{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Total SCS opex forecast ","SCS_Distribution opex forecast","SCS_Transmission opex forecast","Rate of change","ACT labour price forecast"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":19,"defined_names":1078,"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":"Total SCS opex forecast ","index":0,"n_rows":67,"n_cols":21,"rows_kept":67,"cut":false,"hidden":false,"merged":[[3,14,3,18],[1,0,1,4]]}
["Evoenergy Electricity Distribution Deterimation 2019-24 "]
["Opex model"]
["Total Standard Control Services "]
["Forecast",null,null,null,null,null,null,null,null,null,null,null,"Base year","Final year","2019-24 regulatory control period"]
[null,null,null,"Source","Unit","Basis","Timing",null,null,null,null,"FY ending June",{"$f":"2018","v":2018},{"$f":"M5+1","v":2019},2020,2021,2022,2023,2024,null,"Total FY19-24"]
[]
[]
[]
[null,"Calc | Operating expenditure"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Actual/Forecast","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast"]
[null,null,"Opex","Source","Unit","Basis",null,null,null,null,null,null,{"$f":"\"FY\"&RIGHT(M$5,2)","v":"FY18"},{"$f":"\"FY\"&RIGHT(N$5,2)","v":"FY19"},"FY20","FY21","FY22","FY23",{"$f":"\"FY\"&RIGHT(S$5,2)","v":"FY24"}]
[]
[null,null,"Base opex"]
[null,null,"Total opex",null,"$ millions","Nominal","Mid-year",null,null,null,null,null,54.796525398823569]
[null,"Adjustments",null,null,"$ millions","Nominal","Mid-year"]
[null,null,"  Power of Choice (Likely Pass Through)",null,"$ millions","Nominal","Mid-year",null,null,null,null,null,-1.1916317804723604]
[null,null,"  Ring Fencing Implementation (Likely Pass Through)",null,"$ millions","Nominal","Mid-year",null,null,null,null,null,-2.1773647800000004]
[null,null,"Adjusted base opex",null,"$ millions","Nominal","Mid-year",null,null,null,null,null,{"$f":"SUM(M15:M18)","v":51.427528838351208}]
[]
[null,null,"Rate of change"]
[null,null,"Real input price growth","Rate of change","per cent","n/a",null,null,null,null,null,null,null,{"$f":"'Rate of change'!N103","v":4.4072728793116411E-3},{"$f":"'Rate of change'!O103","v":3.4083092931735948E-3},{"$f":"'Rate of change'!P103","v":6.7325264228266235E-3},{"$f":"'Rate of change'!Q103","v":9.4676590811748618E-3},{"$f":"'Rate of change'!R103","v":9.2684971143910388E-3},{"$f":"'Rate of change'!S103","v":7.8726063476963759E-3}]
[null,null,"Output growth","Rate of change","per cent","n/a",null,null,null,null,null,null,null,{"$f":"'Rate of change'!N104","v":1.7027100408945277E-2},{"$f":"'Rate of change'!O104","v":1.5745984926523612E-2},{"$f":"'Rate of change'!P104","v":1.4898341860952409E-2},{"$f":"'Rate of change'!Q104","v":1.4096982531163007E-2},{"$f":"'Rate of change'!R104","v":1.284019201865263E-2},{"$f":"'Rate of change'!S104","v":1.1881868745538928E-2}]
[null,null,"Productivity growth","Rate of change","per cent","n/a",null,null,null,null,null,null,null,{"$f":"'Rate of change'!N105","v":0},{"$f":"'Rate of change'!O105","v":0},{"$f":"'Rate of change'!P105","v":0},{"$f":"'Rate of change'!Q105","v":0},{"$f":"'Rate of change'!R105","v":0},{"$f":"'Rate of change'!S105","v":0}]
[null,null,"Rate of change","Calculated","per cent","n/a",null,null,null,null,null,null,null,{"$f":"N22+N23-N24","v":2.1434373288256918E-2},{"$f":"O22+O23-O24","v":1.9154294219697207E-2},2.1630868283779033E-2,2.3564641612337869E-2,2.2108689133043667E-2,1.9754475093235302E-2]
[]
[]
[null,null,"Base opex - Total SCS","Calculated",null,"Real FY18","Year-end",null,null,null,null,null,{"$f":"SUM(M15:M18)/'Rate of change'!$M$26","v":51.939258147068621},{"$f":"M28*(1+N$25)","v":53.05254359450803},{"$f":"N28*(1+O$25)","v":54.068727623620546},{"$f":"O28*(1+P$25)","v":55.238281149118613},56.539951447679151,57.789975657833274,58.931586292604614,null,{"$f":"SUM(O28:S28)","v":282.56852217085623}]
[null,null,"Base opex - Total SCS","Calculated",null,"Real FY19","Year-end",null,null,null,null,null,{"$f":"M28*(1+'Rate of change'!$N$16)","v":52.978043310009994},{"$f":"N28*(1+'Rate of change'!$N$16)","v":54.11359446639819},{"$f":"O28*(1+'Rate of change'!$N$16)","v":55.150102176092958},{"$f":"P28*(1+'Rate of change'!$N$16)","v":56.343046772100983},{"$f":"Q28*(1+'Rate of change'!$N$16)","v":57.670750476632733},{"$f":"R28*(1+'Rate of change'!$N$16)","v":58.94577517098994},{"$f":"S28*(1+'Rate of change'!$N$16)","v":60.110218018456706},null,{"$f":"SUM(O29:S29)","v":288.21989261427336}]
[]
[]
[]
[null,null,"Step changes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"FY\"&RIGHT(N$5,2)","v":"FY19"},{"$f":"\"FY\"&RIGHT(O$5,2)","v":"FY20"},"FY21","FY22","FY23","FY24"]
[null,null,"Vegetation and private electrical infrastructure responsibilities",null,"$ millions","Real FY18","Year-end",null,null,null,null,null,null,3.6821099823196715,3.6784478286377804,3.6906342528174911,3.7006611209378324,3.6999310025030159,3.6948137323825594,null,{"$f":"SUM(O36:S36)","v":18.46448793727868}]
[null,null,"Strathnairn demand management opex capex trade-off",null,"$ millions","Real FY19","Year-end",null,null,null,null,null,null,0,0.3514121658585706,0.35257636823809685,0.35353426233014174,0.35346451212231911,0.35297564533391101,null,{"$f":"SUM(O37:S37)","v":1.763962953883039}]
[]
[null,null,"Total step changes","Calculated","$ millions","Real FY18","Year-end",null,null,null,null,null,null,{"$f":"SUM(N36:N37)","v":3.6821099823196715},4.0298599944963511,4.0432106210555876,4.0541953832679738,4.0533955146253353,4.0477893777164704,null,{"$f":"SUM(O39:S39)","v":20.228450891161717}]
[null,null,"Total step changes","Calculated","$ millions","Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N39*(1+'Rate of change'!$N$16)","v":3.7557521819660651},{"$f":"O39*(1+'Rate of change'!$N$16)","v":4.110457194386278},{"$f":"P39*(1+'Rate of change'!$N$16)","v":4.1240748334766995},{"$f":"Q39*(1+'Rate of change'!$N$16)","v":4.1352792909333331},{"$f":"R39*(1+'Rate of change'!$N$16)","v":4.1344634249178425},{"$f":"S39*(1+'Rate of change'!$N$16)","v":4.1287451652708},null,{"$f":"SUM(O40:S40)","v":20.633019908984952}]
[]
[null,null,"Total opex","Calculated","$ millions","Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N29+N40","v":57.869346648364257},59.260559370479235,60.467121605577681,61.806029767566066,63.08023859590778,64.238963183727506,null,{"$f":"SUM(O42:S42)","v":308.85291252325828}]
[]
[null,null,"% change",null,null,null,null,null,null,null,null,null,null,{"$f":"N42/M29-1","v":9.2326991197692498E-2},9.5114082788883225E-2,9.6409965162124411E-2,9.6959311014223504E-2,9.3799509709291629E-2,8.9797580867892357E-2]
[]
["Dist PTRM Input =>",null,"Distribution allocation",null,"$ millions","Real FY19","Year-end",null,null,null,null,null,null,{"$f":"'SCS_Distribution opex forecast'!N42","v":49.946323402721234},{"$f":"'SCS_Distribution opex forecast'!O42","v":51.185776206479666},{"$f":"'SCS_Distribution opex forecast'!P42","v":52.21767387053756},{"$f":"'SCS_Distribution opex forecast'!Q42","v":53.362186753150013},{"$f":"'SCS_Distribution opex forecast'!R42","v":54.449713281197774},{"$f":"'SCS_Distribution opex forecast'!S42","v":55.437946371646525},null,{"$f":"SUM(O46:S46)","v":266.65329648301156}]
["Trans PTRM Input =>",null,"Transmission allocation",null,"$ millions","Real FY19","Year-end",null,null,null,null,null,null,{"$f":"'SCS_Transmission opex forecast'!N42","v":7.9230232456430274},{"$f":"'SCS_Transmission opex forecast'!O42","v":8.0747831639995749},{"$f":"'SCS_Transmission opex forecast'!P42","v":8.2494477350401283},{"$f":"'SCS_Transmission opex forecast'!Q42","v":8.4438430144160606},{"$f":"'SCS_Transmission opex forecast'!R42","v":8.6305253147100078},{"$f":"'SCS_Transmission opex forecast'!S42","v":8.8010168120809844},null,42.199616040246752]
[null,null,"check",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N46+N47-N42)","v":7.1054273576010019E-15},{"$f":"SUM(O46+O47-O42)","v":7.1054273576010019E-15},7.1054273576010019E-15,7.1054273576010019E-15,0,0]
[]
[null,null,"Total opex","Calculated","$ millions","Nominal",null,null,null,null,null,null,null,{"$f":"N42*'Rate of change'!N28","v":57.299191397543311},{"$f":"O42*'Rate of change'!O28","v":58.533408404232517},{"$f":"P42*'Rate of change'!P28","v":61.218294774889891},{"$f":"Q42*'Rate of change'!Q28","v":64.138181873505076},{"$f":"R42*'Rate of change'!R28","v":67.096982716350709},{"$f":"S42*'Rate of change'!S28","v":70.037728389360183},null,{"$f":"SUM(O50:S50)","v":321.0245961583384}]
[]
[null,null,"$Real June 2018",null,null,null,null,null,null,null,null,null,{"$f":"\"FY\"&RIGHT(M$5,2)","v":"FY18"},"FY19","FY20","FY21","FY22","FY23","FY24"]
[null,null,"Base opex ","Calculated","$ millions","Real FY18","Year-end",null,null,null,null,null,{"$f":"M28","v":51.939258147068621},{"$f":"$M$28","v":51.939258147068621},{"$f":"$M$28","v":51.939258147068621},{"$f":"$M$28","v":51.939258147068621},51.939258147068621,51.939258147068621,51.939258147068621,null,{"$f":"SUM(O53:S53)","v":259.6962907353431}]
[null,null,"Real price growth","Calculated","$ millions","Real FY18","Year-end",null,null,null,null,null,0,{"$f":"N53*N22","v":0.22891048380314175},{"$f":"'Rate of change'!O128","v":0.4079837999356889},{"$f":"'Rate of change'!P128","v":0.76478708784507565},{"$f":"'Rate of change'!Q128","v":1.2745411249073224},{"$f":"'Rate of change'!R128","v":1.7838614280503722},{"$f":"'Rate of change'!S128","v":2.2252767543521146},null,{"$f":"SUM(O54:S54)","v":6.4564501950905733}]
[null,null,"Output growth","Calculated","$ millions","Real FY18","Year-end",null,null,null,null,null,0,{"$f":"'Rate of change'!N129","v":0.88437496363626877},{"$f":"'Rate of change'!O129","v":1.7214856766162365},{"$f":"'Rate of change'!P129","v":2.5342359142049165},{"$f":"'Rate of change'!Q129","v":3.3261521757032075},{"$f":"'Rate of change'!R129","v":4.0668560827142812},{"$f":"'Rate of change'!S129","v":4.7670513911838777},null,16.415781240422518]
[null,null,"Productivity growth","Calculated","$ millions","Real FY18","Year-end",null,null,null,null,null,0,{"$f":"'Rate of change'!N130","v":0},{"$f":"'Rate of change'!O130","v":0},{"$f":"'Rate of change'!P130","v":0},{"$f":"'Rate of change'!Q130","v":0},{"$f":"'Rate of change'!R130","v":0},{"$f":"'Rate of change'!S130","v":0},null,0]
[null,null,"Step changes","Calculated","$ millions","Real FY18","Year-end",null,null,null,null,null,0,{"$f":"N39","v":3.6821099823196715},4.0298599944963511,4.0432106210555876,4.0541953832679738,4.0533955146253353,4.0477893777164704,null,20.228450891161717]
[null,null,"Total SCS opex","Calculated","$ millions","Real FY18","Year-end",null,null,null,null,null,{"$f":"SUM(M53:M57)","v":51.939258147068621},{"$f":"SUM(N53:N57)","v":56.734653576827704},58.098587618116895,59.281491770174199,60.594146830947125,61.84337117245861,62.979375670321083,null,{"$f":"SUM(O58:S58)","v":302.79697306201791}]
[null,null,"Total SCS opex","Calculated","$ millions","Real FY19","Year-end",null,null,null,null,null,{"$f":"M58*(1+'Rate of change'!$N$16)","v":52.978043310009994},{"$f":"N58*(1+'Rate of change'!$N$16)","v":57.869346648364257},{"$f":"O58*(1+'Rate of change'!$N$16)","v":59.260559370479235},{"$f":"P58*(1+'Rate of change'!$N$16)","v":60.467121605577681},{"$f":"Q58*(1+'Rate of change'!$N$16)","v":61.806029767566066},{"$f":"R58*(1+'Rate of change'!$N$16)","v":63.080238595907787},{"$f":"S58*(1+'Rate of change'!$N$16)","v":64.238963183727506},null,{"$f":"SUM(O59:S59)","v":308.85291252325828}]
[]
[null,null,"$Real June 2019",null,null,null,null,null,null,null,null,null,null,"FY16","FY17","FY18","FY19","FY20","FY21"]
[null,null,"Base opex ","Calculated","$ millions","Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N53*(1+'Rate of change'!$N$16)","v":52.978043310009994},{"$f":"O53*(1+'Rate of change'!$N$16)","v":52.978043310009994},{"$f":"P53*(1+'Rate of change'!$N$16)","v":52.978043310009994},{"$f":"Q53*(1+'Rate of change'!$N$16)","v":52.978043310009994},{"$f":"R53*(1+'Rate of change'!$N$16)","v":52.978043310009994},{"$f":"S53*(1+'Rate of change'!$N$16)","v":52.978043310009994},null,{"$f":"SUM(O62:S62)","v":264.89021655004996}]
[null,null,"Real price growth","Calculated","$ millions","Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N54*(1+'Rate of change'!$N$16)","v":0.23348869347920459},{"$f":"O54*(1+'Rate of change'!$N$16)","v":0.41614347593440271},{"$f":"P54*(1+'Rate of change'!$N$16)","v":0.78008282960197717},{"$f":"Q54*(1+'Rate of change'!$N$16)","v":1.3000319474054689},{"$f":"R54*(1+'Rate of change'!$N$16)","v":1.8195386566113796},{"$f":"S54*(1+'Rate of change'!$N$16)","v":2.2697822894391568},null,6.5855791989923844]
[null,null,"Output growth","Calculated","$ millions","Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N55*(1+'Rate of change'!$N$16)","v":0.90206246290899417},{"$f":"O55*(1+'Rate of change'!$N$16)","v":1.7559153901485614},{"$f":"P55*(1+'Rate of change'!$N$16)","v":2.5849206324890148},{"$f":"Q55*(1+'Rate of change'!$N$16)","v":3.3926752192172716},{"$f":"R55*(1+'Rate of change'!$N$16)","v":4.1481932043685665},{"$f":"S55*(1+'Rate of change'!$N$16)","v":4.8623924190075556},null,16.744096865230972]
[null,null,"Productivity growth","Calculated","$ millions","Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N56*(1+'Rate of change'!$N$16)","v":0},{"$f":"O56*(1+'Rate of change'!$N$16)","v":0},{"$f":"P56*(1+'Rate of change'!$N$16)","v":0},{"$f":"Q56*(1+'Rate of change'!$N$16)","v":0},{"$f":"R56*(1+'Rate of change'!$N$16)","v":0},{"$f":"S56*(1+'Rate of change'!$N$16)","v":0},null,0]
[null,null,"Step changes","Calculated","$ millions","Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N57*(1+'Rate of change'!$N$16)","v":3.7557521819660651},{"$f":"O57*(1+'Rate of change'!$N$16)","v":4.110457194386278},{"$f":"P57*(1+'Rate of change'!$N$16)","v":4.1240748334766995},{"$f":"Q57*(1+'Rate of change'!$N$16)","v":4.1352792909333331},{"$f":"R57*(1+'Rate of change'!$N$16)","v":4.1344634249178425},{"$f":"S57*(1+'Rate of change'!$N$16)","v":4.1287451652708},null,20.633019908984952]
[null,null,"Total SCS opex","Calculated","$ millions","Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N58*(1+'Rate of change'!$N$16)","v":57.869346648364257},{"$f":"O58*(1+'Rate of change'!$N$16)","v":59.260559370479235},{"$f":"P58*(1+'Rate of change'!$N$16)","v":60.467121605577681},{"$f":"Q58*(1+'Rate of change'!$N$16)","v":61.806029767566066},{"$f":"R58*(1+'Rate of change'!$N$16)","v":63.080238595907787},{"$f":"S58*(1+'Rate of change'!$N$16)","v":64.238963183727506},null,308.85291252325828]

