{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Modulo1","aliquota","libprof","cococo","MENU","sanzioni aziende acconti","sanzioni autonomi"," sanzioniCDCM","sanzioni agricoli","sanzfallimenti","tassi","scadenze","help","calcolo interessi legali","sanzaziende","Domestici"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":185,"comments":5,"pivot_tables":0},"unopened":[{"sheet":"Modulo1","index":0,"reason":"part_missing"}],"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":"aliquota","index":1,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["anno","non assicurato","già assicurato","titolare pensione","professionista"]
[]
[2000,0.13,0.1,0.1,0.13]
[2001,0.13,0.1,0.1,0.13]
[2002,0.14000000000000001,0.1,0.1,0.14000000000000001]
[2003,0.14000000000000001,0.1,0.125,0.14000000000000001]
[2004,0.17799999999999999,0.1,0.15,0.17799999999999999]
[2005,0.18,0.1,0.15,0.18]
[2006,0.182,0.1,0.15,0.182]
[2007,0.23499999999999999,0.16,0.16,0.23499999999999999]
[2008,0.2472,0.17,0.17,0.2472]
[2009,0.25719999999999998,0.17,0.17,0.25719999999999998]
[2010,0.26719999999999999,0.17,0.17,0.26719999999999999]
[2011,0.26719999999999999,0.17,0.17,0.26719999999999999]
[2012,0.2772,0.18,0.18,0.2772]
[2013,0.2772,0.2,0.2,0.2772]
[2014,0.28720000000000001,0.22,0.22,0.2772]
[2015,0.30719999999999997,0.23499999999999999,0.23499999999999999,0.2772]
[2016]
[2017]
[2018]
[2019]
[2020]

{"sheet":"libprof","index":2,"n_rows":31,"n_cols":28,"rows_kept":31,"cut":false,"hidden":false,"merged":[[7,8,7,10]]}
[]
[]
[]
[null,null,null,null,null,"CALCOLO CONTRIBUTI E SANZIONI LIBERI PROFESSIONISTI"]
[]
[]
[]
[null,null,null,null,null,null,"Professionista:",null,"Tizio Alessandro"]
[]
[null,null,null,null,"data calcolo:",null,null,null,null,null,null,null,null,null,"int.mora","tasso morosità","tasso/giorni"]
[null,null,null,null,"2015-12-20",null,"anno",2014,null,null,null,null,"data verbale",{"$f":"E11","v":42358},{"$f":"VLOOKUP($E$11,tassi,5)","v":4.8800000000000003E-2},{"$f":"VLOOKUP($E$11,tassi,4)","v":5.5500000000000001E-2},{"$f":"$P$11/365","v":1.5205479452054795E-4},null,null,null,null,null,2000,0.14000000000000001,"gennaio",1,{"$f":"IF(C16=1,VLOOKUP($H$11,aliquota!A1:E30,5),IF(C16=2,VLOOKUP($H$11,aliquota!A1:E30,3),IF(C16=3,VLOOKUP($H$11,aliquota!A1:E30,4),\"\")))","v":0.2772},{"$f":"AA11","v":0.2772}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2001,0.14000000000000001,"febbraio",2,{"$f":"IF(C17=1,VLOOKUP($H$11,aliquota!A1:E31,5),IF(C17=2,VLOOKUP($H$11,aliquota!A1:E31,3),IF(C17=3,VLOOKUP($H$11,aliquota!A1:E31,4),\"\")))","v":0.2772},{"$f":"AA12","v":0.2772}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2002,0.17799999999999999,"marzo",3]
[null,"E/M","tipo","scadenze","imp.le compenso","aliquota %","contributo dovuto","data versamento","tasso % ","sanzione","interessi mora","totale dovuto",null,null,"giorni tot.","giorniXint.","sanzioni evasione","interessi evasione","giorni x 40%","sanzioni morosità","giorniXint.","interessi morosità",2003,0.18,"aprile",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2004,0.182,"maggio",5]
[null,"E",1,"saldo a.p. e 1° acc.",10000,{"$f":"AB11","v":0.2772},{"$f":"IF(E16>0,ROUND((E16*F16),),\"\")","v":2772},{"$f":"IF(E16>0,DATE($H$11+1,6,20),\"\")","v":"2015-06-20"},{"$f":"IF(B16=\"E\",\"30%\",$P$11)","v":"30%"},{"$f":"IF(E16>0,IF(B16=\"E\",ROUND(Q16,),ROUND(T16,)),\"\")","v":417},{"$f":"IF(E16>0,IF(B16=\"E\",ROUND(R16,),ROUND(V16,)),\"\")","v":0},{"$f":"IF(E16>0,(G16+J16+K16),\"\")","v":3189},null,{"$f":"H16","v":42175},{"$f":"$N$11-H16","v":183},{"$f":"IF(O16>730,O16-730,0)","v":0},{"$f":"IF(E16<=0,\"\",IF(G16*O16*(I16/365)>0.6*G16,0.6*G16,G16*O16*(I16/365)))","v":416.93917808219175},{"$f":"IF(P16>0,G16*$O$11/365*P16,0)","v":0},{"$f":"40/$Q$11/100","v":2630.6306306306305},{"$f":"IF(E16<=0,\"\",IF(G16*O16*(I16/365)>0.4*G16,0.4*G16,G16*O16*(I16/365)))","v":416.93917808219175},{"$f":"IF(O16<S16,0,O16-S16)","v":0},{"$f":"IF(U16>0,G16*$O$11/365*U16,0)","v":0},2005,0.23499999999999999,"giugno",6]
[null,"e",1,"2° acconto",20000,{"$f":"AB12","v":0.2772},{"$f":"IF(E17>0,ROUND((E17*F17),),\"\")","v":5544},{"$f":"IF(E17>0,DATE($H$11+1,11,30),\"\")","v":"2015-11-30"},{"$f":"IF(B17=\"E\",\"30%\",$P$11)","v":"30%"},{"$f":"IF(E17>0,IF(B17=\"E\",ROUND(Q17,),ROUND(T17,)),\"\")","v":91},{"$f":"IF(E17>0,IF(B17=\"E\",ROUND(R17,),ROUND(V17,)),\"\")","v":0},{"$f":"IF(E17>0,(G17+J17+K17),\"\")","v":5635},null,{"$f":"H17","v":42338},{"$f":"$N$11-H17","v":20},{"$f":"IF(O17>730,O17-730,0)","v":0},{"$f":"IF(E17<=0,\"\",IF(G17*O17*(I17/365)>0.6*G17,0.6*G17,G17*O17*(I17/365)))","v":91.134246575342459},{"$f":"IF(P17>0,G17*$O$11/365*P17,0)","v":0},{"$f":"40/$Q$11/100","v":2630.6306306306305},{"$f":"IF(E17<=0,\"\",IF(G17*O17*(I17/365)>0.4*G17,0.4*G17,G17*O17*(I17/365)))","v":91.134246575342459},{"$f":"IF(O17<S17,0,O17-S17)","v":0},{"$f":"IF(U17>0,G17*$O$11/365*U17,0)","v":0},2006,0,"luglio",7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2007]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2008]
[null,null,null,"TOTALI",{"$f":"SUM(E16:E19)","v":30000},null,{"$f":"SUM(G16:G19)","v":8316},null,null,{"$f":"SUM(J16:J19)","v":508},{"$f":"SUM(K16:K19)","v":0},{"$f":"SUM(L16:L17)","v":8824},null,null,null,null,null,null,null,null,null,null,2009]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2010]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2011]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2012]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2013]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2017]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020]

{"sheet":"cococo","index":3,"n_rows":30,"n_cols":28,"rows_kept":30,"cut":false,"hidden":false,"merged":[[11,15,11,17],[11,18,11,21]]}
[]
[]
[null,null,null,null,null,"CALCOLO CONTRIBUTI E SANZIONI PARASUBORDINATI"]
[]
[null,null,null,null,null,null,"AZIENDA:",null,"Prova"]
[]
[null,null,null,null,null,null,"Collaboratore:",null,"Francesco Caio",null,null,null,null,null,null,"tasso evasione"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.3]
[null,null,null,null,"data calcolo:",null,null,null,null,null,null,null,null,null,null,"tasso morosità","tasso/giorni"]
[null,null,null,null,"2015-12-04",null,"anno",2014,null,null,null,null,"data verbale",{"$f":"E10","v":42342},{"$f":"VLOOKUP($E$10,tassi,5)","v":4.8800000000000003E-2},{"$f":"VLOOKUP($E$10,tassi,4)","v":5.5500000000000001E-2},{"$f":"$P$10/365","v":1.5205479452054795E-4},null,null,null,null,null,2000,0.14000000000000001,"gennaio",1,{"$f":"IF(C15=1,VLOOKUP($H$10,aliquota!$A$1:$E$30,2),IF(C15=2,VLOOKUP($H$10,aliquota!$A$1:$E$30,3),IF(C15=3,VLOOKUP($H$10,aliquota!$A$1:$E$30,4),\"\")))","v":0.28720000000000001},{"$f":"AA10","v":0.28720000000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2001,0.14000000000000001,"febbraio",2,{"$f":"IF(C16=1,VLOOKUP($H$10,aliquota!$A$1:$E$30,2),IF(C16=2,VLOOKUP($H$10,aliquota!$A$1:$E$30,3),IF(C16=3,VLOOKUP($H$10,aliquota!$A$1:$E$30,4),\"\")))","v":0.28720000000000001},0.28720000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EVASIONE",null,null,"MOROSITA'",null,null,null,2002,0.17799999999999999,"marzo",3,{"$f":"IF(C17=1,VLOOKUP($H$10,aliquota!$A$1:$E$30,2),IF(C17=2,VLOOKUP($H$10,aliquota!$A$1:$E$30,3),IF(C17=3,VLOOKUP($H$10,aliquota!$A$1:$E$30,4),\"\")))","v":0.28720000000000001},0.28720000000000001]
[null,"E/M","tipo","mese","imp.le compenso","aliquota %","contributo dovuto","data versamento","tasso % evasione","sanzione","interessi mora","totale dovuto",null,null,"giorni tot.","giorniXint.","sanzioni","interessi","giorni x 40%","sanzioni morosità","giorniXint.","interessi morosità",2003,0.18,"aprile",4,{"$f":"IF(C18=1,VLOOKUP($H$10,aliquota!$A$1:$E$30,2),IF(C18=2,VLOOKUP($H$10,aliquota!$A$1:$E$30,3),IF(C18=3,VLOOKUP($H$10,aliquota!$A$1:$E$30,4),\"\")))","v":0.28720000000000001},0.28720000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2004,0.182,"maggio",5,{"$f":"IF(C19=1,VLOOKUP($H$10,aliquota!$A$1:$E$30,2),IF(C19=2,VLOOKUP($H$10,aliquota!$A$1:$E$30,3),IF(C19=3,VLOOKUP($H$10,aliquota!$A$1:$E$30,4),\"\")))","v":0.28720000000000001},0.28720000000000001]
[null,"M",1,1,2100,{"$f":"AB10","v":0.28720000000000001},{"$f":"IF(E15>0,ROUND((E15*F15),),\"\")","v":603},{"$f":"IF(E15>0,DATE($H$10,D15+1,16),\"\")","v":"2014-02-16"},{"$f":"IF(E15>0,IF(B15=\"E\",\"30%\",$P$10),\"\")","v":5.5500000000000001E-2},{"$f":"IF(E15>0,IF(B15=\"E\",ROUND(Q15,),ROUND(T15,)),\"\")","v":60},{"$f":"IF(E15>0,IF(B15=\"E\",ROUND(R15,),ROUND(V15,)),\"\")","v":0},{"$f":"IF(E15>0,(G15+J15+K15),\"\")","v":663},null,{"$f":"H15","v":41686},{"$f":"$N$10-H15","v":656},{"$f":"IF(O15>730,O15-730,0)","v":0},{"$f":"IF(E15<=0,\"\",IF(G15*O15*($P$8/365)>0.6*G15,0.6*G15,G15*O15*($P$8/365)))","v":325.12438356164381},{"$f":"IF(P15>0,G15*$O$10/365*P15,0)","v":0},{"$f":"40/$Q$10/100","v":2630.6306306306305},{"$f":"IF(E15<=0,\"\",IF(G15*O15*(I15/365)>0.4*G15,0.4*G15,G15*O15*(I15/365)))","v":60.148010958904109},{"$f":"IF(O15<S15,0,O15-S15)","v":0},{"$f":"IF(U15>0,G15*$O$10/365*U15,0)","v":0},2005,0.23499999999999999,"giugno",6,{"$f":"IF(C20=1,VLOOKUP($H$10,aliquota!$A$1:$E$30,2),IF(C20=2,VLOOKUP($H$10,aliquota!$A$1:$E$30,3),IF(C20=3,VLOOKUP($H$10,aliquota!$A$1:$E$30,4),\"\")))","v":0.28720000000000001},0.28720000000000001]
[null,"M",1,2,1550,0.28720000000000001,445,"2014-03-16",{"$f":"IF(E16>0,IF(B16=\"E\",\"30%\",$P$10),\"\")","v":5.5500000000000001E-2},{"$f":"IF(E16>0,IF(B16=\"E\",ROUND(Q16,),ROUND(T16,)),\"\")","v":42},{"$f":"IF(E16>0,IF(B16=\"E\",ROUND(R16,),ROUND(V16,)),\"\")","v":0},487,null,41714,628,0,{"$f":"IF(E16<=0,\"\",IF(G16*O16*($P$8/365)>0.6*G16,0.6*G16,G16*O16*($P$8/365)))","v":229.69315068493148},0,{"$f":"40/$Q$10/100","v":2630.6306306306305},{"$f":"IF(E16<=0,\"\",IF(G16*O16*(I16/365)>0.4*G16,0.4*G16,G16*O16*(I16/365)))","v":42.493232876712327},{"$f":"IF(O16<S16,0,O16-S16)","v":0},{"$f":"IF(U16>0,G16*$O$10/365*U16,0)","v":0},2006,0,"luglio",7,{"$f":"IF(C21=1,VLOOKUP($H$10,aliquota!$A$1:$E$30,2),IF(C21=2,VLOOKUP($H$10,aliquota!$A$1:$E$30,3),IF(C21=3,VLOOKUP($H$10,aliquota!$A$1:$E$30,4),\"\")))","v":0.28720000000000001},0.28720000000000001]
[null,"M",1,3,1300,0.28720000000000001,373,"2014-04-16",5.5500000000000001E-2,34,0,407,null,41745,597,0,183.02547945205478,0,{"$f":"40/$Q$10/100","v":2630.6306306306305},33.859713698630138,{"$f":"IF(O17<S17,0,O17-S17)","v":0},{"$f":"IF(U17>0,G17*$O$10/365*U17,0)","v":0},2007,0,"agosto",8,{"$f":"IF(C22=1,VLOOKUP($H$10,aliquota!$A$1:$E$30,2),IF(C22=2,VLOOKUP($H$10,aliquota!$A$1:$E$30,3),IF(C22=3,VLOOKUP($H$10,aliquota!$A$1:$E$30,4),\"\")))","v":0.28720000000000001},0.28720000000000001]
[null,"M",1,4,900,0.28720000000000001,258,"2014-05-16",5.5500000000000001E-2,22,0,280,null,41775,567,0,120.23506849315068,0,2630.6306306306305,22.243487671232877,0,0,2008,0,"settembre",9,{"$f":"IF(C23=1,VLOOKUP($H$10,aliquota!$A$1:$E$30,2),IF(C23=2,VLOOKUP($H$10,aliquota!$A$1:$E$30,3),IF(C23=3,VLOOKUP($H$10,aliquota!$A$1:$E$30,4),\"\")))","v":0.28720000000000001},0.28720000000000001]
[null,"M",1,5,1000,0.28720000000000001,287,"2014-06-16",5.5500000000000001E-2,23,0,310,null,41806,536,0,126.4372602739726,0,2630.6306306306305,23.390893150684931,0,0,2009,null,"ottobre",10,{"$f":"IF(C24=1,VLOOKUP($H$10,aliquota!$A$1:$E$30,2),IF(C24=2,VLOOKUP($H$10,aliquota!$A$1:$E$30,3),IF(C24=3,VLOOKUP($H$10,aliquota!$A$1:$E$30,4),\"\")))","v":0.28720000000000001},0.28720000000000001]
[null,"m",1,6,1300,0.28720000000000001,373,"2014-07-16",5.5500000000000001E-2,29,0,402,null,41836,506,0,155.12712328767122,0,2630.6306306306305,28.698517808219179,0,0,2010,null,"novembre",11,{"$f":"IF(C25=1,VLOOKUP($H$10,aliquota!$A$1:$E$30,2),IF(C25=2,VLOOKUP($H$10,aliquota!$A$1:$E$30,3),IF(C25=3,VLOOKUP($H$10,aliquota!$A$1:$E$30,4),\"\")))","v":""},{"$f":"IF($H$10=2007,AA20+0.22%,AA20)","v":""}]
[null,"m",1,7,1800,0.28720000000000001,517,"2014-08-16",5.5500000000000001E-2,37,0,554,null,41867,475,0,201.84246575342465,0,2630.6306306306305,37.34085616438356,0,0,2011,null,"dicembre",12,{"$f":"IF(C26=1,VLOOKUP($H$10,aliquota!$A$1:$E$30,2),IF(C26=2,VLOOKUP($H$10,aliquota!$A$1:$E$30,3),IF(C26=3,VLOOKUP($H$10,aliquota!$A$1:$E$30,4),\"\")))","v":""},{"$f":"IF($H$10=2007,AA21+0.22%,AA21)","v":""}]
[null,"m",1,8,1900,0.28720000000000001,546,"2014-09-16",5.5500000000000001E-2,37,0,583,null,41898,444,0,199.252602739726,0,2630.6306306306305,36.861731506849317,0,0,2012]
[null,"m",1,9,1400,0.28720000000000001,402,"2014-10-16",5.5500000000000001E-2,25,0,427,null,41928,414,0,136.79013698630135,0,2630.6306306306305,25.306175342465753,0,0,2013]
[null,"m",1,10,1100,0.28720000000000001,316,"2014-11-16",5.5500000000000001E-2,18,0,334,null,41959,383,0,99.475068493150673,0,2630.6306306306305,18.402887671232879,0,0,2014]
[null,null,null,null,null,"","","","","","","",null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},2630.6306306306305,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},2015]
[null,null,null,null,null,"","","","","","","",null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},2630.6306306306305,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},2016]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2017]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018]
[null,null,null,"TOTALI",{"$f":"SUM(E15:E28)","v":14350},null,{"$f":"SUM(G15:G28)","v":4120},null,null,{"$f":"SUM(J15:J28)","v":327},{"$f":"SUM(K15:K28)","v":0},{"$f":"SUM(L15:L26)","v":4447},null,null,null,null,null,null,null,null,null,null,2019]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020]

{"sheet":"MENU","index":4,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"          CALCOLO SANZIONI L.388/2000"]
[]
[]
[]
[null,null,null,null,null,null,"SANZIONI AZIENDE ",null,null,null,null,null,null,"SANZIONI FALLIMENTI"]
[]
[null,null,null,null,null,null,"SANZIONI AZIENDE CON ACCONTI",null,null,null,null,null,null,"CALCOLO INTERESSI LEGALI"]
[]
[null,null,null,null,null,null,"SANZIONI AUTONOMI",null,null,null,null,null,null,"SANZIONI CO.CO.CO."]
[]
[null,null,null,null,null,null,"SANZIONI AZIENDE AGRICOLE",null,null,null,null,null,null,"SANZIONI LIBERI PROFESSIONISTI"]
[]
[null,null,null,null,null,null,"SANZIONI CD/CM",null,null,null,null,null,null,"ALIQUOTE GEST. SEPARATA"]
[]
[]
[null,null,null,null,null,null,"SANZIONI DOMESTICI"]
[]
[]
[null,null,null,null,null,null,"MODIFICA TASSI",null,null,null,null,null,null,"MODIFICA SCADENZE CD/CM"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"versione:","2015-06-05"]

