{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Total SCS opex forecast ","Rate of change","ACT labour price forecast"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":19,"defined_names":992,"comments":1,"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":47,"n_cols":21,"rows_kept":47,"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,55.75228854310479,null,null,null,null,null,null,"2017/18 RIN excluding DMIA"]
[null,"Adjustments",null,null,"$ millions","Nominal","Mid-year"]
[null,null,"  Power of Choice (Pass Through)",null,"$ millions","Nominal","Mid-year",null,null,null,null,null,-1.5457984600000001]
[null,null,"  Ring Fencing Implementation (Pass Through)",null,"$ millions","Nominal","Mid-year",null,null,null,null,null,-1.5517241499999999]
[null,null,"TCCS contract switching costs",null,"$ millions","Nominal","Mid-year",null,null,null,null,null,-4.5116000000000003E-2,null,null,null,null,null,null,"AER draft decision"]
[null,null,"Adjusted base opex",null,"$ millions","Nominal","Mid-year",null,null,null,null,null,{"$f":"SUM(M15:M19)","v":52.609649933104791}]
[]
[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'!N110","v":2.252232238938947E-3},{"$f":"'Rate of change'!O110","v":1.3504338387840768E-3},{"$f":"'Rate of change'!P110","v":3.1433929028486058E-3},{"$f":"'Rate of change'!Q110","v":5.5467756677120622E-3},{"$f":"'Rate of change'!R110","v":5.9380356107113794E-3},{"$f":"'Rate of change'!S110","v":5.6694168160056737E-3}]
[null,null,"Output growth","Rate of change","per cent","n/a",null,null,null,null,null,null,null,{"$f":"'Rate of change'!N111","v":1.0564368919284584E-2},{"$f":"'Rate of change'!O111","v":5.3310367936867074E-3},{"$f":"'Rate of change'!P111","v":1.1366280779779829E-2},{"$f":"'Rate of change'!Q111","v":1.0257080867067706E-2},{"$f":"'Rate of change'!R111","v":1.0211662975935211E-2},{"$f":"'Rate of change'!S111","v":9.6673060474155876E-3}]
[null,null,"Productivity growth","Rate of change","per cent","n/a",null,null,null,null,null,null,null,{"$f":"'Rate of change'!N112","v":0},{"$f":"'Rate of change'!O112","v":0},{"$f":"'Rate of change'!P112","v":0},{"$f":"'Rate of change'!Q112","v":0},{"$f":"'Rate of change'!R112","v":0},{"$f":"'Rate of change'!S112","v":0}]
[null,null,"Rate of change","Calculated","per cent","n/a",null,null,null,null,null,null,null,{"$f":"(1+N23)*(1+N24)*(1-N25)-1","v":1.2840394570487357E-2},{"$f":"(1+O23)*(1+O24)*(1-O25)-1","v":6.6886698449526438E-3},1.4545402368963289E-2,1.5860750261355028E-2,1.6210335805042497E-2,1.5391530850891844E-2]
[]
[]
[null,null,"Base opex - Total SCS","Calculated",null,"Real FY18","Year-end",null,null,null,null,null,{"$f":"SUM(M15:M19)/'Rate of change'!$M$26","v":53.153372284857838},{"$f":"M29*(1+N$26)","v":53.835882557747418},{"$f":"N29*(1+O$26)","v":54.195973001987838},{"$f":"O29*(1+P$26)","v":54.98427523607922},55.856367093900282,56.761817561342134,57.635468827490229,null,{"$f":"SUM(O29:S29)","v":279.43390172079967}]
[null,null,"Base opex - Total SCS","Calculated",null,"Real FY19","Year-end",null,null,null,null,null,{"$f":"M29*(1+'Rate of change'!$N$16)","v":54.349323161267137},{"$f":"M30*(1+N26)","v":55.047189915296734},{"$f":"N30*(1+O26)","v":55.415382394532557},{"$f":"O30*(1+P26)","v":56.221421428890999},57.11313535351303,58.038958456472322,58.932266876108748,null,{"$f":"SUM(O30:S30)","v":285.72116450951768}]
[]
[]
[]
[null,null,"Step changes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"FY\"&RIGHT(O$5,2)","v":"FY20"},"FY21","FY22","FY23","FY24"]
[null,null,"Vegetation and private electrical infrastructure responsibilities",null,"$ millions","Real FY19","Year-end",null,null,null,null,null,null,null,2.404928,2.404928,2.404928,2.404928,2.404928,null,{"$f":"SUM(O37:S37)","v":12.02464}]
[null,null,"Strathnairn demand management opex capex trade-off",null,"$ millions","Real FY19","Year-end",null,null,null,null,null,null,null,0.3514121658585706,0.35257636823809685,0.35353426233014174,0.35346451212231905,0.35297564533391101,null,{"$f":"SUM(O38:S38)","v":1.763962953883039}]
[]
[null,null,"Total step changes","Calculated","$ millions","Real FY19","Year-end",null,null,null,null,null,null,null,{"$f":"SUM(O37:O38)","v":2.7563401658585707},2.7575043682380969,2.7584622623301418,2.758392512122319,2.757903645333911,null,{"$f":"SUM(O40:S40)","v":13.788602953883039}]
[]
[null,null,"Total opex","Calculated","$ millions","Real FY19","Year-end",null,null,null,null,null,null,null,{"$f":"O30+O40","v":58.171722560391125},{"$f":"P30+P40","v":58.978925797129094},59.871597615843172,60.797350968594642,61.69017052144266,null,{"$f":"SUM(O42:S42)","v":299.50976746340069}]
[]
[null,null,"Distribution allocation (AER draft decision with revised base year adjustments)",null,null,null,null,null,null,null,null,null,null,null,0.85687523327144577,0.85687523327144577,0.85687523327144577,0.85687523327144577,0.85687523327144577]
[]
["Dist PTRM Input =>",null,"Distribution allocation",null,"$ millions","Real FY19","Year-end",null,null,null,null,null,null,null,{"$f":"O30*O44+O40","v":50.240408882000018},{"$f":"P30*P44+P40","v":50.932247969971328},51.697293441235274,52.490538578343788,53.255503572014689,null,{"$f":"SUM(O46:S46)","v":258.61599244356506}]
["Trans PTRM Input =>",null,"Transmission allocation",null,"$ millions","Real FY19","Year-end",null,null,null,null,null,null,null,{"$f":"O30*(1-O44)","v":7.9313136783911036},{"$f":"P30*(1-P44)","v":8.0466778271577635},8.1743041746078955,8.3068123902508511,8.4346669494279674,null,40.893775019835573]

{"sheet":"Rate of change","index":1,"n_rows":116,"n_cols":21,"rows_kept":116,"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","AER draft decision","Per cent",null,null,null,3.0155642023346418E-2,1.5108593012275628E-2,1.0232558139534831E-2,1.9337016574585641E-2,2.0776874435411097E-2,2.2499999999999964E-2,2.44995114800401E-2,2.44995114800401E-2,2.44995114800401E-2,2.44995114800401E-2,2.44995114800401E-2,null,"Inflation to FY19 set equal to AER draft decision opex model.  Inflation from FY20 set equal to AER draft decision PTRMs."]
[]
[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.98525484065733759},{"$f":"I22*(1+I$16)^(1-Dollar_Conversion_Factor)*(1+J$16)^Dollar_Conversion_Factor","v":1.0075259763461564},1.0202889535036062,1.0353632910761426,1.0561292531456397,1.0789818560083593,1.1043371392257029,1.1313928596459979,1.1591114319993308,1.1875090958342442,1.2166024885602875]
[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.97059058256383302},{"$f":"1/(1+J$16)^Dollar_Conversion_Factor","v":0.99253024088426012},{"$f":"J23*(1+J$16)^(1-Dollar_Conversion_Factor)*(1+K$16)^Dollar_Conversion_Factor","v":1.0051032574514593},{"$f":"K23*(1+K$16)^(1-Dollar_Conversion_Factor)*(1+L$16)^Dollar_Conversion_Factor","v":1.019953232790358},{"$f":"L23*(1+L$16)^(1-Dollar_Conversion_Factor)*(1+M$16)^Dollar_Conversion_Factor","v":1.0404101200755649},{"$f":"M23*(1+M$16)^(1-Dollar_Conversion_Factor)*(1+N$16)^Dollar_Conversion_Factor","v":1.0629225911747464},{"$f":"N23*(1+N$16)^(1-Dollar_Conversion_Factor)*(1+O$16)^Dollar_Conversion_Factor","v":1.087900493432576},{"$f":"O23*(1+O$16)^(1-Dollar_Conversion_Factor)*(1+P$16)^Dollar_Conversion_Factor","v":1.1145535240605688},{"$f":"P23*(1+P$16)^(1-Dollar_Conversion_Factor)*(1+Q$16)^Dollar_Conversion_Factor","v":1.1418595409184102},{"$f":"Q23*(1+Q$16)^(1-Dollar_Conversion_Factor)*(1+R$16)^Dollar_Conversion_Factor","v":1.1698345418497345},{"$f":"R23*(1+R$16)^(1-Dollar_Conversion_Factor)*(1+S$16)^Dollar_Conversion_Factor","v":1.1984949166375298}]
[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.97059058256383302},{"$f":"1/(1+J$16)^Dollar_Conversion_Factor","v":0.99253024088426012},{"$f":"1/(1+K$16)^Dollar_Conversion_Factor","v":0.99492265355462151},{"$f":"K24*(1+K$16)^(1-Dollar_Conversion_Factor)*(1+L$16)^Dollar_Conversion_Factor","v":1.0096222147786693},1.029871896023234,1.0521563402512453,1.0768812434990971,1.1032643078868434,1.1302937444634358,1.1579853890317355,1.1863554653640374]
[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.96075955456364681},{"$f":"K25/((1+K$16)^Dollar_Conversion_Factor*(1+J$16)^(1-Dollar_Conversion_Factor))","v":0.9824769879839591},{"$f":"1/(1+K$16)^Dollar_Conversion_Factor","v":0.99492265355462151},{"$f":"1/(1+L$16)^Dollar_Conversion_Factor","v":0.99046948983706873},{"$f":"L25*(1+L$16)^(1-Dollar_Conversion_Factor)*(1+M$16)^Dollar_Conversion_Factor","v":1.0103350307870211},1.0321967348806256,1.0564526020235043,1.0823351746748977,1.1088518577120967,1.1360181865297783,1.1638500771321991]
[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.94253376355566454},{"$f":"K26/((1+K$16)^Dollar_Conversion_Factor*(1+J$16)^(1-Dollar_Conversion_Factor))","v":0.96383921314415522},{"$f":"L26/((1+L$16)^Dollar_Conversion_Factor*(1+K$16)^(1-Dollar_Conversion_Factor))","v":0.97604878207797574},{"$f":"1/(1+L$16)^Dollar_Conversion_Factor","v":0.99046948983706873},{"$f":"1/(1+M$16)^Dollar_Conversion_Factor","v":0.98977068945241808},{"$f":"M26*(1+M$16)^(1-Dollar_Conversion_Factor)*(1+N$16)^Dollar_Conversion_Factor","v":1.0111874208078342},1.0349495844601944,1.0603053436859398,1.0862823066259217,1.1128956924676681,1.1401610932613671]
[null,null,"Real 2019","Calculated","factor",null,null,null,0.92334944801426599,{"$f":"K27/((1+K$16)^Dollar_Conversion_Factor*(1+J$16)^(1-Dollar_Conversion_Factor))","v":0.94422124685892017},{"$f":"L27/((1+L$16)^Dollar_Conversion_Factor*(1+K$16)^(1-Dollar_Conversion_Factor))","v":0.95618230244276026},{"$f":"M27/((1+M$16)^Dollar_Conversion_Factor*(1+L$16)^(1-Dollar_Conversion_Factor))","v":0.97030949137135847},{"$f":"1/(1+M$16)^Dollar_Conversion_Factor","v":0.98977068945241808},{"$f":"1/(1+N$16)^Dollar_Conversion_Factor","v":0.98893635286829751},{"$f":"N27*(1+N$16)^(1-Dollar_Conversion_Factor)*(1+O$16)^Dollar_Conversion_Factor","v":1.0121756327239064},1.0369734412576428,1.0623787839862313,1.0884065452006531,1.1150719738497474]
[null,null,"Real 2020","Calculated","factor",null,null,null,0.90303124500172716,{"$f":"K28/((1+K$16)^Dollar_Conversion_Factor*(1+J$16)^(1-Dollar_Conversion_Factor))","v":0.92344376220921287},{"$f":"L28/((1+L$16)^Dollar_Conversion_Factor*(1+K$16)^(1-Dollar_Conversion_Factor))","v":0.93514161608093915},{"$f":"M28/((1+M$16)^Dollar_Conversion_Factor*(1+L$16)^(1-Dollar_Conversion_Factor))","v":0.94895793777149973},{"$f":"N28/((1+N$16)^Dollar_Conversion_Factor*(1+M$16)^(1-Dollar_Conversion_Factor))","v":0.96799089432999319},{"$f":"1/(1+N$16)^Dollar_Conversion_Factor","v":0.98893635286829751},{"$f":"1/(1+O$16)^Dollar_Conversion_Factor","v":0.98797083003160224},{"$f":"O28*(1+O$16)^(1-Dollar_Conversion_Factor)*(1+P$16)^Dollar_Conversion_Factor","v":1.0121756327239064},{"$f":"P28*(1+P$16)^(1-Dollar_Conversion_Factor)*(1+Q$16)^Dollar_Conversion_Factor","v":1.0369734412576428},{"$f":"Q28*(1+Q$16)^(1-Dollar_Conversion_Factor)*(1+R$16)^Dollar_Conversion_Factor","v":1.0623787839862313},{"$f":"R28*(1+R$16)^(1-Dollar_Conversion_Factor)*(1+S$16)^Dollar_Conversion_Factor","v":1.0884065452006531}]
[]
[]
[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,null,{"$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,"DAE",null,null,null,null,null,null,null,null,null,null,1.6279999759816199E-4,-1.1431568110134016E-3,-6.0090650395383527E-4,3.1007005883143535E-3,4.9681794433342752E-3,6.5024565243028132E-3]
[null,null,"Average",null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(N43:N44)","v":3.7725833148056064E-3},{"$f":"AVERAGE(O43:O44)","v":2.2620332307940983E-3},5.2653147451400435E-3,9.2910815204557164E-3,9.9464583093992961E-3,9.4965105795739926E-3]
[null,null,"Non-labour","External","Per cent",null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[null,null,"Opex real price factor","Calculated","Factor",null,null,null,null,null,null,null,null,{"$f":"N45*$J$36+N46*$K$36","v":2.252232238938947E-3},1.3504338387840768E-3,3.1433929028486058E-3,5.5467756677120622E-3,5.9380356107113794E-3,5.6694168160056737E-3]
[]
[]
[]
[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,"Output growth factor weights"]
[null,null,null,null,null,null,null,null,"SFA CD","LSE CD","LSE TLG","MPFP"]
[null,null,"Customer numbers","Four model approach as per AER draft decision, updated for 2018 benchmarking report","Per cent",null,null,null,0.71199999999999997,0.67659999999999998,0.51680000000000004,0.31]
[null,null,"Circuit length",null,"Per cent",null,null,null,0.16900000000000001,0.1181,0.1386,0.28999999999999998]
[null,null,"Ratcheted maximum demand",null,"Per cent",null,null,null,0.11899999999999999,0.2054,0.34449999999999997,0.28000000000000003]
[null,null,"Energy throughput",null,"Per cent",null,null,null,null,null,null,0.12]
[]
[]
[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","Revised forecasts","Number",null,null,null,null,null,null,189168.66666666631,195104.08333333299,198432.98153354207,199671.93110316282,203076.9722440929,206560.93968087141,210005.5303920173,213413.31434150302]
[null,null,"Incremental customer numbers","Calculated","Number",null,null,null,null,null,null,null,{"$f":"M76-L76","v":5935.4166666666861},{"$f":"N76-M76","v":3328.8982002090779},{"$f":"O76-N76","v":1238.949569620745},{"$f":"P76-O76","v":3405.0411409300868},{"$f":"Q76-P76","v":3483.9674367785046},{"$f":"R76-Q76","v":3444.5907111458946},{"$f":"S76-R76","v":3407.783949485718}]
[null,null,"Customer growth rate","Calculated","Per cent",null,null,null,null,null,null,null,{"$f":"M76/L76-1","v":3.1376320250358747E-2},{"$f":"N76/M76-1","v":1.7062165708350063E-2},{"$f":"O76/N76-1","v":6.2436675599277791E-3},{"$f":"P76/O76-1","v":1.7053178792420409E-2},{"$f":"Q76/P76-1","v":1.7155896103231649E-2},{"$f":"R76/Q76-1","v":1.6675905505017852E-2},{"$f":"S76/R76-1","v":1.6227115272271275E-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":"M82-L82","v":47.299999999999272},{"$f":"N82-M82","v":30.000000000000909},{"$f":"O82-N82","v":42.199999999999818},{"$f":"P82-O82","v":41.199999999999818},{"$f":"Q82-P82","v":29.900000000000546},{"$f":"R82-Q82","v":38.199999999999818},{"$f":"S82-R82","v":33.599999999999454}]
[null,null,"Mains growth rate","Calculated","Per cent",null,null,null,null,null,null,null,{"$f":"M82/L82-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","AER draft decision","MVA",null,null,null,null,null,null,null,724,724,724,724,724,724,724]
[null,null,"Incremental throughput","Calculated","MVA",null,null,null,null,null,null,null,null,{"$f":"N87-M87","v":0},{"$f":"O87-N87","v":0},{"$f":"P87-O87","v":0},{"$f":"Q87-P87","v":0},{"$f":"R87-Q87","v":0},{"$f":"S87-R87","v":0}]
[null,null,"Ratched maximum demand growth rate",null,null,null,null,null,null,null,null,null,null,{"$f":"N87/M87-1","v":0},{"$f":"O87/N87-1","v":0},{"$f":"P87/O87-1","v":0},{"$f":"Q87/P87-1","v":0},{"$f":"R87/Q87-1","v":0},0]
[]
[null,"Energy throughput",null,"Revised forecasts",null,null,null,null,null,null,null,null,2897302.8460899913,2916615.1043042433,2964994.4848577399,3030351.3252332644,3016714.908541678,2998541.8101295093,2966172.3280586665]
[]
[]
[null,null,"Output growth rates"]
[null,null,"Customer numbers ","Calculated","Per cent",null,null,null,null,null,null,null,null,{"$f":"LN(N76)-LN(M76)","v":1.6918241755154995E-2},6.2242566226871077E-3,1.6909405564076607E-2,1.7010395489020169E-2,1.6538389291905986E-2,1.6096862829058978E-2]
[null,null,"Circuit length","Calculated","Per cent",null,null,null,null,null,null,null,null,{"$f":"LN(N82)-LN(M82)","v":5.5604094851720021E-3},{"$f":"LN(O82)-LN(N82)","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,null,{"$f":"LN(N87)-LN(M87)","v":0},{"$f":"LN(O87)-LN(N87)","v":0},0,0,0,0]
[null,null,"Energy throughput","Calculated","Per cent",null,null,null,null,null,null,null,null,{"$f":"LN(N91)-LN(M91)","v":6.6434818685863206E-3},{"$f":"LN(O91)-LN(N91)","v":1.6451439345363639E-2},2.180338935533932E-2,-4.5101010239605444E-3,-6.0423534867375395E-3,-1.0853764016854228E-2]
[null,null,null,null,"SFA CD",null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(N95:N98,$I$67:$I$70)","v":1.2985497332664424E-2},{"$f":"SUMPRODUCT(O95:O98,$I$67:$I$70)","v":5.7447457747453788E-3},{"$f":"SUMPRODUCT(P95:P98,$I$67:$I$70)","v":1.3311688550584587E-2},1.3028706627704879E-2,1.2940076992717708E-2,1.2478859204587189E-2]
[null,null,null,null,"LSE CD",null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(N95:N98,$J$67:$J$70)","v":1.2103566731736681E-2},{"$f":"SUMPRODUCT(O95:O98,$J$67:$J$70)","v":5.1289306375030793E-3},{"$f":"SUMPRODUCT(P95:P98,$J$67:$J$70)","v":1.232993250451469E-2},1.21502615474427E-2,1.2003816471670481E-2,1.1602457792402245E-2]
[null,null,null,null,"LSE TLG",null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(N95:N98,$K$67:$K$70)","v":9.5140200937089414E-3},{"$f":"SUMPRODUCT(O95:O98,$K$67:$K$70)","v":4.2935727648044202E-3},9.7821286177049646E-3,9.5432710779435014E-3,9.502267355404102E-3,9.1536513243960921E-3]
[null,null,null,null,"MPFP",null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(N95:N98,$L$67:$L$70)","v":7.6543915190282873E-3},{"$f":"SUMPRODUCT(O95:O98,$L$67:$L$70)","v":6.1568979976939532E-3},1.0041373446315073E-2,6.3060842151797473E-3,6.4004910839485516E-3,5.4342558682768244E-3]
[null,null,"Opex cost function estimate approach","Calculated","Per cent",null,null,null,null,null,null,null,null,{"$f":"AVERAGE(N99:N102)","v":1.0564368919284584E-2},{"$f":"AVERAGE(O99:O102)","v":5.3310367936867074E-3},1.1366280779779829E-2,1.0257080867067706E-2,1.0211662975935211E-2,9.6673060474155876E-3]
[]
[]
[]
[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":"N52","v":2.252232238938947E-3},{"$f":"O52","v":1.3504338387840768E-3},3.1433929028486058E-3,5.5467756677120622E-3,5.9380356107113794E-3,5.6694168160056737E-3]
[null,null,"Output growth",null,"Per cent",null,null,null,null,null,null,null,null,{"$f":"N103","v":1.0564368919284584E-2},{"$f":"O103","v":5.3310367936867074E-3},1.1366280779779829E-2,1.0257080867067706E-2,1.0211662975935211E-2,9.6673060474155876E-3]
[null,null,"Productivity growth",null,"Per cent",null,null,null,null,null,null,null,null,{"$f":"M60","v":0},{"$f":"N60","v":0},0,0,0,0]
[null,null,"Rate of change","Calculated","Per cent",null,null,null,null,null,null,null,null,{"$f":"N110+N111-N112","v":1.281660115822353E-2},{"$f":"O110+O111-O112","v":6.6814706324707842E-3},1.4509673682628434E-2,1.5803856534779767E-2,1.6149698586646589E-2,1.5336722863421262E-2]
[]
[]
[null,"Rate of change workings"]

{"sheet":"ACT labour price forecast","index":2,"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. "]