{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Title Page","Change log","Inputs | General","Exit Fees >","Input | Exit Fees","Calc | Exit Fees","Calc | Tax Allowance","Output | Exit Fee price caps","LUTs and Dropdowns"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":23,"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":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":2,"n_rows":42,"n_cols":23,"rows_kept":42,"cut":false,"hidden":false,"merged":[[35,1,35,6],[38,7,38,11],[4,1,4,6],[1,10,1,11],[1,12,1,13],[20,1,20,6],[23,7,23,11],[29,7,29,11]]}
[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$46)=COUNTIF($X14:$X47,\"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"]
[]
[]
[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,"draft"]
[]
[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,"Base year","Regulatory period"]
[null,null,"Year",null,"Units",null,{"$f":"LEFT(H25,4)-1&\"-\"&RIGHT(H25,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(H25,4)+1&\"-\"&RIGHT(H25,2)+1","v":"2027-28"},{"$f":"LEFT(I25,4)+1&\"-\"&RIGHT(I25,2)+1","v":"2028-29"},{"$f":"LEFT(J25,4)+1&\"-\"&RIGHT(J25,2)+1","v":"2029-30"},{"$f":"LEFT(K25,4)+1&\"-\"&RIGHT(K25,2)+1","v":"2030-31"}]
[null,null,"Inflation Assumption (CPI % increase)",null,"%",null,null,2.5499939054115517E-2,2.5499939054115517E-2,2.5499939054115517E-2,2.5499939054115517E-2,2.5499939054115517E-2]
[null,null,"Cumulative Inflation Index (CPI end period)",null,"Index",null,1,{"$f":"G27*(1+H26)","v":1.0254999390541155},{"$f":"H27*(1+I26)","v":1.0516501249999946},{"$f":"I27*(1+J26)","v":1.0784671390937475},{"$f":"J27*(1+K26)","v":1.1059679854125044},{"$f":"K27*(1+L26)","v":1.1341701016363261}]
[]
[]
[null,null,null,null,null,null,"Base year","Regulatory period"]
[null,null,"Year",null,"Units",null,{"$f":"LEFT(H31,4)-1&\"-\"&RIGHT(H31,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(H31,4)+1&\"-\"&RIGHT(H31,2)+1","v":"2027-28"},{"$f":"LEFT(I31,4)+1&\"-\"&RIGHT(I31,2)+1","v":"2028-29"},{"$f":"LEFT(J31,4)+1&\"-\"&RIGHT(J31,2)+1","v":"2029-30"},{"$f":"LEFT(K31,4)+1&\"-\"&RIGHT(K31,2)+1","v":"2030-31"}]
[null,null,"Weighted average of Opex Price Change (% increase)",null,"%",null,null,9.1506511132063428E-3,9.4532903132763194E-3,1.1677109032548483E-2,1.2078971675182581E-2,1.1092521820503005E-2]
[null,null,"Real Price index to input year",null,"Index",null,1,{"$f":"G33*(1+H32)","v":1.0091506511132065},{"$f":"H33*(1+I32)","v":1.0186904451880114},{"$f":"I33*(1+J32)","v":1.0305858045868872},{"$f":"J33*(1+K32)","v":1.0430342213293375},{"$f":"K33*(1+L32)","v":1.0546041011889644}]
[]
[]
[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,"Base year","Regulatory period"]
[null,null,"Assumption",null,"Units",null,{"$f":"LEFT(H40,4)-1&\"-\"&RIGHT(H40,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(H40,4)+1&\"-\"&RIGHT(H40,2)+1","v":"2027-28"},{"$f":"LEFT(I40,4)+1&\"-\"&RIGHT(I40,2)+1","v":"2028-29"},{"$f":"LEFT(J40,4)+1&\"-\"&RIGHT(J40,2)+1","v":"2029-30"},{"$f":"LEFT(K40,4)+1&\"-\"&RIGHT(K40,2)+1","v":"2030-31"}]
[null,null,"Value of imputation credits",null,"%",null,0.58499999999999996,0.56999999999999995,0.56999999999999995,0.56999999999999995,0.56999999999999995,0.56999999999999995]
[null,null,"Corporate tax rate",null,"%",null,0.3,0.3,0.3,0.3,0.3,0.3]

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

{"sheet":"Input | Exit Fees","index":4,"n_rows":139,"n_cols":17,"rows_kept":139,"cut":false,"hidden":false,"merged":[[138,1,138,3],[0,13,0,14],[47,3,47,5],[4,1,4,6],[24,1,24,7],[41,1,41,7],[6,7,6,11],[4,9,4,11],[21,1,21,3],[94,3,94,5],[66,9,66,14],[111,3,111,5],[112,3,112,5],[113,3,113,5],[121,1,121,6],[121,9,121,11],[123,7,123,11],[107,3,107,5],[108,3,108,5],[109,3,109,5],[110,3,110,5],[86,1,86,7],[114,3,114,5],[115,3,115,5],[116,3,116,5],[117,3,117,5]]}
[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"]
[]
[]
[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",null,{"$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",null,41.287458655463894,{"$f":"G9+G10-G11","v":41.287458655463894},43.262016262813972,52.495106609501647,67.135364133308926,84.138830888907322,103.77344803998778,"Opening balance of METERS row in PTRM inputs sheet of PTRM (nominal)"]
[null,null,"Gross capital expenditure",null,"$m",null,null,7.0506577460841804,14.779234335160725,21.171683801291035,24.94633861983489,29.240578256639299,null,"Gross capex from METERS row in ASSETS sheet of PTRM (nominal)"]
[null,null,"Regulatory depreciation",null,"$m",null,null,5.0761001387341036,5.546143988473049,6.5314262774837637,7.9428718642364995,9.6059611055588263,null,"Depreciation from METERS row in ASSETS sheet of PTRM (nominal)"]
[]
[]
[null,"Linked Input - RAB Comms & IT & Other"]
[null,null,null,null,"Units",null,{"$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",null,6.7386775247177786,{"$f":"G16+G17-G18","v":6.7386775247177786},{"$f":"H16+H17-H18","v":7.6543885085298013},8.5360216979165529,8.8887772887078054,8.9694372412223853,8.9539322240333092,"Opening balance of COMMS & IT & Inhouse Software & ERC rows from PTRM INPUTS sheet of PTRM (nominal)"]
[null,null,"Gross capital expenditure",null,"$m",null,null,2.3338315028367904,2.5727670584168125,2.1649263201351197,2.202105870449178,2.4205274536668346,null,"Gross capex from COMMS & IT & Inhouse Software & ERC rows in ASSETS sheet of PTRM (nominal)"]
[null,null,"Regulatory depreciation",null,"$m",null,null,1.4181205190247672,1.6911338690300619,1.8121707293438671,2.1214459179345986,2.4360324708559098,null,"Depreciation from COMMS & IT & Inhouse Software & ERC rows in ASSETS sheet of PTRM (nominal)"]
[]
[]
[null,null,null,null,"Units",null,{"$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",null,{"$f":"G9+G16","v":48.026136180181673},48.026136180181673,50.916404771343771,61.0311283074182,76.024141422016726,93.108268130129701,112.72738026402109]
[]
[]
[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"]
[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(B25,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":"+D49","v":"Single Phase (inc. DC)"},"$dollars","2024-06-01",224.15477698848665,187.23661898277302,{"$f":"K49+L49","v":411.39139597125967}]
[null,null,null,"Single Phase, Two Element",null,null,null,{"$f":"+D50","v":"Single Phase, Two Element"},"$dollars","2024-06-01",261.36,187.236618982773,448.59661898277301]
[null,null,null,"Three Phase (inc. DC)",null,null,null,{"$f":"+D51","v":"Three Phase (inc. DC)"},"$dollars","2024-06-01",386.29503546343614,200.17557501308789,586.47061047652403]
[null,null,null,"Three Phase CT",null,null,null,{"$f":"+D52","v":"Three Phase CT"},"$dollars","2024-06-01",502.94,355.74957606726872,858.68957606726872]
[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":"H48","v":"Meter Type"},"Units",{"$f":"LEFT(K68,4)-1&\"-\"&RIGHT(K68,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(K68,4)+1&\"-\"&RIGHT(K68,2)+1","v":"2027-28"},{"$f":"LEFT(L68,4)+1&\"-\"&RIGHT(L68,2)+1","v":"2028-29"},{"$f":"LEFT(M68,4)+1&\"-\"&RIGHT(M68,2)+1","v":"2029-30"},{"$f":"LEFT(N68,4)+1&\"-\"&RIGHT(N68,2)+1","v":"2030-31"},null,"Link from Metering - ACS Model"]
[null,null,null,null,null,null,null,"Single Phase (inc. DC)","No.",307426.10633907933,306336.5200013335,304606.68248900841,302845.9294801224,301054.28927049314,299231.71914258366]
[null,null,null,null,null,null,null,"Single Phase, Two Element","No.",20550.731316981815,20182.627690922232,19807.80108453584,19426.275611592253,19038.057403317824,18643.137203542923]
[null,null,null,null,null,null,null,"Three Phase (inc. DC)","No.",64521.325093293177,74772.230598240276,83461.106777199719,92305.269750274441,101304.57738916909,110459.24426166095]
[null,null,null,null,null,null,null,"Three Phase CT","No.",2673.679981521087,2854.7369461216467,3040.6623626821738,3229.9106211485559,3422.478680245722,3618.3711313158146]
[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":"H55","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.",0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,"No.",0,0,0,0,0,0]
[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(J69:J83)","v":395171.84273087542},404146.11523661768,410916.25271342613,417807.38546313759,424819.40274322574,431952.47173910338]
[]
[]
[null,{"$f":"LEFT(B42,1)+1&\". INPUT | Admin and handling\"","v":"6. INPUT | Admin and handling"}]
[]
[null,"a","Inputs - Admin Hourly Rate"]
[null,null,null,"Admin Fees","Units",null,"Rate"]
[null,null,null,"Hourly Rate","$dollars/hr (Real 26)",null,73.101987335475528]
[]
[]
[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",null,{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(K95,4)+1&\"-\"&RIGHT(K95,2)+1","v":"2027-28"},{"$f":"LEFT(L95,4)+1&\"-\"&RIGHT(L95,2)+1","v":"2028-29"},{"$f":"LEFT(M95,4)+1&\"-\"&RIGHT(M95,2)+1","v":"2029-30"},{"$f":"LEFT(N95,4)+1&\"-\"&RIGHT(N95,2)+1","v":"2030-31"}]
[null,null,null,"Validate B2B and paperwork",null,null,8.3333333333333329E-2,"Entered",1,null,{"$f":"$G$91*$G96*$I96*'Inputs | General'!H$27*'Inputs | General'!H$33","v":6.3043393361017408},{"$f":"$G$91*$G96*$I96*'Inputs | General'!I$27*'Inputs | General'!I$33","v":6.526216068418627},{"$f":"$G$91*$G96*$I96*'Inputs | General'!J$27*'Inputs | General'!J$33","v":6.7707847994569859},{"$f":"$G$91*$G96*$I96*'Inputs | General'!K$27*'Inputs | General'!K$33","v":7.0273090070228541},{"$f":"$G$91*$G96*$I96*'Inputs | General'!L$27*'Inputs | General'!L$33","v":7.286443271917169}]
[null,null,null,"Write off meter from AMI SAP",null,null,8.3333333333333329E-2,"Entered",1,null,{"$f":"$G$91*$G97*$I97*'Inputs | General'!H$27*'Inputs | General'!H$33","v":6.3043393361017408},{"$f":"$G$91*$G97*$I97*'Inputs | General'!I$27*'Inputs | General'!I$33","v":6.526216068418627},{"$f":"$G$91*$G97*$I97*'Inputs | General'!J$27*'Inputs | General'!J$33","v":6.7707847994569859},{"$f":"$G$91*$G97*$I97*'Inputs | General'!K$27*'Inputs | General'!K$33","v":7.0273090070228541},{"$f":"$G$91*$G97*$I97*'Inputs | General'!L$27*'Inputs | General'!L$33","v":7.286443271917169}]
[null,null,null,"Update new meter detail in ERP SAP",null,null,8.3333333333333329E-2,"Entered",1,null,{"$f":"$G$91*$G98*$I98*'Inputs | General'!H$27*'Inputs | General'!H$33","v":6.3043393361017408},{"$f":"$G$91*$G98*$I98*'Inputs | General'!I$27*'Inputs | General'!I$33","v":6.526216068418627},{"$f":"$G$91*$G98*$I98*'Inputs | General'!J$27*'Inputs | General'!J$33","v":6.7707847994569859},{"$f":"$G$91*$G98*$I98*'Inputs | General'!K$27*'Inputs | General'!K$33","v":7.0273090070228541},{"$f":"$G$91*$G98*$I98*'Inputs | General'!L$27*'Inputs | General'!L$33","v":7.286443271917169}]
[null,null,null,"SAP ERP internal Service Order creation and close out",null,null,8.3333333333333329E-2,"Entered",1,null,{"$f":"$G$91*$G99*$I99*'Inputs | General'!H$27*'Inputs | General'!H$33","v":6.3043393361017408},{"$f":"$G$91*$G99*$I99*'Inputs | General'!I$27*'Inputs | General'!I$33","v":6.526216068418627},{"$f":"$G$91*$G99*$I99*'Inputs | General'!J$27*'Inputs | General'!J$33","v":6.7707847994569859},{"$f":"$G$91*$G99*$I99*'Inputs | General'!K$27*'Inputs | General'!K$33","v":7.0273090070228541},{"$f":"$G$91*$G99*$I99*'Inputs | General'!L$27*'Inputs | General'!L$33","v":7.286443271917169}]
[null,null,null,"Manage system exceptions, errors and reporting",null,null,0.25,"Entered",0.2,null,{"$f":"$G$91*$G100*$I100*'Inputs | General'!H$27*'Inputs | General'!H$33","v":3.7826036016610449},{"$f":"$G$91*$G100*$I100*'Inputs | General'!I$27*'Inputs | General'!I$33","v":3.9157296410511764},{"$f":"$G$91*$G100*$I100*'Inputs | General'!J$27*'Inputs | General'!J$33","v":4.0624708796741915},{"$f":"$G$91*$G100*$I100*'Inputs | General'!K$27*'Inputs | General'!K$33","v":4.216385404213713},{"$f":"$G$91*$G100*$I100*'Inputs | General'!L$27*'Inputs | General'!L$33","v":4.3718659631503014}]
[null,null,null,"Manage phone calls and inquiries",null,null,0.16666666666666666,"Entered",0.2,null,{"$f":"$G$91*$G101*$I101*'Inputs | General'!H$27*'Inputs | General'!H$33","v":2.5217357344406963},{"$f":"$G$91*$G101*$I101*'Inputs | General'!I$27*'Inputs | General'!I$33","v":2.6104864273674506},{"$f":"$G$91*$G101*$I101*'Inputs | General'!J$27*'Inputs | General'!J$33","v":2.7083139197827943},{"$f":"$G$91*$G101*$I101*'Inputs | General'!K$27*'Inputs | General'!K$33","v":2.8109236028091416},{"$f":"$G$91*$G101*$I101*'Inputs | General'!L$27*'Inputs | General'!L$33","v":2.9145773087668676}]
[null,null,null,"Relays (Equipment and installation cost)",null,null,null,"Entered"]
[null,null,null,"Access Points (Equipment and installation cost)",null,null,null,"Entered"]
[null,null,null,"Decommission and meter disposal cost by Vendor",null,null,null,"Entered",null,null,27.264026249999993,27.945626906249991,28.644267578906241,29.360374268378891,30.094383625088362]
[]
[]
[null,"c","Admin & Handling Cost Calculation (Autofilled)"]
[null,null,null,"Admin Process Description",null,null,"Amount (Fixed or Hours)","Calculated or Entered","Proportion required",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,{"$f":"D96","v":"Validate B2B and paperwork"},null,null,{"$f":"G96","v":8.3333333333333329E-2},"Entered",1,null,{"$f":"IF($H109=\"Calc-Fixed\",$I109*$G109,IF($H109=\"Calc-Hourly\",$G$91*$G109*$I109,IF($H109=\"Entered\",K96,0)))","v":6.3043393361017408},{"$f":"IF($H109=\"Calc-Fixed\",$I109*$G109,IF($H109=\"Calc-Hourly\",$G$91*$G109*$I109,IF($H109=\"Entered\",L96,0)))","v":6.526216068418627},6.7707847994569859,7.0273090070228541,7.286443271917169]
[null,null,null,"Write off meter from AMI SAP",null,null,8.3333333333333329E-2,"Entered",1,null,6.3043393361017408,6.526216068418627,6.7707847994569859,7.0273090070228541,7.286443271917169]
[null,null,null,"Update new meter detail in ERP SAP",null,null,8.3333333333333329E-2,"Entered",1,null,6.3043393361017408,6.526216068418627,6.7707847994569859,7.0273090070228541,7.286443271917169]
[null,null,null,"SAP ERP internal Service Order creation and close out",null,null,8.3333333333333329E-2,"Entered",1,null,6.3043393361017408,6.526216068418627,6.7707847994569859,7.0273090070228541,7.286443271917169]
[null,null,null,"Manage system exceptions, errors and reporting",null,null,0.25,"Entered",0.2,null,3.7826036016610449,3.9157296410511764,4.0624708796741915,4.216385404213713,4.3718659631503014]
[null,null,null,"Manage phone calls and inquiries",null,null,0.16666666666666666,"Entered",0.2,null,2.5217357344406963,2.6104864273674506,2.7083139197827943,2.8109236028091416,2.9145773087668676]
[null,null,null,"Relays (Equipment and installation cost)",null,null,0,"Entered",0,null,0,0,0,0,0]
[null,null,null,"Access Points (Equipment and installation cost)",null,null,{"$f":"G103","v":0},"Entered",0,null,{"$f":"IF($H116=\"Calc-Fixed\",$I116*$G116,IF($H116=\"Calc-Hourly\",$G$91*$G116*$I116,IF($H116=\"Entered\",K103,0)))","v":0},0,0,0,0]
[null,null,null,"Decommission and meter disposal cost by Vendor",null,null,0,"Entered",0,null,27.264026249999993,27.945626906249991,28.644267578906241,29.360374268378891,30.094383625088362]
[null,null,null,0,null,null,0,0,0,null,0,0,0,0,0]
[null,null,null,"TOTAL ADMIN and Handling",null,null,null,null,null,null,{"$f":"SUM(K109:K118)","v":58.785722930508697},{"$f":"SUM(L109:L118)","v":60.576707248343126},{"$f":"SUM(M109:M118)","v":62.498191576191175},{"$f":"SUM(N109:N118)","v":64.496919303493158},{"$f":"SUM(O109:O118)","v":66.526599984674206}]
[]
[]
[null,{"$f":"LEFT('Input | Exit Fees'!B87,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",null,{"$f":"LEFT(H125,4)-1&\"-\"&RIGHT(H125,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(H125,4)+1&\"-\"&RIGHT(H125,2)+1","v":"2027-28"},{"$f":"LEFT(I125,4)+1&\"-\"&RIGHT(I125,2)+1","v":"2028-29"},{"$f":"LEFT(J125,4)+1&\"-\"&RIGHT(J125,2)+1","v":"2029-30"},{"$f":"LEFT(K125,4)+1&\"-\"&RIGHT(K125,2)+1","v":"2030-31"},{"$f":"LEFT(L125,4)+1&\"-\"&RIGHT(L125,2)+1","v":"2031-32"}]
[null,null,"Opening TAB",null,"$m",null,24.711970990646506,{"$f":"G126+G127-G128","v":24.711970990646506},27.27098092678423,36.759221021782515,50.859083568711306,66.403798129152904,85.573121379800881,"Opening tax balance of METERS row in PTRM inputs sheet of PTRM (nominal)"]
[null,null,"Gross capital expenditure",null,"$m",null,null,6.9343579236689674,14.531529965602061,20.811488939750724,24.512132929653742,28.71088305262835,null,"Gross capex from METERS row in PTRM input sheet of PTRM (nominal)"]
[null,null,"Tax depreciation",null,"$m",null,null,4.3753479875312449,5.0432898706037816,6.7116263928219322,8.9674183692121439,9.5415598019803625,null,"Tax Depreciation from METERS row in ASSETS sheet of PTRM (nominal)"]
[]
[]
[null,"Linked Input - TAB Comms & IT & Other"]
[null,null,null,null,"Units",null,{"$f":"LEFT(H132,4)-1&\"-\"&RIGHT(H132,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(H132,4)+1&\"-\"&RIGHT(H132,2)+1","v":"2027-28"},{"$f":"LEFT(I132,4)+1&\"-\"&RIGHT(I132,2)+1","v":"2028-29"},{"$f":"LEFT(J132,4)+1&\"-\"&RIGHT(J132,2)+1","v":"2029-30"},{"$f":"LEFT(K132,4)+1&\"-\"&RIGHT(K132,2)+1","v":"2030-31"},{"$f":"LEFT(L132,4)+1&\"-\"&RIGHT(L132,2)+1","v":"2031-32"}]
[null,null,"Opening RAB",null,"$m",null,3.0481641100851311,{"$f":"G133+G134-G135","v":3.0481641100851311},3.9676105293783399,4.221108869496323,3.6798177093562789,3.3109930244338828,2.6548426845190587,"Opening tax balance of COMMS & IT & Inhouse Software & ERC rows from PTRM INPUTS sheet of PTRM (nominal)"]
[null,null,"Gross capital expenditure less disposals",null,"$m",null,null,2.9810684937765046,3.2153800005502955,2.8138276102304189,2.8495102074571221,3.0624127069642837,null,"Gross capex from COMMS & IT & Inhouse Software & ERC rows in PTRM input sheet of PTRM (nominal)"]
[null,null,"Tax depreciation",null,"$m",null,null,2.0616220744832958,2.9618816604323128,3.355118770370463,3.2183348923795179,3.7185630468791082,null,"Tax Depreciation from COMMS & IT & Inhouse Software & ERC rows in ASSETS sheet of PTRM (nominal)"]
[]
[]
[null,null,null,null,"Units",null,{"$f":"LEFT(H138,4)-1&\"-\"&RIGHT(H138,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(H138,4)+1&\"-\"&RIGHT(H138,2)+1","v":"2027-28"},{"$f":"LEFT(I138,4)+1&\"-\"&RIGHT(I138,2)+1","v":"2028-29"},{"$f":"LEFT(J138,4)+1&\"-\"&RIGHT(J138,2)+1","v":"2029-30"},{"$f":"LEFT(K138,4)+1&\"-\"&RIGHT(K138,2)+1","v":"2030-31"},{"$f":"LEFT(L138,4)+1&\"-\"&RIGHT(L138,2)+1","v":"2031-32"}]
[null,"TOTAL Opening TAB",null,null,"$m",null,{"$f":"G126+G133","v":27.760135100731638},27.760135100731638,31.23859145616257,40.980329891278842,54.538901278067584,69.714791153586788,88.227964064319934]

{"sheet":"Calc | Exit Fees","index":5,"n_rows":286,"n_cols":15,"rows_kept":286,"cut":false,"hidden":false,"merged":[[179,1,179,7],[224,6,224,10],[183,10,183,14],[198,10,198,14],[211,1,211,7],[215,10,215,14],[221,1,221,7],[223,6,223,10],[115,6,115,10],[112,1,112,7],[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]]}
[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"]
[]
[]
[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'!H68","v":"Meter Type"},{"$f":"'Input | Exit Fees'!I68","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'!H69","v":"Single Phase (inc. DC)"},"No.",{"$f":"'Input | Exit Fees'!D49","v":"Single Phase (inc. DC)"},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J69:K69),0)","v":306881.31317020638},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K69:L69),0)","v":305471.60124517092},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L69:M69),0)","v":303726.30598456541},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M69:N69),0)","v":301950.1093753078},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N69:O69),0)","v":300143.00420653843}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H70","v":"Single Phase, Two Element"},"No.",{"$f":"'Input | Exit Fees'!D50","v":"Single Phase, Two Element"},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J70:K70),0)","v":20366.679503952022},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K70:L70),0)","v":19995.214387729036},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L70:M70),0)","v":19617.038348064045},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M70:N70),0)","v":19232.16650745504},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N70:O70),0)","v":18840.597303430375}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H71","v":"Three Phase (inc. DC)"},"No.",{"$f":"'Input | Exit Fees'!D51","v":"Three Phase (inc. DC)"},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J71:K71),0)","v":69646.77784576673},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K71:L71),0)","v":79116.668687719997},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L71:M71),0)","v":87883.188263737073},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M71:N71),0)","v":96804.923569721766},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N71:O71),0)","v":105881.91082541502}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H72","v":"Three Phase CT"},"No.",{"$f":"'Input | Exit Fees'!D52","v":"Three Phase CT"},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J72:K72),0)","v":2764.2084638213669},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K72:L72),0)","v":2947.6996544019103},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L72:M72),0)","v":3135.2864919153649},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M72:N72),0)","v":3326.194650697139},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N72:O72),0)","v":3520.4249057807683}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H73","v":0},"No.",{"$f":"'Input | Exit Fees'!D53","v":0},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J73:K73),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K73:L73),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L73:M73),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M73:N73),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N73:O73),0)","v":0}]
[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":"Total"},"No.",null,null,null,{"$f":"SUM(K12:K26)","v":399658.97898374655},{"$f":"SUM(L12:L26)","v":407531.18397502188},{"$f":"SUM(M12:M26)","v":414361.81908828189},{"$f":"SUM(N12:N26)","v":421313.39410318172},{"$f":"SUM(O12:O26)","v":428385.93724116456}]
[]
[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'!$D29","v":"Single Phase (inc. DC)"},"No.",null,null,{"$f":"IF($F31=0,0,SUMPRODUCT('Input | Exit Fees'!$J$69:$J$83,($H$12:$H$26=$F31)/1))","v":307426.10633907933},{"$f":"IF($F31=0,0,SUMPRODUCT(K$12:K$26,($H$12:$H$26=$F31)/1))","v":306881.31317020638},{"$f":"IF($F31=0,0,SUMPRODUCT(L$12:L$26,($H$12:$H$26=$F31)/1))","v":305471.60124517092},{"$f":"IF($F31=0,0,SUMPRODUCT(M$12:M$26,($H$12:$H$26=$F31)/1))","v":303726.30598456541},{"$f":"IF($F31=0,0,SUMPRODUCT(N$12:N$26,($H$12:$H$26=$F31)/1))","v":301950.1093753078},{"$f":"IF($F31=0,0,SUMPRODUCT(O$12:O$26,($H$12:$H$26=$F31)/1))","v":300143.00420653843}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D30","v":"Single Phase, Two Element"},"No.",null,null,{"$f":"IF($F32=0,0,SUMPRODUCT('Input | Exit Fees'!$J$69:$J$83,($H$12:$H$26=$F32)/1))","v":20550.731316981815},{"$f":"IF($F32=0,0,SUMPRODUCT(K$12:K$26,($H$12:$H$26=$F32)/1))","v":20366.679503952022},{"$f":"IF($F32=0,0,SUMPRODUCT(L$12:L$26,($H$12:$H$26=$F32)/1))","v":19995.214387729036},{"$f":"IF($F32=0,0,SUMPRODUCT(M$12:M$26,($H$12:$H$26=$F32)/1))","v":19617.038348064045},{"$f":"IF($F32=0,0,SUMPRODUCT(N$12:N$26,($H$12:$H$26=$F32)/1))","v":19232.16650745504},{"$f":"IF($F32=0,0,SUMPRODUCT(O$12:O$26,($H$12:$H$26=$F32)/1))","v":18840.597303430375}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D31","v":"Three Phase (inc. DC)"},"No.",null,null,{"$f":"IF($F33=0,0,SUMPRODUCT('Input | Exit Fees'!$J$69:$J$83,($H$12:$H$26=$F33)/1))","v":64521.325093293177},{"$f":"IF($F33=0,0,SUMPRODUCT(K$12:K$26,($H$12:$H$26=$F33)/1))","v":69646.77784576673},{"$f":"IF($F33=0,0,SUMPRODUCT(L$12:L$26,($H$12:$H$26=$F33)/1))","v":79116.668687719997},{"$f":"IF($F33=0,0,SUMPRODUCT(M$12:M$26,($H$12:$H$26=$F33)/1))","v":87883.188263737073},{"$f":"IF($F33=0,0,SUMPRODUCT(N$12:N$26,($H$12:$H$26=$F33)/1))","v":96804.923569721766},{"$f":"IF($F33=0,0,SUMPRODUCT(O$12:O$26,($H$12:$H$26=$F33)/1))","v":105881.91082541502}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D32","v":"Three Phase CT"},"No.",null,null,{"$f":"IF($F34=0,0,SUMPRODUCT('Input | Exit Fees'!$J$69:$J$83,($H$12:$H$26=$F34)/1))","v":2673.679981521087},{"$f":"IF($F34=0,0,SUMPRODUCT(K$12:K$26,($H$12:$H$26=$F34)/1))","v":2764.2084638213669},{"$f":"IF($F34=0,0,SUMPRODUCT(L$12:L$26,($H$12:$H$26=$F34)/1))","v":2947.6996544019103},{"$f":"IF($F34=0,0,SUMPRODUCT(M$12:M$26,($H$12:$H$26=$F34)/1))","v":3135.2864919153649},{"$f":"IF($F34=0,0,SUMPRODUCT(N$12:N$26,($H$12:$H$26=$F34)/1))","v":3326.194650697139},{"$f":"IF($F34=0,0,SUMPRODUCT(O$12:O$26,($H$12:$H$26=$F34)/1))","v":3520.4249057807683}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D33","v":0},"No.",null,null,{"$f":"IF($F35=0,0,SUMPRODUCT('Input | Exit Fees'!$J$69:$J$83,($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'!$D34","v":0},"No.",null,null,{"$f":"IF($F36=0,0,SUMPRODUCT('Input | Exit Fees'!$J$69:$J$83,($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'!$D35","v":0},"No.",null,null,{"$f":"IF($F37=0,0,SUMPRODUCT('Input | Exit Fees'!$J$69:$J$83,($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'!$D36","v":0},"No.",null,null,{"$f":"IF($F38=0,0,SUMPRODUCT('Input | Exit Fees'!$J$69:$J$83,($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'!$D37","v":0},"No.",null,null,{"$f":"IF($F39=0,0,SUMPRODUCT('Input | Exit Fees'!$J$69:$J$83,($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'!$D38","v":0},"No.",null,null,{"$f":"IF($F40=0,0,SUMPRODUCT('Input | Exit Fees'!$J$69:$J$83,($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":395171.84273087542},399658.97898374655,407531.18397502188,414361.81908828189,421313.39410318172,428385.93724116456]
[]
[]
[null,null,null,null,"Cost-Weighted Volume of Meters",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(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'!$D29","v":"Single Phase (inc. DC)"},"$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,K$12:K$26,($H$12:$H$26=$F46)/1)","v":126248331.82258452},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,L$12:L$26,($H$12:$H$26=$F46)/1)","v":125668388.46582685},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,M$12:M$26,($H$12:$H$26=$F46)/1)","v":124950389.01218432},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,N$12:N$26,($H$12:$H$26=$F46)/1)","v":124219677.00958242},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,O$12:O$26,($H$12:$H$26=$F46)/1)","v":123476249.49153551}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D30","v":"Single Phase, Two Element"},"$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,K$12:K$26,($H$12:$H$26=$F47)/1)","v":9136423.5653786175},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,L$12:L$26,($H$12:$H$26=$F47)/1)","v":8969785.5701709427},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,M$12:M$26,($H$12:$H$26=$F47)/1)","v":8800137.077396933},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,N$12:N$26,($H$12:$H$26=$F47)/1)","v":8627484.8709580563},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,O$12:O$26,($H$12:$H$26=$F47)/1)","v":8451828.2499348167}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D31","v":"Three Phase (inc. DC)"},"$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,K$12:K$26,($H$12:$H$26=$F48)/1)","v":40845788.320929661},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,L$12:L$26,($H$12:$H$26=$F48)/1)","v":46399600.984156042},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,M$12:M$26,($H$12:$H$26=$F48)/1)","v":51540907.071657173},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,N$12:N$26,($H$12:$H$26=$F48)/1)","v":56773242.623067975},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,O$12:O$26,($H$12:$H$26=$F48)/1)","v":62096628.880202025}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D32","v":"Three Phase CT"},"$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,K$12:K$26,($H$12:$H$26=$F49)/1)","v":2373596.9939603256},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,L$12:L$26,($H$12:$H$26=$F49)/1)","v":2531158.9666120107},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,M$12:M$26,($H$12:$H$26=$F49)/1)","v":2692237.8285922389},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,N$12:N$26,($H$12:$H$26=$F49)/1)","v":2856168.6745243431},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,O$12:O$26,($H$12:$H$26=$F49)/1)","v":3022952.1699215425}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D33","v":0},"$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,K$12:K$26,($H$12:$H$26=$F50)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,L$12:L$26,($H$12:$H$26=$F50)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,M$12:M$26,($H$12:$H$26=$F50)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,N$12:N$26,($H$12:$H$26=$F50)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,O$12:O$26,($H$12:$H$26=$F50)/1)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D34","v":0},"$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,K$12:K$26,($H$12:$H$26=$F51)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,L$12:L$26,($H$12:$H$26=$F51)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,M$12:M$26,($H$12:$H$26=$F51)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,N$12:N$26,($H$12:$H$26=$F51)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,O$12:O$26,($H$12:$H$26=$F51)/1)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D35","v":0},"$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,K$12:K$26,($H$12:$H$26=$F52)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,L$12:L$26,($H$12:$H$26=$F52)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,M$12:M$26,($H$12:$H$26=$F52)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,N$12:N$26,($H$12:$H$26=$F52)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,O$12:O$26,($H$12:$H$26=$F52)/1)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D36","v":0},"$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,K$12:K$26,($H$12:$H$26=$F53)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,L$12:L$26,($H$12:$H$26=$F53)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,M$12:M$26,($H$12:$H$26=$F53)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,N$12:N$26,($H$12:$H$26=$F53)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,O$12:O$26,($H$12:$H$26=$F53)/1)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D37","v":0},"$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,K$12:K$26,($H$12:$H$26=$F54)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,L$12:L$26,($H$12:$H$26=$F54)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,M$12:M$26,($H$12:$H$26=$F54)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,N$12:N$26,($H$12:$H$26=$F54)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,O$12:O$26,($H$12:$H$26=$F54)/1)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D38","v":0},"$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,K$12:K$26,($H$12:$H$26=$F55)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,L$12:L$26,($H$12:$H$26=$F55)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,M$12:M$26,($H$12:$H$26=$F55)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,N$12:N$26,($H$12:$H$26=$F55)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,O$12:O$26,($H$12:$H$26=$F55)/1)","v":0}]
[null,null,null,null,null,"Total","$dollars",null,null,null,{"$f":"SUM(K46:K55)","v":178604140.70285314},{"$f":"SUM(L46:L55)","v":183568933.98676586},{"$f":"SUM(M46:M55)","v":187983670.98983067},{"$f":"SUM(N46:N55)","v":192476573.1781328},{"$f":"SUM(O46:O55)","v":197047658.79159391}]
[]
[]
[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'!$D29","v":"Single Phase (inc. DC)"},"%",null,null,null,{"$f":"K46/K$56","v":0.70686116976776092},0.68458418173789004,0.6646874611728576,0.64537556419720676,0.62663139592097017]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D30","v":"Single Phase, Two Element"},"%",null,null,null,5.1154601060336258E-2,4.8863309141499979E-2,4.6813305810338136E-2,4.4823558153092795E-2,4.2892304845265045E-2]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D31","v":"Three Phase (inc. DC)"},"%",null,null,null,0.22869452052002265,0.25276390714074287,0.27417757510675156,0.2949618319031771,0.31513507575280603]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D32","v":"Three Phase CT"},"%",null,null,null,1.3289708651880143E-2,1.378860197986709E-2,1.4321657910052627E-2,1.4839045746523253E-2,1.534122348095872E-2]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D33","v":0},"%",null,null,null,0,0,0,0,0]
[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,"Total","%",null,null,null,{"$f":"SUM(K61:K70)","v":1},{"$f":"SUM(L61:L70)","v":0.99999999999999989},{"$f":"SUM(M61:M70)","v":0.99999999999999989},{"$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",null,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'!$D29","v":"Single Phase (inc. DC)"},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!H$9:I$9)*'Calc | Exit Fees'!K61","v":29.882370371991929},{"$f":"AVERAGE('Input | Exit Fees'!I$9:J$9)*'Calc | Exit Fees'!L61","v":32.776905803559394},{"$f":"AVERAGE('Input | Exit Fees'!J$9:K$9)*'Calc | Exit Fees'!M61","v":39.758436938476287},{"$f":"AVERAGE('Input | Exit Fees'!K$9:L$9)*'Calc | Exit Fees'!N61","v":48.814334480470549},{"$f":"AVERAGE('Input | Exit Fees'!L$9:M$9)*'Calc | Exit Fees'!O61","v":58.875866827952123}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D30","v":"Single Phase, Two Element"},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!H$9:I$9)*'Calc | Exit Fees'!K62","v":2.1625473296527056},{"$f":"AVERAGE('Input | Exit Fees'!I$9:J$9)*'Calc | Exit Fees'!L62","v":2.3395049487052781},{"$f":"AVERAGE('Input | Exit Fees'!J$9:K$9)*'Calc | Exit Fees'!M62","v":2.8001489055589501},{"$f":"AVERAGE('Input | Exit Fees'!K$9:L$9)*'Calc | Exit Fees'!N62","v":3.3903238388203052},{"$f":"AVERAGE('Input | Exit Fees'!L$9:M$9)*'Calc | Exit Fees'!O62","v":4.0299953759933214}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D31","v":"Three Phase (inc. DC)"},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!H$9:I$9)*'Calc | Exit Fees'!K63","v":9.6680008133276196},{"$f":"AVERAGE('Input | Exit Fees'!I$9:J$9)*'Calc | Exit Fees'!L63","v":12.101972256881345},{"$f":"AVERAGE('Input | Exit Fees'!J$9:K$9)*'Calc | Exit Fees'!M63","v":16.399996188571496},{"$f":"AVERAGE('Input | Exit Fees'!K$9:L$9)*'Calc | Exit Fees'!N63","v":22.310056841715689},{"$f":"AVERAGE('Input | Exit Fees'!L$9:M$9)*'Calc | Exit Fees'!O63","v":29.608875127569885}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D32","v":"Three Phase CT"},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!H$9:I$9)*'Calc | Exit Fees'!K64","v":0.56181894416668021},{"$f":"AVERAGE('Input | Exit Fees'!I$9:J$9)*'Calc | Exit Fees'!L64","v":0.66017842701179363},{"$f":"AVERAGE('Input | Exit Fees'!J$9:K$9)*'Calc | Exit Fees'!M64","v":0.85665333879854622},{"$f":"AVERAGE('Input | Exit Fees'!K$9:L$9)*'Calc | Exit Fees'!N64","v":1.1223823501015735},{"$f":"AVERAGE('Input | Exit Fees'!L$9:M$9)*'Calc | Exit Fees'!O64","v":1.4414021329322149}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D33","v":0},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!H$9:I$9)*'Calc | Exit Fees'!K65","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$9:J$9)*'Calc | Exit Fees'!L65","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$9:K$9)*'Calc | Exit Fees'!M65","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$9:L$9)*'Calc | Exit Fees'!N65","v":0},{"$f":"AVERAGE('Input | Exit Fees'!L$9:M$9)*'Calc | Exit Fees'!O65","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D34","v":0},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!H$9:I$9)*'Calc | Exit Fees'!K66","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$9:J$9)*'Calc | Exit Fees'!L66","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$9:K$9)*'Calc | Exit Fees'!M66","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$9:L$9)*'Calc | Exit Fees'!N66","v":0},{"$f":"AVERAGE('Input | Exit Fees'!L$9:M$9)*'Calc | Exit Fees'!O66","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D35","v":0},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!H$9:I$9)*'Calc | Exit Fees'!K67","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$9:J$9)*'Calc | Exit Fees'!L67","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$9:K$9)*'Calc | Exit Fees'!M67","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$9:L$9)*'Calc | Exit Fees'!N67","v":0},{"$f":"AVERAGE('Input | Exit Fees'!L$9:M$9)*'Calc | Exit Fees'!O67","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D36","v":0},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!H$9:I$9)*'Calc | Exit Fees'!K68","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$9:J$9)*'Calc | Exit Fees'!L68","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$9:K$9)*'Calc | Exit Fees'!M68","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$9:L$9)*'Calc | Exit Fees'!N68","v":0},{"$f":"AVERAGE('Input | Exit Fees'!L$9:M$9)*'Calc | Exit Fees'!O68","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D37","v":0},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!H$9:I$9)*'Calc | Exit Fees'!K69","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$9:J$9)*'Calc | Exit Fees'!L69","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$9:K$9)*'Calc | Exit Fees'!M69","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$9:L$9)*'Calc | Exit Fees'!N69","v":0},{"$f":"AVERAGE('Input | Exit Fees'!L$9:M$9)*'Calc | Exit Fees'!O69","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D38","v":0},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!H$9:I$9)*'Calc | Exit Fees'!K70","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$9:J$9)*'Calc | Exit Fees'!L70","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$9:K$9)*'Calc | Exit Fees'!M70","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$9:L$9)*'Calc | Exit Fees'!N70","v":0},{"$f":"AVERAGE('Input | Exit Fees'!L$9:M$9)*'Calc | Exit Fees'!O70","v":0}]
[null,null,null,null,null,"Total","$m",null,null,null,{"$f":"SUM(K77:K86)","v":42.27473745913894},{"$f":"SUM(L77:L86)","v":47.87856143615781},{"$f":"SUM(M77:M86)","v":59.815235371405272},{"$f":"SUM(N77:N86)","v":75.637097511108124},{"$f":"SUM(O77:O86)","v":93.956139464447546}]
[{"$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",null,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'!$D29","v":"Single Phase (inc. DC)"},"$dollars",null,null,null,{"$f":"IFERROR(K77*10^6/K31,0)","v":97.374356435376015},{"$f":"IFERROR(L77*10^6/L31,0)","v":107.29935506264201},130.90218448347608,161.66357608367991,196.15938403627649]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D30","v":"Single Phase, Two Element"},"$dollars",null,null,null,106.18065302363487,117.00324404328572,142.74065513234262,176.28403110518519,213.89955483309254]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D31","v":"Three Phase (inc. DC)"},"$dollars",null,null,null,138.81476088868712,152.96362268043447,186.61130203145541,230.46407165072887,279.64054385447315]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D32","v":"Three Phase CT"},"$dollars",null,null,null,203.2476752458808,223.96393948275036,273.22968443474258,337.43736250262225,409.43981806438705]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D33","v":0},"$dollars",null,null,null,0,0,0,0,0]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D34","v":0},"$dollars",null,null,null,0,0,0,0,0]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D35","v":0},"$dollars",null,null,null,0,0,0,0,0]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D36","v":0},"$dollars",null,null,null,0,0,0,0,0]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D37","v":0},"$dollars",null,null,null,0,0,0,0,0]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D38","v":0},"$dollars",null,null,null,0,0,0,0,0]
[]
[null,"Calculations | Comms & IT & Other"]
[]
[null,null,"Calculation of Allocated Comms & IT 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",null,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 & Other RAB per meter","$dollars",null,null,null,{"$f":"(AVERAGE('Input | Exit Fees'!G$16:H$16)*10^6)/'Calc | Exit Fees'!K$41","v":16.861068758802563},{"$f":"(AVERAGE('Input | Exit Fees'!H$16:I$16)*10^6)/'Calc | Exit Fees'!L$41","v":17.658852376472069},{"$f":"(AVERAGE('Input | Exit Fees'!I$16:J$16)*10^6)/'Calc | Exit Fees'!M$41","v":19.536561358464482},{"$f":"(AVERAGE('Input | Exit Fees'!J$16:K$16)*10^6)/'Calc | Exit Fees'!N$41","v":20.67914197662197},{"$f":"(AVERAGE('Input | Exit Fees'!K$16:L$16)*10^6)/'Calc | Exit Fees'!O$41","v":20.843605003631005}]
[]
[]
[]
[null,"Calculations | Exit Fees with Component Detail"]
[]
[null,null,null,null,null,"Base Year","Regulatory period"]
[null,null,null,null,null,null,"Tariff ($/year)"]
[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'!D29","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$29:$D$38,$D118))","v":97.374356435376015},{"$f":"IF($D118=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$29:$D$38,$D118))","v":107.29935506264201},{"$f":"IF($D118=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$29:$D$38,$D118))","v":130.90218448347608},{"$f":"IF($D118=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$29:$D$38,$D118))","v":161.66357608367991},{"$f":"IF($D118=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$29:$D$38,$D118))","v":196.15938403627649}]
[null,null,null,null,"Comms & IT & Other",null,{"$f":"IF($D118=0,0,'Calc | Exit Fees'!K$109)","v":16.861068758802563},{"$f":"IF($D118=0,0,'Calc | Exit Fees'!L$109)","v":17.658852376472069},{"$f":"IF($D118=0,0,'Calc | Exit Fees'!M$109)","v":19.536561358464482},{"$f":"IF($D118=0,0,'Calc | Exit Fees'!N$109)","v":20.67914197662197},{"$f":"IF($D118=0,0,'Calc | Exit Fees'!O$109)","v":20.843605003631005}]
[null,null,null,null,"Admin cost",null,{"$f":"IF($D118=0,0,'Input | Exit Fees'!K$119)","v":58.785722930508697},{"$f":"IF($D118=0,0,'Input | Exit Fees'!L$119)","v":60.576707248343126},{"$f":"IF($D118=0,0,'Input | Exit Fees'!M$119)","v":62.498191576191175},{"$f":"IF($D118=0,0,'Input | Exit Fees'!N$119)","v":64.496919303493158},{"$f":"IF($D118=0,0,'Input | Exit Fees'!O$119)","v":66.526599984674206}]
[null,null,null,null,"Tax allowance",null,{"$f":"+'Calc | Tax Allowance'!G29","v":6.9225354465432805},{"$f":"+'Calc | Tax Allowance'!H29","v":6.6058623330396049},{"$f":"+'Calc | Tax Allowance'!I29","v":6.6179261235517171},{"$f":"+'Calc | Tax Allowance'!J29","v":7.0572004243166848},{"$f":"+'Calc | Tax Allowance'!K29","v":7.4344018433939443}]
[null,null,null,null,"TOTAL exit fee",{"$f":"IF(D118=0,0,'Input | Exit Fees'!G29)","v":191.64},{"$f":"SUM(G119:G122)","v":179.94368357123057},{"$f":"SUM(H119:H122)","v":192.14077702049681},{"$f":"SUM(I119:I122)","v":219.55486354168343},{"$f":"SUM(J119:J122)","v":253.8968377881117},{"$f":"SUM(K119:K122)","v":290.96399086797567}]
[null,null,2,{"$f":"'Input | Exit Fees'!D30","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$29:$D$38,$D124))","v":106.18065302363487},{"$f":"IF($D124=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$29:$D$38,$D124))","v":117.00324404328572},{"$f":"IF($D124=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$29:$D$38,$D124))","v":142.74065513234262},{"$f":"IF($D124=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$29:$D$38,$D124))","v":176.28403110518519},{"$f":"IF($D124=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$29:$D$38,$D124))","v":213.89955483309254}]
[null,null,null,null,{"$f":"IF($D124=0,\"\",E$120)","v":"Comms & IT & Other"},null,{"$f":"IF($D124=0,0,'Calc | Exit Fees'!K$109)","v":16.861068758802563},{"$f":"IF($D124=0,0,'Calc | Exit Fees'!L$109)","v":17.658852376472069},{"$f":"IF($D124=0,0,'Calc | Exit Fees'!M$109)","v":19.536561358464482},{"$f":"IF($D124=0,0,'Calc | Exit Fees'!N$109)","v":20.67914197662197},{"$f":"IF($D124=0,0,'Calc | Exit Fees'!O$109)","v":20.843605003631005}]
[null,null,null,null,{"$f":"IF($D124=0,\"\",E$121)","v":"Admin cost"},null,{"$f":"IF($D124=0,0,'Input | Exit Fees'!K$119)","v":58.785722930508697},{"$f":"IF($D124=0,0,'Input | Exit Fees'!L$119)","v":60.576707248343126},{"$f":"IF($D124=0,0,'Input | Exit Fees'!M$119)","v":62.498191576191175},{"$f":"IF($D124=0,0,'Input | Exit Fees'!N$119)","v":64.496919303493158},{"$f":"IF($D124=0,0,'Input | Exit Fees'!O$119)","v":66.526599984674206}]
[null,null,null,null,{"$f":"IF($D124=0,\"\",E$122)","v":"Tax allowance"},null,{"$f":"+'Calc | Tax Allowance'!G50","v":7.4249073492370563},{"$f":"+'Calc | Tax Allowance'!H50","v":7.0820456895748229},{"$f":"+'Calc | Tax Allowance'!I50","v":7.0871071139680435},{"$f":"+'Calc | Tax Allowance'!J50","v":7.5440457403660677},{"$f":"+'Calc | Tax Allowance'!K50","v":7.9368557016883887}]
[null,null,null,null,{"$f":"IF($D124=0,\"\",E$123)","v":"TOTAL exit fee"},{"$f":"IF(D124=0,0,'Input | Exit Fees'!G30)","v":191.64},{"$f":"SUM(G125:G128)","v":189.25235206218321},{"$f":"SUM(H125:H128)","v":202.32084935767574},{"$f":"SUM(I125:I128)","v":231.86251518096634},{"$f":"SUM(J125:J128)","v":269.00413812566637},{"$f":"SUM(K125:K128)","v":309.20661552308616}]
[null,null,3,{"$f":"'Input | Exit Fees'!D31","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$29:$D$38,$D130))","v":138.81476088868712},{"$f":"IF($D130=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$29:$D$38,$D130))","v":152.96362268043447},{"$f":"IF($D130=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$29:$D$38,$D130))","v":186.61130203145541},{"$f":"IF($D130=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$29:$D$38,$D130))","v":230.46407165072887},{"$f":"IF($D130=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$29:$D$38,$D130))","v":279.64054385447315}]
[null,null,null,null,{"$f":"IF($D130=0,\"\",E$120)","v":"Comms & IT & Other"},null,{"$f":"IF($D130=0,0,'Calc | Exit Fees'!K$109)","v":16.861068758802563},{"$f":"IF($D130=0,0,'Calc | Exit Fees'!L$109)","v":17.658852376472069},{"$f":"IF($D130=0,0,'Calc | Exit Fees'!M$109)","v":19.536561358464482},{"$f":"IF($D130=0,0,'Calc | Exit Fees'!N$109)","v":20.67914197662197},{"$f":"IF($D130=0,0,'Calc | Exit Fees'!O$109)","v":20.843605003631005}]
[null,null,null,null,{"$f":"IF($D130=0,\"\",E$121)","v":"Admin cost"},null,{"$f":"IF($D130=0,0,'Input | Exit Fees'!K$119)","v":58.785722930508697},{"$f":"IF($D130=0,0,'Input | Exit Fees'!L$119)","v":60.576707248343126},{"$f":"IF($D130=0,0,'Input | Exit Fees'!M$119)","v":62.498191576191175},{"$f":"IF($D130=0,0,'Input | Exit Fees'!N$119)","v":64.496919303493158},{"$f":"IF($D130=0,0,'Input | Exit Fees'!O$119)","v":66.526599984674206}]
[null,null,null,null,{"$f":"IF($D130=0,\"\",E$122)","v":"Tax allowance"},null,{"$f":"+'Calc | Tax Allowance'!G71","v":9.2865819699553978},{"$f":"+'Calc | Tax Allowance'!H71","v":8.8466715870754573},{"$f":"+'Calc | Tax Allowance'!I71","v":8.8257838546415499},{"$f":"+'Calc | Tax Allowance'!J71","v":9.3481824053443479},{"$f":"+'Calc | Tax Allowance'!K71","v":9.798834030995911}]
[null,null,null,null,{"$f":"IF($D130=0,\"\",E$123)","v":"TOTAL exit fee"},{"$f":"IF(D130=0,0,'Input | Exit Fees'!G31)","v":191.64},{"$f":"SUM(G131:G134)","v":223.74813454795375},{"$f":"SUM(H131:H134)","v":240.04585389232511},{"$f":"SUM(I131:I134)","v":277.47183882075262},{"$f":"SUM(J131:J134)","v":324.98831533618835},{"$f":"SUM(K131:K134)","v":376.80958287377427}]
[null,null,4,{"$f":"'Input | Exit Fees'!D32","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$29:$D$38,$D136))","v":203.2476752458808},{"$f":"IF($D136=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$29:$D$38,$D136))","v":223.96393948275036},{"$f":"IF($D136=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$29:$D$38,$D136))","v":273.22968443474258},{"$f":"IF($D136=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$29:$D$38,$D136))","v":337.43736250262225},{"$f":"IF($D136=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$29:$D$38,$D136))","v":409.43981806438705}]
[null,null,null,null,{"$f":"IF($D136=0,\"\",E$120)","v":"Comms & IT & Other"},null,{"$f":"IF($D136=0,0,'Calc | Exit Fees'!K$109)","v":16.861068758802563},{"$f":"IF($D136=0,0,'Calc | Exit Fees'!L$109)","v":17.658852376472069},{"$f":"IF($D136=0,0,'Calc | Exit Fees'!M$109)","v":19.536561358464482},{"$f":"IF($D136=0,0,'Calc | Exit Fees'!N$109)","v":20.67914197662197},{"$f":"IF($D136=0,0,'Calc | Exit Fees'!O$109)","v":20.843605003631005}]
[null,null,null,null,{"$f":"IF($D136=0,\"\",E$121)","v":"Admin cost"},null,{"$f":"IF($D136=0,0,'Input | Exit Fees'!K$119)","v":58.785722930508697},{"$f":"IF($D136=0,0,'Input | Exit Fees'!L$119)","v":60.576707248343126},{"$f":"IF($D136=0,0,'Input | Exit Fees'!M$119)","v":62.498191576191175},{"$f":"IF($D136=0,0,'Input | Exit Fees'!N$119)","v":64.496919303493158},{"$f":"IF($D136=0,0,'Input | Exit Fees'!O$119)","v":66.526599984674206}]
[null,null,null,null,{"$f":"IF($D136=0,\"\",E$122)","v":"Tax allowance"},null,{"$f":"+'Calc | Tax Allowance'!G92","v":12.962279859223077},{"$f":"+'Calc | Tax Allowance'!H92","v":12.330756085303928},{"$f":"+'Calc | Tax Allowance'!I92","v":12.258634232838379},{"$f":"+'Calc | Tax Allowance'!J92","v":12.910277122439588},{"$f":"+'Calc | Tax Allowance'!K92","v":13.475131563728542}]
[null,null,null,null,{"$f":"IF($D136=0,\"\",E$123)","v":"TOTAL exit fee"},{"$f":"IF(D136=0,0,'Input | Exit Fees'!G32)","v":191.64},{"$f":"SUM(G137:G140)","v":291.85674679441513},{"$f":"SUM(H137:H140)","v":314.53025519286945},{"$f":"SUM(I137:I140)","v":367.52307160223666},{"$f":"SUM(J137:J140)","v":435.52370090517695},{"$f":"SUM(K137:K140)","v":510.28515461642081}]
[null,null,5,{"$f":"'Input | Exit Fees'!D33","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$29:$D$38,$D142))","v":0},{"$f":"IF($D142=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$29:$D$38,$D142))","v":0},{"$f":"IF($D142=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$29:$D$38,$D142))","v":0},{"$f":"IF($D142=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$29:$D$38,$D142))","v":0},{"$f":"IF($D142=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$29:$D$38,$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$119)","v":0},{"$f":"IF($D142=0,0,'Input | Exit Fees'!L$119)","v":0},{"$f":"IF($D142=0,0,'Input | Exit Fees'!M$119)","v":0},{"$f":"IF($D142=0,0,'Input | Exit Fees'!N$119)","v":0},{"$f":"IF($D142=0,0,'Input | Exit Fees'!O$119)","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'!G33)","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'!D34","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$29:$D$38,$D148))","v":0},{"$f":"IF($D148=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$29:$D$38,$D148))","v":0},{"$f":"IF($D148=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$29:$D$38,$D148))","v":0},{"$f":"IF($D148=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$29:$D$38,$D148))","v":0},{"$f":"IF($D148=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$29:$D$38,$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$119)","v":0},{"$f":"IF($D148=0,0,'Input | Exit Fees'!L$119)","v":0},{"$f":"IF($D148=0,0,'Input | Exit Fees'!M$119)","v":0},{"$f":"IF($D148=0,0,'Input | Exit Fees'!N$119)","v":0},{"$f":"IF($D148=0,0,'Input | Exit Fees'!O$119)","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'!G34)","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'!D35","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$29:$D$38,$D154))","v":0},{"$f":"IF($D154=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$29:$D$38,$D154))","v":0},{"$f":"IF($D154=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$29:$D$38,$D154))","v":0},{"$f":"IF($D154=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$29:$D$38,$D154))","v":0},{"$f":"IF($D154=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$29:$D$38,$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$119)","v":0},{"$f":"IF($D154=0,0,'Input | Exit Fees'!L$119)","v":0},{"$f":"IF($D154=0,0,'Input | Exit Fees'!M$119)","v":0},{"$f":"IF($D154=0,0,'Input | Exit Fees'!N$119)","v":0},{"$f":"IF($D154=0,0,'Input | Exit Fees'!O$119)","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'!G35)","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'!D36","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$29:$D$38,$D160))","v":0},{"$f":"IF($D160=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$29:$D$38,$D160))","v":0},{"$f":"IF($D160=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$29:$D$38,$D160))","v":0},{"$f":"IF($D160=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$29:$D$38,$D160))","v":0},{"$f":"IF($D160=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$29:$D$38,$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$119)","v":0},{"$f":"IF($D160=0,0,'Input | Exit Fees'!L$119)","v":0},{"$f":"IF($D160=0,0,'Input | Exit Fees'!M$119)","v":0},{"$f":"IF($D160=0,0,'Input | Exit Fees'!N$119)","v":0},{"$f":"IF($D160=0,0,'Input | Exit Fees'!O$119)","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'!G36)","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'!D37","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$29:$D$38,$D166))","v":0},{"$f":"IF($D166=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$29:$D$38,$D166))","v":0},{"$f":"IF($D166=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$29:$D$38,$D166))","v":0},{"$f":"IF($D166=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$29:$D$38,$D166))","v":0},{"$f":"IF($D166=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$29:$D$38,$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$119)","v":0},{"$f":"IF($D166=0,0,'Input | Exit Fees'!L$119)","v":0},{"$f":"IF($D166=0,0,'Input | Exit Fees'!M$119)","v":0},{"$f":"IF($D166=0,0,'Input | Exit Fees'!N$119)","v":0},{"$f":"IF($D166=0,0,'Input | Exit Fees'!O$119)","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'!G37)","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'!D38","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$29:$D$38,$D172))","v":0},{"$f":"IF($D172=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$29:$D$38,$D172))","v":0},{"$f":"IF($D172=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$29:$D$38,$D172))","v":0},{"$f":"IF($D172=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$29:$D$38,$D172))","v":0},{"$f":"IF($D172=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$29:$D$38,$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$119)","v":0},{"$f":"IF($D172=0,0,'Input | Exit Fees'!L$119)","v":0},{"$f":"IF($D172=0,0,'Input | Exit Fees'!M$119)","v":0},{"$f":"IF($D172=0,0,'Input | Exit Fees'!N$119)","v":0},{"$f":"IF($D172=0,0,'Input | Exit Fees'!O$119)","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'!G38)","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",null,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'!$D29","v":"Single Phase (inc. DC)"},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!H$126:I$126)*'Calc | Exit Fees'!K61","v":18.372365100168182},{"$f":"AVERAGE('Input | Exit Fees'!I$126:J$126)*'Calc | Exit Fees'!L61","v":21.917031703735706},{"$f":"AVERAGE('Input | Exit Fees'!J$126:K$126)*'Calc | Exit Fees'!M61","v":29.119394215262737},{"$f":"AVERAGE('Input | Exit Fees'!K$126:L$126)*'Calc | Exit Fees'!N61","v":37.839299217574712},{"$f":"AVERAGE('Input | Exit Fees'!L$126:M$126)*'Calc | Exit Fees'!O61","v":47.61675460983232}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D30","v":"Single Phase, Two Element"},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!H$126:I$126)*'Calc | Exit Fees'!K62","v":1.3295835836374057},{"$f":"AVERAGE('Input | Exit Fees'!I$126:J$126)*'Calc | Exit Fees'!L62","v":1.5643637761027456},{"$f":"AVERAGE('Input | Exit Fees'!J$126:K$126)*'Calc | Exit Fees'!M62","v":2.0508512436890705},{"$f":"AVERAGE('Input | Exit Fees'!K$126:L$126)*'Calc | Exit Fees'!N62","v":2.6280697984917283},{"$f":"AVERAGE('Input | Exit Fees'!L$126:M$126)*'Calc | Exit Fees'!O62","v":3.2593201805111769}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D31","v":"Three Phase (inc. DC)"},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!H$126:I$126)*'Calc | Exit Fees'!K63","v":5.9441081319861073},{"$f":"AVERAGE('Input | Exit Fees'!I$126:J$126)*'Calc | Exit Fees'!L63","v":8.0922620097652693},{"$f":"AVERAGE('Input | Exit Fees'!J$126:K$126)*'Calc | Exit Fees'!M63","v":12.011487143793177},{"$f":"AVERAGE('Input | Exit Fees'!K$126:L$126)*'Calc | Exit Fees'!N63","v":17.294037199923782},{"$f":"AVERAGE('Input | Exit Fees'!L$126:M$126)*'Calc | Exit Fees'!O63","v":23.946629021066126}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D32","v":"Three Phase CT"},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!H$126:I$126)*'Calc | Exit Fees'!K64","v":0.34541914292367437},{"$f":"AVERAGE('Input | Exit Fees'!I$126:J$126)*'Calc | Exit Fees'!L64","v":0.44144348467964845},{"$f":"AVERAGE('Input | Exit Fees'!J$126:K$126)*'Calc | Exit Fees'!M64","v":0.62741969250192309},{"$f":"AVERAGE('Input | Exit Fees'!K$126:L$126)*'Calc | Exit Fees'!N64","v":0.87003463294187566},{"$f":"AVERAGE('Input | Exit Fees'!L$126:M$126)*'Calc | Exit Fees'!O64","v":1.1657559430672677}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D33","v":0},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!H$126:I$126)*'Calc | Exit Fees'!K65","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$126:J$126)*'Calc | Exit Fees'!L65","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$126:K$126)*'Calc | Exit Fees'!M65","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$126:L$126)*'Calc | Exit Fees'!N65","v":0},{"$f":"AVERAGE('Input | Exit Fees'!L$126:M$126)*'Calc | Exit Fees'!O65","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D34","v":0},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!H$126:I$126)*'Calc | Exit Fees'!K66","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$126:J$126)*'Calc | Exit Fees'!L66","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$126:K$126)*'Calc | Exit Fees'!M66","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$126:L$126)*'Calc | Exit Fees'!N66","v":0},{"$f":"AVERAGE('Input | Exit Fees'!L$126:M$126)*'Calc | Exit Fees'!O66","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D35","v":0},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!H$126:I$126)*'Calc | Exit Fees'!K67","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$126:J$126)*'Calc | Exit Fees'!L67","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$126:K$126)*'Calc | Exit Fees'!M67","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$126:L$126)*'Calc | Exit Fees'!N67","v":0},{"$f":"AVERAGE('Input | Exit Fees'!L$126:M$126)*'Calc | Exit Fees'!O67","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D36","v":0},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!H$126:I$126)*'Calc | Exit Fees'!K68","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$126:J$126)*'Calc | Exit Fees'!L68","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$126:K$126)*'Calc | Exit Fees'!M68","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$126:L$126)*'Calc | Exit Fees'!N68","v":0},{"$f":"AVERAGE('Input | Exit Fees'!L$126:M$126)*'Calc | Exit Fees'!O68","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D37","v":0},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!H$126:I$126)*'Calc | Exit Fees'!K69","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$126:J$126)*'Calc | Exit Fees'!L69","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$126:K$126)*'Calc | Exit Fees'!M69","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$126:L$126)*'Calc | Exit Fees'!N69","v":0},{"$f":"AVERAGE('Input | Exit Fees'!L$126:M$126)*'Calc | Exit Fees'!O69","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D38","v":0},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!H$126:I$126)*'Calc | Exit Fees'!K70","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$126:J$126)*'Calc | Exit Fees'!L70","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$126:K$126)*'Calc | Exit Fees'!M70","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$126:L$126)*'Calc | Exit Fees'!N70","v":0},{"$f":"AVERAGE('Input | Exit Fees'!L$126:M$126)*'Calc | Exit Fees'!O70","v":0}]
[null,null,null,null,null,"Total","$m",null,null,null,{"$f":"SUM(K186:K195)","v":25.99147595871537},{"$f":"SUM(L186:L195)","v":32.015100974283364},{"$f":"SUM(M186:M195)","v":43.809152295246911},{"$f":"SUM(N186:N195)","v":58.631440848932094},{"$f":"SUM(O186:O195)","v":75.988459754476892}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"(K196=AVERAGE('Input | Exit Fees'!H$126:I$126))/1","v":1},{"$f":"(L196=AVERAGE('Input | Exit Fees'!I$126:J$126))/1","v":1},{"$f":"(M196=AVERAGE('Input | Exit Fees'!J$126:K$126))/1","v":1},{"$f":"(N196=AVERAGE('Input | Exit Fees'!K$126:L$126))/1","v":1},{"$f":"(O196=AVERAGE('Input | Exit Fees'!L$126:M$126))/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",null,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'!$D29","v":"Single Phase (inc. DC)"},"$dollars",null,null,null,{"$f":"IFERROR(K186*10^6/'Calc | Exit Fees'!K31,0)","v":59.867982544698869},{"$f":"IFERROR(L186*10^6/'Calc | Exit Fees'!L31,0)","v":71.748180892747328},{"$f":"IFERROR(M186*10^6/'Calc | Exit Fees'!M31,0)","v":95.873797038648704},{"$f":"IFERROR(N186*10^6/'Calc | Exit Fees'!N31,0)","v":125.31639513513967},{"$f":"IFERROR(O186*10^6/'Calc | Exit Fees'!O31,0)","v":158.64689145666588}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D30","v":"Single Phase, Two Element"},"$dollars",null,null,null,{"$f":"IFERROR(K187*10^6/'Calc | Exit Fees'!K32,0)","v":65.282295200816051},{"$f":"IFERROR(L187*10^6/'Calc | Exit Fees'!L32,0)","v":78.236909380816044},{"$f":"IFERROR(M187*10^6/'Calc | Exit Fees'!M32,0)","v":104.5443867367198},{"$f":"IFERROR(N187*10^6/'Calc | Exit Fees'!N32,0)","v":136.6497007746371},{"$f":"IFERROR(O187*10^6/'Calc | Exit Fees'!O32,0)","v":172.99452496220707}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D31","v":"Three Phase (inc. DC)"},"$dollars",null,null,null,{"$f":"IFERROR(K188*10^6/'Calc | Exit Fees'!K33,0)","v":85.346491479467673},{"$f":"IFERROR(L188*10^6/'Calc | Exit Fees'!L33,0)","v":102.28264339220466},{"$f":"IFERROR(M188*10^6/'Calc | Exit Fees'!M33,0)","v":136.6755961077192},{"$f":"IFERROR(N188*10^6/'Calc | Exit Fees'!N33,0)","v":178.64832244269175},{"$f":"IFERROR(O188*10^6/'Calc | Exit Fees'!O33,0)","v":226.16355177562752}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D32","v":"Three Phase CT"},"$dollars",null,null,null,{"$f":"IFERROR(K189*10^6/'Calc | Exit Fees'!K34,0)","v":124.96132163858269},{"$f":"IFERROR(L189*10^6/'Calc | Exit Fees'!L34,0)","v":149.75863772973761},{"$f":"IFERROR(M189*10^6/'Calc | Exit Fees'!M34,0)","v":200.11558564736734},{"$f":"IFERROR(N189*10^6/'Calc | Exit Fees'!N34,0)","v":261.57057066985681},{"$f":"IFERROR(O189*10^6/'Calc | Exit Fees'!O34,0)","v":331.14069303197465}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D33","v":0},"$dollars",null,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'!$D34","v":0},"$dollars",null,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'!$D35","v":0},"$dollars",null,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'!$D36","v":0},"$dollars",null,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'!$D37","v":0},"$dollars",null,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'!$D38","v":0},"$dollars",null,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 & Other (TAB)"]
[]
[null,null,"Calculation of Allocated Comms & IT 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",null,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 & Other TAB per meter","$dollars",null,null,null,{"$f":"(AVERAGE('Input | Exit Fees'!G$133:H$133)*10^6)/'Calc | Exit Fees'!K$41","v":7.6269126189432983},{"$f":"(AVERAGE('Input | Exit Fees'!H$133:I$133)*10^6)/'Calc | Exit Fees'!L$41","v":8.6076537395644763},{"$f":"(AVERAGE('Input | Exit Fees'!I$133:J$133)*10^6)/'Calc | Exit Fees'!M$41","v":9.881122031093815},{"$f":"(AVERAGE('Input | Exit Fees'!J$133:K$133)*10^6)/'Calc | Exit Fees'!N$41","v":9.3765433160162317},{"$f":"(AVERAGE('Input | Exit Fees'!K$133:L$133)*10^6)/'Calc | Exit Fees'!O$41","v":8.1594773848220523}]
[]
[]
[]
[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)"]
[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'!D29","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$29:$D$38,$D227))","v":59.867982544698869},{"$f":"IF($D227=0,0,SUMIFS('Calc | Exit Fees'!L$201:L$210,'Input | Exit Fees'!$D$29:$D$38,$D227))","v":71.748180892747328},{"$f":"IF($D227=0,0,SUMIFS('Calc | Exit Fees'!M$201:M$210,'Input | Exit Fees'!$D$29:$D$38,$D227))","v":95.873797038648704},{"$f":"IF($D227=0,0,SUMIFS('Calc | Exit Fees'!N$201:N$210,'Input | Exit Fees'!$D$29:$D$38,$D227))","v":125.31639513513967},{"$f":"IF($D227=0,0,SUMIFS('Calc | Exit Fees'!O$201:O$210,'Input | Exit Fees'!$D$29:$D$38,$D227))","v":158.64689145666588}]
[null,null,null,null,"WDV - Comms & IT & Other",null,{"$f":"IF($D227=0,0,'Calc | Exit Fees'!K$218)","v":7.6269126189432983},{"$f":"IF($D227=0,0,'Calc | Exit Fees'!L$218)","v":8.6076537395644763},{"$f":"IF($D227=0,0,'Calc | Exit Fees'!M$218)","v":9.881122031093815},{"$f":"IF($D227=0,0,'Calc | Exit Fees'!N$218)","v":9.3765433160162317},{"$f":"IF($D227=0,0,'Calc | Exit Fees'!O$218)","v":8.1594773848220523}]
[]
[]
[null,null,null,null,"TOTAL WDV",null,{"$f":"SUM(G228:G231)","v":67.49489516364217},{"$f":"SUM(H228:H231)","v":80.355834632311797},{"$f":"SUM(I228:I231)","v":105.75491906974251},{"$f":"SUM(J228:J231)","v":134.6929384511559},{"$f":"SUM(K228:K231)","v":166.80636884148794}]
[null,null,2,{"$f":"'Input | Exit Fees'!D30","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$29:$D$38,$D233))","v":65.282295200816051},{"$f":"IF($D233=0,0,SUMIFS('Calc | Exit Fees'!L$201:L$210,'Input | Exit Fees'!$D$29:$D$38,$D233))","v":78.236909380816044},{"$f":"IF($D233=0,0,SUMIFS('Calc | Exit Fees'!M$201:M$210,'Input | Exit Fees'!$D$29:$D$38,$D233))","v":104.5443867367198},{"$f":"IF($D233=0,0,SUMIFS('Calc | Exit Fees'!N$201:N$210,'Input | Exit Fees'!$D$29:$D$38,$D233))","v":136.6497007746371},{"$f":"IF($D233=0,0,SUMIFS('Calc | Exit Fees'!O$201:O$210,'Input | Exit Fees'!$D$29:$D$38,$D233))","v":172.99452496220707}]
[null,null,null,null,{"$f":"IF($D233=0,\"\",E$229)","v":"WDV - Comms & IT & Other"},null,{"$f":"IF($D233=0,0,'Calc | Exit Fees'!K$218)","v":7.6269126189432983},{"$f":"IF($D233=0,0,'Calc | Exit Fees'!L$218)","v":8.6076537395644763},{"$f":"IF($D233=0,0,'Calc | Exit Fees'!M$218)","v":9.881122031093815},{"$f":"IF($D233=0,0,'Calc | Exit Fees'!N$218)","v":9.3765433160162317},{"$f":"IF($D233=0,0,'Calc | Exit Fees'!O$218)","v":8.1594773848220523}]
[]
[]
[null,null,null,null,{"$f":"IF($D233=0,\"\",E$232)","v":"TOTAL WDV"},null,{"$f":"SUM(G234:G237)","v":72.909207819759345},{"$f":"SUM(H234:H237)","v":86.844563120380514},{"$f":"SUM(I234:I237)","v":114.42550876781361},{"$f":"SUM(J234:J237)","v":146.02624409065334},{"$f":"SUM(K234:K237)","v":181.15400234702912}]
[null,null,3,{"$f":"'Input | Exit Fees'!D31","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$29:$D$38,$D239))","v":85.346491479467673},{"$f":"IF($D239=0,0,SUMIFS('Calc | Exit Fees'!L$201:L$210,'Input | Exit Fees'!$D$29:$D$38,$D239))","v":102.28264339220466},{"$f":"IF($D239=0,0,SUMIFS('Calc | Exit Fees'!M$201:M$210,'Input | Exit Fees'!$D$29:$D$38,$D239))","v":136.6755961077192},{"$f":"IF($D239=0,0,SUMIFS('Calc | Exit Fees'!N$201:N$210,'Input | Exit Fees'!$D$29:$D$38,$D239))","v":178.64832244269175},{"$f":"IF($D239=0,0,SUMIFS('Calc | Exit Fees'!O$201:O$210,'Input | Exit Fees'!$D$29:$D$38,$D239))","v":226.16355177562752}]
[null,null,null,null,{"$f":"IF($D239=0,\"\",E$229)","v":"WDV - Comms & IT & Other"},null,{"$f":"IF($D239=0,0,'Calc | Exit Fees'!K$218)","v":7.6269126189432983},{"$f":"IF($D239=0,0,'Calc | Exit Fees'!L$218)","v":8.6076537395644763},{"$f":"IF($D239=0,0,'Calc | Exit Fees'!M$218)","v":9.881122031093815},{"$f":"IF($D239=0,0,'Calc | Exit Fees'!N$218)","v":9.3765433160162317},{"$f":"IF($D239=0,0,'Calc | Exit Fees'!O$218)","v":8.1594773848220523}]
[]
[]
[null,null,null,null,{"$f":"IF($D239=0,\"\",E$232)","v":"TOTAL WDV"},null,{"$f":"SUM(G240:G243)","v":92.973404098410967},{"$f":"SUM(H240:H243)","v":110.89029713176913},{"$f":"SUM(I240:I243)","v":146.55671813881301},{"$f":"SUM(J240:J243)","v":188.02486575870799},{"$f":"SUM(K240:K243)","v":234.32302916044958}]
[null,null,4,{"$f":"'Input | Exit Fees'!D32","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$29:$D$38,$D245))","v":124.96132163858269},{"$f":"IF($D245=0,0,SUMIFS('Calc | Exit Fees'!L$201:L$210,'Input | Exit Fees'!$D$29:$D$38,$D245))","v":149.75863772973761},{"$f":"IF($D245=0,0,SUMIFS('Calc | Exit Fees'!M$201:M$210,'Input | Exit Fees'!$D$29:$D$38,$D245))","v":200.11558564736734},{"$f":"IF($D245=0,0,SUMIFS('Calc | Exit Fees'!N$201:N$210,'Input | Exit Fees'!$D$29:$D$38,$D245))","v":261.57057066985681},{"$f":"IF($D245=0,0,SUMIFS('Calc | Exit Fees'!O$201:O$210,'Input | Exit Fees'!$D$29:$D$38,$D245))","v":331.14069303197465}]
[null,null,null,null,{"$f":"IF($D245=0,\"\",E$229)","v":"WDV - Comms & IT & Other"},null,{"$f":"IF($D245=0,0,'Calc | Exit Fees'!K$218)","v":7.6269126189432983},{"$f":"IF($D245=0,0,'Calc | Exit Fees'!L$218)","v":8.6076537395644763},{"$f":"IF($D245=0,0,'Calc | Exit Fees'!M$218)","v":9.881122031093815},{"$f":"IF($D245=0,0,'Calc | Exit Fees'!N$218)","v":9.3765433160162317},{"$f":"IF($D245=0,0,'Calc | Exit Fees'!O$218)","v":8.1594773848220523}]
[]
[]
[null,null,null,null,{"$f":"IF($D245=0,\"\",E$232)","v":"TOTAL WDV"},null,{"$f":"SUM(G246:G249)","v":132.58823425752598},{"$f":"SUM(H246:H249)","v":158.3662914693021},{"$f":"SUM(I246:I249)","v":209.99670767846115},{"$f":"SUM(J246:J249)","v":270.94711398587305},{"$f":"SUM(K246:K249)","v":339.30017041679667}]
[null,null,5,{"$f":"'Input | Exit Fees'!D33","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$29:$D$38,$D251))","v":0},{"$f":"IF($D251=0,0,SUMIFS('Calc | Exit Fees'!L$201:L$210,'Input | Exit Fees'!$D$29:$D$38,$D251))","v":0},{"$f":"IF($D251=0,0,SUMIFS('Calc | Exit Fees'!M$201:M$210,'Input | Exit Fees'!$D$29:$D$38,$D251))","v":0},{"$f":"IF($D251=0,0,SUMIFS('Calc | Exit Fees'!N$201:N$210,'Input | Exit Fees'!$D$29:$D$38,$D251))","v":0},{"$f":"IF($D251=0,0,SUMIFS('Calc | Exit Fees'!O$201:O$210,'Input | Exit Fees'!$D$29:$D$38,$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$119)","v":0},{"$f":"IF($D251=0,0,'Input | Exit Fees'!L$119)","v":0},{"$f":"IF($D251=0,0,'Input | Exit Fees'!M$119)","v":0},{"$f":"IF($D251=0,0,'Input | Exit Fees'!N$119)","v":0},{"$f":"IF($D251=0,0,'Input | Exit Fees'!O$119)","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'!D34","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$29:$D$38,$D257))","v":0},{"$f":"IF($D257=0,0,SUMIFS('Calc | Exit Fees'!L$201:L$210,'Input | Exit Fees'!$D$29:$D$38,$D257))","v":0},{"$f":"IF($D257=0,0,SUMIFS('Calc | Exit Fees'!M$201:M$210,'Input | Exit Fees'!$D$29:$D$38,$D257))","v":0},{"$f":"IF($D257=0,0,SUMIFS('Calc | Exit Fees'!N$201:N$210,'Input | Exit Fees'!$D$29:$D$38,$D257))","v":0},{"$f":"IF($D257=0,0,SUMIFS('Calc | Exit Fees'!O$201:O$210,'Input | Exit Fees'!$D$29:$D$38,$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$119)","v":0},{"$f":"IF($D257=0,0,'Input | Exit Fees'!L$119)","v":0},{"$f":"IF($D257=0,0,'Input | Exit Fees'!M$119)","v":0},{"$f":"IF($D257=0,0,'Input | Exit Fees'!N$119)","v":0},{"$f":"IF($D257=0,0,'Input | Exit Fees'!O$119)","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'!D35","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$29:$D$38,$D263))","v":0},{"$f":"IF($D263=0,0,SUMIFS('Calc | Exit Fees'!L$201:L$210,'Input | Exit Fees'!$D$29:$D$38,$D263))","v":0},{"$f":"IF($D263=0,0,SUMIFS('Calc | Exit Fees'!M$201:M$210,'Input | Exit Fees'!$D$29:$D$38,$D263))","v":0},{"$f":"IF($D263=0,0,SUMIFS('Calc | Exit Fees'!N$201:N$210,'Input | Exit Fees'!$D$29:$D$38,$D263))","v":0},{"$f":"IF($D263=0,0,SUMIFS('Calc | Exit Fees'!O$201:O$210,'Input | Exit Fees'!$D$29:$D$38,$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$119)","v":0},{"$f":"IF($D263=0,0,'Input | Exit Fees'!L$119)","v":0},{"$f":"IF($D263=0,0,'Input | Exit Fees'!M$119)","v":0},{"$f":"IF($D263=0,0,'Input | Exit Fees'!N$119)","v":0},{"$f":"IF($D263=0,0,'Input | Exit Fees'!O$119)","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'!D36","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$29:$D$38,$D269))","v":0},{"$f":"IF($D269=0,0,SUMIFS('Calc | Exit Fees'!L$201:L$210,'Input | Exit Fees'!$D$29:$D$38,$D269))","v":0},{"$f":"IF($D269=0,0,SUMIFS('Calc | Exit Fees'!M$201:M$210,'Input | Exit Fees'!$D$29:$D$38,$D269))","v":0},{"$f":"IF($D269=0,0,SUMIFS('Calc | Exit Fees'!N$201:N$210,'Input | Exit Fees'!$D$29:$D$38,$D269))","v":0},{"$f":"IF($D269=0,0,SUMIFS('Calc | Exit Fees'!O$201:O$210,'Input | Exit Fees'!$D$29:$D$38,$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$119)","v":0},{"$f":"IF($D269=0,0,'Input | Exit Fees'!L$119)","v":0},{"$f":"IF($D269=0,0,'Input | Exit Fees'!M$119)","v":0},{"$f":"IF($D269=0,0,'Input | Exit Fees'!N$119)","v":0},{"$f":"IF($D269=0,0,'Input | Exit Fees'!O$119)","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'!D37","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$29:$D$38,$D275))","v":0},{"$f":"IF($D275=0,0,SUMIFS('Calc | Exit Fees'!L$201:L$210,'Input | Exit Fees'!$D$29:$D$38,$D275))","v":0},{"$f":"IF($D275=0,0,SUMIFS('Calc | Exit Fees'!M$201:M$210,'Input | Exit Fees'!$D$29:$D$38,$D275))","v":0},{"$f":"IF($D275=0,0,SUMIFS('Calc | Exit Fees'!N$201:N$210,'Input | Exit Fees'!$D$29:$D$38,$D275))","v":0},{"$f":"IF($D275=0,0,SUMIFS('Calc | Exit Fees'!O$201:O$210,'Input | Exit Fees'!$D$29:$D$38,$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$119)","v":0},{"$f":"IF($D275=0,0,'Input | Exit Fees'!L$119)","v":0},{"$f":"IF($D275=0,0,'Input | Exit Fees'!M$119)","v":0},{"$f":"IF($D275=0,0,'Input | Exit Fees'!N$119)","v":0},{"$f":"IF($D275=0,0,'Input | Exit Fees'!O$119)","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'!D38","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$29:$D$38,$D281))","v":0},{"$f":"IF($D281=0,0,SUMIFS('Calc | Exit Fees'!L$201:L$210,'Input | Exit Fees'!$D$29:$D$38,$D281))","v":0},{"$f":"IF($D281=0,0,SUMIFS('Calc | Exit Fees'!M$201:M$210,'Input | Exit Fees'!$D$29:$D$38,$D281))","v":0},{"$f":"IF($D281=0,0,SUMIFS('Calc | Exit Fees'!N$201:N$210,'Input | Exit Fees'!$D$29:$D$38,$D281))","v":0},{"$f":"IF($D281=0,0,SUMIFS('Calc | Exit Fees'!O$201:O$210,'Input | Exit Fees'!$D$29:$D$38,$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$119)","v":0},{"$f":"IF($D281=0,0,'Input | Exit Fees'!L$119)","v":0},{"$f":"IF($D281=0,0,'Input | Exit Fees'!M$119)","v":0},{"$f":"IF($D281=0,0,'Input | Exit Fees'!N$119)","v":0},{"$f":"IF($D281=0,0,'Input | Exit Fees'!O$119)","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":6,"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"]
[]
[]
[null,"CALCULATION | Tax Allowance"]
[]
[null,null,null,null,null,"Base Year","Regulatory period"]
[null,null,null,null,null,null,"Tariff ($/year)"]
[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":97.374356435376015},{"$f":"+'Calc | Exit Fees'!H119","v":107.29935506264201},{"$f":"+'Calc | Exit Fees'!I119","v":130.90218448347608},{"$f":"+'Calc | Exit Fees'!J119","v":161.66357608367991},{"$f":"+'Calc | Exit Fees'!K119","v":196.15938403627649}]
[null,null,null,null,"Comms & IT & Other",null,{"$f":"+'Calc | Exit Fees'!G120","v":16.861068758802563},{"$f":"+'Calc | Exit Fees'!H120","v":17.658852376472069},{"$f":"+'Calc | Exit Fees'!I120","v":19.536561358464482},{"$f":"+'Calc | Exit Fees'!J120","v":20.67914197662197},{"$f":"+'Calc | Exit Fees'!K120","v":20.843605003631005}]
[null,null,null,null,"Admin cost",null,{"$f":"+'Calc | Exit Fees'!G121","v":58.785722930508697},{"$f":"+'Calc | Exit Fees'!H121","v":60.576707248343126},{"$f":"+'Calc | Exit Fees'!I121","v":62.498191576191175},{"$f":"+'Calc | Exit Fees'!J121","v":64.496919303493158},{"$f":"+'Calc | Exit Fees'!K121","v":66.526599984674206}]
[null,null,null,null,"Revenue for Tax Assessment Subtotal",null,{"$f":"SUM(G12:G14)","v":173.02114812468727},{"$f":"SUM(H12:H14)","v":185.53491468745722},{"$f":"SUM(I12:I14)","v":212.93693741813172},{"$f":"SUM(J12:J14)","v":246.83963736379502},{"$f":"SUM(K12:K14)","v":283.5295890245817}]
[]
[null,null,null,null,"Tax expenses"]
[null,null,null,null,"WDV - Meter TAB",null,{"$f":"+'Calc | Exit Fees'!G228","v":59.867982544698869},{"$f":"+'Calc | Exit Fees'!H228","v":71.748180892747328},{"$f":"+'Calc | Exit Fees'!I228","v":95.873797038648704},{"$f":"+'Calc | Exit Fees'!J228","v":125.31639513513967},{"$f":"+'Calc | Exit Fees'!K228","v":158.64689145666588}]
[null,null,null,null,"WDV - Comms & IT & Other TAB",null,{"$f":"+'Calc | Exit Fees'!G229","v":7.6269126189432983},{"$f":"+'Calc | Exit Fees'!H229","v":8.6076537395644763},{"$f":"+'Calc | Exit Fees'!I229","v":9.881122031093815},{"$f":"+'Calc | Exit Fees'!J229","v":9.3765433160162317},{"$f":"+'Calc | Exit Fees'!K229","v":8.1594773848220523}]
[null,null,null,null,"Admin cost",null,{"$f":"+'Calc | Exit Fees'!G121","v":58.785722930508697},{"$f":"+'Calc | Exit Fees'!H121","v":60.576707248343126},{"$f":"+'Calc | Exit Fees'!I121","v":62.498191576191175},{"$f":"+'Calc | Exit Fees'!J121","v":64.496919303493158},{"$f":"+'Calc | Exit Fees'!K121","v":66.526599984674206}]
[null,null,null,null,"Interest expense",null,0,0,0,0,0]
[null,null,null,null,"Tax expenses",null,{"$f":"SUM(G18:G21)","v":126.28061809415087},{"$f":"SUM(H18:H21)","v":140.93254188065492},{"$f":"SUM(I18:I21)","v":168.2531106459337},{"$f":"SUM(J18:J21)","v":199.18985775464904},{"$f":"SUM(K18:K21)","v":233.33296882616213}]
[]
[null,null,null,null,"Corporate tax rate",null,{"$f":"+'Inputs | General'!H$42","v":0.3},{"$f":"+'Inputs | General'!I$42","v":0.3},{"$f":"+'Inputs | General'!J$42","v":0.3},{"$f":"+'Inputs | General'!K$42","v":0.3},{"$f":"+'Inputs | General'!L$42","v":0.3}]
[null,null,null,null,"Imputation credits rate",null,{"$f":"+'Inputs | General'!H$41","v":0.56999999999999995},{"$f":"+'Inputs | General'!I$41","v":0.56999999999999995},{"$f":"+'Inputs | General'!J$41","v":0.56999999999999995},{"$f":"+'Inputs | General'!K$41","v":0.56999999999999995},{"$f":"+'Inputs | General'!L$41","v":0.56999999999999995}]
[null,null,null,null,"Taxable income",null,{"$f":"+G15-G22","v":46.740530030536405},{"$f":"+H15-H22","v":44.602372806802293},{"$f":"+I15-I22","v":44.683826772198017},{"$f":"+J15-J22","v":47.64977960914598},{"$f":"+K15-K22","v":50.196620198419566}]
[null,null,null,null,"Tax payable",null,{"$f":"+G26*G24/(1-G24*(1-G25))","v":16.098919643123907},{"$f":"+H26*H24/(1-H24*(1-H25))","v":15.362470541952568},{"$f":"+I26*I24/(1-I24*(1-I25))","v":15.39052586872492},{"$f":"+J26*J24/(1-J24*(1-J25))","v":16.4120940100388},{"$f":"+K26*K24/(1-K24*(1-K25))","v":17.289306612544053}]
[null,null,null,null,"Imputation credits",null,{"$f":"+G27*G25","v":9.1763841965806261},{"$f":"+H27*H25","v":8.7566082089129633},{"$f":"+I27*I25","v":8.7725997451732027},{"$f":"+J27*J25","v":9.3548935857221149},{"$f":"+K27*K25","v":9.8549047691501084}]
[null,null,null,null,"Tax allowance",null,{"$f":"+G27-G28","v":6.9225354465432805},{"$f":"+H27-H28","v":6.6058623330396049},{"$f":"+I27-I28","v":6.6179261235517171},{"$f":"+J27-J28","v":7.0572004243166848},{"$f":"+K27-K28","v":7.4344018433939443}]
[]
[null,null,null,{"$f":"'Input | Exit Fees'!D30","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":106.18065302363487},{"$f":"+'Calc | Exit Fees'!H125","v":117.00324404328572},{"$f":"+'Calc | Exit Fees'!I125","v":142.74065513234262},{"$f":"+'Calc | Exit Fees'!J125","v":176.28403110518519},{"$f":"+'Calc | Exit Fees'!K125","v":213.89955483309254}]
[null,null,null,null,"Comms & IT & Other",null,{"$f":"+'Calc | Exit Fees'!G126","v":16.861068758802563},{"$f":"+'Calc | Exit Fees'!H126","v":17.658852376472069},{"$f":"+'Calc | Exit Fees'!I126","v":19.536561358464482},{"$f":"+'Calc | Exit Fees'!J126","v":20.67914197662197},{"$f":"+'Calc | Exit Fees'!K126","v":20.843605003631005}]
[null,null,null,null,"Admin cost",null,{"$f":"+'Calc | Exit Fees'!G127","v":58.785722930508697},{"$f":"+'Calc | Exit Fees'!H127","v":60.576707248343126},{"$f":"+'Calc | Exit Fees'!I127","v":62.498191576191175},{"$f":"+'Calc | Exit Fees'!J127","v":64.496919303493158},{"$f":"+'Calc | Exit Fees'!K127","v":66.526599984674206}]
[null,null,null,null,"Revenue for Tax Assessment Subtotal",null,{"$f":"SUM(G33:G35)","v":181.82744471294615},{"$f":"SUM(H33:H35)","v":195.23880366810093},{"$f":"SUM(I33:I35)","v":224.7754080669983},{"$f":"SUM(J33:J35)","v":261.4600923853003},{"$f":"SUM(K33:K35)","v":301.26975982139777}]
[]
[null,null,null,null,"Tax expenses"]
[null,null,null,null,"Meter TAB",null,{"$f":"+'Calc | Exit Fees'!G234","v":65.282295200816051},{"$f":"+'Calc | Exit Fees'!H234","v":78.236909380816044},{"$f":"+'Calc | Exit Fees'!I234","v":104.5443867367198},{"$f":"+'Calc | Exit Fees'!J234","v":136.6497007746371},{"$f":"+'Calc | Exit Fees'!K234","v":172.99452496220707}]
[null,null,null,null,"Comms & IT & Other TAB",null,{"$f":"+'Calc | Exit Fees'!G235","v":7.6269126189432983},{"$f":"+'Calc | Exit Fees'!H235","v":8.6076537395644763},{"$f":"+'Calc | Exit Fees'!I235","v":9.881122031093815},{"$f":"+'Calc | Exit Fees'!J235","v":9.3765433160162317},{"$f":"+'Calc | Exit Fees'!K235","v":8.1594773848220523}]
[null,null,null,null,"Admin cost",null,{"$f":"+'Calc | Exit Fees'!G127","v":58.785722930508697},{"$f":"+'Calc | Exit Fees'!H127","v":60.576707248343126},{"$f":"+'Calc | Exit Fees'!I127","v":62.498191576191175},{"$f":"+'Calc | Exit Fees'!J127","v":64.496919303493158},{"$f":"+'Calc | Exit Fees'!K127","v":66.526599984674206}]
[null,null,null,null,"Interest expense",null,0,0,0,0,0]
[null,null,null,null,"Tax expenses",null,{"$f":"SUM(G39:G42)","v":131.69493075026804},{"$f":"SUM(H39:H42)","v":147.42127036872364},{"$f":"SUM(I39:I42)","v":176.92370034400477},{"$f":"SUM(J39:J42)","v":210.52316339414648},{"$f":"SUM(K39:K42)","v":247.68060233170331}]
[]
[null,null,null,null,"Corporate tax rate",null,{"$f":"+'Inputs | General'!H$42","v":0.3},{"$f":"+'Inputs | General'!I$42","v":0.3},{"$f":"+'Inputs | General'!J$42","v":0.3},{"$f":"+'Inputs | General'!K$42","v":0.3},{"$f":"+'Inputs | General'!L$42","v":0.3}]
[null,null,null,null,"Imputation credits rate",null,{"$f":"+'Inputs | General'!H$41","v":0.56999999999999995},{"$f":"+'Inputs | General'!I$41","v":0.56999999999999995},{"$f":"+'Inputs | General'!J$41","v":0.56999999999999995},{"$f":"+'Inputs | General'!K$41","v":0.56999999999999995},{"$f":"+'Inputs | General'!L$41","v":0.56999999999999995}]
[null,null,null,null,"Taxable income",null,{"$f":"+G36-G43","v":50.132513962678104},{"$f":"+H36-H43","v":47.817533299377288},{"$f":"+I36-I43","v":47.851707722993524},{"$f":"+J36-J43","v":50.93692899115382},{"$f":"+K36-K43","v":53.589157489694458}]
[null,null,null,null,"Tax payable",null,{"$f":"+G47*G45/(1-G45*(1-G46))","v":17.267226393574546},{"$f":"+H47*H45/(1-H45*(1-H46))","v":16.469873696685632},{"$f":"+I47*I45/(1-I45*(1-I46))","v":16.481644451088471},{"$f":"+J47*J45/(1-J45*(1-J46))","v":17.544292419455967},{"$f":"+K47*K45/(1-K45*(1-K46))","v":18.457803957414853}]
[null,null,null,null,"Imputation credits",null,{"$f":"+G48*G46","v":9.8423190443374899},{"$f":"+H48*H46","v":9.3878280071108087},{"$f":"+I48*I46","v":9.3945373371204273},{"$f":"+J48*J46","v":10.0002466790899},{"$f":"+K48*K46","v":10.520948255726465}]
[null,null,null,null,"Tax allowance",null,{"$f":"+G48-G49","v":7.4249073492370563},{"$f":"+H48-H49","v":7.0820456895748229},{"$f":"+I48-I49","v":7.0871071139680435},{"$f":"+J48-J49","v":7.5440457403660677},{"$f":"+K48-K49","v":7.9368557016883887}]
[]
[null,null,null,{"$f":"'Input | Exit Fees'!D31","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":138.81476088868712},{"$f":"+'Calc | Exit Fees'!H131","v":152.96362268043447},{"$f":"+'Calc | Exit Fees'!I131","v":186.61130203145541},{"$f":"+'Calc | Exit Fees'!J131","v":230.46407165072887},{"$f":"+'Calc | Exit Fees'!K131","v":279.64054385447315}]
[null,null,null,null,"Comms & IT & Other",null,{"$f":"+'Calc | Exit Fees'!G132","v":16.861068758802563},{"$f":"+'Calc | Exit Fees'!H132","v":17.658852376472069},{"$f":"+'Calc | Exit Fees'!I132","v":19.536561358464482},{"$f":"+'Calc | Exit Fees'!J132","v":20.67914197662197},{"$f":"+'Calc | Exit Fees'!K132","v":20.843605003631005}]
[null,null,null,null,"Admin cost",null,{"$f":"+'Calc | Exit Fees'!G133","v":58.785722930508697},{"$f":"+'Calc | Exit Fees'!H133","v":60.576707248343126},{"$f":"+'Calc | Exit Fees'!I133","v":62.498191576191175},{"$f":"+'Calc | Exit Fees'!J133","v":64.496919303493158},{"$f":"+'Calc | Exit Fees'!K133","v":66.526599984674206}]
[null,null,null,null,"Revenue for Tax Assessment Subtotal",null,{"$f":"SUM(G54:G56)","v":214.46155257799836},{"$f":"SUM(H54:H56)","v":231.19918230524965},{"$f":"SUM(I54:I56)","v":268.64605496611108},{"$f":"SUM(J54:J56)","v":315.640132930844},{"$f":"SUM(K54:K56)","v":367.01074884277836}]
[]
[null,null,null,null,"Tax expenses"]
[null,null,null,null,"Meter TAB",null,{"$f":"+'Calc | Exit Fees'!G240","v":85.346491479467673},{"$f":"+'Calc | Exit Fees'!H240","v":102.28264339220466},{"$f":"+'Calc | Exit Fees'!I240","v":136.6755961077192},{"$f":"+'Calc | Exit Fees'!J240","v":178.64832244269175},{"$f":"+'Calc | Exit Fees'!K240","v":226.16355177562752}]
[null,null,null,null,"Comms & IT & Other TAB",null,{"$f":"+'Calc | Exit Fees'!G241","v":7.6269126189432983},{"$f":"+'Calc | Exit Fees'!H241","v":8.6076537395644763},{"$f":"+'Calc | Exit Fees'!I241","v":9.881122031093815},{"$f":"+'Calc | Exit Fees'!J241","v":9.3765433160162317},{"$f":"+'Calc | Exit Fees'!K241","v":8.1594773848220523}]
[null,null,null,null,"Admin cost",null,{"$f":"+'Calc | Exit Fees'!G133","v":58.785722930508697},{"$f":"+'Calc | Exit Fees'!H133","v":60.576707248343126},{"$f":"+'Calc | Exit Fees'!I133","v":62.498191576191175},{"$f":"+'Calc | Exit Fees'!J133","v":64.496919303493158},{"$f":"+'Calc | Exit Fees'!K133","v":66.526599984674206}]
[null,null,null,null,"Interest expense",null,0,0,0,0,0]
[null,null,null,null,"Tax expenses",null,{"$f":"SUM(G60:G63)","v":151.75912702891966},{"$f":"SUM(H60:H63)","v":171.46700438011226},{"$f":"SUM(I60:I63)","v":209.05490971500419},{"$f":"SUM(J60:J63)","v":252.52178506220116},{"$f":"SUM(K60:K63)","v":300.8496291451238}]
[]
[null,null,null,null,"Corporate tax rate",null,{"$f":"+'Inputs | General'!H$42","v":0.3},{"$f":"+'Inputs | General'!I$42","v":0.3},{"$f":"+'Inputs | General'!J$42","v":0.3},{"$f":"+'Inputs | General'!K$42","v":0.3},{"$f":"+'Inputs | General'!L$42","v":0.3}]
[null,null,null,null,"Imputation credits rate",null,{"$f":"+'Inputs | General'!H$41","v":0.56999999999999995},{"$f":"+'Inputs | General'!I$41","v":0.56999999999999995},{"$f":"+'Inputs | General'!J$41","v":0.56999999999999995},{"$f":"+'Inputs | General'!K$41","v":0.56999999999999995},{"$f":"+'Inputs | General'!L$41","v":0.56999999999999995}]
[null,null,null,null,"Taxable income",null,{"$f":"+G57-G64","v":62.702425549078697},{"$f":"+H57-H64","v":59.732177925137393},{"$f":"+I57-I64","v":59.591145251106894},{"$f":"+J57-J64","v":63.118347868642843},{"$f":"+K57-K64","v":66.161119697654556}]
[null,null,null,null,"Tax payable",null,{"$f":"+G68*G66/(1-G66*(1-G67))","v":21.596702255710227},{"$f":"+H68*H66/(1-H66*(1-H67))","v":20.573654853663854},{"$f":"+I68*I66/(1-I66*(1-I67))","v":20.52507873172453},{"$f":"+J68*J66/(1-J66*(1-J67))","v":21.739959082196155},{"$f":"+K68*K66/(1-K66*(1-K67))","v":22.787986118595139}]
[null,null,null,null,"Imputation credits",null,{"$f":"+G69*G67","v":12.310120285754829},{"$f":"+H69*H67","v":11.726983266588396},{"$f":"+I69*I67","v":11.699294877082981},{"$f":"+J69*J67","v":12.391776676851807},{"$f":"+K69*K67","v":12.989152087599228}]
[null,null,null,null,"Tax allowance",null,{"$f":"+G69-G70","v":9.2865819699553978},{"$f":"+H69-H70","v":8.8466715870754573},{"$f":"+I69-I70","v":8.8257838546415499},{"$f":"+J69-J70","v":9.3481824053443479},{"$f":"+K69-K70","v":9.798834030995911}]
[]
[null,null,null,{"$f":"'Input | Exit Fees'!D32","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":203.2476752458808},{"$f":"+'Calc | Exit Fees'!H137","v":223.96393948275036},{"$f":"+'Calc | Exit Fees'!I137","v":273.22968443474258},{"$f":"+'Calc | Exit Fees'!J137","v":337.43736250262225},{"$f":"+'Calc | Exit Fees'!K137","v":409.43981806438705}]
[null,null,null,null,"Comms & IT & Other",null,{"$f":"+'Calc | Exit Fees'!G138","v":16.861068758802563},{"$f":"+'Calc | Exit Fees'!H138","v":17.658852376472069},{"$f":"+'Calc | Exit Fees'!I138","v":19.536561358464482},{"$f":"+'Calc | Exit Fees'!J138","v":20.67914197662197},{"$f":"+'Calc | Exit Fees'!K138","v":20.843605003631005}]
[null,null,null,null,"Admin cost",null,{"$f":"+'Calc | Exit Fees'!G139","v":58.785722930508697},{"$f":"+'Calc | Exit Fees'!H139","v":60.576707248343126},{"$f":"+'Calc | Exit Fees'!I139","v":62.498191576191175},{"$f":"+'Calc | Exit Fees'!J139","v":64.496919303493158},{"$f":"+'Calc | Exit Fees'!K139","v":66.526599984674206}]
[null,null,null,null,"Revenue for Tax Assessment Subtotal",null,{"$f":"SUM(G75:G77)","v":278.89446693519204},{"$f":"SUM(H75:H77)","v":302.19949910756554},{"$f":"SUM(I75:I77)","v":355.26443736939825},{"$f":"SUM(J75:J77)","v":422.61342378273736},{"$f":"SUM(K75:K77)","v":496.81002305269226}]
[]
[null,null,null,null,"Tax expenses"]
[null,null,null,null,"Meter TAB",null,{"$f":"+'Calc | Exit Fees'!G246","v":124.96132163858269},{"$f":"+'Calc | Exit Fees'!H246","v":149.75863772973761},{"$f":"+'Calc | Exit Fees'!I246","v":200.11558564736734},{"$f":"+'Calc | Exit Fees'!J246","v":261.57057066985681},{"$f":"+'Calc | Exit Fees'!K246","v":331.14069303197465}]
[null,null,null,null,"Comms & IT & Other TAB",null,{"$f":"+'Calc | Exit Fees'!G247","v":7.6269126189432983},{"$f":"+'Calc | Exit Fees'!H247","v":8.6076537395644763},{"$f":"+'Calc | Exit Fees'!I247","v":9.881122031093815},{"$f":"+'Calc | Exit Fees'!J247","v":9.3765433160162317},{"$f":"+'Calc | Exit Fees'!K247","v":8.1594773848220523}]
[null,null,null,null,"Admin cost",null,{"$f":"+'Calc | Exit Fees'!G139","v":58.785722930508697},{"$f":"+'Calc | Exit Fees'!H139","v":60.576707248343126},{"$f":"+'Calc | Exit Fees'!I139","v":62.498191576191175},{"$f":"+'Calc | Exit Fees'!J139","v":64.496919303493158},{"$f":"+'Calc | Exit Fees'!K139","v":66.526599984674206}]
[null,null,null,null,"Interest expense",null,0,0,0,0,0]
[null,null,null,null,"Tax expenses",null,{"$f":"SUM(G81:G84)","v":191.37395718803469},{"$f":"SUM(H81:H84)","v":218.94299871764522},{"$f":"SUM(I81:I84)","v":272.4948992546523},{"$f":"SUM(J81:J84)","v":335.44403328936619},{"$f":"SUM(K81:K84)","v":405.82677040147087}]
[]
[null,null,null,null,"Corporate tax rate",null,{"$f":"+'Inputs | General'!H$42","v":0.3},{"$f":"+'Inputs | General'!I$42","v":0.3},{"$f":"+'Inputs | General'!J$42","v":0.3},{"$f":"+'Inputs | General'!K$42","v":0.3},{"$f":"+'Inputs | General'!L$42","v":0.3}]
[null,null,null,null,"Imputation credits rate",null,{"$f":"+'Inputs | General'!H$41","v":0.56999999999999995},{"$f":"+'Inputs | General'!I$41","v":0.56999999999999995},{"$f":"+'Inputs | General'!J$41","v":0.56999999999999995},{"$f":"+'Inputs | General'!K$41","v":0.56999999999999995},{"$f":"+'Inputs | General'!L$41","v":0.56999999999999995}]
[null,null,null,null,"Taxable income",null,{"$f":"+G78-G85","v":87.520509747157348},{"$f":"+H78-H85","v":83.256500389920319},{"$f":"+I78-I85","v":82.769538114745956},{"$f":"+J78-J85","v":87.169390493371168},{"$f":"+K78-K85","v":90.983252651221392}]
[null,null,null,null,"Tax payable",null,{"$f":"+G89*G87/(1-G87*(1-G88))","v":30.144836881914127},{"$f":"+H89*H87/(1-H87*(1-H88))","v":28.676176942567274},{"$f":"+I89*I87/(1-I87*(1-I88))","v":28.508451704275299},{"$f":"+J89*J87/(1-J87*(1-J88))","v":30.023900284743224},{"$f":"+K89*K87/(1-K87*(1-K88))","v":31.337515264484978}]
[null,null,null,null,"Imputation credits",null,{"$f":"+G90*G88","v":17.18255702269105},{"$f":"+H90*H88","v":16.345420857263345},{"$f":"+I90*I88","v":16.24981747143692},{"$f":"+J90*J88","v":17.113623162303636},{"$f":"+K90*K88","v":17.862383700756435}]
[null,null,null,null,"Tax allowance",null,{"$f":"+G90-G91","v":12.962279859223077},{"$f":"+H90-H91","v":12.330756085303928},{"$f":"+I90-I91","v":12.258634232838379},{"$f":"+J90-J91","v":12.910277122439588},{"$f":"+K90-K91","v":13.475131563728542}]

{"sheet":"Output | Exit Fee price caps","index":7,"n_rows":62,"n_cols":14,"rows_kept":62,"cut":false,"hidden":false,"merged":[[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],[17,3,17,4],[60,3,60,4],[14,3,14,4],[47,3,47,4],[27,3,27,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],[59,8,59,12],[49,3,49,4],[50,3,50,4],[51,3,51,4],[52,3,52,4],[53,3,53,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":179.94},{"$f":"IF(J25=0,0,ROUND(I9*(1-J45)*(1+J$41),2))","v":192.14},219.55,253.89,290.95999999999998]
[null,null,null,{"$f":"D26","v":"Single Phase, Two Element"},null,"$dollars","nominal",191.64,189.25,202.32,231.86,269,309.2]
[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":223.75},{"$f":"IF(J27=0,0,ROUND(I11*(1-J47)*(1+J$41),2))","v":240.05},{"$f":"IF(K27=0,0,ROUND(J11*(1-K47)*(1+K$41),2))","v":277.48},{"$f":"IF(L27=0,0,ROUND(K11*(1-L47)*(1+L$41),2))","v":325},{"$f":"IF(M27=0,0,ROUND(L11*(1-M47)*(1+M$41),2))","v":376.82}]
[null,null,null,"Three Phase CT",null,"$dollars","nominal",191.64,291.86,314.52999999999997,367.52,435.52,510.28]
[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'!$D29","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":179.94368357123057},{"$f":"INDEX(Table3[2027-28],MATCH('Output | Exit Fee price caps'!$D25,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":192.14077702049681},{"$f":"INDEX(Table3[2028-29],MATCH('Output | Exit Fee price caps'!$D25,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":219.55486354168343},{"$f":"INDEX(Table3[2029-30],MATCH('Output | Exit Fee price caps'!$D25,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":253.8968377881117},{"$f":"INDEX(Table3[2030-31],MATCH('Output | Exit Fee price caps'!$D25,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":290.96399086797567}]
[null,null,null,{"$f":"'Input | Exit Fees'!$D30","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":189.25235206218321},{"$f":"INDEX(Table3[2027-28],MATCH('Output | Exit Fee price caps'!$D26,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":202.32084935767574},{"$f":"INDEX(Table3[2028-29],MATCH('Output | Exit Fee price caps'!$D26,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":231.86251518096634},{"$f":"INDEX(Table3[2029-30],MATCH('Output | Exit Fee price caps'!$D26,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":269.00413812566637},{"$f":"INDEX(Table3[2030-31],MATCH('Output | Exit Fee price caps'!$D26,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":309.20661552308616}]
[null,null,null,{"$f":"'Input | Exit Fees'!$D31","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":223.74813454795375},{"$f":"INDEX(Table3[2027-28],MATCH('Output | Exit Fee price caps'!$D27,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":240.04585389232511},{"$f":"INDEX(Table3[2028-29],MATCH('Output | Exit Fee price caps'!$D27,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":277.47183882075262},{"$f":"INDEX(Table3[2029-30],MATCH('Output | Exit Fee price caps'!$D27,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":324.98831533618835},{"$f":"INDEX(Table3[2030-31],MATCH('Output | Exit Fee price caps'!$D27,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":376.80958287377427}]
[null,null,null,{"$f":"'Input | Exit Fees'!$D32","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":291.85674679441513},{"$f":"INDEX(Table3[2027-28],MATCH('Output | Exit Fee price caps'!$D28,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":314.53025519286945},{"$f":"INDEX(Table3[2028-29],MATCH('Output | Exit Fee price caps'!$D28,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":367.52307160223666},{"$f":"INDEX(Table3[2029-30],MATCH('Output | Exit Fee price caps'!$D28,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":435.52370090517695},{"$f":"INDEX(Table3[2030-31],MATCH('Output | Exit Fee price caps'!$D28,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":510.28515461642081}]
[null,null,null,{"$f":"'Input | Exit Fees'!$D33","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'!$D34","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'!$D35","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'!$D36","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'!$D37","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'!$D38","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'!H26","v":2.5499939054115517E-2},{"$f":"'Inputs | General'!I26","v":2.5499939054115517E-2},{"$f":"'Inputs | General'!J26","v":2.5499939054115517E-2},{"$f":"'Inputs | General'!K26","v":2.5499939054115517E-2},{"$f":"'Inputs | General'!L26","v":2.5499939054115517E-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'!$D29","v":"Single Phase (inc. DC)"},null,"%",null,null,{"$f":"IFERROR(-1*(((I25/H25)/(1+I$41)-1)),\"\")","v":8.4380980339691325E-2},-4.1231497693165142E-2,-0.11426343808174311,-0.12766107882680555,-0.11749686665834713]
[null,null,null,{"$f":"'Input | Exit Fees'!$D30","v":"Single Phase, Two Element"},null,"%",null,null,3.7015083694283635E-2,-4.2470358058289248E-2,-0.11751732359457612,-0.13133905402495794,-0.12086724341003996]
[null,null,null,{"$f":"'Input | Exit Fees'!$D31","v":"Three Phase (inc. DC)"},null,"%",null,null,-0.13851202520550498,-4.6162496514309925E-2,-0.12716907302102487,-0.14212383631833037,-0.13062492028534578]
[null,null,null,{"$f":"'Input | Exit Fees'!$D32","v":"Three Phase CT"},null,"%",null,null,-0.48507345785975708,-5.088949603075088E-2,-0.13942709177161539,-0.15555746526696823,-0.14252444539851483]
[null,null,null,{"$f":"'Input | Exit Fees'!$D33","v":0},null,"%",null,null,"","","","",""]
[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,"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.64},{"$f":"SUMPRODUCT(I$25:I$34,'Calc | Exit Fees'!K$31:K$40)/'Calc | Exit Fees'!K$41","v":188.82569738009195},{"$f":"SUMPRODUCT(J$25:J$34,'Calc | Exit Fees'!L$31:L$40)/'Calc | Exit Fees'!L$41","v":202.82562867830444},{"$f":"SUMPRODUCT(K$25:K$34,'Calc | Exit Fees'!M$31:M$40)/'Calc | Exit Fees'!M$41","v":233.54092734702053},{"$f":"SUMPRODUCT(L$25:L$34,'Calc | Exit Fees'!N$31:N$40)/'Calc | Exit Fees'!N$41","v":272.35501541891466},{"$f":"SUMPRODUCT(M$25:M$34,'Calc | Exit Fees'!O$31:O$40)/'Calc | Exit Fees'!O$41","v":314.78667051835168}]

{"sheet":"LUTs and Dropdowns","index":8,"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"]