{"sheet":"sanzioni aziende acconti","index":5,"n_rows":42,"n_cols":55,"rows_kept":42,"cut":false,"hidden":false,"merged":[[6,43,6,45]]}
[]
[null,null,null,null,null,null,"DITTA:","prova"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35450,null,null,null,null,null,null,null,null," ","INTERESSI "," ",null,null,null,null,null,null,null,null,null,"inad :",{"$f":"IF(G12=\"\",\" \",G12)","v":502},null,null,null,"ditta :",{"$f":"H2","v":"prova"},null,null,null,null,null,1995,null,"E"]
[null,null,null,null,null,null,"MATRICOLA",null,"8100000081",null,null,null,null,null,null,null," ","E",null,null,null,null,null,null,null,null,null,null,null,"DI MORA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1996,null,"M"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"data calcolo:",{"$f":"$H$6","v":"2013-10-14"},null,null,null,"matricola :",{"$f":"I4","v":"8100000081"}]
[null,null,null,null,null,null,"DATA ","2013-10-14",null,null,"IMPORTI IN EURO",null,null,null,null,null,{"$f":"H6","v":41561},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($H$6,tassi,5)","v":5.2229999999999999E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1997]
[null,null,null,null,null,null,"TIPO (E/M)",null,"m",null,null,null,null,null,null,"MOROSITA' =1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TIPO EVENTO :",{"$f":"IF($I$7=\"M\",\"MOROSITA'\",\"EVASIONE\")","v":"MOROSITA'"},null,{"$f":"IF($I$4=\"\",\" \",$I$4)","v":"8100000081"},null,null,null,null,null,null,null,null,1998]
[null,null,null,null,null,null,"TASSO CORRENTE.........................",null,null,null,null,null,null,null,null,"EVASIONE=2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1999]
[]
[null,null,null,null,null,null,"INADEMPIENZA",null,null,null,null,null,null,null,null,null,null,null,null,null,"EVASIONE","morosità","MOROSITA'","IVS","IVS","SSN","SSN",null,null,"IVS","SSN","IVS","SSN",null,null,null,null,"N.","PERIODO",null,"IMPORTO","IMPORTO","EVAS.","GG","TASSO","SANZIONI","INTERESSI","SANZIONI","INTERESSI","TOTALE ",null,null,2000]
[null,null,null,null,null,null,"N.","DAL","AL","valuta media","IMPORTO CONTRIBUTI IVS","IMPORTO CONTRIBUTI SSN","TIPO     E/M","TASSO",null,"flag morosità","DATA1","DATA2","MEDIA","GIORNI TOT.","GIORNIxINT.","giorni x 40%","GIORNIxINT.","SANZIONI EVASIONE","SANZIONI MOROSITA'","SANZIONI EVASIONE","SANZIONI MOROSITA'","TASSO","TASSO/GIORNI","INT. EVASIONE","INT.EVASIONE","INT. MOROSITA'","INT. MOROSITA'",null,null,null,null,"inad.","DAL","AL","CONTRIBUTI    IVS al netto degli acconti","CONTRIBUTI   SSN al netto degli acconti","MOR.",null,null," IVS debito residuo","DI MORA IVS debito res."," SSN debito residuo","DI MORA SSN debito res.","SANZIONI debito residuo",null,null,2001]
[null,null,null,null,null,null,502,"2000-02-01","2001-02-12",{"$f":"IF(H12=\"\",\" \",S12)","v":"2000-09-14T12:00:00"},36000,null,"m",{"$f":"IF($M$12=\"\",\" \",IF($M$12=\"M\",VLOOKUP($H$6,tassi,4),VLOOKUP($H$6,tassi,2)))","v":0.06},null,{"$f":"IF(M12=\"M\",1,2)","v":1},{"$f":"IF(H12=0,0,IF(YEAR(H12)<1998,DATE(YEAR(H12),MONTH(H12)+1,20),IF(AND(YEAR(H12)=1998,MONTH(H12)<4),DATE(YEAR(H12),MONTH(H12)+1,20),IF(YEAR(H12)>1998,DATE(YEAR(H12),MONTH(H12)+1,16),DATE(YEAR(H12),MONTH(H12)+1,15)))))","v":"2000-03-16"},{"$f":"IF(I12=0,0,IF(YEAR(I12)<1998,DATE(YEAR(I12),MONTH(I12)+1,20),IF(AND(YEAR(I12)=1998,MONTH(I12)<4),DATE(YEAR(I12),MONTH(I12)+1,20),IF(YEAR(I12)>1998,DATE(YEAR(I12),MONTH(I12)+1,16),DATE(YEAR(I12),MONTH(I12)+1,15)))))","v":"2001-03-16"},{"$f":"AVERAGE(Q12,R12)","v":"2000-09-14T12:00:00"},{"$f":"IF(S12<>0,$Q$6-S12,0)","v":4777.5},{"$f":"IF(T12>730,T12-730,0)","v":4047.5},{"$f":"IF(P12=2,0,40/AC12/100)","v":2433.333333333333},{"$f":"IF(V12=0,0,IF(T12<V12,0,T12-V12))","v":2344.166666666667},{"$f":"IF(T12<=0,0,IF((K12-K35)*T12*AC12>0.6*(K12-K35),0.6*(K12-K35),(K12-K35)*T12*AC12))","v":19800},{"$f":"IF(T12<=0,0,IF((K12-K35)*T12*AC12>0.4*(K12-K35),0.4*(K12-K35),(K12-K35)*T12*AC12))","v":13200},{"$f":"IF(T12<=0,0,IF((L12-L35)*T12*AC12>0.6*(L12-L35),0.6*(L12-L35),(L12-L35)*T12*AC12))","v":0},{"$f":"IF(T12<=0,0,IF((L12-L35)*T12*AC12>0.4*(L12-L35),0.4*(L12-L35),(L12-L35)*T12*AC12))","v":0},{"$f":"N12","v":0.06},{"$f":"AB12/365","v":1.6438356164383562E-4},{"$f":"IF(U12>0,(K12-K35)*$AD$6/365*U12,0)","v":19112.960342465754},{"$f":"IF(U12>0,(L12-L35)*$AD$6/365*U12,0)","v":0},{"$f":"IF(W12>0,(K12-K35)*$AD$6/365*W12,0)","v":11069.540342465756},{"$f":"IF(W12>0,(L12-L35)*$AD$6/365*W12,0)","v":0},null,null,null,null,{"$f":"G12","v":502},{"$f":"IF(H12>0,H12,\"\")","v":"2000-02-01"},{"$f":"IF(I12>0,I12,\"\")","v":"2001-02-12"},{"$f":"IF(K12>0,(K12-K35),0)","v":33000},{"$f":"IF(L12>0,(L12-L35),0)","v":0},{"$f":"M12","v":"m"},{"$f":"IF(S12>0,INT(T12),\"\")","v":4777},{"$f":"IF(N12=\"\",\" \",N12)","v":0.06},{"$f":"IF(P12=1,Y12,X12)","v":13200},{"$f":"IF(P12=1,AF12,AD12)","v":11069.540342465756},{"$f":"IF(P12=1,AA12,Z12)","v":0},{"$f":"IF(P12=1,AG12,AE12)","v":0},{"$f":"AT12+AU12+AV12+AW12","v":24269.540342465756},null,null,2002]
[null,null,null,null,null,null,"ACCONTI",null,null,null,null,null,null,null,null,null,null,null,null,null,"EVASIONE","morosità","MOROSITA'","IVS","IVS","SSN","SSN",null,null,"IVS","SSN","IVS","SSN"]
[null,null,null,null,null,null,"N.",null,null,"DATA VERSAMENTO","IMPORTO CONTRIBUTI IVS","IMPORTO CONTRIBUTI SSN",null,"TASSO",null,null,"DATA INAD.",null,"DATA VERS.","GIORNI TOT.","GIORNIxINT.","giorni x 40%","GIORNIxINT.","SANZIONI EVASIONE","SANZIONI MOROSITA'","SANZIONI EVASIONE","SANZIONI MOROSITA'","TASSO","TASSO/GIORNI","INT. EVASIONE","INT.EVASIONE","INT. MOROSITA'","INT. MOROSITA'",null,null,null,null,"N.","DATA VERS.",null,"IMPORTO CONTRIBUTI    IVS  acconto","IMPORTO CONTRIBUTI  SSN acconto",null,"GG","TASSO","SANZIONI IVS acconti","INTERESSI DI MORA IVS acconti","SANZIONI SSN acconti","INTERESSI DI MORA SSN acconti","TOTALE SANZIONI      acconti"]
[null,null,null,null,null,null,1,{"$f":"IF(J15=\"\",\" \",IF(J15<$J$12,\"data errata\",\" \"))","v":" "},null,"2011-01-13",1000,null,null,{"$f":"IF(J15=\"\",\" \",IF($M$12=\"M\",VLOOKUP(J15,tassi,4),VLOOKUP(J15,tassi,2)))","v":6.5000000000000002E-2},null,{"$f":"IF($M$12=\"M\",1,2)","v":1},{"$f":"$J$12","v":"2000-09-14T12:00:00"},null,{"$f":"IF(J15=\"\",0,J15)","v":"2011-01-13"},{"$f":"IF(S15<>0,S15-Q15,0)","v":3772.5},{"$f":"IF(T15>730,T15-730,0)","v":3042.5},{"$f":"IF(P15=2,0,IF(AC15=0,0,40/AC15/100))","v":2246.1538461538462},{"$f":"IF(V15=0,0,IF(T15<V15,0,T15-V15))","v":1526.3461538461538},{"$f":"IF(T15<=0,\"\",IF(K15*T15*AC15>0.6*K15,0.6*K15,K15*T15*AC15))","v":600},{"$f":"IF(T15<=0,\"\",IF(K15*T15*AC15>0.4*K15,0.4*K15,K15*T15*AC15))","v":400},{"$f":"IF(T15<=0,\"\",IF(L15*T15*AC15>0.6*L15,0.6*L15,L15*T15*AC15))","v":0},{"$f":"IF(T15<=0,\"\",IF(L15*T15*AC15>0.4*L15,0.4*L15,L15*T15*AC15))","v":0},{"$f":"IF(N15=\" \",0,N15)","v":6.5000000000000002E-2},{"$f":"AB15/365","v":1.7808219178082192E-4},{"$f":"IF(U15>0,K15*$AD$6/365*U15,\"\")","v":435.36924657534246},{"$f":"IF(U15>0,L15*$AD$6/365*U15,\"\")","v":0},{"$f":"IF(W15>0,K15*$AD$6/365*W15,\"\")","v":218.41386195995784},{"$f":"IF(L15>0,IF(W15>0,L15*$AD$6/365*W15,\"\"),\"\")","v":""},null,null,null,null,{"$f":"G15","v":1},{"$f":"IF(J15=\"\",\" \",J15)","v":"2011-01-13"},{"$f":"IF(I15>0,I15,\"\")","v":""},{"$f":"IF(K15>0,K15,\"\")","v":1000},{"$f":"IF(L15>0,L15,\"\")","v":""},{"$f":"M15","v":0},{"$f":"IF(S15>0,INT(T15),\"\")","v":3772},{"$f":"IF(N15=\"\",\" \",N15)","v":6.5000000000000002E-2},{"$f":"IF(P15=1,Y15,X15)","v":400},{"$f":"IF(P15=1,AF15,AD15)","v":218.41386195995784},{"$f":"IF(P15=1,AA15,Z15)","v":0},{"$f":"IF(P15=1,AG15,AE15)","v":""},{"$f":"IF(T15>0,SUMIF(AT15:AW15,\"<>\"\"\"),\"\")","v":618.41386195995779},null,null,2003]
[null,null,null,null,null,null,2," ",null,"2012-03-16",2000,null,null,6.5000000000000002E-2,null,1,"2000-09-14T12:00:00",null,"2012-03-16",4200.5,3470.5,2246.1538461538462,1954.3461538461538,1200,800,0,0,6.5000000000000002E-2,1.7808219178082192E-4,993.22857534246577,0,559.31780611169654,{"$f":"IF(L16>0,IF(W16>0,L16*$AD$6/365*W16,\"\"),\"\")","v":""},null,null,null,null,2,"2012-03-16","",2000,"",0,4200,6.5000000000000002E-2,800,559.31780611169654,0,"",1359.3178061116964,null,null,2004]
[null,null,null,null,null,null,3," ",null,null,null,null,null," ",null,1,"2000-09-14T12:00:00",null,"00:00:00",0,0,0,0,"","","","",0,0,"","","","",null,null,null,null,3," ","","","",0,""," ","","","","","",null,null,2005]
[null,null,null,null,null,null,4," ",null,null,null,null,null," ",null,1,"2000-09-14T12:00:00",null,"00:00:00",0,0,0,0,"","","","",0,0,"","","","",null,null,null,null,4," ","","","",0,""," ","","","","","",null,null,2006]
[null,null,null,null,null,null,5," ",null,null,null,null,null," ",null,1,"2000-09-14T12:00:00",null,"00:00:00",0,0,0,0,"","","","",0,0,"","","","",null,null,null,null,5," ","","","",0,""," ","","","","","",null,null,2007]
[null,null,null,null,null,null,6," ",null,null,null,null,null," ",null,1,"2000-09-14T12:00:00",null,"00:00:00",0,0,0,0,"","","","",0,0,"","","","",null,null,null,null,6," ","","","",0,""," ","","","","","",null,null,2008]
[null,null,null,null,null,null,7," ",null,null,null,null,null," ",null,1,"2000-09-14T12:00:00",null,"00:00:00",0,0,0,0,"","","","",0,0,"","","","",null,null,null,null,7," ","","","",0,""," ","","","","","",null,null,2009]
[null,null,null,null,null,null,8," ",null,null,null,null,null," ",null,1,"2000-09-14T12:00:00",null,"00:00:00",0,0,0,0,"","","","",0,0,"","","","",null,null,null,null,8," ","","","",0,""," ","","","","","",null,null,2010]
[null,null,null,null,null,null,9," ",null,null,null,null,null," ",null,1,"2000-09-14T12:00:00",null,"00:00:00",0,0,0,0,"","","","",0,0,"","","","",null,null,null,null,9," ","","","",0,""," ","","","","",""]
[null,null,null,null,null,null,10," ",null,null,null,null,null," ",null,1,"2000-09-14T12:00:00",null,{"$f":"IF(J24=\"\",0,J24)","v":"00:00:00"},{"$f":"IF(S24<>0,S24-Q24,0)","v":0},0,{"$f":"IF(P24=2,0,IF(AC24=0,0,40/AC24/100))","v":0},{"$f":"IF(V24=0,0,IF(T24<V24,0,T24-V24))","v":0},{"$f":"IF(T24<=0,\"\",IF(K24*T24*AC24>0.6*K24,0.6*K24,K24*T24*AC24))","v":""},{"$f":"IF(T24<=0,\"\",IF(K24*T24*AC24>0.4*K24,0.4*K24,K24*T24*AC24))","v":""},{"$f":"IF(T24<=0,\"\",IF(L24*T24*AC24>0.6*L24,0.6*L24,L24*T24*AC24))","v":""},{"$f":"IF(T24<=0,\"\",IF(L24*T24*AC24>0.4*L24,0.4*L24,L24*T24*AC24))","v":""},{"$f":"IF(N24=\" \",0,N24)","v":0},0,{"$f":"IF(U24>0,K24*$AD$6/365*U24,\"\")","v":""},{"$f":"IF(U24>0,L24*$AD$6/365*U24,\"\")","v":""},{"$f":"IF(W24>0,K24*$AD$6/365*W24,\"\")","v":""},"",null,null,null,null,10,{"$f":"IF(J24=\"\",\" \",J24)","v":" "},{"$f":"IF(I24>0,I24,\"\")","v":""},"",{"$f":"IF(L24>0,L24,\"\")","v":""},{"$f":"M24","v":0},{"$f":"IF(S24>0,INT(T24),\"\")","v":""},{"$f":"IF(N24=\"\",\" \",N24)","v":" "},{"$f":"IF(P24=1,Y24,X24)","v":""},{"$f":"IF(P24=1,AF24,AD24)","v":""},{"$f":"IF(P24=1,AA24,Z24)","v":""},{"$f":"IF(P24=1,AG24,AE24)","v":""},""]
[null,null,null,null,null,null,11," ",null,null,null,null,null," ",null,1,"2000-09-14T12:00:00",null,"00:00:00",0,0,0,0,"","","","",0,0,"","","","",null,null,null,null,11," ","","","",0,""," ","","","","",""]
[null,null,null,null,null,null,12," ",null,null,null,null,null," ",null,1,"2000-09-14T12:00:00",null,"00:00:00",0,0,0,0,"","","","",0,0,"","","","",null,null,null,null,12," ","","","",0,""," ","","","","",""]
[null,null,null,null,null,null,13," ",null,null,null,null,null," ",null,1,"2000-09-14T12:00:00",null,"00:00:00",0,0,0,0,"","","","",0,0,"","","","",null,null,null,null,13," ","","","",0,""," ","","","","",""]
[null,null,null,null,null,null,14," ",null,null,null,null,null," ",null,1,"2000-09-14T12:00:00",null,"00:00:00",0,0,0,0,"","","","",0,0,"","","","",null,null,null,null,14," ","","","",0,""," ","","","","",""]
[null,null,null,null,null,null,15," ",null,null,null,null,null," ",null,1,"2000-09-14T12:00:00",null,"00:00:00",0,0,0,0,"","","","",0,0,"","","","",null,null,null,null,15," ","","","",0,""," ","","","","",""]
[null,null,null,null,null,null,16," ",null,null,null,null,null," ",null,1,"2000-09-14T12:00:00",null,"00:00:00",0,0,0,0,"","","","",0,0,"","","","",null,null,null,null,16," ","","","",0,""," ","","","","",""]
[null,null,null,null,null,null,17," ",null,null,null,null,null," ",null,1,"2000-09-14T12:00:00",null,"00:00:00",0,0,0,0,"","","","",0,0,"","","","",null,null,null,null,17," ","","","",0,""," ","","","","",""]
[null,null,null,null,null,null,18," ",null,null,null,null,null," ",null,1,"2000-09-14T12:00:00",null,"00:00:00",0,0,0,0,"","","","",0,0,"","","","",null,null,null,null,18," ","","","",0,""," ","","","","",""]
[null,null,null,null,null,null,19," ",null,null,null,null,null," ",null,1,"2000-09-14T12:00:00",null,"00:00:00",0,0,0,0,"","","","",0,0,"","","","",null,null,null,null,19," ",null,"","",0,""," ","","","","",""]
[null,null,null,null,null,null,20," ",null,null,null,null,null," ",null,1,"2000-09-14T12:00:00",null,"00:00:00",0,0,0,0,"","","","",0,0,"","","","",null,null,null,null,20," ","","","",0,""," ","","","","",""]
[null,null,null,null,null,null,null,"TOTALE ACCONTI",null,null,{"$f":"SUM(K15:K34)","v":3000},{"$f":"SUM(L15:L34)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTALE ACCONTI",null,{"$f":"SUM(AO15:AO34)","v":3000},{"$f":"SUM(AP15:AP34)","v":0},null,null,null,{"$f":"SUM(AT15:AT34)","v":1200},{"$f":"SUM(AU15:AU34)","v":777.73166807165444},{"$f":"SUM(AV15:AV34)","v":0},{"$f":"SUM(AW15:AW34)","v":0},{"$f":"SUMIF(AX15:AX34,\"<>\"\"\")","v":1977.7316680716542}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IVS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IVS",null,"SSN",null,"TOTALE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," A)","CONTRIBUZIONE DOVUTA ...........……….................",null,null,null,null,null,{"$f":"K12","v":36000},null,{"$f":"L12","v":0},null,{"$f":"SUM(AT38:AV38)","v":36000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," B)","ACCONTI VERSATI ……………………………….…….",null,null,null,null,null,{"$f":"K35","v":3000},null,{"$f":"L35","v":0},null,{"$f":"SUM(AT39:AV39)","v":3000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," C)","DEBITO RESIDUO ………………..…………………….",null,null,null,null,null,{"$f":"AT38-AT39","v":33000},null,{"$f":"AV38-AV39","v":0},null,{"$f":"SUM(AT40:AV40)","v":33000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," D)","SANZIONI + INTERESSI",null,null,null,null,null,{"$f":"ROUND(AT12+AU12+AT35+AU35,)","v":26247},null,{"$f":"ROUND(AV12+AV35+AW12+AW35,)","v":0},null,{"$f":"SUM(AT41:AV41)","v":26247}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," TOTALE DEBITO  .............................................",null,null,null,null,null,null,{"$f":"SUM(AT40:AT41)","v":59247},null,{"$f":"SUM(AV40:AV41)","v":0},null,{"$f":"SUM(AT42:AV42)","v":59247}]

{"sheet":"sanzioni autonomi","index":6,"n_rows":27,"n_cols":41,"rows_kept":27,"cut":false,"hidden":false,"merged":[[6,31,6,33]]}
[]
[null,null,null,null,null,"DITTA:","PROVA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35450,null,null,null,null,null,null," ","INTERESSI ",null,null,null,null,null,"ditta :",{"$f":"G2","v":"PROVA"},null,null,"codice individuale :",null,{"$f":"G4","v":"12345678JK"},null,null,1995,null,"E"]
[null,null,null,null,null,"CODICE","12345678JK",null,null,null,null,null,"E"," ",null,null,null,null,null,null,null,null,null,"DI MORA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1996,null,"M"]
[null,null,null,null,null,null,null,null,null,null,null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"data calcolo:",{"$f":"G6","v":"2012-01-10"}]
[null,null,null,null,null,"DATA ","2012-01-10",null,null,null,null,null,null,{"$f":"G6","v":40918},null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($G$6,tassi,5)","v":5.024E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,1997]
[null,null,null,null,null,"TIPO (E/M)",null,null,null,null,null,null,"MOROSITA' =1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TIPO EVENTO :",null,{"$f":"IF(#REF!=\"\",\" \",#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,null,1998]
[null,null,null,null,null,"TASSO CORRENTE.........................",null,null,null,null,null,null,"EVASIONE=2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1999]
[]
[null,null,null,null,null,"trimestre","anno","scadenza","importo contributi","e/m","tasso",null,"M 1",null,null,null,"EVASIONE","morosità","MOROSITA'","evasione","morosità",null,null,"interessi","interessi",null,null,null,"ANNO",null,null,null,null,null,null,null,null,null,2000]
[null,null,null,null,null,null,null,null,"in EURO",null,null,null,"E 2",null,null,null,null,null,null,null,null,null,null,"evasione","morosità",null,null,"TRIM.",{"$f":"G12","v":2011},"IMPORTO","E/M","GIORNI","TASSO","SANZIONI","INTERESSI","TOTALE"]
[null,null,null,null,null,null,2011,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCADENZE",null,null,null,null,null,null,null,null,null,2002]
[null,null,null,null,null,1,{"$f":"IF(H13=\"\",\" \",IF(H13<$H$12,\"data errata\",\" \"))","v":" "},{"$f":"IF($G$12<1991,DATE($G$12,4,25),IF($G$12<1998,DATE($G$12,4,20),DATE($G$12,5,16)))","v":"2011-05-16"},400,"m",{"$f":"IF(I13=\"\",\" \",IF(J13=\"M\",VLOOKUP(G6,tassi,4),VLOOKUP(G6,tassi,2)))","v":6.5000000000000002E-2},null,{"$f":"IF($J$13=\"M\",1,2)","v":1},{"$f":"$G$6","v":"2012-01-10"},{"$f":"IF(H13=\"\",0,H13)","v":"2011-05-16"},{"$f":"IF(O13<>0,N13-O13,0)","v":239},{"$f":"IF(P13>730,P13-730,0)","v":0},{"$f":"IF(M13=2,0,IF(W13=0,0,40/W13/100))","v":2246.1538461538462},{"$f":"IF(R13=0,0,IF(P13<R13,0,P13-R13))","v":0},{"$f":"IF(P13<=0,0,IF(I13*P13*W13>0.6*I13,0.6*I13,I13*P13*W13))","v":17.024657534246575},{"$f":"IF(P13<=0,0,IF(I13*P13*W13>0.4*I13,0.4*I13,I13*P13*W13))","v":17.024657534246575},{"$f":"IF(K13=\" \",0,K13)","v":6.5000000000000002E-2},{"$f":"V13/365","v":1.7808219178082192E-4},{"$f":"IF(Q13>0,I13*$X$6/365*Q13,0)","v":0},{"$f":"IF(S13>0,I13*$X$6/365*S13,0)","v":0},null,null,{"$f":"F13","v":1},{"$f":"IF(H13=\"\",\" \",H13)","v":"2011-05-16"},{"$f":"IF(I13>0,I13,0)","v":400},{"$f":"J13","v":"m"},{"$f":"IF(AD13>0,INT(P13),0)","v":239},{"$f":"IF(K13=\"\",\" \",K13)","v":6.5000000000000002E-2},{"$f":"IF(M13=1,U13,T13)","v":17.024657534246575},{"$f":"IF(M13=1,Y13,X13)","v":0},{"$f":"(AH13+AI13)","v":17.024657534246575},null,null,2003]
[null,null,null,null,null,2,{"$f":"IF(H14=\"\",\" \",IF(H14<$H$12,\"data errata\",\" \"))","v":" "},{"$f":"IF($G$12<1991,DATE($G$12,7,25),IF($G$12<1998,DATE($G$12,8,20),DATE($G$12,8,16)))","v":"2011-08-16"},400,"m",{"$f":"IF(I14=\"\",\" \",IF(J14=\"M\",VLOOKUP(G6,tassi,4),VLOOKUP(G6,tassi,2)))","v":6.5000000000000002E-2},null,{"$f":"IF($J$14=\"M\",1,2)","v":1},"2012-01-10","2011-08-16",147,0,2246.1538461538462,0,10.471232876712328,10.471232876712328,6.5000000000000002E-2,1.7808219178082192E-4,0,0,null,null,{"$f":"F14","v":2},"2011-08-16",400,"m",147,6.5000000000000002E-2,10.471232876712328,0,10.471232876712328,null,null,2004]
[null,null,null,null,null,3,{"$f":"IF(H15=\"\",\" \",IF(H15<$H$12,\"data errata\",\" \"))","v":" "},{"$f":"IF($G$12<1990,DATE($G$12,10,25),IF($G$12<1998,DATE($G$12,11,20),DATE($G$12,11,16)))","v":"2011-11-16"},400,"m",{"$f":"IF(I15=\"\",\" \",IF(J15=\"M\",VLOOKUP(G6,tassi,4),VLOOKUP(G6,tassi,2)))","v":6.5000000000000002E-2},null,{"$f":"IF($J$15=\"M\",1,2)","v":1},"2012-01-10","2011-11-16",55,0,2246.1538461538462,0,3.9178082191780823,3.9178082191780823,6.5000000000000002E-2,1.7808219178082192E-4,0,0,null,null,{"$f":"F15","v":3},"2011-11-16",400,"m",55,6.5000000000000002E-2,3.9178082191780823,0,3.9178082191780823,null,null,2005]
[null,null,null,null,null,4,{"$f":"IF(H16=\"\",\" \",IF(H16<$H$12,\"data errata\",\" \"))","v":" "},{"$f":"IF($G$12<1990,DATE($G$12+1,1,25),IF($G$12<1998,DATE($G$12+1,2,20),DATE($G$12+1,2,16)))","v":"2012-02-16"},400,"m",{"$f":"IF(I16=\"\",\" \",IF(J16=\"M\",VLOOKUP(G6,tassi,4),VLOOKUP(G6,tassi,2)))","v":6.5000000000000002E-2},null,{"$f":"IF($J$16=\"M\",1,2)","v":1},"2012-01-10","2012-02-16",-37,0,2246.1538461538462,0,0,0,6.5000000000000002E-2,1.7808219178082192E-4,0,0,null,null,{"$f":"F16","v":4},"2012-02-16",400,"m",-37,6.5000000000000002E-2,0,0,0,null,null,2006]
[null,null,null,null,null,"%",null,{"$f":"IF($G$12<=1990,DATE($G$12,7,25),IF($G$12=1998,DATE($G$12,6,19),DATE($G$12,6,20)))","v":"2011-06-20"},200,"E",{"$f":"IF(I17=\"\",\" \",IF(J17=\"M\",VLOOKUP(G6,tassi,4),VLOOKUP(G6,tassi,2)))","v":0.3},null,{"$f":"IF($J$17=\"M\",1,2)","v":2},"2012-01-10","2011-06-20",204,0,0,0,33.534246575342465,33.534246575342465,0.3,8.2191780821917802E-4,0,0,null,null,"%","2011-06-20",200,"E",204,0.3,33.534246575342465,0,33.534246575342465]
[null,null,null,null,null,"%",null,{"$f":"IF($G$12<=1990,DATE($G$12,10,25),IF($G$12=1998,DATE($G$12,11,30),DATE($G$12,11,30)))","v":"2011-11-30"},100,"E",{"$f":"IF(I18=\"\",\" \",IF(J18=\"M\",VLOOKUP(G6,tassi,4),VLOOKUP(G6,tassi,2)))","v":0.3},null,{"$f":"IF($J$18=\"M\",1,2)","v":2},"2012-01-10","2011-11-30",41,0,0,0,3.3698630136986298,3.3698630136986298,0.3,8.2191780821917802E-4,0,0,null,null,"%","2011-11-30",100,"E",41,0.3,3.3698630136986298,0,3.3698630136986298]
[null,null,null,null,null,"conguaglio",null,null,null,null,{"$f":"IF(I19=\"\",\" \",IF(J19=\"M\",VLOOKUP(G6,tassi,4),VLOOKUP(G6,tassi,2)))","v":" "},null,{"$f":"IF($J$18=\"M\",1,2)","v":2},"2012-01-10",{"$f":"IF(H19=\"\",0,H19)","v":"00:00:00"},{"$f":"IF(O19<>0,N19-O19,0)","v":0},0,{"$f":"IF(M19=2,0,IF(W19=0,0,40/W19/100))","v":0},{"$f":"IF(R19=0,0,IF(P19<R19,0,P19-R19))","v":0},{"$f":"IF(P19<=0,0,IF(I19*P19*W19>0.6*I19,0.6*I19,I19*P19*W19))","v":0},{"$f":"IF(P19<=0,0,IF(I19*P19*W19>0.4*I19,0.4*I19,I19*P19*W19))","v":0},{"$f":"IF(K19=\" \",0,K19)","v":0},0,{"$f":"IF(Q19>0,I19*$X$6/365*Q19,0)","v":0},{"$f":"IF(S19>0,I19*$X$6/365*S19,0)","v":0},null,null,"cong.",{"$f":"IF(H19=\"\",\" \",H19)","v":" "},{"$f":"IF(I19>0,I19,0)","v":0},{"$f":"J19","v":0},{"$f":"IF(AD19>0,INT(P19),0)","v":0},{"$f":"IF(K19=\"\",\" \",K19)","v":" "},{"$f":"IF(M19=1,U19,T19)","v":0},{"$f":"IF(M19=1,Y19,X19)","v":0},{"$f":"(AH19+AI19)","v":0}]
[null,null,null,null,null,null,"TOTALE ",null,{"$f":"SUM(I13:I18)","v":1900},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTALE",{"$f":"SUM(AD13:AD19)","v":1900},null,null,null,{"$f":"(SUM(AH13:AH19))","v":68.317808219178076},{"$f":"(SUM(AI13:AI19))","v":0},{"$f":"(SUM(AJ13:AJ19))","v":68.317808219178076}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IVS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IN EURO","IN LIRE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," A)","TOTALE CONTRIBUTI",null,null,null,{"$f":"(AD20)","v":1900},{"$f":"ROUND(AH23*1936.27,-3)","v":3679000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," B)","TOTALE SANZIONI",null,null,null,{"$f":"ROUND(AH20,)","v":68},{"$f":"ROUND(AH24*1936.27,-3)","v":132000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," C)","TOTALE INTERESSI DI MORA",null,null,null,{"$f":"ROUND(AI20,)","v":0},{"$f":"ROUND(AH25*1936.27,-3)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," D)","TOTALE SANZIONI + INTERESSI",null,null,null,{"$f":"AH24+AH25","v":68},{"$f":"ROUND(AH26*1936.27,-3)","v":132000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," TOTALE DEBITO  .............................................",null,null,null,null,{"$f":"AH23+AH26","v":1968},{"$f":"ROUND(AH27*1936.27,-3)","v":3811000}]

{"sheet":" sanzioniCDCM","index":7,"n_rows":30,"n_cols":44,"rows_kept":30,"cut":false,"hidden":false,"merged":[[11,34,11,36]]}
[]
[]
[null,null,null,null,null,null,"CALCOLO SANZIONI L.388/2000"]
[]
[]
[]
[null,null,null,null,null,null,"DITTA:","Prova",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CALCOLO SANZIONI L.388/2000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35450,null,null,null,null,null,null," ","INTERESSI ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1995,null,"E"]
[null,null,null,null,null,null,"CODICE","12345678AB",null,null,null,null,null,"E"," ",null,null,null,null,null,null,null,null,null,"DI MORA",null,null,null,null,null,null,null,"ditta :",{"$f":"H7","v":"Prova"},null,null,"codice individuale :",null,{"$f":"H9","v":"12345678AB"},null,null,1996,null,"M"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"M"]
[null,null,null,null,null,null,"DATA ","2015-01-12",null,"CD/CM",null,null,null,null,{"$f":"H11","v":42016},null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($H$11,tassi,5)","v":5.1400000000000001E-2},null,null,null,null,null,null,null,"data calcolo:",{"$f":"H11","v":"2015-01-12"},null,null,null,null,null,null,null,1997]
[null,null,null,null,null,null,"TIPO (E/M)",null,null,null,null,null,null,"MOROSITA' =1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TIPO EVENTO :",null,{"$f":"IF(#REF!=\"\",\" \",#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,null,1998]
[null,null,null,null,null,null,"TASSO CORRENTE.........................",null,null,null,null,null,null,"EVASIONE=2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1999]
[]
[null,null,null,null,null,null,"trimestre","anno","scadenza","importo contributi","e/m","tasso",null,"M 1",null,null,null,"EVASIONE","morosità","MOROSITA'","evasione","morosità",null,null,"interessi","interessi",null,null,null,null,null,"ANNO",null,null,null,null,null,null,null,null,null,2000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"E 2",null,null,null,null,null,null,null,null,null,null,"evasione","morosità",null,null,null,null,"TRIM.",{"$f":"H17","v":2012},"IMPORTO","E/M","GIORNI","TASSO","SANZIONI","INTERESSI","TOTALE"]
[null,null,null,null,null,null,null,2012,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCADENZE",null,null,null,null,null,null,null,null,null,2002]
[null,null,null,null,null,null,1,null,{"$f":"VLOOKUP(H17,scadenze,6)","v":"2012-07-16"},340,"E",{"$f":"IF(J18=\"\",\" \",IF(K18=\"M\",VLOOKUP(H11,tassi,4),VLOOKUP(H11,tassi,2)))","v":0.3},null,{"$f":"IF(K18=\"M\",1,2)","v":2},{"$f":"$H$11","v":"2015-01-12"},{"$f":"IF(I18=\"\",0,I18)","v":"2012-07-16"},{"$f":"IF(P18<>0,O18-P18,0)","v":910},{"$f":"IF(Q18>730,Q18-730,0)","v":180},{"$f":"IF(N18=2,0,IF(X18=0,0,40/X18/100))","v":0},{"$f":"IF(S18=0,0,IF(Q18<S18,0,Q18-S18))","v":0},{"$f":"IF(Q18<=0,0,IF(J18*Q18*X18>0.6*J18,0.6*J18,J18*Q18*X18))","v":204},{"$f":"IF(Q18<=0,0,IF(J18*Q18*X18>0.4*J18,0.4*J18,J18*Q18*X18))","v":136},{"$f":"IF(L18=\" \",0,L18)","v":0.3},{"$f":"W18/365","v":8.2191780821917802E-4},{"$f":"IF(R18>0,J18*$Y$11/365*R18,0)","v":8.6183013698630138},{"$f":"IF(T18>0,J18*$Y$11/365*T18,0)","v":0},null,null,null,null,{"$f":"G18","v":1},{"$f":"IF(I18=\"\",\" \",I18)","v":"2012-07-16"},{"$f":"IF(J18>0,J18,0)","v":340},{"$f":"K18","v":"E"},{"$f":"IF(AG18>0,INT(Q18),0)","v":910},{"$f":"IF(L18=\"\",\" \",L18)","v":0.3},{"$f":"IF(N18=1,V18,U18)","v":204},{"$f":"IF(N18=1,Z18,Y18)","v":8.6183013698630138},{"$f":"ROUND(AK18+AL18,)","v":213},null,null,2003]
[null,null,null,null,null,null,2,null,{"$f":"VLOOKUP(H17,scadenze,7)","v":"2012-09-16"},null,null,{"$f":"IF(J19=\"\",\" \",IF(K19=\"M\",VLOOKUP(H11,tassi,4),VLOOKUP(H11,tassi,2)))","v":" "},null,{"$f":"IF(K19=\"M\",1,2)","v":2},{"$f":"$H$11","v":"2015-01-12"},{"$f":"IF(I19=\"\",0,I19)","v":"2012-09-16"},{"$f":"IF(P19<>0,O19-P19,0)","v":848},{"$f":"IF(Q19>730,Q19-730,0)","v":118},{"$f":"IF(N19=2,0,IF(X19=0,0,40/X19/100))","v":0},{"$f":"IF(S19=0,0,IF(Q19<S19,0,Q19-S19))","v":0},{"$f":"IF(Q19<=0,0,IF(J19*Q19*X19>0.6*J19,0.6*J19,J19*Q19*X19))","v":0},{"$f":"IF(Q19<=0,0,IF(J19*Q19*X19>0.4*J19,0.4*J19,J19*Q19*X19))","v":0},{"$f":"IF(L19=\" \",0,L19)","v":0},{"$f":"W19/365","v":0},{"$f":"IF(R19>0,J19*$Y$11/365*R19,0)","v":0},{"$f":"IF(T19>0,J19*$Y$11/365*T19,0)","v":0},null,null,null,null,{"$f":"G19","v":2},{"$f":"IF(I19=\"\",\" \",I19)","v":"2012-09-16"},{"$f":"IF(J19>0,J19,0)","v":0},{"$f":"K19","v":0},{"$f":"IF(AG19>0,INT(Q19),0)","v":0},{"$f":"IF(L19=\"\",\" \",L19)","v":" "},{"$f":"IF(N19=1,V19,U19)","v":0},{"$f":"IF(N19=1,Z19,Y19)","v":0},{"$f":"ROUND(AK19+AL19,)","v":0},null,null,2004]
[null,null,null,null,null,null,3,null,{"$f":"VLOOKUP(H17,scadenze,8)","v":"2012-11-16"},null,null,{"$f":"IF(J20=\"\",\" \",IF(K20=\"M\",VLOOKUP(H11,tassi,4),VLOOKUP(H11,tassi,2)))","v":" "},null,{"$f":"IF(K20=\"M\",1,2)","v":2},{"$f":"$H$11","v":"2015-01-12"},{"$f":"IF(I20=\"\",0,I20)","v":"2012-11-16"},{"$f":"IF(P20<>0,O20-P20,0)","v":787},{"$f":"IF(Q20>730,Q20-730,0)","v":57},{"$f":"IF(N20=2,0,IF(X20=0,0,40/X20/100))","v":0},{"$f":"IF(S20=0,0,IF(Q20<S20,0,Q20-S20))","v":0},{"$f":"IF(Q20<=0,0,IF(J20*Q20*X20>0.6*J20,0.6*J20,J20*Q20*X20))","v":0},{"$f":"IF(Q20<=0,0,IF(J20*Q20*X20>0.4*J20,0.4*J20,J20*Q20*X20))","v":0},{"$f":"IF(L20=\" \",0,L20)","v":0},{"$f":"W20/365","v":0},{"$f":"IF(R20>0,J20*$Y$11/365*R20,0)","v":0},{"$f":"IF(T20>0,J20*$Y$11/365*T20,0)","v":0},null,null,null,null,{"$f":"G20","v":3},{"$f":"IF(I20=\"\",\" \",I20)","v":"2012-11-16"},{"$f":"IF(J20>0,J20,0)","v":0},{"$f":"K20","v":0},{"$f":"IF(AG20>0,INT(Q20),0)","v":0},{"$f":"IF(L20=\"\",\" \",L20)","v":" "},{"$f":"IF(N20=1,V20,U20)","v":0},{"$f":"IF(N20=1,Z20,Y20)","v":0},{"$f":"ROUND(AK20+AL20,)","v":0},null,null,2005]
[null,null,null,null,null,null,4,null,{"$f":"VLOOKUP(H17,scadenze,9)","v":"2013-01-16"},null,null,{"$f":"IF(J21=\"\",\" \",IF(K21=\"M\",VLOOKUP(H11,tassi,4),VLOOKUP(H11,tassi,2)))","v":" "},null,{"$f":"IF(K21=\"M\",1,2)","v":2},{"$f":"$H$11","v":"2015-01-12"},{"$f":"IF(I21=\"\",0,I21)","v":"2013-01-16"},{"$f":"IF(P21<>0,O21-P21,0)","v":726},{"$f":"IF(Q21>730,Q21-730,0)","v":0},{"$f":"IF(N21=2,0,IF(X21=0,0,40/X21/100))","v":0},{"$f":"IF(S21=0,0,IF(Q21<S21,0,Q21-S21))","v":0},{"$f":"IF(Q21<=0,0,IF(J21*Q21*X21>0.6*J21,0.6*J21,J21*Q21*X21))","v":0},{"$f":"IF(Q21<=0,0,IF(J21*Q21*X21>0.4*J21,0.4*J21,J21*Q21*X21))","v":0},{"$f":"IF(L21=\" \",0,L21)","v":0},{"$f":"W21/365","v":0},{"$f":"IF(R21>0,J21*$Y$11/365*R21,0)","v":0},{"$f":"IF(T21>0,J21*$Y$11/365*T21,0)","v":0},null,null,null,null,{"$f":"G21","v":4},{"$f":"IF(I21=\"\",\" \",I21)","v":"2013-01-16"},{"$f":"IF(J21>0,J21,0)","v":0},{"$f":"K21","v":0},{"$f":"IF(AG21>0,INT(Q21),0)","v":0},{"$f":"IF(L21=\"\",\" \",L21)","v":" "},{"$f":"IF(N21=1,V21,U21)","v":0},{"$f":"IF(N21=1,Z21,Y21)","v":0},{"$f":"ROUND(AK21+AL21,)","v":0},null,null,2006]
[null,null,null,null,null,null,null,"TOTALE ",null,{"$f":"SUM(J18:J21)","v":340},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTALE",{"$f":"SUM(AG18:AG21)","v":340},null,null,null,{"$f":"SUM(AK18:AK21)","v":204},{"$f":"SUM(AL18:AL21)","v":8.6183013698630138},{"$f":"ROUND(AK22+AL22,)","v":213}]
[]
[]
[null,null,null,null,null,null,{"$f":"IF(H17=1998,\"N.B. LE SCADENZE SONO RELATIVE AI TITOLARI DI PARTITA IVA\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," A)","TOTALE CONTRIBUTI",null,null,null,{"$f":"ROUND(AG22,)","v":340}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," B)","TOTALE SANZIONI",null,null,null,{"$f":"ROUND(AK22,)","v":204}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," C)","TOTALE INTERESSI DI MORA",null,null,null,{"$f":"ROUND(AL22,)","v":9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," D)","TOTALE SANZIONI + INTERESSI",null,null,null,{"$f":"AM22","v":213}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," TOTALE DEBITO  .............................................",null,null,null,null,{"$f":"AK26+AK29","v":553}]

{"sheet":"sanzioni agricoli","index":8,"n_rows":29,"n_cols":41,"rows_kept":29,"cut":false,"hidden":false,"merged":[[10,31,10,33]]}
[]
[]
[]
[null,null,null,null,null,"CALCOLO SANZIONI L.388/2000"]
[]
[null,null,null,null,null,"DITTA:","PROVA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CALCOLO SANZIONI L.388/2000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35450,null,null,null,null,null,null," ","INTERESSI ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1995,null,"E"]
[null,null,null,null,null,"MATRICOLA","8100000081",null,null,null,null,null,"E"," ",null,null,null,null,null,null,null,null,null,"DI MORA",null,null,null,null,null,"ditta :",{"$f":"G6","v":"PROVA"},null,null,null,"matricola:",{"$f":"G8","v":"8100000081"},null,null,1996,null,"M"]
[null,null,null,null,null,null,null,null,null,null,null,null,"M"]
[null,null,null,null,null,"DATA ","2012-01-10",null,"AGRICOLI",null,null,null,null,{"$f":"G10","v":40918},null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($G$10,tassi,5)","v":5.024E-2},null,null,null,null,null,"data calcolo:",{"$f":"G10","v":"2012-01-10"},null,null,null,null,null,null,null,1997]
[null,null,null,null,null,"TIPO (E/M)",null,null,null,null,null,null,"MOROSITA' =1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TIPO EVENTO :",null,{"$f":"IF(#REF!=\"\",\" \",#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,null,1998]
[null,null,null,null,null,"TASSO CORRENTE.........................",null,null,null,null,null,null,"EVASIONE=2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1999]
[]
[null,null,null,null,null,"trimestre","anno","scadenza","importo","e/m","tasso",null,"M 1","data calcolo","scadenza","giorni","EVASIONE","morosità","MOROSITA'","evasione","morosità",null,null,"interessi","interessi",null,null,null,"ANNO",null,null,null,null,null,null,null,null,null,2000]
[null,null,null,null,null,null,null,null,"contributi",null,null,null,"E 2",null,null,null,null,null,null,null,null,null,null,"evasione","morosità",null,null,"TRIM.",{"$f":"G16","v":2011},"IMPORTO","E/M","GIORNI","TASSO","SANZIONI","INTERESSI","TOTALE"]
[null,null,null,null,null,null,2011,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCADENZE",null,null,null,null,null,null,null,null,null,2002]
[null,null,null,null,null,1,null,{"$f":"VLOOKUP(G16,scadenze,2)","v":"2011-09-16"},300,"M",{"$f":"IF(I17=\"\",\" \",IF(J17=\"M\",VLOOKUP(G10,tassi,4),VLOOKUP(G10,tassi,2)))","v":6.5000000000000002E-2},null,{"$f":"IF(J17=\"M\",1,2)","v":1},{"$f":"$G$10","v":"2012-01-10"},{"$f":"IF(H17=\"\",0,H17)","v":"2011-09-16"},{"$f":"IF(O17<>0,N17-O17,0)","v":116},{"$f":"IF(P17>730,P17-730,0)","v":0},{"$f":"IF(M17=2,0,IF(W17=0,0,40/W17/100))","v":2246.1538461538462},{"$f":"IF(R17=0,0,IF(P17<R17,0,P17-R17))","v":0},{"$f":"IF(P17<=0,0,IF(I17*P17*W17>0.6*I17,0.6*I17,I17*P17*W17))","v":6.1972602739726028},{"$f":"IF(P17<=0,0,IF(I17*P17*W17>0.4*I17,0.4*I17,I17*P17*W17))","v":6.1972602739726028},{"$f":"IF(K17=\" \",0,K17)","v":6.5000000000000002E-2},{"$f":"V17/365","v":1.7808219178082192E-4},{"$f":"IF(Q17>0,I17*$X$10/365*Q17,0)","v":0},{"$f":"IF(S17>0,I17*$X$10/365*S17,0)","v":0},null,null,{"$f":"F17","v":1},{"$f":"IF(H17=\"\",\" \",H17)","v":"2011-09-16"},{"$f":"IF(I17>0,I17,0)","v":300},{"$f":"J17","v":"M"},{"$f":"IF(AD17>0,INT(P17),0)","v":116},{"$f":"IF(K17=\"\",\" \",K17)","v":6.5000000000000002E-2},{"$f":"IF(M17=1,U17,T17)","v":6.1972602739726028},{"$f":"IF(M17=1,Y17,X17)","v":0},{"$f":"ROUND(AH17+AI17,)","v":6},null,null,2003]
[null,null,null,null,null,2,null,{"$f":"VLOOKUP(G16,scadenze,3)","v":"2011-12-16"},null,null,{"$f":"IF(I18=\"\",\" \",IF(J18=\"M\",VLOOKUP(G10,tassi,4),VLOOKUP(G10,tassi,2)))","v":" "},null,{"$f":"IF(J18=\"M\",1,2)","v":2},{"$f":"$G$10","v":"2012-01-10"},{"$f":"IF(H18=\"\",0,H18)","v":"2011-12-16"},{"$f":"IF(O18<>0,N18-O18,0)","v":25},{"$f":"IF(P18>730,P18-730,0)","v":0},{"$f":"IF(M18=2,0,IF(W18=0,0,40/W18/100))","v":0},{"$f":"IF(R18=0,0,IF(P18<R18,0,P18-R18))","v":0},{"$f":"IF(P18<=0,0,IF(I18*P18*W18>0.6*I18,0.6*I18,I18*P18*W18))","v":0},{"$f":"IF(P18<=0,0,IF(I18*P18*W18>0.4*I18,0.4*I18,I18*P18*W18))","v":0},{"$f":"IF(K18=\" \",0,K18)","v":0},{"$f":"V18/365","v":0},{"$f":"IF(Q18>0,I18*$X$10/365*Q18,0)","v":0},{"$f":"IF(S18>0,I18*$X$10/365*S18,0)","v":0},null,null,{"$f":"F18","v":2},{"$f":"IF(H18=\"\",\" \",H18)","v":"2011-12-16"},{"$f":"IF(I18>0,I18,0)","v":0},{"$f":"J18","v":0},{"$f":"IF(AD18>0,INT(P18),0)","v":0},{"$f":"IF(K18=\"\",\" \",K18)","v":" "},{"$f":"IF(M18=1,U18,T18)","v":0},{"$f":"IF(M18=1,Y18,X18)","v":0},{"$f":"ROUND(AH18+AI18,)","v":0},null,null,2004]
[null,null,null,null,null,3,null,{"$f":"VLOOKUP(G16,scadenze,4)","v":"2012-03-16"},null,null,{"$f":"IF(I19=\"\",\" \",IF(J19=\"M\",VLOOKUP(G10,tassi,4),VLOOKUP(G10,tassi,2)))","v":" "},null,{"$f":"IF(J19=\"M\",1,2)","v":2},{"$f":"$G$10","v":"2012-01-10"},{"$f":"IF(H19=\"\",0,H19)","v":"2012-03-16"},{"$f":"IF(O19<>0,N19-O19,0)","v":-66},{"$f":"IF(P19>730,P19-730,0)","v":0},{"$f":"IF(M19=2,0,IF(W19=0,0,40/W19/100))","v":0},{"$f":"IF(R19=0,0,IF(P19<R19,0,P19-R19))","v":0},{"$f":"IF(P19<=0,0,IF(I19*P19*W19>0.6*I19,0.6*I19,I19*P19*W19))","v":0},{"$f":"IF(P19<=0,0,IF(I19*P19*W19>0.4*I19,0.4*I19,I19*P19*W19))","v":0},{"$f":"IF(K19=\" \",0,K19)","v":0},{"$f":"V19/365","v":0},{"$f":"IF(Q19>0,I19*$X$10/365*Q19,0)","v":0},{"$f":"IF(S19>0,I19*$X$10/365*S19,0)","v":0},null,null,{"$f":"F19","v":3},{"$f":"IF(H19=\"\",\" \",H19)","v":"2012-03-16"},{"$f":"IF(I19>0,I19,0)","v":0},{"$f":"J19","v":0},{"$f":"IF(AD19>0,INT(P19),0)","v":0},{"$f":"IF(K19=\"\",\" \",K19)","v":" "},{"$f":"IF(M19=1,U19,T19)","v":0},{"$f":"IF(M19=1,Y19,X19)","v":0},{"$f":"ROUND(AH19+AI19,)","v":0},null,null,2005]
[null,null,null,null,null,4,null,{"$f":"VLOOKUP(G16,scadenze,5)","v":"2012-06-16"},null,null,{"$f":"IF(I20=\"\",\" \",IF(J20=\"M\",VLOOKUP(G10,tassi,4),VLOOKUP(G10,tassi,2)))","v":" "},null,{"$f":"IF(J20=\"M\",1,2)","v":2},{"$f":"$G$10","v":"2012-01-10"},{"$f":"IF(H20=\"\",0,H20)","v":"2012-06-16"},{"$f":"IF(O20<>0,N20-O20,0)","v":-158},{"$f":"IF(P20>730,P20-730,0)","v":0},{"$f":"IF(M20=2,0,IF(W20=0,0,40/W20/100))","v":0},{"$f":"IF(R20=0,0,IF(P20<R20,0,P20-R20))","v":0},{"$f":"IF(P20<=0,0,IF(I20*P20*W20>0.6*I20,0.6*I20,I20*P20*W20))","v":0},{"$f":"IF(P20<=0,0,IF(I20*P20*W20>0.4*I20,0.4*I20,I20*P20*W20))","v":0},{"$f":"IF(K20=\" \",0,K20)","v":0},{"$f":"V20/365","v":0},{"$f":"IF(Q20>0,I20*$X$10/365*Q20,0)","v":0},{"$f":"IF(S20>0,I20*$X$10/365*S20,0)","v":0},null,null,{"$f":"F20","v":4},{"$f":"IF(H20=\"\",\" \",H20)","v":"2012-06-16"},{"$f":"IF(I20>0,I20,0)","v":0},{"$f":"J20","v":0},{"$f":"IF(AD20>0,INT(P20),0)","v":0},{"$f":"IF(K20=\"\",\" \",K20)","v":" "},{"$f":"IF(M20=1,U20,T20)","v":0},{"$f":"IF(M20=1,Y20,X20)","v":0},{"$f":"ROUND(AH20+AI20,)","v":0},null,null,2006]
[null,null,null,null,null,null,"TOTALE ",null,{"$f":"SUM(I17:I20)","v":300},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTALE",{"$f":"SUM(AD17:AD20)","v":300},null,null,null,{"$f":"SUM(AH17:AH20)","v":6.1972602739726028},{"$f":"SUM(AI17:AI20)","v":0},{"$f":"ROUND(AH21+AI21,)","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IVS"]
[]
[]
[null,null,null,null,null,{"$f":"IF(G16=1998,\"N.B. LE SCADENZE SONO RELATIVE AI TITOLARI DI PARTITA IVA\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," A)","TOTALE CONTRIBUTI",null,null,null,{"$f":"ROUND(AD21,)","v":300}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," B)","TOTALE SANZIONI",null,null,null,{"$f":"ROUND(AH21,)","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," C)","TOTALE INTERESSI DI MORA",null,null,null,{"$f":"ROUND(AI21,)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," D)","TOTALE SANZIONI + INTERESSI",null,null,null,{"$f":"AJ21","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," TOTALE DEBITO  .............................................",null,null,null,null,{"$f":"AH25+AH28","v":306}]

{"sheet":"sanzfallimenti","index":9,"n_rows":47,"n_cols":63,"rows_kept":47,"cut":false,"hidden":false,"merged":[[4,52,4,53],[5,52,5,53],[3,52,3,55]]}
[null,null,null,null,"DITTA:","prova",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,"CALCOLO SANZIONI AZIENDE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35450,null,null,null,null,null,null,null,null,null,null," ","INTERESSI "," ",null,null,null,null,null,{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,null,null,"data apertura fallimento:",null,null,{"$f":"O3","v":"1999-02-08"},null,null,null,null,null,null,null,null,null,null,null,1995,null,"E"]
[null,null,null,null,"MATRICOLA",null,"8100000081",null,null,"VIG N°","1230",null,"data apertura fallimento",null,"1999-02-08",null," ","E",null,null,null,null,null,null,null,null,null,null,null,null,null,"DI MORA",null,null,null,null,null,null,{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,null,null,"data chiusura fallimento:",null,null,{"$f":"O5","v":"2010-04-15"},null,null,"matricola:",{"$f":"G3","v":"8100000081"},null,null,null,null,null,null,null,1996,null,"M"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"data calcolo:",{"$f":"$F$5","v":"2013-10-14"},null,null,"ditta:",{"$f":"IF(F1=\"\",\" \",F1)","v":"prova"},null,null,null,"vig:",{"$f":"IF($K$3=\"\",\" \",$K$3)","v":"1230"}]
[null,null,null,null,"DATA ","2013-10-14",null,null,null,null,null,null,"data chiusura fallimento",null,"2010-04-15",null,{"$f":"F5","v":41561},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($F$5,tassi,5)","v":5.2229999999999999E-2},null,null,null,null,null,null,{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1997]
[null,null,null,null,"TIPO (E/M)",null,"m",null,null,"EURO ","EURO",null,null,null,null,"MOROSITA' =1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,"TIPO EVENTO :",{"$f":"IF($G$6=\"M\",\"MOROSITA'\",\"EVASIONE\")","v":"MOROSITA'"},null,"N° Matricola ........….:",null,{"$f":"IF($G$3=\"\",\" \",$G$3)","v":"8100000081"},null,null,null,null,null,null,null,1998]
[null,null,null,null,"TASSO CORRENTE.........................",null,null,null,null,"EURO ","EURO",null,null,null,null,"EVASIONE=2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1999]
[null,null,null,null,null,null,null,null,null,"EURO ","EURO",null,null,null,null,null,null,null,null,null,null,null,"EVASIONE","morosità","MOROSITA'","IVS","IVS","SSN","SSN",null,null,"IVS","SSN","IVS","SSN",null,null,null,{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,"N.","ANNO","MESE","MESE","IMPORTO","IMPORTO","EVAS.","TASSO","DATA","GG","SANZIONI","INTERESSI","SANZIONI","INTERESSI","TOTALE ",null,null,2000]
[null,null,null,null,"N.","Anno","INIZIO","FINE","Controllo data","IMPORTO CONTRIBUTI IVS","IMPORTO CONTRIBUTI SSN","TIPO     E/M","TASSO","giorni totali","giorni interessi di mora","flag morosità","DATA1","DATA2","MEDIA","GIORNI TOT.","giorni fallimento","differenza","GIORNIxINT.","giorni x 40%","GIORNIxINT.","SANZIONI EVASIONE","SANZIONI MOROSITA'","SANZIONI EVASIONE","SANZIONI MOROSITA'","TASSO","TASSO/GIORNI","INT. EVASIONE","INT.EVASIONE","INT. MOROSITA'","INT. MOROSITA'","  C",null,null,{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,null,null,"INIZIO","FINE","CONTRIBUTI   IVS in EURO","CONTRIBUTI  SSN in EURO","MOR.","%","VALUTA",null,"Legge 388/00    IVS","DI MORA","Legge 388/00    SSN","DI MORA","SANZIONI",null,null,2001]
[null,null,null,null,1,1998,12,12,{"$f":"IF(F10=0,\" \",IF(H10<G10,\"data errata\",IF($F$5<AZ10,\"data errata\",\"OK\")))","v":"OK"},5000,null,"e",{"$f":"IF(L10=\"\",\" \",IF(L10=\"M\",VLOOKUP($F$5,tassi,4),VLOOKUP($F$5,tassi,2)))","v":0.3},{"$f":"IF(L10=\"\",\"\",V10)","v":1302},{"$f":"IF(L10=\"\",\"\",IF(L10=\"E\",W10,Y10))","v":572},{"$f":"IF(L10=\"M\",1,2)","v":2},{"$f":"IF(G10=0,0,IF(F10<1998,DATE(F10,G10+1,20),IF(AND(F10=1998,G10<4),DATE(F10,G10+1,20),IF(F10>1998,DATE(F10,G10+1,16),DATE(F10,G10+1,15)))))","v":"1999-01-15"},{"$f":"IF(H10=0,0,IF(F10<1998,DATE(F10,H10+1,20),IF(AND(F10=1998,H10<4),DATE(F10,H10+1,20),IF(F10>1998,DATE(F10,H10+1,16),DATE(F10,H10+1,15)))))","v":"1999-01-15"},{"$f":"AVERAGE(Q10,R10)","v":"1999-01-15"},{"$f":"IF(S10<>0,$Q$5-S10,0)","v":5386},{"$f":"$O$5-$O$3","v":4084},{"$f":"T10-U10","v":1302},{"$f":"IF(V10>730,V10-730,0)","v":572},{"$f":"IF(P10=2,0,40/AE10/100)","v":0},{"$f":"IF(X10=0,0,IF(V10<X10,0,V10-X10))","v":0},{"$f":"IF(T10<=0,\"\",IF(J10*T10*AE10>0.6*J10,0.6*J10,J10*T10*AE10))","v":3000},{"$f":"IF(T10<=0,\"\",IF(J10*T10*AE10>0.4*J10,0.4*J10,J10*T10*AE10))","v":2000},{"$f":"IF(T10<=0,\"\",IF(K10*T10*AE10>0.6*K10,0.6*K10,K10*T10*AE10))","v":0},{"$f":"IF(T10<=0,\"\",IF(K10*T10*AE10>0.4*K10,0.4*K10,K10*T10*AE10))","v":0},{"$f":"M10","v":0.3},{"$f":"AD10/365","v":8.2191780821917802E-4},{"$f":"IF(W10>0,J10*$AF$5/365*W10,\"\")","v":409.25424657534245},{"$f":"IF(W10>0,K10*$AF$5/365*W10,\"\")","v":0},{"$f":"IF(Y10>0,J10*$AF$5/365*Y10,\"\")","v":""},{"$f":"IF(Y10>0,K10*$AF$5/365*Y10,\"\")","v":""},{"$f":"90*360+12*30+15","v":32775},null,null,{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"E10","v":1},{"$f":"IF(F10>0,F10,\"\")","v":1998},{"$f":"IF(G10>0,G10,\"\")","v":12},{"$f":"IF(H10>0,H10,\"\")","v":12},{"$f":"IF(J10>0,J10,\"\")","v":5000},{"$f":"IF(K10>0,K10,\"\")","v":""},{"$f":"L10","v":"e"},{"$f":"IF(OR(J10>0,K10>0),AD10,\" \")","v":0.3},{"$f":"IF(F10>0,S10,\" \")","v":"1999-01-15"},{"$f":"IF(S10>0,INT(V10),\"\")","v":1302},{"$f":"IF(P10=1,AA10,Z10)","v":3000},{"$f":"IF(P10=1,AH10,AF10)","v":409.25424657534245},{"$f":"IF(P10=1,AC10,AB10)","v":0},{"$f":"IF(P10=1,AI10,AG10)","v":0},{"$f":"IF(T10=0,\"\",SUMIF(BB10:BE10,\"<>\"\"\"))","v":3409.2542465753422},null,null,2002]
[null,null,null,null,2,1999,1,1,"OK",21000,null,"e",0.3,1270,{"$f":"IF(L11=\"\",\"\",IF(L11=\"E\",W11,Y11))","v":540},2,"1999-02-16","1999-02-16","1999-02-16",5354,{"$f":"$O$5-$O$3","v":4084},{"$f":"T11-U11","v":1270},{"$f":"IF(V11>730,V11-730,0)","v":540},0,{"$f":"IF(X11=0,0,IF(V11<X11,0,V11-X11))","v":0},12600,8400,0,0,0.3,8.2191780821917802E-4,1622.7073972602739,0,"","",32775,null,null,{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,2,1999,1,1,21000,"","e",0.3,"1999-02-16",{"$f":"IF(S11>0,INT(V11),\"\")","v":1270},12600,1622.7073972602739,0,0,14222.707397260274,null,null,2003]
[null,null,null,null,3,null,null,null," ",null,null,null," ","",{"$f":"IF(L12=\"\",\"\",IF(L12=\"E\",W12,Y12))","v":""},2,"00:00:00","00:00:00","00:00:00",0,4084,-4084,0,0,0,"","","",""," ",{"$error":"#VALUE!"},"","","","",32775,null,null,{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,3,"","","","","",0," "," ",{"$f":"IF(S12>0,INT(V12),\"\")","v":""},"","","","","",null,null,2004]
[null,null,null,null,4,null,null,null," ",null,null,null," ","","",2,"00:00:00","00:00:00","00:00:00",0,4084,-4084,0,0,0,"","","",""," ",{"$error":"#VALUE!"},"","","","",32775,null,null,{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,4,"","","","","",0," "," ","","","","","","",null,null,2005]
[null,null,null,null,5,null,null,null," ",null,null,null," ","","",2,"00:00:00","00:00:00","00:00:00",0,4084,-4084,0,0,0,"","","",""," ",{"$error":"#VALUE!"},"","","","",32775,null,"La data è quella in cui si ",{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,5,"","","","","",0," "," ","","","","","","",null,null,2006]
[null,null,null,null,6,null,null,null," ",null,null,null," ","","",2,"00:00:00","00:00:00","00:00:00",0,4084,-4084,0,0,0,"","","",""," ",{"$error":"#VALUE!"},"","","","",32775,null,"effettua il calcolo",{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,6,"","","","","",0," "," ","","","","","","",null,null,2007]
[null,null,null,null,7,null,null,null," ",null,null,null," ","","",2,"00:00:00","00:00:00","00:00:00",0,4084,-4084,0,0,0,"","","",""," ",{"$error":"#VALUE!"},"","","","",32775,null,null,{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,7,"","","","","",0," "," ","","","","","","",null,null,2008]
[null,null,null,null,8,null,null,null," ",null,null,null," ","","",2,"00:00:00","00:00:00","00:00:00",0,4084,-4084,0,0,0,"","","",""," ",{"$error":"#VALUE!"},"","","","",32775,null,"L'importo dei contributi",{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,8,"","","","","",0," "," ","","","","","","",null,null,2009]
[null,null,null,null,9,null,null,null," ",null,null,null," ","","",2,"00:00:00","00:00:00","00:00:00",0,4084,-4084,0,0,0,"","","",""," ",{"$error":"#VALUE!"},"","","","",32775,null,"è espresso in EURO",{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,9,"","","","","",0," "," ","","","","","","",null,null,2010]
[null,null,null,null,10,null,null,null," ",null,null,null," ","","",2,"00:00:00","00:00:00","00:00:00",0,4084,-4084,0,0,0,"","","",""," ",{"$error":"#VALUE!"},"","","","",32775,null,null,{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,10,"","","","","",0," "," ","","","","","",""]
[null,null,null,null,11,null,null,null," ",null,null,null," ","","",2,"00:00:00","00:00:00","00:00:00",0,4084,-4084,0,0,0,"","","",""," ",{"$error":"#VALUE!"},"","","","",32775,null,null,{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,11,"","","","","",0," "," ","","","","","",""]
[null,null,null,null,12,null,null,null," ",null,null,null," ","","",2,"00:00:00","00:00:00","00:00:00",0,4084,-4084,0,0,0,"","","",""," ",{"$error":"#VALUE!"},"","","","",32775,null," Il programma è utilizzabile per ",{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,12,"","","","","",0," "," ","","","","","",""]
[null,null,null,null,13,null,null,null," ",null,null,null," ","","",2,"00:00:00","00:00:00","00:00:00",0,4084,-4084,0,0,0,"","","",""," ",{"$error":"#VALUE!"},"","","","",32775,null," calcolare le sanzioni secondo ",{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,13,"","","","","",0," "," ","","","","","",""]
[null,null,null,null,14,null,null,null," ",null,null,null," ","","",2,"00:00:00","00:00:00","00:00:00",0,4084,-4084,0,0,0,"","","",""," ",{"$error":"#VALUE!"},"","","","",32775,null," quanto disposto dalla legge ",{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,14,"","","","","",0," "," ","","","","","",""]
[null,null,null,null,15,null,null,null," ",null,null,null," ","","",2,"00:00:00","00:00:00","00:00:00",0,4084,-4084,0,0,0,"","","",""," ",{"$error":"#VALUE!"},"","","","",32775,null," finanziaria 2001 (l. 388/00)",{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,15,"","","","","",0," "," ","","","","","",""]
[null,null,null,null,16,null,null,null," ",null,null,null," ","","",2,"00:00:00","00:00:00","00:00:00",0,4084,-4084,0,0,0,"","","",""," ",{"$error":"#VALUE!"},"","","","",32775,null,null,{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,16,"","","","","",0," "," ","","","","","",""]
[null,null,null,null,17,null,null,null," ",null,null,null," ","","",2,"00:00:00","00:00:00","00:00:00",0,4084,-4084,0,0,0,"","","",""," ",{"$error":"#VALUE!"},"","","","",32775,null,"Il periodo compreso tra la ",{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,17,"","","","","",0," "," ","","","","","",""]
[null,null,null,null,18,null,null,null," ",null,null,null," ","","",2,"00:00:00","00:00:00","00:00:00",0,4084,-4084,0,0,0,"","","",""," ",{"$error":"#VALUE!"},"","","","",32775,null,"data di apertura del ",{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,18,"","","","","",0," "," ","","","","","",""]
[null,null,null,null,19,null,null,null," ",null,null,null," ","","",2,"00:00:00","00:00:00","00:00:00",0,4084,-4084,0,0,0,"","","",""," ",{"$error":"#VALUE!"},"","","","",32775,null,"fallimento e la data di ",{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,19,"","","","","",0," "," ","","","","","",""]
[null,null,null,null,20,null,null,null," ",null,null,null," ","","",2,"00:00:00","00:00:00","00:00:00",0,4084,-4084,0,0,0,"","","",""," ",{"$error":"#VALUE!"},"","","","",32775,null,"chiusura è neutro.",{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,20,"","","","","",0," "," ","","","","","",""]
[null,null,null,null,21,null,null,null," ",null,null,null," ","","",2,"00:00:00","00:00:00","00:00:00",0,4084,-4084,0,0,0,"","","",""," ",{"$error":"#VALUE!"},"","","","",32775,null,null,{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,21,"","","","","",0," "," ","","","","","",""]
[null,null,null,null,22,null,null,null," ",null,null,null," ","","",2,"00:00:00","00:00:00","00:00:00",0,4084,-4084,0,0,0,"","","",""," ",{"$error":"#VALUE!"},"","","","",32775,null,null,{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,22,"","","","","",0," "," ","","","","","",""]
[null,null,null,null,23,null,null,null," ",null,null,null," ","","",2,"00:00:00","00:00:00","00:00:00",0,4084,-4084,0,0,0,"","","",""," ",{"$error":"#VALUE!"},"","","","",32775,null,null,{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,23,"","","","","",0," "," ","","","","","",""]
[null,null,null,null,24,null,null,null," ",null,null,null," ","","",2,"00:00:00","00:00:00","00:00:00",0,4084,-4084,0,0,0,"","","",""," ",{"$error":"#VALUE!"},"","","","",32775,null,null,{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,24,"","","","","",0," "," ","","","","","",""]
[null,null,null,null,25,null,null,null," ",null,null,null," ","","",2,"00:00:00","00:00:00","00:00:00",0,4084,-4084,0,0,0,"","","",""," ",{"$error":"#VALUE!"},"","","","",32775,null,null,{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,25,"","","","","",0," "," ","","","","","",""]
[null,null,null,null,26,null,null,null," ",null,null,null," ","","",2,"00:00:00","00:00:00","00:00:00",0,4084,-4084,0,0,0,"","","",""," ",{"$error":"#VALUE!"},"","","","",32775,null,null,{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,26,"","","","","",0," "," ","","","","","",""]
[null,null,null,null,27,null,null,null," ",null,null,null," ","","",2,"00:00:00","00:00:00","00:00:00",0,4084,-4084,0,0,0,"","","",""," ",{"$error":"#VALUE!"},"","","","",32775,null,null,{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,27,"","","","","",0," "," ","","","","","",""]
[null,null,null,null,28,null,null,null," ",null,null,null," ","","",2,"00:00:00","00:00:00","00:00:00",0,4084,-4084,0,0,0,"","","",""," ",{"$error":"#VALUE!"},"","","","",32775,null,null,{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,28,"","","","","",0," "," ","","","","","",""]
[null,null,null,null,29,null,null,null," ",null,null,null," ","","",2,"00:00:00","00:00:00","00:00:00",0,4084,-4084,0,0,0,"","","",""," ",{"$error":"#VALUE!"},"","","","",32775,null,null,{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,29,"","","","","",0," "," ","","","","","",""]
[null,null,null,null,30,null,null,null," ",null,null,null," ","","",2,"00:00:00","00:00:00","00:00:00",0,4084,-4084,0,0,0,"","","",""," ",{"$error":"#VALUE!"},"","","","",32775,null,null,{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,30,"","","","","",0," "," ",{"$f":"IF(S39>0,INT(V39),\"\")","v":""},"","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J10:J39)","v":26000},{"$f":"SUM(K10:K39)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AV10:AV39)","v":26000},{"$f":"SUM(AW10:AW39)","v":0},null,null,null,null,{"$f":"SUM(BB10:BB39)","v":15600},{"$f":"SUM(BC10:BC39)","v":2031.9616438356163},{"$f":"SUM(BD10:BD39)","v":0},{"$f":"SUM(BE10:BE39)","v":0},{"$f":"SUM(BF10:BF39)","v":17631.961643835617}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,"QUADRO RIEPILOGATIVO",null,null,"IVS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IVS",null,"SSN",null,"TOTALE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," A)","CONTRIBUZIONE EVASA ............................",null,null,null,null,null,null,null,{"$f":"ROUND(AV40,)","v":26000},null,{"$f":"ROUND(AW40,)","v":0},null,{"$f":"ROUND(AV40+AW40,)","v":26000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," B)","AMMONTARE SANZIONI .............................",null,null,null,null,null,null,null,{"$f":"ROUND(BB40,0)","v":15600},null,{"$f":"ROUND(BD40,0)","v":0},null,{"$f":"BB44+BD44","v":15600}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," C)","INTERESSI DI MORA …………………………",null,null,null,null,null,null,null,{"$f":"ROUND(BC40,0)","v":2032},null,{"$f":"ROUND(BE40,0)","v":0},null,{"$f":"BB45+BD45","v":2032}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D)","SANZIONI + INTERESSI",null,null,"………………….",null,null,null,null,{"$f":"SUM(BB44:BB45)","v":17632},null,{"$f":"SUM(BD44:BD45)","v":0},null,{"$f":"SUM(BF44:BF45)","v":17632}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," TOTALE DEBITO  .............................................",null,null,null,null,null,null,null,null,{"$f":"SUM(BB43:BB45)","v":43632},null,{"$f":"SUM(BD43:BD45)","v":0},null,{"$f":"SUM(BF43:BF45)","v":43632}]

{"sheet":"tassi","index":10,"n_rows":150,"n_cols":7,"rows_kept":150,"cut":false,"hidden":false,"merged":[]}
["periodo","tasso evasione","prime rate","tasso morosità","interessi di mora","interessi legali"]
["1960-01-01",0.3,0.13,{"$f":"IF(C2<>0,C2+5.5%,0)","v":0.185},8.4000000000000005E-2]
["1988-02-29",0.3,0.13,{"$f":"IF(C3<>0,C3+5.5%,0)","v":0.185},8.4000000000000005E-2]
["1988-06-07",0.3,0.12625,{"$f":"IF(C4<>0,C4+5.5%,0)","v":0.18124999999999999},8.4000000000000005E-2]
["1988-08-16",0.3,0.125,0.18,8.4000000000000005E-2]
["1988-09-27",0.3,0.12625,0.18124999999999999,8.4000000000000005E-2,null,"Il tasso per evasione è fissto al 30%"]
["1988-10-18",0.3,0.12875,0.18375,8.4000000000000005E-2]
["1988-12-02",0.3,0.13,0.185,8.4000000000000005E-2,null,"Il tasso per la morosità è calcolato aggiungendo al prime rate il 5,50%."]
["1989-04-27",0.3,0.14000000000000001,0.19500000000000001,8.4000000000000005E-2]
["1990-08-10",0.3,0.13250000000000001,0.1875,8.4000000000000005E-2]
["1990-08-22",0.3,0.13,0.185,8.4000000000000005E-2]
["1991-03-04",0.3,0.13125000000000001,0.18625,8.4000000000000005E-2]
["1991-04-24",0.3,0.13500000000000001,0.19,8.4000000000000005E-2]
["1991-07-15",0.3,0.12875,0.18375,8.4000000000000005E-2]
["1991-08-03",0.3,0.12625,0.18124999999999999,8.4000000000000005E-2]
["1991-08-14",0.3,0.125,0.18,8.4000000000000005E-2]
["1992-02-28",0.3,0.12625,0.18124999999999999,8.4000000000000005E-2]
["1992-03-31",0.3,0.13,0.185,8.4000000000000005E-2]
["1992-06-27",0.3,0.13125000000000001,0.18625,8.4000000000000005E-2]
["1992-08-20",0.3,0.13500000000000001,0.19,8.4000000000000005E-2]
["1992-10-15",0.3,0.14000000000000001,0.19500000000000001,8.4000000000000005E-2]
["1992-10-27",0.3,0.14874999999999999,0.20374999999999999,8.4000000000000005E-2]
["1992-11-02",0.3,0.1575,0.21249999999999999,8.4000000000000005E-2]
["1992-11-10",0.3,0.15375,0.20874999999999999,8.4000000000000005E-2]
["1992-12-18",0.3,0.17,0.22500000000000001,8.4000000000000005E-2]
["1993-02-10",0.3,0.16250000000000001,0.2175,8.4000000000000005E-2]
["1993-02-18",0.3,0.15875,0.21375,8.4000000000000005E-2]
["1993-02-24",0.3,0.14749999999999999,0.20249999999999999,8.4000000000000005E-2]
["1993-04-02",0.3,0.14000000000000001,0.19500000000000001,8.4000000000000005E-2]
["1993-04-08",0.3,0.13625000000000001,0.19125,8.4000000000000005E-2]
["1993-04-29",0.3,0.1275,0.1825,8.4000000000000005E-2]
["1993-05-10",0.3,0.12625,0.18124999999999999,8.4000000000000005E-2]
["1993-08-09",0.3,0.12375,0.17874999999999999,8.4000000000000005E-2]
["1993-08-19",0.3,0.1225,0.17749999999999999,8.4000000000000005E-2]
["1993-10-02",0.3,0.11874999999999999,0.17374999999999999,8.4000000000000005E-2]
["1993-10-06",0.3,0.11749999999999999,0.17249999999999999,8.4000000000000005E-2]
["1993-10-15",0.3,0.11625000000000001,0.17125000000000001,8.4000000000000005E-2]
["1993-10-21",0.3,0.10875,0.16375000000000001,8.4000000000000005E-2]
["1993-12-07",0.3,0.10375,0.15875,8.4000000000000005E-2]
["1994-02-01",0.3,0.1,0.155,8.4000000000000005E-2]
["1994-02-11",0.3,9.8750000000000004E-2,0.15375,8.4000000000000005E-2]
["1994-04-29",0.3,9.375E-2,0.14874999999999999,8.4000000000000005E-2]
["1994-07-27",0.3,9.1249999999999998E-2,0.14624999999999999,8.4000000000000005E-2]
["1994-10-15",0.3,8.8749999999999996E-2,0.14374999999999999,8.4000000000000005E-2]
["1994-10-22",0.3,9.1249999999999998E-2,0.14624999999999999,8.4000000000000005E-2]
["1994-11-05",0.3,9.375E-2,0.14874999999999999,8.4000000000000005E-2]
["1995-05-04",0.3,0.1,0.155,8.4000000000000005E-2]
["1995-05-26",0.3,0.10125000000000001,0.15625,8.4000000000000005E-2]
["1995-06-12",0.3,0.10625,0.16125,8.4000000000000005E-2]
["1995-07-11",0.3,0.10875,0.16375000000000001,8.4000000000000005E-2]
["1995-07-24",0.3,0.11375,0.16875000000000001,8.4000000000000005E-2]
["1995-08-18",0.3,0.11625000000000001,0.17125000000000001,8.4000000000000005E-2]
["1995-10-30",0.3,0.115,0.17,8.4000000000000005E-2]
["1996-07-01",0.3,0.115,0.17,8.4000000000000005E-2]
["1996-09-20",0.3,0.10875,0.16375000000000001,8.4000000000000005E-2]
["1996-10-12",0.3,0.1075,0.16250000000000001,8.4000000000000005E-2]
["1996-10-24",0.3,0.1075,0.16250000000000001,8.4000000000000005E-2]
["1996-12-17",0.3,0.10125000000000001,0.15625,8.4000000000000005E-2]
["1997-01-22",0.3,0.1,0.155,8.4000000000000005E-2,0.05]
["1997-03-03",0.3,9.7500000000000003E-2,0.1525,8.4000000000000005E-2,0.05]
["1997-03-21",0.3,9.6250000000000002E-2,0.15125,8.4000000000000005E-2,0.05]
["1997-04-01",0.3,9.5000000000000001E-2,0.15,8.4000000000000005E-2,0.05]
["1997-08-23",0.3,0.09,0.14499999999999999,8.4000000000000005E-2,0.05]
["1998-02-23",0.3,8.8749999999999996E-2,0.14374999999999999,8.4000000000000005E-2,0.05]
["1998-02-27",0.3,8.3750000000000005E-2,0.13875000000000001,8.4000000000000005E-2,0.05]
["1998-03-11",0.3,8.2500000000000004E-2,0.13750000000000001,8.4000000000000005E-2,0.05]
["1998-06-22",0.3,7.8750000000000001E-2,0.13375000000000001,8.4000000000000005E-2,0.05]
["1998-12-30",0.3,7.2499999999999995E-2,{"$f":"IF(C68<>0,C68+5.5%,0)","v":0.1275},8.4000000000000005E-2,0.05]
["1999-01-01",0.3,0.03,8.4999999999999992E-2,8.4000000000000005E-2,2.5000000000000001E-2]
["1999-04-14",0.3,2.5000000000000001E-2,0.08,8.4000000000000005E-2,2.5000000000000001E-2]
["1999-11-10",0.3,0.03,8.4999999999999992E-2,8.4000000000000005E-2,2.5000000000000001E-2]
["2000-02-09",0.3,3.2500000000000001E-2,8.7499999999999994E-2,8.4000000000000005E-2,2.5000000000000001E-2]
["2000-03-22",0.3,3.5000000000000003E-2,0.09,8.4000000000000005E-2,2.5000000000000001E-2]
["2000-05-04",0.3,3.7499999999999999E-2,9.2499999999999999E-2,8.4000000000000005E-2,2.5000000000000001E-2]
["2000-06-15",0.3,4.2500000000000003E-2,9.7500000000000003E-2,8.4000000000000005E-2,2.5000000000000001E-2]
["2000-09-06",0.3,4.4999999999999998E-2,0.1,8.4000000000000005E-2,2.5000000000000001E-2]
["2000-10-01",0.3,4.4999999999999998E-2,0.1,8.4000000000000005E-2,2.5000000000000001E-2]
["2000-10-11",0.3,4.7500000000000001E-2,0.10250000000000001,8.4000000000000005E-2,2.5000000000000001E-2]
["2001-01-01",0.3,4.7500000000000001E-2,0.10250000000000001,8.4000000000000005E-2,3.5000000000000003E-2]
["2001-05-15",0.3,4.4999999999999998E-2,0.1,8.4000000000000005E-2,3.5000000000000003E-2]
["2001-09-05",0.3,4.2500000000000003E-2,9.7500000000000003E-2,8.4000000000000005E-2,3.5000000000000003E-2]
["2001-09-19",0.3,3.7499999999999999E-2,9.2499999999999999E-2,8.4000000000000005E-2,3.5000000000000003E-2]
["2001-11-14",0.3,3.2500000000000001E-2,8.7499999999999994E-2,8.4000000000000005E-2,3.5000000000000003E-2]
["2002-01-01",0.3,3.2500000000000001E-2,8.7499999999999994E-2,8.4000000000000005E-2,0.03]
["2002-12-11",0.3,2.75E-2,8.2500000000000004E-2,8.4000000000000005E-2,0.03]
["2003-03-12",0.3,2.5000000000000001E-2,0.08,8.4000000000000005E-2,0.03]
["2003-06-09",0.3,0.02,7.4999999999999997E-2,8.4000000000000005E-2,0.03]
["2004-01-01",0.3,0.02,7.4999999999999997E-2,8.4000000000000005E-2,2.5000000000000001E-2]
["2005-12-06",0.3,2.2499999999999999E-2,7.7499999999999999E-2,8.4000000000000005E-2,2.5000000000000001E-2]
["2006-03-08",0.3,2.5000000000000001E-2,0.08,8.4000000000000005E-2,2.5000000000000001E-2]
["2006-06-15",0.3,2.75E-2,8.2500000000000004E-2,8.4000000000000005E-2,2.5000000000000001E-2]
["2006-08-09",0.3,0.03,8.4999999999999992E-2,8.4000000000000005E-2,2.5000000000000001E-2]
["2006-10-11",0.3,3.2500000000000001E-2,8.7499999999999994E-2,8.4000000000000005E-2,2.5000000000000001E-2]
["2006-12-13",0.3,3.5000000000000003E-2,0.09,8.4000000000000005E-2,2.5000000000000001E-2]
["2007-03-14",0.3,3.7499999999999999E-2,9.2499999999999999E-2,8.4000000000000005E-2,2.5000000000000001E-2]
["2007-06-13",0.3,0.04,9.5000000000000001E-2,8.4000000000000005E-2,2.5000000000000001E-2]
["2008-01-01",0.3,0.04,9.5000000000000001E-2,8.4000000000000005E-2,0.03]
["2008-07-09",0.3,4.2500000000000003E-2,9.7500000000000003E-2,8.4000000000000005E-2,0.03]
["2008-10-15",0.3,3.7499999999999999E-2,9.2499999999999999E-2,8.4000000000000005E-2,0.03]
["2008-11-12",0.3,3.2500000000000001E-2,8.7499999999999994E-2,8.4000000000000005E-2,0.03]
["2008-12-10",0.3,2.5000000000000001E-2,0.08,8.4000000000000005E-2,0.03]
["2009-01-21",0.3,0.02,7.4999999999999997E-2,8.4000000000000005E-2,0.03]
["2009-03-11",0.3,1.4999999999999999E-2,7.0000000000000007E-2,8.4000000000000005E-2,0.03,"Dopo aver aggiornato i tassi cliccare su Ritorna a sanzioni"]
["2009-04-08",0.3,1.2500000000000001E-2,6.7500000000000004E-2,8.4000000000000005E-2,0.03,"per salvare le modifiche."]
["2009-05-13",0.3,0.01,6.5000000000000002E-2,8.4000000000000005E-2,0.03]
["2009-10-01",0.3,0.01,6.5000000000000002E-2,6.8360000000000004E-2,0.03]
["2010-01-01",0.3,0.01,6.5000000000000002E-2,6.8360000000000004E-2,0.01]
["2010-10-01",0.3,0.01,6.5000000000000002E-2,5.7567E-2,0.01]
["2011-01-01",0.3,0.01,6.5000000000000002E-2,5.7567E-2,1.4999999999999999E-2]
["2011-04-13",0.3,1.2500000000000001E-2,6.7500000000000004E-2,5.7567E-2,1.4999999999999999E-2]
["2011-07-13",0.3,1.4999999999999999E-2,7.0000000000000007E-2,5.7567E-2,1.4999999999999999E-2]
["2011-11-09",0.3,1.2500000000000001E-2,6.7500000000000004E-2,5.7567E-2,1.4999999999999999E-2]
["2011-11-10",0.3,1.2500000000000001E-2,6.7500000000000004E-2,5.024E-2,1.4999999999999999E-2]
["2011-12-14",0.3,0.01,6.5000000000000002E-2,5.024E-2,1.4999999999999999E-2]
["2012-01-01",0.3,0.01,6.5000000000000002E-2,5.024E-2,2.5000000000000001E-2]
["2012-07-11",0.3,7.4999999999999997E-3,6.25E-2,5.024E-2,2.5000000000000001E-2]
["2012-10-01",0.3,7.4999999999999997E-3,6.25E-2,4.5499999999999999E-2,2.5000000000000001E-2]
["2013-05-01",0.3,7.4999999999999997E-3,{"$f":"IF(C118<>0,C118+5.5%,0)","v":6.25E-2},5.2229999999999999E-2,2.5000000000000001E-2]
["2013-05-08",0.3,5.0000000000000001E-3,{"$f":"IF(C119<>0,C119+5.5%,0)","v":0.06},5.2229999999999999E-2,2.5000000000000001E-2]
["2013-11-13",0.3,2.5000000000000001E-3,{"$f":"IF(C120<>0,C120+5.5%,0)","v":5.7500000000000002E-2},5.2229999999999999E-2,2.5000000000000001E-2]
["2014-01-01",0.3,2.5000000000000001E-3,{"$f":"IF(C121<>0,C121+5.5%,0)","v":5.7500000000000002E-2},5.2229999999999999E-2,0.01]
["2014-05-01",0.3,2.5000000000000001E-3,{"$f":"IF(C122<>0,C122+5.5%,0)","v":5.7500000000000002E-2},5.1400000000000001E-2,0.01]
["2014-06-11",0.3,1.5E-3,{"$f":"IF(C123<>0,C123+5.5%,0)","v":5.6500000000000002E-2},5.1400000000000001E-2,0.01]
["2014-09-10",0.3,5.0000000000000001E-4,5.5500000000000001E-2,5.1400000000000001E-2,0.01]
["2015-01-01",0.3,5.0000000000000001E-4,5.5500000000000001E-2,5.1400000000000001E-2,5.0000000000000001E-3]
["2015-05-15",0.3,5.0000000000000001E-4,5.5500000000000001E-2,4.8800000000000003E-2,5.0000000000000001E-3]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,{"$f":"IF(C132<>0,C132+5.5%,0)","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]

{"sheet":"scadenze","index":11,"n_rows":35,"n_cols":13,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["anno","AGRICOLI",null,null,null,"CD/CM",null,null,null,null,"DOMESTICI"]
[null,"1° TRIM","2° TRIM","3° TRIM","4° TRIM","1° TRIM","2° TRIM","3° TRIM","4° TRIM","1° TRIM","2° TRIM","3° TRIM","4° TRIM"]
[1988,"1988-09-10","1988-12-10","1989-03-10","1989-06-10","1988-07-10","1988-09-10","1988-11-10","1989-01-10","1988-07-10","1988-09-10","1988-11-10","1989-01-10"]
[1989,"1989-09-10","1989-12-10","1990-03-10","1990-06-10","1989-07-10","1989-09-10","1989-11-10","1990-01-10","1989-07-10","1989-09-10","1989-11-10","1990-01-10"]
[1990,"1990-09-10","1990-12-10","1991-03-10","1991-06-10","1990-07-10","1990-09-10","1990-11-10","1991-01-10","1990-07-10","1990-09-10","1990-11-10","1991-01-10"]
[1991,"1991-09-10","1991-12-10","1992-03-10","1992-06-10","1991-11-10","1992-01-10","1992-03-10","1992-05-10","1991-11-10","1992-01-10","1992-03-10","1992-05-10"]
[1992,"1992-09-10","1992-12-10","1993-03-10","1993-06-10","1992-07-10","1992-09-10","1992-11-10","1993-01-10","1992-07-10","1992-09-10","1992-11-10","1993-01-10"]
[1993,"1993-09-10","1993-12-10","1994-03-10","1994-06-10","1993-07-10","1993-09-10","1993-11-10","1994-01-10","1993-07-10","1993-09-10","1993-11-10","1994-01-10"]
[1994,"1994-09-10","1994-12-10","1995-03-10","1995-06-10","1994-07-10","1994-09-10","1994-11-10","1995-01-10","1994-07-10","1994-09-10","1994-11-10","1995-01-10"]
[1995,"1995-09-10","1995-12-10","1996-03-10","1996-06-10","1995-07-10","1995-09-10","1995-11-10","1996-01-10","1995-07-10","1995-09-10","1995-11-10","1996-01-10"]
[1996,"1996-09-10","1996-12-10","1997-03-10","1997-06-10","1996-07-10","1996-09-10","1996-11-10","1997-01-10","1996-07-10","1996-09-10","1996-11-10","1997-01-10"]
[1997,"1997-09-10","1997-12-10","1998-03-10","1998-06-10","1997-07-10","1997-09-10","1997-11-10","1998-01-10","1997-07-10","1997-09-10","1997-11-10","1998-01-10"]
[1998,"1998-09-15","1998-12-15","1999-03-15","1999-06-15","1998-07-15","1998-09-15","1998-11-15","1999-01-15","1998-07-15","1998-09-15","1998-11-15","1999-01-15"]
[1999,"1999-09-16","1999-12-16","2000-03-16","2000-06-16","1999-07-16","1999-09-16","1999-11-16","2000-01-16","1999-07-16","1999-09-16","1999-11-16","2000-01-16"]
[2000,"2000-09-16","2000-12-16","2001-03-16","2001-06-16","2000-07-16","2000-09-16","2000-11-16","2001-01-16","2000-04-10","2000-07-10","2000-10-10","2001-01-10"]
[2001,"2001-09-16","2001-12-16","2002-03-16","2002-06-16","2001-07-16","2001-09-16","2001-11-16","2002-01-16",{"$f":"J15+365","v":"2001-04-10"},{"$f":"K15+365","v":"2001-07-10"},{"$f":"L15+365","v":"2001-10-10"},{"$f":"M15+365","v":"2002-01-10"}]
[2002,"2002-09-16","2002-12-16","2003-03-16","2003-06-16","2002-07-16","2002-09-16","2002-11-16","2003-01-16",{"$f":"J16+365","v":"2002-04-10"},{"$f":"K16+365","v":"2002-07-10"},"2002-10-10","2003-01-10"]
[2003,"2003-09-16","2003-12-16","2004-03-16","2004-06-16","2003-07-16","2003-09-16","2003-11-16","2004-01-16","2003-04-10","2003-07-10","2003-10-10","2004-01-10"]
[2004,"2004-09-16","2004-12-16","2005-03-16","2005-06-16","2004-07-16","2004-09-16","2004-11-16","2005-01-16",{"$f":"J18+366","v":"2004-04-10"},{"$f":"K18+366","v":"2004-07-10"},{"$f":"L18+366","v":"2004-10-10"},{"$f":"M18+366","v":"2005-01-10"}]
[2005,"2005-09-16","2005-12-16","2006-03-16","2006-06-16","2005-07-16","2005-09-16","2005-11-16","2006-01-16","2005-04-10",{"$f":"K19+365","v":"2005-07-10"},{"$f":"L19+365","v":"2005-10-10"},{"$f":"M19+365","v":"2006-01-10"}]
[2006,"2006-09-16","2006-12-16","2007-03-16","2007-06-16","2006-07-16","2006-09-16","2006-11-16","2007-01-16","2006-04-10",{"$f":"K20+365","v":"2006-07-10"},"2006-10-10","2007-01-10"]
[2007,"2007-09-16","2007-12-16","2008-03-16","2008-06-16","2007-07-16","2007-09-16","2007-11-16","2008-01-16","2007-04-10",{"$f":"K21+365","v":"2007-07-10"},"2007-10-10","2008-01-10"]
[2008,"2008-09-16","2008-12-16","2009-03-16","2009-06-16","2008-07-16","2008-09-16","2008-11-16","2009-01-16",{"$f":"J22+366","v":"2008-04-10"},{"$f":"K22+366","v":"2008-07-10"},{"$f":"L22+366","v":"2008-10-10"},{"$f":"M22+366","v":"2009-01-10"}]
[2009,"2009-09-16","2009-12-16","2010-03-16","2010-06-16","2009-07-16","2009-09-16","2009-11-16","2010-01-16","2009-04-10",{"$f":"K23+365","v":"2009-07-10"},"2009-10-10","2010-01-10"]
[2010,"2010-09-16","2010-12-16","2011-03-16","2011-06-16","2010-07-16","2010-09-16","2010-11-16","2011-01-16","2010-04-10",{"$f":"K24+365","v":"2010-07-10"},"2010-10-10","2011-01-10"]
[2011,"2011-09-16","2011-12-16","2012-03-16","2012-06-16","2011-07-16","2011-09-16","2011-11-16","2012-01-16","2011-04-10",{"$f":"K25+365","v":"2011-07-10"},"2011-10-10","2012-01-10"]
[2012,{"$f":"B26+366","v":"2012-09-16"},{"$f":"C26+366","v":"2012-12-16"},{"$f":"D26+365","v":"2013-03-16"},{"$f":"E26+365","v":"2013-06-16"},{"$f":"F26+366","v":"2012-07-16"},"2012-09-16","2012-11-16","2013-01-16","2012-04-10","2012-07-10","2012-10-10","2013-01-10"]
[2013,{"$f":"B27+365","v":"2013-09-16"},"2013-12-16",{"$f":"D27+365","v":"2014-03-16"},{"$f":"E27+365","v":"2014-06-16"},{"$f":"F27+365","v":"2013-07-16"},{"$f":"G27+365","v":"2013-09-16"},{"$f":"H27+365","v":"2013-11-16"},{"$f":"I27+365","v":"2014-01-16"},"2013-04-10",{"$f":"K27+365","v":"2013-07-10"},"2013-10-10","2014-01-10"]
[2014,"2014-09-16","2014-12-16",{"$f":"D28+365","v":"2015-03-16"},"2015-06-16",{"$f":"F28+365","v":"2014-07-16"},"2014-09-16","2014-11-16","2015-01-16","2014-04-10",{"$f":"K28+365","v":"2014-07-10"},"2014-10-10","2015-01-10"]
[2015,"2015-09-16","2015-12-16",{"$f":"D29+366","v":"2016-03-16"},{"$f":"E29+366","v":"2016-06-16"},"2015-07-16","2015-09-16","2015-11-16","2016-01-16","2015-04-10",{"$f":"K29+365","v":"2015-07-10"},"2015-10-10",{"$f":"M29+365","v":"2016-01-10"}]
[2016,{"$f":"B30+366","v":"2016-09-16"},{"$f":"C30+366","v":"2016-12-16"},{"$f":"D30+365","v":"2017-03-16"},"2017-06-16",{"$f":"F30+366","v":"2016-07-16"},"2016-09-16","2016-11-16","2017-01-16","2016-04-10","2016-07-10","2016-10-10","2017-01-10"]
[2017,"2017-09-16","2017-12-16",{"$f":"D31+365","v":"2018-03-16"},"2018-06-16","2017-07-16","2017-09-16","2017-11-16","2018-01-16","2017-04-10",{"$f":"K31+365","v":"2017-07-10"},"2017-10-10","2018-01-10"]
[2018,"2018-09-16","2018-12-16",{"$f":"D32+365","v":"2019-03-16"},"2019-06-16","2018-07-16","2018-09-16","2018-11-16","2019-01-16","2018-04-10","2018-07-10","2018-10-10","2019-01-10"]
[2019,"2019-09-16","2019-12-16",{"$f":"D33+366","v":"2020-03-16"},{"$f":"E33+366","v":"2020-06-16"},"2019-07-16","2019-09-16","2019-11-16","2020-01-16","2019-04-10","2019-07-10","2019-10-10","2020-01-10"]
[2020,{"$f":"B34+366","v":"2020-09-16"},{"$f":"C34+366","v":"2020-12-16"},{"$f":"D34+365","v":"2021-03-16"},"2021-06-16",{"$f":"F34+366","v":"2020-07-16"},"2020-09-16","2020-11-16","2021-01-16","2020-04-10","2020-07-10","2020-10-10","2021-01-10"]

{"sheet":"help","index":12,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"Il pgm effettua il calcolo delle somme aggiuntive secondo"]
[null,null,"le nuove misure stabilite dal comma 8 dell'art.116 della "]
[null,null,"legge 23/12/2000 n° 388."]
[]
[null,null,"In pratica la procedura effettua 2 tipi di calcolo:"]
[]
[null,"1-","per i casi di morosità, applica come tasso annuo il tasso "]
[null,null,"ufficiale di riferimento, maggiorato di 5,5 punti,"]
[null,null,"con un tetto massimo del 40%."]
[null,null,"Raggiunto tale tetto la procedura applicherà, per i giorni"]
[null,null,"intercorrenti tra la data di raggiungimento del tetto e quella "]
[null,null,"del calcolo, sui soli contributi, gli interessi di mora"]
[null,null,"di cui all'art. 14 Dlgs n° 46/99."]
[]
[null,"2-","per i casi di evasione, applica il tasso annuo fisso del 30% "]
[null,null,"con un tetto massimo del 60%."]
[null,null,"Raggiunto tale tetto la procedura applicherà, per i giorni"]
[null,null,"intercorrenti tra la data di raggiungimento del tetto e quella "]
[null,null,"del calcolo, sui soli contributi, gli interessi di mora"]
[null,null,"di cui all'art. 14 Dlgs n° 46/99."]
[]
[null,null,"E' possibile effettuare il calcolo dei contributi divisi tra "]
[null,null,"previdenziali(IVS)e sanitari(SSN)."]
[]
[null,null,"Nella sezione INADEMPIENZA si inseriscono i valori del debito "]
[null,null,"originario, al lordo degli acconti."]
[null,null,"Nella sezione ACCONTI si inseriscono fino a 10 acconti."]
[]
[null,null,"Il programma effettua automaticamente il calcolo."]
[null,null,"Con i bottoni presenti sulla sinistra della videata è possibile "]
[null,null,"stampare il prospetto di calcolo o vedere l'anteprima di stampa. "]
[null,null,"E' possibile, inoltre, con i restanti bottoni,"]
[null,null,"azzerare tutti i campi di acquisizione o aggiornare i tassi per"]
[null,null,"la morosità (il tasso di riferimento perché i 5,5 punti in più "]
[null,null,"li mette in automatico)"]
[]
[null,null,"Se state leggendo queste brevi istruzioni avete già scoperto "]
[null,null,"l'utilizzo del tasto Help!"]

{"sheet":"calcolo interessi legali","index":13,"n_rows":43,"n_cols":40,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"DITTA:","Farmacia Dr. Provacalcolo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ditta:",{"$f":"E2","v":"Farmacia Dr. Provacalcolo"}]
[null,null,null,null,null,null,null,null,null,null,null,"anno calcolo",{"$f":"YEAR(E6)","v":2012},null,35450,null,null,null,null,null,null," ","INTERESSI ",null,null,null,null,null,null,null,null,null,"Cod.",{"$f":"E4","v":"12345678JK"},null,null,null,1995,null,"E"]
[null,null,null,"CODICE","12345678JK",null,null,null,null,null,"E"," ",null,null,null,null,null,null,null,null,null,null,"DI MORA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1996,null,"M"]
[null,null,null,null,null,null,null,null,null,null,"M"]
[null,null,null,"DATA ","2012-01-10",null,null,null,null,null,"I",{"$f":"E6","v":40918},null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($E$6,tassi,5)","v":5.024E-2},null,null,null,null,null,null,null,null,null,null,{"$f":"\"data calcolo: \"","v":"data calcolo: "},{"$f":"E6","v":"2012-01-10"},null,null,1997]
[null,null,null,"TIPO (E/M)",null,null,null,null,null,null,"MOROSITA' =1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TIPO EVENTO :",null,{"$f":"IF(#REF!=\"\",\" \",#REF!)","v":{"$error":"#REF!"}},null,null,1998]
[null,null,null,"TASSO CORRENTE.........................",null,null,null,null,null,null,"EVASIONE=2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1999]
[]
[null,null,null,"trimestre","anno","scadenza","importo contributi","tipo","tasso",null,"M 1",null,null,null,null,"EVASIONE","morosità","MOROSITA'","evasione","morosità","tasso",null,"interessi","interessi","int.legali","int.legali","int.legali","interessi",null,null,null,"ANNO",null,null,null,null,null,2000]
[null,null,null,null,null,null,"in EURO",null,null,null,"E 2",null,null,null,null,null,null,null,null,null,null,null,"evasione","morosità","giorni primo anno","anni","giorni ultimo anno","legali",null,null,"TRIM.",{"$f":"E12","v":2008},"IMPORTO"]
[null,null,null,null,2008,null,null,null,null,null,"I 3",null,null,null,"giorni totali","giorni evasione","giorni morosità",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCADENZE",null,null,null,null,null,2002]
[null,null,null,1,{"$f":"IF(F13=\"\",\" \",IF(F13<$F$12,\"data errata\",\" \"))","v":" "},{"$f":"IF(G13>0,DATE($E$12,5,16),\"\")","v":"2008-05-16"},400,"I",{"$f":"IF(G13=\"\",\" \",IF(H13=\"M\",VLOOKUP(E6,tassi!A1:F168,4),IF(H13=\"E\",VLOOKUP(E6,tassi!A1:F168,2),VLOOKUP(F13,tassi!A1:F168,6))))","v":0.03},null,{"$f":"IF(H13=\"M\",1,IF(H13=\"E\",2,3))","v":3},{"$f":"$E$6","v":"2012-01-10"},{"$f":"IF(F13=\"\",0,F13)","v":"2008-05-16"},null,{"$f":"IF(M13<>0,L13-M13,0)","v":1334},{"$f":"IF(O13>730,O13-730,0)","v":604},{"$f":"IF(K13=2,0,IF(V13=0,0,40/V13/100))","v":4800},{"$f":"IF(Q13=0,0,IF(O13<Q13,0,O13-Q13))","v":0},{"$f":"IF(O13<=0,0,IF(G13*O13*V13>0.6*G13,0.6*G13,G13*O13*V13))","v":44.466666666666669},{"$f":"IF(O13<=0,0,IF(G13*O13*V13>0.4*G13,0.4*G13,G13*O13*V13))","v":44.466666666666669},{"$f":"IF(I13=\" \",0,I13)","v":0.03},{"$f":"U13/360","v":8.3333333333333331E-5},{"$f":"IF(P13>0,G13*$W$6/365*P13,0)","v":33.254750684931508},{"$f":"IF(R13>0,G13*$W$6/365*R13,0)","v":0},null,null,null,{"$f":"G13*V13*O13","v":44.466666666666669},null,null,{"$f":"D13","v":1},{"$f":"IF(F13=\"\",\" \",F13)","v":"2008-05-16"},{"$f":"IF(G13>0,G13,0)","v":400},null,null,null,null,2003]
[null,null,null,2,{"$f":"IF(F14=\"\",\" \",IF(F14<$F$12,\"data errata\",\" \"))","v":" "},{"$f":"IF(G14>0,DATE($E$12,8,16),\"\")","v":"2008-08-16"},450,"I",{"$f":"IF(G14=\"\",\" \",IF(H14=\"M\",VLOOKUP(E7,tassi!A1:F168,4),IF(H14=\"E\",VLOOKUP(E7,tassi!A1:F168,2),VLOOKUP(F14,tassi!A1:F168,6))))","v":0.03},null,{"$f":"IF(H14=\"M\",1,IF(H14=\"E\",2,3))","v":3},{"$f":"$E$6","v":"2012-01-10"},{"$f":"IF(F14=\"\",0,F14)","v":"2008-08-16"},null,{"$f":"IF(M14<>0,L14-M14,0)","v":1242},{"$f":"IF(O14>730,O14-730,0)","v":512},{"$f":"IF(K14=2,0,IF(V14=0,0,40/V14/100))","v":4800},{"$f":"IF(Q14=0,0,IF(O14<Q14,0,O14-Q14))","v":0},{"$f":"IF(O14<=0,0,IF(G14*O14*V14>0.6*G14,0.6*G14,G14*O14*V14))","v":46.574999999999996},{"$f":"IF(O14<=0,0,IF(G14*O14*V14>0.4*G14,0.4*G14,G14*O14*V14))","v":46.574999999999996},{"$f":"IF(I14=\" \",0,I14)","v":0.03},{"$f":"U14/360","v":8.3333333333333331E-5},{"$f":"IF(P14>0,G14*$W$6/365*P14,0)","v":31.713139726027396},{"$f":"IF(R14>0,G14*$W$6/365*R14,0)","v":0},null,null,null,{"$f":"G14*V14*O14","v":46.574999999999996},null,null,{"$f":"D14","v":2},{"$f":"IF(F14=\"\",\" \",F14)","v":"2008-08-16"},{"$f":"IF(G14>0,G14,0)","v":450},null,null,null,null,2004]
[null,null,null,3,{"$f":"IF(F15=\"\",\" \",IF(F15<$F$12,\"data errata\",\" \"))","v":" "},{"$f":"IF(G15>0,DATE($E$12,11,16),\"\")","v":""},null,"I",{"$f":"IF(G15=\"\",\" \",IF(H15=\"M\",VLOOKUP(E8,tassi!A1:F168,4),IF(H15=\"E\",VLOOKUP(E8,tassi!A1:F168,2),VLOOKUP(F15,tassi!A1:F168,6))))","v":" "},null,{"$f":"IF(H15=\"M\",1,IF(H15=\"E\",2,3))","v":3},{"$f":"$E$6","v":"2012-01-10"},{"$f":"IF(F15=\"\",0,F15)","v":"00:00:00"},null,{"$f":"IF(M15<>0,L15-M15,0)","v":0},{"$f":"IF(O15>730,O15-730,0)","v":0},{"$f":"IF(K15=2,0,IF(V15=0,0,40/V15/100))","v":0},{"$f":"IF(Q15=0,0,IF(O15<Q15,0,O15-Q15))","v":0},{"$f":"IF(O15<=0,0,IF(G15*O15*V15>0.6*G15,0.6*G15,G15*O15*V15))","v":0},{"$f":"IF(O15<=0,0,IF(G15*O15*V15>0.4*G15,0.4*G15,G15*O15*V15))","v":0},{"$f":"IF(I15=\" \",0,I15)","v":0},{"$f":"U15/360","v":0},{"$f":"IF(P15>0,G15*$W$6/365*P15,0)","v":0},{"$f":"IF(R15>0,G15*$W$6/365*R15,0)","v":0},null,null,null,{"$f":"G15*V15*O15","v":0},null,null,{"$f":"D15","v":3},{"$f":"IF(F15=\"\",\" \",F15)","v":" "},{"$f":"IF(G15>0,G15,0)","v":0},null,null,null,null,2005]
[null,null,null,4,{"$f":"IF(F16=\"\",\" \",IF(F16<$F$12,\"data errata\",\" \"))","v":" "},{"$f":"IF(G16>0,DATE($E$12+1,2,16),\"\")","v":""},null,"I",{"$f":"IF(G16=\"\",\" \",IF(H16=\"M\",VLOOKUP(E9,tassi!A1:F168,4),IF(H16=\"E\",VLOOKUP(E9,tassi!A1:F168,2),VLOOKUP(F16,tassi!A1:F168,6))))","v":" "},null,{"$f":"IF(H16=\"M\",1,IF(H16=\"E\",2,3))","v":3},{"$f":"$E$6","v":"2012-01-10"},{"$f":"IF(F16=\"\",0,F16)","v":"00:00:00"},null,{"$f":"IF(M16<>0,L16-M16,0)","v":0},{"$f":"IF(O16>730,O16-730,0)","v":0},{"$f":"IF(K16=2,0,IF(V16=0,0,40/V16/100))","v":0},{"$f":"IF(Q16=0,0,IF(O16<Q16,0,O16-Q16))","v":0},{"$f":"IF(O16<=0,0,IF(G16*O16*V16>0.6*G16,0.6*G16,G16*O16*V16))","v":0},{"$f":"IF(O16<=0,0,IF(G16*O16*V16>0.4*G16,0.4*G16,G16*O16*V16))","v":0},{"$f":"IF(I16=\" \",0,I16)","v":0},{"$f":"U16/360","v":0},{"$f":"IF(P16>0,G16*$W$6/365*P16,0)","v":0},{"$f":"IF(R16>0,G16*$W$6/365*R16,0)","v":0},null,null,null,{"$f":"G16*V16*O16","v":0},null,null,{"$f":"D16","v":4},{"$f":"IF(F16=\"\",\" \",F16)","v":" "},{"$f":"IF(G16>0,G16,0)","v":0},null,null,null,null,2006]
[null,null,null,"valuta media",null,{"$f":"R17","v":"2008-07-01"},{"$f":"SUM(G13:G16)","v":850},null,null,null,{"$f":"IF(F13<>\"\",F13,\"\")","v":39584},{"$f":"IF(F14<>\"\",F14,\"\")","v":39676},{"$f":"IF(F15<>\"\",F15,\"\")","v":""},null,{"$f":"IF(F16<>\"\",F16,\"\")","v":""},{"$f":"SUM(K17:O17)","v":79260},{"$f":"COUNTA(G13:G16)","v":2},{"$f":"P17/Q17","v":39630},null,null,null,null,null,null,null,null,null,null,null,null,"valuta media",{"$f":"F17","v":"2008-07-01"},{"$f":"G17","v":850}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"da","a","tasso","giorni","interessi"]
[null,null,null,"da","a","tasso","giorni",null,"interessi"]
[null,null,null,{"$f":"$F$17","v":"2008-07-01"},{"$f":"$M$21","v":"2008-12-31"},{"$f":"IF(D21<>\" \",VLOOKUP(D21,tassi!A1:F168,6),\" \")","v":0.03},{"$f":"N21","v":180},null,{"$f":"IF(D21<>\" \",ROUND($G$17*F21/360*G21,),\" \")","v":13},null,{"$f":"F17","v":"2008-07-01"},{"$f":"YEAR(K21)","v":2008},{"$f":"DATE(L21,12,31)","v":"2008-12-31"},{"$f":"IF(K21<>\" \",DAYS360(K21,M21),\" \")","v":180},{"$f":"IF(K21<>\" \",M21-K21,\" \")","v":183},2000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D21","v":"2008-07-01"},{"$f":"E21","v":"2008-12-31"},{"$f":"F21","v":0.03},{"$f":"G21","v":180},{"$f":"I21","v":13}]
[null,null,null,{"$f":"IF(L22<=$M$3,K22,\" \")","v":"2009-01-01"},{"$f":"M22","v":"2009-12-31"},{"$f":"IF(D22<>\" \",VLOOKUP(D22,tassi!$A$1:$F$168,6),\" \")","v":0.03},{"$f":"N22","v":360},null,{"$f":"IF(D22<>\" \",ROUND($G$17*F22/360*G22,),\" \")","v":26},null,{"$f":"IF($M$3>L21,DATE(L21+1,1,1),\" \")","v":"2009-01-01"},{"$f":"IF(K22<>\" \",YEAR(K22),\" \")","v":2009},{"$f":"IF(K22<>\" \",IF(L22=$M$3,$E$6,DATE(L22,12,31)),\" \")","v":"2009-12-31"},{"$f":"IF(K22<>\" \",DAYS360(K22,M22),\" \")","v":360},{"$f":"IF(K22<>\" \",M22-K22,\" \")","v":364},2001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2009-01-01","2009-12-31",0.03,360,26]
[null,null,null,"2010-01-01","2010-12-31",{"$f":"IF(D23<>\" \",VLOOKUP(D23,tassi!$A$1:$F$168,6),\" \")","v":0.01},360,null,9,null,"2010-01-01",2010,"2010-12-31",360,364,2002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2010-01-01","2010-12-31",0.01,360,9]
[null,null,null,"2011-01-01","2011-12-31",{"$f":"IF(D24<>\" \",VLOOKUP(D24,tassi!$A$1:$F$168,6),\" \")","v":1.4999999999999999E-2},360,null,13,null,"2011-01-01",2011,"2011-12-31",360,364,2003,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2011-01-01","2011-12-31",1.4999999999999999E-2,360,13]
[null,null,null,"2012-01-01","2012-01-10",{"$f":"IF(D25<>\" \",VLOOKUP(D25,tassi!$A$1:$F$168,6),\" \")","v":2.5000000000000001E-2},9,null,1,null,"2012-01-01",2012,"2012-01-10",9,9,2004,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2012-01-01","2012-01-10",2.5000000000000001E-2,9,1]
[null,null,null," "," ",{"$f":"IF(D26<>\" \",VLOOKUP(D26,tassi!$A$1:$F$168,6),\" \")","v":" "}," ",null," ",null," "," "," "," "," ",2005,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "," "," "]
[null,null,null," "," ",{"$f":"IF(D27<>\" \",VLOOKUP(D27,tassi!$A$1:$F$168,6),\" \")","v":" "}," ",null," ",null," "," "," "," "," ",2006,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "," "," "]
[null,null,null," "," ",{"$f":"IF(D28<>\" \",VLOOKUP(D28,tassi!$A$1:$F$168,6),\" \")","v":" "}," ",null," ",null," "," "," "," "," ",2007,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "," "," "]
[null,null,null," "," ",{"$f":"IF(D29<>\" \",VLOOKUP(D29,tassi!$A$1:$F$168,6),\" \")","v":" "}," ",null," ",null," "," "," "," "," ",2008,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "," "," "]
[null,null,null," "," ",{"$f":"IF(D30<>\" \",VLOOKUP(D30,tassi!$A$1:$F$168,6),\" \")","v":" "}," ",null," ",null," "," "," "," "," ",2009,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "," "," "]
[null,null,null," "," ",{"$f":"IF(D31<>\" \",VLOOKUP(D31,tassi!$A$1:$F$168,6),\" \")","v":" "}," ",null," ",null," "," "," "," "," ",2010,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "," "," "]
[null,null,null,null,null,null,{"$f":"O32","v":" "},null,null,null," "," "," "," "," ",2011,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTALE",null,null,{"$f":"SUM(AH21:AH31)","v":1269},{"$f":"SUM(AI21:AI31)","v":62}]
[null,null,null,"TOTALE",null,null,{"$f":"SUM(G21:G32)","v":1269},null,{"$f":"SUM(I21:I32)","v":62},null," "," "," "," "," ",2012,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"totale contributi + interessi legali",null,{"$f":"AG17+AI32","v":912}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2013]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,2014]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,2015]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,2016]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,2017]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,2018]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,2019]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,2020]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"sanzaziende","index":14,"n_rows":47,"n_cols":53,"rows_kept":47,"cut":false,"hidden":false,"merged":[[5,44,5,45],[3,44,3,47],[3,41,3,42],[3,31,3,35],[4,31,4,35],[4,44,4,45]]}
[null,null,null,null,"DITTA:","dddd",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CALCOLO SANZIONI AZIENDE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35450,null,null,null,null,null,null,null,null," ","INTERESSI ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1995,null,"E"]
[null,null,null,null,"MATRICOLA",null,"8100000182",null,null,null,null,null,null," ","E",null,null,null,null,null,null,null,null,null,null,null,"DI MORA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"matricola:",{"$f":"G3","v":"8100000182"},null,null,1996,null,"M"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Per le nuove sanzioni introdotte dalla legge 183/2010",null,null,null,null,null,null,null,null,"data calcolo:",{"$f":"F5","v":"2015-07-10"},null,"ditta:",{"$f":"IF(F1=\"\",\" \",F1)","v":"dddd"}]
[null,null,null,null,"DATA ","2015-07-10",null,null,null,null,null,null,null,{"$f":"F5","v":42195},"X",null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($F$5,tassi,5)","v":4.8800000000000003E-2},null,null,null,null,"usare nel campo TIPO il valore X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1997]
[null,null,null,null,"TIPO (E/M)",null,"m",null,null,"EURO ",null,null,"MOROSITA' =1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,"TIPO EVENTO :",null,"N° Matricola ........….:",null,{"$f":"IF($G$3=\"\",\" \",$G$3)","v":"8100000182"},null,null,null,null,null,1998]
[null,null,null,null,"TASSO CORRENTE.........................",null,null,null,null,"EURO ",null,null,"EVASIONE=2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"e1\",1,IF(#REF!=\"e2\",1,IF(#REF!=\"e3\",1,2)))","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1999]
[null,null,null,null,null,null,null,null,null,"EURO ",null,null,null,null,null,null,null,"EVASIONE","morosità","nuova evasione","MOROSITA'","IVS","IVS","IVS",null,null,"IVS","IVS","IVS",null,null,null,null,null,null,null,"N.","ANNO","MESE","MESE","IMPORTO","EVAS.","TASSO","DATA","GG","SANZIONI","INTERESSI","TOTALE ",null,null,2000]
[null,null,null,null,"N.","Anno","INIZIO","FINE","Controllo data","IMPORTO CONTRIBUTI","TIPO     E/M","TASSO","flag morosità","DATA1","DATA2","MEDIA","GIORNI TOT.","GIORNIxINT.","giorni x 40%","GIORNIxINT.","GIORNIxINT.","SANZIONI EVASIONE","SANZIONI MOROSITA'","Nuove sanzioni evasione","TASSO","TASSO/GIORNI","INT. EVASIONE","INT. MOROSITA'","INT.Nuova evasione","  C",null,null,null,null,null,null,null,null,"INIZIO","FINE","CONTRIBUTI   IVS in EURO","MOR.","%","VALUTA",null,"Legge 388/00  ","DI MORA","SANZIONI",null,null,2001]
[null,null,null,null,1,2015,3,3,{"$f":"IF(F10=0,\" \",IF(H10<G10,\"data errata\",IF($F$5<AR10,\"data errata\",\"OK\")))","v":"OK"},11365,"m",{"$f":"IF(K10=\"\",\" \",IF(K10=\"M\",VLOOKUP($F$5,tassi,4),IF(K10=\"E\",VLOOKUP($F$5,tassi,2),45%)))","v":5.5500000000000001E-2},{"$f":"IF(K10=\"M\",1,IF(K10=\"E\",2,3))","v":1},{"$f":"IF(G10=0,0,IF(F10<1998,DATE(F10,G10+1,20),IF(AND(F10=1998,G10<4),DATE(F10,G10+1,20),IF(F10>1998,DATE(F10,G10+1,16),DATE(F10,G10+1,15)))))","v":"2015-04-16"},{"$f":"IF(H10=0,0,IF(F10<1998,DATE(F10,H10+1,20),IF(AND(F10=1998,H10<4),DATE(F10,H10+1,20),IF(F10>1998,DATE(F10,H10+1,16),DATE(F10,H10+1,15)))))","v":"2015-04-16"},{"$f":"AVERAGE(N10,O10)","v":"2015-04-16"},{"$f":"IF(P10<>0,$N$5-P10,0)","v":85},{"$f":"IF(Q10>730,Q10-730,0)","v":0},{"$f":"IF(M10=2,0,40/Z10/100)","v":2630.6306306306305},{"$f":"IF(Q10>730,Q10-730,0)","v":0},{"$f":"IF(S10=0,0,IF(Q10<S10,0,Q10-S10))","v":0},{"$f":"IF(Q10<=0,\"\",IF(J10*Q10*Z10>0.6*J10,0.6*J10,J10*Q10*Z10))","v":146.88873287671234},{"$f":"IF(Q10<=0,\"\",IF(J10*Q10*Z10>0.4*J10,0.4*J10,J10*Q10*Z10))","v":146.88873287671234},{"$f":"IF(Q10<=0,\"\",IF(J10*Q10*Z10>0.9*J10,0.9*J10,J10*Q10*Z10))","v":146.88873287671234},{"$f":"L10","v":5.5500000000000001E-2},{"$f":"Y10/365","v":1.5205479452054795E-4},{"$f":"IF(R10>0,J10*$AA$5/365*R10,\"\")","v":""},{"$f":"IF(U10>0,J10*$AA$5/365*U10,\"\")","v":""},{"$f":"IF(T10>0,J10*$AA$5/365*T10,\"\")","v":""},{"$f":"90*360+12*30+15","v":32775},null,null,null,null,null,null,{"$f":"E10","v":1},{"$f":"IF(F10>0,F10,\"\")","v":2015},{"$f":"IF(G10>0,G10,\"\")","v":3},{"$f":"IF(H10>0,H10,\"\")","v":3},{"$f":"IF(J10>0,J10,\"\")","v":11365},{"$f":"K10","v":"m"},{"$f":"IF(J10>0,Y10,\" \")","v":5.5500000000000001E-2},{"$f":"IF(F10>0,P10,\" \")","v":"2015-04-16"},{"$f":"IF(P10>0,INT(Q10),\"\")","v":85},{"$f":"IF(M10=1,W10,IF(M10=2,V10,X10))","v":146.88873287671234},{"$f":"IF(M10=1,AB10,IF(M10=2,AA10,AC10))","v":""},{"$f":"IF(Q10=0,\"\",SUMIF(AT10:AU10,\"<>\"\"\"))","v":146.88873287671234},null,null,2002]
[null,null,null,null,2,null,null,null,{"$f":"IF(F11=0,\" \",IF(H11<G11,\"data errata\",IF($F$5<AR11,\"data errata\",\"OK\")))","v":" "},null,null," ",{"$f":"IF(K11=\"M\",1,IF(K11=\"E\",2,3))","v":3},{"$f":"IF(G11=0,0,IF(F11<1998,DATE(F11,G11+1,20),IF(AND(F11=1998,G11<4),DATE(F11,G11+1,20),IF(F11>1998,DATE(F11,G11+1,16),DATE(F11,G11+1,15)))))","v":"00:00:00"},{"$f":"IF(H11=0,0,IF(F11<1998,DATE(F11,H11+1,20),IF(AND(F11=1998,H11<4),DATE(F11,H11+1,20),IF(F11>1998,DATE(F11,H11+1,16),DATE(F11,H11+1,15)))))","v":"00:00:00"},"00:00:00",0,0,{"$error":"#VALUE!"},{"$f":"IF(Q11>730,Q11-730,0)","v":0},{"$error":"#VALUE!"},"","",{"$f":"IF(Q11<=0,\"\",IF(J11*Q11*Z11>0.9*J11,0.9*J11,J11*Q11*Z11))","v":""}," ",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},{"$f":"IF(T11>0,J11*$AA$5/365*T11,\"\")","v":""},32775,null,null,null,null,null,null,2,"","","","",0,{"$f":"IF(J11>0,Y11,\" \")","v":" "}," ","",{"$f":"IF(M11=1,W11,IF(M11=2,V11,X11))","v":""},{"$f":"IF(M11=1,AB11,IF(M11=2,AA11,AC11))","v":""},"",null,null,2003]
[null,null,null,null,3,null,null,null,{"$f":"IF(F12=0,\" \",IF(H12<G12,\"data errata\",IF($F$5<AR12,\"data errata\",\"OK\")))","v":" "},null,null," ",3,"00:00:00","00:00:00","00:00:00",0,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},"","",""," ",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},"",32775,null,null,null,null,null,null,3,"","","","",0,{"$f":"IF(J12>0,Y12,\" \")","v":" "}," ","","","","",null,null,2004]
[null,null,null,null,4,null,null,null," ",null,null," ",3,"00:00:00","00:00:00","00:00:00",0,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},"","",""," ",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},"",32775,null,null,null,null,null,null,4,"","","","",0," "," ","","","","",null,null,2005]
[null,null,null,null,5,null,null,null," ",null,null," ",3,"00:00:00","00:00:00","00:00:00",0,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},"","",""," ",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},"",32775,null,"La data è quella in cui si ",null,null,null,null,5,"","","","",0," "," ","","","","",null,null,2006]
[null,null,null,null,6,null,null,null," ",null,null," ",3,"00:00:00","00:00:00","00:00:00",0,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},"","",""," ",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},"",32775,null,"effettua il calcolo",null,null,null,null,6,"","","","",0," "," ","","","","",null,null,2007]
[null,null,null,null,7,null,null,null," ",null,null," ",3,"00:00:00","00:00:00","00:00:00",0,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},"","",""," ",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},"",32775,null,null,null,null,null,null,7,"","","","",0," "," ","","","","",null,null,2008]
[null,null,null,null,8,null,null,null," ",null,null," ",3,"00:00:00","00:00:00","00:00:00",0,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},"","",""," ",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},"",32775,null,"L'importo dei contributi",null,null,null,null,8,"","","","",0," "," ","","","","",null,null,2009]
[null,null,null,null,9,null,null,null," ",null,null," ",3,"00:00:00","00:00:00","00:00:00",0,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},"","",""," ",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},"",32775,null,"è espresso in EURO",null,null,null,null,9,"","","","",0," "," ","","","","",null,null,2010]
[null,null,null,null,10,null,null,null," ",null,null," ",3,"00:00:00","00:00:00","00:00:00",0,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},"","",""," ",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},"",32775,null,null,null,null,null,null,10,"","","","",0," "," ","","","",""]
[null,null,null,null,11,null,null,null," ",null,null," ",3,"00:00:00","00:00:00","00:00:00",0,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},"","",""," ",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},"",32775,null,null,null,null,null,null,11,"","","","",0," "," ","","","",""]
[null,null,null,null,12,null,null,null," ",null,null," ",3,"00:00:00","00:00:00","00:00:00",0,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},"","",""," ",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},"",32775,null," Il programma è utilizzabile per ",null,null,null,null,12,"","","","",0," "," ","","","",""]
[null,null,null,null,13,null,null,null," ",null,null," ",3,"00:00:00","00:00:00","00:00:00",0,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},"","",""," ",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},"",32775,null," calcolare le sanzioni secondo ",null,null,null,null,13,"","","","",0," "," ","","","",""]
[null,null,null,null,14,null,null,null," ",null,null," ",3,"00:00:00","00:00:00","00:00:00",0,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},"","",""," ",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},"",32775,null," quanto disposto dalla legge ",null,null,null,null,14,"","","","",0," "," ","","","",""]
[null,null,null,null,15,null,null,null," ",null,null," ",3,"00:00:00","00:00:00","00:00:00",0,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},"","",""," ",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},"",32775,null," finanziaria 2001 (l. 388/00)",null,null,null,null,15,"","","","",0," "," ","","","",""]
[null,null,null,null,16,null,null,null," ",null,null," ",3,"00:00:00","00:00:00","00:00:00",0,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},"","",""," ",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},"",32775,null,null,null,null,null,null,16,"","","","",0," "," ","","","",""]
[null,null,null,null,17,null,null,null," ",null,null," ",3,"00:00:00","00:00:00","00:00:00",0,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},"","",""," ",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},"",32775,null,null,null,null,null,null,17,"","","","",0," "," ","","","",""]
[null,null,null,null,18,null,null,null," ",null,null," ",3,"00:00:00","00:00:00","00:00:00",0,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},"","",""," ",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},"",32775,null,"E'utilizzabile anche per i ",null,null,null,null,18,"","","","",0," "," ","","","",""]
[null,null,null,null,19,null,null,null," ",null,null," ",3,"00:00:00","00:00:00","00:00:00",0,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},"","",""," ",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},"",32775,null,"fallimenti.",null,null,null,null,19,"","","","",0," "," ","","","",""]
[null,null,null,null,20,null,null,null," ",null,null," ",3,"00:00:00","00:00:00","00:00:00",0,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},"","",""," ",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},"",32775,null,"Quindi con data di calcolo",null,null,null,null,20,"","","","",0," "," ","","","",""]
[null,null,null,null,21,null,null,null," ",null,null," ",3,"00:00:00","00:00:00","00:00:00",0,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},"","",""," ",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},"",32775,null,"anteriore al gennaio 2001",null,null,null,null,21,"","","","",0," "," ","","","",""]
[null,null,null,null,22,null,null,null," ",null,null," ",3,"00:00:00","00:00:00","00:00:00",0,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},"","",""," ",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},"",32775,null,null,null,null,null,null,22,"","","","",0," "," ","","","",""]
[null,null,null,null,23,null,null,null," ",null,null," ",3,"00:00:00","00:00:00","00:00:00",0,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},"","",""," ",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},"",32775,null,null,null,null,null,null,23,"","","","",0," "," ","","","",""]
[null,null,null,null,24,null,null,null," ",null,null," ",3,"00:00:00","00:00:00","00:00:00",0,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},"","",""," ",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},"",32775,null,null,null,null,null,null,24,"","","","",0," "," ","","","",""]
[null,null,null,null,25,null,null,null," ",null,null," ",3,"00:00:00","00:00:00","00:00:00",0,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},"","",""," ",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},"",32775,null,null,null,null,null,null,25,"","","","",0," "," ","","","",""]
[null,null,null,null,26,null,null,null," ",null,null," ",3,"00:00:00","00:00:00","00:00:00",0,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},"","",""," ",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},"",32775,null,null,null,null,null,null,26,"","","","",0," "," ","","","",""]
[null,null,null,null,27,null,null,null," ",null,null," ",3,"00:00:00","00:00:00","00:00:00",0,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},"","",""," ",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},"",32775,null,null,null,null,null,null,27,"","","","",0," "," ","","","",""]
[null,null,null,null,28,null,null,null," ",null,null," ",3,"00:00:00","00:00:00","00:00:00",0,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},"","",""," ",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},"",32775,null,null,null,null,null,null,28,"","","","",0," "," ","","","",""]
[null,null,null,null,29,null,null,null," ",null,null," ",3,"00:00:00","00:00:00","00:00:00",0,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},"","",""," ",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},"",32775,null,null,null,null,null,null,29,"","","","",0," "," ","","","",""]
[null,null,null,null,30,null,null,null,{"$f":"IF(F39=0,\" \",IF(H39<G39,\"data errata\",IF($F$5<AR39,\"data errata\",\"OK\")))","v":" "},null,null," ",3,"00:00:00","00:00:00","00:00:00",0,0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},"","",""," ",{"$error":"#VALUE!"},"",{"$error":"#VALUE!"},"",32775,null,null,null,null,null,null,30,"","","","",0," "," ","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J10:J39)","v":11365},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AO10:AO39)","v":11365},null,null,null,null,{"$f":"SUM(AT10:AT39)","v":146.88873287671234},{"$f":"SUM(AU10:AU39)","v":0},{"$f":"SUM(AV10:AV39)","v":146.88873287671234}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,"QUADRO RIEPILOGATIVO",null,null,"IVS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTALE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," A)","CONTRIBUZIONE EVASA ............................",null,null,null,null,null,null,{"$f":"ROUND(AO40,)","v":11365}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," B)","AMMONTARE SANZIONI .............................",null,null,null,null,null,null,{"$f":"ROUND(AT40,0)","v":147}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," C)","INTERESSI DI MORA …………………………",null,null,null,null,null,null,{"$f":"ROUND(AU40,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D)","SANZIONI + INTERESSI",null,null,null,null,null,null,{"$f":"SUM(AT44:AT45)","v":147}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," TOTALE DEBITO  .............................................",null,null,null,null,null,null,null,{"$f":"SUM(AT43:AT45)","v":11512}]

{"sheet":"Domestici","index":15,"n_rows":30,"n_cols":40,"rows_kept":30,"cut":false,"hidden":false,"merged":[[11,30,11,32]]}
[]
[]
[null,null,null,null,"CALCOLO SANZIONI L.388/2000"]
[]
[]
[]
[null,null,null,null,"Dat. Lav.:","Caio Alberto",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CALCOLO SANZIONI L.388/2000 lavoratori domestici"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,35450,null,null,null,null,null,null," ","INTERESSI ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1995,null,"E"]
[null,null,null,null,"Lavoratore","Tizia Maria",null,null,null,null,null,"E"," ",null,null,null,null,null,null,null,null,null,"DI MORA",null,null,null,null,null,"datore di lavoro :",{"$f":"F7","v":"Caio Alberto"},null,null,"lavoratore domestico :",null,{"$f":"F9","v":"Tizia Maria"},null,null,1996,null,"M"]
[null,null,null,null,null,null,null,null,null,null,null,"M"]
[null,null,null,null,"DATA ","2015-03-10",null,"DOMESTICI",null,null,null,null,{"$f":"F11","v":42073},null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($F$11,tassi,5)","v":5.1400000000000001E-2},null,null,null,null,null,"data calcolo:",{"$f":"F11","v":"2015-03-10"},null,null,null,null,null,null,null,1997]
[null,null,null,null,"TIPO (E/M)",null,null,null,null,null,null,"MOROSITA' =1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TIPO EVENTO :",null,{"$f":"IF(#REF!=\"\",\" \",#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,null,1998]
[null,null,null,null,"TASSO CORRENTE.........................",null,null,null,null,null,null,"EVASIONE=2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1999]
[]
[null,null,null,null,"trimestre","anno","scadenza","importo contributi","e/m","tasso",null,"M 1",null,null,null,"EVASIONE","morosità","MOROSITA'","evasione","morosità",null,null,"interessi","interessi",null,null,null,"ANNO",null,null,null,null,null,null,null,null,null,2000]
[null,null,null,null,null,null,null,null,null,null,null,"E 2",null,null,null,null,null,null,null,null,null,null,"evasione","morosità",null,null,"TRIM.",{"$f":"F17","v":2013},"IMPORTO","E/M","GIORNI","TASSO","SANZIONI","INTERESSI","TOTALE"]
[null,null,null,null,null,2013,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCADENZE",null,null,null,null,null,null,null,null,null,2002]
[null,null,null,null,1,null,{"$f":"VLOOKUP(F17,scadenze,10)","v":"2013-04-10"},1000,"E",{"$f":"IF(H18=\"\",\" \",IF(I18=\"M\",VLOOKUP(F11,tassi,4),VLOOKUP(F11,tassi,2)))","v":0.3},null,{"$f":"IF(I18=\"M\",1,2)","v":2},{"$f":"$F$11","v":"2015-03-10"},{"$f":"IF(G18=\"\",0,G18)","v":"2013-04-10"},{"$f":"IF(N18<>0,M18-N18,0)","v":699},{"$f":"IF(O18>730,O18-730,0)","v":0},{"$f":"IF(L18=2,0,IF(V18=0,0,40/V18/100))","v":0},{"$f":"IF(Q18=0,0,IF(O18<Q18,0,O18-Q18))","v":0},{"$f":"IF(O18<=0,0,IF(H18*O18*V18>0.6*H18,0.6*H18,H18*O18*V18))","v":574.52054794520541},{"$f":"IF(O18<=0,0,IF(H18*O18*V18>0.4*H18,0.4*H18,H18*O18*V18))","v":400},{"$f":"IF(J18=\" \",0,J18)","v":0.3},{"$f":"U18/365","v":8.2191780821917802E-4},{"$f":"IF(P18>0,H18*$W$11/365*P18,0)","v":0},{"$f":"IF(R18>0,H18*$W$11/365*R18,0)","v":0},null,null,{"$f":"E18","v":1},{"$f":"IF(G18=\"\",\" \",G18)","v":"2013-04-10"},{"$f":"IF(H18>0,H18,0)","v":1000},{"$f":"I18","v":"E"},{"$f":"IF(AC18>0,INT(O18),0)","v":699},{"$f":"IF(J18=\"\",\" \",J18)","v":0.3},{"$f":"IF(L18=1,T18,S18)","v":574.52054794520541},{"$f":"IF(L18=1,X18,W18)","v":0},{"$f":"ROUND(AG18+AH18,)","v":575},null,null,2003]
[null,null,null,null,2,null,{"$f":"VLOOKUP(F17,scadenze,11)","v":"2013-07-10"},null,null,{"$f":"IF(H19=\"\",\" \",IF(I19=\"M\",VLOOKUP(F11,tassi,4),VLOOKUP(F11,tassi,2)))","v":" "},null,{"$f":"IF(I19=\"M\",1,2)","v":2},{"$f":"$F$11","v":"2015-03-10"},{"$f":"IF(G19=\"\",0,G19)","v":"2013-07-10"},{"$f":"IF(N19<>0,M19-N19,0)","v":608},{"$f":"IF(O19>730,O19-730,0)","v":0},{"$f":"IF(L19=2,0,IF(V19=0,0,40/V19/100))","v":0},{"$f":"IF(Q19=0,0,IF(O19<Q19,0,O19-Q19))","v":0},{"$f":"IF(O19<=0,0,IF(H19*O19*V19>0.6*H19,0.6*H19,H19*O19*V19))","v":0},{"$f":"IF(O19<=0,0,IF(H19*O19*V19>0.4*H19,0.4*H19,H19*O19*V19))","v":0},{"$f":"IF(J19=\" \",0,J19)","v":0},{"$f":"U19/365","v":0},{"$f":"IF(P19>0,H19*$W$11/365*P19,0)","v":0},{"$f":"IF(R19>0,H19*$W$11/365*R19,0)","v":0},null,null,{"$f":"E19","v":2},{"$f":"IF(G19=\"\",\" \",G19)","v":"2013-07-10"},{"$f":"IF(H19>0,H19,0)","v":0},{"$f":"I19","v":0},{"$f":"IF(AC19>0,INT(O19),0)","v":0},{"$f":"IF(J19=\"\",\" \",J19)","v":" "},{"$f":"IF(L19=1,T19,S19)","v":0},{"$f":"IF(L19=1,X19,W19)","v":0},{"$f":"ROUND(AG19+AH19,)","v":0},null,null,2004]
[null,null,null,null,3,null,{"$f":"VLOOKUP(F17,scadenze,12)","v":"2013-10-10"},null,null,{"$f":"IF(H20=\"\",\" \",IF(I20=\"M\",VLOOKUP(F11,tassi,4),VLOOKUP(F11,tassi,2)))","v":" "},null,{"$f":"IF(I20=\"M\",1,2)","v":2},{"$f":"$F$11","v":"2015-03-10"},{"$f":"IF(G20=\"\",0,G20)","v":"2013-10-10"},{"$f":"IF(N20<>0,M20-N20,0)","v":516},{"$f":"IF(O20>730,O20-730,0)","v":0},{"$f":"IF(L20=2,0,IF(V20=0,0,40/V20/100))","v":0},{"$f":"IF(Q20=0,0,IF(O20<Q20,0,O20-Q20))","v":0},{"$f":"IF(O20<=0,0,IF(H20*O20*V20>0.6*H20,0.6*H20,H20*O20*V20))","v":0},{"$f":"IF(O20<=0,0,IF(H20*O20*V20>0.4*H20,0.4*H20,H20*O20*V20))","v":0},{"$f":"IF(J20=\" \",0,J20)","v":0},{"$f":"U20/365","v":0},{"$f":"IF(P20>0,H20*$W$11/365*P20,0)","v":0},{"$f":"IF(R20>0,H20*$W$11/365*R20,0)","v":0},null,null,{"$f":"E20","v":3},{"$f":"IF(G20=\"\",\" \",G20)","v":"2013-10-10"},{"$f":"IF(H20>0,H20,0)","v":0},{"$f":"I20","v":0},{"$f":"IF(AC20>0,INT(O20),0)","v":0},{"$f":"IF(J20=\"\",\" \",J20)","v":" "},{"$f":"IF(L20=1,T20,S20)","v":0},{"$f":"IF(L20=1,X20,W20)","v":0},{"$f":"ROUND(AG20+AH20,)","v":0},null,null,2005]
[null,null,null,null,4,null,{"$f":"VLOOKUP(F17,scadenze,13)","v":"2014-01-10"},null,null,{"$f":"IF(H21=\"\",\" \",IF(I21=\"M\",VLOOKUP(F11,tassi,4),VLOOKUP(F11,tassi,2)))","v":" "},null,{"$f":"IF(I21=\"M\",1,2)","v":2},{"$f":"$F$11","v":"2015-03-10"},{"$f":"IF(G21=\"\",0,G21)","v":"2014-01-10"},{"$f":"IF(N21<>0,M21-N21,0)","v":424},{"$f":"IF(O21>730,O21-730,0)","v":0},{"$f":"IF(L21=2,0,IF(V21=0,0,40/V21/100))","v":0},{"$f":"IF(Q21=0,0,IF(O21<Q21,0,O21-Q21))","v":0},{"$f":"IF(O21<=0,0,IF(H21*O21*V21>0.6*H21,0.6*H21,H21*O21*V21))","v":0},{"$f":"IF(O21<=0,0,IF(H21*O21*V21>0.4*H21,0.4*H21,H21*O21*V21))","v":0},{"$f":"IF(J21=\" \",0,J21)","v":0},{"$f":"U21/365","v":0},{"$f":"IF(P21>0,H21*$W$11/365*P21,0)","v":0},{"$f":"IF(R21>0,H21*$W$11/365*R21,0)","v":0},null,null,{"$f":"E21","v":4},{"$f":"IF(G21=\"\",\" \",G21)","v":"2014-01-10"},{"$f":"IF(H21>0,H21,0)","v":0},{"$f":"I21","v":0},{"$f":"IF(AC21>0,INT(O21),0)","v":0},{"$f":"IF(J21=\"\",\" \",J21)","v":" "},{"$f":"IF(L21=1,T21,S21)","v":0},{"$f":"IF(L21=1,X21,W21)","v":0},{"$f":"ROUND(AG21+AH21,)","v":0},null,null,2006]
[null,null,null,null,null,"TOTALE ",null,{"$f":"SUM(H18:H21)","v":1000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTALE",{"$f":"SUM(AC18:AC21)","v":1000},null,null,null,{"$f":"SUM(AG18:AG21)","v":574.52054794520541},{"$f":"SUM(AH18:AH21)","v":0},{"$f":"ROUND(AG22+AH22,)","v":575}]
[]
[]
[null,null,null,null,{"$f":"IF(F17=1998,\"N.B. LE SCADENZE SONO RELATIVE AI TITOLARI DI PARTITA IVA\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," A)","TOTALE CONTRIBUTI",null,null,null,{"$f":"ROUND(AC22,)","v":1000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," B)","TOTALE SANZIONI",null,null,null,{"$f":"ROUND(AG22,)","v":575}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," C)","TOTALE INTERESSI DI MORA",null,null,null,{"$f":"ROUND(AH22,)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," D)","TOTALE SANZIONI + INTERESSI",null,null,null,{"$f":"AI22","v":575}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," TOTALE DEBITO  .............................................",null,null,null,null,{"$f":"AG26+AG29","v":1575}]