{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Intero Piano"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Intero Piano","index":0,"n_rows":56,"n_cols":15,"rows_kept":56,"cut":false,"hidden":false,"merged":[[55,2,55,3],[2,6,2,7],[3,6,3,7],[2,4,5,4],[10,0,10,4],[9,6,12,7],[0,0,0,7],[3,11,3,14],[12,1,13,1],[12,0,13,0],[12,2,12,3],[12,4,13,4],[9,0,9,4],[11,0,11,4]]}
["L.R. 80/82 - calcola l'Equivalente Sovvenzione Lorda (ESL)"]
[]
["Importo del mutuo",null,null,null,"Metodo di calcolo della rata di ammortamento 0= rata costantre 1= quota capitale costante",null,"Riduzione periodale (0= matem; 1= finanz)"]
["Tasso teorico di mercato annuo",null,null,null,null,null,"del tasso:",null,null,null,null,"Tasso di interesse periodale del tasso"]
["Tasso a carico annuo",null,null,null,null,null,"Teorico di mercato",0,null,null,null,"Teorico di mercato","A carico","Di Attualizzazione","Di Contribuzione"]
["Tasso di attualizz. Annuo (+ margine)",null,null,null,null,null,"A carico annuo",0,null,null,null,{"$f":"IF(($H5=0),($C4/(12/$C$7)),((((1+$C4/100)^(1/(12/$C$7)))-1)*100))","v":0},{"$f":"IF(($H6=0),($C5/(12/$C$7)),((((1+$C5/100)^(1/(12/$C$7)))-1)*100))","v":0},{"$f":"IF(($H7=0),($C6/(12/$C$7)),((((1+$C6/100)^(1/(12/$C$7)))-1)*100))","v":0},{"$f":"L6-M6","v":0}]
["Mesi in una rata",null,6,null,1,null,"Di Attualizzazione",0]
["Durata totale in Mesi (max. 240)"]
[]
[{"$f":"CONCATENATE(\"Piano di ammortamento al Tasso teorico di mercato annuo del \",C4,\"%,\")","v":"Piano di ammortamento al Tasso teorico di mercato annuo del %,"},null,null,null,null,null,{"$f":"CONCATENATE(\"Contributo in conto interessi per singola rata di ammortamento, pari al \",(C4-C5),\"%, a valore:\")","v":"Contributo in conto interessi per singola rata di ammortamento, pari al 0%, a valore:"},null,null,null,null,"Frazionabilità della"]
[{"$f":"CONCATENATE(\"sviluppato a \",IF(E7=0,\"Rata Costante,\",\"Quota Capitale Costante,\"),\" per l'importo di euro\")","v":"sviluppato a Quota Capitale Costante, per l'importo di euro"},null,null,null,null,null,null,null,null,null,null,"durata ( 0 = SI )"]
[{"$f":"C3","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF((((C8/C7)-TRUNC((C8/C7),0))<>0),1,0)","v":0}]
["Rata numero","Importo Rata","Quota:",null,"Debito residuo"]
[null,null,"Interessi","Capitale",null,null,"Pieno","Attualizzato",null,null,null,"Durata rata"]
[{"$f":"IF(L24=0,1,0)","v":0},{"$f":"IF(A15<>0,IF(($E$7=0),ROUND(($C$3/((1-((1+$L$6/100)^(-($C$8/$C$7))))/($L$6/100))),2),(C15+D15)),0)","v":0},{"$f":"IF(A15<>0,ROUND(($L$6/100*C3),2),0)","v":0},{"$f":"IF(A15<>0,IF((E7=0),(B15-C15),($C$3/($C$8/$C$7))),0)","v":0},{"$f":"IF(A15<>0,(C3-D15),0)","v":0},null,{"$f":"IF(A15<>0,ROUND(($O$6/100*C3),2),0)","v":0},{"$f":"IF(A15<>0,ROUND((G15/((1+$N$6/100)^(A15))),2),0)","v":0},null,null,null,"entro i limiti ( 0 = SI )"]
[{"$f":"IF(AND(((A15+1)<=($C$8/$C$7)),(A15<>0)),(A15+1),0)","v":0},{"$f":"IF(A16<>0,IF(($E$7=0),ROUND(($C$3/((1-((1+$L$6/100)^(-($C$8/$C$7))))/($L$6/100))),2),(C16+D16)),0)","v":0},{"$f":"IF(A16<>0,ROUND(($L$6/100*E15),2),0)","v":0},{"$f":"IF(A16<>0,IF(($E$7=0),(B16-C16),($C$3/($C$8/$C$7))),0)","v":0},{"$f":"IF(A16<>0,E15-D16,0)","v":0},null,{"$f":"IF(A16<>0,ROUND(($O$6/100*E15),2),0)","v":0},{"$f":"IF(A16<>0,ROUND((G16/((1+$N$6/100)^(A16))),2),0)","v":0},null,null,null,{"$f":"IF(OR(C7<1,C7>12),1,0)","v":0}]
[0,0,{"$f":"IF(A17<>0,ROUND(($L$6/100*E16),2),0)","v":0},{"$f":"IF(A17<>0,IF(($E$7=0),(B17-C17),($C$3/($C$8/$C$7))),0)","v":0},{"$f":"IF(A17<>0,E16-D17,0)","v":0},null,{"$f":"IF(A17<>0,ROUND(($O$6/100*E16),2),0)","v":0},0]
[0,0,0,0,0,null,0,0,null,null,null,"Durata mutuo"]
[0,0,0,0,0,null,0,0,null,null,null,"entro i limiti ( 0 = SI )"]
[0,0,0,0,0,null,0,0,null,null,null,{"$f":"IF(OR(C8<C7,C8>240),1,0)","v":1}]
[0,0,0,0,0,null,0,0]
[0,0,0,0,0,null,0,0,null,null,null,"Congruenza"]
[0,0,0,0,0,null,0,0,null,null,null,"Totale ( 0 = SI )"]
[0,0,0,0,0,null,0,0,null,null,null,{"$f":"IF((L12+L16+L20)=0,0,1)","v":1}]
[0,0,0,0,0,null,0,0]
[0,0,0,0,0,null,0,0]
[0,0,0,0,0,null,0,0]
[0,0,0,0,0,null,0,0]
[0,0,0,0,0,null,0,0]
[0,0,0,0,0,null,0,0]
[0,0,0,0,0,null,0,0]
[0,0,0,0,0,null,0,0]
[0,0,0,0,0,null,0,0]
[0,0,0,0,{"$f":"IF(A34<>0,E33-D34,0)","v":0},null,0,0]
[0,{"$f":"IF(A35<>0,IF(($E$7=0),ROUND(($C$3/((1-((1+$L$6/100)^(-($C$8/$C$7))))/($L$6/100))),2),(C35+D35)),0)","v":0},{"$f":"IF(A35<>0,ROUND(($L$6/100*E34),2),0)","v":0},{"$f":"IF(A35<>0,IF(($E$7=0),(B35-C35),($C$3/($C$8/$C$7))),0)","v":0},{"$f":"IF(A35<>0,E34-D35,0)","v":0},null,{"$f":"IF(A35<>0,ROUND(($O$6/100*E34),2),0)","v":0},{"$f":"IF(A35<>0,ROUND((G35/((1+$N$6/100)^(A35))),2),0)","v":0}]
[0,0,0,0,0,null,0,0]
[0,0,0,0,0,null,0,0]
[0,0,0,0,0,null,0,0]
[0,0,0,0,0,null,0,0]
[0,0,0,0,0,null,0,0]
[0,0,0,0,0,null,0,0]
[0,0,0,0,0,null,0,0]
[0,0,0,0,0,null,0,0]
[{"$f":"IF(AND(((A43+1)<=($C$8/$C$7)),(A43<>0)),(A43+1),0)","v":0},{"$f":"IF(A44<>0,IF(($E$7=0),ROUND(($C$3/((1-((1+$L$6/100)^(-($C$8/$C$7))))/($L$6/100))),2),(C44+D44)),0)","v":0},{"$f":"IF(A44<>0,ROUND(($L$6/100*E43),2),0)","v":0},{"$f":"IF(A44<>0,IF(($E$7=0),(B44-C44),($C$3/($C$8/$C$7))),0)","v":0},{"$f":"IF(A44<>0,E43-D44,0)","v":0},null,{"$f":"IF(A44<>0,ROUND(($O$6/100*E43),2),0)","v":0},{"$f":"IF(A44<>0,ROUND((G44/((1+$N$6/100)^(A44))),2),0)","v":0}]
[{"$f":"IF(AND(((A44+1)<=($C$8/$C$7)),(A44<>0)),(A44+1),0)","v":0},{"$f":"IF(A45<>0,IF(($E$7=0),ROUND(($C$3/((1-((1+$L$6/100)^(-($C$8/$C$7))))/($L$6/100))),2),(C45+D45)),0)","v":0},{"$f":"IF(A45<>0,ROUND(($L$6/100*E44),2),0)","v":0},{"$f":"IF(A45<>0,IF(($E$7=0),(B45-C45),($C$3/($C$8/$C$7))),0)","v":0},{"$f":"IF(A45<>0,E44-D45,0)","v":0},null,{"$f":"IF(A45<>0,ROUND(($O$6/100*E44),2),0)","v":0},{"$f":"IF(A45<>0,ROUND((G45/((1+$N$6/100)^(A45))),2),0)","v":0}]
[0,0,0,0,0,null,0,0]
[0,0,0,0,0,null,0,0]
[0,0,0,0,0,null,0,0]
[0,0,0,0,0,null,0,0]
[0,0,0,0,0,null,0,0]
[0,0,0,0,0,null,0,0]
[0,0,0,0,0,null,0,0]
[0,0,0,0,0,null,0,0]
[0,0,0,0,0,null,0,0]
[null,null,{"$f":"SUM(C15:C54)","v":0},{"$f":"SUM(D15:D54)","v":0},null,null,{"$f":"SUM(G15:G54)","v":0},{"$f":"SUM(H15:H54)","v":0}]
[null,null,{"$f":"C55+D55","v":0}]