{"text_format":"1","workbook":"xlsx","n_sheets":7,"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","Cognos_Office_Connection_Cache"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":274,"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":17,"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,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026]
[null,"Cost of Capital"]
[null,null,"Capital Structure"]
[null,null,null,"Deemed Short-term Debt Capitalization",null,null,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04]
[null,null,null,"Deemed Long-term Debt Capitalization",null,null,{"$f":"60%-G14","v":0.55999999999999994},{"$f":"G15-(H14-G14)","v":0.55999999999999994},{"$f":"H15-(I14-H14)","v":0.55999999999999994},0.55999999999999994,0.55999999999999994,0.55999999999999994,0.55999999999999994,{"$f":"M15-(N14-M14)","v":0.55999999999999994},{"$f":"N15-(O14-N14)","v":0.55999999999999994},0.55999999999999994,0.55999999999999994]
[null,null,null,"Deemed Equity Capitalization",null,null,{"$f":"100%-G15-G17-G14","v":0.40000000000000008},{"$f":"100%-H15-H17-H14","v":0.40000000000000008},{"$f":"100%-I15-I17-I14","v":0.40000000000000008},0.40000000000000008,0.40000000000000008,0.40000000000000008,0.40000000000000008,{"$f":"100%-N15-N17-N14","v":0.40000000000000008},{"$f":"100%-O15-O17-O14","v":0.40000000000000008},0.40000000000000008,{"$f":"100%-Q15-Q17-Q14","v":0.40000000000000008}]
[null,null,null,"Preferred Shares"]
[null,null,"Total",null,null,null,{"$f":"SUM(G14:G17)","v":1},{"$f":"SUM(H14:H17)","v":1},{"$f":"SUM(I14:I17)","v":1},1,1,1,1,1,1,{"$f":"SUM(P14:P17)","v":1},1]
[]
[null,null,"Cost of Capital Parameters"]
[null,null,null,"Deemed Short-term Debt Rate",null,null,1.7600000000000001E-2,1.7600000000000001E-2,1.7600000000000001E-2,1.7600000000000001E-2,1.7600000000000001E-2,1.7600000000000001E-2,1.7600000000000001E-2,1.7600000000000001E-2,1.7600000000000001E-2,1.7600000000000001E-2,1.7600000000000001E-2]
[null,null,null,"Long-term Debt Rate (actual/embedded/deemed)1",null,null,3.8825037148941706E-2,3.8825037148941706E-2,3.8825037148941706E-2,3.8825037148941706E-2,3.8825037148941706E-2,3.8825037148941706E-2,3.8825037148941706E-2,3.8825037148941706E-2,3.8825037148941706E-2,3.8825037148941706E-2,3.8825037148941706E-2]
[null,null,null,"Target Return on Equity (ROE)",null,null,8.7800000000000003E-2,8.7800000000000003E-2,8.7800000000000003E-2,8.7800000000000003E-2,8.7800000000000003E-2,8.7800000000000003E-2,8.7800000000000003E-2,8.7800000000000003E-2,8.7800000000000003E-2,8.7800000000000003E-2,8.7800000000000003E-2]
[null,null,null,"Return on Preferred Shares"]
[null,null,"WACC",null,null,null,{"$f":"SUMPRODUCT(G14:G17,G21:G24)","v":5.7566020803407357E-2},{"$f":"SUMPRODUCT(H14:H17,H21:H24)","v":5.7566020803407357E-2},{"$f":"SUMPRODUCT(I14:I17,I21:I24)","v":5.7566020803407357E-2},5.7566020803407357E-2,5.7566020803407357E-2,5.7566020803407357E-2,5.7566020803407357E-2,5.7566020803407357E-2,5.7566020803407357E-2,{"$f":"SUMPRODUCT(P14:P17,P21:P24)","v":5.7566020803407357E-2},5.7566020803407357E-2]
[]
[null,"Working Capital Allowance"]
[null,null,"Working Capital Allowance Rate",null,null,null,7.4999999999999997E-2,7.4999999999999997E-2,7.4999999999999997E-2,7.4999999999999997E-2,7.4999999999999997E-2,7.4999999999999997E-2,7.4999999999999997E-2,7.4999999999999997E-2,7.4999999999999997E-2,7.4999999999999997E-2,7.4999999999999997E-2]
[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,0.26500000000000001,0.26500000000000001,0.26500000000000001,0.26500000000000001,0.26500000000000001,0.26500000000000001,0.26500000000000001,0.26500000000000001,0.26500000000000001,0.26500000000000001]
[null,null,"Capital Tax (until July 1st, 2010)",null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Depreciation Rates",null,null,"Account"]
[null,"(expressed as expected useful life in years)"]
[]
[null,null,null,"Year",1822,null,20,20,20,20,20,20,20,20,20,20,20]
[null,null,"                              - rate (%)","Rate (%)",null,null,{"$f":"IF(G38=0,0,1/G38)","v":0.05},{"$f":"IF(H38=0,0,1/H38)","v":0.05},{"$f":"IF(I38=0,0,1/I38)","v":0.05},0.05,0.05,0.05,0.05,0.05,0.05,{"$f":"IF(P38=0,0,1/P38)","v":0.05},0.05]
[]
[null,null,null,"Year",1845,null,45,45,45,45,45,45,45,45,45,45,45]
[null,null,"                              - rate (%)","Rate (%)",null,null,{"$f":"IF(G41=0,0,1/G41)","v":2.2222222222222223E-2},{"$f":"IF(H41=0,0,1/H41)","v":2.2222222222222223E-2},{"$f":"IF(I41=0,0,1/I41)","v":2.2222222222222223E-2},2.2222222222222223E-2,2.2222222222222223E-2,2.2222222222222223E-2,2.2222222222222223E-2,2.2222222222222223E-2,2.2222222222222223E-2,{"$f":"IF(P41=0,0,1/P41)","v":2.2222222222222223E-2},2.2222222222222223E-2]
[]
[null,null,null,"Year",1930,null,7,7,7,7,7,7,7,7,7,7,7]
[null,null,"                              - rate (%)","Rate (%)",null,null,{"$f":"IF(G44=0,0,1/G44)","v":0.14285714285714285},{"$f":"IF(H44=0,0,1/H44)","v":0.14285714285714285},{"$f":"IF(I44=0,0,1/I44)","v":0.14285714285714285},0.14285714285714285,0.14285714285714285,0.14285714285714285,0.14285714285714285,0.14285714285714285,0.14285714285714285,{"$f":"IF(P44=0,0,1/P44)","v":0.14285714285714285},0.14285714285714285]
[]
[null,null,null,"Year",1835,null,40,40,40,40,40,40,40,40,40,40,40]
[null,null,"                              - rate (%)","Rate (%)",null,null,{"$f":"IF(G47=0,0,1/G47)","v":2.5000000000000001E-2},{"$f":"IF(H47=0,0,1/H47)","v":2.5000000000000001E-2},{"$f":"IF(I47=0,0,1/I47)","v":2.5000000000000001E-2},2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,{"$f":"IF(P47=0,0,1/P47)","v":2.5000000000000001E-2},2.5000000000000001E-2]
[]
[null,null,null,"Year",1921,null,4,4,4,4,4,4,4,4,4,4,4]
[null,null,"                              - rate (%)","Rate (%)",null,null,{"$f":"IF(G50=0,0,1/G50)","v":0.25},{"$f":"IF(H50=0,0,1/H50)","v":0.25},{"$f":"IF(I50=0,0,1/I50)","v":0.25},0.25,0.25,0.25,0.25,0.25,0.25,{"$f":"IF(P50=0,0,1/P50)","v":0.25},0.25]
[]
[null,null,null,"Year",1935,null,10,10,10,10,10,10,10,10,10,10,10]
[null,null,"                              - rate (%)","Rate (%)",null,null,{"$f":"IF(G53=0,0,1/G53)","v":0.1},{"$f":"IF(H53=0,0,1/H53)","v":0.1},{"$f":"IF(I53=0,0,1/I53)","v":0.1},0.1,0.1,0.1,0.1,0.1,0.1,{"$f":"IF(P53=0,0,1/P53)","v":0.1},0.1]
[]
[null,null,null,"Year",1926,null,3,3,3,3,3,3,3,3,3,3,3]
[null,null,"                              - rate (%)","Rate (%)",null,null,{"$f":"IF(G56=0,0,1/G56)","v":0.33333333333333331},{"$f":"IF(H56=0,0,1/H56)","v":0.33333333333333331},{"$f":"IF(I56=0,0,1/I56)","v":0.33333333333333331},0.33333333333333331,0.33333333333333331,0.33333333333333331,0.33333333333333331,0.33333333333333331,0.33333333333333331,{"$f":"IF(P56=0,0,1/P56)","v":0.33333333333333331},0.33333333333333331]
[]
[null,null,null,"Year",1860,null,15,15,15,15,15,15,15,15,15,15,15]
[null,null,"                              - rate (%)","Rate (%)",null,null,{"$f":"IF(G59=0,0,1/G59)","v":6.6666666666666666E-2},{"$f":"IF(H59=0,0,1/H59)","v":6.6666666666666666E-2},{"$f":"IF(I59=0,0,1/I59)","v":6.6666666666666666E-2},6.6666666666666666E-2,6.6666666666666666E-2,6.6666666666666666E-2,6.6666666666666666E-2,6.6666666666666666E-2,6.6666666666666666E-2,{"$f":"IF(P59=0,0,1/P59)","v":6.6666666666666666E-2},6.6666666666666666E-2]
[]
[null,null,null,"Year",1924,null,6,6,6,6,6,6,6,6,6,6,6]
[null,null,"                              - rate (%)","Rate (%)",null,null,{"$f":"IF(G62=0,0,1/G62)","v":0.16666666666666666},{"$f":"IF(H62=0,0,1/H62)","v":0.16666666666666666},{"$f":"IF(I62=0,0,1/I62)","v":0.16666666666666666},0.16666666666666666,0.16666666666666666,0.16666666666666666,0.16666666666666666,0.16666666666666666,0.16666666666666666,{"$f":"IF(P62=0,0,1/P62)","v":0.16666666666666666},0.16666666666666666]
[]
[null,null,null,"Year",1850,null,30,30,30,30,30,30,30,30,30,30,30]
[null,null,"                              - rate (%)","Rate (%)",null,null,{"$f":"IF(G65=0,0,1/G65)","v":3.3333333333333333E-2},{"$f":"IF(H65=0,0,1/H65)","v":3.3333333333333333E-2},{"$f":"IF(I65=0,0,1/I65)","v":3.3333333333333333E-2},3.3333333333333333E-2,3.3333333333333333E-2,3.3333333333333333E-2,3.3333333333333333E-2,3.3333333333333333E-2,3.3333333333333333E-2,{"$f":"IF(P65=0,0,1/P65)","v":3.3333333333333333E-2},3.3333333333333333E-2]
[]
[null,null,null,"Year",1982,null,10,10,10,10,10,10,10,10,10,10,10]
[null,null,"                              - rate (%)","Rate (%)",null,null,{"$f":"IF(G68=0,0,1/G68)","v":0.1},{"$f":"IF(H68=0,0,1/H68)","v":0.1},{"$f":"IF(I68=0,0,1/I68)","v":0.1},0.1,0.1,0.1,0.1,0.1,0.1,{"$f":"IF(P68=0,0,1/P68)","v":0.1},0.1]
[]
[null,null,null,"Year",1955,null,6,6,6,6,6,6,6,6,6,6,6]
[null,null,"                              - rate (%)","Rate (%)",null,null,{"$f":"IF(G71=0,0,1/G71)","v":0.16666666666666666},{"$f":"IF(H71=0,0,1/H71)","v":0.16666666666666666},{"$f":"IF(I71=0,0,1/I71)","v":0.16666666666666666},0.16666666666666666,0.16666666666666666,0.16666666666666666,0.16666666666666666,0.16666666666666666,0.16666666666666666,{"$f":"IF(P71=0,0,1/P71)","v":0.16666666666666666},0.16666666666666666]
[]
[null,"CCA Rates"]
[null,null,null,"CCA Class",1822,null,47,47,47,47,47,47,47,47,47,47,47]
[null,null,null,"CCA Rate",null,null,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[]
[null,null,null,"CCA Class",1845,null,47,47,47,47,47,47,47,47,47,47,47]
[null,null,null,"CCA Rate",null,null,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[]
[null,null,null,"CCA Class",1930,null,10,10,10,10,10,10,10,10,10,10,10]
[null,null,null,"CCA Rate",null,null,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3]
[]
[null,null,null,"CCA Class",1835,null,47,47,47,47,47,47,47,47,47,47,47]
[null,null,null,"CCA Rate",null,null,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[]
[null,null,null,"CCA Class",1921,null,50,50,50,50,50,50,50,50,50,50,50]
[null,null,null,"CCA Rate",null,null,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004]
[]
[null,null,null,"CCA Class",1935,null,8,8,8,8,8,8,8,8,8,8,8]
[null,null,null,"CCA Rate",null,null,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2]
[]
[null,null,null,"CCA Class",1926,null,12,12,12,12,12,12,12,12,12,12,12]
[null,null,null,"CCA Rate",null,null,1,1,1,1,1,1,1,1,1,1,1]
[]
[null,null,null,"CCA Class",1860,null,47,47,47,47,47,47,47,47,47,47,47]
[null,null,null,"CCA Rate",null,null,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[]
[null,null,null,"CCA Class",1924,null,50,50,50,50,50,50,50,50,50,50,50]
[null,null,null,"CCA Rate",null,null,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004]
[]
[null,null,null,"CCA Class",1850,null,47,47,47,47,47,47,47,47,47,47,47]
[null,null,null,"CCA Rate",null,null,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[]
[null,null,null,"CCA Class",1982,null,8,8,8,8,8,8,8,8,8,8,8]
[null,null,null,"CCA Rate",null,null,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2]
[]
[null,null,null,"CCA Class",1955,null,8,8,8,8,8,8,8,8,8,8,8]
[null,null,null,"CCA Rate",null,null,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,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":15,"rows_kept":269,"cut":false,"hidden":false,"merged":[[3,3,3,4]]}
[]
[]
[]
[null,null,null,"MIST Meters True-up Model"]
[]
[]
[]
[]
[null,"Sheet 2: 1557 - Net Book Value"]
[null,null,null,null,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026]
[null,"Net Fixed Assets - 1860"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",0,{"$f":"E17","v":1985917.65},{"$f":"F17","v":2026921.0199999998},3693737.0699999994,3705805.1499999994,5954476.5599999996,7936900.7399999993,9013159.6199999992,9037747.7399999984,9037747.7399999984,9037747.7399999984]
[null,null,null,"Capital Additions during year ",1985917.65,41003.369999999937,1666816.0499999998,12068.08,2248671.41,1982424.18,1076258.8799999999,24588.12,0,0,0]
[null,null,null,"Retirements/Removals (if applicable)",null,0,null,0,null,0,0,0,0,0,0]
[null,null,null,"Closing Balance",{"$f":"E14+E15-E16","v":1985917.65},{"$f":"F14+F15-F16","v":2026921.0199999998},{"$f":"G14+G15-G16","v":3693737.0699999994},3705805.1499999994,5954476.5599999996,7936900.7399999993,9013159.6199999992,9037747.7399999984,9037747.7399999984,{"$f":"N14+N15-N16","v":9037747.7399999984},9037747.7399999984]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",0,{"$f":"E23","v":0},{"$f":"F23","v":-170040.85},-332691.76,-443699.62,-556890.05000000005,-757495.97000000009,-1082340.5,{"$f":"L23","v":-1434739.51},{"$f":"M23","v":-1787692.17},-2140644.83]
[null,null,null,"Amortization expense during year",0,-170040.85,-162650.91,-111007.86,-113190.43,-200605.92,-324844.53000000003,-352399.01,-352952.66,-352952.66,-352952.66]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E20+E21-E22","v":0},{"$f":"F20+F21-F22","v":-170040.85},{"$f":"G20+G21-G22","v":-332691.76},{"$f":"H20+H21-H22","v":-443699.62},{"$f":"I20+I21-I22","v":-556890.05000000005},{"$f":"J20+J21-J22","v":-757495.97000000009},{"$f":"K20+K21-K22","v":-1082340.5},{"$f":"L20+L21-L22","v":-1434739.51},{"$f":"M20+M21-M22","v":-1787692.17},-2140644.83,{"$f":"O20+O21-O22","v":-2493597.4900000002}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",{"$f":"E14+E20","v":0},{"$f":"E27","v":1985917.65},{"$f":"F27","v":1856880.1699999997},3361045.3099999996,3262105.5299999993,5397586.5099999998,7179404.7699999996,7930819.1199999992,7603008.2299999986,7250055.5699999984,6897102.9099999983]
[null,null,null,"Closing Balance",{"$f":"E17+E23","v":1985917.65},{"$f":"F17+F23","v":1856880.1699999997},{"$f":"G17+G23","v":3361045.3099999996},3262105.5299999993,5397586.5099999998,7179404.7699999996,7930819.1199999992,7603008.2299999986,7250055.5699999984,{"$f":"N17+N23","v":6897102.9099999983},6544150.2499999981]
[null,null,null,"Net Fixed Assets (NFA)",{"$f":"SUM(E26:E27)/2","v":992958.82499999995},{"$f":"AVERAGE(F26:F27)","v":1921398.9099999997},{"$f":"AVERAGE(G26:G27)","v":2608962.7399999998},3311575.4199999995,4329846.0199999996,6288495.6399999997,7555111.9449999994,7766913.6749999989,7426531.8999999985,{"$f":"AVERAGE(N26:N27)","v":7073579.2399999984},{"$f":"AVERAGE(O26:O27)","v":6720626.5799999982}]
[]
[null,"Net Fixed Assets - 1845"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,{"$f":"E36","v":0},{"$f":"F36","v":0},0,0,0,0,0,0,0,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},{"$f":"F33+F34-F35","v":0},{"$f":"G33+G34-G35","v":0},0,0,0,0,0,0,{"$f":"N33+N34-N35","v":0},0]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,{"$f":"E42","v":0},{"$f":"F42","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Amortization expense during year",{"$f":"-E34/'1. Cost of Service_parameters'!G41/2","v":0},{"$f":"-F33/'1. Cost of Service_parameters'!G41-'2. MIST Meters Assets_Rate Base'!F34/'1. Cost of Service_parameters'!G41/2","v":0},{"$f":"-G33/'1. Cost of Service_parameters'!H41-'2. MIST Meters Assets_Rate Base'!G34/'1. Cost of Service_parameters'!H41/2","v":0},{"$f":"-H33/'1. Cost of Service_parameters'!I41-'2. MIST Meters Assets_Rate Base'!H34/'1. Cost of Service_parameters'!I41/2","v":0},{"$f":"-I33/'1. Cost of Service_parameters'!J41-'2. MIST Meters Assets_Rate Base'!I34/'1. Cost of Service_parameters'!J41/2","v":0},{"$f":"-J33/'1. Cost of Service_parameters'!K41-'2. MIST Meters Assets_Rate Base'!J34/'1. Cost of Service_parameters'!K41/2","v":0},{"$f":"-K33/'1. Cost of Service_parameters'!L41-'2. MIST Meters Assets_Rate Base'!K34/'1. Cost of Service_parameters'!L41/2","v":0},{"$f":"-L33/'1. Cost of Service_parameters'!M41-'2. MIST Meters Assets_Rate Base'!L34/'1. Cost of Service_parameters'!M41/2","v":0},{"$f":"-M33/'1. Cost of Service_parameters'!N41-'2. MIST Meters Assets_Rate Base'!M34/'1. Cost of Service_parameters'!N41/2","v":0},{"$f":"-N33/'1. Cost of Service_parameters'!O41-'2. MIST Meters Assets_Rate Base'!N34/'1. Cost of Service_parameters'!O41/2","v":0},{"$f":"-O33/'1. Cost of Service_parameters'!P41-'2. MIST Meters Assets_Rate Base'!O34/'1. Cost of Service_parameters'!P41/2","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E39+E40-E41","v":0},{"$f":"F39+F40-F41","v":0},{"$f":"G39+G40-G41","v":0},0,0,0,0,0,0,{"$f":"N39+N40-N41","v":0},0]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",{"$f":"E33+E39","v":0},{"$f":"E46","v":0},{"$f":"F46","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Closing Balance",{"$f":"E36+E42","v":0},{"$f":"F36+F42","v":0},{"$f":"G36+G42","v":0},0,0,0,0,0,0,{"$f":"N36+N42","v":0},0]
[null,null,null,"Net Fixed Assets (NFA)",{"$f":"AVERAGE(E45:E46)","v":0},{"$f":"AVERAGE(F45:F46)","v":0},{"$f":"AVERAGE(G45:G46)","v":0},0,0,0,0,0,0,{"$f":"AVERAGE(N45:N46)","v":0},0]
[]
[null,"Net Fixed Assets - 1930"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,{"$f":"E55","v":0},{"$f":"F55","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,0]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E52+E53-E54","v":0},{"$f":"F52+F53-F54","v":0},{"$f":"G52+G53-G54","v":0},0,0,0,0,0,0,{"$f":"N52+N53-N54","v":0},0]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,{"$f":"E61","v":0},{"$f":"F61","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Amortization expense during year",{"$f":"-E53/'1. Cost of Service_parameters'!G44/2","v":0},{"$f":"-F52/'1. Cost of Service_parameters'!G44","v":0},{"$f":"-G52/'1. Cost of Service_parameters'!H44","v":0},{"$f":"-H52/'1. Cost of Service_parameters'!I44","v":0},{"$f":"-I52/'1. Cost of Service_parameters'!J44","v":0},{"$f":"-J52/'1. Cost of Service_parameters'!K44","v":0},{"$f":"-K52/'1. Cost of Service_parameters'!L44","v":0},{"$f":"-L52/'1. Cost of Service_parameters'!M44","v":0},{"$f":"-M52/'1. Cost of Service_parameters'!N44","v":0},{"$f":"-N52/'1. Cost of Service_parameters'!O44","v":0},{"$f":"-O52/'1. Cost of Service_parameters'!P44","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E58+E59-E60","v":0},{"$f":"F58+F59-F60","v":0},{"$f":"G58+G59-G60","v":0},0,0,0,0,0,0,{"$f":"N58+N59-N60","v":0},0]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",{"$f":"E52+E58","v":0},{"$f":"E65","v":0},{"$f":"F65","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Closing Balance",{"$f":"E55+E61","v":0},{"$f":"F55+F61","v":0},{"$f":"G55+G61","v":0},0,0,0,0,0,0,{"$f":"N55+N61","v":0},0]
[null,null,null,"Net Fixed Assets (NFA)",{"$f":"AVERAGE(E64:E65)","v":0},{"$f":"AVERAGE(F64:F65)","v":0},{"$f":"AVERAGE(G64:G65)","v":0},0,0,0,0,0,0,{"$f":"AVERAGE(N64:N65)","v":0},0]
[]
[null,"Net Fixed Assets - 1835"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,{"$f":"E74","v":0},{"$f":"F74","v":0},0,0,0,0,0,0,0,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},{"$f":"F71+F72-F73","v":0},{"$f":"G71+G72-G73","v":0},0,0,0,0,0,0,{"$f":"N71+N72-N73","v":0},0]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,{"$f":"E80","v":0},{"$f":"F80","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Amortization expense during year",{"$f":"-E72/'1. Cost of Service_parameters'!G47/2","v":0},{"$f":"-F71/'1. Cost of Service_parameters'!G47-'2. MIST Meters Assets_Rate Base'!F72/'1. Cost of Service_parameters'!G47/2","v":0},{"$f":"-G71/'1. Cost of Service_parameters'!H47-'2. MIST Meters Assets_Rate Base'!G72/'1. Cost of Service_parameters'!H47/2","v":0},{"$f":"-H71/'1. Cost of Service_parameters'!I47-'2. MIST Meters Assets_Rate Base'!H72/'1. Cost of Service_parameters'!I47/2","v":0},{"$f":"-I71/'1. Cost of Service_parameters'!J47-'2. MIST Meters Assets_Rate Base'!I72/'1. Cost of Service_parameters'!J47/2","v":0},{"$f":"-J71/'1. Cost of Service_parameters'!K47-'2. MIST Meters Assets_Rate Base'!J72/'1. Cost of Service_parameters'!K47/2","v":0},{"$f":"-K71/'1. Cost of Service_parameters'!L47-'2. MIST Meters Assets_Rate Base'!K72/'1. Cost of Service_parameters'!L47/2","v":0},{"$f":"-L71/'1. Cost of Service_parameters'!M47-'2. MIST Meters Assets_Rate Base'!L72/'1. Cost of Service_parameters'!M47/2","v":0},{"$f":"-M71/'1. Cost of Service_parameters'!N47-'2. MIST Meters Assets_Rate Base'!M72/'1. Cost of Service_parameters'!N47/2","v":0},{"$f":"-N71/'1. Cost of Service_parameters'!O47-'2. MIST Meters Assets_Rate Base'!N72/'1. Cost of Service_parameters'!O47/2","v":0},{"$f":"-O71/'1. Cost of Service_parameters'!P47-'2. MIST Meters Assets_Rate Base'!O72/'1. Cost of Service_parameters'!P47/2","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E77+E78-E79","v":0},{"$f":"F77+F78-F79","v":0},{"$f":"G77+G78-G79","v":0},0,0,0,0,0,0,{"$f":"N77+N78-N79","v":0},0]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",{"$f":"E71+E77","v":0},{"$f":"E84","v":0},{"$f":"F84","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Closing Balance",{"$f":"E74+E80","v":0},{"$f":"F74+F80","v":0},{"$f":"G74+G80","v":0},0,0,0,0,0,0,{"$f":"N74+N80","v":0},0]
[null,null,null,"Net Fixed Assets (NFA)",{"$f":"AVERAGE(E83:E84)","v":0},{"$f":"AVERAGE(F83:F84)","v":0},{"$f":"AVERAGE(G83:G84)","v":0},0,0,0,0,0,0,{"$f":"AVERAGE(N83:N84)","v":0},0]
[]
[null,"Net Fixed Assets - 1921"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,{"$f":"E93","v":0},{"$f":"F93","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,0]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E90+E91-E92","v":0},{"$f":"F90+F91-F92","v":0},{"$f":"G90+G91-G92","v":0},0,0,0,0,0,0,{"$f":"N90+N91-N92","v":0},0]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,{"$f":"E99","v":0},{"$f":"F99","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Amortization expense during year",{"$f":"-E91/'1. Cost of Service_parameters'!G50/2","v":0},{"$f":"-F90/'1. Cost of Service_parameters'!G50","v":0},{"$f":"-G90/'1. Cost of Service_parameters'!H50","v":0},{"$f":"-H90/'1. Cost of Service_parameters'!I50","v":0},{"$f":"-I90/'1. Cost of Service_parameters'!J50","v":0},{"$f":"-J90/'1. Cost of Service_parameters'!K50","v":0},{"$f":"-K90/'1. Cost of Service_parameters'!L50","v":0},{"$f":"-L90/'1. Cost of Service_parameters'!M50","v":0},{"$f":"-M90/'1. Cost of Service_parameters'!N50","v":0},{"$f":"-N90/'1. Cost of Service_parameters'!O50","v":0},{"$f":"-O90/'1. Cost of Service_parameters'!P50","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E96+E97-E98","v":0},{"$f":"F96+F97-F98","v":0},{"$f":"G96+G97-G98","v":0},0,0,0,0,0,0,{"$f":"N96+N97-N98","v":0},0]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",{"$f":"E90+E96","v":0},{"$f":"E103","v":0},{"$f":"F103","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Closing Balance",{"$f":"E93+E99","v":0},{"$f":"F93+F99","v":0},{"$f":"G93+G99","v":0},0,0,0,0,0,0,{"$f":"N93+N99","v":0},0]
[null,null,null,"Net Fixed Assets (NFA)",{"$f":"AVERAGE(E102:E103)","v":0},{"$f":"AVERAGE(F102:F103)","v":0},{"$f":"AVERAGE(G102:G103)","v":0},0,0,0,0,0,0,{"$f":"AVERAGE(N102:N103)","v":0},0]
[]
[null,"Net Fixed Assets - 1935"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,{"$f":"E112","v":0},{"$f":"F112","v":0},0,0,0,0,0,0,0,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},{"$f":"F109+F110-F111","v":0},{"$f":"G109+G110-G111","v":0},0,0,0,0,0,0,{"$f":"N109+N110-N111","v":0},0]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,{"$f":"E118","v":0},{"$f":"F118","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Amortization expense during year",{"$f":"-E110/'1. Cost of Service_parameters'!G53/2","v":0},{"$f":"-F109/'1. Cost of Service_parameters'!G53-'2. MIST Meters Assets_Rate Base'!F110/'1. Cost of Service_parameters'!G53/2","v":0},{"$f":"-G109/'1. Cost of Service_parameters'!H53-'2. MIST Meters Assets_Rate Base'!G110/'1. Cost of Service_parameters'!H53/2","v":0},{"$f":"-H109/'1. Cost of Service_parameters'!I53-'2. MIST Meters Assets_Rate Base'!H110/'1. Cost of Service_parameters'!I53/2","v":0},{"$f":"-I109/'1. Cost of Service_parameters'!J53-'2. MIST Meters Assets_Rate Base'!I110/'1. Cost of Service_parameters'!J53/2","v":0},{"$f":"-J109/'1. Cost of Service_parameters'!K53-'2. MIST Meters Assets_Rate Base'!J110/'1. Cost of Service_parameters'!K53/2","v":0},{"$f":"-K109/'1. Cost of Service_parameters'!L53-'2. MIST Meters Assets_Rate Base'!K110/'1. Cost of Service_parameters'!L53/2","v":0},{"$f":"-L109/'1. Cost of Service_parameters'!M53-'2. MIST Meters Assets_Rate Base'!L110/'1. Cost of Service_parameters'!M53/2","v":0},{"$f":"-M109/'1. Cost of Service_parameters'!N53-'2. MIST Meters Assets_Rate Base'!M110/'1. Cost of Service_parameters'!N53/2","v":0},{"$f":"-N109/'1. Cost of Service_parameters'!O53-'2. MIST Meters Assets_Rate Base'!N110/'1. Cost of Service_parameters'!O53/2","v":0},{"$f":"-O109/'1. Cost of Service_parameters'!P53-'2. MIST Meters Assets_Rate Base'!O110/'1. Cost of Service_parameters'!P53/2","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E115+E116-E117","v":0},{"$f":"F115+F116-F117","v":0},{"$f":"G115+G116-G117","v":0},0,0,0,0,0,0,{"$f":"N115+N116-N117","v":0},0]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",{"$f":"E109+E115","v":0},{"$f":"E122","v":0},{"$f":"F122","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Closing Balance",{"$f":"E112+E118","v":0},{"$f":"F112+F118","v":0},{"$f":"G112+G118","v":0},0,0,0,0,0,0,{"$f":"N112+N118","v":0},0]
[null,null,null,"Net Fixed Assets (NFA)",{"$f":"AVERAGE(E121:E122)","v":0},{"$f":"AVERAGE(F121:F122)","v":0},{"$f":"AVERAGE(G121:G122)","v":0},0,0,0,0,0,0,{"$f":"AVERAGE(N121:N122)","v":0},0]
[]
[null,"Net Fixed Assets - 1926"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,{"$f":"E131","v":0},{"$f":"F131","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,0]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E128+E129-E130","v":0},{"$f":"F128+F129-F130","v":0},{"$f":"G128+G129-G130","v":0},0,0,0,0,0,0,{"$f":"N128+N129-N130","v":0},0]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,{"$f":"E137","v":0},{"$f":"F137","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Amortization expense during year",{"$f":"-E129/'1. Cost of Service_parameters'!G56/2","v":0},{"$f":"-F128/'1. Cost of Service_parameters'!G56","v":0},{"$f":"-G128/'1. Cost of Service_parameters'!H56","v":0},{"$f":"-H128/'1. Cost of Service_parameters'!I56","v":0},{"$f":"-I128/'1. Cost of Service_parameters'!J56","v":0},{"$f":"-J128/'1. Cost of Service_parameters'!K56","v":0},{"$f":"-K128/'1. Cost of Service_parameters'!L56","v":0},{"$f":"-L128/'1. Cost of Service_parameters'!M56","v":0},{"$f":"-M128/'1. Cost of Service_parameters'!N56","v":0},{"$f":"-N128/'1. Cost of Service_parameters'!O56","v":0},{"$f":"-O128/'1. Cost of Service_parameters'!P56","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E134+E135-E136","v":0},{"$f":"F134+F135-F136","v":0},{"$f":"G134+G135-G136","v":0},0,0,0,0,0,0,{"$f":"N134+N135-N136","v":0},0]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",{"$f":"E128+E134","v":0},{"$f":"E141","v":0},{"$f":"F141","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Closing Balance",{"$f":"E131+E137","v":0},{"$f":"F131+F137","v":0},{"$f":"G131+G137","v":0},0,0,0,0,0,0,{"$f":"N131+N137","v":0},0]
[null,null,null,"Net Fixed Assets (NFA)",{"$f":"AVERAGE(E140:E141)","v":0},{"$f":"AVERAGE(F140:F141)","v":0},{"$f":"AVERAGE(G140:G141)","v":0},0,0,0,0,0,0,{"$f":"AVERAGE(N140:N141)","v":0},0]
[]
[null,"Net Fixed Assets - 1862"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,{"$f":"E150","v":0},{"$f":"F150","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,0]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E147+E148-E149","v":0},{"$f":"F147+F148-F149","v":0},{"$f":"G147+G148-G149","v":0},0,0,0,0,0,0,{"$f":"N147+N148-N149","v":0},0]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,{"$f":"E156","v":0},{"$f":"F156","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Amortization expense during year",{"$f":"-E148/'1. Cost of Service_parameters'!G59/2","v":0},{"$f":"-F147/'1. Cost of Service_parameters'!G59","v":0},{"$f":"-G147/'1. Cost of Service_parameters'!H59","v":0},{"$f":"-H147/'1. Cost of Service_parameters'!I59","v":0},{"$f":"-I147/'1. Cost of Service_parameters'!J59","v":0},{"$f":"-J147/'1. Cost of Service_parameters'!K59","v":0},{"$f":"-K147/'1. Cost of Service_parameters'!L59","v":0},{"$f":"-L147/'1. Cost of Service_parameters'!M59","v":0},{"$f":"-M147/'1. Cost of Service_parameters'!N59","v":0},{"$f":"-N147/'1. Cost of Service_parameters'!O59","v":0},{"$f":"-O147/'1. Cost of Service_parameters'!P59","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E153+E154-E155","v":0},{"$f":"F153+F154-F155","v":0},{"$f":"G153+G154-G155","v":0},0,0,0,0,0,0,{"$f":"N153+N154-N155","v":0},0]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",{"$f":"E147+E153","v":0},{"$f":"E160","v":0},{"$f":"F160","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Closing Balance",{"$f":"E150+E156","v":0},{"$f":"F150+F156","v":0},{"$f":"G150+G156","v":0},0,0,0,0,0,0,{"$f":"N150+N156","v":0},0]
[null,null,null,"Net Fixed Assets (NFA)",{"$f":"AVERAGE(E159:E160)","v":0},{"$f":"AVERAGE(F159:F160)","v":0},{"$f":"AVERAGE(G159:G160)","v":0},0,0,0,0,0,0,{"$f":"AVERAGE(N159:N160)","v":0},0]
[]
[null,"Net Fixed Assets - 1924"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,{"$f":"E169","v":0},{"$f":"F169","v":0},0,0,0,0,0,0,0,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},{"$f":"F166+F167-F168","v":0},{"$f":"G166+G167-G168","v":0},0,0,0,0,0,0,{"$f":"N166+N167-N168","v":0},0]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,{"$f":"E175","v":0},{"$f":"F175","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Amortization expense during year",{"$f":"-E167/'1. Cost of Service_parameters'!G62/2","v":0},{"$f":"-F166/'1. Cost of Service_parameters'!G62-'2. MIST Meters Assets_Rate Base'!F167/'1. Cost of Service_parameters'!G62/2","v":0},{"$f":"-G166/'1. Cost of Service_parameters'!H62-'2. MIST Meters Assets_Rate Base'!G167/'1. Cost of Service_parameters'!H62/2","v":0},{"$f":"-H166/'1. Cost of Service_parameters'!I62-'2. MIST Meters Assets_Rate Base'!H167/'1. Cost of Service_parameters'!I62/2","v":0},{"$f":"-I166/'1. Cost of Service_parameters'!J62-'2. MIST Meters Assets_Rate Base'!I167/'1. Cost of Service_parameters'!J62/2","v":0},{"$f":"-J166/'1. Cost of Service_parameters'!K62-'2. MIST Meters Assets_Rate Base'!J167/'1. Cost of Service_parameters'!K62/2","v":0},{"$f":"-K166/'1. Cost of Service_parameters'!L62-'2. MIST Meters Assets_Rate Base'!K167/'1. Cost of Service_parameters'!L62/2","v":0},{"$f":"-L166/'1. Cost of Service_parameters'!M62-'2. MIST Meters Assets_Rate Base'!L167/'1. Cost of Service_parameters'!M62/2","v":0},{"$f":"-M166/'1. Cost of Service_parameters'!N62-'2. MIST Meters Assets_Rate Base'!M167/'1. Cost of Service_parameters'!N62/2","v":0},{"$f":"-N166/'1. Cost of Service_parameters'!O62-'2. MIST Meters Assets_Rate Base'!N167/'1. Cost of Service_parameters'!O62/2","v":0},{"$f":"-O166/'1. Cost of Service_parameters'!P62-'2. MIST Meters Assets_Rate Base'!O167/'1. Cost of Service_parameters'!P62/2","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E172+E173-E174","v":0},{"$f":"F172+F173-F174","v":0},{"$f":"G172+G173-G174","v":0},0,0,0,0,0,0,{"$f":"N172+N173-N174","v":0},0]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",{"$f":"E166+E172","v":0},{"$f":"E179","v":0},{"$f":"F179","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Closing Balance",{"$f":"E169+E175","v":0},{"$f":"F169+F175","v":0},{"$f":"G169+G175","v":0},0,0,0,0,0,0,{"$f":"N169+N175","v":0},0]
[null,null,null,"Net Fixed Assets (NFA)",{"$f":"AVERAGE(E178:E179)","v":0},{"$f":"AVERAGE(F178:F179)","v":0},{"$f":"AVERAGE(G178:G179)","v":0},0,0,0,0,0,0,{"$f":"AVERAGE(N178:N179)","v":0},0]
[]
[]
[null,"Net Fixed Assets - 1850"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,{"$f":"E189","v":0},{"$f":"F189","v":0},0,0,0,0,0,0,0,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},{"$f":"F186+F187-F188","v":0},{"$f":"G186+G187-G188","v":0},0,0,0,0,0,0,{"$f":"N186+N187-N188","v":0},0]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,{"$f":"E195","v":0},{"$f":"F195","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Amortization expense during year",{"$f":"-E187/'1. Cost of Service_parameters'!G65/2","v":0},{"$f":"-F186/'1. Cost of Service_parameters'!G65-'2. MIST Meters Assets_Rate Base'!F187/'1. Cost of Service_parameters'!G65/2","v":0},{"$f":"-G186/'1. Cost of Service_parameters'!H65-'2. MIST Meters Assets_Rate Base'!G187/'1. Cost of Service_parameters'!H65/2","v":0},{"$f":"-H186/'1. Cost of Service_parameters'!I65-'2. MIST Meters Assets_Rate Base'!H187/'1. Cost of Service_parameters'!I65/2","v":0},{"$f":"-I186/'1. Cost of Service_parameters'!J65-'2. MIST Meters Assets_Rate Base'!I187/'1. Cost of Service_parameters'!J65/2","v":0},{"$f":"-J186/'1. Cost of Service_parameters'!K65-'2. MIST Meters Assets_Rate Base'!J187/'1. Cost of Service_parameters'!K65/2","v":0},{"$f":"-K186/'1. Cost of Service_parameters'!L65-'2. MIST Meters Assets_Rate Base'!K187/'1. Cost of Service_parameters'!L65/2","v":0},{"$f":"-L186/'1. Cost of Service_parameters'!M65-'2. MIST Meters Assets_Rate Base'!L187/'1. Cost of Service_parameters'!M65/2","v":0},{"$f":"-M186/'1. Cost of Service_parameters'!N65-'2. MIST Meters Assets_Rate Base'!M187/'1. Cost of Service_parameters'!N65/2","v":0},{"$f":"-N186/'1. Cost of Service_parameters'!O65-'2. MIST Meters Assets_Rate Base'!N187/'1. Cost of Service_parameters'!O65/2","v":0},{"$f":"-O186/'1. Cost of Service_parameters'!P65-'2. MIST Meters Assets_Rate Base'!O187/'1. Cost of Service_parameters'!P65/2","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E192+E193-E194","v":0},{"$f":"F192+F193-F194","v":0},{"$f":"G192+G193-G194","v":0},0,0,0,0,0,0,{"$f":"N192+N193-N194","v":0},0]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",{"$f":"E186+E192","v":0},{"$f":"E199","v":0},{"$f":"F199","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Closing Balance",{"$f":"E189+E195","v":0},{"$f":"F189+F195","v":0},{"$f":"G189+G195","v":0},0,0,0,0,0,0,{"$f":"N189+N195","v":0},0]
[null,null,null,"Net Fixed Assets (NFA)",{"$f":"AVERAGE(E198:E199)","v":0},{"$f":"AVERAGE(F198:F199)","v":0},{"$f":"AVERAGE(G198:G199)","v":0},0,0,0,0,0,0,{"$f":"AVERAGE(N198:N199)","v":0},0]
[]
[]
[null,"Net Fixed Assets - 1982"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,{"$f":"E209","v":0},{"$f":"F209","v":0},0,0,0,0,0,0,0,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},{"$f":"F206+F207-F208","v":0},{"$f":"G206+G207-G208","v":0},0,0,0,0,0,0,{"$f":"N206+N207-N208","v":0},0]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,{"$f":"E215","v":0},{"$f":"F215","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Amortization expense during year",{"$f":"-E207/'1. Cost of Service_parameters'!G68/2","v":0},{"$f":"-F206/'1. Cost of Service_parameters'!G68-'2. MIST Meters Assets_Rate Base'!F207/'1. Cost of Service_parameters'!G68/2","v":0},{"$f":"-G206/'1. Cost of Service_parameters'!H68-'2. MIST Meters Assets_Rate Base'!G207/'1. Cost of Service_parameters'!H68/2","v":0},{"$f":"-H206/'1. Cost of Service_parameters'!I68-'2. MIST Meters Assets_Rate Base'!H207/'1. Cost of Service_parameters'!I68/2","v":0},{"$f":"-I206/'1. Cost of Service_parameters'!J68-'2. MIST Meters Assets_Rate Base'!I207/'1. Cost of Service_parameters'!J68/2","v":0},{"$f":"-J206/'1. Cost of Service_parameters'!K68-'2. MIST Meters Assets_Rate Base'!J207/'1. Cost of Service_parameters'!K68/2","v":0},{"$f":"-K206/'1. Cost of Service_parameters'!L68-'2. MIST Meters Assets_Rate Base'!K207/'1. Cost of Service_parameters'!L68/2","v":0},{"$f":"-L206/'1. Cost of Service_parameters'!M68-'2. MIST Meters Assets_Rate Base'!L207/'1. Cost of Service_parameters'!M68/2","v":0},{"$f":"-M206/'1. Cost of Service_parameters'!N68-'2. MIST Meters Assets_Rate Base'!M207/'1. Cost of Service_parameters'!N68/2","v":0},{"$f":"-N206/'1. Cost of Service_parameters'!O68-'2. MIST Meters Assets_Rate Base'!N207/'1. Cost of Service_parameters'!O68/2","v":0},{"$f":"-O206/'1. Cost of Service_parameters'!P68-'2. MIST Meters Assets_Rate Base'!O207/'1. Cost of Service_parameters'!P68/2","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E212+E213-E214","v":0},{"$f":"F212+F213-F214","v":0},{"$f":"G212+G213-G214","v":0},0,0,0,0,0,0,{"$f":"N212+N213-N214","v":0},0]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",{"$f":"E206+E212","v":0},{"$f":"E219","v":0},{"$f":"F219","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Closing Balance",{"$f":"E209+E215","v":0},{"$f":"F209+F215","v":0},{"$f":"G209+G215","v":0},0,0,0,0,0,0,{"$f":"N209+N215","v":0},0]
[null,null,null,"Net Fixed Assets (NFA)",{"$f":"AVERAGE(E218:E219)","v":0},{"$f":"AVERAGE(F218:F219)","v":0},{"$f":"AVERAGE(G218:G219)","v":0},0,0,0,0,0,0,{"$f":"AVERAGE(N218:N219)","v":0},0]
[]
[]
[null,"Net Fixed Assets - 1955"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,{"$f":"E229","v":0},{"$f":"F229","v":0},0,0,0,0,0,0,0,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},{"$f":"F226+F227-F228","v":0},{"$f":"G226+G227-G228","v":0},0,0,0,0,0,0,{"$f":"N226+N227-N228","v":0},0]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,{"$f":"E235","v":0},{"$f":"F235","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Amortization expense during year",{"$f":"-E227/'1. Cost of Service_parameters'!G71/2","v":0},{"$f":"-F226/'1. Cost of Service_parameters'!G71-'2. MIST Meters Assets_Rate Base'!F227/'1. Cost of Service_parameters'!G71/2","v":0},{"$f":"-G226/'1. Cost of Service_parameters'!H71-'2. MIST Meters Assets_Rate Base'!G227/'1. Cost of Service_parameters'!H71/2","v":0},{"$f":"-H226/'1. Cost of Service_parameters'!I71-'2. MIST Meters Assets_Rate Base'!H227/'1. Cost of Service_parameters'!I71/2","v":0},{"$f":"-I226/'1. Cost of Service_parameters'!J71-'2. MIST Meters Assets_Rate Base'!I227/'1. Cost of Service_parameters'!J71/2","v":0},{"$f":"-J226/'1. Cost of Service_parameters'!K71-'2. MIST Meters Assets_Rate Base'!J227/'1. Cost of Service_parameters'!K71/2","v":0},{"$f":"-K226/'1. Cost of Service_parameters'!L71-'2. MIST Meters Assets_Rate Base'!K227/'1. Cost of Service_parameters'!L71/2","v":0},{"$f":"-L226/'1. Cost of Service_parameters'!M71-'2. MIST Meters Assets_Rate Base'!L227/'1. Cost of Service_parameters'!M71/2","v":0},{"$f":"-M226/'1. Cost of Service_parameters'!N71-'2. MIST Meters Assets_Rate Base'!M227/'1. Cost of Service_parameters'!N71/2","v":0},{"$f":"-N226/'1. Cost of Service_parameters'!O71-'2. MIST Meters Assets_Rate Base'!N227/'1. Cost of Service_parameters'!O71/2","v":0},{"$f":"-O226/'1. Cost of Service_parameters'!P71-'2. MIST Meters Assets_Rate Base'!O227/'1. Cost of Service_parameters'!P71/2","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E232+E233-E234","v":0},{"$f":"F232+F233-F234","v":0},{"$f":"G232+G233-G234","v":0},0,0,0,0,0,0,{"$f":"N232+N233-N234","v":0},0]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",{"$f":"E226+E232","v":0},{"$f":"E239","v":0},{"$f":"F239","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Closing Balance",{"$f":"E229+E235","v":0},{"$f":"F229+F235","v":0},{"$f":"G229+G235","v":0},0,0,0,0,0,0,{"$f":"N229+N235","v":0},0]
[null,null,null,"Net Fixed Assets (NFA)",{"$f":"AVERAGE(E238:E239)","v":0},{"$f":"AVERAGE(F238:F239)","v":0},{"$f":"AVERAGE(G238:G239)","v":0},0,0,0,0,0,0,{"$f":"AVERAGE(N238:N239)","v":0},0]
[]
[]
[null,"Net Fixed Assets - "]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,{"$f":"E249","v":0},{"$f":"F249","v":0},0,0,0,0,0,0,0,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},{"$f":"F246+F247-F248","v":0},{"$f":"G246+G247-G248","v":0},0,0,0,0,0,0,{"$f":"N246+N247-N248","v":0},0]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,{"$f":"E255","v":0},{"$f":"F255","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Amortization expense during year",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E252+E253-E254","v":0},{"$f":"F252+F253-F254","v":0},{"$f":"G252+G253-G254","v":0},0,0,0,0,0,0,{"$f":"N252+N253-N254","v":0},0]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",{"$f":"E246+E252","v":0},{"$f":"E259","v":0},{"$f":"F259","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Closing Balance",{"$f":"E249+E255","v":0},{"$f":"F249+F255","v":0},{"$f":"G249+G255","v":0},0,0,0,0,0,0,{"$f":"N249+N255","v":0},0]
[null,null,null,"Incremental CAPEX",{"$f":"E259","v":0},{"$f":"AVERAGE(F258:F259)","v":0},{"$f":"AVERAGE(G258:G259)","v":0},0,0,0,0,0,0,{"$f":"AVERAGE(N258:N259)","v":0},0]
[]
[]
[]
[]
[]
[]
[null,null,null,"Additions",{"$f":"E15+E34+E53+E72+E91+E110+E129+E148+E167+E187+E207+E227+E247","v":1985917.65},{"$f":"F15+F34+F53+F72+F91+F110+F129+F148+F167+F187+F207+F227+F247","v":41003.369999999937},1666816.0499999998,12068.08,2248671.41,1982424.18,1076258.8799999999,24588.12,0,{"$f":"N15+N34+N53+N72+N91+N110+N129+N148+N167+N187+N207+N227+N247","v":0},0]
[null,null,null,"Net Fixed Assets (NFA)",{"$f":"E28+E47+E66+E85+E104+E123+E142+E161+E180+E200+E220+E240+E260","v":992958.82499999995},{"$f":"F28+F47+F66+F85+F104+F123+F142+F161+F180+F200+F220+F240+F260","v":1921398.9099999997},{"$f":"G28+G47+G66+G85+G104+G123+G142+G161+G180+G200+G220+G240+G260","v":2608962.7399999998},3311575.4199999995,4329846.0199999996,6288495.6399999997,7555111.9449999994,7766913.6749999989,7426531.8999999985,{"$f":"N28+N47+N66+N85+N104+N123+N142+N161+N180+N200+N220+N240+N260","v":7073579.2399999984},6720626.5799999982]
[null,null,null,"Total Amortization",{"$f":"E21+E40+E59+E78+E97+E116+E135+E154+E173+E193+E213+E233+E253","v":0},{"$f":"F21+F40+F59+F78+F97+F116+F135+F154+F173+F193+F213+F233+F253","v":-170040.85},{"$f":"G21+G40+G59+G78+G97+G116+G135+G154+G173+G193+G213+G233+G253","v":-162650.91},-111007.86,-113190.43,-200605.92,-324844.53000000003,-352399.01,-352952.66,{"$f":"N21+N40+N59+N78+N97+N116+N135+N154+N173+N193+N213+N233+N253","v":-352952.66},-352952.66]

{"sheet":"3. UCC_Calculations","index":2,"n_rows":88,"n_cols":14,"rows_kept":88,"cut":false,"hidden":false,"merged":[[2,2,2,3]]}
[]
[]
[null,null,"MIST Meters True-up Model"]
[]
[]
[]
[]
[]
["Sheet 3: CCA For PILs Calculation"]
[]
["UCC/Class 47",null,null,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026]
[null,null,null,"Actual","Actual","Actual","Actual","Actual","Actual","Actual","Actual","Actual","Actual","Actual"]
[]
["Opening UCC",null,null,0,{"$f":"D17-D22","v":1906480.9439999999},{"$f":"E17-E22","v":1793325.7036799998},{"$f":"F17-F22","v":3250003.0553855998},3001588.1677547521,4920185.667934373,6429698.027299623,6948530.7099156529,6416252.8483224008,{"$f":"L17-L22","v":5902952.6204566089},{"$f":"M17-M22","v":5430716.41082008}]
["Capital Additions",null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!E267-D29-D44-D59-D74","v":1985917.65},{"$f":"'2. MIST Meters Assets_Rate Base'!F267-E29-E44-E59-E74","v":41003.369999999937},{"$f":"'2. MIST Meters Assets_Rate Base'!G267-F29-F44-F59-F74","v":1666816.0499999998},{"$f":"'2. MIST Meters Assets_Rate Base'!H267-G29-G44-G59-G74","v":12068.08},{"$f":"'2. MIST Meters Assets_Rate Base'!I267-H29-H44-H59-H74","v":2248671.41},{"$f":"'2. MIST Meters Assets_Rate Base'!J267-I29-I44-I59-I74","v":1982424.18},{"$f":"'2. MIST Meters Assets_Rate Base'!K267-J29-J44-J59-J74","v":1076258.8799999999},{"$f":"'2. MIST Meters Assets_Rate Base'!L267-K29-K44-K59-K74","v":24588.12},{"$f":"'2. MIST Meters Assets_Rate Base'!M267-L29-L44-L59-L74","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!N267-M29-M44-M59-M74","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!O267-N29-N44-N59-N74","v":0}]
["Retirements/Removals (if applicable)",null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!E16","v":0}]
["UCC Before Half Year Rule",null,null,{"$f":"SUM(D14:D15)-D16","v":1985917.65},{"$f":"SUM(E14:E15)-E16","v":1947484.3139999998},{"$f":"SUM(F14:F15)-F16","v":3460141.7536799996},3262071.1353855999,5250259.5777547527,6902609.8479343727,7505956.9072996229,6973118.829915653,6416252.8483224008,{"$f":"SUM(M14:M15)-M16","v":5902952.6204566089},5430716.41082008]
["Half Year Rule (1/2 Additions - Disposals)",null,null,{"$f":"IF(((D15-D16)/2)<0, 0, (D15-D16)/2)","v":992958.82499999995},{"$f":"IF(((E15-E16)/2)<0, 0, (E15-E16)/2)","v":20501.684999999969},{"$f":"IF(((F15-F16)/2)<0, 0, (F15-F16)/2)","v":833408.02499999991},{"$f":"IF(((G15-G16)/2)<0, 0, (G15-G16)/2)","v":6034.04},1124335.7050000001,991212.09,538129.43999999994,12294.06,0,{"$f":"IF(((M15-M16)/2)<0, 0, (M15-M16)/2)","v":0},0]
["Reduced UCC",null,null,{"$f":"D18+D14","v":992958.82499999995},{"$f":"E18+E14","v":1926982.629},{"$f":"F18+F14","v":2626733.7286799997},{"$f":"G18+G14","v":3256037.0953855999},4125923.8727547522,5911397.7579343729,6967827.4672996234,6960824.7699156525,6416252.8483224008,{"$f":"M18+M14","v":5902952.6204566089},5430716.41082008]
["CCA Rate Class",null,null,47,47,47,47,47,47,47,47,47,47,47]
["CCA Rate ",null,null,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
["CCA",null,null,{"$f":"D19*D21","v":79436.705999999991},154158.61032000001,210138.69829439998,260482.967630848,330073.90982038015,472911.82063474983,557426.19738396991,556865.98159325216,513300.22786579205,472236.20963652874,434457.31286560639]
["Closing UCC",null,null,{"$f":"IF((D17-D22)<0, 0, D17-D22)","v":1906480.9439999999},{"$f":"IF((E17-E22)<0, 0, E17-E22)","v":1793325.7036799998},{"$f":"IF((F17-F22)<0, 0, F17-F22)","v":3250003.0553855998},3001588.1677547521,4920185.667934373,6429698.027299623,6948530.7099156529,6416252.8483224008,5902952.6204566089,{"$f":"IF((M17-M22)<0, 0, M17-M22)","v":5430716.41082008},4996259.0979544735]
[]
["UCC/Class 8",null,null,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026]
[null,null,null,{"$f":"D12","v":"Actual"},"Actual",{"$f":"F12","v":"Actual"},"Actual","Actual","Actual","Actual","Actual","Actual",{"$f":"M12","v":"Actual"},"Actual"]
[]
["Opening UCC",null,null,0,{"$f":"D31-D36","v":0},{"$f":"E31-E36","v":0},0,0,0,0,0,0,{"$f":"L31-L36","v":0},{"$f":"M31-M36","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},{"$f":"'2. MIST Meters Assets_Rate Base'!F227+'2. MIST Meters Assets_Rate Base'!F207+'2. MIST Meters Assets_Rate Base'!F148+'2. MIST Meters Assets_Rate Base'!F110","v":0},{"$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},{"$f":"'2. MIST Meters Assets_Rate Base'!H227+'2. MIST Meters Assets_Rate Base'!H207+'2. MIST Meters Assets_Rate Base'!H148+'2. MIST Meters Assets_Rate Base'!H110","v":0},{"$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},{"$f":"'2. MIST Meters Assets_Rate Base'!J227+'2. MIST Meters Assets_Rate Base'!J207+'2. MIST Meters Assets_Rate Base'!J148+'2. MIST Meters Assets_Rate Base'!J110","v":0},{"$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},{"$f":"'2. MIST Meters Assets_Rate Base'!L227+'2. MIST Meters Assets_Rate Base'!L207+'2. MIST Meters Assets_Rate Base'!L148+'2. MIST Meters Assets_Rate Base'!L110","v":0},{"$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},{"$f":"'2. MIST Meters Assets_Rate Base'!N227+'2. MIST Meters Assets_Rate Base'!N207+'2. MIST Meters Assets_Rate Base'!N148+'2. MIST Meters Assets_Rate Base'!N110","v":0},{"$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}]
["Retirements/Removals (if applicable)"]
["UCC Before Half Year Rule",null,null,{"$f":"SUM(D28:D29)-D30","v":0},{"$f":"SUM(E28:E29)-E30","v":0},{"$f":"SUM(F28:F29)-F30","v":0},0,0,0,0,0,0,{"$f":"SUM(M28:M29)-M30","v":0},0]
["Half Year Rule (1/2 Additions - Disposals)",null,null,{"$f":"IF((SUM(D29:D29)/2)<0, 0, SUM(D29:D29)/2)","v":0},{"$f":"IF((SUM(E29:E29)/2)<0, 0, SUM(E29:E29)/2)","v":0},{"$f":"IF((SUM(F29:F29)/2)<0, 0, SUM(F29:F29)/2)","v":0},0,0,0,0,0,0,{"$f":"IF((SUM(M29:M29)/2)<0, 0, SUM(M29:M29)/2)","v":0},0]
["Reduced UCC",null,null,{"$f":"D32+D28","v":0},{"$f":"E32+E28","v":0},{"$f":"F32+F28","v":0},0,0,0,0,0,0,{"$f":"M32+M28","v":0},0]
["CCA Rate Class",null,null,8,8,8,8,8,8,8,8,8,8,8]
["CCA Rate ",null,null,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2]
["CCA",null,null,{"$f":"D35*D33","v":0},{"$f":"E35*E33","v":0},{"$f":"F35*F33","v":0},0,0,0,0,0,0,{"$f":"M35*M33","v":0},0]
["Closing UCC",null,null,{"$f":"IF((D31-D36)<0, 0, D31-D36)","v":0},{"$f":"IF((E31-E36)<0, 0, E31-E36)","v":0},{"$f":"IF((F31-F36)<0, 0, F31-F36)","v":0},0,0,0,0,0,0,{"$f":"IF((M31-M36)<0, 0, M31-M36)","v":0},0]
[]
[]
["UCC/Class 10",null,null,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026]
[null,null,null,"Audited Actual","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast"]
[]
["Opening UCC",null,null,0,{"$f":"D46-D51","v":0},{"$f":"E46-E51","v":0},0,0,0,0,0,0,{"$f":"L46-L51","v":0},{"$f":"M46-M51","v":0}]
["Capital Additions ",null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!E53","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!F53","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!G53","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!H53","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!I53","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!J53","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!K53","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!L53","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!M53","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!N53","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!O53","v":0}]
["Retirements/Removals (if applicable)"]
["UCC Before Half Year Rule",null,null,{"$f":"SUM(D43:D44)-D45","v":0},{"$f":"SUM(E43:E44)-E45","v":0},{"$f":"SUM(F43:F44)-F45","v":0},0,0,0,0,0,0,{"$f":"SUM(M43:M44)-M45","v":0},0]
["Half Year Rule (1/2 Additions - Disposals)",null,null,{"$f":"IF((SUM(D44:D44)/2)<0, 0, SUM(D44:D44)/2)","v":0},{"$f":"IF((SUM(E44:E44)/2)<0, 0, SUM(E44:E44)/2)","v":0},{"$f":"IF((SUM(F44:F44)/2)<0, 0, SUM(F44:F44)/2)","v":0},0,0,0,0,0,0,{"$f":"IF((SUM(M44:M44)/2)<0, 0, SUM(M44:M44)/2)","v":0},0]
["Reduced UCC",null,null,{"$f":"D47+D43","v":0},{"$f":"E47+E43","v":0},{"$f":"F47+F43","v":0},0,0,0,0,0,0,{"$f":"M47+M43","v":0},0]
["CCA Rate Class",null,null,10,10,10,10,10,10,10,10,10,10,10]
["CCA Rate ",null,null,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3]
["CCA",null,null,{"$f":"D50*D48","v":0},{"$f":"E50*E48","v":0},{"$f":"F50*F48","v":0},0,0,0,0,0,0,{"$f":"M50*M48","v":0},0]
["Closing UCC",null,null,{"$f":"IF((D46-D51)<0, 0, D46-D51)","v":0},{"$f":"IF((E46-E51)<0, 0, E46-E51)","v":0},{"$f":"IF((F46-F51)<0, 0, F46-F51)","v":0},0,0,0,0,0,0,{"$f":"IF((M46-M51)<0, 0, M46-M51)","v":0},0]
[]
[]
["UCC/Class 50",null,null,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026]
[null,null,null,"Audited Actual","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast"]
[]
["Opening UCC",null,null,0,{"$f":"D61-D66","v":0},{"$f":"E61-E66","v":0},0,0,0,0,0,0,{"$f":"L61-L66","v":0},{"$f":"M61-M66","v":0}]
["Capital Additions ",null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!E91+'2. MIST Meters Assets_Rate Base'!E167","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!F91+'2. MIST Meters Assets_Rate Base'!F167","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!G91+'2. MIST Meters Assets_Rate Base'!G167","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!H91+'2. MIST Meters Assets_Rate Base'!H167","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!I91+'2. MIST Meters Assets_Rate Base'!I167","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!J91+'2. MIST Meters Assets_Rate Base'!J167","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!K91+'2. MIST Meters Assets_Rate Base'!K167","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!L91+'2. MIST Meters Assets_Rate Base'!L167","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!M91+'2. MIST Meters Assets_Rate Base'!M167","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!N91+'2. MIST Meters Assets_Rate Base'!N167","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!O91+'2. MIST Meters Assets_Rate Base'!O167","v":0}]
["Retirements/Removals (if applicable)"]
["UCC Before Half Year Rule",null,null,{"$f":"SUM(D58:D59)-D60","v":0},{"$f":"SUM(E58:E59)-E60","v":0},{"$f":"SUM(F58:F59)-F60","v":0},0,0,0,0,0,0,{"$f":"SUM(M58:M59)-M60","v":0},0]
["Half Year Rule (1/2 Additions - Disposals)",null,null,{"$f":"IF((SUM(D59:D59)/2)<0, 0, SUM(D59:D59)/2)","v":0},{"$f":"IF((SUM(E59:E59)/2)<0, 0, SUM(E59:E59)/2)","v":0},{"$f":"IF((SUM(F59:F59)/2)<0, 0, SUM(F59:F59)/2)","v":0},0,0,0,0,0,0,{"$f":"IF((SUM(M59:M59)/2)<0, 0, SUM(M59:M59)/2)","v":0},0]
["Reduced UCC",null,null,{"$f":"D62+D58","v":0},{"$f":"E62+E58","v":0},{"$f":"F62+F58","v":0},0,0,0,0,0,0,{"$f":"M62+M58","v":0},0]
["CCA Rate Class",null,null,50,50,50,50,50,50,50,50,50,50,50]
["CCA Rate ",null,null,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004]
["CCA",null,null,{"$f":"D65*D63","v":0},{"$f":"E65*E63","v":0},{"$f":"F65*F63","v":0},0,0,0,0,0,0,{"$f":"M65*M63","v":0},0]
["Closing UCC",null,null,{"$f":"IF((D61-D66)<0, 0, D61-D66)","v":0},{"$f":"IF((E61-E66)<0, 0, E61-E66)","v":0},{"$f":"IF((F61-F66)<0, 0, F61-F66)","v":0},0,0,0,0,0,0,{"$f":"IF((M61-M66)<0, 0, M61-M66)","v":0},0]
[]
[]
["UCC/Class 12",null,null,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026]
[null,null,null,"Audited Actual","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast","Forecast"]
[]
["Opening UCC",null,null,0,{"$f":"D76-D81","v":0},{"$f":"E76-E81","v":0},0,0,0,0,0,0,{"$f":"L76-L81","v":0},{"$f":"M76-M81","v":0}]
["Capital Additions ",null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!E129","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!F129","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!G129","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!H129","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!I129","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!J129","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!K129","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!L129","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!M129","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!N129","v":0},{"$f":"'2. MIST Meters Assets_Rate Base'!O129","v":0}]
["Retirements/Removals (if applicable)"]
["UCC Before Half Year Rule",null,null,{"$f":"SUM(D73:D74)-D75","v":0},{"$f":"SUM(E73:E74)-E75","v":0},{"$f":"SUM(F73:F74)-F75","v":0},0,0,0,0,0,0,{"$f":"SUM(M73:M74)-M75","v":0},0]
["Half Year Rule (1/2 Additions - Disposals)",null,null,{"$f":"IF((SUM(D74:D74)/2)<0, 0, SUM(D74:D74)/2)","v":0},{"$f":"IF((SUM(E74:E74)/2)<0, 0, SUM(E74:E74)/2)","v":0},{"$f":"IF((SUM(F74:F74)/2)<0, 0, SUM(F74:F74)/2)","v":0},0,0,0,0,0,0,{"$f":"IF((SUM(M74:M74)/2)<0, 0, SUM(M74:M74)/2)","v":0},0]
["Reduced UCC",null,null,{"$f":"D77+D73","v":0},{"$f":"E77+E73","v":0},{"$f":"F77+F73","v":0},0,0,0,0,0,0,{"$f":"M77+M73","v":0},0]
["CCA Rate Class",null,null,12,12,12,12,12,12,12,12,12,12,12]
["CCA Rate ",null,null,1,1,1,1,1,1,1,1,1,1,1]
["CCA",null,null,{"$f":"D80*D78","v":0},{"$f":"E80*E78","v":0},{"$f":"F80*F78","v":0},0,0,0,0,0,0,{"$f":"M80*M78","v":0},0]
["Closing UCC",null,null,{"$f":"IF((D76-D81)<0, 0, D76-D81)","v":0},{"$f":"IF((E76-E81)<0, 0, E76-E81)","v":0},{"$f":"IF((F76-F81)<0, 0, F76-F81)","v":0},0,0,0,0,0,0,{"$f":"IF((M76-M81)<0, 0, M76-M81)","v":0},0]
[]
[]
[]
[null,"Capital Additions",null,{"$f":"SUM(D74,D59,D44,D29,D15)","v":1985917.65},{"$f":"SUM(E74,E59,E44,E29,E15)","v":41003.369999999937},{"$f":"SUM(F74,F59,F44,F29,F15)","v":1666816.0499999998},12068.08,2248671.41,1982424.18,1076258.8799999999,24588.12,0,{"$f":"SUM(M74,M59,M44,M29,M15)","v":0},0]
[]
[null,"CCA",null,{"$f":"SUM(D81,D66,D51,D36,D22,)","v":79436.705999999991},{"$f":"SUM(E81,E66,E51,E36,E22,)","v":154158.61032000001},{"$f":"SUM(F81,F66,F51,F36,F22,)","v":210138.69829439998},260482.967630848,330073.90982038015,472911.82063474983,557426.19738396991,556865.98159325216,513300.22786579205,{"$f":"SUM(M81,M66,M51,M36,M22,)","v":472236.20963652874},434457.31286560639]

{"sheet":"4. Fund Adder Revenues","index":3,"n_rows":151,"n_cols":14,"rows_kept":151,"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 Fund 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,"2016 Q1",1.0999999999999999E-2,2.92E-2,null,"2016-01-01",{"$f":"YEAR(F16)","v":2016},{"$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":"2016 Q1"},0,null,1.0999999999999999E-2,{"$f":"ROUND(J16*L16/12,2)","v":0},{"$f":"K16+M16","v":0}]
[null,"2016 Q2",1.0999999999999999E-2,2.92E-2,null,"2016-02-01",{"$f":"YEAR(F17)","v":2016},{"$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":"2016 Q1"},{"$f":"J16+K16","v":0},null,1.0999999999999999E-2,{"$f":"ROUND(J17*L17/12,2)","v":0},{"$f":"N16+K17+M17","v":0}]
[null,"2016 Q3",1.0999999999999999E-2,2.92E-2,null,"2016-03-01",2016,"Q1","2016 Q1",{"$f":"J17+K17","v":0},null,1.0999999999999999E-2,0,{"$f":"N17+K18+M18","v":0}]
[null,"2016 Q4",1.0999999999999999E-2,2.46E-2,null,"2016-04-01",2016,"Q2","2016 Q2",0,null,1.0999999999999999E-2,0,0]
[null,"2017 Q1",1.0999999999999999E-2,2.81E-2,null,"2016-05-01",2016,"Q2","2016 Q2",0,null,1.0999999999999999E-2,0,0]
[null,"2017 Q2",1.0999999999999999E-2,2.81E-2,null,"2016-06-01",2016,"Q2","2016 Q2",0,null,1.0999999999999999E-2,0,0]
[null,"2017 Q3",1.0999999999999999E-2,2.53E-2,null,"2016-07-01",2016,"Q3","2016 Q3",0,null,1.0999999999999999E-2,0,0]
[null,"2017 Q4",1.4999999999999999E-2,2.9899999999999999E-2,null,"2016-08-01",2016,"Q3","2016 Q3",0,null,1.0999999999999999E-2,0,0]
[null,"2018 Q1",1.4999999999999999E-2,2.9899999999999999E-2,null,"2016-09-01",2016,"Q3","2016 Q3",0,null,1.0999999999999999E-2,0,0]
[null,"2018 Q2",1.89E-2,3.3500000000000002E-2,null,"2016-10-01",2016,"Q4","2016 Q4",0,null,1.0999999999999999E-2,0,0]
[null,"2018 Q3",1.89E-2,3.3500000000000002E-2,null,"2016-11-01",2016,"Q4","2016 Q4",0,null,1.0999999999999999E-2,0,0]
[null,"2018 Q4",2.1700000000000001E-2,3.3500000000000002E-2,null,"2016-12-01",2016,"Q4","2016 Q4",0,null,1.0999999999999999E-2,0,0]
[null,"2019 Q1",2.4500000000000001E-2,3.8199999999999998E-2,null,"2017-01-01",2017,"Q1","2017 Q1",0,null,1.0999999999999999E-2,0,0]
[null,"2019 Q2",2.18E-2,3.39E-2,null,"2017-02-01",2017,"Q1","2017 Q1",0,null,1.0999999999999999E-2,0,0]
[null,"2019 Q3",2.18E-2,2.8799999999999999E-2,null,"2017-03-01",2017,"Q1","2017 Q1",0,null,1.0999999999999999E-2,0,0]
[null,"2019 Q4",2.18E-2,2.8799999999999999E-2,null,"2017-04-01",2017,"Q2","2017 Q2",0,null,1.0999999999999999E-2,0,0]
[null,"2020 Q1",2.18E-2,2.8799999999999999E-2,null,"2017-05-01",2017,"Q2","2017 Q2",0,null,1.0999999999999999E-2,0,0]
[null,"2020 Q2",2.18E-2,2.4799999999999999E-2,null,"2017-06-01",2017,"Q2","2017 Q2",0,null,1.0999999999999999E-2,0,0]
[null,"2020 Q3",5.7000000000000002E-3,2.4799999999999999E-2,null,"2017-07-01",2017,"Q3","2017 Q3",0,null,1.0999999999999999E-2,0,0]
[null,"2020 Q4",5.7000000000000002E-3,2.0299999999999999E-2,null,"2017-08-01",2017,"Q3","2017 Q3",0,null,1.0999999999999999E-2,0,0]
[null,"2021 Q1",5.7000000000000002E-3,2.0299999999999999E-2,null,"2017-09-01",2017,"Q3","2017 Q3",0,null,1.0999999999999999E-2,0,0]
[null,"2021 Q2",5.7000000000000002E-3,2.29E-2,null,"2017-10-01",2017,"Q4","2017 Q4",0,null,1.4999999999999999E-2,0,0]
[null,"2021 Q3",5.7000000000000002E-3,2.29E-2,null,"2017-11-01",2017,"Q4","2017 Q4",0,null,1.4999999999999999E-2,0,0]
[null,"2021 Q4",5.7000000000000002E-3,2.29E-2,null,"2017-12-01",2017,"Q4","2017 Q4",0,null,1.4999999999999999E-2,0,0]
[null,"2022 Q1",5.7000000000000002E-3,2.7199999999999998E-2,null,"2018-01-01",{"$f":"YEAR(F40)","v":2018},{"$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":"2018 Q1"},0,null,1.4999999999999999E-2,{"$f":"ROUND(J40*L40/12,2)","v":0},{"$f":"K40+M40","v":0}]
[null,"2022 Q2",1.0200000000000001E-2,3.3099999999999997E-2,null,"2018-02-01",{"$f":"YEAR(F41)","v":2018},{"$f":"IF(MONTH(F41)=0,\"\",IF(MONTH(F41)<4,\"Q1\",IF(MONTH(F41)<7,\"Q2\",IF(MONTH(F41)<10,\"Q3\",\"Q4\"))))","v":"Q1"},{"$f":"CONCATENATE(G41,\" \",H41)","v":"2018 Q1"},{"$f":"J40+K40","v":0},null,1.4999999999999999E-2,{"$f":"ROUND(J41*L41/12,2)","v":0},{"$f":"N40+K41+M41","v":0}]
[null,"2022 Q3",2.1999999999999999E-2,4.6600000000000003E-2,null,"2018-03-01",2018,"Q1","2018 Q1",{"$f":"J41+K41","v":0},null,1.4999999999999999E-2,0,{"$f":"N41+K42+M42","v":0}]
[null,"2022 Q4",3.8699999999999998E-2,5.0099999999999999E-2,null,"2018-04-01",2018,"Q2","2018 Q2",0,null,1.89E-2,0,0]
[null,"2023 Q1",4.7300000000000002E-2,5.0099999999999999E-2,null,"2018-05-01",2018,"Q2","2018 Q2",0,null,1.89E-2,0,0]
[null,"2023 Q2",4.9799999999999997E-2,5.0099999999999999E-2,null,"2018-06-01",2018,"Q2","2018 Q2",0,null,1.89E-2,0,0]
[null,"2023 Q3",4.9799999999999997E-2,5.0099999999999999E-2,null,"2018-07-01",2018,"Q3","2018 Q3",0,null,1.89E-2,0,0]
[null,"2023 Q4",5.4899999999999997E-2,5.4800000000000001E-2,null,"2018-08-01",2018,"Q3","2018 Q3",0,null,1.89E-2,0,0]
[null,"2024 Q1",5.4899999999999997E-2,5.4800000000000001E-2,null,"2018-09-01",2018,"Q3","2018 Q3",0,null,1.89E-2,0,0]
[null,"2024 Q2",5.4899999999999997E-2,5.9799999999999999E-2,null,"2018-10-01",2018,"Q4","2018 Q4",0,null,2.1700000000000001E-2,0,0]
[null,"2024 Q3",5.1999999999999998E-2,5.9799999999999999E-2,null,"2018-11-01",2018,"Q4","2018 Q4",0,null,2.1700000000000001E-2,0,0]
[null,"2024 Q4",4.3999999999999997E-2,4.5499999999999999E-2,null,"2018-12-01",2018,"Q4","2018 Q4",0,null,2.1700000000000001E-2,0,0]
[null,"2025 Q1",3.6400000000000002E-2,4.2299999999999997E-2,null,"2019-01-01",2019,"Q1","2019 Q1",0,null,2.4500000000000001E-2,0,0]
[null,"2025 Q2",3.1600000000000003E-2,4.2299999999999997E-2,null,"2019-02-01",2019,"Q1","2019 Q1",0,null,2.4500000000000001E-2,0,0]
[null,"2025 Q3",2.9100000000000001E-2,4.2299999999999997E-2,null,"2019-03-01",2019,"Q1","2019 Q1",0,null,2.4500000000000001E-2,0,0]
[null,"2025 Q4",2.9100000000000001E-2,4.2299999999999997E-2,null,"2019-04-01",2019,"Q2","2019 Q2",0,null,2.18E-2,0,0]
[null,"2026 Q1",2.5499999999999998E-2,4.2299999999999997E-2,null,"2019-05-01",2019,"Q2","2019 Q2",0,null,2.18E-2,0,0]
[null,"2026 Q2",2.5499999999999998E-2,4.2299999999999997E-2,null,"2019-06-01",2019,"Q2","2019 Q2",0,null,2.18E-2,0,0]
[null,"2026 Q3",2.5499999999999998E-2,4.2299999999999997E-2,null,"2019-07-01",2019,"Q3","2019 Q3",0,null,2.18E-2,0,0]
[null,"2026 Q4",2.5499999999999998E-2,4.2299999999999997E-2,null,"2019-08-01",2019,"Q3","2019 Q3",0,null,2.18E-2,0,0]
[null,null,null,null,null,"2019-09-01",2019,"Q3","2019 Q3",0,null,2.18E-2,0,0]
[null,null,null,null,null,"2019-10-01",2019,"Q4","2019 Q4",0,null,2.18E-2,0,0]
[null,null,null,null,null,"2019-11-01",2019,"Q4","2019 Q4",0,null,2.18E-2,0,0]
[null,null,null,null,null,"2019-12-01",2019,"Q4","2019 Q4",0,null,2.18E-2,0,0]
[null,null,null,null,null,"2020-01-01",{"$f":"YEAR(F64)","v":2020},{"$f":"IF(MONTH(F64)=0,\"\",IF(MONTH(F64)<4,\"Q1\",IF(MONTH(F64)<7,\"Q2\",IF(MONTH(F64)<10,\"Q3\",\"Q4\"))))","v":"Q1"},{"$f":"CONCATENATE(G64,\" \",H64)","v":"2020 Q1"},0,null,2.18E-2,{"$f":"ROUND(J64*L64/12,2)","v":0},0]
[null,null,null,null,null,"2020-02-01",{"$f":"YEAR(F65)","v":2020},{"$f":"IF(MONTH(F65)=0,\"\",IF(MONTH(F65)<4,\"Q1\",IF(MONTH(F65)<7,\"Q2\",IF(MONTH(F65)<10,\"Q3\",\"Q4\"))))","v":"Q1"},{"$f":"CONCATENATE(G65,\" \",H65)","v":"2020 Q1"},0,null,2.18E-2,{"$f":"ROUND(J65*L65/12,2)","v":0},0]
[null,null,null,null,null,"2020-03-01",{"$f":"YEAR(F66)","v":2020},{"$f":"IF(MONTH(F66)=0,\"\",IF(MONTH(F66)<4,\"Q1\",IF(MONTH(F66)<7,\"Q2\",IF(MONTH(F66)<10,\"Q3\",\"Q4\"))))","v":"Q1"},{"$f":"CONCATENATE(G66,\" \",H66)","v":"2020 Q1"},0,null,2.18E-2,{"$f":"ROUND(J66*L66/12,2)","v":0},0]
[null,null,null,null,null,"2020-04-01",{"$f":"YEAR(F67)","v":2020},{"$f":"IF(MONTH(F67)=0,\"\",IF(MONTH(F67)<4,\"Q1\",IF(MONTH(F67)<7,\"Q2\",IF(MONTH(F67)<10,\"Q3\",\"Q4\"))))","v":"Q2"},{"$f":"CONCATENATE(G67,\" \",H67)","v":"2020 Q2"},0,null,2.18E-2,{"$f":"ROUND(J67*L67/12,2)","v":0},0]
[null,null,null,null,null,"2020-05-01",{"$f":"YEAR(F68)","v":2020},{"$f":"IF(MONTH(F68)=0,\"\",IF(MONTH(F68)<4,\"Q1\",IF(MONTH(F68)<7,\"Q2\",IF(MONTH(F68)<10,\"Q3\",\"Q4\"))))","v":"Q2"},{"$f":"CONCATENATE(G68,\" \",H68)","v":"2020 Q2"},0,null,2.18E-2,{"$f":"ROUND(J68*L68/12,2)","v":0},0]
[null,null,null,null,null,"2020-06-01",{"$f":"YEAR(F69)","v":2020},{"$f":"IF(MONTH(F69)=0,\"\",IF(MONTH(F69)<4,\"Q1\",IF(MONTH(F69)<7,\"Q2\",IF(MONTH(F69)<10,\"Q3\",\"Q4\"))))","v":"Q2"},{"$f":"CONCATENATE(G69,\" \",H69)","v":"2020 Q2"},0,null,2.18E-2,{"$f":"ROUND(J69*L69/12,2)","v":0},0]
[null,null,null,null,null,"2020-07-01",{"$f":"YEAR(F70)","v":2020},{"$f":"IF(MONTH(F70)=0,\"\",IF(MONTH(F70)<4,\"Q1\",IF(MONTH(F70)<7,\"Q2\",IF(MONTH(F70)<10,\"Q3\",\"Q4\"))))","v":"Q3"},{"$f":"CONCATENATE(G70,\" \",H70)","v":"2020 Q3"},0,null,5.7000000000000002E-3,{"$f":"ROUND(J70*L70/12,2)","v":0},0]
[null,null,null,null,null,"2020-08-01",{"$f":"YEAR(F71)","v":2020},{"$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":"2020 Q3"},0,null,5.7000000000000002E-3,{"$f":"ROUND(J71*L71/12,2)","v":0},0]
[null,null,null,null,null,"2020-09-01",{"$f":"YEAR(F72)","v":2020},{"$f":"IF(MONTH(F72)=0,\"\",IF(MONTH(F72)<4,\"Q1\",IF(MONTH(F72)<7,\"Q2\",IF(MONTH(F72)<10,\"Q3\",\"Q4\"))))","v":"Q3"},{"$f":"CONCATENATE(G72,\" \",H72)","v":"2020 Q3"},0,null,5.7000000000000002E-3,{"$f":"ROUND(J72*L72/12,2)","v":0},0]
[null,null,null,null,null,"2020-10-01",{"$f":"YEAR(F73)","v":2020},{"$f":"IF(MONTH(F73)=0,\"\",IF(MONTH(F73)<4,\"Q1\",IF(MONTH(F73)<7,\"Q2\",IF(MONTH(F73)<10,\"Q3\",\"Q4\"))))","v":"Q4"},{"$f":"CONCATENATE(G73,\" \",H73)","v":"2020 Q4"},0,null,5.7000000000000002E-3,{"$f":"ROUND(J73*L73/12,2)","v":0},0]
[null,null,null,null,null,"2020-11-01",{"$f":"YEAR(F74)","v":2020},{"$f":"IF(MONTH(F74)=0,\"\",IF(MONTH(F74)<4,\"Q1\",IF(MONTH(F74)<7,\"Q2\",IF(MONTH(F74)<10,\"Q3\",\"Q4\"))))","v":"Q4"},{"$f":"CONCATENATE(G74,\" \",H74)","v":"2020 Q4"},0,null,5.7000000000000002E-3,{"$f":"ROUND(J74*L74/12,2)","v":0},0]
[null,null,null,null,null,"2020-12-01",{"$f":"YEAR(F75)","v":2020},{"$f":"IF(MONTH(F75)=0,\"\",IF(MONTH(F75)<4,\"Q1\",IF(MONTH(F75)<7,\"Q2\",IF(MONTH(F75)<10,\"Q3\",\"Q4\"))))","v":"Q4"},{"$f":"CONCATENATE(G75,\" \",H75)","v":"2020 Q4"},0,null,5.7000000000000002E-3,{"$f":"ROUND(J75*L75/12,2)","v":0},0]
[null,null,null,null,null,"2021-01-01",{"$f":"YEAR(F76)","v":2021},{"$f":"IF(MONTH(F76)=0,\"\",IF(MONTH(F76)<4,\"Q1\",IF(MONTH(F76)<7,\"Q2\",IF(MONTH(F76)<10,\"Q3\",\"Q4\"))))","v":"Q1"},{"$f":"CONCATENATE(G76,\" \",H76)","v":"2021 Q1"},0,null,5.7000000000000002E-3,{"$f":"ROUND(J76*L76/12,2)","v":0},0]
[null,null,null,null,null,"2021-02-01",{"$f":"YEAR(F77)","v":2021},{"$f":"IF(MONTH(F77)=0,\"\",IF(MONTH(F77)<4,\"Q1\",IF(MONTH(F77)<7,\"Q2\",IF(MONTH(F77)<10,\"Q3\",\"Q4\"))))","v":"Q1"},{"$f":"CONCATENATE(G77,\" \",H77)","v":"2021 Q1"},0,null,5.7000000000000002E-3,{"$f":"ROUND(J77*L77/12,2)","v":0},0]
[null,null,null,null,null,"2021-03-01",{"$f":"YEAR(F78)","v":2021},{"$f":"IF(MONTH(F78)=0,\"\",IF(MONTH(F78)<4,\"Q1\",IF(MONTH(F78)<7,\"Q2\",IF(MONTH(F78)<10,\"Q3\",\"Q4\"))))","v":"Q1"},{"$f":"CONCATENATE(G78,\" \",H78)","v":"2021 Q1"},0,null,5.7000000000000002E-3,{"$f":"ROUND(J78*L78/12,2)","v":0},0]
[null,null,null,null,null,"2021-04-01",{"$f":"YEAR(F79)","v":2021},{"$f":"IF(MONTH(F79)=0,\"\",IF(MONTH(F79)<4,\"Q1\",IF(MONTH(F79)<7,\"Q2\",IF(MONTH(F79)<10,\"Q3\",\"Q4\"))))","v":"Q2"},{"$f":"CONCATENATE(G79,\" \",H79)","v":"2021 Q2"},0,null,5.7000000000000002E-3,{"$f":"ROUND(J79*L79/12,2)","v":0},0]
[null,null,null,null,null,"2021-05-01",{"$f":"YEAR(F80)","v":2021},{"$f":"IF(MONTH(F80)=0,\"\",IF(MONTH(F80)<4,\"Q1\",IF(MONTH(F80)<7,\"Q2\",IF(MONTH(F80)<10,\"Q3\",\"Q4\"))))","v":"Q2"},{"$f":"CONCATENATE(G80,\" \",H80)","v":"2021 Q2"},0,null,5.7000000000000002E-3,{"$f":"ROUND(J80*L80/12,2)","v":0},0]
[null,null,null,null,null,"2021-06-01",{"$f":"YEAR(F81)","v":2021},{"$f":"IF(MONTH(F81)=0,\"\",IF(MONTH(F81)<4,\"Q1\",IF(MONTH(F81)<7,\"Q2\",IF(MONTH(F81)<10,\"Q3\",\"Q4\"))))","v":"Q2"},{"$f":"CONCATENATE(G81,\" \",H81)","v":"2021 Q2"},0,null,5.7000000000000002E-3,{"$f":"ROUND(J81*L81/12,2)","v":0},0]
[null,null,null,null,null,"2021-07-01",{"$f":"YEAR(F82)","v":2021},{"$f":"IF(MONTH(F82)=0,\"\",IF(MONTH(F82)<4,\"Q1\",IF(MONTH(F82)<7,\"Q2\",IF(MONTH(F82)<10,\"Q3\",\"Q4\"))))","v":"Q3"},{"$f":"CONCATENATE(G82,\" \",H82)","v":"2021 Q3"},0,null,5.7000000000000002E-3,{"$f":"ROUND(J82*L82/12,2)","v":0},0]
[null,null,null,null,null,"2021-08-01",{"$f":"YEAR(F83)","v":2021},{"$f":"IF(MONTH(F83)=0,\"\",IF(MONTH(F83)<4,\"Q1\",IF(MONTH(F83)<7,\"Q2\",IF(MONTH(F83)<10,\"Q3\",\"Q4\"))))","v":"Q3"},{"$f":"CONCATENATE(G83,\" \",H83)","v":"2021 Q3"},0,null,5.7000000000000002E-3,{"$f":"ROUND(J83*L83/12,2)","v":0},0]
[null,null,null,null,null,"2021-09-01",{"$f":"YEAR(F84)","v":2021},{"$f":"IF(MONTH(F84)=0,\"\",IF(MONTH(F84)<4,\"Q1\",IF(MONTH(F84)<7,\"Q2\",IF(MONTH(F84)<10,\"Q3\",\"Q4\"))))","v":"Q3"},{"$f":"CONCATENATE(G84,\" \",H84)","v":"2021 Q3"},{"$f":"J83+K83","v":0},null,5.7000000000000002E-3,{"$f":"ROUND(J84*L84/12,2)","v":0},{"$f":"N83+K84+M84","v":0}]
[null,null,null,null,null,"2021-10-01",2021,"Q4","2021 Q4",0,null,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2021-11-01",2021,"Q4","2021 Q4",0,null,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2021-12-01",2021,"Q4","2021 Q4",0,null,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2022-01-01",2022,"Q1","2022 Q1",0,null,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2022-02-01",2022,"Q1","2022 Q1",0,null,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2022-03-01",2022,"Q1","2022 Q1",0,null,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2022-04-01",2022,"Q2","2022 Q2",0,null,1.0200000000000001E-2,0,0]
[null,null,null,null,null,"2022-05-01",2022,"Q2","2022 Q2",0,null,1.0200000000000001E-2,0,0]
[null,null,null,null,null,"2022-06-01",2022,"Q2","2022 Q2",0,null,1.0200000000000001E-2,0,0]
[null,null,null,null,null,"2022-07-01",2022,"Q3","2022 Q3",0,null,2.1999999999999999E-2,0,0]
[null,null,null,null,null,"2022-08-01",2022,"Q3","2022 Q3",0,null,2.1999999999999999E-2,0,0]
[null,null,null,null,null,"2022-09-01",2022,"Q3","2022 Q3",0,null,2.1999999999999999E-2,0,0]
[null,null,null,null,null,"2022-10-01",2022,"Q4","2022 Q4",0,null,3.8699999999999998E-2,0,0]
[null,null,null,null,null,"2022-11-01",2022,"Q4","2022 Q4",0,null,3.8699999999999998E-2,0,0]
[null,null,null,null,null,"2022-12-01",2022,"Q4","2022 Q4",0,null,3.8699999999999998E-2,0,0]
[null,null,null,null,null,"2023-01-01",2023,"Q1","2023 Q1",0,null,4.7300000000000002E-2,0,0]
[null,null,null,null,null,"2023-02-01",2023,"Q1","2023 Q1",0,null,4.7300000000000002E-2,0,0]
[null,null,null,null,null,"2023-03-01",2023,"Q1","2023 Q1",0,null,4.7300000000000002E-2,0,0]
[null,null,null,null,null,"2023-04-01",2023,"Q2","2023 Q2",0,null,4.9799999999999997E-2,0,0]
[null,null,null,null,null,"2023-05-01",2023,"Q2","2023 Q2",0,null,4.9799999999999997E-2,0,0]
[null,null,null,null,null,"2023-06-01",2023,"Q2","2023 Q2",0,null,4.9799999999999997E-2,0,0]
[null,null,null,null,null,"2023-07-01",2023,"Q3","2023 Q3",0,null,4.9799999999999997E-2,0,0]
[null,null,null,null,null,"2023-08-01",2023,"Q3","2023 Q3",0,null,4.9799999999999997E-2,0,0]
[null,null,null,null,null,"2023-09-01",2023,"Q3","2023 Q3",0,null,4.9799999999999997E-2,0,0]
[null,null,null,null,null,"2023-10-01",2023,"Q4","2023 Q4",0,null,5.4899999999999997E-2,0,0]
[null,null,null,null,null,"2023-11-01",2023,"Q4","2023 Q4",0,null,5.4899999999999997E-2,0,0]
[null,null,null,null,null,"2023-12-01",2023,"Q4","2023 Q4",0,null,5.4899999999999997E-2,0,0]
[null,null,null,null,null,"2024-01-01",2024,"Q1","2024 Q1",0,null,5.4899999999999997E-2,0,0]
[null,null,null,null,null,"2024-02-01",2024,"Q1","2024 Q1",0,null,5.4899999999999997E-2,0,0]
[null,null,null,null,null,"2024-03-01",2024,"Q1","2024 Q1",0,null,5.4899999999999997E-2,0,0]
[null,null,null,null,null,"2024-04-01",2024,"Q2","2024 Q2",0,null,5.4899999999999997E-2,0,0]
[null,null,null,null,null,"2024-05-01",2024,"Q2","2024 Q2",0,null,5.4899999999999997E-2,0,0]
[null,null,null,null,null,"2024-06-01",2024,"Q2","2024 Q2",0,null,5.4899999999999997E-2,0,0]
[null,null,null,null,null,"2024-07-01",2024,"Q3","2024 Q3",0,null,5.1999999999999998E-2,0,0]
[null,null,null,null,null,"2024-08-01",2024,"Q3","2024 Q3",0,null,5.1999999999999998E-2,0,0]
[null,null,null,null,null,"2024-09-01",2024,"Q3","2024 Q3",0,null,5.1999999999999998E-2,0,0]
[null,null,null,null,null,"2024-10-01",2024,"Q4","2024 Q4",0,null,4.3999999999999997E-2,0,0]
[null,null,null,null,null,"2024-11-01",2024,"Q4","2024 Q4",0,null,4.3999999999999997E-2,0,0]
[null,null,null,null,null,"2024-12-01",2024,"Q4","2024 Q4",0,null,4.3999999999999997E-2,0,0]
[null,null,null,null,null,"2025-01-01",2025,"Q1","2025 Q1",0,null,4.3999999999999997E-2,0,0]
[null,null,null,null,null,"2025-02-01",2025,"Q1","2025 Q1",0,null,4.3999999999999997E-2,0,0]
[null,null,null,null,null,"2025-03-01",2025,"Q1","2025 Q1",0,null,4.3999999999999997E-2,0,0]
[null,null,null,null,null,"2025-04-01",2025,"Q2","2025 Q2",0,null,4.3999999999999997E-2,0,0]
[null,null,null,null,null,"2025-05-01",2025,"Q2","2025 Q2",0,null,4.3999999999999997E-2,0,0]
[null,null,null,null,null,"2025-06-01",2025,"Q2","2025 Q2",0,null,4.3999999999999997E-2,0,0]
[null,null,null,null,null,"2025-07-01",2025,"Q3","2025 Q3",0,null,4.3999999999999997E-2,0,0]
[null,null,null,null,null,"2025-08-01",2025,"Q3","2025 Q3",0,null,4.3999999999999997E-2,0,0]
[null,null,null,null,null,"2025-09-01",2025,"Q3","2025 Q3",0,null,4.3999999999999997E-2,0,0]
[null,null,null,null,null,"2025-10-01",2025,"Q4","2025 Q4",0,null,4.3999999999999997E-2,0,0]
[null,null,null,null,null,"2025-11-01",2025,"Q4","2025 Q4",0,null,4.3999999999999997E-2,0,0]
[null,null,null,null,null,"2025-12-01",2025,"Q4","2025 Q4",0,null,4.3999999999999997E-2,0,0]
[null,null,null,null,null,"2026-01-01",2026,"Q1","2026 Q1",0,null,4.3999999999999997E-2,0,0]
[null,null,null,null,null,"2026-02-01",2026,"Q1","2026 Q1",0,null,4.3999999999999997E-2,0,0]
[null,null,null,null,null,"2026-03-01",2026,"Q1","2026 Q1",0,null,4.3999999999999997E-2,0,0]
[null,null,null,null,null,"2026-04-01",2026,"Q2","2026 Q2",0,null,4.3999999999999997E-2,0,0]
[null,null,null,null,null,"2026-05-01",2026,"Q2","2026 Q2",0,null,4.3999999999999997E-2,0,0]
[null,null,null,null,null,"2026-06-01",2026,"Q2","2026 Q2",0,null,4.3999999999999997E-2,0,0]
[null,null,null,null,null,"2026-07-01",2026,"Q3","2026 Q3",0,null,4.3999999999999997E-2,0,0]
[null,null,null,null,null,"2026-08-01",2026,"Q3","2026 Q3",0,null,4.3999999999999997E-2,0,0]
[null,null,null,null,null,"2026-09-01",2026,"Q3","2026 Q3",0,null,4.3999999999999997E-2,0,0]
[null,null,null,null,null,"2026-10-01",2026,"Q4","2026 Q4",0,null,4.3999999999999997E-2,0,0]
[null,null,null,null,null,"2026-11-01",2026,"Q4","2026 Q4",0,null,4.3999999999999997E-2,0,0]
[null,null,null,null,null,"2026-12-01",2026,"Q4","2026 Q4",0,null,4.3999999999999997E-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":"K149+M149","v":0}]
[]
[null,"NOTE: Funding adder revenues are up to December 2014 actuals"]

{"sheet":"5. MIST Meters_IRR","index":4,"n_rows":69,"n_cols":36,"rows_kept":69,"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,"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":992958.82499999995},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!F268-'2. MIST Meters Assets_Rate Base'!F269","v":2091439.7599999998},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!G268-'2. MIST Meters Assets_Rate Base'!G269","v":2771613.65},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!H268-'2. MIST Meters Assets_Rate Base'!H269","v":3422583.2799999993},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!I268-'2. MIST Meters Assets_Rate Base'!I269","v":4443036.4499999993},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!J268-'2. MIST Meters Assets_Rate Base'!J269","v":6489101.5599999996},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!K268-'2. MIST Meters Assets_Rate Base'!K269","v":7879956.4749999996},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!L268-'2. MIST Meters Assets_Rate Base'!L269","v":8119312.6849999987},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!M268-'2. MIST Meters Assets_Rate Base'!M269","v":7779484.5599999987},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!N268-'2. MIST Meters Assets_Rate Base'!N269","v":7426531.8999999985},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!O268-'2. MIST Meters Assets_Rate Base'!O269","v":7073579.2399999984},"B"]
[null,"Depreciation Expense",null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!E269","v":0},null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!F269","v":170040.85},null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!G269","v":162650.91},null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!H269","v":111007.86},null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!I269","v":113190.43},null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!J269","v":200605.92},null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!K269","v":324844.53000000003},null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!L269","v":352399.01},null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!M269","v":352952.66},null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!N269","v":352952.66},null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!O269","v":352952.66},"C"]
[null,"Net Fixed Assets to be included in Rate Base",null,null,{"$f":"E15-E16","v":992958.82499999995},null,null,{"$f":"H15-H16","v":1921398.9099999997},null,null,{"$f":"K15-K16","v":2608962.7399999998},null,null,{"$f":"N15-N16","v":3311575.4199999995},null,null,{"$f":"Q15-Q16","v":4329846.0199999996},null,null,{"$f":"T15-T16","v":6288495.6399999997},null,null,{"$f":"W15-W16","v":7555111.9449999994},null,null,{"$f":"Z15-Z16","v":7766913.6749999989},null,null,{"$f":"AC15-AC16","v":7426531.8999999985},null,null,{"$f":"AF15-AF16","v":7073579.2399999984},null,null,{"$f":"AI15-AI16","v":6720626.5799999982},"D = B - C"]
[]
[null,"Deemed ShortTerm Debt %",{"$f":"'1. Cost of Service_parameters'!G14","v":0.04},"E",{"$f":"E17*C19","v":39718.352999999996},{"$f":"'1. Cost of Service_parameters'!H14","v":0.04},null,{"$f":"H17*F19","v":76855.956399999995},{"$f":"'1. Cost of Service_parameters'!I14","v":0.04},null,{"$f":"K17*I19","v":104358.50959999999},{"$f":"'1. Cost of Service_parameters'!J14","v":0.04},null,{"$f":"N17*L19","v":132463.01679999998},{"$f":"'1. Cost of Service_parameters'!K14","v":0.04},null,{"$f":"Q17*O19","v":173193.84079999998},{"$f":"'1. Cost of Service_parameters'!L14","v":0.04},null,{"$f":"T17*R19","v":251539.82559999998},{"$f":"'1. Cost of Service_parameters'!M14","v":0.04},null,{"$f":"W17*U19","v":302204.47779999999},{"$f":"'1. Cost of Service_parameters'!N14","v":0.04},null,{"$f":"Z17*X19","v":310676.54699999996},{"$f":"'1. Cost of Service_parameters'!O14","v":0.04},null,{"$f":"AC17*AA19","v":297061.27599999995},{"$f":"'1. Cost of Service_parameters'!P14","v":0.04},null,{"$f":"AF17*AD19","v":282943.16959999996},{"$f":"'1. Cost of Service_parameters'!Q14","v":0.04},null,{"$f":"AI17*AG19","v":268825.06319999992},"G = D * E"]
[null,"Deemed Long Term Debt %",{"$f":"'1. Cost of Service_parameters'!G15","v":0.55999999999999994},"F",{"$f":"E17*C20","v":556056.94199999992},{"$f":"'1. Cost of Service_parameters'!H15","v":0.55999999999999994},null,{"$f":"H17*F20","v":1075983.3895999996},{"$f":"'1. Cost of Service_parameters'!I15","v":0.55999999999999994},null,{"$f":"K17*I20","v":1461019.1343999996},{"$f":"'1. Cost of Service_parameters'!J15","v":0.55999999999999994},null,{"$f":"N17*L20","v":1854482.2351999995},{"$f":"'1. Cost of Service_parameters'!K15","v":0.55999999999999994},null,{"$f":"Q17*O20","v":2424713.7711999994},{"$f":"'1. Cost of Service_parameters'!L15","v":0.55999999999999994},null,{"$f":"T17*R20","v":3521557.5583999995},{"$f":"'1. Cost of Service_parameters'!M15","v":0.55999999999999994},null,{"$f":"W17*U20","v":4230862.689199999},{"$f":"'1. Cost of Service_parameters'!N15","v":0.55999999999999994},null,{"$f":"Z17*X20","v":4349471.6579999989},{"$f":"'1. Cost of Service_parameters'!O15","v":0.55999999999999994},null,{"$f":"AC17*AA20","v":4158857.8639999987},{"$f":"'1. Cost of Service_parameters'!P15","v":0.55999999999999994},null,{"$f":"AF17*AD20","v":3961204.3743999987},{"$f":"'1. Cost of Service_parameters'!Q15","v":0.55999999999999994},null,{"$f":"AI17*AG20","v":3763550.8847999987},"H = D * F"]
[]
[null,"Short Term Interest",{"$f":"'1. Cost of Service_parameters'!G21","v":1.7600000000000001E-2},"I",{"$f":"E19*C22","v":699.04301279999993},{"$f":"'1. Cost of Service_parameters'!H21","v":1.7600000000000001E-2},null,{"$f":"H19*F22","v":1352.66483264},{"$f":"'1. Cost of Service_parameters'!I21","v":1.7600000000000001E-2},null,{"$f":"K19*I22","v":1836.70976896},{"$f":"'1. Cost of Service_parameters'!J21","v":1.7600000000000001E-2},null,{"$f":"N19*L22","v":2331.3490956799997},{"$f":"'1. Cost of Service_parameters'!K21","v":1.7600000000000001E-2},null,{"$f":"Q19*O22","v":3048.2115980799999},{"$f":"'1. Cost of Service_parameters'!L21","v":1.7600000000000001E-2},null,{"$f":"T19*R22","v":4427.1009305600001},{"$f":"'1. Cost of Service_parameters'!M21","v":1.7600000000000001E-2},null,{"$f":"W19*U22","v":5318.7988092800006},{"$f":"'1. Cost of Service_parameters'!N21","v":1.7600000000000001E-2},null,{"$f":"Z19*X22","v":5467.9072271999994},{"$f":"'1. Cost of Service_parameters'!O21","v":1.7600000000000001E-2},null,{"$f":"AC19*AA22","v":5228.2784575999995},{"$f":"'1. Cost of Service_parameters'!P21","v":1.7600000000000001E-2},null,{"$f":"AF19*AD22","v":4979.7997849599997},{"$f":"'1. Cost of Service_parameters'!Q21","v":1.7600000000000001E-2},null,{"$f":"AI19*AG22","v":4731.321112319999},"K = G * I"]
[null,"Long Term Interest",{"$f":"'1. Cost of Service_parameters'!G22","v":3.8825037148941706E-2},"J",{"$f":"E20*C23","v":21588.931430076922},{"$f":"'1. Cost of Service_parameters'!H22","v":3.8825037148941706E-2},null,{"$f":"H20*F23","v":41775.095072864206},{"$f":"'1. Cost of Service_parameters'!I22","v":3.8825037148941706E-2},null,{"$f":"K20*I23","v":56724.122168394642},{"$f":"'1. Cost of Service_parameters'!J22","v":3.8825037148941706E-2},null,{"$f":"N20*L23","v":72000.341673692426},{"$f":"'1. Cost of Service_parameters'!K22","v":3.8825037148941706E-2},null,{"$f":"Q20*O23","v":94139.602242390509},{"$f":"'1. Cost of Service_parameters'!L22","v":3.8825037148941706E-2},null,{"$f":"T20*R23","v":136724.60302701642},{"$f":"'1. Cost of Service_parameters'!M22","v":3.8825037148941706E-2},null,{"$f":"W20*U23","v":164263.40108026136},{"$f":"'1. Cost of Service_parameters'!N22","v":3.8825037148941706E-2},null,{"$f":"Z20*X23","v":168868.39870011903},{"$f":"'1. Cost of Service_parameters'!O22","v":3.8825037148941706E-2},null,{"$f":"AC20*AA23","v":161467.81106696831},{"$f":"'1. Cost of Service_parameters'!P22","v":3.8825037148941706E-2},null,{"$f":"AF20*AD23","v":153793.90699063035},{"$f":"'1. Cost of Service_parameters'!Q22","v":3.8825037148941706E-2},null,{"$f":"AI20*AG23","v":146120.00291429239},"L = H * J"]
[]
[null,"Return on Rate Base - Interest",null,null,{"$f":"SUM(E22:E23)","v":22287.974442876923},null,null,{"$f":"SUM(H22:H23)","v":43127.759905504208},null,null,{"$f":"SUM(K22:K23)","v":58560.83193735464},null,null,{"$f":"SUM(N22:N23)","v":74331.690769372421},null,null,{"$f":"SUM(Q22:Q23)","v":97187.81384047051},null,null,{"$f":"SUM(T22:T23)","v":141151.70395757642},null,null,{"$f":"SUM(W22:W23)","v":169582.19988954137},null,null,{"$f":"SUM(Z22:Z23)","v":174336.30592731902},null,null,{"$f":"SUM(AC22:AC23)","v":166696.08952456832},null,null,{"$f":"SUM(AF22:AF23)","v":158773.70677559034},null,null,{"$f":"SUM(AI22:AI23)","v":150851.32402661239},"M = K + L"]
[]
[]
[null,"Deemed Equity %",{"$f":"'1. Cost of Service_parameters'!G16","v":0.40000000000000008},"N",{"$f":"E17*C28","v":397183.53000000009},{"$f":"'1. Cost of Service_parameters'!H16","v":0.40000000000000008},null,{"$f":"H17*F28","v":768559.56400000001},{"$f":"'1. Cost of Service_parameters'!I16","v":0.40000000000000008},null,{"$f":"K17*I28","v":1043585.0960000001},{"$f":"'1. Cost of Service_parameters'!J16","v":0.40000000000000008},null,{"$f":"N17*L28","v":1324630.1680000001},{"$f":"'1. Cost of Service_parameters'!K16","v":0.40000000000000008},null,{"$f":"Q17*O28","v":1731938.4080000001},{"$f":"'1. Cost of Service_parameters'!L16","v":0.40000000000000008},null,{"$f":"T17*R28","v":2515398.2560000005},{"$f":"'1. Cost of Service_parameters'!M16","v":0.40000000000000008},null,{"$f":"W17*U28","v":3022044.7780000004},{"$f":"'1. Cost of Service_parameters'!N16","v":0.40000000000000008},null,{"$f":"Z17*X28","v":3106765.47},{"$f":"'1. Cost of Service_parameters'!O16","v":0.40000000000000008},null,{"$f":"AC17*AA28","v":2970612.76},{"$f":"'1. Cost of Service_parameters'!P16","v":0.40000000000000008},null,{"$f":"AF17*AD28","v":2829431.696},{"$f":"'1. Cost of Service_parameters'!Q16","v":0.40000000000000008},null,{"$f":"AI17*AG28","v":2688250.6319999998},"P = D * N"]
[]
[null,"Return on Rate Base -Equity",{"$f":"'1. Cost of Service_parameters'!G23","v":8.7800000000000003E-2},"O",{"$f":"E28*C30","v":34872.713934000007},{"$f":"'1. Cost of Service_parameters'!H23","v":8.7800000000000003E-2},null,{"$f":"H28*F30","v":67479.5297192},{"$f":"'1. Cost of Service_parameters'!I23","v":8.7800000000000003E-2},null,{"$f":"K28*I30","v":91626.771428800013},{"$f":"'1. Cost of Service_parameters'!J23","v":8.7800000000000003E-2},null,{"$f":"N28*L30","v":116302.52875040002},{"$f":"'1. Cost of Service_parameters'!K23","v":8.7800000000000003E-2},null,{"$f":"Q28*O30","v":152064.19222240002},{"$f":"'1. Cost of Service_parameters'!L23","v":8.7800000000000003E-2},null,{"$f":"T28*R30","v":220851.96687680006},{"$f":"'1. Cost of Service_parameters'!M23","v":8.7800000000000003E-2},null,{"$f":"W28*U30","v":265335.53150840005},{"$f":"'1. Cost of Service_parameters'!N23","v":8.7800000000000003E-2},null,{"$f":"Z28*X30","v":272774.00826600002},{"$f":"'1. Cost of Service_parameters'!O23","v":8.7800000000000003E-2},null,{"$f":"AC28*AA30","v":260819.80032799998},{"$f":"'1. Cost of Service_parameters'!P23","v":8.7800000000000003E-2},null,{"$f":"AF28*AD30","v":248424.10290880001},{"$f":"'1. Cost of Service_parameters'!Q23","v":8.7800000000000003E-2},null,{"$f":"AI28*AG30","v":236028.40548959997},"Q = P * O"]
[]
[null,"Return on Rate Base - Total",null,null,{"$f":"E25+E30","v":57160.688376876933},null,null,{"$f":"H25+H30","v":110607.28962470421},null,null,{"$f":"K25+K30","v":150187.60336615465},null,null,{"$f":"N25+N30","v":190634.21951977245},null,null,{"$f":"Q25+Q30","v":249252.00606287053},null,null,{"$f":"T25+T30","v":362003.67083437648},null,null,{"$f":"W25+W30","v":434917.73139794142},null,null,{"$f":"Z25+Z30","v":447110.31419331906},null,null,{"$f":"AC25+AC30","v":427515.88985256827},null,null,{"$f":"AF25+AF30","v":407197.80968439032},null,null,{"$f":"AI25+AI30","v":386879.72951621236},"R = M + Q"]
[]
[]
[]
[null,"Amortization Expense"]
[]
[null,"Amortization Expense - Incremental",null,"C",{"$f":"E16","v":0},null,null,{"$f":"H16","v":170040.85},null,null,{"$f":"K16","v":162650.91},null,null,{"$f":"N16","v":111007.86},null,null,{"$f":"Q16","v":113190.43},null,null,{"$f":"T16","v":200605.92},null,null,{"$f":"W16","v":324844.53000000003},null,null,{"$f":"Z16","v":352399.01},null,null,{"$f":"AC16","v":352952.66},null,null,{"$f":"AF16","v":352952.66},null,null,{"$f":"AI16","v":352952.66},"S"]
[]
[]
[null,"OM&A Expense"]
[]
[null,"OM&A Expense - Incremental",null,"D",31250.880000000001,null,null,44277.59,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,"S"]
[]
[]
[null,"Grossed up PIL's"]
[]
[null,"Regulatory Taxable Income",null,"O",{"$f":"E30","v":34872.713934000007},null,null,{"$f":"H30","v":67479.5297192},null,null,{"$f":"K30","v":91626.771428800013},null,null,{"$f":"N30","v":116302.52875040002},null,null,{"$f":"Q30","v":152064.19222240002},null,null,{"$f":"T30","v":220851.96687680006},null,null,{"$f":"W30","v":265335.53150840005},null,null,{"$f":"Z30","v":272774.00826600002},null,null,{"$f":"AC30","v":260819.80032799998},null,null,{"$f":"AF30","v":248424.10290880001},null,null,{"$f":"AI30","v":236028.40548959997},"T "]
[]
[null,"Add Back Amortization Expense",null,"S",{"$f":"E38","v":0},null,null,{"$f":"H38","v":170040.85},null,null,{"$f":"K38","v":162650.91},null,null,{"$f":"N38","v":111007.86},null,null,{"$f":"Q38","v":113190.43},null,null,{"$f":"T38","v":200605.92},null,null,{"$f":"W38","v":324844.53000000003},null,null,{"$f":"Z38","v":352399.01},null,null,{"$f":"AC38","v":352952.66},null,null,{"$f":"AF38","v":352952.66},null,null,{"$f":"AI38","v":352952.66},"U"]
[]
[null,"Deduct CCA",null,null,{"$f":"'3. UCC_Calculations'!D88","v":79436.705999999991},null,null,{"$f":"+'3. UCC_Calculations'!E88","v":154158.61032000001},null,null,{"$f":"+'3. UCC_Calculations'!F88","v":210138.69829439998},null,null,{"$f":"+'3. UCC_Calculations'!G88","v":260482.967630848},null,null,{"$f":"+'3. UCC_Calculations'!H88","v":330073.90982038015},null,null,{"$f":"+'3. UCC_Calculations'!I88","v":472911.82063474983},null,null,{"$f":"+'3. UCC_Calculations'!J88","v":557426.19738396991},null,null,{"$f":"+'3. UCC_Calculations'!K88","v":556865.98159325216},null,null,{"$f":"+'3. UCC_Calculations'!L88","v":513300.22786579205},null,null,{"$f":"+'3. UCC_Calculations'!M88","v":472236.20963652874},null,null,{"$f":"+'3. UCC_Calculations'!N88","v":434457.31286560639},"V"]
[]
[null,"Incremental Taxable Income",null,null,{"$f":"E48+E50-E52","v":-44563.992065999984},null,null,{"$f":"H48+H50-H52","v":83361.769399200013},null,null,{"$f":"K48+K50-K52","v":44138.983134400041},null,null,{"$f":"N48+N50-N52","v":-33172.578880447982},null,null,{"$f":"Q48+Q50-Q52","v":-64819.287597980117},null,null,{"$f":"T48+T50-T52","v":-51453.933757949737},null,null,{"$f":"W48+W50-W52","v":32753.864124430227},null,null,{"$f":"Z48+Z50-Z52","v":68307.036672747927},null,null,{"$f":"AC48+AC50-AC52","v":100472.23246220784},null,null,{"$f":"AF48+AF50-AF52","v":129140.5532722713},null,null,{"$f":"AI48+AI50-AI52","v":154523.75262399355},"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,"PIL's Before Gross Up",null,null,{"$f":"E54*C56","v":-11809.457897489996},null,null,{"$f":"H54*F56","v":22090.868890788006},null,null,{"$f":"K54*I56","v":11696.830530616011},null,null,{"$f":"N54*L56","v":-8790.7334033187162},null,null,{"$f":"Q54*O56","v":-17177.111213464734},null,null,{"$f":"T54*R56","v":-13635.292445856681},null,null,{"$f":"W54*U56","v":8679.773992974011},null,null,{"$f":"Z54*X56","v":18101.364718278201},null,null,{"$f":"AC54*AA56","v":26625.141602485081},null,null,{"$f":"AF54*AD56","v":34222.246617151897},null,null,{"$f":"AI54*AG56","v":40948.794445358297},"Y = W * X"]
[]
[null,"Incremental Grossed Up PIL's",null,null,{"$f":"E58/(1-C56)","v":-16067.289656448975},null,null,{"$f":"H58/(1-F56)","v":30055.603933044906},null,null,{"$f":"K58/(1-I56)","v":15914.055143695254},null,null,{"$f":"N58/(1-L56)","v":-11960.181501113901},null,null,{"$f":"Q58/(1-O56)","v":-23370.219338047256},null,null,{"$f":"T58/(1-R56)","v":-18551.41829368256},null,null,{"$f":"W58/(1-U56)","v":11809.216316971444},null,null,{"$f":"Z58/(1-X56)","v":24627.707099698233},null,null,{"$f":"AC58/(1-AA56)","v":36224.682452360656},null,null,{"$f":"AF58/(1-AD56)","v":46560.879751227068},null,null,{"$f":"AI58/(1-AG56)","v":55712.645503888838},"Z = Y / ( 1 - X ) "]
[]
[]
[null,"Incremental Revenue Requirement"]
[null,"Return on Rate Base - Total",null,"Q",{"$f":"E32","v":57160.688376876933},null,null,{"$f":"H32","v":110607.28962470421},null,null,{"$f":"K32","v":150187.60336615465},null,null,{"$f":"N32","v":190634.21951977245},null,null,{"$f":"Q32","v":249252.00606287053},null,null,{"$f":"T32","v":362003.67083437648},null,null,{"$f":"W32","v":434917.73139794142},null,null,{"$f":"Z32","v":447110.31419331906},null,null,{"$f":"AC32","v":427515.88985256827},null,null,{"$f":"AF32","v":407197.80968439032},null,null,{"$f":"AI32","v":386879.72951621236},"AF"]
[null,"Amortization Expense - Total",null,"S",{"$f":"E38","v":0},null,null,{"$f":"H38","v":170040.85},null,null,{"$f":"K38","v":162650.91},null,null,{"$f":"N38","v":111007.86},null,null,{"$f":"Q38","v":113190.43},null,null,{"$f":"T38","v":200605.92},null,null,{"$f":"W38","v":324844.53000000003},null,null,{"$f":"Z38","v":352399.01},null,null,{"$f":"AC38","v":352952.66},null,null,{"$f":"AF38","v":352952.66},null,null,{"$f":"AI38","v":352952.66},"AG"]
[null,"Incremental Grossed Up PIL's",null,"Z",{"$f":"E60","v":-16067.289656448975},null,null,{"$f":"H60","v":30055.603933044906},null,null,{"$f":"K60","v":15914.055143695254},null,null,{"$f":"N60","v":-11960.181501113901},null,null,{"$f":"Q60","v":-23370.219338047256},null,null,{"$f":"T60","v":-18551.41829368256},null,null,{"$f":"W60","v":11809.216316971444},null,null,{"$f":"Z60","v":24627.707099698233},null,null,{"$f":"AC60","v":36224.682452360656},null,null,{"$f":"AF60","v":46560.879751227068},null,null,{"$f":"AI60","v":55712.645503888838},"AH"]
[null,"OM&A",null,"D",{"$f":"E43","v":31250.880000000001},null,null,{"$f":"H43","v":44277.59},null,null,{"$f":"K43","v":0},null,null,{"$f":"N43","v":0},null,null,{"$f":"Q43","v":0},null,null,{"$f":"T43","v":0},null,null,{"$f":"W43","v":0},null,null,{"$f":"Z43","v":0},null,null,{"$f":"AC43","v":0},null,null,{"$f":"AF43","v":0},null,null,{"$f":"AI43","v":0}]
[]
[null,"Incremental Revenue Requirement",null,null,{"$f":"SUM(E64:E67)","v":72344.278720427959},null,null,{"$f":"SUM(H64:H67)","v":354981.33355774905},null,null,{"$f":"SUM(K64:K67)","v":328752.56850984989},null,null,{"$f":"SUM(N64:N67)","v":289681.89801865851},null,null,{"$f":"SUM(Q64:Q67)","v":339072.21672482329},null,null,{"$f":"SUM(T64:T67)","v":544058.17254069401},null,null,{"$f":"SUM(W64:W67)","v":771571.47771491297},null,null,{"$f":"SUM(Z64:Z67)","v":824137.03129301732},null,null,{"$f":"SUM(AC64:AC67)","v":816693.23230492882},null,null,{"$f":"SUM(AF64:AF67)","v":806711.34943561745},null,null,{"$f":"SUM(AI64:AI67)","v":795545.03502010112},"AJ = AF + AG + AH + AI"]

{"sheet":"6. True-up Summary","index":5,"n_rows":21,"n_cols":26,"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,2016,null,2017,null,2018,null,2019,null,2020,null,2021,null,2022,null,2023,null,2024,null,2025,null,2026,"Total"]
[]
[null,null,"Deferred and forecasted MIST Meters Revenue Requirement (from Sheet 5)",null,{"$f":"'5. MIST Meters_IRR'!E69","v":72344.278720427959},null,{"$f":"'5. MIST Meters_IRR'!H69","v":354981.33355774905},null,{"$f":"'5. MIST Meters_IRR'!K69","v":328752.56850984989},null,{"$f":"'5. MIST Meters_IRR'!N69","v":289681.89801865851},null,{"$f":"'5. MIST Meters_IRR'!Q69","v":339072.21672482329},null,{"$f":"'5. MIST Meters_IRR'!T69","v":544058.17254069401},null,{"$f":"'5. MIST Meters_IRR'!W69","v":771571.47771491297},null,{"$f":"'5. MIST Meters_IRR'!Z69","v":824137.03129301732},null,{"$f":"'5. MIST Meters_IRR'!AC69","v":816693.23230492882},null,{"$f":"'5. MIST Meters_IRR'!AF69","v":806711.34943561745},null,{"$f":"'5. MIST Meters_IRR'!AI69","v":795545.03502010112},{"$f":"SUM(E14:Y14)","v":5943548.5938407797}]
[]
[]
[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,{"$f":"SUM(E17:Y17)","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},{"$f":"SUM(E19:Y19)","v":0}]
[]
[null,null,"Net Deferred Revenue Requirement",null,{"$f":"E14-E17-E19","v":72344.278720427959},null,{"$f":"G14-G17-G19","v":354981.33355774905},null,{"$f":"I14-I17-I19","v":328752.56850984989},null,{"$f":"K14-K17-K19","v":289681.89801865851},null,{"$f":"M14-M17-M19","v":339072.21672482329},null,{"$f":"O14-O17-O19","v":544058.17254069401},null,{"$f":"Q14-Q17-Q19","v":771571.47771491297},null,{"$f":"S14-S17-S19","v":824137.03129301732},null,{"$f":"U14-U17-U19","v":816693.23230492882},null,{"$f":"W14-W17-W19","v":806711.34943561745},null,{"$f":"Y14-Y17-Y19","v":795545.03502010112},{"$f":"SUM(E21:Y21)","v":5943548.5938407797}]

{"sheet":"Cognos_Office_Connection_Cache","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}