{"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":2,"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":13,"n_cols":4,"rows_kept":13,"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"]

{"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,"revised proposal"]
[]
[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,{"$f":"'[1]Input| Prices'!M$23","v":2.6597593508804751E-2},{"$f":"'[1]Input| Prices'!N$23","v":2.6597593508804751E-2},{"$f":"'[1]Input| Prices'!O$23","v":2.6597593508804751E-2},{"$f":"'[1]Input| Prices'!P$23","v":2.6597593508804751E-2},{"$f":"'[1]Input| Prices'!Q$23","v":2.6597593508804751E-2}]
[null,null,"Cumulative Inflation Index (CPI end period)",null,"Index",null,null,null,1,{"$f":"I27*(1+J26)","v":1.0265975935088048},{"$f":"J27*(1+K26)","v":1.0539026189980691},{"$f":"K27*(1+L26)","v":1.0819338924560444},{"$f":"L27*(1+M26)","v":1.1107107303309891},{"$f":"M27*(1+N26)","v":1.1402529628422005}]
[null,null,"Historical Inflation (CPI % increase)",null,"%",null,null,{"$f":"'[1]Input| Prices'!K$23","v":2.4246877296105973E-2},{"$f":"'[1]Input| Prices'!L$23","v":0.03}]
[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.0549742836149891},{"$f":"I29*(1+J26)","v":1.083034060772823},{"$f":"J29*(1+K26)","v":1.1118401604774488},1.1414124331125923,1.1717712570344168,1.2029375526143193]
[]
[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,{"$f":"'[1]Input| Prices'!M$43","v":8.1208180725738932E-3},{"$f":"'[1]Input| Prices'!N$43","v":9.5505821675600684E-3},{"$f":"'[1]Input| Prices'!O$43","v":1.1199334904118818E-2},{"$f":"'[1]Input| Prices'!P$43","v":1.2274361918209287E-2},{"$f":"'[1]Input| Prices'!Q$43","v":1.2025416152939058E-2}]
[null,null,"Real Price index to input year",null,"Index",null,null,null,1,{"$f":"I34*(1+J33)","v":1.0081208180725738},{"$f":"J34*(1+K33)","v":1.0177489587804038},{"$f":"K34*(1+L33)","v":1.0291470702181038},{"$f":"L34*(1+M33)","v":1.0417791938250256},{"$f":"M34*(1+N33)","v":1.0543070221702449}]
[null,null,"Historical Real input cost escalation (% increase)",null,"%",null,null,{"$f":"'[1]Input| Prices'!K$43","v":1.8251668270074514E-2},{"$f":"'[1]Input| Prices'!L$43","v":1.2760766141320486E-2}]
[null,null,"Cumulative Real input cost escalation Index (Jun 2024 to Nominal)",null,"Index",null,1,{"$f":"G36*(1+H35)","v":1.0182516682700744},{"$f":"H36*(1+I35)","v":1.0312453396818784},{"$f":"I36*(1+J33)","v":1.0396198954736244},{"$f":"J36*(1+K33)","v":1.0495488707083755},1.0613031200096783,1.0743299386096019,1.0872492032069436]
[]
[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":48.426387001777677},{"$f":"+H12","v":67.58559211095681},92.648565065246743,121.67668827482134,153.31704511439389,188.86855320958239,"Opening balance of METERS row in PTRM inputs sheet of PTRM"]
[null,null,"Gross capital expenditure",null,"$m","Nominal",null,{"$f":"[2]Assets!G$64","v":23.289094051416797},{"$f":"[2]Assets!H$64","v":30.42127848981281},{"$f":"[2]Assets!I$64","v":35.992171639418039},{"$f":"[2]Assets!J$64","v":40.546394987826524},{"$f":"[2]Assets!K$64","v":46.713934824750524},null,"Gross capex from METERS row in ASSETS sheet of PTRM"]
[null,null,"Regulatory depreciation",null,"$m","Nominal",null,{"$f":"[2]Assets!G$154*[2]Assets!G$7-H9*[2]Assets!G$6","v":4.1298889422376757},{"$f":"[2]Assets!H$154*[2]Assets!H$7-I9*[2]Assets!H$6","v":5.3583055355228772},{"$f":"[2]Assets!I$154*[2]Assets!I$7-J9*[2]Assets!I$6","v":6.9640484298434444},{"$f":"[2]Assets!J$154*[2]Assets!J$7-K9*[2]Assets!J$6","v":8.906038148253959},{"$f":"[2]Assets!K$154*[2]Assets!K$7-L9*[2]Assets!K$6","v":11.162426729562014},null,"Depreciation from METERS row in ASSETS sheet of PTRM"]
[null,null,"Closing RAB",null,"$m","Nominal",{"$f":"[2]!A3value","v":48.426387001777677},{"$f":"+H9+H10-H11","v":67.58559211095681},{"$f":"+I9+I10-I11","v":92.648565065246743},121.67668827482134,153.31704511439389,188.86855320958239,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.0424658357638208},{"$f":"+H19","v":16.112932546728139},22.00524213490209,26.044708547343596,31.616955808961556,33.851299735096127,"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,{"$f":"[2]Assets!G$61-H10","v":11.339441192098988},{"$f":"[2]Assets!H$61-I10","v":8.6403509658323863},{"$f":"[2]Assets!I$61-J10","v":7.7588396724066939},{"$f":"[2]Assets!J$61-K10","v":10.335122035852294},{"$f":"[2]Assets!K$61-L10","v":8.5105063229978697},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,{"$f":"-[2]Assets!G$1436-[2]Assets!G$1437-H11","v":1.2689744811346708},{"$f":"-[2]Assets!H$1436-[2]Assets!H$1437-I11","v":2.7480413776584349},{"$f":"-[2]Assets!I$1436-[2]Assets!I$1437-J11","v":3.7193732599651881},{"$f":"-[2]Assets!J$1436-[2]Assets!J$1437-K11","v":4.7628747742343318},{"$f":"-[2]Assets!K$1436-[2]Assets!K$1437-L11","v":6.2761623968632989},null,"Depreciation from COMMS & IT & Inhouse Software & Equity Raising Costs rows in ASSETS sheet of PTRM"]
[null,null,"Closing RAB",null,"$m","Nominal",{"$f":"[2]!RAB-G12","v":6.0424658357638208},{"$f":"+H16+H17-H18","v":16.112932546728139},{"$f":"+I16+I17-I18","v":22.00524213490209},{"$f":"+J16+J17-J18","v":26.044708547343596},{"$f":"+K16+K17-K18","v":31.616955808961556},{"$f":"+L16+L17-L18","v":33.851299735096127},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},54.468852837541498,83.698524657684942,114.65380720014883,147.72139682216493,184.93400092335546,222.71985294467851]
[null,"TOTAL Closing RAB",null,null,"$m","Nominal",{"$f":"G12+G19","v":54.468852837541498},{"$f":"H12+H19","v":83.698524657684942},114.65380720014883,147.72139682216493,184.93400092335546,222.71985294467851]
[]
[]
[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",{"$f":"('[1]Input | Meters Vols & Costs'!P125*'[1]Input | Meters Vols & Costs'!M150/SUM('[1]Input | Meters Vols & Costs'!$M$150,'[1]Input | Meters Vols & Costs'!$M$153)+'[1]Input | Meters Vols & Costs'!P128*'[1]Input | Meters Vols & Costs'!M153/SUM('[1]Input | Meters Vols & Costs'!$M$150,'[1]Input | Meters Vols & Costs'!$M$153))","v":224.20514159725627},{"$f":"('[1]Input | Meters Vols & Costs'!W103*'[1]Input | Meters Vols & Costs'!M150/SUM('[1]Input | Meters Vols & Costs'!$M$150,'[1]Input | Meters Vols & Costs'!$M$153)+'[1]Input | Meters Vols & Costs'!W106*'[1]Input | Meters Vols & Costs'!M153/SUM('[1]Input | Meters Vols & Costs'!$M$150,'[1]Input | Meters Vols & Costs'!$M$153))","v":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",{"$f":"('[1]Input | Meters Vols & Costs'!P126)","v":261.36},{"$f":"('[1]Input | Meters Vols & Costs'!W104)","v":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",{"$f":"('[1]Input | Meters Vols & Costs'!P127*'[1]Input | Meters Vols & Costs'!M152/SUM('[1]Input | Meters Vols & Costs'!$M$152,'[1]Input | Meters Vols & Costs'!$M$154)+'[1]Input | Meters Vols & Costs'!P129*'[1]Input | Meters Vols & Costs'!M154/SUM('[1]Input | Meters Vols & Costs'!$M$152,'[1]Input | Meters Vols & Costs'!$M$154))","v":386.98566663193992},{"$f":"('[1]Input | Meters Vols & Costs'!W105*'[1]Input | Meters Vols & Costs'!M152/SUM('[1]Input | Meters Vols & Costs'!$M$152,'[1]Input | Meters Vols & Costs'!$M$154)+'[1]Input | Meters Vols & Costs'!W107*'[1]Input | Meters Vols & Costs'!M154/SUM('[1]Input | Meters Vols & Costs'!$M$152,'[1]Input | Meters Vols & Costs'!$M$154))","v":226.34158986538534},613.32725649732527]
[null,null,null,"Three Phase CT",null,null,null,{"$f":"+D53","v":"Three Phase CT"},"$dollars","2024-06-01",{"$f":"('[1]Input | Meters Vols & Costs'!P130)","v":502.94},{"$f":"('[1]Input | Meters Vols & Costs'!W108)","v":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.",{"$f":"SUM('[1]Input | Meters Vols & Costs'!P$412,'[1]Input | Meters Vols & Costs'!P$415)","v":310245.33490393456},{"$f":"SUM('[1]Input | Meters Vols & Costs'!Q$412,'[1]Input | Meters Vols & Costs'!Q$415)","v":309729.92547962011},{"$f":"SUM('[1]Input | Meters Vols & Costs'!R$412,'[1]Input | Meters Vols & Costs'!R$415)","v":308375.13589472865},{"$f":"SUM('[1]Input | Meters Vols & Costs'!S$412,'[1]Input | Meters Vols & Costs'!S$415)","v":307003.79862656241},{"$f":"SUM('[1]Input | Meters Vols & Costs'!T$412,'[1]Input | Meters Vols & Costs'!T$415)","v":305615.91087206162},{"$f":"SUM('[1]Input | Meters Vols & Costs'!U$412,'[1]Input | Meters Vols & Costs'!U$415)","v":304211.46965250559}]
[null,null,null,null,null,null,null,"Single Phase, Two Element","No.",{"$f":"'[1]Input | Meters Vols & Costs'!P$413","v":20745.718893714988},{"$f":"'[1]Input | Meters Vols & Costs'!Q$413","v":20479.172000981489},{"$f":"'[1]Input | Meters Vols & Costs'!R$413","v":20209.329777810533},{"$f":"'[1]Input | Meters Vols & Costs'!S$413","v":19936.191645302082},{"$f":"'[1]Input | Meters Vols & Costs'!T$413","v":19659.757045152546},{"$f":"'[1]Input | Meters Vols & Costs'!U$413","v":19380.025384070817}]
[null,null,null,null,null,null,null,"Three Phase (inc. DC)","No.",{"$f":"SUM('[1]Input | Meters Vols & Costs'!P$414,'[1]Input | Meters Vols & Costs'!P$416)","v":64099.481476673835},{"$f":"SUM('[1]Input | Meters Vols & Costs'!Q$414,'[1]Input | Meters Vols & Costs'!Q$416)","v":72599.146280530389},{"$f":"SUM('[1]Input | Meters Vols & Costs'!R$414,'[1]Input | Meters Vols & Costs'!R$416)","v":82004.233944211752},{"$f":"SUM('[1]Input | Meters Vols & Costs'!S$414,'[1]Input | Meters Vols & Costs'!S$416)","v":91524.197315209953},{"$f":"SUM('[1]Input | Meters Vols & Costs'!T$414,'[1]Input | Meters Vols & Costs'!T$416)","v":101159.05585265232},{"$f":"SUM('[1]Input | Meters Vols & Costs'!U$414,'[1]Input | Meters Vols & Costs'!U$416)","v":110908.83023512206}]
[null,null,null,null,null,null,null,"Three Phase CT","No.",{"$f":"'[1]Input | Meters Vols & Costs'!P$417","v":2635.2188695903733},{"$f":"'[1]Input | Meters Vols & Costs'!Q$417","v":2826.5625699480415},{"$f":"'[1]Input | Meters Vols & Costs'!R$417","v":3028.6860840727386},{"$f":"'[1]Input | Meters Vols & Costs'!S$417","v":3233.2783770627407},{"$f":"'[1]Input | Meters Vols & Costs'!T$417","v":3440.3398671116192},{"$f":"'[1]Input | Meters Vols & Costs'!U$417","v":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",76.332841312427618]
[]
[]
[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.162207177833265},{"$f":"$G$92*$G97*$I97*'Inputs | General'!K$29*'Inputs | General'!K$36","v":7.4229272629171597},{"$f":"$G$92*$G97*$I97*'Inputs | General'!L$29*'Inputs | General'!L$36","v":7.7057022203989929},{"$f":"$G$92*$G97*$I97*'Inputs | General'!M$29*'Inputs | General'!M$36","v":8.0077536026038434},{"$f":"$G$92*$G97*$I97*'Inputs | General'!N$29*'Inputs | General'!N$36","v":8.3195984043784978}]
[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.162207177833265},{"$f":"$G$92*$G98*$I98*'Inputs | General'!K$29*'Inputs | General'!K$36","v":7.4229272629171597},{"$f":"$G$92*$G98*$I98*'Inputs | General'!L$29*'Inputs | General'!L$36","v":7.7057022203989929},{"$f":"$G$92*$G98*$I98*'Inputs | General'!M$29*'Inputs | General'!M$36","v":8.0077536026038434},{"$f":"$G$92*$G98*$I98*'Inputs | General'!N$29*'Inputs | General'!N$36","v":8.3195984043784978}]
[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.162207177833265},{"$f":"$G$92*$G99*$I99*'Inputs | General'!K$29*'Inputs | General'!K$36","v":7.4229272629171597},{"$f":"$G$92*$G99*$I99*'Inputs | General'!L$29*'Inputs | General'!L$36","v":7.7057022203989929},{"$f":"$G$92*$G99*$I99*'Inputs | General'!M$29*'Inputs | General'!M$36","v":8.0077536026038434},{"$f":"$G$92*$G99*$I99*'Inputs | General'!N$29*'Inputs | General'!N$36","v":8.3195984043784978}]
[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.162207177833265},{"$f":"$G$92*$G100*$I100*'Inputs | General'!K$29*'Inputs | General'!K$36","v":7.4229272629171597},{"$f":"$G$92*$G100*$I100*'Inputs | General'!L$29*'Inputs | General'!L$36","v":7.7057022203989929},{"$f":"$G$92*$G100*$I100*'Inputs | General'!M$29*'Inputs | General'!M$36","v":8.0077536026038434},{"$f":"$G$92*$G100*$I100*'Inputs | General'!N$29*'Inputs | General'!N$36","v":8.3195984043784978}]
[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.2973243066999602},{"$f":"$G$92*$G101*$I101*'Inputs | General'!K$29*'Inputs | General'!K$36","v":4.4537563577502963},{"$f":"$G$92*$G101*$I101*'Inputs | General'!L$29*'Inputs | General'!L$36","v":4.6234213322393964},{"$f":"$G$92*$G101*$I101*'Inputs | General'!M$29*'Inputs | General'!M$36","v":4.8046521615623066},{"$f":"$G$92*$G101*$I101*'Inputs | General'!N$29*'Inputs | General'!N$36","v":4.9917590426270992}]
[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.8648828711333065},{"$f":"$G$92*$G102*$I102*'Inputs | General'!K$29*'Inputs | General'!K$36","v":2.9691709051668638},{"$f":"$G$92*$G102*$I102*'Inputs | General'!L$29*'Inputs | General'!L$36","v":3.0822808881595973},{"$f":"$G$92*$G102*$I102*'Inputs | General'!M$29*'Inputs | General'!M$36","v":3.2031014410415373},{"$f":"$G$92*$G102*$I102*'Inputs | General'!N$29*'Inputs | General'!N$36","v":3.3278393617513995}]
[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.162207177833265},{"$f":"IF($H110=\"Calc-Fixed\",$I110*$G110,IF($H110=\"Calc-Hourly\",$G$92*$G110*$I110,IF($H110=\"Entered\",L97,0)))","v":7.4229272629171597},{"$f":"IF($H110=\"Calc-Fixed\",$I110*$G110,IF($H110=\"Calc-Hourly\",$G$92*$G110*$I110,IF($H110=\"Entered\",M97,0)))","v":7.7057022203989929},8.0077536026038434,8.3195984043784978]
[null,null,null,"Write off meter from AMI SAP",null,null,8.3333333333333329E-2,"Entered",1,"Nominal",7.162207177833265,7.4229272629171597,7.7057022203989929,8.0077536026038434,8.3195984043784978]
[null,null,null,"Update new meter detail in ERP SAP",null,null,8.3333333333333329E-2,"Entered",1,"Nominal",7.162207177833265,7.4229272629171597,7.7057022203989929,8.0077536026038434,8.3195984043784978]
[null,null,null,"SAP ERP internal Service Order creation and close out",null,null,8.3333333333333329E-2,"Entered",1,"Nominal",7.162207177833265,7.4229272629171597,7.7057022203989929,8.0077536026038434,8.3195984043784978]
[null,null,null,"Manage system exceptions, errors and reporting",null,null,0.25,"Entered",0.2,"Nominal",4.2973243066999602,4.4537563577502963,4.6234213322393964,4.8046521615623066,4.9917590426270992]
[null,null,null,"Manage phone calls and inquiries",null,null,0.16666666666666666,"Entered",0.2,"Nominal",2.8648828711333065,2.9691709051668638,3.0822808881595973,3.2031014410415373,3.3278393617513995]
[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",{"$f":"IF($H117=\"Calc-Fixed\",$I117*$G117,IF($H117=\"Calc-Hourly\",$G$92*$G117*$I117,IF($H117=\"Entered\",K104,0)))","v":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.859266178541176},{"$f":"SUM(L110:L119)","v":84.078246264713485},{"$f":"SUM(M110:M119)","v":88.997112820564254},{"$f":"SUM(N110:N119)","v":93.59208989469623},{"$f":"SUM(O110:O119)","v":98.418889948844097}]
[]
[]
[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":33.918900960120169},{"$f":"+H130","v":51.233160314658519},72.945902465486341,96.931800656092392,122.02471725478522,151.64700437117148,"Opening tax balance of METERS row in PTRM inputs sheet of PTRM"]
[null,null,"Gross capital expenditure",null,"$m","Nominal",null,{"$f":"'[2]PTRM input'!G$279*[2]Assets!G$7","v":22.917198004666083},{"$f":"'[2]PTRM input'!H$279*[2]Assets!H$7","v":29.927412512557112},{"$f":"'[2]PTRM input'!I$279*[2]Assets!I$7","v":35.398764636775489},{"$f":"'[2]PTRM input'!J$279*[2]Assets!J$7","v":39.861977374091673},{"$f":"'[2]PTRM input'!K$279*[2]Assets!K$7","v":45.892249417024289},null,"Gross capex from METERS row in PTRM input sheet of PTRM"]
[null,null,"Tax depreciation",null,"$m","Nominal",null,{"$f":"[2]Assets!G$818","v":5.602938650127733},{"$f":"[2]Assets!H$818","v":8.21467036172929},{"$f":"[2]Assets!I$818","v":11.412866446169444},{"$f":"[2]Assets!J$818","v":14.769060775398836},{"$f":"[2]Assets!K$818","v":16.269962300638028},null,"Tax Depreciation from METERS row in ASSETS sheet of PTRM"]
[null,null,"Closing TAB",null,"$m","Nominal",{"$f":"[2]!A3taxvalue","v":33.918900960120169},{"$f":"+H127+H128-H129","v":51.233160314658519},{"$f":"+I127+I128-I129","v":72.945902465486341},96.931800656092392,122.02471725478522,151.64700437117148,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.8986131211141526},{"$f":"+H137","v":12.303210777519752},14.684078066173859,14.350783239689674,16.054364381633924,15.231624257757861,"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,{"$f":"'[2]PTRM input'!G$327*[2]Assets!G$7-H128","v":11.158365305574875},{"$f":"'[2]PTRM input'!H$327*[2]Assets!H$7-I128","v":8.5000815364919333},{"$f":"'[2]PTRM input'!I$327*[2]Assets!I$7-J128","v":7.6309188056106336},{"$f":"'[2]PTRM input'!J$327*[2]Assets!J$7-K128","v":10.160666586395926},{"$f":"'[2]PTRM input'!K$327*[2]Assets!K$7-L128","v":8.3608088315704379},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,{"$f":"+-[2]Assets!G$1446-H129","v":1.7537676491692755},{"$f":"+-[2]Assets!H$1446-I129","v":6.1192142478378262},{"$f":"+-[2]Assets!I$1446-J129","v":7.96421363209482},{"$f":"+-[2]Assets!J$1446-K129","v":8.4570854444516765},{"$f":"+-[2]Assets!K$1446-L129","v":9.1835489554465006},null,"Tax Depreciation from COMMS & IT & Inhouse Software & Equity Raising Costs rows in ASSETS sheet of PTRM"]
[null,null,"Closing TAB",null,"$m","Nominal",{"$f":"'[2]PTRM input'!$N$57-G130","v":2.8986131211141526},{"$f":"+H134+H135-H136","v":12.303210777519752},{"$f":"+I134+I135-I136","v":14.684078066173859},{"$f":"+J134+J135-J136","v":14.350783239689674},{"$f":"+K134+K135-K136","v":16.054364381633924},{"$f":"+L134+L135-L136","v":15.231624257757861},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},36.817514081234322,63.536371092178271,87.629980531660195,111.28258389578207,138.07908163641915,166.87862862892933]
[null,"TOTAL Closing TAB",null,null,"$m","Nominal",{"$f":"G130+G137","v":36.817514081234322},{"$f":"H130+H137","v":63.536371092178271},87.629980531660195,111.28258389578207,138.07908163641915,166.87862862892933]

