{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["1. LDC Information","2. Smart Meter Data","3.  LDC Assumptions and Data","4. Smart Meter Rev Req","5. PILs","6. Avg Nt Fix Ass &UCC","7. Funding Adder Collected","8. Smart Meter Rate  Adder"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":16,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1. LDC Information","index":0,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,2,19,3],[12,0,12,1],[13,2,13,3],[15,2,15,3],[17,2,17,3]]}
[null,"Sheet 1 Utility Information Sheet"]
[]
[]
[null,"Name of LDC:","Chapleau Public Utilities Corporation"]
[]
[null,"Licence Number:","ED-2002-0528"]
[]
[]
[null,"Date of Submission:","2010-10-29"]
[]
[]
[]
["Contact Information"]
[null,"Name:","Marita Morin"]
[]
[null,"Title:","Secretary Treasurer"]
[]
[null,"Phone Number:","705-864-0111"]
[]
[null,"E-Mail Address:","chec@onlink.net"]

{"sheet":"2. Smart Meter Data","index":1,"n_rows":147,"n_cols":11,"rows_kept":147,"cut":false,"hidden":false,"merged":[[142,3,142,8],[134,3,134,8],[136,3,136,8],[119,3,119,8],[126,3,126,8],[132,3,132,8],[138,3,138,8],[140,3,140,8],[89,3,89,8],[91,3,91,8],[95,3,95,8],[87,3,87,8],[116,3,116,8],[105,3,105,8],[110,3,110,8],[93,3,93,8],[0,1,0,8],[41,3,41,8],[53,3,53,8],[56,3,56,8],[43,3,43,8],[85,3,85,8],[45,3,45,8],[59,3,59,8],[69,3,69,8],[71,3,71,8]]}
[null,"Sheet 2.  Smart Meter Capital Cost and Operational Expense Data"]
[]
[null,"Smart Meter Unit Installation Plan: "]
[null,"assume calendar year installation",null,2006,2007,2008,2009,2010,2011,"Later","Total"]
[null,null,null,"Audited Actual","Audited Actual","Audited Actual","Audited Actual","Actual","Forecasted","Forecasted"]
[null,null,null,0,0,0,1088,26,0,0,{"$f":"SUM(D6:J6)","v":1114}]
[]
[null,"Planned number of General Service Less Than 50 kW smart meters",null,0,0,0,67,58,36,0,{"$f":"SUM(D8:J8)","v":161}]
[]
[null,"Planned Meter Installation (Residential and Less Than 50 kW only)",null,{"$f":"SUM(D6,D8)","v":0},{"$f":"SUM(E6,E8)","v":0},0,1155,84,36,0,1275]
[]
[null,"Percentage of Completion",null,{"$f":"IF(ISERROR(SUM($D10:D10)/$K10),0,SUM($D10:D10)/$K10)","v":0},{"$f":"IF(ISERROR(SUM($D10:E10)/$K10),0,SUM($D10:E10)/$K10)","v":0},{"$f":"IF(ISERROR(SUM($D10:F10)/$K10),0,SUM($D10:F10)/$K10)","v":0},{"$f":"IF(ISERROR(SUM($D10:G10)/$K10),0,SUM($D10:G10)/$K10)","v":0.90588235294117647},{"$f":"IF(ISERROR(SUM($D10:H10)/$K10),0,SUM($D10:H10)/$K10)","v":0.97176470588235297},{"$f":"IF(ISERROR(SUM($D10:I10)/$K10),0,SUM($D10:I10)/$K10)","v":1},{"$f":"IF(ISERROR(SUM($D10:J10)/$K10),0,SUM($D10:J10)/$K10)","v":1}]
[]
[null,"Planned number of General Service Greater Than 50 kW smart meters",null,0,null,0,0,0,0,0,{"$f":"SUM(D14:J14)","v":0}]
[]
[null,"Planned / Actual Meter Installations",null,{"$f":"SUM(D10,D14)","v":0},0,0,1155,84,36,0,{"$f":"SUM(D16:J16)","v":1275}]
[]
[null,"Other Unit Installation Plan: "]
[null,"assume calendar year installation",null,{"$f":"D4","v":2006},{"$f":"E4","v":2007},2008,2009,2010,2011,"Later","Total"]
[null,null,null,{"$f":"D5","v":"Audited Actual"},{"$f":"E5","v":"Audited Actual"},"Audited Actual","Audited Actual","Actual","Forecasted","Forecasted"]
[null,"Planned number of Collectors to be installed",null,0,0,0,1,0,0,0,{"$f":"SUM(D21:J21)","v":1}]
[]
[null,"Planned number of Repeaters to be installed",null,0,0,0,0,0,0,0,{"$f":"SUM(D23:J23)","v":0}]
[]
[null,"Other : Please specify"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D26:J26)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D28:J28)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D30:J30)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D32:J32)","v":0}]
[]
[]
[null,"Capital Costs"]
[null,"1.1 ADVANCED METERING COMMUNICATION DEVICE (AMCD)","Asset Type"]
[null,null,null,{"$f":"D19","v":2006},{"$f":"E19","v":2007},2008,2009,2010,2011,"Later","Total"]
[null,null,null,{"$f":"D20","v":"Audited Actual"},{"$f":"E20","v":"Audited Actual"},"Audited Actual","Audited Actual","Actual","Forecasted","Forecasted"]
[null,"1.1.1 Smart Meter  ","Smart Meter",0,0,0,106554.12,10736.9,9000,0,{"$f":"SUM(D39:J39)","v":126291.01999999999}]
[null,"may include new meters and modules, etc."]
[null,"1.1.2 Installation Cost ","Smart Meter",0,0,0,14719.33,400,400,0,{"$f":"SUM(D41:J41)","v":15519.33}]
[null,"may include socket kits plus shipping, labour, benefits, vehicle, etc."]
[null,"1.1.3a Workforce Automation Hardware","Comp. Hard.",0,0,0,4298.62,0,0,0,{"$f":"SUM(D43:J43)","v":4298.62}]
[null,"may include fieldworker handhelds, barcode hardware, etc."]
[null,"1.1.3b Workforce Automation Software","Comp. Soft.",null,null,null,null,null,null,null,{"$f":"SUM(D45:J45)","v":0}]
[null,"may include fieldworker handhelds, barcode hardware, etc."]
[]
[null,"Total Advanced Metering Communication Device (AMCD)",null,{"$f":"SUM(D39,D41,D43,D45)","v":0},0,0,125572.06999999999,11136.9,9400,0,146108.96999999997]
[]
[null,"1.2 ADVANCED METERING REGIONAL COLLECTOR (AMRC) (includes LAN)"]
[null,null,null,{"$f":"D4","v":2006},{"$f":"E4","v":2007},2008,2009,2010,2011,"Later","Total"]
[null,null,null,{"$f":"D5","v":"Audited Actual"},{"$f":"E5","v":"Audited Actual"},"Audited Actual","Audited Actual","Actual","Forecasted","Forecasted"]
[null,"1.2.1 Collectors","Smart Meter",0,0,0,162420.49,0,0,0,{"$f":"SUM(D53:J53)","v":162420.49}]
[]
[]
[null,"1.2.2 Repeaters","Smart Meter",0,0,0,0,0,0,0,{"$f":"SUM(D56:J56)","v":0}]
[null,"may include radio licence, etc."]
[]
[null,"1.2.3 Installation","Smart Meter",0,0,0,2654.29,0,0,0,{"$f":"SUM(D59:J59)","v":2654.29}]
[null,"may include meter seals and rings, collector computer hardware, etc."]
[]
[null,"Total Advanced Metering Regional Collector (AMRC) (includes LAN)",null,{"$f":"SUM(D53,D56,D59)","v":0},0,0,165074.78,0,0,0,165074.78]
[]
[null,"1.3 ADVANCED METERING CONTROL COMPUTER (AMCC)"]
[null,null,null,{"$f":"D4","v":2006},{"$f":"E4","v":2007},2008,2009,2010,2011,"Later","Total"]
[null,null,null,{"$f":"D5","v":"Audited Actual"},{"$f":"E5","v":"Audited Actual"},"Audited Actual","Audited Actual","Actual","Forecasted","Forecasted"]
[null,"1.3.1 Computer Hardware","Comp. Hard.",null,null,null,null,null,null,null,{"$f":"SUM(D67:J67)","v":0}]
[]
[null,"1.3.2 Computer Software","Comp. Soft.",null,null,null,null,null,null,null,{"$f":"SUM(D69:J69)","v":0}]
[]
[null,"1.3.3 Computer Software Licence & Installation (includes hardware & software)","Comp. Soft.",null,null,null,null,null,null,null,{"$f":"SUM(D71:J71)","v":0}]
[null,"may include AS/400 disc space, backup & recovery computer, UPS, etc"]
[null,"Total Advanced Metering Control Computer (AMCC)",null,{"$f":"SUM(D67,D69,D71)","v":0},0,0,0,0,0,0,0]
[]
[]
[null,"1.4 WIDE AREA NETWORK (WAN)",null,{"$f":"D4","v":2006},{"$f":"E4","v":2007},2008,2009,2010,2011,"Later","Total"]
[null,null,null,{"$f":"D5","v":"Audited Actual"},{"$f":"E5","v":"Audited Actual"},"Audited Actual","Audited Actual","Actual","Forecasted","Forecasted"]
[null,"1.4.1 Activation Fees","Tools & Equip",null,null,null,null,null,null,null,{"$f":"SUM(D78:J78)","v":0}]
[]
[null,"Total Wide Area Network (WAN)",null,{"$f":"SUM(D78)","v":0},0,0,0,0,0,0,0]
[]
[]
[null,"1.5 OTHER AMI CAPITAL COSTS RELATED TO MINIMUM FUNCTIONALITY",null,{"$f":"D4","v":2006},{"$f":"E4","v":2007},2008,2009,2010,2011,"Later","Total"]
[null,null,null,{"$f":"D5","v":"Audited Actual"},{"$f":"E5","v":"Audited Actual"},"Audited Actual","Audited Actual","Actual","Forecasted","Forecasted"]
[null,"1.5.1 Customer equipment (including repair of damaged equipment)","Other Equip.",null,null,null,null,null,null,null,{"$f":"SUM(D85:J85)","v":0}]
[]
[null,"1.5.2 AMI Interface to CIS","Comp. Soft.",0,0,0,3800,{"$f":"7226.2+6000","v":13226.2},8000,0,{"$f":"SUM(D87:J87)","v":25026.2}]
[]
[null,"1.5.3 Professional Fees","Comp. Soft.",0,0,9429.52,17620.77,{"$f":"10912.21+2500","v":13412.21},5000,0,{"$f":"SUM(D89:J89)","v":45462.5}]
[]
[null,"1.5.4 Integration","Comp. Soft.",0,0,0,0,8100,0,0,{"$f":"SUM(D91:J91)","v":8100}]
[]
[null,"1.5.5 Program Management","Comp. Soft.",0,0,0,0,0,0,0,{"$f":"SUM(D93:J93)","v":0}]
[]
[null,"1.5.6 Other AMI Capital","Comp. Soft.",0,0,0,2630.8,4052.8,0,0,{"$f":"SUM(D95:J95)","v":6683.6}]
[]
[null,"Total Other AMI Capital Costs Related To Minimum Functionality",null,{"$f":"SUM(D85,D87,D89,D91,D95,D93)","v":0},0,9429.52,24051.57,38791.210000000006,13000,0,85272.3]
[]
[null,"Total Capital Costs",null,{"$f":"SUM(D48,D62,D80,D97,D73)","v":0},0,9429.52,314698.42,49928.110000000008,22400,0,396456.05]
[]
[null,"O M & A"]
[null,"2.1 ADVANCED METERING COMMUNICATION DEVICE (AMCD)"]
[null,null,null,{"$f":"D4","v":2006},{"$f":"E4","v":2007},2008,2009,2010,2011,"Later","Total"]
[null,null,null,{"$f":"D5","v":"Audited Actual"},{"$f":"E5","v":"Audited Actual"},"Audited Actual","Audited Actual","Actual","Forecasted","Forecasted"]
[null,"2.1.1 Maintenance",null,null,null,null,null,null,null,null,{"$f":"SUM(D105:J105)","v":0}]
[null,"may include meter reverification costs, etc."]
[null,"Total Incremental AMI Operation Expenses",null,{"$f":"SUM(D105)","v":0},0,0,0,0,0,0,0]
[]
[null,"2.2 ADVANCED METERING REGIONAL COLLECTOR (AMRC) (includes LAN)"]
[null,"2.2.1 Maintenance",null,null,null,null,null,null,null,null,{"$f":"SUM(D110:J110)","v":0}]
[]
[]
[null,"Total Advanced Metering Regional Collector (AMRC) (includes LAN)",null,{"$f":"SUM(D110)","v":0},0,0,0,0,0,0,0]
[]
[null,"2.3 ADVANCED METERING CONTROL COMPUTER (AMCC)"]
[null,"2.3.1 Hardware Maintenance",null,null,null,null,null,null,null,null,{"$f":"SUM(D116:J116)","v":0}]
[null,"may include server support, etc"]
[]
[null,"2.3.2 Software Maintenance",null,null,null,null,null,null,null,null,{"$f":"SUM(D119:J119)","v":0}]
[null,"may include maintenance support, etc."]
[]
[null,"Total Advanced Metering Control Computer (AMCC)",null,{"$f":"SUM(D116,D119)","v":0},0,0,0,0,0,0,0]
[]
[null,"2.4 WIDE AREA NETWORK (WAN)"]
[]
[null,"2.4.1 WIDE AREA NETWORK (WAN)",null,0,0,0,18310.96,{"$f":"21143.81+7500","v":28643.81},28600,28600,{"$f":"SUM(D126:J126)","v":104154.77}]
[null,"may include serial to Ethernet hardware, etc."]
[]
[null,"Total Incremental Other Operation Expenses",null,{"$f":"SUM(D126)","v":0},0,0,18310.96,28643.81,28600,28600,104154.77]
[]
[null,"2.5 OTHER AMI OM&A COSTS RELATED TO MINIMUM FUNCTIONALITY"]
[null,"2.5.1 Business Process Redesign",null,null,null,null,null,null,null,null,{"$f":"SUM(D132:J132)","v":0}]
[]
[null,"2.5.2 Customer Communication",null,null,null,null,null,null,null,null,{"$f":"SUM(D134:J134)","v":0}]
[null,"may include project communication. etc."]
[null,"2.5.3 Program Management",null,0,0,0,0,{"$f":"1381.19+460","v":1841.19},1900,1900,{"$f":"SUM(D136:J136)","v":5641.1900000000005}]
[]
[null,"2.5.4 Change Management",null,null,null,null,null,null,null,null,{"$f":"SUM(D138:J138)","v":0}]
[null,"may include training, etc."]
[null,"2.5.5 Administration Cost",null,null,null,null,null,null,null,null,{"$f":"SUM(D140:J140)","v":0}]
[]
[null,"2.5.6 Other AMI Expenses",null,null,null,null,null,null,null,null,{"$f":"SUM(D142:J142)","v":0}]
[]
[]
[null,"Total 2.5 Other AMI OM&A Costs Related To Minimum Functionality",null,{"$f":"SUM(D132,D134,D136,D138,D140,D142)","v":0},0,0,0,1841.19,1900,1900,5641.1900000000005]
[]
[null,"Total O M & A Costs",null,{"$f":"SUM(D107,D113,D122,D129,D145)","v":0},0,0,18310.96,30485,30500,30500,109795.96]

