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

{"sheet":"NOTES","index":0,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
["The model has actual and test data to illustrate the workings of the model.",null,null,{"$f":"'Model update'!B5","v":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 \"&$D$2&\" value\"","v":"Updated 2022 value"}]
[]
[{"$f":"A8+1","v":3},"'Model update'!B46",{"$f":"\"Pass Through Amount for \"&D2","v":"Pass Through Amount for 2022"},"NIL for 2022"]
[]
[{"$f":"A10+1","v":4},"'Model update'!B58","Real Pre-tax WACC (rptw)",{"$f":"\"Updated \"&$D$2&\" value\"","v":"Updated 2022 value"}]
[]
[{"$f":"A12+1","v":5},{"$f":"\"Prop\"&D2&\"DistTar!E8:E96\"","v":"Prop2022DistTar!E8:E96"},{"$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:B12",{"$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:D96\"","v":"Prop2022DistTar!D8:D96"},{"$f":"\"Proposed \"&D2&\" Tariffs\"","v":"Proposed 2022 Tariffs"}]
[null,{"$f":"\"Prop\"&D2&\"DistTar!F8:F96\"","v":"Prop2022DistTar!F8:F96"},{"$f":"\"Actual \"&D2-2&\" Volumes\"","v":"Actual 2020 Volumes"}]
[]
[null,"ARS!C6:C12",{"$f":"\"Proposed \"&D2&\" Ancillary Reference Services Charges\"","v":"Proposed 2022 Ancillary Reference Services Charges"},"Calculated using formula"]

{"sheet":"Model update","index":1,"n_rows":58,"n_cols":2,"rows_kept":58,"cut":false,"hidden":false,"merged":[[54,0,55,1]]}
[]
[]
["Tariff Approval Template for ","Aust. Gas Networks (Vic & Albury)"]
[]
["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:B$22,2,FALSE)","v":114.8}]
[{"$f":"\"CPI Index June \" &$B$9","v":"CPI Index June 2020"},{"$f":"VLOOKUP(A26,A$17:B$22,2,FALSE)","v":114.4}]
[{"$f":"\"CPI Index June \" &$B$8","v":"CPI Index June 2021"},{"$f":"VLOOKUP(A27,A$17:B$22,2,FALSE)","v":118.8}]
[]
[{"$f":"\"CPI \" &$B$8","v":"CPI 2021"},{"$f":"B26/B25-1","v":-3.4843205574912606E-3}]
[{"$f":"\"CPI \" &$B$5","v":"CPI 2022"},{"$f":"B27/B26-1","v":3.8461538461538325E-2}]
[]
[]
[{"$f":"\"Xt for \"&B$5","v":"Xt for 2022"}]
[2019,-1.2932003198752063E-2]
[2020,-5.9643805428307873E-3]
[2021,-2.9121585433830224E-3]
[2022,{"$f":"'[1]Model update'!$B$37","v":-5.6359370969629296E-3}]
[]
[]
[{"$f":"\"Xt for \"&B$5","v":"Xt for 2022"},{"$f":"VLOOKUP(B5,A34:B38,2,FALSE)","v":-5.6359370969629296E-3}]
[]
[]
["Pass Through Amounts :  PT (t)"]
[2019,0]
[2020,0]
[2021,0]
[2022,0]
[]
[]
[{"$f":"\"Pass Through Amount for \"&B$5","v":"Pass Through Amount for 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 "]
[]
[]
[" Pretax WACCD",3.605542631615144E-2]

{"sheet":"Prop2022DistTar","index":2,"n_rows":101,"n_cols":8,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"\"Tariff Approval - \"&'Model update'!B3","v":"Tariff Approval - Aust. Gas Networks (Vic & Albury)"},null,{"$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 tariff 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 - AGN Central - Residential","Tariff V - AGN Central - Residential"]
[]
[null,"Fixed Charge","Fixed Charge",{"$f":"ROUND([2]Prop2022DistTar!D8,4)","v":0.193},0.193,210211700,{"$f":"D8*$F8","v":40570858.100000001},{"$f":"E8*$F8","v":40570858.100000001}]
[null,"GJ 0 - 0.0274","GJ 0 - 0.0274",{"$f":"ROUND([2]Prop2022DistTar!D9,4)","v":13.2331},11.8856,5089650.0896270648,{"$f":"D9*$F9","v":67351848.60104391},60493545.105271444]
[null,"GJ 0.0274 - 0.0493","GJ 0.0274 - 0.0493",{"$f":"ROUND([2]Prop2022DistTar!D10,4)","v":7.6085000000000003},6.8338000000000001,3282266.5365116103,24973124.943048589,22430353.057213042]
[null,"GJ > 0.0493","GJ > 0.0493",{"$f":"ROUND([2]Prop2022DistTar!D11,4)","v":3.7513999999999998},3.7513999999999998,20196474.250040032,75765053.501600176,75765053.501600176]
[null,"Tariff V - AGN Central - Non Residential","Tariff V - AGN Central - Non Residential"]
[]
[null,"Fixed Charge","Fixed Charge",{"$f":"ROUND([2]Prop2022DistTar!D14,4)","v":0.193},0.193,7357700,{"$f":"D14*$F14","v":1420036.1},{"$f":"E14*$F14","v":1420036.1}]
[null,"GJ 0 - 0.05","GJ 0 - 0.05",{"$f":"ROUND([2]Prop2022DistTar!D15,4)","v":9.3412000000000006},8.39,260279.12842858184,{"$f":"D15*$F15","v":2431319.3944770689},2183741.8875158019]
[null,"GJ 0.05 - 0.55","GJ 0.05 - 0.55",{"$f":"ROUND([2]Prop2022DistTar!D16,4)","v":3.9599000000000002},3.9599000000000002,1346836.6677376083,5333338.5205741553,5333338.5205741553]
[null,"GJ 0.55 - 1.37","GJ 0.55 - 1.37",{"$f":"ROUND([2]Prop2022DistTar!D17,4)","v":2.9535999999999998},2.9535999999999998,1013097.1393793365,2992283.710870808,2992283.710870808]
[null,"GJ > 1.37","GJ > 1.37",{"$f":"ROUND([2]Prop2022DistTar!D18,4)","v":1.1929000000000001},1.1929000000000001,3454727.2837079535,4121144.1767352181,4121144.1767352181]
[null,"Tariff V - AGN North - Residential","Tariff V - AGN North - Residential"]
[]
[null,"Fixed Charge","Fixed Charge",{"$f":"ROUND([2]Prop2022DistTar!D21,4)","v":0.193},0.193,29660925,{"$f":"D21*$F21","v":5724558.5250000004},{"$f":"E21*$F21","v":5724558.5250000004}]
[null,"GJ 0 - 0.0274","GJ 0 - 0.0274",{"$f":"ROUND([2]Prop2022DistTar!D22,4)","v":11.6431},10.4575,688391.1033751379,{"$f":"D22*$F22","v":8015006.4557070686},7198849.963545504]
[null,"GJ 0.0274 - 0.0493","GJ 0.0274 - 0.0493",{"$f":"ROUND([2]Prop2022DistTar!D23,4)","v":6.8155000000000001},6.1215000000000002,420751.27034647524,2867630.283046402,2575628.9014259484]
[null,"GJ > 0.0493","GJ > 0.0493",{"$f":"ROUND([2]Prop2022DistTar!D24,4)","v":3.3609},3.3609,2776289.6384657924,9330831.8459196817,9330831.8459196817]
[null,"Tariff V - AGN North - Non Residential","Tariff V - AGN North - Non Residential"]
[]
[null,"Fixed Charge","Fixed Charge",{"$f":"ROUND([2]Prop2022DistTar!D27,4)","v":0.193},0.193,1196858,{"$f":"D27*$F27","v":230993.59400000001},{"$f":"E27*$F27","v":230993.59400000001}]
[null,"GJ 0 - 0.05","GJ 0 - 0.05",{"$f":"ROUND([2]Prop2022DistTar!D28,4)","v":8.3790999999999993},7.5259,36017.447575653983,{"$f":"D28*$F28","v":301793.79498116224},271063.70870961429]
[null,"GJ 0.05 - 0.55","GJ 0.05 - 0.55",{"$f":"ROUND([2]Prop2022DistTar!D29,4)","v":3.5788000000000002},3.5788000000000002,173290.66479011832,620172.63115087547,620172.63115087547]
[null,"GJ 0.55 - 1.37","GJ 0.55 - 1.37",{"$f":"ROUND([2]Prop2022DistTar!D30,4)","v":2.6690999999999998},2.6690999999999998,114823.45676968904,306475.28846397699,306475.28846397699]
[null,"GJ > 1.37","GJ > 1.37",{"$f":"ROUND([2]Prop2022DistTar!D31,4)","v":1.0785},1.0785,417484.61388794519,450257.15607814887,450257.15607814887]
[null,"Tariff V - Murray Valley - Residential","Tariff V - Murray Valley - Residential"]
[]
[null,"Fixed Charge","Fixed Charge",{"$f":"ROUND([2]Prop2022DistTar!D34,4)","v":0.2457},0.2457,3082859,{"$f":"D34*$F34","v":757458.45629999996},{"$f":"E34*$F34","v":757458.45629999996}]
[null,"GJ 0 - 0.0274","GJ 0 - 0.0274",{"$f":"ROUND([2]Prop2022DistTar!D35,4)","v":10.136699999999999},9.1044999999999998,61237.19952777763,{"$f":"D35*$F35","v":620743.12045322347},557534.08310065139]
[null,"GJ 0.0274 - 0.0493","GJ 0.0274 - 0.0493",{"$f":"ROUND([2]Prop2022DistTar!D36,4)","v":6.1322999999999999},5.5079000000000002,33277.759149794489,204069.20243428473,183290.56962115306]
[null,"GJ > 0.0493","GJ > 0.0493",{"$f":"ROUND([2]Prop2022DistTar!D37,4)","v":3.4455},3.4455,216314.8497688447,745312.81487855443,745312.81487855443]
[null,"Tariff V - Murray Valley - Non Residential","Tariff V - Murray Valley - Non Residential"]
[]
[null,"Fixed Charge","Fixed Charge",{"$f":"ROUND([2]Prop2022DistTar!D40,4)","v":0.2457},0.2457,133894,{"$f":"D40*$F40","v":32897.755799999999},{"$f":"E40*$F40","v":32897.755799999999}]
[null,"GJ 0 - 0.05","GJ 0 - 0.05",{"$f":"ROUND([2]Prop2022DistTar!D41,4)","v":7.492},6.7290999999999999,4363.7335579930013,{"$f":"D41*$F41","v":32693.091816483568},29363.999485090706]
[null,"GJ 0.05 - 0.55","GJ 0.05 - 0.55",{"$f":"ROUND([2]Prop2022DistTar!D42,4)","v":3.9744000000000002},3.9744000000000002,19533.933169653013,77635.663989468943,77635.663989468943]
[null,"GJ 0.55 - 1.37","GJ 0.55 - 1.37",{"$f":"ROUND([2]Prop2022DistTar!D43,4)","v":2.9661},2.9661,10791.869502720994,32009.76413202074,32009.76413202074]
[null,"GJ > 1.37","GJ > 1.37",{"$f":"ROUND([2]Prop2022DistTar!D44,4)","v":1.3427},1.3427,25569.568025606,34332.258987981179,34332.258987981179]
[null,"Tariff V - Bairnsdale - Residential","Tariff V - Bairnsdale - Residential"]
[]
[null,"Fixed Charge","Fixed Charge",{"$f":"ROUND([2]Prop2022DistTar!D47,4)","v":0.31759999999999999},0.31759999999999999,1725031,{"$f":"D47*$F47","v":547869.8456},{"$f":"E47*$F47","v":547869.8456}]
[null,"GJ 0 - 0.0274","GJ 0 - 0.0274",{"$f":"ROUND([2]Prop2022DistTar!D48,4)","v":21.6053},19.4053,35064.938512722591,{"$f":"D48*$F48","v":757588.51604892535},{"$f":"E48*$F48","v":680445.65132093569}]
[null,"GJ 0.0274 - 0.0493","GJ 0.0274 - 0.0493",{"$f":"ROUND([2]Prop2022DistTar!D49,4)","v":12.5664},11.286799999999999,18002.240041649886,226223.34925938913,203187.68290209392]
[null,"GJ > 0.0493","GJ > 0.0493",{"$f":"ROUND([2]Prop2022DistTar!D50,4)","v":6.2016999999999998},6.2016999999999998,80647.197390457804,500149.72405640216,500149.72405640216]
[null,"Tariff V - Bairnsdale - Non Residential","Tariff V - Bairnsdale - Non Residential"]
[]
[null,"Fixed Charge","Fixed Charge",{"$f":"ROUND([2]Prop2022DistTar!D53,4)","v":0.31759999999999999},0.31759999999999999,44767,{"$f":"D53*$F53","v":14217.9992},{"$f":"E53*$F53","v":14217.9992}]
[null,"GJ 0 - 0.05","GJ 0 - 0.05",{"$f":"ROUND([2]Prop2022DistTar!D54,4)","v":15.3606},13.7965,1750.1146743840004,{"$f":"D54*$F54","v":26882.811467342875},{"$f":"E54*$F54","v":24145.457105138863}]
[null,"GJ 0.05 - 0.55","GJ 0.05 - 0.55",{"$f":"ROUND([2]Prop2022DistTar!D55,4)","v":6.7260999999999997},6.7260999999999997,12304.525360697004,82761.468028584117,82761.468028584117]
[null,"GJ 0.55 - 1.37","GJ 0.55 - 1.37",{"$f":"ROUND([2]Prop2022DistTar!D56,4)","v":5.0148999999999999},5.0148999999999999,9092.5019583729973,45597.98807104474,45597.98807104474]
[null,"GJ > 1.37","GJ > 1.37",{"$f":"ROUND([2]Prop2022DistTar!D57,4)","v":2.0105},2.0256000000000003,41529.113477980005,83494.282647478802,84121.372260996315]
[]
[null,"Tariff D -  AGN Central","Tariff D -  AGN Central"]
[null,"0 - 10","0 - 10",{"$f":"ROUND([2]Prop2022DistTar!D60,4)","v":1524.8607},1460.155,1415.4355000000003,{"$f":"D60*$F60","v":2158341.9673348502},2066755.2225025003]
[null,"10 - 50","10 - 50",{"$f":"ROUND([2]Prop2022DistTar!D61,4)","v":932.20219999999995},892.64530000000002,1154.7040000000006,1076417.6091488006,1030741.0984912006]
[null,"> 50","> 50",{"$f":"ROUND([2]Prop2022DistTar!D62,4)","v":170.23929999999999},163.0154,1186.3117,201956.87338980997,193387.07630017999]
[]
[null,"Tariff D - AGN North","Tariff D - AGN North"]
[null,"0 - 10","0 - 10",{"$f":"ROUND([2]Prop2022DistTar!D65,4)","v":1524.8607},1460.155,442.94089999999994,{"$f":"D65*$F65","v":675423.1708326299},646762.36983949994]
[null,"10 - 50","10 - 50",{"$f":"ROUND([2]Prop2022DistTar!D66,4)","v":932.20219999999995},892.64530000000002,622.19809999999995,580014.43765581993,555402.20963393]
[null,"> 50","> 50",{"$f":"ROUND([2]Prop2022DistTar!D67,4)","v":170.23929999999999},163.0154,414.34199999999998,70537.29204059999,67544.126866799998]
[]
[null,"Tariff D - Murray Valley","Tariff D - Murray Valley"]
[null,"0 - 10","0 - 10",{"$f":"ROUND([2]Prop2022DistTar!D70,4)","v":1777.4082000000001},1701.9860000000001,69.065300000000008,{"$f":"D70*$F70","v":122757.23055546002},117548.17368580002]
[null,"10 - 50","10 - 50",{"$f":"ROUND([2]Prop2022DistTar!D71,4)","v":1096.7731000000001},1050.2328,160.51580000000001,176049.41156498002,168578.95807824002]
[null,"> 50","> 50",{"$f":"ROUND([2]Prop2022DistTar!D72,4)","v":186.7998},178.8732,85.953599999999994,16056.11528928,15374.795483519998]
[]
[null,"Tariff D - Bairnsdale","Tariff D - Bairnsdale"]
[null,"0 - 10","0 - 10",{"$f":"ROUND([2]Prop2022DistTar!D75,4)","v":2522.3240999999998},2415.2923000000001,16.410399999999999,{"$f":"D75*$F75","v":41392.347410639995},39635.91275992]
[null,"10 - 50","10 - 50",{"$f":"ROUND([2]Prop2022DistTar!D76,4)","v":1562.5903000000001},1496.2836,4.8068000000000008,7511.0590540400017,7192.3360084800015]
[null,"> 50","> 50",{"$f":"ROUND([2]Prop2022DistTar!D77,4)","v":284.98090000000002},272.88810000000001,0,0,0]
[]
[null,"Tariff V - Albury - Residential","Tariff V - Albury - Residential"]
[]
[null,"Fixed Charge","Fixed Charge",{"$f":"ROUND([2]Prop2022DistTar!D81,4)","v":0.25109999999999999},0.25109999999999999,8360632,{"$f":"D81*$F81","v":2099354.6952},2099354.6952]
[null,"GJ 0 - 0.0274","GJ 0 - 0.0274",{"$f":"ROUND([2]Prop2022DistTar!D82,4)","v":9.5828000000000007},8.6069999999999993,192275.31005656751,1842535.8412100752,1654913.5936568764]
[null,"GJ 0.0274 - 0.0493","GJ 0.0274 - 0.0493",{"$f":"ROUND([2]Prop2022DistTar!D83,4)","v":5.7278000000000002},5.1445999999999996,115094.74292321946,659239.66851561645,592116.41444279475]
[null,"GJ > 0.0493","GJ > 0.0493",{"$f":"ROUND([2]Prop2022DistTar!D84,4)","v":2.8250999999999999},2.8250999999999999,745173.93406256125,2105190.8811201416,2105190.8811201416]
[null,"Tariff V - Albury - Non Residential","Tariff V - Albury - Non Residential"]
[]
[null,"Fixed Charge","Fixed Charge",{"$f":"ROUND([2]Prop2022DistTar!D87,4)","v":0.25109999999999999},0.25109999999999999,338819,{"$f":"D87*$F87","v":85077.450899999996},85077.450899999996]
[null,"GJ 0 - 0.05","GJ 0 - 0.05",{"$f":"ROUND([2]Prop2022DistTar!D88,4)","v":7.0331999999999999},6.3170000000000002,10894.173855471008,76620.903560298699,68818.496245010363]
[null,"GJ 0.05 - 0.55","GJ 0.05 - 0.55",{"$f":"ROUND([2]Prop2022DistTar!D89,4)","v":3.1192000000000002},3.1192000000000002,55072.744106879974,171782.90341818004,171782.90341818004]
[null,"GJ 0.55 - 1.37","GJ 0.55 - 1.37",{"$f":"ROUND([2]Prop2022DistTar!D90,4)","v":2.2149999999999999},2.2149999999999999,37411.784081163976,82867.101739778198,82867.101739778198]
[null,"GJ > 1.37","GJ > 1.37",{"$f":"ROUND([2]Prop2022DistTar!D91,4)","v":0.89439999999999997},0.89439999999999997,139269.14957664086,124562.32738134758,124562.32738134758]
[]
[null,"Tariff D - Albury","Tariff D - Albury"]
[null,"0 - 10","0 - 10",{"$f":"ROUND([2]Prop2022DistTar!D94,4)","v":1311.3807999999999},1255.7338999999999,39.445999999999998,{"$f":"D94*$F94","v":51728.727036799995},49533.679419399996]
[null,"10 - 50","10 - 50",{"$f":"ROUND([2]Prop2022DistTar!D95,4)","v":814.48789999999997},779.92610000000002,62.022599999999997,{"$f":"D95*$F95","v":50516.657226539995},48373.044529860003]
[null,"> 50","> 50",{"$f":"ROUND([2]Prop2022DistTar!D96,4)","v":196.87960000000001},188.52520000000001,5.2768999999999977,1038.9139612399997,994.82862787999966]
[]
[]
[]
[]
[null,"Total Revenue","Total Revenue",null,null,null,{"$f":"SUM(G8:G97)","v":270105638.32141531},{"$f":"SUM(H8:H97)","v":258644026.02524579}]

{"sheet":"2022TarContForm","index":3,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[[43,1,43,3]]}
[null,{"$f":"\"Tariff Approval - \"&'Model update'!B3","v":"Tariff Approval - Aust. Gas Networks (Vic & Albury)"},null,null,null,{"$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 June\"&'Model update'!$B$9","v":"CPI June2020"},{"$f":"'Model update'!B26","v":114.4}]
[null,{"$f":"\"CPI June\"&'Model update'!$B$8","v":"CPI June2021"},{"$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":-5.6359370969629296E-3}]
[]
[]
[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":258644026.02524579}]
[]
[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.044314242369923}]
[]
[null,"Proposed distribution tariff revenue",{"$f":"IF(Prop2022DistTar!G101=0,\"\",Prop2022DistTar!G101)","v":270105638.32141531}]
[null,"Existing distribution tariff revenue",{"$f":"IF(Prop2022DistTar!H101=0,\"\",Prop2022DistTar!H101)","v":258644026.02524579}]
[null,"Average price movement",{"$f":"IF(C40=\"\",\"\",C40/C41)","v":1.0443142355627064}]
[]
[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":454,"n_cols":7,"rows_kept":454,"cut":false,"hidden":false,"merged":[[399,1,399,2],[429,1,429,2],[453,1,453,2],[243,1,243,2],[153,1,153,2],[273,1,273,2],[369,1,369,2],[297,1,297,2],[321,1,321,2],[345,1,345,2],[63,1,63,2],[93,1,93,2],[123,1,123,2],[183,1,183,2],[213,1,213,2]]}
[null,{"$f":"\"Tariff Approval - \"&'Model update'!B3","v":"Tariff Approval - Aust. Gas Networks (Vic & Albury)"},{"$f":"'Model update'!B7&\"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'!C29","v":0}]
[null,{"$f":"\"Xt \"&'Model update'!$B$5","v":"Xt 2022"},{"$f":"'2022TarContForm'!C17","v":-5.6359370969629296E-3}]
[]
[null,"Rebalancing control",{"$f":"(1+C8)*(1+C9)*(1+C10)*(1-C11)","v":1.0652005272173215}]
[]
[]
[]
[null,"Rebalancing control summary"]
[null,null,"Existing","Proposed","Movement","Assessment"]
[null,{"$f":"B38","v":"Tariff V - AGN Central - Residential"},{"$f":"C59","v":199259809.76408467},{"$f":"C60","v":208660885.14569268},{"$f":"IF(C19=0,0,D19/C19)","v":1.0471799877393162},{"$f":"IF(E19=0,\"\",IF($C$13<=E19,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B68","v":"Tariff V - AGN North - Residential"},{"$f":"C89","v":24829869.235891134},{"$f":"C90","v":25938027.10967315},{"$f":"IF(C20=0,0,D20/C20)","v":1.0446300326133089},{"$f":"IF(E20=0,\"\",IF($C$13<=E20,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B98","v":"Tariff V - Murray Valley - Residential"},{"$f":"C119","v":2243595.9239003588},{"$f":"C120","v":2327583.5940660625},1.0374344012979377,"Compliant"]
[null,{"$f":"B128","v":"Tariff V - Bairnsdale - Residential"},{"$f":"C149","v":1931652.903879432},{"$f":"C150","v":2031831.4349647167},1.0518615590223748,"Compliant"]
[null,{"$f":"B158","v":"Tariff V - AGN Central - Non Residential"},{"$f":"C179","v":16050544.395695984},{"$f":"C180","v":16298121.90265725},1.0154248666498598,"Compliant"]
[null,{"$f":"B188","v":"Tariff V - AGN North - Non Residential"},{"$f":"C209","v":1878962.3784026154},{"$f":"C210","v":1909692.4646741636},1.0163548172250649,{"$f":"IF(E24=0,\"\",IF($C$13<=E24,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B218","v":"Tariff V - Murray Valley - Non Residential"},{"$f":"C239","v":206239.44239456157},{"$f":"C240","v":209568.53472595444},1.0161418800048145,"Compliant"]
[null,{"$f":"B248","v":"Tariff V - Bairnsdale - Non Residential"},{"$f":"C269","v":250844.28466576402},{"$f":"C270","v":252954.54941445054},{"$f":"IF(C26=0,0,D26/C26)","v":1.0084126483148632},{"$f":"IF(E26=0,\"\",IF($C$13<=E26,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B278","v":"Tariff D -  AGN Central"},{"$f":"C293","v":3290883.397293881},{"$f":"C294","v":3436716.4498734609},{"$f":"IF(C27=0,0,D27/C27)","v":1.0443142569862851},{"$f":"IF(E27=0,\"\",IF($C$13<=E27,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B302","v":"Tariff D - AGN North"},{"$f":"C317","v":1269708.7063402298},{"$f":"C318","v":1325974.9005290498},1.0443142540551682,"Compliant"]
[null,{"$f":"B326","v":"Tariff D - Murray Valley"},{"$f":"C341","v":301501.92724756006},{"$f":"C342","v":314862.75740972004},1.0443142446356224,"Compliant"]
[null,{"$f":"B350","v":"Tariff D - Bairnsdale"},{"$f":"C365","v":46828.248768400001},{"$f":"C366","v":48903.406464679996},1.0443142280750914,"Compliant"]
[null,{"$f":"B374","v":"Tariff V - Albury - Residential"},{"$f":"C395","v":6451575.5844198121},{"$f":"C396","v":6706321.0860458333},1.0394857811541753,"Compliant"]
[null,{"$f":"B404","v":"Tariff V - Albury - Non Residential"},{"$f":"C425","v":533108.27968431613},{"$f":"C426","v":540910.68699960446},1.014635689619956,"Compliant"]
[null,{"$f":"B434","v":"Tariff D - Albury"},{"$f":"C449","v":98901.552577139984},{"$f":"C450","v":103284.29822457999},1.0443142249361719,"Compliant"]
[null,null,{"$f":"SUM(C19:C33)","v":258644026.02524585},{"$f":"SUM(D19:D33)","v":270105638.32141536},1.0443142355627064]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!B6","v":"Tariff V - AGN Central - Residential"},1,2,3,4,5]
[null,null,1,2,3,4,5]
[null,"Distribution tariff","Fixed","Blk1","Blk2","Blk3"]
[]
[null,{"$f":"\"Existing : \"&Prop2022DistTar!C6","v":"Existing : Tariff V - AGN Central - Residential"},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$11,C$39)","v":0.193},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$11,D$39)","v":11.8856},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$11,E$39)","v":6.8338000000000001},{"$f":"INDEX(Prop2022DistTar!$E$8:$E$11,F$39)","v":3.7513999999999998}]
[]
[null,{"$f":"\"Proposed : \"&B38","v":"Proposed : Tariff V - AGN Central - Residential"},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$11,C$38)","v":0.193},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$11,D$38)","v":13.2331},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$11,E$38)","v":7.6085000000000003},{"$f":"INDEX(Prop2022DistTar!$D$8:$D$11,F$38)","v":3.7513999999999998}]
[]
[null,"Distribution volumes (actual)",{"$f":"C$40","v":"Fixed"},{"$f":"D$40","v":"Blk1"},"Blk2","Blk3"]
[]
[null,{"$f":"B42","v":"Existing : Tariff V - AGN Central - Residential"},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$11,C$13)","v":210211700},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$11,D$38)","v":5089650.0896270648},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$11,E$38)","v":3282266.5365116103},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$11,F$38)","v":20196474.250040032}]
[]
[null,{"$f":"B44","v":"Proposed : Tariff V - AGN Central - Residential"},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$11,C$38)","v":210211700},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$11,D$38)","v":5089650.0896270648},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$11,E$38)","v":3282266.5365116103},{"$f":"INDEX(Prop2022DistTar!$F$8:$F$11,F$38)","v":20196474.250040032}]
[]
[null,"Distribution revenue",{"$f":"C$40","v":"Fixed"},"Blk1","Blk2","Blk3"]
[]
[null,{"$f":"B48","v":"Existing : Tariff V - AGN Central - Residential"},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$11,C$39)","v":40570858.100000001},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$11,D$39)","v":60493545.105271444},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$11,E$39)","v":22430353.057213042},{"$f":"INDEX(Prop2022DistTar!$H$8:$H$11,F$39)","v":75765053.501600176}]
[]
[null,{"$f":"B50","v":"Proposed : Tariff V - AGN Central - Residential"},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$11,C$38)","v":40570858.100000001},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$11,D$38)","v":67351848.60104391},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$11,E$38)","v":24973124.943048589},{"$f":"INDEX(Prop2022DistTar!$G$8:$G$11,F$38)","v":75765053.501600176}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B54","v":"Existing : Tariff V - AGN Central - Residential"},{"$f":"SUM(C54:F54)","v":199259809.76408467}]
[null,{"$f":"B56","v":"Proposed : Tariff V - AGN Central - Residential"},{"$f":"SUM(C56:F56)","v":208660885.14569268}]
[]
[null,"Average price movement",{"$f":"IF(C60=0,\"\",C60/C59)","v":1.0471799877393162}]
[]
[null,{"$f":"IF(C62=\"\",\"\",IF(C62<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!B19","v":"Tariff V - AGN North - Residential"},1,2,3,4]
[null,null,1,2,3,4]
[null,"Distribution tariff","Fixed","Blk1","Blk2","Blk3"]
[]
[null,{"$f":"\"Existing : \"&Prop2022DistTar!C19","v":"Existing : Tariff V - AGN North - Residential"},{"$f":"INDEX(Prop2022DistTar!$E$21:$E$24,C$39)","v":0.193},{"$f":"INDEX(Prop2022DistTar!$E$21:$E$24,D$39)","v":10.4575},{"$f":"INDEX(Prop2022DistTar!$E$21:$E$24,E$39)","v":6.1215000000000002},{"$f":"INDEX(Prop2022DistTar!$E$21:$E$24,F$39)","v":3.3609}]
[]
[null,{"$f":"\"Proposed : \"&B68","v":"Proposed : Tariff V - AGN North - Residential"},{"$f":"INDEX(Prop2022DistTar!$D$21:$D$24,C$38)","v":0.193},{"$f":"INDEX(Prop2022DistTar!$D$21:$D$24,D$38)","v":11.6431},{"$f":"INDEX(Prop2022DistTar!$D$21:$D$24,E$38)","v":6.8155000000000001},{"$f":"INDEX(Prop2022DistTar!$D$21:$D$24,F$38)","v":3.3609}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B72","v":"Existing : Tariff V - AGN North - Residential"},{"$f":"INDEX(Prop2022DistTar!$F$21:$F$24,C$38)","v":29660925},{"$f":"INDEX(Prop2022DistTar!$F$21:$F$24,D$38)","v":688391.1033751379},{"$f":"INDEX(Prop2022DistTar!$F$21:$F$24,E$38)","v":420751.27034647524},{"$f":"INDEX(Prop2022DistTar!$F$21:$F$24,F$38)","v":2776289.6384657924}]
[]
[null,{"$f":"B74","v":"Proposed : Tariff V - AGN North - Residential"},{"$f":"INDEX(Prop2022DistTar!$F$21:$F$24,C$38)","v":29660925},{"$f":"INDEX(Prop2022DistTar!$F$21:$F$24,D$38)","v":688391.1033751379},{"$f":"INDEX(Prop2022DistTar!$F$21:$F$24,E$38)","v":420751.27034647524},{"$f":"INDEX(Prop2022DistTar!$F$21:$F$24,F$38)","v":2776289.6384657924}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B78","v":"Existing : Tariff V - AGN North - Residential"},{"$f":"INDEX(Prop2022DistTar!$H$21:$H$24,C$39)","v":5724558.5250000004},{"$f":"INDEX(Prop2022DistTar!$H$21:$H$24,D$39)","v":7198849.963545504},{"$f":"INDEX(Prop2022DistTar!$H$21:$H$24,E$39)","v":2575628.9014259484},{"$f":"INDEX(Prop2022DistTar!$H$21:$H$24,F$39)","v":9330831.8459196817}]
[]
[null,{"$f":"B80","v":"Proposed : Tariff V - AGN North - Residential"},{"$f":"INDEX(Prop2022DistTar!$G$21:$G$24,C$38)","v":5724558.5250000004},{"$f":"INDEX(Prop2022DistTar!$G$21:$G$24,D$38)","v":8015006.4557070686},{"$f":"INDEX(Prop2022DistTar!$G$21:$G$24,E$38)","v":2867630.283046402},{"$f":"INDEX(Prop2022DistTar!$G$21:$G$24,F$38)","v":9330831.8459196817}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B84","v":"Existing : Tariff V - AGN North - Residential"},{"$f":"SUM(C84:F84)","v":24829869.235891134}]
[null,{"$f":"B86","v":"Proposed : Tariff V - AGN North - Residential"},{"$f":"SUM(C86:F86)","v":25938027.10967315}]
[]
[null,"Average price movement",{"$f":"IF(C90=0,\"\",C90/C89)","v":1.0446300326133089}]
[]
[null,{"$f":"IF(C92=\"\",\"\",IF(C92<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!B32","v":"Tariff V - Murray Valley - Residential"},1,2,3,4]
[null,null,1,2,3,4]
[null,"Distribution tariff","Fixed","Blk1","Blk2","Blk3"]
[]
[null,{"$f":"\"Existing : \"&Prop2022DistTar!C32","v":"Existing : Tariff V - Murray Valley - Residential"},{"$f":"INDEX(Prop2022DistTar!$E$34:$E$37,C$39)","v":0.2457},{"$f":"INDEX(Prop2022DistTar!$E$34:$E$37,D$39)","v":9.1044999999999998},{"$f":"INDEX(Prop2022DistTar!$E$34:$E$37,E$39)","v":5.5079000000000002},{"$f":"INDEX(Prop2022DistTar!$E$34:$E$37,F$39)","v":3.4455}]
[]
[null,{"$f":"\"Proposed : \"&B98","v":"Proposed : Tariff V - Murray Valley - Residential"},{"$f":"INDEX(Prop2022DistTar!$D$34:$D$37,C$38)","v":0.2457},{"$f":"INDEX(Prop2022DistTar!$D$34:$D$37,D$38)","v":10.136699999999999},{"$f":"INDEX(Prop2022DistTar!$D$34:$D$37,E$38)","v":6.1322999999999999},{"$f":"INDEX(Prop2022DistTar!$D$34:$D$37,F$38)","v":3.4455}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B102","v":"Existing : Tariff V - Murray Valley - Residential"},{"$f":"INDEX(Prop2022DistTar!$F$34:$F$37,C$38)","v":3082859},{"$f":"INDEX(Prop2022DistTar!$F$34:$F$37,D$38)","v":61237.19952777763},{"$f":"INDEX(Prop2022DistTar!$F$34:$F$37,E$38)","v":33277.759149794489},{"$f":"INDEX(Prop2022DistTar!$F$34:$F$37,F$38)","v":216314.8497688447}]
[]
[null,{"$f":"B104","v":"Proposed : Tariff V - Murray Valley - Residential"},{"$f":"INDEX(Prop2022DistTar!$F$34:$F$37,C$38)","v":3082859},{"$f":"INDEX(Prop2022DistTar!$F$34:$F$37,D$38)","v":61237.19952777763},{"$f":"INDEX(Prop2022DistTar!$F$34:$F$37,E$38)","v":33277.759149794489},{"$f":"INDEX(Prop2022DistTar!$F$34:$F$37,F$38)","v":216314.8497688447}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B108","v":"Existing : Tariff V - Murray Valley - Residential"},{"$f":"INDEX(Prop2022DistTar!$H$34:$H$37,C$39)","v":757458.45629999996},{"$f":"INDEX(Prop2022DistTar!$H$34:$H$37,D$39)","v":557534.08310065139},{"$f":"INDEX(Prop2022DistTar!$H$34:$H$37,E$39)","v":183290.56962115306},{"$f":"INDEX(Prop2022DistTar!$H$34:$H$37,F$39)","v":745312.81487855443}]
[]
[null,{"$f":"B110","v":"Proposed : Tariff V - Murray Valley - Residential"},{"$f":"INDEX(Prop2022DistTar!$G$34:$G$37,C$38)","v":757458.45629999996},{"$f":"INDEX(Prop2022DistTar!$G$34:$G$37,D$38)","v":620743.12045322347},{"$f":"INDEX(Prop2022DistTar!$G$34:$G$37,E$38)","v":204069.20243428473},{"$f":"INDEX(Prop2022DistTar!$G$34:$G$37,F$38)","v":745312.81487855443}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B114","v":"Existing : Tariff V - Murray Valley - Residential"},{"$f":"SUM(C114:F114)","v":2243595.9239003588}]
[null,{"$f":"B116","v":"Proposed : Tariff V - Murray Valley - Residential"},{"$f":"SUM(C116:F116)","v":2327583.5940660625}]
[]
[null,"Average price movement",{"$f":"IF(C120=0,\"\",C120/C119)","v":1.0374344012979377}]
[]
[null,{"$f":"IF(C122=\"\",\"\",IF(C122<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!B45","v":"Tariff V - Bairnsdale - Residential"},1,2,3,4]
[null,null,1,2,3,4]
[null,"Distribution tariff","Fixed","Blk1","Blk2","Blk3"]
[]
[null,{"$f":"\"Existing : \"&Prop2022DistTar!C45","v":"Existing : Tariff V - Bairnsdale - Residential"},{"$f":"INDEX(Prop2022DistTar!$E$47:$E$50,C$39)","v":0.31759999999999999},{"$f":"INDEX(Prop2022DistTar!$E$47:$E$50,D$39)","v":19.4053},{"$f":"INDEX(Prop2022DistTar!$E$47:$E$50,E$39)","v":11.286799999999999},{"$f":"INDEX(Prop2022DistTar!$E$47:$E$50,F$39)","v":6.2016999999999998}]
[]
[null,{"$f":"\"Proposed : \"&B128","v":"Proposed : Tariff V - Bairnsdale - Residential"},{"$f":"INDEX(Prop2022DistTar!$D$47:$D$50,C$38)","v":0.31759999999999999},{"$f":"INDEX(Prop2022DistTar!$D$47:$D$50,D$38)","v":21.6053},{"$f":"INDEX(Prop2022DistTar!$D$47:$D$50,E$38)","v":12.5664},{"$f":"INDEX(Prop2022DistTar!$D$47:$D$50,F$38)","v":6.2016999999999998}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B132","v":"Existing : Tariff V - Bairnsdale - Residential"},{"$f":"INDEX(Prop2022DistTar!$F$47:$F$50,C$38)","v":1725031},{"$f":"INDEX(Prop2022DistTar!$F$47:$F$50,D$38)","v":35064.938512722591},{"$f":"INDEX(Prop2022DistTar!$F$47:$F$50,E$38)","v":18002.240041649886},{"$f":"INDEX(Prop2022DistTar!$F$47:$F$50,F$38)","v":80647.197390457804}]
[]
[null,{"$f":"B134","v":"Proposed : Tariff V - Bairnsdale - Residential"},{"$f":"INDEX(Prop2022DistTar!$F$47:$F$50,C$38)","v":1725031},{"$f":"INDEX(Prop2022DistTar!$F$47:$F$50,D$38)","v":35064.938512722591},{"$f":"INDEX(Prop2022DistTar!$F$47:$F$50,E$38)","v":18002.240041649886},{"$f":"INDEX(Prop2022DistTar!$F$47:$F$50,F$38)","v":80647.197390457804}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B138","v":"Existing : Tariff V - Bairnsdale - Residential"},{"$f":"INDEX(Prop2022DistTar!$H$47:$H$50,C$39)","v":547869.8456},{"$f":"INDEX(Prop2022DistTar!$H$47:$H$50,D$39)","v":680445.65132093569},{"$f":"INDEX(Prop2022DistTar!$H$47:$H$50,E$39)","v":203187.68290209392},{"$f":"INDEX(Prop2022DistTar!$H$47:$H$50,F$39)","v":500149.72405640216}]
[]
[null,{"$f":"B140","v":"Proposed : Tariff V - Bairnsdale - Residential"},{"$f":"INDEX(Prop2022DistTar!$G$47:$G$50,C$38)","v":547869.8456},{"$f":"INDEX(Prop2022DistTar!$G$47:$G$50,D$38)","v":757588.51604892535},{"$f":"INDEX(Prop2022DistTar!$G$47:$G$50,E$38)","v":226223.34925938913},{"$f":"INDEX(Prop2022DistTar!$G$47:$G$50,F$38)","v":500149.72405640216}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B144","v":"Existing : Tariff V - Bairnsdale - Residential"},{"$f":"SUM(C144:F144)","v":1931652.903879432}]
[null,{"$f":"B146","v":"Proposed : Tariff V - Bairnsdale - Residential"},{"$f":"SUM(C146:F146)","v":2031831.4349647167}]
[]
[null,"Average price movement",{"$f":"IF(C150=0,\"\",C150/C149)","v":1.0518615590223748}]
[]
[null,{"$f":"IF(C152=\"\",\"\",IF(C152<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!B12","v":"Tariff V - AGN Central - Non Residential"},1,2,3,4,5]
[null,null,1,2,3,4,5]
[null,"Distribution tariff","Fixed","Blk1","Blk2","Blk3","Blk4"]
[]
[null,{"$f":"\"Existing : \"&Prop2022DistTar!C12","v":"Existing : Tariff V - AGN Central - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$E$14:$E$18,C$39)","v":0.193},{"$f":"INDEX(Prop2022DistTar!$E$14:$E$18,D$39)","v":8.39},{"$f":"INDEX(Prop2022DistTar!$E$14:$E$18,E$39)","v":3.9599000000000002},{"$f":"INDEX(Prop2022DistTar!$E$14:$E$18,F$39)","v":2.9535999999999998},{"$f":"INDEX(Prop2022DistTar!$E$14:$E$18,G$39)","v":1.1929000000000001}]
[]
[null,{"$f":"\"Proposed : \"&B158","v":"Proposed : Tariff V - AGN Central - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$D$14:$D$18,C$38)","v":0.193},{"$f":"INDEX(Prop2022DistTar!$D$14:$D$18,D$38)","v":9.3412000000000006},{"$f":"INDEX(Prop2022DistTar!$D$14:$D$18,E$38)","v":3.9599000000000002},{"$f":"INDEX(Prop2022DistTar!$D$14:$D$18,F$38)","v":2.9535999999999998},{"$f":"INDEX(Prop2022DistTar!$D$14:$D$18,G$38)","v":1.1929000000000001}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B162","v":"Existing : Tariff V - AGN Central - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$F$14:$F$18,C$38)","v":7357700},{"$f":"INDEX(Prop2022DistTar!$F$14:$F$18,D$38)","v":260279.12842858184},{"$f":"INDEX(Prop2022DistTar!$F$14:$F$18,E$38)","v":1346836.6677376083},{"$f":"INDEX(Prop2022DistTar!$F$14:$F$18,F$38)","v":1013097.1393793365},{"$f":"INDEX(Prop2022DistTar!$F$14:$F$18,G$38)","v":3454727.2837079535}]
[]
[null,{"$f":"B164","v":"Proposed : Tariff V - AGN Central - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$F$14:$F$18,C$38)","v":7357700},{"$f":"INDEX(Prop2022DistTar!$F$14:$F$18,D$38)","v":260279.12842858184},{"$f":"INDEX(Prop2022DistTar!$F$14:$F$18,E$38)","v":1346836.6677376083},{"$f":"INDEX(Prop2022DistTar!$F$14:$F$18,F$38)","v":1013097.1393793365},{"$f":"INDEX(Prop2022DistTar!$F$14:$F$18,G$38)","v":3454727.2837079535}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B168","v":"Existing : Tariff V - AGN Central - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$H$14:$H$18,C$39)","v":1420036.1},{"$f":"INDEX(Prop2022DistTar!$H$14:$H$18,D$39)","v":2183741.8875158019},{"$f":"INDEX(Prop2022DistTar!$H$14:$H$18,E$39)","v":5333338.5205741553},{"$f":"INDEX(Prop2022DistTar!$H$14:$H$18,F$39)","v":2992283.710870808},{"$f":"INDEX(Prop2022DistTar!$H$14:$H$18,G$39)","v":4121144.1767352181}]
[]
[null,{"$f":"B170","v":"Proposed : Tariff V - AGN Central - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$G$14:$G$18,C$38)","v":1420036.1},{"$f":"INDEX(Prop2022DistTar!$G$14:$G$18,D$38)","v":2431319.3944770689},{"$f":"INDEX(Prop2022DistTar!$G$14:$G$18,E$38)","v":5333338.5205741553},{"$f":"INDEX(Prop2022DistTar!$G$14:$G$18,F$38)","v":2992283.710870808},{"$f":"INDEX(Prop2022DistTar!$G$14:$G$18,G$38)","v":4121144.1767352181}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B174","v":"Existing : Tariff V - AGN Central - Non Residential"},{"$f":"SUM(C174:G174)","v":16050544.395695984}]
[null,{"$f":"B176","v":"Proposed : Tariff V - AGN Central - Non Residential"},{"$f":"SUM(C176:G176)","v":16298121.90265725}]
[]
[null,"Average price movement",{"$f":"IF(C180=0,\"\",C180/C179)","v":1.0154248666498598}]
[]
[null,{"$f":"IF(C182=\"\",\"\",IF(C182<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!B25","v":"Tariff V - AGN North - Non Residential"},1,2,3,4,5]
[null,null,1,2,3,4,5]
[null,"Distribution tariff","Fixed","Blk1","Blk2","Blk3","Blk4"]
[]
[null,{"$f":"\"Existing : \"&Prop2022DistTar!C25","v":"Existing : Tariff V - AGN North - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$E$27:$E$31,C$39)","v":0.193},{"$f":"INDEX(Prop2022DistTar!$E$27:$E$31,D$39)","v":7.5259},{"$f":"INDEX(Prop2022DistTar!$E$27:$E$31,E$39)","v":3.5788000000000002},{"$f":"INDEX(Prop2022DistTar!$E$27:$E$31,F$39)","v":2.6690999999999998},{"$f":"INDEX(Prop2022DistTar!$E$27:$E$31,G$39)","v":1.0785}]
[]
[null,{"$f":"\"Proposed : \"&B188","v":"Proposed : Tariff V - AGN North - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$D$27:$D$31,C$38)","v":0.193},{"$f":"INDEX(Prop2022DistTar!$D$27:$D$31,D$38)","v":8.3790999999999993},{"$f":"INDEX(Prop2022DistTar!$D$27:$D$31,E$38)","v":3.5788000000000002},{"$f":"INDEX(Prop2022DistTar!$D$27:$D$31,F$38)","v":2.6690999999999998},{"$f":"INDEX(Prop2022DistTar!$D$27:$D$31,G$38)","v":1.0785}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B192","v":"Existing : Tariff V - AGN North - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$F$27:$F$31,C$38)","v":1196858},{"$f":"INDEX(Prop2022DistTar!$F$27:$F$31,D$38)","v":36017.447575653983},{"$f":"INDEX(Prop2022DistTar!$F$27:$F$31,E$38)","v":173290.66479011832},{"$f":"INDEX(Prop2022DistTar!$F$27:$F$31,F$38)","v":114823.45676968904},{"$f":"INDEX(Prop2022DistTar!$F$27:$F$31,G$38)","v":417484.61388794519}]
[]
[null,{"$f":"B194","v":"Proposed : Tariff V - AGN North - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$F$27:$F$31,C$38)","v":1196858},{"$f":"INDEX(Prop2022DistTar!$F$27:$F$31,D$38)","v":36017.447575653983},{"$f":"INDEX(Prop2022DistTar!$F$27:$F$31,E$38)","v":173290.66479011832},{"$f":"INDEX(Prop2022DistTar!$F$27:$F$31,F$38)","v":114823.45676968904},{"$f":"INDEX(Prop2022DistTar!$F$27:$F$31,G$38)","v":417484.61388794519}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B198","v":"Existing : Tariff V - AGN North - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$H$27:$H$31,C$39)","v":230993.59400000001},{"$f":"INDEX(Prop2022DistTar!$H$27:$H$31,D$39)","v":271063.70870961429},{"$f":"INDEX(Prop2022DistTar!$H$27:$H$31,E$39)","v":620172.63115087547},{"$f":"INDEX(Prop2022DistTar!$H$27:$H$31,F$39)","v":306475.28846397699},{"$f":"INDEX(Prop2022DistTar!$H$27:$H$31,G$39)","v":450257.15607814887}]
[]
[null,{"$f":"B200","v":"Proposed : Tariff V - AGN North - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$G$27:$G$31,C$38)","v":230993.59400000001},{"$f":"INDEX(Prop2022DistTar!$G$27:$G$31,D$38)","v":301793.79498116224},{"$f":"INDEX(Prop2022DistTar!$G$27:$G$31,E$38)","v":620172.63115087547},{"$f":"INDEX(Prop2022DistTar!$G$27:$G$31,F$38)","v":306475.28846397699},{"$f":"INDEX(Prop2022DistTar!$G$27:$G$31,G$38)","v":450257.15607814887}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B204","v":"Existing : Tariff V - AGN North - Non Residential"},{"$f":"SUM(C204:G204)","v":1878962.3784026154}]
[null,{"$f":"B206","v":"Proposed : Tariff V - AGN North - Non Residential"},{"$f":"SUM(C206:G206)","v":1909692.4646741636}]
[]
[null,"Average price movement",{"$f":"IF(C210=0,\"\",C210/C209)","v":1.0163548172250649}]
[]
[null,{"$f":"IF(C212=\"\",\"\",IF(C212<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!B38","v":"Tariff V - Murray Valley - Non Residential"},1,2,3,4,5]
[null,null,1,2,3,4,5]
[null,"Distribution tariff","Fixed","Blk1","Blk2","Blk3","Blk4"]
[]
[null,{"$f":"\"Existing : \"&Prop2022DistTar!C38","v":"Existing : Tariff V - Murray Valley - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$E$40:$E$44,C$39)","v":0.2457},{"$f":"INDEX(Prop2022DistTar!$E$40:$E$44,D$39)","v":6.7290999999999999},{"$f":"INDEX(Prop2022DistTar!$E$40:$E$44,E$39)","v":3.9744000000000002},{"$f":"INDEX(Prop2022DistTar!$E$40:$E$44,F$39)","v":2.9661},{"$f":"INDEX(Prop2022DistTar!$E$40:$E$44,G$39)","v":1.3427}]
[]
[null,{"$f":"\"Proposed : \"&B218","v":"Proposed : Tariff V - Murray Valley - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$D$40:$D$44,C$38)","v":0.2457},{"$f":"INDEX(Prop2022DistTar!$D$40:$D$44,D$38)","v":7.492},{"$f":"INDEX(Prop2022DistTar!$D$40:$D$44,E$38)","v":3.9744000000000002},{"$f":"INDEX(Prop2022DistTar!$D$40:$D$44,F$38)","v":2.9661},{"$f":"INDEX(Prop2022DistTar!$D$40:$D$44,G$38)","v":1.3427}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B222","v":"Existing : Tariff V - Murray Valley - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$F$40:$F$44,C$38)","v":133894},{"$f":"INDEX(Prop2022DistTar!$F$40:$F$44,D$38)","v":4363.7335579930013},{"$f":"INDEX(Prop2022DistTar!$F$40:$F$44,E$38)","v":19533.933169653013},{"$f":"INDEX(Prop2022DistTar!$F$40:$F$44,F$38)","v":10791.869502720994},{"$f":"INDEX(Prop2022DistTar!$F$40:$F$44,G$38)","v":25569.568025606}]
[]
[null,{"$f":"B224","v":"Proposed : Tariff V - Murray Valley - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$F$40:$F$44,C$38)","v":133894},{"$f":"INDEX(Prop2022DistTar!$F$40:$F$44,D$38)","v":4363.7335579930013},{"$f":"INDEX(Prop2022DistTar!$F$40:$F$44,E$38)","v":19533.933169653013},{"$f":"INDEX(Prop2022DistTar!$F$40:$F$44,F$38)","v":10791.869502720994},{"$f":"INDEX(Prop2022DistTar!$F$40:$F$44,G$38)","v":25569.568025606}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B228","v":"Existing : Tariff V - Murray Valley - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$H$40:$H$44,C$39)","v":32897.755799999999},{"$f":"INDEX(Prop2022DistTar!$H$40:$H$44,D$39)","v":29363.999485090706},{"$f":"INDEX(Prop2022DistTar!$H$40:$H$44,E$39)","v":77635.663989468943},{"$f":"INDEX(Prop2022DistTar!$H$40:$H$44,F$39)","v":32009.76413202074},{"$f":"INDEX(Prop2022DistTar!$H$40:$H$44,G$39)","v":34332.258987981179}]
[]
[null,{"$f":"B230","v":"Proposed : Tariff V - Murray Valley - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$G$40:$G$44,C$38)","v":32897.755799999999},{"$f":"INDEX(Prop2022DistTar!$G$40:$G$44,D$38)","v":32693.091816483568},{"$f":"INDEX(Prop2022DistTar!$G$40:$G$44,E$38)","v":77635.663989468943},{"$f":"INDEX(Prop2022DistTar!$G$40:$G$44,F$38)","v":32009.76413202074},{"$f":"INDEX(Prop2022DistTar!$G$40:$G$44,G$38)","v":34332.258987981179}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B234","v":"Existing : Tariff V - Murray Valley - Non Residential"},{"$f":"SUM(C234:G234)","v":206239.44239456157}]
[null,{"$f":"B236","v":"Proposed : Tariff V - Murray Valley - Non Residential"},{"$f":"SUM(C236:G236)","v":209568.53472595444}]
[]
[null,"Average price movement",{"$f":"IF(C240=0,\"\",C240/C239)","v":1.0161418800048145}]
[]
[null,{"$f":"IF(C242=\"\",\"\",IF(C242<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!B51","v":"Tariff V - Bairnsdale - Non Residential"},1,2,3,4,5]
[null,null,1,2,3,4,5]
[null,"Distribution tariff","Fixed","Blk1","Blk2","Blk3","Blk4"]
[]
[null,{"$f":"\"Existing : \"&Prop2022DistTar!C51","v":"Existing : Tariff V - Bairnsdale - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$E$53:$E$57,C$39)","v":0.31759999999999999},{"$f":"INDEX(Prop2022DistTar!$E$53:$E$57,D$39)","v":13.7965},{"$f":"INDEX(Prop2022DistTar!$E$53:$E$57,E$39)","v":6.7260999999999997},{"$f":"INDEX(Prop2022DistTar!$E$53:$E$57,F$39)","v":5.0148999999999999},{"$f":"INDEX(Prop2022DistTar!$E$53:$E$57,G$39)","v":2.0256000000000003}]
[]
[null,{"$f":"\"Proposed : \"&B248","v":"Proposed : Tariff V - Bairnsdale - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$D$53:$D$57,C$38)","v":0.31759999999999999},{"$f":"INDEX(Prop2022DistTar!$D$53:$D$57,D$38)","v":15.3606},{"$f":"INDEX(Prop2022DistTar!$D$53:$D$57,E$38)","v":6.7260999999999997},{"$f":"INDEX(Prop2022DistTar!$D$53:$D$57,F$38)","v":5.0148999999999999},{"$f":"INDEX(Prop2022DistTar!$D$53:$D$57,G$38)","v":2.0105}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B252","v":"Existing : Tariff V - Bairnsdale - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$F$53:$F$57,C$38)","v":44767},{"$f":"INDEX(Prop2022DistTar!$F$53:$F$57,D$38)","v":1750.1146743840004},{"$f":"INDEX(Prop2022DistTar!$F$53:$F$57,E$38)","v":12304.525360697004},{"$f":"INDEX(Prop2022DistTar!$F$53:$F$57,F$38)","v":9092.5019583729973},{"$f":"INDEX(Prop2022DistTar!$F$53:$F$57,G$38)","v":41529.113477980005}]
[]
[null,{"$f":"B254","v":"Proposed : Tariff V - Bairnsdale - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$F$53:$F$57,C$38)","v":44767},{"$f":"INDEX(Prop2022DistTar!$F$53:$F$57,D$38)","v":1750.1146743840004},{"$f":"INDEX(Prop2022DistTar!$F$53:$F$57,E$38)","v":12304.525360697004},{"$f":"INDEX(Prop2022DistTar!$F$53:$F$57,F$38)","v":9092.5019583729973},{"$f":"INDEX(Prop2022DistTar!$F$53:$F$57,G$38)","v":41529.113477980005}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B258","v":"Existing : Tariff V - Bairnsdale - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$H$53:$H$57,C$39)","v":14217.9992},{"$f":"INDEX(Prop2022DistTar!$H$53:$H$57,D$39)","v":24145.457105138863},{"$f":"INDEX(Prop2022DistTar!$H$53:$H$57,E$39)","v":82761.468028584117},{"$f":"INDEX(Prop2022DistTar!$H$53:$H$57,F$39)","v":45597.98807104474},{"$f":"INDEX(Prop2022DistTar!$H$53:$H$57,G$39)","v":84121.372260996315}]
[]
[null,{"$f":"B260","v":"Proposed : Tariff V - Bairnsdale - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$G$53:$G$57,C$38)","v":14217.9992},{"$f":"INDEX(Prop2022DistTar!$G$53:$G$57,D$38)","v":26882.811467342875},{"$f":"INDEX(Prop2022DistTar!$G$53:$G$57,E$38)","v":82761.468028584117},{"$f":"INDEX(Prop2022DistTar!$G$53:$G$57,F$38)","v":45597.98807104474},{"$f":"INDEX(Prop2022DistTar!$G$53:$G$57,G$38)","v":83494.282647478802}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B264","v":"Existing : Tariff V - Bairnsdale - Non Residential"},{"$f":"SUM(C264:G264)","v":250844.28466576402}]
[null,{"$f":"B266","v":"Proposed : Tariff V - Bairnsdale - Non Residential"},{"$f":"SUM(C266:G266)","v":252954.54941445054}]
[]
[null,"Average price movement",{"$f":"IF(C270=0,\"\",C270/C269)","v":1.0084126483148632}]
[]
[null,{"$f":"IF(C272=\"\",\"\",IF(C272<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!B59","v":"Tariff D -  AGN Central"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2022DistTar!C59","v":"Existing: Tariff D -  AGN Central"},{"$f":"INDEX(Prop2022DistTar!$E$60:$E$62,C279)","v":1460.155},{"$f":"INDEX(Prop2022DistTar!$E$60:$E$62,D279)","v":892.64530000000002},{"$f":"INDEX(Prop2022DistTar!$E$60:$E$62,E279)","v":163.0154}]
[null,{"$f":"\"Proposed: \"&B278","v":"Proposed: Tariff D -  AGN Central"},{"$f":"INDEX(Prop2022DistTar!$D$60:$D$62,C279)","v":1524.8607},{"$f":"INDEX(Prop2022DistTar!$D$60:$D$62,D279)","v":932.20219999999995},{"$f":"INDEX(Prop2022DistTar!$D$60:$D$62,E279)","v":170.23929999999999}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B281","v":"Existing: Tariff D -  AGN Central"},{"$f":"INDEX(Prop2022DistTar!$F$60:$F$62,C$38)","v":1415.4355000000003},{"$f":"INDEX(Prop2022DistTar!$F$60:$F$62,D$38)","v":1154.7040000000006},{"$f":"INDEX(Prop2022DistTar!$F$60:$F$62,E$38)","v":1186.3117}]
[null,{"$f":"B282","v":"Proposed: Tariff D -  AGN Central"},{"$f":"INDEX(Prop2022DistTar!$F$60:$F$62,C$38)","v":1415.4355000000003},{"$f":"INDEX(Prop2022DistTar!$F$60:$F$62,D$38)","v":1154.7040000000006},{"$f":"INDEX(Prop2022DistTar!$F$60:$F$62,E$38)","v":1186.3117}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B285","v":"Existing: Tariff D -  AGN Central"},{"$f":"INDEX(Prop2022DistTar!$H$60:$H$62,C279)","v":2066755.2225025003},{"$f":"INDEX(Prop2022DistTar!$H$60:$H$62,D279)","v":1030741.0984912006},{"$f":"INDEX(Prop2022DistTar!$H$60:$H$62,E279)","v":193387.07630017999}]
[null,{"$f":"B286","v":"Proposed: Tariff D -  AGN Central"},{"$f":"INDEX(Prop2022DistTar!$G$60:$G$62,C279)","v":2158341.9673348502},{"$f":"INDEX(Prop2022DistTar!$G$60:$G$62,D279)","v":1076417.6091488006},{"$f":"INDEX(Prop2022DistTar!$G$60:$G$62,E279)","v":201956.87338980997}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B289","v":"Existing: Tariff D -  AGN Central"},{"$f":"SUM(C289:E289)","v":3290883.397293881}]
[null,{"$f":"B290","v":"Proposed: Tariff D -  AGN Central"},{"$f":"SUM(C290:E290)","v":3436716.4498734609}]
[]
[null,"Average price movement",{"$f":"IF(C294=0,\"\",C294/C293)","v":1.0443142569862851}]
[]
[null,{"$f":"IF(C296=\"\",\"\",IF(C296<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!B64","v":"Tariff D - AGN North"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2022DistTar!C64","v":"Existing: Tariff D - AGN North"},{"$f":"INDEX(Prop2022DistTar!$E$65:$E$67,C303)","v":1460.155},{"$f":"INDEX(Prop2022DistTar!$E$65:$E$67,D303)","v":892.64530000000002},{"$f":"INDEX(Prop2022DistTar!$E$65:$E$67,E303)","v":163.0154}]
[null,{"$f":"\"Proposed: \"&B302","v":"Proposed: Tariff D - AGN North"},{"$f":"INDEX(Prop2022DistTar!$D$65:$D$67,C303)","v":1524.8607},{"$f":"INDEX(Prop2022DistTar!$D$65:$D$67,D303)","v":932.20219999999995},{"$f":"INDEX(Prop2022DistTar!$D$65:$D$67,E303)","v":170.23929999999999}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B305","v":"Existing: Tariff D - AGN North"},{"$f":"INDEX(Prop2022DistTar!$F$65:$F$67,C$38)","v":442.94089999999994},{"$f":"INDEX(Prop2022DistTar!$F$65:$F$67,D$38)","v":622.19809999999995},{"$f":"INDEX(Prop2022DistTar!$F$65:$F$67,E$38)","v":414.34199999999998}]
[null,{"$f":"B306","v":"Proposed: Tariff D - AGN North"},{"$f":"INDEX(Prop2022DistTar!$F$65:$F$67,C$38)","v":442.94089999999994},{"$f":"INDEX(Prop2022DistTar!$F$65:$F$67,D$38)","v":622.19809999999995},{"$f":"INDEX(Prop2022DistTar!$F$65:$F$67,E$38)","v":414.34199999999998}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B309","v":"Existing: Tariff D - AGN North"},{"$f":"INDEX(Prop2022DistTar!$H$65:$H$67,C303)","v":646762.36983949994},{"$f":"INDEX(Prop2022DistTar!$H$65:$H$67,D303)","v":555402.20963393},{"$f":"INDEX(Prop2022DistTar!$H$65:$H$67,E303)","v":67544.126866799998}]
[null,{"$f":"B310","v":"Proposed: Tariff D - AGN North"},{"$f":"INDEX(Prop2022DistTar!$G$65:$G$67,C303)","v":675423.1708326299},{"$f":"INDEX(Prop2022DistTar!$G$65:$G$67,D303)","v":580014.43765581993},{"$f":"INDEX(Prop2022DistTar!$G$65:$G$67,E303)","v":70537.29204059999}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B313","v":"Existing: Tariff D - AGN North"},{"$f":"SUM(C313:E313)","v":1269708.7063402298}]
[null,{"$f":"B314","v":"Proposed: Tariff D - AGN North"},{"$f":"SUM(C314:E314)","v":1325974.9005290498}]
[]
[null,"Average price movement",{"$f":"IF(C318=0,\"\",C318/C317)","v":1.0443142540551682}]
[]
[null,{"$f":"IF(C320=\"\",\"\",IF(C320<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!B69","v":"Tariff D - Murray Valley"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2022DistTar!C69","v":"Existing: Tariff D - Murray Valley"},{"$f":"INDEX(Prop2022DistTar!$E$70:$E$72,C327)","v":1701.9860000000001},{"$f":"INDEX(Prop2022DistTar!$E$70:$E$72,D327)","v":1050.2328},{"$f":"INDEX(Prop2022DistTar!$E$70:$E$72,E327)","v":178.8732}]
[null,{"$f":"\"Proposed: \"&B326","v":"Proposed: Tariff D - Murray Valley"},{"$f":"INDEX(Prop2022DistTar!$D$70:$D$72,C327)","v":1777.4082000000001},{"$f":"INDEX(Prop2022DistTar!$D$70:$D$72,D327)","v":1096.7731000000001},{"$f":"INDEX(Prop2022DistTar!$D$70:$D$72,E327)","v":186.7998}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B329","v":"Existing: Tariff D - Murray Valley"},{"$f":"INDEX(Prop2022DistTar!$F$70:$F$72,C$38)","v":69.065300000000008},{"$f":"INDEX(Prop2022DistTar!$F$70:$F$72,D$38)","v":160.51580000000001},{"$f":"INDEX(Prop2022DistTar!$F$70:$F$72,E$38)","v":85.953599999999994}]
[null,{"$f":"B330","v":"Proposed: Tariff D - Murray Valley"},{"$f":"INDEX(Prop2022DistTar!$F$70:$F$72,C$38)","v":69.065300000000008},{"$f":"INDEX(Prop2022DistTar!$F$70:$F$72,D$38)","v":160.51580000000001},{"$f":"INDEX(Prop2022DistTar!$F$70:$F$72,E$38)","v":85.953599999999994}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B333","v":"Existing: Tariff D - Murray Valley"},{"$f":"INDEX(Prop2022DistTar!$H$70:$H$72,C327)","v":117548.17368580002},{"$f":"INDEX(Prop2022DistTar!$H$70:$H$72,D327)","v":168578.95807824002},{"$f":"INDEX(Prop2022DistTar!$H$70:$H$72,E327)","v":15374.795483519998}]
[null,{"$f":"B334","v":"Proposed: Tariff D - Murray Valley"},{"$f":"INDEX(Prop2022DistTar!$G$70:$G$72,C327)","v":122757.23055546002},{"$f":"INDEX(Prop2022DistTar!$G$70:$G$72,D327)","v":176049.41156498002},{"$f":"INDEX(Prop2022DistTar!$G$70:$G$72,E327)","v":16056.11528928}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B337","v":"Existing: Tariff D - Murray Valley"},{"$f":"SUM(C337:E337)","v":301501.92724756006}]
[null,{"$f":"B338","v":"Proposed: Tariff D - Murray Valley"},{"$f":"SUM(C338:E338)","v":314862.75740972004}]
[]
[null,"Average price movement",{"$f":"IF(C342=0,\"\",C342/C341)","v":1.0443142446356224}]
[]
[null,{"$f":"IF(C344=\"\",\"\",IF(C344<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!B74","v":"Tariff D - Bairnsdale"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2022DistTar!C74","v":"Existing: Tariff D - Bairnsdale"},{"$f":"INDEX(Prop2022DistTar!$E$75:$E$77,C351)","v":2415.2923000000001},{"$f":"INDEX(Prop2022DistTar!$E$75:$E$77,D351)","v":1496.2836},{"$f":"INDEX(Prop2022DistTar!$E$75:$E$77,E351)","v":272.88810000000001}]
[null,{"$f":"\"Proposed: \"&B350","v":"Proposed: Tariff D - Bairnsdale"},{"$f":"INDEX(Prop2022DistTar!$D$75:$D$77,C351)","v":2522.3240999999998},{"$f":"INDEX(Prop2022DistTar!$D$75:$D$77,D351)","v":1562.5903000000001},{"$f":"INDEX(Prop2022DistTar!$D$75:$D$77,E351)","v":284.98090000000002}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B353","v":"Existing: Tariff D - Bairnsdale"},{"$f":"INDEX(Prop2022DistTar!$F$75:$F$77,C$38)","v":16.410399999999999},{"$f":"INDEX(Prop2022DistTar!$F$75:$F$77,D$38)","v":4.8068000000000008},{"$f":"INDEX(Prop2022DistTar!$F$75:$F$77,E$38)","v":0}]
[null,{"$f":"B354","v":"Proposed: Tariff D - Bairnsdale"},{"$f":"INDEX(Prop2022DistTar!$F$75:$F$77,C$38)","v":16.410399999999999},{"$f":"INDEX(Prop2022DistTar!$F$75:$F$77,D$38)","v":4.8068000000000008},{"$f":"INDEX(Prop2022DistTar!$F$75:$F$77,E$38)","v":0}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B357","v":"Existing: Tariff D - Bairnsdale"},{"$f":"INDEX(Prop2022DistTar!$H$75:$H$77,C351)","v":39635.91275992},{"$f":"INDEX(Prop2022DistTar!$H$75:$H$77,D351)","v":7192.3360084800015},{"$f":"INDEX(Prop2022DistTar!$H$75:$H$77,E351)","v":0}]
[null,{"$f":"B358","v":"Proposed: Tariff D - Bairnsdale"},{"$f":"INDEX(Prop2022DistTar!$G$75:$G$77,C351)","v":41392.347410639995},{"$f":"INDEX(Prop2022DistTar!$G$75:$G$77,D351)","v":7511.0590540400017},{"$f":"INDEX(Prop2022DistTar!$G$75:$G$77,E351)","v":0}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B361","v":"Existing: Tariff D - Bairnsdale"},{"$f":"SUM(C361:E361)","v":46828.248768400001}]
[null,{"$f":"B362","v":"Proposed: Tariff D - Bairnsdale"},{"$f":"SUM(C362:E362)","v":48903.406464679996}]
[]
[null,"Average price movement",{"$f":"IF(C366=0,\"\",C366/C365)","v":1.0443142280750914}]
[]
[null,{"$f":"IF(C368=\"\",\"\",IF(C368<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!B79","v":"Tariff V - Albury - Residential"},1,2,3,4]
[null,null,1,2,3,4]
[null,"Distribution tariff","Fixed","Blk1","Blk2","Blk3"]
[]
[null,{"$f":"\"Existing : \"&Prop2022DistTar!C79","v":"Existing : Tariff V - Albury - Residential"},{"$f":"INDEX(Prop2022DistTar!$E$81:$E$84,C$39)","v":0.25109999999999999},{"$f":"INDEX(Prop2022DistTar!$E$81:$E$84,D$39)","v":8.6069999999999993},{"$f":"INDEX(Prop2022DistTar!$E$81:$E$84,E$39)","v":5.1445999999999996},{"$f":"INDEX(Prop2022DistTar!$E$81:$E$84,F$39)","v":2.8250999999999999}]
[]
[null,{"$f":"\"Proposed : \"&B374","v":"Proposed : Tariff V - Albury - Residential"},{"$f":"INDEX(Prop2022DistTar!$D$81:$D$84,C$38)","v":0.25109999999999999},{"$f":"INDEX(Prop2022DistTar!$D$81:$D$84,D$38)","v":9.5828000000000007},{"$f":"INDEX(Prop2022DistTar!$D$81:$D$84,E$38)","v":5.7278000000000002},{"$f":"INDEX(Prop2022DistTar!$D$81:$D$84,F$38)","v":2.8250999999999999}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B378","v":"Existing : Tariff V - Albury - Residential"},{"$f":"INDEX(Prop2022DistTar!$F$81:$F$84,C$38)","v":8360632},{"$f":"INDEX(Prop2022DistTar!$F$81:$F$84,D$38)","v":192275.31005656751},{"$f":"INDEX(Prop2022DistTar!$F$81:$F$84,E$38)","v":115094.74292321946},{"$f":"INDEX(Prop2022DistTar!$F$81:$F$84,F$38)","v":745173.93406256125}]
[]
[null,{"$f":"B380","v":"Proposed : Tariff V - Albury - Residential"},{"$f":"INDEX(Prop2022DistTar!$F$81:$F$84,C$38)","v":8360632},{"$f":"INDEX(Prop2022DistTar!$F$81:$F$84,D$38)","v":192275.31005656751},{"$f":"INDEX(Prop2022DistTar!$F$81:$F$84,E$38)","v":115094.74292321946},{"$f":"INDEX(Prop2022DistTar!$F$81:$F$84,F$38)","v":745173.93406256125}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B384","v":"Existing : Tariff V - Albury - Residential"},{"$f":"INDEX(Prop2022DistTar!$H$81:$H$84,C$39)","v":2099354.6952},{"$f":"INDEX(Prop2022DistTar!$H$81:$H$84,D$39)","v":1654913.5936568764},{"$f":"INDEX(Prop2022DistTar!$H$81:$H$84,E$39)","v":592116.41444279475},{"$f":"INDEX(Prop2022DistTar!$H$81:$H$84,F$39)","v":2105190.8811201416}]
[]
[null,{"$f":"B386","v":"Proposed : Tariff V - Albury - Residential"},{"$f":"INDEX(Prop2022DistTar!$G$81:$G$84,C$38)","v":2099354.6952},{"$f":"INDEX(Prop2022DistTar!$G$81:$G$84,D$38)","v":1842535.8412100752},{"$f":"INDEX(Prop2022DistTar!$G$81:$G$84,E$38)","v":659239.66851561645},{"$f":"INDEX(Prop2022DistTar!$G$81:$G$84,F$38)","v":2105190.8811201416}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B390","v":"Existing : Tariff V - Albury - Residential"},{"$f":"SUM(C390:G390)","v":6451575.5844198121}]
[null,{"$f":"B392","v":"Proposed : Tariff V - Albury - Residential"},{"$f":"SUM(C392:G392)","v":6706321.0860458333}]
[]
[null,"Average price movement",{"$f":"IF(C396=0,\"\",C396/C395)","v":1.0394857811541753}]
[]
[null,{"$f":"IF(C398=\"\",\"\",IF(C398<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!B85","v":"Tariff V - Albury - Non Residential"},1,2,3,4,5]
[null,null,1,2,3,4,5]
[null,"Distribution tariff","Fixed","Blk1","Blk2","Blk3","Blk4"]
[]
[null,{"$f":"\"Existing : \"&Prop2022DistTar!C85","v":"Existing : Tariff V - Albury - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$E$87:$E$91,C$39)","v":0.25109999999999999},{"$f":"INDEX(Prop2022DistTar!$E$87:$E$91,D$39)","v":6.3170000000000002},{"$f":"INDEX(Prop2022DistTar!$E$87:$E$91,E$39)","v":3.1192000000000002},{"$f":"INDEX(Prop2022DistTar!$E$87:$E$91,F$39)","v":2.2149999999999999},{"$f":"INDEX(Prop2022DistTar!$E$87:$E$91,G$39)","v":0.89439999999999997}]
[]
[null,{"$f":"\"Proposed : \"&B404","v":"Proposed : Tariff V - Albury - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$D$87:$D$91,C$38)","v":0.25109999999999999},{"$f":"INDEX(Prop2022DistTar!$D$87:$D$91,D$38)","v":7.0331999999999999},{"$f":"INDEX(Prop2022DistTar!$D$87:$D$91,E$38)","v":3.1192000000000002},{"$f":"INDEX(Prop2022DistTar!$D$87:$D$91,F$38)","v":2.2149999999999999},{"$f":"INDEX(Prop2022DistTar!$D$87:$D$91,G$38)","v":0.89439999999999997}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B408","v":"Existing : Tariff V - Albury - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$F$87:$F$91,C$38)","v":338819},{"$f":"INDEX(Prop2022DistTar!$F$87:$F$91,D$38)","v":10894.173855471008},{"$f":"INDEX(Prop2022DistTar!$F$87:$F$91,E$38)","v":55072.744106879974},{"$f":"INDEX(Prop2022DistTar!$F$87:$F$91,F$38)","v":37411.784081163976},{"$f":"INDEX(Prop2022DistTar!$F$87:$F$91,G$38)","v":139269.14957664086}]
[]
[null,{"$f":"B410","v":"Proposed : Tariff V - Albury - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$F$87:$F$91,C$38)","v":338819},{"$f":"INDEX(Prop2022DistTar!$F$87:$F$91,D$38)","v":10894.173855471008},{"$f":"INDEX(Prop2022DistTar!$F$87:$F$91,E$38)","v":55072.744106879974},{"$f":"INDEX(Prop2022DistTar!$F$87:$F$91,F$38)","v":37411.784081163976},{"$f":"INDEX(Prop2022DistTar!$F$87:$F$91,G$38)","v":139269.14957664086}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B414","v":"Existing : Tariff V - Albury - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$H$87:$H$91,C$39)","v":85077.450899999996},{"$f":"INDEX(Prop2022DistTar!$H$87:$H$91,D$39)","v":68818.496245010363},{"$f":"INDEX(Prop2022DistTar!$H$87:$H$91,E$39)","v":171782.90341818004},{"$f":"INDEX(Prop2022DistTar!$H$87:$H$91,F$39)","v":82867.101739778198},{"$f":"INDEX(Prop2022DistTar!$H$87:$H$91,G$39)","v":124562.32738134758}]
[]
[null,{"$f":"B416","v":"Proposed : Tariff V - Albury - Non Residential"},{"$f":"INDEX(Prop2022DistTar!$G$87:$G$91,C$38)","v":85077.450899999996},{"$f":"INDEX(Prop2022DistTar!$G$87:$G$91,D$38)","v":76620.903560298699},{"$f":"INDEX(Prop2022DistTar!$G$87:$G$91,E$38)","v":171782.90341818004},{"$f":"INDEX(Prop2022DistTar!$G$87:$G$91,F$38)","v":82867.101739778198},{"$f":"INDEX(Prop2022DistTar!$G$87:$G$91,G$38)","v":124562.32738134758}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B420","v":"Existing : Tariff V - Albury - Non Residential"},{"$f":"SUM(C420:G420)","v":533108.27968431613}]
[null,{"$f":"B422","v":"Proposed : Tariff V - Albury - Non Residential"},{"$f":"SUM(C422:G422)","v":540910.68699960446}]
[]
[null,"Average price movement",{"$f":"IF(C426=0,\"\",C426/C425)","v":1.014635689619956}]
[]
[null,{"$f":"IF(C428=\"\",\"\",IF(C428<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2022DistTar!B93","v":"Tariff D - Albury"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2022DistTar!C93","v":"Existing: Tariff D - Albury"},{"$f":"INDEX(Prop2022DistTar!$E$94:$E$96,C435)","v":1255.7338999999999},{"$f":"INDEX(Prop2022DistTar!$E$94:$E$96,D435)","v":779.92610000000002},{"$f":"INDEX(Prop2022DistTar!$E$94:$E$96,E435)","v":188.52520000000001}]
[null,{"$f":"\"Proposed: \"&B434","v":"Proposed: Tariff D - Albury"},{"$f":"INDEX(Prop2022DistTar!$D$94:$D$96,C435)","v":1311.3807999999999},{"$f":"INDEX(Prop2022DistTar!$D$94:$D$96,D435)","v":814.48789999999997},{"$f":"INDEX(Prop2022DistTar!$D$94:$D$96,E435)","v":196.87960000000001}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B437","v":"Existing: Tariff D - Albury"},{"$f":"INDEX(Prop2022DistTar!$F$94:$F$96,C$38)","v":39.445999999999998},{"$f":"INDEX(Prop2022DistTar!$F$94:$F$96,D$38)","v":62.022599999999997},{"$f":"INDEX(Prop2022DistTar!$F$94:$F$96,E$38)","v":5.2768999999999977}]
[null,{"$f":"B438","v":"Proposed: Tariff D - Albury"},{"$f":"INDEX(Prop2022DistTar!$F$94:$F$96,C$38)","v":39.445999999999998},{"$f":"INDEX(Prop2022DistTar!$F$94:$F$96,D$38)","v":62.022599999999997},{"$f":"INDEX(Prop2022DistTar!$F$94:$F$96,E$38)","v":5.2768999999999977}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B441","v":"Existing: Tariff D - Albury"},{"$f":"INDEX(Prop2022DistTar!$H$94:$H$96,C435)","v":49533.679419399996},{"$f":"INDEX(Prop2022DistTar!$H$94:$H$96,D435)","v":48373.044529860003},{"$f":"INDEX(Prop2022DistTar!$H$94:$H$96,E435)","v":994.82862787999966}]
[null,{"$f":"B442","v":"Proposed: Tariff D - Albury"},{"$f":"INDEX(Prop2022DistTar!$G$94:$G$96,C435)","v":51728.727036799995},{"$f":"INDEX(Prop2022DistTar!$G$94:$G$96,D435)","v":50516.657226539995},{"$f":"INDEX(Prop2022DistTar!$G$94:$G$96,E435)","v":1038.9139612399997}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B445","v":"Existing: Tariff D - Albury"},{"$f":"SUM(C445:E445)","v":98901.552577139984}]
[null,{"$f":"B446","v":"Proposed: Tariff D - Albury"},{"$f":"SUM(C446:E446)","v":103284.29822457999}]
[]
[null,"Average price movement",{"$f":"IF(C450=0,\"\",C450/C449)","v":1.0443142249361719}]
[]
[null,{"$f":"IF(C452=\"\",\"\",IF(C452<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]

{"sheet":"ARS","index":5,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Tariff Approval - \"&'Model update'!B3","v":"Tariff Approval - Aust. Gas Networks (Vic & Albury)"}]
[]
["Ancillary Reference Services (Exc GST)"]
[]
[null,{"$f":"'Model update'!$B$8","v":2021},{"$f":"'Model update'!$B$5","v":2022}]
["Meter and Gas Installation Test ",220,{"$f":"ROUND(B6*(1+'Model update'!$B$30),0)","v":228}]
["Disconnection",73,{"$f":"ROUND(B7*(1+'Model update'!$B$30),0)","v":76}]
["Reconnection",85,{"$f":"ROUND(B8*(1+'Model update'!$B$30),0)","v":88}]
["Meter Removal",104,{"$f":"ROUND(B9*(1+'Model update'!$B$30),0)","v":108}]
["Meter Reinstallation",104,{"$f":"ROUND(B10*(1+'Model update'!$B$30),0)","v":108}]
["Special Meter Read - Metropolitan",9.3000000000000007,{"$f":"ROUND(B11*(1+'Model update'!$B$30),1)","v":9.6999999999999993}]
["Special Meter Read - Non Metropolitan",12.8,{"$f":"ROUND(B12*(1+'Model update'!$B$30),1)","v":13.3}]
[]
[{"$f":"\"Note: \"&'Model update'!$B$5&\" formula is as per AA2018-22, Section 4.4.2, p9 : ART = ARTt-1 * (1+CPI)\"","v":"Note: 2022 formula is as per AA2018-22, Section 4.4.2, p9 : ART = ARTt-1 * (1+CPI)"}]