{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["NOTES","Model update","Prop2021DistTar","2021TarContForm","2021RebalContForm","ARS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":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":2021}]
[]
["Issue","Location","Item","Comment"]
[]
[1,"'Model update'!B21","CPI",{"$f":"\"Updated June \"&D2-1&\" CPI for \"&D2","v":"Updated June 2020 CPI for 2021"},"NOTE: This worksheet is programmed to update for each year - use as checklist and note any placeholders or changes"]
[null,null,null,null,"NOTE: Worksheet names in this file are programmed to update each year once each worksheet is accessed and a cell is selected"]
[{"$f":"A6+1","v":2},"'Model update'!B36",{"$f":"\"Xt for \"&D2","v":"Xt for 2021"},{"$f":"\"Updated \"&$D$2&\" value\"","v":"Updated 2021 value"}]
[]
[{"$f":"A8+1","v":3},"'Model update'!B46",{"$f":"\"Pass Through Amount for \"&D2","v":"Pass Through Amount for 2021"},"NIL for 2020"]
[]
[{"$f":"A10+1","v":4},"'Model update'!B58","Real Pre-tax WACC (rptw)",{"$f":"\"Updated \"&$D$2&\" value\"","v":"Updated 2021 value"}]
[]
[{"$f":"A12+1","v":5},{"$f":"\"Prop\"&D2&\"DistTar!E8:E96\"","v":"Prop2021DistTar!E8:E96"},{"$f":"D2-1&\" tariffs\"","v":"2020 tariffs"},{"$f":"\"Updated from \"&D2-1&\" model\"","v":"Updated from 2020 model"}]
[]
[{"$f":"A14+1","v":6},"ARS!B6:B12",{"$f":"D2-1&\" ARS tariffs\"","v":"2020 ARS tariffs"},{"$f":"\"Updated from \"&D2-1&\" model\"","v":"Updated from 2020 model"}]
[]
[{"$f":"A16+1","v":7},"The following is test data to illustrate the workings of the model.",null,"Input data required from DNSPs"]
[null,{"$f":"\"Prop\"&D2&\"DistTar!D8:D96\"","v":"Prop2021DistTar!D8:D96"},{"$f":"\"Proposed \"&D2&\" Tariffs\"","v":"Proposed 2021 Tariffs"}]
[null,{"$f":"\"Prop\"&D2&\"DistTar!F8:F96\"","v":"Prop2021DistTar!F8:F96"},{"$f":"\"Actual \"&D2-2&\" Volumes\"","v":"Actual 2019 Volumes"}]
[]
[null,"ARS!C6:C12",{"$f":"\"Proposed \"&D2&\" Ancillary Reference Services Charges\"","v":"Proposed 2021 Ancillary Reference Services Charges"},"Calculated using formula"]

{"sheet":"Model update","index":1,"n_rows":58,"n_cols":2,"rows_kept":58,"cut":false,"hidden":false,"merged":[[54,0,55,1]]}
[]
[]
["Tariff Approval Template for ","Aust. Gas Networks (Vic & Albury)"]
[]
["Calendar year commencing",2021]
[]
["t",{"$f":"B5","v":2021}]
["t-1",{"$f":"B7-1","v":2020}]
["t-2",2019]
["t-3",2018]
[]
[]
["Please fill in yellow highlighted cells where appropriate"]
[]
["CPI"]
[]
["CPI Index June 2016",108.6]
["CPI Index June 2017",110.7]
["CPI Index June 2018",113]
["CPI Index June 2019",114.8]
["CPI Index June 2020",114.4]
["CPI Index June 2021"]
[]
[]
[{"$f":"\"CPI Index June \" &$B$10","v":"CPI Index June 2018"},{"$f":"VLOOKUP(A25,A$17:B$22,2,FALSE)","v":113}]
[{"$f":"\"CPI Index June \" &$B$9","v":"CPI Index June 2019"},{"$f":"VLOOKUP(A26,A$17:B$22,2,FALSE)","v":114.8}]
[{"$f":"\"CPI Index June \" &$B$8","v":"CPI Index June 2020"},{"$f":"VLOOKUP(A27,A$17:B$22,2,FALSE)","v":114.4}]
[]
[{"$f":"\"CPI \" &$B$8","v":"CPI 2020"},{"$f":"B26/B25-1","v":1.5929203539823078E-2}]
[{"$f":"\"CPI \" &$B$5","v":"CPI 2021"},{"$f":"B27/B26-1","v":-3.4843205574912606E-3}]
[]
[]
[{"$f":"\"Xt for \"&B$5","v":"Xt for 2021"}]
[2019,-1.2932003198752063E-2]
[2020,-5.9643805428307873E-3]
[2021,-2.9121585433830224E-3]
[2022,-1.35E-2]
[]
[]
[{"$f":"\"Xt for \"&B$5","v":"Xt for 2021"},{"$f":"VLOOKUP(B5,A34:B38,2,FALSE)","v":-2.9121585433830224E-3}]
[]
[]
["Pass Through Amounts :  PT (t)"]
[2019,0]
[2020,0]
[2021,0]
[2022,0]
[]
[]
[{"$f":"\"Pass Through Amount for \"&B$5","v":"Pass Through Amount for 2021"},{"$f":"VLOOKUP(B5,A44:B48,2,FALSE)","v":0}]
["The Pass Through Amount is to include an amount that reflects the time value of money between incurring the costs and recovering the costs"]
["and excludes any amounts already passed through in reference tariffs."]
[]
[]
["Pre-tax WACC for distribution tariffs "]
[]
[]
[" Pretax WACCD",3.605542631615144E-2]

{"sheet":"Prop2021DistTar","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":"Prop2021DistTar"}]
[]
[null,{"$f":"\"PROPOSED \"&'Model update'!$B$5&\" DISTRIBUTION TARIFFS\"","v":"PROPOSED 2021 DISTRIBUTION TARIFFS"}]
[]
[null,"Proposed tariff name","Existing tariff name",{"$f":"\"Prop\n\"&'Model update'!$B$5&\" Tariff\"","v":"Prop\n2021 Tariff"},{"$f":"\"Exist\n\"&'Model update'!$B$8&\" Tariff\"","v":"Exist\n2020 Tariff"},{"$f":"\"Actual \"&'Model update'!$B$9&\" Volumes\"","v":"Actual 2019 Volumes"},"Prop Tar\nRevenue","Exist Tar\nRevenue"]
[null,"Tariff V - AGN Central - Residential","Tariff V - AGN Central - Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.193,0.19309999999999999,205059578,{"$f":"D8*$F8","v":39576498.553999998},{"$f":"E8*$F8","v":39597004.511799999}]
[null,"GJ 0 - 0.0274","GJ 0 - 0.0274",11.8856,11.8925,4898091.6888095047,{"$f":"D9*$F9","v":58216758.576514252},58250555.409167036]
[null,"GJ 0.0274 - 0.0493","GJ 0.0274 - 0.0493",6.8338000000000001,6.8377999999999997,3062512.152785081,20928595.549702685,20940845.598313827]
[null,"GJ > 0.0493","GJ > 0.0493",3.7513999999999998,3.7538,18240946.651288182,68429087.267642483,68472865.539605573]
[null,"Tariff V - AGN Central - Non Residential","Tariff V - AGN Central - Non Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.193,0.19309999999999999,7304213,{"$f":"D14*$F14","v":1409713.1089999999},{"$f":"E14*$F14","v":1410443.5303}]
[null,"GJ 0 - 0.05","GJ 0 - 0.05",8.39,8.3948999999999998,266313.64792238764,{"$f":"D15*$F15","v":2234371.5060688322},2235676.4429436522]
[null,"GJ 0.05 - 0.55","GJ 0.05 - 0.55",3.9599000000000002,3.9622000000000002,1443576.7831511109,5716419.7036000844,5719739.9302013321]
[null,"GJ 0.55 - 1.37","GJ 0.55 - 1.37",2.9535999999999998,2.9552999999999998,1167065.0089756171,3447043.2105103824,3449027.2210256411]
[null,"GJ > 1.37","GJ > 1.37",1.1929000000000001,1.1936,4103544.0663897018,4895117.7167962752,4897990.1976427482]
[null,"Tariff V - AGN North - Residential","Tariff V - AGN North - Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.193,0.19309999999999999,28977377,{"$f":"D21*$F21","v":5592633.7609999999},{"$f":"E21*$F21","v":5595531.4986999994}]
[null,"GJ 0 - 0.0274","GJ 0 - 0.0274",10.4575,10.4636,664129.75276136328,{"$f":"D22*$F22","v":6945136.8895019563},6949188.0809938004]
[null,"GJ 0.0274 - 0.0493","GJ 0.0274 - 0.0493",6.1215000000000002,6.1250999999999998,397382.03996837436,2432574.1576664038,2434004.7330102897]
[null,"GJ > 0.0493","GJ > 0.0493",3.3609,3.3628999999999998,2557176.0828654249,8594413.0969024058,8599527.4490681365]
[null,"Tariff V - AGN North - Non Residential","Tariff V - AGN North - Non Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.193,0.19309999999999999,1197219,{"$f":"D27*$F27","v":231063.26699999999},{"$f":"E27*$F27","v":231182.9889}]
[null,"GJ 0 - 0.05","GJ 0 - 0.05",7.5259,7.5303000000000004,37630.697013927864,{"$f":"D28*$F28","v":283204.86265711969},283370.43772398098]
[null,"GJ 0.05 - 0.55","GJ 0.05 - 0.55",3.5788000000000002,3.5809000000000002,184739.00299572418,661143.94392109767,661531.89582738874]
[null,"GJ 0.55 - 1.37","GJ 0.55 - 1.37",2.6690999999999998,2.6707000000000001,127263.14566871065,339678.0621043556,339881.68313742557]
[null,"GJ > 1.37","GJ > 1.37",1.0785,1.0790999999999999,496073.4155062486,535015.1786234891,535312.82267279283]
[null,"Tariff V - Murray Valley - Residential","Tariff V - Murray Valley - Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.2457,0.24579999999999999,2990930,{"$f":"D34*$F34","v":734871.50100000005},{"$f":"E34*$F34","v":735170.59399999992}]
[null,"GJ 0 - 0.0274","GJ 0 - 0.0274",9.1044999999999998,9.1097999999999999,57802.152626636329,{"$f":"D35*$F35","v":526259.6985892104},526566.04999813158]
[null,"GJ 0.0274 - 0.0493","GJ 0.0274 - 0.0493",5.5079000000000002,5.5110999999999999,30628.05682436829,168696.27418293813,168794.28396477608]
[null,"GJ > 0.0493","GJ > 0.0493",3.4455,3.4474999999999998,192707.46998040809,663973.58781749604,664359.00275745685]
[null,"Tariff V - Murray Valley - Non Residential","Tariff V - Murray Valley - Non Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.2457,0.24579999999999999,130312,{"$f":"D40*$F40","v":32017.6584},{"$f":"E40*$F40","v":32030.689599999998}]
[null,"GJ 0 - 0.05","GJ 0 - 0.05",6.7290999999999999,6.7329999999999997,4406.9050896670024,{"$f":"D41*$F41","v":29654.505038878226},29671.691968727926]
[null,"GJ 0.05 - 0.55","GJ 0.05 - 0.55",3.9744000000000002,3.9767000000000001,20671.549759732974,82157.00736508274,82204.55192953012]
[null,"GJ 0.55 - 1.37","GJ 0.55 - 1.37",2.9661,2.9678,12808.446194453998,37991.132257370002,38012.906615900574]
[null,"GJ > 1.37","GJ > 1.37",1.3427,1.3434999999999999,28696.127148841006,38530.289922748816,38553.246824467889]
[null,"Tariff V - Bairnsdale - Residential","Tariff V - Bairnsdale - Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.31759999999999999,0.31780000000000003,1657399,{"$f":"D47*$F47","v":526389.92240000004},{"$f":"E47*$F47","v":526721.40220000001}]
[null,"GJ 0 - 0.0274","GJ 0 - 0.0274",19.4053,19.416599999999999,32506.662790609971,{"$f":"D48*$F48","v":630801.54345062363},{"$f":"E48*$F48","v":631168.86874015757}]
[null,"GJ 0.0274 - 0.0493","GJ 0.0274 - 0.0493",11.286799999999999,11.2934,16112.610177241058,181859.80854848438,181966.15177565417]
[null,"GJ > 0.0493","GJ > 0.0493",6.2016999999999998,6.1999000000000004,69682.996465973032,432153.03918302496,432027.60978938622]
[null,"Tariff V - Bairnsdale - Non Residential","Tariff V - Bairnsdale - Non Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.31759999999999999,0.31780000000000003,43459,{"$f":"D53*$F53","v":13802.5784},{"$f":"E53*$F53","v":13811.270200000001}]
[null,"GJ 0 - 0.05","GJ 0 - 0.05",13.7965,13.804500000000001,1792.2717191360005,{"$f":"D54*$F54","v":24727.076773059831},{"$f":"E54*$F54","v":24741.414946812918}]
[null,"GJ 0.05 - 0.55","GJ 0.05 - 0.55",6.7260999999999997,6.73,13124.727761945993,88278.231399624943,88329.417837896544]
[null,"GJ 0.55 - 1.37","GJ 0.55 - 1.37",5.0148999999999999,5.0178000000000003,10214.248610588005,51223.435357237788,51253.056678208493]
[null,"GJ > 1.37","GJ > 1.37",2.0256000000000003,2.0266999999999999,41020.008440777019,83090.129097637939,83135.251106922777]
[]
[null,"Tariff D -  AGN Central","Tariff D -  AGN Central"]
[null,"0 - 10","0 - 10",1460.155,1461.0057999999999,1429.1395999999995,{"$f":"D60*$F60","v":2086765.3326379992},2087981.2446096791]
[null,"10 - 50","10 - 50",892.64530000000002,893.16539999999998,1224.1337999999998,1092717.2831411399,1093353.9551305198]
[null,"> 50","> 50",163.0154,163.1104,1251.7936999999999,204061.65072298,204180.57112447999]
[]
[null,"Tariff D - AGN North","Tariff D - AGN North"]
[null,"0 - 10","0 - 10",1460.155,1461.0057999999999,429.69869999999997,{"$f":"D65*$F65","v":627426.7052984999},627792.29295245989]
[null,"10 - 50","10 - 50",892.64530000000002,893.16539999999998,600.40189999999996,535945.93414606992,536258.20317425998]
[null,"> 50","> 50",163.0154,163.1104,438.6123,71500.559529420003,71542.227697919996]
[]
[null,"Tariff D - Murray Valley","Tariff D - Murray Valley"]
[null,"0 - 10","0 - 10",1701.9860000000001,1702.9776999999999,68.440300000000008,{"$f":"D70*$F70","v":116484.43243580002},116552.30468131001]
[null,"10 - 50","10 - 50",1050.2328,1050.8447000000001,160.83710000000002,168916.39787688002,169014.81409837003]
[null,"> 50","> 50",178.8732,178.97739999999999,78.773099999999999,14090.396470919999,14098.60462794]
[]
[null,"Tariff D - Bairnsdale","Tariff D - Bairnsdale"]
[null,"0 - 10","0 - 10",2415.2923000000001,2416.6995999999999,16.009700000000002,{"$f":"D75*$F75","v":38668.105135310005},38690.635586120006]
[null,"10 - 50","10 - 50",1496.2836,1497.1554000000001,2.7294,4083.95645784,4086.3359487600005]
[null,"> 50","> 50",272.88810000000001,273.0471,0,0,0]
[]
[null,"Tariff V - Albury - Residential","Tariff V - Albury - Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.25109999999999999,0.25119999999999998,8209588,{"$f":"D81*$F81","v":2061427.5467999999},2062248.5055999998]
[null,"GJ 0 - 0.0274","GJ 0 - 0.0274",8.6069999999999993,8.6120000000000001,186859.48234335432,1608299.5645292506,1609233.8619409674]
[null,"GJ 0.0274 - 0.0493","GJ 0.0274 - 0.0493",5.1445999999999996,5.1475999999999997,110413.06763127322,568031.06773584813,568362.30693874205]
[null,"GJ > 0.0493","GJ > 0.0493",2.8250999999999999,2.8267000000000002,710587.82733224751,2007481.6709963323,2008618.6115200643]
[null,"Tariff V - Albury - Non Residential","Tariff V - Albury - Non Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.25109999999999999,0.25119999999999998,338182,{"$f":"D87*$F87","v":84917.500199999995},84951.318399999989]
[null,"GJ 0 - 0.05","GJ 0 - 0.05",6.3170000000000002,6.3207000000000004,11076.581779452994,69970.767100804558,70011.750453388537]
[null,"GJ 0.05 - 0.55","GJ 0.05 - 0.55",3.1192000000000002,3.121,57113.873612594893,178149.594572406,178252.39954490867]
[null,"GJ 0.55 - 1.37","GJ 0.55 - 1.37",2.2149999999999999,2.2162999999999999,41149.016723229011,91145.072041952255,91198.565763692459]
[null,"GJ > 1.37","GJ > 1.37",0.89439999999999997,0.89490000000000003,171447.0921728932,153342.27923943568,153428.00278552214]
[]
[null,"Tariff D - Albury","Tariff D - Albury"]
[null,"0 - 10","0 - 10",1255.7338999999999,1256.4656,49.456200000000003,{"$f":"D94*$F94","v":62103.826905180002},62140.014006720005]
[null,"10 - 50","10 - 50",779.92610000000002,780.38049999999998,106.018,{"$f":"D95*$F95","v":82686.205269800004},82734.379849000004]
[null,"> 50","> 50",188.52520000000001,188.63499999999999,188.90899999999999,35614.107006799997,35634.849214999995]
[]
[]
[]
[]
[null,"Total Revenue","Total Revenue",null,null,null,{"$f":"SUM(G8:G97)","v":246778775.78864592},{"$f":"SUM(H8:H97)","v":246922563.18761748}]

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

{"sheet":"2021RebalContForm","index":4,"n_rows":454,"n_cols":7,"rows_kept":454,"cut":false,"hidden":false,"merged":[[63,1,63,2],[93,1,93,2],[123,1,123,2],[183,1,183,2],[213,1,213,2],[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]]}
[null,{"$f":"\"Tariff Approval - \"&'Model update'!B3","v":"Tariff Approval - Aust. Gas Networks (Vic & Albury)"},{"$f":"'Model update'!B7&\"RebalContForm\"","v":"2021RebalContForm"}]
[]
[null,{"$f":"'Model update'!$B$5&\"  REBALANCING CONTROL FORMULA\"","v":"2021  REBALANCING CONTROL FORMULA"}]
[]
[]
[null,"Rebalancing control"]
[]
[null,{"$f":"\"CPI \"&'Model update'!$B$5","v":"CPI 2021"},{"$f":"'2021TarContForm'!C11","v":-3.4843205574912606E-3}]
[null,{"$f":"\"Y  \"&'Model update'!$B$5","v":"Y  2021"},0.02]
[null,{"$f":"\"PTt \"&'Model update'!$B$5","v":"PTt 2021"},{"$f":"'2021TarContForm'!C29","v":0}]
[null,{"$f":"\"Xt \"&'Model update'!$B$5","v":"Xt 2021"},{"$f":"'2021TarContForm'!C17","v":-2.9121585433830224E-3}]
[]
[null,"Rebalancing control",{"$f":"(1+C8)*(1+C9)*(1+C10)*(1-C11)","v":1.0194060449138527}]
[]
[]
[]
[null,"Rebalancing control summary"]
[null,null,"Existing","Proposed","Movement","Assessment"]
[null,{"$f":"B38","v":"Tariff V - AGN Central - Residential"},{"$f":"C59","v":187261271.05888644},{"$f":"C60","v":187150939.94785941},{"$f":"IF(C19=0,0,D19/C19)","v":0.99941081724799175},{"$f":"IF(E19=0,\"\",IF($C$13<=E19,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B68","v":"Tariff V - AGN North - Residential"},{"$f":"C89","v":23578251.761772227},{"$f":"C90","v":23564757.905070767},{"$f":"IF(C20=0,0,D20/C20)","v":0.99942769901527062},{"$f":"IF(E20=0,\"\",IF($C$13<=E20,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B98","v":"Tariff V - Murray Valley - Residential"},{"$f":"C119","v":2094889.9307203644},{"$f":"C120","v":2093801.0615896448},0.99948022608980447,"Compliant"]
[null,{"$f":"B128","v":"Tariff V - Bairnsdale - Residential"},{"$f":"C149","v":1771884.0325051979},{"$f":"C150","v":1771204.3135821333},0.99961638633759586,"Compliant"]
[null,{"$f":"B158","v":"Tariff V - AGN Central - Non Residential"},{"$f":"C179","v":17712877.322113372},{"$f":"C180","v":17702665.245975576},0.99942346599301246,"Compliant"]
[null,{"$f":"B188","v":"Tariff V - AGN North - Non Residential"},{"$f":"C209","v":2051279.8282615882},{"$f":"C210","v":2050105.3143060619},0.99942742382616723,{"$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":220473.08693862654},{"$f":"C240","v":220350.59298407979},0.99944440404836876,"Compliant"]
[null,{"$f":"B248","v":"Tariff V - Bairnsdale - Non Residential"},{"$f":"C269","v":261270.41076984073},{"$f":"C270","v":261121.45102756051},{"$f":"IF(C26=0,0,D26/C26)","v":0.99942986371154197},{"$f":"IF(E26=0,\"\",IF($C$13<=E26,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B278","v":"Tariff D -  AGN Central"},{"$f":"C293","v":3385515.770864679},{"$f":"C294","v":3383544.2665021191},{"$f":"IF(C27=0,0,D27/C27)","v":0.99941766498932705},{"$f":"IF(E27=0,\"\",IF($C$13<=E27,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B302","v":"Tariff D - AGN North"},{"$f":"C317","v":1235592.7238246398},{"$f":"C318","v":1234873.1989739898},0.99941766826821155,"Compliant"]
[null,{"$f":"B326","v":"Tariff D - Murray Valley"},{"$f":"C341","v":299665.72340762004},{"$f":"C342","v":299491.22678360005},0.99941769575099981,"Compliant"]
[null,{"$f":"B350","v":"Tariff D - Bairnsdale"},{"$f":"C365","v":42776.971534880009},{"$f":"C366","v":42752.061593150007},0.9994176786986968,"Compliant"]
[null,{"$f":"B374","v":"Tariff V - Albury - Residential"},{"$f":"C395","v":6248463.2859997731},{"$f":"C396","v":6245239.8500614315},0.99948412340910064,"Compliant"]
[null,{"$f":"B404","v":"Tariff V - Albury - Non Residential"},{"$f":"C425","v":577842.03694751184},{"$f":"C426","v":577525.21315459849},0.99945171210701977,"Compliant"]
[null,{"$f":"B434","v":"Tariff D - Albury"},{"$f":"C449","v":180509.24307072},{"$f":"C450","v":180404.13918177999},0.99941773680310197,"Compliant"]
[null,null,{"$f":"SUM(C19:C33)","v":246922563.18761745},{"$f":"SUM(D19:D33)","v":246778775.78864589},0.99941768221941585]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!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 : \"&Prop2021DistTar!C6","v":"Existing : Tariff V - AGN Central - Residential"},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$11,C$39)","v":0.19309999999999999},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$11,D$39)","v":11.8925},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$11,E$39)","v":6.8377999999999997},{"$f":"INDEX(Prop2021DistTar!$E$8:$E$11,F$39)","v":3.7538}]
[]
[null,{"$f":"\"Proposed : \"&B38","v":"Proposed : Tariff V - AGN Central - Residential"},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$11,C$38)","v":0.193},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$11,D$38)","v":11.8856},{"$f":"INDEX(Prop2021DistTar!$D$8:$D$11,E$38)","v":6.8338000000000001},{"$f":"INDEX(Prop2021DistTar!$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(Prop2021DistTar!$F$8:$F$11,C$13)","v":205059578},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$11,D$38)","v":4898091.6888095047},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$11,E$38)","v":3062512.152785081},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$11,F$38)","v":18240946.651288182}]
[]
[null,{"$f":"B44","v":"Proposed : Tariff V - AGN Central - Residential"},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$11,C$38)","v":205059578},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$11,D$38)","v":4898091.6888095047},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$11,E$38)","v":3062512.152785081},{"$f":"INDEX(Prop2021DistTar!$F$8:$F$11,F$38)","v":18240946.651288182}]
[]
[null,"Distribution revenue",{"$f":"C$40","v":"Fixed"},"Blk1","Blk2","Blk3"]
[]
[null,{"$f":"B48","v":"Existing : Tariff V - AGN Central - Residential"},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$11,C$39)","v":39597004.511799999},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$11,D$39)","v":58250555.409167036},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$11,E$39)","v":20940845.598313827},{"$f":"INDEX(Prop2021DistTar!$H$8:$H$11,F$39)","v":68472865.539605573}]
[]
[null,{"$f":"B50","v":"Proposed : Tariff V - AGN Central - Residential"},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$11,C$38)","v":39576498.553999998},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$11,D$38)","v":58216758.576514252},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$11,E$38)","v":20928595.549702685},{"$f":"INDEX(Prop2021DistTar!$G$8:$G$11,F$38)","v":68429087.267642483}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B54","v":"Existing : Tariff V - AGN Central - Residential"},{"$f":"SUM(C54:F54)","v":187261271.05888644}]
[null,{"$f":"B56","v":"Proposed : Tariff V - AGN Central - Residential"},{"$f":"SUM(C56:F56)","v":187150939.94785941}]
[]
[null,"Average price movement",{"$f":"IF(C60=0,\"\",C60/C59)","v":0.99941081724799175}]
[]
[null,{"$f":"IF(C62=\"\",\"\",IF(C62<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!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 : \"&Prop2021DistTar!C19","v":"Existing : Tariff V - AGN North - Residential"},{"$f":"INDEX(Prop2021DistTar!$E$21:$E$24,C$39)","v":0.19309999999999999},{"$f":"INDEX(Prop2021DistTar!$E$21:$E$24,D$39)","v":10.4636},{"$f":"INDEX(Prop2021DistTar!$E$21:$E$24,E$39)","v":6.1250999999999998},{"$f":"INDEX(Prop2021DistTar!$E$21:$E$24,F$39)","v":3.3628999999999998}]
[]
[null,{"$f":"\"Proposed : \"&B68","v":"Proposed : Tariff V - AGN North - Residential"},{"$f":"INDEX(Prop2021DistTar!$D$21:$D$24,C$38)","v":0.193},{"$f":"INDEX(Prop2021DistTar!$D$21:$D$24,D$38)","v":10.4575},{"$f":"INDEX(Prop2021DistTar!$D$21:$D$24,E$38)","v":6.1215000000000002},{"$f":"INDEX(Prop2021DistTar!$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(Prop2021DistTar!$F$21:$F$24,C$38)","v":28977377},{"$f":"INDEX(Prop2021DistTar!$F$21:$F$24,D$38)","v":664129.75276136328},{"$f":"INDEX(Prop2021DistTar!$F$21:$F$24,E$38)","v":397382.03996837436},{"$f":"INDEX(Prop2021DistTar!$F$21:$F$24,F$38)","v":2557176.0828654249}]
[]
[null,{"$f":"B74","v":"Proposed : Tariff V - AGN North - Residential"},{"$f":"INDEX(Prop2021DistTar!$F$21:$F$24,C$38)","v":28977377},{"$f":"INDEX(Prop2021DistTar!$F$21:$F$24,D$38)","v":664129.75276136328},{"$f":"INDEX(Prop2021DistTar!$F$21:$F$24,E$38)","v":397382.03996837436},{"$f":"INDEX(Prop2021DistTar!$F$21:$F$24,F$38)","v":2557176.0828654249}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B78","v":"Existing : Tariff V - AGN North - Residential"},{"$f":"INDEX(Prop2021DistTar!$H$21:$H$24,C$39)","v":5595531.4986999994},{"$f":"INDEX(Prop2021DistTar!$H$21:$H$24,D$39)","v":6949188.0809938004},{"$f":"INDEX(Prop2021DistTar!$H$21:$H$24,E$39)","v":2434004.7330102897},{"$f":"INDEX(Prop2021DistTar!$H$21:$H$24,F$39)","v":8599527.4490681365}]
[]
[null,{"$f":"B80","v":"Proposed : Tariff V - AGN North - Residential"},{"$f":"INDEX(Prop2021DistTar!$G$21:$G$24,C$38)","v":5592633.7609999999},{"$f":"INDEX(Prop2021DistTar!$G$21:$G$24,D$38)","v":6945136.8895019563},{"$f":"INDEX(Prop2021DistTar!$G$21:$G$24,E$38)","v":2432574.1576664038},{"$f":"INDEX(Prop2021DistTar!$G$21:$G$24,F$38)","v":8594413.0969024058}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B84","v":"Existing : Tariff V - AGN North - Residential"},{"$f":"SUM(C84:F84)","v":23578251.761772227}]
[null,{"$f":"B86","v":"Proposed : Tariff V - AGN North - Residential"},{"$f":"SUM(C86:F86)","v":23564757.905070767}]
[]
[null,"Average price movement",{"$f":"IF(C90=0,\"\",C90/C89)","v":0.99942769901527062}]
[]
[null,{"$f":"IF(C92=\"\",\"\",IF(C92<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!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 : \"&Prop2021DistTar!C32","v":"Existing : Tariff V - Murray Valley - Residential"},{"$f":"INDEX(Prop2021DistTar!$E$34:$E$37,C$39)","v":0.24579999999999999},{"$f":"INDEX(Prop2021DistTar!$E$34:$E$37,D$39)","v":9.1097999999999999},{"$f":"INDEX(Prop2021DistTar!$E$34:$E$37,E$39)","v":5.5110999999999999},{"$f":"INDEX(Prop2021DistTar!$E$34:$E$37,F$39)","v":3.4474999999999998}]
[]
[null,{"$f":"\"Proposed : \"&B98","v":"Proposed : Tariff V - Murray Valley - Residential"},{"$f":"INDEX(Prop2021DistTar!$D$34:$D$37,C$38)","v":0.2457},{"$f":"INDEX(Prop2021DistTar!$D$34:$D$37,D$38)","v":9.1044999999999998},{"$f":"INDEX(Prop2021DistTar!$D$34:$D$37,E$38)","v":5.5079000000000002},{"$f":"INDEX(Prop2021DistTar!$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(Prop2021DistTar!$F$34:$F$37,C$38)","v":2990930},{"$f":"INDEX(Prop2021DistTar!$F$34:$F$37,D$38)","v":57802.152626636329},{"$f":"INDEX(Prop2021DistTar!$F$34:$F$37,E$38)","v":30628.05682436829},{"$f":"INDEX(Prop2021DistTar!$F$34:$F$37,F$38)","v":192707.46998040809}]
[]
[null,{"$f":"B104","v":"Proposed : Tariff V - Murray Valley - Residential"},{"$f":"INDEX(Prop2021DistTar!$F$34:$F$37,C$38)","v":2990930},{"$f":"INDEX(Prop2021DistTar!$F$34:$F$37,D$38)","v":57802.152626636329},{"$f":"INDEX(Prop2021DistTar!$F$34:$F$37,E$38)","v":30628.05682436829},{"$f":"INDEX(Prop2021DistTar!$F$34:$F$37,F$38)","v":192707.46998040809}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B108","v":"Existing : Tariff V - Murray Valley - Residential"},{"$f":"INDEX(Prop2021DistTar!$H$34:$H$37,C$39)","v":735170.59399999992},{"$f":"INDEX(Prop2021DistTar!$H$34:$H$37,D$39)","v":526566.04999813158},{"$f":"INDEX(Prop2021DistTar!$H$34:$H$37,E$39)","v":168794.28396477608},{"$f":"INDEX(Prop2021DistTar!$H$34:$H$37,F$39)","v":664359.00275745685}]
[]
[null,{"$f":"B110","v":"Proposed : Tariff V - Murray Valley - Residential"},{"$f":"INDEX(Prop2021DistTar!$G$34:$G$37,C$38)","v":734871.50100000005},{"$f":"INDEX(Prop2021DistTar!$G$34:$G$37,D$38)","v":526259.6985892104},{"$f":"INDEX(Prop2021DistTar!$G$34:$G$37,E$38)","v":168696.27418293813},{"$f":"INDEX(Prop2021DistTar!$G$34:$G$37,F$38)","v":663973.58781749604}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B114","v":"Existing : Tariff V - Murray Valley - Residential"},{"$f":"SUM(C114:F114)","v":2094889.9307203644}]
[null,{"$f":"B116","v":"Proposed : Tariff V - Murray Valley - Residential"},{"$f":"SUM(C116:F116)","v":2093801.0615896448}]
[]
[null,"Average price movement",{"$f":"IF(C120=0,\"\",C120/C119)","v":0.99948022608980447}]
[]
[null,{"$f":"IF(C122=\"\",\"\",IF(C122<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!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 : \"&Prop2021DistTar!C45","v":"Existing : Tariff V - Bairnsdale - Residential"},{"$f":"INDEX(Prop2021DistTar!$E$47:$E$50,C$39)","v":0.31780000000000003},{"$f":"INDEX(Prop2021DistTar!$E$47:$E$50,D$39)","v":19.416599999999999},{"$f":"INDEX(Prop2021DistTar!$E$47:$E$50,E$39)","v":11.2934},{"$f":"INDEX(Prop2021DistTar!$E$47:$E$50,F$39)","v":6.1999000000000004}]
[]
[null,{"$f":"\"Proposed : \"&B128","v":"Proposed : Tariff V - Bairnsdale - Residential"},{"$f":"INDEX(Prop2021DistTar!$D$47:$D$50,C$38)","v":0.31759999999999999},{"$f":"INDEX(Prop2021DistTar!$D$47:$D$50,D$38)","v":19.4053},{"$f":"INDEX(Prop2021DistTar!$D$47:$D$50,E$38)","v":11.286799999999999},{"$f":"INDEX(Prop2021DistTar!$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(Prop2021DistTar!$F$47:$F$50,C$38)","v":1657399},{"$f":"INDEX(Prop2021DistTar!$F$47:$F$50,D$38)","v":32506.662790609971},{"$f":"INDEX(Prop2021DistTar!$F$47:$F$50,E$38)","v":16112.610177241058},{"$f":"INDEX(Prop2021DistTar!$F$47:$F$50,F$38)","v":69682.996465973032}]
[]
[null,{"$f":"B134","v":"Proposed : Tariff V - Bairnsdale - Residential"},{"$f":"INDEX(Prop2021DistTar!$F$47:$F$50,C$38)","v":1657399},{"$f":"INDEX(Prop2021DistTar!$F$47:$F$50,D$38)","v":32506.662790609971},{"$f":"INDEX(Prop2021DistTar!$F$47:$F$50,E$38)","v":16112.610177241058},{"$f":"INDEX(Prop2021DistTar!$F$47:$F$50,F$38)","v":69682.996465973032}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B138","v":"Existing : Tariff V - Bairnsdale - Residential"},{"$f":"INDEX(Prop2021DistTar!$H$47:$H$50,C$39)","v":526721.40220000001},{"$f":"INDEX(Prop2021DistTar!$H$47:$H$50,D$39)","v":631168.86874015757},{"$f":"INDEX(Prop2021DistTar!$H$47:$H$50,E$39)","v":181966.15177565417},{"$f":"INDEX(Prop2021DistTar!$H$47:$H$50,F$39)","v":432027.60978938622}]
[]
[null,{"$f":"B140","v":"Proposed : Tariff V - Bairnsdale - Residential"},{"$f":"INDEX(Prop2021DistTar!$G$47:$G$50,C$38)","v":526389.92240000004},{"$f":"INDEX(Prop2021DistTar!$G$47:$G$50,D$38)","v":630801.54345062363},{"$f":"INDEX(Prop2021DistTar!$G$47:$G$50,E$38)","v":181859.80854848438},{"$f":"INDEX(Prop2021DistTar!$G$47:$G$50,F$38)","v":432153.03918302496}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B144","v":"Existing : Tariff V - Bairnsdale - Residential"},{"$f":"SUM(C144:F144)","v":1771884.0325051979}]
[null,{"$f":"B146","v":"Proposed : Tariff V - Bairnsdale - Residential"},{"$f":"SUM(C146:F146)","v":1771204.3135821333}]
[]
[null,"Average price movement",{"$f":"IF(C150=0,\"\",C150/C149)","v":0.99961638633759586}]
[]
[null,{"$f":"IF(C152=\"\",\"\",IF(C152<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!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 : \"&Prop2021DistTar!C12","v":"Existing : Tariff V - AGN Central - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$E$14:$E$18,C$39)","v":0.19309999999999999},{"$f":"INDEX(Prop2021DistTar!$E$14:$E$18,D$39)","v":8.3948999999999998},{"$f":"INDEX(Prop2021DistTar!$E$14:$E$18,E$39)","v":3.9622000000000002},{"$f":"INDEX(Prop2021DistTar!$E$14:$E$18,F$39)","v":2.9552999999999998},{"$f":"INDEX(Prop2021DistTar!$E$14:$E$18,G$39)","v":1.1936}]
[]
[null,{"$f":"\"Proposed : \"&B158","v":"Proposed : Tariff V - AGN Central - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$D$14:$D$18,C$38)","v":0.193},{"$f":"INDEX(Prop2021DistTar!$D$14:$D$18,D$38)","v":8.39},{"$f":"INDEX(Prop2021DistTar!$D$14:$D$18,E$38)","v":3.9599000000000002},{"$f":"INDEX(Prop2021DistTar!$D$14:$D$18,F$38)","v":2.9535999999999998},{"$f":"INDEX(Prop2021DistTar!$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(Prop2021DistTar!$F$14:$F$18,C$38)","v":7304213},{"$f":"INDEX(Prop2021DistTar!$F$14:$F$18,D$38)","v":266313.64792238764},{"$f":"INDEX(Prop2021DistTar!$F$14:$F$18,E$38)","v":1443576.7831511109},{"$f":"INDEX(Prop2021DistTar!$F$14:$F$18,F$38)","v":1167065.0089756171},{"$f":"INDEX(Prop2021DistTar!$F$14:$F$18,G$38)","v":4103544.0663897018}]
[]
[null,{"$f":"B164","v":"Proposed : Tariff V - AGN Central - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$F$14:$F$18,C$38)","v":7304213},{"$f":"INDEX(Prop2021DistTar!$F$14:$F$18,D$38)","v":266313.64792238764},{"$f":"INDEX(Prop2021DistTar!$F$14:$F$18,E$38)","v":1443576.7831511109},{"$f":"INDEX(Prop2021DistTar!$F$14:$F$18,F$38)","v":1167065.0089756171},{"$f":"INDEX(Prop2021DistTar!$F$14:$F$18,G$38)","v":4103544.0663897018}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B168","v":"Existing : Tariff V - AGN Central - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$H$14:$H$18,C$39)","v":1410443.5303},{"$f":"INDEX(Prop2021DistTar!$H$14:$H$18,D$39)","v":2235676.4429436522},{"$f":"INDEX(Prop2021DistTar!$H$14:$H$18,E$39)","v":5719739.9302013321},{"$f":"INDEX(Prop2021DistTar!$H$14:$H$18,F$39)","v":3449027.2210256411},{"$f":"INDEX(Prop2021DistTar!$H$14:$H$18,G$39)","v":4897990.1976427482}]
[]
[null,{"$f":"B170","v":"Proposed : Tariff V - AGN Central - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$G$14:$G$18,C$38)","v":1409713.1089999999},{"$f":"INDEX(Prop2021DistTar!$G$14:$G$18,D$38)","v":2234371.5060688322},{"$f":"INDEX(Prop2021DistTar!$G$14:$G$18,E$38)","v":5716419.7036000844},{"$f":"INDEX(Prop2021DistTar!$G$14:$G$18,F$38)","v":3447043.2105103824},{"$f":"INDEX(Prop2021DistTar!$G$14:$G$18,G$38)","v":4895117.7167962752}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B174","v":"Existing : Tariff V - AGN Central - Non Residential"},{"$f":"SUM(C174:G174)","v":17712877.322113372}]
[null,{"$f":"B176","v":"Proposed : Tariff V - AGN Central - Non Residential"},{"$f":"SUM(C176:G176)","v":17702665.245975576}]
[]
[null,"Average price movement",{"$f":"IF(C180=0,\"\",C180/C179)","v":0.99942346599301246}]
[]
[null,{"$f":"IF(C182=\"\",\"\",IF(C182<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!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 : \"&Prop2021DistTar!C25","v":"Existing : Tariff V - AGN North - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$E$27:$E$31,C$39)","v":0.19309999999999999},{"$f":"INDEX(Prop2021DistTar!$E$27:$E$31,D$39)","v":7.5303000000000004},{"$f":"INDEX(Prop2021DistTar!$E$27:$E$31,E$39)","v":3.5809000000000002},{"$f":"INDEX(Prop2021DistTar!$E$27:$E$31,F$39)","v":2.6707000000000001},{"$f":"INDEX(Prop2021DistTar!$E$27:$E$31,G$39)","v":1.0790999999999999}]
[]
[null,{"$f":"\"Proposed : \"&B188","v":"Proposed : Tariff V - AGN North - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$D$27:$D$31,C$38)","v":0.193},{"$f":"INDEX(Prop2021DistTar!$D$27:$D$31,D$38)","v":7.5259},{"$f":"INDEX(Prop2021DistTar!$D$27:$D$31,E$38)","v":3.5788000000000002},{"$f":"INDEX(Prop2021DistTar!$D$27:$D$31,F$38)","v":2.6690999999999998},{"$f":"INDEX(Prop2021DistTar!$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(Prop2021DistTar!$F$27:$F$31,C$38)","v":1197219},{"$f":"INDEX(Prop2021DistTar!$F$27:$F$31,D$38)","v":37630.697013927864},{"$f":"INDEX(Prop2021DistTar!$F$27:$F$31,E$38)","v":184739.00299572418},{"$f":"INDEX(Prop2021DistTar!$F$27:$F$31,F$38)","v":127263.14566871065},{"$f":"INDEX(Prop2021DistTar!$F$27:$F$31,G$38)","v":496073.4155062486}]
[]
[null,{"$f":"B194","v":"Proposed : Tariff V - AGN North - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$F$27:$F$31,C$38)","v":1197219},{"$f":"INDEX(Prop2021DistTar!$F$27:$F$31,D$38)","v":37630.697013927864},{"$f":"INDEX(Prop2021DistTar!$F$27:$F$31,E$38)","v":184739.00299572418},{"$f":"INDEX(Prop2021DistTar!$F$27:$F$31,F$38)","v":127263.14566871065},{"$f":"INDEX(Prop2021DistTar!$F$27:$F$31,G$38)","v":496073.4155062486}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B198","v":"Existing : Tariff V - AGN North - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$H$27:$H$31,C$39)","v":231182.9889},{"$f":"INDEX(Prop2021DistTar!$H$27:$H$31,D$39)","v":283370.43772398098},{"$f":"INDEX(Prop2021DistTar!$H$27:$H$31,E$39)","v":661531.89582738874},{"$f":"INDEX(Prop2021DistTar!$H$27:$H$31,F$39)","v":339881.68313742557},{"$f":"INDEX(Prop2021DistTar!$H$27:$H$31,G$39)","v":535312.82267279283}]
[]
[null,{"$f":"B200","v":"Proposed : Tariff V - AGN North - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$G$27:$G$31,C$38)","v":231063.26699999999},{"$f":"INDEX(Prop2021DistTar!$G$27:$G$31,D$38)","v":283204.86265711969},{"$f":"INDEX(Prop2021DistTar!$G$27:$G$31,E$38)","v":661143.94392109767},{"$f":"INDEX(Prop2021DistTar!$G$27:$G$31,F$38)","v":339678.0621043556},{"$f":"INDEX(Prop2021DistTar!$G$27:$G$31,G$38)","v":535015.1786234891}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B204","v":"Existing : Tariff V - AGN North - Non Residential"},{"$f":"SUM(C204:G204)","v":2051279.8282615882}]
[null,{"$f":"B206","v":"Proposed : Tariff V - AGN North - Non Residential"},{"$f":"SUM(C206:G206)","v":2050105.3143060619}]
[]
[null,"Average price movement",{"$f":"IF(C210=0,\"\",C210/C209)","v":0.99942742382616723}]
[]
[null,{"$f":"IF(C212=\"\",\"\",IF(C212<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!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 : \"&Prop2021DistTar!C38","v":"Existing : Tariff V - Murray Valley - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$E$40:$E$44,C$39)","v":0.24579999999999999},{"$f":"INDEX(Prop2021DistTar!$E$40:$E$44,D$39)","v":6.7329999999999997},{"$f":"INDEX(Prop2021DistTar!$E$40:$E$44,E$39)","v":3.9767000000000001},{"$f":"INDEX(Prop2021DistTar!$E$40:$E$44,F$39)","v":2.9678},{"$f":"INDEX(Prop2021DistTar!$E$40:$E$44,G$39)","v":1.3434999999999999}]
[]
[null,{"$f":"\"Proposed : \"&B218","v":"Proposed : Tariff V - Murray Valley - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$D$40:$D$44,C$38)","v":0.2457},{"$f":"INDEX(Prop2021DistTar!$D$40:$D$44,D$38)","v":6.7290999999999999},{"$f":"INDEX(Prop2021DistTar!$D$40:$D$44,E$38)","v":3.9744000000000002},{"$f":"INDEX(Prop2021DistTar!$D$40:$D$44,F$38)","v":2.9661},{"$f":"INDEX(Prop2021DistTar!$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(Prop2021DistTar!$F$40:$F$44,C$38)","v":130312},{"$f":"INDEX(Prop2021DistTar!$F$40:$F$44,D$38)","v":4406.9050896670024},{"$f":"INDEX(Prop2021DistTar!$F$40:$F$44,E$38)","v":20671.549759732974},{"$f":"INDEX(Prop2021DistTar!$F$40:$F$44,F$38)","v":12808.446194453998},{"$f":"INDEX(Prop2021DistTar!$F$40:$F$44,G$38)","v":28696.127148841006}]
[]
[null,{"$f":"B224","v":"Proposed : Tariff V - Murray Valley - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$F$40:$F$44,C$38)","v":130312},{"$f":"INDEX(Prop2021DistTar!$F$40:$F$44,D$38)","v":4406.9050896670024},{"$f":"INDEX(Prop2021DistTar!$F$40:$F$44,E$38)","v":20671.549759732974},{"$f":"INDEX(Prop2021DistTar!$F$40:$F$44,F$38)","v":12808.446194453998},{"$f":"INDEX(Prop2021DistTar!$F$40:$F$44,G$38)","v":28696.127148841006}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B228","v":"Existing : Tariff V - Murray Valley - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$H$40:$H$44,C$39)","v":32030.689599999998},{"$f":"INDEX(Prop2021DistTar!$H$40:$H$44,D$39)","v":29671.691968727926},{"$f":"INDEX(Prop2021DistTar!$H$40:$H$44,E$39)","v":82204.55192953012},{"$f":"INDEX(Prop2021DistTar!$H$40:$H$44,F$39)","v":38012.906615900574},{"$f":"INDEX(Prop2021DistTar!$H$40:$H$44,G$39)","v":38553.246824467889}]
[]
[null,{"$f":"B230","v":"Proposed : Tariff V - Murray Valley - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$G$40:$G$44,C$38)","v":32017.6584},{"$f":"INDEX(Prop2021DistTar!$G$40:$G$44,D$38)","v":29654.505038878226},{"$f":"INDEX(Prop2021DistTar!$G$40:$G$44,E$38)","v":82157.00736508274},{"$f":"INDEX(Prop2021DistTar!$G$40:$G$44,F$38)","v":37991.132257370002},{"$f":"INDEX(Prop2021DistTar!$G$40:$G$44,G$38)","v":38530.289922748816}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B234","v":"Existing : Tariff V - Murray Valley - Non Residential"},{"$f":"SUM(C234:G234)","v":220473.08693862654}]
[null,{"$f":"B236","v":"Proposed : Tariff V - Murray Valley - Non Residential"},{"$f":"SUM(C236:G236)","v":220350.59298407979}]
[]
[null,"Average price movement",{"$f":"IF(C240=0,\"\",C240/C239)","v":0.99944440404836876}]
[]
[null,{"$f":"IF(C242=\"\",\"\",IF(C242<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!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 : \"&Prop2021DistTar!C51","v":"Existing : Tariff V - Bairnsdale - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$E$53:$E$57,C$39)","v":0.31780000000000003},{"$f":"INDEX(Prop2021DistTar!$E$53:$E$57,D$39)","v":13.804500000000001},{"$f":"INDEX(Prop2021DistTar!$E$53:$E$57,E$39)","v":6.73},{"$f":"INDEX(Prop2021DistTar!$E$53:$E$57,F$39)","v":5.0178000000000003},{"$f":"INDEX(Prop2021DistTar!$E$53:$E$57,G$39)","v":2.0266999999999999}]
[]
[null,{"$f":"\"Proposed : \"&B248","v":"Proposed : Tariff V - Bairnsdale - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$D$53:$D$57,C$38)","v":0.31759999999999999},{"$f":"INDEX(Prop2021DistTar!$D$53:$D$57,D$38)","v":13.7965},{"$f":"INDEX(Prop2021DistTar!$D$53:$D$57,E$38)","v":6.7260999999999997},{"$f":"INDEX(Prop2021DistTar!$D$53:$D$57,F$38)","v":5.0148999999999999},{"$f":"INDEX(Prop2021DistTar!$D$53:$D$57,G$38)","v":2.0256000000000003}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B252","v":"Existing : Tariff V - Bairnsdale - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$F$53:$F$57,C$38)","v":43459},{"$f":"INDEX(Prop2021DistTar!$F$53:$F$57,D$38)","v":1792.2717191360005},{"$f":"INDEX(Prop2021DistTar!$F$53:$F$57,E$38)","v":13124.727761945993},{"$f":"INDEX(Prop2021DistTar!$F$53:$F$57,F$38)","v":10214.248610588005},{"$f":"INDEX(Prop2021DistTar!$F$53:$F$57,G$38)","v":41020.008440777019}]
[]
[null,{"$f":"B254","v":"Proposed : Tariff V - Bairnsdale - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$F$53:$F$57,C$38)","v":43459},{"$f":"INDEX(Prop2021DistTar!$F$53:$F$57,D$38)","v":1792.2717191360005},{"$f":"INDEX(Prop2021DistTar!$F$53:$F$57,E$38)","v":13124.727761945993},{"$f":"INDEX(Prop2021DistTar!$F$53:$F$57,F$38)","v":10214.248610588005},{"$f":"INDEX(Prop2021DistTar!$F$53:$F$57,G$38)","v":41020.008440777019}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B258","v":"Existing : Tariff V - Bairnsdale - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$H$53:$H$57,C$39)","v":13811.270200000001},{"$f":"INDEX(Prop2021DistTar!$H$53:$H$57,D$39)","v":24741.414946812918},{"$f":"INDEX(Prop2021DistTar!$H$53:$H$57,E$39)","v":88329.417837896544},{"$f":"INDEX(Prop2021DistTar!$H$53:$H$57,F$39)","v":51253.056678208493},{"$f":"INDEX(Prop2021DistTar!$H$53:$H$57,G$39)","v":83135.251106922777}]
[]
[null,{"$f":"B260","v":"Proposed : Tariff V - Bairnsdale - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$G$53:$G$57,C$38)","v":13802.5784},{"$f":"INDEX(Prop2021DistTar!$G$53:$G$57,D$38)","v":24727.076773059831},{"$f":"INDEX(Prop2021DistTar!$G$53:$G$57,E$38)","v":88278.231399624943},{"$f":"INDEX(Prop2021DistTar!$G$53:$G$57,F$38)","v":51223.435357237788},{"$f":"INDEX(Prop2021DistTar!$G$53:$G$57,G$38)","v":83090.129097637939}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B264","v":"Existing : Tariff V - Bairnsdale - Non Residential"},{"$f":"SUM(C264:G264)","v":261270.41076984073}]
[null,{"$f":"B266","v":"Proposed : Tariff V - Bairnsdale - Non Residential"},{"$f":"SUM(C266:G266)","v":261121.45102756051}]
[]
[null,"Average price movement",{"$f":"IF(C270=0,\"\",C270/C269)","v":0.99942986371154197}]
[]
[null,{"$f":"IF(C272=\"\",\"\",IF(C272<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!B59","v":"Tariff D -  AGN Central"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2021DistTar!C59","v":"Existing: Tariff D -  AGN Central"},{"$f":"INDEX(Prop2021DistTar!$E$60:$E$62,C279)","v":1461.0057999999999},{"$f":"INDEX(Prop2021DistTar!$E$60:$E$62,D279)","v":893.16539999999998},{"$f":"INDEX(Prop2021DistTar!$E$60:$E$62,E279)","v":163.1104}]
[null,{"$f":"\"Proposed: \"&B278","v":"Proposed: Tariff D -  AGN Central"},{"$f":"INDEX(Prop2021DistTar!$D$60:$D$62,C279)","v":1460.155},{"$f":"INDEX(Prop2021DistTar!$D$60:$D$62,D279)","v":892.64530000000002},{"$f":"INDEX(Prop2021DistTar!$D$60:$D$62,E279)","v":163.0154}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B281","v":"Existing: Tariff D -  AGN Central"},{"$f":"INDEX(Prop2021DistTar!$F$60:$F$62,C$38)","v":1429.1395999999995},{"$f":"INDEX(Prop2021DistTar!$F$60:$F$62,D$38)","v":1224.1337999999998},{"$f":"INDEX(Prop2021DistTar!$F$60:$F$62,E$38)","v":1251.7936999999999}]
[null,{"$f":"B282","v":"Proposed: Tariff D -  AGN Central"},{"$f":"INDEX(Prop2021DistTar!$F$60:$F$62,C$38)","v":1429.1395999999995},{"$f":"INDEX(Prop2021DistTar!$F$60:$F$62,D$38)","v":1224.1337999999998},{"$f":"INDEX(Prop2021DistTar!$F$60:$F$62,E$38)","v":1251.7936999999999}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B285","v":"Existing: Tariff D -  AGN Central"},{"$f":"INDEX(Prop2021DistTar!$H$60:$H$62,C279)","v":2087981.2446096791},{"$f":"INDEX(Prop2021DistTar!$H$60:$H$62,D279)","v":1093353.9551305198},{"$f":"INDEX(Prop2021DistTar!$H$60:$H$62,E279)","v":204180.57112447999}]
[null,{"$f":"B286","v":"Proposed: Tariff D -  AGN Central"},{"$f":"INDEX(Prop2021DistTar!$G$60:$G$62,C279)","v":2086765.3326379992},{"$f":"INDEX(Prop2021DistTar!$G$60:$G$62,D279)","v":1092717.2831411399},{"$f":"INDEX(Prop2021DistTar!$G$60:$G$62,E279)","v":204061.65072298}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B289","v":"Existing: Tariff D -  AGN Central"},{"$f":"SUM(C289:E289)","v":3385515.770864679}]
[null,{"$f":"B290","v":"Proposed: Tariff D -  AGN Central"},{"$f":"SUM(C290:E290)","v":3383544.2665021191}]
[]
[null,"Average price movement",{"$f":"IF(C294=0,\"\",C294/C293)","v":0.99941766498932705}]
[]
[null,{"$f":"IF(C296=\"\",\"\",IF(C296<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!B64","v":"Tariff D - AGN North"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2021DistTar!C64","v":"Existing: Tariff D - AGN North"},{"$f":"INDEX(Prop2021DistTar!$E$65:$E$67,C303)","v":1461.0057999999999},{"$f":"INDEX(Prop2021DistTar!$E$65:$E$67,D303)","v":893.16539999999998},{"$f":"INDEX(Prop2021DistTar!$E$65:$E$67,E303)","v":163.1104}]
[null,{"$f":"\"Proposed: \"&B302","v":"Proposed: Tariff D - AGN North"},{"$f":"INDEX(Prop2021DistTar!$D$65:$D$67,C303)","v":1460.155},{"$f":"INDEX(Prop2021DistTar!$D$65:$D$67,D303)","v":892.64530000000002},{"$f":"INDEX(Prop2021DistTar!$D$65:$D$67,E303)","v":163.0154}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B305","v":"Existing: Tariff D - AGN North"},{"$f":"INDEX(Prop2021DistTar!$F$65:$F$67,C$38)","v":429.69869999999997},{"$f":"INDEX(Prop2021DistTar!$F$65:$F$67,D$38)","v":600.40189999999996},{"$f":"INDEX(Prop2021DistTar!$F$65:$F$67,E$38)","v":438.6123}]
[null,{"$f":"B306","v":"Proposed: Tariff D - AGN North"},{"$f":"INDEX(Prop2021DistTar!$F$65:$F$67,C$38)","v":429.69869999999997},{"$f":"INDEX(Prop2021DistTar!$F$65:$F$67,D$38)","v":600.40189999999996},{"$f":"INDEX(Prop2021DistTar!$F$65:$F$67,E$38)","v":438.6123}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B309","v":"Existing: Tariff D - AGN North"},{"$f":"INDEX(Prop2021DistTar!$H$65:$H$67,C303)","v":627792.29295245989},{"$f":"INDEX(Prop2021DistTar!$H$65:$H$67,D303)","v":536258.20317425998},{"$f":"INDEX(Prop2021DistTar!$H$65:$H$67,E303)","v":71542.227697919996}]
[null,{"$f":"B310","v":"Proposed: Tariff D - AGN North"},{"$f":"INDEX(Prop2021DistTar!$G$65:$G$67,C303)","v":627426.7052984999},{"$f":"INDEX(Prop2021DistTar!$G$65:$G$67,D303)","v":535945.93414606992},{"$f":"INDEX(Prop2021DistTar!$G$65:$G$67,E303)","v":71500.559529420003}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B313","v":"Existing: Tariff D - AGN North"},{"$f":"SUM(C313:E313)","v":1235592.7238246398}]
[null,{"$f":"B314","v":"Proposed: Tariff D - AGN North"},{"$f":"SUM(C314:E314)","v":1234873.1989739898}]
[]
[null,"Average price movement",{"$f":"IF(C318=0,\"\",C318/C317)","v":0.99941766826821155}]
[]
[null,{"$f":"IF(C320=\"\",\"\",IF(C320<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!B69","v":"Tariff D - Murray Valley"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2021DistTar!C69","v":"Existing: Tariff D - Murray Valley"},{"$f":"INDEX(Prop2021DistTar!$E$70:$E$72,C327)","v":1702.9776999999999},{"$f":"INDEX(Prop2021DistTar!$E$70:$E$72,D327)","v":1050.8447000000001},{"$f":"INDEX(Prop2021DistTar!$E$70:$E$72,E327)","v":178.97739999999999}]
[null,{"$f":"\"Proposed: \"&B326","v":"Proposed: Tariff D - Murray Valley"},{"$f":"INDEX(Prop2021DistTar!$D$70:$D$72,C327)","v":1701.9860000000001},{"$f":"INDEX(Prop2021DistTar!$D$70:$D$72,D327)","v":1050.2328},{"$f":"INDEX(Prop2021DistTar!$D$70:$D$72,E327)","v":178.8732}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B329","v":"Existing: Tariff D - Murray Valley"},{"$f":"INDEX(Prop2021DistTar!$F$70:$F$72,C$38)","v":68.440300000000008},{"$f":"INDEX(Prop2021DistTar!$F$70:$F$72,D$38)","v":160.83710000000002},{"$f":"INDEX(Prop2021DistTar!$F$70:$F$72,E$38)","v":78.773099999999999}]
[null,{"$f":"B330","v":"Proposed: Tariff D - Murray Valley"},{"$f":"INDEX(Prop2021DistTar!$F$70:$F$72,C$38)","v":68.440300000000008},{"$f":"INDEX(Prop2021DistTar!$F$70:$F$72,D$38)","v":160.83710000000002},{"$f":"INDEX(Prop2021DistTar!$F$70:$F$72,E$38)","v":78.773099999999999}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B333","v":"Existing: Tariff D - Murray Valley"},{"$f":"INDEX(Prop2021DistTar!$H$70:$H$72,C327)","v":116552.30468131001},{"$f":"INDEX(Prop2021DistTar!$H$70:$H$72,D327)","v":169014.81409837003},{"$f":"INDEX(Prop2021DistTar!$H$70:$H$72,E327)","v":14098.60462794}]
[null,{"$f":"B334","v":"Proposed: Tariff D - Murray Valley"},{"$f":"INDEX(Prop2021DistTar!$G$70:$G$72,C327)","v":116484.43243580002},{"$f":"INDEX(Prop2021DistTar!$G$70:$G$72,D327)","v":168916.39787688002},{"$f":"INDEX(Prop2021DistTar!$G$70:$G$72,E327)","v":14090.396470919999}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B337","v":"Existing: Tariff D - Murray Valley"},{"$f":"SUM(C337:E337)","v":299665.72340762004}]
[null,{"$f":"B338","v":"Proposed: Tariff D - Murray Valley"},{"$f":"SUM(C338:E338)","v":299491.22678360005}]
[]
[null,"Average price movement",{"$f":"IF(C342=0,\"\",C342/C341)","v":0.99941769575099981}]
[]
[null,{"$f":"IF(C344=\"\",\"\",IF(C344<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!B74","v":"Tariff D - Bairnsdale"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2021DistTar!C74","v":"Existing: Tariff D - Bairnsdale"},{"$f":"INDEX(Prop2021DistTar!$E$75:$E$77,C351)","v":2416.6995999999999},{"$f":"INDEX(Prop2021DistTar!$E$75:$E$77,D351)","v":1497.1554000000001},{"$f":"INDEX(Prop2021DistTar!$E$75:$E$77,E351)","v":273.0471}]
[null,{"$f":"\"Proposed: \"&B350","v":"Proposed: Tariff D - Bairnsdale"},{"$f":"INDEX(Prop2021DistTar!$D$75:$D$77,C351)","v":2415.2923000000001},{"$f":"INDEX(Prop2021DistTar!$D$75:$D$77,D351)","v":1496.2836},{"$f":"INDEX(Prop2021DistTar!$D$75:$D$77,E351)","v":272.88810000000001}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B353","v":"Existing: Tariff D - Bairnsdale"},{"$f":"INDEX(Prop2021DistTar!$F$75:$F$77,C$38)","v":16.009700000000002},{"$f":"INDEX(Prop2021DistTar!$F$75:$F$77,D$38)","v":2.7294},{"$f":"INDEX(Prop2021DistTar!$F$75:$F$77,E$38)","v":0}]
[null,{"$f":"B354","v":"Proposed: Tariff D - Bairnsdale"},{"$f":"INDEX(Prop2021DistTar!$F$75:$F$77,C$38)","v":16.009700000000002},{"$f":"INDEX(Prop2021DistTar!$F$75:$F$77,D$38)","v":2.7294},{"$f":"INDEX(Prop2021DistTar!$F$75:$F$77,E$38)","v":0}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B357","v":"Existing: Tariff D - Bairnsdale"},{"$f":"INDEX(Prop2021DistTar!$H$75:$H$77,C351)","v":38690.635586120006},{"$f":"INDEX(Prop2021DistTar!$H$75:$H$77,D351)","v":4086.3359487600005},{"$f":"INDEX(Prop2021DistTar!$H$75:$H$77,E351)","v":0}]
[null,{"$f":"B358","v":"Proposed: Tariff D - Bairnsdale"},{"$f":"INDEX(Prop2021DistTar!$G$75:$G$77,C351)","v":38668.105135310005},{"$f":"INDEX(Prop2021DistTar!$G$75:$G$77,D351)","v":4083.95645784},{"$f":"INDEX(Prop2021DistTar!$G$75:$G$77,E351)","v":0}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B361","v":"Existing: Tariff D - Bairnsdale"},{"$f":"SUM(C361:E361)","v":42776.971534880009}]
[null,{"$f":"B362","v":"Proposed: Tariff D - Bairnsdale"},{"$f":"SUM(C362:E362)","v":42752.061593150007}]
[]
[null,"Average price movement",{"$f":"IF(C366=0,\"\",C366/C365)","v":0.9994176786986968}]
[]
[null,{"$f":"IF(C368=\"\",\"\",IF(C368<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!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 : \"&Prop2021DistTar!C79","v":"Existing : Tariff V - Albury - Residential"},{"$f":"INDEX(Prop2021DistTar!$E$81:$E$84,C$39)","v":0.25119999999999998},{"$f":"INDEX(Prop2021DistTar!$E$81:$E$84,D$39)","v":8.6120000000000001},{"$f":"INDEX(Prop2021DistTar!$E$81:$E$84,E$39)","v":5.1475999999999997},{"$f":"INDEX(Prop2021DistTar!$E$81:$E$84,F$39)","v":2.8267000000000002}]
[]
[null,{"$f":"\"Proposed : \"&B374","v":"Proposed : Tariff V - Albury - Residential"},{"$f":"INDEX(Prop2021DistTar!$D$81:$D$84,C$38)","v":0.25109999999999999},{"$f":"INDEX(Prop2021DistTar!$D$81:$D$84,D$38)","v":8.6069999999999993},{"$f":"INDEX(Prop2021DistTar!$D$81:$D$84,E$38)","v":5.1445999999999996},{"$f":"INDEX(Prop2021DistTar!$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(Prop2021DistTar!$F$81:$F$84,C$38)","v":8209588},{"$f":"INDEX(Prop2021DistTar!$F$81:$F$84,D$38)","v":186859.48234335432},{"$f":"INDEX(Prop2021DistTar!$F$81:$F$84,E$38)","v":110413.06763127322},{"$f":"INDEX(Prop2021DistTar!$F$81:$F$84,F$38)","v":710587.82733224751}]
[]
[null,{"$f":"B380","v":"Proposed : Tariff V - Albury - Residential"},{"$f":"INDEX(Prop2021DistTar!$F$81:$F$84,C$38)","v":8209588},{"$f":"INDEX(Prop2021DistTar!$F$81:$F$84,D$38)","v":186859.48234335432},{"$f":"INDEX(Prop2021DistTar!$F$81:$F$84,E$38)","v":110413.06763127322},{"$f":"INDEX(Prop2021DistTar!$F$81:$F$84,F$38)","v":710587.82733224751}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B384","v":"Existing : Tariff V - Albury - Residential"},{"$f":"INDEX(Prop2021DistTar!$H$81:$H$84,C$39)","v":2062248.5055999998},{"$f":"INDEX(Prop2021DistTar!$H$81:$H$84,D$39)","v":1609233.8619409674},{"$f":"INDEX(Prop2021DistTar!$H$81:$H$84,E$39)","v":568362.30693874205},{"$f":"INDEX(Prop2021DistTar!$H$81:$H$84,F$39)","v":2008618.6115200643}]
[]
[null,{"$f":"B386","v":"Proposed : Tariff V - Albury - Residential"},{"$f":"INDEX(Prop2021DistTar!$G$81:$G$84,C$38)","v":2061427.5467999999},{"$f":"INDEX(Prop2021DistTar!$G$81:$G$84,D$38)","v":1608299.5645292506},{"$f":"INDEX(Prop2021DistTar!$G$81:$G$84,E$38)","v":568031.06773584813},{"$f":"INDEX(Prop2021DistTar!$G$81:$G$84,F$38)","v":2007481.6709963323}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B390","v":"Existing : Tariff V - Albury - Residential"},{"$f":"SUM(C390:G390)","v":6248463.2859997731}]
[null,{"$f":"B392","v":"Proposed : Tariff V - Albury - Residential"},{"$f":"SUM(C392:G392)","v":6245239.8500614315}]
[]
[null,"Average price movement",{"$f":"IF(C396=0,\"\",C396/C395)","v":0.99948412340910064}]
[]
[null,{"$f":"IF(C398=\"\",\"\",IF(C398<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!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 : \"&Prop2021DistTar!C85","v":"Existing : Tariff V - Albury - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$E$87:$E$91,C$39)","v":0.25119999999999998},{"$f":"INDEX(Prop2021DistTar!$E$87:$E$91,D$39)","v":6.3207000000000004},{"$f":"INDEX(Prop2021DistTar!$E$87:$E$91,E$39)","v":3.121},{"$f":"INDEX(Prop2021DistTar!$E$87:$E$91,F$39)","v":2.2162999999999999},{"$f":"INDEX(Prop2021DistTar!$E$87:$E$91,G$39)","v":0.89490000000000003}]
[]
[null,{"$f":"\"Proposed : \"&B404","v":"Proposed : Tariff V - Albury - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$D$87:$D$91,C$38)","v":0.25109999999999999},{"$f":"INDEX(Prop2021DistTar!$D$87:$D$91,D$38)","v":6.3170000000000002},{"$f":"INDEX(Prop2021DistTar!$D$87:$D$91,E$38)","v":3.1192000000000002},{"$f":"INDEX(Prop2021DistTar!$D$87:$D$91,F$38)","v":2.2149999999999999},{"$f":"INDEX(Prop2021DistTar!$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(Prop2021DistTar!$F$87:$F$91,C$38)","v":338182},{"$f":"INDEX(Prop2021DistTar!$F$87:$F$91,D$38)","v":11076.581779452994},{"$f":"INDEX(Prop2021DistTar!$F$87:$F$91,E$38)","v":57113.873612594893},{"$f":"INDEX(Prop2021DistTar!$F$87:$F$91,F$38)","v":41149.016723229011},{"$f":"INDEX(Prop2021DistTar!$F$87:$F$91,G$38)","v":171447.0921728932}]
[]
[null,{"$f":"B410","v":"Proposed : Tariff V - Albury - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$F$87:$F$91,C$38)","v":338182},{"$f":"INDEX(Prop2021DistTar!$F$87:$F$91,D$38)","v":11076.581779452994},{"$f":"INDEX(Prop2021DistTar!$F$87:$F$91,E$38)","v":57113.873612594893},{"$f":"INDEX(Prop2021DistTar!$F$87:$F$91,F$38)","v":41149.016723229011},{"$f":"INDEX(Prop2021DistTar!$F$87:$F$91,G$38)","v":171447.0921728932}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B414","v":"Existing : Tariff V - Albury - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$H$87:$H$91,C$39)","v":84951.318399999989},{"$f":"INDEX(Prop2021DistTar!$H$87:$H$91,D$39)","v":70011.750453388537},{"$f":"INDEX(Prop2021DistTar!$H$87:$H$91,E$39)","v":178252.39954490867},{"$f":"INDEX(Prop2021DistTar!$H$87:$H$91,F$39)","v":91198.565763692459},{"$f":"INDEX(Prop2021DistTar!$H$87:$H$91,G$39)","v":153428.00278552214}]
[]
[null,{"$f":"B416","v":"Proposed : Tariff V - Albury - Non Residential"},{"$f":"INDEX(Prop2021DistTar!$G$87:$G$91,C$38)","v":84917.500199999995},{"$f":"INDEX(Prop2021DistTar!$G$87:$G$91,D$38)","v":69970.767100804558},{"$f":"INDEX(Prop2021DistTar!$G$87:$G$91,E$38)","v":178149.594572406},{"$f":"INDEX(Prop2021DistTar!$G$87:$G$91,F$38)","v":91145.072041952255},{"$f":"INDEX(Prop2021DistTar!$G$87:$G$91,G$38)","v":153342.27923943568}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B420","v":"Existing : Tariff V - Albury - Non Residential"},{"$f":"SUM(C420:G420)","v":577842.03694751184}]
[null,{"$f":"B422","v":"Proposed : Tariff V - Albury - Non Residential"},{"$f":"SUM(C422:G422)","v":577525.21315459849}]
[]
[null,"Average price movement",{"$f":"IF(C426=0,\"\",C426/C425)","v":0.99945171210701977}]
[]
[null,{"$f":"IF(C428=\"\",\"\",IF(C428<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2021DistTar!B93","v":"Tariff D - Albury"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2021DistTar!C93","v":"Existing: Tariff D - Albury"},{"$f":"INDEX(Prop2021DistTar!$E$94:$E$96,C435)","v":1256.4656},{"$f":"INDEX(Prop2021DistTar!$E$94:$E$96,D435)","v":780.38049999999998},{"$f":"INDEX(Prop2021DistTar!$E$94:$E$96,E435)","v":188.63499999999999}]
[null,{"$f":"\"Proposed: \"&B434","v":"Proposed: Tariff D - Albury"},{"$f":"INDEX(Prop2021DistTar!$D$94:$D$96,C435)","v":1255.7338999999999},{"$f":"INDEX(Prop2021DistTar!$D$94:$D$96,D435)","v":779.92610000000002},{"$f":"INDEX(Prop2021DistTar!$D$94:$D$96,E435)","v":188.52520000000001}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B437","v":"Existing: Tariff D - Albury"},{"$f":"INDEX(Prop2021DistTar!$F$94:$F$96,C$38)","v":49.456200000000003},{"$f":"INDEX(Prop2021DistTar!$F$94:$F$96,D$38)","v":106.018},{"$f":"INDEX(Prop2021DistTar!$F$94:$F$96,E$38)","v":188.90899999999999}]
[null,{"$f":"B438","v":"Proposed: Tariff D - Albury"},{"$f":"INDEX(Prop2021DistTar!$F$94:$F$96,C$38)","v":49.456200000000003},{"$f":"INDEX(Prop2021DistTar!$F$94:$F$96,D$38)","v":106.018},{"$f":"INDEX(Prop2021DistTar!$F$94:$F$96,E$38)","v":188.90899999999999}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B441","v":"Existing: Tariff D - Albury"},{"$f":"INDEX(Prop2021DistTar!$H$94:$H$96,C435)","v":62140.014006720005},{"$f":"INDEX(Prop2021DistTar!$H$94:$H$96,D435)","v":82734.379849000004},{"$f":"INDEX(Prop2021DistTar!$H$94:$H$96,E435)","v":35634.849214999995}]
[null,{"$f":"B442","v":"Proposed: Tariff D - Albury"},{"$f":"INDEX(Prop2021DistTar!$G$94:$G$96,C435)","v":62103.826905180002},{"$f":"INDEX(Prop2021DistTar!$G$94:$G$96,D435)","v":82686.205269800004},{"$f":"INDEX(Prop2021DistTar!$G$94:$G$96,E435)","v":35614.107006799997}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B445","v":"Existing: Tariff D - Albury"},{"$f":"SUM(C445:E445)","v":180509.24307072}]
[null,{"$f":"B446","v":"Proposed: Tariff D - Albury"},{"$f":"SUM(C446:E446)","v":180404.13918177999}]
[]
[null,"Average price movement",{"$f":"IF(C450=0,\"\",C450/C449)","v":0.99941773680310197}]
[]
[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":2020},{"$f":"'Model update'!$B$5","v":2021}]
["Meter and Gas Installation Test ",221,{"$f":"ROUND(B6*(1+'Model update'!$B$30),0)","v":220}]
["Disconnection",73,{"$f":"ROUND(B7*(1+'Model update'!$B$30),0)","v":73}]
["Reconnection",85,{"$f":"ROUND(B8*(1+'Model update'!$B$30),0)","v":85}]
["Meter Removal",104,{"$f":"ROUND(B9*(1+'Model update'!$B$30),0)","v":104}]
["Meter Reinstallation",104,{"$f":"ROUND(B10*(1+'Model update'!$B$30),0)","v":104}]
["Special Meter Read - Metropolitan",9.3000000000000007,{"$f":"ROUND(B11*(1+'Model update'!$B$30),1)","v":9.3000000000000007}]
["Special Meter Read - Non Metropolitan",12.8,{"$f":"ROUND(B12*(1+'Model update'!$B$30),1)","v":12.8}]
[]
[{"$f":"\"Note: \"&'Model update'!$B$5&\" formula is as per AA2018-22, Section 4.4.2, p9 : ART = ARTt-1 * (1+CPI)\"","v":"Note: 2021 formula is as per AA2018-22, Section 4.4.2, p9 : ART = ARTt-1 * (1+CPI)"}]