{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["NOTES","Model update","Prop2020DistTar","2020TarContForm","2020RebalContForm","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":2020}]
[]
["Issue","Location","Item","Comment"]
[]
[1,"'Model update'!C25","CPI",{"$f":"\"Updated June \"&D2-1&\" CPI for \"&D2","v":"Updated June 2019 CPI for 2020"},"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'!B34",{"$f":"\"Xt for \"&D2","v":"Xt for 2020"},{"$f":"\"Updated \"&$D$2&\" value\"","v":"Updated 2020 value"}]
[]
[{"$f":"A8+1","v":3},"'Model update'!B44",{"$f":"\"Pass Through Amount for \"&D2","v":"Pass Through Amount for 2020"},"NIL for 2020"]
[]
[{"$f":"A10+1","v":4},"'Model update'!H79:H83","Real Pre-tax WACC (rptw)",{"$f":"\"Updated \"&$D$2&\" value\"","v":"Updated 2020 value"}]
[]
[{"$f":"A12+1","v":5},{"$f":"\"Prop\"&D2&\"DistTar!E8:E96\"","v":"Prop2020DistTar!E8:E96"},{"$f":"D2-1&\" tariffs\"","v":"2019 tariffs"},{"$f":"\"Updated from \"&D2-1&\" model\"","v":"Updated from 2019 model"}]
[]
[{"$f":"A14+1","v":6},"ARS!B6:B12",{"$f":"D2-1&\" ARS tariffs\"","v":"2019 ARS tariffs"},{"$f":"\"Updated from \"&D2-1&\" model\"","v":"Updated from 2019 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":"Prop2020DistTar!D8:D96"},{"$f":"\"Proposed \"&D2&\" Tariffs\"","v":"Proposed 2020 Tariffs"}]
[null,{"$f":"\"Prop\"&D2&\"DistTar!F8:F96\"","v":"Prop2020DistTar!F8:F96"},{"$f":"\"Actual \"&D2-2&\" Volumes\"","v":"Actual 2018 Volumes"}]
[]
[null,"ARS!C6:C12",{"$f":"\"Proposed \"&D2&\" Ancillary Reference Services Charges\"","v":"Proposed 2020 Ancillary Reference Services Charges"}]

