{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["sim_f2002","es. capitale differito","es. elem. caso morte"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"sim_f2002","index":0,"n_rows":125,"n_cols":5,"rows_kept":125,"cut":false,"hidden":false,"merged":[]}
["Tavola 1 - Tavole di mortalità della popolazione residente per sesso ed età al 2002"]
["                  Italia "]
[null,"Maschi 2002",null,"Femmine 2002"]
["ETÀ   x","lx","dx","lx","dx"]
[]
[0,100000,468,100000,397]
[1,99532,30,99603,27]
[2,99502,22,99576,20]
[3,99480,17,99556,15]
[4,99463,14,99541,13]
[5,99449,13,99528,11]
[6,99435,13,99517,11]
[7,99422,14,99506,10]
[8,99408,13,99496,9]
[9,99395,13,99488,8]
[10,99382,13,99479,10]
[11,99368,13,99470,10]
[12,99356,15,99459,11]
[13,99341,19,99448,13]
[14,99321,27,99436,14]
[15,99294,37,99422,16]
[16,99258,49,99406,20]
[17,99209,60,99385,23]
[18,99149,70,99363,24]
[19,99079,77,99338,25]
[20,99002,82,99313,26]
[21,98921,86,99287,25]
[22,98835,88,99262,27]
[23,98746,90,99235,26]
[24,98657,92,99209,27]
[25,98565,90,99182,27]
[26,98474,90,99155,27]
[27,98385,89,99128,29]
[28,98296,87,99099,30]
[29,98208,85,99068,31]
[30,98123,87,99037,33]
[31,98036,87,99004,35]
[32,97949,90,98969,37]
[33,97859,95,98932,41]
[34,97765,100,98892,44]
[35,97664,104,98848,48]
[36,97561,108,98800,53]
[37,97453,112,98747,57]
[38,97341,119,98691,62]
[39,97222,128,98629,68]
[40,97095,137,98561,74]
[41,96958,145,98487,80]
[42,96813,157,98407,87]
[43,96656,169,98319,95]
[44,96487,187,98224,105]
[45,96300,204,98119,117]
[46,96096,220,98002,130]
[47,95876,247,97871,141]
[48,95629,267,97730,154]
[49,95362,291,97577,170]
[50,95071,319,97407,183]
[51,94752,353,97225,201]
[52,94398,390,97024,223]
[53,94009,446,96800,250]
[54,93563,472,96551,272]
[55,93091,513,96279,298]
[56,92578,567,95981,324]
[57,92011,642,95657,350]
[58,91369,704,95307,374]
[59,90665,796,94933,410]
[60,89869,856,94523,437]
[61,89013,924,94086,458]
[62,88089,996,93629,497]
[63,87093,1062,93131,529]
[64,86031,1158,92602,583]
[65,84873,1271,92020,656]
[66,83602,1399,91364,733]
[67,82203,1533,90631,799]
[68,80670,1656,89832,872]
[69,79014,1810,88960,959]
[70,77204,1979,88001,1051]
[71,75225,2132,86950,1160]
[72,73093,2304,85790,1286]
[73,70789,2454,84503,1432]
[74,68335,2625,83072,1593]
[75,65709,2806,81479,1791]
[76,62904,2978,79688,2005]
[77,59925,3128,77683,2198]
[78,56797,3294,75485,2441]
[79,53504,3425,73045,2688]
[80,50079,3491,70357,2883]
[81,46588,3454,67474,3046]
[82,43134,3476,64428,3255]
[83,39658,3625,61173,3618]
[84,36033,3922,57555,4169]
[85,32111,4001,53387,4597]
[86,28110,3870,48790,4745]
[87,24240,3610,44045,4715]
[88,20630,3206,39330,4501]
[89,17423,2914,34829,4414]
[90,14509,2621,30415,4283]
[91,11888,2344,26132,4099]
[92,9544,2026,22033,3811]
[93,7518,1719,18223,3469]
[94,5800,1431,14753,3099]
[95,4368,1171,11654,2701]
[96,3197,935,8953,2292]
[97,2262,715,6662,1861]
[98,1547,527,4800,1459]
[99,1020,374,3341,1101]
[100,646,254,2240,797]
[101,393,165,1443,552]
[102,228,102,891,364]
[103,125,60,527,229]
[104,65,33,297,137]
[105,32,17,160,78]
[106,15,8,81,42]
[107,6,4,39,21]
[108,3,2,18,10]
[109,1,1,8,5]
[110,0,0,3,2]
[111,0,0,1,1]
[112,0,0,0,0]
[113,0,0,0,0]
[114,0,0,0,0]
[115,0,0,0,0]
[116,0,0,0,0]
[117,0,0,0,0]
[118,0,0,0,0]
[119,0,0,0,0]

{"sheet":"es. capitale differito","index":1,"n_rows":75,"n_cols":5,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
["x =",40,null,"età dell'assicurato"]
["i =",0.01,null,"tasso annuo d'interesse"]
["sesso:","m"]
[]
[]
["h","E(x,h)",null,"x + h","1000*E(x,h)"]
[1,0.98870199085411392,null,{"$f":"+$B$1+A7","v":41},{"$f":"1000*B7","v":988.70199085411389}]
[2,0.97744890500264914,null,42,977.4489050026491]
[3,0.96620177494303938,null,43,966.20177494303937]
[4,0.95496277355284498,null,44,954.96277355284496]
[5,0.94367522237530166,null,45,943.6752223753017]
[6,0.93235263326626761,null,46,932.35263326626762]
[7,0.92100804586334317,null,47,921.00804586334323]
[8,0.90953990506989069,null,48,909.53990506989066]
[9,0.89802023089929039,null,49,898.02023089929037]
[10,0.88641573788162731,null,50,886.41573788162736]
[11,0.87469452476695075,null,51,874.69452476695074]
[12,0.86279861956413795,null,52,862.79861956413799]
[13,0.85073579787838505,null,53,850.73579787838503]
[14,0.83831654897266905,null,54,838.31654897266901]
[15,0.82582917721044968,null,55,825.82917721044964]
[16,0.81314678214672531,null,56,813.14678214672529]
[17,0.80016496201653386,null,57,800.16496201653388]
[18,0.786714722491625,null,58,786.71472249162503]
[19,0.77292383127001596,null,59,772.92383127001597]
[20,0.75855236628809308,null,60,758.55236628809303]
[21,0.74388829087092601,null,61,743.88829087092597]
[22,0.7288775780612865,null,62,728.8775780612865]
[23,0.71350133068717558,null,63,713.5013306871756]
[24,0.69782276644925245,null,64,697.82276644925241]
[25,0.68161375006139746,null,65,681.61375006139747]
[26,0.6647587809139287,null,66,664.75878091392872]
[27,0.64716304417687298,null,67,647.16304417687297]
[28,0.62880606937146954,null,68,628.80606937146956]
[29,0.60979989083157882,null,69,609.79989083157886]
[30,0.58993168489455816,null,70,589.9316848945582]
[31,0.56911855226545416,null,71,569.11855226545413]
[32,0.54751366153340419,null,72,547.51366153340416]
[33,0.52500516548344345,null,{"$f":"+$B$1+A39","v":73},{"$f":"1000*B39","v":525.00516548344342}]
[34,0.50178725233099108,null,74,501.78725233099107]
[35,0.47772713435509673,null,75,477.72713435509672]
[36,0.45280575757096742,null,76,452.80575757096744]
[37,0.42709092816021743,null,77,427.09092816021746]
[38,0.40078949258711793,null,78,400.78949258711793]
[39,0.37381421120556946,null,79,373.81421120556945]
[40,0.3464206966475295,null,80,346.4206966475295]
[41,0.31908094943484555,null,81,319.08094943484554]
[42,0.29249952762498282,null,82,292.49952762498282]
[43,0.26626548229743119,null,83,266.26548229743116]
[44,0.23953176200133255,null,84,239.53176200133257]
[45,0.21134654096299491,null,85,211.34654096299491]
[46,0.18318115184210298,null,86,183.18115184210299]
[47,0.15639799516935152,null,87,156.3979951693515]
[48,0.1317881678407232,null,88,131.78816784072319]
[49,0.11019927954046162,null,89,110.19927954046162]
[50,9.0859831169596436E-2,null,90,90.859831169596433]
[51,7.3709228818996095E-2,null,91,73.709228818996095]
[52,5.8589815160016483E-2,null,92,58.589815160016485]
[53,4.5695416992377558E-2,null,93,45.695416992377559]
[54,3.4904140104118409E-2,null,94,34.904140104118412]
[55,2.6026166605460772E-2,null,95,26.026166605460773]
[56,1.8860310502497483E-2,null,96,18.860310502497484]
[57,1.321226965770797E-2,null,97,13.212269657707971]
[58,8.9465124005192239E-3,null,98,8.9465124005192234]
[59,5.8403954306512178E-3,null,99,5.8403954306512178]
[60,3.662294164434757E-3,null,100,3.6622941644347571]
[61,2.2059307951795659E-3,null,101,2.2059307951795657]
[62,1.2671055886452048E-3,null,102,1.2671055886452047]
[63,6.8780701138027858E-4,null,103,0.68780701138027855]
[64,3.5411846130469789E-4,null,104,0.35411846130469787]
[65,1.7260915097867986E-4,null,105,0.17260915097867985]
[66,8.0109445070550688E-5,null,106,8.0109445070550692E-2]
[67,3.1726512899227986E-5,null,107,3.1726512899227989E-2]
[68,1.570619450456831E-5,null,108,1.570619450456831E-2]
[69,5.1835625427618186E-6,null,109,5.1835625427618182E-3]

{"sheet":"es. elem. caso morte","index":2,"n_rows":76,"n_cols":5,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
["x =",40,null,"età dell'assicurato"]
["i =",0.01,null,"tasso annuo d'interesse"]
["sesso:","m"]
[]
[]
["h","A(x,h)",null,"x + h","1000*A(x,h)"]
[0,1.3970190468761072E-3,null,{"$f":"+$B$1+A7","v":40},{"$f":"1000*B7","v":1.3970190468761072}]
[1,1.4639572291467481E-3,null,41,1.4639572291467482]
[2,1.5694181288906759E-3,null,42,1.5694181288906759]
[3,1.6726471828373854E-3,null,43,1.6726471828373854]
[4,1.8324742116737425E-3,null,44,1.8324742116737425]
[5,1.9792700756152033E-3,null,45,1.9792700756152033]
[6,2.1133732121692136E-3,null,46,2.1133732121692135]
[7,2.3492492502511057E-3,null,47,2.3492492502511055]
[8,2.5143285758489806E-3,null,48,2.5143285758489804]
[9,2.7132036028184574E-3,null,49,2.7132036028184574]
[10,2.9448196703041338E-3,null,50,2.9448196703041338]
[11,3.2355633734369883E-3,null,51,3.2355633734369884]
[12,3.5202610960088057E-3,null,52,3.5202610960088059]
[13,3.9961221940490402E-3,null,53,3.9961221940490401]
[14,4.1872079110046329E-3,null,54,4.1872079110046325]
[15,4.5058685566902509E-3,null,55,4.5058685566902508]
[16,4.9308618911149179E-3,null,56,4.930861891114918]
[17,5.5278141584084676E-3,null,57,5.5278141584084679]
[18,6.0016365434742321E-3,null,58,6.0016365434742323]
[19,6.7187537812295906E-3,null,59,6.7187537812295908]
[20,7.1536559489682695E-3,null,60,7.1536559489682698]
[21,7.6454822069569267E-3,null,61,7.6454822069569266]
[22,8.1596376903359264E-3,null,62,8.1596376903359271]
[23,8.614194627158886E-3,null,63,8.6141946271588861]
[24,9.2998800863772733E-3,null,64,9.2998800863772733]
[25,1.0106318156761839E-2,null,65,10.106318156761839]
[26,1.1013966628997058E-2,null,66,11.013966628997057]
[27,1.194941991256307E-2,null,67,11.949419912563069]
[28,1.2780375872846514E-2,null,68,12.780375872846514]
[29,1.3830583255519795E-2,null,69,13.830583255519795]
[30,1.4972224857870836E-2,null,70,14.972224857870836]
[31,1.5970053580906762E-2,null,71,15.970053580906761]
[32,1.7087568708045797E-2,null,{"$f":"+$B$1+A39","v":72},{"$f":"1000*B39","v":17.087568708045797}]
[33,1.8019842207071809E-2,null,73,18.019842207071807]
[34,1.9091927358755787E-2,null,74,19.091927358755786]
[35,2.0191405156851132E-2,null,75,20.191405156851133]
[36,2.1231604088265129E-2,null,76,21.231604088265129]
[37,2.2072812522008288E-2,null,77,22.072812522008288]
[38,2.3007068583656181E-2,null,78,23.007068583656181]
[39,2.3692383754024413E-2,null,79,23.692383754024412]
[40,2.3909839325084697E-2,null,80,23.909839325084697]
[41,2.3422204488725614E-2,null,81,23.422204488725615]
[42,2.3338010400571655E-2,null,82,23.338010400571655]
[43,2.4097428392163587E-2,null,83,24.097428392163586]
[44,2.581361943436411E-2,null,84,25.81361943436411]
[45,2.6072849111357311E-2,null,85,26.072849111357311]
[46,2.4969481902037557E-2,null,86,24.969481902037558]
[47,2.306133232695156E-2,null,87,23.061332326951561]
[48,2.0284054955303932E-2,null,88,20.284054955303933]
[49,1.8248366395217038E-2,null,89,18.248366395217037]
[50,1.6251000061792462E-2,null,90,16.25100006179246]
[51,1.4389619314237073E-2,null,91,14.389619314237073]
[52,1.2314300987836783E-2,null,92,12.314300987836782]
[53,1.0338847017047487E-2,null,93,10.338847017047486]
[54,8.532387953072304E-3,null,94,8.5323879530723037]
[55,6.9081712850874426E-3,null,95,6.9081712850874428]
[56,5.4613050972400325E-3,null,96,5.4613050972400323]
[57,4.1349427061223307E-3,null,97,4.1349427061223309]
[58,3.0175376391697963E-3,null,98,3.0175376391697966]
[59,2.1202755688832804E-3,null,99,2.1202755688832804]
[60,1.4201030309934609E-3,null,100,1.4201030309934608]
[61,9.1698430757218747E-4,null,101,0.91698430757218752]
[62,5.6675297737734953E-4,null,102,0.56675297737734953]
[63,3.2687857966587493E-4,null,103,0.32687857966587491]
[64,1.7800318694676361E-4,null,{"$f":"+$B$1+A71","v":104},{"$f":"1000*B71","v":0.17800318694676362}]
[65,9.0790704413290762E-5,null,105,9.0790704413290763E-2]
[66,4.7589769348841986E-5,null,106,4.7589769348841987E-2]
[67,1.570619450456831E-5,null,107,1.570619450456831E-2]
[68,1.0367125085523637E-5,null,108,1.0367125085523636E-2]
[69,5.1322401413483359E-6,null,109,5.1322401413483355E-3]