{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Model update","Prop2019DistTar","2019TarContForm","2019RebalContForm","ARS"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Model update","index":0,"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",2019]
[]
["t",{"$f":"B5","v":2019}]
["t-1",{"$f":"B7-1","v":2018}]
["t-2",2017]
["t-3",2016]
[]
[]
["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"]
["CPI Index June 2020"]
["CPI Index June 2021"]
[]
[]
[{"$f":"\"CPI Index June \" &$B$10","v":"CPI Index June 2016"},{"$f":"VLOOKUP(A25,A$17:B$22,2,FALSE)","v":108.6}]
[{"$f":"\"CPI Index June \" &$B$9","v":"CPI Index June 2017"},{"$f":"VLOOKUP(A26,A$17:B$22,2,FALSE)","v":110.7}]
[{"$f":"\"CPI Index June \" &$B$8","v":"CPI Index June 2018"},{"$f":"VLOOKUP(A27,A$17:B$22,2,FALSE)","v":113}]
[]
[{"$f":"\"CPI \" &$B$8","v":"CPI 2018"},{"$f":"B26/B25-1","v":1.9337016574585641E-2}]
[{"$f":"\"CPI \" &$B$5","v":"CPI 2019"},{"$f":"B27/B26-1","v":2.0776874435411097E-2}]
[]
[]
[{"$f":"\"Xt for \"&B$5","v":"Xt for 2019"}]
[2019,-1.2932003198752101E-2]
[2020,-1.35E-2]
[2021,-1.35E-2]
[2022,-1.35E-2]
[]
[]
[{"$f":"\"Xt for \"&B$5","v":"Xt for 2019"},{"$f":"VLOOKUP(B5,A34:B38,2,FALSE)","v":-1.2932003198752101E-2}]
[]
[]
["Pass Through Amounts :  PT (t)"]
[2019,0]
[2020,0]
[2021,0]
[2022,0]
[]
[]
[{"$f":"\"Pass Through Amount for \"&B$5","v":"Pass Through Amount for 2019"},{"$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.8426924098434956E-2]

{"sheet":"Prop2019DistTar","index":1,"n_rows":99,"n_cols":8,"rows_kept":99,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"\"Tariff Approval - \"&'Model update'!B3","v":"Tariff Approval - Aust. Gas Networks (Vic & Albury)"}]
[]
[null,{"$f":"\"PROPOSED \"&'Model update'!$B$5&\" DISTRIBUTION TARIFFS\"","v":"PROPOSED 2019 DISTRIBUTION TARIFFS"}]
[]
[null,"Proposed tariff name","Existing tariff name","Prop\n2019 Tariff","Exist\n2018 Tariff","Actual 2017 Volumes","Prop Tar\nRevenue","Exist Tar\nRevenue"]
[null,"Tariff V - AGN Central - Residential","Tariff V - AGN Central - Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.19009999999999999,0.1862,194438385,{"$f":"D8*$F8","v":36962736.988499999},{"$f":"E8*$F8","v":36204427.287}]
[null,"GJ 0 - 0.0274","GJ 0 - 0.0274",11.467599999999999,10.724399999999999,4704142.8474926082,{"$f":"D9*$F9","v":53945228.517906234},{"$f":"E9*$F9","v":50449109.553649724}]
[null,"GJ 0.0274 - 0.0493","GJ 0.0274 - 0.0493",6.7305999999999999,6.5936000000000003,3019087.7205201131,{"$f":"D10*$F10","v":20320271.811732672},{"$f":"E10*$F10","v":19906656.79402142}]
[null,"GJ > 0.0493","GJ > 0.0493",3.6949000000000001,3.6196999999999999,18939948.234109078,69981214.730209634,68556930.62300463]
[null,"Tariff V - AGN Central - Non Residential","Tariff V - AGN Central - Non Residential",null,null,26663178.802121799]
[]
[null,"Fixed Charge","Fixed Charge",0.19009999999999999,0.1862,7272382,{"$f":"D14*$F14","v":1382479.8181999999},{"$f":"E14*$F14","v":1354117.5284}]
[null,"GJ 0 - 0.05","GJ 0 - 0.05",8.2632999999999992,7.7278000000000002,269661.67627303291,{"$f":"D15*$F15","v":2228295.3295469526},2083891.5019027437]
[null,"GJ 0.05 - 0.55","GJ 0.05 - 0.55",3.8769,3.798,1428561.6535620149,5538390.6746945754,5425677.1602285327]
[null,"GJ 0.55 - 1.37","GJ 0.55 - 1.37",2.8973,2.8382999999999998,1117989.3929096402,3239150.6680771005,3173189.2938954318]
[null,"GJ > 1.37","GJ > 1.37",1.1749000000000001,1.151,4069892.5481019528,4781716.7547649844,4684446.3228653474]
[null,"Tariff V - AGN North - Residential","Tariff V - AGN North - Residential",null,null,6886105.2708466407]
[]
[null,"Fixed Charge","Fixed Charge",0.19009999999999999,0.1862,27518961,{"$f":"D21*$F21","v":5231354.4860999994},{"$f":"E21*$F21","v":5124030.5382000003}]
[null,"GJ 0 - 0.0274","GJ 0 - 0.0274",10.089700000000001,9.4358000000000004,639501.84695019631,{"$f":"D22*$F22","v":6452381.7851733956},6034211.5274526626]
[null,"GJ 0.0274 - 0.0493","GJ 0.0274 - 0.0493",6.0290999999999997,5.9063999999999997,389854.0995849325,2350469.3518075165,2302634.2537884451]
[null,"GJ > 0.0493","GJ > 0.0493",3.3102,3.2427999999999999,2641770.6495225122,8744789.2040494196,8566733.8622716032]
[null,"Tariff V - AGN North - Non Residential","Tariff V - AGN North - Non Residential",null,null,3671126.5960576413]
[]
[null,"Fixed Charge","Fixed Charge",0.19009999999999999,0.1862,1187017,{"$f":"D27*$F27","v":225651.93169999999},{"$f":"E27*$F27","v":221022.56539999999}]
[null,"GJ 0 - 0.05","GJ 0 - 0.05",7.4122000000000003,6.9318,37831.814903191,{"$f":"D28*$F28","v":280416.97842543235},262242.57454593939]
[null,"GJ 0.05 - 0.55","GJ 0.05 - 0.55",3.5038,3.4325000000000001,184497.15983377551,646441.14862558269,633286.50112943444]
[null,"GJ 0.55 - 1.37","GJ 0.55 - 1.37",2.6183000000000001,2.5649999999999999,125529.1123302951,328672.87481441168,321982.17312720692]
[null,"GJ > 1.37","GJ > 1.37",1.0617000000000001,1.0401,473113.72231482749,502304.8389816524,492085.58257965208]
[null,"Tariff V - Murray Valley - Residential","Tariff V - Murray Valley - Residential",null,null,820971.80938208918]
[]
[null,"Fixed Charge","Fixed Charge",0.2419,0.23699999999999999,2846787,{"$f":"D34*$F34","v":688637.77529999998},{"$f":"E34*$F34","v":674688.51899999997}]
[null,"GJ 0 - 0.0274","GJ 0 - 0.0274",8.7843,8.2149999999999999,56332.215050547529,{"$f":"D35*$F35","v":494839.07666852465},462769.14664024796]
[null,"GJ 0.0274 - 0.0493","GJ 0.0274 - 0.0493",5.4246999999999996,5.3143000000000002,30747.311906243045,166794.94289779663,163400.43966334741]
[null,"GJ > 0.0493","GJ > 0.0493",3.3934000000000002,3.3243,202036.38845941913,685590.28059819294,671629.56615564704]
[null,"Tariff V - Murray Valley - Non Residential","Tariff V - Murray Valley - Non Residential",null,null,289115.91541620973]
[]
[null,"Fixed Charge","Fixed Charge",0.2419,0.23699999999999999,125998,{"$f":"D40*$F40","v":30478.9162},{"$f":"E40*$F40","v":29861.525999999998}]
[null,"GJ 0 - 0.05","GJ 0 - 0.05",6.6273999999999997,6.1978999999999997,4424.8102404030024,{"$f":"D41*$F41","v":29324.987387246856},27424.531388993768]
[null,"GJ 0.05 - 0.55","GJ 0.05 - 0.55",3.8910999999999998,3.8119000000000001,20965.222197847972,81577.776094046232,79917.330495976683]
[null,"GJ 0.55 - 1.37","GJ 0.55 - 1.37",2.9096000000000002,2.8504,13536.138173602994,39384.747629915277,38583.408250037974]
[null,"GJ > 1.37","GJ > 1.37",1.3224,1.2955000000000001,31825.493754002993,42086.03294029356,41229.927158310878]
[null,"Tariff V - Bairnsdale - Residential","Tariff V - Bairnsdale - Residential",null,null,70751.664365856966]
[]
[null,"Fixed Charge","Fixed Charge",0.31280000000000002,0.30640000000000001,1493889,{"$f":"D47*$F47","v":467288.47920000006},{"$f":"E47*$F47","v":457727.58960000001}]
[null,"GJ 0 - 0.0274","GJ 0 - 0.0274",18.722799999999999,17.509399999999999,29986.527511842723,{"$f":"D48*$F48","v":561431.75729872892},{"$f":"E48*$F48","v":525046.104815859}]
[null,"GJ 0.0274 - 0.0493","GJ 0.0274 - 0.0493",11.116300000000001,10.89,15331.24691661623,170426.74009918101,166957.27892195075]
[null,"GJ > 0.0493","GJ > 0.0493",6.1026999999999996,5.9785000000000004,72694.09364491672,443630.24528683326,434601.63885613461]
[null,"Tariff V - Bairnsdale - Non Residential","Tariff V - Bairnsdale - Non Residential",null,null,118011.86807337568]
[]
[null,"Fixed Charge","Fixed Charge",0.31280000000000002,0.30640000000000001,39321,{"$f":"D53*$F53","v":12299.608800000002},{"$f":"E53*$F53","v":12047.954400000001}]
[null,"GJ 0 - 0.05","GJ 0 - 0.05",13.588100000000001,12.7075,1614.2376307399998,{"$f":"D54*$F54","v":21934.422350258192},{"$f":"E54*$F54","v":20512.924692628545}]
[null,"GJ 0.05 - 0.55","GJ 0.05 - 0.55",6.5850999999999997,6.4511000000000003,12155.849312449995,80047.483307414455,78418.599499546166]
[null,"GJ 0.55 - 1.37","GJ 0.55 - 1.37",4.9194000000000004,4.8193000000000001,10095.529428740003,49663.947471743573,48653.384975926696]
[null,"GJ > 1.37","GJ > 1.37",1.9948999999999999,1.9542999999999999,45489.220243329008,90746.44546341704,88899.583121537871]
[null,null,null,null,null,69354.836615259002]
[null,"Tariff D -  AGN Central","Tariff D -  AGN Central"]
[null,"0 - 10","0 - 10",1429.5715,1381.8195000000001,1467.4216999999999,{"$f":"D60*$F60","v":2097784.24080155},2027711.9197831498]
[null,"10 - 50","10 - 50",873.94849999999997,844.75599999999997,1341.3308,1172254.0406638,1133097.2412848]
[null,"> 50","> 50",159.601,154.2698,1336.6181999999999,213325.60133819998,206199.82239036]
[]
[null,"Tariff D - AGN North","Tariff D - AGN North"]
[null,"0 - 10","0 - 10",1429.5715,1381.8195000000001,437.06389999999999,{"$f":"D65*$F65","v":624814.09511885},603943.41976605006]
[null,"10 - 50","10 - 50",873.94849999999997,844.75599999999997,625.73840000000007,546863.13607240003,528596.26783040003]
[null,"> 50","> 50",159.601,154.2698,505.43940000000003,80668.633679400009,77974.035150120006]
[]
[null,"Tariff D - Murray Valley","Tariff D - Murray Valley"]
[null,"0 - 10","0 - 10",1666.3372999999999,1610.6766,64.920299999999997,{"$f":"D70*$F70","v":108179.11741718999},104565.60807498]
[null,"10 - 50","10 - 50",1028.2353000000001,993.88909999999998,131.62190000000001,135338.28383307002,130817.57173129001]
[null,"> 50","> 50",175.1266,169.27680000000001,126.3329,22124.25124514,21385.22904672]
[]
[null,"Tariff D - Bairnsdale","Tariff D - Bairnsdale"]
[null,"0 - 10","0 - 10",2364.7031000000002,2285.7148000000002,17.319700000000001,{"$f":"D75*$F75","v":40955.948281070006},39587.894621560008]
[null,"10 - 50","10 - 50",1464.9434000000001,1416.0098,3.9206000000000003,5743.4570940400008,5551.6080218800007]
[null,"> 50","> 50",267.17239999999998,258.24799999999999,0,0,0]
[]
[null,"Tariff V - Albury - Residential","Tariff V - Albury - Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.24729999999999999,0.24229999999999999,7897336,{"$f":"D81*$F81","v":1953011.1927999998},{"$f":"E81*$F81","v":1913524.5127999999}]
[null,"GJ 0 - 0.0274","GJ 0 - 0.0274",8.3042999999999996,7.7660999999999998,181185.54128674389,1504619.0905075071,1407105.0321869818]
[null,"GJ 0.0274 - 0.0493","GJ 0.0274 - 0.0493",5.0669000000000004,4.9638,109199.07900232291,553300.81339686993,542042.38835173042]
[null,"GJ > 0.0493","GJ > 0.0493",2.7824,2.7258,719170.63465140236,2001020.3738540618,1960315.3159327926]
[null,"Tariff V - Albury - Non Residential","Tariff V - Albury - Non Residential",null,null,1009555.2549404692]
[]
[null,"Fixed Charge","Fixed Charge",0.24729999999999999,0.24229999999999999,335600,{"$f":"D87*$F87","v":82993.87999999999},81315.87999999999]
[null,"GJ 0 - 0.05","GJ 0 - 0.05",6.2215999999999996,5.8183999999999996,11288.751835738014,70234.098421227623,65682.473681058051]
[null,"GJ 0.05 - 0.55","GJ 0.05 - 0.55",3.0537999999999998,2.9916,58602.418625916005,178960.06599982228,175314.99556129033]
[null,"GJ 0.55 - 1.37","GJ 0.55 - 1.37",2.1728000000000001,2.1286,42526.967890955952,92402.595833469095,90522.903852688847]
[null,"GJ > 1.37","GJ > 1.37",0.88080000000000003,0.8629,172784.30788248617,152188.41838289384,149095.57927179732]
[null,null,null,null,null,285202.44623509614]
[null,"Tariff D - Albury","Tariff D - Albury"]
[null,"0 - 10","0 - 10",1229.4321,1188.3652999999999,48.608400000000003,{"$f":"D94*$F94","v":59760.727289640003},57764.535848519998]
[null,"10 - 50","10 - 50",763.59019999999998,738.08399999999995,100.84530000000001,{"$f":"D95*$F95","v":77004.482796060009},74432.302405199996]
[null,"> 50","> 50",184.5128,178.34950000000001,187.76440000000002,34644.935184320006,33487.686857800007]
[]
[]
[null,"Total Revenue","Total Revenue",null,null,null,{"$f":"SUM(G8:G97)","v":239106343.03831375},{"$f":"SUM(H8:H97)","v":231249079.32155007}]

{"sheet":"2019TarContForm","index":2,"n_rows":44,"n_cols":3,"rows_kept":44,"cut":false,"hidden":false,"merged":[[43,1,43,3]]}
[null,{"$f":"\"Tariff Approval - \"&'Model update'!B3","v":"Tariff Approval - Aust. Gas Networks (Vic & Albury)"}]
[]
[null,{"$f":"'Model update'!$B$5&\"  TARIFF CONTROL FORMULA\"","v":"2019  TARIFF CONTROL FORMULA"}]
[]
[]
[null,"CPI"]
[]
[null,"CPI Index June 2017",{"$f":"'Model update'!B26","v":110.7}]
[null,"CPI Index June 2018",{"$f":"'Model update'!B27","v":113}]
[]
[null,{"$f":"\"CPI \"&'Model update'!$B$5","v":"CPI 2019"},{"$f":"(C9/C8-1)","v":2.0776874435411097E-2}]
[]
[]
[]
[null,"X factor"]
[]
[null,{"$f":"\"X \"&'Model update'!$B$5","v":"X 2019"},{"$f":"'Model update'!B40","v":-1.2932003198752101E-2}]
[]
[]
[null,"Pass Through Factor (PT)"]
[]
[null,"pass through"]
[null,{"$f":"\"AP (t) \"&'Model update'!$B$7","v":"AP (t) 2019"},{"$f":"'Model update'!B50","v":0}]
[]
[null,"Revenue"]
[null,"∑∑p(t-1)q(t-2)",{"$f":"C41","v":231249079.32155007}]
[]
[null,"PT' (t-1)",0]
[null,{"$f":"\"PT' \"&'Model update'!$B$5","v":"PT' 2019"},{"$f":"IF(C26=\"\",0,(C23)/((1+C11)*(1-C17)*C26))","v":0}]
[]
[null,{"$f":"\"PTt \"&'Model update'!$B$5","v":"PTt 2019"},{"$f":"((1+C29)/(1+C28))-1","v":0}]
[]
[]
[]
[]
[null,{"$f":"'Model update'!$B$5&\"  Distribution price control\"","v":"2019  Distribution price control"}]
[]
[null,"Average price movement allowed",{"$f":"(1+C11)*(1-C17)*(1+C31)","v":1.033977564240822}]
[]
[null,"Proposed distribution tariff revenue",{"$f":"IF(Prop2019DistTar!G99=0,\"\",Prop2019DistTar!G99)","v":239106343.03831375}]
[null,"Existing distribution tariff revenue",{"$f":"IF(Prop2019DistTar!H99=0,\"\",Prop2019DistTar!H99)","v":231249079.32155007}]
[null,"Average price movement",{"$f":"IF(C40=\"\",\"\",C40/C41)","v":1.0339774918880356}]
[]
[null,{"$f":"IF(C40=\"\",\"\",IF(C38>=C42,\"DISTRIBUTION PRICE CONTROL FORMULA COMPLIANT\",\"DISTRIBUTION PRICE CONTROL FORMULA BREACHED\"))","v":"DISTRIBUTION PRICE CONTROL FORMULA COMPLIANT"}]

{"sheet":"2019RebalContForm","index":3,"n_rows":454,"n_cols":7,"rows_kept":454,"cut":false,"hidden":false,"merged":[[399,1,399,2],[429,1,429,2],[453,1,453,2],[243,1,243,2],[153,1,153,2],[273,1,273,2],[369,1,369,2],[297,1,297,2],[321,1,321,2],[345,1,345,2],[63,1,63,2],[93,1,93,2],[123,1,123,2],[183,1,183,2],[213,1,213,2]]}
[null,{"$f":"\"Tariff Approval - \"&'Model update'!B3","v":"Tariff Approval - Aust. Gas Networks (Vic & Albury)"}]
[]
[null,{"$f":"'Model update'!$B$5&\"  REBALANCING CONTROL FORMULA\"","v":"2019  REBALANCING CONTROL FORMULA"}]
[]
[]
[null,"Rebalancing control"]
[]
[null,{"$f":"\"CPI \"&'Model update'!$B$5","v":"CPI 2019"},{"$f":"'2019TarContForm'!C11","v":2.0776874435411097E-2}]
[null,{"$f":"\"Y  \"&'Model update'!$B$5","v":"Y  2019"},0.02]
[null,{"$f":"\"PTt \"&'Model update'!$B$5","v":"PTt 2019"},{"$f":"'2019TarContForm'!C29","v":0}]
[null,{"$f":"\"Xt \"&'Model update'!$B$5","v":"Xt 2019"},{"$f":"'2019TarContForm'!C17","v":-1.2932003198752101E-2}]
[]
[null,"Rebalancing control",{"$f":"(1+C8)*(1+C9)*(1+C10)*(1-C11)","v":1.0546571155256386}]
[]
[]
[]
[null,"Rebalancing control summary"]
[null,null,"Existing","Proposed","Movement","Assessment"]
[null,{"$f":"B38","v":"Tariff V - AGN Central - Residential"},{"$f":"C59","v":175117124.25767577},{"$f":"C60","v":181209452.04834855},{"$f":"IF(C19=0,0,D19/C19)","v":1.0347900173469513},{"$f":"IF(E19=0,\"\",IF($C$13<=E19,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B68","v":"Tariff V - AGN North - Residential"},{"$f":"C89","v":22027610.181712709},{"$f":"C90","v":22778994.827130333},{"$f":"IF(C20=0,0,D20/C20)","v":1.0341110378846916},{"$f":"IF(E20=0,\"\",IF($C$13<=E20,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B98","v":"Tariff V - Murray Valley - Residential"},{"$f":"C119","v":1972487.6714592422},{"$f":"C120","v":2035862.0754645141},1.0321291762287099,"Compliant"]
[null,{"$f":"B128","v":"Tariff V - Bairnsdale - Residential"},{"$f":"C149","v":1584332.6121939444},{"$f":"C150","v":1642777.2218847433},1.0368891034881029,"Compliant"]
[null,{"$f":"B158","v":"Tariff V - AGN Central - Non Residential"},{"$f":"C179","v":16721321.807292055},{"$f":"C180","v":17170033.245283611},1.0268346870637868,"Compliant"]
[null,{"$f":"B188","v":"Tariff V - AGN North - Non Residential"},{"$f":"C209","v":1930619.3967822329},{"$f":"C210","v":1983487.772547079},1.0273841523880687,{"$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":217016.72329331934},{"$f":"C240","v":222852.46025150194},1.0268907246852816,"Compliant"]
[null,{"$f":"B248","v":"Tariff V - Bairnsdale - Non Residential"},{"$f":"C269","v":248532.44668963927},{"$f":"C270","v":254691.90739283327},{"$f":"IF(C26=0,0,D26/C26)","v":1.0247833262225345},{"$f":"IF(E26=0,\"\",IF($C$13<=E26,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B278","v":"Tariff D -  AGN Central"},{"$f":"C293","v":3367008.9834583094},{"$f":"C294","v":3483363.8828035495},{"$f":"IF(C27=0,0,D27/C27)","v":1.0345573474608702},{"$f":"IF(E27=0,\"\",IF($C$13<=E27,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B302","v":"Tariff D - AGN North"},{"$f":"C317","v":1210513.7227465701},{"$f":"C318","v":1252345.86487065},1.034557346470361,"Compliant"]
[null,{"$f":"B326","v":"Tariff D - Murray Valley"},{"$f":"C341","v":256768.40885298999},{"$f":"C342","v":265641.65249539999},1.0345573806452579,"Compliant"]
[null,{"$f":"B350","v":"Tariff D - Bairnsdale"},{"$f":"C365","v":45139.502643440006},{"$f":"C366","v":46699.405375110007},1.0345573752549242,"Compliant"]
[null,{"$f":"B374","v":"Tariff V - Albury - Residential"},{"$f":"C395","v":5822987.2492715046},{"$f":"C396","v":6011951.4705584385},1.032451422817485,"Compliant"]
[null,{"$f":"B404","v":"Tariff V - Albury - Non Residential"},{"$f":"C425","v":561931.83236683451},{"$f":"C426","v":576779.05863741273},1.0264217569025096,"Compliant"]
[null,{"$f":"B434","v":"Tariff D - Albury"},{"$f":"C449","v":165684.52511151999},{"$f":"C450","v":171410.14527002},1.0345573622801898,"Compliant"]
[null,null,{"$f":"SUM(C19:C33)","v":231249079.32155004},{"$f":"SUM(D19:D33)","v":239106343.03831375},1.0339774918880358]
[]
[]
[]
[null,{"$f":"Prop2019DistTar!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 : \"&Prop2019DistTar!C6","v":"Existing : Tariff V - AGN Central - Residential"},{"$f":"INDEX(Prop2019DistTar!$E$8:$E$11,C$39)","v":0.1862},{"$f":"INDEX(Prop2019DistTar!$E$8:$E$11,D$39)","v":10.724399999999999},{"$f":"INDEX(Prop2019DistTar!$E$8:$E$11,E$39)","v":6.5936000000000003},{"$f":"INDEX(Prop2019DistTar!$E$8:$E$11,F$39)","v":3.6196999999999999}]
[]
[null,{"$f":"\"Proposed : \"&B38","v":"Proposed : Tariff V - AGN Central - Residential"},{"$f":"INDEX(Prop2019DistTar!$D$8:$D$11,C$38)","v":0.19009999999999999},{"$f":"INDEX(Prop2019DistTar!$D$8:$D$11,D$38)","v":11.467599999999999},{"$f":"INDEX(Prop2019DistTar!$D$8:$D$11,E$38)","v":6.7305999999999999},{"$f":"INDEX(Prop2019DistTar!$D$8:$D$11,F$38)","v":3.6949000000000001}]
[]
[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(Prop2019DistTar!$F$8:$F$11,C$13)","v":194438385},{"$f":"INDEX(Prop2019DistTar!$F$8:$F$11,D$38)","v":4704142.8474926082},{"$f":"INDEX(Prop2019DistTar!$F$8:$F$11,E$38)","v":3019087.7205201131},{"$f":"INDEX(Prop2019DistTar!$F$8:$F$11,F$38)","v":18939948.234109078}]
[]
[null,{"$f":"B44","v":"Proposed : Tariff V - AGN Central - Residential"},{"$f":"INDEX(Prop2019DistTar!$F$8:$F$11,C$38)","v":194438385},{"$f":"INDEX(Prop2019DistTar!$F$8:$F$11,D$38)","v":4704142.8474926082},{"$f":"INDEX(Prop2019DistTar!$F$8:$F$11,E$38)","v":3019087.7205201131},{"$f":"INDEX(Prop2019DistTar!$F$8:$F$11,F$38)","v":18939948.234109078}]
[]
[null,"Distribution revenue",{"$f":"C$40","v":"Fixed"},"Blk1","Blk2","Blk3"]
[]
[null,{"$f":"B48","v":"Existing : Tariff V - AGN Central - Residential"},{"$f":"INDEX(Prop2019DistTar!$H$8:$H$11,C$39)","v":36204427.287},{"$f":"INDEX(Prop2019DistTar!$H$8:$H$11,D$39)","v":50449109.553649724},{"$f":"INDEX(Prop2019DistTar!$H$8:$H$11,E$39)","v":19906656.79402142},{"$f":"INDEX(Prop2019DistTar!$H$8:$H$11,F$39)","v":68556930.62300463}]
[]
[null,{"$f":"B50","v":"Proposed : Tariff V - AGN Central - Residential"},{"$f":"INDEX(Prop2019DistTar!$G$8:$G$11,C$38)","v":36962736.988499999},{"$f":"INDEX(Prop2019DistTar!$G$8:$G$11,D$38)","v":53945228.517906234},{"$f":"INDEX(Prop2019DistTar!$G$8:$G$11,E$38)","v":20320271.811732672},{"$f":"INDEX(Prop2019DistTar!$G$8:$G$11,F$38)","v":69981214.730209634}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B54","v":"Existing : Tariff V - AGN Central - Residential"},{"$f":"SUM(C54:F54)","v":175117124.25767577}]
[null,{"$f":"B56","v":"Proposed : Tariff V - AGN Central - Residential"},{"$f":"SUM(C56:F56)","v":181209452.04834855}]
[]
[null,"Average price movement",{"$f":"IF(C60=0,\"\",C60/C59)","v":1.0347900173469513}]
[]
[null,{"$f":"IF(C62=\"\",\"\",IF(C62<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2019DistTar!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 : \"&Prop2019DistTar!C19","v":"Existing : Tariff V - AGN North - Residential"},{"$f":"INDEX(Prop2019DistTar!$E$21:$E$24,C$39)","v":0.1862},{"$f":"INDEX(Prop2019DistTar!$E$21:$E$24,D$39)","v":9.4358000000000004},{"$f":"INDEX(Prop2019DistTar!$E$21:$E$24,E$39)","v":5.9063999999999997},{"$f":"INDEX(Prop2019DistTar!$E$21:$E$24,F$39)","v":3.2427999999999999}]
[]
[null,{"$f":"\"Proposed : \"&B68","v":"Proposed : Tariff V - AGN North - Residential"},{"$f":"INDEX(Prop2019DistTar!$D$21:$D$24,C$38)","v":0.19009999999999999},{"$f":"INDEX(Prop2019DistTar!$D$21:$D$24,D$38)","v":10.089700000000001},{"$f":"INDEX(Prop2019DistTar!$D$21:$D$24,E$38)","v":6.0290999999999997},{"$f":"INDEX(Prop2019DistTar!$D$21:$D$24,F$38)","v":3.3102}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B72","v":"Existing : Tariff V - AGN North - Residential"},{"$f":"INDEX(Prop2019DistTar!$F$21:$F$24,C$38)","v":27518961},{"$f":"INDEX(Prop2019DistTar!$F$21:$F$24,D$38)","v":639501.84695019631},{"$f":"INDEX(Prop2019DistTar!$F$21:$F$24,E$38)","v":389854.0995849325},{"$f":"INDEX(Prop2019DistTar!$F$21:$F$24,F$38)","v":2641770.6495225122}]
[]
[null,{"$f":"B74","v":"Proposed : Tariff V - AGN North - Residential"},{"$f":"INDEX(Prop2019DistTar!$F$21:$F$24,C$38)","v":27518961},{"$f":"INDEX(Prop2019DistTar!$F$21:$F$24,D$38)","v":639501.84695019631},{"$f":"INDEX(Prop2019DistTar!$F$21:$F$24,E$38)","v":389854.0995849325},{"$f":"INDEX(Prop2019DistTar!$F$21:$F$24,F$38)","v":2641770.6495225122}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B78","v":"Existing : Tariff V - AGN North - Residential"},{"$f":"INDEX(Prop2019DistTar!$H$21:$H$24,C$39)","v":5124030.5382000003},{"$f":"INDEX(Prop2019DistTar!$H$21:$H$24,D$39)","v":6034211.5274526626},{"$f":"INDEX(Prop2019DistTar!$H$21:$H$24,E$39)","v":2302634.2537884451},{"$f":"INDEX(Prop2019DistTar!$H$21:$H$24,F$39)","v":8566733.8622716032}]
[]
[null,{"$f":"B80","v":"Proposed : Tariff V - AGN North - Residential"},{"$f":"INDEX(Prop2019DistTar!$G$21:$G$24,C$38)","v":5231354.4860999994},{"$f":"INDEX(Prop2019DistTar!$G$21:$G$24,D$38)","v":6452381.7851733956},{"$f":"INDEX(Prop2019DistTar!$G$21:$G$24,E$38)","v":2350469.3518075165},{"$f":"INDEX(Prop2019DistTar!$G$21:$G$24,F$38)","v":8744789.2040494196}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B84","v":"Existing : Tariff V - AGN North - Residential"},{"$f":"SUM(C84:F84)","v":22027610.181712709}]
[null,{"$f":"B86","v":"Proposed : Tariff V - AGN North - Residential"},{"$f":"SUM(C86:F86)","v":22778994.827130333}]
[]
[null,"Average price movement",{"$f":"IF(C90=0,\"\",C90/C89)","v":1.0341110378846916}]
[]
[null,{"$f":"IF(C92=\"\",\"\",IF(C92<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2019DistTar!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 : \"&Prop2019DistTar!C32","v":"Existing : Tariff V - Murray Valley - Residential"},{"$f":"INDEX(Prop2019DistTar!$E$34:$E$37,C$39)","v":0.23699999999999999},{"$f":"INDEX(Prop2019DistTar!$E$34:$E$37,D$39)","v":8.2149999999999999},{"$f":"INDEX(Prop2019DistTar!$E$34:$E$37,E$39)","v":5.3143000000000002},{"$f":"INDEX(Prop2019DistTar!$E$34:$E$37,F$39)","v":3.3243}]
[]
[null,{"$f":"\"Proposed : \"&B98","v":"Proposed : Tariff V - Murray Valley - Residential"},{"$f":"INDEX(Prop2019DistTar!$D$34:$D$37,C$38)","v":0.2419},{"$f":"INDEX(Prop2019DistTar!$D$34:$D$37,D$38)","v":8.7843},{"$f":"INDEX(Prop2019DistTar!$D$34:$D$37,E$38)","v":5.4246999999999996},{"$f":"INDEX(Prop2019DistTar!$D$34:$D$37,F$38)","v":3.3934000000000002}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B102","v":"Existing : Tariff V - Murray Valley - Residential"},{"$f":"INDEX(Prop2019DistTar!$F$34:$F$37,C$38)","v":2846787},{"$f":"INDEX(Prop2019DistTar!$F$34:$F$37,D$38)","v":56332.215050547529},{"$f":"INDEX(Prop2019DistTar!$F$34:$F$37,E$38)","v":30747.311906243045},{"$f":"INDEX(Prop2019DistTar!$F$34:$F$37,F$38)","v":202036.38845941913}]
[]
[null,{"$f":"B104","v":"Proposed : Tariff V - Murray Valley - Residential"},{"$f":"INDEX(Prop2019DistTar!$F$34:$F$37,C$38)","v":2846787},{"$f":"INDEX(Prop2019DistTar!$F$34:$F$37,D$38)","v":56332.215050547529},{"$f":"INDEX(Prop2019DistTar!$F$34:$F$37,E$38)","v":30747.311906243045},{"$f":"INDEX(Prop2019DistTar!$F$34:$F$37,F$38)","v":202036.38845941913}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B108","v":"Existing : Tariff V - Murray Valley - Residential"},{"$f":"INDEX(Prop2019DistTar!$H$34:$H$37,C$39)","v":674688.51899999997},{"$f":"INDEX(Prop2019DistTar!$H$34:$H$37,D$39)","v":462769.14664024796},{"$f":"INDEX(Prop2019DistTar!$H$34:$H$37,E$39)","v":163400.43966334741},{"$f":"INDEX(Prop2019DistTar!$H$34:$H$37,F$39)","v":671629.56615564704}]
[]
[null,{"$f":"B110","v":"Proposed : Tariff V - Murray Valley - Residential"},{"$f":"INDEX(Prop2019DistTar!$G$34:$G$37,C$38)","v":688637.77529999998},{"$f":"INDEX(Prop2019DistTar!$G$34:$G$37,D$38)","v":494839.07666852465},{"$f":"INDEX(Prop2019DistTar!$G$34:$G$37,E$38)","v":166794.94289779663},{"$f":"INDEX(Prop2019DistTar!$G$34:$G$37,F$38)","v":685590.28059819294}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B114","v":"Existing : Tariff V - Murray Valley - Residential"},{"$f":"SUM(C114:F114)","v":1972487.6714592422}]
[null,{"$f":"B116","v":"Proposed : Tariff V - Murray Valley - Residential"},{"$f":"SUM(C116:F116)","v":2035862.0754645141}]
[]
[null,"Average price movement",{"$f":"IF(C120=0,\"\",C120/C119)","v":1.0321291762287099}]
[]
[null,{"$f":"IF(C122=\"\",\"\",IF(C122<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2019DistTar!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 : \"&Prop2019DistTar!C45","v":"Existing : Tariff V - Bairnsdale - Residential"},{"$f":"INDEX(Prop2019DistTar!$E$47:$E$50,C$39)","v":0.30640000000000001},{"$f":"INDEX(Prop2019DistTar!$E$47:$E$50,D$39)","v":17.509399999999999},{"$f":"INDEX(Prop2019DistTar!$E$47:$E$50,E$39)","v":10.89},{"$f":"INDEX(Prop2019DistTar!$E$47:$E$50,F$39)","v":5.9785000000000004}]
[]
[null,{"$f":"\"Proposed : \"&B128","v":"Proposed : Tariff V - Bairnsdale - Residential"},{"$f":"INDEX(Prop2019DistTar!$D$47:$D$50,C$38)","v":0.31280000000000002},{"$f":"INDEX(Prop2019DistTar!$D$47:$D$50,D$38)","v":18.722799999999999},{"$f":"INDEX(Prop2019DistTar!$D$47:$D$50,E$38)","v":11.116300000000001},{"$f":"INDEX(Prop2019DistTar!$D$47:$D$50,F$38)","v":6.1026999999999996}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B132","v":"Existing : Tariff V - Bairnsdale - Residential"},{"$f":"INDEX(Prop2019DistTar!$F$47:$F$50,C$38)","v":1493889},{"$f":"INDEX(Prop2019DistTar!$F$47:$F$50,D$38)","v":29986.527511842723},{"$f":"INDEX(Prop2019DistTar!$F$47:$F$50,E$38)","v":15331.24691661623},{"$f":"INDEX(Prop2019DistTar!$F$47:$F$50,F$38)","v":72694.09364491672}]
[]
[null,{"$f":"B134","v":"Proposed : Tariff V - Bairnsdale - Residential"},{"$f":"INDEX(Prop2019DistTar!$F$47:$F$50,C$38)","v":1493889},{"$f":"INDEX(Prop2019DistTar!$F$47:$F$50,D$38)","v":29986.527511842723},{"$f":"INDEX(Prop2019DistTar!$F$47:$F$50,E$38)","v":15331.24691661623},{"$f":"INDEX(Prop2019DistTar!$F$47:$F$50,F$38)","v":72694.09364491672}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B138","v":"Existing : Tariff V - Bairnsdale - Residential"},{"$f":"INDEX(Prop2019DistTar!$H$47:$H$50,C$39)","v":457727.58960000001},{"$f":"INDEX(Prop2019DistTar!$H$47:$H$50,D$39)","v":525046.104815859},{"$f":"INDEX(Prop2019DistTar!$H$47:$H$50,E$39)","v":166957.27892195075},{"$f":"INDEX(Prop2019DistTar!$H$47:$H$50,F$39)","v":434601.63885613461}]
[]
[null,{"$f":"B140","v":"Proposed : Tariff V - Bairnsdale - Residential"},{"$f":"INDEX(Prop2019DistTar!$G$47:$G$50,C$38)","v":467288.47920000006},{"$f":"INDEX(Prop2019DistTar!$G$47:$G$50,D$38)","v":561431.75729872892},{"$f":"INDEX(Prop2019DistTar!$G$47:$G$50,E$38)","v":170426.74009918101},{"$f":"INDEX(Prop2019DistTar!$G$47:$G$50,F$38)","v":443630.24528683326}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B144","v":"Existing : Tariff V - Bairnsdale - Residential"},{"$f":"SUM(C144:F144)","v":1584332.6121939444}]
[null,{"$f":"B146","v":"Proposed : Tariff V - Bairnsdale - Residential"},{"$f":"SUM(C146:F146)","v":1642777.2218847433}]
[]
[null,"Average price movement",{"$f":"IF(C150=0,\"\",C150/C149)","v":1.0368891034881029}]
[]
[null,{"$f":"IF(C152=\"\",\"\",IF(C152<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2019DistTar!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 : \"&Prop2019DistTar!C12","v":"Existing : Tariff V - AGN Central - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$E$14:$E$18,C$39)","v":0.1862},{"$f":"INDEX(Prop2019DistTar!$E$14:$E$18,D$39)","v":7.7278000000000002},{"$f":"INDEX(Prop2019DistTar!$E$14:$E$18,E$39)","v":3.798},{"$f":"INDEX(Prop2019DistTar!$E$14:$E$18,F$39)","v":2.8382999999999998},{"$f":"INDEX(Prop2019DistTar!$E$14:$E$18,G$39)","v":1.151}]
[]
[null,{"$f":"\"Proposed : \"&B158","v":"Proposed : Tariff V - AGN Central - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$D$14:$D$18,C$38)","v":0.19009999999999999},{"$f":"INDEX(Prop2019DistTar!$D$14:$D$18,D$38)","v":8.2632999999999992},{"$f":"INDEX(Prop2019DistTar!$D$14:$D$18,E$38)","v":3.8769},{"$f":"INDEX(Prop2019DistTar!$D$14:$D$18,F$38)","v":2.8973},{"$f":"INDEX(Prop2019DistTar!$D$14:$D$18,G$38)","v":1.1749000000000001}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B162","v":"Existing : Tariff V - AGN Central - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$F$14:$F$18,C$38)","v":7272382},{"$f":"INDEX(Prop2019DistTar!$F$14:$F$18,D$38)","v":269661.67627303291},{"$f":"INDEX(Prop2019DistTar!$F$14:$F$18,E$38)","v":1428561.6535620149},{"$f":"INDEX(Prop2019DistTar!$F$14:$F$18,F$38)","v":1117989.3929096402},{"$f":"INDEX(Prop2019DistTar!$F$14:$F$18,G$38)","v":4069892.5481019528}]
[]
[null,{"$f":"B164","v":"Proposed : Tariff V - AGN Central - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$F$14:$F$18,C$38)","v":7272382},{"$f":"INDEX(Prop2019DistTar!$F$14:$F$18,D$38)","v":269661.67627303291},{"$f":"INDEX(Prop2019DistTar!$F$14:$F$18,E$38)","v":1428561.6535620149},{"$f":"INDEX(Prop2019DistTar!$F$14:$F$18,F$38)","v":1117989.3929096402},{"$f":"INDEX(Prop2019DistTar!$F$14:$F$18,G$38)","v":4069892.5481019528}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B168","v":"Existing : Tariff V - AGN Central - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$H$14:$H$18,C$39)","v":1354117.5284},{"$f":"INDEX(Prop2019DistTar!$H$14:$H$18,D$39)","v":2083891.5019027437},{"$f":"INDEX(Prop2019DistTar!$H$14:$H$18,E$39)","v":5425677.1602285327},{"$f":"INDEX(Prop2019DistTar!$H$14:$H$18,F$39)","v":3173189.2938954318},{"$f":"INDEX(Prop2019DistTar!$H$14:$H$18,G$39)","v":4684446.3228653474}]
[]
[null,{"$f":"B170","v":"Proposed : Tariff V - AGN Central - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$G$14:$G$18,C$38)","v":1382479.8181999999},{"$f":"INDEX(Prop2019DistTar!$G$14:$G$18,D$38)","v":2228295.3295469526},{"$f":"INDEX(Prop2019DistTar!$G$14:$G$18,E$38)","v":5538390.6746945754},{"$f":"INDEX(Prop2019DistTar!$G$14:$G$18,F$38)","v":3239150.6680771005},{"$f":"INDEX(Prop2019DistTar!$G$14:$G$18,G$38)","v":4781716.7547649844}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B174","v":"Existing : Tariff V - AGN Central - Non Residential"},{"$f":"SUM(C174:G174)","v":16721321.807292055}]
[null,{"$f":"B176","v":"Proposed : Tariff V - AGN Central - Non Residential"},{"$f":"SUM(C176:G176)","v":17170033.245283611}]
[]
[null,"Average price movement",{"$f":"IF(C180=0,\"\",C180/C179)","v":1.0268346870637868}]
[]
[null,{"$f":"IF(C182=\"\",\"\",IF(C182<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2019DistTar!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 : \"&Prop2019DistTar!C25","v":"Existing : Tariff V - AGN North - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$E$27:$E$31,C$39)","v":0.1862},{"$f":"INDEX(Prop2019DistTar!$E$27:$E$31,D$39)","v":6.9318},{"$f":"INDEX(Prop2019DistTar!$E$27:$E$31,E$39)","v":3.4325000000000001},{"$f":"INDEX(Prop2019DistTar!$E$27:$E$31,F$39)","v":2.5649999999999999},{"$f":"INDEX(Prop2019DistTar!$E$27:$E$31,G$39)","v":1.0401}]
[]
[null,{"$f":"\"Proposed : \"&B188","v":"Proposed : Tariff V - AGN North - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$D$27:$D$31,C$38)","v":0.19009999999999999},{"$f":"INDEX(Prop2019DistTar!$D$27:$D$31,D$38)","v":7.4122000000000003},{"$f":"INDEX(Prop2019DistTar!$D$27:$D$31,E$38)","v":3.5038},{"$f":"INDEX(Prop2019DistTar!$D$27:$D$31,F$38)","v":2.6183000000000001},{"$f":"INDEX(Prop2019DistTar!$D$27:$D$31,G$38)","v":1.0617000000000001}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B192","v":"Existing : Tariff V - AGN North - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$F$27:$F$31,C$38)","v":1187017},{"$f":"INDEX(Prop2019DistTar!$F$27:$F$31,D$38)","v":37831.814903191},{"$f":"INDEX(Prop2019DistTar!$F$27:$F$31,E$38)","v":184497.15983377551},{"$f":"INDEX(Prop2019DistTar!$F$27:$F$31,F$38)","v":125529.1123302951},{"$f":"INDEX(Prop2019DistTar!$F$27:$F$31,G$38)","v":473113.72231482749}]
[]
[null,{"$f":"B194","v":"Proposed : Tariff V - AGN North - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$F$27:$F$31,C$38)","v":1187017},{"$f":"INDEX(Prop2019DistTar!$F$27:$F$31,D$38)","v":37831.814903191},{"$f":"INDEX(Prop2019DistTar!$F$27:$F$31,E$38)","v":184497.15983377551},{"$f":"INDEX(Prop2019DistTar!$F$27:$F$31,F$38)","v":125529.1123302951},{"$f":"INDEX(Prop2019DistTar!$F$27:$F$31,G$38)","v":473113.72231482749}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B198","v":"Existing : Tariff V - AGN North - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$H$27:$H$31,C$39)","v":221022.56539999999},{"$f":"INDEX(Prop2019DistTar!$H$27:$H$31,D$39)","v":262242.57454593939},{"$f":"INDEX(Prop2019DistTar!$H$27:$H$31,E$39)","v":633286.50112943444},{"$f":"INDEX(Prop2019DistTar!$H$27:$H$31,F$39)","v":321982.17312720692},{"$f":"INDEX(Prop2019DistTar!$H$27:$H$31,G$39)","v":492085.58257965208}]
[]
[null,{"$f":"B200","v":"Proposed : Tariff V - AGN North - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$G$27:$G$31,C$38)","v":225651.93169999999},{"$f":"INDEX(Prop2019DistTar!$G$27:$G$31,D$38)","v":280416.97842543235},{"$f":"INDEX(Prop2019DistTar!$G$27:$G$31,E$38)","v":646441.14862558269},{"$f":"INDEX(Prop2019DistTar!$G$27:$G$31,F$38)","v":328672.87481441168},{"$f":"INDEX(Prop2019DistTar!$G$27:$G$31,G$38)","v":502304.8389816524}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B204","v":"Existing : Tariff V - AGN North - Non Residential"},{"$f":"SUM(C204:G204)","v":1930619.3967822329}]
[null,{"$f":"B206","v":"Proposed : Tariff V - AGN North - Non Residential"},{"$f":"SUM(C206:G206)","v":1983487.772547079}]
[]
[null,"Average price movement",{"$f":"IF(C210=0,\"\",C210/C209)","v":1.0273841523880687}]
[]
[null,{"$f":"IF(C212=\"\",\"\",IF(C212<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2019DistTar!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 : \"&Prop2019DistTar!C38","v":"Existing : Tariff V - Murray Valley - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$E$40:$E$44,C$39)","v":0.23699999999999999},{"$f":"INDEX(Prop2019DistTar!$E$40:$E$44,D$39)","v":6.1978999999999997},{"$f":"INDEX(Prop2019DistTar!$E$40:$E$44,E$39)","v":3.8119000000000001},{"$f":"INDEX(Prop2019DistTar!$E$40:$E$44,F$39)","v":2.8504},{"$f":"INDEX(Prop2019DistTar!$E$40:$E$44,G$39)","v":1.2955000000000001}]
[]
[null,{"$f":"\"Proposed : \"&B218","v":"Proposed : Tariff V - Murray Valley - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$D$40:$D$44,C$38)","v":0.2419},{"$f":"INDEX(Prop2019DistTar!$D$40:$D$44,D$38)","v":6.6273999999999997},{"$f":"INDEX(Prop2019DistTar!$D$40:$D$44,E$38)","v":3.8910999999999998},{"$f":"INDEX(Prop2019DistTar!$D$40:$D$44,F$38)","v":2.9096000000000002},{"$f":"INDEX(Prop2019DistTar!$D$40:$D$44,G$38)","v":1.3224}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B222","v":"Existing : Tariff V - Murray Valley - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$F$40:$F$44,C$38)","v":125998},{"$f":"INDEX(Prop2019DistTar!$F$40:$F$44,D$38)","v":4424.8102404030024},{"$f":"INDEX(Prop2019DistTar!$F$40:$F$44,E$38)","v":20965.222197847972},{"$f":"INDEX(Prop2019DistTar!$F$40:$F$44,F$38)","v":13536.138173602994},{"$f":"INDEX(Prop2019DistTar!$F$40:$F$44,G$38)","v":31825.493754002993}]
[]
[null,{"$f":"B224","v":"Proposed : Tariff V - Murray Valley - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$F$40:$F$44,C$38)","v":125998},{"$f":"INDEX(Prop2019DistTar!$F$40:$F$44,D$38)","v":4424.8102404030024},{"$f":"INDEX(Prop2019DistTar!$F$40:$F$44,E$38)","v":20965.222197847972},{"$f":"INDEX(Prop2019DistTar!$F$40:$F$44,F$38)","v":13536.138173602994},{"$f":"INDEX(Prop2019DistTar!$F$40:$F$44,G$38)","v":31825.493754002993}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B228","v":"Existing : Tariff V - Murray Valley - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$H$40:$H$44,C$39)","v":29861.525999999998},{"$f":"INDEX(Prop2019DistTar!$H$40:$H$44,D$39)","v":27424.531388993768},{"$f":"INDEX(Prop2019DistTar!$H$40:$H$44,E$39)","v":79917.330495976683},{"$f":"INDEX(Prop2019DistTar!$H$40:$H$44,F$39)","v":38583.408250037974},{"$f":"INDEX(Prop2019DistTar!$H$40:$H$44,G$39)","v":41229.927158310878}]
[]
[null,{"$f":"B230","v":"Proposed : Tariff V - Murray Valley - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$G$40:$G$44,C$38)","v":30478.9162},{"$f":"INDEX(Prop2019DistTar!$G$40:$G$44,D$38)","v":29324.987387246856},{"$f":"INDEX(Prop2019DistTar!$G$40:$G$44,E$38)","v":81577.776094046232},{"$f":"INDEX(Prop2019DistTar!$G$40:$G$44,F$38)","v":39384.747629915277},{"$f":"INDEX(Prop2019DistTar!$G$40:$G$44,G$38)","v":42086.03294029356}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B234","v":"Existing : Tariff V - Murray Valley - Non Residential"},{"$f":"SUM(C234:G234)","v":217016.72329331934}]
[null,{"$f":"B236","v":"Proposed : Tariff V - Murray Valley - Non Residential"},{"$f":"SUM(C236:G236)","v":222852.46025150194}]
[]
[null,"Average price movement",{"$f":"IF(C240=0,\"\",C240/C239)","v":1.0268907246852816}]
[]
[null,{"$f":"IF(C242=\"\",\"\",IF(C242<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2019DistTar!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 : \"&Prop2019DistTar!C51","v":"Existing : Tariff V - Bairnsdale - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$E$53:$E$57,C$39)","v":0.30640000000000001},{"$f":"INDEX(Prop2019DistTar!$E$53:$E$57,D$39)","v":12.7075},{"$f":"INDEX(Prop2019DistTar!$E$53:$E$57,E$39)","v":6.4511000000000003},{"$f":"INDEX(Prop2019DistTar!$E$53:$E$57,F$39)","v":4.8193000000000001},{"$f":"INDEX(Prop2019DistTar!$E$53:$E$57,G$39)","v":1.9542999999999999}]
[]
[null,{"$f":"\"Proposed : \"&B248","v":"Proposed : Tariff V - Bairnsdale - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$D$53:$D$57,C$38)","v":0.31280000000000002},{"$f":"INDEX(Prop2019DistTar!$D$53:$D$57,D$38)","v":13.588100000000001},{"$f":"INDEX(Prop2019DistTar!$D$53:$D$57,E$38)","v":6.5850999999999997},{"$f":"INDEX(Prop2019DistTar!$D$53:$D$57,F$38)","v":4.9194000000000004},{"$f":"INDEX(Prop2019DistTar!$D$53:$D$57,G$38)","v":1.9948999999999999}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B252","v":"Existing : Tariff V - Bairnsdale - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$F$53:$F$57,C$38)","v":39321},{"$f":"INDEX(Prop2019DistTar!$F$53:$F$57,D$38)","v":1614.2376307399998},{"$f":"INDEX(Prop2019DistTar!$F$53:$F$57,E$38)","v":12155.849312449995},{"$f":"INDEX(Prop2019DistTar!$F$53:$F$57,F$38)","v":10095.529428740003},{"$f":"INDEX(Prop2019DistTar!$F$53:$F$57,G$38)","v":45489.220243329008}]
[]
[null,{"$f":"B254","v":"Proposed : Tariff V - Bairnsdale - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$F$53:$F$57,C$38)","v":39321},{"$f":"INDEX(Prop2019DistTar!$F$53:$F$57,D$38)","v":1614.2376307399998},{"$f":"INDEX(Prop2019DistTar!$F$53:$F$57,E$38)","v":12155.849312449995},{"$f":"INDEX(Prop2019DistTar!$F$53:$F$57,F$38)","v":10095.529428740003},{"$f":"INDEX(Prop2019DistTar!$F$53:$F$57,G$38)","v":45489.220243329008}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B258","v":"Existing : Tariff V - Bairnsdale - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$H$53:$H$57,C$39)","v":12047.954400000001},{"$f":"INDEX(Prop2019DistTar!$H$53:$H$57,D$39)","v":20512.924692628545},{"$f":"INDEX(Prop2019DistTar!$H$53:$H$57,E$39)","v":78418.599499546166},{"$f":"INDEX(Prop2019DistTar!$H$53:$H$57,F$39)","v":48653.384975926696},{"$f":"INDEX(Prop2019DistTar!$H$53:$H$57,G$39)","v":88899.583121537871}]
[]
[null,{"$f":"B260","v":"Proposed : Tariff V - Bairnsdale - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$G$53:$G$57,C$38)","v":12299.608800000002},{"$f":"INDEX(Prop2019DistTar!$G$53:$G$57,D$38)","v":21934.422350258192},{"$f":"INDEX(Prop2019DistTar!$G$53:$G$57,E$38)","v":80047.483307414455},{"$f":"INDEX(Prop2019DistTar!$G$53:$G$57,F$38)","v":49663.947471743573},{"$f":"INDEX(Prop2019DistTar!$G$53:$G$57,G$38)","v":90746.44546341704}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B264","v":"Existing : Tariff V - Bairnsdale - Non Residential"},{"$f":"SUM(C264:G264)","v":248532.44668963927}]
[null,{"$f":"B266","v":"Proposed : Tariff V - Bairnsdale - Non Residential"},{"$f":"SUM(C266:G266)","v":254691.90739283327}]
[]
[null,"Average price movement",{"$f":"IF(C270=0,\"\",C270/C269)","v":1.0247833262225345}]
[]
[null,{"$f":"IF(C272=\"\",\"\",IF(C272<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2019DistTar!B59","v":"Tariff D -  AGN Central"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2019DistTar!C59","v":"Existing: Tariff D -  AGN Central"},{"$f":"INDEX(Prop2019DistTar!$E$60:$E$62,C279)","v":1381.8195000000001},{"$f":"INDEX(Prop2019DistTar!$E$60:$E$62,D279)","v":844.75599999999997},{"$f":"INDEX(Prop2019DistTar!$E$60:$E$62,E279)","v":154.2698}]
[null,{"$f":"\"Proposed: \"&B278","v":"Proposed: Tariff D -  AGN Central"},{"$f":"INDEX(Prop2019DistTar!$D$60:$D$62,C279)","v":1429.5715},{"$f":"INDEX(Prop2019DistTar!$D$60:$D$62,D279)","v":873.94849999999997},{"$f":"INDEX(Prop2019DistTar!$D$60:$D$62,E279)","v":159.601}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B281","v":"Existing: Tariff D -  AGN Central"},{"$f":"INDEX(Prop2019DistTar!$F$60:$F$62,C$38)","v":1467.4216999999999},{"$f":"INDEX(Prop2019DistTar!$F$60:$F$62,D$38)","v":1341.3308},{"$f":"INDEX(Prop2019DistTar!$F$60:$F$62,E$38)","v":1336.6181999999999}]
[null,{"$f":"B282","v":"Proposed: Tariff D -  AGN Central"},{"$f":"INDEX(Prop2019DistTar!$F$60:$F$62,C$38)","v":1467.4216999999999},{"$f":"INDEX(Prop2019DistTar!$F$60:$F$62,D$38)","v":1341.3308},{"$f":"INDEX(Prop2019DistTar!$F$60:$F$62,E$38)","v":1336.6181999999999}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B285","v":"Existing: Tariff D -  AGN Central"},{"$f":"INDEX(Prop2019DistTar!$H$60:$H$62,C279)","v":2027711.9197831498},{"$f":"INDEX(Prop2019DistTar!$H$60:$H$62,D279)","v":1133097.2412848},{"$f":"INDEX(Prop2019DistTar!$H$60:$H$62,E279)","v":206199.82239036}]
[null,{"$f":"B286","v":"Proposed: Tariff D -  AGN Central"},{"$f":"INDEX(Prop2019DistTar!$G$60:$G$62,C279)","v":2097784.24080155},{"$f":"INDEX(Prop2019DistTar!$G$60:$G$62,D279)","v":1172254.0406638},{"$f":"INDEX(Prop2019DistTar!$G$60:$G$62,E279)","v":213325.60133819998}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B289","v":"Existing: Tariff D -  AGN Central"},{"$f":"SUM(C289:E289)","v":3367008.9834583094}]
[null,{"$f":"B290","v":"Proposed: Tariff D -  AGN Central"},{"$f":"SUM(C290:E290)","v":3483363.8828035495}]
[]
[null,"Average price movement",{"$f":"IF(C294=0,\"\",C294/C293)","v":1.0345573474608702}]
[]
[null,{"$f":"IF(C296=\"\",\"\",IF(C296<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2019DistTar!B64","v":"Tariff D - AGN North"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2019DistTar!C64","v":"Existing: Tariff D - AGN North"},{"$f":"INDEX(Prop2019DistTar!$E$65:$E$67,C303)","v":1381.8195000000001},{"$f":"INDEX(Prop2019DistTar!$E$65:$E$67,D303)","v":844.75599999999997},{"$f":"INDEX(Prop2019DistTar!$E$65:$E$67,E303)","v":154.2698}]
[null,{"$f":"\"Proposed: \"&B302","v":"Proposed: Tariff D - AGN North"},{"$f":"INDEX(Prop2019DistTar!$D$65:$D$67,C303)","v":1429.5715},{"$f":"INDEX(Prop2019DistTar!$D$65:$D$67,D303)","v":873.94849999999997},{"$f":"INDEX(Prop2019DistTar!$D$65:$D$67,E303)","v":159.601}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B305","v":"Existing: Tariff D - AGN North"},{"$f":"INDEX(Prop2019DistTar!$F$65:$F$67,C$38)","v":437.06389999999999},{"$f":"INDEX(Prop2019DistTar!$F$65:$F$67,D$38)","v":625.73840000000007},{"$f":"INDEX(Prop2019DistTar!$F$65:$F$67,E$38)","v":505.43940000000003}]
[null,{"$f":"B306","v":"Proposed: Tariff D - AGN North"},{"$f":"INDEX(Prop2019DistTar!$F$65:$F$67,C$38)","v":437.06389999999999},{"$f":"INDEX(Prop2019DistTar!$F$65:$F$67,D$38)","v":625.73840000000007},{"$f":"INDEX(Prop2019DistTar!$F$65:$F$67,E$38)","v":505.43940000000003}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B309","v":"Existing: Tariff D - AGN North"},{"$f":"INDEX(Prop2019DistTar!$H$65:$H$67,C303)","v":603943.41976605006},{"$f":"INDEX(Prop2019DistTar!$H$65:$H$67,D303)","v":528596.26783040003},{"$f":"INDEX(Prop2019DistTar!$H$65:$H$67,E303)","v":77974.035150120006}]
[null,{"$f":"B310","v":"Proposed: Tariff D - AGN North"},{"$f":"INDEX(Prop2019DistTar!$G$65:$G$67,C303)","v":624814.09511885},{"$f":"INDEX(Prop2019DistTar!$G$65:$G$67,D303)","v":546863.13607240003},{"$f":"INDEX(Prop2019DistTar!$G$65:$G$67,E303)","v":80668.633679400009}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B313","v":"Existing: Tariff D - AGN North"},{"$f":"SUM(C313:E313)","v":1210513.7227465701}]
[null,{"$f":"B314","v":"Proposed: Tariff D - AGN North"},{"$f":"SUM(C314:E314)","v":1252345.86487065}]
[]
[null,"Average price movement",{"$f":"IF(C318=0,\"\",C318/C317)","v":1.034557346470361}]
[]
[null,{"$f":"IF(C320=\"\",\"\",IF(C320<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2019DistTar!B69","v":"Tariff D - Murray Valley"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2019DistTar!C69","v":"Existing: Tariff D - Murray Valley"},{"$f":"INDEX(Prop2019DistTar!$E$70:$E$72,C327)","v":1610.6766},{"$f":"INDEX(Prop2019DistTar!$E$70:$E$72,D327)","v":993.88909999999998},{"$f":"INDEX(Prop2019DistTar!$E$70:$E$72,E327)","v":169.27680000000001}]
[null,{"$f":"\"Proposed: \"&B326","v":"Proposed: Tariff D - Murray Valley"},{"$f":"INDEX(Prop2019DistTar!$D$70:$D$72,C327)","v":1666.3372999999999},{"$f":"INDEX(Prop2019DistTar!$D$70:$D$72,D327)","v":1028.2353000000001},{"$f":"INDEX(Prop2019DistTar!$D$70:$D$72,E327)","v":175.1266}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B329","v":"Existing: Tariff D - Murray Valley"},{"$f":"INDEX(Prop2019DistTar!$F$70:$F$72,C$38)","v":64.920299999999997},{"$f":"INDEX(Prop2019DistTar!$F$70:$F$72,D$38)","v":131.62190000000001},{"$f":"INDEX(Prop2019DistTar!$F$70:$F$72,E$38)","v":126.3329}]
[null,{"$f":"B330","v":"Proposed: Tariff D - Murray Valley"},{"$f":"INDEX(Prop2019DistTar!$F$70:$F$72,C$38)","v":64.920299999999997},{"$f":"INDEX(Prop2019DistTar!$F$70:$F$72,D$38)","v":131.62190000000001},{"$f":"INDEX(Prop2019DistTar!$F$70:$F$72,E$38)","v":126.3329}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B333","v":"Existing: Tariff D - Murray Valley"},{"$f":"INDEX(Prop2019DistTar!$H$70:$H$72,C327)","v":104565.60807498},{"$f":"INDEX(Prop2019DistTar!$H$70:$H$72,D327)","v":130817.57173129001},{"$f":"INDEX(Prop2019DistTar!$H$70:$H$72,E327)","v":21385.22904672}]
[null,{"$f":"B334","v":"Proposed: Tariff D - Murray Valley"},{"$f":"INDEX(Prop2019DistTar!$G$70:$G$72,C327)","v":108179.11741718999},{"$f":"INDEX(Prop2019DistTar!$G$70:$G$72,D327)","v":135338.28383307002},{"$f":"INDEX(Prop2019DistTar!$G$70:$G$72,E327)","v":22124.25124514}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B337","v":"Existing: Tariff D - Murray Valley"},{"$f":"SUM(C337:E337)","v":256768.40885298999}]
[null,{"$f":"B338","v":"Proposed: Tariff D - Murray Valley"},{"$f":"SUM(C338:E338)","v":265641.65249539999}]
[]
[null,"Average price movement",{"$f":"IF(C342=0,\"\",C342/C341)","v":1.0345573806452579}]
[]
[null,{"$f":"IF(C344=\"\",\"\",IF(C344<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2019DistTar!B74","v":"Tariff D - Bairnsdale"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2019DistTar!C74","v":"Existing: Tariff D - Bairnsdale"},{"$f":"INDEX(Prop2019DistTar!$E$75:$E$77,C351)","v":2285.7148000000002},{"$f":"INDEX(Prop2019DistTar!$E$75:$E$77,D351)","v":1416.0098},{"$f":"INDEX(Prop2019DistTar!$E$75:$E$77,E351)","v":258.24799999999999}]
[null,{"$f":"\"Proposed: \"&B350","v":"Proposed: Tariff D - Bairnsdale"},{"$f":"INDEX(Prop2019DistTar!$D$75:$D$77,C351)","v":2364.7031000000002},{"$f":"INDEX(Prop2019DistTar!$D$75:$D$77,D351)","v":1464.9434000000001},{"$f":"INDEX(Prop2019DistTar!$D$75:$D$77,E351)","v":267.17239999999998}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B353","v":"Existing: Tariff D - Bairnsdale"},{"$f":"INDEX(Prop2019DistTar!$F$75:$F$77,C$38)","v":17.319700000000001},{"$f":"INDEX(Prop2019DistTar!$F$75:$F$77,D$38)","v":3.9206000000000003},{"$f":"INDEX(Prop2019DistTar!$F$75:$F$77,E$38)","v":0}]
[null,{"$f":"B354","v":"Proposed: Tariff D - Bairnsdale"},{"$f":"INDEX(Prop2019DistTar!$F$75:$F$77,C$38)","v":17.319700000000001},{"$f":"INDEX(Prop2019DistTar!$F$75:$F$77,D$38)","v":3.9206000000000003},{"$f":"INDEX(Prop2019DistTar!$F$75:$F$77,E$38)","v":0}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B357","v":"Existing: Tariff D - Bairnsdale"},{"$f":"INDEX(Prop2019DistTar!$H$75:$H$77,C351)","v":39587.894621560008},{"$f":"INDEX(Prop2019DistTar!$H$75:$H$77,D351)","v":5551.6080218800007},{"$f":"INDEX(Prop2019DistTar!$H$75:$H$77,E351)","v":0}]
[null,{"$f":"B358","v":"Proposed: Tariff D - Bairnsdale"},{"$f":"INDEX(Prop2019DistTar!$G$75:$G$77,C351)","v":40955.948281070006},{"$f":"INDEX(Prop2019DistTar!$G$75:$G$77,D351)","v":5743.4570940400008},{"$f":"INDEX(Prop2019DistTar!$G$75:$G$77,E351)","v":0}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B361","v":"Existing: Tariff D - Bairnsdale"},{"$f":"SUM(C361:E361)","v":45139.502643440006}]
[null,{"$f":"B362","v":"Proposed: Tariff D - Bairnsdale"},{"$f":"SUM(C362:E362)","v":46699.405375110007}]
[]
[null,"Average price movement",{"$f":"IF(C366=0,\"\",C366/C365)","v":1.0345573752549242}]
[]
[null,{"$f":"IF(C368=\"\",\"\",IF(C368<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2019DistTar!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 : \"&Prop2019DistTar!C79","v":"Existing : Tariff V - Albury - Residential"},{"$f":"INDEX(Prop2019DistTar!$E$81:$E$84,C$39)","v":0.24229999999999999},{"$f":"INDEX(Prop2019DistTar!$E$81:$E$84,D$39)","v":7.7660999999999998},{"$f":"INDEX(Prop2019DistTar!$E$81:$E$84,E$39)","v":4.9638},{"$f":"INDEX(Prop2019DistTar!$E$81:$E$84,F$39)","v":2.7258}]
[]
[null,{"$f":"\"Proposed : \"&B374","v":"Proposed : Tariff V - Albury - Residential"},{"$f":"INDEX(Prop2019DistTar!$D$81:$D$84,C$38)","v":0.24729999999999999},{"$f":"INDEX(Prop2019DistTar!$D$81:$D$84,D$38)","v":8.3042999999999996},{"$f":"INDEX(Prop2019DistTar!$D$81:$D$84,E$38)","v":5.0669000000000004},{"$f":"INDEX(Prop2019DistTar!$D$81:$D$84,F$38)","v":2.7824}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B378","v":"Existing : Tariff V - Albury - Residential"},{"$f":"INDEX(Prop2019DistTar!$F$81:$F$84,C$38)","v":7897336},{"$f":"INDEX(Prop2019DistTar!$F$81:$F$84,D$38)","v":181185.54128674389},{"$f":"INDEX(Prop2019DistTar!$F$81:$F$84,E$38)","v":109199.07900232291},{"$f":"INDEX(Prop2019DistTar!$F$81:$F$84,F$38)","v":719170.63465140236}]
[]
[null,{"$f":"B380","v":"Proposed : Tariff V - Albury - Residential"},{"$f":"INDEX(Prop2019DistTar!$F$81:$F$84,C$38)","v":7897336},{"$f":"INDEX(Prop2019DistTar!$F$81:$F$84,D$38)","v":181185.54128674389},{"$f":"INDEX(Prop2019DistTar!$F$81:$F$84,E$38)","v":109199.07900232291},{"$f":"INDEX(Prop2019DistTar!$F$81:$F$84,F$38)","v":719170.63465140236}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B384","v":"Existing : Tariff V - Albury - Residential"},{"$f":"INDEX(Prop2019DistTar!$H$81:$H$84,C$39)","v":1913524.5127999999},{"$f":"INDEX(Prop2019DistTar!$H$81:$H$84,D$39)","v":1407105.0321869818},{"$f":"INDEX(Prop2019DistTar!$H$81:$H$84,E$39)","v":542042.38835173042},{"$f":"INDEX(Prop2019DistTar!$H$81:$H$84,F$39)","v":1960315.3159327926}]
[]
[null,{"$f":"B386","v":"Proposed : Tariff V - Albury - Residential"},{"$f":"INDEX(Prop2019DistTar!$G$81:$G$84,C$38)","v":1953011.1927999998},{"$f":"INDEX(Prop2019DistTar!$G$81:$G$84,D$38)","v":1504619.0905075071},{"$f":"INDEX(Prop2019DistTar!$G$81:$G$84,E$38)","v":553300.81339686993},{"$f":"INDEX(Prop2019DistTar!$G$81:$G$84,F$38)","v":2001020.3738540618}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B390","v":"Existing : Tariff V - Albury - Residential"},{"$f":"SUM(C390:G390)","v":5822987.2492715046}]
[null,{"$f":"B392","v":"Proposed : Tariff V - Albury - Residential"},{"$f":"SUM(C392:G392)","v":6011951.4705584385}]
[]
[null,"Average price movement",{"$f":"IF(C396=0,\"\",C396/C395)","v":1.032451422817485}]
[]
[null,{"$f":"IF(C398=\"\",\"\",IF(C398<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2019DistTar!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 : \"&Prop2019DistTar!C85","v":"Existing : Tariff V - Albury - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$E$87:$E$91,C$39)","v":0.24229999999999999},{"$f":"INDEX(Prop2019DistTar!$E$87:$E$91,D$39)","v":5.8183999999999996},{"$f":"INDEX(Prop2019DistTar!$E$87:$E$91,E$39)","v":2.9916},{"$f":"INDEX(Prop2019DistTar!$E$87:$E$91,F$39)","v":2.1286},{"$f":"INDEX(Prop2019DistTar!$E$87:$E$91,G$39)","v":0.8629}]
[]
[null,{"$f":"\"Proposed : \"&B404","v":"Proposed : Tariff V - Albury - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$D$87:$D$91,C$38)","v":0.24729999999999999},{"$f":"INDEX(Prop2019DistTar!$D$87:$D$91,D$38)","v":6.2215999999999996},{"$f":"INDEX(Prop2019DistTar!$D$87:$D$91,E$38)","v":3.0537999999999998},{"$f":"INDEX(Prop2019DistTar!$D$87:$D$91,F$38)","v":2.1728000000000001},{"$f":"INDEX(Prop2019DistTar!$D$87:$D$91,G$38)","v":0.88080000000000003}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B408","v":"Existing : Tariff V - Albury - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$F$87:$F$91,C$38)","v":335600},{"$f":"INDEX(Prop2019DistTar!$F$87:$F$91,D$38)","v":11288.751835738014},{"$f":"INDEX(Prop2019DistTar!$F$87:$F$91,E$38)","v":58602.418625916005},{"$f":"INDEX(Prop2019DistTar!$F$87:$F$91,F$38)","v":42526.967890955952},{"$f":"INDEX(Prop2019DistTar!$F$87:$F$91,G$38)","v":172784.30788248617}]
[]
[null,{"$f":"B410","v":"Proposed : Tariff V - Albury - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$F$87:$F$91,C$38)","v":335600},{"$f":"INDEX(Prop2019DistTar!$F$87:$F$91,D$38)","v":11288.751835738014},{"$f":"INDEX(Prop2019DistTar!$F$87:$F$91,E$38)","v":58602.418625916005},{"$f":"INDEX(Prop2019DistTar!$F$87:$F$91,F$38)","v":42526.967890955952},{"$f":"INDEX(Prop2019DistTar!$F$87:$F$91,G$38)","v":172784.30788248617}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B414","v":"Existing : Tariff V - Albury - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$H$87:$H$91,C$39)","v":81315.87999999999},{"$f":"INDEX(Prop2019DistTar!$H$87:$H$91,D$39)","v":65682.473681058051},{"$f":"INDEX(Prop2019DistTar!$H$87:$H$91,E$39)","v":175314.99556129033},{"$f":"INDEX(Prop2019DistTar!$H$87:$H$91,F$39)","v":90522.903852688847},{"$f":"INDEX(Prop2019DistTar!$H$87:$H$91,G$39)","v":149095.57927179732}]
[]
[null,{"$f":"B416","v":"Proposed : Tariff V - Albury - Non Residential"},{"$f":"INDEX(Prop2019DistTar!$G$87:$G$91,C$38)","v":82993.87999999999},{"$f":"INDEX(Prop2019DistTar!$G$87:$G$91,D$38)","v":70234.098421227623},{"$f":"INDEX(Prop2019DistTar!$G$87:$G$91,E$38)","v":178960.06599982228},{"$f":"INDEX(Prop2019DistTar!$G$87:$G$91,F$38)","v":92402.595833469095},{"$f":"INDEX(Prop2019DistTar!$G$87:$G$91,G$38)","v":152188.41838289384}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B420","v":"Existing : Tariff V - Albury - Non Residential"},{"$f":"SUM(C420:G420)","v":561931.83236683451}]
[null,{"$f":"B422","v":"Proposed : Tariff V - Albury - Non Residential"},{"$f":"SUM(C422:G422)","v":576779.05863741273}]
[]
[null,"Average price movement",{"$f":"IF(C426=0,\"\",C426/C425)","v":1.0264217569025096}]
[]
[null,{"$f":"IF(C428=\"\",\"\",IF(C428<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"Prop2019DistTar!B93","v":"Tariff D - Albury"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&Prop2019DistTar!C93","v":"Existing: Tariff D - Albury"},{"$f":"INDEX(Prop2019DistTar!$E$94:$E$96,C435)","v":1188.3652999999999},{"$f":"INDEX(Prop2019DistTar!$E$94:$E$96,D435)","v":738.08399999999995},{"$f":"INDEX(Prop2019DistTar!$E$94:$E$96,E435)","v":178.34950000000001}]
[null,{"$f":"\"Proposed: \"&B434","v":"Proposed: Tariff D - Albury"},{"$f":"INDEX(Prop2019DistTar!$D$94:$D$96,C435)","v":1229.4321},{"$f":"INDEX(Prop2019DistTar!$D$94:$D$96,D435)","v":763.59019999999998},{"$f":"INDEX(Prop2019DistTar!$D$94:$D$96,E435)","v":184.5128}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B437","v":"Existing: Tariff D - Albury"},{"$f":"INDEX(Prop2019DistTar!$F$94:$F$96,C$38)","v":48.608400000000003},{"$f":"INDEX(Prop2019DistTar!$F$94:$F$96,D$38)","v":100.84530000000001},{"$f":"INDEX(Prop2019DistTar!$F$94:$F$96,E$38)","v":187.76440000000002}]
[null,{"$f":"B438","v":"Proposed: Tariff D - Albury"},{"$f":"INDEX(Prop2019DistTar!$F$94:$F$96,C$38)","v":48.608400000000003},{"$f":"INDEX(Prop2019DistTar!$F$94:$F$96,D$38)","v":100.84530000000001},{"$f":"INDEX(Prop2019DistTar!$F$94:$F$96,E$38)","v":187.76440000000002}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B441","v":"Existing: Tariff D - Albury"},{"$f":"INDEX(Prop2019DistTar!$H$94:$H$96,C435)","v":57764.535848519998},{"$f":"INDEX(Prop2019DistTar!$H$94:$H$96,D435)","v":74432.302405199996},{"$f":"INDEX(Prop2019DistTar!$H$94:$H$96,E435)","v":33487.686857800007}]
[null,{"$f":"B442","v":"Proposed: Tariff D - Albury"},{"$f":"INDEX(Prop2019DistTar!$G$94:$G$96,C435)","v":59760.727289640003},{"$f":"INDEX(Prop2019DistTar!$G$94:$G$96,D435)","v":77004.482796060009},{"$f":"INDEX(Prop2019DistTar!$G$94:$G$96,E435)","v":34644.935184320006}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B445","v":"Existing: Tariff D - Albury"},{"$f":"SUM(C445:E445)","v":165684.52511151999}]
[null,{"$f":"B446","v":"Proposed: Tariff D - Albury"},{"$f":"SUM(C446:E446)","v":171410.14527002}]
[]
[null,"Average price movement",{"$f":"IF(C450=0,\"\",C450/C449)","v":1.0345573622801898}]
[]
[null,{"$f":"IF(C452=\"\",\"\",IF(C452<=$C$13,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]

{"sheet":"ARS","index":4,"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":2018},{"$f":"'Model update'!$B$5","v":2019}]
["Meter and Gas Installation Test ",214,{"$f":"ROUND(B6*(1+'Model update'!$B$30),0)","v":218}]
["Disconnection",71,{"$f":"ROUND(B7*(1+'Model update'!$B$30),0)","v":72}]
["Reconnection",82,{"$f":"ROUND(B8*(1+'Model update'!$B$30),0)","v":84}]
["Meter Removal",100,{"$f":"ROUND(B9*(1+'Model update'!$B$30),0)","v":102}]
["Meter Reinstallation",100,{"$f":"ROUND(B10*(1+'Model update'!$B$30),0)","v":102}]
["Special Meter Read - Metropolitan",9,{"$f":"ROUND(B11*(1+'Model update'!$B$30),1)","v":9.1999999999999993}]
["Special Meter Read - Non Metropolitan",12.3,{"$f":"ROUND(B12*(1+'Model update'!$B$30),1)","v":12.6}]
[]
["Note: 2017 formula is as per AA2013-17, Section 4.4.2, p9 : ART = ARTt-1 * (1+CPI)"]