{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Home","Input|Installations","Input|RP_Vol","Input|AER_DD_Vol","Input|IP_Vol","Output|Charts","Checklist","Lookup"],"not_rendered":{"charts":10,"images":2,"macros":1,"external_links":3,"defined_names":132,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Home","index":0,"n_rows":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":false,"merged":[[24,9,24,11],[1,3,1,7],[3,3,3,7],[47,2,47,3],[5,1,5,3],[44,2,44,3],[46,2,46,3],[45,2,45,3],[17,4,17,7],[19,4,19,7],[9,4,9,7],[11,4,11,7],[13,4,13,7],[15,4,15,7],[21,4,21,7]]}
[]
[null,null,null,"Inspection and Replacement Obligation Volume Model",null,null,null,null,null,"Overall check:",{"$f":"IF(COUNTA(Check_Status_List)=COUNTIF(Check_Status_List,\"Ok\"),\"Ok\",\"Check\")","v":"Ok"}]
[]
[null,null,null,{"$f":"RIGHT(CELL(\"filename\",D3),LEN(CELL(\"filename\",D3))-FIND(\"]\",CELL(\"filename\",D3)))","v":"Home"},{"$f":"RIGHT(CELL(\"filename\",E3),LEN(CELL(\"filename\",E3))-FIND(\"]\",CELL(\"filename\",E3)))","v":"Home"},{"$f":"RIGHT(CELL(\"filename\",F3),LEN(CELL(\"filename\",F3))-FIND(\"]\",CELL(\"filename\",F3)))","v":"Home"},{"$f":"RIGHT(CELL(\"filename\",G3),LEN(CELL(\"filename\",G3))-FIND(\"]\",CELL(\"filename\",G3)))","v":"Home"},{"$f":"RIGHT(CELL(\"filename\",H3),LEN(CELL(\"filename\",H3))-FIND(\"]\",CELL(\"filename\",H3)))","v":"Home"}]
[]
[null,null,null,null," Copyright Jemena Limited. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Project Details"]
[]
[null,null,"Project Name:",null,"ACS Metering - Revised Proposal"]
[]
[null,null,"Project No:",null,1]
[]
[null,null,"Start Year:",null,2024]
[]
[null,null,"Asset Type:",null,"JEN",null,null,null,"Description of each asset type --->",null,null,"Click Link"]
[]
[null,null,"Number of Options:",null,3,null,null,null,"<--- select from drop-down list"]
[]
[null,null,"Cashflow Type:",null,"Annual"]
[]
[null,null,"Dollar Unit:",null,"Millions",null,null,null,"<--- select from drop-down list"]
[]
[]
[null,null,null,null,null,null,null,null,null,"<--- Click button after completing the above Project Details section"]
[]
[]
[null,"Table Of Contents & Checks "]
[]
[null,null,"Worksheet",null,"Ref","Check","Description"]
[]
[null,null,{"$f":"D4","v":"Home"},null,1,"Ok","Outlines project details, model checks and model structure"]
[null,null,{"$f":"'Input|Installations'!$D$2","v":"Input|Installations"},null,{"$f":"E32+1","v":2},{"$f":"'Input|Installations'!$N$1","v":"Ok"},"Input for meter installations with reallocation of meters installed from calendar years into financial years"]
[null,null,{"$f":"'Input|RP_Vol'!$D$2","v":"Input|RP_Vol"},null,3,{"$f":"'Input|RP_Vol'!$J$1","v":"Ok"},"Outlines the replacement and inspection profiles by meter installation year under the Revised Proposal Scenario"]
[null,null,{"$f":"'Input|AER_DD_Vol'!$D$2","v":"Input|AER_DD_Vol"},null,4,{"$f":"'Input|AER_DD_Vol'!$J$1","v":"Ok"},"Outlines the replacement and inspection profiles by meter installation year under the AER Draft Decision Scenario"]
[null,null,{"$f":"'Input|IP_Vol'!$D$2","v":"Input|IP_Vol"},null,5,{"$f":"'Input|IP_Vol'!$J$1","v":"Ok"},"Outlines the replacement and inspection profiles by meter installation year under the Initial Proposal Scenario"]
[null,null,{"$f":"'Output|Charts'!$D$2","v":"Output|Charts"},null,6,{"$f":"'Output|Charts'!$N$1","v":"Ok"},"Presents charts associated with the replacement and installation profiles by scenario"]
[null,null,{"$f":"Checklist!D2","v":"Checklist"},null,7,{"$f":"Checklist!$I$1","v":"Ok"},"Lists all checks in the model for users to navigate to the error cells"]
[null,null,{"$f":"Lookup!D4","v":"Lookup"},null,8,{"$f":"Lookup!$K$4","v":"Ok"},"Provides all lookup tables (name ranges) list"]
[]
[null,"Model Key Legend"]
[]
[null,null,"Model key",null,null,"Description"]
[]
[null,null,"Input",null,"--------->","Input assumption (hardcode)"]
[null,null,"Internal link",null,"--------->","Internal link (different sheet within the model)"]
[null,null,"Drop-down",null,"--------->","Choose from a drop-down list"]
[null,null,"Calculation",null,"--------->","Calculation (general formula driven)"]
[]
[null,"End"]

{"sheet":"Input|Installations","index":1,"n_rows":42,"n_cols":23,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[null,null,null,{"$f":"Model_Name","v":"Inspection and Replacement Obligation Volume Model"},null,null,null,null,null,null,null,null,"Section Check:",{"$f":"IF(COUNTA($A$7:$A$42)=COUNTIF($A$7:$A$42,0),\"Ok\",\"Check\")","v":"Ok"},null,null,null,null,"Legend:","Input","Internal","Select","Calculation"]
[null,null,null,{"$f":"RIGHT(CELL(\"filename\",D1),LEN(CELL(\"filename\",D1))-FIND(\"]\",CELL(\"filename\",D1)))","v":"Input|Installations"}]
[]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Input | Meter Population"]
[]
[null,null,"Input | Meter Installation by Year"]
[]
[null,null,null,"Volumes","Unit","Installation (Financial Year)",null,"Installation Volume (#, CY)","Installation Volume (#, CY (1 Jan to 30 June)","Installation Volume (#, CY (1 July to 31 Dec)",null,"Installation Volume (#, FY)",null,"Applied Installation Volume (#, FY)","Comment"]
[]
[null,null,null,{"$f":"F13&\" Installations\"","v":"2010 Installations"},"# Meters",2010,null,35689,{"$f":"H13*$H$32","v":17844.5},{"$f":"H13*$H$33","v":17844.5},null,null,null,{"$f":"H13*(2/3)+4592","v":28384.666666666664},"Note: 2/3 of 2010 CY installations plus the balancing item to reconcile with total meters installed"]
[null,null,null,"2011 Installations","# Meters",2011,null,50044,{"$f":"H14*$H$32","v":25022},{"$f":"H14*$H$33","v":25022},null,null,null,{"$f":"I14+(1/3)*H13","v":36918.333333333328},"Note: 1/3 of 2010 CY installations plus H1 CY2011"]
[null,null,null,"2012 Installations","# Meters",2012,null,63277,31638.5,31638.5,null,null,null,{"$f":"I15+J14","v":56660.5},"Note: CY installation value apportioned into FY based on the assumption in H32"]
[null,null,null,"2013 Installations","# Meters",2013,null,115956,57978,57978,null,null,null,89616.5]
[null,null,null,"2014 Installations","# Meters",2014,null,34708,17354,17354,null,null,null,75332]
[null,null,null,"2015 Installations","# Meters",2015,null,9731,4865.5,4865.5,null,null,null,22219.5]
[null,null,null,"2016 Installations","# Meters",2016,null,9116,4558,4558,null,null,null,9423.5]
[null,null,null,"2017 Installations","# Meters",2017,null,9398,4699,4699,null,null,null,9257]
[null,null,null,"2018 Installations","# Meters",2018,null,9100,4550,4550,null,null,null,9249]
[null,null,null,"2019 Installations","# Meters",2019,null,9503,4751.5,4751.5,null,null,null,{"$f":"I22+J21","v":9301.5}]
[null,null,null,"2020 Installations","# Meters",2020,null,9184,4592,4592,null,null,null,{"$f":"I23+J22","v":9343.5}]
[null,null,null,"2021 Installations","# Meters",2021,null,null,null,null,null,8430,null,{"$f":"L24","v":8430},"Note: 100% of the FY Installation value"]
[null,null,null,"2022 Installations","# Meters",2022,null,null,null,null,null,9186,null,{"$f":"L25","v":9186}]
[null,null,null,"2023 Installations","# Meters",2023,null,null,null,null,null,9538,null,{"$f":"L26","v":9538}]
[null,null,null,"2024 Installations","# Meters",2024,null,null,null,null,null,8283,null,{"$f":"L27","v":8283}]
[null,null,null,"2025 Installations","# Meters",2025,null,null,null,null,null,8983,null,{"$f":"L28","v":8983}]
[]
[{"$f":"IF(ROUND(SUM(H30:L30)-N30,3)=0,0,1)","v":0},null,null,"Total",null,null,null,{"$f":"SUM(H13:H28)","v":355706},null,null,null,{"$f":"SUM(L13:L28)","v":44420},null,{"$f":"SUM(N13:N28)","v":400126}]
[]
[null,null,null,"% of CY installations: 1 January to 30 June",null,null,null,0.5]
[null,null,null,"% of CY installations: 1 July to 31 December",null,null,null,{"$f":"1-H32","v":0.5}]
[]
[null,null,"Input | Obligations"]
[]
[null,null,null,"Item",null,null,null,"Unit","Basis","Input"]
[]
[null,null,null,"Inspection obligation starts after x years",null,null,null,"Years","n/a",15,null,"Note: '15 year inspection obligation' | Under our current MAMS, these physical inspections by a qualified technician fall due upon the 15 year anniversary of a meter’s service life."]
[null,null,null,"Inspection avoided if replacements done within x years",null,null,null,"Years","n/a",5,null,"Note: 'Substituted 20 year replacement obligation\" | This inspection can be avoided if within the next 5 years the meter is planned to be replaced, creating a compliant replacement window of up to 20 years of a meter’s service life."]
[]
[null,"End"]

{"sheet":"Input|RP_Vol","index":2,"n_rows":178,"n_cols":20,"rows_kept":178,"cut":false,"hidden":false,"merged":[]}
[null,null,null,{"$f":"Model_Name","v":"Inspection and Replacement Obligation Volume Model"},null,null,null,"Section Check:",null,{"$f":"IF(COUNTA($A$8:$A$178)=COUNTIF($A$8:$A$178,0),\"Ok\",\"Check\")","v":"Ok"},null,"Overall Check:",{"$f":"Overall_Check","v":"Ok"},null,"Legend:","Input","Internal","Select","Calculation"]
[null,null,null,{"$f":"RIGHT(CELL(\"filename\",D1),LEN(CELL(\"filename\",D1))-FIND(\"]\",CELL(\"filename\",D1)))","v":"Input|RP_Vol"}]
[null,null,null,null,null,null,null,"Year",null,2026,{"$f":"IF(CF_Type=Annually,J3+1,IF(K4=1,J3+1,J3))","v":2027},2028,2029,2030,2031,2032,2033,2034,2035,2036]
[null,null,null,null,"Unit","Basis",null,"Month",null,{"$f":"IF(CF_Type=Annually,NA,Start_Month)","v":"n/a"},{"$f":"IF(J4=NA,NA,IF(J4+1=Months_in_year,Months_in_year,MOD(J4+1,Months_in_year)))","v":"n/a"},"n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Input | Impact of Replacement Volumes on Inspection Obligations"]
[]
[null,null,{"$f":"\"Calculation | \"&'Output|Charts'!P13&\" outstanding inspection obligations / replacements\"","v":"Calculation | Revised Proposal outstanding inspection obligations / replacements"}]
[]
[null,null,null,"Item",{"$f":"E$4","v":"Unit"},{"$f":"F$4","v":"Basis"},"Installation Year","Installation Volume (#)","Inspection Year",{"$f":"IF(CF_Type=Annually,\"FY\"&RIGHT(J$3,2),TEXT(DATE(J$3,J$4,1),\"mmm-yyyy\"))","v":"FY26"},"FY27","FY28","FY29","FY30","FY31","FY32","FY33","FY34","FY35",{"$f":"$T$3","v":2036}]
[]
[null,null,null,{"$f":"'Input|Installations'!D39","v":"Inspection obligation starts after x years"},"Years","n/a",null,null,{"$f":"'Input|Installations'!$J$39","v":15}]
[null,null,null,{"$f":"'Input|Installations'!D40","v":"Inspection avoided if replacements done within x years"},"Years","n/a",null,null,1]
[]
[null,null,null,{"$f":"\"Inspection obligation - \"&G17&\" Installations\"","v":"Inspection obligation - 2010 Installations"},"# Meters","n/a",{"$f":"'Input|Installations'!F13","v":2010},{"$f":"'Input|Installations'!N13","v":28384.666666666664},{"$f":"G17+$I$14+1","v":2026},{"$f":"AND(J$3>=$I17,J$3<=$I17+$I$15-1)*$H17/$I$15","v":28384.666666666664},{"$f":"AND(K$3>=$I17,K$3<=$I17+$I$15-1)*$H17/$I$15","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"\"Inspection obligation - \"&G18&\" Installations\"","v":"Inspection obligation - 2011 Installations"},"# Meters","n/a",{"$f":"'Input|Installations'!F14","v":2011},{"$f":"'Input|Installations'!N14","v":36918.333333333328},{"$f":"G18+$I$14+1","v":2027},{"$f":"AND(J$3>=$I18,J$3<=$I18+$I$15-1)*$H18/$I$15","v":0},36918.333333333328,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspection obligation - 2012 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F15","v":2012},{"$f":"'Input|Installations'!N15","v":56660.5},2028,0,0,56660.5,0,0,0,0,0,0,0,0]
[null,null,null,"Inspection obligation - 2013 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F16","v":2013},{"$f":"'Input|Installations'!N16","v":89616.5},2029,0,0,0,89616.5,0,0,0,0,0,0,0]
[null,null,null,"Inspection obligation - 2014 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F17","v":2014},{"$f":"'Input|Installations'!N17","v":75332},2030,0,0,0,0,75332,0,0,0,0,0,0]
[null,null,null,"Inspection obligation - 2015 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F18","v":2015},{"$f":"'Input|Installations'!N18","v":22219.5},2031,0,0,0,0,0,22219.5,0,0,0,0,0]
[null,null,null,"Inspection obligation - 2016 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F19","v":2016},{"$f":"'Input|Installations'!N19","v":9423.5},2032,0,0,0,0,0,0,9423.5,0,0,0,0]
[null,null,null,"Inspection obligation - 2017 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F20","v":2017},{"$f":"'Input|Installations'!N20","v":9257},2033,0,0,0,0,0,0,0,9257,0,0,0]
[null,null,null,"Inspection obligation - 2018 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F21","v":2018},{"$f":"'Input|Installations'!N21","v":9249},2034,0,0,0,0,0,0,0,0,9249,0,0]
[null,null,null,"Inspection obligation - 2019 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F22","v":2019},{"$f":"'Input|Installations'!N22","v":9301.5},2035,0,0,0,0,0,0,0,0,0,9301.5,0]
[null,null,null,"Inspection obligation - 2020 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F23","v":2020},{"$f":"'Input|Installations'!N23","v":9343.5},2036,0,0,0,0,0,0,0,0,0,0,9343.5]
[null,null,null,"Inspection obligation - 2021 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F24","v":2021},{"$f":"'Input|Installations'!N24","v":8430},2037,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspection obligation - 2022 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F25","v":2022},{"$f":"'Input|Installations'!N25","v":9186},2038,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspection obligation - 2023 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F26","v":2023},{"$f":"'Input|Installations'!N26","v":9538},2039,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspection obligation - 2024 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F27","v":2024},{"$f":"'Input|Installations'!N27","v":8283},2040,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspection obligation - 2025 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F28","v":2025},{"$f":"'Input|Installations'!N28","v":8983},2041,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Total inspection obligation","# Meters","n/a",null,null,null,{"$f":"SUM(J17:J32)","v":28384.666666666664},{"$f":"SUM(K17:K32)","v":36918.333333333328},56660.5,89616.5,75332,22219.5,9423.5,9257,9249,9301.5,9343.5]
[]
[null,null,null,"Smoothing adjustment","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Total smoothed inspection obligations","# Meters","n/a",null,null,null,{"$f":"J34+J36","v":28384.666666666664},{"$f":"K34+K36","v":36918.333333333328},56660.5,89616.5,75332,22219.5,9423.5,9257,9249,9301.5,9343.5]
[]
[null,null,null,"Less allowed replacements","# Meters","n/a",null,null,null,0,{"$f":"-'Output|Charts'!Q13","v":-22284.399999999998},{"$f":"-'Output|Charts'!R13","v":-29802},{"$f":"-'Output|Charts'!S13","v":-34802.199999999997},{"$f":"-'Output|Charts'!T13","v":-37801.799999999996},{"$f":"-'Output|Charts'!U13","v":-41664.19999999999}]
[]
[null,null,null,"Outstanding Inspections","# Meters","n/a",null,null,null,{"$f":"MAX(0,J38+SUM(J40:J40))","v":28384.666666666664},14633.933333333331,26858.5,54814.3,37530.200000000004,0,9423.5,9257,9249,9301.5,9343.5]
[]
[null,null,null,"Cumulative outstanding inspections / replacements","# Meters","n/a",null,null,null,{"$f":"SUM($J42:J42)","v":28384.666666666664},{"$f":"SUM($J42:K42)","v":43018.599999999991},{"$f":"SUM($J42:L42)","v":69877.099999999991},{"$f":"SUM($J42:M42)","v":124691.4},{"$f":"SUM($J42:N42)","v":162221.6},{"$f":"SUM($J42:O42)","v":162221.6},{"$f":"SUM($J42:P42)","v":171645.1},{"$f":"SUM($J42:Q42)","v":180902.1},{"$f":"SUM($J42:R42)","v":190151.1},{"$f":"SUM($J42:S42)","v":199452.6},{"$f":"SUM($J42:T42)","v":208796.1}]
[]
[null,null,null,"Meters remaining in the field due for inspection / replacements","# Meters","n/a",null,null,null,{"$f":"SUMIF($I$17:$I$32,\"<=\"&J$3,$H$17:$H$32)+SUM($J40:J40)","v":28384.666666666664},{"$f":"SUMIF($I$17:$I$32,\"<=\"&K$3,$H$17:$H$32)+SUM($J40:K40)","v":43018.599999999991},{"$f":"SUMIF($I$17:$I$32,\"<=\"&L$3,$H$17:$H$32)+SUM($J40:L40)","v":69877.100000000006},{"$f":"SUMIF($I$17:$I$32,\"<=\"&M$3,$H$17:$H$32)+SUM($J40:M40)","v":124691.40000000001},{"$f":"SUMIF($I$17:$I$32,\"<=\"&N$3,$H$17:$H$32)+SUM($J40:N40)","v":162221.6},{"$f":"SUMIF($I$17:$I$32,\"<=\"&O$3,$H$17:$H$32)+SUM($J40:O40)","v":142776.90000000002},{"$f":"SUMIF($I$17:$I$32,\"<=\"&P$3,$H$17:$H$32)+SUM($J40:P40)","v":152200.40000000002},{"$f":"SUMIF($I$17:$I$32,\"<=\"&Q$3,$H$17:$H$32)+SUM($J40:Q40)","v":161457.40000000002},{"$f":"SUMIF($I$17:$I$32,\"<=\"&R$3,$H$17:$H$32)+SUM($J40:R40)","v":170706.40000000002},{"$f":"SUMIF($I$17:$I$32,\"<=\"&S$3,$H$17:$H$32)+SUM($J40:S40)","v":180007.90000000002},{"$f":"SUMIF($I$17:$I$32,\"<=\"&T$3,$H$17:$H$32)+SUM($J40:T40)","v":189351.40000000002}]
[]
[null,"Input | Allocation of annual replacements and inspections to meter installation year"]
[]
[null,null,null,"Summary",{"$f":"E$4","v":"Unit"},{"$f":"F$4","v":"Basis"},null,null,null,{"$f":"IF(CF_Type=Annually,\"FY\"&RIGHT(J$3,2),TEXT(DATE(J$3,J$4,1),\"mmm-yyyy\"))","v":"FY26"},"FY27","FY28","FY29","FY30","FY31","FY32","FY33","FY34","FY35",{"$f":"$T$3","v":2036}]
[]
[null,null,null,{"$f":"H12","v":"Installation Volume (#)"},"# Meters","n/a",null,null,null,{"$f":"TRANSPOSE(H17:H27)","v":28384.666666666664},36918.333333333328,56660.5,89616.5,75332,22219.5,9423.5,9257,9249,9301.5,9343.5]
[]
[null,null,null,"Less allowed replacements","# Meters","n/a",null,null,null,0,{"$f":"-'Output|Charts'!Q13","v":-22284.399999999998},{"$f":"-'Output|Charts'!R13","v":-29802},{"$f":"-'Output|Charts'!S13","v":-34802.199999999997},{"$f":"-'Output|Charts'!T13","v":-37801.799999999996},{"$f":"-'Output|Charts'!U13","v":-41664.19999999999}]
[null,null,null,"Less allowed inspections","# Meters","n/a",null,null,null,0,{"$f":"-'Output|Charts'!Q36","v":0},{"$f":"-'Output|Charts'!R36","v":0},{"$f":"-'Output|Charts'!S36","v":0},{"$f":"-'Output|Charts'!T36","v":0},{"$f":"-'Output|Charts'!U36","v":0}]
[]
[null,null,null,{"$f":"D44","v":"Cumulative outstanding inspections / replacements"},"# Meters","n/a",null,null,null,{"$f":"SUM($J52:J55)","v":28384.666666666664},{"$f":"SUM($J52:K55)","v":43018.599999999991},{"$f":"SUM($J52:L55)","v":69877.100000000006},{"$f":"SUM($J52:M55)","v":124691.40000000001},{"$f":"SUM($J52:N55)","v":162221.59999999998},{"$f":"SUM($J52:O55)","v":142776.9},{"$f":"SUM($J52:P55)","v":152200.4},{"$f":"SUM($J52:Q55)","v":161457.4},{"$f":"SUM($J52:R55)","v":170706.4},{"$f":"SUM($J52:S55)","v":180007.9},{"$f":"SUM($J52:T55)","v":189351.4}]
[]
[null,null,null,"Inspection Volumes - 2026-31 Regulatory Period",{"$f":"E$4","v":"Unit"},{"$f":"F$4","v":"Basis"},"Installation Year","Installation Volume (#)","Inspection Year",{"$f":"IF(CF_Type=Annually,\"FY\"&RIGHT(J$3,2),TEXT(DATE(J$3,J$4,1),\"mmm-yyyy\"))","v":"FY26"},"FY27","FY28","FY29","FY30","FY31","FY32","FY33","FY34","FY35",{"$f":"$T$3","v":2036}]
[]
[null,null,null,{"$f":"\"Opening Inspections Due - \"&I61","v":"Opening Inspections Due - 2026"},"# Meters","n/a",{"$f":"G17","v":2010},28384.666666666664,2026,{"$f":"IF(J$3=$I61,$H61,I137)","v":28384.666666666664},28384.666666666664,6100.2666666666664,0,0,0,0,0,0,0,0]
[null,null,null,"Opening Inspections Due - 2027","# Meters","n/a",2011,36918.333333333328,2027,0,36918.333333333328,36918.333333333328,13216.599999999995,0,0,0,0,0,0,0]
[null,null,null,"Opening Inspections Due - 2028","# Meters","n/a",2012,56660.5,2028,0,0,56660.5,56660.5,35074.899999999994,0,0,0,0,0,0]
[null,null,null,"Opening Inspections Due - 2029","# Meters","n/a",2013,89616.5,2029,0,0,0,89616.5,89616.5,86889.600000000006,45225.400000000016,45225.400000000016,45225.400000000016,45225.400000000016,45225.400000000016]
[null,null,null,"Opening Inspections Due - 2030","# Meters","n/a",2014,75332,2030,0,0,0,0,75332,75332,75332,75332,75332,75332,75332]
[null,null,null,"Opening Inspections Due - 2031","# Meters","n/a",2015,22219.5,2031,0,0,0,0,0,22219.5,22219.5,22219.5,22219.5,22219.5,22219.5]
[null,null,null,"Opening Inspections Due - 2032","# Meters","n/a",2016,9423.5,2032,0,0,0,0,0,0,9423.5,9423.5,9423.5,9423.5,9423.5]
[null,null,null,"Opening Inspections Due - 2033","# Meters","n/a",2017,9257,2033,0,0,0,0,0,0,0,9257,9257,9257,9257]
[null,null,null,"Opening Inspections Due - 2034","# Meters","n/a",2018,9249,2034,0,0,0,0,0,0,0,0,9249,9249,9249]
[null,null,null,"Opening Inspections Due - 2035","# Meters","n/a",2019,9301.5,2035,0,0,0,0,0,0,0,0,0,9301.5,9301.5]
[null,null,null,"Opening Inspections Due - 2036","# Meters","n/a",2020,9343.5,2036,0,0,0,0,0,0,0,0,0,0,9343.5]
[null,null,null,"Opening Inspections Due - 2037","# Meters","n/a",2021,8430,2037,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Opening Inspections Due - 2038","# Meters","n/a",2022,9186,2038,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Opening Inspections Due - 2039","# Meters","n/a",2023,9538,2039,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Opening Inspections Due - 2040","# Meters","n/a",2024,8283,2040,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Opening Inspections Due - 2041","# Meters","n/a",2025,8983,2041,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Total Opening Inspections Due","# Meters","n/a",null,null,null,{"$f":"SUM(J61:J76)","v":28384.666666666664},{"$f":"SUM(K61:K76)","v":65302.999999999993},99679.099999999991,159493.59999999998,200023.4,184441.1,152200.40000000002,161457.40000000002,170706.40000000002,180007.90000000002,189351.40000000002]
[]
[null,null,null,{"$f":"\"Inspections avoided due to replacements - \"&I61","v":"Inspections avoided due to replacements - 2026"},"# Meters","n/a",null,null,null,0,{"$f":"K$54","v":-22284.399999999998},{"$f":"-L61","v":-6100.2666666666664},0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2027","# Meters","n/a",null,null,null,0,0,{"$f":"L$54-L80","v":-23701.733333333334},{"$f":"-M62","v":-13216.599999999995},0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2028","# Meters","n/a",null,null,null,0,0,0,{"$f":"M$54-M81","v":-21585.600000000002},{"$f":"-N63","v":-35074.899999999994},0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2029","# Meters","n/a",null,null,null,0,0,0,0,{"$f":"N$54-N82","v":-2726.9000000000015},{"$f":"O$54","v":-41664.19999999999},0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2030","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2031","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2032","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2033","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2034","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2035","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2036","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2037","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2038","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2039","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2040","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2041","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Total inspections avoided due to replacements","# Meters","n/a",null,null,null,{"$f":"SUM(J80:J95)","v":0},{"$f":"SUM(K80:K95)","v":-22284.399999999998},-29802,-34802.199999999997,-37801.799999999996,-41664.19999999999,0,0,0,0,0]
[]
[null,null,null,{"$f":"\"Interim Balance - Prior to inspections - \"&I61","v":"Interim Balance - Prior to inspections - 2026"},"# Meters","n/a",null,null,null,{"$f":"J61+J80","v":28384.666666666664},{"$f":"K61+K80","v":6100.2666666666664},0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"\"Interim Balance - Prior to inspections - \"&I62","v":"Interim Balance - Prior to inspections - 2027"},"# Meters","n/a",null,null,null,{"$f":"J62+J81","v":0},36918.333333333328,13216.599999999995,0,0,0,0,0,0,0,0]
[null,null,null,"Interim Balance - Prior to inspections - 2028","# Meters","n/a",null,null,null,0,0,56660.5,35074.899999999994,0,0,0,0,0,0,0]
[null,null,null,"Interim Balance - Prior to inspections - 2029","# Meters","n/a",null,null,null,0,0,0,89616.5,86889.600000000006,45225.400000000016,45225.400000000016,45225.400000000016,45225.400000000016,45225.400000000016,45225.400000000016]
[null,null,null,"Interim Balance - Prior to inspections - 2030","# Meters","n/a",null,null,null,0,0,0,0,75332,75332,75332,75332,75332,75332,75332]
[null,null,null,"Interim Balance - Prior to inspections - 2031","# Meters","n/a",null,null,null,0,0,0,0,0,22219.5,22219.5,22219.5,22219.5,22219.5,22219.5]
[null,null,null,"Interim Balance - Prior to inspections - 2032","# Meters","n/a",null,null,null,0,0,0,0,0,0,9423.5,9423.5,9423.5,9423.5,9423.5]
[null,null,null,"Interim Balance - Prior to inspections - 2033","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,9257,9257,9257,9257]
[null,null,null,"Interim Balance - Prior to inspections - 2034","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,9249,9249,9249]
[null,null,null,"Interim Balance - Prior to inspections - 2035","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,9301.5,9301.5]
[null,null,null,"Interim Balance - Prior to inspections - 2036","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,9343.5]
[null,null,null,"Interim Balance - Prior to inspections - 2037","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Interim Balance - Prior to inspections - 2038","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Interim Balance - Prior to inspections - 2039","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Interim Balance - Prior to inspections - 2040","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Interim Balance - Prior to inspections - 2041","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Total Interim Balance","# Meters","n/a",null,null,null,{"$f":"SUM(J99:J114)","v":28384.666666666664},{"$f":"SUM(K99:K114)","v":43018.599999999991},69877.099999999991,124691.4,162221.6,142776.90000000002,152200.40000000002,161457.40000000002,170706.40000000002,180007.90000000002,189351.40000000002]
[]
[null,null,null,{"$f":"\"Inspections completed - \"&I61","v":"Inspections completed - 2026"},"# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"\"Inspections completed - \"&I62","v":"Inspections completed - 2027"},"# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2028","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2029","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2030","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2031","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2032","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2033","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2034","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2035","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2036","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2037","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2038","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2039","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2040","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2041","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Total inspections completed","# Meters","n/a",null,null,null,{"$f":"SUM(J118:J133)","v":0},{"$f":"SUM(K118:K133)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,{"$f":"\"Closing Inspections Due - \"&I61","v":"Closing Inspections Due - 2026"},"# Meters","n/a",null,null,null,{"$f":"J61+J80+J118","v":28384.666666666664},{"$f":"K61+K80+K118","v":6100.2666666666664},0,0,0,0,0,0,0,0,0]
[null,null,null,"Closing Inspections Due - 2027","# Meters","n/a",null,null,null,{"$f":"J62+J81+J119","v":0},36918.333333333328,13216.599999999995,0,0,0,0,0,0,0,0]
[null,null,null,"Closing Inspections Due - 2028","# Meters","n/a",null,null,null,0,0,56660.5,35074.899999999994,0,0,0,0,0,0,0]
[null,null,null,"Closing Inspections Due - 2029","# Meters","n/a",null,null,null,0,0,0,89616.5,86889.600000000006,45225.400000000016,45225.400000000016,45225.400000000016,45225.400000000016,45225.400000000016,45225.400000000016]
[null,null,null,"Closing Inspections Due - 2030","# Meters","n/a",null,null,null,0,0,0,0,75332,75332,75332,75332,75332,75332,75332]
[null,null,null,"Closing Inspections Due - 2031","# Meters","n/a",null,null,null,0,0,0,0,0,22219.5,22219.5,22219.5,22219.5,22219.5,22219.5]
[null,null,null,"Closing Inspections Due - 2032","# Meters","n/a",null,null,null,0,0,0,0,0,0,9423.5,9423.5,9423.5,9423.5,9423.5]
[null,null,null,"Closing Inspections Due - 2033","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,9257,9257,9257,9257]
[null,null,null,"Closing Inspections Due - 2034","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,9249,9249,9249]
[null,null,null,"Closing Inspections Due - 2035","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,9301.5,9301.5]
[null,null,null,"Closing Inspections Due - 2036","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,9343.5]
[null,null,null,"Closing Inspections Due - 2037","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Closing Inspections Due - 2038","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Closing Inspections Due - 2039","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Closing Inspections Due - 2040","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Closing Inspections Due - 2041","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Total Outstanding Inspections Due","# Meters","n/a",null,null,null,{"$f":"SUM(J137:J152)","v":28384.666666666664},{"$f":"SUM(K137:K152)","v":43018.599999999991},69877.099999999991,124691.4,162221.6,142776.90000000002,152200.40000000002,161457.40000000002,170706.40000000002,180007.90000000002,189351.40000000002]
[]
[{"$f":"IF(SUM(J156:T156)=0,0,1)","v":0},null,null,"Check - replacements","n/a","n/a",null,null,null,{"$f":"IF(ROUND(J97-J$54,3)=0,0,1)","v":0},{"$f":"IF(ROUND(K97-K$54,3)=0,0,1)","v":0},0,0,0,0,0,0,0,0,0]
[{"$f":"IF(SUM(J157:T157)=0,0,1)","v":0},null,null,"Check - inspections","n/a","n/a",null,null,null,{"$f":"IF(ROUND(J135-J$55,3)=0,0,1)","v":0},{"$f":"IF(ROUND(K135-K$55,3)=0,0,1)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,"Calculation | Inspection Delay and Meter Age"]
[]
[null,null,"Calculation | Chart Data - Inspection Delay"]
[]
[null,null,null,"Inspection Delay",{"$f":"E$4","v":"Unit"},{"$f":"F$4","v":"Basis"},null,null,null,{"$f":"IF(CF_Type=Annually,\"FY\"&RIGHT(J$3,2),TEXT(DATE(J$3,J$4,1),\"mmm-yyyy\"))","v":"FY26"},"FY27","FY28","FY29","FY30","FY31","FY32","FY33","FY34","FY35",{"$f":"$T$3","v":2036}]
[]
[null,null,null,{"$f":"\"Inspections - \"&I61","v":"Inspections - 2026"},{"$f":"Year","v":"year"},"n/a",null,null,null,1,{"$f":"J165+1","v":2},{"$f":"K165+1","v":3},4,5,6,7,8,9,10,11]
[null,null,null,{"$f":"\"Inspections - \"&I62","v":"Inspections - 2027"},"year","n/a",null,null,null,0,1,{"$f":"K166+1","v":2},3,4,5,6,7,8,9,10]
[null,null,null,"Inspections - 2028","year","n/a",null,null,null,0,0,1,{"$f":"L167+1","v":2},3,4,5,6,7,8,9]
[null,null,null,"Inspections - 2029","year","n/a",null,null,null,0,0,0,1,{"$f":"M168+1","v":2},3,4,5,6,7,8]
[null,null,null,"Inspections - 2030","year","n/a",null,null,null,0,0,0,0,1,{"$f":"N169+1","v":2},3,4,5,6,7]
[null,null,null,"Inspections - 2031","year","n/a",null,null,null,0,0,0,0,0,1,{"$f":"O170+1","v":2},3,4,5,6]
[null,null,null,"Inspections - 2032","year","n/a",null,null,null,0,0,0,0,0,0,1,{"$f":"P171+1","v":2},3,4,5]
[null,null,null,"Inspections - 2033","year","n/a",null,null,null,0,0,0,0,0,0,0,1,{"$f":"Q172+1","v":2},3,4]
[null,null,null,"Inspections - 2034","year","n/a",null,null,null,0,0,0,0,0,0,0,0,1,{"$f":"R173+1","v":2},3]
[null,null,null,"Inspections - 2035","year","n/a",null,null,null,0,0,0,0,0,0,0,0,0,1,{"$f":"S174+1","v":2}]
[null,null,null,"Inspections - 2036","year","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,1]
[null,null,null,"Inspections - 2037","year","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"End"]

{"sheet":"Input|AER_DD_Vol","index":3,"n_rows":178,"n_cols":20,"rows_kept":178,"cut":false,"hidden":false,"merged":[]}
[null,null,null,{"$f":"Model_Name","v":"Inspection and Replacement Obligation Volume Model"},null,null,null,"Section Check:",null,{"$f":"IF(COUNTA($A$8:$A$178)=COUNTIF($A$8:$A$178,0),\"Ok\",\"Check\")","v":"Ok"},null,"Overall Check:",{"$f":"Overall_Check","v":"Ok"},null,"Legend:","Input","Internal","Select","Calculation"]
[null,null,null,{"$f":"RIGHT(CELL(\"filename\",D1),LEN(CELL(\"filename\",D1))-FIND(\"]\",CELL(\"filename\",D1)))","v":"Input|AER_DD_Vol"}]
[null,null,null,null,null,null,null,"Year",null,{"$f":"'Input|RP_Vol'!$J$3","v":2026},{"$f":"IF(CF_Type=Annually,J3+1,IF(K4=1,J3+1,J3))","v":2027},2028,2029,2030,2031,2032,2033,2034,2035,2036]
[null,null,null,null,"Unit","Basis",null,"Month",null,{"$f":"IF(CF_Type=Annually,NA,Start_Month)","v":"n/a"},{"$f":"IF(J4=NA,NA,IF(J4+1=Months_in_year,Months_in_year,MOD(J4+1,Months_in_year)))","v":"n/a"},"n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Input | Impact of Replacement Volumes on Inspection Obligations"]
[]
[null,null,{"$f":"\"Calculation | \"&'Output|Charts'!P14&\" outstanding inspection obligations / replacements\"","v":"Calculation | Adjusted AER DD outstanding inspection obligations / replacements"}]
[]
[null,null,null,"Item",{"$f":"E$4","v":"Unit"},{"$f":"F$4","v":"Basis"},"Installation Year","Installation Volume (#)","Inspection Year",{"$f":"IF(CF_Type=Annually,\"FY\"&RIGHT(J$3,2),TEXT(DATE(J$3,J$4,1),\"mmm-yyyy\"))","v":"FY26"},"FY27","FY28","FY29","FY30","FY31","FY32","FY33","FY34","FY35",{"$f":"$T$3","v":2036}]
[]
[null,null,null,{"$f":"'Input|Installations'!D39","v":"Inspection obligation starts after x years"},"Years","n/a",null,null,{"$f":"'Input|Installations'!$J$39","v":15}]
[null,null,null,{"$f":"'Input|Installations'!D40","v":"Inspection avoided if replacements done within x years"},"Years","n/a",null,null,1]
[]
[null,null,null,{"$f":"\"Inspection obligation - \"&G17&\" Installations\"","v":"Inspection obligation - 2010 Installations"},"# Meters","n/a",{"$f":"'Input|Installations'!F13","v":2010},{"$f":"'Input|Installations'!N13","v":28384.666666666664},{"$f":"G17+$I$14+1","v":2026},{"$f":"AND(J$3>=$I17,J$3<=$I17+$I$15-1)*$H17/$I$15","v":28384.666666666664},{"$f":"AND(K$3>=$I17,K$3<=$I17+$I$15-1)*$H17/$I$15","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"\"Inspection obligation - \"&G18&\" Installations\"","v":"Inspection obligation - 2011 Installations"},"# Meters","n/a",{"$f":"'Input|Installations'!F14","v":2011},{"$f":"'Input|Installations'!N14","v":36918.333333333328},{"$f":"G18+$I$14+1","v":2027},{"$f":"AND(J$3>=$I18,J$3<=$I18+$I$15-1)*$H18/$I$15","v":0},36918.333333333328,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspection obligation - 2012 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F15","v":2012},{"$f":"'Input|Installations'!N15","v":56660.5},2028,0,0,56660.5,0,0,0,0,0,0,0,0]
[null,null,null,"Inspection obligation - 2013 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F16","v":2013},{"$f":"'Input|Installations'!N16","v":89616.5},2029,0,0,0,89616.5,0,0,0,0,0,0,0]
[null,null,null,"Inspection obligation - 2014 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F17","v":2014},{"$f":"'Input|Installations'!N17","v":75332},2030,0,0,0,0,75332,0,0,0,0,0,0]
[null,null,null,"Inspection obligation - 2015 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F18","v":2015},{"$f":"'Input|Installations'!N18","v":22219.5},2031,0,0,0,0,0,22219.5,0,0,0,0,0]
[null,null,null,"Inspection obligation - 2016 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F19","v":2016},{"$f":"'Input|Installations'!N19","v":9423.5},2032,0,0,0,0,0,0,9423.5,0,0,0,0]
[null,null,null,"Inspection obligation - 2017 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F20","v":2017},{"$f":"'Input|Installations'!N20","v":9257},2033,0,0,0,0,0,0,0,9257,0,0,0]
[null,null,null,"Inspection obligation - 2018 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F21","v":2018},{"$f":"'Input|Installations'!N21","v":9249},2034,0,0,0,0,0,0,0,0,9249,0,0]
[null,null,null,"Inspection obligation - 2019 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F22","v":2019},{"$f":"'Input|Installations'!N22","v":9301.5},2035,0,0,0,0,0,0,0,0,0,9301.5,0]
[null,null,null,"Inspection obligation - 2020 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F23","v":2020},{"$f":"'Input|Installations'!N23","v":9343.5},2036,0,0,0,0,0,0,0,0,0,0,9343.5]
[null,null,null,"Inspection obligation - 2021 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F24","v":2021},{"$f":"'Input|Installations'!N24","v":8430},2037,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspection obligation - 2022 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F25","v":2022},{"$f":"'Input|Installations'!N25","v":9186},2038,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspection obligation - 2023 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F26","v":2023},{"$f":"'Input|Installations'!N26","v":9538},2039,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspection obligation - 2024 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F27","v":2024},{"$f":"'Input|Installations'!N27","v":8283},2040,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspection obligation - 2025 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F28","v":2025},{"$f":"'Input|Installations'!N28","v":8983},2041,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Total inspection obligation","# Meters","n/a",null,null,null,{"$f":"SUM(J17:J32)","v":28384.666666666664},{"$f":"SUM(K17:K32)","v":36918.333333333328},56660.5,89616.5,75332,22219.5,9423.5,9257,9249,9301.5,9343.5]
[]
[null,null,null,"Smoothing adjustment","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Total smoothed inspection obligations","# Meters","n/a",null,null,null,{"$f":"J34+J36","v":28384.666666666664},{"$f":"K34+K36","v":36918.333333333328},56660.5,89616.5,75332,22219.5,9423.5,9257,9249,9301.5,9343.5]
[]
[null,null,null,"Less allowed replacements","# Meters","n/a",null,null,null,0,{"$f":"-'Output|Charts'!Q14","v":-3032.7141418881151},{"$f":"-'Output|Charts'!R14","v":-18196.284851328688},{"$f":"-'Output|Charts'!S14","v":-30327.141418881154},{"$f":"-'Output|Charts'!T14","v":-36392.569702657376},{"$f":"-'Output|Charts'!U14","v":-42457.99798643362}]
[]
[null,null,null,"Outstanding Inspections","# Meters","n/a",null,null,null,{"$f":"MAX(0,J38+SUM(J40:J40))","v":28384.666666666664},33885.619191445214,38464.215148671312,59289.358581118846,38939.430297342624,0,9423.5,9257,9249,9301.5,9343.5]
[]
[null,null,null,"Cumulative outstanding inspections / replacements","# Meters","n/a",null,null,null,{"$f":"SUM($J42:J42)","v":28384.666666666664},{"$f":"SUM($J42:K42)","v":62270.285858111878},{"$f":"SUM($J42:L42)","v":100734.50100678319},{"$f":"SUM($J42:M42)","v":160023.85958790203},{"$f":"SUM($J42:N42)","v":198963.28988524465},{"$f":"SUM($J42:O42)","v":198963.28988524465},{"$f":"SUM($J42:P42)","v":208386.78988524465},{"$f":"SUM($J42:Q42)","v":217643.78988524465},{"$f":"SUM($J42:R42)","v":226892.78988524465},{"$f":"SUM($J42:S42)","v":236194.28988524465},{"$f":"SUM($J42:T42)","v":245537.78988524465}]
[]
[null,null,null,"Meters remaining in the field due for inspection / replacements","# Meters","n/a",null,null,null,{"$f":"SUMIF($I$17:$I$32,\"<=\"&J$3,$H$17:$H$32)+SUM($J40:J40)","v":28384.666666666664},{"$f":"SUMIF($I$17:$I$32,\"<=\"&K$3,$H$17:$H$32)+SUM($J40:K40)","v":62270.285858111878},{"$f":"SUMIF($I$17:$I$32,\"<=\"&L$3,$H$17:$H$32)+SUM($J40:L40)","v":100734.50100678319},{"$f":"SUMIF($I$17:$I$32,\"<=\"&M$3,$H$17:$H$32)+SUM($J40:M40)","v":160023.85958790203},{"$f":"SUMIF($I$17:$I$32,\"<=\"&N$3,$H$17:$H$32)+SUM($J40:N40)","v":198963.28988524468},{"$f":"SUMIF($I$17:$I$32,\"<=\"&O$3,$H$17:$H$32)+SUM($J40:O40)","v":178724.79189881106},{"$f":"SUMIF($I$17:$I$32,\"<=\"&P$3,$H$17:$H$32)+SUM($J40:P40)","v":188148.29189881106},{"$f":"SUMIF($I$17:$I$32,\"<=\"&Q$3,$H$17:$H$32)+SUM($J40:Q40)","v":197405.29189881106},{"$f":"SUMIF($I$17:$I$32,\"<=\"&R$3,$H$17:$H$32)+SUM($J40:R40)","v":206654.29189881106},{"$f":"SUMIF($I$17:$I$32,\"<=\"&S$3,$H$17:$H$32)+SUM($J40:S40)","v":215955.79189881106},{"$f":"SUMIF($I$17:$I$32,\"<=\"&T$3,$H$17:$H$32)+SUM($J40:T40)","v":225299.29189881106}]
[]
[null,"Input | Allocation of annual replacements and inspections to meter installation year"]
[]
[null,null,null,"Summary",{"$f":"E$4","v":"Unit"},{"$f":"F$4","v":"Basis"},null,null,null,{"$f":"IF(CF_Type=Annually,\"FY\"&RIGHT(J$3,2),TEXT(DATE(J$3,J$4,1),\"mmm-yyyy\"))","v":"FY26"},"FY27","FY28","FY29","FY30","FY31","FY32","FY33","FY34","FY35",{"$f":"$T$3","v":2036}]
[]
[null,null,null,{"$f":"H12","v":"Installation Volume (#)"},"# Meters","n/a",null,null,null,{"$f":"TRANSPOSE(H17:H27)","v":28384.666666666664},36918.333333333328,56660.5,89616.5,75332,22219.5,9423.5,9257,9249,9301.5,9343.5]
[]
[null,null,null,"Less allowed replacements","# Meters","n/a",null,null,null,0,{"$f":"-'Output|Charts'!Q14","v":-3032.7141418881151},{"$f":"-'Output|Charts'!R14","v":-18196.284851328688},{"$f":"-'Output|Charts'!S14","v":-30327.141418881154},{"$f":"-'Output|Charts'!T14","v":-36392.569702657376},{"$f":"-'Output|Charts'!U14","v":-42457.99798643362}]
[null,null,null,"Less allowed inspections","# Meters","n/a",null,null,null,0,{"$f":"-'Output|Charts'!Q37","v":0},{"$f":"-'Output|Charts'!R37","v":0},{"$f":"-'Output|Charts'!S37","v":0},{"$f":"-'Output|Charts'!T37","v":0},{"$f":"-'Output|Charts'!U37","v":0}]
[]
[null,null,null,{"$f":"D44","v":"Cumulative outstanding inspections / replacements"},"# Meters","n/a",null,null,null,{"$f":"SUM($J52:J55)","v":28384.666666666664},{"$f":"SUM($J52:K55)","v":62270.285858111878},{"$f":"SUM($J52:L55)","v":100734.50100678319},{"$f":"SUM($J52:M55)","v":160023.85958790206},{"$f":"SUM($J52:N55)","v":198963.28988524462},{"$f":"SUM($J52:O55)","v":178724.791898811},{"$f":"SUM($J52:P55)","v":188148.29189881103},{"$f":"SUM($J52:Q55)","v":197405.29189881103},{"$f":"SUM($J52:R55)","v":206654.29189881103},{"$f":"SUM($J52:S55)","v":215955.79189881103},{"$f":"SUM($J52:T55)","v":225299.29189881106}]
[]
[null,null,null,"Inspection Volumes - 2026-31 Regulatory Period",{"$f":"E$4","v":"Unit"},{"$f":"F$4","v":"Basis"},"Installation Year","Installation Volume (#)","Inspection Year",{"$f":"IF(CF_Type=Annually,\"FY\"&RIGHT(J$3,2),TEXT(DATE(J$3,J$4,1),\"mmm-yyyy\"))","v":"FY26"},"FY27","FY28","FY29","FY30","FY31","FY32","FY33","FY34","FY35","FY36"]
[]
[null,null,null,{"$f":"\"Opening Inspections Due - \"&I61","v":"Opening Inspections Due - 2026"},"# Meters","n/a",{"$f":"G17","v":2010},28384.666666666664,2026,{"$f":"IF(J$3=$I61,$H61,I137)","v":28384.666666666664},28384.666666666664,25351.95252477855,7155.6676734498615,0,0,0,0,0,0,0]
[null,null,null,"Opening Inspections Due - 2027","# Meters","n/a",2011,36918.333333333328,2027,0,36918.333333333328,36918.333333333328,36918.333333333328,13746.859587902036,0,0,0,0,0,0]
[null,null,null,"Opening Inspections Due - 2028","# Meters","n/a",2012,56660.5,2028,0,0,56660.5,56660.5,56660.5,34014.78988524466,0,0,0,0,0]
[null,null,null,"Opening Inspections Due - 2029","# Meters","n/a",2013,89616.5,2029,0,0,0,89616.5,89616.5,89616.5,81173.291898811032,81173.291898811032,81173.291898811032,81173.291898811032,81173.291898811032]
[null,null,null,"Opening Inspections Due - 2030","# Meters","n/a",2014,75332,2030,0,0,0,0,75332,75332,75332,75332,75332,75332,75332]
[null,null,null,"Opening Inspections Due - 2031","# Meters","n/a",2015,22219.5,2031,0,0,0,0,0,22219.5,22219.5,22219.5,22219.5,22219.5,22219.5]
[null,null,null,"Opening Inspections Due - 2032","# Meters","n/a",2016,9423.5,2032,0,0,0,0,0,0,9423.5,9423.5,9423.5,9423.5,9423.5]
[null,null,null,"Opening Inspections Due - 2033","# Meters","n/a",2017,9257,2033,0,0,0,0,0,0,0,9257,9257,9257,9257]
[null,null,null,"Opening Inspections Due - 2034","# Meters","n/a",2018,9249,2034,0,0,0,0,0,0,0,0,9249,9249,9249]
[null,null,null,"Opening Inspections Due - 2035","# Meters","n/a",2019,9301.5,2035,0,0,0,0,0,0,0,0,0,9301.5,9301.5]
[null,null,null,"Opening Inspections Due - 2036","# Meters","n/a",2020,9343.5,2036,0,0,0,0,0,0,0,0,0,0,9343.5]
[null,null,null,"Opening Inspections Due - 2037","# Meters","n/a",2021,8430,2037,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Opening Inspections Due - 2038","# Meters","n/a",2022,9186,2038,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Opening Inspections Due - 2039","# Meters","n/a",2023,9538,2039,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Opening Inspections Due - 2040","# Meters","n/a",2024,8283,2040,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Opening Inspections Due - 2041","# Meters","n/a",2025,8983,2041,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Total Opening Inspections Due","# Meters","n/a",null,null,null,{"$f":"SUM(J61:J76)","v":28384.666666666664},{"$f":"SUM(K61:K76)","v":65302.999999999993},118930.78585811188,190351.00100678319,235355.85958790203,221182.78988524465,188148.29189881103,197405.29189881103,206654.29189881103,215955.79189881103,225299.29189881103]
[]
[null,null,null,{"$f":"\"Inspections avoided due to replacements - \"&I61","v":"Inspections avoided due to replacements - 2026"},"# Meters","n/a",null,null,null,0,{"$f":"K$54","v":-3032.7141418881151},{"$f":"L$54","v":-18196.284851328688},{"$f":"-M61","v":-7155.6676734498615},0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2027","# Meters","n/a",null,null,null,0,0,0,{"$f":"M$54-M80","v":-23171.473745431293},{"$f":"-N62","v":-13746.859587902036},0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2028","# Meters","n/a",null,null,null,0,0,0,0,{"$f":"N$54-N81","v":-22645.71011475534},{"$f":"-O63","v":-34014.78988524466},0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2029","# Meters","n/a",null,null,null,0,0,0,0,0,{"$f":"O$54-O82","v":-8443.2081011889604},0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2030","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2031","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2032","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2033","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2034","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2035","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2036","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2037","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2038","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2039","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2040","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2041","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Total inspections avoided due to replacements","# Meters","n/a",null,null,null,{"$f":"SUM(J80:J95)","v":0},{"$f":"SUM(K80:K95)","v":-3032.7141418881151},-18196.284851328688,-30327.141418881154,-36392.569702657376,-42457.99798643362,0,0,0,0,0]
[]
[null,null,null,{"$f":"\"Interim Balance - Prior to inspections - \"&I61","v":"Interim Balance - Prior to inspections - 2026"},"# Meters","n/a",null,null,null,{"$f":"J61+J80","v":28384.666666666664},{"$f":"K61+K80","v":25351.95252477855},7155.6676734498615,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"\"Interim Balance - Prior to inspections - \"&I62","v":"Interim Balance - Prior to inspections - 2027"},"# Meters","n/a",null,null,null,{"$f":"J62+J81","v":0},36918.333333333328,36918.333333333328,13746.859587902036,0,0,0,0,0,0,0]
[null,null,null,"Interim Balance - Prior to inspections - 2028","# Meters","n/a",null,null,null,0,0,56660.5,56660.5,34014.78988524466,0,0,0,0,0,0]
[null,null,null,"Interim Balance - Prior to inspections - 2029","# Meters","n/a",null,null,null,0,0,0,89616.5,89616.5,81173.291898811032,81173.291898811032,81173.291898811032,81173.291898811032,81173.291898811032,81173.291898811032]
[null,null,null,"Interim Balance - Prior to inspections - 2030","# Meters","n/a",null,null,null,0,0,0,0,75332,75332,75332,75332,75332,75332,75332]
[null,null,null,"Interim Balance - Prior to inspections - 2031","# Meters","n/a",null,null,null,0,0,0,0,0,22219.5,22219.5,22219.5,22219.5,22219.5,22219.5]
[null,null,null,"Interim Balance - Prior to inspections - 2032","# Meters","n/a",null,null,null,0,0,0,0,0,0,9423.5,9423.5,9423.5,9423.5,9423.5]
[null,null,null,"Interim Balance - Prior to inspections - 2033","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,9257,9257,9257,9257]
[null,null,null,"Interim Balance - Prior to inspections - 2034","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,9249,9249,9249]
[null,null,null,"Interim Balance - Prior to inspections - 2035","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,9301.5,9301.5]
[null,null,null,"Interim Balance - Prior to inspections - 2036","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,9343.5]
[null,null,null,"Interim Balance - Prior to inspections - 2037","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Interim Balance - Prior to inspections - 2038","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Interim Balance - Prior to inspections - 2039","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Interim Balance - Prior to inspections - 2040","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Interim Balance - Prior to inspections - 2041","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Total Interim Balance","# Meters","n/a",null,null,null,{"$f":"SUM(J99:J114)","v":28384.666666666664},{"$f":"SUM(K99:K114)","v":62270.285858111878},100734.50100678319,160023.85958790203,198963.28988524465,178724.79189881103,188148.29189881103,197405.29189881103,206654.29189881103,215955.79189881103,225299.29189881103]
[]
[null,null,null,{"$f":"\"Inspections completed - \"&I61","v":"Inspections completed - 2026"},"# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"\"Inspections completed - \"&I62","v":"Inspections completed - 2027"},"# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2028","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2029","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2030","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2031","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2032","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2033","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2034","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2035","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2036","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2037","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2038","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2039","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2040","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2041","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Total inspections completed","# Meters","n/a",null,null,null,{"$f":"SUM(J118:J133)","v":0},{"$f":"SUM(K118:K133)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,{"$f":"\"Closing Inspections Due - \"&I61","v":"Closing Inspections Due - 2026"},"# Meters","n/a",null,null,null,{"$f":"J61+J80+J118","v":28384.666666666664},{"$f":"K61+K80+K118","v":25351.95252477855},7155.6676734498615,0,0,0,0,0,0,0,0]
[null,null,null,"Closing Inspections Due - 2027","# Meters","n/a",null,null,null,{"$f":"J62+J81+J119","v":0},36918.333333333328,36918.333333333328,13746.859587902036,0,0,0,0,0,0,0]
[null,null,null,"Closing Inspections Due - 2028","# Meters","n/a",null,null,null,0,0,56660.5,56660.5,34014.78988524466,0,0,0,0,0,0]
[null,null,null,"Closing Inspections Due - 2029","# Meters","n/a",null,null,null,0,0,0,89616.5,89616.5,81173.291898811032,81173.291898811032,81173.291898811032,81173.291898811032,81173.291898811032,81173.291898811032]
[null,null,null,"Closing Inspections Due - 2030","# Meters","n/a",null,null,null,0,0,0,0,75332,75332,75332,75332,75332,75332,75332]
[null,null,null,"Closing Inspections Due - 2031","# Meters","n/a",null,null,null,0,0,0,0,0,22219.5,22219.5,22219.5,22219.5,22219.5,22219.5]
[null,null,null,"Closing Inspections Due - 2032","# Meters","n/a",null,null,null,0,0,0,0,0,0,9423.5,9423.5,9423.5,9423.5,9423.5]
[null,null,null,"Closing Inspections Due - 2033","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,9257,9257,9257,9257]
[null,null,null,"Closing Inspections Due - 2034","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,9249,9249,9249]
[null,null,null,"Closing Inspections Due - 2035","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,9301.5,9301.5]
[null,null,null,"Closing Inspections Due - 2036","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,9343.5]
[null,null,null,"Closing Inspections Due - 2037","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Closing Inspections Due - 2038","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Closing Inspections Due - 2039","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Closing Inspections Due - 2040","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Closing Inspections Due - 2041","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Total Outstanding Inspections Due","# Meters","n/a",null,null,null,{"$f":"SUM(J137:J152)","v":28384.666666666664},{"$f":"SUM(K137:K152)","v":62270.285858111878},100734.50100678319,160023.85958790203,198963.28988524465,178724.79189881103,188148.29189881103,197405.29189881103,206654.29189881103,215955.79189881103,225299.29189881103]
[]
[{"$f":"IF(SUM(J156:T156)=0,0,1)","v":0},null,null,"Check - replacements","n/a","n/a",null,null,null,{"$f":"IF(ROUND(J97-J$54,3)=0,0,1)","v":0},{"$f":"IF(ROUND(K97-K$54,3)=0,0,1)","v":0},0,0,0,0,0,0,0,0,0]
[{"$f":"IF(SUM(J157:T157)=0,0,1)","v":0},null,null,"Check - inspections","n/a","n/a",null,null,null,{"$f":"IF(ROUND(J135-J$55,3)=0,0,1)","v":0},{"$f":"IF(ROUND(K135-K$55,3)=0,0,1)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,"Calculation | Inspection Delay and Meter Age"]
[]
[null,null,"Calculation | Chart Data - Inspection Delay"]
[]
[null,null,null,"Inspection Delay",{"$f":"E$4","v":"Unit"},{"$f":"F$4","v":"Basis"},null,null,null,{"$f":"IF(CF_Type=Annually,\"FY\"&RIGHT(J$3,2),TEXT(DATE(J$3,J$4,1),\"mmm-yyyy\"))","v":"FY26"},"FY27","FY28","FY29","FY30","FY31","FY32","FY33","FY34","FY35",{"$f":"$T$3","v":2036}]
[]
[null,null,null,{"$f":"\"Inspections - \"&I61","v":"Inspections - 2026"},{"$f":"Year","v":"year"},"n/a",null,null,null,1,{"$f":"J165+1","v":2},{"$f":"K165+1","v":3},4,5,6,7,8,9,10,11]
[null,null,null,{"$f":"\"Inspections - \"&I62","v":"Inspections - 2027"},"year","n/a",null,null,null,0,1,{"$f":"K166+1","v":2},3,4,5,6,7,8,9,10]
[null,null,null,"Inspections - 2028","year","n/a",null,null,null,0,0,1,{"$f":"L167+1","v":2},3,4,5,6,7,8,9]
[null,null,null,"Inspections - 2029","year","n/a",null,null,null,0,0,0,1,{"$f":"M168+1","v":2},3,4,5,6,7,8]
[null,null,null,"Inspections - 2030","year","n/a",null,null,null,0,0,0,0,1,{"$f":"N169+1","v":2},3,4,5,6,7]
[null,null,null,"Inspections - 2031","year","n/a",null,null,null,0,0,0,0,0,1,{"$f":"O170+1","v":2},3,4,5,6]
[null,null,null,"Inspections - 2032","year","n/a",null,null,null,0,0,0,0,0,0,1,{"$f":"P171+1","v":2},3,4,5]
[null,null,null,"Inspections - 2033","year","n/a",null,null,null,0,0,0,0,0,0,0,1,{"$f":"Q172+1","v":2},3,4]
[null,null,null,"Inspections - 2034","year","n/a",null,null,null,0,0,0,0,0,0,0,0,1,{"$f":"R173+1","v":2},3]
[null,null,null,"Inspections - 2035","year","n/a",null,null,null,0,0,0,0,0,0,0,0,0,1,{"$f":"S174+1","v":2}]
[null,null,null,"Inspections - 2036","year","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,1]
[null,null,null,"Inspections - 2037","year","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"End"]

{"sheet":"Input|IP_Vol","index":4,"n_rows":178,"n_cols":20,"rows_kept":178,"cut":false,"hidden":false,"merged":[]}
[null,null,null,{"$f":"Model_Name","v":"Inspection and Replacement Obligation Volume Model"},null,null,null,"Section Check:",null,{"$f":"IF(COUNTA($A$8:$A$178)=COUNTIF($A$8:$A$178,0),\"Ok\",\"Check\")","v":"Ok"},null,"Overall Check:",{"$f":"Overall_Check","v":"Ok"},null,"Legend:","Input","Internal","Select","Calculation"]
[null,null,null,{"$f":"RIGHT(CELL(\"filename\",D1),LEN(CELL(\"filename\",D1))-FIND(\"]\",CELL(\"filename\",D1)))","v":"Input|IP_Vol"}]
[null,null,null,null,null,null,null,"Year",null,{"$f":"'Input|RP_Vol'!$J$3","v":2026},{"$f":"IF(CF_Type=Annually,J3+1,IF(K4=1,J3+1,J3))","v":2027},2028,2029,2030,2031,2032,2033,2034,2035,2036]
[null,null,null,null,"Unit","Basis",null,"Month",null,{"$f":"IF(CF_Type=Annually,NA,Start_Month)","v":"n/a"},{"$f":"IF(J4=NA,NA,IF(J4+1=Months_in_year,Months_in_year,MOD(J4+1,Months_in_year)))","v":"n/a"},"n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Input | Impact of Replacement Volumes on Inspection Obligations"]
[]
[null,null,{"$f":"\"Calculation | \"&'Output|Charts'!P15&\" outstanding inspection obligations / replacements\"","v":"Calculation | Initial Proposal outstanding inspection obligations / replacements"}]
[]
[null,null,null,"Item",{"$f":"E$4","v":"Unit"},{"$f":"F$4","v":"Basis"},"Installation Year","Installation Volume (#)","Inspection Year",{"$f":"IF(CF_Type=Annually,\"FY\"&RIGHT(J$3,2),TEXT(DATE(J$3,J$4,1),\"mmm-yyyy\"))","v":"FY26"},"FY27","FY28","FY29","FY30","FY31","FY32","FY33","FY34","FY35",{"$f":"$T$3","v":2036}]
[]
[null,null,null,{"$f":"'Input|Installations'!D39","v":"Inspection obligation starts after x years"},"Years","n/a",null,null,{"$f":"'Input|Installations'!$J$39","v":15}]
[null,null,null,{"$f":"'Input|Installations'!D40","v":"Inspection avoided if replacements done within x years"},"Years","n/a",null,null,1]
[]
[null,null,null,{"$f":"\"Inspection obligation - \"&G17&\" Installations\"","v":"Inspection obligation - 2010 Installations"},"# Meters","n/a",{"$f":"'Input|Installations'!F13","v":2010},{"$f":"'Input|Installations'!N13","v":28384.666666666664},{"$f":"G17+$I$14+1","v":2026},{"$f":"AND(J$3>=$I17,J$3<=$I17+$I$15-1)*$H17/$I$15","v":28384.666666666664},{"$f":"AND(K$3>=$I17,K$3<=$I17+$I$15-1)*$H17/$I$15","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"\"Inspection obligation - \"&G18&\" Installations\"","v":"Inspection obligation - 2011 Installations"},"# Meters","n/a",{"$f":"'Input|Installations'!F14","v":2011},{"$f":"'Input|Installations'!N14","v":36918.333333333328},{"$f":"G18+$I$14+1","v":2027},{"$f":"AND(J$3>=$I18,J$3<=$I18+$I$15-1)*$H18/$I$15","v":0},36918.333333333328,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspection obligation - 2012 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F15","v":2012},{"$f":"'Input|Installations'!N15","v":56660.5},2028,0,0,56660.5,0,0,0,0,0,0,0,0]
[null,null,null,"Inspection obligation - 2013 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F16","v":2013},{"$f":"'Input|Installations'!N16","v":89616.5},2029,0,0,0,89616.5,0,0,0,0,0,0,0]
[null,null,null,"Inspection obligation - 2014 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F17","v":2014},{"$f":"'Input|Installations'!N17","v":75332},2030,0,0,0,0,75332,0,0,0,0,0,0]
[null,null,null,"Inspection obligation - 2015 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F18","v":2015},{"$f":"'Input|Installations'!N18","v":22219.5},2031,0,0,0,0,0,22219.5,0,0,0,0,0]
[null,null,null,"Inspection obligation - 2016 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F19","v":2016},{"$f":"'Input|Installations'!N19","v":9423.5},2032,0,0,0,0,0,0,9423.5,0,0,0,0]
[null,null,null,"Inspection obligation - 2017 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F20","v":2017},{"$f":"'Input|Installations'!N20","v":9257},2033,0,0,0,0,0,0,0,9257,0,0,0]
[null,null,null,"Inspection obligation - 2018 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F21","v":2018},{"$f":"'Input|Installations'!N21","v":9249},2034,0,0,0,0,0,0,0,0,9249,0,0]
[null,null,null,"Inspection obligation - 2019 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F22","v":2019},{"$f":"'Input|Installations'!N22","v":9301.5},2035,0,0,0,0,0,0,0,0,0,9301.5,0]
[null,null,null,"Inspection obligation - 2020 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F23","v":2020},{"$f":"'Input|Installations'!N23","v":9343.5},2036,0,0,0,0,0,0,0,0,0,0,9343.5]
[null,null,null,"Inspection obligation - 2021 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F24","v":2021},{"$f":"'Input|Installations'!N24","v":8430},2037,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspection obligation - 2022 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F25","v":2022},{"$f":"'Input|Installations'!N25","v":9186},2038,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspection obligation - 2023 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F26","v":2023},{"$f":"'Input|Installations'!N26","v":9538},2039,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspection obligation - 2024 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F27","v":2024},{"$f":"'Input|Installations'!N27","v":8283},2040,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspection obligation - 2025 Installations","# Meters","n/a",{"$f":"'Input|Installations'!F28","v":2025},{"$f":"'Input|Installations'!N28","v":8983},2041,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Total inspection obligation","# Meters","n/a",null,null,null,{"$f":"SUM(J17:J32)","v":28384.666666666664},{"$f":"SUM(K17:K32)","v":36918.333333333328},56660.5,89616.5,75332,22219.5,9423.5,9257,9249,9301.5,9343.5]
[]
[null,null,null,"Smoothing adjustment","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Total smoothed inspection obligations","# Meters","n/a",null,null,null,{"$f":"J34+J36","v":28384.666666666664},{"$f":"K34+K36","v":36918.333333333328},56660.5,89616.5,75332,22219.5,9423.5,9257,9249,9301.5,9343.5]
[]
[null,null,null,"Less allowed replacements","# Meters","n/a",null,null,null,0,{"$f":"-'Output|Charts'!Q15","v":-1910.06},{"$f":"-'Output|Charts'!R15","v":-11460.359999999999},{"$f":"-'Output|Charts'!S15","v":-19100.599999999999},{"$f":"-'Output|Charts'!T15","v":-22920.719999999998},{"$f":"-'Output|Charts'!U15","v":-26740.84}]
[]
[null,null,null,"Outstanding Inspections","# Meters","n/a",null,null,null,{"$f":"MAX(0,J38+SUM(J40:J40))","v":28384.666666666664},35008.273333333331,45200.14,70515.899999999994,52411.28,0,9423.5,9257,9249,9301.5,9343.5]
[]
[null,null,null,"Cumulative outstanding inspections / replacements","# Meters","n/a",null,null,null,{"$f":"SUM($J42:J42)","v":28384.666666666664},{"$f":"SUM($J42:K42)","v":63392.939999999995},{"$f":"SUM($J42:L42)","v":108593.07999999999},{"$f":"SUM($J42:M42)","v":179108.97999999998},{"$f":"SUM($J42:N42)","v":231520.25999999998},{"$f":"SUM($J42:O42)","v":231520.25999999998},{"$f":"SUM($J42:P42)","v":240943.75999999998},{"$f":"SUM($J42:Q42)","v":250200.75999999998},{"$f":"SUM($J42:R42)","v":259449.75999999998},{"$f":"SUM($J42:S42)","v":268751.26},{"$f":"SUM($J42:T42)","v":278094.76}]
[]
[null,null,null,"Meters remaining in the field due for inspection / replacements","# Meters","n/a",null,null,null,{"$f":"SUMIF($I$17:$I$32,\"<=\"&J$3,$H$17:$H$32)+SUM($J40:J40)","v":28384.666666666664},{"$f":"SUMIF($I$17:$I$32,\"<=\"&K$3,$H$17:$H$32)+SUM($J40:K40)","v":63392.939999999995},{"$f":"SUMIF($I$17:$I$32,\"<=\"&L$3,$H$17:$H$32)+SUM($J40:L40)","v":108593.08},{"$f":"SUMIF($I$17:$I$32,\"<=\"&M$3,$H$17:$H$32)+SUM($J40:M40)","v":179108.98},{"$f":"SUMIF($I$17:$I$32,\"<=\"&N$3,$H$17:$H$32)+SUM($J40:N40)","v":231520.26},{"$f":"SUMIF($I$17:$I$32,\"<=\"&O$3,$H$17:$H$32)+SUM($J40:O40)","v":226998.92},{"$f":"SUMIF($I$17:$I$32,\"<=\"&P$3,$H$17:$H$32)+SUM($J40:P40)","v":236422.42},{"$f":"SUMIF($I$17:$I$32,\"<=\"&Q$3,$H$17:$H$32)+SUM($J40:Q40)","v":245679.42},{"$f":"SUMIF($I$17:$I$32,\"<=\"&R$3,$H$17:$H$32)+SUM($J40:R40)","v":254928.42},{"$f":"SUMIF($I$17:$I$32,\"<=\"&S$3,$H$17:$H$32)+SUM($J40:S40)","v":264229.92000000004},{"$f":"SUMIF($I$17:$I$32,\"<=\"&T$3,$H$17:$H$32)+SUM($J40:T40)","v":273573.42000000004}]
[]
[null,"Input | Allocation of annual replacements and inspections to meter installation year"]
[]
[null,null,null,"Summary",{"$f":"E$4","v":"Unit"},{"$f":"F$4","v":"Basis"},null,null,null,{"$f":"IF(CF_Type=Annually,\"FY\"&RIGHT(J$3,2),TEXT(DATE(J$3,J$4,1),\"mmm-yyyy\"))","v":"FY26"},"FY27","FY28","FY29","FY30","FY31","FY32","FY33","FY34","FY35",{"$f":"$T$3","v":2036}]
[]
[null,null,null,{"$f":"H12","v":"Installation Volume (#)"},"# Meters","n/a",null,null,null,{"$f":"TRANSPOSE(H17:H27)","v":28384.666666666664},36918.333333333328,56660.5,89616.5,75332,22219.5,9423.5,9257,9249,9301.5,9343.5]
[]
[null,null,null,"Less allowed replacements","# Meters","n/a",null,null,null,0,{"$f":"-'Output|Charts'!Q15","v":-1910.06},{"$f":"-'Output|Charts'!R15","v":-11460.359999999999},{"$f":"-'Output|Charts'!S15","v":-19100.599999999999},{"$f":"-'Output|Charts'!T15","v":-22920.719999999998},{"$f":"-'Output|Charts'!U15","v":-26740.84}]
[null,null,null,"Less allowed inspections","# Meters","n/a",null,null,null,0,{"$f":"-'Output|Charts'!Q38","v":-21079.973318887587},{"$f":"-'Output|Charts'!R38","v":-21260.031878305108},{"$f":"-'Output|Charts'!S38","v":-30674.763180874281},{"$f":"-'Output|Charts'!T38","v":-30657.710773435603},{"$f":"-'Output|Charts'!U38","v":-23453.10301464015}]
[]
[null,null,null,{"$f":"D44","v":"Cumulative outstanding inspections / replacements"},"# Meters","n/a",null,null,null,{"$f":"SUM($J52:J55)","v":28384.666666666664},{"$f":"SUM($J52:K55)","v":42312.966681112404},{"$f":"SUM($J52:L55)","v":66253.074802807314},{"$f":"SUM($J52:M55)","v":106094.21162193303},{"$f":"SUM($J52:N55)","v":127847.78084849744},{"$f":"SUM($J52:O55)","v":99873.337833857324},{"$f":"SUM($J52:P55)","v":109296.83783385735},{"$f":"SUM($J52:Q55)","v":118553.83783385735},{"$f":"SUM($J52:R55)","v":127802.83783385735},{"$f":"SUM($J52:S55)","v":137104.33783385731},{"$f":"SUM($J52:T55)","v":146447.83783385731}]
[]
[null,null,null,"Inspection Volumes - 2026-31 Regulatory Period",{"$f":"E$4","v":"Unit"},{"$f":"F$4","v":"Basis"},"Installation Year","Installation Volume (#)","Inspection Year",{"$f":"IF(CF_Type=Annually,\"FY\"&RIGHT(J$3,2),TEXT(DATE(J$3,J$4,1),\"mmm-yyyy\"))","v":"FY26"},"FY27","FY28","FY29","FY30","FY31","FY32","FY33","FY34","FY35",{"$f":"$T$3","v":2036}]
[]
[null,null,null,{"$f":"\"Opening Inspections Due - \"&I61","v":"Opening Inspections Due - 2026"},"# Meters","n/a",{"$f":"G17","v":2010},28384.666666666664,2026,{"$f":"IF(J$3=$I61,$H61,I137)","v":28384.666666666664},28384.666666666664,5394.6333477790758,0,0,0,0,0,0,0,0]
[null,null,null,"Opening Inspections Due - 2027","# Meters","n/a",2011,36918.333333333328,2027,0,36918.333333333328,36918.333333333328,9592.5748028072958,0,0,0,0,0,0,0]
[null,null,null,"Opening Inspections Due - 2028","# Meters","n/a",2012,56660.5,2028,0,0,56660.5,56660.5,16477.711621933013,0,0,0,0,0,0]
[null,null,null,"Opening Inspections Due - 2029","# Meters","n/a",2013,89616.5,2029,0,0,0,89616.5,89616.5,52515.780848497416,2321.8378338572657,2321.8378338572657,2321.8378338572657,2321.8378338572657,2321.8378338572657]
[null,null,null,"Opening Inspections Due - 2030","# Meters","n/a",2014,75332,2030,0,0,0,0,75332,75332,75332,75332,75332,75332,75332]
[null,null,null,"Opening Inspections Due - 2031","# Meters","n/a",2015,22219.5,2031,0,0,0,0,0,22219.5,22219.5,22219.5,22219.5,22219.5,22219.5]
[null,null,null,"Opening Inspections Due - 2032","# Meters","n/a",2016,9423.5,2032,0,0,0,0,0,0,9423.5,9423.5,9423.5,9423.5,9423.5]
[null,null,null,"Opening Inspections Due - 2033","# Meters","n/a",2017,9257,2033,0,0,0,0,0,0,0,9257,9257,9257,9257]
[null,null,null,"Opening Inspections Due - 2034","# Meters","n/a",2018,9249,2034,0,0,0,0,0,0,0,0,9249,9249,9249]
[null,null,null,"Opening Inspections Due - 2035","# Meters","n/a",2019,9301.5,2035,0,0,0,0,0,0,0,0,0,9301.5,9301.5]
[null,null,null,"Opening Inspections Due - 2036","# Meters","n/a",2020,9343.5,2036,0,0,0,0,0,0,0,0,0,0,9343.5]
[null,null,null,"Opening Inspections Due - 2037","# Meters","n/a",2021,8430,2037,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Opening Inspections Due - 2038","# Meters","n/a",2022,9186,2038,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Opening Inspections Due - 2039","# Meters","n/a",2023,9538,2039,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Opening Inspections Due - 2040","# Meters","n/a",2024,8283,2040,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Opening Inspections Due - 2041","# Meters","n/a",2025,8983,2041,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Total Opening Inspections Due","# Meters","n/a",null,null,null,{"$f":"SUM(J61:J76)","v":28384.666666666664},{"$f":"SUM(K61:K76)","v":65302.999999999993},98973.466681112404,155869.5748028073,181426.21162193301,150067.28084849741,109296.83783385727,118553.83783385727,127802.83783385727,137104.33783385728,146447.83783385728]
[]
[null,null,null,{"$f":"\"Inspections avoided due to replacements - \"&I61","v":"Inspections avoided due to replacements - 2026"},"# Meters","n/a",null,null,null,0,{"$f":"K54","v":-1910.06},{"$f":"-L61","v":-5394.6333477790758},0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2027","# Meters","n/a",null,null,null,0,0,{"$f":"L$54-L80","v":-6065.7266522209229},{"$f":"-M62","v":-9592.5748028072958},0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2028","# Meters","n/a",null,null,null,0,0,0,{"$f":"M$54-M81","v":-9508.0251971927028},{"$f":"-N63","v":-16477.711621933013},0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2029","# Meters","n/a",null,null,null,0,0,0,0,{"$f":"N$54-N82","v":-6443.0083780669847},{"$f":"O54","v":-26740.84},0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2030","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2031","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2032","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2033","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2034","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2035","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2036","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2037","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2038","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2039","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2040","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections avoided due to replacements - 2041","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Total inspections avoided due to replacements","# Meters","n/a",null,null,null,{"$f":"SUM(J80:J95)","v":0},{"$f":"SUM(K80:K95)","v":-1910.06},-11460.359999999999,-19100.599999999999,-22920.719999999998,-26740.84,0,0,0,0,0]
[]
[null,null,null,{"$f":"\"Interim Balance - Prior to inspections - \"&I61","v":"Interim Balance - Prior to inspections - 2026"},"# Meters","n/a",null,null,null,{"$f":"J61+J80","v":28384.666666666664},{"$f":"K61+K80","v":26474.606666666663},0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"\"Interim Balance - Prior to inspections - \"&I62","v":"Interim Balance - Prior to inspections - 2027"},"# Meters","n/a",null,null,null,{"$f":"J62+J81","v":0},36918.333333333328,30852.606681112404,0,0,0,0,0,0,0,0]
[null,null,null,"Interim Balance - Prior to inspections - 2028","# Meters","n/a",null,null,null,0,0,56660.5,47152.474802807294,0,0,0,0,0,0,0]
[null,null,null,"Interim Balance - Prior to inspections - 2029","# Meters","n/a",null,null,null,0,0,0,89616.5,83173.491621933019,25774.940848497416,2321.8378338572657,2321.8378338572657,2321.8378338572657,2321.8378338572657,2321.8378338572657]
[null,null,null,"Interim Balance - Prior to inspections - 2030","# Meters","n/a",null,null,null,0,0,0,0,75332,75332,75332,75332,75332,75332,75332]
[null,null,null,"Interim Balance - Prior to inspections - 2031","# Meters","n/a",null,null,null,0,0,0,0,0,22219.5,22219.5,22219.5,22219.5,22219.5,22219.5]
[null,null,null,"Interim Balance - Prior to inspections - 2032","# Meters","n/a",null,null,null,0,0,0,0,0,0,9423.5,9423.5,9423.5,9423.5,9423.5]
[null,null,null,"Interim Balance - Prior to inspections - 2033","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,9257,9257,9257,9257]
[null,null,null,"Interim Balance - Prior to inspections - 2034","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,9249,9249,9249]
[null,null,null,"Interim Balance - Prior to inspections - 2035","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,9301.5,9301.5]
[null,null,null,"Interim Balance - Prior to inspections - 2036","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,9343.5]
[null,null,null,"Interim Balance - Prior to inspections - 2037","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Interim Balance - Prior to inspections - 2038","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Interim Balance - Prior to inspections - 2039","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Interim Balance - Prior to inspections - 2040","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Interim Balance - Prior to inspections - 2041","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Total Interim Balance","# Meters","n/a",null,null,null,{"$f":"SUM(J99:J114)","v":28384.666666666664},{"$f":"SUM(K99:K114)","v":63392.939999999988},87513.106681112404,136768.97480280729,158505.491621933,123326.44084849741,109296.83783385727,118553.83783385727,127802.83783385727,137104.33783385728,146447.83783385728]
[]
[null,null,null,{"$f":"\"Inspections completed - \"&I61","v":"Inspections completed - 2026"},"# Meters","n/a",null,null,null,0,{"$f":"K55","v":-21079.973318887587},0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"\"Inspections completed - \"&I62","v":"Inspections completed - 2027"},"# Meters","n/a",null,null,null,0,0,{"$f":"L55","v":-21260.031878305108},{"$f":"-M62-M81","v":0},0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2028","# Meters","n/a",null,null,null,0,0,0,{"$f":"M55-M119","v":-30674.763180874281},{"$f":"-N63-N82","v":0},0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2029","# Meters","n/a",null,null,null,0,0,0,0,{"$f":"N55-N120","v":-30657.710773435603},{"$f":"O55","v":-23453.10301464015},0,0,0,0,0]
[null,null,null,"Inspections completed - 2030","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2031","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2032","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2033","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2034","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2035","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2036","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2037","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2038","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2039","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2040","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Inspections completed - 2041","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Total inspections completed","# Meters","n/a",null,null,null,{"$f":"SUM(J118:J133)","v":0},{"$f":"SUM(K118:K133)","v":-21079.973318887587},-21260.031878305108,-30674.763180874281,-30657.710773435603,-23453.10301464015,0,0,0,0,0]
[]
[null,null,null,{"$f":"\"Closing Inspections Due - \"&I61","v":"Closing Inspections Due - 2026"},"# Meters","n/a",null,null,null,{"$f":"J61+J80+J118","v":28384.666666666664},{"$f":"K61+K80+K118","v":5394.6333477790758},0,0,0,0,0,0,0,0,0]
[null,null,null,"Closing Inspections Due - 2027","# Meters","n/a",null,null,null,{"$f":"J62+J81+J119","v":0},36918.333333333328,9592.5748028072958,0,0,0,0,0,0,0,0]
[null,null,null,"Closing Inspections Due - 2028","# Meters","n/a",null,null,null,0,0,56660.5,16477.711621933013,0,0,0,0,0,0,0]
[null,null,null,"Closing Inspections Due - 2029","# Meters","n/a",null,null,null,0,0,0,89616.5,52515.780848497416,2321.8378338572657,2321.8378338572657,2321.8378338572657,2321.8378338572657,2321.8378338572657,2321.8378338572657]
[null,null,null,"Closing Inspections Due - 2030","# Meters","n/a",null,null,null,0,0,0,0,75332,75332,75332,75332,75332,75332,75332]
[null,null,null,"Closing Inspections Due - 2031","# Meters","n/a",null,null,null,0,0,0,0,0,22219.5,22219.5,22219.5,22219.5,22219.5,22219.5]
[null,null,null,"Closing Inspections Due - 2032","# Meters","n/a",null,null,null,0,0,0,0,0,0,9423.5,9423.5,9423.5,9423.5,9423.5]
[null,null,null,"Closing Inspections Due - 2033","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,9257,9257,9257,9257]
[null,null,null,"Closing Inspections Due - 2034","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,9249,9249,9249]
[null,null,null,"Closing Inspections Due - 2035","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,9301.5,9301.5]
[null,null,null,"Closing Inspections Due - 2036","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,9343.5]
[null,null,null,"Closing Inspections Due - 2037","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Closing Inspections Due - 2038","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Closing Inspections Due - 2039","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Closing Inspections Due - 2040","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Closing Inspections Due - 2041","# Meters","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Total Outstanding Inspections Due","# Meters","n/a",null,null,null,{"$f":"SUM(J137:J152)","v":28384.666666666664},{"$f":"SUM(K137:K152)","v":42312.966681112404},66253.074802807299,106094.21162193301,127847.78084849741,99873.337833857266,109296.83783385727,118553.83783385727,127802.83783385727,137104.33783385728,146447.83783385728]
[]
[{"$f":"IF(SUM(J156:T156)=0,0,1)","v":0},null,null,"Check - replacements","n/a","n/a",null,null,null,{"$f":"IF(ROUND(J97-J$54,3)=0,0,1)","v":0},{"$f":"IF(ROUND(K97-K$54,3)=0,0,1)","v":0},0,0,0,0,0,0,0,0,0]
[{"$f":"IF(SUM(J157:T157)=0,0,1)","v":0},null,null,"Check - inspections","n/a","n/a",null,null,null,{"$f":"IF(ROUND(J135-J$55,3)=0,0,1)","v":0},{"$f":"IF(ROUND(K135-K$55,3)=0,0,1)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,"Calculation | Inspection Delay and Meter Age"]
[]
[null,null,"Calculation | Chart Data - Inspection Delay"]
[]
[null,null,null,"Inspection Delay",{"$f":"E$4","v":"Unit"},{"$f":"F$4","v":"Basis"},null,null,null,{"$f":"IF(CF_Type=Annually,\"FY\"&RIGHT(J$3,2),TEXT(DATE(J$3,J$4,1),\"mmm-yyyy\"))","v":"FY26"},"FY27","FY28","FY29","FY30","FY31","FY32","FY33","FY34","FY35",{"$f":"$T$3","v":2036}]
[]
[null,null,null,{"$f":"\"Inspections - \"&I61","v":"Inspections - 2026"},{"$f":"Year","v":"year"},"n/a",null,null,null,1,{"$f":"J165+1","v":2},{"$f":"K165+1","v":3},4,5,6,7,8,9,10,11]
[null,null,null,{"$f":"\"Inspections - \"&I62","v":"Inspections - 2027"},"year","n/a",null,null,null,0,1,{"$f":"K166+1","v":2},3,4,5,6,7,8,9,10]
[null,null,null,"Inspections - 2028","year","n/a",null,null,null,0,0,1,{"$f":"L167+1","v":2},3,4,5,6,7,8,9]
[null,null,null,"Inspections - 2029","year","n/a",null,null,null,0,0,0,1,{"$f":"M168+1","v":2},3,4,5,6,7,8]
[null,null,null,"Inspections - 2030","year","n/a",null,null,null,0,0,0,0,1,{"$f":"N169+1","v":2},3,4,5,6,7]
[null,null,null,"Inspections - 2031","year","n/a",null,null,null,0,0,0,0,0,1,{"$f":"O170+1","v":2},3,4,5,6]
[null,null,null,"Inspections - 2032","year","n/a",null,null,null,0,0,0,0,0,0,1,{"$f":"P171+1","v":2},3,4,5]
[null,null,null,"Inspections - 2033","year","n/a",null,null,null,0,0,0,0,0,0,0,1,{"$f":"Q172+1","v":2},3,4]
[null,null,null,"Inspections - 2034","year","n/a",null,null,null,0,0,0,0,0,0,0,0,1,{"$f":"R173+1","v":2},3]
[null,null,null,"Inspections - 2035","year","n/a",null,null,null,0,0,0,0,0,0,0,0,0,1,{"$f":"S174+1","v":2}]
[null,null,null,"Inspections - 2036","year","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,1]
[null,null,null,"Inspections - 2037","year","n/a",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"End"]

{"sheet":"Output|Charts","index":5,"n_rows":253,"n_cols":38,"rows_kept":253,"cut":false,"hidden":false,"merged":[]}
[null,null,null,{"$f":"Model_Name","v":"Inspection and Replacement Obligation Volume Model"},null,null,null,null,null,null,null,null,"Section Check:",{"$f":"IF(COUNTA($A$7:$A$253)=COUNTIF($A$7:$A$253,0),\"Ok\",\"Check\")","v":"Ok"},null,"Overall Check:",{"$f":"Overall_Check","v":"Ok"},null,"Legend:","Input","Internal","Select","Calculation"]
[null,null,null,{"$f":"RIGHT(CELL(\"filename\",D1),LEN(CELL(\"filename\",D1))-FIND(\"]\",CELL(\"filename\",D1)))","v":"Output|Charts"},null,null,null,null,null,null,null,null,null,null,null,null,"Next Period",null,null,null,null,"Future Period"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2026,{"$f":"'Input|RP_Vol'!$K$3","v":2027},{"$f":"IF(CF_Type=Annually,Q3+1,IF(R4=1,Q3+1,Q3))","v":2028},2029,2030,2031,2032,2033,2034,2035,2036,2037]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Output | Summary by driver"]
[]
[null,null,"Output | Proactive Replacements by Scenario"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q$2","v":"Next Period"},null,null,null,null,{"$f":"V$2","v":"Future Period"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proactive Meter Replacements",{"$f":"\"FY\"&RIGHT(Q$3,2)","v":"FY27"},"FY28","FY29","FY30","FY31","FY32","FY33","FY34","FY35","FY36","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revised Proposal",{"$f":"'[1]Input|Vol&Costs'!N265","v":22284.399999999998},{"$f":"'[1]Input|Vol&Costs'!O265","v":29802},{"$f":"'[1]Input|Vol&Costs'!P265","v":34802.199999999997},{"$f":"'[1]Input|Vol&Costs'!Q265","v":37801.799999999996},{"$f":"'[1]Input|Vol&Costs'!R265","v":41664.19999999999},50038,48573,34710,28203,9260,{"$f":"SUM(Q13:Z13)","v":337138.6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adjusted AER DD",3032.7141418881151,18196.284851328688,30327.141418881154,36392.569702657376,42457.99798643362,{"$f":"V13/SUM($V$13:$Z$13)*$Q$22","v":41590.365296597323},{"$f":"W13/SUM($V$13:$Z$13)*$Q$22","v":40372.693024333938},{"$f":"X13/SUM($V$13:$Z$13)*$Q$22","v":28850.105508711244},{"$f":"Y13/SUM($V$13:$Z$13)*$Q$22","v":23441.64579839191},{"$f":"Z13/SUM($V$13:$Z$13)*$Q$22","v":7696.6861714395309},{"$f":"SUM(Q14:Z14)","v":272358.20390066289}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Initial Proposal",{"$f":"'[3]Input|Vol&Costs'!N282","v":1910.06},{"$f":"'[3]Input|Vol&Costs'!O282","v":11460.359999999999},{"$f":"'[3]Input|Vol&Costs'!P282","v":19100.599999999999},{"$f":"'[3]Input|Vol&Costs'!Q282","v":22920.719999999998},{"$f":"'[3]Input|Vol&Costs'!R282","v":26740.84},{"$f":"'[3]Input|Vol&Costs'!S282","v":18807.994297654135},{"$f":"'[3]Input|Vol&Costs'!T282","v":14454.866452733839},{"$f":"'[3]Input|Vol&Costs'!U282","v":5821.4874182899202},{"$f":"'[3]Input|Vol&Costs'!V282","v":3785.0615876097618},{"$f":"'[3]Input|Vol&Costs'!W282","v":3740.8669861663157},{"$f":"SUM(Q15:Z15)","v":128742.85674245397}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title:","Proactive Meter Replacements by Scenario"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y-axis:","Number of meters"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meter Population (FY31)",{"$f":"'[2]Input | Meters Vols & Costs'!U427","v":430156.04787719378}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Replacement Proportion",0.33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Replacements in 2031-36",{"$f":"Q20*Q21","v":141951.49579947395}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Output | Planned Meter Inspections by Scenario"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q$2","v":"Next Period"},null,null,null,null,{"$f":"V$2","v":"Future Period"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Planned Meter Inspections",{"$f":"\"FY\"&RIGHT(Q$3,2)","v":"FY27"},"FY28","FY29","FY30","FY31","FY32","FY33","FY34","FY35","FY36","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$P$13","v":"Revised Proposal"},{"$f":"'[1]Input|Vol&Costs'!N288","v":0},{"$f":"'[1]Input|Vol&Costs'!O288","v":0},{"$f":"'[1]Input|Vol&Costs'!P288","v":0},{"$f":"'[1]Input|Vol&Costs'!Q288","v":0},{"$f":"'[1]Input|Vol&Costs'!R288","v":0},{"$f":"'[1]Input|Vol&Costs'!S288","v":0},{"$f":"'[1]Input|Vol&Costs'!T288","v":0},{"$f":"'[1]Input|Vol&Costs'!U288","v":0},{"$f":"'[1]Input|Vol&Costs'!V288","v":0},{"$f":"'[1]Input|Vol&Costs'!W288","v":0},{"$f":"SUM(Q36:Z36)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$P$14","v":"Adjusted AER DD"},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q37:Z37)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$P$15","v":"Initial Proposal"},{"$f":"'[3]Input|Vol&Costs'!N283","v":21079.973318887587},{"$f":"'[3]Input|Vol&Costs'!O283","v":21260.031878305108},{"$f":"'[3]Input|Vol&Costs'!P283","v":30674.763180874281},{"$f":"'[3]Input|Vol&Costs'!Q283","v":30657.710773435603},{"$f":"'[3]Input|Vol&Costs'!R283","v":23453.10301464015},{"$f":"'[3]Input|Vol&Costs'!S283","v":24541.784691995872},{"$f":"'[3]Input|Vol&Costs'!T283","v":17747.451139841425},{"$f":"'[3]Input|Vol&Costs'!U283","v":4810.2591139985616},{"$f":"'[3]Input|Vol&Costs'!V283","v":2062.486117228158},{"$f":"'[3]Input|Vol&Costs'!W283","v":1892.5369570675693},{"$f":"SUM(Q38:Z38)","v":178180.10018627433}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title:","Planned Meter Inspections by Scenario"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y-axis:","Number of meters"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Output | Charts by option"]
[]
[null,null,{"$f":"\"Output | \"&$P$13","v":"Output | Revised Proposal"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q$2","v":"Next Period"},null,null,null,null,{"$f":"V$2","v":"Future Period"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"FY\"&RIGHT(Q$3,2)","v":"FY27"},"FY28","FY29","FY30","FY31","FY32","FY33","FY34","FY35","FY36","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$P$12","v":"Proactive Meter Replacements"},{"$f":"Q$13","v":22284.399999999998},{"$f":"R$13","v":29802},34802.199999999997,37801.799999999996,41664.19999999999,50038,48573,34710,28203,9260,{"$f":"SUM(Q61:Z61)","v":337138.6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Planned Meter Inspections",{"$f":"Q$36","v":0},{"$f":"R$36","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(Q62:Z62)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title:",{"$f":"$P$13","v":"Revised Proposal"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y-axis:","Number of meters"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q$2","v":"Next Period"},null,null,null,null,{"$f":"V$2","v":"Future Period"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P61","v":"Proactive Meter Replacements"},{"$f":"\"FY\"&RIGHT(Q$3,2)","v":"FY27"},"FY28","FY29","FY30","FY31","FY32","FY33","FY34","FY35","FY36"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2026-31:",{"$f":"Q61","v":22284.399999999998},{"$f":"R61","v":29802},{"$f":"S61","v":34802.199999999997},{"$f":"T61","v":37801.799999999996},{"$f":"U61","v":41664.19999999999},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2031-36:",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"V61","v":50038},{"$f":"W61","v":48573},{"$f":"X61","v":34710},{"$f":"Y61","v":28203},{"$f":"Z61","v":9260}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2026-31:",{"$f":"SUM(Q61:U61)","v":166354.59999999998},{"$f":"TEXT(Q85,\"0,000\")&\" replacements\"","v":"166,355 replacements"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2031-36:",{"$f":"SUM(V61:Z61)","v":170784},{"$f":"TEXT(Q86,\"0,000\")&\" replacements\"","v":"170,784 replacements"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"\"Output | \"&$P$14","v":"Output | Adjusted AER DD"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q$2","v":"Next Period"},null,null,null,null,{"$f":"V$2","v":"Future Period"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"FY\"&RIGHT(Q$3,2)","v":"FY27"},"FY28","FY29","FY30","FY31","FY32","FY33","FY34","FY35","FY36","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$P$12","v":"Proactive Meter Replacements"},{"$f":"Q$14","v":3032.7141418881151},{"$f":"R$14","v":18196.284851328688},30327.141418881154,36392.569702657376,42457.99798643362,41590.365296597323,40372.693024333938,28850.105508711244,23441.64579839191,7696.6861714395309,272358.20390066289]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Planned Meter Inspections",{"$f":"Q$37","v":0},{"$f":"R$37","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title:",{"$f":"$P$14","v":"Adjusted AER DD"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y-axis:","Number of meters"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"\"Output | \"&$P$15","v":"Output | Initial Proposal"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q$2","v":"Next Period"},null,null,null,null,{"$f":"V$2","v":"Future Period"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"FY\"&RIGHT(Q$3,2)","v":"FY27"},"FY28","FY29","FY30","FY31","FY32","FY33","FY34","FY35","FY36","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$P$12","v":"Proactive Meter Replacements"},{"$f":"Q$15","v":1910.06},{"$f":"R$15","v":11460.359999999999},19100.599999999999,22920.719999999998,26740.84,18807.994297654135,14454.866452733839,5821.4874182899202,3785.0615876097618,3740.8669861663157,128742.85674245397]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Planned Meter Inspections",{"$f":"Q$38","v":21079.973318887587},{"$f":"R$38","v":21260.031878305108},30674.763180874281,30657.710773435603,23453.10301464015,24541.784691995872,17747.451139841425,4810.2591139985616,2062.486117228158,1892.5369570675693,178180.10018627433]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title:",{"$f":"$P$15","v":"Initial Proposal"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y-axis:","Number of meters"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Output | Other charts"]
[]
[null,null,"Output | Total activity profiles"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q$2","v":"Next Period"},null,null,null,null,{"$f":"V$2","v":"Future Period"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"FY\"&RIGHT(Q$3,2)","v":"FY27"},"FY28","FY29","FY30","FY31","FY32","FY33","FY34","FY35","FY36"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revised Proposal",{"$f":"Q13+Q36","v":22284.399999999998},29802,34802.199999999997,37801.799999999996,41664.19999999999,50038,48573,34710,28203,9260]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adjusted Draft Decision",{"$f":"Q14+Q37","v":3032.7141418881151},18196.284851328688,30327.141418881154,36392.569702657376,42457.99798643362,41590.365296597323,40372.693024333938,28850.105508711244,23441.64579839191,7696.6861714395309]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Initial Proposal",{"$f":"Q15+Q38","v":22990.033318887588},32720.391878305105,49775.363180874279,53578.430773435597,50193.94301464015,43349.778989650003,32202.317592575266,10631.746532288482,5847.5477048379198,5633.403943233885]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title:","Total Activity: Proactive Replacements + Planned Inspections"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y-axis:","Number of meters"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"\"Output | \"&Q192","v":"Output | Annual balance of aged AMI meter inspection obligations volumes - impact of Revised Proposal on JEN's 2031-36 inspection obligations"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q$2","v":"Next Period"},null,null,null,null,{"$f":"V$2","v":"Future Period"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input|AER_DD_Vol'!K$59","v":"FY27"},{"$f":"'Input|AER_DD_Vol'!L$59","v":"FY28"},{"$f":"'Input|AER_DD_Vol'!M$59","v":"FY29"},{"$f":"'Input|AER_DD_Vol'!N$59","v":"FY30"},{"$f":"'Input|AER_DD_Vol'!O$59","v":"FY31"},{"$f":"'Input|AER_DD_Vol'!P$59","v":"FY32"},{"$f":"'Input|AER_DD_Vol'!Q$59","v":"FY33"},{"$f":"'Input|AER_DD_Vol'!R$59","v":"FY34"},{"$f":"'Input|AER_DD_Vol'!S$59","v":"FY35"},{"$f":"'Input|AER_DD_Vol'!T$59","v":"FY36"},"Criteria",null,{"$f":"Q175","v":"FY27"},{"$f":"R175","v":"FY28"},"FY29","FY30","FY31","FY32","FY33",{"$f":"X175","v":"FY34"},{"$f":"Y175","v":"FY35"},{"$f":"Z175","v":"FY36"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection delay - 0-5 yrs",{"$f":"SUM(Q181:Q185)","v":43018.599999999991},69877.099999999991,124691.4,162221.6,142776.90000000002,152200.40000000002,161457.40000000002,125481,59450.5,46574.5,null,null,{"$f":"IF(OR(Q176/SUM(Q$176:Q$179)=0,Q176/SUM(Q$176:Q$179)=1),\"\",Q176/SUM(Q$176:Q$179))","v":""},{"$f":"IF(OR(R176/SUM(R$176:R$179)=0,R176/SUM(R$176:R$179)=1),\"\",R176/SUM(R$176:R$179))","v":""},"","","","","",0.73506910109990009,0.33026606054512048,0.24596860651677249]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Inspection delay - \"&AA177&\" yrs\"","v":"Inspection delay - 6 yrs"},{"$f":"Q186","v":0},0,0,0,0,0,0,45225.400000000016,75332,22219.5,6,null,{"$f":"IF(OR(Q177/SUM(Q$176:Q$179)=0,Q177/SUM(Q$176:Q$179)=1),\"\",Q177/SUM(Q$176:Q$179))","v":""},{"$f":"IF(OR(R177/SUM(R$176:R$179)=0,R177/SUM(R$176:R$179)=1),\"\",R177/SUM(R$176:R$179))","v":""},"","","","","",0.26493089890009985,0.41849274392957192,0.11734531669689265]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Inspection delay - \"&AA178&\" yrs\"","v":"Inspection delay - 7 yrs"},{"$f":"Q187","v":0},0,0,0,0,0,0,0,45225.400000000016,75332,{"$f":"AA177+1","v":7},null,{"$f":"IF(OR(Q178/SUM(Q$176:Q$179)=0,Q178/SUM(Q$176:Q$179)=1),\"\",Q178/SUM(Q$176:Q$179))","v":""},"","","","","","","",0.25124119552530755,0.39784231856748875]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Inspection delay - \"&AA179&\" yrs\"","v":"Inspection delay - 8 yrs"},{"$f":"Q188","v":0},0,0,0,0,0,0,0,0,45225.400000000016,{"$f":"AA178+1","v":8},null,{"$f":"IF(OR(Q179/SUM(Q$176:Q$179)=0,Q179/SUM(Q$176:Q$179)=1),\"\",Q179/SUM(Q$176:Q$179))","v":""},"","","","","","","","",0.23884375821884607]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Inspection delay - \"&AA181&\" yr\"","v":"Inspection delay - 1 yr"},{"$f":"SUMPRODUCT(('Input|RP_Vol'!K$137:K$148)*('Input|RP_Vol'!K$165:K$176=$AA181))","v":36918.333333333328},{"$f":"SUMPRODUCT(('Input|RP_Vol'!L$137:L$148)*('Input|RP_Vol'!L$165:L$176=$AA181))","v":56660.5},{"$f":"SUMPRODUCT(('Input|RP_Vol'!M$137:M$148)*('Input|RP_Vol'!M$165:M$176=$AA181))","v":89616.5},{"$f":"SUMPRODUCT(('Input|RP_Vol'!N$137:N$148)*('Input|RP_Vol'!N$165:N$176=$AA181))","v":75332},{"$f":"SUMPRODUCT(('Input|RP_Vol'!O$137:O$148)*('Input|RP_Vol'!O$165:O$176=$AA181))","v":22219.5},{"$f":"SUMPRODUCT(('Input|RP_Vol'!P$137:P$148)*('Input|RP_Vol'!P$165:P$176=$AA181))","v":9423.5},{"$f":"SUMPRODUCT(('Input|RP_Vol'!Q$137:Q$148)*('Input|RP_Vol'!Q$165:Q$176=$AA181))","v":9257},{"$f":"SUMPRODUCT(('Input|RP_Vol'!R$137:R$148)*('Input|RP_Vol'!R$165:R$176=$AA181))","v":9249},{"$f":"SUMPRODUCT(('Input|RP_Vol'!S$137:S$148)*('Input|RP_Vol'!S$165:S$176=$AA181))","v":9301.5},{"$f":"SUMPRODUCT(('Input|RP_Vol'!T$137:T$148)*('Input|RP_Vol'!T$165:T$176=$AA181))","v":9343.5},1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Inspection delay - \"&AA182&\" yrs\"","v":"Inspection delay - 2 yrs"},{"$f":"SUMPRODUCT(('Input|RP_Vol'!K$137:K$148)*('Input|RP_Vol'!K$165:K$176=$AA182))","v":6100.2666666666664},{"$f":"SUMPRODUCT(('Input|RP_Vol'!L$137:L$148)*('Input|RP_Vol'!L$165:L$176=$AA182))","v":13216.599999999995},{"$f":"SUMPRODUCT(('Input|RP_Vol'!M$137:M$148)*('Input|RP_Vol'!M$165:M$176=$AA182))","v":35074.899999999994},{"$f":"SUMPRODUCT(('Input|RP_Vol'!N$137:N$148)*('Input|RP_Vol'!N$165:N$176=$AA182))","v":86889.600000000006},{"$f":"SUMPRODUCT(('Input|RP_Vol'!O$137:O$148)*('Input|RP_Vol'!O$165:O$176=$AA182))","v":75332},{"$f":"SUMPRODUCT(('Input|RP_Vol'!P$137:P$148)*('Input|RP_Vol'!P$165:P$176=$AA182))","v":22219.5},{"$f":"SUMPRODUCT(('Input|RP_Vol'!Q$137:Q$148)*('Input|RP_Vol'!Q$165:Q$176=$AA182))","v":9423.5},{"$f":"SUMPRODUCT(('Input|RP_Vol'!R$137:R$148)*('Input|RP_Vol'!R$165:R$176=$AA182))","v":9257},{"$f":"SUMPRODUCT(('Input|RP_Vol'!S$137:S$148)*('Input|RP_Vol'!S$165:S$176=$AA182))","v":9249},{"$f":"SUMPRODUCT(('Input|RP_Vol'!T$137:T$148)*('Input|RP_Vol'!T$165:T$176=$AA182))","v":9301.5},{"$f":"AA181+1","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Inspection delay - \"&AA183&\" yrs\"","v":"Inspection delay - 3 yrs"},{"$f":"SUMPRODUCT(('Input|RP_Vol'!K$137:K$148)*('Input|RP_Vol'!K$165:K$176=$AA183))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!L$137:L$148)*('Input|RP_Vol'!L$165:L$176=$AA183))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!M$137:M$148)*('Input|RP_Vol'!M$165:M$176=$AA183))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!N$137:N$148)*('Input|RP_Vol'!N$165:N$176=$AA183))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!O$137:O$148)*('Input|RP_Vol'!O$165:O$176=$AA183))","v":45225.400000000016},{"$f":"SUMPRODUCT(('Input|RP_Vol'!P$137:P$148)*('Input|RP_Vol'!P$165:P$176=$AA183))","v":75332},{"$f":"SUMPRODUCT(('Input|RP_Vol'!Q$137:Q$148)*('Input|RP_Vol'!Q$165:Q$176=$AA183))","v":22219.5},{"$f":"SUMPRODUCT(('Input|RP_Vol'!R$137:R$148)*('Input|RP_Vol'!R$165:R$176=$AA183))","v":9423.5},{"$f":"SUMPRODUCT(('Input|RP_Vol'!S$137:S$148)*('Input|RP_Vol'!S$165:S$176=$AA183))","v":9257},{"$f":"SUMPRODUCT(('Input|RP_Vol'!T$137:T$148)*('Input|RP_Vol'!T$165:T$176=$AA183))","v":9249},3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection delay - 4 yrs",{"$f":"SUMPRODUCT(('Input|RP_Vol'!K$137:K$148)*('Input|RP_Vol'!K$165:K$176=$AA184))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!L$137:L$148)*('Input|RP_Vol'!L$165:L$176=$AA184))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!M$137:M$148)*('Input|RP_Vol'!M$165:M$176=$AA184))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!N$137:N$148)*('Input|RP_Vol'!N$165:N$176=$AA184))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!O$137:O$148)*('Input|RP_Vol'!O$165:O$176=$AA184))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!P$137:P$148)*('Input|RP_Vol'!P$165:P$176=$AA184))","v":45225.400000000016},{"$f":"SUMPRODUCT(('Input|RP_Vol'!Q$137:Q$148)*('Input|RP_Vol'!Q$165:Q$176=$AA184))","v":75332},{"$f":"SUMPRODUCT(('Input|RP_Vol'!R$137:R$148)*('Input|RP_Vol'!R$165:R$176=$AA184))","v":22219.5},{"$f":"SUMPRODUCT(('Input|RP_Vol'!S$137:S$148)*('Input|RP_Vol'!S$165:S$176=$AA184))","v":9423.5},{"$f":"SUMPRODUCT(('Input|RP_Vol'!T$137:T$148)*('Input|RP_Vol'!T$165:T$176=$AA184))","v":9257},4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection delay - 5 yrs",{"$f":"SUMPRODUCT(('Input|RP_Vol'!K$137:K$148)*('Input|RP_Vol'!K$165:K$176=$AA185))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!L$137:L$148)*('Input|RP_Vol'!L$165:L$176=$AA185))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!M$137:M$148)*('Input|RP_Vol'!M$165:M$176=$AA185))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!N$137:N$148)*('Input|RP_Vol'!N$165:N$176=$AA185))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!O$137:O$148)*('Input|RP_Vol'!O$165:O$176=$AA185))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!P$137:P$148)*('Input|RP_Vol'!P$165:P$176=$AA185))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!Q$137:Q$148)*('Input|RP_Vol'!Q$165:Q$176=$AA185))","v":45225.400000000016},{"$f":"SUMPRODUCT(('Input|RP_Vol'!R$137:R$148)*('Input|RP_Vol'!R$165:R$176=$AA185))","v":75332},{"$f":"SUMPRODUCT(('Input|RP_Vol'!S$137:S$148)*('Input|RP_Vol'!S$165:S$176=$AA185))","v":22219.5},{"$f":"SUMPRODUCT(('Input|RP_Vol'!T$137:T$148)*('Input|RP_Vol'!T$165:T$176=$AA185))","v":9423.5},5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection delay - 6 yrs",{"$f":"SUMPRODUCT(('Input|RP_Vol'!K$137:K$148)*('Input|RP_Vol'!K$165:K$176=$AA186))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!L$137:L$148)*('Input|RP_Vol'!L$165:L$176=$AA186))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!M$137:M$148)*('Input|RP_Vol'!M$165:M$176=$AA186))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!N$137:N$148)*('Input|RP_Vol'!N$165:N$176=$AA186))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!O$137:O$148)*('Input|RP_Vol'!O$165:O$176=$AA186))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!P$137:P$148)*('Input|RP_Vol'!P$165:P$176=$AA186))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!Q$137:Q$148)*('Input|RP_Vol'!Q$165:Q$176=$AA186))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!R$137:R$148)*('Input|RP_Vol'!R$165:R$176=$AA186))","v":45225.400000000016},{"$f":"SUMPRODUCT(('Input|RP_Vol'!S$137:S$148)*('Input|RP_Vol'!S$165:S$176=$AA186))","v":75332},{"$f":"SUMPRODUCT(('Input|RP_Vol'!T$137:T$148)*('Input|RP_Vol'!T$165:T$176=$AA186))","v":22219.5},6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection delay - 7 yrs",{"$f":"SUMPRODUCT(('Input|RP_Vol'!K$137:K$148)*('Input|RP_Vol'!K$165:K$176=$AA187))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!L$137:L$148)*('Input|RP_Vol'!L$165:L$176=$AA187))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!M$137:M$148)*('Input|RP_Vol'!M$165:M$176=$AA187))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!N$137:N$148)*('Input|RP_Vol'!N$165:N$176=$AA187))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!O$137:O$148)*('Input|RP_Vol'!O$165:O$176=$AA187))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!P$137:P$148)*('Input|RP_Vol'!P$165:P$176=$AA187))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!Q$137:Q$148)*('Input|RP_Vol'!Q$165:Q$176=$AA187))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!R$137:R$148)*('Input|RP_Vol'!R$165:R$176=$AA187))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!S$137:S$148)*('Input|RP_Vol'!S$165:S$176=$AA187))","v":45225.400000000016},{"$f":"SUMPRODUCT(('Input|RP_Vol'!T$137:T$148)*('Input|RP_Vol'!T$165:T$176=$AA187))","v":75332},7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection delay - 8 yrs",{"$f":"SUMPRODUCT(('Input|RP_Vol'!K$137:K$148)*('Input|RP_Vol'!K$165:K$176=$AA188))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!L$137:L$148)*('Input|RP_Vol'!L$165:L$176=$AA188))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!M$137:M$148)*('Input|RP_Vol'!M$165:M$176=$AA188))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!N$137:N$148)*('Input|RP_Vol'!N$165:N$176=$AA188))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!O$137:O$148)*('Input|RP_Vol'!O$165:O$176=$AA188))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!P$137:P$148)*('Input|RP_Vol'!P$165:P$176=$AA188))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!Q$137:Q$148)*('Input|RP_Vol'!Q$165:Q$176=$AA188))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!R$137:R$148)*('Input|RP_Vol'!R$165:R$176=$AA188))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!S$137:S$148)*('Input|RP_Vol'!S$165:S$176=$AA188))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!T$137:T$148)*('Input|RP_Vol'!T$165:T$176=$AA188))","v":45225.400000000016},8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection delay - 9 yrs",{"$f":"SUMPRODUCT(('Input|RP_Vol'!K$137:K$148)*('Input|RP_Vol'!K$165:K$176=$AA189))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!L$137:L$148)*('Input|RP_Vol'!L$165:L$176=$AA189))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!M$137:M$148)*('Input|RP_Vol'!M$165:M$176=$AA189))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!N$137:N$148)*('Input|RP_Vol'!N$165:N$176=$AA189))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!O$137:O$148)*('Input|RP_Vol'!O$165:O$176=$AA189))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!P$137:P$148)*('Input|RP_Vol'!P$165:P$176=$AA189))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!Q$137:Q$148)*('Input|RP_Vol'!Q$165:Q$176=$AA189))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!R$137:R$148)*('Input|RP_Vol'!R$165:R$176=$AA189))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!S$137:S$148)*('Input|RP_Vol'!S$165:S$176=$AA189))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!T$137:T$148)*('Input|RP_Vol'!T$165:T$176=$AA189))","v":0},9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection delay - 10 yrs",{"$f":"SUMPRODUCT(('Input|RP_Vol'!K$137:K$148)*('Input|RP_Vol'!K$165:K$176=$AA190))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!L$137:L$148)*('Input|RP_Vol'!L$165:L$176=$AA190))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!M$137:M$148)*('Input|RP_Vol'!M$165:M$176=$AA190))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!N$137:N$148)*('Input|RP_Vol'!N$165:N$176=$AA190))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!O$137:O$148)*('Input|RP_Vol'!O$165:O$176=$AA190))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!P$137:P$148)*('Input|RP_Vol'!P$165:P$176=$AA190))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!Q$137:Q$148)*('Input|RP_Vol'!Q$165:Q$176=$AA190))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!R$137:R$148)*('Input|RP_Vol'!R$165:R$176=$AA190))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!S$137:S$148)*('Input|RP_Vol'!S$165:S$176=$AA190))","v":0},{"$f":"SUMPRODUCT(('Input|RP_Vol'!T$137:T$148)*('Input|RP_Vol'!T$165:T$176=$AA190))","v":0},10]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title:","Annual balance of aged AMI meter inspection obligations volumes - impact of Revised Proposal on JEN's 2031-36 inspection obligations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y-axis:","# of remaining inspections / replacements"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min replacements required to meet obligations:",{"$f":"SUM(Z186:Z190)","v":142776.90000000002},null,"Age profile of inspections due when planning 2031-36 inspections or replacements"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prudent replacements (Min + 50% of 0-5 years):",{"$f":"Q195+50%*SUM(Z181:Z185)","v":166064.15000000002}]
[]
[]
[null,null,{"$f":"\"Output | \"&Q219","v":"Output | Annual balance of aged AMI meter inspection obligations volumes - impact of AER Draft Decision on JEN's 2031-36 inspection obligations"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q$2","v":"Next Period"},null,null,null,null,{"$f":"V$2","v":"Future Period"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input|AER_DD_Vol'!K$59","v":"FY27"},{"$f":"'Input|AER_DD_Vol'!L$59","v":"FY28"},{"$f":"'Input|AER_DD_Vol'!M$59","v":"FY29"},{"$f":"'Input|AER_DD_Vol'!N$59","v":"FY30"},{"$f":"'Input|AER_DD_Vol'!O$59","v":"FY31"},{"$f":"'Input|AER_DD_Vol'!P$59","v":"FY32"},{"$f":"'Input|AER_DD_Vol'!Q$59","v":"FY33"},{"$f":"'Input|AER_DD_Vol'!R$59","v":"FY34"},{"$f":"'Input|AER_DD_Vol'!S$59","v":"FY35"},{"$f":"'Input|AER_DD_Vol'!T$59","v":"FY36"},"Criteria",null,{"$f":"Q202","v":"FY27"},"FY28","FY29","FY30","FY31","FY32","FY33","FY34","FY35","FY36"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection delay - 0-5 yrs",{"$f":"SUM(Q208:Q212)","v":62270.285858111878},100734.50100678319,160023.85958790203,198963.28988524465,178724.79189881103,188148.29189881103,197405.29189881103,125481,59450.5,46574.5,null,null,{"$f":"IF(OR(Q203/SUM(Q$203:Q$206)=0,Q203/SUM(Q$203:Q$206)=1),\"\",Q203/SUM(Q$203:Q$206))","v":""},{"$f":"IF(OR(R203/SUM(R$203:R$206)=0,R203/SUM(R$203:R$206)=1),\"\",R203/SUM(R$203:R$206))","v":""},"","","","","",0.60720248704750923,0.27529013914040484,0.20672279796120294]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Inspection delay - \"&AA204&\" yrs\"","v":"Inspection delay - 6 yrs"},{"$f":"Q213","v":0},0,0,0,0,0,0,81173.291898811032,75332,22219.5,6,null,{"$f":"IF(OR(Q204/SUM(Q$203:Q$206)=0,Q204/SUM(Q$203:Q$206)=1),\"\",Q204/SUM(Q$203:Q$206))","v":""},{"$f":"IF(OR(R204/SUM(R$203:R$206)=0,R204/SUM(R$203:R$206)=1),\"\",R204/SUM(R$203:R$206))","v":""},"","","","","",0.39279751295249077,0.34883065342974368,9.8622147512028011E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Inspection delay - \"&AA205&\" yrs\"","v":"Inspection delay - 7 yrs"},{"$f":"Q214","v":0},0,0,0,0,0,0,0,81173.291898811032,75332,{"$f":"AA204+1","v":7},null,{"$f":"IF(OR(Q205/SUM(Q$203:Q$206)=0,Q205/SUM(Q$203:Q$206)=1),\"\",Q205/SUM(Q$203:Q$206))","v":""},"","","","","","","",0.37587920742985148,0.33436412234191115]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Inspection delay - \"&AA206&\" yrs\"","v":"Inspection delay - 8 yrs"},{"$f":"Q215","v":0},0,0,0,0,0,0,0,0,81173.291898811032,{"$f":"AA205+1","v":8},null,{"$f":"IF(OR(Q206/SUM(Q$203:Q$206)=0,Q206/SUM(Q$203:Q$206)=1),\"\",Q206/SUM(Q$203:Q$206))","v":""},"","","","","","","","",0.36029093218485791]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Inspection delay - \"&AA208&\" yr\"","v":"Inspection delay - 1 yr"},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!K$137:K$148)*('Input|AER_DD_Vol'!K$165:K$176=$AA208))","v":36918.333333333328},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!L$137:L$148)*('Input|AER_DD_Vol'!L$165:L$176=$AA208))","v":56660.5},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!M$137:M$148)*('Input|AER_DD_Vol'!M$165:M$176=$AA208))","v":89616.5},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!N$137:N$148)*('Input|AER_DD_Vol'!N$165:N$176=$AA208))","v":75332},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!O$137:O$148)*('Input|AER_DD_Vol'!O$165:O$176=$AA208))","v":22219.5},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!P$137:P$148)*('Input|AER_DD_Vol'!P$165:P$176=$AA208))","v":9423.5},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!Q$137:Q$148)*('Input|AER_DD_Vol'!Q$165:Q$176=$AA208))","v":9257},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!R$137:R$148)*('Input|AER_DD_Vol'!R$165:R$176=$AA208))","v":9249},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!S$137:S$148)*('Input|AER_DD_Vol'!S$165:S$176=$AA208))","v":9301.5},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!T$137:T$148)*('Input|AER_DD_Vol'!T$165:T$176=$AA208))","v":9343.5},1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Inspection delay - \"&AA209&\" yrs\"","v":"Inspection delay - 2 yrs"},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!K$137:K$148)*('Input|AER_DD_Vol'!K$165:K$176=$AA209))","v":25351.95252477855},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!L$137:L$148)*('Input|AER_DD_Vol'!L$165:L$176=$AA209))","v":36918.333333333328},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!M$137:M$148)*('Input|AER_DD_Vol'!M$165:M$176=$AA209))","v":56660.5},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!N$137:N$148)*('Input|AER_DD_Vol'!N$165:N$176=$AA209))","v":89616.5},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!O$137:O$148)*('Input|AER_DD_Vol'!O$165:O$176=$AA209))","v":75332},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!P$137:P$148)*('Input|AER_DD_Vol'!P$165:P$176=$AA209))","v":22219.5},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!Q$137:Q$148)*('Input|AER_DD_Vol'!Q$165:Q$176=$AA209))","v":9423.5},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!R$137:R$148)*('Input|AER_DD_Vol'!R$165:R$176=$AA209))","v":9257},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!S$137:S$148)*('Input|AER_DD_Vol'!S$165:S$176=$AA209))","v":9249},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!T$137:T$148)*('Input|AER_DD_Vol'!T$165:T$176=$AA209))","v":9301.5},{"$f":"AA208+1","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection delay - 3 yrs",{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!K$137:K$148)*('Input|AER_DD_Vol'!K$165:K$176=$AA210))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!L$137:L$148)*('Input|AER_DD_Vol'!L$165:L$176=$AA210))","v":7155.6676734498615},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!M$137:M$148)*('Input|AER_DD_Vol'!M$165:M$176=$AA210))","v":13746.859587902036},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!N$137:N$148)*('Input|AER_DD_Vol'!N$165:N$176=$AA210))","v":34014.78988524466},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!O$137:O$148)*('Input|AER_DD_Vol'!O$165:O$176=$AA210))","v":81173.291898811032},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!P$137:P$148)*('Input|AER_DD_Vol'!P$165:P$176=$AA210))","v":75332},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!Q$137:Q$148)*('Input|AER_DD_Vol'!Q$165:Q$176=$AA210))","v":22219.5},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!R$137:R$148)*('Input|AER_DD_Vol'!R$165:R$176=$AA210))","v":9423.5},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!S$137:S$148)*('Input|AER_DD_Vol'!S$165:S$176=$AA210))","v":9257},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!T$137:T$148)*('Input|AER_DD_Vol'!T$165:T$176=$AA210))","v":9249},3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection delay - 4 yrs",{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!K$137:K$148)*('Input|AER_DD_Vol'!K$165:K$176=$AA211))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!L$137:L$148)*('Input|AER_DD_Vol'!L$165:L$176=$AA211))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!M$137:M$148)*('Input|AER_DD_Vol'!M$165:M$176=$AA211))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!N$137:N$148)*('Input|AER_DD_Vol'!N$165:N$176=$AA211))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!O$137:O$148)*('Input|AER_DD_Vol'!O$165:O$176=$AA211))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!P$137:P$148)*('Input|AER_DD_Vol'!P$165:P$176=$AA211))","v":81173.291898811032},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!Q$137:Q$148)*('Input|AER_DD_Vol'!Q$165:Q$176=$AA211))","v":75332},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!R$137:R$148)*('Input|AER_DD_Vol'!R$165:R$176=$AA211))","v":22219.5},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!S$137:S$148)*('Input|AER_DD_Vol'!S$165:S$176=$AA211))","v":9423.5},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!T$137:T$148)*('Input|AER_DD_Vol'!T$165:T$176=$AA211))","v":9257},4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection delay - 5 yrs",{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!K$137:K$148)*('Input|AER_DD_Vol'!K$165:K$176=$AA212))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!L$137:L$148)*('Input|AER_DD_Vol'!L$165:L$176=$AA212))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!M$137:M$148)*('Input|AER_DD_Vol'!M$165:M$176=$AA212))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!N$137:N$148)*('Input|AER_DD_Vol'!N$165:N$176=$AA212))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!O$137:O$148)*('Input|AER_DD_Vol'!O$165:O$176=$AA212))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!P$137:P$148)*('Input|AER_DD_Vol'!P$165:P$176=$AA212))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!Q$137:Q$148)*('Input|AER_DD_Vol'!Q$165:Q$176=$AA212))","v":81173.291898811032},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!R$137:R$148)*('Input|AER_DD_Vol'!R$165:R$176=$AA212))","v":75332},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!S$137:S$148)*('Input|AER_DD_Vol'!S$165:S$176=$AA212))","v":22219.5},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!T$137:T$148)*('Input|AER_DD_Vol'!T$165:T$176=$AA212))","v":9423.5},5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection delay - 6 yrs",{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!K$137:K$148)*('Input|AER_DD_Vol'!K$165:K$176=$AA213))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!L$137:L$148)*('Input|AER_DD_Vol'!L$165:L$176=$AA213))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!M$137:M$148)*('Input|AER_DD_Vol'!M$165:M$176=$AA213))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!N$137:N$148)*('Input|AER_DD_Vol'!N$165:N$176=$AA213))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!O$137:O$148)*('Input|AER_DD_Vol'!O$165:O$176=$AA213))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!P$137:P$148)*('Input|AER_DD_Vol'!P$165:P$176=$AA213))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!Q$137:Q$148)*('Input|AER_DD_Vol'!Q$165:Q$176=$AA213))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!R$137:R$148)*('Input|AER_DD_Vol'!R$165:R$176=$AA213))","v":81173.291898811032},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!S$137:S$148)*('Input|AER_DD_Vol'!S$165:S$176=$AA213))","v":75332},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!T$137:T$148)*('Input|AER_DD_Vol'!T$165:T$176=$AA213))","v":22219.5},6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection delay - 7 yrs",{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!K$137:K$148)*('Input|AER_DD_Vol'!K$165:K$176=$AA214))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!L$137:L$148)*('Input|AER_DD_Vol'!L$165:L$176=$AA214))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!M$137:M$148)*('Input|AER_DD_Vol'!M$165:M$176=$AA214))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!N$137:N$148)*('Input|AER_DD_Vol'!N$165:N$176=$AA214))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!O$137:O$148)*('Input|AER_DD_Vol'!O$165:O$176=$AA214))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!P$137:P$148)*('Input|AER_DD_Vol'!P$165:P$176=$AA214))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!Q$137:Q$148)*('Input|AER_DD_Vol'!Q$165:Q$176=$AA214))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!R$137:R$148)*('Input|AER_DD_Vol'!R$165:R$176=$AA214))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!S$137:S$148)*('Input|AER_DD_Vol'!S$165:S$176=$AA214))","v":81173.291898811032},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!T$137:T$148)*('Input|AER_DD_Vol'!T$165:T$176=$AA214))","v":75332},7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection delay - 8 yrs",{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!K$137:K$148)*('Input|AER_DD_Vol'!K$165:K$176=$AA215))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!L$137:L$148)*('Input|AER_DD_Vol'!L$165:L$176=$AA215))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!M$137:M$148)*('Input|AER_DD_Vol'!M$165:M$176=$AA215))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!N$137:N$148)*('Input|AER_DD_Vol'!N$165:N$176=$AA215))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!O$137:O$148)*('Input|AER_DD_Vol'!O$165:O$176=$AA215))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!P$137:P$148)*('Input|AER_DD_Vol'!P$165:P$176=$AA215))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!Q$137:Q$148)*('Input|AER_DD_Vol'!Q$165:Q$176=$AA215))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!R$137:R$148)*('Input|AER_DD_Vol'!R$165:R$176=$AA215))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!S$137:S$148)*('Input|AER_DD_Vol'!S$165:S$176=$AA215))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!T$137:T$148)*('Input|AER_DD_Vol'!T$165:T$176=$AA215))","v":81173.291898811032},8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection delay - 9 yrs",{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!K$137:K$148)*('Input|AER_DD_Vol'!K$165:K$176=$AA216))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!L$137:L$148)*('Input|AER_DD_Vol'!L$165:L$176=$AA216))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!M$137:M$148)*('Input|AER_DD_Vol'!M$165:M$176=$AA216))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!N$137:N$148)*('Input|AER_DD_Vol'!N$165:N$176=$AA216))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!O$137:O$148)*('Input|AER_DD_Vol'!O$165:O$176=$AA216))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!P$137:P$148)*('Input|AER_DD_Vol'!P$165:P$176=$AA216))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!Q$137:Q$148)*('Input|AER_DD_Vol'!Q$165:Q$176=$AA216))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!R$137:R$148)*('Input|AER_DD_Vol'!R$165:R$176=$AA216))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!S$137:S$148)*('Input|AER_DD_Vol'!S$165:S$176=$AA216))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!T$137:T$148)*('Input|AER_DD_Vol'!T$165:T$176=$AA216))","v":0},9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection delay - 10 yrs",{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!K$137:K$148)*('Input|AER_DD_Vol'!K$165:K$176=$AA217))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!L$137:L$148)*('Input|AER_DD_Vol'!L$165:L$176=$AA217))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!M$137:M$148)*('Input|AER_DD_Vol'!M$165:M$176=$AA217))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!N$137:N$148)*('Input|AER_DD_Vol'!N$165:N$176=$AA217))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!O$137:O$148)*('Input|AER_DD_Vol'!O$165:O$176=$AA217))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!P$137:P$148)*('Input|AER_DD_Vol'!P$165:P$176=$AA217))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!Q$137:Q$148)*('Input|AER_DD_Vol'!Q$165:Q$176=$AA217))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!R$137:R$148)*('Input|AER_DD_Vol'!R$165:R$176=$AA217))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!S$137:S$148)*('Input|AER_DD_Vol'!S$165:S$176=$AA217))","v":0},{"$f":"SUMPRODUCT(('Input|AER_DD_Vol'!T$137:T$148)*('Input|AER_DD_Vol'!T$165:T$176=$AA217))","v":0},10]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title:","Annual balance of aged AMI meter inspection obligations volumes - impact of AER Draft Decision on JEN's 2031-36 inspection obligations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y-axis:","# of remaining inspections / replacements"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min replacements required to meet obligations:",{"$f":"SUM(Z213:Z217)","v":178724.79189881103},null,{"$f":"$S$195","v":"Age profile of inspections due when planning 2031-36 inspections or replacements"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prudent replacements (Min + 50% of 0-5 years):",{"$f":"Q222+50%*SUM(Z208:Z212)","v":202012.04189881103}]
[]
[]
[null,null,{"$f":"\"Output | \"&Q246","v":"Output | Annual balance of aged AMI meter inspection obligations volumes - impact of Initial Proposal on JEN's 2031-36 inspection obligations"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q$2","v":"Next Period"},null,null,null,null,{"$f":"V$2","v":"Future Period"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input|AER_DD_Vol'!K$59","v":"FY27"},{"$f":"'Input|AER_DD_Vol'!L$59","v":"FY28"},{"$f":"'Input|AER_DD_Vol'!M$59","v":"FY29"},{"$f":"'Input|AER_DD_Vol'!N$59","v":"FY30"},{"$f":"'Input|AER_DD_Vol'!O$59","v":"FY31"},{"$f":"'Input|AER_DD_Vol'!P$59","v":"FY32"},{"$f":"'Input|AER_DD_Vol'!Q$59","v":"FY33"},{"$f":"'Input|AER_DD_Vol'!R$59","v":"FY34"},{"$f":"'Input|AER_DD_Vol'!S$59","v":"FY35"},{"$f":"'Input|AER_DD_Vol'!T$59","v":"FY36"},"Criteria",null,{"$f":"Q229","v":"FY27"},"FY28","FY29","FY30","FY31","FY32","FY33","FY34","FY35","FY36"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection delay - 0-5 yrs",{"$f":"SUM(Q235:Q239)","v":42312.966681112404},66253.074802807299,106094.21162193301,127847.78084849741,99873.337833857266,109296.83783385727,118553.83783385727,125481,59450.5,46574.5,null,null,{"$f":"IF(OR(Q230/SUM(Q$230:Q$233)=0,Q230/SUM(Q$230:Q$233)=1),\"\",Q230/SUM(Q$230:Q$233))","v":""},"","","","","","",0.98183265823192722,0.43361501860022822,0.31802791143176878]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Inspection delay - \"&AA231&\" yrs\"","v":"Inspection delay - 6 yrs"},{"$f":"Q240","v":0},0,0,0,0,0,0,2321.8378338572657,75332,22219.5,6,null,"","","","","","","",1.8167341768072769E-2,0.54945015737785874,0.15172296381191824]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Inspection delay - \"&AA232&\" yrs\"","v":"Inspection delay - 7 yrs"},{"$f":"Q241","v":0},0,0,0,0,0,0,0,2321.8378338572657,75332,{"$f":"AA231+1","v":7},null,"","","","","","","","",1.6934824021912882E-2,0.51439475730234363]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Inspection delay - \"&AA233&\" yrs\"","v":"Inspection delay - 8 yrs"},{"$f":"Q242","v":0},0,0,0,0,0,0,0,0,2321.8378338572657,{"$f":"AA232+1","v":8},null,"","","","","","","","","",1.5854367453969197E-2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Inspection delay - \"&AA235&\" yr\"","v":"Inspection delay - 1 yr"},{"$f":"SUMPRODUCT(('Input|IP_Vol'!K$137:K$148)*('Input|IP_Vol'!K$165:K$176=$AA235))","v":36918.333333333328},{"$f":"SUMPRODUCT(('Input|IP_Vol'!L$137:L$148)*('Input|IP_Vol'!L$165:L$176=$AA235))","v":56660.5},{"$f":"SUMPRODUCT(('Input|IP_Vol'!M$137:M$148)*('Input|IP_Vol'!M$165:M$176=$AA235))","v":89616.5},{"$f":"SUMPRODUCT(('Input|IP_Vol'!N$137:N$148)*('Input|IP_Vol'!N$165:N$176=$AA235))","v":75332},{"$f":"SUMPRODUCT(('Input|IP_Vol'!O$137:O$148)*('Input|IP_Vol'!O$165:O$176=$AA235))","v":22219.5},{"$f":"SUMPRODUCT(('Input|IP_Vol'!P$137:P$148)*('Input|IP_Vol'!P$165:P$176=$AA235))","v":9423.5},{"$f":"SUMPRODUCT(('Input|IP_Vol'!Q$137:Q$148)*('Input|IP_Vol'!Q$165:Q$176=$AA235))","v":9257},{"$f":"SUMPRODUCT(('Input|IP_Vol'!R$137:R$148)*('Input|IP_Vol'!R$165:R$176=$AA235))","v":9249},{"$f":"SUMPRODUCT(('Input|IP_Vol'!S$137:S$148)*('Input|IP_Vol'!S$165:S$176=$AA235))","v":9301.5},{"$f":"SUMPRODUCT(('Input|IP_Vol'!T$137:T$148)*('Input|IP_Vol'!T$165:T$176=$AA235))","v":9343.5},1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Inspection delay - \"&AA236&\" yrs\"","v":"Inspection delay - 2 yrs"},{"$f":"SUMPRODUCT(('Input|IP_Vol'!K$137:K$148)*('Input|IP_Vol'!K$165:K$176=$AA236))","v":5394.6333477790758},{"$f":"SUMPRODUCT(('Input|IP_Vol'!L$137:L$148)*('Input|IP_Vol'!L$165:L$176=$AA236))","v":9592.5748028072958},{"$f":"SUMPRODUCT(('Input|IP_Vol'!M$137:M$148)*('Input|IP_Vol'!M$165:M$176=$AA236))","v":16477.711621933013},{"$f":"SUMPRODUCT(('Input|IP_Vol'!N$137:N$148)*('Input|IP_Vol'!N$165:N$176=$AA236))","v":52515.780848497416},{"$f":"SUMPRODUCT(('Input|IP_Vol'!O$137:O$148)*('Input|IP_Vol'!O$165:O$176=$AA236))","v":75332},{"$f":"SUMPRODUCT(('Input|IP_Vol'!P$137:P$148)*('Input|IP_Vol'!P$165:P$176=$AA236))","v":22219.5},{"$f":"SUMPRODUCT(('Input|IP_Vol'!Q$137:Q$148)*('Input|IP_Vol'!Q$165:Q$176=$AA236))","v":9423.5},{"$f":"SUMPRODUCT(('Input|IP_Vol'!R$137:R$148)*('Input|IP_Vol'!R$165:R$176=$AA236))","v":9257},{"$f":"SUMPRODUCT(('Input|IP_Vol'!S$137:S$148)*('Input|IP_Vol'!S$165:S$176=$AA236))","v":9249},{"$f":"SUMPRODUCT(('Input|IP_Vol'!T$137:T$148)*('Input|IP_Vol'!T$165:T$176=$AA236))","v":9301.5},{"$f":"AA235+1","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Inspection delay - \"&AA237&\" yrs\"","v":"Inspection delay - 3 yrs"},{"$f":"SUMPRODUCT(('Input|IP_Vol'!K$137:K$148)*('Input|IP_Vol'!K$165:K$176=$AA237))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!L$137:L$148)*('Input|IP_Vol'!L$165:L$176=$AA237))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!M$137:M$148)*('Input|IP_Vol'!M$165:M$176=$AA237))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!N$137:N$148)*('Input|IP_Vol'!N$165:N$176=$AA237))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!O$137:O$148)*('Input|IP_Vol'!O$165:O$176=$AA237))","v":2321.8378338572657},{"$f":"SUMPRODUCT(('Input|IP_Vol'!P$137:P$148)*('Input|IP_Vol'!P$165:P$176=$AA237))","v":75332},{"$f":"SUMPRODUCT(('Input|IP_Vol'!Q$137:Q$148)*('Input|IP_Vol'!Q$165:Q$176=$AA237))","v":22219.5},{"$f":"SUMPRODUCT(('Input|IP_Vol'!R$137:R$148)*('Input|IP_Vol'!R$165:R$176=$AA237))","v":9423.5},{"$f":"SUMPRODUCT(('Input|IP_Vol'!S$137:S$148)*('Input|IP_Vol'!S$165:S$176=$AA237))","v":9257},{"$f":"SUMPRODUCT(('Input|IP_Vol'!T$137:T$148)*('Input|IP_Vol'!T$165:T$176=$AA237))","v":9249},3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection delay - 4 yrs",{"$f":"SUMPRODUCT(('Input|IP_Vol'!K$137:K$148)*('Input|IP_Vol'!K$165:K$176=$AA238))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!L$137:L$148)*('Input|IP_Vol'!L$165:L$176=$AA238))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!M$137:M$148)*('Input|IP_Vol'!M$165:M$176=$AA238))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!N$137:N$148)*('Input|IP_Vol'!N$165:N$176=$AA238))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!O$137:O$148)*('Input|IP_Vol'!O$165:O$176=$AA238))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!P$137:P$148)*('Input|IP_Vol'!P$165:P$176=$AA238))","v":2321.8378338572657},{"$f":"SUMPRODUCT(('Input|IP_Vol'!Q$137:Q$148)*('Input|IP_Vol'!Q$165:Q$176=$AA238))","v":75332},{"$f":"SUMPRODUCT(('Input|IP_Vol'!R$137:R$148)*('Input|IP_Vol'!R$165:R$176=$AA238))","v":22219.5},{"$f":"SUMPRODUCT(('Input|IP_Vol'!S$137:S$148)*('Input|IP_Vol'!S$165:S$176=$AA238))","v":9423.5},{"$f":"SUMPRODUCT(('Input|IP_Vol'!T$137:T$148)*('Input|IP_Vol'!T$165:T$176=$AA238))","v":9257},4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection delay - 5 yrs",{"$f":"SUMPRODUCT(('Input|IP_Vol'!K$137:K$148)*('Input|IP_Vol'!K$165:K$176=$AA239))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!L$137:L$148)*('Input|IP_Vol'!L$165:L$176=$AA239))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!M$137:M$148)*('Input|IP_Vol'!M$165:M$176=$AA239))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!N$137:N$148)*('Input|IP_Vol'!N$165:N$176=$AA239))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!O$137:O$148)*('Input|IP_Vol'!O$165:O$176=$AA239))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!P$137:P$148)*('Input|IP_Vol'!P$165:P$176=$AA239))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!Q$137:Q$148)*('Input|IP_Vol'!Q$165:Q$176=$AA239))","v":2321.8378338572657},{"$f":"SUMPRODUCT(('Input|IP_Vol'!R$137:R$148)*('Input|IP_Vol'!R$165:R$176=$AA239))","v":75332},{"$f":"SUMPRODUCT(('Input|IP_Vol'!S$137:S$148)*('Input|IP_Vol'!S$165:S$176=$AA239))","v":22219.5},{"$f":"SUMPRODUCT(('Input|IP_Vol'!T$137:T$148)*('Input|IP_Vol'!T$165:T$176=$AA239))","v":9423.5},5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection delay - 6 yrs",{"$f":"SUMPRODUCT(('Input|IP_Vol'!K$137:K$148)*('Input|IP_Vol'!K$165:K$176=$AA240))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!L$137:L$148)*('Input|IP_Vol'!L$165:L$176=$AA240))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!M$137:M$148)*('Input|IP_Vol'!M$165:M$176=$AA240))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!N$137:N$148)*('Input|IP_Vol'!N$165:N$176=$AA240))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!O$137:O$148)*('Input|IP_Vol'!O$165:O$176=$AA240))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!P$137:P$148)*('Input|IP_Vol'!P$165:P$176=$AA240))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!Q$137:Q$148)*('Input|IP_Vol'!Q$165:Q$176=$AA240))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!R$137:R$148)*('Input|IP_Vol'!R$165:R$176=$AA240))","v":2321.8378338572657},{"$f":"SUMPRODUCT(('Input|IP_Vol'!S$137:S$148)*('Input|IP_Vol'!S$165:S$176=$AA240))","v":75332},{"$f":"SUMPRODUCT(('Input|IP_Vol'!T$137:T$148)*('Input|IP_Vol'!T$165:T$176=$AA240))","v":22219.5},6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection delay - 7 yrs",{"$f":"SUMPRODUCT(('Input|IP_Vol'!K$137:K$148)*('Input|IP_Vol'!K$165:K$176=$AA241))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!L$137:L$148)*('Input|IP_Vol'!L$165:L$176=$AA241))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!M$137:M$148)*('Input|IP_Vol'!M$165:M$176=$AA241))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!N$137:N$148)*('Input|IP_Vol'!N$165:N$176=$AA241))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!O$137:O$148)*('Input|IP_Vol'!O$165:O$176=$AA241))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!P$137:P$148)*('Input|IP_Vol'!P$165:P$176=$AA241))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!Q$137:Q$148)*('Input|IP_Vol'!Q$165:Q$176=$AA241))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!R$137:R$148)*('Input|IP_Vol'!R$165:R$176=$AA241))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!S$137:S$148)*('Input|IP_Vol'!S$165:S$176=$AA241))","v":2321.8378338572657},{"$f":"SUMPRODUCT(('Input|IP_Vol'!T$137:T$148)*('Input|IP_Vol'!T$165:T$176=$AA241))","v":75332},7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection delay - 8 yrs",{"$f":"SUMPRODUCT(('Input|IP_Vol'!K$137:K$148)*('Input|IP_Vol'!K$165:K$176=$AA242))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!L$137:L$148)*('Input|IP_Vol'!L$165:L$176=$AA242))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!M$137:M$148)*('Input|IP_Vol'!M$165:M$176=$AA242))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!N$137:N$148)*('Input|IP_Vol'!N$165:N$176=$AA242))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!O$137:O$148)*('Input|IP_Vol'!O$165:O$176=$AA242))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!P$137:P$148)*('Input|IP_Vol'!P$165:P$176=$AA242))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!Q$137:Q$148)*('Input|IP_Vol'!Q$165:Q$176=$AA242))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!R$137:R$148)*('Input|IP_Vol'!R$165:R$176=$AA242))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!S$137:S$148)*('Input|IP_Vol'!S$165:S$176=$AA242))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!T$137:T$148)*('Input|IP_Vol'!T$165:T$176=$AA242))","v":2321.8378338572657},8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection delay - 9 yrs",{"$f":"SUMPRODUCT(('Input|IP_Vol'!K$137:K$148)*('Input|IP_Vol'!K$165:K$176=$AA243))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!L$137:L$148)*('Input|IP_Vol'!L$165:L$176=$AA243))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!M$137:M$148)*('Input|IP_Vol'!M$165:M$176=$AA243))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!N$137:N$148)*('Input|IP_Vol'!N$165:N$176=$AA243))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!O$137:O$148)*('Input|IP_Vol'!O$165:O$176=$AA243))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!P$137:P$148)*('Input|IP_Vol'!P$165:P$176=$AA243))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!Q$137:Q$148)*('Input|IP_Vol'!Q$165:Q$176=$AA243))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!R$137:R$148)*('Input|IP_Vol'!R$165:R$176=$AA243))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!S$137:S$148)*('Input|IP_Vol'!S$165:S$176=$AA243))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!T$137:T$148)*('Input|IP_Vol'!T$165:T$176=$AA243))","v":0},9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection delay - 10 yrs",{"$f":"SUMPRODUCT(('Input|IP_Vol'!K$137:K$148)*('Input|IP_Vol'!K$165:K$176=$AA244))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!L$137:L$148)*('Input|IP_Vol'!L$165:L$176=$AA244))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!M$137:M$148)*('Input|IP_Vol'!M$165:M$176=$AA244))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!N$137:N$148)*('Input|IP_Vol'!N$165:N$176=$AA244))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!O$137:O$148)*('Input|IP_Vol'!O$165:O$176=$AA244))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!P$137:P$148)*('Input|IP_Vol'!P$165:P$176=$AA244))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!Q$137:Q$148)*('Input|IP_Vol'!Q$165:Q$176=$AA244))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!R$137:R$148)*('Input|IP_Vol'!R$165:R$176=$AA244))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!S$137:S$148)*('Input|IP_Vol'!S$165:S$176=$AA244))","v":0},{"$f":"SUMPRODUCT(('Input|IP_Vol'!T$137:T$148)*('Input|IP_Vol'!T$165:T$176=$AA244))","v":0},10]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Title:","Annual balance of aged AMI meter inspection obligations volumes - impact of Initial Proposal on JEN's 2031-36 inspection obligations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y-axis:","# of remaining inspections / replacements"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min replacements required to meet obligations:",{"$f":"SUM(Z240:Z244)","v":99873.337833857266},null,{"$f":"$S$195","v":"Age profile of inspections due when planning 2031-36 inspections or replacements"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prudent replacements (Min + 50% of 0-5 years):",{"$f":"Q249+50%*SUM(Z235:Z239)","v":123160.58783385727}]
[]
[]
[null,"End"]