{"sheet":"SCS_Distribution opex forecast","index":1,"n_rows":63,"n_cols":21,"rows_kept":63,"cut":false,"hidden":false,"merged":[[3,14,3,18],[1,0,1,4]]}
["Evoenergy Electricity Distribution Deterimation 2019-24 "]
["Opex model"]
["Distribution "]
["Forecast",null,null,null,null,null,null,null,null,null,null,null,"Base year","Final year","2019-24 regulatory control period"]
[null,null,null,"Source","Unit","Basis","Timing",null,null,null,null,"FY ending June",{"$f":"2018","v":2018},{"$f":"M5+1","v":2019},2020,2021,2022,2023,2024,null,"Total"]
[]
[]
[]
[null,"Calc | Operating expenditure"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Actual/Forecast","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast"]
[null,null,"Opex","Source","Unit","Basis",null,null,null,null,null,null,{"$f":"\"FY\"&RIGHT(M$5,2)","v":"FY18"},{"$f":"\"FY\"&RIGHT(N$5,2)","v":"FY19"},"FY20","FY21","FY22","FY23","FY24"]
[]
[null,null,"Base opex"]
[null,null,"Total opex",null,"$ millions","Nominal","Mid-year",null,null,null,null,null,47.266781524477047]
[null,"Adjustments",null,null,"$ millions","Nominal","Mid-year"]
[null,null,"  Power of Choice (Likely Pass Through)",null,"$ millions","Nominal","Mid-year",null,null,null,null,null,-1.1916317804723604]
[null,null,"  Ring Fencing Implementation (Likely Pass Through)",null,"$ millions","Nominal","Mid-year",null,null,null,null,null,-2.1773647800000004]
[null,null,"Adjusted base opex",null,"$ millions","Nominal","Mid-year",null,null,null,null,null,{"$f":"SUM(M15:M18)","v":43.897784964004686}]
[]
[null,null,"Rate of change"]
[null,null,"Real input price growth","Rate of change","per cent","n/a",null,null,null,null,null,null,null,{"$f":"'Rate of change'!N103","v":4.4072728793116411E-3},{"$f":"'Rate of change'!O103","v":3.4083092931735948E-3},{"$f":"'Rate of change'!P103","v":6.7325264228266235E-3},{"$f":"'Rate of change'!Q103","v":9.4676590811748618E-3},{"$f":"'Rate of change'!R103","v":9.2684971143910388E-3},{"$f":"'Rate of change'!S103","v":7.8726063476963759E-3}]
[null,null,"Output growth","Rate of change","per cent","n/a",null,null,null,null,null,null,null,{"$f":"'Rate of change'!N104","v":1.7027100408945277E-2},{"$f":"'Rate of change'!O104","v":1.5745984926523612E-2},{"$f":"'Rate of change'!P104","v":1.4898341860952409E-2},{"$f":"'Rate of change'!Q104","v":1.4096982531163007E-2},{"$f":"'Rate of change'!R104","v":1.284019201865263E-2},{"$f":"'Rate of change'!S104","v":1.1881868745538928E-2}]
[null,null,"Productivity growth","Rate of change","per cent","n/a",null,null,null,null,null,null,null,{"$f":"'Rate of change'!N105","v":0},{"$f":"'Rate of change'!O105","v":0},{"$f":"'Rate of change'!P105","v":0},{"$f":"'Rate of change'!Q105","v":0},{"$f":"'Rate of change'!R105","v":0},{"$f":"'Rate of change'!S105","v":0}]
[null,null,"Rate of change","Calculated","per cent","n/a",null,null,null,null,null,null,null,{"$f":"N22+N23-N24","v":2.1434373288256918E-2},{"$f":"O22+O23-O24","v":1.9154294219697207E-2},2.1630868283779033E-2,2.3564641612337869E-2,2.2108689133043667E-2,1.9754475093235302E-2]
[]
[]
[null,null,"Base opex - Distribution","Calculated",null,"Real FY18","Year-end",null,null,null,null,null,{"$f":"SUM(M15:M18)/'Rate of change'!$M$26","v":44.334589602712192},{"$f":"M28*(1+N$25)","v":45.284873745838397},{"$f":"N28*(1+O$25)","v":46.152273541268023},{"$f":"O28*(1+P$25)","v":47.150587291236135},48.26167398256537,49.328676329686211,50.303138437623261,null,{"$f":"SUM(O28:S28)","v":241.19634958237899}]
[null,null,"Base opex - Distribution","Calculated",null,"Real FY19","Year-end",null,null,null,null,null,{"$f":"M28*(1+'Rate of change'!$N$16)","v":45.221281394766436},{"$f":"N28*(1+'Rate of change'!$N$16)","v":46.190571220755167},{"$f":"O28*(1+'Rate of change'!$N$16)","v":47.075319012093388},{"$f":"P28*(1+'Rate of change'!$N$16)","v":48.093599037060862},{"$f":"Q28*(1+'Rate of change'!$N$16)","v":49.22690746221668},{"$f":"R28*(1+'Rate of change'!$N$16)","v":50.315249856279934},{"$f":"S28*(1+'Rate of change'!$N$16)","v":51.309201206375725},null,{"$f":"SUM(O29:S29)","v":246.02027657402658}]
[]
[]
[]
[null,null,"Step changes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"FY15",{"$f":"\"FY\"&RIGHT(N$5,2)","v":"FY19"},{"$f":"\"FY\"&RIGHT(O$5,2)","v":"FY20"},"FY21","FY22","FY23","FY24"]
[null,null,"Vegetation and private electrical infrastructure responsibilities",null,"$ millions","Real FY18","Year-end",null,null,null,null,null,null,3.6821099823196715,3.6784478286377804,3.6906342528174911,3.7006611209378324,3.6999310025030159,3.6948137323825594,null,{"$f":"SUM(O36:S36)","v":18.46448793727868}]
[null,null,"Strathnairn demand management opex capex trade-off",null,"$ millions","Real FY19","Year-end",null,null,null,null,null,null,0,0.3514121658585706,0.35257636823809685,0.35353426233014174,0.35346451212231911,0.35297564533391101,null,{"$f":"SUM(O37:S37)","v":1.763962953883039}]
[]
[null,null,"Total step changes","Calculated","$ millions","Real FY18","Year-end",null,null,null,null,null,null,{"$f":"SUM(N36:N37)","v":3.6821099823196715},4.0298599944963511,4.0432106210555876,4.0541953832679738,4.0533955146253353,4.0477893777164704,null,{"$f":"SUM(O39:S39)","v":20.228450891161717}]
[null,null,"Total step changes","Calculated","$ millions","Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N39*(1+'Rate of change'!$N$16)","v":3.7557521819660651},{"$f":"O39*(1+'Rate of change'!$N$16)","v":4.110457194386278},{"$f":"P39*(1+'Rate of change'!$N$16)","v":4.1240748334766995},{"$f":"Q39*(1+'Rate of change'!$N$16)","v":4.1352792909333331},{"$f":"R39*(1+'Rate of change'!$N$16)","v":4.1344634249178425},{"$f":"S39*(1+'Rate of change'!$N$16)","v":4.1287451652708},null,{"$f":"SUM(O40:S40)","v":20.633019908984952}]
[]
[null,null,"Total Distribution opex","Calculated",null,"Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N29+N40","v":49.946323402721234},51.185776206479666,52.21767387053756,53.362186753150013,54.449713281197774,55.437946371646525,null,{"$f":"SUM(O42:S42)","v":266.65329648301156}]
[]
[null,null,"% change",null,null,null,null,null,null,null,null,null,null,{"$f":"N42/M29-1","v":0.10448713221341044},0.10814339060349099,0.10923675009240252,0.1095486264612715,0.10609656564328707,0.1018120059027634]
[]
[null,null,"Total opex","Calculated",null,"Nominal",null,null,null,null,null,null,null,{"$f":"N42*'Rate of change'!N28","v":49.454229397922795},{"$f":"O42*'Rate of change'!O28","v":50.557706086622325},{"$f":"P42*'Rate of change'!P28","v":52.86636549887902},{"$f":"Q42*'Rate of change'!Q28","v":55.375723889929127},{"$f":"R42*'Rate of change'!R28","v":57.916893662095106},{"$f":"S42*'Rate of change'!S28","v":60.442255572157819},null,{"$f":"SUM(O46:S46)","v":277.1589447096834}]
[]
[null,null,"$Real June 2018",null,null,null,null,null,null,null,null,null,null,{"$f":"\"FY\"&RIGHT(N$5,2)","v":"FY19"},"FY20","FY21","FY22","FY23","FY24"]
[null,null,"Base opex ","Calculated","$ millions","Real FY18","Year-end",null,null,null,null,null,null,{"$f":"$M$28","v":44.334589602712192},{"$f":"$M$28","v":44.334589602712192},{"$f":"$M$28","v":44.334589602712192},44.334589602712192,44.334589602712192,44.334589602712192,null,{"$f":"SUM(O49:S49)","v":221.67294801356095}]
[null,null,"Real price growth","Calculated","$ millions","Real FY18","Year-end",null,null,null,null,null,null,{"$f":"'Rate of change'!N149","v":0.19539463437144633},{"$f":"'Rate of change'!O149","v":0.34824899276549565},{"$f":"'Rate of change'!P149","v":0.65281105049781274},{"$f":"'Rate of change'!Q149","v":1.0879296262673812},{"$f":"'Rate of change'!R149","v":1.522677973119746},{"$f":"'Rate of change'!S149","v":1.8994636268640042},null,{"$f":"SUM(O50:S50)","v":5.5111312695144399}]
[null,null,"Output growth","Calculated","$ millions","Real FY18","Year-end",null,null,null,null,null,null,{"$f":"'Rate of change'!N150","v":0.7548895087547649},{"$f":"'Rate of change'!O150","v":1.4694349457903371},{"$f":"'Rate of change'!P150","v":2.1631866380261338},{"$f":"'Rate of change'!Q150","v":2.8391547535857993},{"$f":"'Rate of change'!R150","v":3.4714087538542837},{"$f":"'Rate of change'!S150","v":4.0690852080470785},null,14.012270299303633]
[null,null,"Productivity growth","Calculated","$ millions","Real FY18","Year-end",null,null,null,null,null,null,{"$f":"'Rate of change'!N151","v":0},{"$f":"'Rate of change'!O151","v":0},{"$f":"'Rate of change'!P151","v":0},{"$f":"'Rate of change'!Q151","v":0},{"$f":"'Rate of change'!R151","v":0},{"$f":"'Rate of change'!S151","v":0},null,0]
[null,null,"Step changes","Calculated","$ millions","Real FY18","Year-end",null,null,null,null,null,null,{"$f":"N39","v":3.6821099823196715},4.0298599944963511,4.0432106210555876,4.0541953832679738,4.0533955146253353,4.0477893777164704,null,20.228450891161717]
[null,null,"Total Distribution opex","Calculated","$ millions","Real FY18","Year-end",null,null,null,null,null,null,{"$f":"SUM(N49:N53)","v":48.966983728158077},50.182133535764379,51.193797912291721,52.31586936583335,53.382071844311561,54.350927815339745,null,{"$f":"SUM(O54:S54)","v":261.42480047354076}]
[null,null,"Total Distribution opex","Calculated","$ millions","Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N54*(1+'Rate of change'!$N$16)","v":49.946323402721241},{"$f":"O54*(1+'Rate of change'!$N$16)","v":51.185776206479666},{"$f":"P54*(1+'Rate of change'!$N$16)","v":52.21767387053756},{"$f":"Q54*(1+'Rate of change'!$N$16)","v":53.36218675315002},{"$f":"R54*(1+'Rate of change'!$N$16)","v":54.449713281197795},{"$f":"S54*(1+'Rate of change'!$N$16)","v":55.437946371646539},null,{"$f":"SUM(O55:S55)","v":266.65329648301156}]
[]
[null,null,"$Real June 2019",null,null,null,null,null,null,null,null,null,null,{"$f":"\"FY\"&RIGHT(N$5,2)","v":"FY19"},"FY20","FY21","FY22","FY23","FY24"]
[null,null,"Base opex ","Calculated","$ millions","Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N49*(1+'Rate of change'!$N$16)","v":45.221281394766436},{"$f":"O49*(1+'Rate of change'!$N$16)","v":45.221281394766436},{"$f":"P49*(1+'Rate of change'!$N$16)","v":45.221281394766436},{"$f":"Q49*(1+'Rate of change'!$N$16)","v":45.221281394766436},{"$f":"R49*(1+'Rate of change'!$N$16)","v":45.221281394766436},{"$f":"S49*(1+'Rate of change'!$N$16)","v":45.221281394766436},null,{"$f":"SUM(O58:S58)","v":226.10640697383218}]
[null,null,"Real price growth","Calculated","$ millions","Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N50*(1+'Rate of change'!$N$16)","v":0.19930252705887527},{"$f":"O50*(1+'Rate of change'!$N$16)","v":0.35521397262080556},{"$f":"P50*(1+'Rate of change'!$N$16)","v":0.66586727150776903},{"$f":"Q50*(1+'Rate of change'!$N$16)","v":1.1096882187927288},{"$f":"R50*(1+'Rate of change'!$N$16)","v":1.5531315325821409},{"$f":"S50*(1+'Rate of change'!$N$16)","v":1.9374528994012843},null,5.621353894904729]
[null,null,"Output growth","Calculated","$ millions","Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N51*(1+'Rate of change'!$N$16)","v":0.76998729892986018},{"$f":"O51*(1+'Rate of change'!$N$16)","v":1.4988236447061438},{"$f":"P51*(1+'Rate of change'!$N$16)","v":2.2064503707866563},{"$f":"Q51*(1+'Rate of change'!$N$16)","v":2.8959378486575154},{"$f":"R51*(1+'Rate of change'!$N$16)","v":3.5408369289313693},{"$f":"S51*(1+'Rate of change'!$N$16)","v":4.15046691220802},null,14.292515705289706]
[null,null,"Productivity growth","Calculated","$ millions","Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N52*(1+'Rate of change'!$N$16)","v":0},{"$f":"O52*(1+'Rate of change'!$N$16)","v":0},{"$f":"P52*(1+'Rate of change'!$N$16)","v":0},{"$f":"Q52*(1+'Rate of change'!$N$16)","v":0},{"$f":"R52*(1+'Rate of change'!$N$16)","v":0},{"$f":"S52*(1+'Rate of change'!$N$16)","v":0},null,0]
[null,null,"Step changes","Calculated","$ millions","Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N53*(1+'Rate of change'!$N$16)","v":3.7557521819660651},{"$f":"O53*(1+'Rate of change'!$N$16)","v":4.110457194386278},{"$f":"P53*(1+'Rate of change'!$N$16)","v":4.1240748334766995},{"$f":"Q53*(1+'Rate of change'!$N$16)","v":4.1352792909333331},{"$f":"R53*(1+'Rate of change'!$N$16)","v":4.1344634249178425},{"$f":"S53*(1+'Rate of change'!$N$16)","v":4.1287451652708},null,20.633019908984952]
[null,null,"Total Distribution opex","Calculated","$ millions","Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N54*(1+'Rate of change'!$N$16)","v":49.946323402721241},{"$f":"O54*(1+'Rate of change'!$N$16)","v":51.185776206479666},{"$f":"P54*(1+'Rate of change'!$N$16)","v":52.21767387053756},{"$f":"Q54*(1+'Rate of change'!$N$16)","v":53.36218675315002},{"$f":"R54*(1+'Rate of change'!$N$16)","v":54.449713281197795},{"$f":"S54*(1+'Rate of change'!$N$16)","v":55.437946371646539},null,266.65329648301156]

