{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["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":2,"defined_names":13,"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":"Cover page","index":0,"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":1,"n_rows":5,"n_cols":4,"rows_kept":5,"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"]

{"sheet":"Intro","index":2,"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":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Cost Escalations","index":4,"n_rows":30,"n_cols":7,"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,6.25E-2,3.499999999999992E-2,2.7498479316033997E-2]
[]
["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.1711647727272725,1.2121555397727268,{"$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.2454879738109832}]
["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.1277882996632997,1.1672608901515151,{"$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.199358789595762}]
["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.0625,{"$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.0996874999999999},{"$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.129927233972851}]
["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.85385081867798673},0.8866912347809861,0.94117647058823528,1,1.0349999999999999,{"$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.0634609260920951}]
["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.8249766364038521},0.85670650703476936,0.90934924694515495,0.96618357487922713,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.027498479316034}]
["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.8028981580128538},0.83377885639796345,0.88501274235507732,0.94032603875226961,0.97323745010859897,{"$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.88012927848236311,0.83928956646895181,0.81386253247848483]
["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.91398040457783847,0.87156993441006514,0.84516493757381084]
["2022-06-01",1.100350715823996,1.0816676818608599,1.0302658935671953,0.97014250014533188,0.92512599940327622,0.8970984733001478]
["2023-06-01",1.1691226355629958,1.1492719119771637,1.0946575119151452,1.0307764064044151,0.98294637436598098,0.95316712788140712]
["2024-06-01",1.2100419278077004,1.1894964288963641,1.1329705248321751,1.0668535806285695,1.0173494974687902,0.98652797735725617]
["2025-06-01",1.2433162407310545,1.2222057718428672,1.1641254913749488,1.096190431748721,1.0453250615821132,1.0136559965373035]
[]
["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.1599999999999999E-2,8.6E-3,6.1000000000000004E-3,8.9999999999999993E-3,1.0500000000000001E-2,"Source: BISOE report"]
["Escalation - Cumulative",{"$f":"PRODUCT(1+$B29:B29)-1","v":1.1600000000000055E-2},{"$f":"PRODUCT(1+$B29:C29)-1","v":2.0299759999999889E-2},{"$f":"PRODUCT(1+$B29:D29)-1","v":2.6523588535999787E-2},{"$f":"PRODUCT(1+$B29:E29)-1","v":3.5762300832823612E-2},{"$f":"PRODUCT(1+$B29:F29)-1","v":4.663780499156811E-2}]

{"sheet":"Ratios & Assumptions","index":5,"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":{"$error":"#REF!"}},{"$f":"C4/$C$6","v":{"$error":"#REF!"}}]
["Ergon","Minor",{"$f":"SUMIF('ERG - Yearly volume scenarios'!$C$5:$C$12,'Ratios & Assumptions'!$B5,'ERG - Yearly volume scenarios'!$G$5:$G$12)","v":{"$error":"#REF!"}},{"$f":"C5/$C$6","v":{"$error":"#REF!"}}]
["Ergon","All",{"$f":"SUM(C4:C5)","v":{"$error":"#REF!"}},{"$f":"SUM(D4:D5)","v":{"$error":"#REF!"}}]
["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":6,"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":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ERG - Yearly volume scenarios","index":8,"n_rows":110,"n_cols":16,"rows_kept":110,"cut":false,"hidden":false,"merged":[[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],[97,0,97,3],[100,0,100,3],[70,10,70,14],[71,10,71,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","Forecast","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","CONV",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},23678,20420,16465,14454,10371,7077,3972,0]
["Ergon Energy",1,"Major","LED",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},5151,8457,12461,14328,18411,21705,24810,28782]
["Ergon Energy",1,"Minor","CONV",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},47430,40904,32981,28953,20775,14177,7957,0,"Removes the Nostalgia  as these are to be converted to LED (see Table 3 below)"]
["Ergon Energy",1,"Minor","LED",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},24036,30687,38737,42390,50568,57166,63386,71343]
["Ergon Energy",2,"Major","CONV",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},12445,12226,11325,9942,7134,4868,2732,0]
["Ergon Energy","2A","Major","LED",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},1194,1413,2314,3697,6505,8771,10907,13639]
["Ergon Energy",2,"Minor","CONV",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},29121,28608,26500,21781,15629,10665,5986,0,"Removes the Nostalgia  as these are to be converted to LED (see Table 3 below)"]
["Ergon Energy","2A","Minor","LED",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},7269,7782,9890,14609,20761,25725,30404,36390]
["Ergon Energy","All","All","CONV",{"$f":"E5+E7+E9+E11","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},112674,102158,87271,75130,53909,36787,20647,0]
["Ergon Energy","All","All","LED",{"$f":"E6+E8+E10+E12","v":{"$error":"#REF!"}},{"$f":"F6+F8+F10+F12","v":{"$error":"#REF!"}},{"$error":"#REF!"},37650,48339,63402,75024,96245,113367,129507,150154]
["Ergon Energy","All","All","All",{"$f":"E13+E14","v":{"$error":"#REF!"}},{"$f":"F13+F14","v":{"$error":"#REF!"}},{"$error":"#REF!"},150324,150497,150673,{"$f":"SUM(K5:K12)","v":150154},{"$f":"SUM(L5:L12)","v":150154},{"$f":"SUM(M5:M12)","v":150154},{"$f":"SUM(N5:N12)","v":150154},{"$f":"SUM(O5:O12)","v":150154}]
["Ergon Energy","All","All","LED",{"$f":"E14/E15","v":{"$error":"#REF!"}},{"$f":"F14/F15","v":{"$error":"#REF!"}},{"$error":"#REF!"},0.25045900854155023,0.32119577134427929,0.42079204635203388,0.49964702905017516,0.64097526539419525,0.75500486167534664,0.86249450564087538,{"$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","Forecast","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":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},3306,4004,1867,4083,3294,3105,3972]
["Ergon Energy",1,"Minor","LED",null,{"$f":"F8-E8","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},6651,8050,3653,8178,6598,6220,7957]
["Ergon Energy","2A","Major","LED",null,{"$f":"F10-E10","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},219,901,1383,2808,2266,2136,2732]
["Ergon Energy","2A","Minor","LED",null,{"$f":"F12-E12","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},513,2108,4719,6152,4964,4679,5986]
["Ergon Energy","All","All","LED",null,{"$f":"SUM(F27:F30)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},10689,15063,11622,21221,17122,16140,20647]
[null,null,null,"Total LED volume",null,null,null,null,null,null,{"$f":"J14+K31","v":75024},{"$f":"K14+L31","v":96245},{"$f":"L14+M31","v":113367},{"$f":"M14+N31","v":129507},{"$f":"N14+O31","v":150154}]
[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":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},0.9315183833847881,0.80023899621589323,{"$f":"SUM(K27:K28)/SUM(K27:K30)","v":0.47496128033040785},0.57777673059705004,0.57773624576568161,0.57775712515489464,0.57775948079624162]
[null,null,null,null,"Rate2A",{"$f":"1-F34","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},6.8481616615211904E-2,0.19976100378410677,{"$f":"1-K34","v":0.52503871966959215},0.42222326940294996,{"$f":"1-M34","v":0.42226375423431839},{"$f":"1-N34","v":0.42224287484510536},{"$f":"1-O34","v":0.42224051920375838}]
[]
[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":3264},3264,3264,3264,3264]
["Ergon Energy",1,"Minor","LED",null,null,null,null,null,null,6521,6521,6521,6521,6521]
["Ergon Energy","2A","Major","LED",null,null,null,null,null,null,2265,2265,2265,2265,2265]
["Ergon Energy","2A","Minor","LED",null,null,null,null,null,null,5300,5300,5300,5300,5300]
["Ergon Energy","All","All","LED",null,null,null,null,null,null,{"$f":"SUM(K41:K44)","v":17350},{"$f":"SUM(L41:L44)","v":17350},{"$f":"SUM(M41:M44)","v":17350},{"$f":"SUM(N41:N44)","v":17350},{"$f":"SUM(O41:O44)","v":17350}]
["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 ","Forecast ","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",47.107851658699111,31.990686402623016,59.028170010136485,{"$f":"ROUND(AVERAGE(E54:G54)*(1+'Ratios & Assumptions'!$D$13),0)","v":47},{"$f":"ROUND(H54*(1+'Ratios & Assumptions'!$D$13),0)","v":48},{"$f":"ROUND(I54*(1+'Ratios & Assumptions'!$D$13),0)","v":49},{"$f":"ROUND(J54*(1+'Ratios & Assumptions'!$D$13),0)","v":50},{"$f":"ROUND(K54*(1+'Ratios & Assumptions'!$D$13),0)","v":51},{"$f":"ROUND(L54*(1+'Ratios & Assumptions'!$D$13),0)","v":52},{"$f":"ROUND(M54*(1+'Ratios & Assumptions'!$D$13),0)","v":53},{"$f":"ROUND(N54*(1+'Ratios & Assumptions'!$D$13),0)","v":54}]
["Ergon Energy",1,"Minor","LED",113.33549093332064,133.08515580736542,116.52212665460117,{"$f":"ROUND(AVERAGE(E55:G55)*(1+'Ratios & Assumptions'!$D$14),0)","v":123},{"$f":"ROUND(H55*(1+'Ratios & Assumptions'!$D$14),0)","v":125},{"$f":"ROUND(I55*(1+'Ratios & Assumptions'!$D$14),0)","v":127},{"$f":"ROUND(J55*(1+'Ratios & Assumptions'!$D$14),0)","v":129},{"$f":"ROUND(K55*(1+'Ratios & Assumptions'!$D$14),0)","v":131},{"$f":"ROUND(L55*(1+'Ratios & Assumptions'!$D$14),0)","v":133},{"$f":"ROUND(M55*(1+'Ratios & Assumptions'!$D$14),0)","v":135},{"$f":"ROUND(N55*(1+'Ratios & Assumptions'!$D$14),0)","v":137}]
["Ergon Energy","All","All","LED",{"$f":"SUM(E54:E55)","v":160.44334259201975},165.07584220998845,175.55029666473766,170,173,176,179,182,185,188,191]
["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 ","Forecast ","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,"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 ","Forecast ","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","CONV",null,{"$f":"F5","v":{"$error":"#REF!"}},{"$error":"#REF!"},23678,20420,16465,14454,10371,7077,3972,0]
["Ergon Energy",1,"Major","LED",null,{"$f":"F6+F54","v":{"$error":"#REF!"}},{"$f":"G6+G54","v":{"$error":"#REF!"}},{"$f":"H6+H54","v":5198},{"$f":"I6+SUM(H54:I54)","v":8552},{"$f":"J6+SUM(H54:J54)","v":12605},{"$f":"K6+K54","v":14378},{"$f":"L6+SUM(K54:L54)","v":18512},{"$f":"M6+SUM(K54:M54)","v":21858},{"$f":"N6+SUM(K54:N54)","v":25016},{"$f":"O6+SUM(K54:O54)","v":29042}]
["Ergon Energy",1,"Minor","CONV",null,{"$f":"F7","v":{"$error":"#REF!"}},{"$error":"#REF!"},47430,40904,32981,28953,20775,14177,7957,0]
["Ergon Energy",1,"Minor","LED",null,{"$f":"F8+F55","v":{"$error":"#REF!"}},{"$f":"G8+G55","v":{"$error":"#REF!"}},{"$f":"H8+H55","v":24159},{"$f":"I8+SUM(H55:I55)","v":30935},{"$f":"J8+SUM(H55:J55)","v":39112},{"$f":"K8+K55+K64","v":42519},{"$f":"L8+SUM(K55:L55)+L64","v":50828},{"$f":"M8+SUM(K55:M55)+M64","v":57559},{"$f":"N8+SUM(K55:N55)+N64","v":63914},{"$f":"O8+SUM(K55:O55)+O64","v":72008}]
["Ergon Energy",2,"Major","CONV",null,{"$f":"F9","v":{"$error":"#REF!"}},{"$error":"#REF!"},12445,12226,11325,9942,7134,4868,2732,0]
["Ergon Energy","2A","Major","LED",null,{"$f":"F10","v":{"$error":"#REF!"}},{"$error":"#REF!"},1194,{"$f":"I10","v":1413},2314,{"$f":"K10","v":3697},6505,8771,10907,13639]
["Ergon Energy",2,"Minor","CONV",null,{"$error":"#REF!"},{"$error":"#REF!"},29121,{"$f":"I11","v":28608},{"$f":"J11","v":26500},{"$f":"K11","v":21781},{"$f":"L11","v":15629},{"$f":"M11","v":10665},{"$f":"N11","v":5986},0]
["Ergon Energy","2A","Minor","LED",null,{"$error":"#REF!"},{"$error":"#REF!"},7269,{"$f":"I12","v":7782},9890,{"$f":"K12+K65","v":16092},{"$f":"L12+L65","v":22244},{"$f":"M12+M65","v":27208},31887,37873]
["Ergon Energy","All","All","CONV",null,{"$f":"SUMIF($D$75:$D$82,$D83,F$75:F$82)","v":{"$error":"#REF!"}},{"$error":"#REF!"},112674,102158,87271,75130,53909,36787,20647,0]
["Ergon Energy","All","All","LED",null,{"$error":"#REF!"},{"$error":"#REF!"},37820,48682,63921,76686,98089,115396,131724,{"$f":"SUMIF($D$75:$D$82,$D84,O$75:O$82)","v":152562}]
["Ergon Energy","All","All","All",null,{"$f":"SUM(F83:F84)","v":{"$error":"#REF!"}},{"$f":"SUM(G83:G84)","v":{"$error":"#REF!"}},150494,150840,151192,151816,151998,152183,152371,152562]
[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":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},0.9326090959307678,0.80254609882538219,0.40579710144927539,0.58136709807036402,0.58224995666493329,0.58261881430671236,0.58162971494385263]
[null,null,"Rate2A",null,null,{"$f":"1-F87","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},6.7390904069232205E-2,0.19745390117461781,{"$f":"1-K87","v":0.59420289855072461},{"$f":"1-L87","v":0.41863290192963598},0.41775004333506671,0.41738118569328764,0.41837028505614737]
["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","Forecast","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"]
["New installations and new subdivisions"]
["Ergon Energy",2,"Major","LED ",null,{"$f":"ROUND(F80*'Ratios & Assumptions'!$C$21,0)","v":{"$error":"#REF!"}},{"$f":"ROUND(G80*'Ratios & Assumptions'!$C$21,0)","v":{"$error":"#REF!"}},{"$f":"ROUND(H80*'Ratios & Assumptions'!$C$21,0)","v":73},{"$f":"ROUND(I80*'Ratios & Assumptions'!$C$21,0)","v":86},{"$f":"ROUND(J80*'Ratios & Assumptions'!$C$21,0)","v":141},{"$f":"ROUND(J99*(1+'Ratios & Assumptions'!$D$13),0)","v":145},{"$f":"ROUND(K99*(1+'Ratios & Assumptions'!$D$13),0)","v":149},{"$f":"ROUND(L99*(1+'Ratios & Assumptions'!$D$13),0)","v":153},{"$f":"ROUND(M99*(1+'Ratios & Assumptions'!$D$13),0)","v":157},{"$f":"ROUND(N99*(1+'Ratios & Assumptions'!$D$13),0)","v":161}]
["Ergon Energy",2,"Minor ","LED ",null,{"$f":"ROUND(F82*'Ratios & Assumptions'!$C$22,0)","v":{"$error":"#REF!"}},{"$f":"ROUND(G82*'Ratios & Assumptions'!$C$22,0)","v":{"$error":"#REF!"}},{"$f":"ROUND(H82*'Ratios & Assumptions'!$C$22,0)","v":296},{"$f":"ROUND(I82*'Ratios & Assumptions'!$C$22,0)","v":317},{"$f":"ROUND(J82*'Ratios & Assumptions'!$C$22,0)","v":403},{"$f":"ROUND(J100*(1+'Ratios & Assumptions'!$D$13),0)","v":413},{"$f":"ROUND(K100*(1+'Ratios & Assumptions'!$D$13),0)","v":423},{"$f":"ROUND(L100*(1+'Ratios & Assumptions'!$D$13),0)","v":434},{"$f":"ROUND(M100*(1+'Ratios & Assumptions'!$D$13),0)","v":445},{"$f":"ROUND(N100*(1+'Ratios & Assumptions'!$D$13),0)","v":456}]
["Rate 4 reassigned to Rate 2 on 1 July 2025"]
["Ergon Energy",4,"Major","LED ",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},35,36,39,{"$f":"$J$102","v":39},{"$f":"$J$102","v":39},39,39,39]
["Ergon Energy",4,"Minor ","LED ",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},18,18,19,{"$f":"$J$103","v":19},{"$f":"$J$103","v":19},19,19,19]
["All",2,"Major","LED ",null,{"$f":"F99","v":{"$error":"#REF!"}},{"$f":"G99","v":{"$error":"#REF!"}},73,86,141,{"$f":"K99+K102","v":184},{"$f":"L99+L102","v":188},192,196,200]
[null,2,"Minor","LED ",null,{"$f":"F100","v":{"$error":"#REF!"}},{"$f":"G100","v":{"$error":"#REF!"}},296,317,403,{"$f":"K100+K103","v":432},{"$f":"L100+L103","v":442},453,464,475]
["All",2,"All","LED ",null,{"$f":"F104+F105","v":{"$error":"#REF!"}},{"$error":"#REF!"},369,403,544,616,630,645,660,675]
["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":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ERG Unit Rates","index":10,"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":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ERG - Forecast capex scenarios","index":12,"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":1906176},{"$f":"'ERG Unit Rates'!$D24*'ERG - Yearly volume scenarios'!L$41","v":1906176},{"$f":"'ERG Unit Rates'!$D24*'ERG - Yearly volume scenarios'!M$41","v":1906176},{"$f":"'ERG Unit Rates'!$D24*'ERG - Yearly volume scenarios'!N$41","v":1906176},{"$f":"'ERG Unit Rates'!$D24*'ERG - Yearly volume scenarios'!O$41","v":1906176}]
[null,1,"Major","LED","Contractor",{"$f":"'ERG Unit Rates'!$D25*'ERG - Yearly volume scenarios'!K$41","v":408000},{"$f":"'ERG Unit Rates'!$D25*'ERG - Yearly volume scenarios'!L$41","v":408000},{"$f":"'ERG Unit Rates'!$D25*'ERG - Yearly volume scenarios'!M$41","v":408000},{"$f":"'ERG Unit Rates'!$D25*'ERG - Yearly volume scenarios'!N$41","v":408000},{"$f":"'ERG Unit Rates'!$D25*'ERG - Yearly volume scenarios'!O$41","v":408000}]
["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":1284637},{"$f":"'ERG Unit Rates'!$D27*'ERG - Yearly volume scenarios'!L$42","v":1284637},{"$f":"'ERG Unit Rates'!$D27*'ERG - Yearly volume scenarios'!M$42","v":1284637},{"$f":"'ERG Unit Rates'!$D27*'ERG - Yearly volume scenarios'!N$42","v":1284637},{"$f":"'ERG Unit Rates'!$D27*'ERG - Yearly volume scenarios'!O$42","v":1284637}]
[null,1,"Minor","LED","Contractor",{"$f":"'ERG Unit Rates'!$D28*'ERG - Yearly volume scenarios'!K$42","v":815125},{"$f":"'ERG Unit Rates'!$D28*'ERG - Yearly volume scenarios'!L$42","v":815125},{"$f":"'ERG Unit Rates'!$D28*'ERG - Yearly volume scenarios'!M$42","v":815125},{"$f":"'ERG Unit Rates'!$D28*'ERG - Yearly volume scenarios'!N$42","v":815125},{"$f":"'ERG Unit Rates'!$D28*'ERG - Yearly volume scenarios'!O$42","v":815125}]
["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":1322760},{"$f":"'ERG Unit Rates'!$D24*'ERG - Yearly volume scenarios'!L$43","v":1322760},{"$f":"'ERG Unit Rates'!$D24*'ERG - Yearly volume scenarios'!M$43","v":1322760},{"$f":"'ERG Unit Rates'!$D24*'ERG - Yearly volume scenarios'!N$43","v":1322760},{"$f":"'ERG Unit Rates'!$D24*'ERG - Yearly volume scenarios'!O$43","v":1322760}]
[null,"2A","Major","LED","Contractor",{"$f":"'ERG Unit Rates'!$D25*'ERG - Yearly volume scenarios'!K$43","v":283125},{"$f":"'ERG Unit Rates'!$D25*'ERG - Yearly volume scenarios'!L$43","v":283125},{"$f":"'ERG Unit Rates'!$D25*'ERG - Yearly volume scenarios'!M$43","v":283125},{"$f":"'ERG Unit Rates'!$D25*'ERG - Yearly volume scenarios'!N$43","v":283125},{"$f":"'ERG Unit Rates'!$D25*'ERG - Yearly volume scenarios'!O$43","v":283125}]
["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":1044100},{"$f":"'ERG Unit Rates'!$D27*'ERG - Yearly volume scenarios'!L$44","v":1044100},{"$f":"'ERG Unit Rates'!$D27*'ERG - Yearly volume scenarios'!M$44","v":1044100},{"$f":"'ERG Unit Rates'!$D27*'ERG - Yearly volume scenarios'!N$44","v":1044100},{"$f":"'ERG Unit Rates'!$D27*'ERG - Yearly volume scenarios'!O$44","v":1044100}]
[null,"2A","Minor","LED","Contractor",{"$f":"'ERG Unit Rates'!$D28*'ERG - Yearly volume scenarios'!K$44","v":662500},{"$f":"'ERG Unit Rates'!$D28*'ERG - Yearly volume scenarios'!L$44","v":662500},{"$f":"'ERG Unit Rates'!$D28*'ERG - Yearly volume scenarios'!M$44","v":662500},{"$f":"'ERG Unit Rates'!$D28*'ERG - Yearly volume scenarios'!N$44","v":662500},{"$f":"'ERG Unit Rates'!$D28*'ERG - Yearly volume scenarios'!O$44","v":662500}]
["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":3190813},3190813,3190813,3190813,3190813]
[null,1,"All","LED","Contractor",1223125,1223125,1223125,1223125,1223125]
["Ergon Energy","2A","All","LED","Labour",0,0,0,0,0]
[null,"2A","All","LED","Material",2366860,2366860,2366860,2366860,2366860]
[null,"2A","All","LED","Contractor",945625,945625,945625,945625,945625]
["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":5557673},5557673,5557673,5557673,5557673]
[null,"All","All","LED","Contractor",2168750,2168750,2168750,2168750,2168750]
["Ergon Energy","All","All","LED","All",{"$f":"SUM(F23:F25)","v":7726423},7726423,7726423,7726423,7726423]
[]
["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":737274.30493652169},{"$f":"'ERG - Yearly volume scenarios'!L$54*'ERG Unit Rates'!$D11","v":752019.79103525216},{"$f":"'ERG - Yearly volume scenarios'!M$54*'ERG Unit Rates'!$D11","v":766765.27713398263},{"$f":"'ERG - Yearly volume scenarios'!N$54*'ERG Unit Rates'!$D11","v":781510.76323271298},{"$f":"'ERG - Yearly volume scenarios'!O$54*'ERG Unit Rates'!$D11","v":796256.24933144345}]
[null,1,"Major","LED","Material",{"$f":"'ERG - Yearly volume scenarios'!K$54*'ERG Unit Rates'!$D12","v":466510.25079861103},{"$f":"'ERG - Yearly volume scenarios'!L$54*'ERG Unit Rates'!$D12","v":475840.45581458323},{"$f":"'ERG - Yearly volume scenarios'!M$54*'ERG Unit Rates'!$D12","v":485170.66083055548},{"$f":"'ERG - Yearly volume scenarios'!N$54*'ERG Unit Rates'!$D12","v":494500.86584652768},{"$f":"'ERG - Yearly volume scenarios'!O$54*'ERG Unit Rates'!$D12","v":503831.07086249988}]
[null,1,"Major","LED","Contractor",{"$f":"'ERG - Yearly volume scenarios'!K$54*'ERG Unit Rates'!$D13","v":388458.2949689696},{"$f":"'ERG - Yearly volume scenarios'!L$54*'ERG Unit Rates'!$D13","v":396227.46086834895},{"$f":"'ERG - Yearly volume scenarios'!M$54*'ERG Unit Rates'!$D13","v":403996.62676772836},{"$f":"'ERG - Yearly volume scenarios'!N$54*'ERG Unit Rates'!$D13","v":411765.79266710777},{"$f":"'ERG - Yearly volume scenarios'!O$54*'ERG Unit Rates'!$D13","v":419534.95856648713}]
["Ergon Energy",1,"Minor","LED","Labour",{"$f":"'ERG - Yearly volume scenarios'!K$55*'ERG Unit Rates'!$D14","v":446249.80368444911},{"$f":"'ERG - Yearly volume scenarios'!L$55*'ERG Unit Rates'!$D14","v":453168.40529195993},{"$f":"'ERG - Yearly volume scenarios'!M$55*'ERG Unit Rates'!$D14","v":460087.00689947081},{"$f":"'ERG - Yearly volume scenarios'!N$55*'ERG Unit Rates'!$D14","v":467005.60850698163},{"$f":"'ERG - Yearly volume scenarios'!O$55*'ERG Unit Rates'!$D14","v":473924.21011449245}]
[null,1,"Minor","LED","Material",{"$f":"'ERG - Yearly volume scenarios'!K$55*'ERG Unit Rates'!$D15","v":113876.00263128222},{"$f":"'ERG - Yearly volume scenarios'!L$55*'ERG Unit Rates'!$D15","v":115641.52205192225},{"$f":"'ERG - Yearly volume scenarios'!M$55*'ERG Unit Rates'!$D15","v":117407.04147256228},{"$f":"'ERG - Yearly volume scenarios'!N$55*'ERG Unit Rates'!$D15","v":119172.56089320232},{"$f":"'ERG - Yearly volume scenarios'!O$55*'ERG Unit Rates'!$D15","v":120938.08031384235}]
[null,1,"Minor","LED","Contractor",{"$f":"'ERG - Yearly volume scenarios'!K$55*'ERG Unit Rates'!$D16","v":235122.03898713607},{"$f":"'ERG - Yearly volume scenarios'!L$55*'ERG Unit Rates'!$D16","v":238767.34191716919},{"$f":"'ERG - Yearly volume scenarios'!M$55*'ERG Unit Rates'!$D16","v":242412.64484720229},{"$f":"'ERG - Yearly volume scenarios'!N$55*'ERG Unit Rates'!$D16","v":246057.94777723541},{"$f":"'ERG - Yearly volume scenarios'!O$55*'ERG Unit Rates'!$D16","v":249703.25070726854}]
["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":1183524.1086209707},1205188.196327212,1226852.2840334536,1248516.3717396946,1270180.4594459359]
[null,1,"All","LED","Material",{"$f":"SUMIFS(F$61:F$72,$B$61:$B$72,$B74,$E$61:$E$72,$E74)","v":580386.25342989329},591481.97786650551,602577.70230311772,613673.42673972994,624769.15117634227]
[null,1,"All","LED","Contractor",623580.33395610563,634994.80278551811,646409.27161493059,657823.74044434319,669238.20927375567]
["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":1183524.1086209707},1205188.196327212,1226852.2840334536,1248516.3717396946,1270180.4594459359]
[null,"All","All","All","Material",{"$f":"SUMIF($E$61:$E$72,$E80,F$61:F$72)","v":580386.25342989329},591481.97786650551,602577.70230311772,613673.42673972994,624769.15117634227]
[null,"All","All","All","Contractor",623580.33395610563,634994.80278551811,646409.27161493059,657823.74044434319,669238.20927375567]
["Ergon Energy","All","All","All","All",{"$f":"SUM(F79:F81)","v":2387490.6960069695},2431664.9769792357,2475839.2579515018,2520013.5389237679,2564187.819896034]
[]
[]
["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":737274.30493652169},752019.79103525216,766765.27713398263,781510.76323271298,796256.24933144345]
[null,1,"Major","All","Material",2372686.250798611,2382016.4558145832,2391346.6608305555,2400676.8658465277,2410007.0708625]
[null,1,"Major","All","Contractor",796458.29496896965,804227.46086834895,811996.62676772836,819765.79266710777,827534.95856648707]
["Ergon Energy","2A","Major","All","Labour",0,0,0,0,0]
[null,"2A","Major","All","Material",1322760,1322760,1322760,1322760,1322760]
[null,"2A","Major","All","Contractor",283125,283125,283125,283125,283125]
["Ergon Energy",1,"Minor","All","Labour",446249.80368444911,453168.40529195993,460087.00689947081,467005.60850698163,473924.21011449245]
[null,1,"Minor","All","Material",1398513.0026312822,1400278.5220519223,1402044.0414725624,1403809.5608932022,1405575.0803138423]
[null,1,"Minor","All","Contractor",1050247.038987136,1053892.3419171693,1057537.6448472023,1061182.9477772354,1064828.2507072685]
["Ergon Energy","2A","Minor","All","Labour",0,0,0,0,0]
[null,"2A","Minor","All","Material",2068348.7799999998,2068348.7799999998,2068348.7799999998,2068348.7799999998,2068348.7799999998]
[null,"2A","Minor","All","Contractor",1099985,1099985,1099985,1099985,1099985]
["Ergon Energy",1,"All","All","Labour",{"$f":"SUMIFS(F$120:F$131,$B$120:$B$131,$B132,$E$120:$E$131,$E132)","v":1183524.1086209707},1205188.196327212,1226852.2840334536,1248516.3717396946,1270180.4594459359]
[null,1,"All","All","Material",{"$f":"SUMIFS(F$120:F$131,$B$120:$B$131,$B133,$E$120:$E$131,$E133)","v":3771199.2534298934},3782294.9778665053,3793390.7023031181,3804486.4267397299,3815582.1511763423]
[null,1,"All","All","Contractor",1846705.3339561056,1858119.8027855181,1869534.2716149306,1880948.7404443431,1892363.2092737556]
[null,"2A","All","All","Labour",0,0,0,0,0]
[null,"2A","All","All","Material",3391108.78,3391108.78,3391108.78,3391108.78,3391108.78]
[null,"2A","All","All","Contractor",1383110,1383110,1383110,1383110,1383110]
["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":1183524.1086209707},1205188.196327212,1226852.2840334536,1248516.3717396946,1270180.4594459359]
[null,"All","All","All","Material",7162308.0334298937,7173403.7578665055,7184499.4823031183,7195595.2067397302,7206690.931176343]
[null,"All","All","All","Contractor",3229815.3339561056,3241229.8027855181,3252644.2716149306,3264058.7404443431,3275473.2092737556]
["Ergon Energy","All","All","All","All",11575647.476006968,11619821.756979235,11663996.037951501,11708170.318923768,11752344.599896034]

{"sheet":"ERG - Gross Capex ","index":13,"n_rows":96,"n_cols":10,"rows_kept":96,"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":1312417.2701361673},{"$f":"'ERG - Forecast capex scenarios'!G138*'Cost Escalations'!$E$21*(1+'Cost Escalations'!C30)","v":1347934.1023187931},{"$f":"'ERG - Forecast capex scenarios'!H138*'Cost Escalations'!$E$21*(1+'Cost Escalations'!D30)","v":1380534.3472687153},{"$f":"'ERG - Forecast capex scenarios'!I138*'Cost Escalations'!$E$21*(1+'Cost Escalations'!E30)","v":1417556.4039422425},{"$f":"'ERG - Forecast capex scenarios'!J138*'Cost Escalations'!$E$21*(1+'Cost Escalations'!F30)","v":1457296.2648310007},null,null,{"$f":"'ERG - Forecast capex scenarios'!F138*'Cost Escalations'!$E$21*(1+'Cost Escalations'!B30)","v":1312417.2701361673},{"$f":"'ERG - Forecast capex scenarios'!F138","v":1183524.1086209707}]
["Contractors",{"$f":"'ERG - Forecast capex scenarios'!F140*'Cost Escalations'!$E$21*(1+'Cost Escalations'!B26)","v":3577667.8383846618},{"$f":"'ERG - Forecast capex scenarios'!G140*'Cost Escalations'!$E$21*(1+'Cost Escalations'!C26)","v":3615802.8631479098},{"$f":"'ERG - Forecast capex scenarios'!H140*'Cost Escalations'!$E$21*(1+'Cost Escalations'!D26)","v":3650670.5185808041},{"$f":"'ERG - Forecast capex scenarios'!I140*'Cost Escalations'!$E$21*(1+'Cost Escalations'!E26)","v":3697185.8088927427},{"$f":"'ERG - Forecast capex scenarios'!J140*'Cost Escalations'!$E$21*(1+'Cost Escalations'!F26)","v":3750555.1831754656},null,null,{"$f":"'ERG - Forecast capex scenarios'!F140*'Cost Escalations'!$E$21*(1+'Cost Escalations'!B26)","v":3577667.8383846618},{"$f":"'ERG - Forecast capex scenarios'!F140","v":3229815.3339561056}]
["Materials",{"$f":"'ERG - Forecast capex scenarios'!F139*'Cost Escalations'!$E$21","v":7851253.5354828481},{"$f":"'ERG - Forecast capex scenarios'!G139*'Cost Escalations'!$E$21","v":7863416.5624435823},{"$f":"'ERG - Forecast capex scenarios'!H139*'Cost Escalations'!$E$21","v":7875579.5894043176},{"$f":"'ERG - Forecast capex scenarios'!I139*'Cost Escalations'!$E$21","v":7887742.6163650518},{"$f":"'ERG - Forecast capex scenarios'!J139*'Cost Escalations'!$E$21","v":7899905.643325788},null,null,{"$f":"'ERG - Forecast capex scenarios'!F139*'Cost Escalations'!$E$21","v":7851253.5354828481},{"$f":"'ERG - Forecast capex scenarios'!F139","v":7162308.0334298937}]
["Total",{"$f":"SUM(B5:B7)","v":12741338.644003678},12827153.527910285,12906784.455253836,13002484.829200037,13107757.091332253,null,null,{"$f":"SUM(I5:I7)","v":12741338.644003678},{"$f":"SUM(J5:J7)","v":11575647.47600697}]
[]
["Overheads & Oncosts"]
["Fleet oncost",{"$f":"B5*Overheads!$D$15","v":277760.44368673069},{"$f":"C5*Overheads!$D$15","v":285277.23829914059},{"$f":"D5*Overheads!$D$15","v":292176.7653837293},{"$f":"E5*Overheads!$D$15","v":300012.1262265254},{"$f":"F5*Overheads!$D$15","v":308422.68409076711}]
["Material oncosts",{"$f":"B7*Overheads!$D$9","v":624863.21885037376},{"$f":"C7*Overheads!$D$9","v":625831.246203369},{"$f":"D7*Overheads!$D$9","v":626799.27355636435},{"$f":"E7*Overheads!$D$9","v":627767.30090935959},{"$f":"F7*Overheads!$D$9","v":628735.32826235506}]
["Network overheads",{"$f":"(B8+B11+B12)*Overheads!$D$19","v":1575106.9269916122},{"$f":"(C8+C11+C12)*Overheads!$D$19","v":1585993.216223082},{"$f":"(D8+D11+D12)*Overheads!$D$19","v":1596094.348259239},{"$f":"(E8+E11+E12)*Overheads!$D$19","v":1608158.6295837061},{"$f":"(F8+F11+F12)*Overheads!$D$19","v":1621394.3260616281}]
["Non-network overheads",{"$f":"B5*Overheads!$D$20","v":464622.57778997114},{"$f":"C5*Overheads!$D$20","v":477196.26338457875},{"$f":"D5*Overheads!$D$20","v":488737.41739853489},{"$f":"E5*Overheads!$D$20","v":501843.98327369738},{"$f":"F5*Overheads!$D$20","v":515912.70747239218}]
["Non-network depreciation",{"$f":"B5*Overheads!$D$25","v":180876.58142648893},{"$f":"C5*Overheads!$D$25","v":185771.49048816648},{"$f":"D5*Overheads!$D$25","v":190264.43720136868},{"$f":"E5*Overheads!$D$25","v":195366.79542299631},{"$f":"F5*Overheads!$D$25","v":200843.71983376471}]
["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":3123229.7487451769},3160069.4545983369,3194072.2417992363,3233148.8354162849,3275308.7657209071]
[]
["Total Expenditure (incl oncosts and overheads)",{"$f":"B8+B19","v":15864568.392748855},{"$f":"C8+C19","v":15987222.982508622},16100856.697053071,16235633.664616322,16383065.857053161]
[]
[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":15864568.392748855},{"$f":"C25*C21","v":15987222.982508622},16100856.697053071,16235633.664616322,16383065.857053161]
["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":3123229.7487451769},{"$f":"C25*C19","v":3160069.4545983369},{"$f":"D25*D19","v":3194072.2417992363},{"$f":"E25*E19","v":3233148.8354162849},{"$f":"F25*F19","v":3275308.7657209071}]
["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":1312417.2701361673},{"$f":"'ERG - Forecast capex scenarios'!G132*'Cost Escalations'!$E$21*(1+'Cost Escalations'!C30)","v":1347934.1023187931},{"$f":"'ERG - Forecast capex scenarios'!H132*'Cost Escalations'!$E$21*(1+'Cost Escalations'!D30)","v":1380534.3472687153},{"$f":"'ERG - Forecast capex scenarios'!I132*'Cost Escalations'!$E$21*(1+'Cost Escalations'!E30)","v":1417556.4039422425},{"$f":"'ERG - Forecast capex scenarios'!J132*'Cost Escalations'!$E$21*(1+'Cost Escalations'!F30)","v":1457296.2648310007}]
["Contractors",{"$f":"'ERG - Forecast capex scenarios'!F134*'Cost Escalations'!$E$21*(1+'Cost Escalations'!B26)","v":2045596.2948741005},{"$f":"'ERG - Forecast capex scenarios'!G134*'Cost Escalations'!$E$21*(1+'Cost Escalations'!C26)","v":2072853.6116784236},{"$f":"'ERG - Forecast capex scenarios'!H134*'Cost Escalations'!$E$21*(1+'Cost Escalations'!D26)","v":2098309.2766773542},{"$f":"'ERG - Forecast capex scenarios'!I134*'Cost Escalations'!$E$21*(1+'Cost Escalations'!E26)","v":2130542.8435637811},{"$f":"'ERG - Forecast capex scenarios'!J134*'Cost Escalations'!$E$21*(1+'Cost Escalations'!F26)","v":2166835.8095244183},{"$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":4133952.5378277693},{"$f":"'ERG - Forecast capex scenarios'!G133*'Cost Escalations'!$E$21","v":4146115.5647885036},{"$f":"'ERG - Forecast capex scenarios'!H133*'Cost Escalations'!$E$21","v":4158278.5917492388},{"$f":"'ERG - Forecast capex scenarios'!I133*'Cost Escalations'!$E$21","v":4170441.6187099735},{"$f":"'ERG - Forecast capex scenarios'!J133*'Cost Escalations'!$E$21","v":4182604.6456707083}]
["Total",{"$f":"SUM(B40:B42)","v":7491966.1028380375},{"$f":"SUM(C40:C42)","v":7566903.2787857205},7637122.2156953085,7718540.8662159964,7806736.7200261271]
[]
["Overheads & Oncosts"]
["Fleet oncost",{"$f":"B40*Overheads!$D$15","v":277760.44368673069},{"$f":"C40*Overheads!$D$15","v":285277.23829914059},{"$f":"D40*Overheads!$D$15","v":292176.7653837293},{"$f":"E40*Overheads!$D$15","v":300012.1262265254},{"$f":"F40*Overheads!$D$15","v":308422.68409076711}]
["Material oncosts",{"$f":"B42*Overheads!$D$9","v":329011.77852523245},{"$f":"C42*Overheads!$D$9","v":329979.80587822775},{"$f":"D42*Overheads!$D$9","v":330947.83323122311},{"$f":"E42*Overheads!$D$9","v":331915.8605842184},{"$f":"F42*Overheads!$D$9","v":332883.88793721376}]
["Network overheads",{"$f":"(B43+B46+B47)*Overheads!$D$19","v":934946.79544544173},{"$f":"(C43+C46+C47)*Overheads!$D$19","v":944577.32386704208},{"$f":"(D43+D46+D47)*Overheads!$D$19","v":953591.90267208894},{"$f":"(E43+E46+E47)*Overheads!$D$19","v":964007.45168613933},{"$f":"(F43+F46+F47)*Overheads!$D$19","v":975271.78761410143}]
["Non-network overheads",{"$f":"B40*Overheads!$D$20","v":464622.57778997114},{"$f":"C40*Overheads!$D$20","v":477196.26338457875},{"$f":"D40*Overheads!$D$20","v":488737.41739853489},{"$f":"E40*Overheads!$D$20","v":501843.98327369738},{"$f":"F40*Overheads!$D$20","v":515912.70747239218}]
["Non-network depreciation",{"$f":"B40*Overheads!$D$25","v":180876.58142648893},{"$f":"C40*Overheads!$D$25","v":185771.49048816648},{"$f":"D40*Overheads!$D$25","v":190264.43720136868},{"$f":"E40*Overheads!$D$25","v":195366.79542299631},{"$f":"F40*Overheads!$D$25","v":200843.71983376471}]
["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":2187218.1768738646},{"$f":"SUM(C46:C53)","v":2222802.1219171556},{"$f":"SUM(D46:D53)","v":2255718.355886945},{"$f":"SUM(E46:E53)","v":2293146.217193577},{"$f":"SUM(F46:F53)","v":2333334.7869482394}]
[]
["Total Expenditure",{"$f":"B43+B54","v":9679184.2797119021},9789705.4007028751,9892840.571582254,10011687.083409574,10140071.506974366]
[]
["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":9679184.2797119021},{"$f":"C59*C56","v":9789705.4007028751},{"$f":"D59*D56","v":9892840.571582254},{"$f":"E59*E56","v":10011687.083409574},{"$f":"F59*F56","v":10140071.506974366}]
["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":1532071.5435105611},{"$f":"'ERG - Forecast capex scenarios'!G137*'Cost Escalations'!$E$21*(1+'Cost Escalations'!C26)","v":1542949.2514694862},{"$f":"'ERG - Forecast capex scenarios'!H137*'Cost Escalations'!$E$21*(1+'Cost Escalations'!D26)","v":1552361.2419034501},{"$f":"'ERG - Forecast capex scenarios'!I137*'Cost Escalations'!$E$21*(1+'Cost Escalations'!E26)","v":1566642.9653289618},{"$f":"'ERG - Forecast capex scenarios'!J137*'Cost Escalations'!$E$21*(1+'Cost Escalations'!F26)","v":1583719.3736510472}]
["Materials",{"$f":"'ERG - Forecast capex scenarios'!F136*'Cost Escalations'!$E$21","v":3717300.9976550783},{"$f":"'ERG - Forecast capex scenarios'!G136*'Cost Escalations'!$E$21","v":3717300.9976550783},{"$f":"'ERG - Forecast capex scenarios'!H136*'Cost Escalations'!$E$21","v":3717300.9976550783},{"$f":"'ERG - Forecast capex scenarios'!I136*'Cost Escalations'!$E$21","v":3717300.9976550783},{"$f":"'ERG - Forecast capex scenarios'!J136*'Cost Escalations'!$E$21","v":3717300.9976550783},{"$f":"'ERG - Forecast capex scenarios'!K136*'Cost Escalations'!$E$21","v":0}]
["Total",{"$f":"SUM(B70:B72)","v":5249372.5411656396},5260250.2491245642,5269662.2395585282,5283943.9629840404,5301020.3713061251]
[]
["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":295851.44032514119},{"$f":"C72*Overheads!$D$9","v":295851.44032514119},{"$f":"D72*Overheads!$D$9","v":295851.44032514119},{"$f":"E72*Overheads!$D$9","v":295851.44032514119},{"$f":"F72*Overheads!$D$9","v":295851.44032514119}]
["Network overheads",{"$f":"(B73+B76+B77)*Overheads!$D$19","v":640160.13154617022},{"$f":"(C73+C76+C77)*Overheads!$D$19","v":641415.89235603996},{"$f":"(D73+D76+D77)*Overheads!$D$19","v":642502.44558714994},{"$f":"(E73+E76+E77)*Overheads!$D$19","v":644151.17789756681},{"$f":"(F73+F76+F77)*Overheads!$D$19","v":646122.53844752652}]
["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":936011.5718713114},{"$f":"SUM(C76:C83)","v":937267.33268118114},{"$f":"SUM(D76:D83)","v":938353.88591229112},{"$f":"SUM(E76:E83)","v":940002.618222708},{"$f":"SUM(F76:F83)","v":941973.9787726677}]
[]
["Total Expenditure",{"$f":"B73+B84","v":6185384.1130369511},6197517.5818057451,6208016.125470819,6223946.5812067483,{"$f":"F73+F84","v":6242994.3500787932}]
[]
["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":6185384.1130369511},6197517.5818057451,6208016.125470819,6223946.5812067483,6242994.3500787932]
["CON",{"$f":"B90*B86","v":0},0,0,0,0]
[]
["Reconciliation",{"$f":"B56+B86","v":15864568.392748853},{"$f":"C56+C86","v":15987222.98250862},{"$f":"D56+D86","v":16100856.697053073},{"$f":"E56+E86","v":16235633.664616322},{"$f":"F56+F86","v":16383065.857053159}]
[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}]

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

