{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["AER Final Decision","AER Final decision changes","Cover page","Inputs","Calculations","Output","Import Qty"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":1,"defined_names":919,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"AER Final Decision","index":0,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[6,2,6,5]]}
["AER Final Decision for Ergon Energy - Public Lighting Annual Prices"]
[]
[null,null,"Rate 1 & 2 CONV","Rate 1 & 2 LED","Rate 2A LED"]
[null,"X factor (Year 2 to 5)",{"$f":"Inputs!C52","v":-7.0000000000000007E-2},{"$f":"Inputs!D52","v":-7.0000000000000007E-2},{"$f":"Inputs!E52","v":-7.0000000000000007E-2}]
[]
[]
[null,null,"Annual Prices 2025-26"]
[null,"Year","AER Final Decision","Revised Proposal","Difference ($)","Difference (%)"]
[null,"Rate 1 - Ergon Energy Owned & Operated"]
[null,"Major Conventional",{"$f":"Output!C6","v":446.5534795482065},431.7470829964584,{"$f":"C10-D10","v":14.806396551748094},{"$f":"E10/D10","v":3.429414380518131E-2}]
[null,"Minor Conventional",{"$f":"Output!C7","v":266.04936618181227},257.22795374535644,{"$f":"C11-D11","v":8.8214124364558302},{"$f":"E11/D11","v":3.4294143805181504E-2}]
[null,"Major LED",{"$f":"Output!C8","v":173.4418519119599},170.42574553678133,3.0161063751785662,1.7697480892214311E-2]
[null,"Minor LED",{"$f":"Output!C9","v":110.07030617078283},108.1562136464014,1.9140925243814308,1.7697480892214248E-2]
[]
[null,"Rate 2 - Gifted & Ergon Energy Operated"]
[null,"Major Conventional",{"$f":"Output!C12","v":180.33471682616565},174.35534940061822,{"$f":"C16-D16","v":5.979367425547423},3.4294143805181247E-2]
[null,"Minor Conventional",{"$f":"Output!C13","v":118.12585405270931},114.20914907061429,3.9167049820950268,3.4294143805181233E-2]
[null,"Major LED",{"$f":"Output!C14","v":126.67295918295044},124.47015106286437,2.2028081200860612,1.7697480892214231E-2]
[null,"Minor LED",{"$f":"Output!C15","v":84.083951498401092},82.621754575519603,1.4621969228814891,1.7697480892214439E-2]
[]
[null,"Rate 2A"]
[null,"Major LED",{"$f":"Output!C18","v":183.43288020667694},179.68970616642642,{"$f":"C22-D22","v":3.7431740402505227},2.0831321504770232E-2]
[null,"Minor LED",{"$f":"Output!C19","v":116.41084930519702},114.03534242425087,2.3755068809461477,2.083132150477035E-2]

{"sheet":"AER Final decision changes","index":1,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Cells","Description of changes"]
["Inputs' C49 and C50","substituted with ABS inflation rate and discounted rate for smoothing"]
["Inputs' rows 16, 17, 24, 27, 29","updated forecast revenue - from Public Lighting intermediary model"]

{"sheet":"Cover page","index":2,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
["ACS Public Lighting pricing model for Ergon Energy"]
["Regulatory control period 1 July 2025 to 30 June 2030"]

{"sheet":"Inputs","index":3,"n_rows":68,"n_cols":8,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Inputs and Assumptions"]
[]
[null,"Rates"]
[null,"Ergon Energy Owned & Operated","Rate 1"]
[null,"Gifted & Ergon Energy Operated","Rate 2"]
[null,"Rate 2 Energex funded, owned & operated","Rate 2A"]
[]
[]
[]
[]
[null,"Forecast revenue"]
[]
[null,"Year","2025-26","2026-27","2027-28","2028-29","2029-30"]
[null,"Opex revenue required (including tax)"]
[null,"Conventional",2084859.6413296408,1492877.0773548498,950443.3010667112,454654.09573027818,0]
[null,"LED total",8960739.5258912481,9490999.7836740725,9959053.1352104284,10384171.894153668,10785718.19705737]
[null,"LED Rate 1 and Rate 2",{"$f":"Calculations!C50*(Calculations!C10+Calculations!C17)+Calculations!C51*(Calculations!C11+Calculations!C18)","v":8331007.4281812748},{"$f":"Calculations!D50*(Calculations!D10+Calculations!D17)+Calculations!D51*(Calculations!D11+Calculations!D18)","v":8540919.550565362},{"$f":"Calculations!E50*(Calculations!E10+Calculations!E17)+Calculations!E51*(Calculations!E11+Calculations!E18)","v":8743442.6377500892},{"$f":"Calculations!F50*(Calculations!F10+Calculations!F17)+Calculations!F51*(Calculations!F11+Calculations!F18)","v":8940774.3366204388},{"$f":"Calculations!G50*(Calculations!G10+Calculations!G17)+Calculations!G51*(Calculations!G11+Calculations!G18)","v":9141349.4327953495}]
[null,"LED Rate 2A",{"$f":"(Calculations!C50*Calculations!C23)+(Calculations!C51*Calculations!C24)","v":629732.09770997346},{"$f":"(Calculations!D50*Calculations!D23)+(Calculations!D51*Calculations!D24)","v":950080.2331087091},{"$f":"(Calculations!E50*Calculations!E23)+(Calculations!E51*Calculations!E24)","v":1215610.4974603388},{"$f":"(Calculations!F50*Calculations!F23)+(Calculations!F51*Calculations!F24)","v":1443397.5575332283},{"$f":"(Calculations!G50*Calculations!G23)+(Calculations!G51*Calculations!G24)","v":1644368.7642620187}]
[]
[null,"Capex revenue required Conventional"]
[null,"Return on capital"]
[null,"Return of capital"]
[null,"Total Capex Charge Conventional",10023223.452478932,8193785.4205192626,8655093.7953072023,8633352.9118198249,7670524.7385220584]
[]
[null,"Capex revenue required LED"]
[null,"Return on and of capital - Rate 1",6167452.7874381952,8061361.8774235137,8889779.2250033151,10286021.457186894,12682901.074717782]
[null,"Return on and of capital - Rate 2",0,0,0,0,0,"No capex Rate 2 allocation "]
[null,"Return on and of capital - Rate 2A",0,1584624.7516200095,2050358.8687588782,2546011.4801723976,3070259.8560087262]
[null,"Total Capex Charge LED",{"$f":"SUM(C27:C29)","v":6167452.7874381952},{"$f":"SUM(D27:D29)","v":9645986.6290435232},{"$f":"SUM(E27:E29)","v":10940138.093762193},12832032.937359292,15753160.93072651]
[]
[null,"Annual revenue requirement (opex plus capex)"]
[null,"Conventional",{"$f":"C16+C24","v":12108083.093808573},{"$f":"D16+D24","v":9686662.4978741128},9605537.0963739138,9088007.0075501036,7670524.7385220584]
[null,"LED",{"$f":"C17+C30","v":15128192.313329443},{"$f":"D17+D30","v":19136986.412717596},20899191.228972621,23216204.831512958,26538879.12778388]
[null,"Total",{"$f":"C33+C34","v":27236275.407138016},{"$f":"D33+D34","v":28823648.910591707},30504728.325346537,32304211.839063063,34209403.86630594]
[]
[]
[null,"Pricing allocators"]
[]
[null,"Proportion of asset base related to refurbishment",0.1]
[]
[null,"Relativity Major to Minor lights"]
[null,"Opex + tax",1.5]
[null,"Asset charge",1.8]
[]
[]
[null,"Price Smoothing Inputs"]
[]
[null,"Expected CPI",2.4246877296106001E-2]
[null,"Discount rate for smoothing",6.0904457365563006E-2,6.1147989400782261E-2,6.1642310808823882E-2,6.2495592049009147E-2,6.3372173958141334E-2]
[null,null,"Rate 1 & 2 CONV","Rate 1 & 2 LED","Rate 2A LED","Adjustment to manage customer impact in P0"]
[null,"X factor (years 2 to 5)",-7.0000000000000007E-2,{"$f":"C52","v":-7.0000000000000007E-2},{"$f":"C52","v":-7.0000000000000007E-2}]
[]
[null,"Days in year",365.25]
[null,"Days in each year",365,365,365,366,365]
[]
[null,"2024-25 Prices"]
[null,"Rate 1 - Ergon Energy Owned & Operated"]
[null,"Major Conventional",1.1071800000000001]
[null,"Minor Conventional",0.65964]
[null,"Major LED",0.37096000000000001]
[null,"Minor LED",0.23541999999999999]
[]
[null,"Rate 2 - Gifted & Ergon Energy Operated"]
[null,"Major Conventional",0.44712000000000002]
[null,"Minor Conventional",0.29287999999999997]
[null,"Major LED",0.27093]
[null,"Minor LED",0.17984]

{"sheet":"Calculations","index":4,"n_rows":157,"n_cols":7,"rows_kept":157,"cut":false,"hidden":false,"merged":[]}
[null,"Ergon Energy - Public Lighting Pricing Model"]
[]
[null,"Quantites"]
[]
[null,"Year","2025-26","2026-27","2027-28","2028-29","2029-30"]
[null,"Average population of lights"]
[null,"Rate 1 - Ergon Energy Owned & Operated"]
[null,"Major Conventional",{"$f":"'Import Qty'!E18","v":19310.5},{"$f":"'Import Qty'!F18","v":15019.5},{"$f":"'Import Qty'!G18","v":10728},{"$f":"'Import Qty'!H18","v":6436.5},{"$f":"'Import Qty'!I18","v":2145.5}]
[null,"Minor Conventional",{"$f":"'Import Qty'!E19","v":12512.5},{"$f":"'Import Qty'!F19","v":9732},{"$f":"'Import Qty'!G19","v":6951.5},{"$f":"'Import Qty'!H19","v":4171},{"$f":"'Import Qty'!I19","v":1390.5}]
[null,"Major LED",{"$f":"'Import Qty'!E20","v":10011.1},{"$f":"'Import Qty'!F20","v":14140.5},{"$f":"'Import Qty'!G20","v":18525},{"$f":"'Import Qty'!H20","v":22911.5},{"$f":"'Import Qty'!I20","v":27299.5}]
[null,"Minor LED",{"$f":"'Import Qty'!E21","v":61964.2},{"$f":"'Import Qty'!F21","v":64273},{"$f":"'Import Qty'!G21","v":67343.5},{"$f":"'Import Qty'!H21","v":70418},{"$f":"'Import Qty'!I21","v":73496.5}]
[null,"Total",{"$f":"SUM(C8:C11)","v":103798.29999999999},{"$f":"SUM(D8:D11)","v":103165},103548,103937,104332]
[]
[null,"Rate 2 - Gifted & Ergon Energy Operated"]
[null,"Major Conventional",{"$f":"'Import Qty'!E36","v":9219.5},{"$f":"'Import Qty'!F36","v":7171},{"$f":"'Import Qty'!G36","v":5122.5},{"$f":"'Import Qty'!H36","v":3073.5},{"$f":"'Import Qty'!I36","v":1024.5}]
[null,"Minor Conventional",{"$f":"'Import Qty'!E37","v":11816},{"$f":"'Import Qty'!F37","v":9190.5},{"$f":"'Import Qty'!G37","v":6565},{"$f":"'Import Qty'!H37","v":3939},{"$f":"'Import Qty'!I37","v":1313}]
[null,"Major LED",{"$f":"'Import Qty'!E38","v":5672},{"$f":"'Import Qty'!F38","v":7727.5},{"$f":"'Import Qty'!G38","v":9783},{"$f":"'Import Qty'!H38","v":11839},{"$f":"'Import Qty'!I38","v":13895.000000000002}]
[null,"Minor LED",{"$f":"'Import Qty'!E39","v":27613},{"$f":"'Import Qty'!F39","v":31005.5},{"$f":"'Import Qty'!G39","v":33657},{"$f":"'Import Qty'!H39","v":36309.5},{"$f":"'Import Qty'!I39","v":38963}]
[null,"Total",{"$f":"SUM(C15:C18)","v":54320.5},{"$f":"SUM(D15:D18)","v":55094.5},55127.5,55161,55195.5]
[]
[]
[null,"Rate 2A - Rate 2 LED Ergon Energy Funded, Owned & Operated"]
[null,"Major LED",{"$f":"'Import Qty'!E50","v":3073.5},{"$f":"'Import Qty'!F50","v":5122},{"$f":"'Import Qty'!G50","v":7170.5},{"$f":"'Import Qty'!H50","v":9219.5},{"$f":"'Import Qty'!I50","v":11268.500000000002}]
[null,"Minor LED",{"$f":"'Import Qty'!E51","v":3939},{"$f":"'Import Qty'!F51","v":6564.5},{"$f":"'Import Qty'!G51","v":9190},{"$f":"'Import Qty'!H51","v":11816},{"$f":"'Import Qty'!I51","v":14442}]
[null,"Total",{"$f":"SUM(C23:C24)","v":7012.5},{"$f":"SUM(D23:D24)","v":11686.5},16360.5,21035.5,25710.5]
[null,"Grand total "]
[]
[null,"Rate 1 and Rate 2 combined total"]
[null,"Major Conventional",{"$f":"C8+C15","v":28530},{"$f":"D8+D15","v":22190.5},15850.5,9510,3170]
[null,"Minor Conventional",{"$f":"C9+C16","v":24328.5},18922.5,13516.5,8110,2703.5]
[null,"Major LED",{"$f":"C10+C17","v":15683.1},21868,28308,34750.5,41194.5]
[null,"Minor LED",{"$f":"C11+C18","v":89577.2},95278.5,101000.5,106727.5,112459.5]
[null,"Total",{"$f":"SUM(C29:C32)","v":158118.79999999999},{"$f":"SUM(D29:D32)","v":158259.5},158675.5,159098,159527.5]
[]
[null,"Rate 1, Rate 2 and Rate 2A combined total"]
[null,"Major Conventional",{"$f":"C8+C15","v":28530},22190.5,15850.5,9510,3170]
[null,"Minor Conventional",24328.5,18922.5,13516.5,8110,2703.5]
[null,"Major LED",{"$f":"C10+C17+C23","v":18756.599999999999},26990,35478.5,43970,52463]
[null,"Minor LED",93516.2,101843,110190.5,118543.5,126901.5]
[null,"Total",{"$f":"SUM(C36:C39)","v":165131.29999999999},{"$f":"SUM(D36:D39)","v":169946},175036,180133.5,185238]
[]
[]
[null,"Price components"]
[]
[null,"Year","2025-26","2026-27","2027-28","2028-29","2029-30"]
[null,"Opex  charge (per unit)"]
[null,"Same operational expenditure is applied to Rate 1, Rate 2, Rate 2A"]
[null,"Major Conventional",{"$f":"Inputs!C16/(Calculations!C36+Calculations!C37/Inputs!$C$43)","v":46.590083383531272},{"$f":"Inputs!D16/(Calculations!D36+Calculations!D37/Inputs!$C$43)","v":42.89198768455703},{"$f":"Inputs!E16/(Calculations!E36+Calculations!E37/Inputs!$C$43)","v":38.22952360343146},{"$f":"Inputs!F16/(Calculations!F36+Calculations!F37/Inputs!$C$43)","v":30.479604183035406},{"$f":"Inputs!G16/(Calculations!G36+Calculations!G37/Inputs!$C$43)","v":0}]
[null,"Minor Conventional",{"$f":"C48/Inputs!$C$43","v":31.060055589020848},{"$f":"D48/Inputs!$C$43","v":28.594658456371352},{"$f":"E48/Inputs!$C$43","v":25.486349068954308},{"$f":"F48/Inputs!$C$43","v":20.319736122023603},{"$f":"G48/Inputs!$C$43","v":0}]
[null,"Major LED",{"$f":"Inputs!C17/(Calculations!C38+Calculations!C39/Inputs!$C$43)","v":110.48900740590814},{"$f":"Inputs!D17/(Calculations!D38+Calculations!D39/Inputs!$C$43)","v":100.02599401039225},{"$f":"Inputs!E17/(Calculations!E38+Calculations!E39/Inputs!$C$43)","v":91.418760697918515},{"$f":"Inputs!F17/(Calculations!F38+Calculations!F39/Inputs!$C$43)","v":84.424848121965766},{"$f":"Inputs!G17/(Calculations!G38+Calculations!G39/Inputs!$C$43)","v":78.691109241357097}]
[null,"Minor LED",{"$f":"C50/Inputs!$C$43","v":73.659338270605431},{"$f":"D50/Inputs!$C$43","v":66.683996006928169},{"$f":"E50/Inputs!$C$43","v":60.945840465279012},{"$f":"F50/Inputs!$C$43","v":56.283232081310508},{"$f":"G50/Inputs!$C$43","v":52.460739494238062}]
[]
[null,"Rate 1 - Capex Charge (per unit)"]
[null,"Applied only to Rate 1 - Ergon Energy Owned & Operated"]
[null,"Major Conventional",{"$f":"Inputs!C24/(Calculations!C8+Calculations!C9/Inputs!$C$44)*(1-Inputs!$C$40)","v":343.4978019059277},{"$f":"Inputs!D24/(Calculations!D8+Calculations!D9/Inputs!$C$44)*(1-Inputs!$C$40)","v":361.02745066217364},{"$f":"Inputs!E24/(Calculations!E8+Calculations!E9/Inputs!$C$44)*(1-Inputs!$C$40)","v":533.90089629454326},{"$f":"Inputs!F24/(Calculations!F8+Calculations!F9/Inputs!$C$44)*(1-Inputs!$C$40)","v":887.62442117626881},{"$f":"Inputs!G24/(Calculations!G8+Calculations!G9/Inputs!$C$44)*(1-Inputs!$C$40)","v":2365.8232572549186}]
[null,"Minor Conventional",{"$f":"C55/Inputs!$C$44","v":190.83211216995983},{"$f":"D55/Inputs!$C$44","v":200.57080592342979},{"$f":"E55/Inputs!$C$44","v":296.61160905252405},{"$f":"F55/Inputs!$C$44","v":493.12467843126046},{"$f":"G55/Inputs!$C$44","v":1314.3462540305104}]
[null,"Major LED",{"$f":"Inputs!C27/(Calculations!C10+Calculations!C11/Inputs!$C$44)*(1-Inputs!$C$40)","v":124.91562100967812},{"$f":"Inputs!D27/(Calculations!D10+Calculations!D11/Inputs!$C$44)*(1-Inputs!$C$40)","v":145.54778766695117},{"$f":"Inputs!E27/(Calculations!E10+Calculations!E11/Inputs!$C$44)*(1-Inputs!$C$40)","v":143.0296642069886},{"$f":"Inputs!F27/(Calculations!F10+Calculations!F11/Inputs!$C$44)*(1-Inputs!$C$40)","v":149.23471937827298},{"$f":"Inputs!G27/(Calculations!G10+Calculations!G11/Inputs!$C$44)*(1-Inputs!$C$40)","v":167.53943994274752}]
[null,"Minor LED",{"$f":"C57/Inputs!$C$44","v":69.397567227598955},{"$f":"D57/Inputs!$C$44","v":80.859882037195092},{"$f":"E57/Inputs!$C$44","v":79.460924559438112},{"$f":"F57/Inputs!$C$44","v":82.908177432373876},{"$f":"G57/Inputs!$C$44","v":93.077466634859732}]
[]
[null,"Rate 2 - Refurbishment Charge (per unit)"]
[null,"Same refurbishment charge is applied Rate 2 LED and CONV "]
[null,"Major Conventional",{"$f":"Inputs!C24/(Calculations!C15+Calculations!C16/Inputs!$C$44)*Inputs!$C$40","v":63.502652887294325},{"$f":"Inputs!D24/(Calculations!D15+Calculations!D16/Inputs!$C$44)*Inputs!$C$40","v":66.74184782057749},{"$f":"Inputs!E24/(Calculations!E15+Calculations!E16/Inputs!$C$44)*Inputs!$C$40","v":98.692906981425764},{"$f":"Inputs!F24/(Calculations!F15+Calculations!F16/Inputs!$C$44)*Inputs!$C$40","v":164.07499753228896},{"$f":"Inputs!G24/(Calculations!G15+Calculations!G16/Inputs!$C$44)*Inputs!$C$40","v":437.32997147191111}]
[null,"Minor Conventional",{"$f":"C62/Inputs!$C$44","v":35.279251604052405},{"$f":"D62/Inputs!$C$44","v":37.078804344765274},{"$f":"E62/Inputs!$C$44","v":54.829392767458756},{"$f":"F62/Inputs!$C$44","v":91.152776406827201},{"$f":"G62/Inputs!$C$44","v":242.96109526217282}]
[null,"Major LED",{"$f":"Inputs!C27/(Calculations!C17+Calculations!C18/Inputs!$C$44)*Inputs!$C$40","v":29.351274151932316},{"$f":"Inputs!D27/(Calculations!D17+Calculations!D18/Inputs!$C$44)*Inputs!$C$40","v":32.306470843509572},{"$f":"Inputs!E27/(Calculations!E17+Calculations!E18/Inputs!$C$44)*Inputs!$C$40","v":31.21265118090205},{"$f":"Inputs!F27/(Calculations!F17+Calculations!F18/Inputs!$C$44)*Inputs!$C$40","v":32.132827180524039},{"$f":"Inputs!G27/(Calculations!G17+Calculations!G18/Inputs!$C$44)*Inputs!$C$40","v":35.685156367418031}]
[null,"Minor LED",{"$f":"C64/Inputs!$C$44","v":16.306263417740176},{"$f":"D64/Inputs!$C$44","v":17.948039357505319},{"$f":"E64/Inputs!$C$44","v":17.340361767167806},{"$f":"F64/Inputs!$C$44","v":17.85157065584669},{"$f":"G64/Inputs!$C$44","v":19.825086870787796}]
[]
[null,"Rate 2A - Capex Charge (per unit)"]
[null,"Applied only to Rate 2A - Ergon Energy Owned & Operated"]
[null,"Major LED",{"$f":"Inputs!C29/(C23+C24/Inputs!$C$44)","v":0},{"$f":"Inputs!D29/(D23+D24/Inputs!$C$44)","v":180.70872288670353},{"$f":"Inputs!E29/(E23+E24/Inputs!$C$44)","v":167.02098320424952},{"$f":"Inputs!F29/(F23+F24/Inputs!$C$44)","v":161.30387997333139},{"$f":"Inputs!G29/(G23+G24/Inputs!$C$44)","v":159.14816404223163}]
[null,"Minor LED",{"$f":"C69/Inputs!$C$44","v":0},{"$f":"D69/Inputs!$C$44","v":100.39373493705752},{"$f":"E69/Inputs!$C$44","v":92.789435113471953},{"$f":"F69/Inputs!$C$44","v":89.613266651850765},{"$f":"G69/Inputs!$C$44","v":88.415646690128682}]
[]
[]
[]
[null,"Unsmoothed Daily Prices"]
[]
[null,"Rate 1 - Ergon Energy Owned & Operated"]
[null,"Major Conventional",{"$f":"(C48+C55)/Inputs!$C$54","v":1.0680024237904422},{"$f":"(D48+D55)/Inputs!$C$54","v":1.1058711522155529},{"$f":"(E48+E55)/Inputs!$C$54","v":1.5664077204598896},{"$f":"(F48+F55)/Inputs!$C$54","v":2.5136318284991215},{"$f":"(G48+G55)/Inputs!$C$54","v":6.4772710670908111}]
[null,"Minor Conventional",{"$f":"(C49+C56)/Inputs!$C$54","v":0.60750764615737352},{"$f":"(D49+D56)/Inputs!$C$54","v":0.62742084703573209},{"$f":"(E49+E56)/Inputs!$C$54","v":0.88185614817653213},{"$f":"(F49+F56)/Inputs!$C$54","v":1.4057341945332897},{"$f":"(G49+G56)/Inputs!$C$54","v":3.5984839261615615}]
[null,"Major LED",{"$f":"(C50+C57)/Inputs!$C$54","v":0.64450274720215273},{"$f":"(D50+D57)/Inputs!$C$54","v":0.67234437146432147},{"$f":"(E50+E57)/Inputs!$C$54","v":0.64188480466778131},{"$f":"(F50+F57)/Inputs!$C$54","v":0.63972503080147503},{"$f":"(G50+G57)/Inputs!$C$54","v":0.67414250289967048}]
[null,"Minor LED",{"$f":"(C51+C58)/Inputs!$C$54","v":0.39166846132294153},{"$f":"(D51+D58)/Inputs!$C$54","v":0.40395312263962563},{"$f":"(E51+E58)/Inputs!$C$54","v":0.38441277214159375},{"$f":"(F51+F58)/Inputs!$C$54","v":0.38108531009906749},{"$f":"(G51+G58)/Inputs!$C$54","v":0.39846189220834444}]
[]
[null,"Rate 2 - Gifted & Ergon Energy Operated"]
[null,"Major Conventional",{"$f":"(C48+C62)/Inputs!$C$54","v":0.30141748465660673},{"$f":"(D48+D62)/Inputs!$C$54","v":0.30016108283404386},{"$f":"(E48+E62)/Inputs!$C$54","v":0.37487318435279188},{"$f":"(F48+F62)/Inputs!$C$54","v":0.5326614694464733},{"$f":"(G48+G62)/Inputs!$C$54","v":1.1973442066308313}]
[null,"Minor Conventional",{"$f":"(C49+C63)/Inputs!$C$54","v":0.18162712441635387},{"$f":"(D49+D63)/Inputs!$C$54","v":0.17980414182378268},{"$f":"(E49+E63)/Inputs!$C$54","v":0.21989251700592216},{"$f":"(F49+F63)/Inputs!$C$54","v":0.30519510617070716},{"$f":"(G49+G63)/Inputs!$C$54","v":0.66519122590601731}]
[null,"Major LED",{"$f":"(C50+C64)/Inputs!$C$54","v":0.38286182493590815},{"$f":"(D50+D64)/Inputs!$C$54","v":0.36230654306338622},{"$f":"(E50+E64)/Inputs!$C$54","v":0.33574650753954977},{"$f":"(F50+F64)/Inputs!$C$54","v":0.31911752307320956},{"$f":"(G50+G64)/Inputs!$C$54","v":0.31314514882621525}]
[null,"Minor LED",{"$f":"(C51+C65)/Inputs!$C$54","v":0.24631239339725011},{"$f":"(D51+D65)/Inputs!$C$54","v":0.23170988463910608},{"$f":"(E51+E65)/Inputs!$C$54","v":0.21433594040368736},{"$f":"(F51+F65)/Inputs!$C$54","v":0.20297002802780889},{"$f":"(G51+G65)/Inputs!$C$54","v":0.19790780661198043}]
[]
[null,"Rate 2A - Ergon Energy funded Rate 2, Owned & Operated"]
[null,"Major LED",{"$f":"(C50+C69)/Inputs!$C$54","v":0.3025024158957102},{"$f":"(D50+D69)/Inputs!$C$54","v":0.76860976563202132},{"$f":"(E50+E69)/Inputs!$C$54","v":0.70756945626876955},{"$f":"(F50+F69)/Inputs!$C$54","v":0.67276859163667946},{"$f":"(G50+G69)/Inputs!$C$54","v":0.65116844157040032}]
[null,"Minor LED",{"$f":"(C51+C70)/Inputs!$C$54","v":0.20166827726380679},{"$f":"(D51+D70)/Inputs!$C$54","v":0.45743389717723659},{"$f":"(E51+E70)/Inputs!$C$54","v":0.42090424525325382},{"$f":"(F51+F70)/Inputs!$C$54","v":0.39944284389640322},{"$f":"(G51+G70)/Inputs!$C$54","v":0.38569852480319433}]
[]
[]
[null,"Smoothed Daily Prices"]
[]
[null,"Rate 1 - Ergon Energy Owned & Operated"]
[null,"Major Conventional",{"$f":"Inputs!C59*(1+Inputs!$C$49)*(1-$C$146)","v":1.2234341905430315},{"$f":"C96*(1+Inputs!$C$49)*(1-Inputs!$C$52)","v":1.3408155546878584},{"$f":"D96*(1+Inputs!$C$49)*(1-Inputs!$C$52)","v":1.4694589750634213},{"$f":"E96*(1+Inputs!$C$49)*(1-Inputs!$C$52)","v":1.6104449801800869},{"$f":"F96*(1+Inputs!$C$49)*(1-Inputs!$C$52)","v":1.7649577689471083}]
[null,"Minor Conventional",{"$f":"Inputs!C60*(1+Inputs!$C$49)*(1-$C$146)","v":0.72890237310085548},{"$f":"C97*(1+Inputs!$C$49)*(1-Inputs!$C$52)","v":0.79883629806743151},{"$f":"D97*(1+Inputs!$C$49)*(1-Inputs!$C$52)","v":0.87547997462999239},{"$f":"E97*(1+Inputs!$C$49)*(1-Inputs!$C$52)","v":0.95947716426054686},{"$f":"F97*(1+Inputs!$C$49)*(1-Inputs!$C$52)","v":1.0515333935839433}]
[null,"Major LED",{"$f":"Inputs!C61*(1+Inputs!$C$49)*(1-$C$147)","v":0.47518315592317784},{"$f":"C98*(1+Inputs!$C$49)*(1-Inputs!$D$52)","v":0.52077420404988517},{"$f":"D98*(1+Inputs!$C$49)*(1-Inputs!$D$52)","v":0.57073944693367218},{"$f":"E98*(1+Inputs!$C$49)*(1-Inputs!$D$52)","v":0.62549856301052686},{"$f":"F98*(1+Inputs!$C$49)*(1-Inputs!$D$52)","v":0.68551149641090514}]
[null,"Minor LED",{"$f":"Inputs!C62*(1+Inputs!$C$49)*(1-$C$147)","v":0.301562482659679},{"$f":"C99*(1+Inputs!$C$49)*(1-Inputs!$D$52)","v":0.33049564135600595},{"$f":"D99*(1+Inputs!$C$49)*(1-Inputs!$D$52)","v":0.36220476762218334},{"$f":"E99*(1+Inputs!$C$49)*(1-Inputs!$D$52)","v":0.39695619933129783},{"$f":"F99*(1+Inputs!$C$49)*(1-Inputs!$D$52)","v":0.43504182791960128}]
[]
[null,"Rate 2 - Gifted & Ergon Energy Operated"]
[null,"Major Conventional",{"$f":"Inputs!C65*(1+Inputs!$C$49)*(1-$C$146)","v":0.49406771733196064},{"$f":"C102*(1+Inputs!$C$49)*(1-Inputs!$C$52)","v":0.54147062881558117},{"$f":"D102*(1+Inputs!$C$49)*(1-Inputs!$C$52)","v":0.59342157276175223},{"$f":"E102*(1+Inputs!$C$49)*(1-Inputs!$C$52)","v":0.65035690631886445},{"$f":"F102*(1+Inputs!$C$49)*(1-Inputs!$C$52)","v":0.71275485255480675}]
[null,"Minor Conventional",{"$f":"Inputs!C66*(1+Inputs!$C$49)*(1-$C$146)","v":0.32363247685673785},{"$f":"C103*(1+Inputs!$C$49)*(1-Inputs!$C$52)","v":0.35468312257896628},{"$f":"D103*(1+Inputs!$C$49)*(1-Inputs!$C$52)","v":0.38871289638231787},{"$f":"E103*(1+Inputs!$C$49)*(1-Inputs!$C$52)","v":0.42600762820421589},{"$f":"F103*(1+Inputs!$C$49)*(1-Inputs!$C$52)","v":0.46688057169496283}]
[null,"Major LED",{"$f":"Inputs!C67*(1+Inputs!$C$49)*(1-$C$147)","v":0.34704920324096011},{"$f":"C104*(1+Inputs!$C$49)*(1-Inputs!$D$52)","v":0.38034654707579091},{"$f":"D104*(1+Inputs!$C$49)*(1-Inputs!$D$52)","v":0.41683857655202666},{"$f":"E104*(1+Inputs!$C$49)*(1-Inputs!$D$52)","v":0.45683180309586485},{"$f":"F104*(1+Inputs!$C$49)*(1-Inputs!$D$52)","v":0.50066214611442339}]
[null,"Minor LED",{"$f":"Inputs!C68*(1+Inputs!$C$49)*(1-$C$147)","v":0.23036699040657835},{"$f":"C105*(1+Inputs!$C$49)*(1-Inputs!$D$52)","v":0.25246935749496269},{"$f":"D105*(1+Inputs!$C$49)*(1-Inputs!$D$52)","v":0.2766923175990717},{"$f":"E105*(1+Inputs!$C$49)*(1-Inputs!$D$52)","v":0.30323932923175856},{"$f":"F105*(1+Inputs!$C$49)*(1-Inputs!$D$52)","v":0.3323333715617241}]
[]
[null,"Rate 2A - Ergon Energy funded Rate 2, Owned & Operated"]
[null,"Major LED",{"$f":"Inputs!C61*(1+Inputs!$C$49)*(1-$C$148)","v":0.50255583618267652},{"$f":"C108*(1+Inputs!$C$49)*(1-Inputs!$E$52)","v":0.55077313308843268},{"$f":"D108*(1+Inputs!$C$49)*(1-Inputs!$E$52)","v":0.60361659798092915},{"$f":"E108*(1+Inputs!$C$49)*(1-Inputs!$E$52)","v":0.6615300846556903},{"$f":"F108*(1+Inputs!$C$49)*(1-Inputs!$E$52)","v":0.72500003208724084}]
[null,"Minor LED",{"$f":"Inputs!C62*(1+Inputs!$C$49)*(1-$C$148)","v":0.31893383371286854},{"$f":"C109*(1+Inputs!$C$49)*(1-Inputs!$E$52)","v":0.3495336720715948},{"$f":"D109*(1+Inputs!$C$49)*(1-Inputs!$E$52)","v":0.38306938617821418},{"$f":"E109*(1+Inputs!$C$49)*(1-Inputs!$E$52)","v":0.419822656161426},{"$f":"F109*(1+Inputs!$C$49)*(1-Inputs!$E$52)","v":0.46010218771290223}]
[]
[null,"Revenue checks"]
[]
[null,"Cummulative discount rate (used for NPV calculation)",{"$f":"1*(1+Inputs!C50)","v":1.060904457365563},{"$f":"C113*(1+Inputs!D50)","v":1.125776631879795},{"$f":"D113*(1+Inputs!E50)","v":1.1951721049234405},{"$f":"E113*(1+Inputs!F50)","v":1.2698650932210913},{"$f":"F113*(1+Inputs!G50)","v":1.3503392048120697}]
[]
[null,"Conventional Rate 1 and Rate 2"]
[null,"Unsmoothed Prices x Volumes - Conventional",{"$f":"(SUMPRODUCT(C8:C9,C77:C78)+SUMPRODUCT(C15:C16,C83:C84))*Inputs!$C$54","v":12108083.093808573},{"$f":"(SUMPRODUCT(D8:D9,D77:D78)+SUMPRODUCT(D15:D16,D83:D84))*Inputs!$C$54","v":9686662.4978741109},{"$f":"(SUMPRODUCT(E8:E9,E77:E78)+SUMPRODUCT(E15:E16,E83:E84))*Inputs!$C$54","v":9605537.0963739119},{"$f":"(SUMPRODUCT(F8:F9,F77:F78)+SUMPRODUCT(F15:F16,F83:F84))*Inputs!$C$54","v":9088007.0075501017},{"$f":"(SUMPRODUCT(G8:G9,G77:G78)+SUMPRODUCT(G15:G16,G83:G84))*Inputs!$C$54","v":7670524.7385220593}]
[null,"Revenue requirement - Conventional",{"$f":"Inputs!C33","v":12108083.093808573},{"$f":"Inputs!D33","v":9686662.4978741128},{"$f":"Inputs!E33","v":9605537.0963739138},{"$f":"Inputs!F33","v":9088007.0075501036},{"$f":"Inputs!G33","v":7670524.7385220584}]
[null,"Check",{"$f":"C116-C117","v":0},{"$f":"D116-D117","v":0},0,0,0]
[]
[null,"LED Rate 1 and Rate 2"]
[null,"Unsmoothed Prices x Volumes - LED",{"$f":"(SUMPRODUCT(C10:C11,C79:C80)+SUMPRODUCT(C17:C18,C85:C86))*Inputs!$C$54","v":14498460.215619471},{"$f":"(SUMPRODUCT(D10:D11,D79:D80)+SUMPRODUCT(D17:D18,D85:D86))*Inputs!$C$54","v":16602281.427988879},{"$f":"(SUMPRODUCT(E10:E11,E79:E80)+SUMPRODUCT(E17:E18,E85:E86))*Inputs!$C$54","v":17633221.862753402},{"$f":"(SUMPRODUCT(F10:F11,F79:F80)+SUMPRODUCT(F17:F18,F85:F86))*Inputs!$C$54","v":19226795.793807335},{"$f":"(SUMPRODUCT(G10:G11,G79:G80)+SUMPRODUCT(G17:G18,G85:G86))*Inputs!$C$54","v":21824250.507513136}]
[null,"Revenue requirement - LED",{"$f":"Inputs!C27+Inputs!C18","v":14498460.215619471},{"$f":"Inputs!D27+Inputs!D18","v":16602281.427988876},{"$f":"Inputs!E27+Inputs!E18","v":17633221.862753406},{"$f":"Inputs!F27+Inputs!F18","v":19226795.793807335},{"$f":"Inputs!G27+Inputs!G18","v":21824250.507513132}]
[null,"Check",{"$f":"C121-C122","v":0},{"$f":"D121-D122","v":0},0,0,0]
[]
[null,"LED Rate 2A"]
[null,"Unsmoothed Prices x Volumes - LED",{"$f":"SUMPRODUCT(C23:C24,C89:C90)*Inputs!$C$54","v":629732.09770997346},{"$f":"SUMPRODUCT(D23:D24,D89:D90)*Inputs!$C$54","v":2534704.9847287186},{"$f":"SUMPRODUCT(E23:E24,E89:E90)*Inputs!$C$54","v":3265969.3662192174},{"$f":"SUMPRODUCT(F23:F24,F89:F90)*Inputs!$C$54","v":3989409.0377056263},{"$f":"SUMPRODUCT(G23:G24,G89:G90)*Inputs!$C$54","v":4714628.620270744}]
[null,"Revenue requirement - LED",{"$f":"Inputs!C29+Inputs!C19","v":629732.09770997346},{"$f":"Inputs!D29+Inputs!D19","v":2534704.9847287186},{"$f":"Inputs!E29+Inputs!E19","v":3265969.366219217},{"$f":"Inputs!F29+Inputs!F19","v":3989409.0377056259},{"$f":"Inputs!G29+Inputs!G19","v":4714628.6202707449}]
[null,"Check",{"$f":"C126-C127","v":0},{"$f":"D126-D127","v":0},0,0,0]
[]
[null,"Smoothed Prices x Volumes - Conventional",{"$f":"(SUMPRODUCT(C8:C9,C96:C97)+SUMPRODUCT(C15:C16,C102:C103))*Inputs!$C$54","v":15020765.828317812},{"$f":"(SUMPRODUCT(D8:D9,D96:D97)+SUMPRODUCT(D15:D16,D102:D103))*Inputs!$C$54","v":12803931.959508076},{"$f":"(SUMPRODUCT(E8:E9,E96:E97)+SUMPRODUCT(E15:E16,E102:E103))*Inputs!$C$54","v":10023174.830534946},{"$f":"(SUMPRODUCT(F8:F9,F96:F97)+SUMPRODUCT(F15:F16,F102:F103))*Inputs!$C$54","v":6590762.5247279983},{"$f":"(SUMPRODUCT(G8:G9,G96:G97)+SUMPRODUCT(G15:G16,G102:G103))*Inputs!$C$54","v":2407766.5755618513}]
[null,"Smoothed Prices x Volumes - LED Rate 1 and 2",{"$f":"(SUMPRODUCT(C10:C11,C98:C99)+SUMPRODUCT(C17:C18,C104:C105))*Inputs!$C$54","v":11605004.559231279},{"$f":"(SUMPRODUCT(D10:D11,D98:D99)+SUMPRODUCT(D17:D18,D104:D105))*Inputs!$C$54","v":14380995.772535671},{"$f":"(SUMPRODUCT(E10:E11,E98:E99)+SUMPRODUCT(E17:E18,E104:E105))*Inputs!$C$54","v":17661901.217525356},{"$f":"(SUMPRODUCT(F10:F11,F98:F99)+SUMPRODUCT(F17:F18,F104:F105))*Inputs!$C$54","v":21441224.039097745},{"$f":"(SUMPRODUCT(G10:G11,G98:G99)+SUMPRODUCT(G17:G18,G104:G105))*Inputs!$C$54","v":25784304.539228972}]
[null,"Smoothed Prices x Volumes - LED Rate 2A",{"$f":"SUMPRODUCT(C23:C24,C108:C109)*Inputs!$C$54","v":1023023.5141617681},{"$f":"SUMPRODUCT(D23:D24,D108:D109)*Inputs!$C$54","v":1868463.3224119199},{"$f":"SUMPRODUCT(E23:E24,E108:E109)*Inputs!$C$54","v":2866715.9334207149},{"$f":"SUMPRODUCT(F23:F24,F108:F109)*Inputs!$C$54","v":4039519.309330761},{"$f":"SUMPRODUCT(G23:G24,G108:G109)*Inputs!$C$54","v":5410981.0242956867}]
[]
[null,"NPV Revenue requirement - Conventional",{"$f":"(C117/C113)+(D117/D113)+(E117/E113)+(F117/F113)+(G117/G113)","v":40891471.343564719}]
[null,"NPV Smoothed Prices x Volume - Conventional",{"$f":"(C130/C113)+(D130/D113)+(E130/E113)+(F130/F113)+(G130/G113)","v":40891471.343564704}]
[null,"Check",{"$f":"C134-C135","v":0}]
[]
[null,"NPV Revenue requirement - LED Rate 1 and Rate 2",{"$f":"(C122/C113)+(D122/D113)+(E122/E113)+(F122/F113)+(G122/G113)","v":74470112.197027519}]
[null,"NPV Smoothed Prices x Volume - LED Rate 1 and Rate 2",{"$f":"(C131/C113)+(D131/D113)+(E131/E113)+(F131/F113)+(G131/G113)","v":74470112.197027519}]
[null,"Check",{"$f":"C138-C139","v":0}]
[]
[null,"NPV Revenue requirement - LED Rate 2A",{"$f":"(C127/C113)+(D127/D113)+(E127/E113)+(F127/F113)+(G127/G113)","v":12210773.29905341}]
[null,"NPV Smoothed Prices x Volume - LED Rate 2A",{"$f":"(C132/C113)+(D132/D113)+(E132/E113)+(F132/F113)+(G132/G113)","v":12210773.299053412}]
[null,"Check",{"$f":"C142-C143","v":0}]
[]
[null,"P0 Conventional",-7.8841719619623246E-2,"Goal Seek value"]
[null,"P0 LED Rate 1 and 2",-0.2506313357104652,"Goal Seek value"]
[null,"P0 LED Rate 2A",-0.32267330783888554,"Goal Seek value"]
[]
[null,"positive P0 imply real decrease in price constraint"]
[]
[]
[null,null,"Data/What-if Analysis/Goal Seek"]
[null,null,"Goal Seek","P0 Conventional","P0\nLED Rate 1 & 2","P0 Rate 2A"]
[null,null,"Set Cell","C136","C140","C144"]
[null,null,"To Value",0,0,0]
[null,null,"By Changing Cell","C146","C147","C148"]

{"sheet":"Output","index":5,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Public lighting annual prices"]
[]
[null,"Year","2025-26","2026-27","2027-28","2028-29","2029-30"]
[null,"Rate 1 - Ergon Energy Owned & Operated"]
[null,"Major Conventional",{"$f":"Calculations!C96*Inputs!C$55","v":446.5534795482065},{"$f":"Calculations!D96*Inputs!D$55","v":489.39767746106833},{"$f":"Calculations!E96*Inputs!E$55","v":536.35252589814877},{"$f":"Calculations!F96*Inputs!F$55","v":589.42286274591174},{"$f":"Calculations!G96*Inputs!G$55","v":644.20958566569459}]
[null,"Minor Conventional",{"$f":"Calculations!C97*Inputs!C$55","v":266.04936618181227},{"$f":"Calculations!D97*Inputs!D$55","v":291.57524879461249},{"$f":"Calculations!E97*Inputs!E$55","v":319.5501907399472},{"$f":"Calculations!F97*Inputs!F$55","v":351.16864211936013},{"$f":"Calculations!G97*Inputs!G$55","v":383.80968865813929}]
[null,"Major LED",{"$f":"Calculations!C98*Inputs!C$55","v":173.4418519119599},{"$f":"Calculations!D98*Inputs!D$55","v":190.08258447820808},{"$f":"Calculations!E98*Inputs!E$55","v":208.31989813079034},{"$f":"Calculations!F98*Inputs!F$55","v":228.93247406185284},{"$f":"Calculations!G98*Inputs!G$55","v":250.21169618998039}]
[null,"Minor LED",{"$f":"Calculations!C99*Inputs!C$55","v":110.07030617078283},{"$f":"Calculations!D99*Inputs!D$55","v":120.63090909494217},{"$f":"Calculations!E99*Inputs!E$55","v":132.20474018209691},{"$f":"Calculations!F99*Inputs!F$55","v":145.28596895525502},{"$f":"Calculations!G99*Inputs!G$55","v":158.79026719065448}]
[]
[null,"Rate 2 - Gifted & Ergon Energy Operated"]
[null,"Major Conventional",{"$f":"Calculations!C102*Inputs!C$55","v":180.33471682616565},{"$f":"Calculations!D102*Inputs!D$55","v":197.63677951768713},{"$f":"Calculations!E102*Inputs!E$55","v":216.59887405803957},{"$f":"Calculations!F102*Inputs!F$55","v":238.03062771270439},{"$f":"Calculations!G102*Inputs!G$55","v":260.15552118250446}]
[null,"Minor Conventional",{"$f":"Calculations!C103*Inputs!C$55","v":118.12585405270931},{"$f":"Calculations!D103*Inputs!D$55","v":129.45933974132268},{"$f":"Calculations!E103*Inputs!E$55","v":141.88020717954603},{"$f":"Calculations!F103*Inputs!F$55","v":155.91879192274303},{"$f":"Calculations!G103*Inputs!G$55","v":170.41140866866144}]
[null,"Major LED",{"$f":"Calculations!C104*Inputs!C$55","v":126.67295918295044},{"$f":"Calculations!D104*Inputs!D$55","v":138.82648968266369},{"$f":"Calculations!E104*Inputs!E$55","v":152.14608044148974},{"$f":"Calculations!F104*Inputs!F$55","v":167.20043993308653},{"$f":"Calculations!G104*Inputs!G$55","v":182.74168333176453}]
[null,"Minor LED",{"$f":"Calculations!C105*Inputs!C$55","v":84.083951498401092},{"$f":"Calculations!D105*Inputs!D$55","v":92.151315485661385},{"$f":"Calculations!E105*Inputs!E$55","v":100.99269592366117},{"$f":"Calculations!F105*Inputs!F$55","v":110.98559449882363},{"$f":"Calculations!G105*Inputs!G$55","v":121.3016806200293}]
[]
[null,"Rate 2A - Ergon Energy funded Rate 2, Owned & Operated"]
[null,"Major LED",{"$f":"Calculations!C108*Inputs!C$55","v":183.43288020667694},{"$f":"Calculations!D108*Inputs!D$55","v":201.03219357727792},{"$f":"Calculations!E108*Inputs!E$55","v":220.32005826303913},{"$f":"Calculations!F108*Inputs!F$55","v":242.12001098398264},{"$f":"Calculations!G108*Inputs!G$55","v":264.62501171184289}]
[null,"Minor LED",{"$f":"Calculations!C109*Inputs!C$55","v":116.41084930519702},{"$f":"Calculations!D109*Inputs!D$55","v":127.5797903061321},{"$f":"Calculations!E109*Inputs!E$55","v":139.82032595504816},{"$f":"Calculations!F109*Inputs!F$55","v":153.65509215508192},{"$f":"Calculations!G109*Inputs!G$55","v":167.93729851520931}]
[]
[null,"Public lighting daily prices"]
[]
[null,"Year","2025-26","2026-27","2027-28","2028-29","2029-30"]
[null,"Rate 1 - Eron Energy Owned & Operated"]
[null,"Major Conventional",{"$f":"Calculations!C96","v":1.2234341905430315},{"$f":"Calculations!D96","v":1.3408155546878584},{"$f":"Calculations!E96","v":1.4694589750634213},{"$f":"Calculations!F96","v":1.6104449801800869},{"$f":"Calculations!G96","v":1.7649577689471083}]
[null,"Minor Conventional",{"$f":"Calculations!C97","v":0.72890237310085548},{"$f":"Calculations!D97","v":0.79883629806743151},{"$f":"Calculations!E97","v":0.87547997462999239},{"$f":"Calculations!F97","v":0.95947716426054686},{"$f":"Calculations!G97","v":1.0515333935839433}]
[null,"Major LED",{"$f":"Calculations!C98","v":0.47518315592317784},{"$f":"Calculations!D98","v":0.52077420404988517},{"$f":"Calculations!E98","v":0.57073944693367218},{"$f":"Calculations!F98","v":0.62549856301052686},{"$f":"Calculations!G98","v":0.68551149641090514}]
[null,"Minor LED",{"$f":"Calculations!C99","v":0.301562482659679},{"$f":"Calculations!D99","v":0.33049564135600595},{"$f":"Calculations!E99","v":0.36220476762218334},{"$f":"Calculations!F99","v":0.39695619933129783},{"$f":"Calculations!G99","v":0.43504182791960128}]
[]
[null,"Rate 2 - Gifted & Ergon Energy Operated"]
[null,"Major Conventional",{"$f":"Calculations!C102","v":0.49406771733196064},{"$f":"Calculations!D102","v":0.54147062881558117},{"$f":"Calculations!E102","v":0.59342157276175223},{"$f":"Calculations!F102","v":0.65035690631886445},{"$f":"Calculations!G102","v":0.71275485255480675}]
[null,"Minor Conventional",{"$f":"Calculations!C103","v":0.32363247685673785},{"$f":"Calculations!D103","v":0.35468312257896628},{"$f":"Calculations!E103","v":0.38871289638231787},{"$f":"Calculations!F103","v":0.42600762820421589},{"$f":"Calculations!G103","v":0.46688057169496283}]
[null,"Major LED",{"$f":"Calculations!C104","v":0.34704920324096011},{"$f":"Calculations!D104","v":0.38034654707579091},{"$f":"Calculations!E104","v":0.41683857655202666},{"$f":"Calculations!F104","v":0.45683180309586485},{"$f":"Calculations!G104","v":0.50066214611442339}]
[null,"Minor LED",{"$f":"Calculations!C105","v":0.23036699040657835},{"$f":"Calculations!D105","v":0.25246935749496269},{"$f":"Calculations!E105","v":0.2766923175990717},{"$f":"Calculations!F105","v":0.30323932923175856},{"$f":"Calculations!G105","v":0.3323333715617241}]
[]
[null,"Rate 2A - Ergon Energy funded Rate 2, Owned & Operated"]
[null,"Major LED",{"$f":"Calculations!C108","v":0.50255583618267652},{"$f":"Calculations!D108","v":0.55077313308843268},{"$f":"Calculations!E108","v":0.60361659798092915},{"$f":"Calculations!F108","v":0.6615300846556903},{"$f":"Calculations!G108","v":0.72500003208724084}]
[null,"Minor LED",{"$f":"Calculations!C109","v":0.31893383371286854},{"$f":"Calculations!D109","v":0.3495336720715948},{"$f":"Calculations!E109","v":0.38306938617821418},{"$f":"Calculations!F109","v":0.419822656161426},{"$f":"Calculations!G109","v":0.46010218771290223}]

{"sheet":"Import Qty","index":6,"n_rows":52,"n_cols":9,"rows_kept":52,"cut":false,"hidden":false,"merged":[[5,4,5,8],[41,4,41,8],[23,4,23,8]]}
[null,"Ergon Energy Forecast Quantities"]
[null,"Output to Public Lighting Pricing Model - Estimated Count by type"]
[]
[]
[]
[null,null,null,null,"Rate 1"]
[null,"Public Lighting Quantity","Rate","Count","2025-26","2026-27","2027-28","2028-29","2029-30"]
[null,"Major Conventional ",1,"Opening",{"$f":"'[1]Import Qty'!E8","v":21456},{"$f":"'[1]Import Qty'!F8","v":17165},{"$f":"'[1]Import Qty'!G8","v":12874},{"$f":"'[1]Import Qty'!H8","v":8582},{"$f":"'[1]Import Qty'!I8","v":4291}]
[null,"Minor Conventional",1,"Opening",{"$f":"'[1]Import Qty'!E9","v":13903},{"$f":"'[1]Import Qty'!F9","v":11122},{"$f":"'[1]Import Qty'!G9","v":8342},{"$f":"'[1]Import Qty'!H9","v":5561},{"$f":"'[1]Import Qty'!I9","v":2781}]
[null,"Major LED",1,"Opening",{"$f":"'[1]Import Qty'!E10","v":8073.2},{"$f":"'[1]Import Qty'!F10","v":11949},{"$f":"'[1]Import Qty'!G10","v":16332},{"$f":"'[1]Import Qty'!H10","v":20718},{"$f":"'[1]Import Qty'!I10","v":25105}]
[null,"Minor LED",1,"Opening",{"$f":"'[1]Import Qty'!E11","v":61189.4},{"$f":"'[1]Import Qty'!F11","v":62739},{"$f":"'[1]Import Qty'!G11","v":65807},{"$f":"'[1]Import Qty'!H11","v":68880},{"$f":"'[1]Import Qty'!I11","v":71956}]
[null,"Total",1,"Opening",{"$f":"SUM(E8:E11)","v":104621.6},{"$f":"SUM(F8:F11)","v":102975},103355,103741,104133]
[null,"Major Conventional ",1,"Closing",{"$f":"'[1]Import Qty'!E13","v":17165},{"$f":"'[1]Import Qty'!F13","v":12874},{"$f":"'[1]Import Qty'!G13","v":8582},{"$f":"'[1]Import Qty'!H13","v":4291},{"$f":"'[1]Import Qty'!I13","v":0}]
[null,"Minor Conventional",1,"Closing",{"$f":"'[1]Import Qty'!E14","v":11122},{"$f":"'[1]Import Qty'!F14","v":8342},{"$f":"'[1]Import Qty'!G14","v":5561},{"$f":"'[1]Import Qty'!H14","v":2781},{"$f":"'[1]Import Qty'!I14","v":0}]
[null,"Major LED",1,"Closing",{"$f":"'[1]Import Qty'!E15","v":11949},{"$f":"'[1]Import Qty'!F15","v":16332},{"$f":"'[1]Import Qty'!G15","v":20718},{"$f":"'[1]Import Qty'!H15","v":25105},{"$f":"'[1]Import Qty'!I15","v":29494.000000000004}]
[null,"Minor LED",1,"Closing",{"$f":"'[1]Import Qty'!E16","v":62739},{"$f":"'[1]Import Qty'!F16","v":65807},{"$f":"'[1]Import Qty'!G16","v":68880},{"$f":"'[1]Import Qty'!H16","v":71956},{"$f":"'[1]Import Qty'!I16","v":75037}]
[null,"Total",1,"Closing",{"$f":"SUM(E13:E16)","v":102975},{"$f":"SUM(F13:F16)","v":103355},103741,104133,104531]
[null,"Major Conventional ",1,"Average",{"$f":"(E8+E13)/2","v":19310.5},15019.5,10728,6436.5,2145.5]
[null,"Minor Conventional",1,"Average",12512.5,9732,6951.5,4171,1390.5]
[null,"Major LED",1,"Average",10011.1,14140.5,18525,22911.5,27299.5]
[null,"Minor LED",1,"Average",61964.2,64273,67343.5,70418,73496.5]
[null,"Total",1,"Average",{"$f":"SUM(E18:E21)","v":103798.29999999999},{"$f":"SUM(F18:F21)","v":103165},103548,103937,{"$f":"SUM(I18:I21)","v":104332}]
[]
[null,null,null,null,"Rate 2 "]
[null,"Public Lighting Quantity","Rate","Count","2025-26","2026-27","2027-28","2028-29","2029-30"]
[null,"Major Conventional ",2,"Opening",{"$f":"'[1]Import Qty'!E26","v":10244},{"$f":"'[1]Import Qty'!F26","v":8195},{"$f":"'[1]Import Qty'!G26","v":6147},{"$f":"'[1]Import Qty'!H26","v":4098},{"$f":"'[1]Import Qty'!I26","v":2049}]
[null,"Minor Conventional",2,"Opening",{"$f":"'[1]Import Qty'!E27","v":13129},{"$f":"'[1]Import Qty'!F27","v":10503},{"$f":"'[1]Import Qty'!G27","v":7878},{"$f":"'[1]Import Qty'!H27","v":5252},{"$f":"'[1]Import Qty'!I27","v":2626}]
[null,"Major LED",2,"Opening",{"$f":"'[1]Import Qty'!E28","v":4644},{"$f":"'[1]Import Qty'!F28","v":6700},{"$f":"'[1]Import Qty'!G28","v":8755},{"$f":"'[1]Import Qty'!H28","v":10811},{"$f":"'[1]Import Qty'!I28","v":12867}]
[null,"Minor LED",2,"Opening",{"$f":"'[1]Import Qty'!E29","v":25546},{"$f":"'[1]Import Qty'!F29","v":29680},{"$f":"'[1]Import Qty'!G29","v":32331},{"$f":"'[1]Import Qty'!H29","v":34983},{"$f":"'[1]Import Qty'!I29","v":37636}]
[null,"Total",2,"Opening",{"$f":"SUM(E26:E29)","v":53563},{"$f":"SUM(F26:F29)","v":55078},55111,55144,55178]
[null,"Major Conventional ",2,"Closing",{"$f":"'[1]Import Qty'!E31","v":8195},{"$f":"'[1]Import Qty'!F31","v":6147},{"$f":"'[1]Import Qty'!G31","v":4098},{"$f":"'[1]Import Qty'!H31","v":2049},{"$f":"'[1]Import Qty'!I31","v":0}]
[null,"Minor Conventional",2,"Closing",{"$f":"'[1]Import Qty'!E32","v":10503},{"$f":"'[1]Import Qty'!F32","v":7878},{"$f":"'[1]Import Qty'!G32","v":5252},{"$f":"'[1]Import Qty'!H32","v":2626},{"$f":"'[1]Import Qty'!I32","v":0}]
[null,"Major LED",2,"Closing",{"$f":"'[1]Import Qty'!E33","v":6700},{"$f":"'[1]Import Qty'!F33","v":8755},{"$f":"'[1]Import Qty'!G33","v":10811},{"$f":"'[1]Import Qty'!H33","v":12867},{"$f":"'[1]Import Qty'!I33","v":14923.000000000004}]
[null,"Minor LED",2,"Closing",{"$f":"'[1]Import Qty'!E34","v":29680},{"$f":"'[1]Import Qty'!F34","v":32331},{"$f":"'[1]Import Qty'!G34","v":34983},{"$f":"'[1]Import Qty'!H34","v":37636},{"$f":"'[1]Import Qty'!I34","v":40290}]
[null,"Total",2,"Closing",{"$f":"SUM(E31:E34)","v":55078},{"$f":"SUM(F31:F34)","v":55111},55144,55178,55213]
[null,"Major Conventional ",2,"Average",{"$f":"(E26+E31)/2","v":9219.5},7171,5122.5,3073.5,1024.5]
[null,"Minor Conventional",2,"Average",{"$f":"(E27+E32)/2","v":11816},9190.5,6565,3939,1313]
[null,"Major LED",2,"Average",{"$f":"(E28+E33)/2","v":5672},7727.5,9783,11839,13895.000000000002]
[null,"Minor LED",2,"Average",{"$f":"(E29+E34)/2","v":27613},31005.5,33657,36309.5,38963]
[null,"Total",2,"Average",{"$f":"SUM(E36:E39)","v":54320.5},{"$f":"SUM(F36:F39)","v":55094.5},55127.5,55161,55195.5]
[]
[null,null,null,null,"Rate 2A "]
[null,"Public Lighting Quantity","Rate","Count","2025-26","2026-27","2027-28","2028-29","2029-30"]
[null,"Major LED","2A","Opening",{"$f":"'[1]Import Qty'!E44","v":2049},{"$f":"'[1]Import Qty'!F44","v":4098},{"$f":"'[1]Import Qty'!G44","v":6146},{"$f":"'[1]Import Qty'!H44","v":8195},{"$f":"'[1]Import Qty'!I44","v":10244}]
[null,"Minor LED","2A","Opening",{"$f":"'[1]Import Qty'!E45","v":2626},{"$f":"'[1]Import Qty'!F45","v":5252},{"$f":"'[1]Import Qty'!G45","v":7877},{"$f":"'[1]Import Qty'!H45","v":10503},{"$f":"'[1]Import Qty'!I45","v":13129}]
[null,"Total","2A","Opening",{"$f":"SUM(E44:E45)","v":4675},{"$f":"SUM(F44:F45)","v":9350},{"$f":"SUM(G44:G45)","v":14023},{"$f":"SUM(H44:H45)","v":18698},{"$f":"SUM(I44:I45)","v":23373}]
[null,"Major LED","2A","Closing",{"$f":"'[1]Import Qty'!E47","v":4098},{"$f":"'[1]Import Qty'!F47","v":6146},{"$f":"'[1]Import Qty'!G47","v":8195},{"$f":"'[1]Import Qty'!H47","v":10244},{"$f":"'[1]Import Qty'!I47","v":12293.000000000004}]
[null,"Minor LED","2A","Closing",{"$f":"'[1]Import Qty'!E48","v":5252},{"$f":"'[1]Import Qty'!F48","v":7877},{"$f":"'[1]Import Qty'!G48","v":10503},{"$f":"'[1]Import Qty'!H48","v":13129},{"$f":"'[1]Import Qty'!I48","v":15755}]
[null,"Total","2A","Closing",{"$f":"SUM(E47:E48)","v":9350},{"$f":"SUM(F47:F48)","v":14023},{"$f":"SUM(G47:G48)","v":18698},{"$f":"SUM(H47:H48)","v":23373},{"$f":"SUM(I47:I48)","v":28048.000000000004}]
[null,"Major LED","2A","Average",{"$f":"(E44+E47)/2","v":3073.5},5122,7170.5,9219.5,11268.500000000002]
[null,"Minor LED","2A","Average",3939,6564.5,9190,11816,14442]
[null,"Total","2A","Average",{"$f":"SUM(E50:E51)","v":7012.5},{"$f":"SUM(F50:F51)","v":11686.5},{"$f":"SUM(G50:G51)","v":16360.5},{"$f":"SUM(H50:H51)","v":21035.5},{"$f":"SUM(I50:I51)","v":25710.5}]