{"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":148969991.10102135},{"$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":153191305.8620038},{"$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":157443869.57861108},{"$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":161894052.35702032},{"$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":166443087.11686885}]
[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":10735116.418565106},{"$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":10924674.356841441},{"$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":11122443.512830459},{"$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":11325774.468772206},{"$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":11527754.518337283}]
[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":46065151.820804678},{"$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":53677607.911332682},{"$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":62114238.406433359},{"$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":71137990.284515172},{"$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":80750165.026153713}]
[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":2721108.7682514694},{"$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":3007692.696590852},{"$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":3319019.0668183649},{"$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":3651722.8824550631},{"$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":4004970.8166544186}]
[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":208491368.10864261},{"$f":"SUM(L46:L55)","v":220801280.82676876},{"$f":"SUM(M46:M55)","v":233999570.56469327},{"$f":"SUM(N46:N55)","v":248009539.99276274},{"$f":"SUM(O46:O55)","v":262725977.47801426}]
[]
[]
[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.71451395063701006},0.69379717947465691,0.67283828426976944,0.65277348751078124,0.63352352407099655]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D31","v":"Single Phase, Two Element"},"%",null,null,null,5.1489500577170909E-2,4.9477404822721449E-2,4.7531897114125109E-2,4.5666688745532563E-2,4.3877482649396414E-2]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D32","v":"Three Phase (inc. DC)"},"%",null,null,null,0.22094512707500016,0.24310369808699542,0.26544595042007052,0.28683570110484891,0.30735508456871624]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D33","v":"Three Phase CT"},"%",null,null,null,1.305142171081888E-2,1.362171761562633E-2,1.4183868196034847E-2,1.4724122638837302E-2,1.5243908710890864E-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},{"$f":"SUM(L61:L70)","v":1},{"$f":"SUM(M61:M70)","v":1},{"$f":"SUM(N61:N70)","v":1},{"$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":41.4460887585291},{"$f":"AVERAGE('Input | Exit Fees'!H$12:I$12)*'Calc | Exit Fees'!L61","v":55.585003152174437},{"$f":"AVERAGE('Input | Exit Fees'!I$12:J$12)*'Calc | Exit Fees'!M61","v":72.103117866507546},{"$f":"AVERAGE('Input | Exit Fees'!J$12:K$12)*'Calc | Exit Fees'!N61","v":89.754309194043984},{"$f":"AVERAGE('Input | Exit Fees'!K$12:L$12)*'Calc | Exit Fees'!O61","v":108.39131306827396}]
[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.9866994327419407},{"$f":"AVERAGE('Input | Exit Fees'!H$12:I$12)*'Calc | Exit Fees'!L62","v":3.9639851305173002},{"$f":"AVERAGE('Input | Exit Fees'!I$12:J$12)*'Calc | Exit Fees'!M62","v":5.0936429453594574},{"$f":"AVERAGE('Input | Exit Fees'!J$12:K$12)*'Calc | Exit Fees'!N62","v":6.279026614828628},{"$f":"AVERAGE('Input | Exit Fees'!K$12:L$12)*'Calc | Exit Fees'!O62","v":7.5071213266667991}]
[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":12.816140733642692},{"$f":"AVERAGE('Input | Exit Fees'!H$12:I$12)*'Calc | Exit Fees'!L63","v":19.47675808469398},{"$f":"AVERAGE('Input | Exit Fees'!I$12:J$12)*'Calc | Exit Fees'!M63","v":28.445885285938385},{"$f":"AVERAGE('Input | Exit Fees'!J$12:K$12)*'Calc | Exit Fees'!N63","v":39.439010158067724},{"$f":"AVERAGE('Input | Exit Fees'!K$12:L$12)*'Calc | Exit Fees'!O63","v":52.58624175553124}]
[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.75706063145350466},{"$f":"AVERAGE('Input | Exit Fees'!H$12:I$12)*'Calc | Exit Fees'!L64","v":1.0913322207160649},{"$f":"AVERAGE('Input | Exit Fees'!I$12:J$12)*'Calc | Exit Fees'!M64","v":1.5199805722286515},{"$f":"AVERAGE('Input | Exit Fees'!J$12:K$12)*'Calc | Exit Fees'!N64","v":2.0245207276672663},{"$f":"AVERAGE('Input | Exit Fees'!K$12:L$12)*'Calc | Exit Fees'!O64","v":2.608123011516132}]
[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":58.00598955636724},{"$f":"SUM(L77:L86)","v":80.117078588101791},{"$f":"SUM(M77:M86)","v":107.16262667003404},{"$f":"SUM(N77:N86)","v":137.4968666946076},{"$f":"SUM(O77:O86)","v":171.09279916198815}]
[{"$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":133.70239558555289},{"$f":"IFERROR(L77*10^6/L31,0)","v":179.85616564466204},234.33729632814689,293.01802668902076,355.48194958067273]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D31","v":"Single Phase, Two Element"},"$dollars","Nominal",null,null,144.89786960848815,194.84547020521848,253.75896313190944,317.15500309971401,384.58827685716392]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D32","v":"Three Phase (inc. DC)"},"$dollars","Nominal",null,null,187.50942776698446,251.95772636253128,327.85273375072848,409.36624755561036,495.93781242074459]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D33","v":"Three Phase CT"},"$dollars","Nominal",null,null,277.2211374014575,372.77058079050181,485.46445182253046,606.72356541656927,735.69688149097533]
[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":27.578399379467161},{"$f":"(AVERAGE('Input | Exit Fees'!H$19:I$19)*10^6)/'Calc | Exit Fees'!L$41","v":46.528010608174014},{"$f":"(AVERAGE('Input | Exit Fees'!I$19:J$19)*10^6)/'Calc | Exit Fees'!M$41","v":57.523160981122118},{"$f":"(AVERAGE('Input | Exit Fees'!J$19:K$19)*10^6)/'Calc | Exit Fees'!N$41","v":67.711982657912202},{"$f":"(AVERAGE('Input | Exit Fees'!K$19:L$19)*10^6)/'Calc | Exit Fees'!O$41","v":75.422062660998549}]
[]
[]
[]
[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":133.70239558555289},{"$f":"IF($D118=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$30:$D$39,$D118))","v":179.85616564466204},{"$f":"IF($D118=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$30:$D$39,$D118))","v":234.33729632814689},{"$f":"IF($D118=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$30:$D$39,$D118))","v":293.01802668902076},{"$f":"IF($D118=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$30:$D$39,$D118))","v":355.48194958067273}]
[null,null,null,null,"Comms, IT, Inhouse software & Equity Raising Costs",null,{"$f":"IF($D118=0,0,'Calc | Exit Fees'!K$109)","v":27.578399379467161},{"$f":"IF($D118=0,0,'Calc | Exit Fees'!L$109)","v":46.528010608174014},{"$f":"IF($D118=0,0,'Calc | Exit Fees'!M$109)","v":57.523160981122118},{"$f":"IF($D118=0,0,'Calc | Exit Fees'!N$109)","v":67.711982657912202},{"$f":"IF($D118=0,0,'Calc | Exit Fees'!O$109)","v":75.422062660998549}]
[null,null,null,null,"Admin cost",null,{"$f":"IF($D118=0,0,'Input | Exit Fees'!K$120)","v":78.859266178541176},{"$f":"IF($D118=0,0,'Input | Exit Fees'!L$120)","v":84.078246264713485},{"$f":"IF($D118=0,0,'Input | Exit Fees'!M$120)","v":88.997112820564254},{"$f":"IF($D118=0,0,'Input | Exit Fees'!N$120)","v":93.59208989469623},{"$f":"IF($D118=0,0,'Input | Exit Fees'!O$120)","v":98.418889948844097}]
[null,null,null,null,"Tax allowance",null,{"$f":"IF($D118=0,0,'Calc | Tax Allowance'!G29)","v":6.549421623106662},{"$f":"IF($D118=0,0,'Calc | Tax Allowance'!H29)","v":8.0061432643131294},{"$f":"IF($D118=0,0,'Calc | Tax Allowance'!I29)","v":10.569069084135544},{"$f":"IF($D118=0,0,'Calc | Tax Allowance'!J29)","v":13.583865231374713},{"$f":"IF($D118=0,0,'Calc | Tax Allowance'!K29)","v":16.373887852333343}]
[null,null,null,null,"TOTAL exit fee",{"$f":"IF(D118=0,0,'Input | Exit Fees'!G30)","v":191.64},{"$f":"SUM(G119:G122)","v":246.68948276666791},{"$f":"SUM(H119:H122)","v":318.46856578186271},{"$f":"SUM(I119:I122)","v":391.42663921396883},{"$f":"SUM(J119:J122)","v":467.90596447300391},{"$f":"SUM(K119:K122)","v":545.69679004284876}]
[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":144.89786960848815},{"$f":"IF($D124=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$30:$D$39,$D124))","v":194.84547020521848},{"$f":"IF($D124=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$30:$D$39,$D124))","v":253.75896313190944},{"$f":"IF($D124=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$30:$D$39,$D124))","v":317.15500309971401},{"$f":"IF($D124=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$30:$D$39,$D124))","v":384.58827685716392}]
[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":27.578399379467161},{"$f":"IF($D124=0,0,'Calc | Exit Fees'!L$109)","v":46.528010608174014},{"$f":"IF($D124=0,0,'Calc | Exit Fees'!M$109)","v":57.523160981122118},{"$f":"IF($D124=0,0,'Calc | Exit Fees'!N$109)","v":67.711982657912202},{"$f":"IF($D124=0,0,'Calc | Exit Fees'!O$109)","v":75.422062660998549}]
[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.859266178541176},{"$f":"IF($D124=0,0,'Input | Exit Fees'!L$120)","v":84.078246264713485},{"$f":"IF($D124=0,0,'Input | Exit Fees'!M$120)","v":88.997112820564254},{"$f":"IF($D124=0,0,'Input | Exit Fees'!N$120)","v":93.59208989469623},{"$f":"IF($D124=0,0,'Input | Exit Fees'!O$120)","v":98.418889948844097}]
[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.9904900509361383},{"$f":"IF($D124=0,0,'Calc | Tax Allowance'!H50)","v":8.5056767152608721},{"$f":"IF($D124=0,0,'Calc | Tax Allowance'!I50)","v":11.165599425291873},{"$f":"IF($D124=0,0,'Calc | Tax Allowance'!J50)","v":14.312329360061476},{"$f":"IF($D124=0,0,'Calc | Tax Allowance'!K50)","v":17.237016990437979}]
[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":258.32602521743263},{"$f":"SUM(H125:H128)","v":333.95740379336684},{"$f":"SUM(I125:I128)","v":411.4448363588877},{"$f":"SUM(J125:J128)","v":492.77140501238392},{"$f":"SUM(K125:K128)","v":575.66624645744457}]
[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":187.50942776698446},{"$f":"IF($D130=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$30:$D$39,$D130))","v":251.95772636253128},{"$f":"IF($D130=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$30:$D$39,$D130))","v":327.85273375072848},{"$f":"IF($D130=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$30:$D$39,$D130))","v":409.36624755561036},{"$f":"IF($D130=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$30:$D$39,$D130))","v":495.93781242074459}]
[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":27.578399379467161},{"$f":"IF($D130=0,0,'Calc | Exit Fees'!L$109)","v":46.528010608174014},{"$f":"IF($D130=0,0,'Calc | Exit Fees'!M$109)","v":57.523160981122118},{"$f":"IF($D130=0,0,'Calc | Exit Fees'!N$109)","v":67.711982657912202},{"$f":"IF($D130=0,0,'Calc | Exit Fees'!O$109)","v":75.422062660998549}]
[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.859266178541176},{"$f":"IF($D130=0,0,'Input | Exit Fees'!L$120)","v":84.078246264713485},{"$f":"IF($D130=0,0,'Input | Exit Fees'!M$120)","v":88.997112820564254},{"$f":"IF($D130=0,0,'Input | Exit Fees'!N$120)","v":93.59208989469623},{"$f":"IF($D130=0,0,'Input | Exit Fees'!O$120)","v":98.418889948844097}]
[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.669258893222672},{"$f":"IF($D130=0,0,'Calc | Tax Allowance'!H71)","v":10.40899933402652},{"$f":"IF($D130=0,0,'Calc | Tax Allowance'!I71)","v":13.441366109551975},{"$f":"IF($D130=0,0,'Calc | Tax Allowance'!J71)","v":17.095303611050426},{"$f":"IF($D130=0,0,'Calc | Tax Allowance'!K71)","v":20.539014791341231}]
[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":302.61635221821547},{"$f":"SUM(H131:H134)","v":392.97298256944526},{"$f":"SUM(I131:I134)","v":487.81437366196684},{"$f":"SUM(J131:J134)","v":587.76562371926923},{"$f":"SUM(K131:K134)","v":690.31777982192853}]
[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":277.2211374014575},{"$f":"IF($D136=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$30:$D$39,$D136))","v":372.77058079050181},{"$f":"IF($D136=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$30:$D$39,$D136))","v":485.46445182253046},{"$f":"IF($D136=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$30:$D$39,$D136))","v":606.72356541656927},{"$f":"IF($D136=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$30:$D$39,$D136))","v":735.69688149097533}]
[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":27.578399379467161},{"$f":"IF($D136=0,0,'Calc | Exit Fees'!L$109)","v":46.528010608174014},{"$f":"IF($D136=0,0,'Calc | Exit Fees'!M$109)","v":57.523160981122118},{"$f":"IF($D136=0,0,'Calc | Exit Fees'!N$109)","v":67.711982657912202},{"$f":"IF($D136=0,0,'Calc | Exit Fees'!O$109)","v":75.422062660998549}]
[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.859266178541176},{"$f":"IF($D136=0,0,'Input | Exit Fees'!L$120)","v":84.078246264713485},{"$f":"IF($D136=0,0,'Input | Exit Fees'!M$120)","v":88.997112820564254},{"$f":"IF($D136=0,0,'Input | Exit Fees'!N$120)","v":93.59208989469623},{"$f":"IF($D136=0,0,'Input | Exit Fees'!O$120)","v":98.418889948844097}]
[null,null,null,null,{"$f":"IF($D136=0,\"\",E$122)","v":"Tax allowance"},null,{"$f":"IF($D136=0,0,'Calc | Tax Allowance'!G92)","v":12.203633824137547},{"$f":"IF($D136=0,0,'Calc | Tax Allowance'!H92)","v":14.435207611231082},{"$f":"IF($D136=0,0,'Calc | Tax Allowance'!I92)","v":18.282360083014272},{"$f":"IF($D136=0,0,'Calc | Tax Allowance'!J92)","v":23.051630706429599},{"$f":"IF($D136=0,0,'Calc | Tax Allowance'!K92)","v":27.648913497335066}]
[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":395.86243678360341},{"$f":"SUM(H137:H140)","v":517.81204527462046},{"$f":"SUM(I137:I140)","v":650.2670857072311},{"$f":"SUM(J137:J140)","v":791.0792686756073},{"$f":"SUM(K137:K140)","v":937.18674759815315}]
[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":30.421167853163439},{"$f":"AVERAGE('Input | Exit Fees'!H$130:I$130)*'Calc | Exit Fees'!L61","v":43.077541753335424},{"$f":"AVERAGE('Input | Exit Fees'!I$130:J$130)*'Calc | Exit Fees'!M61","v":57.150111152006147},{"$f":"AVERAGE('Input | Exit Fees'!J$130:K$130)*'Calc | Exit Fees'!N61","v":71.464504904950203},{"$f":"AVERAGE('Input | Exit Fees'!K$130:L$130)*'Calc | Exit Fees'!O61","v":86.688736761526428}]
[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":2.1922185540775048},{"$f":"AVERAGE('Input | Exit Fees'!H$130:I$130)*'Calc | Exit Fees'!L62","v":3.0720288798396846},{"$f":"AVERAGE('Input | Exit Fees'!I$130:J$130)*'Calc | Exit Fees'!M62","v":4.0373047533793853},{"$f":"AVERAGE('Input | Exit Fees'!J$130:K$130)*'Calc | Exit Fees'!N62","v":4.999509576120837},{"$f":"AVERAGE('Input | Exit Fees'!K$130:L$130)*'Calc | Exit Fees'!O62","v":6.0040131086366806}]
[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":9.4069664995270887},{"$f":"AVERAGE('Input | Exit Fees'!H$130:I$130)*'Calc | Exit Fees'!L63","v":15.094194693415194},{"$f":"AVERAGE('Input | Exit Fees'!I$130:J$130)*'Calc | Exit Fees'!M63","v":22.546674180143025},{"$f":"AVERAGE('Input | Exit Fees'!J$130:K$130)*'Calc | Exit Fees'!N63","v":31.402273163221494},{"$f":"AVERAGE('Input | Exit Fees'!K$130:L$130)*'Calc | Exit Fees'!O63","v":42.05719757220605}]
[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.55567773062131309},{"$f":"AVERAGE('Input | Exit Fees'!H$130:I$130)*'Calc | Exit Fees'!L64","v":0.84576606348213357},{"$f":"AVERAGE('Input | Exit Fees'!I$130:J$130)*'Calc | Exit Fees'!M64","v":1.2047614752608051},{"$f":"AVERAGE('Input | Exit Fees'!J$130:K$130)*'Calc | Exit Fees'!N64","v":1.611971311146269},{"$f":"AVERAGE('Input | Exit Fees'!K$130:L$130)*'Calc | Exit Fees'!O64","v":2.0859133706092106}]
[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":42.576030637389344},{"$f":"SUM(L186:L195)","v":62.089531390072437},{"$f":"SUM(M186:M195)","v":84.938851560789374},{"$f":"SUM(N186:N195)","v":109.4782589554388},{"$f":"SUM(O186:O195)","v":136.83586081297835}]
[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":98.136715437138704},{"$f":"IFERROR(L186*10^6/'Calc | Exit Fees'!L31,0)","v":139.38582433721882},{"$f":"IFERROR(M186*10^6/'Calc | Exit Fees'!M31,0)","v":185.73957588087978},{"$f":"IFERROR(N186*10^6/'Calc | Exit Fees'!N31,0)","v":233.3078867587779},{"$f":"IFERROR(O186*10^6/'Calc | Exit Fees'!O31,0)","v":284.30582007307595}]
[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":106.35412278845013},{"$f":"IFERROR(L187*10^6/'Calc | Exit Fees'!L32,0)","v":151.00231001579476},{"$f":"IFERROR(M187*10^6/'Calc | Exit Fees'!M32,0)","v":201.13350681528451},{"$f":"IFERROR(N187*10^6/'Calc | Exit Fees'!N32,0)","v":252.52631854864816},{"$f":"IFERROR(O187*10^6/'Calc | Exit Fees'!O32,0)","v":307.58435293647312}]
[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":137.6307378335234},{"$f":"IFERROR(L188*10^6/'Calc | Exit Fees'!L33,0)","v":195.26344988671309},{"$f":"IFERROR(M188*10^6/'Calc | Exit Fees'!M33,0)","v":259.86144191479696},{"$f":"IFERROR(N188*10^6/'Calc | Exit Fees'!N33,0)","v":325.94709344941754},{"$f":"IFERROR(O188*10^6/'Calc | Exit Fees'!O33,0)","v":396.63900412341241}]
[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":203.47856712050142},{"$f":"IFERROR(L189*10^6/'Calc | Exit Fees'!L34,0)","v":288.89159571433356},{"$f":"IFERROR(M189*10^6/'Calc | Exit Fees'!M34,0)","v":384.78706889446198},{"$f":"IFERROR(N189*10^6/'Calc | Exit Fees'!N34,0)","v":483.0876601470024},{"$f":"IFERROR(O189*10^6/'Calc | Exit Fees'!O34,0)","v":588.3924780547236}]
[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":18.922790894347234},{"$f":"(AVERAGE('Input | Exit Fees'!H$137:I$137)*10^6)/'Calc | Exit Fees'!L$41","v":32.941369099983632},{"$f":"(AVERAGE('Input | Exit Fees'!I$137:J$137)*10^6)/'Calc | Exit Fees'!M$41","v":34.759182418450784},{"$f":"(AVERAGE('Input | Exit Fees'!J$137:K$137)*10^6)/'Calc | Exit Fees'!N$41","v":35.704706956159868},{"$f":"(AVERAGE('Input | Exit Fees'!K$137:L$137)*10^6)/'Calc | Exit Fees'!O$41","v":36.042716824546169}]
[]
[]
[]
[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":98.136715437138704},{"$f":"IF($D227=0,0,SUMIFS('Calc | Exit Fees'!L$201:L$210,'Input | Exit Fees'!$D$30:$D$39,$D227))","v":139.38582433721882},{"$f":"IF($D227=0,0,SUMIFS('Calc | Exit Fees'!M$201:M$210,'Input | Exit Fees'!$D$30:$D$39,$D227))","v":185.73957588087978},{"$f":"IF($D227=0,0,SUMIFS('Calc | Exit Fees'!N$201:N$210,'Input | Exit Fees'!$D$30:$D$39,$D227))","v":233.3078867587779},{"$f":"IF($D227=0,0,SUMIFS('Calc | Exit Fees'!O$201:O$210,'Input | Exit Fees'!$D$30:$D$39,$D227))","v":284.30582007307595}]
[null,null,null,null,"WDV - Comms, IT, Inhouse software & Equity Raising Costs",null,{"$f":"IF($D227=0,0,'Calc | Exit Fees'!K$218)","v":18.922790894347234},{"$f":"IF($D227=0,0,'Calc | Exit Fees'!L$218)","v":32.941369099983632},{"$f":"IF($D227=0,0,'Calc | Exit Fees'!M$218)","v":34.759182418450784},{"$f":"IF($D227=0,0,'Calc | Exit Fees'!N$218)","v":35.704706956159868},{"$f":"IF($D227=0,0,'Calc | Exit Fees'!O$218)","v":36.042716824546169}]
[]
[]
[null,null,null,null,"TOTAL WDV",null,{"$f":"SUM(G228:G231)","v":117.05950633148593},{"$f":"SUM(H228:H231)","v":172.32719343720245},{"$f":"SUM(I228:I231)","v":220.49875829933058},{"$f":"SUM(J228:J231)","v":269.01259371493779},{"$f":"SUM(K228:K231)","v":320.34853689762213}]
[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":106.35412278845013},{"$f":"IF($D233=0,0,SUMIFS('Calc | Exit Fees'!L$201:L$210,'Input | Exit Fees'!$D$30:$D$39,$D233))","v":151.00231001579476},{"$f":"IF($D233=0,0,SUMIFS('Calc | Exit Fees'!M$201:M$210,'Input | Exit Fees'!$D$30:$D$39,$D233))","v":201.13350681528451},{"$f":"IF($D233=0,0,SUMIFS('Calc | Exit Fees'!N$201:N$210,'Input | Exit Fees'!$D$30:$D$39,$D233))","v":252.52631854864816},{"$f":"IF($D233=0,0,SUMIFS('Calc | Exit Fees'!O$201:O$210,'Input | Exit Fees'!$D$30:$D$39,$D233))","v":307.58435293647312}]
[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":18.922790894347234},{"$f":"IF($D233=0,0,'Calc | Exit Fees'!L$218)","v":32.941369099983632},{"$f":"IF($D233=0,0,'Calc | Exit Fees'!M$218)","v":34.759182418450784},{"$f":"IF($D233=0,0,'Calc | Exit Fees'!N$218)","v":35.704706956159868},{"$f":"IF($D233=0,0,'Calc | Exit Fees'!O$218)","v":36.042716824546169}]
[]
[]
[null,null,null,null,{"$f":"IF($D233=0,\"\",E$232)","v":"TOTAL WDV"},null,{"$f":"SUM(G234:G237)","v":125.27691368279736},{"$f":"SUM(H234:H237)","v":183.94367911577839},{"$f":"SUM(I234:I237)","v":235.8926892337353},{"$f":"SUM(J234:J237)","v":288.23102550480803},{"$f":"SUM(K234:K237)","v":343.6270697610193}]
[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":137.6307378335234},{"$f":"IF($D239=0,0,SUMIFS('Calc | Exit Fees'!L$201:L$210,'Input | Exit Fees'!$D$30:$D$39,$D239))","v":195.26344988671309},{"$f":"IF($D239=0,0,SUMIFS('Calc | Exit Fees'!M$201:M$210,'Input | Exit Fees'!$D$30:$D$39,$D239))","v":259.86144191479696},{"$f":"IF($D239=0,0,SUMIFS('Calc | Exit Fees'!N$201:N$210,'Input | Exit Fees'!$D$30:$D$39,$D239))","v":325.94709344941754},{"$f":"IF($D239=0,0,SUMIFS('Calc | Exit Fees'!O$201:O$210,'Input | Exit Fees'!$D$30:$D$39,$D239))","v":396.63900412341241}]
[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":18.922790894347234},{"$f":"IF($D239=0,0,'Calc | Exit Fees'!L$218)","v":32.941369099983632},{"$f":"IF($D239=0,0,'Calc | Exit Fees'!M$218)","v":34.759182418450784},{"$f":"IF($D239=0,0,'Calc | Exit Fees'!N$218)","v":35.704706956159868},{"$f":"IF($D239=0,0,'Calc | Exit Fees'!O$218)","v":36.042716824546169}]
[]
[]
[null,null,null,null,{"$f":"IF($D239=0,\"\",E$232)","v":"TOTAL WDV"},null,{"$f":"SUM(G240:G243)","v":156.55352872787063},{"$f":"SUM(H240:H243)","v":228.20481898669672},{"$f":"SUM(I240:I243)","v":294.62062433324775},{"$f":"SUM(J240:J243)","v":361.65180040557743},{"$f":"SUM(K240:K243)","v":432.68172094795858}]
[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":203.47856712050142},{"$f":"IF($D245=0,0,SUMIFS('Calc | Exit Fees'!L$201:L$210,'Input | Exit Fees'!$D$30:$D$39,$D245))","v":288.89159571433356},{"$f":"IF($D245=0,0,SUMIFS('Calc | Exit Fees'!M$201:M$210,'Input | Exit Fees'!$D$30:$D$39,$D245))","v":384.78706889446198},{"$f":"IF($D245=0,0,SUMIFS('Calc | Exit Fees'!N$201:N$210,'Input | Exit Fees'!$D$30:$D$39,$D245))","v":483.0876601470024},{"$f":"IF($D245=0,0,SUMIFS('Calc | Exit Fees'!O$201:O$210,'Input | Exit Fees'!$D$30:$D$39,$D245))","v":588.3924780547236}]
[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":18.922790894347234},{"$f":"IF($D245=0,0,'Calc | Exit Fees'!L$218)","v":32.941369099983632},{"$f":"IF($D245=0,0,'Calc | Exit Fees'!M$218)","v":34.759182418450784},{"$f":"IF($D245=0,0,'Calc | Exit Fees'!N$218)","v":35.704706956159868},{"$f":"IF($D245=0,0,'Calc | Exit Fees'!O$218)","v":36.042716824546169}]
[]
[]
[null,null,null,null,{"$f":"IF($D245=0,\"\",E$232)","v":"TOTAL WDV"},null,{"$f":"SUM(G246:G249)","v":222.40135801484865},{"$f":"SUM(H246:H249)","v":321.83296481431717},{"$f":"SUM(I246:I249)","v":419.54625131291277},{"$f":"SUM(J246:J249)","v":518.79236710316229},{"$f":"SUM(K246:K249)","v":624.43519487926972}]
[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":133.70239558555289},{"$f":"+'Calc | Exit Fees'!H119","v":179.85616564466204},{"$f":"+'Calc | Exit Fees'!I119","v":234.33729632814689},{"$f":"+'Calc | Exit Fees'!J119","v":293.01802668902076},{"$f":"+'Calc | Exit Fees'!K119","v":355.48194958067273}]
[null,null,null,null,"Comms, IT, Inhouse software & Equity Raising Costs RAB",null,{"$f":"+'Calc | Exit Fees'!G120","v":27.578399379467161},{"$f":"+'Calc | Exit Fees'!H120","v":46.528010608174014},{"$f":"+'Calc | Exit Fees'!I120","v":57.523160981122118},{"$f":"+'Calc | Exit Fees'!J120","v":67.711982657912202},{"$f":"+'Calc | Exit Fees'!K120","v":75.422062660998549}]
[null,null,null,null,"Admin cost",null,{"$f":"+'Calc | Exit Fees'!G121","v":78.859266178541176},{"$f":"+'Calc | Exit Fees'!H121","v":84.078246264713485},{"$f":"+'Calc | Exit Fees'!I121","v":88.997112820564254},{"$f":"+'Calc | Exit Fees'!J121","v":93.59208989469623},{"$f":"+'Calc | Exit Fees'!K121","v":98.418889948844097}]
[null,null,null,null,"Revenue for Tax Assessment Subtotal",null,{"$f":"SUM(G12:G14)","v":240.14006114356124},{"$f":"SUM(H12:H14)","v":310.46242251754956},{"$f":"SUM(I12:I14)","v":380.85757012983328},{"$f":"SUM(J12:J14)","v":454.32209924162919},{"$f":"SUM(K12:K14)","v":529.32290219051538}]
[]
[null,null,null,null,"Tax expenses"]
[null,null,null,null,"WDV - Meter TAB",null,{"$f":"+'Calc | Exit Fees'!G228","v":98.136715437138704},{"$f":"+'Calc | Exit Fees'!H228","v":139.38582433721882},{"$f":"+'Calc | Exit Fees'!I228","v":185.73957588087978},{"$f":"+'Calc | Exit Fees'!J228","v":233.3078867587779},{"$f":"+'Calc | Exit Fees'!K228","v":284.30582007307595}]
[null,null,null,null,"WDV - Comms, IT, Inhouse software & Equity Raising Costs TAB",null,{"$f":"+'Calc | Exit Fees'!G229","v":18.922790894347234},{"$f":"+'Calc | Exit Fees'!H229","v":32.941369099983632},{"$f":"+'Calc | Exit Fees'!I229","v":34.759182418450784},{"$f":"+'Calc | Exit Fees'!J229","v":35.704706956159868},{"$f":"+'Calc | Exit Fees'!K229","v":36.042716824546169}]
[null,null,null,null,"Admin cost",null,{"$f":"+'Calc | Exit Fees'!G121","v":78.859266178541176},{"$f":"+'Calc | Exit Fees'!H121","v":84.078246264713485},{"$f":"+'Calc | Exit Fees'!I121","v":88.997112820564254},{"$f":"+'Calc | Exit Fees'!J121","v":93.59208989469623},{"$f":"+'Calc | Exit Fees'!K121","v":98.418889948844097}]
[null,null,null,null,"Interest expense",null,0,0,0,0,0]
[null,null,null,null,"Tax expenses",null,{"$f":"SUM(G18:G21)","v":195.91877251002711},{"$f":"SUM(H18:H21)","v":256.40543970191595},{"$f":"SUM(I18:I21)","v":309.49587111989484},{"$f":"SUM(J18:J21)","v":362.60468360963404},{"$f":"SUM(K18:K21)","v":418.76742684646621}]
[]
[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":44.22128863353413},{"$f":"+H15-H22","v":54.056982815633603},{"$f":"+I15-I22","v":71.361699009938434},{"$f":"+J15-J22","v":91.717415631995152},{"$f":"+K15-K22","v":110.55547534404917}]
[null,null,null,null,"Tax payable",null,{"$f":"+G26*G24/(1-G24*(1-G25))","v":15.231213076992237},{"$f":"+H26*H24/(1-H24*(1-H25))","v":18.61893782398402},{"$f":"+I26*I24/(1-I24*(1-I25))","v":24.579230428222193},{"$f":"+J26*J24/(1-J24*(1-J25))","v":31.590384259010957},{"$f":"+K26*K24/(1-K24*(1-K25))","v":38.078808958914749}]
[null,null,null,null,"Imputation credits",null,{"$f":"+G27*G25","v":8.6817914538855749},{"$f":"+H27*H25","v":10.61279455967089},{"$f":"+I27*I25","v":14.010161344086649},{"$f":"+J27*J25","v":18.006519027636244},{"$f":"+K27*K25","v":21.704921106581406}]
[null,null,null,null,"Tax allowance",null,{"$f":"+G27-G28","v":6.549421623106662},{"$f":"+H27-H28","v":8.0061432643131294},{"$f":"+I27-I28","v":10.569069084135544},{"$f":"+J27-J28","v":13.583865231374713},{"$f":"+K27-K28","v":16.373887852333343}]
[]
[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":144.89786960848815},{"$f":"+'Calc | Exit Fees'!H125","v":194.84547020521848},{"$f":"+'Calc | Exit Fees'!I125","v":253.75896313190944},{"$f":"+'Calc | Exit Fees'!J125","v":317.15500309971401},{"$f":"+'Calc | Exit Fees'!K125","v":384.58827685716392}]
[null,null,null,null,"Comms, IT, Inhouse software & Equity Raising Costs RAB",null,{"$f":"+'Calc | Exit Fees'!G126","v":27.578399379467161},{"$f":"+'Calc | Exit Fees'!H126","v":46.528010608174014},{"$f":"+'Calc | Exit Fees'!I126","v":57.523160981122118},{"$f":"+'Calc | Exit Fees'!J126","v":67.711982657912202},{"$f":"+'Calc | Exit Fees'!K126","v":75.422062660998549}]
[null,null,null,null,"Admin cost",null,{"$f":"+'Calc | Exit Fees'!G127","v":78.859266178541176},{"$f":"+'Calc | Exit Fees'!H127","v":84.078246264713485},{"$f":"+'Calc | Exit Fees'!I127","v":88.997112820564254},{"$f":"+'Calc | Exit Fees'!J127","v":93.59208989469623},{"$f":"+'Calc | Exit Fees'!K127","v":98.418889948844097}]
[null,null,null,null,"Revenue for Tax Assessment Subtotal",null,{"$f":"SUM(G33:G35)","v":251.33553516649647},{"$f":"SUM(H33:H35)","v":325.45172707810599},{"$f":"SUM(I33:I35)","v":400.27923693359583},{"$f":"SUM(J33:J35)","v":478.45907565232244},{"$f":"SUM(K33:K35)","v":558.42922946700662}]
[]
[null,null,null,null,"Tax expenses"]
[null,null,null,null,"Meter TAB",null,{"$f":"+'Calc | Exit Fees'!G234","v":106.35412278845013},{"$f":"+'Calc | Exit Fees'!H234","v":151.00231001579476},{"$f":"+'Calc | Exit Fees'!I234","v":201.13350681528451},{"$f":"+'Calc | Exit Fees'!J234","v":252.52631854864816},{"$f":"+'Calc | Exit Fees'!K234","v":307.58435293647312}]
[null,null,null,null,"Comms, IT, Inhouse software & Equity Raising Costs TAB",null,{"$f":"+'Calc | Exit Fees'!G235","v":18.922790894347234},{"$f":"+'Calc | Exit Fees'!H235","v":32.941369099983632},{"$f":"+'Calc | Exit Fees'!I235","v":34.759182418450784},{"$f":"+'Calc | Exit Fees'!J235","v":35.704706956159868},{"$f":"+'Calc | Exit Fees'!K235","v":36.042716824546169}]
[null,null,null,null,"Admin cost",null,{"$f":"+'Calc | Exit Fees'!G127","v":78.859266178541176},{"$f":"+'Calc | Exit Fees'!H127","v":84.078246264713485},{"$f":"+'Calc | Exit Fees'!I127","v":88.997112820564254},{"$f":"+'Calc | Exit Fees'!J127","v":93.59208989469623},{"$f":"+'Calc | Exit Fees'!K127","v":98.418889948844097}]
[null,null,null,null,"Interest expense",null,0,0,0,0,0]
[null,null,null,null,"Tax expenses",null,{"$f":"SUM(G39:G42)","v":204.13617986133852},{"$f":"SUM(H39:H42)","v":268.02192538049189},{"$f":"SUM(I39:I42)","v":324.88980205429954},{"$f":"SUM(J39:J42)","v":381.82311539950427},{"$f":"SUM(K39:K42)","v":442.04595970986338}]
[]
[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":47.199355305157951},{"$f":"+H36-H43","v":57.429801697614096},{"$f":"+I36-I43","v":75.389434879296289},{"$f":"+J36-J43","v":96.635960252818165},{"$f":"+K36-K43","v":116.38326975714324}]
[null,null,null,null,"Tax payable",null,{"$f":"+G47*G45/(1-G45*(1-G46))","v":16.256953606828226},{"$f":"+H47*H45/(1-H45*(1-H46))","v":19.780643523862491},{"$f":"+I47*I45/(1-I45*(1-I46))","v":25.966510291376448},{"$f":"+J47*J45/(1-J45*(1-J46))","v":33.284486883863892},{"$f":"+K47*K45/(1-K45*(1-K46))","v":40.086086024274366}]
[null,null,null,null,"Imputation credits",null,{"$f":"+G48*G46","v":9.2664635558920878},{"$f":"+H48*H46","v":11.274966808601619},{"$f":"+I48*I46","v":14.800910866084575},{"$f":"+J48*J46","v":18.972157523802416},{"$f":"+K48*K46","v":22.849069033836386}]
[null,null,null,null,"Tax allowance",null,{"$f":"+G48-G49","v":6.9904900509361383},{"$f":"+H48-H49","v":8.5056767152608721},{"$f":"+I48-I49","v":11.165599425291873},{"$f":"+J48-J49","v":14.312329360061476},{"$f":"+K48-K49","v":17.237016990437979}]
[]
[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":187.50942776698446},{"$f":"+'Calc | Exit Fees'!H131","v":251.95772636253128},{"$f":"+'Calc | Exit Fees'!I131","v":327.85273375072848},{"$f":"+'Calc | Exit Fees'!J131","v":409.36624755561036},{"$f":"+'Calc | Exit Fees'!K131","v":495.93781242074459}]
[null,null,null,null,"Comms, IT, Inhouse software & Equity Raising Costs RAB",null,{"$f":"+'Calc | Exit Fees'!G132","v":27.578399379467161},{"$f":"+'Calc | Exit Fees'!H132","v":46.528010608174014},{"$f":"+'Calc | Exit Fees'!I132","v":57.523160981122118},{"$f":"+'Calc | Exit Fees'!J132","v":67.711982657912202},{"$f":"+'Calc | Exit Fees'!K132","v":75.422062660998549}]
[null,null,null,null,"Admin cost",null,{"$f":"+'Calc | Exit Fees'!G133","v":78.859266178541176},{"$f":"+'Calc | Exit Fees'!H133","v":84.078246264713485},{"$f":"+'Calc | Exit Fees'!I133","v":88.997112820564254},{"$f":"+'Calc | Exit Fees'!J133","v":93.59208989469623},{"$f":"+'Calc | Exit Fees'!K133","v":98.418889948844097}]
[null,null,null,null,"Revenue for Tax Assessment Subtotal",null,{"$f":"SUM(G54:G56)","v":293.94709332499281},{"$f":"SUM(H54:H56)","v":382.56398323541873},{"$f":"SUM(I54:I56)","v":474.37300755241489},{"$f":"SUM(J54:J56)","v":570.67032010821879},{"$f":"SUM(K54:K56)","v":669.77876503058724}]
[]
[null,null,null,null,"Tax expenses"]
[null,null,null,null,"Meter TAB",null,{"$f":"+'Calc | Exit Fees'!G240","v":137.6307378335234},{"$f":"+'Calc | Exit Fees'!H240","v":195.26344988671309},{"$f":"+'Calc | Exit Fees'!I240","v":259.86144191479696},{"$f":"+'Calc | Exit Fees'!J240","v":325.94709344941754},{"$f":"+'Calc | Exit Fees'!K240","v":396.63900412341241}]
[null,null,null,null,"Comms, IT, Inhouse software & Equity Raising Costs TAB",null,{"$f":"+'Calc | Exit Fees'!G241","v":18.922790894347234},{"$f":"+'Calc | Exit Fees'!H241","v":32.941369099983632},{"$f":"+'Calc | Exit Fees'!I241","v":34.759182418450784},{"$f":"+'Calc | Exit Fees'!J241","v":35.704706956159868},{"$f":"+'Calc | Exit Fees'!K241","v":36.042716824546169}]
[null,null,null,null,"Admin cost",null,{"$f":"+'Calc | Exit Fees'!G133","v":78.859266178541176},{"$f":"+'Calc | Exit Fees'!H133","v":84.078246264713485},{"$f":"+'Calc | Exit Fees'!I133","v":88.997112820564254},{"$f":"+'Calc | Exit Fees'!J133","v":93.59208989469623},{"$f":"+'Calc | Exit Fees'!K133","v":98.418889948844097}]
[null,null,null,null,"Interest expense",null,0,0,0,0,0]
[null,null,null,null,"Tax expenses",null,{"$f":"SUM(G60:G63)","v":235.41279490641182},{"$f":"SUM(H60:H63)","v":312.28306525141022},{"$f":"SUM(I60:I63)","v":383.61773715381202},{"$f":"SUM(J60:J63)","v":455.24389030027368},{"$f":"SUM(K60:K63)","v":531.10061089680266}]
[]
[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":58.534298418580988},{"$f":"+H57-H64","v":70.280917984008511},{"$f":"+I57-I64","v":90.755270398602875},{"$f":"+J57-J64","v":115.42642980794511},{"$f":"+K57-K64","v":138.67815413378457}]
[null,null,null,null,"Tax payable",null,{"$f":"+G68*G66/(1-G66*(1-G67))","v":20.161067193541097},{"$f":"+H68*H66/(1-H66*(1-H67))","v":24.206975195410507},{"$f":"+I68*I66/(1-I66*(1-I67))","v":31.258990952446453},{"$f":"+J68*J66/(1-J66*(1-J67))","v":39.756520025698663},{"$f":"+K68*K66/(1-K66*(1-K67))","v":47.76515067753774}]
[null,null,null,null,"Imputation credits",null,{"$f":"+G69*G67","v":11.491808300318425},{"$f":"+H69*H67","v":13.797975861383987},{"$f":"+I69*I67","v":17.817624842894478},{"$f":"+J69*J67","v":22.661216414648237},{"$f":"+K69*K67","v":27.226135886196509}]
[null,null,null,null,"Tax allowance",null,{"$f":"+G69-G70","v":8.669258893222672},{"$f":"+H69-H70","v":10.40899933402652},{"$f":"+I69-I70","v":13.441366109551975},{"$f":"+J69-J70","v":17.095303611050426},{"$f":"+K69-K70","v":20.539014791341231}]
[]
[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":277.2211374014575},{"$f":"+'Calc | Exit Fees'!H137","v":372.77058079050181},{"$f":"+'Calc | Exit Fees'!I137","v":485.46445182253046},{"$f":"+'Calc | Exit Fees'!J137","v":606.72356541656927},{"$f":"+'Calc | Exit Fees'!K137","v":735.69688149097533}]
[null,null,null,null,"Comms, IT, Inhouse software & Equity Raising Costs RAB",null,{"$f":"+'Calc | Exit Fees'!G138","v":27.578399379467161},{"$f":"+'Calc | Exit Fees'!H138","v":46.528010608174014},{"$f":"+'Calc | Exit Fees'!I138","v":57.523160981122118},{"$f":"+'Calc | Exit Fees'!J138","v":67.711982657912202},{"$f":"+'Calc | Exit Fees'!K138","v":75.422062660998549}]
[null,null,null,null,"Admin cost",null,{"$f":"+'Calc | Exit Fees'!G139","v":78.859266178541176},{"$f":"+'Calc | Exit Fees'!H139","v":84.078246264713485},{"$f":"+'Calc | Exit Fees'!I139","v":88.997112820564254},{"$f":"+'Calc | Exit Fees'!J139","v":93.59208989469623},{"$f":"+'Calc | Exit Fees'!K139","v":98.418889948844097}]
[null,null,null,null,"Revenue for Tax Assessment Subtotal",null,{"$f":"SUM(G75:G77)","v":383.65880295946585},{"$f":"SUM(H75:H77)","v":503.37683766338932},{"$f":"SUM(I75:I77)","v":631.98472562421682},{"$f":"SUM(J75:J77)","v":768.0276379691777},{"$f":"SUM(K75:K77)","v":909.53783410081803}]
[]
[null,null,null,null,"Tax expenses"]
[null,null,null,null,"Meter TAB",null,{"$f":"+'Calc | Exit Fees'!G246","v":203.47856712050142},{"$f":"+'Calc | Exit Fees'!H246","v":288.89159571433356},{"$f":"+'Calc | Exit Fees'!I246","v":384.78706889446198},{"$f":"+'Calc | Exit Fees'!J246","v":483.0876601470024},{"$f":"+'Calc | Exit Fees'!K246","v":588.3924780547236}]
[null,null,null,null,"Comms, IT, Inhouse software & Equity Raising Costs TAB",null,{"$f":"+'Calc | Exit Fees'!G247","v":18.922790894347234},{"$f":"+'Calc | Exit Fees'!H247","v":32.941369099983632},{"$f":"+'Calc | Exit Fees'!I247","v":34.759182418450784},{"$f":"+'Calc | Exit Fees'!J247","v":35.704706956159868},{"$f":"+'Calc | Exit Fees'!K247","v":36.042716824546169}]
[null,null,null,null,"Admin cost",null,{"$f":"+'Calc | Exit Fees'!G139","v":78.859266178541176},{"$f":"+'Calc | Exit Fees'!H139","v":84.078246264713485},{"$f":"+'Calc | Exit Fees'!I139","v":88.997112820564254},{"$f":"+'Calc | Exit Fees'!J139","v":93.59208989469623},{"$f":"+'Calc | Exit Fees'!K139","v":98.418889948844097}]
[null,null,null,null,"Interest expense",null,0,0,0,0,0]
[null,null,null,null,"Tax expenses",null,{"$f":"SUM(G81:G84)","v":301.26062419338984},{"$f":"SUM(H81:H84)","v":405.91121107903064},{"$f":"SUM(I81:I84)","v":508.54336413347704},{"$f":"SUM(J81:J84)","v":612.38445699785848},{"$f":"SUM(K81:K84)","v":722.85408482811386}]
[]
[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":82.398178766076001},{"$f":"+H78-H85","v":97.465626584358688},{"$f":"+I78-I85","v":123.44136149073978},{"$f":"+J78-J85","v":155.64318097131923},{"$f":"+K78-K85","v":186.68374927270418}]
[null,null,null,null,"Tax payable",null,{"$f":"+G89*G87/(1-G87*(1-G88))","v":28.380543777064062},{"$f":"+H89*H87/(1-H87*(1-H88))","v":33.570250258676928},{"$f":"+I89*I87/(1-I87*(1-I88))","v":42.517116472126212},{"$f":"+J89*J87/(1-J87*(1-J88))","v":53.608443503324644},{"$f":"+K89*K87/(1-K87*(1-K88))","v":64.299798831011771}]
[null,null,null,null,"Imputation credits",null,{"$f":"+G90*G88","v":16.176909952926515},{"$f":"+H90*H88","v":19.135042647445847},{"$f":"+I90*I88","v":24.23475638911194},{"$f":"+J90*J88","v":30.556812796895045},{"$f":"+K90*K88","v":36.650885333676705}]
[null,null,null,null,"Tax allowance",null,{"$f":"+G90-G91","v":12.203633824137547},{"$f":"+H90-H91","v":14.435207611231082},{"$f":"+I90-I91","v":18.282360083014272},{"$f":"+J90-J91","v":23.051630706429599},{"$f":"+K90-K91","v":27.648913497335066}]

{"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":246.69},{"$f":"IF(J25=0,0,ROUND(I9*(1-J45)*(1+J$41),2))","v":318.47000000000003},391.43,467.91,545.70000000000005]
[null,null,null,{"$f":"D26","v":"Single Phase, Two Element"},null,"$dollars","nominal",191.64,258.33,333.96,411.45,492.78,575.67999999999995]
[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":302.62},{"$f":"IF(J27=0,0,ROUND(I11*(1-J47)*(1+J$41),2))","v":392.98},{"$f":"IF(K27=0,0,ROUND(J11*(1-K47)*(1+K$41),2))","v":487.82},{"$f":"IF(L27=0,0,ROUND(K11*(1-L47)*(1+L$41),2))","v":587.77},{"$f":"IF(M27=0,0,ROUND(L11*(1-M47)*(1+M$41),2))","v":690.32}]
[null,null,null,"Three Phase CT",null,"$dollars","nominal",191.64,395.86,517.80999999999995,650.26,791.07,937.18]
[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":246.68948276666791},{"$f":"INDEX(Table3[2027-28],MATCH('Output | Exit Fee price caps'!$D25,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":318.46856578186271},{"$f":"INDEX(Table3[2028-29],MATCH('Output | Exit Fee price caps'!$D25,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":391.42663921396883},{"$f":"INDEX(Table3[2029-30],MATCH('Output | Exit Fee price caps'!$D25,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":467.90596447300391},{"$f":"INDEX(Table3[2030-31],MATCH('Output | Exit Fee price caps'!$D25,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":545.69679004284876}]
[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":258.32602521743263},{"$f":"INDEX(Table3[2027-28],MATCH('Output | Exit Fee price caps'!$D26,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":333.95740379336684},{"$f":"INDEX(Table3[2028-29],MATCH('Output | Exit Fee price caps'!$D26,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":411.4448363588877},{"$f":"INDEX(Table3[2029-30],MATCH('Output | Exit Fee price caps'!$D26,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":492.77140501238392},{"$f":"INDEX(Table3[2030-31],MATCH('Output | Exit Fee price caps'!$D26,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":575.66624645744457}]
[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":302.61635221821547},{"$f":"INDEX(Table3[2027-28],MATCH('Output | Exit Fee price caps'!$D27,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":392.97298256944526},{"$f":"INDEX(Table3[2028-29],MATCH('Output | Exit Fee price caps'!$D27,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":487.81437366196684},{"$f":"INDEX(Table3[2029-30],MATCH('Output | Exit Fee price caps'!$D27,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":587.76562371926923},{"$f":"INDEX(Table3[2030-31],MATCH('Output | Exit Fee price caps'!$D27,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":690.31777982192853}]
[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":395.86243678360341},{"$f":"INDEX(Table3[2027-28],MATCH('Output | Exit Fee price caps'!$D28,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":517.81204527462046},{"$f":"INDEX(Table3[2028-29],MATCH('Output | Exit Fee price caps'!$D28,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":650.2670857072311},{"$f":"INDEX(Table3[2029-30],MATCH('Output | Exit Fee price caps'!$D28,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":791.0792686756073},{"$f":"INDEX(Table3[2030-31],MATCH('Output | Exit Fee price caps'!$D28,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":937.18674759815315}]
[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.6597593508804751E-2},{"$f":"'Inputs | General'!K26","v":2.6597593508804751E-2},{"$f":"'Inputs | General'!L26","v":2.6597593508804751E-2},{"$f":"'Inputs | General'!M26","v":2.6597593508804751E-2},{"$f":"'Inputs | General'!N26","v":2.6597593508804751E-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":-0.253903834083123},-0.25752230149253363,-0.19724646952571834,-0.1644154531130928,-0.1360372608228293]
[null,null,null,{"$f":"'Input | Exit Fees'!$D31","v":"Single Phase, Two Element"},null,"%",null,null,-0.31305149222745476,-0.25928106335919199,-0.20010791007691631,-0.16663134292790871,-0.13795483575304868]
[null,null,null,{"$f":"'Input | Exit Fees'!$D32","v":"Three Phase (inc. DC)"},null,"%",null,null,-0.53817584781907768,-0.26494038793813712,-0.20918195628122715,-0.17367903619454217,-0.14404902460245461]
[null,null,null,{"$f":"'Input | Exit Fees'!$D33","v":"Three Phase CT"},null,"%",null,null,-1.0121385868806767,-0.27417069718511344,-0.22326170892592523,-0.18502630115105911,-0.15400022506834232]
[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":257.81722790759488},{"$f":"SUMPRODUCT(J$25:J$34,'Calc | Exit Fees'!L$31:L$40)/'Calc | Exit Fees'!L$41","v":334.72248375671387},{"$f":"SUMPRODUCT(K$25:K$34,'Calc | Exit Fees'!M$31:M$40)/'Calc | Exit Fees'!M$41","v":414.35272864314459},{"$f":"SUMPRODUCT(L$25:L$34,'Calc | Exit Fees'!N$31:N$40)/'Calc | Exit Fees'!N$41","v":498.71514880187209},{"$f":"SUMPRODUCT(M$25:M$34,'Calc | Exit Fees'!O$31:O$40)/'Calc | Exit Fees'!O$41","v":585.57490948709074}]

{"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"]