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

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

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

{"sheet":"Prop2021DistTar","index":2,"n_rows":137,"n_cols":8,"rows_kept":137,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"\"Tariff Approval - \"&'Model update'!B3","v":"Tariff Approval - AusNet Services"},{"$f":"\"Prop\"&'Model update'!B5&\"DistTar\"","v":"Prop2021DistTar"}]
[]
[null,{"$f":"\"PROPOSED \"&'Model update'!$B$5&\" DISTRIBUTION TARIFFS\"","v":"PROPOSED 2021 DISTRIBUTION TARIFFS"}]
[]
[null,"Proposed tariff name","Existing name",{"$f":"\"Prop\n\"&'Model update'!$B$5&\" Tariff\"","v":"Prop\n2021 Tariff"},{"$f":"\"Exist\n\"&'Model update'!$B$8&\" Tariff\"","v":"Exist\n2020 Tariff"},{"$f":"\"Actual \"&'Model update'!$B$9&\" Volumes\"","v":"Actual 2019 Volumes"},"Prop Tar\nRevenue","Exist Tar\nRevenue"]
[null,"Tariff V - SP AusNet Central - Residential","Tariff V - SP AusNet Central - Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.38579999999999998,0.35720000000000002,542431.3816522432,{"$f":"D8*$F8*365","v":76383559.870123923},{"$f":"E8*$F8*365","v":70721118.677056164}]
[null,"Peak 0 - 0.1","Peak 0 - 0.1",6.54,7.3345000000000002,5416825.5140000004,{"$f":"D9*$F9","v":35426038.861560002},39729706.732433006]
[null,"Peak 0.1 - 0.2","Peak 0.1 - 0.2",3.9236,4.4001999999999999,3862435.585,15154652.261305999,16995489.061117001]
[null,"Peak 0.2 - 1.4","Peak 0.2 - 1.4",0.68610000000000004,0.76939999999999997,5818211.0760000004,3991874.6192436004,4476531.6018743999]
[null,"Peak > 1.4","Peak > 1.4",0.61339999999999995,0.68789999999999996,79110.494999999995,48526.377632999996,54420.109510499991]
[null,"Off Peak 0 - 0.1","Off Peak 0 - 0.1",2.2311000000000001,2.5021,7294065.8899999997,16273790.407179,18250482.263368998]
[null,"Off Peak 0.1 - 0.2","Off Peak 0.1 - 0.2",1.7844,2.0011999999999999,1682755.4269999999,3002708.7839388,3367530.1605123994]
[null,"Off Peak 0.2 - 1.4","Off Peak 0.2 - 1.4",0.68279999999999996,0.76570000000000005,590107.72199999995,402925.55258159997,451845.48273539997]
[null,"Off Peak > 1.4","Off Peak > 1.4",0.23760000000000001,0.26650000000000001,79800.216,18960.5313216,21266.757564]
[null,"Tariff V - SP AusNet Central - Non Residential","Tariff V - SP AusNet Central - Non Residential",null,null,{"$f":"SUM(F9:F16)","v":24823311.924999997}]
[]
[null,"Fixed Charge","Fixed Charge",0.40279999999999999,0.373,10219.748128115862,{"$f":"D19*$F19*365","v":1502527.8092918501},{"$f":"E19*$F19*365","v":1391367.608902334}]
[null,"Peak 0 - 0.1","Peak 0 - 0.1",1.1125,1.2476,94487.953999999998,{"$f":"D20*$F20","v":105117.84882500001},117883.1714104]
[null,"Peak 0.1 - 0.2","Peak 0.1 - 0.2",1.0592999999999999,1.1879999999999999,78714.222999999998,83381.976423899992,93512.496923999992]
[null,"Peak 0.2 - 1.4","Peak 0.2 - 1.4",0.94740000000000002,1.0625,479726.81099999999,454493.18074139999,509709.73668749997]
[null,"Peak > 1.4","Peak > 1.4",0.71099999999999997,0.7974,1262355.5449999999,897534.79249499994,1006602.3115829999]
[null,"Off Peak 0 - 0.1","Off Peak 0 - 0.1",1.056,1.1842999999999999,161888.78400000001,170954.55590400004,191724.8868912]
[null,"Off Peak 0.1 - 0.2","Off Peak 0.1 - 0.2",0.73860000000000003,0.82830000000000004,114613.47500000001,84653.512635000006,94934.341342500004]
[null,"Off Peak 0.2 - 1.4","Off Peak 0.2 - 1.4",0.61040000000000005,0.6845,690621.18,421555.1682720001,472730.19771000004]
[null,"Off Peak > 1.4","Off Peak > 1.4",0.58099999999999996,0.65159999999999996,1479380.2609999999,859519.93164099986,963964.17806759989]
[null,"Tariff V - SP AusNet West - Residential","Tariff V - SP AusNet West - Residential",null,null,{"$f":"SUM(F20:F27)","v":4361788.233}]
[]
[null,"Fixed Charge","Fixed Charge",0.38579999999999998,0.35720000000000002,145788.04402326143,{"$f":"D30*$F30*365","v":20529434.995223604},{"$f":"E30*$F30*365","v":19007553.603664782}]
[null,"Peak 0 - 0.1","Peak 0 - 0.1",3.7231000000000001,4.1753999999999998,1490194.007,{"$f":"D31*$F31","v":5548141.3074617004},6222156.0568277994]
[null,"Peak 0.1 - 0.2","Peak 0.1 - 0.2",2.6686999999999999,2.9929000000000001,1127296.4539999999,3008416.0467897998,3373885.5571765997]
[null,"Peak 0.2 - 1.4","Peak 0.2 - 1.4",0.86050000000000004,0.96499999999999997,1736232.76,1494028.2899800001,1675464.6133999999]
[null,"Peak > 1.4","Peak > 1.4",0.82410000000000005,0.92420000000000002,18296.895,15078.471169500001,16909.990358999999]
[null,"Off Peak 0 - 0.1","Off Peak 0 - 0.1",1.1676,1.3093999999999999,1945311.1839999999,2271345.3384383996,2547190.4643295999]
[null,"Off Peak 0.1 - 0.2","Off Peak 0.1 - 0.2",1.0991,1.2325999999999999,545685.51500000001,599762.94953650003,672611.96578899992]
[null,"Off Peak 0.2 - 1.4","Off Peak 0.2 - 1.4",0.62180000000000002,0.69730000000000003,265994.98100000003,165395.67918580002,185478.30025130004]
[null,"Off Peak > 1.4","Off Peak > 1.4",0.1206,0.1353,11826.136,1426.2320016000001,1600.0762008000002]
[null,"Tariff V - SP AusNet West - Non Residential","Tariff V - SP AusNet West - Non Residential",null,null,{"$f":"SUM(F31:F38)","v":7140837.9319999982}]
[]
[null,"Fixed Charge","Fixed Charge",0.40279999999999999,0.373,6075.2722108130229,{"$f":"D41*$F41*365","v":893198.67097815231},{"$f":"E41*$F41*365","v":827117.93514113897}]
[null,"Peak 0 - 0.1","Peak 0 - 0.1",1.8216000000000001,2.0428999999999999,50926.353999999999,{"$f":"D42*$F42","v":92767.446446400005},104037.44858659999]
[null,"Peak 0.1 - 0.2","Peak 0.1 - 0.2",1.5341,1.7203999999999999,40136.322,61573.131580200003,69050.528368799991]
[null,"Peak 0.2 - 1.4","Peak 0.2 - 1.4",0.94059999999999999,1.0548999999999999,217624.77600000001,204697.8643056,229572.37620239999]
[null,"Peak > 1.4","Peak > 1.4",0.3458,0.38779999999999998,500556.94300000003,173092.59088940002,194115.98249540001]
[null,"Off Peak 0 - 0.1","Off Peak 0 - 0.1",0.84650000000000003,0.94930000000000003,77537.567999999999,65635.551311999996,73606.413302400004]
[null,"Off Peak 0.1 - 0.2","Off Peak 0.1 - 0.2",0.71299999999999997,0.79959999999999998,49031.339,34959.344706999997,39205.458664400001]
[null,"Off Peak 0.2 - 1.4","Off Peak 0.2 - 1.4",0.3458,0.38779999999999998,260756.022,90169.432407600005,101121.18533159999]
[null,"Off Peak > 1.4","Off Peak > 1.4",0.25530000000000003,0.2863,513975.78499999997,131218.0179105,147151.2672455]
[null,"Tariff V - Adjoining Central - Residential","Tariff V - Adjoining Central - Residential",null,null,{"$f":"SUM(F42:F49)","v":1710545.1089999999}]
[]
[null,"Fixed Charge","Fixed Charge",0.38579999999999998,0.35720000000000002,1764.9033232729714,{"$f":"D52*$F52*365","v":248528.39127332999},{"$f":"E52*$F52*365","v":230104.56548168347}]
[null,"Peak 0 - 0.1","Peak 0 - 0.1",9.9795999999999996,11.1919,15308.242,{"$f":"D53*$F53","v":152770.13186319999},171328.31363980001]
[null,"Peak 0.1 - 0.2","Peak 0.1 - 0.2",7.1813000000000002,8.0535999999999994,9827.4570000000003,70573.916954100001,79146.407695200003]
[null,"Peak 0.2 - 1.4","Peak 0.2 - 1.4",2.5834999999999999,2.8973,12230.718999999999,31598.062536499998,35436.062158699999]
[null,"Peak > 1.4","Peak > 1.4",2.4601999999999999,2.7591000000000001,551.20399999999995,1356.0720807999999,1520.8269564]
[null,"Off Peak 0 - 0.1","Off Peak 0 - 0.1",4.6380999999999997,5.2015000000000002,17812.036,82614.004171599998,92649.305254000006]
[null,"Off Peak 0.1 - 0.2","Off Peak 0.1 - 0.2",2.6200999999999999,2.9384000000000001,4596.0709999999999,12042.165627099999,13505.0950264]
[null,"Off Peak 0.2 - 1.4","Off Peak 0.2 - 1.4",2.3005,2.5798999999999999,2927.5819999999999,6734.9023909999996,7552.8688017999993]
[null,"Off Peak > 1.4","Off Peak > 1.4",2.1901999999999999,2.4563000000000001,432.37,946.97677399999998,1062.0304310000001]
[null,"Tariff V - Adjoining Central - Non Residential","Tariff V - Adjoining Central - Non Residential",null,null,{"$f":"SUM(F53:F60)","v":63685.680999999997}]
[]
[null,"Fixed Charge","Fixed Charge",0.40279999999999999,0.373,15.581605321148968,{"$f":"D63*$F63*365","v":2290.8387775259635},{"$f":"E63*$F63*365","v":2121.3576564478262}]
[null,"Peak 0 - 0.1","Peak 0 - 0.1",4.1746999999999996,4.6818,186.23599999999999,{"$f":"D64*$F64","v":777.47942919999991},871.91970479999998]
[null,"Peak 0.1 - 0.2","Peak 0.1 - 0.2",3.9756999999999998,4.4585999999999997,157.434,625.91035379999994,701.9352323999999]
[null,"Peak 0.2 - 1.4","Peak 0.2 - 1.4",3.5366,3.9662000000000002,798.10299999999995,2822.5710697999998,3165.4361186000001]
[null,"Peak > 1.4","Peak > 1.4",3.3578999999999999,3.7658,306.262,1028.3971698,1153.3214396000001]
[null,"Off Peak 0 - 0.1","Off Peak 0 - 0.1",3.7176,4.1692,274.83699999999999,1021.7340312,1145.8504203999998]
[null,"Off Peak 0.1 - 0.2","Off Peak 0.1 - 0.2",3.53,3.9588000000000001,178.9,631.51699999999994,708.22932000000003]
[null,"Off Peak 0.2 - 1.4","Off Peak 0.2 - 1.4",3.3582000000000001,3.7660999999999998,1471.7,4942.2629400000005,5542.5693700000002]
[null,"Off Peak > 1.4","Off Peak > 1.4",3.1979000000000002,3.5863999999999998,538.69899999999996,1722.7055321,1931.9900935999997]
[null,"Tariff V - Adjoining West - Residential","Tariff V - Adjoining West - Residential",null,null,{"$f":"SUM(F64:F71)","v":3912.1709999999998}]
[]
[null,"Fixed Charge","Fixed Charge",0.38579999999999998,0.35720000000000002,10963.400305957612,{"$f":"D74*$F74*365","v":1543833.1408840329},{"$f":"E74*$F74*365","v":1429386.2050901416}]
[null,"Peak 0 - 0.1","Peak 0 - 0.1",6.9668999999999999,7.8132000000000001,110186.788,{"$f":"D75*$F75","v":767660.33331719995},{"$f":"E75*$F75","v":860911.41200160002}]
[null,"Peak 0.1 - 0.2","Peak 0.1 - 0.2",5.8392999999999997,6.5486000000000004,86785.596999999994,506767.13656209991,568324.16051419999]
[null,"Peak 0.2 - 1.4","Peak 0.2 - 1.4",3.0125000000000002,3.3784000000000001,170960.25399999999,515017.76517500001,577572.12211359991]
[null,"Peak > 1.4","Peak > 1.4",2.6823000000000001,3.0081000000000002,2129.2660000000001,5711.3301918000006,6405.0450546000011]
[null,"Off Peak 0 - 0.1","Off Peak 0 - 0.1",4.2339000000000002,4.7481999999999998,142276.106,602382.80519340001,675555.40650919999]
[null,"Off Peak 0.1 - 0.2","Off Peak 0.1 - 0.2",3.1793999999999998,3.5655999999999999,48758.250999999997,155021.98322939998,173852.41976559997]
[null,"Off Peak 0.2 - 1.4","Off Peak 0.2 - 1.4",2.2713000000000001,2.5472000000000001,28729.171999999999,65252.568363600003,73178.946918400005]
[null,"Off Peak > 1.4","Off Peak > 1.4",2.1631999999999998,2.4260000000000002,3641.8359999999998,7878.0196351999984,8835.0941359999997]
[null,"Tariff V - Adjoining West - Non Residential","Tariff V - Adjoining West - Non Residential",null,null,{"$f":"SUM(F75:F82)","v":593467.27}]
[]
[null,"Fixed Charge","Fixed Charge",0.40279999999999999,0.373,276.71714011396222,{"$f":"D85*$F85*365","v":40683.507373834953},{"$f":"E85*$F85*365","v":37673.655040815385}]
[null,"Peak 0 - 0.1","Peak 0 - 0.1",4.9333,5.5326000000000004,2817.0439999999999,{"$f":"D86*$F86","v":13897.323165199999},{"$f":"E86*$F86","v":15585.577634400001}]
[null,"Peak 0.1 - 0.2","Peak 0.1 - 0.2",4.6258999999999997,5.1878000000000002,2316.364,10715.2682276,12016.833159200001]
[null,"Peak 0.2 - 1.4","Peak 0.2 - 1.4",3.8874,4.3596000000000004,13900.484,54036.741501600001,60600.550046400007]
[null,"Peak > 1.4","Peak > 1.4",3.3166000000000002,3.7195,29449.126,97670.971291600014,109536.02415700001]
[null,"Off Peak 0 - 0.1","Off Peak 0 - 0.1",3.7970999999999999,4.2583000000000002,4607.3789999999999,17494.678800900001,19619.601995699999]
[null,"Off Peak 0.1 - 0.2","Off Peak 0.1 - 0.2",3.6160999999999999,4.0553999999999997,3420.018,12367.1270898,13869.5409972]
[null,"Off Peak 0.2 - 1.4","Off Peak 0.2 - 1.4",3.1371000000000002,3.5182000000000002,20040.642,62869.498018200007,70506.986684400006]
[null,"Off Peak > 1.4","Off Peak > 1.4",2.9533999999999998,3.3121999999999998,30968.370999999999,91461.986911399988,102573.43842619999]
[null,null,null,null,null,{"$f":"SUM(F86:F93)","v":107519.428}]
[null,"Tariff M - SP AusNet Central","Tariff M - SP AusNet Central"]
[null,"0 - 10","0 - 10",680.0702,693.98429999999996,161.61999999999998,{"$f":"D96*$F96","v":109912.94572399999},112161.74256599997]
[null,"10 - 50","10 - 50",647.71019999999999,660.96220000000005,52.8,34199.098559999999,34898.80416]
[null,"> 50","> 50",135.2432,138.0103,0,0,0]
[]
[null,"Tariff M - SP AusNet West","Tariff M - SP AusNet West"]
[null,"0 - 10","0 - 10",680.0702,693.98429999999996,28.7,{"$f":"D101*$F101","v":19518.014739999999},19917.349409999999]
[null,"10 - 50","10 - 50",647.71019999999999,660.96220000000005,24.560000000000002,15907.762512000001,16233.231632000003]
[null,"> 50","> 50",135.2432,138.0103,0,0,0]
[]
[null,"Tariff M - Adjoining Central","Tariff M - Adjoining Central"]
[null,"0 - 10","0 - 10",680.0702,693.98429999999996,0,{"$f":"D106*$F106","v":0},0]
[null,"10 - 50","10 - 50",647.71019999999999,660.96220000000005,0,0,0]
[null,"> 50","> 50",135.2432,138.0103,0,0,0]
[]
[null,"Tariff M - Adjoining West","Tariff M - Adjoining West"]
[null,"0 - 10","0 - 10",680.0702,693.98429999999996,0,{"$f":"D111*$F111","v":0},0]
[null,"10 - 50","10 - 50",647.71019999999999,660.96220000000005,0,0,0]
[null,"> 50","> 50",135.2432,138.0103,0,0,0]
[]
[]
[null,"Tariff D - SP AusNet Central","Tariff D - SP AusNet Central"]
[null,"0 - 10","0 - 10",310.23239999999998,316.5797,1389.3800000000006,{"$f":"D117*$F117","v":431030.69191200013},439849.50358600018]
[null,"10 - 50","10 - 50",295.46179999999998,301.50689999999997,1567.7399999999998,463207.28233199992,472684.42740599992]
[null,"> 50","> 50",143.4504,146.3854,3295.5800000000004,{"$f":"D119*$F119","v":472752.26923200005},{"$f":"E119*$F119","v":482424.79653200007}]
[]
[null,"Tariff D - SP AusNet West","Tariff D - SP AusNet West"]
[null,"0 - 10","0 - 10",310.23239999999998,316.5797,520.08000000000004,{"$f":"D122*$F122","v":161345.66659199999},164646.770376]
[null,"10 - 50","10 - 50",295.46179999999998,301.50689999999997,664.26,196263.45526799999,200278.97339399997]
[null,"> 50","> 50",143.4504,146.3854,410.42,58874.913168000006,60079.495868000005]
[]
[null,"Tariff D - Adjoining Central","Tariff D - Adjoining Central"]
[null,"0 - 10","0 - 10",310.23239999999998,316.5797,10,{"$f":"D127*$F127","v":3102.3239999999996},3165.797]
[null,"10 - 50","10 - 50",295.46179999999998,301.50689999999997,19.98,{"$f":"D128*$F128","v":5903.3267639999995},6024.1078619999998]
[null,"> 50","> 50",143.4504,146.3854,0,0,0]
[]
[null,"Tariff D - Adjoining West","Tariff D - Adjoining West"]
[null,"0 - 10","0 - 10",310.23239999999998,316.5797,11.15,{"$f":"D132*$F132","v":3459.0912600000001},3529.8636550000001]
[null,"10 - 50","10 - 50",295.46179999999998,301.50689999999997,5.7,1684.1322599999999,1718.5893299999998]
[null,"> 50","> 50",143.4504,146.3854,0,0,0]
[]
[]
[null,"Total Revenue","Total Revenue",null,null,null,{"$f":"SUM(G8:G135)","v":197834028.60067135},{"$f":"SUM(H8:H135)","v":201881913.55685005}]

{"sheet":"2021TarContForm","index":3,"n_rows":44,"n_cols":3,"rows_kept":44,"cut":false,"hidden":false,"merged":[[43,1,43,3]]}
[null,{"$f":"\"Tariff Approval - \"&'Model update'!B3","v":"Tariff Approval - AusNet Services"},{"$f":"'Model update'!B5&\"TarContForm\"","v":"2021TarContForm"}]
[]
[null,{"$f":"'Model update'!$B$5&\"  TARIFF CONTROL FORMULA\"","v":"2021  TARIFF CONTROL FORMULA"}]
[]
[]
[null,"CPI"]
[]
[null,{"$f":"\"CPI Sept\"&'Model update'!$B$9","v":"CPI Sept2019"},{"$f":"'Model update'!B26","v":114.8}]
[null,{"$f":"\"CPI Sept\"&'Model update'!$B$8","v":"CPI Sept2020"},{"$f":"'Model update'!B27","v":114.4}]
[]
[null,{"$f":"\"CPI \"&'Model update'!$B$5","v":"CPI 2021"},{"$f":"(C9/C8-1)","v":-3.4843205574912606E-3}]
[]
[]
[]
[null,"X factor"]
[]
[null,{"$f":"\"X \"&'Model update'!$B$5","v":"X 2021"},{"$f":"'Model update'!B40","v":1.6623218055427314E-2}]
[]
[]
[null,"Pass Through Factor (PT)"]
[]
[null,"Pass Through"]
[null,{"$f":"\"AP (t) \"&'Model update'!$B$7","v":"AP (t) 2021"},{"$f":"'Model update'!B50","v":0}]
[]
[null,"Revenue"]
[null,"∑∑p(t-1)q(t-2)",{"$f":"C41","v":201881913.55685005}]
[]
[null,"PT' (t-1)",0]
[null,{"$f":"\"PT' \"&'Model update'!$B$5","v":"PT' 2021"},{"$f":"IF(C26=\"\",0,(C23)/((1+C11)*(1-C17)*C26))","v":0}]
[]
[null,{"$f":"\"PTt \"&'Model update'!$B$5","v":"PTt 2021"},{"$f":"((1+C29)/(1+C28))-1","v":0}]
[]
[]
[]
[]
[null,{"$f":"'Model update'!$B$5&\"  Distribution price control\"","v":"2021  Distribution price control"}]
[]
[null,"Average price movement allowed",{"$f":"(1+C11)*(1-C17)*(1+C31)","v":0.97995038200748363}]
[]
[null,"Proposed distribution tariff revenue",{"$f":"IF(Prop2021DistTar!G137=0,\"\",Prop2021DistTar!G137)","v":197834028.60067135}]
[null,"Existing distribution tariff revenue",{"$f":"IF(Prop2021DistTar!H137=0,\"\",Prop2021DistTar!H137)","v":201881913.55685005}]
[null,"Average price movement",{"$f":"IF(C40=\"\",\"\",C40/C41)","v":0.97994924416525897}]
[]
[null,{"$f":"IF(C40=\"\",\"\",IF(C38>=C42,\"DISTRIBUTION PRICE CONTROL FORMULA COMPLIANT\",\"DISTRIBUTION PRICE CONTROL FORMULA BREACHED\"))","v":"DISTRIBUTION PRICE CONTROL FORMULA COMPLIANT"}]

{"sheet":"2021RebalContForm","index":4,"n_rows":467,"n_cols":11,"rows_kept":467,"cut":false,"hidden":false,"merged":[[466,1,466,2],[346,1,346,2],[370,1,370,2],[394,1,394,2],[418,1,418,2],[442,1,442,2],[322,1,322,2],[64,1,64,2],[94,1,94,2],[124,1,124,2],[184,1,184,2],[214,1,214,2],[244,1,244,2],[298,1,298,2],[154,1,154,2],[274,1,274,2]]}
[null,{"$f":"\"Tariff Approval - \"&'Model update'!B3","v":"Tariff Approval - AusNet Services"},{"$f":"'Model update'!B5&\"RebalContForm\"","v":"2021RebalContForm"}]
[]
[null,{"$f":"'Model update'!$B$5&\"  REBALANCING CONTROL FORMULA\"","v":"2021  REBALANCING CONTROL FORMULA"}]
[]
[]
[null,"Rebalancing control"]
[]
[null,{"$f":"\"CPI \"&'Model update'!$B$5","v":"CPI 2021"},{"$f":"'2021TarContForm'!C11","v":-3.4843205574912606E-3}]
[null,{"$f":"\"Y  \"&'Model update'!$B$5","v":"Y  2021"},0.02]
[null,{"$f":"\"PTt \"&'Model update'!$B$5","v":"PTt 2021"},{"$f":"'2021TarContForm'!C31","v":0}]
[null,{"$f":"\"Xt \"&'Model update'!$B$5","v":"Xt 2021"},{"$f":"'2021TarContForm'!C17","v":1.6623218055427314E-2}]
[]
[null,"Rebalancing control",{"$f":"(1+C8)*(1+C9)*(1+C10)*(1-C11)","v":0.99954938964763329}]
[]
[]
[]
[null,"Rebalancing control summary"]
[null,null,"Existing","Proposed","Movement","Assessment"]
[null,{"$f":"B39","v":"Tariff V - SP AusNet Central - Residential"},{"$f":"C60","v":154068390.84617186},{"$f":"C61","v":150703037.26488754},{"$f":"IF(C19=0,0,D19/C19)","v":0.9781567551734579},{"$f":"IF(E19=0,\"\",IF($C$13<=E19,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B69","v":"Tariff V - SP AusNet West - Residential"},{"$f":"C90","v":33702850.627998881},{"$f":"C91","v":33633029.309786908},0.99792832603441661,{"$f":"IF(E20=0,\"\",IF($C$13<=E20,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B99","v":"Tariff V - Adjoining Central - Residential"},{"$f":"C120","v":632305.47544498357},{"$f":"C121","v":607164.62367162993},0.96023938942540266,"Compliant"]
[null,{"$f":"B129","v":"Tariff V - Adjoining West - Residential"},{"$f":"C150","v":4374020.8121033413},{"$f":"C151","v":4169525.0825517327},0.95324765511271714,"Compliant"]
[null,{"$f":"B159","v":"Tariff V - SP AusNet Central - Non Residential"},{"$f":"C180","v":4842428.9295185339},{"$f":"C181","v":4579738.7762291506},0.94575239882446727,"Compliant"]
[null,{"$f":"B189","v":"Tariff V - SP AusNet West - Non Residential"},{"$f":"C210","v":1784978.5953382389},{"$f":"C211","v":1747312.0505368528},0.97889804118673562,"Compliant"]
[null,{"$f":"B219","v":"Tariff V - Adjoining Central - Non Residential"},{"$f":"C240","v":17342.609355847828},{"$f":"C241","v":15863.416303425964},0.91470758395863372,"Compliant"]
[null,{"$f":"B249","v":"Tariff V - Adjoining West - Non Residential"},{"$f":"C270","v":441982.20814131544},{"$f":"C271","v":401197.10238013498},{"$f":"IF(C26=0,0,D26/C26)","v":0.90772229060374265},{"$f":"IF(E26=0,\"\",IF($C$13<=E26,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B279","v":"Tariff M - SP AusNet Central"},{"$f":"C294","v":147060.54672599997},{"$f":"C295","v":144112.044284},0.9799504183301212,"Compliant"]
[null,{"$f":"B303","v":"Tariff M - SP AusNet West"},{"$f":"C318","v":36150.581042000005},{"$f":"C319","v":35425.777252},0.97995042488645134,"Compliant"]
[null,{"$f":"B327","v":"Tariff M - Adjoining Central"},{"$f":"C342","v":0},{"$f":"C343","v":0},{"$f":"IF(C29=0,0,D29/C29)","v":0},{"$f":"IF(E29=0,\"\",IF($C$13<=E29,\"Breached\",\"Compliant\"))","v":""}]
[null,{"$f":"B351","v":"Tariff M - Adjoining West"},{"$f":"C366","v":0},{"$f":"C367","v":0},0,""]
[null,{"$f":"B375","v":"Tariff D - SP AusNet Central"},{"$f":"C390","v":1394958.7275240002},{"$f":"C391","v":1366990.2434760001},{"$f":"IF(C31=0,0,D31/C31)","v":0.97995031430238577},{"$f":"IF(E31=0,\"\",IF($C$13<=E31,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B399","v":"Tariff D - SP AusNet West"},{"$f":"C414","v":425005.23963799997},{"$f":"C415","v":416484.03502799995},0.97995035398326391,"Compliant"]
[null,{"$f":"B423","v":"Tariff D - Adjoining Central"},{"$f":"C438","v":9189.9048619999994},{"$f":"C439","v":9005.6507639999982},0.97995038025236947,"Compliant"]
[null,{"$f":"B447","v":"Tariff D - Adjoining West"},{"$f":"C462","v":5248.4529849999999},{"$f":"C463","v":5143.2235199999996},0.97995038437026216,"Compliant"]
[null,null,{"$f":"SUM(C19:C34)","v":201881913.55684993},{"$f":"SUM(D19:D34)","v":197834028.60067132},0.97994924416525941]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!B6","v":"Tariff V - SP AusNet Central - Residential"},1,2,3,4,5,6,7,8,9]
[null,null,1,2,3,4,5,6,7,8,9]
[null,"Distribution tariff","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4"]
[]
[null,{"$f":"\"Existing : \"&Prop2021DistTar!C6","v":"Existing : Tariff V - SP AusNet Central - Residential"},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$16,C$40)","v":0.35720000000000002},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$16,D$40)","v":7.3345000000000002},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$16,E$40)","v":4.4001999999999999},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$16,F$40)","v":0.76939999999999997},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$16,G$40)","v":0.68789999999999996},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$16,H$40)","v":2.5021},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$16,I$40)","v":2.0011999999999999},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$16,J$40)","v":0.76570000000000005},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$16,K$40)","v":0.26650000000000001}]
[]
[null,{"$f":"\"Proposed : \"&B39","v":"Proposed : Tariff V - SP AusNet Central - Residential"},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$16,C$39)","v":0.38579999999999998},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$16,D$39)","v":6.54},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$16,E$39)","v":3.9236},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$16,F$39)","v":0.68610000000000004},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$16,G$39)","v":0.61339999999999995},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$16,H$39)","v":2.2311000000000001},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$16,I$39)","v":1.7844},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$16,J$39)","v":0.68279999999999996},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$16,K$39)","v":0.23760000000000001}]
[]
[null,"Distribution volumes (actual)",{"$f":"C$41","v":"Fixed"},{"$f":"D$41","v":"PkBlk1"},"PkBlk2","PkBlk3","PkBlk4","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4"]
[]
[null,{"$f":"B43","v":"Existing : Tariff V - SP AusNet Central - Residential"},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$16,C$39)","v":542431.3816522432},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$16,D$39)","v":5416825.5140000004},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$16,E$39)","v":3862435.585},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$16,F$39)","v":5818211.0760000004},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$16,G$39)","v":79110.494999999995},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$16,H$39)","v":7294065.8899999997},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$16,I$39)","v":1682755.4269999999},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$16,J$39)","v":590107.72199999995},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$16,K$39)","v":79800.216}]
[]
[null,{"$f":"B45","v":"Proposed : Tariff V - SP AusNet Central - Residential"},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$16,C$39)","v":542431.3816522432},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$16,D$39)","v":5416825.5140000004},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$16,E$39)","v":3862435.585},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$16,F$39)","v":5818211.0760000004},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$16,G$39)","v":79110.494999999995},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$16,H$39)","v":7294065.8899999997},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$16,I$39)","v":1682755.4269999999},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$16,J$39)","v":590107.72199999995},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$16,K$39)","v":79800.216}]
[]
[null,"Distribution revenue",{"$f":"C$41","v":"Fixed"},"PkBlk1","PkBlk2","PkBlk3","PkBlk4","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4"]
[]
[null,{"$f":"B49","v":"Existing : Tariff V - SP AusNet Central - Residential"},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$16,C$40)","v":70721118.677056164},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$16,D$40)","v":39729706.732433006},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$16,E$40)","v":16995489.061117001},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$16,F$40)","v":4476531.6018743999},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$16,G$40)","v":54420.109510499991},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$16,H$40)","v":18250482.263368998},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$16,I$40)","v":3367530.1605123994},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$16,J$40)","v":451845.48273539997},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$16,K$40)","v":21266.757564}]
[]
[null,{"$f":"B51","v":"Proposed : Tariff V - SP AusNet Central - Residential"},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$16,C$39)","v":76383559.870123923},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$16,D$39)","v":35426038.861560002},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$16,E$39)","v":15154652.261305999},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$16,F$39)","v":3991874.6192436004},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$16,G$39)","v":48526.377632999996},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$16,H$39)","v":16273790.407179},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$16,I$39)","v":3002708.7839388},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$16,J$39)","v":402925.55258159997},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$16,K$39)","v":18960.5313216}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B55","v":"Existing : Tariff V - SP AusNet Central - Residential"},{"$f":"SUM(C55:K55)","v":154068390.84617186}]
[null,{"$f":"B57","v":"Proposed : Tariff V - SP AusNet Central - Residential"},{"$f":"SUM(C57:K57)","v":150703037.26488754}]
[]
[null,"Average price movement",{"$f":"IF(C61=0,\"\",C61/C60)","v":0.9781567551734579}]
[]
[null,{"$f":"IF(C63=\"\",\"\",IF(C63<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!B28","v":"Tariff V - SP AusNet West - Residential"},1,2,3,4,5,6,7,8,9]
[null,null,1,2,3,4,5,6,7,8,9]
[null,"Distribution tariff","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4"]
[]
[null,{"$f":"\"Existing : \"&Prop2021DistTar!C28","v":"Existing : Tariff V - SP AusNet West - Residential"},{"$f":"INDEX(Prop2021DistTar!$E$30:$E$38,C$40)","v":0.35720000000000002},{"$f":"INDEX(Prop2021DistTar!$E$30:$E$38,D$40)","v":4.1753999999999998},{"$f":"INDEX(Prop2021DistTar!$E$30:$E$38,E$40)","v":2.9929000000000001},{"$f":"INDEX(Prop2021DistTar!$E$30:$E$38,F$40)","v":0.96499999999999997},{"$f":"INDEX(Prop2021DistTar!$E$30:$E$38,G$40)","v":0.92420000000000002},{"$f":"INDEX(Prop2021DistTar!$E$30:$E$38,H$40)","v":1.3093999999999999},{"$f":"INDEX(Prop2021DistTar!$E$30:$E$38,I$40)","v":1.2325999999999999},{"$f":"INDEX(Prop2021DistTar!$E$30:$E$38,J$40)","v":0.69730000000000003},{"$f":"INDEX(Prop2021DistTar!$E$30:$E$38,K$40)","v":0.1353}]
[]
[null,{"$f":"\"Proposed : \"&B69","v":"Proposed : Tariff V - SP AusNet West - Residential"},{"$f":"INDEX(Prop2021DistTar!$D$30:$D$38,C$39)","v":0.38579999999999998},{"$f":"INDEX(Prop2021DistTar!$D$30:$D$38,D$39)","v":3.7231000000000001},{"$f":"INDEX(Prop2021DistTar!$D$30:$D$38,E$39)","v":2.6686999999999999},{"$f":"INDEX(Prop2021DistTar!$D$30:$D$38,F$39)","v":0.86050000000000004},{"$f":"INDEX(Prop2021DistTar!$D$30:$D$38,G$39)","v":0.82410000000000005},{"$f":"INDEX(Prop2021DistTar!$D$30:$D$38,H$39)","v":1.1676},{"$f":"INDEX(Prop2021DistTar!$D$30:$D$38,I$39)","v":1.0991},{"$f":"INDEX(Prop2021DistTar!$D$30:$D$38,J$39)","v":0.62180000000000002},{"$f":"INDEX(Prop2021DistTar!$D$30:$D$38,K$39)","v":0.1206}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B73","v":"Existing : Tariff V - SP AusNet West - Residential"},{"$f":"INDEX(Prop2021DistTar!$F$30:$F$38,C$39)","v":145788.04402326143},{"$f":"INDEX(Prop2021DistTar!$F$30:$F$38,D$39)","v":1490194.007},{"$f":"INDEX(Prop2021DistTar!$F$30:$F$38,E$39)","v":1127296.4539999999},{"$f":"INDEX(Prop2021DistTar!$F$30:$F$38,F$39)","v":1736232.76},{"$f":"INDEX(Prop2021DistTar!$F$30:$F$38,G$39)","v":18296.895},{"$f":"INDEX(Prop2021DistTar!$F$30:$F$38,H$39)","v":1945311.1839999999},{"$f":"INDEX(Prop2021DistTar!$F$30:$F$38,I$39)","v":545685.51500000001},{"$f":"INDEX(Prop2021DistTar!$F$30:$F$38,J$39)","v":265994.98100000003},{"$f":"INDEX(Prop2021DistTar!$F$30:$F$38,K$39)","v":11826.136}]
[]
[null,{"$f":"B75","v":"Proposed : Tariff V - SP AusNet West - Residential"},{"$f":"INDEX(Prop2021DistTar!$F$30:$F$38,C$39)","v":145788.04402326143},{"$f":"INDEX(Prop2021DistTar!$F$30:$F$38,D$39)","v":1490194.007},{"$f":"INDEX(Prop2021DistTar!$F$30:$F$38,E$39)","v":1127296.4539999999},{"$f":"INDEX(Prop2021DistTar!$F$30:$F$38,F$39)","v":1736232.76},{"$f":"INDEX(Prop2021DistTar!$F$30:$F$38,G$39)","v":18296.895},{"$f":"INDEX(Prop2021DistTar!$F$30:$F$38,H$39)","v":1945311.1839999999},{"$f":"INDEX(Prop2021DistTar!$F$30:$F$38,I$39)","v":545685.51500000001},{"$f":"INDEX(Prop2021DistTar!$F$30:$F$38,J$39)","v":265994.98100000003},{"$f":"INDEX(Prop2021DistTar!$F$30:$F$38,K$39)","v":11826.136}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B79","v":"Existing : Tariff V - SP AusNet West - Residential"},{"$f":"INDEX(Prop2021DistTar!$H$30:$H$38,C$40)","v":19007553.603664782},{"$f":"INDEX(Prop2021DistTar!$H$30:$H$38,D$40)","v":6222156.0568277994},{"$f":"INDEX(Prop2021DistTar!$H$30:$H$38,E$40)","v":3373885.5571765997},{"$f":"INDEX(Prop2021DistTar!$H$30:$H$38,F$40)","v":1675464.6133999999},{"$f":"INDEX(Prop2021DistTar!$H$30:$H$38,G$40)","v":16909.990358999999},{"$f":"INDEX(Prop2021DistTar!$H$30:$H$38,H$40)","v":2547190.4643295999},{"$f":"INDEX(Prop2021DistTar!$H$30:$H$38,I$40)","v":672611.96578899992},{"$f":"INDEX(Prop2021DistTar!$H$30:$H$38,J$40)","v":185478.30025130004},{"$f":"INDEX(Prop2021DistTar!$H$30:$H$38,K$40)","v":1600.0762008000002}]
[]
[null,{"$f":"B81","v":"Proposed : Tariff V - SP AusNet West - Residential"},{"$f":"INDEX(Prop2021DistTar!$G$30:$G$38,C$39)","v":20529434.995223604},{"$f":"INDEX(Prop2021DistTar!$G$30:$G$38,D$39)","v":5548141.3074617004},{"$f":"INDEX(Prop2021DistTar!$G$30:$G$38,E$39)","v":3008416.0467897998},{"$f":"INDEX(Prop2021DistTar!$G$30:$G$38,F$39)","v":1494028.2899800001},{"$f":"INDEX(Prop2021DistTar!$G$30:$G$38,G$39)","v":15078.471169500001},{"$f":"INDEX(Prop2021DistTar!$G$30:$G$38,H$39)","v":2271345.3384383996},{"$f":"INDEX(Prop2021DistTar!$G$30:$G$38,I$39)","v":599762.94953650003},{"$f":"INDEX(Prop2021DistTar!$G$30:$G$38,J$39)","v":165395.67918580002},{"$f":"INDEX(Prop2021DistTar!$G$30:$G$38,K$39)","v":1426.2320016000001}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B85","v":"Existing : Tariff V - SP AusNet West - Residential"},{"$f":"SUM(C85:K85)","v":33702850.627998881}]
[null,{"$f":"B87","v":"Proposed : Tariff V - SP AusNet West - Residential"},{"$f":"SUM(C87:K87)","v":33633029.309786908}]
[]
[null,"Average price movement",{"$f":"IF(C91=0,\"\",C91/C90)","v":0.99792832603441661}]
[]
[null,{"$f":"IF(C93=\"\",\"\",IF(C93<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!B50","v":"Tariff V - Adjoining Central - Residential"},1,2,3,4,5,6,7,8,9]
[null,null,1,2,3,4,5,6,7,8,9]
[null,"Distribution tariff","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4"]
[]
[null,{"$f":"\"Existing : \"&Prop2021DistTar!C50","v":"Existing : Tariff V - Adjoining Central - Residential"},{"$f":"INDEX(Prop2021DistTar!$E$52:$E$60,C$40)","v":0.35720000000000002},{"$f":"INDEX(Prop2021DistTar!$E$52:$E$60,D$40)","v":11.1919},{"$f":"INDEX(Prop2021DistTar!$E$52:$E$60,E$40)","v":8.0535999999999994},{"$f":"INDEX(Prop2021DistTar!$E$52:$E$60,F$40)","v":2.8973},{"$f":"INDEX(Prop2021DistTar!$E$52:$E$60,G$40)","v":2.7591000000000001},{"$f":"INDEX(Prop2021DistTar!$E$52:$E$60,H$40)","v":5.2015000000000002},{"$f":"INDEX(Prop2021DistTar!$E$52:$E$60,I$40)","v":2.9384000000000001},{"$f":"INDEX(Prop2021DistTar!$E$52:$E$60,J$40)","v":2.5798999999999999},{"$f":"INDEX(Prop2021DistTar!$E$52:$E$60,K$40)","v":2.4563000000000001}]
[]
[null,{"$f":"\"Proposed : \"&B99","v":"Proposed : Tariff V - Adjoining Central - Residential"},{"$f":"INDEX(Prop2021DistTar!$D$52:$D$60,C$39)","v":0.38579999999999998},{"$f":"INDEX(Prop2021DistTar!$D$52:$D$60,D$39)","v":9.9795999999999996},{"$f":"INDEX(Prop2021DistTar!$D$52:$D$60,E$39)","v":7.1813000000000002},{"$f":"INDEX(Prop2021DistTar!$D$52:$D$60,F$39)","v":2.5834999999999999},{"$f":"INDEX(Prop2021DistTar!$D$52:$D$60,G$39)","v":2.4601999999999999},{"$f":"INDEX(Prop2021DistTar!$D$52:$D$60,H$39)","v":4.6380999999999997},{"$f":"INDEX(Prop2021DistTar!$D$52:$D$60,I$39)","v":2.6200999999999999},{"$f":"INDEX(Prop2021DistTar!$D$52:$D$60,J$39)","v":2.3005},{"$f":"INDEX(Prop2021DistTar!$D$52:$D$60,K$39)","v":2.1901999999999999}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B103","v":"Existing : Tariff V - Adjoining Central - Residential"},{"$f":"INDEX(Prop2021DistTar!$F$52:$F$60,C$39)","v":1764.9033232729714},{"$f":"INDEX(Prop2021DistTar!$F$52:$F$60,D$39)","v":15308.242},{"$f":"INDEX(Prop2021DistTar!$F$52:$F$60,E$39)","v":9827.4570000000003},{"$f":"INDEX(Prop2021DistTar!$F$52:$F$60,F$39)","v":12230.718999999999},{"$f":"INDEX(Prop2021DistTar!$F$52:$F$60,G$39)","v":551.20399999999995},{"$f":"INDEX(Prop2021DistTar!$F$52:$F$60,H$39)","v":17812.036},{"$f":"INDEX(Prop2021DistTar!$F$52:$F$60,I$39)","v":4596.0709999999999},{"$f":"INDEX(Prop2021DistTar!$F$52:$F$60,J$39)","v":2927.5819999999999},{"$f":"INDEX(Prop2021DistTar!$F$52:$F$60,K$39)","v":432.37}]
[]
[null,{"$f":"B105","v":"Proposed : Tariff V - Adjoining Central - Residential"},{"$f":"INDEX(Prop2021DistTar!$F$52:$F$60,C$39)","v":1764.9033232729714},{"$f":"INDEX(Prop2021DistTar!$F$52:$F$60,D$39)","v":15308.242},{"$f":"INDEX(Prop2021DistTar!$F$52:$F$60,E$39)","v":9827.4570000000003},{"$f":"INDEX(Prop2021DistTar!$F$52:$F$60,F$39)","v":12230.718999999999},{"$f":"INDEX(Prop2021DistTar!$F$52:$F$60,G$39)","v":551.20399999999995},{"$f":"INDEX(Prop2021DistTar!$F$52:$F$60,H$39)","v":17812.036},{"$f":"INDEX(Prop2021DistTar!$F$52:$F$60,I$39)","v":4596.0709999999999},{"$f":"INDEX(Prop2021DistTar!$F$52:$F$60,J$39)","v":2927.5819999999999},{"$f":"INDEX(Prop2021DistTar!$F$52:$F$60,K$39)","v":432.37}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B109","v":"Existing : Tariff V - Adjoining Central - Residential"},{"$f":"INDEX(Prop2021DistTar!$H$52:$H$60,C$40)","v":230104.56548168347},{"$f":"INDEX(Prop2021DistTar!$H$52:$H$60,D$40)","v":171328.31363980001},{"$f":"INDEX(Prop2021DistTar!$H$52:$H$60,E$40)","v":79146.407695200003},{"$f":"INDEX(Prop2021DistTar!$H$52:$H$60,F$40)","v":35436.062158699999},{"$f":"INDEX(Prop2021DistTar!$H$52:$H$60,G$40)","v":1520.8269564},{"$f":"INDEX(Prop2021DistTar!$H$52:$H$60,H$40)","v":92649.305254000006},{"$f":"INDEX(Prop2021DistTar!$H$52:$H$60,I$40)","v":13505.0950264},{"$f":"INDEX(Prop2021DistTar!$H$52:$H$60,J$40)","v":7552.8688017999993},{"$f":"INDEX(Prop2021DistTar!$H$52:$H$60,K$40)","v":1062.0304310000001}]
[]
[null,{"$f":"B111","v":"Proposed : Tariff V - Adjoining Central - Residential"},{"$f":"INDEX(Prop2021DistTar!$G$52:$G$60,C$39)","v":248528.39127332999},{"$f":"INDEX(Prop2021DistTar!$G$52:$G$60,D$39)","v":152770.13186319999},{"$f":"INDEX(Prop2021DistTar!$G$52:$G$60,E$39)","v":70573.916954100001},{"$f":"INDEX(Prop2021DistTar!$G$52:$G$60,F$39)","v":31598.062536499998},{"$f":"INDEX(Prop2021DistTar!$G$52:$G$60,G$39)","v":1356.0720807999999},{"$f":"INDEX(Prop2021DistTar!$G$52:$G$60,H$39)","v":82614.004171599998},{"$f":"INDEX(Prop2021DistTar!$G$52:$G$60,I$39)","v":12042.165627099999},{"$f":"INDEX(Prop2021DistTar!$G$52:$G$60,J$39)","v":6734.9023909999996},{"$f":"INDEX(Prop2021DistTar!$G$52:$G$60,K$39)","v":946.97677399999998}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B115","v":"Existing : Tariff V - Adjoining Central - Residential"},{"$f":"SUM(C115:K115)","v":632305.47544498357}]
[null,{"$f":"B117","v":"Proposed : Tariff V - Adjoining Central - Residential"},{"$f":"SUM(C117:K117)","v":607164.62367162993}]
[]
[null,"Average price movement",{"$f":"IF(C121=0,\"\",C121/C120)","v":0.96023938942540266}]
[]
[null,{"$f":"IF(C123=\"\",\"\",IF(C123<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!B72","v":"Tariff V - Adjoining West - Residential"},1,2,3,4,5,6,7,8,9]
[null,null,1,2,3,4,5,6,7,8,9]
[null,"Distribution tariff","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4"]
[]
[null,{"$f":"\"Existing : \"&Prop2021DistTar!C72","v":"Existing : Tariff V - Adjoining West - Residential"},{"$f":"INDEX(Prop2021DistTar!$E$74:$E$82,C$40)","v":0.35720000000000002},{"$f":"INDEX(Prop2021DistTar!$E$74:$E$82,D$40)","v":7.8132000000000001},{"$f":"INDEX(Prop2021DistTar!$E$74:$E$82,E$40)","v":6.5486000000000004},{"$f":"INDEX(Prop2021DistTar!$E$74:$E$82,F$40)","v":3.3784000000000001},{"$f":"INDEX(Prop2021DistTar!$E$74:$E$82,G$40)","v":3.0081000000000002},{"$f":"INDEX(Prop2021DistTar!$E$74:$E$82,H$40)","v":4.7481999999999998},{"$f":"INDEX(Prop2021DistTar!$E$74:$E$82,I$40)","v":3.5655999999999999},{"$f":"INDEX(Prop2021DistTar!$E$74:$E$82,J$40)","v":2.5472000000000001},{"$f":"INDEX(Prop2021DistTar!$E$74:$E$82,K$40)","v":2.4260000000000002}]
[]
[null,{"$f":"\"Proposed : \"&B129","v":"Proposed : Tariff V - Adjoining West - Residential"},{"$f":"INDEX(Prop2021DistTar!$D$74:$D$82,C$39)","v":0.38579999999999998},{"$f":"INDEX(Prop2021DistTar!$D$74:$D$82,D$39)","v":6.9668999999999999},{"$f":"INDEX(Prop2021DistTar!$D$74:$D$82,E$39)","v":5.8392999999999997},{"$f":"INDEX(Prop2021DistTar!$D$74:$D$82,F$39)","v":3.0125000000000002},{"$f":"INDEX(Prop2021DistTar!$D$74:$D$82,G$39)","v":2.6823000000000001},{"$f":"INDEX(Prop2021DistTar!$D$74:$D$82,H$39)","v":4.2339000000000002},{"$f":"INDEX(Prop2021DistTar!$D$74:$D$82,I$39)","v":3.1793999999999998},{"$f":"INDEX(Prop2021DistTar!$D$74:$D$82,J$39)","v":2.2713000000000001},{"$f":"INDEX(Prop2021DistTar!$D$74:$D$82,K$39)","v":2.1631999999999998}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B133","v":"Existing : Tariff V - Adjoining West - Residential"},{"$f":"INDEX(Prop2021DistTar!$F$74:$F$82,C$39)","v":10963.400305957612},{"$f":"INDEX(Prop2021DistTar!$F$74:$F$82,D$39)","v":110186.788},{"$f":"INDEX(Prop2021DistTar!$F$74:$F$82,E$39)","v":86785.596999999994},{"$f":"INDEX(Prop2021DistTar!$F$74:$F$82,F$39)","v":170960.25399999999},{"$f":"INDEX(Prop2021DistTar!$F$74:$F$82,G$39)","v":2129.2660000000001},{"$f":"INDEX(Prop2021DistTar!$F$74:$F$82,H$39)","v":142276.106},{"$f":"INDEX(Prop2021DistTar!$F$74:$F$82,I$39)","v":48758.250999999997},{"$f":"INDEX(Prop2021DistTar!$F$74:$F$82,J$39)","v":28729.171999999999},{"$f":"INDEX(Prop2021DistTar!$F$74:$F$82,K$39)","v":3641.8359999999998}]
[]
[null,{"$f":"B135","v":"Proposed : Tariff V - Adjoining West - Residential"},{"$f":"INDEX(Prop2021DistTar!$F$74:$F$82,C$39)","v":10963.400305957612},{"$f":"INDEX(Prop2021DistTar!$F$74:$F$82,D$39)","v":110186.788},{"$f":"INDEX(Prop2021DistTar!$F$74:$F$82,E$39)","v":86785.596999999994},{"$f":"INDEX(Prop2021DistTar!$F$74:$F$82,F$39)","v":170960.25399999999},{"$f":"INDEX(Prop2021DistTar!$F$74:$F$82,G$39)","v":2129.2660000000001},{"$f":"INDEX(Prop2021DistTar!$F$74:$F$82,H$39)","v":142276.106},{"$f":"INDEX(Prop2021DistTar!$F$74:$F$82,I$39)","v":48758.250999999997},{"$f":"INDEX(Prop2021DistTar!$F$74:$F$82,J$39)","v":28729.171999999999},{"$f":"INDEX(Prop2021DistTar!$F$74:$F$82,K$39)","v":3641.8359999999998}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B139","v":"Existing : Tariff V - Adjoining West - Residential"},{"$f":"INDEX(Prop2021DistTar!$H$74:$H$82,C$40)","v":1429386.2050901416},{"$f":"INDEX(Prop2021DistTar!$H$74:$H$82,D$40)","v":860911.41200160002},{"$f":"INDEX(Prop2021DistTar!$H$74:$H$82,E$40)","v":568324.16051419999},{"$f":"INDEX(Prop2021DistTar!$H$74:$H$82,F$40)","v":577572.12211359991},{"$f":"INDEX(Prop2021DistTar!$H$74:$H$82,G$40)","v":6405.0450546000011},{"$f":"INDEX(Prop2021DistTar!$H$74:$H$82,H$40)","v":675555.40650919999},{"$f":"INDEX(Prop2021DistTar!$H$74:$H$82,I$40)","v":173852.41976559997},{"$f":"INDEX(Prop2021DistTar!$H$74:$H$82,J$40)","v":73178.946918400005},{"$f":"INDEX(Prop2021DistTar!$H$74:$H$82,K$40)","v":8835.0941359999997}]
[]
[null,{"$f":"B141","v":"Proposed : Tariff V - Adjoining West - Residential"},{"$f":"INDEX(Prop2021DistTar!$G$74:$G$82,C$39)","v":1543833.1408840329},{"$f":"INDEX(Prop2021DistTar!$G$74:$G$82,D$39)","v":767660.33331719995},{"$f":"INDEX(Prop2021DistTar!$G$74:$G$82,E$39)","v":506767.13656209991},{"$f":"INDEX(Prop2021DistTar!$G$74:$G$82,F$39)","v":515017.76517500001},{"$f":"INDEX(Prop2021DistTar!$G$74:$G$82,G$39)","v":5711.3301918000006},{"$f":"INDEX(Prop2021DistTar!$G$74:$G$82,H$39)","v":602382.80519340001},{"$f":"INDEX(Prop2021DistTar!$G$74:$G$82,I$39)","v":155021.98322939998},{"$f":"INDEX(Prop2021DistTar!$G$74:$G$82,J$39)","v":65252.568363600003},{"$f":"INDEX(Prop2021DistTar!$G$74:$G$82,K$39)","v":7878.0196351999984}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B145","v":"Existing : Tariff V - Adjoining West - Residential"},{"$f":"SUM(C145:K145)","v":4374020.8121033413}]
[null,{"$f":"B147","v":"Proposed : Tariff V - Adjoining West - Residential"},{"$f":"SUM(C147:K147)","v":4169525.0825517327}]
[]
[null,"Average price movement",{"$f":"IF(C151=0,\"\",C151/C150)","v":0.95324765511271714}]
[]
[null,{"$f":"IF(C153=\"\",\"\",IF(C153<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!B17","v":"Tariff V - SP AusNet Central - Non Residential"},1,2,3,4,5]
[null,null,1,2,3,4,5,6,7,8,9]
[null,"Distribution tariff","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4"]
[]
[null,{"$f":"\"Existing : \"&Prop2021DistTar!C17","v":"Existing : Tariff V - SP AusNet Central - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$E$19:$E$27,C$40)","v":0.373},{"$f":"INDEX(Prop2021DistTar!$E$19:$E$27,D$40)","v":1.2476},{"$f":"INDEX(Prop2021DistTar!$E$19:$E$27,E$40)","v":1.1879999999999999},{"$f":"INDEX(Prop2021DistTar!$E$19:$E$27,F$40)","v":1.0625},{"$f":"INDEX(Prop2021DistTar!$E$19:$E$27,G$40)","v":0.7974},{"$f":"INDEX(Prop2021DistTar!$E$19:$E$27,H$40)","v":1.1842999999999999},{"$f":"INDEX(Prop2021DistTar!$E$19:$E$27,I$40)","v":0.82830000000000004},{"$f":"INDEX(Prop2021DistTar!$E$19:$E$27,J$40)","v":0.6845},{"$f":"INDEX(Prop2021DistTar!$E$19:$E$27,K$40)","v":0.65159999999999996}]
[]
[null,{"$f":"\"Proposed : \"&B159","v":"Proposed : Tariff V - SP AusNet Central - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$D$19:$D$27,C$39)","v":0.40279999999999999},{"$f":"INDEX(Prop2021DistTar!$D$19:$D$27,D$39)","v":1.1125},{"$f":"INDEX(Prop2021DistTar!$D$19:$D$27,E$39)","v":1.0592999999999999},{"$f":"INDEX(Prop2021DistTar!$D$19:$D$27,F$39)","v":0.94740000000000002},{"$f":"INDEX(Prop2021DistTar!$D$19:$D$27,G$39)","v":0.71099999999999997},{"$f":"INDEX(Prop2021DistTar!$D$19:$D$27,H$39)","v":1.056},{"$f":"INDEX(Prop2021DistTar!$D$19:$D$27,I$39)","v":0.73860000000000003},{"$f":"INDEX(Prop2021DistTar!$D$19:$D$27,J$39)","v":0.61040000000000005},{"$f":"INDEX(Prop2021DistTar!$D$19:$D$27,K$39)","v":0.58099999999999996}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B163","v":"Existing : Tariff V - SP AusNet Central - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$F$19:$F$27,C$39)","v":10219.748128115862},{"$f":"INDEX(Prop2021DistTar!$F$19:$F$27,D$39)","v":94487.953999999998},{"$f":"INDEX(Prop2021DistTar!$F$19:$F$27,E$39)","v":78714.222999999998},{"$f":"INDEX(Prop2021DistTar!$F$19:$F$27,F$39)","v":479726.81099999999},{"$f":"INDEX(Prop2021DistTar!$F$19:$F$27,G$39)","v":1262355.5449999999},{"$f":"INDEX(Prop2021DistTar!$F$19:$F$27,H$39)","v":161888.78400000001},{"$f":"INDEX(Prop2021DistTar!$F$19:$F$27,I$39)","v":114613.47500000001},{"$f":"INDEX(Prop2021DistTar!$F$19:$F$27,J$39)","v":690621.18},{"$f":"INDEX(Prop2021DistTar!$F$19:$F$27,K$39)","v":1479380.2609999999}]
[]
[null,{"$f":"B165","v":"Proposed : Tariff V - SP AusNet Central - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$F$19:$F$27,C$39)","v":10219.748128115862},{"$f":"INDEX(Prop2021DistTar!$F$19:$F$27,D$39)","v":94487.953999999998},{"$f":"INDEX(Prop2021DistTar!$F$19:$F$27,E$39)","v":78714.222999999998},{"$f":"INDEX(Prop2021DistTar!$F$19:$F$27,F$39)","v":479726.81099999999},{"$f":"INDEX(Prop2021DistTar!$F$19:$F$27,G$39)","v":1262355.5449999999},{"$f":"INDEX(Prop2021DistTar!$F$19:$F$27,H$39)","v":161888.78400000001},{"$f":"INDEX(Prop2021DistTar!$F$19:$F$27,I$39)","v":114613.47500000001},{"$f":"INDEX(Prop2021DistTar!$F$19:$F$27,J$39)","v":690621.18},{"$f":"INDEX(Prop2021DistTar!$F$19:$F$27,K$39)","v":1479380.2609999999}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B169","v":"Existing : Tariff V - SP AusNet Central - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$H$19:$H$27,C$40)","v":1391367.608902334},{"$f":"INDEX(Prop2021DistTar!$H$19:$H$27,D$40)","v":117883.1714104},{"$f":"INDEX(Prop2021DistTar!$H$19:$H$27,E$40)","v":93512.496923999992},{"$f":"INDEX(Prop2021DistTar!$H$19:$H$27,F$40)","v":509709.73668749997},{"$f":"INDEX(Prop2021DistTar!$H$19:$H$27,G$40)","v":1006602.3115829999},{"$f":"INDEX(Prop2021DistTar!$H$19:$H$27,H$40)","v":191724.8868912},{"$f":"INDEX(Prop2021DistTar!$H$19:$H$27,I$40)","v":94934.341342500004},{"$f":"INDEX(Prop2021DistTar!$H$19:$H$27,J$40)","v":472730.19771000004},{"$f":"INDEX(Prop2021DistTar!$H$19:$H$27,K$40)","v":963964.17806759989}]
[]
[null,{"$f":"B171","v":"Proposed : Tariff V - SP AusNet Central - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$G$19:$G$27,C$39)","v":1502527.8092918501},{"$f":"INDEX(Prop2021DistTar!$G$19:$G$27,D$39)","v":105117.84882500001},{"$f":"INDEX(Prop2021DistTar!$G$19:$G$27,E$39)","v":83381.976423899992},{"$f":"INDEX(Prop2021DistTar!$G$19:$G$27,F$39)","v":454493.18074139999},{"$f":"INDEX(Prop2021DistTar!$G$19:$G$27,G$39)","v":897534.79249499994},{"$f":"INDEX(Prop2021DistTar!$G$19:$G$27,H$39)","v":170954.55590400004},{"$f":"INDEX(Prop2021DistTar!$G$19:$G$27,I$39)","v":84653.512635000006},{"$f":"INDEX(Prop2021DistTar!$G$19:$G$27,J$39)","v":421555.1682720001},{"$f":"INDEX(Prop2021DistTar!$G$19:$G$27,K$39)","v":859519.93164099986}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B175","v":"Existing : Tariff V - SP AusNet Central - Non Residential"},{"$f":"SUM(C175:K175)","v":4842428.9295185339}]
[null,{"$f":"B177","v":"Proposed : Tariff V - SP AusNet Central - Non Residential"},{"$f":"SUM(C177:K177)","v":4579738.7762291506}]
[]
[null,"Average price movement",{"$f":"IF(C181=0,\"\",C181/C180)","v":0.94575239882446727}]
[]
[null,{"$f":"IF(C183=\"\",\"\",IF(C183<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!B39","v":"Tariff V - SP AusNet West - Non Residential"},1,2,3,4,5]
[null,null,1,2,3,4,5,6,7,8,9]
[null,"Distribution tariff","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4"]
[]
[null,{"$f":"\"Existing : \"&Prop2021DistTar!C39","v":"Existing : Tariff V - SP AusNet West - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$E$41:$E$49,C$40)","v":0.373},{"$f":"INDEX(Prop2021DistTar!$E$41:$E$49,D$40)","v":2.0428999999999999},{"$f":"INDEX(Prop2021DistTar!$E$41:$E$49,E$40)","v":1.7203999999999999},{"$f":"INDEX(Prop2021DistTar!$E$41:$E$49,F$40)","v":1.0548999999999999},{"$f":"INDEX(Prop2021DistTar!$E$41:$E$49,G$40)","v":0.38779999999999998},{"$f":"INDEX(Prop2021DistTar!$E$41:$E$49,H$40)","v":0.94930000000000003},{"$f":"INDEX(Prop2021DistTar!$E$41:$E$49,I$40)","v":0.79959999999999998},{"$f":"INDEX(Prop2021DistTar!$E$41:$E$49,J$40)","v":0.38779999999999998},{"$f":"INDEX(Prop2021DistTar!$E$41:$E$49,K$40)","v":0.2863}]
[]
[null,{"$f":"\"Proposed : \"&B189","v":"Proposed : Tariff V - SP AusNet West - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$D$41:$D$49,C$39)","v":0.40279999999999999},{"$f":"INDEX(Prop2021DistTar!$D$41:$D$49,D$39)","v":1.8216000000000001},{"$f":"INDEX(Prop2021DistTar!$D$41:$D$49,E$39)","v":1.5341},{"$f":"INDEX(Prop2021DistTar!$D$41:$D$49,F$39)","v":0.94059999999999999},{"$f":"INDEX(Prop2021DistTar!$D$41:$D$49,G$39)","v":0.3458},{"$f":"INDEX(Prop2021DistTar!$D$41:$D$49,H$39)","v":0.84650000000000003},{"$f":"INDEX(Prop2021DistTar!$D$41:$D$49,I$39)","v":0.71299999999999997},{"$f":"INDEX(Prop2021DistTar!$D$41:$D$49,J$39)","v":0.3458},{"$f":"INDEX(Prop2021DistTar!$D$41:$D$49,K$39)","v":0.25530000000000003}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B193","v":"Existing : Tariff V - SP AusNet West - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$F$41:$F$49,C$39)","v":6075.2722108130229},{"$f":"INDEX(Prop2021DistTar!$F$41:$F$49,D$39)","v":50926.353999999999},{"$f":"INDEX(Prop2021DistTar!$F$41:$F$49,E$39)","v":40136.322},{"$f":"INDEX(Prop2021DistTar!$F$41:$F$49,F$39)","v":217624.77600000001},{"$f":"INDEX(Prop2021DistTar!$F$41:$F$49,G$39)","v":500556.94300000003},{"$f":"INDEX(Prop2021DistTar!$F$41:$F$49,H$39)","v":77537.567999999999},{"$f":"INDEX(Prop2021DistTar!$F$41:$F$49,I$39)","v":49031.339},{"$f":"INDEX(Prop2021DistTar!$F$41:$F$49,J$39)","v":260756.022},{"$f":"INDEX(Prop2021DistTar!$F$41:$F$49,K$39)","v":513975.78499999997}]
[]
[null,{"$f":"B195","v":"Proposed : Tariff V - SP AusNet West - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$F$41:$F$49,C$39)","v":6075.2722108130229},{"$f":"INDEX(Prop2021DistTar!$F$41:$F$49,D$39)","v":50926.353999999999},{"$f":"INDEX(Prop2021DistTar!$F$41:$F$49,E$39)","v":40136.322},{"$f":"INDEX(Prop2021DistTar!$F$41:$F$49,F$39)","v":217624.77600000001},{"$f":"INDEX(Prop2021DistTar!$F$41:$F$49,G$39)","v":500556.94300000003},{"$f":"INDEX(Prop2021DistTar!$F$41:$F$49,H$39)","v":77537.567999999999},{"$f":"INDEX(Prop2021DistTar!$F$41:$F$49,I$39)","v":49031.339},{"$f":"INDEX(Prop2021DistTar!$F$41:$F$49,J$39)","v":260756.022},{"$f":"INDEX(Prop2021DistTar!$F$41:$F$49,K$39)","v":513975.78499999997}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B199","v":"Existing : Tariff V - SP AusNet West - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$H$41:$H$49,C$40)","v":827117.93514113897},{"$f":"INDEX(Prop2021DistTar!$H$41:$H$49,D$40)","v":104037.44858659999},{"$f":"INDEX(Prop2021DistTar!$H$41:$H$49,E$40)","v":69050.528368799991},{"$f":"INDEX(Prop2021DistTar!$H$41:$H$49,F$40)","v":229572.37620239999},{"$f":"INDEX(Prop2021DistTar!$H$41:$H$49,G$40)","v":194115.98249540001},{"$f":"INDEX(Prop2021DistTar!$H$41:$H$49,H$40)","v":73606.413302400004},{"$f":"INDEX(Prop2021DistTar!$H$41:$H$49,I$40)","v":39205.458664400001},{"$f":"INDEX(Prop2021DistTar!$H$41:$H$49,J$40)","v":101121.18533159999},{"$f":"INDEX(Prop2021DistTar!$H$41:$H$49,K$40)","v":147151.2672455}]
[]
[null,{"$f":"B201","v":"Proposed : Tariff V - SP AusNet West - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$G$41:$G$49,C$39)","v":893198.67097815231},{"$f":"INDEX(Prop2021DistTar!$G$41:$G$49,D$39)","v":92767.446446400005},{"$f":"INDEX(Prop2021DistTar!$G$41:$G$49,E$39)","v":61573.131580200003},{"$f":"INDEX(Prop2021DistTar!$G$41:$G$49,F$39)","v":204697.8643056},{"$f":"INDEX(Prop2021DistTar!$G$41:$G$49,G$39)","v":173092.59088940002},{"$f":"INDEX(Prop2021DistTar!$G$41:$G$49,H$39)","v":65635.551311999996},{"$f":"INDEX(Prop2021DistTar!$G$41:$G$49,I$39)","v":34959.344706999997},{"$f":"INDEX(Prop2021DistTar!$G$41:$G$49,J$39)","v":90169.432407600005},{"$f":"INDEX(Prop2021DistTar!$G$41:$G$49,K$39)","v":131218.0179105}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B205","v":"Existing : Tariff V - SP AusNet West - Non Residential"},{"$f":"SUM(C205:K205)","v":1784978.5953382389}]
[null,{"$f":"B207","v":"Proposed : Tariff V - SP AusNet West - Non Residential"},{"$f":"SUM(C207:K207)","v":1747312.0505368528}]
[]
[null,"Average price movement",{"$f":"IF(C211=0,\"\",C211/C210)","v":0.97889804118673562}]
[]
[null,{"$f":"IF(C213=\"\",\"\",IF(C213<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!B61","v":"Tariff V - Adjoining Central - Non Residential"},1,2,3,4,5]
[null,null,1,2,3,4,5,6,7,8,9]
[null,"Distribution tariff","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4"]
[]
[null,{"$f":"\"Existing : \"&Prop2021DistTar!C61","v":"Existing : Tariff V - Adjoining Central - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$E$63:$E$71,C$40)","v":0.373},{"$f":"INDEX(Prop2021DistTar!$E$63:$E$71,D$40)","v":4.6818},{"$f":"INDEX(Prop2021DistTar!$E$63:$E$71,E$40)","v":4.4585999999999997},{"$f":"INDEX(Prop2021DistTar!$E$63:$E$71,F$40)","v":3.9662000000000002},{"$f":"INDEX(Prop2021DistTar!$E$63:$E$71,G$40)","v":3.7658},{"$f":"INDEX(Prop2021DistTar!$E$63:$E$71,H$40)","v":4.1692},{"$f":"INDEX(Prop2021DistTar!$E$63:$E$71,I$40)","v":3.9588000000000001},{"$f":"INDEX(Prop2021DistTar!$E$63:$E$71,J$40)","v":3.7660999999999998},{"$f":"INDEX(Prop2021DistTar!$E$63:$E$71,K$40)","v":3.5863999999999998}]
[]
[null,{"$f":"\"Proposed : \"&B219","v":"Proposed : Tariff V - Adjoining Central - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$D$63:$D$71,C$39)","v":0.40279999999999999},{"$f":"INDEX(Prop2021DistTar!$D$63:$D$71,D$39)","v":4.1746999999999996},{"$f":"INDEX(Prop2021DistTar!$D$63:$D$71,E$39)","v":3.9756999999999998},{"$f":"INDEX(Prop2021DistTar!$D$63:$D$71,F$39)","v":3.5366},{"$f":"INDEX(Prop2021DistTar!$D$63:$D$71,G$39)","v":3.3578999999999999},{"$f":"INDEX(Prop2021DistTar!$D$63:$D$71,H$39)","v":3.7176},{"$f":"INDEX(Prop2021DistTar!$D$63:$D$71,I$39)","v":3.53},{"$f":"INDEX(Prop2021DistTar!$D$63:$D$71,J$39)","v":3.3582000000000001},{"$f":"INDEX(Prop2021DistTar!$D$63:$D$71,K$39)","v":3.1979000000000002}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B223","v":"Existing : Tariff V - Adjoining Central - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$F$63:$F$71,C$39)","v":15.581605321148968},{"$f":"INDEX(Prop2021DistTar!$F$63:$F$71,D$39)","v":186.23599999999999},{"$f":"INDEX(Prop2021DistTar!$F$63:$F$71,E$39)","v":157.434},{"$f":"INDEX(Prop2021DistTar!$F$63:$F$71,F$39)","v":798.10299999999995},{"$f":"INDEX(Prop2021DistTar!$F$63:$F$71,G$39)","v":306.262},{"$f":"INDEX(Prop2021DistTar!$F$63:$F$71,H$39)","v":274.83699999999999},{"$f":"INDEX(Prop2021DistTar!$F$63:$F$71,I$39)","v":178.9},{"$f":"INDEX(Prop2021DistTar!$F$63:$F$71,J$39)","v":1471.7},{"$f":"INDEX(Prop2021DistTar!$F$63:$F$71,K$39)","v":538.69899999999996}]
[]
[null,{"$f":"B225","v":"Proposed : Tariff V - Adjoining Central - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$F$63:$F$71,C$39)","v":15.581605321148968},{"$f":"INDEX(Prop2021DistTar!$F$63:$F$71,D$39)","v":186.23599999999999},{"$f":"INDEX(Prop2021DistTar!$F$63:$F$71,E$39)","v":157.434},{"$f":"INDEX(Prop2021DistTar!$F$63:$F$71,F$39)","v":798.10299999999995},{"$f":"INDEX(Prop2021DistTar!$F$63:$F$71,G$39)","v":306.262},{"$f":"INDEX(Prop2021DistTar!$F$63:$F$71,H$39)","v":274.83699999999999},{"$f":"INDEX(Prop2021DistTar!$F$63:$F$71,I$39)","v":178.9},{"$f":"INDEX(Prop2021DistTar!$F$63:$F$71,J$39)","v":1471.7},{"$f":"INDEX(Prop2021DistTar!$F$63:$F$71,K$39)","v":538.69899999999996}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B229","v":"Existing : Tariff V - Adjoining Central - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$H$63:$H$71,C$40)","v":2121.3576564478262},{"$f":"INDEX(Prop2021DistTar!$H$63:$H$71,D$40)","v":871.91970479999998},{"$f":"INDEX(Prop2021DistTar!$H$63:$H$71,E$40)","v":701.9352323999999},{"$f":"INDEX(Prop2021DistTar!$H$63:$H$71,F$40)","v":3165.4361186000001},{"$f":"INDEX(Prop2021DistTar!$H$63:$H$71,G$40)","v":1153.3214396000001},{"$f":"INDEX(Prop2021DistTar!$H$63:$H$71,H$40)","v":1145.8504203999998},{"$f":"INDEX(Prop2021DistTar!$H$63:$H$71,I$40)","v":708.22932000000003},{"$f":"INDEX(Prop2021DistTar!$H$63:$H$71,J$40)","v":5542.5693700000002},{"$f":"INDEX(Prop2021DistTar!$H$63:$H$71,K$40)","v":1931.9900935999997}]
[]
[null,{"$f":"B231","v":"Proposed : Tariff V - Adjoining Central - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$G$63:$G$71,C$39)","v":2290.8387775259635},{"$f":"INDEX(Prop2021DistTar!$G$63:$G$71,D$39)","v":777.47942919999991},{"$f":"INDEX(Prop2021DistTar!$G$63:$G$71,E$39)","v":625.91035379999994},{"$f":"INDEX(Prop2021DistTar!$G$63:$G$71,F$39)","v":2822.5710697999998},{"$f":"INDEX(Prop2021DistTar!$G$63:$G$71,G$39)","v":1028.3971698},{"$f":"INDEX(Prop2021DistTar!$G$63:$G$71,H$39)","v":1021.7340312},{"$f":"INDEX(Prop2021DistTar!$G$63:$G$71,I$39)","v":631.51699999999994},{"$f":"INDEX(Prop2021DistTar!$G$63:$G$71,J$39)","v":4942.2629400000005},{"$f":"INDEX(Prop2021DistTar!$G$63:$G$71,K$39)","v":1722.7055321}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B235","v":"Existing : Tariff V - Adjoining Central - Non Residential"},{"$f":"SUM(C235:K235)","v":17342.609355847828}]
[null,{"$f":"B237","v":"Proposed : Tariff V - Adjoining Central - Non Residential"},{"$f":"SUM(C237:K237)","v":15863.416303425964}]
[]
[null,"Average price movement",{"$f":"IF(C241=0,\"\",C241/C240)","v":0.91470758395863372}]
[]
[null,{"$f":"IF(C243=\"\",\"\",IF(C243<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!B83","v":"Tariff V - Adjoining West - Non Residential"},1,2,3,4,5]
[null,null,1,2,3,4,5,6,7,8,9]
[null,"Distribution tariff","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4"]
[]
[null,{"$f":"\"Existing : \"&Prop2021DistTar!C83","v":"Existing : Tariff V - Adjoining West - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$E$85:$E$93,C$40)","v":0.373},{"$f":"INDEX(Prop2021DistTar!$E$85:$E$93,D$40)","v":5.5326000000000004},{"$f":"INDEX(Prop2021DistTar!$E$85:$E$93,E$40)","v":5.1878000000000002},{"$f":"INDEX(Prop2021DistTar!$E$85:$E$93,F$40)","v":4.3596000000000004},{"$f":"INDEX(Prop2021DistTar!$E$85:$E$93,G$40)","v":3.7195},{"$f":"INDEX(Prop2021DistTar!$E$85:$E$93,H$40)","v":4.2583000000000002},{"$f":"INDEX(Prop2021DistTar!$E$85:$E$93,I$40)","v":4.0553999999999997},{"$f":"INDEX(Prop2021DistTar!$E$85:$E$93,J$40)","v":3.5182000000000002},{"$f":"INDEX(Prop2021DistTar!$E$85:$E$93,K$40)","v":3.3121999999999998}]
[]
[null,{"$f":"\"Proposed : \"&B249","v":"Proposed : Tariff V - Adjoining West - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$D$85:$D$93,C$39)","v":0.40279999999999999},{"$f":"INDEX(Prop2021DistTar!$D$85:$D$93,D$39)","v":4.9333},{"$f":"INDEX(Prop2021DistTar!$D$85:$D$93,E$39)","v":4.6258999999999997},{"$f":"INDEX(Prop2021DistTar!$D$85:$D$93,F$39)","v":3.8874},{"$f":"INDEX(Prop2021DistTar!$D$85:$D$93,G$39)","v":3.3166000000000002},{"$f":"INDEX(Prop2021DistTar!$D$85:$D$93,H$39)","v":3.7970999999999999},{"$f":"INDEX(Prop2021DistTar!$D$85:$D$93,I$39)","v":3.6160999999999999},{"$f":"INDEX(Prop2021DistTar!$D$85:$D$93,J$39)","v":3.1371000000000002},{"$f":"INDEX(Prop2021DistTar!$D$85:$D$93,K$39)","v":2.9533999999999998}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B253","v":"Existing : Tariff V - Adjoining West - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$F$85:$F$93,C$39)","v":276.71714011396222},{"$f":"INDEX(Prop2021DistTar!$F$85:$F$93,D$39)","v":2817.0439999999999},{"$f":"INDEX(Prop2021DistTar!$F$85:$F$93,E$39)","v":2316.364},{"$f":"INDEX(Prop2021DistTar!$F$85:$F$93,F$39)","v":13900.484},{"$f":"INDEX(Prop2021DistTar!$F$85:$F$93,G$39)","v":29449.126},{"$f":"INDEX(Prop2021DistTar!$F$85:$F$93,H$39)","v":4607.3789999999999},{"$f":"INDEX(Prop2021DistTar!$F$85:$F$93,I$39)","v":3420.018},{"$f":"INDEX(Prop2021DistTar!$F$85:$F$93,J$39)","v":20040.642},{"$f":"INDEX(Prop2021DistTar!$F$85:$F$93,K$39)","v":30968.370999999999}]
[]
[null,{"$f":"B255","v":"Proposed : Tariff V - Adjoining West - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$F$85:$F$93,C$39)","v":276.71714011396222},{"$f":"INDEX(Prop2021DistTar!$F$85:$F$93,D$39)","v":2817.0439999999999},{"$f":"INDEX(Prop2021DistTar!$F$85:$F$93,E$39)","v":2316.364},{"$f":"INDEX(Prop2021DistTar!$F$85:$F$93,F$39)","v":13900.484},{"$f":"INDEX(Prop2021DistTar!$F$85:$F$93,G$39)","v":29449.126},{"$f":"INDEX(Prop2021DistTar!$F$85:$F$93,H$39)","v":4607.3789999999999},{"$f":"INDEX(Prop2021DistTar!$F$85:$F$93,I$39)","v":3420.018},{"$f":"INDEX(Prop2021DistTar!$F$85:$F$93,J$39)","v":20040.642},{"$f":"INDEX(Prop2021DistTar!$F$85:$F$93,K$39)","v":30968.370999999999}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B259","v":"Existing : Tariff V - Adjoining West - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$H$85:$H$93,C$40)","v":37673.655040815385},{"$f":"INDEX(Prop2021DistTar!$H$85:$H$93,D$40)","v":15585.577634400001},{"$f":"INDEX(Prop2021DistTar!$H$85:$H$93,E$40)","v":12016.833159200001},{"$f":"INDEX(Prop2021DistTar!$H$85:$H$93,F$40)","v":60600.550046400007},{"$f":"INDEX(Prop2021DistTar!$H$85:$H$93,G$40)","v":109536.02415700001},{"$f":"INDEX(Prop2021DistTar!$H$85:$H$93,H$40)","v":19619.601995699999},{"$f":"INDEX(Prop2021DistTar!$H$85:$H$93,I$40)","v":13869.5409972},{"$f":"INDEX(Prop2021DistTar!$H$85:$H$93,J$40)","v":70506.986684400006},{"$f":"INDEX(Prop2021DistTar!$H$85:$H$93,K$40)","v":102573.43842619999}]
[]
[null,{"$f":"B261","v":"Proposed : Tariff V - Adjoining West - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$G$85:$G$93,C$39)","v":40683.507373834953},{"$f":"INDEX(Prop2021DistTar!$G$85:$G$93,D$39)","v":13897.323165199999},{"$f":"INDEX(Prop2021DistTar!$G$85:$G$93,E$39)","v":10715.2682276},{"$f":"INDEX(Prop2021DistTar!$G$85:$G$93,F$39)","v":54036.741501600001},{"$f":"INDEX(Prop2021DistTar!$G$85:$G$93,G$39)","v":97670.971291600014},{"$f":"INDEX(Prop2021DistTar!$G$85:$G$93,H$39)","v":17494.678800900001},{"$f":"INDEX(Prop2021DistTar!$G$85:$G$93,I$39)","v":12367.1270898},{"$f":"INDEX(Prop2021DistTar!$G$85:$G$93,J$39)","v":62869.498018200007},{"$f":"INDEX(Prop2021DistTar!$G$85:$G$93,K$39)","v":91461.986911399988}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B265","v":"Existing : Tariff V - Adjoining West - Non Residential"},{"$f":"SUM(C265:K265)","v":441982.20814131544}]
[null,{"$f":"B267","v":"Proposed : Tariff V - Adjoining West - Non Residential"},{"$f":"SUM(C267:K267)","v":401197.10238013498}]
[]
[null,"Average price movement",{"$f":"IF(C271=0,\"\",C271/C270)","v":0.90772229060374265}]
[]
[null,{"$f":"IF(C273=\"\",\"\",IF(C273<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!B95","v":"Tariff M - SP AusNet Central"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2021DistTar!C95","v":"Existing: Tariff M - SP AusNet Central"},{"$f":"INDEX(Prop2021DistTar!$E$96:$E$98,C280)","v":693.98429999999996},{"$f":"INDEX(Prop2021DistTar!$E$96:$E$98,D280)","v":660.96220000000005},{"$f":"INDEX(Prop2021DistTar!$E$96:$E$98,E280)","v":138.0103}]
[null,{"$f":"\"Proposed: \"&B279","v":"Proposed: Tariff M - SP AusNet Central"},{"$f":"INDEX(Prop2021DistTar!$D$96:$D$98,C280)","v":680.0702},{"$f":"INDEX(Prop2021DistTar!$D$96:$D$98,D280)","v":647.71019999999999},{"$f":"INDEX(Prop2021DistTar!$D$96:$D$98,E280)","v":135.2432}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B282","v":"Existing: Tariff M - SP AusNet Central"},{"$f":"INDEX(Prop2021DistTar!$F$96:$F$98,C$280)","v":161.61999999999998},{"$f":"INDEX(Prop2021DistTar!$F$96:$F$98,D$280)","v":52.8},{"$f":"INDEX(Prop2021DistTar!$F$96:$F$98,E$280)","v":0}]
[null,{"$f":"B283","v":"Proposed: Tariff M - SP AusNet Central"},{"$f":"INDEX(Prop2021DistTar!$F$96:$F$98,C$280)","v":161.61999999999998},{"$f":"INDEX(Prop2021DistTar!$F$96:$F$98,D$280)","v":52.8},{"$f":"INDEX(Prop2021DistTar!$F$96:$F$98,E$280)","v":0}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B286","v":"Existing: Tariff M - SP AusNet Central"},{"$f":"INDEX(Prop2021DistTar!$H$96:$H$98,C280)","v":112161.74256599997},{"$f":"INDEX(Prop2021DistTar!$H$96:$H$98,D280)","v":34898.80416},{"$f":"INDEX(Prop2021DistTar!$H$96:$H$98,E280)","v":0}]
[null,{"$f":"B287","v":"Proposed: Tariff M - SP AusNet Central"},{"$f":"INDEX(Prop2021DistTar!$G$96:$G$98,C280)","v":109912.94572399999},{"$f":"INDEX(Prop2021DistTar!$G$96:$G$98,D280)","v":34199.098559999999},{"$f":"INDEX(Prop2021DistTar!$G$96:$G$98,E280)","v":0}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B290","v":"Existing: Tariff M - SP AusNet Central"},{"$f":"SUM(C290:E290)","v":147060.54672599997}]
[null,{"$f":"B291","v":"Proposed: Tariff M - SP AusNet Central"},{"$f":"SUM(C291:E291)","v":144112.044284}]
[]
[null,"Average price movement",{"$f":"IF(C295=0,\"\",C295/C294)","v":0.9799504183301212}]
[]
[null,{"$f":"IF(C297=\"\",\"\",IF(C297<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!B100","v":"Tariff M - SP AusNet West"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2021DistTar!C100","v":"Existing: Tariff M - SP AusNet West"},{"$f":"INDEX(Prop2021DistTar!$E$101:$E$103,C304)","v":693.98429999999996},{"$f":"INDEX(Prop2021DistTar!$E$101:$E$103,D304)","v":660.96220000000005},{"$f":"INDEX(Prop2021DistTar!$E$101:$E$103,E304)","v":138.0103}]
[null,{"$f":"\"Proposed: \"&B303","v":"Proposed: Tariff M - SP AusNet West"},{"$f":"INDEX(Prop2021DistTar!$D$101:$D$103,C304)","v":680.0702},{"$f":"INDEX(Prop2021DistTar!$D$101:$D$103,D304)","v":647.71019999999999},{"$f":"INDEX(Prop2021DistTar!$D$101:$D$103,E304)","v":135.2432}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B306","v":"Existing: Tariff M - SP AusNet West"},{"$f":"INDEX(Prop2021DistTar!$F$101:$F$103,C$280)","v":28.7},{"$f":"INDEX(Prop2021DistTar!$F$101:$F$103,D$280)","v":24.560000000000002},{"$f":"INDEX(Prop2021DistTar!$F$101:$F$103,E$280)","v":0}]
[null,{"$f":"B307","v":"Proposed: Tariff M - SP AusNet West"},{"$f":"INDEX(Prop2021DistTar!$F$101:$F$103,C$280)","v":28.7},{"$f":"INDEX(Prop2021DistTar!$F$101:$F$103,D$280)","v":24.560000000000002},{"$f":"INDEX(Prop2021DistTar!$F$101:$F$103,E$280)","v":0}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B310","v":"Existing: Tariff M - SP AusNet West"},{"$f":"INDEX(Prop2021DistTar!$H$101:$H$103,C304)","v":19917.349409999999},{"$f":"INDEX(Prop2021DistTar!$H$101:$H$103,D304)","v":16233.231632000003},{"$f":"INDEX(Prop2021DistTar!$H$101:$H$103,E304)","v":0}]
[null,{"$f":"B311","v":"Proposed: Tariff M - SP AusNet West"},{"$f":"INDEX(Prop2021DistTar!$G$101:$G$103,C304)","v":19518.014739999999},{"$f":"INDEX(Prop2021DistTar!$G$101:$G$103,D304)","v":15907.762512000001},{"$f":"INDEX(Prop2021DistTar!$G$101:$G$103,E304)","v":0}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B314","v":"Existing: Tariff M - SP AusNet West"},{"$f":"SUM(C314:E314)","v":36150.581042000005}]
[null,{"$f":"B315","v":"Proposed: Tariff M - SP AusNet West"},{"$f":"SUM(C315:E315)","v":35425.777252}]
[]
[null,"Average price movement",{"$f":"IF(C319=0,\"\",C319/C318)","v":0.97995042488645134}]
[]
[null,{"$f":"IF(C321=\"\",\"\",IF(C321<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!B105","v":"Tariff M - Adjoining Central"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2021DistTar!C105","v":"Existing: Tariff M - Adjoining Central"},{"$f":"INDEX(Prop2021DistTar!$E$106:$E$108,C328)","v":693.98429999999996},{"$f":"INDEX(Prop2021DistTar!$E$106:$E$108,D328)","v":660.96220000000005},{"$f":"INDEX(Prop2021DistTar!$E$106:$E$108,E328)","v":138.0103}]
[null,{"$f":"\"Proposed: \"&B327","v":"Proposed: Tariff M - Adjoining Central"},{"$f":"INDEX(Prop2021DistTar!$D$106:$D$108,C328)","v":680.0702},{"$f":"INDEX(Prop2021DistTar!$D$106:$D$108,D328)","v":647.71019999999999},{"$f":"INDEX(Prop2021DistTar!$D$106:$D$108,E328)","v":135.2432}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B330","v":"Existing: Tariff M - Adjoining Central"},{"$f":"INDEX(Prop2021DistTar!$F$106:$F$108,C$280)","v":0},{"$f":"INDEX(Prop2021DistTar!$F$106:$F$108,D$280)","v":0},{"$f":"INDEX(Prop2021DistTar!$F$106:$F$108,E$280)","v":0}]
[null,{"$f":"B331","v":"Proposed: Tariff M - Adjoining Central"},{"$f":"INDEX(Prop2021DistTar!$F$106:$F$108,C$280)","v":0},{"$f":"INDEX(Prop2021DistTar!$F$106:$F$108,D$280)","v":0},{"$f":"INDEX(Prop2021DistTar!$F$106:$F$108,E$280)","v":0}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B334","v":"Existing: Tariff M - Adjoining Central"},{"$f":"INDEX(Prop2021DistTar!$H$106:$H$108,C328)","v":0},{"$f":"INDEX(Prop2021DistTar!$H$106:$H$108,D328)","v":0},{"$f":"INDEX(Prop2021DistTar!$H$106:$H$108,E328)","v":0}]
[null,{"$f":"B335","v":"Proposed: Tariff M - Adjoining Central"},{"$f":"INDEX(Prop2021DistTar!$G$106:$G$108,C328)","v":0},{"$f":"INDEX(Prop2021DistTar!$G$106:$G$108,D328)","v":0},{"$f":"INDEX(Prop2021DistTar!$G$106:$G$108,E328)","v":0}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B338","v":"Existing: Tariff M - Adjoining Central"},{"$f":"SUM(C338:E338)","v":0}]
[null,{"$f":"B339","v":"Proposed: Tariff M - Adjoining Central"},{"$f":"SUM(C339:E339)","v":0}]
[]
[null,"Average price movement",{"$f":"IF(C343=0,\"\",C343/C342)","v":""}]
[]
[null,{"$f":"IF(C345=\"\",\"\",IF(C345<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":""}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!B110","v":"Tariff M - Adjoining West"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2021DistTar!C110","v":"Existing: Tariff M - Adjoining West"},{"$f":"INDEX(Prop2021DistTar!$E$111:$E$113,C352)","v":693.98429999999996},{"$f":"INDEX(Prop2021DistTar!$E$111:$E$113,D352)","v":660.96220000000005},{"$f":"INDEX(Prop2021DistTar!$E$111:$E$113,E352)","v":138.0103}]
[null,{"$f":"\"Proposed: \"&B351","v":"Proposed: Tariff M - Adjoining West"},{"$f":"INDEX(Prop2021DistTar!$D$111:$D$113,C352)","v":680.0702},{"$f":"INDEX(Prop2021DistTar!$D$111:$D$113,D352)","v":647.71019999999999},{"$f":"INDEX(Prop2021DistTar!$D$111:$D$113,E352)","v":135.2432}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B354","v":"Existing: Tariff M - Adjoining West"},{"$f":"INDEX(Prop2021DistTar!$F$111:$F$113,C$280)","v":0},{"$f":"INDEX(Prop2021DistTar!$F$111:$F$113,D$280)","v":0},{"$f":"INDEX(Prop2021DistTar!$F$111:$F$113,E$280)","v":0}]
[null,{"$f":"B355","v":"Proposed: Tariff M - Adjoining West"},{"$f":"INDEX(Prop2021DistTar!$F$111:$F$113,C$280)","v":0},{"$f":"INDEX(Prop2021DistTar!$F$111:$F$113,D$280)","v":0},{"$f":"INDEX(Prop2021DistTar!$F$111:$F$113,E$280)","v":0}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B358","v":"Existing: Tariff M - Adjoining West"},{"$f":"INDEX(Prop2021DistTar!$H$111:$H$113,C352)","v":0},{"$f":"INDEX(Prop2021DistTar!$H$111:$H$113,D352)","v":0},{"$f":"INDEX(Prop2021DistTar!$H$111:$H$113,E352)","v":0}]
[null,{"$f":"B359","v":"Proposed: Tariff M - Adjoining West"},{"$f":"INDEX(Prop2021DistTar!$G$111:$G$113,C352)","v":0},{"$f":"INDEX(Prop2021DistTar!$G$111:$G$113,D352)","v":0},{"$f":"INDEX(Prop2021DistTar!$G$111:$G$113,E352)","v":0}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B362","v":"Existing: Tariff M - Adjoining West"},{"$f":"SUM(C362:E362)","v":0}]
[null,{"$f":"B363","v":"Proposed: Tariff M - Adjoining West"},{"$f":"SUM(C363:E363)","v":0}]
[]
[null,"Average price movement",{"$f":"IF(C367=0,\"\",C367/C366)","v":""}]
[]
[null,{"$f":"IF(C369=\"\",\"\",IF(C369<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":""}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!B116","v":"Tariff D - SP AusNet Central"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2021DistTar!C116","v":"Existing: Tariff D - SP AusNet Central"},{"$f":"INDEX(Prop2021DistTar!$E$117:$E$119,C376)","v":316.5797},{"$f":"INDEX(Prop2021DistTar!$E$117:$E$119,D376)","v":301.50689999999997},{"$f":"INDEX(Prop2021DistTar!$E$117:$E$119,E376)","v":146.3854}]
[null,{"$f":"\"Proposed: \"&B375","v":"Proposed: Tariff D - SP AusNet Central"},{"$f":"INDEX(Prop2021DistTar!$D$117:$D$119,C376)","v":310.23239999999998},{"$f":"INDEX(Prop2021DistTar!$D$117:$D$119,D376)","v":295.46179999999998},{"$f":"INDEX(Prop2021DistTar!$D$117:$D$119,E376)","v":143.4504}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B378","v":"Existing: Tariff D - SP AusNet Central"},{"$f":"INDEX(Prop2021DistTar!$F$117:$F$119,C$280)","v":1389.3800000000006},{"$f":"INDEX(Prop2021DistTar!$F$117:$F$119,D$280)","v":1567.7399999999998},{"$f":"INDEX(Prop2021DistTar!$F$117:$F$119,E$280)","v":3295.5800000000004}]
[null,{"$f":"B379","v":"Proposed: Tariff D - SP AusNet Central"},{"$f":"INDEX(Prop2021DistTar!$F$117:$F$119,C$280)","v":1389.3800000000006},{"$f":"INDEX(Prop2021DistTar!$F$117:$F$119,D$280)","v":1567.7399999999998},{"$f":"INDEX(Prop2021DistTar!$F$117:$F$119,E$280)","v":3295.5800000000004}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B382","v":"Existing: Tariff D - SP AusNet Central"},{"$f":"INDEX(Prop2021DistTar!$H$117:$H$119,C376)","v":439849.50358600018},{"$f":"INDEX(Prop2021DistTar!$H$117:$H$119,D376)","v":472684.42740599992},{"$f":"INDEX(Prop2021DistTar!$H$117:$H$119,E376)","v":482424.79653200007}]
[null,{"$f":"B383","v":"Proposed: Tariff D - SP AusNet Central"},{"$f":"INDEX(Prop2021DistTar!$G$117:$G$119,C376)","v":431030.69191200013},{"$f":"INDEX(Prop2021DistTar!$G$117:$G$119,D376)","v":463207.28233199992},{"$f":"INDEX(Prop2021DistTar!$G$117:$G$119,E376)","v":472752.26923200005}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B386","v":"Existing: Tariff D - SP AusNet Central"},{"$f":"SUM(C386:E386)","v":1394958.7275240002}]
[null,{"$f":"B387","v":"Proposed: Tariff D - SP AusNet Central"},{"$f":"SUM(C387:E387)","v":1366990.2434760001}]
[]
[null,"Average price movement",{"$f":"IF(C391=0,\"\",C391/C390)","v":0.97995031430238577}]
[]
[null,{"$f":"IF(C393=\"\",\"\",IF(C393<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!B121","v":"Tariff D - SP AusNet West"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2021DistTar!C121","v":"Existing: Tariff D - SP AusNet West"},{"$f":"INDEX(Prop2021DistTar!$E$122:$E$124,C400)","v":316.5797},{"$f":"INDEX(Prop2021DistTar!$E$122:$E$124,D400)","v":301.50689999999997},{"$f":"INDEX(Prop2021DistTar!$E$122:$E$124,E400)","v":146.3854}]
[null,{"$f":"\"Proposed: \"&B399","v":"Proposed: Tariff D - SP AusNet West"},{"$f":"INDEX(Prop2021DistTar!$D$122:$D$124,C400)","v":310.23239999999998},{"$f":"INDEX(Prop2021DistTar!$D$122:$D$124,D400)","v":295.46179999999998},{"$f":"INDEX(Prop2021DistTar!$D$122:$D$124,E400)","v":143.4504}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B402","v":"Existing: Tariff D - SP AusNet West"},{"$f":"INDEX(Prop2021DistTar!$F$122:$F$124,C$280)","v":520.08000000000004},{"$f":"INDEX(Prop2021DistTar!$F$122:$F$124,D$280)","v":664.26},{"$f":"INDEX(Prop2021DistTar!$F$122:$F$124,E$280)","v":410.42}]
[null,{"$f":"B403","v":"Proposed: Tariff D - SP AusNet West"},{"$f":"INDEX(Prop2021DistTar!$F$122:$F$124,C$280)","v":520.08000000000004},{"$f":"INDEX(Prop2021DistTar!$F$122:$F$124,D$280)","v":664.26},{"$f":"INDEX(Prop2021DistTar!$F$122:$F$124,E$280)","v":410.42}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B406","v":"Existing: Tariff D - SP AusNet West"},{"$f":"INDEX(Prop2021DistTar!$H$122:$H$124,C400)","v":164646.770376},{"$f":"INDEX(Prop2021DistTar!$H$122:$H$124,D400)","v":200278.97339399997},{"$f":"INDEX(Prop2021DistTar!$H$122:$H$124,E400)","v":60079.495868000005}]
[null,{"$f":"B407","v":"Proposed: Tariff D - SP AusNet West"},{"$f":"INDEX(Prop2021DistTar!$G$122:$G$124,C400)","v":161345.66659199999},{"$f":"INDEX(Prop2021DistTar!$G$122:$G$124,D400)","v":196263.45526799999},{"$f":"INDEX(Prop2021DistTar!$G$122:$G$124,E400)","v":58874.913168000006}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B410","v":"Existing: Tariff D - SP AusNet West"},{"$f":"SUM(C410:E410)","v":425005.23963799997}]
[null,{"$f":"B411","v":"Proposed: Tariff D - SP AusNet West"},{"$f":"SUM(C411:E411)","v":416484.03502799995}]
[]
[null,"Average price movement",{"$f":"IF(C415=0,\"\",C415/C414)","v":0.97995035398326391}]
[]
[null,{"$f":"IF(C417=\"\",\"\",IF(C417<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!B126","v":"Tariff D - Adjoining Central"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2021DistTar!C126","v":"Existing: Tariff D - Adjoining Central"},{"$f":"INDEX(Prop2021DistTar!$E$127:$E$129,C424)","v":316.5797},{"$f":"INDEX(Prop2021DistTar!$E$127:$E$129,D424)","v":301.50689999999997},{"$f":"INDEX(Prop2021DistTar!$E$127:$E$129,E424)","v":146.3854}]
[null,{"$f":"\"Proposed: \"&B423","v":"Proposed: Tariff D - Adjoining Central"},{"$f":"INDEX(Prop2021DistTar!$D$127:$D$129,C424)","v":310.23239999999998},{"$f":"INDEX(Prop2021DistTar!$D$127:$D$129,D424)","v":295.46179999999998},{"$f":"INDEX(Prop2021DistTar!$D$127:$D$129,E424)","v":143.4504}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B426","v":"Existing: Tariff D - Adjoining Central"},{"$f":"INDEX(Prop2021DistTar!$F$127:$F$129,C$280)","v":10},{"$f":"INDEX(Prop2021DistTar!$F$127:$F$129,D$280)","v":19.98},{"$f":"INDEX(Prop2021DistTar!$F$127:$F$129,E$280)","v":0}]
[null,{"$f":"B427","v":"Proposed: Tariff D - Adjoining Central"},{"$f":"INDEX(Prop2021DistTar!$F$127:$F$129,C$280)","v":10},{"$f":"INDEX(Prop2021DistTar!$F$127:$F$129,D$280)","v":19.98},{"$f":"INDEX(Prop2021DistTar!$F$127:$F$129,E$280)","v":0}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B430","v":"Existing: Tariff D - Adjoining Central"},{"$f":"INDEX(Prop2021DistTar!$H$127:$H$129,C424)","v":3165.797},{"$f":"INDEX(Prop2021DistTar!$H$127:$H$129,D424)","v":6024.1078619999998},{"$f":"INDEX(Prop2021DistTar!$H$127:$H$129,E424)","v":0}]
[null,{"$f":"B431","v":"Proposed: Tariff D - Adjoining Central"},{"$f":"INDEX(Prop2021DistTar!$G$127:$G$129,C424)","v":3102.3239999999996},{"$f":"INDEX(Prop2021DistTar!$G$127:$G$129,D424)","v":5903.3267639999995},{"$f":"INDEX(Prop2021DistTar!$G$127:$G$129,E424)","v":0}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B434","v":"Existing: Tariff D - Adjoining Central"},{"$f":"SUM(C434:E434)","v":9189.9048619999994}]
[null,{"$f":"B435","v":"Proposed: Tariff D - Adjoining Central"},{"$f":"SUM(C435:E435)","v":9005.6507639999982}]
[]
[null,"Average price movement",{"$f":"IF(C439=0,\"\",C439/C438)","v":0.97995038025236947}]
[]
[null,{"$f":"IF(C441=\"\",\"\",IF(C441<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!B131","v":"Tariff D - Adjoining West"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2021DistTar!C131","v":"Existing: Tariff D - Adjoining West"},{"$f":"INDEX(Prop2021DistTar!$E$132:$E$134,C448)","v":316.5797},{"$f":"INDEX(Prop2021DistTar!$E$132:$E$134,D448)","v":301.50689999999997},{"$f":"INDEX(Prop2021DistTar!$E$132:$E$134,E448)","v":146.3854}]
[null,{"$f":"\"Proposed: \"&B447","v":"Proposed: Tariff D - Adjoining West"},{"$f":"INDEX(Prop2021DistTar!$D$132:$D$134,C448)","v":310.23239999999998},{"$f":"INDEX(Prop2021DistTar!$D$132:$D$134,D448)","v":295.46179999999998},{"$f":"INDEX(Prop2021DistTar!$D$132:$D$134,E448)","v":143.4504}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B450","v":"Existing: Tariff D - Adjoining West"},{"$f":"INDEX(Prop2021DistTar!$F$132:$F$134,C$280)","v":11.15},{"$f":"INDEX(Prop2021DistTar!$F$132:$F$134,D$280)","v":5.7},{"$f":"INDEX(Prop2021DistTar!$F$132:$F$134,E$280)","v":0}]
[null,{"$f":"B451","v":"Proposed: Tariff D - Adjoining West"},{"$f":"INDEX(Prop2021DistTar!$F$132:$F$134,C$280)","v":11.15},{"$f":"INDEX(Prop2021DistTar!$F$132:$F$134,D$280)","v":5.7},{"$f":"INDEX(Prop2021DistTar!$F$132:$F$134,E$280)","v":0}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B454","v":"Existing: Tariff D - Adjoining West"},{"$f":"INDEX(Prop2021DistTar!$H$132:$H$134,C448)","v":3529.8636550000001},{"$f":"INDEX(Prop2021DistTar!$H$132:$H$134,D448)","v":1718.5893299999998},{"$f":"INDEX(Prop2021DistTar!$H$132:$H$134,E448)","v":0}]
[null,{"$f":"B455","v":"Proposed: Tariff D - Adjoining West"},{"$f":"INDEX(Prop2021DistTar!$G$132:$G$134,C448)","v":3459.0912600000001},{"$f":"INDEX(Prop2021DistTar!$G$132:$G$134,D448)","v":1684.1322599999999},{"$f":"INDEX(Prop2021DistTar!$G$132:$G$134,E448)","v":0}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B458","v":"Existing: Tariff D - Adjoining West"},{"$f":"SUM(C458:E458)","v":5248.4529849999999}]
[null,{"$f":"B459","v":"Proposed: Tariff D - Adjoining West"},{"$f":"SUM(C459:E459)","v":5143.2235199999996}]
[]
[null,"Average price movement",{"$f":"IF(C463=0,\"\",C463/C462)","v":0.97995038437026216}]
[]
[null,{"$f":"IF(C465=\"\",\"\",IF(C465<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]

{"sheet":"ARS","index":5,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Tariff Approval - \"&'Model update'!B3","v":"Tariff Approval - AusNet Services"}]
[]
["Ancillary Reference Services (Exc GST)"]
[]
[null,{"$f":"'Model update'!$B$8","v":2020},{"$f":"'Model update'!$B$5","v":2021}]
["Disconnection",60.57,{"$f":"ROUND(B6*(1+'Model update'!$B$30),2)","v":60.36}]
["Reconnection of Meter ",60.57,{"$f":"ROUND(B7*(1+'Model update'!$B$30),2)","v":60.36}]
["Special Meter Reads",9.39,{"$f":"ROUND(B8*(1+'Model update'!$B$30),2)","v":9.36}]
["Meter and gas installation test",181.72,{"$f":"ROUND(B9*(1+'Model update'!$B$30),2)","v":181.09}]
[]
["Note: Formula is as per AA2018-22, Part B, section 2, p9 : ART = ARTt-1  * (1+CPIt)"]