{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Title Page","Change Log","AER Change log","Inputs | General","Exit Fees >","Input | Exit Fees","Calc | Exit Fees","Calc | Tax Allowance","Output | Exit Fee price caps","LUTs and Dropdowns"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3547,"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":"Title Page","index":0,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[13,1,13,23],[7,1,8,23],[32,4,32,7],[24,1,24,23],[27,4,27,7],[30,4,30,7],[31,4,31,7],[29,4,29,7],[28,4,28,7]]}
[]
[]
[]
[]
[]
[]
[]
[null,"JEN 2027-31 - ACS Standardised Metering Pricing Model "]
[]
[null,"Version",1.02]
[null,"Date","2022-01-14"]
[]
[]
[null,"Status"]
[]
[null,"Notes:"]
[null,"Current model version contains test data. "]
[]
[null,null,"Locked Sheets Pwd:"]
[]
[]
[]
[]
[]
[null,"Version Summary"]
[]
[null,"Date","Version","Author","Changes"]
[null,null,null,null,null,null,null," "]
[null,"2022-01-14",1.02,"AER","Updates following consultation"]
[null,"2021-10-25",1,"AER","Consultation version (contains anonymised input data)"]

{"sheet":"Change Log","index":1,"n_rows":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[null,"AMI Pricing Model"]
[null,"Change Log"]
[]
[null,"Model change log"]
[]
[null,null,"Starting model name ---->","AER – Metering pricing model – Draft decision – Jemena distribution determination 2026–31 – September 2025"]
[]
[null,null,"Model changes to above model"]
[]
[null,null,"Model sheet","Reference","Cell reference","Type","Legend","Comments"]
[]
[null,null,{"$f":"SheetName('Inputs | General'!A1)","v":"Inputs | General"},1,{"$f":"CellReference('Inputs | General'!G9)","v":"G9"},"Input",null,"Changed state to revised proposal"]
[null,null,{"$f":"SheetName('Inputs | General'!A2)","v":"Inputs | General"},{"$f":"+D12+1","v":2},{"$f":"CellReference('Inputs | General'!G24:H37)","v":"G24:H37"},"Input",null,"Shifted tables two columns right to include FY24 and FY25 inflation values"]
[null,null,{"$f":"SheetName('Inputs | General'!A4)","v":"Inputs | General"},{"$f":"+D13+1","v":3},{"$f":"CellReference('Inputs | General'!J26:N26)","v":"J26:N26"},"Input",null,"Updated forecast inflation to align with PTRM"]
[null,null,{"$f":"SheetName('Inputs | General'!A6)","v":"Inputs | General"},{"$f":"+D14+1","v":4},{"$f":"CellReference('Inputs | General'!G29:N29)","v":"G29:N29"},"Formula",null,"Included Cumulative inflation for FY24 to Nominal"]
[null,null,{"$f":"SheetName('Inputs | General'!A8)","v":"Inputs | General"},{"$f":"+D15+1","v":5},{"$f":"CellReference('Inputs | General'!J33:N33)","v":"J33:N33"},"Input",null,"Updated forecast labour escalation"]
[null,null,{"$f":"SheetName('Inputs | General'!A9)","v":"Inputs | General"},{"$f":"+D16+1","v":6},{"$f":"CellReference('Inputs | General'!H35:I35)","v":"H35:I35"},"Input",null,"Included historical labour escalation"]
[null,null,{"$f":"SheetName('Inputs | General'!A10)","v":"Inputs | General"},7,{"$f":"CellReference('Inputs | General'!G36:N36)","v":"G36:N36"},"Formula",null,"Included Cumulative labour escalation for FY24 to Nominal"]
[]
[]
[null,null,"Model sheet","Reference","Cell reference","Type","Legend","Comments"]
[]
[null,null,{"$f":"SheetName('Input | Exit Fees'!A1)","v":"Input | Exit Fees"},{"$f":"D18+1","v":8},{"$f":"CellReference('Input | Exit Fees'!F8:F23)&\", \"&CellReference('Input | Exit Fees'!F126:F141)&\", \"&CellReference('Input | Exit Fees'!G28)&\", \"&CellReference('Input | Exit Fees'!J96:J120)","v":"F8:F23, F126:F141, G28, J96:J120"},"Labelling",null,"Specified dollar basis"]
[null,null,{"$f":"SheetName('Input | Exit Fees'!A2)","v":"Input | Exit Fees"},{"$f":"+D23+1","v":9},{"$f":"CellReference('Input | Exit Fees'!G9:M11)&\", \"&CellReference('Input | Exit Fees'!G16:M18)","v":"G9:M11, G16:M18"},"Input",null,"Updates to opening RAB and capex data to align with PTRM"]
[null,null,{"$f":"SheetName('Input | Exit Fees'!A4)","v":"Input | Exit Fees"},10,"Rows 12, 19, 23","Input",null,"Added Closing RAB to align with the AER's preferred modelling treatment"]
[null,null,{"$f":"SheetName('Input | Exit Fees'!A3)","v":"Input | Exit Fees"},11,{"$f":"CellReference('Input | Exit Fees'!N9:N19)","v":"N9:N19"},"Labelling",null,"Updated labelling to improve transparency"]
[null,null,{"$f":"SheetName('Input | Exit Fees'!A5)","v":"Input | Exit Fees"},12,{"$f":"CellReference('Input | Exit Fees'!B14)&\", \"&CellReference('Input | Exit Fees'!B132)&\", \"&CellReference('Input | Exit Fees'!N127:N137)","v":"B14, B132, N127:N137"},"Labelling",null,"Improved labelling for clarity"]
[null,null,{"$f":"SheetName('Input | Exit Fees'!A11)","v":"Input | Exit Fees"},13,{"$f":"CellReference('Input | Exit Fees'!K50:L53)","v":"K50:L53"},"Input",null,"Updated value to consider weighted calculation"]
[null,null,{"$f":"SheetName('Input | Exit Fees'!A14)","v":"Input | Exit Fees"},14,{"$f":"CellReference('Input | Exit Fees'!J70:O73)","v":"J70:O73"},"Input",null,"Updated gross meter populations to align with Metering expenditure model"]
[null,null,{"$f":"SheetName('Input | Exit Fees'!A15)","v":"Input | Exit Fees"},{"$f":"+D29+1","v":15},{"$f":"CellReference('Input | Exit Fees'!E91:G92)","v":"E91:G92"},"Input",null,"Updated hourly rate and included basis"]
[null,null,{"$f":"SheetName('Input | Exit Fees'!A16)","v":"Input | Exit Fees"},16,{"$f":"CellReference('Input | Exit Fees'!K97:O102)","v":"K97:O102"},"Formula",null,"Updated calculation to consider the escalation to Nominal costs"]
[null,null,{"$f":"SheetName('Input | Exit Fees'!A17)","v":"Input | Exit Fees"},17,{"$f":"CellReference('Input | Exit Fees'!K103:O105)","v":"K103:O105"},"Formula",null,"Updated input value"]
[null,null,{"$f":"SheetName('Input | Exit Fees'!A19)","v":"Input | Exit Fees"},18,{"$f":"CellReference('Input | Exit Fees'!G127:L129)&\", \"&CellReference('Input | Exit Fees'!G134:M136)","v":"G127:L129, G134:M136"},"Input",null,"Updates to opening TAB and capex data to align with PTRM"]
[null,null,{"$f":"SheetName('Input | Exit Fees'!A21)","v":"Input | Exit Fees"},19,"Rows 130, 137, 141","Input",null,"Added Closing TAB to align with the AER's preferred modelling treatment"]
[]
[]
[null,null,"Model sheet","Reference","Cell reference","Type","Legend","Comments"]
[]
[null,null,{"$f":"SheetName('Calc | Exit Fees'!A1)","v":"Calc | Exit Fees"},{"$f":"D34+1","v":20},{"$f":"CellReference('Calc | Exit Fees'!H45:H109)&\", \"&CellReference('Calc | Exit Fees'!G116)&\", \"&CellReference('Calc | Exit Fees'!H185:H218)&\", \"&CellReference('Calc | Exit Fees'!G225)","v":"H45:H109, G116, H185:H218, G225"},"Labelling",null,"Specified dollar basis"]
[null,null,{"$f":"SheetName('Calc | Exit Fees'!A2)","v":"Calc | Exit Fees"},{"$f":"+D39+1","v":21},{"$f":"CellReference('Calc | Exit Fees'!K46:O55)","v":"K46:O55"},"Formula",null,"Updated calculation to consider the escalation to Nominal costs"]
[null,null,{"$f":"SheetName('Calc | Exit Fees'!A3)","v":"Calc | Exit Fees"},{"$f":"+D40+1","v":22},{"$f":"CellReference('Calc | Exit Fees'!K77:O86)&\", \"&CellReference('Calc | Exit Fees'!K109:O109)&\", \"&CellReference('Calc | Exit Fees'!K186:O195)&\", \"&CellReference('Calc | Exit Fees'!K218:O218)","v":"K77:O86, K109:O109, K186:O195, K218:O218"},"Formula",null,"Updated calculation formula to refer to average of closing RAB"]
[null,null,{"$f":"SheetName('Calc | Exit Fees'!A5)","v":"Calc | Exit Fees"},{"$f":"+D41+1","v":23},{"$f":"CellReference('Calc | Exit Fees'!B103)&\", \"&CellReference('Calc | Exit Fees'!C105)&\", \"&CellReference('Calc | Exit Fees'!F109)&\", \"&CellReference('Calc | Exit Fees'!E120)&\", \"&CellReference('Calc | Exit Fees'!C214)&\", \"&CellReference('Calc | Exit Fees'!F218)","v":"B103, C105, F109, E120, C214, F218"},"Labelling",null,"Improved labelling for clarity"]
[null,null,{"$f":"SheetName('Calc | Exit Fees'!A9)","v":"Calc | Exit Fees"},24,{"$f":"CellReference('Calc | Exit Fees'!K109:O109)&\", \"&CellReference('Calc | Exit Fees'!K218:O218)","v":"K109:O109, K218:O218"},"Formula",null,"Updated calculation to consider the escalation to Nominal costs"]
[]
[]
[null,null,"Model sheet","Reference","Cell reference","Type","Legend","Comments"]
[]
[null,null,{"$f":"SheetName('Calc | Tax Allowance'!A3)","v":"Calc | Tax Allowance"},{"$f":"D43+1","v":25},{"$f":"CellReference('Calc | Tax Allowance'!G8)","v":"G8"},"Input",null,"Specified dollar basis"]
[null,null,{"$f":"SheetName('Calc | Tax Allowance'!A4)","v":"Calc | Tax Allowance"},{"$f":"+D48+1","v":26},{"$f":"CellReference('Calc | Tax Allowance'!E13:E82)","v":"E13:E82"},"Labelling",null,"Improved labelling for clarity"]
[]
[null,"End"]

{"sheet":"AER Change log","index":2,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Worksheet","Cells","Description of change"]
[null,"Throughout workbook",null,"Added cost basis labelling"]
[null,"Inputs | General","G9","Updated decision stage"]
[null,"Inputs | General","H26:L26","Update forecast inflation"]
[null,"Inputs | General","H32:L32","Update opex price change to reflect Input prices "]
[null,"Inputs | Exit Fees","G9:L18","Updated RAB inputs"]
[null,"Inputs | Exit Fees","D29:D31","Updated titles for Single Phase and Three Phase to include DC"]
[null,"Inputs | Exit Fees","G29:G32","Corrected base year exit fees"]
[null,"Inputs | Exit Fees","K49:L63","Updated meter unit costs"]
[null,"Inputs | Exit Fees","K71:O71","Updated meter end year populations"]
[null,"Inputs | Exit Fees","K102:O103","Updated admin labour tasks"]
[null,"Inputs | Exit Fees","G126:L135","Updated TAB inputs"]
[]
[]
[]
[null,"AER Final Decision Change Log"]
[]
[null,"changes in the spreadsheet are also highlighted in green"]
[]
[null,"Worksheet","Cells","Description of change"]
[null,"Inputs | General","I26:N28","Updated forecast inflation"]
[null,null,"H33:N35","Updated WPI"]
[null,"Inputs | Exit Fees","G10:L12","Updated RAB meter inputs"]
[null,null,"G17:L19","Updated  RAB Comms, IT, Inhouse software & Equity Raising Costs"]
[null,null,"J70:O73","Updated gross meter population"]
[null,null,"G92","Updated Admin labour rate"]
[null,null,"G129:L137","Updated TAB  inputs"]

{"sheet":"Inputs | General","index":3,"n_rows":44,"n_cols":23,"rows_kept":44,"cut":false,"hidden":false,"merged":[[37,1,37,6],[40,9,40,13],[4,1,4,6],[1,10,1,11],[1,12,1,13],[20,1,20,6],[23,9,23,13],[30,9,30,13]]}
[null,{"$f":"'Title Page'!B8&\" v\"&'Title Page'!$C$10","v":"JEN 2027-31 - ACS Standardised Metering Pricing Model  v1.02"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Worksheet check:",{"$f":"IF(COUNTA($X$14:$X$48)=COUNTIF($X14:$X49,\"OK\"),\"OK\",\"Check\")","v":"OK"}]
[null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"Inputs | General"},null,null,null,null,null,null,"Key:","Input","External Link",null,"Internal Link",null,"Jemena modification","JEN - RP"]
[]
[]
[null,"1. Inputs - General"]
[]
[null,null,"Inputs","Source","Input Format",null,"Value"]
[null,null,"NSP name","NSP",null,null,"JEN - ACS"]
[null,null,"Decision stage","NSP",null,null,"final"]
[]
[null,null,"Forecast regulatory control period, first year","NSP","YYYY-YY",null,"2026-27"]
[null,null,"Forecast regulatory control period, last year","NSP",null,null,{"$f":"LEFT(FPFirstYear,4)+4&\"-\"&RIGHT(FPFirstYear,2)+4","v":"2030-31"}]
[]
[null,null,"Regulatory Period Length, Yrs",null,null,null,{"$f":"LEFT(G12,4)-LEFT(FPFirstYear,4)+1","v":5}]
[]
[null,null,"Model Used For (Price Cap or Vic Exit Fees?)",null,null,null,"Exit Fees (Vic)"]
[]
[]
[]
[]
[null,{"$f":"LEFT('Inputs | General'!B5,1)+1&\". Linked Inputs - Inflation\"","v":"2. Linked Inputs - Inflation"}]
[]
[]
[null,null,null,null,null,null,null,null,"Base year","Regulatory period"]
[null,null,"Year",null,"Units",null,{"$f":"LEFT(H25,4)-1&\"-\"&RIGHT(H25,2)-1","v":"2023-24"},"2024-25",{"$f":"LEFT(J25,4)-1&\"-\"&RIGHT(J25,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(J25,4)+1&\"-\"&RIGHT(J25,2)+1","v":"2027-28"},{"$f":"LEFT(K25,4)+1&\"-\"&RIGHT(K25,2)+1","v":"2028-29"},{"$f":"LEFT(L25,4)+1&\"-\"&RIGHT(L25,2)+1","v":"2029-30"},{"$f":"LEFT(M25,4)+1&\"-\"&RIGHT(M25,2)+1","v":"2030-31"}]
[null,null,"Inflation Assumption (CPI % increase)",null,"%",null,null,null,null,2.6198992109813399E-2,2.6198992109813399E-2,2.6198992109813399E-2,2.6198992109813399E-2,2.6198992109813399E-2]
[null,null,"Cumulative Inflation Index (CPI end period)",null,"Index",null,null,null,1,{"$f":"I27*(1+J26)","v":1.0261989921098134},{"$f":"J27*(1+K26)","v":1.0530843714071967},{"$f":"K27*(1+L26)","v":1.0806741205446615},{"$f":"L27*(1+M26)","v":1.1089866933020907},{"$f":"M27*(1+N26)","v":1.1380410269298}]
[null,null,"Historical Inflation (CPI % increase)",null,"%",null,null,2.4246877296105973E-2,{"$f":"(100.32/96.81)-1","v":3.6256585063526359E-2}]
[null,null,"Cumulative Inflation Index (Jun 2024 to Nominal)",null,"Index",null,1,{"$f":"G29*(1+H28)","v":1.024246877296106},{"$f":"H29*(1+I28)","v":1.0613825713288434},{"$f":"I29*(1+J26)","v":1.0891897249405811},{"$f":"J29*(1+K26)","v":1.1177253979503892},1.1470086768322294,1.1770591481064445,1.207896911440469]
[]
[null,null,null,null,null,null,null,null,"Base year","Regulatory period"]
[null,null,"Year",null,"Units",null,{"$f":"LEFT(H32,4)-1&\"-\"&RIGHT(H32,2)-1","v":"2023-24"},"2024-25",{"$f":"LEFT(J32,4)-1&\"-\"&RIGHT(J32,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(J32,4)+1&\"-\"&RIGHT(J32,2)+1","v":"2027-28"},{"$f":"LEFT(K32,4)+1&\"-\"&RIGHT(K32,2)+1","v":"2028-29"},{"$f":"LEFT(L32,4)+1&\"-\"&RIGHT(L32,2)+1","v":"2029-30"},{"$f":"LEFT(M32,4)+1&\"-\"&RIGHT(M32,2)+1","v":"2030-31"}]
[null,null,"Weighted average of Opex Price Change (% increase)",null,"%",null,null,null,null,6.4142447704512448E-3,8.5734453709334808E-3,1.002659802990522E-2,1.1296131514512021E-2,1.1485766163867313E-2]
[null,null,"Real Price index to input year",null,"Index",null,null,null,1,{"$f":"I34*(1+J33)","v":1.0064142447704512},{"$f":"J34*(1+K33)","v":1.0150426823185199},{"$f":"K34*(1+L33)","v":1.0252201072773246},{"$f":"L34*(1+M33)","v":1.0368011284404512},{"$f":"M34*(1+N33)","v":1.0487095837601519}]
[null,null,"Historical Real input cost escalation (% increase)",null,"%",null,null,1.9500105332415019E-2,7.3232263809143629E-3]
[null,null,"Cumulative Real input cost escalation Index (Jun 2024 to Nominal)",null,"Index",null,1,{"$f":"G36*(1+H35)","v":1.0195001053324151},{"$f":"H36*(1+I35)","v":1.0269661353991304},{"$f":"I36*(1+J33)","v":1.0335533475625447},{"$f":"J36*(1+K33)","v":1.0424144607258174},1.0528663315040756,1.0647596480519474,1.0769892283901936]
[]
[null,{"$f":"LEFT('Inputs | General'!B21,1)+1&\". Linked Inputs - Return and tax assumptions\"","v":"3. Linked Inputs - Return and tax assumptions"}]
[]
[]
[null,null,null,null,null,null,null,null,"Base year","Regulatory period"]
[null,null,"Assumption",null,"Units",null,null,null,{"$f":"LEFT(J42,4)-1&\"-\"&RIGHT(J42,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(J42,4)+1&\"-\"&RIGHT(J42,2)+1","v":"2027-28"},{"$f":"LEFT(K42,4)+1&\"-\"&RIGHT(K42,2)+1","v":"2028-29"},{"$f":"LEFT(L42,4)+1&\"-\"&RIGHT(L42,2)+1","v":"2029-30"},{"$f":"LEFT(M42,4)+1&\"-\"&RIGHT(M42,2)+1","v":"2030-31"}]
[null,null,"Value of imputation credits",null,"%",null,null,null,0.58499999999999996,0.56999999999999995,0.56999999999999995,0.56999999999999995,0.56999999999999995,0.56999999999999995]
[null,null,"Corporate tax rate",null,"%",null,null,null,0.3,0.3,0.3,0.3,0.3,0.3]

{"sheet":"Exit Fees >","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Input | Exit Fees","index":5,"n_rows":141,"n_cols":17,"rows_kept":141,"cut":false,"hidden":false,"merged":[[140,1,140,3],[87,1,87,7],[115,3,115,5],[116,3,116,5],[117,3,117,5],[118,3,118,5],[124,7,124,11],[108,3,108,5],[109,3,109,5],[110,3,110,5],[111,3,111,5],[139,1,139,3],[95,3,95,5],[112,3,112,5],[113,3,113,5],[114,3,114,5],[122,1,122,6],[122,9,122,11],[0,13,0,14],[48,3,48,5],[4,1,4,6],[25,1,25,7],[42,1,42,7],[6,7,6,11],[4,9,4,11],[21,1,21,3],[22,1,22,3],[67,9,67,14]]}
[null,{"$f":"'Title Page'!B8&\" v\"&'Title Page'!$C$10","v":"JEN 2027-31 - ACS Standardised Metering Pricing Model  v1.02"},null,null,null,null,null,null,null,null,null,null,"DNSP:",{"$f":"IF('Inputs | General'!$G$16=\"Price Cap\",\"NOT USED\",NSP)","v":"JEN - ACS"}]
[null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"Input | Exit Fees"},null,null,null,null,null,"Key:","Input","External Link","Internal Link","Jemena modification","JEN - RP"]
[]
[]
[null,{"$f":"LEFT('Inputs | General'!B21,1)+1&\". Linked Input - RAB\"","v":"3. Linked Input - RAB"},null,null,null,null,null,null,null,{"$f":"IF('Inputs | General'!$G$16=\"Price Cap\",\"NOT USED\",\"\")","v":""}]
[]
[null,"Linked Input - RAB Meters",null,null,null,null,"Base Year","Regulatory Period"]
[null,null,null,null,"Units","Basis",{"$f":"LEFT(H8,4)-1&\"-\"&RIGHT(H8,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(H8,4)+1&\"-\"&RIGHT(H8,2)+1","v":"2027-28"},{"$f":"LEFT(I8,4)+1&\"-\"&RIGHT(I8,2)+1","v":"2028-29"},{"$f":"LEFT(J8,4)+1&\"-\"&RIGHT(J8,2)+1","v":"2029-30"},{"$f":"LEFT(K8,4)+1&\"-\"&RIGHT(K8,2)+1","v":"2030-31"},{"$f":"LEFT(L8,4)+1&\"-\"&RIGHT(L8,2)+1","v":"2031-32"}]
[null,null,"Opening RAB",null,"$m","Nominal",null,{"$f":"+G12","v":40.117112132813411},{"$f":"+H12","v":46.194645893672096},62.843989479232008,88.136896781580717,118.06656568694962,153.26132362039147,"Opening balance of METERS row in PTRM inputs sheet of PTRM"]
[null,null,"Gross capital expenditure",null,"$m","Nominal",null,10.158766757477219,21.400805799817704,31.228463452319396,37.537658455753103,44.846511837460504,null,"Gross capex from METERS row in ASSETS sheet of PTRM"]
[null,null,"Regulatory depreciation",null,"$m","Nominal",null,4.0812329966185334,4.7514622142577849,5.935556149970683,7.6079895503841986,9.651753904018646,null,"Depreciation from METERS row in ASSETS sheet of PTRM"]
[null,null,"Closing RAB",null,"$m","Nominal",40.117112132813411,{"$f":"+H9+H10-H11","v":46.194645893672096},{"$f":"+I9+I10-I11","v":62.843989479232008},{"$f":"+J9+J10-J11","v":88.136896781580717},118.06656568694962,153.26132362039147,null,"Closing balance of METERS row in PTRM inputs sheet of PTRM"]
[]
[null,"Linked Input - RAB Comms, IT, Inhouse software & Equity Raising Costs"]
[null,null,null,null,"Units","Basis",{"$f":"LEFT(H15,4)-1&\"-\"&RIGHT(H15,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(H15,4)+1&\"-\"&RIGHT(H15,2)+1","v":"2027-28"},{"$f":"LEFT(I15,4)+1&\"-\"&RIGHT(I15,2)+1","v":"2028-29"},{"$f":"LEFT(J15,4)+1&\"-\"&RIGHT(J15,2)+1","v":"2029-30"},{"$f":"LEFT(K15,4)+1&\"-\"&RIGHT(K15,2)+1","v":"2030-31"},{"$f":"LEFT(L15,4)+1&\"-\"&RIGHT(L15,2)+1","v":"2031-32"}]
[null,null,"Opening RAB",null,"$m","Nominal",null,{"$f":"+G19","v":6.0450666866575276},{"$f":"+H19","v":12.202594858628332},14.829474000191786,15.964218336237703,19.050872505772801,19.22993203173036,"Opening balance of COMMS & IT & Inhouse Software & Equity Raising Costs rows from PTRM INPUTS sheet of PTRM"]
[null,null,"Gross capital expenditure",null,"$m","Nominal",null,7.4286766310917169,4.926846934206754,3.9337584734840121,6.4153582547451009,4.4664669283523821,null,"Gross capex from COMMS & IT & Inhouse Software & Equity Raising Costs rows in ASSETS sheet of PTRM"]
[null,null,"Regulatory depreciation",null,"$m","Nominal",null,1.2711484591209121,2.2999677926433026,2.7990141374380961,3.3287040852100045,4.2874074023948232,null,"Depreciation from COMMS & IT & Inhouse Software & Equity Raising Costs rows in ASSETS sheet of PTRM"]
[null,null,"Closing RAB",null,"$m","Nominal",6.0450666866575276,{"$f":"+H16+H17-H18","v":12.202594858628332},{"$f":"+I16+I17-I18","v":14.829474000191786},{"$f":"+J16+J17-J18","v":15.964218336237703},{"$f":"+K16+K17-K18","v":19.050872505772801},{"$f":"+L16+L17-L18","v":19.22993203173036},null,"Closing balance of COMMS & IT & Inhouse Software & Equity Raising Costs rows from PTRM INPUTS sheet of PTRM"]
[]
[null,null,null,null,"Units","Basis",{"$f":"LEFT(H21,4)-1&\"-\"&RIGHT(H21,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(H21,4)+1&\"-\"&RIGHT(H21,2)+1","v":"2027-28"},{"$f":"LEFT(I21,4)+1&\"-\"&RIGHT(I21,2)+1","v":"2028-29"},{"$f":"LEFT(J21,4)+1&\"-\"&RIGHT(J21,2)+1","v":"2029-30"},{"$f":"LEFT(K21,4)+1&\"-\"&RIGHT(K21,2)+1","v":"2030-31"},{"$f":"LEFT(L21,4)+1&\"-\"&RIGHT(L21,2)+1","v":"2031-32"}]
[null,"TOTAL Opening RAB",null,null,"$m","Nominal",{"$f":"G9+G16","v":0},{"$f":"H9+H16","v":46.162178819470938},58.397240752300426,77.673463479423788,104.10111511781842,137.11743819272243,172.49125565212182]
[null,"TOTAL Closing RAB",null,null,"$m","Nominal",{"$f":"G12+G19","v":46.162178819470938},{"$f":"H12+H19","v":58.397240752300426},77.673463479423788,104.10111511781842,137.11743819272243,172.49125565212182]
[]
[]
[null,{"$f":"LEFT(B5,1)+1&\". Input | Define Exit Fees\"","v":"4. Input | Define Exit Fees"}]
[]
[null,"Enter Allowed Exit Fee in final year of current Regulatory Period ",null,null,null,null,"Exit Fee $2025–26"]
[null,null,null,"Exit Fee Name",null,"Units","Last Year - Current RP"]
[null,null,null,"Single Phase (inc. DC)",null,"$dollars",191.64]
[null,null,null,"Single Phase, Two Element",null,"$dollars",191.64]
[null,null,null,"Three Phase (inc. DC)",null,"$dollars",191.64]
[null,null,null,"Three Phase CT",null,"$dollars",191.64]
[null,null,null,0,null,"$dollars"]
[null,null,null,0,null,"$dollars",0]
[null,null,null,0,null,"$dollars",0]
[null,null,null,0,null,"$dollars",0]
[null,null,null,0,null,"$dollars",0]
[null,null,null,0,null,"$dollars",0]
[]
[]
[]
[null,{"$f":"LEFT(B26,1)+1&\". Input | from Metering ACS Model\"","v":"5. Input | from Metering ACS Model"}]
[]
[null,"METERS"]
[]
[null,"a","Inputs - Designated Exit Fee by Meter Type",null,null,null,"b","Linked Input - Meter Types & Unit Costs"]
[null,null,null,null,null,null,null,null,null,null,"Equipment Cost","Labour Cost","Total Cost"]
[null,null,null,"Designated Exit Fee",null,null,null,"Meter Type","Units","Basis","New Meter Installations","New Meter Installations","New Meter Installations",null,null,null,"Link from Metering - ACS Model"]
[null,null,null,"Single Phase (inc. DC)",null,null,null,{"$f":"+D50","v":"Single Phase (inc. DC)"},"$dollars","2024-06-01",224.20514159725627,211.15240246062427,{"$f":"K50+L50","v":435.35754405788055}]
[null,null,null,"Single Phase, Two Element",null,null,null,{"$f":"+D51","v":"Single Phase, Two Element"},"$dollars","2024-06-01",261.36,211.15240246062427,472.51240246062429]
[null,null,null,"Three Phase (inc. DC)",null,null,null,{"$f":"+D52","v":"Three Phase (inc. DC)"},"$dollars","2024-06-01",386.98566663193992,226.34158986538534,613.32725649732527]
[null,null,null,"Three Phase CT",null,null,null,{"$f":"+D53","v":"Three Phase CT"},"$dollars","2024-06-01",502.94,401.18956467518615,904.1295646751862]
[null,null,null,null,null,null,null,null,"$dollars",null,null,null,0]
[null,null,null,0,null,null,null,null,"$dollars",null,null,null,0]
[null,null,null,0,null,null,null,null,"$dollars"]
[null,null,null,0,null,null,null,null,"$dollars"]
[null,null,null,0,null,null,null,null,"$dollars"]
[null,null,null,0,null,null,null,null,"$dollars"]
[null,null,null,0,null,null,null,null,"$dollars"]
[null,null,null,0,null,null,null,null,"$dollars"]
[null,null,null,0,null,null,null,0,"$dollars"]
[null,null,null,0,null,null,null,0,"$dollars"]
[null,null,null,0,null,null,null,0,"$dollars"]
[]
[]
[null,"e","Linked Input - Gross Meter Population (Year End), by meter type"]
[null,null,null,null,null,null,null,null,null,"Number of meters in year"]
[null,null,null,null,null,null,null,{"$f":"H49","v":"Meter Type"},"Units",{"$f":"LEFT(K69,4)-1&\"-\"&RIGHT(K69,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(K69,4)+1&\"-\"&RIGHT(K69,2)+1","v":"2027-28"},{"$f":"LEFT(L69,4)+1&\"-\"&RIGHT(L69,2)+1","v":"2028-29"},{"$f":"LEFT(M69,4)+1&\"-\"&RIGHT(M69,2)+1","v":"2029-30"},{"$f":"LEFT(N69,4)+1&\"-\"&RIGHT(N69,2)+1","v":"2030-31"},null,"Link from Metering - ACS Model"]
[null,null,null,null,null,null,null,"Single Phase (inc. DC)","No.",310245.33490393456,309729.92547962011,308375.13589472865,307003.79862656241,305615.91087206162,304211.46965250559]
[null,null,null,null,null,null,null,"Single Phase, Two Element","No.",20745.718893714988,20479.172000981489,20209.329777810533,19936.191645302082,19659.757045152546,19380.025384070817]
[null,null,null,null,null,null,null,"Three Phase (inc. DC)","No.",64099.481476673835,72599.146280530389,82004.233944211752,91524.197315209953,101159.05585265232,110908.83023512206]
[null,null,null,null,null,null,null,"Three Phase CT","No.",2635.2188695903733,2826.5625699480415,3028.6860840727386,3233.2783770627407,3440.3398671116192,3649.8709986201129]
[null,null,null,null,null,null,null,0,"No."]
[null,null,null,null,null,null,null,null,"No."]
[null,null,null,null,null,null,null,{"$f":"H56","v":0},"No."]
[null,null,null,null,null,null,null,0,"No."]
[null,null,null,null,null,null,null,0,"No."]
[null,null,null,null,null,null,null,0,"No."]
[null,null,null,null,null,null,null,0,"No."]
[null,null,null,null,null,null,null,0,"No."]
[null,null,null,null,null,null,null,0,"No."]
[null,null,null,null,null,null,null,0,"No."]
[null,null,null,null,null,null,null,0,"No.",0,0,0,0,0,0]
[null,null,null,null,null,null,null,"Total","No.",{"$f":"SUM(J70:J84)","v":397725.7541439138},405634.80633108004,413617.38570082368,421697.46596413717,429875.06363697816,438150.19627031859]
[]
[]
[null,{"$f":"LEFT(B43,1)+1&\". INPUT | Admin and handling\"","v":"6. INPUT | Admin and handling"}]
[]
[null,"a","Inputs - Admin Hourly Rate"]
[null,null,null,"Admin Fees","Units","Basis","Rate"]
[null,null,null,"Hourly Rate","$dollars/hr","2024-06-01",74.757542322413357]
[]
[]
[null,"b","Inputs - Admin & Handling Costs (Execution costs)"]
[null,null,null,"Admin Process Description",null,null,"Amount\n ($Fixed or Hours)","Calculated or Entered","Proportion required","Basis",{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(K96,4)+1&\"-\"&RIGHT(K96,2)+1","v":"2027-28"},{"$f":"LEFT(L96,4)+1&\"-\"&RIGHT(L96,2)+1","v":"2028-29"},{"$f":"LEFT(M96,4)+1&\"-\"&RIGHT(M96,2)+1","v":"2029-30"},{"$f":"LEFT(N96,4)+1&\"-\"&RIGHT(N96,2)+1","v":"2030-31"}]
[null,null,null,"Validate B2B and paperwork",null,null,8.3333333333333329E-2,"Entered",1,"Nominal",{"$f":"$G$92*$G97*$I97*'Inputs | General'!J$29*'Inputs | General'!J$36","v":7.013102767970226},{"$f":"$G$92*$G97*$I97*'Inputs | General'!K$29*'Inputs | General'!K$36","v":7.2585406979953637},{"$f":"$G$92*$G97*$I97*'Inputs | General'!L$29*'Inputs | General'!L$36","v":7.5233923408911023},{"$f":"$G$92*$G97*$I97*'Inputs | General'!M$29*'Inputs | General'!M$36","v":7.8077093941394695},{"$f":"$G$92*$G97*$I97*'Inputs | General'!N$29*'Inputs | General'!N$36","v":8.1042904960823279}]
[null,null,null,"Write off meter from AMI SAP",null,null,8.3333333333333329E-2,"Entered",1,"Nominal",{"$f":"$G$92*$G98*$I98*'Inputs | General'!J$29*'Inputs | General'!J$36","v":7.013102767970226},{"$f":"$G$92*$G98*$I98*'Inputs | General'!K$29*'Inputs | General'!K$36","v":7.2585406979953637},{"$f":"$G$92*$G98*$I98*'Inputs | General'!L$29*'Inputs | General'!L$36","v":7.5233923408911023},{"$f":"$G$92*$G98*$I98*'Inputs | General'!M$29*'Inputs | General'!M$36","v":7.8077093941394695},{"$f":"$G$92*$G98*$I98*'Inputs | General'!N$29*'Inputs | General'!N$36","v":8.1042904960823279}]
[null,null,null,"Update new meter detail in ERP SAP",null,null,8.3333333333333329E-2,"Entered",1,"Nominal",{"$f":"$G$92*$G99*$I99*'Inputs | General'!J$29*'Inputs | General'!J$36","v":7.013102767970226},{"$f":"$G$92*$G99*$I99*'Inputs | General'!K$29*'Inputs | General'!K$36","v":7.2585406979953637},{"$f":"$G$92*$G99*$I99*'Inputs | General'!L$29*'Inputs | General'!L$36","v":7.5233923408911023},{"$f":"$G$92*$G99*$I99*'Inputs | General'!M$29*'Inputs | General'!M$36","v":7.8077093941394695},{"$f":"$G$92*$G99*$I99*'Inputs | General'!N$29*'Inputs | General'!N$36","v":8.1042904960823279}]
[null,null,null,"SAP ERP internal Service Order creation and close out",null,null,8.3333333333333329E-2,"Entered",1,"Nominal",{"$f":"$G$92*$G100*$I100*'Inputs | General'!J$29*'Inputs | General'!J$36","v":7.013102767970226},{"$f":"$G$92*$G100*$I100*'Inputs | General'!K$29*'Inputs | General'!K$36","v":7.2585406979953637},{"$f":"$G$92*$G100*$I100*'Inputs | General'!L$29*'Inputs | General'!L$36","v":7.5233923408911023},{"$f":"$G$92*$G100*$I100*'Inputs | General'!M$29*'Inputs | General'!M$36","v":7.8077093941394695},{"$f":"$G$92*$G100*$I100*'Inputs | General'!N$29*'Inputs | General'!N$36","v":8.1042904960823279}]
[null,null,null,"Manage system exceptions, errors and reporting",null,null,0.25,"Entered",0.2,"Nominal",{"$f":"$G$92*$G101*$I101*'Inputs | General'!J$29*'Inputs | General'!J$36","v":4.207861660782136},{"$f":"$G$92*$G101*$I101*'Inputs | General'!K$29*'Inputs | General'!K$36","v":4.3551244187972182},{"$f":"$G$92*$G101*$I101*'Inputs | General'!L$29*'Inputs | General'!L$36","v":4.5140354045346616},{"$f":"$G$92*$G101*$I101*'Inputs | General'!M$29*'Inputs | General'!M$36","v":4.6846256364836822},{"$f":"$G$92*$G101*$I101*'Inputs | General'!N$29*'Inputs | General'!N$36","v":4.8625742976493971}]
[null,null,null,"Manage phone calls and inquiries",null,null,0.16666666666666666,"Entered",0.2,"Nominal",{"$f":"$G$92*$G102*$I102*'Inputs | General'!J$29*'Inputs | General'!J$36","v":2.8052411071880905},{"$f":"$G$92*$G102*$I102*'Inputs | General'!K$29*'Inputs | General'!K$36","v":2.9034162791981455},{"$f":"$G$92*$G102*$I102*'Inputs | General'!L$29*'Inputs | General'!L$36","v":3.0093569363564407},{"$f":"$G$92*$G102*$I102*'Inputs | General'!M$29*'Inputs | General'!M$36","v":3.1230837576557877},{"$f":"$G$92*$G102*$I102*'Inputs | General'!N$29*'Inputs | General'!N$36","v":3.2417161984329312}]
[null,null,null,"Relays (Equipment and installation cost)",null,null,null,"Entered",null,"Nominal",5.6023881414321286,5.6517517041565082,5.7047090556059192,5.760486427534004,5.8174465947716376]
[null,null,null,"Access Points (Equipment and installation cost)",null,null,null,"Entered",null,"Nominal",10.369990628622141,13.515854234034963,16.22858183514856,18.49855402828258,20.930012516821972]
[null,null,null,"Decommission and meter disposal cost by Vendor",null,null,null,"Entered",null,"Nominal",27.075851519320576,27.796004011936219,28.535310827814808,29.294281425860419,30.073438815357985]
[null,null,null,null,null,null,null,null,null,"Nominal"]
[]
[null,"c","Admin & Handling Cost Calculation (Autofilled)"]
[null,null,null,"Admin Process Description",null,null,"Amount (Fixed or Hours)","Calculated or Entered","Proportion required","Basis",{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(K109,4)+1&\"-\"&RIGHT(K109,2)+1","v":"2027-28"},{"$f":"LEFT(L109,4)+1&\"-\"&RIGHT(L109,2)+1","v":"2028-29"},{"$f":"LEFT(M109,4)+1&\"-\"&RIGHT(M109,2)+1","v":"2029-30"},{"$f":"LEFT(N109,4)+1&\"-\"&RIGHT(N109,2)+1","v":"2030-31"}]
[null,null,null,{"$f":"D97","v":"Validate B2B and paperwork"},null,null,{"$f":"G97","v":8.3333333333333329E-2},"Entered",1,"Nominal",{"$f":"IF($H110=\"Calc-Fixed\",$I110*$G110,IF($H110=\"Calc-Hourly\",$G$92*$G110*$I110,IF($H110=\"Entered\",K97,0)))","v":7.013102767970226},7.2585406979953637,7.5233923408911023,7.8077093941394695,8.1042904960823279]
[null,null,null,"Write off meter from AMI SAP",null,null,8.3333333333333329E-2,"Entered",1,"Nominal",7.013102767970226,7.2585406979953637,7.5233923408911023,7.8077093941394695,8.1042904960823279]
[null,null,null,"Update new meter detail in ERP SAP",null,null,8.3333333333333329E-2,"Entered",1,"Nominal",7.013102767970226,7.2585406979953637,7.5233923408911023,7.8077093941394695,8.1042904960823279]
[null,null,null,"SAP ERP internal Service Order creation and close out",null,null,8.3333333333333329E-2,"Entered",1,"Nominal",7.013102767970226,7.2585406979953637,7.5233923408911023,7.8077093941394695,8.1042904960823279]
[null,null,null,"Manage system exceptions, errors and reporting",null,null,0.25,"Entered",0.2,"Nominal",4.207861660782136,4.3551244187972182,4.5140354045346616,4.6846256364836822,4.8625742976493971]
[null,null,null,"Manage phone calls and inquiries",null,null,0.16666666666666666,"Entered",0.2,"Nominal",2.8052411071880905,2.9034162791981455,3.0093569363564407,3.1230837576557877,3.2417161984329312]
[null,null,null,"Relays (Equipment and installation cost)",null,null,0,"Entered",0,"Nominal",5.6023881414321286,5.6517517041565082,5.7047090556059192,5.760486427534004,5.8174465947716376]
[null,null,null,"Access Points (Equipment and installation cost)",null,null,{"$f":"G104","v":0},"Entered",0,"Nominal",10.369990628622141,13.515854234034963,16.22858183514856,18.49855402828258,20.930012516821972]
[null,null,null,"Decommission and meter disposal cost by Vendor",null,null,0,"Entered",0,"Nominal",27.075851519320576,27.796004011936219,28.535310827814808,29.294281425860419,30.073438815357985]
[null,null,null,0,null,null,0,0,0,"Nominal",0,0,0,0,0]
[null,null,null,"TOTAL ADMIN and Handling",null,null,null,null,null,"Nominal",{"$f":"SUM(K110:K119)","v":78.113744129225978},{"$f":"SUM(L110:L119)","v":83.25631344010452},{"$f":"SUM(M110:M119)","v":88.085563423024794},{"$f":"SUM(N110:N119)","v":92.591868852374347},{"$f":"SUM(O110:O119)","v":97.342350407363242}]
[]
[]
[null,{"$f":"LEFT('Input | Exit Fees'!B88,1)+1&\". Linked Input - TAB\"","v":"7. Linked Input - TAB"},null,null,null,null,null,null,null,{"$f":"IF('Inputs | General'!$G$16=\"Price Cap\",\"NOT USED\",\"\")","v":""}]
[]
[null,"Linked Input - TAB Meters",null,null,null,null,"Base Year","Regulatory Period"]
[null,null,null,null,"Units","Basis",{"$f":"LEFT(H126,4)-1&\"-\"&RIGHT(H126,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(H126,4)+1&\"-\"&RIGHT(H126,2)+1","v":"2027-28"},{"$f":"LEFT(I126,4)+1&\"-\"&RIGHT(I126,2)+1","v":"2028-29"},{"$f":"LEFT(J126,4)+1&\"-\"&RIGHT(J126,2)+1","v":"2029-30"},{"$f":"LEFT(K126,4)+1&\"-\"&RIGHT(K126,2)+1","v":"2030-31"},{"$f":"LEFT(L126,4)+1&\"-\"&RIGHT(L126,2)+1","v":"2031-32"}]
[null,null,"Opening TAB",null,"$m","Nominal",null,{"$f":"+G130","v":25.823798027302004},{"$f":"+H130","v":31.287519022105382},46.765404459606046,69.526169416312072,95.276944814707491,126.58369817218073,"Opening tax balance of METERS row in PTRM inputs sheet of PTRM"]
[null,null,"Gross capital expenditure",null,"$m","Nominal",null,9.987312587222025,21.033136960222873,30.682898335424767,36.865752008490226,44.01034599943425,null,"Gross capex from METERS row in PTRM input sheet of PTRM"]
[null,null,"Tax depreciation",null,"$m","Nominal",null,4.5235915924186436,5.5552515227222052,7.9221333787187378,11.114976610094795,12.703592641961,null,"Tax Depreciation from METERS row in ASSETS sheet of PTRM"]
[null,null,"Closing TAB",null,"$m","Nominal",25.823798027302004,{"$f":"+H127+H128-H129","v":31.287519022105382},{"$f":"+I127+I128-I129","v":46.765404459606046},69.526169416312072,95.276944814707491,126.58369817218073,null,"Closing tax balance of METERS row in PTRM inputs sheet of PTRM"]
[]
[null,"Linked Input - TAB Comms, IT, Inhouse software & Equity Raising Costs"]
[null,null,null,null,"Units","Basis",{"$f":"LEFT(H133,4)-1&\"-\"&RIGHT(H133,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(H133,4)+1&\"-\"&RIGHT(H133,2)+1","v":"2027-28"},{"$f":"LEFT(I133,4)+1&\"-\"&RIGHT(I133,2)+1","v":"2028-29"},{"$f":"LEFT(J133,4)+1&\"-\"&RIGHT(J133,2)+1","v":"2029-30"},{"$f":"LEFT(K133,4)+1&\"-\"&RIGHT(K133,2)+1","v":"2030-31"},{"$f":"LEFT(L133,4)+1&\"-\"&RIGHT(L133,2)+1","v":"2031-32"}]
[null,null,"Opening RAB",null,"$m","Nominal",null,{"$f":"+G137","v":2.9011469349582661},{"$f":"+H137","v":8.4496207645182668},9.6068910390926181,8.7979672863017413,10.286695360983023,9.3178808951222933,"Opening tax balance of COMMS & IT & Inhouse Software & Equity Raising Costs rows from PTRM INPUTS sheet of PTRM"]
[null,null,"Gross capital expenditure less disposals",null,"$m","Nominal",null,7.3032994452300066,4.8422030141550785,3.8650352266711039,6.3005263565875325,4.3831893910558648,null,"Gross capex from COMMS & IT & Inhouse Software & Equity Raising Costs rows in PTRM input sheet of PTRM"]
[null,null,"Tax depreciation",null,"$m","Nominal",null,1.7548256156700059,3.6849327395807272,4.6739589794619798,4.8117982819062508,5.3520038569165944,null,"Tax Depreciation from COMMS & IT & Inhouse Software & Equity Raising Costs rows in ASSETS sheet of PTRM"]
[null,null,"Closing TAB",null,"$m","Nominal",2.9011469349582661,{"$f":"+H134+H135-H136","v":8.4496207645182668},{"$f":"+I134+I135-I136","v":9.6068910390926181},{"$f":"+J134+J135-J136","v":8.7979672863017413},{"$f":"+K134+K135-K136","v":10.286695360983023},{"$f":"+L134+L135-L136","v":9.3178808951222933},null,"Closing tax balance of COMMS & IT & Inhouse Software & Equity Raising Costs rows from PTRM INPUTS sheet of PTRM"]
[]
[null,null,null,null,"Units","Basis",{"$f":"LEFT(H139,4)-1&\"-\"&RIGHT(H139,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(H139,4)+1&\"-\"&RIGHT(H139,2)+1","v":"2027-28"},{"$f":"LEFT(I139,4)+1&\"-\"&RIGHT(I139,2)+1","v":"2028-29"},{"$f":"LEFT(J139,4)+1&\"-\"&RIGHT(J139,2)+1","v":"2029-30"},{"$f":"LEFT(K139,4)+1&\"-\"&RIGHT(K139,2)+1","v":"2030-31"},{"$f":"LEFT(L139,4)+1&\"-\"&RIGHT(L139,2)+1","v":"2031-32"}]
[null,"TOTAL Opening TAB",null,null,"$m","Nominal",{"$f":"G127+G134","v":0},28.72494496226027,39.737139786623651,56.372295498698662,78.324136702613814,105.56364017569051,135.90157906730303]
[null,"TOTAL Closing TAB",null,null,"$m","Nominal",{"$f":"G130+G137","v":28.72494496226027},{"$f":"H130+H137","v":39.737139786623651},56.372295498698662,78.324136702613814,105.56364017569051,135.90157906730303]

{"sheet":"Calc | Exit Fees","index":6,"n_rows":286,"n_cols":15,"rows_kept":286,"cut":false,"hidden":false,"merged":[[115,6,115,10],[0,13,0,14],[4,1,4,7],[74,10,74,14],[114,6,114,10],[89,10,89,14],[58,10,58,14],[106,10,106,14],[102,1,102,7],[28,10,28,14],[43,10,43,14],[9,10,9,14],[179,1,179,7],[224,6,224,10],[183,10,183,14],[198,10,198,14],[211,1,211,7],[215,10,215,14],[223,6,223,10]]}
[null,{"$f":"'Title Page'!B8&\" v\"&'Title Page'!$C$10","v":"JEN 2027-31 - ACS Standardised Metering Pricing Model  v1.02"},null,null,null,null,null,null,null,null,null,null,"DNSP:",{"$f":"IF('Inputs | General'!$G$16=\"Price Cap\",\"NOT USED\",NSP)","v":"JEN - ACS"}]
[null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"Calc | Exit Fees"},null,null,null,null,null,"Key:","Input","External Link","Internal Link","Jemena modification","JEN - RP"]
[]
[]
[null,"CALCULATION | Meters"]
[]
[null,"Calculation of Allocated Meters RAB by Designated Exit Fee"]
[]
[]
[null,null,null,null,"Average number of meters (Year, Year-1)",null,null,null,null,null,"Average number of meters (Year, Year-1)"]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H69","v":"Meter Type"},{"$f":"'Input | Exit Fees'!I69","v":"Units"},"Designated Exit Fee",null,null,{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(K11,4)+1&\"-\"&RIGHT(K11,2)+1","v":"2027-28"},{"$f":"LEFT(L11,4)+1&\"-\"&RIGHT(L11,2)+1","v":"2028-29"},{"$f":"LEFT(M11,4)+1&\"-\"&RIGHT(M11,2)+1","v":"2029-30"},{"$f":"LEFT(N11,4)+1&\"-\"&RIGHT(N11,2)+1","v":"2030-31"}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H70","v":"Single Phase (inc. DC)"},"No.",{"$f":"'Input | Exit Fees'!D50","v":"Single Phase (inc. DC)"},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J70:K70),0)","v":309987.63019177737},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K70:L70),0)","v":309052.53068717441},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L70:M70),0)","v":307689.46726064553},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M70:N70),0)","v":306309.85474931204},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N70:O70),0)","v":304913.69026228361}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H71","v":"Single Phase, Two Element"},"No.",{"$f":"'Input | Exit Fees'!D51","v":"Single Phase, Two Element"},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J71:K71),0)","v":20612.44544734824},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K71:L71),0)","v":20344.250889396011},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L71:M71),0)","v":20072.760711556308},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M71:N71),0)","v":19797.974345227314},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N71:O71),0)","v":19519.891214611682}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H72","v":"Three Phase (inc. DC)"},"No.",{"$f":"'Input | Exit Fees'!D52","v":"Three Phase (inc. DC)"},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J72:K72),0)","v":68349.313878602115},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K72:L72),0)","v":77301.69011237107},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L72:M72),0)","v":86764.215629710845},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M72:N72),0)","v":96341.626583931138},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N72:O72),0)","v":106033.94304388719}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H73","v":"Three Phase CT"},"No.",{"$f":"'Input | Exit Fees'!D53","v":"Three Phase CT"},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J73:K73),0)","v":2730.8907197692074},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K73:L73),0)","v":2927.6243270103901},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L73:M73),0)","v":3130.9822305677399},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M73:N73),0)","v":3336.8091220871802},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N73:O73),0)","v":3545.1054328658661}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H74","v":0},"No.",{"$f":"'Input | Exit Fees'!D54","v":0},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J74:K74),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K74:L74),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L74:M74),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M74:N74),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N74:O74),0)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H75","v":0},"No.",{"$f":"'Input | Exit Fees'!D55","v":0},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J75:K75),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K75:L75),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L75:M75),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M75:N75),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N75:O75),0)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H76","v":0},"No.",{"$f":"'Input | Exit Fees'!D56","v":0},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J76:K76),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K76:L76),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L76:M76),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M76:N76),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N76:O76),0)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H77","v":0},"No.",{"$f":"'Input | Exit Fees'!D57","v":0},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J77:K77),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K77:L77),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L77:M77),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M77:N77),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N77:O77),0)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H78","v":0},"No.",{"$f":"'Input | Exit Fees'!D58","v":0},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J78:K78),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K78:L78),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L78:M78),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M78:N78),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N78:O78),0)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H79","v":0},"No.",{"$f":"'Input | Exit Fees'!D59","v":0},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J79:K79),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K79:L79),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L79:M79),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M79:N79),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N79:O79),0)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H80","v":0},"No.",{"$f":"'Input | Exit Fees'!D60","v":0},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J80:K80),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K80:L80),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L80:M80),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M80:N80),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N80:O80),0)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H81","v":0},"No.",{"$f":"'Input | Exit Fees'!D61","v":0},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J81:K81),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K81:L81),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L81:M81),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M81:N81),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N81:O81),0)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H82","v":0},"No.",{"$f":"'Input | Exit Fees'!D62","v":0},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J82:K82),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K82:L82),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L82:M82),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M82:N82),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N82:O82),0)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H83","v":0},"No.",{"$f":"'Input | Exit Fees'!D63","v":0},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J83:K83),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K83:L83),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L83:M83),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M83:N83),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N83:O83),0)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H84","v":0},"No.",{"$f":"'Input | Exit Fees'!D64","v":0},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J84:K84),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K84:L84),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L84:M84),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M84:N84),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N84:O84),0)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H85","v":"Total"},"No.",null,null,null,{"$f":"SUM(K12:K26)","v":401680.28023749695},{"$f":"SUM(L12:L26)","v":409626.09601595189},{"$f":"SUM(M12:M26)","v":417657.42583248043},{"$f":"SUM(N12:N26)","v":425786.26480055769},{"$f":"SUM(O12:O26)","v":434012.62995364837}]
[]
[null,null,null,null,"Volume of meters",null,null,null,null,"End Year Vol","Regulatory period"]
[null,null,null,null,null,"Exit Fee","Units",null,null,{"$f":"LEFT(K30,4)-1&\"-\"&RIGHT(K30,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(K30,4)+1&\"-\"&RIGHT(K30,2)+1","v":"2027-28"},{"$f":"LEFT(L30,4)+1&\"-\"&RIGHT(L30,2)+1","v":"2028-29"},{"$f":"LEFT(M30,4)+1&\"-\"&RIGHT(M30,2)+1","v":"2029-30"},{"$f":"LEFT(N30,4)+1&\"-\"&RIGHT(N30,2)+1","v":"2030-31"}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D30","v":"Single Phase (inc. DC)"},"No.",null,null,{"$f":"IF($F31=0,0,SUMPRODUCT('Input | Exit Fees'!$J$70:$J$84,($H$12:$H$26=$F31)/1))","v":310245.33490393456},{"$f":"IF($F31=0,0,SUMPRODUCT(K$12:K$26,($H$12:$H$26=$F31)/1))","v":309987.63019177737},{"$f":"IF($F31=0,0,SUMPRODUCT(L$12:L$26,($H$12:$H$26=$F31)/1))","v":309052.53068717441},{"$f":"IF($F31=0,0,SUMPRODUCT(M$12:M$26,($H$12:$H$26=$F31)/1))","v":307689.46726064553},{"$f":"IF($F31=0,0,SUMPRODUCT(N$12:N$26,($H$12:$H$26=$F31)/1))","v":306309.85474931204},{"$f":"IF($F31=0,0,SUMPRODUCT(O$12:O$26,($H$12:$H$26=$F31)/1))","v":304913.69026228361}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D31","v":"Single Phase, Two Element"},"No.",null,null,{"$f":"IF($F32=0,0,SUMPRODUCT('Input | Exit Fees'!$J$70:$J$84,($H$12:$H$26=$F32)/1))","v":20745.718893714988},{"$f":"IF($F32=0,0,SUMPRODUCT(K$12:K$26,($H$12:$H$26=$F32)/1))","v":20612.44544734824},{"$f":"IF($F32=0,0,SUMPRODUCT(L$12:L$26,($H$12:$H$26=$F32)/1))","v":20344.250889396011},{"$f":"IF($F32=0,0,SUMPRODUCT(M$12:M$26,($H$12:$H$26=$F32)/1))","v":20072.760711556308},{"$f":"IF($F32=0,0,SUMPRODUCT(N$12:N$26,($H$12:$H$26=$F32)/1))","v":19797.974345227314},{"$f":"IF($F32=0,0,SUMPRODUCT(O$12:O$26,($H$12:$H$26=$F32)/1))","v":19519.891214611682}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D32","v":"Three Phase (inc. DC)"},"No.",null,null,{"$f":"IF($F33=0,0,SUMPRODUCT('Input | Exit Fees'!$J$70:$J$84,($H$12:$H$26=$F33)/1))","v":64099.481476673835},{"$f":"IF($F33=0,0,SUMPRODUCT(K$12:K$26,($H$12:$H$26=$F33)/1))","v":68349.313878602115},{"$f":"IF($F33=0,0,SUMPRODUCT(L$12:L$26,($H$12:$H$26=$F33)/1))","v":77301.69011237107},{"$f":"IF($F33=0,0,SUMPRODUCT(M$12:M$26,($H$12:$H$26=$F33)/1))","v":86764.215629710845},{"$f":"IF($F33=0,0,SUMPRODUCT(N$12:N$26,($H$12:$H$26=$F33)/1))","v":96341.626583931138},{"$f":"IF($F33=0,0,SUMPRODUCT(O$12:O$26,($H$12:$H$26=$F33)/1))","v":106033.94304388719}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D33","v":"Three Phase CT"},"No.",null,null,{"$f":"IF($F34=0,0,SUMPRODUCT('Input | Exit Fees'!$J$70:$J$84,($H$12:$H$26=$F34)/1))","v":2635.2188695903733},{"$f":"IF($F34=0,0,SUMPRODUCT(K$12:K$26,($H$12:$H$26=$F34)/1))","v":2730.8907197692074},{"$f":"IF($F34=0,0,SUMPRODUCT(L$12:L$26,($H$12:$H$26=$F34)/1))","v":2927.6243270103901},{"$f":"IF($F34=0,0,SUMPRODUCT(M$12:M$26,($H$12:$H$26=$F34)/1))","v":3130.9822305677399},{"$f":"IF($F34=0,0,SUMPRODUCT(N$12:N$26,($H$12:$H$26=$F34)/1))","v":3336.8091220871802},{"$f":"IF($F34=0,0,SUMPRODUCT(O$12:O$26,($H$12:$H$26=$F34)/1))","v":3545.1054328658661}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D34","v":0},"No.",null,null,{"$f":"IF($F35=0,0,SUMPRODUCT('Input | Exit Fees'!$J$70:$J$84,($H$12:$H$26=$F35)/1))","v":0},{"$f":"IF($F35=0,0,SUMPRODUCT(K$12:K$26,($H$12:$H$26=$F35)/1))","v":0},{"$f":"IF($F35=0,0,SUMPRODUCT(L$12:L$26,($H$12:$H$26=$F35)/1))","v":0},{"$f":"IF($F35=0,0,SUMPRODUCT(M$12:M$26,($H$12:$H$26=$F35)/1))","v":0},{"$f":"IF($F35=0,0,SUMPRODUCT(N$12:N$26,($H$12:$H$26=$F35)/1))","v":0},{"$f":"IF($F35=0,0,SUMPRODUCT(O$12:O$26,($H$12:$H$26=$F35)/1))","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D35","v":0},"No.",null,null,{"$f":"IF($F36=0,0,SUMPRODUCT('Input | Exit Fees'!$J$70:$J$84,($H$12:$H$26=$F36)/1))","v":0},{"$f":"IF($F36=0,0,SUMPRODUCT(K$12:K$26,($H$12:$H$26=$F36)/1))","v":0},{"$f":"IF($F36=0,0,SUMPRODUCT(L$12:L$26,($H$12:$H$26=$F36)/1))","v":0},{"$f":"IF($F36=0,0,SUMPRODUCT(M$12:M$26,($H$12:$H$26=$F36)/1))","v":0},{"$f":"IF($F36=0,0,SUMPRODUCT(N$12:N$26,($H$12:$H$26=$F36)/1))","v":0},{"$f":"IF($F36=0,0,SUMPRODUCT(O$12:O$26,($H$12:$H$26=$F36)/1))","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D36","v":0},"No.",null,null,{"$f":"IF($F37=0,0,SUMPRODUCT('Input | Exit Fees'!$J$70:$J$84,($H$12:$H$26=$F37)/1))","v":0},{"$f":"IF($F37=0,0,SUMPRODUCT(K$12:K$26,($H$12:$H$26=$F37)/1))","v":0},{"$f":"IF($F37=0,0,SUMPRODUCT(L$12:L$26,($H$12:$H$26=$F37)/1))","v":0},{"$f":"IF($F37=0,0,SUMPRODUCT(M$12:M$26,($H$12:$H$26=$F37)/1))","v":0},{"$f":"IF($F37=0,0,SUMPRODUCT(N$12:N$26,($H$12:$H$26=$F37)/1))","v":0},{"$f":"IF($F37=0,0,SUMPRODUCT(O$12:O$26,($H$12:$H$26=$F37)/1))","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D37","v":0},"No.",null,null,{"$f":"IF($F38=0,0,SUMPRODUCT('Input | Exit Fees'!$J$70:$J$84,($H$12:$H$26=$F38)/1))","v":0},{"$f":"IF($F38=0,0,SUMPRODUCT(K$12:K$26,($H$12:$H$26=$F38)/1))","v":0},{"$f":"IF($F38=0,0,SUMPRODUCT(L$12:L$26,($H$12:$H$26=$F38)/1))","v":0},{"$f":"IF($F38=0,0,SUMPRODUCT(M$12:M$26,($H$12:$H$26=$F38)/1))","v":0},{"$f":"IF($F38=0,0,SUMPRODUCT(N$12:N$26,($H$12:$H$26=$F38)/1))","v":0},{"$f":"IF($F38=0,0,SUMPRODUCT(O$12:O$26,($H$12:$H$26=$F38)/1))","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D38","v":0},"No.",null,null,{"$f":"IF($F39=0,0,SUMPRODUCT('Input | Exit Fees'!$J$70:$J$84,($H$12:$H$26=$F39)/1))","v":0},{"$f":"IF($F39=0,0,SUMPRODUCT(K$12:K$26,($H$12:$H$26=$F39)/1))","v":0},{"$f":"IF($F39=0,0,SUMPRODUCT(L$12:L$26,($H$12:$H$26=$F39)/1))","v":0},{"$f":"IF($F39=0,0,SUMPRODUCT(M$12:M$26,($H$12:$H$26=$F39)/1))","v":0},{"$f":"IF($F39=0,0,SUMPRODUCT(N$12:N$26,($H$12:$H$26=$F39)/1))","v":0},{"$f":"IF($F39=0,0,SUMPRODUCT(O$12:O$26,($H$12:$H$26=$F39)/1))","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D39","v":0},"No.",null,null,{"$f":"IF($F40=0,0,SUMPRODUCT('Input | Exit Fees'!$J$70:$J$84,($H$12:$H$26=$F40)/1))","v":0},{"$f":"IF($F40=0,0,SUMPRODUCT(K$12:K$26,($H$12:$H$26=$F40)/1))","v":0},{"$f":"IF($F40=0,0,SUMPRODUCT(L$12:L$26,($H$12:$H$26=$F40)/1))","v":0},{"$f":"IF($F40=0,0,SUMPRODUCT(M$12:M$26,($H$12:$H$26=$F40)/1))","v":0},{"$f":"IF($F40=0,0,SUMPRODUCT(N$12:N$26,($H$12:$H$26=$F40)/1))","v":0},{"$f":"IF($F40=0,0,SUMPRODUCT(O$12:O$26,($H$12:$H$26=$F40)/1))","v":0}]
[null,null,null,null,null,"Total","No.",null,null,{"$f":"SUM(J31:J40)","v":397725.7541439138},401680.28023749695,409626.09601595189,417657.42583248043,425786.26480055769,434012.62995364837]
[]
[]
[null,null,null,null,"Cost-Weighted Volume of Meters",null,null,null,null,null,"Regulatory period"]
[null,null,null,null,null,"Exit Fee","Units","Basis",null,null,{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(K45,4)+1&\"-\"&RIGHT(K45,2)+1","v":"2027-28"},{"$f":"LEFT(L45,4)+1&\"-\"&RIGHT(L45,2)+1","v":"2028-29"},{"$f":"LEFT(M45,4)+1&\"-\"&RIGHT(M45,2)+1","v":"2029-30"},{"$f":"LEFT(N45,4)+1&\"-\"&RIGHT(N45,2)+1","v":"2030-31"}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D30","v":"Single Phase (inc. DC)"},"$dollars","Nominal",null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,K$12:K$26,($H$12:$H$26=$F46)/1)*'Inputs | General'!J$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,K$12:K$26,($H$12:$H$26=$F46)/1)*'Inputs | General'!J$29*'Inputs | General'!J$36","v":149384195.61947215},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,L$12:L$26,($H$12:$H$26=$F46)/1)*'Inputs | General'!K$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,L$12:L$26,($H$12:$H$26=$F46)/1)*'Inputs | General'!K$29*'Inputs | General'!K$36","v":153481803.20266211},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,M$12:M$26,($H$12:$H$26=$F46)/1)*'Inputs | General'!L$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,M$12:M$26,($H$12:$H$26=$F46)/1)*'Inputs | General'!L$29*'Inputs | General'!L$36","v":157587089.75990242},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,N$12:N$26,($H$12:$H$26=$F46)/1)*'Inputs | General'!M$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,N$12:N$26,($H$12:$H$26=$F46)/1)*'Inputs | General'!M$29*'Inputs | General'!M$36","v":161896051.72071892},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,O$12:O$26,($H$12:$H$26=$F46)/1)*'Inputs | General'!N$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,O$12:O$26,($H$12:$H$26=$F46)/1)*'Inputs | General'!N$29*'Inputs | General'!N$36","v":166331381.9662503}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D31","v":"Single Phase, Two Element"},"$dollars","Nominal",null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,K$12:K$26,($H$12:$H$26=$F47)/1)*'Inputs | General'!J$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,K$12:K$26,($H$12:$H$26=$F47)/1)*'Inputs | General'!J$29*'Inputs | General'!J$36","v":10767373.03554428},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,L$12:L$26,($H$12:$H$26=$F47)/1)*'Inputs | General'!K$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,L$12:L$26,($H$12:$H$26=$F47)/1)*'Inputs | General'!K$29*'Inputs | General'!K$36","v":10948245.739206955},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,M$12:M$26,($H$12:$H$26=$F47)/1)*'Inputs | General'!L$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,M$12:M$26,($H$12:$H$26=$F47)/1)*'Inputs | General'!L$29*'Inputs | General'!L$36","v":11135960.460296385},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,N$12:N$26,($H$12:$H$26=$F47)/1)*'Inputs | General'!M$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,N$12:N$26,($H$12:$H$26=$F47)/1)*'Inputs | General'!M$29*'Inputs | General'!M$36","v":11329793.420004409},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,O$12:O$26,($H$12:$H$26=$F47)/1)*'Inputs | General'!N$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,O$12:O$26,($H$12:$H$26=$F47)/1)*'Inputs | General'!N$29*'Inputs | General'!N$36","v":11524200.223500071}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D32","v":"Three Phase (inc. DC)"},"$dollars","Nominal",null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,K$12:K$26,($H$12:$H$26=$F48)/1)*'Inputs | General'!J$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,K$12:K$26,($H$12:$H$26=$F48)/1)*'Inputs | General'!J$29*'Inputs | General'!J$36","v":46224751.483944595},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,L$12:L$26,($H$12:$H$26=$F48)/1)*'Inputs | General'!K$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,L$12:L$26,($H$12:$H$26=$F48)/1)*'Inputs | General'!K$29*'Inputs | General'!K$36","v":53822213.170763656},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,M$12:M$26,($H$12:$H$26=$F48)/1)*'Inputs | General'!L$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,M$12:M$26,($H$12:$H$26=$F48)/1)*'Inputs | General'!L$29*'Inputs | General'!L$36","v":62228737.311998367},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,N$12:N$26,($H$12:$H$26=$F48)/1)*'Inputs | General'!M$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,N$12:N$26,($H$12:$H$26=$F48)/1)*'Inputs | General'!M$29*'Inputs | General'!M$36","v":71213375.552616969},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,O$12:O$26,($H$12:$H$26=$F48)/1)*'Inputs | General'!N$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,O$12:O$26,($H$12:$H$26=$F48)/1)*'Inputs | General'!N$29*'Inputs | General'!N$36","v":80785643.822811604}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D33","v":"Three Phase CT"},"$dollars","Nominal",null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,K$12:K$26,($H$12:$H$26=$F49)/1)*'Inputs | General'!J$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,K$12:K$26,($H$12:$H$26=$F49)/1)*'Inputs | General'!J$29*'Inputs | General'!J$36","v":2729335.4507549834},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,L$12:L$26,($H$12:$H$26=$F49)/1)*'Inputs | General'!K$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,L$12:L$26,($H$12:$H$26=$F49)/1)*'Inputs | General'!K$29*'Inputs | General'!K$36","v":3014247.0513191563},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,M$12:M$26,($H$12:$H$26=$F49)/1)*'Inputs | General'!L$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,M$12:M$26,($H$12:$H$26=$F49)/1)*'Inputs | General'!L$29*'Inputs | General'!L$36","v":3323136.3868213738},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,N$12:N$26,($H$12:$H$26=$F49)/1)*'Inputs | General'!M$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,N$12:N$26,($H$12:$H$26=$F49)/1)*'Inputs | General'!M$29*'Inputs | General'!M$36","v":3653122.0273117917},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,O$12:O$26,($H$12:$H$26=$F49)/1)*'Inputs | General'!N$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,O$12:O$26,($H$12:$H$26=$F49)/1)*'Inputs | General'!N$29*'Inputs | General'!N$36","v":4003856.089027164}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D34","v":0},"$dollars","Nominal",null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,K$12:K$26,($H$12:$H$26=$F50)/1)*'Inputs | General'!J$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,K$12:K$26,($H$12:$H$26=$F50)/1)*'Inputs | General'!J$29*'Inputs | General'!J$36","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,L$12:L$26,($H$12:$H$26=$F50)/1)*'Inputs | General'!K$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,L$12:L$26,($H$12:$H$26=$F50)/1)*'Inputs | General'!K$29*'Inputs | General'!K$36","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,M$12:M$26,($H$12:$H$26=$F50)/1)*'Inputs | General'!L$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,M$12:M$26,($H$12:$H$26=$F50)/1)*'Inputs | General'!L$29*'Inputs | General'!L$36","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,N$12:N$26,($H$12:$H$26=$F50)/1)*'Inputs | General'!M$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,N$12:N$26,($H$12:$H$26=$F50)/1)*'Inputs | General'!M$29*'Inputs | General'!M$36","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,O$12:O$26,($H$12:$H$26=$F50)/1)*'Inputs | General'!N$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,O$12:O$26,($H$12:$H$26=$F50)/1)*'Inputs | General'!N$29*'Inputs | General'!N$36","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D35","v":0},"$dollars","Nominal",null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,K$12:K$26,($H$12:$H$26=$F51)/1)*'Inputs | General'!J$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,K$12:K$26,($H$12:$H$26=$F51)/1)*'Inputs | General'!J$29*'Inputs | General'!J$36","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,L$12:L$26,($H$12:$H$26=$F51)/1)*'Inputs | General'!K$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,L$12:L$26,($H$12:$H$26=$F51)/1)*'Inputs | General'!K$29*'Inputs | General'!K$36","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,M$12:M$26,($H$12:$H$26=$F51)/1)*'Inputs | General'!L$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,M$12:M$26,($H$12:$H$26=$F51)/1)*'Inputs | General'!L$29*'Inputs | General'!L$36","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,N$12:N$26,($H$12:$H$26=$F51)/1)*'Inputs | General'!M$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,N$12:N$26,($H$12:$H$26=$F51)/1)*'Inputs | General'!M$29*'Inputs | General'!M$36","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,O$12:O$26,($H$12:$H$26=$F51)/1)*'Inputs | General'!N$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,O$12:O$26,($H$12:$H$26=$F51)/1)*'Inputs | General'!N$29*'Inputs | General'!N$36","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D36","v":0},"$dollars","Nominal",null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,K$12:K$26,($H$12:$H$26=$F52)/1)*'Inputs | General'!J$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,K$12:K$26,($H$12:$H$26=$F52)/1)*'Inputs | General'!J$29*'Inputs | General'!J$36","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,L$12:L$26,($H$12:$H$26=$F52)/1)*'Inputs | General'!K$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,L$12:L$26,($H$12:$H$26=$F52)/1)*'Inputs | General'!K$29*'Inputs | General'!K$36","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,M$12:M$26,($H$12:$H$26=$F52)/1)*'Inputs | General'!L$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,M$12:M$26,($H$12:$H$26=$F52)/1)*'Inputs | General'!L$29*'Inputs | General'!L$36","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,N$12:N$26,($H$12:$H$26=$F52)/1)*'Inputs | General'!M$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,N$12:N$26,($H$12:$H$26=$F52)/1)*'Inputs | General'!M$29*'Inputs | General'!M$36","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,O$12:O$26,($H$12:$H$26=$F52)/1)*'Inputs | General'!N$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,O$12:O$26,($H$12:$H$26=$F52)/1)*'Inputs | General'!N$29*'Inputs | General'!N$36","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D37","v":0},"$dollars","Nominal",null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,K$12:K$26,($H$12:$H$26=$F53)/1)*'Inputs | General'!J$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,K$12:K$26,($H$12:$H$26=$F53)/1)*'Inputs | General'!J$29*'Inputs | General'!J$36","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,L$12:L$26,($H$12:$H$26=$F53)/1)*'Inputs | General'!K$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,L$12:L$26,($H$12:$H$26=$F53)/1)*'Inputs | General'!K$29*'Inputs | General'!K$36","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,M$12:M$26,($H$12:$H$26=$F53)/1)*'Inputs | General'!L$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,M$12:M$26,($H$12:$H$26=$F53)/1)*'Inputs | General'!L$29*'Inputs | General'!L$36","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,N$12:N$26,($H$12:$H$26=$F53)/1)*'Inputs | General'!M$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,N$12:N$26,($H$12:$H$26=$F53)/1)*'Inputs | General'!M$29*'Inputs | General'!M$36","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,O$12:O$26,($H$12:$H$26=$F53)/1)*'Inputs | General'!N$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,O$12:O$26,($H$12:$H$26=$F53)/1)*'Inputs | General'!N$29*'Inputs | General'!N$36","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D38","v":0},"$dollars","Nominal",null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,K$12:K$26,($H$12:$H$26=$F54)/1)*'Inputs | General'!J$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,K$12:K$26,($H$12:$H$26=$F54)/1)*'Inputs | General'!J$29*'Inputs | General'!J$36","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,L$12:L$26,($H$12:$H$26=$F54)/1)*'Inputs | General'!K$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,L$12:L$26,($H$12:$H$26=$F54)/1)*'Inputs | General'!K$29*'Inputs | General'!K$36","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,M$12:M$26,($H$12:$H$26=$F54)/1)*'Inputs | General'!L$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,M$12:M$26,($H$12:$H$26=$F54)/1)*'Inputs | General'!L$29*'Inputs | General'!L$36","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,N$12:N$26,($H$12:$H$26=$F54)/1)*'Inputs | General'!M$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,N$12:N$26,($H$12:$H$26=$F54)/1)*'Inputs | General'!M$29*'Inputs | General'!M$36","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,O$12:O$26,($H$12:$H$26=$F54)/1)*'Inputs | General'!N$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,O$12:O$26,($H$12:$H$26=$F54)/1)*'Inputs | General'!N$29*'Inputs | General'!N$36","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D39","v":0},"$dollars","Nominal",null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,K$12:K$26,($H$12:$H$26=$F55)/1)*'Inputs | General'!J$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,K$12:K$26,($H$12:$H$26=$F55)/1)*'Inputs | General'!J$29*'Inputs | General'!J$36","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,L$12:L$26,($H$12:$H$26=$F55)/1)*'Inputs | General'!K$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,L$12:L$26,($H$12:$H$26=$F55)/1)*'Inputs | General'!K$29*'Inputs | General'!K$36","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,M$12:M$26,($H$12:$H$26=$F55)/1)*'Inputs | General'!L$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,M$12:M$26,($H$12:$H$26=$F55)/1)*'Inputs | General'!L$29*'Inputs | General'!L$36","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,N$12:N$26,($H$12:$H$26=$F55)/1)*'Inputs | General'!M$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,N$12:N$26,($H$12:$H$26=$F55)/1)*'Inputs | General'!M$29*'Inputs | General'!M$36","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$50:$K$64,O$12:O$26,($H$12:$H$26=$F55)/1)*'Inputs | General'!N$29+SUMPRODUCT('Input | Exit Fees'!$L$50:$L$64,O$12:O$26,($H$12:$H$26=$F55)/1)*'Inputs | General'!N$29*'Inputs | General'!N$36","v":0}]
[null,null,null,null,null,"Total","$dollars","Nominal",null,null,{"$f":"SUM(K46:K55)","v":209105655.58971599},{"$f":"SUM(L46:L55)","v":221266509.1639519},{"$f":"SUM(M46:M55)","v":234274923.91901854},{"$f":"SUM(N46:N55)","v":248092342.7206521},{"$f":"SUM(O46:O55)","v":262645082.10158914}]
[]
[]
[null,null,null,null,"Proportionate Volume-Weighted Costs",null,null,null,null,null,"Regulatory period"]
[null,null,null,null,null,"Exit Fee","Units",null,null,null,{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(K60,4)+1&\"-\"&RIGHT(K60,2)+1","v":"2027-28"},{"$f":"LEFT(L60,4)+1&\"-\"&RIGHT(L60,2)+1","v":"2028-29"},{"$f":"LEFT(M60,4)+1&\"-\"&RIGHT(M60,2)+1","v":"2029-30"},{"$f":"LEFT(N60,4)+1&\"-\"&RIGHT(N60,2)+1","v":"2030-31"}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D30","v":"Single Phase (inc. DC)"},"%",null,null,null,{"$f":"K46/K$56","v":0.71439576896273582},0.69365130666447428,0.67265880241786058,0.65256367828736739,0.63329334261783199]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D31","v":"Single Phase, Two Element"},"%",null,null,null,5.1492500311282011E-2,4.9479904485204451E-2,4.7533727784479979E-2,4.5667646553531761E-2,4.3877464338139015E-2]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D32","v":"Three Phase (inc. DC)"},"%",null,null,null,0.22105930781060124,0.24324608985846563,0.26562269777327463,0.287043827196239,0.30758483340481635]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D33","v":"Three Phase CT"},"%",null,null,null,1.3052422915381034E-2,1.3622698991855513E-2,1.418477202438481E-2,1.4724847962861744E-2,1.5244359639212671E-2]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D34","v":0},"%",null,null,null,0,0,0,0,0]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D35","v":0},"%",null,null,null,0,0,0,0,0]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D36","v":0},"%",null,null,null,0,0,0,0,0]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D37","v":0},"%",null,null,null,0,0,0,0,0]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D38","v":0},"%",null,null,null,0,0,0,0,0]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D39","v":0},"%",null,null,null,0,0,0,0,0]
[null,null,null,null,null,"Total","%",null,null,null,{"$f":"SUM(K61:K70)","v":1.0000000000000002},{"$f":"SUM(L61:L70)","v":0.99999999999999989},{"$f":"SUM(M61:M70)","v":1},{"$f":"SUM(N61:N70)","v":0.99999999999999989},{"$f":"SUM(O61:O70)","v":1}]
[{"$f":"PRODUCT(J72:O72)","v":1},null,null,null,null,null,null,null,null,null,{"$f":"(K71=1)/1","v":1},{"$f":"(L71=1)/1","v":1},{"$f":"(M71=1)/1","v":1},{"$f":"(N71=1)/1","v":1},{"$f":"(O71=1)/1","v":1}]
[]
[]
[null,null,null,null,"Allocated Meter RAB by Designated Exit Fee",null,null,null,null,null,"Regulatory period"]
[null,null,null,null,null,"Exit Fee","Units","Basis",null,null,{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(K76,4)+1&\"-\"&RIGHT(K76,2)+1","v":"2027-28"},{"$f":"LEFT(L76,4)+1&\"-\"&RIGHT(L76,2)+1","v":"2028-29"},{"$f":"LEFT(M76,4)+1&\"-\"&RIGHT(M76,2)+1","v":"2029-30"},{"$f":"LEFT(N76,4)+1&\"-\"&RIGHT(N76,2)+1","v":"2030-31"}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D30","v":"Single Phase (inc. DC)"},"$m","Nominal",null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$12:H$12)*'Calc | Exit Fees'!K61","v":30.83037737292835},{"$f":"AVERAGE('Input | Exit Fees'!H$12:I$12)*'Calc | Exit Fees'!L61","v":37.817395951663052},{"$f":"AVERAGE('Input | Exit Fees'!I$12:J$12)*'Calc | Exit Fees'!M61","v":50.779311070092753},{"$f":"AVERAGE('Input | Exit Fees'!J$12:K$12)*'Calc | Exit Fees'!N61","v":67.280444972027638},{"$f":"AVERAGE('Input | Exit Fees'!K$12:L$12)*'Calc | Exit Fees'!O61","v":85.915072982443576}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D31","v":"Single Phase, Two Element"},"$m","Nominal",null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$12:H$12)*'Calc | Exit Fees'!K62","v":2.2222041135230515},{"$f":"AVERAGE('Input | Exit Fees'!H$12:I$12)*'Calc | Exit Fees'!L62","v":2.6976106317241655},{"$f":"AVERAGE('Input | Exit Fees'!I$12:J$12)*'Calc | Exit Fees'!M62","v":3.5883421740905028},{"$f":"AVERAGE('Input | Exit Fees'!J$12:K$12)*'Calc | Exit Fees'!N62","v":4.7084134210636481},{"$f":"AVERAGE('Input | Exit Fees'!K$12:L$12)*'Calc | Exit Fees'!O62","v":5.9525898935126946}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D32","v":"Three Phase (inc. DC)"},"$m","Nominal",null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$12:H$12)*'Calc | Exit Fees'!K63","v":9.5400087426254956},{"$f":"AVERAGE('Input | Exit Fees'!H$12:I$12)*'Calc | Exit Fees'!L63","v":13.261610848980951},{"$f":"AVERAGE('Input | Exit Fees'!I$12:J$12)*'Calc | Exit Fees'!M63","v":20.051975160398506},{"$f":"AVERAGE('Input | Exit Fees'!J$12:K$12)*'Calc | Exit Fees'!N63","v":29.59471552404149},{"$f":"AVERAGE('Input | Exit Fees'!K$12:L$12)*'Calc | Exit Fees'!O63","v":41.728171815339479}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D33","v":"Three Phase CT"},"$m","Nominal",null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$12:H$12)*'Calc | Exit Fees'!K64","v":0.56328878416586114},{"$f":"AVERAGE('Input | Exit Fees'!H$12:I$12)*'Calc | Exit Fees'!L64","v":0.74270025408388085},{"$f":"AVERAGE('Input | Exit Fees'!I$12:J$12)*'Calc | Exit Fees'!M64","v":1.0708147258246006},{"$f":"AVERAGE('Input | Exit Fees'!J$12:K$12)*'Calc | Exit Fees'!N64","v":1.5181573171323886},{"$f":"AVERAGE('Input | Exit Fees'!K$12:L$12)*'Calc | Exit Fees'!O64","v":2.0681099623747969}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D34","v":0},"$m","Nominal",null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$12:H$12)*'Calc | Exit Fees'!K65","v":0},{"$f":"AVERAGE('Input | Exit Fees'!H$12:I$12)*'Calc | Exit Fees'!L65","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$12:J$12)*'Calc | Exit Fees'!M65","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$12:K$12)*'Calc | Exit Fees'!N65","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$12:L$12)*'Calc | Exit Fees'!O65","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D35","v":0},"$m","Nominal",null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$12:H$12)*'Calc | Exit Fees'!K66","v":0},{"$f":"AVERAGE('Input | Exit Fees'!H$12:I$12)*'Calc | Exit Fees'!L66","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$12:J$12)*'Calc | Exit Fees'!M66","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$12:K$12)*'Calc | Exit Fees'!N66","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$12:L$12)*'Calc | Exit Fees'!O66","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D36","v":0},"$m","Nominal",null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$12:H$12)*'Calc | Exit Fees'!K67","v":0},{"$f":"AVERAGE('Input | Exit Fees'!H$12:I$12)*'Calc | Exit Fees'!L67","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$12:J$12)*'Calc | Exit Fees'!M67","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$12:K$12)*'Calc | Exit Fees'!N67","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$12:L$12)*'Calc | Exit Fees'!O67","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D37","v":0},"$m","Nominal",null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$12:H$12)*'Calc | Exit Fees'!K68","v":0},{"$f":"AVERAGE('Input | Exit Fees'!H$12:I$12)*'Calc | Exit Fees'!L68","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$12:J$12)*'Calc | Exit Fees'!M68","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$12:K$12)*'Calc | Exit Fees'!N68","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$12:L$12)*'Calc | Exit Fees'!O68","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D38","v":0},"$m","Nominal",null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$12:H$12)*'Calc | Exit Fees'!K69","v":0},{"$f":"AVERAGE('Input | Exit Fees'!H$12:I$12)*'Calc | Exit Fees'!L69","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$12:J$12)*'Calc | Exit Fees'!M69","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$12:K$12)*'Calc | Exit Fees'!N69","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$12:L$12)*'Calc | Exit Fees'!O69","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D39","v":0},"$m","Nominal",null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$12:H$12)*'Calc | Exit Fees'!K70","v":0},{"$f":"AVERAGE('Input | Exit Fees'!H$12:I$12)*'Calc | Exit Fees'!L70","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$12:J$12)*'Calc | Exit Fees'!M70","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$12:K$12)*'Calc | Exit Fees'!N70","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$12:L$12)*'Calc | Exit Fees'!O70","v":0}]
[null,null,null,null,null,"Total","$m","Nominal",null,null,{"$f":"SUM(K77:K86)","v":43.15587901324276},{"$f":"SUM(L77:L86)","v":54.519317686452048},{"$f":"SUM(M77:M86)","v":75.490443130406376},{"$f":"SUM(N77:N86)","v":103.10173123426517},{"$f":"SUM(O77:O86)","v":135.66394465367054}]
[{"$f":"PRODUCT(J88:O88)","v":1},null,null,null,null,null,null,null,null,null,{"$f":"(ROUND(K87,6)=ROUND(AVERAGE('Input | Exit Fees'!H$9:I$9),6))/1","v":1},{"$f":"(ROUND(L87,6)=ROUND(AVERAGE('Input | Exit Fees'!I$9:J$9),6))/1","v":1},{"$f":"(ROUND(M87,6)=ROUND(AVERAGE('Input | Exit Fees'!J$9:K$9),6))/1","v":1},{"$f":"(ROUND(N87,6)=ROUND(AVERAGE('Input | Exit Fees'!K$9:L$9),6))/1","v":1},{"$f":"(ROUND(O87,6)=ROUND(AVERAGE('Input | Exit Fees'!L$9:M$9),6))/1","v":1}]
[]
[null,null,null,null,"Allocated Meter RAB by Designated Exit Fee Per Meter",null,null,null,null,null,"Regulatory period"]
[null,null,null,null,null,"Exit Fee","Units","Basis",null,null,{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(K91,4)+1&\"-\"&RIGHT(K91,2)+1","v":"2027-28"},{"$f":"LEFT(L91,4)+1&\"-\"&RIGHT(L91,2)+1","v":"2028-29"},{"$f":"LEFT(M91,4)+1&\"-\"&RIGHT(M91,2)+1","v":"2029-30"},{"$f":"LEFT(N91,4)+1&\"-\"&RIGHT(N91,2)+1","v":"2030-31"}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D30","v":"Single Phase (inc. DC)"},"$dollars","Nominal",null,null,{"$f":"IFERROR(K77*10^6/K31,0)","v":99.456798820826464},{"$f":"IFERROR(L77*10^6/L31,0)","v":122.36559224277035},165.03428447577409,219.64831992457712,281.76849950076138]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D31","v":"Single Phase, Two Element"},"$dollars","Nominal",null,null,107.8088535976664,132.59817952452772,178.76674891185343,237.82298829974508,304.9499522342042]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D32","v":"Three Phase (inc. DC)"},"$dollars","Nominal",null,null,139.57724227590458,171.55654462021408,231.10881617342793,307.18513454056216,393.53598119111996]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D33","v":"Three Phase CT"},"$dollars","Nominal",null,null,206.26558949728525,253.68700732252285,342.00600545421497,454.97277835981771,583.37050943586041]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D34","v":0},"$dollars","Nominal",null,null,0,0,0,0,0]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D35","v":0},"$dollars","Nominal",null,null,0,0,0,0,0]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D36","v":0},"$dollars","Nominal",null,null,0,0,0,0,0]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D37","v":0},"$dollars","Nominal",null,null,0,0,0,0,0]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D38","v":0},"$dollars","Nominal",null,null,0,0,0,0,0]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D39","v":0},"$dollars","Nominal",null,null,0,0,0,0,0]
[]
[null,"Calculations | Comms, IT, Inhouse software & Equity Raising Costs"]
[]
[null,null,"Calculation of Allocated Comms, IT, Inhouse software & Equity Raising Costs RAB by Designated Exit Fee"]
[]
[null,null,null,null,null,null,null,null,null,null,"Regulatory period"]
[null,null,null,null,null,"Exit Fee Component","Units","Basis",null,null,{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(K108,4)+1&\"-\"&RIGHT(K108,2)+1","v":"2027-28"},{"$f":"LEFT(L108,4)+1&\"-\"&RIGHT(L108,2)+1","v":"2028-29"},{"$f":"LEFT(M108,4)+1&\"-\"&RIGHT(M108,2)+1","v":"2029-30"},{"$f":"LEFT(N108,4)+1&\"-\"&RIGHT(N108,2)+1","v":"2030-31"}]
[null,null,null,null,null,"Comms, IT, Inhouse software & Equity Raising Costs RAB per meter","$dollars","Nominal",null,null,{"$f":"(AVERAGE('Input | Exit Fees'!G$19:H$19)*10^6)/'Calc | Exit Fees'!K$41","v":22.714161539740974},{"$f":"(AVERAGE('Input | Exit Fees'!H$19:I$19)*10^6)/'Calc | Exit Fees'!L$41","v":32.996028721968216},{"$f":"(AVERAGE('Input | Exit Fees'!I$19:J$19)*10^6)/'Calc | Exit Fees'!M$41","v":36.864772935679383},{"$f":"(AVERAGE('Input | Exit Fees'!J$19:K$19)*10^6)/'Calc | Exit Fees'!N$41","v":41.118154502249979},{"$f":"(AVERAGE('Input | Exit Fees'!K$19:L$19)*10^6)/'Calc | Exit Fees'!O$41","v":44.101025978888529}]
[]
[]
[]
[null,"Calculations | Exit Fees with Component Detail"]
[]
[null,null,null,null,null,"Base Year","Regulatory period"]
[null,null,null,null,null,null,"Tariff ($/year) (Nominal)"]
[null,null,"No.","Exit Fee Name","Component","2025-26","2026-27","2027-28","2028-29","2029-30","2030-31"]
[null,null,1,{"$f":"'Input | Exit Fees'!D30","v":"Single Phase (inc. DC)"}]
[null,null,null,null,"Meter RAB",null,{"$f":"IF($D118=0,0,SUMIFS('Calc | Exit Fees'!K$92:K$101,'Input | Exit Fees'!$D$30:$D$39,$D118))","v":99.456798820826464},{"$f":"IF($D118=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$30:$D$39,$D118))","v":122.36559224277035},{"$f":"IF($D118=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$30:$D$39,$D118))","v":165.03428447577409},{"$f":"IF($D118=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$30:$D$39,$D118))","v":219.64831992457712},{"$f":"IF($D118=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$30:$D$39,$D118))","v":281.76849950076138}]
[null,null,null,null,"Comms, IT, Inhouse software & Equity Raising Costs",null,{"$f":"IF($D118=0,0,'Calc | Exit Fees'!K$109)","v":22.714161539740974},{"$f":"IF($D118=0,0,'Calc | Exit Fees'!L$109)","v":32.996028721968216},{"$f":"IF($D118=0,0,'Calc | Exit Fees'!M$109)","v":36.864772935679383},{"$f":"IF($D118=0,0,'Calc | Exit Fees'!N$109)","v":41.118154502249979},{"$f":"IF($D118=0,0,'Calc | Exit Fees'!O$109)","v":44.101025978888529}]
[null,null,null,null,"Admin cost",null,{"$f":"IF($D118=0,0,'Input | Exit Fees'!K$120)","v":78.113744129225978},{"$f":"IF($D118=0,0,'Input | Exit Fees'!L$120)","v":83.25631344010452},{"$f":"IF($D118=0,0,'Input | Exit Fees'!M$120)","v":88.085563423024794},{"$f":"IF($D118=0,0,'Input | Exit Fees'!N$120)","v":92.591868852374347},{"$f":"IF($D118=0,0,'Input | Exit Fees'!O$120)","v":97.342350407363242}]
[null,null,null,null,"Tax allowance",null,{"$f":"IF($D118=0,0,'Calc | Tax Allowance'!G29)","v":6.2548917245715785},{"$f":"IF($D118=0,0,'Calc | Tax Allowance'!H29)","v":6.7726704048095598},{"$f":"IF($D118=0,0,'Calc | Tax Allowance'!I29)","v":7.8125051804594676},{"$f":"IF($D118=0,0,'Calc | Tax Allowance'!J29)","v":9.3020405735460105},{"$f":"IF($D118=0,0,'Calc | Tax Allowance'!K29)","v":10.794900095374286}]
[null,null,null,null,"TOTAL exit fee",{"$f":"IF(D118=0,0,'Input | Exit Fees'!G30)","v":191.64},{"$f":"SUM(G119:G122)","v":206.53959621436496},{"$f":"SUM(H119:H122)","v":245.39060480965264},{"$f":"SUM(I119:I122)","v":297.79712601493776},{"$f":"SUM(J119:J122)","v":362.66038385274749},{"$f":"SUM(K119:K122)","v":434.00677598238741}]
[null,null,2,{"$f":"'Input | Exit Fees'!D31","v":"Single Phase, Two Element"}]
[null,null,null,null,{"$f":"IF($D124=0,\"\",E$119)","v":"Meter RAB"},null,{"$f":"IF($D124=0,0,SUMIFS('Calc | Exit Fees'!K$92:K$101,'Input | Exit Fees'!$D$30:$D$39,$D124))","v":107.8088535976664},{"$f":"IF($D124=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$30:$D$39,$D124))","v":132.59817952452772},{"$f":"IF($D124=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$30:$D$39,$D124))","v":178.76674891185343},{"$f":"IF($D124=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$30:$D$39,$D124))","v":237.82298829974508},{"$f":"IF($D124=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$30:$D$39,$D124))","v":304.9499522342042}]
[null,null,null,null,{"$f":"IF($D124=0,\"\",E$120)","v":"Comms, IT, Inhouse software & Equity Raising Costs"},null,{"$f":"IF($D124=0,0,'Calc | Exit Fees'!K$109)","v":22.714161539740974},{"$f":"IF($D124=0,0,'Calc | Exit Fees'!L$109)","v":32.996028721968216},{"$f":"IF($D124=0,0,'Calc | Exit Fees'!M$109)","v":36.864772935679383},{"$f":"IF($D124=0,0,'Calc | Exit Fees'!N$109)","v":41.118154502249979},{"$f":"IF($D124=0,0,'Calc | Exit Fees'!O$109)","v":44.101025978888529}]
[null,null,null,null,{"$f":"IF($D124=0,\"\",E$121)","v":"Admin cost"},null,{"$f":"IF($D124=0,0,'Input | Exit Fees'!K$120)","v":78.113744129225978},{"$f":"IF($D124=0,0,'Input | Exit Fees'!L$120)","v":83.25631344010452},{"$f":"IF($D124=0,0,'Input | Exit Fees'!M$120)","v":88.085563423024794},{"$f":"IF($D124=0,0,'Input | Exit Fees'!N$120)","v":92.591868852374347},{"$f":"IF($D124=0,0,'Input | Exit Fees'!O$120)","v":97.342350407363242}]
[null,null,null,null,{"$f":"IF($D124=0,\"\",E$122)","v":"Tax allowance"},null,{"$f":"IF($D124=0,0,'Calc | Tax Allowance'!G50)","v":6.6733810038081032},{"$f":"IF($D124=0,0,'Calc | Tax Allowance'!H50)","v":7.2033339229409279},{"$f":"IF($D124=0,0,'Calc | Tax Allowance'!I50)","v":8.2798030049868423},{"$f":"IF($D124=0,0,'Calc | Tax Allowance'!J50)","v":9.8424788387556976},{"$f":"IF($D124=0,0,'Calc | Tax Allowance'!K50)","v":11.420844127277075}]
[null,null,null,null,{"$f":"IF($D124=0,\"\",E$123)","v":"TOTAL exit fee"},{"$f":"IF(D124=0,0,'Input | Exit Fees'!G31)","v":191.64},{"$f":"SUM(G125:G128)","v":215.31014027044148},{"$f":"SUM(H125:H128)","v":256.05385560954142},{"$f":"SUM(I125:I128)","v":311.99688827554445},{"$f":"SUM(J125:J128)","v":381.37549049312508},{"$f":"SUM(K125:K128)","v":457.81417274773304}]
[null,null,3,{"$f":"'Input | Exit Fees'!D32","v":"Three Phase (inc. DC)"}]
[null,null,null,null,{"$f":"IF($D130=0,\"\",E$119)","v":"Meter RAB"},null,{"$f":"IF($D130=0,0,SUMIFS('Calc | Exit Fees'!K$92:K$101,'Input | Exit Fees'!$D$30:$D$39,$D130))","v":139.57724227590458},{"$f":"IF($D130=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$30:$D$39,$D130))","v":171.55654462021408},{"$f":"IF($D130=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$30:$D$39,$D130))","v":231.10881617342793},{"$f":"IF($D130=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$30:$D$39,$D130))","v":307.18513454056216},{"$f":"IF($D130=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$30:$D$39,$D130))","v":393.53598119111996}]
[null,null,null,null,{"$f":"IF($D130=0,\"\",E$120)","v":"Comms, IT, Inhouse software & Equity Raising Costs"},null,{"$f":"IF($D130=0,0,'Calc | Exit Fees'!K$109)","v":22.714161539740974},{"$f":"IF($D130=0,0,'Calc | Exit Fees'!L$109)","v":32.996028721968216},{"$f":"IF($D130=0,0,'Calc | Exit Fees'!M$109)","v":36.864772935679383},{"$f":"IF($D130=0,0,'Calc | Exit Fees'!N$109)","v":41.118154502249979},{"$f":"IF($D130=0,0,'Calc | Exit Fees'!O$109)","v":44.101025978888529}]
[null,null,null,null,{"$f":"IF($D130=0,\"\",E$121)","v":"Admin cost"},null,{"$f":"IF($D130=0,0,'Input | Exit Fees'!K$120)","v":78.113744129225978},{"$f":"IF($D130=0,0,'Input | Exit Fees'!L$120)","v":83.25631344010452},{"$f":"IF($D130=0,0,'Input | Exit Fees'!M$120)","v":88.085563423024794},{"$f":"IF($D130=0,0,'Input | Exit Fees'!N$120)","v":92.591868852374347},{"$f":"IF($D130=0,0,'Input | Exit Fees'!O$120)","v":97.342350407363242}]
[null,null,null,null,{"$f":"IF($D130=0,\"\",E$122)","v":"Tax allowance"},null,{"$f":"IF($D130=0,0,'Calc | Tax Allowance'!G71)","v":8.2651725372313987},{"$f":"IF($D130=0,0,'Calc | Tax Allowance'!H71)","v":8.8429922137298203},{"$f":"IF($D130=0,0,'Calc | Tax Allowance'!I71)","v":10.060935173684637},{"$f":"IF($D130=0,0,'Calc | Tax Allowance'!J71)","v":11.905017599398219},{"$f":"IF($D130=0,0,'Calc | Tax Allowance'!K71)","v":13.81283813960891}]
[null,null,null,null,{"$f":"IF($D130=0,\"\",E$123)","v":"TOTAL exit fee"},{"$f":"IF(D130=0,0,'Input | Exit Fees'!G32)","v":191.64},{"$f":"SUM(G131:G134)","v":248.67032048210294},{"$f":"SUM(H131:H134)","v":296.65187899601665},{"$f":"SUM(I131:I134)","v":366.12008770581673},{"$f":"SUM(J131:J134)","v":452.80017549458466},{"$f":"SUM(K131:K134)","v":548.79219571698059}]
[null,null,4,{"$f":"'Input | Exit Fees'!D33","v":"Three Phase CT"}]
[null,null,null,null,{"$f":"IF($D136=0,\"\",E$119)","v":"Meter RAB"},null,{"$f":"IF($D136=0,0,SUMIFS('Calc | Exit Fees'!K$92:K$101,'Input | Exit Fees'!$D$30:$D$39,$D136))","v":206.26558949728525},{"$f":"IF($D136=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$30:$D$39,$D136))","v":253.68700732252285},{"$f":"IF($D136=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$30:$D$39,$D136))","v":342.00600545421497},{"$f":"IF($D136=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$30:$D$39,$D136))","v":454.97277835981771},{"$f":"IF($D136=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$30:$D$39,$D136))","v":583.37050943586041}]
[null,null,null,null,{"$f":"IF($D136=0,\"\",E$120)","v":"Comms, IT, Inhouse software & Equity Raising Costs"},null,{"$f":"IF($D136=0,0,'Calc | Exit Fees'!K$109)","v":22.714161539740974},{"$f":"IF($D136=0,0,'Calc | Exit Fees'!L$109)","v":32.996028721968216},{"$f":"IF($D136=0,0,'Calc | Exit Fees'!M$109)","v":36.864772935679383},{"$f":"IF($D136=0,0,'Calc | Exit Fees'!N$109)","v":41.118154502249979},{"$f":"IF($D136=0,0,'Calc | Exit Fees'!O$109)","v":44.101025978888529}]
[null,null,null,null,{"$f":"IF($D136=0,\"\",E$121)","v":"Admin cost"},null,{"$f":"IF($D136=0,0,'Input | Exit Fees'!K$120)","v":78.113744129225978},{"$f":"IF($D136=0,0,'Input | Exit Fees'!L$120)","v":83.25631344010452},{"$f":"IF($D136=0,0,'Input | Exit Fees'!M$120)","v":88.085563423024794},{"$f":"IF($D136=0,0,'Input | Exit Fees'!N$120)","v":92.591868852374347},{"$f":"IF($D136=0,0,'Input | Exit Fees'!O$120)","v":97.342350407363242}]
[null,null,null,null,{"$f":"IF($D136=0,\"\",E$122)","v":"Tax allowance"},null,{"$f":"IF($D136=0,0,'Calc | Tax Allowance'!G92)","v":11.60666862506112},{"$f":"IF($D136=0,0,'Calc | Tax Allowance'!H92)","v":12.299654056838833},{"$f":"IF($D136=0,0,'Calc | Tax Allowance'!I92)","v":13.834621647684191},{"$f":"IF($D136=0,0,'Calc | Tax Allowance'!J92)","v":16.299601104109239},{"$f":"IF($D136=0,0,'Calc | Tax Allowance'!K92)","v":18.938737338861941}]
[null,null,null,null,{"$f":"IF($D136=0,\"\",E$123)","v":"TOTAL exit fee"},{"$f":"IF(D136=0,0,'Input | Exit Fees'!G33)","v":191.64},{"$f":"SUM(G137:G140)","v":318.70016379131329},{"$f":"SUM(H137:H140)","v":382.23900354143444},{"$f":"SUM(I137:I140)","v":480.79096346060328},{"$f":"SUM(J137:J140)","v":604.98240281855124},{"$f":"SUM(K137:K140)","v":743.75262316097417}]
[null,null,5,{"$f":"'Input | Exit Fees'!D34","v":0}]
[null,null,null,null,{"$f":"IF($D142=0,\"\",E$119)","v":""},null,{"$f":"IF($D142=0,0,SUMIFS('Calc | Exit Fees'!K$92:K$101,'Input | Exit Fees'!$D$30:$D$39,$D142))","v":0},{"$f":"IF($D142=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$30:$D$39,$D142))","v":0},{"$f":"IF($D142=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$30:$D$39,$D142))","v":0},{"$f":"IF($D142=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$30:$D$39,$D142))","v":0},{"$f":"IF($D142=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$30:$D$39,$D142))","v":0}]
[null,null,null,null,{"$f":"IF($D142=0,\"\",E$120)","v":""},null,{"$f":"IF($D142=0,0,'Calc | Exit Fees'!K$109)","v":0},{"$f":"IF($D142=0,0,'Calc | Exit Fees'!L$109)","v":0},{"$f":"IF($D142=0,0,'Calc | Exit Fees'!M$109)","v":0},{"$f":"IF($D142=0,0,'Calc | Exit Fees'!N$109)","v":0},{"$f":"IF($D142=0,0,'Calc | Exit Fees'!O$109)","v":0}]
[null,null,null,null,{"$f":"IF($D142=0,\"\",E$121)","v":""},null,{"$f":"IF($D142=0,0,'Input | Exit Fees'!K$120)","v":0},{"$f":"IF($D142=0,0,'Input | Exit Fees'!L$120)","v":0},{"$f":"IF($D142=0,0,'Input | Exit Fees'!M$120)","v":0},{"$f":"IF($D142=0,0,'Input | Exit Fees'!N$120)","v":0},{"$f":"IF($D142=0,0,'Input | Exit Fees'!O$120)","v":0}]
[null,null,null,null,{"$f":"IF($D142=0,\"\",E$122)","v":""}]
[null,null,null,null,{"$f":"IF($D142=0,\"\",E$123)","v":""},{"$f":"IF(D142=0,0,'Input | Exit Fees'!G34)","v":0},{"$f":"SUM(G143:G146)","v":0},{"$f":"SUM(H143:H146)","v":0},{"$f":"SUM(I143:I146)","v":0},{"$f":"SUM(J143:J146)","v":0},{"$f":"SUM(K143:K146)","v":0}]
[null,null,6,{"$f":"'Input | Exit Fees'!D35","v":0}]
[null,null,null,null,{"$f":"IF($D148=0,\"\",E$119)","v":""},null,{"$f":"IF($D148=0,0,SUMIFS('Calc | Exit Fees'!K$92:K$101,'Input | Exit Fees'!$D$30:$D$39,$D148))","v":0},{"$f":"IF($D148=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$30:$D$39,$D148))","v":0},{"$f":"IF($D148=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$30:$D$39,$D148))","v":0},{"$f":"IF($D148=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$30:$D$39,$D148))","v":0},{"$f":"IF($D148=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$30:$D$39,$D148))","v":0}]
[null,null,null,null,{"$f":"IF($D148=0,\"\",E$120)","v":""},null,{"$f":"IF($D148=0,0,'Calc | Exit Fees'!K$109)","v":0},{"$f":"IF($D148=0,0,'Calc | Exit Fees'!L$109)","v":0},{"$f":"IF($D148=0,0,'Calc | Exit Fees'!M$109)","v":0},{"$f":"IF($D148=0,0,'Calc | Exit Fees'!N$109)","v":0},{"$f":"IF($D148=0,0,'Calc | Exit Fees'!O$109)","v":0}]
[null,null,null,null,{"$f":"IF($D148=0,\"\",E$121)","v":""},null,{"$f":"IF($D148=0,0,'Input | Exit Fees'!K$120)","v":0},{"$f":"IF($D148=0,0,'Input | Exit Fees'!L$120)","v":0},{"$f":"IF($D148=0,0,'Input | Exit Fees'!M$120)","v":0},{"$f":"IF($D148=0,0,'Input | Exit Fees'!N$120)","v":0},{"$f":"IF($D148=0,0,'Input | Exit Fees'!O$120)","v":0}]
[null,null,null,null,{"$f":"IF($D148=0,\"\",E$122)","v":""}]
[null,null,null,null,{"$f":"IF($D148=0,\"\",E$123)","v":""},{"$f":"IF(D148=0,0,'Input | Exit Fees'!G35)","v":0},{"$f":"SUM(G149:G152)","v":0},{"$f":"SUM(H149:H152)","v":0},{"$f":"SUM(I149:I152)","v":0},{"$f":"SUM(J149:J152)","v":0},{"$f":"SUM(K149:K152)","v":0}]
[null,null,7,{"$f":"'Input | Exit Fees'!D36","v":0}]
[null,null,null,null,{"$f":"IF($D154=0,\"\",E$119)","v":""},null,{"$f":"IF($D154=0,0,SUMIFS('Calc | Exit Fees'!K$92:K$101,'Input | Exit Fees'!$D$30:$D$39,$D154))","v":0},{"$f":"IF($D154=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$30:$D$39,$D154))","v":0},{"$f":"IF($D154=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$30:$D$39,$D154))","v":0},{"$f":"IF($D154=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$30:$D$39,$D154))","v":0},{"$f":"IF($D154=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$30:$D$39,$D154))","v":0}]
[null,null,null,null,{"$f":"IF($D154=0,\"\",E$120)","v":""},null,{"$f":"IF($D154=0,0,'Calc | Exit Fees'!K$109)","v":0},{"$f":"IF($D154=0,0,'Calc | Exit Fees'!L$109)","v":0},{"$f":"IF($D154=0,0,'Calc | Exit Fees'!M$109)","v":0},{"$f":"IF($D154=0,0,'Calc | Exit Fees'!N$109)","v":0},{"$f":"IF($D154=0,0,'Calc | Exit Fees'!O$109)","v":0}]
[null,null,null,null,{"$f":"IF($D154=0,\"\",E$121)","v":""},null,{"$f":"IF($D154=0,0,'Input | Exit Fees'!K$120)","v":0},{"$f":"IF($D154=0,0,'Input | Exit Fees'!L$120)","v":0},{"$f":"IF($D154=0,0,'Input | Exit Fees'!M$120)","v":0},{"$f":"IF($D154=0,0,'Input | Exit Fees'!N$120)","v":0},{"$f":"IF($D154=0,0,'Input | Exit Fees'!O$120)","v":0}]
[null,null,null,null,{"$f":"IF($D154=0,\"\",E$122)","v":""}]
[null,null,null,null,{"$f":"IF($D154=0,\"\",E$123)","v":""},{"$f":"IF(D154=0,0,'Input | Exit Fees'!G36)","v":0},{"$f":"SUM(G155:G158)","v":0},{"$f":"SUM(H155:H158)","v":0},{"$f":"SUM(I155:I158)","v":0},{"$f":"SUM(J155:J158)","v":0},{"$f":"SUM(K155:K158)","v":0}]
[null,null,8,{"$f":"'Input | Exit Fees'!D37","v":0}]
[null,null,null,null,{"$f":"IF($D160=0,\"\",E$119)","v":""},null,{"$f":"IF($D160=0,0,SUMIFS('Calc | Exit Fees'!K$92:K$101,'Input | Exit Fees'!$D$30:$D$39,$D160))","v":0},{"$f":"IF($D160=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$30:$D$39,$D160))","v":0},{"$f":"IF($D160=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$30:$D$39,$D160))","v":0},{"$f":"IF($D160=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$30:$D$39,$D160))","v":0},{"$f":"IF($D160=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$30:$D$39,$D160))","v":0}]
[null,null,null,null,{"$f":"IF($D160=0,\"\",E$120)","v":""},null,{"$f":"IF($D160=0,0,'Calc | Exit Fees'!K$109)","v":0},{"$f":"IF($D160=0,0,'Calc | Exit Fees'!L$109)","v":0},{"$f":"IF($D160=0,0,'Calc | Exit Fees'!M$109)","v":0},{"$f":"IF($D160=0,0,'Calc | Exit Fees'!N$109)","v":0},{"$f":"IF($D160=0,0,'Calc | Exit Fees'!O$109)","v":0}]
[null,null,null,null,{"$f":"IF($D160=0,\"\",E$121)","v":""},null,{"$f":"IF($D160=0,0,'Input | Exit Fees'!K$120)","v":0},{"$f":"IF($D160=0,0,'Input | Exit Fees'!L$120)","v":0},{"$f":"IF($D160=0,0,'Input | Exit Fees'!M$120)","v":0},{"$f":"IF($D160=0,0,'Input | Exit Fees'!N$120)","v":0},{"$f":"IF($D160=0,0,'Input | Exit Fees'!O$120)","v":0}]
[null,null,null,null,{"$f":"IF($D160=0,\"\",E$122)","v":""}]
[null,null,null,null,{"$f":"IF($D160=0,\"\",E$123)","v":""},{"$f":"IF(D160=0,0,'Input | Exit Fees'!G37)","v":0},{"$f":"SUM(G161:G164)","v":0},{"$f":"SUM(H161:H164)","v":0},{"$f":"SUM(I161:I164)","v":0},{"$f":"SUM(J161:J164)","v":0},{"$f":"SUM(K161:K164)","v":0}]
[null,null,9,{"$f":"'Input | Exit Fees'!D38","v":0}]
[null,null,null,null,{"$f":"IF($D166=0,\"\",E$119)","v":""},null,{"$f":"IF($D166=0,0,SUMIFS('Calc | Exit Fees'!K$92:K$101,'Input | Exit Fees'!$D$30:$D$39,$D166))","v":0},{"$f":"IF($D166=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$30:$D$39,$D166))","v":0},{"$f":"IF($D166=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$30:$D$39,$D166))","v":0},{"$f":"IF($D166=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$30:$D$39,$D166))","v":0},{"$f":"IF($D166=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$30:$D$39,$D166))","v":0}]
[null,null,null,null,{"$f":"IF($D166=0,\"\",E$120)","v":""},null,{"$f":"IF($D166=0,0,'Calc | Exit Fees'!K$109)","v":0},{"$f":"IF($D166=0,0,'Calc | Exit Fees'!L$109)","v":0},{"$f":"IF($D166=0,0,'Calc | Exit Fees'!M$109)","v":0},{"$f":"IF($D166=0,0,'Calc | Exit Fees'!N$109)","v":0},{"$f":"IF($D166=0,0,'Calc | Exit Fees'!O$109)","v":0}]
[null,null,null,null,{"$f":"IF($D166=0,\"\",E$121)","v":""},null,{"$f":"IF($D166=0,0,'Input | Exit Fees'!K$120)","v":0},{"$f":"IF($D166=0,0,'Input | Exit Fees'!L$120)","v":0},{"$f":"IF($D166=0,0,'Input | Exit Fees'!M$120)","v":0},{"$f":"IF($D166=0,0,'Input | Exit Fees'!N$120)","v":0},{"$f":"IF($D166=0,0,'Input | Exit Fees'!O$120)","v":0}]
[null,null,null,null,{"$f":"IF($D166=0,\"\",E$122)","v":""}]
[null,null,null,null,{"$f":"IF($D166=0,\"\",E$123)","v":""},{"$f":"IF(D166=0,0,'Input | Exit Fees'!G38)","v":0},{"$f":"SUM(G167:G170)","v":0},{"$f":"SUM(H167:H170)","v":0},{"$f":"SUM(I167:I170)","v":0},{"$f":"SUM(J167:J170)","v":0},{"$f":"SUM(K167:K170)","v":0}]
[null,null,10,{"$f":"'Input | Exit Fees'!D39","v":0}]
[null,null,null,null,{"$f":"IF($D172=0,\"\",E$119)","v":""},null,{"$f":"IF($D172=0,0,SUMIFS('Calc | Exit Fees'!K$92:K$101,'Input | Exit Fees'!$D$30:$D$39,$D172))","v":0},{"$f":"IF($D172=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$30:$D$39,$D172))","v":0},{"$f":"IF($D172=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$30:$D$39,$D172))","v":0},{"$f":"IF($D172=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$30:$D$39,$D172))","v":0},{"$f":"IF($D172=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$30:$D$39,$D172))","v":0}]
[null,null,null,null,{"$f":"IF($D172=0,\"\",E$120)","v":""},null,{"$f":"IF($D172=0,0,'Calc | Exit Fees'!K$109)","v":0},{"$f":"IF($D172=0,0,'Calc | Exit Fees'!L$109)","v":0},{"$f":"IF($D172=0,0,'Calc | Exit Fees'!M$109)","v":0},{"$f":"IF($D172=0,0,'Calc | Exit Fees'!N$109)","v":0},{"$f":"IF($D172=0,0,'Calc | Exit Fees'!O$109)","v":0}]
[null,null,null,null,{"$f":"IF($D172=0,\"\",E$121)","v":""},null,{"$f":"IF($D172=0,0,'Input | Exit Fees'!K$120)","v":0},{"$f":"IF($D172=0,0,'Input | Exit Fees'!L$120)","v":0},{"$f":"IF($D172=0,0,'Input | Exit Fees'!M$120)","v":0},{"$f":"IF($D172=0,0,'Input | Exit Fees'!N$120)","v":0},{"$f":"IF($D172=0,0,'Input | Exit Fees'!O$120)","v":0}]
[null,null,null,null,{"$f":"IF($D172=0,\"\",E$122)","v":""}]
[null,null,null,null,{"$f":"IF($D172=0,\"\",E$123)","v":""},{"$f":"IF(D172=0,0,'Input | Exit Fees'!G39)","v":0},{"$f":"SUM(G173:G176)","v":0},{"$f":"SUM(H173:H176)","v":0},{"$f":"SUM(I173:I176)","v":0},{"$f":"SUM(J173:J176)","v":0},{"$f":"SUM(K173:K176)","v":0}]
[]
[]
[null,"CALCULATION | Meters (TAB)"]
[]
[null,"Calculation of Allocated Meters TAB by Designated Exit Fee"]
[]
[null,null,null,null,"Allocated Meter TAB by Designated Exit Fee",null,null,null,null,null,"Regulatory period"]
[null,null,null,null,null,"Exit Fee","Units","Basis",null,null,{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(K185,4)+1&\"-\"&RIGHT(K185,2)+1","v":"2027-28"},{"$f":"LEFT(L185,4)+1&\"-\"&RIGHT(L185,2)+1","v":"2028-29"},{"$f":"LEFT(M185,4)+1&\"-\"&RIGHT(M185,2)+1","v":"2029-30"},{"$f":"LEFT(N185,4)+1&\"-\"&RIGHT(N185,2)+1","v":"2030-31"}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D30","v":"Single Phase (inc. DC)"},"$m","Nominal",null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$130:H$130)*'Calc | Exit Fees'!K61","v":20.400041629992998},{"$f":"AVERAGE('Input | Exit Fees'!H$130:I$130)*'Calc | Exit Fees'!L61","v":27.07075618103568},{"$f":"AVERAGE('Input | Exit Fees'!I$130:J$130)*'Calc | Exit Fees'!M61","v":39.112275407331623},{"$f":"AVERAGE('Input | Exit Fees'!J$130:K$130)*'Calc | Exit Fees'!N61","v":53.772263207903649},{"$f":"AVERAGE('Input | Exit Fees'!K$130:L$130)*'Calc | Exit Fees'!O61","v":70.251434096253959}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D31","v":"Single Phase, Two Element"},"$m","Nominal",null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$130:H$130)*'Calc | Exit Fees'!K62","v":1.4704022554721679},{"$f":"AVERAGE('Input | Exit Fees'!H$130:I$130)*'Calc | Exit Fees'!L62","v":1.9310255993330265},{"$f":"AVERAGE('Input | Exit Fees'!I$130:J$130)*'Calc | Exit Fees'!M62","v":2.7638860081233174},{"$f":"AVERAGE('Input | Exit Fees'!J$130:K$130)*'Calc | Exit Fees'!N62","v":3.7630851858117604},{"$f":"AVERAGE('Input | Exit Fees'!K$130:L$130)*'Calc | Exit Fees'!O62","v":4.8673412253468902}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D32","v":"Three Phase (inc. DC)"},"$m","Nominal",null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$130:H$130)*'Calc | Exit Fees'!K63","v":6.3124941075468932},{"$f":"AVERAGE('Input | Exit Fees'!H$130:I$130)*'Calc | Exit Fees'!L63","v":9.4930342194741613},{"$f":"AVERAGE('Input | Exit Fees'!I$130:J$130)*'Calc | Exit Fees'!M63","v":15.444840790610719},{"$f":"AVERAGE('Input | Exit Fees'!J$130:K$130)*'Calc | Exit Fees'!N63","v":23.652858321365407},{"$f":"AVERAGE('Input | Exit Fees'!K$130:L$130)*'Calc | Exit Fees'!O63","v":34.120484456103725}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D33","v":"Three Phase CT"},"$m","Nominal",null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$130:H$130)*'Calc | Exit Fees'!K64","v":0.37272053169163827},{"$f":"AVERAGE('Input | Exit Fees'!H$130:I$130)*'Calc | Exit Fees'!L64","v":0.5316457410128429},{"$f":"AVERAGE('Input | Exit Fees'!I$130:J$130)*'Calc | Exit Fees'!M64","v":0.8247847318934014},{"$f":"AVERAGE('Input | Exit Fees'!J$130:K$130)*'Calc | Exit Fees'!N64","v":1.2133504004289497},{"$f":"AVERAGE('Input | Exit Fees'!K$130:L$130)*'Calc | Exit Fees'!O64","v":1.6910617157395453}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D34","v":0},"$m","Nominal",null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$130:H$130)*'Calc | Exit Fees'!K65","v":0},{"$f":"AVERAGE('Input | Exit Fees'!H$130:I$130)*'Calc | Exit Fees'!L65","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$130:J$130)*'Calc | Exit Fees'!M65","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$130:K$130)*'Calc | Exit Fees'!N65","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$130:L$130)*'Calc | Exit Fees'!O65","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D35","v":0},"$m","Nominal",null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$130:H$130)*'Calc | Exit Fees'!K66","v":0},{"$f":"AVERAGE('Input | Exit Fees'!H$130:I$130)*'Calc | Exit Fees'!L66","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$130:J$130)*'Calc | Exit Fees'!M66","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$130:K$130)*'Calc | Exit Fees'!N66","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$130:L$130)*'Calc | Exit Fees'!O66","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D36","v":0},"$m","Nominal",null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$130:H$130)*'Calc | Exit Fees'!K67","v":0},{"$f":"AVERAGE('Input | Exit Fees'!H$130:I$130)*'Calc | Exit Fees'!L67","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$130:J$130)*'Calc | Exit Fees'!M67","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$130:K$130)*'Calc | Exit Fees'!N67","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$130:L$130)*'Calc | Exit Fees'!O67","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D37","v":0},"$m","Nominal",null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$130:H$130)*'Calc | Exit Fees'!K68","v":0},{"$f":"AVERAGE('Input | Exit Fees'!H$130:I$130)*'Calc | Exit Fees'!L68","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$130:J$130)*'Calc | Exit Fees'!M68","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$130:K$130)*'Calc | Exit Fees'!N68","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$130:L$130)*'Calc | Exit Fees'!O68","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D38","v":0},"$m","Nominal",null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$130:H$130)*'Calc | Exit Fees'!K69","v":0},{"$f":"AVERAGE('Input | Exit Fees'!H$130:I$130)*'Calc | Exit Fees'!L69","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$130:J$130)*'Calc | Exit Fees'!M69","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$130:K$130)*'Calc | Exit Fees'!N69","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$130:L$130)*'Calc | Exit Fees'!O69","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D39","v":0},"$m","Nominal",null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$130:H$130)*'Calc | Exit Fees'!K70","v":0},{"$f":"AVERAGE('Input | Exit Fees'!H$130:I$130)*'Calc | Exit Fees'!L70","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$130:J$130)*'Calc | Exit Fees'!M70","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$130:K$130)*'Calc | Exit Fees'!N70","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$130:L$130)*'Calc | Exit Fees'!O70","v":0}]
[null,null,null,null,null,"Total","$m","Nominal",null,null,{"$f":"SUM(K186:K195)","v":28.555658524703695},{"$f":"SUM(L186:L195)","v":39.026461740855716},{"$f":"SUM(M186:M195)","v":58.145786937959059},{"$f":"SUM(N186:N195)","v":82.40155711550976},{"$f":"SUM(O186:O195)","v":110.93032149344413}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"(K196=AVERAGE('Input | Exit Fees'!G$130:H$130))/1","v":1},{"$f":"(L196=AVERAGE('Input | Exit Fees'!H$130:I$130))/1","v":1},{"$f":"(M196=AVERAGE('Input | Exit Fees'!I$130:J$130))/1","v":1},{"$f":"(N196=AVERAGE('Input | Exit Fees'!J$130:K$130))/1","v":1},{"$f":"(O196=AVERAGE('Input | Exit Fees'!K$130:L$130))/1","v":1}]
[]
[null,null,null,null,"Allocated Meter TAB by Designated Exit Fee Per Meter",null,null,null,null,null,"Regulatory period"]
[null,null,null,null,null,"Exit Fee","Units","Basis",null,null,{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(K200,4)+1&\"-\"&RIGHT(K200,2)+1","v":"2027-28"},{"$f":"LEFT(L200,4)+1&\"-\"&RIGHT(L200,2)+1","v":"2028-29"},{"$f":"LEFT(M200,4)+1&\"-\"&RIGHT(M200,2)+1","v":"2029-30"},{"$f":"LEFT(N200,4)+1&\"-\"&RIGHT(N200,2)+1","v":"2030-31"}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D30","v":"Single Phase (inc. DC)"},"$dollars","Nominal",null,null,{"$f":"IFERROR(K186*10^6/'Calc | Exit Fees'!K31,0)","v":65.809211862332319},{"$f":"IFERROR(L186*10^6/'Calc | Exit Fees'!L31,0)","v":87.592734221733096},{"$f":"IFERROR(M186*10^6/'Calc | Exit Fees'!M31,0)","v":127.11606853347173},{"$f":"IFERROR(N186*10^6/'Calc | Exit Fees'!N31,0)","v":175.54859033807961},{"$f":"IFERROR(O186*10^6/'Calc | Exit Fees'!O31,0)","v":230.39776940098821}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D31","v":"Single Phase, Two Element"},"$dollars","Nominal",null,null,{"$f":"IFERROR(K187*10^6/'Calc | Exit Fees'!K32,0)","v":71.335652978590801},{"$f":"IFERROR(L187*10^6/'Calc | Exit Fees'!L32,0)","v":94.917508136882574},{"$f":"IFERROR(M187*10^6/'Calc | Exit Fees'!M32,0)","v":137.69336703805223},{"$f":"IFERROR(N187*10^6/'Calc | Exit Fees'!N32,0)","v":190.07425306210305},{"$f":"IFERROR(O187*10^6/'Calc | Exit Fees'!O32,0)","v":249.35288684925791}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D32","v":"Three Phase (inc. DC)"},"$dollars","Nominal",null,null,{"$f":"IFERROR(K188*10^6/'Calc | Exit Fees'!K33,0)","v":92.356363938908885},{"$f":"IFERROR(L188*10^6/'Calc | Exit Fees'!L33,0)","v":122.80500213739741},{"$f":"IFERROR(M188*10^6/'Calc | Exit Fees'!M33,0)","v":178.00934035438812},{"$f":"IFERROR(N188*10^6/'Calc | Exit Fees'!N33,0)","v":245.51026550044236},{"$f":"IFERROR(O188*10^6/'Calc | Exit Fees'!O33,0)","v":321.78832057562306}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D33","v":"Three Phase CT"},"$dollars","Nominal",null,null,{"$f":"IFERROR(K189*10^6/'Calc | Exit Fees'!K34,0)","v":136.48313679982684},{"$f":"IFERROR(L189*10^6/'Calc | Exit Fees'!L34,0)","v":181.59629844166002},{"$f":"IFERROR(M189*10^6/'Calc | Exit Fees'!M34,0)","v":263.42683258979832},{"$f":"IFERROR(N189*10^6/'Calc | Exit Fees'!N34,0)","v":363.62595402819949},{"$f":"IFERROR(O189*10^6/'Calc | Exit Fees'!O34,0)","v":477.01309531222876}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D34","v":0},"$dollars","Nominal",null,null,{"$f":"IFERROR(K190*10^6/'Calc | Exit Fees'!K35,0)","v":0},{"$f":"IFERROR(L190*10^6/'Calc | Exit Fees'!L35,0)","v":0},{"$f":"IFERROR(M190*10^6/'Calc | Exit Fees'!M35,0)","v":0},{"$f":"IFERROR(N190*10^6/'Calc | Exit Fees'!N35,0)","v":0},{"$f":"IFERROR(O190*10^6/'Calc | Exit Fees'!O35,0)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D35","v":0},"$dollars","Nominal",null,null,{"$f":"IFERROR(K191*10^6/'Calc | Exit Fees'!K36,0)","v":0},{"$f":"IFERROR(L191*10^6/'Calc | Exit Fees'!L36,0)","v":0},{"$f":"IFERROR(M191*10^6/'Calc | Exit Fees'!M36,0)","v":0},{"$f":"IFERROR(N191*10^6/'Calc | Exit Fees'!N36,0)","v":0},{"$f":"IFERROR(O191*10^6/'Calc | Exit Fees'!O36,0)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D36","v":0},"$dollars","Nominal",null,null,{"$f":"IFERROR(K192*10^6/'Calc | Exit Fees'!K37,0)","v":0},{"$f":"IFERROR(L192*10^6/'Calc | Exit Fees'!L37,0)","v":0},{"$f":"IFERROR(M192*10^6/'Calc | Exit Fees'!M37,0)","v":0},{"$f":"IFERROR(N192*10^6/'Calc | Exit Fees'!N37,0)","v":0},{"$f":"IFERROR(O192*10^6/'Calc | Exit Fees'!O37,0)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D37","v":0},"$dollars","Nominal",null,null,{"$f":"IFERROR(K193*10^6/'Calc | Exit Fees'!K38,0)","v":0},{"$f":"IFERROR(L193*10^6/'Calc | Exit Fees'!L38,0)","v":0},{"$f":"IFERROR(M193*10^6/'Calc | Exit Fees'!M38,0)","v":0},{"$f":"IFERROR(N193*10^6/'Calc | Exit Fees'!N38,0)","v":0},{"$f":"IFERROR(O193*10^6/'Calc | Exit Fees'!O38,0)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D38","v":0},"$dollars","Nominal",null,null,{"$f":"IFERROR(K194*10^6/'Calc | Exit Fees'!K39,0)","v":0},{"$f":"IFERROR(L194*10^6/'Calc | Exit Fees'!L39,0)","v":0},{"$f":"IFERROR(M194*10^6/'Calc | Exit Fees'!M39,0)","v":0},{"$f":"IFERROR(N194*10^6/'Calc | Exit Fees'!N39,0)","v":0},{"$f":"IFERROR(O194*10^6/'Calc | Exit Fees'!O39,0)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D39","v":0},"$dollars","Nominal",null,null,{"$f":"IFERROR(K195*10^6/'Calc | Exit Fees'!K40,0)","v":0},{"$f":"IFERROR(L195*10^6/'Calc | Exit Fees'!L40,0)","v":0},{"$f":"IFERROR(M195*10^6/'Calc | Exit Fees'!M40,0)","v":0},{"$f":"IFERROR(N195*10^6/'Calc | Exit Fees'!N40,0)","v":0},{"$f":"IFERROR(O195*10^6/'Calc | Exit Fees'!O40,0)","v":0}]
[]
[null,"Calculations | Comms, IT, Inhouse software & Equity Raising Costs (TAB)"]
[]
[null,null,"Calculation of Allocated Comms, IT, Inhouse software & Equity Raising Costs TAB by Designated Exit Fee"]
[]
[null,null,null,null,null,null,null,null,null,null,"Regulatory period"]
[null,null,null,null,null,"Exit Fee Component","Units","Basis",null,null,{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(K217,4)+1&\"-\"&RIGHT(K217,2)+1","v":"2027-28"},{"$f":"LEFT(L217,4)+1&\"-\"&RIGHT(L217,2)+1","v":"2028-29"},{"$f":"LEFT(M217,4)+1&\"-\"&RIGHT(M217,2)+1","v":"2029-30"},{"$f":"LEFT(N217,4)+1&\"-\"&RIGHT(N217,2)+1","v":"2030-31"}]
[null,null,null,null,null,"Comms, IT, Inhouse software & Equity Raising Costs TAB per meter","$dollars","Nominal",null,null,{"$f":"(AVERAGE('Input | Exit Fees'!G$137:H$137)*10^6)/'Calc | Exit Fees'!K$41","v":14.129107474189787},{"$f":"(AVERAGE('Input | Exit Fees'!H$137:I$137)*10^6)/'Calc | Exit Fees'!L$41","v":22.040236180299065},{"$f":"(AVERAGE('Input | Exit Fees'!I$137:J$137)*10^6)/'Calc | Exit Fees'!M$41","v":22.033438395964762},{"$f":"(AVERAGE('Input | Exit Fees'!J$137:K$137)*10^6)/'Calc | Exit Fees'!N$41","v":22.411083006898075},{"$f":"(AVERAGE('Input | Exit Fees'!K$137:L$137)*10^6)/'Calc | Exit Fees'!O$41","v":22.585260085863222}]
[]
[]
[]
[null,"Calculations | Exit Fees with Component Detail (TAB)"]
[]
[null,null,null,null,null,"Base Year","Regulatory period"]
[null,null,null,null,null,null,"Tariff ($/year) (Nominal)"]
[null,null,"No.","Exit Fee Name","Component","2025-26","2026-27","2027-28","2028-29","2029-30","2030-31"]
[null,null,1,{"$f":"'Input | Exit Fees'!D30","v":"Single Phase (inc. DC)"}]
[null,null,null,null,"WDV - Meter RAB",null,{"$f":"IF($D227=0,0,SUMIFS('Calc | Exit Fees'!K$201:K$210,'Input | Exit Fees'!$D$30:$D$39,$D227))","v":65.809211862332319},{"$f":"IF($D227=0,0,SUMIFS('Calc | Exit Fees'!L$201:L$210,'Input | Exit Fees'!$D$30:$D$39,$D227))","v":87.592734221733096},{"$f":"IF($D227=0,0,SUMIFS('Calc | Exit Fees'!M$201:M$210,'Input | Exit Fees'!$D$30:$D$39,$D227))","v":127.11606853347173},{"$f":"IF($D227=0,0,SUMIFS('Calc | Exit Fees'!N$201:N$210,'Input | Exit Fees'!$D$30:$D$39,$D227))","v":175.54859033807961},{"$f":"IF($D227=0,0,SUMIFS('Calc | Exit Fees'!O$201:O$210,'Input | Exit Fees'!$D$30:$D$39,$D227))","v":230.39776940098821}]
[null,null,null,null,"WDV - Comms, IT, Inhouse software & Equity Raising Costs",null,{"$f":"IF($D227=0,0,'Calc | Exit Fees'!K$218)","v":14.129107474189787},{"$f":"IF($D227=0,0,'Calc | Exit Fees'!L$218)","v":22.040236180299065},{"$f":"IF($D227=0,0,'Calc | Exit Fees'!M$218)","v":22.033438395964762},{"$f":"IF($D227=0,0,'Calc | Exit Fees'!N$218)","v":22.411083006898075},{"$f":"IF($D227=0,0,'Calc | Exit Fees'!O$218)","v":22.585260085863222}]
[]
[]
[null,null,null,null,"TOTAL WDV",null,{"$f":"SUM(G228:G231)","v":79.938319336522113},{"$f":"SUM(H228:H231)","v":109.63297040203216},{"$f":"SUM(I228:I231)","v":149.14950692943648},{"$f":"SUM(J228:J231)","v":197.95967334497769},{"$f":"SUM(K228:K231)","v":252.98302948685142}]
[null,null,2,{"$f":"'Input | Exit Fees'!D31","v":"Single Phase, Two Element"}]
[null,null,null,null,{"$f":"IF($D233=0,\"\",E$228)","v":"WDV - Meter RAB"},null,{"$f":"IF($D233=0,0,SUMIFS('Calc | Exit Fees'!K$201:K$210,'Input | Exit Fees'!$D$30:$D$39,$D233))","v":71.335652978590801},{"$f":"IF($D233=0,0,SUMIFS('Calc | Exit Fees'!L$201:L$210,'Input | Exit Fees'!$D$30:$D$39,$D233))","v":94.917508136882574},{"$f":"IF($D233=0,0,SUMIFS('Calc | Exit Fees'!M$201:M$210,'Input | Exit Fees'!$D$30:$D$39,$D233))","v":137.69336703805223},{"$f":"IF($D233=0,0,SUMIFS('Calc | Exit Fees'!N$201:N$210,'Input | Exit Fees'!$D$30:$D$39,$D233))","v":190.07425306210305},{"$f":"IF($D233=0,0,SUMIFS('Calc | Exit Fees'!O$201:O$210,'Input | Exit Fees'!$D$30:$D$39,$D233))","v":249.35288684925791}]
[null,null,null,null,{"$f":"IF($D233=0,\"\",E$229)","v":"WDV - Comms, IT, Inhouse software & Equity Raising Costs"},null,{"$f":"IF($D233=0,0,'Calc | Exit Fees'!K$218)","v":14.129107474189787},{"$f":"IF($D233=0,0,'Calc | Exit Fees'!L$218)","v":22.040236180299065},{"$f":"IF($D233=0,0,'Calc | Exit Fees'!M$218)","v":22.033438395964762},{"$f":"IF($D233=0,0,'Calc | Exit Fees'!N$218)","v":22.411083006898075},{"$f":"IF($D233=0,0,'Calc | Exit Fees'!O$218)","v":22.585260085863222}]
[]
[]
[null,null,null,null,{"$f":"IF($D233=0,\"\",E$232)","v":"TOTAL WDV"},null,{"$f":"SUM(G234:G237)","v":85.464760452780581},{"$f":"SUM(H234:H237)","v":116.95774431718164},{"$f":"SUM(I234:I237)","v":159.726805434017},{"$f":"SUM(J234:J237)","v":212.48533606900114},{"$f":"SUM(K234:K237)","v":271.93814693512115}]
[null,null,3,{"$f":"'Input | Exit Fees'!D32","v":"Three Phase (inc. DC)"}]
[null,null,null,null,{"$f":"IF($D239=0,\"\",E$228)","v":"WDV - Meter RAB"},null,{"$f":"IF($D239=0,0,SUMIFS('Calc | Exit Fees'!K$201:K$210,'Input | Exit Fees'!$D$30:$D$39,$D239))","v":92.356363938908885},{"$f":"IF($D239=0,0,SUMIFS('Calc | Exit Fees'!L$201:L$210,'Input | Exit Fees'!$D$30:$D$39,$D239))","v":122.80500213739741},{"$f":"IF($D239=0,0,SUMIFS('Calc | Exit Fees'!M$201:M$210,'Input | Exit Fees'!$D$30:$D$39,$D239))","v":178.00934035438812},{"$f":"IF($D239=0,0,SUMIFS('Calc | Exit Fees'!N$201:N$210,'Input | Exit Fees'!$D$30:$D$39,$D239))","v":245.51026550044236},{"$f":"IF($D239=0,0,SUMIFS('Calc | Exit Fees'!O$201:O$210,'Input | Exit Fees'!$D$30:$D$39,$D239))","v":321.78832057562306}]
[null,null,null,null,{"$f":"IF($D239=0,\"\",E$229)","v":"WDV - Comms, IT, Inhouse software & Equity Raising Costs"},null,{"$f":"IF($D239=0,0,'Calc | Exit Fees'!K$218)","v":14.129107474189787},{"$f":"IF($D239=0,0,'Calc | Exit Fees'!L$218)","v":22.040236180299065},{"$f":"IF($D239=0,0,'Calc | Exit Fees'!M$218)","v":22.033438395964762},{"$f":"IF($D239=0,0,'Calc | Exit Fees'!N$218)","v":22.411083006898075},{"$f":"IF($D239=0,0,'Calc | Exit Fees'!O$218)","v":22.585260085863222}]
[]
[]
[null,null,null,null,{"$f":"IF($D239=0,\"\",E$232)","v":"TOTAL WDV"},null,{"$f":"SUM(G240:G243)","v":106.48547141309868},{"$f":"SUM(H240:H243)","v":144.84523831769647},{"$f":"SUM(I240:I243)","v":200.04277875035288},{"$f":"SUM(J240:J243)","v":267.92134850734044},{"$f":"SUM(K240:K243)","v":344.3735806614863}]
[null,null,4,{"$f":"'Input | Exit Fees'!D33","v":"Three Phase CT"}]
[null,null,null,null,{"$f":"IF($D245=0,\"\",E$228)","v":"WDV - Meter RAB"},null,{"$f":"IF($D245=0,0,SUMIFS('Calc | Exit Fees'!K$201:K$210,'Input | Exit Fees'!$D$30:$D$39,$D245))","v":136.48313679982684},{"$f":"IF($D245=0,0,SUMIFS('Calc | Exit Fees'!L$201:L$210,'Input | Exit Fees'!$D$30:$D$39,$D245))","v":181.59629844166002},{"$f":"IF($D245=0,0,SUMIFS('Calc | Exit Fees'!M$201:M$210,'Input | Exit Fees'!$D$30:$D$39,$D245))","v":263.42683258979832},{"$f":"IF($D245=0,0,SUMIFS('Calc | Exit Fees'!N$201:N$210,'Input | Exit Fees'!$D$30:$D$39,$D245))","v":363.62595402819949},{"$f":"IF($D245=0,0,SUMIFS('Calc | Exit Fees'!O$201:O$210,'Input | Exit Fees'!$D$30:$D$39,$D245))","v":477.01309531222876}]
[null,null,null,null,{"$f":"IF($D245=0,\"\",E$229)","v":"WDV - Comms, IT, Inhouse software & Equity Raising Costs"},null,{"$f":"IF($D245=0,0,'Calc | Exit Fees'!K$218)","v":14.129107474189787},{"$f":"IF($D245=0,0,'Calc | Exit Fees'!L$218)","v":22.040236180299065},{"$f":"IF($D245=0,0,'Calc | Exit Fees'!M$218)","v":22.033438395964762},{"$f":"IF($D245=0,0,'Calc | Exit Fees'!N$218)","v":22.411083006898075},{"$f":"IF($D245=0,0,'Calc | Exit Fees'!O$218)","v":22.585260085863222}]
[]
[]
[null,null,null,null,{"$f":"IF($D245=0,\"\",E$232)","v":"TOTAL WDV"},null,{"$f":"SUM(G246:G249)","v":150.61224427401663},{"$f":"SUM(H246:H249)","v":203.6365346219591},{"$f":"SUM(I246:I249)","v":285.46027098576309},{"$f":"SUM(J246:J249)","v":386.03703703509757},{"$f":"SUM(K246:K249)","v":499.598355398092}]
[null,null,5,{"$f":"'Input | Exit Fees'!D34","v":0}]
[null,null,null,null,{"$f":"IF($D251=0,\"\",E$228)","v":""},null,{"$f":"IF($D251=0,0,SUMIFS('Calc | Exit Fees'!K$201:K$210,'Input | Exit Fees'!$D$30:$D$39,$D251))","v":0},{"$f":"IF($D251=0,0,SUMIFS('Calc | Exit Fees'!L$201:L$210,'Input | Exit Fees'!$D$30:$D$39,$D251))","v":0},{"$f":"IF($D251=0,0,SUMIFS('Calc | Exit Fees'!M$201:M$210,'Input | Exit Fees'!$D$30:$D$39,$D251))","v":0},{"$f":"IF($D251=0,0,SUMIFS('Calc | Exit Fees'!N$201:N$210,'Input | Exit Fees'!$D$30:$D$39,$D251))","v":0},{"$f":"IF($D251=0,0,SUMIFS('Calc | Exit Fees'!O$201:O$210,'Input | Exit Fees'!$D$30:$D$39,$D251))","v":0}]
[null,null,null,null,{"$f":"IF($D251=0,\"\",E$229)","v":""},null,{"$f":"IF($D251=0,0,'Calc | Exit Fees'!K$218)","v":0},{"$f":"IF($D251=0,0,'Calc | Exit Fees'!L$218)","v":0},{"$f":"IF($D251=0,0,'Calc | Exit Fees'!M$218)","v":0},{"$f":"IF($D251=0,0,'Calc | Exit Fees'!N$218)","v":0},{"$f":"IF($D251=0,0,'Calc | Exit Fees'!O$218)","v":0}]
[null,null,null,null,{"$f":"IF($D251=0,\"\",E$230)","v":""},null,{"$f":"IF($D251=0,0,'Input | Exit Fees'!K$120)","v":0},{"$f":"IF($D251=0,0,'Input | Exit Fees'!L$120)","v":0},{"$f":"IF($D251=0,0,'Input | Exit Fees'!M$120)","v":0},{"$f":"IF($D251=0,0,'Input | Exit Fees'!N$120)","v":0},{"$f":"IF($D251=0,0,'Input | Exit Fees'!O$120)","v":0}]
[null,null,null,null,{"$f":"IF($D251=0,\"\",E$231)","v":""}]
[null,null,null,null,{"$f":"IF($D251=0,\"\",E$232)","v":""},null,{"$f":"SUM(G252:G255)","v":0},{"$f":"SUM(H252:H255)","v":0},{"$f":"SUM(I252:I255)","v":0},{"$f":"SUM(J252:J255)","v":0},{"$f":"SUM(K252:K255)","v":0}]
[null,null,6,{"$f":"'Input | Exit Fees'!D35","v":0}]
[null,null,null,null,{"$f":"IF($D257=0,\"\",E$228)","v":""},null,{"$f":"IF($D257=0,0,SUMIFS('Calc | Exit Fees'!K$201:K$210,'Input | Exit Fees'!$D$30:$D$39,$D257))","v":0},{"$f":"IF($D257=0,0,SUMIFS('Calc | Exit Fees'!L$201:L$210,'Input | Exit Fees'!$D$30:$D$39,$D257))","v":0},{"$f":"IF($D257=0,0,SUMIFS('Calc | Exit Fees'!M$201:M$210,'Input | Exit Fees'!$D$30:$D$39,$D257))","v":0},{"$f":"IF($D257=0,0,SUMIFS('Calc | Exit Fees'!N$201:N$210,'Input | Exit Fees'!$D$30:$D$39,$D257))","v":0},{"$f":"IF($D257=0,0,SUMIFS('Calc | Exit Fees'!O$201:O$210,'Input | Exit Fees'!$D$30:$D$39,$D257))","v":0}]
[null,null,null,null,{"$f":"IF($D257=0,\"\",E$229)","v":""},null,{"$f":"IF($D257=0,0,'Calc | Exit Fees'!K$218)","v":0},{"$f":"IF($D257=0,0,'Calc | Exit Fees'!L$218)","v":0},{"$f":"IF($D257=0,0,'Calc | Exit Fees'!M$218)","v":0},{"$f":"IF($D257=0,0,'Calc | Exit Fees'!N$218)","v":0},{"$f":"IF($D257=0,0,'Calc | Exit Fees'!O$218)","v":0}]
[null,null,null,null,{"$f":"IF($D257=0,\"\",E$230)","v":""},null,{"$f":"IF($D257=0,0,'Input | Exit Fees'!K$120)","v":0},{"$f":"IF($D257=0,0,'Input | Exit Fees'!L$120)","v":0},{"$f":"IF($D257=0,0,'Input | Exit Fees'!M$120)","v":0},{"$f":"IF($D257=0,0,'Input | Exit Fees'!N$120)","v":0},{"$f":"IF($D257=0,0,'Input | Exit Fees'!O$120)","v":0}]
[null,null,null,null,{"$f":"IF($D257=0,\"\",E$231)","v":""}]
[null,null,null,null,{"$f":"IF($D257=0,\"\",E$232)","v":""},null,{"$f":"SUM(G258:G261)","v":0},{"$f":"SUM(H258:H261)","v":0},{"$f":"SUM(I258:I261)","v":0},{"$f":"SUM(J258:J261)","v":0},{"$f":"SUM(K258:K261)","v":0}]
[null,null,7,{"$f":"'Input | Exit Fees'!D36","v":0}]
[null,null,null,null,{"$f":"IF($D263=0,\"\",E$228)","v":""},null,{"$f":"IF($D263=0,0,SUMIFS('Calc | Exit Fees'!K$201:K$210,'Input | Exit Fees'!$D$30:$D$39,$D263))","v":0},{"$f":"IF($D263=0,0,SUMIFS('Calc | Exit Fees'!L$201:L$210,'Input | Exit Fees'!$D$30:$D$39,$D263))","v":0},{"$f":"IF($D263=0,0,SUMIFS('Calc | Exit Fees'!M$201:M$210,'Input | Exit Fees'!$D$30:$D$39,$D263))","v":0},{"$f":"IF($D263=0,0,SUMIFS('Calc | Exit Fees'!N$201:N$210,'Input | Exit Fees'!$D$30:$D$39,$D263))","v":0},{"$f":"IF($D263=0,0,SUMIFS('Calc | Exit Fees'!O$201:O$210,'Input | Exit Fees'!$D$30:$D$39,$D263))","v":0}]
[null,null,null,null,{"$f":"IF($D263=0,\"\",E$229)","v":""},null,{"$f":"IF($D263=0,0,'Calc | Exit Fees'!K$218)","v":0},{"$f":"IF($D263=0,0,'Calc | Exit Fees'!L$218)","v":0},{"$f":"IF($D263=0,0,'Calc | Exit Fees'!M$218)","v":0},{"$f":"IF($D263=0,0,'Calc | Exit Fees'!N$218)","v":0},{"$f":"IF($D263=0,0,'Calc | Exit Fees'!O$218)","v":0}]
[null,null,null,null,{"$f":"IF($D263=0,\"\",E$230)","v":""},null,{"$f":"IF($D263=0,0,'Input | Exit Fees'!K$120)","v":0},{"$f":"IF($D263=0,0,'Input | Exit Fees'!L$120)","v":0},{"$f":"IF($D263=0,0,'Input | Exit Fees'!M$120)","v":0},{"$f":"IF($D263=0,0,'Input | Exit Fees'!N$120)","v":0},{"$f":"IF($D263=0,0,'Input | Exit Fees'!O$120)","v":0}]
[null,null,null,null,{"$f":"IF($D263=0,\"\",E$231)","v":""}]
[null,null,null,null,{"$f":"IF($D263=0,\"\",E$232)","v":""},null,{"$f":"SUM(G264:G267)","v":0},{"$f":"SUM(H264:H267)","v":0},{"$f":"SUM(I264:I267)","v":0},{"$f":"SUM(J264:J267)","v":0},{"$f":"SUM(K264:K267)","v":0}]
[null,null,8,{"$f":"'Input | Exit Fees'!D37","v":0}]
[null,null,null,null,{"$f":"IF($D269=0,\"\",E$228)","v":""},null,{"$f":"IF($D269=0,0,SUMIFS('Calc | Exit Fees'!K$201:K$210,'Input | Exit Fees'!$D$30:$D$39,$D269))","v":0},{"$f":"IF($D269=0,0,SUMIFS('Calc | Exit Fees'!L$201:L$210,'Input | Exit Fees'!$D$30:$D$39,$D269))","v":0},{"$f":"IF($D269=0,0,SUMIFS('Calc | Exit Fees'!M$201:M$210,'Input | Exit Fees'!$D$30:$D$39,$D269))","v":0},{"$f":"IF($D269=0,0,SUMIFS('Calc | Exit Fees'!N$201:N$210,'Input | Exit Fees'!$D$30:$D$39,$D269))","v":0},{"$f":"IF($D269=0,0,SUMIFS('Calc | Exit Fees'!O$201:O$210,'Input | Exit Fees'!$D$30:$D$39,$D269))","v":0}]
[null,null,null,null,{"$f":"IF($D269=0,\"\",E$229)","v":""},null,{"$f":"IF($D269=0,0,'Calc | Exit Fees'!K$218)","v":0},{"$f":"IF($D269=0,0,'Calc | Exit Fees'!L$218)","v":0},{"$f":"IF($D269=0,0,'Calc | Exit Fees'!M$218)","v":0},{"$f":"IF($D269=0,0,'Calc | Exit Fees'!N$218)","v":0},{"$f":"IF($D269=0,0,'Calc | Exit Fees'!O$218)","v":0}]
[null,null,null,null,{"$f":"IF($D269=0,\"\",E$230)","v":""},null,{"$f":"IF($D269=0,0,'Input | Exit Fees'!K$120)","v":0},{"$f":"IF($D269=0,0,'Input | Exit Fees'!L$120)","v":0},{"$f":"IF($D269=0,0,'Input | Exit Fees'!M$120)","v":0},{"$f":"IF($D269=0,0,'Input | Exit Fees'!N$120)","v":0},{"$f":"IF($D269=0,0,'Input | Exit Fees'!O$120)","v":0}]
[null,null,null,null,{"$f":"IF($D269=0,\"\",E$231)","v":""}]
[null,null,null,null,{"$f":"IF($D269=0,\"\",E$232)","v":""},null,{"$f":"SUM(G270:G273)","v":0},{"$f":"SUM(H270:H273)","v":0},{"$f":"SUM(I270:I273)","v":0},{"$f":"SUM(J270:J273)","v":0},{"$f":"SUM(K270:K273)","v":0}]
[null,null,9,{"$f":"'Input | Exit Fees'!D38","v":0}]
[null,null,null,null,{"$f":"IF($D275=0,\"\",E$228)","v":""},null,{"$f":"IF($D275=0,0,SUMIFS('Calc | Exit Fees'!K$201:K$210,'Input | Exit Fees'!$D$30:$D$39,$D275))","v":0},{"$f":"IF($D275=0,0,SUMIFS('Calc | Exit Fees'!L$201:L$210,'Input | Exit Fees'!$D$30:$D$39,$D275))","v":0},{"$f":"IF($D275=0,0,SUMIFS('Calc | Exit Fees'!M$201:M$210,'Input | Exit Fees'!$D$30:$D$39,$D275))","v":0},{"$f":"IF($D275=0,0,SUMIFS('Calc | Exit Fees'!N$201:N$210,'Input | Exit Fees'!$D$30:$D$39,$D275))","v":0},{"$f":"IF($D275=0,0,SUMIFS('Calc | Exit Fees'!O$201:O$210,'Input | Exit Fees'!$D$30:$D$39,$D275))","v":0}]
[null,null,null,null,{"$f":"IF($D275=0,\"\",E$229)","v":""},null,{"$f":"IF($D275=0,0,'Calc | Exit Fees'!K$218)","v":0},{"$f":"IF($D275=0,0,'Calc | Exit Fees'!L$218)","v":0},{"$f":"IF($D275=0,0,'Calc | Exit Fees'!M$218)","v":0},{"$f":"IF($D275=0,0,'Calc | Exit Fees'!N$218)","v":0},{"$f":"IF($D275=0,0,'Calc | Exit Fees'!O$218)","v":0}]
[null,null,null,null,{"$f":"IF($D275=0,\"\",E$230)","v":""},null,{"$f":"IF($D275=0,0,'Input | Exit Fees'!K$120)","v":0},{"$f":"IF($D275=0,0,'Input | Exit Fees'!L$120)","v":0},{"$f":"IF($D275=0,0,'Input | Exit Fees'!M$120)","v":0},{"$f":"IF($D275=0,0,'Input | Exit Fees'!N$120)","v":0},{"$f":"IF($D275=0,0,'Input | Exit Fees'!O$120)","v":0}]
[null,null,null,null,{"$f":"IF($D275=0,\"\",E$231)","v":""}]
[null,null,null,null,{"$f":"IF($D275=0,\"\",E$232)","v":""},null,{"$f":"SUM(G276:G279)","v":0},{"$f":"SUM(H276:H279)","v":0},{"$f":"SUM(I276:I279)","v":0},{"$f":"SUM(J276:J279)","v":0},{"$f":"SUM(K276:K279)","v":0}]
[null,null,10,{"$f":"'Input | Exit Fees'!D39","v":0}]
[null,null,null,null,{"$f":"IF($D281=0,\"\",E$228)","v":""},null,{"$f":"IF($D281=0,0,SUMIFS('Calc | Exit Fees'!K$201:K$210,'Input | Exit Fees'!$D$30:$D$39,$D281))","v":0},{"$f":"IF($D281=0,0,SUMIFS('Calc | Exit Fees'!L$201:L$210,'Input | Exit Fees'!$D$30:$D$39,$D281))","v":0},{"$f":"IF($D281=0,0,SUMIFS('Calc | Exit Fees'!M$201:M$210,'Input | Exit Fees'!$D$30:$D$39,$D281))","v":0},{"$f":"IF($D281=0,0,SUMIFS('Calc | Exit Fees'!N$201:N$210,'Input | Exit Fees'!$D$30:$D$39,$D281))","v":0},{"$f":"IF($D281=0,0,SUMIFS('Calc | Exit Fees'!O$201:O$210,'Input | Exit Fees'!$D$30:$D$39,$D281))","v":0}]
[null,null,null,null,{"$f":"IF($D281=0,\"\",E$229)","v":""},null,{"$f":"IF($D281=0,0,'Calc | Exit Fees'!K$218)","v":0},{"$f":"IF($D281=0,0,'Calc | Exit Fees'!L$218)","v":0},{"$f":"IF($D281=0,0,'Calc | Exit Fees'!M$218)","v":0},{"$f":"IF($D281=0,0,'Calc | Exit Fees'!N$218)","v":0},{"$f":"IF($D281=0,0,'Calc | Exit Fees'!O$218)","v":0}]
[null,null,null,null,{"$f":"IF($D281=0,\"\",E$230)","v":""},null,{"$f":"IF($D281=0,0,'Input | Exit Fees'!K$120)","v":0},{"$f":"IF($D281=0,0,'Input | Exit Fees'!L$120)","v":0},{"$f":"IF($D281=0,0,'Input | Exit Fees'!M$120)","v":0},{"$f":"IF($D281=0,0,'Input | Exit Fees'!N$120)","v":0},{"$f":"IF($D281=0,0,'Input | Exit Fees'!O$120)","v":0}]
[null,null,null,null,{"$f":"IF($D281=0,\"\",E$231)","v":""}]
[null,null,null,null,{"$f":"IF($D281=0,\"\",E$232)","v":""},null,{"$f":"SUM(G282:G285)","v":0},{"$f":"SUM(H282:H285)","v":0},{"$f":"SUM(I282:I285)","v":0},{"$f":"SUM(J282:J285)","v":0},{"$f":"SUM(K282:K285)","v":0}]