{"sheet":"SCS_Transmission opex forecast","index":2,"n_rows":63,"n_cols":21,"rows_kept":63,"cut":false,"hidden":false,"merged":[[3,14,3,18],[1,0,1,4]]}
["Evoenergy Electricity Distribution Deterimation 2019-24 "]
["Opex model"]
["Transmisson"]
["Forecast",null,null,null,null,null,null,null,null,null,null,null,"Base year","Final year","2019-24 regulatory control period"]
[null,null,null,"Source","Unit","Basis","Timing",null,null,null,null,"FY ending June",{"$f":"2018","v":2018},{"$f":"M5+1","v":2019},2020,2021,2022,2023,2024,null,"Total"]
[]
[]
[]
[null,"Calc | Operating expenditure"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Actual","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast"]
[null,null,"Opex","Source","Unit","Basis",null,null,null,null,null,null,{"$f":"\"FY\"&RIGHT(M$5,2)","v":"FY18"},{"$f":"\"FY\"&RIGHT(N$5,2)","v":"FY19"},"FY20","FY21","FY22","FY23","FY24"]
[]
[null,null,"Base opex"]
[null,null,"Total opex",null,"$ millions","Nominal","Mid-year",null,null,null,null,null,7.5297438743465248]
[null,"Adjustments",null,null,"$ millions","Nominal","Mid-year"]
[null,null,"  Power of Choice (Likely Pass Through)",null,"$ millions","Nominal","Mid-year",null,null,null,null,null,0]
[null,null,"  Ring Fencing Implementation (Likely Pass Through)",null,"$ millions","Nominal","Mid-year",null,null,null,null,null,0]
[null,null,"Adjusted base opex",null,"$ millions","Nominal","Mid-year",null,null,null,null,null,{"$f":"SUM(M15:M18)","v":7.5297438743465248}]
[]
[null,null,"Rate of change"]
[null,null,"Real input price growth","Rate of change","per cent","n/a",null,null,null,null,null,null,null,{"$f":"'Rate of change'!N103","v":4.4072728793116411E-3},{"$f":"'Rate of change'!O103","v":3.4083092931735948E-3},{"$f":"'Rate of change'!P103","v":6.7325264228266235E-3},{"$f":"'Rate of change'!Q103","v":9.4676590811748618E-3},{"$f":"'Rate of change'!R103","v":9.2684971143910388E-3},{"$f":"'Rate of change'!S103","v":7.8726063476963759E-3}]
[null,null,"Output growth","Rate of change","per cent","n/a",null,null,null,null,null,null,null,{"$f":"'Rate of change'!N104","v":1.7027100408945277E-2},{"$f":"'Rate of change'!O104","v":1.5745984926523612E-2},{"$f":"'Rate of change'!P104","v":1.4898341860952409E-2},{"$f":"'Rate of change'!Q104","v":1.4096982531163007E-2},{"$f":"'Rate of change'!R104","v":1.284019201865263E-2},{"$f":"'Rate of change'!S104","v":1.1881868745538928E-2}]
[null,null,"Productivity growth","Rate of change","per cent","n/a",null,null,null,null,null,null,null,{"$f":"'Rate of change'!N105","v":0},{"$f":"'Rate of change'!O105","v":0},{"$f":"'Rate of change'!P105","v":0},{"$f":"'Rate of change'!Q105","v":0},{"$f":"'Rate of change'!R105","v":0},{"$f":"'Rate of change'!S105","v":0}]
[null,null,"Rate of change","Calculated","per cent","n/a",null,null,null,null,null,null,null,{"$f":"N22+N23-N24","v":2.1434373288256918E-2},{"$f":"O22+O23-O24","v":1.9154294219697207E-2},2.1630868283779033E-2,2.3564641612337869E-2,2.2108689133043667E-2,1.9754475093235302E-2]
[]
[]
[null,null,"Base opex - Transmission","Calculated",null,"Real FY18","Year-end",null,null,null,null,null,{"$f":"SUM(M15:M18)/'Rate of change'!$M$26","v":7.6046685443564339},{"$f":"M28*(1+N$25)","v":7.7676698486696347},{"$f":"N28*(1+O$25)","v":7.9164540823525238},{"$f":"O28*(1+P$25)","v":8.0876938578824777},8.2782774651137849,8.4612993281470672,8.6284478549813564,null,{"$f":"SUM(O28:S28)","v":41.372172588477213}]
[null,null,"Base opex - Transmission","Calculated",null,"Real FY19","Year-end",null,null,null,null,null,{"$f":"M28*(1+'Rate of change'!$N$16)","v":7.7567619152435627},{"$f":"N28*(1+'Rate of change'!$N$16)","v":7.9230232456430274},{"$f":"O28*(1+'Rate of change'!$N$16)","v":8.0747831639995749},{"$f":"P28*(1+'Rate of change'!$N$16)","v":8.2494477350401283},{"$f":"Q28*(1+'Rate of change'!$N$16)","v":8.4438430144160606},{"$f":"R28*(1+'Rate of change'!$N$16)","v":8.6305253147100078},{"$f":"S28*(1+'Rate of change'!$N$16)","v":8.8010168120809844},null,{"$f":"SUM(O29:S29)","v":42.199616040246752}]
[]
[]
[]
[null,null,"Step changes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"FY15",{"$f":"\"FY\"&RIGHT(N$5,2)","v":"FY19"},{"$f":"\"FY\"&RIGHT(O$5,2)","v":"FY20"},"FY21","FY22","FY23","FY24"]
[null,null,null,null,"$ millions","Real FY18","Year-end",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O36:S36)","v":0}]
[null,null,null,null,"$ millions","Real FY19","Year-end",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O37:S37)","v":0}]
[]
[null,null,"Total step changes","Calculated","$ millions","Real FY18","Year-end",null,null,null,null,null,null,{"$f":"SUM(N36:N37)","v":0},0,0,0,0,0,null,{"$f":"SUM(O39:S39)","v":0}]
[null,null,"Total step changes","Calculated","$ millions","Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N39*(1+'Rate of change'!$N$16)","v":0},{"$f":"O39*(1+'Rate of change'!$N$16)","v":0},{"$f":"P39*(1+'Rate of change'!$N$16)","v":0},{"$f":"Q39*(1+'Rate of change'!$N$16)","v":0},{"$f":"R39*(1+'Rate of change'!$N$16)","v":0},{"$f":"S39*(1+'Rate of change'!$N$16)","v":0},null,{"$f":"SUM(O40:S40)","v":0}]
[]
[null,null,"Total Transmission opex","Calculated","$ millions","Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N29+N40","v":7.9230232456430274},8.0747831639995749,8.2494477350401283,8.4438430144160606,8.6305253147100078,8.8010168120809844,null,{"$f":"SUM(O42:S42)","v":42.199616040246752}]
[]
[null,null,"% change",null,null,null,null,null,null,null,null,null,null,{"$f":"N42/M29-1","v":2.1434373288256925E-2},1.9154294219697388E-2,2.1630868283779359E-2,2.3564641612337844E-2,2.2108689133043757E-2,1.9754475093235468E-2]
[]
[null,null,"Total opex","Calculated",null,"Nominal",null,null,null,null,null,null,null,{"$f":"N42*'Rate of change'!N28","v":7.8449619996205193},{"$f":"O42*'Rate of change'!O28","v":7.9757023176101978},{"$f":"P42*'Rate of change'!P28","v":8.3519292760108819},{"$f":"Q42*'Rate of change'!Q28","v":8.7624579835759597},{"$f":"R42*'Rate of change'!R28","v":9.1800890542555997},{"$f":"S42*'Rate of change'!S28","v":9.5954728172023618},null,{"$f":"SUM(O46:S46)","v":43.865651448655001}]
[]
[null,null,"$Real June 2018",null,null,null,null,null,null,null,null,null,null,{"$f":"\"FY\"&RIGHT(N$5,2)","v":"FY19"},"FY20","FY21","FY22","FY23","FY24"]
[null,null,"Base opex ","Calculated","$ millions","Real FY18","Year-end",null,null,null,null,null,null,{"$f":"$M$28","v":7.6046685443564339},{"$f":"$M$28","v":7.6046685443564339},{"$f":"$M$28","v":7.6046685443564339},7.6046685443564339,7.6046685443564339,7.6046685443564339,null,{"$f":"SUM(O49:S49)","v":38.023342721782171}]
[null,null,"Real price growth","Calculated","$ millions","Real FY18","Year-end",null,null,null,null,null,null,{"$f":"'Rate of change'!N170","v":3.3515849431696054E-2},{"$f":"'Rate of change'!O170","v":5.9734807170190557E-2},{"$f":"'Rate of change'!P170","v":0.11197603734726463},{"$f":"'Rate of change'!Q170","v":0.18661149863994303},{"$f":"'Rate of change'!R170","v":0.26118345493063277},{"$f":"'Rate of change'!S170","v":0.32581312748811686},null,{"$f":"SUM(O50:S50)","v":0.94531892557614783}]
[null,null,"Output growth","Calculated","$ millions","Real FY18","Year-end",null,null,null,null,null,null,{"$f":"'Rate of change'!N171","v":0.12948545488150476},{"$f":"'Rate of change'!O171","v":0.25205073082589829},{"$f":"'Rate of change'!P171","v":0.37104927617877742},{"$f":"'Rate of change'!Q171","v":0.48699742211740621},{"$f":"'Rate of change'!R171","v":0.59544732885999896},{"$f":"'Rate of change'!S171","v":0.69796618313680359},null,2.4035109411188844]
[null,null,"Productivity growth","Calculated","$ millions","Real FY18","Year-end",null,null,null,null,null,null,{"$f":"'Rate of change'!N172","v":0},{"$f":"'Rate of change'!O172","v":0},{"$f":"'Rate of change'!P172","v":0},{"$f":"'Rate of change'!Q172","v":0},{"$f":"'Rate of change'!R172","v":0},{"$f":"'Rate of change'!S172","v":0},null,0]
[null,null,"Step changes","Calculated","$ millions","Real FY18","Year-end",null,null,null,null,null,null,{"$f":"N39","v":0},0,0,0,0,0,null,0]
[null,null,"Total Transmission opex","Calculated","$ millions","Real FY18","Year-end",null,null,null,null,null,null,{"$f":"SUM(N49:N53)","v":7.7676698486696347},7.9164540823525229,8.087693857882476,8.2782774651137832,8.4612993281470654,8.6284478549813546,null,{"$f":"SUM(O54:S54)","v":41.372172588477198}]
[null,null,"Total Transmission opex","Calculated","$ millions","Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N54*(1+'Rate of change'!$N$16)","v":7.9230232456430274},{"$f":"O54*(1+'Rate of change'!$N$16)","v":8.0747831639995731},{"$f":"P54*(1+'Rate of change'!$N$16)","v":8.2494477350401265},{"$f":"Q54*(1+'Rate of change'!$N$16)","v":8.4438430144160588},{"$f":"R54*(1+'Rate of change'!$N$16)","v":8.6305253147100061},{"$f":"S54*(1+'Rate of change'!$N$16)","v":8.8010168120809826},null,{"$f":"SUM(O55:S55)","v":42.199616040246745}]
[]
[null,null,"$Real June 2019",null,null,null,null,null,null,null,null,null,null,{"$f":"\"FY\"&RIGHT(N$5,2)","v":"FY19"},"FY20","FY21","FY22","FY23","FY24"]
[null,null,"Base opex ","Calculated","$ millions","Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N49*(1+'Rate of change'!$N$16)","v":7.7567619152435627},{"$f":"O49*(1+'Rate of change'!$N$16)","v":7.7567619152435627},{"$f":"P49*(1+'Rate of change'!$N$16)","v":7.7567619152435627},{"$f":"Q49*(1+'Rate of change'!$N$16)","v":7.7567619152435627},{"$f":"R49*(1+'Rate of change'!$N$16)","v":7.7567619152435627},{"$f":"S49*(1+'Rate of change'!$N$16)","v":7.7567619152435627},null,{"$f":"SUM(O58:S58)","v":38.783809576217813}]
[null,null,"Real price growth","Calculated","$ millions","Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N50*(1+'Rate of change'!$N$16)","v":3.4186166420329976E-2},{"$f":"O50*(1+'Rate of change'!$N$16)","v":6.0929503313594369E-2},{"$f":"P50*(1+'Rate of change'!$N$16)","v":0.11421555809420993},{"$f":"Q50*(1+'Rate of change'!$N$16)","v":0.1903437286127419},{"$f":"R50*(1+'Rate of change'!$N$16)","v":0.26640712402924543},{"$f":"S50*(1+'Rate of change'!$N$16)","v":0.3323293900378792},null,0.96422530408767082]
[null,null,"Output growth","Calculated","$ millions","Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N51*(1+'Rate of change'!$N$16)","v":0.13207516397913485},{"$f":"O51*(1+'Rate of change'!$N$16)","v":0.25709174544241625},{"$f":"P51*(1+'Rate of change'!$N$16)","v":0.37847026170235298},{"$f":"Q51*(1+'Rate of change'!$N$16)","v":0.49673737055975437},{"$f":"R51*(1+'Rate of change'!$N$16)","v":0.60735627543719894},{"$f":"S51*(1+'Rate of change'!$N$16)","v":0.7119255067995397},null,2.451581159941262]
[null,null,"Productivity growth","Calculated","$ millions","Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N52*(1+'Rate of change'!$N$16)","v":0},{"$f":"O52*(1+'Rate of change'!$N$16)","v":0},{"$f":"P52*(1+'Rate of change'!$N$16)","v":0},{"$f":"Q52*(1+'Rate of change'!$N$16)","v":0},{"$f":"R52*(1+'Rate of change'!$N$16)","v":0},{"$f":"S52*(1+'Rate of change'!$N$16)","v":0},null,0]
[null,null,"Step changes","Calculated","$ millions","Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N53*(1+'Rate of change'!$N$16)","v":0},{"$f":"O53*(1+'Rate of change'!$N$16)","v":0},{"$f":"P53*(1+'Rate of change'!$N$16)","v":0},{"$f":"Q53*(1+'Rate of change'!$N$16)","v":0},{"$f":"R53*(1+'Rate of change'!$N$16)","v":0},{"$f":"S53*(1+'Rate of change'!$N$16)","v":0},null,0]
[null,null,"Total Transmission opex","Calculated","$ millions","Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N54*(1+'Rate of change'!$N$16)","v":7.9230232456430274},{"$f":"O54*(1+'Rate of change'!$N$16)","v":8.0747831639995731},{"$f":"P54*(1+'Rate of change'!$N$16)","v":8.2494477350401265},{"$f":"Q54*(1+'Rate of change'!$N$16)","v":8.4438430144160588},{"$f":"R54*(1+'Rate of change'!$N$16)","v":8.6305253147100061},{"$f":"S54*(1+'Rate of change'!$N$16)","v":8.8010168120809826},null,42.199616040246745]

