{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Notes","Tables_charts","Index Tables","Rate of change","Metering opex forecast ","Base opex output"],"not_rendered":{"charts":1,"images":1,"macros":0,"external_links":10,"defined_names":697,"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":"Notes","index":0,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Add table and charts tabs"]
[]
[]
["Check input categories with CW for BY and step changes"]
["check $ terms of standard control inputs"]
["Duplicate for ACS"]
["Split between Dist and Trans - confirm once receive final RIN"]
["Forecast by category"]
[]
[]
["update output detail labour split to benchmark"]
["DMIS to be removed for opex output"]
["escalate output detailed to June18 $"]

{"sheet":"Tables_charts","index":1,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[null,"$millions, 2018/19",{"$f":"'Metering opex forecast '!N50","v":"FY19"},{"$f":"'Metering opex forecast '!O50","v":"FY20"},{"$f":"'Metering opex forecast '!P50","v":"FY21"},{"$f":"'Metering opex forecast '!Q50","v":"FY22"},{"$f":"'Metering opex forecast '!R50","v":"FY23"},{"$f":"'Metering opex forecast '!S50","v":"FY24"},"Total"]
[null,{"$f":"'Metering opex forecast '!C51","v":"Base opex "},{"$f":"'Metering opex forecast '!N51*(1+'Rate of change'!$N$16)","v":4.0282187289570874},{"$f":"'Metering opex forecast '!O51*(1+'Rate of change'!$N$16)","v":4.0282187289570874},{"$f":"'Metering opex forecast '!P51*(1+'Rate of change'!$N$16)","v":4.0282187289570874},{"$f":"'Metering opex forecast '!Q51*(1+'Rate of change'!$N$16)","v":4.0282187289570874},{"$f":"'Metering opex forecast '!R51*(1+'Rate of change'!$N$16)","v":4.0282187289570874},{"$f":"'Metering opex forecast '!S51*(1+'Rate of change'!$N$16)","v":4.0282187289570874},{"$f":"SUM(D3:H3)","v":20.141093644785435}]
[null,{"$f":"'Metering opex forecast '!C52","v":"Real price growth"},{"$f":"'Metering opex forecast '!N52*(1+'Rate of change'!$N$16)","v":9.0724840868553064E-3},{"$f":"'Metering opex forecast '!O52*(1+'Rate of change'!$N$16)","v":1.4584644014365655E-2},{"$f":"'Metering opex forecast '!P52*(1+'Rate of change'!$N$16)","v":2.7543195452648474E-2},{"$f":"'Metering opex forecast '!Q52*(1+'Rate of change'!$N$16)","v":5.1188090004999673E-2},{"$f":"'Metering opex forecast '!R52*(1+'Rate of change'!$N$16)","v":7.8415883993199001E-2},{"$f":"'Metering opex forecast '!S52*(1+'Rate of change'!$N$16)","v":0.10734289611675402},{"$f":"SUM(D4:H4)","v":0.27907470958196684}]
[null,{"$f":"'Metering opex forecast '!C53","v":"Output growth"},{"$f":"'Metering opex forecast '!N53*(1+'Rate of change'!$N$16)","v":-2.1840272061751796E-2},{"$f":"'Metering opex forecast '!O53*(1+'Rate of change'!$N$16)","v":-4.3680421375968843E-2},{"$f":"'Metering opex forecast '!P53*(1+'Rate of change'!$N$16)","v":-6.5674710817373236E-2},{"$f":"'Metering opex forecast '!Q53*(1+'Rate of change'!$N$16)","v":-8.8570032082781178E-2},{"$f":"'Metering opex forecast '!R53*(1+'Rate of change'!$N$16)","v":-0.11324627563169477},{"$f":"'Metering opex forecast '!S53*(1+'Rate of change'!$N$16)","v":-0.1404851900776409},-0.45165662998545897]
[null,{"$f":"'Metering opex forecast '!C54","v":"Productivity growth"},{"$f":"'Metering opex forecast '!N54*(1+'Rate of change'!$N$16)","v":0},{"$f":"'Metering opex forecast '!O54*(1+'Rate of change'!$N$16)","v":0},{"$f":"'Metering opex forecast '!P54*(1+'Rate of change'!$N$16)","v":0},{"$f":"'Metering opex forecast '!Q54*(1+'Rate of change'!$N$16)","v":0},{"$f":"'Metering opex forecast '!R54*(1+'Rate of change'!$N$16)","v":0},{"$f":"'Metering opex forecast '!S54*(1+'Rate of change'!$N$16)","v":0},0]
[null,{"$f":"'Metering opex forecast '!C55","v":"Step changes"},{"$f":"'Metering opex forecast '!N55*(1+'Rate of change'!$N$16)","v":0},{"$f":"'Metering opex forecast '!O55*(1+'Rate of change'!$N$16)","v":0},{"$f":"'Metering opex forecast '!P55*(1+'Rate of change'!$N$16)","v":0},{"$f":"'Metering opex forecast '!Q55*(1+'Rate of change'!$N$16)","v":0},{"$f":"'Metering opex forecast '!R55*(1+'Rate of change'!$N$16)","v":0},{"$f":"'Metering opex forecast '!S55*(1+'Rate of change'!$N$16)","v":0},0]
[null,{"$f":"'Metering opex forecast '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Metering opex forecast '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Metering opex forecast '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Metering opex forecast '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Metering opex forecast '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Metering opex forecast '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Metering opex forecast '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,{"$f":"'Metering opex forecast '!C56","v":"Total"},{"$f":"SUM(C3:C8)","v":{"$error":"#REF!"}},{"$f":"SUM(D3:D8)","v":{"$error":"#REF!"}},{"$f":"SUM(E3:E8)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Maintenance as % of total in BY"]

{"sheet":"Index Tables","index":2,"n_rows":51,"n_cols":19,"rows_kept":51,"cut":false,"hidden":false,"merged":[[2,10,2,18],[2,6,2,9]]}
[]
[]
["Inflation",null,null,null,null,null,"Australian Bureau of Statistics (ABS) Data",null,null,null,"Forecast"]
[null,"FY09","FY10","FY11","FY12","FY13","FY14","FY15","FY16","FY17","FY18","FY19","FY20","FY21","FY22","FY23","FY24","FY25","FY26"]
["Inflation rate",4.3499999999999997E-2,1.77E-2,2.92E-2,3.3000000000000002E-2,1.7600000000000001E-2,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,2.4500000000000001E-2,2.4500000000000001E-2]
[]
["CPI indices (real mid year to nominal)"]
[]
["Real 2009",1,{"$f":"B9*(1+B$5)","v":1.0435000000000001},1.0619699500000002,1.0929794725400002,1.12904779513382,1.1489190363281754,1.183565427501496,1.2014474358490161,1.2137413165879363,{"$f":"J9*(1+K$5)","v":1.2389590675197544},{"$f":"K9*(1+L$5)","v":1.2668356465389488},{"$f":"L9*(1+M$5)","v":1.2978725010046539},{"$f":"M9*(1+N$5)","v":1.3296697432426459},{"$f":"N9*(1+O$5)","v":1.3622460023818812},{"$f":"O9*(1+P$5)","v":1.3956203639558749},{"$f":"P9*(1+Q$5)","v":1.4298123810843897},{"$f":"Q9*(1+R$5)","v":1.4648427844209573},{"$f":"R9*(1+S$5)","v":1.5007314326392707}]
["Real 2010",{"$f":"C10/(1+B$5)","v":0.95831336847149007},1,{"$f":"C10*(1+C$5)","v":1.0177},1.0474168399999999,1.0819815957199999,1.101024471804672,1.1342265716353577,1.1513631392899051,1.1631445295524063,{"$f":"J10*(1+K$5)","v":1.1873110373931519},1.2140255357344978,1.2437685682842869,1.2742402906014809,1.3054585552294016,1.337441652089961,1.3702083191992229,1.4037784230196038,1.4381709943835841]
["Real 2011",0.941646230197003,{"$f":"D11/(1+C$5)","v":0.98260784121057276},1,{"$f":"D11*(1+D$5)","v":1.0291999999999999},1.0631635999999998,1.0818752793599997,1.1144999229982877,1.1313384487470814,1.142914935199377,1.1666611352983705,1.1929110108425838,1.2221367478473879,1.2520785011314539,1.2827538127438354,1.3141806545052181,1.3463774385371154,1.3793636857812748,1.413158096082916]
["Real 2012",0.91493026641760888,0.95472973300677499,{"$f":"E12/(1+D$5)","v":0.97162844928099501},1,{"$f":"E12*(1+E$5)","v":1.0329999999999999},{"$f":"F12*(1+F$5)","v":1.0511808},{"$f":"G12*(1+G$5)","v":1.0828798319066149},{"$f":"H12*(1+H$5)","v":1.0992406225680933},{"$f":"I12*(1+I$5)","v":1.1104886661478597},1.1335611497263609,1.1590662755952039,1.1874628331202759,1.2165550924324271,1.2463600978855767,1.2768953114119883,1.3081786227527357,1.3402289990101777,1.3730646094859269]
["Real 2013",0.8857020972096894,0.92423013843831092,0.94058901188866906,{"$f":"F13/(1+E$5)","v":0.96805421103581812},1,{"$f":"F13*(1+F$5)","v":1.0176000000000001},{"$f":"G13*(1+G$5)","v":1.0482863813229575},{"$f":"H13*(1+H$5)","v":1.0641245136186772},{"$f":"I13*(1+I$5)","v":1.0750132295719845},1.0973486444592073,1.1220389889595395,{"$f":"L13*(1+M$5)","v":1.1495283960506064},1.1776912801862804,1.2065441412251474,1.2361038832642681,1.2663878245428233,1.2974143262441225,1.3292009772371034]
["Real 2014",0.87038335024537072,0.9082450259810444,0.92432096294090893,0.9513111350587834,{"$f":"G14/(1+F$5)","v":0.98270440251572322},1,{"$f":"G14*(1+G$5)","v":1.0301556420233464},{"$f":"H14*(1+H$5)","v":1.0457198443579767},{"$f":"I14*(1+I$5)","v":1.056420233463035},1.0783693440047242,1.1026326542448304,1.1296466156157687,1.1573224058434357,1.1856762394115046,1.2147247280505775,1.2444848904705412,1.2749747702870695,1.3062116521591027]
["Real 2015",0.84490470637605386,0.88165806110341227,0.89726340878494271,0.92346350032146296,0.95393779583207117,{"$f":"H15/(1+G$5)","v":0.97072710103871562},1,{"$f":"H15*(1+H$5)","v":1.0151085930122756},{"$f":"I15*(1+I$5)","v":1.0254957507082152},1.0468023471547274,1.0703553999657087,1.0965785843748916,1.1234442239915505,1.1509680586544164,1.1791662138205798,1.2080552100129527,1.23765256265827,1.2679750504433975]
["Real 2016",0.83232938051371264,0.86853570856605922,0.88390879060767846,0.90971892729342263,0.93973965189410547,{"$f":"H16/(1+G$5)","v":0.95627906976744181},{"$f":"I16/(1+H$5)","v":0.98511627906976751},1,{"$f":"I16*(1+I$5)","v":1.0102325581395348},1.0312220331505642,1.0544245288964518,1.0802574147469863,1.1067231936809787,1.1338373712697924,1.1616158329637152,1.1900748533988061,1.2192316873070768,1.2491028636461001]
["Real 2017",0.82389878826173235,0.85973838555111781,0.87495575497537259,0.90050446302065335,0.93022111030033483,{"$f":"H17/(1+G$5)","v":0.94659300184162076},{"$f":"I17/(1+H$5)","v":0.97513812154696156},{"$f":"J17/(1+I$5)","v":0.98987108655616951},1,1.0207768744354111,1.0437443541102078,1.069315580895958,1.0955132902459044,1.1223528306768205,1.1498499267366429,1.1780206882170505,1.2068821950783681,1.2364508088577881]
["Real 2018",0.80712916690773229,0.84223928566821871,0.85714692102454626,0.88217561111846288,0.91128740628537208,{"$f":"H18/(1+G$5)","v":0.92732606463599465},{"$f":"I18/(1+H$5)","v":0.95529017748007627},{"$f":"J18/(1+I$5)","v":0.96972326798024733},{"$f":"K18/(1+K$5)","v":0.97964601769911497},1,1.0225,1.047550750488341,1.0732152321258548,1.0995084810258762,1.126445901679171,1.154043275979004,1.1823173362404895,1.2112841109783814]
["Real 2019",0.7893683783938702,0.82370590285400358,0.83828549733451951,0.86276343385668741,0.89123462717395807,{"$f":"H19/(1+G$5)","v":0.90692035661221981},{"$f":"I19/(1+H$5)","v":0.93426912222990355},{"$f":"J19/(1+I$5)","v":0.94838461416161113},{"$f":"K19/(1+K$5)","v":0.95808901486466014},{"$f":"L19/(1+L$5)","v":0.97799511002444994},1,1.0244995114800401,{"$f":"M19*(1+N$5)","v":1.049599249022841},{"$f":"N19*(1+O$5)","v":1.0753139178737177},{"$f":"O19*(1+P$5)","v":1.1016585835493118},{"$f":"P19*(1+Q$5)","v":1.128648680664063},{"$f":"Q19*(1+R$5)","v":1.1563005733403324},{"$f":"R19*(1+S$5)","v":1.1846299373871705}]
["Nominal",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[]
["CPI indices (nominal to real mid year)"]
[]
["Real 2009",{"$f":"1/B$9","v":1},{"$f":"1/C$9","v":0.95831336847149007},{"$f":"1/D$9","v":0.94164623019700311},0.91493026641760888,0.88570209720968929,0.87038335024537061,0.84490470637605375,0.83232938051371252,0.82389878826173202,0.80712916690773218,0.78936837839387008,0.77049170794968114,0.75206644738814232,0.73408180185627581,0.71652723464532142,0.69939246101756791,0.68266711665941227,0.66634174393305257]
["Real 2010",{"$f":"1/B$9","v":1},{"$f":"1/C$10","v":1},0.98260784121057276,0.95472973300677511,0.92423013843831092,0.9082450259810444,0.88165806110341227,0.86853570856605922,0.85973838555111759,0.84223928566821871,0.82370590285400369,0.80400809724549249,0.78478133784952675,0.76601436023702418,0.74769616935239314,0.7298160330718324,0.71236313623409708,0.69532760979414066]
["Real 2011",{"$f":"1/B$11","v":1.0619699500000002},{"$f":"1/C$11","v":1.0177},{"$f":"1/D$11","v":1},0.97162844928099501,0.94058901188866906,0.92432096294090915,0.89726340878494293,0.88390879060767868,0.87495575497537259,0.85714692102454637,0.83828549733451974,0.81823904056673791,0.79867196752946357,0.77957281441321968,0.76093039154993081,0.7427337768572041,0.72497196374544082,0.70763490848749722]
["Real 2012",{"$f":"1/B$12","v":1.0929794725400002},{"$f":"1/C$12","v":1.0474168400000001},{"$f":"1/D$12","v":1.0291999999999999},1,0.96805421103581812,0.9513111350587834,0.92346350032146296,0.90971892729342274,0.90050446302065335,0.88217561111846299,0.86276343385668763,0.84213162055128665,0.8219931889813239,0.80233634059408565,0.78314955898318872,0.76442160314143448,0.74614114508680773,0.72829784781533213]
["Real 2013",{"$f":"1/B$13","v":1.1290477951338198},{"$f":"1/C$13","v":1.0819815957199999},{"$f":"1/D$13","v":1.0631635999999998},1.0329999999999999,1,0.98270440251572322,0.95393779583207106,0.93973965189410547,0.93022111030033461,0.91128740628537208,0.89123462717395807,0.86992196402947874,0.84911896421770716,0.82881343983369005,0.80899349442963342,0.78964751604510131,0.77076380287467183,0.75233167679323754]
["Real 2014",{"$f":"1/B$14","v":1.1489190363281754},{"$f":"1/C$14","v":1.101024471804672},{"$f":"1/D$14","v":1.0818752793599999},1.0511808,1.0176000000000001,1,0.97072710103871562,0.95627906976744181,0.94659300184162065,0.92732606463599465,0.90692035661221981,0.88523259059639769,0.86406345798793904,0.8434005563747633,0.82323177993159535,0.80354531232749549,0.78432924580526642,0.76557271430479878]
["Real 2015",{"$f":"1/B$15","v":1.1835654275014957},{"$f":"1/C$15","v":1.1342265716353577},{"$f":"1/D$15","v":1.1144999229982879},1.0828798319066149,1.0482863813229573,1.0301556420233464,1,0.98511627906976751,0.97513812154696144,0.95529017748007627,0.93426912222990355,0.91192734770582207,0.89011984631247798,0.86883384163509159,0.84805686278945447,0.82777673711558108,0.80798119777021093,0.78865905102021572]
["Real 2016",{"$f":"1/B$16","v":1.2014474358490159},{"$f":"1/C$16","v":1.1513631392899051},{"$f":"1/D$16","v":1.1313384487470817},1.0992406225680935,1.0641245136186772,1.0457198443579767,{"$f":"1/H$16","v":1.0151085930122756},1,0.98987108655616951,0.96972326798024733,0.94838461416161113,0.92570528685907338,0.90356830480256256,0.88196069854364822,0.86086980878060781,0.84028327894169008,0.82018865684889231,0.80057457964752787]
["Real 2017",{"$f":"1/B$17","v":1.2137413165879358},{"$f":"1/C$17","v":1.1631445295524061},{"$f":"1/D$17","v":1.142914935199377},1.1104886661478597,1.0750132295719843,1.0564202334630348,1.025495750708215,1.0102325581395348,1,0.97964601769911497,0.95808901486466014,0.93517762002693361,0.91281412001449569,0.8909854126682808,0.8696787091495255,0.84888152644713977,0.82858128496548544,0.80876650557880481]
["Real 2018",{"$f":"1/B$18","v":1.2389590675197542},{"$f":"1/C$18","v":1.1873110373931519},{"$f":"1/D$18","v":1.1666611352983707},1.1335611497263611,1.0973486444592073,1.0783693440047242,1.0468023471547274,1.0312220331505642,{"$f":"1/J$18","v":1.0207768744354111},1,0.97799511002444994,0.95460768801303986,0.9317795443689072,0.90949730471107271,0.88774791448867574,0.86651863133267226,0.84579661428274511,0.82557014571278209]
["Real 2019",{"$f":"1/B$19","v":1.2668356465389485},1.214025535734498,1.192911010842584,1.1590662755952041,1.1220389889595395,1.1026326542448304,1.0703553999657087,1.0544245288964518,1.0437443541102078,{"$f":"1/K$19","v":1.0225},1,{"$f":"1/M$19","v":0.97608636099333324},{"$f":"1/N$19","v":0.95274458411720753},0.92996099406707178,0.90772224256467071,0.8860153005376572,0.86482703810410666,0.84414547399131934]
["Nominal",{"$f":"1/B$20","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[]
[]
["CPI indices (nominal mid year to real end year)"]
[]
["Real 2009",{"$f":"1/(1+B$5)^0.5","v":0.97893481318803355},{"$f":"B40*(1+B$5)^(1-0.5)*(1+C$5)^0.5","v":1.0088111815399352},{"$f":"C40*(1+C$5)^(1-0.5)*(1+D$5)^0.5","v":1.0324515088216009},{"$f":"D40*(1+D$5)^(1-0.5)*(1+E$5)^0.5","v":1.0645589433785243},1.0914615040989717,1.1175022201059128,1.1427627339846675,1.1572388418098221,1.1743365560343941,1.1978898619991896,1.2238098913971165,1.2525685273535676,1.2832558443690036,1.3146949856599508,1.3469043705538781,1.3799028696427793,1.41371015289394,{"$f":"R40*(1+R$5)^(1-0.5)*(1+S$5)^0.5","v":1.4483460516398414}]
["Real 2010",{"$f":"C41/((1+C$5)^0.5*(1+B$5)^(1-0.5))","v":0.96190902347256901},{"$f":"1/(1+C$5)^0.5","v":0.9912657772820429},{"$f":"C41*(1+C$5)^(1-0.5)*(1+D$5)^0.5","v":1.0144949482377918},1.0460439651945801,{"$f":"E41*(1+E$5)^(1-0.5)*(1+F$5)^0.5","v":1.0724786323071354},1.0980664440462937,1.1228876230565668,1.1371119601157733,1.1539123081796152,1.1770559713070552,1.2025251954378668,1.2307836566311963,1.2609372549562783,1.2918296017096902,1.3234787958670327,1.3559033798199671,1.3891226814325845,1.4231561871276825]
["Real 2011",0.93461817282604842,0.96314203000587151,{"$f":"1/(1+D$5)^0.5","v":0.98571215335968898},{"$f":"D42*(1+D$5)^(1-0.5)*(1+E$5)^0.5","v":1.016366075781753},{"$f":"E42*(1+E$5)^(1-0.5)*(1+F$5)^0.5","v":1.0420507503955845},1.0669125962361969,1.0910295599072746,1.1048503304661619,1.1211740266028136,1.1436610681180095,1.1684076908646199,1.1958644156929616,1.225162509673803,1.2551783926444713,1.2859296500845632,1.3174342983093341,1.3497111168213993,1.3827790391835233]
["Real 2012",0.90476105791485806,0.93237369797277003,0.95422280092903089,{"$f":"1/(1+E$5)^0.5","v":0.98389745961447528},1.0087616170334794,1.0328292315936076,1.0561757598327921,1.0695550149720827,1.0853572377568375,1.1071259129893603,1.1310819853481313,1.157661583439459,1.1860237266929357,1.2150807286006493,1.2448496128601767,1.2753478202413684,1.3065935303208118,1.3386050718136715]
["Real 2013",0.88911267483771417,0.9162477377877063,0.9377189474538431,0.96688036518718068,{"$f":"1/(1+F$5)^0.5","v":0.99131448214768003},1.0149658329339695,1.0379085690180736,1.0510564219458356,1.0665853358459483,1.0879775088338834,1.111519246607833,1.1376391346692794,1.1655107377092526,1.1940651814078707,1.2233191950276894,1.2532899176900241,1.283995214544823,1.3154530973011709]
["Real 2014",0.86308576934199255,0.88942651033594144,0.91026919545094487,0.93857697394940676,{"$f":"G45/((1+G$5)^0.5*(1+F$5)^(1-0.5))","v":0.96229583347291314},{"$f":"1/(1+G$5)^0.5","v":0.98525484065733759},1.0075259763461564,1.0202889535036062,1.0353632910761426,1.0561292531456397,1.0789818560083593,1.1043371392257029,1.1313928596459979,1.1591114319993308,1.1875090958342442,1.2166024885602875,1.2464089523626796,1.2769459716955649]
["Real 2015",0.8491983755963568,0.87511528357772617,0.89562260158879858,0.92347489665787641,{"$f":"G46/((1+G$5)^0.5*(1+F$5)^(1-0.5))","v":0.94681211028580581},{"$f":"H46/((1+G$5)^0.5*(1+F$5)^(1-0.5))","v":0.96940169790139397},{"$f":"1/(1+H$5)^0.5","v":0.99253024088426012},1.0051032574514593,1.019953232790358,1.0404101200755649,1.0629225911747464,1.087900493432576,1.1145535240605688,1.1418595409184102,1.1698345418497345,1.1984949166375298,1.2278577493507701,1.2579402642098638]
["Real 2016",0.8416278358500644,0.86731369654305879,0.8876381933540981,0.91524218730425566,{"$f":"G47/((1+G$5)^0.5*(1+F$5)^(1-0.5))","v":0.93837135142524397},{"$f":"H47/((1+H$5)^0.5*(1+G$5)^(1-0.5))","v":0.96075955456364681},0.9824769879839591,{"$f":"1/(1+I$5)^0.5","v":0.99492265355462151},1.0096222147786693,1.029871896023234,1.0521563402512453,1.0768812434990971,1.1032643078868434,1.1302937444634358,1.1579853890317355,1.1863554653640374,1.2154208844862595,1.2451986961561727]
["Real 2017",{"$f":"C48/((1+C$5)^0.5*(1+B$5)^(1-0.5))","v":0.82566199614559199},0.8508605911885837,0.87079952843952191,0.89787986938791498,0.92057026887788185,0.94253376355566454,0.96383921314415522,0.97604878207797574,{"$f":"1/(1+J$5)^0.5","v":0.99046948983706873},1.0103350307870211,1.0321967348806256,1.0564526020235043,1.0823351746748977,1.1088518577120967,1.1360181865297783,1.1638500771321991,1.1923641197399077,1.2215770406735353]
["Real 2018",{"$f":"C49/((1+C$5)^0.5*(1+B$5)^(1-0.5))","v":0.80885648648953101},0.8335421897750106,0.8530752902500448,0.87960443841807234,0.90183299791842042,0.92334944801426599,0.94422124685892017,0.95618230244276026,0.97030949137135847,{"$f":"1/(1+K$5)^0.5","v":0.98977068945241808},{"$f":"K49*(1+K$5)^(1-0.5)*(1+L$5)^0.5","v":1.0111874208078342},1.0349495844601944,{"$f":"M49*(1+M$5)^(1-0.5)*(1+N$5)^0.5","v":1.0603053436859398},1.0862823066259217,1.1128956924676681,1.1401610932613671,1.1680947615505117,1.1967130832084991]
["Real 2019",{"$f":"C50/((1+C$5)^0.5*(1+B$5)^(1-0.5))","v":0.79105768849831914},0.81520018559903262,0.83430346234723229,0.86024883952867726,0.88198826202290515,0.90303124500172716,0.92344376220921287,0.93514161608093915,0.94895793777149973,{"$f":"L50/((1+L$5)^0.5*(1+K$5)^(1-0.5))","v":0.96799089432999319},{"$f":"1/(1+L$5)^0.5","v":0.98893635286829751},1.0121756327239064,{"$f":"M50*(1+M$5)^(1-0.5)*(1+N$5)^0.5","v":1.0369734412576428},1.0623787839862313,1.0884065452006531,1.1150719738497474,1.142390964841576,1.1703795434801945]
["Nominal",{"$f":"1/B$20","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]

{"sheet":"Rate of change","index":3,"n_rows":119,"n_cols":24,"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,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,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",null,"Per cent",null,null,null,null,{"$f":"'[8]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,"Average of EGWWS and DAE labour","External","Per cent",null,null,null,null,null,null,null,{"$f":"'[9]Wage Forecasts'!I30/100","v":5.704288097400605E-3},{"$f":"N56","v":3.7725833148056064E-3},{"$f":"O56","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,0,0,0,0,0,0,0]
[]
[null,null,"Cumulative factor"]
[null,null,{"$f":"$C$43","v":"Average of EGWWS and DAE labour"},"Calculated","Factor",null,null,null,null,null,null,null,1,{"$f":"M47*(1+N43)","v":1.0037725833148057},{"$f":"N47*(1+O43)","v":1.0060431502544238},{"$f":"O47*(1+P43)","v":1.0113402840877055},1.0207367291120852,1.0308894444330712,1.0406792969485008]
[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.0022522322389391,1.0036077607018909,1.00677014960036,1.0123798272799149,1.0184409983265434,1.0242855402782549]
[null,null,"EGWWS labour","External","Per cent",null,null,null,null,null,null,null,null,{"$f":"'[9]Wage Forecasts'!J30/100","v":7.3823666320130509E-3},{"$f":"'[9]Wage Forecasts'!K30/100","v":5.6672232726015983E-3},{"$f":"'[9]Wage Forecasts'!L30/100","v":1.1131535994233922E-2},{"$f":"'[9]Wage Forecasts'!M30/100","v":1.5481462452597078E-2},{"$f":"'[9]Wage Forecasts'!N30/100","v":1.4924737175464315E-2},{"$f":"'[9]Wage Forecasts'!O30/100","v":1.2490564634845174E-2}]
[null,null,"     DAE labour","External","Per cent",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(N54:N55)","v":3.7725833148056064E-3},{"$f":"AVERAGE(O54:O55)","v":2.2620332307940983E-3},5.2653147451400435E-3,9.2910815204557164E-3,9.9464583093992961E-3,9.4965105795739926E-3]
[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,{"$f":"'Base opex output'!K17","v":0.53946643033921871}]
[]
[]
[null,"VARIABLES BELOW TO BE UPDATED"]
[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,null,null,"from draft Jacobs forecast"]
[null,"meter numbers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016/17",{"$f":"SUM([10]Customers!B14:E14)","v":189191}]
[null,null,"Forecasts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017/18",{"$f":"SUM([10]Customers!B15:E15)","v":193508}]
[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,null,"2018/19",{"$f":"SUM([10]Customers!B16:E16)","v":196643}]
[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,null,"2019/20",{"$f":"SUM([10]Customers!B17:E17)","v":199876}]
[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,null,"2020/21",{"$f":"SUM([10]Customers!B18:E18)","v":203147}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021/22",{"$f":"SUM([10]Customers!B19:E19)","v":206414}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022/23",{"$f":"SUM([10]Customers!B20:E20)","v":209655}]
[]
[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":-5.4218188065985164E-3},{"$f":"SUMPRODUCT(O82:O82,$I$68)","v":-5.4218188065994748E-3},-5.4218188065985164E-3,-5.4218188065985164E-3,-5.4218188065985164E-3,-5.4218188065985164E-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":2.2522322389391114E-3},1.3555284629518383E-3,3.1623888984690929E-3,5.6096776795548919E-3,6.0611710466285107E-3,5.8445419517114683E-3]
[null,null,"Output growth",null,"Per cent","n/a",null,null,null,null,null,null,null,{"$f":"N84","v":-5.4218188065985164E-3},{"$f":"O84","v":-5.4218188065994748E-3},-5.4218188065985164E-3,-5.4218188065985164E-3,-5.4218188065985164E-3,-5.4218188065985164E-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":-3.169586567659405E-3},{"$f":"O91+O92-O93","v":-4.0662903436476366E-3},-2.2594299081294235E-3,1.8785887295637554E-4,6.3935224002999429E-4,4.2272314511295189E-4]
[]
[]
[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":3.9395782190289368},{"$f":"M102*(1+N91)","v":3.9484510641016559},{"$f":"N102*(1+O91)","v":3.9538033019036183},{"$f":"O102*(1+P91)","v":3.9663067655722886},{"$f":"P102*(1+Q91)","v":3.9885564681053869},4.0127317910877105,{"$f":"R102*(1+S91)","v":4.0361843703816893},{"$f":"SUM(O102:S102)","v":19.957582697050693}]
[null,null,"Output growth",null,null,null,null,null,null,null,null,null,{"$f":"'Metering opex forecast '!$M$26","v":3.9395782190289368},{"$f":"M103*(1+N92)","v":3.9182185397509399},{"$f":"N103*(1+O92)","v":3.8969746687837516},3.8758459782357018,3.854831843619424,3.8339316438334134,3.8131447611436644,19.274728895615954]
[null,null,"Opex partial factor productivity",null,null,null,null,null,null,null,null,null,{"$f":"'Metering opex forecast '!$M$26","v":3.9395782190289368},{"$f":"M104*(1+N93)","v":3.9395782190289368},{"$f":"N104*(1+O93)","v":3.9395782190289368},3.9395782190289368,3.9395782190289368,3.9395782190289368,3.9395782190289368,19.697891095144684]
[null,null,"Rate of change",null,null,null,null,null,null,null,null,null,{"$f":"'Metering opex forecast '!$M$26","v":3.9395782190289368},{"$f":"M105*(1+N94)","v":3.927091384823659},{"$f":"N105*(1+O94)","v":3.9111226910469288},{"$f":"O105*(1+P94)","v":3.9022857834644138},{"$f":"P105*(1+Q94)","v":3.9030188624736493},{"$f":"Q105*(1+R94)","v":3.9055142663262514},{"$f":"R105*(1+S94)","v":3.9071652176001965},19.529106820911441]
[]
[null,null,"Real input cost escalation",null,null,null,null,null,null,null,null,null,null,{"$f":"N102-$M102","v":8.8728450727191266E-3},{"$f":"O102-$M102","v":1.4225082874681494E-2},{"$f":"P102-$M102","v":2.6728546543351772E-2},4.8978249076450098E-2,7.3153572058773708E-2,9.6606151352752523E-2,{"$f":"SUM(O107:S107)","v":0.25969160190600959}]
[null,null,"Output growth",null,null,null,null,null,null,null,null,null,null,{"$f":"N103-$M103","v":-2.1359679277996868E-2},-4.260355024518514E-2,{"$f":"P103-$M103","v":-6.3732240793235029E-2},-8.4746375409512797E-2,-0.10564657519552334,-0.12643345788527238,-0.42316219952872869]
[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":-1.2486834205277741E-2},{"$f":"SUM(O107:O109)","v":-2.8378467370503646E-2},-3.7003694249883257E-2,-3.57681263330627E-2,-3.2493003136749632E-2,-2.9827306532519859E-2,{"$f":"SUM(O110:S110)","v":-0.16347059762271909}]
[]
[null,null,"Rate of change - multiplicative",null,null,null,null,null,null,null,null,null,null,{"$f":"N105-$M$105","v":-1.2486834205277741E-2},{"$f":"O105-$M$105","v":-2.8455527982008011E-2},{"$f":"P105-$M$105","v":-3.7292435564522997E-2},-3.6559356555287525E-2,-3.4063952702685363E-2,-3.2413001428740262E-2,{"$f":"SUM(O112:S112)","v":-0.16878427423324416}]
[]
[]
[]
[null,null,"Real input cost escalation",null,null,null,null,null,null,null,null,null,null,{"$f":"N107/N$110*N$112","v":8.8728450727191266E-3},1.4263710527496974E-2,2.6937110467137874E-2,{"$f":"Q107/Q$110*Q$112","v":5.00617017163811E-2},7.6690351093593151E-2,0.10498082749804794,{"$f":"SUM(O116:S116)","v":0.27293370130265704}]
[null,null,"Output growth",null,null,null,null,null,null,null,null,null,null,-2.1359679277996868E-2,-4.271923850950498E-2,-6.4229546031660867E-2,-8.6621058271668633E-2,-0.11075430379627851,-0.13739382892678817,{"$f":"SUM(O117:S117)","v":-0.4417179755359012}]
[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":-1.2486834205277741E-2},-2.8455527982008004E-2,{"$f":"SUM(P116:P118)","v":-3.7292435564522997E-2},-3.6559356555287532E-2,-3.4063952702685363E-2,-3.2413001428740235E-2,{"$f":"SUM(O119:S119)","v":-0.16878427423324413}]

{"sheet":"Metering opex forecast ","index":4,"n_rows":57,"n_cols":30,"rows_kept":57,"cut":false,"hidden":false,"merged":[[0,2,0,4],[1,2,1,4],[3,14,3,18]]}
[null,null,"Evoenergy Electricity Distribution Deterimation 2019-24 "]
[null,null,"Metering opex model"]
[null,null,"Forecast"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Base year","year 5","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,{"$f":"'Base opex output'!K11","v":3.8992790500000001}]
[null,"Adjustments",null,null,"$ millions","Nominal","Mid-year"]
[]
[]
[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":2.2522322389391114E-3},{"$f":"'Rate of change'!O91","v":1.3555284629518383E-3},{"$f":"'Rate of change'!P91","v":3.1623888984690929E-3},{"$f":"'Rate of change'!Q91","v":5.6096776795548919E-3},{"$f":"'Rate of change'!R91","v":6.0611710466285107E-3},{"$f":"'Rate of change'!S91","v":5.8445419517114683E-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":-5.4218188065985164E-3},{"$f":"'Rate of change'!O92","v":-5.4218188065994748E-3},{"$f":"'Rate of change'!P92","v":-5.4218188065985164E-3},{"$f":"'Rate of change'!Q92","v":-5.4218188065985164E-3},{"$f":"'Rate of change'!R92","v":-5.4218188065985164E-3},{"$f":"'Rate of change'!S92","v":-5.4218188065985164E-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":-3.169586567659405E-3},{"$f":"O20+O21-O22","v":-4.0662903436476366E-3},-2.2594299081294235E-3,1.8785887295637554E-4,6.3935224002999429E-4,4.2272314511295189E-4]
[]
[]
[null,null,"Base opex(A)","Calculated",null,"Real FY18","Year-end",null,null,null,null,null,{"$f":"SUM(M15:M16)/'Index Tables'!$K$49","v":3.9395782190289368},{"$f":"M26*(1+N$23)","v":3.927091384823659},{"$f":"N26*(1+O$23)","v":3.9111226910469288},{"$f":"O26*(1+P$23)","v":3.9022857834644138},3.9030188624736493,3.9055142663262514,3.9071652176001965,null,{"$f":"SUM(O26:S26)","v":19.529106820911441}]
[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.0282187289570874},{"$f":"N26*(1+'Rate of change'!$N$16)","v":4.0154509409821912},{"$f":"O26*(1+'Rate of change'!$N$16)","v":3.9991229515954845},{"$f":"P26*(1+'Rate of change'!$N$16)","v":3.9900872135923628},{"$f":"Q26*(1+'Rate of change'!$N$16)","v":3.9908367868793064},{"$f":"R26*(1+'Rate of change'!$N$16)","v":3.9933883373185921},{"$f":"S26*(1+'Rate of change'!$N$16)","v":3.9950764349962009},null,{"$f":"SUM(O27:S27)","v":19.968511724381948}]
[]
[]
[]
[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(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 excluding category specific forecasts (A+B)","Calculated",null,"Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N27+N38","v":4.0154509409821912},{"$f":"O27+O38","v":3.9991229515954845},3.9900872135923628,3.9908367868793064,3.9933883373185921,3.9950764349962009,null,{"$f":"SUM(O40:S40)","v":19.968511724381948}]
[]
[]
[null,null,"Total metering opex ","Calculated",null,"Real FY18","Year-end",null,null,null,null,null,null,{"$f":"N26+N37","v":3.927091384823659},{"$f":"O26+O37","v":3.9111226910469288},3.9022857834644138,3.9030188624736493,3.9055142663262514,3.9071652176001965,null,{"$f":"SUM(O43:S43)","v":19.529106820911441}]
[null,null,"Total metering opex ","Calculated",null,"Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N27+N38","v":4.0154509409821912},{"$f":"O27+O38","v":3.9991229515954845},{"$f":"P27+P38","v":3.9900872135923628},3.9908367868793064,3.9933883373185921,3.9950764349962009,null,{"$f":"SUM(O44:S44)","v":19.968511724381948}]
[null,null,"% change",null,null,null,null,null,null,null,null,null,null,{"$f":"N44/M27-1","v":-3.1695865676593105E-3},{"$f":"O44/N44-1","v":-4.0662903436476938E-3},-2.25942990812944E-3,1.8785887295647008E-4,6.3935224003008884E-4,4.2272314511304643E-4]
[]
[]
[null,null,"Total opex excluding DRC (A + B + C) ","Calculated",null,"Nominal",null,null,null,null,null,null,null,{"$f":"N44*'Rate of change'!N28","v":3.9710254086965016},{"$f":"O44*'Rate of change'!O28","v":3.9510168218862218},{"$f":"P44*'Rate of change'!P28","v":4.0386690500414186},{"$f":"Q44*'Rate of change'!Q28","v":4.1383917563878283},{"$f":"R44*'Rate of change'!R28","v":4.2424910457853242},{"$f":"S44*'Rate of change'!S28","v":4.348267340426756},null,{"$f":"SUM(O48:S48)","v":20.71883601452755}]
[]
[null,null,null,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,null,null,"FY16","FY17","FY18","FY19","FY20","FY21","Total"]
[null,null,"Base opex ",null,null,"Real FY18","Year-end",null,null,null,null,null,null,{"$f":"$M$26","v":3.9395782190289368},{"$f":"$M$26","v":3.9395782190289368},{"$f":"$M$26","v":3.9395782190289368},3.9395782190289368,3.9395782190289368,3.9395782190289368,null,{"$f":"SUM(O51:S51)","v":19.697891095144684},null,"Real FY19",{"$f":"N51*(1+'Rate of change'!$N$16)","v":4.0282187289570874},{"$f":"O51*(1+'Rate of change'!$N$16)","v":4.0282187289570874},{"$f":"P51*(1+'Rate of change'!$N$16)","v":4.0282187289570874},{"$f":"Q51*(1+'Rate of change'!$N$16)","v":4.0282187289570874},{"$f":"R51*(1+'Rate of change'!$N$16)","v":4.0282187289570874},{"$f":"S51*(1+'Rate of change'!$N$16)","v":4.0282187289570874},{"$f":"SUM(Y51:AC51)","v":20.141093644785435}]
[null,null,"Real price growth",null,null,"Real FY18","Year-end",null,null,null,null,null,null,{"$f":"'Rate of change'!N116","v":8.8728450727191266E-3},{"$f":"'Rate of change'!O116","v":1.4263710527496974E-2},{"$f":"'Rate of change'!P116","v":2.6937110467137874E-2},{"$f":"'Rate of change'!Q116","v":5.00617017163811E-2},{"$f":"'Rate of change'!R116","v":7.6690351093593151E-2},{"$f":"'Rate of change'!S116","v":0.10498082749804794},null,{"$f":"SUM(O52:S52)","v":0.27293370130265704},null,"Real FY19",{"$f":"N52*(1+'Rate of change'!$N$16)","v":9.0724840868553064E-3},{"$f":"O52*(1+'Rate of change'!$N$16)","v":1.4584644014365655E-2},{"$f":"P52*(1+'Rate of change'!$N$16)","v":2.7543195452648474E-2},{"$f":"Q52*(1+'Rate of change'!$N$16)","v":5.1188090004999673E-2},{"$f":"R52*(1+'Rate of change'!$N$16)","v":7.8415883993199001E-2},{"$f":"S52*(1+'Rate of change'!$N$16)","v":0.10734289611675402},{"$f":"SUM(Y52:AC52)","v":0.27907470958196684}]
[null,null,"Output growth",null,null,"Real FY18","Year-end",null,null,null,null,null,null,{"$f":"'Rate of change'!N117","v":-2.1359679277996868E-2},{"$f":"'Rate of change'!O117","v":-4.271923850950498E-2},{"$f":"'Rate of change'!P117","v":-6.4229546031660867E-2},{"$f":"'Rate of change'!Q117","v":-8.6621058271668633E-2},{"$f":"'Rate of change'!R117","v":-0.11075430379627851},{"$f":"'Rate of change'!S117","v":-0.13739382892678817},null,-0.4417179755359012,null,"Real FY19",{"$f":"N53*(1+'Rate of change'!$N$16)","v":-2.1840272061751796E-2},{"$f":"O53*(1+'Rate of change'!$N$16)","v":-4.3680421375968843E-2},{"$f":"P53*(1+'Rate of change'!$N$16)","v":-6.5674710817373236E-2},{"$f":"Q53*(1+'Rate of change'!$N$16)","v":-8.8570032082781178E-2},{"$f":"R53*(1+'Rate of change'!$N$16)","v":-0.11324627563169477},{"$f":"S53*(1+'Rate of change'!$N$16)","v":-0.1404851900776409},-0.45165662998545897]
[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,"Real FY19",{"$f":"N54*(1+'Rate of change'!$N$16)","v":0},{"$f":"O54*(1+'Rate of change'!$N$16)","v":0},{"$f":"P54*(1+'Rate of change'!$N$16)","v":0},{"$f":"Q54*(1+'Rate of change'!$N$16)","v":0},{"$f":"R54*(1+'Rate of change'!$N$16)","v":0},{"$f":"S54*(1+'Rate of change'!$N$16)","v":0},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,"Real FY19",{"$f":"N55*(1+'Rate of change'!$N$16)","v":0},{"$f":"O55*(1+'Rate of change'!$N$16)","v":0},{"$f":"P55*(1+'Rate of change'!$N$16)","v":0},{"$f":"Q55*(1+'Rate of change'!$N$16)","v":0},{"$f":"R55*(1+'Rate of change'!$N$16)","v":0},{"$f":"S55*(1+'Rate of change'!$N$16)","v":0},0]
[null,null,"Total",null,null,"Real FY18","Year-end",null,null,null,null,null,null,{"$f":"SUM(N51:N55)","v":3.927091384823659},3.9111226910469288,3.9022857834644138,3.9030188624736493,3.9055142663262514,3.9071652176001965,null,{"$f":"SUM(O56:S56)","v":19.529106820911441},null,"Real FY19",{"$f":"N56*(1+'Rate of change'!$N$16)","v":4.0154509409821912},{"$f":"O56*(1+'Rate of change'!$N$16)","v":3.9991229515954845},{"$f":"P56*(1+'Rate of change'!$N$16)","v":3.9900872135923628},{"$f":"Q56*(1+'Rate of change'!$N$16)","v":3.9908367868793064},{"$f":"R56*(1+'Rate of change'!$N$16)","v":3.9933883373185921},{"$f":"S56*(1+'Rate of change'!$N$16)","v":3.9950764349962009},{"$f":"SUM(Y56:AC56)","v":19.968511724381948}]
[null,null,"Total",null,null,"Real FY19","Year-end",null,null,null,null,null,null,{"$f":"N56*(1+'Rate of change'!$N$16)","v":4.0154509409821912},{"$f":"O56*(1+'Rate of change'!$N$16)","v":3.9991229515954845},{"$f":"P56*(1+'Rate of change'!$N$16)","v":3.9900872135923628},{"$f":"Q56*(1+'Rate of change'!$N$16)","v":3.9908367868793064},{"$f":"R56*(1+'Rate of change'!$N$16)","v":3.9933883373185921},{"$f":"S56*(1+'Rate of change'!$N$16)","v":3.9950764349962009},null,{"$f":"SUM(O57:S57)","v":19.968511724381948}]

{"sheet":"Base opex output","index":5,"n_rows":38,"n_cols":17,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Base opex output "]
[]
[null,"$2017/18 mid year",null,null,null,null,null,null,null,null,"Base year","Forecast"]
[null,null,1000000,null,null,null,null,{"$f":"'Index Tables'!H4","v":"FY15"},{"$f":"'Index Tables'!I4","v":"FY16"},{"$f":"'Index Tables'!J4","v":"FY17"},{"$f":"'Index Tables'!K4","v":"FY18"},{"$f":"'Index Tables'!L4","v":"FY19"},{"$f":"'Index Tables'!M4","v":"FY20"},{"$f":"'Index Tables'!N4","v":"FY21"},{"$f":"'Index Tables'!O4","v":"FY22"},{"$f":"'Index Tables'!P4","v":"FY23"},{"$f":"'Index Tables'!Q4","v":"FY24"}]
[]
[null,"Opex category",null,"RIN opex category"]
[null,null,"Metering Condition Monitoring","Metering","variable",null,null,0.46622196999999999,0.47552420999999989,0.35187995,0.54441890999999998,0.54269332713568419,0.54048657849999038,0.53926538695958492,0.53936669274740356,0.53971153805060923,0.53993968660942782]
[null,null,"Metering Strategy & Planning","Metering","fixed",null,null,0.15291882999999998,7.1685240000000011E-2,4.2604520000000007E-2,0.14315926000000001,0.14270550433246795,0.14212522231821548,0.14180410034021015,0.14183073949868066,0.14192141929968427,0.14198141276840953]
[null,null,"Meter Reading","Metering","variable",null,null,1.86212826,1.9052893900000001,1.7828872399999998,1.5591112400000002,1.5541695019562094,1.5478497975180132,1.5443525393922088,1.5446426597197065,1.5456302304642444,1.5462836041364481]
[null,null,"Meter Data Services","Metering","fixed",null,null,0.98335960000000011,1.0780204499999999,1.2143391299999999,1.65258964,1.6473516140752029,1.6406530041142966,1.6369460636479383,1.6372535784905458,1.6383003602334509,1.6389929077143686]
[null,null,"Total",null,null,null,null,{"$f":"SUM(H7:H10)","v":3.4646286599999998},3.53051929,3.3917108399999996,{"$f":"SUM(K7:K10)","v":3.8992790500000001},3.8869199474995648,3.8711146024505156,3.8623680903399427,3.8630936704563368,3.8655635480479891,3.8671976112286539]
[]
[null,null,null,null,"Fixed",null,null,null,null,null,{"$f":"K8+K10","v":1.7957489}]
[null,null,null,null,"Variable",null,null,null,null,null,{"$f":"K7+K9","v":2.1035301500000001}]
[]
[null,null,null,null,"Fixed",null,null,null,null,null,{"$f":"K13/K11","v":0.46053356966078124}]
[null,null,null,null,"Variable",null,null,null,null,null,{"$f":"K14/K11","v":0.53946643033921871}]
[]
[null,"$2017/18 end year",null,null,null,null,null,null,null,null,"Base year","Forecast"]
[null,null,1000000,null,null,{"$f":"'Index Tables'!J37","v":0},null,"FY15","FY16","FY17","FY18","FY19","FY20","FY21","FY22","FY23","FY24"]
[]
[null,"Opex category",null,"RIN opex category"]
[null,null,{"$f":"C7","v":"Metering Condition Monitoring"},"Metering",null,null,null,0.47086110883878968,0.4802559107205725,0.35538132927356009,0.54983614700826999,0.54809339374229893,0.54586468686790757,0.54463134386860645,0.54473365769904236,0.54508193438331209,0.54531235313295889]
[null,null,"Metering Strategy & Planning","Metering",null,null,null,0.15444044787535507,7.2398543538767096E-2,4.3028456013654598E-2,0.14458376533422609,0.14412549457372109,0.14353943846686254,0.14321512116659441,0.14324202539784708,0.14333360750765164,0.14339419794101768]
[null,null,"Meter Reading","Metering",null,null,null,1.8806573557733584,1.9242479603313873,1.8006278484922733,1.5746251667835827,1.5696342560058469,1.5632516673875918,1.5597196098163628,1.5600126169843911,1.5610100145455355,1.5616698896084369]
[null,null,"Meter Data Services","Metering",null,null,null,0.99314451363857592,1.0887472858430309,1.2264224040281309,1.6690337230266008,1.6637435761571253,1.6569783117190917,1.6532344853644718,1.6535450601316251,1.654602257869811,1.6553016965401688]
[null,null,"Total",null,null,null,null,{"$f":"SUM(H23:H26)","v":3.4991034261260792},3.5656497004337577,3.425460037807619,{"$f":"SUM(K23:K26)","v":3.9380788021526794},3.9255967204789921,3.9096341044414533,3.9008005602160356,3.9015333602129054,3.9040278143063101,3.9056781372225822]
[]
[]
[null,"$2018/19 end year",null,null,null,null,null,null,null,null,"Base year","Forecast"]
[null,null,1000000,null,null,{"$f":"'Index Tables'!J69","v":0},null,"FY15","FY16","FY17","FY18","FY19","FY20","FY21","FY22","FY23","FY24"]
[]
[null,"Opex category",null,"RIN opex category"]
[null,null,{"$f":"C23","v":"Metering Condition Monitoring"},{"$f":"D23","v":"Metering"},null,null,null,0.4802783310155655,0.48986102893498396,0.36248895585903129,0.5608328699484354,0.55905526161714492,0.55678198060526574,0.55552397074597859,0.55562833085302321,0.55598357307097834,0.55621860019561808]
[null,null,{"$f":"C24","v":"Metering Strategy & Planning"},"Metering",null,null,null,0.15752925683286217,7.3846514409542444E-2,4.3889025133927694E-2,0.14747544064091062,0.14700800446519552,0.14641022723619979,0.14607942358992629,0.14610686590580402,0.14620027965780469,0.14626208189983803]
[null,null,"Meter Reading","Metering",null,null,null,1.9182705028888256,1.9627329195380152,1.8366404054621188,1.6061176701192543,1.6010269411259639,1.5945167007353436,1.5909140020126902,1.591212869324079,1.5922302148364462,1.5929032874006057]
[null,null,"Meter Data Services","Metering",null,null,null,1.0130074039113475,1.1105222315598915,1.2509508521086934,1.7024143974871329,1.6970184476802679,1.6901178779534736,1.6862991750717613,1.6866159613342575,1.6876943030272071,1.6884077304709721]
[null,null,"Total",null,null,null,null,{"$f":"SUM(H34:H37)","v":3.569085494648601},3.6369626944424329,3.4939692385637713,{"$f":"SUM(K34:K37)","v":4.0168403781957336},4.0041086548885723,3.9878267865302828,3.9788165714203565,3.9795640274171635,3.9821083705924361,3.9837916999670338]