{"sheet":"Calc | Tax Allowance","index":7,"n_rows":92,"n_cols":14,"rows_kept":92,"cut":false,"hidden":false,"merged":[[6,6,6,10],[7,6,7,10],[0,13,0,14],[4,1,4,7]]}
[null,{"$f":"'Title Page'!B8&\" v\"&'Title Page'!$C$10","v":"JEN 2027-31 - ACS Standardised Metering Pricing Model  v1.02"},null,null,null,null,null,null,null,null,null,null,"DNSP:",{"$f":"IF('Inputs | General'!$G$16=\"Price Cap\",\"NOT USED\",NSP)","v":"JEN - ACS"}]
[null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"Calc | Tax Allowance"},null,null,null,null,null,"Key:","Input","External Link","Internal Link","Jemena added sheet","JEN - RP"]
[]
[]
[null,"CALCULATION | Tax Allowance"]
[]
[null,null,null,null,null,"Base Year","Regulatory period"]
[null,null,null,null,null,null,"Tariff ($/year) (Nominal)"]
[null,null,null,"Exit Fee Name","Component","2025-26","2026-27","2027-28","2028-29","2029-30","2030-31"]
[null,null,null,"Single Phase"]
[null,null,null,null,"Revenue excluding tax allowance"]
[null,null,null,null,"Meter RAB",null,{"$f":"+'Calc | Exit Fees'!G119","v":99.456798820826464},{"$f":"+'Calc | Exit Fees'!H119","v":122.36559224277035},{"$f":"+'Calc | Exit Fees'!I119","v":165.03428447577409},{"$f":"+'Calc | Exit Fees'!J119","v":219.64831992457712},{"$f":"+'Calc | Exit Fees'!K119","v":281.76849950076138}]
[null,null,null,null,"Comms, IT, Inhouse software & Equity Raising Costs RAB",null,{"$f":"+'Calc | Exit Fees'!G120","v":22.714161539740974},{"$f":"+'Calc | Exit Fees'!H120","v":32.996028721968216},{"$f":"+'Calc | Exit Fees'!I120","v":36.864772935679383},{"$f":"+'Calc | Exit Fees'!J120","v":41.118154502249979},{"$f":"+'Calc | Exit Fees'!K120","v":44.101025978888529}]
[null,null,null,null,"Admin cost",null,{"$f":"+'Calc | Exit Fees'!G121","v":78.113744129225978},{"$f":"+'Calc | Exit Fees'!H121","v":83.25631344010452},{"$f":"+'Calc | Exit Fees'!I121","v":88.085563423024794},{"$f":"+'Calc | Exit Fees'!J121","v":92.591868852374347},{"$f":"+'Calc | Exit Fees'!K121","v":97.342350407363242}]
[null,null,null,null,"Revenue for Tax Assessment Subtotal",null,{"$f":"SUM(G12:G14)","v":200.2847044897934},{"$f":"SUM(H12:H14)","v":238.61793440484308},{"$f":"SUM(I12:I14)","v":289.98462083447828},{"$f":"SUM(J12:J14)","v":353.35834327920145},{"$f":"SUM(K12:K14)","v":423.21187588701315}]
[]
[null,null,null,null,"Tax expenses"]
[null,null,null,null,"WDV - Meter TAB",null,{"$f":"+'Calc | Exit Fees'!G228","v":65.809211862332319},{"$f":"+'Calc | Exit Fees'!H228","v":87.592734221733096},{"$f":"+'Calc | Exit Fees'!I228","v":127.11606853347173},{"$f":"+'Calc | Exit Fees'!J228","v":175.54859033807961},{"$f":"+'Calc | Exit Fees'!K228","v":230.39776940098821}]
[null,null,null,null,"WDV - Comms, IT, Inhouse software & Equity Raising Costs TAB",null,{"$f":"+'Calc | Exit Fees'!G229","v":14.129107474189787},{"$f":"+'Calc | Exit Fees'!H229","v":22.040236180299065},{"$f":"+'Calc | Exit Fees'!I229","v":22.033438395964762},{"$f":"+'Calc | Exit Fees'!J229","v":22.411083006898075},{"$f":"+'Calc | Exit Fees'!K229","v":22.585260085863222}]
[null,null,null,null,"Admin cost",null,{"$f":"+'Calc | Exit Fees'!G121","v":78.113744129225978},{"$f":"+'Calc | Exit Fees'!H121","v":83.25631344010452},{"$f":"+'Calc | Exit Fees'!I121","v":88.085563423024794},{"$f":"+'Calc | Exit Fees'!J121","v":92.591868852374347},{"$f":"+'Calc | Exit Fees'!K121","v":97.342350407363242}]
[null,null,null,null,"Interest expense",null,0,0,0,0,0]
[null,null,null,null,"Tax expenses",null,{"$f":"SUM(G18:G21)","v":158.05206346574809},{"$f":"SUM(H18:H21)","v":192.88928384213668},{"$f":"SUM(I18:I21)","v":237.23507035246126},{"$f":"SUM(J18:J21)","v":290.55154219735203},{"$f":"SUM(K18:K21)","v":350.32537989421468}]
[]
[null,null,null,null,"Corporate tax rate",null,{"$f":"+'Inputs | General'!J$44","v":0.3},{"$f":"+'Inputs | General'!K$44","v":0.3},{"$f":"+'Inputs | General'!L$44","v":0.3},{"$f":"+'Inputs | General'!M$44","v":0.3},{"$f":"+'Inputs | General'!N$44","v":0.3}]
[null,null,null,null,"Imputation credits rate",null,{"$f":"+'Inputs | General'!J$43","v":0.56999999999999995},{"$f":"+'Inputs | General'!K$43","v":0.56999999999999995},{"$f":"+'Inputs | General'!L$43","v":0.56999999999999995},{"$f":"+'Inputs | General'!M$43","v":0.56999999999999995},{"$f":"+'Inputs | General'!N$43","v":0.56999999999999995}]
[null,null,null,null,"Taxable income",null,{"$f":"+G15-G22","v":42.232641024045307},{"$f":"+H15-H22","v":45.728650562706406},{"$f":"+I15-I22","v":52.749550482017014},{"$f":"+J15-J22","v":62.806801081849414},{"$f":"+K15-K22","v":72.886495992798473}]
[null,null,null,null,"Tax payable",null,{"$f":"+G26*G24/(1-G24*(1-G25))","v":14.546259824585066},{"$f":"+H26*H24/(1-H24*(1-H25))","v":15.750396290254789},{"$f":"+I26*I24/(1-I24*(1-I25))","v":18.168616698742944},{"$f":"+J26*J24/(1-J24*(1-J25))","v":21.632652496618626},{"$f":"+K26*K24/(1-K24*(1-K25))","v":25.104418826451827}]
[null,null,null,null,"Imputation credits",null,{"$f":"+G27*G25","v":8.2913681000134876},{"$f":"+H27*H25","v":8.9777258854452295},{"$f":"+I27*I25","v":10.356111518283477},{"$f":"+J27*J25","v":12.330611923072615},{"$f":"+K27*K25","v":14.30951873107754}]
[null,null,null,null,"Tax allowance",null,{"$f":"+G27-G28","v":6.2548917245715785},{"$f":"+H27-H28","v":6.7726704048095598},{"$f":"+I27-I28","v":7.8125051804594676},{"$f":"+J27-J28","v":9.3020405735460105},{"$f":"+K27-K28","v":10.794900095374286}]
[]
[null,null,null,{"$f":"'Input | Exit Fees'!D31","v":"Single Phase, Two Element"}]
[null,null,null,null,"Revenue for Tax Assessment Subtotal"]
[null,null,null,null,"Meter RAB",null,{"$f":"+'Calc | Exit Fees'!G125","v":107.8088535976664},{"$f":"+'Calc | Exit Fees'!H125","v":132.59817952452772},{"$f":"+'Calc | Exit Fees'!I125","v":178.76674891185343},{"$f":"+'Calc | Exit Fees'!J125","v":237.82298829974508},{"$f":"+'Calc | Exit Fees'!K125","v":304.9499522342042}]
[null,null,null,null,"Comms, IT, Inhouse software & Equity Raising Costs RAB",null,{"$f":"+'Calc | Exit Fees'!G126","v":22.714161539740974},{"$f":"+'Calc | Exit Fees'!H126","v":32.996028721968216},{"$f":"+'Calc | Exit Fees'!I126","v":36.864772935679383},{"$f":"+'Calc | Exit Fees'!J126","v":41.118154502249979},{"$f":"+'Calc | Exit Fees'!K126","v":44.101025978888529}]
[null,null,null,null,"Admin cost",null,{"$f":"+'Calc | Exit Fees'!G127","v":78.113744129225978},{"$f":"+'Calc | Exit Fees'!H127","v":83.25631344010452},{"$f":"+'Calc | Exit Fees'!I127","v":88.085563423024794},{"$f":"+'Calc | Exit Fees'!J127","v":92.591868852374347},{"$f":"+'Calc | Exit Fees'!K127","v":97.342350407363242}]
[null,null,null,null,"Revenue for Tax Assessment Subtotal",null,{"$f":"SUM(G33:G35)","v":208.63675926663336},{"$f":"SUM(H33:H35)","v":248.85052168660047},{"$f":"SUM(I33:I35)","v":303.71708527055762},{"$f":"SUM(J33:J35)","v":371.53301165436937},{"$f":"SUM(K33:K35)","v":446.39332862045597}]
[]
[null,null,null,null,"Tax expenses"]
[null,null,null,null,"Meter TAB",null,{"$f":"+'Calc | Exit Fees'!G234","v":71.335652978590801},{"$f":"+'Calc | Exit Fees'!H234","v":94.917508136882574},{"$f":"+'Calc | Exit Fees'!I234","v":137.69336703805223},{"$f":"+'Calc | Exit Fees'!J234","v":190.07425306210305},{"$f":"+'Calc | Exit Fees'!K234","v":249.35288684925791}]
[null,null,null,null,"Comms, IT, Inhouse software & Equity Raising Costs TAB",null,{"$f":"+'Calc | Exit Fees'!G235","v":14.129107474189787},{"$f":"+'Calc | Exit Fees'!H235","v":22.040236180299065},{"$f":"+'Calc | Exit Fees'!I235","v":22.033438395964762},{"$f":"+'Calc | Exit Fees'!J235","v":22.411083006898075},{"$f":"+'Calc | Exit Fees'!K235","v":22.585260085863222}]
[null,null,null,null,"Admin cost",null,{"$f":"+'Calc | Exit Fees'!G127","v":78.113744129225978},{"$f":"+'Calc | Exit Fees'!H127","v":83.25631344010452},{"$f":"+'Calc | Exit Fees'!I127","v":88.085563423024794},{"$f":"+'Calc | Exit Fees'!J127","v":92.591868852374347},{"$f":"+'Calc | Exit Fees'!K127","v":97.342350407363242}]
[null,null,null,null,"Interest expense",null,0,0,0,0,0]
[null,null,null,null,"Tax expenses",null,{"$f":"SUM(G39:G42)","v":163.57850458200656},{"$f":"SUM(H39:H42)","v":200.21405775728616},{"$f":"SUM(I39:I42)","v":247.8123688570418},{"$f":"SUM(J39:J42)","v":305.07720492137548},{"$f":"SUM(K39:K42)","v":369.28049734248441}]
[]
[null,null,null,null,"Corporate tax rate",null,{"$f":"+'Inputs | General'!J$44","v":0.3},{"$f":"+'Inputs | General'!K$44","v":0.3},{"$f":"+'Inputs | General'!L$44","v":0.3},{"$f":"+'Inputs | General'!M$44","v":0.3},{"$f":"+'Inputs | General'!N$44","v":0.3}]
[null,null,null,null,"Imputation credits rate",null,{"$f":"+'Inputs | General'!J$43","v":0.56999999999999995},{"$f":"+'Inputs | General'!K$43","v":0.56999999999999995},{"$f":"+'Inputs | General'!L$43","v":0.56999999999999995},{"$f":"+'Inputs | General'!M$43","v":0.56999999999999995},{"$f":"+'Inputs | General'!N$43","v":0.56999999999999995}]
[null,null,null,null,"Taxable income",null,{"$f":"+G36-G43","v":45.058254684626803},{"$f":"+H36-H43","v":48.636463929314317},{"$f":"+I36-I43","v":55.904716413515814},{"$f":"+J36-J43","v":66.455806732993892},{"$f":"+K36-K43","v":77.112831277971566}]
[null,null,null,null,"Tax payable",null,{"$f":"+G47*G45/(1-G45*(1-G46))","v":15.519490706530471},{"$f":"+H47*H45/(1-H45*(1-H46))","v":16.751939355676573},{"$f":"+I47*I45/(1-I45*(1-I46))","v":19.255355825550794},{"$f":"+J47*J45/(1-J45*(1-J46))","v":22.889485671524874},{"$f":"+K47*K45/(1-K45*(1-K46))","v":26.56010262157459}]
[null,null,null,null,"Imputation credits",null,{"$f":"+G48*G46","v":8.8461097027223676},{"$f":"+H48*H46","v":9.5486054327356449},{"$f":"+I48*I46","v":10.975552820563951},{"$f":"+J48*J46","v":13.047006832769176},{"$f":"+K48*K46","v":15.139258494297515}]
[null,null,null,null,"Tax allowance",null,{"$f":"+G48-G49","v":6.6733810038081032},{"$f":"+H48-H49","v":7.2033339229409279},{"$f":"+I48-I49","v":8.2798030049868423},{"$f":"+J48-J49","v":9.8424788387556976},{"$f":"+K48-K49","v":11.420844127277075}]
[]
[null,null,null,{"$f":"'Input | Exit Fees'!D32","v":"Three Phase (inc. DC)"}]
[null,null,null,null,"Revenue for Tax Assessment Subtotal"]
[null,null,null,null,"Meter RAB",null,{"$f":"+'Calc | Exit Fees'!G131","v":139.57724227590458},{"$f":"+'Calc | Exit Fees'!H131","v":171.55654462021408},{"$f":"+'Calc | Exit Fees'!I131","v":231.10881617342793},{"$f":"+'Calc | Exit Fees'!J131","v":307.18513454056216},{"$f":"+'Calc | Exit Fees'!K131","v":393.53598119111996}]
[null,null,null,null,"Comms, IT, Inhouse software & Equity Raising Costs RAB",null,{"$f":"+'Calc | Exit Fees'!G132","v":22.714161539740974},{"$f":"+'Calc | Exit Fees'!H132","v":32.996028721968216},{"$f":"+'Calc | Exit Fees'!I132","v":36.864772935679383},{"$f":"+'Calc | Exit Fees'!J132","v":41.118154502249979},{"$f":"+'Calc | Exit Fees'!K132","v":44.101025978888529}]
[null,null,null,null,"Admin cost",null,{"$f":"+'Calc | Exit Fees'!G133","v":78.113744129225978},{"$f":"+'Calc | Exit Fees'!H133","v":83.25631344010452},{"$f":"+'Calc | Exit Fees'!I133","v":88.085563423024794},{"$f":"+'Calc | Exit Fees'!J133","v":92.591868852374347},{"$f":"+'Calc | Exit Fees'!K133","v":97.342350407363242}]
[null,null,null,null,"Revenue for Tax Assessment Subtotal",null,{"$f":"SUM(G54:G56)","v":240.40514794487154},{"$f":"SUM(H54:H56)","v":287.80888678228683},{"$f":"SUM(I54:I56)","v":356.05915253213209},{"$f":"SUM(J54:J56)","v":440.89515789518646},{"$f":"SUM(K54:K56)","v":534.97935757737173}]
[]
[null,null,null,null,"Tax expenses"]
[null,null,null,null,"Meter TAB",null,{"$f":"+'Calc | Exit Fees'!G240","v":92.356363938908885},{"$f":"+'Calc | Exit Fees'!H240","v":122.80500213739741},{"$f":"+'Calc | Exit Fees'!I240","v":178.00934035438812},{"$f":"+'Calc | Exit Fees'!J240","v":245.51026550044236},{"$f":"+'Calc | Exit Fees'!K240","v":321.78832057562306}]
[null,null,null,null,"Comms, IT, Inhouse software & Equity Raising Costs TAB",null,{"$f":"+'Calc | Exit Fees'!G241","v":14.129107474189787},{"$f":"+'Calc | Exit Fees'!H241","v":22.040236180299065},{"$f":"+'Calc | Exit Fees'!I241","v":22.033438395964762},{"$f":"+'Calc | Exit Fees'!J241","v":22.411083006898075},{"$f":"+'Calc | Exit Fees'!K241","v":22.585260085863222}]
[null,null,null,null,"Admin cost",null,{"$f":"+'Calc | Exit Fees'!G133","v":78.113744129225978},{"$f":"+'Calc | Exit Fees'!H133","v":83.25631344010452},{"$f":"+'Calc | Exit Fees'!I133","v":88.085563423024794},{"$f":"+'Calc | Exit Fees'!J133","v":92.591868852374347},{"$f":"+'Calc | Exit Fees'!K133","v":97.342350407363242}]
[null,null,null,null,"Interest expense",null,0,0,0,0,0]
[null,null,null,null,"Tax expenses",null,{"$f":"SUM(G60:G63)","v":184.59921554232466},{"$f":"SUM(H60:H63)","v":228.10155175780099},{"$f":"SUM(I60:I63)","v":288.12834217337769},{"$f":"SUM(J60:J63)","v":360.51321735971476},{"$f":"SUM(K60:K63)","v":441.71593106884956}]
[]
[null,null,null,null,"Corporate tax rate",null,{"$f":"+'Inputs | General'!J$44","v":0.3},{"$f":"+'Inputs | General'!K$44","v":0.3},{"$f":"+'Inputs | General'!L$44","v":0.3},{"$f":"+'Inputs | General'!M$44","v":0.3},{"$f":"+'Inputs | General'!N$44","v":0.3}]
[null,null,null,null,"Imputation credits rate",null,{"$f":"+'Inputs | General'!J$43","v":0.56999999999999995},{"$f":"+'Inputs | General'!K$43","v":0.56999999999999995},{"$f":"+'Inputs | General'!L$43","v":0.56999999999999995},{"$f":"+'Inputs | General'!M$43","v":0.56999999999999995},{"$f":"+'Inputs | General'!N$43","v":0.56999999999999995}]
[null,null,null,null,"Taxable income",null,{"$f":"+G57-G64","v":55.805932402546887},{"$f":"+H57-H64","v":59.707335024485843},{"$f":"+I57-I64","v":67.9308103587544},{"$f":"+J57-J64","v":80.381940535471699},{"$f":"+K57-K64","v":93.263426508522173}]
[null,null,null,null,"Tax payable",null,{"$f":"+G68*G66/(1-G66*(1-G67))","v":19.221331481933483},{"$f":"+H68*H66/(1-H66*(1-H67))","v":20.565098171464697},{"$f":"+I68*I66/(1-I66*(1-I67))","v":23.397523659731711},{"$f":"+J68*J66/(1-J66*(1-J67))","v":27.686087440460973},{"$f":"+K68*K66/(1-K66*(1-K67))","v":32.122879394439323}]
[null,null,null,null,"Imputation credits",null,{"$f":"+G69*G67","v":10.956158944702084},{"$f":"+H69*H67","v":11.722105957734877},{"$f":"+I69*I67","v":13.336588486047074},{"$f":"+J69*J67","v":15.781069841062754},{"$f":"+K69*K67","v":18.310041254830413}]
[null,null,null,null,"Tax allowance",null,{"$f":"+G69-G70","v":8.2651725372313987},{"$f":"+H69-H70","v":8.8429922137298203},{"$f":"+I69-I70","v":10.060935173684637},{"$f":"+J69-J70","v":11.905017599398219},{"$f":"+K69-K70","v":13.81283813960891}]
[]
[null,null,null,{"$f":"'Input | Exit Fees'!D33","v":"Three Phase CT"}]
[null,null,null,null,"Revenue for Tax Assessment Subtotal"]
[null,null,null,null,"Meter RAB",null,{"$f":"+'Calc | Exit Fees'!G137","v":206.26558949728525},{"$f":"+'Calc | Exit Fees'!H137","v":253.68700732252285},{"$f":"+'Calc | Exit Fees'!I137","v":342.00600545421497},{"$f":"+'Calc | Exit Fees'!J137","v":454.97277835981771},{"$f":"+'Calc | Exit Fees'!K137","v":583.37050943586041}]
[null,null,null,null,"Comms, IT, Inhouse software & Equity Raising Costs RAB",null,{"$f":"+'Calc | Exit Fees'!G138","v":22.714161539740974},{"$f":"+'Calc | Exit Fees'!H138","v":32.996028721968216},{"$f":"+'Calc | Exit Fees'!I138","v":36.864772935679383},{"$f":"+'Calc | Exit Fees'!J138","v":41.118154502249979},{"$f":"+'Calc | Exit Fees'!K138","v":44.101025978888529}]
[null,null,null,null,"Admin cost",null,{"$f":"+'Calc | Exit Fees'!G139","v":78.113744129225978},{"$f":"+'Calc | Exit Fees'!H139","v":83.25631344010452},{"$f":"+'Calc | Exit Fees'!I139","v":88.085563423024794},{"$f":"+'Calc | Exit Fees'!J139","v":92.591868852374347},{"$f":"+'Calc | Exit Fees'!K139","v":97.342350407363242}]
[null,null,null,null,"Revenue for Tax Assessment Subtotal",null,{"$f":"SUM(G75:G77)","v":307.09349516625218},{"$f":"SUM(H75:H77)","v":369.9393494845956},{"$f":"SUM(I75:I77)","v":466.95634181291911},{"$f":"SUM(J75:J77)","v":588.68280171444201},{"$f":"SUM(K75:K77)","v":724.81388582211218}]
[]
[null,null,null,null,"Tax expenses"]
[null,null,null,null,"Meter TAB",null,{"$f":"+'Calc | Exit Fees'!G246","v":136.48313679982684},{"$f":"+'Calc | Exit Fees'!H246","v":181.59629844166002},{"$f":"+'Calc | Exit Fees'!I246","v":263.42683258979832},{"$f":"+'Calc | Exit Fees'!J246","v":363.62595402819949},{"$f":"+'Calc | Exit Fees'!K246","v":477.01309531222876}]
[null,null,null,null,"Comms, IT, Inhouse software & Equity Raising Costs TAB",null,{"$f":"+'Calc | Exit Fees'!G247","v":14.129107474189787},{"$f":"+'Calc | Exit Fees'!H247","v":22.040236180299065},{"$f":"+'Calc | Exit Fees'!I247","v":22.033438395964762},{"$f":"+'Calc | Exit Fees'!J247","v":22.411083006898075},{"$f":"+'Calc | Exit Fees'!K247","v":22.585260085863222}]
[null,null,null,null,"Admin cost",null,{"$f":"+'Calc | Exit Fees'!G139","v":78.113744129225978},{"$f":"+'Calc | Exit Fees'!H139","v":83.25631344010452},{"$f":"+'Calc | Exit Fees'!I139","v":88.085563423024794},{"$f":"+'Calc | Exit Fees'!J139","v":92.591868852374347},{"$f":"+'Calc | Exit Fees'!K139","v":97.342350407363242}]
[null,null,null,null,"Interest expense",null,0,0,0,0,0]
[null,null,null,null,"Tax expenses",null,{"$f":"SUM(G81:G84)","v":228.72598840324261},{"$f":"SUM(H81:H84)","v":286.89284806206365},{"$f":"SUM(I81:I84)","v":373.54583440878787},{"$f":"SUM(J81:J84)","v":478.62890588747189},{"$f":"SUM(K81:K84)","v":596.9407058054552}]
[]
[null,null,null,null,"Corporate tax rate",null,{"$f":"+'Inputs | General'!J$44","v":0.3},{"$f":"+'Inputs | General'!K$44","v":0.3},{"$f":"+'Inputs | General'!L$44","v":0.3},{"$f":"+'Inputs | General'!M$44","v":0.3},{"$f":"+'Inputs | General'!N$44","v":0.3}]
[null,null,null,null,"Imputation credits rate",null,{"$f":"+'Inputs | General'!J$43","v":0.56999999999999995},{"$f":"+'Inputs | General'!K$43","v":0.56999999999999995},{"$f":"+'Inputs | General'!L$43","v":0.56999999999999995},{"$f":"+'Inputs | General'!M$43","v":0.56999999999999995},{"$f":"+'Inputs | General'!N$43","v":0.56999999999999995}]
[null,null,null,null,"Taxable income",null,{"$f":"+G78-G85","v":78.367506763009573},{"$f":"+H78-H85","v":83.046501422531946},{"$f":"+I78-I85","v":93.410507404131238},{"$f":"+J78-J85","v":110.05389582697012},{"$f":"+K78-K85","v":127.87318001665699}]
[null,null,null,null,"Tax payable",null,{"$f":"+G89*G87/(1-G87*(1-G88))","v":26.992252616421208},{"$f":"+H89*H87/(1-H87*(1-H88))","v":28.603846643811234},{"$f":"+I89*I87/(1-I87*(1-I88))","v":32.17353871554463},{"$f":"+J89*J87/(1-J87*(1-J88))","v":37.906049079323807},{"$f":"+K89*K87/(1-K87*(1-K88))","v":44.043575206655674}]
[null,null,null,null,"Imputation credits",null,{"$f":"+G90*G88","v":15.385583991360088},{"$f":"+H90*H88","v":16.304192586972402},{"$f":"+I90*I88","v":18.338917067860439},{"$f":"+J90*J88","v":21.606447975214568},{"$f":"+K90*K88","v":25.104837867793734}]
[null,null,null,null,"Tax allowance",null,{"$f":"+G90-G91","v":11.60666862506112},{"$f":"+H90-H91","v":12.299654056838833},{"$f":"+I90-I91","v":13.834621647684191},{"$f":"+J90-J91","v":16.299601104109239},{"$f":"+K90-K91","v":18.938737338861941}]