{"sheet":"3.  LDC Assumptions and Data","index":2,"n_rows":75,"n_cols":10,"rows_kept":75,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
[null,"Sheet 3.  LDC Assumptions and Data"]
[]
[]
[null,"Assumptions:"]
[null,"1. Planned meter installations occur evenly through the year."]
[null,"2. Year assumed January to December"]
[null,"3. Amortization is straight line and has half year rule applied in first year"]
[]
[]
[null,null,"2006 EDR Data Information",{"$f":"D29","v":2007},2008,2009,2010,2011,"Later"]
[]
[null,"Rate Base"]
[]
[null,"Deemed Short Term Debt %",null,null,0.04,0.04,0.04,0.04,0.04]
[null,"Deemed Debt",0.5,0.5,0.49299999999999999,0.52700000000000002,0.56000000000000005,0.56000000000000005,0]
[null,"Deemed Equity ",{"$f":"1-C15","v":0.5},{"$f":"1-D15","v":0.5},{"$f":"1-E15-E14","v":0.46700000000000003},{"$f":"1-F15-F14","v":0.433},{"$f":"1-G15-G14","v":0.39999999999999997},{"$f":"1-H15-H14","v":0.39999999999999997},{"$f":"1-I15-I14","v":0.96}]
[]
[null,"Deemed Short Term Debt  Rate%",null,null,4.4699999999999997E-2,1.1299999999999999E-2,1.1299999999999999E-2,1.1299999999999999E-2,1.1299999999999999E-2]
[null,"Weighted Debt Rate",0,0,0,0,0,0,0]
[null,"Proposed ROE",0.09,0.09,8.5699999999999998E-2,8.0100000000000005E-2,8.0100000000000005E-2,8.0100000000000005E-2,8.0100000000000005E-2]
[null,"Weighted Average Cost of Capital",{"$f":"(C19*C15)+(C16*C20)","v":4.4999999999999998E-2},{"$f":"(D19*D15)+(D16*D20)","v":4.4999999999999998E-2},{"$f":"(E14*E18)+(E15*E19)+(E16*E20)","v":4.1809899999999997E-2},{"$f":"(F14*F18)+(F15*F19)+(F16*F20)","v":3.5135300000000001E-2},{"$f":"(G14*G18)+(G15*G19)+(G16*G20)","v":3.2492E-2},{"$f":"(H14*H18)+(H15*H19)+(H16*H20)","v":3.2492E-2},{"$f":"(I14*I18)+(I15*I19)+(I16*I20)","v":7.7348E-2}]
[]
[null,"Working Capital Allowance %",0.15,0.15,0.15,0.15,0.15,0.15,0.15]
[]
[null,"2006 EDR Tax Rate"]
[null,"Corporate Income Tax Rate ",0.36120000000000002,0.36120000000000002,0.33500000000000002,0.33,0.31,0.28249999999999997,0.26250000000000001]
[]
[]
[null,"Capital Data: ",{"$f":"'2. Smart Meter Data'!D4","v":2006},{"$f":"'2. Smart Meter Data'!E4","v":2007},{"$f":"'2. Smart Meter Data'!F4","v":2008},{"$f":"'2. Smart Meter Data'!G4","v":2009},{"$f":"'2. Smart Meter Data'!H4","v":2010},{"$f":"'2. Smart Meter Data'!I4","v":2011},{"$f":"'2. Smart Meter Data'!J4","v":"Later"},"Total"]
[null,null,{"$f":"'2. Smart Meter Data'!D5","v":"Audited Actual"},{"$f":"'2. Smart Meter Data'!E5","v":"Audited Actual"},{"$f":"'2. Smart Meter Data'!F5","v":"Audited Actual"},{"$f":"'2. Smart Meter Data'!G5","v":"Audited Actual"},{"$f":"'2. Smart Meter Data'!H5","v":"Actual"},{"$f":"'2. Smart Meter Data'!I5","v":"Forecasted"},{"$f":"'2. Smart Meter Data'!J5","v":"Forecasted"}]
[null,"Smart Meter",{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Smart Meter\",'2. Smart Meter Data'!D:D)","v":0},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Smart Meter\",'2. Smart Meter Data'!E:E)","v":0},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Smart Meter\",'2. Smart Meter Data'!F:F)","v":0},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Smart Meter\",'2. Smart Meter Data'!G:G)","v":286348.23},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Smart Meter\",'2. Smart Meter Data'!H:H)","v":11136.9},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Smart Meter\",'2. Smart Meter Data'!I:I)","v":9400},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Smart Meter\",'2. Smart Meter Data'!J:J)","v":0},{"$f":"SUM(C31:H31)","v":306885.13}]
[null,"Computer Hardware",{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Comp. Hard.\",'2. Smart Meter Data'!D:D)","v":0},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Comp. Hard.\",'2. Smart Meter Data'!E:E)","v":0},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Comp. Hard.\",'2. Smart Meter Data'!F:F)","v":0},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Comp. Hard.\",'2. Smart Meter Data'!G:G)","v":4298.62},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Comp. Hard.\",'2. Smart Meter Data'!H:H)","v":0},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Comp. Hard.\",'2. Smart Meter Data'!I:I)","v":0},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Comp. Hard.\",'2. Smart Meter Data'!J:J)","v":0},{"$f":"SUM(C32:H32)","v":4298.62}]
[null,"Computer Software",{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Comp. Soft.\",'2. Smart Meter Data'!D:D)","v":0},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Comp. Soft.\",'2. Smart Meter Data'!E:E)","v":0},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Comp. Soft.\",'2. Smart Meter Data'!F:F)","v":9429.52},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Comp. Soft.\",'2. Smart Meter Data'!G:G)","v":24051.57},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Comp. Soft.\",'2. Smart Meter Data'!H:H)","v":38791.210000000006},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Comp. Soft.\",'2. Smart Meter Data'!I:I)","v":13000},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Comp. Soft.\",'2. Smart Meter Data'!J:J)","v":0},{"$f":"SUM(C33:H33)","v":85272.3}]
[null,"Tools & Equipment",{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Tools & Equip\",'2. Smart Meter Data'!D:D)","v":0},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Tools & Equip\",'2. Smart Meter Data'!E:E)","v":0},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Tools & Equip\",'2. Smart Meter Data'!F:F)","v":0},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Tools & Equip\",'2. Smart Meter Data'!G:G)","v":0},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Tools & Equip\",'2. Smart Meter Data'!H:H)","v":0},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Tools & Equip\",'2. Smart Meter Data'!I:I)","v":0},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Tools & Equip\",'2. Smart Meter Data'!J:J)","v":0},{"$f":"SUM(C34:H34)","v":0}]
[null,"Other Equipment",{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Other Equip.\",'2. Smart Meter Data'!D:D)","v":0},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Other Equip.\",'2. Smart Meter Data'!E:E)","v":0},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Other Equip.\",'2. Smart Meter Data'!F:F)","v":0},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Other Equip.\",'2. Smart Meter Data'!G:G)","v":0},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Other Equip.\",'2. Smart Meter Data'!H:H)","v":0},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Other Equip.\",'2. Smart Meter Data'!I:I)","v":0},{"$f":"SUMIF('2. Smart Meter Data'!$C:$J,\"Other Equip.\",'2. Smart Meter Data'!J:J)","v":0},{"$f":"SUM(C35:H35)","v":0}]
[null,"Total Capital Costs",{"$f":"SUM(C31:C33)","v":0},0,9429.52,314698.42,49928.110000000008,22400,0,396456.05]
[null,null,{"$f":"'2. Smart Meter Data'!D99-C36","v":0},{"$f":"'2. Smart Meter Data'!E99-D36","v":0},{"$f":"'2. Smart Meter Data'!F99-E36","v":0},{"$f":"'2. Smart Meter Data'!G99-F36","v":0},{"$f":"'2. Smart Meter Data'!H99-G36","v":0},{"$f":"'2. Smart Meter Data'!I99-H36","v":0},{"$f":"'2. Smart Meter Data'!J99-I36","v":0},{"$f":"'2. Smart Meter Data'!K99-J36","v":0}]
[]
[null,null,{"$f":"C29","v":2006},{"$f":"D29","v":2007},2008,2009,2010,2011,"Later","Total"]
[null,"Operating Expense Data:",{"$f":"C30","v":"Audited Actual"},{"$f":"D30","v":"Audited Actual"},"Audited Actual","Audited Actual","Actual","Forecasted","Forecasted"]
[null,"2.1 Advanced Metering Communication Device (AMCD)",{"$f":"'2. Smart Meter Data'!D107","v":0},{"$f":"'2. Smart Meter Data'!E107","v":0},{"$f":"'2. Smart Meter Data'!F107","v":0},{"$f":"'2. Smart Meter Data'!G107","v":0},{"$f":"'2. Smart Meter Data'!H107","v":0},{"$f":"'2. Smart Meter Data'!I107","v":0},{"$f":"'2. Smart Meter Data'!J107","v":0},{"$f":"SUM(C41:H41)","v":0}]
[null,"2.2 Advanced Metering Regional Collector (AMRC) (includes LAN)",{"$f":"'2. Smart Meter Data'!D113","v":0},{"$f":"'2. Smart Meter Data'!E113","v":0},{"$f":"'2. Smart Meter Data'!F113","v":0},{"$f":"'2. Smart Meter Data'!G113","v":0},{"$f":"'2. Smart Meter Data'!H113","v":0},{"$f":"'2. Smart Meter Data'!I113","v":0},{"$f":"'2. Smart Meter Data'!J113","v":0},{"$f":"SUM(C42:H42)","v":0}]
[null,"2.3 Advanced Metering Control Computer (AMCC)",{"$f":"'2. Smart Meter Data'!D122","v":0},{"$f":"'2. Smart Meter Data'!E122","v":0},{"$f":"'2. Smart Meter Data'!F122","v":0},{"$f":"'2. Smart Meter Data'!G122","v":0},{"$f":"'2. Smart Meter Data'!H122","v":0},{"$f":"'2. Smart Meter Data'!I122","v":0},{"$f":"'2. Smart Meter Data'!J122","v":0},{"$f":"SUM(C43:H43)","v":0}]
[null,"2.4 Wide Area Network (WAN)",{"$f":"'2. Smart Meter Data'!D129","v":0},{"$f":"'2. Smart Meter Data'!E129","v":0},{"$f":"'2. Smart Meter Data'!F129","v":0},{"$f":"'2. Smart Meter Data'!G129","v":18310.96},{"$f":"'2. Smart Meter Data'!H129","v":28643.81},{"$f":"'2. Smart Meter Data'!I129","v":28600},{"$f":"'2. Smart Meter Data'!J129","v":28600},{"$f":"SUM(C44:H44)","v":75554.77}]
[null,"2.5 Other AMI OM&A Costs Related To Minimum Functionality",{"$f":"'2. Smart Meter Data'!D145","v":0},{"$f":"'2. Smart Meter Data'!E145","v":0},{"$f":"'2. Smart Meter Data'!F145","v":0},{"$f":"'2. Smart Meter Data'!G145","v":0},{"$f":"'2. Smart Meter Data'!H145","v":1841.19},{"$f":"'2. Smart Meter Data'!I145","v":1900},{"$f":"'2. Smart Meter Data'!J145","v":1900},{"$f":"SUM(C45:H45)","v":3741.19}]
[null,"Total O M & A Costs",{"$f":"SUM(C41:C45)","v":0},0,0,18310.96,30485,30500,30500,79295.960000000006]
[null,null,{"$f":"'2. Smart Meter Data'!D147-C46","v":0},{"$f":"'2. Smart Meter Data'!E147-D46","v":0},{"$f":"'2. Smart Meter Data'!F147-E46","v":0},{"$f":"'2. Smart Meter Data'!G147-F46","v":0},{"$f":"'2. Smart Meter Data'!H147-G46","v":0},{"$f":"'2. Smart Meter Data'!I147-H46","v":0},{"$f":"'2. Smart Meter Data'!J147-I46","v":0},{"$f":"'2. Smart Meter Data'!K147-J46","v":30500}]
[]
[null,"Per Meter Cost Split:","Per Meter","Installed","Investment","% of Invest"]
[null,"Smart meter including installation",{"$f":"IF(ISERROR(E50/D50),0,E50/D50)","v":240.69421960784314},{"$f":"'2. Smart Meter Data'!K10","v":1275},{"$f":"J31","v":306885.13},{"$f":"IF(ISERROR(E50/$E$56),0,E50/$E$56)","v":0.64505272400215397}]
[null,"Computer Hardware Costs",3.3714666666666666,{"$f":"D50","v":1275},{"$f":"J32","v":4298.62},9.0354216264898167E-3]
[null,"Computer Software Costs",66.880235294117654,{"$f":"D51","v":1275},{"$f":"J33","v":85272.3},0.17923686754366]
[null,"Tools & Equipment",0,{"$f":"D52","v":1275},{"$f":"J34","v":0},0]
[null,"Other Equipment",0,{"$f":"D53","v":1275},{"$f":"J35","v":0},0]
[null,"Smart meter incremental operating expenses",62.192909803921573,{"$f":"D52","v":1275},{"$f":"J46","v":79295.960000000006},0.16667498682769624]
[null,"Total Smart Meter Capital Costs per meter",{"$f":"SUM(C50:C55)","v":373.13883137254902},null,{"$f":"SUM(E50:E55)","v":475752.01},{"$f":"SUM(F50:F55)","v":1}]
[]
[null,null,{"$f":"C39","v":2006},{"$f":"D39","v":2007},2008,2009,2010,2011,"Later"]
[null,"Depreciation Rates",{"$f":"C40","v":"Audited Actual"},{"$f":"D40","v":"Audited Actual"},"Audited Actual","Audited Actual","Actual","Forecasted","Forecasted"]
[null,"Smart Meter (years)",15,15,15,15,15,15,15]
[null,"Computer Hardware  (years)",10,10,10,10,10,10,10]
[null,"Computer Software  (years)",5,5,5,5,5,5,5]
[null,"Tools & Equipment  (years)",10,10,10,10,10,10,10]
[null,"Other Equipment  (years)",10,10,10,10,10,10,10]
[]
[null,null,{"$f":"C58","v":2006},{"$f":"D58","v":2007},2008,2009,2010,2011,"Later"]
[null,"CCA Rates",{"$f":"C59","v":"Audited Actual"},{"$f":"D59","v":"Audited Actual"},"Audited Actual","Audited Actual","Actual","Forecasted","Forecasted"]
[null,"CCA Class",47,47,47,47,47,47,47]
[null,"Smart Meter",0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[]
[null,"CCA Class",45,50,50,50,50,50,50]
[null,"Computer Equipment",0.45,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.55000000000000004]
[]
[null,"CCA Class",8,8,8,8,8,8,8]
[null,"General Equipment",0.2,0.2,0.2,0.2,0.2,0.2,0.2]

{"sheet":"4. Smart Meter Rev Req","index":3,"n_rows":55,"n_cols":23,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,1,0,3],[6,2,6,4],[6,5,6,7],[6,8,6,10],[5,8,5,10],[5,2,5,4],[5,5,5,7],[5,20,5,22],[6,20,6,22],[6,11,6,13],[6,14,6,16],[5,17,5,19],[6,17,6,19],[5,11,5,13],[5,14,5,16]]}
[null,"Sheet 4. Smart Meter Rev Req Calc"]
[]
[]
["Smart Meter Revenue Requirement Calculation"]
[]
[null,"Average Asset Values",{"$f":"'2. Smart Meter Data'!D4","v":2006},null,null,{"$f":"'2. Smart Meter Data'!E4","v":2007},null,null,{"$f":"'2. Smart Meter Data'!F4","v":2008},null,null,{"$f":"'2. Smart Meter Data'!G4","v":2009},null,null,{"$f":"'2. Smart Meter Data'!H4","v":2010},null,null,{"$f":"'2. Smart Meter Data'!I4","v":2011},null,null,{"$f":"'2. Smart Meter Data'!J4","v":"Later"}]
[null,null,{"$f":"'2. Smart Meter Data'!D5","v":"Audited Actual"},null,null,{"$f":"'2. Smart Meter Data'!E5","v":"Audited Actual"},null,null,{"$f":"'2. Smart Meter Data'!F5","v":"Audited Actual"},null,null,{"$f":"'2. Smart Meter Data'!G5","v":"Audited Actual"},null,null,{"$f":"'2. Smart Meter Data'!H5","v":"Actual"},null,null,{"$f":"'2. Smart Meter Data'!I5","v":"Forecasted"},null,null,{"$f":"'2. Smart Meter Data'!J5","v":"Forecasted"}]
[null,"Net Fixed Assets Smart Meters",{"$f":"'6. Avg Nt Fix Ass &UCC'!C18","v":0},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!D18","v":0},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!E18","v":0},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!F18","v":138401.64449999999},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!G18","v":272641.18299999996},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!H18","v":263106.23933333333},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!M18","v":0}]
[null,"Net Fixed Assets Computer Hardware",{"$f":"'6. Avg Nt Fix Ass &UCC'!C33","v":0},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!D33","v":0},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!E33","v":0},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!F33","v":2041.8444999999999},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!G33","v":3868.7579999999998},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!H33","v":3438.8960000000002},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!I33","v":0}]
[null,"Net Fixed Assets Computer Software",{"$f":"'6. Avg Nt Fix Ass &UCC'!C48","v":0},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!D48","v":0},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!E48","v":4243.2840000000006},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!F48","v":18366.822499999998},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!G48","v":42355.012499999997},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!H48","v":55085.718000000008},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!I48","v":0}]
[null,"Net Fixed Assets Tools & Equipment",{"$f":"'6. Avg Nt Fix Ass &UCC'!C63","v":0},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!D63","v":0},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!E63","v":0},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!F63","v":0},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!G63","v":0},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!H63","v":0},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!I63","v":0}]
[null,"Net Fixed Assets Other Equipment",{"$f":"'6. Avg Nt Fix Ass &UCC'!C78","v":0},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!D78","v":0},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!E78","v":0},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!F78","v":0},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!G78","v":0},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!H78","v":0},null,null,{"$f":"'6. Avg Nt Fix Ass &UCC'!I78","v":0}]
[null,"Total Net Fixed Assets",{"$f":"SUM(C8:C12)","v":0},{"$f":"C13","v":0},null,{"$f":"SUM(F8:F12)","v":0},{"$f":"F13","v":0},null,{"$f":"SUM(I8:I12)","v":4243.2840000000006},{"$f":"I13","v":4243.2840000000006},null,{"$f":"SUM(L8:L12)","v":158810.31150000001},{"$f":"L13","v":158810.31150000001},null,{"$f":"SUM(O8:O12)","v":318864.95349999995},{"$f":"O13","v":318864.95349999995},null,{"$f":"SUM(R8:R12)","v":321630.85333333333},{"$f":"R13","v":321630.85333333333},null,{"$f":"SUM(U8:U12)","v":0},{"$f":"U13","v":0}]
[]
[null,"Working Capital"]
[null,"Operation Expense",{"$f":"E33","v":0},null,null,{"$f":"H33","v":0},null,null,{"$f":"K33","v":0},null,null,{"$f":"N33","v":18310.96},null,null,{"$f":"Q33","v":30485},null,null,{"$f":"T33","v":30500},null,null,{"$f":"W33","v":30500}]
[null,{"$f":"\"Working Capital  %\"","v":"Working Capital  %"},{"$f":"C16*'3.  LDC Assumptions and Data'!$C$23","v":0},{"$f":"C17","v":0},null,{"$f":"F16*'3.  LDC Assumptions and Data'!$D$23","v":0},{"$f":"F17","v":0},null,{"$f":"I16*'3.  LDC Assumptions and Data'!$E$23","v":0},{"$f":"I17","v":0},null,{"$f":"L16*'3.  LDC Assumptions and Data'!$F$23","v":2746.6439999999998},{"$f":"L17","v":2746.6439999999998},null,{"$f":"O16*'3.  LDC Assumptions and Data'!$G$23","v":4572.75},{"$f":"O17","v":4572.75},null,{"$f":"R16*'3.  LDC Assumptions and Data'!$H$23","v":4575},{"$f":"R17","v":4575},null,{"$f":"U16*'3.  LDC Assumptions and Data'!$I$23","v":4575},{"$f":"U17","v":4575}]
[]
[null,"Smart Meters included in Rate Base",null,{"$f":"SUM(D9:D17)","v":0},null,null,{"$f":"SUM(G9:G17)","v":0},null,null,{"$f":"SUM(J9:J17)","v":4243.2840000000006},null,null,{"$f":"SUM(M9:M17)","v":161556.95550000001},null,null,{"$f":"SUM(P9:P17)","v":323437.70349999995},null,null,{"$f":"SUM(S9:S17)","v":326205.85333333333},null,null,{"$f":"SUM(V9:V17)","v":4575}]
[]
[null,"Return on Rate Base"]
[null,"Deemed Short Term Debt %",null,null,null,null,null,null,{"$f":"'3.  LDC Assumptions and Data'!$E$14","v":0.04},null,null,{"$f":"'3.  LDC Assumptions and Data'!$F14","v":0.04},null,null,{"$f":"'3.  LDC Assumptions and Data'!$G14","v":0.04},null,null,{"$f":"'3.  LDC Assumptions and Data'!$H14","v":0.04},null,null,{"$f":"'3.  LDC Assumptions and Data'!$I14","v":0.04}]
[null,"Deemed Long Term Debt %",{"$f":"'3.  LDC Assumptions and Data'!$C$15","v":0.5},{"$f":"D19*C23","v":0},null,{"$f":"'3.  LDC Assumptions and Data'!$D$15","v":0.5},{"$f":"G19*F23","v":0},null,{"$f":"'3.  LDC Assumptions and Data'!$E$15","v":0.49299999999999999},{"$f":"J19*I23","v":2091.9390120000003},null,{"$f":"'3.  LDC Assumptions and Data'!$F15","v":0.52700000000000002},{"$f":"M19*L23","v":85140.515548500014},null,{"$f":"'3.  LDC Assumptions and Data'!$G15","v":0.56000000000000005},{"$f":"P19*O23","v":181125.11395999999},null,{"$f":"'3.  LDC Assumptions and Data'!$H15","v":0.56000000000000005},{"$f":"S19*R23","v":182675.27786666667},null,{"$f":"'3.  LDC Assumptions and Data'!$I15","v":0},{"$f":"V19*U23","v":0}]
[null,"Deemed Equity %",{"$f":"'3.  LDC Assumptions and Data'!$C$16","v":0.5},{"$f":"D19*C24","v":0},null,{"$f":"'3.  LDC Assumptions and Data'!$D$16","v":0.5},{"$f":"G19*F24","v":0},null,{"$f":"'3.  LDC Assumptions and Data'!$E$16","v":0.46700000000000003},{"$f":"J19*I24","v":1981.6136280000003},null,{"$f":"'3.  LDC Assumptions and Data'!$F$16","v":0.433},{"$f":"M19*L24","v":69954.161731500004},null,{"$f":"'3.  LDC Assumptions and Data'!$G$16","v":0.39999999999999997},{"$f":"P19*O24","v":129375.08139999997},null,{"$f":"'3.  LDC Assumptions and Data'!$H$16","v":0.39999999999999997},{"$f":"S19*R24","v":130482.34133333332},null,{"$f":"'3.  LDC Assumptions and Data'!$I$16","v":0.96},{"$f":"V19*U24","v":4392}]
[null,null,null,{"$f":"SUM(D23:D24)","v":0},null,null,{"$f":"SUM(G23:G24)","v":0},null,null,{"$f":"SUM(J23:J24)","v":4073.5526400000008},null,null,{"$f":"SUM(M23:M24)","v":155094.67728},null,null,{"$f":"SUM(P23:P24)","v":310500.19535999995},null,null,{"$f":"SUM(S23:S24)","v":313157.61919999996},null,null,{"$f":"SUM(V23:V24)","v":4392}]
[]
[null,"Deemed Short Term Debt Rate%",null,null,null,null,null,null,{"$f":"'3.  LDC Assumptions and Data'!$E$18","v":4.4699999999999997E-2},null,null,{"$f":"'3.  LDC Assumptions and Data'!$F18","v":1.1299999999999999E-2},null,null,{"$f":"'3.  LDC Assumptions and Data'!$G18","v":1.1299999999999999E-2},null,null,{"$f":"'3.  LDC Assumptions and Data'!$H18","v":1.1299999999999999E-2},null,null,{"$f":"'3.  LDC Assumptions and Data'!$I18","v":1.1299999999999999E-2}]
[null,"Weighted Debt Rate (3.  LDC Assumptions and Data)",{"$f":"'3.  LDC Assumptions and Data'!$C$19","v":0},{"$f":"D23*C28","v":0},null,{"$f":"'3.  LDC Assumptions and Data'!$D$19","v":0},{"$f":"G23*F28","v":0},null,{"$f":"'3.  LDC Assumptions and Data'!$E$19","v":0},{"$f":"J23*I28","v":0},null,{"$f":"'3.  LDC Assumptions and Data'!$F19","v":0},{"$f":"M23*L28","v":0},null,{"$f":"'3.  LDC Assumptions and Data'!$G19","v":0},{"$f":"P23*O28","v":0},null,{"$f":"'3.  LDC Assumptions and Data'!$H19","v":0},{"$f":"S23*R28","v":0},null,{"$f":"'3.  LDC Assumptions and Data'!$I19","v":0},{"$f":"V23*U28","v":0}]
[null,"Proposed ROE (3.  LDC Assumptions and Data)",{"$f":"'3.  LDC Assumptions and Data'!$C$20","v":0.09},{"$f":"D24*C29","v":0},null,{"$f":"'3.  LDC Assumptions and Data'!$D$20","v":0.09},{"$f":"G24*F29","v":0},null,{"$f":"'3.  LDC Assumptions and Data'!$E$20","v":8.5699999999999998E-2},{"$f":"J24*I29","v":169.82428791960001},null,{"$f":"'3.  LDC Assumptions and Data'!$F$20","v":8.0100000000000005E-2},{"$f":"M24*L29","v":5603.3283546931507},null,{"$f":"'3.  LDC Assumptions and Data'!$G$20","v":8.0100000000000005E-2},{"$f":"P24*O29","v":10362.944020139998},null,{"$f":"'3.  LDC Assumptions and Data'!$H$20","v":8.0100000000000005E-2},{"$f":"S24*R29","v":10451.6355408},null,{"$f":"'3.  LDC Assumptions and Data'!$I$20","v":8.0100000000000005E-2},{"$f":"V24*U29","v":351.79920000000004}]
[null,"Return on Rate Base",null,{"$f":"SUM(D28:D29)","v":0},{"$f":"D30","v":0},null,{"$f":"SUM(G28:G29)","v":0},{"$f":"G30","v":0},null,{"$f":"SUM(J28:J29)","v":169.82428791960001},{"$f":"J30","v":169.82428791960001},null,{"$f":"SUM(M28:M29)","v":5603.3283546931507},{"$f":"M30","v":5603.3283546931507},null,{"$f":"SUM(P28:P29)","v":10362.944020139998},{"$f":"P30","v":10362.944020139998},null,{"$f":"SUM(S28:S29)","v":10451.6355408},{"$f":"S30","v":10451.6355408},null,{"$f":"SUM(V28:V29)","v":351.79920000000004},{"$f":"V30","v":351.79920000000004}]
[]
[null,"Operating Expenses"]
[null,"Incremental Operating Expenses (3.  LDC Assumptions and Data)",null,null,{"$f":"'3.  LDC Assumptions and Data'!C46","v":0},null,null,{"$f":"'3.  LDC Assumptions and Data'!D46","v":0},null,null,{"$f":"'3.  LDC Assumptions and Data'!E46","v":0},null,null,{"$f":"'3.  LDC Assumptions and Data'!F46","v":18310.96},null,null,{"$f":"'3.  LDC Assumptions and Data'!G46","v":30485},null,null,{"$f":"'3.  LDC Assumptions and Data'!H46","v":30500},null,null,{"$f":"'3.  LDC Assumptions and Data'!I46","v":30500}]
[]
[null,"Amortization Expenses"]
[null,"Amortization Expenses - Smart Meters",null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!C13:C13)","v":0},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!D13:D13)","v":0},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!E13:E13)","v":0},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!F13:F13)","v":9544.9409999999989},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!G13:G13)","v":19461.111999999997},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!H13:H13)","v":20145.675333333333},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!I13:I13)","v":0}]
[null,"Amortization Expenses - Computer Hardware",null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!C28:C28)","v":0},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!D28:D28)","v":0},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!E28:E28)","v":0},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!F28:F28)","v":214.93099999999998},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!G28:G28)","v":429.86199999999997},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!H28:H28)","v":429.86199999999997},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!I28:I28)","v":0}]
[null,"Amortization Expenses - Computer Software",null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!C43:C43)","v":0},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!D43:D43)","v":0},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!E43:E43)","v":942.952},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!F43:F43)","v":4291.0609999999997},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!G43:G43)","v":10575.339},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!H43:H43)","v":15754.460000000001},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!I43:I43)","v":0}]
[null,"Amortization Expenses -  Tools & Equipment",null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!C58:C58)","v":0},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!D58:D58)","v":0},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!E58:E58)","v":0},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!F58:F58)","v":0},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!G58:G58)","v":0},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!H58:H58)","v":0},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!I58:I58)","v":0}]
[null,"Amortization Expenses - Other Equipment",null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!C73:C73)","v":0},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!D73:D73)","v":0},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!E73:E73)","v":0},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!F73:F73)","v":0},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!G73:G73)","v":0},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!H73:H73)","v":0},null,null,{"$f":"SUM('6. Avg Nt Fix Ass &UCC'!I73:I73)","v":0}]
[null,"Total Amortization Expenses",null,null,{"$f":"SUM(D36:D40)","v":0},null,null,{"$f":"SUM(G36:G40)","v":0},null,null,{"$f":"SUM(J36:J40)","v":942.952},null,null,{"$f":"SUM(M36:M40)","v":14050.932999999999},null,null,{"$f":"SUM(P36:P40)","v":30466.312999999998},null,null,{"$f":"SUM(S36:S40)","v":36329.997333333333},null,null,{"$f":"SUM(V36:V40)","v":0}]
[]
[null,"Revenue Requirement Before PILs",null,null,{"$f":"SUM(E30,E41,E33)","v":0},null,null,{"$f":"SUM(H30,H41,H33)","v":0},null,null,{"$f":"SUM(K30,K41,K33)","v":1112.7762879196},null,null,{"$f":"SUM(N30,N41,N33)","v":37965.221354693145},null,null,{"$f":"SUM(Q30,Q41,Q33)","v":71314.257020139994},null,null,{"$f":"SUM(T30,T41,T33)","v":77281.632874133327},null,null,{"$f":"SUM(W30,W41,W33)","v":30851.799200000001}]
[]
[null,"Calculation of Taxable Income"]
[null,"Incremental Operating Expenses",null,null,{"$f":"-E33","v":0},null,null,{"$f":"-H33","v":0},null,null,{"$f":"-K33","v":0},null,null,{"$f":"-N33","v":-18310.96},null,null,{"$f":"-Q33","v":-30485},null,null,{"$f":"-T33","v":-30500},null,null,{"$f":"-W33","v":-30500}]
[null,"Depreciation Expenses",null,null,{"$f":"-E41","v":0},null,null,{"$f":"-H41","v":0},null,null,{"$f":"-K41","v":-942.952},null,null,{"$f":"-N41","v":-14050.932999999999},null,null,{"$f":"-Q41","v":-30466.312999999998},null,null,{"$f":"-T41","v":-36329.997333333333},null,null,{"$f":"-W41","v":0}]
[null,"Interest Expense",null,null,{"$f":"-D28","v":0},null,null,{"$f":"-G28","v":0},null,null,{"$f":"-J28","v":0},null,null,{"$f":"-M28","v":0},null,null,{"$f":"-P28","v":0},null,null,{"$f":"-S28","v":0},null,null,{"$f":"-V28","v":0}]
[null,"Taxable Income For PILs",null,null,{"$f":"SUM(E43:E48)","v":0},null,null,{"$f":"SUM(H43:H48)","v":0},null,null,{"$f":"SUM(K43:K48)","v":169.82428791960001},null,null,{"$f":"SUM(N43:N48)","v":5603.328354693147},null,null,{"$f":"SUM(Q43:Q48)","v":10362.944020139996},null,null,{"$f":"SUM(T43:T48)","v":10451.635540799994},null,null,{"$f":"SUM(W43:W48)","v":351.79920000000129}]
[]
[null,"Grossed up PILs (5. PILs)",null,null,{"$f":"'5. PILs'!C42","v":0},null,null,{"$f":"'5. PILs'!D42","v":0},null,null,{"$f":"'5. PILs'!E42","v":-726.64127244651752},null,null,{"$f":"'5. PILs'!F42","v":-957.39926349068912},null,null,{"$f":"'5. PILs'!G42","v":-2122.1299239298619},null,null,{"$f":"'5. PILs'!H42","v":167.96915981620486},null,null,{"$f":"'5. PILs'!I42","v":0}]
[]
[null,{"$f":"B43","v":"Revenue Requirement Before PILs"},null,null,{"$f":"E43","v":0},null,null,{"$f":"H43","v":0},null,null,{"$f":"K43","v":1112.7762879196},null,null,{"$f":"N43","v":37965.221354693145},null,null,{"$f":"Q43","v":71314.257020139994},null,null,{"$f":"T43","v":77281.632874133327},null,null,{"$f":"W43","v":30851.799200000001}]
[null,"Grossed up PILs (5. PILs)",null,null,{"$f":"E51","v":0},null,null,{"$f":"H51","v":0},null,null,{"$f":"K51","v":-726.64127244651752},null,null,{"$f":"N51","v":-957.39926349068912},null,null,{"$f":"Q51","v":-2122.1299239298619},null,null,{"$f":"T51","v":167.96915981620486},null,null,{"$f":"W51","v":0}]
[null,"Revenue Requirement for Smart Meters",null,null,{"$f":"SUM(E53:E54)","v":0},null,null,{"$f":"SUM(H53:H54)","v":0},null,null,{"$f":"SUM(K53:K54)","v":386.13501547308249},null,null,{"$f":"SUM(N53:N54)","v":37007.822091202455},null,null,{"$f":"SUM(Q53:Q54)","v":69192.127096210126},null,null,{"$f":"SUM(T53:T54)","v":77449.60203394953},null,null,{"$f":"SUM(W53:W54)","v":30851.799200000001}]

