{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["NOTES","Model update","Prop2024-25DistTar","2024-25TarContForm","2024-25RebalContForm","ARS"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":22,"comments":0,"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":57,"n_cols":7,"rows_kept":57,"cut":false,"hidden":true,"merged":[]}
[]
[null,"The model has actual and test data to illustrate the workings of the model.",null,null,{"$f":"'Model update'!B5","v":"2024-25"},{"$f":"'Model update'!B8","v":"2023-24"},{"$f":"IF('Model update'!B9=\"HY23\",\"2022\",'Model update'!B9)","v":"2022-23"}]
[]
[null,"Issue","Location","Item","Comment"]
[]
["AER:",1,"'Model update'!B17:B22","CPI",{"$f":"\"Updated December \"&LEFT(E2,4)-1&\" CPI for \"&E2","v":"Updated December 2023 CPI for 2024-25"},"NOTE: This worksheet is programmed to update for each year - use as checklist and note any placeholders or changes"]
[null,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"]
[null,{"$f":"B6+1","v":2},"'Model update'!B35:B38",{"$f":"\"Xt for \"&E2","v":"Xt for 2024-25"},{"$f":"\"Updated \"&$E$2&\" value\"","v":"Updated 2024-25 value"}]
[]
[null,{"$f":"B8+1","v":3},"'Model update'!B44:B48","Real Pre-tax WACC (rptw)",{"$f":"\"Updated \"&$E$2&\" value\"","v":"Updated 2024-25 value"}]
[]
[null,{"$f":"B10+1","v":4},"'Model update'!G18:G21",{"$f":"\"Pass Through Amount for \"&E2","v":"Pass Through Amount for 2024-25"},{"$f":"\"Updated \"&E2&\" AP(t) value\"","v":"Updated 2024-25 AP(t) value"}]
[]
[null,{"$f":"B12+1","v":5},{"$f":"\"Prop\"&E2&\"DistTar!E8:E96\"","v":"Prop2024-25DistTar!E8:E96"},{"$f":"F2&\" tariffs\"","v":"2023-24 tariffs"},{"$f":"\"Updated from \"&F2&\" model\"","v":"Updated from 2023-24 model"}]
[]
[null,{"$f":"B14+1","v":6},"ARS!B6:B12",{"$f":"F2&\" ARS tariffs\"","v":"2023-24 ARS tariffs"},{"$f":"\"Updated from \"&F2&\" model\"","v":"Updated from 2023-24 model"}]
[]
[]
["AGN:",1,"'Model update'!F30:F34",{"$f":"\"Estimated safeguard mechanism amount for \"&F2","v":"Estimated safeguard mechanism amount for 2023-24"},{"$f":"\"Updated \"&F2&\" estimated cf(t) value, used for the cf(t-1) value for \"&E2","v":"Updated 2023-24 estimated cf(t) value, used for the cf(t-1) value for 2024-25"}]
[]
[null,{"$f":"B19+1","v":2},"'Model update'!G30:G34",{"$f":"\"Actual safeguard mechanism amount for \"&G2","v":"Actual safeguard mechanism amount for 2022-23"},{"$f":"\"Updated \"&G2&\" actual cf(t) value, used for the cf(t-2) value for \"&E2","v":"Updated 2022-23 actual cf(t) value, used for the cf(t-2) value for 2024-25"}]
[]
[null,{"$f":"B21+1","v":3},"'Model update'!F43:F47",{"$f":"\"Estimated abolishments amount for \"&F2","v":"Estimated abolishments amount for 2023-24"},{"$f":"\"Updated \"&F2&\" estimated af(t) value, used for the af(t-1) value for \"&E2","v":"Updated 2023-24 estimated af(t) value, used for the af(t-1) value for 2024-25"}]
[]
[null,{"$f":"B23+1","v":4},"'Model update'!G43:G47",{"$f":"\"Actual abolishments amount for \"&G2","v":"Actual abolishments amount for 2022-23"},{"$f":"\"Updated \"&G2&\" actual af(t) value, used for the af(t-2) value for \"&E2","v":"Updated 2022-23 actual af(t) value, used for the af(t-2) value for 2024-25"}]
[]
[null,{"$f":"B25+1","v":5},{"$f":"\"Prop\"&E2&\"DistTar!D8:D96\"","v":"Prop2024-25DistTar!D8:D96"},{"$f":"\"Proposed \"&E2&\" Tariffs\"","v":"Proposed 2024-25 Tariffs"}]
[]
[null,{"$f":"B27+1","v":6},{"$f":"\"Prop\"&E2&\"DistTar!F8:F96\"","v":"Prop2024-25DistTar!F8:F96"},{"$f":"\"Actual \"&G2&\" Volumes\"","v":"Actual 2022-23 Volumes"}]
[]
[null,{"$f":"B29+1","v":7},"ARS!C6:C12",{"$f":"\"Proposed \"&E2&\" Ancillary Reference Services Charges\"","v":"Proposed 2024-25 Ancillary Reference Services Charges"},"Calculated using formula"]
[]
[]
[]
[]
[]
[]
[]
["Reset",1,"Whole workbook","Colour formatting","Adjusted colour formatting away from yellow to ensure yellow can be used to clearly identify confidential material"]
[]
[null,{"$f":"B39+1","v":2},"'Model update'","CPI","Adjusted CPI to have CPI for whole period"]
[]
[null,{"$f":"B41+1","v":3},"'Model update'","WACC","Adjusted WACC to have WACC for whole period"]
[]
[null,{"$f":"B43+1","v":4},"'Model update'","Pass-through adjustment","Adjusted to have $$ amount as input and calculate adjustment factor"]
[]
[null,{"$f":"B45+1","v":5},"'Model update'","Safeguard mechanism","Added safeguard mechanism adjustment"]
[]
[null,{"$f":"B47+1","v":6},"'Model update'","Abolishments adjustment","Added abolishments adjustment"]
[]
[null,{"$f":"B49+1","v":7},"Prop2024-25DistTar","Tariffs","Updated tariff schedule"]
[]
[null,{"$f":"B51+1","v":8},"2024-25TarContForm","Tariff Control Formula","Simplified, and updated for new adjustment factors. Added denominators for calculations in adjustments."]
[]
[null,{"$f":"B53+1","v":9},"2024-25RebalContForm","Rebalancing constraint formulae","Updated for new adjustment factors"]
[]
[null,{"$f":"B55+1","v":10},"ARS","Ancillary reference services","Updated for new tariff schedule"]

{"sheet":"Model update","index":1,"n_rows":56,"n_cols":14,"rows_kept":56,"cut":false,"hidden":false,"merged":[[41,0,42,1]]}
[]
[]
["Tariff Approval Template for ","Aust. Gas Networks (Vic & Albury)"]
[]
["Financial year","2024-25"]
[]
["t",{"$f":"B5","v":"2024-25"}]
["t-1",{"$f":"LEFT(B7,4)-1&\"-\"&RIGHT(B7,2)-1","v":"2023-24"}]
["t-2",{"$f":"LEFT(B8,4)-1&\"-\"&RIGHT(B8,2)-1","v":"2022-23"}]
["t-3","2021-22"]
[]
[]
["Update orange highlighted cells where appropriate",null,null,"Darker orange cells should be overwritten with t-1 values before changing to new year"]
[]
["CPI"]
[null,null,null,"Pass Through Amounts :  PT (t)",null,null,"AP(t)","PT'(t)"]
["CPI Index December 2021",121.3,null,{"$f":"A44","v":"2023-24"},null,null,0]
["CPI Index December 2022",130.80000000000001,null,{"$f":"A45","v":"2024-25"},null,null,0,{"$f":"G18/'2024-25TarContForm'!$G$11","v":0}]
["CPI Index December 2023",136.1,null,"2025-26",null,null,null,{"$f":"G19/'2024-25TarContForm'!$G$11","v":0}]
["CPI Index December 2024",140.08000000000001,null,"2026-27",null,null,null,{"$f":"G20/'2024-25TarContForm'!$G$11","v":0}]
["CPI Index December 2025",144.16936223498834,null,"2027-28",null,null,null,{"$f":"G21/'2024-25TarContForm'!$G$11","v":0}]
["CPI Index December 2026",148.37810542006912]
[null,null,null,{"$f":"\"Pass Through Amount for \"&B$5","v":"Pass Through Amount for 2024-25"},null,null,null,{"$f":"(1+VLOOKUP($B$5,D17:H21,5,FALSE))/(1+VLOOKUP($B$8,D17:H21,5,FALSE))-1","v":0}]
[{"$f":"\"CPI \"&A44","v":"CPI 2023-24"},{"$f":"B18/B17-1","v":7.8318219291014124E-2},null,"The Pass Through Amount is to include an amount that reflects the time value of money between incurring the costs and recovering the costs"]
[{"$f":"\"CPI \"&A45","v":"CPI 2024-25"},{"$f":"B19/B18-1","v":4.0519877675840865E-2},null,"and excludes any amounts already passed through in reference tariffs."]
["CPI 2025-26",2.924320352681864E-2]
["CPI 2026-27",2.9193048507912156E-2]
["CPI 2027-28",2.9193048507912156E-2,null,"Safeguard Mechanism Amounts :  C (t)",null,"Est. cf(t)","Act. cf(t)","C'(t)",null,null,null,null,"At=0 for the purpose of this formula as it is unknown at the time of "]
[null,null,null,"2022-23",null,0,0,null,null,null,null,null,null,"calculation, and prevents a circular reference. This gives"]
[{"$f":"\"CPI \" &$B$8","v":"CPI 2023-24"},{"$f":"VLOOKUP(A30,A24:B28,2,FALSE)","v":7.8318219291014124E-2},null,{"$f":"A44","v":"2023-24"},null,null,null,null,null,null,null,null,null,"the intended outcome of calculating a percentage of the revenue"]
[{"$f":"\"CPI \" &$B$5","v":"CPI 2024-25"},{"$f":"VLOOKUP(A31,A24:B28,2,FALSE)","v":4.0519877675840865E-2},null,{"$f":"A45","v":"2024-25"},null,null,null,{"$f":"(('Model update'!F30*(1+'Model update'!B45)*(1+'Model update'!B25))+(('Model update'!G29-'Model update'!F29)*(1+'Model update'!B44)*(1+'Model update'!B45)*(1+'Model update'!B24)*(1+'Model update'!B25)))/'2024-25TarContForm'!$G$12","v":0},null,null,null,null,null,"that the adjustment will be added to."]
[null,null,null,"2025-26",null,null,null,{"$f":"(('Model update'!F31*(1+'Model update'!B46)*(1+'Model update'!B26))+(('Model update'!G30-'Model update'!F30)*(1+'Model update'!B45)*(1+'Model update'!B46)*(1+'Model update'!B25)*(1+'Model update'!B26)))/'2024-25TarContForm'!$G$12","v":0}]
[null,null,null,"2026-27",null,null,null,{"$f":"(('Model update'!F32*(1+'Model update'!B47)*(1+'Model update'!B27))+(('Model update'!G31-'Model update'!F31)*(1+'Model update'!B46)*(1+'Model update'!B47)*(1+'Model update'!B26)*(1+'Model update'!B27)))/'2024-25TarContForm'!$G$12","v":0}]
[{"$f":"\"Xt for \"&B$5","v":"Xt for 2024-25"},null,null,"2027-28",null,null,null,{"$f":"(('Model update'!F33*(1+'Model update'!B48)*(1+'Model update'!B28))+(('Model update'!G32-'Model update'!F32)*(1+'Model update'!B47)*(1+'Model update'!B48)*(1+'Model update'!B27)*(1+'Model update'!B28)))/'2024-25TarContForm'!$G$12","v":0}]
["2024-25",9.7982408269751096E-4]
["2025-26",null,null,{"$f":"\"Safeguard Mechanism Amount for \"&B$5","v":"Safeguard Mechanism Amount for 2024-25"},null,null,null,{"$f":"(1+VLOOKUP($B$5,D30:H34,5,FALSE))/(1+VLOOKUP($B$8,D30:H34,5,FALSE))-1","v":0}]
["2026-27"]
["2027-28"]
[]
[{"$f":"\"Xt for \"&B$5","v":"Xt for 2024-25"},{"$f":"VLOOKUP(B5,A35:B38,2,FALSE)","v":9.7982408269751096E-4}]
[null,null,null,"Abolishment True-up Amounts :  A (t)","Fcst af(t)","Estimate af(t)","Act. af(t)","A'(t)"]
["Pre-tax WACC for distribution tariffs ",null,null,"2022-23",0,0,0]
[null,null,null,{"$f":"A44","v":"2023-24"},{"$f":"E52*(1+H52)","v":2524223.5102467649},1510720.7850000001]
["2023-24",2.8282344487653654E-2,null,{"$f":"A45","v":"2024-25"},{"$f":"E53*(1+H52)*(1+H52)","v":3865967.8957231687},null,null,{"$f":"(((F43-'Model update'!E43)*(1+'Model update'!B45)*(1+'Model update'!B25))+(('Model update'!G42-'Model update'!F42)*(1+'Model update'!B44)*(1+'Model update'!B45)*(1+'Model update'!B24)*(1+'Model update'!B25)))/'2024-25TarContForm'!$G$13","v":-3.6337494104771743E-3}]
[{"$f":"A35","v":"2024-25"},2.8924003932044196E-2,null,"2025-26",{"$f":"E54*(1+H52)*(1+H52)*(1+H52)","v":5283900.2697564848},null,null,{"$f":"(((F44-'Model update'!E44)*(1+'Model update'!B46)*(1+'Model update'!B26))+(('Model update'!G43-'Model update'!F43)*(1+'Model update'!B45)*(1+'Model update'!B46)*(1+'Model update'!B25)*(1+'Model update'!B26)))/'2024-25TarContForm'!$G$13","v":-1.8900004066364929E-2}]
[{"$f":"A36","v":"2025-26"},null,null,"2026-27",{"$f":"E55*(1+H52)*(1+H52)*(1+H52)*(1+H52)","v":8589122.1654213481},null,null,{"$f":"(((F45-'Model update'!E45)*(1+'Model update'!B47)*(1+'Model update'!B27))+(('Model update'!G44-'Model update'!F44)*(1+'Model update'!B46)*(1+'Model update'!B47)*(1+'Model update'!B26)*(1+'Model update'!B27)))/'2024-25TarContForm'!$G$13","v":-1.8211588531411291E-2}]
["2026-27",null,null,"2027-28",{"$f":"E56*(1+H52)*(1+H52)*(1+H52)*(1+H52)*(1+H52)","v":12067256.966830933},null,null,{"$f":"(((F46-'Model update'!E46)*(1+'Model update'!B48)*(1+'Model update'!B28))+(('Model update'!G45-'Model update'!F45)*(1+'Model update'!B47)*(1+'Model update'!B48)*(1+'Model update'!B27)*(1+'Model update'!B28)))/'2024-25TarContForm'!$G$13","v":-2.9603427532118583E-2}]
["2027-28"]
[null,null,null,{"$f":"\"Abolishment True-up Amount for \"&B$5","v":"Abolishment True-up Amount for 2024-25"},null,null,null,{"$f":"(1+VLOOKUP($B$5,D43:H47,5,FALSE))/(1+VLOOKUP($B$8,D43:H47,5,FALSE))-1","v":-3.6337494104772272E-3}]
[{"$f":"\"Pre-tax real WACC for \"&B8","v":"Pre-tax real WACC for 2023-24"},{"$f":"VLOOKUP(B8,A44:B48,2,FALSE)","v":2.8282344487653654E-2}]
[{"$f":"\"Pre-tax real WACC for \"&B5","v":"Pre-tax real WACC for 2024-25"},{"$f":"VLOOKUP(B5,A44:B48,2,FALSE)","v":2.8924003932044196E-2},null,null,"Fcst af(t) $22-23",null,null,"Forecast inflation"]
[null,null,null,null,2452623.9405778102,null,null,2.9193048507912201E-2]
[null,null,null,null,3649762.08113555]
[null,null,null,null,4846900.2216932997]
[null,null,null,null,7655285.6938121598]
[null,null,null,null,10450193.690283099]

{"sheet":"Prop2024-25DistTar","index":2,"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,"Prop2024-25DistTar"]
[]
[null,{"$f":"\"PROPOSED \"&'Model update'!$B$5&\" DISTRIBUTION TARIFFS\"","v":"PROPOSED 2024-25 DISTRIBUTION TARIFFS"}]
[]
[null,"Proposed tariff name","Existing tariff name","Prop\n2024-25 Tariff",{"$f":"\"Exist\n\"&'Model update'!$B$8&\" Tariff\"","v":"Exist\n2023-24 Tariff"},"Actual 2022-23 Volumes","Prop Tar\nRevenue","Exist Tar\nRevenue"]
[null,"Tariff R - Residential (Central)","Tariff V - AGN Central - Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.2044,0.20445966648909583,219152514,{"$f":"D8*$F8","v":44794773.861599997},{"$f":"E8*$F8","v":44807849.922686905}]
[null,"GJ 0 - 0.0274","GJ 0 - 0.0274",15.150600000000001,14.02842161134787,5206883.2767229257,{"$f":"D9*$F9","v":78887405.772318363},73044353.88694571]
[null,"GJ 0.0274 - 0.0493","GJ 0.0274 - 0.0493",8.7110000000000003,8.0658073676089721,3232414.0846800189,28157559.091647647,26072029.339375108]
[null,"GJ > 0.0493","GJ > 0.0493",3.9767999999999999,3.9768253935643103,18916813.933209032,75228385.649585679,75228866.014916837]
[null,"Tariff R - Residential (Northern)","Tariff V - AGN North - Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.2044,0.20445966648909583,31295663,{"$f":"D14*$F14","v":6396833.5171999997},6398700.8195351362]
[null,"GJ 0 - 0.0274","GJ 0 - 0.0274",13.330299999999999,12.342883129835361,711833.97202799423,9488960.3973247707,8786083.5245880261]
[null,"GJ 0.0274 - 0.0493","GJ 0.0274 - 0.0493",7.8030999999999997,7.2251474937333109,427223.43174900202,3333667.1602806374,3086752.3071654462]
[null,"GJ > 0.0493","GJ > 0.0493",3.5634000000000001,3.5628750052409588,2626780.4613119988,9360269.4958391767,9358890.4498638362]
[null,"Tariff R - Residential (Murray Valley)","Tariff V - Murray Valley - Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.26019999999999999,0.26028885135017399,3230069,{"$f":"D20*$F20","v":840463.9537999999},{"$f":"E20*$F20","v":840750.94979180512}]
[null,"GJ 0 - 0.0274","GJ 0 - 0.0274",11.605600000000001,10.745938057307789,63590.374215999494,{"$f":"D21*$F21","v":738004.44700120378},683338.22236615291]
[null,"GJ 0.0274 - 0.0493","GJ 0.0274 - 0.0493",7.0209000000000001,6.5008629340991888,34360.747417000071,241243.3715400158,223374.50927112022]
[null,"GJ > 0.0493","GJ > 0.0493",3.6534,3.6526002696252395,203445.21722699993,743266.75661712151,743104.05529730534]
[null,"Tariff R - Residential (Bairnsdale)","Tariff V - Bairnsdale - Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.33639999999999998,0.33645776860688759,1903886,{"$f":"D26*$F26","v":640467.2503999999},640577.23524189275]
[null,"GJ 0 - 0.0274","GJ 0 - 0.0274",24.7361,22.903814277323267,37197.471301999933,920120.36987340054,851963.97428706859]
[null,"GJ 0.0274 - 0.0493","GJ 0.0274 - 0.0493",14.3873,13.321629362430865,18277.772623999987,262967.79807327501,243489.71246771328]
[null,"GJ > 0.0493","GJ > 0.0493",6.5772000000000004,6.5744335350564844,76273.039305000028,501663.03411684622,501452.02742747351]
[null,"Tariff R - Residential (Albury)","Tariff V - Albury - Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.26600000000000001,0.26619152882969371,8744581,{"$f":"D32*$F32","v":2326058.5460000001},{"$f":"E32*$F32","v":2327733.3853650917}]
[null,"GJ 0 - 0.0274","GJ 0 - 0.0274",10.971399999999999,10.158710896939564,201205.15896599702,{"$f":"D33*$F33","v":2207502.2810795396},2043985.0409083311]
[null,"GJ 0.0274 - 0.0493","GJ 0.0274 - 0.0493",6.5578000000000003,6.0720955296389842,120912.29372200096,792918.63977013796,734190.99818775791]
[null,"GJ > 0.0493","GJ > 0.0493",2.9948000000000001,2.9948893866615651,726702.83327600046,2176329.6450949661,2176394.6026351824]
[null,"Tariff C - Non-residential (Central)","Tariff V - AGN Central - Non Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.2044,0.20445966648909583,7430525,{"$f":"D38*$F38","v":1518799.31},{"$f":"E38*$F38","v":1519242.6633388889}]
[null,"GJ 0 - 0.05","GJ 0 - 0.05",10.6936,9.9026028888518649,263322.02451700019,{"$f":"D39*$F39","v":2815860.4013749934},2607573.4406803679]
[null,"GJ 0.05 - 0.55","GJ 0.05 - 0.55",4.5331000000000001,4.1978458842723789,1445422.826917998,6552246.216701977,6067662.2650110647]
[null,"GJ 0.55 - 1.37","GJ 0.55 - 1.37",3.1311,3.1311236183643039,1194962.2884559995,3741546.42138458,3741574.6444392381]
[null,"GJ > 1.37","GJ > 1.37",1.2645,1.2645911689023099,4386898.1198520083,5547232.6725528641,5547632.6212389972]
[null,"Tariff C - Non-residential (Northern)","Tariff V - AGN North - Non Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.2044,0.20445966648909583,1196061,{"$f":"D45*$F45","v":244474.86840000001},244546.23316061444]
[null,"GJ 0 - 0.05","GJ 0 - 0.05",9.5922999999999998,8.8826982780984292,36896.722905000031,353924.43512163177,327742.45701571862]
[null,"GJ 0.05 - 0.55","GJ 0.05 - 0.55",4.0968999999999998,3.7938764026523244,181815.904839,744881.58053489903,689787.07099556259]
[null,"GJ 0.55 - 1.37","GJ 0.55 - 1.37",2.8294999999999999,2.8295356024120921,130947.20439899989,370515.11484697019,370519.77688330354]
[null,"GJ > 1.37","GJ > 1.37",1.1432,1.1432768492818197,470094.24906400038,537411.74552996526,537447.87193539343]
[null,"Tariff C - Non-residential (Murray Valley)","Tariff V - Murray Valley - Non Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.26019999999999999,0.26028885135017399,134317,{"$f":"D52*$F52","v":34949.2834},{"$f":"E52*$F52","v":34961.21764680132}]
[null,"GJ 0 - 0.05","GJ 0 - 0.05",8.5768000000000004,7.9423322331351907,4498.1406140000026,{"$f":"D53*$F53","v":38579.652418155223},{"$f":"E53*$F53","v":35725.727187746736}]
[null,"GJ 0.05 - 0.55","GJ 0.05 - 0.55",4.5498000000000003,4.2132802760816013,20797.376636999994,94623.904223022575,87625.176778912384]
[null,"GJ 0.55 - 1.37","GJ 0.55 - 1.37",3.1442999999999999,3.1443971953202348,12680.840052000001,39872.365375503599,39873.597893813305]
[null,"GJ > 1.37","GJ > 1.37",1.4233,1.4233596126465136,34805.341790000013,49538.442969707015,49540.517808243931]
[null,"Tariff C - Non-residential (Bairnsdale)","Tariff V - Bairnsdale - Non Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.33639999999999998,0.33645776860688759,46322,{"$f":"D59*$F59","v":15582.720799999999},15585.396757408247]
[null,"GJ 0 - 0.05","GJ 0 - 0.05",17.584599999999998,16.283797838456881,1906.5132769999993,33525.273370734183,31045.276779001932]
[null,"GJ 0.05 - 0.55","GJ 0.05 - 0.55",7.7,7.1303803280246845,13418.648190999997,103323.59107069997,95680.065089790398]
[null,"GJ 0.55 - 1.37","GJ 0.55 - 1.37",5.3163,5.3163248107140468,10990.360774000006,58428.054982816233,58428.327661514668]
[null,"GJ > 1.37","GJ > 1.37",2.1313,2.1312837169628596,53734.48070399998,114524.29872443515,114523.42376389012]
[null,"Tariff C - Non-residential (Albury)","Tariff V - Albury - Non Residential"]
[]
[null,"Fixed Charge","Fixed Charge",0.26600000000000001,0.26619152882969371,343646,{"$f":"D66*$F66","v":91409.83600000001},91475.654116208927]
[null,"GJ 0 - 0.05","GJ 0 - 0.05",8.0515000000000008,7.4559430992538882,11287.540863000004,90881.635258444541,84159.262405031157]
[null,"GJ 0.05 - 0.55","GJ 0.05 - 0.55",3.5708000000000002,3.3066641012078626,58687.201406999979,209560.25878411555,194058.86209288239]
[null,"GJ 0.55 - 1.37","GJ 0.55 - 1.37",2.3479999999999999,2.3480854739097405,43302.458535999962,101674.1726425279,101677.87387296036]
[null,"GJ > 1.37","GJ > 1.37",0.94810000000000005,0.94818613681324537,143146.866939,135717.5445448659,135729.87475981007]
[]
[null,"Tariff D - AGN Central","Tariff D - AGN Central"]
[null,"0 - 10","0 - 10",1674.2542000000001,1616.5076496660338,1479.135499999999,{"$f":"D73*$F73","v":2476448.8232440986},2391033.8506425922]
[null,"10 - 50","10 - 50",1023.5317,988.22922581903811,1231.2340999999999,1260207.1314709699,1216741.5214450001]
[null,"> 50","> 50",186.9179,180.47094785904252,1223.0869000000002,228616.83486551006,220731.652156978]
[]
[null,"Tariff D - AGN North","Tariff D - AGN North"]
[null,"0 - 10","0 - 10",1674.2542000000001,1616.5076496660338,412.15229999999997,{"$f":"D78*$F78","v":690047.71931465995},666247.34577745001]
[null,"10 - 50","10 - 50",1023.5317,988.22922581903811,589.9677999999999,603850.74527925986,583023.42225216096]
[null,"> 50","> 50",186.9179,180.47094785904252,377.36469999999997,70536.217258129996,68103.365097543225]
[]
[null,"Tariff D - Murray Valley","Tariff D - Murray Valley"]
[null,"0 - 10","0 - 10",1951.5442,1884.2336389482641,68.353899999999996,{"$f":"D83*$F83","v":133395.65709237999},128794.71773330575]
[null,"10 - 50","10 - 50",1204.2260000000001,1162.6911533629686,152.77950000000001,183981.04616700002,177635.37306521769]
[null,"> 50","> 50",205.1009,198.02684827041554,94.941299999999998,19472.546077169998,18800.926409696003]
[]
[null,"Tariff D - Bairnsdale","Tariff D - Bairnsdale"]
[null,"0 - 10","0 - 10",2769.4409000000001,2673.9204049145128,15.952299999999999,{"$f":"D88*$F88","v":44178.952069070001},42655.180475317778]
[null,"10 - 50","10 - 50",1715.6802,1656.5048470801805,4.2654999999999994,7318.2338930999995,7065.8214252205089]
[null,"> 50","> 50",312.90100000000001,302.10877233185397,0,0,0]
[]
[]
[null,"Tariff D - Albury","Tariff D - Albury"]
[null,"0 - 10","0 - 10",1439.8592000000001,1390.1971755092725,43.471299999999999,{"$f":"D94*$F94","v":62592.551240960005},60433.678475716239]
[null,"10 - 50","10 - 50",894.28480000000002,863.44011012256487,72.546599999999998,{"$f":"D95*$F95","v":64877.321671680002},62639.644293017664]
[null,"> 50","> 50",216.16820000000001,208.71238640777656,4.440100000000001,959.80842482000025,926.70386688916892]
[]
[]
[null,"Total Revenue","Total Revenue",null,null,null,{"$f":"SUM(G8:G97)","v":297524428.42824447},{"$f":"SUM(H8:H97)","v":287262533.48075306}]

{"sheet":"2024-25TarContForm","index":3,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,1,25,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":"2024-25TarContForm"}]
[]
[null,{"$f":"'Model update'!$B$5&\"  TARIFF CONTROL FORMULA\"","v":"2024-25  TARIFF CONTROL FORMULA"}]
[]
[]
[null,"Adjustments",null,null,null,"Denominators for adjustment factors"]
[]
[]
[null,"CPI",{"$f":"'Model update'!B31","v":4.0519877675840865E-2}]
[null,"X-factor",{"$f":"'Model update'!B40","v":9.7982408269751096E-4}]
[null,"Pass-through Amount",{"$f":"'Model update'!H23","v":0},null,null,null,{"$f":"(1+C9)*(1-C10)*C23","v":298609504.45167077}]
[null,"Safeguard Mechanism Amount",{"$f":"'Model update'!H36","v":0},null,null,null,{"$f":"(1+C9)*(1-C10)*(1+C11)*(1+0)*C23","v":298609504.45167077}]
[null,"Abolishment True-up Amount",{"$f":"'Model update'!H49","v":-3.6337494104772272E-3},null,null,null,{"$f":"(1+C9)*(1-C10)*(1+C11)*(1+C12)*C23","v":298609504.45167077}]
[]
[]
[]
[]
[null,{"$f":"'Model update'!$B$5&\"  Distribution price control\"","v":"2024-25  Distribution price control"}]
[]
[null,"Average price movement allowed",{"$f":"(1+C9)*(1-C10)*(1+C11)*(1+C12)*(1+C13)","v":1.0357230674526552}]
[]
[null,"Proposed distribution tariff revenue",{"$f":"IF('Prop2024-25DistTar'!G99=0,\"\",'Prop2024-25DistTar'!G99)","v":297524428.42824447}]
[null,"Existing distribution tariff revenue",{"$f":"IF('Prop2024-25DistTar'!H99=0,\"\",'Prop2024-25DistTar'!H99)","v":287262533.48075306}]
[null,"Average price movement",{"$f":"IF(C22=\"\",\"\",C22/C23)","v":1.0357230538321454}]
[]
[null,{"$f":"IF(C22=\"\",\"\",IF(C20>=C24,\"DISTRIBUTION PRICE CONTROL FORMULA COMPLIANT\",\"DISTRIBUTION PRICE CONTROL FORMULA BREACHED\"))","v":"DISTRIBUTION PRICE CONTROL FORMULA COMPLIANT"}]

{"sheet":"2024-25RebalContForm","index":4,"n_rows":456,"n_cols":7,"rows_kept":456,"cut":false,"hidden":false,"merged":[[335,1,335,2],[455,1,455,2],[275,1,275,2],[155,1,155,2],[305,1,305,2],[431,1,431,2],[359,1,359,2],[383,1,383,2],[407,1,407,2],[65,1,65,2],[95,1,95,2],[125,1,125,2],[215,1,215,2],[245,1,245,2],[185,1,185,2]]}
[null,{"$f":"\"Tariff Approval - \"&'Model update'!B3","v":"Tariff Approval - Aust. Gas Networks (Vic & Albury)"},{"$f":"'Model update'!B7&\"RebalContForm\"","v":"2024-25RebalContForm"}]
[]
[null,{"$f":"'Model update'!$B$5&\"  REBALANCING CONTROL FORMULA\"","v":"2024-25  REBALANCING CONTROL FORMULA"}]
[]
[]
[null,"Rebalancing control"]
[]
[null,{"$f":"'2024-25TarContForm'!B9","v":"CPI"},{"$f":"'2024-25TarContForm'!C9","v":4.0519877675840865E-2}]
[null,{"$f":"'2024-25TarContForm'!B10","v":"X-factor"},{"$f":"'2024-25TarContForm'!C10","v":9.7982408269751096E-4}]
[null,{"$f":"'2024-25TarContForm'!B11","v":"Pass-through Amount"},{"$f":"'2024-25TarContForm'!C11","v":0}]
[null,{"$f":"'2024-25TarContForm'!B12","v":"Safeguard Mechanism Amount"},{"$f":"'2024-25TarContForm'!C12","v":0}]
[null,{"$f":"'2024-25TarContForm'!B13","v":"Abolishment True-up Amount"},{"$f":"'2024-25TarContForm'!C13","v":-3.6337494104772272E-3}]
[null,"Y factor",0.02]
[]
[null,"Rebalancing control",{"$f":"(1+C8)*(1-C9)*(1+C10)*(1+C11)*(1+C13)","v":1.0602903582659922},null,null,"The abolishment true-up amount is not accounted for under the mechanism in the AA."]
[]
[]
[]
[null,"Rebalancing control summary"]
[null,null,"Existing","Proposed","Movement","Assessment"]
[null,{"$f":"B40","v":"Tariff R - Residential (Central)"},{"$f":"C61","v":219153099.16392457},{"$f":"C62","v":227068124.37515169},{"$f":"IF(C21=0,0,D21/C21)","v":1.0361164192586059},{"$f":"IF(E21=0,\"\",IF($C$15<=E21,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B70","v":"Tariff R - Residential (Northern)"},{"$f":"C91","v":27630427.101152446},{"$f":"C92","v":28579730.570644587},1.0343571768187596,"Compliant"]
[null,{"$f":"B100","v":"Tariff R - Residential (Murray Valley)"},{"$f":"C121","v":2490567.7367263837},{"$f":"C122","v":2562978.5289583411},1.0290740103809159,"Compliant"]
[null,{"$f":"B130","v":"Tariff R - Residential (Bairnsdale)"},{"$f":"C151","v":2237482.9494241481},{"$f":"C152","v":2325218.4524635216},1.0392116968140266,"Compliant"]
[null,{"$f":"B160","v":"Tariff R - Residential (Albury)"},{"$f":"C181","v":7282304.0270963628},{"$f":"C182","v":7502809.1119446438},{"$f":"IF(C25=0,0,D25/C25)","v":1.0302795769069535},{"$f":"IF(E25=0,\"\",IF($C$15<=E25,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B190","v":"Tariff C - Non-residential (Central)"},{"$f":"C211","v":19483685.634708554},{"$f":"C212","v":20175685.022014417},1.0355168626860374,"Compliant"]
[null,{"$f":"B220","v":"Tariff C - Non-residential (Northern)"},{"$f":"C241","v":2170043.4099905929},{"$f":"C242","v":2251207.7444334663},1.0374021708824825,"Compliant"]
[null,{"$f":"B250","v":"Tariff C - Non-residential (Murray Valley)"},{"$f":"C271","v":247726.23731551765},{"$f":"C272","v":257563.64838638844},1.0397108161714066,"Compliant"]
[null,{"$f":"B280","v":"Tariff C - Non-residential (Bairnsdale)"},{"$f":"C301","v":315262.49005160539},{"$f":"C302","v":325383.93894868554},1.0321048307885388,"Compliant"]
[null,{"$f":"B310","v":"Tariff C - Non-residential (Albury)"},{"$f":"C331","v":607101.52724689292},{"$f":"C332","v":629243.44722995395},{"$f":"IF(C30=0,0,D30/C30)","v":1.0364715273958724},{"$f":"IF(E30=0,\"\",IF($C$15<=E30,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B340","v":"Tariff D - AGN Central"},{"$f":"C355","v":3828507.0242445702},{"$f":"C356","v":3965272.7895805785},1.0357230023269957,"Compliant"]
[null,{"$f":"B364","v":"Tariff D - AGN North"},{"$f":"C379","v":1317374.1331271543},{"$f":"C380","v":1364434.6818520499},1.0357229943578627,"Compliant"]
[null,{"$f":"B388","v":"Tariff D - Murray Valley"},{"$f":"C403","v":325231.01720821945},{"$f":"C404","v":336849.24933655001},1.0357230138381677,"Compliant"]
[null,{"$f":"B412","v":"Tariff D - Bairnsdale"},{"$f":"C427","v":49721.001900538286},{"$f":"C428","v":51497.185962169999},1.0357230142945386,"Compliant"]
[null,{"$f":"B436","v":"Tariff D - Albury"},{"$f":"C451","v":124000.02663562306},{"$f":"C452","v":128429.68133746002},1.0357230141155824,"Compliant"]
[null,null,{"$f":"SUM(C21:C35)","v":287262533.48075324},{"$f":"SUM(D21:D35)","v":297524428.42824447},1.0357230538321447]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B6","v":"Tariff R - Residential (Central)"},1,2,3,4,5]
[null,null,1,2,3,4,5]
[null,"Distribution tariff","Fixed","Blk1","Blk2","Blk3"]
[]
[null,{"$f":"\"Existing : \"&'Prop2024-25DistTar'!C6","v":"Existing : Tariff V - AGN Central - Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$E$8:$E$11,C$41)","v":0.20445966648909583},{"$f":"INDEX('Prop2024-25DistTar'!$E$8:$E$11,D$41)","v":14.02842161134787},{"$f":"INDEX('Prop2024-25DistTar'!$E$8:$E$11,E$41)","v":8.0658073676089721},{"$f":"INDEX('Prop2024-25DistTar'!$E$8:$E$11,F$41)","v":3.9768253935643103}]
[]
[null,{"$f":"\"Proposed : \"&B40","v":"Proposed : Tariff R - Residential (Central)"},{"$f":"INDEX('Prop2024-25DistTar'!$D$8:$D$11,C$40)","v":0.2044},{"$f":"INDEX('Prop2024-25DistTar'!$D$8:$D$11,D$40)","v":15.150600000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$8:$D$11,E$40)","v":8.7110000000000003},{"$f":"INDEX('Prop2024-25DistTar'!$D$8:$D$11,F$40)","v":3.9767999999999999}]
[]
[null,"Distribution volumes (actual)",{"$f":"C$42","v":"Fixed"},{"$f":"D$42","v":"Blk1"},"Blk2","Blk3"]
[]
[null,{"$f":"B44","v":"Existing : Tariff V - AGN Central - Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$11,C$41)","v":219152514},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$11,D$41)","v":5206883.2767229257},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$11,E$41)","v":3232414.0846800189},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$11,F$41)","v":18916813.933209032}]
[]
[null,{"$f":"B46","v":"Proposed : Tariff R - Residential (Central)"},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$11,C$40)","v":219152514},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$11,D$40)","v":5206883.2767229257},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$11,E$40)","v":3232414.0846800189},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$11,F$40)","v":18916813.933209032}]
[]
[null,"Distribution revenue",{"$f":"C$42","v":"Fixed"},{"$f":"D$42","v":"Blk1"},"Blk2","Blk3"]
[]
[null,{"$f":"B50","v":"Existing : Tariff V - AGN Central - Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$H$8:$H$11,C$41)","v":44807849.922686905},{"$f":"INDEX('Prop2024-25DistTar'!$H$8:$H$11,D$41)","v":73044353.88694571},{"$f":"INDEX('Prop2024-25DistTar'!$H$8:$H$11,E$41)","v":26072029.339375108},{"$f":"INDEX('Prop2024-25DistTar'!$H$8:$H$11,F$41)","v":75228866.014916837}]
[]
[null,{"$f":"B52","v":"Proposed : Tariff R - Residential (Central)"},{"$f":"INDEX('Prop2024-25DistTar'!$G$8:$G$11,C$40)","v":44794773.861599997},{"$f":"INDEX('Prop2024-25DistTar'!$G$8:$G$11,D$40)","v":78887405.772318363},{"$f":"INDEX('Prop2024-25DistTar'!$G$8:$G$11,E$40)","v":28157559.091647647},{"$f":"INDEX('Prop2024-25DistTar'!$G$8:$G$11,F$40)","v":75228385.649585679}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B56","v":"Existing : Tariff V - AGN Central - Residential"},{"$f":"SUM(C56:F56)","v":219153099.16392457}]
[null,{"$f":"B58","v":"Proposed : Tariff R - Residential (Central)"},{"$f":"SUM(C58:F58)","v":227068124.37515169}]
[]
[null,"Average price movement",{"$f":"IF(C62=0,\"\",C62/C61)","v":1.0361164192586059}]
[]
[null,{"$f":"IF(C64=\"\",\"\",IF(C64<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B12","v":"Tariff R - Residential (Northern)"},1,2,3,4]
[null,null,1,2,3,4]
[null,"Distribution tariff","Fixed","Blk1","Blk2","Blk3"]
[]
[null,{"$f":"\"Existing : \"&'Prop2024-25DistTar'!C12","v":"Existing : Tariff V - AGN North - Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$E$14:$E$17,C$41)","v":0.20445966648909583},{"$f":"INDEX('Prop2024-25DistTar'!$E$14:$E$17,D$41)","v":12.342883129835361},{"$f":"INDEX('Prop2024-25DistTar'!$E$14:$E$17,E$41)","v":7.2251474937333109},{"$f":"INDEX('Prop2024-25DistTar'!$E$14:$E$17,F$41)","v":3.5628750052409588}]
[]
[null,{"$f":"\"Proposed : \"&B70","v":"Proposed : Tariff R - Residential (Northern)"},{"$f":"INDEX('Prop2024-25DistTar'!$D$14:$D$17,C$40)","v":0.2044},{"$f":"INDEX('Prop2024-25DistTar'!$D$14:$D$17,D$40)","v":13.330299999999999},{"$f":"INDEX('Prop2024-25DistTar'!$D$14:$D$17,E$40)","v":7.8030999999999997},{"$f":"INDEX('Prop2024-25DistTar'!$D$14:$D$17,F$40)","v":3.5634000000000001}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B74","v":"Existing : Tariff V - AGN North - Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$F$14:$F$17,C$41)","v":31295663},{"$f":"INDEX('Prop2024-25DistTar'!$F$14:$F$17,D$41)","v":711833.97202799423},{"$f":"INDEX('Prop2024-25DistTar'!$F$14:$F$17,E$41)","v":427223.43174900202},{"$f":"INDEX('Prop2024-25DistTar'!$F$14:$F$17,F$41)","v":2626780.4613119988}]
[]
[null,{"$f":"B76","v":"Proposed : Tariff R - Residential (Northern)"},{"$f":"INDEX('Prop2024-25DistTar'!$F$14:$F$17,C$40)","v":31295663},{"$f":"INDEX('Prop2024-25DistTar'!$F$14:$F$17,D$40)","v":711833.97202799423},{"$f":"INDEX('Prop2024-25DistTar'!$F$14:$F$17,E$40)","v":427223.43174900202},{"$f":"INDEX('Prop2024-25DistTar'!$F$14:$F$17,F$40)","v":2626780.4613119988}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B80","v":"Existing : Tariff V - AGN North - Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$H$14:$H$17,C$41)","v":6398700.8195351362},{"$f":"INDEX('Prop2024-25DistTar'!$H$14:$H$17,D$41)","v":8786083.5245880261},{"$f":"INDEX('Prop2024-25DistTar'!$H$14:$H$17,E$41)","v":3086752.3071654462},{"$f":"INDEX('Prop2024-25DistTar'!$H$14:$H$17,F$41)","v":9358890.4498638362}]
[]
[null,{"$f":"B82","v":"Proposed : Tariff R - Residential (Northern)"},{"$f":"INDEX('Prop2024-25DistTar'!$G$14:$G$17,C$40)","v":6396833.5171999997},{"$f":"INDEX('Prop2024-25DistTar'!$G$14:$G$17,D$40)","v":9488960.3973247707},{"$f":"INDEX('Prop2024-25DistTar'!$G$14:$G$17,E$40)","v":3333667.1602806374},{"$f":"INDEX('Prop2024-25DistTar'!$G$14:$G$17,F$40)","v":9360269.4958391767}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B86","v":"Existing : Tariff V - AGN North - Residential"},{"$f":"SUM(C86:F86)","v":27630427.101152446}]
[null,{"$f":"B88","v":"Proposed : Tariff R - Residential (Northern)"},{"$f":"SUM(C88:F88)","v":28579730.570644587}]
[]
[null,"Average price movement",{"$f":"IF(C92=0,\"\",C92/C91)","v":1.0343571768187596}]
[]
[null,{"$f":"IF(C94=\"\",\"\",IF(C94<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B18","v":"Tariff R - Residential (Murray Valley)"},1,2,3,4]
[null,null,1,2,3,4]
[null,"Distribution tariff","Fixed","Blk1","Blk2","Blk3"]
[]
[null,{"$f":"\"Existing : \"&'Prop2024-25DistTar'!C18","v":"Existing : Tariff V - Murray Valley - Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$E$20:$E$23,C$41)","v":0.26028885135017399},{"$f":"INDEX('Prop2024-25DistTar'!$E$20:$E$23,D$41)","v":10.745938057307789},{"$f":"INDEX('Prop2024-25DistTar'!$E$20:$E$23,E$41)","v":6.5008629340991888},{"$f":"INDEX('Prop2024-25DistTar'!$E$20:$E$23,F$41)","v":3.6526002696252395}]
[]
[null,{"$f":"\"Proposed : \"&B100","v":"Proposed : Tariff R - Residential (Murray Valley)"},{"$f":"INDEX('Prop2024-25DistTar'!$D$20:$D$23,C$40)","v":0.26019999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$D$20:$D$23,D$40)","v":11.605600000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$20:$D$23,E$40)","v":7.0209000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$20:$D$23,F$40)","v":3.6534}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B104","v":"Existing : Tariff V - Murray Valley - Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$F$20:$F$23,C$41)","v":3230069},{"$f":"INDEX('Prop2024-25DistTar'!$F$20:$F$23,D$41)","v":63590.374215999494},{"$f":"INDEX('Prop2024-25DistTar'!$F$20:$F$23,E$41)","v":34360.747417000071},{"$f":"INDEX('Prop2024-25DistTar'!$F$20:$F$23,F$41)","v":203445.21722699993}]
[]
[null,{"$f":"B106","v":"Proposed : Tariff R - Residential (Murray Valley)"},{"$f":"INDEX('Prop2024-25DistTar'!$F$20:$F$23,C$40)","v":3230069},{"$f":"INDEX('Prop2024-25DistTar'!$F$20:$F$23,D$40)","v":63590.374215999494},{"$f":"INDEX('Prop2024-25DistTar'!$F$20:$F$23,E$40)","v":34360.747417000071},{"$f":"INDEX('Prop2024-25DistTar'!$F$20:$F$23,F$40)","v":203445.21722699993}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B110","v":"Existing : Tariff V - Murray Valley - Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$H$20:$H$23,C$41)","v":840750.94979180512},{"$f":"INDEX('Prop2024-25DistTar'!$H$20:$H$23,D$41)","v":683338.22236615291},{"$f":"INDEX('Prop2024-25DistTar'!$H$20:$H$23,E$41)","v":223374.50927112022},{"$f":"INDEX('Prop2024-25DistTar'!$H$20:$H$23,F$41)","v":743104.05529730534}]
[]
[null,{"$f":"B112","v":"Proposed : Tariff R - Residential (Murray Valley)"},{"$f":"INDEX('Prop2024-25DistTar'!$G$20:$G$23,C$40)","v":840463.9537999999},{"$f":"INDEX('Prop2024-25DistTar'!$G$20:$G$23,D$40)","v":738004.44700120378},{"$f":"INDEX('Prop2024-25DistTar'!$G$20:$G$23,E$40)","v":241243.3715400158},{"$f":"INDEX('Prop2024-25DistTar'!$G$20:$G$23,F$40)","v":743266.75661712151}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B116","v":"Existing : Tariff V - Murray Valley - Residential"},{"$f":"SUM(C116:F116)","v":2490567.7367263837}]
[null,{"$f":"B118","v":"Proposed : Tariff R - Residential (Murray Valley)"},{"$f":"SUM(C118:F118)","v":2562978.5289583411}]
[]
[null,"Average price movement",{"$f":"IF(C122=0,\"\",C122/C121)","v":1.0290740103809159}]
[]
[null,{"$f":"IF(C124=\"\",\"\",IF(C124<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B24","v":"Tariff R - Residential (Bairnsdale)"},1,2,3,4]
[null,null,1,2,3,4]
[null,"Distribution tariff","Fixed","Blk1","Blk2","Blk3"]
[]
[null,{"$f":"\"Existing : \"&'Prop2024-25DistTar'!C24","v":"Existing : Tariff V - Bairnsdale - Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$E$26:$E$29,C$41)","v":0.33645776860688759},{"$f":"INDEX('Prop2024-25DistTar'!$E$26:$E$29,D$41)","v":22.903814277323267},{"$f":"INDEX('Prop2024-25DistTar'!$E$26:$E$29,E$41)","v":13.321629362430865},{"$f":"INDEX('Prop2024-25DistTar'!$E$26:$E$29,F$41)","v":6.5744335350564844}]
[]
[null,{"$f":"\"Proposed : \"&B130","v":"Proposed : Tariff R - Residential (Bairnsdale)"},{"$f":"INDEX('Prop2024-25DistTar'!$D$26:$D$29,C$40)","v":0.33639999999999998},{"$f":"INDEX('Prop2024-25DistTar'!$D$26:$D$29,D$40)","v":24.7361},{"$f":"INDEX('Prop2024-25DistTar'!$D$26:$D$29,E$40)","v":14.3873},{"$f":"INDEX('Prop2024-25DistTar'!$D$26:$D$29,F$40)","v":6.5772000000000004}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B134","v":"Existing : Tariff V - Bairnsdale - Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$F$26:$F$29,C$41)","v":1903886},{"$f":"INDEX('Prop2024-25DistTar'!$F$26:$F$29,D$41)","v":37197.471301999933},{"$f":"INDEX('Prop2024-25DistTar'!$F$26:$F$29,E$41)","v":18277.772623999987},{"$f":"INDEX('Prop2024-25DistTar'!$F$26:$F$29,F$41)","v":76273.039305000028}]
[]
[null,{"$f":"B136","v":"Proposed : Tariff R - Residential (Bairnsdale)"},{"$f":"INDEX('Prop2024-25DistTar'!$F$26:$F$29,C$40)","v":1903886},{"$f":"INDEX('Prop2024-25DistTar'!$F$26:$F$29,D$40)","v":37197.471301999933},{"$f":"INDEX('Prop2024-25DistTar'!$F$26:$F$29,E$40)","v":18277.772623999987},{"$f":"INDEX('Prop2024-25DistTar'!$F$26:$F$29,F$40)","v":76273.039305000028}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B140","v":"Existing : Tariff V - Bairnsdale - Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$H$26:$H$29,C$41)","v":640577.23524189275},{"$f":"INDEX('Prop2024-25DistTar'!$H$26:$H$29,D$41)","v":851963.97428706859},{"$f":"INDEX('Prop2024-25DistTar'!$H$26:$H$29,E$41)","v":243489.71246771328},{"$f":"INDEX('Prop2024-25DistTar'!$H$26:$H$29,F$41)","v":501452.02742747351}]
[]
[null,{"$f":"B142","v":"Proposed : Tariff R - Residential (Bairnsdale)"},{"$f":"INDEX('Prop2024-25DistTar'!$G$26:$G$29,C$40)","v":640467.2503999999},{"$f":"INDEX('Prop2024-25DistTar'!$G$26:$G$29,D$40)","v":920120.36987340054},{"$f":"INDEX('Prop2024-25DistTar'!$G$26:$G$29,E$40)","v":262967.79807327501},{"$f":"INDEX('Prop2024-25DistTar'!$G$26:$G$29,F$40)","v":501663.03411684622}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B146","v":"Existing : Tariff V - Bairnsdale - Residential"},{"$f":"SUM(C146:F146)","v":2237482.9494241481}]
[null,{"$f":"B148","v":"Proposed : Tariff R - Residential (Bairnsdale)"},{"$f":"SUM(C148:F148)","v":2325218.4524635216}]
[]
[null,"Average price movement",{"$f":"IF(C152=0,\"\",C152/C151)","v":1.0392116968140266}]
[]
[null,{"$f":"IF(C154=\"\",\"\",IF(C154<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B30","v":"Tariff R - Residential (Albury)"},1,2,3,4]
[null,null,1,2,3,4]
[null,"Distribution tariff","Fixed","Blk1","Blk2","Blk3"]
[]
[null,{"$f":"\"Existing : \"&'Prop2024-25DistTar'!C30","v":"Existing : Tariff V - Albury - Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$E$32:$E$35,C$41)","v":0.26619152882969371},{"$f":"INDEX('Prop2024-25DistTar'!$E$32:$E$35,D$41)","v":10.158710896939564},{"$f":"INDEX('Prop2024-25DistTar'!$E$32:$E$35,E$41)","v":6.0720955296389842},{"$f":"INDEX('Prop2024-25DistTar'!$E$32:$E$35,F$41)","v":2.9948893866615651}]
[]
[null,{"$f":"\"Proposed : \"&B160","v":"Proposed : Tariff R - Residential (Albury)"},{"$f":"INDEX('Prop2024-25DistTar'!$D$32:$D$35,C$40)","v":0.26600000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$32:$D$35,D$40)","v":10.971399999999999},{"$f":"INDEX('Prop2024-25DistTar'!$D$32:$D$35,E$40)","v":6.5578000000000003},{"$f":"INDEX('Prop2024-25DistTar'!$D$32:$D$35,F$40)","v":2.9948000000000001}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B164","v":"Existing : Tariff V - Albury - Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$F$32:$F$35,C$41)","v":8744581},{"$f":"INDEX('Prop2024-25DistTar'!$F$32:$F$35,D$41)","v":201205.15896599702},{"$f":"INDEX('Prop2024-25DistTar'!$F$32:$F$35,E$41)","v":120912.29372200096},{"$f":"INDEX('Prop2024-25DistTar'!$F$32:$F$35,F$41)","v":726702.83327600046}]
[]
[null,{"$f":"B166","v":"Proposed : Tariff R - Residential (Albury)"},{"$f":"INDEX('Prop2024-25DistTar'!$F$32:$F$35,C$40)","v":8744581},{"$f":"INDEX('Prop2024-25DistTar'!$F$32:$F$35,D$40)","v":201205.15896599702},{"$f":"INDEX('Prop2024-25DistTar'!$F$32:$F$35,E$40)","v":120912.29372200096},{"$f":"INDEX('Prop2024-25DistTar'!$F$32:$F$35,F$40)","v":726702.83327600046}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3"]
[]
[null,{"$f":"B170","v":"Existing : Tariff V - Albury - Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$H$32:$H$35,C$41)","v":2327733.3853650917},{"$f":"INDEX('Prop2024-25DistTar'!$H$32:$H$35,D$41)","v":2043985.0409083311},{"$f":"INDEX('Prop2024-25DistTar'!$H$32:$H$35,E$41)","v":734190.99818775791},{"$f":"INDEX('Prop2024-25DistTar'!$H$32:$H$35,F$41)","v":2176394.6026351824}]
[]
[null,{"$f":"B172","v":"Proposed : Tariff R - Residential (Albury)"},{"$f":"INDEX('Prop2024-25DistTar'!$G$32:$G$35,C$40)","v":2326058.5460000001},{"$f":"INDEX('Prop2024-25DistTar'!$G$32:$G$35,D$40)","v":2207502.2810795396},{"$f":"INDEX('Prop2024-25DistTar'!$G$32:$G$35,E$40)","v":792918.63977013796},{"$f":"INDEX('Prop2024-25DistTar'!$G$32:$G$35,F$40)","v":2176329.6450949661}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B176","v":"Existing : Tariff V - Albury - Residential"},{"$f":"SUM(C176:G176)","v":7282304.0270963628}]
[null,{"$f":"B178","v":"Proposed : Tariff R - Residential (Albury)"},{"$f":"SUM(C178:G178)","v":7502809.1119446438}]
[]
[null,"Average price movement",{"$f":"IF(C182=0,\"\",C182/C181)","v":1.0302795769069535}]
[]
[null,{"$f":"IF(C184=\"\",\"\",IF(C184<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B36","v":"Tariff C - Non-residential (Central)"},1,2,3,4,5]
[null,null,1,2,3,4,5]
[null,"Distribution tariff","Fixed","Blk1","Blk2","Blk3","Blk4"]
[]
[null,{"$f":"\"Existing : \"&'Prop2024-25DistTar'!C36","v":"Existing : Tariff V - AGN Central - Non Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$E$38:$E$42,C$41)","v":0.20445966648909583},{"$f":"INDEX('Prop2024-25DistTar'!$E$38:$E$42,D$41)","v":9.9026028888518649},{"$f":"INDEX('Prop2024-25DistTar'!$E$38:$E$42,E$41)","v":4.1978458842723789},{"$f":"INDEX('Prop2024-25DistTar'!$E$38:$E$42,F$41)","v":3.1311236183643039},{"$f":"INDEX('Prop2024-25DistTar'!$E$38:$E$42,G$41)","v":1.2645911689023099}]
[]
[null,{"$f":"\"Proposed : \"&B190","v":"Proposed : Tariff C - Non-residential (Central)"},{"$f":"INDEX('Prop2024-25DistTar'!$D$38:$D$42,C$40)","v":0.2044},{"$f":"INDEX('Prop2024-25DistTar'!$D$38:$D$42,D$40)","v":10.6936},{"$f":"INDEX('Prop2024-25DistTar'!$D$38:$D$42,E$40)","v":4.5331000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$38:$D$42,F$40)","v":3.1311},{"$f":"INDEX('Prop2024-25DistTar'!$D$38:$D$42,G$40)","v":1.2645}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B194","v":"Existing : Tariff V - AGN Central - Non Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$F$38:$F$42,C$41)","v":7430525},{"$f":"INDEX('Prop2024-25DistTar'!$F$38:$F$42,D$41)","v":263322.02451700019},{"$f":"INDEX('Prop2024-25DistTar'!$F$38:$F$42,E$41)","v":1445422.826917998},{"$f":"INDEX('Prop2024-25DistTar'!$F$38:$F$42,F$41)","v":1194962.2884559995},{"$f":"INDEX('Prop2024-25DistTar'!$F$38:$F$42,G$41)","v":4386898.1198520083}]
[]
[null,{"$f":"B196","v":"Proposed : Tariff C - Non-residential (Central)"},{"$f":"INDEX('Prop2024-25DistTar'!$F$38:$F$42,C$40)","v":7430525},{"$f":"INDEX('Prop2024-25DistTar'!$F$38:$F$42,D$40)","v":263322.02451700019},{"$f":"INDEX('Prop2024-25DistTar'!$F$38:$F$42,E$40)","v":1445422.826917998},{"$f":"INDEX('Prop2024-25DistTar'!$F$38:$F$42,F$40)","v":1194962.2884559995},{"$f":"INDEX('Prop2024-25DistTar'!$F$38:$F$42,G$40)","v":4386898.1198520083}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B200","v":"Existing : Tariff V - AGN Central - Non Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$H$38:$H$42,C$41)","v":1519242.6633388889},{"$f":"INDEX('Prop2024-25DistTar'!$H$38:$H$42,D$41)","v":2607573.4406803679},{"$f":"INDEX('Prop2024-25DistTar'!$H$38:$H$42,E$41)","v":6067662.2650110647},{"$f":"INDEX('Prop2024-25DistTar'!$H$38:$H$42,F$41)","v":3741574.6444392381},{"$f":"INDEX('Prop2024-25DistTar'!$H$38:$H$42,G$41)","v":5547632.6212389972}]
[]
[null,{"$f":"B202","v":"Proposed : Tariff C - Non-residential (Central)"},{"$f":"INDEX('Prop2024-25DistTar'!$G$38:$G$42,C$40)","v":1518799.31},{"$f":"INDEX('Prop2024-25DistTar'!$G$38:$G$42,D$40)","v":2815860.4013749934},{"$f":"INDEX('Prop2024-25DistTar'!$G$38:$G$42,E$40)","v":6552246.216701977},{"$f":"INDEX('Prop2024-25DistTar'!$G$38:$G$42,F$40)","v":3741546.42138458},{"$f":"INDEX('Prop2024-25DistTar'!$G$38:$G$42,G$40)","v":5547232.6725528641}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B206","v":"Existing : Tariff V - AGN Central - Non Residential"},{"$f":"SUM(C206:G206)","v":19483685.634708554}]
[null,{"$f":"B208","v":"Proposed : Tariff C - Non-residential (Central)"},{"$f":"SUM(C208:G208)","v":20175685.022014417}]
[]
[null,"Average price movement",{"$f":"IF(C212=0,\"\",C212/C211)","v":1.0355168626860374}]
[]
[null,{"$f":"IF(C214=\"\",\"\",IF(C214<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B43","v":"Tariff C - Non-residential (Northern)"},1,2,3,4,5]
[null,null,1,2,3,4,5]
[null,"Distribution tariff","Fixed","Blk1","Blk2","Blk3","Blk4"]
[]
[null,{"$f":"\"Existing : \"&'Prop2024-25DistTar'!C43","v":"Existing : Tariff V - AGN North - Non Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$E$45:$E$49,C$41)","v":0.20445966648909583},{"$f":"INDEX('Prop2024-25DistTar'!$E$45:$E$49,D$41)","v":8.8826982780984292},{"$f":"INDEX('Prop2024-25DistTar'!$E$45:$E$49,E$41)","v":3.7938764026523244},{"$f":"INDEX('Prop2024-25DistTar'!$E$45:$E$49,F$41)","v":2.8295356024120921},{"$f":"INDEX('Prop2024-25DistTar'!$E$45:$E$49,G$41)","v":1.1432768492818197}]
[]
[null,{"$f":"\"Proposed : \"&B220","v":"Proposed : Tariff C - Non-residential (Northern)"},{"$f":"INDEX('Prop2024-25DistTar'!$D$45:$D$49,C$40)","v":0.2044},{"$f":"INDEX('Prop2024-25DistTar'!$D$45:$D$49,D$40)","v":9.5922999999999998},{"$f":"INDEX('Prop2024-25DistTar'!$D$45:$D$49,E$40)","v":4.0968999999999998},{"$f":"INDEX('Prop2024-25DistTar'!$D$45:$D$49,F$40)","v":2.8294999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$D$45:$D$49,G$40)","v":1.1432}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B224","v":"Existing : Tariff V - AGN North - Non Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$F$45:$F$49,C$41)","v":1196061},{"$f":"INDEX('Prop2024-25DistTar'!$F$45:$F$49,D$41)","v":36896.722905000031},{"$f":"INDEX('Prop2024-25DistTar'!$F$45:$F$49,E$41)","v":181815.904839},{"$f":"INDEX('Prop2024-25DistTar'!$F$45:$F$49,F$41)","v":130947.20439899989},{"$f":"INDEX('Prop2024-25DistTar'!$F$45:$F$49,G$41)","v":470094.24906400038}]
[]
[null,{"$f":"B226","v":"Proposed : Tariff C - Non-residential (Northern)"},{"$f":"INDEX('Prop2024-25DistTar'!$F$45:$F$49,C$40)","v":1196061},{"$f":"INDEX('Prop2024-25DistTar'!$F$45:$F$49,D$40)","v":36896.722905000031},{"$f":"INDEX('Prop2024-25DistTar'!$F$45:$F$49,E$40)","v":181815.904839},{"$f":"INDEX('Prop2024-25DistTar'!$F$45:$F$49,F$40)","v":130947.20439899989},{"$f":"INDEX('Prop2024-25DistTar'!$F$45:$F$49,G$40)","v":470094.24906400038}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B230","v":"Existing : Tariff V - AGN North - Non Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$H$45:$H$49,C$41)","v":244546.23316061444},{"$f":"INDEX('Prop2024-25DistTar'!$H$45:$H$49,D$41)","v":327742.45701571862},{"$f":"INDEX('Prop2024-25DistTar'!$H$45:$H$49,E$41)","v":689787.07099556259},{"$f":"INDEX('Prop2024-25DistTar'!$H$45:$H$49,F$41)","v":370519.77688330354},{"$f":"INDEX('Prop2024-25DistTar'!$H$45:$H$49,G$41)","v":537447.87193539343}]
[]
[null,{"$f":"B232","v":"Proposed : Tariff C - Non-residential (Northern)"},{"$f":"INDEX('Prop2024-25DistTar'!$G$45:$G$49,C$40)","v":244474.86840000001},{"$f":"INDEX('Prop2024-25DistTar'!$G$45:$G$49,D$40)","v":353924.43512163177},{"$f":"INDEX('Prop2024-25DistTar'!$G$45:$G$49,E$40)","v":744881.58053489903},{"$f":"INDEX('Prop2024-25DistTar'!$G$45:$G$49,F$40)","v":370515.11484697019},{"$f":"INDEX('Prop2024-25DistTar'!$G$45:$G$49,G$40)","v":537411.74552996526}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B236","v":"Existing : Tariff V - AGN North - Non Residential"},{"$f":"SUM(C236:G236)","v":2170043.4099905929}]
[null,{"$f":"B238","v":"Proposed : Tariff C - Non-residential (Northern)"},{"$f":"SUM(C238:G238)","v":2251207.7444334663}]
[]
[null,"Average price movement",{"$f":"IF(C242=0,\"\",C242/C241)","v":1.0374021708824825}]
[]
[null,{"$f":"IF(C244=\"\",\"\",IF(C244<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B50","v":"Tariff C - Non-residential (Murray Valley)"},1,2,3,4,5]
[null,null,1,2,3,4,5]
[null,"Distribution tariff","Fixed","Blk1","Blk2","Blk3","Blk4"]
[]
[null,{"$f":"\"Existing : \"&'Prop2024-25DistTar'!C50","v":"Existing : Tariff V - Murray Valley - Non Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$E$52:$E$56,C$41)","v":0.26028885135017399},{"$f":"INDEX('Prop2024-25DistTar'!$E$52:$E$56,D$41)","v":7.9423322331351907},{"$f":"INDEX('Prop2024-25DistTar'!$E$52:$E$56,E$41)","v":4.2132802760816013},{"$f":"INDEX('Prop2024-25DistTar'!$E$52:$E$56,F$41)","v":3.1443971953202348},{"$f":"INDEX('Prop2024-25DistTar'!$E$52:$E$56,G$41)","v":1.4233596126465136}]
[]
[null,{"$f":"\"Proposed : \"&B250","v":"Proposed : Tariff C - Non-residential (Murray Valley)"},{"$f":"INDEX('Prop2024-25DistTar'!$D$52:$D$56,C$40)","v":0.26019999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$D$52:$D$56,D$40)","v":8.5768000000000004},{"$f":"INDEX('Prop2024-25DistTar'!$D$52:$D$56,E$40)","v":4.5498000000000003},{"$f":"INDEX('Prop2024-25DistTar'!$D$52:$D$56,F$40)","v":3.1442999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$D$52:$D$56,G$40)","v":1.4233}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B254","v":"Existing : Tariff V - Murray Valley - Non Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$F$52:$F$56,C$41)","v":134317},{"$f":"INDEX('Prop2024-25DistTar'!$F$52:$F$56,D$41)","v":4498.1406140000026},{"$f":"INDEX('Prop2024-25DistTar'!$F$52:$F$56,E$41)","v":20797.376636999994},{"$f":"INDEX('Prop2024-25DistTar'!$F$52:$F$56,F$41)","v":12680.840052000001},{"$f":"INDEX('Prop2024-25DistTar'!$F$52:$F$56,G$41)","v":34805.341790000013}]
[]
[null,{"$f":"B256","v":"Proposed : Tariff C - Non-residential (Murray Valley)"},{"$f":"INDEX('Prop2024-25DistTar'!$F$52:$F$56,C$40)","v":134317},{"$f":"INDEX('Prop2024-25DistTar'!$F$52:$F$56,D$40)","v":4498.1406140000026},{"$f":"INDEX('Prop2024-25DistTar'!$F$52:$F$56,E$40)","v":20797.376636999994},{"$f":"INDEX('Prop2024-25DistTar'!$F$52:$F$56,F$40)","v":12680.840052000001},{"$f":"INDEX('Prop2024-25DistTar'!$F$52:$F$56,G$40)","v":34805.341790000013}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B260","v":"Existing : Tariff V - Murray Valley - Non Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$H$52:$H$56,C$41)","v":34961.21764680132},{"$f":"INDEX('Prop2024-25DistTar'!$H$52:$H$56,D$41)","v":35725.727187746736},{"$f":"INDEX('Prop2024-25DistTar'!$H$52:$H$56,E$41)","v":87625.176778912384},{"$f":"INDEX('Prop2024-25DistTar'!$H$52:$H$56,F$41)","v":39873.597893813305},{"$f":"INDEX('Prop2024-25DistTar'!$H$52:$H$56,G$41)","v":49540.517808243931}]
[]
[null,{"$f":"B262","v":"Proposed : Tariff C - Non-residential (Murray Valley)"},{"$f":"INDEX('Prop2024-25DistTar'!$G$52:$G$56,C$40)","v":34949.2834},{"$f":"INDEX('Prop2024-25DistTar'!$G$52:$G$56,D$40)","v":38579.652418155223},{"$f":"INDEX('Prop2024-25DistTar'!$G$52:$G$56,E$40)","v":94623.904223022575},{"$f":"INDEX('Prop2024-25DistTar'!$G$52:$G$56,F$40)","v":39872.365375503599},{"$f":"INDEX('Prop2024-25DistTar'!$G$52:$G$56,G$40)","v":49538.442969707015}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B266","v":"Existing : Tariff V - Murray Valley - Non Residential"},{"$f":"SUM(C266:G266)","v":247726.23731551765}]
[null,{"$f":"B268","v":"Proposed : Tariff C - Non-residential (Murray Valley)"},{"$f":"SUM(C268:G268)","v":257563.64838638844}]
[]
[null,"Average price movement",{"$f":"IF(C272=0,\"\",C272/C271)","v":1.0397108161714066}]
[]
[null,{"$f":"IF(C274=\"\",\"\",IF(C274<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B57","v":"Tariff C - Non-residential (Bairnsdale)"},1,2,3,4,5]
[null,null,1,2,3,4,5]
[null,"Distribution tariff","Fixed","Blk1","Blk2","Blk3","Blk4"]
[]
[null,{"$f":"\"Existing : \"&'Prop2024-25DistTar'!C57","v":"Existing : Tariff V - Bairnsdale - Non Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$E$59:$E$63,C$41)","v":0.33645776860688759},{"$f":"INDEX('Prop2024-25DistTar'!$E$59:$E$63,D$41)","v":16.283797838456881},{"$f":"INDEX('Prop2024-25DistTar'!$E$59:$E$63,E$41)","v":7.1303803280246845},{"$f":"INDEX('Prop2024-25DistTar'!$E$59:$E$63,F$41)","v":5.3163248107140468},{"$f":"INDEX('Prop2024-25DistTar'!$E$59:$E$63,G$41)","v":2.1312837169628596}]
[]
[null,{"$f":"\"Proposed : \"&B280","v":"Proposed : Tariff C - Non-residential (Bairnsdale)"},{"$f":"INDEX('Prop2024-25DistTar'!$D$59:$D$63,C$40)","v":0.33639999999999998},{"$f":"INDEX('Prop2024-25DistTar'!$D$59:$D$63,D$40)","v":17.584599999999998},{"$f":"INDEX('Prop2024-25DistTar'!$D$59:$D$63,E$40)","v":7.7},{"$f":"INDEX('Prop2024-25DistTar'!$D$59:$D$63,F$40)","v":5.3163},{"$f":"INDEX('Prop2024-25DistTar'!$D$59:$D$63,G$40)","v":2.1313}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B284","v":"Existing : Tariff V - Bairnsdale - Non Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$F$59:$F$63,C$40)","v":46322},{"$f":"INDEX('Prop2024-25DistTar'!$F$59:$F$63,D$40)","v":1906.5132769999993},{"$f":"INDEX('Prop2024-25DistTar'!$F$59:$F$63,E$40)","v":13418.648190999997},{"$f":"INDEX('Prop2024-25DistTar'!$F$59:$F$63,F$40)","v":10990.360774000006},{"$f":"INDEX('Prop2024-25DistTar'!$F$59:$F$63,G$40)","v":53734.48070399998}]
[]
[null,{"$f":"B286","v":"Proposed : Tariff C - Non-residential (Bairnsdale)"},{"$f":"INDEX('Prop2024-25DistTar'!$F$59:$F$63,C$40)","v":46322},{"$f":"INDEX('Prop2024-25DistTar'!$F$59:$F$63,D$40)","v":1906.5132769999993},{"$f":"INDEX('Prop2024-25DistTar'!$F$59:$F$63,E$40)","v":13418.648190999997},{"$f":"INDEX('Prop2024-25DistTar'!$F$59:$F$63,F$40)","v":10990.360774000006},{"$f":"INDEX('Prop2024-25DistTar'!$F$59:$F$63,G$40)","v":53734.48070399998}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B290","v":"Existing : Tariff V - Bairnsdale - Non Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$H$59:$H$63,C$41)","v":15585.396757408247},{"$f":"INDEX('Prop2024-25DistTar'!$H$59:$H$63,D$41)","v":31045.276779001932},{"$f":"INDEX('Prop2024-25DistTar'!$H$59:$H$63,E$41)","v":95680.065089790398},{"$f":"INDEX('Prop2024-25DistTar'!$H$59:$H$63,F$41)","v":58428.327661514668},{"$f":"INDEX('Prop2024-25DistTar'!$H$59:$H$63,G$41)","v":114523.42376389012}]
[]
[null,{"$f":"B292","v":"Proposed : Tariff C - Non-residential (Bairnsdale)"},{"$f":"INDEX('Prop2024-25DistTar'!$G$59:$G$63,C$40)","v":15582.720799999999},{"$f":"INDEX('Prop2024-25DistTar'!$G$59:$G$63,D$40)","v":33525.273370734183},{"$f":"INDEX('Prop2024-25DistTar'!$G$59:$G$63,E$40)","v":103323.59107069997},{"$f":"INDEX('Prop2024-25DistTar'!$G$59:$G$63,F$40)","v":58428.054982816233},{"$f":"INDEX('Prop2024-25DistTar'!$G$59:$G$63,G$40)","v":114524.29872443515}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B296","v":"Existing : Tariff V - Bairnsdale - Non Residential"},{"$f":"SUM(C296:G296)","v":315262.49005160539}]
[null,{"$f":"B298","v":"Proposed : Tariff C - Non-residential (Bairnsdale)"},{"$f":"SUM(C298:G298)","v":325383.93894868554}]
[]
[null,"Average price movement",{"$f":"IF(C302=0,\"\",C302/C301)","v":1.0321048307885388}]
[]
[null,{"$f":"IF(C304=\"\",\"\",IF(C304<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B64","v":"Tariff C - Non-residential (Albury)"},1,2,3,4,5]
[null,null,1,2,3,4,5]
[null,"Distribution tariff","Fixed","Blk1","Blk2","Blk3","Blk4"]
[]
[null,{"$f":"\"Existing : \"&'Prop2024-25DistTar'!C64","v":"Existing : Tariff V - Albury - Non Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$E$66:$E$70,C$41)","v":0.26619152882969371},{"$f":"INDEX('Prop2024-25DistTar'!$E$66:$E$70,D$41)","v":7.4559430992538882},{"$f":"INDEX('Prop2024-25DistTar'!$E$66:$E$70,E$41)","v":3.3066641012078626},{"$f":"INDEX('Prop2024-25DistTar'!$E$66:$E$70,F$41)","v":2.3480854739097405},{"$f":"INDEX('Prop2024-25DistTar'!$E$66:$E$70,G$41)","v":0.94818613681324537}]
[]
[null,{"$f":"\"Proposed : \"&B310","v":"Proposed : Tariff C - Non-residential (Albury)"},{"$f":"INDEX('Prop2024-25DistTar'!$D$66:$D$70,C$40)","v":0.26600000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$66:$D$70,D$40)","v":8.0515000000000008},{"$f":"INDEX('Prop2024-25DistTar'!$D$66:$D$70,E$40)","v":3.5708000000000002},{"$f":"INDEX('Prop2024-25DistTar'!$D$66:$D$70,F$40)","v":2.3479999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$D$66:$D$70,G$40)","v":0.94810000000000005}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B314","v":"Existing : Tariff V - Albury - Non Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$F$66:$F$70,C$40)","v":343646},{"$f":"INDEX('Prop2024-25DistTar'!$F$66:$F$70,D$40)","v":11287.540863000004},{"$f":"INDEX('Prop2024-25DistTar'!$F$66:$F$70,E$40)","v":58687.201406999979},{"$f":"INDEX('Prop2024-25DistTar'!$F$66:$F$70,F$40)","v":43302.458535999962},{"$f":"INDEX('Prop2024-25DistTar'!$F$66:$F$70,G$40)","v":143146.866939}]
[]
[null,{"$f":"B316","v":"Proposed : Tariff C - Non-residential (Albury)"},{"$f":"INDEX('Prop2024-25DistTar'!$F$66:$F$70,C$40)","v":343646},{"$f":"INDEX('Prop2024-25DistTar'!$F$66:$F$70,D$40)","v":11287.540863000004},{"$f":"INDEX('Prop2024-25DistTar'!$F$66:$F$70,E$40)","v":58687.201406999979},{"$f":"INDEX('Prop2024-25DistTar'!$F$66:$F$70,F$40)","v":43302.458535999962},{"$f":"INDEX('Prop2024-25DistTar'!$F$66:$F$70,G$40)","v":143146.866939}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4"]
[]
[null,{"$f":"B320","v":"Existing : Tariff V - Albury - Non Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$H$66:$H$70,C$41)","v":91475.654116208927},{"$f":"INDEX('Prop2024-25DistTar'!$H$66:$H$70,D$41)","v":84159.262405031157},{"$f":"INDEX('Prop2024-25DistTar'!$H$66:$H$70,E$41)","v":194058.86209288239},{"$f":"INDEX('Prop2024-25DistTar'!$H$66:$H$70,F$41)","v":101677.87387296036},{"$f":"INDEX('Prop2024-25DistTar'!$H$66:$H$70,G$41)","v":135729.87475981007}]
[]
[null,{"$f":"B322","v":"Proposed : Tariff C - Non-residential (Albury)"},{"$f":"INDEX('Prop2024-25DistTar'!$G$66:$G$70,C$40)","v":91409.83600000001},{"$f":"INDEX('Prop2024-25DistTar'!$G$66:$G$70,D$40)","v":90881.635258444541},{"$f":"INDEX('Prop2024-25DistTar'!$G$66:$G$70,E$40)","v":209560.25878411555},{"$f":"INDEX('Prop2024-25DistTar'!$G$66:$G$70,F$40)","v":101674.1726425279},{"$f":"INDEX('Prop2024-25DistTar'!$G$66:$G$70,G$40)","v":135717.5445448659}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B326","v":"Existing : Tariff V - Albury - Non Residential"},{"$f":"SUM(C326:G326)","v":607101.52724689292}]
[null,{"$f":"B328","v":"Proposed : Tariff C - Non-residential (Albury)"},{"$f":"SUM(C328:G328)","v":629243.44722995395}]
[]
[null,"Average price movement",{"$f":"IF(C332=0,\"\",C332/C331)","v":1.0364715273958724}]
[]
[null,{"$f":"IF(C334=\"\",\"\",IF(C334<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B72","v":"Tariff D - AGN Central"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&'Prop2024-25DistTar'!C72","v":"Existing: Tariff D - AGN Central"},{"$f":"INDEX('Prop2024-25DistTar'!$E$73:$E$75,C341)","v":1616.5076496660338},{"$f":"INDEX('Prop2024-25DistTar'!$E$73:$E$75,D341)","v":988.22922581903811},{"$f":"INDEX('Prop2024-25DistTar'!$E$73:$E$75,E341)","v":180.47094785904252}]
[null,{"$f":"\"Proposed: \"&B340","v":"Proposed: Tariff D - AGN Central"},{"$f":"INDEX('Prop2024-25DistTar'!$D$73:$D$75,C341)","v":1674.2542000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$73:$D$75,D341)","v":1023.5317},{"$f":"INDEX('Prop2024-25DistTar'!$D$73:$D$75,E341)","v":186.9179}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B343","v":"Existing: Tariff D - AGN Central"},{"$f":"INDEX('Prop2024-25DistTar'!$F$73:$F$75,C$40)","v":1479.135499999999},{"$f":"INDEX('Prop2024-25DistTar'!$F$73:$F$75,D$40)","v":1231.2340999999999},{"$f":"INDEX('Prop2024-25DistTar'!$F$73:$F$75,E$40)","v":1223.0869000000002}]
[null,{"$f":"B344","v":"Proposed: Tariff D - AGN Central"},{"$f":"INDEX('Prop2024-25DistTar'!$F$73:$F$75,C$40)","v":1479.135499999999},{"$f":"INDEX('Prop2024-25DistTar'!$F$73:$F$75,D$40)","v":1231.2340999999999},{"$f":"INDEX('Prop2024-25DistTar'!$F$73:$F$75,E$40)","v":1223.0869000000002}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B347","v":"Existing: Tariff D - AGN Central"},{"$f":"INDEX('Prop2024-25DistTar'!$H$73:$H$75,C341)","v":2391033.8506425922},{"$f":"INDEX('Prop2024-25DistTar'!$H$73:$H$75,D341)","v":1216741.5214450001},{"$f":"INDEX('Prop2024-25DistTar'!$H$73:$H$75,E341)","v":220731.652156978}]
[null,{"$f":"B348","v":"Proposed: Tariff D - AGN Central"},{"$f":"INDEX('Prop2024-25DistTar'!$G$73:$G$75,C341)","v":2476448.8232440986},{"$f":"INDEX('Prop2024-25DistTar'!$G$73:$G$75,D341)","v":1260207.1314709699},{"$f":"INDEX('Prop2024-25DistTar'!$G$73:$G$75,E341)","v":228616.83486551006}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B351","v":"Existing: Tariff D - AGN Central"},{"$f":"SUM(C351:E351)","v":3828507.0242445702}]
[null,{"$f":"B352","v":"Proposed: Tariff D - AGN Central"},{"$f":"SUM(C352:E352)","v":3965272.7895805785}]
[]
[null,"Average price movement",{"$f":"IF(C356=0,\"\",C356/C355)","v":1.0357230023269957}]
[]
[null,{"$f":"IF(C358=\"\",\"\",IF(C358<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B77","v":"Tariff D - AGN North"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&'Prop2024-25DistTar'!C77","v":"Existing: Tariff D - AGN North"},{"$f":"INDEX('Prop2024-25DistTar'!$E$78:$E$80,C365)","v":1616.5076496660338},{"$f":"INDEX('Prop2024-25DistTar'!$E$78:$E$80,D365)","v":988.22922581903811},{"$f":"INDEX('Prop2024-25DistTar'!$E$78:$E$80,E365)","v":180.47094785904252}]
[null,{"$f":"\"Proposed: \"&B364","v":"Proposed: Tariff D - AGN North"},{"$f":"INDEX('Prop2024-25DistTar'!$D$78:$D$80,C365)","v":1674.2542000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$78:$D$80,D365)","v":1023.5317},{"$f":"INDEX('Prop2024-25DistTar'!$D$78:$D$80,E365)","v":186.9179}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B367","v":"Existing: Tariff D - AGN North"},{"$f":"INDEX('Prop2024-25DistTar'!$F$78:$F$80,C$40)","v":412.15229999999997},{"$f":"INDEX('Prop2024-25DistTar'!$F$78:$F$80,D$40)","v":589.9677999999999},{"$f":"INDEX('Prop2024-25DistTar'!$F$78:$F$80,E$40)","v":377.36469999999997}]
[null,{"$f":"B368","v":"Proposed: Tariff D - AGN North"},{"$f":"INDEX('Prop2024-25DistTar'!$F$78:$F$80,C$40)","v":412.15229999999997},{"$f":"INDEX('Prop2024-25DistTar'!$F$78:$F$80,D$40)","v":589.9677999999999},{"$f":"INDEX('Prop2024-25DistTar'!$F$78:$F$80,E$40)","v":377.36469999999997}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B371","v":"Existing: Tariff D - AGN North"},{"$f":"INDEX('Prop2024-25DistTar'!$H$78:$H$80,C365)","v":666247.34577745001},{"$f":"INDEX('Prop2024-25DistTar'!$H$78:$H$80,D365)","v":583023.42225216096},{"$f":"INDEX('Prop2024-25DistTar'!$H$78:$H$80,E365)","v":68103.365097543225}]
[null,{"$f":"B372","v":"Proposed: Tariff D - AGN North"},{"$f":"INDEX('Prop2024-25DistTar'!$G$78:$G$80,C365)","v":690047.71931465995},{"$f":"INDEX('Prop2024-25DistTar'!$G$78:$G$80,D365)","v":603850.74527925986},{"$f":"INDEX('Prop2024-25DistTar'!$G$78:$G$80,E365)","v":70536.217258129996}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B375","v":"Existing: Tariff D - AGN North"},{"$f":"SUM(C375:E375)","v":1317374.1331271543}]
[null,{"$f":"B376","v":"Proposed: Tariff D - AGN North"},{"$f":"SUM(C376:E376)","v":1364434.6818520499}]
[]
[null,"Average price movement",{"$f":"IF(C380=0,\"\",C380/C379)","v":1.0357229943578627}]
[]
[null,{"$f":"IF(C382=\"\",\"\",IF(C382<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B82","v":"Tariff D - Murray Valley"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&'Prop2024-25DistTar'!C82","v":"Existing: Tariff D - Murray Valley"},{"$f":"INDEX('Prop2024-25DistTar'!$E$83:$E$85,C389)","v":1884.2336389482641},{"$f":"INDEX('Prop2024-25DistTar'!$E$83:$E$85,D389)","v":1162.6911533629686},{"$f":"INDEX('Prop2024-25DistTar'!$E$83:$E$85,E389)","v":198.02684827041554}]
[null,{"$f":"\"Proposed: \"&B388","v":"Proposed: Tariff D - Murray Valley"},{"$f":"INDEX('Prop2024-25DistTar'!$D$83:$D$85,C389)","v":1951.5442},{"$f":"INDEX('Prop2024-25DistTar'!$D$83:$D$85,D389)","v":1204.2260000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$83:$D$85,E389)","v":205.1009}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B391","v":"Existing: Tariff D - Murray Valley"},{"$f":"INDEX('Prop2024-25DistTar'!$F$83:$F$85,C$40)","v":68.353899999999996},{"$f":"INDEX('Prop2024-25DistTar'!$F$83:$F$85,D$40)","v":152.77950000000001},{"$f":"INDEX('Prop2024-25DistTar'!$F$83:$F$85,E$40)","v":94.941299999999998}]
[null,{"$f":"B392","v":"Proposed: Tariff D - Murray Valley"},{"$f":"INDEX('Prop2024-25DistTar'!$F$83:$F$85,C$40)","v":68.353899999999996},{"$f":"INDEX('Prop2024-25DistTar'!$F$83:$F$85,D$40)","v":152.77950000000001},{"$f":"INDEX('Prop2024-25DistTar'!$F$83:$F$85,E$40)","v":94.941299999999998}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B395","v":"Existing: Tariff D - Murray Valley"},{"$f":"INDEX('Prop2024-25DistTar'!$H$83:$H$85,C389)","v":128794.71773330575},{"$f":"INDEX('Prop2024-25DistTar'!$H$83:$H$85,D389)","v":177635.37306521769},{"$f":"INDEX('Prop2024-25DistTar'!$H$83:$H$85,E389)","v":18800.926409696003}]
[null,{"$f":"B396","v":"Proposed: Tariff D - Murray Valley"},{"$f":"INDEX('Prop2024-25DistTar'!$G$83:$G$85,C389)","v":133395.65709237999},{"$f":"INDEX('Prop2024-25DistTar'!$G$83:$G$85,D389)","v":183981.04616700002},{"$f":"INDEX('Prop2024-25DistTar'!$G$83:$G$85,E389)","v":19472.546077169998}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B399","v":"Existing: Tariff D - Murray Valley"},{"$f":"SUM(C399:E399)","v":325231.01720821945}]
[null,{"$f":"B400","v":"Proposed: Tariff D - Murray Valley"},{"$f":"SUM(C400:E400)","v":336849.24933655001}]
[]
[null,"Average price movement",{"$f":"IF(C404=0,\"\",C404/C403)","v":1.0357230138381677}]
[]
[null,{"$f":"IF(C406=\"\",\"\",IF(C406<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B87","v":"Tariff D - Bairnsdale"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&'Prop2024-25DistTar'!C87","v":"Existing: Tariff D - Bairnsdale"},{"$f":"INDEX('Prop2024-25DistTar'!$E$88:$E$90,C413)","v":2673.9204049145128},{"$f":"INDEX('Prop2024-25DistTar'!$E$88:$E$90,D413)","v":1656.5048470801805},{"$f":"INDEX('Prop2024-25DistTar'!$E$88:$E$90,E413)","v":302.10877233185397}]
[null,{"$f":"\"Proposed: \"&B412","v":"Proposed: Tariff D - Bairnsdale"},{"$f":"INDEX('Prop2024-25DistTar'!$D$88:$D$90,C413)","v":2769.4409000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$88:$D$90,D413)","v":1715.6802},{"$f":"INDEX('Prop2024-25DistTar'!$D$88:$D$90,E413)","v":312.90100000000001}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B415","v":"Existing: Tariff D - Bairnsdale"},{"$f":"INDEX('Prop2024-25DistTar'!$F$88:$F$90,C$40)","v":15.952299999999999},{"$f":"INDEX('Prop2024-25DistTar'!$F$88:$F$90,D$40)","v":4.2654999999999994},{"$f":"INDEX('Prop2024-25DistTar'!$F$88:$F$90,E$40)","v":0}]
[null,{"$f":"B416","v":"Proposed: Tariff D - Bairnsdale"},{"$f":"INDEX('Prop2024-25DistTar'!$F$88:$F$90,C$40)","v":15.952299999999999},{"$f":"INDEX('Prop2024-25DistTar'!$F$88:$F$90,D$40)","v":4.2654999999999994},{"$f":"INDEX('Prop2024-25DistTar'!$F$88:$F$90,E$40)","v":0}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B419","v":"Existing: Tariff D - Bairnsdale"},{"$f":"INDEX('Prop2024-25DistTar'!$H$88:$H$90,C413)","v":42655.180475317778},{"$f":"INDEX('Prop2024-25DistTar'!$H$88:$H$90,D413)","v":7065.8214252205089},{"$f":"INDEX('Prop2024-25DistTar'!$H$88:$H$90,E413)","v":0}]
[null,{"$f":"B420","v":"Proposed: Tariff D - Bairnsdale"},{"$f":"INDEX('Prop2024-25DistTar'!$G$88:$G$90,C413)","v":44178.952069070001},{"$f":"INDEX('Prop2024-25DistTar'!$G$88:$G$90,D413)","v":7318.2338930999995},{"$f":"INDEX('Prop2024-25DistTar'!$G$88:$G$90,E413)","v":0}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B423","v":"Existing: Tariff D - Bairnsdale"},{"$f":"SUM(C423:E423)","v":49721.001900538286}]
[null,{"$f":"B424","v":"Proposed: Tariff D - Bairnsdale"},{"$f":"SUM(C424:E424)","v":51497.185962169999}]
[]
[null,"Average price movement",{"$f":"IF(C428=0,\"\",C428/C427)","v":1.0357230142945386}]
[]
[null,{"$f":"IF(C430=\"\",\"\",IF(C430<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B93","v":"Tariff D - Albury"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&'Prop2024-25DistTar'!C93","v":"Existing: Tariff D - Albury"},{"$f":"INDEX('Prop2024-25DistTar'!$E$94:$E$96,C437)","v":1390.1971755092725},{"$f":"INDEX('Prop2024-25DistTar'!$E$94:$E$96,D437)","v":863.44011012256487},{"$f":"INDEX('Prop2024-25DistTar'!$E$94:$E$96,E437)","v":208.71238640777656}]
[null,{"$f":"\"Proposed: \"&B436","v":"Proposed: Tariff D - Albury"},{"$f":"INDEX('Prop2024-25DistTar'!$D$94:$D$96,C437)","v":1439.8592000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$94:$D$96,D437)","v":894.28480000000002},{"$f":"INDEX('Prop2024-25DistTar'!$D$94:$D$96,E437)","v":216.16820000000001}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B439","v":"Existing: Tariff D - Albury"},{"$f":"INDEX('Prop2024-25DistTar'!$F$94:$F$96,C$40)","v":43.471299999999999},{"$f":"INDEX('Prop2024-25DistTar'!$F$94:$F$96,D$40)","v":72.546599999999998},{"$f":"INDEX('Prop2024-25DistTar'!$F$94:$F$96,E$40)","v":4.440100000000001}]
[null,{"$f":"B440","v":"Proposed: Tariff D - Albury"},{"$f":"INDEX('Prop2024-25DistTar'!$F$94:$F$96,C$40)","v":43.471299999999999},{"$f":"INDEX('Prop2024-25DistTar'!$F$94:$F$96,D$40)","v":72.546599999999998},{"$f":"INDEX('Prop2024-25DistTar'!$F$94:$F$96,E$40)","v":4.440100000000001}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B443","v":"Existing: Tariff D - Albury"},{"$f":"INDEX('Prop2024-25DistTar'!$H$94:$H$96,C437)","v":60433.678475716239},{"$f":"INDEX('Prop2024-25DistTar'!$H$94:$H$96,D437)","v":62639.644293017664},{"$f":"INDEX('Prop2024-25DistTar'!$H$94:$H$96,E437)","v":926.70386688916892}]
[null,{"$f":"B444","v":"Proposed: Tariff D - Albury"},{"$f":"INDEX('Prop2024-25DistTar'!$G$94:$G$96,C437)","v":62592.551240960005},{"$f":"INDEX('Prop2024-25DistTar'!$G$94:$G$96,D437)","v":64877.321671680002},{"$f":"INDEX('Prop2024-25DistTar'!$G$94:$G$96,E437)","v":959.80842482000025}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B447","v":"Existing: Tariff D - Albury"},{"$f":"SUM(C447:E447)","v":124000.02663562306}]
[null,{"$f":"B448","v":"Proposed: Tariff D - Albury"},{"$f":"SUM(C448:E448)","v":128429.68133746002}]
[]
[null,"Average price movement",{"$f":"IF(C452=0,\"\",C452/C451)","v":1.0357230141155824}]
[]
[null,{"$f":"IF(C454=\"\",\"\",IF(C454<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]

{"sheet":"ARS","index":5,"n_rows":13,"n_cols":3,"rows_kept":13,"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":"2023-24"},{"$f":"'Model update'!$B$5","v":"2024-25"}]
["Disconnection",81,{"$f":"ROUND(B6*(1+'Model update'!$B$31),0)","v":84}]
["Reconnection",94,{"$f":"ROUND(B7*(1+'Model update'!$B$31),0)","v":98}]
["Special Meter Read - Metropolitan",10.3,{"$f":"ROUND(B8*(1+'Model update'!$B$31),1)","v":10.7}]
["Special Meter Read - Non Metropolitan",14.2,{"$f":"ROUND(B9*(1+'Model update'!$B$31),1)","v":14.8}]
["Meter Removal",115,{"$f":"ROUND(B10*(1+'Model update'!$B$31),0)","v":120}]
["Meter Reinstallation",115,{"$f":"ROUND(B11*(1+'Model update'!$B$31),0)","v":120}]
["Meter and Gas Installation Test",243,{"$f":"ROUND(B12*(1+'Model update'!$B$31),0)","v":253}]
["Service Abolishment - residential",220,{"$f":"ROUND(B13*(1+'Model update'!$B$31),0)","v":229}]