{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["NOTES","Model update","Prop2021DistTar","2021TarContForm","2021RebalContForm","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":false,"merged":[]}
[]
["The model has actual and test data to illustrate the workings of the model.",null,null,{"$f":"'Model update'!B5","v":2021}]
[]
["Issue","Location","Item","Comment"]
[]
[1,"'Model update'!B21","CPI",{"$f":"\"Updated June \"&D2-1&\" CPI for \"&D2","v":"Updated June 2020 CPI for 2021"},"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'!B36",{"$f":"\"Xt for \"&D2","v":"Xt for 2021"},{"$f":"\"Updated for \"&D2&\" annual update \"","v":"Updated for 2021 annual update "}]
[]
[{"$f":"A8+1","v":3},"'Model update'!B46",{"$f":"\"Pass Through Amount for \"&D2","v":"Pass Through Amount for 2021"},"NIL for 2020"]
[]
[{"$f":"A10+1","v":4},"'Model update'!B58","Real Pre-tax WACC (rptw)",{"$f":"\"Updated for \"&$D$2&\" annual update\"","v":"Updated for 2021 annual update"}]
[]
[{"$f":"A12+1","v":5},{"$f":"\"Prop\"&D2&\"DistTar!E8:E165\"","v":"Prop2021DistTar!E8:E165"},{"$f":"D2-1&\" tariffs\"","v":"2020 tariffs"},{"$f":"\"Updated from \"&D2-1&\" model\"","v":"Updated from 2020 model"}]
[]
[{"$f":"A14+1","v":6},"ARS!B6:B14",{"$f":"D2-1&\" ARS tariffs\"","v":"2020 ARS tariffs"},{"$f":"\"Updated from \"&D2-1&\" model\"","v":"Updated from 2020 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:D165\"","v":"Prop2021DistTar!D8:D165"},{"$f":"\"Proposed \"&D2&\" Tariffs\"","v":"Proposed 2021 Tariffs"}]
[null,{"$f":"\"Prop\"&D2&\"DistTar!F8:F165\"","v":"Prop2021DistTar!F8:F165"},{"$f":"\"Actual \"&D2-2&\" Volumes\"","v":"Actual 2019 Volumes"}]
[]
[null,"ARS!C6:C14",{"$f":"\"Proposed \"&D2&\" Ancillary Reference Services Charges\"","v":"Proposed 2021 Ancillary Reference Services Charges"},"Calculated using formula"]

{"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",2021]
[]
["t",{"$f":"B5","v":2021}]
["t-1",{"$f":"B7-1","v":2020}]
["t-2",2019]
["t-3",2018]
[]
[]
["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",114.4]
["CPI Index June 2021"]
[]
[]
[{"$f":"\"CPI Index June \" &$B$10","v":"CPI Index June 2018"},{"$f":"VLOOKUP(A25,A$17:D$22,2,FALSE)","v":113}]
[{"$f":"\"CPI Index June \" &$B$9","v":"CPI Index June 2019"},{"$f":"VLOOKUP(A26,A$17:D$22,2,FALSE)","v":114.8}]
[{"$f":"\"CPI Index June \" &$B$8","v":"CPI Index June 2020"},{"$f":"VLOOKUP(A27,A$17:D$22,2,FALSE)","v":114.4}]
[]
[{"$f":"\"CPI \" &$B$8","v":"CPI 2020"},{"$f":"B26/B25-1","v":1.5929203539823078E-2}]
[{"$f":"\"CPI \" &$B$5","v":"CPI 2021"},{"$f":"B27/B26-1","v":-3.4843205574912606E-3}]
[]
[]
[{"$f":"\"Xt for \"&B$5","v":"Xt for 2021"}]
[2019,-1.7757344845594263E-2]
[2020,-1.1736521921608076E-2]
[2021,-9.5596923257416158E-3]
[2022,-1.7999999999999999E-2]
[]
[]
[{"$f":"\"Xt for \"&B$5","v":"Xt for 2021"},{"$f":"VLOOKUP(B5,A34:B38,2,FALSE)","v":-9.5596923257416158E-3}]
[]
[]
["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 2021"},{"$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 real WACC for distribution tariffs "]
[]
[]
[" Pretax real WACCD",3.7768857840393411E-2]

{"sheet":"Prop2021DistTar","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":"Prop2021DistTar"}]
[]
[null,{"$f":"\"PROPOSED \"&'Model update'!$B$5&\" DISTRIBUTION TARIFFS\"","v":"PROPOSED 2021 DISTRIBUTION TARIFFS"}]
[]
[null,"Proposed tariff name","Existing name","Prop\n2021 Tariff",{"$f":"\"Exist\n\"&'Model update'!$B$8&\" Tariff\"","v":"Exist\n2020 Tariff"},"Actual 2019 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.183,683819,{"$f":"D8*$F8*365","v":45675690.104999997},{"$f":"E8*$F8*365","v":45675690.104999997}]
[null,"Peak 0 - 0.05","Peak 0 - 0.05",8.8805999999999994,8.7502965387832621,3656357.6590307998,{"$f":"D9*$F9","v":32470649.826788917},31994213.768370878]
[null,"Peak 0.05 - 0.1","Peak 0.05 - 0.1",5.8383000000000003,5.8383000000000003,3045063.9529073001,17777996.87625869,17777996.87625869]
[null,"Peak 0.1 -0.15","Peak 0.1 -0.15",3.0185,3.0185,2645466.0950507997,7985339.4079108387,7985339.4079108387]
[null,"Peak 0.15 - 0.25","Peak 0.15 - 0.25",1.5276000000000001,1.5276000000000001,4271305.6881771004,6524846.569259339,6524846.569259339]
[null,"Peak >0.25","Peak >0.25",1.1329,1.1329,7916490.7287751995,8968592.346629424,8968592.346629424]
[null,"May Shoulder 0 - 0.05","May Shoulder 0 - 0.05",8.4760000000000009,8.3515498907265346,910259.82547619997,7715362.2807362713,7602080.345988512]
[null,"May Shoulder 0.05 - 0.1","May Shoulder 0.05 - 0.1",5.5464000000000002,5.5464000000000002,709598.92964590003,3935719.5033880202,3935719.5033880202]
[null,"May Shoulder 0.1 -0.15","May Shoulder 0.1 -0.15",2.8685999999999998,2.8685999999999998,564811.02874089999,1620216.9170461455,1620216.9170461455]
[null,"May Shoulder 0.15 - 0.25","May Shoulder 0.15 - 0.25",1.4513,1.4513,787777.1574727,1143300.9886401296,1143300.9886401296]
[null,"May Shoulder >0.25","May Shoulder >0.25",1.0912999999999999,1.0912999999999999,1101432.5439166001,1201993.3351761855,1201993.3351761855]
[null,"Oct Shoulder 0 - 0.05","Oct Shoulder 0 - 0.05",8.4760000000000009,8.3515498907265346,898951.67758010002,7619514.4191689286,7507639.7846625196]
[null,"Oct Shoulder 0.05 - 0.1","Oct Shoulder 0.05 - 0.1",5.5464000000000002,5.5464000000000002,656008.13638489996,3638483.5276452093,3638483.5276452093]
[null,"Oct Shoulder 0.1 -0.15","Oct Shoulder 0.1 -0.15",2.8685999999999998,2.8685999999999998,466704.85743720003,1338789.5540443519,1338789.5540443519]
[null,"Oct Shoulder 0.15 - 0.25","Oct Shoulder 0.15 - 0.25",1.4513,1.4513,536718.77040570008,778939.95148979255,778939.95148979255]
[null,"Oct Shoulder >0.25","Oct Shoulder >0.25",1.0912999999999999,1.0912999999999999,547491.79961370002,597477.80091843079,597477.80091843079]
[null,"Off Peak 0 - 0.05","Off Peak 0 - 0.05",7.5838999999999999,7.4725368875245666,4531241.1013417002,34364479.388465323,33859866.276043296]
[null,"Off Peak 0.05 - 0.1","Off Peak 0.05 - 0.1",4.9626999999999999,4.9626999999999999,1955394.8698773,9704038.1207400765,9704038.1207400765]
[null,"Off Peak 0.1 -0.15","Off Peak 0.1 -0.15",2.5666000000000002,2.5666000000000002,938386.89220689994,2408463.7975382297,2408463.7975382297]
[null,"Off Peak 0.15 - 0.25","Off Peak 0.15 - 0.25",1.2985,1.2985,845215.13879130001,1097511.8577205031,1097511.8577205031]
[null,"Off Peak >0.25","Off Peak >0.25",0.97660000000000002,0.97660000000000002,1162552.1081513001,{"$f":"D28*$F28","v":1135348.3888205597},{"$f":"E28*$F28","v":1135348.3888205597}]
[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.30180000000000001,15954,{"$f":"D31*$F31*365","v":1757444.7779999999},{"$f":"E31*$F31*365","v":1757444.7779999999}]
[null,"Peak 0 - 0.25","Peak 0 - 0.25",4.0556000000000001,3.9961125101069404,311065.4927147,{"$f":"D32*$F32","v":1261557.2122537373},1243052.706899792]
[null,"Peak 0.25 - 1","Peak 0.25 - 1",2.3485999999999998,2.3485999999999998,511137.53289869998,1200457.6097658866,1200457.6097658866]
[null,"Peak 1 - 1.5","Peak 1 - 1.5",1.4092,1.4092,201892.02762110002,284506.24532365415,284506.24532365415]
[null,"Peak 1.5 - 5","Peak 1.5 - 5",0.78420000000000001,0.78420000000000001,692403.02085239999,542982.44895245205,542982.44895245205]
[null,"Peak >5","Peak >5",0.26169999999999999,0.26169999999999999,899358.90232170012,235362.2247375889,235362.2247375889]
[null,"May Shoulder 0 - 0.25","May Shoulder 0 - 0.25",3.722,3.6673575297524805,74302.652958199993,276554.4743104204,272494.39380684018]
[null,"May Shoulder 0.25 - 1","May Shoulder 0.25 - 1",2.1139000000000001,2.1139000000000001,115553.00397239999,244267.49509725635,244267.49509725635]
[null,"May Shoulder 1 - 1.5","May Shoulder 1 - 1.5",1.3387,1.3387,44583.311007299999,59683.678445472506,59683.678445472506]
[null,"May Shoulder 1.5 - 5","May Shoulder 1.5 - 5",0.7641,0.7641,145396.4190083,111097.40376424203,111097.40376424203]
[null,"May Shoulder >5","May Shoulder >5",0.23530000000000001,0.23530000000000001,149477.1699492,35171.978089046759,35171.978089046759]
[null,"Oct Shoulder 0 - 0.25","Oct Shoulder 0 - 0.25",3.722,3.6673575297524805,72262.057018499996,{"$f":"D42*$F42","v":268959.37622285698},265010.79892219906]
[null,"Oct Shoulder 0.25 - 1","Oct Shoulder 0.25 - 1",2.1139000000000001,2.1139000000000001,111702.0019336,236126.86188743706,236126.86188743706]
[null,"Oct Shoulder 1 - 1.5","Oct Shoulder 1 - 1.5",1.3387,1.3387,44153.806008,59108.700102909599,59108.700102909599]
[null,"Oct Shoulder 1.5 - 5","Oct Shoulder 1.5 - 5",0.7641,0.7641,145933.33897780001,111507.66431293699,111507.66431293699]
[null,"Oct Shoulder >5","Oct Shoulder >5",0.23530000000000001,0.23530000000000001,157757.08895979999,37120.243032240942,37120.243032240942]
[null,"Off Peak 0 - 0.25","Off Peak 0 - 0.25",3.3755999999999999,3.3260452207808484,355008.28721139999,1198365.9743108018,1180773.6170170717]
[null,"Off Peak 0.25 - 1","Off Peak 0.25 - 1",2.0411000000000001,2.0411000000000001,533680.39119849994,1089295.0464752584,1089295.0464752584]
[null,"Off Peak 1 - 1.5","Off Peak 1 - 1.5",1.2218,1.2218,200341.93614490001,244777.77758183883,244777.77758183883]
[null,"Off Peak 1.5 - 5","Off Peak 1.5 - 5",0.74039999999999995,0.74039999999999995,591353.11092330003,437837.84332761134,437837.84332761134]
[null,"Off Peak >5","Off Peak >5",0.20910000000000001,0.20910000000000001,514465.11198069999,{"$f":"D51*$F51","v":107574.65491516437},{"$f":"E51*$F51","v":107574.65491516437}]
[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.183,5537,{"$f":"D54*$F54*365","v":369843.91499999998},{"$f":"E54*$F54*365","v":369843.91499999998}]
[null,"Peak 0 - 0.05","Peak 0 - 0.05",10.5832,10.427832127329596,29459.105438900002,{"$f":"D55*$F55","v":311771.60468096647},307194.60613815149]
[null,"Peak 0.05 - 0.1","Peak 0.05 - 0.1",7.8394000000000004,7.8394000000000004,24505.515942400001,192108.54167885057,192108.54167885057]
[null,"Peak 0.1 -0.15","Peak 0.1 -0.15",5.6036999999999999,5.6036999999999999,21468.781072500002,120304.60849596826,120304.60849596826]
[null,"Peak 0.15 - 0.25","Peak 0.15 - 0.25",4.4203999999999999,4.4203999999999999,34255.014491699993,151420.86605911065,151420.86605911065]
[null,"Peak >0.25","Peak >0.25",4.1197999999999997,4.1197999999999997,54673.235485600002,225242.79555357486,225242.79555357486]
[null,"May Shoulder 0 - 0.05","May Shoulder 0 - 0.05",10.2293,10.079108935895372,7277.5799994999998,74444.549088885353,73351.521604653884]
[null,"May Shoulder 0.05 - 0.1","May Shoulder 0.05 - 0.1",7.6078000000000001,7.6078000000000001,5670.9759966000001,43143.651186933479,43143.651186933479]
[null,"May Shoulder 0.1 -0.15","May Shoulder 0.1 -0.15",5.4839000000000002,5.4839000000000002,4624.5520018999996,25360.580723219409,25360.580723219409]
[null,"May Shoulder 0.15 - 0.25","May Shoulder 0.15 - 0.25",4.3597000000000001,4.3597000000000001,6965.6160009000005,30367.996079123732,30367.996079123732]
[null,"May Shoulder >0.25","May Shoulder >0.25",4.0742000000000003,4.0742000000000003,10135.0689889,41292.298074576385,41292.298074576385]
[null,"Oct Shoulder 0 - 0.05","Oct Shoulder 0 - 0.05",10.2293,10.079108935895372,7302.7530038000004,74702.051301771353,73605.243057237356]
[null,"Oct Shoulder 0.05 - 0.1","Oct Shoulder 0.05 - 0.1",7.6078000000000001,7.6078000000000001,5511.6559612999999,41931.576222378142,41931.576222378142]
[null,"Oct Shoulder 0.1 -0.15","Oct Shoulder 0.1 -0.15",5.4839000000000002,5.4839000000000002,4069.0109822999998,22314.049325834971,22314.049325834971]
[null,"Oct Shoulder 0.15 - 0.25","Oct Shoulder 0.15 - 0.25",4.3597000000000001,4.3597000000000001,4307.8660088999995,18781.003439001328,18781.003439001328]
[null,"Oct Shoulder >0.25","Oct Shoulder >0.25",4.0742000000000003,4.0742000000000003,3897.9939885999997,15881.20710835412,15881.20710835412]
[null,"Off Peak 0 - 0.05","Off Peak 0 - 0.05",9.5215999999999994,9.381868410873107,32879.853344999996,313068.81160975195,308474.45745159592]
[null,"Off Peak 0.05 - 0.1","Off Peak 0.05 - 0.1",7.1447000000000003,7.1447000000000003,13748.0909032,98225.985076093042,98225.985076093042]
[null,"Off Peak 0.1 -0.15","Off Peak 0.1 -0.15",5.2443,5.2443,6315.2820528999991,33119.233670023466,33119.233670023466]
[null,"Off Peak 0.15 - 0.25","Off Peak 0.15 - 0.25",4.2385000000000002,4.2385000000000002,4640.7630239,19669.874076800152,19669.874076800152]
[null,"Off Peak >0.25","Off Peak >0.25",4.0199999999999996,3.9830999999999999,7380.8600264999995,{"$f":"D74*$F74","v":29671.057306529994},{"$f":"E74*$F74","v":29398.703571552149}]
[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.3004,70,{"$f":"D77*$F77*365","v":7675.2199999999993},{"$f":"E77*$F77*365","v":7675.2199999999993}]
[null,"Peak 0 - 0.25","Peak 0 - 0.25",6.8071999999999999,6.7072603443387768,1606.5840081000001,{"$f":"D78*$F78","v":10936.338659938321},10775.77720737798]
[null,"Peak 0.25 - 1","Peak 0.25 - 1",5.1199000000000003,5.1199000000000003,2260.6579849999998,11574.342817401501,11574.342817401501]
[null,"Peak 1 - 1.5","Peak 1 - 1.5",4.3555000000000001,4.3555000000000001,536.2200024,2335.5062204532001,2335.5062204532001]
[null,"Peak 1.5 - 5","Peak 1.5 - 5",3.8468,3.8468,1928.5949933000002,7418.9192202264403,7418.9192202264403]
[null,"Peak >5","Peak >5",3.4214000000000002,3.4214000000000002,4249.3089932000003,14538.585789334482,14538.585789334482]
[null,"May Shoulder 0 - 0.25","May Shoulder 0 - 0.25",6.5354999999999999,6.4395422153776156,386.72900150000004,2527.46738930325,2490.3577310700834]
[null,"May Shoulder 0.25 - 1","May Shoulder 0.25 - 1",4.9287999999999998,4.9287999999999998,556.3390071,2742.0836981944799,2742.0836981944799]
[null,"May Shoulder 1 - 1.5","May Shoulder 1 - 1.5",4.298,4.298,116.0809995,498.91613585100004,498.91613585100004]
[null,"May Shoulder 1.5 - 5","May Shoulder 1.5 - 5",3.8304,3.8304,472.38699939999998,1809.4311625017599,1809.4311625017599]
[null,"May Shoulder >5","May Shoulder >5",3.4001000000000001,3.4001000000000001,810.08400219999999,2754.3666158802203,2754.3666158802203]
[null,"Oct Shoulder 0 - 0.25","Oct Shoulder 0 - 0.25",6.5354999999999999,6.4395422153776156,380.44100109999999,2486.3721626890501,2449.8658870439717]
[null,"Oct Shoulder 0.25 - 1","Oct Shoulder 0.25 - 1",4.9287999999999998,4.9287999999999998,477.64299779999999,2354.2068075566399,2354.2068075566399]
[null,"Oct Shoulder 1 - 1.5","Oct Shoulder 1 - 1.5",4.298,4.298,99.563001099999994,427.92177872779996,427.92177872779996]
[null,"Oct Shoulder 1.5 - 5","Oct Shoulder 1.5 - 5",3.8304,3.8304,342.24500160000002,1310.9352541286401,1310.9352541286401]
[null,"Oct Shoulder >5","Oct Shoulder >5",3.4001000000000001,3.4001000000000001,645.54999850000002,2194.93454989985,2194.93454989985]
[null,"Off Peak 0 - 0.25","Off Peak 0 - 0.25",6.2533000000000003,6.1615311941072965,1859.1080180000001,11625.5601689594,11454.952046121991]
[null,"Off Peak 0.25 - 1","Off Peak 0.25 - 1",4.8697999999999997,4.8697999999999997,2180.4379764,10618.29685747272,10618.29685747272]
[null,"Off Peak 1 - 1.5","Off Peak 1 - 1.5",4.2027999999999999,4.2027999999999999,399.19000130000001,1677.7157374636399,1677.7157374636399]
[null,"Off Peak 1.5 - 5","Off Peak 1.5 - 5",3.8111999999999999,3.8111999999999999,1794.7270031000003,6840.0635542147211,6840.0635542147211]
[null,"Off Peak >5","Off Peak >5",3.3786999999999998,3.3786999999999998,2615.0449941999996,8835.4525219035386,8835.4525219035386]
[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.183,5708,{"$f":"D100*$F100*365","v":381265.86000000004},{"$f":"E100*$F100*365","v":381265.86000000004}]
[null,"Peak 0 - 0.05","Peak 0 - 0.05",11.517899999999999,11.348840131152924,26360.131065599999,{"$f":"D101*$F101","v":303613.35360047419},299156.91329973214]
[null,"Peak 0.05 - 0.1","Peak 0.05 - 0.1",8.5803999999999991,8.5803999999999991,19423.857085300002,166664.46333470813,166664.46333470813]
[null,"Peak 0.1 -0.15","Peak 0.1 -0.15",6.2061999999999999,6.2061999999999999,15284.093121299999,94856.13872941205,94856.13872941205]
[null,"Peak 0.15 - 0.25","Peak 0.15 - 0.25",4.9497,4.9497,20405.663061799998,101001.91045699145,101001.91045699145]
[null,"Peak >0.25","Peak >0.25",4.6306000000000003,4.6306000000000003,19711.759956000002,91277.275652253607,91277.275652253607]
[null,"May Shoulder 0 - 0.05","May Shoulder 0 - 0.05",11.1419,10.97839893694638,6353.8729430000003,70794.216943611696,69755.351962923567]
[null,"May Shoulder 0.05 - 0.1","May Shoulder 0.05 - 0.1",8.3346,8.3346,4036.7039064999999,33644.312379114897,33644.312379114897]
[null,"May Shoulder 0.1 -0.15","May Shoulder 0.1 -0.15",6.0789999999999997,6.0789999999999997,2520.9449976000001,15324.824640410399,15324.824640410399]
[null,"May Shoulder 0.15 - 0.25","May Shoulder 0.15 - 0.25",4.8853,4.8853,2164.3510323,10573.504098095191,10573.504098095191]
[null,"May Shoulder >0.25","May Shoulder >0.25",4.5819999999999999,4.5819999999999999,1794.9040004000001,8224.2501298328007,8224.2501298328007]
[null,"Oct Shoulder 0 - 0.05","Oct Shoulder 0 - 0.05",11.1419,10.97839893694638,6264.9350357000003,69803.279674265825,68778.956135967019]
[null,"Oct Shoulder 0.05 - 0.1","Oct Shoulder 0.05 - 0.1",8.3346,8.3346,3603.6810163,30035.239798453978,30035.239798453978]
[null,"Oct Shoulder 0.1 -0.15","Oct Shoulder 0.1 -0.15",6.0789999999999997,6.0789999999999997,2054.3500242,12488.393797111799,12488.393797111799]
[null,"Oct Shoulder 0.15 - 0.25","Oct Shoulder 0.15 - 0.25",4.8853,4.8853,1707.7279650999999,8342.7634279030299,8342.7634279030299]
[null,"Oct Shoulder >0.25","Oct Shoulder >0.25",4.5819999999999999,4.5819999999999999,1161.5389984999999,5322.1716911269996,5322.1716911269996]
[null,"Off Peak 0 - 0.05","Off Peak 0 - 0.05",10.390700000000001,10.238134122071841,25322.996692599998,263123.6617337988,259260.23651162043]
[null,"Off Peak 0.05 - 0.1","Off Peak 0.05 - 0.1",7.8428000000000004,7.8428000000000004,8409.7501834000013,65955.988738369531,65955.988738369531]
[null,"Off Peak 0.1 -0.15","Off Peak 0.1 -0.15",5.8247,5.8247,3906.7520571,22755.658706990369,22755.658706990369]
[null,"Off Peak 0.15 - 0.25","Off Peak 0.15 - 0.25",4.7565,4.7565,2847.6270867999997,13544.738238364198,13544.738238364198]
[null,"Off Peak >0.25","Off Peak >0.25",4.4851999999999999,4.4851999999999999,5002.1280256999999,{"$f":"D120*$F120","v":22435.544620869638},{"$f":"E120*$F120","v":22435.544620869638}]
[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.30180000000000001,115,{"$f":"D123*$F123*365","v":12668.055},{"$f":"E123*$F123*365","v":12668.055}]
[null,"Peak 0 - 0.25","Peak 0 - 0.25",7.508,7.3978104893600891,2540.7380096000002,{"$f":"D124*$F124","v":19075.860976076801},18795.898298134754]
[null,"Peak 0.25 - 1","Peak 0.25 - 1",5.6927000000000003,5.6927000000000003,4864.6490023999995,27692.987375962479,27692.987375962479]
[null,"Peak 1 - 1.5","Peak 1 - 1.5",4.8807,4.8807,2304.2040027000003,11246.128475977892,11246.128475977892]
[null,"Peak 1.5 - 5","Peak 1.5 - 5",4.3407999999999998,4.3407999999999998,9135.8849957000002,39657.049589334558,39657.049589334558]
[null,"Peak >5","Peak >5",3.8889999999999998,3.8889999999999998,15699.511997900001,61055.402159833102,61055.402159833102]
[null,"May Shoulder 0 - 0.25","May Shoulder 0 - 0.25",7.2195999999999998,7.1136237327042773,596.35400659999993,4305.4373860493597,4242.2380144430426]
[null,"May Shoulder 0.25 - 1","May Shoulder 0.25 - 1",5.4896000000000003,5.4896000000000003,1094.7889979000001,6009.953682871841,6009.953682871841]
[null,"May Shoulder 1 - 1.5","May Shoulder 1 - 1.5",4.8198999999999996,4.8198999999999996,499.53599839999998,2407.7135586881595,2407.7135586881595]
[null,"May Shoulder 1.5 - 5","May Shoulder 1.5 - 5",4.3231999999999999,4.3231999999999999,2061.3569988999998,8911.658577644479,8911.658577644479]
[null,"May Shoulder >5","May Shoulder >5",3.8662000000000001,3.8662000000000001,2693.6820025999996,10414.313358452118,10414.313358452118]
[null,"Oct Shoulder 0 - 0.25","Oct Shoulder 0 - 0.25",7.2195999999999998,7.1136237327042773,603.77200549999998,4358.9923709077993,4295.0068674672575]
[null,"Oct Shoulder 0.25 - 1","Oct Shoulder 0.25 - 1",5.4896000000000003,5.4896000000000003,1135.7460054999999,6234.7912717928002,6234.7912717928002]
[null,"Oct Shoulder 1 - 1.5","Oct Shoulder 1 - 1.5",4.8198999999999996,4.8198999999999996,503.51900030000002,2426.9112295459699,2426.9112295459699]
[null,"Oct Shoulder 1.5 - 5","Oct Shoulder 1.5 - 5",4.3231999999999999,4.3231999999999999,2113.7210031,9138.0386406019188,9138.0386406019188]
[null,"Oct Shoulder >5","Oct Shoulder >5",3.8662000000000001,3.8662000000000001,2943.5170019000002,11380.225432745781,11380.225432745781]
[null,"Off Peak 0 - 0.25","Off Peak 0 - 0.25",6.9200999999999997,6.8185265102007593,3117.0529882000001,21570.318383642818,21253.708433742195]
[null,"Off Peak 0.25 - 1","Off Peak 0.25 - 1",5.4268999999999998,5.4268999999999998,5918.3710056,32118.40761029064,32118.40761029064]
[null,"Off Peak 1 - 1.5","Off Peak 1 - 1.5",4.7186000000000003,4.7186000000000003,2656.5599945999998,12535.243990519561,12535.243990519561]
[null,"Off Peak 1.5 - 5","Off Peak 1.5 - 5",4.3028000000000004,4.3028000000000004,9239.258018999999,39754.679404153198,39754.679404153198]
[null,"Off Peak >5","Off Peak >5",3.8435999999999999,3.8435999999999999,9447.5089940000016,36312.445569338408,36312.445569338408]
[]
[null,"Tariff D - Multinet","Tariff D - Multinet"]
[null,"0 - 50","0 - 50",598.92169999999999,595.32470000000001,3044.7899999999986,{"$f":"D146*$F146","v":1823590.8029429992},{"$f":"E146*$F146","v":1812638.6933129991}]
[null,"> 50","> 50",101.9014,101.2894,534.32000000000005,{"$f":"D147*$F147","v":54447.956048},{"$f":"E147*$F147","v":54120.952208000002}]
[]
[null,"Tariff  L- Multinet Non-Residential","Tariff  L- Multinet Non-Residential"]
[null,"1 January - 31 December","1 January - 31 December"]
[null,"Fixed Charge","Fixed Charge",0,0,12,{"$f":"D151*$F151*365","v":0},{"$f":"E151*$F151*365","v":0}]
[null,"Peak < 5","Peak < 5",0.64159999999999995,0.63770000000000004,6200.74,{"$f":"D152*$F152","v":3978.3947839999996},3954.211898]
[null,"Peak > 5","Peak > 5",0.1376,0.1368,26827.479999999996,3691.4612479999996,3669.9992639999996]
[null,"May Shoulder < 5","May Shoulder < 5",0.56879999999999997,0.56540000000000001,1550.22,881.76513599999998,876.49438800000007]
[null,"May Shoulder > 5","May Shoulder > 5",0.12920000000000001,0.12839999999999999,5594.4299999999994,722.80035599999997,718.32481199999984]
[null,"Oct Shoulder < 5","Oct Shoulder < 5",0.56879999999999997,0.56540000000000001,1551.27,882.36237599999993,877.08805800000005]
[null,"Oct Shoulder > 5","Oct Shoulder > 5",0.12920000000000001,0.12839999999999999,4598.68,594.1494560000001,590.47051199999999]
[null,"Off Peak < 5","Off Peak < 5",0.45100000000000001,0.44829999999999998,8819.9600000000009,3977.8019600000007,3953.9880680000001]
[null,"Off Peak > 5","Off Peak > 5",0.1026,0.10199999999999999,18454.080000000002,{"$f":"D159*$F159","v":1893.3886080000002},{"$f":"E159*$F159","v":1882.3161600000001}]
[null,"Tariff L - Multinet","Tariff L - Multinet"]
[null,"Rolling 12 month max [$/GJ (MHQ/d)]","Rolling 12 month max [$/GJ (MHQ/d)]",0.59650000000000003,0.59289999999999998,38.18,{"$f":"D161*$F161*365","v":8312.645050000001},{"$f":"E161*$F161*365","v":8262.4765299999999}]
[null,"Peak Demand [$/GJ (MHQ/d)]","Peak Demand [$/GJ (MHQ/d)]",1.7846,1.7739,35.22,{"$f":"D162*$F162*122","v":7668.1406639999996},{"$f":"E162*$F162*122","v":7622.1644759999999}]
[null,"Tariff D - Multinet South Gippsland","Tariff D - Multinet South Gippsland"]
[null,"0 - 50","0 - 50",647.08190000000002,643.19569999999999,100,{"$f":"D164*$F164","v":64708.19},{"$f":"E164*$F164","v":64319.57}]
[null,"> 50","> 50",110.0889,109.4277,67.34,{"$f":"D165*$F165","v":7413.3865260000002},{"$f":"E165*$F165","v":7368.8613180000002}]
[]
[]
[null,"Total Revenue","Total Revenue",null,null,null,{"$f":"SUM(G8:G166)","v":214021448.95674565},{"$f":"SUM(H8:H166)","v":212736084.9228307}]

{"sheet":"2021TarContForm","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":"2021TarContForm"}]
[]
[null,{"$f":"'Model update'!$B$5&\"  TARIFF CONTROL FORMULA\"","v":"2021  TARIFF CONTROL FORMULA"}]
[]
[]
[null,"CPI"]
[]
[null,{"$f":"\"CPI Sept\"&'Model update'!$B$9","v":"CPI Sept2019"},{"$f":"'Model update'!B26","v":114.8}]
[null,{"$f":"\"CPI Sept\"&'Model update'!$B$8","v":"CPI Sept2020"},{"$f":"'Model update'!B27","v":114.4}]
[]
[null,{"$f":"\"CPI \"&'Model update'!$B$5","v":"CPI 2021"},{"$f":"(C9/C8-1)","v":-3.4843205574912606E-3}]
[]
[]
[]
[null,"X factor"]
[]
[null,{"$f":"\"X \"&'Model update'!$B$5","v":"X 2021"},{"$f":"'Model update'!B40","v":-9.5596923257416158E-3}]
[]
[]
[null,"Pass Through Factor (PT)"]
[]
[null,"pass through"]
[null,{"$f":"\"AP (t) \"&'Model update'!$B$7","v":"AP (t) 2021"},{"$f":"'Model update'!B50","v":0}]
[]
[null,"Revenue"]
[null,"∑∑p(t-1)q(t-2)",{"$f":"C41","v":212736084.9228307}]
[]
[null,"PT' (t-1)",0]
[null,{"$f":"\"PT' \"&'Model update'!$B$5","v":"PT' 2021"},{"$f":"IF(C26=\"\",0,(C23)/((1+C11)*(1-C17)*C26))","v":0}]
[]
[null,{"$f":"\"PTt \"&'Model update'!$B$5","v":"PTt 2021"},{"$f":"((1+C29)/(1+C28))-1","v":0}]
[]
[]
[]
[]
[null,{"$f":"'Model update'!$B$5&\"  Distribution price control\"","v":"2021  Distribution price control"}]
[]
[null,"Average price movement allowed",{"$f":"(1+C11)*(1-C17)*(1+C31)","v":1.0060420627357567}]
[]
[null,"Proposed distribution tariff revenue",{"$f":"IF(Prop2021DistTar!G168=0,\"\",Prop2021DistTar!G168)","v":214021448.95674565}]
[null,"Existing distribution tariff revenue",{"$f":"IF(Prop2021DistTar!H168=0,\"\",Prop2021DistTar!H168)","v":212736084.9228307}]
[null,"Average price movement",{"$f":"IF(C40=\"\",\"\",C40/C41)","v":1.0060420592697341}]
[]
[null,{"$f":"IF(C40=\"\",\"\",IF(C38>=C42,\"DISTRIBUTION PRICE CONTROL FORMULA COMPLIANT\",\"DISTRIBUTION PRICE CONTROL FORMULA BREACHED\"))","v":"DISTRIBUTION PRICE CONTROL FORMULA COMPLIANT"}]

