{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Disclaimer","Input","Output","Assumptions","Version Control","Calculation"],"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,"Single Scheme Estimator Tool - Disclaimer"]

{"sheet":"Input","index":1,"n_rows":135,"n_cols":5,"rows_kept":135,"cut":false,"hidden":false,"merged":[[30,1,31,7],[0,1,2,7],[27,2,27,7],[3,2,3,7],[15,2,15,7],[7,2,7,7],[11,2,11,7],[19,2,19,7]],"read":"row_number_cap"}
[null,"SINGLE PUBLIC SERVICE PENSION SCHEME (THE \"SINGLE SCHEME\") ESTIMATOR TOOL  - INPUTS"]
[]
[]
[null,null,"This Estimator Tool is designed to give a broad indication of retirement benefits for a standard grade member 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,"Full-Time Gross Annual Pensionable Pay (€)"]
[null,null,"€",null,{"$f":"IF(E11=\"\",\"\",\"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(D11<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,2013,1]
[null,null,2014,0.99]
[null,null,2015,0.98]
[null,null,2016,0.97]
[null,null,2017,0.96]
[null,null,2018,0.95]
[null,null,null,0.94]
[null,null,null,0.93]
[null,null,null,0.92]
[null,null,null,0.91]
[null,null,null,0.9]
[null,null,null,0.89]
[null,null,null,0.88]
[null,null,null,0.87]
[null,null,null,0.86]
[null,null,null,0.85]
[null,null,null,0.84]
[null,null,null,0.83]
[null,null,null,0.82]
[null,null,null,0.81]
[null,null,null,0.8]
[null,null,null,0.79]
[null,null,null,0.78]
[null,null,null,0.77]
[null,null,null,0.76]
[null,null,null,0.75]
[null,null,null,0.74]
[null,null,null,0.73]
[null,null,null,0.72]
[null,null,null,0.71]
[null,null,null,0.7]
[null,null,null,0.69]
[null,null,null,0.68]
[null,null,null,0.67]
[null,null,null,0.66]
[null,null,null,0.65]
[null,null,null,0.64]
[null,null,null,0.63]
[null,null,null,0.62]
[null,null,null,0.61]
[null,null,null,0.6]
[null,null,null,0.59]
[null,null,null,0.57999999999999996]
[null,null,null,0.56999999999999995]
[null,null,null,0.56000000000000005]
[null,null,null,0.55000000000000004]
[null,null,null,0.54]
[null,null,null,0.53]
[null,null,null,0.52]
[null,null,null,0.51]
[null,null,null,0.5]
[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.28999999999999998]
[null,null,null,0.28000000000000003]
[null,null,null,0.27]
[null,null,null,0.26]
[null,null,null,0.25]
[null,null,null,0.24]
[null,null,null,0.23]
[null,null,null,0.22]
[null,null,null,0.21]
[null,null,null,0.2]
[null,null,null,0.19]
[null,null,null,0.18]
[null,null,null,0.17]
[null,null,null,0.16]
[null,null,null,0.15]
[null,null,null,0.14000000000000001]
[null,null,null,0.13]
[null,null,null,0.12]
[null,null,null,0.11]
[null,null,null,0.1]
[null,null,null,0.09]
[null,null,null,0.08]
[null,null,null,7.0000000000000007E-2]
[null,null,null,0.06]
[null,null,null,0.05]
[null,null,null,0.04]
[null,null,null,0.03]
[null,null,null,0.02]
[null,null,null,0.01]
[null,null,null,0]

{"sheet":"Output","index":2,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[[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]]}
[null,"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,"Pension Related Deduction \"PRD\" / ASC"]
[null,null,"€",{"$f":"Calculation!H35+Calculation!I35","v":0}," ","€",{"$f":"Calculation!J35","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 Pension Related Deductions / Additional Superannuation Contribution over the next 12 months.\"","v":"Based on your inputs, you are projected to pay € in employee contributions and € in Pension Related Deductions / Additional Superannuation Contribution over the next 12 months."}]
[]
[null,null,"Retirement Benefits Built Up This Year"]
[null,null,{"$f":"\"Your normal retirement age is: \"&Calculation!S5","v":"Your normal retirement age is: 65"}]
[]
[null,null,"Retirement Pension Benefit ",null,null,"Retirement Lump Sum Benefit"]
[null,null,"€",{"$f":"Calculation!O35","v":""},"p.a.","€",{"$f":"Calculation!M35","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":{"$error":"#VALUE!"}}]
[null,null,{"$f":"\"The benefits built-up above will be payable from your normal retirement age, i.e. age \"&Calculation!S5&\". Your pension and lump sum benefits will be updated 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 65. Your pension and lump sum benefits will be updated 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!S7","v":65}]
[]
[null,null,"Single Scheme Retirement Lump Sum",null,null,"€",{"$f":"Calculation!S14","v":0}]
[]
[null,null,"Single Scheme Annual Retirement Pension",null,null,"€",{"$f":"Calculation!S13","v":0},"p.a."]
[]
[null,null,"Annual Contributory State Pension",null,null,"€",{"$f":"Calculation!G12","v":12695.394},"p.a."]
[]
[null,null,"Today's Date",null,null,null,{"$f":"TODAY()","v":"2018-07-18"}]
[]
[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,"Full-Time Gross Annual Pensionable Pay (€)",null,null,null,{"$f":"Input!D7","v":0}]
[null,null,"% Work Pattern or Full Time Equivalent (FTE)",null,null,null,{"$f":"Input!D11","v":0}]
[null,null,"Year of Birth",null,null,null,{"$f":"Input!D15","v":0}]
[null,null,"Year of Entry to the Single Scheme",null,null,null,{"$f":"Input!D19","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!D23","v":0},{"$f":"Input!E23","v":0}]
[null,null,null,2014,{"$f":"Input!D24","v":0},{"$f":"Input!E24","v":0}]
[null,null,null,2015,{"$f":"Input!D25","v":0},{"$f":"Input!E25","v":0}]
[null,null,null,2016,{"$f":"Input!D26","v":0},{"$f":"Input!E26","v":0}]
[null,null,null,2017,{"$f":"Input!D27","v":0},{"$f":"Input!E27","v":0}]

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

{"sheet":"Version Control","index":4,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":true,"merged":[[1,1,2,1],[1,2,2,2],[6,1,8,1]]}
[]
[null,"Resource Toolkit","Single Scheme Administration Project (Phase 1)\nMember Resources"]
[]
[null,"Resource Name","Single Public Service Scheme Member's Estimator Tool (for Standard Grades)"]
[null,"Description","This Estimator Tool is designed to give a broad indication of the normal retirement benefits for a standard grade member of the Single Scheme at normal retirement age \n"]
[null,"Version  ","V1.1  (22/05/2018)"]
[null,"Version Comments","V1 test launch 9/05/2018 "]
[null,null,"V1.1 - Added Reminder of Input details to Output Sheet.  Added detail re present day money terms. Formatting of \"Standard Grade\" changed. CPI 2015 (Calculations _ N6) changed to correct CPI of 0.001."]
[null,null,"v2 20/07/2018 change to calculations sheet - promotional pay increase 1% p.a.. Issue resolved on output sheet where rows not hiding. "]

{"sheet":"Calculation","index":5,"n_rows":86,"n_cols":19,"rows_kept":86,"cut":false,"hidden":false,"merged":[[21,14,21,15],[1,1,1,15],[21,3,21,6],[21,7,21,8]]}
[]
[null,"Single Scheme"]
[null,"Parameters",null,null,null,null,null,null,2018,null,"2018-12-31",null,"CPI rates - SS referable amounts",null,null,null,null,"CALCULATIONS"]
[null,"Accrual rates",null,null,null,null,null,null,"Bands",null,"PRD",null,null,null,null,null,null,"Service (Years)"]
[null,"Lump sum rate:",null,null,null,null,3.7500000000000006E-2,null,"<=€28,750",28750,0,null,2014,0,null,null,null,"Normal Pension Age:",{"$f":"IF(Input!D15<1949,65, IF(AND( Input!D15>=1949,Input!D15<1955),66,IF(AND(Input!D15>=1955,Input!D15<1961),67,68)))","v":65}]
[null,"Pension rate:",null,null,null,null,1.2500000000000001E-2,null,">28,750 - <=€60000",60000,0.1,null,2015,1E-3,null,null,null,"Projected service from current date forward:",{"$f":"S5-(YEAR(NOW())-Input!D15)","v":-1953}]
[null,"Low-pay rate:",null,null,null,null,5.7999999999999996E-3,null,">€60,000",null,0.105,null,2016,0,null,null,null,"Year of Retirement",{"$f":"Input!D15+$S$5","v":65}]
[null,null,null,null,null,null,null,null,null,null,null,null,2017,4.0000000000000001E-3]
[null,"State Pension (€)",null,null,null,null,null,null,2019,null,"2019-12-31",null,null,null,null,null,null,"Benefits"]
[null,"Weekly rate:",null,null,null,null,243.3,null,"Bands",null,"ASC",null,"Year","% of Year Worked","Reference Date",null,null,"Projected Pension",{"$f":"SUM(P28:P86)","v":0}]
[null,null,null,null,null,null,null,null,"<=€32,000",32000,0,null,2013,{"$f":"IFERROR(IF(Input!$D$19=M11,0.5,IF(Input!$D$19>Calculation!M11,0,1)),\"\")","v":1},"2013-12-31",null,null,"Projected Lump Sum",{"$f":"SUM(N28:N86)","v":0}]
[null,"Annual rate:",null,null,null,null,{"$f":"G10*52.18","v":12695.394},null,">32000 - <=€60000",60000,6.6600000000000006E-2,null,2014,{"$f":"IFERROR(IF(Input!$D$19=M12,0.5,IF(Input!$D$19>Calculation!M12,0,1)),\"\")","v":1},"2014-12-31"]
[null,3.74,"* annual",null,null,null,{"$f":"G12*B13","v":47480.773560000001},null,">€60,000",null,7.0000000000000007E-2,null,2015,{"$f":"IFERROR(IF(Input!$D$19=M13,0.5,IF(Input!$D$19>Calculation!M13,0,1)),\"\")","v":1},"2015-12-31",null,null,"PV Pension",{"$f":"$S$10*(1+$G$20)^-($S$6-1)","v":0}]
[null,"Annual rate of increase (nominal)",null,null,null,null,null,null,null,null,null,null,2016,{"$f":"IFERROR(IF(Input!$D$19=M14,0.5,IF(Input!$D$19>Calculation!M14,0,1)),\"\")","v":1},"2016-12-31",null,null,"PV Lump Sum",{"$f":"S11*(1+$G$20)^-($S$6-1)","v":0}]
[null,null,null,null,null,null,null,null,"2020 Onwards",null,null,null,2017,{"$f":"IFERROR(IF(Input!$D$19=M15,0.5,IF(Input!$D$19>Calculation!M15,0,1)),\"\")","v":1},"2017-12-31"]
[null,"Salary (€)",null,null,null,null,null,null,"Bands",null,"ASC",null,2018,{"$f":"IFERROR(IF(Input!$D$19=M16,0.5,IF(Input!$D$19>Calculation!M16,0,1)),\"\")","v":1},{"$f":"TODAY()","v":"2018-07-18"},null,null,"Contributions"]
[null,"Annual rate of increase (nominal)",null,null,null,null,{"$f":"G18+G19","v":3.5000000000000003E-2},null,"<=€34500",34500,0,null,null,null,null,null,null,"PV EE CONT",{"$f":"SUM(K35:K77)","v":0}]
[null,"Real and Promotional pay growth",null,null,null,null,0.02,null,">34500 - <=€60000",60000,3.3300000000000003E-2,null,"CSP Cut-Off Dates",null,null,null,null,"PV EE CONT+PRD/ASC",{"$f":"SUM(L35:L77)","v":0}]
[null,"Inflation",null,null,null,null,1.4999999999999999E-2,null,">€60,000",null,3.5000000000000003E-2,null,2017,"2017-01-01","2017-03-09","2017-12-31"]
[null,"Deflation Factor",null,null,null,null,2.5000000000000001E-2,null,null,null,null,null,2018,"2018-01-01","2018-03-25","2018-12-31"]
[]
[null,"YEAR",null,"PROJECTED SALARY",null,null,null,"EE CONT",null,"PRD (Year 1)/ASC","PV EE CONT","PV EE CONT + PRD/ASC","Lump Sum",null,"Scheme Pension"]
[null,null,"% of Year Worked","PR","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,0.03,3.5000000000000003E-2,{"$f":"SUM(J35:J77)","v":0}]
[]
[]
[null,2013,{"$f":"IFERROR(IF(Input!$D$19=B28,0.5,IF(Input!$D$19>Calculation!B28,0,1)),\"\")","v":1},{"$f":"IF(Input!$D$19>Calculation!B28,0,Input!E23)","v":0},{"$f":"230.3*52.18*2","v":24034.108},{"$f":"E28/2*$B$13","v":44943.78196},{"$f":"IFERROR(MAX(D28-E28,0),\"\")","v":0},null,null,null,null,null,{"$f":"IFERROR($G$5*(D28*MAX(Input!D23,0)*C28),\"\")","v":0},{"$f":"IFERROR(M28*(1+$N$5)*(1+$N$6)*(1+$N$7)*(1+$N$8)*(1+$G$19)^($S$7-2018-1),\"\")","v":0},{"$f":"IFERROR(IF(D28<F28,D28*$G$7,((D28-F28)*$G$6)+($F$28*$G$7))*MAX(Input!D23,0)*C28,\"\")","v":0},{"$f":"IFERROR(O28*(1+$N$5)*(1+$N$6)*(1+$N$7)*(1+$N$8)*(1+$G$19)^($S$7-2018-1),\"\")","v":0}]
[null,2014,{"$f":"IFERROR(IF(Input!$D$19=B29,0.5,IF(Input!$D$19>Calculation!B29,0,1)),\"\")","v":1},{"$f":"IF(Input!$D$19>Calculation!B29,0,Input!E24)","v":0},{"$f":"230.3*52.18*2","v":24034.108},44943.78196,0,null,null,null,null,null,{"$f":"IFERROR($G$5*(D29*MAX(Input!D24,0)*C29),\"\")","v":0},{"$f":"IFERROR(M29*(1+$N$6)*(1+$N$7)*(1+$N$8)*(1+$G$19)^($S$7-2018-1),\"\")","v":0},{"$f":"IFERROR(IF(D29<F29,D29*$G$7,((D29-F29)*$G$6)+($F$28*$G$7))*MAX(Input!D24,0)*C29,\"\")","v":0},{"$f":"IFERROR(O29*(1+$N$6)*(1+$N$7)*(1+$N$8)*(1+$G$19)^($S$7-2018-1),\"\")","v":0}]
[null,2015,{"$f":"IFERROR(IF(Input!$D$19=B30,0.5,IF(Input!$D$19>Calculation!B30,0,1)),\"\")","v":1},{"$f":"IF(Input!$D$19>Calculation!B30,0,Input!E25)","v":0},{"$f":"230.3*52.18*2","v":24034.108},44943.78196,0,null,null,null,null,null,{"$f":"IFERROR($G$5*(D30*MAX(Input!D25,0)*C30),\"\")","v":0},{"$f":"IFERROR(M30*(1+$N$7)*(1+$N$8)*(1+$G$19)^($S$7-2018-1),\"\")","v":0},{"$f":"IFERROR(IF(D30<F30,D30*$G$7,((D30-F30)*$G$6)+($F$28*$G$7))*MAX(Input!D25,0)*C30,\"\")","v":0},{"$f":"IFERROR(O30*(1+$N$7)*(1+$N$8)*(1+$G$19)^($S$7-2018-1),\"\")","v":0}]
[null,2016,{"$f":"IFERROR(IF(Input!$D$19=B31,0.5,IF(Input!$D$19>Calculation!B31,0,1)),\"\")","v":1},{"$f":"IF(Input!$D$19>Calculation!B31,0,Input!E26)","v":0},{"$f":"233.3*52.18*2","v":24347.188000000002},45529.241560000009,0,null,null,null,null,null,{"$f":"IFERROR($G$5*(D31*MAX(Input!D26,0)*C31),\"\")","v":0},{"$f":"IFERROR(M31*(1+$N$8)*(1+$G$19)^($S$7-2018-1),\"\")","v":0},{"$f":"IFERROR(IF(D31<F31,D31*$G$7,((D31-F31)*$G$6)+($F$28*$G$7))*MAX(Input!D26,0)*C31,\"\")","v":0},{"$f":"IFERROR(O31*(1+$N$8)*(1+$G$19)^($S$7-2018-1),\"\")","v":0}]
[null,2017,{"$f":"IFERROR(IF(Input!$D$19=B32,0.5,IF(Input!$D$19>Calculation!B32,0,1)),\"\")","v":1},{"$f":"IF(Input!$D$19>Calculation!B32,0,Input!E27)","v":0},{"$f":"(YEARFRAC(N19,O19)*233.3+YEARFRAC(O19,P19)*238.3)*52.18*2","v":24770.425777777778},46320.696204444452,0,null,null,null,null,null,{"$f":"IFERROR($G$5*(D32*MAX(Input!D27,0)*C32),\"\")","v":0},{"$f":"IFERROR(M32*(1+$G$19)^($S$7-2018-1),\"\")","v":0},{"$f":"IFERROR(IF(D32<F32,D32*$G$7,((D32-F32)*$G$6)+($F$28*$G$7))*MAX(Input!D27,0)*C32,\"\")","v":0},{"$f":"IFERROR(O32*(1+$G$19)^($S$7-2018-1),\"\")","v":0}]
[null,2018,{"$f":"IFERROR(IF(Input!$D$19=B33,0.5,IF(Input!$D$19>Calculation!B33,0,1)),\"\")","v":1},{"$f":"IF(Input!$D$19>Calculation!B33,0,Input!D7)","v":0},{"$f":"(YEARFRAC(N20,O20)*238.3+YEARFRAC(O20,P20)*243.3)*52.18*2","v":25269.03466666667},47253.094826666675,0,null,null,null,null,null,{"$f":"IFERROR($G$5*(D33*Input!D11*C33),\"\")","v":0},{"$f":"IFERROR(M33*(1+$G$19)^($S$7-2018-1),\"\")","v":0},{"$f":"IFERROR(IF(D33<$G$13*(1+$G$17)^(B33-1),D33*$G$7,((D33-($G$13*(1+$G$17)^(B33-1)))*$G$6)+($G$13*(1+$G$17)^(B33-1)*$G$7)*Input!D28*C33),\"\")","v":0},{"$f":"IFERROR(O33*(1+$G$19)^($S$7-2018-1),\"\")","v":0}]
[]
[null,1,{"$f":"IF(B35=\"\",\"\",1)","v":1},{"$f":"Input!D7","v":0},{"$f":"243.3*52.18*2","v":25390.788},{"$f":"IF(B35=\"\",\"\",E35/2*$B$13)","v":47480.773560000001},{"$f":"IFERROR(MAX(D35-2*($G$12*((1+$G$18)*(+$G$19))^(B35-1)),0),\"\")","v":0},{"$f":"IFERROR($H$25*D35*Input!$D$11,\"\")","v":0},{"$f":"IFERROR($I$25*G35*Input!$D$11,\"\")","v":0},{"$f":"IFERROR(YEARFRAC(TODAY(),$K$3)*IF(D35*Input!$D$11<=$J$5,$K$5*D35*Input!$D$11,IF(AND(D35*Input!$D$11>28750,D35*Input!$D$11<=60000),$K$6*(D35*Input!$D$11-$J$5),IF(D35*Input!$D$11>$J$6,$K$6*($J$6-$J$5)+$K$7*(D35*Input!$D$11-$J$6))))+(1-YEARFRAC(TODAY(),$K$3))*IF(D35*Input!$D$11<=$J$11,$K$11*D35*Input!$D$11,IF(AND(D35*Input!$D$11>$J$11,D35*Input!$D$11<=$J$12),$K$12*(D35*Input!$D$11-$J$11),IF(D35*Input!$D$11>$J$12,$K$12*($J$12-$J$11)+$K$13*(D35*Input!$D$11-$J$12)))),\"\")","v":0},{"$f":"IFERROR(SUM(H35:I35)*(1+$G$19)^(-B35+0.5),\"\")","v":0},{"$f":"IFERROR(SUM(H35:J35)*(1+$G$19)^(-B35+0.5),\"\")","v":0},{"$f":"IFERROR($G$5*D35*Input!$D$11*C35,\"\")","v":0},{"$f":"IFERROR(M35*(1+$G$19)^($S$6-B35),\"\")","v":0},{"$f":"IFERROR(IF(B35=\"\",\"\",IF(D36<$G$13*(1+$G$17)^(B36-1),D36*$G$7*Input!$D$11*C36,((D36-($G$13*(1+$G$17)^(B36-1)))*$G$6)+($G$13*(1+$G$17)^(B36-1)*$G$7)*Input!$D$11*C36)),\"\")","v":""},{"$f":"IFERROR(O35*(1+$G$19)^($S$6-B35),\"\")","v":""}]
[null,{"$f":"IF(B35=\"\",\"\",IF($S$6>=B35+1,B35+1,\"\"))","v":""},{"$f":"IF(B36=\"\",\"\",1)","v":""},{"$f":"IF(B36=\"\",\"\",$D$35*(($G$18+1)*($G$19+1))^(B36-1))","v":""},{"$f":"IF(B36=\"\",\"\",$E$35*(($G$18+1)*($G$19+1))^(B36-1))","v":""},{"$f":"IF(B36=\"\",\"\",E36/2*$B$13)","v":""},{"$f":"IFERROR(D36-E36,\"\")","v":""},{"$f":"IFERROR($H$25*D36*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G36*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(YEARFRAC(EDATE(TODAY(),12),$K$9)*IF(D36*Input!$D$11<=$J$11,$K$11*D36*Input!$D$11,IF(AND(D36*Input!$D$11>$J$11,D36*Input!$D$11<=$J$12),$K$12*(D36*Input!$D$11-$J$11),IF(D36*Input!$D$11>$J$12,$K$12*($J$12*Input!$D$11-$J$11)+$K$13*(D36*Input!$D$11-$J$12))))+(1-YEARFRAC(EDATE(TODAY(),12), $K$9))*IF(D36*Input!$D$11<=$J$17,$K$17*D36*Input!$D$11,IF(AND(D36*Input!$D$11>$J$17,D36*Input!$D$11<=$J$18),$K$18*(D36*Input!$D$11-$J$17),IF(D36*Input!$D$11>$J$18,$K$18*($J$18*Input!$D$11-$J$17)+$K$19*(D36*Input!$D$11-$J$18)))),\"\")","v":""},{"$f":"IFERROR(SUM(H36:I36)*(1+$G$19)^(-B36+0.5),\"\")","v":""},{"$f":"IFERROR(SUM(H36:J36)*(1+$G$19)^(-B36+0.5),\"\")","v":""},{"$f":"IFERROR($G$5*D36*Input!$D$11*C36,\"\")","v":""},"",{"$f":"IFERROR(IF(B36=\"\",\"\",IF(D37<$G$13*(1+$G$17)^(B37-1),D37*$G$7*Input!$D$11*C37,((D37-($G$13*(1+$G$17)^(B37-1)))*$G$6)+($G$13*(1+$G$17)^(B37-1)*$G$7)*Input!$D$11*C37)),\"\")","v":""},""]
[null,"","","",{"$f":"IF(B37=\"\",\"\",$E$35*(($G$18+1)*($G$19+1))^(B37-1))","v":""},"",{"$f":"IFERROR(D37-E37,\"\")","v":""},{"$f":"IFERROR($H$25*D37*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G37*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D37*Input!$D$11<=$J$17,$K$17*D37*Input!$D$11,IF(AND(D37*Input!$D$11>$J$17,D37*Input!$D$11<=$J$18),$K$18*(D37*Input!$D$11-$J$17),IF(D37*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D37*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D37*Input!$D$11*C37,\"\")","v":""},"",{"$f":"IFERROR(IF(B37=\"\",\"\",IF(D38<$G$13*(1+$G$17)^(B38-1),D38*$G$7*Input!$D$11*C38,((D38-($G$13*(1+$G$17)^(B38-1)))*$G$6)+($G$13*(1+$G$17)^(B38-1)*$G$7)*Input!$D$11*C38)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D38*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G38*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D38*Input!$D$11<=$J$17,$K$17*D38*Input!$D$11,IF(AND(D38*Input!$D$11>$J$17,D38*Input!$D$11<=$J$18),$K$18*(D38*Input!$D$11-$J$17),IF(D38*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D38*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D38*Input!$D$11*C38,\"\")","v":""},"",{"$f":"IFERROR(IF(B38=\"\",\"\",IF(D39<$G$13*(1+$G$17)^(B39-1),D39*$G$7*Input!$D$11*C39,((D39-($G$13*(1+$G$17)^(B39-1)))*$G$6)+($G$13*(1+$G$17)^(B39-1)*$G$7)*Input!$D$11*C39)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D39*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G39*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D39*Input!$D$11<=$J$17,$K$17*D39*Input!$D$11,IF(AND(D39*Input!$D$11>$J$17,D39*Input!$D$11<=$J$18),$K$18*(D39*Input!$D$11-$J$17),IF(D39*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D39*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D39*Input!$D$11*C39,\"\")","v":""},"",{"$f":"IFERROR(IF(B39=\"\",\"\",IF(D40<$G$13*(1+$G$17)^(B40-1),D40*$G$7*Input!$D$11*C40,((D40-($G$13*(1+$G$17)^(B40-1)))*$G$6)+($G$13*(1+$G$17)^(B40-1)*$G$7)*Input!$D$11*C40)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D40*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G40*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D40*Input!$D$11<=$J$17,$K$17*D40*Input!$D$11,IF(AND(D40*Input!$D$11>$J$17,D40*Input!$D$11<=$J$18),$K$18*(D40*Input!$D$11-$J$17),IF(D40*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D40*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D40*Input!$D$11*C40,\"\")","v":""},"",{"$f":"IFERROR(IF(B40=\"\",\"\",IF(D41<$G$13*(1+$G$17)^(B41-1),D41*$G$7*Input!$D$11*C41,((D41-($G$13*(1+$G$17)^(B41-1)))*$G$6)+($G$13*(1+$G$17)^(B41-1)*$G$7)*Input!$D$11*C41)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D41*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G41*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D41*Input!$D$11<=$J$17,$K$17*D41*Input!$D$11,IF(AND(D41*Input!$D$11>$J$17,D41*Input!$D$11<=$J$18),$K$18*(D41*Input!$D$11-$J$17),IF(D41*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D41*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D41*Input!$D$11*C41,\"\")","v":""},"",{"$f":"IFERROR(IF(B41=\"\",\"\",IF(D42<$G$13*(1+$G$17)^(B42-1),D42*$G$7*Input!$D$11*C42,((D42-($G$13*(1+$G$17)^(B42-1)))*$G$6)+($G$13*(1+$G$17)^(B42-1)*$G$7)*Input!$D$11*C42)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D42*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G42*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D42*Input!$D$11<=$J$17,$K$17*D42*Input!$D$11,IF(AND(D42*Input!$D$11>$J$17,D42*Input!$D$11<=$J$18),$K$18*(D42*Input!$D$11-$J$17),IF(D42*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D42*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D42*Input!$D$11*C42,\"\")","v":""},"",{"$f":"IFERROR(IF(B42=\"\",\"\",IF(D43<$G$13*(1+$G$17)^(B43-1),D43*$G$7*Input!$D$11*C43,((D43-($G$13*(1+$G$17)^(B43-1)))*$G$6)+($G$13*(1+$G$17)^(B43-1)*$G$7)*Input!$D$11*C43)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D43*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G43*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D43*Input!$D$11<=$J$17,$K$17*D43*Input!$D$11,IF(AND(D43*Input!$D$11>$J$17,D43*Input!$D$11<=$J$18),$K$18*(D43*Input!$D$11-$J$17),IF(D43*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D43*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D43*Input!$D$11*C43,\"\")","v":""},"",{"$f":"IFERROR(IF(B43=\"\",\"\",IF(D44<$G$13*(1+$G$17)^(B44-1),D44*$G$7*Input!$D$11*C44,((D44-($G$13*(1+$G$17)^(B44-1)))*$G$6)+($G$13*(1+$G$17)^(B44-1)*$G$7)*Input!$D$11*C44)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D44*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G44*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D44*Input!$D$11<=$J$17,$K$17*D44*Input!$D$11,IF(AND(D44*Input!$D$11>$J$17,D44*Input!$D$11<=$J$18),$K$18*(D44*Input!$D$11-$J$17),IF(D44*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D44*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D44*Input!$D$11*C44,\"\")","v":""},"",{"$f":"IFERROR(IF(B44=\"\",\"\",IF(D45<$G$13*(1+$G$17)^(B45-1),D45*$G$7*Input!$D$11*C45,((D45-($G$13*(1+$G$17)^(B45-1)))*$G$6)+($G$13*(1+$G$17)^(B45-1)*$G$7)*Input!$D$11*C45)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D45*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G45*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D45*Input!$D$11<=$J$17,$K$17*D45*Input!$D$11,IF(AND(D45*Input!$D$11>$J$17,D45*Input!$D$11<=$J$18),$K$18*(D45*Input!$D$11-$J$17),IF(D45*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D45*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D45*Input!$D$11*C45,\"\")","v":""},"",{"$f":"IFERROR(IF(B45=\"\",\"\",IF(D46<$G$13*(1+$G$17)^(B46-1),D46*$G$7*Input!$D$11*C46,((D46-($G$13*(1+$G$17)^(B46-1)))*$G$6)+($G$13*(1+$G$17)^(B46-1)*$G$7)*Input!$D$11*C46)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D46*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G46*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D46*Input!$D$11<=$J$17,$K$17*D46*Input!$D$11,IF(AND(D46*Input!$D$11>$J$17,D46*Input!$D$11<=$J$18),$K$18*(D46*Input!$D$11-$J$17),IF(D46*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D46*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D46*Input!$D$11*C46,\"\")","v":""},"",{"$f":"IFERROR(IF(B46=\"\",\"\",IF(D47<$G$13*(1+$G$17)^(B47-1),D47*$G$7*Input!$D$11*C47,((D47-($G$13*(1+$G$17)^(B47-1)))*$G$6)+($G$13*(1+$G$17)^(B47-1)*$G$7)*Input!$D$11*C47)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D47*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G47*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D47*Input!$D$11<=$J$17,$K$17*D47*Input!$D$11,IF(AND(D47*Input!$D$11>$J$17,D47*Input!$D$11<=$J$18),$K$18*(D47*Input!$D$11-$J$17),IF(D47*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D47*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D47*Input!$D$11*C47,\"\")","v":""},"",{"$f":"IFERROR(IF(B47=\"\",\"\",IF(D48<$G$13*(1+$G$17)^(B48-1),D48*$G$7*Input!$D$11*C48,((D48-($G$13*(1+$G$17)^(B48-1)))*$G$6)+($G$13*(1+$G$17)^(B48-1)*$G$7)*Input!$D$11*C48)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D48*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G48*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D48*Input!$D$11<=$J$17,$K$17*D48*Input!$D$11,IF(AND(D48*Input!$D$11>$J$17,D48*Input!$D$11<=$J$18),$K$18*(D48*Input!$D$11-$J$17),IF(D48*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D48*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D48*Input!$D$11*C48,\"\")","v":""},"",{"$f":"IFERROR(IF(B48=\"\",\"\",IF(D49<$G$13*(1+$G$17)^(B49-1),D49*$G$7*Input!$D$11*C49,((D49-($G$13*(1+$G$17)^(B49-1)))*$G$6)+($G$13*(1+$G$17)^(B49-1)*$G$7)*Input!$D$11*C49)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D49*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G49*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D49*Input!$D$11<=$J$17,$K$17*D49*Input!$D$11,IF(AND(D49*Input!$D$11>$J$17,D49*Input!$D$11<=$J$18),$K$18*(D49*Input!$D$11-$J$17),IF(D49*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D49*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D49*Input!$D$11*C49,\"\")","v":""},"",{"$f":"IFERROR(IF(B49=\"\",\"\",IF(D50<$G$13*(1+$G$17)^(B50-1),D50*$G$7*Input!$D$11*C50,((D50-($G$13*(1+$G$17)^(B50-1)))*$G$6)+($G$13*(1+$G$17)^(B50-1)*$G$7)*Input!$D$11*C50)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D50*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G50*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D50*Input!$D$11<=$J$17,$K$17*D50*Input!$D$11,IF(AND(D50*Input!$D$11>$J$17,D50*Input!$D$11<=$J$18),$K$18*(D50*Input!$D$11-$J$17),IF(D50*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D50*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D50*Input!$D$11*C50,\"\")","v":""},"",{"$f":"IFERROR(IF(B50=\"\",\"\",IF(D51<$G$13*(1+$G$17)^(B51-1),D51*$G$7*Input!$D$11*C51,((D51-($G$13*(1+$G$17)^(B51-1)))*$G$6)+($G$13*(1+$G$17)^(B51-1)*$G$7)*Input!$D$11*C51)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D51*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G51*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D51*Input!$D$11<=$J$17,$K$17*D51*Input!$D$11,IF(AND(D51*Input!$D$11>$J$17,D51*Input!$D$11<=$J$18),$K$18*(D51*Input!$D$11-$J$17),IF(D51*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D51*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D51*Input!$D$11*C51,\"\")","v":""},"",{"$f":"IFERROR(IF(B51=\"\",\"\",IF(D52<$G$13*(1+$G$17)^(B52-1),D52*$G$7*Input!$D$11*C52,((D52-($G$13*(1+$G$17)^(B52-1)))*$G$6)+($G$13*(1+$G$17)^(B52-1)*$G$7)*Input!$D$11*C52)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D52*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G52*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D52*Input!$D$11<=$J$17,$K$17*D52*Input!$D$11,IF(AND(D52*Input!$D$11>$J$17,D52*Input!$D$11<=$J$18),$K$18*(D52*Input!$D$11-$J$17),IF(D52*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D52*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D52*Input!$D$11*C52,\"\")","v":""},"",{"$f":"IFERROR(IF(B52=\"\",\"\",IF(D53<$G$13*(1+$G$17)^(B53-1),D53*$G$7*Input!$D$11*C53,((D53-($G$13*(1+$G$17)^(B53-1)))*$G$6)+($G$13*(1+$G$17)^(B53-1)*$G$7)*Input!$D$11*C53)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D53*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G53*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D53*Input!$D$11<=$J$17,$K$17*D53*Input!$D$11,IF(AND(D53*Input!$D$11>$J$17,D53*Input!$D$11<=$J$18),$K$18*(D53*Input!$D$11-$J$17),IF(D53*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D53*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D53*Input!$D$11*C53,\"\")","v":""},"",{"$f":"IFERROR(IF(B53=\"\",\"\",IF(D54<$G$13*(1+$G$17)^(B54-1),D54*$G$7*Input!$D$11*C54,((D54-($G$13*(1+$G$17)^(B54-1)))*$G$6)+($G$13*(1+$G$17)^(B54-1)*$G$7)*Input!$D$11*C54)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D54*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G54*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D54*Input!$D$11<=$J$17,$K$17*D54*Input!$D$11,IF(AND(D54*Input!$D$11>$J$17,D54*Input!$D$11<=$J$18),$K$18*(D54*Input!$D$11-$J$17),IF(D54*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D54*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D54*Input!$D$11*C54,\"\")","v":""},"",{"$f":"IFERROR(IF(B54=\"\",\"\",IF(D55<$G$13*(1+$G$17)^(B55-1),D55*$G$7*Input!$D$11*C55,((D55-($G$13*(1+$G$17)^(B55-1)))*$G$6)+($G$13*(1+$G$17)^(B55-1)*$G$7)*Input!$D$11*C55)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D55*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G55*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D55*Input!$D$11<=$J$17,$K$17*D55*Input!$D$11,IF(AND(D55*Input!$D$11>$J$17,D55*Input!$D$11<=$J$18),$K$18*(D55*Input!$D$11-$J$17),IF(D55*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D55*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D55*Input!$D$11*C55,\"\")","v":""},"",{"$f":"IFERROR(IF(B55=\"\",\"\",IF(D56<$G$13*(1+$G$17)^(B56-1),D56*$G$7*Input!$D$11*C56,((D56-($G$13*(1+$G$17)^(B56-1)))*$G$6)+($G$13*(1+$G$17)^(B56-1)*$G$7)*Input!$D$11*C56)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D56*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G56*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D56*Input!$D$11<=$J$17,$K$17*D56*Input!$D$11,IF(AND(D56*Input!$D$11>$J$17,D56*Input!$D$11<=$J$18),$K$18*(D56*Input!$D$11-$J$17),IF(D56*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D56*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D56*Input!$D$11*C56,\"\")","v":""},"",{"$f":"IFERROR(IF(B56=\"\",\"\",IF(D57<$G$13*(1+$G$17)^(B57-1),D57*$G$7*Input!$D$11*C57,((D57-($G$13*(1+$G$17)^(B57-1)))*$G$6)+($G$13*(1+$G$17)^(B57-1)*$G$7)*Input!$D$11*C57)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D57*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G57*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D57*Input!$D$11<=$J$17,$K$17*D57*Input!$D$11,IF(AND(D57*Input!$D$11>$J$17,D57*Input!$D$11<=$J$18),$K$18*(D57*Input!$D$11-$J$17),IF(D57*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D57*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D57*Input!$D$11*C57,\"\")","v":""},"",{"$f":"IFERROR(IF(B57=\"\",\"\",IF(D58<$G$13*(1+$G$17)^(B58-1),D58*$G$7*Input!$D$11*C58,((D58-($G$13*(1+$G$17)^(B58-1)))*$G$6)+($G$13*(1+$G$17)^(B58-1)*$G$7)*Input!$D$11*C58)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D58*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G58*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D58*Input!$D$11<=$J$17,$K$17*D58*Input!$D$11,IF(AND(D58*Input!$D$11>$J$17,D58*Input!$D$11<=$J$18),$K$18*(D58*Input!$D$11-$J$17),IF(D58*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D58*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D58*Input!$D$11*C58,\"\")","v":""},"",{"$f":"IFERROR(IF(B58=\"\",\"\",IF(D59<$G$13*(1+$G$17)^(B59-1),D59*$G$7*Input!$D$11*C59,((D59-($G$13*(1+$G$17)^(B59-1)))*$G$6)+($G$13*(1+$G$17)^(B59-1)*$G$7)*Input!$D$11*C59)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D59*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G59*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D59*Input!$D$11<=$J$17,$K$17*D59*Input!$D$11,IF(AND(D59*Input!$D$11>$J$17,D59*Input!$D$11<=$J$18),$K$18*(D59*Input!$D$11-$J$17),IF(D59*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D59*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D59*Input!$D$11*C59,\"\")","v":""},"",{"$f":"IFERROR(IF(B59=\"\",\"\",IF(D60<$G$13*(1+$G$17)^(B60-1),D60*$G$7*Input!$D$11*C60,((D60-($G$13*(1+$G$17)^(B60-1)))*$G$6)+($G$13*(1+$G$17)^(B60-1)*$G$7)*Input!$D$11*C60)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D60*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G60*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D60*Input!$D$11<=$J$17,$K$17*D60*Input!$D$11,IF(AND(D60*Input!$D$11>$J$17,D60*Input!$D$11<=$J$18),$K$18*(D60*Input!$D$11-$J$17),IF(D60*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D60*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D60*Input!$D$11*C60,\"\")","v":""},"",{"$f":"IFERROR(IF(B60=\"\",\"\",IF(D61<$G$13*(1+$G$17)^(B61-1),D61*$G$7*Input!$D$11*C61,((D61-($G$13*(1+$G$17)^(B61-1)))*$G$6)+($G$13*(1+$G$17)^(B61-1)*$G$7)*Input!$D$11*C61)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D61*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G61*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D61*Input!$D$11<=$J$17,$K$17*D61*Input!$D$11,IF(AND(D61*Input!$D$11>$J$17,D61*Input!$D$11<=$J$18),$K$18*(D61*Input!$D$11-$J$17),IF(D61*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D61*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D61*Input!$D$11*C61,\"\")","v":""},"",{"$f":"IFERROR(IF(B61=\"\",\"\",IF(D62<$G$13*(1+$G$17)^(B62-1),D62*$G$7*Input!$D$11*C62,((D62-($G$13*(1+$G$17)^(B62-1)))*$G$6)+($G$13*(1+$G$17)^(B62-1)*$G$7)*Input!$D$11*C62)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D62*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G62*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D62*Input!$D$11<=$J$17,$K$17*D62*Input!$D$11,IF(AND(D62*Input!$D$11>$J$17,D62*Input!$D$11<=$J$18),$K$18*(D62*Input!$D$11-$J$17),IF(D62*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D62*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D62*Input!$D$11*C62,\"\")","v":""},"",{"$f":"IFERROR(IF(B62=\"\",\"\",IF(D63<$G$13*(1+$G$17)^(B63-1),D63*$G$7*Input!$D$11*C63,((D63-($G$13*(1+$G$17)^(B63-1)))*$G$6)+($G$13*(1+$G$17)^(B63-1)*$G$7)*Input!$D$11*C63)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D63*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G63*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D63*Input!$D$11<=$J$17,$K$17*D63*Input!$D$11,IF(AND(D63*Input!$D$11>$J$17,D63*Input!$D$11<=$J$18),$K$18*(D63*Input!$D$11-$J$17),IF(D63*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D63*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D63*Input!$D$11*C63,\"\")","v":""},"",{"$f":"IFERROR(IF(B63=\"\",\"\",IF(D64<$G$13*(1+$G$17)^(B64-1),D64*$G$7*Input!$D$11*C64,((D64-($G$13*(1+$G$17)^(B64-1)))*$G$6)+($G$13*(1+$G$17)^(B64-1)*$G$7)*Input!$D$11*C64)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D64*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G64*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D64*Input!$D$11<=$J$17,$K$17*D64*Input!$D$11,IF(AND(D64*Input!$D$11>$J$17,D64*Input!$D$11<=$J$18),$K$18*(D64*Input!$D$11-$J$17),IF(D64*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D64*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D64*Input!$D$11*C64,\"\")","v":""},"",{"$f":"IFERROR(IF(B64=\"\",\"\",IF(D65<$G$13*(1+$G$17)^(B65-1),D65*$G$7*Input!$D$11*C65,((D65-($G$13*(1+$G$17)^(B65-1)))*$G$6)+($G$13*(1+$G$17)^(B65-1)*$G$7)*Input!$D$11*C65)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D65*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G65*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D65*Input!$D$11<=$J$17,$K$17*D65*Input!$D$11,IF(AND(D65*Input!$D$11>$J$17,D65*Input!$D$11<=$J$18),$K$18*(D65*Input!$D$11-$J$17),IF(D65*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D65*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D65*Input!$D$11*C65,\"\")","v":""},"",{"$f":"IFERROR(IF(B65=\"\",\"\",IF(D66<$G$13*(1+$G$17)^(B66-1),D66*$G$7*Input!$D$11*C66,((D66-($G$13*(1+$G$17)^(B66-1)))*$G$6)+($G$13*(1+$G$17)^(B66-1)*$G$7)*Input!$D$11*C66)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D66*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G66*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D66*Input!$D$11<=$J$17,$K$17*D66*Input!$D$11,IF(AND(D66*Input!$D$11>$J$17,D66*Input!$D$11<=$J$18),$K$18*(D66*Input!$D$11-$J$17),IF(D66*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D66*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D66*Input!$D$11*C66,\"\")","v":""},"",{"$f":"IFERROR(IF(B66=\"\",\"\",IF(D67<$G$13*(1+$G$17)^(B67-1),D67*$G$7*Input!$D$11*C67,((D67-($G$13*(1+$G$17)^(B67-1)))*$G$6)+($G$13*(1+$G$17)^(B67-1)*$G$7)*Input!$D$11*C67)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D67*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G67*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D67*Input!$D$11<=$J$17,$K$17*D67*Input!$D$11,IF(AND(D67*Input!$D$11>$J$17,D67*Input!$D$11<=$J$18),$K$18*(D67*Input!$D$11-$J$17),IF(D67*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D67*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D67*Input!$D$11*C67,\"\")","v":""},"",{"$f":"IFERROR(IF(B67=\"\",\"\",IF(D68<$G$13*(1+$G$17)^(B68-1),D68*$G$7*Input!$D$11*C68,((D68-($G$13*(1+$G$17)^(B68-1)))*$G$6)+($G$13*(1+$G$17)^(B68-1)*$G$7)*Input!$D$11*C68)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D68*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G68*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D68*Input!$D$11<=$J$17,$K$17*D68*Input!$D$11,IF(AND(D68*Input!$D$11>$J$17,D68*Input!$D$11<=$J$18),$K$18*(D68*Input!$D$11-$J$17),IF(D68*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D68*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D68*Input!$D$11*C68,\"\")","v":""},"",{"$f":"IFERROR(IF(B68=\"\",\"\",IF(D69<$G$13*(1+$G$17)^(B69-1),D69*$G$7*Input!$D$11*C69,((D69-($G$13*(1+$G$17)^(B69-1)))*$G$6)+($G$13*(1+$G$17)^(B69-1)*$G$7)*Input!$D$11*C69)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D69*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G69*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D69*Input!$D$11<=$J$17,$K$17*D69*Input!$D$11,IF(AND(D69*Input!$D$11>$J$17,D69*Input!$D$11<=$J$18),$K$18*(D69*Input!$D$11-$J$17),IF(D69*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D69*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D69*Input!$D$11*C69,\"\")","v":""},"",{"$f":"IFERROR(IF(B69=\"\",\"\",IF(D70<$G$13*(1+$G$17)^(B70-1),D70*$G$7*Input!$D$11*C70,((D70-($G$13*(1+$G$17)^(B70-1)))*$G$6)+($G$13*(1+$G$17)^(B70-1)*$G$7)*Input!$D$11*C70)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D70*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G70*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D70*Input!$D$11<=$J$17,$K$17*D70*Input!$D$11,IF(AND(D70*Input!$D$11>$J$17,D70*Input!$D$11<=$J$18),$K$18*(D70*Input!$D$11-$J$17),IF(D70*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D70*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D70*Input!$D$11*C70,\"\")","v":""},"",{"$f":"IFERROR(IF(B70=\"\",\"\",IF(D71<$G$13*(1+$G$17)^(B71-1),D71*$G$7*Input!$D$11*C71,((D71-($G$13*(1+$G$17)^(B71-1)))*$G$6)+($G$13*(1+$G$17)^(B71-1)*$G$7)*Input!$D$11*C71)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D71*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G71*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D71*Input!$D$11<=$J$17,$K$17*D71*Input!$D$11,IF(AND(D71*Input!$D$11>$J$17,D71*Input!$D$11<=$J$18),$K$18*(D71*Input!$D$11-$J$17),IF(D71*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D71*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D71*Input!$D$11*C71,\"\")","v":""},"",{"$f":"IFERROR(IF(B71=\"\",\"\",IF(D72<$G$13*(1+$G$17)^(B72-1),D72*$G$7*Input!$D$11*C72,((D72-($G$13*(1+$G$17)^(B72-1)))*$G$6)+($G$13*(1+$G$17)^(B72-1)*$G$7)*Input!$D$11*C72)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D72*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G72*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D72*Input!$D$11<=$J$17,$K$17*D72*Input!$D$11,IF(AND(D72*Input!$D$11>$J$17,D72*Input!$D$11<=$J$18),$K$18*(D72*Input!$D$11-$J$17),IF(D72*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D72*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D72*Input!$D$11*C72,\"\")","v":""},"",{"$f":"IFERROR(IF(B72=\"\",\"\",IF(D73<$G$13*(1+$G$17)^(B73-1),D73*$G$7*Input!$D$11*C73,((D73-($G$13*(1+$G$17)^(B73-1)))*$G$6)+($G$13*(1+$G$17)^(B73-1)*$G$7)*Input!$D$11*C73)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D73*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G73*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D73*Input!$D$11<=$J$17,$K$17*D73*Input!$D$11,IF(AND(D73*Input!$D$11>$J$17,D73*Input!$D$11<=$J$18),$K$18*(D73*Input!$D$11-$J$17),IF(D73*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D73*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D73*Input!$D$11*C73,\"\")","v":""},"",{"$f":"IFERROR(IF(B73=\"\",\"\",IF(D74<$G$13*(1+$G$17)^(B74-1),D74*$G$7*Input!$D$11*C74,((D74-($G$13*(1+$G$17)^(B74-1)))*$G$6)+($G$13*(1+$G$17)^(B74-1)*$G$7)*Input!$D$11*C74)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D74*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G74*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D74*Input!$D$11<=$J$17,$K$17*D74*Input!$D$11,IF(AND(D74*Input!$D$11>$J$17,D74*Input!$D$11<=$J$18),$K$18*(D74*Input!$D$11-$J$17),IF(D74*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D74*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D74*Input!$D$11*C74,\"\")","v":""},"",{"$f":"IFERROR(IF(B74=\"\",\"\",IF(D75<$G$13*(1+$G$17)^(B75-1),D75*$G$7*Input!$D$11*C75,((D75-($G$13*(1+$G$17)^(B75-1)))*$G$6)+($G$13*(1+$G$17)^(B75-1)*$G$7)*Input!$D$11*C75)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D75*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G75*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D75*Input!$D$11<=$J$17,$K$17*D75*Input!$D$11,IF(AND(D75*Input!$D$11>$J$17,D75*Input!$D$11<=$J$18),$K$18*(D75*Input!$D$11-$J$17),IF(D75*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D75*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D75*Input!$D$11*C75,\"\")","v":""},"",{"$f":"IFERROR(IF(B75=\"\",\"\",IF(D76<$G$13*(1+$G$17)^(B76-1),D76*$G$7*Input!$D$11*C76,((D76-($G$13*(1+$G$17)^(B76-1)))*$G$6)+($G$13*(1+$G$17)^(B76-1)*$G$7)*Input!$D$11*C76)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D76*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G76*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D76*Input!$D$11<=$J$17,$K$17*D76*Input!$D$11,IF(AND(D76*Input!$D$11>$J$17,D76*Input!$D$11<=$J$18),$K$18*(D76*Input!$D$11-$J$17),IF(D76*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D76*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D76*Input!$D$11*C76,\"\")","v":""},"",{"$f":"IFERROR(IF(B76=\"\",\"\",IF(D77<$G$13*(1+$G$17)^(B77-1),D77*$G$7*Input!$D$11*C77,((D77-($G$13*(1+$G$17)^(B77-1)))*$G$6)+($G$13*(1+$G$17)^(B77-1)*$G$7)*Input!$D$11*C77)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D77*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G77*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D77*Input!$D$11<=$J$17,$K$17*D77*Input!$D$11,IF(AND(D77*Input!$D$11>$J$17,D77*Input!$D$11<=$J$18),$K$18*(D77*Input!$D$11-$J$17),IF(D77*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D77*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D77*Input!$D$11*C77,\"\")","v":""},"",{"$f":"IFERROR(IF(B77=\"\",\"\",IF(D78<$G$13*(1+$G$17)^(B78-1),D78*$G$7*Input!$D$11*C78,((D78-($G$13*(1+$G$17)^(B78-1)))*$G$6)+($G$13*(1+$G$17)^(B78-1)*$G$7)*Input!$D$11*C78)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D78*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G78*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D78*Input!$D$11<=$J$17,$K$17*D78*Input!$D$11,IF(AND(D78*Input!$D$11>$J$17,D78*Input!$D$11<=$J$18),$K$18*(D78*Input!$D$11-$J$17),IF(D78*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D78*Input!$D$11-$J$18)))),\"\")","v":""},{"$f":"IFERROR(SUM(H78:I78)*(1+$G$19)^(-B78+0.5),\"\")","v":""},{"$f":"IFERROR(SUM(H78:J78)*(1+$G$19)^(-B78+0.5),\"\")","v":""},{"$f":"IFERROR($G$5*D78*Input!$D$11*C78,\"\")","v":""},{"$f":"IFERROR(M78*(1+$G$19)^($S$6-B78),\"\")","v":""},{"$f":"IFERROR(IF(B78=\"\",\"\",IF(D79<$G$13*(1+$G$17)^(B79-1),D79*$G$7*Input!$D$11*C79,((D79-($G$13*(1+$G$17)^(B79-1)))*$G$6)+($G$13*(1+$G$17)^(B79-1)*$G$7)*Input!$D$11*C79)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D79*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G79*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D79*Input!$D$11<=$J$17,$K$17*D79*Input!$D$11,IF(AND(D79*Input!$D$11>$J$17,D79*Input!$D$11<=$J$18),$K$18*(D79*Input!$D$11-$J$17),IF(D79*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D79*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D79*Input!$D$11*C79,\"\")","v":""},"",{"$f":"IFERROR(IF(B79=\"\",\"\",IF(D80<$G$13*(1+$G$17)^(B80-1),D80*$G$7*Input!$D$11*C80,((D80-($G$13*(1+$G$17)^(B80-1)))*$G$6)+($G$13*(1+$G$17)^(B80-1)*$G$7)*Input!$D$11*C80)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D80*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G80*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D80*Input!$D$11<=$J$17,$K$17*D80*Input!$D$11,IF(AND(D80*Input!$D$11>$J$17,D80*Input!$D$11<=$J$18),$K$18*(D80*Input!$D$11-$J$17),IF(D80*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D80*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D80*Input!$D$11*C80,\"\")","v":""},"",{"$f":"IFERROR(IF(B80=\"\",\"\",IF(D81<$G$13*(1+$G$17)^(B81-1),D81*$G$7*Input!$D$11*C81,((D81-($G$13*(1+$G$17)^(B81-1)))*$G$6)+($G$13*(1+$G$17)^(B81-1)*$G$7)*Input!$D$11*C81)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D81*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G81*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D81*Input!$D$11<=$J$17,$K$17*D81*Input!$D$11,IF(AND(D81*Input!$D$11>$J$17,D81*Input!$D$11<=$J$18),$K$18*(D81*Input!$D$11-$J$17),IF(D81*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D81*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D81*Input!$D$11*C81,\"\")","v":""},"",{"$f":"IFERROR(IF(B81=\"\",\"\",IF(D82<$G$13*(1+$G$17)^(B82-1),D82*$G$7*Input!$D$11*C82,((D82-($G$13*(1+$G$17)^(B82-1)))*$G$6)+($G$13*(1+$G$17)^(B82-1)*$G$7)*Input!$D$11*C82)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D82*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G82*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D82*Input!$D$11<=$J$17,$K$17*D82*Input!$D$11,IF(AND(D82*Input!$D$11>$J$17,D82*Input!$D$11<=$J$18),$K$18*(D82*Input!$D$11-$J$17),IF(D82*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D82*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D82*Input!$D$11*C82,\"\")","v":""},"",{"$f":"IFERROR(IF(B82=\"\",\"\",IF(D83<$G$13*(1+$G$17)^(B83-1),D83*$G$7*Input!$D$11*C83,((D83-($G$13*(1+$G$17)^(B83-1)))*$G$6)+($G$13*(1+$G$17)^(B83-1)*$G$7)*Input!$D$11*C83)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D83*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G83*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D83*Input!$D$11<=$J$17,$K$17*D83*Input!$D$11,IF(AND(D83*Input!$D$11>$J$17,D83*Input!$D$11<=$J$18),$K$18*(D83*Input!$D$11-$J$17),IF(D83*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D83*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D83*Input!$D$11*C83,\"\")","v":""},"",{"$f":"IFERROR(IF(B83=\"\",\"\",IF(D84<$G$13*(1+$G$17)^(B84-1),D84*$G$7*Input!$D$11*C84,((D84-($G$13*(1+$G$17)^(B84-1)))*$G$6)+($G$13*(1+$G$17)^(B84-1)*$G$7)*Input!$D$11*C84)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D84*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G84*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D84*Input!$D$11<=$J$17,$K$17*D84*Input!$D$11,IF(AND(D84*Input!$D$11>$J$17,D84*Input!$D$11<=$J$18),$K$18*(D84*Input!$D$11-$J$17),IF(D84*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D84*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D84*Input!$D$11*C84,\"\")","v":""},"",{"$f":"IFERROR(IF(B84=\"\",\"\",IF(D85<$G$13*(1+$G$17)^(B85-1),D85*$G$7*Input!$D$11*C85,((D85-($G$13*(1+$G$17)^(B85-1)))*$G$6)+($G$13*(1+$G$17)^(B85-1)*$G$7)*Input!$D$11*C85)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D85*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G85*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D85*Input!$D$11<=$J$17,$K$17*D85*Input!$D$11,IF(AND(D85*Input!$D$11>$J$17,D85*Input!$D$11<=$J$18),$K$18*(D85*Input!$D$11-$J$17),IF(D85*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D85*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D85*Input!$D$11*C85,\"\")","v":""},"",{"$f":"IFERROR(IF(B85=\"\",\"\",IF(D86<$G$13*(1+$G$17)^(B86-1),D86*$G$7*Input!$D$11*C86,((D86-($G$13*(1+$G$17)^(B86-1)))*$G$6)+($G$13*(1+$G$17)^(B86-1)*$G$7)*Input!$D$11*C86)),\"\")","v":""},""]
[null,"","","","","","",{"$f":"IFERROR($H$25*D86*Input!$D$11,\"\")","v":""},{"$f":"IFERROR($I$25*G86*Input!$D$11,\"\")","v":""},{"$f":"IFERROR(IF(D86*Input!$D$11<=$J$17,$K$17*D86*Input!$D$11,IF(AND(D86*Input!$D$11>$J$17,D86*Input!$D$11<=$J$18),$K$18*(D86*Input!$D$11-$J$17),IF(D86*Input!$D$11>$J$18,$K$18*($J$18-$J$17)+$K$19*(D86*Input!$D$11-$J$18)))),\"\")","v":""},"","",{"$f":"IFERROR($G$5*D86*Input!$D$11*C86,\"\")","v":""},"",{"$f":"IFERROR(IF(B86=\"\",\"\",IF(D87<$G$13*(1+$G$17)^(B87-1),D87*$G$7*Input!$D$11*C87,((D87-($G$13*(1+$G$17)^(B87-1)))*$G$6)+($G$13*(1+$G$17)^(B87-1)*$G$7)*Input!$D$11*C87)),\"\")","v":""},""]