{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["COVER","Inputs","Calculations","Tariffs","Cash flow"],"not_rendered":{"charts":5,"images":3,"macros":0,"external_links":2,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"COVER","index":0,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[5,2,5,15]]}
[]
[null,null,"Mini-grid Retail Tariff Tool"]
[null,null,"Supportive framework conditions for mini-grids employing renewable and hybrid generation in the SADC Region"]
[]
[]
[null,null,"This tool was prepared for the SADC Regional Electricity Regulators’ Association (RERA) by Economic Consulting Associates and Practical Action (Southern Africa). The support of the Africa-EU Renewable Energy Cooperation Programme (RECP), managed by the European Union Energy Initiative Partnership Dialogue Facility (EUEI PDF), is gratefully acknowledged."]
[]
[]
[]
[]
[]
[]
[null," "]
[]
[null,"Note: Model is populated with dummy data for illustrative purposes"]

{"sheet":"Inputs","index":1,"n_rows":83,"n_cols":30,"rows_kept":83,"cut":false,"hidden":false,"merged":[[12,2,18,2],[23,2,29,2],[34,2,40,2],[45,2,51,2],[59,2,65,2]]}
[{"$f":"[1]TITLE!Title_Project","v":"Retail Tariff Tool"}]
["Inputs"]
[null,"Unit","Notes",{"$f":"$D$7","v":2014},{"$f":"D3+1","v":2015},2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040]
[]
["General"]
[]
["First year of costs","year","The first year that costs are incurred",2014]
["First year of operation","year","The year sales begin",2015]
["Tariff period","years","The period over which tariffs stay constant (in real terms) between updates",5]
[]
["Billed consumption"]
[]
["Domestic customers","kWh","Input forecast billed electricity consumption by customer category",null,40000000,{"$f":"E13*(1+2%)","v":40800000},{"$f":"F13*(1+2%)","v":41616000},42448320,43297286.399999999,44163232.127999999,45046496.770559996,45947426.705971196,46866375.240090623,47803702.744892433,48759776.799790286,49734972.335786089,50729671.782501809,51744265.218151845,52779150.52251488,53834733.532965176,54911428.203624479,56009656.767696969,57129849.903050907,58272446.901111923,59437895.839134164,60626653.755916849,61839186.831035189,63075970.567655891,64337489.97900901,65624239.778589189]
["Commercial/industrial customers","kWh",null,null,10000000,{"$f":"E14*(1+2%)","v":10200000},10404000,10612080,10824321.6,11040808.032,11261624.192639999,11486856.676492799,11716593.810022656,11950925.686223108,12189944.199947571,12433743.083946522,12682417.945625452,12936066.304537961,13194787.63062872,13458683.383241294,13727857.05090612,14002414.191924242,14282462.475762727,14568111.725277981,14859473.959783541,15156663.438979212,15459796.707758797,15768992.641913973,16084372.494752252,16406059.944647297]
[null,"kWh"]
[null,"kWh"]
[null,"kWh"]
[null,"kWh"]
[null,"kWh"]
["Total","kWh",null,{"$f":"SUM(D13:D19)","v":0},{"$f":"SUM(E13:E19)","v":50000000},51000000,52020000,53060400,54121608,55204040.159999996,56308120.963199995,57434283.382463992,58582969.050113276,59754628.431115538,60949720.999737859,62168715.419732615,63412089.728127263,64680331.522689804,65973938.1531436,67293416.916206464,68639285.254530594,70012070.959621206,71412312.378813639,72840558.626389906,74297369.798917711,75783317.194896057,77298983.538793981,78844963.209569871,80421862.473761261,82030299.723236486]
[]
["Operating costs"]
[]
["Fuel costs","$","Input operating costs by category. This should include power purchase costs. All cost forecasts should exclude inflation.",null,4050000,4050000,4050000,4050000,4050000,4050000,4050000,4050000,4050000,4050000,4050000,4050000,4050000,4050000,4050000,4050000,4050000,4050000,4050000,4050000,4050000,4050000,4050000,4050000,4050000,4050000]
["Generator maintenance costs","$",null,null,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000]
["Network maintenance costs","$",null,null,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000]
["Administration costs","$",null,null,250000,250000,250000,250000,250000,250000,250000,250000,250000,250000,250000,250000,250000,250000,250000,250000,250000,250000,250000,250000,250000,250000,250000,250000,250000,250000]
["Staff costs","$",null,null,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000,500000]
[null,"$"]
[null,"$"]
["Total","$",null,{"$f":"SUM(D24:D30)","v":0},{"$f":"SUM(E24:E30)","v":5800000},5800000,5800000,5800000,5800000,5800000,5800000,5800000,5800000,5800000,5800000,5800000,5800000,5800000,5800000,5800000,5800000,5800000,5800000,5800000,5800000,5800000,5800000,5800000,5800000,5800000]
[]
["Capital costs (less capital contributions)"]
[]
["Development","$","Input capital costs by asset type. This should be the all-in cost (including interest during construction). Capital contributions should be excluded from capital costs.",1000000]
["Generator","$",null,20000000]
["Network","$",null,4000000]
["Land","$",null,1000000]
["Meters","$",null,200000]
[null,"$"]
[null,"$"]
["Total","$",null,{"$f":"SUM(D35:D41)","v":26200000},{"$f":"SUM(E35:E41)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Average asset lives by asset type"]
[]
[{"$f":"IF(A35<>\"\",A35,\"\")","v":"Development"},"years","Input average asset lives for each asset type entered above. Leave blank or enter NA if asset does not depreciate.",20]
[{"$f":"IF(A36<>\"\",A36,\"\")","v":"Generator"},"years",null,20]
["Network","years",null,20]
["Land","years",null,20]
["Meters","years",null,20]
["","years"]
["","years"]
[]
["Collection rate"]
[]
["Collection rate as a percentage of billed revenue","%","The percentage of billed revenue that is collected.",null,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9]
[]
["Deductible income"]
[]
["Connection and disconnection fees","$","Input non-tariff income that is earned using assets paid for from above costs. This may include connection and disconnection fees, metering reading fees, rental income etc.",null,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000]
["Rental income","$",null,null,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000]
[null,"$"]
[null,"$"]
[null,"$"]
[null,"$"]
[null,"$"]
["Total","$",null,{"$f":"SUM(D60:D66)","v":0},{"$f":"SUM(E60:E66)","v":100000},100000,{"$f":"SUM(G60:G66)","v":100000},{"$f":"SUM(H60:H66)","v":100000},100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000]
[]
["Financing costs"]
[]
["Gearing","%","The percentage of investments financed with debt",0.7]
["Loan period","years","The repayment period of loans",10]
["Interest rate (nominal)"]
["Nominal","%","Interest rate (on loans) including inflation",0.16]
["Real","%","Interest rate (on loans) excluding inflation",{"$f":"D74-D83","v":0.12}]
["Pre-tax return on equity"]
["Nominal","%","The return that the investor expects on equity contributed including inflation, before tax",0.22]
["Real","%","The return that the investor expects on equity contributed excluding inflation, before tax",{"$f":"D77-D83","v":0.18}]
["Weighted average cost of capital (pre-tax real)","%","The weighted average cost of capital employed (used to calculate return on capital)",{"$f":"D75*D71+D78*(1-D71)","v":0.13800000000000001}]
[]
["Inflation"]
[]
["Inflation rate (for indexation of tariff)","%","Assumes that the tariff will be indexed to inflation (to reflect changes in costs over time).",0.04,{"$f":"D83","v":0.04},{"$f":"E83","v":0.04},0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04]

{"sheet":"Calculations","index":2,"n_rows":61,"n_cols":30,"rows_kept":61,"cut":false,"hidden":false,"merged":[[6,2,13,2],[17,2,24,2],[28,2,35,2],[39,2,46,2]]}
[{"$f":"[1]TITLE!Title_Project","v":"Retail Tariff Tool"}]
["Calculations"]
[null,"Unit","Comments",{"$f":"Inputs!$D$7","v":2014},{"$f":"D3+1","v":2015},2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040]
[]
["Opening asset base"]
[]
[{"$f":"IF(Inputs!A35<>\"\",Inputs!A35,\"\")","v":"Development"},"$","The depreciated value of assets as at the start of the year",0,{"$f":"D40","v":1000000},{"$f":"E40","v":950000},902500,857375,814506.25,773780.9375,735091.890625,698337.29609375005,663420.4312890626,630249.40972460946,598736.93923837901,568800.09227646003,540360.087662637,513342.08327950514,487674.97911552986,463291.23015975335,440126.66865176568,{"$f":"U40","v":418120.33521917742},397214.31845821853,377353.60253530758,358485.92240854219,340561.62628811511,323533.54497370933,307356.86772502388,291989.0243387727,277389.57312183408]
[{"$f":"IF(Inputs!A36<>\"\",Inputs!A36,\"\")","v":"Generator"},"$",null,0,{"$f":"D41","v":20000000},19000000,18050000,17147500,16290125,15475618.75,14701837.8125,13966745.921875,13268408.625781249,12604988.194492187,11974738.784767577,11376001.845529199,10807201.753252739,10266841.665590102,9753499.5823105965,9265824.6031950675,8802533.3730353136,8362406.7043835483,7944286.3691643709,7547072.0507061528,7169718.4481708454,6811232.5257623028,6470670.8994741878,6147137.3545004781,5839780.4867754541,5547791.4624366816]
[{"$f":"IF(Inputs!A37<>\"\",Inputs!A37,\"\")","v":"Network"},"$",null,0,4000000,3800000,3610000,3429500,3258025,3095123.75,2940367.5625,2793349.1843750002,2653681.7251562504,2520997.6388984378,2394947.756953516,2275200.3691058401,2161440.350650548,2053368.3331180206,1950699.9164621194,1853164.9206390134,1760506.6746070627,1672481.3408767097,1588857.2738328741,1509414.4101412303,1433943.6896341688,1362246.5051524604,1294134.1798948373,1229427.4709000955,1167956.0973550908,1109558.2924873363]
[{"$f":"IF(Inputs!A38<>\"\",Inputs!A38,\"\")","v":"Land"},"$",null,0,1000000,950000,902500,857375,814506.25,773780.9375,735091.890625,698337.29609375005,663420.4312890626,630249.40972460946,598736.93923837901,568800.09227646003,540360.087662637,513342.08327950514,487674.97911552986,463291.23015975335,440126.66865176568,418120.33521917742,397214.31845821853,377353.60253530758,358485.92240854219,340561.62628811511,323533.54497370933,307356.86772502388,291989.0243387727,277389.57312183408]
[{"$f":"IF(Inputs!A39<>\"\",Inputs!A39,\"\")","v":"Meters"},"$",null,0,200000,190000,180500,171475,162901.25,154756.1875,147018.37812499999,139667.45921874998,132684.08625781248,126049.88194492186,119747.38784767577,113760.01845529198,108072.01753252739,102668.41665590102,97534.995823105972,92658.246031950679,88025.333730353144,83624.067043835486,79442.86369164371,75470.720507061531,71697.184481708449,68112.32525762303,64706.708994741879,61471.373545004782,58397.804867754545,55477.914624366815]
[{"$f":"IF(Inputs!A40<>\"\",Inputs!A40,\"\")","v":""},"$",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(Inputs!A41<>\"\",Inputs!A41,\"\")","v":""},"$",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total","$",null,{"$f":"SUM(D7:D13)","v":0},{"$f":"SUM(E7:E13)","v":26200000},24890000,23645500,22463225,21340063.75,20273060.5625,19259407.534375001,18296437.157656252,17381615.299773436,16512534.534784768,15686907.808045525,14902562.417643249,14157434.296761088,13449562.581923034,12777084.45282688,12138230.23018554,11531318.71867626,10954752.78274245,10407015.143605324,9886664.3864250593,9392331.1671038065,8922714.6087486185,8476578.878311187,8052749.9343956271,7650112.4376758449,7267606.8157920539]
[]
["Capital expenditure"]
[]
[{"$f":"IF(Inputs!A35<>\"\",Inputs!A35,\"\")","v":"Development"},"$","Capital expenditure",{"$f":"Inputs!D35","v":1000000},{"$f":"Inputs!E35","v":0},{"$f":"Inputs!F35","v":0},{"$f":"Inputs!G35","v":0},{"$f":"Inputs!H35","v":0},{"$f":"Inputs!I35","v":0},{"$f":"Inputs!J35","v":0},{"$f":"Inputs!K35","v":0},{"$f":"Inputs!L35","v":0},{"$f":"Inputs!M35","v":0},{"$f":"Inputs!N35","v":0},{"$f":"Inputs!O35","v":0},{"$f":"Inputs!P35","v":0},{"$f":"Inputs!Q35","v":0},{"$f":"Inputs!R35","v":0},{"$f":"Inputs!S35","v":0},{"$f":"Inputs!T35","v":0},{"$f":"Inputs!U35","v":0},{"$f":"Inputs!V35","v":0},{"$f":"Inputs!W35","v":0},{"$f":"Inputs!X35","v":0},{"$f":"Inputs!Y35","v":0},{"$f":"Inputs!Z35","v":0},{"$f":"Inputs!AA35","v":0},{"$f":"Inputs!AB35","v":0},{"$f":"Inputs!AC35","v":0},{"$f":"Inputs!AD35","v":0}]
[{"$f":"IF(Inputs!A36<>\"\",Inputs!A36,\"\")","v":"Generator"},"$",null,{"$f":"Inputs!D36","v":20000000},{"$f":"Inputs!E36","v":0},{"$f":"Inputs!F36","v":0},{"$f":"Inputs!G36","v":0},{"$f":"Inputs!H36","v":0},{"$f":"Inputs!I36","v":0},{"$f":"Inputs!J36","v":0},{"$f":"Inputs!K36","v":0},{"$f":"Inputs!L36","v":0},{"$f":"Inputs!M36","v":0},{"$f":"Inputs!N36","v":0},{"$f":"Inputs!O36","v":0},{"$f":"Inputs!P36","v":0},{"$f":"Inputs!Q36","v":0},{"$f":"Inputs!R36","v":0},{"$f":"Inputs!S36","v":0},{"$f":"Inputs!T36","v":0},{"$f":"Inputs!U36","v":0},{"$f":"Inputs!V36","v":0},{"$f":"Inputs!W36","v":0},{"$f":"Inputs!X36","v":0},{"$f":"Inputs!Y36","v":0},{"$f":"Inputs!Z36","v":0},{"$f":"Inputs!AA36","v":0},{"$f":"Inputs!AB36","v":0},{"$f":"Inputs!AC36","v":0},{"$f":"Inputs!AD36","v":0}]
[{"$f":"IF(Inputs!A37<>\"\",Inputs!A37,\"\")","v":"Network"},"$",null,{"$f":"Inputs!D37","v":4000000},{"$f":"Inputs!E37","v":0},{"$f":"Inputs!F37","v":0},{"$f":"Inputs!G37","v":0},{"$f":"Inputs!H37","v":0},{"$f":"Inputs!I37","v":0},{"$f":"Inputs!J37","v":0},{"$f":"Inputs!K37","v":0},{"$f":"Inputs!L37","v":0},{"$f":"Inputs!M37","v":0},{"$f":"Inputs!N37","v":0},{"$f":"Inputs!O37","v":0},{"$f":"Inputs!P37","v":0},{"$f":"Inputs!Q37","v":0},{"$f":"Inputs!R37","v":0},{"$f":"Inputs!S37","v":0},{"$f":"Inputs!T37","v":0},{"$f":"Inputs!U37","v":0},{"$f":"Inputs!V37","v":0},{"$f":"Inputs!W37","v":0},{"$f":"Inputs!X37","v":0},{"$f":"Inputs!Y37","v":0},{"$f":"Inputs!Z37","v":0},{"$f":"Inputs!AA37","v":0},{"$f":"Inputs!AB37","v":0},{"$f":"Inputs!AC37","v":0},{"$f":"Inputs!AD37","v":0}]
[{"$f":"IF(Inputs!A38<>\"\",Inputs!A38,\"\")","v":"Land"},"$",null,{"$f":"Inputs!D38","v":1000000},{"$f":"Inputs!E38","v":0},{"$f":"Inputs!F38","v":0},{"$f":"Inputs!G38","v":0},{"$f":"Inputs!H38","v":0},{"$f":"Inputs!I38","v":0},{"$f":"Inputs!J38","v":0},{"$f":"Inputs!K38","v":0},{"$f":"Inputs!L38","v":0},{"$f":"Inputs!M38","v":0},{"$f":"Inputs!N38","v":0},{"$f":"Inputs!O38","v":0},{"$f":"Inputs!P38","v":0},{"$f":"Inputs!Q38","v":0},{"$f":"Inputs!R38","v":0},{"$f":"Inputs!S38","v":0},{"$f":"Inputs!T38","v":0},{"$f":"Inputs!U38","v":0},{"$f":"Inputs!V38","v":0},{"$f":"Inputs!W38","v":0},{"$f":"Inputs!X38","v":0},{"$f":"Inputs!Y38","v":0},{"$f":"Inputs!Z38","v":0},{"$f":"Inputs!AA38","v":0},{"$f":"Inputs!AB38","v":0},{"$f":"Inputs!AC38","v":0},{"$f":"Inputs!AD38","v":0}]
[{"$f":"IF(Inputs!A39<>\"\",Inputs!A39,\"\")","v":"Meters"},"$",null,{"$f":"Inputs!D39","v":200000},{"$f":"Inputs!E39","v":0},{"$f":"Inputs!F39","v":0},{"$f":"Inputs!G39","v":0},{"$f":"Inputs!H39","v":0},{"$f":"Inputs!I39","v":0},{"$f":"Inputs!J39","v":0},{"$f":"Inputs!K39","v":0},{"$f":"Inputs!L39","v":0},{"$f":"Inputs!M39","v":0},{"$f":"Inputs!N39","v":0},{"$f":"Inputs!O39","v":0},{"$f":"Inputs!P39","v":0},{"$f":"Inputs!Q39","v":0},{"$f":"Inputs!R39","v":0},{"$f":"Inputs!S39","v":0},{"$f":"Inputs!T39","v":0},{"$f":"Inputs!U39","v":0},{"$f":"Inputs!V39","v":0},{"$f":"Inputs!W39","v":0},{"$f":"Inputs!X39","v":0},{"$f":"Inputs!Y39","v":0},{"$f":"Inputs!Z39","v":0},{"$f":"Inputs!AA39","v":0},{"$f":"Inputs!AB39","v":0},{"$f":"Inputs!AC39","v":0},{"$f":"Inputs!AD39","v":0}]
[{"$f":"IF(Inputs!A40<>\"\",Inputs!A40,\"\")","v":""},"$",null,{"$f":"Inputs!D40","v":0},{"$f":"Inputs!E40","v":0},{"$f":"Inputs!F40","v":0},{"$f":"Inputs!G40","v":0},{"$f":"Inputs!H40","v":0},{"$f":"Inputs!I40","v":0},{"$f":"Inputs!J40","v":0},{"$f":"Inputs!K40","v":0},{"$f":"Inputs!L40","v":0},{"$f":"Inputs!M40","v":0},{"$f":"Inputs!N40","v":0},{"$f":"Inputs!O40","v":0},{"$f":"Inputs!P40","v":0},{"$f":"Inputs!Q40","v":0},{"$f":"Inputs!R40","v":0},{"$f":"Inputs!S40","v":0},{"$f":"Inputs!T40","v":0},{"$f":"Inputs!U40","v":0},{"$f":"Inputs!V40","v":0},{"$f":"Inputs!W40","v":0},{"$f":"Inputs!X40","v":0},{"$f":"Inputs!Y40","v":0},{"$f":"Inputs!Z40","v":0},{"$f":"Inputs!AA40","v":0},{"$f":"Inputs!AB40","v":0},{"$f":"Inputs!AC40","v":0},{"$f":"Inputs!AD40","v":0}]
[{"$f":"IF(Inputs!A41<>\"\",Inputs!A41,\"\")","v":""},"$",null,{"$f":"Inputs!D41","v":0},{"$f":"Inputs!E41","v":0},{"$f":"Inputs!F41","v":0},{"$f":"Inputs!G41","v":0},{"$f":"Inputs!H41","v":0},{"$f":"Inputs!I41","v":0},{"$f":"Inputs!J41","v":0},{"$f":"Inputs!K41","v":0},{"$f":"Inputs!L41","v":0},{"$f":"Inputs!M41","v":0},{"$f":"Inputs!N41","v":0},{"$f":"Inputs!O41","v":0},{"$f":"Inputs!P41","v":0},{"$f":"Inputs!Q41","v":0},{"$f":"Inputs!R41","v":0},{"$f":"Inputs!S41","v":0},{"$f":"Inputs!T41","v":0},{"$f":"Inputs!U41","v":0},{"$f":"Inputs!V41","v":0},{"$f":"Inputs!W41","v":0},{"$f":"Inputs!X41","v":0},{"$f":"Inputs!Y41","v":0},{"$f":"Inputs!Z41","v":0},{"$f":"Inputs!AA41","v":0},{"$f":"Inputs!AB41","v":0},{"$f":"Inputs!AC41","v":0},{"$f":"Inputs!AD41","v":0}]
["Total","$",null,{"$f":"SUM(D18:D24)","v":26200000},{"$f":"SUM(E18:E24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Depreciation"]
[]
[{"$f":"IF(Inputs!A35<>\"\",Inputs!A35,\"\")","v":"Development"},"$","Annual depreciation, calculated based on accellerated rate (using average asset lives). Assumes capital expenditure occurs midway through the year",{"$f":"IF(D$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D46)=TRUE,(D7+D18/2)*1/Inputs!$D46,0),0)","v":0},{"$f":"IF(E$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D46)=TRUE,(E7+E18/2)*1/Inputs!$D46,0),0)","v":50000},{"$f":"IF(F$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D46)=TRUE,(F7+F18/2)*1/Inputs!$D46,0),0)","v":47500},{"$f":"IF(G$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D46)=TRUE,(G7+G18/2)*1/Inputs!$D46,0),0)","v":45125},{"$f":"IF(H$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D46)=TRUE,(H7+H18/2)*1/Inputs!$D46,0),0)","v":42868.75},{"$f":"IF(I$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D46)=TRUE,(I7+I18/2)*1/Inputs!$D46,0),0)","v":40725.3125},{"$f":"IF(J$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D46)=TRUE,(J7+J18/2)*1/Inputs!$D46,0),0)","v":38689.046875},{"$f":"IF(K$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D46)=TRUE,(K7+K18/2)*1/Inputs!$D46,0),0)","v":36754.594531249997},{"$f":"IF(L$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D46)=TRUE,(L7+L18/2)*1/Inputs!$D46,0),0)","v":34916.864804687502},{"$f":"IF(M$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D46)=TRUE,(M7+M18/2)*1/Inputs!$D46,0),0)","v":33171.021564453127},{"$f":"IF(N$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D46)=TRUE,(N7+N18/2)*1/Inputs!$D46,0),0)","v":31512.470486230472},{"$f":"IF(O$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D46)=TRUE,(O7+O18/2)*1/Inputs!$D46,0),0)","v":29936.846961918949},{"$f":"IF(P$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D46)=TRUE,(P7+P18/2)*1/Inputs!$D46,0),0)","v":28440.004613823003},{"$f":"IF(Q$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D46)=TRUE,(Q7+Q18/2)*1/Inputs!$D46,0),0)","v":27018.004383131851},{"$f":"IF(R$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D46)=TRUE,(R7+R18/2)*1/Inputs!$D46,0),0)","v":25667.104163975258},{"$f":"IF(S$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D46)=TRUE,(S7+S18/2)*1/Inputs!$D46,0),0)","v":24383.748955776493},{"$f":"IF(T$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D46)=TRUE,(T7+T18/2)*1/Inputs!$D46,0),0)","v":23164.561507987666},{"$f":"IF(U$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D46)=TRUE,(U7+U18/2)*1/Inputs!$D46,0),0)","v":22006.333432588282},{"$f":"IF(V$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D46)=TRUE,(V7+V18/2)*1/Inputs!$D46,0),0)","v":20906.016760958872},{"$f":"IF(W$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D46)=TRUE,(W7+W18/2)*1/Inputs!$D46,0),0)","v":19860.715922910927},{"$f":"IF(X$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D46)=TRUE,(X7+X18/2)*1/Inputs!$D46,0),0)","v":18867.680126765379},{"$f":"IF(Y$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D46)=TRUE,(Y7+Y18/2)*1/Inputs!$D46,0),0)","v":17924.296120427109},{"$f":"IF(Z$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D46)=TRUE,(Z7+Z18/2)*1/Inputs!$D46,0),0)","v":17028.081314405754},{"$f":"IF(AA$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D46)=TRUE,(AA7+AA18/2)*1/Inputs!$D46,0),0)","v":16176.677248685466},{"$f":"IF(AB$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D46)=TRUE,(AB7+AB18/2)*1/Inputs!$D46,0),0)","v":15367.843386251194},{"$f":"IF(AC$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D46)=TRUE,(AC7+AC18/2)*1/Inputs!$D46,0),0)","v":14599.451216938634},{"$f":"IF(AD$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D46)=TRUE,(AD7+AD18/2)*1/Inputs!$D46,0),0)","v":13869.478656091704}]
[{"$f":"IF(Inputs!A36<>\"\",Inputs!A36,\"\")","v":"Generator"},"$",null,{"$f":"IF(D$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D47)=TRUE,(D8+D19/2)*1/Inputs!$D47,0),0)","v":0},{"$f":"IF(E$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D47)=TRUE,(E8+E19/2)*1/Inputs!$D47,0),0)","v":1000000},{"$f":"IF(F$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D47)=TRUE,(F8+F19/2)*1/Inputs!$D47,0),0)","v":950000},{"$f":"IF(G$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D47)=TRUE,(G8+G19/2)*1/Inputs!$D47,0),0)","v":902500},{"$f":"IF(H$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D47)=TRUE,(H8+H19/2)*1/Inputs!$D47,0),0)","v":857375},{"$f":"IF(I$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D47)=TRUE,(I8+I19/2)*1/Inputs!$D47,0),0)","v":814506.25},{"$f":"IF(J$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D47)=TRUE,(J8+J19/2)*1/Inputs!$D47,0),0)","v":773780.9375},{"$f":"IF(K$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D47)=TRUE,(K8+K19/2)*1/Inputs!$D47,0),0)","v":735091.890625},{"$f":"IF(L$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D47)=TRUE,(L8+L19/2)*1/Inputs!$D47,0),0)","v":698337.29609375005},{"$f":"IF(M$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D47)=TRUE,(M8+M19/2)*1/Inputs!$D47,0),0)","v":663420.43128906249},{"$f":"IF(N$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D47)=TRUE,(N8+N19/2)*1/Inputs!$D47,0),0)","v":630249.40972460934},{"$f":"IF(O$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D47)=TRUE,(O8+O19/2)*1/Inputs!$D47,0),0)","v":598736.93923837889},{"$f":"IF(P$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D47)=TRUE,(P8+P19/2)*1/Inputs!$D47,0),0)","v":568800.09227645991},{"$f":"IF(Q$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D47)=TRUE,(Q8+Q19/2)*1/Inputs!$D47,0),0)","v":540360.087662637},{"$f":"IF(R$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D47)=TRUE,(R8+R19/2)*1/Inputs!$D47,0),0)","v":513342.08327950508},{"$f":"IF(S$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D47)=TRUE,(S8+S19/2)*1/Inputs!$D47,0),0)","v":487674.9791155298},{"$f":"IF(T$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D47)=TRUE,(T8+T19/2)*1/Inputs!$D47,0),0)","v":463291.23015975335},{"$f":"IF(U$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D47)=TRUE,(U8+U19/2)*1/Inputs!$D47,0),0)","v":440126.66865176568},{"$f":"IF(V$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D47)=TRUE,(V8+V19/2)*1/Inputs!$D47,0),0)","v":418120.33521917742},{"$f":"IF(W$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D47)=TRUE,(W8+W19/2)*1/Inputs!$D47,0),0)","v":397214.31845821853},{"$f":"IF(X$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D47)=TRUE,(X8+X19/2)*1/Inputs!$D47,0),0)","v":377353.60253530764},{"$f":"IF(Y$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D47)=TRUE,(Y8+Y19/2)*1/Inputs!$D47,0),0)","v":358485.92240854225},{"$f":"IF(Z$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D47)=TRUE,(Z8+Z19/2)*1/Inputs!$D47,0),0)","v":340561.62628811516},{"$f":"IF(AA$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D47)=TRUE,(AA8+AA19/2)*1/Inputs!$D47,0),0)","v":323533.54497370939},{"$f":"IF(AB$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D47)=TRUE,(AB8+AB19/2)*1/Inputs!$D47,0),0)","v":307356.86772502388},{"$f":"IF(AC$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D47)=TRUE,(AC8+AC19/2)*1/Inputs!$D47,0),0)","v":291989.0243387727},{"$f":"IF(AD$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D47)=TRUE,(AD8+AD19/2)*1/Inputs!$D47,0),0)","v":277389.57312183408}]
[{"$f":"IF(Inputs!A37<>\"\",Inputs!A37,\"\")","v":"Network"},"$",null,{"$f":"IF(D$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D48)=TRUE,(D9+D20/2)*1/Inputs!$D48,0),0)","v":0},{"$f":"IF(E$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D48)=TRUE,(E9+E20/2)*1/Inputs!$D48,0),0)","v":200000},{"$f":"IF(F$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D48)=TRUE,(F9+F20/2)*1/Inputs!$D48,0),0)","v":190000},{"$f":"IF(G$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D48)=TRUE,(G9+G20/2)*1/Inputs!$D48,0),0)","v":180500},{"$f":"IF(H$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D48)=TRUE,(H9+H20/2)*1/Inputs!$D48,0),0)","v":171475},{"$f":"IF(I$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D48)=TRUE,(I9+I20/2)*1/Inputs!$D48,0),0)","v":162901.25},{"$f":"IF(J$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D48)=TRUE,(J9+J20/2)*1/Inputs!$D48,0),0)","v":154756.1875},{"$f":"IF(K$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D48)=TRUE,(K9+K20/2)*1/Inputs!$D48,0),0)","v":147018.37812499999},{"$f":"IF(L$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D48)=TRUE,(L9+L20/2)*1/Inputs!$D48,0),0)","v":139667.45921875001},{"$f":"IF(M$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D48)=TRUE,(M9+M20/2)*1/Inputs!$D48,0),0)","v":132684.08625781251},{"$f":"IF(N$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D48)=TRUE,(N9+N20/2)*1/Inputs!$D48,0),0)","v":126049.88194492189},{"$f":"IF(O$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D48)=TRUE,(O9+O20/2)*1/Inputs!$D48,0),0)","v":119747.3878476758},{"$f":"IF(P$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D48)=TRUE,(P9+P20/2)*1/Inputs!$D48,0),0)","v":113760.01845529201},{"$f":"IF(Q$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D48)=TRUE,(Q9+Q20/2)*1/Inputs!$D48,0),0)","v":108072.0175325274},{"$f":"IF(R$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D48)=TRUE,(R9+R20/2)*1/Inputs!$D48,0),0)","v":102668.41665590103},{"$f":"IF(S$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D48)=TRUE,(S9+S20/2)*1/Inputs!$D48,0),0)","v":97534.995823105972},{"$f":"IF(T$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D48)=TRUE,(T9+T20/2)*1/Inputs!$D48,0),0)","v":92658.246031950664},{"$f":"IF(U$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D48)=TRUE,(U9+U20/2)*1/Inputs!$D48,0),0)","v":88025.33373035313},{"$f":"IF(V$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D48)=TRUE,(V9+V20/2)*1/Inputs!$D48,0),0)","v":83624.067043835486},{"$f":"IF(W$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D48)=TRUE,(W9+W20/2)*1/Inputs!$D48,0),0)","v":79442.86369164371},{"$f":"IF(X$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D48)=TRUE,(X9+X20/2)*1/Inputs!$D48,0),0)","v":75470.720507061516},{"$f":"IF(Y$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D48)=TRUE,(Y9+Y20/2)*1/Inputs!$D48,0),0)","v":71697.184481708435},{"$f":"IF(Z$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D48)=TRUE,(Z9+Z20/2)*1/Inputs!$D48,0),0)","v":68112.325257623015},{"$f":"IF(AA$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D48)=TRUE,(AA9+AA20/2)*1/Inputs!$D48,0),0)","v":64706.708994741864},{"$f":"IF(AB$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D48)=TRUE,(AB9+AB20/2)*1/Inputs!$D48,0),0)","v":61471.373545004775},{"$f":"IF(AC$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D48)=TRUE,(AC9+AC20/2)*1/Inputs!$D48,0),0)","v":58397.804867754538},{"$f":"IF(AD$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D48)=TRUE,(AD9+AD20/2)*1/Inputs!$D48,0),0)","v":55477.914624366815}]
[{"$f":"IF(Inputs!A38<>\"\",Inputs!A38,\"\")","v":"Land"},"$",null,{"$f":"IF(D$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D49)=TRUE,(D10+D21/2)*1/Inputs!$D49,0),0)","v":0},{"$f":"IF(E$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D49)=TRUE,(E10+E21/2)*1/Inputs!$D49,0),0)","v":50000},{"$f":"IF(F$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D49)=TRUE,(F10+F21/2)*1/Inputs!$D49,0),0)","v":47500},{"$f":"IF(G$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D49)=TRUE,(G10+G21/2)*1/Inputs!$D49,0),0)","v":45125},{"$f":"IF(H$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D49)=TRUE,(H10+H21/2)*1/Inputs!$D49,0),0)","v":42868.75},{"$f":"IF(I$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D49)=TRUE,(I10+I21/2)*1/Inputs!$D49,0),0)","v":40725.3125},{"$f":"IF(J$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D49)=TRUE,(J10+J21/2)*1/Inputs!$D49,0),0)","v":38689.046875},{"$f":"IF(K$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D49)=TRUE,(K10+K21/2)*1/Inputs!$D49,0),0)","v":36754.594531249997},{"$f":"IF(L$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D49)=TRUE,(L10+L21/2)*1/Inputs!$D49,0),0)","v":34916.864804687502},{"$f":"IF(M$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D49)=TRUE,(M10+M21/2)*1/Inputs!$D49,0),0)","v":33171.021564453127},{"$f":"IF(N$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D49)=TRUE,(N10+N21/2)*1/Inputs!$D49,0),0)","v":31512.470486230472},{"$f":"IF(O$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D49)=TRUE,(O10+O21/2)*1/Inputs!$D49,0),0)","v":29936.846961918949},{"$f":"IF(P$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D49)=TRUE,(P10+P21/2)*1/Inputs!$D49,0),0)","v":28440.004613823003},{"$f":"IF(Q$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D49)=TRUE,(Q10+Q21/2)*1/Inputs!$D49,0),0)","v":27018.004383131851},{"$f":"IF(R$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D49)=TRUE,(R10+R21/2)*1/Inputs!$D49,0),0)","v":25667.104163975258},{"$f":"IF(S$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D49)=TRUE,(S10+S21/2)*1/Inputs!$D49,0),0)","v":24383.748955776493},{"$f":"IF(T$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D49)=TRUE,(T10+T21/2)*1/Inputs!$D49,0),0)","v":23164.561507987666},{"$f":"IF(U$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D49)=TRUE,(U10+U21/2)*1/Inputs!$D49,0),0)","v":22006.333432588282},{"$f":"IF(V$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D49)=TRUE,(V10+V21/2)*1/Inputs!$D49,0),0)","v":20906.016760958872},{"$f":"IF(W$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D49)=TRUE,(W10+W21/2)*1/Inputs!$D49,0),0)","v":19860.715922910927},{"$f":"IF(X$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D49)=TRUE,(X10+X21/2)*1/Inputs!$D49,0),0)","v":18867.680126765379},{"$f":"IF(Y$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D49)=TRUE,(Y10+Y21/2)*1/Inputs!$D49,0),0)","v":17924.296120427109},{"$f":"IF(Z$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D49)=TRUE,(Z10+Z21/2)*1/Inputs!$D49,0),0)","v":17028.081314405754},{"$f":"IF(AA$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D49)=TRUE,(AA10+AA21/2)*1/Inputs!$D49,0),0)","v":16176.677248685466},{"$f":"IF(AB$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D49)=TRUE,(AB10+AB21/2)*1/Inputs!$D49,0),0)","v":15367.843386251194},{"$f":"IF(AC$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D49)=TRUE,(AC10+AC21/2)*1/Inputs!$D49,0),0)","v":14599.451216938634},{"$f":"IF(AD$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D49)=TRUE,(AD10+AD21/2)*1/Inputs!$D49,0),0)","v":13869.478656091704}]
[{"$f":"IF(Inputs!A39<>\"\",Inputs!A39,\"\")","v":"Meters"},"$",null,{"$f":"IF(D$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D50)=TRUE,(D11+D22/2)*1/Inputs!$D50,0),0)","v":0},{"$f":"IF(E$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D50)=TRUE,(E11+E22/2)*1/Inputs!$D50,0),0)","v":10000},{"$f":"IF(F$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D50)=TRUE,(F11+F22/2)*1/Inputs!$D50,0),0)","v":9500},{"$f":"IF(G$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D50)=TRUE,(G11+G22/2)*1/Inputs!$D50,0),0)","v":9025},{"$f":"IF(H$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D50)=TRUE,(H11+H22/2)*1/Inputs!$D50,0),0)","v":8573.75},{"$f":"IF(I$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D50)=TRUE,(I11+I22/2)*1/Inputs!$D50,0),0)","v":8145.0625},{"$f":"IF(J$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D50)=TRUE,(J11+J22/2)*1/Inputs!$D50,0),0)","v":7737.8093749999998},{"$f":"IF(K$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D50)=TRUE,(K11+K22/2)*1/Inputs!$D50,0),0)","v":7350.9189062499991},{"$f":"IF(L$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D50)=TRUE,(L11+L22/2)*1/Inputs!$D50,0),0)","v":6983.3729609374986},{"$f":"IF(M$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D50)=TRUE,(M11+M22/2)*1/Inputs!$D50,0),0)","v":6634.2043128906244},{"$f":"IF(N$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D50)=TRUE,(N11+N22/2)*1/Inputs!$D50,0),0)","v":6302.4940972460927},{"$f":"IF(O$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D50)=TRUE,(O11+O22/2)*1/Inputs!$D50,0),0)","v":5987.3693923837882},{"$f":"IF(P$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D50)=TRUE,(P11+P22/2)*1/Inputs!$D50,0),0)","v":5688.0009227645987},{"$f":"IF(Q$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D50)=TRUE,(Q11+Q22/2)*1/Inputs!$D50,0),0)","v":5403.6008766263694},{"$f":"IF(R$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D50)=TRUE,(R11+R22/2)*1/Inputs!$D50,0),0)","v":5133.420832795051},{"$f":"IF(S$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D50)=TRUE,(S11+S22/2)*1/Inputs!$D50,0),0)","v":4876.7497911552982},{"$f":"IF(T$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D50)=TRUE,(T11+T22/2)*1/Inputs!$D50,0),0)","v":4632.9123015975338},{"$f":"IF(U$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D50)=TRUE,(U11+U22/2)*1/Inputs!$D50,0),0)","v":4401.266686517657},{"$f":"IF(V$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D50)=TRUE,(V11+V22/2)*1/Inputs!$D50,0),0)","v":4181.2033521917747},{"$f":"IF(W$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D50)=TRUE,(W11+W22/2)*1/Inputs!$D50,0),0)","v":3972.1431845821853},{"$f":"IF(X$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D50)=TRUE,(X11+X22/2)*1/Inputs!$D50,0),0)","v":3773.5360253530766},{"$f":"IF(Y$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D50)=TRUE,(Y11+Y22/2)*1/Inputs!$D50,0),0)","v":3584.8592240854223},{"$f":"IF(Z$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D50)=TRUE,(Z11+Z22/2)*1/Inputs!$D50,0),0)","v":3405.6162628811517},{"$f":"IF(AA$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D50)=TRUE,(AA11+AA22/2)*1/Inputs!$D50,0),0)","v":3235.3354497370938},{"$f":"IF(AB$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D50)=TRUE,(AB11+AB22/2)*1/Inputs!$D50,0),0)","v":3073.568677250239},{"$f":"IF(AC$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D50)=TRUE,(AC11+AC22/2)*1/Inputs!$D50,0),0)","v":2919.8902433877274},{"$f":"IF(AD$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D50)=TRUE,(AD11+AD22/2)*1/Inputs!$D50,0),0)","v":2773.8957312183406}]
[{"$f":"IF(Inputs!A40<>\"\",Inputs!A40,\"\")","v":""},"$",null,{"$f":"IF(D$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D51)=TRUE,(D12+D23/2)*1/Inputs!$D51,0),0)","v":0},{"$f":"IF(E$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D51)=TRUE,(E12+E23/2)*1/Inputs!$D51,0),0)","v":0},{"$f":"IF(F$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D51)=TRUE,(F12+F23/2)*1/Inputs!$D51,0),0)","v":0},{"$f":"IF(G$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D51)=TRUE,(G12+G23/2)*1/Inputs!$D51,0),0)","v":0},{"$f":"IF(H$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D51)=TRUE,(H12+H23/2)*1/Inputs!$D51,0),0)","v":0},{"$f":"IF(I$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D51)=TRUE,(I12+I23/2)*1/Inputs!$D51,0),0)","v":0},{"$f":"IF(J$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D51)=TRUE,(J12+J23/2)*1/Inputs!$D51,0),0)","v":0},{"$f":"IF(K$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D51)=TRUE,(K12+K23/2)*1/Inputs!$D51,0),0)","v":0},{"$f":"IF(L$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D51)=TRUE,(L12+L23/2)*1/Inputs!$D51,0),0)","v":0},{"$f":"IF(M$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D51)=TRUE,(M12+M23/2)*1/Inputs!$D51,0),0)","v":0},{"$f":"IF(N$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D51)=TRUE,(N12+N23/2)*1/Inputs!$D51,0),0)","v":0},{"$f":"IF(O$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D51)=TRUE,(O12+O23/2)*1/Inputs!$D51,0),0)","v":0},{"$f":"IF(P$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D51)=TRUE,(P12+P23/2)*1/Inputs!$D51,0),0)","v":0},{"$f":"IF(Q$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D51)=TRUE,(Q12+Q23/2)*1/Inputs!$D51,0),0)","v":0},{"$f":"IF(R$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D51)=TRUE,(R12+R23/2)*1/Inputs!$D51,0),0)","v":0},{"$f":"IF(S$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D51)=TRUE,(S12+S23/2)*1/Inputs!$D51,0),0)","v":0},{"$f":"IF(T$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D51)=TRUE,(T12+T23/2)*1/Inputs!$D51,0),0)","v":0},{"$f":"IF(U$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D51)=TRUE,(U12+U23/2)*1/Inputs!$D51,0),0)","v":0},{"$f":"IF(V$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D51)=TRUE,(V12+V23/2)*1/Inputs!$D51,0),0)","v":0},{"$f":"IF(W$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D51)=TRUE,(W12+W23/2)*1/Inputs!$D51,0),0)","v":0},{"$f":"IF(X$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D51)=TRUE,(X12+X23/2)*1/Inputs!$D51,0),0)","v":0},{"$f":"IF(Y$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D51)=TRUE,(Y12+Y23/2)*1/Inputs!$D51,0),0)","v":0},{"$f":"IF(Z$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D51)=TRUE,(Z12+Z23/2)*1/Inputs!$D51,0),0)","v":0},{"$f":"IF(AA$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D51)=TRUE,(AA12+AA23/2)*1/Inputs!$D51,0),0)","v":0},{"$f":"IF(AB$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D51)=TRUE,(AB12+AB23/2)*1/Inputs!$D51,0),0)","v":0},{"$f":"IF(AC$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D51)=TRUE,(AC12+AC23/2)*1/Inputs!$D51,0),0)","v":0},{"$f":"IF(AD$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D51)=TRUE,(AD12+AD23/2)*1/Inputs!$D51,0),0)","v":0}]
[{"$f":"IF(Inputs!A41<>\"\",Inputs!A41,\"\")","v":""},"$",null,{"$f":"IF(D$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D52)=TRUE,(D13+D24/2)*1/Inputs!$D52,0),0)","v":0},{"$f":"IF(E$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D52)=TRUE,(E13+E24/2)*1/Inputs!$D52,0),0)","v":0},{"$f":"IF(F$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D52)=TRUE,(F13+F24/2)*1/Inputs!$D52,0),0)","v":0},{"$f":"IF(G$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D52)=TRUE,(G13+G24/2)*1/Inputs!$D52,0),0)","v":0},{"$f":"IF(H$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D52)=TRUE,(H13+H24/2)*1/Inputs!$D52,0),0)","v":0},{"$f":"IF(I$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D52)=TRUE,(I13+I24/2)*1/Inputs!$D52,0),0)","v":0},{"$f":"IF(J$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D52)=TRUE,(J13+J24/2)*1/Inputs!$D52,0),0)","v":0},{"$f":"IF(K$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D52)=TRUE,(K13+K24/2)*1/Inputs!$D52,0),0)","v":0},{"$f":"IF(L$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D52)=TRUE,(L13+L24/2)*1/Inputs!$D52,0),0)","v":0},{"$f":"IF(M$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D52)=TRUE,(M13+M24/2)*1/Inputs!$D52,0),0)","v":0},{"$f":"IF(N$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D52)=TRUE,(N13+N24/2)*1/Inputs!$D52,0),0)","v":0},{"$f":"IF(O$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D52)=TRUE,(O13+O24/2)*1/Inputs!$D52,0),0)","v":0},{"$f":"IF(P$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D52)=TRUE,(P13+P24/2)*1/Inputs!$D52,0),0)","v":0},{"$f":"IF(Q$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D52)=TRUE,(Q13+Q24/2)*1/Inputs!$D52,0),0)","v":0},{"$f":"IF(R$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D52)=TRUE,(R13+R24/2)*1/Inputs!$D52,0),0)","v":0},{"$f":"IF(S$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D52)=TRUE,(S13+S24/2)*1/Inputs!$D52,0),0)","v":0},{"$f":"IF(T$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D52)=TRUE,(T13+T24/2)*1/Inputs!$D52,0),0)","v":0},{"$f":"IF(U$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D52)=TRUE,(U13+U24/2)*1/Inputs!$D52,0),0)","v":0},{"$f":"IF(V$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D52)=TRUE,(V13+V24/2)*1/Inputs!$D52,0),0)","v":0},{"$f":"IF(W$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D52)=TRUE,(W13+W24/2)*1/Inputs!$D52,0),0)","v":0},{"$f":"IF(X$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D52)=TRUE,(X13+X24/2)*1/Inputs!$D52,0),0)","v":0},{"$f":"IF(Y$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D52)=TRUE,(Y13+Y24/2)*1/Inputs!$D52,0),0)","v":0},{"$f":"IF(Z$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D52)=TRUE,(Z13+Z24/2)*1/Inputs!$D52,0),0)","v":0},{"$f":"IF(AA$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D52)=TRUE,(AA13+AA24/2)*1/Inputs!$D52,0),0)","v":0},{"$f":"IF(AB$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D52)=TRUE,(AB13+AB24/2)*1/Inputs!$D52,0),0)","v":0},{"$f":"IF(AC$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D52)=TRUE,(AC13+AC24/2)*1/Inputs!$D52,0),0)","v":0},{"$f":"IF(AD$3>=Inputs!$D$8,IF(ISNUMBER(Inputs!$D52)=TRUE,(AD13+AD24/2)*1/Inputs!$D52,0),0)","v":0}]
["Total","$",null,{"$f":"SUM(D29:D35)","v":0},1310000,1244500,{"$f":"SUM(G29:G35)","v":1182275},1123161.25,1067003.1875,1013653.028125,962970.37671874999,914821.85788281239,869080.76498867187,825626.72673923825,784345.39040227653,745128.12088216259,707871.7148380545,672478.12909615168,638854.22264134407,606911.51150927693,576565.93593381299,547737.63913712231,520350.75718026632,494333.21932125301,469616.55835519027,446135.73043743084,423828.94391555921,402637.49671978125,382505.62188379216,363380.34078960266]
[]
["Closing asset base"]
[]
[{"$f":"IF(Inputs!A35<>\"\",Inputs!A35,\"\")","v":"Development"},"$","The depreciated value of assets as at the end of the year",{"$f":"D7+D18-D29","v":1000000},{"$f":"E7+E18-E29","v":950000},902500,857375,814506.25,773780.9375,735091.890625,698337.29609375005,663420.4312890626,630249.40972460946,598736.93923837901,568800.09227646003,540360.087662637,513342.08327950514,487674.97911552986,463291.23015975335,440126.66865176568,418120.33521917742,397214.31845821853,377353.60253530758,358485.92240854219,340561.62628811511,323533.54497370933,307356.86772502388,291989.0243387727,277389.57312183408,263520.09446574235]
[{"$f":"IF(Inputs!A36<>\"\",Inputs!A36,\"\")","v":"Generator"},"$",null,{"$f":"D8+D19-D30","v":20000000},19000000,18050000,17147500,16290125,15475618.75,14701837.8125,13966745.921875,13268408.625781249,12604988.194492187,11974738.784767577,11376001.845529199,10807201.753252739,10266841.665590102,9753499.5823105965,9265824.6031950675,8802533.3730353136,8362406.7043835483,7944286.3691643709,7547072.0507061528,7169718.4481708454,6811232.5257623028,6470670.8994741878,6147137.3545004781,5839780.4867754541,5547791.4624366816,5270401.8893148471]
[{"$f":"IF(Inputs!A37<>\"\",Inputs!A37,\"\")","v":"Network"},"$",null,4000000,3800000,3610000,3429500,3258025,3095123.75,2940367.5625,2793349.1843750002,2653681.7251562504,2520997.6388984378,2394947.756953516,2275200.3691058401,2161440.350650548,2053368.3331180206,1950699.9164621194,1853164.9206390134,1760506.6746070627,1672481.3408767097,1588857.2738328741,1509414.4101412303,1433943.6896341688,1362246.5051524604,1294134.1798948373,1229427.4709000955,1167956.0973550908,1109558.2924873363,1054080.3778629694]
[{"$f":"IF(Inputs!A38<>\"\",Inputs!A38,\"\")","v":"Land"},"$",null,1000000,950000,902500,857375,814506.25,773780.9375,735091.890625,698337.29609375005,663420.4312890626,630249.40972460946,598736.93923837901,568800.09227646003,540360.087662637,513342.08327950514,487674.97911552986,463291.23015975335,440126.66865176568,418120.33521917742,397214.31845821853,377353.60253530758,358485.92240854219,340561.62628811511,323533.54497370933,307356.86772502388,291989.0243387727,277389.57312183408,263520.09446574235]
[{"$f":"IF(Inputs!A39<>\"\",Inputs!A39,\"\")","v":"Meters"},"$",null,200000,190000,180500,171475,162901.25,154756.1875,147018.37812499999,139667.45921874998,132684.08625781248,126049.88194492186,119747.38784767577,113760.01845529198,108072.01753252739,102668.41665590102,97534.995823105972,92658.246031950679,88025.333730353144,83624.067043835486,79442.86369164371,75470.720507061531,71697.184481708449,68112.32525762303,64706.708994741879,61471.373545004782,58397.804867754545,55477.914624366815,52704.018893148474]
[{"$f":"IF(Inputs!A40<>\"\",Inputs!A40,\"\")","v":""},"$",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(Inputs!A41<>\"\",Inputs!A41,\"\")","v":""},"$",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total","$",null,{"$f":"SUM(D40:D46)","v":26200000},{"$f":"SUM(E40:E46)","v":24890000},23645500,22463225,21340063.75,20273060.5625,19259407.534375001,18296437.157656252,17381615.299773436,16512534.534784768,15686907.808045525,14902562.417643249,14157434.296761088,13449562.581923034,12777084.45282688,12138230.23018554,11531318.71867626,10954752.78274245,10407015.143605324,9886664.3864250593,9392331.1671038065,8922714.6087486185,8476578.878311187,8052749.9343956271,7650112.4376758449,7267606.8157920539,6904226.475002449]
[]
["Return on capital"]
[]
["Return on capital (pre-tax)","$","Return on capital, before tax, calculated as the average of the opening and closing asset base, multiplied by the pre-tax real weighted average cost of capital.",{"$f":"IF(D3>=Inputs!$D$8,AVERAGE(D14,D47)*Inputs!$D$79,0)","v":0},{"$f":"IF(E3>=Inputs!$D$8,AVERAGE(E14,E47)*Inputs!$D$79,0)","v":3525210.0000000005},{"$f":"IF(F3>=Inputs!$D$8,AVERAGE(F14,F47)*Inputs!$D$79,0)","v":3348949.5000000005},{"$f":"IF(G3>=Inputs!$D$8,AVERAGE(G14,G47)*Inputs!$D$79,0)","v":3181502.0250000004},{"$f":"IF(H3>=Inputs!$D$8,AVERAGE(H14,H47)*Inputs!$D$79,0)","v":3022426.9237500001},{"$f":"IF(I3>=Inputs!$D$8,AVERAGE(I14,I47)*Inputs!$D$79,0)","v":2871305.5775625003},{"$f":"IF(J3>=Inputs!$D$8,AVERAGE(J14,J47)*Inputs!$D$79,0)","v":2727740.2986843749},{"$f":"IF(K3>=Inputs!$D$8,AVERAGE(K14,K47)*Inputs!$D$79,0)","v":2591353.2837501564},{"$f":"IF(L3>=Inputs!$D$8,AVERAGE(L14,L47)*Inputs!$D$79,0)","v":2461785.6195626492},{"$f":"IF(M3>=Inputs!$D$8,AVERAGE(M14,M47)*Inputs!$D$79,0)","v":2338696.3385845162},{"$f":"IF(N3>=Inputs!$D$8,AVERAGE(N14,N47)*Inputs!$D$79,0)","v":2221761.5216552904},{"$f":"IF(O3>=Inputs!$D$8,AVERAGE(O14,O47)*Inputs!$D$79,0)","v":2110673.4455725257},{"$f":"IF(P3>=Inputs!$D$8,AVERAGE(P14,P47)*Inputs!$D$79,0)","v":2005139.7732938994},{"$f":"IF(Q3>=Inputs!$D$8,AVERAGE(Q14,Q47)*Inputs!$D$79,0)","v":1904882.7846292045},{"$f":"IF(R3>=Inputs!$D$8,AVERAGE(R14,R47)*Inputs!$D$79,0)","v":1809638.6453977441},{"$f":"IF(S3>=Inputs!$D$8,AVERAGE(S14,S47)*Inputs!$D$79,0)","v":1719156.7131278571},{"$f":"IF(T3>=Inputs!$D$8,AVERAGE(T14,T47)*Inputs!$D$79,0)","v":1633198.8774714645},{"$f":"IF(U3>=Inputs!$D$8,AVERAGE(U14,U47)*Inputs!$D$79,0)","v":1551538.9335978911},{"$f":"IF(V3>=Inputs!$D$8,AVERAGE(V14,V47)*Inputs!$D$79,0)","v":1473961.9869179965},{"$f":"IF(W3>=Inputs!$D$8,AVERAGE(W14,W47)*Inputs!$D$79,0)","v":1400263.8875720967},{"$f":"IF(X3>=Inputs!$D$8,AVERAGE(X14,X47)*Inputs!$D$79,0)","v":1330250.693193492},{"$f":"IF(Y3>=Inputs!$D$8,AVERAGE(Y14,Y47)*Inputs!$D$79,0)","v":1263738.1585338176},{"$f":"IF(Z3>=Inputs!$D$8,AVERAGE(Z14,Z47)*Inputs!$D$79,0)","v":1200551.2506071266},{"$f":"IF(AA3>=Inputs!$D$8,AVERAGE(AA14,AA47)*Inputs!$D$79,0)","v":1140523.6880767702},{"$f":"IF(AB3>=Inputs!$D$8,AVERAGE(AB14,AB47)*Inputs!$D$79,0)","v":1083497.5036729316},{"$f":"IF(AC3>=Inputs!$D$8,AVERAGE(AC14,AC47)*Inputs!$D$79,0)","v":1029322.6284892851},{"$f":"IF(AD3>=Inputs!$D$8,AVERAGE(AD14,AD47)*Inputs!$D$79,0)","v":977856.49706482084}]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"Inputs!$D$7","v":2014},{"$f":"D57+1","v":2015},2016,2017,2018,2019,2020]
["Opening asset value"]
["Plus: Capex"]
["Less: Depreciation"]
["Closing asset value"]

{"sheet":"Tariffs","index":3,"n_rows":42,"n_cols":30,"rows_kept":42,"cut":false,"hidden":false,"merged":[[36,2,38,2],[40,2,41,2],[6,2,9,2],[11,2,12,2],[14,2,15,2],[19,2,20,2],[22,2,26,2],[30,2,32,2]]}
[{"$f":"[1]TITLE!Title_Project","v":"Retail Tariff Tool"}]
["Tariffs"]
[null,"Unit","Comments",{"$f":"Inputs!$D$7","v":2014},{"$f":"D3+1","v":2015},2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040]
[]
["Revenue requirement"]
[]
["Operating costs","$","The three main 'building blocks' of the costs of supplying electricity. ",{"$f":"Inputs!D31","v":0},{"$f":"Inputs!E31","v":5800000},{"$f":"Inputs!F31","v":5800000},{"$f":"Inputs!G31","v":5800000},{"$f":"Inputs!H31","v":5800000},{"$f":"Inputs!I31","v":5800000},{"$f":"Inputs!J31","v":5800000},{"$f":"Inputs!K31","v":5800000},{"$f":"Inputs!L31","v":5800000},{"$f":"Inputs!M31","v":5800000},{"$f":"Inputs!N31","v":5800000},{"$f":"Inputs!O31","v":5800000},{"$f":"Inputs!P31","v":5800000},{"$f":"Inputs!Q31","v":5800000},{"$f":"Inputs!R31","v":5800000},{"$f":"Inputs!S31","v":5800000},{"$f":"Inputs!T31","v":5800000},{"$f":"Inputs!U31","v":5800000},{"$f":"Inputs!V31","v":5800000},{"$f":"Inputs!W31","v":5800000},{"$f":"Inputs!X31","v":5800000},{"$f":"Inputs!Y31","v":5800000},{"$f":"Inputs!Z31","v":5800000},{"$f":"Inputs!AA31","v":5800000},{"$f":"Inputs!AB31","v":5800000},{"$f":"Inputs!AC31","v":5800000},{"$f":"Inputs!AD31","v":5800000}]
["Depreciation","$",null,{"$f":"Calculations!D36","v":0},{"$f":"Calculations!E36","v":1310000},{"$f":"Calculations!F36","v":1244500},{"$f":"Calculations!G36","v":1182275},{"$f":"Calculations!H36","v":1123161.25},{"$f":"Calculations!I36","v":1067003.1875},{"$f":"Calculations!J36","v":1013653.028125},{"$f":"Calculations!K36","v":962970.37671874999},{"$f":"Calculations!L36","v":914821.85788281239},{"$f":"Calculations!M36","v":869080.76498867187},{"$f":"Calculations!N36","v":825626.72673923825},{"$f":"Calculations!O36","v":784345.39040227653},{"$f":"Calculations!P36","v":745128.12088216259},{"$f":"Calculations!Q36","v":707871.7148380545},{"$f":"Calculations!R36","v":672478.12909615168},{"$f":"Calculations!S36","v":638854.22264134407},{"$f":"Calculations!T36","v":606911.51150927693},{"$f":"Calculations!U36","v":576565.93593381299},{"$f":"Calculations!V36","v":547737.63913712231},{"$f":"Calculations!W36","v":520350.75718026632},{"$f":"Calculations!X36","v":494333.21932125301},{"$f":"Calculations!Y36","v":469616.55835519027},{"$f":"Calculations!Z36","v":446135.73043743084},{"$f":"Calculations!AA36","v":423828.94391555921},{"$f":"Calculations!AB36","v":402637.49671978125},{"$f":"Calculations!AC36","v":382505.62188379216},{"$f":"Calculations!AD36","v":363380.34078960266}]
["Return on capital","$",null,{"$f":"Calculations!D51","v":0},{"$f":"Calculations!E51","v":3525210.0000000005},{"$f":"Calculations!F51","v":3348949.5000000005},{"$f":"Calculations!G51","v":3181502.0250000004},{"$f":"Calculations!H51","v":3022426.9237500001},{"$f":"Calculations!I51","v":2871305.5775625003},{"$f":"Calculations!J51","v":2727740.2986843749},{"$f":"Calculations!K51","v":2591353.2837501564},{"$f":"Calculations!L51","v":2461785.6195626492},{"$f":"Calculations!M51","v":2338696.3385845162},{"$f":"Calculations!N51","v":2221761.5216552904},{"$f":"Calculations!O51","v":2110673.4455725257},{"$f":"Calculations!P51","v":2005139.7732938994},{"$f":"Calculations!Q51","v":1904882.7846292045},{"$f":"Calculations!R51","v":1809638.6453977441},{"$f":"Calculations!S51","v":1719156.7131278571},{"$f":"Calculations!T51","v":1633198.8774714645},{"$f":"Calculations!U51","v":1551538.9335978911},{"$f":"Calculations!V51","v":1473961.9869179965},{"$f":"Calculations!W51","v":1400263.8875720967},{"$f":"Calculations!X51","v":1330250.693193492},{"$f":"Calculations!Y51","v":1263738.1585338176},{"$f":"Calculations!Z51","v":1200551.2506071266},{"$f":"Calculations!AA51","v":1140523.6880767702},{"$f":"Calculations!AB51","v":1083497.5036729316},{"$f":"Calculations!AC51","v":1029322.6284892851},{"$f":"Calculations!AD51","v":977856.49706482084}]
["Total costs","$",null,{"$f":"SUM(D7:D9)","v":0},{"$f":"SUM(E7:E9)","v":10635210},10393449.5,10163777.025,9945588.1737500001,9738308.7650624998,9541393.3268093746,9354323.6604689062,9176607.4774454609,9007777.1035731882,8847388.2483945284,8695018.8359748013,8550267.8941760622,8412754.4994672593,8282116.7744938955,8158010.9357692013,8040110.3889807416,7928104.8695317041,7821699.6260551196,7720614.6447523627,7624583.9125147443,7533354.716889007,7446686.9810445569,7364352.6319923289,7286135.0003927127,7211828.2503730766,7141236.8378544236]
[]
["Collection rate","%","Costs are grossed up to reflect the fact that some will never be collected (bad debt)",{"$f":"Inputs!D56","v":0},{"$f":"Inputs!E56","v":0.9},{"$f":"Inputs!F56","v":0.9},{"$f":"Inputs!G56","v":0.9},{"$f":"Inputs!H56","v":0.9},{"$f":"Inputs!I56","v":0.9},{"$f":"Inputs!J56","v":0.9},{"$f":"Inputs!K56","v":0.9},{"$f":"Inputs!L56","v":0.9},{"$f":"Inputs!M56","v":0.9},{"$f":"Inputs!N56","v":0.9},{"$f":"Inputs!O56","v":0.9},{"$f":"Inputs!P56","v":0.9},{"$f":"Inputs!Q56","v":0.9},{"$f":"Inputs!R56","v":0.9},{"$f":"Inputs!S56","v":0.9},{"$f":"Inputs!T56","v":0.9},{"$f":"Inputs!U56","v":0.9},{"$f":"Inputs!V56","v":0.9},{"$f":"Inputs!W56","v":0.9},{"$f":"Inputs!X56","v":0.9},{"$f":"Inputs!Y56","v":0.9},{"$f":"Inputs!Z56","v":0.9},{"$f":"Inputs!AA56","v":0.9},{"$f":"Inputs!AB56","v":0.9},{"$f":"Inputs!AC56","v":0.9},{"$f":"Inputs!AD56","v":0.9}]
["Total costs plus uncollected","$",null,{"$f":"IF(D12>0,D10/D12,0)","v":0},{"$f":"IF(E12>0,E10/E12,0)","v":11816900},{"$f":"IF(F12>0,F10/F12,0)","v":11548277.222222222},11293085.583333334,11050653.526388889,10820343.072291667,10601548.140899304,10393692.956076562,10196230.530494956,10008641.226192432,9830431.3871050309,9661132.0399720017,9500297.6601956245,9347504.9994080663,9202351.9716598839,9064456.5952991117,8933455.9877563789,8809005.4105907828,8690777.3622834664,8578460.7163915131,8471759.9027941599,8370394.1298766742,8274096.6456050631,8182614.035547032,8095705.5559919029,8013142.5004145298,7934707.5976160262]
[]
["Less: Deductible income","$","Non-tariff income is deducted to give the total revenue required to operate the system sustainably.",{"$f":"-Inputs!D67","v":0},{"$f":"-Inputs!E67","v":-100000},{"$f":"-Inputs!F67","v":-100000},{"$f":"-Inputs!G67","v":-100000},{"$f":"-Inputs!H67","v":-100000},{"$f":"-Inputs!I67","v":-100000},{"$f":"-Inputs!J67","v":-100000},{"$f":"-Inputs!K67","v":-100000},{"$f":"-Inputs!L67","v":-100000},{"$f":"-Inputs!M67","v":-100000},{"$f":"-Inputs!N67","v":-100000},{"$f":"-Inputs!O67","v":-100000},{"$f":"-Inputs!P67","v":-100000},{"$f":"-Inputs!Q67","v":-100000},{"$f":"-Inputs!R67","v":-100000},{"$f":"-Inputs!S67","v":-100000},{"$f":"-Inputs!T67","v":-100000},{"$f":"-Inputs!U67","v":-100000},{"$f":"-Inputs!V67","v":-100000},{"$f":"-Inputs!W67","v":-100000},{"$f":"-Inputs!X67","v":-100000},{"$f":"-Inputs!Y67","v":-100000},{"$f":"-Inputs!Z67","v":-100000},{"$f":"-Inputs!AA67","v":-100000},{"$f":"-Inputs!AB67","v":-100000},{"$f":"-Inputs!AC67","v":-100000},{"$f":"-Inputs!AD67","v":-100000}]
["Total revenue requirement","$",null,{"$f":"D13+D15","v":0},11716900,11448277.222222222,11193085.583333334,10950653.526388889,10720343.072291667,10501548.140899304,10293692.956076562,10096230.530494956,9908641.2261924315,9730431.3871050309,9561132.0399720017,9400297.6601956245,9247504.9994080663,9102351.9716598839,8964456.5952991117,8833455.9877563789,8709005.4105907828,8590777.3622834664,8478460.7163915131,8371759.9027941599,8270394.1298766742,8174096.6456050631,8082614.035547032,7995705.5559919029,7913142.5004145298,7834707.5976160262]
[]
["Average tariffs"]
[]
["Revenue requirement","$","Revenue is divided by billed consumption to give the required cost-recovery tariff",{"$f":"D16","v":0},{"$f":"E16","v":11716900},11448277.222222222,11193085.583333334,10950653.526388889,10720343.072291667,10501548.140899304,10293692.956076562,10096230.530494956,9908641.2261924315,9730431.3871050309,9561132.0399720017,9400297.6601956245,9247504.9994080663,9102351.9716598839,8964456.5952991117,8833455.9877563789,8709005.4105907828,8590777.3622834664,8478460.7163915131,8371759.9027941599,8270394.1298766742,8174096.6456050631,8082614.035547032,7995705.5559919029,7913142.5004145298,7834707.5976160262]
["Billed consumption","kWh",null,{"$f":"Inputs!D20","v":0},{"$f":"Inputs!E20","v":50000000},{"$f":"Inputs!F20","v":51000000},{"$f":"Inputs!G20","v":52020000},{"$f":"Inputs!H20","v":53060400},{"$f":"Inputs!I20","v":54121608},{"$f":"Inputs!J20","v":55204040.159999996},{"$f":"Inputs!K20","v":56308120.963199995},{"$f":"Inputs!L20","v":57434283.382463992},{"$f":"Inputs!M20","v":58582969.050113276},{"$f":"Inputs!N20","v":59754628.431115538},{"$f":"Inputs!O20","v":60949720.999737859},{"$f":"Inputs!P20","v":62168715.419732615},{"$f":"Inputs!Q20","v":63412089.728127263},{"$f":"Inputs!R20","v":64680331.522689804},{"$f":"Inputs!S20","v":65973938.1531436},{"$f":"Inputs!T20","v":67293416.916206464},{"$f":"Inputs!U20","v":68639285.254530594},{"$f":"Inputs!V20","v":70012070.959621206},{"$f":"Inputs!W20","v":71412312.378813639},{"$f":"Inputs!X20","v":72840558.626389906},{"$f":"Inputs!Y20","v":74297369.798917711},{"$f":"Inputs!Z20","v":75783317.194896057},{"$f":"Inputs!AA20","v":77298983.538793981},{"$f":"Inputs!AB20","v":78844963.209569871},{"$f":"Inputs!AC20","v":80421862.473761261},{"$f":"Inputs!AD20","v":82030299.723236486}]
[]
["Tariff update?","yes/no","Tariffs are kept constant (in real terms) between updates.",{"$f":"IF((Tariffs!D3-Inputs!$D$8)/Inputs!$D$9=INT((Tariffs!D3-Inputs!$D$8)/Inputs!$D$9),\"Y\",\"N\")","v":"N"},{"$f":"IF((Tariffs!E3-Inputs!$D$8)/Inputs!$D$9=INT((Tariffs!E3-Inputs!$D$8)/Inputs!$D$9),\"Y\",\"N\")","v":"Y"},{"$f":"IF((Tariffs!F3-Inputs!$D$8)/Inputs!$D$9=INT((Tariffs!F3-Inputs!$D$8)/Inputs!$D$9),\"Y\",\"N\")","v":"N"},{"$f":"IF((Tariffs!G3-Inputs!$D$8)/Inputs!$D$9=INT((Tariffs!G3-Inputs!$D$8)/Inputs!$D$9),\"Y\",\"N\")","v":"N"},{"$f":"IF((Tariffs!H3-Inputs!$D$8)/Inputs!$D$9=INT((Tariffs!H3-Inputs!$D$8)/Inputs!$D$9),\"Y\",\"N\")","v":"N"},{"$f":"IF((Tariffs!I3-Inputs!$D$8)/Inputs!$D$9=INT((Tariffs!I3-Inputs!$D$8)/Inputs!$D$9),\"Y\",\"N\")","v":"N"},{"$f":"IF((Tariffs!J3-Inputs!$D$8)/Inputs!$D$9=INT((Tariffs!J3-Inputs!$D$8)/Inputs!$D$9),\"Y\",\"N\")","v":"Y"},{"$f":"IF((Tariffs!K3-Inputs!$D$8)/Inputs!$D$9=INT((Tariffs!K3-Inputs!$D$8)/Inputs!$D$9),\"Y\",\"N\")","v":"N"},{"$f":"IF((Tariffs!L3-Inputs!$D$8)/Inputs!$D$9=INT((Tariffs!L3-Inputs!$D$8)/Inputs!$D$9),\"Y\",\"N\")","v":"N"},{"$f":"IF((Tariffs!M3-Inputs!$D$8)/Inputs!$D$9=INT((Tariffs!M3-Inputs!$D$8)/Inputs!$D$9),\"Y\",\"N\")","v":"N"},{"$f":"IF((Tariffs!N3-Inputs!$D$8)/Inputs!$D$9=INT((Tariffs!N3-Inputs!$D$8)/Inputs!$D$9),\"Y\",\"N\")","v":"N"},{"$f":"IF((Tariffs!O3-Inputs!$D$8)/Inputs!$D$9=INT((Tariffs!O3-Inputs!$D$8)/Inputs!$D$9),\"Y\",\"N\")","v":"Y"},{"$f":"IF((Tariffs!P3-Inputs!$D$8)/Inputs!$D$9=INT((Tariffs!P3-Inputs!$D$8)/Inputs!$D$9),\"Y\",\"N\")","v":"N"},{"$f":"IF((Tariffs!Q3-Inputs!$D$8)/Inputs!$D$9=INT((Tariffs!Q3-Inputs!$D$8)/Inputs!$D$9),\"Y\",\"N\")","v":"N"},{"$f":"IF((Tariffs!R3-Inputs!$D$8)/Inputs!$D$9=INT((Tariffs!R3-Inputs!$D$8)/Inputs!$D$9),\"Y\",\"N\")","v":"N"},{"$f":"IF((Tariffs!S3-Inputs!$D$8)/Inputs!$D$9=INT((Tariffs!S3-Inputs!$D$8)/Inputs!$D$9),\"Y\",\"N\")","v":"N"},{"$f":"IF((Tariffs!T3-Inputs!$D$8)/Inputs!$D$9=INT((Tariffs!T3-Inputs!$D$8)/Inputs!$D$9),\"Y\",\"N\")","v":"Y"},{"$f":"IF((Tariffs!U3-Inputs!$D$8)/Inputs!$D$9=INT((Tariffs!U3-Inputs!$D$8)/Inputs!$D$9),\"Y\",\"N\")","v":"N"},{"$f":"IF((Tariffs!V3-Inputs!$D$8)/Inputs!$D$9=INT((Tariffs!V3-Inputs!$D$8)/Inputs!$D$9),\"Y\",\"N\")","v":"N"},{"$f":"IF((Tariffs!W3-Inputs!$D$8)/Inputs!$D$9=INT((Tariffs!W3-Inputs!$D$8)/Inputs!$D$9),\"Y\",\"N\")","v":"N"},{"$f":"IF((Tariffs!X3-Inputs!$D$8)/Inputs!$D$9=INT((Tariffs!X3-Inputs!$D$8)/Inputs!$D$9),\"Y\",\"N\")","v":"N"},{"$f":"IF((Tariffs!Y3-Inputs!$D$8)/Inputs!$D$9=INT((Tariffs!Y3-Inputs!$D$8)/Inputs!$D$9),\"Y\",\"N\")","v":"Y"},{"$f":"IF((Tariffs!Z3-Inputs!$D$8)/Inputs!$D$9=INT((Tariffs!Z3-Inputs!$D$8)/Inputs!$D$9),\"Y\",\"N\")","v":"N"},{"$f":"IF((Tariffs!AA3-Inputs!$D$8)/Inputs!$D$9=INT((Tariffs!AA3-Inputs!$D$8)/Inputs!$D$9),\"Y\",\"N\")","v":"N"},{"$f":"IF((Tariffs!AB3-Inputs!$D$8)/Inputs!$D$9=INT((Tariffs!AB3-Inputs!$D$8)/Inputs!$D$9),\"Y\",\"N\")","v":"N"},{"$f":"IF((Tariffs!AC3-Inputs!$D$8)/Inputs!$D$9=INT((Tariffs!AC3-Inputs!$D$8)/Inputs!$D$9),\"Y\",\"N\")","v":"N"},{"$f":"IF((Tariffs!AD3-Inputs!$D$8)/Inputs!$D$9=INT((Tariffs!AD3-Inputs!$D$8)/Inputs!$D$9),\"Y\",\"N\")","v":"Y"}]
["NPV (revenue requirement)","$",null,{"$f":"IF(D23=\"Y\",NPV(Inputs!$D$79,OFFSET(D20,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(E23=\"Y\",NPV(Inputs!$D$79,OFFSET(E20,0,0,,Inputs!$D$9)),\"\")","v":38877305.419244207},{"$f":"IF(F23=\"Y\",NPV(Inputs!$D$79,OFFSET(F20,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(G23=\"Y\",NPV(Inputs!$D$79,OFFSET(G20,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(H23=\"Y\",NPV(Inputs!$D$79,OFFSET(H20,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(I23=\"Y\",NPV(Inputs!$D$79,OFFSET(I20,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(J23=\"Y\",NPV(Inputs!$D$79,OFFSET(J20,0,0,,Inputs!$D$9)),\"\")","v":35033570.560646988},{"$f":"IF(K23=\"Y\",NPV(Inputs!$D$79,OFFSET(K20,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(L23=\"Y\",NPV(Inputs!$D$79,OFFSET(L20,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(M23=\"Y\",NPV(Inputs!$D$79,OFFSET(M20,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(N23=\"Y\",NPV(Inputs!$D$79,OFFSET(N20,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(O23=\"Y\",NPV(Inputs!$D$79,OFFSET(O20,0,0,,Inputs!$D$9)),\"\")","v":32059361.798260201},{"$f":"IF(P23=\"Y\",NPV(Inputs!$D$79,OFFSET(P20,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(Q23=\"Y\",NPV(Inputs!$D$79,OFFSET(Q20,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(R23=\"Y\",NPV(Inputs!$D$79,OFFSET(R20,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(S23=\"Y\",NPV(Inputs!$D$79,OFFSET(S20,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(T23=\"Y\",NPV(Inputs!$D$79,OFFSET(T20,0,0,,Inputs!$D$9)),\"\")","v":29757975.753779829},{"$f":"IF(U23=\"Y\",NPV(Inputs!$D$79,OFFSET(U20,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(V23=\"Y\",NPV(Inputs!$D$79,OFFSET(V20,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(W23=\"Y\",NPV(Inputs!$D$79,OFFSET(W20,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(X23=\"Y\",NPV(Inputs!$D$79,OFFSET(X20,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(Y23=\"Y\",NPV(Inputs!$D$79,OFFSET(Y20,0,0,,Inputs!$D$9)),\"\")","v":27977207.102732401},{"$f":"IF(Z23=\"Y\",NPV(Inputs!$D$79,OFFSET(Z20,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(AA23=\"Y\",NPV(Inputs!$D$79,OFFSET(AA20,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(AB23=\"Y\",NPV(Inputs!$D$79,OFFSET(AB20,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(AC23=\"Y\",NPV(Inputs!$D$79,OFFSET(AC20,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(AD23=\"Y\",NPV(Inputs!$D$79,OFFSET(AD20,0,0,,Inputs!$D$9)),\"\")","v":6884628.820400727}]
["NPV (billed consumption)","kWh",null,{"$f":"IF(D23=\"Y\",NPV(Inputs!$D$79,OFFSET(D21,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(E23=\"Y\",NPV(Inputs!$D$79,OFFSET(E21,0,0,,Inputs!$D$9)),\"\")","v":178609492.20923463},{"$f":"IF(F23=\"Y\",NPV(Inputs!$D$79,OFFSET(F21,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(G23=\"Y\",NPV(Inputs!$D$79,OFFSET(G21,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(H23=\"Y\",NPV(Inputs!$D$79,OFFSET(H21,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(I23=\"Y\",NPV(Inputs!$D$79,OFFSET(I21,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(J23=\"Y\",NPV(Inputs!$D$79,OFFSET(J21,0,0,,Inputs!$D$9)),\"\")","v":197199311.61751592},{"$f":"IF(K23=\"Y\",NPV(Inputs!$D$79,OFFSET(K21,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(L23=\"Y\",NPV(Inputs!$D$79,OFFSET(L21,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(M23=\"Y\",NPV(Inputs!$D$79,OFFSET(M21,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(N23=\"Y\",NPV(Inputs!$D$79,OFFSET(N21,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(O23=\"Y\",NPV(Inputs!$D$79,OFFSET(O21,0,0,,Inputs!$D$9)),\"\")","v":217723974.36115405},{"$f":"IF(P23=\"Y\",NPV(Inputs!$D$79,OFFSET(P21,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(Q23=\"Y\",NPV(Inputs!$D$79,OFFSET(Q21,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(R23=\"Y\",NPV(Inputs!$D$79,OFFSET(R21,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(S23=\"Y\",NPV(Inputs!$D$79,OFFSET(S21,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(T23=\"Y\",NPV(Inputs!$D$79,OFFSET(T21,0,0,,Inputs!$D$9)),\"\")","v":240384860.48855913},{"$f":"IF(U23=\"Y\",NPV(Inputs!$D$79,OFFSET(U21,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(V23=\"Y\",NPV(Inputs!$D$79,OFFSET(V21,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(W23=\"Y\",NPV(Inputs!$D$79,OFFSET(W21,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(X23=\"Y\",NPV(Inputs!$D$79,OFFSET(X21,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(Y23=\"Y\",NPV(Inputs!$D$79,OFFSET(Y21,0,0,,Inputs!$D$9)),\"\")","v":265404309.8453283},{"$f":"IF(Z23=\"Y\",NPV(Inputs!$D$79,OFFSET(Z21,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(AA23=\"Y\",NPV(Inputs!$D$79,OFFSET(AA21,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(AB23=\"Y\",NPV(Inputs!$D$79,OFFSET(AB21,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(AC23=\"Y\",NPV(Inputs!$D$79,OFFSET(AC21,0,0,,Inputs!$D$9)),\"\")","v":""},{"$f":"IF(AD23=\"Y\",NPV(Inputs!$D$79,OFFSET(AD21,0,0,,Inputs!$D$9)),\"\")","v":72082864.431666508}]
[]
["Average tariff","$/kWh",null,{"$f":"IF(D25<>\"\",D24/D25,\"\")","v":""},0.21766651334353965,"","","","",0.17765564328438146,"","","","",0.14724773370653746,"","","","",0.12379305291231571,"","","","",0.1054135372520397,"","","","",9.5509922846188408E-2]
[]
["Cost-recovery tariffs"]
[]
["Cost recovery tariff (real)",{"$f":"B27","v":"$/kWh"},"Shows annual tariffs, adjusted at the end of each tariff period, in both real and nominal terms (excluding and including inflation).",{"$f":"IF(D27<>\"\",D27,0)","v":0},{"$f":"IF(E27<>\"\",E27,D31)","v":0.21766651334353965},0.21766651334353965,0.21766651334353965,0.21766651334353965,0.21766651334353965,0.17765564328438146,0.17765564328438146,0.17765564328438146,0.17765564328438146,0.17765564328438146,0.14724773370653746,0.14724773370653746,0.14724773370653746,0.14724773370653746,0.14724773370653746,0.12379305291231571,0.12379305291231571,0.12379305291231571,0.12379305291231571,0.12379305291231571,0.1054135372520397,0.1054135372520397,0.1054135372520397,0.1054135372520397,0.1054135372520397,9.5509922846188408E-2]
["Inflation factor","factor",null,1,{"$f":"D32*(1+Inputs!D83)","v":1.04},{"$f":"E32*(1+Inputs!E83)","v":1.0816000000000001},{"$f":"F32*(1+Inputs!F83)","v":1.1248640000000001},{"$f":"G32*(1+Inputs!G83)","v":1.1698585600000002},{"$f":"H32*(1+Inputs!H83)","v":1.2166529024000003},{"$f":"I32*(1+Inputs!I83)","v":1.2653190184960004},{"$f":"J32*(1+Inputs!J83)","v":1.3159317792358405},{"$f":"K32*(1+Inputs!K83)","v":1.3685690504052741},{"$f":"L32*(1+Inputs!L83)","v":1.4233118124214852},{"$f":"M32*(1+Inputs!M83)","v":1.4802442849183446},{"$f":"N32*(1+Inputs!N83)","v":1.5394540563150785},{"$f":"O32*(1+Inputs!O83)","v":1.6010322185676817},{"$f":"P32*(1+Inputs!P83)","v":1.6650735073103891},{"$f":"Q32*(1+Inputs!Q83)","v":1.7316764476028046},{"$f":"R32*(1+Inputs!R83)","v":1.8009435055069167},{"$f":"S32*(1+Inputs!S83)","v":1.8729812457271935},{"$f":"T32*(1+Inputs!T83)","v":1.9479004955562813},{"$f":"U32*(1+Inputs!U83)","v":2.0258165153785326},{"$f":"V32*(1+Inputs!V83)","v":2.1068491759936738},{"$f":"W32*(1+Inputs!W83)","v":2.1911231430334208},{"$f":"X32*(1+Inputs!X83)","v":2.2787680687547578},{"$f":"Y32*(1+Inputs!Y83)","v":2.369918791504948},{"$f":"Z32*(1+Inputs!Z83)","v":2.4647155431651462},{"$f":"AA32*(1+Inputs!AA83)","v":2.5633041648917523},{"$f":"AB32*(1+Inputs!AB83)","v":2.6658363314874225},{"$f":"AC32*(1+Inputs!AC83)","v":2.7724697847469195}]
["Cost recovery tariff (nominal)","$/kWh",null,{"$f":"IF(D31<>\"\",D31*D32,\"\")","v":0},{"$f":"IF(E31<>\"\",E31*E32,\"\")","v":0.22637317387728123},0.23542810083237251,0.2448452248656674,0.25463903386029413,0.26482459521470592,0.22479106419086911,0.23378270675850391,0.24313401502884405,0.25285937562999783,0.26297375065519774,0.2266811209377316,0.23574836577524089,0.24517830040625052,0.25498543242250055,0.26518484971940054,0.23186206645608146,0.24113654911432472,0.25078201107889769,0.26081329152205363,0.27124582318293577,0.24021300270443821,0.24982152281261574,0.25981438372512039,0.27020695907412523,0.28101523743709028,0.26479837523456684]
[]
["Adjustments to tariffs to improve cashflow"]
[]
["Tariff adjustment factor","factor","Adjustment factors can be used to change the profile of tariffs so that cash flow is improved. Adjustments should be revenue neutral over time. ",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
["Adjusted tariff (real)","$/kWh",null,{"$f":"D32*D36","v":0},{"$f":"E31*E37","v":0.21766651334353965},{"$f":"F31*F37","v":0.21766651334353965},0.21766651334353965,0.21766651334353965,0.21766651334353965,0.17765564328438146,0.17765564328438146,0.17765564328438146,0.17765564328438146,0.17765564328438146,0.14724773370653746,0.14724773370653746,0.14724773370653746,0.14724773370653746,0.14724773370653746,0.12379305291231571,0.12379305291231571,0.12379305291231571,0.12379305291231571,0.12379305291231571,0.1054135372520397,0.1054135372520397,0.1054135372520397,0.1054135372520397,0.1054135372520397,9.5509922846188408E-2]
["Adjusted tariff (nominal)","$/kWh",null,0,0.22637317387728123,0.23542810083237251,0.2448452248656674,0.25463903386029413,0.26482459521470592,0.22479106419086911,0.23378270675850391,0.24313401502884405,0.25285937562999783,0.26297375065519774,0.2266811209377316,0.23574836577524089,0.24517830040625052,0.25498543242250055,0.26518484971940054,{"$f":"T33*T37","v":0.23186206645608146},0.24113654911432472,0.25078201107889769,0.26081329152205363,0.27124582318293577,0.24021300270443821,0.24982152281261574,0.25981438372512039,0.27020695907412523,0.28101523743709028,0.26479837523456684]
[]
["Cash at End of Year","$","Cash flow indicators are calculated on the cash flow worksheet",{"$f":"'Cash flow'!D29","v":0},{"$f":"'Cash flow'!E29","v":-509607.17552234419},{"$f":"'Cash flow'!F29","v":-343537.34731644671},{"$f":"'Cash flow'!G29","v":526381.59044436924},{"$f":"'Cash flow'!H29","v":2130231.8914610455},{"$f":"'Cash flow'!I29","v":4500129.985653135},{"$f":"'Cash flow'!J29","v":5155049.0219076211},{"$f":"'Cash flow'!K29","v":6493956.3183992654},{"$f":"'Cash flow'!L29","v":8546597.8582638018},{"$f":"'Cash flow'!M29","v":11344768.206368154},{"$f":"'Cash flow'!N29","v":14922444.664117942}]
["Debt service coverage","factor",null,null,{"$f":"'Cash flow'!E33","v":0.72213349208160083},{"$f":"'Cash flow'!F33","v":1.09055061516134},{"$f":"'Cash flow'!G33","v":1.4743287555947742},{"$f":"'Cash flow'!H33","v":1.8745094334878278},{"$f":"'Cash flow'!I33","v":2.292201796178893},{"$f":"'Cash flow'!J33","v":1.3570987111529369},{"$f":"'Cash flow'!K33","v":1.730047598959457},{"$f":"'Cash flow'!L33","v":2.1192156705913501},{"$f":"'Cash flow'!M33","v":2.5257199280830709},{"$f":"'Cash flow'!N33","v":2.9507505222190771}]

{"sheet":"Cash flow","index":4,"n_rows":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":false,"merged":[[14,2,15,2]]}
[{"$f":"[1]TITLE!Title_Project","v":"Retail Tariff Tool"}]
["Cash flow analysis"]
[null,"Unit","Comments",{"$f":"Inputs!$D$7","v":2014},{"$f":"D3+1","v":2015},2016,2017,2018,2019,2020,2021,2022,2023,2024]
[]
["Operating cash flows"]
[]
["Tariff revenue collected","$","Total tariff revenue, less the amount no collected",{"$f":"Tariffs!D39*Tariffs!D21*Tariffs!D12","v":0},{"$f":"Tariffs!E39*Tariffs!E21*Tariffs!E12","v":10186792.824477656},{"$f":"Tariffs!F39*Tariffs!F21*Tariffs!F12","v":10806149.828205898},{"$f":"Tariffs!G39*Tariffs!G21*Tariffs!G12","v":11463163.737760816},{"$f":"Tariffs!H39*Tariffs!H21*Tariffs!H12","v":12160124.093016677},{"$f":"Tariffs!I39*Tariffs!I21*Tariffs!I12","v":12899459.637872091},{"$f":"Tariffs!J39*Tariffs!J21*Tariffs!J12","v":11168437.441681689},{"$f":"Tariffs!K39*Tariffs!K21*Tariffs!K12","v":11847478.438135935},{"$f":"Tariffs!L39*Tariffs!L21*Tariffs!L12","v":12567805.127174599},{"$f":"Tariffs!M39*Tariffs!M21*Tariffs!M12","v":13331927.678906817},{"$f":"Tariffs!N39*Tariffs!N21*Tariffs!N12","v":14142508.881784352}]
["Deductible revenue","$","Plus non-tariff revenue",{"$f":"-Tariffs!D15*Tariffs!D32","v":0},{"$f":"-Tariffs!E15*Tariffs!E32","v":104000},{"$f":"-Tariffs!F15*Tariffs!F32","v":108160.00000000001},{"$f":"-Tariffs!G15*Tariffs!G32","v":112486.40000000001},{"$f":"-Tariffs!H15*Tariffs!H32","v":116985.85600000001},{"$f":"-Tariffs!I15*Tariffs!I32","v":121665.29024000003},{"$f":"-Tariffs!J15*Tariffs!J32","v":126531.90184960004},{"$f":"-Tariffs!K15*Tariffs!K32","v":131593.17792358404},{"$f":"-Tariffs!L15*Tariffs!L32","v":136856.9050405274},{"$f":"-Tariffs!M15*Tariffs!M32","v":142331.18124214851},{"$f":"-Tariffs!N15*Tariffs!N32","v":148024.42849183446}]
["Operating costs","$","Less operating costs.",{"$f":"-Tariffs!D7*Tariffs!D32","v":0},{"$f":"-Tariffs!E7*Tariffs!E32","v":-6032000},{"$f":"-Tariffs!F7*Tariffs!F32","v":-6273280.0000000009},{"$f":"-Tariffs!G7*Tariffs!G32","v":-6524211.2000000002},{"$f":"-Tariffs!H7*Tariffs!H32","v":-6785179.648000001},{"$f":"-Tariffs!I7*Tariffs!I32","v":-7056586.833920002},{"$f":"-Tariffs!J7*Tariffs!J32","v":-7338850.3072768021},{"$f":"-Tariffs!K7*Tariffs!K32","v":-7632404.319567875},{"$f":"-Tariffs!L7*Tariffs!L32","v":-7937700.4923505895},{"$f":"-Tariffs!M7*Tariffs!M32","v":-8255208.5120446142},{"$f":"-Tariffs!N7*Tariffs!N32","v":-8585416.8525263984}]
["Interest on loans","$","Plus interest on loans, which is calculated assuming that financing parameters on the Inputs worksheet, and that the investor is unable to refinance (to maintain an optimal capital structure) in these initial years of operation.",null,{"$f":"-(SUM($D20:D20)+SUM($D21:D21))*Inputs!$D$74","v":-2934400},{"$f":"-(SUM($D20:E20)+SUM($D21:E21))*Inputs!$D$74","v":-2640960},{"$f":"-(SUM($D20:F20)+SUM($D21:F21))*Inputs!$D$74","v":-2347520},{"$f":"-(SUM($D20:G20)+SUM($D21:G21))*Inputs!$D$74","v":-2054080},{"$f":"-(SUM($D20:H20)+SUM($D21:H21))*Inputs!$D$74","v":-1760640},{"$f":"-(SUM($D20:I20)+SUM($D21:I21))*Inputs!$D$74","v":-1467200},{"$f":"-(SUM($D20:J20)+SUM($D21:J21))*Inputs!$D$74","v":-1173760},{"$f":"-(SUM($D20:K20)+SUM($D21:K21))*Inputs!$D$74","v":-880320},{"$f":"-(SUM($D20:L20)+SUM($D21:L21))*Inputs!$D$74","v":-586880},{"$f":"-(SUM($D20:M20)+SUM($D21:M21))*Inputs!$D$74","v":-293440}]
["Net operating cash flow","$","Gives the annual operating cash flow",{"$f":"SUM(D7:D10)","v":0},1324392.8244776558,2000069.8282058975,2703918.937760816,3437850.3010166762,4203898.0941920895,2488919.0362544861,3172907.2964916443,3886641.5398645364,4632170.3481043521,5411676.4577497877]
[]
["Investing cash flows"]
[]
["Investment costs","$","The cost of capital expenditure",{"$f":"-Inputs!D42*Tariffs!D32","v":-26200000},{"$f":"-Inputs!E42*Tariffs!E32","v":0},{"$f":"-Inputs!F42*Tariffs!F32","v":0},{"$f":"-Inputs!G42*Tariffs!G32","v":0},{"$f":"-Inputs!H42*Tariffs!H32","v":0},{"$f":"-Inputs!I42*Tariffs!I32","v":0},{"$f":"-Inputs!J42*Tariffs!J32","v":0},{"$f":"-Inputs!K42*Tariffs!K32","v":0},{"$f":"-Inputs!L42*Tariffs!L32","v":0},{"$f":"-Inputs!M42*Tariffs!M32","v":0},{"$f":"-Inputs!N42*Tariffs!N32","v":0}]
["Net investing cash flow","$",null,{"$f":"SUM(D15)","v":-26200000},0,0,0,0,0,{"$f":"SUM(J15)","v":0},0,0,0,0]
[]
["Financing cash flows"]
[]
["Proceeds on loan","$","As above, assumes that capital expenditure is initally financed based with gearing on Inputs worksheet, but that the investor is unable to refinance (to maintain an optimal capital structure) in these initial years of operation.",{"$f":"-Inputs!$D$71*D16","v":18340000},{"$f":"-Inputs!$D$71*E16","v":0},{"$f":"-Inputs!$D$71*F16","v":0},{"$f":"-Inputs!$D$71*G16","v":0},{"$f":"-Inputs!$D$71*H16","v":0},{"$f":"-Inputs!$D$71*I16","v":0},{"$f":"-Inputs!$D$71*J16","v":0},{"$f":"-Inputs!$D$71*K16","v":0},{"$f":"-Inputs!$D$71*L16","v":0},{"$f":"-Inputs!$D$71*M16","v":0},{"$f":"-Inputs!$D$71*N16","v":0}]
["Principal paid on Loan","$","Loan paid based on term of loan",null,{"$f":"-SUM(OFFSET(D20,0,0,,-MIN(COLUMN(D20)-COLUMN($D20)+1,Inputs!$D$72)))/Inputs!$D$72","v":-1834000},{"$f":"-SUM(OFFSET(E20,0,0,,-MIN(COLUMN(E20)-COLUMN($D20)+1,Inputs!$D$72)))/Inputs!$D$72","v":-1834000},{"$f":"-SUM(OFFSET(F20,0,0,,-MIN(COLUMN(F20)-COLUMN($D20)+1,Inputs!$D$72)))/Inputs!$D$72","v":-1834000},{"$f":"-SUM(OFFSET(G20,0,0,,-MIN(COLUMN(G20)-COLUMN($D20)+1,Inputs!$D$72)))/Inputs!$D$72","v":-1834000},{"$f":"-SUM(OFFSET(H20,0,0,,-MIN(COLUMN(H20)-COLUMN($D20)+1,Inputs!$D$72)))/Inputs!$D$72","v":-1834000},{"$f":"-SUM(OFFSET(I20,0,0,,-MIN(COLUMN(I20)-COLUMN($D20)+1,Inputs!$D$72)))/Inputs!$D$72","v":-1834000},{"$f":"-SUM(OFFSET(J20,0,0,,-MIN(COLUMN(J20)-COLUMN($D20)+1,Inputs!$D$72)))/Inputs!$D$72","v":-1834000},{"$f":"-SUM(OFFSET(K20,0,0,,-MIN(COLUMN(K20)-COLUMN($D20)+1,Inputs!$D$72)))/Inputs!$D$72","v":-1834000},{"$f":"-SUM(OFFSET(L20,0,0,,-MIN(COLUMN(L20)-COLUMN($D20)+1,Inputs!$D$72)))/Inputs!$D$72","v":-1834000},{"$f":"-SUM(OFFSET(M20,0,0,,-MIN(COLUMN(M20)-COLUMN($D20)+1,Inputs!$D$72)))/Inputs!$D$72","v":-1834000}]
["Equity contributions","$","Equity share of capital expenditure",{"$f":"-D16*(1-Inputs!$D$71)","v":7860000.0000000009},{"$f":"-E16*(1-Inputs!$D$71)","v":0},{"$f":"-F16*(1-Inputs!$D$71)","v":0},{"$f":"-G16*(1-Inputs!$D$71)","v":0},{"$f":"-H16*(1-Inputs!$D$71)","v":0},{"$f":"-I16*(1-Inputs!$D$71)","v":0},{"$f":"-J16*(1-Inputs!$D$71)","v":0},{"$f":"-K16*(1-Inputs!$D$71)","v":0},{"$f":"-L16*(1-Inputs!$D$71)","v":0},{"$f":"-M16*(1-Inputs!$D$71)","v":0},{"$f":"-N16*(1-Inputs!$D$71)","v":0}]
["Net financing cash flow","$","Gives the anna",{"$f":"SUM(D20:D22)","v":26200000},{"$f":"SUM(E20:E22)","v":-1834000},-1834000,-1834000,-1834000,-1834000,-1834000,-1834000,-1834000,-1834000,-1834000]
[]
["Net cash flows"]
[]
["Cash at Beginning of Year","$",null,0,{"$f":"D29","v":0},{"$f":"E29","v":-509607.17552234419},-343537.34731644671,526381.59044436924,2130231.8914610455,4500129.985653135,5155049.0219076211,6493956.3183992654,8546597.8582638018,11344768.206368154]
["Net Change in Cash","$",null,{"$f":"D11+D16+D23","v":0},{"$f":"E11+E16+E23","v":-509607.17552234419},{"$f":"F11+F16+F23","v":166069.82820589747},869918.93776081596,1603850.3010166762,2369898.0941920895,654919.03625448607,1338907.2964916443,2052641.5398645364,2798170.3481043521,3577676.4577497877]
["Cash at End of Year","$",null,{"$f":"D27+D28","v":0},-509607.17552234419,-343537.34731644671,526381.59044436924,2130231.8914610455,4500129.985653135,5155049.0219076211,6493956.3183992654,8546597.8582638018,11344768.206368154,14922444.664117942]
[]
["Debt service coverage"]
[]
["Debt service coverage ratio","ratio",null,null,{"$f":"IF(E21<>0,E11/-E21,\"\")","v":0.72213349208160083},{"$f":"IF(F21<>0,F11/-F21,\"\")","v":1.09055061516134},1.4743287555947742,1.8745094334878278,2.292201796178893,1.3570987111529369,1.730047598959457,2.1192156705913501,2.5257199280830709,2.9507505222190771]