{"sheet":"ERG - Opex BST","index":15,"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":75130},{"$f":"'ERG - Yearly volume scenarios'!L83","v":53909},{"$f":"'ERG - Yearly volume scenarios'!M83","v":36787},{"$f":"'ERG - Yearly volume scenarios'!N83","v":20647},{"$f":"'ERG - Yearly volume scenarios'!O83","v":0}]
["LED",null,null,null,{"$f":"'ERG - Yearly volume scenarios'!K84+'ERG - Yearly volume scenarios'!K106","v":77302},{"$f":"'ERG - Yearly volume scenarios'!L84+'ERG - Yearly volume scenarios'!L106","v":98719},{"$f":"'ERG - Yearly volume scenarios'!M84+'ERG - Yearly volume scenarios'!M106","v":116041},{"$f":"'ERG - Yearly volume scenarios'!N84+'ERG - Yearly volume scenarios'!N106","v":132384},{"$f":"'ERG - Yearly volume scenarios'!O84+'ERG - Yearly volume scenarios'!O106","v":153237}]
["Total",null,null,null,{"$f":"SUM(E5:E6)","v":152432},{"$f":"SUM(F5:F6)","v":152628},{"$f":"SUM(G5:G6)","v":152828},{"$f":"SUM(H5:H6)","v":153031},{"$f":"SUM(I5:I6)","v":153237}]
[]
["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.1599999999999999E-2},{"$f":"'Cost Escalations'!C29","v":8.6E-3},{"$f":"'Cost Escalations'!D29","v":6.1000000000000004E-3},{"$f":"'Cost Escalations'!E29","v":8.9999999999999993E-3},{"$f":"'Cost Escalations'!F29","v":1.0500000000000001E-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.866429924966189E-3},{"$f":"SUMPRODUCT(F12:F14,F18:F20)","v":6.1298419480729088E-3},{"$f":"SUMPRODUCT(G12:G14,G18:G20)","v":5.0373544511173058E-3},{"$f":"SUMPRODUCT(H12:H14,H18:H20)","v":7.5617625758859497E-3},{"$f":"SUMPRODUCT(I12:I14,I18:I20)","v":8.9300565643325898E-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":151736},{"$f":"'ERG - Yearly volume scenarios'!K85+'ERG - Yearly volume scenarios'!K106","v":152432},{"$f":"'ERG - Yearly volume scenarios'!L85+'ERG - Yearly volume scenarios'!L106","v":152628},{"$f":"'ERG - Yearly volume scenarios'!M85+'ERG - Yearly volume scenarios'!M106","v":152828},{"$f":"'ERG - Yearly volume scenarios'!N85+'ERG - Yearly volume scenarios'!N106","v":153031},{"$f":"'ERG - Yearly volume scenarios'!O85+'ERG - Yearly volume scenarios'!O106","v":153237}]
["Growth Rate",null,null,null,{"$f":"LN(E28)-LN(D28)","v":4.5764262824015134E-3},{"$f":"LN(F28)-LN(E28)","v":1.2849932929253072E-3},{"$f":"LN(G28)-LN(F28)","v":1.3095177608590802E-3},{"$f":"LN(H28)-LN(G28)","v":1.3274092297912432E-3},{"$f":"LN(I28)-LN(H28)","v":1.3452272589073999E-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.255037530922693E-3},{"$f":"SUMPRODUCT($D$30,F29)","v":3.5239610781164258E-4},{"$f":"SUMPRODUCT($D$30,G29)","v":3.5912168925521465E-4},{"$f":"SUMPRODUCT($D$30,H29)","v":3.6402823939009826E-4},{"$f":"SUMPRODUCT($D$30,I29)","v":3.6891464941572093E-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.0272708648118596E-2},{"$f":"(1+F24)*(1+F30)*(1-F34)-1","v":-3.3774977739204681E-2},{"$f":"(1+G24)*(1+G30)*(1-G34)-1","v":-3.4817646242932265E-2},{"$f":"(1+H24)*(1+H30)*(1-H34)-1","v":-3.2388598230022492E-2},{"$f":"(1+I24)*(1+I30)*(1-I34)-1","v":-3.1069824983262384E-2}]
["Rate of Change - Cummulative",null,null,null,{"$f":"PRODUCT(1+$D38:E38)-1","v":-3.0272708648118596E-2},{"$f":"PRODUCT(1+$D38:F38)-1","v":-6.3025226326627659E-2},{"$f":"PRODUCT(1+$D38:G38)-1","v":-9.5648482534938628E-2},{"$f":"PRODUCT(1+$D38:H38)-1","v":-0.12493916049282572},{"$f":"PRODUCT(1+$D38:I38)-1","v":-0.15212714762602031}]

