{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Illustration Calculator","Plan Calculations"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Illustration Calculator","index":0,"n_rows":105,"n_cols":8,"rows_kept":105,"cut":false,"hidden":false,"merged":[[10,7,10,8],[11,7,11,8],[1,1,1,9],[2,1,2,9],[4,7,4,8],[5,7,5,8],[7,7,7,8],[8,7,8,8]]}
[]
[null,"ILLUSTRATION TOOL"]
[null,"For Agent Use Only"]
[]
[null,"Plan # Selection",null,"Age","Year","Exp. Annuity Payment",null,"Total Payment"]
[null,"Plan # 7",null,{"$f":"B9","v":40},1,{"$f":"_xlfn.IFNA(IF(E6=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$G$2:$L$75, E6+1, FALSE)), \"Something is wrong\")","v":0},null,{"$f":"SUM(F6:F105)","v":180000}]
[null,null,null,{"$f":"IF(E7=\"\", \"\", D6+1)","v":41},{"$f":"IF(E6=\"\", \"\", IF($B$9+E6-1>=110, \"\", E6+1))","v":2},{"$f":"_xlfn.IFNA(IF(E7=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$G$2:$L$75, E7+1, FALSE)), \"Something is wrong\")","v":0}]
[null,"Current Age",null,{"$f":"IF(E8=\"\", \"\", D7+1)","v":42},{"$f":"IF(E7=\"\", \"\", IF($B$9+E7-1>=110, \"\", E7+1))","v":3},{"$f":"_xlfn.IFNA(IF(E8=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$G$2:$L$75, E8+1, FALSE)), \"Something is wrong\")","v":0},null,"Total Years of Payment"]
[null,40,null,43,4,{"$f":"_xlfn.IFNA(IF(E9=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$G$2:$L$75, E9+1, FALSE)), \"Something is wrong\")","v":0},null,{"$f":"COUNTIF(F6:F105, \">0\")","v":5}]
[null,null,null,44,5,{"$f":"_xlfn.IFNA(IF(E10=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$G$2:$L$75, E10+1, FALSE)), \"Something is wrong\")","v":0}]
[null,{"$f":"IF(OR(B6=\"Plan # 1\", B6=\"Plan # 3\", B6=\"Plan # 5\", B6=\"Plan # 6\", B6=\"plan # 7\"), \"Age Payments Begin\", \"\")","v":"Age Payments Begin"},null,45,6,{"$f":"_xlfn.IFNA(IF(E11=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$G$2:$L$75, E11+1, FALSE)), \"Something is wrong\")","v":0},null,"Age of Last Payment"]
[null,41,null,46,7,{"$f":"_xlfn.IFNA(IF(E12=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$G$2:$L$75, E12+1, FALSE)), \"Something is wrong\")","v":0},null,{"$f":"IF(OR(B6=\"Plan # 1\", B6=\"plan # 5\", B6=\"plan # 6\", B6=\"plan # 7\"), B12+B15-1, IF(B6=\"Plan # 2\", 94, IF(B6=\"Plan # 3\", 110, 100)))","v":50}]
[null,null,null,47,8,{"$f":"_xlfn.IFNA(IF(E13=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$G$2:$L$75, E13+1, FALSE)), \"Something is wrong\")","v":30000}]
[null,{"$f":"IF(OR(B6=\"Plan # 1\", B6=\"Plan # 5\", B6=\"Plan # 6\", B6=\"plan # 7\"), \"Years of Payment\", \"\")","v":"Years of Payment"},null,48,9,{"$f":"_xlfn.IFNA(IF(E14=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$G$2:$L$75, E14+1, FALSE)), \"Something is wrong\")","v":0}]
[null,10,null,49,10,{"$f":"_xlfn.IFNA(IF(E15=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$G$2:$L$75, E15+1, FALSE)), \"Something is wrong\")","v":30000}]
[null,null,null,50,11,{"$f":"_xlfn.IFNA(IF(E16=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$G$2:$L$75, E16+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,51,12,{"$f":"_xlfn.IFNA(IF(E17=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$G$2:$L$75, E17+1, FALSE)), \"Something is wrong\")","v":60000}]
[null,null,null,52,13,{"$f":"_xlfn.IFNA(IF(E18=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$G$2:$L$75, E18+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,53,14,{"$f":"_xlfn.IFNA(IF(E19=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$G$2:$L$75, E19+1, FALSE)), \"Something is wrong\")","v":30000}]
[null,null,null,54,15,{"$f":"_xlfn.IFNA(IF(E20=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E20+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,55,16,{"$f":"_xlfn.IFNA(IF(E21=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E21+1, FALSE)), \"Something is wrong\")","v":30000}]
[null,null,null,56,17,{"$f":"_xlfn.IFNA(IF(E22=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E22+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,57,18,{"$f":"_xlfn.IFNA(IF(E23=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E23+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,58,19,{"$f":"_xlfn.IFNA(IF(E24=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E24+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,59,20,{"$f":"_xlfn.IFNA(IF(E25=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E25+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,60,21,{"$f":"_xlfn.IFNA(IF(E26=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E26+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,61,22,{"$f":"_xlfn.IFNA(IF(E27=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E27+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,62,23,{"$f":"_xlfn.IFNA(IF(E28=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E28+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,63,24,{"$f":"_xlfn.IFNA(IF(E29=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E29+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,64,25,{"$f":"_xlfn.IFNA(IF(E30=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E30+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,65,26,{"$f":"_xlfn.IFNA(IF(E31=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E31+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,66,27,{"$f":"_xlfn.IFNA(IF(E32=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E32+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,67,28,{"$f":"_xlfn.IFNA(IF(E33=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E33+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,68,29,{"$f":"_xlfn.IFNA(IF(E34=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E34+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,69,30,{"$f":"_xlfn.IFNA(IF(E35=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E35+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,70,31,{"$f":"_xlfn.IFNA(IF(E36=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E36+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,71,32,{"$f":"_xlfn.IFNA(IF(E37=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E37+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,72,33,{"$f":"_xlfn.IFNA(IF(E38=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E38+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,73,34,{"$f":"_xlfn.IFNA(IF(E39=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E39+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,74,35,{"$f":"_xlfn.IFNA(IF(E40=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E40+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,75,36,{"$f":"_xlfn.IFNA(IF(E41=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E41+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,76,37,{"$f":"_xlfn.IFNA(IF(E42=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E42+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,77,38,{"$f":"_xlfn.IFNA(IF(E43=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E43+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,78,39,{"$f":"_xlfn.IFNA(IF(E44=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E44+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,79,40,{"$f":"_xlfn.IFNA(IF(E45=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E45+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,80,41,{"$f":"_xlfn.IFNA(IF(E46=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E46+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,81,42,{"$f":"_xlfn.IFNA(IF(E47=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E47+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,82,43,{"$f":"_xlfn.IFNA(IF(E48=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E48+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,83,44,{"$f":"_xlfn.IFNA(IF(E49=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E49+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,84,45,{"$f":"_xlfn.IFNA(IF(E50=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E50+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,85,46,{"$f":"_xlfn.IFNA(IF(E51=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E51+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,86,47,{"$f":"_xlfn.IFNA(IF(E52=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E52+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,87,48,{"$f":"_xlfn.IFNA(IF(E53=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E53+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,88,49,{"$f":"_xlfn.IFNA(IF(E54=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E54+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,89,50,{"$f":"_xlfn.IFNA(IF(E55=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E55+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,90,51,{"$f":"_xlfn.IFNA(IF(E56=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E56+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,91,52,{"$f":"_xlfn.IFNA(IF(E57=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E57+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,92,53,{"$f":"_xlfn.IFNA(IF(E58=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E58+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,93,54,{"$f":"_xlfn.IFNA(IF(E59=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E59+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,94,55,{"$f":"_xlfn.IFNA(IF(E60=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E60+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,95,56,{"$f":"_xlfn.IFNA(IF(E61=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E61+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,96,57,{"$f":"_xlfn.IFNA(IF(E62=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E62+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,97,58,{"$f":"_xlfn.IFNA(IF(E63=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E63+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,98,59,{"$f":"_xlfn.IFNA(IF(E64=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E64+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,99,60,{"$f":"_xlfn.IFNA(IF(E65=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E65+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,100,61,{"$f":"_xlfn.IFNA(IF(E66=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E66+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,101,62,{"$f":"_xlfn.IFNA(IF(E67=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E67+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,102,63,{"$f":"_xlfn.IFNA(IF(E68=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E68+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,103,64,{"$f":"_xlfn.IFNA(IF(E69=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E69+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,104,65,{"$f":"_xlfn.IFNA(IF(E70=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E70+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,105,66,{"$f":"_xlfn.IFNA(IF(E71=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E71+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,{"$f":"IF(E72=\"\", \"\", D71+1)","v":106},{"$f":"IF(E71=\"\", \"\", IF($B$9+E71-1>=110, \"\", E71+1))","v":67},{"$f":"_xlfn.IFNA(IF(E72=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E72+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,107,68,{"$f":"_xlfn.IFNA(IF(E73=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E73+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,108,69,{"$f":"_xlfn.IFNA(IF(E74=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E74+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,109,70,{"$f":"_xlfn.IFNA(IF(E75=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E75+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,110,71,{"$f":"_xlfn.IFNA(IF(E76=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E76+1, FALSE)), \"Something is wrong\")","v":0}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E77=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E77+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E78=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E78+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E79=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E79+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E80=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E80+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E81=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E81+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E82=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E82+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E83=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E83+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E84=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E84+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E85=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E85+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E86=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E86+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E87=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E87+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E88=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E88+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E89=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E89+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E90=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E90+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E91=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E91+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E92=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E92+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E93=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E93+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E94=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E94+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E95=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E95+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E96=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E96+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E97=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E97+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E98=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E98+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E99=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E99+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E100=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E100+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E101=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E101+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E102=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E102+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E103=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E103+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E104=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E104+1, FALSE)), \"Something is wrong\")","v":""}]
[null,null,null,"","",{"$f":"_xlfn.IFNA(IF(E105=\"\", \"\",HLOOKUP($B$6, 'Plan Calculations'!$F$2:$L$75, E105+1, FALSE)), \"Something is wrong\")","v":""}]

{"sheet":"Plan Calculations","index":1,"n_rows":75,"n_cols":12,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Years of Payment",null,null,null,"Plan # 1","Plan # 2","Plan # 3","Plan # 4","Plan # 5","Plan # 6","Plan # 7"]
[null,{"$f":"'Illustration Calculator'!B15","v":10},{"$f":"B6","v":40},1,"Year 1",{"$f":"IF(AND($B$6+D3-1>=$B$9, $B$6+D3-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D3-1< 95, IF($B$6+D3-1=65, 25000, IF($B$6+D3-1>65, 25000+1000*($B$6+D3-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D3-1<$B$9, $B$6+D3-1>110), 0, 600*12)","v":0},{"$f":"IF(AND($B$6+D3-1>=60, $B$6+D3-1<=100), ($B$6+D3-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D3-1>=$B$9, $B$6+D3-1<$B$9+$B$3), IF($B$6+D3-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},{"$f":"IF(AND($B$6+D3-1>=$B$9, $B$6+D3-1<($B$9+$B$3)), 100000/($B$3-1), 0)","v":0},{"$f":"IF(AND($B$6+D3-1>=$B$9,$B$6+D3-1<$B$9+$B$3),IF(AND(ISEVEN($B$6+D3-1), ISEVEN($B$9)),30000,IF(AND(ISODD($B$6+D3-1), ISODD($B$9)), 30000,0)), 0)","v":0}]
[null,null,{"$f":"C3+1","v":41},2,"Year 2",{"$f":"IF(AND($B$6+D4-1>=$B$9, $B$6+D4-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D4-1< 95, IF($B$6+D4-1=65, 25000, IF($B$6+D4-1>65, 25000+1000*($B$6+D4-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D4-1<$B$9, $B$6+D4-1>110), 0, 600*12)","v":0},{"$f":"IF(AND($B$6+D4-1>=60, $B$6+D4-1<=100), ($B$6+D4-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D4-1>=$B$9, $B$6+D4-1<$B$9+$B$3), IF($B$6+D4-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,"Current Age of Client",{"$f":"C4+1","v":42},3,"Year 3",{"$f":"IF(AND($B$6+D5-1>=$B$9, $B$6+D5-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D5-1< 95, IF($B$6+D5-1=65, 25000, IF($B$6+D5-1>65, 25000+1000*($B$6+D5-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D5-1<$B$9, $B$6+D5-1>110), 0, 600*12)","v":0},{"$f":"IF(AND($B$6+D5-1>=60, $B$6+D5-1<=100), ($B$6+D5-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D5-1>=$B$9, $B$6+D5-1<$B$9+$B$3), IF($B$6+D5-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,{"$f":"IF(AND($B$6+D5-1>=$B$9,$B$6+D5-1<$B$9+$B$3),IF(AND(ISEVEN($B$6+D5-1), ISEVEN($B$9)),30000,IF(AND(ISODD($B$6+D5-1), ISODD($B$9)), 30000,0)), 0)","v":0}]
[null,{"$f":"'Illustration Calculator'!B9","v":40},43,4,"Year 4",{"$f":"IF(AND($B$6+D6-1>=$B$9, $B$6+D6-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D6-1< 95, IF($B$6+D6-1=65, 25000, IF($B$6+D6-1>65, 25000+1000*($B$6+D6-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D6-1<$B$9, $B$6+D6-1>110), 0, 600*12)","v":0},{"$f":"IF(AND($B$6+D6-1>=60, $B$6+D6-1<=100), ($B$6+D6-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D6-1>=$B$9, $B$6+D6-1<$B$9+$B$3), IF($B$6+D6-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,{"$f":"IF(AND($B$6+D6-1>=$B$9,$B$6+D6-1<$B$9+$B$3),IF(AND(ISEVEN($B$6+D6-1), ISEVEN($B$9)),30000,IF(AND(ISODD($B$6+D6-1), ISODD($B$9)), 30000,0)), 0)","v":0}]
[null,null,44,5,"Year 5",{"$f":"IF(AND($B$6+D7-1>=$B$9, $B$6+D7-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D7-1< 95, IF($B$6+D7-1=65, 25000, IF($B$6+D7-1>65, 25000+1000*($B$6+D7-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D7-1<$B$9, $B$6+D7-1>110), 0, 600*12)","v":0},{"$f":"IF(AND($B$6+D7-1>=60, $B$6+D7-1<=100), ($B$6+D7-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D7-1>=$B$9, $B$6+D7-1<$B$9+$B$3), IF($B$6+D7-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,"Age Payments begin",45,6,"Year 6",{"$f":"IF(AND($B$6+D8-1>=$B$9, $B$6+D8-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D8-1< 95, IF($B$6+D8-1=65, 25000, IF($B$6+D8-1>65, 25000+1000*($B$6+D8-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D8-1<$B$9, $B$6+D8-1>110), 0, 600*12)","v":0},{"$f":"IF(AND($B$6+D8-1>=60, $B$6+D8-1<=100), ($B$6+D8-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D8-1>=$B$9, $B$6+D8-1<$B$9+$B$3), IF($B$6+D8-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,{"$f":"'Illustration Calculator'!B12+6","v":47},46,7,"Year 7",{"$f":"IF(AND($B$6+D9-1>=$B$9, $B$6+D9-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D9-1< 95, IF($B$6+D9-1=65, 25000, IF($B$6+D9-1>65, 25000+1000*($B$6+D9-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D9-1<$B$9, $B$6+D9-1>110), 0, 600*12)","v":0},{"$f":"IF(AND($B$6+D9-1>=60, $B$6+D9-1<=100), ($B$6+D9-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D9-1>=$B$9, $B$6+D9-1<$B$9+$B$3), IF($B$6+D9-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,47,8,"Year 8",{"$f":"IF(AND($B$6+D10-1>=$B$9, $B$6+D10-1<$B$9+$B$3), 15000, 0)","v":15000},{"$f":"IF($B$6+D10-1< 95, IF($B$6+D10-1=65, 25000, IF($B$6+D10-1>65, 25000+1000*($B$6+D10-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D10-1<$B$9, $B$6+D10-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D10-1>=60, $B$6+D10-1<=100), ($B$6+D10-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D10-1>=$B$9, $B$6+D10-1<$B$9+$B$3), IF($B$6+D10-1<($B$9+$B$3/2), 19000, 25000), 0)","v":19000},11111.111111111111,30000]
[null,null,48,9,"Year 9",{"$f":"IF(AND($B$6+D11-1>=$B$9, $B$6+D11-1<$B$9+$B$3), 15000, 0)","v":15000},{"$f":"IF($B$6+D11-1< 95, IF($B$6+D11-1=65, 25000, IF($B$6+D11-1>65, 25000+1000*($B$6+D11-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D11-1<$B$9, $B$6+D11-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D11-1>=60, $B$6+D11-1<=100), ($B$6+D11-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D11-1>=$B$9, $B$6+D11-1<$B$9+$B$3), IF($B$6+D11-1<($B$9+$B$3/2), 19000, 25000), 0)","v":19000},11111.111111111111,0]
[null,null,49,10,"Year 10",{"$f":"IF(AND($B$6+D12-1>=$B$9, $B$6+D12-1<$B$9+$B$3), 15000, 0)","v":15000},{"$f":"IF($B$6+D12-1< 95, IF($B$6+D12-1=65, 25000, IF($B$6+D12-1>65, 25000+1000*($B$6+D12-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D12-1<$B$9, $B$6+D12-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D12-1>=60, $B$6+D12-1<=100), ($B$6+D12-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D12-1>=$B$9, $B$6+D12-1<$B$9+$B$3), IF($B$6+D12-1<($B$9+$B$3/2), 19000, 25000), 0)","v":19000},11111.111111111111,30000]
[null,null,50,11,"Year 11",{"$f":"IF(AND($B$6+D13-1>=$B$9, $B$6+D13-1<$B$9+$B$3), 15000, 0)","v":15000},{"$f":"IF($B$6+D13-1< 95, IF($B$6+D13-1=65, 25000, IF($B$6+D13-1>65, 25000+1000*($B$6+D13-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D13-1<$B$9, $B$6+D13-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D13-1>=60, $B$6+D13-1<=100), ($B$6+D13-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D13-1>=$B$9, $B$6+D13-1<$B$9+$B$3), IF($B$6+D13-1<($B$9+$B$3/2), 19000, 25000), 0)","v":19000},11111.111111111111,0]
[null,null,51,12,"Year 12",{"$f":"IF(AND($B$6+D14-1>=$B$9, $B$6+D14-1<$B$9+$B$3), 15000, 0)","v":15000},{"$f":"IF($B$6+D14-1< 95, IF($B$6+D14-1=65, 25000, IF($B$6+D14-1>65, 25000+1000*($B$6+D14-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D14-1<$B$9, $B$6+D14-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D14-1>=60, $B$6+D14-1<=100), ($B$6+D14-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D14-1>=$B$9, $B$6+D14-1<$B$9+$B$3), IF($B$6+D14-1<($B$9+$B$3/2), 19000, 25000), 0)","v":19000},11111.111111111111,{"$f":"IF(AND($B$6+D14-1>=$B$9,$B$6+D14-1<$B$9+$B$3),IF(AND(ISEVEN($B$6+D14-1), ISEVEN($B$9)),30000,IF(AND(ISODD($B$6+D14-1), ISODD($B$9)), 30000*2,0)), 0)","v":60000}]
[null,null,52,13,"Year 13",{"$f":"IF(AND($B$6+D15-1>=$B$9, $B$6+D15-1<$B$9+$B$3), 15000, 0)","v":15000},{"$f":"IF($B$6+D15-1< 95, IF($B$6+D15-1=65, 25000, IF($B$6+D15-1>65, 25000+1000*($B$6+D15-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D15-1<$B$9, $B$6+D15-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D15-1>=60, $B$6+D15-1<=100), ($B$6+D15-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D15-1>=$B$9, $B$6+D15-1<$B$9+$B$3), IF($B$6+D15-1<($B$9+$B$3/2), 19000, 25000), 0)","v":25000},11111.111111111111,0]
[null,null,53,14,"Year 14",{"$f":"IF(AND($B$6+D16-1>=$B$9, $B$6+D16-1<$B$9+$B$3), 15000, 0)","v":15000},{"$f":"IF($B$6+D16-1< 95, IF($B$6+D16-1=65, 25000, IF($B$6+D16-1>65, 25000+1000*($B$6+D16-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D16-1<$B$9, $B$6+D16-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D16-1>=60, $B$6+D16-1<=100), ($B$6+D16-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D16-1>=$B$9, $B$6+D16-1<$B$9+$B$3), IF($B$6+D16-1<($B$9+$B$3/2), 19000, 25000), 0)","v":25000},11111.111111111111,30000]
[null,null,54,15,"Year 15",{"$f":"IF(AND($B$6+D17-1>=$B$9, $B$6+D17-1<$B$9+$B$3), 15000, 0)","v":15000},{"$f":"IF($B$6+D17-1< 95, IF($B$6+D17-1=65, 25000, IF($B$6+D17-1>65, 25000+1000*($B$6+D17-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D17-1<$B$9, $B$6+D17-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D17-1>=60, $B$6+D17-1<=100), ($B$6+D17-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D17-1>=$B$9, $B$6+D17-1<$B$9+$B$3), IF($B$6+D17-1<($B$9+$B$3/2), 19000, 25000), 0)","v":25000},11111.111111111111,0]
[null,null,55,16,"Year 16",{"$f":"IF(AND($B$6+D18-1>=$B$9, $B$6+D18-1<$B$9+$B$3), 15000, 0)","v":15000},{"$f":"IF($B$6+D18-1< 95, IF($B$6+D18-1=65, 25000, IF($B$6+D18-1>65, 25000+1000*($B$6+D18-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D18-1<$B$9, $B$6+D18-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D18-1>=60, $B$6+D18-1<=100), ($B$6+D18-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D18-1>=$B$9, $B$6+D18-1<$B$9+$B$3), IF($B$6+D18-1<($B$9+$B$3/2), 19000, 25000), 0)","v":25000},{"$f":"IF(AND($B$6+D18-1>=$B$9, $B$6+D18-1<($B$9+$B$3)), 100000/($B$3-1), 0)","v":11111.111111111111},30000]
[null,null,56,17,"Year 17",{"$f":"IF(AND($B$6+D19-1>=$B$9, $B$6+D19-1<$B$9+$B$3), 15000, 0)","v":15000},{"$f":"IF($B$6+D19-1< 95, IF($B$6+D19-1=65, 25000, IF($B$6+D19-1>65, 25000+1000*($B$6+D19-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D19-1<$B$9, $B$6+D19-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D19-1>=60, $B$6+D19-1<=100), ($B$6+D19-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D19-1>=$B$9, $B$6+D19-1<$B$9+$B$3), IF($B$6+D19-1<($B$9+$B$3/2), 19000, 25000), 0)","v":25000},{"$f":"IF(AND($B$6+D19-1>=$B$9, $B$6+D19-1<($B$9+$B$3)), 100000/($B$3-1), 0)","v":11111.111111111111},0]
[null,null,57,18,"Year 18",{"$f":"IF(AND($B$6+D20-1>=$B$9, $B$6+D20-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D20-1< 95, IF($B$6+D20-1=65, 25000, IF($B$6+D20-1>65, 25000+1000*($B$6+D20-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D20-1<$B$9, $B$6+D20-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D20-1>=60, $B$6+D20-1<=100), ($B$6+D20-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D20-1>=$B$9, $B$6+D20-1<$B$9+$B$3), IF($B$6+D20-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,58,19,"Year 19",{"$f":"IF(AND($B$6+D21-1>=$B$9, $B$6+D21-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D21-1< 95, IF($B$6+D21-1=65, 25000, IF($B$6+D21-1>65, 25000+1000*($B$6+D21-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D21-1<$B$9, $B$6+D21-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D21-1>=60, $B$6+D21-1<=100), ($B$6+D21-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D21-1>=$B$9, $B$6+D21-1<$B$9+$B$3), IF($B$6+D21-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,59,20,"Year 20",{"$f":"IF(AND($B$6+D22-1>=$B$9, $B$6+D22-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D22-1< 95, IF($B$6+D22-1=65, 25000, IF($B$6+D22-1>65, 25000+1000*($B$6+D22-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D22-1<$B$9, $B$6+D22-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D22-1>=60, $B$6+D22-1<=100), ($B$6+D22-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D22-1>=$B$9, $B$6+D22-1<$B$9+$B$3), IF($B$6+D22-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,60,21,"Year 21",{"$f":"IF(AND($B$6+D23-1>=$B$9, $B$6+D23-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D23-1< 95, IF($B$6+D23-1=65, 25000, IF($B$6+D23-1>65, 25000+1000*($B$6+D23-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D23-1<$B$9, $B$6+D23-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D23-1>=60, $B$6+D23-1<=100), ($B$6+D23-1)*1000, 0)","v":60000},{"$f":"IF(AND($B$6+D23-1>=$B$9, $B$6+D23-1<$B$9+$B$3), IF($B$6+D23-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,61,22,"Year 22",{"$f":"IF(AND($B$6+D24-1>=$B$9, $B$6+D24-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D24-1< 95, IF($B$6+D24-1=65, 25000, IF($B$6+D24-1>65, 25000+1000*($B$6+D24-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D24-1<$B$9, $B$6+D24-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D24-1>=60, $B$6+D24-1<=100), ($B$6+D24-1)*1000, 0)","v":61000},{"$f":"IF(AND($B$6+D24-1>=$B$9, $B$6+D24-1<$B$9+$B$3), IF($B$6+D24-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,62,23,"Year 23",{"$f":"IF(AND($B$6+D25-1>=$B$9, $B$6+D25-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D25-1< 95, IF($B$6+D25-1=65, 25000, IF($B$6+D25-1>65, 25000+1000*($B$6+D25-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D25-1<$B$9, $B$6+D25-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D25-1>=60, $B$6+D25-1<=100), ($B$6+D25-1)*1000, 0)","v":62000},{"$f":"IF(AND($B$6+D25-1>=$B$9, $B$6+D25-1<$B$9+$B$3), IF($B$6+D25-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,63,24,"Year 24",{"$f":"IF(AND($B$6+D26-1>=$B$9, $B$6+D26-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D26-1< 95, IF($B$6+D26-1=65, 25000, IF($B$6+D26-1>65, 25000+1000*($B$6+D26-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D26-1<$B$9, $B$6+D26-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D26-1>=60, $B$6+D26-1<=100), ($B$6+D26-1)*1000, 0)","v":63000},{"$f":"IF(AND($B$6+D26-1>=$B$9, $B$6+D26-1<$B$9+$B$3), IF($B$6+D26-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,64,25,"Year 25",{"$f":"IF(AND($B$6+D27-1>=$B$9, $B$6+D27-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D27-1< 95, IF($B$6+D27-1=65, 25000, IF($B$6+D27-1>65, 25000+1000*($B$6+D27-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D27-1<$B$9, $B$6+D27-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D27-1>=60, $B$6+D27-1<=100), ($B$6+D27-1)*1000, 0)","v":64000},{"$f":"IF(AND($B$6+D27-1>=$B$9, $B$6+D27-1<$B$9+$B$3), IF($B$6+D27-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,65,26,"Year 26",{"$f":"IF(AND($B$6+D28-1>=$B$9, $B$6+D28-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D28-1< 95, IF($B$6+D28-1=65, 25000, IF($B$6+D28-1>65, 25000+1000*($B$6+D28-1-65), 0)), 0)","v":25000},{"$f":"IF(OR($B$6+D28-1<$B$9, $B$6+D28-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D28-1>=60, $B$6+D28-1<=100), ($B$6+D28-1)*1000, 0)","v":65000},{"$f":"IF(AND($B$6+D28-1>=$B$9, $B$6+D28-1<$B$9+$B$3), IF($B$6+D28-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,66,27,"Year 27",{"$f":"IF(AND($B$6+D29-1>=$B$9, $B$6+D29-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D29-1< 95, IF($B$6+D29-1=65, 25000, IF($B$6+D29-1>65, 25000+1000*($B$6+D29-1-65), 0)), 0)","v":26000},{"$f":"IF(OR($B$6+D29-1<$B$9, $B$6+D29-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D29-1>=60, $B$6+D29-1<=100), ($B$6+D29-1)*1000, 0)","v":66000},{"$f":"IF(AND($B$6+D29-1>=$B$9, $B$6+D29-1<$B$9+$B$3), IF($B$6+D29-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,67,28,"Year 28",{"$f":"IF(AND($B$6+D30-1>=$B$9, $B$6+D30-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D30-1< 95, IF($B$6+D30-1=65, 25000, IF($B$6+D30-1>65, 25000+1000*($B$6+D30-1-65), 0)), 0)","v":27000},{"$f":"IF(OR($B$6+D30-1<$B$9, $B$6+D30-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D30-1>=60, $B$6+D30-1<=100), ($B$6+D30-1)*1000, 0)","v":67000},{"$f":"IF(AND($B$6+D30-1>=$B$9, $B$6+D30-1<$B$9+$B$3), IF($B$6+D30-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,68,29,"Year 29",{"$f":"IF(AND($B$6+D31-1>=$B$9, $B$6+D31-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D31-1< 95, IF($B$6+D31-1=65, 25000, IF($B$6+D31-1>65, 25000+1000*($B$6+D31-1-65), 0)), 0)","v":28000},{"$f":"IF(OR($B$6+D31-1<$B$9, $B$6+D31-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D31-1>=60, $B$6+D31-1<=100), ($B$6+D31-1)*1000, 0)","v":68000},{"$f":"IF(AND($B$6+D31-1>=$B$9, $B$6+D31-1<$B$9+$B$3), IF($B$6+D31-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,69,30,"Year 30",{"$f":"IF(AND($B$6+D32-1>=$B$9, $B$6+D32-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D32-1< 95, IF($B$6+D32-1=65, 25000, IF($B$6+D32-1>65, 25000+1000*($B$6+D32-1-65), 0)), 0)","v":29000},{"$f":"IF(OR($B$6+D32-1<$B$9, $B$6+D32-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D32-1>=60, $B$6+D32-1<=100), ($B$6+D32-1)*1000, 0)","v":69000},{"$f":"IF(AND($B$6+D32-1>=$B$9, $B$6+D32-1<$B$9+$B$3), IF($B$6+D32-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,70,31,"Year 31",{"$f":"IF(AND($B$6+D33-1>=$B$9, $B$6+D33-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D33-1< 95, IF($B$6+D33-1=65, 25000, IF($B$6+D33-1>65, 25000+1000*($B$6+D33-1-65), 0)), 0)","v":30000},{"$f":"IF(OR($B$6+D33-1<$B$9, $B$6+D33-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D33-1>=60, $B$6+D33-1<=100), ($B$6+D33-1)*1000, 0)","v":70000},{"$f":"IF(AND($B$6+D33-1>=$B$9, $B$6+D33-1<$B$9+$B$3), IF($B$6+D33-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,71,32,"Year 32",{"$f":"IF(AND($B$6+D34-1>=$B$9, $B$6+D34-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D34-1< 95, IF($B$6+D34-1=65, 25000, IF($B$6+D34-1>65, 25000+1000*($B$6+D34-1-65), 0)), 0)","v":31000},{"$f":"IF(OR($B$6+D34-1<$B$9, $B$6+D34-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D34-1>=60, $B$6+D34-1<=100), ($B$6+D34-1)*1000, 0)","v":71000},{"$f":"IF(AND($B$6+D34-1>=$B$9, $B$6+D34-1<$B$9+$B$3), IF($B$6+D34-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,72,33,"Year 33",{"$f":"IF(AND($B$6+D35-1>=$B$9, $B$6+D35-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D35-1< 95, IF($B$6+D35-1=65, 25000, IF($B$6+D35-1>65, 25000+1000*($B$6+D35-1-65), 0)), 0)","v":32000},{"$f":"IF(OR($B$6+D35-1<$B$9, $B$6+D35-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D35-1>=60, $B$6+D35-1<=100), ($B$6+D35-1)*1000, 0)","v":72000},{"$f":"IF(AND($B$6+D35-1>=$B$9, $B$6+D35-1<$B$9+$B$3), IF($B$6+D35-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,73,34,"Year 34",{"$f":"IF(AND($B$6+D36-1>=$B$9, $B$6+D36-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D36-1< 95, IF($B$6+D36-1=65, 25000, IF($B$6+D36-1>65, 25000+1000*($B$6+D36-1-65), 0)), 0)","v":33000},{"$f":"IF(OR($B$6+D36-1<$B$9, $B$6+D36-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D36-1>=60, $B$6+D36-1<=100), ($B$6+D36-1)*1000, 0)","v":73000},{"$f":"IF(AND($B$6+D36-1>=$B$9, $B$6+D36-1<$B$9+$B$3), IF($B$6+D36-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,74,35,"Year 35",{"$f":"IF(AND($B$6+D37-1>=$B$9, $B$6+D37-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D37-1< 95, IF($B$6+D37-1=65, 25000, IF($B$6+D37-1>65, 25000+1000*($B$6+D37-1-65), 0)), 0)","v":34000},{"$f":"IF(OR($B$6+D37-1<$B$9, $B$6+D37-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D37-1>=60, $B$6+D37-1<=100), ($B$6+D37-1)*1000, 0)","v":74000},{"$f":"IF(AND($B$6+D37-1>=$B$9, $B$6+D37-1<$B$9+$B$3), IF($B$6+D37-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,75,36,"Year 36",{"$f":"IF(AND($B$6+D38-1>=$B$9, $B$6+D38-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D38-1< 95, IF($B$6+D38-1=65, 25000, IF($B$6+D38-1>65, 25000+1000*($B$6+D38-1-65), 0)), 0)","v":35000},{"$f":"IF(OR($B$6+D38-1<$B$9, $B$6+D38-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D38-1>=60, $B$6+D38-1<=100), ($B$6+D38-1)*1000, 0)","v":75000},{"$f":"IF(AND($B$6+D38-1>=$B$9, $B$6+D38-1<$B$9+$B$3), IF($B$6+D38-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,76,37,"Year 37",{"$f":"IF(AND($B$6+D39-1>=$B$9, $B$6+D39-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D39-1< 95, IF($B$6+D39-1=65, 25000, IF($B$6+D39-1>65, 25000+1000*($B$6+D39-1-65), 0)), 0)","v":36000},{"$f":"IF(OR($B$6+D39-1<$B$9, $B$6+D39-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D39-1>=60, $B$6+D39-1<=100), ($B$6+D39-1)*1000, 0)","v":76000},{"$f":"IF(AND($B$6+D39-1>=$B$9, $B$6+D39-1<$B$9+$B$3), IF($B$6+D39-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,77,38,"Year 38",{"$f":"IF(AND($B$6+D40-1>=$B$9, $B$6+D40-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D40-1< 95, IF($B$6+D40-1=65, 25000, IF($B$6+D40-1>65, 25000+1000*($B$6+D40-1-65), 0)), 0)","v":37000},{"$f":"IF(OR($B$6+D40-1<$B$9, $B$6+D40-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D40-1>=60, $B$6+D40-1<=100), ($B$6+D40-1)*1000, 0)","v":77000},{"$f":"IF(AND($B$6+D40-1>=$B$9, $B$6+D40-1<$B$9+$B$3), IF($B$6+D40-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,78,39,"Year 39",{"$f":"IF(AND($B$6+D41-1>=$B$9, $B$6+D41-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D41-1< 95, IF($B$6+D41-1=65, 25000, IF($B$6+D41-1>65, 25000+1000*($B$6+D41-1-65), 0)), 0)","v":38000},{"$f":"IF(OR($B$6+D41-1<$B$9, $B$6+D41-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D41-1>=60, $B$6+D41-1<=100), ($B$6+D41-1)*1000, 0)","v":78000},{"$f":"IF(AND($B$6+D41-1>=$B$9, $B$6+D41-1<$B$9+$B$3), IF($B$6+D41-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,79,40,"Year 40",{"$f":"IF(AND($B$6+D42-1>=$B$9, $B$6+D42-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D42-1< 95, IF($B$6+D42-1=65, 25000, IF($B$6+D42-1>65, 25000+1000*($B$6+D42-1-65), 0)), 0)","v":39000},{"$f":"IF(OR($B$6+D42-1<$B$9, $B$6+D42-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D42-1>=60, $B$6+D42-1<=100), ($B$6+D42-1)*1000, 0)","v":79000},{"$f":"IF(AND($B$6+D42-1>=$B$9, $B$6+D42-1<$B$9+$B$3), IF($B$6+D42-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,80,41,"Year 41",{"$f":"IF(AND($B$6+D43-1>=$B$9, $B$6+D43-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D43-1< 95, IF($B$6+D43-1=65, 25000, IF($B$6+D43-1>65, 25000+1000*($B$6+D43-1-65), 0)), 0)","v":40000},{"$f":"IF(OR($B$6+D43-1<$B$9, $B$6+D43-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D43-1>=60, $B$6+D43-1<=100), ($B$6+D43-1)*1000, 0)","v":80000},{"$f":"IF(AND($B$6+D43-1>=$B$9, $B$6+D43-1<$B$9+$B$3), IF($B$6+D43-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,81,42,"Year 42",{"$f":"IF(AND($B$6+D44-1>=$B$9, $B$6+D44-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D44-1< 95, IF($B$6+D44-1=65, 25000, IF($B$6+D44-1>65, 25000+1000*($B$6+D44-1-65), 0)), 0)","v":41000},{"$f":"IF(OR($B$6+D44-1<$B$9, $B$6+D44-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D44-1>=60, $B$6+D44-1<=100), ($B$6+D44-1)*1000, 0)","v":81000},{"$f":"IF(AND($B$6+D44-1>=$B$9, $B$6+D44-1<$B$9+$B$3), IF($B$6+D44-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,82,43,"Year 43",{"$f":"IF(AND($B$6+D45-1>=$B$9, $B$6+D45-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D45-1< 95, IF($B$6+D45-1=65, 25000, IF($B$6+D45-1>65, 25000+1000*($B$6+D45-1-65), 0)), 0)","v":42000},{"$f":"IF(OR($B$6+D45-1<$B$9, $B$6+D45-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D45-1>=60, $B$6+D45-1<=100), ($B$6+D45-1)*1000, 0)","v":82000},{"$f":"IF(AND($B$6+D45-1>=$B$9, $B$6+D45-1<$B$9+$B$3), IF($B$6+D45-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,83,44,"Year 44",{"$f":"IF(AND($B$6+D46-1>=$B$9, $B$6+D46-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D46-1< 95, IF($B$6+D46-1=65, 25000, IF($B$6+D46-1>65, 25000+1000*($B$6+D46-1-65), 0)), 0)","v":43000},{"$f":"IF(OR($B$6+D46-1<$B$9, $B$6+D46-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D46-1>=60, $B$6+D46-1<=100), ($B$6+D46-1)*1000, 0)","v":83000},{"$f":"IF(AND($B$6+D46-1>=$B$9, $B$6+D46-1<$B$9+$B$3), IF($B$6+D46-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,84,45,"Year 45",{"$f":"IF(AND($B$6+D47-1>=$B$9, $B$6+D47-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D47-1< 95, IF($B$6+D47-1=65, 25000, IF($B$6+D47-1>65, 25000+1000*($B$6+D47-1-65), 0)), 0)","v":44000},{"$f":"IF(OR($B$6+D47-1<$B$9, $B$6+D47-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D47-1>=60, $B$6+D47-1<=100), ($B$6+D47-1)*1000, 0)","v":84000},{"$f":"IF(AND($B$6+D47-1>=$B$9, $B$6+D47-1<$B$9+$B$3), IF($B$6+D47-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,85,46,"Year 46",{"$f":"IF(AND($B$6+D48-1>=$B$9, $B$6+D48-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D48-1< 95, IF($B$6+D48-1=65, 25000, IF($B$6+D48-1>65, 25000+1000*($B$6+D48-1-65), 0)), 0)","v":45000},{"$f":"IF(OR($B$6+D48-1<$B$9, $B$6+D48-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D48-1>=60, $B$6+D48-1<=100), ($B$6+D48-1)*1000, 0)","v":85000},{"$f":"IF(AND($B$6+D48-1>=$B$9, $B$6+D48-1<$B$9+$B$3), IF($B$6+D48-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,86,47,"Year 47",{"$f":"IF(AND($B$6+D49-1>=$B$9, $B$6+D49-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D49-1< 95, IF($B$6+D49-1=65, 25000, IF($B$6+D49-1>65, 25000+1000*($B$6+D49-1-65), 0)), 0)","v":46000},{"$f":"IF(OR($B$6+D49-1<$B$9, $B$6+D49-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D49-1>=60, $B$6+D49-1<=100), ($B$6+D49-1)*1000, 0)","v":86000},{"$f":"IF(AND($B$6+D49-1>=$B$9, $B$6+D49-1<$B$9+$B$3), IF($B$6+D49-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,87,48,"Year 48",{"$f":"IF(AND($B$6+D50-1>=$B$9, $B$6+D50-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D50-1< 95, IF($B$6+D50-1=65, 25000, IF($B$6+D50-1>65, 25000+1000*($B$6+D50-1-65), 0)), 0)","v":47000},{"$f":"IF(OR($B$6+D50-1<$B$9, $B$6+D50-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D50-1>=60, $B$6+D50-1<=100), ($B$6+D50-1)*1000, 0)","v":87000},{"$f":"IF(AND($B$6+D50-1>=$B$9, $B$6+D50-1<$B$9+$B$3), IF($B$6+D50-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,88,49,"Year 49",{"$f":"IF(AND($B$6+D51-1>=$B$9, $B$6+D51-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D51-1< 95, IF($B$6+D51-1=65, 25000, IF($B$6+D51-1>65, 25000+1000*($B$6+D51-1-65), 0)), 0)","v":48000},{"$f":"IF(OR($B$6+D51-1<$B$9, $B$6+D51-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D51-1>=60, $B$6+D51-1<=100), ($B$6+D51-1)*1000, 0)","v":88000},{"$f":"IF(AND($B$6+D51-1>=$B$9, $B$6+D51-1<$B$9+$B$3), IF($B$6+D51-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,89,50,"Year 50",{"$f":"IF(AND($B$6+D52-1>=$B$9, $B$6+D52-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D52-1< 95, IF($B$6+D52-1=65, 25000, IF($B$6+D52-1>65, 25000+1000*($B$6+D52-1-65), 0)), 0)","v":49000},{"$f":"IF(OR($B$6+D52-1<$B$9, $B$6+D52-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D52-1>=60, $B$6+D52-1<=100), ($B$6+D52-1)*1000, 0)","v":89000},{"$f":"IF(AND($B$6+D52-1>=$B$9, $B$6+D52-1<$B$9+$B$3), IF($B$6+D52-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,90,51,"Year 51",{"$f":"IF(AND($B$6+D53-1>=$B$9, $B$6+D53-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D53-1< 95, IF($B$6+D53-1=65, 25000, IF($B$6+D53-1>65, 25000+1000*($B$6+D53-1-65), 0)), 0)","v":50000},{"$f":"IF(OR($B$6+D53-1<$B$9, $B$6+D53-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D53-1>=60, $B$6+D53-1<=100), ($B$6+D53-1)*1000, 0)","v":90000},{"$f":"IF(AND($B$6+D53-1>=$B$9, $B$6+D53-1<$B$9+$B$3), IF($B$6+D53-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,91,52,"Year 52",{"$f":"IF(AND($B$6+D54-1>=$B$9, $B$6+D54-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D54-1< 95, IF($B$6+D54-1=65, 25000, IF($B$6+D54-1>65, 25000+1000*($B$6+D54-1-65), 0)), 0)","v":51000},{"$f":"IF(OR($B$6+D54-1<$B$9, $B$6+D54-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D54-1>=60, $B$6+D54-1<=100), ($B$6+D54-1)*1000, 0)","v":91000},{"$f":"IF(AND($B$6+D54-1>=$B$9, $B$6+D54-1<$B$9+$B$3), IF($B$6+D54-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,92,53,"Year 53",{"$f":"IF(AND($B$6+D55-1>=$B$9, $B$6+D55-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D55-1< 95, IF($B$6+D55-1=65, 25000, IF($B$6+D55-1>65, 25000+1000*($B$6+D55-1-65), 0)), 0)","v":52000},{"$f":"IF(OR($B$6+D55-1<$B$9, $B$6+D55-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D55-1>=60, $B$6+D55-1<=100), ($B$6+D55-1)*1000, 0)","v":92000},{"$f":"IF(AND($B$6+D55-1>=$B$9, $B$6+D55-1<$B$9+$B$3), IF($B$6+D55-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,93,54,"Year 54",{"$f":"IF(AND($B$6+D56-1>=$B$9, $B$6+D56-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D56-1< 95, IF($B$6+D56-1=65, 25000, IF($B$6+D56-1>65, 25000+1000*($B$6+D56-1-65), 0)), 0)","v":53000},{"$f":"IF(OR($B$6+D56-1<$B$9, $B$6+D56-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D56-1>=60, $B$6+D56-1<=100), ($B$6+D56-1)*1000, 0)","v":93000},{"$f":"IF(AND($B$6+D56-1>=$B$9, $B$6+D56-1<$B$9+$B$3), IF($B$6+D56-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,94,54,"Year 55",{"$f":"IF(AND($B$6+D57-1>=$B$9, $B$6+D57-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D57-1< 95, IF($B$6+D57-1=65, 25000, IF($B$6+D57-1>65, 25000+1000*($B$6+D57-1-65), 0)), 0)","v":53000},{"$f":"IF(OR($B$6+D57-1<$B$9, $B$6+D57-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D57-1>=60, $B$6+D57-1<=100), ($B$6+D57-1)*1000, 0)","v":93000},{"$f":"IF(AND($B$6+D57-1>=$B$9, $B$6+D57-1<$B$9+$B$3), IF($B$6+D57-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,95,56,"Year 56",{"$f":"IF(AND($B$6+D58-1>=$B$9, $B$6+D58-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D58-1< 95, IF($B$6+D58-1=65, 25000, IF($B$6+D58-1>65, 25000+1000*($B$6+D58-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D58-1<$B$9, $B$6+D58-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D58-1>=60, $B$6+D58-1<=100), ($B$6+D58-1)*1000, 0)","v":95000},{"$f":"IF(AND($B$6+D58-1>=$B$9, $B$6+D58-1<$B$9+$B$3), IF($B$6+D58-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,96,57,"Year 57",{"$f":"IF(AND($B$6+D59-1>=$B$9, $B$6+D59-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D59-1< 95, IF($B$6+D59-1=65, 25000, IF($B$6+D59-1>65, 25000+1000*($B$6+D59-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D59-1<$B$9, $B$6+D59-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D59-1>=60, $B$6+D59-1<=100), ($B$6+D59-1)*1000, 0)","v":96000},{"$f":"IF(AND($B$6+D59-1>=$B$9, $B$6+D59-1<$B$9+$B$3), IF($B$6+D59-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,97,58,"Year 58",{"$f":"IF(AND($B$6+D60-1>=$B$9, $B$6+D60-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D60-1< 95, IF($B$6+D60-1=65, 25000, IF($B$6+D60-1>65, 25000+1000*($B$6+D60-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D60-1<$B$9, $B$6+D60-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D60-1>=60, $B$6+D60-1<=100), ($B$6+D60-1)*1000, 0)","v":97000},{"$f":"IF(AND($B$6+D60-1>=$B$9, $B$6+D60-1<$B$9+$B$3), IF($B$6+D60-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,98,59,"Year 59",{"$f":"IF(AND($B$6+D61-1>=$B$9, $B$6+D61-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D61-1< 95, IF($B$6+D61-1=65, 25000, IF($B$6+D61-1>65, 25000+1000*($B$6+D61-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D61-1<$B$9, $B$6+D61-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D61-1>=60, $B$6+D61-1<=100), ($B$6+D61-1)*1000, 0)","v":98000},{"$f":"IF(AND($B$6+D61-1>=$B$9, $B$6+D61-1<$B$9+$B$3), IF($B$6+D61-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,99,60,"Year 60",{"$f":"IF(AND($B$6+D62-1>=$B$9, $B$6+D62-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D62-1< 95, IF($B$6+D62-1=65, 25000, IF($B$6+D62-1>65, 25000+1000*($B$6+D62-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D62-1<$B$9, $B$6+D62-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D62-1>=60, $B$6+D62-1<=100), ($B$6+D62-1)*1000, 0)","v":99000},{"$f":"IF(AND($B$6+D62-1>=$B$9, $B$6+D62-1<$B$9+$B$3), IF($B$6+D62-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,100,61,"Year 61",{"$f":"IF(AND($B$6+D63-1>=$B$9, $B$6+D63-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D63-1< 95, IF($B$6+D63-1=65, 25000, IF($B$6+D63-1>65, 25000+1000*($B$6+D63-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D63-1<$B$9, $B$6+D63-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D63-1>=60, $B$6+D63-1<=100), ($B$6+D63-1)*1000, 0)","v":100000},{"$f":"IF(AND($B$6+D63-1>=$B$9, $B$6+D63-1<$B$9+$B$3), IF($B$6+D63-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,101,62,"Year 62",{"$f":"IF(AND($B$6+D64-1>=$B$9, $B$6+D64-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D64-1< 95, IF($B$6+D64-1=65, 25000, IF($B$6+D64-1>65, 25000+1000*($B$6+D64-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D64-1<$B$9, $B$6+D64-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D64-1>=60, $B$6+D64-1<=100), ($B$6+D64-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D64-1>=$B$9, $B$6+D64-1<$B$9+$B$3), IF($B$6+D64-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,102,63,"Year 63",{"$f":"IF(AND($B$6+D65-1>=$B$9, $B$6+D65-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D65-1< 95, IF($B$6+D65-1=65, 25000, IF($B$6+D65-1>65, 25000+1000*($B$6+D65-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D65-1<$B$9, $B$6+D65-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D65-1>=60, $B$6+D65-1<=100), ($B$6+D65-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D65-1>=$B$9, $B$6+D65-1<$B$9+$B$3), IF($B$6+D65-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,103,64,"Year 64",{"$f":"IF(AND($B$6+D66-1>=$B$9, $B$6+D66-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D66-1< 95, IF($B$6+D66-1=65, 25000, IF($B$6+D66-1>65, 25000+1000*($B$6+D66-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D66-1<$B$9, $B$6+D66-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D66-1>=60, $B$6+D66-1<=100), ($B$6+D66-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D66-1>=$B$9, $B$6+D66-1<$B$9+$B$3), IF($B$6+D66-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,104,65,"Year 65",{"$f":"IF(AND($B$6+D67-1>=$B$9, $B$6+D67-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D67-1< 95, IF($B$6+D67-1=65, 25000, IF($B$6+D67-1>65, 25000+1000*($B$6+D67-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D67-1<$B$9, $B$6+D67-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D67-1>=60, $B$6+D67-1<=100), ($B$6+D67-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D67-1>=$B$9, $B$6+D67-1<$B$9+$B$3), IF($B$6+D67-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,105,66,"Year 66",{"$f":"IF(AND($B$6+D68-1>=$B$9, $B$6+D68-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D68-1< 95, IF($B$6+D68-1=65, 25000, IF($B$6+D68-1>65, 25000+1000*($B$6+D68-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D68-1<$B$9, $B$6+D68-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D68-1>=60, $B$6+D68-1<=100), ($B$6+D68-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D68-1>=$B$9, $B$6+D68-1<$B$9+$B$3), IF($B$6+D68-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,{"$f":"C68+1","v":106},67,"Year 67",{"$f":"IF(AND($B$6+D69-1>=$B$9, $B$6+D69-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D69-1< 95, IF($B$6+D69-1=65, 25000, IF($B$6+D69-1>65, 25000+1000*($B$6+D69-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D69-1<$B$9, $B$6+D69-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D69-1>=60, $B$6+D69-1<=100), ($B$6+D69-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D69-1>=$B$9, $B$6+D69-1<$B$9+$B$3), IF($B$6+D69-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,107,68,"Year 68",{"$f":"IF(AND($B$6+D70-1>=$B$9, $B$6+D70-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D70-1< 95, IF($B$6+D70-1=65, 25000, IF($B$6+D70-1>65, 25000+1000*($B$6+D70-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D70-1<$B$9, $B$6+D70-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D70-1>=60, $B$6+D70-1<=100), ($B$6+D70-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D70-1>=$B$9, $B$6+D70-1<$B$9+$B$3), IF($B$6+D70-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,{"$f":"IF(AND($B$6+D70-1>=$B$9,$B$6+D70-1<$B$9+$B$3),IF(AND(ISEVEN($B$6+D70-1), ISEVEN($B$9)),30000,IF(AND(ISODD($B$6+D70-1), ISODD($B$9)), 30000,0)), 0)","v":0}]
[null,null,108,69,"Year 69",{"$f":"IF(AND($B$6+D71-1>=$B$9, $B$6+D71-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D71-1< 95, IF($B$6+D71-1=65, 25000, IF($B$6+D71-1>65, 25000+1000*($B$6+D71-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D71-1<$B$9, $B$6+D71-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D71-1>=60, $B$6+D71-1<=100), ($B$6+D71-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D71-1>=$B$9, $B$6+D71-1<$B$9+$B$3), IF($B$6+D71-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,109,70,"Year 70",{"$f":"IF(AND($B$6+D72-1>=$B$9, $B$6+D72-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D72-1< 95, IF($B$6+D72-1=65, 25000, IF($B$6+D72-1>65, 25000+1000*($B$6+D72-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D72-1<$B$9, $B$6+D72-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D72-1>=60, $B$6+D72-1<=100), ($B$6+D72-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D72-1>=$B$9, $B$6+D72-1<$B$9+$B$3), IF($B$6+D72-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,{"$f":"C72+1","v":110},71,"Year 71",{"$f":"IF(AND($B$6+D73-1>=$B$9, $B$6+D73-1<$B$9+$B$3), 15000, 0)","v":0},{"$f":"IF($B$6+D73-1< 95, IF($B$6+D73-1=65, 25000, IF($B$6+D73-1>65, 25000+1000*($B$6+D73-1-65), 0)), 0)","v":0},{"$f":"IF(OR($B$6+D73-1<$B$9, $B$6+D73-1>110), 0, 600*12)","v":7200},{"$f":"IF(AND($B$6+D73-1>=60, $B$6+D73-1<=100), ($B$6+D73-1)*1000, 0)","v":0},{"$f":"IF(AND($B$6+D73-1>=$B$9, $B$6+D73-1<$B$9+$B$3), IF($B$6+D73-1<($B$9+$B$3/2), 19000, 25000), 0)","v":0},0,0]
[null,null,111,72,"Year 72",0,0,0,0,0,0,0]
[null,null,112,73,"Year 73",0,0,0,0,0,0,0]