{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Draft Decision changes","Cover page","Version Control","Intro",">>General inputs","Cost Escalations","Ratios & Assumptions","Overheads",">>Volumes","EGX - Yearly volume scenarios",">>Unit Rates","EGX Unit Rates",">>Forecast capex","EGX - Forecast capex scenarios","EGX - Gross Capex",">>Forecast opex","EGX - Opex BST","EGX - Forecast Opex"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":3,"defined_names":24,"comments":2,"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":"Cover page","index":1,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[[1,0,1,5],[2,0,2,5]]}
[]
["Energex Public Lighting Capex and Opex Forecasting Model"]
["2025-30"]

{"sheet":"Version Control","index":2,"n_rows":6,"n_cols":4,"rows_kept":6,"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"]

{"sheet":"Intro","index":3,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Model developer ","Energex"]
[]
[]
[]
["Purpose","To provide capex and opex forecasts 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":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Cost Escalations","index":5,"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)),'EGX - Gross Capex'!P8/(1+'EGX - Gross Capex'!P$4),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)),'EGX - Gross Capex'!P10/(1+'EGX - Gross Capex'!P$4),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)),'EGX - Gross Capex'!#REF!/(1+'EGX - Gross Capex'!P$4),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)),'EGX - Gross Capex'!P12/(1+'EGX - Gross Capex'!P$4),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)),'EGX - Gross Capex'!P20/(1+'EGX - Gross Capex'!P$4),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)),'EGX - Gross Capex'!P21/(1+'EGX - Gross Capex'!P$4),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.4816502818954524E-2,9.8611007932502479E-3,8.4436518056068104E-3,1.0512472688202901E-2,1.2367452017459594E-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.4816502818954636E-2},{"$f":"PRODUCT(1+$B29:C29)-1","v":2.4823710639906071E-2},{"$f":"PRODUCT(1+$B29:D29)-1","v":3.3476965214679355E-2},{"$f":"PRODUCT(1+$B29:E29)-1","v":4.434136358538554E-2},{"$f":"PRODUCT(1+$B29:F29)-1","v":5.7257205289376278E-2}]

{"sheet":"Ratios & Assumptions","index":6,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,2,1,3]]}
["Table 1 - EGX ratios between major and minor roads"]
[null,null,"2025-26"]
["DNSP","Road type","Volume","Ratio"]
["Energex","Major",{"$f":"SUMIF('EGX - Yearly volume scenarios'!$C$5:$C$12,'Ratios & Assumptions'!$B4,'EGX - Yearly volume scenarios'!$G$5:$G$12)","v":97805},{"$f":"C4/$C$6","v":0.2849995337669301}]
["Energex","Minor",{"$f":"SUMIF('EGX - Yearly volume scenarios'!$C$5:$C$12,'Ratios & Assumptions'!$B5,'EGX - Yearly volume scenarios'!$G$5:$G$12)","v":245371},{"$f":"C5/$C$6","v":0.7150004662330699}]
["Energex","All",{"$f":"SUM(C4:C5)","v":343176},{"$f":"SUM(D4:D5)","v":1}]
["Note:"]
["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 - EGX estimated annual growth rates"]
["DNSP","Road","Rate","Rate"]
["All","All ",1,2.5000000000000001E-2]
["All","All ",2,1.4999999999999999E-2]
["Note:"]
["Different growth rates for Rate 1 and Rate 2"]

