{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["AER Final Decision","AER Final decision changes","Cover page","Inputs","Calc","Output"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":17,"defined_names":1499,"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":"AER Final Decision","index":0,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["AER Final Decision for Ergon Energy - Rate 2B - Smart Control Annual Prices"]
[]
[]
[null,"Year","2025-26","2026-27","2027-28","2028-29","2029-30"]
["AER Final Decision","Rate 2B - Gifted & Ergon Energy operated",{"$f":"Calc!C29*Inputs!C16","v":34.234457335043999},{"$f":"Calc!D29*Inputs!D16","v":35.158787683090189},{"$f":"Calc!E29*Inputs!E16","v":36.084635758744895},{"$f":"Calc!F29*Inputs!F16","v":37.112207550735022},{"$f":"Calc!G29*Inputs!G16","v":37.936078278466503}]
["Revised Proposal","Rate 2B - Gifted & Ergon Energy operated",34.632891553816741,34.632891553816741,35.741144083538877,36.985915107072977,38.065176236426908]
[]
[null,null,"Difference",{"$f":"D5-D6","v":0.52589612927344831},{"$f":"E5-E6","v":0.34349167520601753},{"$f":"F5-F6","v":0.12629244366204517},{"$f":"G5-G6","v":-0.12909795796040413}]
[]
[]
[null,"Note: There are no prices for smart controls for 2025–26 as it is introduced in 2026-27. Our final decision is to update the smart control models for CPI to derive the prices for 2026–27."]

{"sheet":"AER Final decision changes","index":1,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Cell","Description of Change"]
[" 'Inputs'C23","Updated USD/AUD exchange spot rate","Source used",null,"https://www.rba.gov.au/statistics/historical-data.html#exchange-rates"]
[" 'Inputs' row 9 and row 14","Updated forecast CPI","Source used",null,"AER modelling"]

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

{"sheet":"Inputs","index":3,"n_rows":50,"n_cols":17,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Inputs and Assumptions"]
[]
[null,"Rates",null,null,null,null,null,null,null,null,null,null,"AER notes"]
[null,"Ergon Energy (Gifted & Operated)","Rate 2B","Smart control devices"]
[]
[null,"Escalations"]
[null,"Year","2022-23","2023-24","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30"]
[null,"CPI",0.06,3.7999999999999999E-2,2.8000000000000001E-2,3.2000000000000001E-2,2.7E-2,2.6333333333333334E-2,2.5666666666666667E-2,2.5000000000000001E-2,null,null,"Updated CPI actual and forecast"]
[null,"Escalations",1,{"$f":"C10*(1+D9)","v":1.038},{"$f":"D10*(1+E9)","v":1.067064},1.101210048,1.130942719296,1.160724210904128,1.1905161323173341,1.2202790356252673]
[null,null,null,null,1,{"$f":"E11*(1+F9)","v":1.032},{"$f":"F11*(1+G9)","v":1.0598639999999999},1.0877737519999999,1.1156932783013334,1.1435856102588666]
[null,"Price Smoothing Inputs"]
[null,"Year","2025-26","2026-27","2027-28","2028-29","2029-30"]
[null,"Forecast CPI",3.2000000000000001E-2,2.7E-2,2.6333333333333334E-2,2.5666666666666667E-2,2.5000000000000001E-2,null,null,null,null,null,"Updated CPI forecast"]
[null,"Discount rate for smoothing",5.7540005878369146E-2,5.8017342057685301E-2,5.8745467609823812E-2,5.9832552994105968E-2,6.0942939047335054E-2,"Same as public lighting"]
[null,"Days in each year",365,365,365,366,365]
[]
[]
[null,"X factor",0]
[null,"Days each year (average)",365.25]
[]
[null,"Exchange rate"]
[null,"USD/AUD",{"$f":"1/0.6289","v":1.590077913817777},"2025-03-31",null,null,null,null,null,null,null,null,"Updated USD/AUD exchange rate",null,"Source used",null,"https://www.rba.gov.au/statistics/historical-data.html#exchange-rates"]
[]
[]
[null,"Proportion of asset base related to refurbishment",0.05]
[]
[null,"GST excl"]
["Source","Cost components","$ 2024-25","Currency","Unit"]
["DTMR SOA","Data Management System",{"$f":"0.21*E10","v":0.22408343999999999},"USD to AUD","$/unit/month"]
["DTMR SOA","Testra Telecommunications",{"$f":"0.83*E10","v":0.88566311999999991},"AUD","$/unit/month"]
["DTMR SOA","VPN Build and Implementation - blended network",{"$f":"14400*E10","v":15365.721600000001},"AUD","$/annual"]
["DTMR SOA","Training",{"$f":"(1750*2)*E10","v":3734.7240000000002},"AUD","$/day",2,"Number of days to be confirmed"]
["DTMR SOA","Implementation services",{"$f":"1750*E10","v":1867.3620000000001},"AUD","$/day",3,"Number of days to be confirmed"]
["DTMR SOA","Annual hosting and maintenance fee",{"$f":"5400*E10","v":5762.1455999999998},"AUD","$/annual"]
["Ironbark","Opticity Lighting Asset Mapper",0.7,"AUD","$/unit/year"]
["Ironbark","Opticity Smarts Manager",3,"AUD","$/unit/year"]
["EQL","Internal Set up costs",{"$f":"200000+33000","v":233000},"AUD","One off",null,"Portion allocated to Energex"]
[null,"Asset life (years)",10]
[]
[null,"Intallation costs (Direct, $22-23)",68.91]
[null,"Overheads"]
[null,"Network overheads",{"$f":"0.199","v":0.19900000000000001}]
[null,"Other ACS corporate allocations",{"$f":"0.126+0.007+0.061","v":0.19400000000000001}]
[null,"Intallation costs (Incl of overheads)",{"$f":"C41*(1+(C43+C44))","v":95.991630000000001}]
[]
[]
[null,"Starting price",0.16085331371847933]
[]
[null,"USD to AUD exchange rate",1.57]

{"sheet":"Calc","index":4,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[null,"Ergon Energy - Smart Control Public Lighting Model"]
[]
[null,"Quantities"]
[]
[null,"Year","2025-26","2026-27","2027-28","2028-29","2029-30"]
[null,"Opening ",0,1000,3000,5000,7000]
[null,"Closing",null,3500,5000,7000,10000]
[null,"Average",{"$f":"AVERAGE(C6:C7)","v":0},{"$f":"AVERAGE(D6:D7)","v":2250},4000,6000,8500]
[null,"Total ",{"$f":"C8","v":0},{"$f":"D8","v":2250},4000,6000,8500]
[]
[null,"Revenue ($ nominal)","2025-26","2026-27","2027-28","2028-29","2029-30"]
[null,"Data Management System",0,{"$f":"(Inputs!$C$30*Inputs!G11)*Inputs!$C$23*D9*12","v":10196.287515357479},{"$f":"(Inputs!$C$30*Inputs!H11)*Inputs!$C$23*E9*12","v":18604.07067246559},{"$f":"(Inputs!$C$30*Inputs!I11)*Inputs!$C$23*F9*12","v":28622.362729588313},{"$f":"(Inputs!$C$30*Inputs!J11)*Inputs!$C$23*G9*12","v":41562.055880256361}]
[null,"Testra Telecommunications",0,{"$f":"Inputs!$C$31*Inputs!G11*D9*12","v":25344.426339423357},{"$f":"Inputs!$C$31*Inputs!H11*E9*12","v":46243.25256242045},{"$f":"Inputs!$C$31*Inputs!I11*F9*12","v":71145.244067283871},{"$f":"Inputs!$C$31*Inputs!J11*G9*12","v":103308.82315603511}]
[null,"VPN Build and Implementation - blended network",0,{"$f":"Inputs!$C$32*Inputs!G11","v":16285.5751578624},{"$f":"Inputs!$C$32*Inputs!H11","v":16714.428637019442},{"$f":"Inputs!$C$32*Inputs!I11","v":17143.43230536961},{"$f":"Inputs!$C$32*Inputs!J11","v":17572.018113003851}]
[null,"Training",0,{"$f":"Inputs!$C$33*Inputs!$F$33*Inputs!G11","v":7916.5990350719994},{"$f":"Inputs!$C$33*Inputs!$F$33*Inputs!H11","v":8125.0694763288957},{"$f":"Inputs!$C$33*Inputs!$F$33*Inputs!I11","v":8333.6129262213381},{"$f":"Inputs!$C$33*Inputs!$F$33*Inputs!J11","v":8541.9532493768711}]
[null,"Implementation services",0]
[null,"Annual hosting and maintenance fee",0,{"$f":"Inputs!$C$35*Inputs!G11","v":6107.0906841983997},{"$f":"Inputs!$C$35*Inputs!H11","v":6267.9107388822904},{"$f":"Inputs!$C$35*Inputs!I11","v":6428.7871145136032},{"$f":"Inputs!$C$35*Inputs!J11","v":6589.5067923764427}]
[null,"Opticity (Lighting Asset Mapper & Smarts Manager)",0,{"$f":"(Inputs!$C$36+Inputs!$C$37)*D9","v":8325},{"$f":"(Inputs!$C$36+Inputs!$C$37)*E9","v":14800},{"$f":"(Inputs!$C$36+Inputs!$C$37)*F9","v":22200},{"$f":"(Inputs!$C$36+Inputs!$C$37)*G9","v":31450}]
[null,"Internal Setup costs",0,{"$f":"(Inputs!$C$38/Inputs!$C$39)*Inputs!G11","v":24694.831199999997},{"$f":"(Inputs!$C$38/Inputs!$C$39)*Inputs!H11","v":25345.128421599999},{"$f":"(Inputs!$C$38/Inputs!$C$39)*Inputs!I11","v":25995.653384421068},{"$f":"(Inputs!$C$38/Inputs!$C$39)*Inputs!J11","v":26645.544719031594}]
[]
[null,"Installation  costs (replacement of faulty assets)",{"$f":"(C9*Inputs!$C$26)*Inputs!$C$45*Inputs!F11","v":0},{"$f":"(D9*Inputs!$C$26)*Inputs!$C$45*Inputs!G11","v":11445.533205561},{"$f":"(E9*Inputs!$C$26)*Inputs!$C$45*Inputs!H11","v":20883.435105139153},{"$f":"(F9*Inputs!$C$26)*Inputs!$C$45*Inputs!I11","v":32129.164909256586},{"$f":"(G9*Inputs!$C$26)*Inputs!$C$45*Inputs!J11","v":46654.224878649664}]
[]
[null,"Total revenue",{"$f":"SUM(C12:C21)","v":0},{"$f":"SUM(D12:D21)","v":110315.34313747464},{"$f":"SUM(E12:E21)","v":156983.29561385582},{"$f":"SUM(F12:F21)","v":211998.25743665441},{"$f":"SUM(G12:G21)","v":282324.12678872992}]
[]
[]
[null,"Price components","2025-26","2026-27","2027-28","2028-29","2029-30"]
["Annual ","Annual opex charge (per unit)",0,{"$f":"D23/D9","v":49.029041394433172},39.245823903463958,35.333042906109071,33.214603151615286]
["Daily","Unsmoothed daily charge (per unit)",0,{"$f":"D27/Inputs!$C$20","v":0.13423419957408123},{"$f":"E27/Inputs!$C$20","v":0.10744920986574663},{"$f":"F27/Inputs!$C$20","v":9.6736599332263029E-2},{"$f":"G27/Inputs!$C$20","v":9.0936627382930277E-2}]
["Daily","Smoothed daily charge (per unit)",{"$f":"Inputs!C48*(1+Inputs!$C$14)*(1-$C$46)","v":9.3793033794641101E-2},{"$f":"C29*(1+Inputs!$D$14)*(1-Inputs!$D$19)","v":9.6325445707096405E-2},{"$f":"D29*(1+Inputs!$E$14)*(1-Inputs!$E$19)","v":9.886201577738328E-2},{"$f":"E29*(1+Inputs!$F$14)*(1-Inputs!$F$19)","v":0.10139947418233612},{"$f":"F29*(1+Inputs!$G$14)*(1-Inputs!$G$19)","v":0.10393446103689452}]
[]
[null,"Revenue checks","2025-26","2026-27","2027-28","2028-29","2029-30"]
[]
[null,"Cummulative discount rate (used for NPV calculation)",{"$f":"1+Inputs!C15","v":1.057540005878369},{"$f":"C33*(1+Inputs!D15)","v":1.118895666139101},{"$f":"D33*(1+Inputs!E15)","v":1.1846257152530477},{"$f":"E33*(1+Inputs!F15)","v":1.2555048961391064},{"$f":"F33*(1+Inputs!G15)","v":1.3320190544981427}]
[]
[null,"Smart control device opex "]
[null,"Unsmoothed Prices x Volumes",0,{"$f":"D28*D9*Inputs!$C$20","v":110315.34313747463},{"$f":"E28*E9*Inputs!$C$20","v":156983.29561385582},{"$f":"F28*F9*Inputs!$C$20","v":211998.25743665441},{"$f":"G28*G9*Inputs!$C$20","v":282324.12678872992}]
[null,"Revenue requirement",0,{"$f":"D23","v":110315.34313747464},156983.29561385582,211998.25743665441,282324.12678872992]
[null,"Check",0,{"$f":"D36-D37","v":0},0,0,0]
[]
[null,"Smoothed Prices x Volumes",{"$f":"C29*C9*Inputs!$C$20","v":0},{"$f":"D29*D9*Inputs!$C$20","v":79161.45535016316},{"$f":"E29*E9*Inputs!$C$20","v":144437.40505075696},{"$f":"F29*F9*Inputs!$C$20","v":222216.94767058961},{"$f":"G29*G9*Inputs!$C$20","v":322677.52609666868}]
[]
[null,"NPV Revenue requirement",{"$f":"(C37/C33)+(D37/D33)+(E37/E33)+(F37/F33)+(G37/G33)","v":611917.26761505031}]
[null,"NPV Smoothed Prices x Volume",{"$f":"(C40/C33)+(D40/D33)+(E40/E33)+(F40/F33)+(G40/G33)","v":611917.26761505054}]
[null,"Check",{"$f":"C42-C43","v":0}]
[]
[null,"P0 Rate 2B",0.43498383360451254]

{"sheet":"Output","index":5,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"Smart control annual prices"]
[]
[null,"Year","2025-26","2026-27","2027-28","2028-29","2029-30"]
[null,"Rate 2B - Gifted & Ergon Energy operated",{"$f":"Calc!C29*Inputs!C16","v":34.234457335043999},{"$f":"Calc!D29*Inputs!D16","v":35.158787683090189},{"$f":"Calc!E29*Inputs!E16","v":36.084635758744895},{"$f":"Calc!F29*Inputs!F16","v":37.112207550735022},{"$f":"Calc!G29*Inputs!G16","v":37.936078278466503}]
[]
[null,"Daily","2025-26","2026-27","2027-28","2028-29","2029-30"]
[null,"Rate 2B - Gifted & Ergon Energy operated",{"$f":"Calc!C29","v":9.3793033794641101E-2},{"$f":"Calc!D29","v":9.6325445707096405E-2},{"$f":"Calc!E29","v":9.886201577738328E-2},{"$f":"Calc!F29","v":0.10139947418233612},{"$f":"Calc!G29","v":0.10393446103689452}]