{"sheet":"ERG - Forecast opex","index":16,"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":75020.170929960601}]
["   Contractor",4774784.0299999993,{"$f":"B5*'Cost Escalations'!$E$21","v":5234072.5673525976}]
["   Materials",303078.30000000005,{"$f":"B6*'Cost Escalations'!$E$21","v":332231.53253066842}]
["   Other",458593.18,{"$f":"B7*'Cost Escalations'!$E$21","v":502705.4559812189}]
["Damage/Emergency"]
["   Labour",1332665.0599999998,{"$f":"B9*'Cost Escalations'!$E$21","v":1460854.6874978349}]
["   Contractor",331765.18000000005,{"$f":"B10*'Cost Escalations'!$E$21","v":363677.81590339221}]
["   Materials",401137.78,{"$f":"B11*'Cost Escalations'!$E$21","v":439723.3962489235}]
["  Other",52326.39,{"$f":"B12*'Cost Escalations'!$E$21","v":57359.688045951953}]
["Total direct opex",{"$f":"SUM(B4:B12)","v":7722787.089999998},{"$f":"SUM(C4:C12)","v":8465645.3144905493}]
[]
["Adjustments (material costs)"]
["LED Lamps ",-210000,{"$f":"B16*'Cost Escalations'!$E$21","v":-230199.99066723141}]
["Overheads & Oncosts"]
["Base Opex",null,{"$f":"C13+C16+C17","v":8235445.3238233179}]
["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":325053.08474029572}]
["Material oncosts",null,{"$f":"(C6+C11+C16)*Overheads!D9","v":43117.030029288901}]
["Network overheads",null,{"$f":"(C18+C23+C24+C25)*Overheads!D19","v":993231.58258823003}]
["Non-network overheads",null,{"$f":"(C4+C9)*Overheads!D20","v":543731.13804841274}]
["Non-network depreciation",null,{"$f":"(C4+C9)*Overheads!D25","v":211673.37569589383}]
["Corporate overheads",null,{"$f":"C18*Overheads!D26","v":442970.86390284303}]
["Market",null,{"$f":"C18*Overheads!D27","v":23310.831679386123}]
["Customer ops",null,{"$f":"C18*Overheads!D28","v":235404.33838467972}]
["Total",null,{"$f":"SUM(C23:C31)","v":2818492.2450690302}]
["Base Opex (Gross)",null,{"$f":"C18+C32","v":11053937.568892349}]
[]
["Table 2 - Forecast Capex (Gross)"]
["Forecast opex","2022-23","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30"]
["LED opex",null,null,{"$f":"D39*('ERG - Opex BST'!E5/'ERG - Opex BST'!E7)","v":5283282.9061547285},{"$f":"E39*('ERG - Opex BST'!F5/'ERG - Opex BST'!F7)","v":3658238.0983735612},{"$f":"F39*('ERG - Opex BST'!G5/'ERG - Opex BST'!G7)","v":2406277.5636783368},{"$f":"G39*('ERG - Opex BST'!H5/'ERG - Opex BST'!H7)","v":1305066.9687972474},{"$f":"H39*('ERG - Opex BST'!I5/'ERG - Opex BST'!I7)","v":0}]
["CONV opex",null,null,{"$f":"D39*('ERG - Opex BST'!E6/'ERG - Opex BST'!E7)","v":5436022.0313000502},{"$f":"E39*('ERG - Opex BST'!F6/'ERG - Opex BST'!F7)","v":6699022.5534389345},{"$f":"F39*('ERG - Opex BST'!G6/'ERG - Opex BST'!G7)","v":7590367.6507135099},{"$f":"G39*('ERG - Opex BST'!H6/'ERG - Opex BST'!H7)","v":8367800.9200975848},{"$f":"H39*('ERG - Opex BST'!I6/'ERG - Opex BST'!I7)","v":9372333.5765006505}]
["Total ",null,{"$f":"C33","v":11053937.568892349},{"$f":"C39*(1+'ERG - Opex BST'!E39)","v":10719304.937454779},{"$f":"$C$39*(1+'ERG - Opex BST'!F39)","v":10357260.651812496},{"$f":"$C$39*(1+'ERG - Opex BST'!G39)","v":9996645.2143918462},{"$f":"$C$39*(1+'ERG - Opex BST'!H39)","v":9672867.8888948318},{"$f":"$C$39*(1+'ERG - Opex BST'!I39)","v":9372333.5765006505}]