{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Revised proposal"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Revised proposal","index":0,"n_rows":61,"n_cols":26,"rows_kept":61,"cut":false,"hidden":false,"merged":[[2,2,2,10],[2,11,2,13],[30,2,30,11],[30,13,30,19],[31,2,31,6],[31,7,31,11],[31,13,31,14],[31,15,31,19],[16,2,16,6],[16,7,16,11],[16,13,16,14],[16,15,16,19],[15,2,15,6],[15,7,15,11],[15,13,15,19],[56,13,56,14],[57,13,57,14],[37,21,42,22],[50,15,50,19],[50,20,50,24],[53,13,53,14],[54,13,54,14],[55,13,55,14]]}
[]
[null,"Actual and estimated inflation"]
[null,null,"Actual",null,null,null,null,null,null,null,null,"Estimated"]
[null,null,"2012-13","2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24"]
[null,"ABS CPI index - June (old base)"]
[null,"ABS CPI index - June (rebased)",null,105.9,107.5,108.6,110.7,113,114.8,114.4,118.8,126.1,133.69999999999999,138.51319999999998]
[null,"Inflation rate (per cent) ",null,null,{"$f":"+E6/D6-1","v":1.5108593012275628E-2},{"$f":"+F6/E6-1","v":1.0232558139534831E-2},{"$f":"+G6/F6-1","v":1.9337016574585641E-2},2.0776874435411097E-2,1.5929203539823078E-2,-3.4843205574912606E-3,3.8461538461538325E-2,6.1447811447811418E-2,6.0269627279936566E-2,3.6000000000000032E-2]
[null,"Reconstructed cumulative index (2023-24=1)",null,{"$f":"E8/(1+E7)","v":0.76454807195270913},{"$f":"F8/(1+F7)","v":0.7760993176101626},0.78404079899966195,0.79920180892506976,0.81580672455765935,0.82880187592229471,0.82591406450793137,0.85767999006592865,0.91038254837806065,0.96525096525096521,1]
[]
[]
[]
[null,"7.5.1 -  The carryover amounts that arise from applying the EBSS during the current regulatory control period"]
[]
[null,"Base year for the previous period (drop down menu)","2017-18"]
[null,"7.5.1.1 - Opex allowance applicable to EBSS (EBSS target)"]
[null,null,"$m, real June 2014",null,null,null,null,"$m, real June 2019",null,null,null,null,null,"$m, real June 2024"]
[null,null,"Previous period",null,null,null,null,"Current regulatory control period",null,null,null,null,null,"Previous period",null,"Current regulatory control period"]
[null,null,{"$f":"E4","v":"2014-15"},"2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23",{"$f":"N4","v":"2023-24"},null,{"$f":"dms_PRCP_BaseYear","v":"2017-18"},{"$f":"G18","v":"2018-19"},{"$f":"H18","v":"2019-20"},"2020-21","2021-22","2022-23","2023-24"]
[null,"Total opex allowance",null,null,null,330.21881004366264,333.93405830722998,386.62105415896849,368.66351388854468,357.43033025819386,338.94776268037208,307.07656864482209,null,{"$f":"+LOOKUP(dms_PRCP_BaseYear,C$18:G$18,C19:G19)/$D$8","v":431.91373068309593},{"$f":"+G19/$D$8","v":436.77313508140708},{"$f":"+H19/$I$8","v":466.4818762973174},{"$f":"+I19/$I$8","v":444.81500898908337},{"$f":"+J19/$I$8","v":431.26148798884373},{"$f":"+K19/$I$8","v":408.96114322037386},{"$f":"+L19/$I$8","v":370.50660425099278}]
[null,"Approved excludable costs - allowance "]
[null,"Debt raising costs",null,null,null,-3.8305694267686392,-3.9197986142542698,-3.9926105620233887,-4.1004788877014615,-4.1491769318263225,-4.1860621292065741,-4.20513373891011,null,{"$f":"+LOOKUP(dms_PRCP_BaseYear,C$18:G$18,C21:G21)/$D$8","v":-5.0102401239271952},-5.1269485308397034,{"$f":"H21/$I$8","v":-4.8173280949447568},{"$f":"I21/$I$8","v":-4.9474778072122829},-5.0062349668418626,-5.0507392065785375,-5.0737502665888838]
[null,"Self insurance",null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"H22/$I$8","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0]
[null,"Demand management innovation allowance",null,null,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0]
[null,"Approved pass throughs",null,null,null,null,null,0,0,0,0,0,null,{"$f":"+LOOKUP(dms_PRCP_BaseYear,C$18:G$18,C27:G27)/$D$8","v":0},0,0,0,0,0,0]
[null,"Forecast opex for EBSS purposes",{"$f":"SUM(C19:C26)","v":0},0,0,{"$f":"SUM(F19:F27)","v":326.388240616894},{"$f":"SUM(G19:G27)","v":330.01425969297571},382.62844359694509,364.56303500084323,353.28115332636753,334.76170055116552,302.871434905912,null,{"$f":"+SUM(N19:N27)","v":426.90349055916874},{"$f":"+SUM(O19:O27)","v":431.64618655056739},461.66454820237266,439.86753118187107,426.25525302200185,403.9104040137953,365.43285398440389]
[]
[null,"7.5.1.2 - Actual and estimated opex applicable to EBSS"]
[null,null,"$m, Actual ",null,null,null,null,null,null,null,null,null,null,"$m, real June 2024"]
[null,null,"Previous period",null,null,null,null,"Current regulatory control period",null,null,null,null,null,"Previous period",null,"Current regulatory control period"]
[null,null,{"$f":"C18","v":"2014-15"},{"$f":"D18","v":"2015-16"},"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24",null,{"$f":"dms_PRCP_BaseYear","v":"2017-18"},{"$f":"O18","v":"2018-19"},{"$f":"P18","v":"2019-20"},"2020-21","2021-22","2022-23","2023-24"]
[null,"Total opex ",null,null,null,345.390715,401.766886,394.65359000000001,385.62245291999938,360.87169299999999,401.69005572409037,null,null,{"$f":"+LOOKUP(dms_PRCP_BaseYear,C$33:G$33,C34:G34)/LOOKUP(dms_PRCP_BaseYear,C$4:N$4,C$8:N$8)*(1+LOOKUP(dms_PRCP_BaseYear,C$4:N$4,C$7:N$7))^0.5","v":427.74878922735888},{"$f":"G34/I$8*(1+I$7)^0.5","v":488.60188241860914},{"$f":"+H34/J$8*(1+J$7)^0.5","v":477.00536552758359},{"$f":"+I34/K$8*(1+K$7)^0.5","v":458.17590140167761},{"$f":"+J34/L$8*(1+L$7)^0.5","v":408.39293098724283},{"$f":"+K34/M$8*(1+M$7)^0.5","v":428.50806099545139}]
[null,"Approved excludable costs"]
[null,{"$f":"B21","v":"Debt raising costs"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+LOOKUP(dms_PRCP_BaseYear,C$33:G$33,C36:G36)/LOOKUP(dms_PRCP_BaseYear,C$4:N$4,C$8:N$8)*(1+LOOKUP(dms_PRCP_BaseYear,C$4:N$4,C$7:N$7))^0.5","v":0},{"$f":"G36/I$8*(1+I$7)^0.5","v":0},{"$f":"H36/J$8*(1+J$7)^0.5","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,null,"Business to nominate base year used to forecast opex \n(drop down menu)"]
[null,"DMIA",null,null,null,-0.64022662889518411,-0.65042492917847017,0,0,-0.25,-2.4669535099999997,null,null,-0.792888035050475,-0.79100308124595198,{"$f":"H39/J$8*(1+J$7)^0.5","v":0},0,-0.28292114545767577,-2.6316545557257252]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,"Movements in provisions",null,null,null,18.768025999999999,-27.7634560477,-12.072732999999999,-1.733862,7.2076130000000003,3.509169,null,null,23.243243228723131,-33.764049153997576,-14.591932174193374,-2.06008176842577,8.156744503902539,3.7434514060467592]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"Actual opex for EBSS purposes",{"$f":"SUM(C34:C42)","v":0},0,0,363.51851437110486,373.35300502312151,382.58085700000004,383.88859091999939,367.82930599999997,402.73227121409036,null,null,{"$f":"N34+SUM(N36:N42)","v":450.19914442103152},454.04683018336561,462.41343335339025,456.11581963325182,416.26675434568767,429.6198578457724,{"$f":"(T28-(LOOKUP(U43,P18:T18,P28:T28)-LOOKUP(U43,P33:T33,P43:T43)))+U44","v":431.17803819873058},"2022-23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40.035730382349563,"Base year non-recurrent efficiency gain ($m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Incremental gain $m, real June 2024"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(P28-P43)-(O28-O43)+IF(N18=O18,O28-O43,N28-N43)","v":-1.6438953800821423},{"$f":"(Q28-Q43)-(P28-P43)","v":-15.499403300363156},{"$f":"(R28-R43)-(Q28-Q43)","v":26.236787127694924},{"$f":"(S28-S43)-(R28-R43)","v":-35.69795250829128},{"$f":"(T28-T43)-(S28-S43)","v":-40.035730382349584}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Carryover"]
[null,null,null,null,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,null,null,null,null," $m, real June 2020"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P33","v":"2019-20"},{"$f":"Q33","v":"2020-21"},"2021-22","2022-23","2023-24","2024-25","2025-26","2026-27","2027-28","2028-29","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-20",null,null,{"$f":"$P$48","v":-1.6438953800821423},{"$f":"$P$48","v":-1.6438953800821423},{"$f":"$P$48","v":-1.6438953800821423},{"$f":"$P$48","v":-1.6438953800821423},{"$f":"$P$48","v":-1.6438953800821423}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-21",null,null,null,{"$f":"$Q$48","v":-15.499403300363156},{"$f":"$Q$48","v":-15.499403300363156},{"$f":"$Q$48","v":-15.499403300363156},{"$f":"$Q$48","v":-15.499403300363156},{"$f":"$Q$48","v":-15.499403300363156}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-22",null,null,null,null,{"$f":"$R$48","v":26.236787127694924},{"$f":"$R$48","v":26.236787127694924},{"$f":"$R$48","v":26.236787127694924},{"$f":"$R$48","v":26.236787127694924},{"$f":"$R$48","v":26.236787127694924}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-23",null,null,null,null,null,{"$f":"$S$48","v":-35.69795250829128},{"$f":"$S$48","v":-35.69795250829128},{"$f":"$S$48","v":-35.69795250829128},{"$f":"$S$48","v":-35.69795250829128},{"$f":"$S$48","v":-35.69795250829128}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-24",null,null,null,null,null,null,{"$f":"+$T$48","v":-40.035730382349584},{"$f":"+$T$48","v":-40.035730382349584},{"$f":"+$T$48","v":-40.035730382349584},{"$f":"+$T$48","v":-40.035730382349584},{"$f":"+$T$48","v":-40.035730382349584}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Carryover Amount ($m, June 2024)",null,null,null,null,null,null,{"$f":"+SUM(U54:U58)","v":-66.640194443391238},{"$f":"+SUM(V55:V58)","v":-64.996299063309095},{"$f":"+SUM(W56:W58)","v":-49.49689576294594},{"$f":"+SUM(X57:X58)","v":-75.733682890640864},{"$f":"+SUM(Y58)","v":-40.035730382349584},{"$f":"+SUM(U59:Y59)","v":-296.90280254263672}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PTRM inputs ($m, June 2024)",null,null,null,null,null,null,{"$f":"U59","v":-66.640194443391238},{"$f":"V59","v":-64.996299063309095},{"$f":"W59","v":-49.49689576294594},{"$f":"X59","v":-75.733682890640864},{"$f":"Y59","v":-40.035730382349584},{"$f":"+SUM(U61:Y61)","v":-296.90280254263672}]