{"sheet":"Checklist","index":6,"n_rows":286,"n_cols":18,"rows_kept":286,"cut":false,"hidden":false,"merged":[[290,13,290,16],[291,14,291,17],[292,13,292,16],[293,13,293,16],[300,13,300,17],[301,13,301,17],[302,13,302,16],[294,13,294,17],[295,13,295,17],[296,13,296,14],[297,13,297,15],[298,13,298,17],[299,13,299,15]]}
[null,null,null,{"$f":"Model_Name","v":"Inspection and Replacement Obligation Volume Model"},null,null,null,"Section Check:",{"$f":"IF(COUNTA($A$7:$A$286)=COUNTIF($A$7:$A$286,0),\"Ok\",\"Check\")","v":"Ok"},null,"Overall Check:",{"$f":"Overall_Check","v":"Ok"},null,"Legend:","Input","Internal","Select","Calculation"]
[null,null,null,{"$f":"RIGHT(CELL(\"filename\",D1),LEN(CELL(\"filename\",D1))-FIND(\"]\",CELL(\"filename\",D1)))","v":"Checklist"}]
[]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Instructions"]
[]
[null,null,null,"Instructions:"]
[null,null,null,"This sheet is intended to help users locate the errors in each worksheet and to navigate to the error cells easily in order to fix the errors."]
[null,null,null,"This sheet links in all checks from all sheets in this model. The sheet name is shown in row 16 below."]
[null,null,null,"The RED dots indicate errors in a specific row of a worksheet. GREEN dots indicate no errors."]
[null,null,null,"Double click on the RED dots will take users to the row containing the error in each corresponding sheet"]
[]
[null,"Check List"]
[]
[null,null,null,"Sheet Name",null,{"$f":"TRANSPOSE(Home!C33:C37)","v":"Input|Installations"},"Input|RP_Vol","Input|AER_DD_Vol","Input|IP_Vol","Output|Charts"]
[]
[{"$f":"IF(COUNTIF(F19:O19,\"ERRORS\")>0,1,0)","v":0},null,null,"Are there errors in this sheet?",null,{"$f":"IF(IFERROR(SUM(F23:F284)<>0,TRUE),\"ERRORS\",\"NO ERRORS\")","v":"NO ERRORS"},"NO ERRORS","NO ERRORS","NO ERRORS","NO ERRORS","NO ERRORS","NO ERRORS","NO ERRORS","NO ERRORS","NO ERRORS"]
[]
[null,null,null,"What's the row number of the first error?",null,{"$f":"IF(F19=\"NO ERRORS\",NA,MATCH(TRUE,F23:F284>0,0)+ROW(F22))","v":"n/a"},{"$f":"IF(G19=\"NO ERRORS\",NA,MATCH(TRUE,G23:G284>0,0)+ROW(G22))","v":"n/a"},{"$f":"IF(H19=\"NO ERRORS\",NA,MATCH(TRUE,H23:H284>0,0)+ROW(H22))","v":"n/a"},{"$f":"IF(I19=\"NO ERRORS\",NA,MATCH(TRUE,I23:I284>0,0)+ROW(I22))","v":"n/a"},{"$f":"IF(J19=\"NO ERRORS\",NA,MATCH(TRUE,J23:J284>0,0)+ROW(J22))","v":"n/a"},{"$f":"IF(K19=\"NO ERRORS\",NA,MATCH(TRUE,K23:K284>0,0)+ROW(K22))","v":"n/a"},{"$f":"IF(L19=\"NO ERRORS\",NA,MATCH(TRUE,L23:L284>0,0)+ROW(L22))","v":"n/a"},{"$f":"IF(M19=\"NO ERRORS\",NA,MATCH(TRUE,M23:M284>0,0)+ROW(M22))","v":"n/a"},{"$f":"IF(N19=\"NO ERRORS\",NA,MATCH(TRUE,N23:N284>0,0)+ROW(N22))","v":"n/a"},{"$f":"IF(O19=\"NO ERRORS\",NA,MATCH(TRUE,O23:O284>0,0)+ROW(O22))","v":"n/a"}]
[]
[null,null,null,"Summary of checks:",null,{"$f":"IF('Input|Installations'!$N$1=\"Ok\",0,1)","v":0},{"$f":"IF('Input|RP_Vol'!$J$1=\"Ok\",0,1)","v":0},{"$f":"IF('Input|AER_DD_Vol'!$J$1=\"Ok\",0,1)","v":0},{"$f":"IF('Input|IP_Vol'!$J$1=\"Ok\",0,1)","v":0},{"$f":"IF('Output|Charts'!$N$1=\"Ok\",0,1)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"End"]

{"sheet":"Lookup","index":7,"n_rows":151,"n_cols":11,"rows_kept":151,"cut":false,"hidden":false,"merged":[[3,3,3,7],[5,1,5,3]]}
[]
[null,null,null,{"$f":"Model_Name","v":"Inspection and Replacement Obligation Volume Model"},null,null,null,null,null,"Overall check:",{"$f":"IF(COUNTA(Check_Status_List)=COUNTIF(Check_Status_List,\"Ok\"),\"Ok\",\"Check\")","v":"Ok"}]
[]
[null,null,null,{"$f":"RIGHT(CELL(\"filename\",D3),LEN(CELL(\"filename\",D3))-FIND(\"]\",CELL(\"filename\",D3)))","v":"Lookup"},{"$f":"RIGHT(CELL(\"filename\",E3),LEN(CELL(\"filename\",E3))-FIND(\"]\",CELL(\"filename\",E3)))","v":"Lookup"},{"$f":"RIGHT(CELL(\"filename\",F3),LEN(CELL(\"filename\",F3))-FIND(\"]\",CELL(\"filename\",F3)))","v":"Lookup"},{"$f":"RIGHT(CELL(\"filename\",G3),LEN(CELL(\"filename\",G3))-FIND(\"]\",CELL(\"filename\",G3)))","v":"Lookup"},{"$f":"RIGHT(CELL(\"filename\",H3),LEN(CELL(\"filename\",H3))-FIND(\"]\",CELL(\"filename\",H3)))","v":"Lookup"},null,"Section check:",{"$f":"IF(COUNTA($A$8:$A$151)=COUNTIF($A$8:$A$151,0),\"Ok\",\"Check\")","v":"Ok"}]
[]
[null,null,null,null," Copyright Jemena Limited. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Lookup Table"]
[]
[null,null,"Lookup List",null,null,null,"Ref."]
[]
[null,null,"Date Assumptions"]
[null,null,"Project Start Year",null,null,null,{"$f":"Start_Date","v":2024}]
[null,null,"Project Month",null,null,null,7]
[null,null,"Model Start Year",null,null,null,2024]
[null,null,"Assumption Lookup Index",null,null,null,{"$f":"Start_Year-G15","v":0}]
[]
[null,null,"Financial unit denomination"]
[null,null,"Dollars",null,null,null,"$dollars"]
[null,null,"Thousands",null,null,null,"$000"]
[null,null,"Millions",null,null,null,"$millions"]
[null,null,"Chosen Unit",null,null,null,{"$f":"INDEX(G20:G21,MATCH(Home!$E$22,C20:C21,0))","v":"$millions"}]
[]
[null,null,"Non-financial unit denomination"]
[null,null,"Percent",null,null,null,"Per cent"]
[null,null,"Unit",null,null,null,"unit"]
[null,null,"Number",null,null,null,"Number"]
[null,null,"Factor",null,null,null,"Factor"]
[null,null,"Index",null,null,null,"Index"]
[null,null,"Elec Energy  - Kilowatts/hr",null,null,null,"kWh"]
[null,null,"Elec Energy  - Gigawatts/hr",null,null,null,"GWh"]
[null,null,"Elec Energy - Megawatts/hr",null,null,null,"MWh"]
[null,null,"Elec Energy - Megawatts",null,null,null,"MW"]
[null,null,"Elec Energy  - Kilowatts",null,null,null,"kW"]
[null,null,"Elec Energy - Kilovolt amps",null,null,null,"kVa"]
[null,null,"Gas Energy - Petajoules",null,null,null,"PJ"]
[null,null,"Gas Energy - Terajoules",null,null,null,"TJ"]
[null,null,"Gas Energy - Gigajoules",null,null,null,"GJ"]
[null,null,"Mains",null,null,null,"mains"]
[null,null,"Kilometres",null,null,null,"kms"]
[null,null,"Metres",null,null,null,"metres"]
[]
[null,null,"Periodicity"]
[null,null,"Actuals",null,null,null,"Actual"]
[null,null,"Forecast",null,null,null,"Fcast"]
[null,null,"Date",null,null,null,"date"]
[null,null,"Month",null,null,null,"month"]
[null,null,"Quarter",null,null,null,"quarter"]
[null,null,"Year",null,null,null,"year"]
[null,null,"Option",null,null,null,"Option"]
[null,null,"Yes/No",null,null,null,"yes/no"]
[null,null,"Actuals/Forecast",null,null,null,"(A)/(F)"]
[]
[null,null,"Time intervals"]
[null,null,"Number of months in a year",null,null,null,12]
[null,null,"Number of days in a year",null,null,null,365]
[null,null,"Number of weeks in a year",null,null,null,52]
[]
[null,null,"Cash flow timing"]
[null,null,"Start-year",null,null,null,-0.5]
[null,null,"Mid-year",null,null,null,0]
[null,null,"End-year",null,null,null,0.5]
[null,null,"Start-Month",null,null,null,-0.5]
[null,null,"Mid-Month",null,null,null,0]
[null,null,"End-Month",null,null,null,0.5]
[]
[null,null,"Yes/No",null,null,null,"[Select]"]
[null,null,"Yes",null,null,null,"Yes"]
[null,null,"No",null,null,null,"No"]
[]
[null,null,"Assets (short)"]
[null,null,"[Select Asset]",null,null,null,{"$f":"C72","v":"[Select Asset]"}]
[null,null,"JEN",null,null,null,{"$f":"C73","v":"JEN"}]
[null,null,"JGN",null,null,null,{"$f":"C74","v":"JGN"}]
[null,null,"Shared",null,null,null,{"$f":"C75","v":"Shared"}]
[]
[null,null,"Assets (long)"]
[null,null,"Jemena Gas Networks",null,null,null,"JGN"]
[null,null,"Jemena Electricity Networks",null,null,null,"JEN"]
[]
[null,null,"Asset classes"]
[null,null,"[Select appropriate asset class]"]
[null,null,"[Select JGN Asset Class]"]
[null,null,"JGN - Trunk & HP Mains"]
[null,null,"JGN - Meters & Meter Reading Devices"]
[null,null,"JGN - Fixed Plant (Distribution) & Country POTS "]
[null,null,"JGN - MP Mains & Services, HP Services"]
[null,null,"JGN - Computers (IT infrastructure)"]
[null,null,"JGN - Fixed Plant & Furniture"]
[null,null,"JGN - Land"]
[null,null,"JGN - Low value assets & Mobile Plant"]
[null,null,"JGN - Vehicles"]
[null,null,"JGN - Leasehold Improvements"]
[null,null,"JGN - Building"]
[null,null,"JGN - Inhouse Software"]
[null,null,"[Select JEN Asset Class]"]
[null,null,"JEN SCS - Subtransmission"]
[null,null,"JEN SCS - Distribution system assets"]
[null,null,"JEN SCS - SCADA/Network control"]
[null,null,"JEN SCS - Non network - IT (Infrastructure)"]
[null,null,"JEN SCS - Non network - other"]
[null,null,"JEN SCS - Land"]
[null,null,"JEN SCS - Building"]
[null,null,"JEN SCS - Inhouse Software"]
[null,null,"JEN AMI - Remotely read interval meters & transformers"]
[null,null,"JEN AMI - Communications"]
[null,null,"JEN AMI - IT"]
[null,null,"JEN AMI - Other"]
[null,null,"JEN AMI - Inhouse Software"]
[]
[null,null,"Number of Options",null,null,null,"Option no.",null,"Option full name"]
[null,null,"[select option]",null,null,null,"[select]",null,"[select option]"]
[null,null,{"$f":"\"Option \"&G113","v":"Option 1"},null,null,null,1,null,"[select option]"]
[null,null,{"$f":"IF(No_of_Options<G114,NA,\"Option \"&G114)","v":"Option 2"},null,null,null,{"$f":"G113+1","v":2},null,"[select option]"]
[null,null,"Option 3",null,null,null,3,null,"[select option]"]
[null,null,"n/a",null,null,null,4,null,"[select option]"]
[null,null,"n/a",null,null,null,5,null,"[select option]"]
[null,null,"n/a",null,null,null,6,null,"[select option]"]
[null,null,"n/a",null,null,null,7,null,"[select option]"]
[]
[null,null,"Cashflow Type"]
[null,null,"Annual",null,null,null,{"$f":"C122","v":"Annual"}]
[null,null,"Monthly",null,null,null,{"$f":"C123","v":"Monthly"}]
[]
[null,null,"Tax Depreciation Method"]
[null,null,"Straight-line depreciation",null,null,null,"SL"]
[null,null,"Diminishing value depreciation",null,null,null,"DV"]
[null,null,"Not applicable",null,null,null,{"$f":"NA","v":"n/a"}]
[]
[null,null,"Nature of costs (Opex)"]
[null,null,"[Select from list]",null,null,null,{"$f":"C131","v":"[Select from list]"}]
[null,null,"Ongoing",null,null,null,{"$f":"C132","v":"Ongoing"}]
[null,null,"Project cost (one-off)",null,null,null,{"$f":"C133","v":"Project cost (one-off)"}]
[]
[null,null,"Type of Economic Benefit"]
[null,null,"[Select from list]",null,null,null,{"$f":"C136","v":"[Select from list]"}]
[null,null,"Avoided cost at asset failure",null,null,null,"Avoided cost at asset failure"]
[null,null,"Improved energy reliability",null,null,null,"Improved energy reliability"]
[null,null,"Reduced energy losses",null,null,null,"Reduced energy losses"]
[null,null,"Increase in DER exports",null,null,null,"Increase in DER exports"]
[null,null,"Other Economic Benefits",null,null,null,"Other Economic Benefits"]
[]
[null,null,"Dollar base"]
[null,null,"Nominal",null,null,null,"Nominal"]
[null,null,"Real",null,null,null,"Real"]
[]
[null,null,"Nominal",null,null,null,{"$f":"Nominal","v":"Nominal"}]
[null,null,"Real",null,null,null,{"$f":"Real&\" \"&Start_Year","v":"Real 2024"}]
[null,null,"Not applicable",null,null,null,"n/a"]
[]
[null,"End"]