{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Pricing model - ACS","General Inputs","ERG -Security Lighting Services","Lookup Tables","Model update log"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":1,"defined_names":19,"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":"Pricing model - ACS","index":0,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,"Ergon Energy Pricing Model - Price Capped Security Lighting Services"]
[null,null,null,null,null,null,"2025-30"]

{"sheet":"General Inputs","index":1,"n_rows":49,"n_cols":21,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Pricing model - ACS'!G2&\" - \"&'Pricing model - ACS'!G3","v":"Ergon Energy Pricing Model - Price Capped Security Lighting Services - 2025-30"}]
[null,{"$f":"'Pricing model - ACS'!#REF!&\" - \"&'Pricing model - ACS'!#REF!","v":{"$error":"#REF!"}}]
[]
[]
[1,"Input table 1 | General inputs"]
[]
[null,null,"Inputs","Value"]
[null,null,"DNSP name","Ergon Energy"]
[null,null,"Year ending","2000-06-01"]
[null,null,"Forecast regulatory year (t)","2025–26"]
[null,null,"Current regulatory year (t-1)",{"$f":"IF(INDEX('Lookup Tables'!I60:I61,MATCH(DNSP,'Lookup Tables'!G60:G61,0))=\"Vic\",\nINDEX('Lookup Tables'!L24:L46,MATCH(forecastyear,'Lookup Tables'!I24:I46,0)-1),\nINDEX('Lookup Tables'!I24:I46,MATCH(forecastyear,'Lookup Tables'!I24:I46,0)-1))","v":"2024–25"}]
[null,null,"Current regulatory control period, first year","2025–26"]
[null,null,"Current regulatory control period, last year",{"$f":"'Lookup Tables'!G55","v":"2029–30"}]
[]
[null,"Input table 2 | Other inputs",null,"Source",null,"Unit",null,null,null,"2020-21","2021-22","2022-23","2023-24","2024-25",null,"2025-26","2026-27","2027-28","2028-29","2029-30","Notes"]
[]
[null,null,"Inflation","'General'",null,"Per cent",null,null,null,{"$f":"G26","v":1.8404907975460238E-2},{"$f":"G27","v":8.6058519793459354E-3},{"$f":"G28","v":3.4982935153583528E-2},{"$f":"G29","v":7.8318219291014124E-2},{"$f":"G30","v":4.0519877675840865E-2},null,3.2000000000000001E-2,2.7E-2,2.6333333333333334E-2,2.5666666666666667E-2,2.5000000000000001E-2]
[]
[null,null,"Security Lighting Services X-factor","Forecast wage price escalation",null,"Per cent",null,null,null,null,-9.8252646141938002E-3,-1.0493456191476618E-2,-1.0262247478872492E-2,-9.6681803386212059E-3,null,0,-1.0870090668475489E-2,-8.7466278382324451E-3,-9.5315736522133768E-3,-1.1515925226694229E-2]
[]
[null,"Input table 3 | Inflation"]
[]
[null,null,null,null,null,"Index value","Inflation",null,null,null,"Applicable regulatory year"]
[null,null,"Source",null,null,"ABS","Calculated"]
[null,null,"Unit",null,null,"index","Percent"]
[null,null,"2019-12-31",null,null,116.2,1.8404907975460238E-2,null,null,null,{"$f":"IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61))=\"Vic\",INDEX('Lookup Tables'!$L$24:$L$46,MATCH(EDATE(C26,18),'Lookup Tables'!$H$24:$H$46)),INDEX('Lookup Tables'!$I$24:$I$46,MATCH(EDATE(C26,18),'Lookup Tables'!$H$24:$H$46)))","v":"2020–21"},null,null,{"$f":"IF(LEFT(K26,2)=\"HY\",F26/#REF!-1,\"\")","v":""}]
[null,null,"2020-12-31",null,null,117.2,{"$f":"F27/F26-1","v":8.6058519793459354E-3},null,null,null,{"$f":"IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61))=\"Vic\",INDEX('Lookup Tables'!$L$24:$L$46,MATCH(EDATE(C27,18),'Lookup Tables'!$H$24:$H$46)),INDEX('Lookup Tables'!$I$24:$I$46,MATCH(EDATE(C27,18),'Lookup Tables'!$H$24:$H$46)))","v":"2021–22"}]
[null,null,"2021-12-31",null,null,121.3,{"$f":"F28/F27-1","v":3.4982935153583528E-2},null,null,null,{"$f":"IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61))=\"Vic\",INDEX('Lookup Tables'!$L$24:$L$46,MATCH(EDATE(C28,18),'Lookup Tables'!$H$24:$H$46)),INDEX('Lookup Tables'!$I$24:$I$46,MATCH(EDATE(C28,18),'Lookup Tables'!$H$24:$H$46)))","v":"2022–23"}]
[null,null,"2022-12-31",null,null,130.80000000000001,7.8318219291014124E-2,null,null,null,{"$f":"IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61))=\"Vic\",INDEX('Lookup Tables'!$L$24:$L$46,MATCH(EDATE(C29,18),'Lookup Tables'!$H$24:$H$46)),INDEX('Lookup Tables'!$I$24:$I$46,MATCH(EDATE(C29,18),'Lookup Tables'!$H$24:$H$46)))","v":"2023–24"}]
[null,null,"2023-12-01",null,null,136.1,4.0519877675840865E-2,null,null,null,"2024-25"]
[null,null,"2024-12-31",null,null,139.4,2.4246877296105973E-2,null,null,null,{"$f":"IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61))=\"Vic\",INDEX('Lookup Tables'!$L$24:$L$46,MATCH(EDATE(C31,18),'Lookup Tables'!$H$24:$H$46)),INDEX('Lookup Tables'!$I$24:$I$46,MATCH(EDATE(C31,18),'Lookup Tables'!$H$24:$H$46)))","v":"2025–26"}]
[null,null,"2025-12-31",null,null,null,null,null,null,null,{"$f":"IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61))=\"Vic\",INDEX('Lookup Tables'!$L$24:$L$46,MATCH(EDATE(C32,18),'Lookup Tables'!$H$24:$H$46)),INDEX('Lookup Tables'!$I$24:$I$46,MATCH(EDATE(C32,18),'Lookup Tables'!$H$24:$H$46)))","v":"2026–27"}]
[null,null,"2026-12-31",null,null,null,{"$f":"IF(MATCH(C33,$C$26:$C$47,0)<=4,\"\",IF(AND(C33>=IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61,0))=\"Vic\",(INDEX('Lookup Tables'!$K$24:$K$46,MATCH(currentyear,'Lookup Tables'!$L$24:$L$46,0))),(INDEX('Lookup Tables'!$H$24:$H$46,MATCH(currentyear,'Lookup Tables'!$I$24:$I$46,0)))),C33<='Lookup Tables'!$H$54),'General Inputs'!#REF!,IF(ISBLANK(F33),\"\",IF(C33>DATE('Lookup Tables'!#REF!,MONTH(#REF!),31),F33/F32-1,F33/F29-1))))","v":{"$error":"#REF!"}},null,null,null,{"$f":"IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61))=\"Vic\",INDEX('Lookup Tables'!$L$24:$L$46,MATCH(EDATE(C33,18),'Lookup Tables'!$H$24:$H$46)),INDEX('Lookup Tables'!$I$24:$I$46,MATCH(EDATE(C33,18),'Lookup Tables'!$H$24:$H$46)))","v":"2027–28"}]
[null,null,"2027-12-31",null,null,null,{"$f":"IF(MATCH(C34,$C$26:$C$47,0)<=4,\"\",IF(AND(C34>=IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61,0))=\"Vic\",(INDEX('Lookup Tables'!$K$24:$K$46,MATCH(currentyear,'Lookup Tables'!$L$24:$L$46,0))),(INDEX('Lookup Tables'!$H$24:$H$46,MATCH(currentyear,'Lookup Tables'!$I$24:$I$46,0)))),C34<='Lookup Tables'!$H$54),'General Inputs'!#REF!,IF(ISBLANK(F34),\"\",IF(C34>DATE('Lookup Tables'!#REF!,MONTH(#REF!),31),F34/F33-1,F34/F30-1))))","v":{"$error":"#REF!"}},null,null,null,{"$f":"IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61))=\"Vic\",INDEX('Lookup Tables'!$L$24:$L$46,MATCH(EDATE(C34,18),'Lookup Tables'!$H$24:$H$46)),INDEX('Lookup Tables'!$I$24:$I$46,MATCH(EDATE(C34,18),'Lookup Tables'!$H$24:$H$46)))","v":"2028–29"}]
[null,null,"2028-12-31",null,null,null,{"$f":"IF(MATCH(C35,$C$26:$C$47,0)<=4,\"\",IF(AND(C35>=IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61,0))=\"Vic\",(INDEX('Lookup Tables'!$K$24:$K$46,MATCH(currentyear,'Lookup Tables'!$L$24:$L$46,0))),(INDEX('Lookup Tables'!$H$24:$H$46,MATCH(currentyear,'Lookup Tables'!$I$24:$I$46,0)))),C35<='Lookup Tables'!$H$54),'General Inputs'!#REF!,IF(ISBLANK(F35),\"\",IF(C35>DATE('Lookup Tables'!#REF!,MONTH(#REF!),31),F35/F34-1,F35/F31-1))))","v":{"$error":"#REF!"}},null,null,null,{"$f":"IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61))=\"Vic\",INDEX('Lookup Tables'!$L$24:$L$46,MATCH(EDATE(C35,18),'Lookup Tables'!$H$24:$H$46)),INDEX('Lookup Tables'!$I$24:$I$46,MATCH(EDATE(C35,18),'Lookup Tables'!$H$24:$H$46)))","v":"2029–30"}]
[null,null,"2029-12-31",null,null,null,{"$f":"IF(MATCH(C36,$C$26:$C$47,0)<=4,\"\",IF(AND(C36>=IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61,0))=\"Vic\",(INDEX('Lookup Tables'!$K$24:$K$46,MATCH(currentyear,'Lookup Tables'!$L$24:$L$46,0))),(INDEX('Lookup Tables'!$H$24:$H$46,MATCH(currentyear,'Lookup Tables'!$I$24:$I$46,0)))),C36<='Lookup Tables'!$H$54),'General Inputs'!#REF!,IF(ISBLANK(F36),\"\",IF(C36>DATE('Lookup Tables'!#REF!,MONTH(#REF!),31),F36/F35-1,F36/F32-1))))","v":""},null,null,null,{"$f":"IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61))=\"Vic\",INDEX('Lookup Tables'!$L$24:$L$46,MATCH(EDATE(C36,18),'Lookup Tables'!$H$24:$H$46)),INDEX('Lookup Tables'!$I$24:$I$46,MATCH(EDATE(C36,18),'Lookup Tables'!$H$24:$H$46)))","v":"2030–31"}]
[null,null,"2030-12-31",null,null,null,{"$f":"IF(MATCH(C37,$C$26:$C$47,0)<=4,\"\",IF(AND(C37>=IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61,0))=\"Vic\",(INDEX('Lookup Tables'!$K$24:$K$46,MATCH(currentyear,'Lookup Tables'!$L$24:$L$46,0))),(INDEX('Lookup Tables'!$H$24:$H$46,MATCH(currentyear,'Lookup Tables'!$I$24:$I$46,0)))),C37<='Lookup Tables'!$H$54),'General Inputs'!#REF!,IF(ISBLANK(F37),\"\",IF(C37>DATE('Lookup Tables'!#REF!,MONTH(#REF!),31),F37/F36-1,F37/F33-1))))","v":""},null,null,null,{"$f":"IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61))=\"Vic\",INDEX('Lookup Tables'!$L$24:$L$46,MATCH(EDATE(C37,18),'Lookup Tables'!$H$24:$H$46)),INDEX('Lookup Tables'!$I$24:$I$46,MATCH(EDATE(C37,18),'Lookup Tables'!$H$24:$H$46)))","v":"2031–32"}]
[null,null,"2031-12-31",null,null,null,{"$f":"IF(MATCH(C38,$C$26:$C$47,0)<=4,\"\",IF(AND(C38>=IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61,0))=\"Vic\",(INDEX('Lookup Tables'!$K$24:$K$46,MATCH(currentyear,'Lookup Tables'!$L$24:$L$46,0))),(INDEX('Lookup Tables'!$H$24:$H$46,MATCH(currentyear,'Lookup Tables'!$I$24:$I$46,0)))),C38<='Lookup Tables'!$H$54),'General Inputs'!#REF!,IF(ISBLANK(F38),\"\",IF(C38>DATE('Lookup Tables'!#REF!,MONTH(#REF!),31),F38/F37-1,F38/F34-1))))","v":""},null,null,null,{"$f":"IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61))=\"Vic\",INDEX('Lookup Tables'!$L$24:$L$46,MATCH(EDATE(C38,18),'Lookup Tables'!$H$24:$H$46)),INDEX('Lookup Tables'!$I$24:$I$46,MATCH(EDATE(C38,18),'Lookup Tables'!$H$24:$H$46)))","v":"2032–33"}]
[null,null,"2032-12-31",null,null,null,{"$f":"IF(MATCH(C39,$C$26:$C$47,0)<=4,\"\",IF(AND(C39>=IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61,0))=\"Vic\",(INDEX('Lookup Tables'!$K$24:$K$46,MATCH(currentyear,'Lookup Tables'!$L$24:$L$46,0))),(INDEX('Lookup Tables'!$H$24:$H$46,MATCH(currentyear,'Lookup Tables'!$I$24:$I$46,0)))),C39<='Lookup Tables'!$H$54),'General Inputs'!#REF!,IF(ISBLANK(F39),\"\",IF(C39>DATE('Lookup Tables'!#REF!,MONTH(#REF!),31),F39/F38-1,F39/F35-1))))","v":""},null,null,null,{"$f":"IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61))=\"Vic\",INDEX('Lookup Tables'!$L$24:$L$46,MATCH(EDATE(C39,18),'Lookup Tables'!$H$24:$H$46)),INDEX('Lookup Tables'!$I$24:$I$46,MATCH(EDATE(C39,18),'Lookup Tables'!$H$24:$H$46)))","v":"2033–34"}]
[null,null,"2033-12-31",null,null,null,{"$f":"IF(MATCH(C40,$C$26:$C$47,0)<=4,\"\",IF(AND(C40>=IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61,0))=\"Vic\",(INDEX('Lookup Tables'!$K$24:$K$46,MATCH(currentyear,'Lookup Tables'!$L$24:$L$46,0))),(INDEX('Lookup Tables'!$H$24:$H$46,MATCH(currentyear,'Lookup Tables'!$I$24:$I$46,0)))),C40<='Lookup Tables'!$H$54),'General Inputs'!#REF!,IF(ISBLANK(F40),\"\",IF(C40>DATE('Lookup Tables'!#REF!,MONTH(#REF!),31),F40/F39-1,F40/F36-1))))","v":""},null,null,null,{"$f":"IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61))=\"Vic\",INDEX('Lookup Tables'!$L$24:$L$46,MATCH(EDATE(C40,18),'Lookup Tables'!$H$24:$H$46)),INDEX('Lookup Tables'!$I$24:$I$46,MATCH(EDATE(C40,18),'Lookup Tables'!$H$24:$H$46)))","v":"2034–35"}]
[null,null,"2034-12-31",null,null,null,{"$f":"IF(MATCH(C41,$C$26:$C$47,0)<=4,\"\",IF(AND(C41>=IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61,0))=\"Vic\",(INDEX('Lookup Tables'!$K$24:$K$46,MATCH(currentyear,'Lookup Tables'!$L$24:$L$46,0))),(INDEX('Lookup Tables'!$H$24:$H$46,MATCH(currentyear,'Lookup Tables'!$I$24:$I$46,0)))),C41<='Lookup Tables'!$H$54),'General Inputs'!#REF!,IF(ISBLANK(F41),\"\",IF(C41>DATE('Lookup Tables'!#REF!,MONTH(#REF!),31),F41/F40-1,F41/F37-1))))","v":""},null,null,null,{"$f":"IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61))=\"Vic\",INDEX('Lookup Tables'!$L$24:$L$46,MATCH(EDATE(C41,18),'Lookup Tables'!$H$24:$H$46)),INDEX('Lookup Tables'!$I$24:$I$46,MATCH(EDATE(C41,18),'Lookup Tables'!$H$24:$H$46)))","v":"2035–36"}]
[null,null,"2035-12-31",null,null,null,{"$f":"IF(MATCH(C42,$C$26:$C$47,0)<=4,\"\",IF(AND(C42>=IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61,0))=\"Vic\",(INDEX('Lookup Tables'!$K$24:$K$46,MATCH(currentyear,'Lookup Tables'!$L$24:$L$46,0))),(INDEX('Lookup Tables'!$H$24:$H$46,MATCH(currentyear,'Lookup Tables'!$I$24:$I$46,0)))),C42<='Lookup Tables'!$H$54),'General Inputs'!#REF!,IF(ISBLANK(F42),\"\",IF(C42>DATE('Lookup Tables'!#REF!,MONTH(#REF!),31),F42/F41-1,F42/F38-1))))","v":""},null,null,null,{"$f":"IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61))=\"Vic\",INDEX('Lookup Tables'!$L$24:$L$46,MATCH(EDATE(C42,18),'Lookup Tables'!$H$24:$H$46)),INDEX('Lookup Tables'!$I$24:$I$46,MATCH(EDATE(C42,18),'Lookup Tables'!$H$24:$H$46)))","v":"2036–37"}]
[null,null,"2036-12-31",null,null,null,{"$f":"IF(MATCH(C43,$C$26:$C$47,0)<=4,\"\",IF(AND(C43>=IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61,0))=\"Vic\",(INDEX('Lookup Tables'!$K$24:$K$46,MATCH(currentyear,'Lookup Tables'!$L$24:$L$46,0))),(INDEX('Lookup Tables'!$H$24:$H$46,MATCH(currentyear,'Lookup Tables'!$I$24:$I$46,0)))),C43<='Lookup Tables'!$H$54),'General Inputs'!#REF!,IF(ISBLANK(F43),\"\",IF(C43>DATE('Lookup Tables'!#REF!,MONTH(#REF!),31),F43/F42-1,F43/F39-1))))","v":""},null,null,null,{"$f":"IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61))=\"Vic\",INDEX('Lookup Tables'!$L$24:$L$46,MATCH(EDATE(C43,18),'Lookup Tables'!$H$24:$H$46)),INDEX('Lookup Tables'!$I$24:$I$46,MATCH(EDATE(C43,18),'Lookup Tables'!$H$24:$H$46)))","v":"2037–38"}]
[null,null,"2037-12-31",null,null,null,{"$f":"IF(MATCH(C44,$C$26:$C$47,0)<=4,\"\",IF(AND(C44>=IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61,0))=\"Vic\",(INDEX('Lookup Tables'!$K$24:$K$46,MATCH(currentyear,'Lookup Tables'!$L$24:$L$46,0))),(INDEX('Lookup Tables'!$H$24:$H$46,MATCH(currentyear,'Lookup Tables'!$I$24:$I$46,0)))),C44<='Lookup Tables'!$H$54),'General Inputs'!#REF!,IF(ISBLANK(F44),\"\",IF(C44>DATE('Lookup Tables'!#REF!,MONTH(#REF!),31),F44/F43-1,F44/F40-1))))","v":""},null,null,null,{"$f":"IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61))=\"Vic\",INDEX('Lookup Tables'!$L$24:$L$46,MATCH(EDATE(C44,18),'Lookup Tables'!$H$24:$H$46)),INDEX('Lookup Tables'!$I$24:$I$46,MATCH(EDATE(C44,18),'Lookup Tables'!$H$24:$H$46)))","v":"2038–39"}]
[null,null,"2038-12-31",null,null,null,{"$f":"IF(MATCH(C45,$C$26:$C$47,0)<=4,\"\",IF(AND(C45>=IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61,0))=\"Vic\",(INDEX('Lookup Tables'!$K$24:$K$46,MATCH(currentyear,'Lookup Tables'!$L$24:$L$46,0))),(INDEX('Lookup Tables'!$H$24:$H$46,MATCH(currentyear,'Lookup Tables'!$I$24:$I$46,0)))),C45<='Lookup Tables'!$H$54),'General Inputs'!#REF!,IF(ISBLANK(F45),\"\",IF(C45>DATE('Lookup Tables'!#REF!,MONTH(#REF!),31),F45/F44-1,F45/F41-1))))","v":""},null,null,null,{"$f":"IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61))=\"Vic\",INDEX('Lookup Tables'!$L$24:$L$46,MATCH(EDATE(C45,18),'Lookup Tables'!$H$24:$H$46)),INDEX('Lookup Tables'!$I$24:$I$46,MATCH(EDATE(C45,18),'Lookup Tables'!$H$24:$H$46)))","v":"2039–40"}]
[null,null,"2039-12-31",null,null,null,{"$f":"IF(MATCH(C46,$C$26:$C$47,0)<=4,\"\",IF(AND(C46>=IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61,0))=\"Vic\",(INDEX('Lookup Tables'!$K$24:$K$46,MATCH(currentyear,'Lookup Tables'!$L$24:$L$46,0))),(INDEX('Lookup Tables'!$H$24:$H$46,MATCH(currentyear,'Lookup Tables'!$I$24:$I$46,0)))),C46<='Lookup Tables'!$H$54),'General Inputs'!#REF!,IF(ISBLANK(F46),\"\",IF(C46>DATE('Lookup Tables'!#REF!,MONTH(#REF!),31),F46/F45-1,F46/F42-1))))","v":""},null,null,null,{"$f":"IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61))=\"Vic\",INDEX('Lookup Tables'!$L$24:$L$46,MATCH(EDATE(C46,18),'Lookup Tables'!$H$24:$H$46)),INDEX('Lookup Tables'!$I$24:$I$46,MATCH(EDATE(C46,18),'Lookup Tables'!$H$24:$H$46)))","v":"2040–41"}]
[null,null,"2040-12-31",null,null,null,{"$f":"IF(MATCH(C47,$C$26:$C$47,0)<=4,\"\",IF(AND(C47>=IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61,0))=\"Vic\",(INDEX('Lookup Tables'!$K$24:$K$46,MATCH(currentyear,'Lookup Tables'!$L$24:$L$46,0))),(INDEX('Lookup Tables'!$H$24:$H$46,MATCH(currentyear,'Lookup Tables'!$I$24:$I$46,0)))),C47<='Lookup Tables'!$H$54),'General Inputs'!#REF!,IF(ISBLANK(F47),\"\",IF(C47>DATE('Lookup Tables'!#REF!,MONTH(#REF!),31),F47/F46-1,F47/F43-1))))","v":""},null,null,null,{"$f":"IF(INDEX('Lookup Tables'!$I$60:$I$61,MATCH(DNSP,'Lookup Tables'!$G$60:$G$61))=\"Vic\",INDEX('Lookup Tables'!$L$24:$L$46,MATCH(EDATE(C47,18),'Lookup Tables'!$H$24:$H$46)),INDEX('Lookup Tables'!$I$24:$I$46,MATCH(EDATE(C47,18),'Lookup Tables'!$H$24:$H$46)))","v":"2041–42"}]
[]
[null,"End"]

{"sheet":"ERG -Security Lighting Services","index":2,"n_rows":15,"n_cols":42,"rows_kept":15,"cut":false,"hidden":false,"merged":[[3,37,3,41],[2,31,2,41],[3,20,3,23],[3,14,3,18],[3,8,3,12],[2,8,2,18],[2,20,2,29],[3,25,3,29],[3,31,3,35]]}
[null,{"$f":"'Pricing model - ACS'!G2&\" - \"&'Pricing model - ACS'!G3","v":"Ergon Energy Pricing Model - Price Capped Security Lighting Services - 2025-30"}]
[null,{"$f":"'Pricing model - ACS'!#REF!&\" - \"&'Pricing model - ACS'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"ALL PRICES ARE EXCLUDING GST",null,null,null,null,null,null,null,null,null,null,null,"X-FACTORS",null,null,null,null,null,null,null,null,null,null,"INFLATION"]
[null,null,null,null,null,null,null,null,"2020-25 regulatory control period",null,null,null,null,null,"2025-30 regulatory control period",null,null,null,null,null,"2020-25 regulatory control period",null,null,null,null,"2025-30 regulatory control period",null,null,null,null,null,"2020-25 regulatory control period",null,null,null,null,null,"2025-30 regulatory control period"]
[null,"Schedule 1 | Security Lighting Services",null,"Tariff code","Unit","Charge",null,null,"2020-21","2021-22","2022-23","2023-24","2024-25",null,"2025-26","2026-27","2027-28","2028-29","2029-30",null,{"$f":"J5","v":"2021-22"},{"$f":"K5","v":"2022-23"},{"$f":"L5","v":"2023-24"},{"$f":"M5","v":"2024-25"},null,"2025–26","2026–27","2027–28","2028–29","2029-30",null,{"$f":"I5","v":"2020-21"},{"$f":"J5","v":"2021-22"},"2022-23","2023-24","2024-25",null,{"$f":"O5","v":"2025-26"},{"$f":"P5","v":"2026-27"},"2027-28","2028-29","2029-30"]
[null,null,null,null,null,null,null,null,"Actual","Actual","Actual","Actual","Forecast",null,"Forecast","Forecast","Forecast","Forecast","Forecast",null,"Actual","Actual","Actual","Forecast",null,"Forecast","Forecast","Forecast","Forecast","Forecast",null,"Actual","Actual","Actual","Actual","Forecast",null,"Forecast","Forecast","Forecast","Forecast","Forecast"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($O7=\"\",0,'General Inputs'!K$19)","v":0},{"$f":"IF($O7=\"\",0,'General Inputs'!L$19)","v":0},{"$f":"IF($O7=\"\",0,'General Inputs'!M$19)","v":0},{"$f":"IF($O7=\"\",0,'General Inputs'!N$19)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF($O7=\"\",0,'General Inputs'!U$19)","v":0},{"$f":"IF($O7=\"\",0,'General Inputs'!V$19)","v":0},{"$f":"IF($O7=\"\",0,'General Inputs'!W$19)","v":0},{"$f":"IF($O7=\"\",0,'General Inputs'!X$19)","v":0}]
[null,null,"Security lighting small LED (W70, W100)","UWLSLED","$dollars","per year",null,null,307.77999999999997,312.74,326.25,354.53,{"$f":"ROUND(L8*(1+AJ$8)*(1-X$8),2)","v":371.59},null,{"$f":"ROUND(M8*(1+AL$8)*(1-Z$8),2)","v":383.48},{"$f":"ROUND(O8*(1+AM$8)*(1-AA$8),2)","v":398.11},{"$f":"ROUND(P8*(1+AN$8)*(1-AB$8),2)","v":412.17},426.78,442.49,null,-7.4339698815084889E-3,-7.9395355080486736E-3,-7.7645988856437937E-3,-7.3151171259523435E-3,null,{"$f":"'General Inputs'!P$19","v":0},{"$f":"'General Inputs'!Q$19","v":-1.0870090668475489E-2},{"$f":"'General Inputs'!R$19","v":-8.7466278382324451E-3},{"$f":"'General Inputs'!S$19","v":-9.5315736522133768E-3},{"$f":"'General Inputs'!T$19","v":-1.1515925226694229E-2},null,{"$f":"'General Inputs'!J$17","v":1.8404907975460238E-2},{"$f":"'General Inputs'!K17","v":8.6058519793459354E-3},{"$f":"'General Inputs'!L17","v":3.4982935153583528E-2},{"$f":"'General Inputs'!M17","v":7.8318219291014124E-2},{"$f":"'General Inputs'!$G$30","v":4.0519877675840865E-2},null,{"$f":"'General Inputs'!P$17","v":3.2000000000000001E-2},{"$f":"'General Inputs'!Q$17","v":2.7E-2},{"$f":"'General Inputs'!R$17","v":2.6333333333333334E-2},{"$f":"'General Inputs'!S$17","v":2.5666666666666667E-2},{"$f":"'General Inputs'!T$17","v":2.5000000000000001E-2}]
[null,null,"Security lighting LED (W200)","UWLMLED","$dollars","per year",null,null,365.78,371.67,387.73,421.34,{"$f":"ROUND(L9*(1+AJ$8)*(1-X$8),2)","v":441.62},null,{"$f":"ROUND(M9*(1+AL$8)*(1-Z$8),2)","v":455.75},{"$f":"ROUND(O9*(1+AM$8)*(1-AA$8),2)","v":473.14},{"$f":"ROUND(P9*(1+AN$8)*(1-AB$8),2)","v":489.85},{"$f":"ROUND(Q9*(1+AO$8)*(1-AC$8),2)","v":507.21},{"$f":"ROUND(R9*(1+AP$8)*(1-AD$8),2)","v":525.88},null,-7.4339698815084889E-3,-7.9395355080486736E-3,-7.7645988856437937E-3,-7.3151171259523435E-3,null,{"$f":"'General Inputs'!P$19","v":0},{"$f":"'General Inputs'!Q$19","v":-1.0870090668475489E-2},{"$f":"'General Inputs'!R$19","v":-8.7466278382324451E-3},{"$f":"'General Inputs'!S$19","v":-9.5315736522133768E-3},{"$f":"'General Inputs'!T$19","v":-1.1515925226694229E-2},null,1.8404907975460238E-2,8.6058519793459354E-3,3.4982935153583528E-2,7.8318219291014124E-2,{"$f":"'General Inputs'!$G$30","v":4.0519877675840865E-2},null,{"$f":"'General Inputs'!P$17","v":3.2000000000000001E-2},{"$f":"'General Inputs'!Q$17","v":2.7E-2},{"$f":"'General Inputs'!R$17","v":2.6333333333333334E-2},{"$f":"'General Inputs'!S$17","v":2.5666666666666667E-2},{"$f":"'General Inputs'!T$17","v":2.5000000000000001E-2}]
[null,null,"Security lighting small conventional (W150)","UWLSCON","$dollars","per year",null,null,392.12,398.43,415.64,451.67,473.41,null,488.56,507.21,525.12,543.73,563.74,null,-7.4339698815084889E-3,-7.9395355080486736E-3,-7.7645988856437937E-3,-7.3151171259523435E-3,null,{"$f":"'General Inputs'!P$19","v":0},{"$f":"'General Inputs'!Q$19","v":-1.0870090668475489E-2},{"$f":"'General Inputs'!R$19","v":-8.7466278382324451E-3},{"$f":"'General Inputs'!S$19","v":-9.5315736522133768E-3},{"$f":"'General Inputs'!T$19","v":-1.1515925226694229E-2},null,1.8404907975460238E-2,8.6058519793459354E-3,3.4982935153583528E-2,7.8318219291014124E-2,{"$f":"'General Inputs'!$G$30","v":4.0519877675840865E-2},null,{"$f":"'General Inputs'!P$17","v":3.2000000000000001E-2},{"$f":"'General Inputs'!Q$17","v":2.7E-2},{"$f":"'General Inputs'!R$17","v":2.6333333333333334E-2},{"$f":"'General Inputs'!S$17","v":2.5666666666666667E-2},{"$f":"'General Inputs'!T$17","v":2.5000000000000001E-2}]
[null,null,"Security lighting medium conventional (W250)","UWLMCON","$dollars","per year",null,null,404.38,410.89,428.64,465.8,488.22,null,503.84,523.07000000000005,541.54,560.73,581.37,null,-7.4339698815084889E-3,-7.9395355080486736E-3,-7.7645988856437937E-3,-7.3151171259523435E-3,null,{"$f":"'General Inputs'!P$19","v":0},{"$f":"'General Inputs'!Q$19","v":-1.0870090668475489E-2},{"$f":"'General Inputs'!R$19","v":-8.7466278382324451E-3},{"$f":"'General Inputs'!S$19","v":-9.5315736522133768E-3},{"$f":"'General Inputs'!T$19","v":-1.1515925226694229E-2},null,1.8404907975460238E-2,8.6058519793459354E-3,3.4982935153583528E-2,7.8318219291014124E-2,{"$f":"'General Inputs'!$G$30","v":4.0519877675840865E-2},null,{"$f":"'General Inputs'!P$17","v":3.2000000000000001E-2},{"$f":"'General Inputs'!Q$17","v":2.7E-2},{"$f":"'General Inputs'!R$17","v":2.6333333333333334E-2},{"$f":"'General Inputs'!S$17","v":2.5666666666666667E-2},{"$f":"'General Inputs'!T$17","v":2.5000000000000001E-2}]
[null,null,"Security lighting large conventional (W400)","UWLLCON","$dollars","per year",null,null,407.37,413.93,431.81,469.24,491.83,null,507.57,526.94000000000005,545.54999999999995,564.89,585.67999999999995,null,-7.4339698815084889E-3,-7.9395355080486736E-3,-7.7645988856437937E-3,-7.3151171259523435E-3,null,{"$f":"'General Inputs'!P$19","v":0},{"$f":"'General Inputs'!Q$19","v":-1.0870090668475489E-2},{"$f":"'General Inputs'!R$19","v":-8.7466278382324451E-3},{"$f":"'General Inputs'!S$19","v":-9.5315736522133768E-3},{"$f":"'General Inputs'!T$19","v":-1.1515925226694229E-2},null,1.8404907975460238E-2,8.6058519793459354E-3,3.4982935153583528E-2,7.8318219291014124E-2,{"$f":"'General Inputs'!$G$30","v":4.0519877675840865E-2},null,{"$f":"'General Inputs'!P$17","v":3.2000000000000001E-2},{"$f":"'General Inputs'!Q$17","v":2.7E-2},{"$f":"'General Inputs'!R$17","v":2.6333333333333334E-2},{"$f":"'General Inputs'!S$17","v":2.5666666666666667E-2},{"$f":"'General Inputs'!T$17","v":2.5000000000000001E-2}]
[null,null,null,null,null,null,null,null,{"$f":"O13","v":0},{"$f":"P13","v":0},{"$f":"Q13","v":0},{"$f":"R13","v":0},{"$f":"S13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($O13=\"\",0,'General Inputs'!K$19)","v":0},{"$f":"IF($O13=\"\",0,'General Inputs'!L$19)","v":0},{"$f":"IF($O13=\"\",0,'General Inputs'!M$19)","v":0},{"$f":"IF($O13=\"\",0,'General Inputs'!N$19)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF($O13=\"\",0,'General Inputs'!U$19)","v":0},{"$f":"IF($O13=\"\",0,'General Inputs'!V$19)","v":0},{"$f":"IF($O13=\"\",0,'General Inputs'!W$19)","v":0},{"$f":"IF($O13=\"\",0,'General Inputs'!X$19)","v":0}]
[]
[null,"End"]

{"sheet":"Lookup Tables","index":3,"n_rows":63,"n_cols":12,"rows_kept":63,"cut":false,"hidden":false,"merged":[[60,6,60,7],[59,6,59,7]]}
[null,{"$f":"'Pricing model - ACS'!G2&\" - \"&'Pricing model - ACS'!G3","v":"Ergon Energy Pricing Model - Price Capped Security Lighting Services - 2025-30"},null,null,null,null,"Back to Index"]
[null,{"$f":"'Pricing model - ACS'!#REF!&\" - \"&'Pricing model - ACS'!#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[null,"Unit Denominations"]
[]
[null,null,{"$f":"B6","v":"Unit Denominations"},null,null,null,"Ref"]
[null,null,"Cents",null,null,null,"cents"]
[null,null,"Dollars",null,null,null,"$dollars"]
[]
[null,null,"Percent",null,null,null,"Per cent"]
[null,null,"Unit",null,null,null,"unit"]
[null,null,"Number",null,null,null,"number"]
[null,null,"Factor",null,null,null,"factor"]
[]
[]
[null,null,"Actual",null,null,null,"Actual"]
[null,null,"Estimate",null,null,null,"Estimate"]
[]
[null,"Years"]
[]
[null,null,{"$f":"B21","v":"Years"},null,null,null,"Calendar Year","Year Ending","Financial Year",null,"Yr/end Vic","Reg yr Vic"]
[null,null,"2020-06-01",null,null,null,2020,{"$f":"DATE(G24,MONTH(yearending),1)","v":"2020-06-01"},{"$f":"G24-1&\"–\"&RIGHT(G24,2)","v":"2019–20"},null,{"$f":"DATE(G24,MONTH(#REF!),1)","v":{"$error":"#REF!"}},{"$f":"G24","v":2020}]
[null,null,"2021-06-01",null,null,null,2021,"2021-06-01","2020–21",null,{"$f":"H25","v":"2021-06-01"},"HY21"]
[null,null,"2022-06-01",null,null,null,2022,"2022-06-01","2021–22",null,{"$f":"H26","v":"2022-06-01"},{"$f":"I26","v":"2021–22"}]
[null,null,"2023-06-01",null,null,null,2023,"2023-06-01","2022–23",null,"2023-06-01","2022–23"]
[null,null,"2024-06-01",null,null,null,2024,"2024-06-01","2023–24",null,"2024-06-01","2023–24"]
[null,null,"2025-06-01",null,null,null,2025,"2025-06-01","2024–25",null,"2025-06-01","2024–25"]
[null,null,"2026-06-01",null,null,null,2026,"2026-06-01","2025–26",null,"2026-06-01","2025–26"]
[null,null,"2027-06-01",null,null,null,2027,"2027-06-01","2026–27",null,"2027-06-01","2026–27"]
[null,null,"2028-06-01",null,null,null,2028,"2028-06-01","2027–28",null,"2028-06-01","2027–28"]
[null,null,"2029-06-01",null,null,null,2029,"2029-06-01","2028–29",null,"2029-06-01","2028–29"]
[null,null,"2030-06-01",null,null,null,2030,"2030-06-01","2029–30",null,"2030-06-01","2029–30"]
[null,null,"2031-06-01",null,null,null,2031,"2031-06-01","2030–31",null,"2031-06-01","2030–31"]
[null,null,"2032-06-01",null,null,null,2032,"2032-06-01","2031–32",null,"2032-06-01","2031–32"]
[null,null,"2033-06-01",null,null,null,2033,"2033-06-01","2032–33",null,"2033-06-01","2032–33"]
[null,null,"2034-06-01",null,null,null,2034,"2034-06-01","2033–34",null,"2034-06-01","2033–34"]
[null,null,"2035-06-01",null,null,null,2035,"2035-06-01","2034–35",null,"2035-06-01","2034–35"]
[null,null,"2036-06-01",null,null,null,2036,"2036-06-01","2035–36",null,"2036-06-01","2035–36"]
[null,null,"2037-06-01",null,null,null,2037,"2037-06-01","2036–37",null,"2037-06-01","2036–37"]
[null,null,"2038-06-01",null,null,null,2038,"2038-06-01","2037–38",null,"2038-06-01","2037–38"]
[null,null,"2039-06-01",null,null,null,2039,"2039-06-01","2038–39",null,"2039-06-01","2038–39"]
[null,null,"2040-06-01",null,null,null,2040,"2040-06-01",{"$f":"G44-1&\"–\"&RIGHT(G44,2)","v":"2039–40"},null,{"$f":"H44","v":"2040-06-01"},"2039–40"]
[null,null,"2041-06-01",null,null,null,2041,"2041-06-01",{"$f":"G45-1&\"–\"&RIGHT(G45,2)","v":"2040–41"},null,"2041-06-01","2040–41"]
[null,null,"2042-06-01",null,null,null,2042,"2042-06-01",{"$f":"G46-1&\"–\"&RIGHT(G46,2)","v":"2041–42"},null,"2042-06-01","2041–42"]
[null,null,null,null,null,null,null,"nominal"]
[null,"Regulatory years"]
[]
[null,null,{"$f":"B48","v":"Regulatory years"},null,null,null,"Year","Year ending"]
[null,null,"Forecast period year 1",null,null,null,{"$f":"RCP_firstyear","v":"2025–26"},{"$f":"INDEX($H$24:$H$46,MATCH(G51,$I$24:$I$46))","v":"2026-06-01"}]
[null,null,"Forecast period year 2",null,null,null,{"$f":"INDEX('Lookup Tables'!I24:I34,MATCH(RCP_firstyear,'Lookup Tables'!I24:I34)+1)","v":"2026–27"},{"$f":"INDEX($H$24:$H$46,MATCH(G52,$I$24:$I$46))","v":"2027-06-01"}]
[null,null,"Forecast period year 3",null,null,null,{"$f":"INDEX('Lookup Tables'!I24:I34,MATCH(RCP_firstyear,'Lookup Tables'!I24:I34)+2)","v":"2027–28"},{"$f":"INDEX($H$24:$H$46,MATCH(G53,$I$24:$I$46))","v":"2028-06-01"}]
[null,null,"Forecast period year 4",null,null,null,{"$f":"INDEX('Lookup Tables'!I24:I34,MATCH(RCP_firstyear,'Lookup Tables'!I24:I34)+3)","v":"2028–29"},{"$f":"INDEX($H$24:$H$46,MATCH(G54,$I$24:$I$46))","v":"2029-06-01"}]
[null,null,"Forecast period year 5",null,null,null,{"$f":"INDEX('Lookup Tables'!I24:I34,MATCH(RCP_firstyear,'Lookup Tables'!I24:I34)+4)","v":"2029–30"},{"$f":"INDEX($H$24:$H$46,MATCH(G55,$I$24:$I$46))","v":"2030-06-01"}]
[]
[null,"DNSP name"]
[]
[null,null,{"$f":"B57","v":"DNSP name"},"Source"]
[null,null,null,"AER",null,null,"Energex",null,"Qld"]
[null,null,null,"AER",null,null,"Ergon Energy",null,"Qld"]
[]
[null,"End"]

{"sheet":"Model update log","index":4,"n_rows":55,"n_cols":5,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'Pricing model - ACS'!#REF!","v":{"$error":"#REF!"}}]
[null,0]
[]
[null,null,"Changelog (to detail completion of inputs, and any changes to inputs)"]
[]
[null,null,"Version","Cell range","Description"]
[null,null,"v1.0",null,"Version submitted to the AER as part of Ergon Energy's 2025-30 Regulatory Proposal"]
[null,null,"v1.2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"End"]