{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["NOTES","NOTES1","Model update","Prop2024-25DistTar","2024-25TarContForm","2024-25RebalContForm","ARS"],"not_rendered":{"charts":0,"images":11,"macros":0,"external_links":0,"defined_names":19,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"NOTES","index":0,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[]
["The model has actual and test data to illustrate the workings of the model.",null,null,2020]
[]
["Issue","Location","Item","Comment"]
[]
[1,"'Model update'!C25","CPI",{"$f":"\"Updated June \"&D2-1&\" CPI for \"&D2","v":"Updated June 2019 CPI for 2020"},"NOTE: This worksheet is programmed to update for each year - use as checklist and note any placeholders or changes"]
[null,null,null,null,"NOTE: Worksheet names in this file are programmed to update each year once each worksheet is accessed and a cell is selected"]
[{"$f":"A6+1","v":2},"'Model update'!B34",{"$f":"\"Xt for \"&D2","v":"Xt for 2020"},{"$f":"\"Value will require updating for \"&D2&\" cost of debt \"","v":"Value will require updating for 2020 cost of debt "}]
[]
[{"$f":"A8+1","v":3},"'Model update'!B44",{"$f":"\"Pass Through Amount for \"&D2","v":"Pass Through Amount for 2020"},"NIL for 2020"]
[]
[{"$f":"A10+1","v":4},"'Model update'!H79:H83","Real Pre-tax WACC (rptw)",{"$f":"\"Updated \"&$D$2&\" value for Jemena, placeholders for others\"","v":"Updated 2020 value for Jemena, placeholders for others"}]
[]
[{"$f":"A12+1","v":5},{"$f":"\"Prop\"&D2&\"DistTar!E8:E96\"","v":"Prop2020DistTar!E8:E96"},{"$f":"D2-1&\" tariffs\"","v":"2019 tariffs"},{"$f":"\"Updated from \"&D2-1&\" model\"","v":"Updated from 2019 model"}]
[]
[{"$f":"A14+1","v":6},"ARS!B6:B12",{"$f":"D2-1&\" ARS tariffs\"","v":"2019 ARS tariffs"},{"$f":"\"Updated from \"&D2-1&\" model\"","v":"Updated from 2019 model"}]
[]
[{"$f":"A16+1","v":7},"The following is test data to illustrate the workings of the model.",null,"Input data required from DNSPs"]
[null,{"$f":"\"Prop\"&D2&\"DistTar!D8:D96\"","v":"Prop2020DistTar!D8:D96"},{"$f":"\"Proposed \"&D2&\" Tariffs\"","v":"Proposed 2020 Tariffs"}]
[null,{"$f":"\"Prop\"&D2&\"DistTar!F8:F96\"","v":"Prop2020DistTar!F8:F96"},{"$f":"\"Actual \"&D2-2&\" Volumes\"","v":"Actual 2018 Volumes"}]
[]
[null,"ARS!C6:C12",{"$f":"\"Proposed \"&D2&\" Ancillary Reference Services Charges\"","v":"Proposed 2020 Ancillary Reference Services Charges"}]

{"sheet":"NOTES1","index":1,"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,"2024-25","2023-24","2022"]
[]
[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"}]
[]
[]
["Multinet:",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"},{"$f":"\"Updated \"&G2&\" actual cf(t) value, used for the cf(t-2) value for \"&E2","v":"Updated 2022 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"},{"$f":"\"Updated \"&G2&\" actual af(t) value, used for the af(t-2) value for \"&E2","v":"Updated 2022 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 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":2,"n_rows":56,"n_cols":8,"rows_kept":56,"cut":false,"hidden":false,"merged":[[41,0,42,1]]}
[]
[]
["Tariff Approval Template for ","Multinet"]
[]
["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,"2022-23",null,0,0]
[{"$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"}]
[{"$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,"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",{"$f":"C26-1.68847637347782%","v":-1.6884763734778201E-2}]
["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":-1.6884763734778201E-2}]
[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":3666696.0658376263},2711454.0449999999]
["2023-24",2.8296956631911341E-2,null,{"$f":"A45","v":"2024-25"},{"$f":"E53*(1+H52)*(1+H52)","v":4845504.8468996063},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.6028909646301276E-3}]
[{"$f":"A35","v":"2024-25"},2.8977192628213855E-2,null,"2025-26",{"$f":"E54*(1+H52)*(1+H52)*(1+H52)","v":6090014.7884631315},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":-2.8094527788470314E-2}]
[{"$f":"A36","v":"2025-26"},null,null,"2026-27",{"$f":"E55*(1+H52)*(1+H52)*(1+H52)*(1+H52)","v":9478211.6837001704},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":-2.2079882704577555E-2}]
["2026-27",null,null,"2027-28",{"$f":"E56*(1+H52)*(1+H52)*(1+H52)*(1+H52)*(1+H52)","v":13037877.678094616},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":-3.4364087690182663E-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.6028909646301788E-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.8296956631911341E-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.8977192628213855E-2},null,null,"Fcst af(t) $22-23",null,null,"Forecast inflation"]
[null,null,null,null,3562690.2757975999,null,null,2.9193048507912201E-2]
[null,null,null,null,4574518.0330486298]
[null,null,null,null,5586345.7902996698]
[null,null,null,null,8447710.5934368502]
[null,null,null,null,11290747.1367197]

{"sheet":"Prop2024-25DistTar","index":3,"n_rows":67,"n_cols":8,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[null,"Tariff Approval - Multinet","Prop2024-25DistTar"]
[]
[null,"PROPOSED 2024-25 DISTRIBUTION TARIFFS"]
[]
[null,"Proposed tariff name","Existing name","Prop\n2024-25 Tariff","Exist\n2023-24 Tariff","Actual 2022-23 Volumes","Prop Tar\nRevenue","Exist Tar\nRevenue"]
[null,"Tariff V Residential - Multinet Metro","Tariff V Residential - Multinet Metro"]
[null,"1 July - 30 June","1 July - 30 June"]
[null,"Fixed Charge","Fixed Charge",0.1973,0.1973,692544,{"$f":"D8*$F8*365","v":49873209.887999997},{"$f":"E8*$F8*365","v":49873209.887999997}]
[null,"0 - 0.05GJ","0 - 0.05GJ",10.484999999999999,9.5922999999999998,9976671.1877689995,{"$f":"D9*$F9","v":104605397.40375796},95699223.034436569]
[null,"0.05 - 0.1GJ","0.05 - 0.1GJ",6.9756,6.4104000000000001,6219346.4981583003,43383673.432553038,39868498.791793972]
[null,"0.1 -0.15GJ","0.1 -0.15GJ",3.1078999999999999,3.1078999999999999,4439680.7561943997,13798083.822176574,13798083.822176574]
[null,"0.15 - 0.25GJ","0.15 - 0.25GJ",1.5904,1.5904,6114964.1247798,9725238.9440497942,9725238.9440497942]
[null," >0.25GJ"," >0.25GJ",1.1939,1.1933,9844173.5258403011,11752958.772500735,11747052.268385231]
[null,"Tariff V Residential - Multinet Yarra Valley Towns","Tariff V Residential - Multinet Yarra Valley Towns"]
[null,"1 July - 30 June","1 July - 30 June"]
[null,"Fixed Charge","Fixed Charge",0.1973,0.1973,16143,{"$f":"D16*$F16*365","v":1162530.0734999999},{"$f":"E16*$F16*365","v":1162530.0734999999}]
[null,"0 - 0.05GJ","0 - 0.05GJ",12.787000000000001,11.750999999999999,801632.11705109989,{"$f":"D17*$F17","v":10250469.880732415},{"$f":"E17*$F17","v":9419979.0074674748}]
[null,"0.05 - 0.1GJ","0.05 - 0.1GJ",9.6423000000000005,8.8613,1254730.0973658999,{"$f":"D18*$F18","v":12098484.017831217},11118539.811788449]
[null,"0.1 -0.15GJ","0.1 -0.15GJ",5.9367000000000001,5.9367000000000001,486011.51595689997,{"$f":"D19*$F19","v":2885304.5667813281},2885304.5667813281]
[null,"0.15 - 0.25GJ","0.15 - 0.25GJ",4.7291999999999996,4.7291999999999996,1622066.9622961001,{"$f":"D20*$F20","v":7671079.0780907162},7671079.0780907162]
[null," >0.25GJ"," >0.25GJ",4.4248000000000003,4.4244000000000003,1724381.9966786001,{"$f":"D21*$F21","v":7630045.4589034701},7629355.7061047992]
[null,"Tariff V Residential - Multinet Gippsland Towns","Tariff V Residential - Multinet Gippsland Towns"]
[null,"1 July - 30 June","1 July - 30 June"]
[null,"Fixed Charge","Fixed Charge",0.1973,0.1973,5798,{"$f":"D24*$F24*365","v":417540.071},{"$f":"E24*$F24*365","v":417540.071}]
[null,"0 - 0.05GJ","0 - 0.05GJ",13.9635,12.832100000000001,81874.416456999999,{"$f":"D25*$F25","v":1143253.4141973194},{"$f":"E25*$F25","v":1050620.6994178698}]
[null,"0.05 - 0.1GJ","0.05 - 0.1GJ",10.6134,9.7537000000000003,52783.097844199998,{"$f":"D26*$F26","v":560208.13065963227},514830.50144297356]
[null,"0.1 -0.15GJ","0.1 -0.15GJ",6.5997000000000003,6.5997000000000003,38085.5800858,{"$f":"D27*$F27","v":251353.40289225426},251353.40289225426]
[null,"0.15 - 0.25GJ","0.15 - 0.25GJ",5.3037000000000001,5.3037000000000001,50283.5100255,{"$f":"D28*$F28","v":266688.65212224436},266688.65212224436]
[null," >0.25GJ"," >0.25GJ",4.9678000000000004,4.9678000000000004,64638.117907399996,{"$f":"D29*$F29","v":321109.24214038171},321109.24214038171]
[null,"Tariff V Non-Residential - Multinet Metro","Tariff V Non-Residential - Multinet Metro"]
[null,"1 July - 30 June","1 July - 30 June"]
[null,"Fixed Charge","Fixed Charge",0.32540000000000002,0.32540000000000002,81,{"$f":"D32*$F32*365","v":9620.4510000000009},{"$f":"E32*$F32*365","v":9620.4510000000009}]
[null,"0 - 0.25GJ","0 - 0.25GJ",4.6844999999999999,4.3049999999999997,4845.8111883000001,{"$f":"D33*$F33","v":22700.202511591349},{"$f":"E33*$F33","v":20861.2171656315}]
[null,"0.25 - 1GJ","0.25 - 1GJ",2.7570999999999999,2.5337999999999998,6779.8160472,{"$f":"D34*$F34","v":18692.630823735119},17178.69790039536]
[null,"1 - 1.5GJ","1 - 1.5GJ",1.4158999999999999,1.4158999999999999,2157.5744474000003,{"$f":"D35*$F35","v":3054.9096600736602},3054.9096600736602]
[null,"1.5 - 5GJ","1.5 - 5GJ",0.82240000000000002,0.82240000000000002,8436.3274187000006,{"$f":"D36*$F36","v":6938.0356691388806},6938.0356691388806]
[null,">5GJ",">5GJ",0.25829999999999997,0.25829999999999997,9924.5671207999985,{"$f":"D37*$F37","v":2563.5156873026394},2563.5156873026394]
[null,"Tariff V Non-Residential - Multinet Yarra Valley Towns","Tariff V Non-Residential - Multinet Yarra Valley Towns"]
[null,"1 July - 30 June","1 July - 30 June"]
[null,"Fixed Charge","Fixed Charge",0.32390000000000002,0.32390000000000002,7066,{"$f":"D40*$F40*365","v":835367.25100000005},{"$f":"E40*$F40*365","v":835367.25100000005}]
[null,"0 - 0.25GJ","0 - 0.25GJ",8.2713000000000001,7.6014999999999997,77924.371808399999,{"$f":"D41*$F41","v":644535.85653881892},{"$f":"E41*$F41","v":592342.11230155255}]
[null,"0.25 - 1GJ","0.25 - 1GJ",6.327,5.8148,39997.194911899998,{"$f":"D42*$F42","v":253062.25220759129},232575.68897371611]
[null,"1 - 1.5GJ","1 - 1.5GJ",4.6292,4.6292,26542.983169899999,{"$f":"D43*$F43","v":122872.77769010108},122872.77769010108]
[null,"1.5 - 5GJ","1.5 - 5GJ",4.1310000000000002,4.1310000000000002,30260.106535600004,{"$f":"D44*$F44","v":125004.50009856361},125004.50009856361]
[null,">5GJ",">5GJ",3.6776,3.6738,24597.972790100001,{"$f":"D45*$F45","v":90461.504732871763},90368.032436269379]
[null,"Tariff V Non-Residential - Multinet Gippsland Towns","Tariff V Non-Residential - Multinet Gippsland Towns"]
[null,"1 July - 30 June","1 July - 30 June"]
[null,"Fixed Charge","Fixed Charge",0.32540000000000002,0.32540000000000002,125,{"$f":"D48*$F48*365","v":14846.375000000002},{"$f":"E48*$F48*365","v":14846.375000000002}]
[null,"0 - 0.25GJ","0 - 0.25GJ",9.1395,8.3989999999999991,7533.2883512000008,{"$f":"D49*$F49","v":68850.488885792409},{"$f":"E49*$F49","v":63272.0888617288}]
[null,"0.25 - 1GJ","0.25 - 1GJ",7.0369000000000002,6.4669999999999996,14642.909544599999,{"$f":"D50*$F50","v":103040.69017439574},94695.696024928184]
[null,"1 - 1.5GJ","1 - 1.5GJ",5.1710000000000003,5.1710000000000003,6367.3688199999997,{"$f":"D51*$F51","v":32925.664168219999},32925.664168219999]
[null,"1.5 - 5GJ","1.5 - 5GJ",4.6614000000000004,4.6614000000000004,24547.810696600001,{"$f":"D52*$F52","v":114427.16478113126},114427.16478113126]
[null,">5GJ",">5GJ",4.1752000000000002,4.173,33319.561793000001,{"$f":"D53*$F53","v":139115.83439813362},139042.53136218901]
[null,"Tariff D - Multinet","Tariff D - Multinet"]
[null,"0 - 50GJ","0 - 50GJ",698.21119999999996,671.02139999999997,3180.1400000000017,{"$f":"D55*$F55","v":2220409.3655680013},{"$f":"E55*$F55","v":2133941.994996001}]
[null,"> 50GJ","> 50GJ",118.8039,114.17749999999999,821.37000000000012,{"$f":"D56*$F56","v":97581.95934300001},{"$f":"E56*$F56","v":93781.973175000006}]
[null,"Tariff D - Multinet South Gippsland","Tariff D - Multinet South Gippsland"]
[null,"0 - 50GJ","0 - 50GJ",754.41390000000001,725.03549999999996,100,{"$f":"D58*$F58","v":75441.39},{"$f":"E58*$F58","v":72503.549999999988}]
[null,"> 50GJ","> 50GJ",128.3494,123.35129999999999,56.129999999999995,{"$f":"D59*$F59","v":7204.2518219999993},{"$f":"E59*$F59","v":6923.7084689999992}]
[null,"Tariff  L- Multinet Metro","Tariff  L- Multinet Non-Residential"]
[null,"1 July - 30 June","1 July - 30 June",null,null,null,{"$f":"D61*$F61*365","v":0},{"$f":"E61*$F61*365","v":0}]
[null,"< 5GJ","< 5GJ",0.60260000000000002,0.57909999999999995,20269.170000000002,{"$f":"D62*$F62","v":12214.201842000002},{"$f":"E62*$F62","v":11737.876346999999}]
[null,"> 5GJ","> 5GJ",0.14699999999999999,0.14130000000000001,56434.920000000013,{"$f":"D63*$F63","v":8295.9332400000021},7974.2541960000026]
[null,"Rolling 12 month max [$/GJ (MHQ/d)]","Rolling 12 month max [$/GJ (MHQ/d)]",0.66969999999999996,0.64370000000000005,45.105833333333337,{"$f":"D64*$F64*365","v":11025.692452916668},{"$f":"E64*$F64*365","v":10597.638094583335}]
[null,"Peak Demand [$/GJ (MHQ/d)]","Peak Demand [$/GJ (MHQ/d)]",2.0034999999999998,1.9255,39.56,{"$f":"D65*$F65*122","v":9669.5321199999998},{"$f":"E65*$F65*122","v":9293.0791600000011}]
[]
[null,"Total Revenue","Total Revenue",null,null,null,{"$f":"SUM(G8:G65)","v":282846550.68330449},{"$f":"SUM(H8:H65)","v":268284948.34580919}]

{"sheet":"2024-25TarContForm","index":4,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,1,25,3]]}
[null,"Tariff Approval - Multinet",null,null,null,"2024-25TarContForm"]
[]
[null,"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":-1.6884763734778201E-2}]
[null,"Pass-through Amount",{"$f":"'Model update'!H23","v":0},null,null,null,{"$f":"(1+C9)*(1-C10)*C23","v":283869301.72854638}]
[null,"Safeguard Mechanism Amount",{"$f":"'Model update'!H36","v":0},null,null,null,{"$f":"(1+C9)*(1-C10)*(1+C11)*C23","v":283869301.72854638}]
[null,"Abolishment True-up Amount",{"$f":"'Model update'!H49","v":-3.6028909646301788E-3},null,null,null,{"$f":"(1+C9)*(1-C10)*(1+C11)*(1+C12)*C23","v":283869301.72854638}]
[]
[]
[]
[]
[null,"2024-25  Distribution price control"]
[]
[null,"Average price movement allowed",{"$f":"(1+C9)*(1-C10)*(1+C11)*(1+C12)*(1+C13)","v":1.0542766313585143}]
[]
[null,"Proposed distribution tariff revenue",{"$f":"IF('Prop2024-25DistTar'!G67=0,\"\",'Prop2024-25DistTar'!G67)","v":282846550.68330449}]
[null,"Existing distribution tariff revenue",{"$f":"IF('Prop2024-25DistTar'!H67=0,\"\",'Prop2024-25DistTar'!H67)","v":268284948.34580919}]
[null,"Average price movement",{"$f":"IF(C22=\"\",\"\",C22/C23)","v":1.054276627993032}]
[]
[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":5,"n_rows":287,"n_cols":8,"rows_kept":287,"cut":false,"hidden":false,"merged":[[257,1,257,2],[286,1,286,2],[59,1,59,2],[89,1,89,2],[119,1,119,2],[149,1,149,2],[179,1,179,2],[209,1,209,2],[233,1,233,2]]}
[null,"Tariff Approval - Multinet",{"$f":"'Model update'!B5&\"RebalContForm\"","v":"2024-25RebalContForm"}]
[]
[null,"2024-25  REBALANCING CONTROL FORMULA"]
[]
[]
[null,"Rebalancing control"]
[]
[null,"CPI",{"$f":"'2024-25TarContForm'!C9","v":4.0519877675840865E-2}]
[null,"X-factor",{"$f":"'2024-25TarContForm'!C10","v":-1.6884763734778201E-2}]
[null,"Pass-through Amount",{"$f":"'2024-25TarContForm'!C11","v":0}]
[null,"Safeguard Mechanism Amount",{"$f":"'2024-25TarContForm'!C12","v":0}]
[null,"Abolishment True-up Amount",{"$f":"'2024-25TarContForm'!C13","v":-3.6028909646301788E-3}]
[null,"Y factor",0.02]
[]
[null,"Rebalancing control",{"$f":"(1+C8)*(1-C9)*(1+C10)*(1+C11)*(1+C13)","v":1.0792505861711725},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":"B34","v":"Tariff V Residential - Multinet Metro"},{"$f":"C55","v":220711306.74884215},{"$f":"C56","v":233138562.2630381},{"$f":"IF(C21=0,0,D21/C21)","v":1.0563054774911804},{"$f":"IF(E21=0,\"\",IF($C$15<=E21,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B64","v":"Tariff V Residential - Multinet Yarra Valley Towns"},{"$f":"C85","v":39886788.243732765},{"$f":"C86","v":41697913.07583914},1.0454066349248099,{"$f":"IF(E22=0,\"\",IF($C$15<=E22,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B94","v":"Tariff V Residential - Multinet Gippsland Towns"},{"$f":"C115","v":2822142.5690157232},{"$f":"C116","v":2960152.9130118317},1.0489026831993971,"Compliant"]
[null,{"$f":"B124","v":"Tariff V Non-Residential - Multinet Metro"},{"$f":"C145","v":60216.827082542048},{"$f":"C146","v":63569.745351841651},1.0556807529015702,"Compliant"]
[null,{"$f":"B154","v":"Tariff V Non-Residential - Multinet Yarra Valley Towns"},{"$f":"C175","v":1998530.3625002028},{"$f":"C176","v":2071304.1422679464},1.0364136473146708,"Compliant"]
[null,{"$f":"B184","v":"Tariff V Non-Residential - Multinet Gippsland Towns"},{"$f":"C205","v":459209.52019819722},{"$f":"C206","v":473206.21740767302},1.0304799804747835,"Compliant"]
[null,{"$f":"B214","v":"Tariff D - Multinet"},{"$f":"C229","v":2227723.9681710009},{"$f":"C230","v":2317991.3249110011},1.0405199917178749,"Compliant"]
[null,{"$f":"B238","v":"Tariff D - Multinet South Gippsland"},{"$f":"C253","v":79427.258468999993},{"$f":"C254","v":82645.641822000005},1.0405198846722896,"Compliant"]
[null,"Tariff L - Multinet",{"$f":"C282","v":39602.847797583338},{"$f":"C283","v":41205.359654916669},1.0404645611730761,"Compliant"]
[null,null,{"$f":"SUM(C21:C29)","v":268284948.34580913},{"$f":"SUM(D21:D29)","v":282846550.68330443},1.054276627993032]
[]
[]
[]
[null,"Tariff V Residential - Multinet Metro",1,2,3,4,5,6]
[null,null,1,2,3,4,5,6]
[null,"Distribution tariff","Fixed","Blk1","Blk2","Blk3","Blk4","Blk5"]
[]
[null,"Existing (1 Jan-31 Dec): Tariff V Residential - Multinet Metro",{"$f":"INDEX('Prop2024-25DistTar'!$E$8:$E$13,C$35)","v":0.1973},{"$f":"INDEX('Prop2024-25DistTar'!$E$8:$E$13,D$35)","v":9.5922999999999998},{"$f":"INDEX('Prop2024-25DistTar'!$E$8:$E$13,E$35)","v":6.4104000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$E$8:$E$13,F$35)","v":3.1078999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$E$8:$E$13,G$35)","v":1.5904},{"$f":"INDEX('Prop2024-25DistTar'!$E$8:$E$13,H$35)","v":1.1933}]
[]
[null,{"$f":"\"Proposed (1 Jan-31 Dec): \"&B34","v":"Proposed (1 Jan-31 Dec): Tariff V Residential - Multinet Metro"},{"$f":"INDEX('Prop2024-25DistTar'!$D$8:$D$13,C$34)","v":0.1973},{"$f":"INDEX('Prop2024-25DistTar'!$D$8:$D$13,D$34)","v":10.484999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$D$8:$D$13,E$34)","v":6.9756},{"$f":"INDEX('Prop2024-25DistTar'!$D$8:$D$13,F$34)","v":3.1078999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$D$8:$D$13,G$34)","v":1.5904},{"$f":"INDEX('Prop2024-25DistTar'!$D$8:$D$13,H$34)","v":1.1939}]
[]
[null,"Distribution volumes (actual)","Fixed","Blk1","Blk2","Blk3","Blk4","Blk5"]
[]
[null,{"$f":"B38","v":"Existing (1 Jan-31 Dec): Tariff V Residential - Multinet Metro"},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$13,C$34)","v":692544},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$13,D$34)","v":9976671.1877689995},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$13,E$34)","v":6219346.4981583003},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$13,F$34)","v":4439680.7561943997},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$13,G$34)","v":6114964.1247798},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$13,H$34)","v":9844173.5258403011}]
[]
[null,{"$f":"B40","v":"Proposed (1 Jan-31 Dec): Tariff V Residential - Multinet Metro"},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$13,C$34)","v":692544},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$13,D$34)","v":9976671.1877689995},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$13,E$34)","v":6219346.4981583003},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$13,F$34)","v":4439680.7561943997},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$13,G$34)","v":6114964.1247798},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$13,H$34)","v":9844173.5258403011}]
[]
[null,"Distribution revenue","Fixed","Blk1","Blk2","Blk3","Blk4","Blk5"]
[]
[null,{"$f":"B44","v":"Existing (1 Jan-31 Dec): Tariff V Residential - Multinet Metro"},{"$f":"INDEX('Prop2024-25DistTar'!$H$8:$H$13,C$35)","v":49873209.887999997},{"$f":"INDEX('Prop2024-25DistTar'!$H$8:$H$13,D$35)","v":95699223.034436569},{"$f":"INDEX('Prop2024-25DistTar'!$H$8:$H$13,E$35)","v":39868498.791793972},{"$f":"INDEX('Prop2024-25DistTar'!$H$8:$H$13,F$35)","v":13798083.822176574},{"$f":"INDEX('Prop2024-25DistTar'!$H$8:$H$13,G$35)","v":9725238.9440497942},{"$f":"INDEX('Prop2024-25DistTar'!$H$8:$H$13,H$35)","v":11747052.268385231}]
[]
[null,{"$f":"B46","v":"Proposed (1 Jan-31 Dec): Tariff V Residential - Multinet Metro"},{"$f":"INDEX('Prop2024-25DistTar'!$G$8:$G$13,C$34)","v":49873209.887999997},{"$f":"INDEX('Prop2024-25DistTar'!$G$8:$G$13,D$34)","v":104605397.40375796},{"$f":"INDEX('Prop2024-25DistTar'!$G$8:$G$13,E$34)","v":43383673.432553038},{"$f":"INDEX('Prop2024-25DistTar'!$G$8:$G$13,F$34)","v":13798083.822176574},{"$f":"INDEX('Prop2024-25DistTar'!$G$8:$G$13,G$34)","v":9725238.9440497942},{"$f":"INDEX('Prop2024-25DistTar'!$G$8:$G$13,H$34)","v":11752958.772500735}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B50","v":"Existing (1 Jan-31 Dec): Tariff V Residential - Multinet Metro"},{"$f":"SUM(C50:H50)","v":220711306.74884215}]
[null,{"$f":"B52","v":"Proposed (1 Jan-31 Dec): Tariff V Residential - Multinet Metro"},{"$f":"SUM(C52:H52)","v":233138562.2630381}]
[]
[null,"Average price movement",{"$f":"IF(C56=0,\"\",C56/C55)","v":1.0563054774911804}]
[]
[null,{"$f":"IF(C58=\"\",\"\",IF(C58<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,"Tariff V Residential - Multinet Yarra Valley Towns",1,2,3,4,5,6]
[null,null,1,2,3,4,5,6]
[null,"Distribution tariff","Fixed","Blk1","Blk2","Blk3","Blk4","Blk5"]
[]
[null,"Existing (1 Jan-31 Dec): Tariff V Residential - Multinet Yarra Valley Towns",{"$f":"INDEX('Prop2024-25DistTar'!$E$16:$E$21,C$35)","v":0.1973},{"$f":"INDEX('Prop2024-25DistTar'!$E$16:$E$21,D$35)","v":11.750999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$E$16:$E$21,E$35)","v":8.8613},{"$f":"INDEX('Prop2024-25DistTar'!$E$16:$E$21,F$35)","v":5.9367000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$E$16:$E$21,G$35)","v":4.7291999999999996},{"$f":"INDEX('Prop2024-25DistTar'!$E$16:$E$21,H$35)","v":4.4244000000000003}]
[]
[null,{"$f":"\"Proposed (1 Jan-31 Dec): \"&B64","v":"Proposed (1 Jan-31 Dec): Tariff V Residential - Multinet Yarra Valley Towns"},{"$f":"INDEX('Prop2024-25DistTar'!$D$16:$D$21,C$34)","v":0.1973},{"$f":"INDEX('Prop2024-25DistTar'!$D$16:$D$21,D$34)","v":12.787000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$16:$D$21,E$34)","v":9.6423000000000005},{"$f":"INDEX('Prop2024-25DistTar'!$D$16:$D$21,F$34)","v":5.9367000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$16:$D$21,G$34)","v":4.7291999999999996},{"$f":"INDEX('Prop2024-25DistTar'!$D$16:$D$21,H$34)","v":4.4248000000000003}]
[]
[null,"Distribution volumes (actual)","Fixed","Blk1","Blk2","Blk3","Blk4","Blk5"]
[]
[null,{"$f":"B68","v":"Existing (1 Jan-31 Dec): Tariff V Residential - Multinet Yarra Valley Towns"},{"$f":"INDEX('Prop2024-25DistTar'!$F$16:$F$21,C$34)","v":16143},{"$f":"INDEX('Prop2024-25DistTar'!$F$16:$F$21,D$34)","v":801632.11705109989},{"$f":"INDEX('Prop2024-25DistTar'!$F$16:$F$21,E$34)","v":1254730.0973658999},{"$f":"INDEX('Prop2024-25DistTar'!$F$16:$F$21,F$34)","v":486011.51595689997},{"$f":"INDEX('Prop2024-25DistTar'!$F$16:$F$21,G$34)","v":1622066.9622961001},{"$f":"INDEX('Prop2024-25DistTar'!$F$16:$F$21,H$34)","v":1724381.9966786001}]
[]
[null,{"$f":"B70","v":"Proposed (1 Jan-31 Dec): Tariff V Residential - Multinet Yarra Valley Towns"},{"$f":"INDEX('Prop2024-25DistTar'!$F$16:$F$21,C$34)","v":16143},{"$f":"INDEX('Prop2024-25DistTar'!$F$16:$F$21,D$34)","v":801632.11705109989},{"$f":"INDEX('Prop2024-25DistTar'!$F$16:$F$21,E$34)","v":1254730.0973658999},{"$f":"INDEX('Prop2024-25DistTar'!$F$16:$F$21,F$34)","v":486011.51595689997},{"$f":"INDEX('Prop2024-25DistTar'!$F$16:$F$21,G$34)","v":1622066.9622961001},{"$f":"INDEX('Prop2024-25DistTar'!$F$16:$F$21,H$34)","v":1724381.9966786001}]
[]
[null,"Distribution revenue","Fixed","Blk1","Blk2","Blk3","Blk4","Blk5"]
[]
[null,{"$f":"B74","v":"Existing (1 Jan-31 Dec): Tariff V Residential - Multinet Yarra Valley Towns"},{"$f":"INDEX('Prop2024-25DistTar'!$H$16:$H$21,C$35)","v":1162530.0734999999},{"$f":"INDEX('Prop2024-25DistTar'!$H$16:$H$21,D$35)","v":9419979.0074674748},{"$f":"INDEX('Prop2024-25DistTar'!$H$16:$H$21,E$35)","v":11118539.811788449},{"$f":"INDEX('Prop2024-25DistTar'!$H$16:$H$21,F$35)","v":2885304.5667813281},{"$f":"INDEX('Prop2024-25DistTar'!$H$16:$H$21,G$35)","v":7671079.0780907162},{"$f":"INDEX('Prop2024-25DistTar'!$H$16:$H$21,H$35)","v":7629355.7061047992}]
[]
[null,{"$f":"B76","v":"Proposed (1 Jan-31 Dec): Tariff V Residential - Multinet Yarra Valley Towns"},{"$f":"INDEX('Prop2024-25DistTar'!$G$16:$G$21,C$34)","v":1162530.0734999999},{"$f":"INDEX('Prop2024-25DistTar'!$G$16:$G$21,D$34)","v":10250469.880732415},{"$f":"INDEX('Prop2024-25DistTar'!$G$16:$G$21,E$34)","v":12098484.017831217},{"$f":"INDEX('Prop2024-25DistTar'!$G$16:$G$21,F$34)","v":2885304.5667813281},{"$f":"INDEX('Prop2024-25DistTar'!$G$16:$G$21,G$34)","v":7671079.0780907162},{"$f":"INDEX('Prop2024-25DistTar'!$G$16:$G$21,H$34)","v":7630045.4589034701}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B80","v":"Existing (1 Jan-31 Dec): Tariff V Residential - Multinet Yarra Valley Towns"},{"$f":"SUM(C80:H80)","v":39886788.243732765}]
[null,{"$f":"B82","v":"Proposed (1 Jan-31 Dec): Tariff V Residential - Multinet Yarra Valley Towns"},{"$f":"SUM(C82:H82)","v":41697913.07583914}]
[]
[null,"Average price movement",{"$f":"IF(C86=0,\"\",C86/C85)","v":1.0454066349248099}]
[]
[null,{"$f":"IF(C88=\"\",\"\",IF(C88<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,"Tariff V Residential - Multinet Gippsland Towns",1,2,3,4,5,6]
[null,null,1,2,3,4,5,6]
[null,"Distribution tariff","Fixed","Blk1","Blk2","Blk3","Blk4","Blk5"]
[]
[null,"Existing (1 Jan-31 Dec): Tariff V Residential - Multinet Gippsland Towns",{"$f":"INDEX('Prop2024-25DistTar'!$E$24:$E$29,C$35)","v":0.1973},{"$f":"INDEX('Prop2024-25DistTar'!$E$24:$E$29,D$35)","v":12.832100000000001},{"$f":"INDEX('Prop2024-25DistTar'!$E$24:$E$29,E$35)","v":9.7537000000000003},{"$f":"INDEX('Prop2024-25DistTar'!$E$24:$E$29,F$35)","v":6.5997000000000003},{"$f":"INDEX('Prop2024-25DistTar'!$E$24:$E$29,G$35)","v":5.3037000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$E$24:$E$29,H$35)","v":4.9678000000000004}]
[]
[null,{"$f":"\"Proposed (1 Jan-31 Dec): \"&B94","v":"Proposed (1 Jan-31 Dec): Tariff V Residential - Multinet Gippsland Towns"},{"$f":"INDEX('Prop2024-25DistTar'!$D$24:$D$29,C$34)","v":0.1973},{"$f":"INDEX('Prop2024-25DistTar'!$D$24:$D$29,D$34)","v":13.9635},{"$f":"INDEX('Prop2024-25DistTar'!$D$24:$D$29,E$34)","v":10.6134},{"$f":"INDEX('Prop2024-25DistTar'!$D$24:$D$29,F$34)","v":6.5997000000000003},{"$f":"INDEX('Prop2024-25DistTar'!$D$24:$D$29,G$34)","v":5.3037000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$24:$D$29,H$34)","v":4.9678000000000004}]
[]
[null,"Distribution volumes (actual)","Fixed","Blk1","Blk2","Blk3","Blk4","Blk5"]
[]
[null,{"$f":"B98","v":"Existing (1 Jan-31 Dec): Tariff V Residential - Multinet Gippsland Towns"},{"$f":"INDEX('Prop2024-25DistTar'!$F$24:$F$29,C$34)","v":5798},{"$f":"INDEX('Prop2024-25DistTar'!$F$24:$F$29,D$34)","v":81874.416456999999},{"$f":"INDEX('Prop2024-25DistTar'!$F$24:$F$29,E$34)","v":52783.097844199998},{"$f":"INDEX('Prop2024-25DistTar'!$F$24:$F$29,F$34)","v":38085.5800858},{"$f":"INDEX('Prop2024-25DistTar'!$F$24:$F$29,G$34)","v":50283.5100255},{"$f":"INDEX('Prop2024-25DistTar'!$F$24:$F$29,H$34)","v":64638.117907399996}]
[]
[null,{"$f":"B100","v":"Proposed (1 Jan-31 Dec): Tariff V Residential - Multinet Gippsland Towns"},{"$f":"INDEX('Prop2024-25DistTar'!$F$24:$F$29,C$34)","v":5798},{"$f":"INDEX('Prop2024-25DistTar'!$F$24:$F$29,D$34)","v":81874.416456999999},{"$f":"INDEX('Prop2024-25DistTar'!$F$24:$F$29,E$34)","v":52783.097844199998},{"$f":"INDEX('Prop2024-25DistTar'!$F$24:$F$29,F$34)","v":38085.5800858},{"$f":"INDEX('Prop2024-25DistTar'!$F$24:$F$29,G$34)","v":50283.5100255},{"$f":"INDEX('Prop2024-25DistTar'!$F$24:$F$29,H$34)","v":64638.117907399996}]
[]
[null,"Distribution revenue","Fixed","Blk1","Blk2","Blk3","Blk4","Blk5"]
[]
[null,{"$f":"B104","v":"Existing (1 Jan-31 Dec): Tariff V Residential - Multinet Gippsland Towns"},{"$f":"INDEX('Prop2024-25DistTar'!$H$24:$H$29,C$35)","v":417540.071},{"$f":"INDEX('Prop2024-25DistTar'!$H$24:$H$29,D$35)","v":1050620.6994178698},{"$f":"INDEX('Prop2024-25DistTar'!$H$24:$H$29,E$35)","v":514830.50144297356},{"$f":"INDEX('Prop2024-25DistTar'!$H$24:$H$29,F$35)","v":251353.40289225426},{"$f":"INDEX('Prop2024-25DistTar'!$H$24:$H$29,G$35)","v":266688.65212224436},{"$f":"INDEX('Prop2024-25DistTar'!$H$24:$H$29,H$35)","v":321109.24214038171}]
[]
[null,{"$f":"B106","v":"Proposed (1 Jan-31 Dec): Tariff V Residential - Multinet Gippsland Towns"},{"$f":"INDEX('Prop2024-25DistTar'!$G$24:$G$29,C$34)","v":417540.071},{"$f":"INDEX('Prop2024-25DistTar'!$G$24:$G$29,D$34)","v":1143253.4141973194},{"$f":"INDEX('Prop2024-25DistTar'!$G$24:$G$29,E$34)","v":560208.13065963227},{"$f":"INDEX('Prop2024-25DistTar'!$G$24:$G$29,F$34)","v":251353.40289225426},{"$f":"INDEX('Prop2024-25DistTar'!$G$24:$G$29,G$34)","v":266688.65212224436},{"$f":"INDEX('Prop2024-25DistTar'!$G$24:$G$29,H$34)","v":321109.24214038171}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B110","v":"Existing (1 Jan-31 Dec): Tariff V Residential - Multinet Gippsland Towns"},{"$f":"SUM(C110:H110)","v":2822142.5690157232}]
[null,{"$f":"B112","v":"Proposed (1 Jan-31 Dec): Tariff V Residential - Multinet Gippsland Towns"},{"$f":"SUM(C112:H112)","v":2960152.9130118317}]
[]
[null,"Average price movement",{"$f":"IF(C116=0,\"\",C116/C115)","v":1.0489026831993971}]
[]
[null,{"$f":"IF(C118=\"\",\"\",IF(C118<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,"Tariff V Non-Residential - Multinet Metro",1,2,3,4,5]
[null,null,1,2,3,4,5,6]
[null,"Distribution tariff","Fixed","Blk1","Blk2","Blk3","Blk4","Blk5"]
[]
[null,"Existing (1 Jan - 31 Dec): Tariff V Non-Residential - Multinet Metro",{"$f":"INDEX('Prop2024-25DistTar'!$E$32:$E$37,C$35)","v":0.32540000000000002},{"$f":"INDEX('Prop2024-25DistTar'!$E$32:$E$37,D$35)","v":4.3049999999999997},{"$f":"INDEX('Prop2024-25DistTar'!$E$32:$E$37,E$35)","v":2.5337999999999998},{"$f":"INDEX('Prop2024-25DistTar'!$E$32:$E$37,F$35)","v":1.4158999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$E$32:$E$37,G$35)","v":0.82240000000000002},{"$f":"INDEX('Prop2024-25DistTar'!$E$32:$E$37,H$35)","v":0.25829999999999997}]
[]
[null,{"$f":"\"Proposed (1 Jan-31 Dec): \"&B124","v":"Proposed (1 Jan-31 Dec): Tariff V Non-Residential - Multinet Metro"},{"$f":"INDEX('Prop2024-25DistTar'!$D$32:$D$37,C$34)","v":0.32540000000000002},{"$f":"INDEX('Prop2024-25DistTar'!$D$32:$D$37,D$34)","v":4.6844999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$D$32:$D$37,E$34)","v":2.7570999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$D$32:$D$37,F$34)","v":1.4158999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$D$32:$D$37,G$34)","v":0.82240000000000002},{"$f":"INDEX('Prop2024-25DistTar'!$D$32:$D$37,H$34)","v":0.25829999999999997}]
[]
[null,"Distribution volumes (actual)","Fixed","Blk1","Blk2","Blk3","Blk4","Blk5"]
[]
[null,{"$f":"B128","v":"Existing (1 Jan - 31 Dec): Tariff V Non-Residential - Multinet Metro"},{"$f":"INDEX('Prop2024-25DistTar'!$F$32:$F$37,C$34)","v":81},{"$f":"INDEX('Prop2024-25DistTar'!$F$32:$F$37,D$34)","v":4845.8111883000001},{"$f":"INDEX('Prop2024-25DistTar'!$F$32:$F$37,E$34)","v":6779.8160472},{"$f":"INDEX('Prop2024-25DistTar'!$F$32:$F$37,F$34)","v":2157.5744474000003},{"$f":"INDEX('Prop2024-25DistTar'!$F$32:$F$37,G$34)","v":8436.3274187000006},{"$f":"INDEX('Prop2024-25DistTar'!$F$32:$F$37,H$34)","v":9924.5671207999985}]
[]
[null,{"$f":"B130","v":"Proposed (1 Jan-31 Dec): Tariff V Non-Residential - Multinet Metro"},{"$f":"INDEX('Prop2024-25DistTar'!$F$32:$F$37,C$34)","v":81},{"$f":"INDEX('Prop2024-25DistTar'!$F$32:$F$37,D$34)","v":4845.8111883000001},{"$f":"INDEX('Prop2024-25DistTar'!$F$32:$F$37,E$34)","v":6779.8160472},{"$f":"INDEX('Prop2024-25DistTar'!$F$32:$F$37,F$34)","v":2157.5744474000003},{"$f":"INDEX('Prop2024-25DistTar'!$F$32:$F$37,G$34)","v":8436.3274187000006},{"$f":"INDEX('Prop2024-25DistTar'!$F$32:$F$37,H$34)","v":9924.5671207999985}]
[]
[null,"Distribution revenue","Fixed","Blk1","Blk2","Blk3","Blk4","Blk5"]
[]
[null,{"$f":"B134","v":"Existing (1 Jan - 31 Dec): Tariff V Non-Residential - Multinet Metro"},{"$f":"INDEX('Prop2024-25DistTar'!$H$32:$H$37,C$35)","v":9620.4510000000009},{"$f":"INDEX('Prop2024-25DistTar'!$H$32:$H$37,D$35)","v":20861.2171656315},{"$f":"INDEX('Prop2024-25DistTar'!$H$32:$H$37,E$35)","v":17178.69790039536},{"$f":"INDEX('Prop2024-25DistTar'!$H$32:$H$37,F$35)","v":3054.9096600736602},{"$f":"INDEX('Prop2024-25DistTar'!$H$32:$H$37,G$35)","v":6938.0356691388806},{"$f":"INDEX('Prop2024-25DistTar'!$H$32:$H$37,H$35)","v":2563.5156873026394}]
[]
[null,{"$f":"B136","v":"Proposed (1 Jan-31 Dec): Tariff V Non-Residential - Multinet Metro"},{"$f":"INDEX('Prop2024-25DistTar'!$G$32:$G$37,C$34)","v":9620.4510000000009},{"$f":"INDEX('Prop2024-25DistTar'!$G$32:$G$37,D$34)","v":22700.202511591349},{"$f":"INDEX('Prop2024-25DistTar'!$G$32:$G$37,E$34)","v":18692.630823735119},{"$f":"INDEX('Prop2024-25DistTar'!$G$32:$G$37,F$34)","v":3054.9096600736602},{"$f":"INDEX('Prop2024-25DistTar'!$G$32:$G$37,G$34)","v":6938.0356691388806},{"$f":"INDEX('Prop2024-25DistTar'!$G$32:$G$37,H$34)","v":2563.5156873026394}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B140","v":"Existing (1 Jan - 31 Dec): Tariff V Non-Residential - Multinet Metro"},{"$f":"SUM(C139:H140)","v":60216.827082542048}]
[null,{"$f":"B142","v":"Proposed (1 Jan-31 Dec): Tariff V Non-Residential - Multinet Metro"},{"$f":"SUM(C141:H142)","v":63569.745351841651}]
[]
[null,"Average price movement",{"$f":"IF(C146=0,\"\",C146/C145)","v":1.0556807529015702}]
[]
[null,{"$f":"IF(C148=\"\",\"\",IF(C148<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,"Tariff V Non-Residential - Multinet Yarra Valley Towns",1,2,3,4,5]
[null,null,1,2,3,4,5,6]
[null,"Distribution tariff","Fixed","Blk1","Blk2","Blk3","Blk4","Blk5"]
[]
[null,"Existing (1 Jan - 31 Dec): Tariff V Non-Residential - Multinet Yarra Valley Towns",{"$f":"INDEX('Prop2024-25DistTar'!$E$40:$E$45,C$35)","v":0.32390000000000002},{"$f":"INDEX('Prop2024-25DistTar'!$E$40:$E$45,D$35)","v":7.6014999999999997},{"$f":"INDEX('Prop2024-25DistTar'!$E$40:$E$45,E$35)","v":5.8148},{"$f":"INDEX('Prop2024-25DistTar'!$E$40:$E$45,F$35)","v":4.6292},{"$f":"INDEX('Prop2024-25DistTar'!$E$40:$E$45,G$35)","v":4.1310000000000002},{"$f":"INDEX('Prop2024-25DistTar'!$E$40:$E$45,H$35)","v":3.6738}]
[]
[null,{"$f":"\"Proposed (1 Jan-31 Dec): \"&B154","v":"Proposed (1 Jan-31 Dec): Tariff V Non-Residential - Multinet Yarra Valley Towns"},{"$f":"INDEX('Prop2024-25DistTar'!$D$40:$D$45,C$34)","v":0.32390000000000002},{"$f":"INDEX('Prop2024-25DistTar'!$D$40:$D$45,D$34)","v":8.2713000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$40:$D$45,E$34)","v":6.327},{"$f":"INDEX('Prop2024-25DistTar'!$D$40:$D$45,F$34)","v":4.6292},{"$f":"INDEX('Prop2024-25DistTar'!$D$40:$D$45,G$34)","v":4.1310000000000002},{"$f":"INDEX('Prop2024-25DistTar'!$D$40:$D$45,H$34)","v":3.6776}]
[]
[null,"Distribution volumes (actual)","Fixed","Blk1","Blk2","Blk3","Blk4","Blk5"]
[]
[null,{"$f":"B158","v":"Existing (1 Jan - 31 Dec): Tariff V Non-Residential - Multinet Yarra Valley Towns"},{"$f":"INDEX('Prop2024-25DistTar'!$F$40:$F$45,C$34)","v":7066},{"$f":"INDEX('Prop2024-25DistTar'!$F$40:$F$45,D$34)","v":77924.371808399999},{"$f":"INDEX('Prop2024-25DistTar'!$F$40:$F$45,E$34)","v":39997.194911899998},{"$f":"INDEX('Prop2024-25DistTar'!$F$40:$F$45,F$34)","v":26542.983169899999},{"$f":"INDEX('Prop2024-25DistTar'!$F$40:$F$45,G$34)","v":30260.106535600004},{"$f":"INDEX('Prop2024-25DistTar'!$F$40:$F$45,H$34)","v":24597.972790100001}]
[]
[null,{"$f":"B160","v":"Proposed (1 Jan-31 Dec): Tariff V Non-Residential - Multinet Yarra Valley Towns"},{"$f":"INDEX('Prop2024-25DistTar'!$F$40:$F$45,C$34)","v":7066},{"$f":"INDEX('Prop2024-25DistTar'!$F$40:$F$45,D$34)","v":77924.371808399999},{"$f":"INDEX('Prop2024-25DistTar'!$F$40:$F$45,E$34)","v":39997.194911899998},{"$f":"INDEX('Prop2024-25DistTar'!$F$40:$F$45,F$34)","v":26542.983169899999},{"$f":"INDEX('Prop2024-25DistTar'!$F$40:$F$45,G$34)","v":30260.106535600004},{"$f":"INDEX('Prop2024-25DistTar'!$F$40:$F$45,H$34)","v":24597.972790100001}]
[]
[null,"Distribution revenue","Fixed","Blk1","Blk2","Blk3","Blk4","Blk5"]
[]
[null,{"$f":"B164","v":"Existing (1 Jan - 31 Dec): Tariff V Non-Residential - Multinet Yarra Valley Towns"},{"$f":"INDEX('Prop2024-25DistTar'!$H$40:$H$45,C$35)","v":835367.25100000005},{"$f":"INDEX('Prop2024-25DistTar'!$H$40:$H$45,D$35)","v":592342.11230155255},{"$f":"INDEX('Prop2024-25DistTar'!$H$40:$H$45,E$35)","v":232575.68897371611},{"$f":"INDEX('Prop2024-25DistTar'!$H$40:$H$45,F$35)","v":122872.77769010108},{"$f":"INDEX('Prop2024-25DistTar'!$H$40:$H$45,G$35)","v":125004.50009856361},{"$f":"INDEX('Prop2024-25DistTar'!$H$40:$H$45,H$35)","v":90368.032436269379}]
[]
[null,{"$f":"B166","v":"Proposed (1 Jan-31 Dec): Tariff V Non-Residential - Multinet Yarra Valley Towns"},{"$f":"INDEX('Prop2024-25DistTar'!$G$40:$G$45,C$34)","v":835367.25100000005},{"$f":"INDEX('Prop2024-25DistTar'!$G$40:$G$45,D$34)","v":644535.85653881892},{"$f":"INDEX('Prop2024-25DistTar'!$G$40:$G$45,E$34)","v":253062.25220759129},{"$f":"INDEX('Prop2024-25DistTar'!$G$40:$G$45,F$34)","v":122872.77769010108},{"$f":"INDEX('Prop2024-25DistTar'!$G$40:$G$45,G$34)","v":125004.50009856361},{"$f":"INDEX('Prop2024-25DistTar'!$G$40:$G$45,H$34)","v":90461.504732871763}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B170","v":"Existing (1 Jan - 31 Dec): Tariff V Non-Residential - Multinet Yarra Valley Towns"},{"$f":"SUM(C169:H170)","v":1998530.3625002028}]
[null,{"$f":"B172","v":"Proposed (1 Jan-31 Dec): Tariff V Non-Residential - Multinet Yarra Valley Towns"},{"$f":"SUM(C171:H172)","v":2071304.1422679464}]
[]
[null,"Average price movement",{"$f":"IF(C176=0,\"\",C176/C175)","v":1.0364136473146708}]
[]
[null,{"$f":"IF(C178=\"\",\"\",IF(C178<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,"Tariff V Non-Residential - Multinet Gippsland Towns",1,2,3,4,5]
[null,null,1,2,3,4,5,6]
[null,"Distribution tariff","Fixed","Blk1","Blk2","Blk3","Blk4","Blk5"]
[]
[null,"Existing (1 Jan - 31 Dec): Tariff V Non-Residential - Multinet Gippsland Towns",{"$f":"INDEX('Prop2024-25DistTar'!$E$48:$E$53,C$35)","v":0.32540000000000002},{"$f":"INDEX('Prop2024-25DistTar'!$E$48:$E$53,D$35)","v":8.3989999999999991},{"$f":"INDEX('Prop2024-25DistTar'!$E$48:$E$53,E$35)","v":6.4669999999999996},{"$f":"INDEX('Prop2024-25DistTar'!$E$48:$E$53,F$35)","v":5.1710000000000003},{"$f":"INDEX('Prop2024-25DistTar'!$E$48:$E$53,G$35)","v":4.6614000000000004},{"$f":"INDEX('Prop2024-25DistTar'!$E$48:$E$53,H$35)","v":4.173}]
[]
[null,{"$f":"\"Proposed (1 Jan-31 Dec): \"&B184","v":"Proposed (1 Jan-31 Dec): Tariff V Non-Residential - Multinet Gippsland Towns"},{"$f":"INDEX('Prop2024-25DistTar'!$D$48:$D$53,C$34)","v":0.32540000000000002},{"$f":"INDEX('Prop2024-25DistTar'!$D$48:$D$53,D$34)","v":9.1395},{"$f":"INDEX('Prop2024-25DistTar'!$D$48:$D$53,E$34)","v":7.0369000000000002},{"$f":"INDEX('Prop2024-25DistTar'!$D$48:$D$53,F$34)","v":5.1710000000000003},{"$f":"INDEX('Prop2024-25DistTar'!$D$48:$D$53,G$34)","v":4.6614000000000004},{"$f":"INDEX('Prop2024-25DistTar'!$D$48:$D$53,H$34)","v":4.1752000000000002}]
[]
[null,"Distribution volumes (actual)","Fixed","Blk1","Blk2","Blk3","Blk4","Blk5"]
[]
[null,{"$f":"B188","v":"Existing (1 Jan - 31 Dec): Tariff V Non-Residential - Multinet Gippsland Towns"},{"$f":"INDEX('Prop2024-25DistTar'!$F$48:$F$53,C$34)","v":125},{"$f":"INDEX('Prop2024-25DistTar'!$F$48:$F$53,D$34)","v":7533.2883512000008},{"$f":"INDEX('Prop2024-25DistTar'!$F$48:$F$53,E$34)","v":14642.909544599999},{"$f":"INDEX('Prop2024-25DistTar'!$F$48:$F$53,F$34)","v":6367.3688199999997},{"$f":"INDEX('Prop2024-25DistTar'!$F$48:$F$53,G$34)","v":24547.810696600001},{"$f":"INDEX('Prop2024-25DistTar'!$F$48:$F$53,H$34)","v":33319.561793000001}]
[]
[null,{"$f":"B190","v":"Proposed (1 Jan-31 Dec): Tariff V Non-Residential - Multinet Gippsland Towns"},{"$f":"INDEX('Prop2024-25DistTar'!$F$48:$F$53,C$34)","v":125},{"$f":"INDEX('Prop2024-25DistTar'!$F$48:$F$53,D$34)","v":7533.2883512000008},{"$f":"INDEX('Prop2024-25DistTar'!$F$48:$F$53,E$34)","v":14642.909544599999},{"$f":"INDEX('Prop2024-25DistTar'!$F$48:$F$53,F$34)","v":6367.3688199999997},{"$f":"INDEX('Prop2024-25DistTar'!$F$48:$F$53,G$34)","v":24547.810696600001},{"$f":"INDEX('Prop2024-25DistTar'!$F$48:$F$53,H$34)","v":33319.561793000001}]
[]
[null,"Distribution revenue","Fixed","Blk1","Blk2","Blk3","Blk4","Blk5"]
[]
[null,{"$f":"B194","v":"Existing (1 Jan - 31 Dec): Tariff V Non-Residential - Multinet Gippsland Towns"},{"$f":"INDEX('Prop2024-25DistTar'!$H$48:$H$53,C$35)","v":14846.375000000002},{"$f":"INDEX('Prop2024-25DistTar'!$H$48:$H$53,D$35)","v":63272.0888617288},{"$f":"INDEX('Prop2024-25DistTar'!$H$48:$H$53,E$35)","v":94695.696024928184},{"$f":"INDEX('Prop2024-25DistTar'!$H$48:$H$53,F$35)","v":32925.664168219999},{"$f":"INDEX('Prop2024-25DistTar'!$H$48:$H$53,G$35)","v":114427.16478113126},{"$f":"INDEX('Prop2024-25DistTar'!$H$48:$H$53,H$35)","v":139042.53136218901}]
[]
[null,{"$f":"B196","v":"Proposed (1 Jan-31 Dec): Tariff V Non-Residential - Multinet Gippsland Towns"},{"$f":"INDEX('Prop2024-25DistTar'!$G$48:$G$53,C$34)","v":14846.375000000002},{"$f":"INDEX('Prop2024-25DistTar'!$G$48:$G$53,D$34)","v":68850.488885792409},{"$f":"INDEX('Prop2024-25DistTar'!$G$48:$G$53,E$34)","v":103040.69017439574},{"$f":"INDEX('Prop2024-25DistTar'!$G$48:$G$53,F$34)","v":32925.664168219999},{"$f":"INDEX('Prop2024-25DistTar'!$G$48:$G$53,G$34)","v":114427.16478113126},{"$f":"INDEX('Prop2024-25DistTar'!$G$48:$G$53,H$34)","v":139115.83439813362}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B200","v":"Existing (1 Jan - 31 Dec): Tariff V Non-Residential - Multinet Gippsland Towns"},{"$f":"SUM(C199:H200)","v":459209.52019819722}]
[null,{"$f":"B202","v":"Proposed (1 Jan-31 Dec): Tariff V Non-Residential - Multinet Gippsland Towns"},{"$f":"SUM(C201:H202)","v":473206.21740767302}]
[]
[null,"Average price movement",{"$f":"IF(C206=0,\"\",C206/C205)","v":1.0304799804747835}]
[]
[null,{"$f":"IF(C208=\"\",\"\",IF(C208<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,"Tariff D - Multinet"]
[null,null,1,2]
[null,"Distribution tariff","DemBlk1","DemBlk2"]
[null,"Existing: Tariff D - Multinet",{"$f":"INDEX('Prop2024-25DistTar'!$E$55:$E$56,C215)","v":671.02139999999997},{"$f":"INDEX('Prop2024-25DistTar'!$E$55:$E$56,D215)","v":114.17749999999999}]
[null,{"$f":"\"Proposed: \"&B214","v":"Proposed: Tariff D - Multinet"},{"$f":"INDEX('Prop2024-25DistTar'!$D$55:$D$56,C215)","v":698.21119999999996},{"$f":"INDEX('Prop2024-25DistTar'!$D$55:$D$56,D215)","v":118.8039}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2"]
[null,{"$f":"B217","v":"Existing: Tariff D - Multinet"},{"$f":"INDEX('Prop2024-25DistTar'!$F$55:$F$56,C$215)","v":3180.1400000000017},{"$f":"INDEX('Prop2024-25DistTar'!$F$55:$F$56,D$215)","v":821.37000000000012}]
[null,{"$f":"B218","v":"Proposed: Tariff D - Multinet"},{"$f":"INDEX('Prop2024-25DistTar'!$F$55:$F$56,C$215)","v":3180.1400000000017},{"$f":"INDEX('Prop2024-25DistTar'!$F$55:$F$56,D$215)","v":821.37000000000012}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2"]
[null,{"$f":"B221","v":"Existing: Tariff D - Multinet"},{"$f":"INDEX('Prop2024-25DistTar'!$H$55:$H$56,C215)","v":2133941.994996001},{"$f":"INDEX('Prop2024-25DistTar'!$H$55:$H$56,D215)","v":93781.973175000006}]
[null,{"$f":"B222","v":"Proposed: Tariff D - Multinet"},{"$f":"INDEX('Prop2024-25DistTar'!$G$55:$G$56,C215)","v":2220409.3655680013},{"$f":"INDEX('Prop2024-25DistTar'!$G$55:$G$56,D215)","v":97581.95934300001}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B225","v":"Existing: Tariff D - Multinet"},{"$f":"SUM(C225:D225)","v":2227723.9681710009}]
[null,{"$f":"B226","v":"Proposed: Tariff D - Multinet"},{"$f":"SUM(C226:D226)","v":2317991.3249110011}]
[]
[null,"Average price movement",{"$f":"IF(C230=0,\"\",C230/C229)","v":1.0405199917178749}]
[]
[null,{"$f":"IF(C232=\"\",\"\",IF(C232<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,"Tariff D - Multinet South Gippsland"]
[null,null,1,2]
[null,"Distribution tariff","DemBlk1","DemBlk2"]
[null,"Existing: Tariff D - Multinet South Gippsland",{"$f":"INDEX('Prop2024-25DistTar'!$E$58:$E$59,C239)","v":725.03549999999996},{"$f":"INDEX('Prop2024-25DistTar'!$E$58:$E$59,D239)","v":123.35129999999999}]
[null,{"$f":"\"Proposed: \"&B238","v":"Proposed: Tariff D - Multinet South Gippsland"},{"$f":"INDEX('Prop2024-25DistTar'!$D$58:$D$59,C239)","v":754.41390000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$58:$D$59,D239)","v":128.3494}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2"]
[null,{"$f":"B241","v":"Existing: Tariff D - Multinet South Gippsland"},{"$f":"INDEX('Prop2024-25DistTar'!$F$58:$F$59,C$239)","v":100},{"$f":"INDEX('Prop2024-25DistTar'!$F$58:$F$59,D$239)","v":56.129999999999995}]
[null,{"$f":"B242","v":"Proposed: Tariff D - Multinet South Gippsland"},{"$f":"INDEX('Prop2024-25DistTar'!$F$58:$F$59,C$239)","v":100},{"$f":"INDEX('Prop2024-25DistTar'!$F$58:$F$59,D$239)","v":56.129999999999995}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2"]
[null,{"$f":"B245","v":"Existing: Tariff D - Multinet South Gippsland"},{"$f":"INDEX('Prop2024-25DistTar'!$H$58:$H$59,C239)","v":72503.549999999988},{"$f":"INDEX('Prop2024-25DistTar'!$H$58:$H$59,D239)","v":6923.7084689999992}]
[null,{"$f":"B246","v":"Proposed: Tariff D - Multinet South Gippsland"},{"$f":"INDEX('Prop2024-25DistTar'!$G$58:$G$59,C239)","v":75441.39},{"$f":"INDEX('Prop2024-25DistTar'!$G$58:$G$59,D239)","v":7204.2518219999993}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B249","v":"Existing: Tariff D - Multinet South Gippsland"},{"$f":"SUM(C249:D249)","v":79427.258468999993}]
[null,{"$f":"B250","v":"Proposed: Tariff D - Multinet South Gippsland"},{"$f":"SUM(C250:D250)","v":82645.641822000005}]
[]
[null,"Average price movement",{"$f":"IF(C254=0,\"\",C254/C253)","v":1.0405198846722896}]
[]
[null,{"$f":"IF(C256=\"\",\"\",IF(C256<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[null,"Tariff  L- Multinet Metro",1,2,3,4]
[null,null,1,2,3]
[null,"Distribution tariff","Blk1","Blk2","Rolling12","PD"]
[]
[null,"Existing (1 Jan - 31 Dec): Tariff  L- Multinet Non-Residential",{"$f":"INDEX('Prop2024-25DistTar'!$E$62:$E$65,C$35)","v":0.57909999999999995},{"$f":"INDEX('Prop2024-25DistTar'!$E$62:$E$65,D$35)","v":0.14130000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$E$62:$E$65,E$35)","v":0.64370000000000005},{"$f":"INDEX('Prop2024-25DistTar'!$E$62:$E$65,F$35)","v":1.9255}]
[]
[null,{"$f":"\"Proposed (1 Jan-31 Dec): \"&B261","v":"Proposed (1 Jan-31 Dec): Tariff  L- Multinet Metro"},{"$f":"INDEX('Prop2024-25DistTar'!$D$62:$D$65,C$35)","v":0.60260000000000002},{"$f":"INDEX('Prop2024-25DistTar'!$D$62:$D$65,D$35)","v":0.14699999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$D$62:$D$65,E$35)","v":0.66969999999999996},{"$f":"INDEX('Prop2024-25DistTar'!$D$62:$D$65,F$35)","v":2.0034999999999998}]
[]
[null,"Distribution volumes (actual)","Blk1","Blk2","Rolling12","PD"]
[]
[null,{"$f":"B265","v":"Existing (1 Jan - 31 Dec): Tariff  L- Multinet Non-Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$F$62:$F$65,C$35)","v":20269.170000000002},{"$f":"INDEX('Prop2024-25DistTar'!$F$62:$F$65,D$35)","v":56434.920000000013},{"$f":"INDEX('Prop2024-25DistTar'!$F$62:$F$65,E$35)","v":45.105833333333337},{"$f":"INDEX('Prop2024-25DistTar'!$F$62:$F$65,F$35)","v":39.56}]
[]
[null,{"$f":"B267","v":"Proposed (1 Jan-31 Dec): Tariff  L- Multinet Metro"},{"$f":"INDEX('Prop2024-25DistTar'!$F$62:$F$65,C$35)","v":20269.170000000002},{"$f":"INDEX('Prop2024-25DistTar'!$F$62:$F$65,D$35)","v":56434.920000000013},{"$f":"INDEX('Prop2024-25DistTar'!$F$62:$F$65,E$35)","v":45.105833333333337},{"$f":"INDEX('Prop2024-25DistTar'!$F$62:$F$65,F$35)","v":39.56}]
[]
[null,"Distribution revenue","Blk1","Blk2","Rolling12","PD"]
[]
[null,{"$f":"B271","v":"Existing (1 Jan - 31 Dec): Tariff  L- Multinet Non-Residential"},{"$f":"INDEX('Prop2024-25DistTar'!$H$62:$H$65,C$35)","v":11737.876346999999},{"$f":"INDEX('Prop2024-25DistTar'!$H$62:$H$65,D$35)","v":7974.2541960000026},{"$f":"INDEX('Prop2024-25DistTar'!$H$62:$H$65,E$35)","v":10597.638094583335},{"$f":"INDEX('Prop2024-25DistTar'!$H$62:$H$65,F$35)","v":9293.0791600000011}]
[]
[null,{"$f":"B273","v":"Proposed (1 Jan-31 Dec): Tariff  L- Multinet Metro"},{"$f":"INDEX('Prop2024-25DistTar'!$G$62:$G$65,C$35)","v":12214.201842000002},{"$f":"INDEX('Prop2024-25DistTar'!$G$62:$G$65,D$35)","v":8295.9332400000021},{"$f":"INDEX('Prop2024-25DistTar'!$G$62:$G$65,E$35)","v":11025.692452916668},{"$f":"INDEX('Prop2024-25DistTar'!$G$62:$G$65,F$35)","v":9669.5321199999998}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B277","v":"Existing (1 Jan - 31 Dec): Tariff  L- Multinet Non-Residential"},{"$f":"SUM(C277:F277)","v":39602.847797583338}]
[null,{"$f":"B279","v":"Proposed (1 Jan-31 Dec): Tariff  L- Multinet Metro"},{"$f":"SUM(C279:F279)","v":41205.359654916669}]
[]
[null,"Average price movement",{"$f":"IF(C283=0,\"\",C283/C282)","v":1.0404645611730761}]
[]
[null,{"$f":"IF(C285=\"\",\"\",IF(C285<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]

{"sheet":"ARS","index":6,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Tariff Approval - Multinet"]
[]
["Ancillary Reference Services (Exc GST)"]
[]
[null,"2023-24","2024-25"]
["Turn On / Reconnections",49.17,{"$f":"ROUND(B6*(1+'Model update'!$B$31),0)","v":51}]
["Meter Investigations",166.51,{"$f":"ROUND(B7*(1+'Model update'!$B$31),0)","v":173}]
["Disconnections",58.33,{"$f":"ROUND(B8*(1+'Model update'!$B$31),0)","v":61}]
["Special meter reading",7.47,{"$f":"ROUND(B9*(1+'Model update'!$B$31),1)","v":7.8}]
["Meter removals",69.680000000000007,{"$f":"ROUND(B10*(1+'Model update'!$B$31),0)","v":73}]
["Meter reinstallation",69.680000000000007,{"$f":"ROUND(B11*(1+'Model update'!$B$31),0)","v":73}]
["Service abolishment - Residential",220,{"$f":"ROUND(B12*(1+'Model update'!$B$31),0)","v":229}]