{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Title Page","AER Changelog","Inputs | General","Price Cap >","Inputs | Price Cap","Calc | Price Cap","Output | Price Caps","Exit Fees >","Input | Exit Fees","Calc | Exit Fees","Output | Exit Fee price caps","LUTs and Dropdowns"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"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,"Final 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":"AER Changelog","index":1,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Worksheet","Cells","Description of change"]
[null,"Throughout workbook",null,"Added cost basis labelling"]
[null,"Inputs | General","C28:N29","Added historical inflation for escalation of inputs"]
[null,"Inputs | General","C30:N30","Added labour cost escalators"]
[null,"Inputs | Exit Fees","C9:N21","Updated inputs from RAB to reflect use of net capex, use of real regulatory depreciation and escalation to nominal, and closing balance to better represent data."]
[null,"Inputs | Exit Fees","G31:G35","Updated 2025–26 meter exit fees"]
[null,"Inputs | Exit Fees","J51:J65","Updated cost basis"]
[null,"Inputs | Exit Fees","L52:L53","Updated meter labour costs"]
[null,"Inputs | Exit Fees","F93:G93","Updated administration hourly rate to be the draft decision ANS 2026-31 price"]
[null,"Calc | Exit Fees","K46:O55","Added CPI and labour escalations to calculations"]
[null,"Calc | Exit Fees","K77:O88","Updated calculation to consistently refer to closing balances"]
[null,"Calc | Exit Fees","K109:O109","Updated calculations to refer to closing balances"]
[null,"Calc | Exit Fees","F117:K117","Updated year labelling"]
[null,"Calc | Exit Fees","G121:K139","Added escalation of admin costs"]

{"sheet":"Inputs | General","index":2,"n_rows":31,"n_cols":23,"rows_kept":31,"cut":false,"hidden":false,"merged":[[4,1,4,6],[1,10,1,11],[1,12,1,13],[20,1,20,6],[23,9,23,13]]}
[null,{"$f":"'Title Page'!B8&\" v\"&'Title Page'!$C$10","v":"Final 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$50)=COUNTIF($X14:$X51,\"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,"Draft Decision","Revised proposal"]
[]
[]
[null,"1. Inputs - General"]
[]
[null,null,"Inputs","Source","Input Format",null,"Value"]
[null,null,"NSP name","NSP",null,null,"AusNet"]
[null,null,"Decision stage","NSP",null,null,"revised proposal"]
[]
[null,null,"Forecast regulatory control period, first year","NSP","YYYY-YY",null,"2026-27"]
[null,null,"Forecast regulatory control period, last year","NSP",null,null,{"$f":"LEFT(FPFirstYear,4)+4&\"-\"&RIGHT(FPFirstYear,2)+4","v":"2030-31"}]
[]
[null,null,"Regulatory Period Length, Yrs",null,null,null,{"$f":"LEFT(G12,4)-LEFT(FPFirstYear,4)+1","v":5}]
[]
[null,null,"Model Used For (Price Cap or Vic Exit Fees?)",null,null,null,"Exit Fees (Vic)"]
[]
[]
[]
[]
[null,{"$f":"LEFT('Inputs | General'!B5,1)+1&\". Linked Inputs - Inflation\"","v":"2. Linked Inputs - Inflation"}]
[]
[]
[null,null,null,null,null,null,null,null,"Base year","Regulatory period"]
[null,null,"Year",null,"Units",null,"2023-24","2024-25",{"$f":"LEFT(J25,4)-1&\"-\"&RIGHT(J25,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(J25,4)+1&\"-\"&RIGHT(J25,2)+1","v":"2027-28"},{"$f":"LEFT(K25,4)+1&\"-\"&RIGHT(K25,2)+1","v":"2028-29"},"2029-30","2030-31"]
[null,null,"Inflation Assumption (CPI % increase)",null,"%",null,null,null,null,2.5999756335213231E-2,2.5999756335213231E-2,2.5999756335213231E-2,2.5999756335213231E-2,2.5999756335213231E-2]
[null,null,"Cumulative Inflation Index (CPI end period)",null,"Index",null,null,null,1,{"$f":"I27*(1+J26)","v":1.0259997563352132},{"$f":"J27*(1+K26)","v":1.0526754999999168},{"$f":"K27*(1+L26)","v":1.0800448064999635},{"$f":"L27*(1+M26)","v":1.1081257083000751},{"$f":"M27*(1+N26)","v":1.1369367067046625}]
[null,null,"Historical inflation",null,null,null,null,2.4246877296105973E-2,3.3000000000000002E-2,{"$f":"J26","v":2.5999756335213231E-2},{"$f":"K26","v":2.5999756335213231E-2},{"$f":"L26","v":2.5999756335213231E-2},2.5999756335213231E-2,2.5999756335213231E-2]
[null,null,"Cumulative Inflation index $2023–24 to nominal",null,null,null,1,{"$f":"G29*(1+H28)","v":1.024246877296106},{"$f":"H29*(1+I28)","v":1.0580470242468774},1.0855559890684936,1.1137801802725058,1.1427381935705809,1.1724491081583577,1.2029324992859129]
[null,null,"Labour escalator",null,null,null,null,{"$f":"'[2]Input| Prices'!K$43","v":1.4480382636025184E-2},{"$f":"'[2]Input| Prices'!L$43","v":1.2873294561071939E-2},{"$f":"'[2]Input| Prices'!M$43","v":8.1208180725738949E-3},{"$f":"'[2]Input| Prices'!N$43","v":9.5505821675600702E-3},{"$f":"'[2]Input| Prices'!O$43","v":1.1199334904118834E-2},{"$f":"'[2]Input| Prices'!P$43","v":1.2274361918209275E-2},{"$f":"'[2]Input| Prices'!Q$43","v":1.2025416152939063E-2}]
[null,null,"Cumulative labour escalation",null,null,null,1,{"$f":"G31*(1+H30)","v":1.0144803826360251},{"$f":"H31*(1+I30)","v":1.0275400874281275},1.035884553540408,1.0457778540851019,1.0574898705083118,1.0704698839037712,1.0833427297369025]

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

{"sheet":"Inputs | Price Cap","index":4,"n_rows":125,"n_cols":22,"rows_kept":125,"cut":false,"hidden":false,"merged":[[94,1,94,7],[1,10,1,11],[40,9,40,13],[38,1,38,7],[6,7,6,11],[4,1,4,6],[14,1,14,6],[4,9,4,11],[14,9,14,11],[38,9,38,11]]}
[null,{"$f":"'Title Page'!B8&\" v\"&'Title Page'!$C$10","v":"Final Standardised Metering Pricing Model  v1.02"},null,null,null,null,null,null,null,null,null,null,null,"DNSP:",{"$f":"IF('Inputs | General'!$G$16=\"Exit Fees (Vic)\",\"NOT USED\",NSP)","v":"NOT USED"},null,null,null,null,null,"Worksheet check:",{"$f":"IF(COUNTA($W$4:$W$71)=COUNTIF($W4:$W72,\"OK\"),\"OK\",\"Check\")","v":"OK"}]
[null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"Inputs | Price Cap"},null,null,null,null,null,"Key:","Input","External Link","Internal Link"]
[]
[]
[null,{"$f":"LEFT('Inputs | General'!B21,1)+1&\". Linked Input -  Inflation & Discount Rates\"","v":"3. Linked Input -  Inflation & Discount Rates"},null,null,null,null,null,null,null,{"$f":"IF('Inputs | General'!$G$16=\"Exit Fees (Vic)\",\"NOT USED\",\"\")","v":"NOT USED"}]
[]
[null,"Linked Inputs - Discount Rates",null,null,null,null,"Base year","Regulatory period"]
[null,null,"Year",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"},"2029-30","2030-31",null,"Link from PTRM"]
[null,null,"Nominal Vanilla WACC",null,"%",null,null,0.05,0.05,0.05,0.05,0.05]
[null,null,"Cumulative Discount Index",null,"Index",null,1,{"$f":"G10*(1+H9)","v":1.05},{"$f":"H10*(1+I9)","v":1.1025},{"$f":"I10*(1+J9)","v":1.1576250000000001},{"$f":"J10*(1+K9)","v":1.2155062500000002},{"$f":"K10*(1+L9)","v":1.2762815625000004}]
[]
[]
[]
[]
[null,{"$f":"LEFT(B5,1)+1&\". Linked Input - Building Block Revenue Requirements\"","v":"4. Linked Input - Building Block Revenue Requirements"},null,null,null,null,null,null,null,{"$f":"IF('Inputs | General'!$G$16=\"Exit Fees (Vic)\",\"NOT USED\",\"\")","v":"NOT USED"}]
[]
[null,"Linked Inputs - Unsmoothed revenue requirement"]
[]
[null,null,null,null,"Units",null,null,{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(H19,4)+1&\"-\"&RIGHT(H19,2)+1","v":"2027-28"},{"$f":"LEFT(I19,4)+1&\"-\"&RIGHT(I19,2)+1","v":"2028-29"},"2029-30","2030-31",null,"Link from PTRM"]
[null,null,"Return on Capital",null,"$m",null,null,{"$f":"'[1]Revenue summary'!G7","v":0},{"$f":"'[1]Revenue summary'!H7","v":-1.7874790769239608},{"$f":"'[1]Revenue summary'!I7","v":-1.8138575637259298},{"$f":"'[1]Revenue summary'!J7","v":-0.41230654256688148},{"$f":"'[1]Revenue summary'!K7","v":2.077516312382091}]
[null,null,"Return of Capital (regulatory depreciation)",null,"$m",null,null,{"$f":"'[1]Revenue summary'!G8","v":47.27664101277017},{"$f":"'[1]Revenue summary'!H8","v":21.302843523033001},{"$f":"'[1]Revenue summary'!I8","v":16.581251054683229},{"$f":"'[1]Revenue summary'!J8","v":18.055284310246069},{"$f":"'[1]Revenue summary'!K8","v":18.584921677622031}]
[null,null,"Operating Expenditure",null,"$m",null,null,{"$f":"'[1]Revenue summary'!G9","v":11.643899665531016},{"$f":"'[1]Revenue summary'!H9","v":12.283753563992155},{"$f":"'[1]Revenue summary'!I9","v":13.463461374935786},{"$f":"'[1]Revenue summary'!J9","v":14.526218173395334},{"$f":"'[1]Revenue summary'!K9","v":15.413374509543464}]
[null,null,"Revenue Adjustments",null,"$m",null,null,{"$f":"'[1]Revenue summary'!G10","v":0},{"$f":"'[1]Revenue summary'!H10","v":0},{"$f":"'[1]Revenue summary'!I10","v":0},{"$f":"'[1]Revenue summary'!J10","v":0},{"$f":"'[1]Revenue summary'!K10","v":0}]
[null,null,"Net Tax Allowance",null,"$m",null,null,{"$f":"'[1]Revenue summary'!G11","v":5.007473497192259},{"$f":"'[1]Revenue summary'!H11","v":0.69857338431209814},{"$f":"'[1]Revenue summary'!I11","v":0},{"$f":"'[1]Revenue summary'!J11","v":0},{"$f":"'[1]Revenue summary'!K11","v":0}]
[null,null,"Annual Revenue Requirement (unsmoothed)",null,"$m",null,null,{"$f":"SUM(H20:H24)","v":63.928014175493445},{"$f":"SUM(I20:I24)","v":32.497691394413295},{"$f":"SUM(J20:J24)","v":28.230854865893086},{"$f":"SUM(K20:K24)","v":32.16919594107452},{"$f":"SUM(L20:L24)","v":36.075812499547588}]
[]
[null,null,"Non-Capital Component",null,"$m",null,null,{"$f":"H22","v":11.643899665531016},{"$f":"I22","v":12.283753563992155},{"$f":"J22","v":13.463461374935786},{"$f":"K22","v":14.526218173395334},{"$f":"L22","v":15.413374509543464}]
[null,null,"Capital Component",null,"$m",null,null,{"$f":"SUM(H20:H21,H23:H24)","v":52.284114509962428},{"$f":"SUM(I20:I21,I23:I24)","v":20.213937830421138},{"$f":"SUM(J20:J21,J23:J24)","v":14.767393490957298},{"$f":"SUM(K20:K21,K23:K24)","v":17.642977767679188},{"$f":"SUM(L20:L21,L23:L24)","v":20.662437990004122}]
[null,null,null,null,null,null,null,{"$f":"(H27+H28=H25)/1","v":1},{"$f":"(I27+I28=I25)/1","v":1},{"$f":"(J27+J28=J25)/1","v":1},{"$f":"(K27+K28=K25)/1","v":1},{"$f":"(L27+L28=L25)/1","v":1}]
[]
[null,"NPV of unsmoothed revenue requirement"]
[null,null,null,null,"Units",null,"NPV"]
[null,null,"Non-capital",null,"$m",null,{"$f":"SUMPRODUCT($H27:$L27,1/$H$10:$L$10)","v":57.88893686601191}]
[null,null,"Capital",null,"$m",null,{"$f":"SUMPRODUCT($H28:$L28,1/$H$10:$L$10)","v":111.59014428946901}]
[null,null,"Total",null,"$m",null,{"$f":"G33+G34","v":169.47908115548091}]
[]
[]
[]
[null,{"$f":"LEFT(B15,1)+1&\". Input - Base Year Tariffs, Base Year Volume & Volume Forecast\"","v":"5. Input - Base Year Tariffs, Base Year Volume & Volume Forecast"},null,null,null,null,null,null,null,{"$f":"IF('Inputs | General'!$G$16=\"Exit Fees (Vic)\",\"NOT USED\",\"\")","v":"NOT USED"}]
[]
[null,null,null,null,null,null,null,{"$f":"LEFT(J42,4)-1&\"-\"&RIGHT(J42,2)-1","v":"2025-26"},{"$f":"LEFT(J42,4)-1&\"-\"&RIGHT(J42,2)-1","v":"2025-26"},"Volume Forecast"]
["▼ Table Filters",null,"Tariff #","Tariff name","Application","Tariff Code","Other designation","Base year tariff ($/year)","Base year volume",{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(J42,4)+1&\"-\"&RIGHT(J42,2)+1","v":"2027-28"},{"$f":"LEFT(K42,4)+1&\"-\"&RIGHT(K42,2)+1","v":"2028-29"},"2029-30","2030-31"]
[null,null,"Tariff #","Tariff name","Application","Tariff Code","Other designation","Base year tariff ($/year)","Base year volume","F-RP0","F-RP+1","F-RP+2","F-RP+3","F-RP+4"]
[null,null,1,{"$f":"D45","v":"Residential Non ToU"},"Non-capital",{"$f":"F45","v":"R1"},{"$f":"G45","v":"Primary"},10,1000000,{"$f":"Table4[[#This Row],[Base year volume]]*0.9","v":900000},{"$f":"Table4[[#This Row],[F-RP0]]*0.9","v":810000},{"$f":"Table4[[#This Row],[F-RP+1]]*0.9","v":729000},{"$f":"Table4[[#This Row],[F-RP+2]]*0.9","v":656100},{"$f":"Table4[[#This Row],[F-RP+3]]*0.9","v":590490}]
[null,null,1,{"$f":"D46","v":"Residential Non ToU"},"Capital",{"$f":"F46","v":"R1"},{"$f":"G46","v":"Primary"},20,1100000,{"$f":"Table4[[#This Row],[Base year volume]]","v":1100000},{"$f":"Table4[[#This Row],[F-RP0]]","v":1100000},{"$f":"Table4[[#This Row],[F-RP+1]]","v":1100000},{"$f":"Table4[[#This Row],[F-RP+2]]","v":1100000},{"$f":"Table4[[#This Row],[F-RP+3]]","v":1100000}]
[null,null,1,"Residential Non ToU","Total","R1","Primary",{"$f":"H44+H45","v":30}]
[null,null,2,{"$f":"D48","v":"Residential ToU"},"Non-capital",{"$f":"F48","v":"R2"},"Primary",20,300000,{"$f":"Table4[[#This Row],[Base year volume]]*0.9","v":270000},{"$f":"Table4[[#This Row],[F-RP0]]*0.9","v":243000},{"$f":"Table4[[#This Row],[F-RP+1]]*0.9","v":218700},{"$f":"Table4[[#This Row],[F-RP+2]]*0.9","v":196830},{"$f":"Table4[[#This Row],[F-RP+3]]*0.9","v":177147}]
[null,null,2,"Residential ToU","Capital","R2","Primary",20,330000,{"$f":"Table4[[#This Row],[Base year volume]]","v":330000},{"$f":"Table4[[#This Row],[F-RP0]]","v":330000},{"$f":"Table4[[#This Row],[F-RP+1]]","v":330000},{"$f":"Table4[[#This Row],[F-RP+2]]","v":330000},{"$f":"Table4[[#This Row],[F-RP+3]]","v":330000}]
[null,null,2,"Residential ToU","Total","R2","Primary",{"$f":"H47+H48","v":40}]
[null,null,3,{"$f":"D51","v":"Controlled load"},"Non-capital",{"$f":"F51","v":"B1"},"Secondary",1,300000,{"$f":"Table4[[#This Row],[Base year volume]]*0.9","v":270000},{"$f":"Table4[[#This Row],[F-RP0]]*0.9","v":243000},{"$f":"Table4[[#This Row],[F-RP+1]]*0.9","v":218700},{"$f":"Table4[[#This Row],[F-RP+2]]*0.9","v":196830},{"$f":"Table4[[#This Row],[F-RP+3]]*0.9","v":177147}]
[null,null,3,"Controlled load","Capital","B1","Secondary",10,330000,{"$f":"Table4[[#This Row],[Base year volume]]","v":330000},{"$f":"Table4[[#This Row],[F-RP0]]","v":330000},{"$f":"Table4[[#This Row],[F-RP+1]]","v":330000},{"$f":"Table4[[#This Row],[F-RP+2]]","v":330000},{"$f":"Table4[[#This Row],[F-RP+3]]","v":330000}]
[null,null,3,"Controlled load","Total","B1","Secondary",{"$f":"H50+H51","v":11}]
[null,null,4,{"$f":"D54","v":"Small Business Non ToU"},"Non-capital",{"$f":"F54","v":"B2"},"Primary",10,50000,{"$f":"Table4[[#This Row],[Base year volume]]*0.9","v":45000},{"$f":"Table4[[#This Row],[F-RP0]]*0.9","v":40500},{"$f":"Table4[[#This Row],[F-RP+1]]*0.9","v":36450},{"$f":"Table4[[#This Row],[F-RP+2]]*0.9","v":32805},{"$f":"Table4[[#This Row],[F-RP+3]]*0.9","v":29524.5}]
[null,null,4,"Small Business Non ToU","Capital","B2","Primary",30,55000,{"$f":"Table4[[#This Row],[Base year volume]]","v":55000},{"$f":"Table4[[#This Row],[F-RP0]]","v":55000},{"$f":"Table4[[#This Row],[F-RP+1]]","v":55000},{"$f":"Table4[[#This Row],[F-RP+2]]","v":55000},{"$f":"Table4[[#This Row],[F-RP+3]]","v":55000}]
[null,null,4,"Small Business Non ToU","Total","B2","Primary",{"$f":"H53+H54","v":40}]
[null,null,5,{"$f":"D57","v":"Small Business ToU"},"Non-capital",{"$f":"F57","v":"LV1"},"Primary",25,50000,{"$f":"Table4[[#This Row],[Base year volume]]*0.9","v":45000},{"$f":"Table4[[#This Row],[F-RP0]]*0.9","v":40500},{"$f":"Table4[[#This Row],[F-RP+1]]*0.9","v":36450},{"$f":"Table4[[#This Row],[F-RP+2]]*0.9","v":32805},{"$f":"Table4[[#This Row],[F-RP+3]]*0.9","v":29524.5}]
[null,null,5,"Small Business ToU","Capital","LV1","Primary",20,55000,{"$f":"Table4[[#This Row],[Base year volume]]","v":55000},{"$f":"Table4[[#This Row],[F-RP0]]","v":55000},{"$f":"Table4[[#This Row],[F-RP+1]]","v":55000},{"$f":"Table4[[#This Row],[F-RP+2]]","v":55000},{"$f":"Table4[[#This Row],[F-RP+3]]","v":55000}]
["▼ More Rows",null,5,"Small Business ToU","Total","LV1","Primary",{"$f":"H56+H57","v":45}]
[null,null,6,{"$f":"D60","v":"LV 40-160 MWh (System)"},"Non-capital",{"$f":"F60","v":0},0,45,10000,{"$f":"Table4[[#This Row],[Base year volume]]*0.9","v":9000},{"$f":"Table4[[#This Row],[F-RP0]]*0.9","v":8100},{"$f":"Table4[[#This Row],[F-RP+1]]*0.9","v":7290},{"$f":"Table4[[#This Row],[F-RP+2]]*0.9","v":6561},{"$f":"Table4[[#This Row],[F-RP+3]]*0.9","v":5904.9000000000005}]
[null,null,6,"LV 40-160 MWh (System)","Capital",0,0,25,10000,{"$f":"Table4[[#This Row],[Base year volume]]","v":10000},{"$f":"Table4[[#This Row],[F-RP0]]","v":10000},{"$f":"Table4[[#This Row],[F-RP+1]]","v":10000},{"$f":"Table4[[#This Row],[F-RP+2]]","v":10000},{"$f":"Table4[[#This Row],[F-RP+3]]","v":10000}]
[null,null,6,"LV 40-160 MWh (System)","Total",0,0,{"$f":"H59+H60","v":70}]
[null,null,7,{"$f":"D63","v":0},"Non-capital",{"$f":"F63","v":0},0]
[null,null,7,0,"Capital",0,0]
[null,null,7,0,"Total",0,0,{"$f":"H62+H63","v":0}]
[null,null,8,{"$f":"D66","v":0},"Non-capital",{"$f":"F66","v":0},0]
[null,null,8,0,"Capital",0,0]
[null,null,8,0,"Total",0,0,{"$f":"H65+H66","v":0}]
[null,null,9,{"$f":"D69","v":0},"Non-capital",{"$f":"F69","v":0},0]
[null,null,9,0,"Capital",0,0]
[null,null,9,0,"Total",0,0,{"$f":"H68+H69","v":0}]
[null,null,10,{"$f":"D72","v":0},"Non-capital",{"$f":"F72","v":0},0]
[null,null,10,0,"Capital",0,0]
[null,null,10,0,"Total",0,0,{"$f":"H71+H72","v":0}]
[null,null,11,{"$f":"D75","v":0},"Non-capital",{"$f":"F75","v":0},0]
[null,null,11,0,"Capital",0,0]
[null,null,11,0,"Total",0,0,{"$f":"H74+H75","v":0}]
[null,null,12,{"$f":"D78","v":0},"Non-capital",{"$f":"F78","v":0},0]
[null,null,12,0,"Capital",0,0]
[null,null,12,0,"Total",0,0,{"$f":"H77+H78","v":0}]
[null,null,13,{"$f":"D81","v":0},"Non-capital",{"$f":"F81","v":0},0]
[null,null,13,0,"Capital",0,0]
[null,null,13,0,"Total",0,0,{"$f":"H80+H81","v":0}]
[null,null,14,{"$f":"D84","v":0},"Non-capital",{"$f":"F84","v":0},0]
[null,null,14,0,"Capital",0,0]
[null,null,14,0,"Total",0,0,{"$f":"H83+H84","v":0}]
[null,null,15,{"$f":"D87","v":0},"Non-capital",{"$f":"F87","v":0},0]
[null,null,15,0,"Capital",0,0]
[null,null,15,0,"Total",0,0,{"$f":"H86+H87","v":0}]
[]
[null,null,null,"Total","Non-capital",null,null,null,{"$f":"SUMIFS(Table4[Base year volume],Table4[[Application]:[Application]],$E90)","v":1710000},{"$f":"SUMIFS(Table4[F-RP0],Table4[[Application]:[Application]],$E90)","v":1539000},{"$f":"SUMIFS(Table4[F-RP+1],Table4[[Application]:[Application]],$E90)","v":1385100},{"$f":"SUMIFS(Table4[F-RP+2],Table4[[Application]:[Application]],$E90)","v":1246590},{"$f":"SUMIFS(Table4[F-RP+3],Table4[[Application]:[Application]],$E90)","v":1121931},{"$f":"SUMIFS(Table4[F-RP+4],Table4[[Application]:[Application]],$E90)","v":1009737.9}]
[null,null,null,"Total","Capital",null,null,null,{"$f":"SUMIFS(Table4[Base year volume],Table4[[Application]:[Application]],$E91)","v":1880000},{"$f":"SUMIFS(Table4[F-RP0],Table4[[Application]:[Application]],$E91)","v":1880000},{"$f":"SUMIFS(Table4[F-RP+1],Table4[[Application]:[Application]],$E91)","v":1880000},{"$f":"SUMIFS(Table4[F-RP+2],Table4[[Application]:[Application]],$E91)","v":1880000},{"$f":"SUMIFS(Table4[F-RP+3],Table4[[Application]:[Application]],$E91)","v":1880000},{"$f":"SUMIFS(Table4[F-RP+4],Table4[[Application]:[Application]],$E91)","v":1880000}]
[]
[]
[]
[null,{"$f":"LEFT(B39,1)+1&\". Set X-Factors\"","v":"6. Set X-Factors"}]
[]
["Price cap calculation"]
[]
[null,"1: Non-capital"]
[]
[null,null,"Unsmoothed - Annual Revenue Requirement",null,{"$f":"'Calc | Price Cap'!I59/10^6","v":18.5},{"$f":"'Inputs | Price Cap'!H27","v":11.643899665531016},{"$f":"'Inputs | Price Cap'!I27","v":12.283753563992155},{"$f":"'Inputs | Price Cap'!J27","v":13.463461374935786},{"$f":"'Inputs | Price Cap'!K27","v":14.526218173395334},{"$f":"'Inputs | Price Cap'!L27","v":15.413374509543464},null,{"$f":"'Inputs | Price Cap'!G33","v":57.88893686601191},"NPV (unsmoothed)"]
[]
[null,null,null,null,null,{"$f":"F106-E101","v":3.2492200000000011},"First year difference ($m)",null,null,null,null,{"$f":"J101-I101","v":0.88715633614813072},"Final year difference ($m)"]
[null,null,null,null,null,{"$f":"(F106/E101)-1","v":0.17563351351351364},"First year difference (%)",null,null,null,null,{"$f":"(J101/I101)-1","v":6.1072766879747942E-2},"Final year difference (%)"]
[]
[null,null,"Smoothed - Expected Revenue",null,{"$f":"'Calc | Price Cap'!I59/10^6","v":18.5},{"$f":"'Calc | Price Cap'!J59/10^6","v":21.749220000000001},{"$f":"'Calc | Price Cap'!K59/10^6","v":20.282076},{"$f":"'Calc | Price Cap'!L59/10^6","v":18.915144300000001},{"$f":"'Calc | Price Cap'!M59/10^6","v":17.642266560000003},{"$f":"'Calc | Price Cap'!N59/10^6","v":16.454476242000002},null,{"$f":"SUMPRODUCT($F106:$J106,1/'Inputs | Price Cap'!$H$10:$L$10)","v":82.856445552448392},"NPV (smoothed)"]
[]
[null,null,"X Factors",null,null,"P_0","X_02","X_03","X_04","X_05"]
[null,null,"positive P0, X imply real decrease in price/ revenue constraint",null,null,-0.27315652200197316,-0.01,-0.01,-0.01,-0.01,null,{"$f":"L101-L106","v":-24.967508686436481},"NPV difference (smoothed vs unsmoothed)"]
[]
[]
[]
[]
[]
[null,"2: Capital"]
[]
[null,null,"Unsmoothed - Annual Revenue Requirement",null,{"$f":"'Calc | Price Cap'!I60/10^6","v":34.9},{"$f":"'Inputs | Price Cap'!H28","v":52.284114509962428},{"$f":"'Inputs | Price Cap'!I28","v":20.213937830421138},{"$f":"'Inputs | Price Cap'!J28","v":14.767393490957298},{"$f":"'Inputs | Price Cap'!K28","v":17.642977767679188},{"$f":"'Inputs | Price Cap'!L28","v":20.662437990004122},null,{"$f":"'Inputs | Price Cap'!G34","v":111.59014428946901},"NPV (unsmoothed)"]
[]
[null,null,null,null,null,{"$f":"F122-E117","v":-3.5792499999999983},"First year difference ($m)",null,null,null,null,{"$f":"J117-I117","v":3.0194602223249341},"Final year difference ($m)"]
[null,null,null,null,null,{"$f":"(F122/E117)-1","v":-0.10255730659025786},"First year difference (%)",null,null,null,null,{"$f":"(J117/I117)-1","v":0.1711423242768233},"Final year difference (%)"]
[]
[null,null,"Smoothed - Expected Revenue",null,{"$f":"'Calc | Price Cap'!I60/10^6","v":34.9},{"$f":"'Calc | Price Cap'!J60/10^6","v":31.32075},{"$f":"'Calc | Price Cap'!K60/10^6","v":31.165649999999999},{"$f":"'Calc | Price Cap'!L60/10^6","v":31.010549999999999},{"$f":"'Calc | Price Cap'!M60/10^6","v":30.8703},{"$f":"'Calc | Price Cap'!N60/10^6","v":30.730049999999999},null,{"$f":"SUMPRODUCT($F122:$J122,1/'Inputs | Price Cap'!$H$10:$L$10)","v":134.36039850018398},"NPV (smoothed)"]
[]
[null,null,"X Factors",null,null,"P_0","X_02","X_03","X_04","X_05"]
[null,null,"positive P0, X imply real decrease in price/ revenue constraint",null,null,0.12542117952813292,0.03,0.03,0.03,0.03,null,{"$f":"L117-L122","v":-22.770254210714967},"NPV difference (smoothed vs unsmoothed)"]

{"sheet":"Calc | Price Cap","index":5,"n_rows":63,"n_cols":14,"rows_kept":63,"cut":false,"hidden":false,"merged":[[7,9,7,13],[4,1,4,7],[1,10,1,11],[0,13,0,14]]}
[null,{"$f":"'Title Page'!B8&\" v\"&'Title Page'!$C$10","v":"Final Standardised Metering Pricing Model  v1.02"},null,null,null,null,null,null,null,null,null,null,"DNSP:",{"$f":"IF('Inputs | General'!$G$16=\"Exit Fees (Vic)\",\"NOT USED\",NSP)","v":"NOT USED"}]
[null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"Calc | Price Cap"},null,null,null,null,null,"Key:","Input","External Link","Internal Link"]
[]
[]
[null,"Annual Charges Calculations"]
[]
[null,"Annual Smoothed Revenue Calculation"]
[null,null,null,null,null,null,null,null,"Base Year Revenue","Annual Revenue"]
["▼ Table Filters",null,"Tariff #","Tariff name","Application","Tariff Code","Other designation",null,{"$f":"LEFT(J9,4)-1&\"-\"&RIGHT(J9,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(J9,4)+1&\"-\"&RIGHT(J9,2)+1","v":"2027-28"},{"$f":"LEFT(K9,4)+1&\"-\"&RIGHT(K9,2)+1","v":"2028-29"},"2029-30","2030-31"]
[null,null,"Tariff #","Tariff name","Application","Tariff Code","Other designation","Column1","F-RP-1","F-RP0","F-RP+1","F-RP+2","F-RP+3","F-RP+4"]
[null,null,1,{"$f":"'Inputs | Price Cap'!D44","v":"Residential Non ToU"},"Non-capital",{"$f":"'Inputs | Price Cap'!F44","v":"R1"},{"$f":"'Inputs | Price Cap'!G44","v":"Primary"},null,{"$f":"'Output | Price Caps'!$I9*'Inputs | Price Cap'!I44","v":10000000},{"$f":"'Output | Price Caps'!J9*'Inputs | Price Cap'!J44","v":11754000},{"$f":"'Output | Price Caps'!K9*'Inputs | Price Cap'!K44","v":10959300},{"$f":"'Output | Price Caps'!L9*'Inputs | Price Cap'!L44","v":10220580},{"$f":"'Output | Price Caps'!M9*'Inputs | Price Cap'!M44","v":9533133},{"$f":"'Output | Price Caps'!N9*'Inputs | Price Cap'!N44","v":8892779.4000000004}]
[null,null,1,{"$f":"'Inputs | Price Cap'!D45","v":"Residential Non ToU"},"Capital",{"$f":"'Inputs | Price Cap'!F45","v":"R1"},{"$f":"'Inputs | Price Cap'!G45","v":"Primary"},null,{"$f":"'Output | Price Caps'!$I10*'Inputs | Price Cap'!I45","v":22000000},{"$f":"'Output | Price Caps'!J10*'Inputs | Price Cap'!J45","v":19745000},{"$f":"'Output | Price Caps'!K10*'Inputs | Price Cap'!K45","v":19646000},{"$f":"'Output | Price Caps'!L10*'Inputs | Price Cap'!L45","v":19547000},{"$f":"'Output | Price Caps'!M10*'Inputs | Price Cap'!M45","v":19459000},{"$f":"'Output | Price Caps'!N10*'Inputs | Price Cap'!N45","v":19371000}]
[null,null,1,{"$f":"'Inputs | Price Cap'!D46","v":"Residential Non ToU"},"Total",{"$f":"'Inputs | Price Cap'!F46","v":"R1"},{"$f":"'Inputs | Price Cap'!G46","v":"Primary"},null,{"$f":"I11+I12","v":32000000},31499000,30605300,29767580,28992133,28263779.399999999]
[null,null,2,{"$f":"'Inputs | Price Cap'!D47","v":"Residential ToU"},"Non-capital",{"$f":"'Inputs | Price Cap'!F47","v":"R2"},{"$f":"'Inputs | Price Cap'!G47","v":"Primary"},null,{"$f":"'Output | Price Caps'!$I12*'Inputs | Price Cap'!I47","v":6000000},{"$f":"'Output | Price Caps'!J12*'Inputs | Price Cap'!J47","v":7055100},{"$f":"'Output | Price Caps'!K12*'Inputs | Price Cap'!K47","v":6580440},{"$f":"'Output | Price Caps'!L12*'Inputs | Price Cap'!L47","v":6136722},{"$f":"'Output | Price Caps'!M12*'Inputs | Price Cap'!M47","v":5723816.3999999994},{"$f":"'Output | Price Caps'!N12*'Inputs | Price Cap'!N47","v":5337439.1099999994}]
[null,null,2,{"$f":"'Inputs | Price Cap'!D48","v":"Residential ToU"},"Capital",{"$f":"'Inputs | Price Cap'!F48","v":"R2"},{"$f":"'Inputs | Price Cap'!G48","v":"Primary"},null,{"$f":"'Output | Price Caps'!$I13*'Inputs | Price Cap'!I48","v":6600000},{"$f":"'Output | Price Caps'!J13*'Inputs | Price Cap'!J48","v":5923500},{"$f":"'Output | Price Caps'!K13*'Inputs | Price Cap'!K48","v":5893800},{"$f":"'Output | Price Caps'!L13*'Inputs | Price Cap'!L48","v":5864100},{"$f":"'Output | Price Caps'!M13*'Inputs | Price Cap'!M48","v":5837700},{"$f":"'Output | Price Caps'!N13*'Inputs | Price Cap'!N48","v":5811300}]
[null,null,2,{"$f":"'Inputs | Price Cap'!D49","v":"Residential ToU"},"Total",{"$f":"'Inputs | Price Cap'!F49","v":"R2"},{"$f":"'Inputs | Price Cap'!G49","v":"Primary"},null,{"$f":"I14+I15","v":12600000},12978600,12474240,12000822,11561516.399999999,11148739.109999999]
[null,null,3,{"$f":"'Inputs | Price Cap'!D50","v":"Controlled load"},"Non-capital",{"$f":"'Inputs | Price Cap'!F50","v":"B1"},{"$f":"'Inputs | Price Cap'!G50","v":"Secondary"},null,{"$f":"'Output | Price Caps'!$I15*'Inputs | Price Cap'!I50","v":300000},{"$f":"'Output | Price Caps'!J15*'Inputs | Price Cap'!J50","v":353700},{"$f":"'Output | Price Caps'!K15*'Inputs | Price Cap'!K50","v":330480},{"$f":"'Output | Price Caps'!L15*'Inputs | Price Cap'!L50","v":308367},{"$f":"'Output | Price Caps'!M15*'Inputs | Price Cap'!M50","v":287371.8},{"$f":"'Output | Price Caps'!N15*'Inputs | Price Cap'!N50","v":267491.97000000003}]
[null,null,3,{"$f":"'Inputs | Price Cap'!D51","v":"Controlled load"},"Capital",{"$f":"'Inputs | Price Cap'!F51","v":"B1"},{"$f":"'Inputs | Price Cap'!G51","v":"Secondary"},null,{"$f":"'Output | Price Caps'!$I16*'Inputs | Price Cap'!I51","v":3300000},{"$f":"'Output | Price Caps'!J16*'Inputs | Price Cap'!J51","v":2960100},{"$f":"'Output | Price Caps'!K16*'Inputs | Price Cap'!K51","v":2946900},{"$f":"'Output | Price Caps'!L16*'Inputs | Price Cap'!L51","v":2933700},{"$f":"'Output | Price Caps'!M16*'Inputs | Price Cap'!M51","v":2920500},{"$f":"'Output | Price Caps'!N16*'Inputs | Price Cap'!N51","v":2907300}]
[null,null,3,{"$f":"'Inputs | Price Cap'!D52","v":"Controlled load"},"Total",{"$f":"'Inputs | Price Cap'!F52","v":"B1"},{"$f":"'Inputs | Price Cap'!G52","v":"Secondary"},null,{"$f":"I17+I18","v":3600000},3313800,3277380,3242067,3207871.8,3174791.97]
[null,null,4,{"$f":"'Inputs | Price Cap'!D53","v":"Small Business Non ToU"},"Non-capital",{"$f":"'Inputs | Price Cap'!F53","v":"B2"},{"$f":"'Inputs | Price Cap'!G53","v":"Primary"},null,{"$f":"'Output | Price Caps'!$I18*'Inputs | Price Cap'!I53","v":500000},{"$f":"'Output | Price Caps'!J18*'Inputs | Price Cap'!J53","v":587700},{"$f":"'Output | Price Caps'!K18*'Inputs | Price Cap'!K53","v":547965},{"$f":"'Output | Price Caps'!L18*'Inputs | Price Cap'!L53","v":511029},{"$f":"'Output | Price Caps'!M18*'Inputs | Price Cap'!M53","v":476656.64999999997},{"$f":"'Output | Price Caps'!N18*'Inputs | Price Cap'!N53","v":444638.97000000003}]
[null,null,4,{"$f":"'Inputs | Price Cap'!D54","v":"Small Business Non ToU"},"Capital",{"$f":"'Inputs | Price Cap'!F54","v":"B2"},{"$f":"'Inputs | Price Cap'!G54","v":"Primary"},null,{"$f":"'Output | Price Caps'!$I19*'Inputs | Price Cap'!I54","v":1650000},{"$f":"'Output | Price Caps'!J19*'Inputs | Price Cap'!J54","v":1480600},{"$f":"'Output | Price Caps'!K19*'Inputs | Price Cap'!K54","v":1473450},{"$f":"'Output | Price Caps'!L19*'Inputs | Price Cap'!L54","v":1466300},{"$f":"'Output | Price Caps'!M19*'Inputs | Price Cap'!M54","v":1459150},{"$f":"'Output | Price Caps'!N19*'Inputs | Price Cap'!N54","v":1452000}]
[null,null,4,{"$f":"'Inputs | Price Cap'!D55","v":"Small Business Non ToU"},"Total",{"$f":"'Inputs | Price Cap'!F55","v":"B2"},{"$f":"'Inputs | Price Cap'!G55","v":"Primary"},null,{"$f":"I20+I21","v":2150000},2068300,2021415,1977329,1935806.65,1896638.97]
[null,null,5,{"$f":"'Inputs | Price Cap'!D56","v":"Small Business ToU"},"Non-capital",{"$f":"'Inputs | Price Cap'!F56","v":"LV1"},{"$f":"'Inputs | Price Cap'!G56","v":"Primary"},null,{"$f":"'Output | Price Caps'!$I21*'Inputs | Price Cap'!I56","v":1250000},{"$f":"'Output | Price Caps'!J21*'Inputs | Price Cap'!J56","v":1469699.9999999998},{"$f":"'Output | Price Caps'!K21*'Inputs | Price Cap'!K56","v":1370520.0000000002},{"$f":"'Output | Price Caps'!L21*'Inputs | Price Cap'!L56","v":1278301.5},{"$f":"'Output | Price Caps'!M21*'Inputs | Price Cap'!M56","v":1192133.7000000002},{"$f":"'Output | Price Caps'!N21*'Inputs | Price Cap'!N56","v":1111892.67}]
[null,null,5,{"$f":"'Inputs | Price Cap'!D57","v":"Small Business ToU"},"Capital",{"$f":"'Inputs | Price Cap'!F57","v":"LV1"},{"$f":"'Inputs | Price Cap'!G57","v":"Primary"},null,{"$f":"'Output | Price Caps'!$I22*'Inputs | Price Cap'!I57","v":1100000},{"$f":"'Output | Price Caps'!J22*'Inputs | Price Cap'!J57","v":987250},{"$f":"'Output | Price Caps'!K22*'Inputs | Price Cap'!K57","v":982300},{"$f":"'Output | Price Caps'!L22*'Inputs | Price Cap'!L57","v":977350},{"$f":"'Output | Price Caps'!M22*'Inputs | Price Cap'!M57","v":972950.00000000012},{"$f":"'Output | Price Caps'!N22*'Inputs | Price Cap'!N57","v":968550}]
["▼ More Rows",null,5,{"$f":"'Inputs | Price Cap'!D58","v":"Small Business ToU"},"Total",{"$f":"'Inputs | Price Cap'!F58","v":"LV1"},{"$f":"'Inputs | Price Cap'!G58","v":"Primary"},null,{"$f":"I23+I24","v":2350000},2456950,2352820,2255651.5,2165083.7000000002,2080442.67]
[null,null,6,{"$f":"'Inputs | Price Cap'!D59","v":"LV 40-160 MWh (System)"},"Non-capital",{"$f":"'Inputs | Price Cap'!F59","v":0},{"$f":"'Inputs | Price Cap'!G59","v":0},null,{"$f":"'Output | Price Caps'!$I24*'Inputs | Price Cap'!I59","v":450000},{"$f":"'Output | Price Caps'!J24*'Inputs | Price Cap'!J59","v":529020},{"$f":"'Output | Price Caps'!K24*'Inputs | Price Cap'!K59","v":493371},{"$f":"'Output | Price Caps'!L24*'Inputs | Price Cap'!L59","v":460144.8},{"$f":"'Output | Price Caps'!M24*'Inputs | Price Cap'!M59","v":429155.00999999995},{"$f":"'Output | Price Caps'!N24*'Inputs | Price Cap'!N59","v":400234.12200000003}]
[null,null,6,{"$f":"'Inputs | Price Cap'!D60","v":"LV 40-160 MWh (System)"},"Capital",{"$f":"'Inputs | Price Cap'!F60","v":0},{"$f":"'Inputs | Price Cap'!G60","v":0},null,{"$f":"'Output | Price Caps'!$I25*'Inputs | Price Cap'!I60","v":250000},{"$f":"'Output | Price Caps'!J25*'Inputs | Price Cap'!J60","v":224300},{"$f":"'Output | Price Caps'!K25*'Inputs | Price Cap'!K60","v":223200},{"$f":"'Output | Price Caps'!L25*'Inputs | Price Cap'!L60","v":222100},{"$f":"'Output | Price Caps'!M25*'Inputs | Price Cap'!M60","v":221000},{"$f":"'Output | Price Caps'!N25*'Inputs | Price Cap'!N60","v":219899.99999999997}]
[null,null,6,{"$f":"'Inputs | Price Cap'!D61","v":"LV 40-160 MWh (System)"},"Total",{"$f":"'Inputs | Price Cap'!F61","v":0},{"$f":"'Inputs | Price Cap'!G61","v":0},null,{"$f":"I26+I27","v":700000},753320,716571,682244.8,650155.01,620134.12199999997]
[null,null,7,{"$f":"'Inputs | Price Cap'!D62","v":0},"Non-capital",{"$f":"'Inputs | Price Cap'!F62","v":0},{"$f":"'Inputs | Price Cap'!G62","v":0},null,{"$f":"'Output | Price Caps'!$I27*'Inputs | Price Cap'!I62","v":0},{"$f":"'Output | Price Caps'!J27*'Inputs | Price Cap'!J62","v":0},{"$f":"'Output | Price Caps'!K27*'Inputs | Price Cap'!K62","v":0},{"$f":"'Output | Price Caps'!L27*'Inputs | Price Cap'!L62","v":0},{"$f":"'Output | Price Caps'!M27*'Inputs | Price Cap'!M62","v":0},{"$f":"'Output | Price Caps'!N27*'Inputs | Price Cap'!N62","v":0}]
[null,null,7,{"$f":"'Inputs | Price Cap'!D63","v":0},"Capital",{"$f":"'Inputs | Price Cap'!F63","v":0},{"$f":"'Inputs | Price Cap'!G63","v":0},null,{"$f":"'Output | Price Caps'!$I28*'Inputs | Price Cap'!I63","v":0},{"$f":"'Output | Price Caps'!J28*'Inputs | Price Cap'!J63","v":0},{"$f":"'Output | Price Caps'!K28*'Inputs | Price Cap'!K63","v":0},{"$f":"'Output | Price Caps'!L28*'Inputs | Price Cap'!L63","v":0},{"$f":"'Output | Price Caps'!M28*'Inputs | Price Cap'!M63","v":0},{"$f":"'Output | Price Caps'!N28*'Inputs | Price Cap'!N63","v":0}]
[null,null,7,{"$f":"'Inputs | Price Cap'!D64","v":0},"Total",{"$f":"'Inputs | Price Cap'!F64","v":0},{"$f":"'Inputs | Price Cap'!G64","v":0},null,{"$f":"I29+I30","v":0},0,0,0,0,0]
[null,null,8,{"$f":"'Inputs | Price Cap'!D65","v":0},"Non-capital",{"$f":"'Inputs | Price Cap'!F65","v":0},{"$f":"'Inputs | Price Cap'!G65","v":0},null,{"$f":"'Output | Price Caps'!$I30*'Inputs | Price Cap'!I65","v":0},{"$f":"'Output | Price Caps'!J30*'Inputs | Price Cap'!J65","v":0},{"$f":"'Output | Price Caps'!K30*'Inputs | Price Cap'!K65","v":0},{"$f":"'Output | Price Caps'!L30*'Inputs | Price Cap'!L65","v":0},{"$f":"'Output | Price Caps'!M30*'Inputs | Price Cap'!M65","v":0},{"$f":"'Output | Price Caps'!N30*'Inputs | Price Cap'!N65","v":0}]
[null,null,8,{"$f":"'Inputs | Price Cap'!D66","v":0},"Capital",{"$f":"'Inputs | Price Cap'!F66","v":0},{"$f":"'Inputs | Price Cap'!G66","v":0},null,{"$f":"'Output | Price Caps'!$I31*'Inputs | Price Cap'!I66","v":0},{"$f":"'Output | Price Caps'!J31*'Inputs | Price Cap'!J66","v":0},{"$f":"'Output | Price Caps'!K31*'Inputs | Price Cap'!K66","v":0},{"$f":"'Output | Price Caps'!L31*'Inputs | Price Cap'!L66","v":0},{"$f":"'Output | Price Caps'!M31*'Inputs | Price Cap'!M66","v":0},{"$f":"'Output | Price Caps'!N31*'Inputs | Price Cap'!N66","v":0}]
[null,null,8,{"$f":"'Inputs | Price Cap'!D67","v":0},"Total",{"$f":"'Inputs | Price Cap'!F67","v":0},{"$f":"'Inputs | Price Cap'!G67","v":0},null,{"$f":"I32+I33","v":0},0,0,0,0,0]
[null,null,9,{"$f":"'Inputs | Price Cap'!D68","v":0},"Non-capital",{"$f":"'Inputs | Price Cap'!F68","v":0},{"$f":"'Inputs | Price Cap'!G68","v":0},null,{"$f":"'Output | Price Caps'!$I33*'Inputs | Price Cap'!I68","v":0},{"$f":"'Output | Price Caps'!J33*'Inputs | Price Cap'!J68","v":0},{"$f":"'Output | Price Caps'!K33*'Inputs | Price Cap'!K68","v":0},{"$f":"'Output | Price Caps'!L33*'Inputs | Price Cap'!L68","v":0},{"$f":"'Output | Price Caps'!M33*'Inputs | Price Cap'!M68","v":0},{"$f":"'Output | Price Caps'!N33*'Inputs | Price Cap'!N68","v":0}]
[null,null,9,{"$f":"'Inputs | Price Cap'!D69","v":0},"Capital",{"$f":"'Inputs | Price Cap'!F69","v":0},{"$f":"'Inputs | Price Cap'!G69","v":0},null,{"$f":"'Output | Price Caps'!$I34*'Inputs | Price Cap'!I69","v":0},{"$f":"'Output | Price Caps'!J34*'Inputs | Price Cap'!J69","v":0},{"$f":"'Output | Price Caps'!K34*'Inputs | Price Cap'!K69","v":0},{"$f":"'Output | Price Caps'!L34*'Inputs | Price Cap'!L69","v":0},{"$f":"'Output | Price Caps'!M34*'Inputs | Price Cap'!M69","v":0},{"$f":"'Output | Price Caps'!N34*'Inputs | Price Cap'!N69","v":0}]
[null,null,9,{"$f":"'Inputs | Price Cap'!D70","v":0},"Total",{"$f":"'Inputs | Price Cap'!F70","v":0},{"$f":"'Inputs | Price Cap'!G70","v":0},null,{"$f":"I35+I36","v":0},0,0,0,0,0]
[null,null,10,{"$f":"'Inputs | Price Cap'!D71","v":0},"Non-capital",{"$f":"'Inputs | Price Cap'!F71","v":0},{"$f":"'Inputs | Price Cap'!G71","v":0},null,{"$f":"'Output | Price Caps'!$I36*'Inputs | Price Cap'!I71","v":0},{"$f":"'Output | Price Caps'!J36*'Inputs | Price Cap'!J71","v":0},{"$f":"'Output | Price Caps'!K36*'Inputs | Price Cap'!K71","v":0},{"$f":"'Output | Price Caps'!L36*'Inputs | Price Cap'!L71","v":0},{"$f":"'Output | Price Caps'!M36*'Inputs | Price Cap'!M71","v":0},{"$f":"'Output | Price Caps'!N36*'Inputs | Price Cap'!N71","v":0}]
[null,null,10,{"$f":"'Inputs | Price Cap'!D72","v":0},"Capital",{"$f":"'Inputs | Price Cap'!F72","v":0},{"$f":"'Inputs | Price Cap'!G72","v":0},null,{"$f":"'Output | Price Caps'!$I37*'Inputs | Price Cap'!I72","v":0},{"$f":"'Output | Price Caps'!J37*'Inputs | Price Cap'!J72","v":0},{"$f":"'Output | Price Caps'!K37*'Inputs | Price Cap'!K72","v":0},{"$f":"'Output | Price Caps'!L37*'Inputs | Price Cap'!L72","v":0},{"$f":"'Output | Price Caps'!M37*'Inputs | Price Cap'!M72","v":0},{"$f":"'Output | Price Caps'!N37*'Inputs | Price Cap'!N72","v":0}]
[null,null,10,{"$f":"'Inputs | Price Cap'!D73","v":0},"Total",{"$f":"'Inputs | Price Cap'!F73","v":0},{"$f":"'Inputs | Price Cap'!G73","v":0},null,{"$f":"I38+I39","v":0},0,0,0,0,0]
[null,null,11,{"$f":"'Inputs | Price Cap'!D74","v":0},"Non-capital",{"$f":"'Inputs | Price Cap'!F74","v":0},{"$f":"'Inputs | Price Cap'!G74","v":0},null,{"$f":"'Output | Price Caps'!$I39*'Inputs | Price Cap'!I74","v":0},{"$f":"'Output | Price Caps'!J39*'Inputs | Price Cap'!J74","v":0},{"$f":"'Output | Price Caps'!K39*'Inputs | Price Cap'!K74","v":0},{"$f":"'Output | Price Caps'!L39*'Inputs | Price Cap'!L74","v":0},{"$f":"'Output | Price Caps'!M39*'Inputs | Price Cap'!M74","v":0},{"$f":"'Output | Price Caps'!N39*'Inputs | Price Cap'!N74","v":0}]
[null,null,11,{"$f":"'Inputs | Price Cap'!D75","v":0},"Capital",{"$f":"'Inputs | Price Cap'!F75","v":0},{"$f":"'Inputs | Price Cap'!G75","v":0},null,{"$f":"'Output | Price Caps'!$I40*'Inputs | Price Cap'!I75","v":0},{"$f":"'Output | Price Caps'!J40*'Inputs | Price Cap'!J75","v":0},{"$f":"'Output | Price Caps'!K40*'Inputs | Price Cap'!K75","v":0},{"$f":"'Output | Price Caps'!L40*'Inputs | Price Cap'!L75","v":0},{"$f":"'Output | Price Caps'!M40*'Inputs | Price Cap'!M75","v":0},{"$f":"'Output | Price Caps'!N40*'Inputs | Price Cap'!N75","v":0}]
[null,null,11,{"$f":"'Inputs | Price Cap'!D76","v":0},"Total",{"$f":"'Inputs | Price Cap'!F76","v":0},{"$f":"'Inputs | Price Cap'!G76","v":0},null,{"$f":"I41+I42","v":0},0,0,0,0,0]
[null,null,12,{"$f":"'Inputs | Price Cap'!D77","v":0},"Non-capital",{"$f":"'Inputs | Price Cap'!F77","v":0},{"$f":"'Inputs | Price Cap'!G77","v":0},null,{"$f":"'Output | Price Caps'!$I42*'Inputs | Price Cap'!I77","v":0},{"$f":"'Output | Price Caps'!J42*'Inputs | Price Cap'!J77","v":0},{"$f":"'Output | Price Caps'!K42*'Inputs | Price Cap'!K77","v":0},{"$f":"'Output | Price Caps'!L42*'Inputs | Price Cap'!L77","v":0},{"$f":"'Output | Price Caps'!M42*'Inputs | Price Cap'!M77","v":0},{"$f":"'Output | Price Caps'!N42*'Inputs | Price Cap'!N77","v":0}]
[null,null,12,{"$f":"'Inputs | Price Cap'!D78","v":0},"Capital",{"$f":"'Inputs | Price Cap'!F78","v":0},{"$f":"'Inputs | Price Cap'!G78","v":0},null,{"$f":"'Output | Price Caps'!$I43*'Inputs | Price Cap'!I78","v":0},{"$f":"'Output | Price Caps'!J43*'Inputs | Price Cap'!J78","v":0},{"$f":"'Output | Price Caps'!K43*'Inputs | Price Cap'!K78","v":0},{"$f":"'Output | Price Caps'!L43*'Inputs | Price Cap'!L78","v":0},{"$f":"'Output | Price Caps'!M43*'Inputs | Price Cap'!M78","v":0},{"$f":"'Output | Price Caps'!N43*'Inputs | Price Cap'!N78","v":0}]
[null,null,12,{"$f":"'Inputs | Price Cap'!D79","v":0},"Total",{"$f":"'Inputs | Price Cap'!F79","v":0},{"$f":"'Inputs | Price Cap'!G79","v":0},null,{"$f":"I44+I45","v":0},0,0,0,0,0]
[null,null,13,{"$f":"'Inputs | Price Cap'!D80","v":0},"Non-capital",{"$f":"'Inputs | Price Cap'!F80","v":0},{"$f":"'Inputs | Price Cap'!G80","v":0},null,{"$f":"'Output | Price Caps'!$I45*'Inputs | Price Cap'!I80","v":0},{"$f":"'Output | Price Caps'!J45*'Inputs | Price Cap'!J80","v":0},{"$f":"'Output | Price Caps'!K45*'Inputs | Price Cap'!K80","v":0},{"$f":"'Output | Price Caps'!L45*'Inputs | Price Cap'!L80","v":0},{"$f":"'Output | Price Caps'!M45*'Inputs | Price Cap'!M80","v":0},{"$f":"'Output | Price Caps'!N45*'Inputs | Price Cap'!N80","v":0}]
[null,null,13,{"$f":"'Inputs | Price Cap'!D81","v":0},"Capital",{"$f":"'Inputs | Price Cap'!F81","v":0},{"$f":"'Inputs | Price Cap'!G81","v":0},null,{"$f":"'Output | Price Caps'!$I46*'Inputs | Price Cap'!I81","v":0},{"$f":"'Output | Price Caps'!J46*'Inputs | Price Cap'!J81","v":0},{"$f":"'Output | Price Caps'!K46*'Inputs | Price Cap'!K81","v":0},{"$f":"'Output | Price Caps'!L46*'Inputs | Price Cap'!L81","v":0},{"$f":"'Output | Price Caps'!M46*'Inputs | Price Cap'!M81","v":0},{"$f":"'Output | Price Caps'!N46*'Inputs | Price Cap'!N81","v":0}]
[null,null,13,{"$f":"'Inputs | Price Cap'!D82","v":0},"Total",{"$f":"'Inputs | Price Cap'!F82","v":0},{"$f":"'Inputs | Price Cap'!G82","v":0},null,{"$f":"I47+I48","v":0},0,0,0,0,0]
[null,null,14,{"$f":"'Inputs | Price Cap'!D83","v":0},"Non-capital",{"$f":"'Inputs | Price Cap'!F83","v":0},{"$f":"'Inputs | Price Cap'!G83","v":0},null,{"$f":"'Output | Price Caps'!$I48*'Inputs | Price Cap'!I83","v":0},{"$f":"'Output | Price Caps'!J48*'Inputs | Price Cap'!J83","v":0},{"$f":"'Output | Price Caps'!K48*'Inputs | Price Cap'!K83","v":0},{"$f":"'Output | Price Caps'!L48*'Inputs | Price Cap'!L83","v":0},{"$f":"'Output | Price Caps'!M48*'Inputs | Price Cap'!M83","v":0},{"$f":"'Output | Price Caps'!N48*'Inputs | Price Cap'!N83","v":0}]
[null,null,14,{"$f":"'Inputs | Price Cap'!D84","v":0},"Capital",{"$f":"'Inputs | Price Cap'!F84","v":0},{"$f":"'Inputs | Price Cap'!G84","v":0},null,{"$f":"'Output | Price Caps'!$I49*'Inputs | Price Cap'!I84","v":0},{"$f":"'Output | Price Caps'!J49*'Inputs | Price Cap'!J84","v":0},{"$f":"'Output | Price Caps'!K49*'Inputs | Price Cap'!K84","v":0},{"$f":"'Output | Price Caps'!L49*'Inputs | Price Cap'!L84","v":0},{"$f":"'Output | Price Caps'!M49*'Inputs | Price Cap'!M84","v":0},{"$f":"'Output | Price Caps'!N49*'Inputs | Price Cap'!N84","v":0}]
[null,null,14,{"$f":"'Inputs | Price Cap'!D85","v":0},"Total",{"$f":"'Inputs | Price Cap'!F85","v":0},{"$f":"'Inputs | Price Cap'!G85","v":0},null,{"$f":"I50+I51","v":0},0,0,0,0,0]
[null,null,15,{"$f":"'Inputs | Price Cap'!D86","v":0},"Non-capital",{"$f":"'Inputs | Price Cap'!F86","v":0},{"$f":"'Inputs | Price Cap'!G86","v":0},null,{"$f":"'Output | Price Caps'!$I51*'Inputs | Price Cap'!I86","v":0},{"$f":"'Output | Price Caps'!J51*'Inputs | Price Cap'!J86","v":0},{"$f":"'Output | Price Caps'!K51*'Inputs | Price Cap'!K86","v":0},{"$f":"'Output | Price Caps'!L51*'Inputs | Price Cap'!L86","v":0},{"$f":"'Output | Price Caps'!M51*'Inputs | Price Cap'!M86","v":0},{"$f":"'Output | Price Caps'!N51*'Inputs | Price Cap'!N86","v":0}]
[null,null,15,{"$f":"'Inputs | Price Cap'!D87","v":0},"Capital",{"$f":"'Inputs | Price Cap'!F87","v":0},{"$f":"'Inputs | Price Cap'!G87","v":0},null,{"$f":"'Output | Price Caps'!$I52*'Inputs | Price Cap'!I87","v":0},{"$f":"'Output | Price Caps'!J52*'Inputs | Price Cap'!J87","v":0},{"$f":"'Output | Price Caps'!K52*'Inputs | Price Cap'!K87","v":0},{"$f":"'Output | Price Caps'!L52*'Inputs | Price Cap'!L87","v":0},{"$f":"'Output | Price Caps'!M52*'Inputs | Price Cap'!M87","v":0},{"$f":"'Output | Price Caps'!N52*'Inputs | Price Cap'!N87","v":0}]
[null,null,15,{"$f":"'Inputs | Price Cap'!D88","v":0},"Total",{"$f":"'Inputs | Price Cap'!F88","v":0},{"$f":"'Inputs | Price Cap'!G88","v":0},null,{"$f":"I53+I54","v":0},0,0,0,0,0]
[]
[null,"Total Smoothed Revenue"]
[null,null,null,null,"Application",null,null,null,{"$f":"LEFT(J58,4)-1&\"-\"&RIGHT(J58,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(J58,4)+1&\"-\"&RIGHT(J58,2)+1","v":"2027-28"},{"$f":"LEFT(K58,4)+1&\"-\"&RIGHT(K58,2)+1","v":"2028-29"},"2029-30","2030-31"]
[null,null,null,null,"Non-capital",null,null,null,{"$f":"SUMIFS('Calc | Price Cap'!I$11:I$55,'Output | Price Caps'!$E$9:$E$53,$E59)","v":18500000},{"$f":"SUMIFS('Calc | Price Cap'!J$11:J$55,'Output | Price Caps'!$E$9:$E$53,$E59)","v":21749220},{"$f":"SUMIFS('Calc | Price Cap'!K$11:K$55,'Output | Price Caps'!$E$9:$E$53,$E59)","v":20282076},{"$f":"SUMIFS('Calc | Price Cap'!L$11:L$55,'Output | Price Caps'!$E$9:$E$53,$E59)","v":18915144.300000001},{"$f":"SUMIFS('Calc | Price Cap'!M$11:M$55,'Output | Price Caps'!$E$9:$E$53,$E59)","v":17642266.560000002},{"$f":"SUMIFS('Calc | Price Cap'!N$11:N$55,'Output | Price Caps'!$E$9:$E$53,$E59)","v":16454476.242000001}]
[null,null,null,null,"Capital",null,null,null,{"$f":"SUMIFS('Calc | Price Cap'!I$11:I$55,'Output | Price Caps'!$E$9:$E$53,$E60)","v":34900000},{"$f":"SUMIFS('Calc | Price Cap'!J$11:J$55,'Output | Price Caps'!$E$9:$E$53,$E60)","v":31320750},{"$f":"SUMIFS('Calc | Price Cap'!K$11:K$55,'Output | Price Caps'!$E$9:$E$53,$E60)","v":31165650},{"$f":"SUMIFS('Calc | Price Cap'!L$11:L$55,'Output | Price Caps'!$E$9:$E$53,$E60)","v":31010550},{"$f":"SUMIFS('Calc | Price Cap'!M$11:M$55,'Output | Price Caps'!$E$9:$E$53,$E60)","v":30870300},{"$f":"SUMIFS('Calc | Price Cap'!N$11:N$55,'Output | Price Caps'!$E$9:$E$53,$E60)","v":30730050}]
[null,null,null,null,"Total",null,null,null,{"$f":"SUMIFS('Calc | Price Cap'!I$11:I$55,'Output | Price Caps'!$E$9:$E$53,$E61)","v":53400000},{"$f":"SUMIFS('Calc | Price Cap'!J$11:J$55,'Output | Price Caps'!$E$9:$E$53,$E61)","v":53069970},{"$f":"SUMIFS('Calc | Price Cap'!K$11:K$55,'Output | Price Caps'!$E$9:$E$53,$E61)","v":51447726},{"$f":"SUMIFS('Calc | Price Cap'!L$11:L$55,'Output | Price Caps'!$E$9:$E$53,$E61)","v":49925694.299999997},{"$f":"SUMIFS('Calc | Price Cap'!M$11:M$55,'Output | Price Caps'!$E$9:$E$53,$E61)","v":48512566.559999995},{"$f":"SUMIFS('Calc | Price Cap'!N$11:N$55,'Output | Price Caps'!$E$9:$E$53,$E61)","v":47184526.241999999}]
[]
[null,null,null,null,null,null,null,null,{"$f":"(ROUND(I59+I60,0)=ROUND(I61,0))/1","v":1},1,1,1,1,1]

{"sheet":"Output | Price Caps","index":6,"n_rows":70,"n_cols":22,"rows_kept":70,"cut":false,"hidden":false,"merged":[[56,3,57,3],[65,9,65,13],[5,9,5,13],[1,10,1,11],[0,14,0,15]]}
[null,null,{"$f":"'Title Page'!B8&\" v\"&'Title Page'!$C$10","v":"Final Standardised Metering Pricing Model  v1.02"},null,null,null,null,null,null,null,null,null,null,"DNSP:",{"$f":"IF('Inputs | General'!$G$16=\"Exit Fees (Vic)\",\"NOT USED\",NSP)","v":"NOT USED"},null,null,null,null,null,"Worksheet check:",{"$f":"IF(COUNTA($W$5:$W$52)=COUNTIF($W5:$W53,\"OK\"),\"OK\",\"Check\")","v":"OK"}]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"Output | Price Caps"},null,null,null,null,"Key:","Input","External Link","Internal Link"]
[]
[]
[null,"RESULT - Price Cap - Annual Charges"]
[null,null,null,null,null,null,null,null,"Base Year Charges","Price Cap - Annual Charges (nominal)"]
["▼ Table Filters",null,"Tariff #","Tariff name","Application","Tariff Code","Other designation",null,{"$f":"LEFT(J7,4)-1&\"-\"&RIGHT(J7,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(J7,4)+1&\"-\"&RIGHT(J7,2)+1","v":"2027-28"},{"$f":"LEFT(K7,4)+1&\"-\"&RIGHT(K7,2)+1","v":"2028-29"},"2029-30","2030-31"]
[null,null,"Tariff #","Tariff name","Application","Tariff Code","Other designation","Ca","F-RP-1","F-RP0","F-RP+1","F-RP+2","F-RP+3","F-RP+4","Column1"]
[null,null,1,{"$f":"'Inputs | Price Cap'!D44","v":"Residential Non ToU"},"Non-capital",{"$f":"'Inputs | Price Cap'!F44","v":"R1"},{"$f":"'Inputs | Price Cap'!G44","v":"Primary"},null,{"$f":"ROUND('Inputs | Price Cap'!H44,2)","v":10},{"$f":"ROUND('Output | Price Caps'!I9*(1-'Inputs | Price Cap'!F$109)*(1+'Inputs | General'!J$26),2)","v":13.06},{"$f":"ROUND('Output | Price Caps'!J9*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!K$26),2)","v":13.53},{"$f":"ROUND('Output | Price Caps'!K9*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!L$26),2)","v":14.02},{"$f":"ROUND('Output | Price Caps'!L9*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!M$26),2)","v":14.53},{"$f":"ROUND('Output | Price Caps'!M9*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!N$26),2)","v":15.06}]
[null,null,1,{"$f":"'Inputs | Price Cap'!D45","v":"Residential Non ToU"},"Capital",{"$f":"'Inputs | Price Cap'!F45","v":"R1"},{"$f":"'Inputs | Price Cap'!G45","v":"Primary"},null,{"$f":"ROUND('Inputs | Price Cap'!H45,2)","v":20},{"$f":"ROUND('Output | Price Caps'!I10*(1-'Inputs | Price Cap'!F$125)*(1+'Inputs | General'!J$26),2)","v":17.95},{"$f":"ROUND('Output | Price Caps'!J10*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!K$26),2)","v":17.86},{"$f":"ROUND('Output | Price Caps'!K10*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!L$26),2)","v":17.77},{"$f":"ROUND('Output | Price Caps'!L10*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!M$26),2)","v":17.690000000000001},{"$f":"ROUND('Output | Price Caps'!M10*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!N$26),2)","v":17.61}]
[null,null,1,{"$f":"'Inputs | Price Cap'!D46","v":"Residential Non ToU"},"Total",{"$f":"'Inputs | Price Cap'!F46","v":"R1"},{"$f":"'Inputs | Price Cap'!G46","v":"Primary"},null,{"$f":"ROUND('Inputs | Price Cap'!H46,2)","v":30},{"$f":"J9+J10","v":31.009999999999998},{"$f":"K9+K10","v":31.39},{"$f":"L9+L10","v":31.79},{"$f":"M9+M10","v":32.22},{"$f":"N9+N10","v":32.67}]
[null,null,2,{"$f":"'Inputs | Price Cap'!D47","v":"Residential ToU"},"Non-capital",{"$f":"'Inputs | Price Cap'!F47","v":"R2"},{"$f":"'Inputs | Price Cap'!G47","v":"Primary"},null,{"$f":"ROUND('Inputs | Price Cap'!H47,2)","v":20},{"$f":"ROUND('Output | Price Caps'!I12*(1-'Inputs | Price Cap'!F$109)*(1+'Inputs | General'!J$26),2)","v":26.13},{"$f":"ROUND('Output | Price Caps'!J12*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!K$26),2)","v":27.08},{"$f":"ROUND('Output | Price Caps'!K12*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!L$26),2)","v":28.06},{"$f":"ROUND('Output | Price Caps'!L12*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!M$26),2)","v":29.08},{"$f":"ROUND('Output | Price Caps'!M12*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!N$26),2)","v":30.13}]
[null,null,2,{"$f":"'Inputs | Price Cap'!D48","v":"Residential ToU"},"Capital",{"$f":"'Inputs | Price Cap'!F48","v":"R2"},{"$f":"'Inputs | Price Cap'!G48","v":"Primary"},null,{"$f":"ROUND('Inputs | Price Cap'!H48,2)","v":20},{"$f":"ROUND('Output | Price Caps'!I13*(1-'Inputs | Price Cap'!F$125)*(1+'Inputs | General'!J$26),2)","v":17.95},{"$f":"ROUND('Output | Price Caps'!J13*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!K$26),2)","v":17.86},{"$f":"ROUND('Output | Price Caps'!K13*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!L$26),2)","v":17.77},{"$f":"ROUND('Output | Price Caps'!L13*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!M$26),2)","v":17.690000000000001},{"$f":"ROUND('Output | Price Caps'!M13*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!N$26),2)","v":17.61}]
[null,null,2,{"$f":"'Inputs | Price Cap'!D49","v":"Residential ToU"},"Total",{"$f":"'Inputs | Price Cap'!F49","v":"R2"},{"$f":"'Inputs | Price Cap'!G49","v":"Primary"},null,{"$f":"ROUND('Inputs | Price Cap'!H49,2)","v":40},{"$f":"J12+J13","v":44.08},{"$f":"K12+K13","v":44.94},{"$f":"L12+L13","v":45.83},{"$f":"M12+M13","v":46.769999999999996},{"$f":"N12+N13","v":47.739999999999995}]
[null,null,3,{"$f":"'Inputs | Price Cap'!D50","v":"Controlled load"},"Non-capital",{"$f":"'Inputs | Price Cap'!F50","v":"B1"},{"$f":"'Inputs | Price Cap'!G50","v":"Secondary"},null,{"$f":"ROUND('Inputs | Price Cap'!H50,2)","v":1},{"$f":"ROUND('Output | Price Caps'!I15*(1-'Inputs | Price Cap'!F$109)*(1+'Inputs | General'!J$26),2)","v":1.31},{"$f":"ROUND('Output | Price Caps'!J15*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!K$26),2)","v":1.36},{"$f":"ROUND('Output | Price Caps'!K15*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!L$26),2)","v":1.41},{"$f":"ROUND('Output | Price Caps'!L15*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!M$26),2)","v":1.46},{"$f":"ROUND('Output | Price Caps'!M15*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!N$26),2)","v":1.51}]
[null,null,3,{"$f":"'Inputs | Price Cap'!D51","v":"Controlled load"},"Capital",{"$f":"'Inputs | Price Cap'!F51","v":"B1"},{"$f":"'Inputs | Price Cap'!G51","v":"Secondary"},null,{"$f":"ROUND('Inputs | Price Cap'!H51,2)","v":10},{"$f":"ROUND('Output | Price Caps'!I16*(1-'Inputs | Price Cap'!F$125)*(1+'Inputs | General'!J$26),2)","v":8.9700000000000006},{"$f":"ROUND('Output | Price Caps'!J16*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!K$26),2)","v":8.93},{"$f":"ROUND('Output | Price Caps'!K16*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!L$26),2)","v":8.89},{"$f":"ROUND('Output | Price Caps'!L16*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!M$26),2)","v":8.85},{"$f":"ROUND('Output | Price Caps'!M16*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!N$26),2)","v":8.81}]
[null,null,3,{"$f":"'Inputs | Price Cap'!D52","v":"Controlled load"},"Total",{"$f":"'Inputs | Price Cap'!F52","v":"B1"},{"$f":"'Inputs | Price Cap'!G52","v":"Secondary"},null,{"$f":"ROUND('Inputs | Price Cap'!H52,2)","v":11},{"$f":"J15+J16","v":10.280000000000001},{"$f":"K15+K16","v":10.29},{"$f":"L15+L16","v":10.3},{"$f":"M15+M16","v":10.309999999999999},{"$f":"N15+N16","v":10.32}]
[null,null,4,{"$f":"'Inputs | Price Cap'!D53","v":"Small Business Non ToU"},"Non-capital",{"$f":"'Inputs | Price Cap'!F53","v":"B2"},{"$f":"'Inputs | Price Cap'!G53","v":"Primary"},null,{"$f":"ROUND('Inputs | Price Cap'!H53,2)","v":10},{"$f":"ROUND('Output | Price Caps'!I18*(1-'Inputs | Price Cap'!F$109)*(1+'Inputs | General'!J$26),2)","v":13.06},{"$f":"ROUND('Output | Price Caps'!J18*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!K$26),2)","v":13.53},{"$f":"ROUND('Output | Price Caps'!K18*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!L$26),2)","v":14.02},{"$f":"ROUND('Output | Price Caps'!L18*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!M$26),2)","v":14.53},{"$f":"ROUND('Output | Price Caps'!M18*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!N$26),2)","v":15.06}]
[null,null,4,{"$f":"'Inputs | Price Cap'!D54","v":"Small Business Non ToU"},"Capital",{"$f":"'Inputs | Price Cap'!F54","v":"B2"},{"$f":"'Inputs | Price Cap'!G54","v":"Primary"},null,{"$f":"ROUND('Inputs | Price Cap'!H54,2)","v":30},{"$f":"ROUND('Output | Price Caps'!I19*(1-'Inputs | Price Cap'!F$125)*(1+'Inputs | General'!J$26),2)","v":26.92},{"$f":"ROUND('Output | Price Caps'!J19*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!K$26),2)","v":26.79},{"$f":"ROUND('Output | Price Caps'!K19*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!L$26),2)","v":26.66},{"$f":"ROUND('Output | Price Caps'!L19*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!M$26),2)","v":26.53},{"$f":"ROUND('Output | Price Caps'!M19*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!N$26),2)","v":26.4}]
[null,null,4,{"$f":"'Inputs | Price Cap'!D55","v":"Small Business Non ToU"},"Total",{"$f":"'Inputs | Price Cap'!F55","v":"B2"},{"$f":"'Inputs | Price Cap'!G55","v":"Primary"},null,{"$f":"ROUND('Inputs | Price Cap'!H55,2)","v":40},{"$f":"J18+J19","v":39.980000000000004},{"$f":"K18+K19","v":40.32},{"$f":"L18+L19","v":40.68},{"$f":"M18+M19","v":41.06},{"$f":"N18+N19","v":41.46}]
[null,null,5,{"$f":"'Inputs | Price Cap'!D56","v":"Small Business ToU"},"Non-capital",{"$f":"'Inputs | Price Cap'!F56","v":"LV1"},{"$f":"'Inputs | Price Cap'!G56","v":"Primary"},null,{"$f":"ROUND('Inputs | Price Cap'!H56,2)","v":25},{"$f":"ROUND('Output | Price Caps'!I21*(1-'Inputs | Price Cap'!F$109)*(1+'Inputs | General'!J$26),2)","v":32.659999999999997},{"$f":"ROUND('Output | Price Caps'!J21*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!K$26),2)","v":33.840000000000003},{"$f":"ROUND('Output | Price Caps'!K21*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!L$26),2)","v":35.07},{"$f":"ROUND('Output | Price Caps'!L21*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!M$26),2)","v":36.340000000000003},{"$f":"ROUND('Output | Price Caps'!M21*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!N$26),2)","v":37.659999999999997}]
[null,null,5,{"$f":"'Inputs | Price Cap'!D57","v":"Small Business ToU"},"Capital",{"$f":"'Inputs | Price Cap'!F57","v":"LV1"},{"$f":"'Inputs | Price Cap'!G57","v":"Primary"},null,{"$f":"ROUND('Inputs | Price Cap'!H57,2)","v":20},{"$f":"ROUND('Output | Price Caps'!I22*(1-'Inputs | Price Cap'!F$125)*(1+'Inputs | General'!J$26),2)","v":17.95},{"$f":"ROUND('Output | Price Caps'!J22*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!K$26),2)","v":17.86},{"$f":"ROUND('Output | Price Caps'!K22*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!L$26),2)","v":17.77},{"$f":"ROUND('Output | Price Caps'!L22*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!M$26),2)","v":17.690000000000001},{"$f":"ROUND('Output | Price Caps'!M22*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!N$26),2)","v":17.61}]
[null,null,5,{"$f":"'Inputs | Price Cap'!D58","v":"Small Business ToU"},"Total",{"$f":"'Inputs | Price Cap'!F58","v":"LV1"},{"$f":"'Inputs | Price Cap'!G58","v":"Primary"},null,{"$f":"ROUND('Inputs | Price Cap'!H58,2)","v":45},{"$f":"J21+J22","v":50.61},{"$f":"K21+K22","v":51.7},{"$f":"L21+L22","v":52.84},{"$f":"M21+M22","v":54.03},{"$f":"N21+N22","v":55.269999999999996}]
[null,null,6,{"$f":"'Inputs | Price Cap'!D59","v":"LV 40-160 MWh (System)"},"Non-capital",{"$f":"'Inputs | Price Cap'!F59","v":0},{"$f":"'Inputs | Price Cap'!G59","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H59,2)","v":45},{"$f":"ROUND('Output | Price Caps'!I24*(1-'Inputs | Price Cap'!F$109)*(1+'Inputs | General'!J$26),2)","v":58.78},{"$f":"ROUND('Output | Price Caps'!J24*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!K$26),2)","v":60.91},{"$f":"ROUND('Output | Price Caps'!K24*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!L$26),2)","v":63.12},{"$f":"ROUND('Output | Price Caps'!L24*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!M$26),2)","v":65.41},{"$f":"ROUND('Output | Price Caps'!M24*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!N$26),2)","v":67.78}]
[null,null,6,{"$f":"'Inputs | Price Cap'!D60","v":"LV 40-160 MWh (System)"},"Capital",{"$f":"'Inputs | Price Cap'!F60","v":0},{"$f":"'Inputs | Price Cap'!G60","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H60,2)","v":25},{"$f":"ROUND('Output | Price Caps'!I25*(1-'Inputs | Price Cap'!F$125)*(1+'Inputs | General'!J$26),2)","v":22.43},{"$f":"ROUND('Output | Price Caps'!J25*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!K$26),2)","v":22.32},{"$f":"ROUND('Output | Price Caps'!K25*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!L$26),2)","v":22.21},{"$f":"ROUND('Output | Price Caps'!L25*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!M$26),2)","v":22.1},{"$f":"ROUND('Output | Price Caps'!M25*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!N$26),2)","v":21.99}]
[null,null,6,{"$f":"'Inputs | Price Cap'!D61","v":"LV 40-160 MWh (System)"},"Total",{"$f":"'Inputs | Price Cap'!F61","v":0},{"$f":"'Inputs | Price Cap'!G61","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H61,2)","v":70},{"$f":"J24+J25","v":81.210000000000008},{"$f":"K24+K25","v":83.22999999999999},{"$f":"L24+L25","v":85.33},{"$f":"M24+M25","v":87.509999999999991},{"$f":"N24+N25","v":89.77}]
[null,null,7,{"$f":"'Inputs | Price Cap'!D62","v":0},"Non-capital",{"$f":"'Inputs | Price Cap'!F62","v":0},{"$f":"'Inputs | Price Cap'!G62","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H62,2)","v":0},{"$f":"ROUND('Output | Price Caps'!I27*(1-'Inputs | Price Cap'!F$109)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J27*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K27*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!L$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L27*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!M$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M27*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!N$26),2)","v":0}]
[null,null,7,{"$f":"'Inputs | Price Cap'!D63","v":0},"Capital",{"$f":"'Inputs | Price Cap'!F63","v":0},{"$f":"'Inputs | Price Cap'!G63","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H63,2)","v":0},{"$f":"ROUND('Output | Price Caps'!I28*(1-'Inputs | Price Cap'!F$125)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J28*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K28*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!L$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L28*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!M$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M28*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!N$26),2)","v":0}]
[null,null,7,{"$f":"'Inputs | Price Cap'!D64","v":0},"Total",{"$f":"'Inputs | Price Cap'!F64","v":0},{"$f":"'Inputs | Price Cap'!G64","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H64,2)","v":0},{"$f":"J27+J28","v":0},{"$f":"K27+K28","v":0},{"$f":"L27+L28","v":0},{"$f":"M27+M28","v":0},{"$f":"N27+N28","v":0}]
[null,null,8,{"$f":"'Inputs | Price Cap'!D65","v":0},"Non-capital",{"$f":"'Inputs | Price Cap'!F65","v":0},{"$f":"'Inputs | Price Cap'!G65","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H65,2)","v":0},{"$f":"ROUND('Output | Price Caps'!I30*(1-'Inputs | Price Cap'!F$109)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J30*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K30*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!L$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L30*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!M$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M30*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!N$26),2)","v":0}]
[null,null,8,{"$f":"'Inputs | Price Cap'!D66","v":0},"Capital",{"$f":"'Inputs | Price Cap'!F66","v":0},{"$f":"'Inputs | Price Cap'!G66","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H66,2)","v":0},{"$f":"ROUND('Output | Price Caps'!I31*(1-'Inputs | Price Cap'!F$125)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J31*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K31*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!L$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L31*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!M$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M31*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!N$26),2)","v":0}]
[null,null,8,{"$f":"'Inputs | Price Cap'!D67","v":0},"Total",{"$f":"'Inputs | Price Cap'!F67","v":0},{"$f":"'Inputs | Price Cap'!G67","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H67,2)","v":0},{"$f":"J30+J31","v":0},{"$f":"K30+K31","v":0},{"$f":"L30+L31","v":0},{"$f":"M30+M31","v":0},{"$f":"N30+N31","v":0}]
[null,null,9,{"$f":"'Inputs | Price Cap'!D68","v":0},"Non-capital",{"$f":"'Inputs | Price Cap'!F68","v":0},{"$f":"'Inputs | Price Cap'!G68","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H68,2)","v":0},{"$f":"ROUND('Output | Price Caps'!I33*(1-'Inputs | Price Cap'!F$109)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J33*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K33*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!L$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L33*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!M$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M33*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!N$26),2)","v":0}]
[null,null,9,{"$f":"'Inputs | Price Cap'!D69","v":0},"Capital",{"$f":"'Inputs | Price Cap'!F69","v":0},{"$f":"'Inputs | Price Cap'!G69","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H69,2)","v":0},{"$f":"ROUND('Output | Price Caps'!I34*(1-'Inputs | Price Cap'!F$125)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J34*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K34*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!L$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L34*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!M$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M34*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!N$26),2)","v":0}]
[null,null,9,{"$f":"'Inputs | Price Cap'!D70","v":0},"Total",{"$f":"'Inputs | Price Cap'!F70","v":0},{"$f":"'Inputs | Price Cap'!G70","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H70,2)","v":0},{"$f":"J33+J34","v":0},{"$f":"K33+K34","v":0},{"$f":"L33+L34","v":0},{"$f":"M33+M34","v":0},{"$f":"N33+N34","v":0}]
[null,null,10,{"$f":"'Inputs | Price Cap'!D71","v":0},"Non-capital",{"$f":"'Inputs | Price Cap'!F71","v":0},{"$f":"'Inputs | Price Cap'!G71","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H71,2)","v":0},{"$f":"ROUND('Output | Price Caps'!I36*(1-'Inputs | Price Cap'!F$109)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J36*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K36*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!L$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L36*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!M$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M36*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!N$26),2)","v":0}]
[null,null,10,{"$f":"'Inputs | Price Cap'!D72","v":0},"Capital",{"$f":"'Inputs | Price Cap'!F72","v":0},{"$f":"'Inputs | Price Cap'!G72","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H72,2)","v":0},{"$f":"ROUND('Output | Price Caps'!I37*(1-'Inputs | Price Cap'!F$125)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J37*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K37*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!L$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L37*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!M$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M37*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!N$26),2)","v":0}]
[null,null,10,{"$f":"'Inputs | Price Cap'!D73","v":0},"Total",{"$f":"'Inputs | Price Cap'!F73","v":0},{"$f":"'Inputs | Price Cap'!G73","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H73,2)","v":0},{"$f":"J36+J37","v":0},{"$f":"K36+K37","v":0},{"$f":"L36+L37","v":0},{"$f":"M36+M37","v":0},{"$f":"N36+N37","v":0}]
[null,null,11,{"$f":"'Inputs | Price Cap'!D74","v":0},"Non-capital",{"$f":"'Inputs | Price Cap'!F74","v":0},{"$f":"'Inputs | Price Cap'!G74","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H74,2)","v":0},{"$f":"ROUND('Output | Price Caps'!I39*(1-'Inputs | Price Cap'!F$109)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J39*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K39*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!L$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L39*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!M$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M39*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!N$26),2)","v":0}]
[null,null,11,{"$f":"'Inputs | Price Cap'!D75","v":0},"Capital",{"$f":"'Inputs | Price Cap'!F75","v":0},{"$f":"'Inputs | Price Cap'!G75","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H75,2)","v":0},{"$f":"ROUND('Output | Price Caps'!I40*(1-'Inputs | Price Cap'!F$125)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J40*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K40*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!L$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L40*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!M$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M40*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!N$26),2)","v":0}]
[null,null,11,{"$f":"'Inputs | Price Cap'!D76","v":0},"Total",{"$f":"'Inputs | Price Cap'!F76","v":0},{"$f":"'Inputs | Price Cap'!G76","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H76,2)","v":0},{"$f":"J39+J40","v":0},{"$f":"K39+K40","v":0},{"$f":"L39+L40","v":0},{"$f":"M39+M40","v":0},{"$f":"N39+N40","v":0}]
[null,null,12,{"$f":"'Inputs | Price Cap'!D77","v":0},"Non-capital",{"$f":"'Inputs | Price Cap'!F77","v":0},{"$f":"'Inputs | Price Cap'!G77","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H77,2)","v":0},{"$f":"ROUND('Output | Price Caps'!I42*(1-'Inputs | Price Cap'!F$109)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J42*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K42*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!L$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L42*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!M$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M42*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!N$26),2)","v":0}]
[null,null,12,{"$f":"'Inputs | Price Cap'!D78","v":0},"Capital",{"$f":"'Inputs | Price Cap'!F78","v":0},{"$f":"'Inputs | Price Cap'!G78","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H78,2)","v":0},{"$f":"ROUND('Output | Price Caps'!I43*(1-'Inputs | Price Cap'!F$125)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J43*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K43*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!L$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L43*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!M$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M43*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!N$26),2)","v":0}]
[null,null,12,{"$f":"'Inputs | Price Cap'!D79","v":0},"Total",{"$f":"'Inputs | Price Cap'!F79","v":0},{"$f":"'Inputs | Price Cap'!G79","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H79,2)","v":0},{"$f":"J42+J43","v":0},{"$f":"K42+K43","v":0},{"$f":"L42+L43","v":0},{"$f":"M42+M43","v":0},{"$f":"N42+N43","v":0}]
[null,null,13,{"$f":"'Inputs | Price Cap'!D80","v":0},"Non-capital",{"$f":"'Inputs | Price Cap'!F80","v":0},{"$f":"'Inputs | Price Cap'!G80","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H80,2)","v":0},{"$f":"ROUND('Output | Price Caps'!I45*(1-'Inputs | Price Cap'!F$109)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J45*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K45*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!L$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L45*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!M$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M45*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!N$26),2)","v":0}]
[null,null,13,{"$f":"'Inputs | Price Cap'!D81","v":0},"Capital",{"$f":"'Inputs | Price Cap'!F81","v":0},{"$f":"'Inputs | Price Cap'!G81","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H81,2)","v":0},{"$f":"ROUND('Output | Price Caps'!I46*(1-'Inputs | Price Cap'!F$125)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J46*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K46*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!L$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L46*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!M$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M46*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!N$26),2)","v":0}]
[null,null,13,{"$f":"'Inputs | Price Cap'!D82","v":0},"Total",{"$f":"'Inputs | Price Cap'!F82","v":0},{"$f":"'Inputs | Price Cap'!G82","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H82,2)","v":0},{"$f":"J45+J46","v":0},{"$f":"K45+K46","v":0},{"$f":"L45+L46","v":0},{"$f":"M45+M46","v":0},{"$f":"N45+N46","v":0}]
[null,null,14,{"$f":"'Inputs | Price Cap'!D83","v":0},"Non-capital",{"$f":"'Inputs | Price Cap'!F83","v":0},{"$f":"'Inputs | Price Cap'!G83","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H83,2)","v":0},{"$f":"ROUND('Output | Price Caps'!I48*(1-'Inputs | Price Cap'!F$109)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J48*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K48*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!L$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L48*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!M$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M48*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!N$26),2)","v":0}]
[null,null,14,{"$f":"'Inputs | Price Cap'!D84","v":0},"Capital",{"$f":"'Inputs | Price Cap'!F84","v":0},{"$f":"'Inputs | Price Cap'!G84","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H84,2)","v":0},{"$f":"ROUND('Output | Price Caps'!I49*(1-'Inputs | Price Cap'!F$125)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J49*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K49*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!L$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L49*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!M$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M49*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!N$26),2)","v":0}]
[null,null,14,{"$f":"'Inputs | Price Cap'!D85","v":0},"Total",{"$f":"'Inputs | Price Cap'!F85","v":0},{"$f":"'Inputs | Price Cap'!G85","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H85,2)","v":0},{"$f":"J48+J49","v":0},{"$f":"K48+K49","v":0},{"$f":"L48+L49","v":0},{"$f":"M48+M49","v":0},{"$f":"N48+N49","v":0}]
[null,null,15,{"$f":"'Inputs | Price Cap'!D86","v":0},"Non-capital",{"$f":"'Inputs | Price Cap'!F86","v":0},{"$f":"'Inputs | Price Cap'!G86","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H86,2)","v":0},{"$f":"ROUND('Output | Price Caps'!I51*(1-'Inputs | Price Cap'!F$109)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J51*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K51*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!L$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L51*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!M$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M51*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!N$26),2)","v":0}]
[null,null,15,{"$f":"'Inputs | Price Cap'!D87","v":0},"Capital",{"$f":"'Inputs | Price Cap'!F87","v":0},{"$f":"'Inputs | Price Cap'!G87","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H87,2)","v":0},{"$f":"ROUND('Output | Price Caps'!I52*(1-'Inputs | Price Cap'!F$125)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J52*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K52*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!L$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L52*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!M$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M52*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!N$26),2)","v":0}]
[null,null,15,{"$f":"'Inputs | Price Cap'!D88","v":0},"Total",{"$f":"'Inputs | Price Cap'!F88","v":0},{"$f":"'Inputs | Price Cap'!G88","v":0},null,{"$f":"ROUND('Inputs | Price Cap'!H88,2)","v":0},{"$f":"J51+J52","v":0},{"$f":"K51+K52","v":0},{"$f":"L51+L52","v":0},{"$f":"M51+M52","v":0},{"$f":"N51+N52","v":0}]
[]
[]
[null,"Implicit X-Factors"]
[null,null,null,"X-Factors",{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(E57,4)+1&\"-\"&RIGHT(E57,2)+1","v":"2027-28"},{"$f":"LEFT(F57,4)+1&\"-\"&RIGHT(F57,2)+1","v":"2028-29"},{"$f":"LEFT(G57,4)+1&\"-\"&RIGHT(G57,2)+1","v":"2029-30"},{"$f":"LEFT(H57,4)+1&\"-\"&RIGHT(H57,2)+1","v":"2030-31"}]
[null,null,null,null,"P_0","X_02","X_03","X_04","X_05"]
[null,null,null,"All Tariffs - Non-Capital",{"$f":"NC_P_0_WAPC","v":-0.27315652200197316},{"$f":"NC_X_02_WAPC","v":-0.01},{"$f":"NC_X_03_WAPC","v":-0.01},{"$f":"NC_X_04_WAPC","v":-0.01},{"$f":"NC_X_05_WAPC","v":-0.01}]
[null,null,null,"All Tariffs - Capital",{"$f":"C_P_0_WAPC","v":0.12542117952813292},{"$f":"C_X_02_WAPC","v":0.03},{"$f":"C_X_03_WAPC","v":0.03},{"$f":"C_X_04_WAPC","v":0.03},{"$f":"C_X_05_WAPC","v":0.03}]
[]
[]
[]
[]
[null,"Cost Metric"]
[null,null,null,null,null,null,null,null,"Base Year Charges","Price Cap - Annual Charges"]
[null,null,null,"Price Cap Per Meter",null,"Application","Units","Basis",{"$f":"LEFT(J67,4)-1&\"-\"&RIGHT(J67,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(J67,4)+1&\"-\"&RIGHT(J67,2)+1","v":"2027-28"},{"$f":"LEFT(K67,4)+1&\"-\"&RIGHT(K67,2)+1","v":"2028-29"},{"$f":"LEFT(L67,4)+1&\"-\"&RIGHT(L67,2)+1","v":"2029-30"},{"$f":"LEFT(M67,4)+1&\"-\"&RIGHT(M67,2)+1","v":"2030-31"}]
[null,null,null,"Volume Weighted Average Price Cap - Per Meter",null,"Non-capital","$dollars","nominal",{"$f":"'Calc | Price Cap'!I59/'Inputs | Price Cap'!I90","v":10.818713450292398},{"$f":"'Calc | Price Cap'!J59/'Inputs | Price Cap'!J90","v":14.13204678362573},{"$f":"'Calc | Price Cap'!K59/'Inputs | Price Cap'!K90","v":14.643040935672515},{"$f":"'Calc | Price Cap'!L59/'Inputs | Price Cap'!L90","v":15.173508771929825},{"$f":"'Calc | Price Cap'!M59/'Inputs | Price Cap'!M90","v":15.724912280701757},{"$f":"'Calc | Price Cap'!N59/'Inputs | Price Cap'!N90","v":16.295789473684209}]
[null,null,null,"Volume Weighted Average Price Cap - Per Meter",null,"Capital","$dollars","nominal",{"$f":"'Calc | Price Cap'!I60/'Inputs | Price Cap'!I91","v":18.563829787234042},{"$f":"'Calc | Price Cap'!J60/'Inputs | Price Cap'!J91","v":16.659973404255318},{"$f":"'Calc | Price Cap'!K60/'Inputs | Price Cap'!K91","v":16.577473404255318},{"$f":"'Calc | Price Cap'!L60/'Inputs | Price Cap'!L91","v":16.494973404255319},{"$f":"'Calc | Price Cap'!M60/'Inputs | Price Cap'!M91","v":16.420372340425534},{"$f":"'Calc | Price Cap'!N60/'Inputs | Price Cap'!N91","v":16.345771276595745}]
[null,null,null,"Volume Weighted Average Price Cap - Per Non-Capital Meter",null,"Total","$dollars","nominal",{"$f":"'Calc | Price Cap'!I61/'Inputs | Price Cap'!I90","v":31.228070175438596},{"$f":"'Calc | Price Cap'!J61/'Inputs | Price Cap'!J90","v":34.483411306042882},{"$f":"'Calc | Price Cap'!K61/'Inputs | Price Cap'!K90","v":37.143690708252109},{"$f":"'Calc | Price Cap'!L61/'Inputs | Price Cap'!L90","v":40.049811325295401},{"$f":"'Calc | Price Cap'!M61/'Inputs | Price Cap'!M90","v":43.240240763469409},{"$f":"'Calc | Price Cap'!N61/'Inputs | Price Cap'!N90","v":46.729479246049891}]

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

