{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["NOTES","Model update","Prop2024-25DistTar","2024-25TarContForm","2024-25RebalContForm","ARS"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":32,"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":false,"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"}]
[]
[]
["AusNet:",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 ","AusNet Services"]
[]
["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,231500,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":1.051692488463654E-3},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":-1.0824473459514232E-3}]
[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",-2.4115202041949779E-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":1.0516924884635959E-3}]
["2026-27"]
["2027-28"]
[]
[{"$f":"\"Xt for \"&B$5","v":"Xt for 2024-25"},{"$f":"VLOOKUP(B5,A35:B38,2,FALSE)","v":-2.4115202041949779E-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":1527242.8369422767},1578100]
["2023-24",2.9840010673424233E-2,null,{"$f":"A45","v":"2024-25"},{"$f":"E53*(1+H52)*(1+H52)","v":2041040.782428338},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":2.3079872372834353E-4}]
[{"$f":"A35","v":"2024-25"},3.0666169487703288E-2,null,"2025-26",{"$f":"E54*(1+H52)*(1+H52)*(1+H52)","v":2584894.1114879232},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.6260732387111603E-2}]
[{"$f":"A36","v":"2025-26"},null,null,"2026-27",{"$f":"E55*(1+H52)*(1+H52)*(1+H52)*(1+H52)","v":4152272.1480065156},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.1257772591616859E-2}]
["2026-27",null,null,"2027-28",{"$f":"E56*(1+H52)*(1+H52)*(1+H52)*(1+H52)*(1+H52)","v":5813282.0157020558},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":-1.808404273622417E-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":2.3079872372844257E-4}]
[{"$f":"\"Pre-tax real WACC for \"&B8","v":"Pre-tax real WACC for 2023-24"},{"$f":"VLOOKUP(B8,A44:B48,2,FALSE)","v":2.9840010673424233E-2}]
[{"$f":"\"Pre-tax real WACC for \"&B5","v":"Pre-tax real WACC for 2024-25"},{"$f":"VLOOKUP(B5,A44:B48,2,FALSE)","v":3.0666169487703288E-2},null,null,"Fcst af(t) $22-23",null,null,"Forecast inflation"]
[null,null,null,null,1483922.6121439701,null,null,2.9193048507912201E-2]
[null,null,null,null,1926894.75305762]
[null,null,null,null,2371112.8527037702]
[null,null,null,null,3700824.0142885]
[null,null,null,null,5034277.7324878499]

{"sheet":"Prop2024-25DistTar","index":2,"n_rows":137,"n_cols":8,"rows_kept":137,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"\"Tariff Approval - \"&'Model update'!B3","v":"Tariff Approval - AusNet Services"},{"$f":"\"Prop\"&'Model update'!B5&\"DistTar\"","v":"Prop2024-25DistTar"}]
[]
[null,{"$f":"\"PROPOSED \"&'Model update'!$B$5&\" DISTRIBUTION TARIFFS\"","v":"PROPOSED 2024-25 DISTRIBUTION TARIFFS"}]
[]
[null,"Proposed tariff name","Existing name",{"$f":"\"Prop\n\"&'Model update'!$B$5&\" Tariff\"","v":"Prop\n2024-25 Tariff"},{"$f":"\"Exist\n\"&'Model update'!$B$8&\" Tariff\"","v":"Exist\n2023-24 Tariff"},{"$f":"\"Actual \"&'Model update'!$B$9&\" Volumes\"","v":"Actual 2022-23 Volumes"},"Prop Tar\nRevenue","Exist Tar\nRevenue"]
[null,"Tariff V - Central Zone - Domestic","Tariff V - Central Zone - Domestic"]
[]
[null,"Fixed Charge","Fixed Charge",0.49419999999999997,0.47060000000000002,596408.54662832047,{"$f":"D8*$F8*365","v":107581962.86645633},{"$f":"E8*$F8*365","v":102444499.64579998}]
[null,"Peak 0 - 0.1","Peak 0 - 0.1",7.0918999999999999,6.4835000000000003,4565205.3161405791,{"$f":"D9*$F9","v":32375979.581537373},29598508.667197447]
[null,"Peak 0.1 - 0.2","Peak 0.1 - 0.2",4.2744,3.9077000000000002,2974213.1170785199,12712976.547640426,11622332.597607732]
[null,"Peak 0.2 - 1.4","Peak 0.2 - 1.4",0.74309999999999998,0.6794,4297336.9780144291,3193351.108362522,2919610.7428630032]
[null,"Peak > 1.4","Peak > 1.4",0.66759999999999997,0.61029999999999995,44764.026766459618,29884.464269288441,27319.485535570304]
[null,"Off Peak 0 - 0.1","Off Peak 0 - 0.1",2.4039000000000001,2.1977000000000002,7981395.1072894596,19186475.698413134,17540712.027290046]
[null,"Off Peak 0.1 - 0.2","Off Peak 0.1 - 0.2",1.8996999999999999,1.7366999999999999,2139042.6618121699,4063539.3446445791,3714875.3907691953]
[null,"Off Peak 0.2 - 1.4","Off Peak 0.2 - 1.4",0.72809999999999997,0.66559999999999997,1445615.067227999,1052552.3304487059,962201.38874695613]
[null,"Off Peak > 1.4","Off Peak > 1.4",0.25829999999999997,0.2361,63559.902670351999,16417.52285975192,15006.493020470107]
[null,"Tariff V - Central Zone - Non-domestic","Tariff V - Central Zone - Non-domestic"]
[]
[null,"Fixed Charge","Fixed Charge",0.51600000000000001,0.49130000000000001,11341.701067130802,{"$f":"D19*$F19*365","v":2136095.9789834153},{"$f":"E19*$F19*365","v":2033844.8730126976}]
[null,"Peak 0 - 0.1","Peak 0 - 0.1",1.2776000000000001,1.1679999999999999,77701.752103056278,{"$f":"D20*$F20","v":99271.75848686471},90755.646456369723]
[null,"Peak 0.1 - 0.2","Peak 0.1 - 0.2",1.2171000000000001,1.1127,62502.956028340377,76072.347782093071,69547.039172734338]
[null,"Peak 0.2 - 1.4","Peak 0.2 - 1.4",1.0952999999999999,1.0013000000000001,386317.66805475706,423133.74182037538,386819.88102322828]
[null,"Peak > 1.4","Peak > 1.4",0.83599999999999997,0.76429999999999998,1056407.4187933807,883156.60211126623,807412.19018378085]
[null,"Off Peak 0 - 0.1","Off Peak 0 - 0.1",1.2104999999999999,1.1067,168895.74330064782,204448.29726543417,186916.91911082694]
[null,"Off Peak 0.1 - 0.2","Off Peak 0.1 - 0.2",0.84699999999999998,0.77429999999999999,123143.75360101571,104302.75930006029,95350.20841326646]
[null,"Off Peak 0.2 - 1.4","Off Peak 0.2 - 1.4",0.69730000000000003,0.63749999999999996,749643.25975939899,522726.24503022892,477897.57809661684]
[null,"Off Peak > 1.4","Off Peak > 1.4",0.67610000000000003,0.61809999999999998,1641338.7854596544,1109709.1528492724,1014511.5032926124]
[null,"Tariff V - West Zone - Domestic","Tariff V - West Zone - Domestic"]
[]
[null,"Fixed Charge","Fixed Charge",0.49419999999999997,0.47060000000000002,154491.290978581,{"$f":"D30*$F30*365","v":27867602.540589377},{"$f":"E30*$F30*365","v":26536814.560099881}]
[null,"Peak 0 - 0.1","Peak 0 - 0.1",3.7486000000000002,3.427,1212721.6011625226,{"$f":"D31*$F31","v":4546008.194117832},4155996.9271839648]
[null,"Peak 0.1 - 0.2","Peak 0.1 - 0.2",2.6991000000000001,2.4676,843491.03506462043,2276666.6527429172,2081398.4781254574]
[null,"Peak 0.2 - 1.4","Peak 0.2 - 1.4",0.87190000000000001,0.79710000000000003,1243315.0189067968,1084046.3649848362,991046.40157060779]
[null,"Peak > 1.4","Peak > 1.4",0.8357,0.76400000000000001,8182.3593660425468,6837.997722201756,6251.3225556565058]
[null,"Off Peak 0 - 0.1","Off Peak 0 - 0.1",1.159,1.0596000000000001,2101963.7438984001,2436175.9791782456,2227240.7830347451]
[null,"Off Peak 0.1 - 0.2","Off Peak 0.1 - 0.2",1.0862000000000001,0.99299999999999999,687337.42406805512,746585.91002272151,682526.06209957867]
[null,"Off Peak 0.2 - 1.4","Off Peak 0.2 - 1.4",0.61929999999999996,0.56620000000000004,511727.71114503802,316912.97151212202,289740.23005032056]
[null,"Off Peak > 1.4","Off Peak > 1.4",0.1222,0.11169999999999999,10147.40188850125,1240.0125107748529,1133.4647909455896]
[null,"Tariff V - West Zone - Non-domestic","Tariff V - West Zone - Non-domestic"]
[]
[null,"Fixed Charge","Fixed Charge",0.51600000000000001,0.49130000000000001,6319.5363959736605,{"$f":"D41*$F41*365","v":1190221.4848176793},{"$f":"E41*$F41*365","v":1133247.7044397788}]
[null,"Peak 0 - 0.1","Peak 0 - 0.1",1.9523999999999999,1.7848999999999999,39559.947559392487,{"$f":"D42*$F42","v":77236.841614957884},70610.550398759646]
[null,"Peak 0.1 - 0.2","Peak 0.1 - 0.2",1.6456,1.5044,30232.375972024089,49750.397899562842,45481.586412313038]
[null,"Peak 0.2 - 1.4","Peak 0.2 - 1.4",1.0165999999999999,0.9294,165603.82219958378,168352.84564809687,153912.19235229318]
[null,"Peak > 1.4","Peak > 1.4",0.38119999999999998,0.34849999999999998,364941.06599113869,139115.53435582205,127181.96149791182]
[null,"Off Peak 0 - 0.1","Off Peak 0 - 0.1",0.90469999999999995,0.82709999999999995,78897.447668684603,71378.520905858953,65256.078966769033]
[null,"Off Peak 0.1 - 0.2","Off Peak 0.1 - 0.2",0.76219999999999999,0.69679999999999997,52272.503506173598,39842.102172405517,36423.480443101762]
[null,"Off Peak 0.2 - 1.4","Off Peak 0.2 - 1.4",0.36720000000000003,0.3357,277192.26564201567,101784.99994374816,93053.443576024656]
[null,"Off Peak > 1.4","Off Peak > 1.4",0.27310000000000001,0.24970000000000001,484525.17004118394,132323.82393824734,120985.93495928364]
[null,"Tariff V - Adjoining Central Zone - Domestic","Tariff V - Adjoining Central Zone - Domestic"]
[]
[null,"Fixed Charge","Fixed Charge",0.49419999999999997,0.47060000000000002,2381.9923711496203,{"$f":"D52*$F52*365","v":429670.92988508189},{"$f":"E52*$F52*365","v":409152.44759999914}]
[null,"Peak 0 - 0.1","Peak 0 - 0.1",11.6142,10.617900000000001,18506.2377637768,{"$f":"D53*$F53","v":214935.14663605651},196497.3819520057]
[null,"Peak 0.1 - 0.2","Peak 0.1 - 0.2",8.3699999999999992,7.6520000000000001,11369.775471244104,95165.020694313134,87001.521905959889]
[null,"Peak 0.2 - 1.4","Peak 0.2 - 1.4",2.9811999999999999,2.7254999999999998,14718.789738890708,43879.655969580977,40116.061433346622]
[null,"Peak > 1.4","Peak > 1.4",2.8586999999999998,2.6135000000000002,550.6742760882878,1574.2125530535882,1439.1872205567402]
[null,"Off Peak 0 - 0.1","Off Peak 0 - 0.1",5.2013999999999996,4.7552000000000003,27233.569032462801,141652.68596545199,129501.06746316713]
[null,"Off Peak 0.1 - 0.2","Off Peak 0.1 - 0.2",3.0165000000000002,2.7576999999999998,8013.407051101849,24172.442369648728,22098.572624823566]
[null,"Off Peak 0.2 - 1.4","Off Peak 0.2 - 1.4",2.6246999999999998,2.3995000000000002,7287.2820233605999,19126.929126714564,17485.833215053761]
[null,"Off Peak > 1.4","Off Peak > 1.4",2.5240999999999998,2.3075999999999999,534.62389307461001,1349.4441685096231,1233.69809565897]
[null,"Tariff V - Adjoining Central Zone - Non-domestic","Tariff V - Adjoining Central Zone - Non-domestic"]
[]
[null,"Fixed Charge","Fixed Charge",0.51600000000000001,0.49130000000000001,27.435094225384049,{"$f":"D63*$F63*365","v":5167.1256464088319},{"$f":"E63*$F63*365","v":4919.7845544198826}]
[null,"Peak 0 - 0.1","Peak 0 - 0.1",4.7752999999999997,4.3657000000000004,237.17538108198565,{"$f":"D64*$F64","v":1132.5835972808061},1035.4365611896249]
[null,"Peak 0.1 - 0.2","Peak 0.1 - 0.2",4.5506000000000002,4.1601999999999997,177.5182640420955,807.81461234995982,738.51148206792561]
[null,"Peak 0.2 - 1.4","Peak 0.2 - 1.4",4.3017000000000003,3.9327000000000001,935.73502785967003,4025.2513693439428,3679.9651440637244]
[null,"Peak > 1.4","Peak > 1.4",4.0629,3.7143999999999999,340.2308270162448,1382.323827084301,1263.7533838691397]
[null,"Off Peak 0 - 0.1","Off Peak 0 - 0.1",4.3956999999999997,4.0186000000000002,413.170192327812,1816.1722144153632,1660.3657348885454]
[null,"Off Peak 0.1 - 0.2","Off Peak 0.1 - 0.2",4.2195999999999998,3.8576000000000001,259.74139027897348,1096.0047704211565,1001.9783871401681]
[null,"Off Peak 0.2 - 1.4","Off Peak 0.2 - 1.4",4.0888999999999998,3.7381000000000002,1633.7224380146479,6680.1276767980935,6107.0178455425557]
[null,"Off Peak > 1.4","Off Peak > 1.4",3.9889999999999999,3.6467999999999998,752.21597937855404,3000.589541741052,2743.1812335977106]
[null,"Tariff V - Adjoining West Zone - Domestic","Tariff V - Adjoining West Zone - Domestic"]
[]
[null,"Fixed Charge","Fixed Charge",0.49419999999999997,0.47060000000000002,14159.74529629905,{"$f":"D74*$F74*365","v":2554177.3357823114},{"$f":"E74*$F74*365","v":2432205.2897999915}]
[null,"Peak 0 - 0.1","Peak 0 - 0.1",8.1387,7.4405000000000001,109094.63468345813,{"$f":"D75*$F75","v":887888.50329826074},{"$f":"E75*$F75","v":811718.62936227024}]
[null,"Peak 0.1 - 0.2","Peak 0.1 - 0.2",6.8331999999999997,6.2469999999999999,81697.876124253176,558257.92713224678,510366.63214820961]
[null,"Peak 0.2 - 1.4","Peak 0.2 - 1.4",3.5068000000000001,3.206,144231.3418470521,505790.4695892423,462405.68196164904]
[null,"Peak > 1.4","Peak > 1.4",3.1454,2.8755999999999999,1956.4320952353041,6153.7615123531259,5625.9161330586403]
[null,"Off Peak 0 - 0.1","Off Peak 0 - 0.1",4.8296000000000001,4.4153000000000002,192439.42723898351,929405.4577933948,849677.80308828398]
[null,"Off Peak 0.1 - 0.2","Off Peak 0.1 - 0.2",3.6526000000000001,3.3393000000000002,72478.839231593898,264736.2081773199,242028.58784606151]
[null,"Off Peak 0.2 - 1.4","Off Peak 0.2 - 1.4",2.6154000000000002,2.391,59898.419395222503,156658.32608626495,143217.12077397702]
[null,"Off Peak > 1.4","Off Peak > 1.4",2.5335000000000001,2.3161999999999998,2618.3181341996287,6633.5089929947599,6064.5484624331793]
[null,"Tariff V - Adjoining West Zone - Non-domestic","Tariff V - Adjoining West Zone - Non-domestic"]
[]
[null,"Fixed Charge","Fixed Charge",0.51600000000000001,0.49130000000000001,337.07190645576247,{"$f":"D85*$F85*365","v":63484.122861878299},{"$f":"E85*$F85*365","v":60445.251089226382}]
[null,"Peak 0 - 0.1","Peak 0 - 0.1",5.8928000000000003,5.3872999999999998,2557.8576959599986,{"$f":"D86*$F86","v":15072.94383075308},{"$f":"E86*$F86","v":13779.9467654453}]
[null,"Peak 0.1 - 0.2","Peak 0.1 - 0.2",5.5313999999999997,5.0568999999999997,1990.2674093125215,11008.96514787128,10064.58326215249]
[null,"Peak 0.2 - 1.4","Peak 0.2 - 1.4",4.7510000000000003,4.3433999999999999,11676.909159171528,55476.99541522393,50717.487241945615]
[null,"Peak > 1.4","Peak > 1.4",4.1760999999999999,3.8178999999999998,23760.919721035876,99227.976847017926,90716.81540294287]
[null,"Off Peak 0 - 0.1","Off Peak 0 - 0.1",4.5301999999999998,4.1416000000000004,5620.0499890956398,25459.950460601067,23275.999034838504]
[null,"Off Peak 0.1 - 0.2","Off Peak 0.1 - 0.2",4.3103999999999996,3.9405999999999999,4061.7421177545439,17507.733224369185,16005.700989223555]
[null,"Off Peak 0.2 - 1.4","Off Peak 0.2 - 1.4",3.7683,3.4449999999999998,22996.021450020431,86655.907630111993,79221.293895320385]
[null,"Off Peak > 1.4","Off Peak > 1.4",3.5884,3.2806000000000002,34043.049882669286,122160.08019897046,111681.62944508487]
[]
[null,"Tariff M - Central Zone","Tariff M - Central Zone"]
[null,"0 - 10","0 - 10",802.68700000000001,752.29870000000005,150.06750000000005,{"$f":"D96*$F96","v":120457.23137250004},112895.58516225005]
[null,"10 - 50","10 - 50",764.49249999999995,716.5018,18.889166666666664,14440.626247916663,13534.121917166665]
[null,"> 50","> 50",159.6277,149.6071,0,0,0]
[]
[null,"Tariff M - West Zone","Tariff M - West Zone"]
[null,"0 - 10","0 - 10",802.68700000000001,752.29870000000005,60.633333333333326,{"$f":"D101*$F101","v":48669.588433333331},45614.377843333328]
[null,"10 - 50","10 - 50",764.49249999999995,716.5018,27.125000000000004,20736.8590625,19435.111325000002]
[null,"> 50","> 50",159.6277,149.6071,0,0,0]
[]
[null,"Tariff M - Adjoining Central Zone","Tariff M - Adjoining Central Zone"]
[null,"0 - 10","0 - 10",802.68700000000001,752.29870000000005,0,{"$f":"D106*$F106","v":0},0]
[null,"10 - 50","10 - 50",764.49249999999995,716.5018,0,0,0]
[null,"> 50","> 50",159.6277,149.6071,0,0,0]
[]
[null,"Tariff M - Adjoining West Zone","Tariff M - Adjoining West Zone"]
[null,"0 - 10","0 - 10",802.68700000000001,752.29870000000005,0,{"$f":"D111*$F111","v":0},0]
[null,"10 - 50","10 - 50",764.49249999999995,716.5018,0,0,0]
[null,"> 50","> 50",159.6277,149.6071,0,0,0]
[]
[]
[null,"Tariff D - Central Zone","Tariff D - Central Zone"]
[null,"0 - 10","0 - 10",366.16730000000001,343.18130000000002,1130.8474999999999,{"$f":"D117*$F117","v":414079.37578674994},388085.71515174996]
[null,"10 - 50","10 - 50",348.73360000000002,326.84199999999998,1412.6974999999998,492655.08488599997,461728.87629499991]
[null,"> 50","> 50",169.31450000000001,158.6859,2395.9641666666657,{"$f":"D119*$F119","v":405671.47489708319},{"$f":"E119*$F119","v":380205.73015524988}]
[]
[null,"Tariff D - West Zone","Tariff D - West Zone"]
[null,"0 - 10","0 - 10",366.16730000000001,343.18130000000002,484.39666666666676,{"$f":"D122*$F122","v":177370.21956233337},166235.87778233338]
[null,"10 - 50","10 - 50",348.73360000000002,326.84199999999998,632.27583333333337,220495.82755133335,206654.29791833332]
[null,"> 50","> 50",169.31450000000001,158.6859,297.11416666666673,50305.736572083348,47147.828940250009]
[]
[null,"Tariff D - Adjoining Central Zone","Tariff D - Adjoining Central Zone"]
[null,"0 - 10","0 - 10",366.16730000000001,343.18130000000002,10,{"$f":"D127*$F127","v":3661.6730000000002},3431.8130000000001]
[null,"10 - 50","10 - 50",348.73360000000002,326.84199999999998,17.778333333333332,{"$f":"D128*$F128","v":6199.9021853333334},5810.7060233333332]
[null,"> 50","> 50",169.31450000000001,158.6859,0,0,0]
[]
[null,"Tariff D - Adjoining West Zone","Tariff D - Adjoining West Zone"]
[null,"0 - 10","0 - 10",366.16730000000001,343.18130000000002,11.575833333333332,{"$f":"D132*$F132","v":4238.6916369166665},3972.6095319166666]
[null,"10 - 50","10 - 50",348.73360000000002,326.84199999999998,4.1608333333333327,1451.0223873333332,1359.9350883333332]
[null,"> 50","> 50",169.31450000000001,158.6859,0,0,0]
[]
[]
[null,"Total Revenue","Total Revenue",null,null,null,{"$f":"SUM(G8:G135)","v":236366963.47112548},{"$f":"SUM(H8:H135)","v":221529430.70882362}]

{"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 - AusNet Services"},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":-2.4115202041949779E-2}]
[null,"Pass-through Amount",{"$f":"'Model update'!H23","v":0},null,null,null,{"$f":"(1+C9)*(1-C10)*C23","v":236064469.50626254}]
[null,"Safeguard Mechanism Amount",{"$f":"'Model update'!H36","v":1.0516924884635959E-3},null,null,null,{"$f":"(1+C9)*(1-C10)*(1+C11)*(1+0)*C23","v":236064469.50626254}]
[null,"Abolishment True-up Amount",{"$f":"'Model update'!H49","v":2.3079872372844257E-4},null,null,null,{"$f":"(1+C9)*(1-C10)*(1+C11)*(1+C12)*C23","v":236312736.73563543}]
[]
[]
[]
[]
[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.0669791217238034}]
[]
[null,"Proposed distribution tariff revenue",{"$f":"IF('Prop2024-25DistTar'!G137=0,\"\",'Prop2024-25DistTar'!G137)","v":236366963.47112548}]
[null,"Existing distribution tariff revenue",{"$f":"IF('Prop2024-25DistTar'!H137=0,\"\",'Prop2024-25DistTar'!H137)","v":221529430.70882362}]
[null,"Average price movement",{"$f":"IF(C22=\"\",\"\",C22/C23)","v":1.066977704564249}]
[]
[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":469,"n_cols":11,"rows_kept":469,"cut":false,"hidden":false,"merged":[[468,1,468,2],[348,1,348,2],[372,1,372,2],[396,1,396,2],[420,1,420,2],[444,1,444,2],[324,1,324,2],[66,1,66,2],[96,1,96,2],[126,1,126,2],[186,1,186,2],[216,1,216,2],[246,1,246,2],[300,1,300,2],[156,1,156,2],[276,1,276,2]]}
[null,{"$f":"\"Tariff Approval - \"&'Model update'!B3","v":"Tariff Approval - AusNet Services"},{"$f":"'Model update'!B5&\"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":-2.4115202041949779E-2}]
[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":1.0516924884635959E-3}]
[null,{"$f":"'2024-25TarContForm'!B13","v":"Abolishment True-up Amount"},{"$f":"'2024-25TarContForm'!C13","v":2.3079872372844257E-4}]
[null,"Y factor",0.02]
[]
[null,"Rebalancing control",{"$f":"(1+C8)*(1-C9)*(1+C10)*(1+C11)*(1+C13)","v":1.0880675795495891},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":"B41","v":"Tariff V - Central Zone - Domestic"},{"$f":"C62","v":168845066.43883038},{"$f":"C63","v":180213139.46463209},{"$f":"IF(C21=0,0,D21/C21)","v":1.0673284287516933},{"$f":"IF(E21=0,\"\",IF($C$15<=E21,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B71","v":"Tariff V - West Zone - Domestic"},{"$f":"C92","v":36972148.229511149},{"$f":"C93","v":39282076.623381026},1.0624775271247586,{"$f":"IF(E22=0,\"\",IF($C$15<=E22,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B101","v":"Tariff V - Adjoining Central Zone - Domestic"},{"$f":"C122","v":904525.77151057159},{"$f":"C123","v":971526.46736841102},1.0740727328818362,"Compliant"]
[null,{"$f":"B131","v":"Tariff V - Adjoining West Zone - Domestic"},{"$f":"C152","v":5463310.2095759334},{"$f":"C153","v":5869701.4983643899},1.0743855415854193,"Compliant"]
[null,{"$f":"B161","v":"Tariff V - Central Zone - Non-domestic"},{"$f":"C182","v":5163055.8387621343},{"$f":"C183","v":5558916.883629011},1.0766718503981523,"Compliant"]
[null,{"$f":"B191","v":"Tariff V - West Zone - Non-domestic"},{"$f":"C212","v":1846152.933046235},{"$f":"C213","v":1970006.5512963785},1.067087409733591,"Compliant"]
[null,{"$f":"B221","v":"Tariff V - Adjoining Central Zone - Non-domestic"},{"$f":"C242","v":23149.994326779281},{"$f":"C243","v":25107.993255843503},1.0845788081597612,"Compliant"]
[null,{"$f":"B251","v":"Tariff V - Adjoining West Zone - Non-domestic"},{"$f":"C272","v":455908.70712617994},{"$f":"C273","v":496054.67561679723},{"$f":"IF(C28=0,0,D28/C28)","v":1.0880570339261062},{"$f":"IF(E28=0,\"\",IF($C$15<=E28,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B281","v":"Tariff M - Central Zone"},{"$f":"C296","v":126429.70707941671},{"$f":"C297","v":134897.8576204167},1.0669791201499876,"Compliant"]
[null,{"$f":"B305","v":"Tariff M - West Zone"},{"$f":"C320","v":65049.489168333326},{"$f":"C321","v":69406.44749583333},1.0669791320916477,"Compliant"]
[null,{"$f":"B329","v":"Tariff M - Adjoining Central Zone"},{"$f":"C344","v":0},{"$f":"C345","v":0},{"$f":"IF(C31=0,0,D31/C31)","v":0},{"$f":"IF(E31=0,\"\",IF($C$15<=E31,\"Breached\",\"Compliant\"))","v":""}]
[null,{"$f":"B353","v":"Tariff M - Adjoining West Zone"},{"$f":"C368","v":0},{"$f":"C369","v":0},0,""]
[null,{"$f":"B377","v":"Tariff D - Central Zone"},{"$f":"C392","v":1230020.3216019997},{"$f":"C393","v":1312405.935569833},{"$f":"IF(C33=0,0,D33/C33)","v":1.0669790673543775},{"$f":"IF(E33=0,\"\",IF($C$15<=E33,\"Breached\",\"Compliant\"))","v":"Compliant"}]
[null,{"$f":"B401","v":"Tariff D - West Zone"},{"$f":"C416","v":420038.00464091671},{"$f":"C417","v":448171.7836857501},1.0669791274455855,"Compliant"]
[null,{"$f":"B425","v":"Tariff D - Adjoining Central Zone"},{"$f":"C440","v":9242.5190233333342},{"$f":"C441","v":9861.5751853333331},1.066979160165876,"Compliant"]
[null,{"$f":"B449","v":"Tariff D - Adjoining West Zone"},{"$f":"C464","v":5332.5446202499998},{"$f":"C465","v":5689.71402425},1.0669791683774519,"Compliant"]
[null,null,{"$f":"SUM(C21:C36)","v":221529430.70882353},{"$f":"SUM(D21:D36)","v":236366963.47112539},1.066977704564249]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B6","v":"Tariff V - Central Zone - Domestic"},1,2,3,4,5,6,7,8,9]
[null,null,1,2,3,4,5,6,7,8,9]
[null,"Distribution tariff","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4"]
[]
[null,{"$f":"\"Existing : \"&'Prop2024-25DistTar'!C6","v":"Existing : Tariff V - Central Zone - Domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$E$8:$E$16,C$42)","v":0.47060000000000002},{"$f":"INDEX('Prop2024-25DistTar'!$E$8:$E$16,D$42)","v":6.4835000000000003},{"$f":"INDEX('Prop2024-25DistTar'!$E$8:$E$16,E$42)","v":3.9077000000000002},{"$f":"INDEX('Prop2024-25DistTar'!$E$8:$E$16,F$42)","v":0.6794},{"$f":"INDEX('Prop2024-25DistTar'!$E$8:$E$16,G$42)","v":0.61029999999999995},{"$f":"INDEX('Prop2024-25DistTar'!$E$8:$E$16,H$42)","v":2.1977000000000002},{"$f":"INDEX('Prop2024-25DistTar'!$E$8:$E$16,I$42)","v":1.7366999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$E$8:$E$16,J$42)","v":0.66559999999999997},{"$f":"INDEX('Prop2024-25DistTar'!$E$8:$E$16,K$42)","v":0.2361}]
[]
[null,{"$f":"\"Proposed : \"&B41","v":"Proposed : Tariff V - Central Zone - Domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$D$8:$D$16,C$41)","v":0.49419999999999997},{"$f":"INDEX('Prop2024-25DistTar'!$D$8:$D$16,D$41)","v":7.0918999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$D$8:$D$16,E$41)","v":4.2744},{"$f":"INDEX('Prop2024-25DistTar'!$D$8:$D$16,F$41)","v":0.74309999999999998},{"$f":"INDEX('Prop2024-25DistTar'!$D$8:$D$16,G$41)","v":0.66759999999999997},{"$f":"INDEX('Prop2024-25DistTar'!$D$8:$D$16,H$41)","v":2.4039000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$8:$D$16,I$41)","v":1.8996999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$D$8:$D$16,J$41)","v":0.72809999999999997},{"$f":"INDEX('Prop2024-25DistTar'!$D$8:$D$16,K$41)","v":0.25829999999999997}]
[]
[null,"Distribution volumes (actual)",{"$f":"C$43","v":"Fixed"},{"$f":"D$43","v":"PkBlk1"},"PkBlk2","PkBlk3","PkBlk4","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4"]
[]
[null,{"$f":"B45","v":"Existing : Tariff V - Central Zone - Domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$16,C$41)","v":596408.54662832047},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$16,D$41)","v":4565205.3161405791},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$16,E$41)","v":2974213.1170785199},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$16,F$41)","v":4297336.9780144291},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$16,G$41)","v":44764.026766459618},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$16,H$41)","v":7981395.1072894596},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$16,I$41)","v":2139042.6618121699},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$16,J$41)","v":1445615.067227999},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$16,K$41)","v":63559.902670351999}]
[]
[null,{"$f":"B47","v":"Proposed : Tariff V - Central Zone - Domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$16,C$41)","v":596408.54662832047},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$16,D$41)","v":4565205.3161405791},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$16,E$41)","v":2974213.1170785199},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$16,F$41)","v":4297336.9780144291},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$16,G$41)","v":44764.026766459618},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$16,H$41)","v":7981395.1072894596},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$16,I$41)","v":2139042.6618121699},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$16,J$41)","v":1445615.067227999},{"$f":"INDEX('Prop2024-25DistTar'!$F$8:$F$16,K$41)","v":63559.902670351999}]
[]
[null,"Distribution revenue",{"$f":"C$43","v":"Fixed"},"PkBlk1","PkBlk2","PkBlk3","PkBlk4","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4"]
[]
[null,{"$f":"B51","v":"Existing : Tariff V - Central Zone - Domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$H$8:$H$16,C$42)","v":102444499.64579998},{"$f":"INDEX('Prop2024-25DistTar'!$H$8:$H$16,D$42)","v":29598508.667197447},{"$f":"INDEX('Prop2024-25DistTar'!$H$8:$H$16,E$42)","v":11622332.597607732},{"$f":"INDEX('Prop2024-25DistTar'!$H$8:$H$16,F$42)","v":2919610.7428630032},{"$f":"INDEX('Prop2024-25DistTar'!$H$8:$H$16,G$42)","v":27319.485535570304},{"$f":"INDEX('Prop2024-25DistTar'!$H$8:$H$16,H$42)","v":17540712.027290046},{"$f":"INDEX('Prop2024-25DistTar'!$H$8:$H$16,I$42)","v":3714875.3907691953},{"$f":"INDEX('Prop2024-25DistTar'!$H$8:$H$16,J$42)","v":962201.38874695613},{"$f":"INDEX('Prop2024-25DistTar'!$H$8:$H$16,K$42)","v":15006.493020470107}]
[]
[null,{"$f":"B53","v":"Proposed : Tariff V - Central Zone - Domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$G$8:$G$16,C$41)","v":107581962.86645633},{"$f":"INDEX('Prop2024-25DistTar'!$G$8:$G$16,D$41)","v":32375979.581537373},{"$f":"INDEX('Prop2024-25DistTar'!$G$8:$G$16,E$41)","v":12712976.547640426},{"$f":"INDEX('Prop2024-25DistTar'!$G$8:$G$16,F$41)","v":3193351.108362522},{"$f":"INDEX('Prop2024-25DistTar'!$G$8:$G$16,G$41)","v":29884.464269288441},{"$f":"INDEX('Prop2024-25DistTar'!$G$8:$G$16,H$41)","v":19186475.698413134},{"$f":"INDEX('Prop2024-25DistTar'!$G$8:$G$16,I$41)","v":4063539.3446445791},{"$f":"INDEX('Prop2024-25DistTar'!$G$8:$G$16,J$41)","v":1052552.3304487059},{"$f":"INDEX('Prop2024-25DistTar'!$G$8:$G$16,K$41)","v":16417.52285975192}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B57","v":"Existing : Tariff V - Central Zone - Domestic"},{"$f":"SUM(C57:K57)","v":168845066.43883038}]
[null,{"$f":"B59","v":"Proposed : Tariff V - Central Zone - Domestic"},{"$f":"SUM(C59:K59)","v":180213139.46463209}]
[]
[null,"Average price movement",{"$f":"IF(C63=0,\"\",C63/C62)","v":1.0673284287516933}]
[]
[null,{"$f":"IF(C65=\"\",\"\",IF(C65<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B28","v":"Tariff V - West Zone - Domestic"},1,2,3,4,5,6,7,8,9]
[null,null,1,2,3,4,5,6,7,8,9]
[null,"Distribution tariff","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4"]
[]
[null,{"$f":"\"Existing : \"&'Prop2024-25DistTar'!C28","v":"Existing : Tariff V - West Zone - Domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$E$30:$E$38,C$42)","v":0.47060000000000002},{"$f":"INDEX('Prop2024-25DistTar'!$E$30:$E$38,D$42)","v":3.427},{"$f":"INDEX('Prop2024-25DistTar'!$E$30:$E$38,E$42)","v":2.4676},{"$f":"INDEX('Prop2024-25DistTar'!$E$30:$E$38,F$42)","v":0.79710000000000003},{"$f":"INDEX('Prop2024-25DistTar'!$E$30:$E$38,G$42)","v":0.76400000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$E$30:$E$38,H$42)","v":1.0596000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$E$30:$E$38,I$42)","v":0.99299999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$E$30:$E$38,J$42)","v":0.56620000000000004},{"$f":"INDEX('Prop2024-25DistTar'!$E$30:$E$38,K$42)","v":0.11169999999999999}]
[]
[null,{"$f":"\"Proposed : \"&B71","v":"Proposed : Tariff V - West Zone - Domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$D$30:$D$38,C$41)","v":0.49419999999999997},{"$f":"INDEX('Prop2024-25DistTar'!$D$30:$D$38,D$41)","v":3.7486000000000002},{"$f":"INDEX('Prop2024-25DistTar'!$D$30:$D$38,E$41)","v":2.6991000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$30:$D$38,F$41)","v":0.87190000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$30:$D$38,G$41)","v":0.8357},{"$f":"INDEX('Prop2024-25DistTar'!$D$30:$D$38,H$41)","v":1.159},{"$f":"INDEX('Prop2024-25DistTar'!$D$30:$D$38,I$41)","v":1.0862000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$30:$D$38,J$41)","v":0.61929999999999996},{"$f":"INDEX('Prop2024-25DistTar'!$D$30:$D$38,K$41)","v":0.1222}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B75","v":"Existing : Tariff V - West Zone - Domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$F$30:$F$38,C$41)","v":154491.290978581},{"$f":"INDEX('Prop2024-25DistTar'!$F$30:$F$38,D$41)","v":1212721.6011625226},{"$f":"INDEX('Prop2024-25DistTar'!$F$30:$F$38,E$41)","v":843491.03506462043},{"$f":"INDEX('Prop2024-25DistTar'!$F$30:$F$38,F$41)","v":1243315.0189067968},{"$f":"INDEX('Prop2024-25DistTar'!$F$30:$F$38,G$41)","v":8182.3593660425468},{"$f":"INDEX('Prop2024-25DistTar'!$F$30:$F$38,H$41)","v":2101963.7438984001},{"$f":"INDEX('Prop2024-25DistTar'!$F$30:$F$38,I$41)","v":687337.42406805512},{"$f":"INDEX('Prop2024-25DistTar'!$F$30:$F$38,J$41)","v":511727.71114503802},{"$f":"INDEX('Prop2024-25DistTar'!$F$30:$F$38,K$41)","v":10147.40188850125}]
[]
[null,{"$f":"B77","v":"Proposed : Tariff V - West Zone - Domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$F$30:$F$38,C$41)","v":154491.290978581},{"$f":"INDEX('Prop2024-25DistTar'!$F$30:$F$38,D$41)","v":1212721.6011625226},{"$f":"INDEX('Prop2024-25DistTar'!$F$30:$F$38,E$41)","v":843491.03506462043},{"$f":"INDEX('Prop2024-25DistTar'!$F$30:$F$38,F$41)","v":1243315.0189067968},{"$f":"INDEX('Prop2024-25DistTar'!$F$30:$F$38,G$41)","v":8182.3593660425468},{"$f":"INDEX('Prop2024-25DistTar'!$F$30:$F$38,H$41)","v":2101963.7438984001},{"$f":"INDEX('Prop2024-25DistTar'!$F$30:$F$38,I$41)","v":687337.42406805512},{"$f":"INDEX('Prop2024-25DistTar'!$F$30:$F$38,J$41)","v":511727.71114503802},{"$f":"INDEX('Prop2024-25DistTar'!$F$30:$F$38,K$41)","v":10147.40188850125}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B81","v":"Existing : Tariff V - West Zone - Domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$H$30:$H$38,C$42)","v":26536814.560099881},{"$f":"INDEX('Prop2024-25DistTar'!$H$30:$H$38,D$42)","v":4155996.9271839648},{"$f":"INDEX('Prop2024-25DistTar'!$H$30:$H$38,E$42)","v":2081398.4781254574},{"$f":"INDEX('Prop2024-25DistTar'!$H$30:$H$38,F$42)","v":991046.40157060779},{"$f":"INDEX('Prop2024-25DistTar'!$H$30:$H$38,G$42)","v":6251.3225556565058},{"$f":"INDEX('Prop2024-25DistTar'!$H$30:$H$38,H$42)","v":2227240.7830347451},{"$f":"INDEX('Prop2024-25DistTar'!$H$30:$H$38,I$42)","v":682526.06209957867},{"$f":"INDEX('Prop2024-25DistTar'!$H$30:$H$38,J$42)","v":289740.23005032056},{"$f":"INDEX('Prop2024-25DistTar'!$H$30:$H$38,K$42)","v":1133.4647909455896}]
[]
[null,{"$f":"B83","v":"Proposed : Tariff V - West Zone - Domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$G$30:$G$38,C$41)","v":27867602.540589377},{"$f":"INDEX('Prop2024-25DistTar'!$G$30:$G$38,D$41)","v":4546008.194117832},{"$f":"INDEX('Prop2024-25DistTar'!$G$30:$G$38,E$41)","v":2276666.6527429172},{"$f":"INDEX('Prop2024-25DistTar'!$G$30:$G$38,F$41)","v":1084046.3649848362},{"$f":"INDEX('Prop2024-25DistTar'!$G$30:$G$38,G$41)","v":6837.997722201756},{"$f":"INDEX('Prop2024-25DistTar'!$G$30:$G$38,H$41)","v":2436175.9791782456},{"$f":"INDEX('Prop2024-25DistTar'!$G$30:$G$38,I$41)","v":746585.91002272151},{"$f":"INDEX('Prop2024-25DistTar'!$G$30:$G$38,J$41)","v":316912.97151212202},{"$f":"INDEX('Prop2024-25DistTar'!$G$30:$G$38,K$41)","v":1240.0125107748529}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B87","v":"Existing : Tariff V - West Zone - Domestic"},{"$f":"SUM(C87:K87)","v":36972148.229511149}]
[null,{"$f":"B89","v":"Proposed : Tariff V - West Zone - Domestic"},{"$f":"SUM(C89:K89)","v":39282076.623381026}]
[]
[null,"Average price movement",{"$f":"IF(C93=0,\"\",C93/C92)","v":1.0624775271247586}]
[]
[null,{"$f":"IF(C95=\"\",\"\",IF(C95<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B50","v":"Tariff V - Adjoining Central Zone - Domestic"},1,2,3,4,5,6,7,8,9]
[null,null,1,2,3,4,5,6,7,8,9]
[null,"Distribution tariff","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4"]
[]
[null,{"$f":"\"Existing : \"&'Prop2024-25DistTar'!C50","v":"Existing : Tariff V - Adjoining Central Zone - Domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$E$52:$E$60,C$42)","v":0.47060000000000002},{"$f":"INDEX('Prop2024-25DistTar'!$E$52:$E$60,D$42)","v":10.617900000000001},{"$f":"INDEX('Prop2024-25DistTar'!$E$52:$E$60,E$42)","v":7.6520000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$E$52:$E$60,F$42)","v":2.7254999999999998},{"$f":"INDEX('Prop2024-25DistTar'!$E$52:$E$60,G$42)","v":2.6135000000000002},{"$f":"INDEX('Prop2024-25DistTar'!$E$52:$E$60,H$42)","v":4.7552000000000003},{"$f":"INDEX('Prop2024-25DistTar'!$E$52:$E$60,I$42)","v":2.7576999999999998},{"$f":"INDEX('Prop2024-25DistTar'!$E$52:$E$60,J$42)","v":2.3995000000000002},{"$f":"INDEX('Prop2024-25DistTar'!$E$52:$E$60,K$42)","v":2.3075999999999999}]
[]
[null,{"$f":"\"Proposed : \"&B101","v":"Proposed : Tariff V - Adjoining Central Zone - Domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$D$52:$D$60,C$41)","v":0.49419999999999997},{"$f":"INDEX('Prop2024-25DistTar'!$D$52:$D$60,D$41)","v":11.6142},{"$f":"INDEX('Prop2024-25DistTar'!$D$52:$D$60,E$41)","v":8.3699999999999992},{"$f":"INDEX('Prop2024-25DistTar'!$D$52:$D$60,F$41)","v":2.9811999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$D$52:$D$60,G$41)","v":2.8586999999999998},{"$f":"INDEX('Prop2024-25DistTar'!$D$52:$D$60,H$41)","v":5.2013999999999996},{"$f":"INDEX('Prop2024-25DistTar'!$D$52:$D$60,I$41)","v":3.0165000000000002},{"$f":"INDEX('Prop2024-25DistTar'!$D$52:$D$60,J$41)","v":2.6246999999999998},{"$f":"INDEX('Prop2024-25DistTar'!$D$52:$D$60,K$41)","v":2.5240999999999998}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B105","v":"Existing : Tariff V - Adjoining Central Zone - Domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$F$52:$F$60,C$41)","v":2381.9923711496203},{"$f":"INDEX('Prop2024-25DistTar'!$F$52:$F$60,D$41)","v":18506.2377637768},{"$f":"INDEX('Prop2024-25DistTar'!$F$52:$F$60,E$41)","v":11369.775471244104},{"$f":"INDEX('Prop2024-25DistTar'!$F$52:$F$60,F$41)","v":14718.789738890708},{"$f":"INDEX('Prop2024-25DistTar'!$F$52:$F$60,G$41)","v":550.6742760882878},{"$f":"INDEX('Prop2024-25DistTar'!$F$52:$F$60,H$41)","v":27233.569032462801},{"$f":"INDEX('Prop2024-25DistTar'!$F$52:$F$60,I$41)","v":8013.407051101849},{"$f":"INDEX('Prop2024-25DistTar'!$F$52:$F$60,J$41)","v":7287.2820233605999},{"$f":"INDEX('Prop2024-25DistTar'!$F$52:$F$60,K$41)","v":534.62389307461001}]
[]
[null,{"$f":"B107","v":"Proposed : Tariff V - Adjoining Central Zone - Domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$F$52:$F$60,C$41)","v":2381.9923711496203},{"$f":"INDEX('Prop2024-25DistTar'!$F$52:$F$60,D$41)","v":18506.2377637768},{"$f":"INDEX('Prop2024-25DistTar'!$F$52:$F$60,E$41)","v":11369.775471244104},{"$f":"INDEX('Prop2024-25DistTar'!$F$52:$F$60,F$41)","v":14718.789738890708},{"$f":"INDEX('Prop2024-25DistTar'!$F$52:$F$60,G$41)","v":550.6742760882878},{"$f":"INDEX('Prop2024-25DistTar'!$F$52:$F$60,H$41)","v":27233.569032462801},{"$f":"INDEX('Prop2024-25DistTar'!$F$52:$F$60,I$41)","v":8013.407051101849},{"$f":"INDEX('Prop2024-25DistTar'!$F$52:$F$60,J$41)","v":7287.2820233605999},{"$f":"INDEX('Prop2024-25DistTar'!$F$52:$F$60,K$41)","v":534.62389307461001}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B111","v":"Existing : Tariff V - Adjoining Central Zone - Domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$H$52:$H$60,C$42)","v":409152.44759999914},{"$f":"INDEX('Prop2024-25DistTar'!$H$52:$H$60,D$42)","v":196497.3819520057},{"$f":"INDEX('Prop2024-25DistTar'!$H$52:$H$60,E$42)","v":87001.521905959889},{"$f":"INDEX('Prop2024-25DistTar'!$H$52:$H$60,F$42)","v":40116.061433346622},{"$f":"INDEX('Prop2024-25DistTar'!$H$52:$H$60,G$42)","v":1439.1872205567402},{"$f":"INDEX('Prop2024-25DistTar'!$H$52:$H$60,H$42)","v":129501.06746316713},{"$f":"INDEX('Prop2024-25DistTar'!$H$52:$H$60,I$42)","v":22098.572624823566},{"$f":"INDEX('Prop2024-25DistTar'!$H$52:$H$60,J$42)","v":17485.833215053761},{"$f":"INDEX('Prop2024-25DistTar'!$H$52:$H$60,K$42)","v":1233.69809565897}]
[]
[null,{"$f":"B113","v":"Proposed : Tariff V - Adjoining Central Zone - Domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$G$52:$G$60,C$41)","v":429670.92988508189},{"$f":"INDEX('Prop2024-25DistTar'!$G$52:$G$60,D$41)","v":214935.14663605651},{"$f":"INDEX('Prop2024-25DistTar'!$G$52:$G$60,E$41)","v":95165.020694313134},{"$f":"INDEX('Prop2024-25DistTar'!$G$52:$G$60,F$41)","v":43879.655969580977},{"$f":"INDEX('Prop2024-25DistTar'!$G$52:$G$60,G$41)","v":1574.2125530535882},{"$f":"INDEX('Prop2024-25DistTar'!$G$52:$G$60,H$41)","v":141652.68596545199},{"$f":"INDEX('Prop2024-25DistTar'!$G$52:$G$60,I$41)","v":24172.442369648728},{"$f":"INDEX('Prop2024-25DistTar'!$G$52:$G$60,J$41)","v":19126.929126714564},{"$f":"INDEX('Prop2024-25DistTar'!$G$52:$G$60,K$41)","v":1349.4441685096231}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B117","v":"Existing : Tariff V - Adjoining Central Zone - Domestic"},{"$f":"SUM(C117:K117)","v":904525.77151057159}]
[null,{"$f":"B119","v":"Proposed : Tariff V - Adjoining Central Zone - Domestic"},{"$f":"SUM(C119:K119)","v":971526.46736841102}]
[]
[null,"Average price movement",{"$f":"IF(C123=0,\"\",C123/C122)","v":1.0740727328818362}]
[]
[null,{"$f":"IF(C125=\"\",\"\",IF(C125<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B72","v":"Tariff V - Adjoining West Zone - Domestic"},1,2,3,4,5,6,7,8,9]
[null,null,1,2,3,4,5,6,7,8,9]
[null,"Distribution tariff","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4"]
[]
[null,{"$f":"\"Existing : \"&'Prop2024-25DistTar'!C72","v":"Existing : Tariff V - Adjoining West Zone - Domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$E$74:$E$82,C$42)","v":0.47060000000000002},{"$f":"INDEX('Prop2024-25DistTar'!$E$74:$E$82,D$42)","v":7.4405000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$E$74:$E$82,E$42)","v":6.2469999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$E$74:$E$82,F$42)","v":3.206},{"$f":"INDEX('Prop2024-25DistTar'!$E$74:$E$82,G$42)","v":2.8755999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$E$74:$E$82,H$42)","v":4.4153000000000002},{"$f":"INDEX('Prop2024-25DistTar'!$E$74:$E$82,I$42)","v":3.3393000000000002},{"$f":"INDEX('Prop2024-25DistTar'!$E$74:$E$82,J$42)","v":2.391},{"$f":"INDEX('Prop2024-25DistTar'!$E$74:$E$82,K$42)","v":2.3161999999999998}]
[]
[null,{"$f":"\"Proposed : \"&B131","v":"Proposed : Tariff V - Adjoining West Zone - Domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$D$74:$D$82,C$41)","v":0.49419999999999997},{"$f":"INDEX('Prop2024-25DistTar'!$D$74:$D$82,D$41)","v":8.1387},{"$f":"INDEX('Prop2024-25DistTar'!$D$74:$D$82,E$41)","v":6.8331999999999997},{"$f":"INDEX('Prop2024-25DistTar'!$D$74:$D$82,F$41)","v":3.5068000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$74:$D$82,G$41)","v":3.1454},{"$f":"INDEX('Prop2024-25DistTar'!$D$74:$D$82,H$41)","v":4.8296000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$74:$D$82,I$41)","v":3.6526000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$74:$D$82,J$41)","v":2.6154000000000002},{"$f":"INDEX('Prop2024-25DistTar'!$D$74:$D$82,K$41)","v":2.5335000000000001}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B135","v":"Existing : Tariff V - Adjoining West Zone - Domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$F$74:$F$82,C$41)","v":14159.74529629905},{"$f":"INDEX('Prop2024-25DistTar'!$F$74:$F$82,D$41)","v":109094.63468345813},{"$f":"INDEX('Prop2024-25DistTar'!$F$74:$F$82,E$41)","v":81697.876124253176},{"$f":"INDEX('Prop2024-25DistTar'!$F$74:$F$82,F$41)","v":144231.3418470521},{"$f":"INDEX('Prop2024-25DistTar'!$F$74:$F$82,G$41)","v":1956.4320952353041},{"$f":"INDEX('Prop2024-25DistTar'!$F$74:$F$82,H$41)","v":192439.42723898351},{"$f":"INDEX('Prop2024-25DistTar'!$F$74:$F$82,I$41)","v":72478.839231593898},{"$f":"INDEX('Prop2024-25DistTar'!$F$74:$F$82,J$41)","v":59898.419395222503},{"$f":"INDEX('Prop2024-25DistTar'!$F$74:$F$82,K$41)","v":2618.3181341996287}]
[]
[null,{"$f":"B137","v":"Proposed : Tariff V - Adjoining West Zone - Domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$F$74:$F$82,C$41)","v":14159.74529629905},{"$f":"INDEX('Prop2024-25DistTar'!$F$74:$F$82,D$41)","v":109094.63468345813},{"$f":"INDEX('Prop2024-25DistTar'!$F$74:$F$82,E$41)","v":81697.876124253176},{"$f":"INDEX('Prop2024-25DistTar'!$F$74:$F$82,F$41)","v":144231.3418470521},{"$f":"INDEX('Prop2024-25DistTar'!$F$74:$F$82,G$41)","v":1956.4320952353041},{"$f":"INDEX('Prop2024-25DistTar'!$F$74:$F$82,H$41)","v":192439.42723898351},{"$f":"INDEX('Prop2024-25DistTar'!$F$74:$F$82,I$41)","v":72478.839231593898},{"$f":"INDEX('Prop2024-25DistTar'!$F$74:$F$82,J$41)","v":59898.419395222503},{"$f":"INDEX('Prop2024-25DistTar'!$F$74:$F$82,K$41)","v":2618.3181341996287}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B141","v":"Existing : Tariff V - Adjoining West Zone - Domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$H$74:$H$82,C$42)","v":2432205.2897999915},{"$f":"INDEX('Prop2024-25DistTar'!$H$74:$H$82,D$42)","v":811718.62936227024},{"$f":"INDEX('Prop2024-25DistTar'!$H$74:$H$82,E$42)","v":510366.63214820961},{"$f":"INDEX('Prop2024-25DistTar'!$H$74:$H$82,F$42)","v":462405.68196164904},{"$f":"INDEX('Prop2024-25DistTar'!$H$74:$H$82,G$42)","v":5625.9161330586403},{"$f":"INDEX('Prop2024-25DistTar'!$H$74:$H$82,H$42)","v":849677.80308828398},{"$f":"INDEX('Prop2024-25DistTar'!$H$74:$H$82,I$42)","v":242028.58784606151},{"$f":"INDEX('Prop2024-25DistTar'!$H$74:$H$82,J$42)","v":143217.12077397702},{"$f":"INDEX('Prop2024-25DistTar'!$H$74:$H$82,K$42)","v":6064.5484624331793}]
[]
[null,{"$f":"B143","v":"Proposed : Tariff V - Adjoining West Zone - Domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$G$74:$G$82,C$41)","v":2554177.3357823114},{"$f":"INDEX('Prop2024-25DistTar'!$G$74:$G$82,D$41)","v":887888.50329826074},{"$f":"INDEX('Prop2024-25DistTar'!$G$74:$G$82,E$41)","v":558257.92713224678},{"$f":"INDEX('Prop2024-25DistTar'!$G$74:$G$82,F$41)","v":505790.4695892423},{"$f":"INDEX('Prop2024-25DistTar'!$G$74:$G$82,G$41)","v":6153.7615123531259},{"$f":"INDEX('Prop2024-25DistTar'!$G$74:$G$82,H$41)","v":929405.4577933948},{"$f":"INDEX('Prop2024-25DistTar'!$G$74:$G$82,I$41)","v":264736.2081773199},{"$f":"INDEX('Prop2024-25DistTar'!$G$74:$G$82,J$41)","v":156658.32608626495},{"$f":"INDEX('Prop2024-25DistTar'!$G$74:$G$82,K$41)","v":6633.5089929947599}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B147","v":"Existing : Tariff V - Adjoining West Zone - Domestic"},{"$f":"SUM(C147:K147)","v":5463310.2095759334}]
[null,{"$f":"B149","v":"Proposed : Tariff V - Adjoining West Zone - Domestic"},{"$f":"SUM(C149:K149)","v":5869701.4983643899}]
[]
[null,"Average price movement",{"$f":"IF(C153=0,\"\",C153/C152)","v":1.0743855415854193}]
[]
[null,{"$f":"IF(C155=\"\",\"\",IF(C155<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B17","v":"Tariff V - Central Zone - Non-domestic"},1,2,3,4,5]
[null,null,1,2,3,4,5,6,7,8,9]
[null,"Distribution tariff","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4"]
[]
[null,{"$f":"\"Existing : \"&'Prop2024-25DistTar'!C17","v":"Existing : Tariff V - Central Zone - Non-domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$E$19:$E$27,C$42)","v":0.49130000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$E$19:$E$27,D$42)","v":1.1679999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$E$19:$E$27,E$42)","v":1.1127},{"$f":"INDEX('Prop2024-25DistTar'!$E$19:$E$27,F$42)","v":1.0013000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$E$19:$E$27,G$42)","v":0.76429999999999998},{"$f":"INDEX('Prop2024-25DistTar'!$E$19:$E$27,H$42)","v":1.1067},{"$f":"INDEX('Prop2024-25DistTar'!$E$19:$E$27,I$42)","v":0.77429999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$E$19:$E$27,J$42)","v":0.63749999999999996},{"$f":"INDEX('Prop2024-25DistTar'!$E$19:$E$27,K$42)","v":0.61809999999999998}]
[]
[null,{"$f":"\"Proposed : \"&B161","v":"Proposed : Tariff V - Central Zone - Non-domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$D$19:$D$27,C$41)","v":0.51600000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$19:$D$27,D$41)","v":1.2776000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$19:$D$27,E$41)","v":1.2171000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$19:$D$27,F$41)","v":1.0952999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$D$19:$D$27,G$41)","v":0.83599999999999997},{"$f":"INDEX('Prop2024-25DistTar'!$D$19:$D$27,H$41)","v":1.2104999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$D$19:$D$27,I$41)","v":0.84699999999999998},{"$f":"INDEX('Prop2024-25DistTar'!$D$19:$D$27,J$41)","v":0.69730000000000003},{"$f":"INDEX('Prop2024-25DistTar'!$D$19:$D$27,K$41)","v":0.67610000000000003}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B165","v":"Existing : Tariff V - Central Zone - Non-domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$F$19:$F$27,C$41)","v":11341.701067130802},{"$f":"INDEX('Prop2024-25DistTar'!$F$19:$F$27,D$41)","v":77701.752103056278},{"$f":"INDEX('Prop2024-25DistTar'!$F$19:$F$27,E$41)","v":62502.956028340377},{"$f":"INDEX('Prop2024-25DistTar'!$F$19:$F$27,F$41)","v":386317.66805475706},{"$f":"INDEX('Prop2024-25DistTar'!$F$19:$F$27,G$41)","v":1056407.4187933807},{"$f":"INDEX('Prop2024-25DistTar'!$F$19:$F$27,H$41)","v":168895.74330064782},{"$f":"INDEX('Prop2024-25DistTar'!$F$19:$F$27,I$41)","v":123143.75360101571},{"$f":"INDEX('Prop2024-25DistTar'!$F$19:$F$27,J$41)","v":749643.25975939899},{"$f":"INDEX('Prop2024-25DistTar'!$F$19:$F$27,K$41)","v":1641338.7854596544}]
[]
[null,{"$f":"B167","v":"Proposed : Tariff V - Central Zone - Non-domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$F$19:$F$27,C$41)","v":11341.701067130802},{"$f":"INDEX('Prop2024-25DistTar'!$F$19:$F$27,D$41)","v":77701.752103056278},{"$f":"INDEX('Prop2024-25DistTar'!$F$19:$F$27,E$41)","v":62502.956028340377},{"$f":"INDEX('Prop2024-25DistTar'!$F$19:$F$27,F$41)","v":386317.66805475706},{"$f":"INDEX('Prop2024-25DistTar'!$F$19:$F$27,G$41)","v":1056407.4187933807},{"$f":"INDEX('Prop2024-25DistTar'!$F$19:$F$27,H$41)","v":168895.74330064782},{"$f":"INDEX('Prop2024-25DistTar'!$F$19:$F$27,I$41)","v":123143.75360101571},{"$f":"INDEX('Prop2024-25DistTar'!$F$19:$F$27,J$41)","v":749643.25975939899},{"$f":"INDEX('Prop2024-25DistTar'!$F$19:$F$27,K$41)","v":1641338.7854596544}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B171","v":"Existing : Tariff V - Central Zone - Non-domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$H$19:$H$27,C$42)","v":2033844.8730126976},{"$f":"INDEX('Prop2024-25DistTar'!$H$19:$H$27,D$42)","v":90755.646456369723},{"$f":"INDEX('Prop2024-25DistTar'!$H$19:$H$27,E$42)","v":69547.039172734338},{"$f":"INDEX('Prop2024-25DistTar'!$H$19:$H$27,F$42)","v":386819.88102322828},{"$f":"INDEX('Prop2024-25DistTar'!$H$19:$H$27,G$42)","v":807412.19018378085},{"$f":"INDEX('Prop2024-25DistTar'!$H$19:$H$27,H$42)","v":186916.91911082694},{"$f":"INDEX('Prop2024-25DistTar'!$H$19:$H$27,I$42)","v":95350.20841326646},{"$f":"INDEX('Prop2024-25DistTar'!$H$19:$H$27,J$42)","v":477897.57809661684},{"$f":"INDEX('Prop2024-25DistTar'!$H$19:$H$27,K$42)","v":1014511.5032926124}]
[]
[null,{"$f":"B173","v":"Proposed : Tariff V - Central Zone - Non-domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$G$19:$G$27,C$41)","v":2136095.9789834153},{"$f":"INDEX('Prop2024-25DistTar'!$G$19:$G$27,D$41)","v":99271.75848686471},{"$f":"INDEX('Prop2024-25DistTar'!$G$19:$G$27,E$41)","v":76072.347782093071},{"$f":"INDEX('Prop2024-25DistTar'!$G$19:$G$27,F$41)","v":423133.74182037538},{"$f":"INDEX('Prop2024-25DistTar'!$G$19:$G$27,G$41)","v":883156.60211126623},{"$f":"INDEX('Prop2024-25DistTar'!$G$19:$G$27,H$41)","v":204448.29726543417},{"$f":"INDEX('Prop2024-25DistTar'!$G$19:$G$27,I$41)","v":104302.75930006029},{"$f":"INDEX('Prop2024-25DistTar'!$G$19:$G$27,J$41)","v":522726.24503022892},{"$f":"INDEX('Prop2024-25DistTar'!$G$19:$G$27,K$41)","v":1109709.1528492724}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B177","v":"Existing : Tariff V - Central Zone - Non-domestic"},{"$f":"SUM(C177:K177)","v":5163055.8387621343}]
[null,{"$f":"B179","v":"Proposed : Tariff V - Central Zone - Non-domestic"},{"$f":"SUM(C179:K179)","v":5558916.883629011}]
[]
[null,"Average price movement",{"$f":"IF(C183=0,\"\",C183/C182)","v":1.0766718503981523}]
[]
[null,{"$f":"IF(C185=\"\",\"\",IF(C185<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B39","v":"Tariff V - West Zone - Non-domestic"},1,2,3,4,5]
[null,null,1,2,3,4,5,6,7,8,9]
[null,"Distribution tariff","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4"]
[]
[null,{"$f":"\"Existing : \"&'Prop2024-25DistTar'!C39","v":"Existing : Tariff V - West Zone - Non-domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$E$41:$E$49,C$42)","v":0.49130000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$E$41:$E$49,D$42)","v":1.7848999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$E$41:$E$49,E$42)","v":1.5044},{"$f":"INDEX('Prop2024-25DistTar'!$E$41:$E$49,F$42)","v":0.9294},{"$f":"INDEX('Prop2024-25DistTar'!$E$41:$E$49,G$42)","v":0.34849999999999998},{"$f":"INDEX('Prop2024-25DistTar'!$E$41:$E$49,H$42)","v":0.82709999999999995},{"$f":"INDEX('Prop2024-25DistTar'!$E$41:$E$49,I$42)","v":0.69679999999999997},{"$f":"INDEX('Prop2024-25DistTar'!$E$41:$E$49,J$42)","v":0.3357},{"$f":"INDEX('Prop2024-25DistTar'!$E$41:$E$49,K$42)","v":0.24970000000000001}]
[]
[null,{"$f":"\"Proposed : \"&B191","v":"Proposed : Tariff V - West Zone - Non-domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$D$41:$D$49,C$41)","v":0.51600000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$41:$D$49,D$41)","v":1.9523999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$D$41:$D$49,E$41)","v":1.6456},{"$f":"INDEX('Prop2024-25DistTar'!$D$41:$D$49,F$41)","v":1.0165999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$D$41:$D$49,G$41)","v":0.38119999999999998},{"$f":"INDEX('Prop2024-25DistTar'!$D$41:$D$49,H$41)","v":0.90469999999999995},{"$f":"INDEX('Prop2024-25DistTar'!$D$41:$D$49,I$41)","v":0.76219999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$D$41:$D$49,J$41)","v":0.36720000000000003},{"$f":"INDEX('Prop2024-25DistTar'!$D$41:$D$49,K$41)","v":0.27310000000000001}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B195","v":"Existing : Tariff V - West Zone - Non-domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$F$41:$F$49,C$41)","v":6319.5363959736605},{"$f":"INDEX('Prop2024-25DistTar'!$F$41:$F$49,D$41)","v":39559.947559392487},{"$f":"INDEX('Prop2024-25DistTar'!$F$41:$F$49,E$41)","v":30232.375972024089},{"$f":"INDEX('Prop2024-25DistTar'!$F$41:$F$49,F$41)","v":165603.82219958378},{"$f":"INDEX('Prop2024-25DistTar'!$F$41:$F$49,G$41)","v":364941.06599113869},{"$f":"INDEX('Prop2024-25DistTar'!$F$41:$F$49,H$41)","v":78897.447668684603},{"$f":"INDEX('Prop2024-25DistTar'!$F$41:$F$49,I$41)","v":52272.503506173598},{"$f":"INDEX('Prop2024-25DistTar'!$F$41:$F$49,J$41)","v":277192.26564201567},{"$f":"INDEX('Prop2024-25DistTar'!$F$41:$F$49,K$41)","v":484525.17004118394}]
[]
[null,{"$f":"B197","v":"Proposed : Tariff V - West Zone - Non-domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$F$41:$F$49,C$41)","v":6319.5363959736605},{"$f":"INDEX('Prop2024-25DistTar'!$F$41:$F$49,D$41)","v":39559.947559392487},{"$f":"INDEX('Prop2024-25DistTar'!$F$41:$F$49,E$41)","v":30232.375972024089},{"$f":"INDEX('Prop2024-25DistTar'!$F$41:$F$49,F$41)","v":165603.82219958378},{"$f":"INDEX('Prop2024-25DistTar'!$F$41:$F$49,G$41)","v":364941.06599113869},{"$f":"INDEX('Prop2024-25DistTar'!$F$41:$F$49,H$41)","v":78897.447668684603},{"$f":"INDEX('Prop2024-25DistTar'!$F$41:$F$49,I$41)","v":52272.503506173598},{"$f":"INDEX('Prop2024-25DistTar'!$F$41:$F$49,J$41)","v":277192.26564201567},{"$f":"INDEX('Prop2024-25DistTar'!$F$41:$F$49,K$41)","v":484525.17004118394}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B201","v":"Existing : Tariff V - West Zone - Non-domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$H$41:$H$49,C$42)","v":1133247.7044397788},{"$f":"INDEX('Prop2024-25DistTar'!$H$41:$H$49,D$42)","v":70610.550398759646},{"$f":"INDEX('Prop2024-25DistTar'!$H$41:$H$49,E$42)","v":45481.586412313038},{"$f":"INDEX('Prop2024-25DistTar'!$H$41:$H$49,F$42)","v":153912.19235229318},{"$f":"INDEX('Prop2024-25DistTar'!$H$41:$H$49,G$42)","v":127181.96149791182},{"$f":"INDEX('Prop2024-25DistTar'!$H$41:$H$49,H$42)","v":65256.078966769033},{"$f":"INDEX('Prop2024-25DistTar'!$H$41:$H$49,I$42)","v":36423.480443101762},{"$f":"INDEX('Prop2024-25DistTar'!$H$41:$H$49,J$42)","v":93053.443576024656},{"$f":"INDEX('Prop2024-25DistTar'!$H$41:$H$49,K$42)","v":120985.93495928364}]
[]
[null,{"$f":"B203","v":"Proposed : Tariff V - West Zone - Non-domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$G$41:$G$49,C$41)","v":1190221.4848176793},{"$f":"INDEX('Prop2024-25DistTar'!$G$41:$G$49,D$41)","v":77236.841614957884},{"$f":"INDEX('Prop2024-25DistTar'!$G$41:$G$49,E$41)","v":49750.397899562842},{"$f":"INDEX('Prop2024-25DistTar'!$G$41:$G$49,F$41)","v":168352.84564809687},{"$f":"INDEX('Prop2024-25DistTar'!$G$41:$G$49,G$41)","v":139115.53435582205},{"$f":"INDEX('Prop2024-25DistTar'!$G$41:$G$49,H$41)","v":71378.520905858953},{"$f":"INDEX('Prop2024-25DistTar'!$G$41:$G$49,I$41)","v":39842.102172405517},{"$f":"INDEX('Prop2024-25DistTar'!$G$41:$G$49,J$41)","v":101784.99994374816},{"$f":"INDEX('Prop2024-25DistTar'!$G$41:$G$49,K$41)","v":132323.82393824734}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B207","v":"Existing : Tariff V - West Zone - Non-domestic"},{"$f":"SUM(C207:K207)","v":1846152.933046235}]
[null,{"$f":"B209","v":"Proposed : Tariff V - West Zone - Non-domestic"},{"$f":"SUM(C209:K209)","v":1970006.5512963785}]
[]
[null,"Average price movement",{"$f":"IF(C213=0,\"\",C213/C212)","v":1.067087409733591}]
[]
[null,{"$f":"IF(C215=\"\",\"\",IF(C215<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B61","v":"Tariff V - Adjoining Central Zone - Non-domestic"},1,2,3,4,5]
[null,null,1,2,3,4,5,6,7,8,9]
[null,"Distribution tariff","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4"]
[]
[null,{"$f":"\"Existing : \"&'Prop2024-25DistTar'!C61","v":"Existing : Tariff V - Adjoining Central Zone - Non-domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$E$63:$E$71,C$42)","v":0.49130000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$E$63:$E$71,D$42)","v":4.3657000000000004},{"$f":"INDEX('Prop2024-25DistTar'!$E$63:$E$71,E$42)","v":4.1601999999999997},{"$f":"INDEX('Prop2024-25DistTar'!$E$63:$E$71,F$42)","v":3.9327000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$E$63:$E$71,G$42)","v":3.7143999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$E$63:$E$71,H$42)","v":4.0186000000000002},{"$f":"INDEX('Prop2024-25DistTar'!$E$63:$E$71,I$42)","v":3.8576000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$E$63:$E$71,J$42)","v":3.7381000000000002},{"$f":"INDEX('Prop2024-25DistTar'!$E$63:$E$71,K$42)","v":3.6467999999999998}]
[]
[null,{"$f":"\"Proposed : \"&B221","v":"Proposed : Tariff V - Adjoining Central Zone - Non-domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$D$63:$D$71,C$41)","v":0.51600000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$63:$D$71,D$41)","v":4.7752999999999997},{"$f":"INDEX('Prop2024-25DistTar'!$D$63:$D$71,E$41)","v":4.5506000000000002},{"$f":"INDEX('Prop2024-25DistTar'!$D$63:$D$71,F$41)","v":4.3017000000000003},{"$f":"INDEX('Prop2024-25DistTar'!$D$63:$D$71,G$41)","v":4.0629},{"$f":"INDEX('Prop2024-25DistTar'!$D$63:$D$71,H$41)","v":4.3956999999999997},{"$f":"INDEX('Prop2024-25DistTar'!$D$63:$D$71,I$41)","v":4.2195999999999998},{"$f":"INDEX('Prop2024-25DistTar'!$D$63:$D$71,J$41)","v":4.0888999999999998},{"$f":"INDEX('Prop2024-25DistTar'!$D$63:$D$71,K$41)","v":3.9889999999999999}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B225","v":"Existing : Tariff V - Adjoining Central Zone - Non-domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$F$63:$F$71,C$41)","v":27.435094225384049},{"$f":"INDEX('Prop2024-25DistTar'!$F$63:$F$71,D$41)","v":237.17538108198565},{"$f":"INDEX('Prop2024-25DistTar'!$F$63:$F$71,E$41)","v":177.5182640420955},{"$f":"INDEX('Prop2024-25DistTar'!$F$63:$F$71,F$41)","v":935.73502785967003},{"$f":"INDEX('Prop2024-25DistTar'!$F$63:$F$71,G$41)","v":340.2308270162448},{"$f":"INDEX('Prop2024-25DistTar'!$F$63:$F$71,H$41)","v":413.170192327812},{"$f":"INDEX('Prop2024-25DistTar'!$F$63:$F$71,I$41)","v":259.74139027897348},{"$f":"INDEX('Prop2024-25DistTar'!$F$63:$F$71,J$41)","v":1633.7224380146479},{"$f":"INDEX('Prop2024-25DistTar'!$F$63:$F$71,K$41)","v":752.21597937855404}]
[]
[null,{"$f":"B227","v":"Proposed : Tariff V - Adjoining Central Zone - Non-domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$F$63:$F$71,C$41)","v":27.435094225384049},{"$f":"INDEX('Prop2024-25DistTar'!$F$63:$F$71,D$41)","v":237.17538108198565},{"$f":"INDEX('Prop2024-25DistTar'!$F$63:$F$71,E$41)","v":177.5182640420955},{"$f":"INDEX('Prop2024-25DistTar'!$F$63:$F$71,F$41)","v":935.73502785967003},{"$f":"INDEX('Prop2024-25DistTar'!$F$63:$F$71,G$41)","v":340.2308270162448},{"$f":"INDEX('Prop2024-25DistTar'!$F$63:$F$71,H$41)","v":413.170192327812},{"$f":"INDEX('Prop2024-25DistTar'!$F$63:$F$71,I$41)","v":259.74139027897348},{"$f":"INDEX('Prop2024-25DistTar'!$F$63:$F$71,J$41)","v":1633.7224380146479},{"$f":"INDEX('Prop2024-25DistTar'!$F$63:$F$71,K$41)","v":752.21597937855404}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B231","v":"Existing : Tariff V - Adjoining Central Zone - Non-domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$H$63:$H$71,C$42)","v":4919.7845544198826},{"$f":"INDEX('Prop2024-25DistTar'!$H$63:$H$71,D$42)","v":1035.4365611896249},{"$f":"INDEX('Prop2024-25DistTar'!$H$63:$H$71,E$42)","v":738.51148206792561},{"$f":"INDEX('Prop2024-25DistTar'!$H$63:$H$71,F$42)","v":3679.9651440637244},{"$f":"INDEX('Prop2024-25DistTar'!$H$63:$H$71,G$42)","v":1263.7533838691397},{"$f":"INDEX('Prop2024-25DistTar'!$H$63:$H$71,H$42)","v":1660.3657348885454},{"$f":"INDEX('Prop2024-25DistTar'!$H$63:$H$71,I$42)","v":1001.9783871401681},{"$f":"INDEX('Prop2024-25DistTar'!$H$63:$H$71,J$42)","v":6107.0178455425557},{"$f":"INDEX('Prop2024-25DistTar'!$H$63:$H$71,K$42)","v":2743.1812335977106}]
[]
[null,{"$f":"B233","v":"Proposed : Tariff V - Adjoining Central Zone - Non-domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$G$63:$G$71,C$41)","v":5167.1256464088319},{"$f":"INDEX('Prop2024-25DistTar'!$G$63:$G$71,D$41)","v":1132.5835972808061},{"$f":"INDEX('Prop2024-25DistTar'!$G$63:$G$71,E$41)","v":807.81461234995982},{"$f":"INDEX('Prop2024-25DistTar'!$G$63:$G$71,F$41)","v":4025.2513693439428},{"$f":"INDEX('Prop2024-25DistTar'!$G$63:$G$71,G$41)","v":1382.323827084301},{"$f":"INDEX('Prop2024-25DistTar'!$G$63:$G$71,H$41)","v":1816.1722144153632},{"$f":"INDEX('Prop2024-25DistTar'!$G$63:$G$71,I$41)","v":1096.0047704211565},{"$f":"INDEX('Prop2024-25DistTar'!$G$63:$G$71,J$41)","v":6680.1276767980935},{"$f":"INDEX('Prop2024-25DistTar'!$G$63:$G$71,K$41)","v":3000.589541741052}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B237","v":"Existing : Tariff V - Adjoining Central Zone - Non-domestic"},{"$f":"SUM(C237:K237)","v":23149.994326779281}]
[null,{"$f":"B239","v":"Proposed : Tariff V - Adjoining Central Zone - Non-domestic"},{"$f":"SUM(C239:K239)","v":25107.993255843503}]
[]
[null,"Average price movement",{"$f":"IF(C243=0,\"\",C243/C242)","v":1.0845788081597612}]
[]
[null,{"$f":"IF(C245=\"\",\"\",IF(C245<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B83","v":"Tariff V - Adjoining West Zone - Non-domestic"},1,2,3,4,5]
[null,null,1,2,3,4,5,6,7,8,9]
[null,"Distribution tariff","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","OPkBlk1","OPkBlk2","OPkBlk3","OPkBlk4"]
[]
[null,{"$f":"\"Existing : \"&'Prop2024-25DistTar'!C83","v":"Existing : Tariff V - Adjoining West Zone - Non-domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$E$85:$E$93,C$42)","v":0.49130000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$E$85:$E$93,D$42)","v":5.3872999999999998},{"$f":"INDEX('Prop2024-25DistTar'!$E$85:$E$93,E$42)","v":5.0568999999999997},{"$f":"INDEX('Prop2024-25DistTar'!$E$85:$E$93,F$42)","v":4.3433999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$E$85:$E$93,G$42)","v":3.8178999999999998},{"$f":"INDEX('Prop2024-25DistTar'!$E$85:$E$93,H$42)","v":4.1416000000000004},{"$f":"INDEX('Prop2024-25DistTar'!$E$85:$E$93,I$42)","v":3.9405999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$E$85:$E$93,J$42)","v":3.4449999999999998},{"$f":"INDEX('Prop2024-25DistTar'!$E$85:$E$93,K$42)","v":3.2806000000000002}]
[]
[null,{"$f":"\"Proposed : \"&B251","v":"Proposed : Tariff V - Adjoining West Zone - Non-domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$D$85:$D$93,C$41)","v":0.51600000000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$85:$D$93,D$41)","v":5.8928000000000003},{"$f":"INDEX('Prop2024-25DistTar'!$D$85:$D$93,E$41)","v":5.5313999999999997},{"$f":"INDEX('Prop2024-25DistTar'!$D$85:$D$93,F$41)","v":4.7510000000000003},{"$f":"INDEX('Prop2024-25DistTar'!$D$85:$D$93,G$41)","v":4.1760999999999999},{"$f":"INDEX('Prop2024-25DistTar'!$D$85:$D$93,H$41)","v":4.5301999999999998},{"$f":"INDEX('Prop2024-25DistTar'!$D$85:$D$93,I$41)","v":4.3103999999999996},{"$f":"INDEX('Prop2024-25DistTar'!$D$85:$D$93,J$41)","v":3.7683},{"$f":"INDEX('Prop2024-25DistTar'!$D$85:$D$93,K$41)","v":3.5884}]
[]
[null,"Distribution volumes (actual)","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B255","v":"Existing : Tariff V - Adjoining West Zone - Non-domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$F$85:$F$93,C$41)","v":337.07190645576247},{"$f":"INDEX('Prop2024-25DistTar'!$F$85:$F$93,D$41)","v":2557.8576959599986},{"$f":"INDEX('Prop2024-25DistTar'!$F$85:$F$93,E$41)","v":1990.2674093125215},{"$f":"INDEX('Prop2024-25DistTar'!$F$85:$F$93,F$41)","v":11676.909159171528},{"$f":"INDEX('Prop2024-25DistTar'!$F$85:$F$93,G$41)","v":23760.919721035876},{"$f":"INDEX('Prop2024-25DistTar'!$F$85:$F$93,H$41)","v":5620.0499890956398},{"$f":"INDEX('Prop2024-25DistTar'!$F$85:$F$93,I$41)","v":4061.7421177545439},{"$f":"INDEX('Prop2024-25DistTar'!$F$85:$F$93,J$41)","v":22996.021450020431},{"$f":"INDEX('Prop2024-25DistTar'!$F$85:$F$93,K$41)","v":34043.049882669286}]
[]
[null,{"$f":"B257","v":"Proposed : Tariff V - Adjoining West Zone - Non-domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$F$85:$F$93,C$41)","v":337.07190645576247},{"$f":"INDEX('Prop2024-25DistTar'!$F$85:$F$93,D$41)","v":2557.8576959599986},{"$f":"INDEX('Prop2024-25DistTar'!$F$85:$F$93,E$41)","v":1990.2674093125215},{"$f":"INDEX('Prop2024-25DistTar'!$F$85:$F$93,F$41)","v":11676.909159171528},{"$f":"INDEX('Prop2024-25DistTar'!$F$85:$F$93,G$41)","v":23760.919721035876},{"$f":"INDEX('Prop2024-25DistTar'!$F$85:$F$93,H$41)","v":5620.0499890956398},{"$f":"INDEX('Prop2024-25DistTar'!$F$85:$F$93,I$41)","v":4061.7421177545439},{"$f":"INDEX('Prop2024-25DistTar'!$F$85:$F$93,J$41)","v":22996.021450020431},{"$f":"INDEX('Prop2024-25DistTar'!$F$85:$F$93,K$41)","v":34043.049882669286}]
[]
[null,"Distribution revenue","Fixed","PkBlk1","PkBlk2","PkBlk3","PkBlk4","PkBlk5","Shd1Blk1","Shd1Blk2","Shd1Blk3"]
[]
[null,{"$f":"B261","v":"Existing : Tariff V - Adjoining West Zone - Non-domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$H$85:$H$93,C$42)","v":60445.251089226382},{"$f":"INDEX('Prop2024-25DistTar'!$H$85:$H$93,D$42)","v":13779.9467654453},{"$f":"INDEX('Prop2024-25DistTar'!$H$85:$H$93,E$42)","v":10064.58326215249},{"$f":"INDEX('Prop2024-25DistTar'!$H$85:$H$93,F$42)","v":50717.487241945615},{"$f":"INDEX('Prop2024-25DistTar'!$H$85:$H$93,G$42)","v":90716.81540294287},{"$f":"INDEX('Prop2024-25DistTar'!$H$85:$H$93,H$42)","v":23275.999034838504},{"$f":"INDEX('Prop2024-25DistTar'!$H$85:$H$93,I$42)","v":16005.700989223555},{"$f":"INDEX('Prop2024-25DistTar'!$H$85:$H$93,J$42)","v":79221.293895320385},{"$f":"INDEX('Prop2024-25DistTar'!$H$85:$H$93,K$42)","v":111681.62944508487}]
[]
[null,{"$f":"B263","v":"Proposed : Tariff V - Adjoining West Zone - Non-domestic"},{"$f":"INDEX('Prop2024-25DistTar'!$G$85:$G$93,C$41)","v":63484.122861878299},{"$f":"INDEX('Prop2024-25DistTar'!$G$85:$G$93,D$41)","v":15072.94383075308},{"$f":"INDEX('Prop2024-25DistTar'!$G$85:$G$93,E$41)","v":11008.96514787128},{"$f":"INDEX('Prop2024-25DistTar'!$G$85:$G$93,F$41)","v":55476.99541522393},{"$f":"INDEX('Prop2024-25DistTar'!$G$85:$G$93,G$41)","v":99227.976847017926},{"$f":"INDEX('Prop2024-25DistTar'!$G$85:$G$93,H$41)","v":25459.950460601067},{"$f":"INDEX('Prop2024-25DistTar'!$G$85:$G$93,I$41)","v":17507.733224369185},{"$f":"INDEX('Prop2024-25DistTar'!$G$85:$G$93,J$41)","v":86655.907630111993},{"$f":"INDEX('Prop2024-25DistTar'!$G$85:$G$93,K$41)","v":122160.08019897046}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B267","v":"Existing : Tariff V - Adjoining West Zone - Non-domestic"},{"$f":"SUM(C267:K267)","v":455908.70712617994}]
[null,{"$f":"B269","v":"Proposed : Tariff V - Adjoining West Zone - Non-domestic"},{"$f":"SUM(C269:K269)","v":496054.67561679723}]
[]
[null,"Average price movement",{"$f":"IF(C273=0,\"\",C273/C272)","v":1.0880570339261062}]
[]
[null,{"$f":"IF(C275=\"\",\"\",IF(C275<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B95","v":"Tariff M - Central Zone"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&'Prop2024-25DistTar'!C95","v":"Existing: Tariff M - Central Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$E$96:$E$98,C282)","v":752.29870000000005},{"$f":"INDEX('Prop2024-25DistTar'!$E$96:$E$98,D282)","v":716.5018},{"$f":"INDEX('Prop2024-25DistTar'!$E$96:$E$98,E282)","v":149.6071}]
[null,{"$f":"\"Proposed: \"&B281","v":"Proposed: Tariff M - Central Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$D$96:$D$98,C282)","v":802.68700000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$96:$D$98,D282)","v":764.49249999999995},{"$f":"INDEX('Prop2024-25DistTar'!$D$96:$D$98,E282)","v":159.6277}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B284","v":"Existing: Tariff M - Central Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$F$96:$F$98,C$282)","v":150.06750000000005},{"$f":"INDEX('Prop2024-25DistTar'!$F$96:$F$98,D$282)","v":18.889166666666664},{"$f":"INDEX('Prop2024-25DistTar'!$F$96:$F$98,E$282)","v":0}]
[null,{"$f":"B285","v":"Proposed: Tariff M - Central Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$F$96:$F$98,C$282)","v":150.06750000000005},{"$f":"INDEX('Prop2024-25DistTar'!$F$96:$F$98,D$282)","v":18.889166666666664},{"$f":"INDEX('Prop2024-25DistTar'!$F$96:$F$98,E$282)","v":0}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B288","v":"Existing: Tariff M - Central Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$H$96:$H$98,C282)","v":112895.58516225005},{"$f":"INDEX('Prop2024-25DistTar'!$H$96:$H$98,D282)","v":13534.121917166665},{"$f":"INDEX('Prop2024-25DistTar'!$H$96:$H$98,E282)","v":0}]
[null,{"$f":"B289","v":"Proposed: Tariff M - Central Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$G$96:$G$98,C282)","v":120457.23137250004},{"$f":"INDEX('Prop2024-25DistTar'!$G$96:$G$98,D282)","v":14440.626247916663},{"$f":"INDEX('Prop2024-25DistTar'!$G$96:$G$98,E282)","v":0}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B292","v":"Existing: Tariff M - Central Zone"},{"$f":"SUM(C292:E292)","v":126429.70707941671}]
[null,{"$f":"B293","v":"Proposed: Tariff M - Central Zone"},{"$f":"SUM(C293:E293)","v":134897.8576204167}]
[]
[null,"Average price movement",{"$f":"IF(C297=0,\"\",C297/C296)","v":1.0669791201499876}]
[]
[null,{"$f":"IF(C299=\"\",\"\",IF(C299<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B100","v":"Tariff M - West Zone"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&'Prop2024-25DistTar'!C100","v":"Existing: Tariff M - West Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$E$101:$E$103,C306)","v":752.29870000000005},{"$f":"INDEX('Prop2024-25DistTar'!$E$101:$E$103,D306)","v":716.5018},{"$f":"INDEX('Prop2024-25DistTar'!$E$101:$E$103,E306)","v":149.6071}]
[null,{"$f":"\"Proposed: \"&B305","v":"Proposed: Tariff M - West Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$D$101:$D$103,C306)","v":802.68700000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$101:$D$103,D306)","v":764.49249999999995},{"$f":"INDEX('Prop2024-25DistTar'!$D$101:$D$103,E306)","v":159.6277}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B308","v":"Existing: Tariff M - West Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$F$101:$F$103,C$282)","v":60.633333333333326},{"$f":"INDEX('Prop2024-25DistTar'!$F$101:$F$103,D$282)","v":27.125000000000004},{"$f":"INDEX('Prop2024-25DistTar'!$F$101:$F$103,E$282)","v":0}]
[null,{"$f":"B309","v":"Proposed: Tariff M - West Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$F$101:$F$103,C$282)","v":60.633333333333326},{"$f":"INDEX('Prop2024-25DistTar'!$F$101:$F$103,D$282)","v":27.125000000000004},{"$f":"INDEX('Prop2024-25DistTar'!$F$101:$F$103,E$282)","v":0}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B312","v":"Existing: Tariff M - West Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$H$101:$H$103,C306)","v":45614.377843333328},{"$f":"INDEX('Prop2024-25DistTar'!$H$101:$H$103,D306)","v":19435.111325000002},{"$f":"INDEX('Prop2024-25DistTar'!$H$101:$H$103,E306)","v":0}]
[null,{"$f":"B313","v":"Proposed: Tariff M - West Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$G$101:$G$103,C306)","v":48669.588433333331},{"$f":"INDEX('Prop2024-25DistTar'!$G$101:$G$103,D306)","v":20736.8590625},{"$f":"INDEX('Prop2024-25DistTar'!$G$101:$G$103,E306)","v":0}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B316","v":"Existing: Tariff M - West Zone"},{"$f":"SUM(C316:E316)","v":65049.489168333326}]
[null,{"$f":"B317","v":"Proposed: Tariff M - West Zone"},{"$f":"SUM(C317:E317)","v":69406.44749583333}]
[]
[null,"Average price movement",{"$f":"IF(C321=0,\"\",C321/C320)","v":1.0669791320916477}]
[]
[null,{"$f":"IF(C323=\"\",\"\",IF(C323<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B105","v":"Tariff M - Adjoining Central Zone"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&'Prop2024-25DistTar'!C105","v":"Existing: Tariff M - Adjoining Central Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$E$106:$E$108,C330)","v":752.29870000000005},{"$f":"INDEX('Prop2024-25DistTar'!$E$106:$E$108,D330)","v":716.5018},{"$f":"INDEX('Prop2024-25DistTar'!$E$106:$E$108,E330)","v":149.6071}]
[null,{"$f":"\"Proposed: \"&B329","v":"Proposed: Tariff M - Adjoining Central Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$D$106:$D$108,C330)","v":802.68700000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$106:$D$108,D330)","v":764.49249999999995},{"$f":"INDEX('Prop2024-25DistTar'!$D$106:$D$108,E330)","v":159.6277}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B332","v":"Existing: Tariff M - Adjoining Central Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$F$106:$F$108,C$282)","v":0},{"$f":"INDEX('Prop2024-25DistTar'!$F$106:$F$108,D$282)","v":0},{"$f":"INDEX('Prop2024-25DistTar'!$F$106:$F$108,E$282)","v":0}]
[null,{"$f":"B333","v":"Proposed: Tariff M - Adjoining Central Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$F$106:$F$108,C$282)","v":0},{"$f":"INDEX('Prop2024-25DistTar'!$F$106:$F$108,D$282)","v":0},{"$f":"INDEX('Prop2024-25DistTar'!$F$106:$F$108,E$282)","v":0}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B336","v":"Existing: Tariff M - Adjoining Central Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$H$106:$H$108,C330)","v":0},{"$f":"INDEX('Prop2024-25DistTar'!$H$106:$H$108,D330)","v":0},{"$f":"INDEX('Prop2024-25DistTar'!$H$106:$H$108,E330)","v":0}]
[null,{"$f":"B337","v":"Proposed: Tariff M - Adjoining Central Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$G$106:$G$108,C330)","v":0},{"$f":"INDEX('Prop2024-25DistTar'!$G$106:$G$108,D330)","v":0},{"$f":"INDEX('Prop2024-25DistTar'!$G$106:$G$108,E330)","v":0}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B340","v":"Existing: Tariff M - Adjoining Central Zone"},{"$f":"SUM(C340:E340)","v":0}]
[null,{"$f":"B341","v":"Proposed: Tariff M - Adjoining Central Zone"},{"$f":"SUM(C341:E341)","v":0}]
[]
[null,"Average price movement",{"$f":"IF(C345=0,\"\",C345/C344)","v":""}]
[]
[null,{"$f":"IF(C347=\"\",\"\",IF(C347<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":""}]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B110","v":"Tariff M - Adjoining West Zone"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&'Prop2024-25DistTar'!C110","v":"Existing: Tariff M - Adjoining West Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$E$111:$E$113,C354)","v":752.29870000000005},{"$f":"INDEX('Prop2024-25DistTar'!$E$111:$E$113,D354)","v":716.5018},{"$f":"INDEX('Prop2024-25DistTar'!$E$111:$E$113,E354)","v":149.6071}]
[null,{"$f":"\"Proposed: \"&B353","v":"Proposed: Tariff M - Adjoining West Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$D$111:$D$113,C354)","v":802.68700000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$111:$D$113,D354)","v":764.49249999999995},{"$f":"INDEX('Prop2024-25DistTar'!$D$111:$D$113,E354)","v":159.6277}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B356","v":"Existing: Tariff M - Adjoining West Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$F$111:$F$113,C$282)","v":0},{"$f":"INDEX('Prop2024-25DistTar'!$F$111:$F$113,D$282)","v":0},{"$f":"INDEX('Prop2024-25DistTar'!$F$111:$F$113,E$282)","v":0}]
[null,{"$f":"B357","v":"Proposed: Tariff M - Adjoining West Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$F$111:$F$113,C$282)","v":0},{"$f":"INDEX('Prop2024-25DistTar'!$F$111:$F$113,D$282)","v":0},{"$f":"INDEX('Prop2024-25DistTar'!$F$111:$F$113,E$282)","v":0}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B360","v":"Existing: Tariff M - Adjoining West Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$H$111:$H$113,C354)","v":0},{"$f":"INDEX('Prop2024-25DistTar'!$H$111:$H$113,D354)","v":0},{"$f":"INDEX('Prop2024-25DistTar'!$H$111:$H$113,E354)","v":0}]
[null,{"$f":"B361","v":"Proposed: Tariff M - Adjoining West Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$G$111:$G$113,C354)","v":0},{"$f":"INDEX('Prop2024-25DistTar'!$G$111:$G$113,D354)","v":0},{"$f":"INDEX('Prop2024-25DistTar'!$G$111:$G$113,E354)","v":0}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B364","v":"Existing: Tariff M - Adjoining West Zone"},{"$f":"SUM(C364:E364)","v":0}]
[null,{"$f":"B365","v":"Proposed: Tariff M - Adjoining West Zone"},{"$f":"SUM(C365:E365)","v":0}]
[]
[null,"Average price movement",{"$f":"IF(C369=0,\"\",C369/C368)","v":""}]
[]
[null,{"$f":"IF(C371=\"\",\"\",IF(C371<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":""}]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B116","v":"Tariff D - Central Zone"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&'Prop2024-25DistTar'!C116","v":"Existing: Tariff D - Central Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$E$117:$E$119,C378)","v":343.18130000000002},{"$f":"INDEX('Prop2024-25DistTar'!$E$117:$E$119,D378)","v":326.84199999999998},{"$f":"INDEX('Prop2024-25DistTar'!$E$117:$E$119,E378)","v":158.6859}]
[null,{"$f":"\"Proposed: \"&B377","v":"Proposed: Tariff D - Central Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$D$117:$D$119,C378)","v":366.16730000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$117:$D$119,D378)","v":348.73360000000002},{"$f":"INDEX('Prop2024-25DistTar'!$D$117:$D$119,E378)","v":169.31450000000001}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B380","v":"Existing: Tariff D - Central Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$F$117:$F$119,C$282)","v":1130.8474999999999},{"$f":"INDEX('Prop2024-25DistTar'!$F$117:$F$119,D$282)","v":1412.6974999999998},{"$f":"INDEX('Prop2024-25DistTar'!$F$117:$F$119,E$282)","v":2395.9641666666657}]
[null,{"$f":"B381","v":"Proposed: Tariff D - Central Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$F$117:$F$119,C$282)","v":1130.8474999999999},{"$f":"INDEX('Prop2024-25DistTar'!$F$117:$F$119,D$282)","v":1412.6974999999998},{"$f":"INDEX('Prop2024-25DistTar'!$F$117:$F$119,E$282)","v":2395.9641666666657}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B384","v":"Existing: Tariff D - Central Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$H$117:$H$119,C378)","v":388085.71515174996},{"$f":"INDEX('Prop2024-25DistTar'!$H$117:$H$119,D378)","v":461728.87629499991},{"$f":"INDEX('Prop2024-25DistTar'!$H$117:$H$119,E378)","v":380205.73015524988}]
[null,{"$f":"B385","v":"Proposed: Tariff D - Central Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$G$117:$G$119,C378)","v":414079.37578674994},{"$f":"INDEX('Prop2024-25DistTar'!$G$117:$G$119,D378)","v":492655.08488599997},{"$f":"INDEX('Prop2024-25DistTar'!$G$117:$G$119,E378)","v":405671.47489708319}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B388","v":"Existing: Tariff D - Central Zone"},{"$f":"SUM(C388:E388)","v":1230020.3216019997}]
[null,{"$f":"B389","v":"Proposed: Tariff D - Central Zone"},{"$f":"SUM(C389:E389)","v":1312405.935569833}]
[]
[null,"Average price movement",{"$f":"IF(C393=0,\"\",C393/C392)","v":1.0669790673543775}]
[]
[null,{"$f":"IF(C395=\"\",\"\",IF(C395<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B121","v":"Tariff D - West Zone"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&'Prop2024-25DistTar'!C121","v":"Existing: Tariff D - West Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$E$122:$E$124,C402)","v":343.18130000000002},{"$f":"INDEX('Prop2024-25DistTar'!$E$122:$E$124,D402)","v":326.84199999999998},{"$f":"INDEX('Prop2024-25DistTar'!$E$122:$E$124,E402)","v":158.6859}]
[null,{"$f":"\"Proposed: \"&B401","v":"Proposed: Tariff D - West Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$D$122:$D$124,C402)","v":366.16730000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$122:$D$124,D402)","v":348.73360000000002},{"$f":"INDEX('Prop2024-25DistTar'!$D$122:$D$124,E402)","v":169.31450000000001}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B404","v":"Existing: Tariff D - West Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$F$122:$F$124,C$282)","v":484.39666666666676},{"$f":"INDEX('Prop2024-25DistTar'!$F$122:$F$124,D$282)","v":632.27583333333337},{"$f":"INDEX('Prop2024-25DistTar'!$F$122:$F$124,E$282)","v":297.11416666666673}]
[null,{"$f":"B405","v":"Proposed: Tariff D - West Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$F$122:$F$124,C$282)","v":484.39666666666676},{"$f":"INDEX('Prop2024-25DistTar'!$F$122:$F$124,D$282)","v":632.27583333333337},{"$f":"INDEX('Prop2024-25DistTar'!$F$122:$F$124,E$282)","v":297.11416666666673}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B408","v":"Existing: Tariff D - West Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$H$122:$H$124,C402)","v":166235.87778233338},{"$f":"INDEX('Prop2024-25DistTar'!$H$122:$H$124,D402)","v":206654.29791833332},{"$f":"INDEX('Prop2024-25DistTar'!$H$122:$H$124,E402)","v":47147.828940250009}]
[null,{"$f":"B409","v":"Proposed: Tariff D - West Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$G$122:$G$124,C402)","v":177370.21956233337},{"$f":"INDEX('Prop2024-25DistTar'!$G$122:$G$124,D402)","v":220495.82755133335},{"$f":"INDEX('Prop2024-25DistTar'!$G$122:$G$124,E402)","v":50305.736572083348}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B412","v":"Existing: Tariff D - West Zone"},{"$f":"SUM(C412:E412)","v":420038.00464091671}]
[null,{"$f":"B413","v":"Proposed: Tariff D - West Zone"},{"$f":"SUM(C413:E413)","v":448171.7836857501}]
[]
[null,"Average price movement",{"$f":"IF(C417=0,\"\",C417/C416)","v":1.0669791274455855}]
[]
[null,{"$f":"IF(C419=\"\",\"\",IF(C419<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B126","v":"Tariff D - Adjoining Central Zone"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&'Prop2024-25DistTar'!C126","v":"Existing: Tariff D - Adjoining Central Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$E$127:$E$129,C426)","v":343.18130000000002},{"$f":"INDEX('Prop2024-25DistTar'!$E$127:$E$129,D426)","v":326.84199999999998},{"$f":"INDEX('Prop2024-25DistTar'!$E$127:$E$129,E426)","v":158.6859}]
[null,{"$f":"\"Proposed: \"&B425","v":"Proposed: Tariff D - Adjoining Central Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$D$127:$D$129,C426)","v":366.16730000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$127:$D$129,D426)","v":348.73360000000002},{"$f":"INDEX('Prop2024-25DistTar'!$D$127:$D$129,E426)","v":169.31450000000001}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B428","v":"Existing: Tariff D - Adjoining Central Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$F$127:$F$129,C$282)","v":10},{"$f":"INDEX('Prop2024-25DistTar'!$F$127:$F$129,D$282)","v":17.778333333333332},{"$f":"INDEX('Prop2024-25DistTar'!$F$127:$F$129,E$282)","v":0}]
[null,{"$f":"B429","v":"Proposed: Tariff D - Adjoining Central Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$F$127:$F$129,C$282)","v":10},{"$f":"INDEX('Prop2024-25DistTar'!$F$127:$F$129,D$282)","v":17.778333333333332},{"$f":"INDEX('Prop2024-25DistTar'!$F$127:$F$129,E$282)","v":0}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B432","v":"Existing: Tariff D - Adjoining Central Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$H$127:$H$129,C426)","v":3431.8130000000001},{"$f":"INDEX('Prop2024-25DistTar'!$H$127:$H$129,D426)","v":5810.7060233333332},{"$f":"INDEX('Prop2024-25DistTar'!$H$127:$H$129,E426)","v":0}]
[null,{"$f":"B433","v":"Proposed: Tariff D - Adjoining Central Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$G$127:$G$129,C426)","v":3661.6730000000002},{"$f":"INDEX('Prop2024-25DistTar'!$G$127:$G$129,D426)","v":6199.9021853333334},{"$f":"INDEX('Prop2024-25DistTar'!$G$127:$G$129,E426)","v":0}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B436","v":"Existing: Tariff D - Adjoining Central Zone"},{"$f":"SUM(C436:E436)","v":9242.5190233333342}]
[null,{"$f":"B437","v":"Proposed: Tariff D - Adjoining Central Zone"},{"$f":"SUM(C437:E437)","v":9861.5751853333331}]
[]
[null,"Average price movement",{"$f":"IF(C441=0,\"\",C441/C440)","v":1.066979160165876}]
[]
[null,{"$f":"IF(C443=\"\",\"\",IF(C443<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]
[]
[]
[]
[null,{"$f":"'Prop2024-25DistTar'!B131","v":"Tariff D - Adjoining West Zone"}]
[null,null,1,2,3]
[null,"Distribution tariff","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"\"Existing: \"&'Prop2024-25DistTar'!C131","v":"Existing: Tariff D - Adjoining West Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$E$132:$E$134,C450)","v":343.18130000000002},{"$f":"INDEX('Prop2024-25DistTar'!$E$132:$E$134,D450)","v":326.84199999999998},{"$f":"INDEX('Prop2024-25DistTar'!$E$132:$E$134,E450)","v":158.6859}]
[null,{"$f":"\"Proposed: \"&B449","v":"Proposed: Tariff D - Adjoining West Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$D$132:$D$134,C450)","v":366.16730000000001},{"$f":"INDEX('Prop2024-25DistTar'!$D$132:$D$134,D450)","v":348.73360000000002},{"$f":"INDEX('Prop2024-25DistTar'!$D$132:$D$134,E450)","v":169.31450000000001}]
[]
[null,"Distribution volumes (actual)","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B452","v":"Existing: Tariff D - Adjoining West Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$F$132:$F$134,C$282)","v":11.575833333333332},{"$f":"INDEX('Prop2024-25DistTar'!$F$132:$F$134,D$282)","v":4.1608333333333327},{"$f":"INDEX('Prop2024-25DistTar'!$F$132:$F$134,E$282)","v":0}]
[null,{"$f":"B453","v":"Proposed: Tariff D - Adjoining West Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$F$132:$F$134,C$282)","v":11.575833333333332},{"$f":"INDEX('Prop2024-25DistTar'!$F$132:$F$134,D$282)","v":4.1608333333333327},{"$f":"INDEX('Prop2024-25DistTar'!$F$132:$F$134,E$282)","v":0}]
[]
[null,"Distribution revenue","DemBlk1","DemBlk2","DemBlk2"]
[null,{"$f":"B456","v":"Existing: Tariff D - Adjoining West Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$H$132:$H$134,C450)","v":3972.6095319166666},{"$f":"INDEX('Prop2024-25DistTar'!$H$132:$H$134,D450)","v":1359.9350883333332},{"$f":"INDEX('Prop2024-25DistTar'!$H$132:$H$134,E450)","v":0}]
[null,{"$f":"B457","v":"Proposed: Tariff D - Adjoining West Zone"},{"$f":"INDEX('Prop2024-25DistTar'!$G$132:$G$134,C450)","v":4238.6916369166665},{"$f":"INDEX('Prop2024-25DistTar'!$G$132:$G$134,D450)","v":1451.0223873333332},{"$f":"INDEX('Prop2024-25DistTar'!$G$132:$G$134,E450)","v":0}]
[]
[null,"Revenue","Total"]
[null,{"$f":"B460","v":"Existing: Tariff D - Adjoining West Zone"},{"$f":"SUM(C460:E460)","v":5332.5446202499998}]
[null,{"$f":"B461","v":"Proposed: Tariff D - Adjoining West Zone"},{"$f":"SUM(C461:E461)","v":5689.71402425}]
[]
[null,"Average price movement",{"$f":"IF(C465=0,\"\",C465/C464)","v":1.0669791683774519}]
[]
[null,{"$f":"IF(C467=\"\",\"\",IF(C467<=$C$15,\"REBALANCING CONTROL COMPLIANT\",\"REBALANCING CONTROL BREACHED\"))","v":"REBALANCING CONTROL COMPLIANT"}]

{"sheet":"ARS","index":5,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Tariff Approval - \"&'Model update'!B3","v":"Tariff Approval - AusNet Services"}]
[]
["Ancillary Reference Services (Exc GST)"]
[]
[null,{"$f":"'Model update'!$B$8","v":"2023-24"},{"$f":"'Model update'!$B$5","v":"2024-25"}]
["Disconnection",64,{"$f":"ROUND(B6*(1+'Model update'!$B$31),2)","v":66.59}]
["Reconnection of Meter ",64,{"$f":"ROUND(B7*(1+'Model update'!$B$31),2)","v":66.59}]
["Special Meter Reads",6.98,{"$f":"ROUND(B8*(1+'Model update'!$B$31),2)","v":7.26}]
["Meter and gas installation test",192.01,{"$f":"ROUND(B9*(1+'Model update'!$B$31),2)","v":199.79}]
["Meter fix or meter reinstallation",141.03,{"$f":"ROUND(B10*(1+'Model update'!$B$31),2)","v":146.74}]
["Service abolishment - residential",220,{"$f":"ROUND(B11*(1+'Model update'!$B$31),2)","v":228.91}]
["Minor meter alter position",1001.6,{"$f":"ROUND(B12*(1+'Model update'!$B$31),2)","v":1042.18}]