{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Pensione","Pensione nota op.","ire 2012","ire 2012 nota op.","tabprev"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":84,"comments":5,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Pensione","index":0,"n_rows":55,"n_cols":26,"rows_kept":55,"cut":false,"hidden":false,"merged":[[5,0,5,1],[6,0,6,1],[14,0,14,1],[11,0,11,1],[0,0,0,14],[10,0,10,1],[4,0,4,1],[7,0,7,1],[1,11,1,13],[1,6,1,9],[1,0,1,5],[3,0,3,1],[2,0,2,6],[2,7,2,14],[12,0,12,3],[13,0,13,6],[3,7,3,11],[13,7,13,11],[14,7,14,11],[5,7,5,14],[6,7,6,11],[7,7,7,11],[4,7,4,11],[8,7,8,11],[12,7,12,11],[10,7,10,11],[9,7,9,11],[11,7,11,11],[8,0,8,1],[9,0,9,1],[54,12,54,13],[52,12,52,13],[53,10,53,11],[54,10,54,11],[51,10,51,11],[51,12,51,13],[53,12,53,13],[15,7,15,11],[19,7,19,14],[18,0,18,1],[19,0,19,3],[18,7,18,11],[17,0,17,1],[16,0,16,1],[15,0,15,1],[17,7,17,11],[54,6,54,7],[54,4,54,5],[54,0,54,3],[51,6,51,7],[53,9,54,9],[52,8,53,8],[52,6,53,7],[52,4,52,5],[52,0,52,3],[53,0,53,3],[53,4,53,5],[51,0,51,3],[49,0,49,1],[31,0,31,14],[30,0,30,14],[51,4,51,5],[50,10,50,13],[50,6,50,9],[49,9,49,14],[50,14,52,14],[52,10,52,11],[50,0,50,5],[23,0,23,1],[24,0,24,1],[20,7,21,11],[29,7,29,12],[26,7,26,10],[20,0,20,6],[28,7,28,10],[21,0,21,1],[25,0,25,1],[26,0,26,3],[27,7,27,10],[23,7,24,11],[22,7,22,14],[25,7,25,14],[22,0,22,1]]}
["DIGITARE SOLO I DATI COMPRESI NELLE CELLE BORDATE CON LINEA DOPPIA\n(Il calcolo non tiene conto della Nota Operativa Inpdap n. 26 del 13.06.2008: anzianità contributiva > 40 anni)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"anno cess.",{"$f":"YEAR(DATE(YEAR($O$2),MONTH($O$2)-$N$22,1))","v":2012},"aliq.norm.prec.",{"$f":"INDEX($T$3:$T$43,MATCH($M$22,$S$3:$S$43))+IF($M$22=40,0,(INDEX($T$3:$T$43,MATCH($M$22+1,$S$3:$S$43,0))-INDEX($T$3:$T$43,MATCH($M$22,$S$3:$S$43,0)))/12*$N$22)","v":0.8},"aliq.norm.succ.",{"$f":"INDEX($V$3:$V$43,MATCH($M$22,$S$3:$S$43,0))+IF($M$22=40,0,(INDEX($V$3:$V$43,MATCH($M$22+1,$S$3:$S$43,0))-INDEX($V$3:$V$43,MATCH($M$22,$S$3:$S$43,0)))/12*$N$22)","v":0.8340000000000003}]
["Attenzione! Verificare comp.accessorie",null,null,null,null,null,"Pinco Pallino",null,null,null,null,"Data di cessazione:",null,null,{"$f":"MAX($D$6:$D$12,$D$16:$D$19,$D$23:$D$26)","v":"2012-02-29"},null,null,null,"anni contr.","ali.prec.","anni","aliq.calc.","aliq.da appl."]
["Calcolo Servizi Utili fino al 31.12.92",null,null,null,null,null,null,"Calcolo aliquota di pensione Servizi Utili al 31.12.92",null,null,null,null,null,null,null,null,null,null,{"$f":"tabprev!A3","v":0},{"$f":"tabprev!B3","v":0},{"$f":"YEAR($C$6)","v":1971},{"$f":"IF(S3=0,0,IF(U3<1995,T3,V2+0.02))","v":0},{"$f":"MIN(T3,V3)","v":0}]
["mansione",null,"dal:","al:","anni:","mesi:","giorni:",null,null,null,null,null,"anni:","mesi:","aliquota (b)",null,null,null,{"$f":"tabprev!A4","v":1},{"$f":"tabprev!B4","v":2.3300000000000001E-2},{"$f":"U3+1","v":1972},{"$f":"IF(S4=0,0,IF(U4<1995,T4,V3+0.02))","v":2.3300000000000001E-2},{"$f":"MIN(T4,V4)","v":2.3300000000000001E-2}]
["figurativo",null,"1969-06-08","1970-09-06",{"$f":"IF(AND(C5<>\"\",D5<>\"\"),FLOOR((DAYS360(C5,D5+1,TRUE))/360,1),0)","v":1},{"$f":"IF(AND(C5<>\"\",D5<>\"\"),FLOOR(((DAYS360(C5,D5+1,TRUE))-E5*360)/30,1),0)","v":2},{"$f":"IF(AND(C5<>\"\",D5<>\"\"),(DAYS360(C5,D5+1,TRUE))-E5*360-F5*30,0)","v":29},"Servizi utili fino al 31.12.92 in anni e mesi",null,null,null,null,{"$f":"IF(E13=\"errore\",0,E13)","v":23},{"$f":"IF(E13=\"errore\",0,ROUND(SUM(F13*30+G13-1)/30,0))","v":2},{"$f":"INDEX($W$3:$W$43,MATCH($M5,$S$3:$S$43,0))+(INDEX($W$3:$W$43,MATCH($M5+1,$S$3:$S$43,0))-INDEX($W$3:$W$43,MATCH($M5,$S$3:$S$43,0)))/12*N5","v":0.497},null,null,null,{"$f":"tabprev!A5","v":2},{"$f":"tabprev!B5","v":4.6699999999999998E-2},{"$f":"U4+1","v":1973},{"$f":"IF(S5=0,0,IF(U5<1995,T5,V4+0.02))","v":4.6699999999999998E-2},{"$f":"MIN(T5,V5)","v":4.6699999999999998E-2}]
[null,null,"1971-01-15","1974-06-25",3,5,11,"Calcolo Quota A pensione annua (anzian.al 31.12.92)",null,null,null,null,null,null,null,null,null,null,{"$f":"tabprev!A6","v":3},{"$f":"tabprev!B6","v":7.0000000000000007E-2},1974,7.0000000000000007E-2,7.0000000000000007E-2]
[null,null,"1974-06-26","1992-12-31",18,6,5,{"$f":"\"- Stipendio annuo lordo alla data di cessaz.\"","v":"- Stipendio annuo lordo alla data di cessaz."},null,null,null,null,{"$f":"$F$34","v":22100},{"$f":"\"+\"","v":"+"},null,null,null,null,{"$f":"tabprev!A7","v":4},{"$f":"tabprev!B7","v":9.3299999999999994E-2},1975,9.3299999999999994E-2,9.3299999999999994E-2]
[null,null,null,null,0,0,0,{"$f":"\"- Retribuz. individ. anzianità alla data di cessazione\"","v":"- Retribuz. individ. anzianità alla data di cessazione"},null,null,null,null,{"$f":"$G$34","v":2000},"+",null,null,null,null,{"$f":"tabprev!A8","v":5},{"$f":"tabprev!B8","v":0.1167},1976,0.1167,0.1167]
[null,null,null,null,0,0,0,{"$f":"\"- Assegno pers. ex Agensud alla data di cessazione\"","v":"- Assegno pers. ex Agensud alla data di cessazione"},null,null,null,null,{"$f":"$H$34","v":0},"+",null,null,null,null,{"$f":"tabprev!A9","v":6},{"$f":"tabprev!B9","v":0.14000000000000001},1977,0.14000000000000001,0.14000000000000001]
[null,null,null,null,0,0,0,{"$f":"\"- Assegno pers. L. 239/04 alla data di cessazione\"","v":"- Assegno pers. L. 239/04 alla data di cessazione"},null,null,null,null,{"$f":"$I$34","v":300},"=",null,null,null,null,{"$f":"tabprev!A10","v":7},{"$f":"tabprev!B10","v":0.1633},1978,0.1633,0.1633]
[null,null,null,null,0,0,0,{"$f":"\"- Incremento voci precedenti del 18%\"","v":"- Incremento voci precedenti del 18%"},null,null,null,null,{"$f":"18%*SUM(M7:M10)","v":4392},"+",null,null,null,null,{"$f":"tabprev!A11","v":8},{"$f":"tabprev!B11","v":0.1867},1979,0.1867,0.1867]
[null,null,null,null,0,0,0,{"$f":"\"- I.I.S. annua alla data di cessazione\"","v":"- I.I.S. annua alla data di cessazione"},null,null,null,null,{"$f":"$K$34","v":6641.4000000000005},"+",null,null,null,null,{"$f":"tabprev!A12","v":9},{"$f":"tabprev!B12","v":0.21},1980,0.21,0.21]
["Totale Servizi utili al 31.12.92",null,null,null,{"$f":"SUM(SUM($E$5:$E$12),INT(INT(SUM($F$5:$F$12)+INT(SUM($G$5:$G$12)/30))/12))","v":23},{"$f":"MOD(SUM(SUM($F$5:$F$12),INT(SUM($G$5:$G$12)/30)),12)","v":2},{"$f":"MOD(SUM($G$5:$G$12),30)","v":15},{"$f":"\"- Indennità di amministraz. alla data di cessazione\"","v":"- Indennità di amministraz. alla data di cessazione"},null,null,null,null,null,"+",null,null,null,null,{"$f":"tabprev!A13","v":10},{"$f":"tabprev!B13","v":0.23330000000000001},1981,0.23330000000000001,0.23330000000000001]
["Calcolo Servizi Utili dal 1.1.93 fino al 31.12.95",null,null,null,null,null,null,"Base pensionabile (Totale)",null,null,null,null,{"$f":"SUM(M$7:M$13)","v":35433.4},{"$f":"\"x\"","v":"x"},null,null,null,null,{"$f":"tabprev!A14","v":11},{"$f":"tabprev!B14","v":0.25669999999999998},1982,0.25669999999999998,0.25669999999999998]
["mansione",null,"dal:","al:","anni:","mesi:","giorni:","Aliquota di pensione al 31.12.92",null,null,null,null,{"$f":"O5","v":0.497},{"$f":"\"=\"","v":"="},null,null,null,null,{"$f":"tabprev!A15","v":12},{"$f":"tabprev!B15","v":0.28000000000000003},1983,0.28000000000000003,0.28000000000000003]
[null,null,"1993-01-01","1993-10-12",{"$f":"IF(AND(C16<>\"\",D16<>\"\"),FLOOR((DAYS360(C16,D16+1,TRUE))/360,1),0)","v":0},{"$f":"IF(AND(C16<>\"\",D16<>\"\"),FLOOR(((DAYS360(C16,D16+1,TRUE))-E16*360)/30,1),0)","v":9},{"$f":"IF(AND(C16<>\"\",D16<>\"\"),(DAYS360(C16,D16+1,TRUE))-E16*360-F16*30,0)","v":12},"Quota A di pensione annua",null,null,null,null,{"$f":"M14*M15","v":17610.399799999999},null,null,null,null,null,{"$f":"tabprev!A16","v":13},{"$f":"tabprev!B16","v":0.30330000000000001},1984,0.30330000000000001,0.30330000000000001]
[null,null,"1993-10-13","1995-12-31",{"$f":"IF(AND(C17<>\"\",D17<>\"\"),FLOOR((DAYS360(C17+1,D17,TRUE))/360,1),0)","v":2},{"$f":"IF(AND(C17<>\"\",D17<>\"\"),FLOOR(((DAYS360(C17,D17+1,TRUE))-E17*360)/30,1),0)","v":2},{"$f":"IF(AND(C17<>\"\",D17<>\"\"),(DAYS360(C17,D17+1,TRUE))-E17*360-F17*30,0)","v":18},null,null,null,null,null,"anni:","mesi:","giorni:",null,null,null,{"$f":"tabprev!A17","v":14},{"$f":"tabprev!B17","v":0.32669999999999999},1985,0.32669999999999999,0.32669999999999999]
[null,null,null,null,{"$f":"IF(AND(C18<>\"\",D18<>\"\"),FLOOR((DAYS360(C18+1,D18,TRUE))/360,1),0)","v":0},{"$f":"IF(AND(C18<>\"\",D18<>\"\"),FLOOR(((DAYS360(C18,D18+1,TRUE))-E18*360)/30,1),0)","v":0},{"$f":"IF(AND(C18<>\"\",D18<>\"\"),(DAYS360(C18,D18+1,TRUE))-E18*360-F18*30,0)","v":0},"Servizio utile dal 1.1.93 alla data di cessazione",null,null,null,null,{"$f":"SUM($E$20,$E$27,INT(SUM(INT(SUM($G$20,$G$27)/30),$F$20,$F$27)/12))","v":19},{"$f":"MOD(SUM($F$20,$F$27,INT(SUM($G$20,$G$27)/30)),12)","v":2},{"$f":"MOD(SUM($G$20,$G$27),30)","v":0},null,null,null,{"$f":"tabprev!A18","v":15},{"$f":"tabprev!B18","v":0.35},1986,0.35,0.35]
[null,null,null,null,{"$f":"IF(AND(C19<>\"\",D19<>\"\"),FLOOR((DAYS360(C19+1,D19,TRUE))/360,1),0)","v":0},{"$f":"IF(AND(C19<>\"\",D19<>\"\"),FLOOR(((DAYS360(C19,D19+1,TRUE))-E19*360)/30,1),0)","v":0},{"$f":"IF(AND(C19<>\"\",D19<>\"\"),(DAYS360(C19,D19+1,TRUE))-E19*360-F19*30,0)","v":0},"Servizio utile alla data di cessazione",null,null,null,null,{"$f":"MIN(40,SUM($E$13,$M$18,INT(INT(SUM($F$13,$N$18)+INT(SUM($G$13,$O$18)/30))/12)))","v":40},{"$f":"IF(M19=40,0,MOD(SUM($F$13,$N$18,INT(SUM($G$13,$O$18)/30)),12))","v":0},{"$f":"IF(M19=40,0,MOD(SUM($G$13,$O$18),30))","v":0},null,null,null,{"$f":"tabprev!A19","v":16},{"$f":"tabprev!B19","v":0.36799999999999999},1987,0.36799999999999999,0.36799999999999999]
["Tot. Servizi utili dal 1.1.93 al 31.12.95",null,null,null,{"$f":"SUM(SUM($E$16:$E$19),INT(INT(SUM($F$16:$F$19)+INT(SUM($G$16:$G$19)/30))/12))","v":3},{"$f":"MOD(SUM(SUM($F$16:$F$19),INT(SUM($G$16:$G$19)/30)),12)","v":0},{"$f":"MOD(SUM($G$16:$G$19),30)","v":0},"Calcolo aliquota di pensione alla data di cessazione",null,null,null,null,null,null,null,null,null,null,{"$f":"tabprev!A20","v":17},{"$f":"tabprev!B20","v":0.38600000000000001},1988,0.38600000000000001,0.38600000000000001]
["Calcolo Servizi Utlili dal 1.1.96 fino alla data di cessazione",null,null,null,null,null,null,null,null,null,null,null,"anni:","mesi:","aliquota (a)",null,null,null,{"$f":"tabprev!A21","v":18},{"$f":"tabprev!B21","v":0.40400000000000003},1989,0.40400000000000003,0.40400000000000003]
["mansione",null,"dal:","al:","anni:","mesi:","giorni:",null,null,null,null,null,{"$f":"SUM($M$19,INT(ROUND(SUM($N$19*30+$O$19)/30,0)/12))","v":40},{"$f":"MOD(ROUND(SUM($N$19*30+$O$19-1)/30,0),12)","v":0},{"$f":"MIN($T$1,$V$1)","v":0.8},null,null,null,{"$f":"tabprev!A22","v":19},{"$f":"tabprev!B22","v":0.42199999999999999},1990,0.42199999999999999,0.42199999999999999]
[null,null,"1996-01-01","2012-02-29",{"$f":"IF(AND(C23<>\"\",D23<>\"\"),FLOOR((DAYS360(C23,D23+1,TRUE))/360,1),0)","v":16},{"$f":"IF(AND(C23<>\"\",D23<>\"\"),FLOOR(((DAYS360(C23,D23+1,TRUE))-E23*360)/30,1),0)","v":2},{"$f":"IF(AND(C23<>\"\",D23<>\"\"),(DAYS360(C23,D23+1,TRUE))-E23*360-F23*30,0)","v":0},"Calcolo aliquota differenza tra aliq.data cessaz. e aliq. al 31.12.92",null,null,null,null,null,null,null,null,null,null,{"$f":"tabprev!A23","v":20},{"$f":"tabprev!B23","v":0.44},1991,0.44,0.44]
[null,null,null,null,{"$f":"IF(AND(C24<>\"\",D24<>\"\"),FLOOR((DAYS360(C24,D24+1,TRUE))/360,1),0)","v":0},{"$f":"IF(AND(C24<>\"\",D24<>\"\"),FLOOR(((DAYS360(C24,D24+1,TRUE))-E24*360)/30,1),0)","v":0},{"$f":"IF(AND(C24<>\"\",D24<>\"\"),(DAYS360(C24,D24+1,TRUE))-E24*360-F24*30,0)","v":0},"Diff.(dal 1.1.93 alla cessaz.) in anni e mesi (a - b)",null,null,null,null,"anni:","mesi:","aliquota",null,null,null,{"$f":"tabprev!A24","v":21},{"$f":"tabprev!B24","v":0.45800000000000002},1992,0.45800000000000002,0.45800000000000002]
[null,null,null,null,{"$f":"IF(AND(C25<>\"\",D25<>\"\"),FLOOR((DAYS360(C25,D25+1,TRUE))/360,1),0)","v":0},{"$f":"IF(AND(C25<>\"\",D25<>\"\"),FLOOR(((DAYS360(C25,D25+1,TRUE))-E25*360)/30,1),0)","v":0},{"$f":"IF(AND(C25<>\"\",D25<>\"\"),(DAYS360(C25,D25+1,TRUE))-E25*360-F25*30,0)","v":0},null,null,null,null,null,{"$f":"INT(($M$22*12+$N$22-($M$5*12+$N$5))/12)","v":16},{"$f":"MOD($N$22+$M$22*12-($N$5+$M$5*12),12)","v":10},{"$f":"$O$22-$O$5","v":0.30300000000000005},null,null,null,{"$f":"tabprev!A25","v":22},{"$f":"tabprev!B25","v":0.47599999999999998},1993,0.47599999999999998,0.47599999999999998]
[null,null,null,null,{"$f":"IF(AND(C26<>\"\",D26<>\"\"),FLOOR((DAYS360(C26,D26+1,TRUE))/360,1),0)","v":0},{"$f":"IF(AND(C26<>\"\",D26<>\"\"),FLOOR(((DAYS360(C26,D26+1,TRUE))-E26*360)/30,1),0)","v":0},{"$f":"IF(AND(C26<>\"\",D26<>\"\"),(DAYS360(C26,D26+1,TRUE))-E26*360-F26*30,0)","v":0},"Calcolo periodo riferim. (dal 1.1.93 alla data di decorrenza della pensione)",null,null,null,null,null,null,null,null,null,null,{"$f":"tabprev!A26","v":23},{"$f":"tabprev!B26","v":0.49399999999999999},1994,0.49399999999999999,0.49399999999999999]
["Totale Serv.utili dal 1.1.96 alla data cess.",null,null,null,{"$f":"SUM(SUM($E$23:$E$26),INT(INT(SUM($F$23:$F$26)+INT(SUM($G$23:$G$26)/30))/12))","v":16},{"$f":"MOD(SUM(SUM($F$23:$F$26),INT(SUM($G$23:$G$26)/30)),12)","v":2},{"$f":"MOD(SUM($G$23:$G$26),30)","v":0},null,null,null,null,"dal:","al:","mesi:",null,null,null,null,{"$f":"tabprev!A27","v":24},{"$f":"tabprev!B27","v":0.51200000000000001},1995,0.51400000000000001,0.51200000000000001]
[null,null,null,null,null,null,null,"Calcolo mesi dal 1.1.93 al 31.12.95 al 50%",null,null,null,"1993-01-01","1995-12-31",{"$f":"ROUND(SUM($E$20*360,$F$20*30,$G$20)/30*50%,0)","v":18},null,null,null,null,{"$f":"tabprev!A28","v":25},{"$f":"tabprev!B28","v":0.53},1996,0.53400000000000003,0.53]
[null,null,null,null,null,null,null,"Calcolo mesi dal 1.1.96 alla data cess.al 66,6%",null,null,null,"1996-01-01",{"$f":"$O$2","v":"2012-02-29"},{"$f":"ROUND(SUM($E$27*360,$F$27*30,$G$27)/30*66.6%,0)","v":129},null,null,null,null,{"$f":"tabprev!A29","v":26},{"$f":"tabprev!B29","v":0.54800000000000004},1997,0.55400000000000005,0.54800000000000004]
[null,null,null,null,null,null,null,"Periodo di riferimento in mesi",null,null,null,null,null,{"$f":"MIN(120,SUM(N28:N29))","v":120},null,null,null,null,{"$f":"tabprev!A30","v":27},{"$f":"tabprev!B30","v":0.56599999999999995},1998,0.57400000000000007,0.56599999999999995]
["CALCOLO SOMMATORIA RETRIBUZIONI RIVALUTATE DEL PERIODO DI RIFERIMENTO\nRetribuz. dalla data di cessaz. in poi, a ritroso nel tempo, fino a raggiungere il n° di mesi del periodo di riferim. per il calcolo della quota B di pensione",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tabprev!A31","v":28},{"$f":"tabprev!B31","v":0.58399999999999996},1999,0.59400000000000008,0.58399999999999996]
["(ogni riga deve riferirsi ad un solo anno. I periodi che si collocano a cavallo di più anni devono essere spezzati per anno)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tabprev!A32","v":29},{"$f":"tabprev!B32","v":0.60199999999999998},2000,0.6140000000000001,0.60199999999999998]
["dal","al","n° mesi","somma cumulata mesi","anno","stip.annuo lordo e vac.contr.\n(c)","retribuz. individ. anzianità\n(d)","assegno pers. pensionabile\n(e)","assegno personale L.239/04\n(f)","increm. 18%\nsu c+d+e+f","ind.int. spec.\nIIS","comp. access.\n(indenn.\nammin.)","altri compensi accessori","coeffic. rivalut.","coeff. x increm. 1%","imp.rival. x i mesi corrisp.\nsoluzione 1",null,null,{"$f":"tabprev!A33","v":30},{"$f":"tabprev!B33","v":0.62},2001,0.63400000000000012,0.62,"Retr. fisse e cont. secondo me","Retr.fisse e cont. secondo M.S.E.","Diff. Secondo me - secondo M.S.E."]
["2012-01-01","2012-02-29",{"$f":"ROUND((B34-A34)/30,0)","v":2},{"$f":"IF(AND(A34=\"\",B34=\"\"),0,IF(ROUND(SUM($C$34:C34),0)<=$N$30,ROUND(SUM($C$34:C34),0),\"oltre limite\"))","v":2},{"$f":"IF(AND(A34=\"\",B34=\"\"),0,IF(YEAR(A34)=YEAR(B34),YEAR(B34),\"data err.\"))","v":2012},22100,2000,null,300,{"$f":"IF(AND($A34=\"\",$B34=\"\"),0,IF(AND($Q33=0,$R33=0),SUM($F34:$I34)*18%,0))","v":4392},6641.4000000000005,3930,0,{"$f":"IF(AND($A34=\"\",$B34=\"\"),0,IF(OR(YEAR($A34)=YEAR($O$2),YEAR($A34)=YEAR($O$2)-1),1,IF(AND($Q33=0,$R33=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A34),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":1},{"$f":"IF(N34=1,1,IF(N34=0,0,O33+1%))","v":1},{"$f":"IF(AND($A34=\"\",$B34=\"\"),0,IF(AND($Q33=0,$R33=0),ROUND((SUM($F34:$I34,$K34)/12*$C34+MAX($J34/12*$C34,SUM($L34/12*$C34,$M34)))*$N34*$O34,2),0))","v":5905.57},{"$f":"IF(AND($A34=\"\",$B34=\"\"),0,IF(ROUND(SUM($C34:$C$35),0)<=$N$30,0,1))","v":0},{"$f":"IF(AND($A34=\"\",$B34=\"\"),0,IF(YEAR($A34)=YEAR($B34),0,1))","v":0},{"$f":"tabprev!A34","v":31},{"$f":"tabprev!B34","v":0.63800000000000001},2002,0.65400000000000014,0.63800000000000001,{"$f":"SUM(F34:I34,K34)","v":31041.4},32230.92,{"$f":"X34-Y34","v":-1189.5199999999968}]
["2011-01-01","2011-12-31",{"$f":"ROUND((B35-A35)/30,0)","v":12},{"$f":"IF(AND(A35=\"\",B35=\"\"),0,IF(ROUND(SUM($C$34:C35),0)<=$N$30,ROUND(SUM($C$34:C35),0),\"oltre limite\"))","v":14},{"$f":"IF(AND(A35=\"\",B35=\"\"),0,IF(YEAR(A35)=YEAR(B35),YEAR(B35),\"data err.\"))","v":2011},22000,2000,null,300,4374,6641.4000000000005,3930,4000,{"$f":"IF(AND($A35=\"\",$B35=\"\"),0,IF(OR(YEAR($A35)=YEAR($O$2),YEAR($A35)=YEAR($O$2)-1),1,IF(AND($Q34=0,$R34=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A35),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":1},{"$f":"IF(N35=1,1,IF(N35=0,0,O34+1%))","v":1},{"$f":"IF(AND($A35=\"\",$B35=\"\"),0,IF(AND($Q34=0,$R34=0),ROUND((SUM($F35:$I35,$K35)/12*$C35+MAX($J35/12*$C35,SUM($L35/12*$C35,$M35)))*$N35*$O35,2),0))","v":38871.4},{"$f":"IF(AND($A35=\"\",$B35=\"\"),0,IF(ROUND(SUM($C$35:$C35),0)<=$N$30,0,1))","v":0},{"$f":"IF(AND($A35=\"\",$B35=\"\"),0,IF(YEAR($A35)=YEAR($B35),0,1))","v":0},{"$f":"tabprev!A35","v":32},{"$f":"tabprev!B35","v":0.65600000000000003},2003,0.67400000000000015,0.65600000000000003,30941.4,32230.92,{"$f":"X35-Y35","v":-1289.5199999999968}]
["2010-01-01","2010-12-31",{"$f":"ROUND((B36-A36)/30,0)","v":12},{"$f":"IF(AND(A36=\"\",B36=\"\"),0,IF(ROUND(SUM($C$34:C36),0)<=$N$30,ROUND(SUM($C$34:C36),0),\"oltre limite\"))","v":26},{"$f":"IF(AND(A36=\"\",B36=\"\"),0,IF(YEAR(A36)=YEAR(B36),YEAR(B36),\"data err.\"))","v":2010},21100,2000,null,300,4212,6641.4000000000005,3930,5000,{"$f":"IF(AND($A36=\"\",$B36=\"\"),0,IF(OR(YEAR($A36)=YEAR($O$2),YEAR($A36)=YEAR($O$2)-1),1,IF(AND($Q35=0,$R35=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A36),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":1.0269482884195194},1.01,40421.83,{"$f":"IF(AND($A36=\"\",$B36=\"\"),0,IF(ROUND(SUM($C$35:$C36),0)<=$N$30,0,1))","v":0},{"$f":"IF(AND($A36=\"\",$B36=\"\"),0,IF(YEAR($A36)=YEAR($B36),0,1))","v":0},{"$f":"tabprev!A36","v":33},{"$f":"tabprev!B36","v":0.67400000000000004},2004,0.69400000000000017,0.67400000000000004,30041.4,32155.11,-2113.7099999999991]
["2009-01-01","2009-12-31",12,{"$f":"IF(AND(A37=\"\",B37=\"\"),0,IF(ROUND(SUM($C$34:C37),0)<=$N$30,ROUND(SUM($C$34:C37),0),\"oltre limite\"))","v":38},2009,20000,2000,null,300,4014,6641.4,3930,5000,{"$f":"IF(AND($A37=\"\",$B37=\"\"),0,IF(OR(YEAR($A37)=YEAR($O$2),YEAR($A37)=YEAR($O$2)-1),1,IF(AND($Q36=0,$R36=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A37),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":1.0436713545521836},1.02,40315.800000000003,{"$f":"IF(AND($A37=\"\",$B37=\"\"),0,IF(ROUND(SUM($C$35:$C37),0)<=$N$30,0,1))","v":0},0,{"$f":"tabprev!A37","v":34},{"$f":"tabprev!B37","v":0.69199999999999995},2005,0.71400000000000019,0.69199999999999995,28941.4,32014.32,-3072.9199999999983]
["2008-01-01","2008-12-31",12,{"$f":"IF(AND(A38=\"\",B38=\"\"),0,IF(ROUND(SUM($C$34:C38),0)<=$N$30,ROUND(SUM($C$34:C38),0),\"oltre limite\"))","v":50},2008,19000,2000,800,300,3978,6641.4,3085.51,6000,{"$f":"IF(AND($A38=\"\",$B38=\"\"),0,IF(OR(YEAR($A38)=YEAR($O$2),YEAR($A38)=YEAR($O$2)-1),1,IF(AND($Q37=0,$R37=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A38),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":1.0506706408345754},1.03,40935.93,{"$f":"IF(AND($A38=\"\",$B38=\"\"),0,IF(ROUND(SUM($C$35:$C38),0)<=$N$30,0,1))","v":0},0,{"$f":"tabprev!A38","v":35},{"$f":"tabprev!B38","v":0.71},2006,0.73400000000000021,0.71,28741.4,31776.48,-3035.0799999999981]
["2007-01-01","2007-12-31",12,{"$f":"IF(AND(A39=\"\",B39=\"\"),0,IF(ROUND(SUM($C$34:C39),0)<=$N$30,ROUND(SUM($C$34:C39),0),\"oltre limite\"))","v":62},2007,18000,2000,1000,1190,3994.2,6641.3999999999987,1854.0075000000002,6000,{"$f":"IF(AND($A39=\"\",$B39=\"\"),0,IF(OR(YEAR($A39)=YEAR($O$2),YEAR($A39)=YEAR($O$2)-1),1,IF(AND($Q38=0,$R38=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A39),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":1.0846153846153845},1.04,41381.14,{"$f":"IF(AND($A39=\"\",$B39=\"\"),0,IF(ROUND(SUM($C$35:$C39),0)<=$N$30,0,1))","v":0},0,{"$f":"tabprev!A39","v":36},{"$f":"tabprev!B39","v":0.72799999999999998},2007,0.75400000000000023,0.72799999999999998,28831.399999999998,30946.7,-2115.3000000000029]
["2006-01-01","2006-12-31",12,{"$f":"IF(AND(A40=\"\",B40=\"\"),0,IF(ROUND(SUM($C$34:C40),0)<=$N$30,ROUND(SUM($C$34:C40),0),\"oltre limite\"))","v":74},2006,17100,2000,2300,1200,4068,6641.4,556.48,3000,{"$f":"IF(AND($A40=\"\",$B40=\"\"),0,IF(OR(YEAR($A40)=YEAR($O$2),YEAR($A40)=YEAR($O$2)-1),1,IF(AND($Q39=0,$R39=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A40),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":1.103286384976526},1.05,38587.300000000003,{"$f":"IF(AND($A40=\"\",$B40=\"\"),0,IF(ROUND(SUM($C$35:$C40),0)<=$N$30,0,1))","v":0},0,{"$f":"tabprev!A40","v":37},{"$f":"tabprev!B40","v":0.746},2008,0.77400000000000024,0.746,29241.4,30949.32,-1707.9199999999983]
["2005-01-01","2005-12-31",12,{"$f":"IF(AND(A41=\"\",B41=\"\"),0,IF(ROUND(SUM($C$34:C41),0)<=$N$30,ROUND(SUM($C$34:C41),0),\"oltre limite\"))","v":86},2005,16000,2000,2600,1200,3924,6641.3999999999987,332.95166666666671,3000,{"$f":"IF(AND($A41=\"\",$B41=\"\"),0,IF(OR(YEAR($A41)=YEAR($O$2),YEAR($A41)=YEAR($O$2)-1),1,IF(AND($Q40=0,$R40=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A41),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":1.1252992817238627},1.06,38606.01,{"$f":"IF(AND($A41=\"\",$B41=\"\"),0,IF(ROUND(SUM($C$35:$C41),0)<=$N$30,0,1))","v":0},0,{"$f":"tabprev!A41","v":38},{"$f":"tabprev!B41","v":0.76400000000000001},2009,0.79400000000000026,0.76400000000000001,28441.399999999998,30917.34,-2475.9400000000023]
["2004-01-01","2004-12-31",12,{"$f":"IF(AND(A42=\"\",B42=\"\"),0,IF(ROUND(SUM($C$34:C42),0)<=$N$30,ROUND(SUM($C$34:C42),0),\"oltre limite\"))","v":98},2004,16900,2000,2900,800,4068,6641.4,null,2000,{"$f":"IF(AND($A42=\"\",$B42=\"\"),0,IF(OR(YEAR($A42)=YEAR($O$2),YEAR($A42)=YEAR($O$2)-1),1,IF(AND($Q41=0,$R41=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A42),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":1.1444805194805194},{"$f":"IF(N42=1,1,IF(N42=0,0,O41+1%))","v":1.07},40790.5,{"$f":"IF(AND($A42=\"\",$B42=\"\"),0,IF(ROUND(SUM($C$35:$C42),0)<=$N$30,0,1))","v":0},0,{"$f":"tabprev!A42","v":39},{"$f":"tabprev!B42","v":0.78200000000000003},2010,0.81400000000000028,0.78200000000000003,29241.4,30565.56,-1324.1599999999999]
["2003-01-01","2003-12-31",12,{"$f":"IF(AND(A43=\"\",B43=\"\"),0,IF(ROUND(SUM($C$34:C43),0)<=$N$30,ROUND(SUM($C$34:C43),0),\"oltre limite\"))","v":110},2003,16000,2000,3000,null,3780,6641.4,null,2000,{"$f":"IF(AND($A43=\"\",$B43=\"\"),0,IF(OR(YEAR($A43)=YEAR($O$2),YEAR($A43)=YEAR($O$2)-1),1,IF(AND($Q42=0,$R42=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A43),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":1.1672185430463577},1.08,39609.69,{"$f":"IF(AND($A43=\"\",$B43=\"\"),0,IF(ROUND(SUM($C$35:$C43),0)<=$N$30,0,1))","v":0},0,{"$f":"tabprev!A43","v":40},{"$f":"tabprev!B43","v":0.8},{"$f":"U42+1","v":2011},{"$f":"IF(S43=0,0,IF(U43<1995,T43,V42+0.02))","v":0.8340000000000003},{"$f":"MIN(T43,V43)","v":0.8},27641.4,29671.8,-2030.3999999999978]
["2002-03-01","2002-12-31",10,{"$f":"IF(AND(A44=\"\",B44=\"\"),0,IF(ROUND(SUM($C$34:C44),0)<=$N$30,ROUND(SUM($C$34:C44),0),\"oltre limite\"))","v":120},2002,15000,2000,4000,null,3780,6641.4,null,2500,{"$f":"IF(AND($A44=\"\",$B44=\"\"),0,IF(OR(YEAR($A44)=YEAR($O$2),YEAR($A44)=YEAR($O$2)-1),1,IF(AND($Q43=0,$R43=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A44),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":1.1959287531806615},1.0900000000000001,34133.129999999997,{"$f":"IF(AND($A44=\"\",$B44=\"\"),0,IF(ROUND(SUM($C$35:$C44),0)<=$N$30,0,1))","v":0},0,null,null,null,null,null,27641.4,29671.8,-2030.3999999999978]
[null,null,0,{"$f":"IF(AND(A45=\"\",B45=\"\"),0,IF(ROUND(SUM($C$34:C45),0)<=$N$30,ROUND(SUM($C$34:C45),0),\"oltre limite\"))","v":0},0,null,null,null,null,0,null,null,0,{"$f":"IF(AND($A45=\"\",$B45=\"\"),0,IF(OR(YEAR($A45)=YEAR($O$2),YEAR($A45)=YEAR($O$2)-1),1,IF(AND($Q44=0,$R44=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A45),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":0},0,0,{"$f":"IF(AND($A45=\"\",$B45=\"\"),0,IF(ROUND(SUM($C$35:$C45),0)<=$N$30,0,1))","v":0},0,null,null,null,null,null,0]
[null,null,0,{"$f":"IF(AND(A46=\"\",B46=\"\"),0,IF(ROUND(SUM($C$34:C46),0)<=$N$30,ROUND(SUM($C$34:C46),0),\"oltre limite\"))","v":0},0,null,null,null,null,0,null,null,0,{"$f":"IF(AND($A46=\"\",$B46=\"\"),0,IF(OR(YEAR($A46)=YEAR($O$2),YEAR($A46)=YEAR($O$2)-1),1,IF(AND($Q45=0,$R45=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A46),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":0},0,0,{"$f":"IF(AND($A46=\"\",$B46=\"\"),0,IF(ROUND(SUM($C$35:$C46),0)<=$N$30,0,1))","v":0},0,null,null,null,null,null,0]
[null,null,0,{"$f":"IF(AND(A47=\"\",B47=\"\"),0,IF(ROUND(SUM($C$34:C47),0)<=$N$30,ROUND(SUM($C$34:C47),0),\"oltre limite\"))","v":0},0,null,null,null,null,0,null,null,0,{"$f":"IF(AND($A47=\"\",$B47=\"\"),0,IF(OR(YEAR($A47)=YEAR($O$2),YEAR($A47)=YEAR($O$2)-1),1,IF(AND($Q46=0,$R46=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A47),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":0},0,0,{"$f":"IF(AND($A47=\"\",$B47=\"\"),0,IF(ROUND(SUM($C$35:$C47),0)<=$N$30,0,1))","v":0},0,null,null,null,null,null,0]
[null,null,0,{"$f":"IF(AND(A48=\"\",B48=\"\"),0,IF(ROUND(SUM($C$34:C48),0)<=$N$30,ROUND(SUM($C$34:C48),0),\"oltre limite\"))","v":0},0,null,null,null,null,0,null,null,0,{"$f":"IF(AND($A48=\"\",$B48=\"\"),0,IF(OR(YEAR($A48)=YEAR($O$2),YEAR($A48)=YEAR($O$2)-1),1,IF(AND($Q47=0,$R47=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A48),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":0},0,0,{"$f":"IF(AND($A48=\"\",$B48=\"\"),0,IF(ROUND(SUM($C$35:$C48),0)<=$N$30,0,1))","v":0},0,null,null,null,null,null,0]
[null,null,{"$f":"ROUND((B49-A49)/30,0)","v":0},{"$f":"IF(AND(A49=\"\",B49=\"\"),0,IF(ROUND(SUM($C$34:C49),0)<=$N$30,ROUND(SUM($C$34:C49),0),\"oltre limite\"))","v":0},{"$f":"IF(AND(A49=\"\",B49=\"\"),0,IF(YEAR(A49)=YEAR(B49),YEAR(B49),\"data err.\"))","v":0},null,null,null,null,0,null,null,0,{"$f":"IF(AND($A49=\"\",$B49=\"\"),0,IF(OR(YEAR($A49)=YEAR($O$2),YEAR($A49)=YEAR($O$2)-1),1,IF(AND($Q48=0,$R48=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A49),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":0},{"$f":"IF(N49=1,1,IF(N49=0,0,O48+1%))","v":0},{"$f":"IF(AND($A49=\"\",$B49=\"\"),0,IF(AND($Q48=0,$R48=0),ROUND((SUM($F49:$I49,$K49)/12*$C49+MAX($J49/12*$C49,SUM($L49/12*$C49,$M49/12*$C49)))*$N49*$O49,2),0))","v":0},{"$f":"IF(AND($A49=\"\",$B49=\"\"),0,IF(ROUND(SUM($C$35:$C49),0)<=$N$30,0,1))","v":0},0,null,null,null,null,null,0]
["TOTALE MESI",null,{"$f":"SUM(C$34:C49)","v":120},null,null,null,null,null,null,"TOTALE IMPORTI RIVALUTATI",null,null,null,null,null,{"$f":"SUM($P$34:$P49)","v":399558.3}]
["Calcolo retribuzione media annua",null,null,null,null,null,"Calcolo quota B di pensione annua",null,null,null,"Calcolo pensione annua",null,null,null,"Pensione x 12 mensilità + 13ma",null,null,null,null,null,null,null,{"$f":"SUM($F49,$K49,$L49,$M49)","v":0}]
["Totale retrib.periodo riferim., rival.:",null,null,null,{"$f":"IF(AND($Q$49=0,$R$49=0),IF(MAX($D$34:$D$49)=$E$53,$P$50,0),0)","v":399558.3},null,"Retribuz. media annua",null,{"$f":"E55","v":39955.829999999994},{"$f":"\"x\"","v":"x"},"Quota A",null,{"$f":"M$16","v":17610.399799999999},null,null,null,null,null,null,null,null,null,{"$f":"SUM($F50,$J50,$K50,$M50)","v":0}]
["N° mesi periodo di riferimento",null,null,null,{"$f":"$N$30","v":120},null,"aliquota pensione dal 1.1.93 alla data cessaz.",null,{"$f":"$O$25","v":0.30300000000000005},{"$f":"\"=\"","v":"="},"Quota B",null,{"$f":"$I$55","v":12106.61649}]
["Retribuzione media mensile",null,null,null,{"$f":"IF(AND($Q$49=0,$R$49=0),IF($N$30<>0,E52/$N$30,0),0)","v":3329.6524999999997},null,null,null,null,null,"Pens.lorda",null,{"$f":"SUM(M$52:M$53)","v":29717.01629},null,{"$f":"$M54/12","v":2476.4180241666668}]
["Retribuzione media annua",null,null,null,{"$f":"E$54*12","v":39955.829999999994},null,"Quota B di pensione annua",null,{"$f":"I52*I53","v":12106.61649},null,"Pensione netta",null,{"$f":"'ire 2012'!$H$7","v":22728.855083692419},null,{"$f":"$M55/12","v":1894.0712569743682}]

{"sheet":"Pensione nota op.","index":1,"n_rows":55,"n_cols":26,"rows_kept":55,"cut":false,"hidden":false,"merged":[[54,4,54,5],[51,12,51,13],[54,12,54,13],[50,0,50,5],[50,6,50,9],[50,10,50,13],[52,10,52,11],[52,12,52,13],[52,6,53,7],[52,8,53,8],[54,0,54,3],[27,7,27,10],[28,7,28,10],[29,7,29,12],[30,0,30,14],[54,6,54,7],[54,10,54,11],[50,14,52,14],[51,0,51,3],[51,4,51,5],[51,6,51,7],[53,0,53,3],[53,4,53,5],[53,9,54,9],[53,10,53,11],[53,12,53,13],[49,0,49,1],[49,9,49,14],[52,0,52,3],[52,4,52,5],[51,10,51,11],[31,0,31,14],[22,0,22,1],[22,7,22,14],[23,0,23,1],[23,7,24,11],[24,0,24,1],[25,0,25,1],[25,7,25,14],[26,0,26,3],[26,7,26,10],[15,0,15,1],[15,7,15,11],[16,0,16,1],[17,0,17,1],[17,7,17,11],[18,0,18,1],[18,7,18,11],[19,0,19,3],[19,7,19,14],[20,0,20,6],[20,7,21,11],[21,0,21,1],[9,0,9,1],[9,7,9,11],[10,0,10,1],[10,7,10,11],[11,0,11,1],[11,7,11,11],[12,0,12,3],[12,7,12,11],[13,0,13,6],[13,7,13,11],[14,0,14,1],[14,7,14,11],[3,0,3,1],[3,7,3,11],[4,0,4,1],[4,7,4,11],[5,0,5,1],[5,7,5,14],[6,0,6,1],[6,7,6,11],[7,0,7,1],[7,7,7,11],[8,0,8,1],[8,7,8,11],[0,0,0,14],[1,0,1,5],[1,6,1,9],[1,11,1,13],[2,0,2,6],[2,7,2,14]]}
["DIGITARE SOLO I DATI COMPRESI NELLE CELLE BORDATE CON LINEA DOPPIA\n(Il calcolo tiene conto della Nota Operativa Inpdap n. 26 del 13.06.2008: anzianità contributiva > 40 anni)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"anno cess.",{"$f":"YEAR(DATE(YEAR($O$2),MONTH($O$2)-$N$22,1))","v":2012},"aliq.norm.prec.",{"$f":"INDEX($T$3:$T$43,MATCH($M$22,$S$3:$S$43))+IF($M$22=40,0,(INDEX($T$3:$T$43,MATCH($M$22+1,$S$3:$S$43,0))-INDEX($T$3:$T$43,MATCH($M$22,$S$3:$S$43,0)))/12*$N$22)","v":0.8},"aliq.norm.succ.",{"$f":"INDEX($V$3:$V$43,MATCH($M$22,$S$3:$S$43,0))+IF($M$22=40,0,(INDEX($V$3:$V$43,MATCH($M$22+1,$S$3:$S$43,0))-INDEX($V$3:$V$43,MATCH($M$22,$S$3:$S$43,0)))/12*$N$22)","v":0.8340000000000003}]
["Attenzione! Verificare comp.accessorie",null,null,null,null,null,"Pinco Pallino",null,null,null,null,"Data di cessazione:",null,null,{"$f":"MAX($D$6:$D$12,$D$16:$D$19,$D$23:$D$26)","v":"2012-02-29"},null,null,null,"anni contr.","ali.prec.","anni","aliq.calc.","aliq.da appl."]
["Calcolo Servizi Utili fino al 31.12.92",null,null,null,null,null,null,"Calcolo aliquota di pensione Servizi Utili al 31.12.92",null,null,null,null,null,null,null,null,null,null,{"$f":"tabprev!A3","v":0},{"$f":"tabprev!B3","v":0},{"$f":"YEAR($C$6)","v":1971},{"$f":"IF(S3=0,0,IF(U3<1995,T3,V2+0.02))","v":0},{"$f":"MIN(T3,V3)","v":0}]
["mansione",null,"dal:","al:","anni:","mesi:","giorni:",null,null,null,null,null,"anni:","mesi:","aliquota (b)",null,null,null,{"$f":"tabprev!A4","v":1},{"$f":"tabprev!B4","v":2.3300000000000001E-2},{"$f":"U3+1","v":1972},2.3300000000000001E-2,2.3300000000000001E-2]
["figurativo",null,"1969-06-08","1970-09-06",{"$f":"IF(AND(C5<>\"\",D5<>\"\"),FLOOR((DAYS360(C5,D5+1,TRUE))/360,1),0)","v":1},{"$f":"IF(AND(C5<>\"\",D5<>\"\"),FLOOR(((DAYS360(C5,D5+1,TRUE))-E5*360)/30,1),0)","v":2},{"$f":"IF(AND(C5<>\"\",D5<>\"\"),(DAYS360(C5,D5+1,TRUE))-E5*360-F5*30,0)","v":29},"Servizi utili da considerare al al 31.12.92 in anni e mesi",null,null,null,null,{"$f":"IF(E13=\"errore\",0,40-INT((40*12-($M$18*12+$N$18))/12))","v":20},{"$f":"IF(E13=\"errore\",0,MOD(40*12-($N$18+$M$18*12),12))","v":10},{"$f":"O22-O25","v":0.37500000000000006},null,null,null,{"$f":"tabprev!A5","v":2},{"$f":"tabprev!B5","v":4.6699999999999998E-2},1973,4.6699999999999998E-2,4.6699999999999998E-2]
[null,null,"1971-01-15","1974-06-25",3,5,11,"Calcolo Quota A pensione annua (anzian.al 31.12.92)",null,null,null,null,null,null,null,null,null,null,{"$f":"tabprev!A6","v":3},{"$f":"tabprev!B6","v":7.0000000000000007E-2},1974,7.0000000000000007E-2,7.0000000000000007E-2]
[null,null,"1974-06-26","1992-12-31",18,6,5,{"$f":"\"- Stipendio annuo lordo alla data di cessaz.\"","v":"- Stipendio annuo lordo alla data di cessaz."},null,null,null,null,{"$f":"$F$34","v":22100},{"$f":"\"+\"","v":"+"},null,null,null,null,{"$f":"tabprev!A7","v":4},{"$f":"tabprev!B7","v":9.3299999999999994E-2},1975,9.3299999999999994E-2,9.3299999999999994E-2]
[null,null,null,null,0,0,0,{"$f":"\"- Retribuz. individ. anzianità alla data di cessazione\"","v":"- Retribuz. individ. anzianità alla data di cessazione"},null,null,null,null,{"$f":"$G$34","v":2000},{"$f":"\"+\"","v":"+"},null,null,null,null,{"$f":"tabprev!A8","v":5},{"$f":"tabprev!B8","v":0.1167},1976,0.1167,0.1167]
[null,null,null,null,0,0,0,{"$f":"\"- Assegno pers. ex Agensud alla data di cessazione\"","v":"- Assegno pers. ex Agensud alla data di cessazione"},null,null,null,null,{"$f":"$H$34","v":0},{"$f":"\"+\"","v":"+"},null,null,null,null,{"$f":"tabprev!A9","v":6},{"$f":"tabprev!B9","v":0.14000000000000001},1977,0.14000000000000001,0.14000000000000001]
[null,null,null,null,0,0,0,{"$f":"\"- Assegno pers. L. 239/04 alla data di cessazione\"","v":"- Assegno pers. L. 239/04 alla data di cessazione"},null,null,null,null,{"$f":"$I$34","v":300},"=",null,null,null,null,{"$f":"tabprev!A10","v":7},{"$f":"tabprev!B10","v":0.1633},1978,0.1633,0.1633]
[null,null,null,null,0,0,0,{"$f":"\"- Incremento voci precedenti del 18%\"","v":"- Incremento voci precedenti del 18%"},null,null,null,null,{"$f":"18%*SUM(M7:M10)","v":4392},{"$f":"\"+\"","v":"+"},null,null,null,null,{"$f":"tabprev!A11","v":8},{"$f":"tabprev!B11","v":0.1867},1979,0.1867,0.1867]
[null,null,null,null,0,0,0,{"$f":"\"- I.I.S. annua alla data di cessazione\"","v":"- I.I.S. annua alla data di cessazione"},null,null,null,null,{"$f":"$K$34","v":6641.4000000000005},{"$f":"\"+\"","v":"+"},null,null,null,null,{"$f":"tabprev!A12","v":9},{"$f":"tabprev!B12","v":0.21},1980,0.21,0.21]
["Totale Servizi utili al 31.12.92",null,null,null,{"$f":"SUM(SUM($E$5:$E$12),INT(INT(SUM($F$5:$F$12)+INT(SUM($G$5:$G$12)/30))/12))","v":23},{"$f":"MOD(SUM(SUM($F$5:$F$12),INT(SUM($G$5:$G$12)/30)),12)","v":2},{"$f":"MOD(SUM($G$5:$G$12),30)","v":15},{"$f":"\"- Indennità di amministraz. alla data di cessazione\"","v":"- Indennità di amministraz. alla data di cessazione"},null,null,null,null,null,{"$f":"\"+\"","v":"+"},null,null,null,null,{"$f":"tabprev!A13","v":10},{"$f":"tabprev!B13","v":0.23330000000000001},1981,0.23330000000000001,0.23330000000000001]
["Calcolo Servizi Utili dal 1.1.93 fino al 31.12.95",null,null,null,null,null,null,"Base pensionabile (Totale)",null,null,null,null,{"$f":"SUM(M$7:M$13)","v":35433.4},{"$f":"\"x\"","v":"x"},null,null,null,null,{"$f":"tabprev!A14","v":11},{"$f":"tabprev!B14","v":0.25669999999999998},1982,0.25669999999999998,0.25669999999999998]
["mansione",null,"dal:","al:","anni:","mesi:","giorni:","Aliquota di pensione al 31.12.92",null,null,null,null,{"$f":"O5","v":0.37500000000000006},{"$f":"\"=\"","v":"="},null,null,null,null,{"$f":"tabprev!A15","v":12},{"$f":"tabprev!B15","v":0.28000000000000003},1983,0.28000000000000003,0.28000000000000003]
[null,null,"1993-01-01","1993-10-12",{"$f":"IF(AND(C16<>\"\",D16<>\"\"),FLOOR((DAYS360(C16,D16+1,TRUE))/360,1),0)","v":0},{"$f":"IF(AND(C16<>\"\",D16<>\"\"),FLOOR(((DAYS360(C16,D16+1,TRUE))-E16*360)/30,1),0)","v":9},{"$f":"IF(AND(C16<>\"\",D16<>\"\"),(DAYS360(C16,D16+1,TRUE))-E16*360-F16*30,0)","v":12},"Quota A di pensione annua",null,null,null,null,{"$f":"M14*M15","v":13287.525000000003},null,null,null,null,null,{"$f":"tabprev!A16","v":13},{"$f":"tabprev!B16","v":0.30330000000000001},1984,0.30330000000000001,0.30330000000000001]
[null,null,"1993-10-13","1995-12-31",{"$f":"IF(AND(C17<>\"\",D17<>\"\"),FLOOR((DAYS360(C17+1,D17,TRUE))/360,1),0)","v":2},{"$f":"IF(AND(C17<>\"\",D17<>\"\"),FLOOR(((DAYS360(C17,D17+1,TRUE))-E17*360)/30,1),0)","v":2},{"$f":"IF(AND(C17<>\"\",D17<>\"\"),(DAYS360(C17,D17+1,TRUE))-E17*360-F17*30,0)","v":18},null,null,null,null,null,"anni:","mesi:","giorni:",null,null,null,{"$f":"tabprev!A17","v":14},{"$f":"tabprev!B17","v":0.32669999999999999},1985,0.32669999999999999,0.32669999999999999]
[null,null,null,null,{"$f":"IF(AND(C18<>\"\",D18<>\"\"),FLOOR((DAYS360(C18+1,D18,TRUE))/360,1),0)","v":0},{"$f":"IF(AND(C18<>\"\",D18<>\"\"),FLOOR(((DAYS360(C18,D18+1,TRUE))-E18*360)/30,1),0)","v":0},{"$f":"IF(AND(C18<>\"\",D18<>\"\"),(DAYS360(C18,D18+1,TRUE))-E18*360-F18*30,0)","v":0},"Servizio utile dal 1.1.93 alla data di cessazione",null,null,null,null,{"$f":"SUM($E$20,$E$27,INT(SUM(INT(SUM($G$20,$G$27)/30),$F$20,$F$27)/12))","v":19},{"$f":"MOD(SUM($F$20,$F$27,INT(SUM($G$20,$G$27)/30)),12)","v":2},{"$f":"MOD(SUM($G$20,$G$27),30)","v":0},null,null,null,{"$f":"tabprev!A18","v":15},{"$f":"tabprev!B18","v":0.35},1986,0.35,0.35]
[null,null,null,null,{"$f":"IF(AND(C19<>\"\",D19<>\"\"),FLOOR((DAYS360(C19+1,D19,TRUE))/360,1),0)","v":0},{"$f":"IF(AND(C19<>\"\",D19<>\"\"),FLOOR(((DAYS360(C19,D19+1,TRUE))-E19*360)/30,1),0)","v":0},{"$f":"IF(AND(C19<>\"\",D19<>\"\"),(DAYS360(C19,D19+1,TRUE))-E19*360-F19*30,0)","v":0},"Servizio utile alla data di cessazione",null,null,null,null,{"$f":"SUM($E$13,$M$18,INT(INT(SUM($F$13,$N$18)+INT(SUM($G$13,$O$18)/30))/12))","v":42},{"$f":"IF(M19=40,0,MOD(SUM($F$13,$N$18,INT(SUM($G$13,$O$18)/30)),12))","v":4},{"$f":"IF(M19=40,0,MOD(SUM($G$13,$O$18),30))","v":15},null,null,null,{"$f":"tabprev!A19","v":16},{"$f":"tabprev!B19","v":0.36799999999999999},1987,0.36799999999999999,0.36799999999999999]
["Tot. Servizi utili dal 1.1.93 al 31.12.95",null,null,null,{"$f":"SUM(SUM($E$16:$E$19),INT(INT(SUM($F$16:$F$19)+INT(SUM($G$16:$G$19)/30))/12))","v":3},{"$f":"MOD(SUM(SUM($F$16:$F$19),INT(SUM($G$16:$G$19)/30)),12)","v":0},{"$f":"MOD(SUM($G$16:$G$19),30)","v":0},"Calcolo aliquota di pensione alla data di cessazione",null,null,null,null,null,null,null,null,null,null,{"$f":"tabprev!A20","v":17},{"$f":"tabprev!B20","v":0.38600000000000001},1988,0.38600000000000001,0.38600000000000001]
["Calcolo Servizi Utlili dal 1.1.96 fino alla data di cessazione",null,null,null,null,null,null,null,null,null,null,null,"anni:","mesi:","aliquota (a)",null,null,null,{"$f":"tabprev!A21","v":18},{"$f":"tabprev!B21","v":0.40400000000000003},1989,0.40400000000000003,0.40400000000000003]
["mansione",null,"dal:","al:","anni:","mesi:","giorni:",null,null,null,null,null,40,0,{"$f":"MIN($T$1,$V$1)","v":0.8},null,null,null,{"$f":"tabprev!A22","v":19},{"$f":"tabprev!B22","v":0.42199999999999999},1990,0.42199999999999999,0.42199999999999999]
[null,null,"1996-01-01","2012-02-29",{"$f":"IF(AND(C23<>\"\",D23<>\"\"),FLOOR((DAYS360(C23,D23+1,TRUE))/360,1),0)","v":16},{"$f":"IF(AND(C23<>\"\",D23<>\"\"),FLOOR(((DAYS360(C23,D23+1,TRUE))-E23*360)/30,1),0)","v":2},{"$f":"IF(AND(C23<>\"\",D23<>\"\"),(DAYS360(C23,D23+1,TRUE))-E23*360-F23*30,0)","v":0},"Calcolo aliquota differenza tra aliq.data cessaz. e aliq. al 31.12.92",null,null,null,null,null,null,null,null,null,null,{"$f":"tabprev!A23","v":20},{"$f":"tabprev!B23","v":0.44},1991,0.44,0.44]
[null,null,null,null,{"$f":"IF(AND(C24<>\"\",D24<>\"\"),FLOOR((DAYS360(C24,D24+1,TRUE))/360,1),0)","v":0},{"$f":"IF(AND(C24<>\"\",D24<>\"\"),FLOOR(((DAYS360(C24,D24+1,TRUE))-E24*360)/30,1),0)","v":0},{"$f":"IF(AND(C24<>\"\",D24<>\"\"),(DAYS360(C24,D24+1,TRUE))-E24*360-F24*30,0)","v":0},"Diff.(dal 1.1.93 alla cessaz.) in anni e mesi (a - b)",null,null,null,null,"anni:","mesi:","aliquota",null,null,null,{"$f":"tabprev!A24","v":21},{"$f":"tabprev!B24","v":0.45800000000000002},1992,0.45800000000000002,0.45800000000000002]
[null,null,null,null,{"$f":"IF(AND(C25<>\"\",D25<>\"\"),FLOOR((DAYS360(C25,D25+1,TRUE))/360,1),0)","v":0},{"$f":"IF(AND(C25<>\"\",D25<>\"\"),FLOOR(((DAYS360(C25,D25+1,TRUE))-E25*360)/30,1),0)","v":0},{"$f":"IF(AND(C25<>\"\",D25<>\"\"),(DAYS360(C25,D25+1,TRUE))-E25*360-F25*30,0)","v":0},null,null,null,null,null,{"$f":"INT(($M$22*12+$N$22-($M$5*12+$N$5))/12)","v":19},{"$f":"MOD($N$22+$M$22*12-($N$5+$M$5*12),12)","v":2},{"$f":"INDEX($W$3:$W$43,MATCH($M25,$S$3:$S$43,0))+(INDEX($W$3:$W$43,MATCH($M25+1,$S$3:$S$43,0))-INDEX($W$3:$W$43,MATCH($M25,$S$3:$S$43,0)))/12*N25","v":0.42499999999999999},null,null,null,{"$f":"tabprev!A25","v":22},{"$f":"tabprev!B25","v":0.47599999999999998},1993,0.47599999999999998,0.47599999999999998]
[null,null,null,null,{"$f":"IF(AND(C26<>\"\",D26<>\"\"),FLOOR((DAYS360(C26,D26+1,TRUE))/360,1),0)","v":0},{"$f":"IF(AND(C26<>\"\",D26<>\"\"),FLOOR(((DAYS360(C26,D26+1,TRUE))-E26*360)/30,1),0)","v":0},{"$f":"IF(AND(C26<>\"\",D26<>\"\"),(DAYS360(C26,D26+1,TRUE))-E26*360-F26*30,0)","v":0},"Calcolo periodo riferim. (dal 1.1.93 alla data di decorrenza della pensione)",null,null,null,null,null,null,null,null,null,null,{"$f":"tabprev!A26","v":23},{"$f":"tabprev!B26","v":0.49399999999999999},1994,0.49399999999999999,0.49399999999999999]
["Totale Serv.utili dal 1.1.96 alla data cess.",null,null,null,{"$f":"SUM(SUM($E$23:$E$26),INT(INT(SUM($F$23:$F$26)+INT(SUM($G$23:$G$26)/30))/12))","v":16},{"$f":"MOD(SUM(SUM($F$23:$F$26),INT(SUM($G$23:$G$26)/30)),12)","v":2},{"$f":"MOD(SUM($G$23:$G$26),30)","v":0},null,null,null,null,"dal:","al:","mesi:",null,null,null,null,{"$f":"tabprev!A27","v":24},{"$f":"tabprev!B27","v":0.51200000000000001},1995,0.51400000000000001,0.51200000000000001]
[null,null,null,null,null,null,null,"Calcolo mesi dal 1.1.93 al 31.12.95 al 50%",null,null,null,"1993-01-01","1995-12-31",{"$f":"ROUND(SUM($E$20*360,$F$20*30,$G$20)/30*50%,0)","v":18},null,null,null,null,{"$f":"tabprev!A28","v":25},{"$f":"tabprev!B28","v":0.53},1996,0.53400000000000003,0.53]
[null,null,null,null,null,null,null,"Calcolo mesi dal 1.1.96 alla data cess.al 66,6%",null,null,null,"1996-01-01",{"$f":"$O$2","v":"2012-02-29"},{"$f":"ROUND(SUM($E$27*360,$F$27*30,$G$27)/30*66.6%,0)","v":129},null,null,null,null,{"$f":"tabprev!A29","v":26},{"$f":"tabprev!B29","v":0.54800000000000004},1997,0.55400000000000005,0.54800000000000004]
[null,null,null,null,null,null,null,"Periodo di riferimento in mesi",null,null,null,null,null,{"$f":"MIN(120,SUM(N28:N29))","v":120},null,null,null,null,{"$f":"tabprev!A30","v":27},{"$f":"tabprev!B30","v":0.56599999999999995},1998,0.57400000000000007,0.56599999999999995]
["CALCOLO SOMMATORIA RETRIBUZIONI RIVALUTATE DEL PERIODO DI RIFERIMENTO\nRetribuz. dalla data di cessaz. in poi, a ritroso nel tempo, fino a raggiungere il n° di mesi del periodo di riferim. per il calcolo della quota B di pensione",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tabprev!A31","v":28},{"$f":"tabprev!B31","v":0.58399999999999996},1999,0.59400000000000008,0.58399999999999996]
["(ogni riga deve riferirsi ad un solo anno. I periodi che si collocano a cavallo di più anni devono essere spezzati per anno)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tabprev!A32","v":29},{"$f":"tabprev!B32","v":0.60199999999999998},2000,0.6140000000000001,0.60199999999999998]
["dal","al","n° mesi","somma cumulata mesi","anno","stip.annuo lordo e vac.contr.\n(c)","retribuz. individ. anzianità\n(d)","assegno pers. ex Agensud\n(e)","assegno personale L.239/04\n(f)","increm. 18%\nsu c+d+e+f","ind.int. spec.\nIIS","comp. access.\n(indenn.\nammin.)","altri compensi accessori","coeffic. rivalut.\n(compr.1%)","coeff. x increm. 1%","imp.rival. x i mesi corrisp.\nsoluzione 1",null,null,{"$f":"tabprev!A33","v":30},{"$f":"tabprev!B33","v":0.62},2001,0.63400000000000012,0.62,"Retr. fisse e cont. secondo me","Retr.fisse e cont. secondo M.S.E.","Diff. Secondo me - secondo M.S.E."]
["2012-01-01","2012-02-29",{"$f":"ROUND((B34-A34)/30,0)","v":2},{"$f":"IF(AND(A34=\"\",B34=\"\"),0,IF(ROUND(SUM($C$34:C34),0)<=$N$30,ROUND(SUM($C$34:C34),0),\"oltre limite\"))","v":2},{"$f":"IF(AND(A34=\"\",B34=\"\"),0,IF(YEAR(A34)=YEAR(B34),YEAR(B34),\"data err.\"))","v":2012},22100,2000,null,300,{"$f":"IF(AND($A34=\"\",$B34=\"\"),0,IF(AND($Q33=0,$R33=0),SUM($F34:$I34)*18%,0))","v":4392},6641.4000000000005,3930,0,{"$f":"IF(AND($A34=\"\",$B34=\"\"),0,IF(OR(YEAR($A34)=YEAR($O$2),YEAR($A34)=YEAR($O$2)-1),1,IF(AND($Q33=0,$R33=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A34),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":1},{"$f":"IF(N34=1,1,IF(N34=0,0,O33+1%))","v":1},{"$f":"IF(AND($A34=\"\",$B34=\"\"),0,IF(AND($Q33=0,$R33=0),ROUND((SUM($F34:$I34,$K34)/12*$C34+MAX($J34/12*$C34,SUM($L34/12*$C34,$M34)))*$N34*$O34,2),0))","v":5905.57},{"$f":"IF(AND($A34=\"\",$B34=\"\"),0,IF(ROUND(SUM($C34:$C$35),0)<=$N$30,0,1))","v":0},{"$f":"IF(AND($A34=\"\",$B34=\"\"),0,IF(YEAR($A34)=YEAR($B34),0,1))","v":0},{"$f":"tabprev!A34","v":31},{"$f":"tabprev!B34","v":0.63800000000000001},2002,0.65400000000000014,0.63800000000000001,{"$f":"SUM(F34:I34,K34)","v":31041.4},32230.92,{"$f":"X34-Y34","v":-1189.5199999999968}]
["2011-01-01","2011-12-31",12,{"$f":"IF(AND(A35=\"\",B35=\"\"),0,IF(ROUND(SUM($C$34:C35),0)<=$N$30,ROUND(SUM($C$34:C35),0),\"oltre limite\"))","v":14},2011,22000,2000,null,300,4374,6641.4000000000005,3930,4000,{"$f":"IF(AND($A35=\"\",$B35=\"\"),0,IF(OR(YEAR($A35)=YEAR($O$2),YEAR($A35)=YEAR($O$2)-1),1,IF(AND($Q34=0,$R34=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A35),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":1},1,{"$f":"IF(AND($A35=\"\",$B35=\"\"),0,IF(AND($Q34=0,$R34=0),ROUND((SUM($F35:$H35,$K35,$I35)/12*$C35+MAX($J35/12*$C35,SUM($L35/12*$C35,$M35)))*$N35*$O35,2),0))","v":38871.4},{"$f":"IF(AND($A35=\"\",$B35=\"\"),0,IF(ROUND(SUM($C$35:$C35),0)<=$N$30,0,1))","v":0},0,{"$f":"tabprev!A35","v":32},{"$f":"tabprev!B35","v":0.65600000000000003},2003,0.67400000000000015,0.65600000000000003,30941.4,32230.92,-1289.5199999999968]
["2010-01-01","2010-12-31",12,{"$f":"IF(AND(A36=\"\",B36=\"\"),0,IF(ROUND(SUM($C$34:C36),0)<=$N$30,ROUND(SUM($C$34:C36),0),\"oltre limite\"))","v":26},2010,21100,2000,null,300,4212,6641.4000000000005,3930,5000,{"$f":"IF(AND($A36=\"\",$B36=\"\"),0,IF(OR(YEAR($A36)=YEAR($O$2),YEAR($A36)=YEAR($O$2)-1),1,IF(AND($Q35=0,$R35=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A36),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":1.0269482884195194},1.01,40421.83,{"$f":"IF(AND($A36=\"\",$B36=\"\"),0,IF(ROUND(SUM($C$35:$C36),0)<=$N$30,0,1))","v":0},0,{"$f":"tabprev!A36","v":33},{"$f":"tabprev!B36","v":0.67400000000000004},2004,0.69400000000000017,0.67400000000000004,30041.4,32155.11,-2113.7099999999991]
["2009-01-01","2009-12-31",12,{"$f":"IF(AND(A37=\"\",B37=\"\"),0,IF(ROUND(SUM($C$34:C37),0)<=$N$30,ROUND(SUM($C$34:C37),0),\"oltre limite\"))","v":38},2009,20000,2000,null,300,4014,6641.4,3930,5000,{"$f":"IF(AND($A37=\"\",$B37=\"\"),0,IF(OR(YEAR($A37)=YEAR($O$2),YEAR($A37)=YEAR($O$2)-1),1,IF(AND($Q36=0,$R36=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A37),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":1.0436713545521836},1.02,40315.800000000003,{"$f":"IF(AND($A37=\"\",$B37=\"\"),0,IF(ROUND(SUM($C$35:$C37),0)<=$N$30,0,1))","v":0},0,{"$f":"tabprev!A37","v":34},{"$f":"tabprev!B37","v":0.69199999999999995},2005,0.71400000000000019,0.69199999999999995,28941.4,32014.32,-3072.9199999999983]
["2008-01-01","2008-12-31",12,{"$f":"IF(AND(A38=\"\",B38=\"\"),0,IF(ROUND(SUM($C$34:C38),0)<=$N$30,ROUND(SUM($C$34:C38),0),\"oltre limite\"))","v":50},2008,19000,2000,800,300,3978,6641.4,3085.51,6000,{"$f":"IF(AND($A38=\"\",$B38=\"\"),0,IF(OR(YEAR($A38)=YEAR($O$2),YEAR($A38)=YEAR($O$2)-1),1,IF(AND($Q37=0,$R37=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A38),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":1.0506706408345754},1.03,40935.93,{"$f":"IF(AND($A38=\"\",$B38=\"\"),0,IF(ROUND(SUM($C$35:$C38),0)<=$N$30,0,1))","v":0},0,{"$f":"tabprev!A38","v":35},{"$f":"tabprev!B38","v":0.71},2006,0.73400000000000021,0.71,28741.4,31776.48,-3035.0799999999981]
["2007-01-01","2007-12-31",12,{"$f":"IF(AND(A39=\"\",B39=\"\"),0,IF(ROUND(SUM($C$34:C39),0)<=$N$30,ROUND(SUM($C$34:C39),0),\"oltre limite\"))","v":62},2007,18000,2000,1000,1190,3994.2,6641.3999999999987,1854.0075000000002,6000,{"$f":"IF(AND($A39=\"\",$B39=\"\"),0,IF(OR(YEAR($A39)=YEAR($O$2),YEAR($A39)=YEAR($O$2)-1),1,IF(AND($Q38=0,$R38=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A39),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":1.0846153846153845},1.04,41381.14,{"$f":"IF(AND($A39=\"\",$B39=\"\"),0,IF(ROUND(SUM($C$35:$C39),0)<=$N$30,0,1))","v":0},0,{"$f":"tabprev!A39","v":36},{"$f":"tabprev!B39","v":0.72799999999999998},2007,0.75400000000000023,0.72799999999999998,28831.399999999998,30946.7,-2115.3000000000029]
["2006-01-01","2006-12-31",12,{"$f":"IF(AND(A40=\"\",B40=\"\"),0,IF(ROUND(SUM($C$34:C40),0)<=$N$30,ROUND(SUM($C$34:C40),0),\"oltre limite\"))","v":74},2006,17100,2000,2300,1200,4068,6641.4,556.48,3000,{"$f":"IF(AND($A40=\"\",$B40=\"\"),0,IF(OR(YEAR($A40)=YEAR($O$2),YEAR($A40)=YEAR($O$2)-1),1,IF(AND($Q39=0,$R39=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A40),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":1.103286384976526},1.05,38587.300000000003,{"$f":"IF(AND($A40=\"\",$B40=\"\"),0,IF(ROUND(SUM($C$35:$C40),0)<=$N$30,0,1))","v":0},0,{"$f":"tabprev!A40","v":37},{"$f":"tabprev!B40","v":0.746},2008,0.77400000000000024,0.746,29241.4,30949.32,-1707.9199999999983]
["2005-01-01","2005-12-31",12,{"$f":"IF(AND(A41=\"\",B41=\"\"),0,IF(ROUND(SUM($C$34:C41),0)<=$N$30,ROUND(SUM($C$34:C41),0),\"oltre limite\"))","v":86},2005,16000,2000,2600,1200,3924,6641.3999999999987,332.95166666666671,3000,{"$f":"IF(AND($A41=\"\",$B41=\"\"),0,IF(OR(YEAR($A41)=YEAR($O$2),YEAR($A41)=YEAR($O$2)-1),1,IF(AND($Q40=0,$R40=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A41),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":1.1252992817238627},1.06,38606.01,{"$f":"IF(AND($A41=\"\",$B41=\"\"),0,IF(ROUND(SUM($C$35:$C41),0)<=$N$30,0,1))","v":0},0,{"$f":"tabprev!A41","v":38},{"$f":"tabprev!B41","v":0.76400000000000001},2009,0.79400000000000026,0.76400000000000001,28441.399999999998,30917.34,-2475.9400000000023]
["2004-01-01","2004-12-31",12,{"$f":"IF(AND(A42=\"\",B42=\"\"),0,IF(ROUND(SUM($C$34:C42),0)<=$N$30,ROUND(SUM($C$34:C42),0),\"oltre limite\"))","v":98},2004,16900,2000,2900,800,4068,6641.4,null,2000,{"$f":"IF(AND($A42=\"\",$B42=\"\"),0,IF(OR(YEAR($A42)=YEAR($O$2),YEAR($A42)=YEAR($O$2)-1),1,IF(AND($Q41=0,$R41=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A42),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":1.1444805194805194},1.07,40790.5,{"$f":"IF(AND($A42=\"\",$B42=\"\"),0,IF(ROUND(SUM($C$35:$C42),0)<=$N$30,0,1))","v":0},0,{"$f":"tabprev!A42","v":39},{"$f":"tabprev!B42","v":0.78200000000000003},2010,0.81400000000000028,0.78200000000000003,29241.4,30565.56,-1324.1599999999999]
["2003-01-01","2003-12-31",12,{"$f":"IF(AND(A43=\"\",B43=\"\"),0,IF(ROUND(SUM($C$34:C43),0)<=$N$30,ROUND(SUM($C$34:C43),0),\"oltre limite\"))","v":110},2003,16000,2000,3000,null,3780,6641.4,null,2000,{"$f":"IF(AND($A43=\"\",$B43=\"\"),0,IF(OR(YEAR($A43)=YEAR($O$2),YEAR($A43)=YEAR($O$2)-1),1,IF(AND($Q42=0,$R42=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A43),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":1.1672185430463577},1.08,39609.69,{"$f":"IF(AND($A43=\"\",$B43=\"\"),0,IF(ROUND(SUM($C$35:$C43),0)<=$N$30,0,1))","v":0},0,{"$f":"tabprev!A43","v":40},{"$f":"tabprev!B43","v":0.8},2011,0.8340000000000003,0.8,27641.4,29671.8,-2030.3999999999978]
["2002-03-01","2002-12-31",10,{"$f":"IF(AND(A44=\"\",B44=\"\"),0,IF(ROUND(SUM($C$34:C44),0)<=$N$30,ROUND(SUM($C$34:C44),0),\"oltre limite\"))","v":120},2002,15000,2000,4000,null,3780,6641.4,null,2500,{"$f":"IF(AND($A44=\"\",$B44=\"\"),0,IF(OR(YEAR($A44)=YEAR($O$2),YEAR($A44)=YEAR($O$2)-1),1,IF(AND($Q43=0,$R43=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A44),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":1.1959287531806615},1.0900000000000001,34133.129999999997,{"$f":"IF(AND($A44=\"\",$B44=\"\"),0,IF(ROUND(SUM($C$35:$C44),0)<=$N$30,0,1))","v":0},0,null,null,null,null,null,27641.4,29671.8,-2030.3999999999978]
[null,null,0,{"$f":"IF(AND(A45=\"\",B45=\"\"),0,IF(ROUND(SUM($C$34:C45),0)<=$N$30,ROUND(SUM($C$34:C45),0),\"oltre limite\"))","v":0},0,null,null,null,null,0,null,null,0,{"$f":"IF(AND($A45=\"\",$B45=\"\"),0,IF(OR(YEAR($A45)=YEAR($O$2),YEAR($A45)=YEAR($O$2)-1),1,IF(AND($Q44=0,$R44=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A45),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":0},0,0,{"$f":"IF(AND($A45=\"\",$B45=\"\"),0,IF(ROUND(SUM($C$35:$C45),0)<=$N$30,0,1))","v":0},0,null,null,null,null,null,0]
[null,null,0,{"$f":"IF(AND(A46=\"\",B46=\"\"),0,IF(ROUND(SUM($C$34:C46),0)<=$N$30,ROUND(SUM($C$34:C46),0),\"oltre limite\"))","v":0},0,null,null,null,null,0,null,null,0,{"$f":"IF(AND($A46=\"\",$B46=\"\"),0,IF(OR(YEAR($A46)=YEAR($O$2),YEAR($A46)=YEAR($O$2)-1),1,IF(AND($Q45=0,$R45=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A46),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":0},0,0,{"$f":"IF(AND($A46=\"\",$B46=\"\"),0,IF(ROUND(SUM($C$35:$C46),0)<=$N$30,0,1))","v":0},0,null,null,null,null,null,0]
[null,null,0,{"$f":"IF(AND(A47=\"\",B47=\"\"),0,IF(ROUND(SUM($C$34:C47),0)<=$N$30,ROUND(SUM($C$34:C47),0),\"oltre limite\"))","v":0},0,null,null,null,null,0,null,null,0,{"$f":"IF(AND($A47=\"\",$B47=\"\"),0,IF(OR(YEAR($A47)=YEAR($O$2),YEAR($A47)=YEAR($O$2)-1),1,IF(AND($Q46=0,$R46=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A47),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":0},0,0,{"$f":"IF(AND($A47=\"\",$B47=\"\"),0,IF(ROUND(SUM($C$35:$C47),0)<=$N$30,0,1))","v":0},0,null,null,null,null,null,0]
[null,null,0,{"$f":"IF(AND(A48=\"\",B48=\"\"),0,IF(ROUND(SUM($C$34:C48),0)<=$N$30,ROUND(SUM($C$34:C48),0),\"oltre limite\"))","v":0},0,null,null,null,null,0,null,null,0,{"$f":"IF(AND($A48=\"\",$B48=\"\"),0,IF(OR(YEAR($A48)=YEAR($O$2),YEAR($A48)=YEAR($O$2)-1),1,IF(AND($Q47=0,$R47=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A48),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":0},0,0,{"$f":"IF(AND($A48=\"\",$B48=\"\"),0,IF(ROUND(SUM($C$35:$C48),0)<=$N$30,0,1))","v":0},0,null,null,null,null,null,0]
[null,null,0,{"$f":"IF(AND(A49=\"\",B49=\"\"),0,IF(ROUND(SUM($C$34:C49),0)<=$N$30,ROUND(SUM($C$34:C49),0),\"oltre limite\"))","v":0},0,null,null,null,null,0,null,null,0,{"$f":"IF(AND($A49=\"\",$B49=\"\"),0,IF(OR(YEAR($A49)=YEAR($O$2),YEAR($A49)=YEAR($O$2)-1),1,IF(AND($Q48=0,$R48=0),INDEX(tabprev!$D$3:$P$22,MATCH(YEAR($A49),tabprev!$C$3:$C$22,0),MATCH(YEAR($O$2),tabprev!$D$2:$P$2,0)))))","v":0},0,0,{"$f":"IF(AND($A49=\"\",$B49=\"\"),0,IF(ROUND(SUM($C$35:$C49),0)<=$N$30,0,1))","v":0},0,null,null,null,null,null,0]
["TOTALE MESI",null,{"$f":"SUM(C$34:C49)","v":120},null,null,null,null,null,null,"TOTALE IMPORTI RIVALUTATI",null,null,null,null,null,{"$f":"SUM($P$34:$P49)","v":399558.3}]
["Calcolo retribuzione media annua",null,null,null,null,null,"Calcolo quota B di pensione annua",null,null,null,"Calcolo pensione annua",null,null,null,"Pensione x 12 mensilità + 13ma",null,null,null,null,null,null,null,{"$f":"SUM($F49,$K49,$L49,$M49)","v":0}]
["Totale retrib.periodo riferim., rival.:",null,null,null,{"$f":"IF(AND($Q$49=0,$R$49=0),IF(MAX($D$34:$D$49)=$E$53,$P$50,0),0)","v":399558.3},null,"Retribuz. media annua",null,{"$f":"E55","v":39955.829999999994},{"$f":"\"x\"","v":"x"},"Quota A",null,{"$f":"M$16","v":13287.525000000003},null,null,null,null,null,null,null,null,null,{"$f":"SUM($F50,$J50,$K50,$M50)","v":0}]
["N° mesi periodo di riferimento",null,null,null,{"$f":"$N$30","v":120},null,"aliquota pensione dal 1.1.93 alla data cessaz.",null,{"$f":"$O$25","v":0.42499999999999999},{"$f":"\"=\"","v":"="},"Quota B",null,{"$f":"$I$55","v":16981.227749999998}]
["Retribuzione media mensile",null,null,null,{"$f":"IF(AND($Q$49=0,$R$49=0),IF($N$30<>0,E52/$N$30,0),0)","v":3329.6524999999997},null,null,null,null,null,"Pens.lorda",null,{"$f":"SUM(M$52:M$53)","v":30268.75275},null,{"$f":"$M54/12","v":2522.3960625}]
["Retribuzione media annua",null,null,null,{"$f":"E$54*12","v":39955.829999999994},null,"Quota B di pensione annua",null,{"$f":"I52*I53","v":16981.227749999998},null,"Pensione netta",null,{"$f":"'ire 2012 nota op.'!$H$7","v":23082.522752356253},null,{"$f":"$M55/12","v":1923.5435626963545}]

{"sheet":"ire 2012","index":2,"n_rows":62,"n_cols":18,"rows_kept":62,"cut":false,"hidden":false,"merged":[[8,5,9,5],[2,0,3,1],[0,2,0,3],[1,2,1,3],[4,0,4,2],[7,0,7,4],[4,3,4,4],[4,5,4,6],[15,0,15,3],[34,8,34,9],[35,8,35,9],[16,0,16,3],[29,5,29,7],[30,5,30,7],[27,5,27,7],[28,5,28,7],[18,0,18,5],[33,5,33,7],[34,6,34,7],[24,5,25,7],[24,4,25,4],[24,0,25,3],[11,0,11,3],[26,8,26,9],[38,0,38,1],[40,0,40,1],[37,0,37,11],[12,0,12,3],[13,0,13,3],[14,0,14,3],[39,0,39,1],[23,0,23,11],[22,0,22,11],[18,6,20,11],[24,8,25,9],[39,5,39,6],[31,5,31,7],[32,5,32,7],[61,6,61,7],[59,5,59,7],[60,6,60,7],[55,4,55,9],[58,5,58,7],[57,0,57,11],[55,2,55,3],[58,10,61,10],[58,0,58,2],[42,0,42,1],[53,0,53,11],[47,10,50,10],[39,10,42,10],[49,0,49,1],[48,0,48,1],[48,5,48,6],[46,4,46,6],[47,5,47,6],[41,0,41,1],[54,1,54,3],[42,5,42,6],[4,7,5,8],[6,7,6,8],[51,0,51,1],[50,0,50,1],[46,0,46,1],[40,5,40,6],[45,0,45,11],[54,4,54,9],[38,4,38,6],[49,5,49,6],[50,5,50,6],[41,5,41,6],[47,0,47,1],[43,0,43,1]]}
[{"$f":"\"reddito imponibile netto esercizio \" & RIGHT(CELL(\"nomefile\",$A$1),4)-2","v":"reddito imponibile netto esercizio 2010"},{"$f":"\"reddito imponibile netto esercizio \" & RIGHT(CELL(\"nomefile\",$A$1),4)-1","v":"reddito imponibile netto esercizio 2011"},{"$f":"\"reddito imponibile netto esercizio \" & RIGHT(CELL(\"nomefile\",$A$1),4)","v":"reddito imponibile netto esercizio 2012"},null,null,null,null,null,null,null,null,null,800,900,220,200,95000,15000]
[45094,53644,{"$f":"Pensione!$O$54*13","v":32193.434314166669}]
["Detrazioni d'imposta:",null,"Coniuge mancante","Detrazione coniuge (SI/NO)","n.fig.>.3 anni non hand.","n.fig.<= 3 anni non handicap","n.fig.>.3 anni e hand.","n.fig.<= 3 anni e hand.","% detraz\n(0,5=50%/1=100%)","n.mesi carico","Altre persone","Detrazione per redditi da pensione"]
[null,null,null,"no",null,null,null,null,null,null,null,"si"]
[{"$f":"\"CALCOLO IMPOSTA LORDA ED ALIQUOTA MASSIMA ESERCIZIO \"&RIGHT(CELL(\"nomefile\",$A$5),4) & \" secondo me\"","v":"CALCOLO IMPOSTA LORDA ED ALIQUOTA MASSIMA ESERCIZIO 2012 secondo me"},null,null,{"$f":"\"CALCOLO ADDIZIONALE REGIONALE ESERCIZIO \"& RIGHT(CELL(\"nomefile\",$A$1),4) & \" secondo me\"","v":"CALCOLO ADDIZIONALE REGIONALE ESERCIZIO 2012 secondo me"},null,{"$f":"\"CALCOLO ADDIZIONALE COMUNALE ESERCIZIO \"& RIGHT(CELL(\"nomefile\",$A$1),4) & \" secondo me\"","v":"CALCOLO ADDIZIONALE COMUNALE ESERCIZIO 2012 secondo me"},null,{"$f":"\"CALCOLO REDDITO NETTO ANNUO ESERCIZIO \"& RIGHT(CELL(\"nomefile\",$A$1),4) & \" secondo me\"","v":"CALCOLO REDDITO NETTO ANNUO ESERCIZIO 2012 secondo me"}]
[{"$f":"\"reddito imponibile netto esercizio \" & RIGHT(CELL(\"nomefile\",$A$5),4)","v":"reddito imponibile netto esercizio 2012"},{"$f":"\"ire lorda \" & RIGHT(CELL(\"nomefile\",$A$5),4)","v":"ire lorda 2012"},{"$f":"\"aliquota massima \" & RIGHT(CELL(\"nomefile\",$A$5),4)","v":"aliquota massima 2012"},{"$f":"\"aliquota massima \" & RIGHT(CELL(\"nomefile\",$A$1),4)","v":"aliquota massima 2012"},{"$f":"\"importo addizionale \" & RIGHT(CELL(\"nomefile\",$A$1),4)","v":"importo addizionale 2012"},{"$f":"\"aliquota massima \" & RIGHT(CELL(\"nomefile\",$A$1),4)","v":"aliquota massima 2012"},{"$f":"\"importo addizionale \" & RIGHT(CELL(\"nomefile\",$A$1),4)","v":"importo addizionale 2012"}]
[{"$f":"C2","v":32193.434314166669},{"$f":"irelordaannuapensionatisecondome($A$7,ROW($B$21),COLUMN($B$21))","v":8553.5050393833335},{"$f":"aliquotamassimasecondome($A$7,ROW($B$21),COLUMN($B$21))","v":1},2.0299999999999999E-2,{"$f":"C2*D7","v":653.52671657758333},8.0000000000000002E-3,{"$f":"C2*F7","v":257.54747451333333},{"$f":"A7-B7-E7-G7","v":22728.855083692419}]
[{"$f":"\"CALCOLO ALIQUOTA MEDIA BIENNIO \"&RIGHT(CELL(\"nomefile\",$A$1),4)-2&\" - \"&RIGHT(CELL(\"nomefile\",A1),4)-1","v":"CALCOLO ALIQUOTA MEDIA BIENNIO 2010 - 2011"}]
[{"$f":"\"reddito imponibile netto esercizio \" & RIGHT(CELL(\"nomefile\",$A$5),4)-2","v":"reddito imponibile netto esercizio 2010"},{"$f":"\"reddito imponibile netto esercizio \" & RIGHT(CELL(\"nomefile\",$A$5),4)-1","v":"reddito imponibile netto esercizio 2011"},{"$f":"\"reddito medio biennio \"&RIGHT(CELL(\"nomefile\",$A$5),4)-2&\" - \"&RIGHT(CELL(\"nomefile\",$A$5),4)-1","v":"reddito medio biennio 2010 - 2011"},{"$f":"\"ire corrispondente al reddito medio\"","v":"ire corrispondente al reddito medio"},{"$f":"\"aliquota media \" & RIGHT(CELL(\"nomefile\",$A$5),4)","v":"aliquota media 2012"}]
[{"$f":"A2","v":45094},{"$f":"B2","v":53644},{"$f":"SUM(A10:B10)/2","v":49369},{"$f":"irexaliqmediasecondome($C$10,ROW($B$21),COLUMN($B$21))","v":4088656.115944},0]
[null,null,null,null,"IRE su Pensione"]
["ire lorda annua",null,null,null,{"$f":"irelordaannuapensionatisecondome($C$2,ROW($B$21),COLUMN($B$21))","v":8553.5050393833335}]
["Detrazione coniuge",null,null,null,{"$f":"IF(AND($C$2<>\"\",UPPER($D$4)=\"SI\"),INDEX($L$27:$L$36,MATCH($C$2,$K$27:$K$36,1)+1,1),0)","v":0}]
["Detrazione figli",null,null,null,{"$f":"SUM($H$40:$I$43,$H$48:$I$51)","v":0}]
["Altre persone",null,null,null,{"$f":"$L$56","v":0}]
["Detrazione per reddito da pensione",null,null,null,{"$f":"IF(AND($C$2<>\"\",UPPER($L$4)=\"SI\"),INDEX($L$59:$L$62,MATCH($C$2,$D$59:$D$62,1)+1),0)","v":715.47550000000001}]
["ire netta annua",null,null,null,{"$f":"IF(E$12-E$13-E$14-E$15-E$16<=0,0,E$12-E$13-E$14-E$15-E$16)","v":7838.029539383333}]
[]
["Aliquote e scaglioni IRE:"]
["aliquote:",0.23,0.27,0.38,0.41,0.43]
["scaglioni (fino a):",15000,28000,55000,75000,"(oltre 75.000)"]
[]
["DETRAZIONI PER CARICO DI FAMIGLIA\n(Coniuge, figli o altri familiari a carico se con reddito annuo <= 2.840,51)"]
["Coniuge"]
["scaglioni di reddito",null,null,null,"detrazione teorica","detrazione effettiva",null,null,"note",null,"redd.scag.+1","detraz."]
[null,null,null,null,null,null,null,null,null,null,0,0]
["da",0,"fino a",15000,800,"800 - ",110,"                         r.c.\nx -----------\n                       15.000,00","se rapporto = 1 allora detrazione = 690\nse rapporto = 0 allora detrazione = 0",null,{"$f":"D27+1","v":15001},{"$f":"IF(AND($A$7>$B$27,$A$7<=$D$27),IF($A$7/$D$27=0,0,IF($A$7/$D$27=1,690,$E$27-$G$27*$A$7/$D$27)),0)","v":0}]
["oltre",15000,"fino a",29000,null,690,null,null,null,null,29001,{"$f":"IF(AND($A$7>$B$28,$A$7<=$D$28),$F$28,0)","v":0}]
["oltre",29000,"fino a",29200,null,700,null,null,"690 + ",10,29201,{"$f":"IF(AND($A$7>$B$29,$A$7<=$D$29),$F$29,0)","v":0}]
["oltre",29200,"fino a",34700,null,710,null,null,"690 + ",20,34701,{"$f":"IF(AND($A$7>$B$30,$A$7<=$D$30),$F$30,0)","v":710}]
["oltre",34700,"fino a",35000,null,720,null,null,"690 + ",30,35001,{"$f":"IF(AND($A$7>$B$31,$A$7<=$D$31),$F$31,0)","v":0}]
["oltre",35000,"fino a",35100,null,710,null,null,"690 + ",20,35101,{"$f":"IF(AND($A$7>$B$32,$A$7<=$D$32),$F$32,0)","v":0}]
["oltre",35100,"fino a",35200,null,700,null,null,"690 + ",10,35201,{"$f":"IF(AND($A$7>$B$33,$A$7<=$D$33),$F$33,0)","v":0}]
["oltre",35200,"fino a",40000,null,690,null,null,null,null,40001,{"$f":"IF(AND($A$7>$B$34,$A$7<=$D$34),$F$34,0)","v":0}]
["oltre",40000,"fino a",80000,null,690,"  80.000,00 - r.c.\nx -------------------\n   40.000,00",null,"se rapporto = 0 allora detrazione = 0",null,80001,{"$f":"IF(AND($A$7>$B$35,$A$7<=$D$35),IF(($D$35-$A$7)/$B$35=0,0,$F$35*($D$35-$A$7)/$B$35),0)","v":0}]
["oltre",80000,null,99999,null,null,null,null,"non spetta alcuna detrazione",null,100000,0]
[]
["Figli (fino a 3)"]
[null,null,"n° figli","detraz. teoriche","detrazione spettante per ciascun figlio successivo al primo",null,null,"detraz.1° figlio","detraz. figli dal 2°","quoziente","note"]
["maggiore di 3 anni non portatori handicap",null,{"$f":"IF(SUM($C$4:$F$4)<=3,$E$4,0)","v":0},{"$f":"$M$1","v":800},{"$f":"D40","v":800},"   95.000 + 15.000 x (n.fig.tot. -1) - r.c.\nx  ---------------------------------------------\n        95.000+15 000 x (n.fig.tot. -1)",null,{"$f":"IF($C40>0,IF(UPPER($C$4)=\"SI\",MAX($D40*$J40,INDEX($L$26:$L$36,MATCH($A$7,$K$26:$K$36,1)+1,1)),$D40*$J40*$I$4*$J$4/12),0)","v":0},{"$f":"IF($H40<>0,$D40*$J40*($C40-1)*$I$4*$J$4/12,$D40*$J40*$C40*$I$4*$J$4/12)","v":0},{"$f":"ROUND(IF(OR((95000+15000*($E$4-1)-$A$7)/(95000+15000*($E$4-1))<0,(95000+15000*($E$4-1)-$A$7)/(95000+15000*($E$4-1))=1),0,(95000+15000*($E$4-1)-$A$7)/(95000+15000*($E$4-1))),4)","v":0.59760000000000002},"se il rapporto indicato è <= 0 oppure è = 1, allora detraz.spettante =0"]
["minore di 3 anni non portatori handicap",null,{"$f":"IF(SUM($C$4:$F$4)<=3,$F$4,0)","v":0},{"$f":"$N$1","v":900},{"$f":"D41","v":900},"   95.000 + 15.000 x (n.fig.tot. -1) - r.c.\nx  ---------------------------------------------\n        95.000+15 000 x (n.fig.tot. -1)",null,{"$f":"IF($C41>0,IF(UPPER($C$4)=\"SI\",MAX($D41*$J41,INDEX($L$26:$L$36,MATCH($A$7,$K$26:$K$36,1)+1,1)),$D41*$J41*$I$4*$J$4/12),0)","v":0},{"$f":"IF($C41>1,$D41*$J41*$C41*$I$4*$J$4/12,0)","v":0},{"$f":"J40","v":0.59760000000000002}]
["maggiore di 3 anni e portatore di handicap",null,{"$f":"IF(SUM($C$4:$F$4)<=3,$G$4,0)","v":0},{"$f":"$M$1+$O$1","v":1020},{"$f":"D42","v":1020},"   95.000 + 15.000 x (n.fig.tot. -1) - r.c.\nx  ---------------------------------------------\n        95.000+15000 x (n.fig.tot. -1)",null,{"$f":"IF($C42>0,IF(UPPER($C$4)=\"SI\",MAX($D42*$J42,INDEX($L$26:$L$36,MATCH($A$7,$K$26:$K$36,1)+1,1)),$D42*$J42*$I$4*$J$4/12),0)","v":0},{"$f":"IF($C42>1,$D42*$J42*$C42*$I$4*$J$4/12,0)","v":0},{"$f":"J40","v":0.59760000000000002}]
["minore di 3 anni e portatore di handicap",null,{"$f":"IF(SUM($C$4:$F$4)<=3,$H$4,0)","v":0},{"$f":"$D$41+$O$1","v":1120},{"$f":"D43","v":1120},"   95.000 + 15.000 x (n.fig.tot. -1) - r.c.\nx  ---------------------------------------------\n        95.000+15000 x (n.fig.tot. -1)",null,{"$f":"IF($C43>0,IF(UPPER($C$4)=\"SI\",MAX($D43*$J43,INDEX($L$26:$L$36,MATCH($A$7,$K$26:$K$36,1)+1,1)),$D43*$J43*$I$4*$J$4/12),0)","v":0},{"$f":"IF($C43>1,$D43*$J43*$C43*$I$4*$J$4/12,0)","v":0},{"$f":"J40","v":0.59760000000000002}]
["Totale figli",null,{"$f":"IF(SUM($C$4:$F$4)<=3,SUM($C$4:$F$4),0)","v":0}]
[]
["Figli (oltre i 3)\n(le detrazioni teoriche aumentano di 200 € per ciascun figlio a partire dal 1°)"]
[null,null,"n° figli","detrazioni teoriche","detrazione spettante per ciascun figlio successivo al primo",null,null,"detraz.1° figlio","detraz. figli dal 2°","quoziente","note"]
["maggiore di 3 anni non portatori handicap",null,{"$f":"IF(SUM($C$4:$F$4)>3,$E$4,0)","v":0},{"$f":"$M$1+200","v":1000},{"$f":"D48","v":1000},"   95.000 + 15.000 x (n.fig.tot. -1) - r.c.\nx  ---------------------------------------------\n        95.000+15000 x (n.fig.tot. -1)",null,{"$f":"IF($C48>0,IF(UPPER($C$4)=\"SI\",MAX($D48*$J48,INDEX($L$26:$L$36,MATCH($A$7,$K$26:$K$36,1)+1,1)),$D48*$J48*$I$4*$J$4/12),0)","v":0},{"$f":"IF($H48<>0,$D48*$J48*($C48-1)*$I$4*$J$4/12,$D48*$J48*$C48*$I$4*$J$4/12)","v":0},{"$f":"ROUND(IF(OR((95000+15000*($E$4-1)-$A$7)/(95000+15000*($E$4-1))<0,(95000+15000*($E$4-1)-$A$7)/(95000+15000*($E$4-1))=1),0,(95000+15000*($E$4-1)-$A$7)/(95000+15000*($E$4-1))),4)","v":0.59760000000000002},"se il rapporto indicato è <= 0 oppure è = 1, allora detraz.spettante =0"]
["minore di 3 anni non portatori handicap",null,{"$f":"IF(SUM($C$4:$F$4)>3,$F$4,0)","v":0},{"$f":"$N$1+200","v":1100},{"$f":"D49","v":1100},"   95.000 + 15.000 x (n.fig.tot. -1) - r.c.\nx  ---------------------------------------------\n        95.000+15000 x (n.fig.tot. -1)",null,{"$f":"IF($C49>0,IF(UPPER($C$4)=\"SI\",MAX($D49*$J49,INDEX($L$26:$L$36,MATCH($A$7,$K$26:$K$36,1)+1,1)),$D49*$J49*$I$4*$J$4/12),0)","v":0},{"$f":"IF($C49>1,$D49*$J49*$C49*$I$4*$J$4/12,0)","v":0},{"$f":"J48","v":0.59760000000000002}]
["maggiore di 3 anni e portatore di handicap",null,{"$f":"IF(SUM($C$4:$F$4)>3,$G$4,0)","v":0},{"$f":"$M$1+$O$1+200","v":1220},{"$f":"D50","v":1220},"   95.000 + 15.000 x (n.fig.tot. -1) - r.c.\nx  ---------------------------------------------\n        95.000+15000 x (n.fig.tot. -1)",null,{"$f":"IF($C50>0,IF(UPPER($C$4)=\"SI\",MAX($D50*$J50,INDEX($L$26:$L$36,MATCH($A$7,$K$26:$K$36,1)+1,1)),$D50*$J50*$I$4*$J$4/12),0)","v":0},{"$f":"IF($C50>1,$D50*$J50*$C50*$I$4*$J$4/12,0)","v":0},{"$f":"J48","v":0.59760000000000002}]
["minore di 3 anni e portatore di handicap",null,{"$f":"IF(SUM($C$4:$F$4)>3,$H$4,0)","v":0},{"$f":"$D$41+$O$1+200","v":1320},{"$f":"D51","v":1320},"   95.000 + 15.000 x (n.fig.tot. -1) - r.c.\nx  ---------------------------------------------\n        95.000+15.000 x (n.fig.tot. -1)",null,{"$f":"IF($C51>0,IF(UPPER($C$4)=\"SI\",MAX($D51*$J51,INDEX($L$26:$L$36,MATCH($A$7,$K$26:$K$36,1)+1,1)),$D51*$J51*$I$4*$J$4/12),0)","v":0},{"$f":"IF($C51>1,$D51*$J51*$C51*$I$4*$J$4/12,0)","v":0},{"$f":"J48","v":0.59760000000000002}]
["Totale figli",null,{"$f":"IF(SUM($C$4:$F$4)>3,SUM($C$4:$F$4),0)","v":0}]
[]
["Altre persone"]
["detraz. teorica","detrazione spettante per ciascun familiare",null,null,"note",null,null,null,null,null,"quoziente","detrazione"]
[750,{"$f":"A56","v":750},"   80.000 - r.c.\nx --------------\n      80.000",null,"se il rapporto indicato è <= 0 oppure è = 1, allora detraz.spettante =0",null,null,null,null,null,{"$f":"(80000-$A$7)/80000","v":0.59758207107291661},{"$f":"IF(AND(K56>0,K56<1),$B$56*INT(K56*10000)/10000,0)*$K$4","v":0}]
[]
["Detrazione per reddito da pensione (contribuenti che non hanno compiuto 75 anni)"]
["scaglioni di reddito",null,null,0,"detraz. teorica","detrazione effettiva",null,null,"redd.scag.+1","quoziente","se il periodo di lavoro nell'anno è inferiore a 365 giorni, allora la detrazione è pari a 690,00","detrazione"]
["da",0,"fino a",7500,null,1725,null,null,{"$f":"D60+1","v":7501},null,null,{"$f":"IF(AND($A$7>$B$60,$A$7<=$D$60),MAX($F60,690),0)","v":0}]
["oltre",7500,"fino a",15000,1255,{"$f":"E61","v":1255},"             15.000 - r.c.\n+ 470 x ----------------\n               7.500",null,{"$f":"D61+1","v":15001},{"$f":"(15000-$A$7)/7500","v":-2.2924579085555559},null,{"$f":"IF(AND($A$7>$B$61,$A$7<=$D$61),IF(AND(J61>0,J61<1),$E$61+470*INT(J61*10000)/10000,1),0)","v":0}]
["oltre",15000,"fino a",55000,1255,{"$f":"E62","v":1255},"  55.000 - r.c.\nx --------------\n    40.000",null,{"$f":"D62+1","v":55001},{"$f":"(55000-$A$7)/40000","v":0.57016414214583333},null,{"$f":"IF(AND($A$7>$B$62,$A$7<=$D$62),IF(AND(J62>0,J62<1),$E$62*INT(J62*10000)/10000,1),0)","v":715.47550000000001}]

{"sheet":"ire 2012 nota op.","index":3,"n_rows":62,"n_cols":18,"rows_kept":62,"cut":false,"hidden":false,"merged":[[57,0,57,11],[58,0,58,2],[58,5,58,7],[58,10,61,10],[59,5,59,7],[60,6,60,7],[61,6,61,7],[49,5,49,6],[50,0,50,1],[50,5,50,6],[53,0,53,11],[55,2,55,3],[55,4,55,9],[54,1,54,3],[54,4,54,9],[51,0,51,1],[34,8,34,9],[35,8,35,9],[37,0,37,11],[39,0,39,1],[39,5,39,6],[43,0,43,1],[45,0,45,11],[46,0,46,1],[46,4,46,6],[47,0,47,1],[47,5,47,6],[47,10,50,10],[48,0,48,1],[48,5,48,6],[49,0,49,1],[32,5,32,7],[33,5,33,7],[38,0,38,1],[38,4,38,6],[26,8,26,9],[30,5,30,7],[31,5,31,7],[39,10,42,10],[40,0,40,1],[40,5,40,6],[41,0,41,1],[41,5,41,6],[42,0,42,1],[42,5,42,6],[24,8,25,9],[14,0,14,3],[15,0,15,3],[16,0,16,3],[18,0,18,5],[18,6,20,11],[22,0,22,11],[8,5,9,5],[4,3,4,4],[4,5,4,6],[34,6,34,7],[11,0,11,3],[12,0,12,3],[27,5,27,7],[28,5,28,7],[29,5,29,7],[4,7,5,8],[6,7,6,8],[24,5,25,7],[13,0,13,3],[23,0,23,11],[24,0,25,3],[24,4,25,4],[0,2,0,3],[1,2,1,3],[2,0,3,1],[4,0,4,2],[7,0,7,4]]}
[{"$f":"\"reddito imponibile netto esercizio \" & LEFT(RIGHT(CELL(\"nomefile\",$A$1),13),4)-2","v":"reddito imponibile netto esercizio 2010"},{"$f":"\"reddito imponibile netto esercizio \" & LEFT(RIGHT(CELL(\"nomefile\",$A$1),13),4)-1","v":"reddito imponibile netto esercizio 2011"},{"$f":"\"reddito imponibile netto esercizio \" & LEFT(RIGHT(CELL(\"nomefile\",$A$1),13),4)","v":"reddito imponibile netto esercizio 2012"},null,null,null,null,null,null,null,null,null,800,900,220,200,95000,15000]
[45094,53644,{"$f":"'Pensione nota op.'!$O$54*13","v":32791.148812500003}]
["Detrazioni d'imposta:",null,"Coniuge mancante","Detrazione coniuge (SI/NO)","n.fig.>.3 anni non hand.","n.fig.<= 3 anni non handicap","n.fig.>.3 anni e hand.","n.fig.<= 3 anni e hand.","% detraz\n(0,5=50%/1=100%)","n.mesi carico","Altre persone","Detrazione per redditi da pensione"]
[null,null,null,"no",null,null,null,null,null,null,null,"si"]
[{"$f":"\"CALCOLO IMPOSTA LORDA ED ALIQUOTA MASSIMA ESERCIZIO \"& LEFT(RIGHT(CELL(\"nomefile\",$A$1),13),4) & \" secondo me\"","v":"CALCOLO IMPOSTA LORDA ED ALIQUOTA MASSIMA ESERCIZIO 2012 secondo me"},null,null,{"$f":"\"CALCOLO ADDIZIONALE REGIONALE ESERCIZIO \"& RIGHT(CELL(\"nomefile\",$A$1),4) & \" secondo me\"","v":"CALCOLO ADDIZIONALE REGIONALE ESERCIZIO  op. secondo me"},null,{"$f":"\"CALCOLO ADDIZIONALE COMUNALE ESERCIZIO \"& RIGHT(CELL(\"nomefile\",$A$1),4) & \" secondo me\"","v":"CALCOLO ADDIZIONALE COMUNALE ESERCIZIO  op. secondo me"},null,{"$f":"\"CALCOLO REDDITO NETTO ANNUO ESERCIZIO \"& RIGHT(CELL(\"nomefile\",$A$1),4) & \" secondo me\"","v":"CALCOLO REDDITO NETTO ANNUO ESERCIZIO  op. secondo me"}]
[{"$f":"\"reddito imponibile netto esercizio \" & LEFT(RIGHT(CELL(\"nomefile\",$A$1),13),4)","v":"reddito imponibile netto esercizio 2012"},{"$f":"\"ire lorda \" & LEFT(RIGHT(CELL(\"nomefile\",$A$1),13),4)","v":"ire lorda 2012"},{"$f":"\"aliquota massima \" & LEFT(RIGHT(CELL(\"nomefile\",$A$1),13),4)-2","v":"aliquota massima 2010"},{"$f":"\"aliquota massima \" & RIGHT(CELL(\"nomefile\",$A$1),4)","v":"aliquota massima  op."},{"$f":"\"importo addizionale \" & RIGHT(CELL(\"nomefile\",$A$1),4)","v":"importo addizionale  op."},{"$f":"\"aliquota massima \" & RIGHT(CELL(\"nomefile\",$A$1),4)","v":"aliquota massima  op."},{"$f":"\"importo addizionale \" & RIGHT(CELL(\"nomefile\",$A$1),4)","v":"importo addizionale  op."}]
[{"$f":"C2","v":32791.148812500003},{"$f":"irelordaannuapensionatisecondome($A$7,ROW($B$21),COLUMN($B$21))","v":8780.6365487500007},{"$f":"aliquotamassimasecondome($A$7,ROW($B$21),COLUMN($B$21))","v":1},2.0299999999999999E-2,{"$f":"C2*D7","v":665.66032089375005},8.0000000000000002E-3,{"$f":"C2*F7","v":262.32919050000004},{"$f":"A7-B7-E7-G7","v":23082.522752356253}]
[{"$f":"\"CALCOLO ALIQUOTA MEDIA BIENNIO \"& LEFT(RIGHT(CELL(\"nomefile\",$A$1),13),4)-2 &\" - \"& LEFT(RIGHT(CELL(\"nomefile\",$A$1),13),4)-1","v":"CALCOLO ALIQUOTA MEDIA BIENNIO 2010 - 2011"}]
[{"$f":"\"reddito imponibile netto esercizio \" & LEFT(RIGHT(CELL(\"nomefile\",$A$1),13),4)-2","v":"reddito imponibile netto esercizio 2010"},{"$f":"\"reddito imponibile netto esercizio \" & LEFT(RIGHT(CELL(\"nomefile\",$A$1),13),4)-1","v":"reddito imponibile netto esercizio 2011"},{"$f":"\"reddito medio biennio \"& LEFT(RIGHT(CELL(\"nomefile\",$A$1),13),4)-2 &\" - \"& LEFT(RIGHT(CELL(\"nomefile\",$A$1),13),4)-1","v":"reddito medio biennio 2010 - 2011"},{"$f":"\"ire corrispondente al reddito medio\"","v":"ire corrispondente al reddito medio"},{"$f":"\"aliquota media \" & LEFT(RIGHT(CELL(\"nomefile\",$A$1),13),4)","v":"aliquota media 2012"}]
[{"$f":"A2","v":45094},{"$f":"B2","v":53644},{"$f":"SUM(A10:B10)/2","v":49369},{"$f":"irexaliqmediasecondome($C$10,ROW($B$21),COLUMN($B$21))","v":4088656.115944}]
[null,null,null,null,"IRE su Pensione"]
["ire lorda annua",null,null,null,{"$f":"irelordaannuapensionatisecondome($C$2,ROW($B$21),COLUMN($B$21))","v":8780.6365487500007}]
["Detrazione coniuge",null,null,null,{"$f":"IF(AND($C$2<>\"\",UPPER($D$4)=\"SI\"),INDEX($L$27:$L$36,MATCH($C$2,$K$27:$K$36,1)+1,1),0)","v":0}]
["Detrazione figli",null,null,null,{"$f":"SUM($H$40:$I$43,$H$48:$I$51)","v":0}]
["Altre persone",null,null,null,{"$f":"$L$56","v":0}]
["Detrazione per reddito da pensione",null,null,null,{"$f":"IF(AND($C$2<>\"\",UPPER($L$4)=\"SI\"),INDEX($L$59:$L$62,MATCH($C$2,$D$59:$D$62,1)+1),0)","v":696.77599999999995}]
["ire netta annua",null,null,null,{"$f":"IF(E$12-E$13-E$14-E$15-E$16<=0,0,E$12-E$13-E$14-E$15-E$16)","v":8083.8605487500008}]
[]
["Aliquote e scaglioni IRE:"]
["aliquote:",0.23,0.27,0.38,0.41,0.43]
["scaglioni (fino a):",15000,28000,55000,75000,"(oltre 75.000)"]
[]
["DETRAZIONI PER CARICO DI FAMIGLIA\n(Coniuge, figli o altri familiari a carico se con reddito annuo <= 2.840,51)"]
["Coniuge"]
["scaglioni di reddito",null,null,null,"detrazione teorica","detrazione effettiva",null,null,"note",null,"redd.scag.+1","detraz."]
[null,null,null,null,null,null,null,null,null,null,0,0]
["da",0,"fino a",15000,800,"800 - ",110,"                         r.c.\nx -----------\n                       15.000,00","se rapporto = 1 allora detrazione = 690\nse rapporto = 0 allora detrazione = 0",null,{"$f":"D27+1","v":15001},{"$f":"IF(AND($A$7>$B$27,$A$7<=$D$27),IF($A$7/$D$27=0,0,IF($A$7/$D$27=1,690,$E$27-$G$27*$A$7/$D$27)),0)","v":0}]
["oltre",15000,"fino a",29000,null,690,null,null,null,null,29001,{"$f":"IF(AND($A$7>$B$28,$A$7<=$D$28),$F$28,0)","v":0}]
["oltre",29000,"fino a",29200,null,700,null,null,"690 + ",10,29201,{"$f":"IF(AND($A$7>$B$29,$A$7<=$D$29),$F$29,0)","v":0}]
["oltre",29200,"fino a",34700,null,710,null,null,"690 + ",20,34701,{"$f":"IF(AND($A$7>$B$30,$A$7<=$D$30),$F$30,0)","v":710}]
["oltre",34700,"fino a",35000,null,720,null,null,"690 + ",30,35001,{"$f":"IF(AND($A$7>$B$31,$A$7<=$D$31),$F$31,0)","v":0}]
["oltre",35000,"fino a",35100,null,710,null,null,"690 + ",20,35101,{"$f":"IF(AND($A$7>$B$32,$A$7<=$D$32),$F$32,0)","v":0}]
["oltre",35100,"fino a",35200,null,700,null,null,"690 + ",10,35201,{"$f":"IF(AND($A$7>$B$33,$A$7<=$D$33),$F$33,0)","v":0}]
["oltre",35200,"fino a",40000,null,690,null,null,null,null,40001,{"$f":"IF(AND($A$7>$B$34,$A$7<=$D$34),$F$34,0)","v":0}]
["oltre",40000,"fino a",80000,null,690,"  80.000,00 - r.c.\nx -------------------\n   40.000,00",null,"se rapporto = 0 allora detrazione = 0",null,80001,{"$f":"IF(AND($A$7>$B$35,$A$7<=$D$35),IF(($D$35-$A$7)/$B$35=0,0,$F$35*($D$35-$A$7)/$B$35),0)","v":0}]
["oltre",80000,null,99999,null,null,null,null,"non spetta alcuna detrazione",null,100000,0]
[]
["Figli (fino a 3)"]
[null,null,"n° figli","detraz. teoriche","detrazione spettante per ciascun figlio successivo al primo",null,null,"detraz.1° figlio","detraz. figli dal 2°","quoziente","note"]
["maggiore di 3 anni non portatori handicap",null,{"$f":"IF(SUM($C$4:$F$4)<=3,$E$4,0)","v":0},{"$f":"$M$1","v":800},{"$f":"D40","v":800},"   95.000 + 15.000 x (n.fig.tot. -1) - r.c.\nx  ---------------------------------------------\n        95.000+15 000 x (n.fig.tot. -1)",null,{"$f":"IF($C40>0,IF(UPPER($C$4)=\"SI\",MAX($D40*$J40,INDEX($L$26:$L$36,MATCH($A$7,$K$26:$K$36,1)+1,1)),$D40*$J40*$I$4*$J$4/12),0)","v":0},{"$f":"IF($H40<>0,$D40*$J40*($C40-1)*$I$4*$J$4/12,$D40*$J40*$C40*$I$4*$J$4/12)","v":0},{"$f":"ROUND(IF(OR((95000+15000*($E$4-1)-$A$7)/(95000+15000*($E$4-1))<0,(95000+15000*($E$4-1)-$A$7)/(95000+15000*($E$4-1))=1),0,(95000+15000*($E$4-1)-$A$7)/(95000+15000*($E$4-1))),4)","v":0.59009999999999996},"se il rapporto indicato è <= 0 oppure è = 1, allora detraz.spettante =0"]
["minore di 3 anni non portatori handicap",null,{"$f":"IF(SUM($C$4:$F$4)<=3,$F$4,0)","v":0},{"$f":"$N$1","v":900},{"$f":"D41","v":900},"   95.000 + 15.000 x (n.fig.tot. -1) - r.c.\nx  ---------------------------------------------\n        95.000+15 000 x (n.fig.tot. -1)",null,{"$f":"IF($C41>0,IF(UPPER($C$4)=\"SI\",MAX($D41*$J41,INDEX($L$26:$L$36,MATCH($A$7,$K$26:$K$36,1)+1,1)),$D41*$J41*$I$4*$J$4/12),0)","v":0},{"$f":"IF($C41>1,$D41*$J41*$C41*$I$4*$J$4/12,0)","v":0},{"$f":"J40","v":0.59009999999999996}]
["maggiore di 3 anni e portatore di handicap",null,{"$f":"IF(SUM($C$4:$F$4)<=3,$G$4,0)","v":0},{"$f":"$M$1+$O$1","v":1020},{"$f":"D42","v":1020},"   95.000 + 15.000 x (n.fig.tot. -1) - r.c.\nx  ---------------------------------------------\n        95.000+15000 x (n.fig.tot. -1)",null,{"$f":"IF($C42>0,IF(UPPER($C$4)=\"SI\",MAX($D42*$J42,INDEX($L$26:$L$36,MATCH($A$7,$K$26:$K$36,1)+1,1)),$D42*$J42*$I$4*$J$4/12),0)","v":0},{"$f":"IF($C42>1,$D42*$J42*$C42*$I$4*$J$4/12,0)","v":0},{"$f":"J40","v":0.59009999999999996}]
["minore di 3 anni e portatore di handicap",null,{"$f":"IF(SUM($C$4:$F$4)<=3,$H$4,0)","v":0},{"$f":"$D$41+$O$1","v":1120},{"$f":"D43","v":1120},"   95.000 + 15.000 x (n.fig.tot. -1) - r.c.\nx  ---------------------------------------------\n        95.000+15000 x (n.fig.tot. -1)",null,{"$f":"IF($C43>0,IF(UPPER($C$4)=\"SI\",MAX($D43*$J43,INDEX($L$26:$L$36,MATCH($A$7,$K$26:$K$36,1)+1,1)),$D43*$J43*$I$4*$J$4/12),0)","v":0},{"$f":"IF($C43>1,$D43*$J43*$C43*$I$4*$J$4/12,0)","v":0},{"$f":"J40","v":0.59009999999999996}]
["Totale figli",null,{"$f":"IF(SUM($C$4:$F$4)<=3,SUM($C$4:$F$4),0)","v":0}]
[]
["Figli (oltre i 3)\n(le detrazioni teoriche aumentano di 200 € per ciascun figlio a partire dal 1°)"]
[null,null,"n° figli","detrazioni teoriche","detrazione spettante per ciascun figlio successivo al primo",null,null,"detraz.1° figlio","detraz. figli dal 2°","quoziente","note"]
["maggiore di 3 anni non portatori handicap",null,{"$f":"IF(SUM($C$4:$F$4)>3,$E$4,0)","v":0},{"$f":"$M$1+200","v":1000},{"$f":"D48","v":1000},"   95.000 + 15.000 x (n.fig.tot. -1) - r.c.\nx  ---------------------------------------------\n        95.000+15000 x (n.fig.tot. -1)",null,{"$f":"IF($C48>0,IF(UPPER($C$4)=\"SI\",MAX($D48*$J48,INDEX($L$26:$L$36,MATCH($A$7,$K$26:$K$36,1)+1,1)),$D48*$J48*$I$4*$J$4/12),0)","v":0},{"$f":"IF($H48<>0,$D48*$J48*($C48-1)*$I$4*$J$4/12,$D48*$J48*$C48*$I$4*$J$4/12)","v":0},{"$f":"ROUND(IF(OR((95000+15000*($E$4-1)-$A$7)/(95000+15000*($E$4-1))<0,(95000+15000*($E$4-1)-$A$7)/(95000+15000*($E$4-1))=1),0,(95000+15000*($E$4-1)-$A$7)/(95000+15000*($E$4-1))),4)","v":0.59009999999999996},"se il rapporto indicato è <= 0 oppure è = 1, allora detraz.spettante =0"]
["minore di 3 anni non portatori handicap",null,{"$f":"IF(SUM($C$4:$F$4)>3,$F$4,0)","v":0},{"$f":"$N$1+200","v":1100},{"$f":"D49","v":1100},"   95.000 + 15.000 x (n.fig.tot. -1) - r.c.\nx  ---------------------------------------------\n        95.000+15000 x (n.fig.tot. -1)",null,{"$f":"IF($C49>0,IF(UPPER($C$4)=\"SI\",MAX($D49*$J49,INDEX($L$26:$L$36,MATCH($A$7,$K$26:$K$36,1)+1,1)),$D49*$J49*$I$4*$J$4/12),0)","v":0},{"$f":"IF($C49>1,$D49*$J49*$C49*$I$4*$J$4/12,0)","v":0},{"$f":"J48","v":0.59009999999999996}]
["maggiore di 3 anni e portatore di handicap",null,{"$f":"IF(SUM($C$4:$F$4)>3,$G$4,0)","v":0},{"$f":"$M$1+$O$1+200","v":1220},{"$f":"D50","v":1220},"   95.000 + 15.000 x (n.fig.tot. -1) - r.c.\nx  ---------------------------------------------\n        95.000+15000 x (n.fig.tot. -1)",null,{"$f":"IF($C50>0,IF(UPPER($C$4)=\"SI\",MAX($D50*$J50,INDEX($L$26:$L$36,MATCH($A$7,$K$26:$K$36,1)+1,1)),$D50*$J50*$I$4*$J$4/12),0)","v":0},{"$f":"IF($C50>1,$D50*$J50*$C50*$I$4*$J$4/12,0)","v":0},{"$f":"J48","v":0.59009999999999996}]
["minore di 3 anni e portatore di handicap",null,{"$f":"IF(SUM($C$4:$F$4)>3,$H$4,0)","v":0},{"$f":"$D$41+$O$1+200","v":1320},{"$f":"D51","v":1320},"   95.000 + 15.000 x (n.fig.tot. -1) - r.c.\nx  ---------------------------------------------\n        95.000+15.000 x (n.fig.tot. -1)",null,{"$f":"IF($C51>0,IF(UPPER($C$4)=\"SI\",MAX($D51*$J51,INDEX($L$26:$L$36,MATCH($A$7,$K$26:$K$36,1)+1,1)),$D51*$J51*$I$4*$J$4/12),0)","v":0},{"$f":"IF($C51>1,$D51*$J51*$C51*$I$4*$J$4/12,0)","v":0},{"$f":"J48","v":0.59009999999999996}]
["Totale figli",null,{"$f":"IF(SUM($C$4:$F$4)>3,SUM($C$4:$F$4),0)","v":0}]
[]
["Altre persone"]
["detraz. teorica","detrazione spettante per ciascun familiare",null,null,"note",null,null,null,null,null,"quoziente","detrazione"]
[750,{"$f":"A56","v":750},"   80.000 - r.c.\nx --------------\n      80.000",null,"se il rapporto indicato è <= 0 oppure è = 1, allora detraz.spettante =0",null,null,null,null,null,{"$f":"(80000-$A$7)/80000","v":0.59011063984375001},{"$f":"IF(AND(K56>0,K56<1),$B$56*INT(K56*10000)/10000,0)*$K$4","v":0}]
[]
["Detrazione per reddito da pensione (contribuenti che non hanno compiuto 75 anni)"]
["scaglioni di reddito",null,null,0,"detraz. teorica","detrazione effettiva",null,null,"redd.scag.+1","quoziente","se il periodo di lavoro nell'anno è inferiore a 365 giorni, allora la detrazione è pari a 690,00","detrazione"]
["da",0,"fino a",7500,null,1725,null,null,{"$f":"D60+1","v":7501},null,null,{"$f":"IF(AND($A$7>$B$60,$A$7<=$D$60),MAX($F60,690),0)","v":0}]
["oltre",7500,"fino a",15000,1255,{"$f":"E61","v":1255},"             15.000 - r.c.\n+ 470 x ----------------\n               7.500",null,{"$f":"D61+1","v":15001},{"$f":"(15000-$A$7)/7500","v":-2.3721531750000002},null,{"$f":"IF(AND($A$7>$B$61,$A$7<=$D$61),IF(AND(J61>0,J61<1),$E$61+470*INT(J61*10000)/10000,1),0)","v":0}]
["oltre",15000,"fino a",55000,1255,{"$f":"E62","v":1255},"  55.000 - r.c.\nx --------------\n    40.000",null,{"$f":"D62+1","v":55001},{"$f":"(55000-$A$7)/40000","v":0.5552212796874999},null,{"$f":"IF(AND($A$7>$B$62,$A$7<=$D$62),IF(AND(J62>0,J62<1),$E$62*INT(J62*10000)/10000,1),0)","v":696.77599999999995}]

{"sheet":"tabprev","index":4,"n_rows":43,"n_cols":21,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,2,0,15],[0,16,0,17]]}
["Aliq.pens.\nDPR 29.12.73 n° 1092 art. 44",null,"Coefficienti rivalutazione retribuzioni per Quota B (ricavati dai dati rilevati dal sito www.inpdap.it)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX($Q$2:$Q$22)","v":2012},null,"base 1995=100","incrementi %"]
["anni di contrib.","aliquota",null,{"$f":"E2-1","v":2004},2005,2006,2007,2008,2009,2010,2011,{"$f":"$Q$1","v":2012},{"$f":"L2+1","v":2013},{"$f":"M2+1","v":2014},{"$f":"N2+1","v":2015},{"$f":"O2+1","v":2016},1992,100]
[0,0,{"$f":"$Q3","v":1993},{"$f":"IF(E3=1,1,E3/INDEX(E$3:E$22,MATCH(1,E$3:E$22,0)-1))","v":1.3227715930902106},1.3490518234165063,1.3720470249520149,1.3994222648752395,1.4235124760076778,1.4695028790786946,1.4793579654510556,{"$f":"IF(L3=1,1,L3/INDEX(L$3:L$22,MATCH(1,L$3:L$22,0)-1))","v":1.5034481765834933},{"$f":"IF($R3=\"\",1,INDEX($R$2:$R$22,MATCH(MAX($Q$2:$Q$22),$Q$2:$Q$22,0))/$R3)","v":1.5439635316698657},{"$f":"IF(L3=1,1,L3*INDEX(L$3:L$22,MATCH(1,L$3:L$22,0)-1))","v":1.5855707062305249},{"$f":"IF(M3=1,1,M3*INDEX(M$3:M$22,MATCH(1,M$3:M$22,0)-1))","v":1.6721789973295762},{"$f":"IF(N3=1,1,N3*INDEX(N$3:N$22,MATCH(1,N$3:N$22,0)-1))","v":1.859846346991703},{"$f":"IF(O3=1,1,O3*INDEX(O$3:O$22,MATCH(1,O$3:O$22,0)-1))","v":2.3007300739017436},1993,104.2]
[1,2.3300000000000001E-2,{"$f":"C3+1","v":1994},{"$f":"IF(E4=1,1,E4/INDEX(E$3:E$22,MATCH(1,E$3:E$22,0)-1))","v":1.2726943674976912},1.2979796860572481,1.3201043397968604,1.3464432132963986,1.369621421975993,1.4138707294552169,1.4233527239150507,{"$f":"IF(L4=1,1,L4/INDEX(L$3:L$22,MATCH(1,L$3:L$22,0)-1))","v":1.4465309325946445},{"$f":"IF($R4=\"\",1,INDEX($R$2:$R$22,MATCH(MAX($Q$2:$Q$22),$Q$2:$Q$22,0))/$R4)","v":1.4855124653739613},{"$f":"IF(L4=1,1,L4*INDEX(L$3:L$22,MATCH(1,L$3:L$22,0)-1))","v":1.5255444837416501},1.6088739752700079,1.7894366514915554,2.2136294893865345,1994,108.3]
[2,4.6699999999999998E-2,{"$f":"C4+1","v":1995},{"$f":"IF(E5=1,1,E5/INDEX(E$3:E$22,MATCH(1,E$3:E$22,0)-1))","v":1.2079999999999995},1.2319999999999995,1.2529999999999997,1.2779999999999996,1.3000000000000003,1.3419999999999999,1.351,1.373,1.4100000000000001,1.4479970866715224,1.5270907232405071,1.6984749286287071,2.1011049404080779,1995,114.1,100]
[3,7.0000000000000007E-2,1996,{"$f":"IF(E6=1,1,E6/INDEX(E$3:E$22,MATCH(1,E$3:E$22,0)-1))","v":1.1626564003849851},1.1857555341674684,1.2059672762271412,1.2300288739172278,1.2512030798845046,1.2916265640038498,1.300288739172281,1.3214629451395574,1.3570741097208856,1.3936449342363064,1.4697697047550597,1.6347208167745013,2.0222376712301036,1996,118.54989999999999,{"$f":"R6/R$5*100","v":103.89999999999999},{"$f":"ROUND((S6-S5)/S5%,1)","v":3.9},{"$f":"R5*S6/S5","v":118.54989999999998}]
[4,9.3299999999999994E-2,1997,{"$f":"IF(E7=1,1,E7/INDEX(E$3:E$22,MATCH(1,E$3:E$22,0)-1))","v":1.1428571428571426},1.1655629139072845,1.1854304635761588,1.2090823084200566,1.2298959318826872,1.2696310312204351,1.2781456953642383,1.2989593188268684,1.3339640491958373,1.3699120971348366,1.4447405139456073,1.6068826193270642,1.9878003220511615,1997,120.6037,{"$f":"R7/R$5*100","v":105.70000000000002},{"$f":"ROUND((S7-S6)/S6%,1)","v":1.7},120.60370000000003]
[5,0.1167,1998,{"$f":"IF(E8=1,1,E8/INDEX(E$3:E$22,MATCH(1,E$3:E$22,0)-1))","v":1.12267657992565},1.1449814126394047,1.1644981412639401,1.1877323420074346,1.2081784386617103,1.2472118959107805,1.2555762081784385,1.2760223048327137,1.3104089219330854,1.3457221995088497,1.4192292966919209,1.5785082979820695,1.9526997587435666,1998,122.77160000000001,107.60000000000001,1.8,122.77159999999999]
[6,0.14000000000000001,1999,{"$f":"IF(E9=1,1,E9/INDEX(E$3:E$22,MATCH(1,E$3:E$22,0)-1))","v":1.1052150045745652},1.1271729185727355,1.1463860933211345,1.1692589204025616,1.1893870082342182,1.2278133577310155,1.2360475754803293,1.2561756633119854,1.2900274473924978,1.324791479113927,1.3971552820132724,1.5539569337865569,1.9223283992754598,1999,124.71129999999999,109.3,1.6,124.71129999999999]
[7,0.1633,2000,{"$f":"IF(E10=1,1,E10/INDEX(E$3:E$22,MATCH(1,E$3:E$22,0)-1))","v":1.0776092774308652},1.0990187332738626,1.1177520071364853,1.1400535236396074,1.1596788581623556,1.1971454058876005,1.2051739518287246,1.2247992863514721,1.2578055307760929,1.2917012369951137,1.3622575586445203,1.5151426660380973,1.8743130601320945,2000,127.9061,112.1,2.6,127.9061]
[8,0.1867,2001,{"$f":"IF(E11=1,1,E11/INDEX(E$3:E$22,MATCH(1,E$3:E$22,0)-1))","v":1.0495221546481319},1.0703735881841876,1.0886185925282363,1.1103388357949608,1.1294526498696791,1.1659426585577759,1.1737619461337967,1.1928757602085143,1.2250217202432667,1.258033958880558,1.326751279965688,1.4756515452899277,1.8254604173832125,2001,131.32910000000001,115.10000000000002,2.7,131.32910000000004]
[9,0.21,2002,{"$f":"IF(E12=1,1,E12/INDEX(E$3:E$22,MATCH(1,E$3:E$22,0)-1))","v":1.024597116200169},1.0449533502968613,1.0627650551314669,1.0839694656488545,1.1026293469041561,1.1382527565733669,1.1458863443596266,1.1645462256149277,1.1959287531806615,1.2281569861505701,1.2952423437154426,1.440606385605349,1.7821076678609646,2002,134.5239,117.9,2.4,134.5239]
[10,0.23330000000000001,2003,{"$f":"IF(E13=1,1,E13/INDEX(E$3:E$22,MATCH(1,E$3:E$22,0)-1))","v":1},1.0198675496688743,1.0372516556291391,1.0579470198675496,1.0761589403973515,1.110927152317881,1.1183774834437088,1.13658940397351,1.1672185430463577,1.1986730849929821,1.2641479497024064,1.4060222919111811,1.7393252817947662,2003,137.83279999999999,120.8,2.5,137.83279999999999]
[11,0.25669999999999998,2004,{"$f":"IF(E14=1,1,E14/INDEX(E$3:E$22,MATCH(1,E$3:E$22,0)-1))","v":1},1,1.0170454545454546,1.0373376623376622,1.0551948051948055,1.0892857142857142,1.0965909090909089,1.1144480519480517,1.1444805194805194,1.1753223106100017,1.2395216909419697,1.3786322472635606,1.7054423217598031,2004,140.5712,123.20000000000002,2,140.5712]
[12,0.28000000000000003,2005,{"$f":"IF(E15=1,1,E15/INDEX(E$3:E$22,MATCH(1,E$3:E$22,0)-1))","v":1},1,1,1.0199521149241819,1.0375099760574624,1.0710295291300878,1.0782122905027933,1.0957701516360734,1.1252992817238627,1.1556241713260353,1.2187475843898699,1.3555266788736686,1.6768594895515385,2005,142.96729999999999,125.30000000000001,1.7,142.96729999999999]
[13,0.30330000000000001,2006,{"$f":"IF(E16=1,1,E16/INDEX(E$3:E$22,MATCH(1,E$3:E$22,0)-1))","v":1},1,1,1,1.0172143974960881,1.0500782472613459,1.0571205007824727,1.0743348982785603,1.103286384976526,1.1330180646882022,1.1949066692022747,1.3290101162978929,1.6440570738717355,2006,145.81979999999999,127.8,2,145.81979999999999]
[14,0.32669999999999999,2007,{"$f":"IF(E17=1,1,E17/INDEX(E$3:E$22,MATCH(1,E$3:E$22,0)-1))","v":1},1,1,1,1,1.0323076923076919,1.039230769230769,1.056153846153846,1.0846153846153845,1.1138439128242479,1.1746851717234668,1.306519175868236,1.6162345695446751,2007,148.33000000000001,130.00000000000003,1.7,148.33000000000004]
[15,0.35,2008,{"$f":"IF(E18=1,1,E18/INDEX(E$3:E$22,MATCH(1,E$3:E$22,0)-1))","v":1},1,1,1,1,1,1.0067064083457526,1.0230998509687035,1.0506706408345754,1.0789844162977067,1.1379215523401691,1.2656296040452362,1.5656519675171967,2008,153.12219999999999,134.20000000000002,3.2,153.12220000000002]
[16,0.36799999999999999,2009,{"$f":"IF(E19=1,1,E19/INDEX(E$3:E$22,MATCH(1,E$3:E$22,0)-1))","v":1},1,1,1,1,1,1,1.0162842339008142,1.0436713545521836,1.0717965112298462,1.1303410238641798,1.2571983187481175,1.5552220136255201,2009,154.1491,135.10000000000002,0.7,{"$f":"R18*S19/S18","v":154.1491}]
[17,0.38600000000000001,2010,{"$f":"IF(E20=1,1,E20/INDEX(E$3:E$22,MATCH(1,E$3:E$22,0)-1))","v":1},1,1,1,1,1,1,1,1.0269482884195194,1.0546227870877802,1.1122292230447974,1.2370538445948338,1.5303022144268592,2010,156.6593,137.30000000000001,1.6,{"$f":"R19*S20/S19","v":156.6593}]
[18,0.40400000000000003,2011,{"$f":"IF(E21=1,1,E21/INDEX(E$3:E$22,MATCH(1,E$3:E$22,0)-1))","v":1},1,1,1,1,1,1,1,1,1,1,1,1,2011,160.881,{"$f":"S20*(1+T21%)","v":141.00710000000001},2.7,{"$f":"R20*S21/S20","v":160.8891011}]
[19,0.42199999999999999,2012,{"$f":"IF(E22=1,1,E22/INDEX(E$3:E$22,MATCH(1,E$3:E$22,0)-1))","v":1},1,1,1,1,1,1,1,1,1,1,1,1,2012,160.881]
[20,0.44]
[21,0.45800000000000002]
[22,0.47599999999999998]
[23,0.49399999999999999]
[24,0.51200000000000001]
[25,0.53]
[26,0.54800000000000004]
[27,0.56599999999999995]
[28,0.58399999999999996]
[29,0.60199999999999998]
[30,0.62]
[31,0.63800000000000001]
[32,0.65600000000000003]
[33,0.67400000000000004]
[34,0.69199999999999995]
[35,0.71]
[36,0.72799999999999998]
[37,0.746]
[38,0.76400000000000001]
[39,0.78200000000000003]
[40,0.8]