{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Draft Decision changes","RRP changes","Cover page","Version Control","Intro",">>General inputs","Cost Escalations","Ratios & Assumptions","Overheads",">>Volumes","ERG - Yearly volume scenarios",">>Unit Rates","ERG Unit Rates",">>Forecast capex","ERG - Forecast capex scenarios","ERG - Gross Capex ",">>Forecast opex","ERG - Opex BST","ERG - Forecast opex"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":25,"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":"Draft Decision changes","index":0,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Cells","Decription of changes"]
[" 'Cost Escalations' - row 3 ","Updated actual CPI in cells E3:F3 and forecast CPI in cell G3."]
[" 'Cost Escalations' - row 29","Substituted with our labour escalators consistent with ANS."]

{"sheet":"RRP changes","index":1,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Cells","Decription of changes"]
[" 'Cost Escalations' - row 29","Substituted with our labour escalators consistent with ANS."]
["ERG - Yearly volume scenario' - columns H, I, & J","Updated for actual (2022-23 & 2023-24) and revised forecast volumes"]

{"sheet":"Cover page","index":2,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[[1,0,1,5],[2,0,2,5]]}
[]
["Ergon Energy Public Lighting Capex and Opex Forecasting Model"]
["2025-30"]

{"sheet":"Version Control","index":3,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["RDP2025 Project: Public Lighting Expenditure Analysis Model"]
[]
[]
[null,"Date","Version","Description of any updates made"]
[null,"2024-01-31","V1","Version submitted to the AER"]
[null,"2024-08-21","V2","AER - updated inflation figures and labour escalators"]
[null,"2024-11-26","V3","ERG - updated actual volumes (2022-23 & 2023-24) and revised forecast"]

{"sheet":"Intro","index":4,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Model developer ","Energex & Ergon Energy Network"]
[]
[]
[]
["Purpose","To provide capex and opex scenarios based on the 100% LED deployment during 2025-30 regulatory period.  "]
[]
["Colour chart","Data","Cells containing hard coded data"]
[null,null,"Cell containing formula"]
[null,null,"Cells to remain empty (non-applicable input/output)"]
[null,"Assumptions","Cells containing assumptions intended to be manipulated by model users"]
[null,"Text","Important notes providing details"]
[null,null,"Cell highlighting particular attention"]
[null,"Header 1","Fist header"]
[null,"Header 2","Second header"]
[null,"Header 3","Third hearder"]

{"sheet":">>General inputs","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Cost Escalations","index":6,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,"2019-20","2020-21","2021-22","2022-23","2023-24","2024-25"]
[null,"2020-06-01","2021-06-01","2022-06-01","2023-06-01","2024-06-01","2025-06-01"]
["Inflation",-3.4843205574912606E-3,3.8461538461538325E-2,6.1447811447811418E-2,0.06,3.7999999999999999E-2,2.8000000000000001E-2,null,null,"Sources used",null,"https://www.rba.gov.au/publications/smp/2024/aug/"]
[null,null,null,null,null,null,null,null,null,null,null,"https://www.abs.gov.au/statistics/economy/price-indexes-and-inflation/consumer-price-index-australia/jun-quarter-2024"]
["Real to Real"]
[null,"2020-06-01","2021-06-01","2022-06-01","2023-06-01","2024-06-01","2025-06-01"]
["2020-06-01",{"$f":"IF(AND($A7>B$6,ISNONTEXT($A7)),C7/(1+C$3),IF(AND($A7=B$6,B$6=B$2),1,IF(AND($A7<B$6,B$6=B$2),#REF!*(1+B$3),0)))","v":1},{"$f":"IF(AND($A7>C$6,ISNONTEXT($A7)),D7/(1+D$3),IF(AND($A7=C$6,C$6=C$2),1,IF(AND($A7<C$6,C$6=C$2),B7*(1+C$3),0)))","v":1.0384615384615383},1.1022727272727271,1.1684090909090907,1.2128086363636361,{"$f":"IF(AND($A7>G$6,ISNONTEXT($A7)),#REF!/(1+#REF!),IF(AND($A7=G$6,G$6=G$2),1,IF(AND($A7<G$6,G$6=G$2),F7*(1+G$3),0)))","v":1.246767278181818}]
["2021-06-01",{"$f":"IF(AND($A8>B$6,ISNONTEXT($A8)),C8/(1+C$3),IF(AND($A8=B$6,B$6=B$2),1,IF(AND($A8<B$6,B$6=B$2),#REF!*(1+B$3),0)))","v":0.96296296296296313},1,1.0614478114478114,1.1251346801346802,1.1678897979797982,{"$f":"IF(AND($A8>G$6,ISNONTEXT($A8)),#REF!/(1+#REF!),IF(AND($A8=G$6,G$6=G$2),1,IF(AND($A8<G$6,G$6=G$2),F8*(1+G$3),0)))","v":1.2005907123232327}]
["2022-06-01",{"$f":"IF(AND($A9>B$6,ISNONTEXT($A9)),C9/(1+C$3),IF(AND($A9=B$6,B$6=B$2),1,IF(AND($A9<B$6,B$6=B$2),#REF!*(1+B$3),0)))","v":0.90721649484536093},0.94210943695479776,1,1.06,{"$f":"IF(AND($A9>F$6,ISNONTEXT($A9)),G9/(1+G$3),IF(AND($A9=F$6,F$6=F$2),1,IF(AND($A9<F$6,F$6=F$2),E9*(1+F$3),0)))","v":1.1002800000000001},{"$f":"IF(AND($A9>G$6,ISNONTEXT($A9)),#REF!/(1+#REF!),IF(AND($A9=G$6,G$6=G$2),1,IF(AND($A9<G$6,G$6=G$2),F9*(1+G$3),0)))","v":1.1310878400000002}]
["2023-06-01",{"$f":"IF(AND($A10>B$6,ISNONTEXT($A10)),C10/(1+C$3),IF(AND($A10=B$6,B$6=B$2),1,IF(AND($A10<B$6,B$6=B$2),#REF!*(1+B$3),0)))","v":0.85586461777864231},0.88878248769320534,0.94339622641509424,1,1.038,{"$f":"IF(AND($A10>G$6,ISNONTEXT($A10)),#REF!/(1+#REF!),IF(AND($A10=G$6,G$6=G$2),1,IF(AND($A10<G$6,G$6=G$2),F10*(1+G$3),0)))","v":1.067064}]
["2024-06-01",{"$f":"IF(AND($A11>B$6,ISNONTEXT($A11)),C11/(1+C$3),IF(AND($A11=B$6,B$6=B$2),1,IF(AND($A11<B$6,B$6=B$2),#REF!*(1+B$3),0)))","v":0.82453238706998289},0.8562451711880591,0.908859563020322,0.96339113680154143,1,{"$f":"IF(AND($A11>G$6,ISNONTEXT($A11)),#REF!/(1+#REF!),IF(AND($A11=G$6,G$6=G$2),1,IF(AND($A11<G$6,G$6=G$2),F11*(1+G$3),0)))","v":1.028}]
["2025-06-01",{"$f":"IF(AND($A12>B$6,ISNONTEXT($A12)),C12/(1+C$3),IF(AND($A12=B$6,B$6=B$2),1,IF(AND($A12<B$6,B$6=B$2),#REF!*(1+B$3),0)))","v":0.80207430648831024},0.83292331827632204,0.88410463328825095,0.93715091128554606,0.97276264591439687,{"$f":"IF(AND($A12>G$6,ISNONTEXT($A12)),#REF!/(1+#REF!),IF(AND($A12=G$6,G$6=G$2),1,IF(AND($A12<G$6,G$6=G$2),F12*(1+G$3),0)))","v":1}]
[]
["Nominal to Real"]
[null,"2020-06-01","2021-06-01","2022-06-01","2023-06-01","2024-06-01","2025-06-01"]
["2020-06-01",{"$f":"IF(AND(B$15=B$2,ISNONTEXT($A16)),1/B7*(1+B$3)^0.5,0)","v":0.99825631951042948},{"$f":"IF(AND(C$15=C$2,ISNONTEXT($A16)),1/C7*(1+C$3)^0.5,0)","v":0.98130676292531638},{"$f":"IF(AND(D$15=D$2,ISNONTEXT($A16)),1/D7*(1+D$3)^0.5,0)","v":0.93467421272075479},0.88116655554061096,0.84005243664057239,0.81322582505495222]
["2021-06-01",{"$f":"IF(AND(B$15=B$2,ISNONTEXT($A17)),1/B8*(1+B$3)^0.5,0)","v":1.0366507933377536},1.019049330730136,0.970623220902322,0.91505757690755729,0.87236214574213256,0.84450374140321927]
["2022-06-01",1.100350715823996,1.0816676818608599,1.0302658935671953,0.971285862357264,0.92596689038790336,0.89639664807193575]
["2023-06-01",1.1663717587734359,1.1465677427725116,1.092081847181227,1.0295630140987,0.98152490381117763,0.95018044695625203]
["2024-06-01",1.2106938856068263,1.1901373169978671,1.1335809573741138,1.0686864086344505,1.0188228501560024,0.98628730394058961]
["2025-06-01",1.2445933144038177,1.2234611618738074,1.165321224180589,1.0986096280762152,1.0473498899603704,1.0139033484509261]
[]
["Real escalation"]
["Contractor","2025-26","2026-27","2027-28","2028-29","2029-30"]
["Escalation - Year on Year",1.0500000000000001E-2,7.1000000000000004E-3,6.1000000000000004E-3,9.1999999999999998E-3,1.09E-2,"Source: BISOE report"]
["Escalation - Cumulative",{"$f":"PRODUCT(1+$B25:B25)-1","v":1.0499999999999954E-2},{"$f":"PRODUCT(1+$B25:C25)-1","v":1.7674549999999956E-2},{"$f":"PRODUCT(1+$B25:D25)-1","v":2.3882364754999941E-2},{"$f":"PRODUCT(1+$B25:E25)-1","v":3.3302082510745956E-2},{"$f":"PRODUCT(1+$B25:F25)-1","v":4.4565075210112992E-2}]
[]
["Labour","2025-26","2026-27","2027-28","2028-29","2029-30"]
["Escalation - Year on Year",1.1250515567042995E-2,9.2135243940020661E-3,9.1083556288052894E-3,1.0777935799648537E-2,1.2340188084018006E-2,"Source: BISOE report",null,null,"Source used",null,"Average of BISOE and Deloitte X factors (see ANS model)"]
["Escalation - Cumulative",{"$f":"PRODUCT(1+$B29:B29)-1","v":1.125051556704304E-2},{"$f":"PRODUCT(1+$B29:C29)-1","v":2.0567696860667173E-2},{"$f":"PRODUCT(1+$B29:D29)-1","v":2.9863390386944744E-2},{"$f":"PRODUCT(1+$B29:E29)-1","v":4.096319189094344E-2},{"$f":"PRODUCT(1+$B29:F29)-1","v":5.3808873467417362E-2}]

{"sheet":"Ratios & Assumptions","index":7,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,2,1,3]]}
["Table 1 - ERG ratios between major and minor roads"]
[null,null,"2025-26"]
["DNSP","Road type","Volume","Ratio"]
["Ergon","Major",{"$f":"SUMIF('ERG - Yearly volume scenarios'!$C$5:$C$12,'Ratios & Assumptions'!$B4,'ERG - Yearly volume scenarios'!$G$5:$G$12)","v":42421},{"$f":"C4/$C$6","v":0.28251661627395874}]
["Ergon","Minor",{"$f":"SUMIF('ERG - Yearly volume scenarios'!$C$5:$C$12,'Ratios & Assumptions'!$B5,'ERG - Yearly volume scenarios'!$G$5:$G$12)","v":107733},{"$f":"C5/$C$6","v":0.71748338372604126}]
["Ergon","All",{"$f":"SUM(C4:C5)","v":150154},{"$f":"SUM(D4:D5)","v":1}]
["Notes:"]
["Allocation based on actual 2021-22 volumes"]
["Used to allocate expenditure between major and minor road types where the breakdown is not available"]
[]
["Table 2 - ERG estimated annual growth rates"]
["DNSP","Road","Rate","Rate"]
["Ergon","All ",1,2.5000000000000001E-2]
["Ergon","All ",2,1.4999999999999999E-2]
["Note:"]
["Different growth rates for Rate 1 and Rate 2"]
[]
[]
["Table 3 - Estimated proportion of contributed Rate 2 LEDs"]
["DNSP","Road","Rate"]
["Ergon","Major ",6.0844986611127638E-2]
["Ergon","Minor",4.0785881160807273E-2]
["Note:"]
["Based on EGX's figures due to data availability issues for Ergon"]

{"sheet":"Overheads","index":8,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Table 1 - ERG Labour Oncosts"]
["DNSP","Cost type","Cost recovery","FY2023"]
["Ergon","Labour Oncosts","Labour only",0]
["Ergon","All","All",{"$f":"SUM(D3)","v":0}]
[]
["Table 2 - ERG Material Oncosts"]
["DNSP","Cost type","Cost recovery","FY2023"]
["Ergon","Material Oncosts","Material only",7.9587700999130317E-2]
["Ergon","All","All",{"$f":"SUM(D8)","v":7.9587700999130317E-2}]
[]
["Table 3 - ERG Fleet Oncosts"]
["DNSP","Cost type","Cost recovery","FY2023"]
["Ergon","Fleet Oncost Indirects","Labour only",0.12669576075036793]
["Ergon","Fleet Oncost Depreciation","Labour only",8.4944584136218471E-2]
["Ergon","All","All",{"$f":"SUM(D13:D14)","v":0.2116403448865864}]
[]
["Table 4 - ERG Network and Non-network Overheads "]
["DNSP","Cost type","Cost recovery","FY2023"]
["Ergon","Network Overhead","All Direct costs + Oncosts",0.11544351205342462]
["Ergon","Non Network Overhead","Labour only",0.35402046922299729]
["Ergon","All","All",{"$f":"SUM(D19:D20)","v":0.46946398127642192}]
[]
["Table 5 - ERG Other Allocations"]
["DNSP","Cost type","Cost recovery","FY2023"]
["Ergon","Non Network Depreciation","Labour only",0.13781941577751597]
["Ergon","Corporate Overhead","All Direct Costs + Oncosts",5.3788331594094435E-2]
["Ergon","Market","All Direct Costs + Oncosts",2.8305490186369222E-3]
["Ergon","Customer Ops","All Direct Costs + Oncosts",2.8584287689180227E-2]
["Ergon","All","All",{"$f":"SUM(D25:D28)","v":0.22302258407942754}]

{"sheet":">>Volumes","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ERG - Yearly volume scenarios","index":10,"n_rows":110,"n_cols":16,"rows_kept":110,"cut":false,"hidden":false,"merged":[[97,0,97,3],[100,0,100,3],[70,10,70,14],[71,10,71,14],[0,10,0,14],[1,5,1,9],[1,10,1,14],[93,10,93,14],[94,5,94,9],[94,10,94,14],[23,5,23,9],[36,10,36,14],[37,10,37,14],[59,10,59,14],[60,10,60,14],[49,10,49,14],[50,10,50,14],[22,10,22,14],[23,10,23,14]]}
["Table 1 - ERG Total public lighting asset base by tariffs to be converted from CONV to LED- yearly data as at 30 June",null,null,null,null,null,null,null,null,null,"100%  LED deployment by 2030"]
["1.a - Number of public lights for LED conversion",null,null,null,"Previous period","Current period",null,null,null,null,"Forthcoming period"]
[null,null,null,null,"Actual","Actual","Actual","Actual","Actuals","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast"]
["DNSP","Rate","Road type","Light type","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30"]
["Ergon Energy",1,"Major","CONV",27931,27894,26945,26195,25747,21456,17165,12874,8582,4291,0]
["Ergon Energy",1,"Major","LED",346,754,1837,2626,3277,7568,11859,16150,20442,24733,29024.000000000004]
["Ergon Energy",1,"Minor","CONV",68751,68404,53974,30065,16683,13903,11122,8342,5561,2781,0,"Removes the Nostalgia  as these are to be converted to LED (see Table 3 below)"]
["Ergon Energy",1,"Minor","LED",1287,1714,17369,41990,56894,59674,62455,65235,68016,70796,73577]
["Ergon Energy",2,"Major","CONV",12886,12883,12715,12494,12293,10244,8195,6147,4098,2049,0]
["Ergon Energy","2A","Major","LED",255,558,924,1483,2217,4266,6315,8363,10412,12461,14510.000000000004]
["Ergon Energy",2,"Minor","CONV",34331,34480,29753,21261,15755,13129,10503,7878,5252,2626,0,"Removes the Nostalgia  as these are to be converted to LED (see Table 3 below)"]
["Ergon Energy","2A","Minor","LED",686,1302,6637,16154,21842,24468,27094,29719,32345,34971,37597]
["Ergon Energy","All","All","CONV",{"$f":"E5+E7+E9+E11","v":143899},143661,123387,90015,70478,58732,46985,35241,23493,11747,0]
["Ergon Energy","All","All","LED",{"$f":"E6+E8+E10+E12","v":2574},{"$f":"F6+F8+F10+F12","v":4328},26767,62253,84230,95976,107723,119467,131215,142961,154708]
["Ergon Energy","All","All","All",{"$f":"E13+E14","v":146473},{"$f":"F13+F14","v":147989},150154,152268,154708,154708,{"$f":"SUM(K5:K12)","v":154708},{"$f":"SUM(L5:L12)","v":154708},{"$f":"SUM(M5:M12)","v":154708},{"$f":"SUM(N5:N12)","v":154708},{"$f":"SUM(O5:O12)","v":154708}]
["Ergon Energy","All","All","LED",{"$f":"E14/E15","v":1.7573204617915929E-2},{"$f":"F14/F15","v":2.9245416889093108E-2},0.17826364932003144,0.40883836393726852,0.54444501900354214,0.62036869457300203,0.69629883393231118,0.77220958192207256,0.84814618507123096,0.92406986064069085,{"$f":"O14/O15","v":1}]
["Note:"]
["CONV Minor volumes exclude Nostalgia volumes which are being converted to LED (see volumes in Table 4)"]
["No growth assumed for CONV to LED conversion program as the conversions are intended for the existing fleet of assets"]
["All Rate 1 CONV lights converted to LED will be assigned to Rate 1 LED"]
["All Rate 2 CONV lights converted to LED and funded by ERG, will be assigned to Rate 2A"]
[]
[null,null,null,null,null,null,null,null,null,null,"100%  LED deployment by 2030"]
[null,null,null,null,"Previous period","Current period",null,null,null,null,"Forthcoming period"]
["Table 1.b - ERG LED luminaire replacement volume/year",null,null,null,"Actual","Actual","Actual","Actual","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast"]
["DNSP","Rate","Road type","Light type","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30"]
["Ergon Energy",1,"Major","LED",null,{"$f":"F6-E6","v":408},1083,789,651,4291,4291,4291,4292,4291,4291.0000000000036]
["Ergon Energy",1,"Minor","LED",null,{"$f":"F8-E8","v":427},15655,24621,14904,2780,2781,2780,2781,2780,2781]
["Ergon Energy","2A","Major","LED",null,{"$f":"F10-E10","v":303},366,559,734,2049,2049,2048,2049,2049,2049.0000000000036]
["Ergon Energy","2A","Minor","LED",null,{"$f":"F12-E12","v":616},5335,9517,5688,2626,2626,2625,2626,2626,2626]
["Ergon Energy","All","All","LED",null,{"$f":"SUM(F27:F30)","v":1754},22439,35486,21977,11746,11747,11744,11748,11746,11747.000000000007]
[null,null,null,"Total LED volume",null,null,null,null,null,null,{"$f":"J14+K31","v":107723},{"$f":"K14+L31","v":119467},{"$f":"L14+M31","v":131215},{"$f":"M14+N31","v":142961},{"$f":"N14+O31","v":154708}]
[null,null,null,null,null,null,null,null,null,"Check",{"$f":"K32-K14","v":0},{"$f":"L32-L14","v":0},{"$f":"M32-M14","v":0},{"$f":"N32-N14","v":0},{"$f":"O32-O14","v":0}]
[null,null,"Proportions","LED","Rate 1",{"$f":"SUM(F27:F28)/SUM(F27:F30)","v":0.47605473204104903},0.7459334194928473,0.71605703657780528,0.70778541202165901,0.60199216754639873,{"$f":"SUM(K27:K28)/SUM(K27:K30)","v":0.60202604920405212},0.60209468664850141,0.60205992509363293,0.60199216754639873,0.60202604920405201]
[null,null,null,null,"Rate2A",{"$f":"1-F34","v":0.52394526795895091},0.2540665805071527,0.28394296342219472,0.29221458797834099,0.39800783245360127,{"$f":"1-K34","v":0.39797395079594788},0.39790531335149859,{"$f":"1-M34","v":0.39794007490636707},{"$f":"1-N34","v":0.39800783245360127},{"$f":"1-O34","v":0.39797395079594799}]
[]
[null,null,null,null,null,null,null,null,null,null,"100%  LED deployment by 2030"]
[null,null,null,null,null,null,null,null,null,null,"Forthcoming period"]
["Table 1.c - ERG smoothed LED luminaire replacement volume/year",null,null,null,null,null,null,null,null,null,"Forecast","Forecast","Forecast","Forecast","Forecast"]
["DNSP","Rate","Road type","Light type",null,null,null,null,null,null,"2025-26","2026-27","2027-28","2028-29","2029-30"]
["Ergon Energy",1,"Major","LED",null,null,null,null,null,null,{"$f":"ROUND(SUM($K27:$O27)/5,0)","v":4291},4291,4291,4291,4291]
["Ergon Energy",1,"Minor","LED",null,null,null,null,null,null,2781,2781,2781,2781,2781]
["Ergon Energy","2A","Major","LED",null,null,null,null,null,null,2049,2049,2049,2049,2049]
["Ergon Energy","2A","Minor","LED",null,null,null,null,null,null,2626,2626,2626,2626,2626]
["Ergon Energy","All","All","LED",null,null,null,null,null,null,{"$f":"SUM(K41:K44)","v":11747},{"$f":"SUM(L41:L44)","v":11747},{"$f":"SUM(M41:M44)","v":11747},{"$f":"SUM(N41:N44)","v":11747},{"$f":"SUM(O41:O44)","v":11747}]
["Note:"]
["This table is based on Table 2 and smoothes the number of lights being converted a consistent yearly deployment"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"100%  LED deployment by 2030"]
[null,null,null,null,null,null,null,null,null,null,"Forthcoming period"]
["2 - New intallations",null,null,null,"Actual ","Actual ","Actual ","Actual ","Actual ","Forecast ","Forecast","Forecast","Forecast","Forecast","Forecast"]
["DNSP","Rate","Road type","Light type","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30"]
["Ergon Energy",1,"Major ","LED",47.107851658699111,31.990686402623016,59.028170010136485,256,161,88.2,{"$f":"ROUND(J54*(1+'Ratios & Assumptions'!$D$13),0)","v":90},{"$f":"ROUND(K54*(1+'Ratios & Assumptions'!$D$13),0)","v":92},{"$f":"ROUND(L54*(1+'Ratios & Assumptions'!$D$13),0)","v":94},{"$f":"ROUND(M54*(1+'Ratios & Assumptions'!$D$13),0)","v":96},{"$f":"ROUND(N54*(1+'Ratios & Assumptions'!$D$13),0)","v":98}]
["Ergon Energy",1,"Minor","LED",113.33549093332064,133.08515580736542,116.52212665460117,226,1010,279.40000000000003,{"$f":"ROUND(J55*(1+'Ratios & Assumptions'!$D$14),0)","v":284},{"$f":"ROUND(K55*(1+'Ratios & Assumptions'!$D$14),0)","v":288},{"$f":"ROUND(L55*(1+'Ratios & Assumptions'!$D$14),0)","v":292},{"$f":"ROUND(M55*(1+'Ratios & Assumptions'!$D$14),0)","v":296},{"$f":"ROUND(N55*(1+'Ratios & Assumptions'!$D$14),0)","v":300}]
["Ergon Energy","All","All","LED",{"$f":"SUM(E54:E55)","v":160.44334259201975},165.07584220998845,175.55029666473766,482,1171,367.6,374,380,386,392,398]
["Notes:"]
["All new installations are assumed to be LEDs"]
["Actual figures (2019-20 to 2021-22) are sourced from the RIN"]
[null,null,null,null,null,null,null,null,null,null,"100%  LED deployment by 2030"]
[null,null,null,null,null,null,null,null,null,null,"Forthcoming period"]
["3 - Conversion of Nostalgia lights from CONV to LED",null,null,null,"Actual ","Actual ","Actual ","Actual ","Actual ","Forecast ","Forecast","Forecast","Forecast","Forecast","Forecast"]
["DNSP","Rate","Road type","Light type","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30"]
["Ergon Energy",1,"Minor","LED",null,null,null,null,null,null,{"$f":"ROUND(J64*(1+'Ratios & Assumptions'!$D$13),0)","v":0},{"$f":"ROUND(K64*(1+'Ratios & Assumptions'!$D$13),0)","v":0},{"$f":"ROUND(L64*(1+'Ratios & Assumptions'!$D$13),0)","v":0},{"$f":"ROUND(M64*(1+'Ratios & Assumptions'!$D$13),0)","v":0},{"$f":"ROUND(N64*(1+'Ratios & Assumptions'!$D$13),0)","v":0},"No Rate 1 Nostalgia lights"]
[null,"2A","Minor","LED",null,null,null,null,null,null,1483,1483,1483,1483,1483]
["Ergon Energy","All","Minor","LED",null,null,null,null,null,null,{"$f":"SUM(K64:K65)","v":1483},1483,1483,1483,1483]
["Notes:",null,null,null,null,null,null,null,null,"Sum",null,null,null,null,{"$f":"SUM(K66:O66)","v":7415}]
["Convert remaining 7,415 Nostalgia lamps to LEDs over the 2025-30 period"]
["Existing Rate 2 Nostalgia lights converted to LED and funded by Ergon. Once converted the assets are assigned to Rate 2A"]
[]
["4 - Total public lighting asset base (table 1.a, table 2 and table 3 combined) ",null,null,null,null,null,null,null,null,null,"100%  LED deployment by 2030"]
[null,null,null,null,null,null,null,null,null,null,"Forthcoming period"]
[null,null,null,null,"Actual ","Actual ","Actual ","Actual ","Actual ","Forecast ","Forecast","Forecast","Forecast","Forecast","Forecast"]
["DNSP","Rate","Road type","Light type","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30"]
["Ergon Energy",1,"Major","CONV",null,{"$f":"F5","v":27894},26945,26195,25747,21456,17165,12874,8582,4291,0]
["Ergon Energy",1,"Major","LED",null,{"$f":"F6+F54","v":785.99068640262306},{"$f":"G6+G54","v":1896.0281700101366},{"$f":"H6+H54","v":2882},{"$f":"I6+SUM(H54:I54)","v":3694},{"$f":"J6+SUM(H54:J54)","v":8073.2},{"$f":"K6+K54","v":11949},{"$f":"L6+SUM(K54:L54)","v":16332},{"$f":"M6+SUM(K54:M54)","v":20718},{"$f":"N6+SUM(K54:N54)","v":25105},{"$f":"O6+SUM(K54:O54)","v":29494.000000000004}]
["Ergon Energy",1,"Minor","CONV",null,{"$f":"F7","v":68404},53974,30065,16683,13903,11122,8342,5561,2781,0]
["Ergon Energy",1,"Minor","LED",null,{"$f":"F8+F55","v":1847.0851558073655},{"$f":"G8+G55","v":17485.5221266546},{"$f":"H8+H55","v":42216},{"$f":"I8+SUM(H55:I55)","v":58130},{"$f":"J8+SUM(H55:J55)","v":61189.4},{"$f":"K8+K55+K64","v":62739},{"$f":"L8+SUM(K55:L55)+L64","v":65807},{"$f":"M8+SUM(K55:M55)+M64","v":68880},{"$f":"N8+SUM(K55:N55)+N64","v":71956},{"$f":"O8+SUM(K55:O55)+O64","v":75037}]
["Ergon Energy",2,"Major","CONV",null,{"$f":"F9","v":12883},12715,12494,12293,10244,8195,6147,4098,2049,0]
["Ergon Energy","2A","Major","LED",null,{"$f":"F10","v":558},924,1483,{"$f":"I10","v":2217},4266,{"$f":"K10","v":6315},8363,10412,12461,14510.000000000004]
["Ergon Energy",2,"Minor","CONV",null,34480,29753,21261,{"$f":"I11","v":15755},{"$f":"J11","v":13129},{"$f":"K11","v":10503},{"$f":"L11","v":7878},{"$f":"M11","v":5252},{"$f":"N11","v":2626},0]
["Ergon Energy","2A","Minor","LED",null,1302,6637,16154,{"$f":"I12","v":21842},24468,{"$f":"K12+K65","v":28577},{"$f":"L12+L65","v":31202},{"$f":"M12+M65","v":33828},36454,39080]
["Ergon Energy","All","All","CONV",null,{"$f":"SUMIF($D$75:$D$82,$D83,F$75:F$82)","v":143661},123387,90015,70478,58732,46985,35241,23493,11747,0]
["Ergon Energy","All","All","LED",null,4493.075842209988,26942.550296664736,62735,85883,97996.6,109580,121704,133838,145976,{"$f":"SUMIF($D$75:$D$82,$D84,O$75:O$82)","v":158121}]
["Ergon Energy","All","All","All",null,{"$f":"SUM(F83:F84)","v":148154.07584220998},{"$f":"SUM(G83:G84)","v":150329.55029666473},152750,156361,156728.6,156565,156945,157331,157723,158121]
[null,null,null,null,null,null,null,null,null,"Check",{"$f":"IF(K15+K56+K66-K85=0,0,1)","v":0},{"$f":"IF(L15+SUM(K56,L56)+L66-L85=0,0,1)","v":0},{"$f":"IF(M15+SUM(K56:M56)+M66-M85=0,0,1)","v":0},{"$f":"IF(N15+SUM(K56:N56)+N66-N85=0,0,1)","v":0},{"$f":"IF(O15+SUM(K56:O56)+O66-O85=0,0,1)","v":0}]
["Proportion ","LED","Rate 1",null,null,{"$f":"((F76-E76)+(F78-E78))/((F76-E76)+(F78-E78)+(F80-E80)+(F82-E82))","v":0.58602968983378434},0.74605196163651277,0.71848811457403305,0.72256782443407641,0.61407013604543648,0.46837716041922056,0.61456614978554935,0.61471897148508325,0.61484593837535018,0.61506792918896658]
[null,null,"Rate2A",null,null,{"$f":"1-F87","v":0.41397031016621566},0.25394803836348723,0.28151188542596695,0.27743217556592359,0.38592986395456352,{"$f":"1-K87","v":0.53162283958077938},{"$f":"1-L87","v":0.38543385021445065},0.38528102851491675,0.38515406162464982,0.38493207081103342]
["Note:"]
["No to little growth assumed in Table 4 as the capex is for the conversion to LED of existing light population. Growth of 2.5% is included in Table 5"]
["Customer funded new installations removed from the Rate 2A tariff and included in Table 5 below to be treated separately "]
[]
[]
["Table 5 - Rate 2 customer contributed assets ",null,null,null,null,null,null,null,null,null,"100%  LED deployment by 2030"]
[null,null,null,null,"Previous period","Current period",null,null,null,null,"Forthcoming period"]
[null,null,null,null,"Actual","Actual","Actual","Actual","Actual","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast"]
["DNSP","Rate","Road type","Light type","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30"]
["New installations and new subdivisions"]
["Ergon Energy",2,"Major","LED ",null,{"$f":"ROUND(F80*'Ratios & Assumptions'!$C$21,0)","v":34},{"$f":"ROUND(G80*'Ratios & Assumptions'!$C$21,0)","v":56},{"$f":"ROUND(H80*'Ratios & Assumptions'!$C$21,0)","v":90},{"$f":"ROUND(I80*'Ratios & Assumptions'!$C$21,0)","v":135},{"$f":"ROUND(J80*'Ratios & Assumptions'!$C$21,0)","v":260},{"$f":"ROUND(J99*(1+'Ratios & Assumptions'!$D$13),0)","v":267},{"$f":"ROUND(K99*(1+'Ratios & Assumptions'!$D$13),0)","v":274},{"$f":"ROUND(L99*(1+'Ratios & Assumptions'!$D$13),0)","v":281},{"$f":"ROUND(M99*(1+'Ratios & Assumptions'!$D$13),0)","v":288},{"$f":"ROUND(N99*(1+'Ratios & Assumptions'!$D$13),0)","v":295}]
["Ergon Energy",2,"Minor ","LED ",null,{"$f":"ROUND(F82*'Ratios & Assumptions'!$C$22,0)","v":53},{"$f":"ROUND(G82*'Ratios & Assumptions'!$C$22,0)","v":271},{"$f":"ROUND(H82*'Ratios & Assumptions'!$C$22,0)","v":659},{"$f":"ROUND(I82*'Ratios & Assumptions'!$C$22,0)","v":891},{"$f":"ROUND(J82*'Ratios & Assumptions'!$C$22,0)","v":998},{"$f":"ROUND(J100*(1+'Ratios & Assumptions'!$D$13),0)","v":1023},{"$f":"ROUND(K100*(1+'Ratios & Assumptions'!$D$13),0)","v":1049},{"$f":"ROUND(L100*(1+'Ratios & Assumptions'!$D$13),0)","v":1075},{"$f":"ROUND(M100*(1+'Ratios & Assumptions'!$D$13),0)","v":1102},{"$f":"ROUND(N100*(1+'Ratios & Assumptions'!$D$13),0)","v":1130}]
["Rate 4 reassigned to Rate 2 on 1 July 2025"]
["Ergon Energy",4,"Major","LED ",null,10,34,60,116,118,{"$f":"$J$102","v":118},{"$f":"$J$102","v":118},118,118,118]
["Ergon Energy",4,"Minor ","LED ",null,7,18,29,48,80,{"$f":"$J$103","v":80},{"$f":"$J$103","v":80},80,80,80]
["All",2,"Major","LED ",null,{"$f":"F99","v":34},{"$f":"G99","v":56},90,135,260,{"$f":"K99+K102","v":385},{"$f":"L99+L102","v":392},399,406,413]
[null,2,"Minor","LED ",null,{"$f":"F100","v":53},{"$f":"G100","v":271},659,891,998,{"$f":"K100+K103","v":1103},{"$f":"L100+L103","v":1129},1155,1182,1210]
["All",2,"All","LED ",null,{"$f":"F104+F105","v":87},327,749,1026,1258,1488,1521,1554,1588,1623]
["Notes:"]
["Historical 2019-20 to 2022-23 figures for Other Contributed assets, based on internal reports between 2019-20 to 2020-21, growth is relatively modest "]
["Historical 2019-20 to 2022-23 figures for New Installations  based on RIN data"]
["Forecast growth rate of 2.5%"]

{"sheet":">>Unit Rates","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ERG Unit Rates","index":12,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Table 1: Ergon Energy Public Light - Unit costs per luminaire"]
[null,null,null,"Unit cost "]
["Activity type","Asset type","Cost categories","$2022-30 "]
[null,null,null,"Actual"]
["Light installation","steel underground decorative minor (typically Rate 2)","Labour","N/A"]
[null,null,"Material","N/A"]
[null,null,"Contractor","N/A"]
[null,"steel underground minor","Labour","N/A"]
[null,null,"Material","N/A"]
[null,null,"Contractor","N/A"]
[null,"Rate 1 Major LED install","Labour",14745.486098730435]
[null,null,"Material",9330.2050159722203]
[null,null,"Contractor",7769.1658993793917]
[null,"Rate 1 Minor LED install","Labour",3459.3008037554196]
[null,null,"Material",882.75971032001712]
[null,null,"Contractor",1822.6514650165586]
[null,"High Pressure Sodium - Major (Rate 1 and 2)\nChange to Rate 2 Major LED Install","Labour",0]
[null,null,"Material",0]
[null,null,"Contractor",0]
[null,"High Pressure Sodium - Minor \nChange to Rate 2 Minor LED Install","Labour",0]
[null,null,"Material",0]
[null,null,"Contractor",0]
["Light replacement","LED Major","Labour",0]
[null,null,"Material",584]
[null,null,"Contractor",125]
[null,"LED Minor","Labour",0]
[null,null,"Material",197]
[null,null,"Contractor",125]
[null,"Nostalgia LED","Labour",0]
[null,null,"Material",690.66]
[null,null,"Contractor",295]

{"sheet":">>Forecast capex","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ERG - Forecast capex scenarios","index":14,"n_rows":141,"n_cols":11,"rows_kept":141,"cut":false,"hidden":false,"merged":[[116,5,116,9],[1,5,1,9],[28,5,28,9],[57,5,57,9],[85,5,85,9],[101,5,101,9]]}
["Table 1 - ERG Light Replacement Capex - CONV to LED"]
["Real $2022-23",null,null,null,null,"100%  LED deployment by 2030"]
[null,null,null,null,null,"Forecast","Forecast","Forecast","Forecast","Forecast"]
["DNSP","Rate","Road type","Light type","Cost category","2025-26","2026-27","2027-28","2028-29","2029-30"]
["Ergon Energy",1,"Major","LED","Labour",{"$f":"'ERG Unit Rates'!$D23*'ERG - Yearly volume scenarios'!K$41","v":0},{"$f":"'ERG Unit Rates'!$D23*'ERG - Yearly volume scenarios'!L$41","v":0},{"$f":"'ERG Unit Rates'!$D23*'ERG - Yearly volume scenarios'!M$41","v":0},{"$f":"'ERG Unit Rates'!$D23*'ERG - Yearly volume scenarios'!N$41","v":0},{"$f":"'ERG Unit Rates'!$D23*'ERG - Yearly volume scenarios'!O$41","v":0}]
[null,1,"Major","LED","Material",{"$f":"'ERG Unit Rates'!$D24*'ERG - Yearly volume scenarios'!K$41","v":2505944},{"$f":"'ERG Unit Rates'!$D24*'ERG - Yearly volume scenarios'!L$41","v":2505944},{"$f":"'ERG Unit Rates'!$D24*'ERG - Yearly volume scenarios'!M$41","v":2505944},{"$f":"'ERG Unit Rates'!$D24*'ERG - Yearly volume scenarios'!N$41","v":2505944},{"$f":"'ERG Unit Rates'!$D24*'ERG - Yearly volume scenarios'!O$41","v":2505944}]
[null,1,"Major","LED","Contractor",{"$f":"'ERG Unit Rates'!$D25*'ERG - Yearly volume scenarios'!K$41","v":536375},{"$f":"'ERG Unit Rates'!$D25*'ERG - Yearly volume scenarios'!L$41","v":536375},{"$f":"'ERG Unit Rates'!$D25*'ERG - Yearly volume scenarios'!M$41","v":536375},{"$f":"'ERG Unit Rates'!$D25*'ERG - Yearly volume scenarios'!N$41","v":536375},{"$f":"'ERG Unit Rates'!$D25*'ERG - Yearly volume scenarios'!O$41","v":536375}]
["Ergon Energy",1,"Minor","LED","Labour",{"$f":"'ERG Unit Rates'!$D26*'ERG - Yearly volume scenarios'!K$42","v":0},{"$f":"'ERG Unit Rates'!$D26*'ERG - Yearly volume scenarios'!L$42","v":0},{"$f":"'ERG Unit Rates'!$D26*'ERG - Yearly volume scenarios'!M$42","v":0},{"$f":"'ERG Unit Rates'!$D26*'ERG - Yearly volume scenarios'!N$42","v":0},{"$f":"'ERG Unit Rates'!$D26*'ERG - Yearly volume scenarios'!O$42","v":0}]
[null,1,"Minor","LED","Material",{"$f":"'ERG Unit Rates'!$D27*'ERG - Yearly volume scenarios'!K$42","v":547857},{"$f":"'ERG Unit Rates'!$D27*'ERG - Yearly volume scenarios'!L$42","v":547857},{"$f":"'ERG Unit Rates'!$D27*'ERG - Yearly volume scenarios'!M$42","v":547857},{"$f":"'ERG Unit Rates'!$D27*'ERG - Yearly volume scenarios'!N$42","v":547857},{"$f":"'ERG Unit Rates'!$D27*'ERG - Yearly volume scenarios'!O$42","v":547857}]
[null,1,"Minor","LED","Contractor",{"$f":"'ERG Unit Rates'!$D28*'ERG - Yearly volume scenarios'!K$42","v":347625},{"$f":"'ERG Unit Rates'!$D28*'ERG - Yearly volume scenarios'!L$42","v":347625},{"$f":"'ERG Unit Rates'!$D28*'ERG - Yearly volume scenarios'!M$42","v":347625},{"$f":"'ERG Unit Rates'!$D28*'ERG - Yearly volume scenarios'!N$42","v":347625},{"$f":"'ERG Unit Rates'!$D28*'ERG - Yearly volume scenarios'!O$42","v":347625}]
["Ergon Energy","2A","Major","LED","Labour",{"$f":"'ERG Unit Rates'!$D23*'ERG - Yearly volume scenarios'!K$43","v":0},{"$f":"'ERG Unit Rates'!$D23*'ERG - Yearly volume scenarios'!L$43","v":0},{"$f":"'ERG Unit Rates'!$D23*'ERG - Yearly volume scenarios'!M$43","v":0},{"$f":"'ERG Unit Rates'!$D23*'ERG - Yearly volume scenarios'!N$43","v":0},{"$f":"'ERG Unit Rates'!$D23*'ERG - Yearly volume scenarios'!O$43","v":0}]
[null,"2A","Major","LED","Material",{"$f":"'ERG Unit Rates'!$D24*'ERG - Yearly volume scenarios'!K$43","v":1196616},{"$f":"'ERG Unit Rates'!$D24*'ERG - Yearly volume scenarios'!L$43","v":1196616},{"$f":"'ERG Unit Rates'!$D24*'ERG - Yearly volume scenarios'!M$43","v":1196616},{"$f":"'ERG Unit Rates'!$D24*'ERG - Yearly volume scenarios'!N$43","v":1196616},{"$f":"'ERG Unit Rates'!$D24*'ERG - Yearly volume scenarios'!O$43","v":1196616}]
[null,"2A","Major","LED","Contractor",{"$f":"'ERG Unit Rates'!$D25*'ERG - Yearly volume scenarios'!K$43","v":256125},{"$f":"'ERG Unit Rates'!$D25*'ERG - Yearly volume scenarios'!L$43","v":256125},{"$f":"'ERG Unit Rates'!$D25*'ERG - Yearly volume scenarios'!M$43","v":256125},{"$f":"'ERG Unit Rates'!$D25*'ERG - Yearly volume scenarios'!N$43","v":256125},{"$f":"'ERG Unit Rates'!$D25*'ERG - Yearly volume scenarios'!O$43","v":256125}]
["Ergon Energy","2A","Minor","LED","Labour",{"$f":"'ERG Unit Rates'!$D26*'ERG - Yearly volume scenarios'!K$44","v":0},{"$f":"'ERG Unit Rates'!$D26*'ERG - Yearly volume scenarios'!L$44","v":0},{"$f":"'ERG Unit Rates'!$D26*'ERG - Yearly volume scenarios'!M$44","v":0},{"$f":"'ERG Unit Rates'!$D26*'ERG - Yearly volume scenarios'!N$44","v":0},{"$f":"'ERG Unit Rates'!$D26*'ERG - Yearly volume scenarios'!O$44","v":0}]
[null,"2A","Minor","LED","Material",{"$f":"'ERG Unit Rates'!$D27*'ERG - Yearly volume scenarios'!K$44","v":517322},{"$f":"'ERG Unit Rates'!$D27*'ERG - Yearly volume scenarios'!L$44","v":517322},{"$f":"'ERG Unit Rates'!$D27*'ERG - Yearly volume scenarios'!M$44","v":517322},{"$f":"'ERG Unit Rates'!$D27*'ERG - Yearly volume scenarios'!N$44","v":517322},{"$f":"'ERG Unit Rates'!$D27*'ERG - Yearly volume scenarios'!O$44","v":517322}]
[null,"2A","Minor","LED","Contractor",{"$f":"'ERG Unit Rates'!$D28*'ERG - Yearly volume scenarios'!K$44","v":328250},{"$f":"'ERG Unit Rates'!$D28*'ERG - Yearly volume scenarios'!L$44","v":328250},{"$f":"'ERG Unit Rates'!$D28*'ERG - Yearly volume scenarios'!M$44","v":328250},{"$f":"'ERG Unit Rates'!$D28*'ERG - Yearly volume scenarios'!N$44","v":328250},{"$f":"'ERG Unit Rates'!$D28*'ERG - Yearly volume scenarios'!O$44","v":328250}]
["Ergon Energy",1,"All","LED","Labour",{"$f":"SUMIFS(F$5:F$16,$B$5:$B$16,$B17,$E$5:$E$16,$E17)","v":0},0,0,0,0]
[null,1,"All","LED","Material",{"$f":"SUMIFS(F$5:F$16,$B$5:$B$16,$B18,$E$5:$E$16,$E18)","v":3053801},3053801,3053801,3053801,3053801]
[null,1,"All","LED","Contractor",884000,884000,884000,884000,884000]
["Ergon Energy","2A","All","LED","Labour",0,0,0,0,0]
[null,"2A","All","LED","Material",1713938,1713938,1713938,1713938,1713938]
[null,"2A","All","LED","Contractor",584375,584375,584375,584375,584375]
["Ergon Energy","All","All","LED","Labour",{"$f":"SUMIF($E$5:$E$16,$E23,F$5:F$16)","v":0},0,0,0,0]
[null,"All","All","LED","Material",{"$f":"SUMIF($E$5:$E$16,$E24,F$5:F$16)","v":4767739},4767739,4767739,4767739,4767739]
[null,"All","All","LED","Contractor",1468375,1468375,1468375,1468375,1468375]
["Ergon Energy","All","All","LED","All",{"$f":"SUM(F23:F25)","v":6236114},6236114,6236114,6236114,6236114]
[]
["Table 2 - ERG Light Replacement Capex - CONV to CONV"]
["Real $2022-23 (direct costs)",null,null,null,null,"100%  LED deployment by 2030"]
[null,null,null,null,null,"Forecast","Forecast","Forecast","Forecast","Forecast"]
["DNSP","Rate","Road Type","Light type","Cost category","2025-26","2026-27","2027-28","2028-29","2029-30"]
["Ergon Energy",1,"Major","CONV","Labour",0,0,0,0,0,"No like for like replacements for conventional assets for 2025-30"]
[null,1,"Major","CONV","Material",0,0,0,0,0,"No like for like replacements for conventional assets for 2025-30"]
[null,1,"Major","CONV","Contractor",0,0,0,0,0,"No like for like replacements for conventional assets for 2025-30"]
["Ergon Energy",1,"Minor","CONV","Labour",0,0,0,0,0,"No like for like replacements for conventional assets for 2025-30"]
[null,1,"Minor","CONV","Material",0,0,0,0,0,"No like for like replacements for conventional assets for 2025-30"]
[null,1,"Minor","CONV","Contractor",0,0,0,0,0,"No like for like replacements for conventional assets for 2025-30"]
["Ergon Energy",2,"Major","CONV","Labour",0,0,0,0,0,"No like for like replacements for conventional assets for 2025-30"]
[null,2,"Major","CONV","Material",0,0,0,0,0,"No like for like replacements for conventional assets for 2025-30"]
[null,2,"Major","CONV","Contractor",0,0,0,0,0,"No like for like replacements for conventional assets for 2025-30"]
["Ergon Energy",2,"Minor","CONV","Labour",0,0,0,0,0,"No like for like replacements for conventional assets for 2025-30"]
[null,2,"Minor","CONV","Material",0,0,0,0,0,"No like for like replacements for conventional assets for 2025-30"]
[null,2,"Minor","CONV","Contractor",0,0,0,0,0,"No like for like replacements for conventional assets for 2025-30"]
["Ergon Energy",1,"All","CONV","Labour",{"$f":"SUMIFS(F32:F43,$B$32:$B$43,$B44,$E$32:$E$43,$E44)","v":0},0,0,0,0]
[null,1,"All","CONV","Material",{"$f":"SUMIFS(F$32:F$43,$B$32:$B$43,$B45,$E$32:$E$43,$E45)","v":0},0,0,0,0]
[null,1,"All","CONV","Contractor",0,0,0,0,0]
["Ergon Energy",2,"All","CONV","Labour",0,0,0,0,0]
[null,2,"All","CONV","Material",0,0,0,0,0]
[null,2,"All","CONV","Contractor",0,0,0,0,0]
["Ergon Energy","All","All","CONV","Labour",{"$f":"SUMIF($E$32:$E$43,$E50,F$32:F$43)","v":0},0,0,0,0]
[null,"All","All","CONV","Material",{"$f":"SUMIF($E$32:$E$43,$E51,F$32:F$43)","v":0},0,0,0,0]
[null,"All","All","CONV","Contractor",0,0,0,0,0]
["Ergon Energy","All","All","CONV","All",{"$f":"SUM(F50:F52)","v":0},0,0,0,0]
["Note:"]
["Assumed $0 given that we do not have any stocks of conventional lights"]
[]
["Table 3 - ERG  Light Installation Capex"]
["Real $2022-23 (direct costs)",null,null,null,null,"100%  LED deployment by 2030"]
[null,null,null,null,null,"Forecast","Forecast","Forecast","Forecast","Forecast"]
["DNSP","Rate","Road type","Light type","Cost category","2025-26","2026-27","2027-28","2028-29","2029-30"]
["Ergon Energy",1,"Major","LED","Labour",{"$f":"'ERG - Yearly volume scenarios'!K$54*'ERG Unit Rates'!$D11","v":1327093.7488857391},{"$f":"'ERG - Yearly volume scenarios'!L$54*'ERG Unit Rates'!$D11","v":1356584.7210832001},{"$f":"'ERG - Yearly volume scenarios'!M$54*'ERG Unit Rates'!$D11","v":1386075.6932806608},{"$f":"'ERG - Yearly volume scenarios'!N$54*'ERG Unit Rates'!$D11","v":1415566.6654781217},{"$f":"'ERG - Yearly volume scenarios'!O$54*'ERG Unit Rates'!$D11","v":1445057.6376755827}]
[null,1,"Major","LED","Material",{"$f":"'ERG - Yearly volume scenarios'!K$54*'ERG Unit Rates'!$D12","v":839718.45143749984},{"$f":"'ERG - Yearly volume scenarios'!L$54*'ERG Unit Rates'!$D12","v":858378.86146944424},{"$f":"'ERG - Yearly volume scenarios'!M$54*'ERG Unit Rates'!$D12","v":877039.27150138875},{"$f":"'ERG - Yearly volume scenarios'!N$54*'ERG Unit Rates'!$D12","v":895699.68153333315},{"$f":"'ERG - Yearly volume scenarios'!O$54*'ERG Unit Rates'!$D12","v":914360.09156527754}]
[null,1,"Major","LED","Contractor",{"$f":"'ERG - Yearly volume scenarios'!K$54*'ERG Unit Rates'!$D13","v":699224.93094414531},{"$f":"'ERG - Yearly volume scenarios'!L$54*'ERG Unit Rates'!$D13","v":714763.26274290401},{"$f":"'ERG - Yearly volume scenarios'!M$54*'ERG Unit Rates'!$D13","v":730301.59454166284},{"$f":"'ERG - Yearly volume scenarios'!N$54*'ERG Unit Rates'!$D13","v":745839.92634042166},{"$f":"'ERG - Yearly volume scenarios'!O$54*'ERG Unit Rates'!$D13","v":761378.25813918037}]
["Ergon Energy",1,"Minor","LED","Labour",{"$f":"'ERG - Yearly volume scenarios'!K$55*'ERG Unit Rates'!$D14","v":982441.42826653912},{"$f":"'ERG - Yearly volume scenarios'!L$55*'ERG Unit Rates'!$D14","v":996278.63148156088},{"$f":"'ERG - Yearly volume scenarios'!M$55*'ERG Unit Rates'!$D14","v":1010115.8346965825},{"$f":"'ERG - Yearly volume scenarios'!N$55*'ERG Unit Rates'!$D14","v":1023953.0379116042},{"$f":"'ERG - Yearly volume scenarios'!O$55*'ERG Unit Rates'!$D14","v":1037790.2411266259}]
[null,1,"Minor","LED","Material",{"$f":"'ERG - Yearly volume scenarios'!K$55*'ERG Unit Rates'!$D15","v":250703.75773088486},{"$f":"'ERG - Yearly volume scenarios'!L$55*'ERG Unit Rates'!$D15","v":254234.79657216492},{"$f":"'ERG - Yearly volume scenarios'!M$55*'ERG Unit Rates'!$D15","v":257765.83541344499},{"$f":"'ERG - Yearly volume scenarios'!N$55*'ERG Unit Rates'!$D15","v":261296.87425472506},{"$f":"'ERG - Yearly volume scenarios'!O$55*'ERG Unit Rates'!$D15","v":264827.91309600516}]
[null,1,"Minor","LED","Contractor",{"$f":"'ERG - Yearly volume scenarios'!K$55*'ERG Unit Rates'!$D16","v":517633.01606470265},{"$f":"'ERG - Yearly volume scenarios'!L$55*'ERG Unit Rates'!$D16","v":524923.6219247689},{"$f":"'ERG - Yearly volume scenarios'!M$55*'ERG Unit Rates'!$D16","v":532214.22778483515},{"$f":"'ERG - Yearly volume scenarios'!N$55*'ERG Unit Rates'!$D16","v":539504.8336449014},{"$f":"'ERG - Yearly volume scenarios'!O$55*'ERG Unit Rates'!$D16","v":546795.43950496754}]
["Ergon Energy","2A","Major","LED","Labour",0,0,0,0,0,"Assumes customers or real estate developers are funding the upfront capex to install new lights "]
[null,"2A","Major","LED","Material",0,0,0,0,0,"Assumes customers or real estate developers are funding the upfront capex to install new lights "]
[null,"2A","Major","LED","Contractor",0,0,0,0,0,"Assumes customers or real estate developers are funding the upfront capex to install new lights "]
["Ergon Energy","2A","Minor","LED","Labour",0,0,0,0,0,"Assumes customers or real estate developers are funding the upfront capex to install new lights "]
[null,"2A","Minor","LED","Material",0,0,0,0,0,"Assumes customers or real estate developers are funding the upfront capex to install new lights "]
[null,"2A","Minor","LED","Contractor",0,0,0,0,0,"Assumes customers or real estate developers are funding the upfront capex to install new lights "]
["Ergon Energy",1,"All","LED","Labour",{"$f":"SUMIFS(F$61:F$72,$B$61:$B$72,$B73,$E$61:$E$72,$E73)","v":2309535.1771522784},2352863.3525647609,2396191.5279772431,2439519.7033897256,2482847.8788022087]
[null,1,"All","LED","Material",{"$f":"SUMIFS(F$61:F$72,$B$61:$B$72,$B74,$E$61:$E$72,$E74)","v":1090422.2091683848},1112613.6580416092,1134805.1069148337,1156996.5557880583,1179188.0046612828]
[null,1,"All","LED","Contractor",1216857.947008848,1239686.8846676729,1262515.8223264981,1285344.7599853231,1308173.697644148]
["Ergon Energy","2A","All","LED","Labour",0,0,0,0,0]
[null,"2A","All","LED","Material",0,0,0,0,0]
[null,"2A","All","LED","Contractor",0,0,0,0,0]
["Ergon Energy","All","All","All","Labour",{"$f":"SUMIF($E$61:$E$72,$E79,F$61:F$72)","v":2309535.1771522784},2352863.3525647609,2396191.5279772431,2439519.7033897256,2482847.8788022087]
[null,"All","All","All","Material",{"$f":"SUMIF($E$61:$E$72,$E80,F$61:F$72)","v":1090422.2091683848},1112613.6580416092,1134805.1069148337,1156996.5557880583,1179188.0046612828]
[null,"All","All","All","Contractor",1216857.947008848,1239686.8846676729,1262515.8223264981,1285344.7599853231,1308173.697644148]
["Ergon Energy","All","All","All","All",{"$f":"SUM(F79:F81)","v":4616815.3333295109},4705163.8952740431,4793512.4572185744,4881861.0191631075,4970209.5811076397]
[]
[]
["Table 4 - ERG Nostalgia Replacement Capex"]
["Real $2022-23 (direct costs)",null,null,null,null,"100%  LED deployment by 2030"]
[null,null,null,null,null,"Forecast","Forecast","Forecast","Forecast","Forecast"]
["DNSP","Rate","Road type","Light type","Cost category","2025-26","2026-27","2027-28","2028-29","2029-30"]
["Ergon Energy",1,"Minor","LED","Labour",{"$f":"'ERG - Yearly volume scenarios'!K$64*'ERG Unit Rates'!$D29","v":0},{"$f":"'ERG - Yearly volume scenarios'!L$64*'ERG Unit Rates'!$D29","v":0},{"$f":"'ERG - Yearly volume scenarios'!M$64*'ERG Unit Rates'!$D29","v":0},{"$f":"'ERG - Yearly volume scenarios'!N$64*'ERG Unit Rates'!$D29","v":0},{"$f":"'ERG - Yearly volume scenarios'!O$64*'ERG Unit Rates'!$D29","v":0}]
[null,1,"Minor","LED","Material",{"$f":"'ERG - Yearly volume scenarios'!K$64*'ERG Unit Rates'!$D30","v":0},{"$f":"'ERG - Yearly volume scenarios'!L$64*'ERG Unit Rates'!$D30","v":0},{"$f":"'ERG - Yearly volume scenarios'!M$64*'ERG Unit Rates'!$D30","v":0},{"$f":"'ERG - Yearly volume scenarios'!N$64*'ERG Unit Rates'!$D30","v":0},{"$f":"'ERG - Yearly volume scenarios'!O$64*'ERG Unit Rates'!$D30","v":0}]
[null,1,"Minor","LED","Contractor",{"$f":"'ERG - Yearly volume scenarios'!K$64*'ERG Unit Rates'!$D31","v":0},{"$f":"'ERG - Yearly volume scenarios'!L$64*'ERG Unit Rates'!$D31","v":0},{"$f":"'ERG - Yearly volume scenarios'!M$64*'ERG Unit Rates'!$D31","v":0},{"$f":"'ERG - Yearly volume scenarios'!N$64*'ERG Unit Rates'!$D31","v":0},{"$f":"'ERG - Yearly volume scenarios'!O$64*'ERG Unit Rates'!$D31","v":0}]
["Ergon Energy","2A","Minor","LED","Labour",{"$f":"'ERG - Yearly volume scenarios'!K$65*'ERG Unit Rates'!$D29","v":0},{"$f":"'ERG - Yearly volume scenarios'!L$65*'ERG Unit Rates'!$D29","v":0},{"$f":"'ERG - Yearly volume scenarios'!M$65*'ERG Unit Rates'!$D29","v":0},{"$f":"'ERG - Yearly volume scenarios'!N$65*'ERG Unit Rates'!$D29","v":0},{"$f":"'ERG - Yearly volume scenarios'!O$65*'ERG Unit Rates'!$D29","v":0}]
[null,"2A","Minor","LED","Material",{"$f":"'ERG - Yearly volume scenarios'!K$65*'ERG Unit Rates'!$D30","v":1024248.7799999999},{"$f":"'ERG - Yearly volume scenarios'!L$65*'ERG Unit Rates'!$D30","v":1024248.7799999999},{"$f":"'ERG - Yearly volume scenarios'!M$65*'ERG Unit Rates'!$D30","v":1024248.7799999999},{"$f":"'ERG - Yearly volume scenarios'!N$65*'ERG Unit Rates'!$D30","v":1024248.7799999999},{"$f":"'ERG - Yearly volume scenarios'!O$65*'ERG Unit Rates'!$D30","v":1024248.7799999999}]
[null,"2A","Minor","LED","Contractor",{"$f":"'ERG - Yearly volume scenarios'!K$65*'ERG Unit Rates'!$D31","v":437485},{"$f":"'ERG - Yearly volume scenarios'!L$65*'ERG Unit Rates'!$D31","v":437485},{"$f":"'ERG - Yearly volume scenarios'!M$65*'ERG Unit Rates'!$D31","v":437485},{"$f":"'ERG - Yearly volume scenarios'!N$65*'ERG Unit Rates'!$D31","v":437485},{"$f":"'ERG - Yearly volume scenarios'!O$65*'ERG Unit Rates'!$D31","v":437485}]
["Ergon Energy","All","All","LED","Labour",{"$f":"SUMIF($E$89:$E$94,$E95,F$89:F$94)","v":0},0,0,0,0]
[null,"All","All","LED","Material",{"$f":"SUMIF($E$89:$E$94,$E96,F$89:F$94)","v":1024248.7799999999},1024248.7799999999,1024248.7799999999,1024248.7799999999,1024248.7799999999]
[null,"All","All","LED","Contractor",437485,437485,437485,437485,437485]
["Ergon Energy","All","All","LED","All",{"$f":"SUM(F95:F97)","v":1461733.7799999998},1461733.7799999998,1461733.7799999998,1461733.7799999998,1461733.7799999998]
[]
[]
["Table 5 - ERG Pole Replacement Capex"]
["Real $2022-23 (direct costs)",null,null,null,null,"100%  LED deployment by 2030"]
[null,null,null,null,null,"Forecast","Forecast","Forecast","Forecast","Forecast"]
["DNSP","Rate","Road type","Light type","Cost category","2025-26","2026-27","2027-28","2028-29","2029-30"]
["Ergon Energy",1,"Major","All","Labour",0,0,0,0,0]
[null,1,"Major","All","Material",0,0,0,0,0]
[null,1,"Major","All","Contractor",0,0,0,0,0]
["Ergon Energy",2,"Minor","All","Labour",0,0,0,0,0]
[null,2,"Minor","All","Material",0,0,0,0,0]
[null,2,"Minor","All","Contractor",0,0,0,0,0]
["Ergon Energy","All","All","All","Labour",{"$f":"SUMIF($E$105:$E$110,$E111,F$105:F$110)","v":0},0,0,0,0]
[null,"All","All","All","Material",{"$f":"SUMIF($E$105:$E$110,$E112,F$105:F$110)","v":0},0,0,0,0]
[null,"All","All","All","Contractor",0,0,0,0,0]
[null,"All","All","All","All",{"$f":"SUM(F111:F113)","v":0},0,0,0,0]
[]
["Table 6 - ERG Nominal Public Lighting Capex (Direct costs)"]
["Real $2022-23 (direct costs)",null,null,null,null,"100%  LED deployment by 2030"]
[null,null,null,null,null,"Forecast","Forecast","Forecast","Forecast","Forecast"]
["DNSP","Rate","Road","Light type","Cost category","2025-26","2026-27","2027-28","2028-29","2029-30"]
["Ergon Energy",1,"Major","All","Labour",{"$f":"SUMIFS(F$5:F$114,$B$5:$B$114,$B120,$C$5:$C$114,$C120,$E$5:$E$114,$E120)","v":1327093.7488857391},1356584.7210832001,1386075.6932806608,1415566.6654781217,1445057.6376755827]
[null,1,"Major","All","Material",3345662.4514374998,3364322.8614694444,3382983.2715013889,3401643.6815333329,3420304.0915652774]
[null,1,"Major","All","Contractor",1235599.9309441452,1251138.262742904,1266676.5945416628,1282214.9263404217,1297753.2581391805]
["Ergon Energy","2A","Major","All","Labour",0,0,0,0,0]
[null,"2A","Major","All","Material",1196616,1196616,1196616,1196616,1196616]
[null,"2A","Major","All","Contractor",256125,256125,256125,256125,256125]
["Ergon Energy",1,"Minor","All","Labour",982441.42826653912,996278.63148156088,1010115.8346965825,1023953.0379116042,1037790.2411266259]
[null,1,"Minor","All","Material",798560.75773088483,802091.79657216487,805622.83541344502,809153.87425472506,812684.9130960051]
[null,1,"Minor","All","Contractor",865258.01606470265,872548.6219247689,879839.22778483515,887129.8336449014,894420.43950496754]
["Ergon Energy","2A","Minor","All","Labour",0,0,0,0,0]
[null,"2A","Minor","All","Material",1541570.7799999998,1541570.7799999998,1541570.7799999998,1541570.7799999998,1541570.7799999998]
[null,"2A","Minor","All","Contractor",765735,765735,765735,765735,765735]
["Ergon Energy",1,"All","All","Labour",{"$f":"SUMIFS(F$120:F$131,$B$120:$B$131,$B132,$E$120:$E$131,$E132)","v":2309535.1771522784},2352863.3525647609,2396191.5279772431,2439519.7033897256,2482847.8788022087]
[null,1,"All","All","Material",{"$f":"SUMIFS(F$120:F$131,$B$120:$B$131,$B133,$E$120:$E$131,$E133)","v":4144223.2091683848},4166414.6580416095,4188606.1069148341,4210797.5557880579,4232989.0046612825]
[null,1,"All","All","Contractor",2100857.9470088477,2123686.8846676731,2146515.8223264981,2169344.7599853231,2192173.697644148]
[null,"2A","All","All","Labour",0,0,0,0,0]
[null,"2A","All","All","Material",2738186.78,2738186.78,2738186.78,2738186.78,2738186.78]
[null,"2A","All","All","Contractor",1021860,1021860,1021860,1021860,1021860]
["Ergon Energy","All","All","All","Labour",{"$f":"SUMIFS(F$5:F$114,$B$5:$B$114,$B138,$C$5:$C$114,$C138,$E$5:$E$114,$E138)","v":2309535.1771522784},{"$f":"SUMIFS(G$5:G$114,$B$5:$B$114,$B138,$C$5:$C$114,$C138,$E$5:$E$114,$E138)","v":2352863.3525647609},2396191.5279772431,2439519.7033897256,2482847.8788022087]
[null,"All","All","All","Material",6882409.989168385,6904601.4380416097,6926792.8869148334,6948984.335788059,6971175.7846612828]
[null,"All","All","All","Contractor",3122717.9470088482,3145546.8846676731,3168375.8223264981,3191204.7599853231,3214033.697644148]
["Ergon Energy","All","All","All","All",12314663.113329509,12403011.675274042,12491360.237218574,12579708.799163107,12668057.361107638]

{"sheet":"ERG - Gross Capex ","index":15,"n_rows":98,"n_cols":8,"rows_kept":98,"cut":false,"hidden":false,"merged":[[1,1,1,5],[36,1,36,5],[66,1,66,5]]}
["1 - This tables shows the RATE 1 and RATE 2A LED capex conversions funded by Ergon"]
[null,"100%  LED deployment by 2030"]
[null,"2025-26","2026-27","2027-28","2028-29","2029-30"]
["Direct Costs ($Real 2024-25)"]
["Labour",{"$f":"'ERG - Forecast capex scenarios'!F138*'Cost Escalations'!$E$21*(1+'Cost Escalations'!B30)","v":2565823.2629344026},{"$f":"'ERG - Forecast capex scenarios'!G138*'Cost Escalations'!$E$21*(1+'Cost Escalations'!C30)","v":2638043.3266435019},{"$f":"'ERG - Forecast capex scenarios'!H138*'Cost Escalations'!$E$21*(1+'Cost Escalations'!D30)","v":2711093.8339020181},{"$f":"'ERG - Forecast capex scenarios'!I138*'Cost Escalations'!$E$21*(1+'Cost Escalations'!E30)","v":2789864.4585498236},{"$f":"'ERG - Forecast capex scenarios'!J138*'Cost Escalations'!$E$21*(1+'Cost Escalations'!F30)","v":2874454.0041424059}]
["Contractors",{"$f":"'ERG - Forecast capex scenarios'!F140*'Cost Escalations'!$E$21*(1+'Cost Escalations'!B26)","v":3466669.8063749913},{"$f":"'ERG - Forecast capex scenarios'!G140*'Cost Escalations'!$E$21*(1+'Cost Escalations'!C26)","v":3516806.532028262},{"$f":"'ERG - Forecast capex scenarios'!H140*'Cost Escalations'!$E$21*(1+'Cost Escalations'!D26)","v":3563938.1144588133},{"$f":"'ERG - Forecast capex scenarios'!I140*'Cost Escalations'!$E$21*(1+'Cost Escalations'!E26)","v":3622641.6550727976},{"$f":"'ERG - Forecast capex scenarios'!J140*'Cost Escalations'!$E$21*(1+'Cost Escalations'!F26)","v":3688326.2359526278}]
["Materials",{"$f":"'ERG - Forecast capex scenarios'!F139*'Cost Escalations'!$E$21","v":7561081.8784683077},{"$f":"'ERG - Forecast capex scenarios'!G139*'Cost Escalations'!$E$21","v":7585461.6178613938},{"$f":"'ERG - Forecast capex scenarios'!H139*'Cost Escalations'!$E$21","v":7609841.3572544781},{"$f":"'ERG - Forecast capex scenarios'!I139*'Cost Escalations'!$E$21","v":7634221.0966475653},{"$f":"'ERG - Forecast capex scenarios'!J139*'Cost Escalations'!$E$21","v":7658600.8360406496}]
["Total",{"$f":"SUM(B5:B7)","v":13593574.947777702},13740311.476533158,13884873.30561531,14046727.210270185,14221381.076135684]
[]
["Overheads & Oncosts"]
["Fleet oncost",{"$f":"B5*Overheads!$D$15","v":543031.72028546338},{"$f":"C5*Overheads!$D$15","v":558316.39947658847},{"$f":"D5*Overheads!$D$15","v":573776.83402692084},{"$f":"E5*Overheads!$D$15","v":590447.87619431433},{"$f":"F5*Overheads!$D$15","v":608350.43679732806}]
["Material oncosts",{"$f":"B7*Overheads!$D$9","v":601769.12377347832},{"$f":"C7*Overheads!$D$9","v":603709.45118273189},{"$f":"D7*Overheads!$D$9","v":605649.77859198547},{"$f":"E7*Overheads!$D$9","v":607590.10600123915},{"$f":"F7*Overheads!$D$9","v":609530.43341049273}]
["Network overheads",{"$f":"(B8+B11+B12)*Overheads!$D$19","v":1701449.8633727953},{"$f":"(C8+C11+C12)*Overheads!$D$19","v":1720378.1588559444},{"$f":"(D8+D11+D12)*Overheads!$D$19","v":1739075.6891870752},{"$f":"(E8+E11+E12)*Overheads!$D$19","v":1759909.2342480468},{"$f":"(F8+F11+F12)*Overheads!$D$19","v":1782362.6225986865}]
["Non-network overheads",{"$f":"B5*Overheads!$D$20","v":908353.95548731915},{"$f":"C5*Overheads!$D$20","v":933921.33632892929},{"$f":"D5*Overheads!$D$20","v":959782.7111855672},{"$f":"E5*Overheads!$D$20","v":987669.12468437187},{"$f":"F5*Overheads!$D$20","v":1017615.555306418}]
["Non-network depreciation",{"$f":"B5*Overheads!$D$25","v":353620.2630859791},{"$f":"C5*Overheads!$D$25","v":363573.59007378214},{"$f":"D5*Overheads!$D$25","v":373641.36830640206},{"$f":"E5*Overheads!$D$25","v":384497.48977579258},{"$f":"F5*Overheads!$D$25","v":396155.57153024786}]
["Corporate overheads",{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},null,"No allocation of corporate overheads to capex"]
["Market",{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},null,"No market allocation to capex"]
["Customer ops",{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},null,"No customer operation allocation to capex"]
["Total",{"$f":"SUM(B11:B18)","v":4108224.9260050352},4179898.9359179763,4251926.3812979506,4330113.8309037648,4414014.6196431732]
[]
["Total Expenditure (incl oncosts and overheads)",{"$f":"B8+B19","v":17701799.873782735},{"$f":"C8+C19","v":17920210.412451133},18136799.686913259,18376841.04117395,18635395.695778858]
[]
[null,"2025-26","2026-27","2027-28","2028-29","2029-30"]
["Allocation of total Expenditure (Gross)"]
["LED",{"$f":"('ERG - Forecast capex scenarios'!F$141-'ERG - Forecast capex scenarios'!F$53)/'ERG - Forecast capex scenarios'!F$141","v":1},{"$f":"('ERG - Forecast capex scenarios'!G$141-'ERG - Forecast capex scenarios'!G$53)/'ERG - Forecast capex scenarios'!G$141","v":1},{"$f":"('ERG - Forecast capex scenarios'!H$141-'ERG - Forecast capex scenarios'!H$53)/'ERG - Forecast capex scenarios'!H$141","v":1},{"$f":"('ERG - Forecast capex scenarios'!I$141-'ERG - Forecast capex scenarios'!I$53)/'ERG - Forecast capex scenarios'!I$141","v":1},{"$f":"('ERG - Forecast capex scenarios'!J$141-'ERG - Forecast capex scenarios'!J$53)/'ERG - Forecast capex scenarios'!J$141","v":1}]
["CON ",{"$f":"1-B25","v":0},{"$f":"1-C25","v":0},0,0,0]
[]
["LED",{"$f":"B25*B21","v":17701799.873782735},{"$f":"C25*C21","v":17920210.412451133},18136799.686913259,18376841.04117395,18635395.695778858]
["CON",{"$f":"B26*B24","v":0},{"$f":"C26*C24","v":0},{"$f":"D26*D24","v":0},{"$f":"E26*E24","v":0},{"$f":"F26*F24","v":0}]
[]
["Immediate Expensing"]
["LED",{"$f":"B25*B19","v":4108224.9260050352},{"$f":"C25*C19","v":4179898.9359179763},{"$f":"D25*D19","v":4251926.3812979506},{"$f":"E25*E19","v":4330113.8309037648},{"$f":"F25*F19","v":4414014.6196431732}]
["CON",{"$f":"B26*B19","v":0},{"$f":"C26*C19","v":0},{"$f":"D26*D19","v":0},{"$f":"E26*E19","v":0},{"$f":"F26*F19","v":0}]
[]
[]
["2 - This table presents  RATE 1 LED conversions are funded by customers"]
[null,"100%  LED deployment by 2030"]
[null,"2025-26","2026-27","2027-28","2028-29","2029-30"]
["Direct Costs ($Real 2024-25)"]
["Labour",{"$f":"'ERG - Forecast capex scenarios'!F132*'Cost Escalations'!$E$21*(1+'Cost Escalations'!B30)","v":2565823.2629344026},{"$f":"'ERG - Forecast capex scenarios'!G132*'Cost Escalations'!$E$21*(1+'Cost Escalations'!C30)","v":2638043.3266435019},{"$f":"'ERG - Forecast capex scenarios'!H132*'Cost Escalations'!$E$21*(1+'Cost Escalations'!D30)","v":2711093.8339020181},{"$f":"'ERG - Forecast capex scenarios'!I132*'Cost Escalations'!$E$21*(1+'Cost Escalations'!E30)","v":2789864.4585498236},{"$f":"'ERG - Forecast capex scenarios'!J132*'Cost Escalations'!$E$21*(1+'Cost Escalations'!F30)","v":2874454.0041424059}]
["Contractors",{"$f":"'ERG - Forecast capex scenarios'!F134*'Cost Escalations'!$E$21*(1+'Cost Escalations'!B26)","v":2332257.0068662968},{"$f":"'ERG - Forecast capex scenarios'!G134*'Cost Escalations'!$E$21*(1+'Cost Escalations'!C26)","v":2374339.4016430564},{"$f":"'ERG - Forecast capex scenarios'!H134*'Cost Escalations'!$E$21*(1+'Cost Escalations'!D26)","v":2414501.9345782581},{"$f":"'ERG - Forecast capex scenarios'!I134*'Cost Escalations'!$E$21*(1+'Cost Escalations'!E26)","v":2462630.6623373409},{"$f":"'ERG - Forecast capex scenarios'!J134*'Cost Escalations'!$E$21*(1+'Cost Escalations'!F26)","v":2515671.1233963547},{"$f":"'ERG - Forecast capex scenarios'!#REF!*'Cost Escalations'!$E$21*(1+'Cost Escalations'!G26)","v":{"$error":"#REF!"}}]
["Materials",{"$f":"'ERG - Forecast capex scenarios'!F133*'Cost Escalations'!$E$21","v":4552883.5184892984},{"$f":"'ERG - Forecast capex scenarios'!G133*'Cost Escalations'!$E$21","v":4577263.2578823837},{"$f":"'ERG - Forecast capex scenarios'!H133*'Cost Escalations'!$E$21","v":4601642.9972754698},{"$f":"'ERG - Forecast capex scenarios'!I133*'Cost Escalations'!$E$21","v":4626022.7366685541},{"$f":"'ERG - Forecast capex scenarios'!J133*'Cost Escalations'!$E$21","v":4650402.4760616403}]
["Total",{"$f":"SUM(B40:B42)","v":9450963.7882899977},{"$f":"SUM(C40:C42)","v":9589645.9861689433},9727238.7657557465,9878517.8575557172,10040527.603600401]
[]
["Overheads & Oncosts"]
["Fleet oncost",{"$f":"B40*Overheads!$D$15","v":543031.72028546338},{"$f":"C40*Overheads!$D$15","v":558316.39947658847},{"$f":"D40*Overheads!$D$15","v":573776.83402692084},{"$f":"E40*Overheads!$D$15","v":590447.87619431433},{"$f":"F40*Overheads!$D$15","v":608350.43679732806}]
["Material oncosts",{"$f":"B42*Overheads!$D$9","v":362353.53215339471},{"$f":"C42*Overheads!$D$9","v":364293.85956264829},{"$f":"D42*Overheads!$D$9","v":366234.18697190192},{"$f":"E42*Overheads!$D$9","v":368174.51438115543},{"$f":"F42*Overheads!$D$9","v":370114.84179040912}]
["Network overheads",{"$f":"(B43+B46+B47)*Overheads!$D$19","v":1195573.3053128542},{"$f":"(C43+C46+C47)*Overheads!$D$19","v":1213571.7805523789},{"$f":"(D43+D46+D47)*Overheads!$D$19","v":1231464.7793340925},{"$f":"(E43+E46+E47)*Overheads!$D$19","v":1251077.5308597859},{"$f":"(F43+F46+F47)*Overheads!$D$19","v":1272071.2376114866}]
["Non-network overheads",{"$f":"B40*Overheads!$D$20","v":908353.95548731915},{"$f":"C40*Overheads!$D$20","v":933921.33632892929},{"$f":"D40*Overheads!$D$20","v":959782.7111855672},{"$f":"E40*Overheads!$D$20","v":987669.12468437187},{"$f":"F40*Overheads!$D$20","v":1017615.555306418}]
["Non-network depreciation",{"$f":"B40*Overheads!$D$25","v":353620.2630859791},{"$f":"C40*Overheads!$D$25","v":363573.59007378214},{"$f":"D40*Overheads!$D$25","v":373641.36830640206},{"$f":"E40*Overheads!$D$25","v":384497.48977579258},{"$f":"F40*Overheads!$D$25","v":396155.57153024786}]
["Corporate overheads",0,0,0,0,0,null,"No allocation of corporate overheads to capex"]
["Market",0,0,0,0,0,null,"No market allocation to capex"]
["Customer ops",0,0,0,0,0,null,"No customer operation allocation to capex"]
["Total",{"$f":"SUM(B46:B53)","v":3362932.7763250107},{"$f":"SUM(C46:C53)","v":3433676.9659943269},{"$f":"SUM(D46:D53)","v":3504899.8798248842},{"$f":"SUM(E46:E53)","v":3581866.5358954202},{"$f":"SUM(F46:F53)","v":3664307.6430358896}]
[]
["Total Expenditure",{"$f":"B43+B54","v":12813896.564615007},13023322.95216327,13232138.645580631,13460384.393451137,13704835.24663629]
[]
["Allocation of total Expenditure (Gross)"]
["LED",{"$f":"('ERG - Forecast capex scenarios'!F$141-'ERG - Forecast capex scenarios'!F$53)/'ERG - Forecast capex scenarios'!F$141","v":1},{"$f":"('ERG - Forecast capex scenarios'!G$141-'ERG - Forecast capex scenarios'!G$53)/'ERG - Forecast capex scenarios'!G$141","v":1},{"$f":"('ERG - Forecast capex scenarios'!H$141-'ERG - Forecast capex scenarios'!H$53)/'ERG - Forecast capex scenarios'!H$141","v":1},{"$f":"('ERG - Forecast capex scenarios'!I$141-'ERG - Forecast capex scenarios'!I$53)/'ERG - Forecast capex scenarios'!I$141","v":1},{"$f":"('ERG - Forecast capex scenarios'!J$141-'ERG - Forecast capex scenarios'!J$53)/'ERG - Forecast capex scenarios'!J$141","v":1}]
["CON ",{"$f":"1-B59","v":0},{"$f":"1-C59","v":0},0,0,0]
[]
["LED",{"$f":"B59*B56","v":12813896.564615007},{"$f":"C59*C56","v":13023322.95216327},{"$f":"D59*D56","v":13232138.645580631},{"$f":"E59*E56","v":13460384.393451137},{"$f":"F59*F56","v":13704835.24663629}]
["CON",{"$f":"B60*B56","v":0},0,0,0,0]
[]
[]
["3 - This table presents the RATE 2A capex "]
[null,"100%  LED deployment by 2030"]
[null,"2025-26","2026-27","2027-28","2028-29","2029-30"]
["Direct Costs ($Real 2024-25)"]
["Labour",{"$f":"'ERG - Forecast capex scenarios'!F135*'Cost Escalations'!$E$21*(1+'Cost Escalations'!B30)","v":0},{"$f":"'ERG - Forecast capex scenarios'!G135*'Cost Escalations'!$E$21*(1+'Cost Escalations'!C30)","v":0},{"$f":"'ERG - Forecast capex scenarios'!H135*'Cost Escalations'!$E$21*(1+'Cost Escalations'!D30)","v":0},{"$f":"'ERG - Forecast capex scenarios'!I135*'Cost Escalations'!$E$21*(1+'Cost Escalations'!E30)","v":0},{"$f":"'ERG - Forecast capex scenarios'!J135*'Cost Escalations'!$E$21*(1+'Cost Escalations'!F30)","v":0}]
["Contractors",{"$f":"'ERG - Forecast capex scenarios'!F137*'Cost Escalations'!$E$21*(1+'Cost Escalations'!B26)","v":1134412.7995086939},{"$f":"'ERG - Forecast capex scenarios'!G137*'Cost Escalations'!$E$21*(1+'Cost Escalations'!C26)","v":1142467.1303852056},{"$f":"'ERG - Forecast capex scenarios'!H137*'Cost Escalations'!$E$21*(1+'Cost Escalations'!D26)","v":1149436.1798805553},{"$f":"'ERG - Forecast capex scenarios'!I137*'Cost Escalations'!$E$21*(1+'Cost Escalations'!E26)","v":1160010.9927354564},{"$f":"'ERG - Forecast capex scenarios'!J137*'Cost Escalations'!$E$21*(1+'Cost Escalations'!F26)","v":1172655.1125562727}]
["Materials",{"$f":"'ERG - Forecast capex scenarios'!F136*'Cost Escalations'!$E$21","v":3008198.3599790093},{"$f":"'ERG - Forecast capex scenarios'!G136*'Cost Escalations'!$E$21","v":3008198.3599790093},{"$f":"'ERG - Forecast capex scenarios'!H136*'Cost Escalations'!$E$21","v":3008198.3599790093},{"$f":"'ERG - Forecast capex scenarios'!I136*'Cost Escalations'!$E$21","v":3008198.3599790093},{"$f":"'ERG - Forecast capex scenarios'!J136*'Cost Escalations'!$E$21","v":3008198.3599790093},{"$f":"'ERG - Forecast capex scenarios'!K136*'Cost Escalations'!$E$21","v":0}]
["Total",{"$f":"SUM(B70:B72)","v":4142611.1594877029},4150665.4903642149,4157634.5398595645,4168209.3527144659,4180853.4725352819]
[]
["Overheads & Oncosts"]
["Fleet oncost",{"$f":"B70*Overheads!$D$15","v":0},{"$f":"C70*Overheads!$D$15","v":0},{"$f":"D70*Overheads!$D$15","v":0},{"$f":"E70*Overheads!$D$15","v":0},{"$f":"F70*Overheads!$D$15","v":0}]
["Material oncosts",{"$f":"B72*Overheads!$D$9","v":239415.59162008358},{"$f":"C72*Overheads!$D$9","v":239415.59162008358},{"$f":"D72*Overheads!$D$9","v":239415.59162008358},{"$f":"E72*Overheads!$D$9","v":239415.59162008358},{"$f":"F72*Overheads!$D$9","v":239415.59162008358}]
["Network overheads",{"$f":"(B73+B76+B77)*Overheads!$D$19","v":505876.55805994093},{"$f":"(C73+C76+C77)*Overheads!$D$19","v":506806.37830356578},{"$f":"(D73+D76+D77)*Overheads!$D$19","v":507610.90985298308},{"$f":"(E73+E76+E77)*Overheads!$D$19","v":508831.70338826062},{"$f":"(F73+F76+F77)*Overheads!$D$19","v":510291.38498719991}]
["Non-network overheads",{"$f":"B70*Overheads!$D$20","v":0},{"$f":"C70*Overheads!$D$20","v":0},{"$f":"D70*Overheads!$D$20","v":0},{"$f":"E70*Overheads!$D$20","v":0},{"$f":"F70*Overheads!$D$20","v":0}]
["Non-network depreciation",{"$f":"B70*Overheads!$D$25","v":0},{"$f":"C70*Overheads!$D$25","v":0},{"$f":"D70*Overheads!$D$25","v":0},{"$f":"E70*Overheads!$D$25","v":0},{"$f":"F70*Overheads!$D$25","v":0}]
["Corporate overheads",0,0,0,0,0,null,"No allocation of corporate overheads to capex"]
["Market",0,0,0,0,0,null,"No market allocation to capex"]
["Customer ops",0,0,0,0,0,null,"No customer operation allocation to capex"]
["Total",{"$f":"SUM(B76:B83)","v":745292.14968002448},{"$f":"SUM(C76:C83)","v":746221.96992364933},{"$f":"SUM(D76:D83)","v":747026.50147306663},{"$f":"SUM(E76:E83)","v":748247.29500834423},{"$f":"SUM(F76:F83)","v":749706.97660728346}]
[]
["Total Expenditure",{"$f":"B73+B84","v":4887903.3091677278},4896887.4602878643,4904661.0413326314,4916456.6477228105,{"$f":"F73+F84","v":4930560.449142565}]
[]
["Allocation of total Expenditure (Gross)"]
["LED",{"$f":"('ERG - Forecast capex scenarios'!F$141-'ERG - Forecast capex scenarios'!F$53)/'ERG - Forecast capex scenarios'!F$141","v":1},{"$f":"('ERG - Forecast capex scenarios'!G$141-'ERG - Forecast capex scenarios'!G$53)/'ERG - Forecast capex scenarios'!G$141","v":1},{"$f":"('ERG - Forecast capex scenarios'!H$141-'ERG - Forecast capex scenarios'!H$53)/'ERG - Forecast capex scenarios'!H$141","v":1},{"$f":"('ERG - Forecast capex scenarios'!I$141-'ERG - Forecast capex scenarios'!I$53)/'ERG - Forecast capex scenarios'!I$141","v":1},{"$f":"('ERG - Forecast capex scenarios'!J$141-'ERG - Forecast capex scenarios'!J$53)/'ERG - Forecast capex scenarios'!J$141","v":1}]
["CON ",{"$f":"1-B89","v":0},{"$f":"1-C89","v":0},0,0,0]
[]
["LED",{"$f":"B89*B86","v":4887903.3091677278},4896887.4602878643,4904661.0413326314,4916456.6477228105,4930560.449142565]
["CON",{"$f":"B90*B86","v":0},0,0,0,0]
[]
["Reconciliation",{"$f":"B56+B86","v":17701799.873782735},{"$f":"C56+C86","v":17920210.412451133},{"$f":"D56+D86","v":18136799.686913263},{"$f":"E56+E86","v":18376841.04117395},{"$f":"F56+F86","v":18635395.695778854}]
[null,{"$f":"B21-B95","v":0},{"$f":"C21-C95","v":0},{"$f":"D21-D95","v":0},{"$f":"E21-E95","v":0},{"$f":"F21-F95","v":0}]
[]
[null,15898742.466071833,16023159.327356923,16144687.72978086,16284614.254263382,16437667.839461189]

{"sheet":">>Forecast opex","index":16,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ERG - Opex BST","index":17,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Ergon Energy - Factors for the Base Step Trend Approach used to derive forecast opex"]
[]
["Table 1: Forecast Volume of LED and CONV Lights"]
["Volumes","2021-22","2022-23","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30"]
["Conventional",null,null,null,{"$f":"'ERG - Yearly volume scenarios'!K83","v":46985},{"$f":"'ERG - Yearly volume scenarios'!L83","v":35241},{"$f":"'ERG - Yearly volume scenarios'!M83","v":23493},{"$f":"'ERG - Yearly volume scenarios'!N83","v":11747},{"$f":"'ERG - Yearly volume scenarios'!O83","v":0}]
["LED",null,null,null,{"$f":"'ERG - Yearly volume scenarios'!K84+'ERG - Yearly volume scenarios'!K106","v":111068},{"$f":"'ERG - Yearly volume scenarios'!L84+'ERG - Yearly volume scenarios'!L106","v":123225},{"$f":"'ERG - Yearly volume scenarios'!M84+'ERG - Yearly volume scenarios'!M106","v":135392},{"$f":"'ERG - Yearly volume scenarios'!N84+'ERG - Yearly volume scenarios'!N106","v":147564},{"$f":"'ERG - Yearly volume scenarios'!O84+'ERG - Yearly volume scenarios'!O106","v":159744}]
["Total",null,null,null,{"$f":"SUM(E5:E6)","v":158053},{"$f":"SUM(F5:F6)","v":158466},{"$f":"SUM(G5:G6)","v":158885},{"$f":"SUM(H5:H6)","v":159311},{"$f":"SUM(I5:I6)","v":159744}]
[]
["Table 2: Base Step Trend approach"]
["2a: Forecast Price Change"]
["Rate","2021-22","2022-23","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30"]
["Labour",null,null,null,{"$f":"'Cost Escalations'!B29","v":1.1250515567042995E-2},{"$f":"'Cost Escalations'!C29","v":9.2135243940020661E-3},{"$f":"'Cost Escalations'!D29","v":9.1083556288052894E-3},{"$f":"'Cost Escalations'!E29","v":1.0777935799648537E-2},{"$f":"'Cost Escalations'!F29","v":1.2340188084018006E-2}]
["Contractor",null,null,null,{"$f":"'Cost Escalations'!B25","v":1.0500000000000001E-2},{"$f":"'Cost Escalations'!C25","v":7.1000000000000004E-3},{"$f":"'Cost Escalations'!D25","v":6.1000000000000004E-3},{"$f":"'Cost Escalations'!E25","v":9.1999999999999998E-3},{"$f":"'Cost Escalations'!F25","v":1.09E-2}]
["Materials/other",null,null,null,0,0,0,0,0]
[]
["2b: Weights"]
["Rate","2021-22","2022-23","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30"]
["Labour",null,null,null,{"$f":"SUM('ERG - Forecast opex'!C4,'ERG - Forecast opex'!C9)/(SUM('ERG - Forecast opex'!C3:C11)-'ERG - Forecast opex'!C16)","v":0.17779445686468556},{"$f":"E18","v":0.17779445686468556},0.17779445686468556,0.17779445686468556,0.17779445686468556]
["Contractor",null,null,null,{"$f":"SUM('ERG - Forecast opex'!C5,'ERG - Forecast opex'!C10)/(SUM('ERG - Forecast opex'!C3:C11)-'ERG - Forecast opex'!C16)","v":0.64800135479388909},0.64800135479388909,0.64800135479388909,0.64800135479388909,0.64800135479388909]
["Materials/other",null,null,null,{"$f":"(SUM('ERG - Forecast opex'!C6,'ERG - Forecast opex'!C7,'ERG - Forecast opex'!C11)-'ERG - Forecast opex'!C16)/(SUM('ERG - Forecast opex'!C3:C11)-'ERG - Forecast opex'!C16)","v":0.17420418834142529},0.17420418834142529,0.17420418834142529,0.17420418834142529,0.17420418834142529]
[]
["2c: Price Change"]
["Rate","2021-22","2022-23","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30"]
["Rate",null,null,null,{"$f":"SUMPRODUCT(E12:E14,E18:E20)","v":8.8042935300259341E-3},{"$f":"SUMPRODUCT(F12:F14,F18:F20)","v":6.2389231844777408E-3},{"$f":"SUMPRODUCT(G12:G14,G18:G20)","v":5.5722234061965619E-3},{"$f":"SUMPRODUCT(H12:H14,H18:H20)","v":7.8778697057247417E-3},{"$f":"SUMPRODUCT(I12:I14,I18:I20)","v":9.2572318052594367E-3}]
[]
["2d: Forecast Output Growth"]
["Rate","2021-22","2022-23","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30"]
["Light Population",null,null,{"$f":"'ERG - Yearly volume scenarios'!J85+'ERG - Yearly volume scenarios'!J106","v":157986.6},{"$f":"'ERG - Yearly volume scenarios'!K85+'ERG - Yearly volume scenarios'!K106","v":158053},{"$f":"'ERG - Yearly volume scenarios'!L85+'ERG - Yearly volume scenarios'!L106","v":158466},{"$f":"'ERG - Yearly volume scenarios'!M85+'ERG - Yearly volume scenarios'!M106","v":158885},{"$f":"'ERG - Yearly volume scenarios'!N85+'ERG - Yearly volume scenarios'!N106","v":159311},{"$f":"'ERG - Yearly volume scenarios'!O85+'ERG - Yearly volume scenarios'!O106","v":159744}]
["Growth Rate",null,null,null,{"$f":"LN(E28)-LN(D28)","v":4.202005127016406E-4},{"$f":"LN(F28)-LN(E28)","v":2.6096394490373598E-3},{"$f":"LN(G28)-LN(F28)","v":2.6406108281857854E-3},{"$f":"LN(H28)-LN(G28)","v":2.6775965412380032E-3},{"$f":"LN(I28)-LN(H28)","v":2.7142672318873906E-3}]
["Factor",null,null,{"$f":"1-(SUM('ERG - Forecast opex'!C4:C7)/SUM('ERG - Forecast opex'!C3:C12))","v":0.27423964759334063},{"$f":"SUMPRODUCT($D$30,E29)","v":1.1523564052183897E-4},{"$f":"SUMPRODUCT($D$30,F29)","v":7.156666028496851E-4},{"$f":"SUMPRODUCT($D$30,G29)","v":7.2416018295282916E-4},{"$f":"SUMPRODUCT($D$30,H29)","v":7.3430313186625777E-4},{"$f":"SUMPRODUCT($D$30,I29)","v":7.4435968914695022E-4}]
[]
["2e: Productivity Factor"]
["Rate","2021-22","2022-23","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30"]
["Rate",null,null,0.04,{"$f":"D34","v":0.04},{"$f":"E34","v":0.04},0.04,0.04,0.04]
[]
["2f: Forecast Rate of Change"]
["Rate","2021-22","2022-23","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30"]
["Rate of Change - year on year",null,null,null,{"$f":"(1+E24)*(1+E30)*(1-E34)-1","v":-3.1436278010606222E-2},{"$f":"(1+F24)*(1+F30)*(1-F34)-1","v":-3.3319307414763411E-2},{"$f":"(1+G24)*(1+G30)*(1-G34)-1","v":-3.3951597979388071E-2},{"$f":"(1+H24)*(1+H30)*(1-H34)-1","v":-3.1726760721291325E-2},{"$f":"(1+I24)*(1+I30)*(1-I34)-1","v":-3.0391857083588492E-2}]
["Rate of Change - Cummulative",null,null,null,{"$f":"PRODUCT(1+$D38:E38)-1","v":-3.1436278010606222E-2},{"$f":"PRODUCT(1+$D38:F38)-1","v":-6.3708150414358289E-2},{"$f":"PRODUCT(1+$D38:G38)-1","v":-9.5496754882867685E-2},{"$f":"PRODUCT(1+$D38:H38)-1","v":-0.1241937129123305},{"$f":"PRODUCT(1+$D38:I38)-1","v":-0.1508110924224072}]

{"sheet":"ERG - Forecast opex","index":18,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Table 1 - Opex Direct Costs","Actual"]
["Opex Direct Costs","2022-23","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30"]
["Maintenance"]
["   Labour",68437.169999999984,{"$f":"B4*'Cost Escalations'!$E$21","v":75185.733880288695}]
["   Contractor",4774784.0299999993,{"$f":"B5*'Cost Escalations'!$E$21","v":5245623.7073425511}]
["   Materials",303078.30000000005,{"$f":"B6*'Cost Escalations'!$E$21","v":332964.73844097165}]
["   Other",458593.18,{"$f":"B7*'Cost Escalations'!$E$21","v":503814.88291808881}]
["Damage/Emergency"]
["   Labour",1332665.0599999998,{"$f":"B9*'Cost Escalations'!$E$21","v":1464078.6659167667}]
["   Contractor",331765.18000000005,{"$f":"B10*'Cost Escalations'!$E$21","v":364480.42100843863}]
["   Materials",401137.78,{"$f":"B11*'Cost Escalations'!$E$21","v":440693.82729311869}]
["  Other",52326.39,{"$f":"B12*'Cost Escalations'!$E$21","v":57486.275856470987}]
["Total direct opex",{"$f":"SUM(B4:B12)","v":7722787.089999998},{"$f":"SUM(C4:C12)","v":8484328.2526566964}]
[]
["Adjustments (material costs)"]
["LED Lamps ",-210000,{"$f":"B16*'Cost Escalations'!$E$21","v":-230708.0218960052}]
["Overheads & Oncosts"]
["Base Opex",null,{"$f":"C13+C16+C17","v":8253620.2307606908}]
["Notes: "]
["Material costs removed to reflect the fact that, upon failure, the LED luminaire is replaced and becomes capex"]
[]
["Overheads & Oncosts"]
["Labour oncost",null,0]
["Fleet oncost",null,{"$f":"(C4+C9)*Overheads!D15","v":325770.44844469323}]
["Material oncosts",null,{"$f":"(C6+C11+C16)*Overheads!D9","v":43212.185540300721}]
["Network overheads",null,{"$f":"(C18+C23+C24+C25)*Overheads!D19","v":995423.55774816207}]
["Non-network overheads",null,{"$f":"(C4+C9)*Overheads!D20","v":544931.10507440881}]
["Non-network depreciation",null,{"$f":"(C4+C9)*Overheads!D25","v":212140.52030715893}]
["Corporate overheads",null,{"$f":"C18*Overheads!D26","v":443948.46182388224}]
["Market",null,{"$f":"C18*Overheads!D27","v":23362.27664438152}]
["Customer ops",null,{"$f":"C18*Overheads!D28","v":235923.85515330167}]
["Total",null,{"$f":"SUM(C23:C31)","v":2824712.4107362893}]
["Base Opex (Gross)",null,{"$f":"C18+C32","v":11078332.641496981}]
[]
["Table 2 - Forecast Opex "]
["Forecast opex","2022-23","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30"]
["Conventional",null,null,{"$f":"D39/('ERG - Opex BST'!E5+'ERG - Opex BST'!E6/0.55)*'ERG - Opex BST'!E5","v":2025303.6380736744},{"$f":"E39/('ERG - Opex BST'!F5+'ERG - Opex BST'!F6/0.55)*'ERG - Opex BST'!F5","v":1409788.7426503436},{"$f":"F39/('ERG - Opex BST'!G5+'ERG - Opex BST'!G6/0.55)*'ERG - Opex BST'!G5","v":872983.50915879477},{"$f":"G39/('ERG - Opex BST'!H5+'ERG - Opex BST'!H6/0.55)*'ERG - Opex BST'!H5","v":406987.73687117209},{"$f":"H39/('ERG - Opex BST'!I5+'ERG - Opex BST'!I6/0.55)*'ERG - Opex BST'!I5","v":0}]
["LED ",null,null,{"$f":"D39-D37","v":8704767.458611235},{"$f":"E39-E37","v":8962763.8165818527},9147404.315562278,9295485.6410004329,9407597.1936140098]
["Total ",null,{"$f":"C33","v":11078332.641496981},{"$f":"C39*(1+'ERG - Opex BST'!E39)","v":10730071.096684908},{"$f":"$C$39*(1+'ERG - Opex BST'!F39)","v":10372552.559232196},{"$f":"$C$39*(1+'ERG - Opex BST'!G39)","v":10020387.824721072},{"$f":"$C$39*(1+'ERG - Opex BST'!H39)","v":9702473.3778716046},{"$f":"$C$39*(1+'ERG - Opex BST'!I39)","v":9407597.1936140098}]