{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["README","Sheet1","Sheet2","Sheet3","Sheet4"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"README","index":0,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Sheet1: call \"WorksheetFunction\""]
["Sheet2: define \"Custom Function\""]
["Sheet3: Msgbox"]
["Sheet4: Annuity Calculation"]

{"sheet":"Sheet1","index":1,"n_rows":50,"n_cols":7,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["Price1","Price2"]
[200,{"$f":"MAX(Price, 300)","v":300}]
[]
[null,null,null,"Call WorksheetFunction"]
[null,"Sum","Max","Min","Average","Power","Count"]
[null,500,300,200,250,40000,2]
[]
[null,null,null,"Call Function"]
[null,"Random","Absolute","Sqrt","Int","Exp","Log"]
[null,0.7055475115776062,200,14.142135623730951,200,20.085536923187668,5.2983173665480363]
[]
[null,null,"Simulation and Count"]
[null,"Simulation","Threshold","True or Faluse","Count(>0.5)"]
[null,0.5334240198135376,0.5,1,23]
[null,0.57951861619949341,null,1]
[null,0.28956246376037598,null,0]
[null,0.30194801092147827,null,0]
[null,0.77474009990692139,null,1]
[null,1.4017641544342041E-2,null,0]
[null,0.76072359085083008,null,1]
[null,0.81449002027511597,null,1]
[null,0.7090378999710083,null,1]
[null,4.5352756977081299E-2,null,0]
[null,0.4140326976776123,null,0]
[null,0.86261934041976929,null,1]
[null,0.79048001766204834,null,1]
[null,0.37353616952896118,null,0]
[null,0.96195316314697266,null,1]
[null,0.87144583463668823,null,1]
[null,5.6236863136291504E-2,null,0]
[null,0.94955664873123169,null,1]
[null,0.36401867866516113,null,0]
[null,0.5248684287071228,null,1]
[null,0.76711165904998779,null,1]
[null,5.3504526615142822E-2,null,0]
[null,0.59245824813842773,null,1]
[null,0.468700110912323,null,0]
[null,0.29816544055938721,null,0]
[null,0.62269669771194458,null,1]
[null,0.64782118797302246,null,1]
[null,0.26379293203353882,null,0]
[null,0.27934205532073975,null,0]
[null,0.82980161905288696,null,1]
[null,0.82460212707519531,null,1]
[null,0.58916300535202026,null,1]
[null,0.98609316349029541,null,1]
[null,0.91096431016921997,null,1]
[null,0.22686600685119629,null,0]
[null,0.69511550664901733,null,1]
[null,0.9800032377243042,null,1]

{"sheet":"Sheet2","index":2,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["net income","other income ","avs",null,"cap_income"]
[25000,1600,12000,null,{"$f":"cap_income(net_income,oth_income,avs)","v":12000}]

{"sheet":"Sheet3","index":3,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Account","Salary","Rent"]
[100,25000,500]
[]
[]
["Account","Salary","Rent"]
[100,25000,2000]

{"sheet":"Sheet4","index":4,"n_rows":66,"n_cols":12,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
["Life Table",null,null,null,"risk free p.a.",null,null,"mthod2",null,32.665424987001707]
["x","q(x)","age","q(x)",0.02,null,null,null,null,"mthod3"]
[37,3.0380000000000001E-4,37,3.0380000000000001E-4,{"$f":"1/(1+rf)","v":0.98039215686274506},32.6654249870017,0.99969620000000003,{"$f":"1+H4*G3*$E$3","v":32.6654249870017},null,32.665424987001707,null,32.665424987001707]
[38,3.3324E-4,38,3.3324E-4,null,32.308548823874425,0.99966675999999999,32.308548823874425,null,32.308548823874432,null,32.308548823874432]
[39,3.6795000000000003E-4,39,3.6795000000000003E-4,null,31.94536527387578,0.99963204999999999,31.94536527387578,null,31.945365273875787,null,31.945365273875787]
[40,4.0811999999999999E-4,40,4.0811999999999999E-4,null,31.575890928420407,0.99959187999999999,31.57589092842041,null,31.575890928420417,null,31.575890928420417]
[41,4.5375999999999999E-4,41,4.5375999999999999E-4,null,31.200142149002666,0.99954624000000003,31.200142149002669,null,31.20014214900268,null,31.20014214900268]
[42,5.0469000000000002E-4,42,5.0469000000000002E-4,null,30.818129026209654,0.99949531000000003,30.818129026209657,null,30.818129026209668,null,30.818129026209668]
[43,5.6141999999999997E-4,43,5.6141999999999997E-4,null,30.429849247350493,0.99943857999999997,30.429849247350496,null,30.429849247350507,null,30.429849247350507]
[44,6.2449000000000001E-4,44,6.2449000000000001E-4,null,30.035308655282755,0.99937551000000002,30.035308655282755,null,30.035308655282769,null,30.035308655282769]
[45,6.9561000000000004E-4,45,6.9561000000000004E-4,null,29.63452129058917,0.99930439000000004,29.63452129058917,null,29.634521290589184,null,29.634521290589184]
[46,7.7554000000000002E-4,46,7.7554000000000002E-4,null,29.227542687369716,0.99922445999999998,29.227542687369716,null,29.227542687369731,null,29.227542687369731]
[47,8.6408000000000003E-4,47,8.6408000000000003E-4,null,28.814440292141281,0.99913591999999996,28.814440292141278,null,28.814440292141295,null,28.814440292141295]
[48,9.6071000000000004E-4,48,9.6071000000000004E-4,null,28.395264878460292,0.99903929000000002,28.395264878460285,null,28.395264878460303,null,28.395264878460303]
[49,1.06434E-3,49,1.06434E-3,null,27.970041274382211,0.99893566,27.970041274382204,null,27.970041274382222,null,27.970041274382222]
[50,1.1714200000000001E-3,50,1.1714200000000001E-3,null,27.538752695914226,0.99882857999999997,27.538752695914219,null,27.538752695914237,null,27.538752695914237]
[51,1.2796000000000001E-3,51,1.2796000000000001E-3,null,27.101274725070954,0.99872039999999995,27.101274725070951,null,27.101274725070965,null,27.101274725070965]
[52,1.3877E-3,52,1.3877E-3,null,26.65741104274267,0.99861230000000001,26.657411042742666,null,26.65741104274268,null,26.65741104274268]
[53,1.4959299999999999E-3,53,1.4959299999999999E-3,null,26.206926615662077,0.99850406999999997,26.206926615662077,null,26.206926615662088,null,26.206926615662088]
[54,1.60574E-3,54,1.60574E-3,null,25.749584724251868,0.99839425999999998,25.749584724251871,null,25.749584724251882,null,25.749584724251882]
[55,1.7176400000000001E-3,55,1.7176400000000001E-3,null,25.285177840202035,0.99828236000000004,25.285177840202035,null,25.285177840202046,null,25.285177840202046]
[56,1.8342300000000001E-3,56,1.8342300000000001E-3,null,24.81350206068559,0.99816576999999995,24.81350206068559,null,24.813502060685604,null,24.813502060685604]
[57,1.9602199999999999E-3,57,1.9602199999999999E-3,null,24.334407001253211,0.99803978000000004,24.334407001253211,null,24.334407001253226,null,24.334407001253226]
[58,2.0994099999999999E-3,58,2.0994099999999999E-3,null,23.847842158434084,0.99790058999999998,23.847842158434084,null,23.847842158434094,null,23.847842158434094]
[59,2.2554900000000002E-3,59,2.2554900000000002E-3,null,23.3538282621947,0.99774450999999997,23.353828262194703,null,23.35382826219471,null,23.35382826219471]
[60,2.4266399999999999E-3,60,2.4266399999999999E-3,null,22.852448296045843,0.99757335999999996,22.852448296045846,null,22.852448296045853,null,22.852448296045853]
[61,2.6132E-3,61,2.6132E-3,null,22.34371742040782,0.99738680000000002,22.343717420407824,null,22.343717420407831,null,22.343717420407831]
[62,2.8177100000000002E-3,62,2.8177100000000002E-3,null,21.827631736068671,0.99718229000000003,21.827631736068678,null,21.827631736068682,null,21.827631736068682]
[63,3.0463199999999999E-3,63,3.0463199999999999E-3,null,21.304213466115655,0.99695367999999995,21.304213466115659,null,21.304213466115666,null,21.304213466115666]
[64,3.3064499999999998E-3,64,3.3064499999999998E-3,null,20.773580709825929,0.99669355000000004,20.773580709825929,null,20.773580709825939,null,20.773580709825939]
[65,3.5914300000000001E-3,65,3.5914300000000001E-3,null,20.235961518986901,0.99640857000000005,20.235961518986901,null,20.235961518986912,null,20.235961518986912]
[66,3.9033900000000001E-3,66,3.9033900000000001E-3,null,19.69140103779581,0.99609661000000005,19.691401037795814,null,19.691401037795821,null,19.691401037795821]
[67,4.25327E-3,67,4.25327E-3,null,19.139939707807788,0.99574673000000002,19.139939707807788,null,19.139939707807798,null,19.139939707807798]
[68,4.6583199999999996E-3,68,4.6583199999999996E-3,null,18.581771794484268,0.99534168000000001,18.581771794484268,null,18.581771794484279,null,18.581771794484279]
[69,5.1393899999999998E-3,69,5.1393899999999998E-3,null,18.017337755185689,0.99486061000000003,18.017337755185693,null,18.0173377551857,null,18.0173377551857]
[70,5.70003E-3,70,5.70003E-3,null,17.447353263176641,0.99429997000000003,17.447353263176645,null,17.447353263176652,null,17.447353263176652]
[71,6.3531500000000001E-3,71,6.3531500000000001E-3,null,16.872473936049879,0.99364684999999997,16.872473936049882,null,16.872473936049886,null,16.872473936049886]
[72,7.1209300000000001E-3,72,7.1209300000000001E-3,null,16.293438070850705,0.99287906999999997,16.293438070850705,null,16.293438070850708,null,16.293438070850708]
[73,8.0345499999999997E-3,73,8.0345499999999997E-3,null,15.711185081449772,0.99196545000000003,15.71118508144977,null,15.711185081449772,null,15.711185081449772]
[74,9.1267399999999995E-3,74,9.1267399999999995E-3,null,15.12694699505791,0.99087325999999998,15.126946995057908,null,15.12694699505791,null,15.12694699505791]
[75,1.041371E-2,75,1.041371E-2,null,14.542208894565457,0.98958628999999998,14.542208894565453,null,14.542208894565455,null,14.542208894565455]
[76,1.191206E-2,76,1.191206E-2,null,13.958411926317982,0.98808794,13.958411926317979,null,13.958411926317982,null,13.958411926317982]
[77,1.3638880000000001E-2,77,1.3638880000000001E-2,null,13.376926920942221,0.98636111999999998,13.376926920942218,null,13.376926920942221,null,13.376926920942221]
[78,1.5627390000000001E-2,78,1.5627390000000001E-2,null,12.799029892176879,0.98437260999999998,12.799029892176875,null,12.799029892176879,null,12.799029892176879]
[79,1.790949E-2,79,1.790949E-2,null,12.226072086687193,0.98209051000000003,12.226072086687187,null,12.226072086687191,null,12.226072086687191]
[80,2.046653E-2,80,2.046653E-2,null,11.65940757173281,0.97953347000000002,11.659407571732805,null,11.659407571732809,null,11.659407571732809]
[81,2.329941E-2,81,2.329941E-2,null,11.099769488394783,0.97670058999999998,11.099769488394779,null,11.099769488394781,null,11.099769488394781]
[82,2.6428650000000001E-2,82,2.6428650000000001E-2,null,10.547515772630668,0.97357134999999995,10.547515772630664,null,10.547515772630666,null,10.547515772630666]
[83,2.9907920000000001E-2,83,2.9907920000000001E-2,null,10.002827310071606,0.97009208000000002,10.002827310071602,null,10.002827310071604,null,10.002827310071604]
[84,3.3803090000000001E-2,84,3.3803090000000001E-2,null,9.4659919873513836,0.96619690999999996,9.4659919873513818,null,9.4659919873513818,null,9.4659919873513818]
[85,3.8183979999999999E-2,85,3.8183979999999999E-2,null,8.9374243880560655,0.96181601999999999,8.9374243880560638,null,8.9374243880560638,null,8.9374243880560638]
[86,4.310692E-2,86,4.310692E-2,null,8.4175899625971979,0.95689307999999995,8.4175899625971979,null,8.4175899625971979,null,8.4175899625971979]
[87,4.8633940000000001E-2,87,4.8633940000000001E-2,null,7.9067786359675027,0.95136606000000001,7.9067786359675027,null,7.9067786359675036,null,7.9067786359675036]
[88,5.4833E-2,88,5.4833E-2,null,7.4050510154701685,0.94516699999999998,7.4050510154701685,null,7.4050510154701694,null,7.4050510154701694]
[89,6.1778390000000002E-2,89,6.1778390000000002E-2,null,6.9121668824446605,0.93822161000000004,6.9121668824446605,null,6.9121668824446614,null,6.9121668824446614]
[90,6.9550970000000004E-2,90,6.9550970000000004E-2,null,6.4274902174695745,0.93044903000000001,6.4274902174695736,null,6.4274902174695745,null,6.4274902174695745]
[91,7.8238360000000007E-2,91,7.8238360000000007E-2,null,5.9498584482580048,0.92176163999999994,5.9498584482580039,null,5.9498584482580048,null,5.9498584482580048]
[92,8.7935029999999997E-2,92,8.7935029999999997E-2,null,5.4773982753536643,0.91206496999999997,5.4773982753536634,null,5.4773982753536643,null,5.4773982753536643]
[93,9.874223E-2,93,9.874223E-2,null,5.0072597798167138,0.90125776999999996,5.0072597798167138,null,5.0072597798167138,null,5.0072597798167138]
[94,0.11076782,94,0.11076782,null,4.5352230088546683,0.88923218000000004,4.5352230088546683,null,4.5352230088546683,null,4.5352230088546683]
[95,0.12412578,95,0.12412578,null,4.055102312010078,0.87587422000000004,4.055102312010078,null,4.055102312010078,null,4.055102312010078]
[96,0.13893554,96,0.13893554,null,3.5578217592136454,0.86106446000000003,3.5578217592136454,null,3.5578217592136454,null,3.5578217592136454]
[97,0.15532096000000001,97,0.15532096000000001,null,3.0299452777297513,0.84467903999999994,3.0299452777297513,null,3.0299452777297513,null,3.0299452777297513]
[98,0.17340896,98,0.17340896,null,2.4512792258753651,0.82659104000000005,2.4512792258753651,null,2.4512792258753651,null,2.4512792258753651]
[99,0.19332775999999999,99,0.19332775999999999,null,1.790855137254902,0.80667224000000004,{"$f":"1+H66*G65*$E$3","v":1.790855137254902},null,1.790855137254902,null,1.790855137254902]
["100+",1,100,1,null,1,null,1,null,1,null,1]