{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["NOTES","Model update","Prop2020DistTar","2020TarContForm","2020RebalContForm","ARS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":30,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"NOTES","index":0,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[]
["The model has actual and test data to illustrate the workings of the model.",null,null,{"$f":"'Model update'!B5","v":2020}]
[]
["Issue","Location","Item","Comment"]
[]
[1,"'Model update'!C25","CPI",{"$f":"\"Updated June \"&D2-1&\" CPI for \"&D2","v":"Updated June 2019 CPI for 2020"},"NOTE: This worksheet is programmed to update for each year - use as checklist and note any placeholders or changes"]
[null,null,null,null,"NOTE: Worksheet names in this file are programmed to update each year once each worksheet is accessed and a cell is selected"]
[{"$f":"A6+1","v":2},"'Model update'!B34",{"$f":"\"Xt for \"&D2","v":"Xt for 2020"},{"$f":"\"Updated for \"&D2&\" annual update \"","v":"Updated for 2020 annual update "}]
[]
[{"$f":"A8+1","v":3},"'Model update'!B44",{"$f":"\"Pass Through Amount for \"&D2","v":"Pass Through Amount for 2020"},"NIL for 2020"]
[]
[{"$f":"A10+1","v":4},"'Model update'!H79:H83","Real Pre-tax WACC (rptw)",{"$f":"\"Updated for \"&$D$2&\" annual update\"","v":"Updated for 2020 annual update"}]
[]
[{"$f":"A12+1","v":5},{"$f":"\"Prop\"&D2&\"DistTar!E8:E96\"","v":"Prop2020DistTar!E8:E96"},{"$f":"D2-1&\" tariffs\"","v":"2019 tariffs"},{"$f":"\"Updated from \"&D2-1&\" model\"","v":"Updated from 2019 model"}]
[]
[{"$f":"A14+1","v":6},"ARS!B6:B12",{"$f":"D2-1&\" ARS tariffs\"","v":"2019 ARS tariffs"},{"$f":"\"Updated from \"&D2-1&\" model\"","v":"Updated from 2019 model"}]
[]
[{"$f":"A16+1","v":7},"The following is test data to illustrate the workings of the model.",null,"Input data required from DNSPs"]
[null,{"$f":"\"Prop\"&D2&\"DistTar!D8:D96\"","v":"Prop2020DistTar!D8:D96"},{"$f":"\"Proposed \"&D2&\" Tariffs\"","v":"Proposed 2020 Tariffs"}]
[null,{"$f":"\"Prop\"&D2&\"DistTar!F8:F96\"","v":"Prop2020DistTar!F8:F96"},{"$f":"\"Actual \"&D2-2&\" Volumes\"","v":"Actual 2018 Volumes"}]
[]
[null,"ARS!C6:C12",{"$f":"\"Proposed \"&D2&\" Ancillary Reference Services Charges\"","v":"Proposed 2020 Ancillary Reference Services Charges"}]

{"sheet":"Model update","index":1,"n_rows":58,"n_cols":2,"rows_kept":58,"cut":false,"hidden":false,"merged":[[54,0,55,1]]}
[]
[]
["Tariff Approval Template for ","MultiNet"]
[]
["Calendar year commencing",2020]
[]
["t",{"$f":"B5","v":2020}]
["t-1",{"$f":"B7-1","v":2019}]
["t-2",2018]
["t-3",2017]
[]
[]
["Please fill in yellow highlighted cells where appropriate"]
[]
["CPI"]
[]
["CPI Index June 2016",108.6]
["CPI Index June 2017",110.7]
["CPI Index June 2018",113]
["CPI Index June 2019",114.8]
["CPI Index June 2020"]
["CPI Index June 2021"]
[]
[]
[{"$f":"\"CPI Index June \" &$B$10","v":"CPI Index June 2017"},{"$f":"VLOOKUP(A25,A$17:D$22,2,FALSE)","v":110.7}]
[{"$f":"\"CPI Index June \" &$B$9","v":"CPI Index June 2018"},{"$f":"VLOOKUP(A26,A$17:D$22,2,FALSE)","v":113}]
[{"$f":"\"CPI Index June \" &$B$8","v":"CPI Index June 2019"},{"$f":"VLOOKUP(A27,A$17:D$22,2,FALSE)","v":114.8}]
[]
[{"$f":"\"CPI \" &$B$8","v":"CPI 2019"},{"$f":"B26/B25-1","v":2.0776874435411097E-2}]
[{"$f":"\"CPI \" &$B$5","v":"CPI 2020"},{"$f":"B27/B26-1","v":1.5929203539823078E-2}]
[]
[]
[{"$f":"\"Xt for \"&B$5","v":"Xt for 2020"}]
[2019,-1.7757344845594263E-2]
[2020,-1.1736521921608076E-2]
[2021,-1.7999999999999999E-2]
[2022,-1.7999999999999999E-2]
[]
[]
[{"$f":"\"Xt for \"&B$5","v":"Xt for 2020"},{"$f":"VLOOKUP(B5,A34:B38,2,FALSE)","v":-1.1736521921608076E-2}]
[]
[]
["Pass Through Amounts :  PT (t)"]
[2019,0]
[2020,0]
[2021,0]
[2022,0]
[]
[]
[{"$f":"\"Pass Through Amount for \"&B$5","v":"Pass Through Amount for 2020"},{"$f":"VLOOKUP(B5,A44:B48,2,FALSE)","v":0}]
["The Pass Through Amount is to include an amount that reflects the time value of money between incurring the costs and recovering the costs"]
["and excludes any amounts already passed through in reference tariffs."]
[]
[]
["Pre-tax WACC for distribution tariffs "]
[]
[]
[" Pretax WACCD",3.9032388807741736E-2]

{"sheet":"Prop2020DistTar","index":2,"n_rows":168,"n_cols":8,"rows_kept":168,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"\"Tariff Approval - \"&'Model update'!B3","v":"Tariff Approval - MultiNet"},{"$f":"\"Prop\"&'Model update'!B5&\"DistTar\"","v":"Prop2020DistTar"}]
[]
[null,{"$f":"\"PROPOSED \"&'Model update'!$B$5&\" DISTRIBUTION TARIFFS\"","v":"PROPOSED 2020 DISTRIBUTION TARIFFS"}]
[]
[null,"Proposed tariff name","Existing name","Prop\n2020 Tariff",{"$f":"\"Exist\n\"&'Model update'!$B$8&\" Tariff\"","v":"Exist\n2019 Tariff"},{"$f":"\"Actual \"&'Model update'!$B$9&\" Volumes\"","v":"Actual 2018 Volumes"},"Prop Tar\nRevenue","Exist Tar\nRevenue"]
[null,"Tariff V - Multinet Residential","Tariff V - Multinet Residential"]
[null,"1 January - 31 December","1 January - 31 December"]
[null,"Fixed Charge","Fixed Charge",0.183,0.18010000000000001,677911,{"$f":"D8*$F8*365","v":45281065.245000005},{"$f":"E8*$F8*365","v":44563496.451500006}]
[null,"Peak 0 - 0.05","Peak 0 - 0.05",8.7502965387832621,8.3680402248471015,3644226.8659199998,{"$f":"D9*$F9","v":31888065.731400751},30495037.002487045]
[null,"Peak 0.05 - 0.1","Peak 0.05 - 0.1",5.8383000000000003,5.7468000000000004,3061316.8703399999,17872886.284106024,17592775.790469911]
[null,"Peak 0.1 -0.15","Peak 0.1 -0.15",3.0185,2.9712000000000001,2663703.46123,8040388.8977227546,7914395.7240065765]
[null,"Peak 0.15 - 0.25","Peak 0.15 - 0.25",1.5276000000000001,1.5036,4323577.4184600003,6604696.8644394968,6500931.0063964566]
[null,"Peak >0.25","Peak >0.25",1.1329,1.1151,8511966.0198999997,9643206.3039447106,9491693.30879049]
[null,"May Shoulder 0 - 0.05","May Shoulder 0 - 0.05",8.3515498907265346,7.9867094258476676,909391.3872,7594827.5403978117,7263044.7639349261]
[null,"May Shoulder 0.05 - 0.1","May Shoulder 0.05 - 0.1",5.5464000000000002,5.4593999999999996,720256.52176999999,3994830.772345128,3932168.4549511378]
[null,"May Shoulder 0.1 -0.15","May Shoulder 0.1 -0.15",2.8685999999999998,2.8235999999999999,580423.26826000004,1665002.187330636,1638883.140258936]
[null,"May Shoulder 0.15 - 0.25","May Shoulder 0.15 - 0.25",1.4513,1.4285000000000001,832054.53486000001,1207560.746442318,1188589.9030475102]
[null,"May Shoulder >0.25","May Shoulder >0.25",1.0912999999999999,1.0742,1271057.5099800001,1387105.060641174,1365369.9772205162]
[null,"Oct Shoulder 0 - 0.05","Oct Shoulder 0 - 0.05",8.3515498907265346,7.9867094258476676,879745.98845000006,7347242.5137067055,7026275.5783052891]
[null,"Oct Shoulder 0.05 - 0.1","Oct Shoulder 0.05 - 0.1",5.5464000000000002,5.4593999999999996,597219.39760999999,3312417.6669041039,3260459.5793120335]
[null,"Oct Shoulder 0.1 -0.15","Oct Shoulder 0.1 -0.15",2.8685999999999998,2.8235999999999999,387562.88742000004,1111762.8988530121,1094322.568919112]
[null,"Oct Shoulder 0.15 - 0.25","Oct Shoulder 0.15 - 0.25",1.4513,1.4285000000000001,417870.95835000003,606456.12185335509,596928.6640029751]
[null,"Oct Shoulder >0.25","Oct Shoulder >0.25",1.0912999999999999,1.0742,483169.19057999999,527282.53767995397,519020.34452103602]
[null,"Off Peak 0 - 0.05","Off Peak 0 - 0.05",7.4725368875245666,7.1461077879984369,4421093.8010300007,33036786.511402875,31593612.843012098]
[null,"Off Peak 0.05 - 0.1","Off Peak 0.05 - 0.1",4.9626999999999999,4.8849,1703421.50667,8453569.9111512098,8321043.7179322829]
[null,"Off Peak 0.1 -0.15","Off Peak 0.1 -0.15",2.5666000000000002,2.5264000000000002,742019.84565999999,1904468.1358709561,1874638.9380754242]
[null,"Off Peak 0.15 - 0.25","Off Peak 0.15 - 0.25",1.2985,1.2781,672243.89884000004,872908.70264373999,859194.9271074041]
[null,"Off Peak >0.25","Off Peak >0.25",0.97660000000000002,0.96130000000000004,1113875.99924,{"$f":"D28*$F28","v":1087811.300857784},{"$f":"E28*$F28","v":1070768.9980694121}]
[null,"Tariff V - Multinet Non-Residential","Tariff V - Multinet Non-Residential"]
[null,"1 January - 31 December","1 January - 31 December"]
[null,"Fixed Charge","Fixed Charge",0.30180000000000001,0.29709999999999998,15893,{"$f":"D31*$F31*365","v":1750725.2010000001},{"$f":"E31*$F31*365","v":1723460.7594999997}]
[null,"Peak 0 - 0.25","Peak 0 - 0.25",3.9961125101069404,3.821572772743568,307852.08324999997,{"$f":"D32*$F32","v":1230211.561137808},1176479.1393805861]
[null,"Peak 0.25 - 1","Peak 0.25 - 1",2.3485999999999998,2.3117999999999999,503329.67335000006,1182120.0708298101,1163597.5388505301]
[null,"Peak 1 - 1.5","Peak 1 - 1.5",1.4092,1.3871,195782.12727,275896.173748884,271569.38873621699]
[null,"Peak 1.5 - 5","Peak 1.5 - 5",0.78420000000000001,0.77190000000000003,650338.59620000003,509995.52714004001,501996.36240678007]
[null,"Peak >5","Peak >5",0.26169999999999999,0.2576,795170.69657999999,208096.17129498598,204835.97143900799]
[null,"May Shoulder 0 - 0.25","May Shoulder 0 - 0.25",3.6673575297524805,3.5070925582600845,74339.004409999994,272627.70757731632,260713.76915477458]
[null,"May Shoulder 0.25 - 1","May Shoulder 0.25 - 1",2.1139000000000001,2.0808,116401.105,246060.29585950001,242207.419284]
[null,"May Shoulder 1 - 1.5","May Shoulder 1 - 1.5",1.3387,1.3177000000000001,44612.173840000003,59722.317119608007,58785.461468968009]
[null,"May Shoulder 1.5 - 5","May Shoulder 1.5 - 5",0.7641,0.75209999999999999,145114.82343000002,110882.23658286301,109140.85870170301]
[null,"May Shoulder >5","May Shoulder >5",0.23530000000000001,0.2316,151403.53863999998,35625.252641991996,35065.059549023994]
[null,"Oct Shoulder 0 - 0.25","Oct Shoulder 0 - 0.25",3.6673575297524805,3.5070925582600845,68871.141530000008,{"$f":"D42*$F42","v":252575.0994726943},241537.46793874007]
[null,"Oct Shoulder 0.25 - 1","Oct Shoulder 0.25 - 1",2.1139000000000001,2.0808,104777.22123000001,221488.56795809703,218020.44193538401]
[null,"Oct Shoulder 1 - 1.5","Oct Shoulder 1 - 1.5",1.3387,1.3177000000000001,40641.859049999999,54407.256710235,53553.777670185002]
[null,"Oct Shoulder 1.5 - 5","Oct Shoulder 1.5 - 5",0.7641,0.75209999999999999,127399.46498999999,97345.931198858991,95817.137618978988]
[null,"Oct Shoulder >5","Oct Shoulder >5",0.23530000000000001,0.2316,119291.88659000001,28069.380914627003,27628.000934244003]
[null,"Off Peak 0 - 0.25","Off Peak 0 - 0.25",3.3260452207808484,3.1806859484169481,341453.58964000002,1135690.079940587,1086056.6346044748]
[null,"Off Peak 0.25 - 1","Off Peak 0.25 - 1",2.0411000000000001,2.0091000000000001,511890.74904999998,1044820.207885955,1028439.703916355]
[null,"Off Peak 1 - 1.5","Off Peak 1 - 1.5",1.2218,1.2025999999999999,189883.52656,231999.692751008,228353.92904105599]
[null,"Off Peak 1.5 - 5","Off Peak 1.5 - 5",0.74039999999999995,0.7288,547490.35448999994,405361.85846439592,399010.97035231197]
[null,"Off Peak >5","Off Peak >5",0.20910000000000001,0.20580000000000001,478141.99687000003,{"$f":"D51*$F51","v":99979.491545517012},{"$f":"E51*$F51","v":98401.622955846018}]
[null,"Tariff V - Yarra Valley Residential","Tariff V - Yarra Valley Residential"]
[null,"1 January - 31 December","1 January - 31 December "]
[null,"Fixed Charge","Fixed Charge",0.183,0.18010000000000001,5449,{"$f":"D54*$F54*365","v":363965.95500000002},{"$f":"E54*$F54*365","v":358198.18849999999}]
[null,"Peak 0 - 0.05","Peak 0 - 0.05",10.427832127329596,9.9722450182235924,29024.731209999998,{"$f":"D55*$F55","v":302665.024598744},289441.73121420131]
[null,"Peak 0.05 - 0.1","Peak 0.05 - 0.1",7.8394000000000004,7.7164999999999999,24230.222730000001,189950.40806956202,186972.513696045]
[null,"Peak 0.1 -0.15","Peak 0.1 -0.15",5.6036999999999999,5.5157999999999996,21044.124029999999,117924.95782691099,116075.17932467398]
[null,"Peak 0.15 - 0.25","Peak 0.15 - 0.25",4.4203999999999999,4.3510999999999997,33858.746659999997,149669.20373586399,147322.79259232598]
[null,"Peak >0.25","Peak >0.25",4.1197999999999997,4.0552000000000001,59278.572299999993,244215.86216153996,240386.46639095998]
[null,"May Shoulder 0 - 0.05","May Shoulder 0 - 0.05",10.079108935895372,9.6387244181659266,7162.3672500000002,72190.279751639362,69036.084104446942]
[null,"May Shoulder 0.05 - 0.1","May Shoulder 0.05 - 0.1",7.6078000000000001,7.4885000000000002,5595.9938099999999,42573.201707717999,41905.599646185001]
[null,"May Shoulder 0.1 -0.15","May Shoulder 0.1 -0.15",5.4839000000000002,5.3978999999999999,4560.0096100000001,25006.636700279003,24614.475873818999]
[null,"May Shoulder 0.15 - 0.25","May Shoulder 0.15 - 0.25",4.3597000000000001,4.2912999999999997,7028.4358099999999,30641.871600857001,30161.126591452998]
[null,"May Shoulder >0.25","May Shoulder >0.25",4.0742000000000003,4.0103,12087.90897,49248.558725574003,48476.141342390998]
[null,"Oct Shoulder 0 - 0.05","Oct Shoulder 0 - 0.05",10.079108935895372,9.6387244181659266,7056.9420599999994,71127.68777704188,68019.919751304144]
[null,"Oct Shoulder 0.05 - 0.1","Oct Shoulder 0.05 - 0.1",7.6078000000000001,7.4885000000000002,4924.0687500000004,37461.330236250004,36873.888834375]
[null,"Oct Shoulder 0.1 -0.15","Oct Shoulder 0.1 -0.15",5.4839000000000002,5.3978999999999999,3190.4222100000002,17495.956357419003,17221.580047359002]
[null,"Oct Shoulder 0.15 - 0.25","Oct Shoulder 0.15 - 0.25",4.3597000000000001,4.2912999999999997,2922.9342299999998,12743.116362531,12543.187661198999]
[null,"Oct Shoulder >0.25","Oct Shoulder >0.25",4.0742000000000003,4.0103,3153.9870699999997,12849.974120593999,12648.434346820999]
[null,"Off Peak 0 - 0.05","Off Peak 0 - 0.05",9.381868410873107,8.9719970705600591,30252.326099999998,283823.34259302198,271423.78114682762]
[null,"Off Peak 0.05 - 0.1","Off Peak 0.05 - 0.1",7.1447000000000003,7.0327000000000002,11025.240600000001,78772.036514820007,77537.209567620012]
[null,"Off Peak 0.1 -0.15","Off Peak 0.1 -0.15",5.2443,5.1620999999999997,4742.1375800000005,24869.192110794003,24479.388401718003]
[null,"Off Peak 0.15 - 0.25","Off Peak 0.15 - 0.25",4.2385000000000002,4.1719999999999997,3472.2586699999997,14717.168372794999,14486.263171239998]
[null,"Off Peak >0.25","Off Peak >0.25",3.9830999999999999,3.9205999999999999,7690.4558999999999,{"$f":"D74*$F74","v":30631.854895289998},{"$f":"E74*$F74","v":30151.201401539998}]
[null,"Tariff V - Yarra Valley Non-Residential","Tariff V - Yarra Valley Non-Residential"]
[null,"1 January - 31 December","1 January - 31 December"]
[null,"Fixed Charge","Fixed Charge",0.3004,0.29570000000000002,70,{"$f":"D77*$F77*365","v":7675.2199999999993},{"$f":"E77*$F77*365","v":7555.1350000000002}]
[null,"Peak 0 - 0.25","Peak 0 - 0.25",6.7072603443387768,6.4142037359270958,1542.6934799999999,{"$f":"D78*$F78","v":10347.246801873986},9895.1502828063713]
[null,"Peak 0.25 - 1","Peak 0.25 - 1",5.1199000000000003,5.0396000000000001,2565.5678100000005,13135.450630419004,12929.435535276003]
[null,"Peak 1 - 1.5","Peak 1 - 1.5",4.3555000000000001,4.2872000000000003,812.33832000000007,3538.1395527600002,3482.6568455040006]
[null,"Peak 1.5 - 5","Peak 1.5 - 5",3.8468,3.7865000000000002,2172.7020600000001,8357.9502844079998,8226.9363501900007]
[null,"Peak >5","Peak >5",3.4214000000000002,3.3677999999999999,8217.7133900000008,28116.084592546005,27675.615154842002]
[null,"May Shoulder 0 - 0.25","May Shoulder 0 - 0.25",6.4395422153776156,6.1582047057071749,357.93822999999998,2304.9583425825422,2204.256892338497]
[null,"May Shoulder 0.25 - 1","May Shoulder 0.25 - 1",4.9287999999999998,4.8514999999999997,578.58330000000001,2851.7213690399999,2806.9968799499998]
[null,"May Shoulder 1 - 1.5","May Shoulder 1 - 1.5",4.298,4.2305999999999999,175.59529000000001,754.70855642000004,742.87343387400006]
[null,"May Shoulder 1.5 - 5","May Shoulder 1.5 - 5",3.8304,3.7703000000000002,427.66823999999997,1638.1404264959999,1612.437565272]
[null,"May Shoulder >5","May Shoulder >5",3.4001000000000001,3.3468,2089.8679400000001,7105.7599827940003,6994.3700215920007]
[null,"Oct Shoulder 0 - 0.25","Oct Shoulder 0 - 0.25",6.4395422153776156,6.1582047057071749,376.46870000000001,2424.2860864183313,2318.3713198914629]
[null,"Oct Shoulder 0.25 - 1","Oct Shoulder 0.25 - 1",4.9287999999999998,4.8514999999999997,512.62018999999998,2526.6023924719998,2486.9768517849998]
[null,"Oct Shoulder 1 - 1.5","Oct Shoulder 1 - 1.5",4.298,4.2305999999999999,126.52008000000001,543.78330384000003,535.25585044800005]
[null,"Oct Shoulder 1.5 - 5","Oct Shoulder 1.5 - 5",3.8304,3.7703000000000002,390.21409,1494.6760503360001,1471.2241835270002]
[null,"Oct Shoulder >5","Oct Shoulder >5",3.4001000000000001,3.3468,599.17699000000005,2037.2616836990003,2005.3255501320002]
[null,"Off Peak 0 - 0.25","Off Peak 0 - 0.25",6.1615311941072965,5.8923716301906968,1664.4567999999999,10255.602494444009,9807.5980279979904]
[null,"Off Peak 0.25 - 1","Off Peak 0.25 - 1",4.8697999999999997,4.7934000000000001,2241.6357900000003,10916.317970142001,10745.056995786001]
[null,"Off Peak 1 - 1.5","Off Peak 1 - 1.5",4.2027999999999999,4.1368999999999998,578.90175999999997,2433.0083169279997,2394.8586909439996]
[null,"Off Peak 1.5 - 5","Off Peak 1.5 - 5",3.8111999999999999,3.7513999999999998,1896.4012599999999,7227.5644821119995,7114.1596867639992]
[null,"Off Peak >5","Off Peak >5",3.3786999999999998,3.3256999999999999,1265.9805000000001,4277.3683153500006,4210.2713488500003]
[null,"Tariff V - South Gippsland Residential","Tariff V - South Gippsland Residential"]
[null,"1 January - 31 December","1 January - 31 December"]
[null,"Fixed Charge","Fixed Charge",0.183,0.18010000000000001,5324,{"$f":"D100*$F100*365","v":355616.58},{"$f":"E100*$F100*365","v":349981.12600000005}]
[null,"Peak 0 - 0.05","Peak 0 - 0.05",11.348840131152924,10.853019777284288,24596.847640000004,{"$f":"D101*$F101","v":279145.69159668614},266950.07389576844]
[null,"Peak 0.05 - 0.1","Peak 0.05 - 0.1",8.5803999999999991,8.4459,18168.29062,155891.20083584799,153447.56574745799]
[null,"Peak 0.1 -0.15","Peak 0.1 -0.15",6.2061999999999999,6.1089000000000002,14198.818019999999,88120.704395723995,86739.159402377991]
[null,"Peak 0.15 - 0.25","Peak 0.15 - 0.25",4.9497,4.8720999999999997,19036.529849999999,94225.111798544996,92747.87708218499]
[null,"Peak >0.25","Peak >0.25",4.6306000000000003,4.5579999999999998,20412.190589999998,94520.689746053991,93038.764709219991]
[null,"May Shoulder 0 - 0.05","May Shoulder 0 - 0.05",10.97839893694638,10.498784911601959,5893.4570400000002,64700.722502875164,61874.137848726343]
[null,"May Shoulder 0.05 - 0.1","May Shoulder 0.05 - 0.1",8.3346,8.2039000000000009,3780.76755,31511.18522223,31017.038903445002]
[null,"May Shoulder 0.1 -0.15","May Shoulder 0.1 -0.15",6.0789999999999997,5.9836999999999998,2390.2720299999996,14530.463670369998,14302.670745910997]
[null,"May Shoulder 0.15 - 0.25","May Shoulder 0.15 - 0.25",4.8853,4.8087,2237.18867,10929.337809551,10757.969157428999]
[null,"May Shoulder >0.25","May Shoulder >0.25",4.5819999999999999,4.5102000000000002,1732.63374,7938.92779668,7814.524694148]
[null,"Oct Shoulder 0 - 0.05","Oct Shoulder 0 - 0.05",10.97839893694638,10.498784911601959,5413.1438699999999,59427.652907945812,56831.433186686634]
[null,"Oct Shoulder 0.05 - 0.1","Oct Shoulder 0.05 - 0.1",8.3346,8.2039000000000009,2609.8348700000001,21751.929707502,21410.824289993005]
[null,"Oct Shoulder 0.1 -0.15","Oct Shoulder 0.1 -0.15",6.0789999999999997,5.9836999999999998,1367.7832599999999,8314.7544375399993,8184.4046928619991]
[null,"Oct Shoulder 0.15 - 0.25","Oct Shoulder 0.15 - 0.25",4.8853,4.8087,1191.74737,5822.043426661,5730.7555781190003]
[null,"Oct Shoulder >0.25","Oct Shoulder >0.25",4.5819999999999999,4.5102000000000002,1400.41932,6416.7213242399994,6316.1712170640003]
[null,"Off Peak 0 - 0.05","Off Peak 0 - 0.05",10.238134122071841,9.790838267753081,21344.004570000001,218522.78148977432,208975.69673105265]
[null,"Off Peak 0.05 - 0.1","Off Peak 0.05 - 0.1",7.8428000000000004,7.7198000000000002,5784.3794900000003,45365.731464172008,44654.252786902005]
[null,"Off Peak 0.1 -0.15","Off Peak 0.1 -0.15",5.8247,5.7333999999999996,2586.1842699999997,15063.747517468999,14827.628893617997]
[null,"Off Peak 0.15 - 0.25","Off Peak 0.15 - 0.25",4.7565,4.6818999999999997,2098.6342100000002,9982.153619865001,9825.5955077990002]
[null,"Off Peak >0.25","Off Peak >0.25",4.4851999999999999,4.4149000000000003,5478.0019400000001,{"$f":"D120*$F120","v":24569.934301287998},{"$f":"E120*$F120","v":24184.830764906001}]
[null,"Tariff V - South Gippsland Non-Residential","Tariff V - South Gippsland Non-Residential"]
[null,"1 January - 31 December","1 January - 31 December"]
[null,"Fixed Charge","Fixed Charge",0.30180000000000001,0.29709999999999998,112,{"$f":"D123*$F123*365","v":12337.584000000001},{"$f":"E123*$F123*365","v":12145.447999999999}]
[null,"Peak 0 - 0.25","Peak 0 - 0.25",7.3978104893600891,7.0746540333436734,2428.1611800000001,{"$f":"D124*$F124","v":17963.076247260971},17178.400285695534]
[null,"Peak 0.25 - 1","Peak 0.25 - 1",5.6927000000000003,5.6033999999999997,4550.35041,25903.779779007,25497.433487393999]
[null,"Peak 1 - 1.5","Peak 1 - 1.5",4.8807,4.8041999999999998,2154.0236,10513.14298452,10348.36017912]
[null,"Peak 1.5 - 5","Peak 1.5 - 5",4.3407999999999998,4.2727000000000004,8849.6441299999988,38414.535239503995,37811.874474250995]
[null,"Peak >5","Peak >5",3.8889999999999998,3.8279999999999998,13120.50102,51025.628466779999,50225.277904559996]
[null,"May Shoulder 0 - 0.25","May Shoulder 0 - 0.25",7.1136237327042773,6.8028577601473694,572.76757999999995,4074.4530504115955,3896.4563763638289]
[null,"May Shoulder 0.25 - 1","May Shoulder 0.25 - 1",5.4896000000000003,5.4035000000000002,1090.4086399999999,5985.907270144,5892.0230862399994]
[null,"May Shoulder 1 - 1.5","May Shoulder 1 - 1.5",4.8198999999999996,4.7443,513.68150000000003,2475.8934618499998,2437.0591404500001]
[null,"May Shoulder 1.5 - 5","May Shoulder 1.5 - 5",4.3231999999999999,4.2553999999999998,2056.1503200000002,8889.1490634239999,8749.7420717280002]
[null,"May Shoulder >5","May Shoulder >5",3.8662000000000001,3.8056000000000001,2889.3577700000001,11170.835010374001,10995.739929512001]
[null,"Oct Shoulder 0 - 0.25","Oct Shoulder 0 - 0.25",7.1136237327042773,6.8028577601473694,554.19888000000003,3942.36230540613,3770.1361514729811]
[null,"Oct Shoulder 0.25 - 1","Oct Shoulder 0.25 - 1",5.4896000000000003,5.4035000000000002,1052.26872,5776.5343653120008,5685.9340285200005]
[null,"Oct Shoulder 1 - 1.5","Oct Shoulder 1 - 1.5",4.8198999999999996,4.7443,482.43288000000001,2325.2782383119998,2288.8063125839999]
[null,"Oct Shoulder 1.5 - 5","Oct Shoulder 1.5 - 5",4.3231999999999999,4.2553999999999998,1964.6681000000001,8493.6531299199996,8360.4486327400009]
[null,"Oct Shoulder >5","Oct Shoulder >5",3.8662000000000001,3.8056000000000001,2202.7962799999996,8516.4509777359981,8382.9615231679982]
[null,"Off Peak 0 - 0.25","Off Peak 0 - 0.25",6.8185265102007593,6.5205997366355799,2968.2225199999998,20238.903940794902,19354.590982187798]
[null,"Off Peak 0.25 - 1","Off Peak 0.25 - 1",5.4268999999999998,5.3418000000000001,5770.2372500000001,31314.500532024998,30823.453342050001]
[null,"Off Peak 1 - 1.5","Off Peak 1 - 1.5",4.7186000000000003,4.6445999999999996,2611.9120400000002,12324.568151944002,12131.286660984]
[null,"Off Peak 1.5 - 5","Off Peak 1.5 - 5",4.3028000000000004,4.2352999999999996,8567.8251200000013,36865.637926336007,36287.309730736]
[null,"Off Peak >5","Off Peak >5",3.8435999999999999,3.7833000000000001,8087.8432400000002,31086.434277264001,30598.737329892003]
[]
[null,"Tariff D - Multinet","Tariff D - Multinet"]
[null,"0 - 50","0 - 50",595.32470000000001,579.19259999999997,3277.68,{"$f":"D146*$F146","v":1951283.8626959999},{"$f":"E146*$F146","v":1898408.0011679998}]
[null,"> 50","> 50",101.2894,98.544700000000006,461.1,{"$f":"D147*$F147","v":46704.54234},{"$f":"E147*$F147","v":45438.961170000002}]
[]
[null,"New Tariff  L- Multinet Non-Residential","New Tariff  L- Multinet Non-Residential"]
[null,"1 January - 31 December","1 January - 31 December"]
[null,"Fixed Charge","Fixed Charge",0,0,13,{"$f":"D151*$F151*365","v":0},{"$f":"E151*$F151*365","v":0}]
[null,"Peak < 5","Peak < 5",0.63770000000000004,0.62039999999999995,6384.22,{"$f":"D152*$F152","v":4071.2170940000005},3960.7700879999998]
[null,"Peak > 5","Peak > 5",0.1368,0.1331,29560.399999999998,4043.8627199999996,3934.4892399999994]
[null,"May Shoulder < 5","May Shoulder < 5",0.56540000000000001,0.55010000000000003,1687.98,954.38389200000006,928.55779800000005]
[null,"May Shoulder > 5","May Shoulder > 5",0.12839999999999999,0.1249,5645.9599999999991,724.94126399999982,705.18040399999984]
[null,"Oct Shoulder < 5","Oct Shoulder < 5",0.56540000000000001,0.55010000000000003,1591.26,899.69840399999998,875.352126]
[null,"Oct Shoulder > 5","Oct Shoulder > 5",0.12839999999999999,0.1249,4686.55,601.75301999999999,585.35009500000001]
[null,"Off Peak < 5","Off Peak < 5",0.44829999999999998,0.43619999999999998,8366.9299999999985,3750.894718999999,3649.6548659999989]
[null,"Off Peak > 5","Off Peak > 5",0.10199999999999999,9.9199999999999997E-2,16302.869999999999,{"$f":"D159*$F159","v":1662.8927399999998},{"$f":"E159*$F159","v":1617.2447039999997}]
[null,"New Tariff L - Multinet","New Tariff L - Multinet"]
[null,"Rolling 12 month max [$/GJ (MHQ/d)]","Rolling 12 month max [$/GJ (MHQ/d)]",0.59289999999999998,0.57679999999999998,43.2,{"$f":"D161*$F161*365","v":9348.8472000000002},{"$f":"E161*$F161*365","v":9094.9824000000008}]
[null,"Peak Demand [$/GJ (MHQ/d)]","Peak Demand [$/GJ (MHQ/d)]",1.7739,1.7258,34.799999999999997,{"$f":"D162*$F162*122","v":7531.269839999999},{"$f":"E162*$F162*122","v":7327.0564799999993}]
[null,"Tariff D - Multinet South Gippsland","Tariff D - Multinet South Gippsland"]
[null,"0 - 50","0 - 50",643.19569999999999,625.76639999999998,100,{"$f":"D164*$F164","v":64319.57},{"$f":"E164*$F164","v":62576.639999999999}]
[null,"> 50","> 50",109.4277,106.4624,134.54000000000002,{"$f":"D165*$F165","v":14722.402758000002},{"$f":"E165*$F165","v":14323.451296000003}]
[]
[]
[null,"Total Revenue","Total Revenue",null,null,null,{"$f":"SUM(G8:G166)","v":209269174.00000012},{"$f":"SUM(H8:H166)","v":203598412.88713446}]

{"sheet":"2020TarContForm","index":3,"n_rows":44,"n_cols":3,"rows_kept":44,"cut":false,"hidden":false,"merged":[[43,1,43,3]]}
[null,{"$f":"\"Tariff Approval - \"&'Model update'!B3","v":"Tariff Approval - MultiNet"},{"$f":"'Model update'!B5&\"TarContForm\"","v":"2020TarContForm"}]
[]
[null,{"$f":"'Model update'!$B$5&\"  TARIFF CONTROL FORMULA\"","v":"2020  TARIFF CONTROL FORMULA"}]
[]
[]
[null,"CPI"]
[]
[null,{"$f":"\"CPI June \"&'Model update'!$B$9","v":"CPI June 2018"},{"$f":"'Model update'!B26","v":113}]
[null,{"$f":"\"CPI June \"&'Model update'!$B$8","v":"CPI June 2019"},{"$f":"'Model update'!B27","v":114.8}]
[]
[null,{"$f":"\"CPI \"&'Model update'!$B$5","v":"CPI 2020"},{"$f":"(C9/C8-1)","v":1.5929203539823078E-2}]
[]
[]
[]
[null,"X factor"]
[]
[null,{"$f":"\"X \"&'Model update'!$B$5","v":"X 2020"},{"$f":"'Model update'!B40","v":-1.1736521921608076E-2}]
[]
[]
[null,"Pass Through Factor (PT)"]
[]
[null,"pass through"]
[null,{"$f":"\"AP (t) \"&'Model update'!$B$7","v":"AP (t) 2020"},{"$f":"'Model update'!B50","v":0}]
[]
[null,"Revenue"]
[null,"∑∑p(t-1)q(t-2)",{"$f":"C41","v":203598412.88713446}]
[]
[null,"PT' (t-1)",0]
[null,{"$f":"\"PT' \"&'Model update'!$B$5","v":"PT' 2020"},{"$f":"IF(C26=\"\",0,(C23)/((1+C11)*(1-C17)*C26))","v":0}]
[]
[null,{"$f":"\"PTt \"&'Model update'!$B$5","v":"PTt 2020"},{"$f":"((1+C29)/(1+C28))-1","v":0}]
[]
[]
[]
[]
[null,{"$f":"'Model update'!$B$5&\"  Distribution price control\"","v":"2020  Distribution price control"}]
[]
[null,"Average price movement allowed",{"$f":"(1+C11)*(1-C17)*(1+C31)","v":1.0278526789079701}]
[]
[null,"Proposed distribution tariff revenue",{"$f":"IF(Prop2020DistTar!G168=0,\"\",Prop2020DistTar!G168)","v":209269174.00000012}]
[null,"Existing distribution tariff revenue",{"$f":"IF(Prop2020DistTar!H168=0,\"\",Prop2020DistTar!H168)","v":203598412.88713446}]
[null,"Average price movement",{"$f":"IF(C40=\"\",\"\",C40/C41)","v":1.0278526783802056}]
[]
[null,{"$f":"IF(C40=\"\",\"\",IF(C38>=C42,\"DISTRIBUTION PRICE CONTROL FORMULA COMPLIANT\",\"DISTRIBUTION PRICE CONTROL FORMULA BREACHED\"))","v":"DISTRIBUTION PRICE CONTROL FORMULA COMPLIANT"}]

{"sheet":"2020RebalContForm","index":4,"n_rows":285,"n_cols":23,"rows_kept":285,"cut":false,"hidden":false,"merged":[[284,1,284,2],[57,1,57,2],[87,1,87,2],[117,1,117,2],[147,1,147,2],[177,1,177,2],[207,1,207,2],[231,1,231,2],[260,1,260,2]]}
[null,{"$f":"\"Tariff Approval - \"&'Model update'!B3","v":"Tariff Approval - MultiNet"},{"$f":"'Model update'!B5&\"RebalContForm\"","v":"2020RebalContForm"}]
[]
[null,{"$f":"'Model update'!$B$5&\"  REBALANCING CONTROL FORMULA\"","v":"2020  REBALANCING CONTROL FORMULA"}]
[]
[]
[null,"Rebalancing control"]
[]
[null,{"$f":"\"CPI \"&'Model update'!$B$5","v":"CPI 2020"},{"$f":"'2020TarContForm'!C11","v":1.5929203539823078E-2}]
[null,{"$f":"\"Y  \"&'Model update'!$B$5","v":"Y  2020"},0.02]
[null,{"$f":"\"PTt \"&'Model update'!$B$5","v":"PTt 2020"},{"$f":"'2020TarContForm'!C31","v":0}]
[null,{"$f":"\"Xt \"&'Model update'!$B$5","v":"Xt 2020"},{"$f":"'2020TarContForm'!C17","v":-1.1736521921608076E-2}]
[]
[null,"Rebalancing control",{"$f":"(1+C8)*(1+C9)*(1+C10)*(1-C11)","v":1.0484097324861295}]
[]
[]
[]
[null,"Rebalancing control summary"]
[null,null,"Existing","Proposed","Movement","Assessment"]
[null,{"$f":"B32","v":"Tariff V - Multinet Residential"},{"$f":"C53","v":188162651.68232059},{"$f":"C54","v":193440341.93469447},{"$f":"IF(C19=0,0,D19/C19)","v":1.0280485537655173},{"$f":"IF(E19=0,\"\",IF($C$13<=E19,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B62","v":"Tariff V - Yarra Valley Residential"},{"$f":"C83","v":2117975.1536065051},{"$f":"C84","v":2172543.6192192454},1.0257644503146417,{"$f":"IF(E20=0,\"\",IF($C$13<=E20,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B92","v":"Tariff V - South Gippsland Residential"},{"$f":"C113","v":1569612.5018356708},{"$f":"C114","v":1612368.0655710208},1.0272395662530382,"Compliant"]
[null,{"$f":"B122","v":"Tariff V - Multinet Non-Residential"},{"$f":"C143","v":9224671.415439168},{"$f":"C144","v":9453700.0817747805},1.0248278400412498,"Compliant"]
[null,{"$f":"B152","v":"Tariff V - Yarra Valley Non-Residential"},{"$f":"C173","v":127214.96246777033},{"$f":"C174","v":129961.85163508086},1.0215925007092344,"Compliant"]
[null,{"$f":"B182","v":"Tariff V - South Gippsland Non-Residential"},{"$f":"C203","v":342861.47962964914},{"$f":"C204","v":349638.30841832567},1.0197655006214075,"Compliant"]
[null,{"$f":"B212","v":"Tariff D - Multinet"},{"$f":"C227","v":1943846.9623379998},{"$f":"C228","v":1997988.4050359998},1.0278527290198196,"Compliant"]
[null,{"$f":"B265","v":"Tariff D - Multinet South Gippsland"},{"$f":"C280","v":76900.091295999999},{"$f":"C281","v":79041.972758000004},1.0278527817835168,"Compliant"]
[null,"Tariff L - Multinet",{"$f":"C256","v":32678.638200999998},{"$f":"C257","v":33589.760892999999},1.0278812931675996,"Compliant"]
[null,null,{"$f":"SUM(C19:C27)","v":203598412.88713431},{"$f":"SUM(D19:D27)","v":209269173.99999988},1.0278526783802051]
[]
[]
[]
[null,{"$f":"Prop2020DistTar!B6","v":"Tariff V - Multinet Residential"},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21]
[null,"Distribution tariff","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3","Shd1Blk4","Shd1Blk5","Shd2Blk1","Shd2Blk2","Shd2Blk3","Shd2Blk4","Shd2Blk5","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4","OPkBlk5"]
[]
[null,{"$f":"\"Existing (1 Jan-31 Dec): \"&Prop2020DistTar!C6","v":"Existing (1 Jan-31 Dec): Tariff V - Multinet Residential"},{"$f":"INDEX(Prop2020DistTar!$E$8:$E$28,C$33)","v":0.18010000000000001},{"$f":"INDEX(Prop2020DistTar!$E$8:$E$28,D$33)","v":8.3680402248471015},{"$f":"INDEX(Prop2020DistTar!$E$8:$E$28,E$33)","v":5.7468000000000004},{"$f":"INDEX(Prop2020DistTar!$E$8:$E$28,F$33)","v":2.9712000000000001},{"$f":"INDEX(Prop2020DistTar!$E$8:$E$28,G$33)","v":1.5036},{"$f":"INDEX(Prop2020DistTar!$E$8:$E$28,H$33)","v":1.1151},{"$f":"INDEX(Prop2020DistTar!$E$8:$E$28,I$33)","v":7.9867094258476676},{"$f":"INDEX(Prop2020DistTar!$E$8:$E$28,J$33)","v":5.4593999999999996},{"$f":"INDEX(Prop2020DistTar!$E$8:$E$28,K$33)","v":2.8235999999999999},{"$f":"INDEX(Prop2020DistTar!$E$8:$E$28,L$33)","v":1.4285000000000001},{"$f":"INDEX(Prop2020DistTar!$E$8:$E$28,M$33)","v":1.0742},{"$f":"INDEX(Prop2020DistTar!$E$8:$E$28,N$33)","v":7.9867094258476676},{"$f":"INDEX(Prop2020DistTar!$E$8:$E$28,O$33)","v":5.4593999999999996},{"$f":"INDEX(Prop2020DistTar!$E$8:$E$28,P$33)","v":2.8235999999999999},{"$f":"INDEX(Prop2020DistTar!$E$8:$E$28,Q$33)","v":1.4285000000000001},{"$f":"INDEX(Prop2020DistTar!$E$8:$E$28,R$33)","v":1.0742},{"$f":"INDEX(Prop2020DistTar!$E$8:$E$28,S$33)","v":7.1461077879984369},{"$f":"INDEX(Prop2020DistTar!$E$8:$E$28,T$33)","v":4.8849},{"$f":"INDEX(Prop2020DistTar!$E$8:$E$28,U$33)","v":2.5264000000000002},{"$f":"INDEX(Prop2020DistTar!$E$8:$E$28,V$33)","v":1.2781},{"$f":"INDEX(Prop2020DistTar!$E$8:$E$28,W$33)","v":0.96130000000000004}]
[]
[null,{"$f":"\"Proposed (1 Jan-31 Dec): \"&B32","v":"Proposed (1 Jan-31 Dec): Tariff V - Multinet Residential"},{"$f":"INDEX(Prop2020DistTar!$D$8:$D$28,C$32)","v":0.183},{"$f":"INDEX(Prop2020DistTar!$D$8:$D$28,D$32)","v":8.7502965387832621},{"$f":"INDEX(Prop2020DistTar!$D$8:$D$28,E$32)","v":5.8383000000000003},{"$f":"INDEX(Prop2020DistTar!$D$8:$D$28,F$32)","v":3.0185},{"$f":"INDEX(Prop2020DistTar!$D$8:$D$28,G$32)","v":1.5276000000000001},{"$f":"INDEX(Prop2020DistTar!$D$8:$D$28,H$32)","v":1.1329},{"$f":"INDEX(Prop2020DistTar!$D$8:$D$28,I$32)","v":8.3515498907265346},{"$f":"INDEX(Prop2020DistTar!$D$8:$D$28,J$32)","v":5.5464000000000002},{"$f":"INDEX(Prop2020DistTar!$D$8:$D$28,K$32)","v":2.8685999999999998},{"$f":"INDEX(Prop2020DistTar!$D$8:$D$28,L$32)","v":1.4513},{"$f":"INDEX(Prop2020DistTar!$D$8:$D$28,M$32)","v":1.0912999999999999},{"$f":"INDEX(Prop2020DistTar!$D$8:$D$28,N$32)","v":8.3515498907265346},{"$f":"INDEX(Prop2020DistTar!$D$8:$D$28,O$32)","v":5.5464000000000002},{"$f":"INDEX(Prop2020DistTar!$D$8:$D$28,P$32)","v":2.8685999999999998},{"$f":"INDEX(Prop2020DistTar!$D$8:$D$28,Q$32)","v":1.4513},{"$f":"INDEX(Prop2020DistTar!$D$8:$D$28,R$32)","v":1.0912999999999999},{"$f":"INDEX(Prop2020DistTar!$D$8:$D$28,S$32)","v":7.4725368875245666},{"$f":"INDEX(Prop2020DistTar!$D$8:$D$28,T$32)","v":4.9626999999999999},{"$f":"INDEX(Prop2020DistTar!$D$8:$D$28,U$32)","v":2.5666000000000002},{"$f":"INDEX(Prop2020DistTar!$D$8:$D$28,V$32)","v":1.2985},{"$f":"INDEX(Prop2020DistTar!$D$8:$D$28,W$32)","v":0.97660000000000002}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3","Shd1Blk4","Shd1Blk5","Shd2Blk1","Shd2Blk2","Shd2Blk3","Shd2Blk4","Shd2Blk5","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4","OPkBlk5"]
[]
[null,{"$f":"B36","v":"Existing (1 Jan-31 Dec): Tariff V - Multinet Residential"},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,C$32)","v":677911},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,D$32)","v":3644226.8659199998},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,E$32)","v":3061316.8703399999},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,F$32)","v":2663703.46123},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,G$32)","v":4323577.4184600003},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,H$32)","v":8511966.0198999997},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,I$32)","v":909391.3872},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,J$32)","v":720256.52176999999},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,K$32)","v":580423.26826000004},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,L$32)","v":832054.53486000001},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,M$32)","v":1271057.5099800001},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,N$32)","v":879745.98845000006},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,O$32)","v":597219.39760999999},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,P$32)","v":387562.88742000004},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,Q$32)","v":417870.95835000003},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,R$32)","v":483169.19057999999},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,S$32)","v":4421093.8010300007},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,T$32)","v":1703421.50667},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,U$32)","v":742019.84565999999},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,V$32)","v":672243.89884000004},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,W$32)","v":1113875.99924}]
[]
[null,{"$f":"B38","v":"Proposed (1 Jan-31 Dec): Tariff V - Multinet Residential"},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,C$32)","v":677911},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,D$32)","v":3644226.8659199998},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,E$32)","v":3061316.8703399999},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,F$32)","v":2663703.46123},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,G$32)","v":4323577.4184600003},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,H$32)","v":8511966.0198999997},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,I$32)","v":909391.3872},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,J$32)","v":720256.52176999999},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,K$32)","v":580423.26826000004},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,L$32)","v":832054.53486000001},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,M$32)","v":1271057.5099800001},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,N$32)","v":879745.98845000006},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,O$32)","v":597219.39760999999},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,P$32)","v":387562.88742000004},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,Q$32)","v":417870.95835000003},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,R$32)","v":483169.19057999999},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,S$32)","v":4421093.8010300007},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,T$32)","v":1703421.50667},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,U$32)","v":742019.84565999999},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,V$32)","v":672243.89884000004},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$28,W$32)","v":1113875.99924}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3","Shd1Blk4","Shd1Blk5","Shd2Blk1","Shd2Blk2","Shd2Blk3","Shd2Blk4","Shd2Blk5","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4","OPkBlk5"]
[]
[null,{"$f":"B42","v":"Existing (1 Jan-31 Dec): Tariff V - Multinet Residential"},{"$f":"INDEX(Prop2020DistTar!$H$8:$H$28,C$33)","v":44563496.451500006},{"$f":"INDEX(Prop2020DistTar!$H$8:$H$28,D$33)","v":30495037.002487045},{"$f":"INDEX(Prop2020DistTar!$H$8:$H$28,E$33)","v":17592775.790469911},{"$f":"INDEX(Prop2020DistTar!$H$8:$H$28,F$33)","v":7914395.7240065765},{"$f":"INDEX(Prop2020DistTar!$H$8:$H$28,G$33)","v":6500931.0063964566},{"$f":"INDEX(Prop2020DistTar!$H$8:$H$28,H$33)","v":9491693.30879049},{"$f":"INDEX(Prop2020DistTar!$H$8:$H$28,I$33)","v":7263044.7639349261},{"$f":"INDEX(Prop2020DistTar!$H$8:$H$28,J$33)","v":3932168.4549511378},{"$f":"INDEX(Prop2020DistTar!$H$8:$H$28,K$33)","v":1638883.140258936},{"$f":"INDEX(Prop2020DistTar!$H$8:$H$28,L$33)","v":1188589.9030475102},{"$f":"INDEX(Prop2020DistTar!$H$8:$H$28,M$33)","v":1365369.9772205162},{"$f":"INDEX(Prop2020DistTar!$H$8:$H$28,N$33)","v":7026275.5783052891},{"$f":"INDEX(Prop2020DistTar!$H$8:$H$28,O$33)","v":3260459.5793120335},{"$f":"INDEX(Prop2020DistTar!$H$8:$H$28,P$33)","v":1094322.568919112},{"$f":"INDEX(Prop2020DistTar!$H$8:$H$28,Q$33)","v":596928.6640029751},{"$f":"INDEX(Prop2020DistTar!$H$8:$H$28,R$33)","v":519020.34452103602},{"$f":"INDEX(Prop2020DistTar!$H$8:$H$28,S$33)","v":31593612.843012098},{"$f":"INDEX(Prop2020DistTar!$H$8:$H$28,T$33)","v":8321043.7179322829},{"$f":"INDEX(Prop2020DistTar!$H$8:$H$28,U$33)","v":1874638.9380754242},{"$f":"INDEX(Prop2020DistTar!$H$8:$H$28,V$33)","v":859194.9271074041},{"$f":"INDEX(Prop2020DistTar!$H$8:$H$28,W$33)","v":1070768.9980694121}]
[]
[null,{"$f":"B44","v":"Proposed (1 Jan-31 Dec): Tariff V - Multinet Residential"},{"$f":"INDEX(Prop2020DistTar!$G$8:$G$28,C$32)","v":45281065.245000005},{"$f":"INDEX(Prop2020DistTar!$G$8:$G$28,D$32)","v":31888065.731400751},{"$f":"INDEX(Prop2020DistTar!$G$8:$G$28,E$32)","v":17872886.284106024},{"$f":"INDEX(Prop2020DistTar!$G$8:$G$28,F$32)","v":8040388.8977227546},{"$f":"INDEX(Prop2020DistTar!$G$8:$G$28,G$32)","v":6604696.8644394968},{"$f":"INDEX(Prop2020DistTar!$G$8:$G$28,H$32)","v":9643206.3039447106},{"$f":"INDEX(Prop2020DistTar!$G$8:$G$28,I$32)","v":7594827.5403978117},{"$f":"INDEX(Prop2020DistTar!$G$8:$G$28,J$32)","v":3994830.772345128},{"$f":"INDEX(Prop2020DistTar!$G$8:$G$28,K$32)","v":1665002.187330636},{"$f":"INDEX(Prop2020DistTar!$G$8:$G$28,L$32)","v":1207560.746442318},{"$f":"INDEX(Prop2020DistTar!$G$8:$G$28,M$32)","v":1387105.060641174},{"$f":"INDEX(Prop2020DistTar!$G$8:$G$28,N$32)","v":7347242.5137067055},{"$f":"INDEX(Prop2020DistTar!$G$8:$G$28,O$32)","v":3312417.6669041039},{"$f":"INDEX(Prop2020DistTar!$G$8:$G$28,P$32)","v":1111762.8988530121},{"$f":"INDEX(Prop2020DistTar!$G$8:$G$28,Q$32)","v":606456.12185335509},{"$f":"INDEX(Prop2020DistTar!$G$8:$G$28,R$32)","v":527282.53767995397},{"$f":"INDEX(Prop2020DistTar!$G$8:$G$28,S$32)","v":33036786.511402875},{"$f":"INDEX(Prop2020DistTar!$G$8:$G$28,T$32)","v":8453569.9111512098},{"$f":"INDEX(Prop2020DistTar!$G$8:$G$28,U$32)","v":1904468.1358709561},{"$f":"INDEX(Prop2020DistTar!$G$8:$G$28,V$32)","v":872908.70264373999},{"$f":"INDEX(Prop2020DistTar!$G$8:$G$28,W$32)","v":1087811.300857784}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B48","v":"Existing (1 Jan-31 Dec): Tariff V - Multinet Residential"},{"$f":"SUM(C48:W48)","v":188162651.68232059}]
[null,{"$f":"B50","v":"Proposed (1 Jan-31 Dec): Tariff V - Multinet Residential"},{"$f":"SUM(C50:W50)","v":193440341.93469447}]
[]
[null,"Average price movement",{"$f":"IF(C54=0,\"\",C54/C53)","v":1.0280485537655173}]
[]
[null,{"$f":"IF(C56=\"\",\"\",IF(C56<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2020DistTar!B52","v":"Tariff V - Yarra Valley Residential"},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21]
[null,"Distribution tariff","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3","Shd1Blk4","Shd1Blk5","Shd2Blk1","Shd2Blk2","Shd2Blk3","Shd2Blk4","Shd2Blk5","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4","OPkBlk5"]
[]
[null,{"$f":"\"Existing (1 Jan-31 Dec): \"&Prop2020DistTar!C52","v":"Existing (1 Jan-31 Dec): Tariff V - Yarra Valley Residential"},{"$f":"INDEX(Prop2020DistTar!$E$54:$E$74,C$33)","v":0.18010000000000001},{"$f":"INDEX(Prop2020DistTar!$E$54:$E$74,D$33)","v":9.9722450182235924},{"$f":"INDEX(Prop2020DistTar!$E$54:$E$74,E$33)","v":7.7164999999999999},{"$f":"INDEX(Prop2020DistTar!$E$54:$E$74,F$33)","v":5.5157999999999996},{"$f":"INDEX(Prop2020DistTar!$E$54:$E$74,G$33)","v":4.3510999999999997},{"$f":"INDEX(Prop2020DistTar!$E$54:$E$74,H$33)","v":4.0552000000000001},{"$f":"INDEX(Prop2020DistTar!$E$54:$E$74,I$33)","v":9.6387244181659266},{"$f":"INDEX(Prop2020DistTar!$E$54:$E$74,J$33)","v":7.4885000000000002},{"$f":"INDEX(Prop2020DistTar!$E$54:$E$74,K$33)","v":5.3978999999999999},{"$f":"INDEX(Prop2020DistTar!$E$54:$E$74,L$33)","v":4.2912999999999997},{"$f":"INDEX(Prop2020DistTar!$E$54:$E$74,M$33)","v":4.0103},{"$f":"INDEX(Prop2020DistTar!$E$54:$E$74,N$33)","v":9.6387244181659266},{"$f":"INDEX(Prop2020DistTar!$E$54:$E$74,O$33)","v":7.4885000000000002},{"$f":"INDEX(Prop2020DistTar!$E$54:$E$74,P$33)","v":5.3978999999999999},{"$f":"INDEX(Prop2020DistTar!$E$54:$E$74,Q$33)","v":4.2912999999999997},{"$f":"INDEX(Prop2020DistTar!$E$54:$E$74,R$33)","v":4.0103},{"$f":"INDEX(Prop2020DistTar!$E$54:$E$74,S$33)","v":8.9719970705600591},{"$f":"INDEX(Prop2020DistTar!$E$54:$E$74,T$33)","v":7.0327000000000002},{"$f":"INDEX(Prop2020DistTar!$E$54:$E$74,U$33)","v":5.1620999999999997},{"$f":"INDEX(Prop2020DistTar!$E$54:$E$74,V$33)","v":4.1719999999999997},{"$f":"INDEX(Prop2020DistTar!$E$54:$E$74,W$33)","v":3.9205999999999999}]
[]
[null,{"$f":"\"Proposed (1 Jan-31 Dec): \"&B62","v":"Proposed (1 Jan-31 Dec): Tariff V - Yarra Valley Residential"},{"$f":"INDEX(Prop2020DistTar!$D$54:$D$74,C$32)","v":0.183},{"$f":"INDEX(Prop2020DistTar!$D$54:$D$74,D$32)","v":10.427832127329596},{"$f":"INDEX(Prop2020DistTar!$D$54:$D$74,E$32)","v":7.8394000000000004},{"$f":"INDEX(Prop2020DistTar!$D$54:$D$74,F$32)","v":5.6036999999999999},{"$f":"INDEX(Prop2020DistTar!$D$54:$D$74,G$32)","v":4.4203999999999999},{"$f":"INDEX(Prop2020DistTar!$D$54:$D$74,H$32)","v":4.1197999999999997},{"$f":"INDEX(Prop2020DistTar!$D$54:$D$74,I$32)","v":10.079108935895372},{"$f":"INDEX(Prop2020DistTar!$D$54:$D$74,J$32)","v":7.6078000000000001},{"$f":"INDEX(Prop2020DistTar!$D$54:$D$74,K$32)","v":5.4839000000000002},{"$f":"INDEX(Prop2020DistTar!$D$54:$D$74,L$32)","v":4.3597000000000001},{"$f":"INDEX(Prop2020DistTar!$D$54:$D$74,M$32)","v":4.0742000000000003},{"$f":"INDEX(Prop2020DistTar!$D$54:$D$74,N$32)","v":10.079108935895372},{"$f":"INDEX(Prop2020DistTar!$D$54:$D$74,O$32)","v":7.6078000000000001},{"$f":"INDEX(Prop2020DistTar!$D$54:$D$74,P$32)","v":5.4839000000000002},{"$f":"INDEX(Prop2020DistTar!$D$54:$D$74,Q$32)","v":4.3597000000000001},{"$f":"INDEX(Prop2020DistTar!$D$54:$D$74,R$32)","v":4.0742000000000003},{"$f":"INDEX(Prop2020DistTar!$D$54:$D$74,S$32)","v":9.381868410873107},{"$f":"INDEX(Prop2020DistTar!$D$54:$D$74,T$32)","v":7.1447000000000003},{"$f":"INDEX(Prop2020DistTar!$D$54:$D$74,U$32)","v":5.2443},{"$f":"INDEX(Prop2020DistTar!$D$54:$D$74,V$32)","v":4.2385000000000002},{"$f":"INDEX(Prop2020DistTar!$D$54:$D$74,W$32)","v":3.9830999999999999}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3","Shd1Blk4","Shd1Blk5","Shd2Blk1","Shd2Blk2","Shd2Blk3","Shd2Blk4","Shd2Blk5","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4","OPkBlk5"]
[]
[null,{"$f":"B66","v":"Existing (1 Jan-31 Dec): Tariff V - Yarra Valley Residential"},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,C$32)","v":5449},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,D$32)","v":29024.731209999998},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,E$32)","v":24230.222730000001},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,F$32)","v":21044.124029999999},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,G$32)","v":33858.746659999997},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,H$32)","v":59278.572299999993},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,I$32)","v":7162.3672500000002},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,J$32)","v":5595.9938099999999},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,K$32)","v":4560.0096100000001},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,L$32)","v":7028.4358099999999},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,M$32)","v":12087.90897},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,N$32)","v":7056.9420599999994},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,O$32)","v":4924.0687500000004},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,P$32)","v":3190.4222100000002},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,Q$32)","v":2922.9342299999998},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,R$32)","v":3153.9870699999997},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,S$32)","v":30252.326099999998},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,T$32)","v":11025.240600000001},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,U$32)","v":4742.1375800000005},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,V$32)","v":3472.2586699999997},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,W$32)","v":7690.4558999999999}]
[]
[null,{"$f":"B68","v":"Proposed (1 Jan-31 Dec): Tariff V - Yarra Valley Residential"},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,C$32)","v":5449},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,D$32)","v":29024.731209999998},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,E$32)","v":24230.222730000001},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,F$32)","v":21044.124029999999},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,G$32)","v":33858.746659999997},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,H$32)","v":59278.572299999993},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,I$32)","v":7162.3672500000002},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,J$32)","v":5595.9938099999999},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,K$32)","v":4560.0096100000001},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,L$32)","v":7028.4358099999999},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,M$32)","v":12087.90897},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,N$32)","v":7056.9420599999994},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,O$32)","v":4924.0687500000004},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,P$32)","v":3190.4222100000002},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,Q$32)","v":2922.9342299999998},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,R$32)","v":3153.9870699999997},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,S$32)","v":30252.326099999998},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,T$32)","v":11025.240600000001},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,U$32)","v":4742.1375800000005},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,V$32)","v":3472.2586699999997},{"$f":"INDEX(Prop2020DistTar!$F$54:$F$74,W$32)","v":7690.4558999999999}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3","Shd1Blk4","Shd1Blk5","Shd2Blk1","Shd2Blk2","Shd2Blk3","Shd2Blk4","Shd2Blk5","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4","OPkBlk5"]
[]
[null,{"$f":"B72","v":"Existing (1 Jan-31 Dec): Tariff V - Yarra Valley Residential"},{"$f":"INDEX(Prop2020DistTar!$H$54:$H$74,C$33)","v":358198.18849999999},{"$f":"INDEX(Prop2020DistTar!$H$54:$H$74,D$33)","v":289441.73121420131},{"$f":"INDEX(Prop2020DistTar!$H$54:$H$74,E$33)","v":186972.513696045},{"$f":"INDEX(Prop2020DistTar!$H$54:$H$74,F$33)","v":116075.17932467398},{"$f":"INDEX(Prop2020DistTar!$H$54:$H$74,G$33)","v":147322.79259232598},{"$f":"INDEX(Prop2020DistTar!$H$54:$H$74,H$33)","v":240386.46639095998},{"$f":"INDEX(Prop2020DistTar!$H$54:$H$74,I$33)","v":69036.084104446942},{"$f":"INDEX(Prop2020DistTar!$H$54:$H$74,J$33)","v":41905.599646185001},{"$f":"INDEX(Prop2020DistTar!$H$54:$H$74,K$33)","v":24614.475873818999},{"$f":"INDEX(Prop2020DistTar!$H$54:$H$74,L$33)","v":30161.126591452998},{"$f":"INDEX(Prop2020DistTar!$H$54:$H$74,M$33)","v":48476.141342390998},{"$f":"INDEX(Prop2020DistTar!$H$54:$H$74,N$33)","v":68019.919751304144},{"$f":"INDEX(Prop2020DistTar!$H$54:$H$74,O$33)","v":36873.888834375},{"$f":"INDEX(Prop2020DistTar!$H$54:$H$74,P$33)","v":17221.580047359002},{"$f":"INDEX(Prop2020DistTar!$H$54:$H$74,Q$33)","v":12543.187661198999},{"$f":"INDEX(Prop2020DistTar!$H$54:$H$74,R$33)","v":12648.434346820999},{"$f":"INDEX(Prop2020DistTar!$H$54:$H$74,S$33)","v":271423.78114682762},{"$f":"INDEX(Prop2020DistTar!$H$54:$H$74,T$33)","v":77537.209567620012},{"$f":"INDEX(Prop2020DistTar!$H$54:$H$74,U$33)","v":24479.388401718003},{"$f":"INDEX(Prop2020DistTar!$H$54:$H$74,V$33)","v":14486.263171239998},{"$f":"INDEX(Prop2020DistTar!$H$54:$H$74,W$33)","v":30151.201401539998}]
[]
[null,{"$f":"B74","v":"Proposed (1 Jan-31 Dec): Tariff V - Yarra Valley Residential"},{"$f":"INDEX(Prop2020DistTar!$G$54:$G$74,C$32)","v":363965.95500000002},{"$f":"INDEX(Prop2020DistTar!$G$54:$G$74,D$32)","v":302665.024598744},{"$f":"INDEX(Prop2020DistTar!$G$54:$G$74,E$32)","v":189950.40806956202},{"$f":"INDEX(Prop2020DistTar!$G$54:$G$74,F$32)","v":117924.95782691099},{"$f":"INDEX(Prop2020DistTar!$G$54:$G$74,G$32)","v":149669.20373586399},{"$f":"INDEX(Prop2020DistTar!$G$54:$G$74,H$32)","v":244215.86216153996},{"$f":"INDEX(Prop2020DistTar!$G$54:$G$74,I$32)","v":72190.279751639362},{"$f":"INDEX(Prop2020DistTar!$G$54:$G$74,J$32)","v":42573.201707717999},{"$f":"INDEX(Prop2020DistTar!$G$54:$G$74,K$32)","v":25006.636700279003},{"$f":"INDEX(Prop2020DistTar!$G$54:$G$74,L$32)","v":30641.871600857001},{"$f":"INDEX(Prop2020DistTar!$G$54:$G$74,M$32)","v":49248.558725574003},{"$f":"INDEX(Prop2020DistTar!$G$54:$G$74,N$32)","v":71127.68777704188},{"$f":"INDEX(Prop2020DistTar!$G$54:$G$74,O$32)","v":37461.330236250004},{"$f":"INDEX(Prop2020DistTar!$G$54:$G$74,P$32)","v":17495.956357419003},{"$f":"INDEX(Prop2020DistTar!$G$54:$G$74,Q$32)","v":12743.116362531},{"$f":"INDEX(Prop2020DistTar!$G$54:$G$74,R$32)","v":12849.974120593999},{"$f":"INDEX(Prop2020DistTar!$G$54:$G$74,S$32)","v":283823.34259302198},{"$f":"INDEX(Prop2020DistTar!$G$54:$G$74,T$32)","v":78772.036514820007},{"$f":"INDEX(Prop2020DistTar!$G$54:$G$74,U$32)","v":24869.192110794003},{"$f":"INDEX(Prop2020DistTar!$G$54:$G$74,V$32)","v":14717.168372794999},{"$f":"INDEX(Prop2020DistTar!$G$54:$G$74,W$32)","v":30631.854895289998}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B78","v":"Existing (1 Jan-31 Dec): Tariff V - Yarra Valley Residential"},{"$f":"SUM(C78:W78)","v":2117975.1536065051}]
[null,{"$f":"B80","v":"Proposed (1 Jan-31 Dec): Tariff V - Yarra Valley Residential"},{"$f":"SUM(C80:W80)","v":2172543.6192192454}]
[]
[null,"Average price movement",{"$f":"IF(C84=0,\"\",C84/C83)","v":1.0257644503146417}]
[]
[null,{"$f":"IF(C86=\"\",\"\",IF(C86<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2020DistTar!B98","v":"Tariff V - South Gippsland Residential"},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21]
[null,"Distribution tariff","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3","Shd1Blk4","Shd1Blk5","Shd2Blk1","Shd2Blk2","Shd2Blk3","Shd2Blk4","Shd2Blk5","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4","OPkBlk5"]
[]
[null,{"$f":"\"Existing (1 Jan-31 Dec): \"&Prop2020DistTar!C98","v":"Existing (1 Jan-31 Dec): Tariff V - South Gippsland Residential"},{"$f":"INDEX(Prop2020DistTar!$E$100:$E$120,C$33)","v":0.18010000000000001},{"$f":"INDEX(Prop2020DistTar!$E$100:$E$120,D$33)","v":10.853019777284288},{"$f":"INDEX(Prop2020DistTar!$E$100:$E$120,E$33)","v":8.4459},{"$f":"INDEX(Prop2020DistTar!$E$100:$E$120,F$33)","v":6.1089000000000002},{"$f":"INDEX(Prop2020DistTar!$E$100:$E$120,G$33)","v":4.8720999999999997},{"$f":"INDEX(Prop2020DistTar!$E$100:$E$120,H$33)","v":4.5579999999999998},{"$f":"INDEX(Prop2020DistTar!$E$100:$E$120,I$33)","v":10.498784911601959},{"$f":"INDEX(Prop2020DistTar!$E$100:$E$120,J$33)","v":8.2039000000000009},{"$f":"INDEX(Prop2020DistTar!$E$100:$E$120,K$33)","v":5.9836999999999998},{"$f":"INDEX(Prop2020DistTar!$E$100:$E$120,L$33)","v":4.8087},{"$f":"INDEX(Prop2020DistTar!$E$100:$E$120,M$33)","v":4.5102000000000002},{"$f":"INDEX(Prop2020DistTar!$E$100:$E$120,N$33)","v":10.498784911601959},{"$f":"INDEX(Prop2020DistTar!$E$100:$E$120,O$33)","v":8.2039000000000009},{"$f":"INDEX(Prop2020DistTar!$E$100:$E$120,P$33)","v":5.9836999999999998},{"$f":"INDEX(Prop2020DistTar!$E$100:$E$120,Q$33)","v":4.8087},{"$f":"INDEX(Prop2020DistTar!$E$100:$E$120,R$33)","v":4.5102000000000002},{"$f":"INDEX(Prop2020DistTar!$E$100:$E$120,S$33)","v":9.790838267753081},{"$f":"INDEX(Prop2020DistTar!$E$100:$E$120,T$33)","v":7.7198000000000002},{"$f":"INDEX(Prop2020DistTar!$E$100:$E$120,U$33)","v":5.7333999999999996},{"$f":"INDEX(Prop2020DistTar!$E$100:$E$120,V$33)","v":4.6818999999999997},{"$f":"INDEX(Prop2020DistTar!$E$100:$E$120,W$33)","v":4.4149000000000003}]
[]
[null,{"$f":"\"Proposed (1 Jan-31 Dec): \"&B92","v":"Proposed (1 Jan-31 Dec): Tariff V - South Gippsland Residential"},{"$f":"INDEX(Prop2020DistTar!$D$100:$D$120,C$32)","v":0.183},{"$f":"INDEX(Prop2020DistTar!$D$100:$D$120,D$32)","v":11.348840131152924},{"$f":"INDEX(Prop2020DistTar!$D$100:$D$120,E$32)","v":8.5803999999999991},{"$f":"INDEX(Prop2020DistTar!$D$100:$D$120,F$32)","v":6.2061999999999999},{"$f":"INDEX(Prop2020DistTar!$D$100:$D$120,G$32)","v":4.9497},{"$f":"INDEX(Prop2020DistTar!$D$100:$D$120,H$32)","v":4.6306000000000003},{"$f":"INDEX(Prop2020DistTar!$D$100:$D$120,I$32)","v":10.97839893694638},{"$f":"INDEX(Prop2020DistTar!$D$100:$D$120,J$32)","v":8.3346},{"$f":"INDEX(Prop2020DistTar!$D$100:$D$120,K$32)","v":6.0789999999999997},{"$f":"INDEX(Prop2020DistTar!$D$100:$D$120,L$32)","v":4.8853},{"$f":"INDEX(Prop2020DistTar!$D$100:$D$120,M$32)","v":4.5819999999999999},{"$f":"INDEX(Prop2020DistTar!$D$100:$D$120,N$32)","v":10.97839893694638},{"$f":"INDEX(Prop2020DistTar!$D$100:$D$120,O$32)","v":8.3346},{"$f":"INDEX(Prop2020DistTar!$D$100:$D$120,P$32)","v":6.0789999999999997},{"$f":"INDEX(Prop2020DistTar!$D$100:$D$120,Q$32)","v":4.8853},{"$f":"INDEX(Prop2020DistTar!$D$100:$D$120,R$32)","v":4.5819999999999999},{"$f":"INDEX(Prop2020DistTar!$D$100:$D$120,S$32)","v":10.238134122071841},{"$f":"INDEX(Prop2020DistTar!$D$100:$D$120,T$32)","v":7.8428000000000004},{"$f":"INDEX(Prop2020DistTar!$D$100:$D$120,U$32)","v":5.8247},{"$f":"INDEX(Prop2020DistTar!$D$100:$D$120,V$32)","v":4.7565},{"$f":"INDEX(Prop2020DistTar!$D$100:$D$120,W$32)","v":4.4851999999999999}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3","Shd1Blk4","Shd1Blk5","Shd2Blk1","Shd2Blk2","Shd2Blk3","Shd2Blk4","Shd2Blk5","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4","OPkBlk5"]
[]
[null,{"$f":"B96","v":"Existing (1 Jan-31 Dec): Tariff V - South Gippsland Residential"},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,C$32)","v":5324},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,D$32)","v":24596.847640000004},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,E$32)","v":18168.29062},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,F$32)","v":14198.818019999999},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,G$32)","v":19036.529849999999},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,H$32)","v":20412.190589999998},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,I$32)","v":5893.4570400000002},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,J$32)","v":3780.76755},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,K$32)","v":2390.2720299999996},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,L$32)","v":2237.18867},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,M$32)","v":1732.63374},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,N$32)","v":5413.1438699999999},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,O$32)","v":2609.8348700000001},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,P$32)","v":1367.7832599999999},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,Q$32)","v":1191.74737},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,R$32)","v":1400.41932},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,S$32)","v":21344.004570000001},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,T$32)","v":5784.3794900000003},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,U$32)","v":2586.1842699999997},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,V$32)","v":2098.6342100000002},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,W$32)","v":5478.0019400000001}]
[]
[null,{"$f":"B98","v":"Proposed (1 Jan-31 Dec): Tariff V - South Gippsland Residential"},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,C$32)","v":5324},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,D$32)","v":24596.847640000004},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,E$32)","v":18168.29062},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,F$32)","v":14198.818019999999},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,G$32)","v":19036.529849999999},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,H$32)","v":20412.190589999998},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,I$32)","v":5893.4570400000002},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,J$32)","v":3780.76755},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,K$32)","v":2390.2720299999996},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,L$32)","v":2237.18867},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,M$32)","v":1732.63374},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,N$32)","v":5413.1438699999999},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,O$32)","v":2609.8348700000001},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,P$32)","v":1367.7832599999999},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,Q$32)","v":1191.74737},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,R$32)","v":1400.41932},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,S$32)","v":21344.004570000001},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,T$32)","v":5784.3794900000003},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,U$32)","v":2586.1842699999997},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,V$32)","v":2098.6342100000002},{"$f":"INDEX(Prop2020DistTar!$F$100:$F$120,W$32)","v":5478.0019400000001}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3","Shd1Blk4","Shd1Blk5","Shd2Blk1","Shd2Blk2","Shd2Blk3","Shd2Blk4","Shd2Blk5","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4","OPkBlk5"]
[]
[null,{"$f":"B102","v":"Existing (1 Jan-31 Dec): Tariff V - South Gippsland Residential"},{"$f":"INDEX(Prop2020DistTar!$H$100:$H$120,C$33)","v":349981.12600000005},{"$f":"INDEX(Prop2020DistTar!$H$100:$H$120,D$33)","v":266950.07389576844},{"$f":"INDEX(Prop2020DistTar!$H$100:$H$120,E$33)","v":153447.56574745799},{"$f":"INDEX(Prop2020DistTar!$H$100:$H$120,F$33)","v":86739.159402377991},{"$f":"INDEX(Prop2020DistTar!$H$100:$H$120,G$33)","v":92747.87708218499},{"$f":"INDEX(Prop2020DistTar!$H$100:$H$120,H$33)","v":93038.764709219991},{"$f":"INDEX(Prop2020DistTar!$H$100:$H$120,I$33)","v":61874.137848726343},{"$f":"INDEX(Prop2020DistTar!$H$100:$H$120,J$33)","v":31017.038903445002},{"$f":"INDEX(Prop2020DistTar!$H$100:$H$120,K$33)","v":14302.670745910997},{"$f":"INDEX(Prop2020DistTar!$H$100:$H$120,L$33)","v":10757.969157428999},{"$f":"INDEX(Prop2020DistTar!$H$100:$H$120,M$33)","v":7814.524694148},{"$f":"INDEX(Prop2020DistTar!$H$100:$H$120,N$33)","v":56831.433186686634},{"$f":"INDEX(Prop2020DistTar!$H$100:$H$120,O$33)","v":21410.824289993005},{"$f":"INDEX(Prop2020DistTar!$H$100:$H$120,P$33)","v":8184.4046928619991},{"$f":"INDEX(Prop2020DistTar!$H$100:$H$120,Q$33)","v":5730.7555781190003},{"$f":"INDEX(Prop2020DistTar!$H$100:$H$120,R$33)","v":6316.1712170640003},{"$f":"INDEX(Prop2020DistTar!$H$100:$H$120,S$33)","v":208975.69673105265},{"$f":"INDEX(Prop2020DistTar!$H$100:$H$120,T$33)","v":44654.252786902005},{"$f":"INDEX(Prop2020DistTar!$H$100:$H$120,U$33)","v":14827.628893617997},{"$f":"INDEX(Prop2020DistTar!$H$100:$H$120,V$33)","v":9825.5955077990002},{"$f":"INDEX(Prop2020DistTar!$H$100:$H$120,W$33)","v":24184.830764906001}]
[]
[null,{"$f":"B104","v":"Proposed (1 Jan-31 Dec): Tariff V - South Gippsland Residential"},{"$f":"INDEX(Prop2020DistTar!$G$100:$G$120,C$32)","v":355616.58},{"$f":"INDEX(Prop2020DistTar!$G$100:$G$120,D$32)","v":279145.69159668614},{"$f":"INDEX(Prop2020DistTar!$G$100:$G$120,E$32)","v":155891.20083584799},{"$f":"INDEX(Prop2020DistTar!$G$100:$G$120,F$32)","v":88120.704395723995},{"$f":"INDEX(Prop2020DistTar!$G$100:$G$120,G$32)","v":94225.111798544996},{"$f":"INDEX(Prop2020DistTar!$G$100:$G$120,H$32)","v":94520.689746053991},{"$f":"INDEX(Prop2020DistTar!$G$100:$G$120,I$32)","v":64700.722502875164},{"$f":"INDEX(Prop2020DistTar!$G$100:$G$120,J$32)","v":31511.18522223},{"$f":"INDEX(Prop2020DistTar!$G$100:$G$120,K$32)","v":14530.463670369998},{"$f":"INDEX(Prop2020DistTar!$G$100:$G$120,L$32)","v":10929.337809551},{"$f":"INDEX(Prop2020DistTar!$G$100:$G$120,M$32)","v":7938.92779668},{"$f":"INDEX(Prop2020DistTar!$G$100:$G$120,N$32)","v":59427.652907945812},{"$f":"INDEX(Prop2020DistTar!$G$100:$G$120,O$32)","v":21751.929707502},{"$f":"INDEX(Prop2020DistTar!$G$100:$G$120,P$32)","v":8314.7544375399993},{"$f":"INDEX(Prop2020DistTar!$G$100:$G$120,Q$32)","v":5822.043426661},{"$f":"INDEX(Prop2020DistTar!$G$100:$G$120,R$32)","v":6416.7213242399994},{"$f":"INDEX(Prop2020DistTar!$G$100:$G$120,S$32)","v":218522.78148977432},{"$f":"INDEX(Prop2020DistTar!$G$100:$G$120,T$32)","v":45365.731464172008},{"$f":"INDEX(Prop2020DistTar!$G$100:$G$120,U$32)","v":15063.747517468999},{"$f":"INDEX(Prop2020DistTar!$G$100:$G$120,V$32)","v":9982.153619865001},{"$f":"INDEX(Prop2020DistTar!$G$100:$G$120,W$32)","v":24569.934301287998}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B108","v":"Existing (1 Jan-31 Dec): Tariff V - South Gippsland Residential"},{"$f":"SUM(C108:W108)","v":1569612.5018356708}]
[null,{"$f":"B110","v":"Proposed (1 Jan-31 Dec): Tariff V - South Gippsland Residential"},{"$f":"SUM(C110:W110)","v":1612368.0655710208}]
[]
[null,"Average price movement",{"$f":"IF(C114=0,\"\",C114/C113)","v":1.0272395662530382}]
[]
[null,{"$f":"IF(C116=\"\",\"\",IF(C116<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2020DistTar!B29","v":"Tariff V - Multinet Non-Residential"},1,2,3,4,5,null,null,null,null,null,null,null,null,null,null,null,6,7,8,9]
[null,null,1,2,3,4,5,6,7,8,9,10,11,null,null,null,null,null,12,13,14,15,16]
[null,"Distribution tariff","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3","Shd1Blk4","Shd1Blk5","Shd2Blk1","Shd2Blk2","Shd2Blk3","Shd2Blk4","Shd2Blk5","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4","OPkBlk5"]
[]
[null,{"$f":"\"Existing (1 Jan - 31 Dec): \"&Prop2020DistTar!C29","v":"Existing (1 Jan - 31 Dec): Tariff V - Multinet Non-Residential"},{"$f":"INDEX(Prop2020DistTar!$E$31:$E$51,C$33)","v":0.29709999999999998},{"$f":"INDEX(Prop2020DistTar!$E$31:$E$51,D$33)","v":3.821572772743568},{"$f":"INDEX(Prop2020DistTar!$E$31:$E$51,E$33)","v":2.3117999999999999},{"$f":"INDEX(Prop2020DistTar!$E$31:$E$51,F$33)","v":1.3871},{"$f":"INDEX(Prop2020DistTar!$E$31:$E$51,G$33)","v":0.77190000000000003},{"$f":"INDEX(Prop2020DistTar!$E$31:$E$51,H$33)","v":0.2576},{"$f":"INDEX(Prop2020DistTar!$E$31:$E$51,I$33)","v":3.5070925582600845},{"$f":"INDEX(Prop2020DistTar!$E$31:$E$51,J$33)","v":2.0808},{"$f":"INDEX(Prop2020DistTar!$E$31:$E$51,K$33)","v":1.3177000000000001},{"$f":"INDEX(Prop2020DistTar!$E$31:$E$51,L$33)","v":0.75209999999999999},{"$f":"INDEX(Prop2020DistTar!$E$31:$E$51,M$33)","v":0.2316},{"$f":"INDEX(Prop2020DistTar!$E$31:$E$51,N$33)","v":3.5070925582600845},{"$f":"INDEX(Prop2020DistTar!$E$31:$E$51,O$33)","v":2.0808},{"$f":"INDEX(Prop2020DistTar!$E$31:$E$51,P$33)","v":1.3177000000000001},{"$f":"INDEX(Prop2020DistTar!$E$31:$E$51,Q$33)","v":0.75209999999999999},{"$f":"INDEX(Prop2020DistTar!$E$31:$E$51,R$33)","v":0.2316},{"$f":"INDEX(Prop2020DistTar!$E$31:$E$51,S$33)","v":3.1806859484169481},{"$f":"INDEX(Prop2020DistTar!$E$31:$E$51,T$33)","v":2.0091000000000001},{"$f":"INDEX(Prop2020DistTar!$E$31:$E$51,U$33)","v":1.2025999999999999},{"$f":"INDEX(Prop2020DistTar!$E$31:$E$51,V$33)","v":0.7288},{"$f":"INDEX(Prop2020DistTar!$E$31:$E$51,W$33)","v":0.20580000000000001}]
[]
[null,{"$f":"\"Proposed (1 Jan-31 Dec): \"&B122","v":"Proposed (1 Jan-31 Dec): Tariff V - Multinet Non-Residential"},{"$f":"INDEX(Prop2020DistTar!$D$31:$D$51,C$32)","v":0.30180000000000001},{"$f":"INDEX(Prop2020DistTar!$D$31:$D$51,D$32)","v":3.9961125101069404},{"$f":"INDEX(Prop2020DistTar!$D$31:$D$51,E$32)","v":2.3485999999999998},{"$f":"INDEX(Prop2020DistTar!$D$31:$D$51,F$32)","v":1.4092},{"$f":"INDEX(Prop2020DistTar!$D$31:$D$51,G$32)","v":0.78420000000000001},{"$f":"INDEX(Prop2020DistTar!$D$31:$D$51,H$32)","v":0.26169999999999999},{"$f":"INDEX(Prop2020DistTar!$D$31:$D$51,I$32)","v":3.6673575297524805},{"$f":"INDEX(Prop2020DistTar!$D$31:$D$51,J$32)","v":2.1139000000000001},{"$f":"INDEX(Prop2020DistTar!$D$31:$D$51,K$32)","v":1.3387},{"$f":"INDEX(Prop2020DistTar!$D$31:$D$51,L$32)","v":0.7641},{"$f":"INDEX(Prop2020DistTar!$D$31:$D$51,M$32)","v":0.23530000000000001},{"$f":"INDEX(Prop2020DistTar!$D$31:$D$51,N$32)","v":3.6673575297524805},{"$f":"INDEX(Prop2020DistTar!$D$31:$D$51,O$32)","v":2.1139000000000001},{"$f":"INDEX(Prop2020DistTar!$D$31:$D$51,P$32)","v":1.3387},{"$f":"INDEX(Prop2020DistTar!$D$31:$D$51,Q$32)","v":0.7641},{"$f":"INDEX(Prop2020DistTar!$D$31:$D$51,R$32)","v":0.23530000000000001},{"$f":"INDEX(Prop2020DistTar!$D$31:$D$51,S$32)","v":3.3260452207808484},{"$f":"INDEX(Prop2020DistTar!$D$31:$D$51,T$32)","v":2.0411000000000001},{"$f":"INDEX(Prop2020DistTar!$D$31:$D$51,U$32)","v":1.2218},{"$f":"INDEX(Prop2020DistTar!$D$31:$D$51,V$32)","v":0.74039999999999995},{"$f":"INDEX(Prop2020DistTar!$D$31:$D$51,W$32)","v":0.20910000000000001}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3","Shd1Blk4","Shd1Blk5","Shd2Blk1","Shd2Blk2","Shd2Blk3","Shd2Blk4","Shd2Blk5","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4","OPkBlk5"]
[]
[null,{"$f":"B126","v":"Existing (1 Jan - 31 Dec): Tariff V - Multinet Non-Residential"},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,C$32)","v":15893},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,D$32)","v":307852.08324999997},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,E$32)","v":503329.67335000006},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,F$32)","v":195782.12727},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,G$32)","v":650338.59620000003},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,H$32)","v":795170.69657999999},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,I$32)","v":74339.004409999994},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,J$32)","v":116401.105},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,K$32)","v":44612.173840000003},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,L$32)","v":145114.82343000002},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,M$32)","v":151403.53863999998},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,N$32)","v":68871.141530000008},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,O$32)","v":104777.22123000001},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,P$32)","v":40641.859049999999},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,Q$32)","v":127399.46498999999},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,R$32)","v":119291.88659000001},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,S$32)","v":341453.58964000002},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,T$32)","v":511890.74904999998},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,U$32)","v":189883.52656},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,V$32)","v":547490.35448999994},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,W$32)","v":478141.99687000003}]
[]
[null,{"$f":"B128","v":"Proposed (1 Jan-31 Dec): Tariff V - Multinet Non-Residential"},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,C$32)","v":15893},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,D$32)","v":307852.08324999997},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,E$32)","v":503329.67335000006},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,F$32)","v":195782.12727},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,G$32)","v":650338.59620000003},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,H$32)","v":795170.69657999999},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,I$32)","v":74339.004409999994},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,J$32)","v":116401.105},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,K$32)","v":44612.173840000003},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,L$32)","v":145114.82343000002},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,M$32)","v":151403.53863999998},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,N$32)","v":68871.141530000008},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,O$32)","v":104777.22123000001},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,P$32)","v":40641.859049999999},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,Q$32)","v":127399.46498999999},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,R$32)","v":119291.88659000001},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,S$32)","v":341453.58964000002},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,T$32)","v":511890.74904999998},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,U$32)","v":189883.52656},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,V$32)","v":547490.35448999994},{"$f":"INDEX(Prop2020DistTar!$F$31:$F$51,W$32)","v":478141.99687000003}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3","Shd1Blk4","Shd1Blk5","Shd2Blk1","Shd2Blk2","Shd2Blk3","Shd2Blk4","Shd2Blk5","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4","OPkBlk5"]
[]
[null,{"$f":"B132","v":"Existing (1 Jan - 31 Dec): Tariff V - Multinet Non-Residential"},{"$f":"INDEX(Prop2020DistTar!$H$31:$H$51,C$33)","v":1723460.7594999997},{"$f":"INDEX(Prop2020DistTar!$H$31:$H$51,D$33)","v":1176479.1393805861},{"$f":"INDEX(Prop2020DistTar!$H$31:$H$51,E$33)","v":1163597.5388505301},{"$f":"INDEX(Prop2020DistTar!$H$31:$H$51,F$33)","v":271569.38873621699},{"$f":"INDEX(Prop2020DistTar!$H$31:$H$51,G$33)","v":501996.36240678007},{"$f":"INDEX(Prop2020DistTar!$H$31:$H$51,H$33)","v":204835.97143900799},{"$f":"INDEX(Prop2020DistTar!$H$31:$H$51,I$33)","v":260713.76915477458},{"$f":"INDEX(Prop2020DistTar!$H$31:$H$51,J$33)","v":242207.419284},{"$f":"INDEX(Prop2020DistTar!$H$31:$H$51,K$33)","v":58785.461468968009},{"$f":"INDEX(Prop2020DistTar!$H$31:$H$51,L$33)","v":109140.85870170301},{"$f":"INDEX(Prop2020DistTar!$H$31:$H$51,M$33)","v":35065.059549023994},{"$f":"INDEX(Prop2020DistTar!$H$31:$H$51,N$33)","v":241537.46793874007},{"$f":"INDEX(Prop2020DistTar!$H$31:$H$51,O$33)","v":218020.44193538401},{"$f":"INDEX(Prop2020DistTar!$H$31:$H$51,P$33)","v":53553.777670185002},{"$f":"INDEX(Prop2020DistTar!$H$31:$H$51,Q$33)","v":95817.137618978988},{"$f":"INDEX(Prop2020DistTar!$H$31:$H$51,R$33)","v":27628.000934244003},{"$f":"INDEX(Prop2020DistTar!$H$31:$H$51,S$33)","v":1086056.6346044748},{"$f":"INDEX(Prop2020DistTar!$H$31:$H$51,T$33)","v":1028439.703916355},{"$f":"INDEX(Prop2020DistTar!$H$31:$H$51,U$33)","v":228353.92904105599},{"$f":"INDEX(Prop2020DistTar!$H$31:$H$51,V$33)","v":399010.97035231197},{"$f":"INDEX(Prop2020DistTar!$H$31:$H$51,W$33)","v":98401.622955846018}]
[]
[null,{"$f":"B134","v":"Proposed (1 Jan-31 Dec): Tariff V - Multinet Non-Residential"},{"$f":"INDEX(Prop2020DistTar!$G$31:$G$51,C$32)","v":1750725.2010000001},{"$f":"INDEX(Prop2020DistTar!$G$31:$G$51,D$32)","v":1230211.561137808},{"$f":"INDEX(Prop2020DistTar!$G$31:$G$51,E$32)","v":1182120.0708298101},{"$f":"INDEX(Prop2020DistTar!$G$31:$G$51,F$32)","v":275896.173748884},{"$f":"INDEX(Prop2020DistTar!$G$31:$G$51,G$32)","v":509995.52714004001},{"$f":"INDEX(Prop2020DistTar!$G$31:$G$51,H$32)","v":208096.17129498598},{"$f":"INDEX(Prop2020DistTar!$G$31:$G$51,I$32)","v":272627.70757731632},{"$f":"INDEX(Prop2020DistTar!$G$31:$G$51,J$32)","v":246060.29585950001},{"$f":"INDEX(Prop2020DistTar!$G$31:$G$51,K$32)","v":59722.317119608007},{"$f":"INDEX(Prop2020DistTar!$G$31:$G$51,L$32)","v":110882.23658286301},{"$f":"INDEX(Prop2020DistTar!$G$31:$G$51,M$32)","v":35625.252641991996},{"$f":"INDEX(Prop2020DistTar!$G$31:$G$51,N$32)","v":252575.0994726943},{"$f":"INDEX(Prop2020DistTar!$G$31:$G$51,O$32)","v":221488.56795809703},{"$f":"INDEX(Prop2020DistTar!$G$31:$G$51,P$32)","v":54407.256710235},{"$f":"INDEX(Prop2020DistTar!$G$31:$G$51,Q$32)","v":97345.931198858991},{"$f":"INDEX(Prop2020DistTar!$G$31:$G$51,R$32)","v":28069.380914627003},{"$f":"INDEX(Prop2020DistTar!$G$31:$G$51,S$32)","v":1135690.079940587},{"$f":"INDEX(Prop2020DistTar!$G$31:$G$51,T$32)","v":1044820.207885955},{"$f":"INDEX(Prop2020DistTar!$G$31:$G$51,U$32)","v":231999.692751008},{"$f":"INDEX(Prop2020DistTar!$G$31:$G$51,V$32)","v":405361.85846439592},{"$f":"INDEX(Prop2020DistTar!$G$31:$G$51,W$32)","v":99979.491545517012}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B138","v":"Existing (1 Jan - 31 Dec): Tariff V - Multinet Non-Residential"},{"$f":"SUM(C137:W138)","v":9224671.415439168}]
[null,{"$f":"B140","v":"Proposed (1 Jan-31 Dec): Tariff V - Multinet Non-Residential"},{"$f":"SUM(C139:W140)","v":9453700.0817747805}]
[]
[null,"Average price movement",{"$f":"IF(C144=0,\"\",C144/C143)","v":1.0248278400412498}]
[]
[null,{"$f":"IF(C146=\"\",\"\",IF(C146<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2020DistTar!B75","v":"Tariff V - Yarra Valley Non-Residential"},1,2,3,4,5,null,null,null,null,null,null,null,null,null,null,null,6,7,8,9]
[null,null,1,2,3,4,5,6,7,8,9,10,11,null,null,null,null,null,12,13,14,15,16]
[null,"Distribution tariff","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3","Shd1Blk4","Shd1Blk5","Shd2Blk1","Shd2Blk2","Shd2Blk3","Shd2Blk4","Shd2Blk5","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4","OPkBlk5"]
[]
[null,{"$f":"\"Existing (1 Jan - 31 Dec): \"&Prop2020DistTar!C75","v":"Existing (1 Jan - 31 Dec): Tariff V - Yarra Valley Non-Residential"},{"$f":"INDEX(Prop2020DistTar!$E$77:$E$97,C$33)","v":0.29570000000000002},{"$f":"INDEX(Prop2020DistTar!$E$77:$E$97,D$33)","v":6.4142037359270958},{"$f":"INDEX(Prop2020DistTar!$E$77:$E$97,E$33)","v":5.0396000000000001},{"$f":"INDEX(Prop2020DistTar!$E$77:$E$97,F$33)","v":4.2872000000000003},{"$f":"INDEX(Prop2020DistTar!$E$77:$E$97,G$33)","v":3.7865000000000002},{"$f":"INDEX(Prop2020DistTar!$E$77:$E$97,H$33)","v":3.3677999999999999},{"$f":"INDEX(Prop2020DistTar!$E$77:$E$97,I$33)","v":6.1582047057071749},{"$f":"INDEX(Prop2020DistTar!$E$77:$E$97,J$33)","v":4.8514999999999997},{"$f":"INDEX(Prop2020DistTar!$E$77:$E$97,K$33)","v":4.2305999999999999},{"$f":"INDEX(Prop2020DistTar!$E$77:$E$97,L$33)","v":3.7703000000000002},{"$f":"INDEX(Prop2020DistTar!$E$77:$E$97,M$33)","v":3.3468},{"$f":"INDEX(Prop2020DistTar!$E$77:$E$97,N$33)","v":6.1582047057071749},{"$f":"INDEX(Prop2020DistTar!$E$77:$E$97,O$33)","v":4.8514999999999997},{"$f":"INDEX(Prop2020DistTar!$E$77:$E$97,P$33)","v":4.2305999999999999},{"$f":"INDEX(Prop2020DistTar!$E$77:$E$97,Q$33)","v":3.7703000000000002},{"$f":"INDEX(Prop2020DistTar!$E$77:$E$97,R$33)","v":3.3468},{"$f":"INDEX(Prop2020DistTar!$E$77:$E$97,S$33)","v":5.8923716301906968},{"$f":"INDEX(Prop2020DistTar!$E$77:$E$97,T$33)","v":4.7934000000000001},{"$f":"INDEX(Prop2020DistTar!$E$77:$E$97,U$33)","v":4.1368999999999998},{"$f":"INDEX(Prop2020DistTar!$E$77:$E$97,V$33)","v":3.7513999999999998},{"$f":"INDEX(Prop2020DistTar!$E$77:$E$97,W$33)","v":3.3256999999999999}]
[]
[null,{"$f":"\"Proposed (1 Jan-31 Dec): \"&B152","v":"Proposed (1 Jan-31 Dec): Tariff V - Yarra Valley Non-Residential"},{"$f":"INDEX(Prop2020DistTar!$D$77:$D$97,C$32)","v":0.3004},{"$f":"INDEX(Prop2020DistTar!$D$77:$D$97,D$32)","v":6.7072603443387768},{"$f":"INDEX(Prop2020DistTar!$D$77:$D$97,E$32)","v":5.1199000000000003},{"$f":"INDEX(Prop2020DistTar!$D$77:$D$97,F$32)","v":4.3555000000000001},{"$f":"INDEX(Prop2020DistTar!$D$77:$D$97,G$32)","v":3.8468},{"$f":"INDEX(Prop2020DistTar!$D$77:$D$97,H$32)","v":3.4214000000000002},{"$f":"INDEX(Prop2020DistTar!$D$77:$D$97,I$32)","v":6.4395422153776156},{"$f":"INDEX(Prop2020DistTar!$D$77:$D$97,J$32)","v":4.9287999999999998},{"$f":"INDEX(Prop2020DistTar!$D$77:$D$97,K$32)","v":4.298},{"$f":"INDEX(Prop2020DistTar!$D$77:$D$97,L$32)","v":3.8304},{"$f":"INDEX(Prop2020DistTar!$D$77:$D$97,M$32)","v":3.4001000000000001},{"$f":"INDEX(Prop2020DistTar!$D$77:$D$97,N$32)","v":6.4395422153776156},{"$f":"INDEX(Prop2020DistTar!$D$77:$D$97,O$32)","v":4.9287999999999998},{"$f":"INDEX(Prop2020DistTar!$D$77:$D$97,P$32)","v":4.298},{"$f":"INDEX(Prop2020DistTar!$D$77:$D$97,Q$32)","v":3.8304},{"$f":"INDEX(Prop2020DistTar!$D$77:$D$97,R$32)","v":3.4001000000000001},{"$f":"INDEX(Prop2020DistTar!$D$77:$D$97,S$32)","v":6.1615311941072965},{"$f":"INDEX(Prop2020DistTar!$D$77:$D$97,T$32)","v":4.8697999999999997},{"$f":"INDEX(Prop2020DistTar!$D$77:$D$97,U$32)","v":4.2027999999999999},{"$f":"INDEX(Prop2020DistTar!$D$77:$D$97,V$32)","v":3.8111999999999999},{"$f":"INDEX(Prop2020DistTar!$D$77:$D$97,W$32)","v":3.3786999999999998}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3","Shd1Blk4","Shd1Blk5","Shd2Blk1","Shd2Blk2","Shd2Blk3","Shd2Blk4","Shd2Blk5","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4","OPkBlk5"]
[]
[null,{"$f":"B156","v":"Existing (1 Jan - 31 Dec): Tariff V - Yarra Valley Non-Residential"},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,C$32)","v":70},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,D$32)","v":1542.6934799999999},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,E$32)","v":2565.5678100000005},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,F$32)","v":812.33832000000007},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,G$32)","v":2172.7020600000001},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,H$32)","v":8217.7133900000008},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,I$32)","v":357.93822999999998},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,J$32)","v":578.58330000000001},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,K$32)","v":175.59529000000001},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,L$32)","v":427.66823999999997},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,M$32)","v":2089.8679400000001},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,N$32)","v":376.46870000000001},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,O$32)","v":512.62018999999998},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,P$32)","v":126.52008000000001},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,Q$32)","v":390.21409},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,R$32)","v":599.17699000000005},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,S$32)","v":1664.4567999999999},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,T$32)","v":2241.6357900000003},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,U$32)","v":578.90175999999997},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,V$32)","v":1896.4012599999999},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,W$32)","v":1265.9805000000001}]
[]
[null,{"$f":"B158","v":"Proposed (1 Jan-31 Dec): Tariff V - Yarra Valley Non-Residential"},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,C$32)","v":70},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,D$32)","v":1542.6934799999999},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,E$32)","v":2565.5678100000005},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,F$32)","v":812.33832000000007},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,G$32)","v":2172.7020600000001},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,H$32)","v":8217.7133900000008},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,I$32)","v":357.93822999999998},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,J$32)","v":578.58330000000001},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,K$32)","v":175.59529000000001},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,L$32)","v":427.66823999999997},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,M$32)","v":2089.8679400000001},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,N$32)","v":376.46870000000001},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,O$32)","v":512.62018999999998},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,P$32)","v":126.52008000000001},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,Q$32)","v":390.21409},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,R$32)","v":599.17699000000005},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,S$32)","v":1664.4567999999999},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,T$32)","v":2241.6357900000003},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,U$32)","v":578.90175999999997},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,V$32)","v":1896.4012599999999},{"$f":"INDEX(Prop2020DistTar!$F$77:$F$97,W$32)","v":1265.9805000000001}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3","Shd1Blk4","Shd1Blk5","Shd2Blk1","Shd2Blk2","Shd2Blk3","Shd2Blk4","Shd2Blk5","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4","OPkBlk5"]
[]
[null,{"$f":"B162","v":"Existing (1 Jan - 31 Dec): Tariff V - Yarra Valley Non-Residential"},{"$f":"INDEX(Prop2020DistTar!$H$77:$H$97,C$33)","v":7555.1350000000002},{"$f":"INDEX(Prop2020DistTar!$H$77:$H$97,D$33)","v":9895.1502828063713},{"$f":"INDEX(Prop2020DistTar!$H$77:$H$97,E$33)","v":12929.435535276003},{"$f":"INDEX(Prop2020DistTar!$H$77:$H$97,F$33)","v":3482.6568455040006},{"$f":"INDEX(Prop2020DistTar!$H$77:$H$97,G$33)","v":8226.9363501900007},{"$f":"INDEX(Prop2020DistTar!$H$77:$H$97,H$33)","v":27675.615154842002},{"$f":"INDEX(Prop2020DistTar!$H$77:$H$97,I$33)","v":2204.256892338497},{"$f":"INDEX(Prop2020DistTar!$H$77:$H$97,J$33)","v":2806.9968799499998},{"$f":"INDEX(Prop2020DistTar!$H$77:$H$97,K$33)","v":742.87343387400006},{"$f":"INDEX(Prop2020DistTar!$H$77:$H$97,L$33)","v":1612.437565272},{"$f":"INDEX(Prop2020DistTar!$H$77:$H$97,M$33)","v":6994.3700215920007},{"$f":"INDEX(Prop2020DistTar!$H$77:$H$97,N$33)","v":2318.3713198914629},{"$f":"INDEX(Prop2020DistTar!$H$77:$H$97,O$33)","v":2486.9768517849998},{"$f":"INDEX(Prop2020DistTar!$H$77:$H$97,P$33)","v":535.25585044800005},{"$f":"INDEX(Prop2020DistTar!$H$77:$H$97,Q$33)","v":1471.2241835270002},{"$f":"INDEX(Prop2020DistTar!$H$77:$H$97,R$33)","v":2005.3255501320002},{"$f":"INDEX(Prop2020DistTar!$H$77:$H$97,S$33)","v":9807.5980279979904},{"$f":"INDEX(Prop2020DistTar!$H$77:$H$97,T$33)","v":10745.056995786001},{"$f":"INDEX(Prop2020DistTar!$H$77:$H$97,U$33)","v":2394.8586909439996},{"$f":"INDEX(Prop2020DistTar!$H$77:$H$97,V$33)","v":7114.1596867639992},{"$f":"INDEX(Prop2020DistTar!$H$77:$H$97,W$33)","v":4210.2713488500003}]
[]
[null,{"$f":"B164","v":"Proposed (1 Jan-31 Dec): Tariff V - Yarra Valley Non-Residential"},{"$f":"INDEX(Prop2020DistTar!$G$77:$G$97,C$32)","v":7675.2199999999993},{"$f":"INDEX(Prop2020DistTar!$G$77:$G$97,D$32)","v":10347.246801873986},{"$f":"INDEX(Prop2020DistTar!$G$77:$G$97,E$32)","v":13135.450630419004},{"$f":"INDEX(Prop2020DistTar!$G$77:$G$97,F$32)","v":3538.1395527600002},{"$f":"INDEX(Prop2020DistTar!$G$77:$G$97,G$32)","v":8357.9502844079998},{"$f":"INDEX(Prop2020DistTar!$G$77:$G$97,H$32)","v":28116.084592546005},{"$f":"INDEX(Prop2020DistTar!$G$77:$G$97,I$32)","v":2304.9583425825422},{"$f":"INDEX(Prop2020DistTar!$G$77:$G$97,J$32)","v":2851.7213690399999},{"$f":"INDEX(Prop2020DistTar!$G$77:$G$97,K$32)","v":754.70855642000004},{"$f":"INDEX(Prop2020DistTar!$G$77:$G$97,L$32)","v":1638.1404264959999},{"$f":"INDEX(Prop2020DistTar!$G$77:$G$97,M$32)","v":7105.7599827940003},{"$f":"INDEX(Prop2020DistTar!$G$77:$G$97,N$32)","v":2424.2860864183313},{"$f":"INDEX(Prop2020DistTar!$G$77:$G$97,O$32)","v":2526.6023924719998},{"$f":"INDEX(Prop2020DistTar!$G$77:$G$97,P$32)","v":543.78330384000003},{"$f":"INDEX(Prop2020DistTar!$G$77:$G$97,Q$32)","v":1494.6760503360001},{"$f":"INDEX(Prop2020DistTar!$G$77:$G$97,R$32)","v":2037.2616836990003},{"$f":"INDEX(Prop2020DistTar!$G$77:$G$97,S$32)","v":10255.602494444009},{"$f":"INDEX(Prop2020DistTar!$G$77:$G$97,T$32)","v":10916.317970142001},{"$f":"INDEX(Prop2020DistTar!$G$77:$G$97,U$32)","v":2433.0083169279997},{"$f":"INDEX(Prop2020DistTar!$G$77:$G$97,V$32)","v":7227.5644821119995},{"$f":"INDEX(Prop2020DistTar!$G$77:$G$97,W$32)","v":4277.3683153500006}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B168","v":"Existing (1 Jan - 31 Dec): Tariff V - Yarra Valley Non-Residential"},{"$f":"SUM(C167:W168)","v":127214.96246777033}]
[null,{"$f":"B170","v":"Proposed (1 Jan-31 Dec): Tariff V - Yarra Valley Non-Residential"},{"$f":"SUM(C169:W170)","v":129961.85163508086}]
[]
[null,"Average price movement",{"$f":"IF(C174=0,\"\",C174/C173)","v":1.0215925007092344}]
[]
[null,{"$f":"IF(C176=\"\",\"\",IF(C176<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2020DistTar!B121","v":"Tariff V - South Gippsland Non-Residential"},1,2,3,4,5,null,null,null,null,null,null,null,null,null,null,null,6,7,8,9]
[null,null,1,2,3,4,5,6,7,8,9,10,11,null,null,null,null,null,12,13,14,15,16]
[null,"Distribution tariff","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3","Shd1Blk4","Shd1Blk5","Shd2Blk1","Shd2Blk2","Shd2Blk3","Shd2Blk4","Shd2Blk5","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4","OPkBlk5"]
[]
[null,{"$f":"\"Existing (1 Jan - 31 Dec): \"&Prop2020DistTar!C121","v":"Existing (1 Jan - 31 Dec): Tariff V - South Gippsland Non-Residential"},{"$f":"INDEX(Prop2020DistTar!$E$123:$E$143,C$33)","v":0.29709999999999998},{"$f":"INDEX(Prop2020DistTar!$E$123:$E$143,D$33)","v":7.0746540333436734},{"$f":"INDEX(Prop2020DistTar!$E$123:$E$143,E$33)","v":5.6033999999999997},{"$f":"INDEX(Prop2020DistTar!$E$123:$E$143,F$33)","v":4.8041999999999998},{"$f":"INDEX(Prop2020DistTar!$E$123:$E$143,G$33)","v":4.2727000000000004},{"$f":"INDEX(Prop2020DistTar!$E$123:$E$143,H$33)","v":3.8279999999999998},{"$f":"INDEX(Prop2020DistTar!$E$123:$E$143,I$33)","v":6.8028577601473694},{"$f":"INDEX(Prop2020DistTar!$E$123:$E$143,J$33)","v":5.4035000000000002},{"$f":"INDEX(Prop2020DistTar!$E$123:$E$143,K$33)","v":4.7443},{"$f":"INDEX(Prop2020DistTar!$E$123:$E$143,L$33)","v":4.2553999999999998},{"$f":"INDEX(Prop2020DistTar!$E$123:$E$143,M$33)","v":3.8056000000000001},{"$f":"INDEX(Prop2020DistTar!$E$123:$E$143,N$33)","v":6.8028577601473694},{"$f":"INDEX(Prop2020DistTar!$E$123:$E$143,O$33)","v":5.4035000000000002},{"$f":"INDEX(Prop2020DistTar!$E$123:$E$143,P$33)","v":4.7443},{"$f":"INDEX(Prop2020DistTar!$E$123:$E$143,Q$33)","v":4.2553999999999998},{"$f":"INDEX(Prop2020DistTar!$E$123:$E$143,R$33)","v":3.8056000000000001},{"$f":"INDEX(Prop2020DistTar!$E$123:$E$143,S$33)","v":6.5205997366355799},{"$f":"INDEX(Prop2020DistTar!$E$123:$E$143,T$33)","v":5.3418000000000001},{"$f":"INDEX(Prop2020DistTar!$E$123:$E$143,U$33)","v":4.6445999999999996},{"$f":"INDEX(Prop2020DistTar!$E$123:$E$143,V$33)","v":4.2352999999999996},{"$f":"INDEX(Prop2020DistTar!$E$123:$E$143,W$33)","v":3.7833000000000001}]
[]
[null,{"$f":"\"Proposed (1 Jan-31 Dec): \"&B182","v":"Proposed (1 Jan-31 Dec): Tariff V - South Gippsland Non-Residential"},{"$f":"INDEX(Prop2020DistTar!$D$123:$D$143,C$32)","v":0.30180000000000001},{"$f":"INDEX(Prop2020DistTar!$D$123:$D$143,D$32)","v":7.3978104893600891},{"$f":"INDEX(Prop2020DistTar!$D$123:$D$143,E$32)","v":5.6927000000000003},{"$f":"INDEX(Prop2020DistTar!$D$123:$D$143,F$32)","v":4.8807},{"$f":"INDEX(Prop2020DistTar!$D$123:$D$143,G$32)","v":4.3407999999999998},{"$f":"INDEX(Prop2020DistTar!$D$123:$D$143,H$32)","v":3.8889999999999998},{"$f":"INDEX(Prop2020DistTar!$D$123:$D$143,I$32)","v":7.1136237327042773},{"$f":"INDEX(Prop2020DistTar!$D$123:$D$143,J$32)","v":5.4896000000000003},{"$f":"INDEX(Prop2020DistTar!$D$123:$D$143,K$32)","v":4.8198999999999996},{"$f":"INDEX(Prop2020DistTar!$D$123:$D$143,L$32)","v":4.3231999999999999},{"$f":"INDEX(Prop2020DistTar!$D$123:$D$143,M$32)","v":3.8662000000000001},{"$f":"INDEX(Prop2020DistTar!$D$123:$D$143,N$32)","v":7.1136237327042773},{"$f":"INDEX(Prop2020DistTar!$D$123:$D$143,O$32)","v":5.4896000000000003},{"$f":"INDEX(Prop2020DistTar!$D$123:$D$143,P$32)","v":4.8198999999999996},{"$f":"INDEX(Prop2020DistTar!$D$123:$D$143,Q$32)","v":4.3231999999999999},{"$f":"INDEX(Prop2020DistTar!$D$123:$D$143,R$32)","v":3.8662000000000001},{"$f":"INDEX(Prop2020DistTar!$D$123:$D$143,S$32)","v":6.8185265102007593},{"$f":"INDEX(Prop2020DistTar!$D$123:$D$143,T$32)","v":5.4268999999999998},{"$f":"INDEX(Prop2020DistTar!$D$123:$D$143,U$32)","v":4.7186000000000003},{"$f":"INDEX(Prop2020DistTar!$D$123:$D$143,V$32)","v":4.3028000000000004},{"$f":"INDEX(Prop2020DistTar!$D$123:$D$143,W$32)","v":3.8435999999999999}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3","Shd1Blk4","Shd1Blk5","Shd2Blk1","Shd2Blk2","Shd2Blk3","Shd2Blk4","Shd2Blk5","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4","OPkBlk5"]
[]
[null,{"$f":"B186","v":"Existing (1 Jan - 31 Dec): Tariff V - South Gippsland Non-Residential"},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,C$32)","v":112},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,D$32)","v":2428.1611800000001},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,E$32)","v":4550.35041},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,F$32)","v":2154.0236},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,G$32)","v":8849.6441299999988},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,H$32)","v":13120.50102},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,I$32)","v":572.76757999999995},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,J$32)","v":1090.4086399999999},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,K$32)","v":513.68150000000003},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,L$32)","v":2056.1503200000002},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,M$32)","v":2889.3577700000001},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,N$32)","v":554.19888000000003},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,O$32)","v":1052.26872},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,P$32)","v":482.43288000000001},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,Q$32)","v":1964.6681000000001},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,R$32)","v":2202.7962799999996},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,S$32)","v":2968.2225199999998},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,T$32)","v":5770.2372500000001},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,U$32)","v":2611.9120400000002},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,V$32)","v":8567.8251200000013},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,W$32)","v":8087.8432400000002}]
[]
[null,{"$f":"B188","v":"Proposed (1 Jan-31 Dec): Tariff V - South Gippsland Non-Residential"},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,C$32)","v":112},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,D$32)","v":2428.1611800000001},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,E$32)","v":4550.35041},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,F$32)","v":2154.0236},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,G$32)","v":8849.6441299999988},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,H$32)","v":13120.50102},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,I$32)","v":572.76757999999995},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,J$32)","v":1090.4086399999999},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,K$32)","v":513.68150000000003},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,L$32)","v":2056.1503200000002},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,M$32)","v":2889.3577700000001},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,N$32)","v":554.19888000000003},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,O$32)","v":1052.26872},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,P$32)","v":482.43288000000001},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,Q$32)","v":1964.6681000000001},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,R$32)","v":2202.7962799999996},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,S$32)","v":2968.2225199999998},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,T$32)","v":5770.2372500000001},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,U$32)","v":2611.9120400000002},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,V$32)","v":8567.8251200000013},{"$f":"INDEX(Prop2020DistTar!$F$123:$F$143,W$32)","v":8087.8432400000002}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3","Shd1Blk4","Shd1Blk5","Shd2Blk1","Shd2Blk2","Shd2Blk3","Shd2Blk4","Shd2Blk5","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4","OPkBlk5"]
[]
[null,{"$f":"B192","v":"Existing (1 Jan - 31 Dec): Tariff V - South Gippsland Non-Residential"},{"$f":"INDEX(Prop2020DistTar!$H$123:$H$143,C$33)","v":12145.447999999999},{"$f":"INDEX(Prop2020DistTar!$H$123:$H$143,D$33)","v":17178.400285695534},{"$f":"INDEX(Prop2020DistTar!$H$123:$H$143,E$33)","v":25497.433487393999},{"$f":"INDEX(Prop2020DistTar!$H$123:$H$143,F$33)","v":10348.36017912},{"$f":"INDEX(Prop2020DistTar!$H$123:$H$143,G$33)","v":37811.874474250995},{"$f":"INDEX(Prop2020DistTar!$H$123:$H$143,H$33)","v":50225.277904559996},{"$f":"INDEX(Prop2020DistTar!$H$123:$H$143,I$33)","v":3896.4563763638289},{"$f":"INDEX(Prop2020DistTar!$H$123:$H$143,J$33)","v":5892.0230862399994},{"$f":"INDEX(Prop2020DistTar!$H$123:$H$143,K$33)","v":2437.0591404500001},{"$f":"INDEX(Prop2020DistTar!$H$123:$H$143,L$33)","v":8749.7420717280002},{"$f":"INDEX(Prop2020DistTar!$H$123:$H$143,M$33)","v":10995.739929512001},{"$f":"INDEX(Prop2020DistTar!$H$123:$H$143,N$33)","v":3770.1361514729811},{"$f":"INDEX(Prop2020DistTar!$H$123:$H$143,O$33)","v":5685.9340285200005},{"$f":"INDEX(Prop2020DistTar!$H$123:$H$143,P$33)","v":2288.8063125839999},{"$f":"INDEX(Prop2020DistTar!$H$123:$H$143,Q$33)","v":8360.4486327400009},{"$f":"INDEX(Prop2020DistTar!$H$123:$H$143,R$33)","v":8382.9615231679982},{"$f":"INDEX(Prop2020DistTar!$H$123:$H$143,S$33)","v":19354.590982187798},{"$f":"INDEX(Prop2020DistTar!$H$123:$H$143,T$33)","v":30823.453342050001},{"$f":"INDEX(Prop2020DistTar!$H$123:$H$143,U$33)","v":12131.286660984},{"$f":"INDEX(Prop2020DistTar!$H$123:$H$143,V$33)","v":36287.309730736},{"$f":"INDEX(Prop2020DistTar!$H$123:$H$143,W$33)","v":30598.737329892003}]
[]
[null,{"$f":"B194","v":"Proposed (1 Jan-31 Dec): Tariff V - South Gippsland Non-Residential"},{"$f":"INDEX(Prop2020DistTar!$G$123:$G$143,C$32)","v":12337.584000000001},{"$f":"INDEX(Prop2020DistTar!$G$123:$G$143,D$32)","v":17963.076247260971},{"$f":"INDEX(Prop2020DistTar!$G$123:$G$143,E$32)","v":25903.779779007},{"$f":"INDEX(Prop2020DistTar!$G$123:$G$143,F$32)","v":10513.14298452},{"$f":"INDEX(Prop2020DistTar!$G$123:$G$143,G$32)","v":38414.535239503995},{"$f":"INDEX(Prop2020DistTar!$G$123:$G$143,H$32)","v":51025.628466779999},{"$f":"INDEX(Prop2020DistTar!$G$123:$G$143,I$32)","v":4074.4530504115955},{"$f":"INDEX(Prop2020DistTar!$G$123:$G$143,J$32)","v":5985.907270144},{"$f":"INDEX(Prop2020DistTar!$G$123:$G$143,K$32)","v":2475.8934618499998},{"$f":"INDEX(Prop2020DistTar!$G$123:$G$143,L$32)","v":8889.1490634239999},{"$f":"INDEX(Prop2020DistTar!$G$123:$G$143,M$32)","v":11170.835010374001},{"$f":"INDEX(Prop2020DistTar!$G$123:$G$143,N$32)","v":3942.36230540613},{"$f":"INDEX(Prop2020DistTar!$G$123:$G$143,O$32)","v":5776.5343653120008},{"$f":"INDEX(Prop2020DistTar!$G$123:$G$143,P$32)","v":2325.2782383119998},{"$f":"INDEX(Prop2020DistTar!$G$123:$G$143,Q$32)","v":8493.6531299199996},{"$f":"INDEX(Prop2020DistTar!$G$123:$G$143,R$32)","v":8516.4509777359981},{"$f":"INDEX(Prop2020DistTar!$G$123:$G$143,S$32)","v":20238.903940794902},{"$f":"INDEX(Prop2020DistTar!$G$123:$G$143,T$32)","v":31314.500532024998},{"$f":"INDEX(Prop2020DistTar!$G$123:$G$143,U$32)","v":12324.568151944002},{"$f":"INDEX(Prop2020DistTar!$G$123:$G$143,V$32)","v":36865.637926336007},{"$f":"INDEX(Prop2020DistTar!$G$123:$G$143,W$32)","v":31086.434277264001}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B198","v":"Existing (1 Jan - 31 Dec): Tariff V - South Gippsland Non-Residential"},{"$f":"SUM(C197:W198)","v":342861.47962964914}]
[null,{"$f":"B200","v":"Proposed (1 Jan-31 Dec): Tariff V - South Gippsland Non-Residential"},{"$f":"SUM(C199:W200)","v":349638.30841832567}]
[]
[null,"Average price movement",{"$f":"IF(C204=0,\"\",C204/C203)","v":1.0197655006214075}]
[]
[null,{"$f":"IF(C206=\"\",\"\",IF(C206<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2020DistTar!B145","v":"Tariff D - Multinet"}]
[null,null,1,2]
[null,"Distribution tariff","DemBlk1","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2020DistTar!C145","v":"Existing: Tariff D - Multinet"},{"$f":"INDEX(Prop2020DistTar!$E$146:$E$147,C213)","v":579.19259999999997},{"$f":"INDEX(Prop2020DistTar!$E$146:$E$147,D213)","v":98.544700000000006}]
[null,{"$f":"\"Proposed: \"&B212","v":"Proposed: Tariff D - Multinet"},{"$f":"INDEX(Prop2020DistTar!$D$146:$D$147,C213)","v":595.32470000000001},{"$f":"INDEX(Prop2020DistTar!$D$146:$D$147,D213)","v":101.2894}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2"]
[null,{"$f":"B215","v":"Existing: Tariff D - Multinet"},{"$f":"INDEX(Prop2020DistTar!$F$146:$F$147,C$213)","v":3277.68},{"$f":"INDEX(Prop2020DistTar!$F$146:$F$147,D$213)","v":461.1}]
[null,{"$f":"B216","v":"Proposed: Tariff D - Multinet"},{"$f":"INDEX(Prop2020DistTar!$F$146:$F$147,C$213)","v":3277.68},{"$f":"INDEX(Prop2020DistTar!$F$146:$F$147,D$213)","v":461.1}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2"]
[null,{"$f":"B219","v":"Existing: Tariff D - Multinet"},{"$f":"INDEX(Prop2020DistTar!$H$146:$H$147,C213)","v":1898408.0011679998},{"$f":"INDEX(Prop2020DistTar!$H$146:$H$147,D213)","v":45438.961170000002}]
[null,{"$f":"B220","v":"Proposed: Tariff D - Multinet"},{"$f":"INDEX(Prop2020DistTar!$G$146:$G$147,C213)","v":1951283.8626959999},{"$f":"INDEX(Prop2020DistTar!$G$146:$G$147,D213)","v":46704.54234}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B223","v":"Existing: Tariff D - Multinet"},{"$f":"SUM(C223:D223)","v":1943846.9623379998}]
[null,{"$f":"B224","v":"Proposed: Tariff D - Multinet"},{"$f":"SUM(C224:D224)","v":1997988.4050359998}]
[]
[null,"Average price movement",{"$f":"IF(C228=0,\"\",C228/C227)","v":1.0278527290198196}]
[]
[null,{"$f":"IF(C230=\"\",\"\",IF(C230<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[null,{"$f":"Prop2020DistTar!B149","v":"New Tariff  L- Multinet Non-Residential"},1,2,3,4,5]
[null,null,1,2,3,null,null,null,4,5,null,null,null,6]
[null,"Distribution tariff","Fixed","PkBlk1","PkBlk2","Shd1Blk1","Shd1Blk2","Shd2Blk1","Shd2Blk2","OffPkBlk1","OffPkBlk2",null,"Rolling12","PD"]
[]
[null,{"$f":"\"Existing (1 Jan - 31 Dec): \"&Prop2020DistTar!C149","v":"Existing (1 Jan - 31 Dec): New Tariff  L- Multinet Non-Residential"},{"$f":"INDEX(Prop2020DistTar!$E$151:$E$162,C$33)","v":0},{"$f":"INDEX(Prop2020DistTar!$E$151:$E$162,D$33)","v":0.62039999999999995},{"$f":"INDEX(Prop2020DistTar!$E$151:$E$162,E$33)","v":0.1331},{"$f":"INDEX(Prop2020DistTar!$E$151:$E$162,F$33)","v":0.55010000000000003},{"$f":"INDEX(Prop2020DistTar!$E$151:$E$162,G$33)","v":0.1249},{"$f":"INDEX(Prop2020DistTar!$E$151:$E$162,H$33)","v":0.55010000000000003},{"$f":"INDEX(Prop2020DistTar!$E$151:$E$162,I$33)","v":0.1249},{"$f":"INDEX(Prop2020DistTar!$E$151:$E$162,J$33)","v":0.43619999999999998},{"$f":"INDEX(Prop2020DistTar!$E$151:$E$162,K$33)","v":9.9199999999999997E-2},{"$f":"INDEX(Prop2020DistTar!$E$151:$E$162,L$33)","v":0},{"$f":"INDEX(Prop2020DistTar!$E$151:$E$162,M$33)","v":0.57679999999999998},{"$f":"INDEX(Prop2020DistTar!$E$151:$E$162,N$33)","v":1.7258}]
[]
[null,{"$f":"\"Proposed (1 Jan-31 Dec): \"&B235","v":"Proposed (1 Jan-31 Dec): New Tariff  L- Multinet Non-Residential"},{"$f":"INDEX(Prop2020DistTar!$D$151:$D$162,C$33)","v":0},{"$f":"INDEX(Prop2020DistTar!$D$151:$D$162,D$33)","v":0.63770000000000004},{"$f":"INDEX(Prop2020DistTar!$D$151:$D$162,E$33)","v":0.1368},{"$f":"INDEX(Prop2020DistTar!$D$151:$D$162,F$33)","v":0.56540000000000001},{"$f":"INDEX(Prop2020DistTar!$D$151:$D$162,G$33)","v":0.12839999999999999},{"$f":"INDEX(Prop2020DistTar!$D$151:$D$162,H$33)","v":0.56540000000000001},{"$f":"INDEX(Prop2020DistTar!$D$151:$D$162,I$33)","v":0.12839999999999999},{"$f":"INDEX(Prop2020DistTar!$D$151:$D$162,J$33)","v":0.44829999999999998},{"$f":"INDEX(Prop2020DistTar!$D$151:$D$162,K$33)","v":0.10199999999999999},{"$f":"INDEX(Prop2020DistTar!$D$151:$D$162,L$33)","v":0},{"$f":"INDEX(Prop2020DistTar!$D$151:$D$162,M$33)","v":0.59289999999999998},{"$f":"INDEX(Prop2020DistTar!$D$151:$D$162,N$33)","v":1.7739}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","Shd1Blk1","Shd1Blk2","Shd2Blk1","Shd2Blk2","OffPkBlk1","OffPkBlk2",null,"Rolling12","PD"]
[]
[null,{"$f":"B239","v":"Existing (1 Jan - 31 Dec): New Tariff  L- Multinet Non-Residential"},{"$f":"INDEX(Prop2020DistTar!$F$151:$F$162,C$33)","v":13},{"$f":"INDEX(Prop2020DistTar!$F$151:$F$162,D$33)","v":6384.22},{"$f":"INDEX(Prop2020DistTar!$F$151:$F$162,E$33)","v":29560.399999999998},{"$f":"INDEX(Prop2020DistTar!$F$151:$F$162,F$33)","v":1687.98},{"$f":"INDEX(Prop2020DistTar!$F$151:$F$162,G$33)","v":5645.9599999999991},{"$f":"INDEX(Prop2020DistTar!$F$151:$F$162,H$33)","v":1591.26},{"$f":"INDEX(Prop2020DistTar!$F$151:$F$162,I$33)","v":4686.55},{"$f":"INDEX(Prop2020DistTar!$F$151:$F$162,J$33)","v":8366.9299999999985},{"$f":"INDEX(Prop2020DistTar!$F$151:$F$162,K$33)","v":16302.869999999999},{"$f":"INDEX(Prop2020DistTar!$F$151:$F$162,L$33)","v":0},{"$f":"INDEX(Prop2020DistTar!$F$151:$F$162,M$33)","v":43.2},{"$f":"INDEX(Prop2020DistTar!$F$151:$F$162,N$33)","v":34.799999999999997}]
[]
[null,{"$f":"B241","v":"Proposed (1 Jan-31 Dec): New Tariff  L- Multinet Non-Residential"},{"$f":"INDEX(Prop2020DistTar!$F$151:$F$162,C$33)","v":13},{"$f":"INDEX(Prop2020DistTar!$F$151:$F$162,D$33)","v":6384.22},{"$f":"INDEX(Prop2020DistTar!$F$151:$F$162,E$33)","v":29560.399999999998},{"$f":"INDEX(Prop2020DistTar!$F$151:$F$162,F$33)","v":1687.98},{"$f":"INDEX(Prop2020DistTar!$F$151:$F$162,G$33)","v":5645.9599999999991},{"$f":"INDEX(Prop2020DistTar!$F$151:$F$162,H$33)","v":1591.26},{"$f":"INDEX(Prop2020DistTar!$F$151:$F$162,I$33)","v":4686.55},{"$f":"INDEX(Prop2020DistTar!$F$151:$F$162,J$33)","v":8366.9299999999985},{"$f":"INDEX(Prop2020DistTar!$F$151:$F$162,K$33)","v":16302.869999999999},{"$f":"INDEX(Prop2020DistTar!$F$151:$F$162,L$33)","v":0},{"$f":"INDEX(Prop2020DistTar!$F$151:$F$162,M$33)","v":43.2},{"$f":"INDEX(Prop2020DistTar!$F$151:$F$162,N$33)","v":34.799999999999997}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","Shd1Blk1","Shd1Blk2","Shd2Blk1","Shd2Blk2","OffPkBlk1","OffPkBlk2",null,"Rolling12","PD"]
[]
[null,{"$f":"B245","v":"Existing (1 Jan - 31 Dec): New Tariff  L- Multinet Non-Residential"},{"$f":"INDEX(Prop2020DistTar!$H$151:$H$162,C$33)","v":0},{"$f":"INDEX(Prop2020DistTar!$H$151:$H$162,D$33)","v":3960.7700879999998},{"$f":"INDEX(Prop2020DistTar!$H$151:$H$162,E$33)","v":3934.4892399999994},{"$f":"INDEX(Prop2020DistTar!$H$151:$H$162,F$33)","v":928.55779800000005},{"$f":"INDEX(Prop2020DistTar!$H$151:$H$162,G$33)","v":705.18040399999984},{"$f":"INDEX(Prop2020DistTar!$H$151:$H$162,H$33)","v":875.352126},{"$f":"INDEX(Prop2020DistTar!$H$151:$H$162,I$33)","v":585.35009500000001},{"$f":"INDEX(Prop2020DistTar!$H$151:$H$162,J$33)","v":3649.6548659999989},{"$f":"INDEX(Prop2020DistTar!$H$151:$H$162,K$33)","v":1617.2447039999997},{"$f":"INDEX(Prop2020DistTar!$H$151:$H$162,L$33)","v":0},{"$f":"INDEX(Prop2020DistTar!$H$151:$H$162,M$33)","v":9094.9824000000008},{"$f":"INDEX(Prop2020DistTar!$H$151:$H$162,N$33)","v":7327.0564799999993}]
[]
[null,{"$f":"B247","v":"Proposed (1 Jan-31 Dec): New Tariff  L- Multinet Non-Residential"},{"$f":"INDEX(Prop2020DistTar!$G$151:$G$162,C$33)","v":0},{"$f":"INDEX(Prop2020DistTar!$G$151:$G$162,D$33)","v":4071.2170940000005},{"$f":"INDEX(Prop2020DistTar!$G$151:$G$162,E$33)","v":4043.8627199999996},{"$f":"INDEX(Prop2020DistTar!$G$151:$G$162,F$33)","v":954.38389200000006},{"$f":"INDEX(Prop2020DistTar!$G$151:$G$162,G$33)","v":724.94126399999982},{"$f":"INDEX(Prop2020DistTar!$G$151:$G$162,H$33)","v":899.69840399999998},{"$f":"INDEX(Prop2020DistTar!$G$151:$G$162,I$33)","v":601.75301999999999},{"$f":"INDEX(Prop2020DistTar!$G$151:$G$162,J$33)","v":3750.894718999999},{"$f":"INDEX(Prop2020DistTar!$G$151:$G$162,K$33)","v":1662.8927399999998},{"$f":"INDEX(Prop2020DistTar!$G$151:$G$162,L$33)","v":0},{"$f":"INDEX(Prop2020DistTar!$G$151:$G$162,M$33)","v":9348.8472000000002},{"$f":"INDEX(Prop2020DistTar!$G$151:$G$162,N$33)","v":7531.269839999999}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B251","v":"Existing (1 Jan - 31 Dec): New Tariff  L- Multinet Non-Residential"},{"$f":"SUM(C251:N251)","v":32678.638200999998}]
[null,{"$f":"B253","v":"Proposed (1 Jan-31 Dec): New Tariff  L- Multinet Non-Residential"},{"$f":"SUM(C253:N253)","v":33589.760892999999}]
[]
[null,"Average price movement",{"$f":"IF(C257=0,\"\",C257/C256)","v":1.0278812931675996}]
[]
[null,{"$f":"IF(C259=\"\",\"\",IF(C259<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2020DistTar!B163","v":"Tariff D - Multinet South Gippsland"}]
[null,null,1,2]
[null,"Distribution tariff","DemBlk1","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2020DistTar!C163","v":"Existing: Tariff D - Multinet South Gippsland"},{"$f":"INDEX(Prop2020DistTar!$E$164:$E$165,C266)","v":625.76639999999998},{"$f":"INDEX(Prop2020DistTar!$E$164:$E$165,D266)","v":106.4624}]
[null,{"$f":"\"Proposed: \"&B265","v":"Proposed: Tariff D - Multinet South Gippsland"},{"$f":"INDEX(Prop2020DistTar!$D$164:$D$165,C266)","v":643.19569999999999},{"$f":"INDEX(Prop2020DistTar!$D$164:$D$165,D266)","v":109.4277}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2"]
[null,{"$f":"B268","v":"Existing: Tariff D - Multinet South Gippsland"},{"$f":"INDEX(Prop2020DistTar!$F$164:$F$165,C$266)","v":100},{"$f":"INDEX(Prop2020DistTar!$F$164:$F$165,D$266)","v":134.54000000000002}]
[null,{"$f":"B269","v":"Proposed: Tariff D - Multinet South Gippsland"},{"$f":"INDEX(Prop2020DistTar!$F$164:$F$165,C$266)","v":100},{"$f":"INDEX(Prop2020DistTar!$F$164:$F$165,D$266)","v":134.54000000000002}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2"]
[null,{"$f":"B272","v":"Existing: Tariff D - Multinet South Gippsland"},{"$f":"INDEX(Prop2020DistTar!$H$164:$H$165,C266)","v":62576.639999999999},{"$f":"INDEX(Prop2020DistTar!$H$164:$H$165,D266)","v":14323.451296000003}]
[null,{"$f":"B273","v":"Proposed: Tariff D - Multinet South Gippsland"},{"$f":"INDEX(Prop2020DistTar!$G$164:$G$165,C266)","v":64319.57},{"$f":"INDEX(Prop2020DistTar!$G$164:$G$165,D266)","v":14722.402758000002}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B276","v":"Existing: Tariff D - Multinet South Gippsland"},{"$f":"SUM(C276:D276)","v":76900.091295999999}]
[null,{"$f":"B277","v":"Proposed: Tariff D - Multinet South Gippsland"},{"$f":"SUM(C277:D277)","v":79041.972758000004}]
[]
[null,"Average price movement",{"$f":"IF(C281=0,\"\",C281/C280)","v":1.0278527817835168}]
[]
[null,{"$f":"IF(C283=\"\",\"\",IF(C283<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]

{"sheet":"ARS","index":5,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Tariff Approval - \"&'Model update'!B3","v":"Tariff Approval - MultiNet"}]
[]
["Ancillary Reference Services (Exc GST)"]
[]
[null,{"$f":"'Model update'!$B$8","v":2019},{"$f":"'Model update'!$B$5","v":2020}]
["Meter Investigation – High Account Investigation Between the hours of 8am and 4pm on a Business Day",148.71698283649505,{"$f":"ROUND(B6*(1+'Model update'!$B$30),2)","v":151.09}]
["Meter Disconnection – Use of locks & plugs Between the hours of 8am and 4pm on a Business Day",52.090243902439028,{"$f":"ROUND(B7*(1+'Model update'!$B$30),2)","v":52.92}]
["Meter Removal – Various Between the hours of 8am and 4pm on a Business Day",62.236766034327012,{"$f":"ROUND(B8*(1+'Model update'!$B$30),2)","v":63.23}]
["Reconnect Between the hours of 8am and 4pm on a Business Day",43.924028906955741,{"$f":"ROUND(B9*(1+'Model update'!$B$30),2)","v":44.62}]
["Special Meter Reads Between the hours of 8am and 4pm on a Business Day",6.6758807588075886,{"$f":"ROUND(B10*(1+'Model update'!$B$30),2)","v":6.78}]
["Installation of a second service valve in a pit and disconnect gas supply – paved (without traffic Mgt)",3320.0359530261971,{"$f":"ROUND(B11*(1+'Model update'!$B$30),2)","v":3372.92}]
["Installation of a second service valve in a pit and disconnect gas supply – paved (with traffic Mgt)",4114.1595302619698,{"$f":"ROUND(B12*(1+'Model update'!$B$30),2)","v":4179.6899999999996}]
["Installation of a second service valve in a pit and disconnect gas supply – unpaved (without traffic Mgt)",1575.7936766034329,{"$f":"ROUND(B13*(1+'Model update'!$B$30),2)","v":1600.89}]
["Installation of a second service valve in a pit and disconnect gas supply – unpaved (with traffic Mgt)",2171.3863595302623,{"$f":"ROUND(B14*(1+'Model update'!$B$30),2)","v":2205.9699999999998}]
[]
["Note: Formula is as per AA2018-22, Part B, section 2, p9 : ART = ARTt-1  * (1+CPIt)"]