{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Disclaimer","Input","Assumptions","Output","Calculation","Version Control"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Disclaimer","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null," Single Scheme Estimator Tool - Disclaimer"]

{"sheet":"Input","index":1,"n_rows":149,"n_cols":8,"rows_kept":149,"cut":false,"hidden":false,"merged":[[44,1,45,7],[0,1,2,7],[3,2,3,7],[24,2,24,7],[16,2,16,7],[20,2,20,7],[29,2,29,7],[8,2,8,7]]}
[null,"SINGLE PUBLIC SERVICE PENSION SCHEME (THE \"SINGLE SCHEME\") \nINPUTS"]
[]
[]
[null,null,"This Tool is designed to give a broad indication of the retirement benefits of members of the Single Scheme at normal retirement age. The outputs from the Estimator Tool are not a guarantee of the retirement benefits payable at your normal retirement age. For a broad estimate of your projected Single Scheme benefits, please provide the following information:"]
[]
[]
[null,null,"Membership Type"]
[null,null,"Select","Standard",{"$f":"IF(D8=\"\",\"Enter Member Type Here\",\"\")","v":""}]
[]
[]
[null,null,"Retirement Age"]
[null,null,"Retirement Age"]
[]
[]
[null,null,"Full-Time Gross Annual Pensionable Pay (€)"]
[null,null,"€",100000,{"$f":"IF(E20=\"\",\"\",\"Enter Full-Time Annual Pensionable Pay here\")","v":""}]
[null,null,"Include all of your approved pensionable allowances"]
[]
[null,null,"% Work Pattern or Full Time Equivalent (FTE)"]
[null,null,"%",1,{"$f":"IF(D20<1,\"If your work pattern is less than 100%, make sure you enter the equivalent Full Time Pensionable Pay you would receive if you worked a full time pattern in the field Full Time Gross Annual Pensionable Pay above\",\"\")","v":""}]
[null,null,"Enter your % work pattern, to a maximum of 100%"]
[]
[null,null,"Year of Birth"]
[null,null,"Year",1990]
[]
[]
[null,null,"Year of Entry to the Single Scheme"]
[null,null,"Year",2024,"In order to give as complete an estimate as possible you should select the year when you first entered pensionable, Single Scheme employment. "]
[]
[]
[null,null,"Work Pattern and Full Time Pensionable Pay in previous years"]
[null,null,"Year","Annual Work Pattern (%)","Full-Time Gross Annual Pensionable Pay(€)"]
[null,null,2013]
[null,null,2014]
[null,null,2015]
[null,null,2016]
[null,null,2017]
[null,null,2018]
[null,null,2019]
[null,null,2020]
[null,null,2021]
[null,null,2022]
[null,null,2023]
[]
[]
[]
[]
[]
[null,null,2013,1,"An Garda Síochána - Garda / Sergeant / Inspector / Superintendent - Retirement Age 55",{"$f":"IF($D$8=\"Retained Firefighter\",\"\",50)","v":50}]
[null,null,2014,0.99,"Irish Prison Service - Prison Officer grades - Retirement Age 55",{"$f":"IF($D$8=\"Retained Firefighter\",\"\",F49+1)","v":51},{"$f":"YEAR(NOW()) - 3","v":2021}]
[null,null,2015,0.98,"Local Authority Fire Service - Career Firefighter - Retirement Age 55",{"$f":"IF($D$8=\"Retained Firefighter\",\"\",F50+1)","v":52},{"$f":"YEAR(NOW()) - 2","v":2022}]
[null,null,2016,0.97,"Permanent Defence Forces - Private / Corporal / Sergeant / Second Lieutenant / Lieutenant - Retirement Age 50",{"$f":"IF($D$8=\"Retained Firefighter\",\"\",F51+1)","v":53},{"$f":"YEAR(NOW()) - 1","v":2023}]
[null,null,2017,0.96,"Permanent Defence Forces - CQMS / Company Sergeant / QMS / Sergeant Major - Retirement Age 56",{"$f":"IF($D$8=\"Retained Firefighter\",\"\",F52+1)","v":54},{"$f":"YEAR(NOW())","v":2024}]
[null,null,2018,0.95,null,55,{"$f":"YEAR(NOW()) +1","v":2025},55]
[null,null,2019,0.94,null,56,{"$f":"YEAR(NOW())+2","v":2026},56]
[null,null,2020,0.93,null,57,{"$f":"YEAR(NOW())+3","v":2027},57]
[null,null,2021,0.92,"Standard",58,{"$f":"YEAR(NOW()) +4","v":2028},58]
[null,null,2022,0.91,"Retained Firefighter",{"$f":"IF($D$8=\"Retained Firefighter\",\"\",F57+1)","v":59},{"$f":"YEAR(NOW())+5","v":2029}]
[null,null,2023,0.9,"Judge",{"$f":"IF($D$8=\"Retained Firefighter\",\"\",F58+1)","v":60},{"$f":"YEAR(NOW())+6","v":2030}]
[null,null,2024,0.89,"Uniform",61,{"$f":"YEAR(NOW()) +7","v":2031}]
[null,null,2025,0.88,null,62]
[null,null,2026,0.87,"President",63]
[null,null,2027,0.86,"Designated Office Holder",64]
[null,null,2028,0.85,"Comptroller and Auditor General",65]
[null,null,2029,0.84,null,66]
[null,null,null,0.83,null,67]
[null,null,null,0.82,null,68]
[null,null,null,0.81,null,69]
[null,null,null,0.8,null,70]
[null,null,null,0.79,null,71]
[null,null,null,0.78,null,72]
[null,null,null,0.77,null,73]
[null,null,null,0.76,null,74]
[null,null,null,0.75,null,75]
[null,null,null,0.74,null,76]
[null,null,null,0.73,null,77]
[null,null,null,0.72,null,78]
[null,null,null,0.71,null,79]
[null,null,null,0.7,null,80]
[null,null,null,0.69,null,81]
[null,null,null,0.68,null,82]
[null,null,null,0.67,null,83]
[null,null,null,0.66,null,84]
[null,null,null,0.65,null,85]
[null,null,null,0.64,null,86]
[null,null,null,0.63,null,87]
[null,null,null,0.62,null,88]
[null,null,null,0.61,null,89]
[null,null,null,0.6,null,90]
[null,null,null,0.59,null,91]
[null,null,null,0.57999999999999996,null,92]
[null,null,null,0.56999999999999995,null,93]
[null,null,null,0.56000000000000005,null,94]
[null,null,null,0.55000000000000004,null,95]
[null,null,null,0.54,null,96]
[null,null,null,0.53,null,97]
[null,null,null,0.52,null,98]
[null,null,null,0.51,null,99]
[null,null,null,0.5,null,100]
[null,null,null,0.49,null,101]
[null,null,null,0.48,null,102]
[null,null,null,0.47,null,103]
[null,null,null,0.46,null,104]
[null,null,null,0.45,null,105]
[null,null,null,0.44,null,106]
[null,null,null,0.43,null,107]
[null,null,null,0.42,null,108]
[null,null,null,0.41,null,109]
[null,null,null,0.4,null,110]
[null,null,null,0.39,null,111]
[null,null,null,0.38]
[null,null,null,0.37]
[null,null,null,0.36]
[null,null,null,0.35]
[null,null,null,0.34]
[null,null,null,0.33]
[null,null,null,0.32]
[null,null,null,0.31]
[null,null,null,0.3]
[null,null,null,0.28999999999999898]
[null,null,null,0.27999999999999903]
[null,null,null,0.26999999999999902]
[null,null,null,0.25999999999999901]
[null,null,null,0.249999999999999]
[null,null,null,0.23999999999999899]
[null,null,null,0.22999999999999901]
[null,null,null,0.219999999999999]
[null,null,null,0.20999999999999899]
[null,null,null,0.19999999999999901]
[null,null,null,0.189999999999999]
[null,null,null,0.17999999999999899]
[null,null,null,0.16999999999999901]
[null,null,null,0.159999999999999]
[null,null,null,0.149999999999999]
[null,null,null,0.13999999999999899]
[null,null,null,0.12999999999999901]
[null,null,null,0.119999999999999]
[null,null,null,0.109999999999999]
[null,null,null,9.9999999999999006E-2]
[null,null,null,8.9999999999998997E-2]
[null,null,null,7.9999999999999002E-2]
[null,null,null,6.9999999999998994E-2]
[null,null,null,5.9999999999998901E-2]
[null,null,null,4.9999999999998899E-2]
[null,null,null,3.9999999999999002E-2]
[null,null,null,2.9999999999999E-2]
[null,null,null,1.9999999999999001E-2]
[null,null,null,9.9999999999990097E-3]
[null,null,null,-9.9920072216264108E-16]

{"sheet":"Assumptions","index":2,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"ASSUMPTIONS"]

{"sheet":"Output","index":3,"n_rows":56,"n_cols":8,"rows_kept":56,"cut":false,"hidden":false,"merged":[[38,5,38,6],[36,2,36,6],[31,2,31,6],[0,1,0,7],[16,2,16,6],[19,2,19,6],[15,2,15,6],[1,2,3,7],[8,2,8,6],[6,5,6,6],[35,1,35,7],[28,2,28,4]]}
[null,{"$f":"Input!D8 & \" SINGLE SCHEME ESTIMATOR TOOL - RESULTS\"","v":"Standard SINGLE SCHEME ESTIMATOR TOOL - RESULTS"}]
[null,null,"See below an estimate of your projected Single Scheme benefits, in present day money terms,  based on information you have provided and assumptions listed."]
[]
[]
[]
[null,null,"Contributions This Year"]
[null,null,"Scheme Contributions",null,null,"Additional Superannuation Contribution (ASC)"]
[null,null,"€",{"$f":"Calculation!H45+Calculation!I45","v":5487.1340199999995}," ","€",{"$f":"Calculation!J45","v":2249.1500000000005}]
[null,null,{"$f":"\"Based on your inputs, you are projected to pay €\"&TEXT(ROUND(D8,0),\"##,###\")& \" in employee contributions and €\"&TEXT(ROUND(G8,0),\"##,###\")&\" in Additional Superannuation Contributions over the next 12 months.\"","v":"Based on your inputs, you are projected to pay €5,487 in employee contributions and €2,249 in Additional Superannuation Contributions over the next 12 months."}]
[]
[null,null,"Retirement Benefits Built Up This Year"]
[null,null,{"$f":"\"Your normal retirement age is: \"&Calculation!AA5","v":"Your normal retirement age is: 66"}]
[]
[null,null,"Retirement Pension Benefit ",null,null,"Retirement Lump Sum Benefit"]
[null,null,"€",{"$f":"IF(Input!D28=Calculation!B43,Calculation!O43*2,Calculation!O43)","v":887.42291818799993},"p.a.","€",{"$f":"IF(Input!D28=Calculation!B43,Calculation!M43*2,Calculation!M43)","v":3750}]
[null,null,{"$f":"\"On the basis of your inputs, you are expected to build up €\"&TEXT(ROUND($D$15,2),\"##,###\")&\" towards your annual pension entitlement and €\"&TEXT(ROUND($G$15,2),\"##,###\")&\" towards your retirement lump sum payment over the next 12 months.\"","v":"On the basis of your inputs, you are expected to build up €887 towards your annual pension entitlement and €3,750 towards your retirement lump sum payment over the next 12 months."}]
[null,null,{"$f":"\"The benefits built-up above will be payable from your normal retirement age, i.e. age \"&Calculation!AA5&\". Your pension and lump sum benefits will be uprated in line with changes in the Consumer Price Index between the year of building up these benefits and the year of your retirement.\"","v":"The benefits built-up above will be payable from your normal retirement age, i.e. age 66. Your pension and lump sum benefits will be uprated in line with changes in the Consumer Price Index between the year of building up these benefits and the year of your retirement."}]
[]
[null,null,"Estimated Benefits At Retirement"]
[null,null,"Please refer to all assumptions for further detail on how these estimates have been derived."]
[]
[null,null,"Normal Retirement Year",null,null,"Year ",{"$f":"Calculation!AA7","v":2056}]
[]
[null,null,"Single Scheme Retirement Lump Sum",null,null,"€",{"$f":"Calculation!AA15","v":123137.37981101588}]
[]
[null,null,"Single Scheme Annual Retirement Pension",null,null,"€",{"$f":"Calculation!AA14","v":29201.809274473118},"p.a."]
[]
[null,null,"Annual Contributory State Pension",null,null,"€",{"$f":"Calculation!G14","v":14469.514000000001},"p.a."]
[null,null,"You are assumed to be eligible to receive the full State Pension (Contributory) from your state pension eligibility age. Your Single Scheme Normal Retirement Age and the State Pension (Contributory) eligibility age are not the same if you are a Uniformed member or a Retained Firefighter.  However for all other membership types, the eligibility age for the State Pension (Contributory) and the minimum Single Scheme normal retirement age are the same. "]
[null,null,"Today's Date",null,null,null,{"$f":"TODAY()","v":"2024-06-20"}]
[]
[null,null,"All figures shown above are in present day money terms. This means that your estimated benefits are shown in the equivalent of “today’s money.”"]
[null,null,null,null,null," "," "]
[]
[]
[null,"Reminder - Inputs"]
[null,null,"These are the values you entered on the \"Inputs\" page. If you need to amend the values, please use the \"Back to Inputs\" button "]
[]
[null,null,{"$f":"Input!D8","v":"Standard"},null,null,{"$f":"Input!D8","v":"Standard"}]
[null,null,"Full-Time Gross Annual Pensionable Pay (€)",null,null,null,{"$f":"Input!D16","v":100000}]
[null,null,"% Work Pattern or Full Time Equivalent (FTE)",null,null,null,{"$f":"Input!D20","v":1}]
[null,null,"Year of Birth",null,null,null,{"$f":"Input!D24","v":1990}]
[null,null,"Year of Entry to the Single Scheme",null,null,null,{"$f":"Input!D28","v":2024}]
[]
[null,null,"Where relevant, Work Pattern and Full Time Pensionable Pay in previous years"]
[null,null,null,"Year","Annual Work Pattern (%)","Full-Time Gross Annual Pensionable Pay (€)"]
[null,null,null,2013,{"$f":"Input!D33","v":0},{"$f":"Input!E33","v":0}]
[null,null,null,2014,{"$f":"Input!D34","v":0},{"$f":"Input!E34","v":0}]
[null,null,null,2015,{"$f":"Input!D35","v":0},{"$f":"Input!E35","v":0}]
[null,null,null,2016,{"$f":"Input!D36","v":0},{"$f":"Input!E36","v":0}]
[null,null,null,2017,{"$f":"Input!D37","v":0},{"$f":"Input!E37","v":0}]
[null,null,null,2018,{"$f":"Input!D38","v":0},{"$f":"Input!E38","v":0}]
[null,null,null,2019,{"$f":"Input!D39","v":0},{"$f":"Input!E39","v":0}]
[null,null,null,2020,{"$f":"Input!D40","v":0},{"$f":"Input!E40","v":0}]
[null,null,null,2021,{"$f":"Input!D41","v":0},{"$f":"Input!E41","v":0}]
[null,null,null,2022,{"$f":"Input!D42","v":0},{"$f":"Input!E42","v":0}]

{"sheet":"Calculation","index":4,"n_rows":96,"n_cols":35,"rows_kept":96,"cut":false,"hidden":true,"merged":[[1,33,1,34],[25,14,25,15],[1,1,1,15],[25,3,25,6],[25,7,25,8],[3,11,16,11],[3,14,16,14]]}
[]
[null,"Single Scheme",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IGNORE - Designated and Comptroller Grades"]
[null,"Parameters",null,null,null,null,null,null,"2020 Onwards",null,null,null,"CPI rates - SS referable amounts",null,null,"Year","% of Year Worked","Reference Date",null,"CSP Cut-Off Dates",null,null,null,null,null,"CALCULATIONS",null,null,"CSP Rates",null,null,null,null,"Year End v Year Start",{"$f":"36 + IFERROR(Input!#REF!-2013, 0)","v":36}]
[null,"Accrual rates",null,null,null,null,null,null,"Bands",null,"ASC","Add CPI Years as is necessary",2013,"N/A","Add Years as is necessary - make sure formula in column Q is ",2013,{"$f":"IFERROR(IF(Input!$D$28=P4,0.5,IF(Input!$D$28>Calculation!P4,0,1)),\"\")","v":0},"2013-12-31",null,2017,"2017-01-01","2017-03-09","2017-12-31",null,null,"Service (Years)",null,null,"Yr","Start ","End ","CSP ",null,"This Cohort"]
[null,"Lump sum rate:",null,null,null,null,3.7499999999999999E-2,null,"<=€34500",34500,0,null,2014,0,null,2014,{"$f":"IFERROR(IF(Input!$D$28=P5,0.5,IF(Input!$D$28>Calculation!P5,0,1)),\"\")","v":0},"2014-12-31",null,2018,"2018-01-01","2018-03-25","2018-12-31",null,null,"Normal Pension Age:",{"$f":"IF(Input!$D$8=\"Uniform\",Input!$D$12,IF(Input!$D$8=\"Retained Firefighter\",55,66))","v":66},null,2013,null,null,230.3,null,"OFFSET"]
[null,"Pension rate:",null,null,null,null,1.2500000000000001E-2,null,">34500 - <=€60000",60000,3.3300000000000003E-2,null,2015,1E-3,null,2015,{"$f":"IFERROR(IF(Input!$D$28=P6,0.5,IF(Input!$D$28>Calculation!P6,0,1)),\"\")","v":0},"2015-12-31",null,2019,"2019-01-01","2019-03-24","2019-12-31",null,null,"Projected service from current date forward (plus one year):",{"$f":"AA5-(YEAR(NOW())-Input!D24)+1","v":33},null,2014,null,null,230.3]
[null,"Low-pay rate:",null,null,null,null,5.7999999999999996E-3,null,">€60,000",null,3.5000000000000003E-2,null,2016,0,null,2016,{"$f":"IFERROR(IF(Input!$D$28=P7,0.5,IF(Input!$D$28>Calculation!P7,0,1)),\"\")","v":0},"2016-12-31",null,2020,"2020-01-01",null,"2020-12-31",null,null,"Year of Retirement",{"$f":"Input!D24+$AA$5","v":2056},null,2015,null,null,230.3]
[null,"PR",null,null,null,null,0.03,null,null,null,null,null,2017,4.0000000000000001E-3,null,2017,{"$f":"IFERROR(IF(Input!$D$28=P8,0.5,IF(Input!$D$28>Calculation!P8,0,1)),\"\")","v":0},"2017-12-31",null,2021,"2021-01-01",null,"2021-12-31",null,null,null,null,null,2016,null,null,233.3]
[null,"NPR",null,null,null,null,3.5000000000000003E-2,null,null,null,null,null,2018,7.0000000000000001E-3,null,2018,{"$f":"IFERROR(IF(Input!$D$28=P9,0.5,IF(Input!$D$28>Calculation!P9,0,1)),\"\")","v":0},"2018-12-31",null,2022,"2022-01-01","2022-01-07","2022-12-31",null,null,"Benefits",null,null,2017,"2017-01-01","2017-03-08",233.3]
[null,"State Pension (€)",null,null,null,null,null,null,null,null,null,null,2019,1.2999999999999999E-2,null,2019,{"$f":"IFERROR(IF(Input!$D$28=P10,0.5,IF(Input!$D$28>Calculation!P10,0,1)),\"\")","v":0},"2019-12-31",null,2023,"2023-01-01","2023-01-06","2023-12-31",null,null,"Projected Pension",{"$f":"SUM(P32:P90)","v":64353.68978413834}]
[null,"Weekly rate:",null,null,null,null,{"$f":"IF(TODAY()<AD19,AF18,AF19)","v":277.3},null,null,null,null,null,2020,0,null,2020,{"$f":"IFERROR(IF(Input!$D$28=P11,0.5,IF(Input!$D$28>Calculation!P11,0,1)),\"\")","v":0},"2020-12-31",null,null,null,null,null,null,null,null,null,null,2017,"2017-03-09","2017-12-31",238.3]
[null,null,null,null,null,null,null,null,null,null,null,null,2021,5.5E-2,null,2021,{"$f":"IFERROR(IF(Input!$D$28=P12,0.5,IF(Input!$D$28>Calculation!P12,0,1)),\"\")","v":0},"2021-12-31",null,null,null,null,null,null,null,"Projected Lump Sum",{"$f":"SUM(N32:N90)","v":271364.85505769105},null,2018,"2018-01-01","2018-03-25",238.3]
[null,null,null,null,null,null,null,null,null,null,null,null,2022,8.2000000000000003E-2,null,2022,{"$f":"IFERROR(IF(Input!$D$28=P13,0.5,IF(Input!$D$28>Calculation!P13,0,1)),\"\")","v":0},"2022-12-31",null,null,null,null,null,null,null,null,null,null,2018,"2018-03-26","2019-03-24",243.3]
[null,"Annual rate:",null,null,null,null,{"$f":"G11*52.18","v":14469.514000000001},null,null,null,null,null,2023,4.5999999999999999E-2,null,2023,{"$f":"IFERROR(IF(Input!$D$28=P14,0.5,IF(Input!$D$28>Calculation!P14,0,1)),\"\")","v":0},{"$f":"TODAY()","v":"2024-06-20"},null,null,null,null,null,null,null,"PV Pension",{"$f":"IF(OR(AD21=\"Judge\",AD21=\"TD/Senator\"),MIN($AA$10*(1+$G$21)^-($AA$6-1),$D$40*0.5),$AA$10*(1+$G$21)^-($AA$6-1))","v":29201.809274473118},null,2019,"2019-03-25",null,248.3]
[null,3.74,"* annual",null,null,null,{"$f":"G14*B15","v":54115.982360000009},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PV Lump Sum",{"$f":"IF(OR(AD21=\"Judge\",AD21=\"TD/Senator\"), MIN($AA$12*(1+$G$21)^-($AA$6-1),1.5*$D$40),$AA$12*(1+$G$21)^-($AA$6-1))","v":123137.37981101588},null,2020,null,null,248.3]
[null,"Annual rate of increase (nominal)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,null,"2022-01-06",248.3]
[null,"Salary (€)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contributions",null,null,2022,"2022-01-07",null,253.3]
[null,"Annual rate of increase (nominal)",null,null,null,null,{"$f":"G19+G20","v":3.5000000000000003E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PV EE CONT",{"$f":"SUM(K45:K90)","v":251381.9280941555},null,2023,"2023-01-06",null,265.3]
[null,"Real and Promotional pay growth",null,null,null,null,0.02,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PV EE CONT+ASC",{"$f":"SUM(L45:L90)","v":378962.87772398262},null,2024,"2024-01-05",null,277.3]
[null,"Inflation",null,null,null,null,1.4999999999999999E-2]
[null,"Deflation Factor",null,null,null,null,2.5000000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contributions",null,null,"Membership Type",{"$f":"Input!D8","v":"Standard"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PV EE CONT",{"$f":"SUM(K45:K49)","v":28346.572170157022}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PV EE CONT+ASC",{"$f":"SUM(L45:L49)","v":40398.552286208549}]
[]
[]
[null,"YEAR",null,"PROJECTED SALARY",null,null,null,"EE CONT",null,"ASC","PV EE CONT","PV EE CONT + ASC","Lump Sum",null,"Scheme Pension"]
[null,null,"% of Year Worked",null,"Offset","3.74*Offset","NPR","PR","NPR",null,null,null,"Accrued per year","Uprated with CPI","Accrued per year","Uprated with CPI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,{"$f":"$G$8","v":0.03},{"$f":"$G$9","v":3.5000000000000003E-2},{"$f":"SUM(J45:J90)","v":171086.40508381362}]
[]
[]
[null,2013,{"$f":"IFERROR(IF(Input!$D$28=B32,0.5,IF(Input!$D$28>Calculation!B32,0,1)),\"\")","v":0},{"$f":"IF(Input!$D$28>Calculation!B32,0,Input!E33)","v":0},{"$f":"230.3*52.18*2","v":24034.108},{"$f":"E32/2*$B$15","v":44943.78196},{"$f":"IFERROR(MAX(D32-E32,0),\"\")","v":0},null,null,null,null,null,{"$f":"IFERROR($G$5*(D32*MAX(Input!D33,0)*C32),\"\")","v":0},{"$f":"IFERROR(M32*(1+$N$5)*(1+$N$6)*(1+$N$7)*(1+$N$8)*(1+N$9)*(1+N$10)*(1+$N$11)*(1+$N$12)*(1+$N$13)*(1+$N$14)*(1+$G$20)^($AA$7-2023-1),\"\")","v":0},{"$f":"IFERROR(IF(D32<F32,D32*$G$7,((D32-F32)*$G$6)+($F32*$G$7))*MAX(Input!D33,0)*C32, \"\")","v":0},{"$f":"IFERROR(O32*(1+$N$5)*(1+$N$6)*(1+$N$7)*(1+$N$8)*(1+N$9)*(1+N$10)*(1+N$11)*(1+$N$12)*(1+$N$13)*(1+$N$14)*(1+$G$20)^($AA$7-2023-1),\"\")","v":0}]
[null,2014,{"$f":"IFERROR(IF(Input!$D$28=B33,0.5,IF(Input!$D$28>Calculation!B33,0,1)),\"\")","v":0},{"$f":"IF(Input!$D$28>Calculation!B33,0,Input!E34)","v":0},{"$f":"230.3*52.18*2","v":24034.108},44943.78196,0,null,null,null,null,null,{"$f":"IFERROR($G$5*(D33*MAX(Input!D34,0)*C33),\"\")","v":0},{"$f":"IFERROR(M33*(1+$N$6)*(1+$N$7)*(1+$N$8)*(1+N$9)*(1+N$10)*(1+N$11)*(1+$N$12)*(1+$N$13)*(1+$N$14)*(1+$G$20)^($AA$7-2023-1),\"\")","v":0},{"$f":"IFERROR(IF(D33<F33,D33*$G$7,((D33-F33)*$G$6)+($F33*$G$7))*MAX(Input!D34,0)*C33, \"\")","v":0},{"$f":"IFERROR(O33*(1+$N$6)*(1+$N$7)*(1+$N$8)*(1+N$9)*(1+N$10)*(1+N$11)*(1+$N$12)*(1+$N$13)*(1+$N$14)*(1+$G$20)^($AA$7-2023-1),\"\")","v":0}]
[null,2015,{"$f":"IFERROR(IF(Input!$D$28=B34,0.5,IF(Input!$D$28>Calculation!B34,0,1)),\"\")","v":0},{"$f":"IF(Input!$D$28>Calculation!B34,0,Input!E35)","v":0},{"$f":"230.3*52.18*2","v":24034.108},44943.78196,0,null,null,null,null,null,{"$f":"IFERROR($G$5*(D34*MAX(Input!D35,0)*C34),\"\")","v":0},{"$f":"IFERROR(M34*(1+$N$7)*(1+$N$8)*(1+N$9)*(1+N$10)*(1+N$11)*(1+$N$12)*(1+$N$13)*(1+$N$14)*(1+$G$20)^($AA$7-2023-1),\"\")","v":0},{"$f":"IFERROR(IF(D34<F34,D34*$G$7,((D34-F34)*$G$6)+($F34*$G$7))*MAX(Input!D35,0)*C34, \"\")","v":0},{"$f":"IFERROR(O34*(1+$N$7)*(1+$N$8)*(1+N$9)*(1+N$10)*(1+N$11)*(1+$N$12)*(1+$N$13)*(1+$N$14)*(1+$G$20)^($AA$7-2023-1),\"\")","v":0}]
[null,2016,{"$f":"IFERROR(IF(Input!$D$28=B35,0.5,IF(Input!$D$28>Calculation!B35,0,1)),\"\")","v":0},{"$f":"IF(Input!$D$28>Calculation!B35,0,Input!E36)","v":0},{"$f":"233.3*52.18*2","v":24347.188000000002},45529.241560000009,0,null,null,null,null,null,{"$f":"IFERROR($G$5*(D35*MAX(Input!D36,0)*C35),\"\")","v":0},{"$f":"IFERROR(M35*(1+$N$8)*(1+N$9)*(1+N$10)*(1+N$11)*(1+$N$12)*(1+$N$13)*(1+$N$14)*(1+$G$20)^($AA$7-2023-1),\"\")","v":0},{"$f":"IFERROR(IF(D35<F35,D35*$G$7,((D35-F35)*$G$6)+($F35*$G$7))*MAX(Input!D36,0)*C35, \"\")","v":0},{"$f":"IFERROR(O35*(1+$N$8)*(1+N$9)*(1+N$10)*(1+N$11)*(1+$N$12)*(1+$N$13)*(1+$N$14)*(1+$G$20)^($AA$7-2023-1),\"\")","v":0}]
[null,2017,{"$f":"IFERROR(IF(Input!$D$28=B36,0.5,IF(Input!$D$28>Calculation!B36,0,1)),\"\")","v":0},{"$f":"IF(Input!$D$28>Calculation!B36,0,Input!E37)","v":0},{"$f":" (YEARFRAC(U4,V4)*233.3+YEARFRAC(V4,W4)*238.3)*52.18*2","v":24770.425777777778},46320.696204444452,0,null,null,null,null,null,{"$f":"IFERROR($G$5*(D36*MAX(Input!D37,0)*C36),\"\")","v":0},{"$f":"IFERROR(M36*(1+$N$9)*(1+N$10)*(1+N$11)*(1+$N$12)*(1+$N$13)*(1+$N$14)*(1+$G$20)^($AA$7-2023-1),\"\")","v":0},{"$f":"IFERROR(IF(D36<F36,D36*$G$7,((D36-F36)*$G$6)+($F36*$G$7))*MAX(Input!D37,0)*C36, \"\")","v":0},{"$f":"IFERROR(O36*(1+$N$9)*(1+N$10)*(1+N$11)*(1+$N$12)*(1+$N$13)*(1+$N$14)*(1+$G$20)^($AA$7-2023-1),\"\")","v":0}]
[null,2018,{"$f":"IFERROR(IF(Input!$D$28=B37,0.5,IF(Input!$D$28>Calculation!B37,0,1)),\"\")","v":0},{"$f":"IF(Input!$D$28>Calculation!B37,0,Input!E38)","v":0},{"$f":" (YEARFRAC(U5,V5)*238.3+YEARFRAC(V5,W5)*243.3)*52.18*2","v":25269.03466666667},47253.094826666675,0,null,null,null,null,null,{"$f":"IFERROR($G$5*(D37*MAX(Input!D38,0)*C37),\"\")","v":0},{"$f":"IFERROR(M37*(1+N$10)*(1+N$11)*(1+$N$12)*(1+$N$13)*(1+$N$14)*(1+$G$20)^($AA$7-2023-1),\"\")","v":0},{"$f":"IFERROR(IF(D37<F37,D37*$G$7,((D37-F37)*$G$6)+($F37*$G$7))*MAX(Input!D38,0)*C37, \"\")","v":0},{"$f":"IFERROR(O37*(1+N$10)*(1+N$11)*(1+$N$12)*(1+$N$13)*(1+$N$14)*(1+$G$20)^($AA$7-2023-1),\"\")","v":0}]
[null,2019,{"$f":"IFERROR(IF(Input!$D$28=B38,0.5,IF(Input!$D$28>Calculation!B38,0,1)),\"\")","v":0},{"$f":"IF(Input!$D$28>Calculation!B38,0,Input!E39)","v":0},{"$f":"(YEARFRAC(U6,V6)*243.3+YEARFRAC(V6,W6)*248.3)*52.18*2","v":25792.284111111112},48231.571287777784,0,null,null,null,null,null,{"$f":"IFERROR($G$5*(D38*MAX(Input!D39,0)*C38),\"\")","v":0},{"$f":"IFERROR(M38*(1+N$11)*(1+$N$12)*(1+$N$13)*(1+$N$14)*(1+$G$20)^($AA$7-2023-1),\"\")","v":0},{"$f":"IFERROR(IF(D38<F38,D38*$G$7,((D38-F38)*$G$6)+($F38*$G$7))*MAX(Input!D39,0)*C38, \"\")","v":0},{"$f":"IFERROR(O38*(1+N$11)*(1+$N$12)*(1+$N$13)*(1+$N$14)*(1+$G$20)^($AA$7-2023-1),\"\")","v":0}]
[null,2020,{"$f":"IFERROR(IF(Input!$D$28=B39,0.5,IF(Input!$D$28>Calculation!B39,0,1)),\"\")","v":0},{"$f":"IF(Input!$D$28>Calculation!B39,0,Input!E40)","v":0},{"$f":" $AF$15*52.18*2","v":25912.588},48456.539560000005,0,null,null,null,null,null,{"$f":"IFERROR($G$5*(D39*MAX(Input!D40,0)*C39),\"\")","v":0},{"$f":"IFERROR(M39*(1+$N$12)*(1+$N$13)*(1+$N$14)*(1+$G$20)^($AA$7-2023-1),\"\")","v":0},{"$f":"IFERROR(IF(D39<F39,D39*$G$7,((D39-F39)*$G$6)+($F39*$G$7))*MAX(Input!D40,0)*C39, \"\")","v":0},{"$f":"IFERROR(O39*(1+$N$12)*(1+$N$13)*(1+$N$14)*(1+$G$20)^($AA$7-2023-1),\"\")","v":0}]
[null,2021,{"$f":"IFERROR(IF(Input!$D$28=B40,0.5,IF(Input!$D$28>Calculation!B40,0,1)),\"\")","v":0},{"$f":"IF(Input!$D$28>Calculation!B40,0,Input!E41)","v":0},{"$f":" $AF$16*52.18*2","v":25912.588},48456.539560000005,0,null,null,null,null,null,{"$f":"IFERROR($G$5*(D40*MAX(Input!D41,0)*C40),\"\")","v":0},{"$f":"IFERROR(M40*(1+$N$13)*(1+$N$14)*(1+$G$20)^($AA$7-2023-1),\"\")","v":0},{"$f":"IFERROR(IF(D40<F40,D40*$G$7,((D40-F40)*$G$6)+($F40*$G$7))*MAX(Input!D41,0)*C40, \"\")","v":0},{"$f":"IFERROR(O40*(1+$N$13)*(1+$N$14)*(1+$G$20)^($AA$7-2023-1),\"\")","v":0}]
[null,2022,{"$f":"IFERROR(IF(Input!$D$28=B41,0.5,IF(Input!$D$28>Calculation!B41,0,1)),\"\")","v":0},{"$f":"IF(Input!$D$28>Calculation!B41,0,Input!E42)","v":0},{"$f":" (YEARFRAC(U9,V9)*AF16+YEARFRAC(V9,W9)*AF17)*52.18*2","v":26425.691333333329},49416.042793333327,{"$f":"IFERROR(MAX(D41-E41,0),\"\")","v":0},null,null,null,null,null,{"$f":"IFERROR($G$5*(D41*MAX(Input!D42,0)*C41),\"\")","v":0},{"$f":"IFERROR(M41*(1+$N$14)*(1+$G$20)^($AA$7-2023-1),\"\")","v":0},{"$f":"IFERROR(IF(D41<F41,D41*$G$7,((D41-F41)*$G$6)+($F41*$G$7))*MAX(Input!D42,0)*C41, \"\")","v":0},{"$f":"IFERROR(O41*(1+$N$14)*(1+$G$20)^($AA$7-2023-1),\"\")","v":0}]
[null,2023,{"$f":"IFERROR(IF(Input!$D$28=B42,0.5,IF(Input!$D$28>Calculation!B42,0,1)),\"\")","v":0},{"$f":"IF(Input!$D$28>Calculation!B42,0,Input!E43)","v":0},{"$f":" (YEARFRAC(U10,V10)*AF17+YEARFRAC(V10,W10)*AF18)*52.18*2","v":27669.314666666673},51741.618426666682,{"$f":"IFERROR(MAX(D42-E42,0),\"\")","v":0},null,null,null,null,null,{"$f":"IFERROR($G$5*(D42*MAX(Input!D43,0)*C42),\"\")","v":0},{"$f":"IFERROR(M42*(1+$G$20)^($AA$7-2023-1),\"\")","v":0},{"$f":"IFERROR(IF(D42<F42,D42*$G$7,((D42-F42)*$G$6)+($F42*$G$7))*MAX(Input!D43,0)*C42, \"\")","v":0},{"$f":"IFERROR(O42*(1+$G$20)^($AA$7-2023-1),\"\")","v":0}]
[null,2024,{"$f":"IFERROR(IF(Input!$D$28=B43,0.5,IF(Input!$D$28>Calculation!B43,0,1)),\"\")","v":0.5},{"$f":"IF(Input!$D$28>Calculation!B43,0,Input!D16)","v":100000},{"$f":"$G$11*52.18*2","v":28939.028000000002},{"$f":"E43/2*$B$15","v":54115.982360000009},{"$f":"IFERROR(MAX(D43-E43,0),\"\")","v":71060.971999999994},null,null,null,null,null,{"$f":"IFERROR($G$5*(D43*Input!$D$20*C43),\"\")","v":1875},{"$f":"IFERROR(M43*(1+$G$20)^($AA$7-2024-1),\"\")","v":2974.7370446216473},{"$f":"IFERROR(IF(D43<F43,D43*$G$7,((D43-F43)*$G$6)+($F$43*$G$7))*MAX(Input!$D$20,0)*C43,\"\")","v":443.71145909399996},{"$f":"IFERROR(O43*(1+$G$20)^($AA$7-2024-1),\"\")","v":703.95995439469039}]
[]
[null,1,{"$f":"IF(B45=\"\",\"\",1)","v":1},{"$f":"Input!D16","v":100000},{"$f":"G11*52.18*2","v":28939.028000000002},{"$f":"IF(B45=\"\",\"\",E45/2*$B$15)","v":54115.982360000009},{"$f":"IFERROR(MAX(D45-2*($G$14*((1+$G$19)*(+$G$20))^(B45-1)),0),\"\")","v":71060.971999999994},{"$f":"IFERROR($H$29*D45*Input!$D$20,\"\")","v":3000},{"$f":"IFERROR($I$29*G45*Input!$D$20,\"\")","v":2487.13402},{"$f":"IFERROR(IF(D45*Input!$D$20<=$J$5,$K$5*D45*Input!$D$20,IF(AND(D45*Input!$D$20>$J$5,D45*Input!$D$20<=$J$6),$K$6*(D45*Input!$D$20-$J$5),IF(D45*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D45*Input!$D$20-$J$6)))),\"\")","v":2249.1500000000005},{"$f":"IFERROR(SUM(H45:I45)*(1+$G$20)^(-B45+0.5),\"\")","v":5446.4377795169121},{"$f":"IFERROR(SUM(H45:J45)*(1+$G$20)^(-B45+0.5),\"\")","v":7678.906585117631},{"$f":"IFERROR($G$5*D46*Input!$D$20*C46,\"\")","v":3882.3749999999991},{"$f":"IFERROR(M45*(1+$G$20)^($AA$6-B45-2),\"\")","v":6068.46357102816},{"$f":"IFERROR(IF(B45=\"\",\"\",IF(D46<$G$15*(1+$G$18)^(B46-1),D46*$G$7,((D46-($G$15*(1+$G$18)^(B46-1)))*$G$6)+($G$15*(1+$G$18)^(B46-1)*$G$7)))*Input!$D$20*C46,\"\")","v":918.85772032457976},{"$f":"IFERROR(O45*(1+$G$20)^($AA$6-B45-2),\"\")","v":1436.2483280846634}]
[null,{"$f":"IF(B45=\"\",\"\",IF($AA$6>=B45+1,B45+1,\"\"))","v":2},{"$f":"IF(B46=\"\",\"\",1)","v":1},{"$f":"IF(B46=\"\",\"\",$D$45*(($G$19+1)*($G$20+1))^(B46-1))","v":103529.99999999999},{"$f":"IF(B46=\"\",\"\",$E$45*(($G$18+1))^(B46-1))","v":29951.893980000001},{"$f":"IF(B46=\"\",\"\",E46/2*$B$15)","v":56010.041742600006},{"$f":"IFERROR(D46-E46,\"\")","v":73578.106019999977},{"$f":"IFERROR($H$29*D46*Input!$D$20,\"\")","v":3105.8999999999996},{"$f":"IFERROR($I$29*G46*Input!$D$20,\"\")","v":2575.2337106999994},{"$f":"IFERROR(IF(D46*Input!$D$20<=$J$5,$K$5*D46*Input!$D$20,IF(AND(D46*Input!$D$20>$J$5,D46*Input!$D$20<=$J$6),$K$6*(D46*Input!$D$20-$J$5),IF(D46*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D46*Input!$D$20-$J$6)))),\"\")","v":2372.6999999999998},{"$f":"IFERROR(SUM(H46:I46)*(1+$G$20)^(-B46+0.5),\"\")","v":5555.6636840406381},7875.9616904572158,{"$f":"IFERROR($G$5*D47*Input!$D$20*C47,\"\")","v":4019.4228374999993},{"$f":"IFERROR(M46*(1+$G$20)^($AA$6-B46-2),\"\")","v":6189.8328424487254},{"$f":"IFERROR(IF(B46=\"\",\"\",IF(D47<$G$15*(1+$G$18)^(B47-1),D47*$G$7,((D47-($G$15*(1+$G$18)^(B47-1)))*$G$6)+($G$15*(1+$G$18)^(B47-1)*$G$7)))*Input!$D$20*C47,\"\")","v":951.40597803594005},{"$f":"IFERROR(O46*(1+$G$20)^($AA$6-B46-2),\"\")","v":1465.1466659356945}]
[null,{"$f":"IF(B46=\"\",\"\",IF($AA$6>=B46+1,B46+1,\"\"))","v":3},1,107184.60899999998,31000.210269299998,57970.393203590997,{"$f":"IFERROR(D47-E47,\"\")","v":76184.398730699992},{"$f":"IFERROR($H$29*D47*Input!$D$20,\"\")","v":3215.5382699999996},{"$f":"IFERROR($I$29*G47*Input!$D$20,\"\")","v":2666.4539555745},{"$f":"IFERROR(IF(D47*Input!$D$20<=$J$5,$K$5*D47*Input!$D$20,IF(AND(D47*Input!$D$20>$J$5,D47*Input!$D$20<=$J$6),$K$6*(D47*Input!$D$20-$J$5),IF(D47*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D47*Input!$D$20-$J$6)))),\"\")","v":2500.6113149999996},5667.0799618062365,8076.3256275667563,{"$f":"IFERROR($G$5*D48*Input!$D$20*C48,\"\")","v":4161.3084636637477},{"$f":"IFERROR(M47*(1+$G$20)^($AA$6-B47-2),\"\")","v":6313.6294992976973},{"$f":"IFERROR(IF(B47=\"\",\"\",IF(D48<$G$15*(1+$G$18)^(B48-1),D48*$G$7,((D48-($G$15*(1+$G$18)^(B48-1)))*$G$6)+($G$15*(1+$G$18)^(B48-1)*$G$7)))*Input!$D$20*C48,\"\")","v":985.10712955094766},1494.6263867267862]
[null,4,1,110968.22569769995,32085.217628725495,59999.356965716681,78883.00806897445,{"$f":"IFERROR($H$29*D48*Input!$D$20,\"\")","v":3329.0467709309983},{"$f":"IFERROR($I$29*G48*Input!$D$20,\"\")","v":2760.9052824141058},{"$f":"IFERROR(IF(D48*Input!$D$20<=$J$5,$K$5*D48*Input!$D$20,IF(AND(D48*Input!$D$20>$J$5,D48*Input!$D$20<=$J$6),$K$6*(D48*Input!$D$20-$J$5),IF(D48*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D48*Input!$D$20-$J$6)))),\"\")","v":2633.0378994194984},5780.7305356509814,8280.0741188800239,{"$f":"IFERROR($G$5*D49*Input!$D$20*C49,\"\")","v":4308.2026524310786},6439.9020892836543,{"$f":"IFERROR(IF(B48=\"\",\"\",IF(D49<$G$15*(1+$G$18)^(B49-1),D49*$G$7,((D49-($G$15*(1+$G$18)^(B49-1)))*$G$6)+($G$15*(1+$G$18)^(B49-1)*$G$7)))*Input!$D$20*C49,\"\")","v":1020.0020099315973},1524.6991854306937]
[null,5,1,114885.40406482876,33208.200245730884,62099.334459516758,81677.203819097878,{"$f":"IFERROR($H$29*D49*Input!$D$20,\"\")","v":3446.5621219448626},{"$f":"IFERROR($I$29*G49*Input!$D$20,\"\")","v":2858.7021336684261},{"$f":"IFERROR(IF(D49*Input!$D$20<=$J$5,$K$5*D49*Input!$D$20,IF(AND(D49*Input!$D$20>$J$5,D49*Input!$D$20<=$J$6),$K$6*(D49*Input!$D$20-$J$5),IF(D49*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D49*Input!$D$20-$J$6)))),\"\")","v":2770.1391422690067},5896.6602091422537,8487.2842641869229,{"$f":"IFERROR($G$5*D50*Input!$D$20*C50,\"\")","v":4460.2822060618955},6568.7001310693277,{"$f":"IFERROR(IF(B49=\"\",\"\",IF(D50<$G$15*(1+$G$18)^(B50-1),D50*$G$7,((D50-($G$15*(1+$G$18)^(B50-1)))*$G$6)+($G$15*(1+$G$18)^(B50-1)*$G$7)))*Input!$D$20*C50,\"\")","v":1056.1329005444463},1555.3769922460065]
[null,6,1,118940.85882831721,34370.487254331463,64272.811165599836,84570.371573985758,{"$f":"IFERROR($H$29*D50*Input!$D$20,\"\")","v":3568.2257648495165},{"$f":"IFERROR($I$29*G50*Input!$D$20,\"\")","v":2959.9630050895016},{"$f":"IFERROR(IF(D50*Input!$D$20<=$J$5,$K$5*D50*Input!$D$20,IF(AND(D50*Input!$D$20>$J$5,D50*Input!$D$20<=$J$6),$K$6*(D50*Input!$D$20-$J$5),IF(D50*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D50*Input!$D$20-$J$6)))),\"\")","v":2912.0800589911028},6014.91468423691,8698.0345702849809,{"$f":"IFERROR($G$5*D51*Input!$D$20*C51,\"\")","v":4617.7301679358798},6700.074133690714,{"$f":"IFERROR(IF(B50=\"\",\"\",IF(D51<$G$15*(1+$G$18)^(B51-1),D51*$G$7,((D51-($G$15*(1+$G$18)^(B51-1)))*$G$6)+($G$15*(1+$G$18)^(B51-1)*$G$7)))*Input!$D$20*C51,\"\")","v":1093.543580284108},1586.6719773278066]
[null,7,1,123139.4711449568,35573.454308233064,66522.359556395837,87566.016836723735,{"$f":"IFERROR($H$29*D51*Input!$D$20,\"\")","v":3694.184134348704},{"$f":"IFERROR($I$29*G51*Input!$D$20,\"\")","v":3064.8105892853309},{"$f":"IFERROR(IF(D51*Input!$D$20<=$J$5,$K$5*D51*Input!$D$20,IF(AND(D51*Input!$D$20>$J$5,D51*Input!$D$20<=$J$6),$K$6*(D51*Input!$D$20-$J$5),IF(D51*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D51*Input!$D$20-$J$6)))),\"\")","v":3059.0314900734884},6135.5405792947768,8912.4049811943587,{"$f":"IFERROR($G$5*D52*Input!$D$20*C52,\"\")","v":4780.736042864015},6834.0756163645265,{"$f":"IFERROR(IF(B51=\"\",\"\",IF(D52<$G$15*(1+$G$18)^(B52-1),D52*$G$7,((D52-($G$15*(1+$G$18)^(B52-1)))*$G$6)+($G$15*(1+$G$18)^(B52-1)*$G$7)))*Input!$D$20*C52,\"\")","v":1132.279378610845},1618.5965556134468]
[null,8,1,127486.29447637375,36818.525209021216,68850.642140869677,90667.769267352531,{"$f":"IFERROR($H$29*D52*Input!$D$20,\"\")","v":3824.5888342912122},{"$f":"IFERROR($I$29*G52*Input!$D$20,\"\")","v":3173.3719243573387},{"$f":"IFERROR(IF(D52*Input!$D$20<=$J$5,$K$5*D52*Input!$D$20,IF(AND(D52*Input!$D$20>$J$5,D52*Input!$D$20<=$J$6),$K$6*(D52*Input!$D$20-$J$5),IF(D52*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D52*Input!$D$20-$J$6)))),\"\")","v":3211.1703066730815},6258.5854474532707,9130.476908948036,{"$f":"IFERROR($G$5*D53*Input!$D$20*C53,\"\")","v":4949.4960251771154},6970.7571286918192,{"$f":"IFERROR(IF(B52=\"\",\"\",IF(D53<$G$15*(1+$G$18)^(B53-1),D53*$G$7,((D53-($G$15*(1+$G$18)^(B53-1)))*$G$6)+($G$15*(1+$G$18)^(B53-1)*$G$7)))*Input!$D$20*C53,\"\")","v":1172.387230466511},1651.1633917453735]
[null,9,1,131986.56067138974,38107.173591336956,71260.414615800109,93879.38708005278,{"$f":"IFERROR($H$29*D53*Input!$D$20,\"\")","v":3959.5968201416922},{"$f":"IFERROR($I$29*G53*Input!$D$20,\"\")","v":3285.7785478018477},{"$f":"IFERROR(IF(D53*Input!$D$20<=$J$5,$K$5*D53*Input!$D$20,IF(AND(D53*Input!$D$20>$J$5,D53*Input!$D$20<=$J$6),$K$6*(D53*Input!$D$20-$J$5),IF(D53*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D53*Input!$D$20-$J$6)))),\"\")","v":3368.6796234986414},6384.0977953704542,9352.3332649691965,{"$f":"IFERROR($G$5*D54*Input!$D$20*C54,\"\")","v":5124.213234865867},7110.1722712656556,{"$f":"IFERROR(IF(B53=\"\",\"\",IF(D54<$G$15*(1+$G$18)^(B54-1),D54*$G$7,((D54-($G$15*(1+$G$18)^(B54-1)))*$G$6)+($G$15*(1+$G$18)^(B54-1)*$G$7)))*Input!$D$20*C54,\"\")","v":1213.9157331353567},1684.3854050929369]
[null,10,1,136645.6862630898,39440.924667033745,73754.529127353104,97204.761596056051,{"$f":"IFERROR($H$29*D54*Input!$D$20,\"\")","v":4099.3705878926939},{"$f":"IFERROR($I$29*G54*Input!$D$20,\"\")","v":3402.1666558619622},{"$f":"IFERROR(IF(D54*Input!$D$20<=$J$5,$K$5*D54*Input!$D$20,IF(AND(D54*Input!$D$20>$J$5,D54*Input!$D$20<=$J$6),$K$6*(D54*Input!$D$20-$J$5),IF(D54*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D54*Input!$D$20-$J$6)))),\"\")","v":3531.7490192081432},6512.1271023438767,9578.0584920479741,{"$f":"IFERROR($G$5*D55*Input!$D$20*C55,\"\")","v":5305.0979620566313},7252.3757166909691,{"$f":"IFERROR(IF(B54=\"\",\"\",IF(D55<$G$15*(1+$G$18)^(B55-1),D55*$G$7,((D55-($G$15*(1+$G$18)^(B55-1)))*$G$6)+($G$15*(1+$G$18)^(B55-1)*$G$7)))*Input!$D$20*C55,\"\")","v":1256.9152051185804},1718.2757748751883]
[null,11,1,141469.27898817684,40821.357030379921,76335.93764681046,100647.92195779692,{"$f":"IFERROR($H$29*D55*Input!$D$20,\"\")","v":4244.0783696453054},{"$f":"IFERROR($I$29*G55*Input!$D$20,\"\")","v":3522.6772685228925},{"$f":"IFERROR(IF(D55*Input!$D$20<=$J$5,$K$5*D55*Input!$D$20,IF(AND(D55*Input!$D$20>$J$5,D55*Input!$D$20<=$J$6),$K$6*(D55*Input!$D$20-$J$5),IF(D55*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D55*Input!$D$20-$J$6)))),\"\")","v":3700.5747645861898},6642.7238398127474,9807.7385969300194,{"$f":"IFERROR($G$5*D56*Input!$D$20*C56,\"\")","v":5492.3679201172299},7397.423231024788,{"$f":"IFERROR(IF(B55=\"\",\"\",IF(D56<$G$15*(1+$G$18)^(B56-1),D56*$G$7,((D56-($G$15*(1+$G$18)^(B56-1)))*$G$6)+($G$15*(1+$G$18)^(B56-1)*$G$7)))*Input!$D$20*C56,\"\")","v":1301.4377470939362},1752.8479453866887]
[null,12,1,146463.14453645947,42250.104526443218,79007.695464448829,104213.04001001625,{"$f":"IFERROR($H$29*D56*Input!$D$20,\"\")","v":4393.8943360937837},{"$f":"IFERROR($I$29*G56*Input!$D$20,\"\")","v":3647.4564003505693},{"$f":"IFERROR(IF(D56*Input!$D$20<=$J$5,$K$5*D56*Input!$D$20,IF(AND(D56*Input!$D$20>$J$5,D56*Input!$D$20<=$J$6),$K$6*(D56*Input!$D$20-$J$5),IF(D56*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D56*Input!$D$20-$J$6)))),\"\")","v":3875.3600587760816},6775.9394912511316,10041.461183529562,{"$f":"IFERROR($G$5*D57*Input!$D$20*C57,\"\")","v":5686.248507697368},7545.3716956452863,{"$f":"IFERROR(IF(B56=\"\",\"\",IF(D57<$G$15*(1+$G$18)^(B57-1),D57*$G$7,((D57-($G$15*(1+$G$18)^(B57-1)))*$G$6)+($G$15*(1+$G$18)^(B57-1)*$G$7)))*Input!$D$20*C57,\"\")","v":1347.5373050342357},1788.1156313283998]
[null,13,1,151633.29353859648,43728.858184868732,81772.964805704527,107904.43535372775,{"$f":"IFERROR($H$29*D57*Input!$D$20,\"\")","v":4548.9988061578943},{"$f":"IFERROR($I$29*G57*Input!$D$20,\"\")","v":3776.6552373804716},{"$f":"IFERROR(IF(D57*Input!$D$20<=$J$5,$K$5*D57*Input!$D$20,IF(AND(D57*Input!$D$20>$J$5,D57*Input!$D$20<=$J$6),$K$6*(D57*Input!$D$20-$J$5),IF(D57*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D57*Input!$D$20-$J$6)))),\"\")","v":4056.315273850877},6911.8265724600005,10279.315486779871,{"$f":"IFERROR($G$5*D58*Input!$D$20*C58,\"\")","v":5886.9730800190846},7696.2791295581919,{"$f":"IFERROR(IF(B57=\"\",\"\",IF(D58<$G$15*(1+$G$18)^(B58-1),D58*$G$7,((D58-($G$15*(1+$G$18)^(B58-1)))*$G$6)+($G$15*(1+$G$18)^(B58-1)*$G$7)))*Input!$D$20*C58,\"\")","v":1395.2697355612036},1824.0928232457718]
[null,14,1,156985.94880050892,45259.368221339122,84635.018573904163,111726.58057916979,{"$f":"IFERROR($H$29*D58*Input!$D$20,\"\")","v":4709.5784640152679},{"$f":"IFERROR($I$29*G58*Input!$D$20,\"\")","v":3910.430320270943},{"$f":"IFERROR(IF(D58*Input!$D$20<=$J$5,$K$5*D58*Input!$D$20,IF(AND(D58*Input!$D$20>$J$5,D58*Input!$D$20<=$J$6),$K$6*(D58*Input!$D$20-$J$5),IF(D58*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D58*Input!$D$20-$J$6)))),\"\")","v":4243.6582080178123},7050.4386522661289,10521.392407134343,{"$f":"IFERROR($G$5*D59*Input!$D$20*C59,\"\")","v":6094.7832297437571},7850.2047121493551,{"$f":"IFERROR(IF(B58=\"\",\"\",IF(D59<$G$15*(1+$G$18)^(B59-1),D59*$G$7,((D59-($G$15*(1+$G$18)^(B59-1)))*$G$6)+($G$15*(1+$G$18)^(B59-1)*$G$7)))*Input!$D$20*C59,\"\")","v":1444.6928736138473},1860.7937930761864]
[null,15,1,162527.55279316686,46843.446109085999,87597.244223990827,115684.10668408086,{"$f":"IFERROR($H$29*D59*Input!$D$20,\"\")","v":4875.8265837950057},{"$f":"IFERROR($I$29*G59*Input!$D$20,\"\")","v":4048.9437339428305},{"$f":"IFERROR(IF(D59*Input!$D$20<=$J$5,$K$5*D59*Input!$D$20,IF(AND(D59*Input!$D$20>$J$5,D59*Input!$D$20<=$J$6),$K$6*(D59*Input!$D$20-$J$5),IF(D59*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D59*Input!$D$20-$J$6)))),\"\")","v":4437.6143477608402},7191.830373636004,10767.784545731576,{"$f":"IFERROR($G$5*D60*Input!$D$20*C60,\"\")","v":6309.9290777537099},8007.2088063923411,{"$f":"IFERROR(IF(B59=\"\",\"\",IF(D60<$G$15*(1+$G$18)^(B60-1),D60*$G$7,((D60-($G$15*(1+$G$18)^(B60-1)))*$G$6)+($G$15*(1+$G$18)^(B60-1)*$G$7)))*Input!$D$20*C60,\"\")","v":1495.8666025133057},1898.2330998079481]
[null,16,1,168264.77540676561,48482.966722904006,90663.147771830496,119781.8086838616,{"$f":"IFERROR($H$29*D60*Input!$D$20,\"\")","v":5047.9432622029681},{"$f":"IFERROR($I$29*G60*Input!$D$20,\"\")","v":4192.3633039351562},{"$f":"IFERROR(IF(D60*Input!$D$20<=$J$5,$K$5*D60*Input!$D$20,IF(AND(D60*Input!$D$20>$J$5,D60*Input!$D$20<=$J$6),$K$6*(D60*Input!$D$20-$J$5),IF(D60*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D60*Input!$D$20-$J$6)))),\"\")","v":4638.4171392367971},7336.0574752130688,11018.58624023823,{"$f":"IFERROR($G$5*D61*Input!$D$20*C61,\"\")","v":6532.6695741984167},8167.3529825201895,{"$f":"IFERROR(IF(B60=\"\",\"\",IF(D61<$G$15*(1+$G$18)^(B61-1),D61*$G$7,((D61-($G$15*(1+$G$18)^(B61-1)))*$G$6)+($G$15*(1+$G$18)^(B61-1)*$G$7)))*Input!$D$20*C61,\"\")","v":1548.8529265090472},1936.4255952530702]
[null,17,1,174204.52197862446,50179.870558205635,93836.357943844545,124024.65142041881,{"$f":"IFERROR($H$29*D61*Input!$D$20,\"\")","v":5226.1356593587334},{"$f":"IFERROR($I$29*G61*Input!$D$20,\"\")","v":4340.8627997146586},{"$f":"IFERROR(IF(D61*Input!$D$20<=$J$5,$K$5*D61*Input!$D$20,IF(AND(D61*Input!$D$20>$J$5,D61*Input!$D$20<=$J$6),$K$6*(D61*Input!$D$20-$J$5),IF(D61*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D61*Input!$D$20-$J$6)))),\"\")","v":4846.3082692518565},7483.1768132867874,11273.893601383565,{"$f":"IFERROR($G$5*D62*Input!$D$20*C62,\"\")","v":6763.2728101676212},8330.7000421705943,{"$f":"IFERROR(IF(B61=\"\",\"\",IF(D62<$G$15*(1+$G$18)^(B62-1),D62*$G$7,((D62-($G$15*(1+$G$18)^(B62-1)))*$G$6)+($G$15*(1+$G$18)^(B62-1)*$G$7)))*Input!$D$20*C62,\"\")","v":1603.7160458942838},1975.386429936138]
[null,18,1,180353.9416044699,51936.166027742831,97120.630471879093,128417.77557672707,{"$f":"IFERROR($H$29*D62*Input!$D$20,\"\")","v":5410.6182481340966},{"$f":"IFERROR($I$29*G62*Input!$D$20,\"\")","v":4494.6221451854481},{"$f":"IFERROR(IF(D62*Input!$D$20<=$J$5,$K$5*D62*Input!$D$20,IF(AND(D62*Input!$D$20>$J$5,D62*Input!$D$20<=$J$6),$K$6*(D62*Input!$D$20-$J$5),IF(D62*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D62*Input!$D$20-$J$6)))),\"\")","v":5061.5379561564478},7633.2463842021689,11533.804550199911,{"$f":"IFERROR($G$5*D63*Input!$D$20*C63,\"\")","v":7002.0163403665365},8497.3140430140065,{"$f":"IFERROR(IF(B62=\"\",\"\",IF(D63<$G$15*(1+$G$18)^(B63-1),D63*$G$7,((D63-($G$15*(1+$G$18)^(B63-1)))*$G$6)+($G$15*(1+$G$18)^(B63-1)*$G$7)))*Input!$D$20*C63,\"\")","v":1660.5224347815999},2015.1310591015961]
[null,19,1,186720.43574310764,53753.931838713826,100519.85253839486,132966.50390439382,{"$f":"IFERROR($H$29*D63*Input!$D$20,\"\")","v":5601.6130722932285},{"$f":"IFERROR($I$29*G63*Input!$D$20,\"\")","v":4653.8276366537839},{"$f":"IFERROR(IF(D63*Input!$D$20<=$J$5,$K$5*D63*Input!$D$20,IF(AND(D63*Input!$D$20>$J$5,D63*Input!$D$20<=$J$6),$K$6*(D63*Input!$D$20-$J$5),IF(D63*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D63*Input!$D$20-$J$6)))),\"\")","v":5284.3652510087686},7786.3253472186043,11798.418855983618,{"$f":"IFERROR($G$5*D64*Input!$D$20*C64,\"\")","v":7249.1875171814745},8667.2603238742868,{"$f":"IFERROR(IF(B63=\"\",\"\",IF(D64<$G$15*(1+$G$18)^(B64-1),D64*$G$7,((D64-($G$15*(1+$G$18)^(B64-1)))*$G$6)+($G$15*(1+$G$18)^(B64-1)*$G$7)))*Input!$D$20*C64,\"\")","v":1719.3409216329924},2055.6752488418256]
[null,20,1,193311.66712483932,55635.319453068798,104038.04737723866,137676.34767177052,{"$f":"IFERROR($H$29*D64*Input!$D$20,\"\")","v":5799.3500137451792},{"$f":"IFERROR($I$29*G64*Input!$D$20,\"\")","v":4818.6721685119683},{"$f":"IFERROR(IF(D64*Input!$D$20<=$J$5,$K$5*D64*Input!$D$20,IF(AND(D64*Input!$D$20>$J$5,D64*Input!$D$20<=$J$6),$K$6*(D64*Input!$D$20-$J$5),IF(D64*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D64*Input!$D$20-$J$6)))),\"\")","v":5515.0583493693775},7942.4740478270442,12067.838174991317,{"$f":"IFERROR($G$5*D65*Input!$D$20*C65,\"\")","v":7505.0838365379805},8840.6055303517751,{"$f":"IFERROR(IF(B64=\"\",\"\",IF(D65<$G$15*(1+$G$18)^(B65-1),D65*$G$7,((D65-($G$15*(1+$G$18)^(B65-1)))*$G$6)+($G$15*(1+$G$18)^(B65-1)*$G$7)))*Input!$D$20*C65,\"\")","v":1780.2427726418655},2097.0350823484509]
[null,21,1,200135.56897434616,57582.555633926204,107679.37903544201,142553.01334041994,{"$f":"IFERROR($H$29*D65*Input!$D$20,\"\")","v":6004.0670692303847},{"$f":"IFERROR($I$29*G65*Input!$D$20,\"\")","v":4989.3554669146988},{"$f":"IFERROR(IF(D65*Input!$D$20<=$J$5,$K$5*D65*Input!$D$20,IF(AND(D65*Input!$D$20>$J$5,D65*Input!$D$20<=$J$6),$K$6*(D65*Input!$D$20-$J$5),IF(D65*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D65*Input!$D$20-$J$6)))),\"\")","v":5753.8949141021167},8101.7540415346311,12342.166089886485,{"$f":"IFERROR($G$5*D66*Input!$D$20*C66,\"\")","v":7770.0132959677703},9017.417640958809,{"$f":"IFERROR(IF(B65=\"\",\"\",IF(D66<$G$15*(1+$G$18)^(B66-1),D66*$G$7,((D66-($G$15*(1+$G$18)^(B66-1)))*$G$6)+($G$15*(1+$G$18)^(B66-1)*$G$7)))*Input!$D$20*C66,\"\")","v":1843.3017780679843},2139.2269662893418]
[null,22,1,207200.35455914054,59597.945081113612,111448.15730168245,147602.40947802694,{"$f":"IFERROR($H$29*D66*Input!$D$20,\"\")","v":6216.0106367742164},{"$f":"IFERROR($I$29*G66*Input!$D$20,\"\")","v":5166.0843317309436},{"$f":"IFERROR(IF(D66*Input!$D$20<=$J$5,$K$5*D66*Input!$D$20,IF(AND(D66*Input!$D$20>$J$5,D66*Input!$D$20<=$J$6),$K$6*(D66*Input!$D$20-$J$5),IF(D66*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D66*Input!$D$20-$J$6)))),\"\")","v":6001.162409569919},8264.2281181262406,12621.50814995182,{"$f":"IFERROR($G$5*D67*Input!$D$20*C67,\"\")","v":8044.2947653154333},9197.7659937779881,{"$f":"IFERROR(IF(B66=\"\",\"\",IF(D67<$G$15*(1+$G$18)^(B67-1),D67*$G$7,((D67-($G$15*(1+$G$18)^(B67-1)))*$G$6)+($G$15*(1+$G$18)^(B67-1)*$G$7)))*Input!$D$20*C67,\"\")","v":1908.5943416299608},2182.2676373138574]
[null,23,1,214514.52707507822,61683.873158952585,115348.84280724134,152830.65391612565,{"$f":"IFERROR($H$29*D67*Input!$D$20,\"\")","v":6435.4358122523463},{"$f":"IFERROR($I$29*G67*Input!$D$20,\"\")","v":5349.0728870643979},{"$f":"IFERROR(IF(D67*Input!$D$20<=$J$5,$K$5*D67*Input!$D$20,IF(AND(D67*Input!$D$20>$J$5,D67*Input!$D$20<=$J$6),$K$6*(D67*Input!$D$20-$J$5),IF(D67*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D67*Input!$D$20-$J$6)))),\"\")","v":6257.1584476277385},8429.9603264124598,12905.971912083121,{"$f":"IFERROR($G$5*D68*Input!$D$20*C68,\"\")","v":8328.2583705310644},9381.7213136535447,{"$f":"IFERROR(IF(B67=\"\",\"\",IF(D68<$G$15*(1+$G$18)^(B68-1),D68*$G$7,((D68-($G$15*(1+$G$18)^(B68-1)))*$G$6)+($G$15*(1+$G$18)^(B68-1)*$G$7)))*Input!$D$20*C68,\"\")","v":1976.1995730635401},2226.1741686888863]
[null,24,1,222086.88988082841,63842.808719515931,119386.0523054948,158244.08116131247,{"$f":"IFERROR($H$29*D68*Input!$D$20,\"\")","v":6662.6066964248521},{"$f":"IFERROR($I$29*G68*Input!$D$20,\"\")","v":5538.5428406459368},{"$f":"IFERROR(IF(D68*Input!$D$20<=$J$5,$K$5*D68*Input!$D$20,IF(AND(D68*Input!$D$20>$J$5,D68*Input!$D$20<=$J$6),$K$6*(D68*Input!$D$20-$J$5),IF(D68*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D68*Input!$D$20-$J$6)))),\"\")","v":6522.191145828996},8599.0159994737332,13195.666982580527,{"$f":"IFERROR($G$5*D69*Input!$D$20*C69,\"\")","v":8622.2458910108126},9569.3557399266174,{"$f":"IFERROR(IF(B68=\"\",\"\",IF(D69<$G$15*(1+$G$18)^(B69-1),D69*$G$7,((D69-($G$15*(1+$G$18)^(B69-1)))*$G$6)+($G$15*(1+$G$18)^(B69-1)*$G$7)))*Input!$D$20*C69,\"\")","v":2046.1993839578172},2270.9639770683375]
[null,25,1,229926.55709362167,66077.307024698966,123564.56413618708,163849.2500689227,{"$f":"IFERROR($H$29*D69*Input!$D$20,\"\")","v":6897.7967128086502},{"$f":"IFERROR($I$29*G69*Input!$D$20,\"\")","v":5734.7237524122947},{"$f":"IFERROR(IF(D69*Input!$D$20<=$J$5,$K$5*D69*Input!$D$20,IF(AND(D69*Input!$D$20>$J$5,D69*Input!$D$20<=$J$6),$K$6*(D69*Input!$D$20-$J$5),IF(D69*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D69*Input!$D$20-$J$6)))),\"\")","v":6796.5794982767584},8771.461780410682,13490.705059753725,{"$f":"IFERROR($G$5*D70*Input!$D$20*C70,\"\")","v":8926.6111709634915},9760.7428547251493,{"$f":"IFERROR(IF(B69=\"\",\"\",IF(D70<$G$15*(1+$G$18)^(B70-1),D70*$G$7,((D70-($G$15*(1+$G$18)^(B70-1)))*$G$6)+($G$15*(1+$G$18)^(B70-1)*$G$7)))*Input!$D$20*C70,\"\")","v":2118.6785869854416},2316.6548293987412]
[null,26,1,238042.96455902647,68390.012770563422,127889.32388095361,169652.95178846305,{"$f":"IFERROR($H$29*D70*Input!$D$20,\"\")","v":7141.288936770794},{"$f":"IFERROR($I$29*G70*Input!$D$20,\"\")","v":5937.8533125962076},{"$f":"IFERROR(IF(D70*Input!$D$20<=$J$5,$K$5*D70*Input!$D$20,IF(AND(D70*Input!$D$20>$J$5,D70*Input!$D$20<=$J$6),$K$6*(D70*Input!$D$20-$J$5),IF(D70*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D70*Input!$D$20-$J$6)))),\"\")","v":7080.6537595659265},8947.365648610652,13791.199977357415,{"$f":"IFERROR($G$5*D71*Input!$D$20*C71,\"\")","v":9241.7205452985017},9955.9577118196521,{"$f":"IFERROR(IF(B70=\"\",\"\",IF(D71<$G$15*(1+$G$18)^(B71-1),D71*$G$7,((D71-($G$15*(1+$G$18)^(B71-1)))*$G$6)+($G$15*(1+$G$18)^(B71-1)*$G$7)))*Input!$D$20*C71,\"\")","v":2193.7249986470279},2363.2648499637139]
[null,27,1,246445.88120796005,70783.663217533147,132365.45021678699,175662.2179904269,{"$f":"IFERROR($H$29*D71*Input!$D$20,\"\")","v":7393.376436238801},{"$f":"IFERROR($I$29*G71*Input!$D$20,\"\")","v":6148.1776296649423},{"$f":"IFERROR(IF(D71*Input!$D$20<=$J$5,$K$5*D71*Input!$D$20,IF(AND(D71*Input!$D$20>$J$5,D71*Input!$D$20<=$J$6),$K$6*(D71*Input!$D$20-$J$5),IF(D71*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D71*Input!$D$20-$J$6)))),\"\")","v":7374.7558422786024},9126.7969465409587,14097.267748874339,{"$f":"IFERROR($G$5*D72*Input!$D$20*C72,\"\")","v":9567.9532805475392},10155.076866056048,{"$f":"IFERROR(IF(B71=\"\",\"\",IF(D72<$G$15*(1+$G$18)^(B72-1),D72*$G$7,((D72-($G$15*(1+$G$18)^(B72-1)))*$G$6)+($G$15*(1+$G$18)^(B72-1)*$G$7)))*Input!$D$20*C72,\"\")","v":2271.4295456542036},2410.812527570075]
[null,28,1,255145.42081460104,73261.091430146815,136998.24097437455,181884.32938445423,{"$f":"IFERROR($H$29*D72*Input!$D$20,\"\")","v":7654.3626244380312},{"$f":"IFERROR($I$29*G72*Input!$D$20,\"\")","v":6365.9515284558993},{"$f":"IFERROR(IF(D72*Input!$D$20<=$J$5,$K$5*D72*Input!$D$20,IF(AND(D72*Input!$D$20>$J$5,D72*Input!$D$20<=$J$6),$K$6*(D72*Input!$D$20-$J$5),IF(D72*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D72*Input!$D$20-$J$6)))),\"\")","v":7679.2397285110364},9309.8264070792957,14409.026612662974,{"$f":"IFERROR($G$5*D73*Input!$D$20*C73,\"\")","v":9905.7020313508656},10358.178403377169,{"$f":"IFERROR(IF(B72=\"\",\"\",IF(D73<$G$15*(1+$G$18)^(B73-1),D73*$G$7,((D73-($G$15*(1+$G$18)^(B73-1)))*$G$6)+($G$15*(1+$G$18)^(B73-1)*$G$7)))*Input!$D$20*C73,\"\")","v":2351.8863750801547},2459.3167228784559]
[null,29,1,264152.05416935642,75825.229630201939,141793.17940847762,188326.82453915448,{"$f":"IFERROR($H$29*D73*Input!$D$20,\"\")","v":7924.5616250806925},{"$f":"IFERROR($I$29*G73*Input!$D$20,\"\")","v":6591.4388588704069},{"$f":"IFERROR(IF(D73*Input!$D$20<=$J$5,$K$5*D73*Input!$D$20,IF(AND(D73*Input!$D$20>$J$5,D73*Input!$D$20<=$J$6),$K$6*(D73*Input!$D$20-$J$5),IF(D73*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D73*Input!$D$20-$J$6)))),\"\")","v":7994.471895927476},9496.5261813920915,14726.597077987572,{"$f":"IFERROR($G$5*D74*Input!$D$20*C74,\"\")","v":10255.373313057553},10565.341971444715,{"$f":"IFERROR(IF(B73=\"\",\"\",IF(D74<$G$15*(1+$G$18)^(B74-1),D74*$G$7,((D74-($G$15*(1+$G$18)^(B74-1)))*$G$6)+($G$15*(1+$G$18)^(B74-1)*$G$7)))*Input!$D$20*C74,\"\")","v":2435.1929684110964},2508.7966758813213]
[null,30,1,273476.62168153474,78479.112667258989,146755.94068777433,194997.50901427574,{"$f":"IFERROR($H$29*D74*Input!$D$20,\"\")","v":8204.2986504460423},{"$f":"IFERROR($I$29*G74*Input!$D$20,\"\")","v":6824.9128154996515},{"$f":"IFERROR(IF(D74*Input!$D$20<=$J$5,$K$5*D74*Input!$D$20,IF(AND(D74*Input!$D$20>$J$5,D74*Input!$D$20<=$J$6),$K$6*(D74*Input!$D$20-$J$5),IF(D74*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D74*Input!$D$20-$J$6)))),\"\")","v":8320.8317588537175},9686.9698673718631,15050.101971948641,{"$f":"IFERROR($G$5*D75*Input!$D$20*C75,\"\")","v":10617.387991008482},10776.648810873608,{"$f":"IFERROR(IF(B74=\"\",\"\",IF(D75<$G$15*(1+$G$18)^(B75-1),D75*$G$7,((D75-($G$15*(1+$G$18)^(B75-1)))*$G$6)+($G$15*(1+$G$18)^(B75-1)*$G$7)))*Input!$D$20*C75,\"\")","v":2521.4502596367897},2559.2720135313411]
[null,31,1,283130.34642689285,81225.881610613069,151892.39861184644,201904.46481627977,{"$f":"IFERROR($H$29*D75*Input!$D$20,\"\")","v":8493.9103928067852},{"$f":"IFERROR($I$29*G75*Input!$D$20,\"\")","v":7066.6562685697927},{"$f":"IFERROR(IF(D75*Input!$D$20<=$J$5,$K$5*D75*Input!$D$20,IF(AND(D75*Input!$D$20>$J$5,D75*Input!$D$20<=$J$6),$K$6*(D75*Input!$D$20-$J$5),IF(D75*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D75*Input!$D$20-$J$6)))),\"\")","v":8658.7121249412503},9881.2325386446591,15379.666487332073,{"$f":"IFERROR($G$5*D76*Input!$D$20*C76,\"\")","v":10992.181787091078},10992.181787091078,{"$f":"IFERROR(IF(B75=\"\",\"\",IF(D76<$G$15*(1+$G$18)^(B76-1),D76*$G$7,((D76-($G$15*(1+$G$18)^(B76-1)))*$G$6)+($G$15*(1+$G$18)^(B76-1)*$G$7)))*Input!$D$20*C76,\"\")","v":2610.7627575231772},2610.7627575231772]
[null,32,1,293124.8476557621,84068.787466984519,157208.63256326105,209056.06018877757,{"$f":"IFERROR($H$29*D76*Input!$D$20,\"\")","v":8793.7454296728629},{"$f":"IFERROR($I$29*G76*Input!$D$20,\"\")","v":7316.9621066072159},{"$f":"IFERROR(IF(D76*Input!$D$20<=$J$5,$K$5*D76*Input!$D$20,IF(AND(D76*Input!$D$20>$J$5,D76*Input!$D$20<=$J$6),$K$6*(D76*Input!$D$20-$J$5),IF(D76*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D76*Input!$D$20-$J$6)))),\"\")","v":9008.5196679516739},10079.390774159177,15715.418231395806,{"$f":"IFERROR($G$5*D77*Input!$D$20*C77,\"\")","v":11380.205804175393},11212.025422832901,{"$f":"IFERROR(IF(B76=\"\",\"\",IF(D77<$G$15*(1+$G$18)^(B77-1),D77*$G$7,((D77-($G$15*(1+$G$18)^(B77-1)))*$G$6)+($G$15*(1+$G$18)^(B77-1)*$G$7)))*Input!$D$20*C77,\"\")","v":2703.2386722151978},2663.2893322317223]
[null,33,1,303472.1547780105,87011.195028328948,162710.93470297515,216460.95974968155,{"$f":"IFERROR($H$29*D77*Input!$D$20,\"\")","v":9104.1646433403148},{"$f":"IFERROR($I$29*G77*Input!$D$20,\"\")","v":7576.1335912388549},{"$f":"IFERROR(IF(D77*Input!$D$20<=$J$5,$K$5*D77*Input!$D$20,IF(AND(D77*Input!$D$20>$J$5,D77*Input!$D$20<=$J$6),$K$6*(D77*Input!$D$20-$J$5),IF(D77*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D77*Input!$D$20-$J$6)))),\"\")","v":9370.6754172303681},{"$f":"IFERROR(SUM(H77:I77)*(1+$G$20)^(-B77+0.5),\"\")","v":10281.522688369045},{"$f":"IFERROR(SUM(H77:J77)*(1+$G$20)^(-B77+0.5),\"\")","v":16057.487275612937},{"$f":"IFERROR($G$5*D78*Input!$D$20*C78,\"\")","v":""},{"$f":"IFERROR(M77*(1+$G$20)^($AA$6-B77-2),\"\")","v":""},{"$f":"IFERROR(IF(B77=\"\",\"\",IF(D78<$G$15*(1+$G$18)^(B78-1),D78*$G$7,((D78-($G$15*(1+$G$18)^(B78-1)))*$G$6)+($G$15*(1+$G$18)^(B78-1)*$G$7)))*Input!$D$20*C78,\"\")","v":""},{"$f":"IFERROR(O77*(1+$G$20)^($AA$6-B77-2),\"\")","v":""}]
[null,"","",{"$f":"IF(B78=\"\",\"\",$D$45*(($G$19+1)*($G$20+1))^(B78-1))","v":""},{"$f":"IF(B78=\"\",\"\",$E$45*(($G$18+1))^(B78-1))","v":""},"","",{"$f":"IFERROR($H$29*D78*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G78*Input!$D$20,\"\")","v":""},{"$f":"IFERROR(IF(D78*Input!$D$20<=$J$5,$K$5*D78*Input!$D$20,IF(AND(D78*Input!$D$20>$J$5,D78*Input!$D$20<=$J$6),$K$6*(D78*Input!$D$20-$J$5),IF(D78*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D78*Input!$D$20-$J$6)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D79*Input!$D$20*C79,\"\")","v":""},"",{"$f":"IFERROR(IF(B78=\"\",\"\",IF(D79<$G$15*(1+$G$18)^(B79-1),D79*$G$7,((D79-($G$15*(1+$G$18)^(B79-1)))*$G$6)+($G$15*(1+$G$18)^(B79-1)*$G$7)))*Input!$D$20*C79,\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D79*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G79*Input!$D$20,\"\")","v":""},{"$f":"IFERROR(IF(D79*Input!$D$20<=$J$5,$K$5*D79*Input!$D$20,IF(AND(D79*Input!$D$20>$J$5,D79*Input!$D$20<=$J$6),$K$6*(D79*Input!$D$20-$J$5),IF(D79*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D79*Input!$D$20-$J$6)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D80*Input!$D$20*C80,\"\")","v":""},"",{"$f":"IFERROR(IF(B79=\"\",\"\",IF(D80<$G$15*(1+$G$18)^(B80-1),D80*$G$7,((D80-($G$15*(1+$G$18)^(B80-1)))*$G$6)+($G$15*(1+$G$18)^(B80-1)*$G$7)))*Input!$D$20*C80,\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D80*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G80*Input!$D$20,\"\")","v":""},{"$f":"IFERROR(IF(D80*Input!$D$20<=$J$5,$K$5*D80*Input!$D$20,IF(AND(D80*Input!$D$20>$J$5,D80*Input!$D$20<=$J$6),$K$6*(D80*Input!$D$20-$J$5),IF(D80*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D80*Input!$D$20-$J$6)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D81*Input!$D$20*C81,\"\")","v":""},"",{"$f":"IFERROR(IF(B80=\"\",\"\",IF(D81<$G$15*(1+$G$18)^(B81-1),D81*$G$7,((D81-($G$15*(1+$G$18)^(B81-1)))*$G$6)+($G$15*(1+$G$18)^(B81-1)*$G$7)))*Input!$D$20*C81,\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D81*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G81*Input!$D$20,\"\")","v":""},{"$f":"IFERROR(IF(D81*Input!$D$20<=$J$5,$K$5*D81*Input!$D$20,IF(AND(D81*Input!$D$20>$J$5,D81*Input!$D$20<=$J$6),$K$6*(D81*Input!$D$20-$J$5),IF(D81*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D81*Input!$D$20-$J$6)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D82*Input!$D$20*C82,\"\")","v":""},"",{"$f":"IFERROR(IF(B81=\"\",\"\",IF(D82<$G$15*(1+$G$18)^(B82-1),D82*$G$7,((D82-($G$15*(1+$G$18)^(B82-1)))*$G$6)+($G$15*(1+$G$18)^(B82-1)*$G$7)))*Input!$D$20*C82,\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D82*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G82*Input!$D$20,\"\")","v":""},{"$f":"IFERROR(IF(D82*Input!$D$20<=$J$5,$K$5*D82*Input!$D$20,IF(AND(D82*Input!$D$20>$J$5,D82*Input!$D$20<=$J$6),$K$6*(D82*Input!$D$20-$J$5),IF(D82*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D82*Input!$D$20-$J$6)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D83*Input!$D$20*C83,\"\")","v":""},"",{"$f":"IFERROR(IF(B82=\"\",\"\",IF(D83<$G$15*(1+$G$18)^(B83-1),D83*$G$7,((D83-($G$15*(1+$G$18)^(B83-1)))*$G$6)+($G$15*(1+$G$18)^(B83-1)*$G$7)))*Input!$D$20*C83,\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D83*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G83*Input!$D$20,\"\")","v":""},{"$f":"IFERROR(IF(D83*Input!$D$20<=$J$5,$K$5*D83*Input!$D$20,IF(AND(D83*Input!$D$20>$J$5,D83*Input!$D$20<=$J$6),$K$6*(D83*Input!$D$20-$J$5),IF(D83*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D83*Input!$D$20-$J$6)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D84*Input!$D$20*C84,\"\")","v":""},"",{"$f":"IFERROR(IF(B83=\"\",\"\",IF(D84<$G$15*(1+$G$18)^(B84-1),D84*$G$7,((D84-($G$15*(1+$G$18)^(B84-1)))*$G$6)+($G$15*(1+$G$18)^(B84-1)*$G$7)))*Input!$D$20*C84,\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D84*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G84*Input!$D$20,\"\")","v":""},{"$f":"IFERROR(IF(D84*Input!$D$20<=$J$5,$K$5*D84*Input!$D$20,IF(AND(D84*Input!$D$20>$J$5,D84*Input!$D$20<=$J$6),$K$6*(D84*Input!$D$20-$J$5),IF(D84*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D84*Input!$D$20-$J$6)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D85*Input!$D$20*C85,\"\")","v":""},"",{"$f":"IFERROR(IF(B84=\"\",\"\",IF(D85<$G$15*(1+$G$18)^(B85-1),D85*$G$7,((D85-($G$15*(1+$G$18)^(B85-1)))*$G$6)+($G$15*(1+$G$18)^(B85-1)*$G$7)))*Input!$D$20*C85,\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D85*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G85*Input!$D$20,\"\")","v":""},{"$f":"IFERROR(IF(D85*Input!$D$20<=$J$5,$K$5*D85*Input!$D$20,IF(AND(D85*Input!$D$20>$J$5,D85*Input!$D$20<=$J$6),$K$6*(D85*Input!$D$20-$J$5),IF(D85*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D85*Input!$D$20-$J$6)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D86*Input!$D$20*C86,\"\")","v":""},"",{"$f":"IFERROR(IF(B85=\"\",\"\",IF(D86<$G$15*(1+$G$18)^(B86-1),D86*$G$7,((D86-($G$15*(1+$G$18)^(B86-1)))*$G$6)+($G$15*(1+$G$18)^(B86-1)*$G$7)))*Input!$D$20*C86,\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D86*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G86*Input!$D$20,\"\")","v":""},{"$f":"IFERROR(IF(D86*Input!$D$20<=$J$5,$K$5*D86*Input!$D$20,IF(AND(D86*Input!$D$20>$J$5,D86*Input!$D$20<=$J$6),$K$6*(D86*Input!$D$20-$J$5),IF(D86*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D86*Input!$D$20-$J$6)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D87*Input!$D$20*C87,\"\")","v":""},"",{"$f":"IFERROR(IF(B86=\"\",\"\",IF(D87<$G$15*(1+$G$18)^(B87-1),D87*$G$7,((D87-($G$15*(1+$G$18)^(B87-1)))*$G$6)+($G$15*(1+$G$18)^(B87-1)*$G$7)))*Input!$D$20*C87,\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D87*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G87*Input!$D$20,\"\")","v":""},{"$f":"IFERROR(IF(D87*Input!$D$20<=$J$5,$K$5*D87*Input!$D$20,IF(AND(D87*Input!$D$20>$J$5,D87*Input!$D$20<=$J$6),$K$6*(D87*Input!$D$20-$J$5),IF(D87*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D87*Input!$D$20-$J$6)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D88*Input!$D$20*C88,\"\")","v":""},"",{"$f":"IFERROR(IF(B87=\"\",\"\",IF(D88<$G$15*(1+$G$18)^(B88-1),D88*$G$7,((D88-($G$15*(1+$G$18)^(B88-1)))*$G$6)+($G$15*(1+$G$18)^(B88-1)*$G$7)))*Input!$D$20*C88,\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D88*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G88*Input!$D$20,\"\")","v":""},{"$f":"IFERROR(IF(D88*Input!$D$20<=$J$5,$K$5*D88*Input!$D$20,IF(AND(D88*Input!$D$20>$J$5,D88*Input!$D$20<=$J$6),$K$6*(D88*Input!$D$20-$J$5),IF(D88*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D88*Input!$D$20-$J$6)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D89*Input!$D$20*C89,\"\")","v":""},"",{"$f":"IFERROR(IF(B88=\"\",\"\",IF(D89<$G$15*(1+$G$18)^(B89-1),D89*$G$7,((D89-($G$15*(1+$G$18)^(B89-1)))*$G$6)+($G$15*(1+$G$18)^(B89-1)*$G$7)))*Input!$D$20*C89,\"\")","v":""},""]
[null,"","","","","",{"$f":"IFERROR(D89-E89,\"\")","v":""},{"$f":"IFERROR($H$29*D89*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G89*Input!$D$20,\"\")","v":""},{"$f":"IFERROR(IF(D89*Input!$D$20<=$J$5,$K$5*D89*Input!$D$20,IF(AND(D89*Input!$D$20>$J$5,D89*Input!$D$20<=$J$6),$K$6*(D89*Input!$D$20-$J$5),IF(D89*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D89*Input!$D$20-$J$6)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D90*Input!$D$20*C90,\"\")","v":""},"",{"$f":"IFERROR(IF(B89=\"\",\"\",IF(D90<$G$15*(1+$G$18)^(B90-1),D90*$G$7,((D90-($G$15*(1+$G$18)^(B90-1)))*$G$6)+($G$15*(1+$G$18)^(B90-1)*$G$7)))*Input!$D$20*C90,\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D90*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G90*Input!$D$20,\"\")","v":""},{"$f":"IFERROR(IF(D90*Input!$D$20<=$J$5,$K$5*D90*Input!$D$20,IF(AND(D90*Input!$D$20>$J$5,D90*Input!$D$20<=$J$6),$K$6*(D90*Input!$D$20-$J$5),IF(D90*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D90*Input!$D$20-$J$6)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D91*Input!$D$20*C91,\"\")","v":""},"",{"$f":"IFERROR(IF(B90=\"\",\"\",IF(D91<$G$15*(1+$G$18)^(B91-1),D91*$G$7,((D91-($G$15*(1+$G$18)^(B91-1)))*$G$6)+($G$15*(1+$G$18)^(B91-1)*$G$7)))*Input!$D$20*C91,\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D91*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G91*Input!$D$20,\"\")","v":""},{"$f":"IFERROR(IF(D91*Input!$D$20<=$J$5,$K$5*D91*Input!$D$20,IF(AND(D91*Input!$D$20>$J$5,D91*Input!$D$20<=$J$6),$K$6*(D91*Input!$D$20-$J$5),IF(D91*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D91*Input!$D$20-$J$6)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D92*Input!$D$20*C92,\"\")","v":""},"",{"$f":"IFERROR(IF(B91=\"\",\"\",IF(D92<$G$15*(1+$G$18)^(B92-1),D92*$G$7,((D92-($G$15*(1+$G$18)^(B92-1)))*$G$6)+($G$15*(1+$G$18)^(B92-1)*$G$7)))*Input!$D$20*C92,\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D92*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G92*Input!$D$20,\"\")","v":""},{"$f":"IFERROR(IF(D92*Input!$D$20<=$J$5,$K$5*D92*Input!$D$20,IF(AND(D92*Input!$D$20>$J$5,D92*Input!$D$20<=$J$6),$K$6*(D92*Input!$D$20-$J$5),IF(D92*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D92*Input!$D$20-$J$6)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D93*Input!$D$20*C93,\"\")","v":""},"",{"$f":"IFERROR(IF(B92=\"\",\"\",IF(D93<$G$15*(1+$G$18)^(B93-1),D93*$G$7,((D93-($G$15*(1+$G$18)^(B93-1)))*$G$6)+($G$15*(1+$G$18)^(B93-1)*$G$7)))*Input!$D$20*C93,\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D93*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G93*Input!$D$20,\"\")","v":""},{"$f":"IFERROR(IF(D93*Input!$D$20<=$J$5,$K$5*D93*Input!$D$20,IF(AND(D93*Input!$D$20>$J$5,D93*Input!$D$20<=$J$6),$K$6*(D93*Input!$D$20-$J$5),IF(D93*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D93*Input!$D$20-$J$6)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D94*Input!$D$20*C94,\"\")","v":""},"",{"$f":"IFERROR(IF(B93=\"\",\"\",IF(D94<$G$15*(1+$G$18)^(B94-1),D94*$G$7,((D94-($G$15*(1+$G$18)^(B94-1)))*$G$6)+($G$15*(1+$G$18)^(B94-1)*$G$7)))*Input!$D$20*C94,\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D94*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G94*Input!$D$20,\"\")","v":""},{"$f":"IFERROR(IF(D94*Input!$D$20<=$J$5,$K$5*D94*Input!$D$20,IF(AND(D94*Input!$D$20>$J$5,D94*Input!$D$20<=$J$6),$K$6*(D94*Input!$D$20-$J$5),IF(D94*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D94*Input!$D$20-$J$6)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D95*Input!$D$20*C95,\"\")","v":""},"",{"$f":"IFERROR(IF(B94=\"\",\"\",IF(D95<$G$15*(1+$G$18)^(B95-1),D95*$G$7,((D95-($G$15*(1+$G$18)^(B95-1)))*$G$6)+($G$15*(1+$G$18)^(B95-1)*$G$7)))*Input!$D$20*C95,\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D95*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G95*Input!$D$20,\"\")","v":""},{"$f":"IFERROR(IF(D95*Input!$D$20<=$J$5,$K$5*D95*Input!$D$20,IF(AND(D95*Input!$D$20>$J$5,D95*Input!$D$20<=$J$6),$K$6*(D95*Input!$D$20-$J$5),IF(D95*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D95*Input!$D$20-$J$6)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D96*Input!$D$20*C96,\"\")","v":""},"",{"$f":"IFERROR(IF(B95=\"\",\"\",IF(D96<$G$15*(1+$G$18)^(B96-1),D96*$G$7,((D96-($G$15*(1+$G$18)^(B96-1)))*$G$6)+($G$15*(1+$G$18)^(B96-1)*$G$7)))*Input!$D$20*C96,\"\")","v":""},""]
[null,{"$f":"IF(B95=\"\",\"\",IF($AA$6>=B95+1,B95+1,\"\"))","v":""},"","","","","",{"$f":"IFERROR($H$29*D96*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G96*Input!$D$20,\"\")","v":""},{"$f":"IFERROR(IF(D96*Input!$D$20<=$J$5,$K$5*D96*Input!$D$20,IF(AND(D96*Input!$D$20>$J$5,D96*Input!$D$20<=$J$6),$K$6*(D96*Input!$D$20-$J$5),IF(D96*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D96*Input!$D$20-$J$6)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D97*Input!$D$20*C97,\"\")","v":0},"",{"$f":"IFERROR(IF(B96=\"\",\"\",IF(D97<$G$15*(1+$G$18)^(B97-1),D97*$G$7,((D97-($G$15*(1+$G$18)^(B97-1)))*$G$6)+($G$15*(1+$G$18)^(B97-1)*$G$7)))*Input!$D$20*C97,\"\")","v":""},""]

{"sheet":"Version Control","index":5,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":true,"merged":[[1,1,2,1],[1,2,2,2],[6,1,9,1]]}
[]
[null,"Resource Toolkit","Single Scheme Administration Project (Phase 1)\nMember Resources"]
[]
[null,"Resource Name","Single Public Service Scheme Member's Estimator Tool (for all Grades)"]
[null,"Description","This Estimator Tool is designed to give a broad indication of the normal retirement benefits for a member of the Single Scheme at normal retirement age\n"]
[null,"Version  ","V1  (22/01/2021)"]
[null,"Version Comments","V1 test launch //2020 \nFormula for NRA was\n''=IF(Input!$D$8=\"Uniform\",Input!$D$12,IF(Input!D24<1949,65,IF(AND(Input!D24>=1949,Input!D24<1955),66,IF(AND(Input!D24>=1955,Input!D24<1961),67,68))))\nNOW IT IS\n''=IF(Input!$D$8=\"Uniform\",Input!$D$12,66)"]
[null,null,"Updated for 2020"]
[null,null,"CPI Rate of ???? Applied"]