{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Draft decision"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"Draft decision","index":0,"n_rows":55,"n_cols":22,"rows_kept":55,"cut":false,"hidden":false,"merged":[[34,17,38,18],[44,11,44,15],[44,16,44,20],[47,9,47,10],[48,9,48,10],[51,9,51,10],[14,1,14,2],[14,3,14,7],[14,9,14,15],[15,1,15,2],[15,3,15,7],[15,9,15,10],[15,11,15,15],[49,9,49,10],[27,1,27,7],[27,9,27,15],[28,1,28,2],[28,3,28,7],[28,9,28,10],[28,11,28,15],[50,9,50,10]]}
["Actual and estimated inflation"]
[null,"Actual",null,null,null,null,null,null,null,null,null,"Estimated"]
[null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25"]
["ABS CPI index - June",null,107.5,108.6,110.7,113,114.8,114.4,118.8,126.1,133.69999999999999,138.80000000000001,142.68640000000002]
["Inflation rate (per cent) ",null,null,{"$f":"+D4/C4-1","v":1.0232558139534831E-2},1.9337016574585641E-2,2.0776874435411097E-2,1.5929203539823078E-2,-3.4843205574912606E-3,3.8461538461538325E-2,6.1447811447811418E-2,6.0269627279936566E-2,{"$f":"+L4/K4-1","v":3.8145100972326373E-2},2.8000000000000025E-2]
["Reconstructed cumulative index (2024-25=1)",null,{"$f":"D6/(1+D5)","v":0.75340046423485318},0.76110967828748888,0.77582726875161157,0.79194653449803176,0.80456161203870846,0.80175826147411366,0.83259511768465644,0.88375626548851161,0.93701992621581287,0.97276264591439687,1]
[]
[]
[]
["7.5.1 -  The carryover amounts that arise from applying the EBSS during the current regulatory control period"]
[]
["Base year used to forecast opex for the current period (drop down menu)","2018-19"]
["Non-recurrent efficiency adjustment made to 2018-19 opex, $m, real June 2020",0]
["7.5.1.1 - Opex allowance applicable to EBSS (EBSS target)"]
[null,"$m, real June 2015",null,"$m, real June 2020",null,null,null,null,null,"$m, real June 2025"]
[null,"Previous period",null,"Current regulatory control period",null,null,null,null,null,"Previous period",null,"Current regulatory control period"]
[null,{"$f":"dms_PRCP_BaseYear","v":"2018-19"},"2019-20","2020-21","2021-22","2022-23","2023-24","2024-25",null,{"$f":"dms_PRCP_BaseYear","v":"2018-19"},"2019-20","2020-21","2021-22","2022-23","2023-24","2024-25"]
["Total opex allowance",358.06033976544927,364.79580390314737,376.82956599545906,371.57488468656942,367.00423393846972,362.05577225241262,357.16838526561975,null,{"$f":"+B18/$C$6","v":475.25898478054717},{"$f":"+C18/$C$6","v":484.19906971205643},{"$f":"+D18/$H$6","v":470.00397015257414},{"$f":"+E18/$H$6","v":463.45002295753261},{"$f":"+F18/$H$6","v":457.74923885872448},{"$f":"+G18/$H$6","v":451.57722676500578},{"$f":"+H18/$H$6","v":445.48139062381415}]
["Approved excludable costs - allowance "]
["Debt raising costs",-5.2217799931962796,-5.2867297344913906,-5.6191699933410906,-5.6640097385034096,-5.7054343063697095,-5.7500601094115797,-5.7825189821237597,null,{"$f":"+B20/$C$6","v":-6.9309487332204833},-7.0171575217444904,{"$f":"D20/$H$6","v":-7.0085588928134994},{"$f":"E20/$H$6","v":-7.0644856569230168},-7.1161528112971251,-7.1718127342267888,-7.2122973469484597]
[null,null,null,null,null,null,null,null,null,0,0,{"$f":"D21/$H$6","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"+B22/$C$6","v":0},0,0,0,0,0,0]
["Approved opex, pass throughs and contingent projects",null,null,null,null,null,null,null,null,{"$f":"+B23/$C$6","v":0},0,0,0,0,0,0]
["Other adjustments or exclusions required by the EBSS ",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0]
["Forecast opex for EBSS purposes",{"$f":"SUM(B18:B24)","v":352.83855977225301},{"$f":"SUM(C18:C24)","v":359.50907416865596},{"$f":"SUM(D18:D24)","v":371.21039600211799},365.91087494806601,361.29879963210004,356.30571214300102,{"$f":"SUM(H18:H24)","v":351.385866283496},null,{"$f":"+SUM(J18:J24)","v":468.32803604732669},477.18191219031195,462.99541125976066,456.3855373006096,450.63308604742735,444.40541403077901,438.2690932768657]
[]
["7.5.1.2 - Actual and estimated opex applicable to EBSS"]
[null,"$m, Actual ",null,null,null,null,null,null,null,"$m, real June 2025"]
[null,"Previous period",null,"Current regulatory control period",null,null,null,null,null,"Previous period",null,"Current regulatory control period"]
[null,{"$f":"dms_PRCP_BaseYear","v":"2018-19"},"2019-20","2020-21","2021-22","2022-23","2023-24","2024-25",null,{"$f":"dms_PRCP_BaseYear","v":"2018-19"},"2019-20","2020-21","2021-22","2022-23","2023-24","2024-25"]
["Total opex ",391.68503199999998,402.90900099999999,370.17271499999998,380.35368299999999,446.406003,473.85760277456399,null,null,{"$f":"+B31/LOOKUP(dms_PRCP_BaseYear,$C$3:$M$3,$C$6:$M$6)*(1+LOOKUP(dms_PRCP_BaseYear,$C$3:$M$3,$C$5:$M$5))^0.5","v":490.69246670115598},{"$f":"+C31/H$6*(1+H$5)^0.5","v":501.65551858035946},{"$f":"+D31/I$6*(1+I$5)^0.5","v":453.07046541939997},{"$f":"+E31/J$6*(1+J$5)^0.5","v":443.40893795073498},{"$f":"+F31/K$6*(1+K$5)^0.5","v":490.55686750977179},{"$f":"+G31/L$6*(1+L$5)^0.5","v":496.32939517881402}]
["Approved excludable costs"]
[{"$f":"IF(ISBLANK(A20),\"\",A20)","v":"Debt raising costs"},0,0,-2.147767,-2.2215060000000002,-6.9824539999999997,-5.7500601094115762,null,null,{"$f":"+B33/LOOKUP(dms_PRCP_BaseYear,$C$3:$M$3,$C$6:$M$6)*(1+LOOKUP(dms_PRCP_BaseYear,$C$3:$M$3,$C$5:$M$5))^0.5","v":0},{"$f":"C33/H$6*(1+H$5)^0.5","v":0},{"$f":"D33/I$6*(1+I$5)^0.5","v":-2.6287453258202147},{"$f":"E33/J$6*(1+J$5)^0.5","v":-2.5897885576966679},-7.6730392036665238,-6.0227457355027747]
["DMIA ",-0.44147707999999997,-2.6619609999999998,-1.5745920200000001,-0.37887797000000001,-0.33393354999999997,-1.0212631458992281,null,null,{"$f":"+B34/LOOKUP(dms_PRCP_BaseYear,$C$3:$M$3,$C$6:$M$6)*(1+LOOKUP(dms_PRCP_BaseYear,$C$3:$M$3,$C$5:$M$5))^0.5","v":-0.55307060438608635},-3.3143648381677435,{"$f":"D34/I$6*(1+I$5)^0.5","v":-1.927211570272199},{"$f":"E34/J$6*(1+J$5)^0.5","v":-0.44168858039066355},-0.36696055864736593,-1.0696946014048117]
[{"$f":"IF(ISBLANK(A22),\"\",A22)","v":""},null,null,null,null,null,null,null,null,0,0,{"$f":"D35/I$6*(1+I$5)^0.5","v":0},0,0,0,null,null,"Ergon Energy to nominate base year used to forecast opex \n(drop down menu)"]
["Capitalised opex that has been excluded from the regulatory asset base",null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"F36/K$6*(1+K$5)^0.5","v":0},0]
["Movements in provisions related to opex",-3.7236199999999999,-6.9845600000000001,-1.304446,-4.3366540000000002,-6.8587350000000002,null,null,null,-4.6648509225079566,-8.6963633479502125,-1.5965681218143661,-5.055587024248184,-7.5370840312817977,0]
["Other adjustments or exclusions required by the EBSS ",null,null,null,null,null,null,null,null,0,0,0,0,0,0]
["Actual opex for EBSS purposes",{"$f":"SUM(B31:B38)","v":387.51993491999997},{"$f":"SUM(C31:C38)","v":393.26247999999998},365.14590998,373.41664502999998,432.23088044999997,{"$f":"SUM(G31:G38)","v":467.0862795192532},null,null,{"$f":"J31+SUM(J33:J38)","v":485.47454517426195},{"$f":"K31+SUM(K33:K38)","v":489.64479039424151},{"$f":"L31+SUM(L33:L38)","v":446.91794040149318},435.32187378839944,474.97978371617609,489.23695484190642,{"$f":"P25-(LOOKUP($Q$39,L17:O17,L25:O25)-LOOKUP($Q$39,L30:O30,L39:O39))+Q40","v":483.10063408799311},"2023-24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"Base year non-recurrent efficiency gain $m, real June 2025"]
[null,null,null,null,null,null,null,null,null,"Incremental gain $m, real June 2025"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"(L25-L39)-((K25-K39)-(J25-J39))-B13/$H$6","v":11.393839935261781},{"$f":"(M25-M39)-(L25-L39)","v":4.9861926539426804},{"$f":"(N25-N39)-(M25-M39)","v":-45.410361180958887},{"$f":"(O25-O39)-(N25-N39)","v":-20.484843142378679},{"$f":"(P25-P39)-(O25-O39)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Carryover"]
[null,null,null,null,null,null,null,null,null,null,null,"Current regulatory control period",null,null,null,null,"Forthcoming regulatory control period"]
[null,null,null,null,null,null,null,null,null,null,null,"$m, real June 2025"]
[null,null,null,null,null,null,null,null,null,null,null,"2020-21","2021-22","2022-23","2023-24","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30","Total"]
[null,null,null,null,null,null,null,null,null,"2020-21",null,null,{"$f":"$L$42","v":11.393839935261781},{"$f":"$L$42","v":11.393839935261781},{"$f":"$L$42","v":11.393839935261781},{"$f":"$L$42","v":11.393839935261781},{"$f":"$L$42","v":11.393839935261781}]
[null,null,null,null,null,null,null,null,null,"2021-22",null,null,null,{"$f":"$M$42","v":4.9861926539426804},{"$f":"$M$42","v":4.9861926539426804},{"$f":"$M$42","v":4.9861926539426804},{"$f":"$M$42","v":4.9861926539426804},{"$f":"$M$42","v":4.9861926539426804}]
[null,null,null,null,null,null,null,null,null,"2022-23",null,null,null,null,{"$f":"$N$42","v":-45.410361180958887},{"$f":"$N$42","v":-45.410361180958887},{"$f":"$N$42","v":-45.410361180958887},{"$f":"$N$42","v":-45.410361180958887},{"$f":"$N$42","v":-45.410361180958887}]
[null,null,null,null,null,null,null,null,null,"2023-24",null,null,null,null,null,{"$f":"$O$42","v":-20.484843142378679},{"$f":"$O$42","v":-20.484843142378679},{"$f":"$O$42","v":-20.484843142378679},{"$f":"$O$42","v":-20.484843142378679},{"$f":"$O$42","v":-20.484843142378679}]
[null,null,null,null,null,null,null,null,null,"2024-25",null,null,null,null,null,null,{"$f":"+$P$42","v":0},{"$f":"+$P$42","v":0},{"$f":"+$P$42","v":0},{"$f":"+$P$42","v":0},{"$f":"+$P$42","v":0}]
[null,null,null,null,null,null,null,null,null,"Total Carryover Amount ($m, June 2025)",null,null,null,null,null,null,{"$f":"+SUM(Q48:Q52)","v":-49.515171734133105},{"$f":"+SUM(R49:R52)","v":-60.909011669394886},{"$f":"+SUM(S50:S52)","v":-65.895204323337566},{"$f":"+SUM(T51:T52)","v":-20.484843142378679},{"$f":"+SUM(U52)","v":0},{"$f":"+SUM(Q53:U53)","v":-196.80423086924424}]
[]
[null,null,null,null,null,null,null,null,null,"PTRM inputs ($m, June 2025)",null,null,null,null,null,null,{"$f":"Q53","v":-49.515171734133105},{"$f":"R53","v":-60.909011669394886},{"$f":"S53","v":-65.895204323337566},{"$f":"T53","v":-20.484843142378679},{"$f":"U53","v":0},{"$f":"+SUM(Q55:U55)","v":-196.80423086924424}]