{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["interesse legale senza anatocis","interesse legale con anatocismo"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"interesse legale senza anatocis","index":0,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":false,"merged":[[35,0,35,5],[2,0,4,1],[34,0,34,3],[4,2,4,4],[0,0,0,6],[1,0,1,6],[2,5,4,6]]}
["CALCOLO INTERESSI E MONTANTE"]
["Inserire i dati solo nelle celle bianche. Non modificare le celle gialle o verdi.\nL'anno viene assunto sempre di 365 giorni, anche se bisestile. Il calcolo viene effettuato per giorni.\nGli interessi del singolo periodo non vengono capitalizzati alla fine del periodo: non si applica l'anatocismo."]
[null,null,"Decorrenza interessi\n(gg/mm/aa)","Termine calcolo interessi\n(gg/mm/aa)","Importo su cui calcolare gli interessi\n(importo)"]
[]
[null,null,{"$f":"IF(AND($C$4=\"\",$D$4=\"\",$E$4=\"\"),\"\",IF(AND($C$4<>\"\",$D$4<>\"\",$E$4<>\"\"),IF($C$4<$A$7,\"data decorrenza minore data decorrenza minima conosciuta prima colonna\",\"\"),\"data decorrenza o data termine o importo su cui calcolare gli interessi non comunicato\"))","v":""}]
["Decorrenza\n(gg.mm.aa)","Tasso %\n(tasso)","Decorrenza interessi","Termine calcolo interessi","Periodo\n(giorni)","Interessi\n(=importo*tasso/100/365*giorni)","Montante\n(=importo+\ninteressi)"]
["1990-01-01",5,{"$f":"IF(OR(MID(C6,1,10)=\"Decorrenza\",C6=0),IF(AND($C$4<$A8,$C$4>=$A7),$C$4,0),IF($D$4<$A7,0,$A7))","v":"00:00:00"},{"$f":"IF($C7<>0,IF($A8<>\"TOTALI\",IF($D$4<$A8,$D$4,$A8-1),$D$4),0)","v":"00:00:00"},{"$f":"IF(OR($C7<>0,$D7<>0),IF(YEAR($C7)=YEAR($D7),$D7-$C7+1,DATE(YEAR($C7),12,31)-$C7+1+$D7-DATE(YEAR($D7),1,1)+1+365*(YEAR($D7)-YEAR($C7)-1)),0)","v":0},{"$f":"IF($E7<>0,$E$4*$B7/100/365*$E7,0)","v":0},{"$f":"$E$4+SUM($F$7:$F7)","v":0}]
["1990-12-16",10,{"$f":"IF(OR(MID(C7,1,10)=\"Decorrenza\",C7=0),IF(AND($C$4<$A9,$C$4>=$A8),$C$4,0),IF($D$4<$A8,0,$A8))","v":"00:00:00"},{"$f":"IF($C8<>0,IF($A9<>\"TOTALI\",IF($D$4<$A9,$D$4,$A9-1),$D$4),0)","v":"00:00:00"},0,0,{"$f":"$E$4+SUM($F$7:$F8)","v":0}]
["1991-01-01",10,"00:00:00","00:00:00",0,0,{"$f":"$E$4+SUM($F$7:$F9)","v":0}]
["1992-01-01",10,"00:00:00","00:00:00",0,0,{"$f":"$E$4+SUM($F$7:$F10)","v":0}]
["1993-01-01",10,"00:00:00","00:00:00",0,0,{"$f":"$E$4+SUM($F$7:$F11)","v":0}]
["1994-01-01",10,"00:00:00","00:00:00",0,0,{"$f":"$E$4+SUM($F$7:$F12)","v":0}]
["1995-01-01",10,"00:00:00","00:00:00",0,0,{"$f":"$E$4+SUM($F$7:$F13)","v":0}]
["1996-01-01",10,"00:00:00","00:00:00",0,0,{"$f":"$E$4+SUM($F$7:$F14)","v":0}]
["1997-01-01",5,"00:00:00","00:00:00",0,0,{"$f":"$E$4+SUM($F$7:$F15)","v":0}]
["1998-01-01",5,"00:00:00","00:00:00",0,0,{"$f":"$E$4+SUM($F$7:$F16)","v":0}]
["1999-01-01",2.5,"00:00:00","00:00:00",0,0,{"$f":"$E$4+SUM($F$7:$F17)","v":0}]
["2000-01-01",2.5,"00:00:00","00:00:00",0,0,{"$f":"$E$4+SUM($F$7:$F18)","v":0}]
["2001-01-01",3.5,"00:00:00","00:00:00",0,0,{"$f":"$E$4+SUM($F$7:$F19)","v":0}]
["2002-01-01",3,"00:00:00","00:00:00",0,0,{"$f":"$E$4+SUM($F$7:$F20)","v":0}]
["2003-01-01",3,"00:00:00","00:00:00",0,0,{"$f":"$E$4+SUM($F$7:$F21)","v":0}]
["2004-01-01",2.5,"00:00:00","00:00:00",0,0,{"$f":"$E$4+SUM($F$7:$F22)","v":0}]
["2005-01-01",2.5,"00:00:00","00:00:00",0,0,{"$f":"$E$4+SUM($F$7:$F23)","v":0}]
["2006-01-01",2.5,"00:00:00","00:00:00",0,0,{"$f":"$E$4+SUM($F$7:$F24)","v":0}]
["2007-01-01",2.5,"00:00:00","00:00:00",0,0,{"$f":"$E$4+SUM($F$7:$F25)","v":0},{"$f":"SUM(E22:E25)","v":0},{"$f":"SUM(F22:F25)","v":0}]
["2008-01-01",3,"00:00:00","00:00:00",0,0,{"$f":"$E$4+SUM($F$7:$F26)","v":0}]
["2009-01-01",3,"00:00:00","00:00:00",0,0,{"$f":"$E$4+SUM($F$7:$F27)","v":0},null,null,{"$f":"SUM(F26:F27)","v":0}]
["2010-01-01",1,"00:00:00","00:00:00",0,0,{"$f":"$E$4+SUM($F$7:$F28)","v":0}]
["2011-01-01",1.5,"00:00:00","00:00:00",0,0,{"$f":"$E$4+SUM($F$7:$F29)","v":0}]
["2012-01-01",2.5,"00:00:00","00:00:00",0,0,{"$f":"$E$4+SUM($F$7:$F30)","v":0}]
["2013-01-01",2.5,"00:00:00","00:00:00",0,0,{"$f":"$E$4+SUM($F$7:$F31)","v":0}]
["2014-01-01",1,"00:00:00","00:00:00",0,0,{"$f":"$E$4+SUM($F$7:$F32)","v":0}]
["2015-01-01",0.5,"00:00:00","00:00:00",0,0,{"$f":"$E$4+SUM($F$7:$F33)","v":0}]
["2016-01-01",0.2,"00:00:00","00:00:00",0,0,{"$f":"$E$4+SUM($F$7:$F34)","v":0}]
["TOTALI",null,null,null,{"$f":"SUM(E$7:E34)","v":0},{"$f":"SUM(F$7:F34)","v":0},{"$f":"$E$4+SUM($F$7:$F34)","v":0}]
["L'interesse relativo ad ogni giorno successivo alla data di \"Termine calcolo interessi\" è pari a:",null,null,null,null,null,{"$f":"IF(F35<>0,$E$4*INDEX($B$7:$B$101,MATCH($D$4,$A$7:$A$101,1))/100/365,0)","v":0}]

{"sheet":"interesse legale con anatocismo","index":1,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[2,0,4,1],[34,0,34,4],[4,2,4,4],[0,0,0,5],[1,0,1,5],[2,5,4,5]]}
["CALCOLO MONTANTE"]
["Inserire i dati solo nelle celle bianche. Non modificare le celle gialle o verdi.\nL'anno viene assunto sempre di 365 giorni, anche se bisestile. Il calcolo viene effettuato per giorni.\nGli interessi del singolo periodo vengono capitalizzati alla fine del periodo: si applica l'anatocismo."]
[null,null,"Decorrenza interessi\n(gg/mm/aa)","Termine calcolo interessi\n(gg/mm/aa)","Importo su cui calcolare gli interessi\n(importo)"]
[]
[null,null,{"$f":"IF(AND($C$4=\"\",$D$4=\"\",$E$4=\"\"),\"\",IF(AND($C$4<>\"\",$D$4<>\"\",$E$4<>\"\"),IF($C$4<$A$7,\"data decorrenza minore data decorrenza minima conosciuta prima colonna\",\"\"),\"data decorrenza o data termine o importo su cui calcolare gli interessi non comunicato\"))","v":""}]
["Decorrenza\n(gg.mm.aa)","Tasso %\n(tasso)","Decorrenza interessi","Termine calcolo interessi","Periodo\n(giorni)","Montante\n(=importo per.prec+importo per.prec.*tasso/100/365*giorni)"]
["1990-01-01",5,{"$f":"IF(OR(MID(C6,1,10)=\"Decorrenza\",C6=0),IF(MID($A8,1,8)<>\"MONTANTE\",IF(AND($C$4<$A8,$C$4>=$A7),$C$4,0),IF($C$4>=$A7,$C$4,0)),IF($D$4<$A7,0,$A7))","v":"00:00:00"},{"$f":"IF($C7<>0,IF(MID($A8,1,8)<>\"MONTANTE\",IF($D$4<$A8,$D$4,$A8-1),$D$4),0)","v":"00:00:00"},{"$f":"IF(OR($C7<>0,$D7<>0),IF(YEAR($C7)=YEAR($D7),$D7-$C7+1,DATE(YEAR($C7),12,31)-$C7+1+$D7-DATE(YEAR($D7),1,1)+1+365*(YEAR($D7)-YEAR($C7)-1)),0)","v":0},{"$f":"IF($E7<>0,IF(OR(MID($C6,1,10)=\"Decorrenza\",F6=0),$E$4+$E$4*$B7/100/365*$E7,F6+F6*$B7/100/365*$E7),0)","v":0}]
["1990-12-16",10,{"$f":"IF(OR(MID(C7,1,10)=\"Decorrenza\",C7=0),IF(MID($A9,1,8)<>\"MONTANTE\",IF(AND($C$4<$A9,$C$4>=$A8),$C$4,0),IF($C$4>=$A8,$C$4,0)),IF($D$4<$A8,0,$A8))","v":"00:00:00"},{"$f":"IF($C8<>0,IF(MID($A9,1,8)<>\"MONTANTE\",IF($D$4<$A9,$D$4,$A9-1),$D$4),0)","v":"00:00:00"},0,{"$f":"IF($E8<>0,IF(OR(MID($C7,1,10)=\"Decorrenza\",F7=0),$E$4+$E$4*$B8/100/365*$E8,F7+F7*$B8/100/365*$E8),0)","v":0}]
["1991-01-01",10,"00:00:00","00:00:00",0,0]
["1992-01-01",10,"00:00:00","00:00:00",0,0]
["1993-01-01",10,"00:00:00","00:00:00",0,0]
["1994-01-01",10,"00:00:00","00:00:00",0,0]
["1995-01-01",10,"00:00:00","00:00:00",0,0]
["1996-01-01",10,"00:00:00","00:00:00",0,0]
["1997-01-01",5,"00:00:00","00:00:00",0,0]
["1998-01-01",5,"00:00:00","00:00:00",0,0]
["1999-01-01",2.5,"00:00:00","00:00:00",0,0]
["2000-01-01",2.5,"00:00:00","00:00:00",0,0]
["2001-01-01",3.5,"00:00:00","00:00:00",0,0]
["2002-01-01",3,"00:00:00","00:00:00",0,0]
["2003-01-01",3,"00:00:00","00:00:00",0,0]
["2004-01-01",2.5,"00:00:00","00:00:00",0,0]
["2005-01-01",2.5,"00:00:00","00:00:00",0,0]
["2006-01-01",2.5,"00:00:00","00:00:00",0,0]
["2007-01-01",2.5,"00:00:00","00:00:00",0,0]
["2008-01-01",3,"00:00:00","00:00:00",0,0]
["2009-01-01",3,"00:00:00","00:00:00",0,0]
["2010-01-01",1,"00:00:00","00:00:00",0,0]
["2011-01-01",1.5,"00:00:00","00:00:00",0,0]
["2012-01-01",2.5,"00:00:00","00:00:00",0,0]
["2013-01-01",2.5,"00:00:00","00:00:00",0,0]
["2014-01-01",1,"00:00:00","00:00:00",0,0]
["2015-01-01",0.5,"00:00:00","00:00:00",0,0]
["2016-01-01",0.2,"00:00:00","00:00:00",0,0]
["MONTANTE ALLA FINE DEL PERIODO:",null,null,null,null,{"$f":"F34","v":0}]