{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["4. Smart Meter Rev & Adder","5. Clearing Actual","6. Adder Recovery","7A.  Smart Meter Rate Calc","8A. PILs","9A. SM Avg Nt Fix Ass &UCC","10. 2007A Smart Meter Rate Calc","11. 2007A PILs","12. 2007A SM Nt Fix Ass &UCC","16. Carry Cost Required to May ","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":3369,"comments":2,"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":"4. Smart Meter Rev & Adder","index":0,"n_rows":66,"n_cols":9,"rows_kept":66,"cut":false,"hidden":true,"merged":[[42,6,42,8],[0,0,0,6],[1,0,1,6],[3,6,3,8],[20,6,20,8]]}
["Smart Meter Revenue Requirement & Proposed Rates- Summary "]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["Summary of Actual Costs claimed in this application","2006 Actual","2006 Plus","2007 Actual","Total Actual",null,"Perm Adjust"]
["Capital Costs (must be installed, and used and useful)",null,null,null,null,null,2006,2007,"Total"]
["Smart Meters",{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!C13","v":{"$error":"#REF!"}},null,{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!C13","v":{"$error":"#REF!"}},{"$f":"SUM(B6:D6)","v":{"$error":"#REF!"}},null,{"$f":"B6","v":{"$error":"#REF!"}},{"$f":"D6","v":{"$error":"#REF!"}},{"$f":"H6","v":{"$error":"#REF!"}}]
["Computer Hardware",{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!C27","v":{"$error":"#REF!"}},null,{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!C27","v":{"$error":"#REF!"}},{"$f":"SUM(B7:D7)","v":{"$error":"#REF!"}},null,{"$f":"B7","v":{"$error":"#REF!"}},{"$f":"D7","v":{"$error":"#REF!"}},{"$f":"H7","v":{"$error":"#REF!"}}]
["Computer Software",{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!C41","v":{"$error":"#REF!"}},null,{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!C41","v":{"$error":"#REF!"}},{"$f":"SUM(B8:D8)","v":{"$error":"#REF!"}},null,{"$f":"B8","v":{"$error":"#REF!"}},{"$f":"D8","v":{"$error":"#REF!"}},{"$f":"H8","v":{"$error":"#REF!"}}]
["Tools & Equipment",{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!C56","v":{"$error":"#REF!"}},null,{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!C56","v":{"$error":"#REF!"}},{"$f":"SUM(B9:D9)","v":{"$error":"#REF!"}},null,{"$f":"B9","v":{"$error":"#REF!"}},{"$f":"D9","v":{"$error":"#REF!"}},{"$f":"H9","v":{"$error":"#REF!"}}]
["Other Equipment (please specify)",{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!C70","v":{"$error":"#REF!"}},null,{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!C70","v":{"$error":"#REF!"}},0,null,{"$f":"B10","v":{"$error":"#REF!"}},{"$f":"D10","v":{"$error":"#REF!"}},{"$f":"H10","v":{"$error":"#REF!"}}]
["Total Capital Costs",{"$f":"SUM(B6:B10)","v":{"$error":"#REF!"}},null,{"$f":"SUM(D6:D10)","v":{"$error":"#REF!"}},{"$f":"SUM(E6:E10)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G6:G10)","v":{"$error":"#REF!"}},{"$f":"SUM(H6:H10)","v":{"$error":"#REF!"}},{"$f":"SUM(I6:I10)","v":{"$error":"#REF!"}}]
[]
["O M & A"]
["2.1 Advanced metering communication device (AMCD)",{"$f":"#REF!","v":{"$error":"#REF!"}},null,0,{"$f":"SUM(B14:D14)","v":{"$error":"#REF!"}}]
["2.2 Advanced metering regional collector (AMRC) (includes LAN)",{"$f":"#REF!","v":{"$error":"#REF!"}},null,0,{"$f":"SUM(B15:D15)","v":{"$error":"#REF!"}}]
["2.3 Advanced metering control computer (AMCC)",{"$f":"#REF!","v":{"$error":"#REF!"}},null,0,{"$f":"SUM(B16:D16)","v":{"$error":"#REF!"}}]
["2.4 Wide area network (WAN)",{"$f":"#REF!","v":{"$error":"#REF!"}},null,0,{"$f":"SUM(B17:D17)","v":{"$error":"#REF!"}}]
["2.5 Other AMI OM&A costs related to minimum functionality",{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(B18:D18)","v":{"$error":"#REF!"}}]
["Total O M & A Costs",{"$f":"SUM(B14:B18)","v":{"$error":"#REF!"}},null,{"$f":"SUM(D14:D18)","v":{"$error":"#REF!"}},{"$f":"SUM(E14:E18)","v":{"$error":"#REF!"}}]
[]
["Summary of Revenue Requirement Calculation","2006 Actual","2006 Plus","2007 Actual","Total Actual",null,"Perm Adjust"]
["Net Fixed Assets",null,null,null,null,null,2006,2007,"Total"]
["Net Fixed Assets Beginning of Year",{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!C20,'9A. SM Avg Nt Fix Ass &UCC'!C34,'9A. SM Avg Nt Fix Ass &UCC'!C48,'9A. SM Avg Nt Fix Ass &UCC'!C63,'9A. SM Avg Nt Fix Ass &UCC'!C77)","v":0},{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!C20,'9A. SM Avg Nt Fix Ass &UCC'!C34,'9A. SM Avg Nt Fix Ass &UCC'!C48,'9A. SM Avg Nt Fix Ass &UCC'!C63,'9A. SM Avg Nt Fix Ass &UCC'!C77,)","v":0},{"$f":"SUM('12. 2007A SM Nt Fix Ass &UCC'!C20,'12. 2007A SM Nt Fix Ass &UCC'!C34,'12. 2007A SM Nt Fix Ass &UCC'!C48,'12. 2007A SM Nt Fix Ass &UCC'!C63,'12. 2007A SM Nt Fix Ass &UCC'!C77)","v":0},null,null,{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!C20,'9A. SM Avg Nt Fix Ass &UCC'!C34,'9A. SM Avg Nt Fix Ass &UCC'!C48,'9A. SM Avg Nt Fix Ass &UCC'!C63,'9A. SM Avg Nt Fix Ass &UCC'!C77,)","v":0},{"$f":"SUM('12. 2007A SM Nt Fix Ass &UCC'!C20,'12. 2007A SM Nt Fix Ass &UCC'!C34,'12. 2007A SM Nt Fix Ass &UCC'!C48,'12. 2007A SM Nt Fix Ass &UCC'!C63,'12. 2007A SM Nt Fix Ass &UCC'!C77)","v":0},{"$f":"SUM(G23:H23)","v":0}]
["Net Fixed Assets End of Year",{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!C21,'9A. SM Avg Nt Fix Ass &UCC'!C35,'9A. SM Avg Nt Fix Ass &UCC'!C49,'9A. SM Avg Nt Fix Ass &UCC'!C64,'9A. SM Avg Nt Fix Ass &UCC'!C78)","v":{"$error":"#REF!"}},{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!C21,'9A. SM Avg Nt Fix Ass &UCC'!C35,'9A. SM Avg Nt Fix Ass &UCC'!C49,'9A. SM Avg Nt Fix Ass &UCC'!C64,'9A. SM Avg Nt Fix Ass &UCC'!C78)","v":{"$error":"#REF!"}},{"$f":"SUM('12. 2007A SM Nt Fix Ass &UCC'!C21,'12. 2007A SM Nt Fix Ass &UCC'!C35,'12. 2007A SM Nt Fix Ass &UCC'!C49,'12. 2007A SM Nt Fix Ass &UCC'!C64,'12. 2007A SM Nt Fix Ass &UCC'!C78)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!C21,'9A. SM Avg Nt Fix Ass &UCC'!C35,'9A. SM Avg Nt Fix Ass &UCC'!C49,'9A. SM Avg Nt Fix Ass &UCC'!C64,'9A. SM Avg Nt Fix Ass &UCC'!C78,)","v":{"$error":"#REF!"}},{"$f":"SUM('12. 2007A SM Nt Fix Ass &UCC'!C21,'12. 2007A SM Nt Fix Ass &UCC'!C35,'12. 2007A SM Nt Fix Ass &UCC'!C49,'12. 2007A SM Nt Fix Ass &UCC'!C64,'12. 2007A SM Nt Fix Ass &UCC'!C78)","v":{"$error":"#REF!"}},{"$f":"SUM(G24:H24)","v":{"$error":"#REF!"}}]
["Average Net Fixed Asset Values",{"$f":"(B23+B24)/2","v":{"$error":"#REF!"}},{"$f":"(C23+C24)/2","v":{"$error":"#REF!"}},{"$f":"(D23+D24)/2","v":{"$error":"#REF!"}},null,null,{"$f":"(G23+G24)/2","v":{"$error":"#REF!"}},{"$f":"(H23+H24)/2","v":{"$error":"#REF!"}},{"$f":"(I23+I24)/2","v":{"$error":"#REF!"}}]
[]
["Working Capital Allowance"]
["Operation Expense",{"$f":"B19","v":{"$error":"#REF!"}},{"$f":"C19","v":0},{"$f":"D19","v":{"$error":"#REF!"}},null,null,{"$f":"G19","v":0},{"$f":"H19","v":0},{"$f":"SUM(G28:H28)","v":0}]
[{"$f":"\"Working Capital Allowance \" &#REF!* 100 &\"% (from approved 2006 EDR application)\"","v":{"$error":"#REF!"}},{"$f":"B28*#REF!","v":{"$error":"#REF!"}},{"$f":"C28*#REF!","v":{"$error":"#REF!"}},{"$f":"D28*#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"G28*#REF!","v":{"$error":"#REF!"}},{"$f":"H28*#REF!","v":{"$error":"#REF!"}},{"$f":"I28*#REF!","v":{"$error":"#REF!"}}]
[]
["Smart Meters Rate Base",{"$f":"B25+B29","v":{"$error":"#REF!"}},{"$f":"C25+C29","v":{"$error":"#REF!"}},{"$f":"D25+D29","v":{"$error":"#REF!"}},null,null,{"$f":"G25+G29","v":{"$error":"#REF!"}},{"$f":"H25+H29","v":{"$error":"#REF!"}},{"$f":"I25+I29","v":{"$error":"#REF!"}}]
[]
["Return on Rate Base"]
[{"$f":"\"Deemed Debt  \" &#REF! * 100& \"%  Times Weighted Debt Rate \" &#REF!*100 & \"%\"","v":{"$error":"#REF!"}},{"$f":"B31*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"C31*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"D31*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(B34:D34)","v":{"$error":"#REF!"}},null,{"$f":"G31*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"H31*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"I31*#REF!*#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Deemed Equity \"&#REF!*100&\"%  Times ROE \"&#REF!*100&\"%\"","v":{"$error":"#REF!"}},{"$f":"B31*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"C31*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"D31*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(B35:D35)","v":{"$error":"#REF!"}},null,{"$f":"G31*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"H31*#REF!*#REF!","v":{"$error":"#REF!"}},{"$f":"I31*#REF!*#REF!","v":{"$error":"#REF!"}}]
["Return on Rate Base",{"$f":"SUM(B34:B35)","v":{"$error":"#REF!"}},{"$f":"SUM(C34:C35)","v":{"$error":"#REF!"}},{"$f":"SUM(D34:D35)","v":{"$error":"#REF!"}},{"$f":"SUM(E34:E35)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G34:G35)","v":{"$error":"#REF!"}},{"$f":"SUM(H34:H35)","v":{"$error":"#REF!"}},{"$f":"SUM(I34:I35)","v":{"$error":"#REF!"}}]
[]
["Operating Expenses"]
["Incremental Operating Expenses",{"$f":"B19","v":{"$error":"#REF!"}},{"$f":"C19","v":0},{"$f":"D19","v":{"$error":"#REF!"}},{"$f":"SUM(B39:D39)","v":{"$error":"#REF!"}},null,{"$f":"G19","v":0},{"$f":"H19","v":0},{"$f":"SUM(G39:H39)","v":0}]
["Amortization Expenses",{"$f":"'7A.  Smart Meter Rate Calc'!C42","v":0},{"$f":"'7A.  Smart Meter Rate Calc'!H42","v":{"$error":"#REF!"}},{"$f":"'10. 2007A Smart Meter Rate Calc'!C42","v":0},{"$f":"SUM(B40:D40)","v":{"$error":"#REF!"}},null,{"$f":"'7A.  Smart Meter Rate Calc'!E42","v":{"$error":"#REF!"}},{"$f":"'10. 2007A Smart Meter Rate Calc'!E42","v":{"$error":"#REF!"}},{"$f":"SUM(G40:H40)","v":{"$error":"#REF!"}}]
["Total Operating Expenses",{"$f":"SUM(B39:B40)","v":{"$error":"#REF!"}},{"$f":"SUM(C39:C40)","v":{"$error":"#REF!"}},{"$f":"SUM(D39:D40)","v":{"$error":"#REF!"}},{"$f":"SUM(E39:E40)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G39:G40)","v":{"$error":"#REF!"}},{"$f":"SUM(H39:H40)","v":{"$error":"#REF!"}},{"$f":"SUM(I39:I40)","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,"Perm Adjust"]
[null,"2006 Actual","2006 Plus","2007 Actual","Total Actual",null,2006,2007,"Total"]
["Revenue Requirement Before PILs",{"$f":"B36+B41","v":{"$error":"#REF!"}},{"$f":"C36+C41","v":{"$error":"#REF!"}},{"$f":"D36+D41","v":{"$error":"#REF!"}},{"$f":"SUM(B45:D45)","v":{"$error":"#REF!"}},null,{"$f":"G36+G41","v":{"$error":"#REF!"}},{"$f":"H36+H41","v":{"$error":"#REF!"}},{"$f":"SUM(G45:H45)","v":{"$error":"#REF!"}}]
["Grossed up PILs",{"$f":"'8A. PILs'!C46","v":{"$error":"#REF!"}},{"$f":"'8A. PILs'!C46","v":{"$error":"#REF!"}},{"$f":"'11. 2007A PILs'!C46","v":{"$error":"#REF!"}},{"$f":"SUM(B46:D46)","v":{"$error":"#REF!"}},null,{"$f":"'8A. PILs'!C46","v":{"$error":"#REF!"}},{"$f":"'11. 2007A PILs'!C46","v":{"$error":"#REF!"}},{"$f":"SUM(G46:H46)","v":{"$error":"#REF!"}}]
["Revenue Requirement for Smart Meters",{"$f":"SUM(B45:B46)","v":{"$error":"#REF!"}},{"$f":"SUM(C45:C46)","v":{"$error":"#REF!"}},{"$f":"SUM(D45:D46)","v":{"$error":"#REF!"}},{"$f":"SUM(E45:E46)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G45:G46)","v":{"$error":"#REF!"}},{"$f":"SUM(H45:H46)","v":{"$error":"#REF!"}},{"$f":"SUM(I45:I46)","v":{"$error":"#REF!"}}]
[]
[]
["Rate Rider to Clear Actual Expenses to April 2007"]
["Revenue Requirement for Smart Meters Installed",null,null,null,null,null,{"$f":"E47","v":{"$error":"#REF!"}}]
["Carrying costs",null,null,null,null,null,{"$f":"'5. Clearing Actual'!H32","v":{"$error":"#REF!"}}]
["Less Smart Meter Adder Recovery","Rate Adder","Metered Customers per 2006 EDR","No. of Mths","Amount Recovered"]
["May 2006 to April 2007 - Residential",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},12,{"$f":"B54*C54*D54","v":{"$error":"#REF!"}}]
["May 2006 to April 2007 - GS & LU",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},12,{"$f":"B55*C55*D55","v":{"$error":"#REF!"}}]
["May 2007 to October 2007 - Residential",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},6,{"$f":"B56*C56*D56","v":{"$error":"#REF!"}}]
["May 2007 to October 2007 - GS & LU",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},6,{"$f":"B57*C57*D57","v":{"$error":"#REF!"}}]
["November 2007 to April 2008 (proposed no change)",{"$f":"'6. Adder Recovery'!H26","v":0.73},{"$f":"#REF!","v":{"$error":"#REF!"}},6,{"$f":"B58*C58*D58","v":{"$error":"#REF!"}},null,{"$f":"-SUM(E54:E58)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,{"$f":"SUM(G51:G58)","v":{"$error":"#REF!"}}]
[]
["Rate Adder for Capital and Operating Exp April 2007 to December 2007","Rate Adder","Metered Customers per 2006 EDR","No. of Mths","Amount Recovered"]
["November 2007 to April 2008 (new deferral account)",{"$f":"E62/C62/D62","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},6,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[]
["Permanent Capital Rate Adjustustment","Rate Adder","Metered Customers per 2006 EDR","No. of Mths","Amount Recovered"]
["May 2008",{"$f":"E66/C66/D66","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},12,{"$f":"I47","v":{"$error":"#REF!"}}]

{"sheet":"5. Clearing Actual","index":1,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":true,"merged":[[0,0,0,8],[1,0,1,8]]}
["Clearing Actuals Smart Meter Revenue Requirement"]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Opening ","2006 \nRev Req","2006 Plus Rev Req","2007 \nRev Req","Recovery","Int. Rate","Interest","Closing"]
["2006-01-01",0,{"$f":"'4. Smart Meter Rev & Adder'!$B$47/12","v":{"$error":"#REF!"}},null,null,{"$f":"-'6. Adder Recovery'!D4","v":{"$error":"#REF!"}},7.0400000000000004E-2,{"$f":"(B4*G4)/12","v":0},{"$f":"SUM(B4:F4,H4)","v":{"$error":"#REF!"}}]
["2006-02-01",{"$f":"I4","v":{"$error":"#REF!"}},{"$f":"'4. Smart Meter Rev & Adder'!$B$47/12","v":{"$error":"#REF!"}},null,null,{"$f":"-'6. Adder Recovery'!D5","v":{"$error":"#REF!"}},7.0400000000000004E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["2006-03-01",{"$error":"#REF!"},{"$f":"'4. Smart Meter Rev & Adder'!$B$47/12","v":{"$error":"#REF!"}},null,null,{"$f":"-'6. Adder Recovery'!D6","v":{"$error":"#REF!"}},7.0400000000000004E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["2006-04-01",{"$error":"#REF!"},{"$f":"'4. Smart Meter Rev & Adder'!$B$47/12","v":{"$error":"#REF!"}},null,null,{"$f":"-'6. Adder Recovery'!D7","v":{"$error":"#REF!"}},4.1399999999999999E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["2006-05-01",{"$error":"#REF!"},{"$f":"'4. Smart Meter Rev & Adder'!$B$47/12","v":{"$error":"#REF!"}},null,null,{"$f":"-'6. Adder Recovery'!D8","v":{"$error":"#REF!"}},4.1399999999999999E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["2006-06-01",{"$error":"#REF!"},{"$f":"'4. Smart Meter Rev & Adder'!$B$47/12","v":{"$error":"#REF!"}},null,null,{"$f":"-'6. Adder Recovery'!D9","v":{"$error":"#REF!"}},4.1399999999999999E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["2006-07-01",{"$error":"#REF!"},{"$f":"'4. Smart Meter Rev & Adder'!$B$47/12","v":{"$error":"#REF!"}},null,null,{"$f":"-'6. Adder Recovery'!D10","v":{"$error":"#REF!"}},4.5900000000000003E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["2006-08-01",{"$error":"#REF!"},{"$f":"'4. Smart Meter Rev & Adder'!$B$47/12","v":{"$error":"#REF!"}},null,null,{"$f":"-'6. Adder Recovery'!D11","v":{"$error":"#REF!"}},4.5900000000000003E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["2006-09-01",{"$error":"#REF!"},{"$f":"'4. Smart Meter Rev & Adder'!$B$47/12","v":{"$error":"#REF!"}},null,null,{"$f":"-'6. Adder Recovery'!D12","v":{"$error":"#REF!"}},4.5900000000000003E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["2006-10-01",{"$error":"#REF!"},{"$f":"'4. Smart Meter Rev & Adder'!$B$47/12","v":{"$error":"#REF!"}},null,null,{"$f":"-'6. Adder Recovery'!D13","v":{"$error":"#REF!"}},4.5900000000000003E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["2006-11-01",{"$error":"#REF!"},{"$f":"'4. Smart Meter Rev & Adder'!$B$47/12","v":{"$error":"#REF!"}},null,null,{"$f":"-'6. Adder Recovery'!D14","v":{"$error":"#REF!"}},4.5900000000000003E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["2006-12-01",{"$error":"#REF!"},{"$f":"'4. Smart Meter Rev & Adder'!$B$47/12","v":{"$error":"#REF!"}},null,null,{"$f":"-'6. Adder Recovery'!D15","v":{"$error":"#REF!"}},4.5900000000000003E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["2007-01-01",{"$error":"#REF!"},0,{"$f":"'4. Smart Meter Rev & Adder'!$C$47/12","v":{"$error":"#REF!"}},{"$f":"'4. Smart Meter Rev & Adder'!$D$47/12","v":{"$error":"#REF!"}},{"$f":"-'6. Adder Recovery'!D16","v":{"$error":"#REF!"}},4.5900000000000003E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["2007-02-01",{"$error":"#REF!"},0,{"$f":"'4. Smart Meter Rev & Adder'!$C$47/12","v":{"$error":"#REF!"}},{"$f":"'4. Smart Meter Rev & Adder'!$D$47/12","v":{"$error":"#REF!"}},{"$f":"-'6. Adder Recovery'!D17","v":{"$error":"#REF!"}},4.5900000000000003E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["2007-03-01",{"$error":"#REF!"},0,{"$f":"'4. Smart Meter Rev & Adder'!$C$47/12","v":{"$error":"#REF!"}},{"$f":"'4. Smart Meter Rev & Adder'!$D$47/12","v":{"$error":"#REF!"}},{"$f":"-'6. Adder Recovery'!D18","v":{"$error":"#REF!"}},4.5900000000000003E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["2007-04-01",{"$error":"#REF!"},0,{"$f":"'4. Smart Meter Rev & Adder'!$C$47/12","v":{"$error":"#REF!"}},{"$f":"'4. Smart Meter Rev & Adder'!$D$47/12","v":{"$error":"#REF!"}},{"$f":"-'6. Adder Recovery'!D19","v":{"$error":"#REF!"}},4.5900000000000003E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["2007-05-01",{"$error":"#REF!"},0,{"$f":"'4. Smart Meter Rev & Adder'!$C$47/12","v":{"$error":"#REF!"}},{"$f":"'4. Smart Meter Rev & Adder'!$D$47/12","v":{"$error":"#REF!"}},{"$f":"-'6. Adder Recovery'!D20","v":{"$error":"#REF!"}},4.5900000000000003E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["2007-06-01",{"$error":"#REF!"},0,{"$f":"'4. Smart Meter Rev & Adder'!$C$47/12","v":{"$error":"#REF!"}},{"$f":"'4. Smart Meter Rev & Adder'!$D$47/12","v":{"$error":"#REF!"}},{"$f":"-'6. Adder Recovery'!D21","v":{"$error":"#REF!"}},4.5900000000000003E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["2007-07-01",{"$error":"#REF!"},0,{"$f":"'4. Smart Meter Rev & Adder'!$C$47/12","v":{"$error":"#REF!"}},{"$f":"'4. Smart Meter Rev & Adder'!$D$47/12","v":{"$error":"#REF!"}},{"$f":"-'6. Adder Recovery'!D22","v":{"$error":"#REF!"}},4.5900000000000003E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["2007-08-01",{"$error":"#REF!"},0,{"$f":"'4. Smart Meter Rev & Adder'!$C$47/12","v":{"$error":"#REF!"}},{"$f":"'4. Smart Meter Rev & Adder'!$D$47/12","v":{"$error":"#REF!"}},{"$f":"-'6. Adder Recovery'!D23","v":{"$error":"#REF!"}},4.5900000000000003E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["2007-09-01",{"$error":"#REF!"},0,{"$f":"'4. Smart Meter Rev & Adder'!$C$47/12","v":{"$error":"#REF!"}},{"$f":"'4. Smart Meter Rev & Adder'!$D$47/12","v":{"$error":"#REF!"}},{"$f":"-'6. Adder Recovery'!D24","v":{"$error":"#REF!"}},4.5900000000000003E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["2007-10-01",{"$error":"#REF!"},0,{"$f":"'4. Smart Meter Rev & Adder'!$C$47/12","v":{"$error":"#REF!"}},{"$f":"'4. Smart Meter Rev & Adder'!$D$47/12","v":{"$error":"#REF!"}},{"$f":"-'6. Adder Recovery'!D25","v":{"$error":"#REF!"}},4.5900000000000003E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["2007-11-01",{"$error":"#REF!"},0,{"$f":"'4. Smart Meter Rev & Adder'!$C$47/12","v":{"$error":"#REF!"}},{"$f":"'4. Smart Meter Rev & Adder'!$D$47/12","v":{"$error":"#REF!"}},{"$f":"-'6. Adder Recovery'!D26","v":{"$error":"#REF!"}},4.5900000000000003E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["2007-12-01",{"$error":"#REF!"},0,{"$f":"'4. Smart Meter Rev & Adder'!$C$47/12","v":{"$error":"#REF!"}},{"$f":"'4. Smart Meter Rev & Adder'!$D$47/12","v":{"$error":"#REF!"}},{"$f":"-'6. Adder Recovery'!D27","v":{"$error":"#REF!"}},4.5900000000000003E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["2008-01-01",{"$error":"#REF!"},0,null,null,{"$f":"-'6. Adder Recovery'!D28","v":{"$error":"#REF!"}},4.5900000000000003E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["2008-02-01",{"$error":"#REF!"},0,null,null,{"$f":"-'6. Adder Recovery'!D29","v":{"$error":"#REF!"}},4.5900000000000003E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["2008-03-01",{"$error":"#REF!"},0,null,null,{"$f":"-'6. Adder Recovery'!D30","v":{"$error":"#REF!"}},4.5900000000000003E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["2008-04-01",{"$error":"#REF!"},0,null,null,{"$f":"-'6. Adder Recovery'!D31","v":{"$error":"#REF!"}},4.5900000000000003E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["Revenue Requirement",null,{"$f":"SUM(C4:C31)","v":{"$error":"#REF!"}},{"$f":"SUM(D4:D31)","v":{"$error":"#REF!"}},{"$f":"SUM(E4:E31)","v":{"$error":"#REF!"}},null,"Carrying Costs",{"$f":"SUM(H4:H31)","v":{"$error":"#REF!"}}]

{"sheet":"6. Adder Recovery","index":2,"n_rows":31,"n_cols":17,"rows_kept":31,"cut":false,"hidden":true,"merged":[[0,12,0,16],[1,12,1,16],[0,0,0,4],[1,0,1,4],[0,6,0,10],[1,6,1,10]]}
["Smart Meter Rate Adder Recovery",null,null,null,null,null,"Smart Meter Rate Adder Recovery - Residential",null,null,null,null,null,"Smart Meter Rate Adder Recovery - GS & LU"]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Month","Residential","GS & LU","Total","Cummulative",null,"Month","SM Rate Adder","Customers","Recovery","Cummulative",null,"Month","SM Rate Adder","Customers","Recovery","Cummulative"]
["2006-01-01",{"$f":"J4","v":{"$error":"#REF!"}},{"$f":"P4","v":{"$error":"#REF!"}},{"$f":"SUM(B4:C4)","v":{"$error":"#REF!"}},{"$f":"SUM($D$4:D4)","v":{"$error":"#REF!"}},null,"2006-01-01",0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"H4*I4","v":{"$error":"#REF!"}},{"$f":"SUM($J$4:$J4)","v":{"$error":"#REF!"}},null,"2006-01-01",0,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"N4*O4","v":{"$error":"#REF!"}},{"$f":"SUM($P$4:$P4)","v":{"$error":"#REF!"}}]
["2006-02-01",{"$f":"J5","v":{"$error":"#REF!"}},{"$f":"P5","v":{"$error":"#REF!"}},{"$f":"SUM(B5:C5)","v":{"$error":"#REF!"}},{"$f":"SUM($D$4:D5)","v":{"$error":"#REF!"}},null,"2006-02-01",0,{"$f":"I4","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUM($J$4:$J5)","v":{"$error":"#REF!"}},null,"2006-02-01",0,{"$f":"O4","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUM($P$4:$P5)","v":{"$error":"#REF!"}}]
["2006-03-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($D$4:D6)","v":{"$error":"#REF!"}},null,"2006-03-01",0,{"$f":"I5","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUM($J$4:$J6)","v":{"$error":"#REF!"}},null,"2006-03-01",0,{"$f":"O5","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUM($P$4:$P6)","v":{"$error":"#REF!"}}]
["2006-04-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($D$4:D7)","v":{"$error":"#REF!"}},null,"2006-04-01",0,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($J$4:$J7)","v":{"$error":"#REF!"}},null,"2006-04-01",0,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($P$4:$P7)","v":{"$error":"#REF!"}}]
["2006-05-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($D$4:D8)","v":{"$error":"#REF!"}},null,"2006-05-01",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($J$4:$J8)","v":{"$error":"#REF!"}},null,"2006-05-01",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($P$4:$P8)","v":{"$error":"#REF!"}}]
["2006-06-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($D$4:D9)","v":{"$error":"#REF!"}},null,"2006-06-01",{"$f":"H8","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($J$4:$J9)","v":{"$error":"#REF!"}},null,"2006-06-01",{"$f":"N8","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($P$4:$P9)","v":{"$error":"#REF!"}}]
["2006-07-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($D$4:D10)","v":{"$error":"#REF!"}},null,"2006-07-01",{"$f":"H9","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($J$4:$J10)","v":{"$error":"#REF!"}},null,"2006-07-01",{"$f":"N9","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($P$4:$P10)","v":{"$error":"#REF!"}}]
["2006-08-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($D$4:D11)","v":{"$error":"#REF!"}},null,"2006-08-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($J$4:$J11)","v":{"$error":"#REF!"}},null,"2006-08-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($P$4:$P11)","v":{"$error":"#REF!"}}]
["2006-09-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($D$4:D12)","v":{"$error":"#REF!"}},null,"2006-09-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($J$4:$J12)","v":{"$error":"#REF!"}},null,"2006-09-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($P$4:$P12)","v":{"$error":"#REF!"}}]
["2006-10-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($D$4:D13)","v":{"$error":"#REF!"}},null,"2006-10-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($J$4:$J13)","v":{"$error":"#REF!"}},null,"2006-10-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($P$4:$P13)","v":{"$error":"#REF!"}}]
["2006-11-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($D$4:D14)","v":{"$error":"#REF!"}},null,"2006-11-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($J$4:$J14)","v":{"$error":"#REF!"}},null,"2006-11-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($P$4:$P14)","v":{"$error":"#REF!"}}]
["2006-12-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($D$4:D15)","v":{"$error":"#REF!"}},null,"2006-12-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($J$4:$J15)","v":{"$error":"#REF!"}},null,"2006-12-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($P$4:$P15)","v":{"$error":"#REF!"}}]
["2007-01-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($D$4:D16)","v":{"$error":"#REF!"}},null,"2007-01-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($J$4:$J16)","v":{"$error":"#REF!"}},null,"2007-01-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($P$4:$P16)","v":{"$error":"#REF!"}}]
["2007-02-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($D$4:D17)","v":{"$error":"#REF!"}},null,"2007-02-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($J$4:$J17)","v":{"$error":"#REF!"}},null,"2007-02-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($P$4:$P17)","v":{"$error":"#REF!"}}]
["2007-03-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($D$4:D18)","v":{"$error":"#REF!"}},null,"2007-03-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($J$4:$J18)","v":{"$error":"#REF!"}},null,"2007-03-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($P$4:$P18)","v":{"$error":"#REF!"}}]
["2007-04-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($D$4:D19)","v":{"$error":"#REF!"}},null,"2007-04-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($J$4:$J19)","v":{"$error":"#REF!"}},null,"2007-04-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($P$4:$P19)","v":{"$error":"#REF!"}}]
["2007-05-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($D$4:D20)","v":{"$error":"#REF!"}},null,"2007-05-01",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($J$4:$J20)","v":{"$error":"#REF!"}},null,"2007-05-01",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($P$4:$P20)","v":{"$error":"#REF!"}}]
["2007-06-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($D$4:D21)","v":{"$error":"#REF!"}},null,"2007-06-01",{"$f":"H20","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($J$4:$J21)","v":{"$error":"#REF!"}},null,"2007-06-01",{"$f":"N20","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($P$4:$P21)","v":{"$error":"#REF!"}}]
["2007-07-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($D$4:D22)","v":{"$error":"#REF!"}},null,"2007-07-01",{"$f":"H21","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($J$4:$J22)","v":{"$error":"#REF!"}},null,"2007-07-01",{"$f":"N21","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($P$4:$P22)","v":{"$error":"#REF!"}}]
["2007-08-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($D$4:D23)","v":{"$error":"#REF!"}},null,"2007-08-01",{"$f":"H22","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($J$4:$J23)","v":{"$error":"#REF!"}},null,"2007-08-01",{"$f":"N22","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($P$4:$P23)","v":{"$error":"#REF!"}}]
["2007-09-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($D$4:D24)","v":{"$error":"#REF!"}},null,"2007-09-01",{"$f":"H23","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($J$4:$J24)","v":{"$error":"#REF!"}},null,"2007-09-01",{"$f":"N23","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($P$4:$P24)","v":{"$error":"#REF!"}}]
["2007-10-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($D$4:D25)","v":{"$error":"#REF!"}},null,"2007-10-01",{"$f":"H24","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($J$4:$J25)","v":{"$error":"#REF!"}},null,"2007-10-01",{"$f":"N24","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($P$4:$P25)","v":{"$error":"#REF!"}}]
["2007-11-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($D$4:D26)","v":{"$error":"#REF!"}},null,"2007-11-01",0.73,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($J$4:$J26)","v":{"$error":"#REF!"}},null,"2007-11-01",{"$f":"H26","v":0.73},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($P$4:$P26)","v":{"$error":"#REF!"}}]
["2007-12-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($D$4:D27)","v":{"$error":"#REF!"}},null,"2007-12-01",{"$f":"H26","v":0.73},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($J$4:$J27)","v":{"$error":"#REF!"}},null,"2007-12-01",0.73,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($P$4:$P27)","v":{"$error":"#REF!"}}]
["2008-01-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($D$4:D28)","v":{"$error":"#REF!"}},null,"2008-01-01",{"$f":"H27","v":0.73},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($J$4:$J28)","v":{"$error":"#REF!"}},null,"2008-01-01",0.73,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($P$4:$P28)","v":{"$error":"#REF!"}}]
["2008-02-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($D$4:D29)","v":{"$error":"#REF!"}},null,"2008-02-01",{"$f":"H28","v":0.73},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($J$4:$J29)","v":{"$error":"#REF!"}},null,"2008-02-01",0.73,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($P$4:$P29)","v":{"$error":"#REF!"}}]
["2008-03-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($D$4:D30)","v":{"$error":"#REF!"}},null,"2008-03-01",{"$f":"H29","v":0.73},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($J$4:$J30)","v":{"$error":"#REF!"}},null,"2008-03-01",0.73,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($P$4:$P30)","v":{"$error":"#REF!"}}]
["2008-04-01",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($D$4:D31)","v":{"$error":"#REF!"}},null,"2008-04-01",{"$f":"H30","v":0.73},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($J$4:$J31)","v":{"$error":"#REF!"}},null,"2008-04-01",0.73,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM($P$4:$P31)","v":{"$error":"#REF!"}}]

{"sheet":"7A.  Smart Meter Rate Calc","index":3,"n_rows":63,"n_cols":17,"rows_kept":63,"cut":false,"hidden":true,"merged":[[9,14,9,16],[9,2,9,4],[1,1,1,4],[2,1,2,4],[0,1,0,4],[4,1,4,3],[9,5,9,7],[9,8,9,10],[9,11,9,13]]}
[]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Sheet 7. Smart Meter Rate Calc"]
[]
[]
["Smart Meter Rate Calculation"]
[]
[null,"Average Asset Values",2006,null,null,2007,null,null,2008,null,null,2009,null,null,2010]
[null,"Net Fixed Assets Smart Meters",{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!C22","v":{"$error":"#REF!"}},null,null,{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!D22","v":{"$error":"#REF!"}},null,null,{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!E22","v":{"$error":"#REF!"}},null,null,{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!F22","v":{"$error":"#REF!"}},null,null,{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!G22","v":{"$error":"#REF!"}}]
[null,"Net Fixed Assets Computer Hardware",{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!C36","v":{"$error":"#REF!"}},null,null,{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!D36","v":{"$error":"#REF!"}},null,null,{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!E36","v":{"$error":"#REF!"}},null,null,{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!F36","v":{"$error":"#REF!"}},null,null,{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!G36","v":{"$error":"#REF!"}}]
[null,"Net Fixed Assets Computer Software",{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!C50","v":{"$error":"#REF!"}},null,null,{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!D50","v":{"$error":"#REF!"}},null,null,{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!E50","v":{"$error":"#REF!"}},null,null,{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!F50","v":{"$error":"#REF!"}},null,null,{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!G50","v":{"$error":"#REF!"}}]
[null,"Net Fixed Assets Tools & Equipment",{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!C65","v":{"$error":"#REF!"}},null,null,{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!D65","v":{"$error":"#REF!"}},null,null,{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!E65","v":{"$error":"#REF!"}},null,null,{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!F65","v":{"$error":"#REF!"}},null,null,{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!G65","v":{"$error":"#REF!"}}]
[null,"Net Fixed Assets Other Equipment",{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!C79","v":{"$error":"#REF!"}},null,null,{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!D79","v":{"$error":"#REF!"}},null,null,{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!E79","v":{"$error":"#REF!"}},null,null,{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!F79","v":{"$error":"#REF!"}},null,null,{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!G79","v":{"$error":"#REF!"}}]
[null,"Total Net Fixed Assets",{"$f":"SUM(C11:C15)","v":{"$error":"#REF!"}},{"$f":"C16","v":{"$error":"#REF!"}},null,{"$f":"SUM(F11:F15)","v":{"$error":"#REF!"}},{"$f":"F16","v":{"$error":"#REF!"}},null,{"$f":"SUM(I11:I15)","v":{"$error":"#REF!"}},{"$f":"I16","v":{"$error":"#REF!"}},null,{"$f":"SUM(L11:L15)","v":{"$error":"#REF!"}},{"$f":"L16","v":{"$error":"#REF!"}},null,{"$f":"SUM(O11:O15)","v":{"$error":"#REF!"}},{"$f":"O16","v":{"$error":"#REF!"}}]
[]
[null,"Working Capital"]
[null,"Operation Expense",{"$f":"E34","v":{"$error":"#REF!"}},null,null,{"$f":"H34","v":{"$error":"#REF!"}},null,null,{"$f":"K34","v":{"$error":"#REF!"}},null,null,{"$f":"N34","v":{"$error":"#REF!"}},null,null,{"$f":"Q34","v":{"$error":"#REF!"}}]
[null,{"$f":"\"Working Capital \"&#REF!*100&\" %\"","v":{"$error":"#REF!"}},{"$f":"C19*#REF!","v":{"$error":"#REF!"}},{"$f":"C20","v":{"$error":"#REF!"}},null,{"$f":"F19*#REF!","v":{"$error":"#REF!"}},{"$f":"F20","v":{"$error":"#REF!"}},null,{"$f":"I19*#REF!","v":{"$error":"#REF!"}},{"$f":"I20","v":{"$error":"#REF!"}},null,{"$f":"L19*#REF!","v":{"$error":"#REF!"}},{"$f":"L20","v":{"$error":"#REF!"}},null,{"$f":"O19*#REF!","v":{"$error":"#REF!"}},{"$f":"O20","v":{"$error":"#REF!"}}]
[]
[null,"Smart Meters included in Rate Base",null,{"$f":"SUM(D12:D20)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(G12:G20)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(J12:J20)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(M12:M20)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(P12:P20)","v":{"$error":"#REF!"}}]
[]
[null,"Return on Rate Base"]
[null,"Deemed Debt (3.  LDC Assumptions and Data)",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"D22*C25","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"G22*F25","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"J22*I25","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"M22*L25","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"P22*O25","v":{"$error":"#REF!"}}]
[null,"Deemed Equity (3.  LDC Assumptions and Data)",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"D22*C26","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"G22*F26","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"J22*I26","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"M22*L26","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"P22*O26","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"SUM(D25:D26)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(G25:G26)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(J25:J26)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(M25:M26)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(P25:P26)","v":{"$error":"#REF!"}}]
[]
[null,"Weighted Debt Rate (3.  LDC Assumptions and Data)",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"D25*C29","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"G25*F29","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"J25*I29","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"M25*L29","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"P25*O29","v":{"$error":"#REF!"}}]
[null,"Proposed ROE (3.  LDC Assumptions and Data)",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"D26*C30","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"G26*F30","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"J26*I30","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"M26*L30","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"P26*O30","v":{"$error":"#REF!"}}]
[null,"Return on Rate Base",null,{"$f":"SUM(D29:D30)","v":{"$error":"#REF!"}},{"$f":"D31","v":{"$error":"#REF!"}},null,{"$f":"SUM(G29:G30)","v":{"$error":"#REF!"}},{"$f":"G31","v":{"$error":"#REF!"}},null,{"$f":"SUM(J29:J30)","v":{"$error":"#REF!"}},{"$f":"J31","v":{"$error":"#REF!"}},null,{"$f":"SUM(M29:M30)","v":{"$error":"#REF!"}},{"$f":"M31","v":{"$error":"#REF!"}},null,{"$f":"SUM(P29:P30)","v":{"$error":"#REF!"}},{"$f":"P31","v":{"$error":"#REF!"}}]
[]
[null,"Operating Expenses"]
[null,"Incremental Operating Expenses (3.  LDC Assumptions and Data)",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Amortization Expenses"]
[null,"Amortization Expenses - Smart Meters",null,{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!C17:C17)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!D17:D17)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!E17:E17)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!F17:F17)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!G17:G17)","v":{"$error":"#REF!"}}]
[null,"Amortization Expenses - Computer Hardware",null,{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!C31:C31)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!D31:D31)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!E31:E31)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!F31:F31)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!G31:G31)","v":{"$error":"#REF!"}}]
[null,"Amortization Expenses - Computer Software",null,{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!C45:C45)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!D45:D45)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!E45:E45)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!F45:F45)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!G45:G45)","v":{"$error":"#REF!"}}]
[null,"Amortization Expenses -  Tools & Equipment",null,{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!C60:C60)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!D60:D60)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!E60:E60)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!F60:F60)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!G60:G60)","v":{"$error":"#REF!"}}]
[null,"Amortization Expenses - Other Equipment",null,{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!C74:C74)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!D74:D74)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!E74:E74)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!F74:F74)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('9A. SM Avg Nt Fix Ass &UCC'!G74:G74)","v":{"$error":"#REF!"}}]
[null,"Total Amortization Expenses",null,null,{"$f":"SUM(D37:D41)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(G37:G41)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(J37:J41)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(M37:M41)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(P37:P41)","v":{"$error":"#REF!"}}]
[]
[null,"Revenue Requirement Before PILs",null,null,{"$f":"SUM(E31,E42,E34)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(H31,H42,H34)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(K31,K42,K34)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(N31,N42,N34)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(Q31,Q42,Q34)","v":{"$error":"#REF!"}}]
[]
[null,"Calculation of Taxable Income"]
[null,"Incremental Operating Expenses",null,null,{"$f":"-E34","v":{"$error":"#REF!"}},null,null,{"$f":"-H34","v":{"$error":"#REF!"}},null,null,{"$f":"-K34","v":{"$error":"#REF!"}},null,null,{"$f":"-N34","v":{"$error":"#REF!"}},null,null,{"$f":"-Q34","v":{"$error":"#REF!"}}]
[null,"Depreciation Expenses",null,null,{"$f":"-E42","v":{"$error":"#REF!"}},null,null,{"$f":"-H42","v":{"$error":"#REF!"}},null,null,{"$f":"-K42","v":{"$error":"#REF!"}},null,null,{"$f":"-N42","v":{"$error":"#REF!"}},null,null,{"$f":"-Q42","v":{"$error":"#REF!"}}]
[null,"Interest Expense",null,null,{"$f":"-D29","v":{"$error":"#REF!"}},null,null,{"$f":"-G29","v":{"$error":"#REF!"}},null,null,{"$f":"-J29","v":{"$error":"#REF!"}},null,null,{"$f":"-M29","v":{"$error":"#REF!"}},null,null,{"$f":"-P29","v":{"$error":"#REF!"}}]
[null,"Taxable Income For PILs",null,null,{"$f":"SUM(E44:E49)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(H44:H49)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(K44:K49)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(N44:N49)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(Q44:Q49)","v":{"$error":"#REF!"}}]
[]
[null,"Grossed up PILs (5. PILs)",null,null,{"$f":"'8A. PILs'!C46","v":{"$error":"#REF!"}},null,null,{"$f":"'8A. PILs'!D46","v":{"$error":"#REF!"}},null,null,{"$f":"'8A. PILs'!E46","v":{"$error":"#REF!"}},null,null,{"$f":"'8A. PILs'!F46","v":{"$error":"#REF!"}},null,null,{"$f":"'8A. PILs'!G46","v":{"$error":"#REF!"}}]
[]
[null,{"$f":"B44","v":"Revenue Requirement Before PILs"},null,null,{"$f":"E44","v":{"$error":"#REF!"}},null,null,{"$f":"H44","v":{"$error":"#REF!"}},null,null,{"$f":"K44","v":{"$error":"#REF!"}},null,null,{"$f":"N44","v":{"$error":"#REF!"}},null,null,{"$f":"Q44","v":{"$error":"#REF!"}}]
[null,"Grossed up PILs (5. PILs)",null,null,{"$f":"E52","v":{"$error":"#REF!"}},null,null,{"$f":"H52","v":{"$error":"#REF!"}},null,null,{"$f":"K52","v":{"$error":"#REF!"}},null,null,{"$f":"N52","v":{"$error":"#REF!"}},null,null,{"$f":"Q52","v":{"$error":"#REF!"}}]
[null,"Revenue Requirement for Smart Meters",null,null,{"$f":"SUM(E54:E55)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(H54:H55)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(K54:K55)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(N54:N55)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(Q54:Q55)","v":{"$error":"#REF!"}}]
[]
[null,"2007 Smart Meter Rate Adder"]
[null,"Revenue Requirement for Smart Meters",null,null,{"$f":"E56","v":{"$error":"#REF!"}},null,null,{"$f":"H56","v":{"$error":"#REF!"}},null,null,{"$f":"K56","v":{"$error":"#REF!"}},null,null,{"$f":"N56","v":{"$error":"#REF!"}},null,null,{"$f":"Q56","v":{"$error":"#REF!"}}]
[null,"2006 EDR Total Metered Customers (3.  LDC Assumptions and Data)",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Annualized amount required per metered customer",null,null,{"$f":"IF(ISERROR(E59/E60),0,E59/E60)","v":0},null,null,{"$f":"IF(ISERROR(H59/H60),0,H59/H60)","v":0},null,null,{"$f":"IF(ISERROR(K59/K60),0,K59/K60)","v":0},null,null,{"$f":"IF(ISERROR(N59/N60),0,N59/N60)","v":0},null,null,{"$f":"IF(ISERROR(Q59/Q60),0,Q59/Q60)","v":0}]
[null,"Number of months in year",null,null,12,null,null,12,null,null,12,null,null,12,null,null,12]
[null,"2007 Smart Meter Rate Adder",null,null,{"$f":"E61/E62","v":0},null,null,{"$f":"H61/H62","v":0},null,null,{"$f":"K61/K62","v":0},null,null,{"$f":"N61/N62","v":0},null,null,{"$f":"Q61/Q62","v":0}]

{"sheet":"8A. PILs","index":4,"n_rows":46,"n_cols":9,"rows_kept":46,"cut":false,"hidden":true,"merged":[[1,1,1,4],[2,1,2,4],[0,1,0,4],[4,1,4,4]]}
[]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Sheet 8A. PILs"]
[]
[]
[null,"PILs Calculation"]
[]
[null,null,2006,2007,2008,2009,2010]
[null,"INCOME TAX"]
[null,"Net Income",{"$f":"'7A.  Smart Meter Rate Calc'!E50","v":{"$error":"#REF!"}},{"$f":"'7A.  Smart Meter Rate Calc'!H50","v":{"$error":"#REF!"}},{"$f":"'7A.  Smart Meter Rate Calc'!K50","v":{"$error":"#REF!"}},{"$f":"'7A.  Smart Meter Rate Calc'!N50","v":{"$error":"#REF!"}},{"$f":"'7A.  Smart Meter Rate Calc'!Q50","v":{"$error":"#REF!"}}]
[null,"Amortization ",{"$f":"-'7A.  Smart Meter Rate Calc'!E48","v":{"$error":"#REF!"}},{"$f":"-'7A.  Smart Meter Rate Calc'!H48","v":{"$error":"#REF!"}},{"$f":"-'7A.  Smart Meter Rate Calc'!K48","v":{"$error":"#REF!"}},{"$f":"-'7A.  Smart Meter Rate Calc'!N48","v":{"$error":"#REF!"}},{"$f":"-'7A.  Smart Meter Rate Calc'!Q48","v":{"$error":"#REF!"}}]
[null,"CCA - Class 47 (8%) Smart Meters",{"$f":"-'9A. SM Avg Nt Fix Ass &UCC'!C93","v":{"$error":"#REF!"}},{"$f":"-'9A. SM Avg Nt Fix Ass &UCC'!D93","v":{"$error":"#REF!"}},{"$f":"-'9A. SM Avg Nt Fix Ass &UCC'!E93","v":{"$error":"#REF!"}},{"$f":"-'9A. SM Avg Nt Fix Ass &UCC'!F93","v":{"$error":"#REF!"}},{"$f":"-'9A. SM Avg Nt Fix Ass &UCC'!G93","v":{"$error":"#REF!"}}]
[null,"CCA - Class 45 (45%) Computers",{"$f":"-'9A. SM Avg Nt Fix Ass &UCC'!C106","v":{"$error":"#REF!"}},{"$f":"-'9A. SM Avg Nt Fix Ass &UCC'!D106","v":{"$error":"#REF!"}},{"$f":"-'9A. SM Avg Nt Fix Ass &UCC'!E106","v":{"$error":"#REF!"}},{"$f":"-'9A. SM Avg Nt Fix Ass &UCC'!F106","v":{"$error":"#REF!"}},{"$f":"-'9A. SM Avg Nt Fix Ass &UCC'!G106","v":{"$error":"#REF!"}}]
[null,"CCA - Class 8 (20%) Other Equipment",{"$f":"-'9A. SM Avg Nt Fix Ass &UCC'!C119","v":{"$error":"#REF!"}},{"$f":"-'9A. SM Avg Nt Fix Ass &UCC'!D119","v":{"$error":"#REF!"}},{"$f":"-'9A. SM Avg Nt Fix Ass &UCC'!E119","v":{"$error":"#REF!"}},{"$f":"-'9A. SM Avg Nt Fix Ass &UCC'!F119","v":{"$error":"#REF!"}},{"$f":"-'9A. SM Avg Nt Fix Ass &UCC'!G119","v":{"$error":"#REF!"}}]
[null,"Change in taxable income",{"$f":"SUM(C12:C16)","v":{"$error":"#REF!"}},{"$f":"SUM(D12:D16)","v":{"$error":"#REF!"}},{"$f":"SUM(E12:E16)","v":{"$error":"#REF!"}},{"$f":"SUM(F12:F16)","v":{"$error":"#REF!"}},{"$f":"SUM(G12:G16)","v":{"$error":"#REF!"}}]
[null,"Tax Rate (3.  LDC Assumptions and Data)",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Income Taxes Payable",{"$f":"C17*C18","v":{"$error":"#REF!"}},{"$f":"D17*D18","v":{"$error":"#REF!"}},{"$f":"E17*E18","v":{"$error":"#REF!"}},{"$f":"F17*F18","v":{"$error":"#REF!"}},{"$f":"G17*G18","v":{"$error":"#REF!"}}]
[]
[null,"ONTARIO CAPITAL TAX"]
[null,"Smart Meters",{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!C21","v":{"$error":"#REF!"}},{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!D21","v":{"$error":"#REF!"}},{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!E21","v":{"$error":"#REF!"}},{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!F21","v":{"$error":"#REF!"}},{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!G21","v":{"$error":"#REF!"}}]
[null,"Computer Hardware",{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!C35","v":{"$error":"#REF!"}},{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!D35","v":{"$error":"#REF!"}},{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!E35","v":{"$error":"#REF!"}},{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!F35","v":{"$error":"#REF!"}},{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!G35","v":{"$error":"#REF!"}}]
[null,"Computer Software",{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!C49","v":{"$error":"#REF!"}},{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!D49","v":{"$error":"#REF!"}},{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!E49","v":{"$error":"#REF!"}},{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!F49","v":{"$error":"#REF!"}},{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!G49","v":{"$error":"#REF!"}}]
[null,"Tools & Equipment",{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!C64","v":{"$error":"#REF!"}},{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!D64","v":{"$error":"#REF!"}},{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!E64","v":{"$error":"#REF!"}},{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!F64","v":{"$error":"#REF!"}},{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!G64","v":{"$error":"#REF!"}}]
[null,"Other Equipment",{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!C78","v":{"$error":"#REF!"}},{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!D78","v":{"$error":"#REF!"}},{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!E78","v":{"$error":"#REF!"}},{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!F78","v":{"$error":"#REF!"}},{"$f":"'9A. SM Avg Nt Fix Ass &UCC'!G78","v":{"$error":"#REF!"}}]
[null,"Rate Base",{"$f":"SUM(C22:C24)","v":{"$error":"#REF!"}},{"$f":"SUM(D22:D24)","v":{"$error":"#REF!"}},{"$f":"SUM(E22:E24)","v":{"$error":"#REF!"}},{"$f":"SUM(F22:F24)","v":{"$error":"#REF!"}},{"$f":"SUM(G22:G24)","v":{"$error":"#REF!"}}]
[null,"Less: Exemption",0,0,0,0,0]
[null,"Deemed Taxable Capital",{"$f":"C27-C28","v":{"$error":"#REF!"}},{"$f":"D27-D28","v":{"$error":"#REF!"}},{"$f":"E27-E28","v":{"$error":"#REF!"}},{"$f":"F27-F28","v":{"$error":"#REF!"}},{"$f":"G27-G28","v":{"$error":"#REF!"}}]
[null,"Ontario Capital Tax Rate",3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3]
[null,"Net Amount (Taxable Capital x Rate)",{"$f":"C29*C30","v":{"$error":"#REF!"}},{"$f":"D29*D30","v":{"$error":"#REF!"}},{"$f":"E29*E30","v":{"$error":"#REF!"}},{"$f":"F29*F30","v":{"$error":"#REF!"}},{"$f":"G29*G30","v":{"$error":"#REF!"}}]
[]
[]
[null,"Gross Up"]
[null,null,"PILs Payable","PILs Payable","PILs Payable","PILs Payable","PILs Payable"]
[null,"Change in Income Taxes Payable",{"$f":"C19","v":{"$error":"#REF!"}},{"$f":"D19","v":{"$error":"#REF!"}},{"$f":"E19","v":{"$error":"#REF!"}},{"$f":"F19","v":{"$error":"#REF!"}},{"$f":"G19","v":{"$error":"#REF!"}}]
[null,"Change in OCT",{"$f":"C31","v":{"$error":"#REF!"}},{"$f":"D31","v":{"$error":"#REF!"}},{"$f":"E31","v":{"$error":"#REF!"}},{"$f":"F31","v":{"$error":"#REF!"}},{"$f":"G31","v":{"$error":"#REF!"}}]
[null,"PIL's",{"$f":"SUM(C36:C37)","v":{"$error":"#REF!"}},{"$f":"SUM(D36:D37)","v":{"$error":"#REF!"}},{"$f":"SUM(E36:E37)","v":{"$error":"#REF!"}},{"$f":"SUM(F36:F37)","v":{"$error":"#REF!"}},{"$f":"SUM(G36:G37)","v":{"$error":"#REF!"}},null,"4. Smart Meter Rate Calc"]
[]
[null,null,"Gross Up","Gross Up","Gross Up","Gross Up","Gross Up"]
[null,null,{"$f":"$C$18","v":{"$error":"#REF!"}},{"$f":"$C$18","v":{"$error":"#REF!"}},{"$f":"$C$18","v":{"$error":"#REF!"}},{"$f":"$C$18","v":{"$error":"#REF!"}},{"$f":"$C$18","v":{"$error":"#REF!"}}]
[]
[null,null,"Grossed Up PILs","Grossed Up PILs","Grossed Up PILs","Grossed Up PILs","Grossed Up PILs"]
[null,"Change in Income Taxes Payable",{"$f":"C36/(1-C41)","v":{"$error":"#REF!"}},{"$f":"D36/(1-D41)","v":{"$error":"#REF!"}},{"$f":"E36/(1-E41)","v":{"$error":"#REF!"}},{"$f":"F36/(1-F41)","v":{"$error":"#REF!"}},{"$f":"G36/(1-G41)","v":{"$error":"#REF!"}}]
[null,"Change in OCT",{"$f":"C37","v":{"$error":"#REF!"}},{"$f":"D37","v":{"$error":"#REF!"}},{"$f":"E37","v":{"$error":"#REF!"}},{"$f":"F37","v":{"$error":"#REF!"}},{"$f":"G37","v":{"$error":"#REF!"}}]
[null,"PIL's",{"$f":"SUM(C44:C45)","v":{"$error":"#REF!"}},{"$f":"SUM(D44:D45)","v":{"$error":"#REF!"}},{"$f":"SUM(E44:E45)","v":{"$error":"#REF!"}},{"$f":"SUM(F44:F45)","v":{"$error":"#REF!"}},{"$f":"SUM(G44:G45)","v":{"$error":"#REF!"}}]

{"sheet":"9A. SM Avg Nt Fix Ass &UCC","index":5,"n_rows":120,"n_cols":7,"rows_kept":120,"cut":false,"hidden":true,"merged":[[1,1,1,4],[2,1,2,4],[0,1,0,4],[4,1,4,4]]}
[]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Sheet 9. SM Avg Net Fixed Assets &UCC"]
[]
[]
[null,"Smart Meter Average Net Fixed Assets"]
[]
[null,"Net Fixed Assets - Smart Meters",2006,2007,2008,2009,2010]
[]
[null,"Opening Capital Investment",0,{"$f":"C14","v":{"$error":"#REF!"}},{"$f":"D14","v":{"$error":"#REF!"}},{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"F14","v":{"$error":"#REF!"}}]
[null,"Capital Investment (3.  LDC Assumptions and Data)",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Closing Capital Investment",{"$f":"SUM(C12:C13)","v":{"$error":"#REF!"}},{"$f":"SUM(D12:D13)","v":{"$error":"#REF!"}},{"$f":"SUM(E12:E13)","v":{"$error":"#REF!"}},{"$f":"SUM(F12:F13)","v":{"$error":"#REF!"}},{"$f":"SUM(G12:G13)","v":{"$error":"#REF!"}}]
[]
[null,"Opening Accumulated Amortization",0,{"$f":"C18","v":{"$error":"#REF!"}},{"$f":"D18","v":{"$error":"#REF!"}},{"$f":"E18","v":{"$error":"#REF!"}},{"$f":"F18","v":{"$error":"#REF!"}}]
[null,{"$f":"\"Amortization Year 1 (\" &#REF! &\" Years  Straight Line)\"","v":{"$error":"#REF!"}},{"$f":"IF(C16+(C12/#REF!)+(C13/#REF!/2)<C14,(C12/#REF!)+(C13/#REF!/2),C14-C16)","v":{"$error":"#REF!"}},{"$f":"IF(D16+(D12/#REF!)+(D13/#REF!/2)<D14,(D12/#REF!)+(D13/#REF!/2),D14-D16)","v":{"$error":"#REF!"}},{"$f":"IF(E16+(E12/#REF!)+(E13/#REF!/2)<E14,(E12/#REF!)+(E13/#REF!/2),E14-E16)","v":{"$error":"#REF!"}},{"$f":"IF(F16+(F12/#REF!)+(F13/#REF!/2)<F14,(F12/#REF!)+(F13/#REF!/2),F14-F16)","v":{"$error":"#REF!"}},{"$f":"IF(G16+(G12/#REF!)+(G13/#REF!/2)<G14,(G12/#REF!)+(G13/#REF!/2),G14-G16)","v":{"$error":"#REF!"}}]
[null,"Closing Accumulated Amortization",{"$f":"SUM(C16:C17)","v":{"$error":"#REF!"}},{"$f":"SUM(D16:D17)","v":{"$error":"#REF!"}},{"$f":"SUM(E16:E17)","v":{"$error":"#REF!"}},{"$f":"SUM(F16:F17)","v":{"$error":"#REF!"}},{"$f":"SUM(G16:G17)","v":{"$error":"#REF!"}}]
[]
[null,"Opening Net Fixed Assets",{"$f":"0","v":0},{"$f":"C21","v":{"$error":"#REF!"}},{"$f":"D21","v":{"$error":"#REF!"}},{"$f":"E21","v":{"$error":"#REF!"}},{"$f":"F21","v":{"$error":"#REF!"}}]
[null,"Closing Net Fixed Assets",{"$f":"C14-C18","v":{"$error":"#REF!"}},{"$f":"D14-D18","v":{"$error":"#REF!"}},{"$f":"E14-E18","v":{"$error":"#REF!"}},{"$f":"F14-F18","v":{"$error":"#REF!"}},{"$f":"G14-G18","v":{"$error":"#REF!"}}]
[null,"Average Net Fixed Assets",{"$f":"(C21+C20)/2","v":{"$error":"#REF!"}},{"$f":"(D21+D20)/2","v":{"$error":"#REF!"}},{"$f":"(E21+E20)/2","v":{"$error":"#REF!"}},{"$f":"(F21+F20)/2","v":{"$error":"#REF!"}},{"$f":"(G21+G20)/2","v":{"$error":"#REF!"}}]
[]
[null,"Net Fixed Assets - Computer Hardware",2006,2007,2008,2009,2010]
[]
[null,"Opening Capital Investment",0,{"$f":"C28","v":{"$error":"#REF!"}},{"$f":"D28","v":{"$error":"#REF!"}},{"$f":"E28","v":{"$error":"#REF!"}},{"$f":"F28","v":{"$error":"#REF!"}}]
[null,"Capital Investment (3.  LDC Assumptions and Data)",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Closing Capital Investment",{"$f":"SUM(C26:C27)","v":{"$error":"#REF!"}},{"$f":"SUM(D26:D27)","v":{"$error":"#REF!"}},{"$f":"SUM(E26:E27)","v":{"$error":"#REF!"}},{"$f":"SUM(F26:F27)","v":{"$error":"#REF!"}},{"$f":"SUM(G26:G27)","v":{"$error":"#REF!"}}]
[]
[null,"Opening Accumulated Amortization",0,{"$f":"C32","v":{"$error":"#REF!"}},{"$f":"D32","v":{"$error":"#REF!"}},{"$f":"E32","v":{"$error":"#REF!"}},{"$f":"F32","v":{"$error":"#REF!"}}]
[null,{"$f":"\"Amortization Year 1 (\" &#REF! &\" Years  Straight Line)\"","v":{"$error":"#REF!"}},{"$f":"IF(C30+(C26/#REF!)+(C27/#REF!/2)<C28,(C26/#REF!)+(C27/#REF!/2),C28-C30)","v":{"$error":"#REF!"}},{"$f":"IF(D30+(D26/#REF!)+(D27/#REF!/2)<D28,(D26/#REF!)+(D27/#REF!/2),D28-D30)","v":{"$error":"#REF!"}},{"$f":"IF(E30+(E26/#REF!)+(E27/#REF!/2)<E28,(E26/#REF!)+(E27/#REF!/2),E28-E30)","v":{"$error":"#REF!"}},{"$f":"IF(F30+(F26/#REF!)+(F27/#REF!/2)<F28,(F26/#REF!)+(F27/#REF!/2),F28-F30)","v":{"$error":"#REF!"}},{"$f":"IF(G30+(G26/#REF!)+(G27/#REF!/2)<G28,(G26/#REF!)+(G27/#REF!/2),G28-G30)","v":{"$error":"#REF!"}}]
[null,"Closing Accumulated Amortization",{"$f":"SUM(C30:C31)","v":{"$error":"#REF!"}},{"$f":"SUM(D30:D31)","v":{"$error":"#REF!"}},{"$f":"SUM(E30:E31)","v":{"$error":"#REF!"}},{"$f":"SUM(F30:F31)","v":{"$error":"#REF!"}},{"$f":"SUM(G30:G31)","v":{"$error":"#REF!"}}]
[]
[null,"Opening Net Fixed Assets",{"$f":"0","v":0},{"$f":"C35","v":{"$error":"#REF!"}},{"$f":"D35","v":{"$error":"#REF!"}},{"$f":"E35","v":{"$error":"#REF!"}},{"$f":"F35","v":{"$error":"#REF!"}}]
[null,"Closing Net Fixed Assets",{"$f":"C28-C32","v":{"$error":"#REF!"}},{"$f":"D28-D32","v":{"$error":"#REF!"}},{"$f":"E28-E32","v":{"$error":"#REF!"}},{"$f":"F28-F32","v":{"$error":"#REF!"}},{"$f":"G28-G32","v":{"$error":"#REF!"}}]
[null,"Average Net Fixed Assets",{"$f":"(C35+C34)/2","v":{"$error":"#REF!"}},{"$f":"(D35+D34)/2","v":{"$error":"#REF!"}},{"$f":"(E35+E34)/2","v":{"$error":"#REF!"}},{"$f":"(F35+F34)/2","v":{"$error":"#REF!"}},{"$f":"(G35+G34)/2","v":{"$error":"#REF!"}}]
[]
[null,"Net Fixed Assets - Computer Software",2006,2007,2008,2009,2010]
[]
[null,"Opening Capital Investment",0,{"$f":"C42","v":{"$error":"#REF!"}},{"$f":"D42","v":{"$error":"#REF!"}},{"$f":"E42","v":{"$error":"#REF!"}},{"$f":"F42","v":{"$error":"#REF!"}}]
[null,"Capital Investment (3.  LDC Assumptions and Data)",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Closing Capital Investment",{"$f":"SUM(C40:C41)","v":{"$error":"#REF!"}},{"$f":"SUM(D40:D41)","v":{"$error":"#REF!"}},{"$f":"SUM(E40:E41)","v":{"$error":"#REF!"}},{"$f":"SUM(F40:F41)","v":{"$error":"#REF!"}},{"$f":"SUM(G40:G41)","v":{"$error":"#REF!"}}]
[]
[null,"Opening Accumulated Amortization",0,{"$f":"C46","v":{"$error":"#REF!"}},{"$f":"D46","v":{"$error":"#REF!"}},{"$f":"E46","v":{"$error":"#REF!"}},{"$f":"F46","v":{"$error":"#REF!"}}]
[null,{"$f":"\"Amortization Year 1 (\" &#REF! &\" Years Straight Line)\"","v":{"$error":"#REF!"}},{"$f":"IF(C44+(C40/#REF!)+(C41/#REF!/2)<C42,(C40/#REF!)+(C41/#REF!/2),C42-C44)","v":{"$error":"#REF!"}},{"$f":"IF(D44+(D40/#REF!)+(D41/#REF!/2)<D42,(D40/#REF!)+(D41/#REF!/2),D42-D44)","v":{"$error":"#REF!"}},{"$f":"IF(E44+(E40/#REF!)+(E41/#REF!/2)<E42,(E40/#REF!)+(E41/#REF!/2),E42-E44)","v":{"$error":"#REF!"}},{"$f":"IF(F44+(F40/#REF!)+(F41/#REF!/2)<F42,(F40/#REF!)+(F41/#REF!/2),F42-F44)","v":{"$error":"#REF!"}},{"$f":"IF(G44+(G40/#REF!)+(G41/#REF!/2)<G42,(G40/#REF!)+(G41/#REF!/2),G42-G44)","v":{"$error":"#REF!"}}]
[null,"Closing Accumulated Amortization",{"$f":"SUM(C44:C45)","v":{"$error":"#REF!"}},{"$f":"SUM(D44:D45)","v":{"$error":"#REF!"}},{"$f":"SUM(E44:E45)","v":{"$error":"#REF!"}},{"$f":"SUM(F44:F45)","v":{"$error":"#REF!"}},{"$f":"SUM(G44:G45)","v":{"$error":"#REF!"}}]
[]
[null,"Opening Net Fixed Assets",{"$f":"0","v":0},{"$f":"C49","v":{"$error":"#REF!"}},{"$f":"D49","v":{"$error":"#REF!"}},{"$f":"E49","v":{"$error":"#REF!"}},{"$f":"F49","v":{"$error":"#REF!"}}]
[null,"Closing Net Fixed Assets",{"$f":"C42-C46","v":{"$error":"#REF!"}},{"$f":"D42-D46","v":{"$error":"#REF!"}},{"$f":"E42-E46","v":{"$error":"#REF!"}},{"$f":"F42-F46","v":{"$error":"#REF!"}},{"$f":"G42-G46","v":{"$error":"#REF!"}}]
[null,"Average Net Fixed Assets",{"$f":"(C49+C48)/2","v":{"$error":"#REF!"}},{"$f":"(D49+D48)/2","v":{"$error":"#REF!"}},{"$f":"(E49+E48)/2","v":{"$error":"#REF!"}},{"$f":"(F49+F48)/2","v":{"$error":"#REF!"}},{"$f":"(G49+G48)/2","v":{"$error":"#REF!"}}]
[]
[]
[null,"Net Fixed Assets - Tools & Equipment",2006,2007,2008,2009,2010]
[]
[null,"Opening Capital Investment",0,{"$f":"C57","v":{"$error":"#REF!"}},{"$f":"D57","v":{"$error":"#REF!"}},{"$f":"E57","v":{"$error":"#REF!"}},{"$f":"F57","v":{"$error":"#REF!"}}]
[null,"Capital Investment (3.  LDC Assumptions and Data)",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Closing Capital Investment",{"$f":"SUM(C55:C56)","v":{"$error":"#REF!"}},{"$f":"SUM(D55:D56)","v":{"$error":"#REF!"}},{"$f":"SUM(E55:E56)","v":{"$error":"#REF!"}},{"$f":"SUM(F55:F56)","v":{"$error":"#REF!"}},{"$f":"SUM(G55:G56)","v":{"$error":"#REF!"}}]
[]
[null,"Opening Accumulated Amortization",0,{"$f":"C61","v":{"$error":"#REF!"}},{"$f":"D61","v":{"$error":"#REF!"}},{"$f":"E61","v":{"$error":"#REF!"}},{"$f":"F61","v":{"$error":"#REF!"}}]
[null,{"$f":"\"Amortization Year 1 (\" &#REF! &\" Years Straight Line)\"","v":{"$error":"#REF!"}},{"$f":"IF(C59+(C55/#REF!)+(C56/#REF!/2)<C57,(C55/#REF!)+(C56/#REF!/2),C57-C59)","v":{"$error":"#REF!"}},{"$f":"IF(D59+(D55/#REF!)+(D56/#REF!/2)<D57,(D55/#REF!)+(D56/#REF!/2),D57-D59)","v":{"$error":"#REF!"}},{"$f":"IF(E59+(E55/#REF!)+(E56/#REF!/2)<E57,(E55/#REF!)+(E56/#REF!/2),E57-E59)","v":{"$error":"#REF!"}},{"$f":"IF(F59+(F55/#REF!)+(F56/#REF!/2)<F57,(F55/#REF!)+(F56/#REF!/2),F57-F59)","v":{"$error":"#REF!"}},{"$f":"IF(G59+(G55/#REF!)+(G56/#REF!/2)<G57,(G55/#REF!)+(G56/#REF!/2),G57-G59)","v":{"$error":"#REF!"}}]
[null,"Closing Accumulated Amortization",{"$f":"SUM(C59:C60)","v":{"$error":"#REF!"}},{"$f":"SUM(D59:D60)","v":{"$error":"#REF!"}},{"$f":"SUM(E59:E60)","v":{"$error":"#REF!"}},{"$f":"SUM(F59:F60)","v":{"$error":"#REF!"}},{"$f":"SUM(G59:G60)","v":{"$error":"#REF!"}}]
[]
[null,"Opening Net Fixed Assets",{"$f":"0","v":0},{"$f":"C64","v":{"$error":"#REF!"}},{"$f":"D64","v":{"$error":"#REF!"}},{"$f":"E64","v":{"$error":"#REF!"}},{"$f":"F64","v":{"$error":"#REF!"}}]
[null,"Closing Net Fixed Assets",{"$f":"C57-C61","v":{"$error":"#REF!"}},{"$f":"D57-D61","v":{"$error":"#REF!"}},{"$f":"E57-E61","v":{"$error":"#REF!"}},{"$f":"F57-F61","v":{"$error":"#REF!"}},{"$f":"G57-G61","v":{"$error":"#REF!"}}]
[null,"Average Net Fixed Assets",{"$f":"(C64+C63)/2","v":{"$error":"#REF!"}},{"$f":"(D64+D63)/2","v":{"$error":"#REF!"}},{"$f":"(E64+E63)/2","v":{"$error":"#REF!"}},{"$f":"(F64+F63)/2","v":{"$error":"#REF!"}},{"$f":"(G64+G63)/2","v":{"$error":"#REF!"}}]
[]
[null,"Net Fixed Assets - Other Equipment",2006,2007,2008,2009,2010]
[]
[null,"Opening Capital Investment",0,{"$f":"C71","v":{"$error":"#REF!"}},{"$f":"D71","v":{"$error":"#REF!"}},{"$f":"E71","v":{"$error":"#REF!"}},{"$f":"F71","v":{"$error":"#REF!"}}]
[null,"Capital Investment (3.  LDC Assumptions and Data)",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Closing Capital Investment",{"$f":"SUM(C69:C70)","v":{"$error":"#REF!"}},{"$f":"SUM(D69:D70)","v":{"$error":"#REF!"}},{"$f":"SUM(E69:E70)","v":{"$error":"#REF!"}},{"$f":"SUM(F69:F70)","v":{"$error":"#REF!"}},{"$f":"SUM(G69:G70)","v":{"$error":"#REF!"}}]
[]
[null,"Opening Accumulated Amortization",0,{"$f":"C75","v":{"$error":"#REF!"}},{"$f":"D75","v":{"$error":"#REF!"}},{"$f":"E75","v":{"$error":"#REF!"}},{"$f":"F75","v":{"$error":"#REF!"}}]
[null,{"$f":"\"Amortization Year 1 (\" &#REF! &\" Years Straight Line)\"","v":{"$error":"#REF!"}},{"$f":"IF(C73+(C69/#REF!)+(C70/#REF!/2)<C71,(C69/#REF!)+(C70/#REF!/2),C71-C73)","v":{"$error":"#REF!"}},{"$f":"IF(D73+(D69/#REF!)+(D70/#REF!/2)<D71,(D69/#REF!)+(D70/#REF!/2),D71-D73)","v":{"$error":"#REF!"}},{"$f":"IF(E73+(E69/#REF!)+(E70/#REF!/2)<E71,(E69/#REF!)+(E70/#REF!/2),E71-E73)","v":{"$error":"#REF!"}},{"$f":"IF(F73+(F69/#REF!)+(F70/#REF!/2)<F71,(F69/#REF!)+(F70/#REF!/2),F71-F73)","v":{"$error":"#REF!"}},{"$f":"IF(G73+(G69/#REF!)+(G70/#REF!/2)<G71,(G69/#REF!)+(G70/#REF!/2),G71-G73)","v":{"$error":"#REF!"}}]
[null,"Closing Accumulated Amortization",{"$f":"SUM(C73:C74)","v":{"$error":"#REF!"}},{"$f":"SUM(D73:D74)","v":{"$error":"#REF!"}},{"$f":"SUM(E73:E74)","v":{"$error":"#REF!"}},{"$f":"SUM(F73:F74)","v":{"$error":"#REF!"}},{"$f":"SUM(G73:G74)","v":{"$error":"#REF!"}}]
[]
[null,"Opening Net Fixed Assets",{"$f":"0","v":0},{"$f":"C78","v":{"$error":"#REF!"}},{"$f":"D78","v":{"$error":"#REF!"}},{"$f":"E78","v":{"$error":"#REF!"}},{"$f":"F78","v":{"$error":"#REF!"}}]
[null,"Closing Net Fixed Assets",{"$f":"C71-C75","v":{"$error":"#REF!"}},{"$f":"D71-D75","v":{"$error":"#REF!"}},{"$f":"E71-E75","v":{"$error":"#REF!"}},{"$f":"F71-F75","v":{"$error":"#REF!"}},{"$f":"G71-G75","v":{"$error":"#REF!"}}]
[null,"Average Net Fixed Assets",{"$f":"(C78+C77)/2","v":{"$error":"#REF!"}},{"$f":"(D78+D77)/2","v":{"$error":"#REF!"}},{"$f":"(E78+E77)/2","v":{"$error":"#REF!"}},{"$f":"(F78+F77)/2","v":{"$error":"#REF!"}},{"$f":"(G78+G77)/2","v":{"$error":"#REF!"}}]
[]
[]
[null,"For PILs Calculation"]
[]
[null,"UCC - Smart Meters"]
[null,"CCA Class 47 (8%)",2006,2007,2008,2009,2010]
[]
[null,"Opening UCC",0,{"$f":"C89-C93","v":{"$error":"#REF!"}},{"$f":"D89-D93","v":{"$error":"#REF!"}},{"$f":"E89-E93","v":{"$error":"#REF!"}},{"$f":"F89-F93","v":{"$error":"#REF!"}}]
[null,"Capital Additions",{"$f":"C13","v":{"$error":"#REF!"}},{"$f":"D13","v":{"$error":"#REF!"}},{"$f":"E13","v":{"$error":"#REF!"}},{"$f":"F13","v":{"$error":"#REF!"}},{"$f":"G13","v":{"$error":"#REF!"}}]
[null,"UCC Before Half Year Rule",{"$f":"SUM(C87:C88)","v":{"$error":"#REF!"}},{"$f":"SUM(D87:D88)","v":{"$error":"#REF!"}},{"$f":"SUM(E87:E88)","v":{"$error":"#REF!"}},{"$f":"SUM(F87:F88)","v":{"$error":"#REF!"}},{"$f":"SUM(G87:G88)","v":{"$error":"#REF!"}}]
[null,"Half Year Rule (1/2 Additions - Disposals)",{"$f":"SUM(C88:C88)/2","v":{"$error":"#REF!"}},{"$f":"SUM(D88:D88)/2","v":{"$error":"#REF!"}},{"$f":"SUM(E88:E88)/2","v":{"$error":"#REF!"}},{"$f":"SUM(F88:F88)/2","v":{"$error":"#REF!"}},{"$f":"SUM(G88:G88)/2","v":{"$error":"#REF!"}}]
[null,"Reduced UCC",{"$f":"C87+C90","v":{"$error":"#REF!"}},{"$f":"D87+D90","v":{"$error":"#REF!"}},{"$f":"E87+E90","v":{"$error":"#REF!"}},{"$f":"F87+F90","v":{"$error":"#REF!"}},{"$f":"G87+G90","v":{"$error":"#REF!"}}]
[null,"CCA Rate Class  47",0.08,0.08,0.08,0.08,0.08]
[null,"CCA",{"$f":"IF((C91*C92)<C91,(C91*C92),C91)","v":{"$error":"#REF!"}},{"$f":"IF((D91*D92)<D91,(D91*D92),D91)","v":{"$error":"#REF!"}},{"$f":"IF((E91*E92)<E91,(E91*E92),E91)","v":{"$error":"#REF!"}},{"$f":"IF((F91*F92)<F91,(F91*F92),F91)","v":{"$error":"#REF!"}},{"$f":"IF((G91*G92)<G91,(G91*G92),G91)","v":{"$error":"#REF!"}}]
[null,"Closing UCC",{"$f":"IF((C89-C93)<0,0,(C89-C93))","v":{"$error":"#REF!"}},{"$f":"IF((D89-D93)<0,0,(D89-D93))","v":{"$error":"#REF!"}},{"$f":"IF((E89-E93)<0,0,(E89-E93))","v":{"$error":"#REF!"}},{"$f":"IF((F89-F93)<0,0,(F89-F93))","v":{"$error":"#REF!"}},{"$f":"IF((G89-G93)<0,0,(G89-G93))","v":{"$error":"#REF!"}}]
[]
[null,"UCC - Computer Equipment"]
[null,"CCA Class 45 (45%)",2006,2007,2008,2009,2010]
[]
[null,"Opening UCC",0,{"$f":"C107","v":{"$error":"#REF!"}},{"$f":"D107","v":{"$error":"#REF!"}},{"$f":"E107","v":{"$error":"#REF!"}},{"$f":"F107","v":{"$error":"#REF!"}}]
[null,"Capital Additions Computer Hardware",{"$f":"C27","v":{"$error":"#REF!"}},{"$f":"D27","v":{"$error":"#REF!"}},{"$f":"E27","v":{"$error":"#REF!"}},{"$f":"F27","v":{"$error":"#REF!"}},{"$f":"G27","v":{"$error":"#REF!"}}]
[null,"Capital Additions Computer Software",{"$f":"C41","v":{"$error":"#REF!"}},{"$f":"D41","v":{"$error":"#REF!"}},{"$f":"E41","v":{"$error":"#REF!"}},{"$f":"F41","v":{"$error":"#REF!"}},{"$f":"G41","v":{"$error":"#REF!"}}]
[null,"UCC Before Half Year Rule",{"$f":"SUM(C99:C101)","v":{"$error":"#REF!"}},{"$f":"SUM(D99:D101)","v":{"$error":"#REF!"}},{"$f":"SUM(E99:E101)","v":{"$error":"#REF!"}},{"$f":"SUM(F99:F101)","v":{"$error":"#REF!"}},{"$f":"SUM(G99:G101)","v":{"$error":"#REF!"}}]
[null,"Half Year Rule (1/2 Additions - Disposals)",{"$f":"SUM(C100:C101)/2","v":{"$error":"#REF!"}},{"$f":"SUM(D100:D101)/2","v":{"$error":"#REF!"}},{"$f":"SUM(E100:E101)/2","v":{"$error":"#REF!"}},{"$f":"SUM(F100:F101)/2","v":{"$error":"#REF!"}},{"$f":"SUM(G100:G101)/2","v":{"$error":"#REF!"}}]
[null,"Reduced UCC",{"$f":"C99+C103","v":{"$error":"#REF!"}},{"$f":"D99+D103","v":{"$error":"#REF!"}},{"$f":"E99+E103","v":{"$error":"#REF!"}},{"$f":"F99+F103","v":{"$error":"#REF!"}},{"$f":"G99+G103","v":{"$error":"#REF!"}}]
[null,"CCA Rate Class  45",0.45,0.45,0.45,0.45,0.45]
[null,"CCA",{"$f":"IF((C104*C105)<C104,(C104*C105),C104)","v":{"$error":"#REF!"}},{"$f":"IF((D104*D105)<D104,(D104*D105),D104)","v":{"$error":"#REF!"}},{"$f":"IF((E104*E105)<E104,(E104*E105),E104)","v":{"$error":"#REF!"}},{"$f":"IF((F104*F105)<F104,(F104*F105),F104)","v":{"$error":"#REF!"}},{"$f":"IF((G104*G105)<G104,(G104*G105),G104)","v":{"$error":"#REF!"}}]
[null,"Closing UCC",{"$f":"IF((C102-C106)<0,0,(C102-C106))","v":{"$error":"#REF!"}},{"$f":"IF((D102-D106)<0,0,(D102-D106))","v":{"$error":"#REF!"}},{"$f":"IF((E102-E106)<0,0,(E102-E106))","v":{"$error":"#REF!"}},{"$f":"IF((F102-F106)<0,0,(F102-F106))","v":{"$error":"#REF!"}},{"$f":"IF((G102-G106)<0,0,(G102-G106))","v":{"$error":"#REF!"}}]
[]
[null,"UCC - General Equipment"]
[null,"CCA Class 8 (20%)",2006,2007,2008,2009,2010]
[]
[null,"Opening UCC",0,{"$f":"C120","v":{"$error":"#REF!"}},{"$f":"D120","v":{"$error":"#REF!"}},{"$f":"E120","v":{"$error":"#REF!"}},{"$f":"F120","v":{"$error":"#REF!"}}]
[null,"Capital Additions Tools & Equipment",{"$f":"C56","v":{"$error":"#REF!"}},{"$f":"D56","v":{"$error":"#REF!"}},{"$f":"E56","v":{"$error":"#REF!"}},{"$f":"F56","v":{"$error":"#REF!"}},{"$f":"G56","v":{"$error":"#REF!"}}]
[null,"Capital Additions Other Equipment",{"$f":"C70","v":{"$error":"#REF!"}},{"$f":"D70","v":{"$error":"#REF!"}},{"$f":"E70","v":{"$error":"#REF!"}},{"$f":"F70","v":{"$error":"#REF!"}},{"$f":"G70","v":{"$error":"#REF!"}}]
[null,"UCC Before Half Year Rule",{"$f":"SUM(C112:C114)","v":{"$error":"#REF!"}},{"$f":"SUM(D112:D114)","v":{"$error":"#REF!"}},{"$f":"SUM(E112:E114)","v":{"$error":"#REF!"}},{"$f":"SUM(F112:F114)","v":{"$error":"#REF!"}},{"$f":"SUM(G112:G114)","v":{"$error":"#REF!"}}]
[null,"Half Year Rule (1/2 Additions - Disposals)",{"$f":"SUM(C113:C114)/2","v":{"$error":"#REF!"}},{"$f":"SUM(D113:D114)/2","v":{"$error":"#REF!"}},{"$f":"SUM(E113:E114)/2","v":{"$error":"#REF!"}},{"$f":"SUM(F113:F114)/2","v":{"$error":"#REF!"}},{"$f":"SUM(G113:G114)/2","v":{"$error":"#REF!"}}]
[null,"Reduced UCC",{"$f":"C112+C116","v":{"$error":"#REF!"}},{"$f":"D112+D116","v":{"$error":"#REF!"}},{"$f":"E112+E116","v":{"$error":"#REF!"}},{"$f":"F112+F116","v":{"$error":"#REF!"}},{"$f":"G112+G116","v":{"$error":"#REF!"}}]
[null,"CCA Rate Class  8",0.2,0.2,0.2,0.2,0.2]
[null,"CCA",{"$f":"IF((C117*C118)<C117,(C117*C118),C117)","v":{"$error":"#REF!"}},{"$f":"IF((D117*D118)<D117,(D117*D118),D117)","v":{"$error":"#REF!"}},{"$f":"IF((E117*E118)<E117,(E117*E118),E117)","v":{"$error":"#REF!"}},{"$f":"IF((F117*F118)<F117,(F117*F118),F117)","v":{"$error":"#REF!"}},{"$f":"IF((G117*G118)<G117,(G117*G118),G117)","v":{"$error":"#REF!"}}]
[null,"Closing UCC",{"$f":"IF((C115-C119)<0,0,(C115-C119))","v":{"$error":"#REF!"}},{"$f":"IF((D115-D119)<0,0,(D115-D119))","v":{"$error":"#REF!"}},{"$f":"IF((E115-E119)<0,0,(E115-E119))","v":{"$error":"#REF!"}},{"$f":"IF((F115-F119)<0,0,(F115-F119))","v":{"$error":"#REF!"}},{"$f":"IF((G115-G119)<0,0,(G115-G119))","v":{"$error":"#REF!"}}]

{"sheet":"10. 2007A Smart Meter Rate Calc","index":6,"n_rows":63,"n_cols":14,"rows_kept":63,"cut":false,"hidden":true,"merged":[[0,1,0,4],[4,1,4,3],[9,5,9,7],[9,8,9,10],[9,11,9,13],[9,2,9,4],[1,1,1,4],[2,1,2,4]]}
[]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Sheet 10. Smart Meter Rate Calc"]
[]
[]
["Smart Meter Rate Calculation"]
[]
[null,"Average Asset Values",2007,null,null,2008,null,null,2009,null,null,2010]
[null,"Net Fixed Assets Smart Meters",{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!C22","v":{"$error":"#REF!"}},null,null,{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!D22","v":{"$error":"#REF!"}},null,null,{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!E22","v":{"$error":"#REF!"}},null,null,{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!F22","v":{"$error":"#REF!"}}]
[null,"Net Fixed Assets Computer Hardware",{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!C36","v":{"$error":"#REF!"}},null,null,{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!D36","v":{"$error":"#REF!"}},null,null,{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!E36","v":{"$error":"#REF!"}},null,null,{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!F36","v":{"$error":"#REF!"}}]
[null,"Net Fixed Assets Computer Software",{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!C50","v":{"$error":"#REF!"}},null,null,{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!D50","v":{"$error":"#REF!"}},null,null,{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!E50","v":{"$error":"#REF!"}},null,null,{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!F50","v":{"$error":"#REF!"}}]
[null,"Net Fixed Assets Tools & Equipment",{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!C65","v":{"$error":"#REF!"}},null,null,{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!D65","v":{"$error":"#REF!"}},null,null,{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!E65","v":{"$error":"#REF!"}},null,null,{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!F65","v":{"$error":"#REF!"}}]
[null,"Net Fixed Assets Other Equipment",{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!C79","v":{"$error":"#REF!"}},null,null,{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!D79","v":{"$error":"#REF!"}},null,null,{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!E79","v":{"$error":"#REF!"}},null,null,{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!F79","v":{"$error":"#REF!"}}]
[null,"Total Net Fixed Assets",{"$f":"SUM(C11:C15)","v":{"$error":"#REF!"}},{"$f":"C16","v":{"$error":"#REF!"}},null,{"$f":"SUM(F11:F15)","v":{"$error":"#REF!"}},{"$f":"F16","v":{"$error":"#REF!"}},null,{"$f":"SUM(I11:I15)","v":{"$error":"#REF!"}},{"$f":"I16","v":{"$error":"#REF!"}},null,{"$f":"SUM(L11:L15)","v":{"$error":"#REF!"}},{"$f":"L16","v":{"$error":"#REF!"}}]
[]
[null,"Working Capital"]
[null,"Operation Expense",{"$f":"E34","v":{"$error":"#REF!"}},null,null,{"$f":"H34","v":{"$error":"#REF!"}},null,null,{"$f":"K34","v":{"$error":"#REF!"}},null,null,{"$f":"N34","v":{"$error":"#REF!"}}]
[null,{"$f":"\"Working Capital \"&#REF!*100&\" %\"","v":{"$error":"#REF!"}},{"$f":"C19*#REF!","v":{"$error":"#REF!"}},{"$f":"C20","v":{"$error":"#REF!"}},null,{"$f":"F19*#REF!","v":{"$error":"#REF!"}},{"$f":"F20","v":{"$error":"#REF!"}},null,{"$f":"I19*#REF!","v":{"$error":"#REF!"}},{"$f":"I20","v":{"$error":"#REF!"}},null,{"$f":"L19*#REF!","v":{"$error":"#REF!"}},{"$f":"L20","v":{"$error":"#REF!"}}]
[]
[null,"Smart Meters included in Rate Base",null,{"$f":"SUM(D12:D20)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(G12:G20)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(J12:J20)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(M12:M20)","v":{"$error":"#REF!"}}]
[]
[null,"Return on Rate Base"]
[null,"Deemed Debt (3.  LDC Assumptions and Data)",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"D22*C25","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"G22*F25","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"J22*I25","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"M22*L25","v":{"$error":"#REF!"}}]
[null,"Deemed Equity (3.  LDC Assumptions and Data)",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"D22*C26","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"G22*F26","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"J22*I26","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"M22*L26","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"SUM(D25:D26)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(G25:G26)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(J25:J26)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(M25:M26)","v":{"$error":"#REF!"}}]
[]
[null,"Weighted Debt Rate (3.  LDC Assumptions and Data)",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"D25*C29","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"G25*F29","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"J25*I29","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"M25*L29","v":{"$error":"#REF!"}}]
[null,"Proposed ROE (3.  LDC Assumptions and Data)",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"D26*C30","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"G26*F30","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"J26*I30","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"M26*L30","v":{"$error":"#REF!"}}]
[null,"Return on Rate Base",null,{"$f":"SUM(D29:D30)","v":{"$error":"#REF!"}},{"$f":"D31","v":{"$error":"#REF!"}},null,{"$f":"SUM(G29:G30)","v":{"$error":"#REF!"}},{"$f":"G31","v":{"$error":"#REF!"}},null,{"$f":"SUM(J29:J30)","v":{"$error":"#REF!"}},{"$f":"J31","v":{"$error":"#REF!"}},null,{"$f":"SUM(M29:M30)","v":{"$error":"#REF!"}},{"$f":"M31","v":{"$error":"#REF!"}}]
[]
[null,"Operating Expenses"]
[null,"Incremental Operating Expenses (3.  LDC Assumptions and Data)",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Amortization Expenses"]
[null,"Amortization Expenses - Smart Meters",null,{"$f":"SUM('12. 2007A SM Nt Fix Ass &UCC'!C17:C17)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('12. 2007A SM Nt Fix Ass &UCC'!D17:D17)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('12. 2007A SM Nt Fix Ass &UCC'!E17:E17)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('12. 2007A SM Nt Fix Ass &UCC'!F17:F17)","v":{"$error":"#REF!"}}]
[null,"Amortization Expenses - Computer Hardware",null,{"$f":"SUM('12. 2007A SM Nt Fix Ass &UCC'!C31:C31)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('12. 2007A SM Nt Fix Ass &UCC'!D31:D31)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('12. 2007A SM Nt Fix Ass &UCC'!E31:E31)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('12. 2007A SM Nt Fix Ass &UCC'!F31:F31)","v":{"$error":"#REF!"}}]
[null,"Amortization Expenses - Computer Software",null,{"$f":"SUM('12. 2007A SM Nt Fix Ass &UCC'!C45:C45)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('12. 2007A SM Nt Fix Ass &UCC'!D45:D45)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('12. 2007A SM Nt Fix Ass &UCC'!E45:E45)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('12. 2007A SM Nt Fix Ass &UCC'!F45:F45)","v":{"$error":"#REF!"}}]
[null,"Amortization Expenses -  Tools & Equipment",null,{"$f":"SUM('12. 2007A SM Nt Fix Ass &UCC'!C60:C60)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('12. 2007A SM Nt Fix Ass &UCC'!D60:D60)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('12. 2007A SM Nt Fix Ass &UCC'!E60:E60)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('12. 2007A SM Nt Fix Ass &UCC'!F60:F60)","v":{"$error":"#REF!"}}]
[null,"Amortization Expenses - Other Equipment",null,{"$f":"SUM('12. 2007A SM Nt Fix Ass &UCC'!C74:C74)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('12. 2007A SM Nt Fix Ass &UCC'!D74:D74)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('12. 2007A SM Nt Fix Ass &UCC'!E74:E74)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM('12. 2007A SM Nt Fix Ass &UCC'!F74:F74)","v":{"$error":"#REF!"}}]
[null,"Total Amortization Expenses",null,null,{"$f":"SUM(D37:D41)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(G37:G41)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(J37:J41)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(M37:M41)","v":{"$error":"#REF!"}}]
[]
[null,"Revenue Requirement Before PILs",null,null,{"$f":"SUM(E31,E42,E34)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(H31,H42,H34)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(K31,K42,K34)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(N31,N42,N34)","v":{"$error":"#REF!"}}]
[]
[null,"Calculation of Taxable Income"]
[null,"Incremental Operating Expenses",null,null,{"$f":"-E34","v":{"$error":"#REF!"}},null,null,{"$f":"-H34","v":{"$error":"#REF!"}},null,null,{"$f":"-K34","v":{"$error":"#REF!"}},null,null,{"$f":"-N34","v":{"$error":"#REF!"}}]
[null,"Depreciation Expenses",null,null,{"$f":"-E42","v":{"$error":"#REF!"}},null,null,{"$f":"-H42","v":{"$error":"#REF!"}},null,null,{"$f":"-K42","v":{"$error":"#REF!"}},null,null,{"$f":"-N42","v":{"$error":"#REF!"}}]
[null,"Interest Expense",null,null,{"$f":"-D29","v":{"$error":"#REF!"}},null,null,{"$f":"-G29","v":{"$error":"#REF!"}},null,null,{"$f":"-J29","v":{"$error":"#REF!"}},null,null,{"$f":"-M29","v":{"$error":"#REF!"}}]
[null,"Taxable Income For PILs",null,null,{"$f":"SUM(E44:E49)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(H44:H49)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(K44:K49)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(N44:N49)","v":{"$error":"#REF!"}}]
[]
[null,"Grossed up PILs (5. PILs)",null,null,{"$f":"'11. 2007A PILs'!C46","v":{"$error":"#REF!"}},null,null,{"$f":"'11. 2007A PILs'!D46","v":{"$error":"#REF!"}},null,null,{"$f":"'11. 2007A PILs'!E46","v":{"$error":"#REF!"}},null,null,{"$f":"'11. 2007A PILs'!F46","v":{"$error":"#REF!"}}]
[]
[null,{"$f":"B44","v":"Revenue Requirement Before PILs"},null,null,{"$f":"E44","v":{"$error":"#REF!"}},null,null,{"$f":"H44","v":{"$error":"#REF!"}},null,null,{"$f":"K44","v":{"$error":"#REF!"}},null,null,{"$f":"N44","v":{"$error":"#REF!"}}]
[null,"Grossed up PILs (5. PILs)",null,null,{"$f":"E52","v":{"$error":"#REF!"}},null,null,{"$f":"H52","v":{"$error":"#REF!"}},null,null,{"$f":"K52","v":{"$error":"#REF!"}},null,null,{"$f":"N52","v":{"$error":"#REF!"}}]
[null,"Revenue Requirement for Smart Meters",null,null,{"$f":"SUM(E54:E55)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(H54:H55)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(K54:K55)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(N54:N55)","v":{"$error":"#REF!"}}]
[]
[null,"2007 Smart Meter Rate Adder"]
[null,"Revenue Requirement for Smart Meters",null,null,{"$f":"E56","v":{"$error":"#REF!"}},null,null,{"$f":"H56","v":{"$error":"#REF!"}},null,null,{"$f":"K56","v":{"$error":"#REF!"}},null,null,{"$f":"N56","v":{"$error":"#REF!"}}]
[null,"2006 EDR Total Metered Customers (3.  LDC Assumptions and Data)",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Annualized amount required per metered customer",null,null,{"$f":"IF(ISERROR(E59/E60),0,E59/E60)","v":0},null,null,{"$f":"IF(ISERROR(H59/H60),0,H59/H60)","v":0},null,null,{"$f":"IF(ISERROR(K59/K60),0,K59/K60)","v":0},null,null,{"$f":"IF(ISERROR(N59/N60),0,N59/N60)","v":0}]
[null,"Number of months in year",null,null,12,null,null,12,null,null,12,null,null,12]
[null,"2007 Smart Meter Rate Adder",null,null,{"$f":"E61/E62","v":0},null,null,{"$f":"H61/H62","v":0},null,null,{"$f":"K61/K62","v":0},null,null,{"$f":"N61/N62","v":0}]

{"sheet":"11. 2007A PILs","index":7,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":true,"merged":[[1,1,1,4],[2,1,2,4],[0,1,0,4],[4,1,4,4]]}
[]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Sheet 11. PILs"]
[]
[]
[null,"PILs Calculation"]
[]
[null,null,2007,2008,2009,2010]
[null,"INCOME TAX"]
[null,"Net Income",{"$f":"'10. 2007A Smart Meter Rate Calc'!E50","v":{"$error":"#REF!"}},{"$f":"'10. 2007A Smart Meter Rate Calc'!H50","v":{"$error":"#REF!"}},{"$f":"'10. 2007A Smart Meter Rate Calc'!K50","v":{"$error":"#REF!"}},{"$f":"'10. 2007A Smart Meter Rate Calc'!N50","v":{"$error":"#REF!"}}]
[null,"Amortization ",{"$f":"-'10. 2007A Smart Meter Rate Calc'!E48","v":{"$error":"#REF!"}},{"$f":"-'10. 2007A Smart Meter Rate Calc'!H48","v":{"$error":"#REF!"}},{"$f":"-'10. 2007A Smart Meter Rate Calc'!K48","v":{"$error":"#REF!"}},{"$f":"-'10. 2007A Smart Meter Rate Calc'!N48","v":{"$error":"#REF!"}}]
[null,"CCA - Class 47 (8%) Smart Meters",{"$f":"-'12. 2007A SM Nt Fix Ass &UCC'!C93","v":{"$error":"#REF!"}},{"$f":"-'12. 2007A SM Nt Fix Ass &UCC'!D93","v":{"$error":"#REF!"}},{"$f":"-'12. 2007A SM Nt Fix Ass &UCC'!E93","v":{"$error":"#REF!"}},{"$f":"-'12. 2007A SM Nt Fix Ass &UCC'!F93","v":{"$error":"#REF!"}}]
[null,"CCA - Class 45 (45%) Computers",{"$f":"-'12. 2007A SM Nt Fix Ass &UCC'!C106","v":{"$error":"#REF!"}},{"$f":"-'12. 2007A SM Nt Fix Ass &UCC'!D106","v":{"$error":"#REF!"}},{"$f":"-'12. 2007A SM Nt Fix Ass &UCC'!E106","v":{"$error":"#REF!"}},{"$f":"-'12. 2007A SM Nt Fix Ass &UCC'!F106","v":{"$error":"#REF!"}}]
[null,"CCA - Class 8 (20%) Other Equipment",{"$f":"-'12. 2007A SM Nt Fix Ass &UCC'!C119","v":{"$error":"#REF!"}},{"$f":"-'12. 2007A SM Nt Fix Ass &UCC'!D119","v":{"$error":"#REF!"}},{"$f":"-'12. 2007A SM Nt Fix Ass &UCC'!E119","v":{"$error":"#REF!"}},{"$f":"-'12. 2007A SM Nt Fix Ass &UCC'!F119","v":{"$error":"#REF!"}}]
[null,"Change in taxable income",{"$f":"SUM(C12:C16)","v":{"$error":"#REF!"}},{"$f":"SUM(D12:D16)","v":{"$error":"#REF!"}},{"$f":"SUM(E12:E16)","v":{"$error":"#REF!"}},{"$f":"SUM(F12:F16)","v":{"$error":"#REF!"}}]
[null,"Tax Rate (3.  LDC Assumptions and Data)",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Income Taxes Payable",{"$f":"C17*C18","v":{"$error":"#REF!"}},{"$f":"D17*D18","v":{"$error":"#REF!"}},{"$f":"E17*E18","v":{"$error":"#REF!"}},{"$f":"F17*F18","v":{"$error":"#REF!"}}]
[]
[null,"ONTARIO CAPITAL TAX"]
[null,"Smart Meters",{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!C21","v":{"$error":"#REF!"}},{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!D21","v":{"$error":"#REF!"}},{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!E21","v":{"$error":"#REF!"}},{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!F21","v":{"$error":"#REF!"}}]
[null,"Computer Hardware",{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!C35","v":{"$error":"#REF!"}},{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!D35","v":{"$error":"#REF!"}},{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!E35","v":{"$error":"#REF!"}},{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!F35","v":{"$error":"#REF!"}}]
[null,"Computer Software",{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!C49","v":{"$error":"#REF!"}},{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!D49","v":{"$error":"#REF!"}},{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!E49","v":{"$error":"#REF!"}},{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!F49","v":{"$error":"#REF!"}}]
[null,"Tools & Equipment",{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!C64","v":{"$error":"#REF!"}},{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!D64","v":{"$error":"#REF!"}},{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!E64","v":{"$error":"#REF!"}},{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!F64","v":{"$error":"#REF!"}}]
[null,"Other Equipment",{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!C78","v":{"$error":"#REF!"}},{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!D78","v":{"$error":"#REF!"}},{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!E78","v":{"$error":"#REF!"}},{"$f":"'12. 2007A SM Nt Fix Ass &UCC'!F78","v":{"$error":"#REF!"}}]
[null,"Rate Base",{"$f":"SUM(C22:C24)","v":{"$error":"#REF!"}},{"$f":"SUM(D22:D24)","v":{"$error":"#REF!"}},{"$f":"SUM(E22:E24)","v":{"$error":"#REF!"}},{"$f":"SUM(F22:F24)","v":{"$error":"#REF!"}}]
[null,"Less: Exemption",0,0,0,0]
[null,"Deemed Taxable Capital",{"$f":"C27-C28","v":{"$error":"#REF!"}},{"$f":"D27-D28","v":{"$error":"#REF!"}},{"$f":"E27-E28","v":{"$error":"#REF!"}},{"$f":"F27-F28","v":{"$error":"#REF!"}}]
[null,"Ontario Capital Tax Rate",3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3]
[null,"Net Amount (Taxable Capital x Rate)",{"$f":"C29*C30","v":{"$error":"#REF!"}},{"$f":"D29*D30","v":{"$error":"#REF!"}},{"$f":"E29*E30","v":{"$error":"#REF!"}},{"$f":"F29*F30","v":{"$error":"#REF!"}}]
[]
[]
[null,"Gross Up"]
[null,null,"PILs Payable","PILs Payable","PILs Payable","PILs Payable"]
[null,"Change in Income Taxes Payable",{"$f":"C19","v":{"$error":"#REF!"}},{"$f":"D19","v":{"$error":"#REF!"}},{"$f":"E19","v":{"$error":"#REF!"}},{"$f":"F19","v":{"$error":"#REF!"}}]
[null,"Change in OCT",{"$f":"C31","v":{"$error":"#REF!"}},{"$f":"D31","v":{"$error":"#REF!"}},{"$f":"E31","v":{"$error":"#REF!"}},{"$f":"F31","v":{"$error":"#REF!"}}]
[null,"PIL's",{"$f":"SUM(C36:C37)","v":{"$error":"#REF!"}},{"$f":"SUM(D36:D37)","v":{"$error":"#REF!"}},{"$f":"SUM(E36:E37)","v":{"$error":"#REF!"}},{"$f":"SUM(F36:F37)","v":{"$error":"#REF!"}}]
[]
[null,null,"Gross Up","Gross Up","Gross Up","Gross Up"]
[null,null,{"$f":"$C$18","v":{"$error":"#REF!"}},{"$f":"$C$18","v":{"$error":"#REF!"}},{"$f":"$C$18","v":{"$error":"#REF!"}},{"$f":"$C$18","v":{"$error":"#REF!"}}]
[]
[null,null,"Grossed Up PILs","Grossed Up PILs","Grossed Up PILs","Grossed Up PILs"]
[null,"Change in Income Taxes Payable",{"$f":"C36/(1-C41)","v":{"$error":"#REF!"}},{"$f":"D36/(1-D41)","v":{"$error":"#REF!"}},{"$f":"E36/(1-E41)","v":{"$error":"#REF!"}},{"$f":"F36/(1-F41)","v":{"$error":"#REF!"}}]
[null,"Change in OCT",{"$f":"C37","v":{"$error":"#REF!"}},{"$f":"D37","v":{"$error":"#REF!"}},{"$f":"E37","v":{"$error":"#REF!"}},{"$f":"F37","v":{"$error":"#REF!"}}]
[null,"PIL's",{"$f":"SUM(C44:C45)","v":{"$error":"#REF!"}},{"$f":"SUM(D44:D45)","v":{"$error":"#REF!"}},{"$f":"SUM(E44:E45)","v":{"$error":"#REF!"}},{"$f":"SUM(F44:F45)","v":{"$error":"#REF!"}}]

{"sheet":"12. 2007A SM Nt Fix Ass &UCC","index":8,"n_rows":120,"n_cols":6,"rows_kept":120,"cut":false,"hidden":true,"merged":[[1,1,1,4],[2,1,2,4],[0,1,0,4],[4,1,4,4]]}
[]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Sheet 12. SM Avg Net Fixed Assets &UCC"]
[]
[]
[null,"Smart Meter Average Net Fixed Assets"]
[]
[null,"Net Fixed Assets - Smart Meters",2007,2008,2009,2010]
[]
[null,"Opening Capital Investment",0,{"$f":"C14","v":{"$error":"#REF!"}},{"$f":"D14","v":{"$error":"#REF!"}},{"$f":"E14","v":{"$error":"#REF!"}}]
[null,"Capital Investment (3.  LDC Assumptions and Data)",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Closing Capital Investment",{"$f":"SUM(C12:C13)","v":{"$error":"#REF!"}},{"$f":"SUM(D12:D13)","v":{"$error":"#REF!"}},{"$f":"SUM(E12:E13)","v":{"$error":"#REF!"}},{"$f":"SUM(F12:F13)","v":{"$error":"#REF!"}}]
[]
[null,"Opening Accumulated Amortization",0,{"$f":"C18","v":{"$error":"#REF!"}},{"$f":"D18","v":{"$error":"#REF!"}},{"$f":"E18","v":{"$error":"#REF!"}}]
[null,{"$f":"\"Amortization Year 1 (\" &#REF! &\" Years  Straight Line)\"","v":{"$error":"#REF!"}},{"$f":"IF(C16+(C12/#REF!)+(C13/#REF!/2)<C14,(C12/#REF!)+(C13/#REF!/2),C14-C16)","v":{"$error":"#REF!"}},{"$f":"IF(D16+(D12/#REF!)+(D13/#REF!/2)<D14,(D12/#REF!)+(D13/#REF!/2),D14-D16)","v":{"$error":"#REF!"}},{"$f":"IF(E16+(E12/#REF!)+(E13/#REF!/2)<E14,(E12/#REF!)+(E13/#REF!/2),E14-E16)","v":{"$error":"#REF!"}},{"$f":"IF(F16+(F12/#REF!)+(F13/#REF!/2)<F14,(F12/#REF!)+(F13/#REF!/2),F14-F16)","v":{"$error":"#REF!"}}]
[null,"Closing Accumulated Amortization",{"$f":"SUM(C16:C17)","v":{"$error":"#REF!"}},{"$f":"SUM(D16:D17)","v":{"$error":"#REF!"}},{"$f":"SUM(E16:E17)","v":{"$error":"#REF!"}},{"$f":"SUM(F16:F17)","v":{"$error":"#REF!"}}]
[]
[null,"Opening Net Fixed Assets",{"$f":"0","v":0},{"$f":"C21","v":{"$error":"#REF!"}},{"$f":"D21","v":{"$error":"#REF!"}},{"$f":"E21","v":{"$error":"#REF!"}}]
[null,"Closing Net Fixed Assets",{"$f":"C14-C18","v":{"$error":"#REF!"}},{"$f":"D14-D18","v":{"$error":"#REF!"}},{"$f":"E14-E18","v":{"$error":"#REF!"}},{"$f":"F14-F18","v":{"$error":"#REF!"}}]
[null,"Average Net Fixed Assets",{"$f":"(C21+C20)/2","v":{"$error":"#REF!"}},{"$f":"(D21+D20)/2","v":{"$error":"#REF!"}},{"$f":"(E21+E20)/2","v":{"$error":"#REF!"}},{"$f":"(F21+F20)/2","v":{"$error":"#REF!"}}]
[]
[null,"Net Fixed Assets - Computer Hardware",2007,2008,2009,2010]
[]
[null,"Opening Capital Investment",0,{"$f":"C28","v":{"$error":"#REF!"}},{"$f":"D28","v":{"$error":"#REF!"}},{"$f":"E28","v":{"$error":"#REF!"}}]
[null,"Capital Investment (3.  LDC Assumptions and Data)",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Closing Capital Investment",{"$f":"SUM(C26:C27)","v":{"$error":"#REF!"}},{"$f":"SUM(D26:D27)","v":{"$error":"#REF!"}},{"$f":"SUM(E26:E27)","v":{"$error":"#REF!"}},{"$f":"SUM(F26:F27)","v":{"$error":"#REF!"}}]
[]
[null,"Opening Accumulated Amortization",0,{"$f":"C32","v":{"$error":"#REF!"}},{"$f":"D32","v":{"$error":"#REF!"}},{"$f":"E32","v":{"$error":"#REF!"}}]
[null,{"$f":"\"Amortization Year 1 (\" &#REF! &\" Years  Straight Line)\"","v":{"$error":"#REF!"}},{"$f":"IF(C30+(C26/#REF!)+(C27/#REF!/2)<C28,(C26/#REF!)+(C27/#REF!/2),C28-C30)","v":{"$error":"#REF!"}},{"$f":"IF(D30+(D26/#REF!)+(D27/#REF!/2)<D28,(D26/#REF!)+(D27/#REF!/2),D28-D30)","v":{"$error":"#REF!"}},{"$f":"IF(E30+(E26/#REF!)+(E27/#REF!/2)<E28,(E26/#REF!)+(E27/#REF!/2),E28-E30)","v":{"$error":"#REF!"}},{"$f":"IF(F30+(F26/#REF!)+(F27/#REF!/2)<F28,(F26/#REF!)+(F27/#REF!/2),F28-F30)","v":{"$error":"#REF!"}}]
[null,"Closing Accumulated Amortization",{"$f":"SUM(C30:C31)","v":{"$error":"#REF!"}},{"$f":"SUM(D30:D31)","v":{"$error":"#REF!"}},{"$f":"SUM(E30:E31)","v":{"$error":"#REF!"}},{"$f":"SUM(F30:F31)","v":{"$error":"#REF!"}}]
[]
[null,"Opening Net Fixed Assets",{"$f":"0","v":0},{"$f":"C35","v":{"$error":"#REF!"}},{"$f":"D35","v":{"$error":"#REF!"}},{"$f":"E35","v":{"$error":"#REF!"}}]
[null,"Closing Net Fixed Assets",{"$f":"C28-C32","v":{"$error":"#REF!"}},{"$f":"D28-D32","v":{"$error":"#REF!"}},{"$f":"E28-E32","v":{"$error":"#REF!"}},{"$f":"F28-F32","v":{"$error":"#REF!"}}]
[null,"Average Net Fixed Assets",{"$f":"(C35+C34)/2","v":{"$error":"#REF!"}},{"$f":"(D35+D34)/2","v":{"$error":"#REF!"}},{"$f":"(E35+E34)/2","v":{"$error":"#REF!"}},{"$f":"(F35+F34)/2","v":{"$error":"#REF!"}}]
[]
[null,"Net Fixed Assets - Computer Software",2007,2008,2009,2010]
[]
[null,"Opening Capital Investment",0,{"$f":"C42","v":{"$error":"#REF!"}},{"$f":"D42","v":{"$error":"#REF!"}},{"$f":"E42","v":{"$error":"#REF!"}}]
[null,"Capital Investment (3.  LDC Assumptions and Data)",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Closing Capital Investment",{"$f":"SUM(C40:C41)","v":{"$error":"#REF!"}},{"$f":"SUM(D40:D41)","v":{"$error":"#REF!"}},{"$f":"SUM(E40:E41)","v":{"$error":"#REF!"}},{"$f":"SUM(F40:F41)","v":{"$error":"#REF!"}}]
[]
[null,"Opening Accumulated Amortization",0,{"$f":"C46","v":{"$error":"#REF!"}},{"$f":"D46","v":{"$error":"#REF!"}},{"$f":"E46","v":{"$error":"#REF!"}}]
[null,{"$f":"\"Amortization Year 1 (\" &#REF! &\" Years Straight Line)\"","v":{"$error":"#REF!"}},{"$f":"IF(C44+(C40/#REF!)+(C41/#REF!/2)<C42,(C40/#REF!)+(C41/#REF!/2),C42-C44)","v":{"$error":"#REF!"}},{"$f":"IF(D44+(D40/#REF!)+(D41/#REF!/2)<D42,(D40/#REF!)+(D41/#REF!/2),D42-D44)","v":{"$error":"#REF!"}},{"$f":"IF(E44+(E40/#REF!)+(E41/#REF!/2)<E42,(E40/#REF!)+(E41/#REF!/2),E42-E44)","v":{"$error":"#REF!"}},{"$f":"IF(F44+(F40/#REF!)+(F41/#REF!/2)<F42,(F40/#REF!)+(F41/#REF!/2),F42-F44)","v":{"$error":"#REF!"}}]
[null,"Closing Accumulated Amortization",{"$f":"SUM(C44:C45)","v":{"$error":"#REF!"}},{"$f":"SUM(D44:D45)","v":{"$error":"#REF!"}},{"$f":"SUM(E44:E45)","v":{"$error":"#REF!"}},{"$f":"SUM(F44:F45)","v":{"$error":"#REF!"}}]
[]
[null,"Opening Net Fixed Assets",{"$f":"0","v":0},{"$f":"C49","v":{"$error":"#REF!"}},{"$f":"D49","v":{"$error":"#REF!"}},{"$f":"E49","v":{"$error":"#REF!"}}]
[null,"Closing Net Fixed Assets",{"$f":"C42-C46","v":{"$error":"#REF!"}},{"$f":"D42-D46","v":{"$error":"#REF!"}},{"$f":"E42-E46","v":{"$error":"#REF!"}},{"$f":"F42-F46","v":{"$error":"#REF!"}}]
[null,"Average Net Fixed Assets",{"$f":"(C49+C48)/2","v":{"$error":"#REF!"}},{"$f":"(D49+D48)/2","v":{"$error":"#REF!"}},{"$f":"(E49+E48)/2","v":{"$error":"#REF!"}},{"$f":"(F49+F48)/2","v":{"$error":"#REF!"}}]
[]
[]
[null,"Net Fixed Assets - Tools & Equipment",2007,2008,2009,2010]
[]
[null,"Opening Capital Investment",0,{"$f":"C57","v":{"$error":"#REF!"}},{"$f":"D57","v":{"$error":"#REF!"}},{"$f":"E57","v":{"$error":"#REF!"}}]
[null,"Capital Investment (3.  LDC Assumptions and Data)",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Closing Capital Investment",{"$f":"SUM(C55:C56)","v":{"$error":"#REF!"}},{"$f":"SUM(D55:D56)","v":{"$error":"#REF!"}},{"$f":"SUM(E55:E56)","v":{"$error":"#REF!"}},{"$f":"SUM(F55:F56)","v":{"$error":"#REF!"}}]
[]
[null,"Opening Accumulated Amortization",0,{"$f":"C61","v":{"$error":"#REF!"}},{"$f":"D61","v":{"$error":"#REF!"}},{"$f":"E61","v":{"$error":"#REF!"}}]
[null,{"$f":"\"Amortization Year 1 (\" &#REF! &\" Years Straight Line)\"","v":{"$error":"#REF!"}},{"$f":"IF(C59+(C55/#REF!)+(C56/#REF!/2)<C57,(C55/#REF!)+(C56/#REF!/2),C57-C59)","v":{"$error":"#REF!"}},{"$f":"IF(D59+(D55/#REF!)+(D56/#REF!/2)<D57,(D55/#REF!)+(D56/#REF!/2),D57-D59)","v":{"$error":"#REF!"}},{"$f":"IF(E59+(E55/#REF!)+(E56/#REF!/2)<E57,(E55/#REF!)+(E56/#REF!/2),E57-E59)","v":{"$error":"#REF!"}},{"$f":"IF(F59+(F55/#REF!)+(F56/#REF!/2)<F57,(F55/#REF!)+(F56/#REF!/2),F57-F59)","v":{"$error":"#REF!"}}]
[null,"Closing Accumulated Amortization",{"$f":"SUM(C59:C60)","v":{"$error":"#REF!"}},{"$f":"SUM(D59:D60)","v":{"$error":"#REF!"}},{"$f":"SUM(E59:E60)","v":{"$error":"#REF!"}},{"$f":"SUM(F59:F60)","v":{"$error":"#REF!"}}]
[]
[null,"Opening Net Fixed Assets",{"$f":"0","v":0},{"$f":"C64","v":{"$error":"#REF!"}},{"$f":"D64","v":{"$error":"#REF!"}},{"$f":"E64","v":{"$error":"#REF!"}}]
[null,"Closing Net Fixed Assets",{"$f":"C57-C61","v":{"$error":"#REF!"}},{"$f":"D57-D61","v":{"$error":"#REF!"}},{"$f":"E57-E61","v":{"$error":"#REF!"}},{"$f":"F57-F61","v":{"$error":"#REF!"}}]
[null,"Average Net Fixed Assets",{"$f":"(C64+C63)/2","v":{"$error":"#REF!"}},{"$f":"(D64+D63)/2","v":{"$error":"#REF!"}},{"$f":"(E64+E63)/2","v":{"$error":"#REF!"}},{"$f":"(F64+F63)/2","v":{"$error":"#REF!"}}]
[]
[null,"Net Fixed Assets - Other Equipment",2007,2008,2009,2010]
[]
[null,"Opening Capital Investment",0,{"$f":"C71","v":{"$error":"#REF!"}},{"$f":"D71","v":{"$error":"#REF!"}},{"$f":"E71","v":{"$error":"#REF!"}}]
[null,"Capital Investment (3.  LDC Assumptions and Data)",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Closing Capital Investment",{"$f":"SUM(C69:C70)","v":{"$error":"#REF!"}},{"$f":"SUM(D69:D70)","v":{"$error":"#REF!"}},{"$f":"SUM(E69:E70)","v":{"$error":"#REF!"}},{"$f":"SUM(F69:F70)","v":{"$error":"#REF!"}}]
[]
[null,"Opening Accumulated Amortization",0,{"$f":"C75","v":{"$error":"#REF!"}},{"$f":"D75","v":{"$error":"#REF!"}},{"$f":"E75","v":{"$error":"#REF!"}}]
[null,{"$f":"\"Amortization Year 1 (\" &#REF! &\" Years Straight Line)\"","v":{"$error":"#REF!"}},{"$f":"IF(C73+(C69/#REF!)+(C70/#REF!/2)<C71,(C69/#REF!)+(C70/#REF!/2),C71-C73)","v":{"$error":"#REF!"}},{"$f":"IF(D73+(D69/#REF!)+(D70/#REF!/2)<D71,(D69/#REF!)+(D70/#REF!/2),D71-D73)","v":{"$error":"#REF!"}},{"$f":"IF(E73+(E69/#REF!)+(E70/#REF!/2)<E71,(E69/#REF!)+(E70/#REF!/2),E71-E73)","v":{"$error":"#REF!"}},{"$f":"IF(F73+(F69/#REF!)+(F70/#REF!/2)<F71,(F69/#REF!)+(F70/#REF!/2),F71-F73)","v":{"$error":"#REF!"}}]
[null,"Closing Accumulated Amortization",{"$f":"SUM(C73:C74)","v":{"$error":"#REF!"}},{"$f":"SUM(D73:D74)","v":{"$error":"#REF!"}},{"$f":"SUM(E73:E74)","v":{"$error":"#REF!"}},{"$f":"SUM(F73:F74)","v":{"$error":"#REF!"}}]
[]
[null,"Opening Net Fixed Assets",{"$f":"0","v":0},{"$f":"C78","v":{"$error":"#REF!"}},{"$f":"D78","v":{"$error":"#REF!"}},{"$f":"E78","v":{"$error":"#REF!"}}]
[null,"Closing Net Fixed Assets",{"$f":"C71-C75","v":{"$error":"#REF!"}},{"$f":"D71-D75","v":{"$error":"#REF!"}},{"$f":"E71-E75","v":{"$error":"#REF!"}},{"$f":"F71-F75","v":{"$error":"#REF!"}}]
[null,"Average Net Fixed Assets",{"$f":"(C78+C77)/2","v":{"$error":"#REF!"}},{"$f":"(D78+D77)/2","v":{"$error":"#REF!"}},{"$f":"(E78+E77)/2","v":{"$error":"#REF!"}},{"$f":"(F78+F77)/2","v":{"$error":"#REF!"}}]
[]
[]
[null,"For PILs Calculation"]
[]
[null,"UCC - Smart Meters"]
[null,"CCA Class 47 (8%)",2007,2008,2009,2010]
[]
[null,"Opening UCC",0,{"$f":"C89-C93","v":{"$error":"#REF!"}},{"$f":"D89-D93","v":{"$error":"#REF!"}},{"$f":"E89-E93","v":{"$error":"#REF!"}}]
[null,"Capital Additions",{"$f":"C13","v":{"$error":"#REF!"}},{"$f":"D13","v":{"$error":"#REF!"}},{"$f":"E13","v":{"$error":"#REF!"}},{"$f":"F13","v":{"$error":"#REF!"}}]
[null,"UCC Before Half Year Rule",{"$f":"SUM(C87:C88)","v":{"$error":"#REF!"}},{"$f":"SUM(D87:D88)","v":{"$error":"#REF!"}},{"$f":"SUM(E87:E88)","v":{"$error":"#REF!"}},{"$f":"SUM(F87:F88)","v":{"$error":"#REF!"}}]
[null,"Half Year Rule (1/2 Additions - Disposals)",{"$f":"SUM(C88:C88)/2","v":{"$error":"#REF!"}},{"$f":"SUM(D88:D88)/2","v":{"$error":"#REF!"}},{"$f":"SUM(E88:E88)/2","v":{"$error":"#REF!"}},{"$f":"SUM(F88:F88)/2","v":{"$error":"#REF!"}}]
[null,"Reduced UCC",{"$f":"C87+C90","v":{"$error":"#REF!"}},{"$f":"D87+D90","v":{"$error":"#REF!"}},{"$f":"E87+E90","v":{"$error":"#REF!"}},{"$f":"F87+F90","v":{"$error":"#REF!"}}]
[null,"CCA Rate Class  47",0.08,0.08,0.08,0.08]
[null,"CCA",{"$f":"IF((C91*C92)<C91,(C91*C92),C91)","v":{"$error":"#REF!"}},{"$f":"IF((D91*D92)<D91,(D91*D92),D91)","v":{"$error":"#REF!"}},{"$f":"IF((E91*E92)<E91,(E91*E92),E91)","v":{"$error":"#REF!"}},{"$f":"IF((F91*F92)<F91,(F91*F92),F91)","v":{"$error":"#REF!"}}]
[null,"Closing UCC",{"$f":"IF((C89-C93)<0,0,(C89-C93))","v":{"$error":"#REF!"}},{"$f":"IF((D89-D93)<0,0,(D89-D93))","v":{"$error":"#REF!"}},{"$f":"IF((E89-E93)<0,0,(E89-E93))","v":{"$error":"#REF!"}},{"$f":"IF((F89-F93)<0,0,(F89-F93))","v":{"$error":"#REF!"}}]
[]
[null,"UCC - Computer Equipment"]
[null,"CCA Class 45 (45%)",2007,2008,2009,2010]
[]
[null,"Opening UCC",0,{"$f":"C107","v":{"$error":"#REF!"}},{"$f":"D107","v":{"$error":"#REF!"}},{"$f":"E107","v":{"$error":"#REF!"}}]
[null,"Capital Additions Computer Hardware",{"$f":"C27","v":{"$error":"#REF!"}},{"$f":"D27","v":{"$error":"#REF!"}},{"$f":"E27","v":{"$error":"#REF!"}},{"$f":"F27","v":{"$error":"#REF!"}}]
[null,"Capital Additions Computer Software",{"$f":"C41","v":{"$error":"#REF!"}},{"$f":"D41","v":{"$error":"#REF!"}},{"$f":"E41","v":{"$error":"#REF!"}},{"$f":"F41","v":{"$error":"#REF!"}}]
[null,"UCC Before Half Year Rule",{"$f":"SUM(C99:C101)","v":{"$error":"#REF!"}},{"$f":"SUM(D99:D101)","v":{"$error":"#REF!"}},{"$f":"SUM(E99:E101)","v":{"$error":"#REF!"}},{"$f":"SUM(F99:F101)","v":{"$error":"#REF!"}}]
[null,"Half Year Rule (1/2 Additions - Disposals)",{"$f":"SUM(C100:C101)/2","v":{"$error":"#REF!"}},{"$f":"SUM(D100:D101)/2","v":{"$error":"#REF!"}},{"$f":"SUM(E100:E101)/2","v":{"$error":"#REF!"}},{"$f":"SUM(F100:F101)/2","v":{"$error":"#REF!"}}]
[null,"Reduced UCC",{"$f":"C99+C103","v":{"$error":"#REF!"}},{"$f":"D99+D103","v":{"$error":"#REF!"}},{"$f":"E99+E103","v":{"$error":"#REF!"}},{"$f":"F99+F103","v":{"$error":"#REF!"}}]
[null,"CCA Rate Class  45",0.45,0.45,0.45,0.45]
[null,"CCA",{"$f":"IF((C104*C105)<C104,(C104*C105),C104)","v":{"$error":"#REF!"}},{"$f":"IF((D104*D105)<D104,(D104*D105),D104)","v":{"$error":"#REF!"}},{"$f":"IF((E104*E105)<E104,(E104*E105),E104)","v":{"$error":"#REF!"}},{"$f":"IF((F104*F105)<F104,(F104*F105),F104)","v":{"$error":"#REF!"}}]
[null,"Closing UCC",{"$f":"IF((C102-C106)<0,0,(C102-C106))","v":{"$error":"#REF!"}},{"$f":"IF((D102-D106)<0,0,(D102-D106))","v":{"$error":"#REF!"}},{"$f":"IF((E102-E106)<0,0,(E102-E106))","v":{"$error":"#REF!"}},{"$f":"IF((F102-F106)<0,0,(F102-F106))","v":{"$error":"#REF!"}}]
[]
[null,"UCC - General Equipment"]
[null,"CCA Class 8 (20%)",2007,2008,2009,2010]
[]
[null,"Opening UCC",0,{"$f":"C120","v":{"$error":"#REF!"}},{"$f":"D120","v":{"$error":"#REF!"}},{"$f":"E120","v":{"$error":"#REF!"}}]
[null,"Capital Additions Tools & Equipment",{"$f":"C56","v":{"$error":"#REF!"}},{"$f":"D56","v":{"$error":"#REF!"}},{"$f":"E56","v":{"$error":"#REF!"}},{"$f":"F56","v":{"$error":"#REF!"}}]
[null,"Capital Additions Other Equipment",{"$f":"C70","v":{"$error":"#REF!"}},{"$f":"D70","v":{"$error":"#REF!"}},{"$f":"E70","v":{"$error":"#REF!"}},{"$f":"F70","v":{"$error":"#REF!"}}]
[null,"UCC Before Half Year Rule",{"$f":"SUM(C112:C114)","v":{"$error":"#REF!"}},{"$f":"SUM(D112:D114)","v":{"$error":"#REF!"}},{"$f":"SUM(E112:E114)","v":{"$error":"#REF!"}},{"$f":"SUM(F112:F114)","v":{"$error":"#REF!"}}]
[null,"Half Year Rule (1/2 Additions - Disposals)",{"$f":"SUM(C113:C114)/2","v":{"$error":"#REF!"}},{"$f":"SUM(D113:D114)/2","v":{"$error":"#REF!"}},{"$f":"SUM(E113:E114)/2","v":{"$error":"#REF!"}},{"$f":"SUM(F113:F114)/2","v":{"$error":"#REF!"}}]
[null,"Reduced UCC",{"$f":"C112+C116","v":{"$error":"#REF!"}},{"$f":"D112+D116","v":{"$error":"#REF!"}},{"$f":"E112+E116","v":{"$error":"#REF!"}},{"$f":"F112+F116","v":{"$error":"#REF!"}}]
[null,"CCA Rate Class  8",0.2,0.2,0.2,0.2]
[null,"CCA",{"$f":"IF((C117*C118)<C117,(C117*C118),C117)","v":{"$error":"#REF!"}},{"$f":"IF((D117*D118)<D117,(D117*D118),D117)","v":{"$error":"#REF!"}},{"$f":"IF((E117*E118)<E117,(E117*E118),E117)","v":{"$error":"#REF!"}},{"$f":"IF((F117*F118)<F117,(F117*F118),F117)","v":{"$error":"#REF!"}}]
[null,"Closing UCC",{"$f":"IF((C115-C119)<0,0,(C115-C119))","v":{"$error":"#REF!"}},{"$f":"IF((D115-D119)<0,0,(D115-D119))","v":{"$error":"#REF!"}},{"$f":"IF((E115-E119)<0,0,(E115-E119))","v":{"$error":"#REF!"}},{"$f":"IF((F115-F119)<0,0,(F115-F119))","v":{"$error":"#REF!"}}]

{"sheet":"16. Carry Cost Required to May ","index":9,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":true,"merged":[[0,0,0,6],[1,0,1,6]]}
["Smart Meter Rate Carrying Cost Recovery Required"]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Opening ","Rev Req","Recovery","Int. Rate","Interest","Closing"]
["2006-01-01",0,0,0,7.0400000000000004E-2,{"$f":"(B4*E4)/12","v":0},{"$f":"SUM(B4:D4,F4)","v":0}]
["2006-02-01",{"$f":"G4","v":0},0,0,7.0400000000000004E-2,0,0]
["2006-03-01",0,0,0,7.0400000000000004E-2,0,0]
["2006-04-01",0,0,0,4.1399999999999999E-2,0,0]
["2006-05-01",0,0,0,4.1399999999999999E-2,0,0]
["2006-06-01",0,0,0,4.1399999999999999E-2,0,0]
["2006-07-01",0,0,0,4.5900000000000003E-2,0,0]
["2006-08-01",0,0,0,4.5900000000000003E-2,0,0]
["2006-09-01",0,0,0,4.5900000000000003E-2,0,0]
["2006-10-01",0,0,0,4.5900000000000003E-2,0,0]
["2006-11-01",0,0,0,4.5900000000000003E-2,0,0]
["2006-12-01",0,0,0,4.5900000000000003E-2,0,0]
["2007-01-01",0,0,0,4.5900000000000003E-2,0,0]
["2007-02-01",0,0,0,4.5900000000000003E-2,0,0]
["2007-03-01",0,0,0,4.5900000000000003E-2,0,0]
["2007-04-01",0,0,0,4.5900000000000003E-2,0,0]
["2007-05-01",0,0,0,4.5900000000000003E-2,0,0]
["2007-06-01",0,0,0,4.5900000000000003E-2,0,0]
["2007-07-01",0,0,0,4.5900000000000003E-2,0,0]
["2007-08-01",0,0,0,4.5900000000000003E-2,0,0]
["2007-09-01",0,0,0,4.5900000000000003E-2,0,0]
["2007-10-01",0,0,0,4.5900000000000003E-2,0,0]
["2007-11-01",0,0,0,4.5900000000000003E-2,0,0]
["2007-12-01",0,0,0,4.5900000000000003E-2,0,0]
["2008-01-01",0,{"$f":"'4. Smart Meter Rev & Adder'!I47/12","v":{"$error":"#REF!"}},0,4.5900000000000003E-2,0,{"$error":"#REF!"}]
["2008-02-01",{"$error":"#REF!"},{"$f":"C28","v":{"$error":"#REF!"}},0,4.5900000000000003E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["2008-03-01",{"$error":"#REF!"},{"$f":"C29","v":{"$error":"#REF!"}},0,4.5900000000000003E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["2008-04-01",{"$error":"#REF!"},{"$f":"C30","v":{"$error":"#REF!"}},0,4.5900000000000003E-2,{"$error":"#REF!"},{"$error":"#REF!"}]
["Carrying Cost Recovery Required on Permanent Adder",null,null,null,null,{"$f":"SUM(F4:F31)","v":{"$error":"#REF!"}}]
[]
[null,"Monthly","Months","Perm Rev Req"]
[null,{"$f":"C28","v":{"$error":"#REF!"}},12,{"$f":"B35*C35","v":{"$error":"#REF!"}}]

{"sheet":"1. Cost of Service_parameters","index":10,"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,2.1600000000000001E-2,2.1600000000000001E-2,2.1600000000000001E-2,2.1600000000000001E-2,2.1600000000000001E-2,2.1600000000000001E-2,2.1600000000000001E-2,2.1600000000000001E-2,2.1600000000000001E-2]
[null,null,null,"Long-term Debt Rate (actual/embedded/deemed)1",null,null,6.0699999999999997E-2,6.0699999999999997E-2,6.0699999999999997E-2,6.0699999999999997E-2,6.0699999999999997E-2,6.0699999999999997E-2,6.0699999999999997E-2,6.0699999999999997E-2,6.0699999999999997E-2]
[null,null,null,"Target Return on Equity (ROE)",null,null,9.2999999999999999E-2,9.2999999999999999E-2,9.2999999999999999E-2,9.2999999999999999E-2,9.2999999999999999E-2,9.2999999999999999E-2,9.2999999999999999E-2,9.2999999999999999E-2,9.2999999999999999E-2]
[null,null,null,"Return on Preferred Shares"]
[null,null,"WACC",null,null,null,{"$f":"SUMPRODUCT(G14:G17,G21:G24)","v":7.2055999999999995E-2},{"$f":"SUMPRODUCT(H14:H17,H21:H24)","v":7.2055999999999995E-2},{"$f":"SUMPRODUCT(I14:I17,I21:I24)","v":7.2055999999999995E-2},7.2055999999999995E-2,7.2055999999999995E-2,7.2055999999999995E-2,7.2055999999999995E-2,7.2055999999999995E-2,7.2055999999999995E-2]
[]
[null,"Working Capital Allowance"]
[null,null,"Working Capital Allowance Rate",null,null,null,0.13,0.13,0.13,0.13,0.13,0.13,0.13,0.13,0.13]
[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":11,"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: 1557 - Net Book Value"]
[null,null,null,null,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":507923.77},{"$f":"F17","v":499979.88},963735.37,1190429.79,1545630.44,1423798.2,1423798.2,1423798.2]
[null,null,null,"Capital Additions during year ",507923.77,-7943.8899999999976,463755.49,226694.41999999998,355200.65,-121832.24000000003,0,0,0]
[null,null,null,"Retirements/Removals (if applicable)",null,0,null,0,null,0,0,0,0]
[null,null,null,"Closing Balance",{"$f":"E14+E15-E16","v":507923.77},{"$f":"F14+F15-F16","v":499979.88},{"$f":"G14+G15-G16","v":963735.37},1190429.79,1545630.44,1423798.2,1423798.2,1423798.2,1423798.2]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",0,{"$f":"E23","v":0},{"$f":"F23","v":0},0,-139405.66,-229229.74,-325993.98,-420913.86,-515833.74]
[null,null,null,"Amortization expense during year",{"$f":"E290","v":0},{"$f":"F290","v":0},0,-139405.66,-89824.08,-96764.24,-94919.88,-94919.88,-94919.88]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",{"$f":"E20+E21-E22","v":0},{"$f":"F20+F21-F22","v":0},{"$f":"G20+G21-G22","v":0},{"$f":"H20+H21-H22","v":-139405.66},{"$f":"I20+I21-I22","v":-229229.74},{"$f":"J20+J21-J22","v":-325993.98},{"$f":"K20+K21-K22","v":-420913.86},{"$f":"L20+L21-L22","v":-515833.74},{"$f":"M20+M21-M22","v":-610753.62}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",{"$f":"E14+E20","v":0},{"$f":"E27","v":507923.77},{"$f":"F27","v":499979.88},963735.37,1051024.1300000001,1316400.7,1097804.22,1002884.34,907964.46]
[null,null,null,"Closing Balance",{"$f":"E17+E23","v":507923.77},{"$f":"F17+F23","v":499979.88},{"$f":"G17+G23","v":963735.37},1051024.1300000001,1316400.7,1097804.22,1002884.34,907964.46,813044.58]
[null,null,null,"Net Fixed Assets (NFA)",{"$f":"SUM(E26:E27)/2","v":253961.88500000001},{"$f":"AVERAGE(F26:F27)","v":503951.82500000001},{"$f":"AVERAGE(G26:G27)","v":731857.625},1007379.75,1183712.415,1207102.46,1050344.28,955424.39999999991,860504.52]
[]
[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":507923.77},{"$f":"F15+F34+F53+F72+F91+F110+F129+F148+F167+F187+F207+F227+F247","v":-7943.8899999999976},463755.49,226694.41999999998,355200.65,-121832.24000000003,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":253961.88500000001},{"$f":"F28+F47+F66+F85+F104+F123+F142+F161+F180+F200+F220+F240+F260","v":503951.82500000001},{"$f":"G28+G47+G66+G85+G104+G123+G142+G161+G180+G200+G220+G240+G260","v":731857.625},1007379.75,1183712.415,1207102.46,1050344.28,955424.39999999991,860504.52]
[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":0},{"$f":"G21+G40+G59+G78+G97+G116+G135+G154+G173+G193+G213+G233+G253","v":0},-139405.66,-89824.08,-96764.24,-94919.88,-94919.88,-94919.88]

{"sheet":"3. UCC_Calculations","index":12,"n_rows":88,"n_cols":12,"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,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":487606.81920000003},{"$f":"E17-E22","v":440654.38366400002},{"$f":"F17-F22","v":850607.30337088008},1000185.3623012097,1261163.1573171131,1038437.864731744,955362.83555320452,878933.8087089482]
["Capital Additions",null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!E267-D29-D44-D59-D74","v":507923.77},{"$f":"'2. MIST Meters Assets_Rate Base'!F267-E29-E44-E59-E74","v":-7943.8899999999976},{"$f":"'2. MIST Meters Assets_Rate Base'!G267-F29-F44-F59-F74","v":463755.49},{"$f":"'2. MIST Meters Assets_Rate Base'!H267-G29-G44-G59-G74","v":226694.41999999998},{"$f":"'2. MIST Meters Assets_Rate Base'!I267-H29-H44-H59-H74","v":355200.65},{"$f":"'2. MIST Meters Assets_Rate Base'!J267-I29-I44-I59-I74","v":-121832.24000000003},{"$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":507923.77},{"$f":"SUM(E14:E15)-E16","v":479662.92920000001},{"$f":"SUM(F14:F15)-F16","v":904409.87366400007},1077301.7233708801,1355386.0123012098,1139330.9173171131,1038437.864731744,955362.83555320452,878933.8087089482]
["Half Year Rule (1/2 Additions - Disposals)",null,null,{"$f":"IF(((D15-D16)/2)<0, 0, (D15-D16)/2)","v":253961.88500000001},{"$f":"IF(((E15-E16)/2)<0, 0, (E15-E16)/2)","v":0},{"$f":"IF(((F15-F16)/2)<0, 0, (F15-F16)/2)","v":231877.745},{"$f":"IF(((G15-G16)/2)<0, 0, (G15-G16)/2)","v":113347.20999999999},177600.32500000001,0,0,0,0]
["Reduced UCC",null,null,{"$f":"D18+D14","v":253961.88500000001},{"$f":"E18+E14","v":487606.81920000003},{"$f":"F18+F14","v":672532.12866399996},{"$f":"G18+G14","v":963954.51337088004},1177785.6873012097,1261163.1573171131,1038437.864731744,955362.83555320452,878933.8087089482]
["CCA Rate Class",null,null,{"$f":"'1. Cost of Service_parameters'!G96","v":47},{"$f":"'1. Cost of Service_parameters'!H96","v":47},{"$f":"'1. Cost of Service_parameters'!I96","v":47},{"$f":"'1. Cost of Service_parameters'!J96","v":47},{"$f":"'1. Cost of Service_parameters'!K96","v":47},{"$f":"'1. Cost of Service_parameters'!L96","v":47},{"$f":"'1. Cost of Service_parameters'!M96","v":47},{"$f":"'1. Cost of Service_parameters'!N96","v":47},{"$f":"'1. Cost of Service_parameters'!O96","v":47}]
["CCA Rate ",null,null,{"$f":"'1. Cost of Service_parameters'!G97","v":0.08},{"$f":"'1. Cost of Service_parameters'!H97","v":0.08},{"$f":"'1. Cost of Service_parameters'!I97","v":0.08},{"$f":"'1. Cost of Service_parameters'!J97","v":0.08},{"$f":"'1. Cost of Service_parameters'!K97","v":0.08},{"$f":"'1. Cost of Service_parameters'!L97","v":0.08},{"$f":"'1. Cost of Service_parameters'!M97","v":0.08},{"$f":"'1. Cost of Service_parameters'!N97","v":0.08},{"$f":"'1. Cost of Service_parameters'!O97","v":0.08}]
["CCA",null,null,{"$f":"D19*D21","v":20316.950800000002},{"$f":"E19*E21","v":39008.545536000005},53802.570293119999,77116.361069670398,94222.854984096775,100893.05258536905,83075.029178539524,76429.026844256368,70314.704696715853]
["Closing UCC",null,null,{"$f":"IF((D17-D22)<0, 0, D17-D22)","v":487606.81920000003},{"$f":"IF((E17-E22)<0, 0, E17-E22)","v":440654.38366400002},{"$f":"IF((F17-F22)<0, 0, F17-F22)","v":850607.30337088008},1000185.3623012097,1261163.1573171131,1038437.864731744,955362.83555320452,878933.8087089482,808619.10401223239]
[]
["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":507923.77},{"$f":"SUM(E74,E59,E44,E29,E15)","v":-7943.8899999999976},{"$f":"SUM(F74,F59,F44,F29,F15)","v":463755.49},226694.41999999998,355200.65,-121832.24000000003,0,0,0]
[]
[null,"CCA",null,{"$f":"SUM(D81,D66,D51,D36,D22,)","v":20316.950800000002},{"$f":"SUM(E81,E66,E51,E36,E22,)","v":39008.545536000005},{"$f":"SUM(F81,F66,F51,F36,F22,)","v":53802.570293119999},77116.361069670398,94222.854984096775,100893.05258536905,83075.029178539524,76429.026844256368,70314.704696715853]

{"sheet":"4. Fund Adder Revenues","index":13,"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 Fund Adder Revenues"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Account 1557 - MIST Meters deferral"]
[]
[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,{"$f":"VLOOKUP(I16,$B$14:$D$51,2)","v":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,{"$f":"VLOOKUP(I40,$B$14:$D$51,2)","v":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",3.1600000000000003E-2,4.2299999999999997E-2,null,"2020-07-01",2020,"Q3","2020 Q3",0,null,5.7000000000000002E-3,0,0]
[null,"2025 Q4",3.1600000000000003E-2,4.2299999999999997E-2,null,"2020-08-01",2020,"Q3","2020 Q3",0,null,5.7000000000000002E-3,0,0]
[null,"2026 Q1",3.1600000000000003E-2,4.2299999999999997E-2,null,"2020-09-01",2020,"Q3","2020 Q3",0,null,5.7000000000000002E-3,0,0]
[null,"2026 Q2",3.1600000000000003E-2,4.2299999999999997E-2,null,"2020-10-01",2020,"Q4","2020 Q4",0,null,5.7000000000000002E-3,0,0]
[null,"2026 Q3",3.1600000000000003E-2,4.2299999999999997E-2,null,"2020-11-01",2020,"Q4","2020 Q4",0,null,5.7000000000000002E-3,0,0]
[null,"2026 Q4",3.1600000000000003E-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,{"$f":"VLOOKUP(I104,$B$14:$D$51,2)","v":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,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2025-08-01",2025,"Q3","2025 Q3",0,null,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2025-09-01",2025,"Q3","2025 Q3",0,null,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2025-10-01",2025,"Q4","2025 Q4",0,null,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2025-11-01",2025,"Q4","2025 Q4",0,null,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2025-12-01",2025,"Q4","2025 Q4",0,null,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2026-01-01",2026,"Q1","2026 Q1",0,null,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2026-02-01",2026,"Q1","2026 Q1",0,null,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2026-03-01",2026,"Q1","2026 Q1",0,null,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2026-04-01",2026,"Q2","2026 Q2",0,null,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2026-05-01",2026,"Q2","2026 Q2",0,null,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2026-06-01",2026,"Q2","2026 Q2",0,null,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2026-07-01",2026,"Q3","2026 Q3",0,null,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2026-08-01",2026,"Q3","2026 Q3",0,null,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2026-09-01",2026,"Q3","2026 Q3",0,null,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2026-10-01",2026,"Q4","2026 Q4",0,null,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2026-11-01",2026,"Q4","2026 Q4",0,null,3.1600000000000003E-2,0,0]
[null,null,null,null,null,"2026-12-01",2026,"Q4","2026 Q4",0,null,3.1600000000000003E-2,0,0]
[]
[null,null,null,null,null,"Total Funding Adder Revenues Collected",null,null,null,null,{"$f":"SUM(K16:K39)","v":0},null,{"$f":"SUM(M16:M39)","v":0},{"$f":"K125+M125","v":0}]
[]
[null,"NOTE: Funding adder revenues are up to December 2014 actuals"]

{"sheet":"5. MIST Meters_IRR","index":14,"n_rows":63,"n_cols":36,"rows_kept":63,"cut":false,"hidden":false,"merged":[[3,1,3,2],[3,3,3,4]]}
[]
[]
[]
[null,null,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":253961.88500000001},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!F268-'2. MIST Meters Assets_Rate Base'!F269","v":503951.82500000001},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!G268-'2. MIST Meters Assets_Rate Base'!G269","v":731857.625},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!H268-'2. MIST Meters Assets_Rate Base'!H269","v":1146785.4099999999},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!I268-'2. MIST Meters Assets_Rate Base'!I269","v":1273536.4950000001},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!J268-'2. MIST Meters Assets_Rate Base'!J269","v":1303866.7},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!K268-'2. MIST Meters Assets_Rate Base'!K269","v":1145264.1600000001},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!L268-'2. MIST Meters Assets_Rate Base'!L269","v":1050344.2799999998},null,null,{"$f":"'2. MIST Meters Assets_Rate Base'!M268-'2. MIST Meters Assets_Rate Base'!M269","v":955424.4},"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":0},null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!G269","v":0},null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!H269","v":139405.66},null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!I269","v":89824.08},null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!J269","v":96764.24},null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!K269","v":94919.88},null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!L269","v":94919.88},null,null,{"$f":"-'2. MIST Meters Assets_Rate Base'!M269","v":94919.88},"C"]
[null,"Net Fixed Assets to be included in Rate Base",null,null,{"$f":"E15-E16","v":253961.88500000001},null,null,{"$f":"H15-H16","v":503951.82500000001},null,null,{"$f":"K15-K16","v":731857.625},null,null,{"$f":"N15-N16","v":1007379.7499999999},null,null,{"$f":"Q15-Q16","v":1183712.415},null,null,{"$f":"T15-T16","v":1207102.46},null,null,{"$f":"W15-W16","v":1050344.2800000003},null,null,{"$f":"Z15-Z16","v":955424.39999999979},null,null,{"$f":"AC15-AC16","v":860504.52},"D = B - C"]
[]
[null,"Deemed ShortTerm Debt %",{"$f":"'1. Cost of Service_parameters'!G14","v":0.04},"E",{"$f":"E17*C19","v":10158.475400000001},{"$f":"'1. Cost of Service_parameters'!H14","v":0.04},null,{"$f":"H17*F19","v":20158.073},{"$f":"'1. Cost of Service_parameters'!I14","v":0.04},null,{"$f":"K17*I19","v":29274.305},{"$f":"'1. Cost of Service_parameters'!J14","v":0.04},null,{"$f":"N17*L19","v":40295.189999999995},{"$f":"'1. Cost of Service_parameters'!K14","v":0.04},null,{"$f":"Q17*O19","v":47348.496600000006},{"$f":"'1. Cost of Service_parameters'!L14","v":0.04},null,{"$f":"T17*R19","v":48284.098400000003},{"$f":"'1. Cost of Service_parameters'!M14","v":0.04},null,{"$f":"W17*U19","v":42013.77120000001},{"$f":"'1. Cost of Service_parameters'!N14","v":0.04},null,{"$f":"Z17*X19","v":38216.975999999995},{"$f":"'1. Cost of Service_parameters'!O14","v":0.04},null,{"$f":"AC17*AA19","v":34420.180800000002},"G = D * E"]
[null,"Deemed Long Term Debt %",{"$f":"'1. Cost of Service_parameters'!G15","v":0.55999999999999994},"F",{"$f":"E17*C20","v":142218.6556},{"$f":"'1. Cost of Service_parameters'!H15","v":0.55999999999999994},null,{"$f":"H17*F20","v":282213.022},{"$f":"'1. Cost of Service_parameters'!I15","v":0.55999999999999994},null,{"$f":"K17*I20","v":409840.26999999996},{"$f":"'1. Cost of Service_parameters'!J15","v":0.55999999999999994},null,{"$f":"N17*L20","v":564132.65999999992},{"$f":"'1. Cost of Service_parameters'!K15","v":0.55999999999999994},null,{"$f":"Q17*O20","v":662878.95239999995},{"$f":"'1. Cost of Service_parameters'!L15","v":0.55999999999999994},null,{"$f":"T17*R20","v":675977.37759999989},{"$f":"'1. Cost of Service_parameters'!M15","v":0.55999999999999994},null,{"$f":"W17*U20","v":588192.79680000013},{"$f":"'1. Cost of Service_parameters'!N15","v":0.55999999999999994},null,{"$f":"Z17*X20","v":535037.66399999987},{"$f":"'1. Cost of Service_parameters'!O15","v":0.55999999999999994},null,{"$f":"AC17*AA20","v":481882.53119999997},"H = D * F"]
[]
[null,"Short Term Interest",{"$f":"'1. Cost of Service_parameters'!G21","v":2.1600000000000001E-2},"I",{"$f":"E19*C22","v":219.42306864000003},{"$f":"'1. Cost of Service_parameters'!H21","v":2.1600000000000001E-2},null,{"$f":"H19*F22","v":435.41437680000001},{"$f":"'1. Cost of Service_parameters'!I21","v":2.1600000000000001E-2},null,{"$f":"K19*I22","v":632.32498800000008},{"$f":"'1. Cost of Service_parameters'!J21","v":2.1600000000000001E-2},null,{"$f":"N19*L22","v":870.37610399999994},{"$f":"'1. Cost of Service_parameters'!K21","v":2.1600000000000001E-2},null,{"$f":"Q19*O22","v":1022.7275265600002},{"$f":"'1. Cost of Service_parameters'!L21","v":2.1600000000000001E-2},null,{"$f":"T19*R22","v":1042.9365254400002},{"$f":"'1. Cost of Service_parameters'!M21","v":2.1600000000000001E-2},null,{"$f":"W19*U22","v":907.49745792000022},{"$f":"'1. Cost of Service_parameters'!N21","v":2.1600000000000001E-2},null,{"$f":"Z19*X22","v":825.48668159999988},{"$f":"'1. Cost of Service_parameters'!O21","v":2.1600000000000001E-2},null,{"$f":"AC19*AA22","v":743.47590528000012},"K = G * I"]
[null,"Long Term Interest",{"$f":"'1. Cost of Service_parameters'!G22","v":6.0699999999999997E-2},"J",{"$f":"E20*C23","v":8632.6723949199986},{"$f":"'1. Cost of Service_parameters'!H22","v":6.0699999999999997E-2},null,{"$f":"H20*F23","v":17130.330435399999},{"$f":"'1. Cost of Service_parameters'!I22","v":6.0699999999999997E-2},null,{"$f":"K20*I23","v":24877.304388999997},{"$f":"'1. Cost of Service_parameters'!J22","v":6.0699999999999997E-2},null,{"$f":"N20*L23","v":34242.852461999995},{"$f":"'1. Cost of Service_parameters'!K22","v":6.0699999999999997E-2},null,{"$f":"Q20*O23","v":40236.752410679997},{"$f":"'1. Cost of Service_parameters'!L22","v":6.0699999999999997E-2},null,{"$f":"T20*R23","v":41031.826820319991},{"$f":"'1. Cost of Service_parameters'!M22","v":6.0699999999999997E-2},null,{"$f":"W20*U23","v":35703.302765760003},{"$f":"'1. Cost of Service_parameters'!N22","v":6.0699999999999997E-2},null,{"$f":"Z20*X23","v":32476.786204799992},{"$f":"'1. Cost of Service_parameters'!O22","v":6.0699999999999997E-2},null,{"$f":"AC20*AA23","v":29250.269643839998},"L = H * J"]
[]
[null,"Return on Rate Base - Interest",null,null,{"$f":"SUM(E22:E23)","v":8852.0954635599992},null,null,{"$f":"SUM(H22:H23)","v":17565.744812199999},null,null,{"$f":"SUM(K22:K23)","v":25509.629376999997},null,null,{"$f":"SUM(N22:N23)","v":35113.228565999998},null,null,{"$f":"SUM(Q22:Q23)","v":41259.479937240001},null,null,{"$f":"SUM(T22:T23)","v":42074.763345759995},null,null,{"$f":"SUM(W22:W23)","v":36610.800223680002},null,null,{"$f":"SUM(Z22:Z23)","v":33302.272886399995},null,null,{"$f":"SUM(AC22:AC23)","v":29993.745549119998},"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":101584.75400000003},{"$f":"'1. Cost of Service_parameters'!H16","v":0.40000000000000008},null,{"$f":"H17*F28","v":201580.73000000004},{"$f":"'1. Cost of Service_parameters'!I16","v":0.40000000000000008},null,{"$f":"K17*I28","v":292743.05000000005},{"$f":"'1. Cost of Service_parameters'!J16","v":0.40000000000000008},null,{"$f":"N17*L28","v":402951.9},{"$f":"'1. Cost of Service_parameters'!K16","v":0.40000000000000008},null,{"$f":"Q17*O28","v":473484.96600000013},{"$f":"'1. Cost of Service_parameters'!L16","v":0.40000000000000008},null,{"$f":"T17*R28","v":482840.98400000005},{"$f":"'1. Cost of Service_parameters'!M16","v":0.40000000000000008},null,{"$f":"W17*U28","v":420137.71200000017},{"$f":"'1. Cost of Service_parameters'!N16","v":0.40000000000000008},null,{"$f":"Z17*X28","v":382169.76},{"$f":"'1. Cost of Service_parameters'!O16","v":0.40000000000000008},null,{"$f":"AC17*AA28","v":344201.80800000008},"P = D * N"]
[]
[null,"Return on Rate Base -Equity",{"$f":"'1. Cost of Service_parameters'!G23","v":9.2999999999999999E-2},"O",{"$f":"E28*C30","v":9447.3821220000027},{"$f":"'1. Cost of Service_parameters'!H23","v":9.2999999999999999E-2},null,{"$f":"H28*F30","v":18747.007890000004},{"$f":"'1. Cost of Service_parameters'!I23","v":9.2999999999999999E-2},null,{"$f":"K28*I30","v":27225.103650000005},{"$f":"'1. Cost of Service_parameters'!J23","v":9.2999999999999999E-2},null,{"$f":"N28*L30","v":37474.526700000002},{"$f":"'1. Cost of Service_parameters'!K23","v":9.2999999999999999E-2},null,{"$f":"Q28*O30","v":44034.10183800001},{"$f":"'1. Cost of Service_parameters'!L23","v":9.2999999999999999E-2},null,{"$f":"T28*R30","v":44904.211512000002},{"$f":"'1. Cost of Service_parameters'!M23","v":9.2999999999999999E-2},null,{"$f":"W28*U30","v":39072.807216000016},{"$f":"'1. Cost of Service_parameters'!N23","v":9.2999999999999999E-2},null,{"$f":"Z28*X30","v":35541.787680000001},{"$f":"'1. Cost of Service_parameters'!O23","v":9.2999999999999999E-2},null,{"$f":"AC28*AA30","v":32010.768144000009},"Q = P * O"]
[]
[null,"Return on Rate Base - Total",null,null,{"$f":"E25+E30","v":18299.477585560002},null,null,{"$f":"H25+H30","v":36312.752702199999},null,null,{"$f":"K25+K30","v":52734.733027000002},null,null,{"$f":"N25+N30","v":72587.755265999993},null,null,{"$f":"Q25+Q30","v":85293.581775240018},null,null,{"$f":"T25+T30","v":86978.974857759997},null,null,{"$f":"W25+W30","v":75683.607439680025},null,null,{"$f":"Z25+Z30","v":68844.060566400003},null,null,{"$f":"AC25+AC30","v":62004.51369312001},"R = M + Q"]
[]
[]
[]
[null,"Amortization Expense"]
[]
[null,"Amortization Expense - Incremental",null,"C",{"$f":"E16","v":0},null,null,{"$f":"H16","v":0},null,null,{"$f":"K16","v":0},null,null,{"$f":"N16","v":139405.66},null,null,{"$f":"Q16","v":89824.08},null,null,{"$f":"T16","v":96764.24},null,null,{"$f":"W16","v":94919.88},null,null,{"$f":"Z16","v":94919.88},null,null,{"$f":"AC16","v":94919.88},"S"]
[]
[]
[null,"Grossed up PIL's"]
[]
[null,"Regulatory Taxable Income",null,"O",{"$f":"E30","v":9447.3821220000027},null,null,{"$f":"H30","v":18747.007890000004},null,null,{"$f":"K30","v":27225.103650000005},null,null,{"$f":"N30","v":37474.526700000002},null,null,{"$f":"Q30","v":44034.10183800001},null,null,{"$f":"T30","v":44904.211512000002},null,null,{"$f":"W30","v":39072.807216000016},null,null,{"$f":"Z30","v":35541.787680000001},null,null,{"$f":"AC30","v":32010.768144000009},"T "]
[]
[null,"Add Back Amortization Expense",null,"S",{"$f":"E38","v":0},null,null,{"$f":"H38","v":0},null,null,{"$f":"K38","v":0},null,null,{"$f":"N38","v":139405.66},null,null,{"$f":"Q38","v":89824.08},null,null,{"$f":"T38","v":96764.24},null,null,{"$f":"W38","v":94919.88},null,null,{"$f":"Z38","v":94919.88},null,null,{"$f":"AC38","v":94919.88},"U"]
[]
[null,"Deduct CCA",null,null,{"$f":"'3. UCC_Calculations'!D88","v":20316.950800000002},null,null,{"$f":"'3. UCC_Calculations'!E88","v":39008.545536000005},null,null,{"$f":"'3. UCC_Calculations'!F88","v":53802.570293119999},null,null,{"$f":"'3. UCC_Calculations'!G88","v":77116.361069670398},null,null,{"$f":"'3. UCC_Calculations'!H88","v":94222.854984096775},null,null,{"$f":"'3. UCC_Calculations'!I88","v":100893.05258536905},null,null,{"$f":"'3. UCC_Calculations'!J88","v":83075.029178539524},null,null,{"$f":"'3. UCC_Calculations'!K88","v":76429.026844256368},null,null,{"$f":"'3. UCC_Calculations'!L88","v":70314.704696715853},"V"]
[]
[null,"Incremental Taxable Income",null,null,{"$f":"E43+E45-E47","v":-10869.568678},null,null,{"$f":"H43+H45-H47","v":-20261.537646000001},null,null,{"$f":"K43+K45-K47","v":-26577.466643119995},null,null,{"$f":"N43+N45-N47","v":99763.825630329622},null,null,{"$f":"Q43+Q45-Q47","v":39635.326853903243},null,null,{"$f":"T43+T45-T47","v":40775.398926630951},null,null,{"$f":"W43+W45-W47","v":50917.658037460496},null,null,{"$f":"Z43+Z45-Z47","v":54032.640835743645},null,null,{"$f":"AC43+AC45-AC47","v":56615.943447284153},"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":-2880.4356996699998},null,null,{"$f":"H49*F51","v":-5369.3074761900007},null,null,{"$f":"K49*I51","v":-7043.0286604267994},null,null,{"$f":"N49*L51","v":26437.413792037351},null,null,{"$f":"Q49*O51","v":10503.361616284359},null,null,{"$f":"T49*R51","v":10805.480715557202},null,null,{"$f":"W49*U51","v":13493.179379927033},null,null,{"$f":"Z49*X51","v":14318.649821472067},null,null,{"$f":"AC49*AA51","v":15003.225013530302},"Y = W * X"]
[]
[null,"Incremental Grossed Up PIL's",null,null,{"$f":"E53/(1-C51)","v":-3918.9601356054422},null,null,{"$f":"H53/(1-F51)","v":-7305.1802397142865},null,null,{"$f":"K53/(1-I51)","v":-9582.3519189480267},null,null,{"$f":"N53/(1-L51)","v":35969.270465356938},null,null,{"$f":"Q53/(1-O51)","v":14290.287913312053},null,null,{"$f":"T53/(1-R51)","v":14701.334306880546},null,null,{"$f":"W53/(1-U51)","v":18358.067183574196},null,null,{"$f":"Z53/(1-X51)","v":19481.156219689889},null,null,{"$f":"AC53/(1-AA51)","v":20412.551038816739},"Z = Y / ( 1 - X ) "]
[]
[]
[null,"Incremental Revenue Requirement"]
[null,"Return on Rate Base - Total",null,"Q",{"$f":"E32","v":18299.477585560002},null,null,{"$f":"H32","v":36312.752702199999},null,null,{"$f":"K32","v":52734.733027000002},null,null,{"$f":"N32","v":72587.755265999993},null,null,{"$f":"Q32","v":85293.581775240018},null,null,{"$f":"T32","v":86978.974857759997},null,null,{"$f":"W32","v":75683.607439680025},null,null,{"$f":"Z32","v":68844.060566400003},null,null,{"$f":"AC32","v":62004.51369312001},"AF"]
[null,"Amortization Expense - Total",null,"S",{"$f":"E38","v":0},null,null,{"$f":"H38","v":0},null,null,{"$f":"K38","v":0},null,null,{"$f":"N38","v":139405.66},null,null,{"$f":"Q38","v":89824.08},null,null,{"$f":"T38","v":96764.24},null,null,{"$f":"W38","v":94919.88},null,null,{"$f":"Z38","v":94919.88},null,null,{"$f":"AC38","v":94919.88},"AG"]
[null,"Incremental Grossed Up PIL's",null,"Z",{"$f":"E55","v":-3918.9601356054422},null,null,{"$f":"H55","v":-7305.1802397142865},null,null,{"$f":"K55","v":-9582.3519189480267},null,null,{"$f":"N55","v":35969.270465356938},null,null,{"$f":"Q55","v":14290.287913312053},null,null,{"$f":"T55","v":14701.334306880546},null,null,{"$f":"W55","v":18358.067183574196},null,null,{"$f":"Z55","v":19481.156219689889},null,null,{"$f":"AC55","v":20412.551038816739},"AH"]
[]
[null,"Incremental Revenue Requirement",null,null,{"$f":"SUM(E59:E61)","v":14380.517449954559},null,null,{"$f":"SUM(H59:H61)","v":29007.572462485714},null,null,{"$f":"SUM(K59:K61)","v":43152.381108051974},null,null,{"$f":"SUM(N59:N61)","v":247962.68573135693},null,null,{"$f":"SUM(Q59:Q61)","v":189407.94968855209},null,null,{"$f":"SUM(T59:T61)","v":198444.54916464054},null,null,{"$f":"SUM(W59:W61)","v":188961.55462325423},null,null,{"$f":"SUM(Z59:Z61)","v":183245.09678608988},null,null,{"$f":"SUM(AC59:AC61)","v":177336.94473193676},"AJ = AF + AG + AH + AI"]

{"sheet":"6. True-up Summary","index":15,"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":14380.517449954559},null,{"$f":"'5. MIST Meters_IRR'!H63","v":29007.572462485714},null,{"$f":"'5. MIST Meters_IRR'!K63","v":43152.381108051974},null,{"$f":"'5. MIST Meters_IRR'!N63","v":247962.68573135693},null,{"$f":"'5. MIST Meters_IRR'!Q63","v":189407.94968855209},null,{"$f":"'5. MIST Meters_IRR'!T63","v":198444.54916464054},null,{"$f":"'5. MIST Meters_IRR'!W63","v":188961.55462325423},null,{"$f":"'5. MIST Meters_IRR'!Z63","v":183245.09678608988},null,{"$f":"'5. MIST Meters_IRR'!AC63","v":177336.94473193676},null,{"$f":"SUM(E14:U14)","v":1271899.2517463227}]
[]
[]
[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":14380.517449954559},{"$f":"F14-F17-F19","v":0},{"$f":"G14-G17-G19","v":29007.572462485714},null,{"$f":"I14-I17-I19","v":43152.381108051974},null,{"$f":"K14-K17-K19","v":247962.68573135693},null,{"$f":"M14-M17-M19","v":189407.94968855209},null,{"$f":"O14-O17-O19","v":198444.54916464054},null,{"$f":"Q14-Q17-Q19","v":188961.55462325423},null,{"$f":"S14-S17-S19","v":183245.09678608988},null,{"$f":"U14-U17-U19","v":177336.94473193676},null,{"$f":"SUM(E21:U21)","v":1271899.2517463227}]