{"sheet":"5. PILs","index":4,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Sheet 5. PILs"]
[]
[]
[null,"PILs Calculation"]
[]
[null,null,{"$f":"'2. Smart Meter Data'!D4","v":2006},{"$f":"'2. Smart Meter Data'!E4","v":2007},{"$f":"'2. Smart Meter Data'!F4","v":2008},{"$f":"'2. Smart Meter Data'!G4","v":2009},{"$f":"'2. Smart Meter Data'!H4","v":2010},{"$f":"'2. Smart Meter Data'!I4","v":2011},{"$f":"'2. Smart Meter Data'!J4","v":"Later"}]
[null,"INCOME TAX",{"$f":"'2. Smart Meter Data'!D5","v":"Audited Actual"},{"$f":"'2. Smart Meter Data'!E5","v":"Audited Actual"},{"$f":"'2. Smart Meter Data'!F5","v":"Audited Actual"},{"$f":"'2. Smart Meter Data'!G5","v":"Audited Actual"},{"$f":"'2. Smart Meter Data'!H5","v":"Actual"},{"$f":"'2. Smart Meter Data'!I5","v":"Forecasted"},{"$f":"'2. Smart Meter Data'!J5","v":"Forecasted"}]
[null,"Net Income",{"$f":"'4. Smart Meter Rev Req'!E49","v":0},{"$f":"'4. Smart Meter Rev Req'!H49","v":0},{"$f":"'4. Smart Meter Rev Req'!K49","v":169.82428791960001},{"$f":"'4. Smart Meter Rev Req'!N49","v":5603.328354693147},{"$f":"'4. Smart Meter Rev Req'!Q49","v":10362.944020139996},{"$f":"'4. Smart Meter Rev Req'!T49","v":10451.635540799994},{"$f":"'4. Smart Meter Rev Req'!S49","v":0}]
[null,"Amortization ",{"$f":"-'4. Smart Meter Rev Req'!E47","v":0},{"$f":"-'4. Smart Meter Rev Req'!H47","v":0},{"$f":"-'4. Smart Meter Rev Req'!K47","v":942.952},{"$f":"-'4. Smart Meter Rev Req'!N47","v":14050.932999999999},{"$f":"-'4. Smart Meter Rev Req'!Q47","v":30466.312999999998},{"$f":"-'4. Smart Meter Rev Req'!T47","v":36329.997333333333},{"$f":"-'4. Smart Meter Rev Req'!S47","v":0}]
[null,"CCA - Smart Meters",{"$f":"-'6. Avg Nt Fix Ass &UCC'!C93","v":0},{"$f":"-'6. Avg Nt Fix Ass &UCC'!D93","v":0},{"$f":"-'6. Avg Nt Fix Ass &UCC'!E93","v":0},{"$f":"-'6. Avg Nt Fix Ass &UCC'!F93","v":-11453.929199999999},{"$f":"-'6. Avg Nt Fix Ass &UCC'!G93","v":-22437.020064},{"$f":"-'6. Avg Nt Fix Ass &UCC'!H93","v":-21463.53445888},{"$f":"-'6. Avg Nt Fix Ass &UCC'!I93","v":0}]
[null,"CCA -  Computers",{"$f":"-'6. Avg Nt Fix Ass &UCC'!C107","v":0},{"$f":"-'6. Avg Nt Fix Ass &UCC'!D107","v":0},{"$f":"-'6. Avg Nt Fix Ass &UCC'!E107","v":-2593.1180000000004},{"$f":"-'6. Avg Nt Fix Ass &UCC'!F107","v":-11556.323350000001},{"$f":"-'6. Avg Nt Fix Ass &UCC'!G107","v":-23664.230507500008},{"$f":"-'6. Avg Nt Fix Ass &UCC'!H107","v":-24891.486478375002},{"$f":"-'6. Avg Nt Fix Ass &UCC'!I107","v":0}]
[null,"CCA -  Other Equipment",{"$f":"-'6. Avg Nt Fix Ass &UCC'!C121","v":0},{"$f":"-'6. Avg Nt Fix Ass &UCC'!D121","v":0},{"$f":"-'6. Avg Nt Fix Ass &UCC'!E121","v":0},{"$f":"-'6. Avg Nt Fix Ass &UCC'!F121","v":0},{"$f":"-'6. Avg Nt Fix Ass &UCC'!G121","v":0},{"$f":"-'6. Avg Nt Fix Ass &UCC'!H121","v":0},{"$f":"-'6. Avg Nt Fix Ass &UCC'!I121","v":0}]
[null,"Change in taxable income",{"$f":"SUM(C8:C12)","v":0},0,-1480.3417120804004,-3355.9911953068531,-5271.993551360014,426.61193687832565,0]
[null,"Tax Rate (3.  LDC Assumptions and Data)",{"$f":"'3.  LDC Assumptions and Data'!C26","v":0.36120000000000002},{"$f":"'3.  LDC Assumptions and Data'!D26","v":0.36120000000000002},{"$f":"'3.  LDC Assumptions and Data'!E26","v":0.33500000000000002},{"$f":"'3.  LDC Assumptions and Data'!F26","v":0.33},{"$f":"'3.  LDC Assumptions and Data'!G26","v":0.31},{"$f":"'3.  LDC Assumptions and Data'!H26","v":0.28249999999999997},{"$f":"'3.  LDC Assumptions and Data'!I26","v":0.26250000000000001}]
[null,"Income Taxes Payable",{"$f":"C13*C14","v":0},0,-495.91447354693418,-1107.4770944512616,-1634.3180009216044,120.51787216812698,0]
[]
[null,"ONTARIO CAPITAL TAX"]
[null,"Smart Meters",{"$f":"'6. Avg Nt Fix Ass &UCC'!C17","v":0},{"$f":"'6. Avg Nt Fix Ass &UCC'!D17","v":0},{"$f":"'6. Avg Nt Fix Ass &UCC'!E17","v":0},{"$f":"'6. Avg Nt Fix Ass &UCC'!F17","v":276803.28899999999},{"$f":"'6. Avg Nt Fix Ass &UCC'!G17","v":268479.07699999999},{"$f":"'6. Avg Nt Fix Ass &UCC'!H17","v":257733.40166666667},{"$f":"'6. Avg Nt Fix Ass &UCC'!I17","v":0}]
[null,"Computer Hardware",{"$f":"'6. Avg Nt Fix Ass &UCC'!C32","v":0},{"$f":"'6. Avg Nt Fix Ass &UCC'!D32","v":0},{"$f":"'6. Avg Nt Fix Ass &UCC'!E32","v":0},{"$f":"'6. Avg Nt Fix Ass &UCC'!F32","v":4083.6889999999999},{"$f":"'6. Avg Nt Fix Ass &UCC'!G32","v":3653.8270000000002},{"$f":"'6. Avg Nt Fix Ass &UCC'!H32","v":3223.9650000000001},{"$f":"'6. Avg Nt Fix Ass &UCC'!I32","v":0}]
[null,"Computer Software",{"$f":"'6. Avg Nt Fix Ass &UCC'!C47","v":0},{"$f":"'6. Avg Nt Fix Ass &UCC'!D47","v":0},{"$f":"'6. Avg Nt Fix Ass &UCC'!E47","v":8486.5680000000011},{"$f":"'6. Avg Nt Fix Ass &UCC'!F47","v":28247.076999999997},{"$f":"'6. Avg Nt Fix Ass &UCC'!G47","v":56462.948000000004},{"$f":"'6. Avg Nt Fix Ass &UCC'!H47","v":53708.488000000005},{"$f":"'6. Avg Nt Fix Ass &UCC'!I47","v":0}]
[null,"Tools & Equipment",{"$f":"'6. Avg Nt Fix Ass &UCC'!C62","v":0},{"$f":"'6. Avg Nt Fix Ass &UCC'!D62","v":0},{"$f":"'6. Avg Nt Fix Ass &UCC'!E62","v":0},{"$f":"'6. Avg Nt Fix Ass &UCC'!F62","v":0},{"$f":"'6. Avg Nt Fix Ass &UCC'!G62","v":0},{"$f":"'6. Avg Nt Fix Ass &UCC'!H62","v":0},{"$f":"'6. Avg Nt Fix Ass &UCC'!I62","v":0}]
[null,"Other Equipment",{"$f":"'6. Avg Nt Fix Ass &UCC'!C77","v":0},{"$f":"'6. Avg Nt Fix Ass &UCC'!D77","v":0},{"$f":"'6. Avg Nt Fix Ass &UCC'!E77","v":0},{"$f":"'6. Avg Nt Fix Ass &UCC'!F77","v":0},{"$f":"'6. Avg Nt Fix Ass &UCC'!G77","v":0},{"$f":"'6. Avg Nt Fix Ass &UCC'!H77","v":0},{"$f":"'6. Avg Nt Fix Ass &UCC'!I77","v":0}]
[null,"Rate Base",{"$f":"SUM(C18:C20)","v":0},0,8486.5680000000011,309134.05499999999,328595.85199999996,314665.85466666665,0]
[null,"Less: Exemption",0,0,0,0,0,0,0]
[null,"Deemed Taxable Capital",{"$f":"C23-C24","v":0},0,8486.5680000000011,309134.05499999999,328595.85199999996,314665.85466666665,0]
[null,"Ontario Capital Tax Rate",3.0000000000000001E-3,2.2499999999999998E-3,2.2499999999999998E-3,2.2499999999999998E-3,{"$f":"0.15%/2","v":7.5000000000000002E-4},0,0]
[null,"Net Amount (Taxable Capital x Rate)",{"$f":"C25*C26","v":0},0,19.094778000000002,695.55162374999998,246.44688899999997,0,0]
[]
[]
[null,"Gross Up"]
[null,null,"PILs Payable","PILs Payable","PILs Payable","PILs Payable","PILs Payable","PILs Payable","PILs Payable"]
[null,"Change in Income Taxes Payable",{"$f":"C15","v":0},0,-495.91447354693418,-1107.4770944512616,-1634.3180009216044,120.51787216812698,0]
[null,"Change in OCT",{"$f":"C27","v":0},0,19.094778000000002,695.55162374999998,246.44688899999997,0,0]
[null,"PIL's",{"$f":"SUM(C32:C33)","v":0},0,-476.81969554693416,-411.92547070126159,-1387.8711119216043,120.51787216812698,0]
[]
[null,null,"Gross Up","Gross Up","Gross Up","Gross Up","Gross Up","Gross Up","Gross Up"]
[null,null,{"$f":"C14","v":0.36120000000000002},{"$f":"D14","v":0.36120000000000002},0.33500000000000002,0.33,0.31,0.28249999999999997,0.26250000000000001]
[]
[null,null,"Grossed Up PILs","Grossed Up PILs","Grossed Up PILs","Grossed Up PILs","Grossed Up PILs","Grossed Up PILs","Grossed Up PILs"]
[null,"Change in Income Taxes Payable",{"$f":"C32/(1-C37)","v":0},0,-745.73605044651754,-1652.9508872406891,-2368.5768129298617,167.96915981620486,0]
[null,"Change in OCT",{"$f":"C33","v":0},0,19.094778000000002,695.55162374999998,246.44688899999997,0,0]
[null,"PIL's",{"$f":"SUM(C40:C41)","v":0},0,-726.64127244651752,-957.39926349068912,-2122.1299239298619,167.96915981620486,0]

{"sheet":"6. Avg Nt Fix Ass &UCC","index":5,"n_rows":122,"n_cols":8,"rows_kept":122,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Sheet 6. Avg Net Fixed Assets &UCC"]
[]
[]
[null,"Smart Meter Average Net Fixed Assets"]
[null,null,{"$f":"'2. Smart Meter Data'!D4","v":2006},{"$f":"'2. Smart Meter Data'!E4","v":2007},{"$f":"'2. Smart Meter Data'!F4","v":2008},{"$f":"'2. Smart Meter Data'!G4","v":2009},{"$f":"'2. Smart Meter Data'!H4","v":2010},{"$f":"'2. Smart Meter Data'!I4","v":2011}]
[null,"Net Fixed Assets - Smart Meters",{"$f":"'2. Smart Meter Data'!D5","v":"Audited Actual"},{"$f":"'2. Smart Meter Data'!E5","v":"Audited Actual"},{"$f":"'2. Smart Meter Data'!F5","v":"Audited Actual"},{"$f":"'2. Smart Meter Data'!G5","v":"Audited Actual"},{"$f":"'2. Smart Meter Data'!H5","v":"Actual"},{"$f":"'2. Smart Meter Data'!I5","v":"Forecasted"}]
[]
[null,"Opening Capital Investment",0,{"$f":"C10","v":0},{"$f":"D10","v":0},{"$f":"E10","v":0},{"$f":"F10","v":286348.23},{"$f":"G10","v":297485.13}]
[null,"Capital Investment (3.  LDC Assumptions and Data)",{"$f":"'3.  LDC Assumptions and Data'!C31","v":0},{"$f":"'3.  LDC Assumptions and Data'!D31","v":0},{"$f":"'3.  LDC Assumptions and Data'!E31","v":0},{"$f":"'3.  LDC Assumptions and Data'!F31","v":286348.23},{"$f":"'3.  LDC Assumptions and Data'!G31","v":11136.9},{"$f":"'3.  LDC Assumptions and Data'!H31","v":9400}]
[null,"Closing Capital Investment",{"$f":"SUM(C8:C9)","v":0},0,0,286348.23,297485.13,306885.13]
[]
[null,"Opening Accumulated Amortization",0,{"$f":"C14","v":0},{"$f":"D14","v":0},{"$f":"E14","v":0},{"$f":"F14","v":9544.9409999999989},{"$f":"G14","v":29006.052999999996}]
[null,{"$f":"\"Amortization (\"&'3.  LDC Assumptions and Data'!C60&\" Years  Straight Line)\"","v":"Amortization (15 Years  Straight Line)"},{"$f":"IF(C12+(C8/'3.  LDC Assumptions and Data'!C60)+(C9/'3.  LDC Assumptions and Data'!C60/2)<C10,(C8/'3.  LDC Assumptions and Data'!C60)+(C9/'3.  LDC Assumptions and Data'!C60/2),C10-C12)","v":0},{"$f":"IF(D12+(D8/'3.  LDC Assumptions and Data'!D60)+(D9/'3.  LDC Assumptions and Data'!D60/2)<D10,(D8/'3.  LDC Assumptions and Data'!D60)+(D9/'3.  LDC Assumptions and Data'!D60/2),D10-D12)","v":0},{"$f":"IF(E12+(E8/'3.  LDC Assumptions and Data'!E60)+(E9/'3.  LDC Assumptions and Data'!E60/2)<E10,(E8/'3.  LDC Assumptions and Data'!E60)+(E9/'3.  LDC Assumptions and Data'!E60/2),E10-E12)","v":0},{"$f":"IF(F12+(F8/'3.  LDC Assumptions and Data'!F60)+(F9/'3.  LDC Assumptions and Data'!F60/2)<F10,(F8/'3.  LDC Assumptions and Data'!F60)+(F9/'3.  LDC Assumptions and Data'!F60/2),F10-F12)","v":9544.9409999999989},{"$f":"IF(G12+(G8/'3.  LDC Assumptions and Data'!G60)+(G9/'3.  LDC Assumptions and Data'!G60/2)<G10,(G8/'3.  LDC Assumptions and Data'!G60)+(G9/'3.  LDC Assumptions and Data'!G60/2),G10-G12)","v":19461.111999999997},{"$f":"IF(H12+(H8/'3.  LDC Assumptions and Data'!H60)+(H9/'3.  LDC Assumptions and Data'!H60/2)<H10,(H8/'3.  LDC Assumptions and Data'!H60)+(H9/'3.  LDC Assumptions and Data'!H60/2),H10-H12)","v":20145.675333333333}]
[null,"Closing Accumulated Amortization",{"$f":"SUM(C12:C13)","v":0},0,0,9544.9409999999989,29006.052999999996,49151.728333333333]
[]
[null,"Opening Net Fixed Assets",{"$f":"0","v":0},{"$f":"C17","v":0},{"$f":"D17","v":0},{"$f":"E17","v":0},{"$f":"F17","v":276803.28899999999},{"$f":"G17","v":268479.07699999999}]
[null,"Closing Net Fixed Assets",{"$f":"C10-C14","v":0},0,0,276803.28899999999,268479.07699999999,257733.40166666667]
[null,"Average Net Fixed Assets",{"$f":"(C17+C16)/2","v":0},0,0,138401.64449999999,272641.18299999996,263106.23933333333]
[]
[null,null,{"$f":"C5","v":2006},2007,2008,2009,2010,2011]
[null,"Net Fixed Assets - Computer Hardware","Audited Actual","Audited Actual","Audited Actual","Audited Actual","Actual","Forecasted"]
[]
[null,"Opening Capital Investment",0,{"$f":"C25","v":0},{"$f":"D25","v":0},{"$f":"E25","v":0},{"$f":"F25","v":4298.62},{"$f":"G25","v":4298.62}]
[null,"Capital Investment (3.  LDC Assumptions and Data)",{"$f":"'3.  LDC Assumptions and Data'!C32","v":0},{"$f":"'3.  LDC Assumptions and Data'!D32","v":0},{"$f":"'3.  LDC Assumptions and Data'!E32","v":0},{"$f":"'3.  LDC Assumptions and Data'!F32","v":4298.62},{"$f":"'3.  LDC Assumptions and Data'!G32","v":0},{"$f":"'3.  LDC Assumptions and Data'!H32","v":0}]
[null,"Closing Capital Investment",{"$f":"SUM(C23:C24)","v":0},0,0,4298.62,4298.62,4298.62]
[]
[null,"Opening Accumulated Amortization",0,{"$f":"C29","v":0},{"$f":"D29","v":0},{"$f":"E29","v":0},{"$f":"F29","v":214.93099999999998},{"$f":"G29","v":644.79299999999989}]
[null,{"$f":"\"Amortization (\" & '3.  LDC Assumptions and Data'!C61 &\" Years  Straight Line)\"","v":"Amortization (10 Years  Straight Line)"},{"$f":"IF(C27+(C23/'3.  LDC Assumptions and Data'!C61)+(C24/'3.  LDC Assumptions and Data'!C61/2)<C25,(C23/'3.  LDC Assumptions and Data'!C61)+(C24/'3.  LDC Assumptions and Data'!C61/2),C25-C27)","v":0},{"$f":"IF(D27+(D23/'3.  LDC Assumptions and Data'!C61)+(D24/'3.  LDC Assumptions and Data'!C61/2)<D25,(D23/'3.  LDC Assumptions and Data'!C61)+(D24/'3.  LDC Assumptions and Data'!C61/2),D25-D27)","v":0},{"$f":"IF(E27+(E23/'3.  LDC Assumptions and Data'!C61)+(E24/'3.  LDC Assumptions and Data'!C61/2)<E25,(E23/'3.  LDC Assumptions and Data'!C61)+(E24/'3.  LDC Assumptions and Data'!C61/2),E25-E27)","v":0},{"$f":"IF(F27+(F23/'3.  LDC Assumptions and Data'!C61)+(F24/'3.  LDC Assumptions and Data'!C61/2)<F25,(F23/'3.  LDC Assumptions and Data'!C61)+(F24/'3.  LDC Assumptions and Data'!C61/2),F25-F27)","v":214.93099999999998},{"$f":"IF(G27+(G23/'3.  LDC Assumptions and Data'!C61)+(G24/'3.  LDC Assumptions and Data'!C61/2)<G25,(G23/'3.  LDC Assumptions and Data'!C61)+(G24/'3.  LDC Assumptions and Data'!C61/2),G25-G27)","v":429.86199999999997},{"$f":"IF(H27+(H23/'3.  LDC Assumptions and Data'!D61)+(H24/'3.  LDC Assumptions and Data'!D61/2)<H25,(H23/'3.  LDC Assumptions and Data'!D61)+(H24/'3.  LDC Assumptions and Data'!D61/2),H25-H27)","v":429.86199999999997}]
[null,"Closing Accumulated Amortization",{"$f":"SUM(C27:C28)","v":0},0,0,214.93099999999998,644.79299999999989,1074.6549999999997]
[]
[null,"Opening Net Fixed Assets",{"$f":"0","v":0},{"$f":"C32","v":0},{"$f":"D32","v":0},{"$f":"E32","v":0},{"$f":"F32","v":4083.6889999999999},{"$f":"G32","v":3653.8270000000002}]
[null,"Closing Net Fixed Assets",{"$f":"C25-C29","v":0},0,0,4083.6889999999999,3653.8270000000002,3223.9650000000001]
[null,"Average Net Fixed Assets",{"$f":"(C32+C31)/2","v":0},0,0,2041.8444999999999,3868.7579999999998,3438.8960000000002]
[]
[null,null,{"$f":"C20","v":2006},2007,2008,2009,2010,2011]
[null,"Net Fixed Assets - Computer Software","Audited Actual","Audited Actual","Audited Actual","Audited Actual","Actual","Forecasted"]
[]
[null,"Opening Capital Investment",0,{"$f":"C40","v":0},{"$f":"D40","v":0},{"$f":"E40","v":9429.52},{"$f":"F40","v":33481.089999999997},{"$f":"G40","v":72272.3}]
[null,"Capital Investment (3.  LDC Assumptions and Data)",{"$f":"'3.  LDC Assumptions and Data'!C33","v":0},{"$f":"'3.  LDC Assumptions and Data'!D33","v":0},{"$f":"'3.  LDC Assumptions and Data'!E33","v":9429.52},{"$f":"'3.  LDC Assumptions and Data'!F33","v":24051.57},{"$f":"'3.  LDC Assumptions and Data'!G33","v":38791.210000000006},{"$f":"'3.  LDC Assumptions and Data'!H33","v":13000}]
[null,"Closing Capital Investment",{"$f":"SUM(C38:C39)","v":0},0,9429.52,33481.089999999997,72272.3,85272.3]
[]
[null,"Opening Accumulated Amortization",0,{"$f":"C44","v":0},{"$f":"D44","v":0},{"$f":"E44","v":942.952},{"$f":"F44","v":5234.0129999999999},{"$f":"G44","v":15809.351999999999}]
[null,{"$f":"\"Amortization Year 1 (\" & '3.  LDC Assumptions and Data'!C62 &\" Years Straight Line)\"","v":"Amortization Year 1 (5 Years Straight Line)"},{"$f":"IF(C42+(C38/'3.  LDC Assumptions and Data'!C62)+(C39/'3.  LDC Assumptions and Data'!C62/2)<C40,(C38/'3.  LDC Assumptions and Data'!C62)+(C39/'3.  LDC Assumptions and Data'!C62/2),C40-C42)","v":0},{"$f":"IF(D42+(D38/'3.  LDC Assumptions and Data'!C62)+(D39/'3.  LDC Assumptions and Data'!C62/2)<D40,(D38/'3.  LDC Assumptions and Data'!C62)+(D39/'3.  LDC Assumptions and Data'!C62/2),D40-D42)","v":0},{"$f":"IF(E42+(E38/'3.  LDC Assumptions and Data'!C62)+(E39/'3.  LDC Assumptions and Data'!C62/2)<E40,(E38/'3.  LDC Assumptions and Data'!C62)+(E39/'3.  LDC Assumptions and Data'!C62/2),E40-E42)","v":942.952},{"$f":"IF(F42+(F38/'3.  LDC Assumptions and Data'!C62)+(F39/'3.  LDC Assumptions and Data'!C62/2)<F40,(F38/'3.  LDC Assumptions and Data'!C62)+(F39/'3.  LDC Assumptions and Data'!C62/2),F40-F42)","v":4291.0609999999997},{"$f":"IF(G42+(G38/'3.  LDC Assumptions and Data'!C62)+(G39/'3.  LDC Assumptions and Data'!C62/2)<G40,(G38/'3.  LDC Assumptions and Data'!C62)+(G39/'3.  LDC Assumptions and Data'!C62/2),G40-G42)","v":10575.339},{"$f":"IF(H42+(H38/'3.  LDC Assumptions and Data'!D62)+(H39/'3.  LDC Assumptions and Data'!D62/2)<H40,(H38/'3.  LDC Assumptions and Data'!D62)+(H39/'3.  LDC Assumptions and Data'!D62/2),H40-H42)","v":15754.460000000001}]
[null,"Closing Accumulated Amortization",{"$f":"SUM(C42:C43)","v":0},0,942.952,5234.0129999999999,15809.351999999999,31563.811999999998]
[]
[null,"Opening Net Fixed Assets",{"$f":"0","v":0},{"$f":"C47","v":0},{"$f":"D47","v":0},{"$f":"E47","v":8486.5680000000011},{"$f":"F47","v":28247.076999999997},{"$f":"G47","v":56462.948000000004}]
[null,"Closing Net Fixed Assets",{"$f":"C40-C44","v":0},0,8486.5680000000011,28247.076999999997,56462.948000000004,53708.488000000005]
[null,"Average Net Fixed Assets",{"$f":"(C47+C46)/2","v":0},0,4243.2840000000006,18366.822499999998,42355.012499999997,55085.718000000008]
[]
[null,null,{"$f":"C35","v":2006},2007,2008,2009,2010,2011]
[null,"Net Fixed Assets - Tools & Equipment","Audited Actual","Audited Actual","Audited Actual","Audited Actual","Actual","Forecasted"]
[]
[null,"Opening Capital Investment",0,{"$f":"C55","v":0},{"$f":"D55","v":0},{"$f":"E55","v":0},{"$f":"F55","v":0},{"$f":"G55","v":0}]
[null,"Capital Investment (3.  LDC Assumptions and Data)",{"$f":"'3.  LDC Assumptions and Data'!C34","v":0},{"$f":"'3.  LDC Assumptions and Data'!D34","v":0},{"$f":"'3.  LDC Assumptions and Data'!E34","v":0},{"$f":"'3.  LDC Assumptions and Data'!F34","v":0},{"$f":"'3.  LDC Assumptions and Data'!G34","v":0},{"$f":"'3.  LDC Assumptions and Data'!H34","v":0}]
[null,"Closing Capital Investment",{"$f":"SUM(C53:C54)","v":0},0,0,0,0,0]
[]
[null,"Opening Accumulated Amortization",0,{"$f":"C59","v":0},{"$f":"D59","v":0},{"$f":"E59","v":0},{"$f":"F59","v":0},{"$f":"G59","v":0}]
[null,{"$f":"\"Amortization Year 1 (\" & '3.  LDC Assumptions and Data'!C63 &\" Years Straight Line)\"","v":"Amortization Year 1 (10 Years Straight Line)"},{"$f":"IF(C57+(C53/'3.  LDC Assumptions and Data'!C63)+(C54/'3.  LDC Assumptions and Data'!C63/2)<C55,(C53/'3.  LDC Assumptions and Data'!C63)+(C54/'3.  LDC Assumptions and Data'!C63/2),C55-C57)","v":0},{"$f":"IF(D57+(D53/'3.  LDC Assumptions and Data'!C63)+(D54/'3.  LDC Assumptions and Data'!C63/2)<D55,(D53/'3.  LDC Assumptions and Data'!C63)+(D54/'3.  LDC Assumptions and Data'!C63/2),D55-D57)","v":0},{"$f":"IF(E57+(E53/'3.  LDC Assumptions and Data'!C63)+(E54/'3.  LDC Assumptions and Data'!C63/2)<E55,(E53/'3.  LDC Assumptions and Data'!C63)+(E54/'3.  LDC Assumptions and Data'!C63/2),E55-E57)","v":0},{"$f":"IF(F57+(F53/'3.  LDC Assumptions and Data'!C63)+(F54/'3.  LDC Assumptions and Data'!C63/2)<F55,(F53/'3.  LDC Assumptions and Data'!C63)+(F54/'3.  LDC Assumptions and Data'!C63/2),F55-F57)","v":0},{"$f":"IF(G57+(G53/'3.  LDC Assumptions and Data'!C63)+(G54/'3.  LDC Assumptions and Data'!C63/2)<G55,(G53/'3.  LDC Assumptions and Data'!C63)+(G54/'3.  LDC Assumptions and Data'!C63/2),G55-G57)","v":0},{"$f":"IF(H57+(H53/'3.  LDC Assumptions and Data'!D63)+(H54/'3.  LDC Assumptions and Data'!D63/2)<H55,(H53/'3.  LDC Assumptions and Data'!D63)+(H54/'3.  LDC Assumptions and Data'!D63/2),H55-H57)","v":0}]
[null,"Closing Accumulated Amortization",{"$f":"SUM(C57:C58)","v":0},0,0,0,0,0]
[]
[null,"Opening Net Fixed Assets",{"$f":"0","v":0},{"$f":"C62","v":0},{"$f":"D62","v":0},{"$f":"E62","v":0},{"$f":"F62","v":0},{"$f":"G62","v":0}]
[null,"Closing Net Fixed Assets",{"$f":"C55-C59","v":0},0,0,0,0,0]
[null,"Average Net Fixed Assets",{"$f":"(C62+C61)/2","v":0},0,0,0,0,0]
[]
[null,null,{"$f":"C50","v":2006},2007,2008,2009,2010,2011]
[null,"Net Fixed Assets - Other Equipment","Audited Actual","Audited Actual","Audited Actual","Audited Actual","Actual","Forecasted"]
[]
[null,"Opening Capital Investment",0,{"$f":"C70","v":0},{"$f":"D70","v":0},{"$f":"E70","v":0},{"$f":"F70","v":0},{"$f":"G70","v":0}]
[null,"Capital Investment (3.  LDC Assumptions and Data)",{"$f":"'3.  LDC Assumptions and Data'!C35","v":0},{"$f":"'3.  LDC Assumptions and Data'!D35","v":0},{"$f":"'3.  LDC Assumptions and Data'!E35","v":0},{"$f":"'3.  LDC Assumptions and Data'!F35","v":0},{"$f":"'3.  LDC Assumptions and Data'!G35","v":0},{"$f":"'3.  LDC Assumptions and Data'!H35","v":0}]
[null,"Closing Capital Investment",{"$f":"SUM(C68:C69)","v":0},0,0,0,0,0]
[]
[null,"Opening Accumulated Amortization",0,{"$f":"C74","v":0},{"$f":"D74","v":0},{"$f":"E74","v":0},{"$f":"F74","v":0},{"$f":"G74","v":0}]
[null,{"$f":"\"Amortization Year 1 (\" & '3.  LDC Assumptions and Data'!C64 &\" Years Straight Line)\"","v":"Amortization Year 1 (10 Years Straight Line)"},{"$f":"IF(C72+(C68/'3.  LDC Assumptions and Data'!C64)+(C69/'3.  LDC Assumptions and Data'!C64/2)<C70,(C68/'3.  LDC Assumptions and Data'!C64)+(C69/'3.  LDC Assumptions and Data'!C64/2),C70-C72)","v":0},{"$f":"IF(D72+(D68/'3.  LDC Assumptions and Data'!C64)+(D69/'3.  LDC Assumptions and Data'!C64/2)<D70,(D68/'3.  LDC Assumptions and Data'!C64)+(D69/'3.  LDC Assumptions and Data'!C64/2),D70-D72)","v":0},{"$f":"IF(E72+(E68/'3.  LDC Assumptions and Data'!C64)+(E69/'3.  LDC Assumptions and Data'!C64/2)<E70,(E68/'3.  LDC Assumptions and Data'!C64)+(E69/'3.  LDC Assumptions and Data'!C64/2),E70-E72)","v":0},{"$f":"IF(F72+(F68/'3.  LDC Assumptions and Data'!C64)+(F69/'3.  LDC Assumptions and Data'!C64/2)<F70,(F68/'3.  LDC Assumptions and Data'!C64)+(F69/'3.  LDC Assumptions and Data'!C64/2),F70-F72)","v":0},{"$f":"IF(G72+(G68/'3.  LDC Assumptions and Data'!C64)+(G69/'3.  LDC Assumptions and Data'!C64/2)<G70,(G68/'3.  LDC Assumptions and Data'!C64)+(G69/'3.  LDC Assumptions and Data'!C64/2),G70-G72)","v":0},{"$f":"IF(H72+(H68/'3.  LDC Assumptions and Data'!D64)+(H69/'3.  LDC Assumptions and Data'!D64/2)<H70,(H68/'3.  LDC Assumptions and Data'!D64)+(H69/'3.  LDC Assumptions and Data'!D64/2),H70-H72)","v":0}]
[null,"Closing Accumulated Amortization",{"$f":"SUM(C72:C73)","v":0},0,0,0,0,0]
[]
[null,"Opening Net Fixed Assets",{"$f":"0","v":0},{"$f":"C77","v":0},{"$f":"D77","v":0},{"$f":"E77","v":0},{"$f":"F77","v":0},{"$f":"G77","v":0}]
[null,"Closing Net Fixed Assets",{"$f":"C70-C74","v":0},0,0,0,0,0]
[null,"Average Net Fixed Assets",{"$f":"(C77+C76)/2","v":0},0,0,0,0,0]
[]
[]
[null,"For PILs Calculation"]
[]
[null,"UCC - Smart Meters",{"$f":"C65","v":2006},2007,2008,2009,2010,2011]
[null,null,"Audited Actual","Audited Actual","Audited Actual","Audited Actual","Actual","Forecasted"]
[]
[null,"Opening UCC",0,{"$f":"C88-C93","v":0},{"$f":"D88-D93","v":0},{"$f":"E88-E93","v":0},{"$f":"F88-F93","v":274894.30079999997},{"$f":"G88-G93","v":263594.18073600001}]
[null,"Capital Additions",{"$f":"C9","v":0},0,0,286348.23,11136.9,9400]
[null,"UCC Before Half Year Rule",{"$f":"SUM(C86:C87)","v":0},0,0,286348.23,286031.20079999999,272994.18073600001]
[null,"Half Year Rule (1/2 Additions - Disposals)",{"$f":"SUM(C87:C87)/2","v":0},0,0,143174.11499999999,5568.45,4700]
[null,"Reduced UCC",{"$f":"C86+C89","v":0},0,0,143174.11499999999,280462.75079999998,268294.18073600001]
[null,"CCA Rate Class",{"$f":"'3.  LDC Assumptions and Data'!C68","v":47},{"$f":"'3.  LDC Assumptions and Data'!D68","v":47},{"$f":"'3.  LDC Assumptions and Data'!E68","v":47},{"$f":"'3.  LDC Assumptions and Data'!F68","v":47},{"$f":"'3.  LDC Assumptions and Data'!G68","v":47},{"$f":"'3.  LDC Assumptions and Data'!H68","v":47}]
[null,"CCA Rate ",{"$f":"'3.  LDC Assumptions and Data'!C69","v":0.08},{"$f":"'3.  LDC Assumptions and Data'!D69","v":0.08},{"$f":"'3.  LDC Assumptions and Data'!E69","v":0.08},{"$f":"'3.  LDC Assumptions and Data'!F69","v":0.08},{"$f":"'3.  LDC Assumptions and Data'!G69","v":0.08},{"$f":"'3.  LDC Assumptions and Data'!H69","v":0.08}]
[null,"CCA",{"$f":"IF((C90*C92)<C90,(C90*C92),C90)","v":0},0,0,11453.929199999999,22437.020064,21463.53445888]
[null,"Closing UCC",{"$f":"IF((C88-C93)<0,0,(C88-C93))","v":0},0,0,274894.30079999997,263594.18073600001,251530.64627712002]
[]
[null,"UCC - Computer Equipment",{"$f":"C83","v":2006},2007,2008,2009,2010,2011]
[null,null,"Audited Actual","Audited Actual","Audited Actual","Audited Actual","Actual","Forecasted"]
[]
[null,"Opening UCC",0,{"$f":"C108","v":0},{"$f":"D108","v":0},{"$f":"E108","v":6836.402},{"$f":"F108","v":23630.268650000005},{"$f":"G108","v":38757.248142500001}]
[null,"Capital Additions Computer Hardware",{"$f":"C24","v":0},0,0,4298.62,0,0]
[null,"Capital Additions Computer Software",{"$f":"C39","v":0},0,9429.52,24051.57,38791.210000000006,13000]
[null,"UCC Before Half Year Rule",{"$f":"SUM(C99:C101)","v":0},0,9429.52,35186.592000000004,62421.478650000012,51757.248142500001]
[null,"Half Year Rule (1/2 Additions - Disposals)",{"$f":"SUM(C100:C101)/2","v":0},0,4714.76,14175.094999999999,19395.605000000003,6500]
[null,"Reduced UCC",{"$f":"C99+C103","v":0},0,4714.76,21011.496999999999,43025.873650000009,45257.248142500001]
[null,"CCA Rate Class",{"$f":"'3.  LDC Assumptions and Data'!C71","v":45},{"$f":"'3.  LDC Assumptions and Data'!D71","v":50},{"$f":"'3.  LDC Assumptions and Data'!E71","v":50},{"$f":"'3.  LDC Assumptions and Data'!F71","v":50},{"$f":"'3.  LDC Assumptions and Data'!G71","v":50},{"$f":"'3.  LDC Assumptions and Data'!H71","v":50}]
[null,"CCA Rate ",{"$f":"'3.  LDC Assumptions and Data'!C72","v":0.45},{"$f":"'3.  LDC Assumptions and Data'!D72","v":0.55000000000000004},{"$f":"'3.  LDC Assumptions and Data'!E72","v":0.55000000000000004},{"$f":"'3.  LDC Assumptions and Data'!F72","v":0.55000000000000004},{"$f":"'3.  LDC Assumptions and Data'!G72","v":0.55000000000000004},{"$f":"'3.  LDC Assumptions and Data'!H72","v":0.55000000000000004}]
[null,"CCA",{"$f":"IF((C104*C106)<C104,(C104*C106),C104)","v":0},0,2593.1180000000004,11556.323350000001,23664.230507500008,24891.486478375002]
[null,"Closing UCC",{"$f":"IF((C102-C107)<0,0,(C102-C107))","v":0},0,6836.402,23630.268650000005,38757.248142500001,26865.761664124999]
[]
[null,"UCC - General Equipment",{"$f":"C96","v":2006},2007,2008,2009,2010,2011]
[null,null,"Audited Actual","Audited Actual","Audited Actual","Audited Actual","Actual","Forecasted"]
[]
[null,"Opening UCC",0,{"$f":"C122","v":0},{"$f":"D122","v":0},{"$f":"E122","v":0},{"$f":"F122","v":0},{"$f":"G122","v":0}]
[null,"Capital Additions Tools & Equipment",{"$f":"C54","v":0},0,0,0,0,0]
[null,"Capital Additions Other Equipment",{"$f":"C69","v":0},0,0,0,0,0]
[null,"UCC Before Half Year Rule",{"$f":"SUM(C113:C115)","v":0},0,0,0,0,0]
[null,"Half Year Rule (1/2 Additions - Disposals)",{"$f":"SUM(C114:C115)/2","v":0},0,0,0,0,0]
[null,"Reduced UCC",{"$f":"C113+C117","v":0},0,0,0,0,0]
[null,"CCA Rate Class",{"$f":"'3.  LDC Assumptions and Data'!C74","v":8},{"$f":"'3.  LDC Assumptions and Data'!D74","v":8},{"$f":"'3.  LDC Assumptions and Data'!E74","v":8},{"$f":"'3.  LDC Assumptions and Data'!F74","v":8},{"$f":"'3.  LDC Assumptions and Data'!G74","v":8},{"$f":"'3.  LDC Assumptions and Data'!H74","v":8}]
[null,"CCA Rate ",{"$f":"'3.  LDC Assumptions and Data'!C75","v":0.2},{"$f":"'3.  LDC Assumptions and Data'!D75","v":0.2},{"$f":"'3.  LDC Assumptions and Data'!E75","v":0.2},{"$f":"'3.  LDC Assumptions and Data'!F75","v":0.2},{"$f":"'3.  LDC Assumptions and Data'!G75","v":0.2},{"$f":"'3.  LDC Assumptions and Data'!H75","v":0.2}]
[null,"CCA",{"$f":"IF((C118*C120)<C118,(C118*C120),C118)","v":0},0,0,0,0,0]
[null,"Closing UCC",{"$f":"IF((C116-C121)<0,0,(C116-C121))","v":0},0,0,0,0,0]

{"sheet":"7. Funding Adder Collected","index":6,"n_rows":81,"n_cols":11,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
[null,"Sheet 7. Smart Meter Funding Adder Collected",null,null,null,null,null,null,null," Approved Deferral and Variance Accounts "," CWIP Account"]
[null,null,null,null,null,null,null,null,null,"Prescribed Interest Rate (per the Bankers' Acceptances-3 months Plus 0.25 Spread)","Prescribed Interest Rate (per the DEX Mid Term Corporate Bond Index Yield 2)"]
["Date","Opening ","Fund Adder","Int. Rate","Interest","Closing",null,null,"Q2 2006 ",4.1399999999999997,4.68]
["2006-01-01",0,0,{"$f":"'3.  LDC Assumptions and Data'!$C$19","v":0},{"$f":"(B4*D4)/12","v":0},{"$f":"SUM(B4:C4,E4)","v":0},null,null,"Q3 2006 ",4.59,5.05]
["2006-02-01",{"$f":"F4","v":0},0,{"$f":"'3.  LDC Assumptions and Data'!$C$19","v":0},0,{"$f":"SUM(B5:C5,E5)","v":0},null,null,"Q4 2006 ",4.59,4.72]
["2006-03-01",0,0,{"$f":"'3.  LDC Assumptions and Data'!$C$19","v":0},0,0,null,null,"Q1 2007 ",4.59,4.72]
["2006-04-01",0,0,4.1399999999999999E-2,0,0,null,null,"Q2 2007 ",4.59,4.72]
["2006-05-01",0,0,4.1399999999999999E-2,0,0,null,null,"Q3 2007 ",4.59,5.18]
["2006-06-01",0,348.92,4.1399999999999999E-2,0,348.92,null,null,"Q4 2007 ",5.14,5.18]
["2006-07-01",348.92,348.92,4.5900000000000003E-2,1.3346190000000002,699.17461900000001,null,null,"Q1 2008 ",5.14,5.18]
["2006-08-01",699.17461900000001,348.92,4.5900000000000003E-2,2.6743429176750002,1050.7689619176749,null,null,"Q2 2008 ",4.08,5.18]
["2006-09-01",1050.7689619176749,348.92,4.5900000000000003E-2,4.0191912793351063,1403.70815319701,null,null,"Q3 2008 ",3.35,5.43]
["2006-10-01",1403.70815319701,348.92,4.5900000000000003E-2,5.3691836859785633,1757.9973368829887,null,null,"Q4 2008 ",3.35,5.43]
["2006-11-01",1757.9973368829887,348.92,4.5900000000000003E-2,6.7243398135774326,2113.6416766965663,null,null,"Q1 2009",2.4500000000000002,6.61]
["2006-12-01",2113.6416766965663,348.92,4.5900000000000003E-2,8.0846794133643662,2470.6463561099308,null,null,"Q2 2009",1,6.61]
["2007-01-01",2470.6463561099308,348.92,4.5900000000000003E-2,9.450222312120486,2829.0165784220512,null,null,"Q3 2009",0.55000000000000004,5.67]
["2007-02-01",2829.0165784220512,348.92,4.5900000000000003E-2,10.820988412464347,3188.7575668345157,null,null,"Q4 2009",0.55000000000000004,4.66]
["2007-03-01",3188.7575668345157,348.92,4.5900000000000003E-2,12.196997693142023,3549.8745645276576,null,null,"Q1 2010",0.55000000000000004,4.34]
["2007-04-01",3549.8745645276576,348.92,4.5900000000000003E-2,13.578270209318291,3912.3728347369761,null,null,"Q2 2010",0.55000000000000004,4.34]
["2007-05-01",3912.3728347369761,348.92,4.5900000000000003E-2,14.964826092868934,4276.257660829845,null,null,"Q3 2010",0.89,4.66]
["2007-06-01",4276.257660829845,348.92,4.5900000000000003E-2,16.356685552674158,4641.5343463825193]
["2007-07-01",4641.5343463825193,348.92,4.5900000000000003E-2,17.753868874913138,5008.2082152574321]
["2007-08-01",5008.2082152574321,348.92,4.5900000000000003E-2,19.156396423359677,5376.2846116807923,null,null,null," "]
["2007-09-01",5376.2846116807923,348.92,4.5900000000000003E-2,20.564288639679031,5745.7689003204714]
["2007-10-01",5745.7689003204714,348.92,5.1400000000000001E-2,24.611043456372684,6119.299943776844]
["2007-11-01",6119.299943776844,348.92,5.1400000000000001E-2,26.211001425844149,6494.4309452026882]
["2007-12-01",6494.4309452026882,348.92,5.1400000000000001E-2,27.817812548618182,6871.1687577513067]
["2008-01-01",6871.1687577513067,348.92,5.1400000000000001E-2,{"$f":"(B28*D28)/12","v":29.431506179034766},{"$f":"SUM(B28:C28,E28)","v":7249.5202639303416}]
["2008-02-01",{"$f":"F28","v":7249.5202639303416},348.92,5.1400000000000001E-2,31.052111797168298,7629.4923757275101]
["2008-03-01",7629.4923757275101,348.92,5.1400000000000001E-2,32.679659009366169,8011.0920347368765]
["2008-04-01",8011.0920347368765,348.92,4.0800000000000003E-2,27.237712918105384,8387.2497476549815,null,null,null," "]
["2008-05-01",8387.2497476549815,348.92,4.0800000000000003E-2,28.516649142026939,8764.6863967970094]
["2008-06-01",8764.6863967970094,348.92,4.0800000000000003E-2,29.799933749109837,9143.4063305461186]
["2008-07-01",9143.4063305461186,348.92,3.3500000000000002E-2,25.525342672774585,9517.8516732188928]
["2008-08-01",9517.8516732188928,348.92,3.3500000000000002E-2,26.570669254402745,9893.3423424732955,null,null,null," "]
["2008-09-01",9893.3423424732955,349.44,3.3500000000000002E-2,27.618914039404618,10270.401256512701]
["2008-10-01",10270.401256512701,349.44,3.3500000000000002E-2,28.671536841097961,10648.512793353801]
["2008-11-01",10648.512793353801,349.44,3.3500000000000002E-2,29.72709821477936,11027.679891568581]
["2008-12-01",11027.679891568581,349.44,3.3500000000000002E-2,30.785606363962291,11407.905497932545,null,null,null," "]
["2009-01-01",11407.905497932545,349.44,2.4500000000000001E-2,23.291140391612277,11780.636638324157]
["2009-02-01",11780.636638324157,349.44,2.4500000000000001E-2,24.052133136578487,12154.128771460735]
["2009-03-01",12154.128771460735,349.44,2.4500000000000001E-2,24.814679575065668,12528.383451035801]
["2009-04-01",12528.383451035801,349.44,0.01,10.440319542529835,12888.263770578331,null,null,null," "]
["2009-05-01",12888.263770578331,349.44,0.01,10.740219808815276,13248.443990387146]
["2009-06-01",13248.443990387146,1344,0.01,11.040369991989289,14603.484360379136]
["2009-07-01",14603.484360379136,1344,5.4999999999999997E-3,6.6932636651737702,15954.177624044311]
["2009-08-01",15954.177624044311,1344,5.4999999999999997E-3,7.3123314110203088,17305.48995545533,null,null,null," "]
["2009-09-01",17305.48995545533,1344,5.4999999999999997E-3,7.9316828962503587,18657.421638351581]
["2009-10-01",18657.421638351581,1344,5.4999999999999997E-3,8.551318250911141,20009.972956602491]
["2009-11-01",20009.972956602491,1344,5.4999999999999997E-3,9.1712376051094733,21363.144194207602]
["2009-12-01",21363.144194207602,1344,5.4999999999999997E-3,9.7914410890118173,22716.935635296613,null,null,null," "]
["2010-01-01",22716.935635296613,1344,5.4999999999999997E-3,10.41192883284428,24071.347564129457]
["2010-02-01",24071.347564129457,1344,5.4999999999999997E-3,11.032700966892667,25426.380265096352]
["2010-03-01",25426.380265096352,1344,5.4999999999999997E-3,11.653757621502493,26782.034022717853]
["2010-04-01",26782.034022717853,1344,5.4999999999999997E-3,12.275098927079014,28138.309121644932,null,null,null," "]
["2010-05-01",28138.309121644932,1344,5.4999999999999997E-3,12.896725014087259,29495.205846659021]
["2010-06-01",29495.205846659021,1344,5.4999999999999997E-3,13.518636013052051,30852.724482672074]
["2010-07-01",30852.724482672074,1350.73,8.8999999999999999E-3,22.882437324648453,32226.336919996724]
["2010-08-01",32226.336919996724,1225.94,8.8999999999999999E-3,23.901199882330904,33476.178119879056]
["2010-09-01",33476.178119879056,1326.01,8.8999999999999999E-3,24.8281654389103,34827.016285317972]
["2010-10-01",34827.016285317972,1330,8.8999999999999999E-3,25.830037078277496,36182.846322396246]
["2010-11-01",36182.846322396246,1330,8.8999999999999999E-3,26.835611022443882,37539.681933418688]
["2010-12-01",37539.681933418688,1330,8.8999999999999999E-3,27.841930767285529,38897.523864185976]
["2011-01-01",38897.523864185976,1330,8.8999999999999999E-3,28.848996865937931,40256.372861051917]
["2011-02-01",40256.372861051917,1330,8.8999999999999999E-3,29.856809871946837,41616.229670923865]
["2011-03-01",41616.229670923865,1330,8.8999999999999999E-3,30.865370339268534,42977.095041263135]
["2011-04-01",42977.095041263135,1330,8.8999999999999999E-3,31.874678822270159,44338.969720085406]
["2011-05-01",44338.969720085406,1330,null,0,45668.969720085406]
["2011-06-01",45668.969720085406,0,null,0,45668.969720085406]
["2011-07-01",45668.969720085406,0,null,0,45668.969720085406]
["2011-08-01",45668.969720085406,0,null,0,45668.969720085406]
["2011-09-01",45668.969720085406,0,null,0,45668.969720085406]
["2011-10-01",45668.969720085406,0,null,0,45668.969720085406]
["2011-11-01",45668.969720085406,0,null,0,45668.969720085406]
["2011-12-01",45668.969720085406,0,null,0,45668.969720085406]
["2012-01-01",45668.969720085406,0,null,0,45668.969720085406]
["2012-02-01",45668.969720085406,0,null,0,45668.969720085406]
["2012-03-01",45668.969720085406,0,null,0,45668.969720085406]
["2012-04-01",45668.969720085406,0,null,0,45668.969720085406]
["2012-05-01",45668.969720085406,0,null,0,45668.969720085406]
[null,null,{"$f":"SUM(C4:C80)","v":44580.480000000003},null,{"$f":"SUM(E4:E80)","v":1088.4897200853841}]

{"sheet":"8. Smart Meter Rate  Adder","index":7,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,"Sheet 8 Applied for Smart Meter Rate Adder"]
[]
[]
[null,"Description","Amount"]
[null,"Revenue Requirement - 2006",{"$f":"'4. Smart Meter Rev Req'!E55","v":0}]
[null,"Revenue Requirement - 2007",{"$f":"'4. Smart Meter Rev Req'!H55","v":0}]
[null,"Revenue Requirement - 2008",{"$f":"'4. Smart Meter Rev Req'!K55","v":386.13501547308249}]
[null,"Revenue Requirement - 2009",{"$f":"'4. Smart Meter Rev Req'!N55","v":37007.822091202455}]
[null,"Revenue Requirement - 2010",{"$f":"'4. Smart Meter Rev Req'!Q55","v":69192.127096210126}]
[null,"Revenue Requirement - 2011",{"$f":"'4. Smart Meter Rev Req'!T55","v":77449.60203394953}]
[null,"Total Revenue Requirement",{"$f":"SUM(C5:C10)","v":184035.6862368352}]
[]
[null,"Smart Meter Rate Adder Collected",{"$f":"-'7. Funding Adder Collected'!C81","v":-44580.480000000003}]
[null,"Carrying Cost / Interest",{"$f":"-'7. Funding Adder Collected'!E81","v":-1088.4897200853841}]
[]
[null,"Proposed Smart Meter Recovery",{"$f":"SUM(C11:C14)","v":138366.71651674982}]
[]
[null,"2011 Expected Metered Customers",1275,"Does not include GS >50kW (No Expenditures incurred - Not Mandated yet)"]
[]
[null,"Proposed Smart Meter Rate Adder",{"$f":"IF(C18<>0,C16/C18/12,0)","v":9.043576242924825},"Starting May 1, 2011"]