{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["1. Cost of Service_parameters","2.MIST Meters Assets_Rate Base","3. UCC_Calculations","4. Fund Adder Revenues","5. MIST Meters_IRR","6. True-up Summary"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":503,"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":15,"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,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]
[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}]
[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}]
[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]
[]
[null,null,"Cost of Capital Parameters"]
[null,null,null,"Deemed Short-term Debt Rate",null,null,1.6500000000000001E-2,1.6500000000000001E-2,1.6500000000000001E-2,1.6500000000000001E-2,1.6500000000000001E-2,1.6500000000000001E-2,1.6500000000000001E-2,1.6500000000000001E-2,1.6500000000000001E-2]
[null,null,null,"Long-term Debt Rate (actual/embedded/deemed)1",null,null,4.9148168670175442E-2,4.9148168670175442E-2,4.9148168670175442E-2,4.9148168670175442E-2,4.9148168670175442E-2,4.9148168670175442E-2,4.9148168670175442E-2,4.9148168670175442E-2,4.9148168670175442E-2]
[null,null,null,"Target Return on Equity (ROE)",null,null,9.1899999999999996E-2,9.1899999999999996E-2,9.1899999999999996E-2,9.1899999999999996E-2,9.1899999999999996E-2,9.1899999999999996E-2,9.1899999999999996E-2,9.1899999999999996E-2,9.1899999999999996E-2]
[null,null,null,"Return on Preferred Shares"]
[null,null,"WACC",null,null,null,{"$f":"SUMPRODUCT(G14:G17,G21:G24)","v":6.4942974455298258E-2},{"$f":"SUMPRODUCT(H14:H17,H21:H24)","v":6.4942974455298258E-2},{"$f":"SUMPRODUCT(I14:I17,I21:I24)","v":6.4942974455298258E-2},6.4942974455298258E-2,6.4942974455298258E-2,6.4942974455298258E-2,6.4942974455298258E-2,6.4942974455298258E-2,6.4942974455298258E-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]
[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]
[null,null,"Capital Tax (until July 1st, 2010)",null,null,null,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]
[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]
[]
[null,null,null,"Year",1845,null,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]
[]
[null,null,null,"Year",1930,null,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]
[]
[null,null,null,"Year",1835,null,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]
[]
[null,null,null,"Year",1921,null,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]
[]
[null,null,null,"Year",1935,null,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]
[]
[null,null,null,"Year",1926,null,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]
[]
[null,null,null,"Year",1860,null,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]
[]
[null,null,null,"Year",1924,null,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]
[]
[null,null,null,"Year",1850,null,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]
[]
[null,null,null,"Year",1982,null,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]
[]
[null,null,null,"Year",1955,null,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]
[]
[null,"CCA Rates"]
[null,null,null,"CCA Class",1822,null,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]
[]
[null,null,null,"CCA Class",1845,null,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]
[]
[null,null,null,"CCA Class",1930,null,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]
[]
[null,null,null,"CCA Class",1835,null,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]
[]
[null,null,null,"CCA Class",1921,null,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]
[]
[null,null,null,"CCA Class",1935,null,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]
[]
[null,null,null,"CCA Class",1926,null,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]
[]
[null,null,null,"CCA Class",1860,null,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]
[]
[null,null,null,"CCA Class",1924,null,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]
[]
[null,null,null,"CCA Class",1850,null,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]
[]
[null,null,null,"CCA Class",1982,null,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]
[]
[null,null,null,"CCA Class",1955,null,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]
[]
[]
[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":13,"rows_kept":269,"cut":false,"hidden":false,"merged":[[3,3,3,4]]}
[]
[]
[]
[null,null,null,"MIST Meters True-up Model"]
[]
[]
[]
[]
[null,"Sheet 2: 1577 -Net Book Value"]
[null,null,null,null,2018,2019,2020,2021,2022,2023,2024,2025,2026]
[null,"Net Fixed Assets - 1822"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",0,{"$f":"E17","v":162581.57999999999},{"$f":"F17","v":223612.31},272697.88,274016.17,274016.17,380136.14,380136.14,380136.14]
[null,null,null,"Capital Additions during year ",162581.57999999999,61030.73,49085.57,1318.29,0,106119.97]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E14+E15-E16","v":162581.57999999999},{"$f":"F14+F15-F16","v":223612.31},{"$f":"G14+G15-G16","v":272697.88},274016.17,274016.17,380136.14,380136.14,380136.14,380136.14]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",0,{"$f":"E23","v":-5419.3859999999995},{"$f":"F23","v":-16258.157999999999},-31165.645333333334,-49345.504000000001,-67613.248666666666,-85880.993333333332,-111223.40266666666,-136565.81200000001]
[null,null,null,"Amortization expense during year",{"$f":"-E15/'1. Cost of Service_parameters'!G59/2","v":-5419.3859999999995},{"$f":"-F14/'1. Cost of Service_parameters'!H59","v":-10838.771999999999},{"$f":"-G14/'1. Cost of Service_parameters'!I59","v":-14907.487333333333},{"$f":"-H14/'1. Cost of Service_parameters'!J59","v":-18179.858666666667},{"$f":"-I14/'1. Cost of Service_parameters'!K59","v":-18267.744666666666},{"$f":"-J14/'1. Cost of Service_parameters'!L59","v":-18267.744666666666},{"$f":"-K14/'1. Cost of Service_parameters'!M59","v":-25342.409333333333},{"$f":"-L14/'1. Cost of Service_parameters'!N59","v":-25342.409333333333},{"$f":"-M14/'1. Cost of Service_parameters'!O59","v":-25342.409333333333}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E20+E21-E22","v":-5419.3859999999995},{"$f":"F20+F21-F22","v":-16258.157999999999},{"$f":"G20+G21-G22","v":-31165.645333333334},{"$f":"H20+H21-H22","v":-49345.504000000001},{"$f":"I20+I21-I22","v":-67613.248666666666},{"$f":"J20+J21-J22","v":-85880.993333333332},{"$f":"K20+K21-K22","v":-111223.40266666666},{"$f":"L20+L21-L22","v":-136565.81200000001},{"$f":"M20+M21-M22","v":-161908.22133333335}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",{"$f":"E14+E20","v":0},{"$f":"E27","v":157162.19399999999},{"$f":"F27","v":207354.152},241532.23466666666,224670.66599999997,206402.9213333333,294255.14666666667,268912.73733333335,243570.32800000001]
[null,null,null,"Closing Balance",{"$f":"E17+E23","v":157162.19399999999},{"$f":"F17+F23","v":207354.152},{"$f":"G17+G23","v":241532.23466666666},224670.66599999997,206402.9213333333,294255.14666666667,268912.73733333335,243570.32800000001,218227.91866666666]
[null,null,null,"Net Fixed Assets (NFA)",{"$f":"SUM(E26:E27)/2","v":78581.096999999994},{"$f":"AVERAGE(F26:F27)","v":182258.17300000001},{"$f":"AVERAGE(G26:G27)","v":224443.19333333333},233101.45033333331,215536.79366666664,250329.03399999999,281583.94200000004,256241.53266666667,230899.12333333335]
[]
[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]
[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]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,{"$f":"E42","v":0},{"$f":"F42","v":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}]
[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]
[]
[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]
[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]
[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]
[]
[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]
[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]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,{"$f":"E61","v":0},{"$f":"F61","v":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}]
[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]
[]
[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]
[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]
[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]
[]
[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]
[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]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,{"$f":"E80","v":0},{"$f":"F80","v":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}]
[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]
[]
[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]
[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]
[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]
[]
[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]
[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]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,{"$f":"E99","v":0},{"$f":"F99","v":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}]
[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]
[]
[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]
[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]
[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]
[]
[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]
[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]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,{"$f":"E118","v":0},{"$f":"F118","v":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}]
[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]
[]
[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]
[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]
[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]
[]
[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]
[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]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,{"$f":"E137","v":0},{"$f":"F137","v":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}]
[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]
[]
[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]
[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]
[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]
[]
[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]
[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]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,{"$f":"E156","v":0},{"$f":"F156","v":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}]
[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]
[]
[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]
[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]
[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]
[]
[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]
[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]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,{"$f":"E175","v":0},{"$f":"F175","v":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}]
[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]
[]
[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]
[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]
[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]
[]
[]
[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]
[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]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,{"$f":"E195","v":0},{"$f":"F195","v":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}]
[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]
[]
[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]
[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]
[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]
[]
[]
[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]
[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]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,{"$f":"E215","v":0},{"$f":"F215","v":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}]
[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]
[]
[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]
[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]
[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]
[]
[]
[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]
[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]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,{"$f":"E235","v":0},{"$f":"F235","v":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}]
[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]
[]
[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]
[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]
[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]
[]
[]
[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]
[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]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,{"$f":"E255","v":0},{"$f":"F255","v":0},0,0,0,0,0,0]
[null,null,null,"Amortization expense during year",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]
[]
[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]
[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]
[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]
[]
[]
[]
[]
[]
[]
[null,null,null,"Additions",{"$f":"E15+E34+E53+E72+E91+E110+E129+E148+E167+E187+E207+E227+E247","v":162581.57999999999},{"$f":"F15+F34+F53+F72+F91+F110+F129+F148+F167+F187+F207+F227+F247","v":61030.73},49085.57,1318.29,0,106119.97,0,0,0]
[null,null,null,"Net Fixed Assets (NFA)",{"$f":"E28+E47+E66+E85+E104+E123+E142+E161+E180+E200+E220+E240+E260","v":78581.096999999994},{"$f":"F28+F47+F66+F85+F104+F123+F142+F161+F180+F200+F220+F240+F260","v":182258.17300000001},{"$f":"G28+G47+G66+G85+G104+G123+G142+G161+G180+G200+G220+G240+G260","v":224443.19333333333},233101.45033333331,215536.79366666664,250329.03399999999,281583.94200000004,256241.53266666667,230899.12333333335]
[null,null,null,"Total Amortization",{"$f":"E21+E40+E59+E78+E97+E116+E135+E154+E173+E193+E213+E233+E253","v":-5419.3859999999995},{"$f":"F21+F40+F59+F78+F97+F116+F135+F154+F173+F193+F213+F233+F253","v":-10838.771999999999},{"$f":"G21+G40+G59+G78+G97+G116+G135+G154+G173+G193+G213+G233+G253","v":-14907.487333333333},-18179.858666666667,-18267.744666666666,-18267.744666666666,-25342.409333333333,-25342.409333333333,-25342.409333333333]

