{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["NOTES","Model update","Prop2022DistTar","2022TarContForm","2022RebalContForm","ARS","PTRM_Link"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":31,"comments":2,"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":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 2021"]
[]
[{"$f":"A10+1","v":4},"'Model update'!B57","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:E134\"","v":"Prop2022DistTar!E8:E134"},{"$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:B9",{"$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:D134\"","v":"Prop2022DistTar!D8:D134"},{"$f":"\"Proposed \"&D2&\" Tariffs\"","v":"Proposed 2022 Tariffs"}]
[null,{"$f":"\"Prop\"&D2&\"DistTar!F8:F134\"","v":"Prop2022DistTar!F8:F134"},{"$f":"\"Actual \"&D2-2&\" Volumes\"","v":"Actual 2020 Volumes"}]
[]
[null,"ARS!C6:C9",{"$f":"\"Proposed \"&D2&\" Ancillary Reference Services Charges\"","v":"Proposed 2022 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",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,7.3928927184635802E-3]
[2020,1.2784150606043319E-2]
[2021,1.6623218055427314E-2]
[2022,1.8998269403243149E-2]
[]
[]
[{"$f":"\"Xt for \"&B$5","v":"Xt for 2022"},{"$f":"VLOOKUP(B5,A34:B38,2,FALSE)","v":1.8998269403243149E-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 WACC for distribution tariffs"]
[]
["Real Pre-tax WACCD",3.6716995735708746E-2]

{"sheet":"Prop2022DistTar","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":"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'!$B$5&\" Tariff\"","v":"Prop\n2022 Tariff"},{"$f":"\"Exist\n\"&'Model update'!$B$8&\" Tariff\"","v":"Exist\n2021 Tariff"},{"$f":"\"Actual \"&'Model update'!$B$9&\" Volumes\"","v":"Actual 2020 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.43459999999999999,0.38579999999999998,560436.77965966088,{"$f":"D8*$F8*365","v":88901525.920632347},{"$f":"E8*$F8*365","v":78919026.001334459}]
[null,"Peak 0 - 0.1","Peak 0 - 0.1",5.9707999999999997,6.54,5639401.0300000003,{"$f":"D9*$F9","v":33671735.669923998},36881682.736200005]
[null,"Peak 0.1 - 0.2","Peak 0.1 - 0.2",3.5987,3.9236,3976798.0419999999,14311303.113745399,15603364.7975912]
[null,"Peak 0.2 - 1.4","Peak 0.2 - 1.4",0.62570000000000003,0.68610000000000004,6032737.2369999997,3774683.6891909,4139061.0183057003]
[null,"Peak > 1.4","Peak > 1.4",0.56200000000000006,0.61339999999999995,77726.47,43682.276140000002,47677.416697999994]
[null,"Off Peak 0 - 0.1","Off Peak 0 - 0.1",2.0238999999999998,2.2311000000000001,8025956.3729999997,16243733.103314698,17906711.263800301]
[null,"Off Peak 0.1 - 0.2","Off Peak 0.1 - 0.2",1.5993999999999999,1.7844,2120662.0060000001,3391786.8123964001,3784109.2835064]
[null,"Off Peak 0.2 - 1.4","Off Peak 0.2 - 1.4",0.61299999999999999,0.68279999999999996,1265267.4350000001,775608.93765500002,863924.60461799998]
[null,"Off Peak > 1.4","Off Peak > 1.4",0.21740000000000001,0.23760000000000001,78346.263999999996,17032.477793599999,18615.072326400001]
[null,"Tariff V - SP AusNet Central - Non Residential","Tariff V - SP AusNet Central - Non Residential",null,null,{"$f":"SUM(F9:F16)","v":27216894.857000001}]
[]
[null,"Fixed Charge","Fixed Charge",0.45369999999999999,0.40279999999999999,10192.876158918511,{"$f":"D19*$F19*365","v":1687945.3883549846},{"$f":"E19*$F19*365","v":1498577.0386365172}]
[null,"Peak 0 - 0.1","Peak 0 - 0.1",1.0755999999999999,1.1125,88047.202000000005,{"$f":"D20*$F20","v":94703.570471200001},97952.512225000013]
[null,"Peak 0.1 - 0.2","Peak 0.1 - 0.2",1.0246999999999999,1.0592999999999999,70613.588000000003,72357.743623600007,74800.973768399999]
[null,"Peak 0.2 - 1.4","Peak 0.2 - 1.4",0.92210000000000003,0.94740000000000002,410048.2,378105.44522000005,388479.66468000005]
[null,"Peak > 1.4","Peak > 1.4",0.70389999999999997,0.71099999999999997,1063952.8459999999,748916.40829939989,756470.47350599989]
[null,"Off Peak 0 - 0.1","Off Peak 0 - 0.1",1.0192000000000001,1.056,161925.58600000001,165034.55725120002,170993.41881600002]
[null,"Off Peak 0.1 - 0.2","Off Peak 0.1 - 0.2",0.71309999999999996,0.73860000000000003,113230.273,80744.507676299996,83631.879637800012]
[null,"Off Peak 0.2 - 1.4","Off Peak 0.2 - 1.4",0.58709999999999996,0.61040000000000005,635368.37100000004,373024.77061409998,387828.85365840007]
[null,"Off Peak > 1.4","Off Peak > 1.4",0.56920000000000004,0.58099999999999996,1379242.1869999999,785064.6528404,801339.71064699988]
[null,"Tariff V - SP AusNet West - Residential","Tariff V - SP AusNet West - Residential",null,null,{"$f":"SUM(F20:F27)","v":3922428.2529999996}]
[]
[null,"Fixed Charge","Fixed Charge",0.43459999999999999,0.38579999999999998,148971.0023903801,{"$f":"D30*$F30*365","v":23631121.138183605},{"$f":"E30*$F30*365","v":20977649.643606152}]
[null,"Peak 0 - 0.1","Peak 0 - 0.1",3.1560000000000001,3.7231000000000001,1524005.8929999999,{"$f":"D31*$F31","v":4809762.5983079998},5674026.3402282996]
[null,"Peak 0.1 - 0.2","Peak 0.1 - 0.2",2.2725,2.6686999999999999,1138150.608,2586447.2566800001,3037382.5275695999]
[null,"Peak 0.2 - 1.4","Peak 0.2 - 1.4",0.73409999999999997,0.86050000000000004,1791901.5209999999,1315434.9065661,1541931.2588205]
[null,"Peak > 1.4","Peak > 1.4",0.7036,0.82410000000000005,16625.277999999998,11697.545600799998,13700.891599799999]
[null,"Off Peak 0 - 0.1","Off Peak 0 - 0.1",0.9758,1.1676,2129926.5589999999,2078382.3362721999,2486902.2502883999]
[null,"Off Peak 0.1 - 0.2","Off Peak 0.1 - 0.2",0.91449999999999998,1.0991,686541.77300000004,627842.45140850008,754578.06270430004]
[null,"Off Peak 0.2 - 1.4","Off Peak 0.2 - 1.4",0.52139999999999997,0.62180000000000002,489836.93800000002,255400.97947319999,304580.60804840003]
[null,"Off Peak > 1.4","Off Peak > 1.4",0.10290000000000001,0.1206,14567.957,1499.0427753000001,1756.8956142]
[null,"Tariff V - SP AusNet West - Non Residential","Tariff V - SP AusNet West - Non Residential",null,null,{"$f":"SUM(F31:F38)","v":7791556.5269999998}]
[]
[null,"Fixed Charge","Fixed Charge",0.45369999999999999,0.40279999999999999,6008.4620902051502,{"$f":"D41*$F41*365","v":995004.32636901783},{"$f":"E41*$F41*365","v":883376.11342614156}]
[null,"Peak 0 - 0.1","Peak 0 - 0.1",1.6437999999999999,1.8216000000000001,46138.148000000001,{"$f":"D42*$F42","v":75841.887682400004},84045.250396800009]
[null,"Peak 0.1 - 0.2","Peak 0.1 - 0.2",1.3854,1.5341,35255.959000000003,48843.605598599999,54086.166701900001]
[null,"Peak 0.2 - 1.4","Peak 0.2 - 1.4",0.85589999999999999,0.94059999999999999,182214.49799999999,155957.38883819999,171390.95681879998]
[null,"Peak > 1.4","Peak > 1.4",0.32090000000000002,0.3458,382790.315,122837.41208350001,132368.890927]
[null,"Off Peak 0 - 0.1","Off Peak 0 - 0.1",0.76170000000000004,0.84650000000000003,76826.112999999998,58518.450272100003,65033.304654500003]
[null,"Off Peak 0.1 - 0.2","Off Peak 0.1 - 0.2",0.64170000000000005,0.71299999999999997,48845.392,31344.088046400004,34826.764495999996]
[null,"Off Peak 0.2 - 1.4","Off Peak 0.2 - 1.4",0.30919999999999997,0.3458,246988.18700000001,76368.747420399988,85408.515064599997]
[null,"Off Peak > 1.4","Off Peak > 1.4",0.23,0.25530000000000003,402194.76799999998,92504.79664,102680.3242704]
[null,"Tariff V - Adjoining Central - Residential","Tariff V - Adjoining Central - Residential",null,null,{"$f":"SUM(F42:F49)","v":1421253.38}]
[]
[null,"Fixed Charge","Fixed Charge",0.43459999999999999,0.38579999999999998,1816.4369961480986,{"$f":"D52*$F52*365","v":288139.58426197676},{"$f":"E52*$F52*365","v":255785.20848658678}]
[null,"Peak 0 - 0.1","Peak 0 - 0.1",9.7782999999999998,9.9795999999999996,16440.452000000001,{"$f":"D53*$F53","v":160759.67179160001},164069.13477920002]
[null,"Peak 0.1 - 0.2","Peak 0.1 - 0.2",7.0468999999999999,7.1813000000000002,10921.23,76960.815686999995,78428.628998999993]
[null,"Peak 0.2 - 1.4","Peak 0.2 - 1.4",2.5099999999999998,2.5834999999999999,16257.147000000001,40805.438969999996,42000.339274500002]
[null,"Peak > 1.4","Peak > 1.4",2.4068000000000001,2.4601999999999999,402.613,969.00896840000007,990.50850259999993]
[null,"Off Peak 0 - 0.1","Off Peak 0 - 0.1",4.3792,4.6380999999999997,21752.272000000001,95257.549542399996,100889.21276319999]
[null,"Off Peak 0.1 - 0.2","Off Peak 0.1 - 0.2",2.5396000000000001,2.6200999999999999,5703.7659999999996,14485.2841336,14944.437296599999]
[null,"Off Peak 0.2 - 1.4","Off Peak 0.2 - 1.4",2.2098,2.3005,5116.268,11305.929026399999,11769.974534000001]
[null,"Off Peak > 1.4","Off Peak > 1.4",2.1251000000000002,2.1901999999999999,395.18200000000002,839.8012682000001,865.52761640000006]
[null,"Tariff V - Adjoining Central - Non Residential","Tariff V - Adjoining Central - Non Residential",null,null,{"$f":"SUM(F53:F60)","v":76988.929999999993}]
[]
[null,"Fixed Charge","Fixed Charge",0.45369999999999999,0.40279999999999999,16.774046859069241,{"$f":"D63*$F63*365","v":2777.790546885296},{"$f":"E63*$F63*365","v":2466.1539173140782}]
[null,"Peak 0 - 0.1","Peak 0 - 0.1",4.0205000000000002,4.1746999999999996,181.83500000000001,{"$f":"D64*$F64","v":731.0676175000001},759.10657449999997]
[null,"Peak 0.1 - 0.2","Peak 0.1 - 0.2",3.8311999999999999,3.9756999999999998,141.35400000000001,541.55544480000003,561.98109780000004]
[null,"Peak 0.2 - 1.4","Peak 0.2 - 1.4",3.6217000000000001,3.5366,634.54499999999996,2298.1316265,2244.1318469999997]
[null,"Peak > 1.4","Peak > 1.4",3.4207000000000001,3.3578999999999999,77.841999999999999,266.27412939999999,261.38565180000001]
[null,"Off Peak 0 - 0.1","Off Peak 0 - 0.1",3.7008000000000001,3.7176,274.78500000000003,1016.9243280000002,1021.5407160000001]
[null,"Off Peak 0.1 - 0.2","Off Peak 0.1 - 0.2",3.5526,3.53,183.36699999999999,651.42960419999997,647.28550999999993]
[null,"Off Peak 0.2 - 1.4","Off Peak 0.2 - 1.4",3.4424999999999999,3.3582000000000001,1222.7049999999999,4209.1619624999994,4106.087931]
[null,"Off Peak > 1.4","Off Peak > 1.4",3.3584000000000001,3.1979000000000002,468.75700000000001,1574.2735087999999,1499.0380103]
[null,"Tariff V - Adjoining West - Residential","Tariff V - Adjoining West - Residential",null,null,{"$f":"SUM(F64:F71)","v":3185.19}]
[]
[null,"Fixed Charge","Fixed Charge",0.43459999999999999,0.38579999999999998,11363.511201453844,{"$f":"D74*$F74*365","v":1802582.4183754218},{"$f":"E74*$F74*365","v":1600175.5568551258}]
[null,"Peak 0 - 0.1","Peak 0 - 0.1",6.8521000000000001,6.9668999999999999,115499.504,{"$f":"D75*$F75","v":791414.15135840001},{"$f":"E75*$F75","v":804673.49441759998}]
[null,"Peak 0.1 - 0.2","Peak 0.1 - 0.2",5.7530000000000001,5.8392999999999997,90775.951000000001,522234.046103,530068.01067430002]
[null,"Peak 0.2 - 1.4","Peak 0.2 - 1.4",2.9525000000000001,3.0125000000000002,178276.56,526361.54339999997,537058.13699999999]
[null,"Peak > 1.4","Peak > 1.4",2.6482000000000001,2.6823000000000001,2598.7440000000001,6881.9938608000002,6970.611031200001]
[null,"Off Peak 0 - 0.1","Off Peak 0 - 0.1",4.0662000000000003,4.2339000000000002,163484.481,664760.59664220002,692176.94410590001]
[null,"Off Peak 0.1 - 0.2","Off Peak 0.1 - 0.2",3.0752000000000002,3.1793999999999998,62178.347999999998,191210.85576959999,197689.83963119998]
[null,"Off Peak 0.2 - 1.4","Off Peak 0.2 - 1.4",2.2019000000000002,2.2713000000000001,53491.512999999999,117782.96247470001,121495.27347690001]
[null,"Off Peak > 1.4","Off Peak > 1.4",2.133,2.1631999999999998,4001.6979999999999,8535.6218339999996,8656.4731135999991]
[null,"Tariff V - Adjoining West - Non Residential","Tariff V - Adjoining West - Non Residential",null,null,{"$f":"SUM(F75:F82)","v":670306.799}]
[]
[null,"Fixed Charge","Fixed Charge",0.45369999999999999,0.40279999999999999,280.10232333745199,{"$f":"D85*$F85*365","v":46385.084795843715},{"$f":"E85*$F85*365","v":41181.203781718861}]
[null,"Peak 0 - 0.1","Peak 0 - 0.1",4.9612999999999996,4.9333,2554.5810000000001,{"$f":"D86*$F86","v":12674.0427153},{"$f":"E86*$F86","v":12602.5144473}]
[null,"Peak 0.1 - 0.2","Peak 0.1 - 0.2",4.657,4.6258999999999997,2128.0250000000001,9910.2124249999997,9844.0308475000002]
[null,"Peak 0.2 - 1.4","Peak 0.2 - 1.4",3.9998999999999998,3.8874,11241.86,44966.315814000001,43701.606564000002]
[null,"Peak > 1.4","Peak > 1.4",3.516,3.3166000000000002,19772.989000000001,69521.829324000006,65579.095317400002]
[null,"Off Peak 0 - 0.1","Off Peak 0 - 0.1",3.8140999999999998,3.7970999999999999,4681.9399999999996,17857.387353999999,17777.794373999997]
[null,"Off Peak 0.1 - 0.2","Off Peak 0.1 - 0.2",3.629,3.6160999999999999,3357.3690000000001,12183.892101000001,12140.582040900001]
[null,"Off Peak 0.2 - 1.4","Off Peak 0.2 - 1.4",3.1726000000000001,3.1371000000000002,18023.665000000001,57181.879579000008,56542.039471500007]
[null,"Off Peak > 1.4","Off Peak > 1.4",3.0211999999999999,2.9533999999999998,24556.594000000001,74190.381792800006,72525.444719599996]
[null,null,null,null,null,{"$f":"SUM(F86:F93)","v":86317.023000000001}]
[null,"Tariff M - SP AusNet Central","Tariff M - SP AusNet Central"]
[null,"0 - 10","0 - 10",692.80970000000002,680.0702,167.92999999999998,{"$f":"D96*$F96","v":116343.53292099999},114204.18868599998]
[null,"10 - 50","10 - 50",659.84349999999995,647.71019999999999,50.949999999999996,33619.026324999992,33000.834689999996]
[null,"> 50","> 50",137.77670000000001,135.2432,0,0,0]
[]
[null,"Tariff M - SP AusNet West","Tariff M - SP AusNet West"]
[null,"0 - 10","0 - 10",692.80970000000002,680.0702,43.449999999999996,{"$f":"D101*$F101","v":30102.581464999999},29549.050189999998]
[null,"10 - 50","10 - 50",659.84349999999995,647.71019999999999,29.05,19168.453675000001,18815.981309999999]
[null,"> 50","> 50",137.77670000000001,135.2432,0,0,0]
[]
[null,"Tariff M - Adjoining Central","Tariff M - Adjoining Central"]
[null,"0 - 10","0 - 10",692.80970000000002,680.0702,0,{"$f":"D106*$F106","v":0},0]
[null,"10 - 50","10 - 50",659.84349999999995,647.71019999999999,0,0,0]
[null,"> 50","> 50",137.77670000000001,135.2432,0,0,0]
[null,null,null,""]
[null,"Tariff M - Adjoining West","Tariff M - Adjoining West",""]
[null,"0 - 10","0 - 10",692.80970000000002,680.0702,0,{"$f":"D111*$F111","v":0},0]
[null,"10 - 50","10 - 50",659.84349999999995,647.71019999999999,0,0,0]
[null,"> 50","> 50",137.77670000000001,135.2432,0,0,0]
[]
[]
[null,"Tariff D - SP AusNet Central","Tariff D - SP AusNet Central"]
[null,"0 - 10","0 - 10",316.04379999999998,310.23239999999998,1348.7500000000005,{"$f":"D117*$F117","v":426264.07525000011},418425.9495000001]
[null,"10 - 50","10 - 50",300.9966,295.46179999999998,1489.3500000000004,448289.28621000011,440046.03183000011]
[null,"> 50","> 50",146.13759999999999,143.4504,3188.85,{"$f":"D119*$F119","v":466010.88575999998},{"$f":"E119*$F119","v":457441.80803999997}]
[]
[null,"Tariff D - SP AusNet West","Tariff D - SP AusNet West"]
[null,"0 - 10","0 - 10",316.04379999999998,310.23239999999998,522.45000000000005,{"$f":"D122*$F122","v":165117.08331000002},162080.91738]
[null,"10 - 50","10 - 50",300.9966,295.46179999999998,738.31,222228.79974599998,218142.40155799998]
[null,"> 50","> 50",146.13759999999999,143.4504,445.56000000000006,65113.069056000008,63915.760224000012]
[]
[null,"Tariff D - Adjoining Central","Tariff D - Adjoining Central"]
[null,"0 - 10","0 - 10",316.04379999999998,310.23239999999998,10,{"$f":"D127*$F127","v":3160.4379999999996},3102.3239999999996]
[null,"10 - 50","10 - 50",300.9966,295.46179999999998,16.25,{"$f":"D128*$F128","v":4891.1947499999997},4801.25425]
[null,"> 50","> 50",146.13759999999999,143.4504,0,0,0]
[null,null,null,""]
[null,"Tariff D - Adjoining West","Tariff D - Adjoining West",""]
[null,"0 - 10","0 - 10",316.04379999999998,310.23239999999998,11.22,{"$f":"D132*$F132","v":3546.0114359999998},3480.8075279999998]
[null,"10 - 50","10 - 50",300.9966,295.46179999999998,6.89,2073.8665740000001,2035.7318019999998]
[null,"> 50","> 50",146.13759999999999,143.4504,0,0,0]
[]
[]
[null,"Total Revenue","Total Revenue",null,null,null,{"$f":"SUM(G8:G135)","v":210177951.21597716},{"$f":"SUM(H8:H135)","v":206313182.86155692}]

{"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 - AusNet Services"},{"$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.8998269403243149E-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":206313182.86155692}]
[]
[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.0187325663889397}]
[]
[null,"Proposed distribution tariff revenue",{"$f":"IF(Prop2022DistTar!G137=0,\"\",Prop2022DistTar!G137)","v":210177951.21597716}]
[null,"Existing distribution tariff revenue",{"$f":"IF(Prop2022DistTar!H137=0,\"\",Prop2022DistTar!H137)","v":206313182.86155692}]
[null,"Average price movement",{"$f":"IF(C40=\"\",\"\",C40/C41)","v":1.0187325322638914}]
[]
[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":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":"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.8998269403243149E-2}]
[]
[null,"Rebalancing control",{"$f":"(1+C8)*(1+C9)*(1+C10)*(1-C11)","v":1.0391072177167187}]
[]
[]
[]
[null,"Rebalancing control summary"]
[null,null,"Existing","Proposed","Movement","Assessment"]
[null,{"$f":"B39","v":"Tariff V - SP AusNet Central - Residential"},{"$f":"C60","v":158164172.19438046},{"$f":"C61","v":161131092.00079235},{"$f":"IF(C19=0,0,D19/C19)","v":1.0187584821849895},{"$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":34792508.478479654},{"$f":"C91","v":35317588.255267709},1.015091748188057,{"$f":"IF(E20=0,\"\",IF($C$13<=E20,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B99","v":"Tariff V - Adjoining Central - Residential"},{"$f":"C120","v":669742.97225208685},{"$f":"C121","v":689523.08364957664},1.0295338842167718,"Compliant"]
[null,{"$f":"B129","v":"Tariff V - Adjoining West - Residential"},{"$f":"C150","v":4498964.3403058257},{"$f":"C151","v":4631764.1898181215},1.0295178711070354,"Compliant"]
[null,{"$f":"B159","v":"Tariff V - SP AusNet Central - Non Residential"},{"$f":"C180","v":4260074.5255751172},{"$f":"C181","v":4385897.0443511847},1.0295352858314331,"Compliant"]
[null,{"$f":"B189","v":"Tariff V - SP AusNet West - Non Residential"},{"$f":"C210","v":1613216.2867561413},{"$f":"C211","v":1657220.7029506178},1.0272774435490981,"Compliant"]
[null,{"$f":"B219","v":"Tariff V - Adjoining Central - Non Residential"},{"$f":"C240","v":13566.711255714079},{"$f":"C241","v":14066.608768585298},1.0368473614163987,"Compliant"]
[null,{"$f":"B249","v":"Tariff V - Adjoining West - Non Residential"},{"$f":"C270","v":331894.31156391883},{"$f":"C271","v":344871.02590094379},{"$f":"IF(C26=0,0,D26/C26)","v":1.0390989356698443},{"$f":"IF(E26=0,\"\",IF($C$13<=E26,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B279","v":"Tariff M - SP AusNet Central"},{"$f":"C294","v":147205.02337599997},{"$f":"C295","v":149962.55924599999},1.0187326207133336,"Compliant"]
[null,{"$f":"B303","v":"Tariff M - SP AusNet West"},{"$f":"C318","v":48365.031499999997},{"$f":"C319","v":49271.03514},1.0187326175937672,"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":1315913.7893700001},{"$f":"C391","v":1340564.2472200003},{"$f":"IF(C31=0,0,D31/C31)","v":1.0187325781134962},{"$f":"IF(E31=0,\"\",IF($C$13<=E31,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B399","v":"Tariff D - SP AusNet West"},{"$f":"C414","v":444139.07916200004},{"$f":"C415","v":452458.95211199997},1.0187325847698379,"Compliant"]
[null,{"$f":"B423","v":"Tariff D - Adjoining Central"},{"$f":"C438","v":7903.5782499999996},{"$f":"C439","v":8051.6327499999989},1.0187325911526213,"Compliant"]
[null,{"$f":"B447","v":"Tariff D - Adjoining West"},{"$f":"C462","v":5516.5393299999996},{"$f":"C463","v":5619.8780100000004},1.0187325193963588,"Compliant"]
[null,null,{"$f":"SUM(C19:C34)","v":206313182.86155692},{"$f":"SUM(D19:D34)","v":210177951.2159771},1.0187325322638912]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!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 : \"&Prop2022DistTar!C6","v":"Existing : Tariff V - SP AusNet Central - Residential"},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$16,C$40)","v":0.38579999999999998},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$16,D$40)","v":6.54},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$16,E$40)","v":3.9236},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$16,F$40)","v":0.68610000000000004},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$16,G$40)","v":0.61339999999999995},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$16,H$40)","v":2.2311000000000001},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$16,I$40)","v":1.7844},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$16,J$40)","v":0.68279999999999996},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$16,K$40)","v":0.23760000000000001}]
[]
[null,{"$f":"\"Proposed : \"&B39","v":"Proposed : Tariff V - SP AusNet Central - Residential"},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$16,C$39)","v":0.43459999999999999},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$16,D$39)","v":5.9707999999999997},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$16,E$39)","v":3.5987},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$16,F$39)","v":0.62570000000000003},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$16,G$39)","v":0.56200000000000006},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$16,H$39)","v":2.0238999999999998},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$16,I$39)","v":1.5993999999999999},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$16,J$39)","v":0.61299999999999999},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$16,K$39)","v":0.21740000000000001}]
[]
[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(Prop2022DistTar!$F$8:$F$16,C$39)","v":560436.77965966088},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$16,D$39)","v":5639401.0300000003},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$16,E$39)","v":3976798.0419999999},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$16,F$39)","v":6032737.2369999997},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$16,G$39)","v":77726.47},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$16,H$39)","v":8025956.3729999997},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$16,I$39)","v":2120662.0060000001},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$16,J$39)","v":1265267.4350000001},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$16,K$39)","v":78346.263999999996}]
[]
[null,{"$f":"B45","v":"Proposed : Tariff V - SP AusNet Central - Residential"},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$16,C$39)","v":560436.77965966088},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$16,D$39)","v":5639401.0300000003},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$16,E$39)","v":3976798.0419999999},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$16,F$39)","v":6032737.2369999997},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$16,G$39)","v":77726.47},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$16,H$39)","v":8025956.3729999997},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$16,I$39)","v":2120662.0060000001},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$16,J$39)","v":1265267.4350000001},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$16,K$39)","v":78346.263999999996}]
[]
[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(Prop2022DistTar!$H$8:$H$16,C$40)","v":78919026.001334459},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$16,D$40)","v":36881682.736200005},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$16,E$40)","v":15603364.7975912},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$16,F$40)","v":4139061.0183057003},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$16,G$40)","v":47677.416697999994},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$16,H$40)","v":17906711.263800301},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$16,I$40)","v":3784109.2835064},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$16,J$40)","v":863924.60461799998},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$16,K$40)","v":18615.072326400001}]
[]
[null,{"$f":"B51","v":"Proposed : Tariff V - SP AusNet Central - Residential"},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$16,C$39)","v":88901525.920632347},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$16,D$39)","v":33671735.669923998},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$16,E$39)","v":14311303.113745399},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$16,F$39)","v":3774683.6891909},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$16,G$39)","v":43682.276140000002},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$16,H$39)","v":16243733.103314698},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$16,I$39)","v":3391786.8123964001},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$16,J$39)","v":775608.93765500002},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$16,K$39)","v":17032.477793599999}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B55","v":"Existing : Tariff V - SP AusNet Central - Residential"},{"$f":"SUM(C55:K55)","v":158164172.19438046}]
[null,{"$f":"B57","v":"Proposed : Tariff V - SP AusNet Central - Residential"},{"$f":"SUM(C57:K57)","v":161131092.00079235}]
[]
[null,"Average price movement",{"$f":"IF(C61=0,\"\",C61/C60)","v":1.0187584821849895}]
[]
[null,{"$f":"IF(C63=\"\",\"\",IF(C63<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!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 : \"&Prop2022DistTar!C28","v":"Existing : Tariff V - SP AusNet West - Residential"},{"$f":"INDEX(Prop2022DistTar!$E$30:$E$38,C$40)","v":0.38579999999999998},{"$f":"INDEX(Prop2022DistTar!$E$30:$E$38,D$40)","v":3.7231000000000001},{"$f":"INDEX(Prop2022DistTar!$E$30:$E$38,E$40)","v":2.6686999999999999},{"$f":"INDEX(Prop2022DistTar!$E$30:$E$38,F$40)","v":0.86050000000000004},{"$f":"INDEX(Prop2022DistTar!$E$30:$E$38,G$40)","v":0.82410000000000005},{"$f":"INDEX(Prop2022DistTar!$E$30:$E$38,H$40)","v":1.1676},{"$f":"INDEX(Prop2022DistTar!$E$30:$E$38,I$40)","v":1.0991},{"$f":"INDEX(Prop2022DistTar!$E$30:$E$38,J$40)","v":0.62180000000000002},{"$f":"INDEX(Prop2022DistTar!$E$30:$E$38,K$40)","v":0.1206}]
[]
[null,{"$f":"\"Proposed : \"&B69","v":"Proposed : Tariff V - SP AusNet West - Residential"},{"$f":"INDEX(Prop2022DistTar!$D$30:$D$38,C$39)","v":0.43459999999999999},{"$f":"INDEX(Prop2022DistTar!$D$30:$D$38,D$39)","v":3.1560000000000001},{"$f":"INDEX(Prop2022DistTar!$D$30:$D$38,E$39)","v":2.2725},{"$f":"INDEX(Prop2022DistTar!$D$30:$D$38,F$39)","v":0.73409999999999997},{"$f":"INDEX(Prop2022DistTar!$D$30:$D$38,G$39)","v":0.7036},{"$f":"INDEX(Prop2022DistTar!$D$30:$D$38,H$39)","v":0.9758},{"$f":"INDEX(Prop2022DistTar!$D$30:$D$38,I$39)","v":0.91449999999999998},{"$f":"INDEX(Prop2022DistTar!$D$30:$D$38,J$39)","v":0.52139999999999997},{"$f":"INDEX(Prop2022DistTar!$D$30:$D$38,K$39)","v":0.10290000000000001}]
[]
[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(Prop2022DistTar!$F$30:$F$38,C$39)","v":148971.0023903801},{"$f":"INDEX(Prop2022DistTar!$F$30:$F$38,D$39)","v":1524005.8929999999},{"$f":"INDEX(Prop2022DistTar!$F$30:$F$38,E$39)","v":1138150.608},{"$f":"INDEX(Prop2022DistTar!$F$30:$F$38,F$39)","v":1791901.5209999999},{"$f":"INDEX(Prop2022DistTar!$F$30:$F$38,G$39)","v":16625.277999999998},{"$f":"INDEX(Prop2022DistTar!$F$30:$F$38,H$39)","v":2129926.5589999999},{"$f":"INDEX(Prop2022DistTar!$F$30:$F$38,I$39)","v":686541.77300000004},{"$f":"INDEX(Prop2022DistTar!$F$30:$F$38,J$39)","v":489836.93800000002},{"$f":"INDEX(Prop2022DistTar!$F$30:$F$38,K$39)","v":14567.957}]
[]
[null,{"$f":"B75","v":"Proposed : Tariff V - SP AusNet West - Residential"},{"$f":"INDEX(Prop2022DistTar!$F$30:$F$38,C$39)","v":148971.0023903801},{"$f":"INDEX(Prop2022DistTar!$F$30:$F$38,D$39)","v":1524005.8929999999},{"$f":"INDEX(Prop2022DistTar!$F$30:$F$38,E$39)","v":1138150.608},{"$f":"INDEX(Prop2022DistTar!$F$30:$F$38,F$39)","v":1791901.5209999999},{"$f":"INDEX(Prop2022DistTar!$F$30:$F$38,G$39)","v":16625.277999999998},{"$f":"INDEX(Prop2022DistTar!$F$30:$F$38,H$39)","v":2129926.5589999999},{"$f":"INDEX(Prop2022DistTar!$F$30:$F$38,I$39)","v":686541.77300000004},{"$f":"INDEX(Prop2022DistTar!$F$30:$F$38,J$39)","v":489836.93800000002},{"$f":"INDEX(Prop2022DistTar!$F$30:$F$38,K$39)","v":14567.957}]
[]
[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(Prop2022DistTar!$H$30:$H$38,C$40)","v":20977649.643606152},{"$f":"INDEX(Prop2022DistTar!$H$30:$H$38,D$40)","v":5674026.3402282996},{"$f":"INDEX(Prop2022DistTar!$H$30:$H$38,E$40)","v":3037382.5275695999},{"$f":"INDEX(Prop2022DistTar!$H$30:$H$38,F$40)","v":1541931.2588205},{"$f":"INDEX(Prop2022DistTar!$H$30:$H$38,G$40)","v":13700.891599799999},{"$f":"INDEX(Prop2022DistTar!$H$30:$H$38,H$40)","v":2486902.2502883999},{"$f":"INDEX(Prop2022DistTar!$H$30:$H$38,I$40)","v":754578.06270430004},{"$f":"INDEX(Prop2022DistTar!$H$30:$H$38,J$40)","v":304580.60804840003},{"$f":"INDEX(Prop2022DistTar!$H$30:$H$38,K$40)","v":1756.8956142}]
[]
[null,{"$f":"B81","v":"Proposed : Tariff V - SP AusNet West - Residential"},{"$f":"INDEX(Prop2022DistTar!$G$30:$G$38,C$39)","v":23631121.138183605},{"$f":"INDEX(Prop2022DistTar!$G$30:$G$38,D$39)","v":4809762.5983079998},{"$f":"INDEX(Prop2022DistTar!$G$30:$G$38,E$39)","v":2586447.2566800001},{"$f":"INDEX(Prop2022DistTar!$G$30:$G$38,F$39)","v":1315434.9065661},{"$f":"INDEX(Prop2022DistTar!$G$30:$G$38,G$39)","v":11697.545600799998},{"$f":"INDEX(Prop2022DistTar!$G$30:$G$38,H$39)","v":2078382.3362721999},{"$f":"INDEX(Prop2022DistTar!$G$30:$G$38,I$39)","v":627842.45140850008},{"$f":"INDEX(Prop2022DistTar!$G$30:$G$38,J$39)","v":255400.97947319999},{"$f":"INDEX(Prop2022DistTar!$G$30:$G$38,K$39)","v":1499.0427753000001}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B85","v":"Existing : Tariff V - SP AusNet West - Residential"},{"$f":"SUM(C85:K85)","v":34792508.478479654}]
[null,{"$f":"B87","v":"Proposed : Tariff V - SP AusNet West - Residential"},{"$f":"SUM(C87:K87)","v":35317588.255267709}]
[]
[null,"Average price movement",{"$f":"IF(C91=0,\"\",C91/C90)","v":1.015091748188057}]
[]
[null,{"$f":"IF(C93=\"\",\"\",IF(C93<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!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 : \"&Prop2022DistTar!C50","v":"Existing : Tariff V - Adjoining Central - Residential"},{"$f":"INDEX(Prop2022DistTar!$E$52:$E$60,C$40)","v":0.38579999999999998},{"$f":"INDEX(Prop2022DistTar!$E$52:$E$60,D$40)","v":9.9795999999999996},{"$f":"INDEX(Prop2022DistTar!$E$52:$E$60,E$40)","v":7.1813000000000002},{"$f":"INDEX(Prop2022DistTar!$E$52:$E$60,F$40)","v":2.5834999999999999},{"$f":"INDEX(Prop2022DistTar!$E$52:$E$60,G$40)","v":2.4601999999999999},{"$f":"INDEX(Prop2022DistTar!$E$52:$E$60,H$40)","v":4.6380999999999997},{"$f":"INDEX(Prop2022DistTar!$E$52:$E$60,I$40)","v":2.6200999999999999},{"$f":"INDEX(Prop2022DistTar!$E$52:$E$60,J$40)","v":2.3005},{"$f":"INDEX(Prop2022DistTar!$E$52:$E$60,K$40)","v":2.1901999999999999}]
[]
[null,{"$f":"\"Proposed : \"&B99","v":"Proposed : Tariff V - Adjoining Central - Residential"},{"$f":"INDEX(Prop2022DistTar!$D$52:$D$60,C$39)","v":0.43459999999999999},{"$f":"INDEX(Prop2022DistTar!$D$52:$D$60,D$39)","v":9.7782999999999998},{"$f":"INDEX(Prop2022DistTar!$D$52:$D$60,E$39)","v":7.0468999999999999},{"$f":"INDEX(Prop2022DistTar!$D$52:$D$60,F$39)","v":2.5099999999999998},{"$f":"INDEX(Prop2022DistTar!$D$52:$D$60,G$39)","v":2.4068000000000001},{"$f":"INDEX(Prop2022DistTar!$D$52:$D$60,H$39)","v":4.3792},{"$f":"INDEX(Prop2022DistTar!$D$52:$D$60,I$39)","v":2.5396000000000001},{"$f":"INDEX(Prop2022DistTar!$D$52:$D$60,J$39)","v":2.2098},{"$f":"INDEX(Prop2022DistTar!$D$52:$D$60,K$39)","v":2.1251000000000002}]
[]
[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(Prop2022DistTar!$F$52:$F$60,C$39)","v":1816.4369961480986},{"$f":"INDEX(Prop2022DistTar!$F$52:$F$60,D$39)","v":16440.452000000001},{"$f":"INDEX(Prop2022DistTar!$F$52:$F$60,E$39)","v":10921.23},{"$f":"INDEX(Prop2022DistTar!$F$52:$F$60,F$39)","v":16257.147000000001},{"$f":"INDEX(Prop2022DistTar!$F$52:$F$60,G$39)","v":402.613},{"$f":"INDEX(Prop2022DistTar!$F$52:$F$60,H$39)","v":21752.272000000001},{"$f":"INDEX(Prop2022DistTar!$F$52:$F$60,I$39)","v":5703.7659999999996},{"$f":"INDEX(Prop2022DistTar!$F$52:$F$60,J$39)","v":5116.268},{"$f":"INDEX(Prop2022DistTar!$F$52:$F$60,K$39)","v":395.18200000000002}]
[]
[null,{"$f":"B105","v":"Proposed : Tariff V - Adjoining Central - Residential"},{"$f":"INDEX(Prop2022DistTar!$F$52:$F$60,C$39)","v":1816.4369961480986},{"$f":"INDEX(Prop2022DistTar!$F$52:$F$60,D$39)","v":16440.452000000001},{"$f":"INDEX(Prop2022DistTar!$F$52:$F$60,E$39)","v":10921.23},{"$f":"INDEX(Prop2022DistTar!$F$52:$F$60,F$39)","v":16257.147000000001},{"$f":"INDEX(Prop2022DistTar!$F$52:$F$60,G$39)","v":402.613},{"$f":"INDEX(Prop2022DistTar!$F$52:$F$60,H$39)","v":21752.272000000001},{"$f":"INDEX(Prop2022DistTar!$F$52:$F$60,I$39)","v":5703.7659999999996},{"$f":"INDEX(Prop2022DistTar!$F$52:$F$60,J$39)","v":5116.268},{"$f":"INDEX(Prop2022DistTar!$F$52:$F$60,K$39)","v":395.18200000000002}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B109","v":"Existing : Tariff V - Adjoining Central - Residential"},{"$f":"INDEX(Prop2022DistTar!$H$52:$H$60,C$40)","v":255785.20848658678},{"$f":"INDEX(Prop2022DistTar!$H$52:$H$60,D$40)","v":164069.13477920002},{"$f":"INDEX(Prop2022DistTar!$H$52:$H$60,E$40)","v":78428.628998999993},{"$f":"INDEX(Prop2022DistTar!$H$52:$H$60,F$40)","v":42000.339274500002},{"$f":"INDEX(Prop2022DistTar!$H$52:$H$60,G$40)","v":990.50850259999993},{"$f":"INDEX(Prop2022DistTar!$H$52:$H$60,H$40)","v":100889.21276319999},{"$f":"INDEX(Prop2022DistTar!$H$52:$H$60,I$40)","v":14944.437296599999},{"$f":"INDEX(Prop2022DistTar!$H$52:$H$60,J$40)","v":11769.974534000001},{"$f":"INDEX(Prop2022DistTar!$H$52:$H$60,K$40)","v":865.52761640000006}]
[]
[null,{"$f":"B111","v":"Proposed : Tariff V - Adjoining Central - Residential"},{"$f":"INDEX(Prop2022DistTar!$G$52:$G$60,C$39)","v":288139.58426197676},{"$f":"INDEX(Prop2022DistTar!$G$52:$G$60,D$39)","v":160759.67179160001},{"$f":"INDEX(Prop2022DistTar!$G$52:$G$60,E$39)","v":76960.815686999995},{"$f":"INDEX(Prop2022DistTar!$G$52:$G$60,F$39)","v":40805.438969999996},{"$f":"INDEX(Prop2022DistTar!$G$52:$G$60,G$39)","v":969.00896840000007},{"$f":"INDEX(Prop2022DistTar!$G$52:$G$60,H$39)","v":95257.549542399996},{"$f":"INDEX(Prop2022DistTar!$G$52:$G$60,I$39)","v":14485.2841336},{"$f":"INDEX(Prop2022DistTar!$G$52:$G$60,J$39)","v":11305.929026399999},{"$f":"INDEX(Prop2022DistTar!$G$52:$G$60,K$39)","v":839.8012682000001}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B115","v":"Existing : Tariff V - Adjoining Central - Residential"},{"$f":"SUM(C115:K115)","v":669742.97225208685}]
[null,{"$f":"B117","v":"Proposed : Tariff V - Adjoining Central - Residential"},{"$f":"SUM(C117:K117)","v":689523.08364957664}]
[]
[null,"Average price movement",{"$f":"IF(C121=0,\"\",C121/C120)","v":1.0295338842167718}]
[]
[null,{"$f":"IF(C123=\"\",\"\",IF(C123<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!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 : \"&Prop2022DistTar!C72","v":"Existing : Tariff V - Adjoining West - Residential"},{"$f":"INDEX(Prop2022DistTar!$E$74:$E$82,C$40)","v":0.38579999999999998},{"$f":"INDEX(Prop2022DistTar!$E$74:$E$82,D$40)","v":6.9668999999999999},{"$f":"INDEX(Prop2022DistTar!$E$74:$E$82,E$40)","v":5.8392999999999997},{"$f":"INDEX(Prop2022DistTar!$E$74:$E$82,F$40)","v":3.0125000000000002},{"$f":"INDEX(Prop2022DistTar!$E$74:$E$82,G$40)","v":2.6823000000000001},{"$f":"INDEX(Prop2022DistTar!$E$74:$E$82,H$40)","v":4.2339000000000002},{"$f":"INDEX(Prop2022DistTar!$E$74:$E$82,I$40)","v":3.1793999999999998},{"$f":"INDEX(Prop2022DistTar!$E$74:$E$82,J$40)","v":2.2713000000000001},{"$f":"INDEX(Prop2022DistTar!$E$74:$E$82,K$40)","v":2.1631999999999998}]
[]
[null,{"$f":"\"Proposed : \"&B129","v":"Proposed : Tariff V - Adjoining West - Residential"},{"$f":"INDEX(Prop2022DistTar!$D$74:$D$82,C$39)","v":0.43459999999999999},{"$f":"INDEX(Prop2022DistTar!$D$74:$D$82,D$39)","v":6.8521000000000001},{"$f":"INDEX(Prop2022DistTar!$D$74:$D$82,E$39)","v":5.7530000000000001},{"$f":"INDEX(Prop2022DistTar!$D$74:$D$82,F$39)","v":2.9525000000000001},{"$f":"INDEX(Prop2022DistTar!$D$74:$D$82,G$39)","v":2.6482000000000001},{"$f":"INDEX(Prop2022DistTar!$D$74:$D$82,H$39)","v":4.0662000000000003},{"$f":"INDEX(Prop2022DistTar!$D$74:$D$82,I$39)","v":3.0752000000000002},{"$f":"INDEX(Prop2022DistTar!$D$74:$D$82,J$39)","v":2.2019000000000002},{"$f":"INDEX(Prop2022DistTar!$D$74:$D$82,K$39)","v":2.133}]
[]
[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(Prop2022DistTar!$F$74:$F$82,C$39)","v":11363.511201453844},{"$f":"INDEX(Prop2022DistTar!$F$74:$F$82,D$39)","v":115499.504},{"$f":"INDEX(Prop2022DistTar!$F$74:$F$82,E$39)","v":90775.951000000001},{"$f":"INDEX(Prop2022DistTar!$F$74:$F$82,F$39)","v":178276.56},{"$f":"INDEX(Prop2022DistTar!$F$74:$F$82,G$39)","v":2598.7440000000001},{"$f":"INDEX(Prop2022DistTar!$F$74:$F$82,H$39)","v":163484.481},{"$f":"INDEX(Prop2022DistTar!$F$74:$F$82,I$39)","v":62178.347999999998},{"$f":"INDEX(Prop2022DistTar!$F$74:$F$82,J$39)","v":53491.512999999999},{"$f":"INDEX(Prop2022DistTar!$F$74:$F$82,K$39)","v":4001.6979999999999}]
[]
[null,{"$f":"B135","v":"Proposed : Tariff V - Adjoining West - Residential"},{"$f":"INDEX(Prop2022DistTar!$F$74:$F$82,C$39)","v":11363.511201453844},{"$f":"INDEX(Prop2022DistTar!$F$74:$F$82,D$39)","v":115499.504},{"$f":"INDEX(Prop2022DistTar!$F$74:$F$82,E$39)","v":90775.951000000001},{"$f":"INDEX(Prop2022DistTar!$F$74:$F$82,F$39)","v":178276.56},{"$f":"INDEX(Prop2022DistTar!$F$74:$F$82,G$39)","v":2598.7440000000001},{"$f":"INDEX(Prop2022DistTar!$F$74:$F$82,H$39)","v":163484.481},{"$f":"INDEX(Prop2022DistTar!$F$74:$F$82,I$39)","v":62178.347999999998},{"$f":"INDEX(Prop2022DistTar!$F$74:$F$82,J$39)","v":53491.512999999999},{"$f":"INDEX(Prop2022DistTar!$F$74:$F$82,K$39)","v":4001.6979999999999}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B139","v":"Existing : Tariff V - Adjoining West - Residential"},{"$f":"INDEX(Prop2022DistTar!$H$74:$H$82,C$40)","v":1600175.5568551258},{"$f":"INDEX(Prop2022DistTar!$H$74:$H$82,D$40)","v":804673.49441759998},{"$f":"INDEX(Prop2022DistTar!$H$74:$H$82,E$40)","v":530068.01067430002},{"$f":"INDEX(Prop2022DistTar!$H$74:$H$82,F$40)","v":537058.13699999999},{"$f":"INDEX(Prop2022DistTar!$H$74:$H$82,G$40)","v":6970.611031200001},{"$f":"INDEX(Prop2022DistTar!$H$74:$H$82,H$40)","v":692176.94410590001},{"$f":"INDEX(Prop2022DistTar!$H$74:$H$82,I$40)","v":197689.83963119998},{"$f":"INDEX(Prop2022DistTar!$H$74:$H$82,J$40)","v":121495.27347690001},{"$f":"INDEX(Prop2022DistTar!$H$74:$H$82,K$40)","v":8656.4731135999991}]
[]
[null,{"$f":"B141","v":"Proposed : Tariff V - Adjoining West - Residential"},{"$f":"INDEX(Prop2022DistTar!$G$74:$G$82,C$39)","v":1802582.4183754218},{"$f":"INDEX(Prop2022DistTar!$G$74:$G$82,D$39)","v":791414.15135840001},{"$f":"INDEX(Prop2022DistTar!$G$74:$G$82,E$39)","v":522234.046103},{"$f":"INDEX(Prop2022DistTar!$G$74:$G$82,F$39)","v":526361.54339999997},{"$f":"INDEX(Prop2022DistTar!$G$74:$G$82,G$39)","v":6881.9938608000002},{"$f":"INDEX(Prop2022DistTar!$G$74:$G$82,H$39)","v":664760.59664220002},{"$f":"INDEX(Prop2022DistTar!$G$74:$G$82,I$39)","v":191210.85576959999},{"$f":"INDEX(Prop2022DistTar!$G$74:$G$82,J$39)","v":117782.96247470001},{"$f":"INDEX(Prop2022DistTar!$G$74:$G$82,K$39)","v":8535.6218339999996}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B145","v":"Existing : Tariff V - Adjoining West - Residential"},{"$f":"SUM(C145:K145)","v":4498964.3403058257}]
[null,{"$f":"B147","v":"Proposed : Tariff V - Adjoining West - Residential"},{"$f":"SUM(C147:K147)","v":4631764.1898181215}]
[]
[null,"Average price movement",{"$f":"IF(C151=0,\"\",C151/C150)","v":1.0295178711070354}]
[]
[null,{"$f":"IF(C153=\"\",\"\",IF(C153<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!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 : \"&Prop2022DistTar!C17","v":"Existing : Tariff V - SP AusNet Central - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$E$19:$E$27,C$40)","v":0.40279999999999999},{"$f":"INDEX(Prop2022DistTar!$E$19:$E$27,D$40)","v":1.1125},{"$f":"INDEX(Prop2022DistTar!$E$19:$E$27,E$40)","v":1.0592999999999999},{"$f":"INDEX(Prop2022DistTar!$E$19:$E$27,F$40)","v":0.94740000000000002},{"$f":"INDEX(Prop2022DistTar!$E$19:$E$27,G$40)","v":0.71099999999999997},{"$f":"INDEX(Prop2022DistTar!$E$19:$E$27,H$40)","v":1.056},{"$f":"INDEX(Prop2022DistTar!$E$19:$E$27,I$40)","v":0.73860000000000003},{"$f":"INDEX(Prop2022DistTar!$E$19:$E$27,J$40)","v":0.61040000000000005},{"$f":"INDEX(Prop2022DistTar!$E$19:$E$27,K$40)","v":0.58099999999999996}]
[]
[null,{"$f":"\"Proposed : \"&B159","v":"Proposed : Tariff V - SP AusNet Central - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$D$19:$D$27,C$39)","v":0.45369999999999999},{"$f":"INDEX(Prop2022DistTar!$D$19:$D$27,D$39)","v":1.0755999999999999},{"$f":"INDEX(Prop2022DistTar!$D$19:$D$27,E$39)","v":1.0246999999999999},{"$f":"INDEX(Prop2022DistTar!$D$19:$D$27,F$39)","v":0.92210000000000003},{"$f":"INDEX(Prop2022DistTar!$D$19:$D$27,G$39)","v":0.70389999999999997},{"$f":"INDEX(Prop2022DistTar!$D$19:$D$27,H$39)","v":1.0192000000000001},{"$f":"INDEX(Prop2022DistTar!$D$19:$D$27,I$39)","v":0.71309999999999996},{"$f":"INDEX(Prop2022DistTar!$D$19:$D$27,J$39)","v":0.58709999999999996},{"$f":"INDEX(Prop2022DistTar!$D$19:$D$27,K$39)","v":0.56920000000000004}]
[]
[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(Prop2022DistTar!$F$19:$F$27,C$39)","v":10192.876158918511},{"$f":"INDEX(Prop2022DistTar!$F$19:$F$27,D$39)","v":88047.202000000005},{"$f":"INDEX(Prop2022DistTar!$F$19:$F$27,E$39)","v":70613.588000000003},{"$f":"INDEX(Prop2022DistTar!$F$19:$F$27,F$39)","v":410048.2},{"$f":"INDEX(Prop2022DistTar!$F$19:$F$27,G$39)","v":1063952.8459999999},{"$f":"INDEX(Prop2022DistTar!$F$19:$F$27,H$39)","v":161925.58600000001},{"$f":"INDEX(Prop2022DistTar!$F$19:$F$27,I$39)","v":113230.273},{"$f":"INDEX(Prop2022DistTar!$F$19:$F$27,J$39)","v":635368.37100000004},{"$f":"INDEX(Prop2022DistTar!$F$19:$F$27,K$39)","v":1379242.1869999999}]
[]
[null,{"$f":"B165","v":"Proposed : Tariff V - SP AusNet Central - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$F$19:$F$27,C$39)","v":10192.876158918511},{"$f":"INDEX(Prop2022DistTar!$F$19:$F$27,D$39)","v":88047.202000000005},{"$f":"INDEX(Prop2022DistTar!$F$19:$F$27,E$39)","v":70613.588000000003},{"$f":"INDEX(Prop2022DistTar!$F$19:$F$27,F$39)","v":410048.2},{"$f":"INDEX(Prop2022DistTar!$F$19:$F$27,G$39)","v":1063952.8459999999},{"$f":"INDEX(Prop2022DistTar!$F$19:$F$27,H$39)","v":161925.58600000001},{"$f":"INDEX(Prop2022DistTar!$F$19:$F$27,I$39)","v":113230.273},{"$f":"INDEX(Prop2022DistTar!$F$19:$F$27,J$39)","v":635368.37100000004},{"$f":"INDEX(Prop2022DistTar!$F$19:$F$27,K$39)","v":1379242.1869999999}]
[]
[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(Prop2022DistTar!$H$19:$H$27,C$40)","v":1498577.0386365172},{"$f":"INDEX(Prop2022DistTar!$H$19:$H$27,D$40)","v":97952.512225000013},{"$f":"INDEX(Prop2022DistTar!$H$19:$H$27,E$40)","v":74800.973768399999},{"$f":"INDEX(Prop2022DistTar!$H$19:$H$27,F$40)","v":388479.66468000005},{"$f":"INDEX(Prop2022DistTar!$H$19:$H$27,G$40)","v":756470.47350599989},{"$f":"INDEX(Prop2022DistTar!$H$19:$H$27,H$40)","v":170993.41881600002},{"$f":"INDEX(Prop2022DistTar!$H$19:$H$27,I$40)","v":83631.879637800012},{"$f":"INDEX(Prop2022DistTar!$H$19:$H$27,J$40)","v":387828.85365840007},{"$f":"INDEX(Prop2022DistTar!$H$19:$H$27,K$40)","v":801339.71064699988}]
[]
[null,{"$f":"B171","v":"Proposed : Tariff V - SP AusNet Central - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$G$19:$G$27,C$39)","v":1687945.3883549846},{"$f":"INDEX(Prop2022DistTar!$G$19:$G$27,D$39)","v":94703.570471200001},{"$f":"INDEX(Prop2022DistTar!$G$19:$G$27,E$39)","v":72357.743623600007},{"$f":"INDEX(Prop2022DistTar!$G$19:$G$27,F$39)","v":378105.44522000005},{"$f":"INDEX(Prop2022DistTar!$G$19:$G$27,G$39)","v":748916.40829939989},{"$f":"INDEX(Prop2022DistTar!$G$19:$G$27,H$39)","v":165034.55725120002},{"$f":"INDEX(Prop2022DistTar!$G$19:$G$27,I$39)","v":80744.507676299996},{"$f":"INDEX(Prop2022DistTar!$G$19:$G$27,J$39)","v":373024.77061409998},{"$f":"INDEX(Prop2022DistTar!$G$19:$G$27,K$39)","v":785064.6528404}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B175","v":"Existing : Tariff V - SP AusNet Central - Non Residential"},{"$f":"SUM(C175:K175)","v":4260074.5255751172}]
[null,{"$f":"B177","v":"Proposed : Tariff V - SP AusNet Central - Non Residential"},{"$f":"SUM(C177:K177)","v":4385897.0443511847}]
[]
[null,"Average price movement",{"$f":"IF(C181=0,\"\",C181/C180)","v":1.0295352858314331}]
[]
[null,{"$f":"IF(C183=\"\",\"\",IF(C183<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!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 : \"&Prop2022DistTar!C39","v":"Existing : Tariff V - SP AusNet West - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$E$41:$E$49,C$40)","v":0.40279999999999999},{"$f":"INDEX(Prop2022DistTar!$E$41:$E$49,D$40)","v":1.8216000000000001},{"$f":"INDEX(Prop2022DistTar!$E$41:$E$49,E$40)","v":1.5341},{"$f":"INDEX(Prop2022DistTar!$E$41:$E$49,F$40)","v":0.94059999999999999},{"$f":"INDEX(Prop2022DistTar!$E$41:$E$49,G$40)","v":0.3458},{"$f":"INDEX(Prop2022DistTar!$E$41:$E$49,H$40)","v":0.84650000000000003},{"$f":"INDEX(Prop2022DistTar!$E$41:$E$49,I$40)","v":0.71299999999999997},{"$f":"INDEX(Prop2022DistTar!$E$41:$E$49,J$40)","v":0.3458},{"$f":"INDEX(Prop2022DistTar!$E$41:$E$49,K$40)","v":0.25530000000000003}]
[]
[null,{"$f":"\"Proposed : \"&B189","v":"Proposed : Tariff V - SP AusNet West - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$D$41:$D$49,C$39)","v":0.45369999999999999},{"$f":"INDEX(Prop2022DistTar!$D$41:$D$49,D$39)","v":1.6437999999999999},{"$f":"INDEX(Prop2022DistTar!$D$41:$D$49,E$39)","v":1.3854},{"$f":"INDEX(Prop2022DistTar!$D$41:$D$49,F$39)","v":0.85589999999999999},{"$f":"INDEX(Prop2022DistTar!$D$41:$D$49,G$39)","v":0.32090000000000002},{"$f":"INDEX(Prop2022DistTar!$D$41:$D$49,H$39)","v":0.76170000000000004},{"$f":"INDEX(Prop2022DistTar!$D$41:$D$49,I$39)","v":0.64170000000000005},{"$f":"INDEX(Prop2022DistTar!$D$41:$D$49,J$39)","v":0.30919999999999997},{"$f":"INDEX(Prop2022DistTar!$D$41:$D$49,K$39)","v":0.23}]
[]
[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(Prop2022DistTar!$F$41:$F$49,C$39)","v":6008.4620902051502},{"$f":"INDEX(Prop2022DistTar!$F$41:$F$49,D$39)","v":46138.148000000001},{"$f":"INDEX(Prop2022DistTar!$F$41:$F$49,E$39)","v":35255.959000000003},{"$f":"INDEX(Prop2022DistTar!$F$41:$F$49,F$39)","v":182214.49799999999},{"$f":"INDEX(Prop2022DistTar!$F$41:$F$49,G$39)","v":382790.315},{"$f":"INDEX(Prop2022DistTar!$F$41:$F$49,H$39)","v":76826.112999999998},{"$f":"INDEX(Prop2022DistTar!$F$41:$F$49,I$39)","v":48845.392},{"$f":"INDEX(Prop2022DistTar!$F$41:$F$49,J$39)","v":246988.18700000001},{"$f":"INDEX(Prop2022DistTar!$F$41:$F$49,K$39)","v":402194.76799999998}]
[]
[null,{"$f":"B195","v":"Proposed : Tariff V - SP AusNet West - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$F$41:$F$49,C$39)","v":6008.4620902051502},{"$f":"INDEX(Prop2022DistTar!$F$41:$F$49,D$39)","v":46138.148000000001},{"$f":"INDEX(Prop2022DistTar!$F$41:$F$49,E$39)","v":35255.959000000003},{"$f":"INDEX(Prop2022DistTar!$F$41:$F$49,F$39)","v":182214.49799999999},{"$f":"INDEX(Prop2022DistTar!$F$41:$F$49,G$39)","v":382790.315},{"$f":"INDEX(Prop2022DistTar!$F$41:$F$49,H$39)","v":76826.112999999998},{"$f":"INDEX(Prop2022DistTar!$F$41:$F$49,I$39)","v":48845.392},{"$f":"INDEX(Prop2022DistTar!$F$41:$F$49,J$39)","v":246988.18700000001},{"$f":"INDEX(Prop2022DistTar!$F$41:$F$49,K$39)","v":402194.76799999998}]
[]
[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(Prop2022DistTar!$H$41:$H$49,C$40)","v":883376.11342614156},{"$f":"INDEX(Prop2022DistTar!$H$41:$H$49,D$40)","v":84045.250396800009},{"$f":"INDEX(Prop2022DistTar!$H$41:$H$49,E$40)","v":54086.166701900001},{"$f":"INDEX(Prop2022DistTar!$H$41:$H$49,F$40)","v":171390.95681879998},{"$f":"INDEX(Prop2022DistTar!$H$41:$H$49,G$40)","v":132368.890927},{"$f":"INDEX(Prop2022DistTar!$H$41:$H$49,H$40)","v":65033.304654500003},{"$f":"INDEX(Prop2022DistTar!$H$41:$H$49,I$40)","v":34826.764495999996},{"$f":"INDEX(Prop2022DistTar!$H$41:$H$49,J$40)","v":85408.515064599997},{"$f":"INDEX(Prop2022DistTar!$H$41:$H$49,K$40)","v":102680.3242704}]
[]
[null,{"$f":"B201","v":"Proposed : Tariff V - SP AusNet West - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$G$41:$G$49,C$39)","v":995004.32636901783},{"$f":"INDEX(Prop2022DistTar!$G$41:$G$49,D$39)","v":75841.887682400004},{"$f":"INDEX(Prop2022DistTar!$G$41:$G$49,E$39)","v":48843.605598599999},{"$f":"INDEX(Prop2022DistTar!$G$41:$G$49,F$39)","v":155957.38883819999},{"$f":"INDEX(Prop2022DistTar!$G$41:$G$49,G$39)","v":122837.41208350001},{"$f":"INDEX(Prop2022DistTar!$G$41:$G$49,H$39)","v":58518.450272100003},{"$f":"INDEX(Prop2022DistTar!$G$41:$G$49,I$39)","v":31344.088046400004},{"$f":"INDEX(Prop2022DistTar!$G$41:$G$49,J$39)","v":76368.747420399988},{"$f":"INDEX(Prop2022DistTar!$G$41:$G$49,K$39)","v":92504.79664}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B205","v":"Existing : Tariff V - SP AusNet West - Non Residential"},{"$f":"SUM(C205:K205)","v":1613216.2867561413}]
[null,{"$f":"B207","v":"Proposed : Tariff V - SP AusNet West - Non Residential"},{"$f":"SUM(C207:K207)","v":1657220.7029506178}]
[]
[null,"Average price movement",{"$f":"IF(C211=0,\"\",C211/C210)","v":1.0272774435490981}]
[]
[null,{"$f":"IF(C213=\"\",\"\",IF(C213<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!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 : \"&Prop2022DistTar!C61","v":"Existing : Tariff V - Adjoining Central - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$E$63:$E$71,C$40)","v":0.40279999999999999},{"$f":"INDEX(Prop2022DistTar!$E$63:$E$71,D$40)","v":4.1746999999999996},{"$f":"INDEX(Prop2022DistTar!$E$63:$E$71,E$40)","v":3.9756999999999998},{"$f":"INDEX(Prop2022DistTar!$E$63:$E$71,F$40)","v":3.5366},{"$f":"INDEX(Prop2022DistTar!$E$63:$E$71,G$40)","v":3.3578999999999999},{"$f":"INDEX(Prop2022DistTar!$E$63:$E$71,H$40)","v":3.7176},{"$f":"INDEX(Prop2022DistTar!$E$63:$E$71,I$40)","v":3.53},{"$f":"INDEX(Prop2022DistTar!$E$63:$E$71,J$40)","v":3.3582000000000001},{"$f":"INDEX(Prop2022DistTar!$E$63:$E$71,K$40)","v":3.1979000000000002}]
[]
[null,{"$f":"\"Proposed : \"&B219","v":"Proposed : Tariff V - Adjoining Central - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$D$63:$D$71,C$39)","v":0.45369999999999999},{"$f":"INDEX(Prop2022DistTar!$D$63:$D$71,D$39)","v":4.0205000000000002},{"$f":"INDEX(Prop2022DistTar!$D$63:$D$71,E$39)","v":3.8311999999999999},{"$f":"INDEX(Prop2022DistTar!$D$63:$D$71,F$39)","v":3.6217000000000001},{"$f":"INDEX(Prop2022DistTar!$D$63:$D$71,G$39)","v":3.4207000000000001},{"$f":"INDEX(Prop2022DistTar!$D$63:$D$71,H$39)","v":3.7008000000000001},{"$f":"INDEX(Prop2022DistTar!$D$63:$D$71,I$39)","v":3.5526},{"$f":"INDEX(Prop2022DistTar!$D$63:$D$71,J$39)","v":3.4424999999999999},{"$f":"INDEX(Prop2022DistTar!$D$63:$D$71,K$39)","v":3.3584000000000001}]
[]
[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(Prop2022DistTar!$F$63:$F$71,C$39)","v":16.774046859069241},{"$f":"INDEX(Prop2022DistTar!$F$63:$F$71,D$39)","v":181.83500000000001},{"$f":"INDEX(Prop2022DistTar!$F$63:$F$71,E$39)","v":141.35400000000001},{"$f":"INDEX(Prop2022DistTar!$F$63:$F$71,F$39)","v":634.54499999999996},{"$f":"INDEX(Prop2022DistTar!$F$63:$F$71,G$39)","v":77.841999999999999},{"$f":"INDEX(Prop2022DistTar!$F$63:$F$71,H$39)","v":274.78500000000003},{"$f":"INDEX(Prop2022DistTar!$F$63:$F$71,I$39)","v":183.36699999999999},{"$f":"INDEX(Prop2022DistTar!$F$63:$F$71,J$39)","v":1222.7049999999999},{"$f":"INDEX(Prop2022DistTar!$F$63:$F$71,K$39)","v":468.75700000000001}]
[]
[null,{"$f":"B225","v":"Proposed : Tariff V - Adjoining Central - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$F$63:$F$71,C$39)","v":16.774046859069241},{"$f":"INDEX(Prop2022DistTar!$F$63:$F$71,D$39)","v":181.83500000000001},{"$f":"INDEX(Prop2022DistTar!$F$63:$F$71,E$39)","v":141.35400000000001},{"$f":"INDEX(Prop2022DistTar!$F$63:$F$71,F$39)","v":634.54499999999996},{"$f":"INDEX(Prop2022DistTar!$F$63:$F$71,G$39)","v":77.841999999999999},{"$f":"INDEX(Prop2022DistTar!$F$63:$F$71,H$39)","v":274.78500000000003},{"$f":"INDEX(Prop2022DistTar!$F$63:$F$71,I$39)","v":183.36699999999999},{"$f":"INDEX(Prop2022DistTar!$F$63:$F$71,J$39)","v":1222.7049999999999},{"$f":"INDEX(Prop2022DistTar!$F$63:$F$71,K$39)","v":468.75700000000001}]
[]
[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(Prop2022DistTar!$H$63:$H$71,C$40)","v":2466.1539173140782},{"$f":"INDEX(Prop2022DistTar!$H$63:$H$71,D$40)","v":759.10657449999997},{"$f":"INDEX(Prop2022DistTar!$H$63:$H$71,E$40)","v":561.98109780000004},{"$f":"INDEX(Prop2022DistTar!$H$63:$H$71,F$40)","v":2244.1318469999997},{"$f":"INDEX(Prop2022DistTar!$H$63:$H$71,G$40)","v":261.38565180000001},{"$f":"INDEX(Prop2022DistTar!$H$63:$H$71,H$40)","v":1021.5407160000001},{"$f":"INDEX(Prop2022DistTar!$H$63:$H$71,I$40)","v":647.28550999999993},{"$f":"INDEX(Prop2022DistTar!$H$63:$H$71,J$40)","v":4106.087931},{"$f":"INDEX(Prop2022DistTar!$H$63:$H$71,K$40)","v":1499.0380103}]
[]
[null,{"$f":"B231","v":"Proposed : Tariff V - Adjoining Central - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$G$63:$G$71,C$39)","v":2777.790546885296},{"$f":"INDEX(Prop2022DistTar!$G$63:$G$71,D$39)","v":731.0676175000001},{"$f":"INDEX(Prop2022DistTar!$G$63:$G$71,E$39)","v":541.55544480000003},{"$f":"INDEX(Prop2022DistTar!$G$63:$G$71,F$39)","v":2298.1316265},{"$f":"INDEX(Prop2022DistTar!$G$63:$G$71,G$39)","v":266.27412939999999},{"$f":"INDEX(Prop2022DistTar!$G$63:$G$71,H$39)","v":1016.9243280000002},{"$f":"INDEX(Prop2022DistTar!$G$63:$G$71,I$39)","v":651.42960419999997},{"$f":"INDEX(Prop2022DistTar!$G$63:$G$71,J$39)","v":4209.1619624999994},{"$f":"INDEX(Prop2022DistTar!$G$63:$G$71,K$39)","v":1574.2735087999999}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B235","v":"Existing : Tariff V - Adjoining Central - Non Residential"},{"$f":"SUM(C235:K235)","v":13566.711255714079}]
[null,{"$f":"B237","v":"Proposed : Tariff V - Adjoining Central - Non Residential"},{"$f":"SUM(C237:K237)","v":14066.608768585298}]
[]
[null,"Average price movement",{"$f":"IF(C241=0,\"\",C241/C240)","v":1.0368473614163987}]
[]
[null,{"$f":"IF(C243=\"\",\"\",IF(C243<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!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 : \"&Prop2022DistTar!C83","v":"Existing : Tariff V - Adjoining West - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$E$85:$E$93,C$40)","v":0.40279999999999999},{"$f":"INDEX(Prop2022DistTar!$E$85:$E$93,D$40)","v":4.9333},{"$f":"INDEX(Prop2022DistTar!$E$85:$E$93,E$40)","v":4.6258999999999997},{"$f":"INDEX(Prop2022DistTar!$E$85:$E$93,F$40)","v":3.8874},{"$f":"INDEX(Prop2022DistTar!$E$85:$E$93,G$40)","v":3.3166000000000002},{"$f":"INDEX(Prop2022DistTar!$E$85:$E$93,H$40)","v":3.7970999999999999},{"$f":"INDEX(Prop2022DistTar!$E$85:$E$93,I$40)","v":3.6160999999999999},{"$f":"INDEX(Prop2022DistTar!$E$85:$E$93,J$40)","v":3.1371000000000002},{"$f":"INDEX(Prop2022DistTar!$E$85:$E$93,K$40)","v":2.9533999999999998}]
[]
[null,{"$f":"\"Proposed : \"&B249","v":"Proposed : Tariff V - Adjoining West - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$D$85:$D$93,C$39)","v":0.45369999999999999},{"$f":"INDEX(Prop2022DistTar!$D$85:$D$93,D$39)","v":4.9612999999999996},{"$f":"INDEX(Prop2022DistTar!$D$85:$D$93,E$39)","v":4.657},{"$f":"INDEX(Prop2022DistTar!$D$85:$D$93,F$39)","v":3.9998999999999998},{"$f":"INDEX(Prop2022DistTar!$D$85:$D$93,G$39)","v":3.516},{"$f":"INDEX(Prop2022DistTar!$D$85:$D$93,H$39)","v":3.8140999999999998},{"$f":"INDEX(Prop2022DistTar!$D$85:$D$93,I$39)","v":3.629},{"$f":"INDEX(Prop2022DistTar!$D$85:$D$93,J$39)","v":3.1726000000000001},{"$f":"INDEX(Prop2022DistTar!$D$85:$D$93,K$39)","v":3.0211999999999999}]
[]
[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(Prop2022DistTar!$F$85:$F$93,C$39)","v":280.10232333745199},{"$f":"INDEX(Prop2022DistTar!$F$85:$F$93,D$39)","v":2554.5810000000001},{"$f":"INDEX(Prop2022DistTar!$F$85:$F$93,E$39)","v":2128.0250000000001},{"$f":"INDEX(Prop2022DistTar!$F$85:$F$93,F$39)","v":11241.86},{"$f":"INDEX(Prop2022DistTar!$F$85:$F$93,G$39)","v":19772.989000000001},{"$f":"INDEX(Prop2022DistTar!$F$85:$F$93,H$39)","v":4681.9399999999996},{"$f":"INDEX(Prop2022DistTar!$F$85:$F$93,I$39)","v":3357.3690000000001},{"$f":"INDEX(Prop2022DistTar!$F$85:$F$93,J$39)","v":18023.665000000001},{"$f":"INDEX(Prop2022DistTar!$F$85:$F$93,K$39)","v":24556.594000000001}]
[]
[null,{"$f":"B255","v":"Proposed : Tariff V - Adjoining West - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$F$85:$F$93,C$39)","v":280.10232333745199},{"$f":"INDEX(Prop2022DistTar!$F$85:$F$93,D$39)","v":2554.5810000000001},{"$f":"INDEX(Prop2022DistTar!$F$85:$F$93,E$39)","v":2128.0250000000001},{"$f":"INDEX(Prop2022DistTar!$F$85:$F$93,F$39)","v":11241.86},{"$f":"INDEX(Prop2022DistTar!$F$85:$F$93,G$39)","v":19772.989000000001},{"$f":"INDEX(Prop2022DistTar!$F$85:$F$93,H$39)","v":4681.9399999999996},{"$f":"INDEX(Prop2022DistTar!$F$85:$F$93,I$39)","v":3357.3690000000001},{"$f":"INDEX(Prop2022DistTar!$F$85:$F$93,J$39)","v":18023.665000000001},{"$f":"INDEX(Prop2022DistTar!$F$85:$F$93,K$39)","v":24556.594000000001}]
[]
[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(Prop2022DistTar!$H$85:$H$93,C$40)","v":41181.203781718861},{"$f":"INDEX(Prop2022DistTar!$H$85:$H$93,D$40)","v":12602.5144473},{"$f":"INDEX(Prop2022DistTar!$H$85:$H$93,E$40)","v":9844.0308475000002},{"$f":"INDEX(Prop2022DistTar!$H$85:$H$93,F$40)","v":43701.606564000002},{"$f":"INDEX(Prop2022DistTar!$H$85:$H$93,G$40)","v":65579.095317400002},{"$f":"INDEX(Prop2022DistTar!$H$85:$H$93,H$40)","v":17777.794373999997},{"$f":"INDEX(Prop2022DistTar!$H$85:$H$93,I$40)","v":12140.582040900001},{"$f":"INDEX(Prop2022DistTar!$H$85:$H$93,J$40)","v":56542.039471500007},{"$f":"INDEX(Prop2022DistTar!$H$85:$H$93,K$40)","v":72525.444719599996}]
[]
[null,{"$f":"B261","v":"Proposed : Tariff V - Adjoining West - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$G$85:$G$93,C$39)","v":46385.084795843715},{"$f":"INDEX(Prop2022DistTar!$G$85:$G$93,D$39)","v":12674.0427153},{"$f":"INDEX(Prop2022DistTar!$G$85:$G$93,E$39)","v":9910.2124249999997},{"$f":"INDEX(Prop2022DistTar!$G$85:$G$93,F$39)","v":44966.315814000001},{"$f":"INDEX(Prop2022DistTar!$G$85:$G$93,G$39)","v":69521.829324000006},{"$f":"INDEX(Prop2022DistTar!$G$85:$G$93,H$39)","v":17857.387353999999},{"$f":"INDEX(Prop2022DistTar!$G$85:$G$93,I$39)","v":12183.892101000001},{"$f":"INDEX(Prop2022DistTar!$G$85:$G$93,J$39)","v":57181.879579000008},{"$f":"INDEX(Prop2022DistTar!$G$85:$G$93,K$39)","v":74190.381792800006}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B265","v":"Existing : Tariff V - Adjoining West - Non Residential"},{"$f":"SUM(C265:K265)","v":331894.31156391883}]
[null,{"$f":"B267","v":"Proposed : Tariff V - Adjoining West - Non Residential"},{"$f":"SUM(C267:K267)","v":344871.02590094379}]
[]
[null,"Average price movement",{"$f":"IF(C271=0,\"\",C271/C270)","v":1.0390989356698443}]
[]
[null,{"$f":"IF(C273=\"\",\"\",IF(C273<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!B95","v":"Tariff M - SP AusNet Central"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2022DistTar!C95","v":"Existing: Tariff M - SP AusNet Central"},{"$f":"INDEX(Prop2022DistTar!$E$96:$E$98,C280)","v":680.0702},{"$f":"INDEX(Prop2022DistTar!$E$96:$E$98,D280)","v":647.71019999999999},{"$f":"INDEX(Prop2022DistTar!$E$96:$E$98,E280)","v":135.2432}]
[null,{"$f":"\"Proposed: \"&B279","v":"Proposed: Tariff M - SP AusNet Central"},{"$f":"INDEX(Prop2022DistTar!$D$96:$D$98,C280)","v":692.80970000000002},{"$f":"INDEX(Prop2022DistTar!$D$96:$D$98,D280)","v":659.84349999999995},{"$f":"INDEX(Prop2022DistTar!$D$96:$D$98,E280)","v":137.77670000000001}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B282","v":"Existing: Tariff M - SP AusNet Central"},{"$f":"INDEX(Prop2022DistTar!$F$96:$F$98,C$280)","v":167.92999999999998},{"$f":"INDEX(Prop2022DistTar!$F$96:$F$98,D$280)","v":50.949999999999996},{"$f":"INDEX(Prop2022DistTar!$F$96:$F$98,E$280)","v":0}]
[null,{"$f":"B283","v":"Proposed: Tariff M - SP AusNet Central"},{"$f":"INDEX(Prop2022DistTar!$F$96:$F$98,C$280)","v":167.92999999999998},{"$f":"INDEX(Prop2022DistTar!$F$96:$F$98,D$280)","v":50.949999999999996},{"$f":"INDEX(Prop2022DistTar!$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(Prop2022DistTar!$H$96:$H$98,C280)","v":114204.18868599998},{"$f":"INDEX(Prop2022DistTar!$H$96:$H$98,D280)","v":33000.834689999996},{"$f":"INDEX(Prop2022DistTar!$H$96:$H$98,E280)","v":0}]
[null,{"$f":"B287","v":"Proposed: Tariff M - SP AusNet Central"},{"$f":"INDEX(Prop2022DistTar!$G$96:$G$98,C280)","v":116343.53292099999},{"$f":"INDEX(Prop2022DistTar!$G$96:$G$98,D280)","v":33619.026324999992},{"$f":"INDEX(Prop2022DistTar!$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":147205.02337599997}]
[null,{"$f":"B291","v":"Proposed: Tariff M - SP AusNet Central"},{"$f":"SUM(C291:E291)","v":149962.55924599999}]
[]
[null,"Average price movement",{"$f":"IF(C295=0,\"\",C295/C294)","v":1.0187326207133336}]
[]
[null,{"$f":"IF(C297=\"\",\"\",IF(C297<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!B100","v":"Tariff M - SP AusNet West"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2022DistTar!C100","v":"Existing: Tariff M - SP AusNet West"},{"$f":"INDEX(Prop2022DistTar!$E$101:$E$103,C304)","v":680.0702},{"$f":"INDEX(Prop2022DistTar!$E$101:$E$103,D304)","v":647.71019999999999},{"$f":"INDEX(Prop2022DistTar!$E$101:$E$103,E304)","v":135.2432}]
[null,{"$f":"\"Proposed: \"&B303","v":"Proposed: Tariff M - SP AusNet West"},{"$f":"INDEX(Prop2022DistTar!$D$101:$D$103,C304)","v":692.80970000000002},{"$f":"INDEX(Prop2022DistTar!$D$101:$D$103,D304)","v":659.84349999999995},{"$f":"INDEX(Prop2022DistTar!$D$101:$D$103,E304)","v":137.77670000000001}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B306","v":"Existing: Tariff M - SP AusNet West"},{"$f":"INDEX(Prop2022DistTar!$F$101:$F$103,C$280)","v":43.449999999999996},{"$f":"INDEX(Prop2022DistTar!$F$101:$F$103,D$280)","v":29.05},{"$f":"INDEX(Prop2022DistTar!$F$101:$F$103,E$280)","v":0}]
[null,{"$f":"B307","v":"Proposed: Tariff M - SP AusNet West"},{"$f":"INDEX(Prop2022DistTar!$F$101:$F$103,C$280)","v":43.449999999999996},{"$f":"INDEX(Prop2022DistTar!$F$101:$F$103,D$280)","v":29.05},{"$f":"INDEX(Prop2022DistTar!$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(Prop2022DistTar!$H$101:$H$103,C304)","v":29549.050189999998},{"$f":"INDEX(Prop2022DistTar!$H$101:$H$103,D304)","v":18815.981309999999},{"$f":"INDEX(Prop2022DistTar!$H$101:$H$103,E304)","v":0}]
[null,{"$f":"B311","v":"Proposed: Tariff M - SP AusNet West"},{"$f":"INDEX(Prop2022DistTar!$G$101:$G$103,C304)","v":30102.581464999999},{"$f":"INDEX(Prop2022DistTar!$G$101:$G$103,D304)","v":19168.453675000001},{"$f":"INDEX(Prop2022DistTar!$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":48365.031499999997}]
[null,{"$f":"B315","v":"Proposed: Tariff M - SP AusNet West"},{"$f":"SUM(C315:E315)","v":49271.03514}]
[]
[null,"Average price movement",{"$f":"IF(C319=0,\"\",C319/C318)","v":1.0187326175937672}]
[]
[null,{"$f":"IF(C321=\"\",\"\",IF(C321<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!B105","v":"Tariff M - Adjoining Central"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2022DistTar!C105","v":"Existing: Tariff M - Adjoining Central"},{"$f":"INDEX(Prop2022DistTar!$E$106:$E$108,C328)","v":680.0702},{"$f":"INDEX(Prop2022DistTar!$E$106:$E$108,D328)","v":647.71019999999999},{"$f":"INDEX(Prop2022DistTar!$E$106:$E$108,E328)","v":135.2432}]
[null,{"$f":"\"Proposed: \"&B327","v":"Proposed: Tariff M - Adjoining Central"},{"$f":"INDEX(Prop2022DistTar!$D$106:$D$108,C328)","v":692.80970000000002},{"$f":"INDEX(Prop2022DistTar!$D$106:$D$108,D328)","v":659.84349999999995},{"$f":"INDEX(Prop2022DistTar!$D$106:$D$108,E328)","v":137.77670000000001}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B330","v":"Existing: Tariff M - Adjoining Central"},{"$f":"INDEX(Prop2022DistTar!$F$106:$F$108,C$280)","v":0},{"$f":"INDEX(Prop2022DistTar!$F$106:$F$108,D$280)","v":0},{"$f":"INDEX(Prop2022DistTar!$F$106:$F$108,E$280)","v":0}]
[null,{"$f":"B331","v":"Proposed: Tariff M - Adjoining Central"},{"$f":"INDEX(Prop2022DistTar!$F$106:$F$108,C$280)","v":0},{"$f":"INDEX(Prop2022DistTar!$F$106:$F$108,D$280)","v":0},{"$f":"INDEX(Prop2022DistTar!$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(Prop2022DistTar!$H$106:$H$108,C328)","v":0},{"$f":"INDEX(Prop2022DistTar!$H$106:$H$108,D328)","v":0},{"$f":"INDEX(Prop2022DistTar!$H$106:$H$108,E328)","v":0}]
[null,{"$f":"B335","v":"Proposed: Tariff M - Adjoining Central"},{"$f":"INDEX(Prop2022DistTar!$G$106:$G$108,C328)","v":0},{"$f":"INDEX(Prop2022DistTar!$G$106:$G$108,D328)","v":0},{"$f":"INDEX(Prop2022DistTar!$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":"Prop2022DistTar!B110","v":"Tariff M - Adjoining West"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2022DistTar!C110","v":"Existing: Tariff M - Adjoining West"},{"$f":"INDEX(Prop2022DistTar!$E$111:$E$113,C352)","v":680.0702},{"$f":"INDEX(Prop2022DistTar!$E$111:$E$113,D352)","v":647.71019999999999},{"$f":"INDEX(Prop2022DistTar!$E$111:$E$113,E352)","v":135.2432}]
[null,{"$f":"\"Proposed: \"&B351","v":"Proposed: Tariff M - Adjoining West"},{"$f":"INDEX(Prop2022DistTar!$D$111:$D$113,C352)","v":692.80970000000002},{"$f":"INDEX(Prop2022DistTar!$D$111:$D$113,D352)","v":659.84349999999995},{"$f":"INDEX(Prop2022DistTar!$D$111:$D$113,E352)","v":137.77670000000001}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B354","v":"Existing: Tariff M - Adjoining West"},{"$f":"INDEX(Prop2022DistTar!$F$111:$F$113,C$280)","v":0},{"$f":"INDEX(Prop2022DistTar!$F$111:$F$113,D$280)","v":0},{"$f":"INDEX(Prop2022DistTar!$F$111:$F$113,E$280)","v":0}]
[null,{"$f":"B355","v":"Proposed: Tariff M - Adjoining West"},{"$f":"INDEX(Prop2022DistTar!$F$111:$F$113,C$280)","v":0},{"$f":"INDEX(Prop2022DistTar!$F$111:$F$113,D$280)","v":0},{"$f":"INDEX(Prop2022DistTar!$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(Prop2022DistTar!$H$111:$H$113,C352)","v":0},{"$f":"INDEX(Prop2022DistTar!$H$111:$H$113,D352)","v":0},{"$f":"INDEX(Prop2022DistTar!$H$111:$H$113,E352)","v":0}]
[null,{"$f":"B359","v":"Proposed: Tariff M - Adjoining West"},{"$f":"INDEX(Prop2022DistTar!$G$111:$G$113,C352)","v":0},{"$f":"INDEX(Prop2022DistTar!$G$111:$G$113,D352)","v":0},{"$f":"INDEX(Prop2022DistTar!$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":"Prop2022DistTar!B116","v":"Tariff D - SP AusNet Central"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2022DistTar!C116","v":"Existing: Tariff D - SP AusNet Central"},{"$f":"INDEX(Prop2022DistTar!$E$117:$E$119,C376)","v":310.23239999999998},{"$f":"INDEX(Prop2022DistTar!$E$117:$E$119,D376)","v":295.46179999999998},{"$f":"INDEX(Prop2022DistTar!$E$117:$E$119,E376)","v":143.4504}]
[null,{"$f":"\"Proposed: \"&B375","v":"Proposed: Tariff D - SP AusNet Central"},{"$f":"INDEX(Prop2022DistTar!$D$117:$D$119,C376)","v":316.04379999999998},{"$f":"INDEX(Prop2022DistTar!$D$117:$D$119,D376)","v":300.9966},{"$f":"INDEX(Prop2022DistTar!$D$117:$D$119,E376)","v":146.13759999999999}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B378","v":"Existing: Tariff D - SP AusNet Central"},{"$f":"INDEX(Prop2022DistTar!$F$117:$F$119,C$280)","v":1348.7500000000005},{"$f":"INDEX(Prop2022DistTar!$F$117:$F$119,D$280)","v":1489.3500000000004},{"$f":"INDEX(Prop2022DistTar!$F$117:$F$119,E$280)","v":3188.85}]
[null,{"$f":"B379","v":"Proposed: Tariff D - SP AusNet Central"},{"$f":"INDEX(Prop2022DistTar!$F$117:$F$119,C$280)","v":1348.7500000000005},{"$f":"INDEX(Prop2022DistTar!$F$117:$F$119,D$280)","v":1489.3500000000004},{"$f":"INDEX(Prop2022DistTar!$F$117:$F$119,E$280)","v":3188.85}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B382","v":"Existing: Tariff D - SP AusNet Central"},{"$f":"INDEX(Prop2022DistTar!$H$117:$H$119,C376)","v":418425.9495000001},{"$f":"INDEX(Prop2022DistTar!$H$117:$H$119,D376)","v":440046.03183000011},{"$f":"INDEX(Prop2022DistTar!$H$117:$H$119,E376)","v":457441.80803999997}]
[null,{"$f":"B383","v":"Proposed: Tariff D - SP AusNet Central"},{"$f":"INDEX(Prop2022DistTar!$G$117:$G$119,C376)","v":426264.07525000011},{"$f":"INDEX(Prop2022DistTar!$G$117:$G$119,D376)","v":448289.28621000011},{"$f":"INDEX(Prop2022DistTar!$G$117:$G$119,E376)","v":466010.88575999998}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B386","v":"Existing: Tariff D - SP AusNet Central"},{"$f":"SUM(C386:E386)","v":1315913.7893700001}]
[null,{"$f":"B387","v":"Proposed: Tariff D - SP AusNet Central"},{"$f":"SUM(C387:E387)","v":1340564.2472200003}]
[]
[null,"Average price movement",{"$f":"IF(C391=0,\"\",C391/C390)","v":1.0187325781134962}]
[]
[null,{"$f":"IF(C393=\"\",\"\",IF(C393<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!B121","v":"Tariff D - SP AusNet West"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2022DistTar!C121","v":"Existing: Tariff D - SP AusNet West"},{"$f":"INDEX(Prop2022DistTar!$E$122:$E$124,C400)","v":310.23239999999998},{"$f":"INDEX(Prop2022DistTar!$E$122:$E$124,D400)","v":295.46179999999998},{"$f":"INDEX(Prop2022DistTar!$E$122:$E$124,E400)","v":143.4504}]
[null,{"$f":"\"Proposed: \"&B399","v":"Proposed: Tariff D - SP AusNet West"},{"$f":"INDEX(Prop2022DistTar!$D$122:$D$124,C400)","v":316.04379999999998},{"$f":"INDEX(Prop2022DistTar!$D$122:$D$124,D400)","v":300.9966},{"$f":"INDEX(Prop2022DistTar!$D$122:$D$124,E400)","v":146.13759999999999}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B402","v":"Existing: Tariff D - SP AusNet West"},{"$f":"INDEX(Prop2022DistTar!$F$122:$F$124,C$280)","v":522.45000000000005},{"$f":"INDEX(Prop2022DistTar!$F$122:$F$124,D$280)","v":738.31},{"$f":"INDEX(Prop2022DistTar!$F$122:$F$124,E$280)","v":445.56000000000006}]
[null,{"$f":"B403","v":"Proposed: Tariff D - SP AusNet West"},{"$f":"INDEX(Prop2022DistTar!$F$122:$F$124,C$280)","v":522.45000000000005},{"$f":"INDEX(Prop2022DistTar!$F$122:$F$124,D$280)","v":738.31},{"$f":"INDEX(Prop2022DistTar!$F$122:$F$124,E$280)","v":445.56000000000006}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B406","v":"Existing: Tariff D - SP AusNet West"},{"$f":"INDEX(Prop2022DistTar!$H$122:$H$124,C400)","v":162080.91738},{"$f":"INDEX(Prop2022DistTar!$H$122:$H$124,D400)","v":218142.40155799998},{"$f":"INDEX(Prop2022DistTar!$H$122:$H$124,E400)","v":63915.760224000012}]
[null,{"$f":"B407","v":"Proposed: Tariff D - SP AusNet West"},{"$f":"INDEX(Prop2022DistTar!$G$122:$G$124,C400)","v":165117.08331000002},{"$f":"INDEX(Prop2022DistTar!$G$122:$G$124,D400)","v":222228.79974599998},{"$f":"INDEX(Prop2022DistTar!$G$122:$G$124,E400)","v":65113.069056000008}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B410","v":"Existing: Tariff D - SP AusNet West"},{"$f":"SUM(C410:E410)","v":444139.07916200004}]
[null,{"$f":"B411","v":"Proposed: Tariff D - SP AusNet West"},{"$f":"SUM(C411:E411)","v":452458.95211199997}]
[]
[null,"Average price movement",{"$f":"IF(C415=0,\"\",C415/C414)","v":1.0187325847698379}]
[]
[null,{"$f":"IF(C417=\"\",\"\",IF(C417<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!B126","v":"Tariff D - Adjoining Central"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2022DistTar!C126","v":"Existing: Tariff D - Adjoining Central"},{"$f":"INDEX(Prop2022DistTar!$E$127:$E$129,C424)","v":310.23239999999998},{"$f":"INDEX(Prop2022DistTar!$E$127:$E$129,D424)","v":295.46179999999998},{"$f":"INDEX(Prop2022DistTar!$E$127:$E$129,E424)","v":143.4504}]
[null,{"$f":"\"Proposed: \"&B423","v":"Proposed: Tariff D - Adjoining Central"},{"$f":"INDEX(Prop2022DistTar!$D$127:$D$129,C424)","v":316.04379999999998},{"$f":"INDEX(Prop2022DistTar!$D$127:$D$129,D424)","v":300.9966},{"$f":"INDEX(Prop2022DistTar!$D$127:$D$129,E424)","v":146.13759999999999}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B426","v":"Existing: Tariff D - Adjoining Central"},{"$f":"INDEX(Prop2022DistTar!$F$127:$F$129,C$280)","v":10},{"$f":"INDEX(Prop2022DistTar!$F$127:$F$129,D$280)","v":16.25},{"$f":"INDEX(Prop2022DistTar!$F$127:$F$129,E$280)","v":0}]
[null,{"$f":"B427","v":"Proposed: Tariff D - Adjoining Central"},{"$f":"INDEX(Prop2022DistTar!$F$127:$F$129,C$280)","v":10},{"$f":"INDEX(Prop2022DistTar!$F$127:$F$129,D$280)","v":16.25},{"$f":"INDEX(Prop2022DistTar!$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(Prop2022DistTar!$H$127:$H$129,C424)","v":3102.3239999999996},{"$f":"INDEX(Prop2022DistTar!$H$127:$H$129,D424)","v":4801.25425},{"$f":"INDEX(Prop2022DistTar!$H$127:$H$129,E424)","v":0}]
[null,{"$f":"B431","v":"Proposed: Tariff D - Adjoining Central"},{"$f":"INDEX(Prop2022DistTar!$G$127:$G$129,C424)","v":3160.4379999999996},{"$f":"INDEX(Prop2022DistTar!$G$127:$G$129,D424)","v":4891.1947499999997},{"$f":"INDEX(Prop2022DistTar!$G$127:$G$129,E424)","v":0}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B434","v":"Existing: Tariff D - Adjoining Central"},{"$f":"SUM(C434:E434)","v":7903.5782499999996}]
[null,{"$f":"B435","v":"Proposed: Tariff D - Adjoining Central"},{"$f":"SUM(C435:E435)","v":8051.6327499999989}]
[]
[null,"Average price movement",{"$f":"IF(C439=0,\"\",C439/C438)","v":1.0187325911526213}]
[]
[null,{"$f":"IF(C441=\"\",\"\",IF(C441<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!B131","v":"Tariff D - Adjoining West"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2022DistTar!C131","v":"Existing: Tariff D - Adjoining West"},{"$f":"INDEX(Prop2022DistTar!$E$132:$E$134,C448)","v":310.23239999999998},{"$f":"INDEX(Prop2022DistTar!$E$132:$E$134,D448)","v":295.46179999999998},{"$f":"INDEX(Prop2022DistTar!$E$132:$E$134,E448)","v":143.4504}]
[null,{"$f":"\"Proposed: \"&B447","v":"Proposed: Tariff D - Adjoining West"},{"$f":"INDEX(Prop2022DistTar!$D$132:$D$134,C448)","v":316.04379999999998},{"$f":"INDEX(Prop2022DistTar!$D$132:$D$134,D448)","v":300.9966},{"$f":"INDEX(Prop2022DistTar!$D$132:$D$134,E448)","v":146.13759999999999}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B450","v":"Existing: Tariff D - Adjoining West"},{"$f":"INDEX(Prop2022DistTar!$F$132:$F$134,C$280)","v":11.22},{"$f":"INDEX(Prop2022DistTar!$F$132:$F$134,D$280)","v":6.89},{"$f":"INDEX(Prop2022DistTar!$F$132:$F$134,E$280)","v":0}]
[null,{"$f":"B451","v":"Proposed: Tariff D - Adjoining West"},{"$f":"INDEX(Prop2022DistTar!$F$132:$F$134,C$280)","v":11.22},{"$f":"INDEX(Prop2022DistTar!$F$132:$F$134,D$280)","v":6.89},{"$f":"INDEX(Prop2022DistTar!$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(Prop2022DistTar!$H$132:$H$134,C448)","v":3480.8075279999998},{"$f":"INDEX(Prop2022DistTar!$H$132:$H$134,D448)","v":2035.7318019999998},{"$f":"INDEX(Prop2022DistTar!$H$132:$H$134,E448)","v":0}]
[null,{"$f":"B455","v":"Proposed: Tariff D - Adjoining West"},{"$f":"INDEX(Prop2022DistTar!$G$132:$G$134,C448)","v":3546.0114359999998},{"$f":"INDEX(Prop2022DistTar!$G$132:$G$134,D448)","v":2073.8665740000001},{"$f":"INDEX(Prop2022DistTar!$G$132:$G$134,E448)","v":0}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B458","v":"Existing: Tariff D - Adjoining West"},{"$f":"SUM(C458:E458)","v":5516.5393299999996}]
[null,{"$f":"B459","v":"Proposed: Tariff D - Adjoining West"},{"$f":"SUM(C459:E459)","v":5619.8780100000004}]
[]
[null,"Average price movement",{"$f":"IF(C463=0,\"\",C463/C462)","v":1.0187325193963588}]
[]
[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":2021},{"$f":"'Model update'!$B$5","v":2022}]
["Disconnection",60.36,{"$f":"ROUND(B6*(1+'Model update'!$B$30),2)","v":62.68}]
["Reconnection of Meter ",60.36,{"$f":"ROUND(B7*(1+'Model update'!$B$30),2)","v":62.68}]
["Special Meter Reads",9.36,{"$f":"ROUND(B8*(1+'Model update'!$B$30),2)","v":9.7200000000000006}]
["Meter and gas installation test",181.09,{"$f":"ROUND(B9*(1+'Model update'!$B$30),2)","v":188.06}]
[]
["Note: Formula is as per AA2018-22, Part B, section 2, p9 : ART = ARTt-1  * (1+CPIt)"]

{"sheet":"PTRM_Link","index":6,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Full Year CPI",{"$f":"(1+6.1%)^0.5-1","v":3.0048542545447088E-2}]
[]
[]
[null,null,"Standing Charge ($ per customer per year)","Peak 0 - 0.1","Peak 0.1 - 0.2","Peak 0.2 - 1.4","Peak > 1.4","Off Peak 0 - 0.1","Off Peak 0.1 - 0.2","Off Peak 0.2 - 1.4","Off Peak > 1.4","0 - 10 MHQ ($/GJ/hour)","10 - 50 MHQ ($/GJ/hour)","> 50 MHQ ($/GJ/hour)"]
[null,null,2022,2022,2022,2022,2022,2022,2022,2022,2022,2022,2022,2022]
[null,"Domestic Tariff V Zone - SP AusNet Central",{"$f":"Prop2022DistTar!D8*365","v":158.62899999999999},{"$f":"Prop2022DistTar!$D9","v":5.9707999999999997},{"$f":"Prop2022DistTar!$D10","v":3.5987},{"$f":"Prop2022DistTar!$D11","v":0.62570000000000003},{"$f":"Prop2022DistTar!$D12","v":0.56200000000000006},{"$f":"Prop2022DistTar!$D13","v":2.0238999999999998},{"$f":"Prop2022DistTar!$D14","v":1.5993999999999999},{"$f":"Prop2022DistTar!$D15","v":0.61299999999999999},{"$f":"Prop2022DistTar!$D16","v":0.21740000000000001},0,0,0]
[null,"Commercial Tariff V Zone - SP AusNet Central",{"$f":"Prop2022DistTar!D19*365","v":165.60050000000001},{"$f":"Prop2022DistTar!$D20","v":1.0755999999999999},{"$f":"Prop2022DistTar!$D21","v":1.0246999999999999},{"$f":"Prop2022DistTar!$D22","v":0.92210000000000003},{"$f":"Prop2022DistTar!$D23","v":0.70389999999999997},{"$f":"Prop2022DistTar!$D24","v":1.0192000000000001},{"$f":"Prop2022DistTar!$D25","v":0.71309999999999996},{"$f":"Prop2022DistTar!$D26","v":0.58709999999999996},{"$f":"Prop2022DistTar!$D27","v":0.56920000000000004},0,0,0]
[null,"Domestic Tariff V Zone - SP AusNet West",{"$f":"Prop2022DistTar!D30*365","v":158.62899999999999},{"$f":"Prop2022DistTar!$D31","v":3.1560000000000001},{"$f":"Prop2022DistTar!$D32","v":2.2725},{"$f":"Prop2022DistTar!$D33","v":0.73409999999999997},{"$f":"Prop2022DistTar!$D34","v":0.7036},{"$f":"Prop2022DistTar!$D35","v":0.9758},{"$f":"Prop2022DistTar!$D36","v":0.91449999999999998},{"$f":"Prop2022DistTar!$D37","v":0.52139999999999997},{"$f":"Prop2022DistTar!$D38","v":0.10290000000000001},0,0,0]
[null,"Commercial Tariff V Zone - SP AusNet West",{"$f":"Prop2022DistTar!D41*365","v":165.60050000000001},{"$f":"Prop2022DistTar!$D42","v":1.6437999999999999},{"$f":"Prop2022DistTar!$D43","v":1.3854},{"$f":"Prop2022DistTar!$D44","v":0.85589999999999999},{"$f":"Prop2022DistTar!$D45","v":0.32090000000000002},{"$f":"Prop2022DistTar!$D46","v":0.76170000000000004},{"$f":"Prop2022DistTar!$D47","v":0.64170000000000005},{"$f":"Prop2022DistTar!$D48","v":0.30919999999999997},{"$f":"Prop2022DistTar!$D49","v":0.23},0,0,0]
[null,"Domestic Tariff V Zone - SP AusNet Adjoining Central",{"$f":"Prop2022DistTar!D52*365","v":158.62899999999999},{"$f":"Prop2022DistTar!$D53","v":9.7782999999999998},{"$f":"Prop2022DistTar!$D54","v":7.0468999999999999},{"$f":"Prop2022DistTar!$D55","v":2.5099999999999998},{"$f":"Prop2022DistTar!$D56","v":2.4068000000000001},{"$f":"Prop2022DistTar!$D57","v":4.3792},{"$f":"Prop2022DistTar!$D58","v":2.5396000000000001},{"$f":"Prop2022DistTar!$D59","v":2.2098},{"$f":"Prop2022DistTar!$D60","v":2.1251000000000002},0,0,0]
[null,"Commercial Tariff V Zone - SP AusNet Adjoining Central",{"$f":"Prop2022DistTar!D63*365","v":165.60050000000001},{"$f":"Prop2022DistTar!$D64","v":4.0205000000000002},{"$f":"Prop2022DistTar!$D65","v":3.8311999999999999},{"$f":"Prop2022DistTar!$D66","v":3.6217000000000001},{"$f":"Prop2022DistTar!$D67","v":3.4207000000000001},{"$f":"Prop2022DistTar!$D68","v":3.7008000000000001},{"$f":"Prop2022DistTar!$D69","v":3.5526},{"$f":"Prop2022DistTar!$D70","v":3.4424999999999999},{"$f":"Prop2022DistTar!$D71","v":3.3584000000000001},0,0,0]
[null,"Domestic Tariff V Zone - SP AusNet Adjoining West",{"$f":"Prop2022DistTar!D74*365","v":158.62899999999999},{"$f":"Prop2022DistTar!$D75","v":6.8521000000000001},{"$f":"Prop2022DistTar!$D76","v":5.7530000000000001},{"$f":"Prop2022DistTar!$D77","v":2.9525000000000001},{"$f":"Prop2022DistTar!$D78","v":2.6482000000000001},{"$f":"Prop2022DistTar!$D79","v":4.0662000000000003},{"$f":"Prop2022DistTar!$D80","v":3.0752000000000002},{"$f":"Prop2022DistTar!$D81","v":2.2019000000000002},{"$f":"Prop2022DistTar!$D82","v":2.133},0,0,0]
[null,"Commercial Tariff V Zone - SP AusNet Adjoining West",{"$f":"Prop2022DistTar!D85*365","v":165.60050000000001},{"$f":"Prop2022DistTar!$D86","v":4.9612999999999996},{"$f":"Prop2022DistTar!$D87","v":4.657},{"$f":"Prop2022DistTar!$D88","v":3.9998999999999998},{"$f":"Prop2022DistTar!$D89","v":3.516},{"$f":"Prop2022DistTar!$D90","v":3.8140999999999998},{"$f":"Prop2022DistTar!$D91","v":3.629},{"$f":"Prop2022DistTar!$D92","v":3.1726000000000001},{"$f":"Prop2022DistTar!$D93","v":3.0211999999999999},0,0,0]
[null," Tariff D Zone - SP AusNet West & Central",0,0,0,0,0,0,0,0,0,{"$f":"Prop2022DistTar!$D117","v":316.04379999999998},{"$f":"Prop2022DistTar!$D118","v":300.9966},{"$f":"Prop2022DistTar!$D119","v":146.13759999999999}]
[null," Tariff D Zone - SP AusNet Adjoining West & Central",0,0,0,0,0,0,0,0,0,{"$f":"Prop2022DistTar!$D127","v":316.04379999999998},{"$f":"Prop2022DistTar!$D128","v":300.9966},{"$f":"Prop2022DistTar!$D129","v":146.13759999999999}]
[null," Tariff M Zone - SP AusNet West & Central",0,0,0,0,0,0,0,0,0,{"$f":"Prop2022DistTar!$D96","v":692.80970000000002},{"$f":"Prop2022DistTar!$D97","v":659.84349999999995},{"$f":"Prop2022DistTar!$D98","v":137.77670000000001}]
[null," Tariff M Zone - SP AusNet Adjoining West & Central",0,0,0,0,0,0,0,0,0,{"$f":"Prop2022DistTar!$D106","v":692.80970000000002},{"$f":"Prop2022DistTar!$D107","v":659.84349999999995},{"$f":"Prop2022DistTar!$D108","v":137.77670000000001}]
[]
[]
[]
[null,"Domestic Tariff V Zone - SP AusNet Central",{"$f":"C8*(1+$C$3)","v":163.39557025544173},{"$f":"D8*(1+$C$3)","v":6.1502138378303552},3.7068356900583006,0.64450137307068622,0.57888728091054131,2.0847152452577302,1.6474596389471881,0.63141975658035909,0.22393255314938021,0,0,0]
[null,"Commercial Tariff V Zone - SP AusNet Central",{"$f":"C9*(1+$C$3)","v":170.57655366979733},1.1079202123618828,1.0554907415463195,0.94980776108115683,0.72505116909774014,1.0498254745623197,0.73452761568915825,0.60474149932843191,0.5863036304168685,0,0,0]
[null,"Domestic Tariff V Zone - SP AusNet West",163.39557025544173,3.2508332002734313,2.3407853129345284,0.75615863508261272,0.72474215453497659,1.0051213678158473,0.94197939215781135,0.53706731008319608,0.10599199502792651,0,0,0]
[null,"Commercial Tariff V Zone - SP AusNet West",170.57655366979733,1.6931937942362059,1.4270292508424625,0.88161854756464819,0.33054257730283398,0.78458797485686704,0.66098214975141345,0.3184910093550522,0.23691116478545285,0,0,0]
[null,"Domestic Tariff V Zone - SP AusNet Adjoining Central",163.39557025544173,10.072123663572144,7.258649074463511,2.585421841789072,2.4791208321983822,4.5107885775150223,2.6159112786484173,2.2762012693169291,2.1889561577633296,0,0,0]
[null,"Commercial Tariff V Zone - SP AusNet Adjoining Central",170.57655366979733,4.1413101653039703,3.9463219762001169,3.730526806536846,3.5234870494852109,3.8120036462521907,3.6593504522469553,3.5459421077127016,3.4593150252846296,0,0,0]
[null,"Domestic Tariff V Zone - SP AusNet Adjoining West",163.39557025544173,7.0579956183756583,5.9258692652639571,3.0412183218654327,2.7277745503688533,4.1883833836982971,3.1676052780357589,2.26806388583082,2.1970935412494388,0,0,0]
[null,"Commercial Tariff V Zone - SP AusNet Adjoining West",170.57655366979733,5.1103798341307263,4.7969360626341473,4.1200911653275334,3.6216506755897919,3.9287081461225895,3.7380461608974276,3.2679320060796857,3.1119826567383044,0,0,0]
[null," Tariff D Zone - SP AusNet West & Central",0,0,0,0,0,0,0,0,0,325.54045557052473,310.04110914113494,150.52882189108951]
[null," Tariff D Zone - SP AusNet Adjoining West & Central",0,0,0,0,0,0,0,0,0,325.54045557052473,310.04110914113494,150.52882189108951]
[null," Tariff M Zone - SP AusNet West & Central",0,0,0,0,0,0,0,0,0,713.6276217463485,679.67083548308665,141.91668903172132]
[null," Tariff M Zone - SP AusNet Adjoining West & Central",0,0,0,0,0,0,0,0,0,713.6276217463485,679.67083548308665,141.91668903172132]