{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Cover Sheet","Model Information","Revenue Nominal Smoothed","Revenue Nominal","Volume Trending","Corporate OH","Building Block Inputs","Unit Costs","Registar data Pivot","Master Data","SinglePhases","MultiPhases","CTs"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":73,"comments":2,"pivot_tables":3},"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":"Cover Sheet","index":0,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Model Details"]
[]
[null,null,"Model Name:","TasNetworks "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Model Description/Scope"]

{"sheet":"Model Information","index":1,"n_rows":74,"n_cols":2,"rows_kept":74,"cut":false,"hidden":false,"merged":[[73,1,74,10],[75,1,76,10],[77,1,78,10],[79,1,80,10],[81,1,82,10],[68,1,70,10],[71,1,72,10],[26,1,29,10],[30,1,34,10],[35,1,38,10],[52,1,54,10],[55,1,57,10],[58,1,59,10],[60,1,62,10],[63,1,67,10],[39,1,42,10],[43,1,44,10],[45,1,46,10],[49,1,51,10],[2,1,4,10],[5,1,7,10],[8,1,13,10],[14,1,19,10],[20,1,25,10]]}
[]
[null,"Process information"]
[null,"The model starts with metering base data that lists total register inventory, this has been extracted by the Metering team leader from his database. "]
[]
[]
[null,"Unit costs are calculated based on supplier contract prices to purchase, on costs and installation costs. As mechanical prices are no longer available the old prices have been indexed."]
[]
[]
[null,"The Metering regulated asset base has been rolled forward using the RFM template. This process starts with the opening asset value from last determination, adding actual expenditure from the reported RIN's for the years already completed, then the forecasted expenditure for the remaining years (2012/13 - 2016/17). The outputs from the process then set the opening RAB for 2017 which have been linked into the Building Blocks"]
[]
[]
[]
[]
[]
[null,"Building block Inputs takes the opening 2017 Regulated Asset base from the Metering RFM then adds in the forecasted POW expenditure during the determination period. This expenditure includes direct metering Capex & Opex expenditure as well as a corporate allocation of Capex and Opex overheads. The expenditure shapes the RAB that feeds into the PTRM determining the level of revenue that can be generated."]
[]
[]
[]
[]
[]
[null,"Register volume trends are forecasted until the end of 2015/16 based on the last 4 years average movement. the Metering team leader has assumed that the trend will continue. There is also a 6 month period at the start of the determination period before the smart meter reform starts (assumed to be 1 January 2018). During this period there will be no replacement programs performed just customer initiated works (new and alterations)."]
[]
[]
[]
[]
[]
[null,"Register numbers need to be converted into meters to calculate the change in meters impact on register numbers, which the Metering team leader has confirmed is assumed to be 1:1 for business's and 2:1 for Domestic meters. This converts the 519k of registers into 280k of meters that will need to be replaced."]
[]
[]
[]
[null,"Forecast meter volumes during the future regulatory periods (after the first 6 months) are assuming that we are not installing smart meters and customers/retailers are paying for the capital costs. Therefore the only movement in meter volumes are the TasNetworks meters being replaced via customer demand and the replacement program that will be ran by the metering coordinator."]
[]
[]
[]
[]
[null,"The register volumes feed into the revenue tab where a weighting for the RAB is determined using the number of mechanical & electric meters and their cost per unit. This weighting is influenced by the mix of mechanical and electric as they have different unit costs"]
[]
[]
[]
[null,"The PTRM is linked to the RAB and forecasted expenditure which determines the capped revenue for metering. PTRM revenue feeds into the revenue tab where there is a calculation to determine the OPEX and CAPEX daily charge based on the weighting for the type of register."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Assumptions"]
[null,"Customer demand for a smart meters is not expected to increase therefor the only take ups are alterations and new meters."]
[]
[null,"x"]
[null,"Register volumes between the count in 2015 and the end of 2016/17 are assumed to follow the trend of the last 5 years. the Metering team leader"]
[]
[]
[null,"Registers then need to be converted into meters which the Metering team leader is confirmed can be assumed to be 1:1 for all meters except 2:1 for Domestic Electronic meters. "]
[]
[]
[null,"Assumed that the smart meter reform will not start until 1 January 2018"]
[]
[null,"Assumed that there will be no meter replacements via TasNetworks replacement plan during the 6 month period 1 July 2017 - December 2017 as the smart meters will be installed after this period."]
[]
[]
[null,"Based on previous averages there are 2,000 new connections each year, 5,000 meter replacements carried out by TasNetworks for old meters and 5,000 alterations that are customer driven (solar for example) . Therefore there are around 12,000 normal meter changes annually, 10,000 of which are replacements of TasNetworks regulated meters."]
[]
[]
[]
[]
[null,"Assumed meter replacements are evenly distributed across the various meters, previously all replacements were assumed to be mechanical however this is not the case anymore according to the Metering team leader."]
[]
[]
[null,"Unit costs have been sourced from the contractors contract, provided by the inventory officer."]
[]
[null,"Assumed that corporate overheads will remain consistent. TasNetworks plans to find savings to offset any increases during the DD17 years included."]

{"sheet":"Revenue Nominal Smoothed","index":2,"n_rows":127,"n_cols":11,"rows_kept":127,"cut":false,"hidden":false,"merged":[[22,3,22,4],[96,10,96,12],[97,1,97,2],[51,2,52,2],[24,9,24,10],[25,2,26,2],[37,9,37,10],[38,2,39,2],[50,9,50,10],[24,3,24,4],[37,3,37,4],[50,3,50,4],[24,6,24,7],[37,6,37,7],[50,6,50,7]]}
[null,"Revenue per the PTRM workpaper",null,{"$f":"'Master Data'!I$28","v":"Year 3"},{"$f":"'Master Data'!J$28","v":"Year 4"}]
[null,"Year",null,{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"}]
[null,"Nominal ($m)",null,null,null,null,null,null,null,"KEY"]
[null,null,null,null,null,null,null,null,null,"PTRM"]
[null,"Return on capital","Link to PTRM",2.816470012757768,2.698011826259104,null,null,null,null,"Aurora decision"]
[null,"Regulated Asset base (regulatory depreciation)","Link to PTRM",3.5431359891862835,3.888198185165991,null,null,null,null,"Linked below"]
[]
[null,null,null,{"$f":"SUM(D5:D7)","v":6.3596060019440515},6.586210011425095]
[]
[null,"Operating Expenditure","Link to PTRM",5.3330695443709644,5.3745510958477869]
[null,"After Tax and Imputation credits","Below weighting",0.93248058728025196,0.9571188463764696]
[null,null,null,{"$f":"SUM(D10:D11)","v":6.2655501316512163},6.3316699422242566]
[null,null,"Total Revenue",{"$f":"D8+D12","v":12.625156133595269},12.917879953649351]
[null,"Smoothed Revenue","Link to PTRM",12.752173177869707,12.783703563660648]
[null,"After Tax and Imputation credits","Link to PTRM",0.93248058728025196,0.95684409420438643]
[]
[]
[]
[null,"Capex Revenue Smoothed",null,{"$f":"D8/D13*D14","v":6.4235876548099062},{"$f":"E8/E13*E14","v":6.5177998786315303}]
[null,"Opex Revenue Smoothed",null,{"$f":"D12/D13*D14","v":6.3285855230598003},{"$f":"E12/E13*E14","v":6.2659036850291185}]
[null,null,null,{"$f":"SUM(D19:D20)","v":12.752173177869707},{"$f":"SUM(E19:E20)","v":12.783703563660648}]
[]
[null,null,null,"For Pricing Schedule"]
[null,null,null,{"$f":"'Master Data'!I23","v":365},{"$f":"'Master Data'!J23","v":365},null,{"$f":"D24","v":365},{"$f":"E24","v":365}]
[null,null,null,"CAPEX Price (cents) per register per day",null,null,"Revenue per Year ($m) ",null,null,"Annual Opex Cost"]
[null,null,"Capex weighting",{"$f":"'Master Data'!I$28","v":"Year 3"},{"$f":"'Master Data'!J$28","v":"Year 4"},null,{"$f":"'Master Data'!I$28","v":"Year 3"},{"$f":"'Master Data'!J$28","v":"Year 4"},null,{"$f":"'Master Data'!I$28","v":"Year 3"},{"$f":"'Master Data'!J$28","v":"Year 4"}]
[null,"Meter Type",null,{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"},null,{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"},null,{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"}]
[null,"Business LV - Single Phase",{"$f":"$J$102","v":3.4951933303916709E-2},{"$f":"ROUND(D$19*10^6*$C28/D81/D$24*'Master Data'!$B$45,3)","v":3.0920000000000001},{"$f":"ROUND(E$19*10^6*$C28/E81/E$24*'Master Data'!$B$45,3)","v":3.137},null,{"$f":"D28*D81*G$24/'Master Data'!$B$45/10^6","v":0.2245197052},{"$f":"E28*E81*H$24/'Master Data'!$B$45/10^6","v":0.22778729470000003},null,{"$f":"ROUND((D28)*D$24/'Master Data'!$B$45,2)","v":11.29},{"$f":"ROUND((E28)*E$24/'Master Data'!$B$45,2)","v":11.45}]
[null,"Business LV - Multi Phase",{"$f":"$J$106","v":7.1546912802578896E-2},{"$f":"ROUND(D$19*10^6*$C29/D82/D$24*'Master Data'!$B$45,3)","v":6.8179999999999996},{"$f":"ROUND(E$19*10^6*$C29/E82/E$24*'Master Data'!$B$45,3)","v":6.9180000000000001},null,{"$f":"D29*D69*G$24/'Master Data'!$B$45/10^6","v":0.45956422190000001},{"$f":"E29*E82*H$24/'Master Data'!$B$45/10^6","v":0.4663046769000001},null,{"$f":"ROUND((D29)*D$24/'Master Data'!$B$45,2)","v":24.89},{"$f":"ROUND((E29)*E$24/'Master Data'!$B$45,2)","v":25.25}]
[null,"Business LV - CT Meters",{"$f":"$J$110","v":1.1651241466948216E-2},{"$f":"ROUND(D$19*10^6*$C30/D83/D$24*'Master Data'!$B$45,3)","v":9.0090000000000003},{"$f":"ROUND(E$19*10^6*$C30/E83/E$24*'Master Data'!$B$45,3)","v":9.141},null,{"$f":"D30*D70*G$24/'Master Data'!$B$45/10^6","v":7.4841366600000014E-2},{"$f":"E30*E83*H$24/'Master Data'!$B$45/10^6","v":7.5937943399999999E-2},null,{"$f":"ROUND((D30)*D$24/'Master Data'!$B$45,2)","v":32.880000000000003},{"$f":"ROUND((E30)*E$24/'Master Data'!$B$45,2)","v":33.36}]
[null,"Domestic LV - Single Phase",{"$f":"$J$114","v":0.7189360304186273},{"$f":"ROUND(D$19*10^6*$C31/D84/D$24*'Master Data'!$B$45,3)","v":3.004},{"$f":"ROUND(E$19*10^6*$C31/E84/E$24*'Master Data'!$B$45,3)","v":3.048},null,{"$f":"D31*D71*G$24/'Master Data'!$B$45/10^6","v":4.6181140863999994},{"$f":"E31*E84*H$24/'Master Data'!$B$45/10^6","v":4.6857562367999988},null,{"$f":"ROUND((D31)*D$24/'Master Data'!$B$45,2)","v":10.96},{"$f":"ROUND((E31)*E$24/'Master Data'!$B$45,2)","v":11.13}]
[null,"Domestic LV - Multi Phase",{"$f":"$J$118","v":5.6620709503485703E-2},{"$f":"ROUND(D$19*10^6*$C32/D85/D$24*'Master Data'!$B$45,3)","v":6.2619999999999996},{"$f":"ROUND(E$19*10^6*$C32/E85/E$24*'Master Data'!$B$45,3)","v":6.3540000000000001},null,{"$f":"D32*D72*G$24/'Master Data'!$B$45/10^6","v":0.36368944559999999},{"$f":"E32*E85*H$24/'Master Data'!$B$45/10^6","v":0.36903269519999998},null,{"$f":"ROUND((D32)*D$24/'Master Data'!$B$45,2)","v":22.86},{"$f":"ROUND((E32)*E$24/'Master Data'!$B$45,2)","v":23.19}]
[null,"Domestic LV - CT Meters",{"$f":"$J$122","v":5.6841543121977827E-4},{"$f":"ROUND(D$19*10^6*$C33/D86/D$24*'Master Data'!$B$45,3)","v":7.9710000000000001},{"$f":"ROUND(E$19*10^6*$C33/E86/E$24*'Master Data'!$B$45,3)","v":8.0879999999999992},null,{"$f":"D33*D73*G$24/'Master Data'!$B$45/10^6","v":3.6513158250000002E-3},{"$f":"E33*E86*H$24/'Master Data'!$B$45/10^6","v":3.7049105999999994E-3},null,{"$f":"ROUND((D33)*D$24/'Master Data'!$B$45,2)","v":29.09},{"$f":"ROUND((E33)*E$24/'Master Data'!$B$45,2)","v":29.52}]
[null,"Other Meters",{"$f":"$J$125","v":0.10572475707322319},{"$f":"ROUND(D$19*10^6*$C34/D87/D$24*'Master Data'!$B$45,3)","v":6.26},{"$f":"ROUND(E$19*10^6*$C34/E87/E$24*'Master Data'!$B$45,3)","v":6.351},null,{"$f":"D34*D74*G$24/'Master Data'!$B$45/10^6","v":0.67917510049999996},{"$f":"E34*E87*H$24/'Master Data'!$B$45/10^6","v":0.68904809317499993},null,{"$f":"ROUND((D34)*D$24/'Master Data'!$B$45,2)","v":22.85},{"$f":"ROUND((E34)*E$24/'Master Data'!$B$45,2)","v":23.18}]
[null,null,{"$f":"SUM(C28:C34)","v":0.99999999999999978},null,null,null,{"$f":"SUM(G28:G34)","v":6.4235552420249995},6.5175718507749982]
[null,null,null,null,null,"Check Calc",{"$f":"D19-G35","v":3.2412784906732384E-5},{"$f":"E19-H35","v":2.2802785653208701E-4}]
[]
[null,null,null,"OPEX Price (cents) per register per day",null,null,"Revenue per Year ($m) ",null,null,"Annual Capex Cost"]
[null,null,"Weighting",{"$f":"'Master Data'!I$28","v":"Year 3"},{"$f":"'Master Data'!J$28","v":"Year 4"},null,{"$f":"'Master Data'!I$28","v":"Year 3"},{"$f":"'Master Data'!J$28","v":"Year 4"},null,{"$f":"'Master Data'!I$28","v":"Year 3"},{"$f":"'Master Data'!J$28","v":"Year 4"}]
[null,"Meter Type",null,{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"},null,{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"},null,{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"}]
[null,{"$f":"B28","v":"Business LV - Single Phase"},{"$f":"$J$102","v":3.4951933303916709E-2},{"$f":"ROUND(D$20*10^6*$C41/D68/D$24*'Master Data'!$B$45,3)","v":3.0459999999999998},{"$f":"ROUND(E$20*10^6*$C41/E68/E$24*'Master Data'!$B$45,3)","v":3.0529999999999999},null,{"$f":"D41*D68*G$24/'Master Data'!$B$45/10^6","v":0.22117950259999997},{"$f":"E41*E68*H$24/'Master Data'!$B$45/10^6","v":0.21901336629999998},null,{"$f":"ROUND((D41)*D$24/'Master Data'!$B$45,2)","v":11.12},{"$f":"ROUND((E41)*E$24/'Master Data'!$B$45,2)","v":11.14}]
[null,{"$f":"B29","v":"Business LV - Multi Phase"},{"$f":"$J$106","v":7.1546912802578896E-2},{"$f":"ROUND(D$20*10^6*$C42/D69/D$24*'Master Data'!$B$45,3)","v":6.718},{"$f":"ROUND(E$20*10^6*$C42/E69/E$24*'Master Data'!$B$45,3)","v":6.7320000000000002},null,{"$f":"D42*D69*G$24/'Master Data'!$B$45/10^6","v":0.45282376689999998},{"$f":"E42*E69*H$24/'Master Data'!$B$45/10^6","v":0.4482879192},null,{"$f":"ROUND((D42)*D$24/'Master Data'!$B$45,2)","v":24.52},{"$f":"ROUND((E42)*E$24/'Master Data'!$B$45,2)","v":24.57}]
[null,"Business LV - CT Meters",{"$f":"$J$110","v":1.1651241466948216E-2},{"$f":"ROUND(D$20*10^6*$C43/D70/D$24*'Master Data'!$B$45,3)","v":8.8759999999999994},{"$f":"ROUND(E$20*10^6*$C43/E70/E$24*'Master Data'!$B$45,3)","v":8.8940000000000001},null,{"$f":"D43*D70*G$24/'Master Data'!$B$45/10^6","v":7.3736482399999997E-2},{"$f":"E43*E70*H$24/'Master Data'!$B$45/10^6","v":7.3009511900000004E-2},null,{"$f":"ROUND((D43)*D$24/'Master Data'!$B$45,2)","v":32.4},{"$f":"ROUND((E43)*E$24/'Master Data'!$B$45,2)","v":32.46}]
[null,"Domestic LV - Single Phase",{"$f":"$J$114","v":0.7189360304186273},{"$f":"ROUND(D$20*10^6*$C44/D71/D$24*'Master Data'!$B$45,3)","v":2.96},{"$f":"ROUND(E$20*10^6*$C44/E71/E$24*'Master Data'!$B$45,3)","v":2.9660000000000002},null,{"$f":"D44*D71*G$24/'Master Data'!$B$45/10^6","v":4.5504719360000001},{"$f":"E44*E71*H$24/'Master Data'!$B$45/10^6","v":4.5047002936},null,{"$f":"ROUND((D44)*D$24/'Master Data'!$B$45,2)","v":10.8},{"$f":"ROUND((E44)*E$24/'Master Data'!$B$45,2)","v":10.83}]
[null,"Domestic LV - Multi Phase",{"$f":"$J$118","v":5.6620709503485703E-2},{"$f":"ROUND(D$20*10^6*$C45/D72/D$24*'Master Data'!$B$45,3)","v":6.17},{"$f":"ROUND(E$20*10^6*$C45/E72/E$24*'Master Data'!$B$45,3)","v":6.1829999999999998},null,{"$f":"D45*D72*G$24/'Master Data'!$B$45/10^6","v":0.35834619599999995},{"$f":"E45*E72*H$24/'Master Data'!$B$45/10^6","v":0.35476817399999999},null,{"$f":"ROUND((D45)*D$24/'Master Data'!$B$45,2)","v":22.52},{"$f":"ROUND((E45)*E$24/'Master Data'!$B$45,2)","v":22.57}]
[null,"Domestic LV - CT Meters",{"$f":"$J$122","v":5.6841543121977827E-4},{"$f":"ROUND(D$20*10^6*$C46/D73/D$24*'Master Data'!$B$45,3)","v":7.8529999999999998},{"$f":"ROUND(E$20*10^6*$C46/E73/E$24*'Master Data'!$B$45,3)","v":7.8689999999999998},null,{"$f":"D46*D73*G$24/'Master Data'!$B$45/10^6","v":3.5972629749999995E-3},{"$f":"E46*E73*H$24/'Master Data'!$B$45/10^6","v":3.5615093999999997E-3},null,{"$f":"ROUND((D46)*D$24/'Master Data'!$B$45,2)","v":28.66},{"$f":"ROUND((E46)*E$24/'Master Data'!$B$45,2)","v":28.72}]
[null,"Other Meters",{"$f":"$J$125","v":0.10572475707322319},{"$f":"ROUND(D$20*10^6*$C47/D74/D$24*'Master Data'!$B$45,3)","v":6.1669999999999998},{"$f":"ROUND(E$20*10^6*$C47/E74/E$24*'Master Data'!$B$45,3)","v":6.18},null,{"$f":"D47*D74*G$24/'Master Data'!$B$45/10^6","v":0.669085118975},{"$f":"E47*E74*H$24/'Master Data'!$B$45/10^6","v":0.66240886200000004},null,{"$f":"ROUND((D47)*D$24/'Master Data'!$B$45,2)","v":22.51},{"$f":"ROUND((E47)*E$24/'Master Data'!$B$45,2)","v":22.56}]
[null,null,{"$f":"SUM(C41:C47)","v":0.99999999999999978},null,null,null,{"$f":"SUM(G41:G47)","v":6.3292402658500002},6.2657496364000007]
[null,null,null,null,null,"Check Calc",{"$f":"D20-G48","v":-6.5474279019994697E-4},{"$f":"E20-H48","v":1.5404862911783113E-4}]
[]
[null,null,null,"Total Price (cents) per register per day",null,null,"Revenue per Year ($m) ",null,null,"Annual Cost both"]
[null,null,"Capex weighting",{"$f":"'Master Data'!I$28","v":"Year 3"},{"$f":"'Master Data'!J$28","v":"Year 4"},null,{"$f":"'Master Data'!I$28","v":"Year 3"},{"$f":"'Master Data'!J$28","v":"Year 4"},null,{"$f":"'Master Data'!I$28","v":"Year 3"},{"$f":"'Master Data'!J$28","v":"Year 4"}]
[null,"Meter Type",null,{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"},null,{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"},null,{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"}]
[null,{"$f":"B41","v":"Business LV - Single Phase"},{"$f":"$J$102","v":3.4951933303916709E-2},{"$f":"D28+D41","v":6.1379999999999999},{"$f":"E28+E41","v":6.1899999999999995},null,{"$f":"G28+G41","v":0.44569920779999994},{"$f":"H28+H41","v":0.44680066100000004},null,{"$f":"(D54)*D$24/'Master Data'!$B$45","v":22.403700000000001},{"$f":"(E54)*E$24/'Master Data'!$B$45","v":22.593499999999999}]
[null,{"$f":"B42","v":"Business LV - Multi Phase"},{"$f":"$J$106","v":7.1546912802578896E-2},13.536,13.65,null,{"$f":"G29+G42","v":0.91238798879999994},0.9145925961000001,null,{"$f":"(D55)*D$24/'Master Data'!$B$45","v":49.406399999999991},{"$f":"(E55)*E$24/'Master Data'!$B$45","v":49.822499999999998}]
[null,"Business LV - CT Meters",{"$f":"$J$110","v":1.1651241466948216E-2},17.884999999999998,18.035,null,0.14857784900000001,0.1489474553,null,{"$f":"(D56)*D$24/'Master Data'!$B$45","v":65.280249999999995},{"$f":"(E56)*E$24/'Master Data'!$B$45","v":65.827749999999995}]
[null,"Domestic LV - Single Phase",{"$f":"$J$114","v":0.7189360304186273},5.9640000000000004,6.0140000000000002,null,9.1685860223999995,9.1904565303999988,null,{"$f":"(D57)*D$24/'Master Data'!$B$45","v":21.768600000000003},{"$f":"(E57)*E$24/'Master Data'!$B$45","v":21.9511}]
[null,"Domestic LV - Multi Phase",{"$f":"$J$118","v":5.6620709503485703E-2},12.431999999999999,12.536999999999999,null,0.7220356416,0.72380086919999997,null,{"$f":"(D58)*D$24/'Master Data'!$B$45","v":45.376799999999996},{"$f":"(E58)*E$24/'Master Data'!$B$45","v":45.760049999999993}]
[null,"Domestic LV - CT Meters",{"$f":"$J$122","v":5.6841543121977827E-4},15.824,15.956999999999999,null,7.2485787999999997E-3,7.2664199999999991E-3,null,{"$f":"(D59)*D$24/'Master Data'!$B$45","v":57.757600000000004},{"$f":"(E59)*E$24/'Master Data'!$B$45","v":58.243049999999997}]
[null,"Other Meters",{"$f":"$J$125","v":0.10572475707322319},12.427,12.530999999999999,null,1.348260219475,1.351456955175,null,{"$f":"(D60)*D$24/'Master Data'!$B$45","v":45.358549999999994},{"$f":"(E60)*E$24/'Master Data'!$B$45","v":45.738149999999997}]
[null,null,{"$f":"SUM(C54:C60)","v":0.99999999999999978},null,null,null,{"$f":"SUM(G54:G60)","v":12.752795507875},12.783321487174998]
[null,null,null,null,null,"Check Calc",{"$f":"G61-D21","v":6.223300052923264E-4},{"$f":"H61-E21","v":-3.8207648564991814E-4}]
[]
[]
[null,null,null,"Volumes - with attrition of smart meter take up"]
[null,null,null,{"$f":"'Master Data'!I$28","v":"Year 3"},{"$f":"'Master Data'!J$28","v":"Year 4"}]
[null,"Meter Type",null,{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"}]
[null,{"$f":"B41","v":"Business LV - Single Phase"},null,{"$f":"'Volume Trending'!Q56","v":19894},{"$f":"'Volume Trending'!R56","v":19654}]
[null,"Business LV - Multi Phase",null,{"$f":"'Volume Trending'!Q60","v":18467},{"$f":"'Volume Trending'!R60","v":18244}]
[null,"Business LV - CT Meters",null,{"$f":"'Volume Trending'!Q64","v":2276},{"$f":"'Volume Trending'!R64","v":2249}]
[null,"Domestic LV - Single Phase",null,{"$f":"'Volume Trending'!Q68","v":421184},{"$f":"'Volume Trending'!R68","v":416104}]
[null,"Domestic LV - Multi Phase",null,{"$f":"'Volume Trending'!Q72","v":15912},{"$f":"'Volume Trending'!R72","v":15720}]
[null,"Domestic LV - CT Meters",null,{"$f":"'Volume Trending'!Q76","v":125.5},{"$f":"'Volume Trending'!R76","v":124}]
[null,"Other Meters",null,{"$f":"'Volume Trending'!Q82","v":29724.5},{"$f":"'Volume Trending'!R82","v":29366}]
[null,null,null,{"$f":"SUM(D68:D74)","v":507583},501461]
[null,null,null,{"$f":"D75-'Volume Trending'!Q84","v":0},{"$f":"E75-'Volume Trending'!R84","v":0}]
[]
[null,null,null,"Volumes - with no attrition for unavoidable costs"]
[null,null,null,{"$f":"'Master Data'!I$28","v":"Year 3"},{"$f":"'Master Data'!J$28","v":"Year 4"}]
[null,null,null,{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"}]
[null,{"$f":"B68","v":"Business LV - Single Phase"},null,{"$f":"D68","v":19894},{"$f":"D81","v":19894}]
[null,{"$f":"B69","v":"Business LV - Multi Phase"},null,{"$f":"D69","v":18467},{"$f":"D82","v":18467}]
[null,"Business LV - CT Meters",null,2276,2276]
[null,"Domestic LV - Single Phase",null,421184,421184]
[null,"Domestic LV - Multi Phase",null,15912,15912]
[null,"Domestic LV - CT Meters",null,125.5,125.5]
[null,"Other Meters",null,29724.5,29724.5]
[null,null,null,{"$f":"SUM(D81:D87)","v":507583},507583]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Meter Type","Meter Volumes",null,null,"Unit  Prices","Meter Type",null,"Weighted cost","Weighting of total cost","Prior splits if required to step chanage for data annomilies"]
[null,"Weighting of costs based on calcualted value of the assets",null,null,null,null,null,null,null,null,"2011/12 split"]
[]
[null,"Business LV - Single Phase",{"$f":"'Volume Trending'!I6","v":18205},null,null,{"$f":"'Unit Costs'!D$82","v":168.83585075540591},"Mechanical",null,{"$f":"C100*F100","v":3073656.6630021646}]
[null,"Business LV - Single Phase",{"$f":"'Volume Trending'!I7","v":3928},null,null,{"$f":"'Unit Costs'!D$81","v":269.35399999999998},"Electronic",null,{"$f":"C101*F101","v":1058022.5119999999}]
[null,null,{"$f":"SUM(C100:C101)","v":22133},null,null,null,null,null,{"$f":"SUBTOTAL(9,I100:I101)","v":4131679.1750021642},{"$f":"I102/$I$127","v":3.4951933303916709E-2}]
[]
[null,"Business LV - Multi Phase",{"$f":"'Volume Trending'!I11","v":7509},null,null,{"$f":"'Unit Costs'!D$84","v":388.51229022804227},"Mechanical",null,{"$f":"C104*F104","v":2917338.7873223694}]
[null,"Business LV - Multi Phase",{"$f":"'Volume Trending'!I12","v":12929},null,null,{"$f":"'Unit Costs'!D$83","v":428.51299999999998},"Electronic",null,{"$f":"C105*F105","v":5540244.5769999996}]
[null,null,{"$f":"SUM(C104:C105)","v":20438},null,null,null,null,null,{"$f":"SUBTOTAL(9,I104:I105)","v":8457583.3643223681},{"$f":"I106/$I$127","v":7.1546912802578896E-2}]
[]
[null,"Business LV - CT Meters",{"$f":"'Volume Trending'!I16","v":602},null,null,{"$f":"'Unit Costs'!D$86","v":388.51229022804227},"Mechanical",{"$f":"C108*F108","v":233884.39871728144},{"$f":"$H$110*K108*$J$108","v":270526.85488978215},1.1000000000000001,0.21195219123505976]
[null,"Business LV - CT Meters",{"$f":"'Volume Trending'!I17","v":1645},null,null,{"$f":"'Unit Costs'!D$85","v":563.18599999999992},"Electronic",{"$f":"C109*F109","v":926440.96999999986},{"$f":"$H$110*K109*$J$108","v":1106770.1121571632},null,0.86713147410358571]
[null,null,{"$f":"SUM(C108:C109)","v":2247},null,null,null,null,{"$f":"SUBTOTAL(9,H108:H109)","v":1160325.3687172814},{"$f":"SUBTOTAL(9,I108:I109)","v":1377296.9670469454},{"$f":"I110/$I$127","v":1.1651241466948216E-2}]
[]
[null,"Domestic LV - Single Phase",{"$f":"'Volume Trending'!I21","v":259105},null,null,{"$f":"'Unit Costs'!D$82","v":168.83585075540591},"Mechanical",null,{"$f":"C112*F112","v":43746213.109979451}]
[null,"Domestic LV - Single Phase",{"$f":"'Volume Trending'!I22","v":153105},null,null,{"$f":"'Unit Costs'!D$81","v":269.35399999999998},"Electronic",null,{"$f":"C113*F113","v":41239444.169999994}]
[null,null,{"$f":"SUM(C112:C113)","v":412210},null,null,null,null,null,{"$f":"SUBTOTAL(9,I112:I113)","v":84985657.279979438},{"$f":"I114/$I$127","v":0.7189360304186273}]
[]
[null,"Domestic LV - Multi Phase",{"$f":"'Volume Trending'!I26","v":5700},null,null,{"$f":"'Unit Costs'!D$84","v":388.51229022804227},"Mechanical",{"$f":"C116*F116","v":2214520.0542998412},{"$f":"$H$118*K116*$J$116","v":3237813.9837206937},1,0.53676020631174048]
[null,"Domestic LV - Multi Phase",{"$f":"'Volume Trending'!I27","v":8909},null,null,{"$f":"'Unit Costs'!D$83","v":428.51299999999998},"Electronic",{"$f":"C117*F117","v":3817622.3169999998},{"$f":"$H$118*K117*$J$116","v":3455338.1316498127},null,0.57282105079115309]
[null,null,{"$f":"SUM(C116:C117)","v":14609},null,null,null,null,{"$f":"SUBTOTAL(9,H116:H117)","v":6032142.3712998405},{"$f":"SUBTOTAL(9,I116:I117)","v":6693152.1153705064},{"$f":"I118/$I$127","v":5.6620709503485703E-2}]
[]
[null,"Domestic LV - CT Meters",{"$f":"'Volume Trending'!I31","v":82},null,null,{"$f":"'Unit Costs'!D$86","v":388.51229022804227},"Mechanical",{"$f":"C120*F120","v":31858.007798699466},{"$f":"$H$122*K120*$J$120","v":23670.109631994244},1.6,0.35227272727272729]
[null,"Domestic LV - CT Meters",{"$f":"'Volume Trending'!I32","v":18},null,null,{"$f":"'Unit Costs'!D$85","v":563.18599999999992},"Electronic",{"$f":"C121*F121","v":10137.347999999998},{"$f":"$H$122*K121*$J$120","v":43522.459645924901},null,0.64772727272727271]
[null,null,{"$f":"SUM(C120:C121)","v":100},null,null,null,null,{"$f":"SUBTOTAL(9,H120:H121)","v":41995.355798699464},{"$f":"SUBTOTAL(9,I120:I121)","v":67192.569277919145},{"$f":"I122/$I$127","v":5.6841543121977827E-4}]
[]
[null,"Other Meters -PAYG",{"$f":"'Volume Trending'!I36","v":30382},null,null,{"$f":"'Unit Costs'!D$87","v":411.35399999999998},null,null,{"$f":"C124*F124","v":12497757.228}]
[null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,I124:I124)","v":12497757.228},{"$f":"I125/$I$127","v":0.10572475707322319}]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,I100:I126)","v":118210318.69899936}]

{"sheet":"Revenue Nominal","index":3,"n_rows":123,"n_cols":11,"rows_kept":123,"cut":false,"hidden":false,"merged":[[93,1,93,2],[47,2,48,2],[21,2,22,2],[34,2,35,2],[92,10,92,12],[2,9,2,10],[3,9,3,10],[4,9,4,10],[5,9,5,10],[46,9,46,10],[20,9,20,10],[33,9,33,10]]}
[null,"Revenue per the PTRM workpaper",null,{"$f":"'Master Data'!I$28","v":"Year 3"},{"$f":"'Master Data'!J$28","v":"Year 4"}]
[null,"Year",null,{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"}]
[null,"Nominal ($m)",null,null,null,null,null,null,null,"KEY"]
[null,null,null,null,null,null,null,null,null,"PTRM"]
[null,"Return on capital","Link to PTRM",2.8303417229527299,2.7118545827865548,null,null,null,null,"Aurora decision"]
[null,"Regulated Asset base (regulatory depreciation)","Link to PTRM",3.5865214219591408,3.9411146132518322,null,null,null,null,"Linked below"]
[]
[null,null,null,{"$f":"SUM(D5:D7)","v":6.4168631449118703},{"$f":"SUM(E5:E7)","v":6.652969196038387}]
[]
[null,"Operating Expenditure","Link to PTRM",5.3331839515304615,5.3746652642114316]
[null,"After Tax and Imputation credits","Below weighting",{"$f":"D15","v":0.93395579739837631},0.95866273944739455]
[null,null,null,{"$f":"SUM(D10:D11)","v":6.2671397489288374},{"$f":"SUM(E10:E11)","v":6.333328003658826}]
[null,null,"Total Revenue",{"$f":"D8+D12","v":12.684002893840708},12.986297199697212]
[]
[null,"After Tax and Imputation credits","Link to PTRM",0.93395579739837631,0.95866273944739455]
[]
[]
[]
[]
[null,null,null,{"$f":"'Master Data'!I23","v":365},{"$f":"'Master Data'!J23","v":365},null,{"$f":"D20","v":365},{"$f":"E20","v":365}]
[null,null,null,"CAPEX Price (cents) per register per day",null,null,"Revenue per Year ($m) ",null,null,"Annual Opex Cost"]
[null,null,"Capex weighting",{"$f":"'Master Data'!I$28","v":"Year 3"},{"$f":"'Master Data'!J$28","v":"Year 4"},null,{"$f":"'Master Data'!I$28","v":"Year 3"},{"$f":"'Master Data'!J$28","v":"Year 4"},null,{"$f":"'Master Data'!I$28","v":"Year 3"},{"$f":"'Master Data'!J$28","v":"Year 4"}]
[null,"Meter Type",null,{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"},null,{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"},null,{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"}]
[null,"Business LV - Single Phase",{"$f":"$J$98","v":3.4951933303916709E-2},{"$f":"D$8*10^6*$C24/D77/D$20*'Master Data'!$B$45","v":3.0887232835579383},{"$f":"E$8*10^6*$C24/E77/E$20*'Master Data'!$B$45","v":3.2023716879316004},null,{"$f":"D24*D77*G$20/'Master Data'!$B$45/10^6","v":0.22428177266132096},{"$f":"E24*E77*H$20/'Master Data'!$B$45/10^6","v":0.23253413561294609},null,{"$f":"(D24)*D$20/'Master Data'!$B$45","v":11.273839984986475},{"$f":"(E24)*E$20/'Master Data'!$B$45","v":11.688656660950342}]
[null,"Business LV - Multi Phase",{"$f":"$J$102","v":7.1546912802578896E-2},{"$f":"D$8*10^6*$C25/D78/D$20*'Master Data'!$B$45","v":6.8112130100281334},{"$f":"E$8*10^6*$C25/E78/E$20*'Master Data'!$B$45","v":7.0618290152104262},null,{"$f":"D25*D65*G$20/'Master Data'!$B$45/10^6","v":0.45910674789509182},{"$f":"E25*E78*H$20/'Master Data'!$B$45/10^6","v":0.47599940694720194},null,{"$f":"(D25)*D$20/'Master Data'!$B$45","v":24.860927486602687},{"$f":"(E25)*E$20/'Master Data'!$B$45","v":25.775675905518057}]
[null,"Business LV - CT Meters",{"$f":"$J$106","v":1.1651241466948216E-2},{"$f":"D$8*10^6*$C26/D79/D$20*'Master Data'!$B$45","v":8.9997378195017603},{"$f":"E$8*10^6*$C26/E79/E$20*'Master Data'!$B$45","v":9.3308797668598586},null,{"$f":"D26*D66*G$20/'Master Data'!$B$45/10^6","v":7.476442196172893E-2},{"$f":"E26*E79*H$20/'Master Data'!$B$45/10^6","v":7.7515350575211583E-2},null,{"$f":"(D26)*D$20/'Master Data'!$B$45","v":32.849043041181424},{"$f":"(E26)*E$20/'Master Data'!$B$45","v":34.057711149038482}]
[null,"Domestic LV - Single Phase",{"$f":"$J$110","v":0.7189360304186273},{"$f":"D$8*10^6*$C27/D80/D$20*'Master Data'!$B$45","v":3.0008777064880432},{"$f":"E$8*10^6*$C27/E80/E$20*'Master Data'!$B$45","v":3.111293866096231},null,{"$f":"D27*D67*G$20/'Master Data'!$B$45/10^6","v":4.6133141171425294},{"$f":"E27*E80*H$20/'Master Data'!$B$45/10^6","v":4.7830592642972443},null,{"$f":"(D27)*D$20/'Master Data'!$B$45","v":10.953203628681358},{"$f":"(E27)*E$20/'Master Data'!$B$45","v":11.356222611251244}]
[null,"Domestic LV - Multi Phase",{"$f":"$J$114","v":5.6620709503485703E-2},{"$f":"D$8*10^6*$C28/D81/D$20*'Master Data'!$B$45","v":6.2557653403940625},{"$f":"E$8*10^6*$C28/E81/E$20*'Master Data'!$B$45","v":6.4859438587665093},null,{"$f":"D28*D68*G$20/'Master Data'!$B$45/10^6","v":0.36332734405167871},{"$f":"E28*E81*H$20/'Master Data'!$B$45/10^6","v":0.3766958361845284},null,{"$f":"(D28)*D$20/'Master Data'!$B$45","v":22.833543492438331},{"$f":"(E28)*E$20/'Master Data'!$B$45","v":23.673695084497759}]
[null,"Domestic LV - CT Meters",{"$f":"$J$118","v":5.6841543121977827E-4},{"$f":"D$8*10^6*$C29/D82/D$20*'Master Data'!$B$45","v":7.9625476867180769},{"$f":"E$8*10^6*$C29/E82/E$20*'Master Data'!$B$45","v":8.2555266156373097},null,{"$f":"D29*D69*G$20/'Master Data'!$B$45/10^6","v":3.6474440315933834E-3},{"$f":"E29*E82*H$20/'Master Data'!$B$45/10^6","v":3.7816503544580607E-3},null,{"$f":"(D29)*D$20/'Master Data'!$B$45","v":29.063299056520982},{"$f":"(E29)*E$20/'Master Data'!$B$45","v":30.132672147076182}]
[null,"Other Meters",{"$f":"$J$121","v":0.10572475707322319},{"$f":"D$8*10^6*$C30/D83/D$20*'Master Data'!$B$45","v":6.2530521468538725},{"$f":"E$8*10^6*$C30/E83/E$20*'Master Data'!$B$45","v":6.483130834296742},null,{"$f":"D30*D70*G$20/'Master Data'!$B$45/10^6","v":0.67842129716792643},{"$f":"E30*E83*H$20/'Master Data'!$B$45/10^6","v":0.70338355206679515},null,{"$f":"(D30)*D$20/'Master Data'!$B$45","v":22.823640336016634},{"$f":"(E30)*E$20/'Master Data'!$B$45","v":23.663427545183108}]
[null,null,{"$f":"SUM(C24:C30)","v":0.99999999999999978},null,null,null,{"$f":"SUM(G24:G30)","v":6.4168631449118703},6.6529691960383861]
[null,null,null,null,null,"Check Calc",{"$f":"D8-G31","v":0},{"$f":"E8-H31","v":0}]
[]
[null,null,null,"OPEX Price (cents) per register per day",null,null,"Revenue per Year ($m) ",null,null,"Annual Capex Cost"]
[null,null,"Capex weighting",{"$f":"'Master Data'!I$28","v":"Year 3"},{"$f":"'Master Data'!J$28","v":"Year 4"},null,{"$f":"'Master Data'!I$28","v":"Year 3"},{"$f":"'Master Data'!J$28","v":"Year 4"},null,{"$f":"'Master Data'!I$28","v":"Year 3"},{"$f":"'Master Data'!J$28","v":"Year 4"}]
[null,"Meter Type",null,{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"},null,{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"},null,{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"}]
[null,{"$f":"B24","v":"Business LV - Single Phase"},{"$f":"$J$98","v":3.4951933303916709E-2},{"$f":"D$12*10^6*$C37/D64/D$20*'Master Data'!$B$45","v":3.0166547153459367},{"$f":"E$12*10^6*$C37/E64/E$20*'Master Data'!$B$45","v":3.085740265158631},null,{"$f":"D37*D64*G$20/'Master Data'!$B$45/10^6","v":0.21904865051088604},{"$f":"E37*E64*H$20/'Master Data'!$B$45/10^6","v":0.22136205797571121},null,{"$f":"(D37)*D$20/'Master Data'!$B$45","v":11.01078971101267},{"$f":"(E37)*E$20/'Master Data'!$B$45","v":11.262951967829004}]
[null,{"$f":"B25","v":"Business LV - Multi Phase"},{"$f":"$J$102","v":7.1546912802578896E-2},{"$f":"D$12*10^6*$C38/D65/D$20*'Master Data'!$B$45","v":6.6522883267997139},{"$f":"E$12*10^6*$C38/E65/E$20*'Master Data'!$B$45","v":6.8047151764349483},null,{"$f":"D38*D65*G$20/'Master Data'!$B$45/10^6","v":0.44839450113818763},{"$f":"E38*E65*H$20/'Master Data'!$B$45/10^6","v":0.4531300664279091},null,{"$f":"(D38)*D$20/'Master Data'!$B$45","v":24.280852392818957},{"$f":"(E38)*E$20/'Master Data'!$B$45","v":24.837210393987561}]
[null,"Business LV - CT Meters",{"$f":"$J$106","v":1.1651241466948216E-2},{"$f":"D$12*10^6*$C39/D66/D$20*'Master Data'!$B$45","v":8.7897487206441376},{"$f":"E$12*10^6*$C39/E66/E$20*'Master Data'!$B$45","v":8.9892169865467242},null,{"$f":"D39*D66*G$20/'Master Data'!$B$45/10^6","v":7.3019958521879105E-2},{"$f":"E39*E66*H$20/'Master Data'!$B$45/10^6","v":7.3791133860014069E-2},null,{"$f":"(D39)*D$20/'Master Data'!$B$45","v":32.0825828303511},{"$f":"(E39)*E$20/'Master Data'!$B$45","v":32.810642000895541}]
[null,"Domestic LV - Single Phase",{"$f":"$J$110","v":0.7189360304186273},{"$f":"D$12*10^6*$C40/D67/D$20*'Master Data'!$B$45","v":2.9308588217154377},{"$f":"E$12*10^6*$C40/E67/E$20*'Master Data'!$B$45","v":2.9979713279593727},null,{"$f":"D40*D67*G$20/'Master Data'!$B$45/10^6","v":4.5056725731736904},{"$f":"E40*E67*H$20/'Master Data'!$B$45/10^6","v":4.5532576942896039},null,{"$f":"(D40)*D$20/'Master Data'!$B$45","v":10.697634699261348},{"$f":"(E40)*E$20/'Master Data'!$B$45","v":10.942595347051711}]
[null,"Domestic LV - Multi Phase",{"$f":"$J$114","v":5.6620709503485703E-2},{"$f":"D$12*10^6*$C41/D68/D$20*'Master Data'!$B$45","v":6.1098008075553905},{"$f":"E$12*10^6*$C41/E68/E$20*'Master Data'!$B$45","v":6.2497390129571855},null,{"$f":"D41*D68*G$20/'Master Data'!$B$45/10^6","v":0.354849899141848},{"$f":"E41*E68*H$20/'Master Data'!$B$45/10^6","v":0.35859752508545739},null,{"$f":"(D41)*D$20/'Master Data'!$B$45","v":22.300772947577176},{"$f":"(E41)*E$20/'Master Data'!$B$45","v":22.811547397293726}]
[null,"Domestic LV - CT Meters",{"$f":"$J$118","v":5.6841543121977827E-4},{"$f":"D$12*10^6*$C42/D69/D$20*'Master Data'!$B$45","v":7.7767591396648976},{"$f":"E$12*10^6*$C42/E69/E$20*'Master Data'!$B$45","v":7.9539579501900768},null,{"$f":"D42*D69*G$20/'Master Data'!$B$45/10^6","v":3.5623389429019982E-3},{"$f":"E42*E69*H$20/'Master Data'!$B$45/10^6","v":3.599961368256029E-3},null,{"$f":"(D42)*D$20/'Master Data'!$B$45","v":28.385170859776878},{"$f":"(E42)*E$20/'Master Data'!$B$45","v":29.031946518193781}]
[null,"Other Meters",{"$f":"$J$121","v":0.10572475707322319},{"$f":"D$12*10^6*$C43/D70/D$20*'Master Data'!$B$45","v":6.1071509204223391},{"$f":"E$12*10^6*$C43/E70/E$20*'Master Data'!$B$45","v":6.2469929781050588},null,{"$f":"D43*D70*G$20/'Master Data'!$B$45/10^6","v":0.66259182749944234},{"$f":"E43*E70*H$20/'Master Data'!$B$45/10^6","v":0.66958956465187103},null,{"$f":"(D43)*D$20/'Master Data'!$B$45","v":22.29110085954154},{"$f":"(E43)*E$20/'Master Data'!$B$45","v":22.801524370083467}]
[null,null,{"$f":"SUM(C37:C43)","v":0.99999999999999978},null,null,null,{"$f":"SUM(G37:G43)","v":6.2671397489288347},6.3333280036588233]
[null,null,null,null,null,"Check Calc",{"$f":"D12-G44","v":0},{"$f":"E12-H44","v":0}]
[]
[null,null,null,"Total Price (cents) per register per day",null,null,"Revenue per Year ($m) ",null,null,"Annual Cost both"]
[null,null,"Capex weighting",{"$f":"'Master Data'!I$28","v":"Year 3"},{"$f":"'Master Data'!J$28","v":"Year 4"},null,{"$f":"'Master Data'!I$28","v":"Year 3"},{"$f":"'Master Data'!J$28","v":"Year 4"},null,{"$f":"'Master Data'!I$28","v":"Year 3"},{"$f":"'Master Data'!J$28","v":"Year 4"}]
[null,"Meter Type",null,{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"},null,{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"},null,{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"}]
[null,{"$f":"B37","v":"Business LV - Single Phase"},{"$f":"$J$98","v":3.4951933303916709E-2},{"$f":"D24+D37","v":6.105377998903875},6.2881119530902314,null,{"$f":"G24+G37","v":0.443330423172207},{"$f":"H24+H37","v":0.45389619358865729},null,{"$f":"(D50)*D$20/'Master Data'!$B$45","v":22.284629695999143},{"$f":"(E50)*E$20/'Master Data'!$B$45","v":22.951608628779343}]
[null,{"$f":"B38","v":"Business LV - Multi Phase"},{"$f":"$J$102","v":7.1546912802578896E-2},{"$f":"D25+D38","v":13.463501336827846},13.866544191645374,null,{"$f":"G25+G38","v":0.90750124903327944},0.92912947337511098,null,{"$f":"(D51)*D$20/'Master Data'!$B$45","v":49.141779879421641},{"$f":"(E51)*E$20/'Master Data'!$B$45","v":50.612886299505618}]
[null,"Business LV - CT Meters",{"$f":"$J$106","v":1.1651241466948216E-2},{"$f":"D26+D39","v":17.789486540145898},18.320096753406581,null,{"$f":"G26+G39","v":0.14778438048360804},0.15130648443522565,null,{"$f":"(D52)*D$20/'Master Data'!$B$45","v":64.931625871532518},{"$f":"(E52)*E$20/'Master Data'!$B$45","v":66.868353149934023}]
[null,"Domestic LV - Single Phase",{"$f":"$J$110","v":0.7189360304186273},{"$f":"D27+D40","v":5.9317365282034809},6.1092651940556042,null,{"$f":"G27+G40","v":9.1189866903162198},9.3363169585868491,null,{"$f":"(D53)*D$20/'Master Data'!$B$45","v":21.650838327942708},{"$f":"(E53)*E$20/'Master Data'!$B$45","v":22.298817958302958}]
[null,"Domestic LV - Multi Phase",{"$f":"$J$114","v":5.6620709503485703E-2},{"$f":"D28+D41","v":12.365566147949453},12.735682871723695,null,{"$f":"G28+G41","v":0.71817724319352672},0.73529336126998579,null,{"$f":"(D54)*D$20/'Master Data'!$B$45","v":45.134316440015503},{"$f":"(E54)*E$20/'Master Data'!$B$45","v":46.485242481791481}]
[null,"Domestic LV - CT Meters",{"$f":"$J$118","v":5.6841543121977827E-4},{"$f":"D29+D42","v":15.739306826382975},16.209484565827388,null,{"$f":"G29+G42","v":7.2097829744953816E-3},7.3816117227140897E-3,null,{"$f":"(D55)*D$20/'Master Data'!$B$45","v":57.44846991629786},{"$f":"(E55)*E$20/'Master Data'!$B$45","v":59.164618665269963}]
[null,"Other Meters",{"$f":"$J$121","v":0.10572475707322319},{"$f":"D30+D43","v":12.360203067276212},12.7301238124018,null,{"$f":"G30+G43","v":1.3410131246673687},1.3729731167186663,null,{"$f":"(D56)*D$20/'Master Data'!$B$45","v":45.114741195558175},{"$f":"(E56)*E$20/'Master Data'!$B$45","v":46.464951915266568}]
[null,null,{"$f":"SUM(C50:C56)","v":0.99999999999999978},null,null,null,{"$f":"SUM(G50:G56)","v":12.684002893840704},12.986297199697209]
[null,null,null,null,null,"Check Calc",{"$f":"G57-D13","v":0},{"$f":"H57-E13","v":0}]
[]
[]
[null,null,null,"Volumes - with attrition of smart meter take up"]
[null,null,null,{"$f":"'Master Data'!I$28","v":"Year 3"},{"$f":"'Master Data'!J$28","v":"Year 4"}]
[null,"Meter Type",null,{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"}]
[null,{"$f":"B37","v":"Business LV - Single Phase"},null,{"$f":"'Volume Trending'!Q56","v":19894},{"$f":"'Volume Trending'!R56","v":19654}]
[null,"Business LV - Multi Phase",null,{"$f":"'Volume Trending'!Q60","v":18467},{"$f":"'Volume Trending'!R60","v":18244}]
[null,"Business LV - CT Meters",null,{"$f":"'Volume Trending'!Q64","v":2276},{"$f":"'Volume Trending'!R64","v":2249}]
[null,"Domestic LV - Single Phase",null,{"$f":"'Volume Trending'!Q68","v":421184},{"$f":"'Volume Trending'!R68","v":416104}]
[null,"Domestic LV - Multi Phase",null,{"$f":"'Volume Trending'!Q72","v":15912},{"$f":"'Volume Trending'!R72","v":15720}]
[null,"Domestic LV - CT Meters",null,{"$f":"'Volume Trending'!Q76","v":125.5},{"$f":"'Volume Trending'!R76","v":124}]
[null,"Other Meters",null,{"$f":"'Volume Trending'!Q82","v":29724.5},{"$f":"'Volume Trending'!R82","v":29366}]
[null,null,null,{"$f":"SUM(D64:D70)","v":507583},501461]
[null,null,null,{"$f":"D71-'Volume Trending'!Q84","v":0},{"$f":"E71-'Volume Trending'!R84","v":0}]
[]
[null,null,null,"Volumes - with no attrition for unavoidable costs"]
[null,null,null,{"$f":"'Master Data'!I$28","v":"Year 3"},{"$f":"'Master Data'!J$28","v":"Year 4"}]
[null,null,null,{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"}]
[null,{"$f":"B64","v":"Business LV - Single Phase"},null,{"$f":"D64","v":19894},{"$f":"D77","v":19894}]
[null,{"$f":"B65","v":"Business LV - Multi Phase"},null,{"$f":"D65","v":18467},{"$f":"D78","v":18467}]
[null,"Business LV - CT Meters",null,2276,{"$f":"D79","v":2276}]
[null,"Domestic LV - Single Phase",null,421184,{"$f":"D80","v":421184}]
[null,"Domestic LV - Multi Phase",null,15912,{"$f":"D81","v":15912}]
[null,"Domestic LV - CT Meters",null,125.5,{"$f":"D82","v":125.5}]
[null,"Other Meters",null,29724.5,{"$f":"D83","v":29724.5}]
[null,null,null,{"$f":"SUM(D77:D83)","v":507583},507583]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Meter Type","Meter Volumes",null,null,"Unit  Prices","Meter Type",null,"Weighted cost","Weighting of total cost","Prior splits if required to step chanage for data annomilies"]
[null,"Weighting of costs based on calcualted value of the assets",null,null,null,null,null,null,null,null,"2011/12 split"]
[]
[null,"Business LV - Single Phase",{"$f":"'Volume Trending'!I6","v":18205},null,null,{"$f":"'Unit Costs'!D$82","v":168.83585075540591},"Mechanical",null,{"$f":"C96*F96","v":3073656.6630021646}]
[null,"Business LV - Single Phase",{"$f":"'Volume Trending'!I7","v":3928},null,null,{"$f":"'Unit Costs'!D$81","v":269.35399999999998},"Electronic",null,{"$f":"C97*F97","v":1058022.5119999999}]
[null,null,{"$f":"SUM(C96:C97)","v":22133},null,null,null,null,null,{"$f":"SUBTOTAL(9,I96:I97)","v":4131679.1750021642},{"$f":"I98/$I$123","v":3.4951933303916709E-2}]
[]
[null,"Business LV - Multi Phase",{"$f":"'Volume Trending'!I11","v":7509},null,null,{"$f":"'Unit Costs'!D$84","v":388.51229022804227},"Mechanical",null,{"$f":"C100*F100","v":2917338.7873223694}]
[null,"Business LV - Multi Phase",{"$f":"'Volume Trending'!I12","v":12929},null,null,{"$f":"'Unit Costs'!D$83","v":428.51299999999998},"Electronic",null,{"$f":"C101*F101","v":5540244.5769999996}]
[null,null,{"$f":"SUM(C100:C101)","v":20438},null,null,null,null,null,{"$f":"SUBTOTAL(9,I100:I101)","v":8457583.3643223681},{"$f":"I102/$I$123","v":7.1546912802578896E-2}]
[]
[null,"Business LV - CT Meters",{"$f":"'Volume Trending'!I16","v":602},null,null,{"$f":"'Unit Costs'!D$86","v":388.51229022804227},"Mechanical",{"$f":"C104*F104","v":233884.39871728144},{"$f":"$H$106*K104*$J$104","v":270526.85488978215},1.1000000000000001,0.21195219123505976]
[null,"Business LV - CT Meters",{"$f":"'Volume Trending'!I17","v":1645},null,null,{"$f":"'Unit Costs'!D$85","v":563.18599999999992},"Electronic",{"$f":"C105*F105","v":926440.96999999986},{"$f":"$H$106*K105*$J$104","v":1106770.1121571632},null,0.86713147410358571]
[null,null,{"$f":"SUM(C104:C105)","v":2247},null,null,null,null,{"$f":"SUBTOTAL(9,H104:H105)","v":1160325.3687172814},{"$f":"SUBTOTAL(9,I104:I105)","v":1377296.9670469454},{"$f":"I106/$I$123","v":1.1651241466948216E-2}]
[]
[null,"Domestic LV - Single Phase",{"$f":"'Volume Trending'!I21","v":259105},null,null,{"$f":"'Unit Costs'!D$82","v":168.83585075540591},"Mechanical",null,{"$f":"C108*F108","v":43746213.109979451}]
[null,"Domestic LV - Single Phase",{"$f":"'Volume Trending'!I22","v":153105},null,null,{"$f":"'Unit Costs'!D$81","v":269.35399999999998},"Electronic",null,{"$f":"C109*F109","v":41239444.169999994}]
[null,null,{"$f":"SUM(C108:C109)","v":412210},null,null,null,null,null,{"$f":"SUBTOTAL(9,I108:I109)","v":84985657.279979438},{"$f":"I110/$I$123","v":0.7189360304186273}]
[]
[null,"Domestic LV - Multi Phase",{"$f":"'Volume Trending'!I26","v":5700},null,null,{"$f":"'Unit Costs'!D$84","v":388.51229022804227},"Mechanical",{"$f":"C112*F112","v":2214520.0542998412},{"$f":"$H$114*K112*$J$112","v":3237813.9837206937},1,0.53676020631174048]
[null,"Domestic LV - Multi Phase",{"$f":"'Volume Trending'!I27","v":8909},null,null,{"$f":"'Unit Costs'!D$83","v":428.51299999999998},"Electronic",{"$f":"C113*F113","v":3817622.3169999998},{"$f":"$H$114*K113*$J$112","v":3455338.1316498127},null,0.57282105079115309]
[null,null,{"$f":"SUM(C112:C113)","v":14609},null,null,null,null,{"$f":"SUBTOTAL(9,H112:H113)","v":6032142.3712998405},{"$f":"SUBTOTAL(9,I112:I113)","v":6693152.1153705064},{"$f":"I114/$I$123","v":5.6620709503485703E-2}]
[]
[null,"Domestic LV - CT Meters",{"$f":"'Volume Trending'!I31","v":82},null,null,{"$f":"'Unit Costs'!D$86","v":388.51229022804227},"Mechanical",{"$f":"C116*F116","v":31858.007798699466},{"$f":"$H$118*K116*$J$116","v":23670.109631994244},1.6,0.35227272727272729]
[null,"Domestic LV - CT Meters",{"$f":"'Volume Trending'!I32","v":18},null,null,{"$f":"'Unit Costs'!D$85","v":563.18599999999992},"Electronic",{"$f":"C117*F117","v":10137.347999999998},{"$f":"$H$118*K117*$J$116","v":43522.459645924901},null,0.64772727272727271]
[null,null,{"$f":"SUM(C116:C117)","v":100},null,null,null,null,{"$f":"SUBTOTAL(9,H116:H117)","v":41995.355798699464},{"$f":"SUBTOTAL(9,I116:I117)","v":67192.569277919145},{"$f":"I118/$I$123","v":5.6841543121977827E-4}]
[]
[null,"Other Meters -PAYG",{"$f":"'Volume Trending'!I36","v":30382},null,null,{"$f":"'Unit Costs'!D$87","v":411.35399999999998},null,null,{"$f":"C120*F120","v":12497757.228}]
[null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,I120:I120)","v":12497757.228},{"$f":"I121/$I$123","v":0.10572475707322319}]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,I96:I122)","v":118210318.69899936}]

{"sheet":"Volume Trending","index":4,"n_rows":84,"n_cols":27,"rows_kept":84,"cut":false,"hidden":false,"merged":[[2,13,3,14],[2,3,3,3],[0,18,0,20],[0,16,0,17],[1,18,1,20],[2,18,3,18],[52,1,54,10],[55,1,57,10],[61,1,63,10],[58,1,60,10],[2,4,2,6],[2,10,2,11],[2,22,2,26],[64,1,64,10],[65,1,65,10],[5,13,5,14],[6,13,6,14],[10,13,10,14],[11,13,11,14],[15,13,15,14],[16,13,16,14],[20,13,20,14],[21,13,21,14],[25,13,25,14],[26,13,26,14],[30,13,30,14],[31,13,31,14],[35,13,35,14]]}
[null,null,null,null,null,null,null,null,null,null,null,null,1000,null,null,null,"Number of Registers after Smart Meter take up",null,"Take up Smart metes. Assumed all Customers will convert within 7 years"]
[null,null,null,null,"Volumes - Registers",null,null,null,null,null,null,null,2500,null,null,"New Connections",null,null,"Number of Registers changed to Smart Meters (only 1 register per smart meter)"]
[null,null,null,"Meter Asset Class","Previous Determination",null,null,"Unknown ","Current","Annual change","Forecast Volumes",null,0,"Register to Meters ratio",null,"Replace Con",{"$f":"10000/2","v":5000},10000,"Rounding",{"$f":"Q3","v":5000},{"$f":"R3","v":10000},null,"Meter Trending volumes for Reset RIN"]
[null,null,null,null,{"$f":"'Master Data'!B29","v":"2010-11"},{"$f":"'Master Data'!C29","v":"2011-12"},{"$f":"'Master Data'!D29","v":"2012-13"},{"$f":"'Master Data'!E29","v":"2013-14"},{"$f":"'Master Data'!F29","v":"2014-15"},4,{"$f":"'Master Data'!G29","v":"2015-16"},{"$f":"'Master Data'!H29","v":"2016-17"},"Jul - Dec 17",null,null,null,{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"},null,{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"},null,{"$f":"I4","v":"2014-15"},{"$f":"K4","v":"2015-16"},{"$f":"L4","v":"2016-17"},{"$f":"Q4","v":"2017-18"},{"$f":"R4","v":"2018-19"}]
[]
[null,"Business LV - Single Phase","LV - Single Phase","Mechanical",22981,22981,22981,null,{"$f":"'Registar data Pivot'!C11","v":18205},{"$f":"ROUND((I6-E6)/$J$4,0)","v":-1194},{"$f":"I6+J6","v":17011},{"$f":"K6+J6","v":15817},{"$f":"L6-(ROUND(L9/$L$45*$M$2,0))","v":15719},1,null,{"$f":"M6/N6","v":15719},{"$f":"M6-ROUND((($P6/$P$45)*Q$3),0)*N6","v":15534},{"$f":"Q6-ROUND((($P6/$P$45)*R$3),0)*$N6","v":15164},null,{"$f":"Q6-M6","v":-185},{"$f":"R6-Q6","v":-370},null,{"$f":"I6/$N6","v":18205},{"$f":"K6/$N6","v":17011},{"$f":"L6/$N6","v":15817},{"$f":"Q6/$N6","v":15534},{"$f":"R6/$N6","v":15164}]
[null,"Business LV - Single Phase","LV - Single Phase","Electronic",2750,2750,2750,null,{"$f":"'Registar data Pivot'!D11","v":3928},{"$f":"ROUND((I7-E7)/$J$4,0)","v":295},{"$f":"I7+J7","v":4223},{"$f":"K7+J7","v":4518},{"$f":"SUM(L7)+(ROUND(L9/$L$45*$M$2,0))+(ROUND(L9/$L$45*$M$1,0))","v":4655},1,null,{"$f":"M7/N7","v":4655},{"$f":"M7-ROUND((($P7/$P$45)*Q$3),0)*N7","v":4600},4490,null,{"$f":"Q7-M7","v":-55},{"$f":"R7-Q7","v":-110},null,{"$f":"I7/$N7","v":3928},{"$f":"K7/$N7","v":4223},{"$f":"L7/$N7","v":4518},{"$f":"Q7/$N7","v":4600},{"$f":"R7/$N7","v":4490}]
[null,"Business LV - Single Phase","LV - Single Phase","Smart",null,null,null,null,null,null,null,null,{"$f":"(ROUND(L9/$L$45*$M$3,0))","v":0},null,null,null,{"$f":"M8-ROUND((($P8/$P$45)*Q$3),0)*N8","v":0},{"$f":"Q8-ROUND((($P8/$P$45)*R$3),0)*$N8","v":0},null,{"$f":"Q8-M8","v":0},{"$f":"R8-Q8","v":0}]
[null,null,null,null,{"$f":"SUM(E6:E7)","v":25731},{"$f":"SUM(F6:F7)","v":25731},25731,0,{"$f":"SUM(I6:I7)","v":22133},{"$f":"SUM(J6:J7)","v":-899},21234,20335,{"$f":"SUM(M6:M8)","v":20374},null,null,{"$f":"SUM(P6:P8)","v":20374},{"$f":"SUM(Q6:Q8)","v":20134},19654,null,{"$f":"SUM(T6:T8)","v":-240},{"$f":"SUM(U6:U8)","v":-480},null,{"$f":"SUM(W6:W8)","v":22133},{"$f":"SUM(X6:X8)","v":21234},{"$f":"SUM(Y6:Y8)","v":20335},20134,19654]
[]
[null,"Business LV - Multi Phase","LV - Multi Phase","Mechanical",15311,14571,13371,null,{"$f":"'Registar data Pivot'!C12","v":7509},{"$f":"ROUND((I11-E11)/$J$4,0)","v":-1951},{"$f":"I11+J11","v":5558},{"$f":"K11+J11","v":3607},{"$f":"L11-(ROUND(L14/$L$45*$M$2,0))","v":3516},1,null,{"$f":"M11/N11","v":3516},{"$f":"M11-ROUND((($P11/$P$45)*Q$3),0)*N11","v":3475},{"$f":"Q11-ROUND((($P11/$P$45)*R$3),0)*$N11","v":3392},null,{"$f":"Q11-M11","v":-41},{"$f":"R11-Q11","v":-83},null,{"$f":"I11/$N11","v":7509},{"$f":"K11/$N11","v":5558},{"$f":"L11/$N11","v":3607},{"$f":"Q11/$N11","v":3475},{"$f":"R11/$N11","v":3392}]
[null,"Business LV - Multi Phase","LV - Multi Phase","Electronic",8249,10194,12544,null,{"$f":"'Registar data Pivot'!D12","v":12929},1170,{"$f":"I12+J12","v":14099},{"$f":"K12+J12","v":15269},{"$f":"SUM(L12)+(ROUND(L14/$L$45*$M$2,0))+(ROUND(L14/$L$45*$M$1,0))","v":15396},1,null,15396,15215,14852,null,{"$f":"Q12-M12","v":-181},{"$f":"R12-Q12","v":-363},null,{"$f":"I12/$N12","v":12929},{"$f":"K12/$N12","v":14099},{"$f":"L12/$N12","v":15269},{"$f":"Q12/$N12","v":15215},{"$f":"R12/$N12","v":14852}]
[null,"Business LV - Multi Phase","LV - Multi Phase","Smart",null,null,null,null,null,null,null,null,{"$f":"(ROUND(L14/$L$45*$M$3,0))","v":0},null,null,null,{"$f":"M13-ROUND((($P13/$P$45)*Q$3),0)*N13","v":0},{"$f":"Q13-ROUND((($P13/$P$45)*R$3),0)*$N13","v":0},null,{"$f":"Q13-M13","v":0},{"$f":"R13-Q13","v":0}]
[null,null,null,null,{"$f":"SUM(E11:E12)","v":23560},{"$f":"SUM(F11:F12)","v":24765},25915,0,{"$f":"SUM(I11:I12)","v":20438},{"$f":"SUM(J11:J12)","v":-781},19657,18876,{"$f":"SUM(M11:M13)","v":18912},null,null,{"$f":"SUM(P11:P13)","v":18912},{"$f":"SUM(Q11:Q13)","v":18690},{"$f":"SUM(R11:R13)","v":18244},null,{"$f":"SUM(T11:T13)","v":-222},{"$f":"SUM(U11:U13)","v":-446},null,{"$f":"SUM(W11:W13)","v":20438},{"$f":"SUM(X11:X13)","v":19657},{"$f":"SUM(Y11:Y13)","v":18876},18690,18244]
[]
[null,"Business LV - CT Meters","LV - CT Meters","Mechanical",808,808,732,null,{"$f":"'Registar data Pivot'!C13","v":602},{"$f":"ROUND((I16-E16)/$J$4,0)","v":-52},{"$f":"I16+J16","v":550},{"$f":"K16+J16","v":498},{"$f":"L16-(ROUND(L19/$L$45*$M$2,0))","v":487},1,null,{"$f":"M16/N16","v":487},{"$f":"M16-ROUND((($P16/$P$45)*Q$3),0)*N16","v":481},{"$f":"Q16-ROUND((($P16/$P$45)*R$3),0)*$N16","v":470},null,{"$f":"Q16-M16","v":-6},{"$f":"R16-Q16","v":-11},null,{"$f":"I16/$N16","v":602},{"$f":"K16/$N16","v":550},{"$f":"L16/$N16","v":498},{"$f":"Q16/$N16","v":481},{"$f":"R16/$N16","v":470}]
[null,"Business LV - CT Meters","LV - CT Meters","Electronic",1278,1478,1754,null,{"$f":"'Registar data Pivot'!D13","v":1645},92,{"$f":"I17+J17","v":1737},{"$f":"K17+J17","v":1829},{"$f":"SUM(L17)+(ROUND(L19/$L$45*$M$2,0))+(ROUND(L19/$L$45*$M$1,0))","v":1844},1,null,1844,{"$f":"M17-ROUND((($P17/$P$45)*Q$3),0)*N17","v":1822},1779,null,{"$f":"Q17-M17","v":-22},{"$f":"R17-Q17","v":-43},null,{"$f":"I17/$N17","v":1645},{"$f":"K17/$N17","v":1737},{"$f":"L17/$N17","v":1829},{"$f":"Q17/$N17","v":1822},{"$f":"R17/$N17","v":1779}]
[null,"Business LV - CT Meters","LV - CT Meters","Smart",null,null,null,null,null,null,null,null,{"$f":"(ROUND(L19/$L$45*$M$3,0))","v":0},null,null,null,{"$f":"M18-ROUND((($P18/$P$45)*Q$3),0)*N18","v":0},{"$f":"Q18-ROUND((($P18/$P$45)*R$3),0)*$N18","v":0},null,{"$f":"Q18-M18","v":0},{"$f":"R18-Q18","v":0}]
[null,null,null,null,{"$f":"SUM(E16:E17)","v":2086},{"$f":"SUM(F16:F17)","v":2286},2486,0,{"$f":"SUM(I16:I17)","v":2247},{"$f":"SUM(J16:J17)","v":40},2287,2327,{"$f":"SUM(M16:M18)","v":2331},null,null,{"$f":"SUM(P16:P18)","v":2331},{"$f":"SUM(Q16:Q18)","v":2303},{"$f":"SUM(R16:R18)","v":2249},null,{"$f":"SUM(T16:T18)","v":-28},{"$f":"SUM(U16:U18)","v":-54},null,{"$f":"SUM(W16:W18)","v":2247},{"$f":"SUM(X16:X18)","v":2287},{"$f":"SUM(Y16:Y18)","v":2327},2303,2249]
[]
[null,"Domestic LV - Single Phase","LV - Single Phase","Mechanical",291517,274697,268777,null,{"$f":"'Registar data Pivot'!C8","v":259105},{"$f":"ROUND((I21-E21)/$J$4,0)","v":-8103},{"$f":"I21+J21","v":251002},{"$f":"K21+J21","v":242899},{"$f":"L21-(ROUND(L24/$L$45*$M$2,0))","v":240825},1,null,{"$f":"M21/N21","v":240825},{"$f":"M21-ROUND((($P21/$P$45)*Q$3),0)*N21","v":237989},{"$f":"Q21-ROUND((($P21/$P$45)*R$3),0)*$N21","v":232317},null,{"$f":"Q21-M21","v":-2836},{"$f":"R21-Q21","v":-5672},null,{"$f":"I21/$N21","v":259105},{"$f":"K21/$N21","v":251002},{"$f":"L21/$N21","v":242899},{"$f":"Q21/$N21","v":237989},{"$f":"R21/$N21","v":232317}]
[null,"Domestic LV - Single Phase","LV - Single Phase","Electronic",84087,106227,118077,null,{"$f":"'Registar data Pivot'!D8","v":153105},17255,{"$f":"I22+J22","v":170360},{"$f":"K22+J22","v":187615},{"$f":"SUM(L22)+(ROUND(L24/$L$45*$M$2,0))+(ROUND(L24/$L$45*$M$1,0))","v":190519},2,null,95259.5,{"$f":"M22-ROUND((($P22/$P$45)*Q$3),0)*N22","v":188275},183787,null,{"$f":"Q22-M22","v":-2244},{"$f":"R22-Q22","v":-4488},null,{"$f":"I22/$N22","v":76552.5},{"$f":"K22/$N22","v":85180},{"$f":"L22/$N22","v":93807.5},{"$f":"Q22/$N22","v":94137.5},{"$f":"R22/$N22","v":91893.5}]
[null,"Domestic LV - Single Phase","LV - Single Phase","Smart",null,null,null,null,null,null,null,null,{"$f":"(ROUND(L24/$L$45*$M$3,0))","v":0},null,null,null,{"$f":"M23-ROUND((($P23/$P$45)*Q$3),0)*N23","v":0},{"$f":"Q23-ROUND((($P23/$P$45)*R$3),0)*$N23","v":0},null,{"$f":"Q23-M23","v":0},{"$f":"R23-Q23","v":0}]
[null,null,null,null,{"$f":"SUM(E21:E22)","v":375604},{"$f":"SUM(F21:F22)","v":380924},386854,0,{"$f":"SUM(I21:I22)","v":412210},{"$f":"SUM(J21:J22)","v":9152},421362,430514,{"$f":"SUM(M21:M23)","v":431344},null,null,{"$f":"SUM(P21:P23)","v":336084.5},{"$f":"SUM(Q21:Q23)","v":426264},{"$f":"SUM(R21:R23)","v":416104},null,{"$f":"SUM(T21:T23)","v":-5080},{"$f":"SUM(U21:U23)","v":-10160},null,{"$f":"SUM(W21:W23)","v":335657.5},{"$f":"SUM(X21:X23)","v":336182},{"$f":"SUM(Y21:Y23)","v":336706.5},332126.5,324210.5]
[]
[null,"Domestic LV - Multi Phase","LV - Multi Phase","Mechanical",6140,6140,6140,null,{"$f":"'Registar data Pivot'!C9","v":5700},{"$f":"ROUND((I26-E26)/$J$4,0)","v":-110},{"$f":"I26+J26","v":5590},{"$f":"K26+J26","v":5480},{"$f":"L26-(ROUND(L29/$L$45*$M$2,0))","v":5402},1,null,{"$f":"M26/N26","v":5402},{"$f":"M26-ROUND((($P26/$P$45)*Q$3),0)*N26","v":5338},{"$f":"Q26-ROUND((($P26/$P$45)*R$3),0)*$N26","v":5211},null,{"$f":"Q26-M26","v":-64},{"$f":"R26-Q26","v":-127},null,{"$f":"I26/$N26","v":5700},{"$f":"K26/$N26","v":5590},{"$f":"L26/$N26","v":5480},{"$f":"Q26/$N26","v":5338},{"$f":"R26/$N26","v":5211}]
[null,"Domestic LV - Multi Phase","LV - Multi Phase","Electronic",5158,5158,5158,null,{"$f":"'Registar data Pivot'!D9","v":8909},938,{"$f":"I27+J27","v":9847},{"$f":"K27+J27","v":10785},{"$f":"SUM(L27)+(ROUND(L29/$L$45*$M$2,0))+(ROUND(L29/$L$45*$M$1,0))","v":10894},1,null,{"$f":"M27/N27","v":10894},{"$f":"M27-ROUND((($P27/$P$45)*Q$3),0)*N27","v":10766},10509,null,{"$f":"Q27-M27","v":-128},{"$f":"R27-Q27","v":-257},null,{"$f":"I27/$N27","v":8909},{"$f":"K27/$N27","v":9847},{"$f":"L27/$N27","v":10785},{"$f":"Q27/$N27","v":10766},{"$f":"R27/$N27","v":10509}]
[null,"Domestic LV - Multi Phase","LV - Multi Phase","Smart",null,null,null,null,null,null,null,null,{"$f":"(ROUND(L29/$L$45*$M$3,0))","v":0},null,null,null,{"$f":"M28-ROUND((($P28/$P$45)*Q$3),0)*N28","v":0},{"$f":"Q28-ROUND((($P28/$P$45)*R$3),0)*$N28","v":0},null,{"$f":"Q28-M28","v":0},{"$f":"R28-Q28","v":0}]
[null,null,null,null,{"$f":"SUM(E26:E27)","v":11298},{"$f":"SUM(F26:F27)","v":11298},11298,0,{"$f":"SUM(I26:I27)","v":14609},{"$f":"SUM(J26:J27)","v":828},15437,16265,{"$f":"SUM(M26:M28)","v":16296},null,null,{"$f":"SUM(P26:P28)","v":16296},{"$f":"SUM(Q26:Q28)","v":16104},{"$f":"SUM(R26:R28)","v":15720},null,{"$f":"SUM(T26:T28)","v":-192},{"$f":"SUM(U26:U28)","v":-384},null,{"$f":"SUM(W26:W28)","v":14609},{"$f":"SUM(X26:X28)","v":15437},{"$f":"SUM(Y26:Y28)","v":16265},16104,15720]
[]
[null,"Domestic LV - CT Meters","LV - CT Meters","Mechanical",18,18,18,null,{"$f":"'Registar data Pivot'!C10","v":82},{"$f":"ROUND((I31-E31)/$J$4,0)","v":16},{"$f":"I31+J31","v":98},{"$f":"K31+J31","v":114},{"$f":"L31-(ROUND(L34/$L$45*$M$2,0))","v":113},1,null,{"$f":"M31/N31","v":113},{"$f":"M31-ROUND((($P31/$P$45)*Q$3),0)*N31","v":112},{"$f":"Q31-ROUND((($P31/$P$45)*R$3),0)*$N31","v":109},null,{"$f":"Q31-M31","v":-1},{"$f":"R31-Q31","v":-3},null,{"$f":"I31/$N31","v":82},{"$f":"K31/$N31","v":98},{"$f":"L31/$N31","v":114},{"$f":"Q31/$N31","v":112},{"$f":"R31/$N31","v":109}]
[null,"Domestic LV - CT Meters","LV - CT Meters","Electronic",26,26,26,null,{"$f":"'Registar data Pivot'!D10","v":18},-2,{"$f":"I32+J32","v":16},{"$f":"K32+J32","v":14},{"$f":"SUM(L32)+(ROUND(L34/$L$45*$M$2,0))+(ROUND(L34/$L$45*$M$1,0))","v":15},1,null,15,{"$f":"M32-ROUND((($P32/$P$45)*Q$3),0)*N32","v":15},15,null,{"$f":"Q32-M32","v":0},{"$f":"R32-Q32","v":0},null,{"$f":"I32/$N32","v":18},{"$f":"K32/$N32","v":16},{"$f":"L32/$N32","v":14},{"$f":"Q32/$N32","v":15},{"$f":"R32/$N32","v":15}]
[null,"Domestic LV - CT Meters","LV - CT Meters","Smart",null,null,null,null,null,null,null,null,{"$f":"(ROUND(L34/$L$45*$M$3,0))","v":0},null,null,null,{"$f":"M33-ROUND((($P33/$P$45)*Q$3),0)*N33","v":0},{"$f":"Q33-ROUND((($P33/$P$45)*R$3),0)*$N33","v":0},null,{"$f":"Q33-M33","v":0},{"$f":"R33-Q33","v":0}]
[null,null,null,null,{"$f":"SUM(E31:E32)","v":44},{"$f":"SUM(F31:F32)","v":44},44,0,{"$f":"SUM(I31:I32)","v":100},{"$f":"SUM(J31:J32)","v":14},114,128,{"$f":"SUM(M31:M33)","v":128},null,null,{"$f":"SUM(P31:P33)","v":128},{"$f":"SUM(Q31:Q33)","v":127},{"$f":"SUM(R31:R33)","v":124},null,{"$f":"SUM(T31:T33)","v":-1},{"$f":"SUM(U31:U33)","v":-3},null,{"$f":"SUM(W31:W33)","v":100},{"$f":"SUM(X31:X33)","v":114},{"$f":"SUM(Y31:Y33)","v":128},127,124]
[]
[null,"Other Meters","PAYG","Electronic",950,950,950,null,{"$f":"'Registar data Pivot'!D14","v":30382},null,{"$f":"I36+J36","v":30382},{"$f":"K36+J36","v":30382},{"$f":"SUM(L36)+(ROUND(L44/$L$45*$M$1,0))","v":30441},1,null,{"$f":"M36/N36","v":30441},{"$f":"M36-ROUND((($P36/$P$45)*Q$3),0)*N36","v":30083},{"$f":"Q36-ROUND((($P36/$P$45)*R$3),0)*$N36","v":29366},null,{"$f":"Q36-M36","v":-358},{"$f":"R36-Q36","v":-717},null,{"$f":"I36/$N36","v":30382},{"$f":"K36/$N36","v":30382},{"$f":"L36/$N36","v":30382},{"$f":"Q36/$N36","v":30083},{"$f":"R36/$N36","v":29366}]
[null,"Business LV - Single Phase","LV - Single Phase - Remote Read","Smart",null,null,null,null,null,null,null,null,{"$f":"(ROUND(L36/$L$45*$M$3,0))","v":0},null,null,null,{"$f":"M37-ROUND((($P37/$P$45)*Q$3),0)*N37","v":0},{"$f":"Q37-ROUND((($P37/$P$45)*R$3),0)*$N37","v":0}]
[null,"Business LV - Single Phase","LV - Single Phase - Remote Read","Electronic",1,1,1,null,0]
[null,"Business LV - Multi Phase","LV - Multi Phase - Remote Read","Electronic",1,1,1,null,0]
[null,"Business LV - CT Meters","LV - CT Meters - Remote Read","Electronic",1,1,1,null,0]
[null,"Domestic LV - Single Phase","LV - Single Phase - Remote Read","Electronic",1,1,1,null,0]
[null,"Domestic LV - Multi Phase","LV - Multi Phase - Remote Read","Electronic",1,1,1,null,0]
[null,"Domestic LV - CT Meters","LV - CT Meters - Remote Read","Electronic",1,1,1,null,0]
[null,null,null,null,{"$f":"SUM(E36:E43)","v":956},{"$f":"SUM(F36:F43)","v":956},956,0,{"$f":"SUM(I36:I43)","v":30382},{"$f":"SUM(J36:J43)","v":0},{"$f":"SUM(K36:K43)","v":30382},30382,{"$f":"SUM(M36:M43)","v":30441},null,null,30441,{"$f":"SUM(Q36:Q43)","v":30083},{"$f":"SUM(R36:R43)","v":29366},null,{"$f":"SUM(T36:T43)","v":-358},{"$f":"SUM(U36:U43)","v":-717},null,{"$f":"SUM(W36:W43)","v":30382},{"$f":"SUM(X36:X43)","v":30382},{"$f":"SUM(Y36:Y43)","v":30382},30083,29366]
[null,"Total",null,null,{"$f":"E9+E14+E19+E24+E29+E34+E44","v":439279},{"$f":"F9+F14+F19+F24+F29+F34+F44","v":446004},453284,0,{"$f":"I9+I14+I19+I24+I29+I34+I44","v":502119},{"$f":"J9+J14+J19+J24+J29+J34+J44","v":8354},{"$f":"K9+K14+K19+K24+K29+K34+K44","v":510473},518827,{"$f":"M9+M14+M19+M24+M29+M34+M44","v":519826},null,null,424566.5,{"$f":"Q9+Q14+Q19+Q24+Q29+Q34+Q44","v":513705},{"$f":"R9+R14+R19+R24+R29+R34+R44","v":501461},null,{"$f":"T9+T14+T19+T24+T29+T34+T44","v":-6121},{"$f":"U9+U14+U19+U24+U29+U34+U44","v":-12244},null,{"$f":"W9+W14+W19+W24+W29+W34+W44","v":425566.5},{"$f":"X9+X14+X19+X24+X29+X34+X44","v":425293},{"$f":"Y9+Y14+Y19+Y24+Y29+Y34+Y44","v":425019.5},419567.5,409567.5]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M45-L45","v":999},null,null,"Check Calculation",{"$f":"M45-Q45","v":6121},{"$f":"Q45-R45","v":12244},null,{"$f":"Q45-M45=T45","v":true},{"$f":"R45-Q45=U45","v":true},null,null,null,null,396000]
[null,null,null,null,null,null,null,"LV - Single Phase",{"$f":"SUMIF($C$5:$C$45,$H47,I$5:I$45)","v":434343},null,"Mechanical",{"$f":"SUMIF($D$5:$D$45,$K47,L$5:L$45)","v":268415},{"$f":"SUMIF($D$5:$D$45,$K47,M$5:M$45)","v":266062},null,null,"Check Calculation",{"$f":"(M45-Q45+Q2)=-T45","v":true},{"$f":"(Q45-R45)=-U45","v":true}]
[null,null,null,null,null,null,null,"LV - Multi Phase",{"$f":"SUMIF($C$5:$C$45,$H48,I$5:I$45)","v":35047},null,"Electronic",{"$f":"SUMIF($D$5:$D$45,$K48,$L$5:$L$45)","v":250412},{"$f":"SUMIF($D$5:$D$45,$K48,M$5:M$45)","v":253764},null,null,null,null,null,null,null,null,"LV - Single Phase",{"$f":"SUMIF($C$5:$C$45,$V48,W$5:W$45)+W51","v":388172.5},{"$f":"SUMIF($C$5:$C$45,$V48,X$5:X$45)+X51","v":387798},{"$f":"SUMIF($C$5:$C$45,$V48,Y$5:Y$45)+Y51","v":387423.5},{"$f":"SUMIF($C$5:$C$45,$V48,Z$5:Z$45)+Z51","v":382343.5},{"$f":"SUMIF($C$5:$C$45,$V48,AA$5:AA$45)+AA51","v":373230.5}]
[null,null,null,null,null,null,null,"LV - CT Meters",{"$f":"SUMIF($C$5:$C$45,$H49,I$5:I$45)","v":2347},null,"Smart",{"$f":"SUMIF($D$5:$D$45,$K49,$L$5:$L$45)","v":0},{"$f":"SUMIF($D$5:$D$45,$K49,M$5:M$45)","v":0},null,null,null,null,null,null,null,null,"LV - Multi Phase",{"$f":"SUMIF($C$5:$C$45,$V49,W$5:W$45)","v":35047},35094,35141,34794,33964]
[null,null,null,null,null,null,null,"PAYG",{"$f":"SUMIF($C$5:$C$45,$H50,I$5:I$45)","v":30382},null,null,{"$f":"SUM(L47:L49)","v":518827},{"$f":"SUM(M47:M49)","v":519826},null,null,null,null,null,null,null,null,"LV - CT Meters",2347,2401,2455,2430,2373]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I47:I50)","v":502119},null,null,null,{"$f":"M50-L50","v":999},null,null,null,null,null,null,null,null,"PAYG",30382,30382,30382,30083,29366]
[null,"Volume Assumptions",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I4","v":"2014-15"},"2 yr Average","2 yr Average"]
[null,"Based on previous averages there are 2,000 new connections each year, 5,000 meter replacements carried out by TasNetworks for old meters and 5,000 alterations that are customer driven (solar for example) . Therefore there are around 12,000 normal meter changes annually, 10,000 of which are replacements of TasNetworks regulated meters.",null,null,null,null,null,null,null,null,null,null,"Business LV - Single Phase","Mechanical",null,{"$f":"AVERAGE(I6,K6)","v":17608},{"$f":"AVERAGE(Q6:R6)","v":15349},{"$f":"AVERAGE(R6:R6)","v":15164}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Electronic",null,null,{"$f":"AVERAGE(Q7:R7)","v":4545},{"$f":"AVERAGE(R7:R7)","v":4490}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Smart",null,null,{"$f":"AVERAGE(Q8:R8)","v":0},{"$f":"AVERAGE(R8:R8)","v":0}]
[null,"During the period of July 2017 & December 2017 TasNetworks is assumed to not perform any replacements because of the rule change for meters. It is assumed that there will be the same level of new connections and customer driven alterations resulting in 1,000 new connections and 2,500 alterations.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q53:Q55)","v":19894},{"$f":"SUM(R53:R55)","v":19654}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Business LV - Multi Phase","Mechanical",null,null,{"$f":"AVERAGE(Q11:R11)","v":3433.5},{"$f":"AVERAGE(R11:R11)","v":3392}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Electronic",null,null,15033.5,{"$f":"AVERAGE(R12:R12)","v":14852}]
[null,"For the second half of 2017/18 and future years the same level of 10,000 regulated meters being replaced annually is assumed to continue. For this scenario there is no accelerated take up given the smart meter is more expensive resulting in little incentive for customers to move.",null,null,null,null,null,null,null,null,null,null,null,"Smart",null,null,0,{"$f":"AVERAGE(R13:R13)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q57:Q59)","v":18467},{"$f":"SUM(R57:R59)","v":18244}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Business LV - CT Meters","Mechanical",null,null,{"$f":"AVERAGE(Q16:R16)","v":475.5},{"$f":"AVERAGE(R16:R16)","v":470}]
[null,"The take up and alterations have been evenly spread across the various meter types as there are no indications that there will be variable numbers.",null,null,null,null,null,null,null,null,null,null,null,"Electronic",null,null,1800.5,{"$f":"AVERAGE(R17:R17)","v":1779}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Smart",null,null,0,{"$f":"AVERAGE(R18:R18)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q61:Q63)","v":2276},{"$f":"SUM(R61:R63)","v":2249}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Domestic LV - Single Phase","Mechanical",null,null,{"$f":"AVERAGE(Q21:R21)","v":235153},{"$f":"AVERAGE(R21:R21)","v":232317}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Electronic",null,null,186031,{"$f":"AVERAGE(R22:R22)","v":183787}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Smart",null,null,0,{"$f":"AVERAGE(R23:R23)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q65:Q67)","v":421184},{"$f":"SUM(R65:R67)","v":416104}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Domestic LV - Multi Phase","Mechanical",null,null,{"$f":"AVERAGE(Q26:R26)","v":5274.5},{"$f":"AVERAGE(R26:R26)","v":5211}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Electronic",null,null,10637.5,{"$f":"AVERAGE(R27:R27)","v":10509}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Smart",null,null,0,{"$f":"AVERAGE(R28:R28)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q69:Q71)","v":15912},{"$f":"SUM(R69:R71)","v":15720}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Domestic LV - CT Meters","Mechanical",null,null,{"$f":"AVERAGE(Q31:R31)","v":110.5},{"$f":"AVERAGE(R31:R31)","v":109}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Electronic",null,null,15,{"$f":"AVERAGE(R32:R32)","v":15}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Smart",null,null,0,{"$f":"AVERAGE(R33:R33)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q73:Q75)","v":125.5},{"$f":"SUM(R73:R75)","v":124}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Other Meters","Electronic"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PAYG","Electronic",null,null,{"$f":"AVERAGE(Q36:R36)","v":29724.5},{"$f":"AVERAGE(R36:R36)","v":29366}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Smart",null,null,{"$f":"AVERAGE(Q37:R37)","v":0},{"$f":"AVERAGE(R37:R37)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q79:Q81)","v":29724.5},{"$f":"SUM(R79:R81)","v":29366}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q56+Q60+Q64+Q68+Q72+Q76+Q82","v":507583},{"$f":"R56+R60+R64+R68+R72+R76+R82","v":501461}]

{"sheet":"Corporate OH","index":5,"n_rows":43,"n_cols":18,"rows_kept":43,"cut":false,"hidden":false,"merged":[[2,0,2,2],[0,0,0,7]]}
[{"$f":"\"Overheads to be Allocated (Corporate and Shared Costs) - \"","v":"Overheads to be Allocated (Corporate and Shared Costs) - "}]
[]
["Annual Overheads to be Allocated",null,null,{"$f":"SUM(G8:G17)","v":2625548.5524979965}]
[]
["This data has been extracted from the step trend workpaper. The network direct overheads are applied to the various forms of control."]
[]
["WC Code","Form of Control","Labour","Material","Contractor","Other","Overheads","Total Including OH","Labour2","Material2","Contractor2","Other2","Total Network Opex","Total (Network Services + OH + Network opex)","inc Actual Provisions","RIN subsubsub category","Service Classification","RIN Sub Sub Sub Category Work Level Description"]
["REVMT","Alternative Control Metering",0,0,0,0,0,0,0,0,0,0,0,0,null,"Opex Alternative Control Metering","Alternative Control","Alternative Control Metering"]
["MDSMR","Alternative Control Metering",1356519.063516093,1278.5428121730515,217481.88352085638,196354.35656131757,2473318.1666980311,4244952.0131084714,0,0,0,0,0,4244952.0131084714,null,"Opex Alternative Control Metering","Alternative Control","Alternative Control Metering"]
["INTMT","Alternative Control Metering",0,0,0,0,0,0,0,0,0,0,0,0,null,"Opex Alternative Control Metering","Alternative Control","Alternative Control Metering"]
["DEPMT","Alternative Control Metering",0,0,0,0,0,0,0,0,0,0,0,0,null,"Opex Alternative Control Metering","Alternative Control","Alternative Control Metering"]
["ARMER","Alternative Control Metering",31034.047737218669,1428.3586063290052,79119.367182317423,2866.4865270098771,45308.530361627563,159756.79041450255,0,0,0,0,0,159756.79041450255,null,"Opex Alternative Control Metering","Alternative Control","Alternative Control Metering"]
["AIMET","Alternative Control Metering",68526.625724271449,0,0,3182.0507003684957,105883.45459820311,177592.13102284307,0,0,0,0,0,177592.13102284307,null,"Opex Alternative Control Metering","Alternative Control","Alternative Control Metering"]
["ADMET","Alternative Control Metering",1975.9233727457727,0,0,200.97211936880578,1038.4008401345911,3215.2963322491696,0,0,0,0,0,3215.2963322491696,null,"Opex Alternative Control Metering","Alternative Control","Alternative Control Metering"]
[]
[]
[]
[]
[]
[]
[]
["DD17 CAPEX OH",null,"Amount","Internal Overheads","Capitalised Overheads (Real$)","Total Capex including Ohs and capitalised labour"]
["Financial Year 2015/16","HV Metering",17642.975538152685,8104.0536253454302,3883.2380749803751,29630.267238478489,{"$f":"'Master Data'!I29","v":"2017-18"},"Financial Year 2017/18",{"$f":"SUMIF($A$23:$A$68,H23,$E$23:$E$68)","v":117457.06431118738}]
["Financial Year 2015/16","HV/LV Metering",11761.98369210179,5402.7024168969538,2588.8253833202498,19753.511492318994,{"$f":"'Master Data'!J29","v":"2018-19"},"Financial Year 2018/19",{"$f":"SUMIF($A$23:$A$68,H24,$E$23:$E$68)","v":0}]
["Financial Year 2015/16","Business LV Metering",509012.40415354061,150048.30217138713,112034.18290593461,771094.88923086238]
["Financial Year 2015/16","Domestic LV Metering",2025852.7905263663,415104.54752661492,445892.39912877709,2886849.737181758]
["Financial Year 2015/16","Off Peak Metering",129773.11001419609,14508.236900357357,28563.20243861249,172844.54935316596]
["Financial Year 2016/17","HV Metering",16932.740393676733,3961.3881219963951,3360.0647191083563,24254.193234781484]
["Financial Year 2016/17","HV/LV Metering",11288.493595784488,2640.9254146642634,2240.0431460722375,16169.462156520989]
["Financial Year 2016/17","Business LV Metering",299145.08028828894,69984.523488602979,59361.143370914288,428490.74714780622]
["Financial Year 2016/17","Domestic LV Metering",778906.05810912978,182223.85361183417,154562.9770789844,1115692.8887999484]
["Financial Year 2016/17","Off Peak Metering",22576.987191568976,5281.8508293285267,4480.086292144475,32338.924313041978]
["Financial Year 2017/18","Wholesale Metering",31686.770364696666,12904.695252563091,6228.757058928777,50820.222676188539]
["Financial Year 2017/18","HV Metering",8487.5661306391867,2016.7390357697245,1668.424608783879,12172.729775192789]
["Financial Year 2017/18","HV/LV Metering",5658.3774204261254,1344.4926905131497,1112.2830725225863,8115.1531834618618]
["Financial Year 2017/18","Business LV Metering",149947.00164129233,35629.056298598472,29475.501421848534,215051.55936173935]
["Financial Year 2017/18","Domestic LV Metering",390428.04200940259,92769.995645407325,76747.532004058434,559945.56965886836]
["Financial Year 2017/18","Off Peak Metering",11316.754840852251,2688.9853810262994,2224.5661450451726,16230.306366923724]
["Financial Year 2018/19","HV Metering",0,0,0,0]
["Financial Year 2018/19","HV/LV Metering",0,0,0,0]
["Financial Year 2018/19","Business LV Metering",0,0,0,0]
["Financial Year 2018/19","Domestic LV Metering",0,0,0,0]
["Financial Year 2018/19","Off Peak Metering",0,0,0,0]

{"sheet":"Building Block Inputs","index":6,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[[2,0,2,7],[16,0,16,7]]}
["Input Variables"]
[{"$f":"\"Opening Regulated Asset Base for \"&'Master Data'!I29&\" ($m Nominal)\"","v":"Opening Regulated Asset Base for 2017-18 ($m Nominal)"}]
["The below Regulated Asset base numbers have been calculated using the Metering RFM. This process includes getting the previous determination asset base, adding in expenditure from the completed RIN's and forecast expenditure to get an opening Regulsted Asset Base for 2017."]
["Asset Class Name","2017-18 \nOpening Asset Value","Remaining Life","Standard Life","Opening Tax Value","Tax Remaining Life","Tax Standard Life","Base Financial Year"]
["Meters - Electronic",29.290532547219364,9.851418029969647,15,{"$f":"B5","v":29.290532547219364},"n/a","n/a"]
["Meters - Mechanical",13.646999766548452,15.024484868075424,30,{"$f":"B6","v":13.646999766548452},"n/a","n/a"]
["Non Network - Motor Vehicles",0.42431739631684612,3.7064082490062242,6,{"$f":"B7","v":0.42431739631684612},{"$f":"C7","v":3.7064082490062242},{"$f":"D7","v":6}]
["Non Network - Minor Assets",1.2333626649411047,3.7165259237332653,5,1.2333626649411047,{"$f":"C8","v":3.7165259237332653},5]
["Non Network - Non-System Property",1.1522301723634629,21.483131735183537,40,1.1522301723634629,{"$f":"C9","v":21.483131735183537},40]
["Non Network - Spare Parts",0.64162130103638559,"n/a",5,0.64162130103638559,{"$f":"C10","v":"n/a"},5]
["Non Network - NEM Assets",0.47089845211627157,1.8080291341030139,5,0.47089845211627157,{"$f":"C11","v":1.8080291341030139},5]
["Other assets - A"]
["Other assets - B"]
["Other assets - C"]
["Total",{"$f":"SUM(B5:B14)","v":46.859962300541888},null,null,{"$f":"SUM(E5:E14)","v":46.859962300541888}]
[]
[]
["Forecast Capital Expenditure – As Incurred ($m Real 2014-15)"]
["Year",null,{"$f":"'Master Data'!F$29","v":"2014-15"},{"$f":"'Master Data'!G$29","v":"2015-16"},{"$f":"'Master Data'!H$29","v":"2016-17"},{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"}]
[{"$f":"A5","v":"Meters - Electronic"},null,4.4066188081316797,2.4033748979398823,2.3831892202829783,0.63177706431118741,0]
["Meters - Mechanical",null,0,0,0,0,0]
["Non Network - Motor Vehicles",null,9.069716026016332E-2,6.4414800177999554E-2,6.4414800177999554E-2,8.5409592571028231E-2,0]
["Non Network - Minor Assets",null,0.29249834183902673,0.29630808081879789,0.48858931119767146,0.72938566190179943,0]
["Non Network - Non-System Property",null,0.11110402131870009,9.0180720249199375E-2,8.7981190487023769E-2,4.5566017636643565E-2,0]
["Non Network - Spare Parts",null,0,0,0,0,0]
["Non Network - NEM Assets",null,0,0,0,0,0]
["Other assets - A"]
["Other assets - B"]
["Other assets - C"]
["Total",null,{"$f":"SUM(C20:C29)","v":4.900918331549569},2.8542784991858796,3.0241745221456728,1.4921383364206584,0]
[]
[]
["Forecast Operating and Maintenance Expenditure ($m Real 2014-15)"]
["Year",null,{"$f":"'Master Data'!F$29","v":"2014-15"},{"$f":"'Master Data'!G$29","v":"2015-16"},{"$f":"'Master Data'!H$29","v":"2016-17"},{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"}]
["Avoidable Opex","Net of POW OH",null,null,null,2.4316800000000001,2.3498839999999999]
["Unavoidable Opex",null,null,null,null,0,0]
["Corporate Overheads",null,null,null,null,{"$f":"'Corporate OH'!D3/1000000","v":2.6255485524979965},{"$f":"F37","v":2.6255485524979965}]
[]
[]
[]
["Total",null,{"$f":"SUM(C35:C40)","v":0},0,0,5.0572285524979961,4.9754325524979963]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"1000/64","v":15.625}]

{"sheet":"Unit Costs","index":7,"n_rows":87,"n_cols":14,"rows_kept":87,"cut":false,"hidden":false,"merged":[[68,3,68,7],[58,3,58,7],[5,9,5,10],[40,10,40,13],[16,9,17,13],[18,11,18,13],[39,3,39,7],[37,3,38,7]]}
[]
[null,null,null,null,"KM travel",20]
[null,null,null,null,"Rate",0.75]
[null,null,null,null,"Rate of occurance",0.1]
[]
[null,"Contracted Instal costs",null,null,"Instal cost","Travel costs (outside range)","Process fee","Total Cost",null,"Prices for the meters to buy"]
[null,"Business LV - Single Phase","New Installation Electronic","New Connections",85,{"$f":"$F$2*$F$3*$F$4","v":1.5},7,{"$f":"SUM(E7:G7)","v":93.5},null,"MK6E CT 1A CLS0.5",1096]
[null,"Business LV - Single Phase","New Installation Electronic","Additions",85,{"$f":"$F$2*$F$3*$F$4","v":1.5},7,{"$f":"SUM(E8:G8)","v":93.5},null,"MK6E CT 5A CLS0.5",988]
[null,"Business LV - Single Phase","Abolishments Mechanical",null,85,1.5,7,93.5,null,"MK7A WITH PAYGUARD",158]
[null,"Business LV - Single Phase","Electronic Replacing Mechanical","Network Replacement",85,1.5,7,93.5,null,"MK7C",104]
[null,"Domestic LV - Single Phase","New Installation Electronic","New Connections",85,1.5,7,93.5,null,"MK10A WC 10/100A",236]
[null,"Domestic LV - Single Phase","New Installation Electronic","Additions",85,1.5,7,93.5,null,"MK10D",301]
[null,"Domestic LV - Single Phase","Abolishments Mechanical",null,85,1.5,7,93.5,null,"MK10A CT 3G",422]
[null,"Domestic LV - Single Phase","Electronic Replacing Mechanical","Network Replacement",85,1.5,7,93.5,null,"MK10E",301]
[null,"Business LV - Multi Phase","New Installation Electronic","New Connections",85,1.5,7,93.5]
[null,"Business LV - Multi Phase","New Installation Electronic","Additions",85,1.5,7,93.5]
[null,"Business LV - Multi Phase","Abolishments Mechanical",null,85,1.5,7,93.5,null,"Use the old quoted prices for Mechanical due to there being no current price as they are not installed anymore"]
[null,"Business LV - Multi Phase","Electronic Replacing Mechanical","Network Replacement",85,1.5,7,93.5]
[null,"Domestic LV - Multi Phase","New Installation Electronic","New Connections",85,1.5,7,93.5,null,null,null,"2011/12"]
[null,"Domestic LV - Multi Phase","New Installation Electronic","Additions",85,1.5,7,93.5,null,null,null,"Meter Cost","Install Costs","Total Cost"]
[null,"Domestic LV - Multi Phase","Abolishments Mechanical",null,85,1.5,7,93.5]
[null,"Domestic LV - Multi Phase","Electronic Replacing Mechanical",null,85,1.5,7,93.5,null,"LV - Single Phase","Mechanical",61.195097452867721,88.365261290083069,134.41958707881452]
[null,"Other Meters (PAYG)","New Installation Electronic","New Connections",227,1.5,7,{"$f":"SUM(E23:G23)","v":235.5}]
[null,"Other Meters (PAYG)","Electronic Replacing Electronic","Network Replacement",227,1.5,7,235.5,null,"LV - Multi Phase","Mechanical",263.69523811508458,66.576566725405058,296.83667519636708]
[]
[null,null,null,null,null,null,null,null,null,"LV - CT Meters","Mechanical",263.69523811508458,66.576566725405058,296.83667519636708]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Costs per meter"]
[]
[null,null,null,"Expenses in 2014/15 costs or converted to 2014/15"]
[null,null,null,"Purch cost","On-costs","Purch+on-cost","Install Costs","Total Cost",null,null,"Can't buy Mechanical Meters therefore index 2010 quote"]
[null,"LV - Single Phase","Electronic",{"$f":"K9","v":158},{"$f":"D42*$D$53","v":17.853999999999999},{"$f":"SUM(D42:E42)","v":175.85399999999998},{"$f":"$H$7","v":93.5},{"$f":"SUM(F42:G42)","v":269.35399999999998},null,null,"2010 quote","CPI Value","Indexed Cost"]
[null,"LV - Single Phase","Mechanical",{"$f":"L22*'Master Data'!F$32","v":66.029075666452343},{"$f":"D43*$D$53","v":7.4612855503091149},{"$f":"SUM(D43:E43)","v":73.490361216761457},{"$f":"M22*'Master Data'!F$32","v":95.345489538644458},{"$f":"SUM(F43:G43)","v":168.83585075540591},null,null,61.195097452867721,{"$f":"'Master Data'!$B$31","v":0.89482987976808059},{"$f":"K43/L43","v":68.387409536132267}]
[null,"LV - Multi Phase","Electronic",{"$f":"K12","v":301},34.012999999999998,{"$f":"SUM(D44:E44)","v":335.01299999999998},{"$f":"$H$15","v":93.5},428.51299999999998]
[null,"LV - Multi Phase","Mechanical",{"$f":"L24*'Master Data'!F$32","v":284.52528968998558},32.151357734968371,316.67664742495396,{"$f":"M24*'Master Data'!F$32","v":71.835642803088291},388.51229022804227,null,null,169.12207357859532,{"$f":"'Master Data'!$B$31","v":0.89482987976808059},{"$f":"K45/L45","v":188.99913536909148}]
[null,"LV - CT Meters","Electronic",{"$f":"K13","v":422},47.686,469.68599999999998,{"$f":"$H$7","v":93.5},563.18599999999992]
[null,"LV - CT Meters","Mechanical",{"$f":"L26*'Master Data'!F$32","v":284.52528968998558},32.151357734968371,316.67664742495396,{"$f":"M26*'Master Data'!F$32","v":71.835642803088291},388.51229022804227,null,null,169.12207357859532,{"$f":"'Master Data'!$B$31","v":0.89482987976808059},{"$f":"K47/L47","v":188.99913536909148}]
[null,"Other Meters","Electronic",{"$f":"K9","v":158},17.853999999999999,175.85399999999998,{"$f":"H23","v":235.5},411.35399999999998]
[]
[null,null,null,null,"Source data"]
[null,"Purch price","Electronic",null,"From 2010 EDMI contract, as per the inventory officer and confirmed with the Metering team leader"]
[null,null,"Mechanical+Other"]
[null,"On-costs - ","Handling fee ",0.113,"Confirmed  by the inventory officer the warehouse fee is 11.3%"]
[null,"Installation costs","all meters"]
[]
[]
[]
[null,"Meter data inputs - per Register"]
[null,"Purchase Costs",null,"Escalated Costs"]
[null,"Meter Type",null,{"$f":"'Master Data'!F$29","v":"2014-15"},{"$f":"'Master Data'!G$29","v":"2015-16"},{"$f":"'Master Data'!H$29","v":"2016-17"},{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"}]
[null,"LV - Single Phase","Electronic",{"$f":"($F42)*'Master Data'!F$31","v":175.85399999999998},{"$f":"($F42)*'Master Data'!G$31","v":180.25034999999997},{"$f":"($F42)*'Master Data'!H$31","v":184.75660874999997},{"$f":"($F42)*'Master Data'!I$31","v":189.37552396874997},{"$f":"($F42)*'Master Data'!J$31","v":194.10991206796868}]
[null,"LV - Single Phase","Mechanical",{"$f":"($F43)*'Master Data'!F$31","v":73.490361216761457},{"$f":"($F43)*'Master Data'!G$31","v":75.327620247180491},{"$f":"($F43)*'Master Data'!H$31","v":77.210810753359993},{"$f":"($F43)*'Master Data'!I$31","v":79.141081022194001},{"$f":"($F43)*'Master Data'!J$31","v":81.119608047748841}]
[null,"LV - Multi Phase","Electronic",{"$f":"($F44)*'Master Data'!F$31","v":335.01299999999998},{"$f":"($F44)*'Master Data'!G$31","v":343.38832499999995},{"$f":"($F44)*'Master Data'!H$31","v":351.97303312499997},{"$f":"($F44)*'Master Data'!I$31","v":360.77235895312492},{"$f":"($F44)*'Master Data'!J$31","v":369.79166792695304}]
[null,"LV - Multi Phase","Mechanical",{"$f":"($F45)*'Master Data'!F$31","v":316.67664742495396},{"$f":"($F45)*'Master Data'!G$31","v":324.5935636105778},{"$f":"($F45)*'Master Data'!H$31","v":332.70840270084221},{"$f":"($F45)*'Master Data'!I$31","v":341.02611276836325},{"$f":"($F45)*'Master Data'!J$31","v":349.55176558757233}]
[null,"LV - CT Meters","Electronic",{"$f":"($F46)*'Master Data'!F$31","v":469.68599999999998},{"$f":"($F46)*'Master Data'!G$31","v":481.42814999999996},{"$f":"($F46)*'Master Data'!H$31","v":493.46385374999994},{"$f":"($F46)*'Master Data'!I$31","v":505.80045009374993},{"$f":"($F46)*'Master Data'!J$31","v":518.44546134609357}]
[null,"LV - CT Meters","Mechanical",{"$f":"($F47)*'Master Data'!F$31","v":316.67664742495396},{"$f":"($F47)*'Master Data'!G$31","v":324.5935636105778},{"$f":"($F47)*'Master Data'!H$31","v":332.70840270084221},{"$f":"($F47)*'Master Data'!I$31","v":341.02611276836325},{"$f":"($F47)*'Master Data'!J$31","v":349.55176558757233}]
[null,"Other Meters","Electronic",{"$f":"($F48)*'Master Data'!F$31","v":175.85399999999998},{"$f":"($F48)*'Master Data'!G$31","v":180.25034999999997},{"$f":"($F48)*'Master Data'!H$31","v":184.75660874999997},{"$f":"($F48)*'Master Data'!I$31","v":189.37552396874997},{"$f":"($F48)*'Master Data'!J$31","v":194.10991206796868}]
[]
[null,"Installation Costs",null,"Escalated Costs"]
[null,"Meter Type",null,{"$f":"'Master Data'!F$29","v":"2014-15"},{"$f":"'Master Data'!G$29","v":"2015-16"},{"$f":"'Master Data'!H$29","v":"2016-17"},{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"}]
[null,"LV - Single Phase","Electronic",{"$f":"($G42)*'Master Data'!F$31","v":93.5},{"$f":"($G42)*'Master Data'!G$31","v":95.837499999999991},{"$f":"($G42)*'Master Data'!H$31","v":98.233437499999994},{"$f":"($G42)*'Master Data'!I$31","v":100.68927343749999},{"$f":"($G42)*'Master Data'!J$31","v":103.20650527343747}]
[null,"LV - Single Phase","Mechanical",{"$f":"($G43)*'Master Data'!F$31","v":95.345489538644458},{"$f":"($G43)*'Master Data'!G$31","v":97.729126777110565},{"$f":"($G43)*'Master Data'!H$31","v":100.17235494653832},{"$f":"($G43)*'Master Data'!I$31","v":102.67666382020178},{"$f":"($G43)*'Master Data'!J$31","v":105.24358041570682}]
[null,"LV - Multi Phase","Electronic",{"$f":"($G44)*'Master Data'!F$31","v":93.5},{"$f":"($G44)*'Master Data'!G$31","v":95.837499999999991},{"$f":"($G44)*'Master Data'!H$31","v":98.233437499999994},{"$f":"($G44)*'Master Data'!I$31","v":100.68927343749999},{"$f":"($G44)*'Master Data'!J$31","v":103.20650527343747}]
[null,"LV - Multi Phase","Mechanical",{"$f":"($G45)*'Master Data'!F$31","v":71.835642803088291},{"$f":"($G45)*'Master Data'!G$31","v":73.631533873165495},{"$f":"($G45)*'Master Data'!H$31","v":75.472322219994624},{"$f":"($G45)*'Master Data'!I$31","v":77.359130275494493},{"$f":"($G45)*'Master Data'!J$31","v":79.293108532381851}]
[null,"LV - CT Meters","Electronic",{"$f":"($G46)*'Master Data'!F$31","v":93.5},{"$f":"($G46)*'Master Data'!G$31","v":95.837499999999991},{"$f":"($G46)*'Master Data'!H$31","v":98.233437499999994},{"$f":"($G46)*'Master Data'!I$31","v":100.68927343749999},{"$f":"($G46)*'Master Data'!J$31","v":103.20650527343747}]
[null,"LV - CT Meters","Mechanical",{"$f":"($G47)*'Master Data'!F$31","v":71.835642803088291},{"$f":"($G47)*'Master Data'!G$31","v":73.631533873165495},{"$f":"($G47)*'Master Data'!H$31","v":75.472322219994624},{"$f":"($G47)*'Master Data'!I$31","v":77.359130275494493},{"$f":"($G47)*'Master Data'!J$31","v":79.293108532381851}]
[null,"Other Meters","Electronic",{"$f":"($G48)*'Master Data'!F$31","v":235.5},{"$f":"($G48)*'Master Data'!G$31","v":241.38749999999999},{"$f":"($G48)*'Master Data'!H$31","v":247.42218749999998},{"$f":"($G48)*'Master Data'!I$31","v":253.60774218749998},{"$f":"($G48)*'Master Data'!J$31","v":259.94793574218744}]
[]
[null,"Total Costs",null,{"$f":"'Master Data'!F$29","v":"2014-15"},{"$f":"'Master Data'!G$29","v":"2015-16"},{"$f":"'Master Data'!H$29","v":"2016-17"},{"$f":"'Master Data'!I$29","v":"2017-18"},{"$f":"'Master Data'!J$29","v":"2018-19"}]
[null,"Meter Type"]
[null,"LV - Single Phase","Electronic",{"$f":"SUM(D61,D71)","v":269.35399999999998},276.08784999999995,282.99004624999998,290.06479740624997,297.31641734140612]
[null,"LV - Single Phase","Mechanical",168.83585075540591,173.05674702429104,177.38316569989831,181.81774484239577,186.36318846345566]
[null,"LV - Multi Phase","Electronic",428.51299999999998,439.22582499999993,450.20647062499995,461.46163239062491,472.99817320039051]
[null,"LV - Multi Phase","Mechanical",388.51229022804227,398.2250974837433,408.18072492083684,418.38524304385771,428.84487411995417]
[null,"LV - CT Meters","Electronic",563.18599999999992,577.26564999999994,591.69729124999992,606.48972353124987,621.65196661953109]
[null,"LV - CT Meters","Mechanical",388.51229022804227,398.2250974837433,408.18072492083684,418.38524304385771,428.84487411995417]
[null,"Other Meters","Electronic",411.35399999999998,421.63784999999996,432.17879624999995,442.98326615624995,454.05784781015609]

{"sheet":"Registar data Pivot","index":8,"n_rows":34,"n_cols":16,"rows_kept":34,"cut":false,"hidden":false,"merged":[[16,3,16,14]]}
[]
[]
[]
[null,"Data received from the metering team leader as well ast the allocation into the vaious options"]
[]
[]
[null,null,"mech","elec",null,null,"Types of meters ","Pivot Data","Check"]
["Domestic","single",{"$f":"SUM(J33:M33,O33)","v":259105},{"$f":"SUM(J30:M32)","v":153105},{"$f":"SUM(C8:D8)","v":412210},null,{"$f":"E8+E11+E14","v":464725},{"$f":"SUMIF($A$19:$A$33,B8,$P$19:$P$33)","v":464725},{"$f":"G8-H8","v":0}]
["Domestic","multi",{"$f":"SUM(J29:M29)","v":5700},{"$f":"SUM(J26:M28)","v":8909},{"$f":"SUM(C9:D9)","v":14609},null,{"$f":"E9+E12","v":35047},{"$f":"SUMIF($A$19:$A$33,B9,$P$19:$P$33)","v":35047},{"$f":"G9-H9","v":0}]
["Domestic","CT",{"$f":"SUM(J22:M22)","v":82},{"$f":"SUM(J19:M21)","v":18},100,null,{"$f":"E10+E13","v":2347},{"$f":"SUMIF($A$19:$A$33,B10,$P$19:$P$33)","v":2347},0]
["Business ","single",{"$f":"SUM(D33:I33)","v":18205},{"$f":"SUM(D30:I32)","v":3928},22133,null,{"$f":"SUM(G8:G10)","v":502119},{"$f":"SUM(H8:H10)","v":502119}]
["Business ","multi",{"$f":"SUM(D29:I29)","v":7509},{"$f":"SUM(D26:I28)","v":12929},20438]
["Business ","CT",{"$f":"SUM(D22:I22)","v":602},{"$f":"SUM(D19:I21)","v":1645},2247]
["res","other (payg)",0,{"$f":"SUM(O30:O32)","v":30382},30382]
[null,null,{"$f":"SUM(C8:C14)","v":291203},{"$f":"SUM(D8:D14)","v":210916},{"$f":"SUM(C15:D15)","v":502119}]
[null,null,"NA / Errors"]
[null,null,null,"Typers of meters and the tarrif applied to it. Colours represent the alignments with the summary table"]
[null,null,"Row Labels","Sum of TAS22","Sum of TAS34","Sum of TAS73","Sum of TAS75","Sum of TAS82","Sum of TAS94","Sum of TAS31","Sum of TAS41","Sum of TAS61","Sum of TAS63","Sum of TAS93","Sum of TAS101"]
["CT","elec","MM10",75,0,0,151,0,102,0,1,0,0,0,0,{"$f":"SUM(D19:M19,O19)","v":329}]
["CT","elec","MM12",677,1,0,350,14,19,8,2,4,0,0,0,{"$f":"SUM(D20:M20,O20)","v":1075}]
["CT","elec","MM9",101,0,0,96,12,47,3,0,0,0,0,0,259]
["CT","mech","MM11",599,2,1,0,0,0,35,32,15,0,0,0,684]
["HV","elec","MM13",0,0,0,0,0,0,0,0,0,0,0,0]
["HV","elec","MM15",0,0,0,0,0,0,0,0,0,0,0,0]
["HV","mech","MM14",0,0,0,0,0,0,0,0,0,0,0,0]
["multi","elec","MM5",1006,0,0,1317,4,210,957,228,23,0,0,0,{"$f":"SUM(D26:M26,O26)","v":3745}]
["multi","elec","MM6",370,0,0,409,11,174,242,132,44,0,0,0,{"$f":"SUM(D27:M27,O27)","v":1382}]
["multi","elec","MM8",8418,1,1,567,59,382,4300,1970,1012,1,0,0,16711]
["multi","mech","MM7",7445,7,2,24,3,28,2578,2488,632,2,0,0,13209]
["single","elec","MM1",2132,4,0,3,0,121,44391,38442,2012,0,0,8411,95516]
["single","elec","MM4",1640,0,0,1,0,1,31765,31565,3887,0,0,1511,70370]
["single","elec payg","MM2",26,0,0,0,0,0,431,505,107,0,0,20460,21529]
["single","mech","MM3",18177,15,0,3,0,10,123774,118622,16603,1,0,105,277310]
[null,null,"Grand Total",40671,30,4,2922,103,1095,208484,193988,24339,4,1,30487,{"$f":"SUM(P19:P33)","v":502119}]

{"sheet":"Master Data","index":9,"n_rows":71,"n_cols":16,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
["Previous Year",{"$f":"EOMONTH($B$2,-12)","v":"2014-06-30"},null,{"$f":"TEXT(B1,\"YY\")","v":"14"},{"$f":"TEXT(B1,\"YYy\")","v":"2014"},{"$f":"TEXT(B1,\"mmm\")","v":"Jun"},{"$f":"TEXT(B1,\"mmmm\")","v":"June"}]
["Current Year",{"$f":"EOMONTH($B$3,-1)","v":"2015-06-30"},null,{"$f":"TEXT(B2,\"YY\")","v":"15"},{"$f":"TEXT(B2,\"YYy\")","v":"2015"},{"$f":"TEXT(B2,\"mmm\")","v":"Jun"},{"$f":"TEXT(B2,\"mmmm\")","v":"June"},{"$f":"E1&\"-\"&D2","v":"2014-15"}]
["Year Start","2015-07-01",2015,{"$f":"TEXT(B3,\"YY\")","v":"15"},{"$f":"TEXT(B3,\"YYy\")","v":"2015"},{"$f":"TEXT(B3,\"mmm\")","v":"Jul"},{"$f":"TEXT(B3,\"mmmm\")","v":"July"}]
["Year 1",{"$f":"EOMONTH($B$3,11)","v":"2016-06-30"},null,{"$f":"TEXT(B4,\"YY\")","v":"16"},{"$f":"TEXT(B4,\"YYy\")","v":"2016"},{"$f":"TEXT(B4,\"mmm\")","v":"Jun"},{"$f":"TEXT(B4,\"mmmm\")","v":"June"},{"$f":"E3&\"-\"&D4","v":"2015-16"}]
["Year 2",{"$f":"EOMONTH($B$3,23)","v":"2017-06-30"},null,{"$f":"TEXT(B5,\"YY\")","v":"17"},{"$f":"TEXT(B5,\"YYy\")","v":"2017"},{"$f":"TEXT(B5,\"mmm\")","v":"Jun"},{"$f":"TEXT(B5,\"mmmm\")","v":"June"},{"$f":"E4&\"-\"&D5","v":"2016-17"}]
["Year 3",{"$f":"EOMONTH($B$3,35)","v":"2018-06-30"},null,"18","2018","Jun","June","2017-18"]
["Year 4",{"$f":"EOMONTH($B$3,47)","v":"2019-06-30"},null,"19","2019","Jun","June","2018-19"]
["Year 5",{"$f":"EOMONTH($B$3,59)","v":"2020-06-30"},null,"20","2020","Jun","June","2019-20"]
["Year 6",{"$f":"EOMONTH($B$3,71)","v":"2021-06-30"},null,"21","2021","Jun","June","2020-21"]
["Year 7",{"$f":"EOMONTH($B$3,83)","v":"2022-06-30"},null,"22","2022","Jun","June","2021-22"]
["Year 8",{"$f":"EOMONTH($B$3,95)","v":"2023-06-30"},null,"23","2023","Jun","June","2022-23"]
["Year 9",{"$f":"EOMONTH($B$3,107)","v":"2024-06-30"},null,"24","2024","Jun","June","2023-24"]
["Year 10",{"$f":"EOMONTH($B$3,119)","v":"2025-06-30"},null,"25","2025","Jun","June","2024-25"]
[]
[]
[]
[]
["Year",null,null,null,null,"Current",{"$f":"A4","v":"Year 1"},{"$f":"A5","v":"Year 2"},{"$f":"A6","v":"Year 3"},{"$f":"A7","v":"Year 4"},{"$f":"A8","v":"Year 5"},{"$f":"A9","v":"Year 6"},{"$f":"A10","v":"Year 7"},{"$f":"A11","v":"Year 8"},{"$f":"A12","v":"Year 9"},{"$f":"A13","v":"Year 10"}]
[null,null,null,null,null,{"$f":"C3","v":2015},{"$f":"F19+1","v":2016},{"$f":"G19+1","v":2017},2018,2019,2020,2021,2022,2023,2024,{"$f":"O19+1","v":2025}]
[null,null,null,null,null,{"$f":"H2","v":"2014-15"},{"$f":"H4","v":"2015-16"},{"$f":"H5","v":"2016-17"},{"$f":"H6","v":"2017-18"},{"$f":"H7","v":"2018-19"},{"$f":"H8","v":"2019-20"},{"$f":"H9","v":"2020-21"},{"$f":"H10","v":"2021-22"},{"$f":"H11","v":"2022-23"},{"$f":"H12","v":"2023-24"},{"$f":"H13","v":"2024-25"}]
[]
[null,{"$f":"EOMONTH(C22,-12)","v":"2011-06-30"},"2012-06-30","2013-06-30",{"$f":"EOMONTH(F22,-12)","v":"2014-06-30"},{"$f":"B2","v":"2015-06-30"},{"$f":"B4","v":"2016-06-30"},{"$f":"B5","v":"2017-06-30"},{"$f":"B6","v":"2018-06-30"},{"$f":"B7","v":"2019-06-30"},{"$f":"B8","v":"2020-06-30"},{"$f":"B9","v":"2021-06-30"},{"$f":"B10","v":"2022-06-30"},{"$f":"B11","v":"2023-06-30"},{"$f":"B12","v":"2024-06-30"},{"$f":"B13","v":"2025-06-30"}]
["Index",null,{"$f":"C22-B22","v":366},365,365,365,{"$f":"G22-F22","v":366},{"$f":"H22-G22","v":365},{"$f":"I22-H22","v":365},365,366,365,365,365,366,365]
["Inflation rate",null,null,null,null,null,{"$f":"C36","v":2.5000000000000001E-2},{"$f":"G24","v":2.5000000000000001E-2},{"$f":"H24","v":2.5000000000000001E-2},2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2]
["Salary costs EBA/award increases ",null,null,null,null,null,{"$f":"G24+1%","v":3.5000000000000003E-2},{"$f":"H24+1%","v":3.5000000000000003E-2},3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2]
[]
[null,null,null,null,null,"2012-13"]
[null,null,"Year -1","Year -2","Year -1",{"$f":"'Master Data'!F18","v":"Current"},{"$f":"'Master Data'!G18","v":"Year 1"},{"$f":"'Master Data'!H18","v":"Year 2"},{"$f":"'Master Data'!I18","v":"Year 3"},{"$f":"'Master Data'!J18","v":"Year 4"},{"$f":"'Master Data'!K18","v":"Year 5"},{"$f":"'Master Data'!L18","v":"Year 6"},{"$f":"'Master Data'!M18","v":"Year 7"},{"$f":"'Master Data'!N18","v":"Year 8"},{"$f":"'Master Data'!O18","v":"Year 9"},{"$f":"'Master Data'!P18","v":"Year 10"}]
[null,"2010-11","2011-12","2012-13","2013-14",{"$f":"'Master Data'!F20","v":"2014-15"},{"$f":"'Master Data'!G20","v":"2015-16"},{"$f":"'Master Data'!H20","v":"2016-17"},{"$f":"'Master Data'!I20","v":"2017-18"},{"$f":"'Master Data'!J20","v":"2018-19"},{"$f":"'Master Data'!K20","v":"2019-20"},{"$f":"'Master Data'!L20","v":"2020-21"},{"$f":"'Master Data'!M20","v":"2021-22"},{"$f":"'Master Data'!N20","v":"2022-23"},{"$f":"'Master Data'!O20","v":"2023-24"},{"$f":"'Master Data'!P20","v":"2024-25"}]
["CPI    (consistent with AER RFM)",2.6548672566371723E-2,3.1034482758620641E-2,2.5999999999999999E-2,2.5999999999999999E-2,{"$f":"'Master Data'!$C$36","v":2.5000000000000001E-2},{"$f":"'Master Data'!$C$36","v":2.5000000000000001E-2},{"$f":"'Master Data'!$C$36","v":2.5000000000000001E-2},{"$f":"'Master Data'!$C$36","v":2.5000000000000001E-2},{"$f":"'Master Data'!$C$36","v":2.5000000000000001E-2},{"$f":"'Master Data'!$C$36","v":2.5000000000000001E-2},{"$f":"'Master Data'!$C$36","v":2.5000000000000001E-2},{"$f":"'Master Data'!$C$36","v":2.5000000000000001E-2},{"$f":"'Master Data'!$C$36","v":2.5000000000000001E-2},{"$f":"'Master Data'!$C$36","v":2.5000000000000001E-2},{"$f":"'Master Data'!$C$36","v":2.5000000000000001E-2}]
["Cumulative CPI",{"$f":"C31-(C31*B30)","v":0.89482987976808059},{"$f":"D31-(D31*C30)","v":0.91923433103448282},{"$f":"E31-(E31*D30)","v":0.94867599999999996},{"$f":"F31-(F31*E30)","v":0.97399999999999998},1,{"$f":"F31*(1+G$30)","v":1.0249999999999999},1.0506249999999999,1.0768906249999999,1.1038128906249998,1.1314082128906247,1.1596934182128902,1.1886857536682123,1.2184028975099175,1.2488629699476652,1.2800845441963566]
[null,null,1,{"$f":"C32*(1+D30)","v":1.026},{"$f":"D32*(1+E30)","v":1.0526759999999999},1.0789928999999998]
["2017/18 dollars",null,null,null,null,null,null,null,1,{"$f":"I33*(1+J30)","v":1.0249999999999999},{"$f":"J33*(1+K30)","v":1.0506249999999999},{"$f":"K33*(1+L30)","v":1.0768906249999999},{"$f":"L33*(1+M30)","v":1.1038128906249998},1.1314082128906247,1.1596934182128902]
["2016/17 dollars",null,null,null,null,null,null,1,{"$f":"H34*(1+I30)","v":1.0249999999999999},{"$f":"I34*(1+J30)","v":1.0506249999999999},1.0768906249999999,1.1038128906249998,1.1314082128906247,1.1596934182128902,{"$f":"N34*(1+O30)","v":1.1886857536682123}]
["General"]
["Inflation Rate (f)",null,2.5000000000000001E-2]
["WACC - discount rate",null,{"$f":"C51","v":6.2300000000000001E-2}]
["Scenario Risk Factor",null,0,0.3]
["Nominal Tax Rate",null,0.3]
["Useful Life",null,7,"years"]
["All $$ are assumed ex GST"]
[]
["Definitions"]
[]
["Model Rounding",100]
[]
[]
[null,null,"Distribution","Transmission"]
["Post-tax Nominal Return on Equity(pre-imp)",null,8.6900000000000005E-2]
["Post-tax Real Return on Equity(pre-imp)",null,5.935672514619883E-2]
["Nominal Vanilla WACC",null,6.2300000000000001E-2,6.4819999999999989E-2]
["Real Vanilla WACC",null,3.6400000000000002E-2,3.8848780487804907E-2]
["Post-tax Nominal WACC ",null,5.5100000000000003E-2,5.8253375736001201E-2]
["Post-tax Real WACC ",null,2.9399999999999999E-2,3.2442317791220754E-2]
["Pre-tax Nominal WACC ",null,6.7799999999999999E-2,6.8002719363145253E-2]
["Pre-tax Real WACC ",null,4.1700000000000001E-2,4.1953872549409965E-2]
["Nominal Tax Allowance",null,1.2699999999999999E-2,9.7493436271440526E-3]
["Real Tax Allowance",null,1.24E-2,9.5115547581892113E-3]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Asset Lives (yrs)","Current","Proposed"]
["Meter Type","2012/13 - 16/17","2017-22"]
["Mechanical",30,30]
["Electronic",15,15]

{"sheet":"SinglePhases","index":10,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Phase","1"]
["CT",1]
[]
[null,"Values"]
["WASP","Sum of Domestic","Sum of Business"]
["MM1",84845,2508]
["MM2",1043,26]
["MM3",258999,18128]
["MM4",67217,1646]
["Grand Total",412104,22308]

{"sheet":"MultiPhases","index":11,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["Phase","3"]
["CT",1]
[]
[null,"Values"]
["WASP","Sum of Domestic","Sum of Business"]
["MM10",1,6]
["MM11",57,16]
["MM12",0,3]
["MM14",1,0]
["MM5",1208,5598]
["MM6",418,2149]
["MM7",5700,7612]
["MM8",7283,11434]
["Grand Total",14668,26818]

{"sheet":"CTs","index":12,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Phase","(All)"]
["CT","(Multiple Items)"]
[]
[null,"Values"]
["WASP","Sum of Domestic","Sum of Business"]
["MM10",0,828]
["MM11",25,587]
["MM12",14,1824]
["MM13",0,3]
["MM14",0,2]
["MM15",0,6]
["MM3",1,103]
["MM5",0,1]
["MM6",0,3]
["MM7",0,9]
["MM8",0,11]
["MM9",3,566]
["Grand Total",43,3943]