{"sheet":"Input | Exit Fees","index":8,"n_rows":121,"n_cols":17,"rows_kept":121,"cut":false,"hidden":false,"merged":[[99,3,99,5],[96,3,96,5],[119,3,119,5],[68,9,68,14],[113,3,113,5],[114,3,114,5],[115,3,115,5],[116,3,116,5],[118,3,118,5],[117,3,117,5],[109,3,109,5],[110,3,110,5],[111,3,111,5],[112,3,112,5],[88,1,88,7],[97,3,97,5],[98,3,98,5],[0,13,0,14],[49,3,49,5],[4,1,4,6],[26,1,26,7],[43,1,43,7],[6,7,6,11],[4,9,4,11],[23,1,23,3]]}
[null,{"$f":"'Title Page'!B8&\" v\"&'Title Page'!$C$10","v":"Final 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":"AusNet"}]
[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","Draft Decision","Revised Proposal"]
[]
[]
[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","$nominal",null,{"$f":"G13","v":117.49195264148101},{"$f":"H13","v":95.645616307929771},{"$f":"I13","v":101.61580319679688},128.9152154180365,172.85161911967327,217.70057456642542,"Opening balance of METERS row in PTRM inputs sheet of PTRM"]
[null,null,"Net capital expenditure",null,"$m","$nominal",null,{"$f":"[1]Assets!G$62","v":14.389366463216687},{"$f":"[1]Assets!H$62","v":15.519943361371411},{"$f":"[1]Assets!I$62","v":35.068742516240832},{"$f":"[1]Assets!J$62","v":54.306436109638859},{"$f":"[1]Assets!K$62","v":59.203165518278752},null,"Net capex from METERS row in ASSETS sheet of PTRM"]
[null,null,"Regulatory depreciation",null,"$m","$2025–26",null,{"$f":"[1]Assets!G$128","v":35.317457507201439},{"$f":"[1]Assets!H$128","v":9.0718901242643764},{"$f":"[1]Assets!I$128","v":7.1935259058175829},{"$f":"[1]Assets!J$128","v":9.3581732923697523},{"$f":"[1]Assets!K$128","v":12.62533788106056},null,"Depreciation from METERS row in ASSETS sheet of PTRM"]
[null,null,"Regulatory depreciation",null,"$m","$nominal",null,{"$f":"H11*'Inputs | General'!J27","v":36.235702796767924},{"$f":"I11*'Inputs | General'!K27","v":9.5497564725043098},{"$f":"J11*'Inputs | General'!L27","v":7.7693302950012262},{"$f":"K11*'Inputs | General'!M27","v":10.370032408002077},{"$f":"L11*'Inputs | General'!N27","v":14.354210071526614}]
[null,null,"Closing RAB",null,null,"$nominal",117.49195264148101,{"$f":"H9+H10-H12","v":95.645616307929771},{"$f":"I9+I10-I12","v":101.61580319679688},128.9152154180365,172.85161911967327,217.70057456642542]
[]
[null,"Linked Input - RAB Comms & IT"]
[null,null,null,null,"Units",null,{"$f":"LEFT(H16,4)-1&\"-\"&RIGHT(H16,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(H16,4)+1&\"-\"&RIGHT(H16,2)+1","v":"2027-28"},{"$f":"LEFT(I16,4)+1&\"-\"&RIGHT(I16,2)+1","v":"2028-29"},{"$f":"LEFT(J16,4)+1&\"-\"&RIGHT(J16,2)+1","v":"2029-30"},{"$f":"LEFT(K16,4)+1&\"-\"&RIGHT(K16,2)+1","v":"2030-31"},{"$f":"LEFT(L16,4)+1&\"-\"&RIGHT(L16,2)+1","v":"2031-32"}]
[null,null,"Opening RAB",null,"$m","$nominal",null,{"$f":"G21","v":11.325562616566112},{"$f":"H21","v":3.4951737156764295},{"$f":"I21","v":-1.1596111735025261},-4.5872907101310432,-9.5287496990759841,-8.6307954095205481,"Opening balance of COMMS & IT rows from PTRM INPUTS sheet of PTRM"]
[null,null,"Net capital expenditure",null,"$m","$nominal",null,{"$f":"SUM([1]Assets!G$63:G$64)","v":2.6619684454871368},{"$f":"SUM([1]Assets!H$63:H$64)","v":5.7016813159194539},{"$f":"SUM([1]Assets!I$63:I$64)","v":4.2449810440207454},{"$f":"SUM([1]Assets!J$63:J$64)","v":2.4121887919123095},{"$f":"SUM([1]Assets!K$63:K$64)","v":5.7981007352369751},null,"Net capex from COMMS & IT rows in ASSETS sheet of PTRM"]
[null,null,"Regulatory depreciation",null,"$m","$2025–26",null,{"$f":"SUM([1]Assets!G$141,[1]Assets!G$154)","v":10.22647157720062},{"$f":"SUM([1]Assets!H$141,[1]Assets!H$154)","v":9.8382323945976022},{"$f":"SUM([1]Assets!I$141,[1]Assets!I$154)","v":7.1040206243976067},{"$f":"SUM([1]Assets!J$141,[1]Assets!J$154)","v":6.6361133270142663},{"$f":"SUM([1]Assets!K$141,[1]Assets!K$154)","v":4.3099553535256119},null,"Depreciation from COMMS & IT rows in ASSETS sheet of PTRM"]
[null,null,"Regulatory depreciation",null,"$m","$nominal",null,{"$f":"H19*'Inputs | General'!J27","v":10.492357346376819},{"$f":"I19*'Inputs | General'!K27","v":10.35646620509841},{"$f":"J19*'Inputs | General'!L27","v":7.6726605806492625},{"$f":"K19*'Inputs | General'!M27","v":7.3536477808572513},{"$f":"L19*'Inputs | General'!N27","v":4.9001464456815382}]
[null,null,"Closing RAB",null,null,"$nominal",11.325562616566112,{"$f":"H17+H18-H20","v":3.4951737156764295},{"$f":"I17+I18-I20","v":-1.1596111735025261},-4.5872907101310432,-9.5287496990759841,-8.6307954095205481]
[]
[null,null,null,null,"Units",null,{"$f":"LEFT(H23,4)-1&\"-\"&RIGHT(H23,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(H23,4)+1&\"-\"&RIGHT(H23,2)+1","v":"2027-28"},{"$f":"LEFT(I23,4)+1&\"-\"&RIGHT(I23,2)+1","v":"2028-29"},{"$f":"LEFT(J23,4)+1&\"-\"&RIGHT(J23,2)+1","v":"2029-30"},{"$f":"LEFT(K23,4)+1&\"-\"&RIGHT(K23,2)+1","v":"2030-31"},{"$f":"LEFT(L23,4)+1&\"-\"&RIGHT(L23,2)+1","v":"2031-32"}]
[null,"TOTAL Opening RAB",null,null,"$m","$nominal",null,{"$f":"H9+H17","v":128.81751525804711},{"$f":"I9+I17","v":99.140790023606201},100.45619202329435,124.32792470790545,163.3228694205973,209.06977915690487]
[]
[]
[null,{"$f":"LEFT(B5,1)+1&\". Input | Define Exit Fees\"","v":"4. Input | Define Exit Fees"}]
[]
[null,"Enter Allowed Exit Fee in final year of current Regulatory Period ",null,null,null,null,"Exit Fee $2025–26"]
[null,null,null,"Exit Fee Name",null,"Units","Last Year - Current RP"]
[null,null,null,"Single phase single element",null,"$dollars",315.20999999999998]
[null,null,null,"Single phase two element with contactor",null,"$dollars",315.20999999999998]
[null,null,null,"Multiphase",null,"$dollars",315.22000000000003]
[null,null,null,"Multiphase CT connected",null,"$dollars",315.22000000000003]
[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,null,null,0,null,"$dollars",0]
[]
[]
[]
[null,{"$f":"LEFT(B27,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 single element",null,null,null,"AMI - Single Phase, single element","$dollars","$2023–24",253.49104699093161,229.9266978192816,{"$f":"K51+L51","v":483.41774481021321}]
[null,null,null,"Single phase two element with contactor",null,null,null,"AMI - Single Phase, two element","$dollars","$2023–24",276.95525144270403,229.9266978192816,506.8819492619856]
[null,null,null,"Multiphase",null,null,null,"AMI - 3 Phase DC","$dollars","$2023–24",372.52659521846664,229.9266978192816,602.45329303774827]
[null,null,null,"Multiphase CT connected",null,null,null,"AMI 3Ph CT","$dollars","$2023–24",472.90723825226718,766.42232606427206,1239.3295643165393]
[null,null,null,null,null,null,null,null,"$dollars","$2023–24"]
[null,null,null,0,null,null,null,null,"$dollars","$2023–24",null,null,{"$f":"K56+L56","v":0}]
[null,null,null,0,null,null,null,null,"$dollars","$2023–24"]
[null,null,null,0,null,null,null,null,"$dollars","$2023–24"]
[null,null,null,0,null,null,null,null,"$dollars","$2023–24"]
[null,null,null,0,null,null,null,null,"$dollars","$2023–24"]
[null,null,null,0,null,null,null,null,"$dollars","$2023–24"]
[null,null,null,0,null,null,null,null,"$dollars","$2023–24"]
[null,null,null,0,null,null,null,0,"$dollars","$2023–24"]
[null,null,null,0,null,null,null,0,"$dollars","$2023–24"]
[null,null,null,0,null,null,null,0,"$dollars","$2023–24"]
[]
[]
[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":"H50","v":"Meter Type"},"Units",{"$f":"LEFT(K70,4)-1&\"-\"&RIGHT(K70,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(K70,4)+1&\"-\"&RIGHT(K70,2)+1","v":"2027-28"},{"$f":"LEFT(L70,4)+1&\"-\"&RIGHT(L70,2)+1","v":"2028-29"},"2029-30","2030-31",null,"Link from Metering - ACS Model"]
[null,null,null,null,null,null,null,"AMI - Single Phase, single element","No.",{"$f":"'[2]Input | Meters Vols & Costs'!P412","v":573745.18699775648},{"$f":"'[2]Input | Meters Vols & Costs'!Q412","v":580696.92340478732},{"$f":"'[2]Input | Meters Vols & Costs'!R412","v":585774.43883344543},{"$f":"'[2]Input | Meters Vols & Costs'!S412","v":589273.37943034701},{"$f":"'[2]Input | Meters Vols & Costs'!T412","v":591168.88077185454},{"$f":"'[2]Input | Meters Vols & Costs'!U412","v":591269.30142958835}]
[null,null,null,null,null,null,null,"AMI - Single Phase, two element","No.",{"$f":"'[2]Input | Meters Vols & Costs'!P413","v":117291.81300224352},{"$f":"'[2]Input | Meters Vols & Costs'!Q413","v":115944.46227490822},{"$f":"'[2]Input | Meters Vols & Costs'!R413","v":114538.66771279977},{"$f":"'[2]Input | Meters Vols & Costs'!S413","v":113116.76078998437},{"$f":"'[2]Input | Meters Vols & Costs'!T413","v":111690.29404567374},{"$f":"'[2]Input | Meters Vols & Costs'!U413","v":110228.38074365607}]
[null,null,null,null,null,null,null,"AMI - 3 Phase DC","No.",{"$f":"'[2]Input | Meters Vols & Costs'!P414","v":158168.274},{"$f":"'[2]Input | Meters Vols & Costs'!Q414","v":169944.74301535875},{"$f":"'[2]Input | Meters Vols & Costs'!R414","v":183725.75657834648},{"$f":"'[2]Input | Meters Vols & Costs'!S414","v":199323.22764710459},{"$f":"'[2]Input | Meters Vols & Costs'!T414","v":217053.7307008339},{"$f":"'[2]Input | Meters Vols & Costs'!U414","v":236976.39562679149}]
[null,null,null,null,null,null,null,"AMI 3Ph CT","No.",{"$f":"'[2]Input | Meters Vols & Costs'!P415","v":5270},{"$f":"'[2]Input | Meters Vols & Costs'!Q415","v":5365.326924310767},{"$f":"'[2]Input | Meters Vols & Costs'!R415","v":5459.9806751815586},{"$f":"'[2]Input | Meters Vols & Costs'!S415","v":5555.6623559633299},{"$f":"'[2]Input | Meters Vols & Costs'!T415","v":5652.2022110521148},{"$f":"'[2]Input | Meters Vols & Costs'!U415","v":5749.5608950320875}]
[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":"H57","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(J71:J85)","v":854475.27399999998},871951.45561936498,889498.84379977325,907269.0302233994,925565.10772941436,944223.63869506808]
[]
[]
[null,{"$f":"LEFT(B44,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","$2023–24",{"$f":"88.0589242315835/'Inputs | General'!J29","v":81.118730971348725}]
[]
[]
[null,"b","Inputs - Admin & Handling 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(K97,4)+1&\"-\"&RIGHT(K97,2)+1","v":"2027-28"},{"$f":"LEFT(L97,4)+1&\"-\"&RIGHT(L97,2)+1","v":"2028-29"},{"$f":"LEFT(M97,4)+1&\"-\"&RIGHT(M97,2)+1","v":"2029-30"},{"$f":"LEFT(N97,4)+1&\"-\"&RIGHT(N97,2)+1","v":"2030-31"}]
[null,null,null,"Site visit @ 20% of the time to rectify issues and locate missing meters",null,null,175,"Calc-Fixed",0.2]
[null,null,null,"Back-office admin processing",null,null,0.25,"Calc-Hourly",1]
[null,null,null,"Receipt Meters into store",null,null,0.27,"Calc-Hourly",1,null,null,15,25]
[null,null,null,null,null,null,null,null,null,null,12,13,14,15,16]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[]
[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(K110,4)+1&\"-\"&RIGHT(K110,2)+1","v":"2027-28"},{"$f":"LEFT(L110,4)+1&\"-\"&RIGHT(L110,2)+1","v":"2028-29"},{"$f":"LEFT(M110,4)+1&\"-\"&RIGHT(M110,2)+1","v":"2029-30"},{"$f":"LEFT(N110,4)+1&\"-\"&RIGHT(N110,2)+1","v":"2030-31"}]
[null,null,null,{"$f":"D98","v":"Site visit @ 20% of the time to rectify issues and locate missing meters"},null,null,{"$f":"G98","v":175},"Calc-Fixed",{"$f":"I98","v":0.2},{"$f":"F93","v":"$2023–24"},{"$f":"IF($H111=\"Calc-Fixed\",$I111*$G111,IF($H111=\"Calc-Hourly\",$G$93*$G111*$I111,IF($H111=\"Entered\",K98,0)))","v":35},35,35,35,35]
[null,null,null,"Back-office admin processing",null,null,0.25,"Calc-Hourly",1,{"$f":"F93","v":"$2023–24"},20.279682742837181,20.279682742837181,20.279682742837181,20.279682742837181,20.279682742837181]
[null,null,null,"Receipt Meters into store",null,null,0.27,"Calc-Hourly",1,{"$f":"F93","v":"$2023–24"},21.902057362264156,21.902057362264156,21.902057362264156,21.902057362264156,21.902057362264156]
[null,null,null,{"$f":"D101","v":0},null,null,{"$f":"G101","v":0},0,0,null,0,0,0,0,0]
[null,null,null,0,null,null,0,0,0,null,0,0,0,0,0]
[null,null,null,0,null,null,0,0,0,null,0,0,0,0,0]
[null,null,null,0,null,null,0,0,0,null,0,0,0,0,0]
[null,null,null,0,null,null,0,0,0,null,0,0,0,0,0]
[null,null,null,0,null,null,0,0,0,null,0,0,0,0,0]
[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(K111:K120)","v":77.181740105101341},{"$f":"SUM(L111:L120)","v":77.181740105101341},{"$f":"SUM(M111:M120)","v":77.181740105101341},{"$f":"SUM(N111:N120)","v":77.181740105101341},{"$f":"SUM(O111:O120)","v":77.181740105101341}]

{"sheet":"Calc | Exit Fees","index":9,"n_rows":177,"n_cols":15,"rows_kept":177,"cut":false,"hidden":false,"merged":[[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":"Final 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":"AusNet"}]
[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","Draft Decision","Revised Proposal"]
[]
[]
[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'!H70","v":"Meter Type"},{"$f":"'Input | Exit Fees'!I70","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"},"2029-30","2030-31"]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H71","v":"AMI - Single Phase, single element"},"No.",{"$f":"'Input | Exit Fees'!D51","v":"Single phase single element"},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J71:K71),0)","v":577221.0552012719},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K71:L71),0)","v":583235.68111911637},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L71:M71),0)","v":587523.90913189622},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M71:N71),0)","v":590221.13010110077},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N71:O71),0)","v":591219.09110072139}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H72","v":"AMI - Single Phase, two element"},"No.",{"$f":"'Input | Exit Fees'!D52","v":"Single phase two element with contactor"},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J72:K72),0)","v":116618.13763857586},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K72:L72),0)","v":115241.564993854},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L72:M72),0)","v":113827.71425139207},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M72:N72),0)","v":112403.52741782906},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N72:O72),0)","v":110959.33739466491}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H73","v":"AMI - 3 Phase DC"},"No.",{"$f":"'Input | Exit Fees'!D53","v":"Multiphase"},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J73:K73),0)","v":164056.50850767939},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K73:L73),0)","v":176835.24979685261},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L73:M73),0)","v":191524.49211272554},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M73:N73),0)","v":208188.47917396924},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N73:O73),0)","v":227015.06316381268}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H74","v":"AMI 3Ph CT"},"No.",{"$f":"'Input | Exit Fees'!D54","v":"Multiphase CT connected"},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J74:K74),0)","v":5317.663462155384},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K74:L74),0)","v":5412.6537997461628},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L74:M74),0)","v":5507.8215155724447},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M74:N74),0)","v":5603.9322835077219},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N74:O74),0)","v":5700.8815530421016}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H75","v":0},"No.",{"$f":"'Input | Exit Fees'!D55","v":0},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J75:K75),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K75:L75),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L75:M75),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M75:N75),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N75:O75),0)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H76","v":0},"No.",{"$f":"'Input | Exit Fees'!D56","v":0},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J76:K76),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K76:L76),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L76:M76),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M76:N76),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N76:O76),0)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H77","v":0},"No.",{"$f":"'Input | Exit Fees'!D57","v":0},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J77:K77),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K77:L77),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L77:M77),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M77:N77),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N77:O77),0)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H78","v":0},"No.",{"$f":"'Input | Exit Fees'!D58","v":0},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J78:K78),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K78:L78),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L78:M78),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M78:N78),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N78:O78),0)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H79","v":0},"No.",{"$f":"'Input | Exit Fees'!D59","v":0},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J79:K79),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K79:L79),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L79:M79),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M79:N79),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N79:O79),0)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H80","v":0},"No.",{"$f":"'Input | Exit Fees'!D60","v":0},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J80:K80),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K80:L80),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L80:M80),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M80:N80),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N80:O80),0)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H81","v":0},"No.",{"$f":"'Input | Exit Fees'!D61","v":0},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J81:K81),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K81:L81),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L81:M81),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M81:N81),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N81:O81),0)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H82","v":0},"No.",{"$f":"'Input | Exit Fees'!D62","v":0},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J82:K82),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K82:L82),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L82:M82),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M82:N82),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N82:O82),0)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H83","v":0},"No.",{"$f":"'Input | Exit Fees'!D63","v":0},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J83:K83),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K83:L83),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L83:M83),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M83:N83),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N83:O83),0)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H84","v":0},"No.",{"$f":"'Input | Exit Fees'!D64","v":0},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J84:K84),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K84:L84),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L84:M84),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M84:N84),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N84:O84),0)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H85","v":0},"No.",{"$f":"'Input | Exit Fees'!D65","v":0},null,null,{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!J85:K85),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!K85:L85),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!L85:M85),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!M85:N85),0)","v":0},{"$f":"IFERROR(AVERAGE('Input | Exit Fees'!N85:O85),0)","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!H86","v":"Total"},"No.",null,null,null,{"$f":"SUM(K12:K26)","v":863213.36480968248},880725.14970956917,898383.93701158627,916417.06897640682,934894.37321224099]
[]
[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"},"2029-30","2030-31"]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D31","v":"Single phase single element"},{"$f":"G12","v":"No."},null,null,{"$f":"IF($F31=0,0,SUMPRODUCT('Input | Exit Fees'!$J$71:$J$85,($H$12:$H$26=$F31)/1))","v":573745.18699775648},{"$f":"IF($F31=0,0,SUMPRODUCT(K$12:K$26,($H$12:$H$26=$F31)/1))","v":577221.0552012719},{"$f":"IF($F31=0,0,SUMPRODUCT(L$12:L$26,($H$12:$H$26=$F31)/1))","v":583235.68111911637},{"$f":"IF($F31=0,0,SUMPRODUCT(M$12:M$26,($H$12:$H$26=$F31)/1))","v":587523.90913189622},{"$f":"IF($F31=0,0,SUMPRODUCT(N$12:N$26,($H$12:$H$26=$F31)/1))","v":590221.13010110077},{"$f":"IF($F31=0,0,SUMPRODUCT(O$12:O$26,($H$12:$H$26=$F31)/1))","v":591219.09110072139}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D32","v":"Single phase two element with contactor"},{"$f":"G13","v":"No."},null,null,{"$f":"IF($F32=0,0,SUMPRODUCT('Input | Exit Fees'!$J$71:$J$85,($H$12:$H$26=$F32)/1))","v":117291.81300224352},{"$f":"IF($F32=0,0,SUMPRODUCT(K$12:K$26,($H$12:$H$26=$F32)/1))","v":116618.13763857586},{"$f":"IF($F32=0,0,SUMPRODUCT(L$12:L$26,($H$12:$H$26=$F32)/1))","v":115241.564993854},{"$f":"IF($F32=0,0,SUMPRODUCT(M$12:M$26,($H$12:$H$26=$F32)/1))","v":113827.71425139207},{"$f":"IF($F32=0,0,SUMPRODUCT(N$12:N$26,($H$12:$H$26=$F32)/1))","v":112403.52741782906},{"$f":"IF($F32=0,0,SUMPRODUCT(O$12:O$26,($H$12:$H$26=$F32)/1))","v":110959.33739466491}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D33","v":"Multiphase"},"No.",null,null,{"$f":"IF($F33=0,0,SUMPRODUCT('Input | Exit Fees'!$J$71:$J$85,($H$12:$H$26=$F33)/1))","v":158168.274},{"$f":"IF($F33=0,0,SUMPRODUCT(K$12:K$26,($H$12:$H$26=$F33)/1))","v":164056.50850767939},{"$f":"IF($F33=0,0,SUMPRODUCT(L$12:L$26,($H$12:$H$26=$F33)/1))","v":176835.24979685261},{"$f":"IF($F33=0,0,SUMPRODUCT(M$12:M$26,($H$12:$H$26=$F33)/1))","v":191524.49211272554},{"$f":"IF($F33=0,0,SUMPRODUCT(N$12:N$26,($H$12:$H$26=$F33)/1))","v":208188.47917396924},{"$f":"IF($F33=0,0,SUMPRODUCT(O$12:O$26,($H$12:$H$26=$F33)/1))","v":227015.06316381268}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D34","v":"Multiphase CT connected"},"No.",null,null,{"$f":"IF($F34=0,0,SUMPRODUCT('Input | Exit Fees'!$J$71:$J$85,($H$12:$H$26=$F34)/1))","v":5270},{"$f":"IF($F34=0,0,SUMPRODUCT(K$12:K$26,($H$12:$H$26=$F34)/1))","v":5317.663462155384},{"$f":"IF($F34=0,0,SUMPRODUCT(L$12:L$26,($H$12:$H$26=$F34)/1))","v":5412.6537997461628},{"$f":"IF($F34=0,0,SUMPRODUCT(M$12:M$26,($H$12:$H$26=$F34)/1))","v":5507.8215155724447},{"$f":"IF($F34=0,0,SUMPRODUCT(N$12:N$26,($H$12:$H$26=$F34)/1))","v":5603.9322835077219},{"$f":"IF($F34=0,0,SUMPRODUCT(O$12:O$26,($H$12:$H$26=$F34)/1))","v":5700.8815530421016}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D35","v":0},"No.",null,null,{"$f":"IF($F35=0,0,SUMPRODUCT('Input | Exit Fees'!$J$71:$J$85,($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'!$D36","v":0},"No.",null,null,{"$f":"IF($F36=0,0,SUMPRODUCT('Input | Exit Fees'!$J$71:$J$85,($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'!$D37","v":0},"No.",null,null,{"$f":"IF($F37=0,0,SUMPRODUCT('Input | Exit Fees'!$J$71:$J$85,($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'!$D38","v":0},"No.",null,null,{"$f":"IF($F38=0,0,SUMPRODUCT('Input | Exit Fees'!$J$71:$J$85,($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'!$D39","v":0},"No.",null,null,{"$f":"IF($F39=0,0,SUMPRODUCT('Input | Exit Fees'!$J$71:$J$85,($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'!$D40","v":0},"No.",null,null,{"$f":"IF($F40=0,0,SUMPRODUCT('Input | Exit Fees'!$J$71:$J$85,($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",{"$f":"G22","v":"No."},null,null,{"$f":"SUM(J31:J40)","v":854475.27399999998},863213.36480968248,880725.14970956917,898383.93701158627,916417.06897640682,934894.37321224099]
[]
[]
[null,null,null,null,"Cost-Weighted Volume of Meters ($nominal)",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'!$D31","v":"Single phase single element"},"$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,K$12:K$26,($H$12:$H$26=$F46)/1)*'Inputs | General'!J$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,K$12:K$26,($H$12:$H$26=$F46)/1)*'Inputs | General'!J$31","v":296320029.94306612},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,L$12:L$26,($H$12:$H$26=$F46)/1)*'Inputs | General'!K$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,L$12:L$26,($H$12:$H$26=$F46)/1)*'Inputs | General'!K$31","v":304907187.88334209},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,M$12:M$26,($H$12:$H$26=$F46)/1)*'Inputs | General'!L$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,M$12:M$26,($H$12:$H$26=$F46)/1)*'Inputs | General'!L$31","v":313043934.07004189},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,N$12:N$26,($H$12:$H$26=$F46)/1)*'Inputs | General'!M$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,N$12:N$26,($H$12:$H$26=$F46)/1)*'Inputs | General'!M$31","v":320687772.63414335},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,O$12:O$26,($H$12:$H$26=$F46)/1)*'Inputs | General'!N$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,O$12:O$26,($H$12:$H$26=$F46)/1)*'Inputs | General'!N$31","v":327548404.07608366}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D32","v":"Single phase two element with contactor"},"$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,K$12:K$26,($H$12:$H$26=$F47)/1)*'Inputs | General'!J$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,K$12:K$26,($H$12:$H$26=$F47)/1)*'Inputs | General'!J$31","v":62837111.643042341},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,L$12:L$26,($H$12:$H$26=$F47)/1)*'Inputs | General'!K$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,L$12:L$26,($H$12:$H$26=$F47)/1)*'Inputs | General'!K$31","v":63258344.370101318},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,M$12:M$26,($H$12:$H$26=$F47)/1)*'Inputs | General'!L$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,M$12:M$26,($H$12:$H$26=$F47)/1)*'Inputs | General'!L$31","v":63701688.026798785},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,N$12:N$26,($H$12:$H$26=$F47)/1)*'Inputs | General'!M$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,N$12:N$26,($H$12:$H$26=$F47)/1)*'Inputs | General'!M$31","v":64165052.652348839},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,O$12:O$26,($H$12:$H$26=$F47)/1)*'Inputs | General'!N$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,O$12:O$26,($H$12:$H$26=$F47)/1)*'Inputs | General'!N$31","v":64605839.992093876}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D33","v":"Multiphase"},"$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,K$12:K$26,($H$12:$H$26=$F48)/1)*'Inputs | General'!J$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,K$12:K$26,($H$12:$H$26=$F48)/1)*'Inputs | General'!J$31","v":105418773.57439244},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,L$12:L$26,($H$12:$H$26=$F48)/1)*'Inputs | General'!K$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,L$12:L$26,($H$12:$H$26=$F48)/1)*'Inputs | General'!K$31","v":115891631.18797819},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,M$12:M$26,($H$12:$H$26=$F48)/1)*'Inputs | General'!L$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,M$12:M$26,($H$12:$H$26=$F48)/1)*'Inputs | General'!L$31","v":128100298.97575092},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,N$12:N$26,($H$12:$H$26=$F48)/1)*'Inputs | General'!M$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,N$12:N$26,($H$12:$H$26=$F48)/1)*'Inputs | General'!M$31","v":142171512.6748254},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,O$12:O$26,($H$12:$H$26=$F48)/1)*'Inputs | General'!N$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,O$12:O$26,($H$12:$H$26=$F48)/1)*'Inputs | General'!N$31","v":158278026.83013281}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D34","v":"Multiphase CT connected"},"$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,K$12:K$26,($H$12:$H$26=$F49)/1)*'Inputs | General'!J$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,K$12:K$26,($H$12:$H$26=$F49)/1)*'Inputs | General'!J$31","v":6951740.6778949201},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,L$12:L$26,($H$12:$H$26=$F49)/1)*'Inputs | General'!K$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,L$12:L$26,($H$12:$H$26=$F49)/1)*'Inputs | General'!K$31","v":7189206.9623495713},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,M$12:M$26,($H$12:$H$26=$F49)/1)*'Inputs | General'!L$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,M$12:M$26,($H$12:$H$26=$F49)/1)*'Inputs | General'!L$31","v":7440477.5830223877},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,N$12:N$26,($H$12:$H$26=$F49)/1)*'Inputs | General'!M$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,N$12:N$26,($H$12:$H$26=$F49)/1)*'Inputs | General'!M$31","v":7704799.9174593333},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,O$12:O$26,($H$12:$H$26=$F49)/1)*'Inputs | General'!N$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,O$12:O$26,($H$12:$H$26=$F49)/1)*'Inputs | General'!N$31","v":7976522.6287699491}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D35","v":0},"$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,K$12:K$26,($H$12:$H$26=$F50)/1)*'Inputs | General'!J$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,K$12:K$26,($H$12:$H$26=$F50)/1)*'Inputs | General'!J$31","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,L$12:L$26,($H$12:$H$26=$F50)/1)*'Inputs | General'!K$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,L$12:L$26,($H$12:$H$26=$F50)/1)*'Inputs | General'!K$31","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,M$12:M$26,($H$12:$H$26=$F50)/1)*'Inputs | General'!L$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,M$12:M$26,($H$12:$H$26=$F50)/1)*'Inputs | General'!L$31","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,N$12:N$26,($H$12:$H$26=$F50)/1)*'Inputs | General'!M$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,N$12:N$26,($H$12:$H$26=$F50)/1)*'Inputs | General'!M$31","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,O$12:O$26,($H$12:$H$26=$F50)/1)*'Inputs | General'!N$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,O$12:O$26,($H$12:$H$26=$F50)/1)*'Inputs | General'!N$31","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D36","v":0},"$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,K$12:K$26,($H$12:$H$26=$F51)/1)*'Inputs | General'!J$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,K$12:K$26,($H$12:$H$26=$F51)/1)*'Inputs | General'!J$31","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,L$12:L$26,($H$12:$H$26=$F51)/1)*'Inputs | General'!K$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,L$12:L$26,($H$12:$H$26=$F51)/1)*'Inputs | General'!K$31","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,M$12:M$26,($H$12:$H$26=$F51)/1)*'Inputs | General'!L$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,M$12:M$26,($H$12:$H$26=$F51)/1)*'Inputs | General'!L$31","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,N$12:N$26,($H$12:$H$26=$F51)/1)*'Inputs | General'!M$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,N$12:N$26,($H$12:$H$26=$F51)/1)*'Inputs | General'!M$31","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,O$12:O$26,($H$12:$H$26=$F51)/1)*'Inputs | General'!N$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,O$12:O$26,($H$12:$H$26=$F51)/1)*'Inputs | General'!N$31","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D37","v":0},"$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,K$12:K$26,($H$12:$H$26=$F52)/1)*'Inputs | General'!J$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,K$12:K$26,($H$12:$H$26=$F52)/1)*'Inputs | General'!J$31","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,L$12:L$26,($H$12:$H$26=$F52)/1)*'Inputs | General'!K$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,L$12:L$26,($H$12:$H$26=$F52)/1)*'Inputs | General'!K$31","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,M$12:M$26,($H$12:$H$26=$F52)/1)*'Inputs | General'!L$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,M$12:M$26,($H$12:$H$26=$F52)/1)*'Inputs | General'!L$31","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,N$12:N$26,($H$12:$H$26=$F52)/1)*'Inputs | General'!M$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,N$12:N$26,($H$12:$H$26=$F52)/1)*'Inputs | General'!M$31","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,O$12:O$26,($H$12:$H$26=$F52)/1)*'Inputs | General'!N$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,O$12:O$26,($H$12:$H$26=$F52)/1)*'Inputs | General'!N$31","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D38","v":0},"$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,K$12:K$26,($H$12:$H$26=$F53)/1)*'Inputs | General'!J$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,K$12:K$26,($H$12:$H$26=$F53)/1)*'Inputs | General'!J$31","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,L$12:L$26,($H$12:$H$26=$F53)/1)*'Inputs | General'!K$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,L$12:L$26,($H$12:$H$26=$F53)/1)*'Inputs | General'!K$31","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,M$12:M$26,($H$12:$H$26=$F53)/1)*'Inputs | General'!L$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,M$12:M$26,($H$12:$H$26=$F53)/1)*'Inputs | General'!L$31","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,N$12:N$26,($H$12:$H$26=$F53)/1)*'Inputs | General'!M$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,N$12:N$26,($H$12:$H$26=$F53)/1)*'Inputs | General'!M$31","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,O$12:O$26,($H$12:$H$26=$F53)/1)*'Inputs | General'!N$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,O$12:O$26,($H$12:$H$26=$F53)/1)*'Inputs | General'!N$31","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D39","v":0},"$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,K$12:K$26,($H$12:$H$26=$F54)/1)*'Inputs | General'!J$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,K$12:K$26,($H$12:$H$26=$F54)/1)*'Inputs | General'!J$31","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,L$12:L$26,($H$12:$H$26=$F54)/1)*'Inputs | General'!K$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,L$12:L$26,($H$12:$H$26=$F54)/1)*'Inputs | General'!K$31","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,M$12:M$26,($H$12:$H$26=$F54)/1)*'Inputs | General'!L$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,M$12:M$26,($H$12:$H$26=$F54)/1)*'Inputs | General'!L$31","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,N$12:N$26,($H$12:$H$26=$F54)/1)*'Inputs | General'!M$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,N$12:N$26,($H$12:$H$26=$F54)/1)*'Inputs | General'!M$31","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,O$12:O$26,($H$12:$H$26=$F54)/1)*'Inputs | General'!N$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,O$12:O$26,($H$12:$H$26=$F54)/1)*'Inputs | General'!N$31","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D40","v":0},"$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,K$12:K$26,($H$12:$H$26=$F55)/1)*'Inputs | General'!J$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,K$12:K$26,($H$12:$H$26=$F55)/1)*'Inputs | General'!J$31","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,L$12:L$26,($H$12:$H$26=$F55)/1)*'Inputs | General'!K$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,L$12:L$26,($H$12:$H$26=$F55)/1)*'Inputs | General'!K$31","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,M$12:M$26,($H$12:$H$26=$F55)/1)*'Inputs | General'!L$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,M$12:M$26,($H$12:$H$26=$F55)/1)*'Inputs | General'!L$31","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,N$12:N$26,($H$12:$H$26=$F55)/1)*'Inputs | General'!M$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,N$12:N$26,($H$12:$H$26=$F55)/1)*'Inputs | General'!M$31","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$K$51:$K$65,O$12:O$26,($H$12:$H$26=$F55)/1)*'Inputs | General'!N$29+SUMPRODUCT('Input | Exit Fees'!$L$51:$L$65,O$12:O$26,($H$12:$H$26=$F55)/1)*'Inputs | General'!N$31","v":0}]
[null,null,null,null,null,"Total","$dollars",null,null,null,{"$f":"SUM(K46:K55)","v":471527655.83839583},{"$f":"SUM(L46:L55)","v":491246370.40377122},{"$f":"SUM(M46:M55)","v":512286398.65561402},{"$f":"SUM(N46:N55)","v":534729137.87877685},{"$f":"SUM(O46:O55)","v":558408793.5270803}]
[]
[]
[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'!$D31","v":"Single phase single element"},"%",null,null,null,{"$f":"K46/K$56","v":0.62842555738580541},{"$f":"L46/L$56","v":0.62068079532624143},0.61107211686970153,0.59972002630394028,0.58657458097532456]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D32","v":"Single phase two element with contactor"},"%",null,null,null,0.13326283382321519,0.12877111808094835,0.12434780270171183,0.11999542966161508,0.11569631556842735]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D33","v":"Multiphase"},"%",null,null,null,0.22356859087502187,0.23591346047549039,0.25005602200628935,0.26587575391684698,0.28344472484109806]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D34","v":"Multiphase CT connected"},"%",null,null,null,1.4743017915957517E-2,1.4634626117319768E-2,1.4524058422297231E-2,1.4408790117597841E-2,1.428437861515002E-2]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D35","v":0},"%",null,null,null,0,0,0,0,0]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D36","v":0},"%",null,null,null,0,0,0,0,0]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D37","v":0},"%",null,null,null,0,0,0,0,0]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D38","v":0},"%",null,null,null,0,0,0,0,0]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D39","v":0},"%",null,null,null,0,0,0,0,0]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D40","v":0},"%",null,null,null,0,0,0,0,0]
[null,null,null,null,null,"Total","%",null,null,null,{"$f":"SUM(K61:K70)","v":1},{"$f":"SUM(L61:L70)","v":1},{"$f":"SUM(M61:M70)","v":1},{"$f":"SUM(N61:N70)","v":1.0000000000000002},{"$f":"SUM(O61:O70)","v":0.99999999999999989}]
[{"$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 ($nominal)",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'!$D31","v":"Single phase single element"},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$13:H$13)*'Calc | Exit Fees'!K61","v":66.970547783444502},{"$f":"AVERAGE('Input | Exit Fees'!H$13:I$13)*'Calc | Exit Fees'!L61","v":61.21818737268854},{"$f":"AVERAGE('Input | Exit Fees'!I$13:J$13)*'Calc | Exit Fees'!M61","v":70.435538774547396},{"$f":"AVERAGE('Input | Exit Fees'!J$13:K$13)*'Calc | Exit Fees'!N61","v":90.48780697330605},{"$f":"AVERAGE('Input | Exit Fees'!K$13:L$13)*'Calc | Exit Fees'!O61","v":114.54399468020857}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D32","v":"Single phase two element with contactor"},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$13:H$13)*'Calc | Exit Fees'!K62","v":14.201658216194698},{"$f":"AVERAGE('Input | Exit Fees'!H$13:I$13)*'Calc | Exit Fees'!L62","v":12.700786771929321},{"$f":"AVERAGE('Input | Exit Fees'!I$13:J$13)*'Calc | Exit Fees'!M62","v":14.333012809670979},{"$f":"AVERAGE('Input | Exit Fees'!J$13:K$13)*'Calc | Exit Fees'!N62","v":18.105320483988994},{"$f":"AVERAGE('Input | Exit Fees'!K$13:L$13)*'Calc | Exit Fees'!O62","v":22.592724923324219}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D33","v":"Multiphase"},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$13:H$13)*'Calc | Exit Fees'!K63","v":23.825432976273792},{"$f":"AVERAGE('Input | Exit Fees'!H$13:I$13)*'Calc | Exit Fees'!L63","v":23.268312046833728},{"$f":"AVERAGE('Input | Exit Fees'!I$13:J$13)*'Calc | Exit Fees'!M63","v":28.822834731941537},{"$f":"AVERAGE('Input | Exit Fees'!J$13:K$13)*'Calc | Exit Fees'!N63","v":40.116242319907002},{"$f":"AVERAGE('Input | Exit Fees'!K$13:L$13)*'Calc | Exit Fees'!O63","v":55.349979537721737}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D34","v":"Multiphase CT connected"},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$13:H$13)*'Calc | Exit Fees'!K64","v":1.5711454987923967},{"$f":"AVERAGE('Input | Exit Fees'!H$13:I$13)*'Calc | Exit Fees'!L64","v":1.4434235609117216},{"$f":"AVERAGE('Input | Exit Fees'!I$13:J$13)*'Calc | Exit Fees'!M64","v":1.6741229912567652},{"$f":"AVERAGE('Input | Exit Fees'!J$13:K$13)*'Calc | Exit Fees'!N64","v":2.1740474916528676},{"$f":"AVERAGE('Input | Exit Fees'!K$13:L$13)*'Calc | Exit Fees'!O64","v":2.7893977017948184}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D35","v":0},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$13:H$13)*'Calc | Exit Fees'!K65","v":0},{"$f":"AVERAGE('Input | Exit Fees'!H$13:I$13)*'Calc | Exit Fees'!L65","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$13:J$13)*'Calc | Exit Fees'!M65","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$13:K$13)*'Calc | Exit Fees'!N65","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$13:L$13)*'Calc | Exit Fees'!O65","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D36","v":0},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$13:H$13)*'Calc | Exit Fees'!K66","v":0},{"$f":"AVERAGE('Input | Exit Fees'!H$13:I$13)*'Calc | Exit Fees'!L66","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$13:J$13)*'Calc | Exit Fees'!M66","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$13:K$13)*'Calc | Exit Fees'!N66","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$13:L$13)*'Calc | Exit Fees'!O66","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D37","v":0},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$13:H$13)*'Calc | Exit Fees'!K67","v":0},{"$f":"AVERAGE('Input | Exit Fees'!H$13:I$13)*'Calc | Exit Fees'!L67","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$13:J$13)*'Calc | Exit Fees'!M67","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$13:K$13)*'Calc | Exit Fees'!N67","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$13:L$13)*'Calc | Exit Fees'!O67","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D38","v":0},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$13:H$13)*'Calc | Exit Fees'!K68","v":0},{"$f":"AVERAGE('Input | Exit Fees'!H$13:I$13)*'Calc | Exit Fees'!L68","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$13:J$13)*'Calc | Exit Fees'!M68","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$13:K$13)*'Calc | Exit Fees'!N68","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$13:L$13)*'Calc | Exit Fees'!O68","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D39","v":0},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$13:H$13)*'Calc | Exit Fees'!K69","v":0},{"$f":"AVERAGE('Input | Exit Fees'!H$13:I$13)*'Calc | Exit Fees'!L69","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$13:J$13)*'Calc | Exit Fees'!M69","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$13:K$13)*'Calc | Exit Fees'!N69","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$13:L$13)*'Calc | Exit Fees'!O69","v":0}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D40","v":0},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$13:H$13)*'Calc | Exit Fees'!K70","v":0},{"$f":"AVERAGE('Input | Exit Fees'!H$13:I$13)*'Calc | Exit Fees'!L70","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$13:J$13)*'Calc | Exit Fees'!M70","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$13:K$13)*'Calc | Exit Fees'!N70","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$13:L$13)*'Calc | Exit Fees'!O70","v":0}]
[null,null,null,null,null,"Total","$m",null,null,null,{"$f":"SUM(K77:K86)","v":106.56878447470538},{"$f":"SUM(L77:L86)","v":98.630709752363316},{"$f":"SUM(M77:M86)","v":115.26550930741668},{"$f":"SUM(N77:N86)","v":150.88341726885488},{"$f":"SUM(O77:O86)","v":195.27609684304934}]
[{"$f":"PRODUCT(J88:O88)","v":1},null,null,null,null,null,null,null,null,null,{"$f":"(K87=AVERAGE('Input | Exit Fees'!G$13:H$13))/1","v":1},{"$f":"(L87=AVERAGE('Input | Exit Fees'!H$13:I$13))/1","v":1},{"$f":"(M87=AVERAGE('Input | Exit Fees'!I$13:J$13))/1","v":1},{"$f":"(N87=AVERAGE('Input | Exit Fees'!J$13:K$13))/1","v":1},{"$f":"(O87=AVERAGE('Input | Exit Fees'!K$13:L$13))/1","v":1}]
[]
[null,null,null,null,"Allocated Meter RAB by Designated Exit Fee Per Meter ($nominal)",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'!$D31","v":"Single phase single element"},"$dollars",null,null,null,{"$f":"IFERROR(K77*10^6/K31,0)","v":116.02235777780569},{"$f":"IFERROR(L77*10^6/L31,0)","v":104.96303527799034},119.88539986163349,153.31170362844534,193.74204318563622]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D32","v":"Single phase two element with contactor"},"$dollars",null,null,null,121.77915463037684,110.2101205637625,125.91848043277116,161.07430878648023,203.61265174976174]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D33","v":"Multiphase"},"$dollars",null,null,null,145.22699034009088,131.58186545705249,150.4916390274372,192.69194183595783,243.81632992248419]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D34","v":"Multiphase CT connected"},"$dollars",null,null,null,295.45786602967377,266.67575912196969,303.9537476883487,387.95035015877204,489.2923446736657]
[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,null,null,null,null,{"$f":"'Input | Exit Fees'!$D39","v":0},"$dollars",null,null,null,0,0,0,0,0]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D40","v":0},"$dollars",null,null,null,0,0,0,0,0]
[]
[null,"Calculations | Comms & IT ($nominal)"]
[]
[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 RAB per meter","$dollars",null,null,null,{"$f":"(AVERAGE('Input | Exit Fees'!G$21:H$21)*10^6)/'Calc | Exit Fees'!K$41","v":8.5846309478249054},{"$f":"(AVERAGE('Input | Exit Fees'!H$21:I$21)*10^6)/'Calc | Exit Fees'!L$41","v":1.3259315593202297},{"$f":"(AVERAGE('Input | Exit Fees'!I$21:J$21)*10^6)/'Calc | Exit Fees'!M$41","v":-3.1984665168604036},{"$f":"(AVERAGE('Input | Exit Fees'!J$21:K$21)*10^6)/'Calc | Exit Fees'!N$41","v":-7.7017555036234517},{"$f":"(AVERAGE('Input | Exit Fees'!K$21:L$21)*10^6)/'Calc | Exit Fees'!O$41","v":-9.7120838615176517}]
[]
[]
[]
[null,"Calculations | Exit Fees with Component Detail ($nominal)"]
[]
[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'!D31","v":"Single phase single element"}]
[null,null,null,null,"Meter RAB",null,{"$f":"IF($D118=0,0,SUMIFS('Calc | Exit Fees'!K$92:K$101,'Input | Exit Fees'!$D$31:$D$40,$D118))","v":116.02235777780569},{"$f":"IF($D118=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$31:$D$40,$D118))","v":104.96303527799034},{"$f":"IF($D118=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$31:$D$40,$D118))","v":119.88539986163349},{"$f":"IF($D118=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$31:$D$40,$D118))","v":153.31170362844534},{"$f":"IF($D118=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$31:$D$40,$D118))","v":193.74204318563622}]
[null,null,null,null,"Comms & IT",null,{"$f":"IF($D118=0,0,'Calc | Exit Fees'!K$109)","v":8.5846309478249054},{"$f":"IF($D118=0,0,'Calc | Exit Fees'!L$109)","v":1.3259315593202297},{"$f":"IF($D118=0,0,'Calc | Exit Fees'!M$109)","v":-3.1984665168604036},{"$f":"IF($D118=0,0,'Calc | Exit Fees'!N$109)","v":-7.7017555036234517},{"$f":"IF($D118=0,0,'Calc | Exit Fees'!O$109)","v":-9.7120838615176517}]
[null,null,null,null,"Admin cost",null,{"$f":"IF($D118=0,0,'Input | Exit Fees'!K$121*'Inputs | General'!J29)","v":83.785100217820698},{"$f":"IF($D118=0,0,'Input | Exit Fees'!L$121*'Inputs | General'!K29)","v":85.963492408005465},{"$f":"IF($D118=0,0,'Input | Exit Fees'!M$121*'Inputs | General'!L29)","v":88.198522264337569},{"$f":"IF($D118=0,0,'Input | Exit Fees'!N$121*'Inputs | General'!M29)","v":90.49166235233622},{"$f":"IF($D118=0,0,'Input | Exit Fees'!O$121*'Inputs | General'!N29)","v":92.844423523865331}]
[]
[null,null,null,null,"TOTAL exit fee",{"$f":"IF(D118=0,0,'Input | Exit Fees'!G31)","v":315.20999999999998},{"$f":"SUM(G119:G122)","v":208.39208894345131},{"$f":"SUM(H119:H122)","v":192.25245924531603},204.88545560911064,236.10161047715812,276.8743828479839]
[null,null,2,{"$f":"'Input | Exit Fees'!D32","v":"Single phase two element with contactor"}]
[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$31:$D$40,$D124))","v":121.77915463037684},{"$f":"IF($D124=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$31:$D$40,$D124))","v":110.2101205637625},{"$f":"IF($D124=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$31:$D$40,$D124))","v":125.91848043277116},{"$f":"IF($D124=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$31:$D$40,$D124))","v":161.07430878648023},{"$f":"IF($D124=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$31:$D$40,$D124))","v":203.61265174976174}]
[null,null,null,null,{"$f":"IF($D124=0,\"\",E$120)","v":"Comms & IT"},null,{"$f":"IF($D124=0,0,'Calc | Exit Fees'!K$109)","v":8.5846309478249054},{"$f":"IF($D124=0,0,'Calc | Exit Fees'!L$109)","v":1.3259315593202297},{"$f":"IF($D124=0,0,'Calc | Exit Fees'!M$109)","v":-3.1984665168604036},{"$f":"IF($D124=0,0,'Calc | Exit Fees'!N$109)","v":-7.7017555036234517},{"$f":"IF($D124=0,0,'Calc | Exit Fees'!O$109)","v":-9.7120838615176517}]
[null,null,null,null,{"$f":"IF($D124=0,\"\",E$121)","v":"Admin cost"},null,{"$f":"IF($D124=0,0,'Input | Exit Fees'!K$121*'Inputs | General'!J29)","v":83.785100217820698},{"$f":"IF($D124=0,0,'Input | Exit Fees'!L$121*'Inputs | General'!K29)","v":85.963492408005465},{"$f":"IF($D124=0,0,'Input | Exit Fees'!M$121*'Inputs | General'!L29)","v":88.198522264337569},{"$f":"IF($D124=0,0,'Input | Exit Fees'!N$121*'Inputs | General'!M29)","v":90.49166235233622},{"$f":"IF($D124=0,0,'Input | Exit Fees'!O$121*'Inputs | General'!N29)","v":92.844423523865331}]
[]
[null,null,null,null,{"$f":"IF($D124=0,\"\",E$123)","v":"TOTAL exit fee"},{"$f":"IF(D124=0,0,'Input | Exit Fees'!G32)","v":315.20999999999998},{"$f":"SUM(G125:G128)","v":214.14888579602245},{"$f":"SUM(H125:H128)","v":197.49954453108819},210.91853618024834,243.86421563519301,286.74499141210941]
[null,null,3,{"$f":"'Input | Exit Fees'!D33","v":"Multiphase"}]
[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$31:$D$40,$D130))","v":145.22699034009088},{"$f":"IF($D130=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$31:$D$40,$D130))","v":131.58186545705249},{"$f":"IF($D130=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$31:$D$40,$D130))","v":150.4916390274372},{"$f":"IF($D130=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$31:$D$40,$D130))","v":192.69194183595783},{"$f":"IF($D130=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$31:$D$40,$D130))","v":243.81632992248419}]
[null,null,null,null,{"$f":"IF($D130=0,\"\",E$120)","v":"Comms & IT"},null,{"$f":"IF($D130=0,0,'Calc | Exit Fees'!K$109)","v":8.5846309478249054},{"$f":"IF($D130=0,0,'Calc | Exit Fees'!L$109)","v":1.3259315593202297},{"$f":"IF($D130=0,0,'Calc | Exit Fees'!M$109)","v":-3.1984665168604036},{"$f":"IF($D130=0,0,'Calc | Exit Fees'!N$109)","v":-7.7017555036234517},{"$f":"IF($D130=0,0,'Calc | Exit Fees'!O$109)","v":-9.7120838615176517}]
[null,null,null,null,{"$f":"IF($D130=0,\"\",E$121)","v":"Admin cost"},null,{"$f":"IF($D130=0,0,'Input | Exit Fees'!K$121*'Inputs | General'!J29)","v":83.785100217820698},{"$f":"IF($D130=0,0,'Input | Exit Fees'!L$121*'Inputs | General'!K29)","v":85.963492408005465},{"$f":"IF($D130=0,0,'Input | Exit Fees'!M$121*'Inputs | General'!L29)","v":88.198522264337569},{"$f":"IF($D130=0,0,'Input | Exit Fees'!N$121*'Inputs | General'!M29)","v":90.49166235233622},{"$f":"IF($D130=0,0,'Input | Exit Fees'!O$121*'Inputs | General'!N29)","v":92.844423523865331}]
[]
[null,null,null,null,{"$f":"IF($D130=0,\"\",E$123)","v":"TOTAL exit fee"},{"$f":"IF(D130=0,0,'Input | Exit Fees'!G33)","v":315.22000000000003},{"$f":"SUM(G131:G134)","v":237.59672150573647},{"$f":"SUM(H131:H134)","v":218.87128942437818},235.49169477491438,275.48184868467058,326.94866958483186]
[null,null,4,{"$f":"'Input | Exit Fees'!D34","v":"Multiphase CT connected"}]
[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$31:$D$40,$D136))","v":295.45786602967377},{"$f":"IF($D136=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$31:$D$40,$D136))","v":266.67575912196969},{"$f":"IF($D136=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$31:$D$40,$D136))","v":303.9537476883487},{"$f":"IF($D136=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$31:$D$40,$D136))","v":387.95035015877204},{"$f":"IF($D136=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$31:$D$40,$D136))","v":489.2923446736657}]
[null,null,null,null,{"$f":"IF($D136=0,\"\",E$120)","v":"Comms & IT"},null,{"$f":"IF($D136=0,0,'Calc | Exit Fees'!K$109)","v":8.5846309478249054},{"$f":"IF($D136=0,0,'Calc | Exit Fees'!L$109)","v":1.3259315593202297},{"$f":"IF($D136=0,0,'Calc | Exit Fees'!M$109)","v":-3.1984665168604036},{"$f":"IF($D136=0,0,'Calc | Exit Fees'!N$109)","v":-7.7017555036234517},{"$f":"IF($D136=0,0,'Calc | Exit Fees'!O$109)","v":-9.7120838615176517}]
[null,null,null,null,{"$f":"IF($D136=0,\"\",E$121)","v":"Admin cost"},null,{"$f":"IF($D136=0,0,'Input | Exit Fees'!K$121*'Inputs | General'!J29)","v":83.785100217820698},{"$f":"IF($D136=0,0,'Input | Exit Fees'!L$121*'Inputs | General'!K29)","v":85.963492408005465},{"$f":"IF($D136=0,0,'Input | Exit Fees'!M$121*'Inputs | General'!L29)","v":88.198522264337569},{"$f":"IF($D136=0,0,'Input | Exit Fees'!N$121*'Inputs | General'!M29)","v":90.49166235233622},{"$f":"IF($D136=0,0,'Input | Exit Fees'!O$121*'Inputs | General'!N29)","v":92.844423523865331}]
[]
[null,null,null,null,{"$f":"IF($D136=0,\"\",E$123)","v":"TOTAL exit fee"},{"$f":"IF(D136=0,0,'Input | Exit Fees'!G34)","v":315.22000000000003},{"$f":"SUM(G137:G140)","v":387.82759719531936},{"$f":"SUM(H137:H140)","v":353.96518308929535},388.95380343582588,470.74025700748479,572.42468433601334]
[null,null,5,{"$f":"'Input | Exit Fees'!D35","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$31:$D$40,$D142))","v":0},{"$f":"IF($D142=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$31:$D$40,$D142))","v":0},{"$f":"IF($D142=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$31:$D$40,$D142))","v":0},{"$f":"IF($D142=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$31:$D$40,$D142))","v":0},{"$f":"IF($D142=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$31:$D$40,$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$121*'Inputs | General'!J29)","v":0},{"$f":"IF($D142=0,0,'Input | Exit Fees'!L$121*'Inputs | General'!K29)","v":0},{"$f":"IF($D142=0,0,'Input | Exit Fees'!M$121*'Inputs | General'!L29)","v":0},{"$f":"IF($D142=0,0,'Input | Exit Fees'!N$121*'Inputs | General'!M29)","v":0},{"$f":"IF($D142=0,0,'Input | Exit Fees'!O$121*'Inputs | General'!N29)","v":0}]
[]
[null,null,null,null,{"$f":"IF($D142=0,\"\",E$123)","v":""},{"$f":"IF(D142=0,0,'Input | Exit Fees'!G35)","v":0},{"$f":"SUM(G143:G146)","v":0},{"$f":"SUM(H143:H146)","v":0},0,0,0]
[null,null,6,{"$f":"'Input | Exit Fees'!D36","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$31:$D$40,$D148))","v":0},{"$f":"IF($D148=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$31:$D$40,$D148))","v":0},{"$f":"IF($D148=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$31:$D$40,$D148))","v":0},{"$f":"IF($D148=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$31:$D$40,$D148))","v":0},{"$f":"IF($D148=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$31:$D$40,$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$121)","v":0},{"$f":"IF($D148=0,0,'Input | Exit Fees'!L$121)","v":0},{"$f":"IF($D148=0,0,'Input | Exit Fees'!M$121)","v":0},{"$f":"IF($D148=0,0,'Input | Exit Fees'!N$121)","v":0},{"$f":"IF($D148=0,0,'Input | Exit Fees'!O$121)","v":0}]
[]
[null,null,null,null,{"$f":"IF($D148=0,\"\",E$123)","v":""},{"$f":"IF(D148=0,0,'Input | Exit Fees'!G36)","v":0},{"$f":"SUM(G149:G152)","v":0},{"$f":"SUM(H149:H152)","v":0},0,0,0]
[null,null,7,{"$f":"'Input | Exit Fees'!D37","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$31:$D$40,$D154))","v":0},{"$f":"IF($D154=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$31:$D$40,$D154))","v":0},{"$f":"IF($D154=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$31:$D$40,$D154))","v":0},{"$f":"IF($D154=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$31:$D$40,$D154))","v":0},{"$f":"IF($D154=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$31:$D$40,$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$121)","v":0},{"$f":"IF($D154=0,0,'Input | Exit Fees'!L$121)","v":0},{"$f":"IF($D154=0,0,'Input | Exit Fees'!M$121)","v":0},{"$f":"IF($D154=0,0,'Input | Exit Fees'!N$121)","v":0},{"$f":"IF($D154=0,0,'Input | Exit Fees'!O$121)","v":0}]
[]
[null,null,null,null,{"$f":"IF($D154=0,\"\",E$123)","v":""},{"$f":"IF(D154=0,0,'Input | Exit Fees'!G37)","v":0},{"$f":"SUM(G155:G158)","v":0},{"$f":"SUM(H155:H158)","v":0},0,0,0]
[null,null,8,{"$f":"'Input | Exit Fees'!D38","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$31:$D$40,$D160))","v":0},{"$f":"IF($D160=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$31:$D$40,$D160))","v":0},{"$f":"IF($D160=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$31:$D$40,$D160))","v":0},{"$f":"IF($D160=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$31:$D$40,$D160))","v":0},{"$f":"IF($D160=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$31:$D$40,$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$121)","v":0},{"$f":"IF($D160=0,0,'Input | Exit Fees'!L$121)","v":0},{"$f":"IF($D160=0,0,'Input | Exit Fees'!M$121)","v":0},{"$f":"IF($D160=0,0,'Input | Exit Fees'!N$121)","v":0},{"$f":"IF($D160=0,0,'Input | Exit Fees'!O$121)","v":0}]
[]
[null,null,null,null,{"$f":"IF($D160=0,\"\",E$123)","v":""},{"$f":"IF(D160=0,0,'Input | Exit Fees'!G38)","v":0},{"$f":"SUM(G161:G164)","v":0},{"$f":"SUM(H161:H164)","v":0},0,0,0]
[null,null,9,{"$f":"'Input | Exit Fees'!D39","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$31:$D$40,$D166))","v":0},{"$f":"IF($D166=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$31:$D$40,$D166))","v":0},{"$f":"IF($D166=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$31:$D$40,$D166))","v":0},{"$f":"IF($D166=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$31:$D$40,$D166))","v":0},{"$f":"IF($D166=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$31:$D$40,$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$121)","v":0},{"$f":"IF($D166=0,0,'Input | Exit Fees'!L$121)","v":0},{"$f":"IF($D166=0,0,'Input | Exit Fees'!M$121)","v":0},{"$f":"IF($D166=0,0,'Input | Exit Fees'!N$121)","v":0},{"$f":"IF($D166=0,0,'Input | Exit Fees'!O$121)","v":0}]
[]
[null,null,null,null,{"$f":"IF($D166=0,\"\",E$123)","v":""},{"$f":"IF(D166=0,0,'Input | Exit Fees'!G39)","v":0},{"$f":"SUM(G167:G170)","v":0},{"$f":"SUM(H167:H170)","v":0},0,0,0]
[null,null,10,{"$f":"'Input | Exit Fees'!D40","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$31:$D$40,$D172))","v":0},{"$f":"IF($D172=0,0,SUMIFS('Calc | Exit Fees'!L$92:L$101,'Input | Exit Fees'!$D$31:$D$40,$D172))","v":0},{"$f":"IF($D172=0,0,SUMIFS('Calc | Exit Fees'!M$92:M$101,'Input | Exit Fees'!$D$31:$D$40,$D172))","v":0},{"$f":"IF($D172=0,0,SUMIFS('Calc | Exit Fees'!N$92:N$101,'Input | Exit Fees'!$D$31:$D$40,$D172))","v":0},{"$f":"IF($D172=0,0,SUMIFS('Calc | Exit Fees'!O$92:O$101,'Input | Exit Fees'!$D$31:$D$40,$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$121)","v":0},{"$f":"IF($D172=0,0,'Input | Exit Fees'!L$121)","v":0},{"$f":"IF($D172=0,0,'Input | Exit Fees'!M$121)","v":0},{"$f":"IF($D172=0,0,'Input | Exit Fees'!N$121)","v":0},{"$f":"IF($D172=0,0,'Input | Exit Fees'!O$121)","v":0}]
[]
[null,null,null,null,{"$f":"IF($D172=0,\"\",E$123)","v":""},{"$f":"IF(D172=0,0,'Input | Exit Fees'!G40)","v":0},{"$f":"SUM(G173:G176)","v":0},{"$f":"SUM(H173:H176)","v":0},0,0,0]