{"sheet":"Overheads","index":7,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Table 1 - EGX Labour Oncosts"]
["DNSP","Cost type","Cost recovery","FY2023"]
["Energex","Labour Oncosts","Labour only",0]
["Energex","All","All",{"$f":"SUM(D3)","v":0}]
[]
["Table 2 - EGX Material Oncosts"]
["DNSP","Cost type","Cost recovery","FY2023"]
["Energex","Material Oncosts","Material only",8.716716242153344E-2]
["Energex","All","All",{"$f":"SUM(D8)","v":8.716716242153344E-2}]
[]
["Table 3 - EGX Fleet Oncosts"]
["DNSP","Cost type","Cost recovery","FY2023"]
["Energex","Fleet Oncost Indirects","Labour only",0.12669576075036793]
["Energex","Fleet Oncost Depreciation","Labour only",8.4944584136218471E-2]
["Energex","All","All",{"$f":"SUM(D13:D14)","v":0.2116403448865864}]
[]
["Table 4 - EGX Network and Non-network Overheads "]
["DNSP","Cost type","Cost recovery","FY2023"]
["Energex","Network Overhead","All Direct costs + Oncosts",0.19886793668603725]
["Energex","Non Network Overhead","Labour only",0.43849358658607429]
["Energex","All","All",{"$f":"SUM(D19:D20)","v":0.63736152327211149}]
[]
["Table 5 - EGX Other Allocations"]
["DNSP","Cost type","Cost recovery","FY2023"]
["Energex","Non Network Depreciation","Labour only",0.14706512532709964]
["Energex","Corporate Overhead","All Direct Costs + Oncosts",0.12596529859724023]
["Energex","Market","All Direct Costs + Oncosts",7.2404380435096239E-3]
["Energex","Customer Ops","All Direct Costs + Oncosts",6.0617436431269656E-2]
["Energex","All","All",{"$f":"SUM(D25:D28)","v":0.34088829839911911}]

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

{"sheet":"EGX - Yearly volume scenarios","index":9,"n_rows":109,"n_cols":16,"rows_kept":109,"cut":false,"hidden":false,"merged":[[23,10,23,14],[23,5,23,9],[98,0,98,3],[1,5,1,9],[92,5,92,9],[38,5,38,9],[22,10,22,14],[37,10,37,14],[95,0,95,3],[92,10,92,14],[1,10,1,14],[71,5,71,9],[71,10,71,14],[70,10,70,14],[91,10,91,14],[38,10,38,14],[51,5,51,9],[51,10,51,14],[61,5,61,9],[61,10,61,14],[50,10,50,14],[60,10,60,14]]}
["Table 1 - EGX 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"]
["Energex",1,"Major","CONV",39166,38542,38010,32565,25403,19811,17899,13391,9719,6071,0]
["Energex",1,"Major","LED",1477,2306,3113,8558,15720,21312,23224,27732,31404,35052,41123]
["Energex",1,"Minor","CONV",104697,102204,95466,81790,63801,49755,44844,33549,24351,15211,0,"Removes the Nostalgia  as these are to be converted to LED (see Table 3 below)"]
["Energex",1,"Minor","LED",4798,7287,13986,27662,45651,59697,64608,75903,85101,94241,109452]
["Energex",2,"Major","CONV",52820,52615,52158,49902,44915,40417,36516,27319,19829,12387,0]
["Energex","2A","Major","LED",2101,3389,4524,6780,11767,16265,20166,29363,36853,44295,56682]
["Energex",2,"Minor","CONV",126472,125346,115984,110967,99877,89874,73032,54638,39657,24772,0,"Removes the Nostalgia  as these are to be converted to LED (see Table 3 below)"]
["Energex","2A","Minor","LED",6059,8985,19935,24952,36042,46045,62887,81281,96262,111147,135919]
["Energex","All","All","CONV",{"$f":"E5+E7+E9+E11","v":323155},318707,301618,275224,233996,199857,172291,128897,93556,58441,0]
["Energex","All","All","LED",{"$f":"E6+E8+E10+E12","v":14435},{"$f":"F6+F8+F10+F12","v":21967},{"$f":"G6+G8+G10+G12","v":41558},67952,109180,143319,170885,214279,249620,284735,343176]
["Energex","All","All","All",{"$f":"E13+E14","v":337590},{"$f":"F13+F14","v":340674},343176,343176,343176,343176,{"$f":"SUM(K5:K12)","v":343176},{"$f":"SUM(L5:L12)","v":343176},{"$f":"SUM(M5:M12)","v":343176},{"$f":"SUM(N5:N12)","v":343176},{"$f":"SUM(O5:O12)","v":343176}]
["Energex","All","All","LED",{"$f":"E14/E15","v":4.275896797890933E-2},{"$f":"F14/F15","v":6.4480999430540628E-2},0.12109821199617689,0.19800918479147725,0.31814579108096136,0.41762535841667248,{"$f":"K14/K15","v":0.49795148844907572},0.62439972492248874,0.72738186819591111,0.82970545725808331,{"$f":"O14/O15","v":1}]
["Notes:"]
["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 remain Rate 1"]
["All Rate 2 CONV lights converted to LED and funded by ERG, will be assigned to Rate 2A"]
[]
["Table 1.b - EGX Number of LED luminaire conversions each year",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"]
["Energex",1,"Major","LED",null,{"$f":"F6-E6","v":829},807,5445,7162,5592,1912,4508,3672,3648,6071]
["Energex",1,"Minor","LED",null,{"$f":"F8-E8","v":2489},6699,13676,17989,14046,4911,11295,9198,9140,15211]
["Energex","2A","Major","LED",null,{"$f":"F10-E10","v":1288},1135,2256,4987,4498,3901,9197,7490,7442,12387]
["Energex","2A","Minor","LED",null,{"$f":"F12-E12","v":2926},10950,5017,11090,10003,16842,18394,14981,14885,24772]
["Energex","All","All","LED",null,{"$f":"SUM(F27:F30)","v":7532},19591,26394,41228,34139,27566,43394,35341,35115,58441]
[null,null,null,"Total LED volume",null,{"$f":"E14+F31","v":21967},41558,67952,109180,143319,170885,214279,249620,284735,343176]
[null,null,null,"Check",null,null,null,null,null,"Check",{"$f":"IF(K14-K32=0,0,1)","v":0},{"$f":"IF(L14-L32=0,0,1)","v":0},{"$f":"IF(M14-M32=0,0,1)","v":0},{"$f":"IF(N14-N32=0,0,1)","v":0},{"$f":"IF(O14-O32=0,0,1)","v":0}]
[null,null,"Proportions","LED","Rate 1",{"$f":"SUM(F27:F28)/SUM(F27:F30)","v":0.44052044609665425},0.38313511306212034,0.7244449496097598,0.61004657029203457,0.57523653299745159,0.24751505477762462,0.36417477070562748,0.36416626581024875,0.36417485405097538,0.3641621464382882]
[null,null,null,null,"Rate2A",{"$f":"1-F34","v":0.55947955390334569},{"$f":"1-G34","v":0.61686488693787966},0.2755550503902402,0.38995342970796543,0.42476346700254841,{"$f":"1-K34","v":0.75248494522237541},0.63582522929437246,0.63583373418975131,0.63582514594902462,0.63583785356171174]
[]
[]
["Table 1.c - EGX smoothed LED luminaire replacement volume/year (ensure the capex is smoothed over the 5 year cycle)",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"]
["Energex",1,"Major","LED",null,null,null,null,null,null,{"$f":"ROUND(SUM($K27:$O27)/5,0)","v":3962},3962,3962,3962,3962]
["Energex",1,"Minor","LED",null,null,null,null,null,null,9951,9951,9951,9951,9951]
["Energex","2A","Major","LED",null,null,null,null,null,null,8083,8083,8083,8083,8083]
["Energex","2A","Minor","LED",null,null,null,null,null,null,17975,17975,17975,17975,17975]
["Energex","All","All","LED",null,null,null,null,null,null,{"$f":"SUM(K42:K45)","v":39971},{"$f":"SUM(L42:L45)","v":39971},{"$f":"SUM(M42:M45)","v":39971},{"$f":"SUM(N42:N45)","v":39971},{"$f":"SUM(O42:O45)","v":39971}]
["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"]
["2- New public light intallations",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"]
["Energex",1,"Major ","LED",227.53343309195932,280.46834345186471,273.29839987730685,{"$f":"ROUND(AVERAGE(E55:G55)*(1+'Ratios & Assumptions'!$D$13),0)","v":267},{"$f":"ROUND(H55*(1+'Ratios & Assumptions'!$D$13),0)","v":274},{"$f":"ROUND(I55*(1+'Ratios & Assumptions'!$D$13),0)","v":281},{"$f":"ROUND(J55*(1+'Ratios & Assumptions'!$D$13),0)","v":288},{"$f":"ROUND(K55*(1+'Ratios & Assumptions'!$D$13),0)","v":295},{"$f":"ROUND(L55*(1+'Ratios & Assumptions'!$D$13),0)","v":302},{"$f":"ROUND(M55*(1+'Ratios & Assumptions'!$D$13),0)","v":310},{"$f":"ROUND(N55*(1+'Ratios & Assumptions'!$D$13),0)","v":318}]
[null,1,"Minor","LED",317.59187029492699,266.74235302802862,338.11907682651986,{"$f":"ROUND(AVERAGE(E56:G56)*(1+'Ratios & Assumptions'!$D$14),0)","v":312},{"$f":"ROUND(H56*(1+'Ratios & Assumptions'!$D$14),0)","v":317},{"$f":"ROUND(I56*(1+'Ratios & Assumptions'!$D$14),0)","v":322},{"$f":"ROUND(J56*(1+'Ratios & Assumptions'!$D$14),0)","v":327},{"$f":"ROUND(K56*(1+'Ratios & Assumptions'!$D$14),0)","v":332},{"$f":"ROUND(L56*(1+'Ratios & Assumptions'!$D$14),0)","v":337},{"$f":"ROUND(M56*(1+'Ratios & Assumptions'!$D$14),0)","v":342},{"$f":"ROUND(N56*(1+'Ratios & Assumptions'!$D$14),0)","v":347}]
["Energex","All","All","LED",{"$f":"SUM(E55:E56)","v":545.12530338688634},547.21069647989339,611.41747670382665,579,591,603,615,627,639,652,665]
["Notes:",null,null,null,null,null,{"$f":"G57-F57","v":64.206780223933265}]
["All new installations are assumed to be LEDs"]
["Actual Rate 1 figures (2019-20 to 2021-22) are sourced from the Category Analysis RIN"]
[null,null,null,null,null,null,null,null,null,null,"100%  LED deployment by 2030"]
["3 - Conversion of Nostalgia lights from CONV to LED",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"]
["Energex",1,"Minor","LED",null,null,null,null,null,null,108,108,108,108,108]
[null,"2A","Minor","LED",null,null,null,null,null,null,{"$f":"8275-K65","v":8167},8167,8167,{"$f":"8275-N65","v":8167},{"$f":"8275-O65","v":8167}]
["Energex","All","All","LED",null,null,null,null,null,null,{"$f":"SUM(K65:K66)","v":8275},8275,8275,8275,8275]
["Notes:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K67:O67)","v":41375}]
["Convert remaining 41375 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"]
[null,null,null,null,null,null,null,null,null,null,"100%  LED deployment by 2030"]
["4 - Total public lighting asset base (table 1.a, table 2 and table 3 combined) ",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"]
["Energex",1,"Major","CONV",null,{"$f":"F5","v":38542},38010,32565,25403,19811,17899,13391,9719,6071,0]
["Energex",1,"Major","LED",null,{"$f":"F6+F55","v":2586.4683434518647},{"$f":"G6+G55","v":3386.298399877307},{"$f":"H6+H55","v":8825},{"$f":"I6+SUM(H55:I55)","v":16261},{"$f":"J6+SUM(H55:J55)","v":22134},{"$f":"K6+K55","v":23512},{"$f":"L6+SUM(K55:L55)","v":28315},{"$f":"M6+SUM(K55:M55)","v":32289},{"$f":"N6+SUM(K55:N55)","v":36247},{"$f":"O6+SUM(K55:O55)","v":42636}]
["Energex",1,"Minor","CONV",null,{"$f":"F7","v":102204},95466,81790,63801,49755,44844,33549,24351,15211,0]
["Energex",1,"Minor","LED",null,{"$f":"F8+F56","v":7553.7423530280284},{"$f":"G8+G56","v":14324.119076826521},{"$f":"H8+H56","v":27974},{"$f":"I8+SUM(H56:I56)","v":46280},{"$f":"J8+SUM(H56:J56)","v":60648},{"$f":"K8+K56+K65","v":65043},{"$f":"L8+SUM(K56:L56)+L65","v":76670},{"$f":"M8+SUM(K56:M56)+M65","v":86205},{"$f":"N8+SUM(K56:N56)+N65","v":95687},{"$f":"O8+SUM(K56:O56)+O65","v":111245}]
["Energex",2,"Major","CONV",null,{"$f":"F9","v":52615},52158,49902,44915,40417,36516,27319,19829,12387,0]
["Energex","2A","Major","LED",null,{"$f":"F10","v":3389},4524,6780,11767,16265,20166,29363,36853,44295,56682]
["Energex",2,"Minor","CONV",null,{"$f":"F11","v":125346},115984,110967,99877,89874,73032,54638,39657,24772,0]
["Energex","2A","Minor","LED",null,{"$f":"F12","v":8985},{"$f":"G12","v":19935},{"$f":"H12","v":24952},{"$f":"I12","v":36042},{"$f":"J12","v":46045},{"$f":"K12+K66","v":71054},{"$f":"L12+L66","v":89448},{"$f":"M12+M66","v":104429},{"$f":"N12+N66","v":119314},{"$f":"O12+O66","v":144086}]
["Energex","All","All","CONV",null,{"$f":"SUMIF($D$75:$D$82,$D83,F$75:F$82)","v":318707},301618,275224,233996,199857,172291,128897,93556,58441,0]
["Energex","All","All","LED",null,22514.210696479895,42169.417476703828,68531,110350,145092,179775,223796,259776,295543,354649]
["Energex","All","All","All",null,{"$f":"SUM(F83:F84)","v":341221.21069647989},{"$f":"G15+G65","v":343176},{"$f":"SUM(H83:H84)","v":343755},344346,344949,352066,352693,353332,353984,354649]
[null,null,null,null,null,null,null,null,null,"Check",{"$f":"IF(K15+K57+K67-K85=0,0,1)","v":0},{"$f":"IF(L15+SUM(K57,L57)+L67-L85=0,0,1)","v":0},{"$f":"IF(M15+SUM(K57:M57)+M67-M85=0,0,1)","v":0},{"$f":"IF(N15+SUM(K57:N57)+N67-N85=0,0,1)","v":0},{"$f":"IF(O15+SUM(K57:O57)+O67-O85=0,0,1)","v":0}]
["Rate 1 and 2A proportion","LED","Rate 1",null,null,null,{"$f":"((G76-F76)+(G78-F78))/((G76-F76)+(G78-F78)+(G80-F80)+(G82-F82))","v":0.38515019785193461},0.7241060928882882,0.61555752170066236,0.58260894594439006,0.16645042239713981,0.3732309579518866,0.3754585881045025,0.37576537031341739,0.37131594085202857]
[null,null,"Rate 2A",null,null,null,{"$f":"1-G87","v":0.61484980214806539},0.2758939071117118,0.38444247829933764,0.41739105405560994,{"$f":"1-K87","v":0.83354957760286019},0.62676904204811335,0.6245414118954975,0.62423462968658261,0.62868405914797143]
["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 "]
[null,null,null,null,null,null,null,null,null,null,"100%  LED deployment by 2030"]
["Table 5 - Rate 2 customer contributed assets ",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"]
["Energex",2,"Major","LED",909,1279,1110,1139,{"$f":"H97*(1+'Ratios & Assumptions'!$D$13)","v":1167.4749999999999},{"$f":"I97*(1+'Ratios & Assumptions'!$D$13)","v":1196.6618749999998},{"$f":"ROUND(J97*(1+'Ratios & Assumptions'!$D$13),0)","v":1227},{"$f":"ROUND(K97*(1+'Ratios & Assumptions'!$D$13),0)","v":1258},{"$f":"ROUND(L97*(1+'Ratios & Assumptions'!$D$13),0)","v":1289},{"$f":"ROUND(M97*(1+'Ratios & Assumptions'!$D$13),0)","v":1321},{"$f":"ROUND(N97*(1+'Ratios & Assumptions'!$D$13),0)","v":1354}]
[null,2,"Minor","LED",1363,1709,2017,2771,{"$f":"H98*(1+'Ratios & Assumptions'!$D$14)","v":2812.5649999999996},{"$f":"I98*(1+'Ratios & Assumptions'!$D$14)","v":2854.7534749999995},{"$f":"ROUND(J98*(1+'Ratios & Assumptions'!$D$14),0)","v":2898},{"$f":"ROUND(K98*(1+'Ratios & Assumptions'!$D$14),0)","v":2941},{"$f":"ROUND(L98*(1+'Ratios & Assumptions'!$D$14),0)","v":2985},{"$f":"ROUND(M98*(1+'Ratios & Assumptions'!$D$14),0)","v":3030},{"$f":"ROUND(N98*(1+'Ratios & Assumptions'!$D$14),0)","v":3075}]
["Rate 4 reassigned to Rate 2 on 1 July 2025"]
["Energex",2,"Major","LED",null,61,184,{"$f":"G100*(1+'Ratios & Assumptions'!$D$13)","v":188.6},{"$f":"H100*(1+'Ratios & Assumptions'!$D$13)","v":193.31499999999997},{"$f":"I100*(1+'Ratios & Assumptions'!$D$13)","v":198.14787499999994},{"$f":"ROUND($J$100,0)","v":198},{"$f":"ROUND($J$100,0)","v":198},198,198,198]
[null,2,"Minor","LED",null,274,634,{"$f":"G101*(1+'Ratios & Assumptions'!$D$13)","v":649.84999999999991},{"$f":"H101*(1+'Ratios & Assumptions'!$D$13)","v":666.09624999999983},{"$f":"I101*(1+'Ratios & Assumptions'!$D$13)","v":682.74865624999973},{"$f":"ROUND($J$101,0)","v":683},{"$f":"ROUND($J$101,0)","v":683},683,683,683]
["Energex","All","Major","LED",{"$f":"E97","v":909},{"$f":"F97","v":1279},1110,1139,1167.4749999999999,1196.6618749999998,{"$f":"K97+K100","v":1425},{"$f":"L97+L100","v":1456},1487,1519,1552]
[null,null,"Minor","LED",{"$f":"E98","v":1363},{"$f":"F98","v":1709},2017,2771,2812.5649999999996,2854.7534749999995,{"$f":"K98+K101","v":3581},{"$f":"L98+L101","v":3624},3668,3713,3758]
["Energex","All","All","LED",{"$f":"E102+E103","v":2272},{"$f":"F102+F103","v":2988},3127,3910,3980.0399999999995,4051.4153499999993,5006,5080,5155,5232,5310]
[]
["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":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"EGX Unit Rates","index":11,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Table 1: Energex Public Light - Unit costs per luminaire"]
[null,null,null,"Unit cost"]
["Activity type","Asset type","Cost categories","$2022-23 "]
[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,"Rate 1 Minor LED install","Labour",506.2196263223293]
[null,null,"Material",841.11606018807208]
[null,null,"Contractor",3510.0585400868404]
[null,"Rate 1 Major LED install","Labour",856.48872629500556]
[null,null,"Material",3433.5610582571344]
[null,null,"Contractor",5938.7771866151279]
[null,"wood pole minor (Rate 1 and 2)","Labour","N/A"]
[null,null,"Material","N/A"]
[null,null,"Contractor","N/A"]
["Light replacement","High Pressure Sodium - Major (Rate 1 and 2)","Labour","N/A"]
[null,null,"Material","N/A"]
[null,null,"Contractor","N/A"]
[null,"High Pressure Sodium - Minor (Rate 1 and 2)","Labour","N/A"]
[null,null,"Material","N/A"]
[null,null,"Contractor","N/A"]
[null,"LED Major","Labour",0]
[null,null,"Material",584]
[null,null,"Contractor",75]
[null,"LED Minor","Labour",0]
[null,null,"Material",197]
[null,null,"Contractor",75]
[null,"Nostalgia LED","Labour",0]
[null,null,"Material",650]
[null,null,"Contractor",245]

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

{"sheet":"EGX - Forecast capex scenarios","index":13,"n_rows":147,"n_cols":11,"rows_kept":147,"cut":false,"hidden":false,"merged":[[2,5,2,9],[29,5,29,9],[58,5,58,9],[86,5,86,9],[101,5,101,9]]}
[]
["Table 1 - EGX 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"]
["Energex",1,"Major","LED","Labour",{"$f":"'EGX Unit Rates'!$D23*'EGX - Yearly volume scenarios'!K$42","v":0},{"$f":"'EGX Unit Rates'!$D23*'EGX - Yearly volume scenarios'!L$42","v":0},{"$f":"'EGX Unit Rates'!$D23*'EGX - Yearly volume scenarios'!M$42","v":0},{"$f":"'EGX Unit Rates'!$D23*'EGX - Yearly volume scenarios'!N$42","v":0},{"$f":"'EGX Unit Rates'!$D23*'EGX - Yearly volume scenarios'!O$42","v":0}]
[null,1,"Major","LED","Material",{"$f":"'EGX Unit Rates'!$D24*'EGX - Yearly volume scenarios'!K$42","v":2313808},{"$f":"'EGX Unit Rates'!$D24*'EGX - Yearly volume scenarios'!L$42","v":2313808},{"$f":"'EGX Unit Rates'!$D24*'EGX - Yearly volume scenarios'!M$42","v":2313808},{"$f":"'EGX Unit Rates'!$D24*'EGX - Yearly volume scenarios'!N$42","v":2313808},{"$f":"'EGX Unit Rates'!$D24*'EGX - Yearly volume scenarios'!O$42","v":2313808}]
[null,1,"Major","LED","Contractor",{"$f":"'EGX Unit Rates'!$D25*'EGX - Yearly volume scenarios'!K$42","v":297150},{"$f":"'EGX Unit Rates'!$D25*'EGX - Yearly volume scenarios'!L$42","v":297150},{"$f":"'EGX Unit Rates'!$D25*'EGX - Yearly volume scenarios'!M$42","v":297150},{"$f":"'EGX Unit Rates'!$D25*'EGX - Yearly volume scenarios'!N$42","v":297150},{"$f":"'EGX Unit Rates'!$D25*'EGX - Yearly volume scenarios'!O$42","v":297150}]
["Energex",1,"Minor","LED","Labour",{"$f":"'EGX Unit Rates'!$D26*'EGX - Yearly volume scenarios'!K$43","v":0},{"$f":"'EGX Unit Rates'!$D26*'EGX - Yearly volume scenarios'!L$43","v":0},{"$f":"'EGX Unit Rates'!$D26*'EGX - Yearly volume scenarios'!M$43","v":0},{"$f":"'EGX Unit Rates'!$D26*'EGX - Yearly volume scenarios'!N$43","v":0},{"$f":"'EGX Unit Rates'!$D26*'EGX - Yearly volume scenarios'!O$43","v":0}]
[null,1,"Minor","LED","Material",{"$f":"'EGX Unit Rates'!$D27*'EGX - Yearly volume scenarios'!K$43","v":1960347},{"$f":"'EGX Unit Rates'!$D27*'EGX - Yearly volume scenarios'!L$43","v":1960347},{"$f":"'EGX Unit Rates'!$D27*'EGX - Yearly volume scenarios'!M$43","v":1960347},{"$f":"'EGX Unit Rates'!$D27*'EGX - Yearly volume scenarios'!N$43","v":1960347},{"$f":"'EGX Unit Rates'!$D27*'EGX - Yearly volume scenarios'!O$43","v":1960347}]
[null,1,"Minor","LED","Contractor",{"$f":"'EGX Unit Rates'!$D28*'EGX - Yearly volume scenarios'!K$43","v":746325},{"$f":"'EGX Unit Rates'!$D28*'EGX - Yearly volume scenarios'!L$43","v":746325},{"$f":"'EGX Unit Rates'!$D28*'EGX - Yearly volume scenarios'!M$43","v":746325},{"$f":"'EGX Unit Rates'!$D28*'EGX - Yearly volume scenarios'!N$43","v":746325},{"$f":"'EGX Unit Rates'!$D28*'EGX - Yearly volume scenarios'!O$43","v":746325}]
["Energex","2A","Major","LED","Labour",{"$f":"'EGX Unit Rates'!$D23*'EGX - Yearly volume scenarios'!K$44","v":0},{"$f":"'EGX Unit Rates'!$D23*'EGX - Yearly volume scenarios'!L$44","v":0},{"$f":"'EGX Unit Rates'!$D23*'EGX - Yearly volume scenarios'!M$44","v":0},{"$f":"'EGX Unit Rates'!$D23*'EGX - Yearly volume scenarios'!N$44","v":0},{"$f":"'EGX Unit Rates'!$D23*'EGX - Yearly volume scenarios'!O$44","v":0}]
[null,"2A","Major","LED","Material",{"$f":"'EGX Unit Rates'!$D24*'EGX - Yearly volume scenarios'!K$44","v":4720472},{"$f":"'EGX Unit Rates'!$D24*'EGX - Yearly volume scenarios'!L$44","v":4720472},{"$f":"'EGX Unit Rates'!$D24*'EGX - Yearly volume scenarios'!M$44","v":4720472},{"$f":"'EGX Unit Rates'!$D24*'EGX - Yearly volume scenarios'!N$44","v":4720472},{"$f":"'EGX Unit Rates'!$D24*'EGX - Yearly volume scenarios'!O$44","v":4720472}]
[null,"2A","Major","LED","Contractor",{"$f":"'EGX Unit Rates'!$D25*'EGX - Yearly volume scenarios'!K$44","v":606225},{"$f":"'EGX Unit Rates'!$D25*'EGX - Yearly volume scenarios'!L$44","v":606225},{"$f":"'EGX Unit Rates'!$D25*'EGX - Yearly volume scenarios'!M$44","v":606225},{"$f":"'EGX Unit Rates'!$D25*'EGX - Yearly volume scenarios'!N$44","v":606225},{"$f":"'EGX Unit Rates'!$D25*'EGX - Yearly volume scenarios'!O$44","v":606225}]
["Energex","2A","Minor","LED","Labour",{"$f":"'EGX Unit Rates'!$D26*'EGX - Yearly volume scenarios'!K$45","v":0},{"$f":"'EGX Unit Rates'!$D26*'EGX - Yearly volume scenarios'!L$45","v":0},{"$f":"'EGX Unit Rates'!$D26*'EGX - Yearly volume scenarios'!M$45","v":0},{"$f":"'EGX Unit Rates'!$D26*'EGX - Yearly volume scenarios'!N$45","v":0},{"$f":"'EGX Unit Rates'!$D26*'EGX - Yearly volume scenarios'!O$45","v":0}]
[null,"2A","Minor","LED","Material",{"$f":"'EGX Unit Rates'!$D27*'EGX - Yearly volume scenarios'!K$45","v":3541075},{"$f":"'EGX Unit Rates'!$D27*'EGX - Yearly volume scenarios'!L$45","v":3541075},{"$f":"'EGX Unit Rates'!$D27*'EGX - Yearly volume scenarios'!M$45","v":3541075},{"$f":"'EGX Unit Rates'!$D27*'EGX - Yearly volume scenarios'!N$45","v":3541075},{"$f":"'EGX Unit Rates'!$D27*'EGX - Yearly volume scenarios'!O$45","v":3541075}]
[null,"2A","Minor","LED","Contractor",{"$f":"'EGX Unit Rates'!$D28*'EGX - Yearly volume scenarios'!K$45","v":1348125},{"$f":"'EGX Unit Rates'!$D28*'EGX - Yearly volume scenarios'!L$45","v":1348125},{"$f":"'EGX Unit Rates'!$D28*'EGX - Yearly volume scenarios'!M$45","v":1348125},{"$f":"'EGX Unit Rates'!$D28*'EGX - Yearly volume scenarios'!N$45","v":1348125},{"$f":"'EGX Unit Rates'!$D28*'EGX - Yearly volume scenarios'!O$45","v":1348125}]
["Energex",1,"All","LED","Labour",{"$f":"F6+F9","v":0},0,0,0,0]
[null,1,"All","LED","Material",{"$f":"SUMIFS(F$6:F$17,$B$6:$B$17,$B19,$E$6:$E$17,$E19)","v":4274155},4274155,4274155,4274155,4274155]
[null,1,"All","LED","Contractor",1043475,1043475,1043475,1043475,1043475]
["Energex","2A","All","LED","Labour",0,0,0,0,0]
[null,"2A","All","LED","Material",8261547,8261547,8261547,8261547,8261547]
[null,"2A","All","LED","Contractor",1954350,1954350,1954350,1954350,1954350]
["Energex","All","All","LED","Labour",{"$f":"F18+F21","v":0},0,0,0,0]
[null,"All","All","LED","Material",{"$f":"F19+F22","v":12535702},12535702,12535702,12535702,12535702]
[null,"All","All","LED","Contractor",2997825,2997825,2997825,2997825,2997825]
["Energex","All","All","LED","All",{"$f":"SUM(F24:F26)","v":15533527},15533527,15533527,15533527,15533527]
[]
["Table 2 - EGX 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"]
["Energex",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"]
["Energex",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"]
["Energex",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"]
["Energex",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"]
["Energex",1,"All","CONV","Labour",{"$f":"SUMIFS(F$33:F$44,$B$33:$B$44,$B45,$E$33:$E$44,$E45)","v":0},0,0,0,0]
[null,1,"All","CONV","Material",{"$f":"SUMIFS(F$33:F$44,$B$33:$B$44,$B46,$E$33:$E$44,$E46)","v":0},0,0,0,0]
[null,1,"All","CONV","Contractor",0,0,0,0,0]
["Energex",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]
["Energex","All","All","CONV","Labour",{"$f":"SUMIF($E$33:$E$44,$E51,F$33:F$44)","v":0},0,0,0,0]
[null,"All","All","CONV","Material",{"$f":"SUMIF($E$33:$E$44,$E52,F$33:F$44)","v":0},0,0,0,0]
[null,"All","All","CONV","Contractor",0,0,0,0,0]
["Energex","All","All","CONV","All",{"$f":"SUM(F51:F53)","v":0},0,0,0,0]
["Note:"]
["Assumed $0 given that Energy Qld does not have any stocks of conventional lights"]
[]
["Table 3 - EGX  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"]
["Energex",1,"Major","LED","Labour",{"$f":"'EGX - Yearly volume scenarios'!K$55*'EGX Unit Rates'!$D11","v":246668.75317296159},{"$f":"'EGX - Yearly volume scenarios'!L$55*'EGX Unit Rates'!$D11","v":252664.17425702664},{"$f":"'EGX - Yearly volume scenarios'!M$55*'EGX Unit Rates'!$D11","v":258659.59534109168},{"$f":"'EGX - Yearly volume scenarios'!N$55*'EGX Unit Rates'!$D11","v":265511.50515145174},{"$f":"'EGX - Yearly volume scenarios'!O$55*'EGX Unit Rates'!$D11","v":272363.4149618118}]
[null,1,"Major","LED","Material",{"$f":"'EGX - Yearly volume scenarios'!K$55*'EGX Unit Rates'!$D12","v":988865.58477805473},{"$f":"'EGX - Yearly volume scenarios'!L$55*'EGX Unit Rates'!$D12","v":1012900.5121858546},{"$f":"'EGX - Yearly volume scenarios'!M$55*'EGX Unit Rates'!$D12","v":1036935.4395936546},{"$f":"'EGX - Yearly volume scenarios'!N$55*'EGX Unit Rates'!$D12","v":1064403.9280597116},{"$f":"'EGX - Yearly volume scenarios'!O$55*'EGX Unit Rates'!$D12","v":1091872.4165257688}]
[null,1,"Major","LED","Contractor",{"$f":"'EGX - Yearly volume scenarios'!K$55*'EGX Unit Rates'!$D13","v":1710367.8297451569},{"$f":"'EGX - Yearly volume scenarios'!L$55*'EGX Unit Rates'!$D13","v":1751939.2700514628},{"$f":"'EGX - Yearly volume scenarios'!M$55*'EGX Unit Rates'!$D13","v":1793510.7103577687},{"$f":"'EGX - Yearly volume scenarios'!N$55*'EGX Unit Rates'!$D13","v":1841020.9278506897},{"$f":"'EGX - Yearly volume scenarios'!O$55*'EGX Unit Rates'!$D13","v":1888531.1453436108}]
["Energex",1,"Minor","LED","Labour",{"$f":"'EGX - Yearly volume scenarios'!K$56*'EGX Unit Rates'!$D8","v":165533.81780740168},{"$f":"'EGX - Yearly volume scenarios'!L$56*'EGX Unit Rates'!$D8","v":168064.91593901333},{"$f":"'EGX - Yearly volume scenarios'!M$56*'EGX Unit Rates'!$D8","v":170596.01407062498},{"$f":"'EGX - Yearly volume scenarios'!N$56*'EGX Unit Rates'!$D8","v":173127.11220223663},{"$f":"'EGX - Yearly volume scenarios'!O$56*'EGX Unit Rates'!$D8","v":175658.21033384826}]
[null,1,"Minor","LED","Material",{"$f":"'EGX - Yearly volume scenarios'!K$56*'EGX Unit Rates'!$D9","v":275044.95168149954},{"$f":"'EGX - Yearly volume scenarios'!L$56*'EGX Unit Rates'!$D9","v":279250.53198243992},{"$f":"'EGX - Yearly volume scenarios'!M$56*'EGX Unit Rates'!$D9","v":283456.11228338029},{"$f":"'EGX - Yearly volume scenarios'!N$56*'EGX Unit Rates'!$D9","v":287661.69258432067},{"$f":"'EGX - Yearly volume scenarios'!O$56*'EGX Unit Rates'!$D9","v":291867.27288526099}]
[null,1,"Minor","LED","Contractor",{"$f":"'EGX - Yearly volume scenarios'!K$56*'EGX Unit Rates'!$D10","v":1147789.1426083967},{"$f":"'EGX - Yearly volume scenarios'!L$56*'EGX Unit Rates'!$D10","v":1165339.435308831},{"$f":"'EGX - Yearly volume scenarios'!M$56*'EGX Unit Rates'!$D10","v":1182889.7280092651},{"$f":"'EGX - Yearly volume scenarios'!N$56*'EGX Unit Rates'!$D10","v":1200440.0207096995},{"$f":"'EGX - Yearly volume scenarios'!O$56*'EGX Unit Rates'!$D10","v":1217990.3134101336}]
["Energex","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 "]
["Energex","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 "]
["Energex",1,"All","LED","Labour",{"$f":"SUMIFS(F$62:F$73,$B$62:$B$73,$B74,$E$62:$E$73,$E74)","v":412202.57098036329},420729.09019603999,429255.60941171669,438638.61735368834,448021.62529566005]
[null,1,"All","LED","Material",{"$f":"SUMIFS(F$62:F$73,$B$62:$B$73,$B75,$E$62:$E$73,$E75)","v":1263910.5364595542},1292151.0441682944,1320391.5518770348,1352065.6206440323,1383739.6894110297]
[null,1,"All","LED","Contractor",2858156.9723535534,2917278.7053602939,2976400.4383670338,3041460.9485603892,3106521.4587537441]
["Energex","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]
["Energex","All","All","LED","Labour",{"$f":"SUMIF($E$62:$E$73,$E80,F$62:F$73)","v":412202.57098036329},420729.09019603999,429255.60941171669,438638.61735368834,448021.62529566005]
[null,"All","All","LED","Material",{"$f":"SUMIF($E$62:$E$73,$E81,F$62:F$73)","v":1263910.5364595542},1292151.0441682944,1320391.5518770348,1352065.6206440323,1383739.6894110297]
[null,"All","All","LED","Contractor",2858156.9723535534,2917278.7053602939,2976400.4383670338,3041460.9485603892,3106521.4587537441]
["Energex","All","All","LED","All",{"$f":"SUM(F80:F82)","v":4534270.0797934709},{"$f":"SUM(G80:G82)","v":4630158.8397246283},4726047.5996557856,4832165.1865581097,4938282.7734604338]
[]
[]
["Table 4 - EGX 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"]
["Energex",1,"Minor","LED","Labour",{"$f":"'EGX - Yearly volume scenarios'!K$65*'EGX Unit Rates'!$D29","v":0},{"$f":"'EGX - Yearly volume scenarios'!L$65*'EGX Unit Rates'!$D29","v":0},{"$f":"'EGX - Yearly volume scenarios'!M$65*'EGX Unit Rates'!$D29","v":0},{"$f":"'EGX - Yearly volume scenarios'!N$65*'EGX Unit Rates'!$D29","v":0},{"$f":"'EGX - Yearly volume scenarios'!O$65*'EGX Unit Rates'!$D29","v":0}]
[null,1,"Minor","LED","Material",{"$f":"'EGX - Yearly volume scenarios'!K$65*'EGX Unit Rates'!$D30","v":70200},{"$f":"'EGX - Yearly volume scenarios'!L$65*'EGX Unit Rates'!$D30","v":70200},{"$f":"'EGX - Yearly volume scenarios'!M$65*'EGX Unit Rates'!$D30","v":70200},{"$f":"'EGX - Yearly volume scenarios'!N$65*'EGX Unit Rates'!$D30","v":70200},{"$f":"'EGX - Yearly volume scenarios'!O$65*'EGX Unit Rates'!$D30","v":70200}]
[null,1,"Minor","LED","Contractor",{"$f":"'EGX - Yearly volume scenarios'!K$65*'EGX Unit Rates'!$D31","v":26460},{"$f":"'EGX - Yearly volume scenarios'!L$65*'EGX Unit Rates'!$D31","v":26460},{"$f":"'EGX - Yearly volume scenarios'!M$65*'EGX Unit Rates'!$D31","v":26460},{"$f":"'EGX - Yearly volume scenarios'!N$65*'EGX Unit Rates'!$D31","v":26460},{"$f":"'EGX - Yearly volume scenarios'!O$65*'EGX Unit Rates'!$D31","v":26460}]
["Energex","2A","Minor","LED","Labour",{"$f":"'EGX - Yearly volume scenarios'!K$66*'EGX Unit Rates'!$D29","v":0},{"$f":"'EGX - Yearly volume scenarios'!L$66*'EGX Unit Rates'!$D29","v":0},{"$f":"'EGX - Yearly volume scenarios'!M$66*'EGX Unit Rates'!$D29","v":0},{"$f":"'EGX - Yearly volume scenarios'!N$66*'EGX Unit Rates'!$D29","v":0},{"$f":"'EGX - Yearly volume scenarios'!O$66*'EGX Unit Rates'!$D29","v":0}]
[null,"2A","Minor","LED","Material",{"$f":"'EGX - Yearly volume scenarios'!K$66*'EGX Unit Rates'!$D30","v":5308550},{"$f":"'EGX - Yearly volume scenarios'!L$66*'EGX Unit Rates'!$D30","v":5308550},{"$f":"'EGX - Yearly volume scenarios'!M$66*'EGX Unit Rates'!$D30","v":5308550},{"$f":"'EGX - Yearly volume scenarios'!N$66*'EGX Unit Rates'!$D30","v":5308550},{"$f":"'EGX - Yearly volume scenarios'!O$66*'EGX Unit Rates'!$D30","v":5308550}]
[null,"2A","Minor","LED","Contractor",{"$f":"'EGX - Yearly volume scenarios'!K$66*'EGX Unit Rates'!$D31","v":2000915},{"$f":"'EGX - Yearly volume scenarios'!L$66*'EGX Unit Rates'!$D31","v":2000915},{"$f":"'EGX - Yearly volume scenarios'!M$66*'EGX Unit Rates'!$D31","v":2000915},{"$f":"'EGX - Yearly volume scenarios'!N$66*'EGX Unit Rates'!$D31","v":2000915},{"$f":"'EGX - Yearly volume scenarios'!O$66*'EGX Unit Rates'!$D31","v":2000915}]
["Energex","All","All","All","Labour",{"$f":"F90+F93","v":0},0,0,0,0]
[null,"All","All","All","Material",{"$f":"F91+F94","v":5378750},5378750,5378750,5378750,5378750]
[null,"All","All","All","Contractor",{"$f":"F92+F95","v":2027375},2027375,2027375,2027375,2027375]
["Energex","All","All","All","All",{"$f":"SUM(F96:F98)","v":7406125},7406125,7406125,7406125,7406125]
[]
["Table 5 - EGX Pole replacements"]
["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"]
["Energex",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]
[null,1,"Minor","All","Labour",0,0,0,0,0]
[null,1,"Minor","All","Material",0,0,0,0,0]
[null,1,"Minor","All","Contractor",0,0,0,0,0]
["Energex",2,"Major","All","Labour",0,0,0,0,0]
[null,2,"Major","All","Material",0,0,0,0,0]
[null,2,"Major","All","Contractor",0,0,0,0,0]
[null,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]
["Energex","All","All","All","Labour",{"$f":"F105+F108+F111+F114","v":0},0,0,0,0]
[null,"All","All","All","Material",{"$f":"F106+F109+F112+F115","v":0},0,0,0,0]
[null,"All","All","All","Contractor",0,0,0,0,0]
["Energex","All","All","All","All",{"$f":"SUM(F117:F119)","v":0},0,0,0,0]
[]
["Table 6 - EGX 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"]
["Energex",1,"Major","All","Labour",{"$f":"SUMIFS(F$6:F$120,$B$6:$B$120,$B126,$C$6:$C$120,$C126,$E$6:$E$120,$E126)","v":246668.75317296159},252664.17425702664,258659.59534109168,265511.50515145174,272363.4149618118]
[null,1,"Major","All","Material",3302673.5847780546,3326708.5121858548,3350743.4395936546,3378211.9280597116,3405680.416525769]
[null,1,"Major","All","Contractor",2007517.8297451569,2049089.2700514628,2090660.7103577687,2138170.9278506897,2185681.145343611]
["Energex","2A","Major","All","Labour",0,0,0,0,0]
[null,"2A","Major","All","Material",4720472,4720472,4720472,4720472,4720472]
[null,"2A","Major","All","Contractor",606225,606225,606225,606225,606225]
["Energex",1,"Minor","All","Labour",165533.81780740168,168064.91593901333,170596.01407062498,173127.11220223663,175658.21033384826]
[null,1,"Minor","All","Material",2305591.9516814994,2309797.53198244,2314003.1122833802,2318208.6925843209,2322414.2728852611]
[null,1,"Minor","All","Contractor",1920574.1426083967,1938124.435308831,1955674.7280092651,1973225.0207096995,1990775.3134101336]
["Energex","2A","Minor","All","Labour",0,0,0,0,0]
[null,"2A","Minor","All","Material",8849625,8849625,8849625,8849625,8849625]
[null,"2A","Minor","All","Contractor",3349040,3349040,3349040,3349040,3349040]
["Energex",1,"All","All","Labour",{"$f":"SUMIFS(F$126:F$137,$B$126:$B$137,$B138,$E$126:$E$137,$E138)","v":412202.57098036329},420729.09019603999,429255.60941171669,438638.61735368834,448021.62529566005]
[null,1,"All","All","Material",{"$f":"SUMIFS(F$126:F$137,$B$126:$B$137,$B139,$E$126:$E$137,$E139)","v":5608265.536459554},5636506.0441682953,5664746.5518770348,5696420.620644033,5728094.6894110302]
[null,1,"All","All","Contractor",3928091.9723535534,3987213.7053602939,4046335.4383670338,4111395.9485603892,4176456.4587537446]
["Energex","2A","All","All","Labour",0,0,0,0,0]
[null,"2A","All","All","Material",13570097,13570097,13570097,13570097,13570097]
[null,"2A","All","All","Contractor",3955265,3955265,3955265,3955265,3955265]
["Energex","All","All","All","Labour",{"$f":"SUMIFS(F$6:F$120,$B$6:$B$120,$B144,$C$6:$C$120,$C144,$E$6:$E$120,$E144)","v":412202.57098036329},420729.09019603999,429255.60941171669,438638.61735368834,448021.62529566005]
[null,"All","All","All","Material",19178362.536459554,19206603.044168293,19234843.551877037,19266517.620644033,19298191.689411029]
[null,"All","All","All","Contractor",7883356.9723535534,7942478.7053602934,8001600.4383670334,8066660.9485603888,8131721.4587537441]
["Energex","All","All","All","All",{"$f":"SUM(F144:F146)","v":27473922.079793468},27569810.839724626,27665699.599655785,27771817.186558113,27877934.773460433]

{"sheet":"EGX - Gross Capex","index":14,"n_rows":82,"n_cols":8,"rows_kept":82,"cut":false,"hidden":false,"merged":[[1,1,1,5],[36,1,36,5],[59,1,59,5]]}
["1 - This tables applies the oncosts and overheads to the capex (direct cost) for both RATE 1 and RATE 2A LED conversions funded by Energex"]
[null,"100%  LED deployment by 2030"]
[null,"2025-26","2026-27","2027-28","2028-29","2029-30"]
["Direct Costs ($Real 2024-25)"]
["Labour",{"$f":"'EGX - Forecast capex scenarios'!F144*'Cost Escalations'!$E$21*(1+'Cost Escalations'!B30)","v":459559.36224893975},{"$f":"'EGX - Forecast capex scenarios'!G144*'Cost Escalations'!$E$21*(1+'Cost Escalations'!C30)","v":473690.97108932381},{"$f":"'EGX - Forecast capex scenarios'!H144*'Cost Escalations'!$E$21*(1+'Cost Escalations'!D30)","v":487371.55813236028},{"$f":"'EGX - Forecast capex scenarios'!I144*'Cost Escalations'!$E$21*(1+'Cost Escalations'!E30)","v":503260.38362324622},{"$f":"'EGX - Forecast capex scenarios'!J144*'Cost Escalations'!$E$21*(1+'Cost Escalations'!F30)","v":520382.91745841986}]
["Contractors",{"$f":"'EGX - Forecast capex scenarios'!F146*'Cost Escalations'!$E$21*(1+'Cost Escalations'!B26)","v":8751669.5560389645},{"$f":"'EGX - Forecast capex scenarios'!G146*'Cost Escalations'!$E$21*(1+'Cost Escalations'!C26)","v":8879906.1071561426},{"$f":"'EGX - Forecast capex scenarios'!H146*'Cost Escalations'!$E$21*(1+'Cost Escalations'!D26)","v":9000576.4398324415},{"$f":"'EGX - Forecast capex scenarios'!I146*'Cost Escalations'!$E$21*(1+'Cost Escalations'!E26)","v":9157238.149061393},{"$f":"'EGX - Forecast capex scenarios'!J146*'Cost Escalations'!$E$21*(1+'Cost Escalations'!F26)","v":9331713.4856938627}]
["Materials",{"$f":"'EGX - Forecast capex scenarios'!F145*'Cost Escalations'!$E$21","v":21069533.73329065},{"$f":"'EGX - Forecast capex scenarios'!G145*'Cost Escalations'!$E$21","v":21100559.026961233},{"$f":"'EGX - Forecast capex scenarios'!H145*'Cost Escalations'!$E$21","v":21131584.320631817},{"$f":"'EGX - Forecast capex scenarios'!I145*'Cost Escalations'!$E$21","v":21166381.757539589},{"$f":"'EGX - Forecast capex scenarios'!J145*'Cost Escalations'!$E$21","v":21201179.194447357}]
["Total Direct Costs",{"$f":"SUM(B5:B7)","v":30280762.651578553},30454156.105206698,30619532.318596616,30826880.290224228,31053275.59759964]
[]
["Overheads & Oncosts",null,null,null,null,null,null,"Note: application of the overhead and on-cost rates in accordance with the EQL's Cost Allocation Methodology"]
["Fleet oncost",{"$f":"B5*Overheads!$D$15","v":97261.301922225306},{"$f":"C5*Overheads!$D$15","v":100252.12049100651},{"$f":"D5*Overheads!$D$15","v":103147.48465104571},{"$f":"E5*Overheads!$D$15","v":106510.20115777961},{"$f":"F5*Overheads!$D$15","v":110134.020123988}]
["Material oncosts",{"$f":"B7*Overheads!$D$9","v":1836571.469075724},{"$f":"C7*Overheads!$D$9","v":1839275.8558882833},{"$f":"D7*Overheads!$D$9","v":1841980.2427008429},{"$f":"E7*Overheads!$D$9","v":1845013.4365356357},{"$f":"F7*Overheads!$D$9","v":1848046.6303704283}]
["Network overheads",{"$f":"(B8+B11+B12)*Overheads!$D$19","v":6406450.1228632489},{"$f":"(C8+C11+C12)*Overheads!$D$19","v":6442065.1149643352},{"$f":"(D8+D11+D12)*Overheads!$D$19","v":6476066.7522200132},{"$f":"(E8+E11+E12)*Overheads!$D$19","v":6518573.5570064802},{"$f":"(F8+F11+F12)*Overheads!$D$19","v":6564920.1910598576}]
["Non-network overheads",{"$f":"B5*Overheads!$D$20","v":201513.83300174653},{"$f":"C5*Overheads!$D$20","v":207710.45284639802},{"$f":"D5*Overheads!$D$20","v":213709.30252550208},{"$f":"E5*Overheads!$D$20","v":220676.45060164088},{"$f":"F5*Overheads!$D$20","v":228184.57187446757}]
["Non-network depreciation",{"$f":"B5*Overheads!$D$25","v":67585.155204382303},{"$f":"C5*Overheads!$D$25","v":69663.422029566937},{"$f":"D5*Overheads!$D$25","v":71675.359277599389},{"$f":"E5*Overheads!$D$25","v":74012.051389716944},{"$f":"F5*Overheads!$D$25","v":76530.178974104259}]
["Corporate overheads",{"$f":"0*Overheads!$D$26","v":0},{"$f":"0*Overheads!$D$26","v":0},{"$f":"0*Overheads!$D$26","v":0},{"$f":"0*Overheads!$D$26","v":0},{"$f":"0*Overheads!$D$26","v":0},null,"No allocation of corporate overheads to capex"]
["Market",{"$f":"0*Overheads!$D$27","v":0},{"$f":"0*Overheads!$D$27","v":0},{"$f":"0*Overheads!$D$27","v":0},{"$f":"0*Overheads!$D$27","v":0},{"$f":"0*Overheads!$D$27","v":0},null,"No market allocation to capex"]
["Customer ops",{"$f":"0*Overheads!$D$28","v":0},{"$f":"0*Overheads!$D$28","v":0},{"$f":"0*Overheads!$D$28","v":0},{"$f":"0*Overheads!$D$28","v":0},{"$f":"0*Overheads!$D$28","v":0},null,"No customer operation allocation to capex"]
["Total",{"$f":"SUM(B11:B18)","v":8609381.8820673265},8658966.9662195891,8706579.1413750015,8764785.6966912523,8827815.5924028456]
[]
["Total Expenditure (incl oncosts and overheads)",{"$f":"B8+B19","v":38890144.533645883},39113123.071426287,39326111.459971622,39591665.986915484,39881091.190002486]
[]
["LED",{"$f":"('EGX - Forecast capex scenarios'!F$147-'EGX - Forecast capex scenarios'!F$54)/'EGX - Forecast capex scenarios'!F$147","v":1},{"$f":"('EGX - Forecast capex scenarios'!G$147-'EGX - Forecast capex scenarios'!G$54)/'EGX - Forecast capex scenarios'!G$147","v":1},{"$f":"('EGX - Forecast capex scenarios'!H$147-'EGX - Forecast capex scenarios'!H$54)/'EGX - Forecast capex scenarios'!H$147","v":1},{"$f":"('EGX - Forecast capex scenarios'!I$147-'EGX - Forecast capex scenarios'!I$54)/'EGX - Forecast capex scenarios'!I$147","v":1},{"$f":"('EGX - Forecast capex scenarios'!J$147-'EGX - Forecast capex scenarios'!J$54)/'EGX - Forecast capex scenarios'!J$147","v":1}]
["CON ",{"$f":"1-B23","v":0},{"$f":"1-C23","v":0},0,0,0]
[]
["LED",{"$f":"B23*B21","v":38890144.533645883},39113123.071426287,39326111.459971622,39591665.986915484,39881091.190002486]
["CON",{"$f":"B24*B21","v":0},0,0,0,0]
[]
["Immediate Expensing"]
[]
["LED",{"$f":"B23*B19","v":8609381.8820673265},8658966.9662195891,8706579.1413750015,8764785.6966912523,8827815.5924028456]
["CON",0,0,0,0,0]
[]
[]
[]
["2 - This tables applies the oncosts and overheads to the capex (direct cost) for RATE 1 conversions funded by Energex"]
[null,"100%  LED deployment by 2030"]
[null,"2025-26","2026-27","2027-28","2028-29","2029-30"]
["Direct Costs ($Real 2024-25)"]
["Labour",{"$f":"'EGX - Forecast capex scenarios'!F138*'Cost Escalations'!$E$21*(1+'Cost Escalations'!B30)","v":459559.36224893975},{"$f":"'EGX - Forecast capex scenarios'!G138*'Cost Escalations'!$E$21*(1+'Cost Escalations'!C30)","v":473690.97108932381},{"$f":"'EGX - Forecast capex scenarios'!H138*'Cost Escalations'!$E$21*(1+'Cost Escalations'!D30)","v":487371.55813236028},{"$f":"'EGX - Forecast capex scenarios'!I138*'Cost Escalations'!$E$21*(1+'Cost Escalations'!E30)","v":503260.38362324622},{"$f":"'EGX - Forecast capex scenarios'!J138*'Cost Escalations'!$E$21*(1+'Cost Escalations'!F30)","v":520382.91745841986}]
["Contractors",{"$f":"'EGX - Forecast capex scenarios'!F140*'Cost Escalations'!$E$21*(1+'Cost Escalations'!B26)","v":4360751.7772348663},{"$f":"'EGX - Forecast capex scenarios'!G140*'Cost Escalations'!$E$21*(1+'Cost Escalations'!C26)","v":4457812.8121225387},{"$f":"'EGX - Forecast capex scenarios'!H140*'Cost Escalations'!$E$21*(1+'Cost Escalations'!D26)","v":4551508.3756991327},{"$f":"'EGX - Forecast capex scenarios'!I140*'Cost Escalations'!$E$21*(1+'Cost Escalations'!E26)","v":4667238.6587380571},{"$f":"'EGX - Forecast capex scenarios'!J140*'Cost Escalations'!$E$21*(1+'Cost Escalations'!F26)","v":4792773.0009260029}]
["Materials",{"$f":"'EGX - Forecast capex scenarios'!F139*'Cost Escalations'!$E$21","v":6161294.5151624866},{"$f":"'EGX - Forecast capex scenarios'!G139*'Cost Escalations'!$E$21","v":6192319.8088330701},{"$f":"'EGX - Forecast capex scenarios'!H139*'Cost Escalations'!$E$21","v":6223345.1025036518},{"$f":"'EGX - Forecast capex scenarios'!I139*'Cost Escalations'!$E$21","v":6258142.5394114237},{"$f":"'EGX - Forecast capex scenarios'!J139*'Cost Escalations'!$E$21","v":6292939.9763191957}]
["Total Direct Costs",{"$f":"SUM(B40:B42)","v":10981605.654646292},11123823.592044933,11262225.036335144,11428641.581772726,11606095.894703619]
[]
["Overheads & Oncosts"]
["Fleet oncost",{"$f":"B40*Overheads!$D$15","v":97261.301922225306},{"$f":"C40*Overheads!$D$15","v":100252.12049100651},{"$f":"D40*Overheads!$D$15","v":103147.48465104571},{"$f":"E40*Overheads!$D$15","v":106510.20115777961},{"$f":"F40*Overheads!$D$15","v":110134.020123988}]
["Material oncosts",{"$f":"B42*Overheads!$D$9","v":537062.55973007157},{"$f":"C42*Overheads!$D$9","v":539766.94654263114},{"$f":"D42*Overheads!$D$9","v":542471.33335519047},{"$f":"E42*Overheads!$D$9","v":545504.52718998329},{"$f":"F42*Overheads!$D$9","v":548537.72102477611}]
["Network overheads",{"$f":"(B43+B46+B47)*Overheads!$D$19","v":2310035.9355967389},{"$f":"(C43+C46+C47)*Overheads!$D$19","v":2339451.1171101416},{"$f":"(D43+D46+D47)*Overheads!$D$19","v":2368088.3376923795},{"$f":"(E43+E46+E47)*Overheads!$D$19","v":2402455.194206818},{"$f":"(F43+F46+F47)*Overheads!$D$19","v":2439069.0336756506}]
["Non-network overheads",{"$f":"B40*Overheads!$D$20","v":201513.83300174653},{"$f":"C40*Overheads!$D$20","v":207710.45284639802},{"$f":"D40*Overheads!$D$20","v":213709.30252550208},{"$f":"E40*Overheads!$D$20","v":220676.45060164088},{"$f":"F40*Overheads!$D$20","v":228184.57187446757}]
["Non-network depreciation",{"$f":"B40*Overheads!$D$25","v":67585.155204382303},{"$f":"C40*Overheads!$D$25","v":69663.422029566937},{"$f":"D40*Overheads!$D$25","v":71675.359277599389},{"$f":"E40*Overheads!$D$25","v":74012.051389716944},{"$f":"F40*Overheads!$D$25","v":76530.178974104259}]
["Corporate overheads",{"$f":"0*Overheads!$D$26","v":0},{"$f":"0*Overheads!$D$26","v":0},{"$f":"0*Overheads!$D$26","v":0},{"$f":"0*Overheads!$D$26","v":0},{"$f":"0*Overheads!$D$26","v":0},null,"No allocation of corporate overheads to capex"]
["Market",{"$f":"0*Overheads!$D$27","v":0},{"$f":"0*Overheads!$D$27","v":0},{"$f":"0*Overheads!$D$27","v":0},{"$f":"0*Overheads!$D$27","v":0},{"$f":"0*Overheads!$D$27","v":0},null,"No market allocation to capex"]
["Customer ops",{"$f":"0*Overheads!$D$28","v":0},{"$f":"0*Overheads!$D$28","v":0},{"$f":"0*Overheads!$D$28","v":0},{"$f":"0*Overheads!$D$28","v":0},{"$f":"0*Overheads!$D$28","v":0},null,"No customer operation allocation to capex"]
["Total",{"$f":"SUM(B46:B53)","v":3213458.7854551645},{"$f":"SUM(C46:C53)","v":3256844.0590197444},{"$f":"SUM(D46:D53)","v":3299091.8175017172},{"$f":"SUM(E46:E53)","v":3349158.4245459391},{"$f":"SUM(F46:F53)","v":3402455.5256729866}]
[]
["Total Expenditure (incl oncosts and overheads)",{"$f":"B43+B54","v":14195064.440101456},14380667.651064677,14561316.853836861,14777800.006318666,{"$f":"F43+F54","v":15008551.420376606}]
[]
[]
["3 - This tables applies the oncosts and overheads to the capex (direct cost) for RATE 2A conversions funded by Energex"]
[null,"100%  LED deployment by 2030"]
[null,"2025-26","2026-27","2027-28","2028-29","2029-30"]
["Direct Costs ($Real 2024-25)"]
["Labour",{"$f":"'EGX - Forecast capex scenarios'!F141*'Cost Escalations'!$E$21*(1+'Cost Escalations'!B30)","v":0},{"$f":"'EGX - Forecast capex scenarios'!G141*'Cost Escalations'!$E$21*(1+'Cost Escalations'!C30)","v":0},{"$f":"'EGX - Forecast capex scenarios'!H141*'Cost Escalations'!$E$21*(1+'Cost Escalations'!D30)","v":0},{"$f":"'EGX - Forecast capex scenarios'!I141*'Cost Escalations'!$E$21*(1+'Cost Escalations'!E30)","v":0},{"$f":"'EGX - Forecast capex scenarios'!J141*'Cost Escalations'!$E$21*(1+'Cost Escalations'!F30)","v":0}]
["Contractors",{"$f":"'EGX - Forecast capex scenarios'!F143*'Cost Escalations'!$E$21*(1+'Cost Escalations'!B26)","v":4390917.7788040964},{"$f":"'EGX - Forecast capex scenarios'!G143*'Cost Escalations'!$E$21*(1+'Cost Escalations'!C26)","v":4422093.2950336058},{"$f":"'EGX - Forecast capex scenarios'!H143*'Cost Escalations'!$E$21*(1+'Cost Escalations'!D26)","v":4449068.0641333107},{"$f":"'EGX - Forecast capex scenarios'!I143*'Cost Escalations'!$E$21*(1+'Cost Escalations'!E26)","v":4489999.4903233368},{"$f":"'EGX - Forecast capex scenarios'!J143*'Cost Escalations'!$E$21*(1+'Cost Escalations'!F26)","v":4538940.4847678607}]
["Materials",{"$f":"'EGX - Forecast capex scenarios'!F142*'Cost Escalations'!$E$21","v":14908239.218128163},{"$f":"'EGX - Forecast capex scenarios'!G142*'Cost Escalations'!$E$21","v":14908239.218128163},{"$f":"'EGX - Forecast capex scenarios'!H142*'Cost Escalations'!$E$21","v":14908239.218128163},{"$f":"'EGX - Forecast capex scenarios'!I142*'Cost Escalations'!$E$21","v":14908239.218128163},{"$f":"'EGX - Forecast capex scenarios'!J142*'Cost Escalations'!$E$21","v":14908239.218128163}]
["Total Direct Costs",{"$f":"SUM(B63:B65)","v":19299156.996932261},19330332.513161771,19357307.282261476,19398238.708451502,19447179.702896025]
[]
["Overheads & Oncosts"]
["Fleet oncost",{"$f":"B63*Overheads!$D$15","v":0},{"$f":"C63*Overheads!$D$15","v":0},{"$f":"D63*Overheads!$D$15","v":0},{"$f":"E63*Overheads!$D$15","v":0},{"$f":"F63*Overheads!$D$15","v":0}]
["Material oncosts",{"$f":"B65*Overheads!$D$9","v":1299508.9093456522},{"$f":"C65*Overheads!$D$9","v":1299508.9093456522},{"$f":"D65*Overheads!$D$9","v":1299508.9093456522},{"$f":"E65*Overheads!$D$9","v":1299508.9093456522},{"$f":"F65*Overheads!$D$9","v":1299508.9093456522}]
["Network overheads",{"$f":"(B66+B69+B70)*Overheads!$D$19","v":4096414.1872665104},{"$f":"(C66+C69+C70)*Overheads!$D$19","v":4102613.9978541951},{"$f":"(D66+D69+D70)*Overheads!$D$19","v":4107978.4145276356},{"$f":"(E66+E69+E70)*Overheads!$D$19","v":4116118.3627996631},{"$f":"(F66+F69+F70)*Overheads!$D$19","v":4125851.1573842079}]
["Non-network overheads",{"$f":"B63*Overheads!$D$20","v":0},{"$f":"C63*Overheads!$D$20","v":0},{"$f":"D63*Overheads!$D$20","v":0},{"$f":"E63*Overheads!$D$20","v":0},{"$f":"F63*Overheads!$D$20","v":0}]
["Non-network depreciation",{"$f":"B63*Overheads!$D$25","v":0},{"$f":"C63*Overheads!$D$25","v":0},{"$f":"D63*Overheads!$D$25","v":0},{"$f":"E63*Overheads!$D$25","v":0},{"$f":"F63*Overheads!$D$25","v":0}]
["Corporate overheads",{"$f":"0*Overheads!$D$26","v":0},{"$f":"0*Overheads!$D$26","v":0},{"$f":"0*Overheads!$D$26","v":0},{"$f":"0*Overheads!$D$26","v":0},{"$f":"0*Overheads!$D$26","v":0}]
["Market",{"$f":"0*Overheads!$D$27","v":0},{"$f":"0*Overheads!$D$27","v":0},{"$f":"0*Overheads!$D$27","v":0},{"$f":"0*Overheads!$D$27","v":0},{"$f":"0*Overheads!$D$27","v":0}]
["Customer ops",{"$f":"0*Overheads!$D$28","v":0},{"$f":"0*Overheads!$D$28","v":0},{"$f":"0*Overheads!$D$28","v":0},{"$f":"0*Overheads!$D$28","v":0},{"$f":"0*Overheads!$D$28","v":0}]
["Total",{"$f":"SUM(B69:B76)","v":5395923.0966121629},{"$f":"SUM(C69:C76)","v":5402122.9071998475},{"$f":"SUM(D69:D76)","v":5407487.323873288},{"$f":"SUM(E69:E76)","v":5415627.2721453151},{"$f":"SUM(F69:F76)","v":5425360.0667298604}]
[]
["Total Expenditure (incl oncosts and overheads)",{"$f":"B66+B77","v":24695080.093544424},24732455.420361619,24764794.606134765,24813865.980596818,{"$f":"F66+F77","v":24872539.769625887}]
[]
[null,{"$f":"B56+B79","v":38890144.533645883},{"$f":"C56+C79","v":39113123.071426295},39326111.459971622,39591665.986915484,39881091.190002494]
[null,{"$f":"B21-B81","v":0},{"$f":"C21-C81","v":0},0,0,0]

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

{"sheet":"EGX - Opex BST","index":16,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Energex - 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":"'EGX - Yearly volume scenarios'!K83","v":172291},{"$f":"'EGX - Yearly volume scenarios'!L83","v":128897},{"$f":"'EGX - Yearly volume scenarios'!M83","v":93556},{"$f":"'EGX - Yearly volume scenarios'!N83","v":58441},{"$f":"'EGX - Yearly volume scenarios'!O83","v":0}]
["LED",null,null,null,{"$f":"'EGX - Yearly volume scenarios'!K84+'EGX - Yearly volume scenarios'!K104","v":184781},{"$f":"'EGX - Yearly volume scenarios'!L84+'EGX - Yearly volume scenarios'!L104","v":228876},{"$f":"'EGX - Yearly volume scenarios'!M84+'EGX - Yearly volume scenarios'!M104","v":264931},{"$f":"'EGX - Yearly volume scenarios'!N84+'EGX - Yearly volume scenarios'!N104","v":300775},{"$f":"'EGX - Yearly volume scenarios'!O84+'EGX - Yearly volume scenarios'!O104","v":359959}]
["Total",null,null,null,{"$f":"SUM(E5:E6)","v":357072},{"$f":"SUM(F5:F6)","v":357773},{"$f":"SUM(G5:G6)","v":358487},{"$f":"SUM(H5:H6)","v":359216},{"$f":"SUM(I5:I6)","v":359959}]
[]
["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.4816502818954524E-2},{"$f":"'Cost Escalations'!C29","v":9.8611007932502479E-3},{"$f":"'Cost Escalations'!D29","v":8.4436518056068104E-3},{"$f":"'Cost Escalations'!E29","v":1.0512472688202901E-2},{"$f":"'Cost Escalations'!F29","v":1.2367452017459594E-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('EGX - Forecast Opex'!B4,'EGX - Forecast Opex'!B9)/(SUM('EGX - Forecast Opex'!B4:B12)-'EGX - Forecast Opex'!B15)","v":0.11495466503112957},{"$f":"E18","v":0.11495466503112957},0.11495466503112957,0.11495466503112957,0.11495466503112957]
["Contractor",null,null,null,{"$f":"SUM('EGX - Forecast Opex'!B5,'EGX - Forecast Opex'!B10)/(SUM('EGX - Forecast Opex'!B4:B12)-'EGX - Forecast Opex'!B15)","v":0.63655631329690932},0.63655631329690932,0.63655631329690932,0.63655631329690932,0.63655631329690932]
["Materials/other",null,null,null,{"$f":"(SUM('EGX - Forecast Opex'!B6,'EGX - Forecast Opex'!B7,'EGX - Forecast Opex'!B11,'EGX - Forecast Opex'!B12)-'EGX - Forecast Opex'!B15)/(SUM('EGX - Forecast Opex'!B3:B12)-'EGX - Forecast Opex'!B15)","v":0.2484890216719613},0.2484890216719613,0.2484890216719613,0.2484890216719613,0.2484890216719613]
[]
["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.3870674081032524E-3},{"$f":"SUMPRODUCT(F12:F14,F18:F20)","v":5.6531293629343438E-3},{"$f":"SUMPRODUCT(G12:G14,G18:G20)","v":4.8536306760641702E-3},{"$f":"SUMPRODUCT(H12:H14,H18:H20)","v":7.064775858852828E-3},{"$f":"SUMPRODUCT(I12:I14,I18:I20)","v":8.3601601188919468E-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":"'EGX - Yearly volume scenarios'!J85","v":344949},{"$f":"'EGX - Yearly volume scenarios'!K85+'EGX - Yearly volume scenarios'!K104","v":357072},{"$f":"'EGX - Yearly volume scenarios'!L85+'EGX - Yearly volume scenarios'!L104","v":357773},{"$f":"'EGX - Yearly volume scenarios'!M85+'EGX - Yearly volume scenarios'!M104","v":358487},{"$f":"'EGX - Yearly volume scenarios'!N85+'EGX - Yearly volume scenarios'!N104","v":359216},{"$f":"'EGX - Yearly volume scenarios'!O85+'EGX - Yearly volume scenarios'!O104","v":359959}]
["Growth Rate",null,null,null,{"$f":"LN(E28)-LN(D28)","v":3.4540862100046255E-2},{"$f":"LN(F28)-LN(E28)","v":1.9612649587052999E-3},{"$f":"LN(G28)-LN(F28)","v":1.9936901027577392E-3},{"$f":"LN(H28)-LN(G28)","v":2.0314816873003849E-3},{"$f":"LN(I28)-LN(H28)","v":2.0662572095755394E-3}]
["Factor",null,null,{"$f":"1-(SUM('EGX - Forecast Opex'!C4:C7)/SUM('EGX - Forecast Opex'!C3:C12))","v":0.20553347091248031},{"$f":"SUMPRODUCT($D$30,E29)","v":7.0993032757318501E-3},{"$f":"SUMPRODUCT($D$30,F29)","v":4.0310559434172266E-4},{"$f":"SUMPRODUCT($D$30,G29)","v":4.0977004674365767E-4},{"$f":"SUMPRODUCT($D$30,H29)","v":4.1753748228599006E-4},{"$f":"SUMPRODUCT($D$30,I29)","v":4.2468501608199685E-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":-2.5075923501799213E-2},{"$f":"(1+F24)*(1+F30)*(1-F34)-1","v":-3.4183826785266214E-2},{"$f":"(1+G24)*(1+G30)*(1-G34)-1","v":-3.4945225988534334E-2},{"$f":"(1+H24)*(1+H30)*(1-H34)-1","v":-3.2814147376130753E-2},{"$f":"(1+I24)*(1+I30)*(1-I34)-1","v":-3.1563140253080046E-2}]
["Rate of Change - Cumulative",null,null,null,{"$f":"PRODUCT(1+$D38:E38)-1","v":-2.5075923501799213E-2},{"$f":"PRODUCT(1+$D38:F38)-1","v":-5.8402559261599318E-2},{"$f":"PRODUCT(1+$D38:G38)-1","v":-9.1306894618428336E-2},{"$f":"PRODUCT(1+$D38:H38)-1","v":-0.12112488409809319},{"$f":"PRODUCT(1+$D38:I38)-1","v":-0.14886494264624706}]

{"sheet":"EGX - Forecast Opex","index":17,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Table 1 - Opex Direct Costs","Actual","Forecast "]
["Opex Direct Costs","2022-23","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30"]
["Maintenance","Adjusted"]
["   Labour",871863.59000000008,{"$f":"B4*'Cost Escalations'!$E$21","v":957837.73434309382}]
["   Contractor",6530695.4500000011,{"$f":"B5*'Cost Escalations'!$E$21","v":7174684.899403532}]
["   Materials",1898621.2599999998,{"$f":"B6*'Cost Escalations'!$E$21","v":2085843.5963061948}]
["   Other",1011.36,{"$f":"B7*'Cost Escalations'!$E$21","v":1111.089833451161}]
["Damage/Emergency"]
["   Labour",554577.46,{"$f":"B9*'Cost Escalations'!$E$21","v":609264.13707005209}]
["   Contractor",1368158.03,{"$f":"B10*'Cost Escalations'!$E$21","v":1503071.5844877872}]
["   Materials",476783.69000000006,{"$f":"B11*'Cost Escalations'!$E$21","v":523799.15234370553}]
["Other",7016.1100000000006,{"$f":"B12*'Cost Escalations'!$E$21","v":7707.9659976418152}]
["Total direct opex",11708726.949999999,{"$f":"SUM(C4:C12)","v":12863320.159785459}]
["Adjustments (material costs)"]
["LED Lamps",-700000,{"$f":"B15*'Cost Escalations'!$E$21","v":-769026.73965335067}]
["Base Opex",{"$f":"+B15+B13","v":11008726.949999999},{"$f":"C13+C15","v":12094293.420132108}]
["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":331661.9805382932}]
["Material oncosts",null,{"$f":"(C6+C11+C15)*Overheads!D9","v":160441.2746118769}]
["Network overheads",null,{"$f":"(C16+C21+C22+C23)*Overheads!D19","v":2503030.737125386}]
["Non-network overheads",null,{"$f":"(C4+C9)*Overheads!D20","v":687164.12014169933}]
["Non-network depreciation",null,{"$f":"(C4+C9)*Overheads!D25","v":230466.0331197067}]
["Corporate overheads",null,{"$f":"($C$16+$C$22+$C$23)*Overheads!D26","v":1585449.2154652439}]
["Market",null,{"$f":"($C$16+$C$22+$C$23)*Overheads!D27","v":91131.025318416854}]
["Customer ops",null,{"$f":"($C$16+$C$22+$C$23)*Overheads!D28","v":762955.10036266735}]
["Total",null,{"$f":"SUM(C21:C29)","v":6352299.4866832905}]
["Base Opex (Gross)",null,{"$f":"C16+C30","v":18446592.906815398}]
[]
["Table 2 - Forecast Opex (Gross)"]
["Forecast opex","2022-23","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30"]
["CONV opex",null,null,{"$f":"D37*('EGX - Opex BST'!E5/'EGX - Opex BST'!E7)","v":8677482.6683226395},{"$f":"E37*('EGX - Opex BST'!F5/'EGX - Opex BST'!F7)","v":6257727.9681516271},{"$f":"F37*('EGX - Opex BST'!G5/'EGX - Opex BST'!G7)","v":4374532.3286797423},{"$f":"G37*('EGX - Opex BST'!H5/'EGX - Opex BST'!H7)","v":2637577.9160244591},{"$f":"H37*('EGX - Opex BST'!I5/'EGX - Opex BST'!I7)","v":0}]
["LED opex",null,null,{"$f":"D37*('EGX - Opex BST'!E6/'EGX - Opex BST'!E7)","v":9306544.885892624},{"$f":"E37*('EGX - Opex BST'!F6/'EGX - Opex BST'!F7)","v":11111536.703248886},{"$f":"F37*('EGX - Opex BST'!G6/'EGX - Opex BST'!G7)","v":12387759.463524016},{"$f":"G37*('EGX - Opex BST'!H6/'EGX - Opex BST'!H7)","v":13574673.562948216},{"$f":"H37*('EGX - Opex BST'!I6/'EGX - Opex BST'!I7)","v":15700541.911723657}]
["Total ",null,null,{"$f":"C31*(1+'EGX - Opex BST'!E39)","v":17984027.554215264},{"$f":"$C$31*(1+'EGX - Opex BST'!F39)","v":17369264.671400513},{"$f":"$C$31*(1+'EGX - Opex BST'!G39)","v":16762291.792203758},{"$f":"$C$31*(1+'EGX - Opex BST'!H39)","v":16212251.478972675},{"$f":"$C$31*(1+'EGX - Opex BST'!I39)","v":15700541.911723657}]