{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Disclaimer","Input","Output","Assumptions","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":"row_number_cap","date_system":"1900"}

{"sheet":"Disclaimer","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null," "]

{"sheet":"Input","index":1,"n_rows":148,"n_cols":7,"rows_kept":148,"cut":false,"hidden":false,"merged":[[43,1,44,7],[0,1,2,7],[40,2,40,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]],"read":"row_number_cap"}
[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",null,{"$f":"IF(D8=\"\",\"Enter Member Type Here\",\"\")","v":"Enter Member Type Here"}]
[]
[]
[null,null,"Retirement Age"]
[null,null,"Retirement Age"]
[]
[]
[null,null,"Full-Time Gross Annual Pensionable Pay (€)"]
[null,null,"€",null,{"$f":"IF(E20=\"\",\"\",\"Enter Full-Time Annual Pensionable Pay here\")","v":"Enter Full-Time Annual Pensionable Pay here"}]
[null,null,"Include all of your approved pensionable allowances"]
[]
[null,null,"% Work Pattern or Full Time Equivalent (FTE)"]
[null,null,"%",null,{"$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":"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"}]
[null,null,"Enter your % work pattern, to a maximum of 100%"]
[]
[null,null,"Year of Birth"]
[null,null,"Year"]
[]
[]
[null,null,"Year of Entry to the Single Scheme"]
[null,null,"Year",null,"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,2013,1,"An Garda Síochána - Garda / Sergeant / Inspector / Superintendent - Retirement Age 55",50]
[null,null,2014,0.99,"Irish Prison Service - Prison Officer grades - Retirement Age 55",51,{"$f":"YEAR(NOW()) - 3","v":2018}]
[null,null,2015,0.98,"Local Authority Fire Service - Career Firefighter - Retirement Age 55",52,{"$f":"YEAR(NOW()) - 2","v":2019}]
[null,null,2016,0.97,"Permanent Defence Forces - Private / Corporal / Sergeant / Second Lieutenant / Lieutenant - Retirement Age 50",53,{"$f":"YEAR(NOW()) - 1","v":2020}]
[null,null,2017,0.96,"Permanent Defence Forces - CQMS / Company Sergeant / QMS / Sergeant Major - Retirement Age 56",54,{"$f":"YEAR(NOW())","v":2021}]
[null,null,2018,0.95,null,55,{"$f":"YEAR(NOW()) +1","v":2022}]
[null,null,2019,0.94,null,56,{"$f":"YEAR(NOW())+2","v":2023}]
[null,null,2020,0.93,null,57,{"$f":"YEAR(NOW())+3","v":2024}]
[null,null,2021,0.92,"Standard",58,{"$f":"YEAR(NOW()) +4","v":2025}]
[null,null,2022,0.91,"Uniform",59,{"$f":"YEAR(NOW())+5","v":2026}]
[null,null,2023,0.9,"Judge",60,{"$f":"YEAR(NOW())+6","v":2027}]
[null,null,2024,0.89,null,61,{"$f":"YEAR(NOW()) +7","v":2028}]
[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,null,null,0.48]
[null,null,null,0.47]
[null,null,null,0.46]
[null,null,null,0.45]
[null,null,null,0.44]
[null,null,null,0.43]
[null,null,null,0.42]
[null,null,null,0.41]
[null,null,null,0.4]
[null,null,null,0.39]
[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":"Output","index":2,"n_rows":54,"n_cols":8,"rows_kept":54,"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":" 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!H42+Calculation!I42","v":0}," ","€",{"$f":"Calculation!J42","v":0}]
[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 € in employee contributions and € 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":"Calculation!O40","v":0},"p.a.","€",{"$f":"Calculation!M40","v":0}]
[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 € towards your annual pension entitlement and € 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":66}]
[]
[null,null,"Single Scheme Retirement Lump Sum",null,null,"€",{"$f":"Calculation!AA15","v":0}]
[]
[null,null,"Single Scheme Annual Retirement Pension",null,null,"€",{"$f":"Calculation!AA14","v":0},"p.a."]
[]
[null,null,"Annual Contributory State Pension",null,null,"€",{"$f":"Calculation!G14","v":12956.294},"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.  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":"2021-05-25"}]
[]
[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":0},null,null,{"$f":"Input!D8","v":0}]
[null,null,"Full-Time Gross Annual Pensionable Pay (€)",null,null,null,{"$f":"Input!D16","v":0}]
[null,null,"% Work Pattern or Full Time Equivalent (FTE)",null,null,null,{"$f":"Input!D20","v":0}]
[null,null,"Year of Birth",null,null,null,{"$f":"Input!D24","v":0}]
[null,null,"Year of Entry to the Single Scheme",null,null,null,{"$f":"Input!D28","v":0}]
[]
[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}]

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

{"sheet":"Calculation","index":4,"n_rows":93,"n_cols":35,"rows_kept":93,"cut":false,"hidden":false,"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":1},"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":1},"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,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":1},"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":-1954},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":1},"2016-12-31",null,2020,"2020-01-01",null,"2020-12-31",null,null,"Year of Retirement",{"$f":"Input!D24+$AA$5","v":66},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":1},"2017-12-31",null,null,null,null,null,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":1},"2018-12-31",null,null,null,null,null,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":1},"2019-12-31",null,null,null,null,null,null,null,"Projected Pension",{"$f":"SUM(P32:P87)","v":0}]
[null,"Weekly rate:",null,null,null,null,{"$f":"IF(TODAY()<AE13,AF13,AF15)","v":248.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":1},"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,null,null,null,2021,{"$f":"IFERROR(IF(Input!$D$28=P12,0.5,IF(Input!$D$28>Calculation!P12,0,1)),\"\")","v":1},{"$f":"TODAY()","v":"2021-05-25"},null,null,null,null,null,null,null,"Projected Lump Sum",{"$f":"SUM(N32:N87)","v":0},null,2018,"2018-01-01","2018-03-25",238.3]
[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,2018,"2018-03-26","2019-03-24",243.3]
[null,"Annual rate:",null,null,null,null,{"$f":"G11*52.18","v":12956.294},null,"Appear On Outputs Tab",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PV Pension",{"$f":"IF(OR(AD17=\"Judge\",AD17=\"TD/Senator\"),MIN($AA$10*(1+$G$21)^-($AA$6-1),$D$40*0.5),$AA$10*(1+$G$21)^-($AA$6-1))","v":0},null,2019,"2019-03-25",null,248.3]
[null,3.74,"* annual",null,null,null,{"$f":"G14*B15","v":48456.539560000005},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PV Lump Sum",{"$f":"IF(OR(AD17=\"Judge\",AD17=\"TD/Senator\"), MIN($AA$12*(1+$G$21)^-($AA$6-1),1.5*$D$40),$AA$12*(1+$G$21)^-($AA$6-1))","v":0},null,2020,null,null,248.3]
[null,"Annual rate of increase (nominal)"]
[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,"Membership Type",{"$f":"Input!D8","v":0}]
[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(K42:K87)","v":0}]
[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(L42:L87)","v":0}]
[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,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(K42:K46)","v":0}]
[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(L42:L46)","v":0}]
[]
[]
[null,"YEAR",null,"PROJECTED SALARY",null,null,null,"EE CONT",null,"ASC","PV EE CONT","PV EE CONT + PRD/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(J42:J87)","v":0}]
[]
[]
[null,2013,{"$f":"IFERROR(IF(Input!$D$28=B32,0.5,IF(Input!$D$28>Calculation!B32,0,1)),\"\")","v":1},{"$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+$G$20)^($AA$7-2020-1),\"\")","v":0},{"$f":"IFERROR(IF(D32<F32,D32*$G$7,((D32-F32)*$G$6)+($F$38*$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+$G$20)^($AA$7-2020-1),\"\")","v":0}]
[null,2014,{"$f":"IFERROR(IF(Input!$D$28=B33,0.5,IF(Input!$D$28>Calculation!B33,0,1)),\"\")","v":1},{"$f":"IF(Input!$D$28>Calculation!B33,0,Input!E34)","v":0},{"$f":"230.3*52.18*2","v":24034.108},{"$f":"E33/2*$B$15","v":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+$G$20)^($AA$7-2020-1),\"\")","v":0},{"$f":"IFERROR(IF(D33<F33,D33*$G$7,((D33-F33)*$G$6)+($F$38*$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+$G$20)^($AA$7-2020-1),\"\")","v":0}]
[null,2015,{"$f":"IFERROR(IF(Input!$D$28=B34,0.5,IF(Input!$D$28>Calculation!B34,0,1)),\"\")","v":1},{"$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+$G$20)^($AA$7-2020-1),\"\")","v":0},{"$f":"IFERROR(IF(D34<F34,D34*$G$7,((D34-F34)*$G$6)+($F$38*$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+$G$20)^($AA$7-2020-1),\"\")","v":0}]
[null,2016,{"$f":"IFERROR(IF(Input!$D$28=B35,0.5,IF(Input!$D$28>Calculation!B35,0,1)),\"\")","v":1},{"$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+$G$20)^($AA$7-2020-1),\"\")","v":0},{"$f":"IFERROR(IF(D35<F35,D35*$G$7,((D35-F35)*$G$6)+($F$38*$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+$G$20)^($AA$7-2020-1),\"\")","v":0}]
[null,2017,{"$f":"IFERROR(IF(Input!$D$28=B36,0.5,IF(Input!$D$28>Calculation!B36,0,1)),\"\")","v":1},{"$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+$G$20)^($AA$7-2020-1),\"\")","v":0},{"$f":"IFERROR(IF(D36<F36,D36*$G$7,((D36-F36)*$G$6)+($F$38*$G$7))*MAX(Input!D37,0)*C36, \"\")","v":0},{"$f":"IFERROR(O36*(1+$N$9)*(1+N$10)*(1+N$11)*(1+$G$20)^($AA$7-2020-1),\"\")","v":0}]
[null,2018,{"$f":"IFERROR(IF(Input!$D$28=B37,0.5,IF(Input!$D$28>Calculation!B37,0,1)),\"\")","v":1},{"$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},{"$f":"E37/2*$B$15","v":47253.094826666675},{"$f":"IFERROR(MAX(D37-E37,0),\"\")","v":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+$G$20)^($AA$7-2020-1),\"\")","v":0},{"$f":"IFERROR(IF(D37<F37,D37*$G$7,((D37-F37)*$G$6)+($F$38*$G$7))*MAX(Input!D38,0)*C37, \"\")","v":0},{"$f":"IFERROR(O37*(1+N$10)*(1+N$11)*(1+$G$20)^($AA$7-2020-1),\"\")","v":0}]
[null,2019,{"$f":"IFERROR(IF(Input!$D$28=B38,0.5,IF(Input!$D$28>Calculation!B38,0,1)),\"\")","v":1},{"$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},{"$f":"E38/2*$B$15","v":48231.571287777784},{"$f":"IFERROR(MAX(D38-E38,0),\"\")","v":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+$G$20)^($AA$7-2020-1),\"\")","v":0},{"$f":"IFERROR(IF(D38<F38,D38*$G$7,((D38-F38)*$G$6)+($F$38*$G$7))*MAX(Input!D39,0)*C38, \"\")","v":0},{"$f":"IFERROR(O38*(1+N$11)*(1+$G$20)^($AA$7-2020-1),\"\")","v":0}]
[null,2020,{"$f":"IFERROR(IF(Input!$D$28=B39,0.5,IF(Input!$D$28>Calculation!B39,0,1)),\"\")","v":1},{"$f":"IF(Input!$D$28>Calculation!B39,0,Input!E40)","v":0},{"$f":" $G$11*52.18*2","v":25912.588},{"$f":"E39/2*$B$15","v":48456.539560000005},{"$f":"IFERROR(MAX(D39-E39,0),\"\")","v":0},null,null,null,null,null,{"$f":"IFERROR($G$5*(D39*MAX(Input!D40,0)*C39),\"\")","v":0},{"$f":"IFERROR(M39*(1+$G$20)^($AA$7-2020-1),\"\")","v":0},{"$f":"IFERROR(IF(D39<F39,D39*$G$7,((D39-F39)*$G$6)+($F$38*$G$7))*MAX(Input!D40,0)*C39, \"\")","v":0},{"$f":"IFERROR(O39*(1+$G$20)^($AA$7-2020-1),\"\")","v":0}]
[null,2021,{"$f":"IFERROR(IF(Input!$D$28=B40,0.5,IF(Input!$D$28>Calculation!B40,0,1)),\"\")","v":1},{"$f":"IF(Input!$D$28>Calculation!B40,0,Input!D16)","v":0},{"$f":" $G$11*52.18*2","v":25912.588},{"$f":"E40/2*$B$15","v":48456.539560000005},{"$f":"IFERROR(MAX(D40-E40,0),\"\")","v":0},null,null,null,null,null,{"$f":"IFERROR($G$5*(D40*Input!$D$20*C40),\"\")","v":0},{"$f":"IFERROR(M40*(1+$G$20)^($AA$7-2021-1),\"\")","v":0},{"$f":"IFERROR(IF(D40<F40,D40*$G$7,((D40-F40)*$G$6)+($F$39*$G$7))*MAX(Input!$D$20,0)*C40,\"\")","v":0},{"$f":"IFERROR(O40*(1+$G$20)^($AA$7-2021-1),\"\")","v":0}]
[]
[null,1,{"$f":"IF(B42=\"\",\"\",1)","v":1},{"$f":"Input!D16","v":0},{"$f":"G11*52.18*2","v":25912.588},{"$f":"IF(B42=\"\",\"\",E42/2*$B$15)","v":48456.539560000005},{"$f":"IFERROR(MAX(D42-2*($G$14*((1+$G$19)*(+$G$20))^(B42-1)),0),\"\")","v":0},{"$f":"IFERROR($H$29*D42*Input!$D$20,\"\")","v":0},{"$f":"IFERROR($I$29*G42*Input!$D$20,\"\")","v":0},{"$f":"IFERROR(IF(D42*Input!$D$20<=$J$5,$K$5*D42*Input!$D$20,IF(AND(D42*Input!$D$20>$J$5,D42*Input!$D$20<=$J$6),$K$6*(D42*Input!$D$20-$J$5),IF(D42*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D42*Input!$D$20-$J$6)))),\"\")","v":0},{"$f":"IFERROR(SUM(H42:I42)*(1+$G$20)^(-B42+0.5),\"\")","v":0},{"$f":"IFERROR(SUM(H42:J42)*(1+$G$20)^(-B42+0.5),\"\")","v":0},{"$f":"IFERROR($G$5*D43*Input!$D$20*C43,\"\")","v":""},{"$f":"IFERROR(M42*(1+$G$20)^($AA$6-B42-2),\"\")","v":""},{"$f":"IFERROR(IF(B42=\"\",\"\",IF(D43<$G$15*(1+$G$18)^(B43-1),D43*$G$7,((D43-($G$15*(1+$G$18)^(B43-1)))*$G$6)+($G$15*(1+$G$18)^(B43-1)*$G$7)))*Input!$D$20*C43,\"\")","v":""},{"$f":"IFERROR(O42*(1+$G$20)^($AA$6-B42-2),\"\")","v":""}]
[null,{"$f":"IF(B42=\"\",\"\",IF($AA$6>=B42+1,B42+1,\"\"))","v":""},{"$f":"IF(B43=\"\",\"\",1)","v":""},{"$f":"IF(B43=\"\",\"\",$D$42*(($G$19+1)*($G$20+1))^(B43-1))","v":""},{"$f":"IF(B43=\"\",\"\",$E$42*(($G$18+1))^(B43-1))","v":""},{"$f":"IF(B43=\"\",\"\",E43/2*$B$15)","v":""},{"$f":"IFERROR(D43-E43,\"\")","v":""},{"$f":"IFERROR($H$29*D43*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G43*Input!$D$20,\"\")","v":""},{"$f":"IFERROR(IF(D43*Input!$D$20<=$J$5,$K$5*D43*Input!$D$20,IF(AND(D43*Input!$D$20>$J$5,D43*Input!$D$20<=$J$6),$K$6*(D43*Input!$D$20-$J$5),IF(D43*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D43*Input!$D$20-$J$6)))),\"\")","v":""},{"$f":"IFERROR(SUM(H43:I43)*(1+$G$20)^(-B43+0.5),\"\")","v":""},"",{"$f":"IFERROR($G$5*D44*Input!$D$20*C44,\"\")","v":""},"",{"$f":"IFERROR(IF(B43=\"\",\"\",IF(D44<$G$15*(1+$G$18)^(B44-1),D44*$G$7,((D44-($G$15*(1+$G$18)^(B44-1)))*$G$6)+($G$15*(1+$G$18)^(B44-1)*$G$7)))*Input!$D$20*C44,\"\")","v":""},""]
[null,{"$f":"IF(B43=\"\",\"\",IF($AA$6>=B43+1,B43+1,\"\"))","v":""},"","","","",{"$f":"IFERROR(D44-E44,\"\")","v":""},{"$f":"IFERROR($H$29*D44*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G44*Input!$D$20,\"\")","v":""},{"$f":"IFERROR(IF(D44*Input!$D$20<=$J$5,$K$5*D44*Input!$D$20,IF(AND(D44*Input!$D$20>$J$5,D44*Input!$D$20<=$J$6),$K$6*(D44*Input!$D$20-$J$5),IF(D44*Input!$D$20>$J$6,$K$6*($J$6*Input!$D$20-$J$5)+$K$7*(D44*Input!$D$20-$J$6)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D45*Input!$D$20*C45,\"\")","v":""},"",{"$f":"IFERROR(IF(B44=\"\",\"\",IF(D45<$G$15*(1+$G$18)^(B45-1),D45*$G$7,((D45-($G$15*(1+$G$18)^(B45-1)))*$G$6)+($G$15*(1+$G$18)^(B45-1)*$G$7)))*Input!$D$20*C45,\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D45*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G45*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D46*Input!$D$20*C46,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D46*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G46*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D47*Input!$D$20*C47,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D47*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G47*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D48*Input!$D$20*C48,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D48*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G48*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D49*Input!$D$20*C49,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D49*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G49*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D50*Input!$D$20*C50,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D50*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G50*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D51*Input!$D$20*C51,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D51*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G51*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D52*Input!$D$20*C52,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D52*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G52*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D53*Input!$D$20*C53,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D53*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G53*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D54*Input!$D$20*C54,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D54*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G54*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D55*Input!$D$20*C55,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D55*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G55*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D56*Input!$D$20*C56,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D56*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G56*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D57*Input!$D$20*C57,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D57*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G57*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D58*Input!$D$20*C58,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D58*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G58*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D59*Input!$D$20*C59,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D59*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G59*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D60*Input!$D$20*C60,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D60*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G60*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D61*Input!$D$20*C61,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D61*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G61*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D62*Input!$D$20*C62,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D62*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G62*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D63*Input!$D$20*C63,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D63*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G63*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D64*Input!$D$20*C64,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D64*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G64*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D65*Input!$D$20*C65,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D65*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G65*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D66*Input!$D$20*C66,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D66*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G66*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D67*Input!$D$20*C67,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D67*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G67*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D68*Input!$D$20*C68,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D68*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G68*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D69*Input!$D$20*C69,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D69*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G69*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D70*Input!$D$20*C70,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D70*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G70*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D71*Input!$D$20*C71,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D71*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G71*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D72*Input!$D$20*C72,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D72*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G72*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D73*Input!$D$20*C73,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D73*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G73*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D74*Input!$D$20*C74,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D74*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G74*Input!$D$20,\"\")","v":""},{"$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":""},{"$f":"IFERROR(SUM(H74:I74)*(1+$G$20)^(-B74+0.5),\"\")","v":""},{"$f":"IFERROR(SUM(H74:J74)*(1+$G$20)^(-B74+0.5),\"\")","v":""},{"$f":"IFERROR($G$5*D75*Input!$D$20*C75,\"\")","v":""},{"$f":"IFERROR(M74*(1+$G$20)^($AA$6-B74-2),\"\")","v":""},{"$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":""},{"$f":"IFERROR(O74*(1+$G$20)^($AA$6-B74-2),\"\")","v":""}]
[null,"","",{"$f":"IF(B75=\"\",\"\",$D$42*(($G$19+1)*($G$20+1))^(B75-1))","v":""},{"$f":"IF(B75=\"\",\"\",$E$42*(($G$18+1))^(B75-1))","v":""},"","",{"$f":"IFERROR($H$29*D75*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G75*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D76*Input!$D$20*C76,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D76*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G76*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D77*Input!$D$20*C77,\"\")","v":""},"",{"$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":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$29*D77*Input!$D$20,\"\")","v":""},{"$f":"IFERROR($I$29*G77*Input!$D$20,\"\")","v":""},{"$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":""},"","",{"$f":"IFERROR($G$5*D78*Input!$D$20*C78,\"\")","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":""},""]
[null,"","","","","","",{"$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(D86-E86,\"\")","v":""},{"$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($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":"IF(B92=\"\",\"\",IF($AA$6>=B92+1,B92+1,\"\"))","v":""},"","","","","",{"$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":0},"",{"$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":""},""]

{"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"]