{"sheet":"2021RebalContForm","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":"2021RebalContForm"}]
[]
[null,{"$f":"'Model update'!$B$5&\"  REBALANCING CONTROL FORMULA\"","v":"2021  REBALANCING CONTROL FORMULA"}]
[]
[]
[null,"Rebalancing control"]
[]
[null,{"$f":"\"CPI \"&'Model update'!$B$5","v":"CPI 2021"},{"$f":"'2021TarContForm'!C11","v":-3.4843205574912606E-3}]
[null,{"$f":"\"Y  \"&'Model update'!$B$5","v":"Y  2021"},0.02]
[null,{"$f":"\"PTt \"&'Model update'!$B$5","v":"PTt 2021"},{"$f":"'2021TarContForm'!C31","v":0}]
[null,{"$f":"\"Xt \"&'Model update'!$B$5","v":"Xt 2021"},{"$f":"'2021TarContForm'!C17","v":-9.5596923257416158E-3}]
[]
[null,"Rebalancing control",{"$f":"(1+C8)*(1+C9)*(1+C10)*(1-C11)","v":1.0261629039904718}]
[]
[]
[]
[null,"Rebalancing control summary"]
[null,null,"Existing","Proposed","Movement","Assessment"]
[null,{"$f":"B32","v":"Tariff V - Multinet Residential"},{"$f":"C53","v":196496549.22329113},{"$f":"C54","v":197702754.96338537},{"$f":"IF(C19=0,0,D19/C19)","v":1.0061385594040309},{"$f":"IF(E19=0,\"\",IF($C$13<=E19,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B62","v":"Tariff V - Yarra Valley Residential"},{"$f":"C83","v":2241032.7135930322},{"$f":"C84","v":2252666.2557577468},1.005191152317479,{"$f":"IF(E20=0,\"\",IF($C$13<=E20,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B92","v":"Tariff V - South Gippsland Residential"},{"$f":"C113","v":1780664.4963502509},{"$f":"C114","v":1791047.5503921581},1.0058309996426553,"Compliant"]
[null,{"$f":"B122","v":"Tariff V - Multinet Non-Residential"},{"$f":"C143","v":9755654.1704569012},{"$f":"C144","v":9799759.6909088157},1.0045210213155649,"Compliant"]
[null,{"$f":"B152","v":"Tariff V - Yarra Valley Non-Residential"},{"$f":"C173","v":112777.85159282466},{"$f":"C174","v":113182.63710210066},1.0035892287675194,"Compliant"]
[null,{"$f":"B182","v":"Tariff V - South Gippsland Non-Residential"},{"$f":"C203","v":378550.85654154012},{"$f":"C204","v":379274.61404442968},1.0019119161676235,"Compliant"]
[null,{"$f":"B212","v":"Tariff D - Multinet"},{"$f":"C227","v":1866759.6455209991},{"$f":"C228","v":1878038.7589909991},1.0060420812593964,"Compliant"]
[null,{"$f":"B265","v":"Tariff D - Multinet South Gippsland"},{"$f":"C280","v":71688.431318000003},{"$f":"C281","v":72121.576526000004},1.0060420516956023,"Compliant"]
[null,"Tariff L - Multinet",{"$f":"C256","v":32407.534165999998},{"$f":"C257","v":32602.909637999997},1.0060287052695598,"Compliant"]
[null,null,{"$f":"SUM(C19:C27)","v":212736084.92283073},{"$f":"SUM(D19:D27)","v":214021448.95674559},1.0060420592697339]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!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): \"&Prop2021DistTar!C6","v":"Existing (1 Jan-31 Dec): Tariff V - Multinet Residential"},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$28,C$33)","v":0.183},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$28,D$33)","v":8.7502965387832621},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$28,E$33)","v":5.8383000000000003},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$28,F$33)","v":3.0185},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$28,G$33)","v":1.5276000000000001},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$28,H$33)","v":1.1329},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$28,I$33)","v":8.3515498907265346},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$28,J$33)","v":5.5464000000000002},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$28,K$33)","v":2.8685999999999998},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$28,L$33)","v":1.4513},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$28,M$33)","v":1.0912999999999999},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$28,N$33)","v":8.3515498907265346},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$28,O$33)","v":5.5464000000000002},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$28,P$33)","v":2.8685999999999998},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$28,Q$33)","v":1.4513},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$28,R$33)","v":1.0912999999999999},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$28,S$33)","v":7.4725368875245666},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$28,T$33)","v":4.9626999999999999},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$28,U$33)","v":2.5666000000000002},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$28,V$33)","v":1.2985},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$28,W$33)","v":0.97660000000000002}]
[]
[null,{"$f":"\"Proposed (1 Jan-31 Dec): \"&B32","v":"Proposed (1 Jan-31 Dec): Tariff V - Multinet Residential"},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$28,C$32)","v":0.183},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$28,D$32)","v":8.8805999999999994},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$28,E$32)","v":5.8383000000000003},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$28,F$32)","v":3.0185},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$28,G$32)","v":1.5276000000000001},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$28,H$32)","v":1.1329},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$28,I$32)","v":8.4760000000000009},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$28,J$32)","v":5.5464000000000002},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$28,K$32)","v":2.8685999999999998},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$28,L$32)","v":1.4513},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$28,M$32)","v":1.0912999999999999},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$28,N$32)","v":8.4760000000000009},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$28,O$32)","v":5.5464000000000002},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$28,P$32)","v":2.8685999999999998},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$28,Q$32)","v":1.4513},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$28,R$32)","v":1.0912999999999999},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$28,S$32)","v":7.5838999999999999},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$28,T$32)","v":4.9626999999999999},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$28,U$32)","v":2.5666000000000002},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$28,V$32)","v":1.2985},{"$f":"INDEX(Prop2021DistTar!$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(Prop2021DistTar!$F$8:$F$28,C$32)","v":683819},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,D$32)","v":3656357.6590307998},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,E$32)","v":3045063.9529073001},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,F$32)","v":2645466.0950507997},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,G$32)","v":4271305.6881771004},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,H$32)","v":7916490.7287751995},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,I$32)","v":910259.82547619997},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,J$32)","v":709598.92964590003},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,K$32)","v":564811.02874089999},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,L$32)","v":787777.1574727},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,M$32)","v":1101432.5439166001},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,N$32)","v":898951.67758010002},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,O$32)","v":656008.13638489996},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,P$32)","v":466704.85743720003},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,Q$32)","v":536718.77040570008},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,R$32)","v":547491.79961370002},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,S$32)","v":4531241.1013417002},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,T$32)","v":1955394.8698773},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,U$32)","v":938386.89220689994},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,V$32)","v":845215.13879130001},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,W$32)","v":1162552.1081513001}]
[]
[null,{"$f":"B38","v":"Proposed (1 Jan-31 Dec): Tariff V - Multinet Residential"},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,C$32)","v":683819},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,D$32)","v":3656357.6590307998},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,E$32)","v":3045063.9529073001},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,F$32)","v":2645466.0950507997},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,G$32)","v":4271305.6881771004},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,H$32)","v":7916490.7287751995},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,I$32)","v":910259.82547619997},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,J$32)","v":709598.92964590003},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,K$32)","v":564811.02874089999},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,L$32)","v":787777.1574727},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,M$32)","v":1101432.5439166001},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,N$32)","v":898951.67758010002},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,O$32)","v":656008.13638489996},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,P$32)","v":466704.85743720003},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,Q$32)","v":536718.77040570008},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,R$32)","v":547491.79961370002},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,S$32)","v":4531241.1013417002},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,T$32)","v":1955394.8698773},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,U$32)","v":938386.89220689994},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,V$32)","v":845215.13879130001},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$28,W$32)","v":1162552.1081513001}]
[]
[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(Prop2021DistTar!$H$8:$H$28,C$33)","v":45675690.104999997},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$28,D$33)","v":31994213.768370878},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$28,E$33)","v":17777996.87625869},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$28,F$33)","v":7985339.4079108387},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$28,G$33)","v":6524846.569259339},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$28,H$33)","v":8968592.346629424},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$28,I$33)","v":7602080.345988512},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$28,J$33)","v":3935719.5033880202},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$28,K$33)","v":1620216.9170461455},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$28,L$33)","v":1143300.9886401296},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$28,M$33)","v":1201993.3351761855},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$28,N$33)","v":7507639.7846625196},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$28,O$33)","v":3638483.5276452093},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$28,P$33)","v":1338789.5540443519},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$28,Q$33)","v":778939.95148979255},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$28,R$33)","v":597477.80091843079},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$28,S$33)","v":33859866.276043296},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$28,T$33)","v":9704038.1207400765},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$28,U$33)","v":2408463.7975382297},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$28,V$33)","v":1097511.8577205031},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$28,W$33)","v":1135348.3888205597}]
[]
[null,{"$f":"B44","v":"Proposed (1 Jan-31 Dec): Tariff V - Multinet Residential"},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$28,C$32)","v":45675690.104999997},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$28,D$32)","v":32470649.826788917},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$28,E$32)","v":17777996.87625869},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$28,F$32)","v":7985339.4079108387},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$28,G$32)","v":6524846.569259339},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$28,H$32)","v":8968592.346629424},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$28,I$32)","v":7715362.2807362713},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$28,J$32)","v":3935719.5033880202},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$28,K$32)","v":1620216.9170461455},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$28,L$32)","v":1143300.9886401296},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$28,M$32)","v":1201993.3351761855},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$28,N$32)","v":7619514.4191689286},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$28,O$32)","v":3638483.5276452093},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$28,P$32)","v":1338789.5540443519},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$28,Q$32)","v":778939.95148979255},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$28,R$32)","v":597477.80091843079},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$28,S$32)","v":34364479.388465323},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$28,T$32)","v":9704038.1207400765},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$28,U$32)","v":2408463.7975382297},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$28,V$32)","v":1097511.8577205031},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$28,W$32)","v":1135348.3888205597}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B48","v":"Existing (1 Jan-31 Dec): Tariff V - Multinet Residential"},{"$f":"SUM(C48:W48)","v":196496549.22329113}]
[null,{"$f":"B50","v":"Proposed (1 Jan-31 Dec): Tariff V - Multinet Residential"},{"$f":"SUM(C50:W50)","v":197702754.96338537}]
[]
[null,"Average price movement",{"$f":"IF(C54=0,\"\",C54/C53)","v":1.0061385594040309}]
[]
[null,{"$f":"IF(C56=\"\",\"\",IF(C56<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!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): \"&Prop2021DistTar!C52","v":"Existing (1 Jan-31 Dec): Tariff V - Yarra Valley Residential"},{"$f":"INDEX(Prop2021DistTar!$E$54:$E$74,C$33)","v":0.183},{"$f":"INDEX(Prop2021DistTar!$E$54:$E$74,D$33)","v":10.427832127329596},{"$f":"INDEX(Prop2021DistTar!$E$54:$E$74,E$33)","v":7.8394000000000004},{"$f":"INDEX(Prop2021DistTar!$E$54:$E$74,F$33)","v":5.6036999999999999},{"$f":"INDEX(Prop2021DistTar!$E$54:$E$74,G$33)","v":4.4203999999999999},{"$f":"INDEX(Prop2021DistTar!$E$54:$E$74,H$33)","v":4.1197999999999997},{"$f":"INDEX(Prop2021DistTar!$E$54:$E$74,I$33)","v":10.079108935895372},{"$f":"INDEX(Prop2021DistTar!$E$54:$E$74,J$33)","v":7.6078000000000001},{"$f":"INDEX(Prop2021DistTar!$E$54:$E$74,K$33)","v":5.4839000000000002},{"$f":"INDEX(Prop2021DistTar!$E$54:$E$74,L$33)","v":4.3597000000000001},{"$f":"INDEX(Prop2021DistTar!$E$54:$E$74,M$33)","v":4.0742000000000003},{"$f":"INDEX(Prop2021DistTar!$E$54:$E$74,N$33)","v":10.079108935895372},{"$f":"INDEX(Prop2021DistTar!$E$54:$E$74,O$33)","v":7.6078000000000001},{"$f":"INDEX(Prop2021DistTar!$E$54:$E$74,P$33)","v":5.4839000000000002},{"$f":"INDEX(Prop2021DistTar!$E$54:$E$74,Q$33)","v":4.3597000000000001},{"$f":"INDEX(Prop2021DistTar!$E$54:$E$74,R$33)","v":4.0742000000000003},{"$f":"INDEX(Prop2021DistTar!$E$54:$E$74,S$33)","v":9.381868410873107},{"$f":"INDEX(Prop2021DistTar!$E$54:$E$74,T$33)","v":7.1447000000000003},{"$f":"INDEX(Prop2021DistTar!$E$54:$E$74,U$33)","v":5.2443},{"$f":"INDEX(Prop2021DistTar!$E$54:$E$74,V$33)","v":4.2385000000000002},{"$f":"INDEX(Prop2021DistTar!$E$54:$E$74,W$33)","v":3.9830999999999999}]
[]
[null,{"$f":"\"Proposed (1 Jan-31 Dec): \"&B62","v":"Proposed (1 Jan-31 Dec): Tariff V - Yarra Valley Residential"},{"$f":"INDEX(Prop2021DistTar!$D$54:$D$74,C$32)","v":0.183},{"$f":"INDEX(Prop2021DistTar!$D$54:$D$74,D$32)","v":10.5832},{"$f":"INDEX(Prop2021DistTar!$D$54:$D$74,E$32)","v":7.8394000000000004},{"$f":"INDEX(Prop2021DistTar!$D$54:$D$74,F$32)","v":5.6036999999999999},{"$f":"INDEX(Prop2021DistTar!$D$54:$D$74,G$32)","v":4.4203999999999999},{"$f":"INDEX(Prop2021DistTar!$D$54:$D$74,H$32)","v":4.1197999999999997},{"$f":"INDEX(Prop2021DistTar!$D$54:$D$74,I$32)","v":10.2293},{"$f":"INDEX(Prop2021DistTar!$D$54:$D$74,J$32)","v":7.6078000000000001},{"$f":"INDEX(Prop2021DistTar!$D$54:$D$74,K$32)","v":5.4839000000000002},{"$f":"INDEX(Prop2021DistTar!$D$54:$D$74,L$32)","v":4.3597000000000001},{"$f":"INDEX(Prop2021DistTar!$D$54:$D$74,M$32)","v":4.0742000000000003},{"$f":"INDEX(Prop2021DistTar!$D$54:$D$74,N$32)","v":10.2293},{"$f":"INDEX(Prop2021DistTar!$D$54:$D$74,O$32)","v":7.6078000000000001},{"$f":"INDEX(Prop2021DistTar!$D$54:$D$74,P$32)","v":5.4839000000000002},{"$f":"INDEX(Prop2021DistTar!$D$54:$D$74,Q$32)","v":4.3597000000000001},{"$f":"INDEX(Prop2021DistTar!$D$54:$D$74,R$32)","v":4.0742000000000003},{"$f":"INDEX(Prop2021DistTar!$D$54:$D$74,S$32)","v":9.5215999999999994},{"$f":"INDEX(Prop2021DistTar!$D$54:$D$74,T$32)","v":7.1447000000000003},{"$f":"INDEX(Prop2021DistTar!$D$54:$D$74,U$32)","v":5.2443},{"$f":"INDEX(Prop2021DistTar!$D$54:$D$74,V$32)","v":4.2385000000000002},{"$f":"INDEX(Prop2021DistTar!$D$54:$D$74,W$32)","v":4.0199999999999996}]
[]
[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(Prop2021DistTar!$F$54:$F$74,C$32)","v":5537},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,D$32)","v":29459.105438900002},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,E$32)","v":24505.515942400001},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,F$32)","v":21468.781072500002},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,G$32)","v":34255.014491699993},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,H$32)","v":54673.235485600002},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,I$32)","v":7277.5799994999998},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,J$32)","v":5670.9759966000001},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,K$32)","v":4624.5520018999996},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,L$32)","v":6965.6160009000005},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,M$32)","v":10135.0689889},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,N$32)","v":7302.7530038000004},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,O$32)","v":5511.6559612999999},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,P$32)","v":4069.0109822999998},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,Q$32)","v":4307.8660088999995},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,R$32)","v":3897.9939885999997},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,S$32)","v":32879.853344999996},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,T$32)","v":13748.0909032},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,U$32)","v":6315.2820528999991},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,V$32)","v":4640.7630239},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,W$32)","v":7380.8600264999995}]
[]
[null,{"$f":"B68","v":"Proposed (1 Jan-31 Dec): Tariff V - Yarra Valley Residential"},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,C$32)","v":5537},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,D$32)","v":29459.105438900002},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,E$32)","v":24505.515942400001},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,F$32)","v":21468.781072500002},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,G$32)","v":34255.014491699993},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,H$32)","v":54673.235485600002},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,I$32)","v":7277.5799994999998},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,J$32)","v":5670.9759966000001},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,K$32)","v":4624.5520018999996},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,L$32)","v":6965.6160009000005},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,M$32)","v":10135.0689889},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,N$32)","v":7302.7530038000004},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,O$32)","v":5511.6559612999999},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,P$32)","v":4069.0109822999998},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,Q$32)","v":4307.8660088999995},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,R$32)","v":3897.9939885999997},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,S$32)","v":32879.853344999996},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,T$32)","v":13748.0909032},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,U$32)","v":6315.2820528999991},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,V$32)","v":4640.7630239},{"$f":"INDEX(Prop2021DistTar!$F$54:$F$74,W$32)","v":7380.8600264999995}]
[]
[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(Prop2021DistTar!$H$54:$H$74,C$33)","v":369843.91499999998},{"$f":"INDEX(Prop2021DistTar!$H$54:$H$74,D$33)","v":307194.60613815149},{"$f":"INDEX(Prop2021DistTar!$H$54:$H$74,E$33)","v":192108.54167885057},{"$f":"INDEX(Prop2021DistTar!$H$54:$H$74,F$33)","v":120304.60849596826},{"$f":"INDEX(Prop2021DistTar!$H$54:$H$74,G$33)","v":151420.86605911065},{"$f":"INDEX(Prop2021DistTar!$H$54:$H$74,H$33)","v":225242.79555357486},{"$f":"INDEX(Prop2021DistTar!$H$54:$H$74,I$33)","v":73351.521604653884},{"$f":"INDEX(Prop2021DistTar!$H$54:$H$74,J$33)","v":43143.651186933479},{"$f":"INDEX(Prop2021DistTar!$H$54:$H$74,K$33)","v":25360.580723219409},{"$f":"INDEX(Prop2021DistTar!$H$54:$H$74,L$33)","v":30367.996079123732},{"$f":"INDEX(Prop2021DistTar!$H$54:$H$74,M$33)","v":41292.298074576385},{"$f":"INDEX(Prop2021DistTar!$H$54:$H$74,N$33)","v":73605.243057237356},{"$f":"INDEX(Prop2021DistTar!$H$54:$H$74,O$33)","v":41931.576222378142},{"$f":"INDEX(Prop2021DistTar!$H$54:$H$74,P$33)","v":22314.049325834971},{"$f":"INDEX(Prop2021DistTar!$H$54:$H$74,Q$33)","v":18781.003439001328},{"$f":"INDEX(Prop2021DistTar!$H$54:$H$74,R$33)","v":15881.20710835412},{"$f":"INDEX(Prop2021DistTar!$H$54:$H$74,S$33)","v":308474.45745159592},{"$f":"INDEX(Prop2021DistTar!$H$54:$H$74,T$33)","v":98225.985076093042},{"$f":"INDEX(Prop2021DistTar!$H$54:$H$74,U$33)","v":33119.233670023466},{"$f":"INDEX(Prop2021DistTar!$H$54:$H$74,V$33)","v":19669.874076800152},{"$f":"INDEX(Prop2021DistTar!$H$54:$H$74,W$33)","v":29398.703571552149}]
[]
[null,{"$f":"B74","v":"Proposed (1 Jan-31 Dec): Tariff V - Yarra Valley Residential"},{"$f":"INDEX(Prop2021DistTar!$G$54:$G$74,C$32)","v":369843.91499999998},{"$f":"INDEX(Prop2021DistTar!$G$54:$G$74,D$32)","v":311771.60468096647},{"$f":"INDEX(Prop2021DistTar!$G$54:$G$74,E$32)","v":192108.54167885057},{"$f":"INDEX(Prop2021DistTar!$G$54:$G$74,F$32)","v":120304.60849596826},{"$f":"INDEX(Prop2021DistTar!$G$54:$G$74,G$32)","v":151420.86605911065},{"$f":"INDEX(Prop2021DistTar!$G$54:$G$74,H$32)","v":225242.79555357486},{"$f":"INDEX(Prop2021DistTar!$G$54:$G$74,I$32)","v":74444.549088885353},{"$f":"INDEX(Prop2021DistTar!$G$54:$G$74,J$32)","v":43143.651186933479},{"$f":"INDEX(Prop2021DistTar!$G$54:$G$74,K$32)","v":25360.580723219409},{"$f":"INDEX(Prop2021DistTar!$G$54:$G$74,L$32)","v":30367.996079123732},{"$f":"INDEX(Prop2021DistTar!$G$54:$G$74,M$32)","v":41292.298074576385},{"$f":"INDEX(Prop2021DistTar!$G$54:$G$74,N$32)","v":74702.051301771353},{"$f":"INDEX(Prop2021DistTar!$G$54:$G$74,O$32)","v":41931.576222378142},{"$f":"INDEX(Prop2021DistTar!$G$54:$G$74,P$32)","v":22314.049325834971},{"$f":"INDEX(Prop2021DistTar!$G$54:$G$74,Q$32)","v":18781.003439001328},{"$f":"INDEX(Prop2021DistTar!$G$54:$G$74,R$32)","v":15881.20710835412},{"$f":"INDEX(Prop2021DistTar!$G$54:$G$74,S$32)","v":313068.81160975195},{"$f":"INDEX(Prop2021DistTar!$G$54:$G$74,T$32)","v":98225.985076093042},{"$f":"INDEX(Prop2021DistTar!$G$54:$G$74,U$32)","v":33119.233670023466},{"$f":"INDEX(Prop2021DistTar!$G$54:$G$74,V$32)","v":19669.874076800152},{"$f":"INDEX(Prop2021DistTar!$G$54:$G$74,W$32)","v":29671.057306529994}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B78","v":"Existing (1 Jan-31 Dec): Tariff V - Yarra Valley Residential"},{"$f":"SUM(C78:W78)","v":2241032.7135930322}]
[null,{"$f":"B80","v":"Proposed (1 Jan-31 Dec): Tariff V - Yarra Valley Residential"},{"$f":"SUM(C80:W80)","v":2252666.2557577468}]
[]
[null,"Average price movement",{"$f":"IF(C84=0,\"\",C84/C83)","v":1.005191152317479}]
[]
[null,{"$f":"IF(C86=\"\",\"\",IF(C86<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!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): \"&Prop2021DistTar!C98","v":"Existing (1 Jan-31 Dec): Tariff V - South Gippsland Residential"},{"$f":"INDEX(Prop2021DistTar!$E$100:$E$120,C$33)","v":0.183},{"$f":"INDEX(Prop2021DistTar!$E$100:$E$120,D$33)","v":11.348840131152924},{"$f":"INDEX(Prop2021DistTar!$E$100:$E$120,E$33)","v":8.5803999999999991},{"$f":"INDEX(Prop2021DistTar!$E$100:$E$120,F$33)","v":6.2061999999999999},{"$f":"INDEX(Prop2021DistTar!$E$100:$E$120,G$33)","v":4.9497},{"$f":"INDEX(Prop2021DistTar!$E$100:$E$120,H$33)","v":4.6306000000000003},{"$f":"INDEX(Prop2021DistTar!$E$100:$E$120,I$33)","v":10.97839893694638},{"$f":"INDEX(Prop2021DistTar!$E$100:$E$120,J$33)","v":8.3346},{"$f":"INDEX(Prop2021DistTar!$E$100:$E$120,K$33)","v":6.0789999999999997},{"$f":"INDEX(Prop2021DistTar!$E$100:$E$120,L$33)","v":4.8853},{"$f":"INDEX(Prop2021DistTar!$E$100:$E$120,M$33)","v":4.5819999999999999},{"$f":"INDEX(Prop2021DistTar!$E$100:$E$120,N$33)","v":10.97839893694638},{"$f":"INDEX(Prop2021DistTar!$E$100:$E$120,O$33)","v":8.3346},{"$f":"INDEX(Prop2021DistTar!$E$100:$E$120,P$33)","v":6.0789999999999997},{"$f":"INDEX(Prop2021DistTar!$E$100:$E$120,Q$33)","v":4.8853},{"$f":"INDEX(Prop2021DistTar!$E$100:$E$120,R$33)","v":4.5819999999999999},{"$f":"INDEX(Prop2021DistTar!$E$100:$E$120,S$33)","v":10.238134122071841},{"$f":"INDEX(Prop2021DistTar!$E$100:$E$120,T$33)","v":7.8428000000000004},{"$f":"INDEX(Prop2021DistTar!$E$100:$E$120,U$33)","v":5.8247},{"$f":"INDEX(Prop2021DistTar!$E$100:$E$120,V$33)","v":4.7565},{"$f":"INDEX(Prop2021DistTar!$E$100:$E$120,W$33)","v":4.4851999999999999}]
[]
[null,{"$f":"\"Proposed (1 Jan-31 Dec): \"&B92","v":"Proposed (1 Jan-31 Dec): Tariff V - South Gippsland Residential"},{"$f":"INDEX(Prop2021DistTar!$D$100:$D$120,C$32)","v":0.183},{"$f":"INDEX(Prop2021DistTar!$D$100:$D$120,D$32)","v":11.517899999999999},{"$f":"INDEX(Prop2021DistTar!$D$100:$D$120,E$32)","v":8.5803999999999991},{"$f":"INDEX(Prop2021DistTar!$D$100:$D$120,F$32)","v":6.2061999999999999},{"$f":"INDEX(Prop2021DistTar!$D$100:$D$120,G$32)","v":4.9497},{"$f":"INDEX(Prop2021DistTar!$D$100:$D$120,H$32)","v":4.6306000000000003},{"$f":"INDEX(Prop2021DistTar!$D$100:$D$120,I$32)","v":11.1419},{"$f":"INDEX(Prop2021DistTar!$D$100:$D$120,J$32)","v":8.3346},{"$f":"INDEX(Prop2021DistTar!$D$100:$D$120,K$32)","v":6.0789999999999997},{"$f":"INDEX(Prop2021DistTar!$D$100:$D$120,L$32)","v":4.8853},{"$f":"INDEX(Prop2021DistTar!$D$100:$D$120,M$32)","v":4.5819999999999999},{"$f":"INDEX(Prop2021DistTar!$D$100:$D$120,N$32)","v":11.1419},{"$f":"INDEX(Prop2021DistTar!$D$100:$D$120,O$32)","v":8.3346},{"$f":"INDEX(Prop2021DistTar!$D$100:$D$120,P$32)","v":6.0789999999999997},{"$f":"INDEX(Prop2021DistTar!$D$100:$D$120,Q$32)","v":4.8853},{"$f":"INDEX(Prop2021DistTar!$D$100:$D$120,R$32)","v":4.5819999999999999},{"$f":"INDEX(Prop2021DistTar!$D$100:$D$120,S$32)","v":10.390700000000001},{"$f":"INDEX(Prop2021DistTar!$D$100:$D$120,T$32)","v":7.8428000000000004},{"$f":"INDEX(Prop2021DistTar!$D$100:$D$120,U$32)","v":5.8247},{"$f":"INDEX(Prop2021DistTar!$D$100:$D$120,V$32)","v":4.7565},{"$f":"INDEX(Prop2021DistTar!$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(Prop2021DistTar!$F$100:$F$120,C$32)","v":5708},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,D$32)","v":26360.131065599999},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,E$32)","v":19423.857085300002},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,F$32)","v":15284.093121299999},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,G$32)","v":20405.663061799998},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,H$32)","v":19711.759956000002},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,I$32)","v":6353.8729430000003},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,J$32)","v":4036.7039064999999},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,K$32)","v":2520.9449976000001},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,L$32)","v":2164.3510323},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,M$32)","v":1794.9040004000001},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,N$32)","v":6264.9350357000003},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,O$32)","v":3603.6810163},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,P$32)","v":2054.3500242},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,Q$32)","v":1707.7279650999999},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,R$32)","v":1161.5389984999999},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,S$32)","v":25322.996692599998},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,T$32)","v":8409.7501834000013},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,U$32)","v":3906.7520571},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,V$32)","v":2847.6270867999997},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,W$32)","v":5002.1280256999999}]
[]
[null,{"$f":"B98","v":"Proposed (1 Jan-31 Dec): Tariff V - South Gippsland Residential"},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,C$32)","v":5708},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,D$32)","v":26360.131065599999},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,E$32)","v":19423.857085300002},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,F$32)","v":15284.093121299999},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,G$32)","v":20405.663061799998},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,H$32)","v":19711.759956000002},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,I$32)","v":6353.8729430000003},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,J$32)","v":4036.7039064999999},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,K$32)","v":2520.9449976000001},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,L$32)","v":2164.3510323},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,M$32)","v":1794.9040004000001},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,N$32)","v":6264.9350357000003},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,O$32)","v":3603.6810163},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,P$32)","v":2054.3500242},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,Q$32)","v":1707.7279650999999},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,R$32)","v":1161.5389984999999},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,S$32)","v":25322.996692599998},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,T$32)","v":8409.7501834000013},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,U$32)","v":3906.7520571},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,V$32)","v":2847.6270867999997},{"$f":"INDEX(Prop2021DistTar!$F$100:$F$120,W$32)","v":5002.1280256999999}]
[]
[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(Prop2021DistTar!$H$100:$H$120,C$33)","v":381265.86000000004},{"$f":"INDEX(Prop2021DistTar!$H$100:$H$120,D$33)","v":299156.91329973214},{"$f":"INDEX(Prop2021DistTar!$H$100:$H$120,E$33)","v":166664.46333470813},{"$f":"INDEX(Prop2021DistTar!$H$100:$H$120,F$33)","v":94856.13872941205},{"$f":"INDEX(Prop2021DistTar!$H$100:$H$120,G$33)","v":101001.91045699145},{"$f":"INDEX(Prop2021DistTar!$H$100:$H$120,H$33)","v":91277.275652253607},{"$f":"INDEX(Prop2021DistTar!$H$100:$H$120,I$33)","v":69755.351962923567},{"$f":"INDEX(Prop2021DistTar!$H$100:$H$120,J$33)","v":33644.312379114897},{"$f":"INDEX(Prop2021DistTar!$H$100:$H$120,K$33)","v":15324.824640410399},{"$f":"INDEX(Prop2021DistTar!$H$100:$H$120,L$33)","v":10573.504098095191},{"$f":"INDEX(Prop2021DistTar!$H$100:$H$120,M$33)","v":8224.2501298328007},{"$f":"INDEX(Prop2021DistTar!$H$100:$H$120,N$33)","v":68778.956135967019},{"$f":"INDEX(Prop2021DistTar!$H$100:$H$120,O$33)","v":30035.239798453978},{"$f":"INDEX(Prop2021DistTar!$H$100:$H$120,P$33)","v":12488.393797111799},{"$f":"INDEX(Prop2021DistTar!$H$100:$H$120,Q$33)","v":8342.7634279030299},{"$f":"INDEX(Prop2021DistTar!$H$100:$H$120,R$33)","v":5322.1716911269996},{"$f":"INDEX(Prop2021DistTar!$H$100:$H$120,S$33)","v":259260.23651162043},{"$f":"INDEX(Prop2021DistTar!$H$100:$H$120,T$33)","v":65955.988738369531},{"$f":"INDEX(Prop2021DistTar!$H$100:$H$120,U$33)","v":22755.658706990369},{"$f":"INDEX(Prop2021DistTar!$H$100:$H$120,V$33)","v":13544.738238364198},{"$f":"INDEX(Prop2021DistTar!$H$100:$H$120,W$33)","v":22435.544620869638}]
[]
[null,{"$f":"B104","v":"Proposed (1 Jan-31 Dec): Tariff V - South Gippsland Residential"},{"$f":"INDEX(Prop2021DistTar!$G$100:$G$120,C$32)","v":381265.86000000004},{"$f":"INDEX(Prop2021DistTar!$G$100:$G$120,D$32)","v":303613.35360047419},{"$f":"INDEX(Prop2021DistTar!$G$100:$G$120,E$32)","v":166664.46333470813},{"$f":"INDEX(Prop2021DistTar!$G$100:$G$120,F$32)","v":94856.13872941205},{"$f":"INDEX(Prop2021DistTar!$G$100:$G$120,G$32)","v":101001.91045699145},{"$f":"INDEX(Prop2021DistTar!$G$100:$G$120,H$32)","v":91277.275652253607},{"$f":"INDEX(Prop2021DistTar!$G$100:$G$120,I$32)","v":70794.216943611696},{"$f":"INDEX(Prop2021DistTar!$G$100:$G$120,J$32)","v":33644.312379114897},{"$f":"INDEX(Prop2021DistTar!$G$100:$G$120,K$32)","v":15324.824640410399},{"$f":"INDEX(Prop2021DistTar!$G$100:$G$120,L$32)","v":10573.504098095191},{"$f":"INDEX(Prop2021DistTar!$G$100:$G$120,M$32)","v":8224.2501298328007},{"$f":"INDEX(Prop2021DistTar!$G$100:$G$120,N$32)","v":69803.279674265825},{"$f":"INDEX(Prop2021DistTar!$G$100:$G$120,O$32)","v":30035.239798453978},{"$f":"INDEX(Prop2021DistTar!$G$100:$G$120,P$32)","v":12488.393797111799},{"$f":"INDEX(Prop2021DistTar!$G$100:$G$120,Q$32)","v":8342.7634279030299},{"$f":"INDEX(Prop2021DistTar!$G$100:$G$120,R$32)","v":5322.1716911269996},{"$f":"INDEX(Prop2021DistTar!$G$100:$G$120,S$32)","v":263123.6617337988},{"$f":"INDEX(Prop2021DistTar!$G$100:$G$120,T$32)","v":65955.988738369531},{"$f":"INDEX(Prop2021DistTar!$G$100:$G$120,U$32)","v":22755.658706990369},{"$f":"INDEX(Prop2021DistTar!$G$100:$G$120,V$32)","v":13544.738238364198},{"$f":"INDEX(Prop2021DistTar!$G$100:$G$120,W$32)","v":22435.544620869638}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B108","v":"Existing (1 Jan-31 Dec): Tariff V - South Gippsland Residential"},{"$f":"SUM(C108:W108)","v":1780664.4963502509}]
[null,{"$f":"B110","v":"Proposed (1 Jan-31 Dec): Tariff V - South Gippsland Residential"},{"$f":"SUM(C110:W110)","v":1791047.5503921581}]
[]
[null,"Average price movement",{"$f":"IF(C114=0,\"\",C114/C113)","v":1.0058309996426553}]
[]
[null,{"$f":"IF(C116=\"\",\"\",IF(C116<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!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): \"&Prop2021DistTar!C29","v":"Existing (1 Jan - 31 Dec): Tariff V - Multinet Non-Residential"},{"$f":"INDEX(Prop2021DistTar!$E$31:$E$51,C$33)","v":0.30180000000000001},{"$f":"INDEX(Prop2021DistTar!$E$31:$E$51,D$33)","v":3.9961125101069404},{"$f":"INDEX(Prop2021DistTar!$E$31:$E$51,E$33)","v":2.3485999999999998},{"$f":"INDEX(Prop2021DistTar!$E$31:$E$51,F$33)","v":1.4092},{"$f":"INDEX(Prop2021DistTar!$E$31:$E$51,G$33)","v":0.78420000000000001},{"$f":"INDEX(Prop2021DistTar!$E$31:$E$51,H$33)","v":0.26169999999999999},{"$f":"INDEX(Prop2021DistTar!$E$31:$E$51,I$33)","v":3.6673575297524805},{"$f":"INDEX(Prop2021DistTar!$E$31:$E$51,J$33)","v":2.1139000000000001},{"$f":"INDEX(Prop2021DistTar!$E$31:$E$51,K$33)","v":1.3387},{"$f":"INDEX(Prop2021DistTar!$E$31:$E$51,L$33)","v":0.7641},{"$f":"INDEX(Prop2021DistTar!$E$31:$E$51,M$33)","v":0.23530000000000001},{"$f":"INDEX(Prop2021DistTar!$E$31:$E$51,N$33)","v":3.6673575297524805},{"$f":"INDEX(Prop2021DistTar!$E$31:$E$51,O$33)","v":2.1139000000000001},{"$f":"INDEX(Prop2021DistTar!$E$31:$E$51,P$33)","v":1.3387},{"$f":"INDEX(Prop2021DistTar!$E$31:$E$51,Q$33)","v":0.7641},{"$f":"INDEX(Prop2021DistTar!$E$31:$E$51,R$33)","v":0.23530000000000001},{"$f":"INDEX(Prop2021DistTar!$E$31:$E$51,S$33)","v":3.3260452207808484},{"$f":"INDEX(Prop2021DistTar!$E$31:$E$51,T$33)","v":2.0411000000000001},{"$f":"INDEX(Prop2021DistTar!$E$31:$E$51,U$33)","v":1.2218},{"$f":"INDEX(Prop2021DistTar!$E$31:$E$51,V$33)","v":0.74039999999999995},{"$f":"INDEX(Prop2021DistTar!$E$31:$E$51,W$33)","v":0.20910000000000001}]
[]
[null,{"$f":"\"Proposed (1 Jan-31 Dec): \"&B122","v":"Proposed (1 Jan-31 Dec): Tariff V - Multinet Non-Residential"},{"$f":"INDEX(Prop2021DistTar!$D$31:$D$51,C$32)","v":0.30180000000000001},{"$f":"INDEX(Prop2021DistTar!$D$31:$D$51,D$32)","v":4.0556000000000001},{"$f":"INDEX(Prop2021DistTar!$D$31:$D$51,E$32)","v":2.3485999999999998},{"$f":"INDEX(Prop2021DistTar!$D$31:$D$51,F$32)","v":1.4092},{"$f":"INDEX(Prop2021DistTar!$D$31:$D$51,G$32)","v":0.78420000000000001},{"$f":"INDEX(Prop2021DistTar!$D$31:$D$51,H$32)","v":0.26169999999999999},{"$f":"INDEX(Prop2021DistTar!$D$31:$D$51,I$32)","v":3.722},{"$f":"INDEX(Prop2021DistTar!$D$31:$D$51,J$32)","v":2.1139000000000001},{"$f":"INDEX(Prop2021DistTar!$D$31:$D$51,K$32)","v":1.3387},{"$f":"INDEX(Prop2021DistTar!$D$31:$D$51,L$32)","v":0.7641},{"$f":"INDEX(Prop2021DistTar!$D$31:$D$51,M$32)","v":0.23530000000000001},{"$f":"INDEX(Prop2021DistTar!$D$31:$D$51,N$32)","v":3.722},{"$f":"INDEX(Prop2021DistTar!$D$31:$D$51,O$32)","v":2.1139000000000001},{"$f":"INDEX(Prop2021DistTar!$D$31:$D$51,P$32)","v":1.3387},{"$f":"INDEX(Prop2021DistTar!$D$31:$D$51,Q$32)","v":0.7641},{"$f":"INDEX(Prop2021DistTar!$D$31:$D$51,R$32)","v":0.23530000000000001},{"$f":"INDEX(Prop2021DistTar!$D$31:$D$51,S$32)","v":3.3755999999999999},{"$f":"INDEX(Prop2021DistTar!$D$31:$D$51,T$32)","v":2.0411000000000001},{"$f":"INDEX(Prop2021DistTar!$D$31:$D$51,U$32)","v":1.2218},{"$f":"INDEX(Prop2021DistTar!$D$31:$D$51,V$32)","v":0.74039999999999995},{"$f":"INDEX(Prop2021DistTar!$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(Prop2021DistTar!$F$31:$F$51,C$32)","v":15954},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,D$32)","v":311065.4927147},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,E$32)","v":511137.53289869998},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,F$32)","v":201892.02762110002},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,G$32)","v":692403.02085239999},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,H$32)","v":899358.90232170012},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,I$32)","v":74302.652958199993},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,J$32)","v":115553.00397239999},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,K$32)","v":44583.311007299999},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,L$32)","v":145396.4190083},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,M$32)","v":149477.1699492},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,N$32)","v":72262.057018499996},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,O$32)","v":111702.0019336},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,P$32)","v":44153.806008},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,Q$32)","v":145933.33897780001},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,R$32)","v":157757.08895979999},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,S$32)","v":355008.28721139999},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,T$32)","v":533680.39119849994},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,U$32)","v":200341.93614490001},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,V$32)","v":591353.11092330003},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,W$32)","v":514465.11198069999}]
[]
[null,{"$f":"B128","v":"Proposed (1 Jan-31 Dec): Tariff V - Multinet Non-Residential"},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,C$32)","v":15954},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,D$32)","v":311065.4927147},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,E$32)","v":511137.53289869998},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,F$32)","v":201892.02762110002},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,G$32)","v":692403.02085239999},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,H$32)","v":899358.90232170012},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,I$32)","v":74302.652958199993},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,J$32)","v":115553.00397239999},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,K$32)","v":44583.311007299999},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,L$32)","v":145396.4190083},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,M$32)","v":149477.1699492},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,N$32)","v":72262.057018499996},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,O$32)","v":111702.0019336},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,P$32)","v":44153.806008},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,Q$32)","v":145933.33897780001},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,R$32)","v":157757.08895979999},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,S$32)","v":355008.28721139999},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,T$32)","v":533680.39119849994},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,U$32)","v":200341.93614490001},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,V$32)","v":591353.11092330003},{"$f":"INDEX(Prop2021DistTar!$F$31:$F$51,W$32)","v":514465.11198069999}]
[]
[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(Prop2021DistTar!$H$31:$H$51,C$33)","v":1757444.7779999999},{"$f":"INDEX(Prop2021DistTar!$H$31:$H$51,D$33)","v":1243052.706899792},{"$f":"INDEX(Prop2021DistTar!$H$31:$H$51,E$33)","v":1200457.6097658866},{"$f":"INDEX(Prop2021DistTar!$H$31:$H$51,F$33)","v":284506.24532365415},{"$f":"INDEX(Prop2021DistTar!$H$31:$H$51,G$33)","v":542982.44895245205},{"$f":"INDEX(Prop2021DistTar!$H$31:$H$51,H$33)","v":235362.2247375889},{"$f":"INDEX(Prop2021DistTar!$H$31:$H$51,I$33)","v":272494.39380684018},{"$f":"INDEX(Prop2021DistTar!$H$31:$H$51,J$33)","v":244267.49509725635},{"$f":"INDEX(Prop2021DistTar!$H$31:$H$51,K$33)","v":59683.678445472506},{"$f":"INDEX(Prop2021DistTar!$H$31:$H$51,L$33)","v":111097.40376424203},{"$f":"INDEX(Prop2021DistTar!$H$31:$H$51,M$33)","v":35171.978089046759},{"$f":"INDEX(Prop2021DistTar!$H$31:$H$51,N$33)","v":265010.79892219906},{"$f":"INDEX(Prop2021DistTar!$H$31:$H$51,O$33)","v":236126.86188743706},{"$f":"INDEX(Prop2021DistTar!$H$31:$H$51,P$33)","v":59108.700102909599},{"$f":"INDEX(Prop2021DistTar!$H$31:$H$51,Q$33)","v":111507.66431293699},{"$f":"INDEX(Prop2021DistTar!$H$31:$H$51,R$33)","v":37120.243032240942},{"$f":"INDEX(Prop2021DistTar!$H$31:$H$51,S$33)","v":1180773.6170170717},{"$f":"INDEX(Prop2021DistTar!$H$31:$H$51,T$33)","v":1089295.0464752584},{"$f":"INDEX(Prop2021DistTar!$H$31:$H$51,U$33)","v":244777.77758183883},{"$f":"INDEX(Prop2021DistTar!$H$31:$H$51,V$33)","v":437837.84332761134},{"$f":"INDEX(Prop2021DistTar!$H$31:$H$51,W$33)","v":107574.65491516437}]
[]
[null,{"$f":"B134","v":"Proposed (1 Jan-31 Dec): Tariff V - Multinet Non-Residential"},{"$f":"INDEX(Prop2021DistTar!$G$31:$G$51,C$32)","v":1757444.7779999999},{"$f":"INDEX(Prop2021DistTar!$G$31:$G$51,D$32)","v":1261557.2122537373},{"$f":"INDEX(Prop2021DistTar!$G$31:$G$51,E$32)","v":1200457.6097658866},{"$f":"INDEX(Prop2021DistTar!$G$31:$G$51,F$32)","v":284506.24532365415},{"$f":"INDEX(Prop2021DistTar!$G$31:$G$51,G$32)","v":542982.44895245205},{"$f":"INDEX(Prop2021DistTar!$G$31:$G$51,H$32)","v":235362.2247375889},{"$f":"INDEX(Prop2021DistTar!$G$31:$G$51,I$32)","v":276554.4743104204},{"$f":"INDEX(Prop2021DistTar!$G$31:$G$51,J$32)","v":244267.49509725635},{"$f":"INDEX(Prop2021DistTar!$G$31:$G$51,K$32)","v":59683.678445472506},{"$f":"INDEX(Prop2021DistTar!$G$31:$G$51,L$32)","v":111097.40376424203},{"$f":"INDEX(Prop2021DistTar!$G$31:$G$51,M$32)","v":35171.978089046759},{"$f":"INDEX(Prop2021DistTar!$G$31:$G$51,N$32)","v":268959.37622285698},{"$f":"INDEX(Prop2021DistTar!$G$31:$G$51,O$32)","v":236126.86188743706},{"$f":"INDEX(Prop2021DistTar!$G$31:$G$51,P$32)","v":59108.700102909599},{"$f":"INDEX(Prop2021DistTar!$G$31:$G$51,Q$32)","v":111507.66431293699},{"$f":"INDEX(Prop2021DistTar!$G$31:$G$51,R$32)","v":37120.243032240942},{"$f":"INDEX(Prop2021DistTar!$G$31:$G$51,S$32)","v":1198365.9743108018},{"$f":"INDEX(Prop2021DistTar!$G$31:$G$51,T$32)","v":1089295.0464752584},{"$f":"INDEX(Prop2021DistTar!$G$31:$G$51,U$32)","v":244777.77758183883},{"$f":"INDEX(Prop2021DistTar!$G$31:$G$51,V$32)","v":437837.84332761134},{"$f":"INDEX(Prop2021DistTar!$G$31:$G$51,W$32)","v":107574.65491516437}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B138","v":"Existing (1 Jan - 31 Dec): Tariff V - Multinet Non-Residential"},{"$f":"SUM(C137:W138)","v":9755654.1704569012}]
[null,{"$f":"B140","v":"Proposed (1 Jan-31 Dec): Tariff V - Multinet Non-Residential"},{"$f":"SUM(C139:W140)","v":9799759.6909088157}]
[]
[null,"Average price movement",{"$f":"IF(C144=0,\"\",C144/C143)","v":1.0045210213155649}]
[]
[null,{"$f":"IF(C146=\"\",\"\",IF(C146<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!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): \"&Prop2021DistTar!C75","v":"Existing (1 Jan - 31 Dec): Tariff V - Yarra Valley Non-Residential"},{"$f":"INDEX(Prop2021DistTar!$E$77:$E$97,C$33)","v":0.3004},{"$f":"INDEX(Prop2021DistTar!$E$77:$E$97,D$33)","v":6.7072603443387768},{"$f":"INDEX(Prop2021DistTar!$E$77:$E$97,E$33)","v":5.1199000000000003},{"$f":"INDEX(Prop2021DistTar!$E$77:$E$97,F$33)","v":4.3555000000000001},{"$f":"INDEX(Prop2021DistTar!$E$77:$E$97,G$33)","v":3.8468},{"$f":"INDEX(Prop2021DistTar!$E$77:$E$97,H$33)","v":3.4214000000000002},{"$f":"INDEX(Prop2021DistTar!$E$77:$E$97,I$33)","v":6.4395422153776156},{"$f":"INDEX(Prop2021DistTar!$E$77:$E$97,J$33)","v":4.9287999999999998},{"$f":"INDEX(Prop2021DistTar!$E$77:$E$97,K$33)","v":4.298},{"$f":"INDEX(Prop2021DistTar!$E$77:$E$97,L$33)","v":3.8304},{"$f":"INDEX(Prop2021DistTar!$E$77:$E$97,M$33)","v":3.4001000000000001},{"$f":"INDEX(Prop2021DistTar!$E$77:$E$97,N$33)","v":6.4395422153776156},{"$f":"INDEX(Prop2021DistTar!$E$77:$E$97,O$33)","v":4.9287999999999998},{"$f":"INDEX(Prop2021DistTar!$E$77:$E$97,P$33)","v":4.298},{"$f":"INDEX(Prop2021DistTar!$E$77:$E$97,Q$33)","v":3.8304},{"$f":"INDEX(Prop2021DistTar!$E$77:$E$97,R$33)","v":3.4001000000000001},{"$f":"INDEX(Prop2021DistTar!$E$77:$E$97,S$33)","v":6.1615311941072965},{"$f":"INDEX(Prop2021DistTar!$E$77:$E$97,T$33)","v":4.8697999999999997},{"$f":"INDEX(Prop2021DistTar!$E$77:$E$97,U$33)","v":4.2027999999999999},{"$f":"INDEX(Prop2021DistTar!$E$77:$E$97,V$33)","v":3.8111999999999999},{"$f":"INDEX(Prop2021DistTar!$E$77:$E$97,W$33)","v":3.3786999999999998}]
[]
[null,{"$f":"\"Proposed (1 Jan-31 Dec): \"&B152","v":"Proposed (1 Jan-31 Dec): Tariff V - Yarra Valley Non-Residential"},{"$f":"INDEX(Prop2021DistTar!$D$77:$D$97,C$32)","v":0.3004},{"$f":"INDEX(Prop2021DistTar!$D$77:$D$97,D$32)","v":6.8071999999999999},{"$f":"INDEX(Prop2021DistTar!$D$77:$D$97,E$32)","v":5.1199000000000003},{"$f":"INDEX(Prop2021DistTar!$D$77:$D$97,F$32)","v":4.3555000000000001},{"$f":"INDEX(Prop2021DistTar!$D$77:$D$97,G$32)","v":3.8468},{"$f":"INDEX(Prop2021DistTar!$D$77:$D$97,H$32)","v":3.4214000000000002},{"$f":"INDEX(Prop2021DistTar!$D$77:$D$97,I$32)","v":6.5354999999999999},{"$f":"INDEX(Prop2021DistTar!$D$77:$D$97,J$32)","v":4.9287999999999998},{"$f":"INDEX(Prop2021DistTar!$D$77:$D$97,K$32)","v":4.298},{"$f":"INDEX(Prop2021DistTar!$D$77:$D$97,L$32)","v":3.8304},{"$f":"INDEX(Prop2021DistTar!$D$77:$D$97,M$32)","v":3.4001000000000001},{"$f":"INDEX(Prop2021DistTar!$D$77:$D$97,N$32)","v":6.5354999999999999},{"$f":"INDEX(Prop2021DistTar!$D$77:$D$97,O$32)","v":4.9287999999999998},{"$f":"INDEX(Prop2021DistTar!$D$77:$D$97,P$32)","v":4.298},{"$f":"INDEX(Prop2021DistTar!$D$77:$D$97,Q$32)","v":3.8304},{"$f":"INDEX(Prop2021DistTar!$D$77:$D$97,R$32)","v":3.4001000000000001},{"$f":"INDEX(Prop2021DistTar!$D$77:$D$97,S$32)","v":6.2533000000000003},{"$f":"INDEX(Prop2021DistTar!$D$77:$D$97,T$32)","v":4.8697999999999997},{"$f":"INDEX(Prop2021DistTar!$D$77:$D$97,U$32)","v":4.2027999999999999},{"$f":"INDEX(Prop2021DistTar!$D$77:$D$97,V$32)","v":3.8111999999999999},{"$f":"INDEX(Prop2021DistTar!$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(Prop2021DistTar!$F$77:$F$97,C$32)","v":70},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,D$32)","v":1606.5840081000001},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,E$32)","v":2260.6579849999998},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,F$32)","v":536.2200024},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,G$32)","v":1928.5949933000002},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,H$32)","v":4249.3089932000003},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,I$32)","v":386.72900150000004},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,J$32)","v":556.3390071},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,K$32)","v":116.0809995},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,L$32)","v":472.38699939999998},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,M$32)","v":810.08400219999999},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,N$32)","v":380.44100109999999},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,O$32)","v":477.64299779999999},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,P$32)","v":99.563001099999994},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,Q$32)","v":342.24500160000002},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,R$32)","v":645.54999850000002},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,S$32)","v":1859.1080180000001},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,T$32)","v":2180.4379764},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,U$32)","v":399.19000130000001},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,V$32)","v":1794.7270031000003},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,W$32)","v":2615.0449941999996}]
[]
[null,{"$f":"B158","v":"Proposed (1 Jan-31 Dec): Tariff V - Yarra Valley Non-Residential"},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,C$32)","v":70},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,D$32)","v":1606.5840081000001},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,E$32)","v":2260.6579849999998},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,F$32)","v":536.2200024},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,G$32)","v":1928.5949933000002},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,H$32)","v":4249.3089932000003},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,I$32)","v":386.72900150000004},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,J$32)","v":556.3390071},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,K$32)","v":116.0809995},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,L$32)","v":472.38699939999998},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,M$32)","v":810.08400219999999},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,N$32)","v":380.44100109999999},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,O$32)","v":477.64299779999999},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,P$32)","v":99.563001099999994},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,Q$32)","v":342.24500160000002},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,R$32)","v":645.54999850000002},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,S$32)","v":1859.1080180000001},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,T$32)","v":2180.4379764},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,U$32)","v":399.19000130000001},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,V$32)","v":1794.7270031000003},{"$f":"INDEX(Prop2021DistTar!$F$77:$F$97,W$32)","v":2615.0449941999996}]
[]
[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(Prop2021DistTar!$H$77:$H$97,C$33)","v":7675.2199999999993},{"$f":"INDEX(Prop2021DistTar!$H$77:$H$97,D$33)","v":10775.77720737798},{"$f":"INDEX(Prop2021DistTar!$H$77:$H$97,E$33)","v":11574.342817401501},{"$f":"INDEX(Prop2021DistTar!$H$77:$H$97,F$33)","v":2335.5062204532001},{"$f":"INDEX(Prop2021DistTar!$H$77:$H$97,G$33)","v":7418.9192202264403},{"$f":"INDEX(Prop2021DistTar!$H$77:$H$97,H$33)","v":14538.585789334482},{"$f":"INDEX(Prop2021DistTar!$H$77:$H$97,I$33)","v":2490.3577310700834},{"$f":"INDEX(Prop2021DistTar!$H$77:$H$97,J$33)","v":2742.0836981944799},{"$f":"INDEX(Prop2021DistTar!$H$77:$H$97,K$33)","v":498.91613585100004},{"$f":"INDEX(Prop2021DistTar!$H$77:$H$97,L$33)","v":1809.4311625017599},{"$f":"INDEX(Prop2021DistTar!$H$77:$H$97,M$33)","v":2754.3666158802203},{"$f":"INDEX(Prop2021DistTar!$H$77:$H$97,N$33)","v":2449.8658870439717},{"$f":"INDEX(Prop2021DistTar!$H$77:$H$97,O$33)","v":2354.2068075566399},{"$f":"INDEX(Prop2021DistTar!$H$77:$H$97,P$33)","v":427.92177872779996},{"$f":"INDEX(Prop2021DistTar!$H$77:$H$97,Q$33)","v":1310.9352541286401},{"$f":"INDEX(Prop2021DistTar!$H$77:$H$97,R$33)","v":2194.93454989985},{"$f":"INDEX(Prop2021DistTar!$H$77:$H$97,S$33)","v":11454.952046121991},{"$f":"INDEX(Prop2021DistTar!$H$77:$H$97,T$33)","v":10618.29685747272},{"$f":"INDEX(Prop2021DistTar!$H$77:$H$97,U$33)","v":1677.7157374636399},{"$f":"INDEX(Prop2021DistTar!$H$77:$H$97,V$33)","v":6840.0635542147211},{"$f":"INDEX(Prop2021DistTar!$H$77:$H$97,W$33)","v":8835.4525219035386}]
[]
[null,{"$f":"B164","v":"Proposed (1 Jan-31 Dec): Tariff V - Yarra Valley Non-Residential"},{"$f":"INDEX(Prop2021DistTar!$G$77:$G$97,C$32)","v":7675.2199999999993},{"$f":"INDEX(Prop2021DistTar!$G$77:$G$97,D$32)","v":10936.338659938321},{"$f":"INDEX(Prop2021DistTar!$G$77:$G$97,E$32)","v":11574.342817401501},{"$f":"INDEX(Prop2021DistTar!$G$77:$G$97,F$32)","v":2335.5062204532001},{"$f":"INDEX(Prop2021DistTar!$G$77:$G$97,G$32)","v":7418.9192202264403},{"$f":"INDEX(Prop2021DistTar!$G$77:$G$97,H$32)","v":14538.585789334482},{"$f":"INDEX(Prop2021DistTar!$G$77:$G$97,I$32)","v":2527.46738930325},{"$f":"INDEX(Prop2021DistTar!$G$77:$G$97,J$32)","v":2742.0836981944799},{"$f":"INDEX(Prop2021DistTar!$G$77:$G$97,K$32)","v":498.91613585100004},{"$f":"INDEX(Prop2021DistTar!$G$77:$G$97,L$32)","v":1809.4311625017599},{"$f":"INDEX(Prop2021DistTar!$G$77:$G$97,M$32)","v":2754.3666158802203},{"$f":"INDEX(Prop2021DistTar!$G$77:$G$97,N$32)","v":2486.3721626890501},{"$f":"INDEX(Prop2021DistTar!$G$77:$G$97,O$32)","v":2354.2068075566399},{"$f":"INDEX(Prop2021DistTar!$G$77:$G$97,P$32)","v":427.92177872779996},{"$f":"INDEX(Prop2021DistTar!$G$77:$G$97,Q$32)","v":1310.9352541286401},{"$f":"INDEX(Prop2021DistTar!$G$77:$G$97,R$32)","v":2194.93454989985},{"$f":"INDEX(Prop2021DistTar!$G$77:$G$97,S$32)","v":11625.5601689594},{"$f":"INDEX(Prop2021DistTar!$G$77:$G$97,T$32)","v":10618.29685747272},{"$f":"INDEX(Prop2021DistTar!$G$77:$G$97,U$32)","v":1677.7157374636399},{"$f":"INDEX(Prop2021DistTar!$G$77:$G$97,V$32)","v":6840.0635542147211},{"$f":"INDEX(Prop2021DistTar!$G$77:$G$97,W$32)","v":8835.4525219035386}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B168","v":"Existing (1 Jan - 31 Dec): Tariff V - Yarra Valley Non-Residential"},{"$f":"SUM(C167:W168)","v":112777.85159282466}]
[null,{"$f":"B170","v":"Proposed (1 Jan-31 Dec): Tariff V - Yarra Valley Non-Residential"},{"$f":"SUM(C169:W170)","v":113182.63710210066}]
[]
[null,"Average price movement",{"$f":"IF(C174=0,\"\",C174/C173)","v":1.0035892287675194}]
[]
[null,{"$f":"IF(C176=\"\",\"\",IF(C176<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!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): \"&Prop2021DistTar!C121","v":"Existing (1 Jan - 31 Dec): Tariff V - South Gippsland Non-Residential"},{"$f":"INDEX(Prop2021DistTar!$E$123:$E$143,C$33)","v":0.30180000000000001},{"$f":"INDEX(Prop2021DistTar!$E$123:$E$143,D$33)","v":7.3978104893600891},{"$f":"INDEX(Prop2021DistTar!$E$123:$E$143,E$33)","v":5.6927000000000003},{"$f":"INDEX(Prop2021DistTar!$E$123:$E$143,F$33)","v":4.8807},{"$f":"INDEX(Prop2021DistTar!$E$123:$E$143,G$33)","v":4.3407999999999998},{"$f":"INDEX(Prop2021DistTar!$E$123:$E$143,H$33)","v":3.8889999999999998},{"$f":"INDEX(Prop2021DistTar!$E$123:$E$143,I$33)","v":7.1136237327042773},{"$f":"INDEX(Prop2021DistTar!$E$123:$E$143,J$33)","v":5.4896000000000003},{"$f":"INDEX(Prop2021DistTar!$E$123:$E$143,K$33)","v":4.8198999999999996},{"$f":"INDEX(Prop2021DistTar!$E$123:$E$143,L$33)","v":4.3231999999999999},{"$f":"INDEX(Prop2021DistTar!$E$123:$E$143,M$33)","v":3.8662000000000001},{"$f":"INDEX(Prop2021DistTar!$E$123:$E$143,N$33)","v":7.1136237327042773},{"$f":"INDEX(Prop2021DistTar!$E$123:$E$143,O$33)","v":5.4896000000000003},{"$f":"INDEX(Prop2021DistTar!$E$123:$E$143,P$33)","v":4.8198999999999996},{"$f":"INDEX(Prop2021DistTar!$E$123:$E$143,Q$33)","v":4.3231999999999999},{"$f":"INDEX(Prop2021DistTar!$E$123:$E$143,R$33)","v":3.8662000000000001},{"$f":"INDEX(Prop2021DistTar!$E$123:$E$143,S$33)","v":6.8185265102007593},{"$f":"INDEX(Prop2021DistTar!$E$123:$E$143,T$33)","v":5.4268999999999998},{"$f":"INDEX(Prop2021DistTar!$E$123:$E$143,U$33)","v":4.7186000000000003},{"$f":"INDEX(Prop2021DistTar!$E$123:$E$143,V$33)","v":4.3028000000000004},{"$f":"INDEX(Prop2021DistTar!$E$123:$E$143,W$33)","v":3.8435999999999999}]
[]
[null,{"$f":"\"Proposed (1 Jan-31 Dec): \"&B182","v":"Proposed (1 Jan-31 Dec): Tariff V - South Gippsland Non-Residential"},{"$f":"INDEX(Prop2021DistTar!$D$123:$D$143,C$32)","v":0.30180000000000001},{"$f":"INDEX(Prop2021DistTar!$D$123:$D$143,D$32)","v":7.508},{"$f":"INDEX(Prop2021DistTar!$D$123:$D$143,E$32)","v":5.6927000000000003},{"$f":"INDEX(Prop2021DistTar!$D$123:$D$143,F$32)","v":4.8807},{"$f":"INDEX(Prop2021DistTar!$D$123:$D$143,G$32)","v":4.3407999999999998},{"$f":"INDEX(Prop2021DistTar!$D$123:$D$143,H$32)","v":3.8889999999999998},{"$f":"INDEX(Prop2021DistTar!$D$123:$D$143,I$32)","v":7.2195999999999998},{"$f":"INDEX(Prop2021DistTar!$D$123:$D$143,J$32)","v":5.4896000000000003},{"$f":"INDEX(Prop2021DistTar!$D$123:$D$143,K$32)","v":4.8198999999999996},{"$f":"INDEX(Prop2021DistTar!$D$123:$D$143,L$32)","v":4.3231999999999999},{"$f":"INDEX(Prop2021DistTar!$D$123:$D$143,M$32)","v":3.8662000000000001},{"$f":"INDEX(Prop2021DistTar!$D$123:$D$143,N$32)","v":7.2195999999999998},{"$f":"INDEX(Prop2021DistTar!$D$123:$D$143,O$32)","v":5.4896000000000003},{"$f":"INDEX(Prop2021DistTar!$D$123:$D$143,P$32)","v":4.8198999999999996},{"$f":"INDEX(Prop2021DistTar!$D$123:$D$143,Q$32)","v":4.3231999999999999},{"$f":"INDEX(Prop2021DistTar!$D$123:$D$143,R$32)","v":3.8662000000000001},{"$f":"INDEX(Prop2021DistTar!$D$123:$D$143,S$32)","v":6.9200999999999997},{"$f":"INDEX(Prop2021DistTar!$D$123:$D$143,T$32)","v":5.4268999999999998},{"$f":"INDEX(Prop2021DistTar!$D$123:$D$143,U$32)","v":4.7186000000000003},{"$f":"INDEX(Prop2021DistTar!$D$123:$D$143,V$32)","v":4.3028000000000004},{"$f":"INDEX(Prop2021DistTar!$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(Prop2021DistTar!$F$123:$F$143,C$32)","v":115},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,D$32)","v":2540.7380096000002},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,E$32)","v":4864.6490023999995},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,F$32)","v":2304.2040027000003},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,G$32)","v":9135.8849957000002},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,H$32)","v":15699.511997900001},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,I$32)","v":596.35400659999993},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,J$32)","v":1094.7889979000001},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,K$32)","v":499.53599839999998},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,L$32)","v":2061.3569988999998},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,M$32)","v":2693.6820025999996},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,N$32)","v":603.77200549999998},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,O$32)","v":1135.7460054999999},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,P$32)","v":503.51900030000002},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,Q$32)","v":2113.7210031},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,R$32)","v":2943.5170019000002},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,S$32)","v":3117.0529882000001},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,T$32)","v":5918.3710056},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,U$32)","v":2656.5599945999998},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,V$32)","v":9239.258018999999},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,W$32)","v":9447.5089940000016}]
[]
[null,{"$f":"B188","v":"Proposed (1 Jan-31 Dec): Tariff V - South Gippsland Non-Residential"},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,C$32)","v":115},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,D$32)","v":2540.7380096000002},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,E$32)","v":4864.6490023999995},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,F$32)","v":2304.2040027000003},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,G$32)","v":9135.8849957000002},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,H$32)","v":15699.511997900001},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,I$32)","v":596.35400659999993},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,J$32)","v":1094.7889979000001},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,K$32)","v":499.53599839999998},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,L$32)","v":2061.3569988999998},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,M$32)","v":2693.6820025999996},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,N$32)","v":603.77200549999998},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,O$32)","v":1135.7460054999999},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,P$32)","v":503.51900030000002},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,Q$32)","v":2113.7210031},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,R$32)","v":2943.5170019000002},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,S$32)","v":3117.0529882000001},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,T$32)","v":5918.3710056},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,U$32)","v":2656.5599945999998},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,V$32)","v":9239.258018999999},{"$f":"INDEX(Prop2021DistTar!$F$123:$F$143,W$32)","v":9447.5089940000016}]
[]
[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(Prop2021DistTar!$H$123:$H$143,C$33)","v":12668.055},{"$f":"INDEX(Prop2021DistTar!$H$123:$H$143,D$33)","v":18795.898298134754},{"$f":"INDEX(Prop2021DistTar!$H$123:$H$143,E$33)","v":27692.987375962479},{"$f":"INDEX(Prop2021DistTar!$H$123:$H$143,F$33)","v":11246.128475977892},{"$f":"INDEX(Prop2021DistTar!$H$123:$H$143,G$33)","v":39657.049589334558},{"$f":"INDEX(Prop2021DistTar!$H$123:$H$143,H$33)","v":61055.402159833102},{"$f":"INDEX(Prop2021DistTar!$H$123:$H$143,I$33)","v":4242.2380144430426},{"$f":"INDEX(Prop2021DistTar!$H$123:$H$143,J$33)","v":6009.953682871841},{"$f":"INDEX(Prop2021DistTar!$H$123:$H$143,K$33)","v":2407.7135586881595},{"$f":"INDEX(Prop2021DistTar!$H$123:$H$143,L$33)","v":8911.658577644479},{"$f":"INDEX(Prop2021DistTar!$H$123:$H$143,M$33)","v":10414.313358452118},{"$f":"INDEX(Prop2021DistTar!$H$123:$H$143,N$33)","v":4295.0068674672575},{"$f":"INDEX(Prop2021DistTar!$H$123:$H$143,O$33)","v":6234.7912717928002},{"$f":"INDEX(Prop2021DistTar!$H$123:$H$143,P$33)","v":2426.9112295459699},{"$f":"INDEX(Prop2021DistTar!$H$123:$H$143,Q$33)","v":9138.0386406019188},{"$f":"INDEX(Prop2021DistTar!$H$123:$H$143,R$33)","v":11380.225432745781},{"$f":"INDEX(Prop2021DistTar!$H$123:$H$143,S$33)","v":21253.708433742195},{"$f":"INDEX(Prop2021DistTar!$H$123:$H$143,T$33)","v":32118.40761029064},{"$f":"INDEX(Prop2021DistTar!$H$123:$H$143,U$33)","v":12535.243990519561},{"$f":"INDEX(Prop2021DistTar!$H$123:$H$143,V$33)","v":39754.679404153198},{"$f":"INDEX(Prop2021DistTar!$H$123:$H$143,W$33)","v":36312.445569338408}]
[]
[null,{"$f":"B194","v":"Proposed (1 Jan-31 Dec): Tariff V - South Gippsland Non-Residential"},{"$f":"INDEX(Prop2021DistTar!$G$123:$G$143,C$32)","v":12668.055},{"$f":"INDEX(Prop2021DistTar!$G$123:$G$143,D$32)","v":19075.860976076801},{"$f":"INDEX(Prop2021DistTar!$G$123:$G$143,E$32)","v":27692.987375962479},{"$f":"INDEX(Prop2021DistTar!$G$123:$G$143,F$32)","v":11246.128475977892},{"$f":"INDEX(Prop2021DistTar!$G$123:$G$143,G$32)","v":39657.049589334558},{"$f":"INDEX(Prop2021DistTar!$G$123:$G$143,H$32)","v":61055.402159833102},{"$f":"INDEX(Prop2021DistTar!$G$123:$G$143,I$32)","v":4305.4373860493597},{"$f":"INDEX(Prop2021DistTar!$G$123:$G$143,J$32)","v":6009.953682871841},{"$f":"INDEX(Prop2021DistTar!$G$123:$G$143,K$32)","v":2407.7135586881595},{"$f":"INDEX(Prop2021DistTar!$G$123:$G$143,L$32)","v":8911.658577644479},{"$f":"INDEX(Prop2021DistTar!$G$123:$G$143,M$32)","v":10414.313358452118},{"$f":"INDEX(Prop2021DistTar!$G$123:$G$143,N$32)","v":4358.9923709077993},{"$f":"INDEX(Prop2021DistTar!$G$123:$G$143,O$32)","v":6234.7912717928002},{"$f":"INDEX(Prop2021DistTar!$G$123:$G$143,P$32)","v":2426.9112295459699},{"$f":"INDEX(Prop2021DistTar!$G$123:$G$143,Q$32)","v":9138.0386406019188},{"$f":"INDEX(Prop2021DistTar!$G$123:$G$143,R$32)","v":11380.225432745781},{"$f":"INDEX(Prop2021DistTar!$G$123:$G$143,S$32)","v":21570.318383642818},{"$f":"INDEX(Prop2021DistTar!$G$123:$G$143,T$32)","v":32118.40761029064},{"$f":"INDEX(Prop2021DistTar!$G$123:$G$143,U$32)","v":12535.243990519561},{"$f":"INDEX(Prop2021DistTar!$G$123:$G$143,V$32)","v":39754.679404153198},{"$f":"INDEX(Prop2021DistTar!$G$123:$G$143,W$32)","v":36312.445569338408}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B198","v":"Existing (1 Jan - 31 Dec): Tariff V - South Gippsland Non-Residential"},{"$f":"SUM(C197:W198)","v":378550.85654154012}]
[null,{"$f":"B200","v":"Proposed (1 Jan-31 Dec): Tariff V - South Gippsland Non-Residential"},{"$f":"SUM(C199:W200)","v":379274.61404442968}]
[]
[null,"Average price movement",{"$f":"IF(C204=0,\"\",C204/C203)","v":1.0019119161676235}]
[]
[null,{"$f":"IF(C206=\"\",\"\",IF(C206<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!B145","v":"Tariff D - Multinet"}]
[null,null,1,2]
[null,"Distribution tariff","DemBlk1","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2021DistTar!C145","v":"Existing: Tariff D - Multinet"},{"$f":"INDEX(Prop2021DistTar!$E$146:$E$147,C213)","v":595.32470000000001},{"$f":"INDEX(Prop2021DistTar!$E$146:$E$147,D213)","v":101.2894}]
[null,{"$f":"\"Proposed: \"&B212","v":"Proposed: Tariff D - Multinet"},{"$f":"INDEX(Prop2021DistTar!$D$146:$D$147,C213)","v":598.92169999999999},{"$f":"INDEX(Prop2021DistTar!$D$146:$D$147,D213)","v":101.9014}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2"]
[null,{"$f":"B215","v":"Existing: Tariff D - Multinet"},{"$f":"INDEX(Prop2021DistTar!$F$146:$F$147,C$213)","v":3044.7899999999986},{"$f":"INDEX(Prop2021DistTar!$F$146:$F$147,D$213)","v":534.32000000000005}]
[null,{"$f":"B216","v":"Proposed: Tariff D - Multinet"},{"$f":"INDEX(Prop2021DistTar!$F$146:$F$147,C$213)","v":3044.7899999999986},{"$f":"INDEX(Prop2021DistTar!$F$146:$F$147,D$213)","v":534.32000000000005}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2"]
[null,{"$f":"B219","v":"Existing: Tariff D - Multinet"},{"$f":"INDEX(Prop2021DistTar!$H$146:$H$147,C213)","v":1812638.6933129991},{"$f":"INDEX(Prop2021DistTar!$H$146:$H$147,D213)","v":54120.952208000002}]
[null,{"$f":"B220","v":"Proposed: Tariff D - Multinet"},{"$f":"INDEX(Prop2021DistTar!$G$146:$G$147,C213)","v":1823590.8029429992},{"$f":"INDEX(Prop2021DistTar!$G$146:$G$147,D213)","v":54447.956048}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B223","v":"Existing: Tariff D - Multinet"},{"$f":"SUM(C223:D223)","v":1866759.6455209991}]
[null,{"$f":"B224","v":"Proposed: Tariff D - Multinet"},{"$f":"SUM(C224:D224)","v":1878038.7589909991}]
[]
[null,"Average price movement",{"$f":"IF(C228=0,\"\",C228/C227)","v":1.0060420812593964}]
[]
[null,{"$f":"IF(C230=\"\",\"\",IF(C230<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[null,{"$f":"Prop2021DistTar!B149","v":"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): \"&Prop2021DistTar!C149","v":"Existing (1 Jan - 31 Dec): Tariff  L- Multinet Non-Residential"},{"$f":"INDEX(Prop2021DistTar!$E$151:$E$162,C$33)","v":0},{"$f":"INDEX(Prop2021DistTar!$E$151:$E$162,D$33)","v":0.63770000000000004},{"$f":"INDEX(Prop2021DistTar!$E$151:$E$162,E$33)","v":0.1368},{"$f":"INDEX(Prop2021DistTar!$E$151:$E$162,F$33)","v":0.56540000000000001},{"$f":"INDEX(Prop2021DistTar!$E$151:$E$162,G$33)","v":0.12839999999999999},{"$f":"INDEX(Prop2021DistTar!$E$151:$E$162,H$33)","v":0.56540000000000001},{"$f":"INDEX(Prop2021DistTar!$E$151:$E$162,I$33)","v":0.12839999999999999},{"$f":"INDEX(Prop2021DistTar!$E$151:$E$162,J$33)","v":0.44829999999999998},{"$f":"INDEX(Prop2021DistTar!$E$151:$E$162,K$33)","v":0.10199999999999999},{"$f":"INDEX(Prop2021DistTar!$E$151:$E$162,L$33)","v":0},{"$f":"INDEX(Prop2021DistTar!$E$151:$E$162,M$33)","v":0.59289999999999998},{"$f":"INDEX(Prop2021DistTar!$E$151:$E$162,N$33)","v":1.7739}]
[]
[null,{"$f":"\"Proposed (1 Jan-31 Dec): \"&B235","v":"Proposed (1 Jan-31 Dec): Tariff  L- Multinet Non-Residential"},{"$f":"INDEX(Prop2021DistTar!$D$151:$D$162,C$33)","v":0},{"$f":"INDEX(Prop2021DistTar!$D$151:$D$162,D$33)","v":0.64159999999999995},{"$f":"INDEX(Prop2021DistTar!$D$151:$D$162,E$33)","v":0.1376},{"$f":"INDEX(Prop2021DistTar!$D$151:$D$162,F$33)","v":0.56879999999999997},{"$f":"INDEX(Prop2021DistTar!$D$151:$D$162,G$33)","v":0.12920000000000001},{"$f":"INDEX(Prop2021DistTar!$D$151:$D$162,H$33)","v":0.56879999999999997},{"$f":"INDEX(Prop2021DistTar!$D$151:$D$162,I$33)","v":0.12920000000000001},{"$f":"INDEX(Prop2021DistTar!$D$151:$D$162,J$33)","v":0.45100000000000001},{"$f":"INDEX(Prop2021DistTar!$D$151:$D$162,K$33)","v":0.1026},{"$f":"INDEX(Prop2021DistTar!$D$151:$D$162,L$33)","v":0},{"$f":"INDEX(Prop2021DistTar!$D$151:$D$162,M$33)","v":0.59650000000000003},{"$f":"INDEX(Prop2021DistTar!$D$151:$D$162,N$33)","v":1.7846}]
[]
[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): Tariff  L- Multinet Non-Residential"},{"$f":"INDEX(Prop2021DistTar!$F$151:$F$162,C$33)","v":12},{"$f":"INDEX(Prop2021DistTar!$F$151:$F$162,D$33)","v":6200.74},{"$f":"INDEX(Prop2021DistTar!$F$151:$F$162,E$33)","v":26827.479999999996},{"$f":"INDEX(Prop2021DistTar!$F$151:$F$162,F$33)","v":1550.22},{"$f":"INDEX(Prop2021DistTar!$F$151:$F$162,G$33)","v":5594.4299999999994},{"$f":"INDEX(Prop2021DistTar!$F$151:$F$162,H$33)","v":1551.27},{"$f":"INDEX(Prop2021DistTar!$F$151:$F$162,I$33)","v":4598.68},{"$f":"INDEX(Prop2021DistTar!$F$151:$F$162,J$33)","v":8819.9600000000009},{"$f":"INDEX(Prop2021DistTar!$F$151:$F$162,K$33)","v":18454.080000000002},{"$f":"INDEX(Prop2021DistTar!$F$151:$F$162,L$33)","v":0},{"$f":"INDEX(Prop2021DistTar!$F$151:$F$162,M$33)","v":38.18},{"$f":"INDEX(Prop2021DistTar!$F$151:$F$162,N$33)","v":35.22}]
[]
[null,{"$f":"B241","v":"Proposed (1 Jan-31 Dec): Tariff  L- Multinet Non-Residential"},{"$f":"INDEX(Prop2021DistTar!$F$151:$F$162,C$33)","v":12},{"$f":"INDEX(Prop2021DistTar!$F$151:$F$162,D$33)","v":6200.74},{"$f":"INDEX(Prop2021DistTar!$F$151:$F$162,E$33)","v":26827.479999999996},{"$f":"INDEX(Prop2021DistTar!$F$151:$F$162,F$33)","v":1550.22},{"$f":"INDEX(Prop2021DistTar!$F$151:$F$162,G$33)","v":5594.4299999999994},{"$f":"INDEX(Prop2021DistTar!$F$151:$F$162,H$33)","v":1551.27},{"$f":"INDEX(Prop2021DistTar!$F$151:$F$162,I$33)","v":4598.68},{"$f":"INDEX(Prop2021DistTar!$F$151:$F$162,J$33)","v":8819.9600000000009},{"$f":"INDEX(Prop2021DistTar!$F$151:$F$162,K$33)","v":18454.080000000002},{"$f":"INDEX(Prop2021DistTar!$F$151:$F$162,L$33)","v":0},{"$f":"INDEX(Prop2021DistTar!$F$151:$F$162,M$33)","v":38.18},{"$f":"INDEX(Prop2021DistTar!$F$151:$F$162,N$33)","v":35.22}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","Shd1Blk1","Shd1Blk2","Shd2Blk1","Shd2Blk2","OffPkBlk1","OffPkBlk2",null,"Rolling12","PD"]
[]
[null,{"$f":"B245","v":"Existing (1 Jan - 31 Dec): Tariff  L- Multinet Non-Residential"},{"$f":"INDEX(Prop2021DistTar!$H$151:$H$162,C$33)","v":0},{"$f":"INDEX(Prop2021DistTar!$H$151:$H$162,D$33)","v":3954.211898},{"$f":"INDEX(Prop2021DistTar!$H$151:$H$162,E$33)","v":3669.9992639999996},{"$f":"INDEX(Prop2021DistTar!$H$151:$H$162,F$33)","v":876.49438800000007},{"$f":"INDEX(Prop2021DistTar!$H$151:$H$162,G$33)","v":718.32481199999984},{"$f":"INDEX(Prop2021DistTar!$H$151:$H$162,H$33)","v":877.08805800000005},{"$f":"INDEX(Prop2021DistTar!$H$151:$H$162,I$33)","v":590.47051199999999},{"$f":"INDEX(Prop2021DistTar!$H$151:$H$162,J$33)","v":3953.9880680000001},{"$f":"INDEX(Prop2021DistTar!$H$151:$H$162,K$33)","v":1882.3161600000001},{"$f":"INDEX(Prop2021DistTar!$H$151:$H$162,L$33)","v":0},{"$f":"INDEX(Prop2021DistTar!$H$151:$H$162,M$33)","v":8262.4765299999999},{"$f":"INDEX(Prop2021DistTar!$H$151:$H$162,N$33)","v":7622.1644759999999}]
[]
[null,{"$f":"B247","v":"Proposed (1 Jan-31 Dec): Tariff  L- Multinet Non-Residential"},{"$f":"INDEX(Prop2021DistTar!$G$151:$G$162,C$33)","v":0},{"$f":"INDEX(Prop2021DistTar!$G$151:$G$162,D$33)","v":3978.3947839999996},{"$f":"INDEX(Prop2021DistTar!$G$151:$G$162,E$33)","v":3691.4612479999996},{"$f":"INDEX(Prop2021DistTar!$G$151:$G$162,F$33)","v":881.76513599999998},{"$f":"INDEX(Prop2021DistTar!$G$151:$G$162,G$33)","v":722.80035599999997},{"$f":"INDEX(Prop2021DistTar!$G$151:$G$162,H$33)","v":882.36237599999993},{"$f":"INDEX(Prop2021DistTar!$G$151:$G$162,I$33)","v":594.1494560000001},{"$f":"INDEX(Prop2021DistTar!$G$151:$G$162,J$33)","v":3977.8019600000007},{"$f":"INDEX(Prop2021DistTar!$G$151:$G$162,K$33)","v":1893.3886080000002},{"$f":"INDEX(Prop2021DistTar!$G$151:$G$162,L$33)","v":0},{"$f":"INDEX(Prop2021DistTar!$G$151:$G$162,M$33)","v":8312.645050000001},{"$f":"INDEX(Prop2021DistTar!$G$151:$G$162,N$33)","v":7668.1406639999996}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B251","v":"Existing (1 Jan - 31 Dec): Tariff  L- Multinet Non-Residential"},{"$f":"SUM(C251:N251)","v":32407.534165999998}]
[null,{"$f":"B253","v":"Proposed (1 Jan-31 Dec): Tariff  L- Multinet Non-Residential"},{"$f":"SUM(C253:N253)","v":32602.909637999997}]
[]
[null,"Average price movement",{"$f":"IF(C257=0,\"\",C257/C256)","v":1.0060287052695598}]
[]
[null,{"$f":"IF(C259=\"\",\"\",IF(C259<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!B163","v":"Tariff D - Multinet South Gippsland"}]
[null,null,1,2]
[null,"Distribution tariff","DemBlk1","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2021DistTar!C163","v":"Existing: Tariff D - Multinet South Gippsland"},{"$f":"INDEX(Prop2021DistTar!$E$164:$E$165,C266)","v":643.19569999999999},{"$f":"INDEX(Prop2021DistTar!$E$164:$E$165,D266)","v":109.4277}]
[null,{"$f":"\"Proposed: \"&B265","v":"Proposed: Tariff D - Multinet South Gippsland"},{"$f":"INDEX(Prop2021DistTar!$D$164:$D$165,C266)","v":647.08190000000002},{"$f":"INDEX(Prop2021DistTar!$D$164:$D$165,D266)","v":110.0889}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2"]
[null,{"$f":"B268","v":"Existing: Tariff D - Multinet South Gippsland"},{"$f":"INDEX(Prop2021DistTar!$F$164:$F$165,C$266)","v":100},{"$f":"INDEX(Prop2021DistTar!$F$164:$F$165,D$266)","v":67.34}]
[null,{"$f":"B269","v":"Proposed: Tariff D - Multinet South Gippsland"},{"$f":"INDEX(Prop2021DistTar!$F$164:$F$165,C$266)","v":100},{"$f":"INDEX(Prop2021DistTar!$F$164:$F$165,D$266)","v":67.34}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2"]
[null,{"$f":"B272","v":"Existing: Tariff D - Multinet South Gippsland"},{"$f":"INDEX(Prop2021DistTar!$H$164:$H$165,C266)","v":64319.57},{"$f":"INDEX(Prop2021DistTar!$H$164:$H$165,D266)","v":7368.8613180000002}]
[null,{"$f":"B273","v":"Proposed: Tariff D - Multinet South Gippsland"},{"$f":"INDEX(Prop2021DistTar!$G$164:$G$165,C266)","v":64708.19},{"$f":"INDEX(Prop2021DistTar!$G$164:$G$165,D266)","v":7413.3865260000002}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B276","v":"Existing: Tariff D - Multinet South Gippsland"},{"$f":"SUM(C276:D276)","v":71688.431318000003}]
[null,{"$f":"B277","v":"Proposed: Tariff D - Multinet South Gippsland"},{"$f":"SUM(C277:D277)","v":72121.576526000004}]
[]
[null,"Average price movement",{"$f":"IF(C281=0,\"\",C281/C280)","v":1.0060420516956023}]
[]
[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":2020},{"$f":"'Model update'!$B$5","v":2021}]
["Meter Investigation – High Account Investigation Between the hours of 8am and 4pm on a Business Day",151.09,{"$f":"ROUND(B6*(1+'Model update'!$B$30),2)","v":150.56}]
["Meter Disconnection – Use of locks & plugs Between the hours of 8am and 4pm on a Business Day",52.92,{"$f":"ROUND(B7*(1+'Model update'!$B$30),2)","v":52.74}]
["Meter Removal – Various Between the hours of 8am and 4pm on a Business Day",63.23,{"$f":"ROUND(B8*(1+'Model update'!$B$30),2)","v":63.01}]
["Reconnect Between the hours of 8am and 4pm on a Business Day",44.62,{"$f":"ROUND(B9*(1+'Model update'!$B$30),2)","v":44.46}]
["Special Meter Reads Between the hours of 8am and 4pm on a Business Day",6.78,{"$f":"ROUND(B10*(1+'Model update'!$B$30),2)","v":6.76}]
["Installation of a second service valve in a pit and disconnect gas supply – paved (without traffic Mgt)",3372.92,{"$f":"ROUND(B11*(1+'Model update'!$B$30),2)","v":3361.17}]
["Installation of a second service valve in a pit and disconnect gas supply – paved (with traffic Mgt)",4179.6899999999996,{"$f":"ROUND(B12*(1+'Model update'!$B$30),2)","v":4165.13}]
["Installation of a second service valve in a pit and disconnect gas supply – unpaved (without traffic Mgt)",1600.89,{"$f":"ROUND(B13*(1+'Model update'!$B$30),2)","v":1595.31}]
["Installation of a second service valve in a pit and disconnect gas supply – unpaved (with traffic Mgt)",2205.9699999999998,{"$f":"ROUND(B14*(1+'Model update'!$B$30),2)","v":2198.2800000000002}]
[]
["Note: Formula is as per AA2018-22, Part B, section 2, p9 : ART = ARTt-1  * (1+CPIt)"]