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

{"sheet":"NOTES","index":0,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[]
["The model has actual and test data to illustrate the workings of the model.",null,null,{"$f":"'Model update'!B5","v":2022}]
[]
["Issue","Location","Item","Comment"]
[]
[1,"'Model update'!B21","CPI",{"$f":"\"Updated June \"&D2-1&\" CPI for \"&D2","v":"Updated June 2021 CPI for 2022"},"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 2022"},{"$f":"\"Updated for \"&D2&\" annual update \"","v":"Updated for 2022 annual update "}]
[]
[{"$f":"A8+1","v":3},"'Model update'!B46",{"$f":"\"Pass Through Amount for \"&D2","v":"Pass Through Amount for 2022"},"NIL for 2022"]
[]
[{"$f":"A10+1","v":4},"'Model update'!B58","Real Pre-tax WACC (rptw)",{"$f":"\"Updated for \"&$D$2&\" annual update\"","v":"Updated for 2022 annual update"}]
[]
[{"$f":"A12+1","v":5},{"$f":"\"Prop\"&D2&\"DistTar!E8:E165\"","v":"Prop2022DistTar!E8:E165"},{"$f":"D2-1&\" tariffs\"","v":"2021 tariffs"},{"$f":"\"Updated from \"&D2-1&\" model\"","v":"Updated from 2021 model"}]
[]
[{"$f":"A14+1","v":6},"ARS!B6:B14",{"$f":"D2-1&\" ARS tariffs\"","v":"2021 ARS tariffs"},{"$f":"\"Updated from \"&D2-1&\" model\"","v":"Updated from 2021 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":"Prop2022DistTar!D8:D165"},{"$f":"\"Proposed \"&D2&\" Tariffs\"","v":"Proposed 2022 Tariffs"}]
[null,{"$f":"\"Prop\"&D2&\"DistTar!F8:F165\"","v":"Prop2022DistTar!F8:F165"},{"$f":"\"Actual \"&D2-2&\" Volumes\"","v":"Actual 2020 Volumes"}]
[]
[null,"ARS!C6:C14",{"$f":"\"Proposed \"&D2&\" Ancillary Reference Services Charges\"","v":"Proposed 2022 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",2022]
[]
["t",{"$f":"B5","v":2022}]
["t-1",{"$f":"B7-1","v":2021}]
["t-2",2020]
["t-3",2019]
[]
[]
["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",118.8]
[]
[]
[{"$f":"\"CPI Index June \" &$B$10","v":"CPI Index June 2019"},{"$f":"VLOOKUP(A25,A$17:D$22,2,FALSE)","v":114.8}]
[{"$f":"\"CPI Index June \" &$B$9","v":"CPI Index June 2020"},{"$f":"VLOOKUP(A26,A$17:D$22,2,FALSE)","v":114.4}]
[{"$f":"\"CPI Index June \" &$B$8","v":"CPI Index June 2021"},{"$f":"VLOOKUP(A27,A$17:D$22,2,FALSE)","v":118.8}]
[]
[{"$f":"\"CPI \" &$B$8","v":"CPI 2021"},{"$f":"B26/B25-1","v":-3.4843205574912606E-3}]
[{"$f":"\"CPI \" &$B$5","v":"CPI 2022"},{"$f":"B27/B26-1","v":3.8461538461538325E-2}]
[]
[]
[{"$f":"\"Xt for \"&B$5","v":"Xt for 2022"}]
[2019,-1.7757344845594263E-2]
[2020,-1.1736521921608076E-2]
[2021,-9.5596923257416158E-3]
[2022,-1.0014953218312436E-2]
[]
[]
[{"$f":"\"Xt for \"&B$5","v":"Xt for 2022"},{"$f":"VLOOKUP(B5,A34:B38,2,FALSE)","v":-1.0014953218312436E-2}]
[]
[]
["Pass Through Amounts :  PT (t)"]
[2019,0]
[2020,0]
[2021,0]
[2022,0]
[]
[]
[{"$f":"\"Pass Through Amount for \"&B$5","v":"Pass Through Amount for 2022"},{"$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.6576957363436913E-2]

{"sheet":"Prop2022DistTar","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":"Prop2022DistTar"}]
[]
[null,{"$f":"\"PROPOSED \"&'Model update'!$B$5&\" DISTRIBUTION TARIFFS\"","v":"PROPOSED 2022 DISTRIBUTION TARIFFS"}]
[]
[null,"Proposed tariff name","Existing name",{"$f":"\"Prop\n\"&'Model update'!B7&\" Tariff\"","v":"Prop\n2022 Tariff"},{"$f":"\"Exist\n\"&'Model update'!$B$8&\" Tariff\"","v":"Exist\n2021 Tariff"},{"$f":"\"Actual \"&'Model update'!B9&\" Volumes\"","v":"Actual 2020 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,689383,{"$f":"D8*$F8*365","v":46047337.484999999},{"$f":"E8*$F8*365","v":46047337.484999999}]
[null,"Peak 0 - 0.05","Peak 0 - 0.05",9.6172000000000004,8.8805999999999994,3668242.6715000002,{"$f":"D9*$F9","v":35278223.420349807},32576195.868522901]
[null,"Peak 0.05 - 0.1","Peak 0.05 - 0.1",6.3226000000000004,5.8383000000000003,3035296.1157999998,19190963.22175708,17720969.31287514]
[null,"Peak 0.1 -0.15","Peak 0.1 -0.15",3.0185,3.0185,2622212.3738000002,7915148.0503153,7915148.0503153]
[null,"Peak 0.15 - 0.25","Peak 0.15 - 0.25",1.5276000000000001,1.5276000000000001,4252284.7959000003,6495790.2542168405,6495790.2542168405]
[null,"Peak >0.25","Peak >0.25",1.1329,1.1329,8080820.3513000002,9154761.37598777,9154761.37598777]
[null,"May Shoulder 0 - 0.05","May Shoulder 0 - 0.05",9.1790000000000003,8.4760000000000009,928731.71010000003,8524828.3670079,7871929.9748076014]
[null,"May Shoulder 0.05 - 0.1","May Shoulder 0.05 - 0.1",6.0064000000000002,5.5464000000000002,758383.4497,4555154.3522780798,4206297.9654160803]
[null,"May Shoulder 0.1 -0.15","May Shoulder 0.1 -0.15",2.8685999999999998,2.8685999999999998,642917.08799999999,1844271.9586367998,1844271.9586367998]
[null,"May Shoulder 0.15 - 0.25","May Shoulder 0.15 - 0.25",1.4513,1.4513,994914.68740000005,1443919.6858236201,1443919.6858236201]
[null,"May Shoulder >0.25","May Shoulder >0.25",1.0912999999999999,1.0912999999999999,1589898.0086000001,1735055.6967851799,1735055.6967851799]
[null,"Oct Shoulder 0 - 0.05","Oct Shoulder 0 - 0.05",9.1790000000000003,8.4760000000000009,892680.26489999995,8193912.1515170997,7566357.9252924006]
[null,"Oct Shoulder 0.05 - 0.1","Oct Shoulder 0.05 - 0.1",6.0064000000000002,5.5464000000000002,626786.33089999994,3764729.4179177596,3476407.70570376]
[null,"Oct Shoulder 0.1 -0.15","Oct Shoulder 0.1 -0.15",2.8685999999999998,2.8685999999999998,425681.24489999999,1221109.21912014,1221109.21912014]
[null,"Oct Shoulder 0.15 - 0.25","Oct Shoulder 0.15 - 0.25",1.4513,1.4513,471225.7807,683889.97552991007,683889.97552991007]
[null,"Oct Shoulder >0.25","Oct Shoulder >0.25",1.0912999999999999,1.0912999999999999,471364.97399999999,514400.59612619993,514400.59612619993]
[null,"Off Peak 0 - 0.05","Off Peak 0 - 0.05",8.2128999999999994,7.5838999999999999,4713253.2405000003,38709477.538902447,35744841.25062795]
[null,"Off Peak 0.05 - 0.1","Off Peak 0.05 - 0.1",5.3742999999999999,4.9626999999999999,2201464.395,11831330.098048499,10925207.3530665]
[null,"Off Peak 0.1 -0.15","Off Peak 0.1 -0.15",2.5666000000000002,2.5666000000000002,1113629.2634999999,2858240.8676991002,2858240.8676991002]
[null,"Off Peak 0.15 - 0.25","Off Peak 0.15 - 0.25",1.2985,1.2985,1108339.0597999999,1439178.2691503,1439178.2691503]
[null,"Off Peak >0.25","Off Peak >0.25",0.97660000000000002,0.97660000000000002,1449295.0033,{"$f":"D28*$F28","v":1415381.50022278},{"$f":"E28*$F28","v":1415381.50022278}]
[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,16019,{"$f":"D31*$F31*365","v":1764604.983},{"$f":"E31*$F31*365","v":1764604.983}]
[null,"Peak 0 - 0.25","Peak 0 - 0.25",4.3920000000000003,4.0556000000000001,278106.35849999997,{"$f":"D32*$F32","v":1221443.126532},1127888.1475326]
[null,"Peak 0.25 - 1","Peak 0.25 - 1",2.5434000000000001,2.3485999999999998,422636.49489999999,1074933.66112866,992604.07192213985]
[null,"Peak 1 - 1.5","Peak 1 - 1.5",1.4092,1.4092,157292.19,221656.154148,221656.154148]
[null,"Peak 1.5 - 5","Peak 1.5 - 5",0.78420000000000001,0.78420000000000001,540414.17200000002,423792.79368240002,423792.79368240002]
[null,"Peak >5","Peak >5",0.26169999999999999,0.26169999999999999,684466.89789999998,179124.98718042998,179124.98718042998]
[null,"May Shoulder 0 - 0.25","May Shoulder 0 - 0.25",4.0307000000000004,3.722,70320.396099999998,283440.42056027002,261732.51428419998]
[null,"May Shoulder 0.25 - 1","May Shoulder 0.25 - 1",2.2892000000000001,2.1139000000000001,104300.19289999999,238764.00158668001,220480.17777131]
[null,"May Shoulder 1 - 1.5","May Shoulder 1 - 1.5",1.3387,1.3387,38641.798999999999,51729.7763213,51729.7763213]
[null,"May Shoulder 1.5 - 5","May Shoulder 1.5 - 5",0.7641,0.7641,131161.90100000001,100220.8085541,100220.8085541]
[null,"May Shoulder >5","May Shoulder >5",0.23530000000000001,0.23530000000000001,153575.196,36136.243618799999,36136.243618799999]
[null,"Oct Shoulder 0 - 0.25","Oct Shoulder 0 - 0.25",4.0307000000000004,3.722,63361.862000000001,{"$f":"D42*$F42","v":255392.65716340003},235832.85036400001]
[null,"Oct Shoulder 0.25 - 1","Oct Shoulder 0.25 - 1",2.2892000000000001,2.1139000000000001,90194.642000000007,206473.57446640002,190662.45372380002]
[null,"Oct Shoulder 1 - 1.5","Oct Shoulder 1 - 1.5",1.3387,1.3387,32912.192000000003,44059.551430400003,44059.551430400003]
[null,"Oct Shoulder 1.5 - 5","Oct Shoulder 1.5 - 5",0.7641,0.7641,105941.144,80949.6281304,80949.6281304]
[null,"Oct Shoulder >5","Oct Shoulder >5",0.23530000000000001,0.23530000000000001,103108.61,24261.455933000001,24261.455933000001]
[null,"Off Peak 0 - 0.25","Off Peak 0 - 0.25",3.6556000000000002,3.3755999999999999,350814.5931,1282437.82653636,1184209.74046836]
[null,"Off Peak 0.25 - 1","Off Peak 0.25 - 1",2.2103999999999999,2.0411000000000001,514448.6151,1137137.2188170399,1050041.06828061]
[null,"Off Peak 1 - 1.5","Off Peak 1 - 1.5",1.2218,1.2218,189200.50409999999,231165.17590937999,231165.17590937999]
[null,"Off Peak 1.5 - 5","Off Peak 1.5 - 5",0.74039999999999995,0.74039999999999995,566251.08810000005,419252.30562924,419252.30562924]
[null,"Off Peak >5","Off Peak >5",0.20910000000000001,0.20910000000000001,470692.54009999998,{"$f":"D51*$F51","v":98421.810134910003},{"$f":"E51*$F51","v":98421.810134910003}]
[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,5638,{"$f":"D54*$F54*365","v":376590.20999999996},{"$f":"E54*$F54*365","v":376590.20999999996}]
[null,"Peak 0 - 0.05","Peak 0 - 0.05",11.461,10.5832,30033.335899999998,{"$f":"D55*$F55","v":344212.06274989998},317848.80049687997]
[null,"Peak 0.05 - 0.1","Peak 0.05 - 0.1",8.4895999999999994,7.8394000000000004,25004.321,212276.68356159999,196018.87404740002]
[null,"Peak 0.1 -0.15","Peak 0.1 -0.15",5.6036999999999999,5.6036999999999999,21739.4231,121821.20522547,121821.20522547]
[null,"Peak 0.15 - 0.25","Peak 0.15 - 0.25",4.4203999999999999,4.4203999999999999,34627.150199999996,153065.85474407999,153065.85474407999]
[null,"Peak >0.25","Peak >0.25",4.1197999999999997,4.1197999999999997,55331.188199999997,227953.42914635997,227953.42914635997]
[null,"May Shoulder 0 - 0.05","May Shoulder 0 - 0.05",11.0778,10.2293,7551.6189999999997,83655.324958199999,77247.776236699996]
[null,"May Shoulder 0.05 - 0.1","May Shoulder 0.05 - 0.1",8.2387999999999995,7.6078000000000001,6169.0879999999997,50825.882214399993,46933.187686400001]
[null,"May Shoulder 0.1 -0.15","May Shoulder 0.1 -0.15",5.4839000000000002,5.4839000000000002,5246.0209999999997,28768.654561899999,28768.654561899999]
[null,"May Shoulder 0.15 - 0.25","May Shoulder 0.15 - 0.25",4.3597000000000001,4.3597000000000001,8121.991,35409.444162699998,35409.444162699998]
[null,"May Shoulder >0.25","May Shoulder >0.25",4.0742000000000003,4.0742000000000003,12074.0659,49192.15928978,49192.15928978]
[null,"Oct Shoulder 0 - 0.05","Oct Shoulder 0 - 0.05",11.0778,10.2293,7363.7139999999999,81573.750949199995,75325.639620200003]
[null,"Oct Shoulder 0.05 - 0.1","Oct Shoulder 0.05 - 0.1",8.2387999999999995,7.6078000000000001,5322.8209999999999,43853.657654799994,40494.957603800001]
[null,"Oct Shoulder 0.1 -0.15","Oct Shoulder 0.1 -0.15",5.4839000000000002,5.4839000000000002,3620.2161000000001,19852.903070790002,19852.903070790002]
[null,"Oct Shoulder 0.15 - 0.25","Oct Shoulder 0.15 - 0.25",4.3597000000000001,4.3597000000000001,3501.4,15265.053580000002,15265.053580000002]
[null,"Oct Shoulder >0.25","Oct Shoulder >0.25",4.0742000000000003,4.0742000000000003,2828.4650000000001,11523.732103000002,11523.732103000002]
[null,"Off Peak 0 - 0.05","Off Peak 0 - 0.05",10.311400000000001,9.5215999999999994,34344.239999999998,354137.19633599999,327012.11558399996]
[null,"Off Peak 0.05 - 0.1","Off Peak 0.05 - 0.1",7.7373000000000003,7.1447000000000003,15187.3799,117509.31450027,108509.27317153]
[null,"Off Peak 0.1 -0.15","Off Peak 0.1 -0.15",5.2443,5.2443,7932.643,41601.159684899998,41601.159684899998]
[null,"Off Peak 0.15 - 0.25","Off Peak 0.15 - 0.25",4.2385000000000002,4.2385000000000002,7063.3770999999997,29938.123838349999,29938.123838349999]
[null,"Off Peak >0.25","Off Peak >0.25",4.0199999999999996,4.0199999999999996,8312.8060000000005,{"$f":"D74*$F74","v":33417.48012},{"$f":"E74*$F74","v":33417.48012}]
[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,71,{"$f":"D77*$F77*365","v":7784.8659999999991},{"$f":"E77*$F77*365","v":7784.8659999999991}]
[null,"Peak 0 - 0.25","Peak 0 - 0.25",7.3718000000000004,6.8071999999999999,1439.9670000000001,{"$f":"D78*$F78","v":10615.148730600002},9802.1433624000001]
[null,"Peak 0.25 - 1","Peak 0.25 - 1",5.5446,5.1199000000000003,1829.8040000000001,10145.5312584,9368.4134996000012]
[null,"Peak 1 - 1.5","Peak 1 - 1.5",4.3555000000000001,4.3555000000000001,507.56799999999998,2210.7124239999998,2210.7124239999998]
[null,"Peak 1.5 - 5","Peak 1.5 - 5",3.8468,3.8468,1473.808,5669.4446144000003,5669.4446144000003]
[null,"Peak >5","Peak >5",3.4214000000000002,3.4214000000000002,4175.2089999999998,14285.060072600001,14285.060072600001]
[null,"May Shoulder 0 - 0.25","May Shoulder 0 - 0.25",7.0776000000000003,6.5354999999999999,362.35399999999998,2564.5966704000002,2368.1645669999998]
[null,"May Shoulder 0.25 - 1","May Shoulder 0.25 - 1",5.3376000000000001,4.9287999999999998,480.12599999999998,2562.7205375999997,2366.4450287999998]
[null,"May Shoulder 1 - 1.5","May Shoulder 1 - 1.5",4.298,4.298,128.13499999999999,550.72422999999992,550.72422999999992]
[null,"May Shoulder 1.5 - 5","May Shoulder 1.5 - 5",3.8304,3.8304,362.267,1387.6275168,1387.6275168]
[null,"May Shoulder >5","May Shoulder >5",3.4001000000000001,3.4001000000000001,1026.586,3490.4950586,3490.4950586]
[null,"Oct Shoulder 0 - 0.25","Oct Shoulder 0 - 0.25",7.0776000000000003,6.5354999999999999,330.99299999999999,2342.6360568,2163.2047514999999]
[null,"Oct Shoulder 0.25 - 1","Oct Shoulder 0.25 - 1",5.3376000000000001,4.9287999999999998,381.01400000000001,2033.7003264,1877.9418032000001]
[null,"Oct Shoulder 1 - 1.5","Oct Shoulder 1 - 1.5",4.298,4.298,86.653999999999996,372.43889200000001,372.43889200000001]
[null,"Oct Shoulder 1.5 - 5","Oct Shoulder 1.5 - 5",3.8304,3.8304,248.749,952.80816960000004,952.80816960000004]
[null,"Oct Shoulder >5","Oct Shoulder >5",3.4001000000000001,3.4001000000000001,588.96699999999998,2002.5466967,2002.5466967]
[null,"Off Peak 0 - 0.25","Off Peak 0 - 0.25",6.7720000000000002,6.2533000000000003,1803.521,12213.444212,11277.9578693]
[null,"Off Peak 0.25 - 1","Off Peak 0.25 - 1",5.2736999999999998,4.8697999999999997,2078.2739999999999,10960.193593799999,10120.778725199998]
[null,"Off Peak 1 - 1.5","Off Peak 1 - 1.5",4.2027999999999999,4.2027999999999999,396.327,1665.6831155999998,1665.6831155999998]
[null,"Off Peak 1.5 - 5","Off Peak 1.5 - 5",3.8111999999999999,3.8111999999999999,1604.8420000000001,6116.3738303999999,6116.3738303999999]
[null,"Off Peak >5","Off Peak >5",3.3786999999999998,3.3786999999999998,2332.5140000000001,7880.8650518000004,7880.8650518000004]
[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,6089,{"$f":"D100*$F100*365","v":406714.755},{"$f":"E100*$F100*365","v":406714.755}]
[null,"Peak 0 - 0.05","Peak 0 - 0.05",12.4732,11.517899999999999,28150.190999999999,{"$f":"D101*$F101","v":351122.96238119999},324231.08491889999]
[null,"Peak 0.05 - 0.1","Peak 0.05 - 0.1",9.2920999999999996,8.5803999999999991,21031.598999999998,195427.72106789998,180459.53205959997]
[null,"Peak 0.1 -0.15","Peak 0.1 -0.15",6.2061999999999999,6.2061999999999999,16634.901099999999,103239.52320682,103239.52320682]
[null,"Peak 0.15 - 0.25","Peak 0.15 - 0.25",4.9497,4.9497,22433.632000000001,111039.74831040001,111039.74831040001]
[null,"Peak >0.25","Peak >0.25",4.6306000000000003,4.6306000000000003,20193.120900000002,93506.265639540012,93506.265639540012]
[null,"May Shoulder 0 - 0.05","May Shoulder 0 - 0.05",12.0661,11.1419,7110.4911000000002,85795.896661710009,79224.380787090005]
[null,"May Shoulder 0.05 - 0.1","May Shoulder 0.05 - 0.1",9.0259,8.3346,5082.9480000000003,45878.180353200005,42364.338400799999]
[null,"May Shoulder 0.1 -0.15","May Shoulder 0.1 -0.15",6.0789999999999997,6.0789999999999997,3711.84,22564.27536,22564.27536]
[null,"May Shoulder 0.15 - 0.25","May Shoulder 0.15 - 0.25",4.8853,4.8853,4109.5209999999997,20076.242941299999,20076.242941299999]
[null,"May Shoulder >0.25","May Shoulder >0.25",4.5819999999999999,4.5819999999999999,2632.1390000000001,12060.460897999999,12060.460897999999]
[null,"Oct Shoulder 0 - 0.05","Oct Shoulder 0 - 0.05",12.0661,11.1419,6328.2920000000004,76357.804101200003,70509.196634799999]
[null,"Oct Shoulder 0.05 - 0.1","Oct Shoulder 0.05 - 0.1",9.0259,8.3346,3278.8870000000002,29594.906173300002,27328.211590200001]
[null,"Oct Shoulder 0.1 -0.15","Oct Shoulder 0.1 -0.15",6.0789999999999997,6.0789999999999997,1675.3109999999999,10184.215569,10184.215569]
[null,"Oct Shoulder 0.15 - 0.25","Oct Shoulder 0.15 - 0.25",4.8853,4.8853,1322.0830000000001,6458.7720799000008,6458.7720799000008]
[null,"Oct Shoulder >0.25","Oct Shoulder >0.25",4.5819999999999999,4.5819999999999999,1043.606,4781.8026920000002,4781.8026920000002]
[null,"Off Peak 0 - 0.05","Off Peak 0 - 0.05",11.2525,10.390700000000001,29133.198,327821.31049499998,302714.32045860001]
[null,"Off Peak 0.05 - 0.1","Off Peak 0.05 - 0.1",8.4932999999999996,7.8428000000000004,9497.6002000000008,80665.967778660008,74487.778848560003]
[null,"Off Peak 0.1 -0.15","Off Peak 0.1 -0.15",5.8247,5.8247,4404.8360000000002,25656.8482492,25656.8482492]
[null,"Off Peak 0.15 - 0.25","Off Peak 0.15 - 0.25",4.7565,4.7565,3785.9870000000001,18008.0471655,18008.0471655]
[null,"Off Peak >0.25","Off Peak >0.25",4.4851999999999999,4.4851999999999999,3777.24,{"$f":"D120*$F120","v":16941.676847999999},{"$f":"E120*$F120","v":16941.676847999999}]
[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,118,{"$f":"D123*$F123*365","v":12998.526},{"$f":"E123*$F123*365","v":12998.526}]
[null,"Peak 0 - 0.25","Peak 0 - 0.25",8.1306999999999992,7.508,2452.1869999999999,{"$f":"D124*$F124","v":19937.996840899996},18411.019995999999]
[null,"Peak 0.25 - 1","Peak 0.25 - 1",6.1649000000000003,5.6927000000000003,4544.4889999999996,28016.3202361,25870.4125303]
[null,"Peak 1 - 1.5","Peak 1 - 1.5",4.8807,4.8807,1929.5840000000001,9417.7206287999998,9417.7206287999998]
[null,"Peak 1.5 - 5","Peak 1.5 - 5",4.3407999999999998,4.3407999999999998,7929.1130000000003,34418.693710400003,34418.693710400003]
[null,"Peak >5","Peak >5",3.8889999999999998,3.8889999999999998,11791.799000000001,45858.306311,45858.306311]
[null,"May Shoulder 0 - 0.25","May Shoulder 0 - 0.25",7.8183999999999996,7.2195999999999998,586.50400000000002,4585.5228735999999,4234.3242784000004]
[null,"May Shoulder 0.25 - 1","May Shoulder 0.25 - 1",5.9448999999999996,5.4896000000000003,1023.1079999999999,6082.274749199999,5616.4536767999998]
[null,"May Shoulder 1 - 1.5","May Shoulder 1 - 1.5",4.8198999999999996,4.8198999999999996,424.142,2044.3220257999999,2044.3220257999999]
[null,"May Shoulder 1.5 - 5","May Shoulder 1.5 - 5",4.3231999999999999,4.3231999999999999,1865.4110000000001,8064.5448352000003,8064.5448352000003]
[null,"May Shoulder >5","May Shoulder >5",3.8662000000000001,3.8662000000000001,2087.732,8071.5894583999998,8071.5894583999998]
[null,"Oct Shoulder 0 - 0.25","Oct Shoulder 0 - 0.25",7.8183999999999996,7.2195999999999998,563.32100000000003,4404.2689063999997,4066.9522916000001]
[null,"Oct Shoulder 0.25 - 1","Oct Shoulder 0.25 - 1",5.9448999999999996,5.4896000000000003,1039.076,6177.2029124000001,5704.1116096000005]
[null,"Oct Shoulder 1 - 1.5","Oct Shoulder 1 - 1.5",4.8198999999999996,4.8198999999999996,427.29199999999997,2059.5047107999999,2059.5047107999999]
[null,"Oct Shoulder 1.5 - 5","Oct Shoulder 1.5 - 5",4.3231999999999999,4.3231999999999999,1759.251,7605.5939232000001,7605.5939232000001]
[null,"Oct Shoulder >5","Oct Shoulder >5",3.8662000000000001,3.8662000000000001,2222.7669999999998,8593.6617753999999,8593.6617753999999]
[null,"Off Peak 0 - 0.25","Off Peak 0 - 0.25",7.4941000000000004,6.9200999999999997,3063.13,22955.402533,21197.165913000001]
[null,"Off Peak 0.25 - 1","Off Peak 0.25 - 1",5.8769999999999998,5.4268999999999998,5807.8980000000001,34133.016545999999,31518.881656199999]
[null,"Off Peak 1 - 1.5","Off Peak 1 - 1.5",4.7186000000000003,4.7186000000000003,2613.9609999999998,12334.236374599999,12334.236374599999]
[null,"Off Peak 1.5 - 5","Off Peak 1.5 - 5",4.3028000000000004,4.3028000000000004,10002.494000000001,43038.731183200005,43038.731183200005]
[null,"Off Peak >5","Off Peak >5",3.8435999999999999,3.8435999999999999,10375.370000000001,39878.772132000006,39878.772132000006]
[]
[null,"Tariff D - Multinet","Tariff D - Multinet"]
[null,"0 - 50","0 - 50",621.90899999999999,598.92169999999999,2886.22,{"$f":"D146*$F146","v":1794966.1939799997},{"$f":"E146*$F146","v":1728619.7889739999}]
[null,"> 50","> 50",105.8207,101.9014,452.51,{"$f":"D147*$F147","v":47884.924957000003},{"$f":"E147*$F147","v":46111.402513999994}]
[]
[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.64159999999999995,6188.06,{"$f":"D152*$F152","v":3970.2592959999997},3970.2592959999997]
[null,"Peak > 5","Peak > 5",0.1376,0.1376,15999.67,2201.554592,2201.554592]
[null,"May Shoulder < 5","May Shoulder < 5",0.56879999999999997,0.56879999999999997,1550.69,882.03247199999998,882.03247199999998]
[null,"May Shoulder > 5","May Shoulder > 5",0.12920000000000001,0.12920000000000001,3335.2,430.90784000000002,430.90784000000002]
[null,"Oct Shoulder < 5","Oct Shoulder < 5",0.56879999999999997,0.56879999999999997,1550.05,881.66843999999992,881.66843999999992]
[null,"Oct Shoulder > 5","Oct Shoulder > 5",0.12920000000000001,0.12920000000000001,3101.96,400.77323200000001,400.77323200000001]
[null,"Off Peak < 5","Off Peak < 5",0.45100000000000001,0.45100000000000001,8714.34,3930.16734,3930.16734]
[null,"Off Peak > 5","Off Peak > 5",0.1236,0.1026,13148.11,{"$f":"D159*$F159","v":1625.1063960000001},{"$f":"E159*$F159","v":1348.9960860000001}]
[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.59650000000000003,35.799999999999997,{"$f":"D161*$F161*365","v":7794.4655000000002},{"$f":"E161*$F161*365","v":7794.4655000000002}]
[null,"Peak Demand [$/GJ (MHQ/d)]","Peak Demand [$/GJ (MHQ/d)]",1.7846,1.7846,25.81,{"$f":"D162*$F162*122","v":5619.3841719999991},{"$f":"E162*$F162*122","v":5619.3841719999991}]
[null,"Tariff D - Multinet South Gippsland","Tariff D - Multinet South Gippsland"]
[null,"0 - 50","0 - 50",671.96969999999999,647.08190000000002,100,{"$f":"D164*$F164","v":67196.97},{"$f":"E164*$F164","v":64708.19}]
[null,"> 50","> 50",114.3231,110.0889,62.2,{"$f":"D165*$F165","v":7110.8968199999999},{"$f":"E165*$F165","v":6847.5295800000004}]
[]
[]
[null,"Total Revenue","Total Revenue",null,null,null,{"$f":"SUM(G8:G166)","v":229082221.45904127},{"$f":"SUM(H8:H166)","v":218410325.84091642}]

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

{"sheet":"2022RebalContForm","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":"2022RebalContForm"}]
[]
[null,{"$f":"'Model update'!$B$5&\"  REBALANCING CONTROL FORMULA\"","v":"2022  REBALANCING CONTROL FORMULA"}]
[]
[]
[null,"Rebalancing control"]
[]
[null,{"$f":"\"CPI \"&'Model update'!$B$5","v":"CPI 2022"},{"$f":"'2022TarContForm'!C11","v":3.8461538461538325E-2}]
[null,{"$f":"\"Y  \"&'Model update'!$B$5","v":"Y  2022"},0.02]
[null,{"$f":"\"PTt \"&'Model update'!$B$5","v":"PTt 2022"},{"$f":"'2022TarContForm'!C31","v":0}]
[null,{"$f":"\"Xt \"&'Model update'!$B$5","v":"Xt 2022"},{"$f":"'2022TarContForm'!C17","v":-1.0014953218312436E-2}]
[]
[null,"Rebalancing control",{"$f":"(1+C8)*(1+C9)*(1+C10)*(1-C11)","v":1.0698389158320125}]
[]
[]
[]
[null,"Rebalancing control summary"]
[null,null,"Existing","Proposed","Movement","Assessment"]
[null,{"$f":"B32","v":"Tariff V - Multinet Residential"},{"$f":"C53","v":202856692.29092628},{"$f":"C54","v":212817103.50239259},{"$f":"IF(C19=0,0,D19/C19)","v":1.049100727705752},{"$f":"IF(E19=0,\"\",IF($C$13<=E19,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B62","v":"Tariff V - Yarra Valley Residential"},{"$f":"C83","v":2333790.0339742405},{"$f":"C84","v":2432443.2824517004},1.0422716898441211,{"$f":"IF(E20=0,\"\",IF($C$13<=E20,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B92","v":"Tariff V - South Gippsland Residential"},{"$f":"C113","v":1952551.4776582101},{"$f":"C114","v":2043897.38297183},1.0467828409948892,"Compliant"]
[null,{"$f":"B122","v":"Tariff V - Multinet Non-Residential"},{"$f":"C143","v":8938826.6980193816},{"$f":"C144","v":9375398.1604631711},1.0488399067565011,"Compliant"]
[null,{"$f":"B152","v":"Tariff V - Yarra Valley Non-Residential"},{"$f":"C173","v":103714.6952795},{"$f":"C174","v":107807.61705849999},1.0394632772913233,"Compliant"]
[null,{"$f":"B182","v":"Tariff V - South Gippsland Non-Residential"},{"$f":"C203","v":351003.52502070006},{"$f":"C204","v":360676.20866640011},1.0275572265125532,"Compliant"]
[null,{"$f":"B212","v":"Tariff D - Multinet"},{"$f":"C227","v":1774731.1914879999},{"$f":"C228","v":1842851.1189369997},1.0383832367266197,"Compliant"]
[null,{"$f":"B265","v":"Tariff D - Multinet South Gippsland"},{"$f":"C280","v":71555.719580000004},{"$f":"C281","v":74307.866819999996},1.0384615968668034,"Compliant"]
[null,"Tariff L - Multinet",{"$f":"C256","v":27460.20897},{"$f":"C257","v":27736.319279999996},1.0100549238464152,"Compliant"]
[null,null,{"$f":"SUM(C19:C27)","v":218410325.84091631},{"$f":"SUM(D19:D27)","v":229082221.45904118},1.0488616807700657]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!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): \"&Prop2022DistTar!C6","v":"Existing (1 Jan-31 Dec): Tariff V - Multinet Residential"},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$28,C$33)","v":0.183},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$28,D$33)","v":8.8805999999999994},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$28,E$33)","v":5.8383000000000003},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$28,F$33)","v":3.0185},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$28,G$33)","v":1.5276000000000001},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$28,H$33)","v":1.1329},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$28,I$33)","v":8.4760000000000009},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$28,J$33)","v":5.5464000000000002},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$28,K$33)","v":2.8685999999999998},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$28,L$33)","v":1.4513},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$28,M$33)","v":1.0912999999999999},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$28,N$33)","v":8.4760000000000009},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$28,O$33)","v":5.5464000000000002},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$28,P$33)","v":2.8685999999999998},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$28,Q$33)","v":1.4513},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$28,R$33)","v":1.0912999999999999},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$28,S$33)","v":7.5838999999999999},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$28,T$33)","v":4.9626999999999999},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$28,U$33)","v":2.5666000000000002},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$28,V$33)","v":1.2985},{"$f":"INDEX(Prop2022DistTar!$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(Prop2022DistTar!$D$8:$D$28,C$32)","v":0.183},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$28,D$32)","v":9.6172000000000004},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$28,E$32)","v":6.3226000000000004},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$28,F$32)","v":3.0185},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$28,G$32)","v":1.5276000000000001},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$28,H$32)","v":1.1329},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$28,I$32)","v":9.1790000000000003},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$28,J$32)","v":6.0064000000000002},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$28,K$32)","v":2.8685999999999998},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$28,L$32)","v":1.4513},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$28,M$32)","v":1.0912999999999999},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$28,N$32)","v":9.1790000000000003},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$28,O$32)","v":6.0064000000000002},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$28,P$32)","v":2.8685999999999998},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$28,Q$32)","v":1.4513},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$28,R$32)","v":1.0912999999999999},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$28,S$32)","v":8.2128999999999994},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$28,T$32)","v":5.3742999999999999},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$28,U$32)","v":2.5666000000000002},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$28,V$32)","v":1.2985},{"$f":"INDEX(Prop2022DistTar!$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(Prop2022DistTar!$F$8:$F$28,C$32)","v":689383},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,D$32)","v":3668242.6715000002},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,E$32)","v":3035296.1157999998},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,F$32)","v":2622212.3738000002},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,G$32)","v":4252284.7959000003},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,H$32)","v":8080820.3513000002},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,I$32)","v":928731.71010000003},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,J$32)","v":758383.4497},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,K$32)","v":642917.08799999999},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,L$32)","v":994914.68740000005},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,M$32)","v":1589898.0086000001},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,N$32)","v":892680.26489999995},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,O$32)","v":626786.33089999994},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,P$32)","v":425681.24489999999},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,Q$32)","v":471225.7807},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,R$32)","v":471364.97399999999},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,S$32)","v":4713253.2405000003},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,T$32)","v":2201464.395},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,U$32)","v":1113629.2634999999},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,V$32)","v":1108339.0597999999},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,W$32)","v":1449295.0033}]
[]
[null,{"$f":"B38","v":"Proposed (1 Jan-31 Dec): Tariff V - Multinet Residential"},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,C$32)","v":689383},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,D$32)","v":3668242.6715000002},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,E$32)","v":3035296.1157999998},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,F$32)","v":2622212.3738000002},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,G$32)","v":4252284.7959000003},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,H$32)","v":8080820.3513000002},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,I$32)","v":928731.71010000003},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,J$32)","v":758383.4497},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,K$32)","v":642917.08799999999},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,L$32)","v":994914.68740000005},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,M$32)","v":1589898.0086000001},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,N$32)","v":892680.26489999995},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,O$32)","v":626786.33089999994},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,P$32)","v":425681.24489999999},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,Q$32)","v":471225.7807},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,R$32)","v":471364.97399999999},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,S$32)","v":4713253.2405000003},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,T$32)","v":2201464.395},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,U$32)","v":1113629.2634999999},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,V$32)","v":1108339.0597999999},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$28,W$32)","v":1449295.0033}]
[]
[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(Prop2022DistTar!$H$8:$H$28,C$33)","v":46047337.484999999},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$28,D$33)","v":32576195.868522901},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$28,E$33)","v":17720969.31287514},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$28,F$33)","v":7915148.0503153},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$28,G$33)","v":6495790.2542168405},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$28,H$33)","v":9154761.37598777},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$28,I$33)","v":7871929.9748076014},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$28,J$33)","v":4206297.9654160803},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$28,K$33)","v":1844271.9586367998},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$28,L$33)","v":1443919.6858236201},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$28,M$33)","v":1735055.6967851799},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$28,N$33)","v":7566357.9252924006},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$28,O$33)","v":3476407.70570376},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$28,P$33)","v":1221109.21912014},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$28,Q$33)","v":683889.97552991007},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$28,R$33)","v":514400.59612619993},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$28,S$33)","v":35744841.25062795},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$28,T$33)","v":10925207.3530665},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$28,U$33)","v":2858240.8676991002},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$28,V$33)","v":1439178.2691503},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$28,W$33)","v":1415381.50022278}]
[]
[null,{"$f":"B44","v":"Proposed (1 Jan-31 Dec): Tariff V - Multinet Residential"},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$28,C$32)","v":46047337.484999999},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$28,D$32)","v":35278223.420349807},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$28,E$32)","v":19190963.22175708},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$28,F$32)","v":7915148.0503153},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$28,G$32)","v":6495790.2542168405},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$28,H$32)","v":9154761.37598777},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$28,I$32)","v":8524828.3670079},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$28,J$32)","v":4555154.3522780798},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$28,K$32)","v":1844271.9586367998},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$28,L$32)","v":1443919.6858236201},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$28,M$32)","v":1735055.6967851799},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$28,N$32)","v":8193912.1515170997},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$28,O$32)","v":3764729.4179177596},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$28,P$32)","v":1221109.21912014},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$28,Q$32)","v":683889.97552991007},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$28,R$32)","v":514400.59612619993},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$28,S$32)","v":38709477.538902447},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$28,T$32)","v":11831330.098048499},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$28,U$32)","v":2858240.8676991002},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$28,V$32)","v":1439178.2691503},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$28,W$32)","v":1415381.50022278}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B48","v":"Existing (1 Jan-31 Dec): Tariff V - Multinet Residential"},{"$f":"SUM(C48:W48)","v":202856692.29092628}]
[null,{"$f":"B50","v":"Proposed (1 Jan-31 Dec): Tariff V - Multinet Residential"},{"$f":"SUM(C50:W50)","v":212817103.50239259}]
[]
[null,"Average price movement",{"$f":"IF(C54=0,\"\",C54/C53)","v":1.049100727705752}]
[]
[null,{"$f":"IF(C56=\"\",\"\",IF(C56<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!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): \"&Prop2022DistTar!C52","v":"Existing (1 Jan-31 Dec): Tariff V - Yarra Valley Residential"},{"$f":"INDEX(Prop2022DistTar!$E$54:$E$74,C$33)","v":0.183},{"$f":"INDEX(Prop2022DistTar!$E$54:$E$74,D$33)","v":10.5832},{"$f":"INDEX(Prop2022DistTar!$E$54:$E$74,E$33)","v":7.8394000000000004},{"$f":"INDEX(Prop2022DistTar!$E$54:$E$74,F$33)","v":5.6036999999999999},{"$f":"INDEX(Prop2022DistTar!$E$54:$E$74,G$33)","v":4.4203999999999999},{"$f":"INDEX(Prop2022DistTar!$E$54:$E$74,H$33)","v":4.1197999999999997},{"$f":"INDEX(Prop2022DistTar!$E$54:$E$74,I$33)","v":10.2293},{"$f":"INDEX(Prop2022DistTar!$E$54:$E$74,J$33)","v":7.6078000000000001},{"$f":"INDEX(Prop2022DistTar!$E$54:$E$74,K$33)","v":5.4839000000000002},{"$f":"INDEX(Prop2022DistTar!$E$54:$E$74,L$33)","v":4.3597000000000001},{"$f":"INDEX(Prop2022DistTar!$E$54:$E$74,M$33)","v":4.0742000000000003},{"$f":"INDEX(Prop2022DistTar!$E$54:$E$74,N$33)","v":10.2293},{"$f":"INDEX(Prop2022DistTar!$E$54:$E$74,O$33)","v":7.6078000000000001},{"$f":"INDEX(Prop2022DistTar!$E$54:$E$74,P$33)","v":5.4839000000000002},{"$f":"INDEX(Prop2022DistTar!$E$54:$E$74,Q$33)","v":4.3597000000000001},{"$f":"INDEX(Prop2022DistTar!$E$54:$E$74,R$33)","v":4.0742000000000003},{"$f":"INDEX(Prop2022DistTar!$E$54:$E$74,S$33)","v":9.5215999999999994},{"$f":"INDEX(Prop2022DistTar!$E$54:$E$74,T$33)","v":7.1447000000000003},{"$f":"INDEX(Prop2022DistTar!$E$54:$E$74,U$33)","v":5.2443},{"$f":"INDEX(Prop2022DistTar!$E$54:$E$74,V$33)","v":4.2385000000000002},{"$f":"INDEX(Prop2022DistTar!$E$54:$E$74,W$33)","v":4.0199999999999996}]
[]
[null,{"$f":"\"Proposed (1 Jan-31 Dec): \"&B62","v":"Proposed (1 Jan-31 Dec): Tariff V - Yarra Valley Residential"},{"$f":"INDEX(Prop2022DistTar!$D$54:$D$74,C$32)","v":0.183},{"$f":"INDEX(Prop2022DistTar!$D$54:$D$74,D$32)","v":11.461},{"$f":"INDEX(Prop2022DistTar!$D$54:$D$74,E$32)","v":8.4895999999999994},{"$f":"INDEX(Prop2022DistTar!$D$54:$D$74,F$32)","v":5.6036999999999999},{"$f":"INDEX(Prop2022DistTar!$D$54:$D$74,G$32)","v":4.4203999999999999},{"$f":"INDEX(Prop2022DistTar!$D$54:$D$74,H$32)","v":4.1197999999999997},{"$f":"INDEX(Prop2022DistTar!$D$54:$D$74,I$32)","v":11.0778},{"$f":"INDEX(Prop2022DistTar!$D$54:$D$74,J$32)","v":8.2387999999999995},{"$f":"INDEX(Prop2022DistTar!$D$54:$D$74,K$32)","v":5.4839000000000002},{"$f":"INDEX(Prop2022DistTar!$D$54:$D$74,L$32)","v":4.3597000000000001},{"$f":"INDEX(Prop2022DistTar!$D$54:$D$74,M$32)","v":4.0742000000000003},{"$f":"INDEX(Prop2022DistTar!$D$54:$D$74,N$32)","v":11.0778},{"$f":"INDEX(Prop2022DistTar!$D$54:$D$74,O$32)","v":8.2387999999999995},{"$f":"INDEX(Prop2022DistTar!$D$54:$D$74,P$32)","v":5.4839000000000002},{"$f":"INDEX(Prop2022DistTar!$D$54:$D$74,Q$32)","v":4.3597000000000001},{"$f":"INDEX(Prop2022DistTar!$D$54:$D$74,R$32)","v":4.0742000000000003},{"$f":"INDEX(Prop2022DistTar!$D$54:$D$74,S$32)","v":10.311400000000001},{"$f":"INDEX(Prop2022DistTar!$D$54:$D$74,T$32)","v":7.7373000000000003},{"$f":"INDEX(Prop2022DistTar!$D$54:$D$74,U$32)","v":5.2443},{"$f":"INDEX(Prop2022DistTar!$D$54:$D$74,V$32)","v":4.2385000000000002},{"$f":"INDEX(Prop2022DistTar!$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(Prop2022DistTar!$F$54:$F$74,C$32)","v":5638},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,D$32)","v":30033.335899999998},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,E$32)","v":25004.321},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,F$32)","v":21739.4231},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,G$32)","v":34627.150199999996},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,H$32)","v":55331.188199999997},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,I$32)","v":7551.6189999999997},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,J$32)","v":6169.0879999999997},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,K$32)","v":5246.0209999999997},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,L$32)","v":8121.991},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,M$32)","v":12074.0659},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,N$32)","v":7363.7139999999999},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,O$32)","v":5322.8209999999999},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,P$32)","v":3620.2161000000001},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,Q$32)","v":3501.4},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,R$32)","v":2828.4650000000001},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,S$32)","v":34344.239999999998},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,T$32)","v":15187.3799},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,U$32)","v":7932.643},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,V$32)","v":7063.3770999999997},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,W$32)","v":8312.8060000000005}]
[]
[null,{"$f":"B68","v":"Proposed (1 Jan-31 Dec): Tariff V - Yarra Valley Residential"},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,C$32)","v":5638},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,D$32)","v":30033.335899999998},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,E$32)","v":25004.321},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,F$32)","v":21739.4231},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,G$32)","v":34627.150199999996},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,H$32)","v":55331.188199999997},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,I$32)","v":7551.6189999999997},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,J$32)","v":6169.0879999999997},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,K$32)","v":5246.0209999999997},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,L$32)","v":8121.991},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,M$32)","v":12074.0659},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,N$32)","v":7363.7139999999999},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,O$32)","v":5322.8209999999999},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,P$32)","v":3620.2161000000001},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,Q$32)","v":3501.4},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,R$32)","v":2828.4650000000001},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,S$32)","v":34344.239999999998},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,T$32)","v":15187.3799},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,U$32)","v":7932.643},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,V$32)","v":7063.3770999999997},{"$f":"INDEX(Prop2022DistTar!$F$54:$F$74,W$32)","v":8312.8060000000005}]
[]
[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(Prop2022DistTar!$H$54:$H$74,C$33)","v":376590.20999999996},{"$f":"INDEX(Prop2022DistTar!$H$54:$H$74,D$33)","v":317848.80049687997},{"$f":"INDEX(Prop2022DistTar!$H$54:$H$74,E$33)","v":196018.87404740002},{"$f":"INDEX(Prop2022DistTar!$H$54:$H$74,F$33)","v":121821.20522547},{"$f":"INDEX(Prop2022DistTar!$H$54:$H$74,G$33)","v":153065.85474407999},{"$f":"INDEX(Prop2022DistTar!$H$54:$H$74,H$33)","v":227953.42914635997},{"$f":"INDEX(Prop2022DistTar!$H$54:$H$74,I$33)","v":77247.776236699996},{"$f":"INDEX(Prop2022DistTar!$H$54:$H$74,J$33)","v":46933.187686400001},{"$f":"INDEX(Prop2022DistTar!$H$54:$H$74,K$33)","v":28768.654561899999},{"$f":"INDEX(Prop2022DistTar!$H$54:$H$74,L$33)","v":35409.444162699998},{"$f":"INDEX(Prop2022DistTar!$H$54:$H$74,M$33)","v":49192.15928978},{"$f":"INDEX(Prop2022DistTar!$H$54:$H$74,N$33)","v":75325.639620200003},{"$f":"INDEX(Prop2022DistTar!$H$54:$H$74,O$33)","v":40494.957603800001},{"$f":"INDEX(Prop2022DistTar!$H$54:$H$74,P$33)","v":19852.903070790002},{"$f":"INDEX(Prop2022DistTar!$H$54:$H$74,Q$33)","v":15265.053580000002},{"$f":"INDEX(Prop2022DistTar!$H$54:$H$74,R$33)","v":11523.732103000002},{"$f":"INDEX(Prop2022DistTar!$H$54:$H$74,S$33)","v":327012.11558399996},{"$f":"INDEX(Prop2022DistTar!$H$54:$H$74,T$33)","v":108509.27317153},{"$f":"INDEX(Prop2022DistTar!$H$54:$H$74,U$33)","v":41601.159684899998},{"$f":"INDEX(Prop2022DistTar!$H$54:$H$74,V$33)","v":29938.123838349999},{"$f":"INDEX(Prop2022DistTar!$H$54:$H$74,W$33)","v":33417.48012}]
[]
[null,{"$f":"B74","v":"Proposed (1 Jan-31 Dec): Tariff V - Yarra Valley Residential"},{"$f":"INDEX(Prop2022DistTar!$G$54:$G$74,C$32)","v":376590.20999999996},{"$f":"INDEX(Prop2022DistTar!$G$54:$G$74,D$32)","v":344212.06274989998},{"$f":"INDEX(Prop2022DistTar!$G$54:$G$74,E$32)","v":212276.68356159999},{"$f":"INDEX(Prop2022DistTar!$G$54:$G$74,F$32)","v":121821.20522547},{"$f":"INDEX(Prop2022DistTar!$G$54:$G$74,G$32)","v":153065.85474407999},{"$f":"INDEX(Prop2022DistTar!$G$54:$G$74,H$32)","v":227953.42914635997},{"$f":"INDEX(Prop2022DistTar!$G$54:$G$74,I$32)","v":83655.324958199999},{"$f":"INDEX(Prop2022DistTar!$G$54:$G$74,J$32)","v":50825.882214399993},{"$f":"INDEX(Prop2022DistTar!$G$54:$G$74,K$32)","v":28768.654561899999},{"$f":"INDEX(Prop2022DistTar!$G$54:$G$74,L$32)","v":35409.444162699998},{"$f":"INDEX(Prop2022DistTar!$G$54:$G$74,M$32)","v":49192.15928978},{"$f":"INDEX(Prop2022DistTar!$G$54:$G$74,N$32)","v":81573.750949199995},{"$f":"INDEX(Prop2022DistTar!$G$54:$G$74,O$32)","v":43853.657654799994},{"$f":"INDEX(Prop2022DistTar!$G$54:$G$74,P$32)","v":19852.903070790002},{"$f":"INDEX(Prop2022DistTar!$G$54:$G$74,Q$32)","v":15265.053580000002},{"$f":"INDEX(Prop2022DistTar!$G$54:$G$74,R$32)","v":11523.732103000002},{"$f":"INDEX(Prop2022DistTar!$G$54:$G$74,S$32)","v":354137.19633599999},{"$f":"INDEX(Prop2022DistTar!$G$54:$G$74,T$32)","v":117509.31450027},{"$f":"INDEX(Prop2022DistTar!$G$54:$G$74,U$32)","v":41601.159684899998},{"$f":"INDEX(Prop2022DistTar!$G$54:$G$74,V$32)","v":29938.123838349999},{"$f":"INDEX(Prop2022DistTar!$G$54:$G$74,W$32)","v":33417.48012}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B78","v":"Existing (1 Jan-31 Dec): Tariff V - Yarra Valley Residential"},{"$f":"SUM(C78:W78)","v":2333790.0339742405}]
[null,{"$f":"B80","v":"Proposed (1 Jan-31 Dec): Tariff V - Yarra Valley Residential"},{"$f":"SUM(C80:W80)","v":2432443.2824517004}]
[]
[null,"Average price movement",{"$f":"IF(C84=0,\"\",C84/C83)","v":1.0422716898441211}]
[]
[null,{"$f":"IF(C86=\"\",\"\",IF(C86<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!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): \"&Prop2022DistTar!C98","v":"Existing (1 Jan-31 Dec): Tariff V - South Gippsland Residential"},{"$f":"INDEX(Prop2022DistTar!$E$100:$E$120,C$33)","v":0.183},{"$f":"INDEX(Prop2022DistTar!$E$100:$E$120,D$33)","v":11.517899999999999},{"$f":"INDEX(Prop2022DistTar!$E$100:$E$120,E$33)","v":8.5803999999999991},{"$f":"INDEX(Prop2022DistTar!$E$100:$E$120,F$33)","v":6.2061999999999999},{"$f":"INDEX(Prop2022DistTar!$E$100:$E$120,G$33)","v":4.9497},{"$f":"INDEX(Prop2022DistTar!$E$100:$E$120,H$33)","v":4.6306000000000003},{"$f":"INDEX(Prop2022DistTar!$E$100:$E$120,I$33)","v":11.1419},{"$f":"INDEX(Prop2022DistTar!$E$100:$E$120,J$33)","v":8.3346},{"$f":"INDEX(Prop2022DistTar!$E$100:$E$120,K$33)","v":6.0789999999999997},{"$f":"INDEX(Prop2022DistTar!$E$100:$E$120,L$33)","v":4.8853},{"$f":"INDEX(Prop2022DistTar!$E$100:$E$120,M$33)","v":4.5819999999999999},{"$f":"INDEX(Prop2022DistTar!$E$100:$E$120,N$33)","v":11.1419},{"$f":"INDEX(Prop2022DistTar!$E$100:$E$120,O$33)","v":8.3346},{"$f":"INDEX(Prop2022DistTar!$E$100:$E$120,P$33)","v":6.0789999999999997},{"$f":"INDEX(Prop2022DistTar!$E$100:$E$120,Q$33)","v":4.8853},{"$f":"INDEX(Prop2022DistTar!$E$100:$E$120,R$33)","v":4.5819999999999999},{"$f":"INDEX(Prop2022DistTar!$E$100:$E$120,S$33)","v":10.390700000000001},{"$f":"INDEX(Prop2022DistTar!$E$100:$E$120,T$33)","v":7.8428000000000004},{"$f":"INDEX(Prop2022DistTar!$E$100:$E$120,U$33)","v":5.8247},{"$f":"INDEX(Prop2022DistTar!$E$100:$E$120,V$33)","v":4.7565},{"$f":"INDEX(Prop2022DistTar!$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(Prop2022DistTar!$D$100:$D$120,C$32)","v":0.183},{"$f":"INDEX(Prop2022DistTar!$D$100:$D$120,D$32)","v":12.4732},{"$f":"INDEX(Prop2022DistTar!$D$100:$D$120,E$32)","v":9.2920999999999996},{"$f":"INDEX(Prop2022DistTar!$D$100:$D$120,F$32)","v":6.2061999999999999},{"$f":"INDEX(Prop2022DistTar!$D$100:$D$120,G$32)","v":4.9497},{"$f":"INDEX(Prop2022DistTar!$D$100:$D$120,H$32)","v":4.6306000000000003},{"$f":"INDEX(Prop2022DistTar!$D$100:$D$120,I$32)","v":12.0661},{"$f":"INDEX(Prop2022DistTar!$D$100:$D$120,J$32)","v":9.0259},{"$f":"INDEX(Prop2022DistTar!$D$100:$D$120,K$32)","v":6.0789999999999997},{"$f":"INDEX(Prop2022DistTar!$D$100:$D$120,L$32)","v":4.8853},{"$f":"INDEX(Prop2022DistTar!$D$100:$D$120,M$32)","v":4.5819999999999999},{"$f":"INDEX(Prop2022DistTar!$D$100:$D$120,N$32)","v":12.0661},{"$f":"INDEX(Prop2022DistTar!$D$100:$D$120,O$32)","v":9.0259},{"$f":"INDEX(Prop2022DistTar!$D$100:$D$120,P$32)","v":6.0789999999999997},{"$f":"INDEX(Prop2022DistTar!$D$100:$D$120,Q$32)","v":4.8853},{"$f":"INDEX(Prop2022DistTar!$D$100:$D$120,R$32)","v":4.5819999999999999},{"$f":"INDEX(Prop2022DistTar!$D$100:$D$120,S$32)","v":11.2525},{"$f":"INDEX(Prop2022DistTar!$D$100:$D$120,T$32)","v":8.4932999999999996},{"$f":"INDEX(Prop2022DistTar!$D$100:$D$120,U$32)","v":5.8247},{"$f":"INDEX(Prop2022DistTar!$D$100:$D$120,V$32)","v":4.7565},{"$f":"INDEX(Prop2022DistTar!$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(Prop2022DistTar!$F$100:$F$120,C$32)","v":6089},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,D$32)","v":28150.190999999999},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,E$32)","v":21031.598999999998},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,F$32)","v":16634.901099999999},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,G$32)","v":22433.632000000001},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,H$32)","v":20193.120900000002},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,I$32)","v":7110.4911000000002},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,J$32)","v":5082.9480000000003},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,K$32)","v":3711.84},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,L$32)","v":4109.5209999999997},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,M$32)","v":2632.1390000000001},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,N$32)","v":6328.2920000000004},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,O$32)","v":3278.8870000000002},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,P$32)","v":1675.3109999999999},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,Q$32)","v":1322.0830000000001},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,R$32)","v":1043.606},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,S$32)","v":29133.198},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,T$32)","v":9497.6002000000008},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,U$32)","v":4404.8360000000002},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,V$32)","v":3785.9870000000001},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,W$32)","v":3777.24}]
[]
[null,{"$f":"B98","v":"Proposed (1 Jan-31 Dec): Tariff V - South Gippsland Residential"},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,C$32)","v":6089},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,D$32)","v":28150.190999999999},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,E$32)","v":21031.598999999998},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,F$32)","v":16634.901099999999},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,G$32)","v":22433.632000000001},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,H$32)","v":20193.120900000002},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,I$32)","v":7110.4911000000002},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,J$32)","v":5082.9480000000003},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,K$32)","v":3711.84},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,L$32)","v":4109.5209999999997},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,M$32)","v":2632.1390000000001},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,N$32)","v":6328.2920000000004},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,O$32)","v":3278.8870000000002},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,P$32)","v":1675.3109999999999},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,Q$32)","v":1322.0830000000001},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,R$32)","v":1043.606},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,S$32)","v":29133.198},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,T$32)","v":9497.6002000000008},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,U$32)","v":4404.8360000000002},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,V$32)","v":3785.9870000000001},{"$f":"INDEX(Prop2022DistTar!$F$100:$F$120,W$32)","v":3777.24}]
[]
[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(Prop2022DistTar!$H$100:$H$120,C$33)","v":406714.755},{"$f":"INDEX(Prop2022DistTar!$H$100:$H$120,D$33)","v":324231.08491889999},{"$f":"INDEX(Prop2022DistTar!$H$100:$H$120,E$33)","v":180459.53205959997},{"$f":"INDEX(Prop2022DistTar!$H$100:$H$120,F$33)","v":103239.52320682},{"$f":"INDEX(Prop2022DistTar!$H$100:$H$120,G$33)","v":111039.74831040001},{"$f":"INDEX(Prop2022DistTar!$H$100:$H$120,H$33)","v":93506.265639540012},{"$f":"INDEX(Prop2022DistTar!$H$100:$H$120,I$33)","v":79224.380787090005},{"$f":"INDEX(Prop2022DistTar!$H$100:$H$120,J$33)","v":42364.338400799999},{"$f":"INDEX(Prop2022DistTar!$H$100:$H$120,K$33)","v":22564.27536},{"$f":"INDEX(Prop2022DistTar!$H$100:$H$120,L$33)","v":20076.242941299999},{"$f":"INDEX(Prop2022DistTar!$H$100:$H$120,M$33)","v":12060.460897999999},{"$f":"INDEX(Prop2022DistTar!$H$100:$H$120,N$33)","v":70509.196634799999},{"$f":"INDEX(Prop2022DistTar!$H$100:$H$120,O$33)","v":27328.211590200001},{"$f":"INDEX(Prop2022DistTar!$H$100:$H$120,P$33)","v":10184.215569},{"$f":"INDEX(Prop2022DistTar!$H$100:$H$120,Q$33)","v":6458.7720799000008},{"$f":"INDEX(Prop2022DistTar!$H$100:$H$120,R$33)","v":4781.8026920000002},{"$f":"INDEX(Prop2022DistTar!$H$100:$H$120,S$33)","v":302714.32045860001},{"$f":"INDEX(Prop2022DistTar!$H$100:$H$120,T$33)","v":74487.778848560003},{"$f":"INDEX(Prop2022DistTar!$H$100:$H$120,U$33)","v":25656.8482492},{"$f":"INDEX(Prop2022DistTar!$H$100:$H$120,V$33)","v":18008.0471655},{"$f":"INDEX(Prop2022DistTar!$H$100:$H$120,W$33)","v":16941.676847999999}]
[]
[null,{"$f":"B104","v":"Proposed (1 Jan-31 Dec): Tariff V - South Gippsland Residential"},{"$f":"INDEX(Prop2022DistTar!$G$100:$G$120,C$32)","v":406714.755},{"$f":"INDEX(Prop2022DistTar!$G$100:$G$120,D$32)","v":351122.96238119999},{"$f":"INDEX(Prop2022DistTar!$G$100:$G$120,E$32)","v":195427.72106789998},{"$f":"INDEX(Prop2022DistTar!$G$100:$G$120,F$32)","v":103239.52320682},{"$f":"INDEX(Prop2022DistTar!$G$100:$G$120,G$32)","v":111039.74831040001},{"$f":"INDEX(Prop2022DistTar!$G$100:$G$120,H$32)","v":93506.265639540012},{"$f":"INDEX(Prop2022DistTar!$G$100:$G$120,I$32)","v":85795.896661710009},{"$f":"INDEX(Prop2022DistTar!$G$100:$G$120,J$32)","v":45878.180353200005},{"$f":"INDEX(Prop2022DistTar!$G$100:$G$120,K$32)","v":22564.27536},{"$f":"INDEX(Prop2022DistTar!$G$100:$G$120,L$32)","v":20076.242941299999},{"$f":"INDEX(Prop2022DistTar!$G$100:$G$120,M$32)","v":12060.460897999999},{"$f":"INDEX(Prop2022DistTar!$G$100:$G$120,N$32)","v":76357.804101200003},{"$f":"INDEX(Prop2022DistTar!$G$100:$G$120,O$32)","v":29594.906173300002},{"$f":"INDEX(Prop2022DistTar!$G$100:$G$120,P$32)","v":10184.215569},{"$f":"INDEX(Prop2022DistTar!$G$100:$G$120,Q$32)","v":6458.7720799000008},{"$f":"INDEX(Prop2022DistTar!$G$100:$G$120,R$32)","v":4781.8026920000002},{"$f":"INDEX(Prop2022DistTar!$G$100:$G$120,S$32)","v":327821.31049499998},{"$f":"INDEX(Prop2022DistTar!$G$100:$G$120,T$32)","v":80665.967778660008},{"$f":"INDEX(Prop2022DistTar!$G$100:$G$120,U$32)","v":25656.8482492},{"$f":"INDEX(Prop2022DistTar!$G$100:$G$120,V$32)","v":18008.0471655},{"$f":"INDEX(Prop2022DistTar!$G$100:$G$120,W$32)","v":16941.676847999999}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B108","v":"Existing (1 Jan-31 Dec): Tariff V - South Gippsland Residential"},{"$f":"SUM(C108:W108)","v":1952551.4776582101}]
[null,{"$f":"B110","v":"Proposed (1 Jan-31 Dec): Tariff V - South Gippsland Residential"},{"$f":"SUM(C110:W110)","v":2043897.38297183}]
[]
[null,"Average price movement",{"$f":"IF(C114=0,\"\",C114/C113)","v":1.0467828409948892}]
[]
[null,{"$f":"IF(C116=\"\",\"\",IF(C116<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!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): \"&Prop2022DistTar!C29","v":"Existing (1 Jan - 31 Dec): Tariff V - Multinet Non-Residential"},{"$f":"INDEX(Prop2022DistTar!$E$31:$E$51,C$33)","v":0.30180000000000001},{"$f":"INDEX(Prop2022DistTar!$E$31:$E$51,D$33)","v":4.0556000000000001},{"$f":"INDEX(Prop2022DistTar!$E$31:$E$51,E$33)","v":2.3485999999999998},{"$f":"INDEX(Prop2022DistTar!$E$31:$E$51,F$33)","v":1.4092},{"$f":"INDEX(Prop2022DistTar!$E$31:$E$51,G$33)","v":0.78420000000000001},{"$f":"INDEX(Prop2022DistTar!$E$31:$E$51,H$33)","v":0.26169999999999999},{"$f":"INDEX(Prop2022DistTar!$E$31:$E$51,I$33)","v":3.722},{"$f":"INDEX(Prop2022DistTar!$E$31:$E$51,J$33)","v":2.1139000000000001},{"$f":"INDEX(Prop2022DistTar!$E$31:$E$51,K$33)","v":1.3387},{"$f":"INDEX(Prop2022DistTar!$E$31:$E$51,L$33)","v":0.7641},{"$f":"INDEX(Prop2022DistTar!$E$31:$E$51,M$33)","v":0.23530000000000001},{"$f":"INDEX(Prop2022DistTar!$E$31:$E$51,N$33)","v":3.722},{"$f":"INDEX(Prop2022DistTar!$E$31:$E$51,O$33)","v":2.1139000000000001},{"$f":"INDEX(Prop2022DistTar!$E$31:$E$51,P$33)","v":1.3387},{"$f":"INDEX(Prop2022DistTar!$E$31:$E$51,Q$33)","v":0.7641},{"$f":"INDEX(Prop2022DistTar!$E$31:$E$51,R$33)","v":0.23530000000000001},{"$f":"INDEX(Prop2022DistTar!$E$31:$E$51,S$33)","v":3.3755999999999999},{"$f":"INDEX(Prop2022DistTar!$E$31:$E$51,T$33)","v":2.0411000000000001},{"$f":"INDEX(Prop2022DistTar!$E$31:$E$51,U$33)","v":1.2218},{"$f":"INDEX(Prop2022DistTar!$E$31:$E$51,V$33)","v":0.74039999999999995},{"$f":"INDEX(Prop2022DistTar!$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(Prop2022DistTar!$D$31:$D$51,C$32)","v":0.30180000000000001},{"$f":"INDEX(Prop2022DistTar!$D$31:$D$51,D$32)","v":4.3920000000000003},{"$f":"INDEX(Prop2022DistTar!$D$31:$D$51,E$32)","v":2.5434000000000001},{"$f":"INDEX(Prop2022DistTar!$D$31:$D$51,F$32)","v":1.4092},{"$f":"INDEX(Prop2022DistTar!$D$31:$D$51,G$32)","v":0.78420000000000001},{"$f":"INDEX(Prop2022DistTar!$D$31:$D$51,H$32)","v":0.26169999999999999},{"$f":"INDEX(Prop2022DistTar!$D$31:$D$51,I$32)","v":4.0307000000000004},{"$f":"INDEX(Prop2022DistTar!$D$31:$D$51,J$32)","v":2.2892000000000001},{"$f":"INDEX(Prop2022DistTar!$D$31:$D$51,K$32)","v":1.3387},{"$f":"INDEX(Prop2022DistTar!$D$31:$D$51,L$32)","v":0.7641},{"$f":"INDEX(Prop2022DistTar!$D$31:$D$51,M$32)","v":0.23530000000000001},{"$f":"INDEX(Prop2022DistTar!$D$31:$D$51,N$32)","v":4.0307000000000004},{"$f":"INDEX(Prop2022DistTar!$D$31:$D$51,O$32)","v":2.2892000000000001},{"$f":"INDEX(Prop2022DistTar!$D$31:$D$51,P$32)","v":1.3387},{"$f":"INDEX(Prop2022DistTar!$D$31:$D$51,Q$32)","v":0.7641},{"$f":"INDEX(Prop2022DistTar!$D$31:$D$51,R$32)","v":0.23530000000000001},{"$f":"INDEX(Prop2022DistTar!$D$31:$D$51,S$32)","v":3.6556000000000002},{"$f":"INDEX(Prop2022DistTar!$D$31:$D$51,T$32)","v":2.2103999999999999},{"$f":"INDEX(Prop2022DistTar!$D$31:$D$51,U$32)","v":1.2218},{"$f":"INDEX(Prop2022DistTar!$D$31:$D$51,V$32)","v":0.74039999999999995},{"$f":"INDEX(Prop2022DistTar!$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(Prop2022DistTar!$F$31:$F$51,C$32)","v":16019},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,D$32)","v":278106.35849999997},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,E$32)","v":422636.49489999999},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,F$32)","v":157292.19},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,G$32)","v":540414.17200000002},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,H$32)","v":684466.89789999998},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,I$32)","v":70320.396099999998},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,J$32)","v":104300.19289999999},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,K$32)","v":38641.798999999999},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,L$32)","v":131161.90100000001},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,M$32)","v":153575.196},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,N$32)","v":63361.862000000001},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,O$32)","v":90194.642000000007},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,P$32)","v":32912.192000000003},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,Q$32)","v":105941.144},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,R$32)","v":103108.61},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,S$32)","v":350814.5931},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,T$32)","v":514448.6151},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,U$32)","v":189200.50409999999},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,V$32)","v":566251.08810000005},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,W$32)","v":470692.54009999998}]
[]
[null,{"$f":"B128","v":"Proposed (1 Jan-31 Dec): Tariff V - Multinet Non-Residential"},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,C$32)","v":16019},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,D$32)","v":278106.35849999997},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,E$32)","v":422636.49489999999},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,F$32)","v":157292.19},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,G$32)","v":540414.17200000002},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,H$32)","v":684466.89789999998},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,I$32)","v":70320.396099999998},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,J$32)","v":104300.19289999999},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,K$32)","v":38641.798999999999},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,L$32)","v":131161.90100000001},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,M$32)","v":153575.196},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,N$32)","v":63361.862000000001},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,O$32)","v":90194.642000000007},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,P$32)","v":32912.192000000003},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,Q$32)","v":105941.144},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,R$32)","v":103108.61},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,S$32)","v":350814.5931},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,T$32)","v":514448.6151},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,U$32)","v":189200.50409999999},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,V$32)","v":566251.08810000005},{"$f":"INDEX(Prop2022DistTar!$F$31:$F$51,W$32)","v":470692.54009999998}]
[]
[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(Prop2022DistTar!$H$31:$H$51,C$33)","v":1764604.983},{"$f":"INDEX(Prop2022DistTar!$H$31:$H$51,D$33)","v":1127888.1475326},{"$f":"INDEX(Prop2022DistTar!$H$31:$H$51,E$33)","v":992604.07192213985},{"$f":"INDEX(Prop2022DistTar!$H$31:$H$51,F$33)","v":221656.154148},{"$f":"INDEX(Prop2022DistTar!$H$31:$H$51,G$33)","v":423792.79368240002},{"$f":"INDEX(Prop2022DistTar!$H$31:$H$51,H$33)","v":179124.98718042998},{"$f":"INDEX(Prop2022DistTar!$H$31:$H$51,I$33)","v":261732.51428419998},{"$f":"INDEX(Prop2022DistTar!$H$31:$H$51,J$33)","v":220480.17777131},{"$f":"INDEX(Prop2022DistTar!$H$31:$H$51,K$33)","v":51729.7763213},{"$f":"INDEX(Prop2022DistTar!$H$31:$H$51,L$33)","v":100220.8085541},{"$f":"INDEX(Prop2022DistTar!$H$31:$H$51,M$33)","v":36136.243618799999},{"$f":"INDEX(Prop2022DistTar!$H$31:$H$51,N$33)","v":235832.85036400001},{"$f":"INDEX(Prop2022DistTar!$H$31:$H$51,O$33)","v":190662.45372380002},{"$f":"INDEX(Prop2022DistTar!$H$31:$H$51,P$33)","v":44059.551430400003},{"$f":"INDEX(Prop2022DistTar!$H$31:$H$51,Q$33)","v":80949.6281304},{"$f":"INDEX(Prop2022DistTar!$H$31:$H$51,R$33)","v":24261.455933000001},{"$f":"INDEX(Prop2022DistTar!$H$31:$H$51,S$33)","v":1184209.74046836},{"$f":"INDEX(Prop2022DistTar!$H$31:$H$51,T$33)","v":1050041.06828061},{"$f":"INDEX(Prop2022DistTar!$H$31:$H$51,U$33)","v":231165.17590937999},{"$f":"INDEX(Prop2022DistTar!$H$31:$H$51,V$33)","v":419252.30562924},{"$f":"INDEX(Prop2022DistTar!$H$31:$H$51,W$33)","v":98421.810134910003}]
[]
[null,{"$f":"B134","v":"Proposed (1 Jan-31 Dec): Tariff V - Multinet Non-Residential"},{"$f":"INDEX(Prop2022DistTar!$G$31:$G$51,C$32)","v":1764604.983},{"$f":"INDEX(Prop2022DistTar!$G$31:$G$51,D$32)","v":1221443.126532},{"$f":"INDEX(Prop2022DistTar!$G$31:$G$51,E$32)","v":1074933.66112866},{"$f":"INDEX(Prop2022DistTar!$G$31:$G$51,F$32)","v":221656.154148},{"$f":"INDEX(Prop2022DistTar!$G$31:$G$51,G$32)","v":423792.79368240002},{"$f":"INDEX(Prop2022DistTar!$G$31:$G$51,H$32)","v":179124.98718042998},{"$f":"INDEX(Prop2022DistTar!$G$31:$G$51,I$32)","v":283440.42056027002},{"$f":"INDEX(Prop2022DistTar!$G$31:$G$51,J$32)","v":238764.00158668001},{"$f":"INDEX(Prop2022DistTar!$G$31:$G$51,K$32)","v":51729.7763213},{"$f":"INDEX(Prop2022DistTar!$G$31:$G$51,L$32)","v":100220.8085541},{"$f":"INDEX(Prop2022DistTar!$G$31:$G$51,M$32)","v":36136.243618799999},{"$f":"INDEX(Prop2022DistTar!$G$31:$G$51,N$32)","v":255392.65716340003},{"$f":"INDEX(Prop2022DistTar!$G$31:$G$51,O$32)","v":206473.57446640002},{"$f":"INDEX(Prop2022DistTar!$G$31:$G$51,P$32)","v":44059.551430400003},{"$f":"INDEX(Prop2022DistTar!$G$31:$G$51,Q$32)","v":80949.6281304},{"$f":"INDEX(Prop2022DistTar!$G$31:$G$51,R$32)","v":24261.455933000001},{"$f":"INDEX(Prop2022DistTar!$G$31:$G$51,S$32)","v":1282437.82653636},{"$f":"INDEX(Prop2022DistTar!$G$31:$G$51,T$32)","v":1137137.2188170399},{"$f":"INDEX(Prop2022DistTar!$G$31:$G$51,U$32)","v":231165.17590937999},{"$f":"INDEX(Prop2022DistTar!$G$31:$G$51,V$32)","v":419252.30562924},{"$f":"INDEX(Prop2022DistTar!$G$31:$G$51,W$32)","v":98421.810134910003}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B138","v":"Existing (1 Jan - 31 Dec): Tariff V - Multinet Non-Residential"},{"$f":"SUM(C137:W138)","v":8938826.6980193816}]
[null,{"$f":"B140","v":"Proposed (1 Jan-31 Dec): Tariff V - Multinet Non-Residential"},{"$f":"SUM(C139:W140)","v":9375398.1604631711}]
[]
[null,"Average price movement",{"$f":"IF(C144=0,\"\",C144/C143)","v":1.0488399067565011}]
[]
[null,{"$f":"IF(C146=\"\",\"\",IF(C146<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!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): \"&Prop2022DistTar!C75","v":"Existing (1 Jan - 31 Dec): Tariff V - Yarra Valley Non-Residential"},{"$f":"INDEX(Prop2022DistTar!$E$77:$E$97,C$33)","v":0.3004},{"$f":"INDEX(Prop2022DistTar!$E$77:$E$97,D$33)","v":6.8071999999999999},{"$f":"INDEX(Prop2022DistTar!$E$77:$E$97,E$33)","v":5.1199000000000003},{"$f":"INDEX(Prop2022DistTar!$E$77:$E$97,F$33)","v":4.3555000000000001},{"$f":"INDEX(Prop2022DistTar!$E$77:$E$97,G$33)","v":3.8468},{"$f":"INDEX(Prop2022DistTar!$E$77:$E$97,H$33)","v":3.4214000000000002},{"$f":"INDEX(Prop2022DistTar!$E$77:$E$97,I$33)","v":6.5354999999999999},{"$f":"INDEX(Prop2022DistTar!$E$77:$E$97,J$33)","v":4.9287999999999998},{"$f":"INDEX(Prop2022DistTar!$E$77:$E$97,K$33)","v":4.298},{"$f":"INDEX(Prop2022DistTar!$E$77:$E$97,L$33)","v":3.8304},{"$f":"INDEX(Prop2022DistTar!$E$77:$E$97,M$33)","v":3.4001000000000001},{"$f":"INDEX(Prop2022DistTar!$E$77:$E$97,N$33)","v":6.5354999999999999},{"$f":"INDEX(Prop2022DistTar!$E$77:$E$97,O$33)","v":4.9287999999999998},{"$f":"INDEX(Prop2022DistTar!$E$77:$E$97,P$33)","v":4.298},{"$f":"INDEX(Prop2022DistTar!$E$77:$E$97,Q$33)","v":3.8304},{"$f":"INDEX(Prop2022DistTar!$E$77:$E$97,R$33)","v":3.4001000000000001},{"$f":"INDEX(Prop2022DistTar!$E$77:$E$97,S$33)","v":6.2533000000000003},{"$f":"INDEX(Prop2022DistTar!$E$77:$E$97,T$33)","v":4.8697999999999997},{"$f":"INDEX(Prop2022DistTar!$E$77:$E$97,U$33)","v":4.2027999999999999},{"$f":"INDEX(Prop2022DistTar!$E$77:$E$97,V$33)","v":3.8111999999999999},{"$f":"INDEX(Prop2022DistTar!$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(Prop2022DistTar!$D$77:$D$97,C$32)","v":0.3004},{"$f":"INDEX(Prop2022DistTar!$D$77:$D$97,D$32)","v":7.3718000000000004},{"$f":"INDEX(Prop2022DistTar!$D$77:$D$97,E$32)","v":5.5446},{"$f":"INDEX(Prop2022DistTar!$D$77:$D$97,F$32)","v":4.3555000000000001},{"$f":"INDEX(Prop2022DistTar!$D$77:$D$97,G$32)","v":3.8468},{"$f":"INDEX(Prop2022DistTar!$D$77:$D$97,H$32)","v":3.4214000000000002},{"$f":"INDEX(Prop2022DistTar!$D$77:$D$97,I$32)","v":7.0776000000000003},{"$f":"INDEX(Prop2022DistTar!$D$77:$D$97,J$32)","v":5.3376000000000001},{"$f":"INDEX(Prop2022DistTar!$D$77:$D$97,K$32)","v":4.298},{"$f":"INDEX(Prop2022DistTar!$D$77:$D$97,L$32)","v":3.8304},{"$f":"INDEX(Prop2022DistTar!$D$77:$D$97,M$32)","v":3.4001000000000001},{"$f":"INDEX(Prop2022DistTar!$D$77:$D$97,N$32)","v":7.0776000000000003},{"$f":"INDEX(Prop2022DistTar!$D$77:$D$97,O$32)","v":5.3376000000000001},{"$f":"INDEX(Prop2022DistTar!$D$77:$D$97,P$32)","v":4.298},{"$f":"INDEX(Prop2022DistTar!$D$77:$D$97,Q$32)","v":3.8304},{"$f":"INDEX(Prop2022DistTar!$D$77:$D$97,R$32)","v":3.4001000000000001},{"$f":"INDEX(Prop2022DistTar!$D$77:$D$97,S$32)","v":6.7720000000000002},{"$f":"INDEX(Prop2022DistTar!$D$77:$D$97,T$32)","v":5.2736999999999998},{"$f":"INDEX(Prop2022DistTar!$D$77:$D$97,U$32)","v":4.2027999999999999},{"$f":"INDEX(Prop2022DistTar!$D$77:$D$97,V$32)","v":3.8111999999999999},{"$f":"INDEX(Prop2022DistTar!$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(Prop2022DistTar!$F$77:$F$97,C$32)","v":71},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,D$32)","v":1439.9670000000001},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,E$32)","v":1829.8040000000001},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,F$32)","v":507.56799999999998},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,G$32)","v":1473.808},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,H$32)","v":4175.2089999999998},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,I$32)","v":362.35399999999998},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,J$32)","v":480.12599999999998},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,K$32)","v":128.13499999999999},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,L$32)","v":362.267},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,M$32)","v":1026.586},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,N$32)","v":330.99299999999999},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,O$32)","v":381.01400000000001},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,P$32)","v":86.653999999999996},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,Q$32)","v":248.749},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,R$32)","v":588.96699999999998},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,S$32)","v":1803.521},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,T$32)","v":2078.2739999999999},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,U$32)","v":396.327},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,V$32)","v":1604.8420000000001},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,W$32)","v":2332.5140000000001}]
[]
[null,{"$f":"B158","v":"Proposed (1 Jan-31 Dec): Tariff V - Yarra Valley Non-Residential"},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,C$32)","v":71},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,D$32)","v":1439.9670000000001},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,E$32)","v":1829.8040000000001},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,F$32)","v":507.56799999999998},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,G$32)","v":1473.808},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,H$32)","v":4175.2089999999998},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,I$32)","v":362.35399999999998},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,J$32)","v":480.12599999999998},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,K$32)","v":128.13499999999999},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,L$32)","v":362.267},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,M$32)","v":1026.586},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,N$32)","v":330.99299999999999},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,O$32)","v":381.01400000000001},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,P$32)","v":86.653999999999996},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,Q$32)","v":248.749},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,R$32)","v":588.96699999999998},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,S$32)","v":1803.521},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,T$32)","v":2078.2739999999999},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,U$32)","v":396.327},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,V$32)","v":1604.8420000000001},{"$f":"INDEX(Prop2022DistTar!$F$77:$F$97,W$32)","v":2332.5140000000001}]
[]
[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(Prop2022DistTar!$H$77:$H$97,C$33)","v":7784.8659999999991},{"$f":"INDEX(Prop2022DistTar!$H$77:$H$97,D$33)","v":9802.1433624000001},{"$f":"INDEX(Prop2022DistTar!$H$77:$H$97,E$33)","v":9368.4134996000012},{"$f":"INDEX(Prop2022DistTar!$H$77:$H$97,F$33)","v":2210.7124239999998},{"$f":"INDEX(Prop2022DistTar!$H$77:$H$97,G$33)","v":5669.4446144000003},{"$f":"INDEX(Prop2022DistTar!$H$77:$H$97,H$33)","v":14285.060072600001},{"$f":"INDEX(Prop2022DistTar!$H$77:$H$97,I$33)","v":2368.1645669999998},{"$f":"INDEX(Prop2022DistTar!$H$77:$H$97,J$33)","v":2366.4450287999998},{"$f":"INDEX(Prop2022DistTar!$H$77:$H$97,K$33)","v":550.72422999999992},{"$f":"INDEX(Prop2022DistTar!$H$77:$H$97,L$33)","v":1387.6275168},{"$f":"INDEX(Prop2022DistTar!$H$77:$H$97,M$33)","v":3490.4950586},{"$f":"INDEX(Prop2022DistTar!$H$77:$H$97,N$33)","v":2163.2047514999999},{"$f":"INDEX(Prop2022DistTar!$H$77:$H$97,O$33)","v":1877.9418032000001},{"$f":"INDEX(Prop2022DistTar!$H$77:$H$97,P$33)","v":372.43889200000001},{"$f":"INDEX(Prop2022DistTar!$H$77:$H$97,Q$33)","v":952.80816960000004},{"$f":"INDEX(Prop2022DistTar!$H$77:$H$97,R$33)","v":2002.5466967},{"$f":"INDEX(Prop2022DistTar!$H$77:$H$97,S$33)","v":11277.9578693},{"$f":"INDEX(Prop2022DistTar!$H$77:$H$97,T$33)","v":10120.778725199998},{"$f":"INDEX(Prop2022DistTar!$H$77:$H$97,U$33)","v":1665.6831155999998},{"$f":"INDEX(Prop2022DistTar!$H$77:$H$97,V$33)","v":6116.3738303999999},{"$f":"INDEX(Prop2022DistTar!$H$77:$H$97,W$33)","v":7880.8650518000004}]
[]
[null,{"$f":"B164","v":"Proposed (1 Jan-31 Dec): Tariff V - Yarra Valley Non-Residential"},{"$f":"INDEX(Prop2022DistTar!$G$77:$G$97,C$32)","v":7784.8659999999991},{"$f":"INDEX(Prop2022DistTar!$G$77:$G$97,D$32)","v":10615.148730600002},{"$f":"INDEX(Prop2022DistTar!$G$77:$G$97,E$32)","v":10145.5312584},{"$f":"INDEX(Prop2022DistTar!$G$77:$G$97,F$32)","v":2210.7124239999998},{"$f":"INDEX(Prop2022DistTar!$G$77:$G$97,G$32)","v":5669.4446144000003},{"$f":"INDEX(Prop2022DistTar!$G$77:$G$97,H$32)","v":14285.060072600001},{"$f":"INDEX(Prop2022DistTar!$G$77:$G$97,I$32)","v":2564.5966704000002},{"$f":"INDEX(Prop2022DistTar!$G$77:$G$97,J$32)","v":2562.7205375999997},{"$f":"INDEX(Prop2022DistTar!$G$77:$G$97,K$32)","v":550.72422999999992},{"$f":"INDEX(Prop2022DistTar!$G$77:$G$97,L$32)","v":1387.6275168},{"$f":"INDEX(Prop2022DistTar!$G$77:$G$97,M$32)","v":3490.4950586},{"$f":"INDEX(Prop2022DistTar!$G$77:$G$97,N$32)","v":2342.6360568},{"$f":"INDEX(Prop2022DistTar!$G$77:$G$97,O$32)","v":2033.7003264},{"$f":"INDEX(Prop2022DistTar!$G$77:$G$97,P$32)","v":372.43889200000001},{"$f":"INDEX(Prop2022DistTar!$G$77:$G$97,Q$32)","v":952.80816960000004},{"$f":"INDEX(Prop2022DistTar!$G$77:$G$97,R$32)","v":2002.5466967},{"$f":"INDEX(Prop2022DistTar!$G$77:$G$97,S$32)","v":12213.444212},{"$f":"INDEX(Prop2022DistTar!$G$77:$G$97,T$32)","v":10960.193593799999},{"$f":"INDEX(Prop2022DistTar!$G$77:$G$97,U$32)","v":1665.6831155999998},{"$f":"INDEX(Prop2022DistTar!$G$77:$G$97,V$32)","v":6116.3738303999999},{"$f":"INDEX(Prop2022DistTar!$G$77:$G$97,W$32)","v":7880.8650518000004}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B168","v":"Existing (1 Jan - 31 Dec): Tariff V - Yarra Valley Non-Residential"},{"$f":"SUM(C167:W168)","v":103714.6952795}]
[null,{"$f":"B170","v":"Proposed (1 Jan-31 Dec): Tariff V - Yarra Valley Non-Residential"},{"$f":"SUM(C169:W170)","v":107807.61705849999}]
[]
[null,"Average price movement",{"$f":"IF(C174=0,\"\",C174/C173)","v":1.0394632772913233}]
[]
[null,{"$f":"IF(C176=\"\",\"\",IF(C176<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!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): \"&Prop2022DistTar!C121","v":"Existing (1 Jan - 31 Dec): Tariff V - South Gippsland Non-Residential"},{"$f":"INDEX(Prop2022DistTar!$E$123:$E$143,C$33)","v":0.30180000000000001},{"$f":"INDEX(Prop2022DistTar!$E$123:$E$143,D$33)","v":7.508},{"$f":"INDEX(Prop2022DistTar!$E$123:$E$143,E$33)","v":5.6927000000000003},{"$f":"INDEX(Prop2022DistTar!$E$123:$E$143,F$33)","v":4.8807},{"$f":"INDEX(Prop2022DistTar!$E$123:$E$143,G$33)","v":4.3407999999999998},{"$f":"INDEX(Prop2022DistTar!$E$123:$E$143,H$33)","v":3.8889999999999998},{"$f":"INDEX(Prop2022DistTar!$E$123:$E$143,I$33)","v":7.2195999999999998},{"$f":"INDEX(Prop2022DistTar!$E$123:$E$143,J$33)","v":5.4896000000000003},{"$f":"INDEX(Prop2022DistTar!$E$123:$E$143,K$33)","v":4.8198999999999996},{"$f":"INDEX(Prop2022DistTar!$E$123:$E$143,L$33)","v":4.3231999999999999},{"$f":"INDEX(Prop2022DistTar!$E$123:$E$143,M$33)","v":3.8662000000000001},{"$f":"INDEX(Prop2022DistTar!$E$123:$E$143,N$33)","v":7.2195999999999998},{"$f":"INDEX(Prop2022DistTar!$E$123:$E$143,O$33)","v":5.4896000000000003},{"$f":"INDEX(Prop2022DistTar!$E$123:$E$143,P$33)","v":4.8198999999999996},{"$f":"INDEX(Prop2022DistTar!$E$123:$E$143,Q$33)","v":4.3231999999999999},{"$f":"INDEX(Prop2022DistTar!$E$123:$E$143,R$33)","v":3.8662000000000001},{"$f":"INDEX(Prop2022DistTar!$E$123:$E$143,S$33)","v":6.9200999999999997},{"$f":"INDEX(Prop2022DistTar!$E$123:$E$143,T$33)","v":5.4268999999999998},{"$f":"INDEX(Prop2022DistTar!$E$123:$E$143,U$33)","v":4.7186000000000003},{"$f":"INDEX(Prop2022DistTar!$E$123:$E$143,V$33)","v":4.3028000000000004},{"$f":"INDEX(Prop2022DistTar!$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(Prop2022DistTar!$D$123:$D$143,C$32)","v":0.30180000000000001},{"$f":"INDEX(Prop2022DistTar!$D$123:$D$143,D$32)","v":8.1306999999999992},{"$f":"INDEX(Prop2022DistTar!$D$123:$D$143,E$32)","v":6.1649000000000003},{"$f":"INDEX(Prop2022DistTar!$D$123:$D$143,F$32)","v":4.8807},{"$f":"INDEX(Prop2022DistTar!$D$123:$D$143,G$32)","v":4.3407999999999998},{"$f":"INDEX(Prop2022DistTar!$D$123:$D$143,H$32)","v":3.8889999999999998},{"$f":"INDEX(Prop2022DistTar!$D$123:$D$143,I$32)","v":7.8183999999999996},{"$f":"INDEX(Prop2022DistTar!$D$123:$D$143,J$32)","v":5.9448999999999996},{"$f":"INDEX(Prop2022DistTar!$D$123:$D$143,K$32)","v":4.8198999999999996},{"$f":"INDEX(Prop2022DistTar!$D$123:$D$143,L$32)","v":4.3231999999999999},{"$f":"INDEX(Prop2022DistTar!$D$123:$D$143,M$32)","v":3.8662000000000001},{"$f":"INDEX(Prop2022DistTar!$D$123:$D$143,N$32)","v":7.8183999999999996},{"$f":"INDEX(Prop2022DistTar!$D$123:$D$143,O$32)","v":5.9448999999999996},{"$f":"INDEX(Prop2022DistTar!$D$123:$D$143,P$32)","v":4.8198999999999996},{"$f":"INDEX(Prop2022DistTar!$D$123:$D$143,Q$32)","v":4.3231999999999999},{"$f":"INDEX(Prop2022DistTar!$D$123:$D$143,R$32)","v":3.8662000000000001},{"$f":"INDEX(Prop2022DistTar!$D$123:$D$143,S$32)","v":7.4941000000000004},{"$f":"INDEX(Prop2022DistTar!$D$123:$D$143,T$32)","v":5.8769999999999998},{"$f":"INDEX(Prop2022DistTar!$D$123:$D$143,U$32)","v":4.7186000000000003},{"$f":"INDEX(Prop2022DistTar!$D$123:$D$143,V$32)","v":4.3028000000000004},{"$f":"INDEX(Prop2022DistTar!$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(Prop2022DistTar!$F$123:$F$143,C$32)","v":118},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,D$32)","v":2452.1869999999999},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,E$32)","v":4544.4889999999996},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,F$32)","v":1929.5840000000001},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,G$32)","v":7929.1130000000003},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,H$32)","v":11791.799000000001},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,I$32)","v":586.50400000000002},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,J$32)","v":1023.1079999999999},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,K$32)","v":424.142},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,L$32)","v":1865.4110000000001},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,M$32)","v":2087.732},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,N$32)","v":563.32100000000003},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,O$32)","v":1039.076},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,P$32)","v":427.29199999999997},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,Q$32)","v":1759.251},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,R$32)","v":2222.7669999999998},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,S$32)","v":3063.13},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,T$32)","v":5807.8980000000001},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,U$32)","v":2613.9609999999998},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,V$32)","v":10002.494000000001},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,W$32)","v":10375.370000000001}]
[]
[null,{"$f":"B188","v":"Proposed (1 Jan-31 Dec): Tariff V - South Gippsland Non-Residential"},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,C$32)","v":118},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,D$32)","v":2452.1869999999999},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,E$32)","v":4544.4889999999996},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,F$32)","v":1929.5840000000001},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,G$32)","v":7929.1130000000003},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,H$32)","v":11791.799000000001},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,I$32)","v":586.50400000000002},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,J$32)","v":1023.1079999999999},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,K$32)","v":424.142},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,L$32)","v":1865.4110000000001},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,M$32)","v":2087.732},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,N$32)","v":563.32100000000003},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,O$32)","v":1039.076},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,P$32)","v":427.29199999999997},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,Q$32)","v":1759.251},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,R$32)","v":2222.7669999999998},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,S$32)","v":3063.13},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,T$32)","v":5807.8980000000001},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,U$32)","v":2613.9609999999998},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,V$32)","v":10002.494000000001},{"$f":"INDEX(Prop2022DistTar!$F$123:$F$143,W$32)","v":10375.370000000001}]
[]
[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(Prop2022DistTar!$H$123:$H$143,C$33)","v":12998.526},{"$f":"INDEX(Prop2022DistTar!$H$123:$H$143,D$33)","v":18411.019995999999},{"$f":"INDEX(Prop2022DistTar!$H$123:$H$143,E$33)","v":25870.4125303},{"$f":"INDEX(Prop2022DistTar!$H$123:$H$143,F$33)","v":9417.7206287999998},{"$f":"INDEX(Prop2022DistTar!$H$123:$H$143,G$33)","v":34418.693710400003},{"$f":"INDEX(Prop2022DistTar!$H$123:$H$143,H$33)","v":45858.306311},{"$f":"INDEX(Prop2022DistTar!$H$123:$H$143,I$33)","v":4234.3242784000004},{"$f":"INDEX(Prop2022DistTar!$H$123:$H$143,J$33)","v":5616.4536767999998},{"$f":"INDEX(Prop2022DistTar!$H$123:$H$143,K$33)","v":2044.3220257999999},{"$f":"INDEX(Prop2022DistTar!$H$123:$H$143,L$33)","v":8064.5448352000003},{"$f":"INDEX(Prop2022DistTar!$H$123:$H$143,M$33)","v":8071.5894583999998},{"$f":"INDEX(Prop2022DistTar!$H$123:$H$143,N$33)","v":4066.9522916000001},{"$f":"INDEX(Prop2022DistTar!$H$123:$H$143,O$33)","v":5704.1116096000005},{"$f":"INDEX(Prop2022DistTar!$H$123:$H$143,P$33)","v":2059.5047107999999},{"$f":"INDEX(Prop2022DistTar!$H$123:$H$143,Q$33)","v":7605.5939232000001},{"$f":"INDEX(Prop2022DistTar!$H$123:$H$143,R$33)","v":8593.6617753999999},{"$f":"INDEX(Prop2022DistTar!$H$123:$H$143,S$33)","v":21197.165913000001},{"$f":"INDEX(Prop2022DistTar!$H$123:$H$143,T$33)","v":31518.881656199999},{"$f":"INDEX(Prop2022DistTar!$H$123:$H$143,U$33)","v":12334.236374599999},{"$f":"INDEX(Prop2022DistTar!$H$123:$H$143,V$33)","v":43038.731183200005},{"$f":"INDEX(Prop2022DistTar!$H$123:$H$143,W$33)","v":39878.772132000006}]
[]
[null,{"$f":"B194","v":"Proposed (1 Jan-31 Dec): Tariff V - South Gippsland Non-Residential"},{"$f":"INDEX(Prop2022DistTar!$G$123:$G$143,C$32)","v":12998.526},{"$f":"INDEX(Prop2022DistTar!$G$123:$G$143,D$32)","v":19937.996840899996},{"$f":"INDEX(Prop2022DistTar!$G$123:$G$143,E$32)","v":28016.3202361},{"$f":"INDEX(Prop2022DistTar!$G$123:$G$143,F$32)","v":9417.7206287999998},{"$f":"INDEX(Prop2022DistTar!$G$123:$G$143,G$32)","v":34418.693710400003},{"$f":"INDEX(Prop2022DistTar!$G$123:$G$143,H$32)","v":45858.306311},{"$f":"INDEX(Prop2022DistTar!$G$123:$G$143,I$32)","v":4585.5228735999999},{"$f":"INDEX(Prop2022DistTar!$G$123:$G$143,J$32)","v":6082.274749199999},{"$f":"INDEX(Prop2022DistTar!$G$123:$G$143,K$32)","v":2044.3220257999999},{"$f":"INDEX(Prop2022DistTar!$G$123:$G$143,L$32)","v":8064.5448352000003},{"$f":"INDEX(Prop2022DistTar!$G$123:$G$143,M$32)","v":8071.5894583999998},{"$f":"INDEX(Prop2022DistTar!$G$123:$G$143,N$32)","v":4404.2689063999997},{"$f":"INDEX(Prop2022DistTar!$G$123:$G$143,O$32)","v":6177.2029124000001},{"$f":"INDEX(Prop2022DistTar!$G$123:$G$143,P$32)","v":2059.5047107999999},{"$f":"INDEX(Prop2022DistTar!$G$123:$G$143,Q$32)","v":7605.5939232000001},{"$f":"INDEX(Prop2022DistTar!$G$123:$G$143,R$32)","v":8593.6617753999999},{"$f":"INDEX(Prop2022DistTar!$G$123:$G$143,S$32)","v":22955.402533},{"$f":"INDEX(Prop2022DistTar!$G$123:$G$143,T$32)","v":34133.016545999999},{"$f":"INDEX(Prop2022DistTar!$G$123:$G$143,U$32)","v":12334.236374599999},{"$f":"INDEX(Prop2022DistTar!$G$123:$G$143,V$32)","v":43038.731183200005},{"$f":"INDEX(Prop2022DistTar!$G$123:$G$143,W$32)","v":39878.772132000006}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B198","v":"Existing (1 Jan - 31 Dec): Tariff V - South Gippsland Non-Residential"},{"$f":"SUM(C197:W198)","v":351003.52502070006}]
[null,{"$f":"B200","v":"Proposed (1 Jan-31 Dec): Tariff V - South Gippsland Non-Residential"},{"$f":"SUM(C199:W200)","v":360676.20866640011}]
[]
[null,"Average price movement",{"$f":"IF(C204=0,\"\",C204/C203)","v":1.0275572265125532}]
[]
[null,{"$f":"IF(C206=\"\",\"\",IF(C206<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!B145","v":"Tariff D - Multinet"}]
[null,null,1,2]
[null,"Distribution tariff","DemBlk1","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2022DistTar!C145","v":"Existing: Tariff D - Multinet"},{"$f":"INDEX(Prop2022DistTar!$E$146:$E$147,C213)","v":598.92169999999999},{"$f":"INDEX(Prop2022DistTar!$E$146:$E$147,D213)","v":101.9014}]
[null,{"$f":"\"Proposed: \"&B212","v":"Proposed: Tariff D - Multinet"},{"$f":"INDEX(Prop2022DistTar!$D$146:$D$147,C213)","v":621.90899999999999},{"$f":"INDEX(Prop2022DistTar!$D$146:$D$147,D213)","v":105.8207}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2"]
[null,{"$f":"B215","v":"Existing: Tariff D - Multinet"},{"$f":"INDEX(Prop2022DistTar!$F$146:$F$147,C$213)","v":2886.22},{"$f":"INDEX(Prop2022DistTar!$F$146:$F$147,D$213)","v":452.51}]
[null,{"$f":"B216","v":"Proposed: Tariff D - Multinet"},{"$f":"INDEX(Prop2022DistTar!$F$146:$F$147,C$213)","v":2886.22},{"$f":"INDEX(Prop2022DistTar!$F$146:$F$147,D$213)","v":452.51}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2"]
[null,{"$f":"B219","v":"Existing: Tariff D - Multinet"},{"$f":"INDEX(Prop2022DistTar!$H$146:$H$147,C213)","v":1728619.7889739999},{"$f":"INDEX(Prop2022DistTar!$H$146:$H$147,D213)","v":46111.402513999994}]
[null,{"$f":"B220","v":"Proposed: Tariff D - Multinet"},{"$f":"INDEX(Prop2022DistTar!$G$146:$G$147,C213)","v":1794966.1939799997},{"$f":"INDEX(Prop2022DistTar!$G$146:$G$147,D213)","v":47884.924957000003}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B223","v":"Existing: Tariff D - Multinet"},{"$f":"SUM(C223:D223)","v":1774731.1914879999}]
[null,{"$f":"B224","v":"Proposed: Tariff D - Multinet"},{"$f":"SUM(C224:D224)","v":1842851.1189369997}]
[]
[null,"Average price movement",{"$f":"IF(C228=0,\"\",C228/C227)","v":1.0383832367266197}]
[]
[null,{"$f":"IF(C230=\"\",\"\",IF(C230<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[null,{"$f":"Prop2022DistTar!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): \"&Prop2022DistTar!C149","v":"Existing (1 Jan - 31 Dec): Tariff  L- Multinet Non-Residential"},{"$f":"INDEX(Prop2022DistTar!$E$151:$E$162,C$33)","v":0},{"$f":"INDEX(Prop2022DistTar!$E$151:$E$162,D$33)","v":0.64159999999999995},{"$f":"INDEX(Prop2022DistTar!$E$151:$E$162,E$33)","v":0.1376},{"$f":"INDEX(Prop2022DistTar!$E$151:$E$162,F$33)","v":0.56879999999999997},{"$f":"INDEX(Prop2022DistTar!$E$151:$E$162,G$33)","v":0.12920000000000001},{"$f":"INDEX(Prop2022DistTar!$E$151:$E$162,H$33)","v":0.56879999999999997},{"$f":"INDEX(Prop2022DistTar!$E$151:$E$162,I$33)","v":0.12920000000000001},{"$f":"INDEX(Prop2022DistTar!$E$151:$E$162,J$33)","v":0.45100000000000001},{"$f":"INDEX(Prop2022DistTar!$E$151:$E$162,K$33)","v":0.1026},{"$f":"INDEX(Prop2022DistTar!$E$151:$E$162,L$33)","v":0},{"$f":"INDEX(Prop2022DistTar!$E$151:$E$162,M$33)","v":0.59650000000000003},{"$f":"INDEX(Prop2022DistTar!$E$151:$E$162,N$33)","v":1.7846}]
[]
[null,{"$f":"\"Proposed (1 Jan-31 Dec): \"&B235","v":"Proposed (1 Jan-31 Dec): Tariff  L- Multinet Non-Residential"},{"$f":"INDEX(Prop2022DistTar!$D$151:$D$162,C$33)","v":0},{"$f":"INDEX(Prop2022DistTar!$D$151:$D$162,D$33)","v":0.64159999999999995},{"$f":"INDEX(Prop2022DistTar!$D$151:$D$162,E$33)","v":0.1376},{"$f":"INDEX(Prop2022DistTar!$D$151:$D$162,F$33)","v":0.56879999999999997},{"$f":"INDEX(Prop2022DistTar!$D$151:$D$162,G$33)","v":0.12920000000000001},{"$f":"INDEX(Prop2022DistTar!$D$151:$D$162,H$33)","v":0.56879999999999997},{"$f":"INDEX(Prop2022DistTar!$D$151:$D$162,I$33)","v":0.12920000000000001},{"$f":"INDEX(Prop2022DistTar!$D$151:$D$162,J$33)","v":0.45100000000000001},{"$f":"INDEX(Prop2022DistTar!$D$151:$D$162,K$33)","v":0.1236},{"$f":"INDEX(Prop2022DistTar!$D$151:$D$162,L$33)","v":0},{"$f":"INDEX(Prop2022DistTar!$D$151:$D$162,M$33)","v":0.59650000000000003},{"$f":"INDEX(Prop2022DistTar!$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(Prop2022DistTar!$F$151:$F$162,C$33)","v":12},{"$f":"INDEX(Prop2022DistTar!$F$151:$F$162,D$33)","v":6188.06},{"$f":"INDEX(Prop2022DistTar!$F$151:$F$162,E$33)","v":15999.67},{"$f":"INDEX(Prop2022DistTar!$F$151:$F$162,F$33)","v":1550.69},{"$f":"INDEX(Prop2022DistTar!$F$151:$F$162,G$33)","v":3335.2},{"$f":"INDEX(Prop2022DistTar!$F$151:$F$162,H$33)","v":1550.05},{"$f":"INDEX(Prop2022DistTar!$F$151:$F$162,I$33)","v":3101.96},{"$f":"INDEX(Prop2022DistTar!$F$151:$F$162,J$33)","v":8714.34},{"$f":"INDEX(Prop2022DistTar!$F$151:$F$162,K$33)","v":13148.11},{"$f":"INDEX(Prop2022DistTar!$F$151:$F$162,L$33)","v":0},{"$f":"INDEX(Prop2022DistTar!$F$151:$F$162,M$33)","v":35.799999999999997},{"$f":"INDEX(Prop2022DistTar!$F$151:$F$162,N$33)","v":25.81}]
[]
[null,{"$f":"B241","v":"Proposed (1 Jan-31 Dec): Tariff  L- Multinet Non-Residential"},{"$f":"INDEX(Prop2022DistTar!$F$151:$F$162,C$33)","v":12},{"$f":"INDEX(Prop2022DistTar!$F$151:$F$162,D$33)","v":6188.06},{"$f":"INDEX(Prop2022DistTar!$F$151:$F$162,E$33)","v":15999.67},{"$f":"INDEX(Prop2022DistTar!$F$151:$F$162,F$33)","v":1550.69},{"$f":"INDEX(Prop2022DistTar!$F$151:$F$162,G$33)","v":3335.2},{"$f":"INDEX(Prop2022DistTar!$F$151:$F$162,H$33)","v":1550.05},{"$f":"INDEX(Prop2022DistTar!$F$151:$F$162,I$33)","v":3101.96},{"$f":"INDEX(Prop2022DistTar!$F$151:$F$162,J$33)","v":8714.34},{"$f":"INDEX(Prop2022DistTar!$F$151:$F$162,K$33)","v":13148.11},{"$f":"INDEX(Prop2022DistTar!$F$151:$F$162,L$33)","v":0},{"$f":"INDEX(Prop2022DistTar!$F$151:$F$162,M$33)","v":35.799999999999997},{"$f":"INDEX(Prop2022DistTar!$F$151:$F$162,N$33)","v":25.81}]
[]
[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(Prop2022DistTar!$H$151:$H$162,C$33)","v":0},{"$f":"INDEX(Prop2022DistTar!$H$151:$H$162,D$33)","v":3970.2592959999997},{"$f":"INDEX(Prop2022DistTar!$H$151:$H$162,E$33)","v":2201.554592},{"$f":"INDEX(Prop2022DistTar!$H$151:$H$162,F$33)","v":882.03247199999998},{"$f":"INDEX(Prop2022DistTar!$H$151:$H$162,G$33)","v":430.90784000000002},{"$f":"INDEX(Prop2022DistTar!$H$151:$H$162,H$33)","v":881.66843999999992},{"$f":"INDEX(Prop2022DistTar!$H$151:$H$162,I$33)","v":400.77323200000001},{"$f":"INDEX(Prop2022DistTar!$H$151:$H$162,J$33)","v":3930.16734},{"$f":"INDEX(Prop2022DistTar!$H$151:$H$162,K$33)","v":1348.9960860000001},{"$f":"INDEX(Prop2022DistTar!$H$151:$H$162,L$33)","v":0},{"$f":"INDEX(Prop2022DistTar!$H$151:$H$162,M$33)","v":7794.4655000000002},{"$f":"INDEX(Prop2022DistTar!$H$151:$H$162,N$33)","v":5619.3841719999991}]
[]
[null,{"$f":"B247","v":"Proposed (1 Jan-31 Dec): Tariff  L- Multinet Non-Residential"},{"$f":"INDEX(Prop2022DistTar!$G$151:$G$162,C$33)","v":0},{"$f":"INDEX(Prop2022DistTar!$G$151:$G$162,D$33)","v":3970.2592959999997},{"$f":"INDEX(Prop2022DistTar!$G$151:$G$162,E$33)","v":2201.554592},{"$f":"INDEX(Prop2022DistTar!$G$151:$G$162,F$33)","v":882.03247199999998},{"$f":"INDEX(Prop2022DistTar!$G$151:$G$162,G$33)","v":430.90784000000002},{"$f":"INDEX(Prop2022DistTar!$G$151:$G$162,H$33)","v":881.66843999999992},{"$f":"INDEX(Prop2022DistTar!$G$151:$G$162,I$33)","v":400.77323200000001},{"$f":"INDEX(Prop2022DistTar!$G$151:$G$162,J$33)","v":3930.16734},{"$f":"INDEX(Prop2022DistTar!$G$151:$G$162,K$33)","v":1625.1063960000001},{"$f":"INDEX(Prop2022DistTar!$G$151:$G$162,L$33)","v":0},{"$f":"INDEX(Prop2022DistTar!$G$151:$G$162,M$33)","v":7794.4655000000002},{"$f":"INDEX(Prop2022DistTar!$G$151:$G$162,N$33)","v":5619.3841719999991}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B251","v":"Existing (1 Jan - 31 Dec): Tariff  L- Multinet Non-Residential"},{"$f":"SUM(C251:N251)","v":27460.20897}]
[null,{"$f":"B253","v":"Proposed (1 Jan-31 Dec): Tariff  L- Multinet Non-Residential"},{"$f":"SUM(C253:N253)","v":27736.319279999996}]
[]
[null,"Average price movement",{"$f":"IF(C257=0,\"\",C257/C256)","v":1.0100549238464152}]
[]
[null,{"$f":"IF(C259=\"\",\"\",IF(C259<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!B163","v":"Tariff D - Multinet South Gippsland"}]
[null,null,1,2]
[null,"Distribution tariff","DemBlk1","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2022DistTar!C163","v":"Existing: Tariff D - Multinet South Gippsland"},{"$f":"INDEX(Prop2022DistTar!$E$164:$E$165,C266)","v":647.08190000000002},{"$f":"INDEX(Prop2022DistTar!$E$164:$E$165,D266)","v":110.0889}]
[null,{"$f":"\"Proposed: \"&B265","v":"Proposed: Tariff D - Multinet South Gippsland"},{"$f":"INDEX(Prop2022DistTar!$D$164:$D$165,C266)","v":671.96969999999999},{"$f":"INDEX(Prop2022DistTar!$D$164:$D$165,D266)","v":114.3231}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2"]
[null,{"$f":"B268","v":"Existing: Tariff D - Multinet South Gippsland"},{"$f":"INDEX(Prop2022DistTar!$F$164:$F$165,C$266)","v":100},{"$f":"INDEX(Prop2022DistTar!$F$164:$F$165,D$266)","v":62.2}]
[null,{"$f":"B269","v":"Proposed: Tariff D - Multinet South Gippsland"},{"$f":"INDEX(Prop2022DistTar!$F$164:$F$165,C$266)","v":100},{"$f":"INDEX(Prop2022DistTar!$F$164:$F$165,D$266)","v":62.2}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2"]
[null,{"$f":"B272","v":"Existing: Tariff D - Multinet South Gippsland"},{"$f":"INDEX(Prop2022DistTar!$H$164:$H$165,C266)","v":64708.19},{"$f":"INDEX(Prop2022DistTar!$H$164:$H$165,D266)","v":6847.5295800000004}]
[null,{"$f":"B273","v":"Proposed: Tariff D - Multinet South Gippsland"},{"$f":"INDEX(Prop2022DistTar!$G$164:$G$165,C266)","v":67196.97},{"$f":"INDEX(Prop2022DistTar!$G$164:$G$165,D266)","v":7110.8968199999999}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B276","v":"Existing: Tariff D - Multinet South Gippsland"},{"$f":"SUM(C276:D276)","v":71555.719580000004}]
[null,{"$f":"B277","v":"Proposed: Tariff D - Multinet South Gippsland"},{"$f":"SUM(C277:D277)","v":74307.866819999996}]
[]
[null,"Average price movement",{"$f":"IF(C281=0,\"\",C281/C280)","v":1.0384615968668034}]
[]
[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":2021},{"$f":"'Model update'!$B$5","v":2022}]
["Meter Investigation – High Account Investigation Between the hours of 8am and 4pm on a Business Day",150.56,{"$f":"ROUND(B6*(1+'Model update'!$B$30),2)","v":156.35}]
["Meter Disconnection – Use of locks & plugs Between the hours of 8am and 4pm on a Business Day",52.74,{"$f":"ROUND(B7*(1+'Model update'!$B$30),2)","v":54.77}]
["Meter Removal – Various Between the hours of 8am and 4pm on a Business Day",63.01,{"$f":"ROUND(B8*(1+'Model update'!$B$30),2)","v":65.430000000000007}]
["Reconnect Between the hours of 8am and 4pm on a Business Day",44.46,{"$f":"ROUND(B9*(1+'Model update'!$B$30),2)","v":46.17}]
["Special Meter Reads Between the hours of 8am and 4pm on a Business Day",6.76,{"$f":"ROUND(B10*(1+'Model update'!$B$30),2)","v":7.02}]
["Installation of a second service valve in a pit and disconnect gas supply – paved (without traffic Mgt)",3361.17,{"$f":"ROUND(B11*(1+'Model update'!$B$30),2)","v":3490.45}]
["Installation of a second service valve in a pit and disconnect gas supply – paved (with traffic Mgt)",4165.13,{"$f":"ROUND(B12*(1+'Model update'!$B$30),2)","v":4325.33}]
["Installation of a second service valve in a pit and disconnect gas supply – unpaved (without traffic Mgt)",1595.31,{"$f":"ROUND(B13*(1+'Model update'!$B$30),2)","v":1656.67}]
["Installation of a second service valve in a pit and disconnect gas supply – unpaved (with traffic Mgt)",2198.2800000000002,{"$f":"ROUND(B14*(1+'Model update'!$B$30),2)","v":2282.83}]
[]
["Note: Formula is as per AA2018-22, Part B, section 2, p9 : ART = ARTt-1  * (1+CPIt)"]