{"sheet":"Output | Exit Fee price caps","index":10,"n_rows":62,"n_cols":14,"rows_kept":62,"cut":false,"hidden":false,"merged":[[59,8,59,12],[49,3,49,4],[50,3,50,4],[51,3,51,4],[52,3,52,4],[53,3,53,4],[61,3,61,4],[48,3,48,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[43,3,43,4],[44,3,44,4],[45,3,45,4],[46,3,46,4],[17,3,17,4],[60,3,60,4],[14,3,14,4],[47,3,47,4],[27,3,27,4],[0,13,0,14],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[22,8,22,12],[6,8,6,12],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[15,3,15,4],[16,3,16,4]]}
[null,{"$f":"'Title Page'!B8&\" v\"&'Title Page'!$C$10","v":"Final 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":"AusNet"}]
[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","Draft Decision","Revised Proposal"]
[]
[]
[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"},"2029-30","2030-31"]
[null,null,null,{"$f":"D25","v":"Single phase single element"},null,"$dollars","nominal",{"$f":"ROUND(H25,2)","v":315.20999999999998},{"$f":"IF(I25=0,0,ROUND(H9*(1-I45)*(1+I$41),2))","v":208.39},192.25,204.88,236.1,276.87]
[null,null,null,{"$f":"D26","v":"Single phase two element with contactor"},null,"$dollars","nominal",315.20999999999998,214.15,197.5,210.92,243.87,286.75]
[null,null,null,"Multiphase",null,"$dollars","nominal",{"$f":"ROUND(H27,2)","v":315.22000000000003},{"$f":"IF(I27=0,0,ROUND(H11*(1-I47)*(1+I$41),2))","v":237.6},{"$f":"IF(J27=0,0,ROUND(I11*(1-J47)*(1+J$41),2))","v":218.87},235.49,275.48,326.95]
[null,null,null,"Multiphase CT connected",null,"$dollars","nominal",315.22000000000003,387.83,353.97,388.96,470.75,572.44000000000005]
[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"},"2029-30","2030-31"]
[null,null,null,{"$f":"'Input | Exit Fees'!$D31","v":"Single phase single element"},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":315.20999999999998},{"$f":"INDEX(Table3[2026–27],MATCH('Output | Exit Fee price caps'!$D25,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":208.39208894345131},{"$f":"INDEX(Table3[2027–28],MATCH('Output | Exit Fee price caps'!$D25,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":192.25245924531603},{"$f":"INDEX(Table3[2028–29],MATCH('Output | Exit Fee price caps'!$D25,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":204.88545560911064},{"$f":"INDEX(Table3[2029–30],MATCH('Output | Exit Fee price caps'!$D25,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":236.10161047715812},{"$f":"INDEX(Table3[2030–31],MATCH('Output | Exit Fee price caps'!$D25,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":276.8743828479839}]
[null,null,null,{"$f":"'Input | Exit Fees'!$D32","v":"Single phase two element with contactor"},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":315.20999999999998},{"$f":"INDEX(Table3[2026–27],MATCH('Output | Exit Fee price caps'!$D26,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":214.14888579602245},{"$f":"INDEX(Table3[2027–28],MATCH('Output | Exit Fee price caps'!$D26,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":197.49954453108819},{"$f":"INDEX(Table3[2028–29],MATCH('Output | Exit Fee price caps'!$D26,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":210.91853618024834},{"$f":"INDEX(Table3[2029–30],MATCH('Output | Exit Fee price caps'!$D26,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":243.86421563519301},{"$f":"INDEX(Table3[2030–31],MATCH('Output | Exit Fee price caps'!$D26,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":286.74499141210941}]
[null,null,null,{"$f":"'Input | Exit Fees'!$D33","v":"Multiphase"},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":315.22000000000003},{"$f":"INDEX(Table3[2026–27],MATCH('Output | Exit Fee price caps'!$D27,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":237.59672150573647},{"$f":"INDEX(Table3[2027–28],MATCH('Output | Exit Fee price caps'!$D27,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":218.87128942437818},{"$f":"INDEX(Table3[2028–29],MATCH('Output | Exit Fee price caps'!$D27,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":235.49169477491438},{"$f":"INDEX(Table3[2029–30],MATCH('Output | Exit Fee price caps'!$D27,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":275.48184868467058},{"$f":"INDEX(Table3[2030–31],MATCH('Output | Exit Fee price caps'!$D27,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":326.94866958483186}]
[null,null,null,{"$f":"'Input | Exit Fees'!$D34","v":"Multiphase CT connected"},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":315.22000000000003},{"$f":"INDEX(Table3[2026–27],MATCH('Output | Exit Fee price caps'!$D28,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":387.82759719531936},{"$f":"INDEX(Table3[2027–28],MATCH('Output | Exit Fee price caps'!$D28,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":353.96518308929535},{"$f":"INDEX(Table3[2028–29],MATCH('Output | Exit Fee price caps'!$D28,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":388.95380343582588},{"$f":"INDEX(Table3[2029–30],MATCH('Output | Exit Fee price caps'!$D28,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":470.74025700748479},{"$f":"INDEX(Table3[2030–31],MATCH('Output | Exit Fee price caps'!$D28,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":572.42468433601334}]
[null,null,null,{"$f":"'Input | Exit Fees'!$D35","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'!$D36","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'!$D37","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'!$D38","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'!$D39","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'!$D40","v":0},null,"$dollars","nominal",{"$f":"INDEX(Table3[2025–26],MATCH('Output | Exit Fee price caps'!$D34,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2026–27],MATCH('Output | Exit Fee price caps'!$D34,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2027–28],MATCH('Output | Exit Fee price caps'!$D34,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2028–29],MATCH('Output | Exit Fee price caps'!$D34,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2029–30],MATCH('Output | Exit Fee price caps'!$D34,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2030–31],MATCH('Output | Exit Fee price caps'!$D34,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0}]
[]
[]
[]
[]
[null,null,"Xfactors"]
[]
[null,null,null,"CPI",null,"%",null,null,{"$f":"'Inputs | General'!J26","v":2.5999756335213231E-2},{"$f":"'Inputs | General'!K26","v":2.5999756335213231E-2},{"$f":"'Inputs | General'!L26","v":2.5999756335213231E-2},{"$f":"'Inputs | General'!M26","v":2.5999756335213231E-2},{"$f":"'Inputs | General'!N26","v":2.5999756335213231E-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'!$D31","v":"Single phase single element"},null,"%",null,null,{"$f":"IFERROR(-1*(((I25/H25)/(1+I$41)-1)),\"\")","v":0.35563197221682719},0.10082666756864611,-3.8704392800522847E-2,-0.12315724265014039,-0.14297457139107617]
[null,null,null,{"$f":"'Input | Exit Fees'!$D32","v":"Single phase two element with contactor"},null,"%",null,null,0.33783141244967474,0.10111730080271286,-4.0881746425398102E-2,-0.12690179559014347,-0.14604192656983672]
[null,null,null,{"$f":"'Input | Exit Fees'!$D33","v":"Multiphase"},null,"%",null,null,0.26535179572407286,0.10215556509295365,-4.8671683228672213E-2,-0.14017138141948715,-0.15674952033645506]
[null,null,null,{"$f":"'Input | Exit Fees'!$D34","v":"Multiphase CT connected"},null,"%",null,null,-0.19916152900834549,0.11044136729011367,-7.1001845512412176E-2,-0.1796035199660222,-0.18519484969490629]
[null,null,null,{"$f":"'Input | Exit Fees'!$D35","v":0},null,"%",null,null,"","","","",""]
[null,null,null,{"$f":"'Input | Exit Fees'!$D36","v":0},null,"%",null,null,"","","","",""]
[null,null,null,{"$f":"'Input | Exit Fees'!$D37","v":0},null,"%",null,null,"","","","",""]
[null,null,null,{"$f":"'Input | Exit Fees'!$D38","v":0},null,"%",null,null,"","","","",""]
[null,null,null,{"$f":"'Input | Exit Fees'!$D39","v":0},null,"%",null,null,"","","","",""]
[null,null,null,{"$f":"'Input | Exit Fees'!$D40","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"},"2029-30","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":315.21191273263219},{"$f":"SUMPRODUCT(I$25:I$34,'Calc | Exit Fees'!K$31:K$40)/'Calc | Exit Fees'!K$41","v":215.8256330540521},{"$f":"SUMPRODUCT(J$25:J$34,'Calc | Exit Fees'!L$31:L$40)/'Calc | Exit Fees'!L$41","v":199.27749400811888},{"$f":"SUMPRODUCT(K$25:K$34,'Calc | Exit Fees'!M$31:M$40)/'Calc | Exit Fees'!M$41","v":213.30322832070866},{"$f":"SUMPRODUCT(L$25:L$34,'Calc | Exit Fees'!N$31:N$40)/'Calc | Exit Fees'!N$41","v":247.43482931549343},{"$f":"SUMPRODUCT(M$25:M$34,'Calc | Exit Fees'!O$31:O$40)/'Calc | Exit Fees'!O$41","v":292.00737671288891}]

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