{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["1. Cost of Service_parameters","2. MIST Meters Assets_Rate Base","3. UCC_Calculations","4. Fund Adder Revenues","5. MIST Meters_IRR","6. True-up Summary"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":266,"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":"1. Cost of Service_parameters","index":0,"n_rows":114,"n_cols":31,"rows_kept":114,"cut":false,"hidden":false,"merged":[[3,3,3,4]]}
[]
[]
[]
[null,null,null,"MIST Meters True-up Model"]
[]
[]
[]
[]
[null,"Sheet 1: Parameters and Rates"]
[]
[null,null,null,null,null,null,2014,null,2015,null,2016,null,2017,null,2018,null,2019,null,2020,null,2021,null,2022,null,2023,null,2024,null,2025,null,2026]
[null,"Cost of Capital"]
[null,null,"Capital Structure"]
[null,null,null,"Deemed Short-term Debt Capitalization",null,null,0.04,null,0.04,null,0.04,null,0.04,null,0.04,null,0.04,null,0.04,null,0.04,null,0.04,null,0.04,null,0.04,null,0.04,null,0.04]
[null,null,null,"Deemed Long-term Debt Capitalization",null,null,{"$f":"60%-G14","v":0.55999999999999994},null,{"$f":"G15-(I14-G14)","v":0.55999999999999994},null,{"$f":"I15-(K14-I14)","v":0.55999999999999994},null,{"$f":"K15-(M14-K14)","v":0.55999999999999994},null,{"$f":"M15-(O14-M14)","v":0.55999999999999994},null,{"$f":"O15-(Q14-O14)","v":0.55999999999999994},null,{"$f":"Q15-(S14-Q14)","v":0.55999999999999994},null,{"$f":"S15-(U14-S14)","v":0.55999999999999994},null,{"$f":"U15-(W14-U14)","v":0.55999999999999994},null,{"$f":"W15-(Y14-W14)","v":0.55999999999999994},null,{"$f":"Y15-(AA14-Y14)","v":0.55999999999999994},null,{"$f":"AA15-(AC14-AA14)","v":0.55999999999999994},null,{"$f":"AC15-(AE14-AC14)","v":0.55999999999999994}]
[null,null,null,"Deemed Equity Capitalization",null,null,{"$f":"100%-G15-G17-G14","v":0.40000000000000008},null,{"$f":"100%-I15-I17-I14","v":0.40000000000000008},null,{"$f":"100%-K15-K17-K14","v":0.40000000000000008},null,{"$f":"100%-M15-M17-M14","v":0.40000000000000008},null,{"$f":"100%-O15-O17-O14","v":0.40000000000000008},null,{"$f":"100%-Q15-Q17-Q14","v":0.40000000000000008},null,{"$f":"100%-S15-S17-S14","v":0.40000000000000008},null,{"$f":"100%-U15-U17-U14","v":0.40000000000000008},null,{"$f":"100%-W15-W17-W14","v":0.40000000000000008},null,{"$f":"100%-Y15-Y17-Y14","v":0.40000000000000008},null,{"$f":"100%-AA15-AA17-AA14","v":0.40000000000000008},null,{"$f":"100%-AC15-AC17-AC14","v":0.40000000000000008},null,{"$f":"100%-AE15-AE17-AE14","v":0.40000000000000008}]
[null,null,null,"Preferred Shares"]
[null,null,"Total",null,null,null,{"$f":"SUM(G14:G17)","v":1},null,{"$f":"SUM(I14:I17)","v":1},null,{"$f":"SUM(K14:K17)","v":1},null,{"$f":"SUM(M14:M17)","v":1},null,{"$f":"SUM(O14:O17)","v":1},null,{"$f":"SUM(Q14:Q17)","v":1},null,{"$f":"SUM(S14:S17)","v":1},null,{"$f":"SUM(U14:U17)","v":1},null,{"$f":"SUM(W14:W17)","v":1},null,{"$f":"SUM(Y14:Y17)","v":1},null,{"$f":"SUM(AA14:AA17)","v":1},null,{"$f":"SUM(AC14:AC17)","v":1},null,{"$f":"SUM(AE14:AE17)","v":1}]
[]
[null,null,"Cost of Capital Parameters"]
[null,null,null,"Deemed Short-term Debt Rate",null,null,2.0799999999999999E-2,null,2.0799999999999999E-2,null,2.0799999999999999E-2,null,2.0799999999999999E-2,null,2.0799999999999999E-2,null,2.0799999999999999E-2,null,2.0799999999999999E-2,null,2.0799999999999999E-2,null,2.0799999999999999E-2,null,2.0799999999999999E-2,null,2.0799999999999999E-2,null,2.0799999999999999E-2,null,2.0799999999999999E-2]
[null,null,null,"Long-term Debt Rate (actual/embedded/deemed)1",null,null,5.0914000000000001E-2,null,5.0914000000000001E-2,null,5.0914000000000001E-2,null,5.0914000000000001E-2,null,5.0914000000000001E-2,null,5.0914000000000001E-2,null,5.0914000000000001E-2,null,5.0914000000000001E-2,null,5.0914000000000001E-2,null,5.0914000000000001E-2,null,5.0914000000000001E-2,null,5.0914000000000001E-2,null,5.0914000000000001E-2]
[null,null,null,"Target Return on Equity (ROE)",null,null,8.9300000000000004E-2,null,8.9300000000000004E-2,null,8.9300000000000004E-2,null,8.9300000000000004E-2,null,8.9300000000000004E-2,null,8.9300000000000004E-2,null,8.9300000000000004E-2,null,8.9300000000000004E-2,null,8.9300000000000004E-2,null,8.9300000000000004E-2,null,8.9300000000000004E-2,null,8.9300000000000004E-2,null,8.9300000000000004E-2]
[null,null,null,"Return on Preferred Shares"]
[null,null,"WACC",null,null,null,{"$f":"SUMPRODUCT(G14:G17,G21:G24)","v":6.5063840000000012E-2},null,{"$f":"SUMPRODUCT(I14:I17,I21:I24)","v":6.5063840000000012E-2},null,{"$f":"SUMPRODUCT(K14:K17,K21:K24)","v":6.5063840000000012E-2},null,{"$f":"SUMPRODUCT(M14:M17,M21:M24)","v":6.5063840000000012E-2},null,{"$f":"SUMPRODUCT(O14:O17,O21:O24)","v":6.5063840000000012E-2},null,{"$f":"SUMPRODUCT(Q14:Q17,Q21:Q24)","v":6.5063840000000012E-2},null,{"$f":"SUMPRODUCT(S14:S17,S21:S24)","v":6.5063840000000012E-2},null,{"$f":"SUMPRODUCT(U14:U17,U21:U24)","v":6.5063840000000012E-2},null,{"$f":"SUMPRODUCT(W14:W17,W21:W24)","v":6.5063840000000012E-2},null,{"$f":"SUMPRODUCT(Y14:Y17,Y21:Y24)","v":6.5063840000000012E-2},null,{"$f":"SUMPRODUCT(AA14:AA17,AA21:AA24)","v":6.5063840000000012E-2},null,{"$f":"SUMPRODUCT(AC14:AC17,AC21:AC24)","v":6.5063840000000012E-2},null,{"$f":"SUMPRODUCT(AE14:AE17,AE21:AE24)","v":6.5063840000000012E-2}]
[]
[null,"Working Capital Allowance"]
[null,null,"Working Capital Allowance Rate",null,null,null,0.13500000000000001,null,0.13500000000000001,null,0.13500000000000001,null,0.13500000000000001,null,0.13500000000000001,null,0.13500000000000001,null,0.13500000000000001,null,0.13500000000000001,null,0.13500000000000001,null,0.13500000000000001,null,0.13500000000000001,null,0.13500000000000001,null,0.13500000000000001]
[null,null,"(% of the sum of Cost of Power + controllable expenses)"]
[]
[null,"Taxes/PILs"]
[null,null,"Aggregate Corporate Income Tax Rate",null,null,null,0.26500000000000001,null,0.26500000000000001,null,0.26500000000000001,null,0.26500000000000001,null,0.26500000000000001,null,0.26500000000000001,null,0.26500000000000001,null,0.26500000000000001,null,0.26500000000000001,null,0.26500000000000001,null,0.26500000000000001,null,0.26500000000000001,null,0.26500000000000001]
[null,null,"Capital Tax (until July 1st, 2010)",null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[]
[null,"Depreciation Rates",null,null,"Account"]
[null,"(expressed as expected useful life in years)"]
[]
[null,null,null,"Year",1822,null,20,null,20,null,20,null,20,null,20,null,20,null,20,null,20,null,20,null,20,null,20,null,20,null,20]
[null,null,"                              - rate (%)","Rate (%)",null,null,{"$f":"IF(G38=0,0,1/G38)","v":0.05},null,{"$f":"IF(I38=0,0,1/I38)","v":0.05},null,{"$f":"IF(K38=0,0,1/K38)","v":0.05},null,{"$f":"IF(M38=0,0,1/M38)","v":0.05},null,{"$f":"IF(O38=0,0,1/O38)","v":0.05},null,{"$f":"IF(Q38=0,0,1/Q38)","v":0.05},null,{"$f":"IF(S38=0,0,1/S38)","v":0.05},null,{"$f":"IF(U38=0,0,1/U38)","v":0.05},null,{"$f":"IF(W38=0,0,1/W38)","v":0.05},null,{"$f":"IF(Y38=0,0,1/Y38)","v":0.05},null,{"$f":"IF(AA38=0,0,1/AA38)","v":0.05},null,{"$f":"IF(AC38=0,0,1/AC38)","v":0.05},null,{"$f":"IF(AE38=0,0,1/AE38)","v":0.05}]
[]
[null,null,null,"Year",1845,null,45,null,45,null,45,null,45,null,45,null,45,null,45,null,45,null,45,null,45,null,45,null,45,null,45]
[null,null,"                              - rate (%)","Rate (%)",null,null,{"$f":"IF(G41=0,0,1/G41)","v":2.2222222222222223E-2},null,{"$f":"IF(I41=0,0,1/I41)","v":2.2222222222222223E-2},null,{"$f":"IF(K41=0,0,1/K41)","v":2.2222222222222223E-2},null,{"$f":"IF(M41=0,0,1/M41)","v":2.2222222222222223E-2},null,{"$f":"IF(O41=0,0,1/O41)","v":2.2222222222222223E-2},null,{"$f":"IF(Q41=0,0,1/Q41)","v":2.2222222222222223E-2},null,{"$f":"IF(S41=0,0,1/S41)","v":2.2222222222222223E-2},null,{"$f":"IF(U41=0,0,1/U41)","v":2.2222222222222223E-2},null,{"$f":"IF(W41=0,0,1/W41)","v":2.2222222222222223E-2},null,{"$f":"IF(Y41=0,0,1/Y41)","v":2.2222222222222223E-2},null,{"$f":"IF(AA41=0,0,1/AA41)","v":2.2222222222222223E-2},null,{"$f":"IF(AC41=0,0,1/AC41)","v":2.2222222222222223E-2},null,{"$f":"IF(AE41=0,0,1/AE41)","v":2.2222222222222223E-2}]
[]
[null,null,null,"Year",1930,null,7,null,7,null,7,null,7,null,7,null,7,null,7,null,7,null,7,null,7,null,7,null,7,null,7]
[null,null,"                              - rate (%)","Rate (%)",null,null,{"$f":"IF(G44=0,0,1/G44)","v":0.14285714285714285},null,{"$f":"IF(I44=0,0,1/I44)","v":0.14285714285714285},null,{"$f":"IF(K44=0,0,1/K44)","v":0.14285714285714285},null,{"$f":"IF(M44=0,0,1/M44)","v":0.14285714285714285},null,{"$f":"IF(O44=0,0,1/O44)","v":0.14285714285714285},null,{"$f":"IF(Q44=0,0,1/Q44)","v":0.14285714285714285},null,{"$f":"IF(S44=0,0,1/S44)","v":0.14285714285714285},null,{"$f":"IF(U44=0,0,1/U44)","v":0.14285714285714285},null,{"$f":"IF(W44=0,0,1/W44)","v":0.14285714285714285},null,{"$f":"IF(Y44=0,0,1/Y44)","v":0.14285714285714285},null,{"$f":"IF(AA44=0,0,1/AA44)","v":0.14285714285714285},null,{"$f":"IF(AC44=0,0,1/AC44)","v":0.14285714285714285},null,{"$f":"IF(AE44=0,0,1/AE44)","v":0.14285714285714285}]
[]
[null,null,null,"Year",1835,null,40,null,40,null,40,null,40,null,40,null,40,null,40,null,40,null,40,null,40,null,40,null,40,null,40]
[null,null,"                              - rate (%)","Rate (%)",null,null,{"$f":"IF(G47=0,0,1/G47)","v":2.5000000000000001E-2},null,{"$f":"IF(I47=0,0,1/I47)","v":2.5000000000000001E-2},null,{"$f":"IF(K47=0,0,1/K47)","v":2.5000000000000001E-2},null,{"$f":"IF(M47=0,0,1/M47)","v":2.5000000000000001E-2},null,{"$f":"IF(O47=0,0,1/O47)","v":2.5000000000000001E-2},null,{"$f":"IF(Q47=0,0,1/Q47)","v":2.5000000000000001E-2},null,{"$f":"IF(S47=0,0,1/S47)","v":2.5000000000000001E-2},null,{"$f":"IF(U47=0,0,1/U47)","v":2.5000000000000001E-2},null,{"$f":"IF(W47=0,0,1/W47)","v":2.5000000000000001E-2},null,{"$f":"IF(Y47=0,0,1/Y47)","v":2.5000000000000001E-2},null,{"$f":"IF(AA47=0,0,1/AA47)","v":2.5000000000000001E-2},null,{"$f":"IF(AC47=0,0,1/AC47)","v":2.5000000000000001E-2},null,{"$f":"IF(AE47=0,0,1/AE47)","v":2.5000000000000001E-2}]
[]
[null,null,null,"Year",1921,null,4,null,4,null,4,null,4,null,4,null,4,null,4,null,4,null,4,null,4,null,4,null,4,null,4]
[null,null,"                              - rate (%)","Rate (%)",null,null,{"$f":"IF(G50=0,0,1/G50)","v":0.25},null,{"$f":"IF(I50=0,0,1/I50)","v":0.25},null,{"$f":"IF(K50=0,0,1/K50)","v":0.25},null,{"$f":"IF(M50=0,0,1/M50)","v":0.25},null,{"$f":"IF(O50=0,0,1/O50)","v":0.25},null,{"$f":"IF(Q50=0,0,1/Q50)","v":0.25},null,{"$f":"IF(S50=0,0,1/S50)","v":0.25},null,{"$f":"IF(U50=0,0,1/U50)","v":0.25},null,{"$f":"IF(W50=0,0,1/W50)","v":0.25},null,{"$f":"IF(Y50=0,0,1/Y50)","v":0.25},null,{"$f":"IF(AA50=0,0,1/AA50)","v":0.25},null,{"$f":"IF(AC50=0,0,1/AC50)","v":0.25},null,{"$f":"IF(AE50=0,0,1/AE50)","v":0.25}]
[]
[null,null,null,"Year",1935,null,10,null,10,null,10,null,10,null,10,null,10,null,10,null,10,null,10,null,10,null,10,null,10,null,10]
[null,null,"                              - rate (%)","Rate (%)",null,null,{"$f":"IF(G53=0,0,1/G53)","v":0.1},null,{"$f":"IF(I53=0,0,1/I53)","v":0.1},null,{"$f":"IF(K53=0,0,1/K53)","v":0.1},null,{"$f":"IF(M53=0,0,1/M53)","v":0.1},null,{"$f":"IF(O53=0,0,1/O53)","v":0.1},null,{"$f":"IF(Q53=0,0,1/Q53)","v":0.1},null,{"$f":"IF(S53=0,0,1/S53)","v":0.1},null,{"$f":"IF(U53=0,0,1/U53)","v":0.1},null,{"$f":"IF(W53=0,0,1/W53)","v":0.1},null,{"$f":"IF(Y53=0,0,1/Y53)","v":0.1},null,{"$f":"IF(AA53=0,0,1/AA53)","v":0.1},null,{"$f":"IF(AC53=0,0,1/AC53)","v":0.1},null,{"$f":"IF(AE53=0,0,1/AE53)","v":0.1}]
[]
[null,null,null,"Year",1926,null,3,null,3,null,3,null,3,null,3,null,3,null,3,null,3,null,3,null,3,null,3,null,3,null,3]
[null,null,"                              - rate (%)","Rate (%)",null,null,{"$f":"IF(G56=0,0,1/G56)","v":0.33333333333333331},null,{"$f":"IF(I56=0,0,1/I56)","v":0.33333333333333331},null,{"$f":"IF(K56=0,0,1/K56)","v":0.33333333333333331},null,{"$f":"IF(M56=0,0,1/M56)","v":0.33333333333333331},null,{"$f":"IF(O56=0,0,1/O56)","v":0.33333333333333331},null,{"$f":"IF(Q56=0,0,1/Q56)","v":0.33333333333333331},null,{"$f":"IF(S56=0,0,1/S56)","v":0.33333333333333331},null,{"$f":"IF(U56=0,0,1/U56)","v":0.33333333333333331},null,{"$f":"IF(W56=0,0,1/W56)","v":0.33333333333333331},null,{"$f":"IF(Y56=0,0,1/Y56)","v":0.33333333333333331},null,{"$f":"IF(AA56=0,0,1/AA56)","v":0.33333333333333331},null,{"$f":"IF(AC56=0,0,1/AC56)","v":0.33333333333333331},null,{"$f":"IF(AE56=0,0,1/AE56)","v":0.33333333333333331}]
[]
[null,null,null,"Year",1860,null,15,null,15,null,15,null,15,null,15,null,15,null,15,null,15,null,15,null,15,null,15,null,15,null,15]
[null,null,"                              - rate (%)","Rate (%)",null,null,{"$f":"IF(G59=0,0,1/G59)","v":6.6666666666666666E-2},null,{"$f":"IF(I59=0,0,1/I59)","v":6.6666666666666666E-2},null,{"$f":"IF(K59=0,0,1/K59)","v":6.6666666666666666E-2},null,{"$f":"IF(M59=0,0,1/M59)","v":6.6666666666666666E-2},null,{"$f":"IF(O59=0,0,1/O59)","v":6.6666666666666666E-2},null,{"$f":"IF(Q59=0,0,1/Q59)","v":6.6666666666666666E-2},null,{"$f":"IF(S59=0,0,1/S59)","v":6.6666666666666666E-2},null,{"$f":"IF(U59=0,0,1/U59)","v":6.6666666666666666E-2},null,{"$f":"IF(W59=0,0,1/W59)","v":6.6666666666666666E-2},null,{"$f":"IF(Y59=0,0,1/Y59)","v":6.6666666666666666E-2},null,{"$f":"IF(AA59=0,0,1/AA59)","v":6.6666666666666666E-2},null,{"$f":"IF(AC59=0,0,1/AC59)","v":6.6666666666666666E-2},null,{"$f":"IF(AE59=0,0,1/AE59)","v":6.6666666666666666E-2}]
[]
[null,null,null,"Year",1924,null,6,null,6,null,6,null,6,null,6,null,6,null,6,null,6,null,6,null,6,null,6,null,6,null,6]
[null,null,"                              - rate (%)","Rate (%)",null,null,{"$f":"IF(G62=0,0,1/G62)","v":0.16666666666666666},null,{"$f":"IF(I62=0,0,1/I62)","v":0.16666666666666666},null,{"$f":"IF(K62=0,0,1/K62)","v":0.16666666666666666},null,{"$f":"IF(M62=0,0,1/M62)","v":0.16666666666666666},null,{"$f":"IF(O62=0,0,1/O62)","v":0.16666666666666666},null,{"$f":"IF(Q62=0,0,1/Q62)","v":0.16666666666666666},null,{"$f":"IF(S62=0,0,1/S62)","v":0.16666666666666666},null,{"$f":"IF(U62=0,0,1/U62)","v":0.16666666666666666},null,{"$f":"IF(W62=0,0,1/W62)","v":0.16666666666666666},null,{"$f":"IF(Y62=0,0,1/Y62)","v":0.16666666666666666},null,{"$f":"IF(AA62=0,0,1/AA62)","v":0.16666666666666666},null,{"$f":"IF(AC62=0,0,1/AC62)","v":0.16666666666666666},null,{"$f":"IF(AE62=0,0,1/AE62)","v":0.16666666666666666}]
[]
[null,null,null,"Year",1850,null,30,null,30,null,30,null,30,null,30,null,30,null,30,null,30,null,30,null,30,null,30,null,30,null,30]
[null,null,"                              - rate (%)","Rate (%)",null,null,{"$f":"IF(G65=0,0,1/G65)","v":3.3333333333333333E-2},null,{"$f":"IF(I65=0,0,1/I65)","v":3.3333333333333333E-2},null,{"$f":"IF(K65=0,0,1/K65)","v":3.3333333333333333E-2},null,{"$f":"IF(M65=0,0,1/M65)","v":3.3333333333333333E-2},null,{"$f":"IF(O65=0,0,1/O65)","v":3.3333333333333333E-2},null,{"$f":"IF(Q65=0,0,1/Q65)","v":3.3333333333333333E-2},null,{"$f":"IF(S65=0,0,1/S65)","v":3.3333333333333333E-2},null,{"$f":"IF(U65=0,0,1/U65)","v":3.3333333333333333E-2},null,{"$f":"IF(W65=0,0,1/W65)","v":3.3333333333333333E-2},null,{"$f":"IF(Y65=0,0,1/Y65)","v":3.3333333333333333E-2},null,{"$f":"IF(AA65=0,0,1/AA65)","v":3.3333333333333333E-2},null,{"$f":"IF(AC65=0,0,1/AC65)","v":3.3333333333333333E-2},null,{"$f":"IF(AE65=0,0,1/AE65)","v":3.3333333333333333E-2}]
[]
[null,null,null,"Year",1982,null,10,null,10,null,10,null,10,null,10,null,10,null,10,null,10,null,10,null,10,null,10,null,10,null,10]
[null,null,"                              - rate (%)","Rate (%)",null,null,{"$f":"IF(G68=0,0,1/G68)","v":0.1},null,{"$f":"IF(I68=0,0,1/I68)","v":0.1},null,{"$f":"IF(K68=0,0,1/K68)","v":0.1},null,{"$f":"IF(M68=0,0,1/M68)","v":0.1},null,{"$f":"IF(O68=0,0,1/O68)","v":0.1},null,{"$f":"IF(Q68=0,0,1/Q68)","v":0.1},null,{"$f":"IF(S68=0,0,1/S68)","v":0.1},null,{"$f":"IF(U68=0,0,1/U68)","v":0.1},null,{"$f":"IF(W68=0,0,1/W68)","v":0.1},null,{"$f":"IF(Y68=0,0,1/Y68)","v":0.1},null,{"$f":"IF(AA68=0,0,1/AA68)","v":0.1},null,{"$f":"IF(AC68=0,0,1/AC68)","v":0.1},null,{"$f":"IF(AE68=0,0,1/AE68)","v":0.1}]
[]
[null,null,null,"Year",1955,null,6,null,6,null,6,null,6,null,6,null,6,null,6,null,6,null,6,null,6,null,6,null,6,null,6]
[null,null,"                              - rate (%)","Rate (%)",null,null,{"$f":"IF(G71=0,0,1/G71)","v":0.16666666666666666},null,{"$f":"IF(I71=0,0,1/I71)","v":0.16666666666666666},null,{"$f":"IF(K71=0,0,1/K71)","v":0.16666666666666666},null,{"$f":"IF(M71=0,0,1/M71)","v":0.16666666666666666},null,{"$f":"IF(O71=0,0,1/O71)","v":0.16666666666666666},null,{"$f":"IF(Q71=0,0,1/Q71)","v":0.16666666666666666},null,{"$f":"IF(S71=0,0,1/S71)","v":0.16666666666666666},null,{"$f":"IF(U71=0,0,1/U71)","v":0.16666666666666666},null,{"$f":"IF(W71=0,0,1/W71)","v":0.16666666666666666},null,{"$f":"IF(Y71=0,0,1/Y71)","v":0.16666666666666666},null,{"$f":"IF(AA71=0,0,1/AA71)","v":0.16666666666666666},null,{"$f":"IF(AC71=0,0,1/AC71)","v":0.16666666666666666},null,{"$f":"IF(AE71=0,0,1/AE71)","v":0.16666666666666666}]
[]
[null,"CCA Rates"]
[null,null,null,"CCA Class",1822,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47]
[null,null,null,"CCA Rate",null,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08]
[]
[null,null,null,"CCA Class",1845,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47]
[null,null,null,"CCA Rate",null,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08]
[]
[null,null,null,"CCA Class",1930,null,10,null,10,null,10,null,10,null,10,null,10,null,10,null,10,null,10,null,10,null,10,null,10,null,10]
[null,null,null,"CCA Rate",null,null,0.3,null,0.3,null,0.3,null,0.3,null,0.3,null,0.3,null,0.3,null,0.3,null,0.3,null,0.3,null,0.3,null,0.3,null,0.3]
[]
[null,null,null,"CCA Class",1835,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47]
[null,null,null,"CCA Rate",null,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08]
[]
[null,null,null,"CCA Class",1921,null,50,null,50,null,50,null,50,null,50,null,50,null,50,null,50,null,50,null,50,null,50,null,50,null,50]
[null,null,null,"CCA Rate",null,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004]
[]
[null,null,null,"CCA Class",1935,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8]
[null,null,null,"CCA Rate",null,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2]
[]
[null,null,null,"CCA Class",1926,null,12,null,12,null,12,null,12,null,12,null,12,null,12,null,12,null,12,null,12,null,12,null,12,null,12]
[null,null,null,"CCA Rate",null,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1]
[]
[null,null,null,"CCA Class",1862,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8]
[null,null,null,"CCA Rate",null,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2]
[]
[null,null,null,"CCA Class",1924,null,50,null,50,null,50,null,50,null,50,null,50,null,50,null,50,null,50,null,50,null,50,null,50,null,50]
[null,null,null,"CCA Rate",null,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004]
[]
[null,null,null,"CCA Class",1850,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47]
[null,null,null,"CCA Rate",null,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08]
[]
[null,null,null,"CCA Class",1982,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8]
[null,null,null,"CCA Rate",null,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2]
[]
[null,null,null,"CCA Class",1955,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8]
[null,null,null,"CCA Rate",null,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2]
[]
[]
[null,"Assumptions"]
[null,1,"Fiscal calendar year (January 1 to December 31) used."]
[null,3,"Amortization is done on a striaght line basis and no \"half-year\" rule applied."]

{"sheet":"2. MIST Meters Assets_Rate Base","index":1,"n_rows":269,"n_cols":29,"rows_kept":269,"cut":false,"hidden":false,"merged":[[3,3,3,4]]}
[]
[]
[]
[null,null,null,"MIST Meters True-up Model"]
[]
[]
[]
[]
[null,"Sheet 2: MIST Meters Asset - Net Book Value"]
[null,null,null,null,2014,null,2015,null,2016,null,2017,null,2018,null,2019,null,2020,null,2021,null,2022,null,2023,null,2024,null,2025,null,2026]
[null,"Net Fixed Assets - 1860"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"E17","v":413818.66},null,{"$f":"G17","v":1245375.24},null,{"$f":"I17","v":2009534.17},null,{"$f":"K17","v":2941497.3899999997},null,{"$f":"M17","v":2962364.59},null,{"$f":"O17","v":2962364.59},null,{"$f":"Q17","v":2962364.59},null,{"$f":"S17","v":2962364.59},null,{"$f":"U17","v":2962364.59},null,{"$f":"W17","v":2962364.59},null,{"$f":"Y17","v":2962364.59},null,{"$f":"AA17","v":2962364.59}]
[null,null,null,"Capital Additions during year ",413818.66,null,831556.58,null,764158.93,null,931963.22,null,20867.2,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E14+E15-E16","v":413818.66},null,{"$f":"G14+G15-G16","v":1245375.24},null,{"$f":"I14+I15-I16","v":2009534.17},null,{"$f":"K14+K15-K16","v":2941497.3899999997},null,{"$f":"M14+M15-M16","v":2962364.59},null,{"$f":"O14+O15-O16","v":2962364.59},null,{"$f":"Q14+Q15-Q16","v":2962364.59},null,{"$f":"S14+S15-S16","v":2962364.59},null,{"$f":"U14+U15-U16","v":2962364.59},null,{"$f":"W14+W15-W16","v":2962364.59},null,{"$f":"Y14+Y15-Y16","v":2962364.59},null,{"$f":"AA14+AA15-AA16","v":2962364.59},null,{"$f":"AC14+AC15-AC16","v":2962364.59}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,{"$f":"E23","v":-13793.96},null,{"$f":"G23","v":-69100.42},null,{"$f":"I23","v":-177597.4},null,{"$f":"K23","v":-342631.79000000004},null,{"$f":"M23","v":-539427.18000000005},null,{"$f":"O23","v":-755653.34},null,{"$f":"Q23","v":-971879.5},null,{"$f":"S23","v":-1188105.6599999999},null,{"$f":"U23","v":-1404331.8199999998},null,{"$f":"W23","v":-1620557.9799999997},null,{"$f":"Y23","v":-1836784.1399999997},null,{"$f":"AA23","v":-2053010.2999999996}]
[null,null,null,"Amortization expense during year",-13793.96,null,-55306.46,null,-108496.98,null,-165034.39000000001,null,-196795.39,null,-216226.15999999992,null,-216226.16,null,-216226.15999999992,null,-216226.16,null,-216226.16,null,-216226.16,null,-216226.16,null,-216226.16]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E20+E21-E22","v":-13793.96},null,{"$f":"G20+G21-G22","v":-69100.42},null,{"$f":"I20+I21-I22","v":-177597.4},null,{"$f":"K20+K21-K22","v":-342631.79000000004},null,{"$f":"M20+M21-M22","v":-539427.18000000005},null,{"$f":"O20+O21-O22","v":-755653.34},null,{"$f":"Q20+Q21-Q22","v":-971879.5},null,{"$f":"S20+S21-S22","v":-1188105.6599999999},null,{"$f":"U20+U21-U22","v":-1404331.8199999998},null,{"$f":"W20+W21-W22","v":-1620557.9799999997},null,{"$f":"Y20+Y21-Y22","v":-1836784.1399999997},null,{"$f":"AA20+AA21-AA22","v":-2053010.2999999996},null,{"$f":"AC20+AC21-AC22","v":-2269236.4599999995}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",{"$f":"E14+E20","v":0},null,{"$f":"E27","v":400024.69999999995},null,{"$f":"G27","v":1176274.82},null,{"$f":"I27","v":1831936.77},null,{"$f":"K27","v":2598865.5999999996},null,{"$f":"M27","v":2422937.4099999997},null,{"$f":"O27","v":2206711.25},null,{"$f":"Q27","v":1990485.0899999999},null,{"$f":"S27","v":1774258.93},null,{"$f":"U27","v":1558032.77},null,{"$f":"W27","v":1341806.6100000001},null,{"$f":"Y27","v":1125580.4500000002},null,{"$f":"AA27","v":909354.29000000027}]
[null,null,null,"Closing Balance",{"$f":"E17+E23","v":400024.69999999995},null,{"$f":"G17+G23","v":1176274.82},null,{"$f":"I17+I23","v":1831936.77},null,{"$f":"K17+K23","v":2598865.5999999996},null,{"$f":"M17+M23","v":2422937.4099999997},null,{"$f":"O17+O23","v":2206711.25},null,{"$f":"Q17+Q23","v":1990485.0899999999},null,{"$f":"S17+S23","v":1774258.93},null,{"$f":"U17+U23","v":1558032.77},null,{"$f":"W17+W23","v":1341806.6100000001},null,{"$f":"Y17+Y23","v":1125580.4500000002},null,{"$f":"AA17+AA23","v":909354.29000000027},null,{"$f":"AC17+AC23","v":693128.13000000035}]
[null,null,null,"Net Fixed Assets (NFA)",{"$f":"SUM(E26:E27)/2","v":200012.34999999998},null,{"$f":"AVERAGE(G26:G27)","v":788149.76000000001},null,{"$f":"AVERAGE(I26:I27)","v":1504105.7949999999},null,{"$f":"AVERAGE(K26:K27)","v":2215401.1849999996},null,{"$f":"AVERAGE(M26:M27)","v":2510901.5049999999},null,{"$f":"AVERAGE(O26:O27)","v":2314824.33},null,{"$f":"AVERAGE(Q26:Q27)","v":2098598.17},null,{"$f":"AVERAGE(S26:S27)","v":1882372.0099999998},null,{"$f":"AVERAGE(U26:U27)","v":1666145.85},null,{"$f":"AVERAGE(W26:W27)","v":1449919.69},null,{"$f":"AVERAGE(Y26:Y27)","v":1233693.5300000003},null,{"$f":"AVERAGE(AA26:AA27)","v":1017467.3700000002},null,{"$f":"AVERAGE(AC26:AC27)","v":801241.21000000031}]
[]
[null,"Net Fixed Assets - 1845"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"E36","v":0},null,{"$f":"G36","v":0},null,{"$f":"I36","v":0},null,{"$f":"K36","v":0},null,{"$f":"M36","v":0},null,{"$f":"O36","v":0},null,{"$f":"Q36","v":0},null,{"$f":"S36","v":0},null,{"$f":"U36","v":0},null,{"$f":"W36","v":0},null,{"$f":"Y36","v":0},null,{"$f":"AA36","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)"]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E33+E34-E35","v":0},null,{"$f":"G33+G34-G35","v":0},null,{"$f":"I33+I34-I35","v":0},null,{"$f":"K33+K34-K35","v":0},null,{"$f":"M33+M34-M35","v":0},null,{"$f":"O33+O34-O35","v":0},null,{"$f":"Q33+Q34-Q35","v":0},null,{"$f":"S33+S34-S35","v":0},null,{"$f":"U33+U34-U35","v":0},null,{"$f":"W33+W34-W35","v":0},null,{"$f":"Y33+Y34-Y35","v":0},null,{"$f":"AA33+AA34-AA35","v":0},null,{"$f":"AC33+AC34-AC35","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,{"$f":"E42","v":0},null,{"$f":"G42","v":0},null,{"$f":"I42","v":0},null,{"$f":"K42","v":0},null,{"$f":"M42","v":0},null,{"$f":"O42","v":0},null,{"$f":"Q42","v":0},null,{"$f":"S42","v":0},null,{"$f":"U42","v":0},null,{"$f":"W42","v":0},null,{"$f":"Y42","v":0},null,{"$f":"AA42","v":0}]
[null,null,null,"Amortization expense during year",{"$f":"-E34/'1. Cost of Service_parameters'!G41/2","v":0},null,{"$f":"-G33/'1. Cost of Service_parameters'!G41-'2. MIST Meters Assets_Rate Base'!G34/'1. Cost of Service_parameters'!G41/2","v":0},null,{"$f":"-I33/'1. Cost of Service_parameters'!I41-'2. MIST Meters Assets_Rate Base'!I34/'1. Cost of Service_parameters'!I41/2","v":0},null,{"$f":"-K33/'1. Cost of Service_parameters'!K41-'2. MIST Meters Assets_Rate Base'!K34/'1. Cost of Service_parameters'!K41/2","v":0},null,{"$f":"-M33/'1. Cost of Service_parameters'!M41-'2. MIST Meters Assets_Rate Base'!M34/'1. Cost of Service_parameters'!M41/2","v":0},null,{"$f":"-O33/'1. Cost of Service_parameters'!O41-'2. MIST Meters Assets_Rate Base'!O34/'1. Cost of Service_parameters'!O41/2","v":0},null,{"$f":"-Q33/'1. Cost of Service_parameters'!Q41-'2. MIST Meters Assets_Rate Base'!Q34/'1. Cost of Service_parameters'!Q41/2","v":0},null,{"$f":"-S33/'1. Cost of Service_parameters'!S41-'2. MIST Meters Assets_Rate Base'!S34/'1. Cost of Service_parameters'!S41/2","v":0},null,{"$f":"-U33/'1. Cost of Service_parameters'!U41-'2. MIST Meters Assets_Rate Base'!U34/'1. Cost of Service_parameters'!U41/2","v":0},null,{"$f":"-W33/'1. Cost of Service_parameters'!W41-'2. MIST Meters Assets_Rate Base'!W34/'1. Cost of Service_parameters'!W41/2","v":0},null,{"$f":"-Y33/'1. Cost of Service_parameters'!Y41-'2. MIST Meters Assets_Rate Base'!Y34/'1. Cost of Service_parameters'!Y41/2","v":0},null,{"$f":"-AA33/'1. Cost of Service_parameters'!AA41-'2. MIST Meters Assets_Rate Base'!AA34/'1. Cost of Service_parameters'!AA41/2","v":0},null,{"$f":"-AC33/'1. Cost of Service_parameters'!AC41-'2. MIST Meters Assets_Rate Base'!AC34/'1. Cost of Service_parameters'!AC41/2","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E39+E40-E41","v":0},null,{"$f":"G39+G40-G41","v":0},null,{"$f":"I39+I40-I41","v":0},null,{"$f":"K39+K40-K41","v":0},null,{"$f":"M39+M40-M41","v":0},null,{"$f":"O39+O40-O41","v":0},null,{"$f":"Q39+Q40-Q41","v":0},null,{"$f":"S39+S40-S41","v":0},null,{"$f":"U39+U40-U41","v":0},null,{"$f":"W39+W40-W41","v":0},null,{"$f":"Y39+Y40-Y41","v":0},null,{"$f":"AA39+AA40-AA41","v":0},null,{"$f":"AC39+AC40-AC41","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",{"$f":"E33+E39","v":0},null,{"$f":"E46","v":0},null,{"$f":"G46","v":0},null,{"$f":"I46","v":0},null,{"$f":"K46","v":0},null,{"$f":"M46","v":0},null,{"$f":"O46","v":0},null,{"$f":"Q46","v":0},null,{"$f":"S46","v":0},null,{"$f":"U46","v":0},null,{"$f":"W46","v":0},null,{"$f":"Y46","v":0},null,{"$f":"AA46","v":0}]
[null,null,null,"Closing Balance",{"$f":"E36+E42","v":0},null,{"$f":"G36+G42","v":0},null,{"$f":"I36+I42","v":0},null,{"$f":"K36+K42","v":0},null,{"$f":"M36+M42","v":0},null,{"$f":"O36+O42","v":0},null,{"$f":"Q36+Q42","v":0},null,{"$f":"S36+S42","v":0},null,{"$f":"U36+U42","v":0},null,{"$f":"W36+W42","v":0},null,{"$f":"Y36+Y42","v":0},null,{"$f":"AA36+AA42","v":0},null,{"$f":"AC36+AC42","v":0}]
[null,null,null,"Net Fixed Assets (NFA)",{"$f":"AVERAGE(E45:E46)","v":0},null,{"$f":"AVERAGE(G45:G46)","v":0},null,{"$f":"AVERAGE(I45:I46)","v":0},null,{"$f":"AVERAGE(K45:K46)","v":0},null,{"$f":"AVERAGE(M45:M46)","v":0},null,{"$f":"AVERAGE(O45:O46)","v":0},null,{"$f":"AVERAGE(Q45:Q46)","v":0},null,{"$f":"AVERAGE(S45:S46)","v":0},null,{"$f":"AVERAGE(U45:U46)","v":0},null,{"$f":"AVERAGE(W45:W46)","v":0},null,{"$f":"AVERAGE(Y45:Y46)","v":0},null,{"$f":"AVERAGE(AA45:AA46)","v":0},null,{"$f":"AVERAGE(AC45:AC46)","v":0}]
[]
[null,"Net Fixed Assets - 1930"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"E55","v":0},null,{"$f":"G55","v":0},null,{"$f":"I55","v":0},null,{"$f":"K55","v":0},null,{"$f":"M55","v":0},null,{"$f":"O55","v":0},null,{"$f":"Q55","v":0},null,{"$f":"S55","v":0},null,{"$f":"U55","v":0},null,{"$f":"W55","v":0},null,{"$f":"Y55","v":0},null,{"$f":"AA55","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E52+E53-E54","v":0},null,{"$f":"G52+G53-G54","v":0},null,{"$f":"I52+I53-I54","v":0},null,{"$f":"K52+K53-K54","v":0},null,{"$f":"M52+M53-M54","v":0},null,{"$f":"O52+O53-O54","v":0},null,{"$f":"Q52+Q53-Q54","v":0},null,{"$f":"S52+S53-S54","v":0},null,{"$f":"U52+U53-U54","v":0},null,{"$f":"W52+W53-W54","v":0},null,{"$f":"Y52+Y53-Y54","v":0},null,{"$f":"AA52+AA53-AA54","v":0},null,{"$f":"AC52+AC53-AC54","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,{"$f":"E61","v":0},null,{"$f":"G61","v":0},null,{"$f":"I61","v":0},null,{"$f":"K61","v":0},null,{"$f":"M61","v":0},null,{"$f":"O61","v":0},null,{"$f":"Q61","v":0},null,{"$f":"S61","v":0},null,{"$f":"U61","v":0},null,{"$f":"W61","v":0},null,{"$f":"Y61","v":0},null,{"$f":"AA61","v":0}]
[null,null,null,"Amortization expense during year",{"$f":"-E53/'1. Cost of Service_parameters'!G44/2","v":0},null,{"$f":"-G52/'1. Cost of Service_parameters'!G44","v":0},null,{"$f":"-I52/'1. Cost of Service_parameters'!I44","v":0},null,{"$f":"-K52/'1. Cost of Service_parameters'!K44","v":0},null,{"$f":"-M52/'1. Cost of Service_parameters'!M44","v":0},null,{"$f":"-O52/'1. Cost of Service_parameters'!O44","v":0},null,{"$f":"-Q52/'1. Cost of Service_parameters'!Q44","v":0},null,{"$f":"-S52/'1. Cost of Service_parameters'!S44","v":0},null,{"$f":"-U52/'1. Cost of Service_parameters'!U44","v":0},null,{"$f":"-W52/'1. Cost of Service_parameters'!W44","v":0},null,{"$f":"-Y52/'1. Cost of Service_parameters'!Y44","v":0},null,{"$f":"-AA52/'1. Cost of Service_parameters'!AA44","v":0},null,{"$f":"-AC52/'1. Cost of Service_parameters'!AC44","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E58+E59-E60","v":0},null,{"$f":"G58+G59-G60","v":0},null,{"$f":"I58+I59-I60","v":0},null,{"$f":"K58+K59-K60","v":0},null,{"$f":"M58+M59-M60","v":0},null,{"$f":"O58+O59-O60","v":0},null,{"$f":"Q58+Q59-Q60","v":0},null,{"$f":"S58+S59-S60","v":0},null,{"$f":"U58+U59-U60","v":0},null,{"$f":"W58+W59-W60","v":0},null,{"$f":"Y58+Y59-Y60","v":0},null,{"$f":"AA58+AA59-AA60","v":0},null,{"$f":"AC58+AC59-AC60","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",{"$f":"E52+E58","v":0},null,{"$f":"E65","v":0},null,{"$f":"G65","v":0},null,{"$f":"I65","v":0},null,{"$f":"K65","v":0},null,{"$f":"M65","v":0},null,{"$f":"O65","v":0},null,{"$f":"Q65","v":0},null,{"$f":"S65","v":0},null,{"$f":"U65","v":0},null,{"$f":"W65","v":0},null,{"$f":"Y65","v":0},null,{"$f":"AA65","v":0}]
[null,null,null,"Closing Balance",{"$f":"E55+E61","v":0},null,{"$f":"G55+G61","v":0},null,{"$f":"I55+I61","v":0},null,{"$f":"K55+K61","v":0},null,{"$f":"M55+M61","v":0},null,{"$f":"O55+O61","v":0},null,{"$f":"Q55+Q61","v":0},null,{"$f":"S55+S61","v":0},null,{"$f":"U55+U61","v":0},null,{"$f":"W55+W61","v":0},null,{"$f":"Y55+Y61","v":0},null,{"$f":"AA55+AA61","v":0},null,{"$f":"AC55+AC61","v":0}]
[null,null,null,"Net Fixed Assets (NFA)",{"$f":"AVERAGE(E64:E65)","v":0},null,{"$f":"AVERAGE(G64:G65)","v":0},null,{"$f":"AVERAGE(I64:I65)","v":0},null,{"$f":"AVERAGE(K64:K65)","v":0},null,{"$f":"AVERAGE(M64:M65)","v":0},null,{"$f":"AVERAGE(O64:O65)","v":0},null,{"$f":"AVERAGE(Q64:Q65)","v":0},null,{"$f":"AVERAGE(S64:S65)","v":0},null,{"$f":"AVERAGE(U64:U65)","v":0},null,{"$f":"AVERAGE(W64:W65)","v":0},null,{"$f":"AVERAGE(Y64:Y65)","v":0},null,{"$f":"AVERAGE(AA64:AA65)","v":0},null,{"$f":"AVERAGE(AC64:AC65)","v":0}]
[]
[null,"Net Fixed Assets - 1835"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"E74","v":0},null,{"$f":"G74","v":0},null,{"$f":"I74","v":0},null,{"$f":"K74","v":0},null,{"$f":"M74","v":0},null,{"$f":"O74","v":0},null,{"$f":"Q74","v":0},null,{"$f":"S74","v":0},null,{"$f":"U74","v":0},null,{"$f":"W74","v":0},null,{"$f":"Y74","v":0},null,{"$f":"AA74","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)"]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E71+E72-E73","v":0},null,{"$f":"G71+G72-G73","v":0},null,{"$f":"I71+I72-I73","v":0},null,{"$f":"K71+K72-K73","v":0},null,{"$f":"M71+M72-M73","v":0},null,{"$f":"O71+O72-O73","v":0},null,{"$f":"Q71+Q72-Q73","v":0},null,{"$f":"S71+S72-S73","v":0},null,{"$f":"U71+U72-U73","v":0},null,{"$f":"W71+W72-W73","v":0},null,{"$f":"Y71+Y72-Y73","v":0},null,{"$f":"AA71+AA72-AA73","v":0},null,{"$f":"AC71+AC72-AC73","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,{"$f":"E80","v":0},null,{"$f":"G80","v":0},null,{"$f":"I80","v":0},null,{"$f":"K80","v":0},null,{"$f":"M80","v":0},null,{"$f":"O80","v":0},null,{"$f":"Q80","v":0},null,{"$f":"S80","v":0},null,{"$f":"U80","v":0},null,{"$f":"W80","v":0},null,{"$f":"Y80","v":0},null,{"$f":"AA80","v":0}]
[null,null,null,"Amortization expense during year",{"$f":"-E72/'1. Cost of Service_parameters'!G47/2","v":0},null,{"$f":"-G71/'1. Cost of Service_parameters'!G47-'2. MIST Meters Assets_Rate Base'!G72/'1. Cost of Service_parameters'!G47/2","v":0},null,{"$f":"-I71/'1. Cost of Service_parameters'!I47-'2. MIST Meters Assets_Rate Base'!I72/'1. Cost of Service_parameters'!I47/2","v":0},null,{"$f":"-K71/'1. Cost of Service_parameters'!K47-'2. MIST Meters Assets_Rate Base'!K72/'1. Cost of Service_parameters'!K47/2","v":0},null,{"$f":"-M71/'1. Cost of Service_parameters'!M47-'2. MIST Meters Assets_Rate Base'!M72/'1. Cost of Service_parameters'!M47/2","v":0},null,{"$f":"-O71/'1. Cost of Service_parameters'!O47-'2. MIST Meters Assets_Rate Base'!O72/'1. Cost of Service_parameters'!O47/2","v":0},null,{"$f":"-Q71/'1. Cost of Service_parameters'!Q47-'2. MIST Meters Assets_Rate Base'!Q72/'1. Cost of Service_parameters'!Q47/2","v":0},null,{"$f":"-S71/'1. Cost of Service_parameters'!S47-'2. MIST Meters Assets_Rate Base'!S72/'1. Cost of Service_parameters'!S47/2","v":0},null,{"$f":"-U71/'1. Cost of Service_parameters'!U47-'2. MIST Meters Assets_Rate Base'!U72/'1. Cost of Service_parameters'!U47/2","v":0},null,{"$f":"-W71/'1. Cost of Service_parameters'!W47-'2. MIST Meters Assets_Rate Base'!W72/'1. Cost of Service_parameters'!W47/2","v":0},null,{"$f":"-Y71/'1. Cost of Service_parameters'!Y47-'2. MIST Meters Assets_Rate Base'!Y72/'1. Cost of Service_parameters'!Y47/2","v":0},null,{"$f":"-AA71/'1. Cost of Service_parameters'!AA47-'2. MIST Meters Assets_Rate Base'!AA72/'1. Cost of Service_parameters'!AA47/2","v":0},null,{"$f":"-AC71/'1. Cost of Service_parameters'!AC47-'2. MIST Meters Assets_Rate Base'!AC72/'1. Cost of Service_parameters'!AC47/2","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E77+E78-E79","v":0},null,{"$f":"G77+G78-G79","v":0},null,{"$f":"I77+I78-I79","v":0},null,{"$f":"K77+K78-K79","v":0},null,{"$f":"M77+M78-M79","v":0},null,{"$f":"O77+O78-O79","v":0},null,{"$f":"Q77+Q78-Q79","v":0},null,{"$f":"S77+S78-S79","v":0},null,{"$f":"U77+U78-U79","v":0},null,{"$f":"W77+W78-W79","v":0},null,{"$f":"Y77+Y78-Y79","v":0},null,{"$f":"AA77+AA78-AA79","v":0},null,{"$f":"AC77+AC78-AC79","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",{"$f":"E71+E77","v":0},null,{"$f":"E84","v":0},null,{"$f":"G84","v":0},null,{"$f":"I84","v":0},null,{"$f":"K84","v":0},null,{"$f":"M84","v":0},null,{"$f":"O84","v":0},null,{"$f":"Q84","v":0},null,{"$f":"S84","v":0},null,{"$f":"U84","v":0},null,{"$f":"W84","v":0},null,{"$f":"Y84","v":0},null,{"$f":"AA84","v":0}]
[null,null,null,"Closing Balance",{"$f":"E74+E80","v":0},null,{"$f":"G74+G80","v":0},null,{"$f":"I74+I80","v":0},null,{"$f":"K74+K80","v":0},null,{"$f":"M74+M80","v":0},null,{"$f":"O74+O80","v":0},null,{"$f":"Q74+Q80","v":0},null,{"$f":"S74+S80","v":0},null,{"$f":"U74+U80","v":0},null,{"$f":"W74+W80","v":0},null,{"$f":"Y74+Y80","v":0},null,{"$f":"AA74+AA80","v":0},null,{"$f":"AC74+AC80","v":0}]
[null,null,null,"Net Fixed Assets (NFA)",{"$f":"AVERAGE(E83:E84)","v":0},null,{"$f":"AVERAGE(G83:G84)","v":0},null,{"$f":"AVERAGE(I83:I84)","v":0},null,{"$f":"AVERAGE(K83:K84)","v":0},null,{"$f":"AVERAGE(M83:M84)","v":0},null,{"$f":"AVERAGE(O83:O84)","v":0},null,{"$f":"AVERAGE(Q83:Q84)","v":0},null,{"$f":"AVERAGE(S83:S84)","v":0},null,{"$f":"AVERAGE(U83:U84)","v":0},null,{"$f":"AVERAGE(W83:W84)","v":0},null,{"$f":"AVERAGE(Y83:Y84)","v":0},null,{"$f":"AVERAGE(AA83:AA84)","v":0},null,{"$f":"AVERAGE(AC83:AC84)","v":0}]
[]
[null,"Net Fixed Assets - 1921"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"E93","v":0},null,{"$f":"G93","v":0},null,{"$f":"I93","v":0},null,{"$f":"K93","v":0},null,{"$f":"M93","v":0},null,{"$f":"O93","v":0},null,{"$f":"Q93","v":0},null,{"$f":"S93","v":0},null,{"$f":"U93","v":0},null,{"$f":"W93","v":0},null,{"$f":"Y93","v":0},null,{"$f":"AA93","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E90+E91-E92","v":0},null,{"$f":"G90+G91-G92","v":0},null,{"$f":"I90+I91-I92","v":0},null,{"$f":"K90+K91-K92","v":0},null,{"$f":"M90+M91-M92","v":0},null,{"$f":"O90+O91-O92","v":0},null,{"$f":"Q90+Q91-Q92","v":0},null,{"$f":"S90+S91-S92","v":0},null,{"$f":"U90+U91-U92","v":0},null,{"$f":"W90+W91-W92","v":0},null,{"$f":"Y90+Y91-Y92","v":0},null,{"$f":"AA90+AA91-AA92","v":0},null,{"$f":"AC90+AC91-AC92","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,{"$f":"E99","v":0},null,{"$f":"G99","v":0},null,{"$f":"I99","v":0},null,{"$f":"K99","v":0},null,{"$f":"M99","v":0},null,{"$f":"O99","v":0},null,{"$f":"Q99","v":0},null,{"$f":"S99","v":0},null,{"$f":"U99","v":0},null,{"$f":"W99","v":0},null,{"$f":"Y99","v":0},null,{"$f":"AA99","v":0}]
[null,null,null,"Amortization expense during year",{"$f":"-E91/'1. Cost of Service_parameters'!G50/2","v":0},null,{"$f":"-G90/'1. Cost of Service_parameters'!G50","v":0},null,{"$f":"-I90/'1. Cost of Service_parameters'!I50","v":0},null,{"$f":"-K90/'1. Cost of Service_parameters'!K50","v":0},null,{"$f":"-M90/'1. Cost of Service_parameters'!M50","v":0},null,{"$f":"-O90/'1. Cost of Service_parameters'!O50","v":0},null,{"$f":"-Q90/'1. Cost of Service_parameters'!Q50","v":0},null,{"$f":"-S90/'1. Cost of Service_parameters'!S50","v":0},null,{"$f":"-U90/'1. Cost of Service_parameters'!U50","v":0},null,{"$f":"-W90/'1. Cost of Service_parameters'!W50","v":0},null,{"$f":"-Y90/'1. Cost of Service_parameters'!Y50","v":0},null,{"$f":"-AA90/'1. Cost of Service_parameters'!AA50","v":0},null,{"$f":"-AC90/'1. Cost of Service_parameters'!AC50","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E96+E97-E98","v":0},null,{"$f":"G96+G97-G98","v":0},null,{"$f":"I96+I97-I98","v":0},null,{"$f":"K96+K97-K98","v":0},null,{"$f":"M96+M97-M98","v":0},null,{"$f":"O96+O97-O98","v":0},null,{"$f":"Q96+Q97-Q98","v":0},null,{"$f":"S96+S97-S98","v":0},null,{"$f":"U96+U97-U98","v":0},null,{"$f":"W96+W97-W98","v":0},null,{"$f":"Y96+Y97-Y98","v":0},null,{"$f":"AA96+AA97-AA98","v":0},null,{"$f":"AC96+AC97-AC98","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",{"$f":"E90+E96","v":0},null,{"$f":"E103","v":0},null,{"$f":"G103","v":0},null,{"$f":"I103","v":0},null,{"$f":"K103","v":0},null,{"$f":"M103","v":0},null,{"$f":"O103","v":0},null,{"$f":"Q103","v":0},null,{"$f":"S103","v":0},null,{"$f":"U103","v":0},null,{"$f":"W103","v":0},null,{"$f":"Y103","v":0},null,{"$f":"AA103","v":0}]
[null,null,null,"Closing Balance",{"$f":"E93+E99","v":0},null,{"$f":"G93+G99","v":0},null,{"$f":"I93+I99","v":0},null,{"$f":"K93+K99","v":0},null,{"$f":"M93+M99","v":0},null,{"$f":"O93+O99","v":0},null,{"$f":"Q93+Q99","v":0},null,{"$f":"S93+S99","v":0},null,{"$f":"U93+U99","v":0},null,{"$f":"W93+W99","v":0},null,{"$f":"Y93+Y99","v":0},null,{"$f":"AA93+AA99","v":0},null,{"$f":"AC93+AC99","v":0}]
[null,null,null,"Net Fixed Assets (NFA)",{"$f":"AVERAGE(E102:E103)","v":0},null,{"$f":"AVERAGE(G102:G103)","v":0},null,{"$f":"AVERAGE(I102:I103)","v":0},null,{"$f":"AVERAGE(K102:K103)","v":0},null,{"$f":"AVERAGE(M102:M103)","v":0},null,{"$f":"AVERAGE(O102:O103)","v":0},null,{"$f":"AVERAGE(Q102:Q103)","v":0},null,{"$f":"AVERAGE(S102:S103)","v":0},null,{"$f":"AVERAGE(U102:U103)","v":0},null,{"$f":"AVERAGE(W102:W103)","v":0},null,{"$f":"AVERAGE(Y102:Y103)","v":0},null,{"$f":"AVERAGE(AA102:AA103)","v":0},null,{"$f":"AVERAGE(AC102:AC103)","v":0}]
[]
[null,"Net Fixed Assets - 1935"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"E112","v":0},null,{"$f":"G112","v":0},null,{"$f":"I112","v":0},null,{"$f":"K112","v":0},null,{"$f":"M112","v":0},null,{"$f":"O112","v":0},null,{"$f":"Q112","v":0},null,{"$f":"S112","v":0},null,{"$f":"U112","v":0},null,{"$f":"W112","v":0},null,{"$f":"Y112","v":0},null,{"$f":"AA112","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)"]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E109+E110-E111","v":0},null,{"$f":"G109+G110-G111","v":0},null,{"$f":"I109+I110-I111","v":0},null,{"$f":"K109+K110-K111","v":0},null,{"$f":"M109+M110-M111","v":0},null,{"$f":"O109+O110-O111","v":0},null,{"$f":"Q109+Q110-Q111","v":0},null,{"$f":"S109+S110-S111","v":0},null,{"$f":"U109+U110-U111","v":0},null,{"$f":"W109+W110-W111","v":0},null,{"$f":"Y109+Y110-Y111","v":0},null,{"$f":"AA109+AA110-AA111","v":0},null,{"$f":"AC109+AC110-AC111","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,{"$f":"E118","v":0},null,{"$f":"G118","v":0},null,{"$f":"I118","v":0},null,{"$f":"K118","v":0},null,{"$f":"M118","v":0},null,{"$f":"O118","v":0},null,{"$f":"Q118","v":0},null,{"$f":"S118","v":0},null,{"$f":"U118","v":0},null,{"$f":"W118","v":0},null,{"$f":"Y118","v":0},null,{"$f":"AA118","v":0}]
[null,null,null,"Amortization expense during year",{"$f":"-E110/'1. Cost of Service_parameters'!G53/2","v":0},null,{"$f":"-G109/'1. Cost of Service_parameters'!G53-'2. MIST Meters Assets_Rate Base'!G110/'1. Cost of Service_parameters'!G53/2","v":0},null,{"$f":"-I109/'1. Cost of Service_parameters'!I53-'2. MIST Meters Assets_Rate Base'!I110/'1. Cost of Service_parameters'!I53/2","v":0},null,{"$f":"-K109/'1. Cost of Service_parameters'!K53-'2. MIST Meters Assets_Rate Base'!K110/'1. Cost of Service_parameters'!K53/2","v":0},null,{"$f":"-M109/'1. Cost of Service_parameters'!M53-'2. MIST Meters Assets_Rate Base'!M110/'1. Cost of Service_parameters'!M53/2","v":0},null,{"$f":"-O109/'1. Cost of Service_parameters'!O53-'2. MIST Meters Assets_Rate Base'!O110/'1. Cost of Service_parameters'!O53/2","v":0},null,{"$f":"-Q109/'1. Cost of Service_parameters'!Q53-'2. MIST Meters Assets_Rate Base'!Q110/'1. Cost of Service_parameters'!Q53/2","v":0},null,{"$f":"-S109/'1. Cost of Service_parameters'!S53-'2. MIST Meters Assets_Rate Base'!S110/'1. Cost of Service_parameters'!S53/2","v":0},null,{"$f":"-U109/'1. Cost of Service_parameters'!U53-'2. MIST Meters Assets_Rate Base'!U110/'1. Cost of Service_parameters'!U53/2","v":0},null,{"$f":"-W109/'1. Cost of Service_parameters'!W53-'2. MIST Meters Assets_Rate Base'!W110/'1. Cost of Service_parameters'!W53/2","v":0},null,{"$f":"-Y109/'1. Cost of Service_parameters'!Y53-'2. MIST Meters Assets_Rate Base'!Y110/'1. Cost of Service_parameters'!Y53/2","v":0},null,{"$f":"-AA109/'1. Cost of Service_parameters'!AA53-'2. MIST Meters Assets_Rate Base'!AA110/'1. Cost of Service_parameters'!AA53/2","v":0},null,{"$f":"-AC109/'1. Cost of Service_parameters'!AC53-'2. MIST Meters Assets_Rate Base'!AC110/'1. Cost of Service_parameters'!AC53/2","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E115+E116-E117","v":0},null,{"$f":"G115+G116-G117","v":0},null,{"$f":"I115+I116-I117","v":0},null,{"$f":"K115+K116-K117","v":0},null,{"$f":"M115+M116-M117","v":0},null,{"$f":"O115+O116-O117","v":0},null,{"$f":"Q115+Q116-Q117","v":0},null,{"$f":"S115+S116-S117","v":0},null,{"$f":"U115+U116-U117","v":0},null,{"$f":"W115+W116-W117","v":0},null,{"$f":"Y115+Y116-Y117","v":0},null,{"$f":"AA115+AA116-AA117","v":0},null,{"$f":"AC115+AC116-AC117","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",{"$f":"E109+E115","v":0},null,{"$f":"E122","v":0},null,{"$f":"G122","v":0},null,{"$f":"I122","v":0},null,{"$f":"K122","v":0},null,{"$f":"M122","v":0},null,{"$f":"O122","v":0},null,{"$f":"Q122","v":0},null,{"$f":"S122","v":0},null,{"$f":"U122","v":0},null,{"$f":"W122","v":0},null,{"$f":"Y122","v":0},null,{"$f":"AA122","v":0}]
[null,null,null,"Closing Balance",{"$f":"E112+E118","v":0},null,{"$f":"G112+G118","v":0},null,{"$f":"I112+I118","v":0},null,{"$f":"K112+K118","v":0},null,{"$f":"M112+M118","v":0},null,{"$f":"O112+O118","v":0},null,{"$f":"Q112+Q118","v":0},null,{"$f":"S112+S118","v":0},null,{"$f":"U112+U118","v":0},null,{"$f":"W112+W118","v":0},null,{"$f":"Y112+Y118","v":0},null,{"$f":"AA112+AA118","v":0},null,{"$f":"AC112+AC118","v":0}]
[null,null,null,"Net Fixed Assets (NFA)",{"$f":"AVERAGE(E121:E122)","v":0},null,{"$f":"AVERAGE(G121:G122)","v":0},null,{"$f":"AVERAGE(I121:I122)","v":0},null,{"$f":"AVERAGE(K121:K122)","v":0},null,{"$f":"AVERAGE(M121:M122)","v":0},null,{"$f":"AVERAGE(O121:O122)","v":0},null,{"$f":"AVERAGE(Q121:Q122)","v":0},null,{"$f":"AVERAGE(S121:S122)","v":0},null,{"$f":"AVERAGE(U121:U122)","v":0},null,{"$f":"AVERAGE(W121:W122)","v":0},null,{"$f":"AVERAGE(Y121:Y122)","v":0},null,{"$f":"AVERAGE(AA121:AA122)","v":0},null,{"$f":"AVERAGE(AC121:AC122)","v":0}]
[]
[null,"Net Fixed Assets - 1926"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"E131","v":0},null,{"$f":"G131","v":0},null,{"$f":"I131","v":0},null,{"$f":"K131","v":0},null,{"$f":"M131","v":0},null,{"$f":"O131","v":0},null,{"$f":"Q131","v":0},null,{"$f":"S131","v":0},null,{"$f":"U131","v":0},null,{"$f":"W131","v":0},null,{"$f":"Y131","v":0},null,{"$f":"AA131","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E128+E129-E130","v":0},null,{"$f":"G128+G129-G130","v":0},null,{"$f":"I128+I129-I130","v":0},null,{"$f":"K128+K129-K130","v":0},null,{"$f":"M128+M129-M130","v":0},null,{"$f":"O128+O129-O130","v":0},null,{"$f":"Q128+Q129-Q130","v":0},null,{"$f":"S128+S129-S130","v":0},null,{"$f":"U128+U129-U130","v":0},null,{"$f":"W128+W129-W130","v":0},null,{"$f":"Y128+Y129-Y130","v":0},null,{"$f":"AA128+AA129-AA130","v":0},null,{"$f":"AC128+AC129-AC130","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,{"$f":"E137","v":0},null,{"$f":"G137","v":0},null,{"$f":"I137","v":0},null,{"$f":"K137","v":0},null,{"$f":"M137","v":0},null,{"$f":"O137","v":0},null,{"$f":"Q137","v":0},null,{"$f":"S137","v":0},null,{"$f":"U137","v":0},null,{"$f":"W137","v":0},null,{"$f":"Y137","v":0},null,{"$f":"AA137","v":0}]
[null,null,null,"Amortization expense during year",{"$f":"-E129/'1. Cost of Service_parameters'!G56/2","v":0},null,{"$f":"-G128/'1. Cost of Service_parameters'!G56","v":0},null,{"$f":"-I128/'1. Cost of Service_parameters'!I56","v":0},null,{"$f":"-K128/'1. Cost of Service_parameters'!K56","v":0},null,{"$f":"-M128/'1. Cost of Service_parameters'!M56","v":0},null,{"$f":"-O128/'1. Cost of Service_parameters'!O56","v":0},null,{"$f":"-Q128/'1. Cost of Service_parameters'!Q56","v":0},null,{"$f":"-S128/'1. Cost of Service_parameters'!S56","v":0},null,{"$f":"-U128/'1. Cost of Service_parameters'!U56","v":0},null,{"$f":"-W128/'1. Cost of Service_parameters'!W56","v":0},null,{"$f":"-Y128/'1. Cost of Service_parameters'!Y56","v":0},null,{"$f":"-AA128/'1. Cost of Service_parameters'!AA56","v":0},null,{"$f":"-AC128/'1. Cost of Service_parameters'!AC56","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E134+E135-E136","v":0},null,{"$f":"G134+G135-G136","v":0},null,{"$f":"I134+I135-I136","v":0},null,{"$f":"K134+K135-K136","v":0},null,{"$f":"M134+M135-M136","v":0},null,{"$f":"O134+O135-O136","v":0},null,{"$f":"Q134+Q135-Q136","v":0},null,{"$f":"S134+S135-S136","v":0},null,{"$f":"U134+U135-U136","v":0},null,{"$f":"W134+W135-W136","v":0},null,{"$f":"Y134+Y135-Y136","v":0},null,{"$f":"AA134+AA135-AA136","v":0},null,{"$f":"AC134+AC135-AC136","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",{"$f":"E128+E134","v":0},null,{"$f":"E141","v":0},null,{"$f":"G141","v":0},null,{"$f":"I141","v":0},null,{"$f":"K141","v":0},null,{"$f":"M141","v":0},null,{"$f":"O141","v":0},null,{"$f":"Q141","v":0},null,{"$f":"S141","v":0},null,{"$f":"U141","v":0},null,{"$f":"W141","v":0},null,{"$f":"Y141","v":0},null,{"$f":"AA141","v":0}]
[null,null,null,"Closing Balance",{"$f":"E131+E137","v":0},null,{"$f":"G131+G137","v":0},null,{"$f":"I131+I137","v":0},null,{"$f":"K131+K137","v":0},null,{"$f":"M131+M137","v":0},null,{"$f":"O131+O137","v":0},null,{"$f":"Q131+Q137","v":0},null,{"$f":"S131+S137","v":0},null,{"$f":"U131+U137","v":0},null,{"$f":"W131+W137","v":0},null,{"$f":"Y131+Y137","v":0},null,{"$f":"AA131+AA137","v":0},null,{"$f":"AC131+AC137","v":0}]
[null,null,null,"Net Fixed Assets (NFA)",{"$f":"AVERAGE(E140:E141)","v":0},null,{"$f":"AVERAGE(G140:G141)","v":0},null,{"$f":"AVERAGE(I140:I141)","v":0},null,{"$f":"AVERAGE(K140:K141)","v":0},null,{"$f":"AVERAGE(M140:M141)","v":0},null,{"$f":"AVERAGE(O140:O141)","v":0},null,{"$f":"AVERAGE(Q140:Q141)","v":0},null,{"$f":"AVERAGE(S140:S141)","v":0},null,{"$f":"AVERAGE(U140:U141)","v":0},null,{"$f":"AVERAGE(W140:W141)","v":0},null,{"$f":"AVERAGE(Y140:Y141)","v":0},null,{"$f":"AVERAGE(AA140:AA141)","v":0},null,{"$f":"AVERAGE(AC140:AC141)","v":0}]
[]
[null,"Net Fixed Assets - 1862"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"E150","v":0},null,{"$f":"G150","v":0},null,{"$f":"I150","v":0},null,{"$f":"K150","v":0},null,{"$f":"M150","v":0},null,{"$f":"O150","v":0},null,{"$f":"Q150","v":0},null,{"$f":"S150","v":0},null,{"$f":"U150","v":0},null,{"$f":"W150","v":0},null,{"$f":"Y150","v":0},null,{"$f":"AA150","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E147+E148-E149","v":0},null,{"$f":"G147+G148-G149","v":0},null,{"$f":"I147+I148-I149","v":0},null,{"$f":"K147+K148-K149","v":0},null,{"$f":"M147+M148-M149","v":0},null,{"$f":"O147+O148-O149","v":0},null,{"$f":"Q147+Q148-Q149","v":0},null,{"$f":"S147+S148-S149","v":0},null,{"$f":"U147+U148-U149","v":0},null,{"$f":"W147+W148-W149","v":0},null,{"$f":"Y147+Y148-Y149","v":0},null,{"$f":"AA147+AA148-AA149","v":0},null,{"$f":"AC147+AC148-AC149","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,{"$f":"E156","v":0},null,{"$f":"G156","v":0},null,{"$f":"I156","v":0},null,{"$f":"K156","v":0},null,{"$f":"M156","v":0},null,{"$f":"O156","v":0},null,{"$f":"Q156","v":0},null,{"$f":"S156","v":0},null,{"$f":"U156","v":0},null,{"$f":"W156","v":0},null,{"$f":"Y156","v":0},null,{"$f":"AA156","v":0}]
[null,null,null,"Amortization expense during year",{"$f":"-E148/'1. Cost of Service_parameters'!G59/2","v":0},null,{"$f":"-G147/'1. Cost of Service_parameters'!G59","v":0},null,{"$f":"-I147/'1. Cost of Service_parameters'!I59","v":0},null,{"$f":"-K147/'1. Cost of Service_parameters'!K59","v":0},null,{"$f":"-M147/'1. Cost of Service_parameters'!M59","v":0},null,{"$f":"-O147/'1. Cost of Service_parameters'!O59","v":0},null,{"$f":"-Q147/'1. Cost of Service_parameters'!Q59","v":0},null,{"$f":"-S147/'1. Cost of Service_parameters'!S59","v":0},null,{"$f":"-U147/'1. Cost of Service_parameters'!U59","v":0},null,{"$f":"-W147/'1. Cost of Service_parameters'!W59","v":0},null,{"$f":"-Y147/'1. Cost of Service_parameters'!Y59","v":0},null,{"$f":"-AA147/'1. Cost of Service_parameters'!AA59","v":0},null,{"$f":"-AC147/'1. Cost of Service_parameters'!AC59","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E153+E154-E155","v":0},null,{"$f":"G153+G154-G155","v":0},null,{"$f":"I153+I154-I155","v":0},null,{"$f":"K153+K154-K155","v":0},null,{"$f":"M153+M154-M155","v":0},null,{"$f":"O153+O154-O155","v":0},null,{"$f":"Q153+Q154-Q155","v":0},null,{"$f":"S153+S154-S155","v":0},null,{"$f":"U153+U154-U155","v":0},null,{"$f":"W153+W154-W155","v":0},null,{"$f":"Y153+Y154-Y155","v":0},null,{"$f":"AA153+AA154-AA155","v":0},null,{"$f":"AC153+AC154-AC155","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",{"$f":"E147+E153","v":0},null,{"$f":"E160","v":0},null,{"$f":"G160","v":0},null,{"$f":"I160","v":0},null,{"$f":"K160","v":0},null,{"$f":"M160","v":0},null,{"$f":"O160","v":0},null,{"$f":"Q160","v":0},null,{"$f":"S160","v":0},null,{"$f":"U160","v":0},null,{"$f":"W160","v":0},null,{"$f":"Y160","v":0},null,{"$f":"AA160","v":0}]
[null,null,null,"Closing Balance",{"$f":"E150+E156","v":0},null,{"$f":"G150+G156","v":0},null,{"$f":"I150+I156","v":0},null,{"$f":"K150+K156","v":0},null,{"$f":"M150+M156","v":0},null,{"$f":"O150+O156","v":0},null,{"$f":"Q150+Q156","v":0},null,{"$f":"S150+S156","v":0},null,{"$f":"U150+U156","v":0},null,{"$f":"W150+W156","v":0},null,{"$f":"Y150+Y156","v":0},null,{"$f":"AA150+AA156","v":0},null,{"$f":"AC150+AC156","v":0}]
[null,null,null,"Net Fixed Assets (NFA)",{"$f":"AVERAGE(E159:E160)","v":0},null,{"$f":"AVERAGE(G159:G160)","v":0},null,{"$f":"AVERAGE(I159:I160)","v":0},null,{"$f":"AVERAGE(K159:K160)","v":0},null,{"$f":"AVERAGE(M159:M160)","v":0},null,{"$f":"AVERAGE(O159:O160)","v":0},null,{"$f":"AVERAGE(Q159:Q160)","v":0},null,{"$f":"AVERAGE(S159:S160)","v":0},null,{"$f":"AVERAGE(U159:U160)","v":0},null,{"$f":"AVERAGE(W159:W160)","v":0},null,{"$f":"AVERAGE(Y159:Y160)","v":0},null,{"$f":"AVERAGE(AA159:AA160)","v":0},null,{"$f":"AVERAGE(AC159:AC160)","v":0}]
[]
[null,"Net Fixed Assets - 1924"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"E169","v":0},null,{"$f":"G169","v":0},null,{"$f":"I169","v":0},null,{"$f":"K169","v":0},null,{"$f":"M169","v":0},null,{"$f":"O169","v":0},null,{"$f":"Q169","v":0},null,{"$f":"S169","v":0},null,{"$f":"U169","v":0},null,{"$f":"W169","v":0},null,{"$f":"Y169","v":0},null,{"$f":"AA169","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)"]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E166+E167-E168","v":0},null,{"$f":"G166+G167-G168","v":0},null,{"$f":"I166+I167-I168","v":0},null,{"$f":"K166+K167-K168","v":0},null,{"$f":"M166+M167-M168","v":0},null,{"$f":"O166+O167-O168","v":0},null,{"$f":"Q166+Q167-Q168","v":0},null,{"$f":"S166+S167-S168","v":0},null,{"$f":"U166+U167-U168","v":0},null,{"$f":"W166+W167-W168","v":0},null,{"$f":"Y166+Y167-Y168","v":0},null,{"$f":"AA166+AA167-AA168","v":0},null,{"$f":"AC166+AC167-AC168","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,{"$f":"E175","v":0},null,{"$f":"G175","v":0},null,{"$f":"I175","v":0},null,{"$f":"K175","v":0},null,{"$f":"M175","v":0},null,{"$f":"O175","v":0},null,{"$f":"Q175","v":0},null,{"$f":"S175","v":0},null,{"$f":"U175","v":0},null,{"$f":"W175","v":0},null,{"$f":"Y175","v":0},null,{"$f":"AA175","v":0}]
[null,null,null,"Amortization expense during year",{"$f":"-E167/'1. Cost of Service_parameters'!G62/2","v":0},null,{"$f":"-G166/'1. Cost of Service_parameters'!G62-'2. MIST Meters Assets_Rate Base'!G167/'1. Cost of Service_parameters'!G62/2","v":0},null,{"$f":"-I166/'1. Cost of Service_parameters'!I62-'2. MIST Meters Assets_Rate Base'!I167/'1. Cost of Service_parameters'!I62/2","v":0},null,{"$f":"-K166/'1. Cost of Service_parameters'!K62-'2. MIST Meters Assets_Rate Base'!K167/'1. Cost of Service_parameters'!K62/2","v":0},null,{"$f":"-M166/'1. Cost of Service_parameters'!M62-'2. MIST Meters Assets_Rate Base'!M167/'1. Cost of Service_parameters'!M62/2","v":0},null,{"$f":"-O166/'1. Cost of Service_parameters'!O62-'2. MIST Meters Assets_Rate Base'!O167/'1. Cost of Service_parameters'!O62/2","v":0},null,{"$f":"-Q166/'1. Cost of Service_parameters'!Q62-'2. MIST Meters Assets_Rate Base'!Q167/'1. Cost of Service_parameters'!Q62/2","v":0},null,{"$f":"-S166/'1. Cost of Service_parameters'!S62-'2. MIST Meters Assets_Rate Base'!S167/'1. Cost of Service_parameters'!S62/2","v":0},null,{"$f":"-U166/'1. Cost of Service_parameters'!U62-'2. MIST Meters Assets_Rate Base'!U167/'1. Cost of Service_parameters'!U62/2","v":0},null,{"$f":"-W166/'1. Cost of Service_parameters'!W62-'2. MIST Meters Assets_Rate Base'!W167/'1. Cost of Service_parameters'!W62/2","v":0},null,{"$f":"-Y166/'1. Cost of Service_parameters'!Y62-'2. MIST Meters Assets_Rate Base'!Y167/'1. Cost of Service_parameters'!Y62/2","v":0},null,{"$f":"-AA166/'1. Cost of Service_parameters'!AA62-'2. MIST Meters Assets_Rate Base'!AA167/'1. Cost of Service_parameters'!AA62/2","v":0},null,{"$f":"-AC166/'1. Cost of Service_parameters'!AC62-'2. MIST Meters Assets_Rate Base'!AC167/'1. Cost of Service_parameters'!AC62/2","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E172+E173-E174","v":0},null,{"$f":"G172+G173-G174","v":0},null,{"$f":"I172+I173-I174","v":0},null,{"$f":"K172+K173-K174","v":0},null,{"$f":"M172+M173-M174","v":0},null,{"$f":"O172+O173-O174","v":0},null,{"$f":"Q172+Q173-Q174","v":0},null,{"$f":"S172+S173-S174","v":0},null,{"$f":"U172+U173-U174","v":0},null,{"$f":"W172+W173-W174","v":0},null,{"$f":"Y172+Y173-Y174","v":0},null,{"$f":"AA172+AA173-AA174","v":0},null,{"$f":"AC172+AC173-AC174","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",{"$f":"E166+E172","v":0},null,{"$f":"E179","v":0},null,{"$f":"G179","v":0},null,{"$f":"I179","v":0},null,{"$f":"K179","v":0},null,{"$f":"M179","v":0},null,{"$f":"O179","v":0},null,{"$f":"Q179","v":0},null,{"$f":"S179","v":0},null,{"$f":"U179","v":0},null,{"$f":"W179","v":0},null,{"$f":"Y179","v":0},null,{"$f":"AA179","v":0}]
[null,null,null,"Closing Balance",{"$f":"E169+E175","v":0},null,{"$f":"G169+G175","v":0},null,{"$f":"I169+I175","v":0},null,{"$f":"K169+K175","v":0},null,{"$f":"M169+M175","v":0},null,{"$f":"O169+O175","v":0},null,{"$f":"Q169+Q175","v":0},null,{"$f":"S169+S175","v":0},null,{"$f":"U169+U175","v":0},null,{"$f":"W169+W175","v":0},null,{"$f":"Y169+Y175","v":0},null,{"$f":"AA169+AA175","v":0},null,{"$f":"AC169+AC175","v":0}]
[null,null,null,"Net Fixed Assets (NFA)",{"$f":"AVERAGE(E178:E179)","v":0},null,{"$f":"AVERAGE(G178:G179)","v":0},null,{"$f":"AVERAGE(I178:I179)","v":0},null,{"$f":"AVERAGE(K178:K179)","v":0},null,{"$f":"AVERAGE(M178:M179)","v":0},null,{"$f":"AVERAGE(O178:O179)","v":0},null,{"$f":"AVERAGE(Q178:Q179)","v":0},null,{"$f":"AVERAGE(S178:S179)","v":0},null,{"$f":"AVERAGE(U178:U179)","v":0},null,{"$f":"AVERAGE(W178:W179)","v":0},null,{"$f":"AVERAGE(Y178:Y179)","v":0},null,{"$f":"AVERAGE(AA178:AA179)","v":0},null,{"$f":"AVERAGE(AC178:AC179)","v":0}]
[]
[]
[null,"Net Fixed Assets - 1850"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"E189","v":0},null,{"$f":"G189","v":0},null,{"$f":"I189","v":0},null,{"$f":"K189","v":0},null,{"$f":"M189","v":0},null,{"$f":"O189","v":0},null,{"$f":"Q189","v":0},null,{"$f":"S189","v":0},null,{"$f":"U189","v":0},null,{"$f":"W189","v":0},null,{"$f":"Y189","v":0},null,{"$f":"AA189","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)"]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E186+E187-E188","v":0},null,{"$f":"G186+G187-G188","v":0},null,{"$f":"I186+I187-I188","v":0},null,{"$f":"K186+K187-K188","v":0},null,{"$f":"M186+M187-M188","v":0},null,{"$f":"O186+O187-O188","v":0},null,{"$f":"Q186+Q187-Q188","v":0},null,{"$f":"S186+S187-S188","v":0},null,{"$f":"U186+U187-U188","v":0},null,{"$f":"W186+W187-W188","v":0},null,{"$f":"Y186+Y187-Y188","v":0},null,{"$f":"AA186+AA187-AA188","v":0},null,{"$f":"AC186+AC187-AC188","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,{"$f":"E195","v":0},null,{"$f":"G195","v":0},null,{"$f":"I195","v":0},null,{"$f":"K195","v":0},null,{"$f":"M195","v":0},null,{"$f":"O195","v":0},null,{"$f":"Q195","v":0},null,{"$f":"S195","v":0},null,{"$f":"U195","v":0},null,{"$f":"W195","v":0},null,{"$f":"Y195","v":0},null,{"$f":"AA195","v":0}]
[null,null,null,"Amortization expense during year",{"$f":"-E187/'1. Cost of Service_parameters'!G65/2","v":0},null,{"$f":"-G186/'1. Cost of Service_parameters'!G65-'2. MIST Meters Assets_Rate Base'!G187/'1. Cost of Service_parameters'!G65/2","v":0},null,{"$f":"-I186/'1. Cost of Service_parameters'!I65-'2. MIST Meters Assets_Rate Base'!I187/'1. Cost of Service_parameters'!I65/2","v":0},null,{"$f":"-K186/'1. Cost of Service_parameters'!K65-'2. MIST Meters Assets_Rate Base'!K187/'1. Cost of Service_parameters'!K65/2","v":0},null,{"$f":"-M186/'1. Cost of Service_parameters'!M65-'2. MIST Meters Assets_Rate Base'!M187/'1. Cost of Service_parameters'!M65/2","v":0},null,{"$f":"-O186/'1. Cost of Service_parameters'!O65-'2. MIST Meters Assets_Rate Base'!O187/'1. Cost of Service_parameters'!O65/2","v":0},null,{"$f":"-Q186/'1. Cost of Service_parameters'!Q65-'2. MIST Meters Assets_Rate Base'!Q187/'1. Cost of Service_parameters'!Q65/2","v":0},null,{"$f":"-S186/'1. Cost of Service_parameters'!S65-'2. MIST Meters Assets_Rate Base'!S187/'1. Cost of Service_parameters'!S65/2","v":0},null,{"$f":"-U186/'1. Cost of Service_parameters'!U65-'2. MIST Meters Assets_Rate Base'!U187/'1. Cost of Service_parameters'!U65/2","v":0},null,{"$f":"-W186/'1. Cost of Service_parameters'!W65-'2. MIST Meters Assets_Rate Base'!W187/'1. Cost of Service_parameters'!W65/2","v":0},null,{"$f":"-Y186/'1. Cost of Service_parameters'!Y65-'2. MIST Meters Assets_Rate Base'!Y187/'1. Cost of Service_parameters'!Y65/2","v":0},null,{"$f":"-AA186/'1. Cost of Service_parameters'!AA65-'2. MIST Meters Assets_Rate Base'!AA187/'1. Cost of Service_parameters'!AA65/2","v":0},null,{"$f":"-AC186/'1. Cost of Service_parameters'!AC65-'2. MIST Meters Assets_Rate Base'!AC187/'1. Cost of Service_parameters'!AC65/2","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E192+E193-E194","v":0},null,{"$f":"G192+G193-G194","v":0},null,{"$f":"I192+I193-I194","v":0},null,{"$f":"K192+K193-K194","v":0},null,{"$f":"M192+M193-M194","v":0},null,{"$f":"O192+O193-O194","v":0},null,{"$f":"Q192+Q193-Q194","v":0},null,{"$f":"S192+S193-S194","v":0},null,{"$f":"U192+U193-U194","v":0},null,{"$f":"W192+W193-W194","v":0},null,{"$f":"Y192+Y193-Y194","v":0},null,{"$f":"AA192+AA193-AA194","v":0},null,{"$f":"AC192+AC193-AC194","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",{"$f":"E186+E192","v":0},null,{"$f":"E199","v":0},null,{"$f":"G199","v":0},null,{"$f":"I199","v":0},null,{"$f":"K199","v":0},null,{"$f":"M199","v":0},null,{"$f":"O199","v":0},null,{"$f":"Q199","v":0},null,{"$f":"S199","v":0},null,{"$f":"U199","v":0},null,{"$f":"W199","v":0},null,{"$f":"Y199","v":0},null,{"$f":"AA199","v":0}]
[null,null,null,"Closing Balance",{"$f":"E189+E195","v":0},null,{"$f":"G189+G195","v":0},null,{"$f":"I189+I195","v":0},null,{"$f":"K189+K195","v":0},null,{"$f":"M189+M195","v":0},null,{"$f":"O189+O195","v":0},null,{"$f":"Q189+Q195","v":0},null,{"$f":"S189+S195","v":0},null,{"$f":"U189+U195","v":0},null,{"$f":"W189+W195","v":0},null,{"$f":"Y189+Y195","v":0},null,{"$f":"AA189+AA195","v":0},null,{"$f":"AC189+AC195","v":0}]
[null,null,null,"Net Fixed Assets (NFA)",{"$f":"AVERAGE(E198:E199)","v":0},null,{"$f":"AVERAGE(G198:G199)","v":0},null,{"$f":"AVERAGE(I198:I199)","v":0},null,{"$f":"AVERAGE(K198:K199)","v":0},null,{"$f":"AVERAGE(M198:M199)","v":0},null,{"$f":"AVERAGE(O198:O199)","v":0},null,{"$f":"AVERAGE(Q198:Q199)","v":0},null,{"$f":"AVERAGE(S198:S199)","v":0},null,{"$f":"AVERAGE(U198:U199)","v":0},null,{"$f":"AVERAGE(W198:W199)","v":0},null,{"$f":"AVERAGE(Y198:Y199)","v":0},null,{"$f":"AVERAGE(AA198:AA199)","v":0},null,{"$f":"AVERAGE(AC198:AC199)","v":0}]
[]
[]
[null,"Net Fixed Assets - 1982"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"E209","v":0},null,{"$f":"G209","v":0},null,{"$f":"I209","v":0},null,{"$f":"K209","v":0},null,{"$f":"M209","v":0},null,{"$f":"O209","v":0},null,{"$f":"Q209","v":0},null,{"$f":"S209","v":0},null,{"$f":"U209","v":0},null,{"$f":"W209","v":0},null,{"$f":"Y209","v":0},null,{"$f":"AA209","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)"]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E206+E207-E208","v":0},null,{"$f":"G206+G207-G208","v":0},null,{"$f":"I206+I207-I208","v":0},null,{"$f":"K206+K207-K208","v":0},null,{"$f":"M206+M207-M208","v":0},null,{"$f":"O206+O207-O208","v":0},null,{"$f":"Q206+Q207-Q208","v":0},null,{"$f":"S206+S207-S208","v":0},null,{"$f":"U206+U207-U208","v":0},null,{"$f":"W206+W207-W208","v":0},null,{"$f":"Y206+Y207-Y208","v":0},null,{"$f":"AA206+AA207-AA208","v":0},null,{"$f":"AC206+AC207-AC208","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,{"$f":"E215","v":0},null,{"$f":"G215","v":0},null,{"$f":"I215","v":0},null,{"$f":"K215","v":0},null,{"$f":"M215","v":0},null,{"$f":"O215","v":0},null,{"$f":"Q215","v":0},null,{"$f":"S215","v":0},null,{"$f":"U215","v":0},null,{"$f":"W215","v":0},null,{"$f":"Y215","v":0},null,{"$f":"AA215","v":0}]
[null,null,null,"Amortization expense during year",{"$f":"-E207/'1. Cost of Service_parameters'!G68/2","v":0},null,{"$f":"-G206/'1. Cost of Service_parameters'!G68-'2. MIST Meters Assets_Rate Base'!G207/'1. Cost of Service_parameters'!G68/2","v":0},null,{"$f":"-I206/'1. Cost of Service_parameters'!I68-'2. MIST Meters Assets_Rate Base'!I207/'1. Cost of Service_parameters'!I68/2","v":0},null,{"$f":"-K206/'1. Cost of Service_parameters'!K68-'2. MIST Meters Assets_Rate Base'!K207/'1. Cost of Service_parameters'!K68/2","v":0},null,{"$f":"-M206/'1. Cost of Service_parameters'!M68-'2. MIST Meters Assets_Rate Base'!M207/'1. Cost of Service_parameters'!M68/2","v":0},null,{"$f":"-O206/'1. Cost of Service_parameters'!O68-'2. MIST Meters Assets_Rate Base'!O207/'1. Cost of Service_parameters'!O68/2","v":0},null,{"$f":"-Q206/'1. Cost of Service_parameters'!Q68-'2. MIST Meters Assets_Rate Base'!Q207/'1. Cost of Service_parameters'!Q68/2","v":0},null,{"$f":"-S206/'1. Cost of Service_parameters'!S68-'2. MIST Meters Assets_Rate Base'!S207/'1. Cost of Service_parameters'!S68/2","v":0},null,{"$f":"-U206/'1. Cost of Service_parameters'!U68-'2. MIST Meters Assets_Rate Base'!U207/'1. Cost of Service_parameters'!U68/2","v":0},null,{"$f":"-W206/'1. Cost of Service_parameters'!W68-'2. MIST Meters Assets_Rate Base'!W207/'1. Cost of Service_parameters'!W68/2","v":0},null,{"$f":"-Y206/'1. Cost of Service_parameters'!Y68-'2. MIST Meters Assets_Rate Base'!Y207/'1. Cost of Service_parameters'!Y68/2","v":0},null,{"$f":"-AA206/'1. Cost of Service_parameters'!AA68-'2. MIST Meters Assets_Rate Base'!AA207/'1. Cost of Service_parameters'!AA68/2","v":0},null,{"$f":"-AC206/'1. Cost of Service_parameters'!AC68-'2. MIST Meters Assets_Rate Base'!AC207/'1. Cost of Service_parameters'!AC68/2","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E212+E213-E214","v":0},null,{"$f":"G212+G213-G214","v":0},null,{"$f":"I212+I213-I214","v":0},null,{"$f":"K212+K213-K214","v":0},null,{"$f":"M212+M213-M214","v":0},null,{"$f":"O212+O213-O214","v":0},null,{"$f":"Q212+Q213-Q214","v":0},null,{"$f":"S212+S213-S214","v":0},null,{"$f":"U212+U213-U214","v":0},null,{"$f":"W212+W213-W214","v":0},null,{"$f":"Y212+Y213-Y214","v":0},null,{"$f":"AA212+AA213-AA214","v":0},null,{"$f":"AC212+AC213-AC214","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",{"$f":"E206+E212","v":0},null,{"$f":"E219","v":0},null,{"$f":"G219","v":0},null,{"$f":"I219","v":0},null,{"$f":"K219","v":0},null,{"$f":"M219","v":0},null,{"$f":"O219","v":0},null,{"$f":"Q219","v":0},null,{"$f":"S219","v":0},null,{"$f":"U219","v":0},null,{"$f":"W219","v":0},null,{"$f":"Y219","v":0},null,{"$f":"AA219","v":0}]
[null,null,null,"Closing Balance",{"$f":"E209+E215","v":0},null,{"$f":"G209+G215","v":0},null,{"$f":"I209+I215","v":0},null,{"$f":"K209+K215","v":0},null,{"$f":"M209+M215","v":0},null,{"$f":"O209+O215","v":0},null,{"$f":"Q209+Q215","v":0},null,{"$f":"S209+S215","v":0},null,{"$f":"U209+U215","v":0},null,{"$f":"W209+W215","v":0},null,{"$f":"Y209+Y215","v":0},null,{"$f":"AA209+AA215","v":0},null,{"$f":"AC209+AC215","v":0}]
[null,null,null,"Net Fixed Assets (NFA)",{"$f":"AVERAGE(E218:E219)","v":0},null,{"$f":"AVERAGE(G218:G219)","v":0},null,{"$f":"AVERAGE(I218:I219)","v":0},null,{"$f":"AVERAGE(K218:K219)","v":0},null,{"$f":"AVERAGE(M218:M219)","v":0},null,{"$f":"AVERAGE(O218:O219)","v":0},null,{"$f":"AVERAGE(Q218:Q219)","v":0},null,{"$f":"AVERAGE(S218:S219)","v":0},null,{"$f":"AVERAGE(U218:U219)","v":0},null,{"$f":"AVERAGE(W218:W219)","v":0},null,{"$f":"AVERAGE(Y218:Y219)","v":0},null,{"$f":"AVERAGE(AA218:AA219)","v":0},null,{"$f":"AVERAGE(AC218:AC219)","v":0}]
[]
[]
[null,"Net Fixed Assets - 1955"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"E229","v":0},null,{"$f":"G229","v":0},null,{"$f":"I229","v":0},null,{"$f":"K229","v":0},null,{"$f":"M229","v":0},null,{"$f":"O229","v":0},null,{"$f":"Q229","v":0},null,{"$f":"S229","v":0},null,{"$f":"U229","v":0},null,{"$f":"W229","v":0},null,{"$f":"Y229","v":0},null,{"$f":"AA229","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)"]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E226+E227-E228","v":0},null,{"$f":"G226+G227-G228","v":0},null,{"$f":"I226+I227-I228","v":0},null,{"$f":"K226+K227-K228","v":0},null,{"$f":"M226+M227-M228","v":0},null,{"$f":"O226+O227-O228","v":0},null,{"$f":"Q226+Q227-Q228","v":0},null,{"$f":"S226+S227-S228","v":0},null,{"$f":"U226+U227-U228","v":0},null,{"$f":"W226+W227-W228","v":0},null,{"$f":"Y226+Y227-Y228","v":0},null,{"$f":"AA226+AA227-AA228","v":0},null,{"$f":"AC226+AC227-AC228","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,{"$f":"E235","v":0},null,{"$f":"G235","v":0},null,{"$f":"I235","v":0},null,{"$f":"K235","v":0},null,{"$f":"M235","v":0},null,{"$f":"O235","v":0},null,{"$f":"Q235","v":0},null,{"$f":"S235","v":0},null,{"$f":"U235","v":0},null,{"$f":"W235","v":0},null,{"$f":"Y235","v":0},null,{"$f":"AA235","v":0}]
[null,null,null,"Amortization expense during year",{"$f":"-E227/'1. Cost of Service_parameters'!G71/2","v":0},null,{"$f":"-G226/'1. Cost of Service_parameters'!G71-'2. MIST Meters Assets_Rate Base'!G227/'1. Cost of Service_parameters'!G71/2","v":0},null,{"$f":"-I226/'1. Cost of Service_parameters'!I71-'2. MIST Meters Assets_Rate Base'!I227/'1. Cost of Service_parameters'!I71/2","v":0},null,{"$f":"-K226/'1. Cost of Service_parameters'!K71-'2. MIST Meters Assets_Rate Base'!K227/'1. Cost of Service_parameters'!K71/2","v":0},null,{"$f":"-M226/'1. Cost of Service_parameters'!M71-'2. MIST Meters Assets_Rate Base'!M227/'1. Cost of Service_parameters'!M71/2","v":0},null,{"$f":"-O226/'1. Cost of Service_parameters'!O71-'2. MIST Meters Assets_Rate Base'!O227/'1. Cost of Service_parameters'!O71/2","v":0},null,{"$f":"-Q226/'1. Cost of Service_parameters'!Q71-'2. MIST Meters Assets_Rate Base'!Q227/'1. Cost of Service_parameters'!Q71/2","v":0},null,{"$f":"-S226/'1. Cost of Service_parameters'!S71-'2. MIST Meters Assets_Rate Base'!S227/'1. Cost of Service_parameters'!S71/2","v":0},null,{"$f":"-U226/'1. Cost of Service_parameters'!U71-'2. MIST Meters Assets_Rate Base'!U227/'1. Cost of Service_parameters'!U71/2","v":0},null,{"$f":"-W226/'1. Cost of Service_parameters'!W71-'2. MIST Meters Assets_Rate Base'!W227/'1. Cost of Service_parameters'!W71/2","v":0},null,{"$f":"-Y226/'1. Cost of Service_parameters'!Y71-'2. MIST Meters Assets_Rate Base'!Y227/'1. Cost of Service_parameters'!Y71/2","v":0},null,{"$f":"-AA226/'1. Cost of Service_parameters'!AA71-'2. MIST Meters Assets_Rate Base'!AA227/'1. Cost of Service_parameters'!AA71/2","v":0},null,{"$f":"-AC226/'1. Cost of Service_parameters'!AC71-'2. MIST Meters Assets_Rate Base'!AC227/'1. Cost of Service_parameters'!AC71/2","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E232+E233-E234","v":0},null,{"$f":"G232+G233-G234","v":0},null,{"$f":"I232+I233-I234","v":0},null,{"$f":"K232+K233-K234","v":0},null,{"$f":"M232+M233-M234","v":0},null,{"$f":"O232+O233-O234","v":0},null,{"$f":"Q232+Q233-Q234","v":0},null,{"$f":"S232+S233-S234","v":0},null,{"$f":"U232+U233-U234","v":0},null,{"$f":"W232+W233-W234","v":0},null,{"$f":"Y232+Y233-Y234","v":0},null,{"$f":"AA232+AA233-AA234","v":0},null,{"$f":"AC232+AC233-AC234","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",{"$f":"E226+E232","v":0},null,{"$f":"E239","v":0},null,{"$f":"G239","v":0},null,{"$f":"I239","v":0},null,{"$f":"K239","v":0},null,{"$f":"M239","v":0},null,{"$f":"O239","v":0},null,{"$f":"Q239","v":0},null,{"$f":"S239","v":0},null,{"$f":"U239","v":0},null,{"$f":"W239","v":0},null,{"$f":"Y239","v":0},null,{"$f":"AA239","v":0}]
[null,null,null,"Closing Balance",{"$f":"E229+E235","v":0},null,{"$f":"G229+G235","v":0},null,{"$f":"I229+I235","v":0},null,{"$f":"K229+K235","v":0},null,{"$f":"M229+M235","v":0},null,{"$f":"O229+O235","v":0},null,{"$f":"Q229+Q235","v":0},null,{"$f":"S229+S235","v":0},null,{"$f":"U229+U235","v":0},null,{"$f":"W229+W235","v":0},null,{"$f":"Y229+Y235","v":0},null,{"$f":"AA229+AA235","v":0},null,{"$f":"AC229+AC235","v":0}]
[null,null,null,"Net Fixed Assets (NFA)",{"$f":"AVERAGE(E238:E239)","v":0},null,{"$f":"AVERAGE(G238:G239)","v":0},null,{"$f":"AVERAGE(I238:I239)","v":0},null,{"$f":"AVERAGE(K238:K239)","v":0},null,{"$f":"AVERAGE(M238:M239)","v":0},null,{"$f":"AVERAGE(O238:O239)","v":0},null,{"$f":"AVERAGE(Q238:Q239)","v":0},null,{"$f":"AVERAGE(S238:S239)","v":0},null,{"$f":"AVERAGE(U238:U239)","v":0},null,{"$f":"AVERAGE(W238:W239)","v":0},null,{"$f":"AVERAGE(Y238:Y239)","v":0},null,{"$f":"AVERAGE(AA238:AA239)","v":0},null,{"$f":"AVERAGE(AC238:AC239)","v":0}]
[]
[]
[null,"Net Fixed Assets - "]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"E249","v":0},null,{"$f":"G249","v":0},null,{"$f":"I249","v":0},null,{"$f":"K249","v":0},null,{"$f":"M249","v":0},null,{"$f":"O249","v":0},null,{"$f":"Q249","v":0},null,{"$f":"S249","v":0},null,{"$f":"U249","v":0},null,{"$f":"W249","v":0},null,{"$f":"Y249","v":0},null,{"$f":"AA249","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)"]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E246+E247-E248","v":0},null,{"$f":"G246+G247-G248","v":0},null,{"$f":"I246+I247-I248","v":0},null,{"$f":"K246+K247-K248","v":0},null,{"$f":"M246+M247-M248","v":0},null,{"$f":"O246+O247-O248","v":0},null,{"$f":"Q246+Q247-Q248","v":0},null,{"$f":"S246+S247-S248","v":0},null,{"$f":"U246+U247-U248","v":0},null,{"$f":"W246+W247-W248","v":0},null,{"$f":"Y246+Y247-Y248","v":0},null,{"$f":"AA246+AA247-AA248","v":0},null,{"$f":"AC246+AC247-AC248","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,{"$f":"E255","v":0},null,{"$f":"G255","v":0},null,{"$f":"I255","v":0},null,{"$f":"K255","v":0},null,{"$f":"M255","v":0},null,{"$f":"O255","v":0},null,{"$f":"Q255","v":0},null,{"$f":"S255","v":0},null,{"$f":"U255","v":0},null,{"$f":"W255","v":0},null,{"$f":"Y255","v":0},null,{"$f":"AA255","v":0}]
[null,null,null,"Amortization expense during year",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E252+E253-E254","v":0},null,{"$f":"G252+G253-G254","v":0},null,{"$f":"I252+I253-I254","v":0},null,{"$f":"K252+K253-K254","v":0},null,{"$f":"M252+M253-M254","v":0},null,{"$f":"O252+O253-O254","v":0},null,{"$f":"Q252+Q253-Q254","v":0},null,{"$f":"S252+S253-S254","v":0},null,{"$f":"U252+U253-U254","v":0},null,{"$f":"W252+W253-W254","v":0},null,{"$f":"Y252+Y253-Y254","v":0},null,{"$f":"AA252+AA253-AA254","v":0},null,{"$f":"AC252+AC253-AC254","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",{"$f":"E246+E252","v":0},null,{"$f":"E259","v":0},null,{"$f":"G259","v":0},null,{"$f":"I259","v":0},null,{"$f":"K259","v":0},null,{"$f":"M259","v":0},null,{"$f":"O259","v":0},null,{"$f":"Q259","v":0},null,{"$f":"S259","v":0},null,{"$f":"U259","v":0},null,{"$f":"W259","v":0},null,{"$f":"Y259","v":0},null,{"$f":"AA259","v":0}]
[null,null,null,"Closing Balance",{"$f":"E249+E255","v":0},null,{"$f":"G249+G255","v":0},null,{"$f":"I249+I255","v":0},null,{"$f":"K249+K255","v":0},null,{"$f":"M249+M255","v":0},null,{"$f":"O249+O255","v":0},null,{"$f":"Q249+Q255","v":0},null,{"$f":"S249+S255","v":0},null,{"$f":"U249+U255","v":0},null,{"$f":"W249+W255","v":0},null,{"$f":"Y249+Y255","v":0},null,{"$f":"AA249+AA255","v":0},null,{"$f":"AC249+AC255","v":0}]
[null,null,null,"Incremental CAPEX",{"$f":"E259","v":0},null,{"$f":"AVERAGE(G258:G259)","v":0},null,{"$f":"AVERAGE(I258:I259)","v":0},null,{"$f":"AVERAGE(K258:K259)","v":0},null,{"$f":"AVERAGE(M258:M259)","v":0},null,{"$f":"AVERAGE(O258:O259)","v":0},null,{"$f":"AVERAGE(Q258:Q259)","v":0},null,{"$f":"AVERAGE(S258:S259)","v":0},null,{"$f":"AVERAGE(U258:U259)","v":0},null,{"$f":"AVERAGE(W258:W259)","v":0},null,{"$f":"AVERAGE(Y258:Y259)","v":0},null,{"$f":"AVERAGE(AA258:AA259)","v":0},null,{"$f":"AVERAGE(AC258:AC259)","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,null,"Additions",{"$f":"E15+E34+E53+E72+E91+E110+E129+E148+E167+E187+E207+E227+E247","v":413818.66},{"$f":"F15+F34+F53+F72+F91+F110+F129+F148+F167+F187+F207+F227+F247","v":0},{"$f":"G15+G34+G53+G72+G91+G110+G129+G148+G167+G187+G207+G227+G247","v":831556.58},null,{"$f":"I15+I34+I53+I72+I91+I110+I129+I148+I167+I187+I207+I227+I247","v":764158.93},null,{"$f":"K15+K34+K53+K72+K91+K110+K129+K148+K167+K187+K207+K227+K247","v":931963.22},null,{"$f":"M15+M34+M53+M72+M91+M110+M129+M148+M167+M187+M207+M227+M247","v":20867.2},null,{"$f":"O15+O34+O53+O72+O91+O110+O129+O148+O167+O187+O207+O227+O247","v":0},null,{"$f":"Q15+Q34+Q53+Q72+Q91+Q110+Q129+Q148+Q167+Q187+Q207+Q227+Q247","v":0},null,{"$f":"S15+S34+S53+S72+S91+S110+S129+S148+S167+S187+S207+S227+S247","v":0},null,{"$f":"U15+U34+U53+U72+U91+U110+U129+U148+U167+U187+U207+U227+U247","v":0},null,{"$f":"W15+W34+W53+W72+W91+W110+W129+W148+W167+W187+W207+W227+W247","v":0},null,{"$f":"Y15+Y34+Y53+Y72+Y91+Y110+Y129+Y148+Y167+Y187+Y207+Y227+Y247","v":0},null,{"$f":"AA15+AA34+AA53+AA72+AA91+AA110+AA129+AA148+AA167+AA187+AA207+AA227+AA247","v":0},null,{"$f":"AC15+AC34+AC53+AC72+AC91+AC110+AC129+AC148+AC167+AC187+AC207+AC227+AC247","v":0}]
[null,null,null,"Net Fixed Assets (NFA)",{"$f":"E28+E47+E66+E85+E104+E123+E142+E161+E180+E200+E220+E240+E260","v":200012.34999999998},{"$f":"F28+F47+F66+F85+F104+F123+F142+F161+F180+F200+F220+F240+F260","v":0},{"$f":"G28+G47+G66+G85+G104+G123+G142+G161+G180+G200+G220+G240+G260","v":788149.76000000001},null,{"$f":"I28+I47+I66+I85+I104+I123+I142+I161+I180+I200+I220+I240+I260","v":1504105.7949999999},null,{"$f":"K28+K47+K66+K85+K104+K123+K142+K161+K180+K200+K220+K240+K260","v":2215401.1849999996},null,{"$f":"M28+M47+M66+M85+M104+M123+M142+M161+M180+M200+M220+M240+M260","v":2510901.5049999999},null,{"$f":"O28+O47+O66+O85+O104+O123+O142+O161+O180+O200+O220+O240+O260","v":2314824.33},null,{"$f":"Q28+Q47+Q66+Q85+Q104+Q123+Q142+Q161+Q180+Q200+Q220+Q240+Q260","v":2098598.17},null,{"$f":"S28+S47+S66+S85+S104+S123+S142+S161+S180+S200+S220+S240+S260","v":1882372.0099999998},null,{"$f":"U28+U47+U66+U85+U104+U123+U142+U161+U180+U200+U220+U240+U260","v":1666145.85},null,{"$f":"W28+W47+W66+W85+W104+W123+W142+W161+W180+W200+W220+W240+W260","v":1449919.69},null,{"$f":"Y28+Y47+Y66+Y85+Y104+Y123+Y142+Y161+Y180+Y200+Y220+Y240+Y260","v":1233693.5300000003},null,{"$f":"AA28+AA47+AA66+AA85+AA104+AA123+AA142+AA161+AA180+AA200+AA220+AA240+AA260","v":1017467.3700000002},null,{"$f":"AC28+AC47+AC66+AC85+AC104+AC123+AC142+AC161+AC180+AC200+AC220+AC240+AC260","v":801241.21000000031}]
[null,null,null,"Total Amortization",{"$f":"E21+E40+E59+E78+E97+E116+E135+E154+E173+E193+E213+E233+E253","v":-13793.96},{"$f":"F21+F40+F59+F78+F97+F116+F135+F154+F173+F193+F213+F233+F253","v":0},{"$f":"G21+G40+G59+G78+G97+G116+G135+G154+G173+G193+G213+G233+G253","v":-55306.46},null,{"$f":"I21+I40+I59+I78+I97+I116+I135+I154+I173+I193+I213+I233+I253","v":-108496.98},null,{"$f":"K21+K40+K59+K78+K97+K116+K135+K154+K173+K193+K213+K233+K253","v":-165034.39000000001},null,{"$f":"M21+M40+M59+M78+M97+M116+M135+M154+M173+M193+M213+M233+M253","v":-196795.39},null,{"$f":"O21+O40+O59+O78+O97+O116+O135+O154+O173+O193+O213+O233+O253","v":-216226.15999999992},null,{"$f":"Q21+Q40+Q59+Q78+Q97+Q116+Q135+Q154+Q173+Q193+Q213+Q233+Q253","v":-216226.16},null,{"$f":"S21+S40+S59+S78+S97+S116+S135+S154+S173+S193+S213+S233+S253","v":-216226.15999999992},null,{"$f":"U21+U40+U59+U78+U97+U116+U135+U154+U173+U193+U213+U233+U253","v":-216226.16},null,{"$f":"W21+W40+W59+W78+W97+W116+W135+W154+W173+W193+W213+W233+W253","v":-216226.16},null,{"$f":"Y21+Y40+Y59+Y78+Y97+Y116+Y135+Y154+Y173+Y193+Y213+Y233+Y253","v":-216226.16},null,{"$f":"AA21+AA40+AA59+AA78+AA97+AA116+AA135+AA154+AA173+AA193+AA213+AA233+AA253","v":-216226.16},null,{"$f":"AC21+AC40+AC59+AC78+AC97+AC116+AC135+AC154+AC173+AC193+AC213+AC233+AC253","v":-216226.16}]

{"sheet":"3. UCC_Calculations","index":2,"n_rows":88,"n_cols":28,"rows_kept":88,"cut":false,"hidden":false,"merged":[[3,1,3,3]]}
[]
[]
[]
[null,"MIST Meters True-up Model"]
[]
[]
[]
[]
["Sheet 3: CCA For PILs Calculation"]
[]
["UCC/Class 47",null,null,2014,null,2015,null,2016,null,2017,null,2018,null,2019,null,2020,null,2021,null,2022,null,2023,null,2024,null,2025,null,2026]
[null,null,null,"Actual",null,"Actual",null,"Actual",null,"Actual",null,"Actual",null,"Actual",null,"Actual",null,"Actual",null,"Actual",null,"Actual",null,"Actual",null,"Actual",null,"Actual"]
[]
["Opening UCC",null,null,0,null,{"$f":"D17-D22","v":397265.91359999997},null,{"$f":"F17-F22","v":1163778.957312},null,{"$f":"H17-H22","v":1804269.2135270401},null,{"$f":"J17-J22","v":2554612.3676448772},null,{"$f":"L17-L22","v":2370275.8902332871},null,{"$f":"N17-N22","v":2180653.8190146242},null,{"$f":"P17-P22","v":2006201.5134934543},null,{"$f":"R17-R22","v":1845705.392413978},null,{"$f":"T17-T22","v":1698048.9610208597},null,{"$f":"V17-V22","v":1562205.0441391908},null,{"$f":"X17-X22","v":1437228.6406080555},null,{"$f":"Z17-Z22","v":1322250.349359411}]
["Capital Additions",null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!E267-D29-D44-D59-D74","v":413818.66},null,{"$f":"'2. MIST Meters Assets_Rate Base'!G267-F29-F44-F59-F74","v":831556.58},null,{"$f":"'2. MIST Meters Assets_Rate Base'!I267-H29-H44-H59-H74","v":764158.93},null,{"$f":"'2. MIST Meters Assets_Rate Base'!K267-J29-J44-J59-J74","v":931963.22},null,{"$f":"'2. MIST Meters Assets_Rate Base'!M267-L29-L44-L59-L74","v":20867.2},null,{"$f":"'2. MIST Meters Assets_Rate Base'!O267-N29-N44-N59-N74","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!Q267-P29-P44-P59-P74","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!S267-R29-R44-R59-R74","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!U267-T29-T44-T59-T74","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!W267-V29-V44-V59-V74","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!Y267-X29-X44-X59-X74","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!AA267-Z29-Z44-Z59-Z74","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!AC267-AB29-AB44-AB59-AB74","v":0}]
["Retirements/Removals (if applicable)"]
["UCC Before Half Year Rule",null,null,{"$f":"SUM(D14:D15)-D16","v":413818.66},null,{"$f":"SUM(F14:F15)-F16","v":1228822.4935999999},null,{"$f":"SUM(H14:H15)-H16","v":1927937.8873120002},null,{"$f":"SUM(J14:J15)-J16","v":2736232.4335270403},null,{"$f":"SUM(L14:L15)-L16","v":2575479.5676448774},null,{"$f":"SUM(N14:N15)-N16","v":2370275.8902332871},null,{"$f":"SUM(P14:P15)-P16","v":2180653.8190146242},null,{"$f":"SUM(R14:R15)-R16","v":2006201.5134934543},null,{"$f":"SUM(T14:T15)-T16","v":1845705.392413978},null,{"$f":"SUM(V14:V15)-V16","v":1698048.9610208597},null,{"$f":"SUM(X14:X15)-X16","v":1562205.0441391908},null,{"$f":"SUM(Z14:Z15)-Z16","v":1437228.6406080555},null,{"$f":"SUM(AB14:AB15)-AB16","v":1322250.349359411}]
["Half Year Rule (1/2 Additions - Disposals)",null,null,{"$f":"IF(((D15-D16)/2)<0, 0, (D15-D16)/2)","v":206909.33},null,{"$f":"IF(((F15-F16)/2)<0, 0, (F15-F16)/2)","v":415778.29},null,{"$f":"IF(((H15-H16)/2)<0, 0, (H15-H16)/2)","v":382079.46500000003},null,{"$f":"IF(((J15-J16)/2)<0, 0, (J15-J16)/2)","v":465981.61},null,{"$f":"IF(((L15-L16)/2)<0, 0, (L15-L16)/2)","v":10433.6},null,{"$f":"IF(((N15-N16)/2)<0, 0, (N15-N16)/2)","v":0},null,{"$f":"IF(((P15-P16)/2)<0, 0, (P15-P16)/2)","v":0},null,{"$f":"IF(((R15-R16)/2)<0, 0, (R15-R16)/2)","v":0},null,{"$f":"IF(((T15-T16)/2)<0, 0, (T15-T16)/2)","v":0},null,{"$f":"IF(((V15-V16)/2)<0, 0, (V15-V16)/2)","v":0},null,{"$f":"IF(((X15-X16)/2)<0, 0, (X15-X16)/2)","v":0},null,{"$f":"IF(((Z15-Z16)/2)<0, 0, (Z15-Z16)/2)","v":0},null,{"$f":"IF(((AB15-AB16)/2)<0, 0, (AB15-AB16)/2)","v":0}]
["Reduced UCC",null,null,{"$f":"D18+D14","v":206909.33},null,{"$f":"F18+F14","v":813044.20359999989},null,{"$f":"H18+H14","v":1545858.4223120001},null,{"$f":"J18+J14","v":2270250.82352704},null,{"$f":"L18+L14","v":2565045.9676448773},null,{"$f":"N18+N14","v":2370275.8902332871},null,{"$f":"P18+P14","v":2180653.8190146242},null,{"$f":"R18+R14","v":2006201.5134934543},null,{"$f":"T18+T14","v":1845705.392413978},null,{"$f":"V18+V14","v":1698048.9610208597},null,{"$f":"X18+X14","v":1562205.0441391908},null,{"$f":"Z18+Z14","v":1437228.6406080555},null,{"$f":"AB18+AB14","v":1322250.349359411}]
["CCA Rate Class",null,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47]
["CCA Rate ",null,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08]
["CCA",null,null,{"$f":"D19*D21","v":16552.7464},null,{"$f":"F19*F21","v":65043.536287999996},null,{"$f":"H19*H21","v":123668.67378496},null,{"$f":"J19*J21","v":181620.06588216321},null,{"$f":"L19*L21","v":205203.67741159018},null,{"$f":"N19*N21","v":189622.07121866298},null,{"$f":"P19*P21","v":174452.30552116994},null,{"$f":"R19*R21","v":160496.12107947635},null,{"$f":"T19*T21","v":147656.43139311826},null,{"$f":"V19*V21","v":135843.91688166879},null,{"$f":"X19*X21","v":124976.40353113526},null,{"$f":"Z19*Z21","v":114978.29124864444},null,{"$f":"AB19*AB21","v":105780.02794875289}]
["Closing UCC",null,null,{"$f":"IF((D17-D22)<0, 0, D17-D22)","v":397265.91359999997},null,{"$f":"IF((F17-F22)<0, 0, F17-F22)","v":1163778.957312},null,{"$f":"IF((H17-H22)<0, 0, H17-H22)","v":1804269.2135270401},null,{"$f":"IF((J17-J22)<0, 0, J17-J22)","v":2554612.3676448772},null,{"$f":"IF((L17-L22)<0, 0, L17-L22)","v":2370275.8902332871},null,{"$f":"IF((N17-N22)<0, 0, N17-N22)","v":2180653.8190146242},null,{"$f":"IF((P17-P22)<0, 0, P17-P22)","v":2006201.5134934543},null,{"$f":"IF((R17-R22)<0, 0, R17-R22)","v":1845705.392413978},null,{"$f":"IF((T17-T22)<0, 0, T17-T22)","v":1698048.9610208597},null,{"$f":"IF((V17-V22)<0, 0, V17-V22)","v":1562205.0441391908},null,{"$f":"IF((X17-X22)<0, 0, X17-X22)","v":1437228.6406080555},null,{"$f":"IF((Z17-Z22)<0, 0, Z17-Z22)","v":1322250.349359411},null,{"$f":"IF((AB17-AB22)<0, 0, AB17-AB22)","v":1216470.3214106581}]
[]
["UCC/Class 8",null,null,{"$f":"D11","v":2014},null,2015,null,{"$f":"H11","v":2016},null,{"$f":"J11","v":2017},null,{"$f":"L11","v":2018},null,{"$f":"N11","v":2019},null,{"$f":"P11","v":2020},null,{"$f":"R11","v":2021},null,{"$f":"T11","v":2022},null,{"$f":"V11","v":2023},null,{"$f":"X11","v":2024},null,{"$f":"Z11","v":2025},null,{"$f":"AB11","v":2026}]
[null,null,null,"Actual",null,"Actual",null,{"$f":"H12","v":"Actual"},null,{"$f":"J12","v":"Actual"},null,{"$f":"L12","v":"Actual"},null,{"$f":"N12","v":"Actual"},null,{"$f":"P12","v":"Actual"},null,{"$f":"R12","v":"Actual"},null,{"$f":"T12","v":"Actual"},null,{"$f":"V12","v":"Actual"},null,{"$f":"X12","v":"Actual"},null,{"$f":"Z12","v":"Actual"},null,{"$f":"AB12","v":"Actual"}]
[]
["Opening UCC",null,null,0,null,{"$f":"D31-D36","v":0},null,{"$f":"F31-F36","v":0},null,{"$f":"H31-H36","v":0},null,{"$f":"J31-J36","v":0},null,{"$f":"L31-L36","v":0},null,{"$f":"N31-N36","v":0},null,{"$f":"P31-P36","v":0},null,{"$f":"R31-R36","v":0},null,{"$f":"T31-T36","v":0},null,{"$f":"V31-V36","v":0},null,{"$f":"X31-X36","v":0},null,{"$f":"Z31-Z36","v":0}]
["Capital Additions ",null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!E227+'2. MIST Meters Assets_Rate Base'!E207+'2. MIST Meters Assets_Rate Base'!E148+'2. MIST Meters Assets_Rate Base'!E110","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!G227+'2. MIST Meters Assets_Rate Base'!G207+'2. MIST Meters Assets_Rate Base'!G148+'2. MIST Meters Assets_Rate Base'!G110","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!I227+'2. MIST Meters Assets_Rate Base'!I207+'2. MIST Meters Assets_Rate Base'!I148+'2. MIST Meters Assets_Rate Base'!I110","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!K227+'2. MIST Meters Assets_Rate Base'!K207+'2. MIST Meters Assets_Rate Base'!K148+'2. MIST Meters Assets_Rate Base'!K110","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!M227+'2. MIST Meters Assets_Rate Base'!M207+'2. MIST Meters Assets_Rate Base'!M148+'2. MIST Meters Assets_Rate Base'!M110","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!O227+'2. MIST Meters Assets_Rate Base'!O207+'2. MIST Meters Assets_Rate Base'!O148+'2. MIST Meters Assets_Rate Base'!O110","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!Q227+'2. MIST Meters Assets_Rate Base'!Q207+'2. MIST Meters Assets_Rate Base'!Q148+'2. MIST Meters Assets_Rate Base'!Q110","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!S227+'2. MIST Meters Assets_Rate Base'!S207+'2. MIST Meters Assets_Rate Base'!S148+'2. MIST Meters Assets_Rate Base'!S110","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!U227+'2. MIST Meters Assets_Rate Base'!U207+'2. MIST Meters Assets_Rate Base'!U148+'2. MIST Meters Assets_Rate Base'!U110","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!W227+'2. MIST Meters Assets_Rate Base'!W207+'2. MIST Meters Assets_Rate Base'!W148+'2. MIST Meters Assets_Rate Base'!W110","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!Y227+'2. MIST Meters Assets_Rate Base'!Y207+'2. MIST Meters Assets_Rate Base'!Y148+'2. MIST Meters Assets_Rate Base'!Y110","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!AA227+'2. MIST Meters Assets_Rate Base'!AA207+'2. MIST Meters Assets_Rate Base'!AA148+'2. MIST Meters Assets_Rate Base'!AA110","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!AC227+'2. MIST Meters Assets_Rate Base'!AC207+'2. MIST Meters Assets_Rate Base'!AC148+'2. MIST Meters Assets_Rate Base'!AC110","v":0}]
["Retirements/Removals (if applicable)"]
["UCC Before Half Year Rule",null,null,{"$f":"SUM(D28:D29)-D30","v":0},null,{"$f":"SUM(F28:F29)-F30","v":0},null,{"$f":"SUM(H28:H29)-H30","v":0},null,{"$f":"SUM(J28:J29)-J30","v":0},null,{"$f":"SUM(L28:L29)-L30","v":0},null,{"$f":"SUM(N28:N29)-N30","v":0},null,{"$f":"SUM(P28:P29)-P30","v":0},null,{"$f":"SUM(R28:R29)-R30","v":0},null,{"$f":"SUM(T28:T29)-T30","v":0},null,{"$f":"SUM(V28:V29)-V30","v":0},null,{"$f":"SUM(X28:X29)-X30","v":0},null,{"$f":"SUM(Z28:Z29)-Z30","v":0},null,{"$f":"SUM(AB28:AB29)-AB30","v":0}]
["Half Year Rule (1/2 Additions - Disposals)",null,null,{"$f":"IF((SUM(D29:D29)/2)<0, 0, SUM(D29:D29)/2)","v":0},null,{"$f":"IF((SUM(F29:F29)/2)<0, 0, SUM(F29:F29)/2)","v":0},null,{"$f":"IF((SUM(H29:H29)/2)<0, 0, SUM(H29:H29)/2)","v":0},null,{"$f":"IF((SUM(J29:J29)/2)<0, 0, SUM(J29:J29)/2)","v":0},null,{"$f":"IF((SUM(L29:L29)/2)<0, 0, SUM(L29:L29)/2)","v":0},null,{"$f":"IF((SUM(N29:N29)/2)<0, 0, SUM(N29:N29)/2)","v":0},null,{"$f":"IF((SUM(P29:P29)/2)<0, 0, SUM(P29:P29)/2)","v":0},null,{"$f":"IF((SUM(R29:R29)/2)<0, 0, SUM(R29:R29)/2)","v":0},null,{"$f":"IF((SUM(T29:T29)/2)<0, 0, SUM(T29:T29)/2)","v":0},null,{"$f":"IF((SUM(V29:V29)/2)<0, 0, SUM(V29:V29)/2)","v":0},null,{"$f":"IF((SUM(X29:X29)/2)<0, 0, SUM(X29:X29)/2)","v":0},null,{"$f":"IF((SUM(Z29:Z29)/2)<0, 0, SUM(Z29:Z29)/2)","v":0},null,{"$f":"IF((SUM(AB29:AB29)/2)<0, 0, SUM(AB29:AB29)/2)","v":0}]
["Reduced UCC",null,null,{"$f":"D32+D28","v":0},null,{"$f":"F32+F28","v":0},null,{"$f":"H32+H28","v":0},null,{"$f":"J32+J28","v":0},null,{"$f":"L32+L28","v":0},null,{"$f":"N32+N28","v":0},null,{"$f":"P32+P28","v":0},null,{"$f":"R32+R28","v":0},null,{"$f":"T32+T28","v":0},null,{"$f":"V32+V28","v":0},null,{"$f":"X32+X28","v":0},null,{"$f":"Z32+Z28","v":0},null,{"$f":"AB32+AB28","v":0}]
["CCA Rate Class",null,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8]
["CCA Rate ",null,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2]
["CCA",null,null,{"$f":"D35*D33","v":0},null,{"$f":"F35*F33","v":0},null,{"$f":"H35*H33","v":0},null,{"$f":"J35*J33","v":0},null,{"$f":"L35*L33","v":0},null,{"$f":"N35*N33","v":0},null,{"$f":"P35*P33","v":0},null,{"$f":"R35*R33","v":0},null,{"$f":"T35*T33","v":0},null,{"$f":"V35*V33","v":0},null,{"$f":"X35*X33","v":0},null,{"$f":"Z35*Z33","v":0},null,{"$f":"AB35*AB33","v":0}]
["Closing UCC",null,null,{"$f":"IF((D31-D36)<0, 0, D31-D36)","v":0},null,{"$f":"IF((F31-F36)<0, 0, F31-F36)","v":0},null,{"$f":"IF((H31-H36)<0, 0, H31-H36)","v":0},null,{"$f":"IF((J31-J36)<0, 0, J31-J36)","v":0},null,{"$f":"IF((L31-L36)<0, 0, L31-L36)","v":0},null,{"$f":"IF((N31-N36)<0, 0, N31-N36)","v":0},null,{"$f":"IF((P31-P36)<0, 0, P31-P36)","v":0},null,{"$f":"IF((R31-R36)<0, 0, R31-R36)","v":0},null,{"$f":"IF((T31-T36)<0, 0, T31-T36)","v":0},null,{"$f":"IF((V31-V36)<0, 0, V31-V36)","v":0},null,{"$f":"IF((X31-X36)<0, 0, X31-X36)","v":0},null,{"$f":"IF((Z31-Z36)<0, 0, Z31-Z36)","v":0},null,{"$f":"IF((AB31-AB36)<0, 0, AB31-AB36)","v":0}]
[]
[]
["UCC/Class 10",null,null,2014,null,2015,null,2015,null,2015,null,2015,null,2015,null,2015,null,2015,null,2015,null,2015,null,2015,null,2015,null,2015]
[null,null,null,"Audited Actual",null,"Forecast",null,"Forecast",null,"Forecast",null,"Forecast",null,"Forecast",null,"Forecast",null,"Forecast",null,"Forecast",null,"Forecast",null,"Forecast",null,"Forecast",null,"Forecast"]
[]
["Opening UCC",null,null,0,null,{"$f":"D46-D51","v":0},null,{"$f":"F46-F51","v":0},null,{"$f":"H46-H51","v":0},null,{"$f":"J46-J51","v":0},null,{"$f":"L46-L51","v":0},null,{"$f":"N46-N51","v":0},null,{"$f":"P46-P51","v":0},null,{"$f":"R46-R51","v":0},null,{"$f":"T46-T51","v":0},null,{"$f":"V46-V51","v":0},null,{"$f":"X46-X51","v":0},null,{"$f":"Z46-Z51","v":0}]
["Capital Additions ",null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!E53","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!G53","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!I53","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!K53","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!M53","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!O53","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!Q53","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!S53","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!U53","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!W53","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!Y53","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!AA53","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!AC53","v":0}]
["Retirements/Removals (if applicable)"]
["UCC Before Half Year Rule",null,null,{"$f":"SUM(D43:D44)-D45","v":0},null,{"$f":"SUM(F43:F44)-F45","v":0},null,{"$f":"SUM(H43:H44)-H45","v":0},null,{"$f":"SUM(J43:J44)-J45","v":0},null,{"$f":"SUM(L43:L44)-L45","v":0},null,{"$f":"SUM(N43:N44)-N45","v":0},null,{"$f":"SUM(P43:P44)-P45","v":0},null,{"$f":"SUM(R43:R44)-R45","v":0},null,{"$f":"SUM(T43:T44)-T45","v":0},null,{"$f":"SUM(V43:V44)-V45","v":0},null,{"$f":"SUM(X43:X44)-X45","v":0},null,{"$f":"SUM(Z43:Z44)-Z45","v":0},null,{"$f":"SUM(AB43:AB44)-AB45","v":0}]
["Half Year Rule (1/2 Additions - Disposals)",null,null,{"$f":"IF((SUM(D44:D44)/2)<0, 0, SUM(D44:D44)/2)","v":0},null,{"$f":"IF((SUM(F44:F44)/2)<0, 0, SUM(F44:F44)/2)","v":0},null,{"$f":"IF((SUM(H44:H44)/2)<0, 0, SUM(H44:H44)/2)","v":0},null,{"$f":"IF((SUM(J44:J44)/2)<0, 0, SUM(J44:J44)/2)","v":0},null,{"$f":"IF((SUM(L44:L44)/2)<0, 0, SUM(L44:L44)/2)","v":0},null,{"$f":"IF((SUM(N44:N44)/2)<0, 0, SUM(N44:N44)/2)","v":0},null,{"$f":"IF((SUM(P44:P44)/2)<0, 0, SUM(P44:P44)/2)","v":0},null,{"$f":"IF((SUM(R44:R44)/2)<0, 0, SUM(R44:R44)/2)","v":0},null,{"$f":"IF((SUM(T44:T44)/2)<0, 0, SUM(T44:T44)/2)","v":0},null,{"$f":"IF((SUM(V44:V44)/2)<0, 0, SUM(V44:V44)/2)","v":0},null,{"$f":"IF((SUM(X44:X44)/2)<0, 0, SUM(X44:X44)/2)","v":0},null,{"$f":"IF((SUM(Z44:Z44)/2)<0, 0, SUM(Z44:Z44)/2)","v":0},null,{"$f":"IF((SUM(AB44:AB44)/2)<0, 0, SUM(AB44:AB44)/2)","v":0}]
["Reduced UCC",null,null,{"$f":"D47+D43","v":0},null,{"$f":"F47+F43","v":0},null,{"$f":"H47+H43","v":0},null,{"$f":"J47+J43","v":0},null,{"$f":"L47+L43","v":0},null,{"$f":"N47+N43","v":0},null,{"$f":"P47+P43","v":0},null,{"$f":"R47+R43","v":0},null,{"$f":"T47+T43","v":0},null,{"$f":"V47+V43","v":0},null,{"$f":"X47+X43","v":0},null,{"$f":"Z47+Z43","v":0},null,{"$f":"AB47+AB43","v":0}]
["CCA Rate Class",null,null,10,null,10,null,10,null,10,null,10,null,10,null,10,null,10,null,10,null,10,null,10,null,10,null,10]
["CCA Rate ",null,null,0.3,null,0.3,null,0.3,null,0.3,null,0.3,null,0.3,null,0.3,null,0.3,null,0.3,null,0.3,null,0.3,null,0.3,null,0.3]
["CCA",null,null,{"$f":"D50*D48","v":0},null,{"$f":"F50*F48","v":0},null,{"$f":"H50*H48","v":0},null,{"$f":"J50*J48","v":0},null,{"$f":"L50*L48","v":0},null,{"$f":"N50*N48","v":0},null,{"$f":"P50*P48","v":0},null,{"$f":"R50*R48","v":0},null,{"$f":"T50*T48","v":0},null,{"$f":"V50*V48","v":0},null,{"$f":"X50*X48","v":0},null,{"$f":"Z50*Z48","v":0},null,{"$f":"AB50*AB48","v":0}]
["Closing UCC",null,null,{"$f":"IF((D46-D51)<0, 0, D46-D51)","v":0},null,{"$f":"IF((F46-F51)<0, 0, F46-F51)","v":0},null,{"$f":"IF((H46-H51)<0, 0, H46-H51)","v":0},null,{"$f":"IF((J46-J51)<0, 0, J46-J51)","v":0},null,{"$f":"IF((L46-L51)<0, 0, L46-L51)","v":0},null,{"$f":"IF((N46-N51)<0, 0, N46-N51)","v":0},null,{"$f":"IF((P46-P51)<0, 0, P46-P51)","v":0},null,{"$f":"IF((R46-R51)<0, 0, R46-R51)","v":0},null,{"$f":"IF((T46-T51)<0, 0, T46-T51)","v":0},null,{"$f":"IF((V46-V51)<0, 0, V46-V51)","v":0},null,{"$f":"IF((X46-X51)<0, 0, X46-X51)","v":0},null,{"$f":"IF((Z46-Z51)<0, 0, Z46-Z51)","v":0},null,{"$f":"IF((AB46-AB51)<0, 0, AB46-AB51)","v":0}]
[]
[]
["UCC/Class 50",null,null,2014,null,2015,null,2015,null,2015,null,2015,null,2015,null,2015,null,2015,null,2015,null,2015,null,2015,null,2015,null,2015]
[null,null,null,"Audited Actual",null,"Forecast",null,"Forecast",null,"Forecast",null,"Forecast",null,"Forecast",null,"Forecast",null,"Forecast",null,"Forecast",null,"Forecast",null,"Forecast",null,"Forecast",null,"Forecast"]
[]
["Opening UCC",null,null,0,null,{"$f":"D61-D66","v":0},null,{"$f":"F61-F66","v":0},null,{"$f":"H61-H66","v":0},null,{"$f":"J61-J66","v":0},null,{"$f":"L61-L66","v":0},null,{"$f":"N61-N66","v":0},null,{"$f":"P61-P66","v":0},null,{"$f":"R61-R66","v":0},null,{"$f":"T61-T66","v":0},null,{"$f":"V61-V66","v":0},null,{"$f":"X61-X66","v":0},null,{"$f":"Z61-Z66","v":0}]
["Capital Additions ",null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!E91+'2. MIST Meters Assets_Rate Base'!E167","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!G91+'2. MIST Meters Assets_Rate Base'!G167","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!I91+'2. MIST Meters Assets_Rate Base'!I167","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!K91+'2. MIST Meters Assets_Rate Base'!K167","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!M91+'2. MIST Meters Assets_Rate Base'!M167","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!O91+'2. MIST Meters Assets_Rate Base'!O167","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!Q91+'2. MIST Meters Assets_Rate Base'!Q167","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!S91+'2. MIST Meters Assets_Rate Base'!S167","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!U91+'2. MIST Meters Assets_Rate Base'!U167","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!W91+'2. MIST Meters Assets_Rate Base'!W167","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!Y91+'2. MIST Meters Assets_Rate Base'!Y167","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!AA91+'2. MIST Meters Assets_Rate Base'!AA167","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!AC91+'2. MIST Meters Assets_Rate Base'!AC167","v":0}]
["Retirements/Removals (if applicable)"]
["UCC Before Half Year Rule",null,null,{"$f":"SUM(D58:D59)-D60","v":0},null,{"$f":"SUM(F58:F59)-F60","v":0},null,{"$f":"SUM(H58:H59)-H60","v":0},null,{"$f":"SUM(J58:J59)-J60","v":0},null,{"$f":"SUM(L58:L59)-L60","v":0},null,{"$f":"SUM(N58:N59)-N60","v":0},null,{"$f":"SUM(P58:P59)-P60","v":0},null,{"$f":"SUM(R58:R59)-R60","v":0},null,{"$f":"SUM(T58:T59)-T60","v":0},null,{"$f":"SUM(V58:V59)-V60","v":0},null,{"$f":"SUM(X58:X59)-X60","v":0},null,{"$f":"SUM(Z58:Z59)-Z60","v":0},null,{"$f":"SUM(AB58:AB59)-AB60","v":0}]
["Half Year Rule (1/2 Additions - Disposals)",null,null,{"$f":"IF((SUM(D59:D59)/2)<0, 0, SUM(D59:D59)/2)","v":0},null,{"$f":"IF((SUM(F59:F59)/2)<0, 0, SUM(F59:F59)/2)","v":0},null,{"$f":"IF((SUM(H59:H59)/2)<0, 0, SUM(H59:H59)/2)","v":0},null,{"$f":"IF((SUM(J59:J59)/2)<0, 0, SUM(J59:J59)/2)","v":0},null,{"$f":"IF((SUM(L59:L59)/2)<0, 0, SUM(L59:L59)/2)","v":0},null,{"$f":"IF((SUM(N59:N59)/2)<0, 0, SUM(N59:N59)/2)","v":0},null,{"$f":"IF((SUM(P59:P59)/2)<0, 0, SUM(P59:P59)/2)","v":0},null,{"$f":"IF((SUM(R59:R59)/2)<0, 0, SUM(R59:R59)/2)","v":0},null,{"$f":"IF((SUM(T59:T59)/2)<0, 0, SUM(T59:T59)/2)","v":0},null,{"$f":"IF((SUM(V59:V59)/2)<0, 0, SUM(V59:V59)/2)","v":0},null,{"$f":"IF((SUM(X59:X59)/2)<0, 0, SUM(X59:X59)/2)","v":0},null,{"$f":"IF((SUM(Z59:Z59)/2)<0, 0, SUM(Z59:Z59)/2)","v":0},null,{"$f":"IF((SUM(AB59:AB59)/2)<0, 0, SUM(AB59:AB59)/2)","v":0}]
["Reduced UCC",null,null,{"$f":"D62+D58","v":0},null,{"$f":"F62+F58","v":0},null,{"$f":"H62+H58","v":0},null,{"$f":"J62+J58","v":0},null,{"$f":"L62+L58","v":0},null,{"$f":"N62+N58","v":0},null,{"$f":"P62+P58","v":0},null,{"$f":"R62+R58","v":0},null,{"$f":"T62+T58","v":0},null,{"$f":"V62+V58","v":0},null,{"$f":"X62+X58","v":0},null,{"$f":"Z62+Z58","v":0},null,{"$f":"AB62+AB58","v":0}]
["CCA Rate Class",null,null,50,null,50,null,50,null,50,null,50,null,50,null,50,null,50,null,50,null,50,null,50,null,50,null,50]
["CCA Rate ",null,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004]
["CCA",null,null,{"$f":"D65*D63","v":0},null,{"$f":"F65*F63","v":0},null,{"$f":"H65*H63","v":0},null,{"$f":"J65*J63","v":0},null,{"$f":"L65*L63","v":0},null,{"$f":"N65*N63","v":0},null,{"$f":"P65*P63","v":0},null,{"$f":"R65*R63","v":0},null,{"$f":"T65*T63","v":0},null,{"$f":"V65*V63","v":0},null,{"$f":"X65*X63","v":0},null,{"$f":"Z65*Z63","v":0},null,{"$f":"AB65*AB63","v":0}]
["Closing UCC",null,null,{"$f":"IF((D61-D66)<0, 0, D61-D66)","v":0},null,{"$f":"IF((F61-F66)<0, 0, F61-F66)","v":0},null,{"$f":"IF((H61-H66)<0, 0, H61-H66)","v":0},null,{"$f":"IF((J61-J66)<0, 0, J61-J66)","v":0},null,{"$f":"IF((L61-L66)<0, 0, L61-L66)","v":0},null,{"$f":"IF((N61-N66)<0, 0, N61-N66)","v":0},null,{"$f":"IF((P61-P66)<0, 0, P61-P66)","v":0},null,{"$f":"IF((R61-R66)<0, 0, R61-R66)","v":0},null,{"$f":"IF((T61-T66)<0, 0, T61-T66)","v":0},null,{"$f":"IF((V61-V66)<0, 0, V61-V66)","v":0},null,{"$f":"IF((X61-X66)<0, 0, X61-X66)","v":0},null,{"$f":"IF((Z61-Z66)<0, 0, Z61-Z66)","v":0},null,{"$f":"IF((AB61-AB66)<0, 0, AB61-AB66)","v":0}]
[]
[]
["UCC/Class 12",null,null,2014,null,2015,null,2015,null,2015,null,2015,null,2015,null,2015,null,2015,null,2015,null,2015,null,2015,null,2015,null,2015]
[null,null,null,"Audited Actual",null,"Forecast",null,"Forecast",null,"Forecast",null,"Forecast",null,"Forecast",null,"Forecast",null,"Forecast",null,"Forecast",null,"Forecast",null,"Forecast",null,"Forecast",null,"Forecast"]
[]
["Opening UCC",null,null,0,null,{"$f":"D76-D81","v":0},null,{"$f":"F76-F81","v":0},null,{"$f":"H76-H81","v":0},null,{"$f":"J76-J81","v":0},null,{"$f":"L76-L81","v":0},null,{"$f":"N76-N81","v":0},null,{"$f":"P76-P81","v":0},null,{"$f":"R76-R81","v":0},null,{"$f":"T76-T81","v":0},null,{"$f":"V76-V81","v":0},null,{"$f":"X76-X81","v":0},null,{"$f":"Z76-Z81","v":0}]
["Capital Additions ",null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!E129","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!G129","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!I129","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!K129","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!M129","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!O129","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!Q129","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!S129","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!U129","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!W129","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!Y129","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!AA129","v":0},null,{"$f":"'2. MIST Meters Assets_Rate Base'!AC129","v":0}]
["Retirements/Removals (if applicable)"]
["UCC Before Half Year Rule",null,null,{"$f":"SUM(D73:D74)-D75","v":0},null,{"$f":"SUM(F73:F74)-F75","v":0},null,{"$f":"SUM(H73:H74)-H75","v":0},null,{"$f":"SUM(J73:J74)-J75","v":0},null,{"$f":"SUM(L73:L74)-L75","v":0},null,{"$f":"SUM(N73:N74)-N75","v":0},null,{"$f":"SUM(P73:P74)-P75","v":0},null,{"$f":"SUM(R73:R74)-R75","v":0},null,{"$f":"SUM(T73:T74)-T75","v":0},null,{"$f":"SUM(V73:V74)-V75","v":0},null,{"$f":"SUM(X73:X74)-X75","v":0},null,{"$f":"SUM(Z73:Z74)-Z75","v":0},null,{"$f":"SUM(AB73:AB74)-AB75","v":0}]
["Half Year Rule (1/2 Additions - Disposals)",null,null,{"$f":"IF((SUM(D74:D74)/2)<0, 0, SUM(D74:D74)/2)","v":0},null,{"$f":"IF((SUM(F74:F74)/2)<0, 0, SUM(F74:F74)/2)","v":0},null,{"$f":"IF((SUM(H74:H74)/2)<0, 0, SUM(H74:H74)/2)","v":0},null,{"$f":"IF((SUM(J74:J74)/2)<0, 0, SUM(J74:J74)/2)","v":0},null,{"$f":"IF((SUM(L74:L74)/2)<0, 0, SUM(L74:L74)/2)","v":0},null,{"$f":"IF((SUM(N74:N74)/2)<0, 0, SUM(N74:N74)/2)","v":0},null,{"$f":"IF((SUM(P74:P74)/2)<0, 0, SUM(P74:P74)/2)","v":0},null,{"$f":"IF((SUM(R74:R74)/2)<0, 0, SUM(R74:R74)/2)","v":0},null,{"$f":"IF((SUM(T74:T74)/2)<0, 0, SUM(T74:T74)/2)","v":0},null,{"$f":"IF((SUM(V74:V74)/2)<0, 0, SUM(V74:V74)/2)","v":0},null,{"$f":"IF((SUM(X74:X74)/2)<0, 0, SUM(X74:X74)/2)","v":0},null,{"$f":"IF((SUM(Z74:Z74)/2)<0, 0, SUM(Z74:Z74)/2)","v":0},null,{"$f":"IF((SUM(AB74:AB74)/2)<0, 0, SUM(AB74:AB74)/2)","v":0}]
["Reduced UCC",null,null,{"$f":"D77+D73","v":0},null,{"$f":"F77+F73","v":0},null,{"$f":"H77+H73","v":0},null,{"$f":"J77+J73","v":0},null,{"$f":"L77+L73","v":0},null,{"$f":"N77+N73","v":0},null,{"$f":"P77+P73","v":0},null,{"$f":"R77+R73","v":0},null,{"$f":"T77+T73","v":0},null,{"$f":"V77+V73","v":0},null,{"$f":"X77+X73","v":0},null,{"$f":"Z77+Z73","v":0},null,{"$f":"AB77+AB73","v":0}]
["CCA Rate Class",null,null,12,null,12,null,12,null,12,null,12,null,12,null,12,null,12,null,12,null,12,null,12,null,12,null,12]
["CCA Rate ",null,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1]
["CCA",null,null,{"$f":"D80*D78","v":0},null,{"$f":"F80*F78","v":0},null,{"$f":"H80*H78","v":0},null,{"$f":"J80*J78","v":0},null,{"$f":"L80*L78","v":0},null,{"$f":"N80*N78","v":0},null,{"$f":"P80*P78","v":0},null,{"$f":"R80*R78","v":0},null,{"$f":"T80*T78","v":0},null,{"$f":"V80*V78","v":0},null,{"$f":"X80*X78","v":0},null,{"$f":"Z80*Z78","v":0},null,{"$f":"AB80*AB78","v":0}]
["Closing UCC",null,null,{"$f":"IF((D76-D81)<0, 0, D76-D81)","v":0},null,{"$f":"IF((F76-F81)<0, 0, F76-F81)","v":0},null,{"$f":"IF((H76-H81)<0, 0, H76-H81)","v":0},null,{"$f":"IF((J76-J81)<0, 0, J76-J81)","v":0},null,{"$f":"IF((L76-L81)<0, 0, L76-L81)","v":0},null,{"$f":"IF((N76-N81)<0, 0, N76-N81)","v":0},null,{"$f":"IF((P76-P81)<0, 0, P76-P81)","v":0},null,{"$f":"IF((R76-R81)<0, 0, R76-R81)","v":0},null,{"$f":"IF((T76-T81)<0, 0, T76-T81)","v":0},null,{"$f":"IF((V76-V81)<0, 0, V76-V81)","v":0},null,{"$f":"IF((X76-X81)<0, 0, X76-X81)","v":0},null,{"$f":"IF((Z76-Z81)<0, 0, Z76-Z81)","v":0},null,{"$f":"IF((AB76-AB81)<0, 0, AB76-AB81)","v":0}]
[]
[]
[]
[null,"Capital Additions",null,{"$f":"SUM(D74,D59,D44,D29,D15)","v":413818.66},{"$f":"SUM(E74,E59,E44,E29,E15)","v":0},{"$f":"SUM(F74,F59,F44,F29,F15)","v":831556.58},null,{"$f":"SUM(H74,H59,H44,H29,H15)","v":764158.93},null,{"$f":"SUM(J74,J59,J44,J29,J15)","v":931963.22},null,{"$f":"SUM(L74,L59,L44,L29,L15)","v":20867.2},null,{"$f":"SUM(N74,N59,N44,N29,N15)","v":0},null,{"$f":"SUM(P74,P59,P44,P29,P15)","v":0},null,{"$f":"SUM(R74,R59,R44,R29,R15)","v":0},null,{"$f":"SUM(T74,T59,T44,T29,T15)","v":0},null,{"$f":"SUM(V74,V59,V44,V29,V15)","v":0},null,{"$f":"SUM(X74,X59,X44,X29,X15)","v":0},null,{"$f":"SUM(Z74,Z59,Z44,Z29,Z15)","v":0},null,{"$f":"SUM(AB74,AB59,AB44,AB29,AB15)","v":0}]
[]
[null,"CCA",null,{"$f":"SUM(D81,D66,D51,D36,D22,)","v":16552.7464},0,65043.536287999996,0,123668.67378496,0,181620.06588216321,0,205203.67741159018,0,189622.07121866298,0,174452.30552116994,0,160496.12107947635,0,147656.43139311826,0,135843.91688166879,0,124976.40353113526,0,114978.29124864444,0,105780.02794875289]

{"sheet":"4. Fund Adder Revenues","index":3,"n_rows":175,"n_cols":14,"rows_kept":175,"cut":false,"hidden":false,"merged":[[10,5,10,14]]}
[]
[]
[]
[null,null,null,null,null,null,null,"MIST Meters True-up Model"]
[]
[]
[]
[]
[null,"Sheet 4: MIST Meters Funding Adder Revenues"]
[]
[]
[]
[]
[null,"Prescribed \nInterest Rates","Approved Deferral and Variance Accounts","CWIP",null,"Date","Year","Quarter",null,"Opening Balance (Principal)","Funding Adder Revenues","Interest Rate","Interest","Principal &\nInterest\n(Cumm.)"]
[]
[null,"2014 Q1",1.47E-2,3.6999999999999998E-2,null,"2014-01-01",{"$f":"YEAR(F16)","v":2014},{"$f":"IF(MONTH(F16)=0,\"\",IF(MONTH(F16)<4,\"Q1\",IF(MONTH(F16)<7,\"Q2\",IF(MONTH(F16)<10,\"Q3\",\"Q4\"))))","v":"Q1"},{"$f":"CONCATENATE(G16,\" \",H16)","v":"2014 Q1"},0,0,{"$f":"VLOOKUP(I16,$B$14:$D$67,2)","v":1.47E-2},{"$f":"ROUND(J16*L16/12,2)","v":0},{"$f":"K16+M16","v":0}]
[null,"2014 Q2",1.47E-2,3.1699999999999999E-2,null,"2014-02-01",{"$f":"YEAR(F17)","v":2014},{"$f":"IF(MONTH(F17)=0,\"\",IF(MONTH(F17)<4,\"Q1\",IF(MONTH(F17)<7,\"Q2\",IF(MONTH(F17)<10,\"Q3\",\"Q4\"))))","v":"Q1"},{"$f":"CONCATENATE(G17,\" \",H17)","v":"2014 Q1"},{"$f":"J16+K16","v":0},0,{"$f":"VLOOKUP(I17,$B$14:$D$67,2)","v":1.47E-2},{"$f":"ROUND(J17*L17/12,2)","v":0},{"$f":"N16+K17+M17","v":0}]
[null,"2014 Q3",{"$f":"C17","v":1.47E-2},3.1699999999999999E-2,null,"2014-03-01",2014,"Q1","2014 Q1",{"$f":"J17+K17","v":0},0,1.47E-2,0,{"$f":"N17+K18+M18","v":0}]
[null,"2014 Q4",1.47E-2,3.1699999999999999E-2,null,"2014-04-01",2014,"Q2","2014 Q2",0,0,1.47E-2,0,0]
[null,"2015 Q1",1.0999999999999999E-2,2.8899999999999999E-2,null,"2014-05-01",2014,"Q2","2014 Q2",0,0,1.47E-2,0,0]
[null,"2015 Q2",{"$f":"C20","v":1.0999999999999999E-2},2.8899999999999999E-2,null,"2014-06-01",2014,"Q2","2014 Q2",0,0,1.47E-2,0,0]
[null,"2015 Q3",{"$f":"C21","v":1.0999999999999999E-2},2.8899999999999999E-2,null,"2014-07-01",2014,"Q3","2014 Q3",0,0,1.47E-2,0,0]
[null,"2015 Q4",{"$f":"C22","v":1.0999999999999999E-2},2.5499999999999998E-2,null,"2014-08-01",2014,"Q3","2014 Q3",0,0,1.47E-2,0,0]
[null,"2016 Q1",1.0999999999999999E-2,2.92E-2,null,"2014-09-01",2014,"Q3","2014 Q3",0,0,1.47E-2,0,0]
[null,"2016 Q2",1.0999999999999999E-2,2.92E-2,null,"2014-10-01",2014,"Q4","2014 Q4",0,0,1.47E-2,0,0]
[null,"2016 Q3",1.0999999999999999E-2,2.92E-2,null,"2014-11-01",2014,"Q4","2014 Q4",0,0,1.47E-2,0,0]
[null,"2016 Q4",1.0999999999999999E-2,2.46E-2,null,"2014-12-01",2014,"Q4","2014 Q4",0,0,1.47E-2,0,0]
[null,"2017 Q1",1.0999999999999999E-2,2.81E-2,null,"2015-01-01",2015,"Q1","2015 Q1",0,0,1.0999999999999999E-2,0,0]
[null,"2017 Q2",1.0999999999999999E-2,2.81E-2,null,"2015-02-01",2015,"Q1","2015 Q1",0,0,1.0999999999999999E-2,0,0]
[null,"2017 Q3",1.0999999999999999E-2,2.46E-2,null,"2015-03-01",2015,"Q1","2015 Q1",0,0,1.0999999999999999E-2,0,0]
[null,"2017 Q4",1.4999999999999999E-2,2.9899999999999999E-2,null,"2015-04-01",2015,"Q2","2015 Q2",0,0,1.0999999999999999E-2,0,0]
[null,"2018 Q1",1.4999999999999999E-2,2.9899999999999999E-2,null,"2015-05-01",2015,"Q2","2015 Q2",0,0,1.0999999999999999E-2,0,0]
[null,"2018 Q2",1.89E-2,3.3500000000000002E-2,null,"2015-06-01",2015,"Q2","2015 Q2",0,0,1.0999999999999999E-2,0,0]
[null,"2018 Q3",1.89E-2,3.3500000000000002E-2,null,"2015-07-01",2015,"Q3","2015 Q3",0,0,1.0999999999999999E-2,0,0]
[null,"2018 Q4",2.1700000000000001E-2,3.3500000000000002E-2,null,"2015-08-01",2015,"Q3","2015 Q3",0,0,1.0999999999999999E-2,0,0]
[null,"2019 Q1",2.4500000000000001E-2,3.8199999999999998E-2,null,"2015-09-01",2015,"Q3","2015 Q3",0,0,1.0999999999999999E-2,0,0]
[null,"2019 Q2",2.18E-2,3.39E-2,null,"2015-10-01",2015,"Q4","2015 Q4",0,0,1.0999999999999999E-2,0,0]
[null,"2019 Q3",2.18E-2,2.8799999999999999E-2,null,"2015-11-01",2015,"Q4","2015 Q4",0,0,1.0999999999999999E-2,0,0]
[null,"2019 Q4",2.18E-2,2.8799999999999999E-2,null,"2015-12-01",2015,"Q4","2015 Q4",0,0,1.0999999999999999E-2,0,0]
[null,"2020 Q1",2.18E-2,2.8799999999999999E-2,null,"2016-01-01",{"$f":"YEAR(F40)","v":2016},{"$f":"IF(MONTH(F40)=0,\"\",IF(MONTH(F40)<4,\"Q1\",IF(MONTH(F40)<7,\"Q2\",IF(MONTH(F40)<10,\"Q3\",\"Q4\"))))","v":"Q1"},{"$f":"CONCATENATE(G40,\" \",H40)","v":"2016 Q1"},{"$f":"J39+K39","v":0},0,1.0999999999999999E-2,{"$f":"ROUND(J40*L40/12,2)","v":0},{"$f":"N39+K40+M40","v":0}]
[null,"2020 Q2",2.18E-2,2.4799999999999999E-2,null,"2016-02-01",2016,"Q1","2016 Q1",0,0,1.0999999999999999E-2,0,0]
[null,"2020 Q3",5.7000000000000002E-3,2.4799999999999999E-2,null,"2016-03-01",2016,"Q1","2016 Q1",0,0,1.0999999999999999E-2,0,0]
[null,"2020 Q4",5.7000000000000002E-3,2.0299999999999999E-2,null,"2016-04-01",2016,"Q2","2016 Q2",0,0,1.0999999999999999E-2,0,0]
[null,"2021 Q1",5.7000000000000002E-3,2.0299999999999999E-2,null,"2016-05-01",2016,"Q2","2016 Q2",0,0,1.0999999999999999E-2,0,0]
[null,"2021 Q2",5.7000000000000002E-3,2.29E-2,null,"2016-06-01",2016,"Q2","2016 Q2",0,0,1.0999999999999999E-2,0,0]
[null,"2021 Q3",5.7000000000000002E-3,2.29E-2,null,"2016-07-01",2016,"Q3","2016 Q3",0,0,1.0999999999999999E-2,0,0]
[null,"2021 Q4",5.7000000000000002E-3,2.29E-2,null,"2016-08-01",2016,"Q3","2016 Q3",0,0,1.0999999999999999E-2,0,0]
[null,"2022 Q1",5.7000000000000002E-3,2.7199999999999998E-2,null,"2016-09-01",2016,"Q3","2016 Q3",0,0,1.0999999999999999E-2,0,0]
[null,"2022 Q2",1.0200000000000001E-2,3.3099999999999997E-2,null,"2016-10-01",2016,"Q4","2016 Q4",0,0,1.0999999999999999E-2,0,0]
[null,"2022 Q3",2.1999999999999999E-2,4.6600000000000003E-2,null,"2016-11-01",2016,"Q4","2016 Q4",0,0,1.0999999999999999E-2,0,0]
[null,"2022 Q4",3.8699999999999998E-2,5.0099999999999999E-2,null,"2016-12-01",2016,"Q4","2016 Q4",0,0,1.0999999999999999E-2,0,0]
[null,"2023 Q1",4.7300000000000002E-2,5.0099999999999999E-2,null,"2017-01-01",2017,"Q1","2017 Q1",0,0,1.0999999999999999E-2,0,0]
[null,"2023 Q2",4.9799999999999997E-2,5.0099999999999999E-2,null,"2017-02-01",2017,"Q1","2017 Q1",0,0,1.0999999999999999E-2,0,0]
[null,"2023 Q3",4.9799999999999997E-2,5.0099999999999999E-2,null,"2017-03-01",2017,"Q1","2017 Q1",0,0,1.0999999999999999E-2,0,0]
[null,"2023 Q4",5.4899999999999997E-2,5.4800000000000001E-2,null,"2017-04-01",2017,"Q2","2017 Q2",0,0,1.0999999999999999E-2,0,0]
[null,"2024 Q1",5.4899999999999997E-2,5.4800000000000001E-2,null,"2017-05-01",2017,"Q2","2017 Q2",0,0,1.0999999999999999E-2,0,0]
[null,"2024 Q2",5.4899999999999997E-2,5.9799999999999999E-2,null,"2017-06-01",2017,"Q2","2017 Q2",0,0,1.0999999999999999E-2,0,0]
[null,"2024 Q3",5.1999999999999998E-2,5.9799999999999999E-2,null,"2017-07-01",2017,"Q3","2017 Q3",0,0,1.0999999999999999E-2,0,0]
[null,"2024 Q4",4.3999999999999997E-2,4.5499999999999999E-2,null,"2017-08-01",2017,"Q3","2017 Q3",0,0,1.0999999999999999E-2,0,0]
[null,"2025 Q1",3.6400000000000002E-2,4.2299999999999997E-2,null,"2017-09-01",2017,"Q3","2017 Q3",0,0,1.0999999999999999E-2,0,0]
[null,"2025 Q2",3.1600000000000003E-2,4.2299999999999997E-2,null,"2017-10-01",2017,"Q4","2017 Q4",0,0,1.4999999999999999E-2,0,0]
[null,"2025 Q3",3.1600000000000003E-2,4.5499999999999999E-2,null,"2017-11-01",2017,"Q4","2017 Q4",0,0,1.4999999999999999E-2,0,0]
[null,"2025 Q4",3.1600000000000003E-2,4.5499999999999999E-2,null,"2017-12-01",2017,"Q4","2017 Q4",0,0,1.4999999999999999E-2,0,0]
[null,"2026 Q1",3.1600000000000003E-2,4.5499999999999999E-2,null,"2018-01-01",2018,"Q1","2018 Q1",0,0,1.4999999999999999E-2,0,0]
[null,"2026 Q2",3.1600000000000003E-2,4.5499999999999999E-2,null,"2018-02-01",2018,"Q1","2018 Q1",0,0,1.4999999999999999E-2,0,0]
[null,"2026 Q3",3.1600000000000003E-2,4.5499999999999999E-2,null,"2018-03-01",2018,"Q1","2018 Q1",0,0,1.4999999999999999E-2,0,0]
[null,"2026 Q4",3.1600000000000003E-2,4.5499999999999999E-2,null,"2018-04-01",2018,"Q2","2018 Q2",0,0,1.89E-2,0,0]
[null,null,null,null,null,"2018-05-01",2018,"Q2","2018 Q2",0,0,1.89E-2,0,0]
[null,null,null,null,null,"2018-06-01",2018,"Q2","2018 Q2",0,0,1.89E-2,0,0]
[null,null,null,null,null,"2018-07-01",2018,"Q3","2018 Q3",0,0,1.89E-2,0,0]
[null,null,null,null,null,"2018-08-01",{"$f":"YEAR(F71)","v":2018},{"$f":"IF(MONTH(F71)=0,\"\",IF(MONTH(F71)<4,\"Q1\",IF(MONTH(F71)<7,\"Q2\",IF(MONTH(F71)<10,\"Q3\",\"Q4\"))))","v":"Q3"},{"$f":"CONCATENATE(G71,\" \",H71)","v":"2018 Q3"},{"$f":"J70+K70","v":0},0,{"$f":"VLOOKUP(I71,$B$14:$D$67,2)","v":1.89E-2},{"$f":"ROUND(J71*L71/12,2)","v":0},{"$f":"N70+K71+M71","v":0}]
[null,null,null,null,null,"2018-09-01",2018,"Q3","2018 Q3",0,0,1.89E-2,0,0]
[null,null,null,null,null,"2018-10-01",2018,"Q4","2018 Q4",0,0,2.1700000000000001E-2,0,0]
[null,null,null,null,null,"2018-11-01",2018,"Q4","2018 Q4",0,0,2.1700000000000001E-2,0,0]
[null,null,null,null,null,"2018-12-01",2018,"Q4","2018 Q4",0,0,2.1700000000000001E-2,0,0]
[null,null,null,null,null,"2019-01-01",2019,"Q1","2019 Q1",0,0,2.4500000000000001E-2,0,0]
[null,null,null,null,null,"2019-02-01",2019,"Q1","2019 Q1",0,0,2.4500000000000001E-2,0,0]
[null,null,null,null,null,"2019-03-01",2019,"Q1","2019 Q1",0,0,2.4500000000000001E-2,0,0]
[null,null,null,null,null,"2019-04-01",2019,"Q2","2019 Q2",0,0,2.18E-2,0,0]
[null,null,null,null,null,"2019-05-01",2019,"Q2","2019 Q2",0,0,2.18E-2,0,0]
[null,null,null,null,null,"2019-06-01",2019,"Q2","2019 Q2",0,0,2.18E-2,0,0]
[null,null,null,null,null,"2019-07-01",2019,"Q3","2019 Q3",0,0,2.18E-2,0,0]
[null,null,null,null,null,"2019-08-01",2019,"Q3","2019 Q3",0,0,2.18E-2,0,0]
[null,null,null,null,null,"2019-09-01",2019,"Q3","2019 Q3",0,0,2.18E-2,0,0]
[null,null,null,null,null,"2019-10-01",2019,"Q4","2019 Q4",0,0,2.18E-2,0,0]
[null,null,null,null,null,"2019-11-01",2019,"Q4","2019 Q4",0,0,2.18E-2,0,0]
[null,null,null,null,null,"2019-12-01",2019,"Q4","2019 Q4",0,0,2.18E-2,0,0]
[null,null,null,null,null,"2020-01-01",2020,"Q1","2020 Q1",0,0,2.18E-2,0,0]
[null,null,null,null,null,"2020-02-01",2020,"Q1","2020 Q1",0,0,2.18E-2,0,0]
[null,null,null,null,null,"2020-03-01",2020,"Q1","2020 Q1",0,0,2.18E-2,0,0]
[null,null,null,null,null,"2020-04-01",2020,"Q2","2020 Q2",0,0,2.18E-2,0,0]
[null,null,null,null,null,"2020-05-01",2020,"Q2","2020 Q2",0,0,2.18E-2,0,0]
[null,null,null,null,null,"2020-06-01",2020,"Q2","2020 Q2",0,0,2.18E-2,0,0]
[null,null,null,null,null,"2020-07-01",2020,"Q3","2020 Q3",0,0,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2020-08-01",2020,"Q3","2020 Q3",0,0,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2020-09-01",2020,"Q3","2020 Q3",0,0,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2020-10-01",2020,"Q4","2020 Q4",0,0,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2020-11-01",2020,"Q4","2020 Q4",0,0,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2020-12-01",2020,"Q4","2020 Q4",0,0,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2021-01-01",{"$f":"YEAR(F100)","v":2021},{"$f":"IF(MONTH(F100)=0,\"\",IF(MONTH(F100)<4,\"Q1\",IF(MONTH(F100)<7,\"Q2\",IF(MONTH(F100)<10,\"Q3\",\"Q4\"))))","v":"Q1"},{"$f":"CONCATENATE(G100,\" \",H100)","v":"2021 Q1"},{"$f":"J99+K99","v":0},0,{"$f":"VLOOKUP(I100,$B$14:$D$67,2)","v":5.7000000000000002E-3},{"$f":"ROUND(J100*L100/12,2)","v":0},{"$f":"N99+K100+M100","v":0}]
[null,null,null,null,null,"2021-02-01",2021,"Q1","2021 Q1",0,0,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2021-03-01",2021,"Q1","2021 Q1",0,0,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2021-04-01",2021,"Q2","2021 Q2",0,0,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2021-05-01",2021,"Q2","2021 Q2",0,0,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2021-06-01",2021,"Q2","2021 Q2",0,0,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2021-07-01",2021,"Q3","2021 Q3",0,0,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2021-08-01",2021,"Q3","2021 Q3",0,0,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2021-09-01",2021,"Q3","2021 Q3",0,0,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2021-10-01",2021,"Q4","2021 Q4",0,0,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2021-11-01",2021,"Q4","2021 Q4",0,0,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2021-12-01",2021,"Q4","2021 Q4",0,0,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2022-01-01",2022,"Q1","2022 Q1",0,0,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2022-02-01",2022,"Q1","2022 Q1",0,0,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2022-03-01",2022,"Q1","2022 Q1",0,0,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2022-04-01",2022,"Q2","2022 Q2",0,0,1.0200000000000001E-2,0,0]
[null,null,null,null,null,"2022-05-01",2022,"Q2","2022 Q2",0,0,1.0200000000000001E-2,0,0]
[null,null,null,null,null,"2022-06-01",2022,"Q2","2022 Q2",0,0,1.0200000000000001E-2,0,0]
[null,null,null,null,null,"2022-07-01",2022,"Q3","2022 Q3",0,0,2.1999999999999999E-2,0,0]
[null,null,null,null,null,"2022-08-01",2022,"Q3","2022 Q3",0,0,2.1999999999999999E-2,0,0]
[null,null,null,null,null,"2022-09-01",2022,"Q3","2022 Q3",0,0,2.1999999999999999E-2,0,0]
[null,null,null,null,null,"2022-10-01",2022,"Q4","2022 Q4",0,0,3.8699999999999998E-2,0,0]
[null,null,null,null,null,"2022-11-01",2022,"Q4","2022 Q4",0,0,3.8699999999999998E-2,0,0]
[null,null,null,null,null,"2022-12-01",2022,"Q4","2022 Q4",0,0,3.8699999999999998E-2,0,0]
[null,null,null,null,null,"2023-01-01",2023,"Q1","2023 Q1",0,0,4.7300000000000002E-2,0,0]
[null,null,null,null,null,"2023-02-01",2023,"Q1","2023 Q1",0,0,4.7300000000000002E-2,0,0]
[null,null,null,null,null,"2023-03-01",2023,"Q1","2023 Q1",0,0,4.7300000000000002E-2,0,0]
[null,null,null,null,null,"2023-04-01",2023,"Q2","2023 Q2",0,0,4.9799999999999997E-2,0,0]
[null,null,null,null,null,"2023-05-01",2023,"Q2","2023 Q2",0,0,4.9799999999999997E-2,0,0]
[null,null,null,null,null,"2023-06-01",2023,"Q2","2023 Q2",0,0,4.9799999999999997E-2,0,0]
[null,null,null,null,null,"2023-07-01",2023,"Q3","2023 Q3",0,0,4.9799999999999997E-2,0,0]
[null,null,null,null,null,"2023-08-01",2023,"Q3","2023 Q3",0,0,4.9799999999999997E-2,0,0]
[null,null,null,null,null,"2023-09-01",2023,"Q3","2023 Q3",0,0,4.9799999999999997E-2,0,0]
[null,null,null,null,null,"2023-10-01",2023,"Q4","2023 Q4",0,0,5.4899999999999997E-2,0,0]
[null,null,null,null,null,"2023-11-01",2023,"Q4","2023 Q4",0,0,5.4899999999999997E-2,0,0]
[null,null,null,null,null,"2023-12-01",{"$f":"YEAR(F135)","v":2023},{"$f":"IF(MONTH(F135)=0,\"\",IF(MONTH(F135)<4,\"Q1\",IF(MONTH(F135)<7,\"Q2\",IF(MONTH(F135)<10,\"Q3\",\"Q4\"))))","v":"Q4"},{"$f":"CONCATENATE(G135,\" \",H135)","v":"2023 Q4"},{"$f":"J134+K134","v":0},0,{"$f":"VLOOKUP(I135,$B$14:$D$67,2)","v":5.4899999999999997E-2},{"$f":"ROUND(J135*L135/12,2)","v":0},{"$f":"N134+K135+M135","v":0}]
[null,null,null,null,null,"2024-01-01",2024,"Q1","2024 Q1",0,0,5.4899999999999997E-2,0,0]
[null,null,null,null,null,"2024-02-01",2024,"Q1","2024 Q1",0,0,5.4899999999999997E-2,0,0]
[null,null,null,null,null,"2024-03-01",2024,"Q1","2024 Q1",0,0,5.4899999999999997E-2,0,0]
[null,null,null,null,null,"2024-04-01",2024,"Q2","2024 Q2",0,0,5.4899999999999997E-2,0,0]
[null,null,null,null,null,"2024-05-01",2024,"Q2","2024 Q2",0,0,5.4899999999999997E-2,0,0]
[null,null,null,null,null,"2024-06-01",2024,"Q2","2024 Q2",0,0,5.4899999999999997E-2,0,0]
[null,null,null,null,null,"2024-07-01",2024,"Q3","2024 Q3",0,0,5.1999999999999998E-2,0,0]
[null,null,null,null,null,"2024-08-01",2024,"Q3","2024 Q3",0,0,5.1999999999999998E-2,0,0]
[null,null,null,null,null,"2024-09-01",2024,"Q3","2024 Q3",0,0,5.1999999999999998E-2,0,0]
[null,null,null,null,null,"2024-10-01",2024,"Q4","2024 Q4",0,0,4.3999999999999997E-2,0,0]
[null,null,null,null,null,"2024-11-01",2024,"Q4","2024 Q4",0,0,4.3999999999999997E-2,0,0]
[null,null,null,null,null,"2024-12-01",2024,"Q4","2024 Q4",0,0,4.3999999999999997E-2,0,0]
[null,null,null,null,null,"2025-01-01",2025,"Q1","2025 Q1",0,0,3.6400000000000002E-2,0,0]
[null,null,null,null,null,"2025-02-01",2025,"Q1","2025 Q1",0,0,3.6400000000000002E-2,0,0]
[null,null,null,null,null,"2025-03-01",2025,"Q1","2025 Q1",0,0,3.6400000000000002E-2,0,0]
[null,null,null,null,null,"2025-04-01",2025,"Q2","2025 Q2",0,0,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2025-05-01",2025,"Q2","2025 Q2",0,0,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2025-06-01",2025,"Q2","2025 Q2",0,0,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2025-07-01",2025,"Q3","2025 Q3",0,0,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2025-08-01",2025,"Q3","2025 Q3",0,0,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2025-09-01",2025,"Q3","2025 Q3",0,0,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2025-10-01",2025,"Q4","2025 Q4",0,0,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2025-11-01",2025,"Q4","2025 Q4",0,0,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2025-12-01",2025,"Q4","2025 Q4",0,0,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2026-01-01",2026,"Q1","2026 Q1",0,0,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2026-02-01",2026,"Q1","2026 Q1",0,0,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2026-03-01",2026,"Q1","2026 Q1",0,0,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2026-04-01",2026,"Q2","2026 Q2",0,0,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2026-05-01",2026,"Q2","2026 Q2",0,0,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2026-06-01",2026,"Q2","2026 Q2",0,0,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2026-07-01",2026,"Q3","2026 Q3",0,0,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2026-08-01",{"$f":"YEAR(F167)","v":2026},{"$f":"IF(MONTH(F167)=0,\"\",IF(MONTH(F167)<4,\"Q1\",IF(MONTH(F167)<7,\"Q2\",IF(MONTH(F167)<10,\"Q3\",\"Q4\"))))","v":"Q3"},{"$f":"CONCATENATE(G167,\" \",H167)","v":"2026 Q3"},{"$f":"J166+K166","v":0},0,{"$f":"VLOOKUP(I167,$B$14:$D$67,2)","v":3.1600000000000003E-2},{"$f":"ROUND(J167*L167/12,2)","v":0},{"$f":"N166+K167+M167","v":0}]
[null,null,null,null,null,"2026-09-01",2026,"Q3","2026 Q3",0,0,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2026-10-01",2026,"Q4","2026 Q4",0,0,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2026-11-01",2026,"Q4","2026 Q4",0,0,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2026-12-01",2026,"Q4","2026 Q4",0,0,3.1600000000000003E-2,0,0]
[]
[null,null,null,null,null,"Total Funding Adder Revenues Collected",null,null,null,null,{"$f":"SUM(K16:K39)","v":0},null,{"$f":"SUM(M16:M39)","v":0},{"$f":"K173+M173","v":0}]
[]
[null,"NOTE: Funding adder revenues are up to December 2014 actuals"]

{"sheet":"5. MIST Meters_IRR","index":4,"n_rows":70,"n_cols":48,"rows_kept":70,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[]
[]
[]
[null,"MIST Meters True-up Model"]
[]
[]
[]
[]
[null,"Sheet 5: Revenue Requirement Calculations"]
[]
[]
[]
[]
[null,"Return on Rate Base",null,null,2014,null,null,2015,null,null,"2016",null,null,"2017",null,null,"2018",null,null,"2019",null,null,"2020",null,null,"2021",null,null,"2022",null,null,"2023",null,null,"2024",null,null,"2025",null,null,"2026"]
[null," Average Fixed Assets",null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!E268-'2. MIST Meters Assets_Rate Base'!E269","v":213806.30999999997},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!G268-'2. MIST Meters Assets_Rate Base'!G269","v":843456.22},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!I268-'2. MIST Meters Assets_Rate Base'!I269","v":1612602.7749999999},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!K268-'2. MIST Meters Assets_Rate Base'!K269","v":2380435.5749999997},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!M268-'2. MIST Meters Assets_Rate Base'!M269","v":2707696.895},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!O268-'2. MIST Meters Assets_Rate Base'!O269","v":2531050.4900000002},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!Q268-'2. MIST Meters Assets_Rate Base'!Q269","v":2314824.33},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!S268-'2. MIST Meters Assets_Rate Base'!S269","v":2098598.17},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!U268-'2. MIST Meters Assets_Rate Base'!U269","v":1882372.01},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!W268-'2. MIST Meters Assets_Rate Base'!W269","v":1666145.8499999999},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!Y268-'2. MIST Meters Assets_Rate Base'!Y269","v":1449919.6900000002},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!AA268-'2. MIST Meters Assets_Rate Base'!AA269","v":1233693.5300000003},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!AC268-'2. MIST Meters Assets_Rate Base'!AC269","v":1017467.3700000003},"B"]
[null,"Depreciation Expense",null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!E269","v":13793.96},null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!G269","v":55306.46},null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!I269","v":108496.98},null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!K269","v":165034.39000000001},null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!M269","v":196795.39},null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!O269","v":216226.15999999992},null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!Q269","v":216226.16},null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!S269","v":216226.15999999992},null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!U269","v":216226.16},null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!W269","v":216226.16},null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!Y269","v":216226.16},null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!AA269","v":216226.16},null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!AC269","v":216226.16},"C"]
[null,"Net Fixed Assets to be included in Rate Base",null,null,{"$f":"E15-E16","v":200012.34999999998},null,null,{"$f":"H15-H16","v":788149.76000000001},null,null,{"$f":"K15-K16","v":1504105.7949999999},null,null,{"$f":"N15-N16","v":2215401.1849999996},null,null,{"$f":"Q15-Q16","v":2510901.5049999999},null,null,{"$f":"T15-T16","v":2314824.33},null,null,{"$f":"W15-W16","v":2098598.17},null,null,{"$f":"Z15-Z16","v":1882372.01},null,null,{"$f":"AC15-AC16","v":1666145.85},null,null,{"$f":"AF15-AF16","v":1449919.69},null,null,{"$f":"AI15-AI16","v":1233693.5300000003},null,null,{"$f":"AL15-AL16","v":1017467.3700000002},null,null,{"$f":"AO15-AO16","v":801241.21000000031},"D = B - C"]
[]
[null,"Deemed ShortTerm Debt %",0.04,"E",{"$f":"E17*C19","v":8000.4939999999997},{"$f":"'1. Cost of Service_parameters'!I14","v":0.04},null,{"$f":"H17*F19","v":31525.990400000002},{"$f":"'1. Cost of Service_parameters'!K14","v":0.04},null,{"$f":"K17*I19","v":60164.231800000001},{"$f":"'1. Cost of Service_parameters'!M14","v":0.04},null,{"$f":"N17*L19","v":88616.047399999981},{"$f":"L19","v":0.04},null,{"$f":"Q17*O19","v":100436.06019999999},{"$f":"O19","v":0.04},null,{"$f":"T17*R19","v":92592.973200000008},{"$f":"R19","v":0.04},null,{"$f":"W17*U19","v":83943.926800000001},{"$f":"U19","v":0.04},null,{"$f":"Z17*X19","v":75294.880400000009},{"$f":"X19","v":0.04},null,{"$f":"AC17*AA19","v":66645.834000000003},{"$f":"AA19","v":0.04},null,{"$f":"AF17*AD19","v":57996.787599999996},{"$f":"AD19","v":0.04},null,{"$f":"AI17*AG19","v":49347.741200000011},{"$f":"AG19","v":0.04},null,{"$f":"AL17*AJ19","v":40698.694800000012},{"$f":"AJ19","v":0.04},null,{"$f":"AO17*AM19","v":32049.648400000013},"G = D * E"]
[null,"Deemed Long Term Debt %",0.56000000000000005,"F",{"$f":"E17*C20","v":112006.916},{"$f":"'1. Cost of Service_parameters'!I15","v":0.55999999999999994},null,{"$f":"H17*F20","v":441363.86559999996},{"$f":"'1. Cost of Service_parameters'!K15","v":0.55999999999999994},null,{"$f":"K17*I20","v":842299.24519999989},{"$f":"'1. Cost of Service_parameters'!M15","v":0.55999999999999994},null,{"$f":"N17*L20","v":1240624.6635999996},{"$f":"L20","v":0.55999999999999994},null,{"$f":"Q17*O20","v":1406104.8427999998},{"$f":"O20","v":0.55999999999999994},null,{"$f":"T17*R20","v":1296301.6247999999},{"$f":"R20","v":0.55999999999999994},null,{"$f":"W17*U20","v":1175214.9751999998},{"$f":"U20","v":0.55999999999999994},null,{"$f":"Z17*X20","v":1054128.3255999999},{"$f":"X20","v":0.55999999999999994},null,{"$f":"AC17*AA20","v":933041.67599999998},{"$f":"AA20","v":0.55999999999999994},null,{"$f":"AF17*AD20","v":811955.02639999986},{"$f":"AD20","v":0.55999999999999994},null,{"$f":"AI17*AG20","v":690868.37680000009},{"$f":"AG20","v":0.55999999999999994},null,{"$f":"AL17*AJ20","v":569781.72720000008},{"$f":"AJ20","v":0.55999999999999994},null,{"$f":"AO17*AM20","v":448695.07760000014},"H = D * F"]
[]
[null,"Short Term Interest",{"$f":"'1. Cost of Service_parameters'!G21","v":2.0799999999999999E-2},"I",{"$f":"E19*C22","v":166.41027519999997},{"$f":"'1. Cost of Service_parameters'!I21","v":2.0799999999999999E-2},null,{"$f":"H19*F22","v":655.74060032},{"$f":"'1. Cost of Service_parameters'!K21","v":2.0799999999999999E-2},null,{"$f":"K19*I22","v":1251.4160214399999},{"$f":"'1. Cost of Service_parameters'!M21","v":2.0799999999999999E-2},null,{"$f":"N19*L22","v":1843.2137859199995},2.0799999999999999E-2,null,{"$f":"Q19*O22","v":2089.0700521599997},2.0799999999999999E-2,null,{"$f":"T19*R22","v":1925.9338425600001},2.0799999999999999E-2,null,{"$f":"W19*U22","v":1746.03367744},2.0799999999999999E-2,null,{"$f":"Z19*X22","v":1566.1335123200001},2.0799999999999999E-2,null,{"$f":"AC19*AA22","v":1386.2333472},2.0799999999999999E-2,null,{"$f":"AF19*AD22","v":1206.3331820799999},2.0799999999999999E-2,null,{"$f":"AI19*AG22","v":1026.4330169600003},2.0799999999999999E-2,null,{"$f":"AL19*AJ22","v":846.53285184000026},2.0799999999999999E-2,null,{"$f":"AO19*AM22","v":666.63268672000027},"K = G * I"]
[null,"Long Term Interest",{"$f":"'1. Cost of Service_parameters'!G22","v":5.0914000000000001E-2},"J",{"$f":"E20*C23","v":5702.7201212239997},{"$f":"'1. Cost of Service_parameters'!I22","v":5.0914000000000001E-2},null,{"$f":"H20*F23","v":22471.599853158397},{"$f":"'1. Cost of Service_parameters'!K22","v":5.0914000000000001E-2},null,{"$f":"K20*I23","v":42884.823770112795},{"$f":"'1. Cost of Service_parameters'!M22","v":5.0914000000000001E-2},null,{"$f":"N20*L23","v":63165.164122530383},5.0914000000000001E-2,null,{"$f":"Q20*O23","v":71590.421966319191},5.0914000000000001E-2,null,{"$f":"T20*R23","v":65999.900925067195},5.0914000000000001E-2,null,{"$f":"W20*U23","v":59834.895247332788},5.0914000000000001E-2,null,{"$f":"Z20*X23","v":53669.889569598396},5.0914000000000001E-2,null,{"$f":"AC20*AA23","v":47504.883891864003},5.0914000000000001E-2,null,{"$f":"AF20*AD23","v":41339.878214129596},5.0914000000000001E-2,null,{"$f":"AI20*AG23","v":35174.872536395203},5.0914000000000001E-2,null,{"$f":"AL20*AJ23","v":29009.866858660804},5.0914000000000001E-2,null,{"$f":"AO20*AM23","v":22844.861180926408},"L = H * J"]
[]
[null,"Return on Rate Base - Interest",null,null,{"$f":"SUM(E22:E23)","v":5869.1303964239996},null,null,{"$f":"SUM(H22:H23)","v":23127.340453478399},null,null,{"$f":"SUM(K22:K23)","v":44136.239791552798},null,null,{"$f":"SUM(N22:N23)","v":65008.377908450384},null,null,{"$f":"SUM(Q22:Q23)","v":73679.492018479184},null,null,{"$f":"SUM(T22:T23)","v":67925.834767627195},null,null,{"$f":"SUM(W22:W23)","v":61580.928924772787},null,null,{"$f":"SUM(Z22:Z23)","v":55236.023081918393},null,null,{"$f":"SUM(AC22:AC23)","v":48891.117239064006},null,null,{"$f":"SUM(AF22:AF23)","v":42546.211396209597},null,null,{"$f":"SUM(AI22:AI23)","v":36201.305553355203},null,null,{"$f":"SUM(AL22:AL23)","v":29856.399710500806},null,null,{"$f":"SUM(AO22:AO23)","v":23511.493867646408},"M = K + L"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aaa"]
[null,"Deemed Equity %",{"$f":"'1. Cost of Service_parameters'!G16","v":0.40000000000000008},"N",{"$f":"E17*C28","v":80004.94},{"$f":"'1. Cost of Service_parameters'!I16","v":0.40000000000000008},null,{"$f":"H17*F28","v":315259.90400000004},{"$f":"'1. Cost of Service_parameters'!K16","v":0.40000000000000008},null,{"$f":"K17*I28","v":601642.31800000009},{"$f":"'1. Cost of Service_parameters'!M16","v":0.40000000000000008},null,{"$f":"N17*L28","v":886160.47400000005},0.40000000000000008,null,{"$f":"Q17*O28","v":1004360.6020000002},0.40000000000000008,null,{"$f":"T17*R28","v":925929.73200000019},0.40000000000000008,null,{"$f":"W17*U28","v":839439.26800000016},0.40000000000000008,null,{"$f":"Z17*X28","v":752948.80400000012},0.40000000000000008,null,{"$f":"AC17*AA28","v":666458.3400000002},0.40000000000000008,null,{"$f":"AF17*AD28","v":579967.87600000005},0.40000000000000008,null,{"$f":"AI17*AG28","v":493477.41200000019},0.40000000000000008,null,{"$f":"AL17*AJ28","v":406986.94800000015},0.40000000000000008,null,{"$f":"AO17*AM28","v":320496.48400000017},"P = D * N"]
[]
[null,"Return on Rate Base -Equity",{"$f":"'1. Cost of Service_parameters'!G23","v":8.9300000000000004E-2},"O",{"$f":"E28*C30","v":7144.4411420000006},{"$f":"'1. Cost of Service_parameters'!I23","v":8.9300000000000004E-2},null,{"$f":"H28*F30","v":28152.709427200003},{"$f":"'1. Cost of Service_parameters'!K23","v":8.9300000000000004E-2},null,{"$f":"K28*I30","v":53726.658997400009},{"$f":"'1. Cost of Service_parameters'!M23","v":8.9300000000000004E-2},null,{"$f":"N28*L30","v":79134.130328200001},null,null,{"$f":"Q28*O30","v":0},{"$f":"'1. Cost of Service_parameters'!R23","v":0},null,{"$f":"T28*R30","v":0},{"$f":"'1. Cost of Service_parameters'!U23","v":8.9300000000000004E-2},null,{"$f":"W28*U30","v":74961.92663240002},{"$f":"'1. Cost of Service_parameters'!X23","v":0},null,{"$f":"Z28*X30","v":0},{"$f":"'1. Cost of Service_parameters'!AA23","v":8.9300000000000004E-2},null,{"$f":"AC28*AA30","v":59514.729762000017},{"$f":"'1. Cost of Service_parameters'!AD23","v":0},null,{"$f":"AF28*AD30","v":0},{"$f":"'1. Cost of Service_parameters'!AG23","v":0},null,{"$f":"AI28*AG30","v":0},{"$f":"'1. Cost of Service_parameters'!AJ23","v":0},null,{"$f":"AL28*AJ30","v":0},{"$f":"'1. Cost of Service_parameters'!AM23","v":0},null,{"$f":"AO28*AM30","v":0},"Q = P * O"]
[]
[null,"Return on Rate Base - Total",null,null,{"$f":"E25+E30","v":13013.571538423999},null,null,{"$f":"H25+H30","v":51280.049880678402},null,null,{"$f":"K25+K30","v":97862.898788952807},null,null,{"$f":"N25+N30","v":144142.50823665038},null,null,{"$f":"Q25+Q30","v":73679.492018479184},null,null,{"$f":"T25+T30","v":67925.834767627195},null,null,{"$f":"W25+W30","v":136542.85555717279},null,null,{"$f":"Z25+Z30","v":55236.023081918393},null,null,{"$f":"AC25+AC30","v":108405.84700106402},null,null,{"$f":"AF25+AF30","v":42546.211396209597},null,null,{"$f":"AI25+AI30","v":36201.305553355203},null,null,{"$f":"AL25+AL30","v":29856.399710500806},null,null,{"$f":"AO25+AO30","v":23511.493867646408},"R = M + Q"]
[]
[]
[]
[null,"Amortization Expense"]
[]
[null,"Amortization Expense - Incremental",null,"C",{"$f":"E16","v":13793.96},null,null,{"$f":"H16","v":55306.46},null,null,{"$f":"K16","v":108496.98},null,null,{"$f":"N16","v":165034.39000000001},null,null,{"$f":"Q16","v":196795.39},null,null,{"$f":"T16","v":216226.15999999992},null,null,{"$f":"W16","v":216226.16},null,null,{"$f":"Z16","v":216226.15999999992},null,null,{"$f":"AC16","v":216226.16},null,null,{"$f":"AF16","v":216226.16},null,null,{"$f":"AI16","v":216226.16},null,null,{"$f":"AL16","v":216226.16},null,null,{"$f":"AO16","v":216226.16},"S"]
[]
[]
[null,"OM&A Expense"]
[]
[null,"OM&A Expense - Incremental",null,"D",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25769.78]
[]
[]
[]
[]
[null,"Grossed up PIL's"]
[]
[null,"Regulatory Taxable Income",null,"O",{"$f":"E30","v":7144.4411420000006},null,null,{"$f":"H30","v":28152.709427200003},null,null,{"$f":"K30","v":53726.658997400009},null,null,{"$f":"N30","v":79134.130328200001},null,null,{"$f":"Q30","v":0},null,null,{"$f":"T30","v":0},null,null,{"$f":"W30","v":74961.92663240002},null,null,{"$f":"Z30","v":0},null,null,{"$f":"AC30","v":59514.729762000017},null,null,{"$f":"AF30","v":0},null,null,{"$f":"AI30","v":0},null,null,{"$f":"AL30","v":0},null,null,{"$f":"AO30","v":0},"T "]
[]
[null,"Add Back Amortization Expense",null,"S",{"$f":"E38","v":13793.96},null,null,{"$f":"H38","v":55306.46},null,null,{"$f":"K38","v":108496.98},null,null,{"$f":"N38","v":165034.39000000001},null,null,{"$f":"Q38","v":196795.39},null,null,{"$f":"T38","v":216226.15999999992},null,null,{"$f":"W38","v":216226.16},null,null,{"$f":"Z38","v":216226.15999999992},null,null,{"$f":"AC38","v":216226.16},null,null,{"$f":"AF38","v":216226.16},null,null,{"$f":"AI38","v":216226.16},null,null,{"$f":"AL38","v":216226.16},null,null,{"$f":"AO38","v":216226.16},"U"]
[]
[null,"Deduct CCA",null,null,{"$f":"'3. UCC_Calculations'!D88","v":16552.7464},null,null,{"$f":"'3. UCC_Calculations'!F88","v":65043.536287999996},null,null,{"$f":"'3. UCC_Calculations'!I88","v":0},null,null,{"$f":"'3. UCC_Calculations'!L88","v":205203.67741159018},null,null,{"$f":"'3. UCC_Calculations'!L88","v":205203.67741159018},null,null,{"$f":"'3. UCC_Calculations'!O88","v":0},null,null,{"$f":"'3. UCC_Calculations'!R88","v":160496.12107947635},null,null,{"$f":"'3. UCC_Calculations'!U88","v":0},null,null,{"$f":"'3. UCC_Calculations'!X88","v":124976.40353113526},null,null,{"$f":"'3. UCC_Calculations'!AA88","v":0},null,null,{"$f":"'3. UCC_Calculations'!AD88","v":0},null,null,{"$f":"'3. UCC_Calculations'!AG88","v":0},null,null,{"$f":"'3. UCC_Calculations'!AJ88","v":0},"V"]
[]
[null,"Incremental Taxable Income",null,null,{"$f":"E50+E52-E54","v":4385.6547419999988},null,null,{"$f":"H50+H52-H54","v":18415.633139200007},null,null,{"$f":"K50+K52-K54","v":162223.6389974},null,null,{"$f":"N50+N52-N54","v":38964.842916609836},null,null,{"$f":"Q50+Q52-Q54","v":-8408.287411590165},null,null,{"$f":"T50+T52-T54","v":216226.15999999992},null,null,{"$f":"W50+W52-W54","v":130691.96555292371},null,null,{"$f":"Z50+Z52-Z54","v":216226.15999999992},null,null,{"$f":"AC50+AC52-AC54","v":150764.48623086474},null,null,{"$f":"AF50+AF52-AF54","v":216226.16},null,null,{"$f":"AI50+AI52-AI54","v":216226.16},null,null,{"$f":"AL50+AL52-AL54","v":216226.16},null,null,{"$f":"AO50+AO52-AO54","v":216226.16},"W = T + U - V"]
[]
[null,"Current Tax Rate (F1.1 Z-Factor Tax Changes)",0.26500000000000001,"X",null,0.26500000000000001,null,null,0.26500000000000001,null,null,0.26500000000000001,null,null,0.26500000000000001,null,null,0.26500000000000001,null,null,0.26500000000000001,null,null,0.26500000000000001,null,null,0.26500000000000001,null,null,0.26500000000000001,null,null,0.26500000000000001,null,null,0.26500000000000001,null,null,0.26500000000000001]
[]
[null,"PIL's Before Gross Up",null,null,{"$f":"E56*C58","v":1162.1985066299997},null,null,{"$f":"H56*F58","v":4880.142781888002},null,null,{"$f":"K56*I58","v":42989.264334311003},null,null,{"$f":"N56*L58","v":10325.683372901607},null,null,{"$f":"Q56*O58","v":-2228.1961640713939},null,null,{"$f":"T56*R58","v":57299.932399999983},null,null,{"$f":"W56*U58","v":34633.370871524785},null,null,{"$f":"Z56*X58","v":57299.932399999983},null,null,{"$f":"AC56*AA58","v":39952.588851179156},null,null,{"$f":"AF56*AD58","v":57299.932400000005},null,null,{"$f":"AI56*AG58","v":57299.932400000005},null,null,{"$f":"AL56*AJ58","v":57299.932400000005},null,null,{"$f":"AO56*AM58","v":57299.932400000005},"Y = W * X"]
[]
[null,"Incremental Grossed Up PIL's",null,null,{"$f":"E60/(1-C58)","v":1581.2224579999995},null,null,{"$f":"H60/(1-F58)","v":6639.650043385037},null,null,{"$f":"K60/(1-I58)","v":58488.79501266803},null,null,{"$f":"N60/(1-L58)","v":14048.548806668854},null,null,{"$f":"Q60/(1-O58)","v":-3031.5594068998557},null,null,{"$f":"T60/(1-R58)","v":77959.091700680248},null,null,{"$f":"W60/(1-U58)","v":47120.232478265018},null,null,{"$f":"Z60/(1-X58)","v":77959.091700680248},null,null,{"$f":"AC60/(1-AA58)","v":54357.263743100892},null,null,{"$f":"AF60/(1-AD58)","v":77959.091700680277},null,null,{"$f":"AI60/(1-AG58)","v":77959.091700680277},null,null,{"$f":"AL60/(1-AJ58)","v":77959.091700680277},null,null,{"$f":"AO60/(1-AM58)","v":77959.091700680277},"Z = Y / ( 1 - X ) "]
[]
[]
[null,"Incremental Revenue Requirement"]
[null,"Return on Rate Base - Total",null,"Q",{"$f":"E32","v":13013.571538423999},null,null,{"$f":"H32","v":51280.049880678402},null,null,{"$f":"K32","v":97862.898788952807},null,null,{"$f":"N32","v":144142.50823665038},null,null,{"$f":"Q32","v":73679.492018479184},null,null,{"$f":"T32","v":67925.834767627195},null,null,{"$f":"W32","v":136542.85555717279},null,null,{"$f":"Z32","v":55236.023081918393},null,null,{"$f":"AC32","v":108405.84700106402},null,null,{"$f":"AF32","v":42546.211396209597},null,null,{"$f":"AI32","v":36201.305553355203},null,null,{"$f":"AL32","v":29856.399710500806},null,null,{"$f":"AO32","v":23511.493867646408},"AF"]
[null,"Amortization Expense - Total",null,"S",{"$f":"E38","v":13793.96},null,null,{"$f":"H38","v":55306.46},null,null,{"$f":"K38","v":108496.98},null,null,{"$f":"N38","v":165034.39000000001},null,null,{"$f":"Q38","v":196795.39},null,null,{"$f":"T38","v":216226.15999999992},null,null,{"$f":"W38","v":216226.16},null,null,{"$f":"Z38","v":216226.15999999992},null,null,{"$f":"AC38","v":216226.16},null,null,{"$f":"AF38","v":216226.16},null,null,{"$f":"AI38","v":216226.16},null,null,{"$f":"AL38","v":216226.16},null,null,{"$f":"AO38","v":216226.16},"AG"]
[null,"Incremental Grossed Up PIL's",null,"Z",{"$f":"E62","v":1581.2224579999995},null,null,{"$f":"H62","v":6639.650043385037},null,null,{"$f":"K62","v":58488.79501266803},null,null,{"$f":"N62","v":14048.548806668854},null,null,{"$f":"Q62","v":-3031.5594068998557},null,null,{"$f":"T62","v":77959.091700680248},null,null,{"$f":"W62","v":47120.232478265018},null,null,{"$f":"Z62","v":77959.091700680248},null,null,{"$f":"AC62","v":54357.263743100892},null,null,{"$f":"AF62","v":77959.091700680277},null,null,{"$f":"AI62","v":77959.091700680277},null,null,{"$f":"AL62","v":77959.091700680277},null,null,{"$f":"AO62","v":77959.091700680277},"AH"]
[null,"OM&A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z43","v":25769.78}]
[null,"Incremental Revenue Requirement",null,null,{"$f":"SUM(E66:E68)","v":28388.753996423999},null,null,{"$f":"SUM(H66:H68)","v":113226.15992406344},null,null,{"$f":"SUM(K66:K68)","v":264848.67380162084},null,null,{"$f":"SUM(N66:N68)","v":323225.44704331923},null,null,{"$f":"SUM(Q66:Q68)","v":267443.32261157932},null,null,{"$f":"SUM(T66:T68)","v":362111.08646830736},null,null,{"$f":"SUM(W66:W68)","v":399889.24803543783},null,null,{"$f":"SUM(Z66:Z69)","v":375191.05478259851},null,null,{"$f":"SUM(AC66:AC68)","v":378989.27074416494},null,null,{"$f":"SUM(AF66:AF68)","v":336731.4630968899},null,null,{"$f":"SUM(AI66:AI68)","v":330386.55725403549},null,null,{"$f":"SUM(AL66:AL68)","v":324041.65141118108},null,null,{"$f":"SUM(AO66:AO68)","v":317696.74556832667},"AJ = AF + AG + AH + AI"]

{"sheet":"6. True-up Summary","index":5,"n_rows":21,"n_cols":31,"rows_kept":21,"cut":false,"hidden":false,"merged":[[11,2,11,3],[3,3,3,6]]}
[]
[]
[]
[null,null,null,"MIST Meters True-up Model"]
[]
[]
[]
[]
[null,"Sheet 6: MIST Meters Incremental Revenue Requirement"]
[null,null," "]
[]
[null,null,null,null,2014,null,2015,null,2016,null,2017,null,2018,null,2019,null,2020,null,2021,null,2022,null,2023,null,2024,null,2025,null,2026,null,"Total"]
[]
[null,null,"Deferred and forecasted MIST Meters Revenue Requirement (from Sheet 5)",null,{"$f":"'5. MIST Meters_IRR'!E70","v":28388.753996423999},null,{"$f":"'5. MIST Meters_IRR'!H70","v":113226.15992406344},null,{"$f":"'5. MIST Meters_IRR'!K70","v":264848.67380162084},null,{"$f":"'5. MIST Meters_IRR'!N70","v":323225.44704331923},null,{"$f":"'5. MIST Meters_IRR'!Q70","v":267443.32261157932},null,{"$f":"'5. MIST Meters_IRR'!T70","v":362111.08646830736},null,{"$f":"'5. MIST Meters_IRR'!W70","v":399889.24803543783},null,{"$f":"'5. MIST Meters_IRR'!Z70","v":375191.05478259851},null,{"$f":"'5. MIST Meters_IRR'!AC70","v":378989.27074416494},null,{"$f":"'5. MIST Meters_IRR'!AF70","v":336731.4630968899},null,{"$f":"'5. MIST Meters_IRR'!AI70","v":330386.55725403549},null,{"$f":"'5. MIST Meters_IRR'!AL70","v":324041.65141118108},null,{"$f":"'5. MIST Meters_IRR'!AO70","v":317696.74556832667},null,{"$f":"SUM(E14:AC14)","v":3822169.4347379487}]
[]
[]
[null,null,"MIST Meters Funding Adder Revenues (from Sheet 4)",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"SUM(E17:G17)","v":0}]
[]
[null,null,"MIST Meters Funding Adder Interest (from Sheet 4)",null,{"$f":"SUM('4. Fund Adder Revenues'!M19:M27)","v":0},null,{"$f":"SUM('4. Fund Adder Revenues'!M28:M39)","v":0},null,{"$f":"SUM('4. Fund Adder Revenues'!O28:O39)","v":0},null,{"$f":"SUM('4. Fund Adder Revenues'!Q28:Q39)","v":0},null,{"$f":"SUM('4. Fund Adder Revenues'!S28:S39)","v":0},null,{"$f":"SUM('4. Fund Adder Revenues'!U28:U39)","v":0},null,{"$f":"SUM('4. Fund Adder Revenues'!W28:W39)","v":0},null,{"$f":"SUM('4. Fund Adder Revenues'!Y28:Y39)","v":0},null,{"$f":"SUM('4. Fund Adder Revenues'!AA28:AA39)","v":0},null,{"$f":"SUM('4. Fund Adder Revenues'!AC28:AC39)","v":0},null,{"$f":"SUM('4. Fund Adder Revenues'!AE28:AE39)","v":0},null,{"$f":"SUM('4. Fund Adder Revenues'!AG28:AG39)","v":0},null,{"$f":"SUM('4. Fund Adder Revenues'!AI28:AI39)","v":0},null,{"$f":"SUM(E19:G19)","v":0}]
[]
[null,null,"Net Deferred Revenue Requirement",null,{"$f":"E14-E17-E19","v":28388.753996423999},null,{"$f":"G14-G17-G19","v":113226.15992406344},null,{"$f":"I14-I17-I19","v":264848.67380162084},null,{"$f":"K14-K17-K19","v":323225.44704331923},null,{"$f":"M14-M17-M19","v":267443.32261157932},null,{"$f":"O14-O17-O19","v":362111.08646830736},null,{"$f":"Q14-Q17-Q19","v":399889.24803543783},null,{"$f":"S14-S17-S19","v":375191.05478259851},null,{"$f":"U14-U17-U19","v":378989.27074416494},null,{"$f":"W14-W17-W19","v":336731.4630968899},null,{"$f":"Y14-Y17-Y19","v":330386.55725403549},null,{"$f":"AA14-AA17-AA19","v":324041.65141118108},null,{"$f":"AC14-AC17-AC19","v":317696.74556832667},null,{"$f":"SUM(E21:AC21)","v":3822169.4347379487}]