{"sheet":"Output | Exit Fee price caps","index":8,"n_rows":62,"n_cols":14,"rows_kept":62,"cut":false,"hidden":false,"merged":[[59,8,59,12],[49,3,49,4],[50,3,50,4],[51,3,51,4],[52,3,52,4],[53,3,53,4],[61,3,61,4],[48,3,48,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[43,3,43,4],[44,3,44,4],[45,3,45,4],[46,3,46,4],[17,3,17,4],[60,3,60,4],[14,3,14,4],[47,3,47,4],[27,3,27,4],[0,13,0,14],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[22,8,22,12],[6,8,6,12],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[15,3,15,4],[16,3,16,4]]}
[null,{"$f":"'Title Page'!B8&\" v\"&'Title Page'!$C$10","v":"JEN 2027-31 - ACS Standardised Metering Pricing Model  v1.02"},null,null,null,null,null,null,null,null,null,null,"DNSP:","D"]
[null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"Output | Exit Fee price caps"},null,null,null,null,null,"Key:","Input","External Link","Internal Link"]
[]
[]
[null,null,"Applicable Exit Fees Price Caps"]
[]
[null,null,null,null,null,null,null,"Base Year","Regulatory Period"]
[null,null,null,"Exit Fee Name",null,"Units","Basis",{"$f":"LEFT(I8,4)-1&\"-\"&RIGHT(I8,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(I8,4)+1&\"-\"&RIGHT(I8,2)+1","v":"2027-28"},{"$f":"LEFT(J8,4)+1&\"-\"&RIGHT(J8,2)+1","v":"2028-29"},{"$f":"LEFT(K8,4)+1&\"-\"&RIGHT(K8,2)+1","v":"2029-30"},{"$f":"LEFT(L8,4)+1&\"-\"&RIGHT(L8,2)+1","v":"2030-31"}]
[null,null,null,{"$f":"D25","v":"Single Phase (inc. DC)"},null,"$dollars","nominal",{"$f":"ROUND(H25,2)","v":191.64},{"$f":"IF(I25=0,0,ROUND(H9*(1-I45)*(1+I$41),2))","v":206.54},{"$f":"IF(J25=0,0,ROUND(I9*(1-J45)*(1+J$41),2))","v":245.39},297.8,362.66,434.01]
[null,null,null,{"$f":"D26","v":"Single Phase, Two Element"},null,"$dollars","nominal",191.64,215.31,256.05,311.99,381.37,457.81]
[null,null,null,"Three Phase (inc. DC)",null,"$dollars","nominal",{"$f":"ROUND(H27,2)","v":191.64},{"$f":"IF(I27=0,0,ROUND(H11*(1-I47)*(1+I$41),2))","v":248.67},{"$f":"IF(J27=0,0,ROUND(I11*(1-J47)*(1+J$41),2))","v":296.64999999999998},{"$f":"IF(K27=0,0,ROUND(J11*(1-K47)*(1+K$41),2))","v":366.12},{"$f":"IF(L27=0,0,ROUND(K11*(1-L47)*(1+L$41),2))","v":452.8},{"$f":"IF(M27=0,0,ROUND(L11*(1-M47)*(1+M$41),2))","v":548.79}]
[null,null,null,"Three Phase CT",null,"$dollars","nominal",191.64,318.7,382.24,480.79,604.98,743.75]
[null,null,null,0,null,"$dollars","nominal",0,0,0,0,0,0]
[null,null,null,0,null,"$dollars","nominal",0,0,0,0,0,0]
[null,null,null,0,null,"$dollars","nominal",0,0,0,0,0,0]
[null,null,null,0,null,"$dollars","nominal",0,0,0,0,0,0]
[null,null,null,0,null,"$dollars","nominal",0,0,0,0,0,0]
[null,null,null,0,null,"$dollars","nominal",0,0,0,0,0,0]
[]
[]
[null,null,"Exit Fees Per Meter"]
[]
[null,null,null,null,null,null,null,"Base Year","Regulatory Period"]
[null,null,null,"Exit Fee Name",null,"Units","Basis",{"$f":"LEFT(I24,4)-1&\"-\"&RIGHT(I24,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(I24,4)+1&\"-\"&RIGHT(I24,2)+1","v":"2027-28"},{"$f":"LEFT(J24,4)+1&\"-\"&RIGHT(J24,2)+1","v":"2028-29"},{"$f":"LEFT(K24,4)+1&\"-\"&RIGHT(K24,2)+1","v":"2029-30"},{"$f":"LEFT(L24,4)+1&\"-\"&RIGHT(L24,2)+1","v":"2030-31"}]
[null,null,null,{"$f":"'Input | Exit Fees'!$D30","v":"Single Phase (inc. DC)"},null,"$dollars","nominal",{"$f":"INDEX(Table3[2025-26],MATCH('Output | Exit Fee price caps'!$D25,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":191.64},{"$f":"INDEX(Table3[2026-27],MATCH('Output | Exit Fee price caps'!$D25,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":206.53959621436496},{"$f":"INDEX(Table3[2027-28],MATCH('Output | Exit Fee price caps'!$D25,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":245.39060480965264},{"$f":"INDEX(Table3[2028-29],MATCH('Output | Exit Fee price caps'!$D25,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":297.79712601493776},{"$f":"INDEX(Table3[2029-30],MATCH('Output | Exit Fee price caps'!$D25,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":362.66038385274749},{"$f":"INDEX(Table3[2030-31],MATCH('Output | Exit Fee price caps'!$D25,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":434.00677598238741}]
[null,null,null,{"$f":"'Input | Exit Fees'!$D31","v":"Single Phase, Two Element"},null,"$dollars","nominal",{"$f":"INDEX(Table3[2025-26],MATCH('Output | Exit Fee price caps'!$D26,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":191.64},{"$f":"INDEX(Table3[2026-27],MATCH('Output | Exit Fee price caps'!$D26,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":215.31014027044148},{"$f":"INDEX(Table3[2027-28],MATCH('Output | Exit Fee price caps'!$D26,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":256.05385560954142},{"$f":"INDEX(Table3[2028-29],MATCH('Output | Exit Fee price caps'!$D26,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":311.99688827554445},{"$f":"INDEX(Table3[2029-30],MATCH('Output | Exit Fee price caps'!$D26,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":381.37549049312508},{"$f":"INDEX(Table3[2030-31],MATCH('Output | Exit Fee price caps'!$D26,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":457.81417274773304}]
[null,null,null,{"$f":"'Input | Exit Fees'!$D32","v":"Three Phase (inc. DC)"},null,"$dollars","nominal",{"$f":"INDEX(Table3[2025-26],MATCH('Output | Exit Fee price caps'!$D27,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":191.64},{"$f":"INDEX(Table3[2026-27],MATCH('Output | Exit Fee price caps'!$D27,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":248.67032048210294},{"$f":"INDEX(Table3[2027-28],MATCH('Output | Exit Fee price caps'!$D27,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":296.65187899601665},{"$f":"INDEX(Table3[2028-29],MATCH('Output | Exit Fee price caps'!$D27,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":366.12008770581673},{"$f":"INDEX(Table3[2029-30],MATCH('Output | Exit Fee price caps'!$D27,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":452.80017549458466},{"$f":"INDEX(Table3[2030-31],MATCH('Output | Exit Fee price caps'!$D27,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":548.79219571698059}]
[null,null,null,{"$f":"'Input | Exit Fees'!$D33","v":"Three Phase CT"},null,"$dollars","nominal",{"$f":"INDEX(Table3[2025-26],MATCH('Output | Exit Fee price caps'!$D28,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":191.64},{"$f":"INDEX(Table3[2026-27],MATCH('Output | Exit Fee price caps'!$D28,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":318.70016379131329},{"$f":"INDEX(Table3[2027-28],MATCH('Output | Exit Fee price caps'!$D28,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":382.23900354143444},{"$f":"INDEX(Table3[2028-29],MATCH('Output | Exit Fee price caps'!$D28,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":480.79096346060328},{"$f":"INDEX(Table3[2029-30],MATCH('Output | Exit Fee price caps'!$D28,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":604.98240281855124},{"$f":"INDEX(Table3[2030-31],MATCH('Output | Exit Fee price caps'!$D28,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":743.75262316097417}]
[null,null,null,{"$f":"'Input | Exit Fees'!$D34","v":0},null,"$dollars","nominal",{"$f":"INDEX(Table3[2025-26],MATCH('Output | Exit Fee price caps'!$D29,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2026-27],MATCH('Output | Exit Fee price caps'!$D29,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2027-28],MATCH('Output | Exit Fee price caps'!$D29,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2028-29],MATCH('Output | Exit Fee price caps'!$D29,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2029-30],MATCH('Output | Exit Fee price caps'!$D29,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2030-31],MATCH('Output | Exit Fee price caps'!$D29,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0}]
[null,null,null,{"$f":"'Input | Exit Fees'!$D35","v":0},null,"$dollars","nominal",{"$f":"INDEX(Table3[2025-26],MATCH('Output | Exit Fee price caps'!$D30,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2026-27],MATCH('Output | Exit Fee price caps'!$D30,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2027-28],MATCH('Output | Exit Fee price caps'!$D30,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2028-29],MATCH('Output | Exit Fee price caps'!$D30,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2029-30],MATCH('Output | Exit Fee price caps'!$D30,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2030-31],MATCH('Output | Exit Fee price caps'!$D30,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0}]
[null,null,null,{"$f":"'Input | Exit Fees'!$D36","v":0},null,"$dollars","nominal",{"$f":"INDEX(Table3[2025-26],MATCH('Output | Exit Fee price caps'!$D31,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2026-27],MATCH('Output | Exit Fee price caps'!$D31,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2027-28],MATCH('Output | Exit Fee price caps'!$D31,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2028-29],MATCH('Output | Exit Fee price caps'!$D31,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2029-30],MATCH('Output | Exit Fee price caps'!$D31,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2030-31],MATCH('Output | Exit Fee price caps'!$D31,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0}]
[null,null,null,{"$f":"'Input | Exit Fees'!$D37","v":0},null,"$dollars","nominal",{"$f":"INDEX(Table3[2025-26],MATCH('Output | Exit Fee price caps'!$D32,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2026-27],MATCH('Output | Exit Fee price caps'!$D32,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2027-28],MATCH('Output | Exit Fee price caps'!$D32,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2028-29],MATCH('Output | Exit Fee price caps'!$D32,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2029-30],MATCH('Output | Exit Fee price caps'!$D32,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2030-31],MATCH('Output | Exit Fee price caps'!$D32,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0}]
[null,null,null,{"$f":"'Input | Exit Fees'!$D38","v":0},null,"$dollars","nominal",{"$f":"INDEX(Table3[2025-26],MATCH('Output | Exit Fee price caps'!$D33,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2026-27],MATCH('Output | Exit Fee price caps'!$D33,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2027-28],MATCH('Output | Exit Fee price caps'!$D33,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2028-29],MATCH('Output | Exit Fee price caps'!$D33,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2029-30],MATCH('Output | Exit Fee price caps'!$D33,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2030-31],MATCH('Output | Exit Fee price caps'!$D33,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0}]
[null,null,null,{"$f":"'Input | Exit Fees'!$D39","v":0},null,"$dollars","nominal",{"$f":"INDEX(Table3[2025-26],MATCH('Output | Exit Fee price caps'!$D34,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2026-27],MATCH('Output | Exit Fee price caps'!$D34,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2027-28],MATCH('Output | Exit Fee price caps'!$D34,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2028-29],MATCH('Output | Exit Fee price caps'!$D34,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2029-30],MATCH('Output | Exit Fee price caps'!$D34,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2030-31],MATCH('Output | Exit Fee price caps'!$D34,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0}]
[]
[]
[]
[]
[null,null,"Xfactors"]
[]
[null,null,null,"CPI",null,"%",null,null,{"$f":"'Inputs | General'!J26","v":2.6198992109813399E-2},{"$f":"'Inputs | General'!K26","v":2.6198992109813399E-2},{"$f":"'Inputs | General'!L26","v":2.6198992109813399E-2},{"$f":"'Inputs | General'!M26","v":2.6198992109813399E-2},{"$f":"'Inputs | General'!N26","v":2.6198992109813399E-2}]
[]
[null,null,null,null,null,null,null,null,{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(I43,4)+1&\"-\"&RIGHT(I43,2)+1","v":"2027-28"},{"$f":"LEFT(J43,4)+1&\"-\"&RIGHT(J43,2)+1","v":"2028-29"},{"$f":"LEFT(K43,4)+1&\"-\"&RIGHT(K43,2)+1","v":"2029-30"},{"$f":"LEFT(L43,4)+1&\"-\"&RIGHT(L43,2)+1","v":"2030-31"}]
[null,null,null,"Exit Fee Name",null,"Units",null,null,"P_0","X_02","X_03","X_04","X_05"]
[null,null,null,{"$f":"'Input | Exit Fees'!$D30","v":"Single Phase (inc. DC)"},null,"%",null,null,{"$f":"IFERROR(-1*(((I25/H25)/(1+I$41)-1)),\"\")","v":-5.0232799977929066E-2},-0.1577719503917232,-0.18258124573797296,-0.18671936962329516,-0.16617790655655873]
[null,null,null,{"$f":"'Input | Exit Fees'!$D31","v":"Single Phase, Two Element"},null,"%",null,null,-9.4830122768194025E-2,-0.15887141899503865,-0.18737351917710665,-0.19116228138556646,-0.16978182715100454]
[null,null,null,{"$f":"'Input | Exit Fees'!$D32","v":"Three Phase (inc. DC)"},null,"%",null,null,-0.26446323967957852,-0.16249626353623015,-0.20266554871233522,-0.20517869315900872,-0.18105400438491159]
[null,null,null,{"$f":"'Input | Exit Fees'!$D33","v":"Three Phase CT"},null,"%",null,null,-0.62055785673457375,-0.16874867035413077,-0.22571559692466492,-0.2261817903272425,-0.19799273460056033]
[null,null,null,{"$f":"'Input | Exit Fees'!$D34","v":0},null,"%",null,null,"","","","",""]
[null,null,null,{"$f":"'Input | Exit Fees'!$D35","v":0},null,"%",null,null,"","","","",""]
[null,null,null,{"$f":"'Input | Exit Fees'!$D36","v":0},null,"%",null,null,"","","","",""]
[null,null,null,{"$f":"'Input | Exit Fees'!$D37","v":0},null,"%",null,null,"","","","",""]
[null,null,null,{"$f":"'Input | Exit Fees'!$D38","v":0},null,"%",null,null,"","","","",""]
[null,null,null,{"$f":"'Input | Exit Fees'!$D39","v":0},null,"%",null,null,"","","","",""]
[]
[]
[]
[null,null,"Cost Metric"]
[]
[null,null,null,null,null,null,null,"Base Year","Regulatory Period"]
[null,null,null,"Exit Fee Per Meter",null,"Units","Basis",{"$f":"LEFT(I61,4)-1&\"-\"&RIGHT(I61,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(I61,4)+1&\"-\"&RIGHT(I61,2)+1","v":"2027-28"},{"$f":"LEFT(J61,4)+1&\"-\"&RIGHT(J61,2)+1","v":"2028-29"},{"$f":"LEFT(K61,4)+1&\"-\"&RIGHT(K61,2)+1","v":"2029-30"},{"$f":"LEFT(L61,4)+1&\"-\"&RIGHT(L61,2)+1","v":"2030-31"}]
[null,null,null,"Volume Weighted Average Exit Fee - Per Meter",null,"$dollars","nominal",{"$f":"SUMPRODUCT(H$25:H$34,'Calc | Exit Fees'!J$31:J$40)/'Calc | Exit Fees'!J$41","v":191.63999999999996},{"$f":"SUMPRODUCT(I$25:I$34,'Calc | Exit Fees'!K$31:K$40)/'Calc | Exit Fees'!K$41","v":214.92110478366101},{"$f":"SUMPRODUCT(J$25:J$34,'Calc | Exit Fees'!L$31:L$40)/'Calc | Exit Fees'!L$41","v":256.57192291237016},{"$f":"SUMPRODUCT(K$25:K$34,'Calc | Exit Fees'!M$31:M$40)/'Calc | Exit Fees'!M$41","v":314.04481286127111},{"$f":"SUMPRODUCT(L$25:L$34,'Calc | Exit Fees'!N$31:N$40)/'Calc | Exit Fees'!N$41","v":385.82533417314681},{"$f":"SUMPRODUCT(M$25:M$34,'Calc | Exit Fees'!O$31:O$40)/'Calc | Exit Fees'!O$41","v":465.65090150121478}]

{"sheet":"LUTs and Dropdowns","index":9,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Title Page'!B8&\" v\"&'Title Page'!$C$10","v":"JEN 2027-31 - ACS Standardised Metering Pricing Model  v1.02"}]
[null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"LUTs and Dropdowns"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Model Use"]
[null,"Price Cap"]
[null,"Exit Fees (Vic)"]
[null,"Show All Sheets"]
[]
[]
[null,"Admin Charges"]
[null,"Entered"]
[null,"Calc-Fixed"]
[null,"Calc-Hourly"]