{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["RENDITE VITALIZIE","CALCOLI","CALCOLO PENSIONE"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"RENDITE VITALIZIE","index":0,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[3,12,3,13],[3,15,3,16],[22,4,22,17]]}
[]
[]
[null,null,null,null,null,null,null,null,null,"CALCOLO RENDITA VITALIZIA"]
[]
[]
[null,null,"ETA' AL MOMENTO DELLA RISCOSSIONE MINIMO 50",null,null,null,null,68]
[]
[null,null,"VALORE MONTANTE DA DESTINARE ALLA RENDITA",null,null,null,null,170267]
[]
[null,null,"SESSO",null,null,null,null,"F"]
[]
[]
["NOTA: Inserendo i dati nelle caselle verdi (età al momento delle riscossione, montante destinato alla"]
[" rendita e sesso) nel grafico compariranno i valori annuali lordi percepibili dall'assicurato."]

{"sheet":"CALCOLI","index":1,"n_rows":113,"n_cols":44,"rows_kept":113,"cut":false,"hidden":true,"merged":[[37,2,37,5],[5,10,5,11],[6,10,6,11],[3,10,3,11],[4,10,4,11],[7,2,7,3],[8,2,8,3],[11,9,11,11],[34,2,34,3],[1,24,1,29],[11,4,11,8],[11,21,11,23],[0,14,0,16],[0,17,0,19],[11,13,11,15],[11,17,11,19]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RENDITA REVERSIBILE SU ASSICURATO DI PARI ETA' E SESSO DIVERSO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Età","Maschi","Femmine"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,2.274E-2,2.274E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+Z5","v":51},2.3269999999999999E-2,2.3269999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+Z6","v":52},2.383E-2,2.383E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,2.4410000000000001E-2,2.4410000000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,2.5010000000000001E-2,2.5010000000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,2.5649999999999999E-2,2.5649999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,2.632E-2,2.632E-2]
[null,null,null,null,"RENDITA VITALIZIA IMMEDIATA A PREMIO UNICO",null,null,null,null,"RENDITA VITALIZIA CERTA 5 ANNI",null,null,null,"RENDITA VITALIZIA CERTA 10 ANNI",null,null,null,"RENDITA CONTROASSICURATA",null,null,null,"RENDITA CON RADDOPPIO TLC",null,null,null,57,2.7029999999999998E-2,2.7029999999999998E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,2.7779999999999999E-2,2.7779999999999999E-2]
[null,null,null,null,null,"Età","Maschi","Femmine",null,"Età","Maschi","Femmine",null,"Età","Maschi","Femmine",null,"Età","Maschi","Femmine",null,"Età","Maschi","Femmine",null,59,2.8559999999999999E-2,2.8559999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,2.9389999999999999E-2,2.9389999999999999E-2]
[null,null,null,null,null,50,2.7609999999999999E-2,2.487E-2,null,50,2.759E-2,2.486E-2,null,50,2.7539999999999999E-2,2.4830000000000001E-2,null,50,2.6800000000000001E-2,2.5239999999999999E-2,null,50,2.6280000000000001E-2,2.317E-2,null,61,3.0269999999999998E-2,3.0269999999999998E-2]
[null,null,null,null,null,{"$f":"1+F16","v":51},2.836E-2,2.5489999999999999E-2,null,{"$f":"1+J16","v":51},2.385E-2,2.547E-2,null,{"$f":"1+N16","v":51},2.8289999999999999E-2,2.5440000000000001E-2,null,{"$f":"1+R16","v":51},2.7310000000000001E-2,2.571E-2,null,{"$f":"1+V16","v":51},2.6970000000000001E-2,2.3709999999999998E-2,null,62,3.1199999999999999E-2,3.1199999999999999E-2]
[null,null,null,null,null,{"$f":"1+F17","v":52},2.9159999999999998E-2,2.613E-2,null,{"$f":"1+J17","v":52},2.9139999999999999E-2,2.6120000000000001E-2,null,{"$f":"1+N17","v":52},2.9069999999999999E-2,2.6079999999999999E-2,null,{"$f":"1+R17","v":52},2.7830000000000001E-2,2.6179999999999998E-2,null,{"$f":"1+V17","v":52},2.7689999999999999E-2,2.426E-2,null,63,3.218E-2,3.218E-2]
[null,null,null,null,null,53,0.03,2.681E-2,null,53,2.998E-2,2.6790000000000001E-2,null,53,2.9899999999999999E-2,2.6749999999999999E-2,null,53,2.8369999999999999E-2,2.6669999999999999E-2,null,53,2.845E-2,2.4850000000000001E-2,null,64,3.3230000000000003E-2,3.3230000000000003E-2]
[null,null,null,null,null,54,3.0890000000000001E-2,2.7519999999999999E-2,null,54,3.0859999999999999E-2,2.75E-2,null,54,3.0769999999999999E-2,2.7459999999999998E-2,null,54,2.8930000000000001E-2,2.7189999999999999E-2,null,54,2.9239999999999999E-2,2.546E-2,null,65,3.4340000000000002E-2,3.4340000000000002E-2]
[null,null,null,null,null,55,3.1829999999999997E-2,2.827E-2,null,55,3.1800000000000002E-2,2.8250000000000001E-2,null,55,3.168E-2,2.8199999999999999E-2,null,55,2.9530000000000001E-2,2.7720000000000002E-2,null,55,3.0079999999999999E-2,2.6100000000000002E-2,null,66,3.5520000000000003E-2,3.5520000000000003E-2]
[null,null,null,null,null,56,3.2820000000000002E-2,2.9059999999999999E-2,null,56,3.2779999999999997E-2,2.904E-2,null,56,3.2640000000000002E-2,2.8979999999999999E-2,null,56,3.0130000000000001E-2,2.827E-2,null,56,3.0970000000000001E-2,2.6769999999999999E-2,null,67,3.6769999999999997E-2,3.6769999999999997E-2]
[null,null,null,null,null,57,3.3869999999999997E-2,2.989E-2,null,57,3.3820000000000003E-2,2.9870000000000001E-2,null,57,3.3660000000000002E-2,2.98E-2,null,57,3.0769999999999999E-2,2.8850000000000001E-2,null,57,3.1899999999999998E-2,2.7480000000000001E-2,null,68,3.8120000000000001E-2,3.8120000000000001E-2]
[null,null,null,null,null,58,3.4979999999999997E-2,3.0769999999999999E-2,null,58,3.4930000000000003E-2,3.075E-2,null,58,3.4729999999999997E-2,3.066E-2,null,58,3.143E-2,2.945E-2,null,58,3.2890000000000003E-2,2.8230000000000002E-2,null,69,3.9550000000000002E-2,3.9550000000000002E-2]
[null,null,null,null,null,59,3.6170000000000001E-2,3.1710000000000002E-2,null,59,3.61E-2,3.168E-2,null,59,3.5869999999999999E-2,3.1579999999999997E-2,null,59,3.2120000000000003E-2,3.007E-2,null,59,3.3939999999999998E-2,2.9010000000000001E-2,null,70,4.1090000000000002E-2,4.1090000000000002E-2]
[null,null,null,null,null,60,3.7429999999999998E-2,3.27E-2,null,60,3.7350000000000001E-2,3.2669999999999998E-2,null,60,3.7069999999999999E-2,3.2550000000000003E-2,null,60,3.2829999999999998E-2,3.0720000000000001E-2,null,60,3.5049999999999998E-2,2.9839999999999998E-2]
[null,null,null,null,null,61,3.8769999999999999E-2,3.3750000000000002E-2,null,61,3.8679999999999999E-2,3.3709999999999997E-2,null,61,3.8330000000000003E-2,3.3570000000000003E-2,null,61,3.3590000000000002E-2,3.141E-2,null,61,3.6229999999999998E-2,3.0720000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100000,{"$f":"+AP27*4%","v":4000},{"$f":"+AP27*4%","v":4000}]
[null,null,null,null,null,62,4.0189999999999997E-2,3.4869999999999998E-2,null,62,4.0079999999999998E-2,3.4819999999999997E-2,null,62,3.9660000000000001E-2,3.465E-2,null,62,3.4369999999999998E-2,3.2120000000000003E-2,null,62,3.7479999999999999E-2,3.1649999999999998E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200000,{"$f":"+AP28*4%","v":8000},{"$f":"+AP28*5.5%","v":11000}]
[null,null,null,null,null,63,4.1709999999999997E-2,3.6049999999999999E-2,null,63,4.1570000000000003E-2,3.5999999999999997E-2,null,63,4.1070000000000002E-2,3.5799999999999998E-2,null,63,3.5189999999999999E-2,3.2849999999999997E-2,null,63,3.8800000000000001E-2,3.2629999999999999E-2]
[null,null,null,null,null,64,4.3319999999999997E-2,3.7319999999999999E-2,null,64,4.3159999999999997E-2,3.7249999999999998E-2,null,64,4.2549999999999998E-2,3.7010000000000001E-2,null,64,3.6049999999999999E-2,3.363E-2,null,64,4.02E-2,3.3660000000000002E-2]
[null,null,null,null,null,65,4.505E-2,3.866E-2,null,65,4.4850000000000001E-2,3.8580000000000003E-2,null,65,4.4119999999999999E-2,3.8300000000000001E-2,null,65,3.6949999999999997E-2,3.4439999999999998E-2,null,65,4.1680000000000002E-2,3.4759999999999999E-2]
[null,null,null,null,null,66,4.6899999999999997E-2,4.0090000000000001E-2,null,66,4.666E-2,0.04,null,66,4.5769999999999998E-2,3.9660000000000001E-2,null,66,3.7879999999999997E-2,3.5279999999999999E-2,null,66,4.3270000000000003E-2,3.5920000000000001E-2]
[null,null,null,null,null,67,4.8869999999999997E-2,4.163E-2,null,67,4.8579999999999998E-2,4.1520000000000001E-2,null,67,4.752E-2,4.1110000000000001E-2,null,67,3.8879999999999998E-2,3.6179999999999997E-2,null,67,4.4949999999999997E-2,3.7159999999999999E-2]
[null,null,null,null,null,68,5.0990000000000001E-2,4.3270000000000003E-2,null,68,5.0630000000000001E-2,4.3139999999999998E-2,null,68,4.9360000000000001E-2,4.2659999999999997E-2,null,68,3.9910000000000001E-2,3.7130000000000003E-2,null,68,4.6739999999999997E-2,3.848E-2]
[null,null,null,null,null,69,5.3260000000000002E-2,4.5039999999999997E-2,null,69,5.2819999999999999E-2,4.4880000000000003E-2,null,69,5.1290000000000002E-2,4.4299999999999999E-2,null,69,4.0989999999999999E-2,3.8089999999999999E-2,null,69,4.8649999999999999E-2,3.9879999999999999E-2]
[null,null,null,null,null,70,5.57E-2,4.6940000000000003E-2,null,70,5.5169999999999997E-2,4.6739999999999997E-2,null,70,5.3310000000000003E-2,4.6039999999999998E-2,null,70,4.215E-2,3.9120000000000002E-2,null,70,5.0700000000000002E-2,4.138E-2]
[]
[]
[]
[]
[1]
[{"$f":"1+A41","v":2}]
[{"$f":"1+A42","v":3}]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[{"$f":"1+A106","v":67}]
[68]
[69]
[70]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S41:S111)","v":0},null,{"$f":"SUM(U42:U111)","v":0},0,{"$f":"SUM(W42:W111)","v":0},null,{"$f":"SUM(Y42:Y111)","v":0},{"$f":"SUM(Z42:Z111)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+V112+U112","v":0},null,null,null,{"$f":"+V113+W112","v":0}]

{"sheet":"CALCOLO PENSIONE","index":2,"n_rows":99,"n_cols":16,"rows_kept":99,"cut":false,"hidden":true,"merged":[[32,8,32,9],[9,8,9,9],[28,8,28,9],[29,8,29,9],[30,8,30,9],[31,8,31,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[27,8,27,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[8,3,8,4],[8,6,8,7],[2,13,2,19],[21,14,21,16],[20,8,20,9],[21,8,21,9],[26,8,26,9],[2,5,2,11],[15,8,15,9],[4,5,4,6],[4,8,4,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[25,8,25,9],[22,8,22,9],[23,8,23,9],[24,8,24,9]]}
[]
[]
[null,null,null,"VECCHIO ISCR",{"$f":"+'RENDITE VITALIZIE'!H12","v":0}]
[null,null,null,"SESSO",{"$f":"+'RENDITE VITALIZIE'!H10","v":"F"},{"$f":"IF($E$4=\"M\",VLOOKUP($E$5,$D$10:$E$99,2),VLOOKUP($E$5,$G$10:$H$97,2))","v":1},null,null,null,null,null,null,null,null,null,{"$f":"IF(E3=\"SI\",122,100)","v":100}]
[null,null,null,"ETA'",{"$f":"+'RENDITE VITALIZIE'!H6","v":68},null,null,null,null,null,{"$f":"+E7*L5","v":7668.825679999999},{"$f":"IF($E$4=\"M\",VLOOKUP($E$6,CALCOLI!$F$16:$H$36,2),VLOOKUP($E$6,CALCOLI!$F$16:$H$36,3))","v":4.5039999999999997E-2},"IMMEDIATA",null,null,{"$f":"+K5*P4%","v":7668.825679999999}]
[null,null,null,"ETA' CORRETTA",{"$f":"+E5+F4","v":69}]
[null,null,null,"MONTANTE",{"$f":"+'RENDITE VITALIZIE'!H8","v":170267},null,null,null,null,null,{"$f":"+E7*L7","v":7641.5829600000006},{"$f":"IF($E$4=\"M\",VLOOKUP($E$6,CALCOLI!$J$16:$L$36,2),VLOOKUP($E$6,CALCOLI!$J$16:$L$36,3))","v":4.4880000000000003E-2},"CERTA 5 ANNI",null,null,{"$f":"+K7","v":7641.5829600000006}]
[]
[null,null,null,"MASCHI",null,null,"femmine",null,null,null,{"$f":"+E7*L9","v":7542.8280999999997},{"$f":"IF($E$4=\"M\",VLOOKUP($E$6,CALCOLI!$N$16:$P$36,2),VLOOKUP($E$6,CALCOLI!$N$16:$P$36,3))","v":4.4299999999999999E-2},"CERTA 10 ANNI",null,null,{"$f":"+K9","v":7542.8280999999997}]
[null,null,null,0,-2,null,0,-2]
[null,null,null,{"$f":"1+D10","v":1},-2,null,{"$f":"1+G10","v":1},-2,null,null,{"$f":"+E7*L11","v":6485.4700299999995},{"$f":"IF($E$4=\"M\",VLOOKUP($E$6,CALCOLI!$R$16:$T$36,2),VLOOKUP($E$6,CALCOLI!$R$16:$T$36,3))","v":3.8089999999999999E-2},"CONTRASS TT 0,50%",null,null,{"$f":"+K11","v":6485.4700299999995}]
[null,null,null,{"$f":"1+D11","v":2},-2,null,{"$f":"1+G11","v":2},-2]
[null,null,null,3,-2,null,3,-2,null,null,{"$f":"+E7*L13","v":6734.0598500000006},{"$f":"IF($E$4=\"M\",VLOOKUP($E$6,CALCOLI!$Z$5:$AB$25,2),VLOOKUP($E$6,CALCOLI!$Z$5:$AB$25,3))","v":3.9550000000000002E-2},"REVERSIBILE",null,null,{"$f":"+K13","v":6734.0598500000006}]
[null,null,null,4,-2,null,4,-2]
[null,null,null,5,-2,null,5,-2]
[null,null,null,6,-2,null,6,-2]
[null,null,null,7,-2,null,7,-2]
[null,null,null,8,-2,null,8,-2]
[null,null,null,9,-2,null,9,-2]
[null,null,null,10,-2,null,10,-2]
[null,null,null,11,-2,null,11,-2]
[null,null,null,12,-2,null,12,-2]
[null,null,null,13,-2,null,13,-2]
[null,null,null,14,-2,null,14,-2]
[null,null,null,15,-2,null,15,-2]
[null,null,null,16,-2,null,16,-2]
[null,null,null,17,-2,null,17,-2]
[null,null,null,18,-2,null,18,-2]
[null,null,null,19,-2,null,19,-2]
[null,null,null,20,-2,null,20,-2]
[null,null,null,21,-2,null,21,-2]
[null,null,null,22,-2,null,22,-2]
[null,null,null,23,-2,null,23,-2]
[null,null,null,24,-2,null,24,-2]
[null,null,null,25,-2,null,25,-2]
[null,null,null,26,-2,null,26,-2]
[null,null,null,27,-2,null,27,-2]
[null,null,null,28,-2,null,28,-2]
[null,null,null,29,-2,null,29,-2]
[null,null,null,30,-2,null,30,-2]
[null,null,null,31,-2,null,31,-2]
[null,null,null,32,-2,null,32,-2]
[null,null,null,33,-2,null,33,-2]
[null,null,null,34,-2,null,34,-2]
[null,null,null,35,-2,null,35,-2]
[null,null,null,36,-2,null,36,-2]
[null,null,null,37,-2,null,37,-2]
[null,null,null,38,-2,null,38,-2]
[null,null,null,39,-2,null,39,-2]
[null,null,null,40,-2,null,40,-2]
[null,null,null,41,-2,null,41,-2]
[null,null,null,42,-2,null,42,-2]
[null,null,null,43,-2,null,43,-2]
[null,null,null,44,-2,null,44,-2]
[null,null,null,45,-2,null,45,-2]
[null,null,null,46,-2,null,46,-2]
[null,null,null,47,-1,null,47,-1]
[null,null,null,48,-1,null,48,-1]
[null,null,null,49,-1,null,49,-1]
[null,null,null,50,-1,null,50,-1]
[null,null,null,51,-1,null,51,-1]
[null,null,null,52,-1,null,52,-1]
[null,null,null,53,-1,null,53,-1]
[null,null,null,54,-1,null,54,-1]
[null,null,null,55,-1,null,55,0]
[null,null,null,56,-1,null,56,0]
[null,null,null,57,0,null,57,0]
[null,null,null,58,0,null,58,0]
[null,null,null,59,0,null,59,0]
[null,null,null,60,0,null,60,0]
[null,null,null,61,0,null,61,0]
[null,null,null,62,0,null,62,0]
[null,null,null,63,0,null,63,0]
[null,null,null,64,0,null,64,0]
[null,null,null,65,0,null,65,0]
[null,null,null,{"$f":"1+D75","v":66},0,null,{"$f":"1+G75","v":66},0]
[null,null,null,67,0,null,67,0]
[null,null,null,68,0,null,68,1]
[null,null,null,69,0,null,69,1]
[null,null,null,70,1,null,70,1]
[null,null,null,71,1,null,71,1]
[null,null,null,72,1,null,72,1]
[null,null,null,73,1,null,73,1]
[null,null,null,74,1,null,74,1]
[null,null,null,75,1,null,75,1]
[null,null,null,76,1,null,76,1]
[null,null,null,77,1,null,77,2]
[null,null,null,78,1,null,78,2]
[null,null,null,79,2,null,79,2]
[null,null,null,80,2,null,80,2]
[null,null,null,81,2,null,81,2]
[null,null,null,82,2,null,82,2]
[null,null,null,83,2,null,83,2]
[null,null,null,84,2,null,84,2]
[null,null,null,85,2,null,85,2]
[null,null,null,86,2,null,86,2]
[null,null,null,87,2,null,87,2]
[null,null,null,88,2]
[null,null,null,89,2]