{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Metering opex forecast ","Rate of change","ACT labour price forecast"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":22,"defined_names":1421,"comments":2,"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":"Metering opex forecast ","index":0,"n_rows":62,"n_cols":22,"rows_kept":62,"cut":false,"hidden":false,"merged":[[3,14,3,18]]}
["Evoenergy Electricity Distribution Deterimation 2019-24 "]
["Metering opex model"]
["Forecast"]
[null,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"]
[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,{"$f":"4.01*'Rate of change'!$M$26","v":3.9704916473364635}]
[]
[]
[]
[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'!N91","v":9.4299682950049757E-4},{"$f":"'Rate of change'!O91","v":-1.8326180877042964E-3},{"$f":"'Rate of change'!P91","v":-5.2018396251263255E-4},{"$f":"'Rate of change'!Q91","v":1.9548785463942009E-3},{"$f":"'Rate of change'!R91","v":2.7572361249668109E-3},{"$f":"'Rate of change'!S91","v":2.3613830527058344E-3}]
[null,null,"Output growth","Rate of change","per cent","n/a",null,null,null,null,null,null,null,{"$f":"'Rate of change'!N92","v":-6.4560530096016144E-3},{"$f":"'Rate of change'!O92","v":-6.456053009602755E-3},{"$f":"'Rate of change'!P92","v":-6.4560530096016144E-3},{"$f":"'Rate of change'!Q92","v":-6.4560530096016144E-3},{"$f":"'Rate of change'!R92","v":-6.4560530096016144E-3},{"$f":"'Rate of change'!S92","v":-6.4560530096016144E-3}]
[null,null,"Productivity growth","Rate of change","per cent","n/a",null,null,null,null,null,null,null,{"$f":"'Rate of change'!N93","v":0},{"$f":"'Rate of change'!O93","v":0},{"$f":"'Rate of change'!P93","v":0},{"$f":"'Rate of change'!Q93","v":0},{"$f":"'Rate of change'!R93","v":0},{"$f":"'Rate of change'!S93","v":0}]
[null,null,"Rate of change","Calculated","per cent","n/a",null,null,null,null,null,null,null,{"$f":"N20+N21-N22","v":-5.5130561801011169E-3},{"$f":"O20+O21-O22","v":-8.2886710973070522E-3},-6.976236972114247E-3,-4.5011744632074135E-3,-3.6988168846348035E-3,-4.0946699568957801E-3]
[]
[]
[null,null,"Base opex(A)","Calculated",null,"Real FY18","Year-end",null,null,null,null,null,{"$f":"SUM(M15:M16)/'Rate of change'!$M$26","v":4.01},{"$f":"M26*(1+N$23)","v":3.9878926447177943},{"$f":"N26*(1+O$23)","v":3.9548383142143586},{"$f":"O26*(1+P$23)","v":3.9272484249480026},3.9095711946269551,3.8951104066805873,3.8791612151195602,null,{"$f":"SUM(O26:S26)","v":19.565929555589463}]
[null,null,"Base opex(A) ","Calculated",null,"Real FY19","Year-end",null,null,null,null,null,{"$f":"M26*(1+'Rate of change'!$N$16)","v":4.0902000000000003},{"$f":"N26*(1+'Rate of change'!$N$16)","v":4.0676504976121501},{"$f":"O26*(1+'Rate of change'!$N$16)","v":4.0339350804986456},{"$f":"P26*(1+'Rate of change'!$N$16)","v":4.0057933934469627},{"$f":"Q26*(1+'Rate of change'!$N$16)","v":3.9877626185194943},{"$f":"R26*(1+'Rate of change'!$N$16)","v":3.9730126148141989},{"$f":"S26*(1+'Rate of change'!$N$16)","v":3.9567444394219513},null,{"$f":"SUM(O27:S27)","v":19.95724814670125}]
[]
[]
[]
[null,null,"Step changes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"FY\"&RIGHT(M$5,2)","v":"FY18"},{"$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(O34:S34)","v":0},{"$f":"U34*(1+'Rate of change'!$N$16)","v":0}]
[null,null,null,null,"$ millions","Real FY18","Year-end",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O35:S35)","v":0},{"$f":"U35*(1+'Rate of change'!$N$16)","v":0}]
[]
[null,null,"Total step changes (B)","Calculated",null,"Real FY18","Year-end",null,null,null,null,null,null,{"$f":"SUM(N34:N35)","v":0},0,0,0,0,0,null,{"$f":"SUM(O37:S37)","v":0}]
[null,null,"Total step changes (B)","Calculated",null,"Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N37*(1+'Rate of change'!$N$16)","v":0},{"$f":"O37*(1+'Rate of change'!$N$16)","v":0},{"$f":"P37*(1+'Rate of change'!$N$16)","v":0},{"$f":"Q37*(1+'Rate of change'!$N$16)","v":0},{"$f":"R37*(1+'Rate of change'!$N$16)","v":0},{"$f":"S37*(1+'Rate of change'!$N$16)","v":0},null,{"$f":"SUM(O38:S38)","v":0},{"$f":"SUM(V34:V35)","v":0}]
[]
["PTRM Input =>",null,"Total metering opex","Calculated",null,"Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N27+N38","v":4.0676504976121501},{"$f":"O27+O38","v":4.0339350804986456},4.0057933934469627,3.9877626185194943,3.9730126148141989,3.9567444394219513,null,{"$f":"SUM(O40:S40)","v":19.95724814670125}]
[]
[null,null,"% change",null,null,null,null,null,null,null,null,null,null,{"$f":"N40/M27-1","v":-5.5130561801012279E-3},{"$f":"O40/N40-1","v":-8.288671097307021E-3},{"$f":"P40/O40-1","v":-6.976236972114136E-3},{"$f":"Q40/P40-1","v":-4.5011744632074135E-3},{"$f":"R40/Q40-1","v":-3.6988168846348035E-3},{"$f":"S40/R40-1","v":-4.0946699568957801E-3}]
[]
[]
[null,null,"Total metering opex ","Calculated",null,"Nominal",null,null,null,null,null,null,null,{"$f":"N40*'Rate of change'!N28","v":4.0275741458985168},{"$f":"O40*'Rate of change'!O28","v":3.9844370699715572},{"$f":"P40*'Rate of change'!P28","v":4.055556710090233},{"$f":"Q40*'Rate of change'!Q28","v":4.138234490337501},{"$f":"R40*'Rate of change'!R28","v":4.2260011167003633},{"$f":"S40*'Rate of change'!S28","v":4.3139144628122512},null,{"$f":"SUM(O45:S45)","v":20.718143849911904}]
[]
[null,null,"$real 2017/18",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 ",null,null,"Real FY18","Year-end",null,null,null,null,null,null,{"$f":"$M$26","v":4.01},{"$f":"$M$26","v":4.01},{"$f":"$M$26","v":4.01},4.01,4.01,4.01,null,{"$f":"SUM(O48:S48)","v":20.049999999999997}]
[null,null,"Real price growth",null,null,"Real FY18","Year-end",null,null,null,null,null,null,{"$f":"'Rate of change'!N116","v":3.7814172862971063E-3},{"$f":"'Rate of change'!O116","v":-3.572819409375779E-3},{"$f":"'Rate of change'!P116","v":-5.6534164363827638E-3},{"$f":"'Rate of change'!Q116","v":2.1705165362934081E-3},{"$f":"'Rate of change'!R116","v":1.3271209545176207E-2},{"$f":"'Rate of change'!S116","v":2.2859040504562403E-2},null,{"$f":"SUM(O49:S49)","v":2.9074530740273476E-2}]
[null,null,"Output growth",null,null,"Real FY18","Year-end",null,null,null,null,null,null,{"$f":"'Rate of change'!N117","v":-2.5888772568502642E-2},{"$f":"'Rate of change'!O117","v":-5.1588866376265398E-2},{"$f":"'Rate of change'!P117","v":-7.7098158615614393E-2},{"$f":"'Rate of change'!Q117","v":-0.10259932190933807},{"$f":"'Rate of change'!R117","v":-0.12816080286458872},{"$f":"'Rate of change'!S117","v":-0.15369782538500196},null,-0.51314497515080859]
[null,null,"Productivity growth",null,null,"Real FY18","Year-end",null,null,null,null,null,null,{"$f":"'Rate of change'!N118","v":0},{"$f":"'Rate of change'!O118","v":0},{"$f":"'Rate of change'!P118","v":0},{"$f":"'Rate of change'!Q118","v":0},{"$f":"'Rate of change'!R118","v":0},{"$f":"'Rate of change'!S118","v":0},null,0]
[null,null,"Step changes",null,null,"Real FY18","Year-end",null,null,null,null,null,null,{"$f":"N37","v":0},0,0,0,0,0,null,0]
[null,null,"Total metering opex ",null,null,"Real FY18","Year-end",null,null,null,null,null,null,{"$f":"SUM(N48:N52)","v":3.9878926447177943},3.9548383142143582,3.9272484249480026,3.9095711946269551,3.8951104066805873,3.8791612151195607,null,{"$f":"SUM(O53:S53)","v":19.565929555589463}]
[null,null,"Total metering opex ",null,null,"Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N53*(1+'Rate of change'!$N$16)","v":4.0676504976121501},{"$f":"O53*(1+'Rate of change'!$N$16)","v":4.0339350804986456},{"$f":"P53*(1+'Rate of change'!$N$16)","v":4.0057933934469627},{"$f":"Q53*(1+'Rate of change'!$N$16)","v":3.9877626185194943},{"$f":"R53*(1+'Rate of change'!$N$16)","v":3.9730126148141989},{"$f":"S53*(1+'Rate of change'!$N$16)","v":3.9567444394219518},null,{"$f":"SUM(O54:S54)","v":19.957248146701254}]
[]
[null,null,"$real 2017/18",null,null,null,null,null,null,null,null,null,null,"FY16","FY17","FY18","FY19","FY20","FY21",null,"Total"]
[null,null,"Base opex ",null,null,"Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N48*(1+'Rate of change'!$N$16)","v":4.0902000000000003},{"$f":"O48*(1+'Rate of change'!$N$16)","v":4.0902000000000003},{"$f":"P48*(1+'Rate of change'!$N$16)","v":4.0902000000000003},{"$f":"Q48*(1+'Rate of change'!$N$16)","v":4.0902000000000003},{"$f":"R48*(1+'Rate of change'!$N$16)","v":4.0902000000000003},{"$f":"S48*(1+'Rate of change'!$N$16)","v":4.0902000000000003},null,{"$f":"SUM(O57:S57)","v":20.451000000000001}]
[null,null,"Real price growth",null,null,"Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N49*(1+'Rate of change'!$N$16)","v":3.8570456320230484E-3},{"$f":"O49*(1+'Rate of change'!$N$16)","v":-3.6442757975632947E-3},{"$f":"P49*(1+'Rate of change'!$N$16)","v":-5.7664847651104191E-3},{"$f":"Q49*(1+'Rate of change'!$N$16)","v":2.2139268670192764E-3},{"$f":"R49*(1+'Rate of change'!$N$16)","v":1.3536633736079731E-2},{"$f":"S49*(1+'Rate of change'!$N$16)","v":2.3316221314653652E-2},null,2.9656021355078947E-2]
[null,null,"Output growth",null,null,"Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N50*(1+'Rate of change'!$N$16)","v":-2.6406548019872696E-2},{"$f":"O50*(1+'Rate of change'!$N$16)","v":-5.2620643703790708E-2},{"$f":"P50*(1+'Rate of change'!$N$16)","v":-7.8640121787926676E-2},{"$f":"Q50*(1+'Rate of change'!$N$16)","v":-0.10465130834752483},{"$f":"R50*(1+'Rate of change'!$N$16)","v":-0.13072401892188051},{"$f":"S50*(1+'Rate of change'!$N$16)","v":-0.15677178189270199},null,-0.52340787465382477]
[null,null,"Productivity growth",null,null,"Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N51*(1+'Rate of change'!$N$16)","v":0},{"$f":"O51*(1+'Rate of change'!$N$16)","v":0},{"$f":"P51*(1+'Rate of change'!$N$16)","v":0},{"$f":"Q51*(1+'Rate of change'!$N$16)","v":0},{"$f":"R51*(1+'Rate of change'!$N$16)","v":0},{"$f":"S51*(1+'Rate of change'!$N$16)","v":0},null,0]
[null,null,"Step changes",null,null,"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,"Total metering opex ",null,null,"Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N53*(1+'Rate of change'!$N$16)","v":4.0676504976121501},{"$f":"O53*(1+'Rate of change'!$N$16)","v":4.0339350804986456},{"$f":"P53*(1+'Rate of change'!$N$16)","v":4.0057933934469627},{"$f":"Q53*(1+'Rate of change'!$N$16)","v":3.9877626185194943},{"$f":"R53*(1+'Rate of change'!$N$16)","v":3.9730126148141989},{"$f":"S53*(1+'Rate of change'!$N$16)","v":3.9567444394219518},null,19.957248146701254]

{"sheet":"Rate of change","index":1,"n_rows":119,"n_cols":20,"rows_kept":119,"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,"Metering 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","Basis",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",null,"Per cent",null,null,null,null,{"$f":"'[22]Rate of change'!J$36","v":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":4.5169266829245824E-3},{"$f":"'ACT labour price forecast'!J30/100","v":1.5795591783929197E-3},{"$f":"'ACT labour price forecast'!K30/100","v":-3.0648708947534687E-3},{"$f":"'ACT labour price forecast'!L30/100","v":-8.7263027295478854E-4},{"$f":"'ACT labour price forecast'!M30/100","v":3.282254415082697E-3},{"$f":"'ACT labour price forecast'!N30/100","v":4.6142730449118211E-3},{"$f":"'ACT labour price forecast'!O30/100","v":3.9336564519746545E-3}]
[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.0015795591783929},0.99850984713868707,0.99763851721823038,1.0009130206460266,1.005531506617495,1.0094869221161649]
[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.0009429968295005,0.9991103787417962,0.99859019477928357,1.0005450733256778,1.0033023094506446,1.0056636925033504]
[]
[]
[]
[null,"Opex productivity and output growth"]
[]
[null,null,"Partial factor productivity","Source","Unit","Basis",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","n/a",null,null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,"Per cent"]
[null,null,null,null,"Per cent"]
[]
[]
[null,null,"Output growth factor weights"]
[]
[null,null,"BY variable costs",null,"Per cent",null,null,null,0.64237186733939744]
[]
[]
[]
[null,null,null,"Source","Unit","Basis",null,null,null,null,null,null,{"$f":"\"FY\"&RIGHT(M$5,2)","v":"FY18"},"FY19","FY20","FY21","FY22","FY23","FY24"]
[null,"meter numbers"]
[null,null,"Forecasts"]
[null,null,"meter numbers","Demand model","Number","n/a",null,null,null,null,0.01,205715,205715,{"$f":"M75*(1-$K$75)","v":203657.85},{"$f":"N75*(1-$K$75)","v":201621.2715},199605.058785,197609.00819714999,195632.9181151785,193676.58893402672]
[null,null,"Incremental meter numbers","Calculated","Number","n/a",null,null,null,null,null,null,{"$f":"M75-L75","v":0},{"$f":"N75-M75","v":-2057.1499999999942},{"$f":"O75-N75","v":-2036.5785000000033},{"$f":"P75-O75","v":-2016.2127150000015},{"$f":"Q75-P75","v":-1996.0505878500117},{"$f":"R75-Q75","v":-1976.090081971488},{"$f":"S75-R75","v":-1956.3291811517847}]
[null,null,"Meter growth rate",null,null,null,null,null,null,null,null,null,{"$f":"M75/L75-1","v":0},{"$f":"N75/M75-1","v":-1.0000000000000009E-2},{"$f":"O75/N75-1","v":-1.0000000000000009E-2},{"$f":"P75/O75-1","v":-1.0000000000000009E-2},{"$f":"Q75/P75-1","v":-1.0000000000000009E-2},{"$f":"R75/Q75-1","v":-9.9999999999998979E-3},{"$f":"S75/R75-1","v":-1.0000000000000009E-2}]
[]
[]
[]
[null,null,"Output growth rates"]
[null,null,"Meter numbers ","Calculated","Per cent","n/a",null,null,null,null,null,null,{"$f":"LN(M75)-LN(L75)","v":0},-1.0050335853501124E-2,-1.0050335853502901E-2,-1.0050335853501124E-2,-1.0050335853501124E-2,-1.0050335853501124E-2,-1.0050335853501124E-2]
[]
[null,null,"Output growth","Calculated","Per cent","n/a",null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(N82:N82,$I$68)","v":-6.4560530096016144E-3},{"$f":"SUMPRODUCT(O82:O82,$I$68)","v":-6.456053009602755E-3},-6.4560530096016144E-3,-6.4560530096016144E-3,-6.4560530096016144E-3,-6.4560530096016144E-3]
[]
[]
[]
[null,null,"Output growth ($)","Calculated","Dollars","n/a"]
[]
[null,null,"Rate of change"]
[null,null,"Real price change",null,"Per cent","n/a",null,null,null,null,null,null,null,{"$f":"N53-M53/1","v":9.4299682950049757E-4},-1.8326180877042964E-3,-5.2018396251263255E-4,1.9548785463942009E-3,2.7572361249668109E-3,2.3613830527058344E-3]
[null,null,"Output growth",null,"Per cent","n/a",null,null,null,null,null,null,null,{"$f":"N84","v":-6.4560530096016144E-3},{"$f":"O84","v":-6.456053009602755E-3},-6.4560530096016144E-3,-6.4560530096016144E-3,-6.4560530096016144E-3,-6.4560530096016144E-3]
[null,null,"Productivity growth",null,"Per cent","n/a",null,null,null,null,null,null,null,{"$f":"M61","v":0},0,0,0,0,0]
[null,null,"Rate of change","Calculated","Per cent","n/a",null,null,null,null,null,null,null,{"$f":"N91+N92-N93","v":-5.5130561801011169E-3},{"$f":"O91+O92-O93","v":-8.2886710973070522E-3},-6.976236972114247E-3,-4.5011744632074135E-3,-3.6988168846348035E-3,-4.0946699568957801E-3]
[]
[]
[null,"Rate of change workings"]
[]
[]
[]
[null,null,"Rate of change component",null,null,null,null,null,null,null,null,null,"FY18","FY19","FY20","FY21","FY22","FY23","FY24"]
[null,null,"Real input cost escalation",null,null,null,null,null,null,null,null,null,{"$f":"'Metering opex forecast '!$M$26","v":4.01},{"$f":"M102*(1+N91)","v":4.0137814172862969},{"$f":"N102*(1+O91)","v":4.0064256888608867},{"$f":"O102*(1+P91)","v":4.0043416104705427},{"$f":"P102*(1+Q91)","v":4.0121696119772858},4.0232321109709233,{"$f":"R102*(1+S91)","v":4.0327325030948717},{"$f":"SUM(O102:S102)","v":20.078901525374512}]
[null,null,"Output growth",null,null,null,null,null,null,null,null,null,{"$f":"'Metering opex forecast '!$M$26","v":4.01},{"$f":"M103*(1+N92)","v":3.9841112274314971},{"$f":"N103*(1+O92)","v":3.9583895941510461},3.9328340210985515,3.9074434361803747,3.8822167742243745,3.8571529769352173,19.538036802589563]
[null,null,"Opex partial factor productivity",null,null,null,null,null,null,null,null,null,{"$f":"'Metering opex forecast '!$M$26","v":4.01},{"$f":"M104*(1+N93)","v":4.01},{"$f":"N104*(1+O93)","v":4.01},4.01,4.01,4.01,4.01,20.049999999999997]
[null,null,"Rate of change",null,null,null,null,null,null,null,null,null,{"$f":"'Metering opex forecast '!$M$26","v":4.01},{"$f":"M105*(1+N94)","v":3.9878926447177943},{"$f":"N105*(1+O94)","v":3.9548383142143586},{"$f":"O105*(1+P94)","v":3.9272484249480026},{"$f":"P105*(1+Q94)","v":3.9095711946269551},{"$f":"Q105*(1+R94)","v":3.8951104066805873},{"$f":"R105*(1+S94)","v":3.8791612151195602},19.565929555589463]
[]
[null,null,"Real input cost escalation",null,null,null,null,null,null,null,null,null,null,{"$f":"N102-$M102","v":3.7814172862971063E-3},{"$f":"O102-$M102","v":-3.5743111391131066E-3},{"$f":"P102-$M102","v":-5.6583895294570752E-3},2.1696119772860456E-3,1.3232110970923472E-2,2.2732503094871959E-2,{"$f":"SUM(O107:S107)","v":2.8901525374511294E-2}]
[null,null,"Output growth",null,null,null,null,null,null,null,null,null,null,{"$f":"N103-$M103","v":-2.5888772568502638E-2},-5.1610405848953711E-2,{"$f":"P103-$M103","v":-7.7165978901448273E-2},-0.10255656381962508,-0.12778322577562529,-0.15284702306478248,-0.51196319741043483]
[null,null,"Opex partial factor productivity",null,null,null,null,null,null,null,null,null,null,{"$f":"N104-$M104","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(N107:N109)","v":-2.2107355282205532E-2},{"$f":"SUM(O107:O109)","v":-5.5184716988066818E-2},-8.2824368430905349E-2,-0.10038695184233903,-0.11455111480470181,-0.13011451996991052,{"$f":"SUM(O110:S110)","v":-0.48306167203592354}]
[]
[null,null,"Rate of change - multiplicative",null,null,null,null,null,null,null,null,null,null,{"$f":"N105-$M$105","v":-2.2107355282205532E-2},{"$f":"O105-$M$105","v":-5.5161685785641179E-2},{"$f":"P105-$M$105","v":-8.275157505199715E-2},-0.10042880537304466,-0.11488959331941251,-0.13083878488043954,{"$f":"SUM(O112:S112)","v":-0.48407044441053504}]
[]
[]
[]
[null,null,"Real input cost escalation",null,null,null,null,null,null,null,null,null,null,{"$f":"N107/N$110*N$112","v":3.7814172862971063E-3},-3.572819409375779E-3,-5.6534164363827638E-3,{"$f":"Q107/Q$110*Q$112","v":2.1705165362934081E-3},1.3271209545176207E-2,2.2859040504562403E-2,{"$f":"SUM(O116:S116)","v":2.9074530740273476E-2}]
[null,null,"Output growth",null,null,null,null,null,null,null,null,null,null,-2.5888772568502642E-2,-5.1588866376265398E-2,-7.7098158615614393E-2,-0.10259932190933807,-0.12816080286458872,-0.15369782538500196,{"$f":"SUM(O117:S117)","v":-0.51314497515080859}]
[null,null,"Opex partial factor productivity",null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,{"$f":"SUM(O118:S118)","v":0}]
[null,null,"Rate of change - additive",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N116:N118)","v":-2.2107355282205535E-2},-5.5161685785641179E-2,{"$f":"SUM(P116:P118)","v":-8.275157505199715E-2},-0.10042880537304466,-0.11488959331941252,-0.13083878488043954,{"$f":"SUM(O119:S119)","v":-0.48407044441053504}]

{"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.4137689770688642,2.399924292935407,2.1935129105246531,2.4127369727045211,2.8282254415082697,2.9614273044911821,2.8933656451974654,{"$f":"AVERAGE(K13:O13)","v":2.6578536548852183},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,{"$f":"I13-I22","v":0.45169266829245824},0.15795591783929197,{"$f":"K13-K22","v":-0.30648708947534686},-8.7263027295478857E-2,0.32822544150826971,0.46142730449118208,0.39336564519746542,0.3194065989174284]
[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. "]