{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["AER Final 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":0,"defined_names":25,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"AER Final Decision changes","index":0,"n_rows":3,"n_cols":4,"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.",null,"Source - https://www.rba.gov.au/publications/smp/2025/feb/"]

{"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":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["RDP2025 Project: Public Lighting Expenditure Analysis Model"]
[]
[]
[null,"Date","Version","Description of any updates made"]
[null,"2024-01-31","V1","Version submitted to the AER"]
[null,"2024-08-21","V2","AER - updated inflation figures and labour escalators"]
[null,"2024-11-26","V3","RRP version - updated volumes for actuals and revised 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.4E-2,null,null,"Sources used",null,"https://www.rba.gov.au/publications/smp/2025/feb/"]
[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.2419160436363634}]
["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.1959191531313134}]
["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.1266867200000001}]
["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.0629120000000001}]
["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.024}]
["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.80520740924803036},0.83617692498833907,0.88755816701203327,0.94081165703275527,0.9765625,{"$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.8148126086614732]
["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.84615155514845275]
["2022-06-01",1.100350715823996,1.0816676818608599,1.0302658935671953,0.971285862357264,0.92596689038790336,0.89814571636548723]
["2023-06-01",1.1663717587734359,1.1465677427725116,1.092081847181227,1.0295630140987,0.98152490381117763,0.9520344593474166]
["2024-06-01",1.2106938856068263,1.1901373169978671,1.1335809573741138,1.0686864086344505,1.0188228501560024,0.98821176880261852]
["2025-06-01",1.2397505388613901,1.2187006126058157,1.1607869003510927,1.0943348824416774,1.0432745985597465,1.0119288512538813]
[]
["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.108542631524629E-2,1.0870090668475489E-2,8.7466278382324451E-3,9.5315736522133768E-3,1.1515925226694229E-2,null,null,null,"Source used",null,"Average Oxford Economics & DEA + Super guarantee value"]
["Escalation - Cumulative",{"$f":"PRODUCT(1+$B29:B29)-1","v":1.1085426315246227E-2},{"$f":"PRODUCT(1+$B29:C29)-1","v":2.2076016572867285E-2},{"$f":"PRODUCT(1+$B29:D29)-1","v":3.1015735112213338E-2},{"$f":"PRODUCT(1+$B29:E29)-1","v":4.0842937528026368E-2},{"$f":"PRODUCT(1+$B29:F29)-1","v":5.282920696933191E-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":[[51,5,51,9],[51,10,51,14],[61,5,61,9],[61,10,61,14],[50,10,50,14],[60,10,60,14],[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]]}
["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","Actual","Actual","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast"]
["DNSP","Rate","Road type","Light type","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30"]
["Energex",1,"Major","CONV",39166,38542,38010,37498,36395,30329,24263,18198,12132,6066,0]
["Energex",1,"Major","LED",1477,2306,3113,3757,4636,10702,16768,22833,28899,34965,41031]
["Energex",1,"Minor","CONV",104697,102204,95466,88231,74605,62171,49737,37303,24869,12434,0,"Removes the Nostalgia  as these are to be converted to LED (see Table 3 below)"]
["Energex",1,"Minor","LED",4798,7287,13986,20958,34586,47020,59454,71888,84322,96757,109191.00000000001]
["Energex",2,"Major","CONV",52820,52615,52158,51753,50794,42328,33863,25397.000000000007,16931,8466,0]
["Energex","2A","Major","LED",2101,3389,4524,5879,8318,16784,25249,33714.999999999993,42181,50646,59111.999999999985]
["Energex",2,"Minor","CONV",126472,125346,115984,103136,78710,65592,52473,39355,26237,13118,0,"Removes the Nostalgia  as these are to be converted to LED (see Table 3 below)"]
["Energex","2A","Minor","LED",6059,8985,19935,35097,62195,75313,88432,101549.99999999999,114668,127787,140904.99999999997]
["Energex","All","All","CONV",{"$f":"E5+E7+E9+E11","v":323155},318707,301618,280618,240504,200420,160336,120253,80169,40084,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},65691,109735,149819,189903,229986,270070,310155,350239]
["Energex","All","All","All",{"$f":"E13+E14","v":337590},{"$f":"F13+F14","v":340674},343176,346309,350239,350239,{"$f":"SUM(K5:K12)","v":350239},{"$f":"SUM(L5:L12)","v":350239},{"$f":"SUM(M5:M12)","v":350239},{"$f":"SUM(N5:N12)","v":350239},{"$f":"SUM(O5:O12)","v":350239}]
["Energex","All","All","LED",{"$f":"E14/E15","v":4.275896797890933E-2},{"$f":"F14/F15","v":6.4480999430540628E-2},0.12109821199617689,0.18968897718511502,0.31331462230077178,0.42776218525064313,{"$f":"K14/K15","v":0.54220974820051449},0.65665445595721783,0.77110201890708918,0.88555243705012865,{"$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","Actual","Actual","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast"]
["DNSP","Rate","Road type","Light type","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30"]
["Energex",1,"Major","LED",null,{"$f":"F6-E6","v":829},807,644,879,6066,6066,6065,6066,6066,6066]
["Energex",1,"Minor","LED",null,{"$f":"F8-E8","v":2489},6699,6972,13628,12434,12434,12434,12434,12435,12434.000000000015]
["Energex","2A","Major","LED",null,{"$f":"F10-E10","v":1288},1135,1355,2439,8466,8465,8465.9999999999927,8466.0000000000073,8465,8465.9999999999854]
["Energex","2A","Minor","LED",null,{"$f":"F12-E12","v":2926},10950,15162,27098,13118,13119,13117.999999999985,13118.000000000015,13119,13117.999999999971]
["Energex","All","All","LED",null,{"$f":"SUM(F27:F30)","v":7532},19591,24133,44044,40084,40084,40082.999999999978,40084.000000000022,40085,40083.999999999971]
[null,null,null,"Total LED volume",null,{"$f":"E14+F31","v":21967},41558,65691,109735,149819,189903,229985.99999999997,270070,310155,350239]
[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":1},{"$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.31558446939874862,0.32937517028426122,0.46153078535076342,0.46153078535076342,0.46151735149564677,0.46153078535076314,0.46154421853561184,0.46153078535076408]
[null,null,null,null,"Rate2A",{"$f":"1-F34","v":0.55947955390334569},{"$f":"1-G34","v":0.61686488693787966},0.68441553060125138,0.67062482971573878,0.53846921464923658,{"$f":"1-K34","v":0.53846921464923658},0.53848264850435323,0.53846921464923692,0.53845578146438822,0.53846921464923592]
[]
[]
["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":6066},6066,6066,6066,6066]
["Energex",1,"Minor","LED",null,null,null,null,null,null,12434,12434,12434,12434,12434]
["Energex","2A","Major","LED",null,null,null,null,null,null,8466,8466,8466,8466,8466]
["Energex","2A","Minor","LED",null,null,null,null,null,null,13118,13118,13118,13118,13118]
["Energex","All","All","LED",null,null,null,null,null,null,{"$f":"SUM(K42:K45)","v":40084},{"$f":"SUM(L42:L45)","v":40084},{"$f":"SUM(M42:M45)","v":40084},{"$f":"SUM(N42:N45)","v":40084},{"$f":"SUM(O42:O45)","v":40084}]
["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","Actual","Actual","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast"]
["DNSP","Rate","Road type","Light type","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30"]
["Energex",1,"Major ","LED",228,280,273,214,127,{"$f":"ROUND(I55*(1+'Ratios & Assumptions'!$D$13),0)","v":130},{"$f":"ROUND(J55*(1+'Ratios & Assumptions'!$D$13),0)","v":133},{"$f":"ROUND(K55*(1+'Ratios & Assumptions'!$D$13),0)","v":136},{"$f":"ROUND(L55*(1+'Ratios & Assumptions'!$D$13),0)","v":139},{"$f":"ROUND(M55*(1+'Ratios & Assumptions'!$D$13),0)","v":142},{"$f":"ROUND(N55*(1+'Ratios & Assumptions'!$D$13),0)","v":146}]
[null,1,"Minor","LED",318,267,338,324,310,{"$f":"ROUND(I56*(1+'Ratios & Assumptions'!$D$14),0)","v":315},{"$f":"ROUND(J56*(1+'Ratios & Assumptions'!$D$14),0)","v":320},{"$f":"ROUND(K56*(1+'Ratios & Assumptions'!$D$14),0)","v":325},{"$f":"ROUND(L56*(1+'Ratios & Assumptions'!$D$14),0)","v":330},{"$f":"ROUND(M56*(1+'Ratios & Assumptions'!$D$14),0)","v":335},{"$f":"ROUND(N56*(1+'Ratios & Assumptions'!$D$14),0)","v":340}]
["Energex","All","All","LED",{"$f":"SUM(E55:E56)","v":546},547,611,538,437,445,453,461,469,477,486]
["Notes:"]
["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","Actual","Actual","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast"]
["DNSP","Rate","Road type","Light type","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30"]
["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,37498,36395,30329,24263,18198,12132,6066,0]
["Energex",1,"Major","LED",null,{"$f":"F6+F55","v":2586},{"$f":"G6+G55","v":3386},{"$f":"H6+H55","v":3971},{"$f":"I6+SUM(H55:I55)","v":4977},{"$f":"J6+SUM(H55:J55)","v":11173},{"$f":"K6+K55","v":16901},{"$f":"L6+SUM(K55:L55)","v":23102},{"$f":"M6+SUM(K55:M55)","v":29307},{"$f":"N6+SUM(K55:N55)","v":35515},{"$f":"O6+SUM(K55:O55)","v":41727}]
["Energex",1,"Minor","CONV",null,{"$f":"F7","v":102204},95466,88231,74605,62171,49737,37303,24869,12434,0]
["Energex",1,"Minor","LED",null,{"$f":"F8+F56","v":7554},{"$f":"G8+G56","v":14324},{"$f":"H8+H56","v":21282},{"$f":"I8+SUM(H56:I56)","v":35220},{"$f":"J8+SUM(H56:J56)","v":47969},{"$f":"K8+K56+K65","v":59882},{"$f":"L8+SUM(K56:L56)+L65","v":72641},{"$f":"M8+SUM(K56:M56)+M65","v":85405},{"$f":"N8+SUM(K56:N56)+N65","v":98175},{"$f":"O8+SUM(K56:O56)+O65","v":110949.00000000001}]
["Energex",2,"Major","CONV",null,{"$f":"F9","v":52615},52158,51753,50794,42328,33863,25397.000000000007,16931,8466,0]
["Energex","2A","Major","LED",null,{"$f":"F10","v":3389},4524,5879,8318,16784,25249,33714.999999999993,42181,50646,59111.999999999985]
["Energex",2,"Minor","CONV",null,{"$f":"F11","v":125346},115984,103136,78710,65592,52473,39355,26237,13118,0]
["Energex","2A","Minor","LED",null,{"$f":"F12","v":8985},{"$f":"G12","v":19935},{"$f":"H12","v":35097},{"$f":"I12","v":62195},{"$f":"J12","v":75313},{"$f":"K12+K66","v":96599},{"$f":"L12+L66","v":109716.99999999999},{"$f":"M12+M66","v":122835},{"$f":"N12+N66","v":135954},{"$f":"O12+O66","v":149071.99999999997}]
["Energex","All","All","CONV",null,{"$f":"SUMIF($D$75:$D$82,$D83,F$75:F$82)","v":318707},301618,280618,240504,200420,160336,120253,80169,40084,0]
["Energex","All","All","LED",null,22514,42169,66229,110710,151239,198631,239175,279728,320290,360860]
["Energex","All","All","All",null,{"$f":"SUM(F83:F84)","v":341221},{"$f":"G15+G65","v":343176},{"$f":"SUM(H83:H84)","v":346847},351214,351659,358967,359428,359897,360374,360860]
[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.38514372933095903},0.31350789692435577,0.33596366988152243,{"$f":"((J76-I76)+(J78-I78))/((J76-I76)+(J78-I78)+(J80-I80)+(J82-I82))","v":0.46744306545930076},0.37223582039162728,0.46764009471191814,0.46775824230019947,0.46787633745870522,0.46798126694601994]
[null,null,"Rate 2A",null,null,null,{"$f":"1-G87","v":0.61485627066904103},0.68649210307564423,0.66403633011847751,0.5325569345406993,{"$f":"1-K87","v":0.62776417960837272},0.53235990528808186,0.53224175769980053,0.53212366254129484,0.53201873305398006]
["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","Actual","Actual","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast"]
["DNSP","Rate","Road type","Light type","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30"]
["New installations and new subdivisions"]
["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,245,330,394,{"$f":"ROUND($J$100,0)","v":394},{"$f":"ROUND($J$100,0)","v":394},394,394,394]
[null,2,"Minor","LED",null,274,634,1036,1187,1721,{"$f":"ROUND($J$101,0)","v":1721},{"$f":"ROUND($J$101,0)","v":1721},1721,1721,1721]
["Energex","All","Major","LED",{"$f":"E97","v":909},{"$f":"F97","v":1279},1110,1139,1167.4749999999999,1196.6618749999998,{"$f":"K97+K100","v":1621},{"$f":"L97+L100","v":1652},1683,1715,1748]
[null,null,"Minor","LED",{"$f":"E98","v":1363},{"$f":"F98","v":1709},2017,2771,2812.5649999999996,2854.7534749999995,{"$f":"K98+K101","v":4619},{"$f":"L98+L101","v":4662},4706,4751,4796]
["Energex","All","All","LED",{"$f":"E102+E103","v":2272},{"$f":"F102+F103","v":2988},3127,3910,3980.0399999999995,4051.4153499999993,6240,6314,6389,6466,6544]
[]
["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":3542544},{"$f":"'EGX Unit Rates'!$D24*'EGX - Yearly volume scenarios'!L$42","v":3542544},{"$f":"'EGX Unit Rates'!$D24*'EGX - Yearly volume scenarios'!M$42","v":3542544},{"$f":"'EGX Unit Rates'!$D24*'EGX - Yearly volume scenarios'!N$42","v":3542544},{"$f":"'EGX Unit Rates'!$D24*'EGX - Yearly volume scenarios'!O$42","v":3542544}]
[null,1,"Major","LED","Contractor",{"$f":"'EGX Unit Rates'!$D25*'EGX - Yearly volume scenarios'!K$42","v":454950},{"$f":"'EGX Unit Rates'!$D25*'EGX - Yearly volume scenarios'!L$42","v":454950},{"$f":"'EGX Unit Rates'!$D25*'EGX - Yearly volume scenarios'!M$42","v":454950},{"$f":"'EGX Unit Rates'!$D25*'EGX - Yearly volume scenarios'!N$42","v":454950},{"$f":"'EGX Unit Rates'!$D25*'EGX - Yearly volume scenarios'!O$42","v":454950}]
["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":2449498},{"$f":"'EGX Unit Rates'!$D27*'EGX - Yearly volume scenarios'!L$43","v":2449498},{"$f":"'EGX Unit Rates'!$D27*'EGX - Yearly volume scenarios'!M$43","v":2449498},{"$f":"'EGX Unit Rates'!$D27*'EGX - Yearly volume scenarios'!N$43","v":2449498},{"$f":"'EGX Unit Rates'!$D27*'EGX - Yearly volume scenarios'!O$43","v":2449498}]
[null,1,"Minor","LED","Contractor",{"$f":"'EGX Unit Rates'!$D28*'EGX - Yearly volume scenarios'!K$43","v":932550},{"$f":"'EGX Unit Rates'!$D28*'EGX - Yearly volume scenarios'!L$43","v":932550},{"$f":"'EGX Unit Rates'!$D28*'EGX - Yearly volume scenarios'!M$43","v":932550},{"$f":"'EGX Unit Rates'!$D28*'EGX - Yearly volume scenarios'!N$43","v":932550},{"$f":"'EGX Unit Rates'!$D28*'EGX - Yearly volume scenarios'!O$43","v":932550}]
["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":4944144},{"$f":"'EGX Unit Rates'!$D24*'EGX - Yearly volume scenarios'!L$44","v":4944144},{"$f":"'EGX Unit Rates'!$D24*'EGX - Yearly volume scenarios'!M$44","v":4944144},{"$f":"'EGX Unit Rates'!$D24*'EGX - Yearly volume scenarios'!N$44","v":4944144},{"$f":"'EGX Unit Rates'!$D24*'EGX - Yearly volume scenarios'!O$44","v":4944144}]
[null,"2A","Major","LED","Contractor",{"$f":"'EGX Unit Rates'!$D25*'EGX - Yearly volume scenarios'!K$44","v":634950},{"$f":"'EGX Unit Rates'!$D25*'EGX - Yearly volume scenarios'!L$44","v":634950},{"$f":"'EGX Unit Rates'!$D25*'EGX - Yearly volume scenarios'!M$44","v":634950},{"$f":"'EGX Unit Rates'!$D25*'EGX - Yearly volume scenarios'!N$44","v":634950},{"$f":"'EGX Unit Rates'!$D25*'EGX - Yearly volume scenarios'!O$44","v":634950}]
["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":2584246},{"$f":"'EGX Unit Rates'!$D27*'EGX - Yearly volume scenarios'!L$45","v":2584246},{"$f":"'EGX Unit Rates'!$D27*'EGX - Yearly volume scenarios'!M$45","v":2584246},{"$f":"'EGX Unit Rates'!$D27*'EGX - Yearly volume scenarios'!N$45","v":2584246},{"$f":"'EGX Unit Rates'!$D27*'EGX - Yearly volume scenarios'!O$45","v":2584246}]
[null,"2A","Minor","LED","Contractor",{"$f":"'EGX Unit Rates'!$D28*'EGX - Yearly volume scenarios'!K$45","v":983850},{"$f":"'EGX Unit Rates'!$D28*'EGX - Yearly volume scenarios'!L$45","v":983850},{"$f":"'EGX Unit Rates'!$D28*'EGX - Yearly volume scenarios'!M$45","v":983850},{"$f":"'EGX Unit Rates'!$D28*'EGX - Yearly volume scenarios'!N$45","v":983850},{"$f":"'EGX Unit Rates'!$D28*'EGX - Yearly volume scenarios'!O$45","v":983850}]
["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":5992042},5992042,5992042,5992042,5992042]
[null,1,"All","LED","Contractor",1387500,1387500,1387500,1387500,1387500]
["Energex","2A","All","LED","Labour",0,0,0,0,0]
[null,"2A","All","LED","Material",7528390,7528390,7528390,7528390,7528390]
[null,"2A","All","LED","Contractor",1618800,1618800,1618800,1618800,1618800]
["Energex","All","All","LED","Labour",{"$f":"F18+F21","v":0},0,0,0,0]
[null,"All","All","LED","Material",{"$f":"F19+F22","v":13520432},13520432,13520432,13520432,13520432]
[null,"All","All","LED","Contractor",3006300,3006300,3006300,3006300,3006300]
["Energex","All","All","LED","All",{"$f":"SUM(F24:F26)","v":16526732},16526732,16526732,16526732,16526732]
[]
["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":113913.00059723575},{"$f":"'EGX - Yearly volume scenarios'!L$55*'EGX Unit Rates'!$D11","v":116482.46677612075},{"$f":"'EGX - Yearly volume scenarios'!M$55*'EGX Unit Rates'!$D11","v":119051.93295500577},{"$f":"'EGX - Yearly volume scenarios'!N$55*'EGX Unit Rates'!$D11","v":121621.39913389079},{"$f":"'EGX - Yearly volume scenarios'!O$55*'EGX Unit Rates'!$D11","v":125047.35403907081}]
[null,1,"Major","LED","Material",{"$f":"'EGX - Yearly volume scenarios'!K$55*'EGX Unit Rates'!$D12","v":456663.62074819888},{"$f":"'EGX - Yearly volume scenarios'!L$55*'EGX Unit Rates'!$D12","v":466964.30392297026},{"$f":"'EGX - Yearly volume scenarios'!M$55*'EGX Unit Rates'!$D12","v":477264.98709774169},{"$f":"'EGX - Yearly volume scenarios'!N$55*'EGX Unit Rates'!$D12","v":487565.67027251306},{"$f":"'EGX - Yearly volume scenarios'!O$55*'EGX Unit Rates'!$D12","v":501299.91450554162}]
[null,1,"Major","LED","Contractor",{"$f":"'EGX - Yearly volume scenarios'!K$55*'EGX Unit Rates'!$D13","v":789857.36581981205},{"$f":"'EGX - Yearly volume scenarios'!L$55*'EGX Unit Rates'!$D13","v":807673.69737965742},{"$f":"'EGX - Yearly volume scenarios'!M$55*'EGX Unit Rates'!$D13","v":825490.02893950278},{"$f":"'EGX - Yearly volume scenarios'!N$55*'EGX Unit Rates'!$D13","v":843306.36049934814},{"$f":"'EGX - Yearly volume scenarios'!O$55*'EGX Unit Rates'!$D13","v":867061.46924580866}]
["Energex",1,"Minor","LED","Labour",{"$f":"'EGX - Yearly volume scenarios'!K$56*'EGX Unit Rates'!$D8","v":161990.28042314539},{"$f":"'EGX - Yearly volume scenarios'!L$56*'EGX Unit Rates'!$D8","v":164521.37855475702},{"$f":"'EGX - Yearly volume scenarios'!M$56*'EGX Unit Rates'!$D8","v":167052.47668636867},{"$f":"'EGX - Yearly volume scenarios'!N$56*'EGX Unit Rates'!$D8","v":169583.57481798032},{"$f":"'EGX - Yearly volume scenarios'!O$56*'EGX Unit Rates'!$D8","v":172114.67294959197}]
[null,1,"Minor","LED","Material",{"$f":"'EGX - Yearly volume scenarios'!K$56*'EGX Unit Rates'!$D9","v":269157.13926018309},{"$f":"'EGX - Yearly volume scenarios'!L$56*'EGX Unit Rates'!$D9","v":273362.71956112341},{"$f":"'EGX - Yearly volume scenarios'!M$56*'EGX Unit Rates'!$D9","v":277568.29986206378},{"$f":"'EGX - Yearly volume scenarios'!N$56*'EGX Unit Rates'!$D9","v":281773.88016300416},{"$f":"'EGX - Yearly volume scenarios'!O$56*'EGX Unit Rates'!$D9","v":285979.46046394453}]
[null,1,"Minor","LED","Contractor",{"$f":"'EGX - Yearly volume scenarios'!K$56*'EGX Unit Rates'!$D10","v":1123218.7328277889},{"$f":"'EGX - Yearly volume scenarios'!L$56*'EGX Unit Rates'!$D10","v":1140769.025528223},{"$f":"'EGX - Yearly volume scenarios'!M$56*'EGX Unit Rates'!$D10","v":1158319.3182286574},{"$f":"'EGX - Yearly volume scenarios'!N$56*'EGX Unit Rates'!$D10","v":1175869.6109290915},{"$f":"'EGX - Yearly volume scenarios'!O$56*'EGX Unit Rates'!$D10","v":1193419.9036295258}]
["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":275903.28102038114},281003.84533087775,286104.40964137443,291204.9739518711,297162.02698866278]
[null,1,"All","LED","Material",{"$f":"SUMIFS(F$62:F$73,$B$62:$B$73,$B75,$E$62:$E$73,$E75)","v":725820.76000838191},740327.0234840936,754833.28695980553,769339.55043551722,787279.37496948615]
[null,1,"All","LED","Contractor",1913076.098647601,1948442.7229078803,1983809.3471681601,2019175.9714284395,2060481.3728753345]
["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":275903.28102038114},281003.84533087775,286104.40964137443,291204.9739518711,297162.02698866278]
[null,"All","All","LED","Material",{"$f":"SUMIF($E$62:$E$73,$E81,F$62:F$73)","v":725820.76000838191},740327.0234840936,754833.28695980553,769339.55043551722,787279.37496948615]
[null,"All","All","LED","Contractor",1913076.098647601,1948442.7229078803,1983809.3471681601,2019175.9714284395,2060481.3728753345]
["Energex","All","All","LED","All",{"$f":"SUM(F80:F82)","v":2914800.1396763641},{"$f":"SUM(G80:G82)","v":2969773.5917228516},3024747.04376934,3079720.4958158275,3144922.7748334836]
[]
[]
["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":113913.00059723575},116482.46677612075,119051.93295500577,121621.39913389079,125047.35403907081]
[null,1,"Major","All","Material",3999207.6207481991,4009508.3039229703,4019808.9870977416,4030109.6702725133,4043843.9145055418]
[null,1,"Major","All","Contractor",1244807.3658198121,1262623.6973796575,1280440.0289395028,1298256.360499348,1322011.4692458087]
["Energex","2A","Major","All","Labour",0,0,0,0,0]
[null,"2A","Major","All","Material",4944144,4944144,4944144,4944144,4944144]
[null,"2A","Major","All","Contractor",634950,634950,634950,634950,634950]
["Energex",1,"Minor","All","Labour",161990.28042314539,164521.37855475702,167052.47668636867,169583.57481798032,172114.67294959197]
[null,1,"Minor","All","Material",2788855.1392601831,2793060.7195611233,2797266.299862064,2801471.8801630042,2805677.4604639444]
[null,1,"Minor","All","Contractor",2082228.7328277889,2099779.0255282233,2117329.3182286574,2134879.6109290915,2152429.9036295256]
["Energex","2A","Minor","All","Labour",0,0,0,0,0]
[null,"2A","Minor","All","Material",7892796,7892796,7892796,7892796,7892796]
[null,"2A","Minor","All","Contractor",2984765,2984765,2984765,2984765,2984765]
["Energex",1,"All","All","Labour",{"$f":"SUMIFS(F$126:F$137,$B$126:$B$137,$B138,$E$126:$E$137,$E138)","v":275903.28102038114},281003.84533087775,286104.40964137443,291204.9739518711,297162.02698866278]
[null,1,"All","All","Material",{"$f":"SUMIFS(F$126:F$137,$B$126:$B$137,$B139,$E$126:$E$137,$E139)","v":6788062.7600083817},6802569.0234840941,6817075.2869598055,6831581.550435517,6849521.3749694861]
[null,1,"All","All","Contractor",3327036.098647601,3362402.7229078808,3397769.3471681601,3433135.9714284395,3474441.3728753342]
["Energex","2A","All","All","Labour",0,0,0,0,0]
[null,"2A","All","All","Material",12836940,12836940,12836940,12836940,12836940]
[null,"2A","All","All","Contractor",3619715,3619715,3619715,3619715,3619715]
["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":275903.28102038114},281003.84533087775,286104.40964137443,291204.9739518711,297162.02698866278]
[null,"All","All","All","Material",19625002.76000838,19639509.023484096,19654015.286959805,19668521.550435517,19686461.374969486]
[null,"All","All","All","Contractor",6946751.098647601,6982117.7229078803,7017484.3471681606,7052850.971428439,7094156.3728753347]
["Energex","All","All","All","All",{"$f":"SUM(F144:F146)","v":26847657.139676362},26902630.591722853,26957604.043769337,27012577.495815828,27077779.774833485]