{"sheet":"3. UCC_Calculations","index":2,"n_rows":88,"n_cols":12,"rows_kept":88,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"MIST Meteres True-up Model"]
[]
[]
[]
[]
[]
["Sheet 3: CCA For PILs Calculation"]
[]
["UCC/Class 47",null,null,2018,2019,2020,2021,2022,2023,2024,2025,2026]
[null,null,null,"Actual","Actual","Actual","Actual","Actual","Actual","Actual","Actual","Actual"]
[]
["Opening UCC",null,null,0,{"$f":"D17-D22","v":156078.3168},{"$f":"E17-E22","v":202181.55225600002},{"$f":"F17-F22","v":233129.17527552001},215744.39965347841,198484.84768120013,284481.23106670409,261722.73258136777,240784.91397485835]
["Capital Additions",null,null,{"$f":"'2.MIST Meters Assets_Rate Base'!E267-D29-D44-D59-D74","v":162581.57999999999},{"$f":"'2.MIST Meters Assets_Rate Base'!F267-E29-E44-E59-E74","v":61030.73},{"$f":"'2.MIST Meters Assets_Rate Base'!G267-F29-F44-F59-F74","v":49085.57},{"$f":"'2.MIST Meters Assets_Rate Base'!H267-G29-G44-G59-G74","v":1318.29},{"$f":"'2.MIST Meters Assets_Rate Base'!I267-H29-H44-H59-H74","v":0},{"$f":"'2.MIST Meters Assets_Rate Base'!J267-I29-I44-I59-I74","v":106119.97},{"$f":"'2.MIST Meters Assets_Rate Base'!K267-J29-J44-J59-J74","v":0},{"$f":"'2.MIST Meters Assets_Rate Base'!L267-K29-K44-K59-K74","v":0},{"$f":"'2.MIST Meters Assets_Rate Base'!M267-L29-L44-L59-L74","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":162581.57999999999},{"$f":"SUM(E14:E15)-E16","v":217109.04680000001},{"$f":"SUM(F14:F15)-F16","v":251267.12225600003},234447.46527552002,215744.39965347841,304604.8176812001,284481.23106670409,261722.73258136777,240784.91397485835]
["Half Year Rule (1/2 Additions - Disposals)",null,null,{"$f":"IF(((D15-D16)/2)<0, 0, (D15-D16)/2)","v":81290.789999999994},{"$f":"IF(((E15-E16)/2)<0, 0, (E15-E16)/2)","v":30515.365000000002},{"$f":"IF(((F15-F16)/2)<0, 0, (F15-F16)/2)","v":24542.785},{"$f":"IF(((G15-G16)/2)<0, 0, (G15-G16)/2)","v":659.14499999999998},0,53059.985000000001,0,0,0]
["Reduced UCC",null,null,{"$f":"D18+D14","v":81290.789999999994},{"$f":"E18+E14","v":186593.68179999999},{"$f":"F18+F14","v":226724.33725600003},{"$f":"G18+G14","v":233788.32027552},215744.39965347841,251544.83268120012,284481.23106670409,261722.73258136777,240784.91397485835]
["CCA Rate Class",null,null,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]
["CCA",null,null,{"$f":"D19*D21","v":6503.2631999999994},{"$f":"E19*E21","v":14927.494543999999},{"$f":"F19*F21","v":18137.946980480003},18703.065622041602,17259.551972278274,20123.586614496009,22758.498485336328,20937.818606509423,19262.793117988669]
["Closing UCC",null,null,{"$f":"IF((D17-D22)<0, 0, D17-D22)","v":156078.3168},{"$f":"IF((E17-E22)<0, 0, E17-E22)","v":202181.55225600002},{"$f":"IF((F17-F22)<0, 0, F17-F22)","v":233129.17527552001},215744.39965347841,198484.84768120013,284481.23106670409,261722.73258136777,240784.91397485835,221522.12085686967]
[]
["UCC/Class 8",null,null,{"$f":"D11","v":2018},2019,{"$f":"F11","v":2020},2021,2022,2023,2024,2025,2026]
[null,null,null,"Actual","Actual",{"$f":"F12","v":"Actual"},"Actual","Actual","Actual","Actual","Actual","Actual"]
[]
["Opening UCC",null,null,0,{"$f":"D31-D36","v":0},{"$f":"E31-E36","v":0},0,0,0,0,0,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}]
["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]
["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]
["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]
["CCA Rate Class",null,null,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]
["CCA",null,null,{"$f":"D35*D33","v":0},{"$f":"E35*E33","v":0},{"$f":"F35*F33","v":0},0,0,0,0,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]
[]
[]
["UCC/Class 10",null,null,2014,2015,2016,2017,2018,2019,2020,2021,2022]
[null,null,null,"Audited Actual","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]
["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}]
["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]
["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]
["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]
["CCA Rate Class",null,null,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]
["CCA",null,null,{"$f":"D50*D48","v":0},{"$f":"E50*E48","v":0},{"$f":"F50*F48","v":0},0,0,0,0,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]
[]
[]
["UCC/Class 50",null,null,2014,2015,2016,2017,2018,2019,2020,2021,2022]
[null,null,null,"Audited Actual","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]
["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}]
["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]
["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]
["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]
["CCA Rate Class",null,null,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]
["CCA",null,null,{"$f":"D65*D63","v":0},{"$f":"E65*E63","v":0},{"$f":"F65*F63","v":0},0,0,0,0,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]
[]
[]
["UCC/Class 12",null,null,2014,2015,2016,2017,2018,2019,2020,2021,2022]
[null,null,null,"Audited Actual","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]
["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}]
["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]
["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]
["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]
["CCA Rate Class",null,null,12,12,12,12,12,12,12,12,12]
["CCA Rate ",null,null,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]
["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]
[]
[]
[]
[null,"Capital Additions",null,{"$f":"SUM(D74,D59,D44,D29,D15)","v":162581.57999999999},{"$f":"SUM(E74,E59,E44,E29,E15)","v":61030.73},{"$f":"SUM(F74,F59,F44,F29,F15)","v":49085.57},1318.29,0,106119.97,0,0,0]
[]
[null,"CCA",null,{"$f":"SUM(D81,D66,D51,D36,D22,)","v":6503.2631999999994},{"$f":"SUM(E81,E66,E51,E36,E22,)","v":14927.494543999999},{"$f":"SUM(F81,F66,F51,F36,F22,)","v":18137.946980480003},18703.065622041602,17259.551972278274,20123.586614496009,22758.498485336328,20937.818606509423,19262.793117988669]

{"sheet":"4. Fund Adder Revenues","index":3,"n_rows":127,"n_cols":14,"rows_kept":127,"cut":false,"hidden":false,"merged":[[10,5,10,14]]}
[]
[]
[]
[null,null,null,null,null,null,null,"MIST Meters True-up Model"]
[]
[]
[]
[]
[null,"Sheet 4: MIST Meters Funding Adder Revenues"]
[]
[]
[]
[]
[null,"Prescribed \nInterest Rates","Approved Deferral and Variance Accounts","CWIP",null,"Date","Year","Quarter",null,"Opening Balance (Principal)","Funding Adder Revenues","Interest Rate","Interest","Principal &\nInterest\n(Cumm.)"]
[]
[null,"2018 Q1",1.4999999999999999E-2,2.9899999999999999E-2,null,"2018-01-01",{"$f":"YEAR(F16)","v":2018},{"$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":"2018 Q1"},0,null,1.4999999999999999E-2,{"$f":"ROUND(J16*L16/12,2)","v":0},{"$f":"K16+M16","v":0}]
[null,"2018 Q2",1.89E-2,3.3500000000000002E-2,null,"2018-02-01",{"$f":"YEAR(F17)","v":2018},{"$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":"2018 Q1"},{"$f":"J16+K16","v":0},null,1.4999999999999999E-2,{"$f":"ROUND(J17*L17/12,2)","v":0},{"$f":"N16+K17+M17","v":0}]
[null,"2018 Q3",1.89E-2,3.3500000000000002E-2,null,"2018-03-01",2018,"Q1","2018 Q1",{"$f":"J17+K17","v":0},null,1.4999999999999999E-2,0,{"$f":"N17+K18+M18","v":0}]
[null,"2018 Q4",2.1700000000000001E-2,3.3500000000000002E-2,null,"2018-04-01",2018,"Q2","2018 Q2",0,null,1.89E-2,0,0]
[null,"2019 Q1",2.4500000000000001E-2,3.8199999999999998E-2,null,"2018-05-01",2018,"Q2","2018 Q2",0,null,1.89E-2,0,0]
[null,"2019 Q2",2.18E-2,3.39E-2,null,"2018-06-01",2018,"Q2","2018 Q2",0,null,1.89E-2,0,0]
[null,"2019 Q3",2.18E-2,2.8799999999999999E-2,null,"2018-07-01",2018,"Q3","2018 Q3",0,null,1.89E-2,0,0]
[null,"2019 Q4",2.18E-2,2.8799999999999999E-2,null,"2018-08-01",2018,"Q3","2018 Q3",0,null,1.89E-2,0,0]
[null,"2020 Q1",2.18E-2,2.8799999999999999E-2,null,"2018-09-01",2018,"Q3","2018 Q3",0,null,1.89E-2,0,0]
[null,"2020 Q2",2.18E-2,2.4799999999999999E-2,null,"2018-10-01",2018,"Q4","2018 Q4",0,null,2.1700000000000001E-2,0,0]
[null,"2020 Q3",5.7000000000000002E-3,2.4799999999999999E-2,null,"2018-11-01",2018,"Q4","2018 Q4",0,null,2.1700000000000001E-2,0,0]
[null,"2020 Q4",5.7000000000000002E-3,2.0299999999999999E-2,null,"2018-12-01",2018,"Q4","2018 Q4",0,null,2.1700000000000001E-2,0,0]
[null,"2021 Q1",5.7000000000000002E-3,2.0299999999999999E-2,null,"2019-01-01",2019,"Q1","2019 Q1",0,null,2.4500000000000001E-2,0,0]
[null,"2021 Q2",5.7000000000000002E-3,2.29E-2,null,"2019-02-01",2019,"Q1","2019 Q1",0,null,2.4500000000000001E-2,0,0]
[null,"2021 Q3",5.7000000000000002E-3,2.29E-2,null,"2019-03-01",2019,"Q1","2019 Q1",0,null,2.4500000000000001E-2,0,0]
[null,"2021 Q4",5.7000000000000002E-3,2.29E-2,null,"2019-04-01",2019,"Q2","2019 Q2",0,null,2.18E-2,0,0]
[null,"2022 Q1",5.7000000000000002E-3,2.7199999999999998E-2,null,"2019-05-01",2019,"Q2","2019 Q2",0,null,2.18E-2,0,0]
[null,"2022 Q2",1.0200000000000001E-2,3.3099999999999997E-2,null,"2019-06-01",2019,"Q2","2019 Q2",0,null,2.18E-2,0,0]
[null,"2022 Q3",2.1999999999999999E-2,4.6600000000000003E-2,null,"2019-07-01",2019,"Q3","2019 Q3",0,null,2.18E-2,0,0]
[null,"2022 Q4",3.8699999999999998E-2,5.0099999999999999E-2,null,"2019-08-01",2019,"Q3","2019 Q3",0,null,2.18E-2,0,0]
[null,"2023 Q1",4.7300000000000002E-2,5.0099999999999999E-2,null,"2019-09-01",2019,"Q3","2019 Q3",0,null,2.18E-2,0,0]
[null,"2023 Q2",4.9799999999999997E-2,5.0099999999999999E-2,null,"2019-10-01",2019,"Q4","2019 Q4",0,null,2.18E-2,0,0]
[null,"2023 Q3",4.9799999999999997E-2,5.0099999999999999E-2,null,"2019-11-01",2019,"Q4","2019 Q4",0,null,2.18E-2,0,0]
[null,"2023 Q4",5.4899999999999997E-2,5.4800000000000001E-2,null,"2019-12-01",2019,"Q4","2019 Q4",0,null,2.18E-2,0,0]
[null,"2024 Q1",5.4899999999999997E-2,5.4800000000000001E-2,null,"2020-01-01",{"$f":"YEAR(F40)","v":2020},{"$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":"2020 Q1"},{"$f":"J39+K39","v":0},null,2.18E-2,{"$f":"ROUND(J40*L40/12,2)","v":0},{"$f":"N39+K40+M40","v":0}]
[null,"2024 Q2",5.4899999999999997E-2,5.9799999999999999E-2,null,"2020-02-01",2020,"Q1","2020 Q1",0,null,2.18E-2,0,0]
[null,"2024 Q3",5.1999999999999998E-2,5.9799999999999999E-2,null,"2020-03-01",2020,"Q1","2020 Q1",0,null,2.18E-2,0,0]
[null,"2024 Q4",4.3999999999999997E-2,4.5499999999999999E-2,null,"2020-04-01",2020,"Q2","2020 Q2",0,null,2.18E-2,0,0]
[null,"2025 Q1",3.6400000000000002E-2,4.2299999999999997E-2,null,"2020-05-01",2020,"Q2","2020 Q2",0,null,2.18E-2,0,0]
[null,"2025 Q2",3.1600000000000003E-2,4.2299999999999997E-2,null,"2020-06-01",2020,"Q2","2020 Q2",0,null,2.18E-2,0,0]
[null,"2025 Q3",2.9100000000000001E-2,4.2299999999999997E-2,null,"2020-07-01",2020,"Q3","2020 Q3",0,null,5.7000000000000002E-3,0,0]
[null,"2025 Q4",2.9100000000000001E-2,4.2299999999999997E-2,null,"2020-08-01",2020,"Q3","2020 Q3",0,null,5.7000000000000002E-3,0,0]
[null,"2026 Q1",2.5499999999999998E-2,4.2299999999999997E-2,null,"2020-09-01",2020,"Q3","2020 Q3",0,null,5.7000000000000002E-3,0,0]
[null,"2026 Q2",2.5499999999999998E-2,4.2299999999999997E-2,null,"2020-10-01",2020,"Q4","2020 Q4",0,null,5.7000000000000002E-3,0,0]
[null,"2026 Q3",2.5499999999999998E-2,4.2299999999999997E-2,null,"2020-11-01",2020,"Q4","2020 Q4",0,null,5.7000000000000002E-3,0,0]
[null,"2026 Q4",2.5499999999999998E-2,4.2299999999999997E-2,null,"2020-12-01",2020,"Q4","2020 Q4",0,null,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2021-01-01",2021,"Q1","2021 Q1",0,null,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2021-02-01",2021,"Q1","2021 Q1",0,null,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2021-03-01",2021,"Q1","2021 Q1",0,null,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2021-04-01",2021,"Q2","2021 Q2",0,null,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2021-05-01",2021,"Q2","2021 Q2",0,null,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2021-06-01",2021,"Q2","2021 Q2",0,null,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2021-07-01",2021,"Q3","2021 Q3",0,null,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2021-08-01",2021,"Q3","2021 Q3",0,null,5.7000000000000002E-3,0,0]
[null,null,null,null,null,"2021-09-01",2021,"Q3","2021 Q3",0,null,5.7000000000000002E-3,0,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,3.6400000000000002E-2,0,0]
[null,null,null,null,null,"2025-02-01",2025,"Q1","2025 Q1",0,null,3.6400000000000002E-2,0,0]
[null,null,null,null,null,"2025-03-01",2025,"Q1","2025 Q1",0,null,3.6400000000000002E-2,0,0]
[null,null,null,null,null,"2025-04-01",2025,"Q2","2025 Q2",0,null,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2025-05-01",{"$f":"YEAR(F104)","v":2025},{"$f":"IF(MONTH(F104)=0,\"\",IF(MONTH(F104)<4,\"Q1\",IF(MONTH(F104)<7,\"Q2\",IF(MONTH(F104)<10,\"Q3\",\"Q4\"))))","v":"Q2"},{"$f":"CONCATENATE(G104,\" \",H104)","v":"2025 Q2"},{"$f":"J103+K103","v":0},null,3.1600000000000003E-2,{"$f":"ROUND(J104*L104/12,2)","v":0},{"$f":"N103+K104+M104","v":0}]
[null,null,null,null,null,"2025-06-01",2025,"Q2","2025 Q2",0,null,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2025-07-01",2025,"Q3","2025 Q3",0,null,2.9100000000000001E-2,0,0]
[null,null,null,null,null,"2025-08-01",2025,"Q3","2025 Q3",0,null,2.9100000000000001E-2,0,0]
[null,null,null,null,null,"2025-09-01",2025,"Q3","2025 Q3",0,null,2.9100000000000001E-2,0,0]
[null,null,null,null,null,"2025-10-01",2025,"Q4","2025 Q4",0,null,2.9100000000000001E-2,0,0]
[null,null,null,null,null,"2025-11-01",2025,"Q4","2025 Q4",0,null,2.9100000000000001E-2,0,0]
[null,null,null,null,null,"2025-12-01",2025,"Q4","2025 Q4",0,null,2.9100000000000001E-2,0,0]
[null,null,null,null,null,"2026-01-01",2026,"Q1","2026 Q1",0,null,2.5499999999999998E-2,0,0]
[null,null,null,null,null,"2026-02-01",2026,"Q1","2026 Q1",0,null,2.5499999999999998E-2,0,0]
[null,null,null,null,null,"2026-03-01",2026,"Q1","2026 Q1",0,null,2.5499999999999998E-2,0,0]
[null,null,null,null,null,"2026-04-01",2026,"Q2","2026 Q2",0,null,2.5499999999999998E-2,0,0]
[null,null,null,null,null,"2026-05-01",2026,"Q2","2026 Q2",0,null,2.5499999999999998E-2,0,0]
[null,null,null,null,null,"2026-06-01",2026,"Q2","2026 Q2",0,null,2.5499999999999998E-2,0,0]
[null,null,null,null,null,"2026-07-01",2026,"Q3","2026 Q3",0,null,2.5499999999999998E-2,0,0]
[null,null,null,null,null,"2026-08-01",2026,"Q3","2026 Q3",0,null,2.5499999999999998E-2,0,0]
[null,null,null,null,null,"2026-09-01",2026,"Q3","2026 Q3",0,null,2.5499999999999998E-2,0,0]
[null,null,null,null,null,"2026-10-01",2026,"Q4","2026 Q4",0,null,2.5499999999999998E-2,0,0]
[null,null,null,null,null,"2026-11-01",2026,"Q4","2026 Q4",0,null,2.5499999999999998E-2,0,0]
[null,null,null,null,null,"2026-12-01",2026,"Q4","2026 Q4",0,null,2.5499999999999998E-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":"K125+M125","v":0}]
[]
[null,"NOTE: Funding adder revenues are up to December 2014 actuals"]

{"sheet":"5. MIST Meters_IRR","index":4,"n_rows":63,"n_cols":36,"rows_kept":63,"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,"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":84000.482999999993},null,null,{"$f":"'2.MIST Meters Assets_Rate Base'!F268-'2.MIST Meters Assets_Rate Base'!F269","v":193096.94500000001},null,null,{"$f":"'2.MIST Meters Assets_Rate Base'!G268-'2.MIST Meters Assets_Rate Base'!G269","v":239350.68066666665},null,null,{"$f":"'2.MIST Meters Assets_Rate Base'!H268-'2.MIST Meters Assets_Rate Base'!H269","v":251281.30899999998},null,null,{"$f":"'2.MIST Meters Assets_Rate Base'!I268-'2.MIST Meters Assets_Rate Base'!I269","v":233804.5383333333},null,null,{"$f":"'2.MIST Meters Assets_Rate Base'!J268-'2.MIST Meters Assets_Rate Base'!J269","v":268596.77866666665},null,null,{"$f":"'2.MIST Meters Assets_Rate Base'!K268-'2.MIST Meters Assets_Rate Base'!K269","v":306926.35133333335},null,null,{"$f":"'2.MIST Meters Assets_Rate Base'!L268-'2.MIST Meters Assets_Rate Base'!L269","v":281583.94199999998},null,null,{"$f":"'2.MIST Meters Assets_Rate Base'!M268-'2.MIST Meters Assets_Rate Base'!M269","v":256241.5326666667},"B"]
[null,"Depreciation Expense",null,null,{"$f":"-'2.MIST Meters Assets_Rate Base'!E269","v":5419.3859999999995},null,null,{"$f":"-'2.MIST Meters Assets_Rate Base'!F269","v":10838.771999999999},null,null,{"$f":"-'2.MIST Meters Assets_Rate Base'!G269","v":14907.487333333333},null,null,{"$f":"-'2.MIST Meters Assets_Rate Base'!H269","v":18179.858666666667},null,null,{"$f":"-'2.MIST Meters Assets_Rate Base'!I269","v":18267.744666666666},null,null,{"$f":"-'2.MIST Meters Assets_Rate Base'!J269","v":18267.744666666666},null,null,{"$f":"-'2.MIST Meters Assets_Rate Base'!K269","v":25342.409333333333},null,null,{"$f":"-'2.MIST Meters Assets_Rate Base'!L269","v":25342.409333333333},null,null,{"$f":"-'2.MIST Meters Assets_Rate Base'!M269","v":25342.409333333333},"C"]
[null,"Net Fixed Assets to be included in Rate Base",null,null,{"$f":"E15-E16","v":78581.096999999994},null,null,{"$f":"H15-H16","v":182258.17300000001},null,null,{"$f":"K15-K16","v":224443.19333333333},null,null,{"$f":"N15-N16","v":233101.45033333331},null,null,{"$f":"Q15-Q16","v":215536.79366666664},null,null,{"$f":"T15-T16","v":250329.03399999999},null,null,{"$f":"W15-W16","v":281583.94200000004},null,null,{"$f":"Z15-Z16","v":256241.53266666664},null,null,{"$f":"AC15-AC16","v":230899.12333333335},"D = B - C"]
[]
[null,"Deemed ShortTerm Debt %",{"$f":"'1. Cost of Service_parameters'!G14","v":0.04},"E",{"$f":"E17*C19","v":3143.24388},{"$f":"'1. Cost of Service_parameters'!H14","v":0.04},null,{"$f":"H17*F19","v":7290.3269200000004},{"$f":"'1. Cost of Service_parameters'!I14","v":0.04},null,{"$f":"K17*I19","v":8977.7277333333332},{"$f":"'1. Cost of Service_parameters'!J14","v":0.04},null,{"$f":"N17*L19","v":9324.0580133333333},{"$f":"'1. Cost of Service_parameters'!K14","v":0.04},null,{"$f":"Q17*O19","v":8621.4717466666661},{"$f":"'1. Cost of Service_parameters'!L14","v":0.04},null,{"$f":"T17*R19","v":10013.16136},{"$f":"'1. Cost of Service_parameters'!M14","v":0.04},null,{"$f":"W17*U19","v":11263.357680000001},{"$f":"'1. Cost of Service_parameters'!N14","v":0.04},null,{"$f":"Z17*X19","v":10249.661306666665},{"$f":"'1. Cost of Service_parameters'!O14","v":0.04},null,{"$f":"AC17*AA19","v":9235.9649333333346},"G = D * E"]
[null,"Deemed Long Term Debt %",{"$f":"'1. Cost of Service_parameters'!G15","v":0.55999999999999994},"F",{"$f":"E17*C20","v":44005.414319999989},{"$f":"'1. Cost of Service_parameters'!H15","v":0.55999999999999994},null,{"$f":"H17*F20","v":102064.57687999999},{"$f":"'1. Cost of Service_parameters'!I15","v":0.55999999999999994},null,{"$f":"K17*I20","v":125688.18826666665},{"$f":"'1. Cost of Service_parameters'!J15","v":0.55999999999999994},null,{"$f":"N17*L20","v":130536.81218666665},{"$f":"'1. Cost of Service_parameters'!K15","v":0.55999999999999994},null,{"$f":"Q17*O20","v":120700.6044533333},{"$f":"'1. Cost of Service_parameters'!L15","v":0.55999999999999994},null,{"$f":"T17*R20","v":140184.25903999998},{"$f":"'1. Cost of Service_parameters'!M15","v":0.55999999999999994},null,{"$f":"W17*U20","v":157687.00752000001},{"$f":"'1. Cost of Service_parameters'!N15","v":0.55999999999999994},null,{"$f":"Z17*X20","v":143495.25829333329},{"$f":"'1. Cost of Service_parameters'!O15","v":0.55999999999999994},null,{"$f":"AC17*AA20","v":129303.50906666667},"H = D * F"]
[]
[null,"Short Term Interest",{"$f":"'1. Cost of Service_parameters'!G21","v":1.6500000000000001E-2},"I",{"$f":"E19*C22","v":51.86352402},{"$f":"'1. Cost of Service_parameters'!H21","v":1.6500000000000001E-2},null,{"$f":"H19*F22","v":120.29039418000001},{"$f":"'1. Cost of Service_parameters'!I21","v":1.6500000000000001E-2},null,{"$f":"K19*I22","v":148.1325076},{"$f":"'1. Cost of Service_parameters'!J21","v":1.6500000000000001E-2},null,{"$f":"N19*L22","v":153.84695722000001},{"$f":"'1. Cost of Service_parameters'!K21","v":1.6500000000000001E-2},null,{"$f":"Q19*O22","v":142.25428382000001},{"$f":"'1. Cost of Service_parameters'!L21","v":1.6500000000000001E-2},null,{"$f":"T19*R22","v":165.21716244000001},{"$f":"'1. Cost of Service_parameters'!M21","v":1.6500000000000001E-2},null,{"$f":"W19*U22","v":185.84540172000001},{"$f":"'1. Cost of Service_parameters'!N21","v":1.6500000000000001E-2},null,{"$f":"Z19*X22","v":169.11941155999997},{"$f":"'1. Cost of Service_parameters'!O21","v":1.6500000000000001E-2},null,{"$f":"AC19*AA22","v":152.39342140000002},"K = G * I"]
[null,"Long Term Interest",{"$f":"'1. Cost of Service_parameters'!G22","v":4.9148168670175442E-2},"J",{"$f":"E20*C23","v":2162.7855254003134},{"$f":"'1. Cost of Service_parameters'!H22","v":4.9148168670175442E-2},null,{"$f":"H20*F23","v":5016.2870397483284},{"$f":"'1. Cost of Service_parameters'!I22","v":4.9148168670175442E-2},null,{"$f":"K20*I23","v":6177.3442767788983},{"$f":"'1. Cost of Service_parameters'!J22","v":4.9148168670175442E-2},null,{"$f":"N20*L23","v":6415.6452630173053},{"$f":"'1. Cost of Service_parameters'!K22","v":4.9148168670175442E-2},null,{"$f":"Q20*O23","v":5932.2136662645544},{"$f":"'1. Cost of Service_parameters'!L22","v":4.9148168670175442E-2},null,{"$f":"T20*R23","v":6889.7996082014852},{"$f":"'1. Cost of Service_parameters'!M22","v":4.9148168670175442E-2},null,{"$f":"W20*U23","v":7750.0276426881837},{"$f":"'1. Cost of Service_parameters'!N22","v":4.9148168670175442E-2},null,{"$f":"Z20*X23","v":7052.5291579711356},{"$f":"'1. Cost of Service_parameters'!O22","v":4.9148168670175442E-2},null,{"$f":"AC20*AA23","v":6355.030673254093},"L = H * J"]
[]
[null,"Return on Rate Base - Interest",null,null,{"$f":"SUM(E22:E23)","v":2214.6490494203135},null,null,{"$f":"SUM(H22:H23)","v":5136.577433928328},null,null,{"$f":"SUM(K22:K23)","v":6325.4767843788986},null,null,{"$f":"SUM(N22:N23)","v":6569.4922202373054},null,null,{"$f":"SUM(Q22:Q23)","v":6074.4679500845541},null,null,{"$f":"SUM(T22:T23)","v":7055.016770641485},null,null,{"$f":"SUM(W22:W23)","v":7935.8730444081839},null,null,{"$f":"SUM(Z22:Z23)","v":7221.6485695311358},null,null,{"$f":"SUM(AC22:AC23)","v":6507.4240946540931},"M = K + L"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aaa"]
[null,"Deemed Equity %",{"$f":"'1. Cost of Service_parameters'!G16","v":0.40000000000000008},"N",{"$f":"E17*C28","v":31432.438800000004},{"$f":"'1. Cost of Service_parameters'!H16","v":0.40000000000000008},null,{"$f":"H17*F28","v":72903.269200000024},{"$f":"'1. Cost of Service_parameters'!I16","v":0.40000000000000008},null,{"$f":"K17*I28","v":89777.277333333346},{"$f":"'1. Cost of Service_parameters'!J16","v":0.40000000000000008},null,{"$f":"N17*L28","v":93240.580133333337},{"$f":"'1. Cost of Service_parameters'!K16","v":0.40000000000000008},null,{"$f":"Q17*O28","v":86214.717466666669},{"$f":"'1. Cost of Service_parameters'!L16","v":0.40000000000000008},null,{"$f":"T17*R28","v":100131.61360000001},{"$f":"'1. Cost of Service_parameters'!M16","v":0.40000000000000008},null,{"$f":"W17*U28","v":112633.57680000004},{"$f":"'1. Cost of Service_parameters'!N16","v":0.40000000000000008},null,{"$f":"Z17*X28","v":102496.61306666667},{"$f":"'1. Cost of Service_parameters'!O16","v":0.40000000000000008},null,{"$f":"AC17*AA28","v":92359.649333333364},"P = D * N"]
[]
[null,"Return on Rate Base -Equity",{"$f":"'1. Cost of Service_parameters'!G23","v":9.1899999999999996E-2},"O",{"$f":"E28*C30","v":2888.6411257200002},{"$f":"'1. Cost of Service_parameters'!H23","v":9.1899999999999996E-2},null,{"$f":"H28*F30","v":6699.8104394800021},{"$f":"'1. Cost of Service_parameters'!I23","v":9.1899999999999996E-2},null,{"$f":"K28*I30","v":8250.5317869333339},{"$f":"'1. Cost of Service_parameters'!J23","v":9.1899999999999996E-2},null,{"$f":"N28*L30","v":8568.8093142533326},{"$f":"'1. Cost of Service_parameters'!K23","v":9.1899999999999996E-2},null,{"$f":"Q28*O30","v":7923.1325351866662},{"$f":"'1. Cost of Service_parameters'!L23","v":9.1899999999999996E-2},null,{"$f":"T28*R30","v":9202.095289840001},{"$f":"'1. Cost of Service_parameters'!M23","v":9.1899999999999996E-2},null,{"$f":"W28*U30","v":10351.025707920004},{"$f":"'1. Cost of Service_parameters'!N23","v":9.1899999999999996E-2},null,{"$f":"Z28*X30","v":9419.4387408266666},{"$f":"'1. Cost of Service_parameters'!O23","v":9.1899999999999996E-2},null,{"$f":"AC28*AA30","v":8487.851773733335},"Q = P * O"]
[]
[null,"Return on Rate Base - Total",null,null,{"$f":"E25+E30","v":5103.2901751403133},null,null,{"$f":"H25+H30","v":11836.38787340833},null,null,{"$f":"K25+K30","v":14576.008571312232},null,null,{"$f":"N25+N30","v":15138.301534490638},null,null,{"$f":"Q25+Q30","v":13997.600485271221},null,null,{"$f":"T25+T30","v":16257.112060481486},null,null,{"$f":"W25+W30","v":18286.898752328187},null,null,{"$f":"Z25+Z30","v":16641.087310357801},null,null,{"$f":"AC25+AC30","v":14995.275868387427},"R = M + Q"]
[]
[]
[]
[null,"Amortization Expense"]
[]
[null,"Amortization Expense - Incremental",null,"C",{"$f":"E16","v":5419.3859999999995},null,null,{"$f":"H16","v":10838.771999999999},null,null,{"$f":"K16","v":14907.487333333333},null,null,{"$f":"N16","v":18179.858666666667},null,null,{"$f":"Q16","v":18267.744666666666},null,null,{"$f":"T16","v":18267.744666666666},null,null,{"$f":"W16","v":25342.409333333333},null,null,{"$f":"Z16","v":25342.409333333333},null,null,{"$f":"AC16","v":25342.409333333333},"S"]
[]
[]
[null,"Grossed up PIL's"]
[]
[null,"Regulatory Taxable Income",null,"O",{"$f":"E30","v":2888.6411257200002},null,null,{"$f":"H30","v":6699.8104394800021},null,null,{"$f":"K30","v":8250.5317869333339},null,null,{"$f":"N30","v":8568.8093142533326},null,null,{"$f":"Q30","v":7923.1325351866662},null,null,{"$f":"T30","v":9202.095289840001},null,null,{"$f":"W30","v":10351.025707920004},null,null,{"$f":"Z30","v":9419.4387408266666},null,null,{"$f":"AC30","v":8487.851773733335},"T "]
[]
[null,"Add Back Amortization Expense",null,"S",{"$f":"E38","v":5419.3859999999995},null,null,{"$f":"H38","v":10838.771999999999},null,null,{"$f":"K38","v":14907.487333333333},null,null,{"$f":"N38","v":18179.858666666667},null,null,{"$f":"Q38","v":18267.744666666666},null,null,{"$f":"T38","v":18267.744666666666},null,null,{"$f":"W38","v":25342.409333333333},null,null,{"$f":"Z38","v":25342.409333333333},null,null,{"$f":"AC38","v":25342.409333333333},"U"]
[]
[null,"Deduct CCA",null,null,{"$f":"'3. UCC_Calculations'!D88","v":6503.2631999999994},null,null,{"$f":"'3. UCC_Calculations'!E88","v":14927.494543999999},null,null,{"$f":"'3. UCC_Calculations'!H88","v":17259.551972278274},null,null,{"$f":"'3. UCC_Calculations'!K88","v":20937.818606509423},null,null,{"$f":"'3. UCC_Calculations'!N88","v":0},null,null,{"$f":"'3. UCC_Calculations'!Q88","v":0},null,null,{"$f":"'3. UCC_Calculations'!T88","v":0},null,null,{"$f":"'3. UCC_Calculations'!W88","v":0},null,null,{"$f":"'3. UCC_Calculations'!Z88","v":0},"V"]
[]
[null,"Incremental Taxable Income",null,null,{"$f":"E43+E45-E47","v":1804.7639257200008},null,null,{"$f":"H43+H45-H47","v":2611.087895480001},null,null,{"$f":"K43+K45-K47","v":5898.4671479883946},null,null,{"$f":"N43+N45-N47","v":5810.8493744105763},null,null,{"$f":"Q43+Q45-Q47","v":26190.877201853331},null,null,{"$f":"T43+T45-T47","v":27469.839956506665},null,null,{"$f":"W43+W45-W47","v":35693.435041253339},null,null,{"$f":"Z43+Z45-Z47","v":34761.84807416},null,null,{"$f":"AC43+AC45-AC47","v":33830.261107066668},"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,"PIL's Before Gross Up",null,null,{"$f":"E49*C51","v":478.26244031580023},null,null,{"$f":"H49*F51","v":691.93829230220024},null,null,{"$f":"K49*I51","v":1563.0937942169246},null,null,{"$f":"N49*L51","v":1539.8750842188028},null,null,{"$f":"Q49*O51","v":6940.5824584911334},null,null,{"$f":"T49*R51","v":7279.5075884742664},null,null,{"$f":"W49*U51","v":9458.760285932136},null,null,{"$f":"Z49*X51","v":9211.8897396524007},null,null,{"$f":"AC49*AA51","v":8965.0191933726674},"Y = W * X"]
[]
[null,"Incremental Grossed Up PIL's",null,null,{"$f":"E53/(1-C51)","v":650.69719770857171},null,null,{"$f":"H53/(1-F51)","v":941.41264258802755},null,null,{"$f":"K53/(1-I51)","v":2126.6582234243874},null,null,{"$f":"N53/(1-L51)","v":2095.0681417942897},null,null,{"$f":"Q53/(1-O51)","v":9442.9693312804538},null,null,{"$f":"T53/(1-R51)","v":9904.0919571078448},null,null,{"$f":"W53/(1-U51)","v":12869.061613513109},null,null,{"$f":"Z53/(1-X51)","v":12533.183319254968},null,null,{"$f":"AC53/(1-AA51)","v":12197.305024996827},"Z = Y / ( 1 - X ) "]
[]
[]
[null,"Incremental Revenue Requirement"]
[null,"Return on Rate Base - Total",null,"Q",{"$f":"E32","v":5103.2901751403133},null,null,{"$f":"H32","v":11836.38787340833},null,null,{"$f":"K32","v":14576.008571312232},null,null,{"$f":"N32","v":15138.301534490638},null,null,{"$f":"Q32","v":13997.600485271221},null,null,{"$f":"T32","v":16257.112060481486},null,null,{"$f":"W32","v":18286.898752328187},null,null,{"$f":"Z32","v":16641.087310357801},null,null,{"$f":"AC32","v":14995.275868387427},"AF"]
[null,"Amortization Expense - Total",null,"S",{"$f":"E38","v":5419.3859999999995},null,null,{"$f":"H38","v":10838.771999999999},null,null,{"$f":"K38","v":14907.487333333333},null,null,{"$f":"N38","v":18179.858666666667},null,null,{"$f":"Q38","v":18267.744666666666},null,null,{"$f":"T38","v":18267.744666666666},null,null,{"$f":"W38","v":25342.409333333333},null,null,{"$f":"Z38","v":25342.409333333333},null,null,{"$f":"AC38","v":25342.409333333333},"AG"]
[null,"Incremental Grossed Up PIL's",null,"Z",{"$f":"E55","v":650.69719770857171},null,null,{"$f":"H55","v":941.41264258802755},null,null,{"$f":"K55","v":2126.6582234243874},null,null,{"$f":"N55","v":2095.0681417942897},null,null,{"$f":"Q55","v":9442.9693312804538},null,null,{"$f":"T55","v":9904.0919571078448},null,null,{"$f":"W55","v":12869.061613513109},null,null,{"$f":"Z55","v":12533.183319254968},null,null,{"$f":"AC55","v":12197.305024996827},"AH"]
[]
[null,"Incremental Revenue Requirement",null,null,{"$f":"SUM(E59:E61)","v":11173.373372848886},null,null,{"$f":"SUM(H59:H61)","v":23616.572515996359},null,null,{"$f":"SUM(K59:K61)","v":31610.154128069949},null,null,{"$f":"SUM(N59:N61)","v":35413.228342951596},null,null,{"$f":"SUM(Q59:Q61)","v":41708.314483218339},null,null,{"$f":"SUM(T59:T61)","v":44428.948684256},null,null,{"$f":"SUM(W59:W61)","v":56498.369699174626},null,null,{"$f":"SUM(Z59:Z61)","v":54516.679962946102},null,null,{"$f":"SUM(AC59:AC61)","v":52534.990226717586},"AJ = AF + AG + AH + AI"]

{"sheet":"6. True-up Summary","index":5,"n_rows":21,"n_cols":23,"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,2018,null,2019,null,2020,null,2021,null,2022,null,2023,null,2024,null,2025,null,2026,null,"Total"]
[]
[null,null,"Deferred and forecasted MIST Meters Revenue Requirement (from Sheet 5)",null,{"$f":"'5. MIST Meters_IRR'!E63","v":11173.373372848886},null,{"$f":"'5. MIST Meters_IRR'!H63","v":23616.572515996359},null,{"$f":"'5. MIST Meters_IRR'!K63","v":31610.154128069949},null,{"$f":"'5. MIST Meters_IRR'!N63","v":35413.228342951596},null,{"$f":"'5. MIST Meters_IRR'!Q63","v":41708.314483218339},null,{"$f":"'5. MIST Meters_IRR'!T63","v":44428.948684256},null,{"$f":"'5. MIST Meters_IRR'!W63","v":56498.369699174626},null,{"$f":"'5. MIST Meters_IRR'!Z63","v":54516.679962946102},null,{"$f":"'5. MIST Meters_IRR'!AC63","v":52534.990226717586},null,{"$f":"SUM(E14:U14)","v":351500.63141617947}]
[]
[]
[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,{"$f":"SUM(E17:G17)","v":0}]
[]
[null,null,"MIST Meters Funding Adder Interest (from Sheet 4)",null,{"$f":"SUM('4. Fund Adder Revenues'!M19:M27)","v":0},null,{"$f":"SUM('4. Fund Adder Revenues'!M28:M39)","v":0},null,{"$f":"SUM('4. Fund Adder Revenues'!O28:O39)","v":0},null,{"$f":"SUM('4. Fund Adder Revenues'!Q28:Q39)","v":0},null,{"$f":"SUM('4. Fund Adder Revenues'!S28:S39)","v":0},null,{"$f":"SUM('4. Fund Adder Revenues'!U28:U39)","v":0},null,{"$f":"SUM('4. Fund Adder Revenues'!W28:W39)","v":0},null,{"$f":"SUM('4. Fund Adder Revenues'!Y28:Y39)","v":0},null,{"$f":"SUM('4. Fund Adder Revenues'!AA28:AA39)","v":0},null,{"$f":"SUM(E19:G19)","v":0}]
[]
[null,null,"Net Deferred Revenue Requirement",null,{"$f":"E14-E17-E19","v":11173.373372848886},null,{"$f":"G14-G17-G19","v":23616.572515996359},null,{"$f":"I14-I17-I19","v":31610.154128069949},null,{"$f":"K14-K17-K19","v":35413.228342951596},null,{"$f":"M14-M17-M19","v":41708.314483218339},null,{"$f":"O14-O17-O19","v":44428.948684256},null,{"$f":"Q14-Q17-Q19","v":56498.369699174626},null,{"$f":"S14-S17-S19","v":54516.679962946102},null,{"$f":"U14-U17-U19","v":52534.990226717586},null,{"$f":"SUM(E21:U21)","v":351500.63141617947}]