{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["使用例","コード"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"使用例","index":0,"n_rows":132,"n_cols":13,"rows_kept":132}
["生命保険数理の計算で便利な関数のマクロ"]
[]
[]
["マクロ名","機能",{"$nulls":6},"使用例",null,null,"マクロでの計算例","VLOOKUPでの計算例"]
["LPV","縦に並んだ計算基数 Dx, Nx (x=0,1,2,…)に対して、x歳n年の期始払有期生命年金現価を計算する。",{"$nulls":6},"期始払有期年金現価（年払）",null,null,{"$f":"LPV($C$22:$C$132,$D$22:$D$132,$K$23,$K$24)","v":{"v":9.747244513974909,"d":"9.747245"}},{"$f":"(VLOOKUP($K$23,$A$22:$H$132,4,FALSE)-VLOOKUP($K$23+$K$24,$A$22:$H$132,4,FALSE))/VLOOKUP($K$23,$A$22:$H$132,3,FALSE)","v":{"v":9.747244513974909,"d":"9.747245"}}]
[null,"年間の分割支払の回数kを指定できる。",{"$nulls":6},"期始払有期年金現価（月払）",null,null,{"$f":"LPV($C$22:$C$132,$D$22:$D$132,$K$23,$K$24,12)","v":{"v":9.721422253116307,"d":"9.721422"}},{"$f":"(VLOOKUP($K$23,$A$22:$H$132,4,FALSE)-VLOOKUP($K$23+$K$24,$A$22:$H$132,4,FALSE))/VLOOKUP($K$23,$A$22:$H$132,3,FALSE)-11/24*(1-VLOOKUP($K$23+$K$24,$A$22:$H$132,3,FALSE)/VLOOKUP($K$23,$A$22:$H$132,3,FALSE))","v":{"v":9.721422253116307,"d":"9.721422"}}]
["SPDB","縦に並んだ計算基数 Dx, Mx (x=0,1,2,…)に対して、x歳n年の定期保険等の一時払純保険料を計算する。",{"$nulls":6},"定期保険の一時払純保険料",null,null,{"$f":"SPDB($C$22:$C$132,$G$22:$G$132,$K$23,$K$24)","v":{"v":0.007865314290386696,"d":"0.007865"}},{"$f":"(VLOOKUP($K$23,$A$22:$H$132,7,FALSE)-VLOOKUP($K$23+$K$24,$A$22:$H$132,7,FALSE))/VLOOKUP($K$23,$A$22:$H$132,3,FALSE)","v":{"v":0.007865314290386696,"d":"0.007865"}}]
[null,"nを省略すると 保険期間終身となる。",{"$nulls":6},"終身保険の一時払純保険料",null,null,{"$f":"SPDB($C$22:$C$132,$G$22:$G$132,$K$23)","v":{"v":0.7749608195694158,"d":"0.774961"}},{"$f":"VLOOKUP($K$23,$A$22:$H$132,7,FALSE)/VLOOKUP($K$23,$A$22:$H$132,3,FALSE)","v":{"v":0.7749608195694158,"d":"0.774961"}}]
[null,"Mxに代えて「ΣDx × 入院発生率 ×入院日数」とすると、医療保険の一時払純保険料も計算できる。",{"$nulls":6},"1年定期保険の一時払純保険料",null,null,{"$f":"SPDB($C$22:$C$132,$F$22:$F$132,$K$23)","v":{"v":6.7830634855319037E-4,"d":"0.000678"}},{"$f":"VLOOKUP($K$23,$A$22:$H$132,6,FALSE)/VLOOKUP($K$23,$A$22:$H$132,3,FALSE)","v":{"v":6.7830634855319037E-4,"d":"0.000678"}}]
["SPLB","縦に並んだ計算基数 Dx (x=0,1,2,…)に対して、x歳n年の生存保険の一時払純保険料を計算する。",{"$nulls":6},"生存保険の一時払純保険料",null,null,{"$f":"SPLB($C$22:$C$132,$K$23,$K$24)","v":{"v":0.9436605217630487,"d":"0.943661"}},{"$f":"VLOOKUP($K$23+$K$24,$A$22:$H$132,3,FALSE)/VLOOKUP($K$23,$A$22:$H$132,3,FALSE)","v":{"v":0.9436605217630487,"d":"0.943661"}}]
["SPITDT","縦に並んだ計算基数 Dx, Mx, Rx (x=0,1,2,…)に対して、x歳n年の逓増定期保険または逓減定期保険の",{"$nulls":6},"逓増定期保険の一時払純保険料（毎年逓増）",null,null,{"$f":"SPITDT($C$22:$C$132,$G$22:$G$132,$H$22:$H$132,$K$23,$K$24,1,1)","v":{"v":0.04634178254901662,"d":"0.046342"}},{"$f":"(VLOOKUP($K$23,$A$22:$H$132,8,FALSE)-VLOOKUP($K$23+$K$24,$A$22:$H$132,8,FALSE)-$K$24*VLOOKUP($K$23+$K$24,$A$22:$H$132,7,FALSE))/VLOOKUP($K$23,$A$22:$H$132,3,FALSE)","v":{"v":0.04634178254901662,"d":"0.046342"}}]
[null,"一時払純保険料を計算する。",{"$nulls":6},"逓増定期保険の一時払純保険料（毎月逓増）",null,null,{"$f":"SPITDT($C$22:$C$132,$G$22:$G$132,$H$22:$H$132,$K$23,$K$24,1,1,12)","v":{"v":0.04273684683258938,"d":"0.042737"}},{"$f":"(VLOOKUP($K$23,$A$22:$H$132,8,FALSE)-VLOOKUP($K$23+$K$24,$A$22:$H$132,8,FALSE)-$K$24*VLOOKUP($K$23+$K$24,$A$22:$H$132,7,FALSE)-11/24*(VLOOKUP($K$23,$A$22:$H$132,7,FALSE)-VLOOKUP($K$23+$K$24,$A$22:$H$132,7,FALSE)))/VLOOKUP($K$23,$A$22:$H$132,3,FALSE)","v":{"v":0.04273684683258938,"d":"0.042737"}}]
[null,"初年度の保険金額s、毎年の保険金額の増減幅d、年間の増減の回数kを指定できる。",{"$nulls":6},"逓減定期保険の一時払純保険料（毎年逓減）",null,null,{"$f":"SPITDT($C$22:$C$132,$G$22:$G$132,$H$22:$H$132,$K$23,$K$24,$K$24,-1)","v":{"v":0.040176674645237026,"d":"0.040177"}},{"$f":"(($K$24+1)*VLOOKUP($K$23,$A$22:$H$132,7,FALSE)-VLOOKUP($K$23,$A$22:$H$132,8,FALSE)+VLOOKUP($K$23+$K$24+1,$A$22:$H$132,8,FALSE))/VLOOKUP($K$23,$A$22:$H$132,3,FALSE)","v":{"v":0.04017667464523942,"d":"0.040177"}}]
[{"$nulls":8},"逓減定期保険の一時払純保険料（毎月逓減）",null,null,{"$f":"SPITDT($C$22:$C$132,$G$22:$G$132,$H$22:$H$132,$K$23,$K$24,$K$24,-1,12)","v":{"v":0.03657173892880979,"d":"0.036572"}},{"$f":"(($K$24+1)*VLOOKUP($K$23,$A$22:$H$132,7,FALSE)-VLOOKUP($K$23,$A$22:$H$132,8,FALSE)+VLOOKUP($K$23+$K$24+1,$A$22:$H$132,8,FALSE)-11/24*(VLOOKUP($K$23,$A$22:$H$132,7,FALSE)-VLOOKUP($K$23+$K$24,$A$22:$H$132,7,FALSE)))/VLOOKUP($K$23,$A$22:$H$132,3,FALSE)","v":{"v":0.036571738928812186,"d":"0.036572"}}]
["XDIV","縦に並んだ数列 Ax, Bx (x=0,1,2,…)と特定のx,yに対して ( Bx - By ) / Ax を計算する。",{"$nulls":6},"定期保険の一時払純保険料",null,null,{"$f":"XDIV($C$22:$C$132,$G$22:$G$132,$K$23,$K$23+$K$24)","v":{"v":0.007865314290386696,"d":"0.007865"}},{"$f":"(VLOOKUP($K$23,$A$22:$H$132,7,FALSE)-VLOOKUP($K$23+$K$24,$A$22:$H$132,7,FALSE))/VLOOKUP($K$23,$A$22:$H$132,3,FALSE)","v":{"v":0.007865314290386696,"d":"0.007865"}}]
[null,"yを省略すると Bx / Ax を計算できる。",{"$nulls":6},"終身保険の一時払純保険料",null,null,{"$f":"XDIV($C$22:$C$132,$G$22:$G$132,$K$23)","v":{"v":0.7749608195694158,"d":"0.774961"}},{"$f":"VLOOKUP($K$23,$A$22:$H$132,7,FALSE)/VLOOKUP($K$23,$A$22:$H$132,3,FALSE)","v":{"v":0.7749608195694158,"d":"0.774961"}}]
[{"$nulls":8},"1年定期保険の一時払純保険料",null,null,{"$f":"XDIV($C$22:$C$132,$F$22:$F$132,$K$23)","v":{"v":6.7830634855319037E-4,"d":"0.000678"}},{"$f":"VLOOKUP($K$23,$A$22:$H$132,6,FALSE)/VLOOKUP($K$23,$A$22:$H$132,3,FALSE)","v":{"v":6.7830634855319037E-4,"d":"0.000678"}}]
["VDIV","縦に並んだ数列 Ax (x=0,1,2,…)と特定のx,yに対して Ay / Ax を計算する。",{"$nulls":6},"生存保険の一時払純保険料",null,null,{"$f":"VDIV($C$22:$C$132,$K$23,$K$23+$K$24)","v":{"v":0.9436605217630487,"d":"0.943661"}},{"$f":"VLOOKUP($K$23+$K$24,$A$22:$H$132,3,FALSE)/VLOOKUP($K$23,$A$22:$H$132,3,FALSE)","v":{"v":0.9436605217630487,"d":"0.943661"}}]
[]
[]
["年齢 x","予定死亡率 qx","Dx","Nx","Sx","Cx","Mx","Rx"]
[0,0.00081,{"v":100000,"d":"100,000"},{"$f":"C22+D23","v":{"v":6664538.882660588,"d":"6,664,539"}},{"$f":"D22+E23","v":{"v":261519185.04647952,"d":"261,519,185"}},{"$f":"C22*B22/SQRT(1+$K$26)","v":{"v":80.79825622471826,"d":"81"}},{"$f":"F22+G23","v":{"v":67009.98949728646,"d":"67,010"}},{"$f":"G22+H23","v":{"v":5376840.311812216,"d":"5,376,840"}}]
[{"$f":"A22+1","v":1},0.00056,{"$f":"C22*(1-B22)/(1+$K$26)","v":{"v":99421.8905472637,"d":"99,422"}},{"$f":"C23+D24","v":{"v":6564538.882660588,"d":"6,564,539"}},{"v":254854646.16381893,"d":"254,854,646"},{"v":55.53758785924538,"d":"56"},{"$f":"F23+G24","v":{"v":66929.19124106174,"d":"66,929"}},{"v":5309830.32231493,"d":"5,309,830"},null,"年齢 x",30]
[{"$f":"A23+1","v":2},0.00036,{"v":98871.85501348978,"d":"98,872"},{"$f":"C24+D25","v":{"v":6465116.992113325,"d":"6,465,117"}},{"v":248290107.28115833,"d":"248,290,107"},{"v":35.50521544352508,"d":"36"},{"$f":"F24+G25","v":{"v":66873.65365320249,"d":"66,874"}},{"v":5242901.131073869,"d":"5,242,901"},null,"保険期間 n",10]
[3,0.00022,{"v":98344.53845341784,"d":"98,345"},{"$f":"C25+D26","v":{"v":6366245.137099835,"d":"6,366,245"}},{"v":241824990.289045,"d":"241,824,990"},{"v":21.581910957745688,"d":"22"},{"$f":"F25+G26","v":{"v":66838.14843775897,"d":"66,838"}},{"v":5176027.477420666,"d":"5,176,027"}]
[4,0.00014,{"v":97833.73398503293,"d":"97,834"},{"$f":"C26+D27","v":{"v":6267900.598646417,"d":"6,267,901"}},{"v":235458745.15194517,"d":"235,458,745"},{"v":13.662608825087734,"d":"14"},{"$f":"F26+G27","v":{"v":66816.56652680122,"d":"66,817"}},{"v":5109189.328982907,"d":"5,109,189"},null,"予定利率 i",{"v":0.005,"d":"0.50%"}]
[5,{"v":1E-4,"d":"0.00010"},{"v":97333.37041022391,"d":"97,333"},{"$f":"C27+D28","v":{"v":6170066.864661384,"d":"6,170,067"}},{"v":229190844.55329874,"d":"229,190,845"},{"v":9.709094569902078,"d":"10"},{"$f":"F27+G28","v":{"v":66802.90391797613,"d":"66,803"}},{"v":5042372.762456106,"d":"5,042,373"}]
[6,{"v":9e-05,"d":"0.00009"},{"v":96839.43987381384,"d":"96,839"},{"$f":"C28+D29","v":{"v":6072733.494251161,"d":"6,072,733"}},{"v":223020777.68863735,"d":"223,020,778"},{"v":8.693842083980677,"d":"9"},{"$f":"F28+G29","v":{"v":66793.19482340623,"d":"66,793"}},{"v":4975569.85853813,"d":"4,975,570"}]
[7,{"v":9e-05,"d":"0.00009"},{"v":96348.97942708977,"d":"96,349"},{"$f":"C29+D30","v":{"v":5975894.054377347,"d":"5,975,894"}},{"v":216948044.19438618,"d":"216,948,044"},{"v":8.649810585266787,"d":"9"},{"$f":"F29+G30","v":{"v":66784.50098132224,"d":"66,785"}},{"v":4908776.663714724,"d":"4,908,777"}]
[8,{"v":9e-05,"d":"0.00009"},{"v":95861.00300392174,"d":"95,861"},{"$f":"C30+D31","v":{"v":5879545.074950257,"d":"5,879,545"}},{"v":210972150.14000884,"d":"210,972,150"},{"v":8.60600209185484,"d":"9"},{"$f":"F30+G31","v":{"v":66775.85117073698,"d":"66,776"}},{"v":4841992.162733401,"d":"4,841,992"}]
[9,{"v":9e-05,"d":"0.00009"},{"v":95375.49802353373,"d":"95,375"},{"$f":"C31+D32","v":{"v":5783684.071946336,"d":"5,783,684"}},{"v":205092605.0650586,"d":"205,092,605"},{"v":8.5624154742951,"d":"9"},{"$f":"F31+G32","v":{"v":66767.24516864512,"d":"66,767"}},{"v":4775216.311562664,"d":"4,775,216"}]
[10,{"v":1E-4,"d":"0.00010"},{"v":94892.45196886729,"d":"94,892"},{"$f":"C32+D33","v":{"v":5688308.573922803,"d":"5,688,309"}},{"v":199308920.99311227,"d":"199,308,921"},{"v":9.465610676509026,"d":"9"},{"$f":"F32+G33","v":{"v":66758.68275317083,"d":"66,759"}},{"v":4708449.066394019,"d":"4,708,449"}]
[11,{"v":1E-4,"d":"0.00010"},{"v":94410.90818275663,"d":"94,411"},{"$f":"C33+D34","v":{"v":5593416.121953935,"d":"5,593,416"}},{"v":193620612.41918945,"d":"193,620,612"},{"v":9.417576234270026,"d":"9"},{"$f":"F33+G34","v":{"v":66749.21714249432,"d":"66,749"}},{"v":4641690.383640848,"d":"4,641,690"}]
[12,{"v":1.1E-4,"d":"0.00011"},{"v":93931.80805167995,"d":"93,932"},{"$f":"C34+D35","v":{"v":5499005.213771178,"d":"5,499,005"}},{"v":188027196.29723552,"d":"188,027,196"},{"v":10.306764103792297,"d":"10"},{"$f":"F34+G35","v":{"v":66739.79956626006,"d":"66,740"}},{"v":4574941.166498354,"d":"4,574,941"}]
[13,0.00013,{"v":93454.20453014356,"d":"93,454"},{"$f":"C35+D36","v":{"v":5405073.405719498,"d":"5,405,073"}},{"v":182528191.08346435,"d":"182,528,191"},{"v":12.118787397252957,"d":"12"},{"$f":"F35+G36","v":{"v":66729.49280215627,"d":"66,729"}},{"v":4508201.366932094,"d":"4,508,201"}]
[14,0.00017,{"v":92977.16963537775,"d":"92,977"},{"$f":"C36+D37","v":{"v":5311619.201189355,"d":"5,311,619"}},{"v":177123117.67774487,"d":"177,123,118"},{"v":15.766751108545915,"d":"16"},{"$f":"F36+G37","v":{"v":66717.37401475901,"d":"66,717"}},{"v":4441471.874129938,"d":"4,441,472"}]
[15,0.00023,{"v":92498.86917068632,"d":"92,499"},{"$f":"C37+D38","v":{"v":5218642.031553977,"d":"5,218,642"}},{"v":171811498.4765555,"d":"171,811,498"},{"v":21.221751682746362,"d":"21"},{"$f":"F37+G38","v":{"v":66701.60726365047,"d":"66,702"}},{"v":4374754.5001151785,"d":"4,374,755"}]
[16,{"v":0.0003,"d":"0.00030"},{"v":92017.5068962956,"d":"92,018"},{"$f":"C38+D39","v":{"v":5126143.162383291,"d":"5,126,143"}},{"v":166592856.4450015,"d":"166,592,856"},{"v":27.536496664321007,"d":"28"},{"$f":"F38+G39","v":{"v":66680.38551196772,"d":"66,680"}},{"v":4308052.892851528,"d":"4,308,053"}]
[17,0.00038,{"v":91532.24044201664,"d":"91,532"},{"$f":"C39+D40","v":{"v":5034125.655486995,"d":"5,034,126"}},{"v":161466713.28261822,"d":"161,466,713"},{"v":34.695620470388896,"d":"35"},{"$f":"F39+G40","v":{"v":66652.84901530339,"d":"66,653"}},{"v":4241372.50733956,"d":"4,241,373"}]
[18,0.00046,{"v":91042.24695586934,"d":"91,042"},{"$f":"C40+D41","v":{"v":4942593.415044978,"d":"4,942,593"}},{"v":156432587.62713122,"d":"156,432,588"},{"v":41.775126006600345,"d":"42"},{"$f":"F40+G41","v":{"v":66618.153394833,"d":"66,618"}},{"v":4174719.658324257,"d":"4,174,720"}]
[19,0.00053,{"v":90547.62937539267,"d":"90,548"},{"$f":"C41+D42","v":{"v":4851551.168089109,"d":"4,851,551"}},{"v":151489994.21208623,"d":"151,489,994"},{"v":47.87071600211501,"d":"48"},{"$f":"F41+G42","v":{"v":66576.3782688264,"d":"66,576"}},{"v":4108101.504929424,"d":"4,108,102"}]
[20,0.00059,{"v":90049.39217096887,"d":"90,049"},{"$f":"C42+D43","v":{"v":4761003.538713716,"d":"4,761,004"}},{"v":146638443.0439971,"d":"146,638,443"},{"v":52.996814546801836,"d":"53"},{"$f":"F42+G43","v":{"v":66528.50755282429,"d":"66,529"}},{"v":4041525.1266605975,"d":"4,041,525"}]
[21,0.00063,{"v":89548.52042745077,"d":"89,549"},{"$f":"C43+D44","v":{"v":4670954.1465427475,"d":"4,670,954"}},{"v":141877439.5052834,"d":"141,877,440"},{"v":56.27505565143455,"d":"56"},{"$f":"F43+G44","v":{"v":66475.51073827749,"d":"66,476"}},{"v":3974996.619107773,"d":"3,974,997"}]
[22,{"v":6.6E-4,"d":"0.00066"},{"v":89046.87050704626,"d":"89,047"},{"$f":"C44+D45","v":{"v":4581405.626115297,"d":"4,581,406"}},{"v":137206485.35874063,"d":"137,206,485"},{"v":58.6245558900844,"d":"59"},{"$f":"F44+G45","v":{"v":66419.23568262605,"d":"66,419"}},{"v":3908521.1083694957,"d":"3,908,521"}]
[23,0.00068,{"v":88545.37270896678,"d":"88,545"},{"$f":"C45+D46","v":{"v":4492358.75560825,"d":"4,492,359"}},{"v":132625079.73262532,"d":"132,625,080"},{"v":60.06088844350058,"d":"60"},{"$f":"F45+G46","v":{"v":66360.61112673597,"d":"66,361"}},{"v":3842101.8726868695,"d":"3,842,102"}]
[24,0.00068,{"v":88044.93716967631,"d":"88,045"},{"$f":"C46+D47","v":{"v":4403813.382899283,"d":"4,403,813"}},{"v":128132720.97701707,"d":"128,132,721"},{"v":59.72143984015821,"d":"60"},{"$f":"F46+G47","v":{"v":66300.55023829246,"d":"66,301"}},{"v":3775741.2615601337,"d":"3,775,741"}]
[25,0.00067,{"v":87547.329962588,"d":"87,547"},{"$f":"C47+D48","v":{"v":4315768.445729607,"d":"4,315,768"}},{"v":123728907.59411779,"d":"123,728,908"},{"v":58.510616922614616,"d":"59"},{"$f":"F47+G48","v":{"v":66240.8287984523,"d":"66,241"}},{"v":3709440.711321841,"d":"3,709,441"}]
[26,0.00065,{"v":87053.40622041102,"d":"87,053"},{"$f":"C48+D49","v":{"v":4228221.115767019,"d":"4,228,221"}},{"v":119413139.14838818,"d":"119,413,139"},{"v":56.44378053913968,"d":"56"},{"$f":"F48+G49","v":{"v":66182.31818152968,"d":"66,182"}},{"v":3643199.8825233886,"d":"3,643,200"}]
[27,0.00064,{"v":86564.00149887339,"d":"86,564"},{"$f":"C49+D50","v":{"v":4141167.7095466075,"d":"4,141,168"}},{"v":115184918.03262116,"d":"115,184,918"},{"v":55.26297578621526,"d":"55"},{"$f":"F49+G50","v":{"v":66125.87440099055,"d":"66,126"}},{"v":3577017.564341859,"d":"3,577,018"}]
[28,0.00064,{"v":86078.20949046181,"d":"86,078"},{"$f":"C50+D51","v":{"v":4054603.708047734,"d":"4,054,604"}},{"v":111043750.32307455,"d":"111,043,750"},{"v":54.95284326538516,"d":"55"},{"$f":"F50+G51","v":{"v":66070.61142520433,"d":"66,071"}},{"v":3510891.6899408684,"d":"3,510,892"}]
[29,{"v":6.6E-4,"d":"0.00066"},{"v":85595.14371779893,"d":"85,595"},{"$f":"C51+D52","v":{"v":3968525.4985572724,"d":"3,968,525"}},{"v":106989146.61502682,"d":"106,989,147"},{"v":56.35209028942616,"d":"56"},{"$f":"F51+G52","v":{"v":66015.65858193894,"d":"66,016"}},{"v":3444821.078515664,"d":"3,444,821"}]
[30,0.00068,{"v":85113.08549546785,"d":"85,113"},{"$f":"C52+D53","v":{"v":3882930.3548394735,"d":"3,882,930"}},{"v":103020621.11646955,"d":"103,020,621"},{"v":57.73274623652631,"d":"58"},{"$f":"F52+G53","v":{"v":65959.30649164952,"d":"65,959"}},{"v":3378805.419933725,"d":"3,378,805"}]
[31,0.00069,{"v":84632.04835555317,"d":"84,632"},{"$f":"C53+D54","v":{"v":3797817.2693440057,"d":"3,797,817"}},{"v":99137690.76163007,"d":"99,137,691"},{"v":58.25066827431808,"d":"58"},{"$f":"F53+G54","v":{"v":65901.573745413,"d":"65,902"}},{"v":3312846.1134420754,"d":"3,312,846"}]
[32,{"v":0.0007,"d":"0.00070"},{"v":84152.88780317198,"d":"84,153"},{"$f":"C54+D55","v":{"v":3713185.2209884524,"d":"3,713,185"}},{"v":95339873.49228607,"d":"95,339,873"},{"$f":"C54*B54/SQRT(1+$K$26)","v":{"v":58.76030387085754,"d":"59"}},{"$f":"F54+G55","v":{"v":65843.32307713869,"d":"65,843"}},{"v":3246944.539696662,"d":"3,246,945"}]
[33,0.00072,{"$f":"C54*(1-B54)/(1+$K$26)","v":{"v":83675.60276787041,"d":"83,676"}},{"$f":"C55+D56","v":{"v":3629032.3331852807,"d":"3,629,032"}},{"v":91626688.27129762,"d":"91,626,688"},{"v":60.09638037507679,"d":"60"},{"$f":"F55+G56","v":{"v":65784.56277326783,"d":"65,785"}},{"v":3181101.2166195237,"d":"3,181,101"}]
[34,0.00074,{"v":83199.35953619657,"d":"83,199"},{"$f":"C56+D57","v":{"v":3545356.7304174104,"d":"3,545,357"}},{"v":87997655.93811233,"d":"87,997,656"},{"v":61.414182042693454,"d":"61"},{"$f":"F56+G57","v":{"v":65724.46639289275,"d":"65,724"}},{"v":3115316.653846256,"d":"3,115,317"}]
[35,0.00077,{"v":82724.17115436796,"d":"82,724"},{"$f":"C57+D58","v":{"v":3462157.370881214,"d":"3,462,157"}},{"v":84452299.20769492,"d":"84,452,299"},{"v":63.53896244715078,"d":"64"},{"$f":"F57+G58","v":{"v":65663.05221085006,"d":"65,663"}},{"v":3049592.187453363,"d":"3,049,592"}]
[36,0.00083,{"v":82249.22740555134,"d":"82,249"},{"$f":"C58+D59","v":{"v":3379433.199726846,"d":"3,379,433"}},{"v":80990141.8368137,"d":"80,990,142"},{"v":68.0968289464821,"d":"68"},{"$f":"F58+G59","v":{"v":65599.5132484029,"d":"65,600"}},{"v":2983929.135242513,"d":"2,983,929"}]
[37,{"v":0.0009,"d":"0.00090"},{"v":81772.10004657188,"d":"81,772"},{"$f":"C59+D60","v":{"v":3297183.9723212947,"d":"3,297,184"}},{"v":77610708.63708685,"d":"77,610,709"},{"v":73.41158990662457,"d":"73"},{"$f":"F59+G60","v":{"v":65531.41641945642,"d":"65,531"}},{"v":2918329.62199411,"d":"2,918,330"}]
[38,0.00099,{"v":81292.04493187062,"d":"81,292"},{"$f":"C60+D61","v":{"v":3215411.872274723,"d":"3,215,412"}},{"v":74313524.66476555,"d":"74,313,525"},{"v":80.2786780331139,"d":"80"},{"$f":"F60+G61","v":{"v":65458.0048295498,"d":"65,458"}},{"v":2852798.2055746536,"d":"2,852,798"}]
[39,{"v":1.09E-3,"d":"0.00109"},{"v":80807.52816655529,"d":"80,808"},{"$f":"C61+D62","v":{"v":3134119.8273428525,"d":"3,134,120"}},{"v":71098112.79249083,"d":"71,098,113"},{"v":87.86082751357216,"d":"88"},{"$f":"F61+G62","v":{"v":65377.72615151668,"d":"65,378"}},{"v":2787340.200745104,"d":"2,787,340"}]
[40,0.00118,{"v":80317.85866751616,"d":"80,318"},{"$f":"C62+D63","v":{"v":3053312.299176297,"d":"3,053,312"}},{"v":67963992.96514797,"d":"67,963,993"},{"v":94.53902037488449,"d":"95"},{"$f":"F62+G63","v":{"v":65289.86532400311,"d":"65,290"}},{"v":2721962.474593587,"d":"2,721,962"}]
[41,0.00129,{"v":79823.96377541145,"d":"79,824"},{"$f":"C63+D64","v":{"v":2972994.440508781,"d":"2,972,994"}},{"v":64910680.66597168,"d":"64,910,681"},{"v":102.71644235330663,"d":"103"},{"$f":"F63+G64","v":{"v":65195.32630362823,"d":"65,195"}},{"v":2656672.609269584,"d":"2,656,673"}]
[42,{"v":1.4E-3,"d":"0.00140"},{"v":79324.3690170559,"d":"79,324"},{"$f":"C64+D65","v":{"v":2893170.4767333698,"d":"2,893,170"}},{"v":61937686.2254629,"d":"61,937,686"},{"v":110.77751814550444,"d":"111"},{"$f":"F64+G65","v":{"v":65092.60986127493,"d":"65,093"}},{"v":2591477.282965956,"d":"2,591,477"}]
[43,0.00151,{"v":78819.21880640004,"d":"78,819"},{"$f":"C65+D66","v":{"v":2813846.107716314,"d":"2,813,846"}},{"v":59044515.74872953,"d":"59,044,516"},{"v":118.72058900238248,"d":"119"},{"$f":"F65+G66","v":{"v":64981.83234312942,"d":"64,982"}},{"v":2526384.673104681,"d":"2,526,385"}]
[44,0.00163,{"v":78308.6584935347,"d":"78,309"},{"$f":"C66+D67","v":{"v":2735026.888909914,"d":"2,735,027"}},{"v":56230669.64101321,"d":"56,230,670"},{"v":127.3251972509452,"d":"127"},{"$f":"F66+G67","v":{"v":64863.111754127036,"d":"64,863"}},{"v":2461402.8407615516,"d":"2,461,403"}]
[45,0.00177,{"v":77792.05510466693,"d":"77,792"},{"$f":"C67+D68","v":{"v":2656718.2304163794,"d":"2,656,718"}},{"v":53495642.7521033,"d":"53,495,643"},{"v":137.34899319817134,"d":"137"},{"$f":"F67+G68","v":{"v":64735.78655687609,"d":"64,736"}},{"v":2396539.729007425,"d":"2,396,540"}]
[46,0.00194,{"v":77268.02305187231,"d":"77,268"},{"$f":"C68+D69","v":{"v":2578926.1753117125,"d":"2,578,926"}},{"v":50838924.52168692,"d":"50,838,925"},{"v":149.52661429103551,"d":"150"},{"$f":"F68+G69","v":{"v":64598.437563677915,"d":"64,598"}},{"v":2331803.9424505485,"d":"2,331,804"}]
[47,{"v":2.14E-3,"d":"0.00214"},{"v":76734.45083298675,"d":"76,734"},{"$f":"C69+D70","v":{"v":2501658.15225984,"d":"2,501,658"}},{"v":48259998.346375205,"d":"48,259,998"},{"v":163.80272856897233,"d":"164"},{"$f":"F69+G70","v":{"v":64448.91094938688,"d":"64,449"}},{"v":2267205.5048868707,"d":"2,267,206"}]
[48,0.00236,{"v":76189.29264497927,"d":"76,189"},{"$f":"C70+D71","v":{"v":2424923.7014268534,"d":"2,424,924"}},{"v":45758340.19411536,"d":"45,758,340"},{"v":179.3588925105361,"d":"179"},{"$f":"F70+G71","v":{"v":64285.10822081791,"d":"64,285"}},{"v":2202756.593937484,"d":"2,202,757"}]
[49,0.00259,{"v":75631.32926799713,"d":"75,631"},{"$f":"C71+D72","v":{"v":2348734.408781874,"d":"2,348,734"}},{"v":43333416.49268851,"d":"43,333,416"},{"v":195.3972587518792,"d":"195"},{"$f":"F71+G72","v":{"v":64105.74932830737,"d":"64,106"}},{"v":2138471.485716666,"d":"2,138,471"}]
[50,0.00285,{"v":75060.14340815227,"d":"75,060"},{"$f":"C72+D73","v":{"v":2273103.0795138767,"d":"2,273,103"}},{"v":40984682.083906636,"d":"40,984,682"},{"v":213.38860238474766,"d":"213"},{"$f":"F72+G73","v":{"v":63910.35206955549,"d":"63,910"}},{"v":2074365.7363883585,"d":"2,074,366"}]
[51,0.00311,{"v":74473.85273576024,"d":"74,474"},{"$f":"C73+D74","v":{"v":2198042.9361057244,"d":"2,198,043"}},{"v":38711579.00439276,"d":"38,711,579"},{"v":231.0368101734583,"d":"231"},{"$f":"F73+G74","v":{"v":63696.963467170746,"d":"63,697"}},{"v":2010455.384318803,"d":"2,010,455"}]
[52,0.00337,{"v":73872.87468035029,"d":"73,873"},{"$f":"C74+D75","v":{"v":2123569.0833699643,"d":"2,123,569"}},{"v":36513536.06828704,"d":"36,513,536"},{"v":248.33153294241643,"d":"248"},{"$f":"F74+G75","v":{"v":63465.92665699729,"d":"63,466"}},{"v":1946758.4208516323,"d":"1,946,758"}]
[{"$f":"A74+1","v":53},{"v":3.64E-3,"d":"0.00364"},{"v":73257.63491808707,"d":"73,258"},{"$f":"C75+D76","v":{"v":2049696.208689614,"d":"2,049,696"}},{"v":34389966.984917074,"d":"34,389,967"},{"v":265.9936361699212,"d":"266"},{"$f":"F75+G76","v":{"v":63217.595124054875,"d":"63,218"}},{"v":1883292.494194635,"d":"1,883,292"}]
[54,0.00391,{"v":72627.83793729875,"d":"72,628"},{"$f":"C76+D77","v":{"v":1976438.5737715268,"d":"1,976,439"}},{"v":32340270.77622746,"d":"32,340,271"},{"v":283.2675604387315,"d":"283"},{"$f":"F76+G77","v":{"v":62951.60148788495,"d":"62,952"}},{"v":1820074.89907058,"d":"1,820,075"}]
[55,0.00422,{"v":71983.94337409346,"d":"71,984"},{"$f":"C77+D78","v":{"v":1903810.735834228,"d":"1,903,811"}},{"v":30363832.202455934,"d":"30,363,832"},{"v":303.01564648641596,"d":"303"},{"$f":"F77+G78","v":{"v":62668.33392744622,"d":"62,668"}},{"v":1757123.297582695,"d":"1,757,123"}]
[{"$f":"A77+1","v":56},0.00458,{"v":71323.55336622367,"d":"71,324"},{"$f":"C78+D79","v":{"v":1831826.7924601347,"d":"1,831,827"}},{"v":28460021.466621704,"d":"28,460,021"},{"v":325.84826948168023,"d":"326"},{"$f":"F78+G79","v":{"v":62365.3182809598,"d":"62,365"}},{"v":1694454.9636552488,"d":"1,694,455"}]
[{"$f":"A78+1","v":57},{"v":0.005,"d":"0.00500"},{"v":70643.67312617549,"d":"70,644"},{"$f":"C79+D80","v":{"v":1760503.2390939111,"d":"1,760,503"}},{"v":26628194.67416157,"d":"26,628,195"},{"v":352.3386174014797,"d":"352"},{"$f":"F79+G80","v":{"v":62039.47001147812,"d":"62,039"}},{"v":1632089.645374289,"d":"1,632,090"}]
[58,0.00546,{"v":69940.75100551704,"d":"69,941"},{"$f":"C80+D81","v":{"v":1689859.5659677356,"d":"1,689,860"}},{"v":24867691.435067657,"d":"24,867,691"},{"v":380.9253744790088,"d":"381"},{"$f":"F80+G81","v":{"v":61687.13139407664,"d":"61,687"}},{"v":1570050.175362811,"d":"1,570,050"}]
[59,0.00597,{"v":69212.81045276311,"d":"69,213"},{"$f":"C81+D82","v":{"v":1619918.8149622185,"d":"1,619,919"}},{"v":23177831.869099922,"d":"23,177,832"},{"v":412.17133489112854,"d":"412"},{"$f":"F81+G82","v":{"v":61306.20601959763,"d":"61,306"}},{"v":1508363.0439687343,"d":"1,508,363"}]
[60,0.00653,{"v":68457.32335757226,"d":"68,457"},{"$f":"C82+D83","v":{"v":1550706.0045094555,"d":"1,550,706"}},{"v":21557913.054137703,"d":"21,557,913"},{"v":445.912929206987,"d":"446"},{"$f":"F82+G83","v":{"v":60894.0346847065,"d":"60,894"}},{"v":1447056.8379491367,"d":"1,447,057"}]
[61,0.00716,{"v":67671.93734930082,"d":"67,672"},{"$f":"C83+D84","v":{"v":1482248.6811518832,"d":"1,482,249"}},{"v":20007207.049628247,"d":"20,007,207"},{"v":483.3242673766756,"d":"483"},{"$f":"F83+G84","v":{"v":60448.12175549952,"d":"60,448"}},{"v":1386162.8032644303,"d":"1,386,163"}]
[62,0.00785,{"v":66853.14057500481,"d":"66,853"},{"$f":"C84+D85","v":{"v":1414576.7438025824,"d":"1,414,577"}},{"v":18524958.368476365,"d":"18,524,958"},{"v":523.4900601927139,"d":"523"},{"$f":"F84+G85","v":{"v":59964.797488122844,"d":"59,965"}},{"v":1325714.6815089306,"d":"1,325,715"}]
[63,0.00858,{"v":65998.35166317516,"d":"65,998"},{"$f":"C85+D86","v":{"v":1347723.6032275776,"d":"1,347,724"}},{"v":17110381.624673784,"d":"17,110,382"},{"v":564.8554793458602,"d":"565"},{"$f":"F85+G86","v":{"v":59441.30742793013,"d":"59,441"}},{"v":1265749.8840208077,"d":"1,265,750"}]
[64,0.00935,{"v":65106.55304070161,"d":"65,107"},{"$f":"C86+D87","v":{"v":1281725.2515644026,"d":"1,281,725"}},{"v":15762658.021446206,"d":"15,762,658"},{"$f":"C86*B86/SQRT(1+$K$26)","v":{"v":607.2300885739403,"d":"607"}},{"$f":"F86+G87","v":{"v":58876.45194858427,"d":"58,876"}},{"v":1206308.5765928775,"d":"1,206,309"}]
[65,0.01015,{"$f":"C86*(1-B86)/(1+$K$26)","v":{"v":64176.92215897618,"d":"64,177"}},{"$f":"C87+D88","v":{"v":1216618.698523701,"d":"1,216,619"}},{"v":14480932.769881804,"d":"14,480,933"},{"v":649.7733520147503,"d":"650"},{"$f":"F87+G88","v":{"v":58269.22186001033,"d":"58,269"}},{"v":1147432.1246442932,"d":"1,147,432"}]
[66,{"v":0.011,"d":"0.01100"},{"v":63209.47900404237,"d":"63,209"},{"$f":"C88+D89","v":{"v":1152441.7763647249,"d":"1,152,442"}},{"v":13264314.071358103,"d":"13,264,314"},{"v":693.5724998073482,"d":"694"},{"$f":"F88+G89","v":{"v":57619.44850799558,"d":"57,619"}},{"v":1089162.9027842828,"d":"1,089,163"}]
[67,{"v":0.0119,"d":"0.01190"},{"v":62203.15894029643,"d":"62,203"},{"$f":"C89+D90","v":{"v":1089232.2973606824,"d":"1,089,232"}},{"v":12111872.294993378,"d":"12,111,872"},{"v":738.3739581621587,"d":"738"},{"$f":"F89+G90","v":{"v":56925.87600818823,"d":"56,926"}},{"v":1031543.4542762871,"d":"1,031,543"}]
[68,0.01292,{"v":61157.155571051655,"d":"61,157"},{"$f":"C90+D91","v":{"v":1027029.1384203859,"d":"1,027,029"}},{"v":11022639.997632695,"d":"11,022,640"},{"v":788.1824507826896,"d":"788"},{"$f":"F90+G91","v":{"v":56187.50205002607,"d":"56,188"}},{"v":974617.5782680989,"d":"974,618"}]
[69,0.01408,{"v":60066.67176226236,"d":"60,067"},{"$f":"C91+D92","v":{"v":965871.9828493343,"d":"965,872"}},{"v":9995610.85921231,"d":"9,995,611"},{"v":843.6322874745136,"d":"844"},{"$f":"F91+G92","v":{"v":55399.31959924338,"d":"55,399"}},{"v":918430.0762180728,"d":"918,430"}]
[70,0.01544,{"v":58926.30151626837,"d":"58,926"},{"$f":"C92+D93","v":{"v":905805.3110870719,"d":"905,805"}},{"v":9029738.876362976,"d":"9,029,739"},{"v":907.5560343696653,"d":"908"},{"$f":"F92+G93","v":{"v":54555.68731176887,"d":"54,556"}},{"v":863030.7566188294,"d":"863,031"}]
[71,0.01702,{"v":57727.84021975841,"d":"57,728"},{"$f":"C93+D94","v":{"v":846879.0095708035,"d":"846,879"}},{"v":8123933.565275903,"d":"8,123,934"},{"v":980.080693924609,"d":"980"},{"$f":"F93+G94","v":{"v":53648.1312773992,"d":"53,648"}},{"v":808475.0693070606,"d":"808,475"}]
[72,0.01886,{"v":56462.99739225684,"d":"56,463"},{"$f":"C94+D95","v":{"v":789151.169351045,"d":"789,151"}},{"v":7277054.555705099,"d":"7,277,055"},{"v":1062.2398424384696,"d":"1,062"},{"$f":"F94+G95","v":{"v":52668.05058347459,"d":"52,668"}},{"v":754826.9380296613,"d":"754,827"}]
[73,0.02099,{"v":55122.492797451625,"d":"55,122"},{"$f":"C95+D96","v":{"v":732688.1719587882,"d":"732,688"}},{"v":6487903.386354054,"d":"6,487,903"},{"v":1154.139373082709,"d":"1,154"},{"$f":"F95+G96","v":{"v":51605.810741036126,"d":"51,606"}},{"v":702158.8874461867,"d":"702,159"}]
[74,0.02346,{"v":53696.986739933454,"d":"53,697"},{"$f":"C96+D97","v":{"v":677565.6791613365,"d":"677,566"}},{"v":5755215.214395266,"d":"5,755,215"},{"v":1256.5937416336305,"d":"1,257"},{"$f":"F96+G97","v":{"v":50451.671367953415,"d":"50,452"}},{"v":650553.0767051507,"d":"650,553"}]
[75,0.02637,{"v":52176.37356319863,"d":"52,176"},{"$f":"C97+D98","v":{"v":623868.692421403,"d":"623,869"}},{"v":5077649.53523393,"d":"5,077,650"},{"v":1372.464088900589,"d":"1,372"},{"$f":"F97+G98","v":{"v":49195.077626319784,"d":"49,195"}},{"v":600101.4053371972,"d":"600,101"}]
[76,0.02978,{"v":50547.74387297223,"d":"50,548"},{"$f":"C98+D99","v":{"v":571692.3188582044,"d":"571,692"}},{"v":4453780.842812527,"d":"4,453,781"},{"v":1501.562586758873,"d":"1,502"},{"$f":"F98+G99","v":{"v":47822.613537419194,"d":"47,823"}},{"v":550906.3277108774,"d":"550,906"}]
[77,0.03381,{"v":48798.439861129475,"d":"48,798"},{"$f":"C99+D100","v":{"v":521144.5749852322,"d":"521,145"}},{"v":3882088.523954323,"d":"3,882,089"},{"v":1645.7659669884565,"d":"1,646"},{"$f":"F99+G100","v":{"v":46321.05095066032,"d":"46,321"}},{"v":503083.7141734582,"d":"503,084"}]
[78,0.03853,{"v":46913.99463624347,"d":"46,914"},{"$f":"C100+D101","v":{"v":472346.1351241027,"d":"472,346"}},{"v":3360943.948969091,"d":"3,360,944"},{"v":1803.0940987139295,"d":"1,803"},{"$f":"F100+G101","v":{"v":44675.28498367186,"d":"44,675"}},{"v":456762.6632227979,"d":"456,763"}]
[79,0.04396,{"v":44881.98848050649,"d":"44,882"},{"$f":"C101+D102","v":{"v":425432.1404878592,"d":"425,432"}},{"v":2888597.813844988,"d":"2,888,598"},{"v":1968.0981033234448,"d":"1,968"},{"$f":"F101+G102","v":{"v":42872.19088495793,"d":"42,872"}},{"v":412087.37823912606,"d":"412,087"}]
[80,0.05006,{"v":42695.498773038235,"d":"42,695"},{"$f":"C102+D103","v":{"v":380550.15200735274,"d":"380,550"}},{"v":2463165.673357129,"d":"2,463,166"},{"v":2132.013281312034,"d":"2,132"},{"$f":"F102+G103","v":{"v":40904.092781634485,"d":"40,904"}},{"v":369215.18735416816,"d":"369,215"}]
[81,0.05673,{"v":40356.38020344273,"d":"40,356"},{"$f":"C103+D104","v":{"v":337854.6532343145,"d":"337,855"}},{"v":2082615.5213497765,"d":"2,082,616"},{"v":2283.715279566673,"d":"2,284"},{"$f":"F103+G104","v":{"v":38772.07950032245,"d":"38,772"}},{"v":328311.0945725337,"d":"328,311"}]
[82,0.06402,{"v":37877.574880100925,"d":"37,878"},{"$f":"C104+D105","v":{"v":297498.2730308718,"d":"297,498"}},{"v":1744760.8681154621,"d":"1,744,761"},{"v":2418.8826773005044,"d":"2,419"},{"$f":"F104+G105","v":{"v":36488.36422075578,"d":"36,488"}},{"v":289539.0150722112,"d":"289,539"}]
[83,0.07235,{"v":35276.27118037499,"d":"35,276"},{"$f":"C105+D106","v":{"v":259620.69815077088,"d":"259,621"}},{"v":1447262.5950845904,"d":"1,447,263"},{"v":2545.881452321106,"d":"2,546"},{"$f":"F105+G106","v":{"v":34069.48154345527,"d":"34,069"}},{"v":253050.65085145543,"d":"253,051"}]
[84,0.08177,{"v":32561.226826343147,"d":"32,561"},{"$f":"C106+D107","v":{"v":224344.4269703959,"d":"224,344"}},{"v":1187641.8969338194,"d":"1,187,642"},{"v":2655.9000464769283,"d":"2,656"},{"$f":"F106+G107","v":{"v":31523.60009113417,"d":"31,524"}},{"v":218981.16930800016,"d":"218,981"}]
[85,0.09175,{"v":29749.945580848827,"d":"29,750"},{"$f":"C107+D108","v":{"v":191783.20014405274,"d":"191,783"}},{"v":963297.4699634236,"d":"963,297"},{"v":2722.7590967179485,"d":"2,723"},{"$f":"F107+G108","v":{"v":28867.700044657242,"d":"28,868"}},{"v":187457.569216866,"d":"187,458"}]
[86,0.10269,{"v":26885.95828239398,"d":"26,886"},{"$f":"C108+D109","v":{"v":162033.2545632039,"d":"162,033"}},{"v":771514.2698193708,"d":"771,514"},{"v":2754.0425346164634,"d":"2,754"},{"$f":"F108+G109","v":{"v":26144.940947939293,"d":"26,145"}},{"v":158589.86917220874,"d":"158,590"}]
[87,0.11466,{"v":24005.014155596964,"d":"24,005"},{"$f":"C109+D110","v":{"v":135147.2962808099,"d":"135,147"}},{"v":609481.0152561669,"d":"609,481"},{"v":2745.5595826150184,"d":"2,746"},{"$f":"F109+G110","v":{"v":23390.89841332283,"d":"23,391"}},{"v":132444.92822426945,"d":"132,445"}]
[88,0.12775,{"v":21146.864907976335,"d":"21,147"},{"$f":"C110+D111","v":{"v":111142.28212521295,"d":"111,142"}},{"v":474333.718975357,"d":"474,334"},{"v":2694.7834336207206,"d":"2,695"},{"$f":"F110+G111","v":{"v":20645.33883070781,"d":"20,645"}},{"v":109054.02981094662,"d":"109,054"}]
[89,0.14204,{"v":18353.584991027223,"d":"18,354"},{"$f":"C111+D112","v":{"v":89995.41721723662,"d":"89,995"}},{"v":363191.43685014406,"d":"363,191"},{"v":2600.4501927976144,"d":"2,600"},{"$f":"F111+G112","v":{"v":17950.55539708709,"d":"17,951"}},{"v":88408.69098023881,"d":"88,409"}]
[90,{"v":0.1576,"d":"0.15760"},{"v":15668.300277514149,"d":"15,668"},{"$f":"C112+D113","v":{"v":71641.8322262094,"d":"71,642"}},{"v":273196.01963290747,"d":"273,196"},{"v":2463.1738673026884,"d":"2,463"},{"$f":"F112+G113","v":{"v":15350.105204289475,"d":"15,350"}},{"v":70458.13558315173,"d":"70,458"}]
[91,0.17453,{"v":13133.309605749175,"d":"13,133"},{"$f":"C113+D114","v":{"v":55973.53194869525,"d":"55,974"}},{"v":201554.1874066981,"d":"201,554"},{"v":2286.4475339977084,"d":"2,286"},{"$f":"F113+G114","v":{"v":12886.931336986787,"d":"12,887"}},{"v":55108.030378862255,"d":"55,108"}]
[92,{"v":0.1929,"d":"0.19290"},{"v":10787.216995281367,"d":"10,787"},{"$f":"C114+D115","v":{"v":42840.22234294607,"d":"42,840"}},{"v":145580.65545800285,"d":"145,581"},{"v":2075.671450072192,"d":"2,076"},{"$f":"F114+G115","v":{"v":10600.483802989078,"d":"10,600"}},{"v":42221.099041875466,"d":"42,221"}]
[93,0.21279,{"v":8663.047598897108,"d":"8,663"},{"$f":"C115+D116","v":{"v":32053.005347664704,"d":"32,053"}},{"v":102740.43311505677,"d":"102,740"},{"v":1838.818584096117,"d":"1,839"},{"$f":"F115+G116","v":{"v":8524.812352916886,"d":"8,525"}},{"v":31620.615238886392,"d":"31,621"}]
[94,0.23426,{"v":6785.709154555017,"d":"6,786"},{"$f":"C116+D117","v":{"v":23389.957748767596,"d":"23,390"}},{"v":70687.42776739207,"d":"70,687"},{"v":1585.6610168452237,"d":"1,586"},{"$f":"F116+G117","v":{"v":6685.993768820769,"d":"6,686"}},{"v":23095.802885969508,"d":"23,096"}]
[95,0.25739,{"v":5170.237739312397,"d":"5,170"},{"$f":"C117+D118","v":{"v":16604.24859421258,"d":"16,604"}},{"v":47297.47001862447,"d":"47,297"},{"v":1327.452997180851,"d":"1,327"},{"$f":"F117+G118","v":{"v":5100.332751975546,"d":"5,100"}},{"v":16409.80911714874,"d":"16,410"}]
[96,0.28222,{"v":3820.368405562965,"d":"3,820"},{"$f":"C118+D119","v":{"v":11434.010854900182,"d":"11,434"}},{"v":30693.221424411895,"d":"30,693"},{"$f":"C118*B118/SQRT(1+$K$26)","v":{"v":1075.498976534775,"d":"1,075"}},{"$f":"F118+G119","v":{"v":3772.8797547946942,"d":"3,773"}},{"v":11309.476365173196,"d":"11,309"}]
[97,0.30878,{"$f":"C118*(1-B118)/(1+$K$26)","v":{"v":2728.5413275074484,"d":"2,729"}},{"$f":"C119+D120","v":{"v":7613.642449337216,"d":"7,614"}},{"v":19259.210569511713,"d":"19,259"},{"v":840.4205594779643,"d":"840"},{"$f":"F119+G120","v":{"v":2697.380778259919,"d":"2,697"}},{"v":7536.596610378501,"d":"7,537"}]
[98,0.33708,{"v":1876.6391406962175,"d":"1,877"},{"$f":"C120+D121","v":{"v":4885.101121829767,"d":"4,885"}},{"v":11645.5681201745,"d":"11,646"},{"v":631.0019835538435,"d":"631"},{"$f":"F120+G121","v":{"v":1856.9602187819548,"d":"1,857"}},{"v":4839.2158321185825,"d":"4,839"}]
[99,{"v":0.3671,"d":"0.36710"},{"v":1237.8722578610314,"d":"1,238"},{"$f":"C121+D122","v":{"v":3008.4619811335497,"d":"3,008"}},{"v":6760.466998344731,"d":"6,760"},{"v":453.2910911372926,"d":"453"},{"$f":"F121+G122","v":{"v":1225.9582352281113,"d":"1,226"}},{"v":2982.255613336628,"d":"2,982"}]
[100,0.39881,{"v":779.5515940300963,"d":"780"},{"$f":"C122+D123","v":{"v":1770.5897232725185,"d":"1,771"}},{"v":3752.0050172111814,"d":"3,752"},{"v":310.11864131734643,"d":"310"},{"$f":"F122+G123","v":{"v":772.6671440908187,"d":"773"}},{"v":1756.2973781085163,"d":"1,756"}]
[101,{"v":0.4321,"d":"0.43210"},{"v":466.3269878755758,"d":"466"},{"$f":"C123+D124","v":{"v":991.0381292424222,"d":"991"}},{"v":1981.415293938663,"d":"1,981"},{"v":200.9980229570584,"d":"201"},{"$f":"F123+G124","v":{"v":462.54850277347225,"d":"463"}},{"v":983.6302340176976,"d":"984"}]
[102,0.46686,{"v":263.50954867118367,"d":"264"},{"$f":"C124+D125","v":{"v":524.7111413668464,"d":"525"}},{"v":990.3771646962407,"d":"990"},{"v":122.7156612701643,"d":"123"},{"$f":"F124+G125","v":{"v":261.5504798164138,"d":"262"}},{"v":521.0817312442254,"d":"521"}]
[103,0.50292,{"v":139.78853808811428,"d":"140"},{"$f":"C125+D126","v":{"v":261.2015926956627,"d":"261"}},{"v":465.66602332939425,"d":"466"},{"v":70.127351797591,"d":"70"},{"$f":"F125+G126","v":{"v":138.83481854624955,"d":"139"}},{"v":259.5312514278115,"d":"260"}]
[104,0.54006,{"v":69.1403845898904,"d":"69"},{"$f":"C126+D127","v":{"v":121.41305460754846,"d":"121"}},{"v":204.46443063373152,"d":"204"},{"v":37.24695482121134,"d":"37"},{"$f":"F126+G127","v":{"v":68.70746674865856,"d":"69"}},{"v":120.69643288156195,"d":"121"}]
[105,{"v":0.578,"d":"0.57800"},{"v":31.642217401267857,"d":"32"},{"$f":"C127+D128","v":{"v":52.27267001765806,"d":"52"}},{"v":83.05137602618305,"d":"83"},{"v":18.243649403743188,"d":"18"},{"$f":"F127+G128","v":{"v":31.460511927447218,"d":"31"}},{"v":51.988966132903386,"d":"52"}]
[106,0.61642,{"v":13.286582829189094,"d":"13"},{"$f":"C128+D129","v":{"v":20.630452616390198,"d":"21"}},{"v":30.778706008525,"d":"31"},{"v":8.169716562898603,"d":"8"},{"$f":"F128+G129","v":{"v":13.21686252370403,"d":"13"}},{"v":20.528454205456164,"d":"21"}]
[107,0.65494,{"v":5.0711118822093075,"d":"5"},{"$f":"C129+D130","v":{"v":7.343869787201103,"d":"7"}},{"v":10.1482533921348,"d":"10"},{"v":3.3130018388655214,"d":"3"},{"$f":"F129+G130","v":{"v":5.047145960805427,"d":"5"}},{"v":7.311591681752134,"d":"7"}]
[108,0.69314,{"$f":"C129*(1-B129)/(1+$K$26)","v":{"v":1.7411322050498945,"d":"2"}},{"$f":"C130+D131","v":{"v":2.2727579049917956,"d":"2"}},{"$f":"D130+E131","v":{"v":2.804383604933697,"d":"3"}},{"$f":"C130*B130/SQRT(1+$K$26)","v":{"v":1.2038425229331038,"d":"1"}},{"$f":"F130+G131","v":{"v":1.7341441219399054,"d":"2"}},{"$f":"G130+H131","v":{"v":2.264445720946707,"d":"2"}}]
[109,{"v":1,"d":"1.00000"},{"v":0.5316256999419012,"d":"1"},{"v":0.5316256999419012,"d":"1"},{"v":0.5316256999419012,"d":"1"},{"v":0.5303015990068015,"d":"1"},{"v":0.5303015990068015,"d":"1"},{"v":0.5303015990068015,"d":"1"}]
[110,{"v":1,"d":"1.00000"},0,0,0,0,0,0]

{"sheet":"コード","index":1,"n_rows":67,"n_cols":1,"rows_kept":67}
["'生命保険数理で便利な関数のマクロ"]
[]
["'縦に並んだ計算基数 Dx, Nx (x=0,1,2,…)に対して、x歳n年の期始払有期生命年金現価を計算する。年間の分割支払の回数kを指定できる。"]
["Function LPV(Dx As Range, Nx As Range, x As Integer, n As Integer, Optional k As Integer = 1)"]
["  If Not Dx.Cells(x + 1, 1) = 0 Then"]
["      LPV = (Nx.Cells(x + 1, 1) - Nx.Cells(x + n + 1, 1)) / Dx.Cells(x + 1, 1)"]
["    If Not k = 1 Then"]
["      LPV = LPV - ((k - 1) / (2 * k)) * (1 - Dx.Cells(x + n + 1, 1) / Dx.Cells(x + 1, 1))"]
["    Else: End If"]
["  Else: LPV = 0"]
["  End If"]
["End Function"]
[]
["'縦に並んだ計算基数 Dx, Mx (x=0,1,2,…)に対して、x歳n年の定期保険等の一時払純保険料を計算する。nを省略すると 保険期間終身となる。Mxに代えて「ΣDx × 入院発生率 ×入院日数」とすると、医療保険の一時払純保険料も計算できる。"]
["Function SPDB(Dx As Range, MX As Range, x As Integer, Optional n As Integer = -1)"]
["  If Not Dx.Cells(x + 1, 1) = 0 Then"]
["    If n < 0 Then"]
["      SPDB = MX.Cells(x + 1, 1) / Dx.Cells(x + 1, 1)"]
["    Else:"]
["      SPDB = (MX.Cells(x + 1, 1) - MX.Cells(x + n + 1, 1)) / Dx.Cells(x + 1, 1)"]
["    End If"]
["  Else: SPDB = 0"]
["  End If"]
["End Function"]
[]
["'縦に並んだ計算基数 Dx (x=0,1,2,…)に対して、x歳n年の生存保険の一時払純保険料を計算する。"]
["Function SPLB(Dx As Range, x As Integer, n As Integer)"]
["  If Not Dx.Cells(x + 1, 1) = 0 Then"]
["    SPLB = Dx.Cells(x + n + 1, 1) / Dx.Cells(x + 1, 1)"]
["  Else: SPLB = 0"]
["  End If"]
["End Function"]
[]
["'縦に並んだ計算基数 Dx, Mx, Rx (x=0,1,2,…)に対して、x歳n年の逓増定期保険または逓減定期保険の一時払純保険料を計算する。"]
["'初年度の保険金額s、毎年の保険金額の増減幅d、年間の増減の回数kを指定できる。"]
["Function SPITDT(Dx As Range, MX As Range, Rx As Range, x As Integer, n As Integer, _"]
["              Optional s As Double = 1, Optional d As Double = 0, Optional k As Integer = 1)"]
["  If Not Dx.Cells(x + 1, 1) = 0 Then"]
["      SPITDT = (s - d) * (MX.Cells(x + 1, 1) - MX.Cells(x + n + 1, 1))"]
["      SPITDT = SPITDT + d * (Rx.Cells(x + 1, 1) - Rx.Cells(x + n + 1, 1) - n * MX.Cells(x + n + 1, 1))"]
["    If Not k = 1 Then"]
["      SPITDT = SPITDT - Abs(d) * ((k - 1) / (2 * k)) * (MX.Cells(x + 1, 1) - MX.Cells(x + n + 1, 1))"]
["    Else: End If"]
["      SPITDT = SPITDT / Dx.Cells(x + 1, 1)"]
["  Else: SPITDT = 0"]
["  End If"]
["End Function"]
[]
["'縦に並んだ数列 Ax, Bx (x=0,1,2,…)と特定のx,yに対して ( Bx - By ) / Ax を計算する。yを省略すると Bx / Ax を計算できる。"]
["Function XDIV(Ai As Range, Bi As Range, x As Integer, Optional y As Integer = -1)"]
["  If Not Ai.Cells(x + 1, 1) = 0 Then"]
["    If y < 0 Then"]
["      XDIV = Bi.Cells(x + 1, 1) / Ai.Cells(x + 1, 1)"]
["    Else:"]
["      XDIV = (Bi.Cells(x + 1, 1) - Bi.Cells(y + 1, 1)) / Ai.Cells(x + 1, 1)"]
["    End If"]
["  Else: XDIV = 0"]
["  End If"]
["End Function"]
[]
["'縦に並んだ数列 Ax (x=0,1,2,…)と特定のx,yに対して Ay / Ax を計算する。"]
["Function VDIV(Ai As Range, x As Integer, y As Integer)"]
["  If Not Ai.Cells(x + 1, 1) = 0 Then"]
["    VDIV = Ai.Cells(y + 1, 1) / Ai.Cells(x + 1, 1)"]
["  Else: VDIV = 0"]
["  End If"]
["End Function"]