{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["sim_f2002","Es. cap. diff.","Es. rendita vital","Es. rendita temp.","Es vita intera","Es temp caso morte"],"not_rendered":{"charts":0,"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. cap. diff.","index":1,"n_rows":77,"n_cols":4,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
["C =",1000,null,"capitale assicurato"]
["n =",10,null,"durata differimento"]
["i =",0.03,null,"tasso annuo d'interesse"]
["sesso:","m"]
[]
["x","1000 * E(x,10)"]
[30,736.29830587015817]
[31,735.91188747558726]
[32,735.4640086463022]
[33,734.94662154996342]
[34,734.3669980733423]
[35,733.70171203877203]
[36,732.92041744053176]
[37,732.05286840465067]
[38,731.00704726332094]
[39,729.85830277490174]
[40,728.58285785206829]
[41,727.16420124481238]
[42,725.53249438010459]
[43,723.71632227203929]
[44,721.54444598217685]
[45,719.29851123209812]
[46,716.85321400796101]
[47,714.09763865370462]
[48,710.94664704429499]
[49,707.4440006932698]
[50,703.37932742743624]
[51,699.02515669011939]
[52,694.36311012243505]
[53,689.3528420693815]
[54,684.19293516112316]
[55,678.40589142913655]
[56,671.9494855494396]
[57,664.7765167888133]
[58,656.96304123629261]
[59,648.47335346219438]
[60,639.23073146120203]
[61,628.83471794126876]
[62,617.42165902151612]
[63,604.79790731315131]
[64,591.03878455984147]
[65,576.08034420780371]
[66,559.87277364971646]
[67,542.4355297274584]
[68,523.89118736072021]
[69,503.86008584091917]
[70,482.66254551724143]
[71,460.82881099645903]
[72,439.1083540852797]
[73,416.86245711868128]
[74,392.36022587947178]
[75,363.62750462263529]
[76,332.51430668553587]
[77,300.99017934245506]
[78,270.27232889623468]
[79,242.30615055408273]
[80,215.58055494791398]
[81,189.87268095415706]
[82,164.64117224867493]
[83,141.05850149260124]
[84,119.77200639416662]
[85,101.217720415711]
[86,84.62711653948169]
[87,69.436486612887478]
[88,55.798026483045753]
[89,43.561716879679722]
[90,33.130103316788514]
[91,24.598663236407557]
[92,17.775923365093604]
[93,12.371872753669944]
[94,8.3389835290150245]
[95,5.45123747177088]
[96,3.4912132384894834]
[97,1.9737239121929049]
[98,1.4429746248805273]
[99,0.72950383813404429]
[100,0]

{"sheet":"Es. rendita vital","index":2,"n_rows":116,"n_cols":4,"rows_kept":116,"cut":false,"hidden":false,"merged":[]}
["R =",100,null,"rata annua anticipata"]
["i =",0.03,null,"tasso annuo d'interesse"]
["sesso:","m"]
[]
[]
["x","100 * a(x)"]
[0,3037.8349279513855]
[1,3040.1981029115518]
[2,3029.3171142928018]
[3,3017.8638806951471]
[4,3005.9134735238217]
[5,2993.5122321150825]
[6,2980.7372143687953]
[7,2967.5473039979483]
[8,2953.9896859390242]
[9,2939.9938518116737]
[10,2925.5763072573095]
[11,2910.7536360285148]
[12,2895.4259060754048]
[13,2879.7234416177484]
[14,2863.6916825863741]
[15,2847.3764804957609]
[16,2830.82411757215]
[17,2814.1380768865297]
[18,2797.2539531808779]
[19,2780.1343692411992]
[20,2762.6854423663185]
[21,2744.8117153092339]
[22,2726.5264560207197]
[23,2707.7605629517357]
[24,2688.4164558592815]
[25,2668.5574428476671]
[26,2648.0589829285773]
[27,2626.8749005789095]
[28,2605.0376892880658]
[29,2582.5008171172153]
[30,2559.1908467420549]
[31,2535.2144004092042]
[32,2510.4987220622188]
[33,2485.097104069022]
[34,2459.0120598609228]
[35,2432.2952004144026]
[36,2404.8002460703597]
[37,2376.5751214542033]
[38,2347.5703718927148]
[39,2317.8310464454653]
[40,2287.3539224207898]
[41,2256.1579546852249]
[42,2224.1689221435249]
[43,2191.4478235729348]
[44,2157.9643916830614]
[45,2123.8194659203864]
[46,2088.959259544386]
[47,2053.3288818404258]
[48,2017.1253560279063]
[49,1980.1678246234396]
[50,1942.5004577052161]
[51,1904.1646809030665]
[52,1865.2583550528107]
[53,1825.7397052014537]
[54,1785.985013997755]
[55,1745.3694808371604]
[56,1704.1215305021763]
[57,1662.42681790607]
[58,1620.6072908823132]
[59,1578.3870135933923]
[60,1536.2260328374439]
[61,1493.5387332796365]
[62,1450.4007896943194]
[63,1406.8193634193835]
[64,1362.6397854591123]
[65,1318.2631494623483]
[66,1273.8879181460661]
[67,1229.68211701316]
[68,1185.6843539950139]
[69,1141.6916184711711]
[70,1098.0968367978026]
[71,1055.0851476740665]
[72,1012.4316780101393]
[73,970.39285340969604]
[74,928.69930330020532]
[75,887.67203728180448]
[76,847.47959040255955]
[77,808.17755259612977]
[78,769.59462708422575]
[79,732.13021485380273]
[80,695.62371185534869]
[81,659.46353271194573]
[82,622.39105285490893]
[83,585.22366594530604]
[84,550.05939412151963]
[85,520.17999603974147]
[86,494.38533790171113]
[87,471.07083349297091]
[88,449.08384459455658]
[89,425.7388340357731]
[90,402.89531577416983]
[91,380.7662668795806]
[92,360.21394196190153]
[93,340.24824660107993]
[94,320.75377715264256]
[95,301.91919979621946]
[96,284.15469397910016]
[97,268.08348070323535]
[98,253.14219673641901]
[99,239.2336350017425]
[100,226.43785902914968]
[101,214.0692688061466]
[102,202.51797947385987]
[103,192.60257839713017]
[104,183.42433797893079]
[105,174.53935711529439]
[106,163.78781403467352]
[107,164.25362113928426]
[108,132.36245954692558]
[109,100]

{"sheet":"Es. rendita temp.","index":3,"n_rows":77,"n_cols":4,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
["R =",100,null,"rata annua anticipata"]
["m =",20,null,"durata della rendita"]
["i =",0.03,null,"tasso annuo d'interesse"]
["sesso:","m"]
[]
["x","100 * a(x,m)"]
[20,1520.6277408729516]
[21,1520.4206326997444]
[22,1520.2518495297536]
[23,1520.0901242186585]
[24,1519.884271861418]
[25,1519.6721663288497]
[26,1519.3831988608961]
[27,1518.9889918343106]
[28,1518.5065845113661]
[29,1517.9019751330115]
[30,1517.1280769846248]
[31,1516.2410780978912]
[32,1515.1911995387941]
[33,1513.9991796731351]
[34,1512.6571268326966]
[35,1511.1754984190995]
[36,1509.4610023075395]
[37,1507.5294918630425]
[38,1505.3294036320167]
[39,1502.8563592776359]
[40,1500.083982209499]
[41,1496.9831512053297]
[42,1493.4816621348818]
[43,1489.5914060434518]
[44,1485.2623611898498]
[45,1480.5382289170759]
[46,1475.3412731374544]
[47,1469.5799164991492]
[48,1463.3328971619767]
[49,1456.406994921201]
[50,1448.7723109825031]
[51,1440.3795443910296]
[52,1431.2138869948064]
[53,1421.1643354939229]
[54,1410.4333541155218]
[55,1398.4527801040183]
[56,1385.2944353822891]
[57,1370.999283879579]
[58,1355.7304072276784]
[59,1339.1709046689357]
[60,1321.6033485608812]
[61,1302.4359909838315]
[62,1281.6612341281943]
[63,1259.2742114149542]
[64,1235.0809508983532]
[65,1209.2965419597483]
[66,1181.8503221049493]
[67,1152.7714337535708]
[68,1122.0970943709215]
[69,1089.7138463348558]
[70,1056.1745077255816]
[71,1021.7685555544113]
[72,986.38989791090819]
[73,950.38557821457277]
[74,913.62587359443216]
[75,876.55973595380669]
[76,839.48355489307198]
[77,802.57468812474553]
[78,765.7770750341831]
[79,729.60503878188183]
[80,694.00644600671353]
[81,658.46369775885125]
[82,621.79835384102432]
[83,584.88754404728968]
[84,549.87619415028962]
[85,520.08369188459369]
[86,494.33694657755842]
[87,471.04832278812881]
[88,449.07318741308069]
[89,425.73565619180715]
[90,402.89531577416983]

{"sheet":"Es vita intera","index":4,"n_rows":116,"n_cols":4,"rows_kept":116,"cut":false,"hidden":false,"merged":[]}
["C =",1000,null,"capitale assicurato"]
["i =",0.03,null,"tasso annuo d'interesse"]
["sesso:","m"]
[]
[]
["x","A(x)"]
[0,115.19371030542219]
[1,114.50540691896563]
[2,117.67462690500936]
[3,121.01052018587968]
[4,124.49122130374158]
[5,128.10323336453934]
[6,131.8241123197684]
[7,135.66583378700545]
[8,139.61465458086678]
[9,143.69111112281351]
[10,147.890395944473]
[11,152.2076788266466]
[12,156.67206619163017]
[13,161.2455995288116]
[14,165.915043906882]
[15,170.66704451579841]
[16,175.48812109549092]
[17,180.34813294567149]
[18,185.26583887935669]
[19,190.2521254637291]
[20,195.33433717485951]
[21,200.54027709439856]
[22,205.86608077066478]
[23,211.33187486842724]
[24,216.96608081768602]
[25,222.75025936475785]
[26,228.72068458391027]
[27,234.89080565662908]
[28,241.25115845978758]
[29,247.815295985278]
[30,254.60460774503269]
[31,261.58803871576583]
[32,268.78677998187811]
[33,276.18530949445972]
[34,283.78289518613894]
[35,291.56450473366914]
[36,299.57274386300202]
[37,307.79365394537768]
[38,316.241639254549]
[39,324.90357870520427]
[40,333.78041094540083]
[41,342.86661514022569]
[42,352.18380908440992]
[43,361.71422614380532]
[44,371.46668203405972]
[45,381.41180604260575]
[46,391.56526421037302]
[47,401.94304412414806]
[48,412.48776038022174]
[49,423.25208991550329]
[50,434.22316765867492]
[51,445.38892789231073]
[52,456.72086746034654]
[53,468.23115382481944]
[54,479.81019009774127]
[55,491.63995703772019]
[56,503.65392315470586]
[57,515.79801420211572]
[58,527.97845896631679]
[59,540.2756271087211]
[60,552.55552441627879]
[61,564.98871846224222]
[62,577.55316805019891]
[63,590.24678735357816]
[64,603.11462559443385]
[65,616.0398593798991]
[66,628.96468403512699]
[67,641.84016009325478]
[68,654.65504252572453]
[69,667.46846063946509]
[70,680.16596986471825]
[71,692.69364630852465]
[72,705.11698698733869]
[73,717.36130483212787]
[74,729.50505729120289]
[75,741.45474642277566]
[76,753.16128434876964]
[77,764.6084798263704]
[78,775.84622512109956]
[79,786.75818984840714]
[80,797.39115188679159]
[81,807.92324289943338]
[82,818.7210525665314]
[83,829.54650506447388]
[84,839.78852598402329]
[85,848.49126328939576]
[86,856.00427051406484]
[87,862.79490286612508]
[88,869.19888021517772]
[89,875.99839785365862]
[90,882.65184977451361]
[91,889.09720382148134]
[92,895.0833178751742]
[93,900.89856895114167]
[94,906.57656976136604]
[95,912.0623689913923]
[96,917.23649689929107]
[97,921.91743280488311]
[98,926.26926308648012]
[99,930.32030048492913]
[100,934.04722552549049]
[101,937.64972753219035]
[102,941.01418073576906]
[103,943.90216163190371]
[104,946.57543554011727]
[105,949.16329404408907]
[106,952.29481144621161]
[107,952.15913947399508]
[108,961.4478273164292]
[109,970.87378640776694]

{"sheet":"Es temp caso morte","index":5,"n_rows":86,"n_cols":4,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
["C =",1000,null,"capitale assicurato"]
["n =",10,null,"durata della polizza"]
["i =",0.03,null,"tasso annuo d'interesse"]
["sesso:","m"]
[]
["x","nAx"]
[20,7.5666479154862971]
[21,7.635616763203525]
[22,7.6563838903613162]
[23,7.6700698276252535]
[24,7.71415312299116]
[25,7.7820762562690113]
[26,7.877137415150071]
[27,8.0329945573300385]
[28,8.2238796398331679]
[29,8.4837577706710512]
[30,8.842656633288879]
[31,9.268420815556599]
[32,9.7682639723340348]
[33,10.344661023510549]
[34,10.990023016521716]
[35,11.722009648409257]
[36,12.586566962723323]
[37,13.55009555899797]
[38,14.71017950674282]
[39,15.989526713544905]
[40,17.412854507065628]
[41,18.995731146130197]
[42,20.81797888045952]
[43,22.847697524513439]
[44,25.262304243382072]
[45,27.775916883160864]
[46,30.519330649203525]
[47,33.612900160147262]
[48,37.123245266504952]
[49,41.037338796644434]
[50,45.567034528438448]
[51,50.447600441092113]
[52,55.689253431945104]
[53,61.342853440308446]
[54,67.163424173683723]
[55,73.714887079219807]
[56,81.021427288536486]
[57,89.117748240147478]
[58,97.894291267942279]
[59,107.44011610759844]
[60,117.77253398463702]
[61,129.39890476611208]
[62,142.19866814022336]
[63,156.38817140367561]
[64,171.94884320278379]
[65,188.9023538461567]
[66,207.29018676119853]
[67,227.0893543045309]
[68,248.19604243769899]
[69,271.05241156640056]
[70,295.29512672211405]
[71,320.37933890677539]
[72,345.60973313988131]
[73,371.55451043673673]
[74,400.00544154512289]
[75,432.9199856587453]
[76,468.52761781892741]
[77,504.91568727693931]
[78,540.92581949134421]
[79,574.49839017294323]
[80,607.10857628659915]
[81,639.10797318100413]
[82,671.35348585132942]
[83,702.46710293139699]
[84,731.2060312737633]
[85,756.1743894231339]
[86,778.3811905967026]
[87,798.78019538498131]
[88,817.51488334304702]
[89,835.47204831651561]
[90,851.70676869009446]
[91,866.03227394020769]
[92,878.35592191294893]
[93,889.22073151551774]
[94,898.68309279542689]
[95,906.88825447606973]
[96,913.91183264662527]
[97,920.03813354309023]
[98,924.88191826851596]
[99,929.61204433140097]