{"sheet":"Rate of change","index":3,"n_rows":173,"n_cols":20,"rows_kept":173,"cut":false,"hidden":false,"merged":[[0,2,0,4],[1,2,1,4],[13,9,13,12],[13,13,13,18],[2,14,2,18],[2,9,2,13],[3,9,3,11],[3,13,3,18]]}
[null,null,"Evoenergy Electricity Distribution Deterimation 2019-24 "]
[null,null,"Opex model"]
[null,null,"Rate of change ",null,null,null,null,null,null,"2014-19 regulatory period",null,null,null,null,"2019-24 regulatory period"]
[null,null,null,null,null,null,null,null,null,"Historical period",null,null,"Base year","Forecast period"]
[null,null,null,"Source","Unit",null,null,null,"FY ending",2015,{"$f":"J5+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024]
[]
[]
[]
[null,"Input | Inflation"]
[]
[null,null,"Dollar conversion to year-end","Calculated",null,null,null,null,0.5]
[]
[]
[null,null,"Inflation",null,null,null,null,null,null,null,null,null,null,"Forecast"]
[null,null,null,null,null,null,null,null,"FY14",{"$f":"\"FY\"&RIGHT(J$5,2)","v":"FY15"},{"$f":"\"FY\"&RIGHT(K$5,2)","v":"FY16"},"FY17","FY18","FY19","FY20","FY21","FY22","FY23","FY24"]
[null,null,"Inflation Rate","ABS / RBA / AAD","Per cent",null,null,null,2.4498886414253906E-2,2.4879227053140163E-2,1.5083667216591934E-2,1.2769909449732886E-2,0.02,0.02,2.4999999999999911E-2,2.4999999999999911E-2,2.4999999999999911E-2,2.4999999999999911E-2,2.4999999999999911E-2]
[]
[null,null,"Source (actuals): ABS, all groups CPI inflation, weighted average for the eight capital cities - average of four quarters to December on the average of the four quarters to the previous December "]
[null,null,"Source (forecast): Based on the AER's approach of calculating the geometric average based on the inflation forecasts for two years sourced from the latest available Reserve Bank of Australia’s (RBA’s) Statement of monetary policy and the mid-point of the RBA’s target inflation band for eight years."]
[null,null,"CPI indexes (real to nominal)"]
[]
[null,null,"Real 2014","Calculated","factor",null,null,null,{"$f":"1/(1+I$16)^Dollar_Conversion_Factor","v":0.98797113142122694},{"$f":"I22*(1+I$16)^(1-Dollar_Conversion_Factor)*(1+J$16)^Dollar_Conversion_Factor","v":1.0123631893017151},1.03257976624165,1.0469596045877756,1.0641072594477148,1.0853894046366692,1.1098073490312548,1.1375525327570359,1.1659913460759614,1.1951411297278602,1.2250196579710564]
[null,null,"Real 2015","Calculated","factor",null,null,null,{"$f":"J23/((1+J$16)^Dollar_Conversion_Factor*(1+I$16)^(1-Dollar_Conversion_Factor))","v":0.96398785861038849},{"$f":"1/(1+J$16)^Dollar_Conversion_Factor","v":0.98778779253101578},{"$f":"J23*(1+J$16)^(1-Dollar_Conversion_Factor)*(1+K$16)^Dollar_Conversion_Factor","v":1.0075136064672239},{"$f":"K23*(1+K$16)^(1-Dollar_Conversion_Factor)*(1+L$16)^Dollar_Conversion_Factor","v":1.0215443702553362},{"$f":"L23*(1+L$16)^(1-Dollar_Conversion_Factor)*(1+M$16)^Dollar_Conversion_Factor","v":1.0382757610449067},{"$f":"M23*(1+M$16)^(1-Dollar_Conversion_Factor)*(1+N$16)^Dollar_Conversion_Factor","v":1.059041276265805},{"$f":"N23*(1+N$16)^(1-Dollar_Conversion_Factor)*(1+O$16)^Dollar_Conversion_Factor","v":1.082866468298231},{"$f":"O23*(1+O$16)^(1-Dollar_Conversion_Factor)*(1+P$16)^Dollar_Conversion_Factor","v":1.1099381300056863},{"$f":"P23*(1+P$16)^(1-Dollar_Conversion_Factor)*(1+Q$16)^Dollar_Conversion_Factor","v":1.1376865832558283},{"$f":"Q23*(1+Q$16)^(1-Dollar_Conversion_Factor)*(1+R$16)^Dollar_Conversion_Factor","v":1.1661287478372238},{"$f":"R23*(1+R$16)^(1-Dollar_Conversion_Factor)*(1+S$16)^Dollar_Conversion_Factor","v":1.195281966533154}]
[null,null,"Real 2016","Calculated","factor",null,null,null,{"$f":"J24/((1+J$16)^Dollar_Conversion_Factor*(1+I$16)^(1-Dollar_Conversion_Factor))","v":0.96398785861038849},{"$f":"1/(1+J$16)^Dollar_Conversion_Factor","v":0.98778779253101578},{"$f":"1/(1+K$16)^Dollar_Conversion_Factor","v":0.99254242680297911},{"$f":"K24*(1+K$16)^(1-Dollar_Conversion_Factor)*(1+L$16)^Dollar_Conversion_Factor","v":1.0063647000216835},1.0228474701912094,1.0433044195950336,1.0667755804479671,1.093444969959166,1.1207810942081446,1.1488006215633479,1.1775206371024314]
[null,null,"Real 2017","Calculated","factor",null,null,null,{"$f":"J25/((1+J$16)^Dollar_Conversion_Factor*(1+I$16)^(1-Dollar_Conversion_Factor))","v":0.94966345114554884},{"$f":"K25/((1+K$16)^Dollar_Conversion_Factor*(1+J$16)^(1-Dollar_Conversion_Factor))","v":0.97310972921037853},{"$f":"1/(1+K$16)^Dollar_Conversion_Factor","v":0.99254242680297911},{"$f":"1/(1+L$16)^Dollar_Conversion_Factor","v":0.99367555318509637},{"$f":"L25*(1+L$16)^(1-Dollar_Conversion_Factor)*(1+M$16)^Dollar_Conversion_Factor","v":1.0099504938362078},1.030149503712932,1.0533247191630888,1.0796578371421657,1.1066492830707195,1.1343155151474871,1.1626734030261738]
[null,null,"Real 2018","Calculated","factor",null,null,null,{"$f":"J26/((1+J$16)^Dollar_Conversion_Factor*(1+I$16)^(1-Dollar_Conversion_Factor))","v":0.93768924440253953},{"$f":"K26/((1+K$16)^Dollar_Conversion_Factor*(1+J$16)^(1-Dollar_Conversion_Factor))","v":0.96083989080905519},{"$f":"L26/((1+L$16)^Dollar_Conversion_Factor*(1+K$16)^(1-Dollar_Conversion_Factor))","v":0.98002756355809939},{"$f":"1/(1+L$16)^Dollar_Conversion_Factor","v":0.99367555318509637},{"$f":"1/(1+M$16)^Dollar_Conversion_Factor","v":0.99014754297667429},{"$f":"M26*(1+M$16)^(1-Dollar_Conversion_Factor)*(1+N$16)^Dollar_Conversion_Factor","v":1.0099504938362078},1.0326712932971458,1.058488075629574,1.0849502775203133,1.1120740344583206,1.1398758853197783]
[null,null,"Real 2019","Calculated","factor",null,null,null,0.9193031807868034,{"$f":"K27/((1+K$16)^Dollar_Conversion_Factor*(1+J$16)^(1-Dollar_Conversion_Factor))","v":0.94199989295005404},{"$f":"L27/((1+L$16)^Dollar_Conversion_Factor*(1+K$16)^(1-Dollar_Conversion_Factor))","v":0.96081133682166597},{"$f":"M27/((1+M$16)^Dollar_Conversion_Factor*(1+L$16)^(1-Dollar_Conversion_Factor))","v":0.97419171880891786},{"$f":"1/(1+M$16)^Dollar_Conversion_Factor","v":0.99014754297667429},{"$f":"1/(1+N$16)^Dollar_Conversion_Factor","v":0.99014754297667429},{"$f":"N27*(1+N$16)^(1-Dollar_Conversion_Factor)*(1+O$16)^Dollar_Conversion_Factor","v":1.0124228365658292},1.0377334074799747,1.0636767426669738,1.0902686612336479,1.1175253777644887]
[null,null,"Real 2020","Calculated","factor",null,null,null,0.90127762822235613,{"$f":"K28/((1+K$16)^Dollar_Conversion_Factor*(1+J$16)^(1-Dollar_Conversion_Factor))","v":0.92352930681377843},{"$f":"L28/((1+L$16)^Dollar_Conversion_Factor*(1+K$16)^(1-Dollar_Conversion_Factor))","v":0.94197189884477051},{"$f":"M28/((1+M$16)^Dollar_Conversion_Factor*(1+L$16)^(1-Dollar_Conversion_Factor))","v":0.95508992040089979},{"$f":"N28/((1+N$16)^Dollar_Conversion_Factor*(1+M$16)^(1-Dollar_Conversion_Factor))","v":0.97073288527124924},{"$f":"1/(1+N$16)^Dollar_Conversion_Factor","v":0.99014754297667429},{"$f":"1/(1+O$16)^Dollar_Conversion_Factor","v":0.9877295966495897},{"$f":"O28*(1+O$16)^(1-Dollar_Conversion_Factor)*(1+P$16)^Dollar_Conversion_Factor","v":1.0124228365658292},{"$f":"P28*(1+P$16)^(1-Dollar_Conversion_Factor)*(1+Q$16)^Dollar_Conversion_Factor","v":1.0377334074799747},{"$f":"Q28*(1+Q$16)^(1-Dollar_Conversion_Factor)*(1+R$16)^Dollar_Conversion_Factor","v":1.0636767426669738},{"$f":"R28*(1+R$16)^(1-Dollar_Conversion_Factor)*(1+S$16)^Dollar_Conversion_Factor","v":1.0902686612336479}]
[]
[]
[null,"Real price change"]
[]
[]
[null,null,null,null,"Unit",null,null,null,null,"Labour","Other","Total","Check"]
[]
[null,null,"Benchmark labour / non-labour weights","AER 2017 Annual benchmarking final report","Per cent",null,null,null,null,0.59699999999999998,{"$f":"1-J36","v":0.40300000000000002},{"$f":"SUM(J36:K36)","v":1},{"$f":"IF(ROUND(($L36-1),7)=0,\"Ok\",\"Check\")","v":"Ok"}]
[]
[]
[]
[null,null,null,"Source","Unit",null,null,null,null,null,null,null,{"$f":"\"FY\"&RIGHT(M$5,2)","v":"FY18"},"FY19","FY20","FY21","FY22","FY23","FY24"]
[]
[null,null,"Annual price growth forecast"]
[null,null,"EGWWS labour","External","Per cent",null,null,null,null,null,null,null,{"$f":"'ACT labour price forecast'!I30/100","v":5.704288097400605E-3},{"$f":"'ACT labour price forecast'!J30/100","v":7.3823666320130509E-3},{"$f":"'ACT labour price forecast'!K30/100","v":5.6672232726015983E-3},{"$f":"'ACT labour price forecast'!L30/100","v":1.1131535994233922E-2},{"$f":"'ACT labour price forecast'!M30/100","v":1.5481462452597078E-2},{"$f":"'ACT labour price forecast'!N30/100","v":1.4924737175464315E-2},{"$f":"'ACT labour price forecast'!O30/100","v":1.2490564634845174E-2}]
[null,null,"Non-labour","External","Per cent",null,null,null,null,null,null,null,0,0,0,0,0,0,0]
[]
[null,null,"Cumulative factor"]
[null,null,{"$f":"$C$43","v":"EGWWS labour"},"Calculated","Factor",null,null,null,null,null,null,null,1,{"$f":"M47*(1+N43)","v":1.007382366632013},1.0130914274245983,1.024368691114425,1.040227416543529,1.0557525373381536,1.0689394826441776]
[null,null,{"$f":"$C$44","v":"Non-labour"},"Calculated","Factor",null,null,null,null,null,null,null,1,1,1,1,1,1,1]
[]
[]
[]
[]
[null,null,"Opex real price factor","Calculated","Factor",null,null,null,null,null,null,null,{"$f":"SUM($J$36*M47)+($K$36*M48)","v":1},1.0044072728793116,1.0078155821724852,1.0145481085953119,1.0240157676764867,1.0332842647908778,1.0411568711385741]
[]
[]
[]
[null,"Opex productivity and output growth"]
[]
[null,null,"Partial factor productivity","Source","Unit",null,null,null,null,null,null,null,{"$f":"\"FY\"&RIGHT(M$5,2)","v":"FY18"},"FY19","FY20","FY21","FY22","FY23","FY24"]
[]
[null,null,"Partial factor productivity",null,"Per cent",null,null,null,null,null,null,null,0,0,0,0,0,0,0]
[]
[]
[]
[]
[null,null,"Output growth factor weights"]
[]
[null,null,"Customer numbers","Updated estimates derived using EI model (SFA CD) with updated 2015/16 dataset","Per cent",null,null,null,0.74549401696122408]
[null,null,"Circuit length",null,"Per cent",null,null,null,9.314191328065638E-2]
[null,null,"Ratcheted maximum demand",null,"Per cent",null,null,null,0.16136406975811954]
[]
[]
[]
[null,null,null,"Source","Unit",null,null,null,null,null,null,{"$f":"\"FY\"&RIGHT(L$5,2)","v":"FY17"},"FY18","FY19","FY20","FY21","FY22","FY23","FY24"]
[null,"Customer numbers"]
[null,null,"Forecasts"]
[null,null,"Customer numbers","RIN Workbook 1 table 6.2.4","Number",null,null,null,null,null,null,189190.49315068492,193508,196642,199875,203145,206411,209651,212859]
[null,null,"Incremental customer numbers","Calculated","Number",null,null,null,null,null,null,null,{"$f":"M77-L77","v":4317.5068493150757},{"$f":"N77-M77","v":3134},{"$f":"O77-N77","v":3233},{"$f":"P77-O77","v":3270},{"$f":"Q77-P77","v":3266},{"$f":"R77-Q77","v":3240},{"$f":"S77-R77","v":3208}]
[null,null,"Customer growth rate","Calculated","Per cent",null,null,null,null,null,null,null,{"$f":"M77/L77-1","v":2.2820950341708279E-2},{"$f":"N77/M77-1","v":1.6195712838745768E-2},{"$f":"O77/N77-1","v":1.644104514803546E-2},{"$f":"P77/O77-1","v":1.6360225140712892E-2},{"$f":"Q77/P77-1","v":1.6077186246277186E-2},{"$f":"R77/Q77-1","v":1.5696837862323232E-2},{"$f":"S77/R77-1","v":1.5301620311851671E-2}]
[]
[]
[null,"Circuit length"]
[null,null,"Total mains","RIN Workbook 1 table 3.5.1","kilometres",null,null,null,null,null,null,5333,5380.2999999999993,5410.3,5452.5,5493.7,5523.6,5561.8,5595.4]
[null,null,"Incremental mains","Calculated","kilometres",null,null,null,null,null,null,null,{"$f":"M83-L83","v":47.299999999999272},{"$f":"N83-M83","v":30.000000000000909},{"$f":"O83-N83","v":42.199999999999818},{"$f":"P83-O83","v":41.199999999999818},{"$f":"Q83-P83","v":29.900000000000546},{"$f":"R83-Q83","v":38.199999999999818},{"$f":"S83-R83","v":33.599999999999454}]
[null,null,"Mains growth rate","Calculated","Per cent",null,null,null,null,null,null,null,{"$f":"M83/L83-1","v":8.8693043315206666E-3},5.5758972548001218E-3,7.7999371569044129E-3,7.556166895919203E-3,5.4425978848500201E-3,6.9157795640524267E-3,6.0412096803192927E-3]
[]
[null,"Ratcheted maximum demand"]
[null,null,"Total volume","RIN Workbook 1 table 3.4.3","MVA",null,null,null,null,null,null,721.252762464277,721.252762464277,741.79722191921917,755.08661043690063,764.97488808020501,773.08288137996601,775.90149145062242,775.90149145062242]
[null,null,"Incremental throughput","Calculated","MVA",null,null,null,null,null,null,null,{"$f":"M88-L88","v":0},{"$f":"N88-M88","v":20.544459454942171},{"$f":"O88-N88","v":13.289388517681459},{"$f":"P88-O88","v":9.8882776433043773},{"$f":"Q88-P88","v":8.1079932997610058},{"$f":"R88-Q88","v":2.8186100706564048},{"$f":"S88-R88","v":0}]
[null,null,"Ratched maximum demand growth rate",null,null,null,null,null,null,null,null,null,{"$f":"M88/L88-1","v":0},{"$f":"N88/M88-1","v":2.8484410076640376E-2},1.7915123061931215E-2,1.3095554214082705E-2,1.0599031976211704E-2,3.6459351753141966E-3,0]
[null,null,"Output growth rates"]
[null,null,"Customer numbers ","Calculated","Per cent",null,null,null,null,null,null,null,{"$f":"LN(M77)-LN(L77)","v":2.2564447547081201E-2},{"$f":"LN(N77)-LN(M77)","v":1.606596135216698E-2},1.6307354517490324E-2,1.622783862132593E-2,1.5949316985501838E-2,1.5574916698970043E-2,1.51857312184287E-2]
[null,null,"Circuit length","Calculated",null,null,null,null,null,null,null,null,{"$f":"LN(M83)-LN(L83)","v":8.8302030823648181E-3},{"$f":"LN(N83)-LN(M83)","v":5.5604094851720021E-3},{"$f":"LN(O83)-LN(N83)","v":7.7696749076459071E-3},7.527762064864163E-3,5.4278404705474514E-3,6.8919752478144858E-3,6.0230347354863767E-3]
[null,null,"Ratched maximum demand","Calculated","Per cent",null,null,null,null,null,null,null,{"$f":"LN(M88)-LN(L88)","v":0},{"$f":"LN(N88)-LN(M88)","v":2.8086272073425178E-2},1.7756538485284246E-2,1.3010548768667363E-2,1.0543256004850399E-2,3.6393048645644299E-3,0]
[]
[null,null,"Opex cost function estimate approach","Calculated","Per cent",null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(N92:N94,$I$68:$I$70)","v":1.7027100408945277E-2},{"$f":"SUMPRODUCT(O92:O94,$I$68:$I$70)","v":1.5745984926523612E-2},1.4898341860952409E-2,1.4096982531163007E-2,1.284019201865263E-2,1.1881868745538928E-2]
[]
[]
[]
[null,null,"Output growth ($)","Calculated","Dollars"]
[]
[null,null,"Rate of change"]
[null,null,"Real price change",null,"Per cent",null,null,null,null,null,null,null,null,{"$f":"N53-M53/1","v":4.4072728793116411E-3},{"$f":"O53-N53/1","v":3.4083092931735948E-3},6.7325264228266235E-3,9.4676590811748618E-3,9.2684971143910388E-3,7.8726063476963759E-3]
[null,null,"Output growth",null,"Per cent",null,null,null,null,null,null,null,null,{"$f":"N96","v":1.7027100408945277E-2},{"$f":"O96","v":1.5745984926523612E-2},1.4898341860952409E-2,1.4096982531163007E-2,1.284019201865263E-2,1.1881868745538928E-2]
[null,null,"Productivity growth",null,"Per cent",null,null,null,null,null,null,null,null,{"$f":"M61","v":0},{"$f":"N61","v":0},0,0,0,0]
[null,null,"Rate of change","Calculated","Per cent",null,null,null,null,null,null,null,null,{"$f":"N103+N104-N105","v":2.1434373288256918E-2},{"$f":"O103+O104-O105","v":1.9154294219697207E-2},2.1630868283779033E-2,2.3564641612337869E-2,2.2108689133043667E-2,1.9754475093235302E-2]
[]
[]
[null,"Rate of change workings"]
[]
[]
[]
[null,null,"Rate of change component - total opex",null,null,null,null,null,null,null,null,null,"FY18","FY19","FY20","FY21","FY22","FY23","FY24","Total FY19-24"]
[null,null,"Real input cost escalation",null,null,null,null,null,null,null,null,null,{"$f":"'Total SCS opex forecast '!$M$28","v":51.939258147068621},{"$f":"M114*(1+N$103)","v":52.168168630871762},{"$f":"N114*(1+O$103)","v":52.345973884824211},52.69839453713238,53.197324970735195,53.690384223719775,54.11306748336969,{"$f":"SUM(O114:S114)","v":266.04514509978128}]
[null,null,"Output growth",null,null,null,null,null,null,null,null,null,{"$f":"'Total SCS opex forecast '!$M$28","v":51.939258147068621},{"$f":"M115*(1+N$104)","v":52.82363311070489},{"$f":"N115*(1+O$104)","v":53.655393241430261},54.454769632624931,55.222417568874548,55.931484014193117,56.596054565992965,275.86011902311583]
[null,null,"Opex partial factor productivity",null,null,null,null,null,null,null,null,null,{"$f":"'Total SCS opex forecast '!$M$28","v":51.939258147068621},{"$f":"M116*(1+N$105)","v":51.939258147068621},{"$f":"N116*(1+O$105)","v":51.939258147068621},51.939258147068621,51.939258147068621,51.939258147068621,51.939258147068621,259.6962907353431]
[null,null,"Rate of change",null,null,null,null,null,null,null,null,null,{"$f":"'Total SCS opex forecast '!$M$28","v":51.939258147068621},{"$f":"M117*(1+N$106)","v":53.05254359450803},{"$f":"N117*(1+O$106)","v":54.068727623620546},55.238281149118613,56.539951447679151,57.789975657833274,58.931586292604614,282.56852217085623]
[]
[null,null,"Real input cost escalation",null,null,null,null,null,null,null,null,null,null,{"$f":"N114-$M114","v":0.22891048380314061},{"$f":"O114-$M114","v":0.40671573775559011},{"$f":"P114-$M114","v":0.75913639006375888},1.2580668236665744,1.7511260766511541,2.1738093363010691,{"$f":"SUM(O119:S119)","v":6.3488543644381465}]
[null,null,"Output growth",null,null,null,null,null,null,null,null,null,null,{"$f":"N115-$M115","v":0.88437496363626877},1.7161350943616398,{"$f":"P115-$M115","v":2.5155114855563099},3.2831594218059266,3.9922258671244961,4.656796418924344,16.163828287772716]
[null,null,"Opex partial factor productivity",null,null,null,null,null,null,null,null,null,null,{"$f":"N116-$M116","v":0},0,0,0,0,0,0]
[null,null,"Rate of change - additive",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N119:N121)","v":1.1132854474394094},{"$f":"SUM(O119:O121)","v":2.1228508321172299},3.2746478756200688,4.541226245472501,5.7433519437756502,6.8306057552254131,{"$f":"SUM(O122:S122)","v":22.512682652210863}]
[]
[null,null,"Rate of change - multiplicative",null,null,null,null,null,null,null,null,null,null,{"$f":"N117-$M$117","v":1.1132854474394094},{"$f":"O117-$M$117","v":2.1294694765519253},{"$f":"P117-$M$117","v":3.2990230020499922},4.6006933006105299,5.8507175107646532,6.9923281455359927,{"$f":"SUM(O124:S124)","v":22.872231435513093}]
[]
[]
[]
[null,null,"Real input cost escalation",null,null,null,null,null,null,null,null,null,null,{"$f":"N119/N$122*N$124","v":0.22891048380314061},0.4079837999356889,{"$f":"P119/P$122*P$124","v":0.76478708784507565},{"$f":"Q119/Q$122*Q$124","v":1.2745411249073224},1.7838614280503722,2.2252767543521146,{"$f":"SUM(O128:S128)","v":6.4564501950905733}]
[null,null,"Output growth",null,null,null,null,null,null,null,null,null,null,0.88437496363626877,1.7214856766162365,{"$f":"P120/P$122*P$124","v":2.5342359142049165},3.3261521757032075,4.0668560827142812,4.7670513911838777,{"$f":"SUM(O129:S129)","v":16.415781240422518}]
[null,null,"Opex partial factor productivity",null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(O130:S130)","v":0}]
[null,null,"Rate of change - additive",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N128:N130)","v":1.1132854474394094},2.1294694765519253,{"$f":"SUM(P128:P130)","v":3.2990230020499922},4.6006933006105299,5.8507175107646532,6.9923281455359927,{"$f":"SUM(O131:S131)","v":22.872231435513093}]
[]
[]
[null,null,"Rate of change component - Distribution",null,null,null,null,null,null,null,null,null,"FY18","FY19","FY20","FY21","FY22","FY23","FY24","Total FY19-24"]
[null,null,"Real input cost escalation",null,null,null,null,null,null,null,null,null,{"$f":"'SCS_Distribution opex forecast'!$M$28","v":44.334589602712192},{"$f":"M135*(1+N$103)","v":44.529984237083639},{"$f":"N135*(1+O$103)","v":44.681756196183763},44.982577300392869,45.408457006865582,45.829325159602668,46.190121395764798,{"$f":"SUM(O135:S135)","v":227.09223705880967}]
[null,null,"Output growth",null,null,null,null,null,null,null,null,null,{"$f":"'SCS_Distribution opex forecast'!$M$28","v":44.334589602712192},{"$f":"M136*(1+N$104)","v":45.089479111466957},{"$f":"N136*(1+O$104)","v":45.799457369900914},46.481793342843815,47.137046371615014,47.74229509821869,48.309562782186511,235.47015496476496]
[null,null,"Opex partial factor productivity",null,null,null,null,null,null,null,null,null,{"$f":"'SCS_Distribution opex forecast'!$M$28","v":44.334589602712192},{"$f":"M137*(1+N$105)","v":44.334589602712192},{"$f":"N137*(1+O$105)","v":44.334589602712192},44.334589602712192,44.334589602712192,44.334589602712192,44.334589602712192,221.67294801356095]
[null,null,"Rate of change",null,null,null,null,null,null,null,null,null,{"$f":"'SCS_Distribution opex forecast'!$M$28","v":44.334589602712192},{"$f":"M138*(1+N$106)","v":45.284873745838397},{"$f":"N138*(1+O$106)","v":46.152273541268023},47.150587291236135,48.26167398256537,49.328676329686211,50.303138437623261,241.19634958237899]
[]
[null,null,"Real input cost escalation",null,null,null,null,null,null,null,null,null,null,{"$f":"N135-$M135","v":0.19539463437144633},{"$f":"O135-$M135","v":0.3471665934715702},{"$f":"P135-$M135","v":0.64798769768067643},1.0738674041533898,1.4947355568904754,1.8555317930526058,{"$f":"SUM(O140:S140)","v":5.4192890452487177}]
[null,null,"Output growth",null,null,null,null,null,null,null,null,null,null,{"$f":"N136-$M136","v":0.7548895087547649},{"$f":"O136-$M136","v":1.4648677671887214},{"$f":"P136-$M136","v":2.1472037401316229},{"$f":"Q136-$M136","v":2.8024567689028217},3.407705495506498,3.9749731794743184,13.797206951203982]
[null,null,"Opex partial factor productivity",null,null,null,null,null,null,null,null,null,null,{"$f":"N137-$M137","v":0},{"$f":"O137-$M137","v":0},0,0,0,0,0]
[null,null,"Rate of change - additive",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N140:N142)","v":0.95028414312621123},{"$f":"SUM(O140:O142)","v":1.8120343606602916},2.7951914378122993,3.8763241730562115,4.9024410523969735,5.8305049725269242,{"$f":"SUM(O143:S143)","v":19.2164959964527}]
[]
[null,null,"Rate of change - multiplicative",null,null,null,null,null,null,null,null,null,null,{"$f":"N138-$M$138","v":0.95028414312620413},{"$f":"O138-$M$138","v":1.817683938555831},2.8159976885239431,3.9270843798531772,4.9940867269740181,5.9685488349110685,{"$f":"SUM(O145:S145)","v":19.523401568818038}]
[]
[]
[]
[null,null,"Real input cost escalation",null,null,null,null,null,null,null,null,null,null,{"$f":"N140/N$122*N$124","v":0.19539463437144633},0.34824899276549565,{"$f":"P140/P$122*P$124","v":0.65281105049781274},{"$f":"Q140/Q$122*Q$124","v":1.0879296262673812},1.522677973119746,1.8994636268640042,{"$f":"SUM(O149:S149)","v":5.5111312695144399}]
[null,null,"Output growth",null,null,null,null,null,null,null,null,null,null,{"$f":"N141/N$122*N$124","v":0.7548895087547649},1.4694349457903371,{"$f":"P141/P$122*P$124","v":2.1631866380261338},{"$f":"Q141/Q$122*Q$124","v":2.8391547535857993},3.4714087538542837,4.0690852080470785,{"$f":"SUM(O150:S150)","v":14.012270299303633}]
[null,null,"Opex partial factor productivity",null,null,null,null,null,null,null,null,null,null,{"$f":"N142/N$122*N$124","v":0},0,0,0,0,0,{"$f":"SUM(O151:S151)","v":0}]
[null,null,"Rate of change - additive",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N149:N151)","v":0.95028414312621123},1.8176839385558328,{"$f":"SUM(P149:P151)","v":2.8159976885239466},{"$f":"SUM(Q149:Q151)","v":3.9270843798531807},4.9940867269740297,5.9685488349110827,{"$f":"SUM(O152:S152)","v":19.523401568818073}]
[]
[]
[null,null,"Rate of change component - Transmission",null,null,null,null,null,null,null,null,null,"FY18","FY19","FY20","FY21","FY22","FY23","FY24","Total FY19-24"]
[null,null,"Real input cost escalation",null,null,null,null,null,null,null,null,null,{"$f":"'SCS_Transmission opex forecast'!$M$28","v":7.6046685443564339},{"$f":"M156*(1+N$103)","v":7.63818439378813},{"$f":"N156*(1+O$103)","v":7.6642176886404512},7.7158172367395181,7.7888679638696203,7.8610590641171187,7.9229460876049034,{"$f":"SUM(O156:S156)","v":38.952908040971614}]
[null,null,"Output growth",null,null,null,null,null,null,null,null,null,{"$f":"'SCS_Transmission opex forecast'!$M$28","v":7.6046685443564339},{"$f":"M157*(1+N$104)","v":7.7341539992379387},{"$f":"N157*(1+O$104)","v":7.8559358715293515},7.9729762897811156,8.085371197259537,8.1891889159744338,8.2864917838064631,40.389964058350898]
[null,null,"Opex partial factor productivity",null,null,null,null,null,null,null,null,null,{"$f":"'SCS_Transmission opex forecast'!$M$28","v":7.6046685443564339},{"$f":"M158*(1+N$105)","v":7.6046685443564339},{"$f":"N158*(1+O$105)","v":7.6046685443564339},7.6046685443564339,7.6046685443564339,7.6046685443564339,7.6046685443564339,38.023342721782171]
[null,null,"Rate of change",null,null,null,null,null,null,null,null,null,{"$f":"'SCS_Transmission opex forecast'!$M$28","v":7.6046685443564339},{"$f":"M159*(1+N$106)","v":7.7676698486696347},{"$f":"N159*(1+O$106)","v":7.9164540823525238},8.0876938578824777,8.2782774651137849,8.4612993281470672,8.6284478549813564,41.372172588477213]
[]
[null,null,"Real input cost escalation",null,null,null,null,null,null,null,null,null,null,{"$f":"N156-$M156","v":3.3515849431696054E-2},{"$f":"O156-$M156","v":5.9549144284017252E-2},{"$f":"P156-$M156","v":0.11114869238308422},0.18419941951318641,0.25639051976068483,0.31827754324846946,{"$f":"SUM(O161:S161)","v":0.92956531918944219}]
[null,null,"Output growth",null,null,null,null,null,null,null,null,null,null,{"$f":"N157-$M157","v":0.12948545488150476},{"$f":"O157-$M157","v":0.25126732717291755},{"$f":"P157-$M157","v":0.3683077454246817},{"$f":"Q157-$M157","v":0.4807026529031031},0.58452037161799986,0.68182323945002921,2.3666213365687314]
[null,null,"Opex partial factor productivity",null,null,null,null,null,null,null,null,null,null,{"$f":"N158-$M158","v":0},{"$f":"O158-$M158","v":0},0,0,0,0,0]
[null,null,"Rate of change - additive",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N161:N163)","v":0.16300130431320081},{"$f":"SUM(O161:O163)","v":0.31081647145693481},0.47945643780776592,0.66490207241628951,0.84091089137868469,1.0001007826984987,{"$f":"SUM(O164:S164)","v":3.2961866557581736}]
[]
[null,null,"Rate of change - multiplicative",null,null,null,null,null,null,null,null,null,null,{"$f":"N159-$M$159","v":0.16300130431320081},{"$f":"O159-$M$159","v":0.31178553799608988},0.48302531352604383,0.67360892075735102,0.85663078379063329,1.0237793106249224,{"$f":"SUM(O166:S166)","v":3.3488298666950405}]
[]
[]
[]
[null,null,"Real input cost escalation",null,null,null,null,null,null,null,null,null,null,{"$f":"N161/N$122*N$124","v":3.3515849431696054E-2},5.9734807170190557E-2,{"$f":"P161/P$122*P$124","v":0.11197603734726463},{"$f":"Q161/Q$122*Q$124","v":0.18661149863994303},0.26118345493063277,0.32581312748811686,{"$f":"SUM(O170:S170)","v":0.94531892557614783}]
[null,null,"Output growth",null,null,null,null,null,null,null,null,null,null,{"$f":"N162/N$122*N$124","v":0.12948545488150476},0.25205073082589829,{"$f":"P162/P$122*P$124","v":0.37104927617877742},{"$f":"Q162/Q$122*Q$124","v":0.48699742211740621},0.59544732885999896,0.69796618313680359,{"$f":"SUM(O171:S171)","v":2.4035109411188844}]
[null,null,"Opex partial factor productivity",null,null,null,null,null,null,null,null,null,null,{"$f":"N163/N$122*N$124","v":0},0,0,0,0,0,{"$f":"SUM(O172:S172)","v":0}]
[null,null,"Rate of change - additive",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N170:N172)","v":0.16300130431320081},0.31178553799608888,{"$f":"SUM(P170:P172)","v":0.48302531352604205},{"$f":"SUM(Q170:Q172)","v":0.67360892075734924},0.85663078379063173,1.0237793106249204,{"$f":"SUM(O173:S173)","v":3.3488298666950325}]

{"sheet":"ACT labour price forecast","index":4,"n_rows":51,"n_cols":19,"rows_kept":51,"cut":false,"hidden":false,"merged":[[19,18,19,19],[20,18,20,19],[21,18,21,19],[22,2,22,6],[22,8,22,9],[22,10,22,14],[15,18,17,19],[0,1,0,15],[1,1,1,15],[4,2,4,6],[4,10,4,14],[8,18,10,19]]}
[null,"Expected Labour Price Changes for Australia and the Australian Capital Territory"]
[null,"(per cent change, year average, year ended June)"]
[]
[null,null,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,"Average (g)"]
[null,"NOMINAL LABOUR PRICE CHANGES","Actuals",null,null,null,null,null,"Forecasts",null,"Next Regulatory Period"]
[]
[null,"Australian Capital Territory Wage Inflation"]
[null,"(1) All Industries"]
[null,"Average Weekly Earnings (a)",5.7016391454615354,5.2850969444338141,-3.6803966437833648,1.0888932884577311,1.9127823475649426,0.48226067699518244,2.5721715509838816,3.2770129224999662,3.0999913973747235,3.2701451596322202,4.0586121475789385,4.2696587326902176,3.7298814376763794,{"$f":"AVERAGE(K9:O9)","v":3.6856577749904957},null,null," "]
[null,"Average Weekly Ordinary Time Earnings (b)",5.2910947325715219,6.6082265677680283,0.74847143158338336,1.5919520471158015,1.1241245365193284,2.1104935397509181,2.9721715509838815,3.5770129224999661,3.1999913973747236,3.4701451596322204,4.3586121475789383,4.6696587326902179,3.9798814376763794,{"$f":"AVERAGE(K10:O10)","v":3.9356577749904957}]
[null,"Wage Price Index (c)",3.3100233100233023,3.7003610108303331,2.3716275021758104,1.7428267800212449,1.7338625443910516,1.848049281314168,2.3721715509838814,2.7770129224999662,2.5999913973747235,3.0701451596322205,3.5586121475789381,3.7696587326902176,3.2798814376763796,{"$f":"AVERAGE(K11:O11)","v":3.255657774990496}]
[null,"(2) Electricity, Gas, Water and Waste Services Wages"]
[null,"Wage Price Index (c)",3.4,4,3.1,2.6,2.2999999999999998,2.1,2.5325051185164664,2.9802050382974201,3.0667223272601598,3.6131535994233923,4.0481462452597077,3.9924737175464315,3.7490564634845174,{"$f":"AVERAGE(K13:O13)","v":3.6939104705948416},null," "]
[null,"Australian Wage Inflation (d)"]
[null,"(1) All Industries "]
[null,"Average Weekly Earnings ",4.1434462076721301,4.3049456482614712,2.7308072790852567,1.3179110494020874,1.7008343924407532,1.624576197513683,2.4553469916435366,2.7656672806012583,2.9590884038757315,3.1642404621013531,3.4200132223681567,3.6378705491665109,3.8177469466944558,{"$f":"AVERAGE(K16:O16)","v":3.3997919168412416},null,null," "]
[null,"Average Weekly Ordinary Time Earnings ",4.3333333333333446,4.5896156792406995,2.994846327673506,2.4299292354655222,1.8770001862607133,2.045192012033481,3.3828248380649795,3.4213481573506899,3.2836970594344317,3.8755934687281446,4.5407825021670956,4.4340812025809306,3.802489272869658,{"$f":"AVERAGE(K17:O17)","v":3.9873287011560521}]
[null,"Wage Price Index",3.6448598130841114,3.313796212804343,2.618372245254208,2.4027216670210461,2.1179401993355551,1.9520130134200731,2.4008404550863949,2.5692951630024163,2.5941360877572484,3.2701451596322206,3.708612147578938,3.7696587326902176,3.3798814376763797,{"$f":"AVERAGE(K18:O18)","v":3.3444867130670004}]
[null,"(2) Electricity, Gas, Water and Waste Services Wages"]
[null,"Wage Price Index ",3.4958601655933785,4.2222222222222161,3.1622601279317819,2.8494734668593757,2.4091547881951447,2.1956479121740591,2.639235142140417,3.1877936751885994,3.2785328161594407,3.7675486683792059,4.1366246123192507,4.2281254285431613,3.9327650113112789,{"$f":"AVERAGE(K20:O20)","v":3.8687193073424675}]
[]
[null,"Consumer Price Index (headline) (e)",2.3023791250959436,2.2755688922230677,2.7139364303178315,1.7138776481790075,1.3807629300257585,1.7082179132040354,1.9620763087764059,2.241968375096115,2.5,2.5,2.5,2.5,2.5,2.3384470559677899]
[null,"REAL LABOUR PRICE CHANGES (f)"]
[null,"Australian Capital Territory Wage Inflation"]
[null,"(1) All Industries"]
[null,"Average Weekly Earnings ",{"$f":"C9-C22","v":3.3992600203655918},3.0095280522107464,-6.3943330741011959,-0.62498435972127631,0.53201941753918414,-1.2259572362088529,0.61009524220747569,1.0350445474038512,0.59999139737472351,0.77014515963222019,1.5586121475789385,1.7696587326902176,1.2298814376763794,1.3472107190227058]
[null,"Average Weekly Ordinary Time Earnings",{"$f":"C10-C22","v":2.9887156074755783},4.3326576755449606,-1.9654649987344481,-0.12192560106320594,-0.25663839350643003,0.40227562654688276,1.0100952422074756,1.335044547403851,0.6999913973747236,0.97014515963222037,1.8586121475789383,2.1696587326902179,1.4798814376763794,1.5972107190227058]
[null,"Wage Price Index",{"$f":"C11-C22","v":1.0076441849273587},1.4247921186072654,-0.34230892814202107,2.8949131842237463E-2,0.35309961436529314,0.13983136811013264,0.41009524220747551,0.53504454740385121,9.9991397374723512E-2,0.57014515963222046,1.0586121475789381,1.2696587326902176,0.77988143767637963,{"$f":"P11-P22","v":0.91721071902270612}]
[null,"(2) Electricity, Gas, Water and Waste Services Wages"]
[null,"Wage Price Index",{"$f":"C13-C22","v":1.0976208749040564},1.7244311077769323,0.38606356968216859,0.88612235182099264,0.91923706997424137,0.39178208679596471,0.57042880974006049,0.7382366632013051,0.56672232726015981,1.1131535994233923,1.5481462452597077,1.4924737175464315,1.2490564634845174,1.3554634146270517]
[null,"Australian Wage Inflation"]
[null,"(1) All Industries"]
[null,"Average Weekly Earnings ",{"$f":"C16-C22","v":1.8410670825761866},2.0293767560384035,1.6870848767425173E-2,-0.39596659877692009,0.32007146241499473,-8.3641715690352392E-2,0.49327068286713072,0.52369890550514331,0.45908840387573147,0.66424046210135312,0.92001322236815675,1.1378705491665109,1.3177469466944558,1.0613448608734517]
[null,"Average Weekly Ordinary Time Earnings ",{"$f":"C17-C22","v":2.030954208237401},2.3140467870176318,0.28090989735567451,0.71605158728651475,0.49623725623495485,0.33697409882944562,1.4207485292885735,1.1793797822545748,0.78369705943443169,1.3755934687281446,2.0407825021670956,1.9340812025809306,1.302489272869658,1.6488816451882622]
[null,"Wage Price Index ",{"$f":"C18-C22","v":1.3424806879881679},1.0382273205812753,-9.5564185063623519E-2,0.68884401884203861,0.73717726930979666,0.24379510021603767,0.43876414630998894,0.32732678790630132,9.4136087757248355E-2,0.77014515963222063,1.208612147578938,1.2696587326902176,0.87988143767637972,1.0060396570992105]
[null,"(2) Electricity, Gas, Water and Waste Services Wages"]
[null,"Wage Price Index",{"$f":"C20-C22","v":1.193481040497435},{"$f":"D20-D22","v":1.9466533299991484},0.44832369761395041,1.1355958186803683,{"$f":"G20-G22","v":1.0283918581693863},0.4874299989700237,0.67715883336401106,0.94582530009248433,0.7785328161594407,1.2675486683792059,1.6366246123192507,1.7281254285431613,1.4327650113112789,{"$f":"P20-P22","v":1.5302722513746776}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Source: BIS Oxford Economics, Department of Employment, RBA, ABS Data"]
[]
[null,"(a) Average Weekly Earnings (AWE) for all employees (i.e. for both full-time and part-time employees). Includes overtime earnings but excludes bonus payments. "]
[null,"It is derived by dividing weekly earnings of all adult employees by the number of employees. It is not a strict wage inflation measure but a long historical series allows for the calculation of how employee "]
[null,"earnings has changed over time. "]
[null,"(b) Average Weekly Ordinary Time Earnings for full-time adult persons. Excludes over-time earnings but includes bonuses.  "]
[null,"(c) Wage price index for total hourly rates of pay excluding bonuses. This is the only series published by the ABS at the state by industry level. It measures quarterly change in combined ordinary time and overtime hourly rates of pay."]
[null,"(d) Australian wages provided for comparison."]
[null,"(e) Reserve Bank of Australia forecasts to December 2019. Beyond that, we have used the mid-point of the Reserve Bank's 2 to 3 per cent inflation target range as preferred by the AER in their recent revenue determinations."]
[null,"(f) Real price changes are calculated by deducting the inflation rate from nominal price changes."]
[null,"(g) Expected average wage change for ActewAGL's next revenue determination period i.e. from 2019/20 to 2023/24 inclusive. "]
[null,"Average inflation is calculated as a geometric mean of Reserve Bank's inflation forecasts for the next two years and assuming an inflation of 2.5% (the mid-point of the bank's 2 to 3 per cent inflation target) "]
[null,"for the next eight years.  This methodology has been adopted by the AER in their recent revenue determinations. "]