{"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",2020]
[]
["t",{"$f":"B5","v":2020}]
["t-1",{"$f":"B7-1","v":2019}]
["t-2",2018]
["t-3",2017]
[]
[]
["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"]
["CPI Index June 2021"]
[]
[]
[{"$f":"\"CPI Index June \" &$B$10","v":"CPI Index June 2017"},{"$f":"VLOOKUP(A25,A$17:B$22,2,FALSE)","v":110.7}]
[{"$f":"\"CPI Index June \" &$B$9","v":"CPI Index June 2018"},{"$f":"VLOOKUP(A26,A$17:B$22,2,FALSE)","v":113}]
[{"$f":"\"CPI Index June \" &$B$8","v":"CPI Index June 2019"},{"$f":"VLOOKUP(A27,A$17:B$22,2,FALSE)","v":114.8}]
[]
[{"$f":"\"CPI \" &$B$8","v":"CPI 2019"},{"$f":"B26/B25-1","v":2.0776874435411097E-2}]
[{"$f":"\"CPI \" &$B$5","v":"CPI 2020"},{"$f":"B27/B26-1","v":1.5929203539823078E-2}]
[]
[]
[{"$f":"\"Xt for \"&B$5","v":"Xt for 2020"}]
[2019,-1.2932003198752063E-2]
[2020,-5.9643805428307873E-3]
[2021,-1.35E-2]
[2022,-1.35E-2]
[]
[]
[{"$f":"\"Xt for \"&B$5","v":"Xt for 2020"},{"$f":"VLOOKUP(B5,A34:B38,2,FALSE)","v":-5.9643805428307873E-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 2020"},{"$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.739434187686741E-2]

{"sheet":"Prop2020DistTar","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":"Prop2020DistTar"}]
[]
[null,{"$f":"\"PROPOSED \"&'Model update'!$B$5&\" DISTRIBUTION TARIFFS\"","v":"PROPOSED 2020 DISTRIBUTION TARIFFS"}]
[]
[null,"Proposed tariff name","Existing tariff name",{"$f":"\"Prop\n\"&'Model update'!$B$5&\" Tariff\"","v":"Prop\n2020 Tariff"},{"$f":"\"Exist\n\"&'Model update'!$B$8&\" Tariff\"","v":"Exist\n2019 Tariff"},{"$f":"\"Actual \"&'Model update'!$B$9&\" Volumes\"","v":"Actual 2018 Volumes"},"Prop Tar\nRevenue","Exist Tar\nRevenue"]
[null,"Tariff V - AGN Central - Residential","Tariff V - AGN Central - Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.19309999999999999,0.19009999999999999,200042386,{"$f":"D8*$F8","v":38628184.736599997},{"$f":"E8*$F8","v":38028057.578599997}]
[null,"GJ 0 - 0.0274","GJ 0 - 0.0274",11.8925,11.467599999999999,4774337.9350008592,{"$f":"D9*$F9","v":56778813.891997717},54750197.703415848]
[null,"GJ 0.0274 - 0.0493","GJ 0.0274 - 0.0493",6.8377999999999997,6.7305999999999999,2971130.4126871959,20315995.535872508,19997490.355632439]
[null,"GJ > 0.0493","GJ > 0.0493",3.7538,3.6949000000000001,17831150.365736302,66934572.24290093,65884317.48635906]
[null,"Tariff V - AGN Central - Non Residential","Tariff V - AGN Central - Non Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.19309999999999999,0.19009999999999999,7284773,{"$f":"D14*$F14","v":1406689.6662999999},{"$f":"E14*$F14","v":1384835.3473}]
[null,"GJ 0 - 0.05","GJ 0 - 0.05",8.3948999999999998,8.2632999999999992,265830.61765718501,{"$f":"D15*$F15","v":2231621.4521703022},2196638.1428866168]
[null,"GJ 0.05 - 0.55","GJ 0.05 - 0.55",3.9622000000000002,3.8769,1423735.4133312982,5641124.45470127,5519679.8239441095]
[null,"GJ 0.55 - 1.37","GJ 0.55 - 1.37",2.9552999999999998,2.8973,1139568.0066959986,3367765.3301886846,3301670.3858003169]
[null,"GJ > 1.37","GJ > 1.37",1.1936,1.1749000000000001,4006118.3130089031,4781702.8184074266,4706788.4059541607]
[null,"Tariff V - AGN North - Residential","Tariff V - AGN North - Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.19309999999999999,0.19009999999999999,28266023,{"$f":"D21*$F21","v":5458169.0412999997},{"$f":"E21*$F21","v":5373370.9722999996}]
[null,"GJ 0 - 0.0274","GJ 0 - 0.0274",10.4636,10.089700000000001,646209.005216424,{"$f":"D22*$F22","v":6761672.5469825743},6520054.9999321541]
[null,"GJ 0.0274 - 0.0493","GJ 0.0274 - 0.0493",6.1250999999999998,6.0290999999999997,383055.06172620138,2346250.5585791562,2309477.2726534405]
[null,"GJ > 0.0493","GJ > 0.0493",3.3628999999999998,3.3102,2456109.3326460756,8259650.074755487,8130213.1129250396]
[null,"Tariff V - AGN North - Non Residential","Tariff V - AGN North - Non Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.19309999999999999,0.19009999999999999,1189097,{"$f":"D27*$F27","v":229614.63069999998},{"$f":"E27*$F27","v":226047.33969999998}]
[null,"GJ 0 - 0.05","GJ 0 - 0.05",7.5303000000000004,7.4122000000000003,37173.312274553988,{"$f":"D28*$F28","v":279926.1934210739},275536.02524144907]
[null,"GJ 0.05 - 0.55","GJ 0.05 - 0.55",3.5809000000000002,3.5038,180073.90312619132,644826.63970457856,630942.94177354919]
[null,"GJ 0.55 - 1.37","GJ 0.55 - 1.37",2.6707000000000001,2.6183000000000001,123812.96927430895,330667.29704089696,324179.49745092314]
[null,"GJ > 1.37","GJ > 1.37",1.0790999999999999,1.0617000000000001,482010.1612990367,520137.16505779047,511750.18825118733]
[null,"Tariff V - Murray Valley - Residential","Tariff V - Murray Valley - Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.24579999999999999,0.2419,2924336,{"$f":"D34*$F34","v":718801.78879999998},{"$f":"E34*$F34","v":707396.87840000005}]
[null,"GJ 0 - 0.0274","GJ 0 - 0.0274",9.1097999999999999,8.7843,55926.255840708727,{"$f":"D35*$F35","v":509477.00545768836},491273.00918153767]
[null,"GJ 0.0274 - 0.0493","GJ 0.0274 - 0.0493",5.5110999999999999,5.4246999999999996,29339.596098886166,161693.44806057154,159158.50695762777]
[null,"GJ > 0.0493","GJ > 0.0493",3.4474999999999998,3.3934000000000002,186758.22166911955,643848.96920428961,633745.34941199026]
[null,"Tariff V - Murray Valley - Non Residential","Tariff V - Murray Valley - Non Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.24579999999999999,0.2419,128179,{"$f":"D40*$F40","v":31506.3982},{"$f":"E40*$F40","v":31006.500100000001}]
[null,"GJ 0 - 0.05","GJ 0 - 0.05",6.7329999999999997,6.6273999999999997,4312.1918159390007,{"$f":"D41*$F41","v":29033.987496717291},28578.620040954131]
[null,"GJ 0.05 - 0.55","GJ 0.05 - 0.55",3.9767000000000001,3.8910999999999998,20264.967402727041,80587.695870424621,78853.014660751185]
[null,"GJ 0.55 - 1.37","GJ 0.55 - 1.37",2.9678,2.9096000000000002,13200.206018902991,39175.571422900299,38407.319432600147]
[null,"GJ > 1.37","GJ > 1.37",1.3434999999999999,1.3224,28916.660752782009,38849.533721362626,38239.392179478928]
[null,"Tariff V - Bairnsdale - Residential","Tariff V - Bairnsdale - Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.31780000000000003,0.31280000000000002,1583316,{"$f":"D47*$F47","v":503177.82480000006},{"$f":"E47*$F47","v":495261.24480000004}]
[null,"GJ 0 - 0.0274","GJ 0 - 0.0274",19.416599999999999,18.722799999999999,30897.57080102677,{"$f":"D48*$F48","v":599925.77321521635},{"$f":"E48*$F48","v":578489.03859346395}]
[null,"GJ 0.0274 - 0.0493","GJ 0.0274 - 0.0493",11.2934,11.116300000000001,15280.184214761981,172565.23241099296,169859.11178655861]
[null,"GJ > 0.0493","GJ > 0.0493",6.1999000000000004,6.1026999999999996,66716.115727078053,413633.24589631124,407148.43944763922]
[null,"Tariff V - Bairnsdale - Non Residential","Tariff V - Bairnsdale - Non Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.31780000000000003,0.31280000000000002,42198,{"$f":"D53*$F53","v":13410.5244},{"$f":"E53*$F53","v":13199.5344}]
[null,"GJ 0 - 0.05","GJ 0 - 0.05",13.804500000000001,13.588100000000001,1724.4188492440005,{"$f":"D54*$F54","v":23804.740004388808},{"$f":"E54*$F54","v":23431.575765412406}]
[null,"GJ 0.05 - 0.55","GJ 0.05 - 0.55",6.73,6.5850999999999997,12856.561794754994,86524.660878701121,84661.745074641105]
[null,"GJ 0.55 - 1.37","GJ 0.55 - 1.37",5.0178000000000003,4.9194000000000004,10060.358185793,50480.865304672123,49490.926059190089]
[null,"GJ > 1.37","GJ > 1.37",2.0266999999999999,1.9948999999999999,37494.204673755987,75989.504612301258,74797.188903675808]
[]
[null,"Tariff D -  AGN Central","Tariff D -  AGN Central"]
[null,"0 - 10","0 - 10",1461.0057999999999,1429.5715,1452.2920000000001,{"$f":"D60*$F60","v":2121807.0352936001},2076155.2528780003]
[null,"10 - 50","10 - 50",893.16539999999998,873.94849999999997,1249.9424000000004,1116405.3036729603,1092385.2855664003]
[null,"> 50","> 50",163.1104,159.601,1420.239,231655.75138560002,226671.56463900002]
[]
[null,"Tariff D - AGN North","Tariff D - AGN North"]
[null,"0 - 10","0 - 10",1461.0057999999999,1429.5715,434.14239999999995,{"$f":"D65*$F65","v":634284.5644259199},620637.60198159993]
[null,"10 - 50","10 - 50",893.16539999999998,873.94849999999997,627.2100999999999,560202.35985053994,548149.32607984985]
[null,"> 50","> 50",163.1104,159.601,440.21849999999995,71804.215622399992,70259.312818499995]
[]
[null,"Tariff D - Murray Valley","Tariff D - Murray Valley"]
[null,"0 - 10","0 - 10",1702.9776999999999,1666.3372999999999,68.235900000000001,{"$f":"D70*$F70","v":116204.21603943},113704.02536906999]
[null,"10 - 50","10 - 50",1050.8447000000001,1028.2353000000001,163.20350000000002,171501.53299645003,167811.59978355002]
[null,"> 50","> 50",178.97739999999999,175.1266,102.5181,18348.422990939998,17953.646291460002]
[]
[null,"Tariff D - Bairnsdale","Tariff D - Bairnsdale"]
[null,"0 - 10","0 - 10",2416.6995999999999,2364.7031000000002,15.391300000000001,{"$f":"D75*$F75","v":37196.148553480001},36395.854823030008]
[null,"10 - 50","10 - 50",1497.1554000000001,1464.9434000000001,3.6834000000000007,5514.6222003600014,5395.9725195600013]
[null,"> 50","> 50",273.0471,267.17239999999998,0,0,0]
[]
[null,"Tariff V - Albury - Residential","Tariff V - Albury - Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.25119999999999998,0.24729999999999999,8074668,{"$f":"D81*$F81","v":2028356.6015999999},1996865.3964]
[null,"GJ 0 - 0.0274","GJ 0 - 0.0274",8.6120000000000001,8.3042999999999996,182816.31088578256,1574414.0693483595,1518161.4904888039]
[null,"GJ 0.0274 - 0.0493","GJ 0.0274 - 0.0493",5.1475999999999997,5.0669000000000004,107334.76385032204,552516.43039591773,543854.51495319675]
[null,"GJ > 0.0493","GJ > 0.0493",2.8267000000000002,2.7824,679508.24242366059,1920765.9488589615,1890663.7337195931]
[null,"Tariff V - Albury - Non Residential","Tariff V - Albury - Non Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.25119999999999998,0.24729999999999999,337460,{"$f":"D87*$F87","v":84769.95199999999},83453.857999999993]
[null,"GJ 0 - 0.05","GJ 0 - 0.05",6.3207000000000004,6.2215999999999996,11053.69385398299,69867.082742870291,68771.661681940561]
[null,"GJ 0.05 - 0.55","GJ 0.05 - 0.55",3.121,3.0537999999999998,56720.669007782002,177025.20797328762,173213.57901596467]
[null,"GJ 0.55 - 1.37","GJ 0.55 - 1.37",2.2162999999999999,2.1728000000000001,41383.913578436994,91719.167663889908,89918.967423227907]
[null,"GJ > 1.37","GJ > 1.37",0.89490000000000003,0.88080000000000003,178425.80578475806,159673.25359678001,157157.4497352149]
[]
[null,"Tariff D - Albury","Tariff D - Albury"]
[null,"0 - 10","0 - 10",1256.4656,1229.4321,50.052,{"$f":"D94*$F94","v":62888.616211200002},61535.535469199996]
[null,"10 - 50","10 - 50",780.38049999999998,763.59019999999998,102.7889,{"$f":"D95*$F95","v":80214.453176449999},78488.596708779995]
[null,"> 50","> 50",188.63499999999999,184.5128,197.36599999999999,37230.135409999995,36416.5532848]
[]
[]
[]
[]
[null,"Total Revenue","Total Revenue",null,null,null,{"$f":"SUM(G8:G97)","v":241034236.13844636},{"$f":"SUM(H8:H97)","v":235848265.75494647}]

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

{"sheet":"2020RebalContForm","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":"2020RebalContForm"}]
[]
[null,{"$f":"'Model update'!$B$5&\"  REBALANCING CONTROL FORMULA\"","v":"2020  REBALANCING CONTROL FORMULA"}]
[]
[]
[null,"Rebalancing control"]
[]
[null,{"$f":"\"CPI \"&'Model update'!$B$5","v":"CPI 2020"},{"$f":"'2020TarContForm'!C11","v":1.5929203539823078E-2}]
[null,{"$f":"\"Y  \"&'Model update'!$B$5","v":"Y  2020"},0.02]
[null,{"$f":"\"PTt \"&'Model update'!$B$5","v":"PTt 2020"},{"$f":"'2020TarContForm'!C29","v":0}]
[null,{"$f":"\"Xt \"&'Model update'!$B$5","v":"Xt 2020"},{"$f":"'2020TarContForm'!C17","v":-5.9643805428307873E-3}]
[]
[null,"Rebalancing control",{"$f":"(1+C8)*(1+C9)*(1+C10)*(1-C11)","v":1.042428363752596}]
[]
[]
[]
[null,"Rebalancing control summary"]
[null,null,"Existing","Proposed","Movement","Assessment"]
[null,{"$f":"B38","v":"Tariff V - AGN Central - Residential"},{"$f":"C59","v":178660063.12400734},{"$f":"C60","v":182657566.40737113},{"$f":"IF(C19=0,0,D19/C19)","v":1.0223749125208197},{"$f":"IF(E19=0,\"\",IF($C$13<=E19,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B68","v":"Tariff V - AGN North - Residential"},{"$f":"C89","v":22333116.357810631},{"$f":"C90","v":22825742.221617218},{"$f":"IF(C20=0,0,D20/C20)","v":1.0220580888002357},{"$f":"IF(E20=0,\"\",IF($C$13<=E20,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B98","v":"Tariff V - Murray Valley - Residential"},{"$f":"C119","v":1991573.7439511558},{"$f":"C120","v":2033821.2115225494},1.0212131073226429,"Compliant"]
[null,{"$f":"B128","v":"Tariff V - Bairnsdale - Residential"},{"$f":"C149","v":1650757.8346276619},{"$f":"C150","v":1689302.0763225206},1.023349422238879,"Compliant"]
[null,{"$f":"B158","v":"Tariff V - AGN Central - Non Residential"},{"$f":"C179","v":17109612.105885204},{"$f":"C180","v":17428903.721767683},1.0186615344583207,"Compliant"]
[null,{"$f":"B188","v":"Tariff V - AGN North - Non Residential"},{"$f":"C209","v":1968455.9924171085},{"$f":"C210","v":2005171.9259243398},1.0186521485106441,{"$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":215084.84641378437},{"$f":"C240","v":219153.18671140485},1.018915048481815,"Compliant"]
[null,{"$f":"B248","v":"Tariff V - Bairnsdale - Non Residential"},{"$f":"C269","v":245580.97020291939},{"$f":"C270","v":250210.29520006332},{"$f":"IF(C26=0,0,D26/C26)","v":1.018850503739434},{"$f":"IF(E26=0,\"\",IF($C$13<=E26,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B278","v":"Tariff D -  AGN Central"},{"$f":"C293","v":3395212.103083401},{"$f":"C294","v":3469868.0903521604},{"$f":"IF(C27=0,0,D27/C27)","v":1.0219886077812221},{"$f":"IF(E27=0,\"\",IF($C$13<=E27,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B302","v":"Tariff D - AGN North"},{"$f":"C317","v":1239046.2408799499},{"$f":"C318","v":1266291.1398988599},1.0219886055257801,"Compliant"]
[null,{"$f":"B326","v":"Tariff D - Murray Valley"},{"$f":"C341","v":299469.27144408005},{"$f":"C342","v":306054.17202682002},1.0219885684797867,"Compliant"]
[null,{"$f":"B350","v":"Tariff D - Bairnsdale"},{"$f":"C365","v":41791.827342590012},{"$f":"C366","v":42710.770753839999},1.021988591303197,"Compliant"]
[null,{"$f":"B374","v":"Tariff V - Albury - Residential"},{"$f":"C395","v":5949545.1355615938},{"$f":"C396","v":6076053.0502032386},1.0212634599383879,"Compliant"]
[null,{"$f":"B404","v":"Tariff V - Albury - Non Residential"},{"$f":"C425","v":572515.51585634798},{"$f":"C426","v":583054.66397682787},1.0184084934444366,"Compliant"]
[null,{"$f":"B434","v":"Tariff D - Albury"},{"$f":"C449","v":176440.68546277998},{"$f":"C450","v":180333.20479764999},1.0220613478385694,"Compliant"]
[null,null,{"$f":"SUM(C19:C33)","v":235848265.75494653},{"$f":"SUM(D19:D33)","v":241034236.13844627},1.0219885881581514]
[]
[]
[]
[null,{"$f":"Prop2020DistTar!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 : \"&Prop2020DistTar!C6","v":"Existing : Tariff V - AGN Central - Residential"},{"$f":"INDEX(Prop2020DistTar!$E$8:$E$11,C$39)","v":0.19009999999999999},{"$f":"INDEX(Prop2020DistTar!$E$8:$E$11,D$39)","v":11.467599999999999},{"$f":"INDEX(Prop2020DistTar!$E$8:$E$11,E$39)","v":6.7305999999999999},{"$f":"INDEX(Prop2020DistTar!$E$8:$E$11,F$39)","v":3.6949000000000001}]
[]
[null,{"$f":"\"Proposed : \"&B38","v":"Proposed : Tariff V - AGN Central - Residential"},{"$f":"INDEX(Prop2020DistTar!$D$8:$D$11,C$38)","v":0.19309999999999999},{"$f":"INDEX(Prop2020DistTar!$D$8:$D$11,D$38)","v":11.8925},{"$f":"INDEX(Prop2020DistTar!$D$8:$D$11,E$38)","v":6.8377999999999997},{"$f":"INDEX(Prop2020DistTar!$D$8:$D$11,F$38)","v":3.7538}]
[]
[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(Prop2020DistTar!$F$8:$F$11,C$13)","v":200042386},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$11,D$38)","v":4774337.9350008592},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$11,E$38)","v":2971130.4126871959},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$11,F$38)","v":17831150.365736302}]
[]
[null,{"$f":"B44","v":"Proposed : Tariff V - AGN Central - Residential"},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$11,C$38)","v":200042386},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$11,D$38)","v":4774337.9350008592},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$11,E$38)","v":2971130.4126871959},{"$f":"INDEX(Prop2020DistTar!$F$8:$F$11,F$38)","v":17831150.365736302}]
[]
[null,"Distribution revenue",{"$f":"C$40","v":"Fixed"},"Blk1","Blk2","Blk3"]
[]
[null,{"$f":"B48","v":"Existing : Tariff V - AGN Central - Residential"},{"$f":"INDEX(Prop2020DistTar!$H$8:$H$11,C$39)","v":38028057.578599997},{"$f":"INDEX(Prop2020DistTar!$H$8:$H$11,D$39)","v":54750197.703415848},{"$f":"INDEX(Prop2020DistTar!$H$8:$H$11,E$39)","v":19997490.355632439},{"$f":"INDEX(Prop2020DistTar!$H$8:$H$11,F$39)","v":65884317.48635906}]
[]
[null,{"$f":"B50","v":"Proposed : Tariff V - AGN Central - Residential"},{"$f":"INDEX(Prop2020DistTar!$G$8:$G$11,C$38)","v":38628184.736599997},{"$f":"INDEX(Prop2020DistTar!$G$8:$G$11,D$38)","v":56778813.891997717},{"$f":"INDEX(Prop2020DistTar!$G$8:$G$11,E$38)","v":20315995.535872508},{"$f":"INDEX(Prop2020DistTar!$G$8:$G$11,F$38)","v":66934572.24290093}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B54","v":"Existing : Tariff V - AGN Central - Residential"},{"$f":"SUM(C54:F54)","v":178660063.12400734}]
[null,{"$f":"B56","v":"Proposed : Tariff V - AGN Central - Residential"},{"$f":"SUM(C56:F56)","v":182657566.40737113}]
[]
[null,"Average price movement",{"$f":"IF(C60=0,\"\",C60/C59)","v":1.0223749125208197}]
[]
[null,{"$f":"IF(C62=\"\",\"\",IF(C62<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2020DistTar!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 : \"&Prop2020DistTar!C19","v":"Existing : Tariff V - AGN North - Residential"},{"$f":"INDEX(Prop2020DistTar!$E$21:$E$24,C$39)","v":0.19009999999999999},{"$f":"INDEX(Prop2020DistTar!$E$21:$E$24,D$39)","v":10.089700000000001},{"$f":"INDEX(Prop2020DistTar!$E$21:$E$24,E$39)","v":6.0290999999999997},{"$f":"INDEX(Prop2020DistTar!$E$21:$E$24,F$39)","v":3.3102}]
[]
[null,{"$f":"\"Proposed : \"&B68","v":"Proposed : Tariff V - AGN North - Residential"},{"$f":"INDEX(Prop2020DistTar!$D$21:$D$24,C$38)","v":0.19309999999999999},{"$f":"INDEX(Prop2020DistTar!$D$21:$D$24,D$38)","v":10.4636},{"$f":"INDEX(Prop2020DistTar!$D$21:$D$24,E$38)","v":6.1250999999999998},{"$f":"INDEX(Prop2020DistTar!$D$21:$D$24,F$38)","v":3.3628999999999998}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B72","v":"Existing : Tariff V - AGN North - Residential"},{"$f":"INDEX(Prop2020DistTar!$F$21:$F$24,C$38)","v":28266023},{"$f":"INDEX(Prop2020DistTar!$F$21:$F$24,D$38)","v":646209.005216424},{"$f":"INDEX(Prop2020DistTar!$F$21:$F$24,E$38)","v":383055.06172620138},{"$f":"INDEX(Prop2020DistTar!$F$21:$F$24,F$38)","v":2456109.3326460756}]
[]
[null,{"$f":"B74","v":"Proposed : Tariff V - AGN North - Residential"},{"$f":"INDEX(Prop2020DistTar!$F$21:$F$24,C$38)","v":28266023},{"$f":"INDEX(Prop2020DistTar!$F$21:$F$24,D$38)","v":646209.005216424},{"$f":"INDEX(Prop2020DistTar!$F$21:$F$24,E$38)","v":383055.06172620138},{"$f":"INDEX(Prop2020DistTar!$F$21:$F$24,F$38)","v":2456109.3326460756}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B78","v":"Existing : Tariff V - AGN North - Residential"},{"$f":"INDEX(Prop2020DistTar!$H$21:$H$24,C$39)","v":5373370.9722999996},{"$f":"INDEX(Prop2020DistTar!$H$21:$H$24,D$39)","v":6520054.9999321541},{"$f":"INDEX(Prop2020DistTar!$H$21:$H$24,E$39)","v":2309477.2726534405},{"$f":"INDEX(Prop2020DistTar!$H$21:$H$24,F$39)","v":8130213.1129250396}]
[]
[null,{"$f":"B80","v":"Proposed : Tariff V - AGN North - Residential"},{"$f":"INDEX(Prop2020DistTar!$G$21:$G$24,C$38)","v":5458169.0412999997},{"$f":"INDEX(Prop2020DistTar!$G$21:$G$24,D$38)","v":6761672.5469825743},{"$f":"INDEX(Prop2020DistTar!$G$21:$G$24,E$38)","v":2346250.5585791562},{"$f":"INDEX(Prop2020DistTar!$G$21:$G$24,F$38)","v":8259650.074755487}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B84","v":"Existing : Tariff V - AGN North - Residential"},{"$f":"SUM(C84:F84)","v":22333116.357810631}]
[null,{"$f":"B86","v":"Proposed : Tariff V - AGN North - Residential"},{"$f":"SUM(C86:F86)","v":22825742.221617218}]
[]
[null,"Average price movement",{"$f":"IF(C90=0,\"\",C90/C89)","v":1.0220580888002357}]
[]
[null,{"$f":"IF(C92=\"\",\"\",IF(C92<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2020DistTar!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 : \"&Prop2020DistTar!C32","v":"Existing : Tariff V - Murray Valley - Residential"},{"$f":"INDEX(Prop2020DistTar!$E$34:$E$37,C$39)","v":0.2419},{"$f":"INDEX(Prop2020DistTar!$E$34:$E$37,D$39)","v":8.7843},{"$f":"INDEX(Prop2020DistTar!$E$34:$E$37,E$39)","v":5.4246999999999996},{"$f":"INDEX(Prop2020DistTar!$E$34:$E$37,F$39)","v":3.3934000000000002}]
[]
[null,{"$f":"\"Proposed : \"&B98","v":"Proposed : Tariff V - Murray Valley - Residential"},{"$f":"INDEX(Prop2020DistTar!$D$34:$D$37,C$38)","v":0.24579999999999999},{"$f":"INDEX(Prop2020DistTar!$D$34:$D$37,D$38)","v":9.1097999999999999},{"$f":"INDEX(Prop2020DistTar!$D$34:$D$37,E$38)","v":5.5110999999999999},{"$f":"INDEX(Prop2020DistTar!$D$34:$D$37,F$38)","v":3.4474999999999998}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B102","v":"Existing : Tariff V - Murray Valley - Residential"},{"$f":"INDEX(Prop2020DistTar!$F$34:$F$37,C$38)","v":2924336},{"$f":"INDEX(Prop2020DistTar!$F$34:$F$37,D$38)","v":55926.255840708727},{"$f":"INDEX(Prop2020DistTar!$F$34:$F$37,E$38)","v":29339.596098886166},{"$f":"INDEX(Prop2020DistTar!$F$34:$F$37,F$38)","v":186758.22166911955}]
[]
[null,{"$f":"B104","v":"Proposed : Tariff V - Murray Valley - Residential"},{"$f":"INDEX(Prop2020DistTar!$F$34:$F$37,C$38)","v":2924336},{"$f":"INDEX(Prop2020DistTar!$F$34:$F$37,D$38)","v":55926.255840708727},{"$f":"INDEX(Prop2020DistTar!$F$34:$F$37,E$38)","v":29339.596098886166},{"$f":"INDEX(Prop2020DistTar!$F$34:$F$37,F$38)","v":186758.22166911955}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B108","v":"Existing : Tariff V - Murray Valley - Residential"},{"$f":"INDEX(Prop2020DistTar!$H$34:$H$37,C$39)","v":707396.87840000005},{"$f":"INDEX(Prop2020DistTar!$H$34:$H$37,D$39)","v":491273.00918153767},{"$f":"INDEX(Prop2020DistTar!$H$34:$H$37,E$39)","v":159158.50695762777},{"$f":"INDEX(Prop2020DistTar!$H$34:$H$37,F$39)","v":633745.34941199026}]
[]
[null,{"$f":"B110","v":"Proposed : Tariff V - Murray Valley - Residential"},{"$f":"INDEX(Prop2020DistTar!$G$34:$G$37,C$38)","v":718801.78879999998},{"$f":"INDEX(Prop2020DistTar!$G$34:$G$37,D$38)","v":509477.00545768836},{"$f":"INDEX(Prop2020DistTar!$G$34:$G$37,E$38)","v":161693.44806057154},{"$f":"INDEX(Prop2020DistTar!$G$34:$G$37,F$38)","v":643848.96920428961}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B114","v":"Existing : Tariff V - Murray Valley - Residential"},{"$f":"SUM(C114:F114)","v":1991573.7439511558}]
[null,{"$f":"B116","v":"Proposed : Tariff V - Murray Valley - Residential"},{"$f":"SUM(C116:F116)","v":2033821.2115225494}]
[]
[null,"Average price movement",{"$f":"IF(C120=0,\"\",C120/C119)","v":1.0212131073226429}]
[]
[null,{"$f":"IF(C122=\"\",\"\",IF(C122<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2020DistTar!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 : \"&Prop2020DistTar!C45","v":"Existing : Tariff V - Bairnsdale - Residential"},{"$f":"INDEX(Prop2020DistTar!$E$47:$E$50,C$39)","v":0.31280000000000002},{"$f":"INDEX(Prop2020DistTar!$E$47:$E$50,D$39)","v":18.722799999999999},{"$f":"INDEX(Prop2020DistTar!$E$47:$E$50,E$39)","v":11.116300000000001},{"$f":"INDEX(Prop2020DistTar!$E$47:$E$50,F$39)","v":6.1026999999999996}]
[]
[null,{"$f":"\"Proposed : \"&B128","v":"Proposed : Tariff V - Bairnsdale - Residential"},{"$f":"INDEX(Prop2020DistTar!$D$47:$D$50,C$38)","v":0.31780000000000003},{"$f":"INDEX(Prop2020DistTar!$D$47:$D$50,D$38)","v":19.416599999999999},{"$f":"INDEX(Prop2020DistTar!$D$47:$D$50,E$38)","v":11.2934},{"$f":"INDEX(Prop2020DistTar!$D$47:$D$50,F$38)","v":6.1999000000000004}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B132","v":"Existing : Tariff V - Bairnsdale - Residential"},{"$f":"INDEX(Prop2020DistTar!$F$47:$F$50,C$38)","v":1583316},{"$f":"INDEX(Prop2020DistTar!$F$47:$F$50,D$38)","v":30897.57080102677},{"$f":"INDEX(Prop2020DistTar!$F$47:$F$50,E$38)","v":15280.184214761981},{"$f":"INDEX(Prop2020DistTar!$F$47:$F$50,F$38)","v":66716.115727078053}]
[]
[null,{"$f":"B134","v":"Proposed : Tariff V - Bairnsdale - Residential"},{"$f":"INDEX(Prop2020DistTar!$F$47:$F$50,C$38)","v":1583316},{"$f":"INDEX(Prop2020DistTar!$F$47:$F$50,D$38)","v":30897.57080102677},{"$f":"INDEX(Prop2020DistTar!$F$47:$F$50,E$38)","v":15280.184214761981},{"$f":"INDEX(Prop2020DistTar!$F$47:$F$50,F$38)","v":66716.115727078053}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B138","v":"Existing : Tariff V - Bairnsdale - Residential"},{"$f":"INDEX(Prop2020DistTar!$H$47:$H$50,C$39)","v":495261.24480000004},{"$f":"INDEX(Prop2020DistTar!$H$47:$H$50,D$39)","v":578489.03859346395},{"$f":"INDEX(Prop2020DistTar!$H$47:$H$50,E$39)","v":169859.11178655861},{"$f":"INDEX(Prop2020DistTar!$H$47:$H$50,F$39)","v":407148.43944763922}]
[]
[null,{"$f":"B140","v":"Proposed : Tariff V - Bairnsdale - Residential"},{"$f":"INDEX(Prop2020DistTar!$G$47:$G$50,C$38)","v":503177.82480000006},{"$f":"INDEX(Prop2020DistTar!$G$47:$G$50,D$38)","v":599925.77321521635},{"$f":"INDEX(Prop2020DistTar!$G$47:$G$50,E$38)","v":172565.23241099296},{"$f":"INDEX(Prop2020DistTar!$G$47:$G$50,F$38)","v":413633.24589631124}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B144","v":"Existing : Tariff V - Bairnsdale - Residential"},{"$f":"SUM(C144:F144)","v":1650757.8346276619}]
[null,{"$f":"B146","v":"Proposed : Tariff V - Bairnsdale - Residential"},{"$f":"SUM(C146:F146)","v":1689302.0763225206}]
[]
[null,"Average price movement",{"$f":"IF(C150=0,\"\",C150/C149)","v":1.023349422238879}]
[]
[null,{"$f":"IF(C152=\"\",\"\",IF(C152<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2020DistTar!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 : \"&Prop2020DistTar!C12","v":"Existing : Tariff V - AGN Central - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$E$14:$E$18,C$39)","v":0.19009999999999999},{"$f":"INDEX(Prop2020DistTar!$E$14:$E$18,D$39)","v":8.2632999999999992},{"$f":"INDEX(Prop2020DistTar!$E$14:$E$18,E$39)","v":3.8769},{"$f":"INDEX(Prop2020DistTar!$E$14:$E$18,F$39)","v":2.8973},{"$f":"INDEX(Prop2020DistTar!$E$14:$E$18,G$39)","v":1.1749000000000001}]
[]
[null,{"$f":"\"Proposed : \"&B158","v":"Proposed : Tariff V - AGN Central - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$D$14:$D$18,C$38)","v":0.19309999999999999},{"$f":"INDEX(Prop2020DistTar!$D$14:$D$18,D$38)","v":8.3948999999999998},{"$f":"INDEX(Prop2020DistTar!$D$14:$D$18,E$38)","v":3.9622000000000002},{"$f":"INDEX(Prop2020DistTar!$D$14:$D$18,F$38)","v":2.9552999999999998},{"$f":"INDEX(Prop2020DistTar!$D$14:$D$18,G$38)","v":1.1936}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B162","v":"Existing : Tariff V - AGN Central - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$F$14:$F$18,C$38)","v":7284773},{"$f":"INDEX(Prop2020DistTar!$F$14:$F$18,D$38)","v":265830.61765718501},{"$f":"INDEX(Prop2020DistTar!$F$14:$F$18,E$38)","v":1423735.4133312982},{"$f":"INDEX(Prop2020DistTar!$F$14:$F$18,F$38)","v":1139568.0066959986},{"$f":"INDEX(Prop2020DistTar!$F$14:$F$18,G$38)","v":4006118.3130089031}]
[]
[null,{"$f":"B164","v":"Proposed : Tariff V - AGN Central - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$F$14:$F$18,C$38)","v":7284773},{"$f":"INDEX(Prop2020DistTar!$F$14:$F$18,D$38)","v":265830.61765718501},{"$f":"INDEX(Prop2020DistTar!$F$14:$F$18,E$38)","v":1423735.4133312982},{"$f":"INDEX(Prop2020DistTar!$F$14:$F$18,F$38)","v":1139568.0066959986},{"$f":"INDEX(Prop2020DistTar!$F$14:$F$18,G$38)","v":4006118.3130089031}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B168","v":"Existing : Tariff V - AGN Central - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$H$14:$H$18,C$39)","v":1384835.3473},{"$f":"INDEX(Prop2020DistTar!$H$14:$H$18,D$39)","v":2196638.1428866168},{"$f":"INDEX(Prop2020DistTar!$H$14:$H$18,E$39)","v":5519679.8239441095},{"$f":"INDEX(Prop2020DistTar!$H$14:$H$18,F$39)","v":3301670.3858003169},{"$f":"INDEX(Prop2020DistTar!$H$14:$H$18,G$39)","v":4706788.4059541607}]
[]
[null,{"$f":"B170","v":"Proposed : Tariff V - AGN Central - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$G$14:$G$18,C$38)","v":1406689.6662999999},{"$f":"INDEX(Prop2020DistTar!$G$14:$G$18,D$38)","v":2231621.4521703022},{"$f":"INDEX(Prop2020DistTar!$G$14:$G$18,E$38)","v":5641124.45470127},{"$f":"INDEX(Prop2020DistTar!$G$14:$G$18,F$38)","v":3367765.3301886846},{"$f":"INDEX(Prop2020DistTar!$G$14:$G$18,G$38)","v":4781702.8184074266}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B174","v":"Existing : Tariff V - AGN Central - Non Residential"},{"$f":"SUM(C174:G174)","v":17109612.105885204}]
[null,{"$f":"B176","v":"Proposed : Tariff V - AGN Central - Non Residential"},{"$f":"SUM(C176:G176)","v":17428903.721767683}]
[]
[null,"Average price movement",{"$f":"IF(C180=0,\"\",C180/C179)","v":1.0186615344583207}]
[]
[null,{"$f":"IF(C182=\"\",\"\",IF(C182<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2020DistTar!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 : \"&Prop2020DistTar!C25","v":"Existing : Tariff V - AGN North - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$E$27:$E$31,C$39)","v":0.19009999999999999},{"$f":"INDEX(Prop2020DistTar!$E$27:$E$31,D$39)","v":7.4122000000000003},{"$f":"INDEX(Prop2020DistTar!$E$27:$E$31,E$39)","v":3.5038},{"$f":"INDEX(Prop2020DistTar!$E$27:$E$31,F$39)","v":2.6183000000000001},{"$f":"INDEX(Prop2020DistTar!$E$27:$E$31,G$39)","v":1.0617000000000001}]
[]
[null,{"$f":"\"Proposed : \"&B188","v":"Proposed : Tariff V - AGN North - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$D$27:$D$31,C$38)","v":0.19309999999999999},{"$f":"INDEX(Prop2020DistTar!$D$27:$D$31,D$38)","v":7.5303000000000004},{"$f":"INDEX(Prop2020DistTar!$D$27:$D$31,E$38)","v":3.5809000000000002},{"$f":"INDEX(Prop2020DistTar!$D$27:$D$31,F$38)","v":2.6707000000000001},{"$f":"INDEX(Prop2020DistTar!$D$27:$D$31,G$38)","v":1.0790999999999999}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B192","v":"Existing : Tariff V - AGN North - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$F$27:$F$31,C$38)","v":1189097},{"$f":"INDEX(Prop2020DistTar!$F$27:$F$31,D$38)","v":37173.312274553988},{"$f":"INDEX(Prop2020DistTar!$F$27:$F$31,E$38)","v":180073.90312619132},{"$f":"INDEX(Prop2020DistTar!$F$27:$F$31,F$38)","v":123812.96927430895},{"$f":"INDEX(Prop2020DistTar!$F$27:$F$31,G$38)","v":482010.1612990367}]
[]
[null,{"$f":"B194","v":"Proposed : Tariff V - AGN North - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$F$27:$F$31,C$38)","v":1189097},{"$f":"INDEX(Prop2020DistTar!$F$27:$F$31,D$38)","v":37173.312274553988},{"$f":"INDEX(Prop2020DistTar!$F$27:$F$31,E$38)","v":180073.90312619132},{"$f":"INDEX(Prop2020DistTar!$F$27:$F$31,F$38)","v":123812.96927430895},{"$f":"INDEX(Prop2020DistTar!$F$27:$F$31,G$38)","v":482010.1612990367}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B198","v":"Existing : Tariff V - AGN North - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$H$27:$H$31,C$39)","v":226047.33969999998},{"$f":"INDEX(Prop2020DistTar!$H$27:$H$31,D$39)","v":275536.02524144907},{"$f":"INDEX(Prop2020DistTar!$H$27:$H$31,E$39)","v":630942.94177354919},{"$f":"INDEX(Prop2020DistTar!$H$27:$H$31,F$39)","v":324179.49745092314},{"$f":"INDEX(Prop2020DistTar!$H$27:$H$31,G$39)","v":511750.18825118733}]
[]
[null,{"$f":"B200","v":"Proposed : Tariff V - AGN North - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$G$27:$G$31,C$38)","v":229614.63069999998},{"$f":"INDEX(Prop2020DistTar!$G$27:$G$31,D$38)","v":279926.1934210739},{"$f":"INDEX(Prop2020DistTar!$G$27:$G$31,E$38)","v":644826.63970457856},{"$f":"INDEX(Prop2020DistTar!$G$27:$G$31,F$38)","v":330667.29704089696},{"$f":"INDEX(Prop2020DistTar!$G$27:$G$31,G$38)","v":520137.16505779047}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B204","v":"Existing : Tariff V - AGN North - Non Residential"},{"$f":"SUM(C204:G204)","v":1968455.9924171085}]
[null,{"$f":"B206","v":"Proposed : Tariff V - AGN North - Non Residential"},{"$f":"SUM(C206:G206)","v":2005171.9259243398}]
[]
[null,"Average price movement",{"$f":"IF(C210=0,\"\",C210/C209)","v":1.0186521485106441}]
[]
[null,{"$f":"IF(C212=\"\",\"\",IF(C212<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2020DistTar!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 : \"&Prop2020DistTar!C38","v":"Existing : Tariff V - Murray Valley - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$E$40:$E$44,C$39)","v":0.2419},{"$f":"INDEX(Prop2020DistTar!$E$40:$E$44,D$39)","v":6.6273999999999997},{"$f":"INDEX(Prop2020DistTar!$E$40:$E$44,E$39)","v":3.8910999999999998},{"$f":"INDEX(Prop2020DistTar!$E$40:$E$44,F$39)","v":2.9096000000000002},{"$f":"INDEX(Prop2020DistTar!$E$40:$E$44,G$39)","v":1.3224}]
[]
[null,{"$f":"\"Proposed : \"&B218","v":"Proposed : Tariff V - Murray Valley - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$D$40:$D$44,C$38)","v":0.24579999999999999},{"$f":"INDEX(Prop2020DistTar!$D$40:$D$44,D$38)","v":6.7329999999999997},{"$f":"INDEX(Prop2020DistTar!$D$40:$D$44,E$38)","v":3.9767000000000001},{"$f":"INDEX(Prop2020DistTar!$D$40:$D$44,F$38)","v":2.9678},{"$f":"INDEX(Prop2020DistTar!$D$40:$D$44,G$38)","v":1.3434999999999999}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B222","v":"Existing : Tariff V - Murray Valley - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$F$40:$F$44,C$38)","v":128179},{"$f":"INDEX(Prop2020DistTar!$F$40:$F$44,D$38)","v":4312.1918159390007},{"$f":"INDEX(Prop2020DistTar!$F$40:$F$44,E$38)","v":20264.967402727041},{"$f":"INDEX(Prop2020DistTar!$F$40:$F$44,F$38)","v":13200.206018902991},{"$f":"INDEX(Prop2020DistTar!$F$40:$F$44,G$38)","v":28916.660752782009}]
[]
[null,{"$f":"B224","v":"Proposed : Tariff V - Murray Valley - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$F$40:$F$44,C$38)","v":128179},{"$f":"INDEX(Prop2020DistTar!$F$40:$F$44,D$38)","v":4312.1918159390007},{"$f":"INDEX(Prop2020DistTar!$F$40:$F$44,E$38)","v":20264.967402727041},{"$f":"INDEX(Prop2020DistTar!$F$40:$F$44,F$38)","v":13200.206018902991},{"$f":"INDEX(Prop2020DistTar!$F$40:$F$44,G$38)","v":28916.660752782009}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B228","v":"Existing : Tariff V - Murray Valley - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$H$40:$H$44,C$39)","v":31006.500100000001},{"$f":"INDEX(Prop2020DistTar!$H$40:$H$44,D$39)","v":28578.620040954131},{"$f":"INDEX(Prop2020DistTar!$H$40:$H$44,E$39)","v":78853.014660751185},{"$f":"INDEX(Prop2020DistTar!$H$40:$H$44,F$39)","v":38407.319432600147},{"$f":"INDEX(Prop2020DistTar!$H$40:$H$44,G$39)","v":38239.392179478928}]
[]
[null,{"$f":"B230","v":"Proposed : Tariff V - Murray Valley - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$G$40:$G$44,C$38)","v":31506.3982},{"$f":"INDEX(Prop2020DistTar!$G$40:$G$44,D$38)","v":29033.987496717291},{"$f":"INDEX(Prop2020DistTar!$G$40:$G$44,E$38)","v":80587.695870424621},{"$f":"INDEX(Prop2020DistTar!$G$40:$G$44,F$38)","v":39175.571422900299},{"$f":"INDEX(Prop2020DistTar!$G$40:$G$44,G$38)","v":38849.533721362626}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B234","v":"Existing : Tariff V - Murray Valley - Non Residential"},{"$f":"SUM(C234:G234)","v":215084.84641378437}]
[null,{"$f":"B236","v":"Proposed : Tariff V - Murray Valley - Non Residential"},{"$f":"SUM(C236:G236)","v":219153.18671140485}]
[]
[null,"Average price movement",{"$f":"IF(C240=0,\"\",C240/C239)","v":1.018915048481815}]
[]
[null,{"$f":"IF(C242=\"\",\"\",IF(C242<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2020DistTar!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 : \"&Prop2020DistTar!C51","v":"Existing : Tariff V - Bairnsdale - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$E$53:$E$57,C$39)","v":0.31280000000000002},{"$f":"INDEX(Prop2020DistTar!$E$53:$E$57,D$39)","v":13.588100000000001},{"$f":"INDEX(Prop2020DistTar!$E$53:$E$57,E$39)","v":6.5850999999999997},{"$f":"INDEX(Prop2020DistTar!$E$53:$E$57,F$39)","v":4.9194000000000004},{"$f":"INDEX(Prop2020DistTar!$E$53:$E$57,G$39)","v":1.9948999999999999}]
[]
[null,{"$f":"\"Proposed : \"&B248","v":"Proposed : Tariff V - Bairnsdale - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$D$53:$D$57,C$38)","v":0.31780000000000003},{"$f":"INDEX(Prop2020DistTar!$D$53:$D$57,D$38)","v":13.804500000000001},{"$f":"INDEX(Prop2020DistTar!$D$53:$D$57,E$38)","v":6.73},{"$f":"INDEX(Prop2020DistTar!$D$53:$D$57,F$38)","v":5.0178000000000003},{"$f":"INDEX(Prop2020DistTar!$D$53:$D$57,G$38)","v":2.0266999999999999}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B252","v":"Existing : Tariff V - Bairnsdale - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$F$53:$F$57,C$38)","v":42198},{"$f":"INDEX(Prop2020DistTar!$F$53:$F$57,D$38)","v":1724.4188492440005},{"$f":"INDEX(Prop2020DistTar!$F$53:$F$57,E$38)","v":12856.561794754994},{"$f":"INDEX(Prop2020DistTar!$F$53:$F$57,F$38)","v":10060.358185793},{"$f":"INDEX(Prop2020DistTar!$F$53:$F$57,G$38)","v":37494.204673755987}]
[]
[null,{"$f":"B254","v":"Proposed : Tariff V - Bairnsdale - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$F$53:$F$57,C$38)","v":42198},{"$f":"INDEX(Prop2020DistTar!$F$53:$F$57,D$38)","v":1724.4188492440005},{"$f":"INDEX(Prop2020DistTar!$F$53:$F$57,E$38)","v":12856.561794754994},{"$f":"INDEX(Prop2020DistTar!$F$53:$F$57,F$38)","v":10060.358185793},{"$f":"INDEX(Prop2020DistTar!$F$53:$F$57,G$38)","v":37494.204673755987}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B258","v":"Existing : Tariff V - Bairnsdale - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$H$53:$H$57,C$39)","v":13199.5344},{"$f":"INDEX(Prop2020DistTar!$H$53:$H$57,D$39)","v":23431.575765412406},{"$f":"INDEX(Prop2020DistTar!$H$53:$H$57,E$39)","v":84661.745074641105},{"$f":"INDEX(Prop2020DistTar!$H$53:$H$57,F$39)","v":49490.926059190089},{"$f":"INDEX(Prop2020DistTar!$H$53:$H$57,G$39)","v":74797.188903675808}]
[]
[null,{"$f":"B260","v":"Proposed : Tariff V - Bairnsdale - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$G$53:$G$57,C$38)","v":13410.5244},{"$f":"INDEX(Prop2020DistTar!$G$53:$G$57,D$38)","v":23804.740004388808},{"$f":"INDEX(Prop2020DistTar!$G$53:$G$57,E$38)","v":86524.660878701121},{"$f":"INDEX(Prop2020DistTar!$G$53:$G$57,F$38)","v":50480.865304672123},{"$f":"INDEX(Prop2020DistTar!$G$53:$G$57,G$38)","v":75989.504612301258}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B264","v":"Existing : Tariff V - Bairnsdale - Non Residential"},{"$f":"SUM(C264:G264)","v":245580.97020291939}]
[null,{"$f":"B266","v":"Proposed : Tariff V - Bairnsdale - Non Residential"},{"$f":"SUM(C266:G266)","v":250210.29520006332}]
[]
[null,"Average price movement",{"$f":"IF(C270=0,\"\",C270/C269)","v":1.018850503739434}]
[]
[null,{"$f":"IF(C272=\"\",\"\",IF(C272<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2020DistTar!B59","v":"Tariff D -  AGN Central"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2020DistTar!C59","v":"Existing: Tariff D -  AGN Central"},{"$f":"INDEX(Prop2020DistTar!$E$60:$E$62,C279)","v":1429.5715},{"$f":"INDEX(Prop2020DistTar!$E$60:$E$62,D279)","v":873.94849999999997},{"$f":"INDEX(Prop2020DistTar!$E$60:$E$62,E279)","v":159.601}]
[null,{"$f":"\"Proposed: \"&B278","v":"Proposed: Tariff D -  AGN Central"},{"$f":"INDEX(Prop2020DistTar!$D$60:$D$62,C279)","v":1461.0057999999999},{"$f":"INDEX(Prop2020DistTar!$D$60:$D$62,D279)","v":893.16539999999998},{"$f":"INDEX(Prop2020DistTar!$D$60:$D$62,E279)","v":163.1104}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B281","v":"Existing: Tariff D -  AGN Central"},{"$f":"INDEX(Prop2020DistTar!$F$60:$F$62,C$38)","v":1452.2920000000001},{"$f":"INDEX(Prop2020DistTar!$F$60:$F$62,D$38)","v":1249.9424000000004},{"$f":"INDEX(Prop2020DistTar!$F$60:$F$62,E$38)","v":1420.239}]
[null,{"$f":"B282","v":"Proposed: Tariff D -  AGN Central"},{"$f":"INDEX(Prop2020DistTar!$F$60:$F$62,C$38)","v":1452.2920000000001},{"$f":"INDEX(Prop2020DistTar!$F$60:$F$62,D$38)","v":1249.9424000000004},{"$f":"INDEX(Prop2020DistTar!$F$60:$F$62,E$38)","v":1420.239}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B285","v":"Existing: Tariff D -  AGN Central"},{"$f":"INDEX(Prop2020DistTar!$H$60:$H$62,C279)","v":2076155.2528780003},{"$f":"INDEX(Prop2020DistTar!$H$60:$H$62,D279)","v":1092385.2855664003},{"$f":"INDEX(Prop2020DistTar!$H$60:$H$62,E279)","v":226671.56463900002}]
[null,{"$f":"B286","v":"Proposed: Tariff D -  AGN Central"},{"$f":"INDEX(Prop2020DistTar!$G$60:$G$62,C279)","v":2121807.0352936001},{"$f":"INDEX(Prop2020DistTar!$G$60:$G$62,D279)","v":1116405.3036729603},{"$f":"INDEX(Prop2020DistTar!$G$60:$G$62,E279)","v":231655.75138560002}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B289","v":"Existing: Tariff D -  AGN Central"},{"$f":"SUM(C289:E289)","v":3395212.103083401}]
[null,{"$f":"B290","v":"Proposed: Tariff D -  AGN Central"},{"$f":"SUM(C290:E290)","v":3469868.0903521604}]
[]
[null,"Average price movement",{"$f":"IF(C294=0,\"\",C294/C293)","v":1.0219886077812221}]
[]
[null,{"$f":"IF(C296=\"\",\"\",IF(C296<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2020DistTar!B64","v":"Tariff D - AGN North"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2020DistTar!C64","v":"Existing: Tariff D - AGN North"},{"$f":"INDEX(Prop2020DistTar!$E$65:$E$67,C303)","v":1429.5715},{"$f":"INDEX(Prop2020DistTar!$E$65:$E$67,D303)","v":873.94849999999997},{"$f":"INDEX(Prop2020DistTar!$E$65:$E$67,E303)","v":159.601}]
[null,{"$f":"\"Proposed: \"&B302","v":"Proposed: Tariff D - AGN North"},{"$f":"INDEX(Prop2020DistTar!$D$65:$D$67,C303)","v":1461.0057999999999},{"$f":"INDEX(Prop2020DistTar!$D$65:$D$67,D303)","v":893.16539999999998},{"$f":"INDEX(Prop2020DistTar!$D$65:$D$67,E303)","v":163.1104}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B305","v":"Existing: Tariff D - AGN North"},{"$f":"INDEX(Prop2020DistTar!$F$65:$F$67,C$38)","v":434.14239999999995},{"$f":"INDEX(Prop2020DistTar!$F$65:$F$67,D$38)","v":627.2100999999999},{"$f":"INDEX(Prop2020DistTar!$F$65:$F$67,E$38)","v":440.21849999999995}]
[null,{"$f":"B306","v":"Proposed: Tariff D - AGN North"},{"$f":"INDEX(Prop2020DistTar!$F$65:$F$67,C$38)","v":434.14239999999995},{"$f":"INDEX(Prop2020DistTar!$F$65:$F$67,D$38)","v":627.2100999999999},{"$f":"INDEX(Prop2020DistTar!$F$65:$F$67,E$38)","v":440.21849999999995}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B309","v":"Existing: Tariff D - AGN North"},{"$f":"INDEX(Prop2020DistTar!$H$65:$H$67,C303)","v":620637.60198159993},{"$f":"INDEX(Prop2020DistTar!$H$65:$H$67,D303)","v":548149.32607984985},{"$f":"INDEX(Prop2020DistTar!$H$65:$H$67,E303)","v":70259.312818499995}]
[null,{"$f":"B310","v":"Proposed: Tariff D - AGN North"},{"$f":"INDEX(Prop2020DistTar!$G$65:$G$67,C303)","v":634284.5644259199},{"$f":"INDEX(Prop2020DistTar!$G$65:$G$67,D303)","v":560202.35985053994},{"$f":"INDEX(Prop2020DistTar!$G$65:$G$67,E303)","v":71804.215622399992}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B313","v":"Existing: Tariff D - AGN North"},{"$f":"SUM(C313:E313)","v":1239046.2408799499}]
[null,{"$f":"B314","v":"Proposed: Tariff D - AGN North"},{"$f":"SUM(C314:E314)","v":1266291.1398988599}]
[]
[null,"Average price movement",{"$f":"IF(C318=0,\"\",C318/C317)","v":1.0219886055257801}]
[]
[null,{"$f":"IF(C320=\"\",\"\",IF(C320<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2020DistTar!B69","v":"Tariff D - Murray Valley"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2020DistTar!C69","v":"Existing: Tariff D - Murray Valley"},{"$f":"INDEX(Prop2020DistTar!$E$70:$E$72,C327)","v":1666.3372999999999},{"$f":"INDEX(Prop2020DistTar!$E$70:$E$72,D327)","v":1028.2353000000001},{"$f":"INDEX(Prop2020DistTar!$E$70:$E$72,E327)","v":175.1266}]
[null,{"$f":"\"Proposed: \"&B326","v":"Proposed: Tariff D - Murray Valley"},{"$f":"INDEX(Prop2020DistTar!$D$70:$D$72,C327)","v":1702.9776999999999},{"$f":"INDEX(Prop2020DistTar!$D$70:$D$72,D327)","v":1050.8447000000001},{"$f":"INDEX(Prop2020DistTar!$D$70:$D$72,E327)","v":178.97739999999999}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B329","v":"Existing: Tariff D - Murray Valley"},{"$f":"INDEX(Prop2020DistTar!$F$70:$F$72,C$38)","v":68.235900000000001},{"$f":"INDEX(Prop2020DistTar!$F$70:$F$72,D$38)","v":163.20350000000002},{"$f":"INDEX(Prop2020DistTar!$F$70:$F$72,E$38)","v":102.5181}]
[null,{"$f":"B330","v":"Proposed: Tariff D - Murray Valley"},{"$f":"INDEX(Prop2020DistTar!$F$70:$F$72,C$38)","v":68.235900000000001},{"$f":"INDEX(Prop2020DistTar!$F$70:$F$72,D$38)","v":163.20350000000002},{"$f":"INDEX(Prop2020DistTar!$F$70:$F$72,E$38)","v":102.5181}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B333","v":"Existing: Tariff D - Murray Valley"},{"$f":"INDEX(Prop2020DistTar!$H$70:$H$72,C327)","v":113704.02536906999},{"$f":"INDEX(Prop2020DistTar!$H$70:$H$72,D327)","v":167811.59978355002},{"$f":"INDEX(Prop2020DistTar!$H$70:$H$72,E327)","v":17953.646291460002}]
[null,{"$f":"B334","v":"Proposed: Tariff D - Murray Valley"},{"$f":"INDEX(Prop2020DistTar!$G$70:$G$72,C327)","v":116204.21603943},{"$f":"INDEX(Prop2020DistTar!$G$70:$G$72,D327)","v":171501.53299645003},{"$f":"INDEX(Prop2020DistTar!$G$70:$G$72,E327)","v":18348.422990939998}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B337","v":"Existing: Tariff D - Murray Valley"},{"$f":"SUM(C337:E337)","v":299469.27144408005}]
[null,{"$f":"B338","v":"Proposed: Tariff D - Murray Valley"},{"$f":"SUM(C338:E338)","v":306054.17202682002}]
[]
[null,"Average price movement",{"$f":"IF(C342=0,\"\",C342/C341)","v":1.0219885684797867}]
[]
[null,{"$f":"IF(C344=\"\",\"\",IF(C344<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2020DistTar!B74","v":"Tariff D - Bairnsdale"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2020DistTar!C74","v":"Existing: Tariff D - Bairnsdale"},{"$f":"INDEX(Prop2020DistTar!$E$75:$E$77,C351)","v":2364.7031000000002},{"$f":"INDEX(Prop2020DistTar!$E$75:$E$77,D351)","v":1464.9434000000001},{"$f":"INDEX(Prop2020DistTar!$E$75:$E$77,E351)","v":267.17239999999998}]
[null,{"$f":"\"Proposed: \"&B350","v":"Proposed: Tariff D - Bairnsdale"},{"$f":"INDEX(Prop2020DistTar!$D$75:$D$77,C351)","v":2416.6995999999999},{"$f":"INDEX(Prop2020DistTar!$D$75:$D$77,D351)","v":1497.1554000000001},{"$f":"INDEX(Prop2020DistTar!$D$75:$D$77,E351)","v":273.0471}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B353","v":"Existing: Tariff D - Bairnsdale"},{"$f":"INDEX(Prop2020DistTar!$F$75:$F$77,C$38)","v":15.391300000000001},{"$f":"INDEX(Prop2020DistTar!$F$75:$F$77,D$38)","v":3.6834000000000007},{"$f":"INDEX(Prop2020DistTar!$F$75:$F$77,E$38)","v":0}]
[null,{"$f":"B354","v":"Proposed: Tariff D - Bairnsdale"},{"$f":"INDEX(Prop2020DistTar!$F$75:$F$77,C$38)","v":15.391300000000001},{"$f":"INDEX(Prop2020DistTar!$F$75:$F$77,D$38)","v":3.6834000000000007},{"$f":"INDEX(Prop2020DistTar!$F$75:$F$77,E$38)","v":0}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B357","v":"Existing: Tariff D - Bairnsdale"},{"$f":"INDEX(Prop2020DistTar!$H$75:$H$77,C351)","v":36395.854823030008},{"$f":"INDEX(Prop2020DistTar!$H$75:$H$77,D351)","v":5395.9725195600013},{"$f":"INDEX(Prop2020DistTar!$H$75:$H$77,E351)","v":0}]
[null,{"$f":"B358","v":"Proposed: Tariff D - Bairnsdale"},{"$f":"INDEX(Prop2020DistTar!$G$75:$G$77,C351)","v":37196.148553480001},{"$f":"INDEX(Prop2020DistTar!$G$75:$G$77,D351)","v":5514.6222003600014},{"$f":"INDEX(Prop2020DistTar!$G$75:$G$77,E351)","v":0}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B361","v":"Existing: Tariff D - Bairnsdale"},{"$f":"SUM(C361:E361)","v":41791.827342590012}]
[null,{"$f":"B362","v":"Proposed: Tariff D - Bairnsdale"},{"$f":"SUM(C362:E362)","v":42710.770753839999}]
[]
[null,"Average price movement",{"$f":"IF(C366=0,\"\",C366/C365)","v":1.021988591303197}]
[]
[null,{"$f":"IF(C368=\"\",\"\",IF(C368<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2020DistTar!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 : \"&Prop2020DistTar!C79","v":"Existing : Tariff V - Albury - Residential"},{"$f":"INDEX(Prop2020DistTar!$E$81:$E$84,C$39)","v":0.24729999999999999},{"$f":"INDEX(Prop2020DistTar!$E$81:$E$84,D$39)","v":8.3042999999999996},{"$f":"INDEX(Prop2020DistTar!$E$81:$E$84,E$39)","v":5.0669000000000004},{"$f":"INDEX(Prop2020DistTar!$E$81:$E$84,F$39)","v":2.7824}]
[]
[null,{"$f":"\"Proposed : \"&B374","v":"Proposed : Tariff V - Albury - Residential"},{"$f":"INDEX(Prop2020DistTar!$D$81:$D$84,C$38)","v":0.25119999999999998},{"$f":"INDEX(Prop2020DistTar!$D$81:$D$84,D$38)","v":8.6120000000000001},{"$f":"INDEX(Prop2020DistTar!$D$81:$D$84,E$38)","v":5.1475999999999997},{"$f":"INDEX(Prop2020DistTar!$D$81:$D$84,F$38)","v":2.8267000000000002}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B378","v":"Existing : Tariff V - Albury - Residential"},{"$f":"INDEX(Prop2020DistTar!$F$81:$F$84,C$38)","v":8074668},{"$f":"INDEX(Prop2020DistTar!$F$81:$F$84,D$38)","v":182816.31088578256},{"$f":"INDEX(Prop2020DistTar!$F$81:$F$84,E$38)","v":107334.76385032204},{"$f":"INDEX(Prop2020DistTar!$F$81:$F$84,F$38)","v":679508.24242366059}]
[]
[null,{"$f":"B380","v":"Proposed : Tariff V - Albury - Residential"},{"$f":"INDEX(Prop2020DistTar!$F$81:$F$84,C$38)","v":8074668},{"$f":"INDEX(Prop2020DistTar!$F$81:$F$84,D$38)","v":182816.31088578256},{"$f":"INDEX(Prop2020DistTar!$F$81:$F$84,E$38)","v":107334.76385032204},{"$f":"INDEX(Prop2020DistTar!$F$81:$F$84,F$38)","v":679508.24242366059}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B384","v":"Existing : Tariff V - Albury - Residential"},{"$f":"INDEX(Prop2020DistTar!$H$81:$H$84,C$39)","v":1996865.3964},{"$f":"INDEX(Prop2020DistTar!$H$81:$H$84,D$39)","v":1518161.4904888039},{"$f":"INDEX(Prop2020DistTar!$H$81:$H$84,E$39)","v":543854.51495319675},{"$f":"INDEX(Prop2020DistTar!$H$81:$H$84,F$39)","v":1890663.7337195931}]
[]
[null,{"$f":"B386","v":"Proposed : Tariff V - Albury - Residential"},{"$f":"INDEX(Prop2020DistTar!$G$81:$G$84,C$38)","v":2028356.6015999999},{"$f":"INDEX(Prop2020DistTar!$G$81:$G$84,D$38)","v":1574414.0693483595},{"$f":"INDEX(Prop2020DistTar!$G$81:$G$84,E$38)","v":552516.43039591773},{"$f":"INDEX(Prop2020DistTar!$G$81:$G$84,F$38)","v":1920765.9488589615}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B390","v":"Existing : Tariff V - Albury - Residential"},{"$f":"SUM(C390:G390)","v":5949545.1355615938}]
[null,{"$f":"B392","v":"Proposed : Tariff V - Albury - Residential"},{"$f":"SUM(C392:G392)","v":6076053.0502032386}]
[]
[null,"Average price movement",{"$f":"IF(C396=0,\"\",C396/C395)","v":1.0212634599383879}]
[]
[null,{"$f":"IF(C398=\"\",\"\",IF(C398<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2020DistTar!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 : \"&Prop2020DistTar!C85","v":"Existing : Tariff V - Albury - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$E$87:$E$91,C$39)","v":0.24729999999999999},{"$f":"INDEX(Prop2020DistTar!$E$87:$E$91,D$39)","v":6.2215999999999996},{"$f":"INDEX(Prop2020DistTar!$E$87:$E$91,E$39)","v":3.0537999999999998},{"$f":"INDEX(Prop2020DistTar!$E$87:$E$91,F$39)","v":2.1728000000000001},{"$f":"INDEX(Prop2020DistTar!$E$87:$E$91,G$39)","v":0.88080000000000003}]
[]
[null,{"$f":"\"Proposed : \"&B404","v":"Proposed : Tariff V - Albury - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$D$87:$D$91,C$38)","v":0.25119999999999998},{"$f":"INDEX(Prop2020DistTar!$D$87:$D$91,D$38)","v":6.3207000000000004},{"$f":"INDEX(Prop2020DistTar!$D$87:$D$91,E$38)","v":3.121},{"$f":"INDEX(Prop2020DistTar!$D$87:$D$91,F$38)","v":2.2162999999999999},{"$f":"INDEX(Prop2020DistTar!$D$87:$D$91,G$38)","v":0.89490000000000003}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B408","v":"Existing : Tariff V - Albury - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$F$87:$F$91,C$38)","v":337460},{"$f":"INDEX(Prop2020DistTar!$F$87:$F$91,D$38)","v":11053.69385398299},{"$f":"INDEX(Prop2020DistTar!$F$87:$F$91,E$38)","v":56720.669007782002},{"$f":"INDEX(Prop2020DistTar!$F$87:$F$91,F$38)","v":41383.913578436994},{"$f":"INDEX(Prop2020DistTar!$F$87:$F$91,G$38)","v":178425.80578475806}]
[]
[null,{"$f":"B410","v":"Proposed : Tariff V - Albury - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$F$87:$F$91,C$38)","v":337460},{"$f":"INDEX(Prop2020DistTar!$F$87:$F$91,D$38)","v":11053.69385398299},{"$f":"INDEX(Prop2020DistTar!$F$87:$F$91,E$38)","v":56720.669007782002},{"$f":"INDEX(Prop2020DistTar!$F$87:$F$91,F$38)","v":41383.913578436994},{"$f":"INDEX(Prop2020DistTar!$F$87:$F$91,G$38)","v":178425.80578475806}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B414","v":"Existing : Tariff V - Albury - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$H$87:$H$91,C$39)","v":83453.857999999993},{"$f":"INDEX(Prop2020DistTar!$H$87:$H$91,D$39)","v":68771.661681940561},{"$f":"INDEX(Prop2020DistTar!$H$87:$H$91,E$39)","v":173213.57901596467},{"$f":"INDEX(Prop2020DistTar!$H$87:$H$91,F$39)","v":89918.967423227907},{"$f":"INDEX(Prop2020DistTar!$H$87:$H$91,G$39)","v":157157.4497352149}]
[]
[null,{"$f":"B416","v":"Proposed : Tariff V - Albury - Non Residential"},{"$f":"INDEX(Prop2020DistTar!$G$87:$G$91,C$38)","v":84769.95199999999},{"$f":"INDEX(Prop2020DistTar!$G$87:$G$91,D$38)","v":69867.082742870291},{"$f":"INDEX(Prop2020DistTar!$G$87:$G$91,E$38)","v":177025.20797328762},{"$f":"INDEX(Prop2020DistTar!$G$87:$G$91,F$38)","v":91719.167663889908},{"$f":"INDEX(Prop2020DistTar!$G$87:$G$91,G$38)","v":159673.25359678001}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B420","v":"Existing : Tariff V - Albury - Non Residential"},{"$f":"SUM(C420:G420)","v":572515.51585634798}]
[null,{"$f":"B422","v":"Proposed : Tariff V - Albury - Non Residential"},{"$f":"SUM(C422:G422)","v":583054.66397682787}]
[]
[null,"Average price movement",{"$f":"IF(C426=0,\"\",C426/C425)","v":1.0184084934444366}]
[]
[null,{"$f":"IF(C428=\"\",\"\",IF(C428<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2020DistTar!B93","v":"Tariff D - Albury"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2020DistTar!C93","v":"Existing: Tariff D - Albury"},{"$f":"INDEX(Prop2020DistTar!$E$94:$E$96,C435)","v":1229.4321},{"$f":"INDEX(Prop2020DistTar!$E$94:$E$96,D435)","v":763.59019999999998},{"$f":"INDEX(Prop2020DistTar!$E$94:$E$96,E435)","v":184.5128}]
[null,{"$f":"\"Proposed: \"&B434","v":"Proposed: Tariff D - Albury"},{"$f":"INDEX(Prop2020DistTar!$D$94:$D$96,C435)","v":1256.4656},{"$f":"INDEX(Prop2020DistTar!$D$94:$D$96,D435)","v":780.38049999999998},{"$f":"INDEX(Prop2020DistTar!$D$94:$D$96,E435)","v":188.63499999999999}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B437","v":"Existing: Tariff D - Albury"},{"$f":"INDEX(Prop2020DistTar!$F$94:$F$96,C$38)","v":50.052},{"$f":"INDEX(Prop2020DistTar!$F$94:$F$96,D$38)","v":102.7889},{"$f":"INDEX(Prop2020DistTar!$F$94:$F$96,E$38)","v":197.36599999999999}]
[null,{"$f":"B438","v":"Proposed: Tariff D - Albury"},{"$f":"INDEX(Prop2020DistTar!$F$94:$F$96,C$38)","v":50.052},{"$f":"INDEX(Prop2020DistTar!$F$94:$F$96,D$38)","v":102.7889},{"$f":"INDEX(Prop2020DistTar!$F$94:$F$96,E$38)","v":197.36599999999999}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B441","v":"Existing: Tariff D - Albury"},{"$f":"INDEX(Prop2020DistTar!$H$94:$H$96,C435)","v":61535.535469199996},{"$f":"INDEX(Prop2020DistTar!$H$94:$H$96,D435)","v":78488.596708779995},{"$f":"INDEX(Prop2020DistTar!$H$94:$H$96,E435)","v":36416.5532848}]
[null,{"$f":"B442","v":"Proposed: Tariff D - Albury"},{"$f":"INDEX(Prop2020DistTar!$G$94:$G$96,C435)","v":62888.616211200002},{"$f":"INDEX(Prop2020DistTar!$G$94:$G$96,D435)","v":80214.453176449999},{"$f":"INDEX(Prop2020DistTar!$G$94:$G$96,E435)","v":37230.135409999995}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B445","v":"Existing: Tariff D - Albury"},{"$f":"SUM(C445:E445)","v":176440.68546277998}]
[null,{"$f":"B446","v":"Proposed: Tariff D - Albury"},{"$f":"SUM(C446:E446)","v":180333.20479764999}]
[]
[null,"Average price movement",{"$f":"IF(C450=0,\"\",C450/C449)","v":1.0220613478385694}]
[]
[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":2019},{"$f":"'Model update'!$B$5","v":2020}]
["Meter and Gas Installation Test ",218,{"$f":"ROUND(B6*(1+'Model update'!$B$30),0)","v":221}]
["Disconnection",72,{"$f":"ROUND(B7*(1+'Model update'!$B$30),0)","v":73}]
["Reconnection",84,{"$f":"ROUND(B8*(1+'Model update'!$B$30),0)","v":85}]
["Meter Removal",102,{"$f":"ROUND(B9*(1+'Model update'!$B$30),0)","v":104}]
["Meter Reinstallation",102,{"$f":"ROUND(B10*(1+'Model update'!$B$30),0)","v":104}]
["Special Meter Read - Metropolitan",9.1999999999999993,{"$f":"ROUND(B11*(1+'Model update'!$B$30),1)","v":9.3000000000000007}]
["Special Meter Read - Non Metropolitan",12.6,{"$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: 2020 formula is as per AA2018-22, Section 4.4.2, p9 : ART = ARTt-1 * (1+CPI)"}]