{"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":305277.61384862231},{"$f":"'EGX - Forecast capex scenarios'!G144*'Cost Escalations'!$E$21*(1+'Cost Escalations'!C30)","v":314300.95689875778},{"$f":"'EGX - Forecast capex scenarios'!H144*'Cost Escalations'!$E$21*(1+'Cost Escalations'!D30)","v":322804.87716093985},{"$f":"'EGX - Forecast capex scenarios'!I144*'Cost Escalations'!$E$21*(1+'Cost Escalations'!E30)","v":331691.41513166006},{"$f":"'EGX - Forecast capex scenarios'!J144*'Cost Escalations'!$E$21*(1+'Cost Escalations'!F30)","v":342374.5537792744}]
["Contractors",{"$f":"'EGX - Forecast capex scenarios'!F146*'Cost Escalations'!$E$21*(1+'Cost Escalations'!B26)","v":7681893.8033824619},{"$f":"'EGX - Forecast capex scenarios'!G146*'Cost Escalations'!$E$21*(1+'Cost Escalations'!C26)","v":7775822.2368707843},{"$f":"'EGX - Forecast capex scenarios'!H146*'Cost Escalations'!$E$21*(1+'Cost Escalations'!D26)","v":7862882.0006236592},{"$f":"'EGX - Forecast capex scenarios'!I146*'Cost Escalations'!$E$21*(1+'Cost Escalations'!E26)","v":7975212.3338199509},{"$f":"'EGX - Forecast capex scenarios'!J146*'Cost Escalations'!$E$21*(1+'Cost Escalations'!F26)","v":8109358.517823861}]
["Materials",{"$f":"'EGX - Forecast capex scenarios'!F145*'Cost Escalations'!$E$21","v":21476325.088291366},{"$f":"'EGX - Forecast capex scenarios'!G145*'Cost Escalations'!$E$21","v":21492199.798426732},{"$f":"'EGX - Forecast capex scenarios'!H145*'Cost Escalations'!$E$21","v":21508074.508562088},{"$f":"'EGX - Forecast capex scenarios'!I145*'Cost Escalations'!$E$21","v":21523949.218697451},{"$f":"'EGX - Forecast capex scenarios'!J145*'Cost Escalations'!$E$21","v":21543581.394469857}]
["Total Direct Costs",{"$f":"SUM(B5:B7)","v":29463496.505522449},29582322.992196277,29693761.386346687,29830852.967649061,29995314.466072991]
[]
["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":64609.059481076569},{"$f":"C5*Overheads!$D$15","v":66518.762916237218},{"$f":"D5*Overheads!$D$15","v":68318.535533413466},{"$f":"E5*Overheads!$D$15","v":70199.285494384443},{"$f":"F5*Overheads!$D$15","v":72460.268642236755}]
["Material oncosts",{"$f":"B7*Overheads!$D$9","v":1872030.317188747},{"$f":"C7*Overheads!$D$9","v":1873414.0706255112},{"$f":"D7*Overheads!$D$9","v":1874797.8240622745},{"$f":"E7*Overheads!$D$9","v":1876181.5774990385},{"$f":"F7*Overheads!$D$9","v":1877892.8585532799}]
["Network overheads",{"$f":"(B8+B11+B12)*Overheads!$D$19","v":6244480.2345527792},{"$f":"(C8+C11+C12)*Overheads!$D$19","v":6268765.9757539378},{"$f":"(D8+D11+D12)*Overheads!$D$19","v":6291560.6005239682},{"$f":"(E8+E11+E12)*Overheads!$D$19","v":6319472.9254896101},{"$f":"(F8+F11+F12)*Overheads!$D$19","v":6352969.0003313133}]
["Non-network overheads",{"$f":"B5*Overheads!$D$20","v":133862.27580092102},{"$f":"C5*Overheads!$D$20","v":137818.95385797144},{"$f":"D5*Overheads!$D$20","v":141547.86835377765},{"$f":"E5*Overheads!$D$20","v":145444.55826089208},{"$f":"F5*Overheads!$D$20","v":150129.0460424808}]
["Non-network depreciation",{"$f":"B5*Overheads!$D$25","v":44895.690540205571},{"$f":"C5*Overheads!$D$25","v":46222.709616743159},{"$f":"D5*Overheads!$D$25","v":47473.339715872622},{"$f":"E5*Overheads!$D$25","v":48780.239536260626},{"$f":"F5*Overheads!$D$25","v":50351.356660358804}]
["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":8359877.5775637291},8392740.4727704003,8423698.1681893058,8460078.5862801857,8503802.5302296691]
[]
["Total Expenditure (incl oncosts and overheads)",{"$f":"B8+B19","v":37823374.083086178},37975063.464966677,38117459.554535992,38290931.553929247,38499116.996302664]
[]
["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":37823374.083086178},37975063.464966677,38117459.554535992,38290931.553929247,38499116.996302664]
["CON",{"$f":"B24*B21","v":0},0,0,0,0]
[]
["Immediate Expensing"]
[]
["LED",{"$f":"B23*B19","v":8359877.5775637291},8392740.4727704003,8423698.1681893058,8460078.5862801857,8503802.5302296691]
["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":305277.61384862231},{"$f":"'EGX - Forecast capex scenarios'!G138*'Cost Escalations'!$E$21*(1+'Cost Escalations'!C30)","v":314300.95689875778},{"$f":"'EGX - Forecast capex scenarios'!H138*'Cost Escalations'!$E$21*(1+'Cost Escalations'!D30)","v":322804.87716093985},{"$f":"'EGX - Forecast capex scenarios'!I138*'Cost Escalations'!$E$21*(1+'Cost Escalations'!E30)","v":331691.41513166006},{"$f":"'EGX - Forecast capex scenarios'!J138*'Cost Escalations'!$E$21*(1+'Cost Escalations'!F30)","v":342374.5537792744}]
["Contractors",{"$f":"'EGX - Forecast capex scenarios'!F140*'Cost Escalations'!$E$21*(1+'Cost Escalations'!B26)","v":3679121.0203006128},{"$f":"'EGX - Forecast capex scenarios'!G140*'Cost Escalations'!$E$21*(1+'Cost Escalations'!C26)","v":3744629.7670290554},{"$f":"'EGX - Forecast capex scenarios'!H140*'Cost Escalations'!$E$21*(1+'Cost Escalations'!D26)","v":3807099.2567158942},{"$f":"'EGX - Forecast capex scenarios'!I140*'Cost Escalations'!$E$21*(1+'Cost Escalations'!E26)","v":3882116.3886682359},{"$f":"'EGX - Forecast capex scenarios'!J140*'Cost Escalations'!$E$21*(1+'Cost Escalations'!F26)","v":3971647.8268699911}]
["Materials",{"$f":"'EGX - Forecast capex scenarios'!F139*'Cost Escalations'!$E$21","v":7428413.8624805007},{"$f":"'EGX - Forecast capex scenarios'!G139*'Cost Escalations'!$E$21","v":7444288.5726158628},{"$f":"'EGX - Forecast capex scenarios'!H139*'Cost Escalations'!$E$21","v":7460163.2827512231},{"$f":"'EGX - Forecast capex scenarios'!I139*'Cost Escalations'!$E$21","v":7476037.9928865843},{"$f":"'EGX - Forecast capex scenarios'!J139*'Cost Escalations'!$E$21","v":7495670.1686589895}]
["Total Direct Costs",{"$f":"SUM(B40:B42)","v":11412812.496629735},11503219.296543676,11590067.416628057,11689845.79668648,11809692.549308255]
[]
["Overheads & Oncosts"]
["Fleet oncost",{"$f":"B40*Overheads!$D$15","v":64609.059481076569},{"$f":"C40*Overheads!$D$15","v":66518.762916237218},{"$f":"D40*Overheads!$D$15","v":68318.535533413466},{"$f":"E40*Overheads!$D$15","v":70199.285494384443},{"$f":"F40*Overheads!$D$15","v":72460.268642236755}]
["Material oncosts",{"$f":"B42*Overheads!$D$9","v":647513.75768520834},{"$f":"C42*Overheads!$D$9","v":648897.51112197223},{"$f":"D42*Overheads!$D$9","v":650281.264558736},{"$f":"E42*Overheads!$D$9","v":651665.01799549977},{"$f":"F42*Overheads!$D$9","v":653376.29904974112}]
["Network overheads",{"$f":"(B43+B46+B47)*Overheads!$D$19","v":2411260.8683062843},{"$f":"(C43+C46+C47)*Overheads!$D$19","v":2429894.8450402408},{"$f":"(D43+D46+D47)*Overheads!$D$19","v":2447799.2527442165},{"$f":"(E43+E46+E47)*Overheads!$D$19","v":2468291.1783673223},{"$f":"(F43+F46+F47)*Overheads!$D$19","v":2492914.8107655789}]
["Non-network overheads",{"$f":"B40*Overheads!$D$20","v":133862.27580092102},{"$f":"C40*Overheads!$D$20","v":137818.95385797144},{"$f":"D40*Overheads!$D$20","v":141547.86835377765},{"$f":"E40*Overheads!$D$20","v":145444.55826089208},{"$f":"F40*Overheads!$D$20","v":150129.0460424808}]
["Non-network depreciation",{"$f":"B40*Overheads!$D$25","v":44895.690540205571},{"$f":"C40*Overheads!$D$25","v":46222.709616743159},{"$f":"D40*Overheads!$D$25","v":47473.339715872622},{"$f":"E40*Overheads!$D$25","v":48780.239536260626},{"$f":"F40*Overheads!$D$25","v":50351.356660358804}]
["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":3302141.6518136961},{"$f":"SUM(C46:C53)","v":3329352.7825531648},{"$f":"SUM(D46:D53)","v":3355420.260906016},{"$f":"SUM(E46:E53)","v":3384380.2796543594},{"$f":"SUM(F46:F53)","v":3419231.7811603961}]
[]
["Total Expenditure (incl oncosts and overheads)",{"$f":"B43+B54","v":14714954.148443431},14832572.079096841,14945487.677534074,15074226.076340839,{"$f":"F43+F54","v":15228924.330468651}]
[]
[]
["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":4002772.7830818486},{"$f":"'EGX - Forecast capex scenarios'!G143*'Cost Escalations'!$E$21*(1+'Cost Escalations'!C26)","v":4031192.4698417298},{"$f":"'EGX - Forecast capex scenarios'!H143*'Cost Escalations'!$E$21*(1+'Cost Escalations'!D26)","v":4055782.7439077646},{"$f":"'EGX - Forecast capex scenarios'!I143*'Cost Escalations'!$E$21*(1+'Cost Escalations'!E26)","v":4093095.945151716},{"$f":"'EGX - Forecast capex scenarios'!J143*'Cost Escalations'!$E$21*(1+'Cost Escalations'!F26)","v":4137710.6909538694}]
["Materials",{"$f":"'EGX - Forecast capex scenarios'!F142*'Cost Escalations'!$E$21","v":14047911.225810867},{"$f":"'EGX - Forecast capex scenarios'!G142*'Cost Escalations'!$E$21","v":14047911.225810867},{"$f":"'EGX - Forecast capex scenarios'!H142*'Cost Escalations'!$E$21","v":14047911.225810867},{"$f":"'EGX - Forecast capex scenarios'!I142*'Cost Escalations'!$E$21","v":14047911.225810867},{"$f":"'EGX - Forecast capex scenarios'!J142*'Cost Escalations'!$E$21","v":14047911.225810867}]
["Total Direct Costs",{"$f":"SUM(B63:B65)","v":18050684.008892715},18079103.695652597,18103693.969718631,18141007.170962583,18185621.916764736]
[]
["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":1224516.5595035388},{"$f":"C65*Overheads!$D$9","v":1224516.5595035388},{"$f":"D65*Overheads!$D$9","v":1224516.5595035388},{"$f":"E65*Overheads!$D$9","v":1224516.5595035388},{"$f":"F65*Overheads!$D$9","v":1224516.5595035388}]
["Network overheads",{"$f":"(B66+B69+B70)*Overheads!$D$19","v":3833219.3662464959},{"$f":"(C66+C69+C70)*Overheads!$D$19","v":3838871.1307136971},{"$f":"(D66+D69+D70)*Overheads!$D$19","v":3843761.3477797532},{"$f":"(E66+E69+E70)*Overheads!$D$19","v":3851181.7471222891},{"$f":"(F66+F69+F70)*Overheads!$D$19","v":3860054.1895657349}]
["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":5057735.9257500349},{"$f":"SUM(C69:C76)","v":5063387.6902172361},{"$f":"SUM(D69:D76)","v":5068277.9072832922},{"$f":"SUM(E69:E76)","v":5075698.3066258281},{"$f":"SUM(F69:F76)","v":5084570.7490692735}]
[]
["Total Expenditure (incl oncosts and overheads)",{"$f":"B66+B77","v":23108419.934642751},23142491.385869831,23171971.877001923,23216705.477588411,{"$f":"F66+F77","v":23270192.66583401}]
[]
[null,{"$f":"B56+B79","v":37823374.083086178},{"$f":"C56+C79","v":37975063.46496667},38117459.554536,38290931.553929254,38499116.996302664]
[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":160336},{"$f":"'EGX - Yearly volume scenarios'!L83","v":120253},{"$f":"'EGX - Yearly volume scenarios'!M83","v":80169},{"$f":"'EGX - Yearly volume scenarios'!N83","v":40084},{"$f":"'EGX - Yearly volume scenarios'!O83","v":0}]
["LED",null,null,null,{"$f":"'EGX - Yearly volume scenarios'!K84+'EGX - Yearly volume scenarios'!K104","v":204871},{"$f":"'EGX - Yearly volume scenarios'!L84+'EGX - Yearly volume scenarios'!L104","v":245489},{"$f":"'EGX - Yearly volume scenarios'!M84+'EGX - Yearly volume scenarios'!M104","v":286117},{"$f":"'EGX - Yearly volume scenarios'!N84+'EGX - Yearly volume scenarios'!N104","v":326756},{"$f":"'EGX - Yearly volume scenarios'!O84+'EGX - Yearly volume scenarios'!O104","v":367404}]
["Total",null,null,null,{"$f":"SUM(E5:E6)","v":365207},{"$f":"SUM(F5:F6)","v":365742},{"$f":"SUM(G5:G6)","v":366286},{"$f":"SUM(H5:H6)","v":366840},{"$f":"SUM(I5:I6)","v":367404}]
[]
["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.108542631524629E-2},{"$f":"'Cost Escalations'!C29","v":1.0870090668475489E-2},{"$f":"'Cost Escalations'!D29","v":8.7466278382324451E-3},{"$f":"'Cost Escalations'!E29","v":9.5315736522133768E-3},{"$f":"'Cost Escalations'!F29","v":1.1515925226694229E-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":7.9581627584139544E-3},{"$f":"SUMPRODUCT(F12:F14,F18:F20)","v":5.769117456060663E-3},{"$f":"SUMPRODUCT(G12:G14,G18:G20)","v":4.8884591844071106E-3},{"$f":"SUMPRODUCT(H12:H14,H18:H20)","v":6.952016938741294E-3},{"$f":"SUMPRODUCT(I12:I14,I18:I20)","v":8.2622731418944811E-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":351659},{"$f":"'EGX - Yearly volume scenarios'!K85+'EGX - Yearly volume scenarios'!K104","v":365207},{"$f":"'EGX - Yearly volume scenarios'!L85+'EGX - Yearly volume scenarios'!L104","v":365742},{"$f":"'EGX - Yearly volume scenarios'!M85+'EGX - Yearly volume scenarios'!M104","v":366286},{"$f":"'EGX - Yearly volume scenarios'!N85+'EGX - Yearly volume scenarios'!N104","v":366840},{"$f":"'EGX - Yearly volume scenarios'!O85+'EGX - Yearly volume scenarios'!O104","v":367404}]
["Growth Rate",null,null,null,{"$f":"LN(E28)-LN(D28)","v":3.7802360059981055E-2},{"$f":"LN(F28)-LN(E28)","v":1.4638506805155771E-3},{"$f":"LN(G28)-LN(F28)","v":1.4862822191030745E-3},{"$f":"LN(H28)-LN(G28)","v":1.5113366745982404E-3},{"$f":"LN(I28)-LN(H28)","v":1.5362743472930873E-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.7696502718112232E-3},{"$f":"SUMPRODUCT($D$30,F29)","v":3.0087031126396286E-4},{"$f":"SUMPRODUCT($D$30,G29)","v":3.0548074324775843E-4},{"$f":"SUMPRODUCT($D$30,H29)","v":3.1063027244750217E-4},{"$f":"SUMPRODUCT($D$30,I29)","v":3.1575579887295344E-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.4841940635202509E-2},{"$f":"(1+F24)*(1+F30)*(1-F34)-1","v":-3.4171145417450366E-2},{"$f":"(1+G24)*(1+G30)*(1-G34)-1","v":-3.5012384072512059E-2},{"$f":"(1+H24)*(1+H30)*(1-H34)-1","v":-3.3025785550619524E-2},{"$f":"(1+I24)*(1+I30)*(1-I34)-1","v":-3.1762587710633228E-2}]
["Rate of Change - Cumulative",null,null,null,{"$f":"PRODUCT(1+$D38:E38)-1","v":-2.4841940635202509E-2},{"$f":"PRODUCT(1+$D38:F38)-1","v":-5.8164208486755742E-2},{"$f":"PRODUCT(1+$D38:G38)-1","v":-9.1140124952455825E-2},{"$f":"PRODUCT(1+$D38:H38)-1","v":-0.12115593628133892},{"$f":"PRODUCT(1+$D38:I38)-1","v":-0.14907029793917226}]

{"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":954110.73926782899}]
["   Contractor",6530695.4500000011,{"$f":"B5*'Cost Escalations'!$E$21","v":7146767.8375381492}]
["   Materials",1898621.2599999998,{"$f":"B6*'Cost Escalations'!$E$21","v":2077727.4733633692}]
["   Other",1011.36,{"$f":"B7*'Cost Escalations'!$E$21","v":1106.7665267062148}]
["Damage/Emergency"]
["   Labour",554577.46,{"$f":"B9*'Cost Escalations'!$E$21","v":606893.45949390403}]
["   Contractor",1368158.03,{"$f":"B10*'Cost Escalations'!$E$21","v":1497223.056921687}]
["   Materials",476783.69000000006,{"$f":"B11*'Cost Escalations'!$E$21","v":521761.02334625926}]
["Other",7016.1100000000006,{"$f":"B12*'Cost Escalations'!$E$21","v":7677.973912047878}]
["Total direct opex",11708726.949999999,{"$f":"SUM(C4:C12)","v":12813268.330369951}]
["Adjustments (material costs)"]
["LED Lamps",-700000,{"$f":"B15*'Cost Escalations'!$E$21","v":-766034.41770917422}]
["Base Opex",{"$f":"+B15+B13","v":11008726.949999999},{"$f":"C13+C15","v":12047233.912660778}]
["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":330371.46699534263}]
["Material oncosts",null,{"$f":"(C6+C11+C15)*Overheads!D9","v":159816.98949665562}]
["Network overheads",null,{"$f":"(C16+C21+C22+C23)*Overheads!D19","v":2493291.3179147816}]
["Non-network overheads",null,{"$f":"(C4+C9)*Overheads!D20","v":684490.32979095355}]
["Non-network depreciation",null,{"$f":"(C4+C9)*Overheads!D25","v":229569.27812702302}]
["Corporate overheads",null,{"$f":"($C$16+$C$22+$C$23)*Overheads!D26","v":1579280.1523700487}]
["Market",null,{"$f":"($C$16+$C$22+$C$23)*Overheads!D27","v":90776.429889162333}]
["Customer ops",null,{"$f":"($C$16+$C$22+$C$23)*Overheads!D28","v":759986.40347409667}]
["Total",null,{"$f":"SUM(C21:C29)","v":6327582.368058065}]
["Base Opex (Gross)",null,{"$f":"C16+C30","v":18374816.280718841}]
[]
["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'!E6/0.82)*'EGX - Opex BST'!E5","v":7004158.7116151992},{"$f":"E37/('EGX - Opex BST'!F5+'EGX - Opex BST'!F6/0.82)*'EGX - Opex BST'!F5","v":4959384.3054388994},{"$f":"F37/('EGX - Opex BST'!G5+'EGX - Opex BST'!G6/0.82)*'EGX - Opex BST'!G5","v":3120152.4337904016},{"$f":"G37/('EGX - Opex BST'!H5+'EGX - Opex BST'!H6/0.82)*'EGX - Opex BST'!H5","v":1475944.4250361365},{"$f":"H37/('EGX - Opex BST'!I5+'EGX - Opex BST'!I6/0.82)*'EGX - Opex BST'!I5","v":0}]
["LED opex",null,null,{"$f":"D37-D35","v":10914191.473875271},{"$f":"E37-E35","v":12346675.330222379},13579980.795125306,14672653.785194624,15635676.94317453]
["Total ",null,null,{"$f":"C31*(1+'EGX - Opex BST'!E39)","v":17918350.18549047},{"$f":"$C$31*(1+'EGX - Opex BST'!F39)","v":17306059.635661278},{"$f":"$C$31*(1+'EGX - Opex BST'!G39)","v":16700133.228915706},{"$f":"$C$31*(1+'EGX - Opex BST'!H39)","v":16148598.21023076},{"$f":"$C$31*(1+'EGX - Opex BST'!I39)","v":15635676.94317453}]