{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["ASD changes","Title Page","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","Reg Depreciation Calc"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":22,"comments":1,"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":"ASD changes","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
["Issues","Location","Comment"]
[]
[]
[null,"ASD Initial Proposal (2026-31)"]
[1,"Reg Depreciation Calc' worksheet","Added worksheet to calculate regualtory depreciation amounts that are used in worksheet 'Input | Exit Fees' table 3. Linked Input - RAB"]
[]
[2,"Output | Exit Fee price caps!'H24:M24","Modified hardcoded values for regulatory years by linking the cells to an existing source from 'Inputs | General' worksheet and extrapolating forward using the appropriate formula ."]
[]
[3,"Output | Exit Fee price caps!'H61:M64","Modified hardcoded values for regulatory years by linking the cells to an existing source from 'Inputs | General' worksheet and extrapolating forward using the appropriate formula ."]

{"sheet":"Title Page","index":1,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[[13,1,13,23],[7,1,8,23],[27,4,27,7],[19,1,19,23],[22,4,22,7],[25,4,25,7],[26,4,26,7],[23,4,23,7]]}
[]
[]
[]
[]
[]
[]
[]
[null,"Preliminary Standardised Metering Pricing Model "]
[]
[null,"Version",1]
[null,"Date","2021-10-25"]
[]
[]
[null,"Status"]
[]
[null,"Notes:"]
[null,"Current model version is in draft form, with test data for consultation purposes"]
[null,"There are no protections currently enabled for non-input cells"]
[]
[null,"Version Summary"]
[]
[null,"Date","Version","Author","Changes"]
[null,null,null,null,null,null,null," "]
[null,"2021-10-25",1,"AER","Consultation version (contains anonymised input data)"]

{"sheet":"Inputs | General","index":2,"n_rows":27,"n_cols":23,"rows_kept":27,"cut":false,"hidden":false,"merged":[[4,1,4,6],[1,10,1,11],[1,12,1,13],[20,1,20,6],[23,7,23,11]]}
[null,{"$f":"'Title Page'!B8&\" v\"&'Title Page'!$C$10","v":"Preliminary Standardised Metering Pricing Model  v1"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Worksheet check:",{"$f":"IF(COUNTA($X$14:$X$46)=COUNTIF($X14:$X47,\"OK\"),\"OK\",\"Check\")","v":"OK"}]
[null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"Inputs | General"},null,null,null,null,null,null,"Key:","Input","External Link",null,"Internal Link"]
[]
[]
[null,"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,"draft"]
[]
[null,null,"Forecast regulatory control period, first year","NSP","YYYY-YY",null,"2026-27"]
[null,null,"Forecast regulatory control period, last year","NSP",null,null,{"$f":"LEFT(FPFirstYear,4)+4&\"-\"&RIGHT(FPFirstYear,2)+4","v":"2030-31"}]
[]
[null,null,"Regulatory Period Length, Yrs",null,null,null,{"$f":"LEFT(G12,4)-LEFT(FPFirstYear,4)+1","v":5}]
[]
[null,null,"Model Used For",null,null,null,"Exit Fees (Vic)"]
[]
[]
[]
[]
[null,{"$f":"LEFT('Inputs | General'!B5,1)+1&\". Linked Inputs - Inflation\"","v":"2. Linked Inputs - Inflation"}]
[]
[]
[null,null,null,null,null,null,"Base year","Regulatory period"]
[null,null,"Year",null,"Units",null,{"$f":"LEFT(H25,4)-1&\"-\"&RIGHT(H25,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(H25,4)+1&\"-\"&RIGHT(H25,2)+1","v":"2027-28"},{"$f":"LEFT(I25,4)+1&\"-\"&RIGHT(I25,2)+1","v":"2028-29"},"2029-30","2030-31"]
[null,null,"Inflation Assumption (CPI % increase)",null,"%",null,null,{"$f":"'[1]PTRM input'!G373","v":2.5000000000000001E-2},{"$f":"'[1]PTRM input'!H373","v":2.5000000000000001E-2},{"$f":"'[1]PTRM input'!I373","v":2.5000000000000001E-2},{"$f":"'[1]PTRM input'!J373","v":2.5000000000000001E-2},{"$f":"'[1]PTRM input'!K373","v":2.5000000000000001E-2}]
[null,null,"Cumulative Inflation Index (CPI end period)",null,"Index",null,1,{"$f":"G27*(1+H26)","v":1.0249999999999999},{"$f":"H27*(1+I26)","v":1.0506249999999999},{"$f":"I27*(1+J26)","v":1.0768906249999999},{"$f":"J27*(1+K26)","v":1.1038128906249998},{"$f":"K27*(1+L26)","v":1.1314082128906247}]

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

{"sheet":"Inputs | Price Cap","index":4,"n_rows":125,"n_cols":22,"rows_kept":125,"cut":false,"hidden":true,"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]]}
[null,{"$f":"'Title Page'!B8&\" v\"&'Title Page'!$C$10","v":"Preliminary Standardised Metering Pricing Model  v1"},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,{"$f":"[1]WACC!G18","v":6.0360530205153029E-2},{"$f":"[1]WACC!H18","v":6.1278003802165776E-2},{"$f":"[1]WACC!I18","v":6.2358025086078517E-2},{"$f":"[1]WACC!J18","v":6.3761644774099915E-2},{"$f":"[1]WACC!K18","v":6.5777620209021309E-2}]
[null,null,"Cumulative Discount Index",null,"Index",null,1,{"$f":"G10*(1+H9)","v":1.0603605302051531},{"$f":"H10*(1+I9)","v":1.1253373068067312},{"$f":"I10*(1+J9)","v":1.1955111188148853},{"$f":"J10*(1+K9)","v":1.2717388740962468},{"$f":"K10*(1+L9)","v":1.3553908307615978}]
[]
[]
[]
[]
[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,12,11,10,9,8]
[null,null,"Return of Capital (regulatory depreciation)",null,"$m",null,null,18,20,21,22,23]
[null,null,"Operating Expenditure",null,"$m",null,null,20,19.5,19,18.5,18]
[null,null,"Revenue Adjustments",null,"$m",null,null,0,0,0,0,0]
[null,null,"Net Tax Allowance",null,"$m",null,null,0.1,0.1,0.1,0.1,0.1]
[null,null,"Annual Revenue Requirement (unsmoothed)",null,"$m",null,null,{"$f":"SUM(H20:H24)","v":50.1},{"$f":"SUM(I20:I24)","v":50.6},{"$f":"SUM(J20:J24)","v":50.1},{"$f":"SUM(K20:K24)","v":49.6},{"$f":"SUM(L20:L24)","v":49.1}]
[]
[null,null,"Non-Capital Component",null,"$m",null,null,{"$f":"H22","v":20},{"$f":"I22","v":19.5},{"$f":"J22","v":19},{"$f":"K22","v":18.5},{"$f":"L22","v":18}]
[null,null,"Capital Component",null,"$m",null,null,{"$f":"SUM(H20:H21,H23:H24)","v":30.1},{"$f":"SUM(I20:I21,I23:I24)","v":31.1},{"$f":"SUM(J20:J21,J23:J24)","v":31.1},{"$f":"SUM(K20:K21,K23:K24)","v":31.1},{"$f":"SUM(L20:L21,L23:L24)","v":31.1}]
[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":79.90974498534068}]
[null,null,"Capital",null,"$m",null,{"$f":"SUMPRODUCT($H28:$L28,1/$H$10:$L$10)","v":129.43682490581097}]
[null,null,"Total",null,"$m",null,{"$f":"G33+G34","v":209.34656989115166}]
[]
[]
[]
[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":"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":20},{"$f":"'Inputs | Price Cap'!I27","v":19.5},{"$f":"'Inputs | Price Cap'!J27","v":19},{"$f":"'Inputs | Price Cap'!K27","v":18.5},{"$f":"'Inputs | Price Cap'!L27","v":18},null,{"$f":"'Inputs | Price Cap'!G33","v":79.90974498534068},"NPV (unsmoothed)"]
[]
[null,null,null,null,null,{"$f":"F106-E101","v":3.2266300000000001},"First year difference ($m)",null,null,null,null,{"$f":"J101-I101","v":-0.5},"Final year difference ($m)"]
[null,null,null,null,null,{"$f":"(F106/E101)-1","v":0.17441243243243254},"First year difference (%)",null,null,null,null,{"$f":"(J101/I101)-1","v":-2.7027027027026973E-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.72663},{"$f":"'Calc | Price Cap'!K59/10^6","v":20.244249},{"$f":"'Calc | Price Cap'!L59/10^6","v":18.8649162},{"$f":"'Calc | Price Cap'!M59/10^6","v":17.575606799999999},{"$f":"'Calc | Price Cap'!N59/10^6","v":16.375173435000001},null,{"$f":"SUMPRODUCT($F106:$J106,1/'Inputs | Price Cap'!$H$10:$L$10)","v":80.160789585737191},"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":-0.25104460039651144},"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":30.1},{"$f":"'Inputs | Price Cap'!I28","v":31.1},{"$f":"'Inputs | Price Cap'!J28","v":31.1},{"$f":"'Inputs | Price Cap'!K28","v":31.1},{"$f":"'Inputs | Price Cap'!L28","v":31.1},null,{"$f":"'Inputs | Price Cap'!G34","v":129.43682490581097},"NPV (unsmoothed)"]
[]
[null,null,null,null,null,{"$f":"F122-E117","v":-3.614099999999997},"First year difference ($m)",null,null,null,null,{"$f":"J117-I117","v":0},"Final year difference ($m)"]
[null,null,null,null,null,{"$f":"(F122/E117)-1","v":-0.10355587392550136},"First year difference (%)",null,null,null,null,{"$f":"(J117/I117)-1","v":0},"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.285900000000002},{"$f":"'Calc | Price Cap'!K60/10^6","v":31.111349999999995},{"$f":"'Calc | Price Cap'!L60/10^6","v":30.936800000000002},{"$f":"'Calc | Price Cap'!M60/10^6","v":30.762250000000002},{"$f":"'Calc | Price Cap'!N60/10^6","v":30.587700000000002},null,{"$f":"SUMPRODUCT($F122:$J122,1/'Inputs | Price Cap'!$H$10:$L$10)","v":129.78523990428823},"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":-0.34841499847726709},"NPV difference (smoothed vs unsmoothed)"]

{"sheet":"Calc | Price Cap","index":5,"n_rows":63,"n_cols":14,"rows_kept":63,"cut":false,"hidden":true,"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":"Preliminary Standardised Metering Pricing Model  v1"},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":11745000},{"$f":"'Output | Price Caps'!K9*'Inputs | Price Cap'!K44","v":10943100},{"$f":"'Output | Price Caps'!L9*'Inputs | Price Cap'!L44","v":10198710},{"$f":"'Output | Price Caps'!M9*'Inputs | Price Cap'!M44","v":9500328},{"$f":"'Output | Price Caps'!N9*'Inputs | Price Cap'!N44","v":8851445.0999999996}]
[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":19723000},{"$f":"'Output | Price Caps'!K10*'Inputs | Price Cap'!K45","v":19612999.999999996},{"$f":"'Output | Price Caps'!L10*'Inputs | Price Cap'!L45","v":19503000},{"$f":"'Output | Price Caps'!M10*'Inputs | Price Cap'!M45","v":19393000},{"$f":"'Output | Price Caps'!N10*'Inputs | Price Cap'!N45","v":19283000}]
[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},31468000,30556099.999999996,29701710,28893328,28134445.100000001]
[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":7047000},{"$f":"'Output | Price Caps'!K12*'Inputs | Price Cap'!K47","v":6565860},{"$f":"'Output | Price Caps'!L12*'Inputs | Price Cap'!L47","v":6117039},{"$f":"'Output | Price Caps'!M12*'Inputs | Price Cap'!M47","v":5700196.7999999998},{"$f":"'Output | Price Caps'!N12*'Inputs | Price Cap'!N47","v":5310867.0600000005}]
[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":5916900},{"$f":"'Output | Price Caps'!K13*'Inputs | Price Cap'!K48","v":5883899.9999999991},{"$f":"'Output | Price Caps'!L13*'Inputs | Price Cap'!L48","v":5850900},{"$f":"'Output | Price Caps'!M13*'Inputs | Price Cap'!M48","v":5817900},{"$f":"'Output | Price Caps'!N13*'Inputs | Price Cap'!N48","v":5784900}]
[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},12963900,12449760,11967939,11518096.800000001,11095767.060000001]
[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":351000},{"$f":"'Output | Price Caps'!K15*'Inputs | Price Cap'!K50","v":328050},{"$f":"'Output | Price Caps'!L15*'Inputs | Price Cap'!L50","v":306180},{"$f":"'Output | Price Caps'!M15*'Inputs | Price Cap'!M50","v":285403.5},{"$f":"'Output | Price Caps'!N15*'Inputs | Price Cap'!N50","v":265720.5}]
[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":2956800.0000000005},{"$f":"'Output | Price Caps'!K16*'Inputs | Price Cap'!K51","v":2940300},{"$f":"'Output | Price Caps'!L16*'Inputs | Price Cap'!L51","v":2923800},{"$f":"'Output | Price Caps'!M16*'Inputs | Price Cap'!M51","v":2907300},{"$f":"'Output | Price Caps'!N16*'Inputs | Price Cap'!N51","v":2890800}]
[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},3307800.0000000005,3268350,3229980,3192703.5,3156520.5]
[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":587250},{"$f":"'Output | Price Caps'!K18*'Inputs | Price Cap'!K53","v":547155},{"$f":"'Output | Price Caps'!L18*'Inputs | Price Cap'!L53","v":509935.5},{"$f":"'Output | Price Caps'!M18*'Inputs | Price Cap'!M53","v":475016.4},{"$f":"'Output | Price Caps'!N18*'Inputs | Price Cap'!N53","v":442572.255}]
[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":1478950},{"$f":"'Output | Price Caps'!K19*'Inputs | Price Cap'!K54","v":1470700},{"$f":"'Output | Price Caps'!L19*'Inputs | Price Cap'!L54","v":1462450},{"$f":"'Output | Price Caps'!M19*'Inputs | Price Cap'!M54","v":1454200},{"$f":"'Output | Price Caps'!N19*'Inputs | Price Cap'!N54","v":1445950}]
[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},2066200,2017855,1972385.5,1929216.4,1888522.2549999999]
[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":1467900},{"$f":"'Output | Price Caps'!K21*'Inputs | Price Cap'!K56","v":1367685.0000000002},{"$f":"'Output | Price Caps'!L21*'Inputs | Price Cap'!L56","v":1274292},{"$f":"'Output | Price Caps'!M21*'Inputs | Price Cap'!M56","v":1187212.95},{"$f":"'Output | Price Caps'!N21*'Inputs | Price Cap'!N56","v":1106283.0149999999}]
[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":986150},{"$f":"'Output | Price Caps'!K22*'Inputs | Price Cap'!K57","v":980649.99999999988},{"$f":"'Output | Price Caps'!L22*'Inputs | Price Cap'!L57","v":975150},{"$f":"'Output | Price Caps'!M22*'Inputs | Price Cap'!M57","v":969650},{"$f":"'Output | Price Caps'!N22*'Inputs | Price Cap'!N57","v":964150.00000000012}]
["▼ 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},2454050,2348335,2249442,2156862.9500000002,2070433.0150000001]
[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":528480},{"$f":"'Output | Price Caps'!K24*'Inputs | Price Cap'!K59","v":492399},{"$f":"'Output | Price Caps'!L24*'Inputs | Price Cap'!L59","v":458759.7},{"$f":"'Output | Price Caps'!M24*'Inputs | Price Cap'!M59","v":427449.15},{"$f":"'Output | Price Caps'!N24*'Inputs | Price Cap'!N59","v":398285.50500000006}]
[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":224100},{"$f":"'Output | Price Caps'!K25*'Inputs | Price Cap'!K60","v":222800},{"$f":"'Output | Price Caps'!L25*'Inputs | Price Cap'!L60","v":221500},{"$f":"'Output | Price Caps'!M25*'Inputs | Price Cap'!M60","v":220200},{"$f":"'Output | Price Caps'!N25*'Inputs | Price Cap'!N60","v":218900}]
[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},752580,715199,680259.7,647649.15,617185.50500000012]
[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":21726630},{"$f":"SUMIFS('Calc | Price Cap'!K$11:K$55,'Output | Price Caps'!$E$9:$E$53,$E59)","v":20244249},{"$f":"SUMIFS('Calc | Price Cap'!L$11:L$55,'Output | Price Caps'!$E$9:$E$53,$E59)","v":18864916.199999999},{"$f":"SUMIFS('Calc | Price Cap'!M$11:M$55,'Output | Price Caps'!$E$9:$E$53,$E59)","v":17575606.800000001},{"$f":"SUMIFS('Calc | Price Cap'!N$11:N$55,'Output | Price Caps'!$E$9:$E$53,$E59)","v":16375173.435000002}]
[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":31285900},{"$f":"SUMIFS('Calc | Price Cap'!K$11:K$55,'Output | Price Caps'!$E$9:$E$53,$E60)","v":31111349.999999996},{"$f":"SUMIFS('Calc | Price Cap'!L$11:L$55,'Output | Price Caps'!$E$9:$E$53,$E60)","v":30936800},{"$f":"SUMIFS('Calc | Price Cap'!M$11:M$55,'Output | Price Caps'!$E$9:$E$53,$E60)","v":30762250},{"$f":"SUMIFS('Calc | Price Cap'!N$11:N$55,'Output | Price Caps'!$E$9:$E$53,$E60)","v":30587700}]
[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":53012530},{"$f":"SUMIFS('Calc | Price Cap'!K$11:K$55,'Output | Price Caps'!$E$9:$E$53,$E61)","v":51355599},{"$f":"SUMIFS('Calc | Price Cap'!L$11:L$55,'Output | Price Caps'!$E$9:$E$53,$E61)","v":49801716.200000003},{"$f":"SUMIFS('Calc | Price Cap'!M$11:M$55,'Output | Price Caps'!$E$9:$E$53,$E61)","v":48337856.799999997},{"$f":"SUMIFS('Calc | Price Cap'!N$11:N$55,'Output | Price Caps'!$E$9:$E$53,$E61)","v":46962873.43500001}]
[]
[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":true,"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":"Preliminary Standardised Metering Pricing Model  v1"},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'!H$26),2)","v":13.05},{"$f":"ROUND('Output | Price Caps'!J9*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!I$26),2)","v":13.51},{"$f":"ROUND('Output | Price Caps'!K9*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!J$26),2)","v":13.99},{"$f":"ROUND('Output | Price Caps'!L9*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!K$26),2)","v":14.48},{"$f":"ROUND('Output | Price Caps'!M9*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!L$26),2)","v":14.99}]
[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'!H$26),2)","v":17.93},{"$f":"ROUND('Output | Price Caps'!J10*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!I$26),2)","v":17.829999999999998},{"$f":"ROUND('Output | Price Caps'!K10*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!J$26),2)","v":17.73},{"$f":"ROUND('Output | Price Caps'!L10*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!K$26),2)","v":17.63},{"$f":"ROUND('Output | Price Caps'!M10*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!L$26),2)","v":17.53}]
[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":30.98},{"$f":"K9+K10","v":31.339999999999996},{"$f":"L9+L10","v":31.72},{"$f":"M9+M10","v":32.11},{"$f":"N9+N10","v":32.520000000000003}]
[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'!H$26),2)","v":26.1},{"$f":"ROUND('Output | Price Caps'!J12*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!I$26),2)","v":27.02},{"$f":"ROUND('Output | Price Caps'!K12*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!J$26),2)","v":27.97},{"$f":"ROUND('Output | Price Caps'!L12*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!K$26),2)","v":28.96},{"$f":"ROUND('Output | Price Caps'!M12*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!L$26),2)","v":29.98}]
[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'!H$26),2)","v":17.93},{"$f":"ROUND('Output | Price Caps'!J13*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!I$26),2)","v":17.829999999999998},{"$f":"ROUND('Output | Price Caps'!K13*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!J$26),2)","v":17.73},{"$f":"ROUND('Output | Price Caps'!L13*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!K$26),2)","v":17.63},{"$f":"ROUND('Output | Price Caps'!M13*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!L$26),2)","v":17.53}]
[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.03},{"$f":"K12+K13","v":44.849999999999994},{"$f":"L12+L13","v":45.7},{"$f":"M12+M13","v":46.59},{"$f":"N12+N13","v":47.510000000000005}]
[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'!H$26),2)","v":1.3},{"$f":"ROUND('Output | Price Caps'!J15*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!I$26),2)","v":1.35},{"$f":"ROUND('Output | Price Caps'!K15*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!J$26),2)","v":1.4},{"$f":"ROUND('Output | Price Caps'!L15*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!K$26),2)","v":1.45},{"$f":"ROUND('Output | Price Caps'!M15*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!L$26),2)","v":1.5}]
[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'!H$26),2)","v":8.9600000000000009},{"$f":"ROUND('Output | Price Caps'!J16*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!I$26),2)","v":8.91},{"$f":"ROUND('Output | Price Caps'!K16*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!J$26),2)","v":8.86},{"$f":"ROUND('Output | Price Caps'!L16*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!K$26),2)","v":8.81},{"$f":"ROUND('Output | Price Caps'!M16*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!L$26),2)","v":8.76}]
[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.260000000000002},{"$f":"K15+K16","v":10.26},{"$f":"L15+L16","v":10.26},{"$f":"M15+M16","v":10.26},{"$f":"N15+N16","v":10.26}]
[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'!H$26),2)","v":13.05},{"$f":"ROUND('Output | Price Caps'!J18*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!I$26),2)","v":13.51},{"$f":"ROUND('Output | Price Caps'!K18*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!J$26),2)","v":13.99},{"$f":"ROUND('Output | Price Caps'!L18*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!K$26),2)","v":14.48},{"$f":"ROUND('Output | Price Caps'!M18*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!L$26),2)","v":14.99}]
[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'!H$26),2)","v":26.89},{"$f":"ROUND('Output | Price Caps'!J19*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!I$26),2)","v":26.74},{"$f":"ROUND('Output | Price Caps'!K19*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!J$26),2)","v":26.59},{"$f":"ROUND('Output | Price Caps'!L19*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!K$26),2)","v":26.44},{"$f":"ROUND('Output | Price Caps'!M19*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!L$26),2)","v":26.29}]
[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.94},{"$f":"K18+K19","v":40.25},{"$f":"L18+L19","v":40.58},{"$f":"M18+M19","v":40.92},{"$f":"N18+N19","v":41.28}]
[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'!H$26),2)","v":32.619999999999997},{"$f":"ROUND('Output | Price Caps'!J21*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!I$26),2)","v":33.770000000000003},{"$f":"ROUND('Output | Price Caps'!K21*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!J$26),2)","v":34.96},{"$f":"ROUND('Output | Price Caps'!L21*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!K$26),2)","v":36.19},{"$f":"ROUND('Output | Price Caps'!M21*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!L$26),2)","v":37.47}]
[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'!H$26),2)","v":17.93},{"$f":"ROUND('Output | Price Caps'!J22*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!I$26),2)","v":17.829999999999998},{"$f":"ROUND('Output | Price Caps'!K22*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!J$26),2)","v":17.73},{"$f":"ROUND('Output | Price Caps'!L22*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!K$26),2)","v":17.63},{"$f":"ROUND('Output | Price Caps'!M22*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!L$26),2)","v":17.53}]
[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.55},{"$f":"K21+K22","v":51.6},{"$f":"L21+L22","v":52.69},{"$f":"M21+M22","v":53.819999999999993},{"$f":"N21+N22","v":55}]
[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'!H$26),2)","v":58.72},{"$f":"ROUND('Output | Price Caps'!J24*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!I$26),2)","v":60.79},{"$f":"ROUND('Output | Price Caps'!K24*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!J$26),2)","v":62.93},{"$f":"ROUND('Output | Price Caps'!L24*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!K$26),2)","v":65.150000000000006},{"$f":"ROUND('Output | Price Caps'!M24*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!L$26),2)","v":67.45}]
[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'!H$26),2)","v":22.41},{"$f":"ROUND('Output | Price Caps'!J25*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!I$26),2)","v":22.28},{"$f":"ROUND('Output | Price Caps'!K25*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!J$26),2)","v":22.15},{"$f":"ROUND('Output | Price Caps'!L25*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!K$26),2)","v":22.02},{"$f":"ROUND('Output | Price Caps'!M25*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!L$26),2)","v":21.89}]
[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.13},{"$f":"K24+K25","v":83.07},{"$f":"L24+L25","v":85.08},{"$f":"M24+M25","v":87.17},{"$f":"N24+N25","v":89.34}]
[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'!H$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J27*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!I$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K27*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L27*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M27*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!L$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'!H$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J28*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!I$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K28*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L28*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M28*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!L$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'!H$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J30*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!I$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K30*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L30*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M30*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!L$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'!H$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J31*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!I$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K31*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L31*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M31*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!L$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'!H$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J33*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!I$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K33*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L33*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M33*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!L$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'!H$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J34*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!I$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K34*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L34*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M34*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!L$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'!H$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J36*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!I$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K36*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L36*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M36*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!L$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'!H$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J37*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!I$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K37*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L37*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M37*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!L$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'!H$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J39*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!I$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K39*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L39*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M39*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!L$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'!H$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J40*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!I$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K40*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L40*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M40*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!L$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'!H$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J42*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!I$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K42*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L42*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M42*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!L$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'!H$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J43*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!I$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K43*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L43*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M43*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!L$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'!H$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J45*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!I$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K45*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L45*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M45*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!L$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'!H$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J46*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!I$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K46*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L46*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M46*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!L$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'!H$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J48*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!I$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K48*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L48*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M48*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!L$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'!H$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J49*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!I$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K49*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L49*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M49*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!L$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'!H$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J51*(1-'Inputs | Price Cap'!G$109)*(1+'Inputs | General'!I$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K51*(1-'Inputs | Price Cap'!H$109)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L51*(1-'Inputs | Price Cap'!I$109)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M51*(1-'Inputs | Price Cap'!J$109)*(1+'Inputs | General'!L$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'!H$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!J52*(1-'Inputs | Price Cap'!G$125)*(1+'Inputs | General'!I$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!K52*(1-'Inputs | Price Cap'!H$125)*(1+'Inputs | General'!J$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!L52*(1-'Inputs | Price Cap'!I$125)*(1+'Inputs | General'!K$26),2)","v":0},{"$f":"ROUND('Output | Price Caps'!M52*(1-'Inputs | Price Cap'!J$125)*(1+'Inputs | General'!L$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.117368421052632},{"$f":"'Calc | Price Cap'!K59/'Inputs | Price Cap'!K90","v":14.615730994152047},{"$f":"'Calc | Price Cap'!L59/'Inputs | Price Cap'!L90","v":15.133216374269006},{"$f":"'Calc | Price Cap'!M59/'Inputs | Price Cap'!M90","v":15.665497076023392},{"$f":"'Calc | Price Cap'!N59/'Inputs | Price Cap'!N90","v":16.217251461988305}]
[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.641436170212767},{"$f":"'Calc | Price Cap'!K60/'Inputs | Price Cap'!K91","v":16.548590425531913},{"$f":"'Calc | Price Cap'!L60/'Inputs | Price Cap'!L91","v":16.455744680851065},{"$f":"'Calc | Price Cap'!M60/'Inputs | Price Cap'!M91","v":16.362898936170211},{"$f":"'Calc | Price Cap'!N60/'Inputs | Price Cap'!N91","v":16.27005319148936}]
[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.446088369070829},{"$f":"'Calc | Price Cap'!K61/'Inputs | Price Cap'!K90","v":37.077177821095951},{"$f":"'Calc | Price Cap'!L61/'Inputs | Price Cap'!L90","v":39.950357535356453},{"$f":"'Calc | Price Cap'!M61/'Inputs | Price Cap'!M90","v":43.084518388385739},{"$f":"'Calc | Price Cap'!N61/'Inputs | Price Cap'!N90","v":46.509964056018902}]

{"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":119,"n_cols":17,"rows_kept":119,"cut":false,"hidden":false,"merged":[[117,3,117,5],[66,9,66,14],[50,3,50,5],[51,3,51,5],[97,3,97,5],[98,3,98,5],[99,3,99,5],[100,3,100,5],[101,3,101,5],[102,3,102,5],[103,3,103,5],[104,3,104,5],[111,3,111,5],[112,3,112,5],[113,3,113,5],[114,3,114,5],[95,3,95,5],[96,3,96,5],[49,3,49,5],[116,3,116,5],[115,3,115,5],[107,3,107,5],[108,3,108,5],[109,3,109,5],[110,3,110,5],[86,1,86,7],[41,1,41,7],[6,7,6,11],[4,9,4,11],[21,1,21,3],[94,3,94,5],[0,13,0,14],[62,3,62,5],[52,3,52,5],[53,3,53,5],[54,3,54,5],[55,3,55,5],[56,3,56,5],[57,3,57,5],[58,3,58,5],[59,3,59,5],[60,3,60,5],[61,3,61,5],[47,3,47,5],[48,3,48,5],[4,1,4,6],[24,1,24,7]]}
[null,{"$f":"'Title Page'!B8&\" v\"&'Title Page'!$C$10","v":"Preliminary Standardised Metering Pricing Model  v1"},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"]
[]
[]
[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"}]
[null,null,"Opening RAB",null,"$m",null,{"$f":"[1]!A1value","v":75.224861419544013},{"$f":"G9+G10-G11","v":75.224861419544013},{"$f":"H9+H10-H11","v":53.076089609987768},{"$f":"I9+I10-I11","v":58.346186625833475},{"$f":"J9+J10-J11","v":85.848696692315869},{"$f":"K9+K10-K11","v":131.6115181098821},null,"Opening balance of METERS row in PTRM inputs sheet of PTRM"]
[null,null,"Gross capital expenditure",null,"$m",null,null,{"$f":"[1]Assets!G62","v":11.777922702882458},{"$f":"[1]Assets!H62","v":12.775457517050814},{"$f":"[1]Assets!I62","v":32.908723524532867},{"$f":"[1]Assets!J62","v":52.981459917715249},{"$f":"[1]Assets!K62","v":57.746031867109167},null,"Gross capex from METERS row in ASSETS sheet of PTRM"]
[null,null,"Regulatory depreciation",null,"$m",null,null,{"$f":"'Reg Depreciation Calc'!F17","v":33.926694512438708},{"$f":"'Reg Depreciation Calc'!G17","v":7.5053605012051081},{"$f":"'Reg Depreciation Calc'!H17","v":5.4062134580504706},{"$f":"'Reg Depreciation Calc'!I17","v":7.2186385001490043},{"$f":"'Reg Depreciation Calc'!J17","v":10.078109233246648},null,"Depreciation from METERS row in ASSETS sheet of PTRM"]
[]
[]
[null,"Linked Input - RAB Comms & IT"]
[null,null,null,null,"Units",null,{"$f":"LEFT(H15,4)-1&\"-\"&RIGHT(H15,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(H15,4)+1&\"-\"&RIGHT(H15,2)+1","v":"2027-28"},{"$f":"LEFT(I15,4)+1&\"-\"&RIGHT(I15,2)+1","v":"2028-29"},{"$f":"LEFT(J15,4)+1&\"-\"&RIGHT(J15,2)+1","v":"2029-30"},{"$f":"LEFT(K15,4)+1&\"-\"&RIGHT(K15,2)+1","v":"2030-31"}]
[null,null,"Opening RAB",null,"$m",null,{"$f":"[1]!A2value+[1]!A3value","v":41.475795657371997},{"$f":"G16+G17-G18","v":41.475795657371997},{"$f":"H16+H17-H18","v":37.095682389260418},{"$f":"I16+I17-I18","v":31.842064273525907},{"$f":"J16+J17-J18","v":29.593693711842789},{"$f":"K16+K17-K18","v":25.491125613479642},null,"Opening balance of COMMS & IT rows from PTRM INPUTS sheet of PTRM"]
[null,null,"Gross capital expenditure",null,"$m",null,null,{"$f":"[1]Assets!G63+[1]Assets!G64","v":6.0694502698021964},{"$f":"[1]Assets!H63+[1]Assets!H64","v":5.7056088255076789},{"$f":"[1]Assets!I63+[1]Assets!I64","v":6.300776117710627},{"$f":"[1]Assets!J63+[1]Assets!J64","v":4.5339154085313265},{"$f":"[1]Assets!K63+[1]Assets!K64","v":1.3400195945161317},null,"Gross capex from COMMS & IT rows in ASSETS sheet of PTRM"]
[null,null,"Regulatory depreciation",null,"$m",null,null,{"$f":"'Reg Depreciation Calc'!F28","v":10.449563537913777},{"$f":"'Reg Depreciation Calc'!G28","v":10.959226941242195},{"$f":"'Reg Depreciation Calc'!H28","v":8.5491466793937434},{"$f":"'Reg Depreciation Calc'!I28","v":8.636483506894475},{"$f":"'Reg Depreciation Calc'!J28","v":6.6543790231233606},null,"Depreciation from COMMS & IT rows in ASSETS sheet of PTRM"]
[]
[]
[null,null,null,null,"Units",null,{"$f":"LEFT(H21,4)-1&\"-\"&RIGHT(H21,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(H21,4)+1&\"-\"&RIGHT(H21,2)+1","v":"2027-28"},{"$f":"LEFT(I21,4)+1&\"-\"&RIGHT(I21,2)+1","v":"2028-29"},{"$f":"LEFT(J21,4)+1&\"-\"&RIGHT(J21,2)+1","v":"2029-30"},{"$f":"LEFT(K21,4)+1&\"-\"&RIGHT(K21,2)+1","v":"2030-31"}]
[null,"TOTAL Opening RAB",null,null,"$m",null,{"$f":"G9+G16","v":116.700657076916},116.700657076916,90.171771999248193,90.188250899359389,115.44239040415866,157.10264372336175]
[]
[]
[null,{"$f":"LEFT(B5,1)+1&\". Input | Define Exit Fees\"","v":"4. Input | Define Exit Fees"}]
[]
[null,"Enter Allowed Exit Fee in final year of current Regulatory Period ",null,null,null,null,"Exit Fee"]
[null,null,null,"Exit Fee Name",null,"Units","Last Year - Current RP"]
[null,null,null,"Single phase single element",null,"$dollars",287.57]
[null,null,null,"Single phase two element with contactor",null,"$dollars",287.57]
[null,null,null,"Multiphase",null,"$dollars",287.57]
[null,null,null,"Multiphase CT connected",null,"$dollars",287.57]
[null,null,null,0,null,"$dollars"]
[null,null,null,0,null,"$dollars",0]
[null,null,null,0,null,"$dollars",0]
[null,null,null,0,null,"$dollars",0]
[null,null,null,0,null,"$dollars",0]
[null,null,null,0,null,"$dollars",0]
[]
[]
[]
[null,{"$f":"LEFT(B25,1)+1&\". Input | from Metering ACS Model\"","v":"5. Input | from Metering ACS Model"}]
[]
[null,"METERS"]
[]
[null,"a","Inputs - Designated Exit Fee by Meter Type",null,null,null,"b","Linked Input - Meter Types & Unit Costs"]
[null,null,null,null,null,null,null,null,null,null,"Equipment Cost","Labour Cost","Total Cost"]
[null,null,null,"Designated Exit Fee",null,null,null,"Meter Type","Units","Basis","New Meter Installations","New Meter Installations","New Meter Installations",null,null,null,"Link from Metering - ACS Model"]
[null,null,null,"Single phase single element",null,null,null,{"$f":"'[2]Input | Meters Vols & Costs'!F9","v":"AMI - Single Phase, single element"},"$dollars",{"$f":"'[2]Input | Meters Vols & Costs'!M103","v":"2024-06-01"},{"$f":"'[2]Input | Meters Vols & Costs'!P125","v":253.49104699093161},{"$f":"'[2]Input | Meters Vols & Costs'!R103","v":306.568930425708},{"$f":"K49+L49","v":560.05997741663964}]
[null,null,null,"Single phase two element with contactor",null,null,null,{"$f":"'[2]Input | Meters Vols & Costs'!F10","v":"AMI - Single Phase, two element"},"$dollars",{"$f":"'[2]Input | Meters Vols & Costs'!M104","v":"2024-06-01"},{"$f":"'[2]Input | Meters Vols & Costs'!P126","v":276.95525144270403},{"$f":"'[2]Input | Meters Vols & Costs'!R104","v":306.568930425708},583.52418186841203]
[null,null,null,"Multiphase",null,null,null,{"$f":"'[2]Input | Meters Vols & Costs'!F11","v":"AMI - 3 Phase DC"},"$dollars",{"$f":"'[2]Input | Meters Vols & Costs'!M105","v":"2024-06-01"},{"$f":"'[2]Input | Meters Vols & Costs'!P127","v":372.52659521846664},{"$f":"'[2]Input | Meters Vols & Costs'!R105","v":306.568930425708},679.09552564417459]
[null,null,null,"Multiphase CT connected",null,null,null,{"$f":"'[2]Input | Meters Vols & Costs'!F12","v":"AMI 3Ph CT"},"$dollars",{"$f":"'[2]Input | Meters Vols & Costs'!M106","v":"2024-06-01"},{"$f":"'[2]Input | Meters Vols & Costs'!P128","v":472.90723825226718},{"$f":"'[2]Input | Meters Vols & Costs'!R106","v":766.42232606427001},1239.3295643165372]
[null,null,null,null,null,null,null,null,"$dollars",null,null,null,0]
[null,null,null,null,null,null,null,null,"$dollars",null,null,null,0]
[null,null,null,null,null,null,null,null,"$dollars",null,null,null,0]
[null,null,null,null,null,null,null,null,"$dollars",null,null,null,0]
[null,null,null,null,null,null,null,null,"$dollars",null,null,null,0]
[null,null,null,null,null,null,null,null,"$dollars"]
[null,null,null,0,null,null,null,null,"$dollars"]
[null,null,null,0,null,null,null,{"$f":"'[2]Input | Meters Vols & Costs'!F20","v":0},"$dollars"]
[null,null,null,0,null,null,null,0,"$dollars"]
[null,null,null,0,null,null,null,0,"$dollars"]
[null,null,null,0,null,null,null,0,"$dollars"]
[]
[]
[null,"e","Linked Input - Gross Meter Population (Year End), by meter type"]
[null,null,null,null,null,null,null,null,null,"Number of meters in year"]
[null,null,null,null,null,null,null,{"$f":"H48","v":"Meter Type"},"Units",{"$f":"LEFT(K68,4)-1&\"-\"&RIGHT(K68,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(K68,4)+1&\"-\"&RIGHT(K68,2)+1","v":"2027-28"},{"$f":"LEFT(L68,4)+1&\"-\"&RIGHT(L68,2)+1","v":"2028-29"},"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":579476.92634379247},{"$f":"'[2]Input | Meters Vols & Costs'!R412","v":583639.63678555156},{"$f":"'[2]Input | Meters Vols & Costs'!S412","v":586339.19458024926},{"$f":"'[2]Input | Meters Vols & Costs'!T412","v":587574.73850173294},{"$f":"'[2]Input | Meters Vols & Costs'!U412","v":587155.40197282739}]
[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":169190.44301535873},{"$f":"'[2]Input | Meters Vols & Costs'!R414","v":182184.39657834644},{"$f":"'[2]Input | Meters Vols & Costs'!S414","v":196994.80764710449},{"$f":"'[2]Input | Meters Vols & Costs'!T414","v":213633.49070083382},{"$f":"'[2]Input | Meters Vols & Costs'!U414","v":232322.05562679141}]
[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":5354.6239853056986},{"$f":"'[2]Input | Meters Vols & Costs'!R415","v":5440.142723075428},{"$f":"'[2]Input | Meters Vols & Costs'!S415","v":5526.5272060611378},{"$f":"'[2]Input | Meters Vols & Costs'!T415","v":5613.8444811737627},{"$f":"'[2]Input | Meters Vols & Costs'!U415","v":5702.0603517930476}]
[null,null,null,null,null,null,null,0,"No."]
[null,null,null,null,null,null,null,0,"No."]
[null,null,null,null,null,null,null,0,"No."]
[null,null,null,null,null,null,null,0,"No."]
[null,null,null,null,null,null,null,0,"No."]
[null,null,null,null,null,null,null,0,"No."]
[null,null,null,null,null,null,null,{"$f":"H59","v":0},"No."]
[null,null,null,null,null,null,null,0,"No."]
[null,null,null,null,null,null,null,0,"No.",0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,"No.",0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,"No.",0,0,0,0,0,0]
[null,null,null,null,null,null,null,"Total","No.",{"$f":"SUM(J69:J83)","v":854475.27399999998},869966.45561936509,885802.84379977325,901977.29022339929,918512.36772941425,935407.89869506797]
[]
[]
[null,{"$f":"LEFT(B42,1)+1&\". INPUT | Admin and handling\"","v":"6. INPUT | Admin and handling"}]
[]
[null,"a","Inputs - Admin Hourly Rate"]
[null,null,null,"Admin Fees","Units",null,"Rate"]
[null,null,null,"Hourly Rate","$dollars/hr",null,88.153344438095232]
[]
[]
[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(K95,4)+1&\"-\"&RIGHT(K95,2)+1","v":"2027-28"},{"$f":"LEFT(L95,4)+1&\"-\"&RIGHT(L95,2)+1","v":"2028-29"},{"$f":"LEFT(M95,4)+1&\"-\"&RIGHT(M95,2)+1","v":"2029-30"},{"$f":"LEFT(N95,4)+1&\"-\"&RIGHT(N95,2)+1","v":"2030-31"}]
[null,null,null,"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,0,null,null,null,null,null,null,5,{"$f":"IF($H99=\"Fixed\",$I99*$G99,$G$91*$G99*$I99)","v":0},{"$f":"IF($H99=\"Fixed\",$I99*$G99,$G$91*$G99*$I99)","v":0},3,{"$f":"IF($H99=\"Fixed\",$I99*$G99,$G$91*$G99*$I99)","v":0}]
[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(K108,4)+1&\"-\"&RIGHT(K108,2)+1","v":"2027-28"},{"$f":"LEFT(L108,4)+1&\"-\"&RIGHT(L108,2)+1","v":"2028-29"},{"$f":"LEFT(M108,4)+1&\"-\"&RIGHT(M108,2)+1","v":"2029-30"},{"$f":"LEFT(N108,4)+1&\"-\"&RIGHT(N108,2)+1","v":"2030-31"}]
[null,null,null,{"$f":"D96","v":"Site visit @ 20% of the time to rectify issues and locate missing meters"},null,null,{"$f":"G96","v":175},"Calc-Fixed",{"$f":"I96","v":0.2},null,{"$f":"IF($H109=\"Calc-Fixed\",$I109*$G109,IF($H109=\"Calc-Hourly\",$G$91*$G109*$I109,IF($H109=\"Entered\",K96,0)))","v":35},{"$f":"IF($H109=\"Calc-Fixed\",$I109*$G109,IF($H109=\"Calc-Hourly\",$G$91*$G109*$I109,IF($H109=\"Entered\",L96,0)))","v":35},35,35,35]
[null,null,null,"Back-office admin processing",null,null,0.25,"Calc-Hourly",1,null,{"$f":"IF($H110=\"Calc-Fixed\",$I110*$G110,IF($H110=\"Calc-Hourly\",$G$91*$G110*$I110,IF($H110=\"Entered\",K97,0)))","v":22.038336109523808},22.038336109523808,22.038336109523808,22.038336109523808,22.038336109523808]
[null,null,null,"Receipt Meters into store",null,null,0.27,"Calc-Hourly",1,null,{"$f":"IF($H111=\"Calc-Fixed\",$I111*$G111,IF($H111=\"Calc-Hourly\",$G$91*$G111*$I111,IF($H111=\"Entered\",K98,0)))","v":23.801402998285713},23.801402998285713,23.801402998285713,23.801402998285713,23.801402998285713]
[null,null,null,0,null,null,0,0,0,null,{"$f":"IF($H112=\"Calc-Fixed\",$I112*$G112,IF($H112=\"Calc-Hourly\",$G$91*$G112*$I112,IF($H112=\"Entered\",K99,0)))","v":0},0,0,0,0]
[null,null,null,0,null,null,0,0,0,null,{"$f":"IF($H113=\"Calc-Fixed\",$I113*$G113,IF($H113=\"Calc-Hourly\",$G$91*$G113*$I113,IF($H113=\"Entered\",K100,0)))","v":0},0,0,0,0]
[null,null,null,0,null,null,0,0,0,null,{"$f":"IF($H114=\"Calc-Fixed\",$I114*$G114,IF($H114=\"Calc-Hourly\",$G$91*$G114*$I114,IF($H114=\"Entered\",K101,0)))","v":0},0,0,0,0]
[null,null,null,0,null,null,0,0,0,null,{"$f":"IF($H115=\"Calc-Fixed\",$I115*$G115,IF($H115=\"Calc-Hourly\",$G$91*$G115*$I115,IF($H115=\"Entered\",K102,0)))","v":0},0,0,0,0]
[null,null,null,0,null,null,0,0,0,null,{"$f":"IF($H116=\"Calc-Fixed\",$I116*$G116,IF($H116=\"Calc-Hourly\",$G$91*$G116*$I116,IF($H116=\"Entered\",K103,0)))","v":0},0,0,0,0]
[null,null,null,0,null,null,0,0,0,null,{"$f":"IF($H117=\"Calc-Fixed\",$I117*$G117,IF($H117=\"Calc-Hourly\",$G$91*$G117*$I117,IF($H117=\"Entered\",K104,0)))","v":0},0,0,0,0]
[null,null,null,0,null,null,0,0,0,null,{"$f":"IF($H118=\"Calc-Fixed\",$I118*$G118,IF($H118=\"Calc-Hourly\",$G$91*$G118*$I118,IF($H118=\"Entered\",K105,0)))","v":0},0,0,0,0]
[null,null,null,"TOTAL ADMIN and Handling",null,null,null,null,null,null,{"$f":"SUM(K109:K118)","v":80.839739107809521},{"$f":"SUM(L109:L118)","v":80.839739107809521},{"$f":"SUM(M109:M118)","v":80.839739107809521},{"$f":"SUM(N109:N118)","v":80.839739107809521},{"$f":"SUM(O109:O118)","v":80.839739107809521}]

{"sheet":"Calc | Exit Fees","index":9,"n_rows":160,"n_cols":15,"rows_kept":160,"cut":false,"hidden":false,"merged":[[98,6,98,10],[95,1,95,7],[0,13,0,14],[4,1,4,7],[54,10,54,14],[97,6,97,10],[69,10,69,14],[38,10,38,14],[86,10,86,14],[82,1,82,7],[8,10,8,14],[23,10,23,14]]}
[null,{"$f":"'Title Page'!B8&\" v\"&'Title Page'!$C$10","v":"Preliminary Standardised Metering Pricing Model  v1"},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"]
[]
[]
[null,"CALCULATION | Meters"]
[]
[null,"Calculation of Allocated Meters RAB by Designated Exit Fee"]
[]
[null,null,null,null,"Volume of meters",null,null,null,null,"Base Year","Regulatory period"]
[null,null,null,null,null,"Exit Fee","Units",null,null,{"$f":"LEFT(K10,4)-1&\"-\"&RIGHT(K10,2)-1","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(K10,4)+1&\"-\"&RIGHT(K10,2)+1","v":"2027-28"},{"$f":"LEFT(L10,4)+1&\"-\"&RIGHT(L10,2)+1","v":"2028-29"},{"$f":"LEFT(M10,4)+1&\"-\"&RIGHT(M10,2)+1","v":"2029-30"},{"$f":"LEFT(N10,4)+1&\"-\"&RIGHT(N10,2)+1","v":"2030-31"}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D$29:$D$38","v":"Single phase single element"},"$dollars",null,null,{"$f":"IF($F11=0,0,SUMPRODUCT('Input | Exit Fees'!J$69:J$83,('Input | Exit Fees'!$D$49:$D$63=$F11)/1))","v":573745.18699775648},{"$f":"IF($F11=0,0,SUMPRODUCT('Input | Exit Fees'!K$69:K$83,('Input | Exit Fees'!$D$49:$D$63=$F11)/1))","v":579476.92634379247},{"$f":"IF($F11=0,0,SUMPRODUCT('Input | Exit Fees'!L$69:L$83,('Input | Exit Fees'!$D$49:$D$63=$F11)/1))","v":583639.63678555156},{"$f":"IF($F11=0,0,SUMPRODUCT('Input | Exit Fees'!M$69:M$83,('Input | Exit Fees'!$D$49:$D$63=$F11)/1))","v":586339.19458024926},{"$f":"IF($F11=0,0,SUMPRODUCT('Input | Exit Fees'!N$69:N$83,('Input | Exit Fees'!$D$49:$D$63=$F11)/1))","v":587574.73850173294},{"$f":"IF($F11=0,0,SUMPRODUCT('Input | Exit Fees'!O$69:O$83,('Input | Exit Fees'!$D$49:$D$63=$F11)/1))","v":587155.40197282739}]
[null,null,null,null,null,"Single phase two element with contactor","$dollars",null,null,{"$f":"IF($F12=0,0,SUMPRODUCT('Input | Exit Fees'!J$69:J$83,('Input | Exit Fees'!$D$49:$D$63=$F12)/1))","v":117291.81300224352},{"$f":"IF($F12=0,0,SUMPRODUCT('Input | Exit Fees'!K$69:K$83,('Input | Exit Fees'!$D$49:$D$63=$F12)/1))","v":115944.46227490822},{"$f":"IF($F12=0,0,SUMPRODUCT('Input | Exit Fees'!L$69:L$83,('Input | Exit Fees'!$D$49:$D$63=$F12)/1))","v":114538.66771279977},{"$f":"IF($F12=0,0,SUMPRODUCT('Input | Exit Fees'!M$69:M$83,('Input | Exit Fees'!$D$49:$D$63=$F12)/1))","v":113116.76078998437},{"$f":"IF($F12=0,0,SUMPRODUCT('Input | Exit Fees'!N$69:N$83,('Input | Exit Fees'!$D$49:$D$63=$F12)/1))","v":111690.29404567374},{"$f":"IF($F12=0,0,SUMPRODUCT('Input | Exit Fees'!O$69:O$83,('Input | Exit Fees'!$D$49:$D$63=$F12)/1))","v":110228.38074365607}]
[null,null,null,null,null,"Multiphase","$dollars",null,null,{"$f":"IF($F13=0,0,SUMPRODUCT('Input | Exit Fees'!J$69:J$83,('Input | Exit Fees'!$D$49:$D$63=$F13)/1))","v":158168.274},{"$f":"IF($F13=0,0,SUMPRODUCT('Input | Exit Fees'!K$69:K$83,('Input | Exit Fees'!$D$49:$D$63=$F13)/1))","v":169190.44301535873},{"$f":"IF($F13=0,0,SUMPRODUCT('Input | Exit Fees'!L$69:L$83,('Input | Exit Fees'!$D$49:$D$63=$F13)/1))","v":182184.39657834644},{"$f":"IF($F13=0,0,SUMPRODUCT('Input | Exit Fees'!M$69:M$83,('Input | Exit Fees'!$D$49:$D$63=$F13)/1))","v":196994.80764710449},{"$f":"IF($F13=0,0,SUMPRODUCT('Input | Exit Fees'!N$69:N$83,('Input | Exit Fees'!$D$49:$D$63=$F13)/1))","v":213633.49070083382},{"$f":"IF($F13=0,0,SUMPRODUCT('Input | Exit Fees'!O$69:O$83,('Input | Exit Fees'!$D$49:$D$63=$F13)/1))","v":232322.05562679141}]
[null,null,null,null,null,"Multiphase CT connected","$dollars",null,null,{"$f":"IF($F14=0,0,SUMPRODUCT('Input | Exit Fees'!J$69:J$83,('Input | Exit Fees'!$D$49:$D$63=$F14)/1))","v":5270},{"$f":"IF($F14=0,0,SUMPRODUCT('Input | Exit Fees'!K$69:K$83,('Input | Exit Fees'!$D$49:$D$63=$F14)/1))","v":5354.6239853056986},{"$f":"IF($F14=0,0,SUMPRODUCT('Input | Exit Fees'!L$69:L$83,('Input | Exit Fees'!$D$49:$D$63=$F14)/1))","v":5440.142723075428},{"$f":"IF($F14=0,0,SUMPRODUCT('Input | Exit Fees'!M$69:M$83,('Input | Exit Fees'!$D$49:$D$63=$F14)/1))","v":5526.5272060611378},{"$f":"IF($F14=0,0,SUMPRODUCT('Input | Exit Fees'!N$69:N$83,('Input | Exit Fees'!$D$49:$D$63=$F14)/1))","v":5613.8444811737627},{"$f":"IF($F14=0,0,SUMPRODUCT('Input | Exit Fees'!O$69:O$83,('Input | Exit Fees'!$D$49:$D$63=$F14)/1))","v":5702.0603517930476}]
[null,null,null,null,null,0,"$dollars",null,null,{"$f":"IF($F15=0,0,SUMPRODUCT('Input | Exit Fees'!J$69:J$83,('Input | Exit Fees'!$D$49:$D$63=$F15)/1))","v":0},{"$f":"IF($F15=0,0,SUMPRODUCT('Input | Exit Fees'!K$69:K$83,('Input | Exit Fees'!$D$49:$D$63=$F15)/1))","v":0},{"$f":"IF($F15=0,0,SUMPRODUCT('Input | Exit Fees'!L$69:L$83,('Input | Exit Fees'!$D$49:$D$63=$F15)/1))","v":0},{"$f":"IF($F15=0,0,SUMPRODUCT('Input | Exit Fees'!M$69:M$83,('Input | Exit Fees'!$D$49:$D$63=$F15)/1))","v":0},{"$f":"IF($F15=0,0,SUMPRODUCT('Input | Exit Fees'!N$69:N$83,('Input | Exit Fees'!$D$49:$D$63=$F15)/1))","v":0},{"$f":"IF($F15=0,0,SUMPRODUCT('Input | Exit Fees'!O$69:O$83,('Input | Exit Fees'!$D$49:$D$63=$F15)/1))","v":0}]
[null,null,null,null,null,0,"$dollars",null,null,{"$f":"IF($F16=0,0,SUMPRODUCT('Input | Exit Fees'!J$69:J$83,('Input | Exit Fees'!$D$49:$D$63=$F16)/1))","v":0},{"$f":"IF($F16=0,0,SUMPRODUCT('Input | Exit Fees'!K$69:K$83,('Input | Exit Fees'!$D$49:$D$63=$F16)/1))","v":0},{"$f":"IF($F16=0,0,SUMPRODUCT('Input | Exit Fees'!L$69:L$83,('Input | Exit Fees'!$D$49:$D$63=$F16)/1))","v":0},{"$f":"IF($F16=0,0,SUMPRODUCT('Input | Exit Fees'!M$69:M$83,('Input | Exit Fees'!$D$49:$D$63=$F16)/1))","v":0},{"$f":"IF($F16=0,0,SUMPRODUCT('Input | Exit Fees'!N$69:N$83,('Input | Exit Fees'!$D$49:$D$63=$F16)/1))","v":0},{"$f":"IF($F16=0,0,SUMPRODUCT('Input | Exit Fees'!O$69:O$83,('Input | Exit Fees'!$D$49:$D$63=$F16)/1))","v":0}]
[null,null,null,null,null,0,"$dollars",null,null,{"$f":"IF($F17=0,0,SUMPRODUCT('Input | Exit Fees'!J$69:J$83,('Input | Exit Fees'!$D$49:$D$63=$F17)/1))","v":0},{"$f":"IF($F17=0,0,SUMPRODUCT('Input | Exit Fees'!K$69:K$83,('Input | Exit Fees'!$D$49:$D$63=$F17)/1))","v":0},{"$f":"IF($F17=0,0,SUMPRODUCT('Input | Exit Fees'!L$69:L$83,('Input | Exit Fees'!$D$49:$D$63=$F17)/1))","v":0},{"$f":"IF($F17=0,0,SUMPRODUCT('Input | Exit Fees'!M$69:M$83,('Input | Exit Fees'!$D$49:$D$63=$F17)/1))","v":0},{"$f":"IF($F17=0,0,SUMPRODUCT('Input | Exit Fees'!N$69:N$83,('Input | Exit Fees'!$D$49:$D$63=$F17)/1))","v":0},{"$f":"IF($F17=0,0,SUMPRODUCT('Input | Exit Fees'!O$69:O$83,('Input | Exit Fees'!$D$49:$D$63=$F17)/1))","v":0}]
[null,null,null,null,null,0,"$dollars",null,null,{"$f":"IF($F18=0,0,SUMPRODUCT('Input | Exit Fees'!J$69:J$83,('Input | Exit Fees'!$D$49:$D$63=$F18)/1))","v":0},{"$f":"IF($F18=0,0,SUMPRODUCT('Input | Exit Fees'!K$69:K$83,('Input | Exit Fees'!$D$49:$D$63=$F18)/1))","v":0},{"$f":"IF($F18=0,0,SUMPRODUCT('Input | Exit Fees'!L$69:L$83,('Input | Exit Fees'!$D$49:$D$63=$F18)/1))","v":0},{"$f":"IF($F18=0,0,SUMPRODUCT('Input | Exit Fees'!M$69:M$83,('Input | Exit Fees'!$D$49:$D$63=$F18)/1))","v":0},{"$f":"IF($F18=0,0,SUMPRODUCT('Input | Exit Fees'!N$69:N$83,('Input | Exit Fees'!$D$49:$D$63=$F18)/1))","v":0},{"$f":"IF($F18=0,0,SUMPRODUCT('Input | Exit Fees'!O$69:O$83,('Input | Exit Fees'!$D$49:$D$63=$F18)/1))","v":0}]
[null,null,null,null,null,0,"$dollars",null,null,{"$f":"IF($F19=0,0,SUMPRODUCT('Input | Exit Fees'!J$69:J$83,('Input | Exit Fees'!$D$49:$D$63=$F19)/1))","v":0},{"$f":"IF($F19=0,0,SUMPRODUCT('Input | Exit Fees'!K$69:K$83,('Input | Exit Fees'!$D$49:$D$63=$F19)/1))","v":0},{"$f":"IF($F19=0,0,SUMPRODUCT('Input | Exit Fees'!L$69:L$83,('Input | Exit Fees'!$D$49:$D$63=$F19)/1))","v":0},{"$f":"IF($F19=0,0,SUMPRODUCT('Input | Exit Fees'!M$69:M$83,('Input | Exit Fees'!$D$49:$D$63=$F19)/1))","v":0},{"$f":"IF($F19=0,0,SUMPRODUCT('Input | Exit Fees'!N$69:N$83,('Input | Exit Fees'!$D$49:$D$63=$F19)/1))","v":0},{"$f":"IF($F19=0,0,SUMPRODUCT('Input | Exit Fees'!O$69:O$83,('Input | Exit Fees'!$D$49:$D$63=$F19)/1))","v":0}]
[null,null,null,null,null,0,"$dollars",null,null,{"$f":"IF($F20=0,0,SUMPRODUCT('Input | Exit Fees'!J$69:J$83,('Input | Exit Fees'!$D$49:$D$63=$F20)/1))","v":0},{"$f":"IF($F20=0,0,SUMPRODUCT('Input | Exit Fees'!K$69:K$83,('Input | Exit Fees'!$D$49:$D$63=$F20)/1))","v":0},{"$f":"IF($F20=0,0,SUMPRODUCT('Input | Exit Fees'!L$69:L$83,('Input | Exit Fees'!$D$49:$D$63=$F20)/1))","v":0},{"$f":"IF($F20=0,0,SUMPRODUCT('Input | Exit Fees'!M$69:M$83,('Input | Exit Fees'!$D$49:$D$63=$F20)/1))","v":0},{"$f":"IF($F20=0,0,SUMPRODUCT('Input | Exit Fees'!N$69:N$83,('Input | Exit Fees'!$D$49:$D$63=$F20)/1))","v":0},{"$f":"IF($F20=0,0,SUMPRODUCT('Input | Exit Fees'!O$69:O$83,('Input | Exit Fees'!$D$49:$D$63=$F20)/1))","v":0}]
[null,null,null,null,null,"Total","$dollars",null,null,{"$f":"SUM(J11:J20)","v":854475.27399999998},869966.45561936509,885802.84379977325,901977.29022339929,918512.36772941425,935407.89869506797]
[]
[]
[null,null,null,null,"Cost-Weighted Volume of Meters",null,null,null,null,null,"Regulatory period"]
[null,null,null,null,null,"Exit Fee","Units",null,null,null,{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(K25,4)+1&\"-\"&RIGHT(K25,2)+1","v":"2027-28"},{"$f":"LEFT(L25,4)+1&\"-\"&RIGHT(L25,2)+1","v":"2028-29"},{"$f":"LEFT(M25,4)+1&\"-\"&RIGHT(M25,2)+1","v":"2029-30"},{"$f":"LEFT(N25,4)+1&\"-\"&RIGHT(N25,2)+1","v":"2030-31"}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D$29:$D$38","v":"Single phase single element"},"$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!K$69:K$83,('Input | Exit Fees'!$D$49:$D$63=$F26)/1)","v":324541834.28156817},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!L$69:L$83,('Input | Exit Fees'!$D$49:$D$63=$F26)/1)","v":326873201.79757178},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!M$69:M$83,('Input | Exit Fees'!$D$49:$D$63=$F26)/1)","v":328385116.07510507},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!N$69:N$83,('Input | Exit Fees'!$D$49:$D$63=$F26)/1)","v":329077094.77586848},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!O$69:O$83,('Input | Exit Fees'!$D$49:$D$63=$F26)/1)","v":328842241.16895968}]
[null,null,null,null,null,"Single phase two element with contactor","$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!K$69:K$83,('Input | Exit Fees'!$D$49:$D$63=$F27)/1)","v":67656397.491138786},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!L$69:L$83,('Input | Exit Fees'!$D$49:$D$63=$F27)/1)","v":66836082.369409382},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!M$69:M$83,('Input | Exit Fees'!$D$49:$D$63=$F27)/1)","v":66006365.295580499},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!N$69:N$83,('Input | Exit Fees'!$D$49:$D$63=$F27)/1)","v":65173987.455644138},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!O$69:O$83,('Input | Exit Fees'!$D$49:$D$63=$F27)/1)","v":64320925.692121737}]
[null,null,null,null,null,"Multiphase","$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!K$69:K$83,('Input | Exit Fees'!$D$49:$D$63=$F28)/1)","v":114896472.8334858},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!L$69:L$83,('Input | Exit Fees'!$D$49:$D$63=$F28)/1)","v":123720608.55853893},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!M$69:M$83,('Input | Exit Fees'!$D$49:$D$63=$F28)/1)","v":133778292.44828349},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!N$69:N$83,('Input | Exit Fees'!$D$49:$D$63=$F28)/1)","v":145077547.66268262},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!O$69:O$83,('Input | Exit Fees'!$D$49:$D$63=$F28)/1)","v":157768868.48461106}]
[null,null,null,null,null,"Multiphase CT connected","$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!K$69:K$83,('Input | Exit Fees'!$D$49:$D$63=$F29)/1)","v":6636143.8107877914},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!L$69:L$83,('Input | Exit Fees'!$D$49:$D$63=$F29)/1)","v":6742129.7108088508},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!M$69:M$83,('Input | Exit Fees'!$D$49:$D$63=$F29)/1)","v":6849188.5544712394},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!N$69:N$83,('Input | Exit Fees'!$D$49:$D$63=$F29)/1)","v":6957403.4349938761},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!O$69:O$83,('Input | Exit Fees'!$D$49:$D$63=$F29)/1)","v":7066731.9714942789}]
[null,null,null,null,null,0,"$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!K$69:K$83,('Input | Exit Fees'!$D$49:$D$63=$F30)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!L$69:L$83,('Input | Exit Fees'!$D$49:$D$63=$F30)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!M$69:M$83,('Input | Exit Fees'!$D$49:$D$63=$F30)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!N$69:N$83,('Input | Exit Fees'!$D$49:$D$63=$F30)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!O$69:O$83,('Input | Exit Fees'!$D$49:$D$63=$F30)/1)","v":0}]
[null,null,null,null,null,0,"$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!K$69:K$83,('Input | Exit Fees'!$D$49:$D$63=$F31)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!L$69:L$83,('Input | Exit Fees'!$D$49:$D$63=$F31)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!M$69:M$83,('Input | Exit Fees'!$D$49:$D$63=$F31)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!N$69:N$83,('Input | Exit Fees'!$D$49:$D$63=$F31)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!O$69:O$83,('Input | Exit Fees'!$D$49:$D$63=$F31)/1)","v":0}]
[null,null,null,null,null,0,"$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!K$69:K$83,('Input | Exit Fees'!$D$49:$D$63=$F32)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!L$69:L$83,('Input | Exit Fees'!$D$49:$D$63=$F32)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!M$69:M$83,('Input | Exit Fees'!$D$49:$D$63=$F32)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!N$69:N$83,('Input | Exit Fees'!$D$49:$D$63=$F32)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!O$69:O$83,('Input | Exit Fees'!$D$49:$D$63=$F32)/1)","v":0}]
[null,null,null,null,null,0,"$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!K$69:K$83,('Input | Exit Fees'!$D$49:$D$63=$F33)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!L$69:L$83,('Input | Exit Fees'!$D$49:$D$63=$F33)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!M$69:M$83,('Input | Exit Fees'!$D$49:$D$63=$F33)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!N$69:N$83,('Input | Exit Fees'!$D$49:$D$63=$F33)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!O$69:O$83,('Input | Exit Fees'!$D$49:$D$63=$F33)/1)","v":0}]
[null,null,null,null,null,0,"$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!K$69:K$83,('Input | Exit Fees'!$D$49:$D$63=$F34)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!L$69:L$83,('Input | Exit Fees'!$D$49:$D$63=$F34)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!M$69:M$83,('Input | Exit Fees'!$D$49:$D$63=$F34)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!N$69:N$83,('Input | Exit Fees'!$D$49:$D$63=$F34)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!O$69:O$83,('Input | Exit Fees'!$D$49:$D$63=$F34)/1)","v":0}]
[null,null,null,null,null,0,"$dollars",null,null,null,{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!K$69:K$83,('Input | Exit Fees'!$D$49:$D$63=$F35)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!L$69:L$83,('Input | Exit Fees'!$D$49:$D$63=$F35)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!M$69:M$83,('Input | Exit Fees'!$D$49:$D$63=$F35)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!N$69:N$83,('Input | Exit Fees'!$D$49:$D$63=$F35)/1)","v":0},{"$f":"SUMPRODUCT('Input | Exit Fees'!$M$49:$M$63,'Input | Exit Fees'!O$69:O$83,('Input | Exit Fees'!$D$49:$D$63=$F35)/1)","v":0}]
[null,null,null,null,null,"Total","$dollars",null,null,null,{"$f":"SUM(K26:K35)","v":513730848.41698056},{"$f":"SUM(L26:L35)","v":524172022.43632895},{"$f":"SUM(M26:M35)","v":535018962.37344033},{"$f":"SUM(N26:N35)","v":546286033.32918906},{"$f":"SUM(O26:O35)","v":557998767.31718683}]
[]
[]
[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(K40,4)+1&\"-\"&RIGHT(K40,2)+1","v":"2027-28"},{"$f":"LEFT(L40,4)+1&\"-\"&RIGHT(L40,2)+1","v":"2028-29"},{"$f":"LEFT(M40,4)+1&\"-\"&RIGHT(M40,2)+1","v":"2029-30"},{"$f":"LEFT(N40,4)+1&\"-\"&RIGHT(N40,2)+1","v":"2030-31"}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D$29:$D$38","v":"Single phase single element"},"%",null,null,null,{"$f":"K26/K$36","v":0.63173514941066355},0.62359910068889068,0.61378220057533972,0.60238972753961728,0.5893243147292363]
[null,null,null,null,null,"Single phase two element with contactor","%",null,null,null,0.1316961940277023,0.12750791631105787,0.12337201097090914,0.11930377765373079,0.11527073079636281]
[null,null,null,null,null,"Multiphase","%",null,null,null,0.22365110677610631,0.23603054581870067,0.25004402059848296,0.26557066959692827,0.28274053228316448]
[null,null,null,null,null,"Multiphase CT connected","%",null,null,null,1.2917549785527819E-2,1.2862437181350737E-2,1.2801767855268171E-2,1.2735825209723753E-2,1.2664422191236296E-2]
[null,null,null,null,null,0,"%",null,null,null,0,0,0,0,0]
[null,null,null,null,null,0,"%",null,null,null,0,0,0,0,0]
[null,null,null,null,null,0,"%",null,null,null,0,0,0,0,0]
[null,null,null,null,null,0,"%",null,null,null,0,0,0,0,0]
[null,null,null,null,null,0,"%",null,null,null,0,0,0,0,0]
[null,null,null,null,null,0,"%",null,null,null,0,0,0,0,0]
[null,null,null,null,null,"Total","%",null,null,null,{"$f":"SUM(K41:K50)","v":1},{"$f":"SUM(L41:L50)","v":0.99999999999999989},{"$f":"SUM(M41:M50)","v":1},{"$f":"SUM(N41:N50)","v":1.0000000000000002},{"$f":"SUM(O41:O50)","v":0.99999999999999989}]
[{"$f":"PRODUCT(J52:O52)","v":1},null,null,null,null,null,null,null,null,null,{"$f":"(K51=1)/1","v":1},{"$f":"(L51=1)/1","v":1},{"$f":"(M51=1)/1","v":1},{"$f":"(N51=1)/1","v":1},{"$f":"(O51=1)/1","v":1}]
[]
[]
[null,null,null,null,"Allocated Meter RAB by Designated Exit Fee",null,null,null,null,null,"Regulatory period"]
[null,null,null,null,null,"Exit Fee","Units",null,null,null,{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(K56,4)+1&\"-\"&RIGHT(K56,2)+1","v":"2027-28"},{"$f":"LEFT(L56,4)+1&\"-\"&RIGHT(L56,2)+1","v":"2028-29"},{"$f":"LEFT(M56,4)+1&\"-\"&RIGHT(M56,2)+1","v":"2029-30"},{"$f":"LEFT(N56,4)+1&\"-\"&RIGHT(N56,2)+1","v":"2030-31"}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D$29:$D$38","v":"Single phase single element"},"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$8:H$9)*'Calc | Exit Fees'!K41","v":47.522189068272098},{"$f":"AVERAGE('Input | Exit Fees'!H$8:I$9)*'Calc | Exit Fees'!L41","v":40.004178839772706},{"$f":"AVERAGE('Input | Exit Fees'!I$8:J$9)*'Calc | Exit Fees'!M41","v":34.194504950567868},{"$f":"AVERAGE('Input | Exit Fees'!J$8:K$9)*'Calc | Exit Fees'!N41","v":43.430758237313448},{"$f":"AVERAGE('Input | Exit Fees'!K$8:L$9)*'Calc | Exit Fees'!O41","v":64.077296034588926}]
[null,null,null,null,null,"Single phase two element with contactor","$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$8:H$9)*'Calc | Exit Fees'!K42","v":9.9068279452152854},{"$f":"AVERAGE('Input | Exit Fees'!H$8:I$9)*'Calc | Exit Fees'!L42","v":8.1796934632513363},{"$f":"AVERAGE('Input | Exit Fees'!I$8:J$9)*'Calc | Exit Fees'!M42","v":6.8731951430847031},{"$f":"AVERAGE('Input | Exit Fees'!J$8:K$9)*'Calc | Exit Fees'!N42","v":8.6014971490970726},{"$f":"AVERAGE('Input | Exit Fees'!K$8:L$9)*'Calc | Exit Fees'!O42","v":12.533398939691697}]
[null,null,null,null,null,"Multiphase","$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$8:H$9)*'Calc | Exit Fees'!K43","v":16.824123513560238},{"$f":"AVERAGE('Input | Exit Fees'!H$8:I$9)*'Calc | Exit Fees'!L43","v":15.141471750279385},{"$f":"AVERAGE('Input | Exit Fees'!I$8:J$9)*'Calc | Exit Fees'!M43","v":13.930236967119773},{"$f":"AVERAGE('Input | Exit Fees'!J$8:K$9)*'Calc | Exit Fees'!N43","v":19.146965857625933},{"$f":"AVERAGE('Input | Exit Fees'!K$8:L$9)*'Calc | Exit Fees'!O43","v":30.742408441792371}]
[null,null,null,null,null,"Multiphase CT connected","$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$8:H$9)*'Calc | Exit Fees'!K44","v":0.9717208924963906},{"$f":"AVERAGE('Input | Exit Fees'!H$8:I$9)*'Calc | Exit Fees'!L44","v":0.82513146146245486},{"$f":"AVERAGE('Input | Exit Fees'!I$8:J$9)*'Calc | Exit Fees'!M44","v":0.71320105713827353},{"$f":"AVERAGE('Input | Exit Fees'!J$8:K$9)*'Calc | Exit Fees'!N44","v":0.91822041503823082},{"$f":"AVERAGE('Input | Exit Fees'!K$8:L$9)*'Calc | Exit Fees'!O44","v":1.3770039850259839}]
[null,null,null,null,null,0,"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$8:H$9)*'Calc | Exit Fees'!K45","v":0},{"$f":"AVERAGE('Input | Exit Fees'!H$8:I$9)*'Calc | Exit Fees'!L45","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$8:J$9)*'Calc | Exit Fees'!M45","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$8:K$9)*'Calc | Exit Fees'!N45","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$8:L$9)*'Calc | Exit Fees'!O45","v":0}]
[null,null,null,null,null,0,"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$8:H$9)*'Calc | Exit Fees'!K46","v":0},{"$f":"AVERAGE('Input | Exit Fees'!H$8:I$9)*'Calc | Exit Fees'!L46","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$8:J$9)*'Calc | Exit Fees'!M46","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$8:K$9)*'Calc | Exit Fees'!N46","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$8:L$9)*'Calc | Exit Fees'!O46","v":0}]
[null,null,null,null,null,0,"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$8:H$9)*'Calc | Exit Fees'!K47","v":0},{"$f":"AVERAGE('Input | Exit Fees'!H$8:I$9)*'Calc | Exit Fees'!L47","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$8:J$9)*'Calc | Exit Fees'!M47","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$8:K$9)*'Calc | Exit Fees'!N47","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$8:L$9)*'Calc | Exit Fees'!O47","v":0}]
[null,null,null,null,null,0,"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$8:H$9)*'Calc | Exit Fees'!K48","v":0},{"$f":"AVERAGE('Input | Exit Fees'!H$8:I$9)*'Calc | Exit Fees'!L48","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$8:J$9)*'Calc | Exit Fees'!M48","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$8:K$9)*'Calc | Exit Fees'!N48","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$8:L$9)*'Calc | Exit Fees'!O48","v":0}]
[null,null,null,null,null,0,"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$8:H$9)*'Calc | Exit Fees'!K49","v":0},{"$f":"AVERAGE('Input | Exit Fees'!H$8:I$9)*'Calc | Exit Fees'!L49","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$8:J$9)*'Calc | Exit Fees'!M49","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$8:K$9)*'Calc | Exit Fees'!N49","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$8:L$9)*'Calc | Exit Fees'!O49","v":0}]
[null,null,null,null,null,0,"$m",null,null,null,{"$f":"AVERAGE('Input | Exit Fees'!G$8:H$9)*'Calc | Exit Fees'!K50","v":0},{"$f":"AVERAGE('Input | Exit Fees'!H$8:I$9)*'Calc | Exit Fees'!L50","v":0},{"$f":"AVERAGE('Input | Exit Fees'!I$8:J$9)*'Calc | Exit Fees'!M50","v":0},{"$f":"AVERAGE('Input | Exit Fees'!J$8:K$9)*'Calc | Exit Fees'!N50","v":0},{"$f":"AVERAGE('Input | Exit Fees'!K$8:L$9)*'Calc | Exit Fees'!O50","v":0}]
[null,null,null,null,null,"Total","$m",null,null,null,{"$f":"SUM(K57:K66)","v":75.224861419544013},{"$f":"SUM(L57:L66)","v":64.150475514765887},{"$f":"SUM(M57:M66)","v":55.711138117910615},{"$f":"SUM(N57:N66)","v":72.09744165907469},{"$f":"SUM(O57:O66)","v":108.73010740109898}]
[{"$f":"PRODUCT(J68:O68)","v":1},null,null,null,null,null,null,null,null,null,{"$f":"(K67=AVERAGE('Input | Exit Fees'!G$8:H$9))/1","v":1},{"$f":"(L67=AVERAGE('Input | Exit Fees'!H$8:I$9))/1","v":1},{"$f":"(M67=AVERAGE('Input | Exit Fees'!I$8:J$9))/1","v":1},{"$f":"(N67=AVERAGE('Input | Exit Fees'!J$8:K$9))/1","v":1},{"$f":"(O67=AVERAGE('Input | Exit Fees'!K$8:L$9))/1","v":1}]
[]
[null,null,null,null,"Allocated Meter RAB by Designated Exit Fee Per Meter",null,null,null,null,null,"Regulatory period"]
[null,null,null,null,null,"Exit Fee","Units",null,null,null,{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(K71,4)+1&\"-\"&RIGHT(K71,2)+1","v":"2027-28"},{"$f":"LEFT(L71,4)+1&\"-\"&RIGHT(L71,2)+1","v":"2028-29"},{"$f":"LEFT(M71,4)+1&\"-\"&RIGHT(M71,2)+1","v":"2029-30"},{"$f":"LEFT(N71,4)+1&\"-\"&RIGHT(N71,2)+1","v":"2030-31"}]
[null,null,null,null,null,{"$f":"'Input | Exit Fees'!$D$29:$D$38","v":"Single phase single element"},"$dollars",null,null,null,{"$f":"IFERROR(K57*10^6/K11,0)","v":82.008768439000974},68.54260115042797,58.318640927709367,73.915291777278071,109.13174914050151]
[null,null,null,null,null,"Single phase two element with contactor","$dollars",null,null,null,85.444597791362057,71.414253601775144,60.761951589523171,77.012037819326039,113.70391958164572]
[null,null,null,null,null,"Multiphase","$dollars",null,null,null,99.438970746314453,83.110694629481927,70.713726587526764,89.625300765406635,132.32668916797908]
[null,null,null,null,null,"Multiphase CT connected","$dollars",null,null,null,181.47322672199073,151.67459816127592,129.05049238807342,163.56356470463643,241.49235540675687]
[null,null,null,null,null,0,"$dollars",null,null,null,0,0,0,0,0]
[null,null,null,null,null,0,"$dollars",null,null,null,0,0,0,0,0]
[null,null,null,null,null,0,"$dollars",null,null,null,0,0,0,0,0]
[null,null,null,null,null,0,"$dollars",null,null,null,0,0,0,0,0]
[null,null,null,null,null,0,"$dollars",null,null,null,0,0,0,0,0]
[null,null,null,null,null,0,"$dollars",null,null,null,0,0,0,0,0]
[]
[null,"Calculations | Comms & IT"]
[]
[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(K88,4)+1&\"-\"&RIGHT(K88,2)+1","v":"2027-28"},{"$f":"LEFT(L88,4)+1&\"-\"&RIGHT(L88,2)+1","v":"2028-29"},{"$f":"LEFT(M88,4)+1&\"-\"&RIGHT(M88,2)+1","v":"2029-30"},{"$f":"LEFT(N88,4)+1&\"-\"&RIGHT(N88,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$16:H$16)*10^6)/'Calc | Exit Fees'!K$21","v":47.675166541730235},{"$f":"(AVERAGE('Input | Exit Fees'!H$16:I$16)*10^6)/'Calc | Exit Fees'!L$21","v":44.350432264130724},{"$f":"(AVERAGE('Input | Exit Fees'!I$16:J$16)*10^6)/'Calc | Exit Fees'!M$21","v":38.214790666022203},{"$f":"(AVERAGE('Input | Exit Fees'!J$16:K$16)*10^6)/'Calc | Exit Fees'!N$21","v":33.443076078136784},{"$f":"(AVERAGE('Input | Exit Fees'!K$16:L$16)*10^6)/'Calc | Exit Fees'!O$21","v":29.444277412115071}]
[]
[]
[]
[]
[]
[]
[null,"Calculations | Exit Fees with Component Detail"]
[]
[null,null,null,null,null,"Base Year","Regulatory period"]
[null,null,null,null,null,null,"Tariff ($/year)"]
[null,null,"No.","Exit Fee Name","Component","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26"]
[null,null,1,{"$f":"'Input | Exit Fees'!D29","v":"Single phase single element"}]
[null,null,null,null,"Meter RAB",null,{"$f":"IF($D101=0,0,SUMIFS('Calc | Exit Fees'!K$72:K$81,'Input | Exit Fees'!$D$29:$D$38,$D101))","v":82.008768439000974},{"$f":"IF($D101=0,0,SUMIFS('Calc | Exit Fees'!L$72:L$81,'Input | Exit Fees'!$D$29:$D$38,$D101))","v":68.54260115042797},{"$f":"IF($D101=0,0,SUMIFS('Calc | Exit Fees'!M$72:M$81,'Input | Exit Fees'!$D$29:$D$38,$D101))","v":58.318640927709367},{"$f":"IF($D101=0,0,SUMIFS('Calc | Exit Fees'!N$72:N$81,'Input | Exit Fees'!$D$29:$D$38,$D101))","v":73.915291777278071},{"$f":"IF($D101=0,0,SUMIFS('Calc | Exit Fees'!O$72:O$81,'Input | Exit Fees'!$D$29:$D$38,$D101))","v":109.13174914050151}]
[null,null,null,null,"Comms & IT",null,{"$f":"IF($D101=0,0,'Calc | Exit Fees'!K$89)","v":47.675166541730235},{"$f":"IF($D101=0,0,'Calc | Exit Fees'!L$89)","v":44.350432264130724},{"$f":"IF($D101=0,0,'Calc | Exit Fees'!M$89)","v":38.214790666022203},{"$f":"IF($D101=0,0,'Calc | Exit Fees'!N$89)","v":33.443076078136784},{"$f":"IF($D101=0,0,'Calc | Exit Fees'!O$89)","v":29.444277412115071}]
[null,null,null,null,"Admin cost",null,{"$f":"IF($D101=0,0,'Input | Exit Fees'!K$119)","v":80.839739107809521},{"$f":"IF($D101=0,0,'Input | Exit Fees'!L$119)","v":80.839739107809521},{"$f":"IF($D101=0,0,'Input | Exit Fees'!M$119)","v":80.839739107809521},{"$f":"IF($D101=0,0,'Input | Exit Fees'!N$119)","v":80.839739107809521},{"$f":"IF($D101=0,0,'Input | Exit Fees'!O$119)","v":80.839739107809521}]
[]
[null,null,null,null,"TOTAL exit fee",{"$f":"IF(D101=0,0,'Input | Exit Fees'!G29)","v":287.57},{"$f":"SUM(G102:G105)","v":210.52367408854073},{"$f":"SUM(H102:H105)","v":193.73277252236821},177.37317070154108,188.19810696322438,219.4157656604261]
[null,null,2,{"$f":"'Input | Exit Fees'!D30","v":"Single phase two element with contactor"}]
[null,null,null,null,{"$f":"IF($D107=0,\"\",E$102)","v":"Meter RAB"},null,{"$f":"IF($D107=0,0,SUMIFS('Calc | Exit Fees'!K$72:K$81,'Input | Exit Fees'!$D$29:$D$38,$D107))","v":85.444597791362057},{"$f":"IF($D107=0,0,SUMIFS('Calc | Exit Fees'!L$72:L$81,'Input | Exit Fees'!$D$29:$D$38,$D107))","v":71.414253601775144},{"$f":"IF($D107=0,0,SUMIFS('Calc | Exit Fees'!M$72:M$81,'Input | Exit Fees'!$D$29:$D$38,$D107))","v":60.761951589523171},{"$f":"IF($D107=0,0,SUMIFS('Calc | Exit Fees'!N$72:N$81,'Input | Exit Fees'!$D$29:$D$38,$D107))","v":77.012037819326039},{"$f":"IF($D107=0,0,SUMIFS('Calc | Exit Fees'!O$72:O$81,'Input | Exit Fees'!$D$29:$D$38,$D107))","v":113.70391958164572}]
[null,null,null,null,{"$f":"IF($D107=0,\"\",E$103)","v":"Comms & IT"},null,{"$f":"IF($D107=0,0,'Calc | Exit Fees'!K$89)","v":47.675166541730235},{"$f":"IF($D107=0,0,'Calc | Exit Fees'!L$89)","v":44.350432264130724},{"$f":"IF($D107=0,0,'Calc | Exit Fees'!M$89)","v":38.214790666022203},{"$f":"IF($D107=0,0,'Calc | Exit Fees'!N$89)","v":33.443076078136784},{"$f":"IF($D107=0,0,'Calc | Exit Fees'!O$89)","v":29.444277412115071}]
[null,null,null,null,{"$f":"IF($D107=0,\"\",E$104)","v":"Admin cost"},null,{"$f":"IF($D107=0,0,'Input | Exit Fees'!K$119)","v":80.839739107809521},{"$f":"IF($D107=0,0,'Input | Exit Fees'!L$119)","v":80.839739107809521},{"$f":"IF($D107=0,0,'Input | Exit Fees'!M$119)","v":80.839739107809521},{"$f":"IF($D107=0,0,'Input | Exit Fees'!N$119)","v":80.839739107809521},{"$f":"IF($D107=0,0,'Input | Exit Fees'!O$119)","v":80.839739107809521}]
[]
[null,null,null,null,{"$f":"IF($D107=0,\"\",E$106)","v":"TOTAL exit fee"},{"$f":"IF(D107=0,0,'Input | Exit Fees'!G30)","v":287.57},{"$f":"SUM(G108:G111)","v":213.95950344090181},{"$f":"SUM(H108:H111)","v":196.6044249737154},179.81648136335491,191.29485300527233,223.98793610157031]
[null,null,3,{"$f":"'Input | Exit Fees'!D31","v":"Multiphase"}]
[null,null,null,null,{"$f":"IF($D113=0,\"\",E$102)","v":"Meter RAB"},null,{"$f":"IF($D113=0,0,SUMIFS('Calc | Exit Fees'!K$72:K$81,'Input | Exit Fees'!$D$29:$D$38,$D113))","v":99.438970746314453},{"$f":"IF($D113=0,0,SUMIFS('Calc | Exit Fees'!L$72:L$81,'Input | Exit Fees'!$D$29:$D$38,$D113))","v":83.110694629481927},{"$f":"IF($D113=0,0,SUMIFS('Calc | Exit Fees'!M$72:M$81,'Input | Exit Fees'!$D$29:$D$38,$D113))","v":70.713726587526764},{"$f":"IF($D113=0,0,SUMIFS('Calc | Exit Fees'!N$72:N$81,'Input | Exit Fees'!$D$29:$D$38,$D113))","v":89.625300765406635},{"$f":"IF($D113=0,0,SUMIFS('Calc | Exit Fees'!O$72:O$81,'Input | Exit Fees'!$D$29:$D$38,$D113))","v":132.32668916797908}]
[null,null,null,null,{"$f":"IF($D113=0,\"\",E$103)","v":"Comms & IT"},null,{"$f":"IF($D113=0,0,'Calc | Exit Fees'!K$89)","v":47.675166541730235},{"$f":"IF($D113=0,0,'Calc | Exit Fees'!L$89)","v":44.350432264130724},{"$f":"IF($D113=0,0,'Calc | Exit Fees'!M$89)","v":38.214790666022203},{"$f":"IF($D113=0,0,'Calc | Exit Fees'!N$89)","v":33.443076078136784},{"$f":"IF($D113=0,0,'Calc | Exit Fees'!O$89)","v":29.444277412115071}]
[null,null,null,null,{"$f":"IF($D113=0,\"\",E$104)","v":"Admin cost"},null,{"$f":"IF($D113=0,0,'Input | Exit Fees'!K$119)","v":80.839739107809521},{"$f":"IF($D113=0,0,'Input | Exit Fees'!L$119)","v":80.839739107809521},{"$f":"IF($D113=0,0,'Input | Exit Fees'!M$119)","v":80.839739107809521},{"$f":"IF($D113=0,0,'Input | Exit Fees'!N$119)","v":80.839739107809521},{"$f":"IF($D113=0,0,'Input | Exit Fees'!O$119)","v":80.839739107809521}]
[]
[null,null,null,null,{"$f":"IF($D113=0,\"\",E$106)","v":"TOTAL exit fee"},{"$f":"IF(D113=0,0,'Input | Exit Fees'!G31)","v":287.57},{"$f":"SUM(G114:G117)","v":227.95387639585419},{"$f":"SUM(H114:H117)","v":208.30086600142218},189.76825636135848,203.90811595135295,242.61070568790367]
[null,null,4,{"$f":"'Input | Exit Fees'!D32","v":"Multiphase CT connected"}]
[null,null,null,null,{"$f":"IF($D119=0,\"\",E$102)","v":"Meter RAB"},null,{"$f":"IF($D119=0,0,SUMIFS('Calc | Exit Fees'!K$72:K$81,'Input | Exit Fees'!$D$29:$D$38,$D119))","v":181.47322672199073},{"$f":"IF($D119=0,0,SUMIFS('Calc | Exit Fees'!L$72:L$81,'Input | Exit Fees'!$D$29:$D$38,$D119))","v":151.67459816127592},{"$f":"IF($D119=0,0,SUMIFS('Calc | Exit Fees'!M$72:M$81,'Input | Exit Fees'!$D$29:$D$38,$D119))","v":129.05049238807342},{"$f":"IF($D119=0,0,SUMIFS('Calc | Exit Fees'!N$72:N$81,'Input | Exit Fees'!$D$29:$D$38,$D119))","v":163.56356470463643},{"$f":"IF($D119=0,0,SUMIFS('Calc | Exit Fees'!O$72:O$81,'Input | Exit Fees'!$D$29:$D$38,$D119))","v":241.49235540675687}]
[null,null,null,null,{"$f":"IF($D119=0,\"\",E$103)","v":"Comms & IT"},null,{"$f":"IF($D119=0,0,'Calc | Exit Fees'!K$89)","v":47.675166541730235},{"$f":"IF($D119=0,0,'Calc | Exit Fees'!L$89)","v":44.350432264130724},{"$f":"IF($D119=0,0,'Calc | Exit Fees'!M$89)","v":38.214790666022203},{"$f":"IF($D119=0,0,'Calc | Exit Fees'!N$89)","v":33.443076078136784},{"$f":"IF($D119=0,0,'Calc | Exit Fees'!O$89)","v":29.444277412115071}]
[null,null,null,null,{"$f":"IF($D119=0,\"\",E$104)","v":"Admin cost"},null,{"$f":"IF($D119=0,0,'Input | Exit Fees'!K$119)","v":80.839739107809521},{"$f":"IF($D119=0,0,'Input | Exit Fees'!L$119)","v":80.839739107809521},{"$f":"IF($D119=0,0,'Input | Exit Fees'!M$119)","v":80.839739107809521},{"$f":"IF($D119=0,0,'Input | Exit Fees'!N$119)","v":80.839739107809521},{"$f":"IF($D119=0,0,'Input | Exit Fees'!O$119)","v":80.839739107809521}]
[]
[null,null,null,null,{"$f":"IF($D119=0,\"\",E$106)","v":"TOTAL exit fee"},{"$f":"IF(D119=0,0,'Input | Exit Fees'!G32)","v":287.57},{"$f":"SUM(G120:G123)","v":309.98813237153047},{"$f":"SUM(H120:H123)","v":276.86476953321619},248.10502216190514,277.84637989058274,351.77637192668146]
[null,null,5,{"$f":"'Input | Exit Fees'!D33","v":0}]
[null,null,null,null,{"$f":"IF($D125=0,\"\",E$102)","v":""},null,{"$f":"IF($D125=0,0,SUMIFS('Calc | Exit Fees'!K$72:K$81,'Input | Exit Fees'!$D$29:$D$38,$D125))","v":0},{"$f":"IF($D125=0,0,SUMIFS('Calc | Exit Fees'!L$72:L$81,'Input | Exit Fees'!$D$29:$D$38,$D125))","v":0},{"$f":"IF($D125=0,0,SUMIFS('Calc | Exit Fees'!M$72:M$81,'Input | Exit Fees'!$D$29:$D$38,$D125))","v":0},{"$f":"IF($D125=0,0,SUMIFS('Calc | Exit Fees'!N$72:N$81,'Input | Exit Fees'!$D$29:$D$38,$D125))","v":0},{"$f":"IF($D125=0,0,SUMIFS('Calc | Exit Fees'!O$72:O$81,'Input | Exit Fees'!$D$29:$D$38,$D125))","v":0}]
[null,null,null,null,{"$f":"IF($D125=0,\"\",E$103)","v":""},null,{"$f":"IF($D125=0,0,'Calc | Exit Fees'!K$89)","v":0},{"$f":"IF($D125=0,0,'Calc | Exit Fees'!L$89)","v":0},{"$f":"IF($D125=0,0,'Calc | Exit Fees'!M$89)","v":0},{"$f":"IF($D125=0,0,'Calc | Exit Fees'!N$89)","v":0},{"$f":"IF($D125=0,0,'Calc | Exit Fees'!O$89)","v":0}]
[null,null,null,null,{"$f":"IF($D125=0,\"\",E$104)","v":""},null,{"$f":"IF($D125=0,0,'Input | Exit Fees'!K$119)","v":0},{"$f":"IF($D125=0,0,'Input | Exit Fees'!L$119)","v":0},{"$f":"IF($D125=0,0,'Input | Exit Fees'!M$119)","v":0},{"$f":"IF($D125=0,0,'Input | Exit Fees'!N$119)","v":0},{"$f":"IF($D125=0,0,'Input | Exit Fees'!O$119)","v":0}]
[]
[null,null,null,null,{"$f":"IF($D125=0,\"\",E$106)","v":""},{"$f":"IF(D125=0,0,'Input | Exit Fees'!G33)","v":0},{"$f":"SUM(G126:G129)","v":0},{"$f":"SUM(H126:H129)","v":0},0,0,0]
[null,null,6,{"$f":"'Input | Exit Fees'!D34","v":0}]
[null,null,null,null,{"$f":"IF($D131=0,\"\",E$102)","v":""},null,{"$f":"IF($D131=0,0,SUMIFS('Calc | Exit Fees'!K$72:K$81,'Input | Exit Fees'!$D$29:$D$38,$D131))","v":0},{"$f":"IF($D131=0,0,SUMIFS('Calc | Exit Fees'!L$72:L$81,'Input | Exit Fees'!$D$29:$D$38,$D131))","v":0},{"$f":"IF($D131=0,0,SUMIFS('Calc | Exit Fees'!M$72:M$81,'Input | Exit Fees'!$D$29:$D$38,$D131))","v":0},{"$f":"IF($D131=0,0,SUMIFS('Calc | Exit Fees'!N$72:N$81,'Input | Exit Fees'!$D$29:$D$38,$D131))","v":0},{"$f":"IF($D131=0,0,SUMIFS('Calc | Exit Fees'!O$72:O$81,'Input | Exit Fees'!$D$29:$D$38,$D131))","v":0}]
[null,null,null,null,{"$f":"IF($D131=0,\"\",E$103)","v":""},null,{"$f":"IF($D131=0,0,'Calc | Exit Fees'!K$89)","v":0},{"$f":"IF($D131=0,0,'Calc | Exit Fees'!L$89)","v":0},{"$f":"IF($D131=0,0,'Calc | Exit Fees'!M$89)","v":0},{"$f":"IF($D131=0,0,'Calc | Exit Fees'!N$89)","v":0},{"$f":"IF($D131=0,0,'Calc | Exit Fees'!O$89)","v":0}]
[null,null,null,null,{"$f":"IF($D131=0,\"\",E$104)","v":""},null,{"$f":"IF($D131=0,0,'Input | Exit Fees'!K$119)","v":0},{"$f":"IF($D131=0,0,'Input | Exit Fees'!L$119)","v":0},{"$f":"IF($D131=0,0,'Input | Exit Fees'!M$119)","v":0},{"$f":"IF($D131=0,0,'Input | Exit Fees'!N$119)","v":0},{"$f":"IF($D131=0,0,'Input | Exit Fees'!O$119)","v":0}]
[]
[null,null,null,null,{"$f":"IF($D131=0,\"\",E$106)","v":""},{"$f":"IF(D131=0,0,'Input | Exit Fees'!G34)","v":0},{"$f":"SUM(G132:G135)","v":0},{"$f":"SUM(H132:H135)","v":0},0,0,0]
[null,null,7,{"$f":"'Input | Exit Fees'!D35","v":0}]
[null,null,null,null,{"$f":"IF($D137=0,\"\",E$102)","v":""},null,{"$f":"IF($D137=0,0,SUMIFS('Calc | Exit Fees'!K$72:K$81,'Input | Exit Fees'!$D$29:$D$38,$D137))","v":0},{"$f":"IF($D137=0,0,SUMIFS('Calc | Exit Fees'!L$72:L$81,'Input | Exit Fees'!$D$29:$D$38,$D137))","v":0},{"$f":"IF($D137=0,0,SUMIFS('Calc | Exit Fees'!M$72:M$81,'Input | Exit Fees'!$D$29:$D$38,$D137))","v":0},{"$f":"IF($D137=0,0,SUMIFS('Calc | Exit Fees'!N$72:N$81,'Input | Exit Fees'!$D$29:$D$38,$D137))","v":0},{"$f":"IF($D137=0,0,SUMIFS('Calc | Exit Fees'!O$72:O$81,'Input | Exit Fees'!$D$29:$D$38,$D137))","v":0}]
[null,null,null,null,{"$f":"IF($D137=0,\"\",E$103)","v":""},null,{"$f":"IF($D137=0,0,'Calc | Exit Fees'!K$89)","v":0},{"$f":"IF($D137=0,0,'Calc | Exit Fees'!L$89)","v":0},{"$f":"IF($D137=0,0,'Calc | Exit Fees'!M$89)","v":0},{"$f":"IF($D137=0,0,'Calc | Exit Fees'!N$89)","v":0},{"$f":"IF($D137=0,0,'Calc | Exit Fees'!O$89)","v":0}]
[null,null,null,null,{"$f":"IF($D137=0,\"\",E$104)","v":""},null,{"$f":"IF($D137=0,0,'Input | Exit Fees'!K$119)","v":0},{"$f":"IF($D137=0,0,'Input | Exit Fees'!L$119)","v":0},{"$f":"IF($D137=0,0,'Input | Exit Fees'!M$119)","v":0},{"$f":"IF($D137=0,0,'Input | Exit Fees'!N$119)","v":0},{"$f":"IF($D137=0,0,'Input | Exit Fees'!O$119)","v":0}]
[]
[null,null,null,null,{"$f":"IF($D137=0,\"\",E$106)","v":""},{"$f":"IF(D137=0,0,'Input | Exit Fees'!G35)","v":0},{"$f":"SUM(G138:G141)","v":0},{"$f":"SUM(H138:H141)","v":0},0,0,0]
[null,null,8,{"$f":"'Input | Exit Fees'!D36","v":0}]
[null,null,null,null,{"$f":"IF($D143=0,\"\",E$102)","v":""},null,{"$f":"IF($D143=0,0,SUMIFS('Calc | Exit Fees'!K$72:K$81,'Input | Exit Fees'!$D$29:$D$38,$D143))","v":0},{"$f":"IF($D143=0,0,SUMIFS('Calc | Exit Fees'!L$72:L$81,'Input | Exit Fees'!$D$29:$D$38,$D143))","v":0},{"$f":"IF($D143=0,0,SUMIFS('Calc | Exit Fees'!M$72:M$81,'Input | Exit Fees'!$D$29:$D$38,$D143))","v":0},{"$f":"IF($D143=0,0,SUMIFS('Calc | Exit Fees'!N$72:N$81,'Input | Exit Fees'!$D$29:$D$38,$D143))","v":0},{"$f":"IF($D143=0,0,SUMIFS('Calc | Exit Fees'!O$72:O$81,'Input | Exit Fees'!$D$29:$D$38,$D143))","v":0}]
[null,null,null,null,{"$f":"IF($D143=0,\"\",E$103)","v":""},null,{"$f":"IF($D143=0,0,'Calc | Exit Fees'!K$89)","v":0},{"$f":"IF($D143=0,0,'Calc | Exit Fees'!L$89)","v":0},{"$f":"IF($D143=0,0,'Calc | Exit Fees'!M$89)","v":0},{"$f":"IF($D143=0,0,'Calc | Exit Fees'!N$89)","v":0},{"$f":"IF($D143=0,0,'Calc | Exit Fees'!O$89)","v":0}]
[null,null,null,null,{"$f":"IF($D143=0,\"\",E$104)","v":""},null,{"$f":"IF($D143=0,0,'Input | Exit Fees'!K$119)","v":0},{"$f":"IF($D143=0,0,'Input | Exit Fees'!L$119)","v":0},{"$f":"IF($D143=0,0,'Input | Exit Fees'!M$119)","v":0},{"$f":"IF($D143=0,0,'Input | Exit Fees'!N$119)","v":0},{"$f":"IF($D143=0,0,'Input | Exit Fees'!O$119)","v":0}]
[]
[null,null,null,null,{"$f":"IF($D143=0,\"\",E$106)","v":""},{"$f":"IF(D143=0,0,'Input | Exit Fees'!G36)","v":0},{"$f":"SUM(G144:G147)","v":0},{"$f":"SUM(H144:H147)","v":0},0,0,0]
[null,null,9,{"$f":"'Input | Exit Fees'!D37","v":0}]
[null,null,null,null,{"$f":"IF($D149=0,\"\",E$102)","v":""},null,{"$f":"IF($D149=0,0,SUMIFS('Calc | Exit Fees'!K$72:K$81,'Input | Exit Fees'!$D$29:$D$38,$D149))","v":0},{"$f":"IF($D149=0,0,SUMIFS('Calc | Exit Fees'!L$72:L$81,'Input | Exit Fees'!$D$29:$D$38,$D149))","v":0},{"$f":"IF($D149=0,0,SUMIFS('Calc | Exit Fees'!M$72:M$81,'Input | Exit Fees'!$D$29:$D$38,$D149))","v":0},{"$f":"IF($D149=0,0,SUMIFS('Calc | Exit Fees'!N$72:N$81,'Input | Exit Fees'!$D$29:$D$38,$D149))","v":0},{"$f":"IF($D149=0,0,SUMIFS('Calc | Exit Fees'!O$72:O$81,'Input | Exit Fees'!$D$29:$D$38,$D149))","v":0}]
[null,null,null,null,{"$f":"IF($D149=0,\"\",E$103)","v":""},null,{"$f":"IF($D149=0,0,'Calc | Exit Fees'!K$89)","v":0},{"$f":"IF($D149=0,0,'Calc | Exit Fees'!L$89)","v":0},{"$f":"IF($D149=0,0,'Calc | Exit Fees'!M$89)","v":0},{"$f":"IF($D149=0,0,'Calc | Exit Fees'!N$89)","v":0},{"$f":"IF($D149=0,0,'Calc | Exit Fees'!O$89)","v":0}]
[null,null,null,null,{"$f":"IF($D149=0,\"\",E$104)","v":""},null,{"$f":"IF($D149=0,0,'Input | Exit Fees'!K$119)","v":0},{"$f":"IF($D149=0,0,'Input | Exit Fees'!L$119)","v":0},{"$f":"IF($D149=0,0,'Input | Exit Fees'!M$119)","v":0},{"$f":"IF($D149=0,0,'Input | Exit Fees'!N$119)","v":0},{"$f":"IF($D149=0,0,'Input | Exit Fees'!O$119)","v":0}]
[]
[null,null,null,null,{"$f":"IF($D149=0,\"\",E$106)","v":""},{"$f":"IF(D149=0,0,'Input | Exit Fees'!G37)","v":0},{"$f":"SUM(G150:G153)","v":0},{"$f":"SUM(H150:H153)","v":0},0,0,0]
[null,null,10,{"$f":"'Input | Exit Fees'!D38","v":0}]
[null,null,null,null,{"$f":"IF($D155=0,\"\",E$102)","v":""},null,{"$f":"IF($D155=0,0,SUMIFS('Calc | Exit Fees'!K$72:K$81,'Input | Exit Fees'!$D$29:$D$38,$D155))","v":0},{"$f":"IF($D155=0,0,SUMIFS('Calc | Exit Fees'!L$72:L$81,'Input | Exit Fees'!$D$29:$D$38,$D155))","v":0},{"$f":"IF($D155=0,0,SUMIFS('Calc | Exit Fees'!M$72:M$81,'Input | Exit Fees'!$D$29:$D$38,$D155))","v":0},{"$f":"IF($D155=0,0,SUMIFS('Calc | Exit Fees'!N$72:N$81,'Input | Exit Fees'!$D$29:$D$38,$D155))","v":0},{"$f":"IF($D155=0,0,SUMIFS('Calc | Exit Fees'!O$72:O$81,'Input | Exit Fees'!$D$29:$D$38,$D155))","v":0}]
[null,null,null,null,{"$f":"IF($D155=0,\"\",E$103)","v":""},null,{"$f":"IF($D155=0,0,'Calc | Exit Fees'!K$89)","v":0},{"$f":"IF($D155=0,0,'Calc | Exit Fees'!L$89)","v":0},{"$f":"IF($D155=0,0,'Calc | Exit Fees'!M$89)","v":0},{"$f":"IF($D155=0,0,'Calc | Exit Fees'!N$89)","v":0},{"$f":"IF($D155=0,0,'Calc | Exit Fees'!O$89)","v":0}]
[null,null,null,null,{"$f":"IF($D155=0,\"\",E$104)","v":""},null,{"$f":"IF($D155=0,0,'Input | Exit Fees'!K$119)","v":0},{"$f":"IF($D155=0,0,'Input | Exit Fees'!L$119)","v":0},{"$f":"IF($D155=0,0,'Input | Exit Fees'!M$119)","v":0},{"$f":"IF($D155=0,0,'Input | Exit Fees'!N$119)","v":0},{"$f":"IF($D155=0,0,'Input | Exit Fees'!O$119)","v":0}]
[]
[null,null,null,null,{"$f":"IF($D155=0,\"\",E$106)","v":""},{"$f":"IF(D155=0,0,'Input | Exit Fees'!G38)","v":0},{"$f":"SUM(G156:G159)","v":0},{"$f":"SUM(H156:H159)","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":"Preliminary Standardised Metering Pricing Model  v1"},null,null,null,null,null,null,null,null,null,null,"DNSP:","D"]
[null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"Output | Exit Fee price caps"},null,null,null,null,null,"Key:","Input","External Link","Internal Link"]
[]
[]
[null,null,"Applicable Exit Fees Price Caps"]
[]
[null,null,null,null,null,null,null,"Base Year","Regulatory Period"]
[null,null,null,"Exit Fee Name",null,"Units","Basis","2025-26",{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(I8,4)+1&\"-\"&RIGHT(I8,2)+1","v":"2027-28"},{"$f":"LEFT(J8,4)+1&\"-\"&RIGHT(J8,2)+1","v":"2028-29"},{"$f":"LEFT(K8,4)+1&\"-\"&RIGHT(K8,2)+1","v":"2029-30"},{"$f":"LEFT(L8,4)+1&\"-\"&RIGHT(L8,2)+1","v":"2030-31"}]
[null,null,null,{"$f":"D25","v":"Single phase single element"},null,"$dollars","nominal",{"$f":"ROUND(H25,2)","v":287.57},{"$f":"IF(I25=0,0,ROUND(H9*(1-I45)*(1+I$41),2))","v":210.52},{"$f":"IF(J25=0,0,ROUND(I9*(1-J45)*(1+J$41),2))","v":193.73},177.37,188.19,219.41]
[null,null,null,{"$f":"D26","v":"Single phase two element with contactor"},null,"$dollars","nominal",287.57,213.96,196.6,179.81,191.29,223.98]
[null,null,null,"Multiphase",null,"$dollars","nominal",{"$f":"ROUND(H27,2)","v":287.57},{"$f":"IF(I27=0,0,ROUND(H11*(1-I47)*(1+I$41),2))","v":227.95},{"$f":"IF(J27=0,0,ROUND(I11*(1-J47)*(1+J$41),2))","v":208.3},189.77,203.91,242.61]
[null,null,null,"Multiphase CT connected",null,"$dollars","nominal",287.57,309.99,276.87,248.11,277.85000000000002,351.78]
[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":"H8","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(I24,4)+1&\"-\"&RIGHT(I24,2)+1","v":"2027-28"},{"$f":"LEFT(J24,4)+1&\"-\"&RIGHT(J24,2)+1","v":"2028-29"},{"$f":"LEFT(K24,4)+1&\"-\"&RIGHT(K24,2)+1","v":"2029-30"},{"$f":"LEFT(L24,4)+1&\"-\"&RIGHT(L24,2)+1","v":"2030-31"}]
[null,null,null,{"$f":"'Input | Exit Fees'!$D29","v":"Single phase single element"},null,"$dollars","nominal",{"$f":"INDEX(Table3[2020-21],MATCH('Output | Exit Fee price caps'!$D25,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":287.57},{"$f":"INDEX(Table3[2021-22],MATCH('Output | Exit Fee price caps'!$D25,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":210.52367408854073},{"$f":"INDEX(Table3[2022-23],MATCH('Output | Exit Fee price caps'!$D25,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":193.73277252236821},{"$f":"INDEX(Table3[2023-24],MATCH('Output | Exit Fee price caps'!$D25,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":177.37317070154108},{"$f":"INDEX(Table3[2024-25],MATCH('Output | Exit Fee price caps'!$D25,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":188.19810696322438},{"$f":"INDEX(Table3[2025-26],MATCH('Output | Exit Fee price caps'!$D25,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":219.4157656604261}]
[null,null,null,{"$f":"'Input | Exit Fees'!$D30","v":"Single phase two element with contactor"},null,"$dollars","nominal",{"$f":"INDEX(Table3[2020-21],MATCH('Output | Exit Fee price caps'!$D26,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":287.57},{"$f":"INDEX(Table3[2021-22],MATCH('Output | Exit Fee price caps'!$D26,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":213.95950344090181},{"$f":"INDEX(Table3[2022-23],MATCH('Output | Exit Fee price caps'!$D26,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":196.6044249737154},{"$f":"INDEX(Table3[2023-24],MATCH('Output | Exit Fee price caps'!$D26,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":179.81648136335491},{"$f":"INDEX(Table3[2024-25],MATCH('Output | Exit Fee price caps'!$D26,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":191.29485300527233},{"$f":"INDEX(Table3[2025-26],MATCH('Output | Exit Fee price caps'!$D26,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":223.98793610157031}]
[null,null,null,{"$f":"'Input | Exit Fees'!$D31","v":"Multiphase"},null,"$dollars","nominal",{"$f":"INDEX(Table3[2020-21],MATCH('Output | Exit Fee price caps'!$D27,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":287.57},{"$f":"INDEX(Table3[2021-22],MATCH('Output | Exit Fee price caps'!$D27,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":227.95387639585419},{"$f":"INDEX(Table3[2022-23],MATCH('Output | Exit Fee price caps'!$D27,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":208.30086600142218},{"$f":"INDEX(Table3[2023-24],MATCH('Output | Exit Fee price caps'!$D27,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":189.76825636135848},{"$f":"INDEX(Table3[2024-25],MATCH('Output | Exit Fee price caps'!$D27,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":203.90811595135295},{"$f":"INDEX(Table3[2025-26],MATCH('Output | Exit Fee price caps'!$D27,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":242.61070568790367}]
[null,null,null,{"$f":"'Input | Exit Fees'!$D32","v":"Multiphase CT connected"},null,"$dollars","nominal",{"$f":"INDEX(Table3[2020-21],MATCH('Output | Exit Fee price caps'!$D28,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":287.57},{"$f":"INDEX(Table3[2021-22],MATCH('Output | Exit Fee price caps'!$D28,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":309.98813237153047},{"$f":"INDEX(Table3[2022-23],MATCH('Output | Exit Fee price caps'!$D28,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":276.86476953321619},{"$f":"INDEX(Table3[2023-24],MATCH('Output | Exit Fee price caps'!$D28,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":248.10502216190514},{"$f":"INDEX(Table3[2024-25],MATCH('Output | Exit Fee price caps'!$D28,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":277.84637989058274},{"$f":"INDEX(Table3[2025-26],MATCH('Output | Exit Fee price caps'!$D28,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":351.77637192668146}]
[null,null,null,{"$f":"'Input | Exit Fees'!$D33","v":0},null,"$dollars","nominal",{"$f":"INDEX(Table3[2020-21],MATCH('Output | Exit Fee price caps'!$D29,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2021-22],MATCH('Output | Exit Fee price caps'!$D29,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2022-23],MATCH('Output | Exit Fee price caps'!$D29,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2023-24],MATCH('Output | Exit Fee price caps'!$D29,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2024-25],MATCH('Output | Exit Fee price caps'!$D29,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2025-26],MATCH('Output | Exit Fee price caps'!$D29,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0}]
[null,null,null,{"$f":"'Input | Exit Fees'!$D34","v":0},null,"$dollars","nominal",{"$f":"INDEX(Table3[2020-21],MATCH('Output | Exit Fee price caps'!$D30,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2021-22],MATCH('Output | Exit Fee price caps'!$D30,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2022-23],MATCH('Output | Exit Fee price caps'!$D30,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2023-24],MATCH('Output | Exit Fee price caps'!$D30,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2024-25],MATCH('Output | Exit Fee price caps'!$D30,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2025-26],MATCH('Output | Exit Fee price caps'!$D30,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0}]
[null,null,null,{"$f":"'Input | Exit Fees'!$D35","v":0},null,"$dollars","nominal",{"$f":"INDEX(Table3[2020-21],MATCH('Output | Exit Fee price caps'!$D31,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2021-22],MATCH('Output | Exit Fee price caps'!$D31,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2022-23],MATCH('Output | Exit Fee price caps'!$D31,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2023-24],MATCH('Output | Exit Fee price caps'!$D31,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2024-25],MATCH('Output | Exit Fee price caps'!$D31,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2025-26],MATCH('Output | Exit Fee price caps'!$D31,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0}]
[null,null,null,{"$f":"'Input | Exit Fees'!$D36","v":0},null,"$dollars","nominal",{"$f":"INDEX(Table3[2020-21],MATCH('Output | Exit Fee price caps'!$D32,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2021-22],MATCH('Output | Exit Fee price caps'!$D32,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2022-23],MATCH('Output | Exit Fee price caps'!$D32,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2023-24],MATCH('Output | Exit Fee price caps'!$D32,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2024-25],MATCH('Output | Exit Fee price caps'!$D32,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2025-26],MATCH('Output | Exit Fee price caps'!$D32,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0}]
[null,null,null,{"$f":"'Input | Exit Fees'!$D37","v":0},null,"$dollars","nominal",{"$f":"INDEX(Table3[2020-21],MATCH('Output | Exit Fee price caps'!$D33,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2021-22],MATCH('Output | Exit Fee price caps'!$D33,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2022-23],MATCH('Output | Exit Fee price caps'!$D33,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2023-24],MATCH('Output | Exit Fee price caps'!$D33,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2024-25],MATCH('Output | Exit Fee price caps'!$D33,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2025-26],MATCH('Output | Exit Fee price caps'!$D33,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0}]
[null,null,null,{"$f":"'Input | Exit Fees'!$D38","v":0},null,"$dollars","nominal",{"$f":"INDEX(Table3[2020-21],MATCH('Output | Exit Fee price caps'!$D34,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2021-22],MATCH('Output | Exit Fee price caps'!$D34,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2022-23],MATCH('Output | Exit Fee price caps'!$D34,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2023-24],MATCH('Output | Exit Fee price caps'!$D34,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2024-25],MATCH('Output | Exit Fee price caps'!$D34,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0},{"$f":"INDEX(Table3[2025-26],MATCH('Output | Exit Fee price caps'!$D34,Table3[[Exit Fee Name]:[Exit Fee Name]],0)+5)","v":0}]
[]
[]
[]
[]
[null,null,"Xfactors"]
[]
[null,null,null,"CPI",null,"%",null,null,{"$f":"'Inputs | General'!H26","v":2.5000000000000001E-2},{"$f":"'Inputs | General'!I26","v":2.5000000000000001E-2},{"$f":"'Inputs | General'!J26","v":2.5000000000000001E-2},{"$f":"'Inputs | General'!K26","v":2.5000000000000001E-2},{"$f":"'Inputs | General'!L26","v":2.5000000000000001E-2}]
[]
[null,null,null,null,null,null,null,null,{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(I43,4)+1&\"-\"&RIGHT(I43,2)+1","v":"2027-28"},{"$f":"LEFT(J43,4)+1&\"-\"&RIGHT(J43,2)+1","v":"2028-29"},{"$f":"LEFT(K43,4)+1&\"-\"&RIGHT(K43,2)+1","v":"2029-30"},{"$f":"LEFT(L43,4)+1&\"-\"&RIGHT(L43,2)+1","v":"2030-31"}]
[null,null,null,"Exit Fee Name",null,"Units",null,null,"P_0","X_02","X_03","X_04","X_05"]
[null,null,null,{"$f":"'Input | Exit Fees'!$D29","v":"Single phase single element"},null,"%",null,null,{"$f":"IFERROR(-1*(((I25/H25)/(1+I$41)-1)),\"\")","v":0.28577754866542526},0.10220271536226233,0.10677479316824556,-3.5150403559983001E-2,-0.13744056767668766]
[null,null,null,{"$f":"'Input | Exit Fees'!$D30","v":"Single phase two element with contactor"},null,"%",null,null,0.27412115670364268,0.10352570457667132,0.10769702386567259,-3.7886646808928059E-2,-0.14234550629977649]
[null,null,null,{"$f":"'Input | Exit Fees'!$D31","v":"Multiphase"},null,"%",null,null,0.22664385801003961,0.10850229753647556,0.11119062605097219,-4.8303605060264987E-2,-0.16078445577566725]
[null,null,null,{"$f":"'Input | Exit Fees'!$D32","v":"Multiphase CT connected"},null,"%",null,null,-5.1665494370509268E-2,0.12863770554747933,0.12573318531624711,-9.2560064103622164E-2,-0.23520220256757374]
[null,null,null,{"$f":"'Input | Exit Fees'!$D33","v":0},null,"%",null,null,"","","","",""]
[null,null,null,{"$f":"'Input | Exit Fees'!$D34","v":0},null,"%",null,null,"","","","",""]
[null,null,null,{"$f":"'Input | Exit Fees'!$D35","v":0},null,"%",null,null,"","","","",""]
[null,null,null,{"$f":"'Input | Exit Fees'!$D36","v":0},null,"%",null,null,"","","","",""]
[null,null,null,{"$f":"'Input | Exit Fees'!$D37","v":0},null,"%",null,null,"","","","",""]
[null,null,null,{"$f":"'Input | Exit Fees'!$D38","v":0},null,"%",null,null,"","","","",""]
[]
[]
[]
[null,null,"Cost Metric"]
[]
[null,null,null,null,null,null,null,"Base Year","Regulatory Period"]
[null,null,null,"Exit Fee Per Meter",null,"Units","Basis",{"$f":"H8","v":"2025-26"},{"$f":"FPFirstYear","v":"2026-27"},{"$f":"LEFT(I61,4)+1&\"-\"&RIGHT(I61,2)+1","v":"2027-28"},{"$f":"LEFT(J61,4)+1&\"-\"&RIGHT(J61,2)+1","v":"2028-29"},{"$f":"LEFT(K61,4)+1&\"-\"&RIGHT(K61,2)+1","v":"2029-30"},{"$f":"LEFT(L61,4)+1&\"-\"&RIGHT(L61,2)+1","v":"2030-31"}]
[null,null,null,"Volume Weighted Average Exit Fee - Per Meter",null,"$dollars","nominal",{"$f":"SUMPRODUCT(H$25:H$34,'Calc | Exit Fees'!J$11:J$20)/'Calc | Exit Fees'!J$21","v":287.57},{"$f":"SUMPRODUCT(I$25:I$34,'Calc | Exit Fees'!K$11:K$20)/'Calc | Exit Fees'!K$21","v":214.9835975555838},{"$f":"SUMPRODUCT(J$25:J$34,'Calc | Exit Fees'!L$11:L$20)/'Calc | Exit Fees'!L$21","v":197.61088661776577},{"$f":"SUMPRODUCT(K$25:K$34,'Calc | Exit Fees'!M$11:M$20)/'Calc | Exit Fees'!M$21","v":180.8200960710854},{"$f":"SUMPRODUCT(L$25:L$34,'Calc | Exit Fees'!N$11:N$20)/'Calc | Exit Fees'!N$21","v":192.77652326447918},{"$f":"SUMPRODUCT(M$25:M$34,'Calc | Exit Fees'!O$11:O$20)/'Calc | Exit Fees'!O$21","v":226.52219192210143}]

{"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":"Preliminary Standardised Metering Pricing Model  v1"}]
[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"]

{"sheet":"Reg Depreciation Calc","index":12,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,{"$f":"[1]Assets!F4","v":"2025-26"},{"$f":"[1]Assets!G4","v":"2026-27"},{"$f":"[1]Assets!H4","v":"2027-28"},{"$f":"[1]Assets!I4","v":"2028-29"},{"$f":"[1]Assets!J4","v":"2029-30"},{"$f":"[1]Assets!K4","v":"2030-31"}]
[]
[null,null,"CPI"]
[]
[null,null,null,"Infation Assumption",null,{"$f":"[1]Assets!G6","v":2.4999999999999911E-2},{"$f":"[1]Assets!H6","v":2.4999999999999911E-2},{"$f":"[1]Assets!I6","v":2.4999999999999911E-2},{"$f":"[1]Assets!J6","v":2.4999999999999911E-2},{"$f":"[1]Assets!K6","v":2.4999999999999911E-2}]
[null,null,null,"Cummulative Inflation Index",{"$f":"[1]Assets!F7","v":1},{"$f":"[1]Assets!G7","v":1.0249999999999999},{"$f":"[1]Assets!H7","v":1.0506249999999999},{"$f":"[1]Assets!I7","v":1.0768906249999999},{"$f":"[1]Assets!J7","v":1.1038128906249998},{"$f":"[1]Assets!K7","v":1.1314082128906247}]
[]
[null,null,"Meters"]
[]
[null,null,null,"Opening RAB",null,{"$f":"E14","v":75.224861419544013},{"$f":"F14","v":51.781550839012461},55.565544409382859,79.814405760783174,119.46556552280109]
[null,null,null,"add Capex",null,{"$f":"[1]Assets!G11","v":11.490656295495082},{"$f":"[1]Assets!H11","v":12.159864382677753},{"$f":"[1]Assets!I11","v":30.559021279002103},{"$f":"[1]Assets!J11","v":47.998587774886502},{"$f":"[1]Assets!K11","v":51.039077858180249}]
[null,null,null,"less Straight Line Depreciation",null,{"$f":"-[1]Assets!G128","v":-34.933966876026638},{"$f":"-[1]Assets!H128","v":-8.3758708123073564},{"$f":"-[1]Assets!I128","v":-6.3101599276017826},{"$f":"-[1]Assets!J128","v":-8.3474280128685905},{"$f":"-[1]Assets!K128","v":-11.54733386452769}]
[null,null,null,"Closing RAB",{"$f":"'Input | Exit Fees'!G9","v":75.224861419544013},{"$f":"SUM(F11:F13)","v":51.781550839012461},{"$f":"SUM(G11:G13)","v":55.565544409382859},79.814405760783174,119.46556552280109,158.95730951645365]
[null,null,null,"Inflation on Opening RAB",null,{"$f":"F11*F$6","v":1.8806215354885936},{"$f":"G11*G$6","v":1.2945387709753069},1.3891386102345666,1.9953601440195723,2.9866391380700166]
[null,null,null,"Nominal Straight Line Depreciation",null,{"$f":"-F13*F$7","v":35.807316047927301},{"$f":"-G13*G$7","v":8.799899272180415},6.7953520682850375,9.2139986441685764,13.064748371316664]
[null,null,null,"Regulatory Depreciation",null,{"$f":"F16-F15","v":33.926694512438708},{"$f":"G16-G15","v":7.5053605012051081},5.4062134580504706,7.2186385001490043,10.078109233246648]
[]
[]
[null,null,"Comms & IT"]
[]
[null,null,null,"Opening RAB",null,{"$f":"E25","v":41.475795657371997},{"$f":"F25","v":36.190909648058948},30.329264573045513,27.53733556353329,23.196924676740039]
[null,null,null,"add Capex",null,{"$f":"[1]Assets!G12+[1]Assets!G13","v":5.9214148973679972},{"$f":"[1]Assets!H12+[1]Assets!H13+[1]Assets!H60","v":5.4306806191625743},{"$f":"[1]Assets!I12+[1]Assets!I13+[1]Assets!I60","v":5.8508969912433102},{"$f":"[1]Assets!J12+[1]Assets!J13+[1]Assets!J60","v":4.1075035878264998},{"$f":"[1]Assets!K12+[1]Assets!K13+[1]Assets!K60","v":1.1843820640938496}]
[null,null,null,"less Straight Line Depreciation",null,{"$f":"-[1]Assets!G141-[1]Assets!G154","v":-11.206300906681047},{"$f":"-[1]Assets!H141-[1]Assets!H154","v":-11.292325694176006},{"$f":"-[1]Assets!I141-[1]Assets!I154","v":-8.6428260007555355},{"$f":"-[1]Assets!J141-[1]Assets!J154","v":-8.4479144746197523},{"$f":"-[1]Assets!K141-[1]Assets!K154","v":-6.394068964338703}]
[null,null,null,"Closing RAB",{"$f":"'Input | Exit Fees'!G16","v":41.475795657371997},{"$f":"SUM(F22:F24)","v":36.190909648058948},{"$f":"SUM(G22:G24)","v":30.329264573045513},{"$f":"SUM(H22:H24)","v":27.53733556353329},{"$f":"SUM(I22:I24)","v":23.196924676740039},{"$f":"SUM(J22:J24)","v":17.987237776495185}]
[null,null,null,"Inflation on Opening RAB",null,{"$f":"F22*F$6","v":1.0368948914342961},{"$f":"G22*G$6","v":0.90477274120147044},0.75823161432613517,0.68843338908832985,0.57992311691849896]
[null,null,null,"Nominal Straight Line Depreciation",null,{"$f":"-F24*F$7","v":11.486458429348072},{"$f":"-G24*G$7","v":11.863999682443666},9.3073782937198786,9.3249168959828044,7.2343021400418595]
[null,null,null,"Regulatory Depreciation",null,{"$f":"F27-F26","v":10.449563537913777},{"$f":"G27-G26","v":10.959226941242195},{"$f":"H27-H26","v":8.5491466793937434},{"$f":"I27-I26","v":8.636483506894475},{"$f":"J27-J26","v":6.6543790231233606}]