{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["1. Utility_Info","2. Smart_Meter_Costs","3. Cost_of_Service_Parameters","4. SM_Assets_and_Rate_Base","5. SM_Rev_Reqt","6. UCC_Calculation","7_Taxes_PILs","8. Funding_Adder_Revs","8A. Opex_Interest_monthly","8B. Opex_Interest_annual","9. SMFA_SMDR_SMIRR"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":15,"comments":4,"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. Utility_Info","index":0,"n_rows":106,"n_cols":31,"rows_kept":106,"cut":false,"hidden":false,"merged":[[1,2,1,9],[2,2,2,9],[3,2,3,9],[4,2,4,9]]}
[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,31]
[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,{"$f":"VLOOKUP(AB1, $AA$20:$AB$87, 2,0)","v":"Haldimand County Hydro Inc."},{"$f":"VLOOKUP($AB1, $AA$20:$AF$86, MATCH(AC$20, $AA$20:$AF$20,0),FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($AB1, $AA$20:$AF$86, MATCH(AD$20, $AA$20:$AF$20,0),FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($AB1, $AA$20:$AF$86, MATCH(AE$20, $AA$20:$AF$20,0),FALSE)","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2011-12-12",null,"Notes pages removed - kcr"]
[]
[]
[]
[null,null,"Name:","Jacqueline A. Scott"]
[]
[null,null,"Title:","Finance Manager"]
[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,"Company Name"]
[null,null,"Phone Number:","905-765-5211  ext. 2237",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Algoma Power Inc."]
[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,2,"Atikokan Hydro Inc."]
[null,null,"Email Address:","jscott@hchydro.ca",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Attawapiskat Power Corp. "]
[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,4,"Bluewater Power Distribution Corporation"]
[null,null,"We are applying for rates effective:","2012-11-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Brant County Power Inc."]
[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,6,"Brantford Power Inc."]
[null,null,"Last COS Re-based Year",2010,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Burlington Hydro Inc."]
[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,8,"Cambridge and North Dumfries Hydro Inc."]
[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,9,"Canadian Niagara Power Inc. - Eastern Ontario Power"]
[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,10,"Canadian Niagara Power Inc. - Fort Erie"]
[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,11,"Canadian Niagara Power Inc. - Port Colborne Hydro Inc."]
[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,12,"Centre Wellington Hydro Ltd."]
[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,13,"Chapleau Public Utilities Corporation"]
[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,14,"Chatham-Kent Hydro Inc."]
[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,15,"Clinton Power Corporation"]
[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,16,"COLLUS Power Corporation"]
[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,17,"Cooperative Hydro Embrun Inc."]
[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,18,"E.L.K. Energy Inc."]
[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,19,"Enersource Hydro Mississauga Inc."]
[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,20,"ENWIN Utilities Ltd."]
[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,21,"Erie Thames Powerlines Corporation"]
[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,22,"Espanola Regional Hydro Distribution Corporation"]
[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,23,"Essex Powerlines Corporation"]
[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,24,"Festival Hydro Inc."]
[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,25,"Festival Hydro Inc. - Hensall"]
[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,26,"Fort Albany Power Corporation"]
[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,27,"Fort Frances Power Corporation"]
[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,28,"Greater Sudbury Hydro Inc."]
[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,29,"Grimsby Power Inc."]
[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,30,"Guelph Hydro Electric Systems Inc."]
[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,31,"Haldimand County Hydro Inc."]
[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,32,"Halton Hills Hydro Inc."]
[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,33,"Hearst Power Distribution Company Limited"]
[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,34,"Horizon Utilities Corporation"]
[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,35,"Hydro 2000 Inc."]
[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,36,"Hydro Hawkesbury Inc."]
[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,37,"Hydro One Brampton Networks Inc."]
[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,38,"Hydro One Networks Inc."]
[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,39,"Hydro Ottawa Limited"]
[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,40,"Innisfil Hydro Distribution Systems Limited"]
[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,41,"Kashechewan Power Corporation"]
[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,42,"Kenora Hydro Electric Corporation Ltd."]
[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,43,"Kingston Hydro Corporation"]
[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,44,"Kitchener-Wilmot Hydro Inc."]
[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,45,"Lakefront Utilities Inc."]
[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,46,"Lakeland Power Distribution Ltd."]
[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,47,"London Hydro Inc."]
[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,48,"Middlesex Power Distribution Corporation"]
[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,49,"Middlesex Power Distribution Corporation - Dutton"]
[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,50,"Middlesex Power Distribution Corporation - Newbury"]
[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,51,"Midland Power Utility Corporation"]
[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,52,"Milton Hydro Distribution inc."]
[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,53,"Newmarket - Tay Power Distribution Ltd."]
[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,54,"Niagara Peninsula Energy Inc."]
[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,55,"Niagara-on-the-Lake Hydro Inc."]
[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,56,"Norfolk Power Distribution Inc."]
[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,57,"North Bay Hydro Distribution Limited"]
[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,58,"Northern Ontario Wires Inc."]
[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,59,"Oakville Hydro Electricity Distribution Inc."]
[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,60,"Orangeville Hydro Limited"]
[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,61,"Orillia Power Distribution Corporation"]
[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,62,"Oshawa PUC Networks Inc."]
[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,63,"Ottawa River Power Corporation"]
[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,64,"Parry Sound Power Corporation"]
[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,65,"Peterborough Distribution Incorporated"]
[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,66,"PowerStream Inc. - Barrie"]
[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,67,"PowerStream Inc. - South"]
[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,68,"PUC Distribution Inc."]
[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,69,"Renfrew Hydro Inc."]
[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,70,"Rideau St. Lawrence Distribution Inc."]
[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,71,"Sioux Lookout Hydro Inc."]
[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,72,"St. Thomas Energy Inc."]
[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,73,"Thunder Bay Hydro Electricity Distribution Inc."]
[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,74,"Tillsonburg Hydro Inc."]
[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,75,"Toronto Hydro-Electric System Limited"]
[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,76,"Veridian Connections Inc."]
[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,77,"Veridian Connections Inc. - Gravenhurst"]
[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,78,"Wasaga Distribution Inc."]
[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,79,"Waterloo North Hydro Inc."]
[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,80,"Welland Hydro-Electric System Corp."]
[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,81,"Wellington North Power Inc."]
[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,82,"West Coast Huron Energy Inc."]
[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,83,"West Perth Power Inc."]
[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,84,"Westario Power Inc."]
[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,85,"Whitby Hydro Electric Corporation"]
[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,86,"Woodstock Hydro Services Inc."]

{"sheet":"2. Smart_Meter_Costs","index":1,"n_rows":197,"n_cols":21,"rows_kept":197,"cut":false,"hidden":false,"merged":[[165,2,165,3],[167,2,167,3],[169,2,169,3],[62,2,62,3],[100,2,100,3],[102,2,102,3],[104,2,104,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,2006,null,2007,null,2008,null,2009,null,2010,null,2011,null,"2012 and later",null,"Total"]
[null,"Smart Meter Capital Cost and Operational Expense Data",null,null,null,null,"Audited Actual",null,"Audited Actual",null,"Audited Actual",null,"Audited Actual",null,"Audited Actual",null,"Audited Actual",null,"Forecast"]
[]
[null,null,"Smart Meter Installation Plan"]
[]
[null,null,"Actual/Planned number of Smart Meters installed during the Calendar Year"]
[]
[null,null,"Residential",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G25,I25,K25,M25,O25,Q25,S25)","v":0}]
[]
[null,null,"General Service < 50 kW",null,null,null,null,null,null,null,null,null,1275,null,758,null,316,null,12,null,{"$f":"SUM(G27,I27,K27,M27,O27,Q27,S27)","v":2361}]
[]
[null,null,"Actual/Planned number of Smart Meters installed (Residential and GS < 50 kW only)",null,null,null,{"$f":"G25+G27","v":0},null,{"$f":"I25+I27","v":0},null,{"$f":"K25+K27","v":0},null,{"$f":"M25+M27","v":1275},null,{"$f":"O25+O27","v":758},null,{"$f":"Q25+Q27","v":316},null,{"$f":"S25+S27","v":12},null,{"$f":"SUM(G29,I29,K29,M29,O29,Q29,S29)","v":2361}]
[]
[null,null,"Percentage of Residential and GS < 50 kW Smart Meter Installations Completed",null,null,null,{"$f":"IF($U29=0,0,G29/$U29)","v":0},null,{"$f":"IF(G31=100%, 0, IF(ISERROR(SUM(G29:I29)/$U29),0,SUM(G29:I29)/$U29))","v":0},null,{"$f":"IF(I31=100%, 0, IF(ISERROR(SUM(G29:K29)/$U29), 0, SUM(G29:K29)/$U29))","v":0},null,{"$f":"IF(K31=100%,0,IF(ISERROR(SUM(G29:M29)/$U29),0,SUM(G29:M29)/$U29))","v":0.54002541296060991},null,{"$f":"IF(M31=100%,0,IF(ISERROR(SUM(G29:O29)/$U29),0,SUM(G29:O29)/$U29))","v":0.86107581533248623},null,{"$f":"IF(O31=100%,0,IF(ISERROR(SUM(G29:Q29)/$U29),0,SUM(G29:Q29)/$U29))","v":0.99491740787801775},null,{"$f":"IF(Q31=100%,0,IF(ISERROR(SUM(G29:S29)/$U29),0,SUM(G29:S29)/$U29))","v":1},null,{"$f":"IF($U29=0,\"\",U29/$U29)","v":1}]
[]
[null,null,"Actual/Planned number of GS > 50 kW meters installed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G33,I33,K33,M33,O33,Q33,S33)","v":0}]
[]
[null,null,"Other (please identify)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G35,I35,K35,M35,O35,Q35,S35)","v":0}]
[]
[null,null,"Total Number of Smart Meters installed or planned to be installed",null,null,null,{"$f":"SUM(G29,G33,G35)","v":0},null,{"$f":"SUM(I29,I33,I35)","v":0},null,{"$f":"SUM(K29,K33,K35)","v":0},null,{"$f":"SUM(M29,M33,M35)","v":1275},null,{"$f":"SUM(O29,O33,O35)","v":758},null,{"$f":"SUM(Q29,Q33,Q35)","v":316},null,{"$f":"SUM(S29,S33,S35)","v":12},null,{"$f":"SUM(G37,I37,K37,M37,O37,Q37,S37)","v":2361}]
[]
[null,1,"Capital Costs"]
[null,null,null,null,"Asset Type"]
[null,null,"1.1  ADVANCED METERING COMMUNICATION DEVICE (AMCD)",null,"Asset type must be selected to enable calculations",null,{"$f":"IF(ISBLANK(G19),\"\",G19)","v":"Audited Actual"},null,{"$f":"IF(ISBLANK(I19),\"\",I19)","v":"Audited Actual"},null,{"$f":"IF(ISBLANK(K19),\"\",K19)","v":"Audited Actual"},null,{"$f":"IF(ISBLANK(M19),\"\",M19)","v":"Audited Actual"},null,{"$f":"IF(ISBLANK(O19),\"\",O19)","v":"Audited Actual"},null,{"$f":"IF(ISBLANK(Q19),\"\",Q19)","v":"Audited Actual"},null,{"$f":"IF(ISBLANK(S19),\"\",S19)","v":"Forecast"}]
[null,null,"1.1.1  Smart Meters (may include new meters and modules, etc.)",null,"Smart Meter",null,null,null,null,null,null,null,103674,null,240374,null,159687,null,2954,null,{"$f":"SUM(G42,I42,K42,M42,O42,Q42,S42)","v":506689}]
[]
[null,null,"1.1.2  Installation Costs (may include socket kits, labour, vehicle, benefits, etc.)",null,"Smart Meter",null,null,null,8582,null,2859,null,{"$f":"13798+15387","v":29185},null,{"$f":"4823+55521","v":60344},null,{"$f":"913+36622","v":37535},null,484,null,{"$f":"SUM(G44,I44,K44,M44,O44,Q44,S44)","v":138989}]
[]
[null,null,"1.1.3a  Workforce Automation Hardware (may include fieldwork handhelds, barcode hardware, etc.)",null,"Computer Hardware",null,null,null,null,null,null,null,477,null,4686,null,585,null,null,null,{"$f":"SUM(G46,I46,K46,M46,O46,Q46,S46)","v":5748}]
[]
[null,null,"1.1.3b  Workforce Automation Software (may include fieldwork handhelds, barcode hardware, etc.)",null,"Computer Software",null,null,null,null,null,null,null,245,null,2294,null,2528,null,null,null,{"$f":"SUM(G48,I48,K48,M48,O48,Q48,S48)","v":5067}]
[]
[null,null,"Total Advanced Metering Communications Devices (AMCD)",null,null,null,{"$f":"SUM(G42,G44,G46,G48)","v":0},null,{"$f":"SUM(I42,I44,I46,I48)","v":8582},null,{"$f":"SUM(K42,K44,K46,K48)","v":2859},null,{"$f":"SUM(M42,M44,M46,M48)","v":133581},null,{"$f":"SUM(O42,O44,O46,O48)","v":307698},null,{"$f":"SUM(Q42,Q44,Q46,Q48)","v":200335},null,{"$f":"SUM(S42,S44,S46,S48)","v":3438},null,{"$f":"U42+U44+U46+U48","v":656493}]
[]
[null,null,null,null,{"$f":"E40","v":"Asset Type"}]
[null,null,"1.2  ADVANCED METERING REGIONAL COLLECTOR (AMRC)  (includes LAN)",null,null,null,{"$f":"G41","v":"Audited Actual"},null,{"$f":"I41","v":"Audited Actual"},null,{"$f":"K41","v":"Audited Actual"},null,{"$f":"M41","v":"Audited Actual"},null,{"$f":"O41","v":"Audited Actual"},null,{"$f":"Q41","v":"Audited Actual"},null,{"$f":"S41","v":"Forecast"}]
[null,null,"1.2.1  Collectors",null,"Smart Meter",null,null,null,null,null,null,null,63590,null,null,null,null,null,null,null,{"$f":"SUM(G54,I54,K54,M54,O54,Q54,S54)","v":63590}]
[]
[null,null,"1.2.2  Repeaters (may include radio licence, etc.)",null,"Smart Meter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G56,I56,K56,M56,O56,Q56,S56)","v":0}]
[]
[null,null,"1.2.3  Installation (may include meter seals and rings, collector computer hardware, etc.)",null,"Smart Meter",null,null,null,null,null,null,null,7057,null,1404,null,38,null,null,null,{"$f":"SUM(G58,I58,K58,M58,O58,Q58,S58)","v":8499}]
[]
[null,null,"Total Advanced Metering Regional Collector (AMRC)  (Includes LAN)",null,null,null,{"$f":"G54+G56+G58","v":0},null,{"$f":"I54+I56+I58","v":0},null,{"$f":"K54+K56+K58","v":0},null,{"$f":"M54+M56+M58","v":70647},null,{"$f":"O54+O56+O58","v":1404},null,{"$f":"Q54+Q56+Q58","v":38},null,{"$f":"S54+S56+S58","v":0},null,{"$f":"U54+U56+U58","v":72089}]
[]
[null,null,null,null,{"$f":"E52","v":"Asset Type"}]
[null,null,"1.3  ADVANCED METERING CONTROL COMPUTER (AMCC)",null,null,null,{"$f":"G53","v":"Audited Actual"},null,{"$f":"I53","v":"Audited Actual"},null,{"$f":"K53","v":"Audited Actual"},null,{"$f":"M53","v":"Audited Actual"},null,{"$f":"O53","v":"Audited Actual"},null,{"$f":"Q53","v":"Audited Actual"},null,{"$f":"S53","v":"Forecast"}]
[null,null,"1.3.1  Computer Hardware",null,"Computer Hardware",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G64,I64,K64,M64,O64,Q64,S64)","v":0}]
[]
[null,null,"1.3.2  Computer Software",null,"Computer Software",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G66,I66,K66,M66,O66,Q66,S66)","v":0}]
[]
[null,null,"1.3.3  Computer Software Licences & Installation (includes hardware and software)",null,"Computer Software",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G68,I68,K68,M68,O68,Q68,S68)","v":0}]
[null,null,"          (may include AS/400 disk space, backup and recovery computer, UPS, etc.)"]
[null,null,"Total Advanced Metering Control Computer (AMCC)",null,null,null,{"$f":"G64+G66+G68","v":0},null,{"$f":"I64+I66+I68","v":0},null,{"$f":"K64+K66+K68","v":0},null,{"$f":"M64+M66+M68","v":0},null,{"$f":"O64+O66+O68","v":0},null,{"$f":"Q64+Q66+Q68","v":0},null,{"$f":"S64+S66+S68","v":0},null,{"$f":"U64+U66+U68","v":0}]
[]
[null,null,null,null,{"$f":"E62","v":"Asset Type"}]
[null,null,"1.4  WIDE AREA NETWORK (WAN)",null,null,null,{"$f":"G63","v":"Audited Actual"},null,{"$f":"I63","v":"Audited Actual"},null,{"$f":"K63","v":"Audited Actual"},null,{"$f":"M63","v":"Audited Actual"},null,{"$f":"O63","v":"Audited Actual"},null,{"$f":"Q63","v":"Audited Actual"},null,{"$f":"S63","v":"Forecast"}]
[]
[null,null,"1.4.1  Activiation Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G75,I75,K75,M75,O75,Q75,S75)","v":0}]
[]
[null,null,"Total Wide Area Network (WAN)",null,null,null,{"$f":"G75","v":0},null,{"$f":"I75","v":0},null,{"$f":"K75","v":0},null,{"$f":"M75","v":0},null,{"$f":"O75","v":0},null,{"$f":"Q75","v":0},null,{"$f":"S75","v":0},null,{"$f":"U75","v":0}]
[]
[null,null,null,null,{"$f":"E72","v":"Asset Type"}]
[null,null,"1.5  OTHER AMI CAPITAL COSTS RELATED TO MINIMUM FUNCTIONALITY",null,null,null,{"$f":"G73","v":"Audited Actual"},null,{"$f":"I73","v":"Audited Actual"},null,{"$f":"K73","v":"Audited Actual"},null,{"$f":"M73","v":"Audited Actual"},null,{"$f":"O73","v":"Audited Actual"},null,{"$f":"Q73","v":"Audited Actual"},null,{"$f":"S73","v":"Forecast"}]
[]
[null,null,"1.5.1  Customer Equipment (including repair of damaged equipment)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G82,I82,K82,M82,O82,Q82,S82)","v":0}]
[]
[null,null,"1.5.2  AMI Interface to CIS",null,"Computer Software",null,null,null,null,null,null,null,273,null,497,null,66,null,null,null,{"$f":"SUM(G84,I84,K84,M84,O84,Q84,S84)","v":836}]
[]
[null,null,"1.5.3  Professional Fees",null,"Smart Meter",null,null,null,1608,null,1678,null,2893,null,1963,null,1210,null,null,null,{"$f":"SUM(G86,I86,K86,M86,O86,Q86,S86)","v":9352}]
[]
[null,null,"1.5.4  Integration",null,"Computer Software",null,null,null,null,null,null,null,null,null,893,null,225,null,null,null,{"$f":"SUM(G88,I88,K88,M88,O88,Q88,S88)","v":1118}]
[]
[null,null,"1.5.5  Program Management",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G90,I90,K90,M90,O90,Q90,S90)","v":0}]
[]
[null,null,"1.5.6  Other AMI Capital",null,"Smart Meter",null,null,null,null,null,null,null,null,null,47,null,13,null,null,null,{"$f":"SUM(G92,I92,K92,M92,O92,Q92,S92)","v":60}]
[]
[null,null,"Total Other AMI Capital Costs Related to Minimum Functionality",null,null,null,{"$f":"SUM(G82,G84,G86,G88,G90,G92)","v":0},null,{"$f":"SUM(I82,I84,I86,I88,I90,I92)","v":1608},null,{"$f":"SUM(K82,K84,K86,K88,K90,K92)","v":1678},null,{"$f":"SUM(M82,M84,M86,M88,M90,M92)","v":3166},null,{"$f":"SUM(O82,O84,O86,O88,O90,O92)","v":3400},null,{"$f":"SUM(Q82,Q84,Q86,Q88,Q90,Q92)","v":1514},null,{"$f":"SUM(S82,S84,S86,S88,S90,S92)","v":0},null,{"$f":"SUM(U82,U84,U86,U88,U90,U92)","v":11366}]
[]
[null,null,"Total Capital Costs Related to Minimum Functionality",null,null,null,{"$f":"SUM(G50,G60,G70,G77,G94)","v":0},null,{"$f":"SUM(I50,I60,I70,I77,I94)","v":10190},null,{"$f":"SUM(K50,K60,K70,K77,K94)","v":4537},null,{"$f":"SUM(M50,M60,M70,M77,M94)","v":207394},null,{"$f":"SUM(O50,O60,O70,O77,O94)","v":312502},null,{"$f":"SUM(Q50,Q60,Q70,Q77,Q94)","v":201887},null,{"$f":"SUM(S50,S60,S70,S77,S94)","v":3438},null,{"$f":"SUM(U50,U60,U70,U77,U94)","v":739948}]
[]
[null,null,null,null,{"$f":"E79","v":"Asset Type"}]
[null,null,"1.6  CAPITAL COSTS BEYOND MINIMUM FUNCTIONALITY",null,null,null,{"$f":"G80","v":"Audited Actual"},null,{"$f":"I80","v":"Audited Actual"},null,{"$f":"K80","v":"Audited Actual"},null,{"$f":"M80","v":"Audited Actual"},null,{"$f":"O80","v":"Audited Actual"},null,{"$f":"Q80","v":"Audited Actual"},null,{"$f":"S80","v":"Forecast"}]
[null,null,"(Please provide a descriptive title and identify nature of beyond minimum functionality costs)"]
[null,null,"1.6.1  Costs related to technical capabilities in the smart meters or related communications infrastructure that exceed those specified in O.Reg 425/06",null,"Computer Software",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G101,I101,K101,M101,O101,Q101,S101)","v":0}]
[]
[null,null,"1.6.2  Costs for deployment of smart meters to customers other than residential                                                 and small general service ",null,"Applications Software",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G103,I103,K103,M103,O103,Q103,S103)","v":0}]
[]
[null,null,"1.6.3  Costs for TOU rate implementation, CIS system upgrades, web presentation,                                     integration with the MDM/R, etc.  ",null,"Smart Meter",null,null,null,null,null,null,null,null,null,479,null,3587,null,null,null,{"$f":"SUM(G105,I105,K105,M105,O105,Q105,S105)","v":4066}]
[]
[null,null,"Total Capital Costs Beyond Minimum Functionality",null,null,null,{"$f":"SUM(G101,G103,G105)","v":0},null,{"$f":"SUM(I101,I103,I105)","v":0},null,{"$f":"SUM(K101,K103,K105)","v":0},null,{"$f":"SUM(M101,M103,M105)","v":0},null,{"$f":"SUM(O101,O103,O105)","v":479},null,{"$f":"SUM(Q101,Q103,Q105)","v":3587},null,{"$f":"SUM(S101,S103,S105)","v":0},null,{"$f":"SUM(U101,U103,U105)","v":4066}]
[]
[null,null,"Total Smart Meter Capital Costs",null,null,null,{"$f":"G96+G107","v":0},null,{"$f":"I96+I107","v":10190},null,{"$f":"K96+K107","v":4537},null,{"$f":"M96+M107","v":207394},null,{"$f":"O96+O107","v":312981},null,{"$f":"Q96+Q107","v":205474},null,{"$f":"S96+S107","v":3438},null,{"$f":"U96+U107","v":744014}]
[]
[null,2,"OM&A Expenses"]
[null,null,"2.1  ADVANCED METERING COMMUNICATION DEVICE (AMCD)",null,null,null,{"$f":"G99","v":"Audited Actual"},null,{"$f":"I99","v":"Audited Actual"},null,{"$f":"K99","v":"Audited Actual"},null,{"$f":"M99","v":"Audited Actual"},null,{"$f":"O99","v":"Audited Actual"},null,{"$f":"Q99","v":"Audited Actual"},null,{"$f":"S99","v":"Forecast"}]
[]
[null,null,"2.1.1  Maintenance (may include meter reverification costs, etc.)",null,null,null,null,null,null,null,null,null,3211,null,1342,null,8849,null,13500,null,{"$f":"SUM(G114,I114,K114,M114,O114,Q114,S114)","v":26902}]
[]
[null,null,"2.1.2  Other (please specifiy)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G116,I116,K116,M116,O116,Q116,S116)","v":0}]
[]
[null,null,"Total Incremental AMCD OM&A Costs",null,null,null,{"$f":"SUM(G114,G116)","v":0},null,{"$f":"SUM(I114,I116)","v":0},null,{"$f":"SUM(K114,K116)","v":0},null,{"$f":"SUM(M114,M116)","v":3211},null,{"$f":"SUM(O114,O116)","v":1342},null,{"$f":"SUM(Q114,Q116)","v":8849},null,{"$f":"SUM(S114,S116)","v":13500},null,{"$f":"SUM(U114,U116)","v":26902}]
[]
[null,null,"2.2  ADVANCED METERING REGIONAL COLLECTOR (AMRC) (includes LAN)"]
[]
[null,null,"2.2.1  Maintenance",null,null,null,null,null,null,null,null,null,9374,null,16882,null,12526,null,{"$f":"13615+2878","v":16493},null,{"$f":"SUM(G122,I122,K122,M122,O122,Q122,S122)","v":55275}]
[]
[null,null,"2.2.2  Other (please specifiy)","Additional Insurance re: Tower Gateway Base Stations",null,null,null,null,null,null,null,null,171,null,null,null,null,null,null,null,{"$f":"SUM(G124,I124,K124,M124,O124,Q124,S124)","v":171}]
[]
[null,null,"Total Incremental AMRC OM&A Costs",null,null,null,{"$f":"SUM(G122,G124)","v":0},null,{"$f":"SUM(I122,I124)","v":0},null,{"$f":"SUM(K122,K124)","v":0},null,{"$f":"SUM(M122,M124)","v":9545},null,{"$f":"SUM(O122,O124)","v":16882},null,{"$f":"SUM(Q122,Q124)","v":12526},null,{"$f":"SUM(S122,S124)","v":16493},null,{"$f":"SUM(U122,U124)","v":55446}]
[]
[null,null,"2.3  ADVANCED METERING CONTROL COMPUTER (AMCC)"]
[]
[null,null,"2.3.1  Hardware Maintenance (may include server support, etc.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G130,I130,K130,M130,O130,Q130,S130)","v":0}]
[]
[null,null,"2.3.2 Software Maintenance (may include maintenance support, etc.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G132,I132,K132,M132,O132,Q132,S132)","v":0}]
[]
[null,null,"2.3.2  Other (please specifiy)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G134,I134,K134,M134,O134,Q134,S134)","v":0}]
[]
[null,null,"Total Incremental AMCC OM&A Costs",null,null,null,{"$f":"SUM(G130,G132,G134)","v":0},null,{"$f":"SUM(I130,I132,I134)","v":0},null,{"$f":"SUM(K130,K132,K134)","v":0},null,{"$f":"SUM(M130,M132,M134)","v":0},null,{"$f":"SUM(O130,O132,O134)","v":0},null,{"$f":"SUM(Q130,Q132,Q134)","v":0},null,{"$f":"SUM(S130,S132,S134)","v":0},null,{"$f":"SUM(U130,U132,U134)","v":0}]
[]
[null,null,"2.4  WIDE AREA NETWORK (WAN)"]
[]
[null,null,"2.4.1  WAN Maintenance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G140,I140,K140,M140,O140,Q140,S140)","v":0}]
[]
[null,null,"2.4.2  Other (please specifiy)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G142,I142,K142,M142,O142,Q142,S142)","v":0}]
[]
[null,null,"Total Incremental AMRC OM&A Costs",null,null,null,{"$f":"SUM(G140,G142)","v":0},null,{"$f":"SUM(I140,I142)","v":0},null,{"$f":"SUM(K140,K142)","v":0},null,{"$f":"SUM(M140,M142)","v":0},null,{"$f":"SUM(O140,O142)","v":0},null,{"$f":"SUM(Q140,Q142)","v":0},null,{"$f":"SUM(S140,S142)","v":0},null,{"$f":"SUM(U140,U142)","v":0}]
[]
[null,null,"2.5  OTHER AMI OM&A COSTS RELATED TO MINIMUM FUNCTIONALITY"]
[]
[null,null,"2.5.1  Business Process Redesign",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G148,I148,K148,M148,O148,Q148,S148)","v":0}]
[]
[null,null,"2.5.2  Customer Communication (may include project communication, etc.)",null,null,null,null,null,null,null,null,null,3428,null,null,null,732,null,1013,null,{"$f":"SUM(G150,I150,K150,M150,O150,Q150,S150)","v":5173}]
[]
[null,null,"2.5.3  Program Management",null,null,null,null,null,null,null,null,null,null,null,2147,null,4305,null,{"$f":"1580+622+3770","v":5972},null,{"$f":"SUM(G152,I152,K152,M152,O152,Q152,S152)","v":12424}]
[]
[null,null,"2.5.4  Change Management (may include training, etc.)",null,null,null,null,null,null,null,null,null,null,null,366,null,115,null,null,null,{"$f":"SUM(G154,I154,K154,M154,O154,Q154,S154)","v":481}]
[]
[null,null,"2.5.5  Administration Costs",null,null,null,null,null,null,null,null,null,1210,null,3864,null,4931,null,{"$f":"1060+6454","v":7514},null,{"$f":"SUM(G156,I156,K156,M156,O156,Q156,S156)","v":17519}]
[]
[null,null,"2.5.6  Other AMI Expenses",null,null,null,null,null,null,null,null,null,null,null,1329,null,1788,null,{"$f":"1463+563+209+626+485","v":3346},null,{"$f":"SUM(G158,I158,K158,M158,O158,Q158,S158)","v":6463}]
[null,null,"             (please specify)"]
[null,null,"Total Other AMI OM&A Costs Related to Minimum Functionality",null,null,null,{"$f":"SUM(G158,G156,G154,G152,G150,G148)","v":0},null,{"$f":"SUM(I158,I156,I154,I152,I150,I148)","v":0},null,{"$f":"SUM(K158,K156,K154,K152,K150,K148)","v":0},null,{"$f":"SUM(M158,M156,M154,M152,M150,M148)","v":4638},null,{"$f":"SUM(O158,O156,O154,O152,O150,O148)","v":7706},null,{"$f":"SUM(Q158,Q156,Q154,Q152,Q150,Q148)","v":11871},null,{"$f":"SUM(S158,S156,S154,S152,S150,S148)","v":17845},null,{"$f":"SUM(U154,U156,U158,U152,U150,U148)","v":42060}]
[]
[null,null,"TOTAL OM&A COSTS RELATED TO MINIMUM FUNCTIONALITY",null,null,null,{"$f":"SUM(G118,G126,G136,G144,G160)","v":0},null,{"$f":"SUM(I118,I126,I136,I144,I160)","v":0},null,{"$f":"SUM(K118,K126,K136,K144,K160)","v":0},null,{"$f":"SUM(M118,M126,M136,M144,M160)","v":17394},null,{"$f":"SUM(O118,O126,O136,O144,O160)","v":25930},null,{"$f":"SUM(Q118,Q126,Q136,Q144,Q160)","v":33246},null,{"$f":"SUM(S118,S126,S136,S144,S160)","v":47838},null,{"$f":"SUM(U118,U126,U136,U144,U160)","v":124408}]
[]
[null,null,"2.6  OM&A COSTS RELATED TO BEYOND MINIMUM FUNCTIONALITY",null,null,null,{"$f":"G112","v":"Audited Actual"},null,{"$f":"I112","v":"Audited Actual"},null,{"$f":"K112","v":"Audited Actual"},null,{"$f":"M112","v":"Audited Actual"},null,{"$f":"O112","v":"Audited Actual"},null,{"$f":"Q112","v":"Audited Actual"}]
[null,null,"(Please provide a descriptive title and identify nature of beyond minimum functionality costs)"]
[null,null,"2.6.1  Costs related to technical capabilities in the smart meters or related communications infrastructure that exceed those specified in O.Reg 425/06",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G166,I166,K166,M166,O166,Q166,S166)","v":0}]
[]
[null,null,"2.6.2  Costs for deployment of smart meters to customers other than residential                                                 and small general service ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G168,I168,K168,M168,O168,Q168,S168)","v":0}]
[]
[null,null,"2.6.3  Costs for TOU rate implementation, CIS system upgrades, web presentation,                                     integration with the MDM/R, etc.  ",null,null,null,null,null,null,null,null,null,null,null,34,null,5430,null,116,null,{"$f":"SUM(G170,I170,K170,M170,O170,Q170,S170)","v":5580}]
[]
[null,null,"Total OM&A Costs Beyond Minimum Functionality",null,null,null,{"$f":"SUM(G166,G168,G170)","v":0},null,{"$f":"SUM(I166,I168,I170)","v":0},null,{"$f":"SUM(K166,K168,K170)","v":0},null,{"$f":"SUM(M166,M168,M170)","v":0},null,{"$f":"SUM(O166,O168,O170)","v":34},null,{"$f":"SUM(Q166,Q168,Q170)","v":5430},null,{"$f":"SUM(S166,S168,S170)","v":116},null,{"$f":"SUM(U166,U168,U170)","v":5580}]
[]
[null,null,"Total Smart Meter OM&A Costs",null,null,null,{"$f":"G162+G172","v":0},null,{"$f":"I162+I172","v":0},null,{"$f":"K162+K172","v":0},null,{"$f":"M162+M172","v":17394},null,{"$f":"O162+O172","v":25964},null,{"$f":"Q162+Q172","v":38676},null,{"$f":"S162+S172","v":47954},null,{"$f":"U162+U172","v":129988}]
[]
[]
[null,3,"Aggregate Smart Meter Costs by Category"]
[]
[null,null,"3.1","Capital"]
[]
[null,null,"3.1.1","Smart Meter",null,null,{"$f":"SUMIF($E$42:$E$105,$D181,G$42:G$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D181,I$42:I$105)","v":10190},null,{"$f":"SUMIF($E$42:$E$105,$D181,K$42:K$105)","v":4537},null,{"$f":"SUMIF($E$42:$E$105,$D181,M$42:M$105)","v":206399},null,{"$f":"SUMIF($E$42:$E$105,$D181,O$42:O$105)","v":304611},null,{"$f":"SUMIF($E$42:$E$105,$D181,Q$42:Q$105)","v":202070},null,{"$f":"SUMIF($E$42:$E$105,$D181,S$42:S$105)","v":3438},null,{"$f":"SUM(G181:S181)","v":731245}]
[]
[null,null,"3.1.2","Computer Hardware",null,null,{"$f":"SUMIF($E$42:$E$105,$D183,G$42:G$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D183,I$42:I$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D183,K$42:K$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D183,M$42:M$105)","v":477},null,{"$f":"SUMIF($E$42:$E$105,$D183,O$42:O$105)","v":4686},null,{"$f":"SUMIF($E$42:$E$105,$D183,Q$42:Q$105)","v":585},null,{"$f":"SUMIF($E$42:$E$105,$D183,S$42:S$105)","v":0},null,{"$f":"SUM(G183:S183)","v":5748}]
[]
[null,null,"3.1.3","Computer Software",null,null,{"$f":"SUMIF($E$42:$E$105,$D185,G$42:G$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D185,I$42:I$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D185,K$42:K$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D185,M$42:M$105)","v":518},null,{"$f":"SUMIF($E$42:$E$105,$D185,O$42:O$105)","v":3684},null,{"$f":"SUMIF($E$42:$E$105,$D185,Q$42:Q$105)","v":2819},null,{"$f":"SUMIF($E$42:$E$105,$D185,S$42:S$105)","v":0},null,{"$f":"SUM(G185:S185)","v":7021}]
[]
[null,null,"3.1.4","Tools & Equipment",null,null,{"$f":"SUMIF($E$42:$E$105,$D187,G$42:G$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D187,I$42:I$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D187,K$42:K$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D187,M$42:M$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D187,O$42:O$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D187,Q$42:Q$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D187,S$42:S$105)","v":0},null,{"$f":"SUM(G187:S187)","v":0}]
[]
[null,null,"3.1.5","Other Equipment",null,null,{"$f":"SUMIF($E$42:$E$105,$D189,G$42:G$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D189,I$42:I$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D189,K$42:K$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D189,M$42:M$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D189,O$42:O$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D189,Q$42:Q$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D189,S$42:S$105)","v":0},null,{"$f":"SUM(G189:S189)","v":0}]
[]
[null,null,"3.1.6","Applications Software",null,null,{"$f":"SUMIF($E$42:$E$105,$D191,G$42:G$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D191,I$42:I$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D191,K$42:K$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D191,M$42:M$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D191,O$42:O$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D191,Q$42:Q$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D191,S$42:S$105)","v":0},null,{"$f":"SUM(G191:S191)","v":0}]
[]
[null,null,"3.1.7","Total Capital Costs",null,null,{"$f":"SUM(G181:G191)","v":0},null,{"$f":"SUM(I181:I191)","v":10190},null,{"$f":"SUM(K181:K191)","v":4537},null,{"$f":"SUM(M181:M191)","v":207394},null,{"$f":"SUM(O181:O191)","v":312981},null,{"$f":"SUM(Q181:Q191)","v":205474},null,{"$f":"SUM(S181:S191)","v":3438},null,{"$f":"SUM(U181:U191)","v":744014}]
[null,null,null,null,null,null,{"$f":"IF(G193=G109,\"\",\"Error\")","v":""},null,{"$f":"IF(I193=I109,\"\",\"Error\")","v":""},null,{"$f":"IF(K193=K109,\"\",\"Error\")","v":""},null,{"$f":"IF(M193=M109,\"\",\"Error\")","v":""},null,{"$f":"IF(O193=O109,\"\",\"Error\")","v":""},null,{"$f":"IF(Q193=Q109,\"\",\"Error\")","v":""},null,{"$f":"IF(S193=S109,\"\",\"Error\")","v":""},null,{"$f":"IF(U193=U109,\"\",\"Error\")","v":""}]
[null,null,"3.2","OM&A Costs"]
[]
[null,null,"3.2.1","Total OM&A Costs",null,null,{"$f":"G174","v":0},null,{"$f":"I174","v":0},null,{"$f":"K174","v":0},null,{"$f":"M174","v":17394},null,{"$f":"O174","v":25964},null,{"$f":"Q174","v":38676},null,{"$f":"S174","v":47954},null,{"$f":"U174","v":129988}]

{"sheet":"3. Cost_of_Service_Parameters","index":2,"n_rows":72,"n_cols":19,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,2006,null,2007,null,2008,null,2009,null,2010,null,2011,null,"2012 and later"]
[null,"Cost of Capital"]
[null,null,"Capital Structure1"]
[null,null,null,"Deemed Short-term Debt Capitalization",null,null,null,null,null,null,null,null,null,null,0.04,null,0.04,null,0.04]
[null,null,null,"Deemed Long-term Debt Capitalization",null,null,0.5,null,{"$f":"G23","v":0.5},null,{"$f":"IF(I23=50%,53.3%-K22,IF(I23=55%,57.5%-K22,IF(I23=65%,62.5%-K22,60%-K22)))","v":0.53299999999999992},null,{"$f":"IF(I23=50%,56.7%-M22,60%-M22)","v":0.56700000000000006},null,{"$f":"60%-O22","v":0.55999999999999994},null,{"$f":"O23","v":0.55999999999999994},null,{"$f":"Q23","v":0.55999999999999994}]
[null,null,null,"Deemed Equity Capitalization",null,null,{"$f":"100%-G23-G25","v":0.5},null,{"$f":"100%-I23-I25-I22","v":0.5},null,{"$f":"100%-K23-K25-K22","v":0.46700000000000008},null,{"$f":"100%-M23-M25-M22","v":0.43299999999999994},null,{"$f":"100%-O23-O25-O22","v":0.40000000000000008},null,{"$f":"100%-Q23-Q25-Q22","v":0.40000000000000008},null,{"$f":"100%-S23-S25-S22","v":0.40000000000000008}]
[null,null,null,"Preferred Shares"]
[null,null,"Total",null,null,null,{"$f":"SUM(G22:G25)","v":1},null,{"$f":"SUM(I22:I25)","v":1},null,{"$f":"SUM(K22:K25)","v":1},null,{"$f":"SUM(M22:M25)","v":1},null,{"$f":"SUM(O22:O25)","v":1},null,{"$f":"SUM(Q22:Q25)","v":1},null,{"$f":"SUM(S22:S25)","v":1}]
[]
[null,null,"Cost of Capital Parameters"]
[null,null,null,"Deemed Short-term Debt Rate",null,null,null,null,null,null,null,null,null,null,2.07E-2,null,2.07E-2,null,2.07E-2]
[null,null,null,"Long-term Debt Rate (actual/embedded/deemed)2",null,null,6.0499999999999998E-2,null,{"$f":"G30","v":6.0499999999999998E-2},null,6.0499999999999998E-2,null,6.0499999999999998E-2,null,5.1299999999999998E-2,null,5.1299999999999998E-2,null,5.1299999999999998E-2]
[null,null,null,"Target Return on Equity (ROE)",null,null,0.09,null,{"$f":"G31","v":0.09},null,0.09,null,0.09,null,9.8500000000000004E-2,null,9.8500000000000004E-2,null,9.8500000000000004E-2]
[null,null,null,"Return on Preferred Shares"]
[null,null,"WACC",null,null,null,{"$f":"SUMPRODUCT(G22:G25,G29:G32)","v":7.5249999999999997E-2},null,{"$f":"SUMPRODUCT(I22:I25,I29:I32)","v":7.5249999999999997E-2},null,{"$f":"SUMPRODUCT(K22:K25,K29:K32)","v":7.4276499999999995E-2},null,{"$f":"SUMPRODUCT(M22:M25,M29:M32)","v":7.3273499999999991E-2},null,{"$f":"SUMPRODUCT(O22:O25,O29:O32)","v":6.8956000000000003E-2},null,{"$f":"SUMPRODUCT(Q22:Q25,Q29:Q32)","v":6.8956000000000003E-2},null,{"$f":"SUMPRODUCT(S22:S25,S29:S32)","v":6.8956000000000003E-2}]
[]
[null,"Working Capital Allowance"]
[null,null,"Working Capital Allowance Rate",null,null,null,0.15,null,0.15,null,0.15,null,0.15,null,0.15,null,0.15,null,0.15]
[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.36120000000000002,null,0.36120000000000002,null,0.33500000000000002,null,0.33,null,0.2979,null,0.28249999999999997,null,0.24329999999999999]
[null,null,"Capital Tax (until July 1st, 2010)",null,null,null,3.0000000000000001E-3,null,2.2499999999999998E-3,null,2.2499999999999998E-3,null,2.2499999999999998E-3,null,7.5000000000000002E-4,null,0,null,0]
[]
[null,"Depreciation Rates"]
[null,"(expressed as expected useful life in years)"]
[null,null,"Smart Meters          - years",null,null,null,15,null,15,null,15,null,15,null,15,null,15,null,15]
[null,null,"                              - rate (%)",null,null,null,{"$f":"IF(G45=0,0,1/G45)","v":6.6666666666666666E-2},null,{"$f":"IF(I45=0,0,1/I45)","v":6.6666666666666666E-2},null,{"$f":"IF(K45=0,0,1/K45)","v":6.6666666666666666E-2},null,{"$f":"IF(M45=0,0,1/M45)","v":6.6666666666666666E-2},null,{"$f":"IF(O45=0,0,1/O45)","v":6.6666666666666666E-2},null,{"$f":"IF(Q45=0,0,1/Q45)","v":6.6666666666666666E-2},null,{"$f":"IF(S45=0,0,1/S45)","v":6.6666666666666666E-2}]
[null,null,"Computer Hardware - years",null,null,null,5,null,5,null,5,null,5,null,5,null,5,null,5]
[null,null,"                             - rate (%)",null,null,null,{"$f":"IF(G47=0,0,1/G47)","v":0.2},null,{"$f":"IF(I47=0,0,1/I47)","v":0.2},null,{"$f":"IF(K47=0,0,1/K47)","v":0.2},null,{"$f":"IF(M47=0,0,1/M47)","v":0.2},null,{"$f":"IF(O47=0,0,1/O47)","v":0.2},null,{"$f":"IF(Q47=0,0,1/Q47)","v":0.2},null,{"$f":"IF(S47=0,0,1/S47)","v":0.2}]
[null,null,"Computer Software - years",null,null,null,5,null,5,null,5,null,5,null,5,null,5,null,5]
[null,null,"                             - rate (%)",null,null,null,{"$f":"IF(G49=0,0,1/G49)","v":0.2},null,{"$f":"IF(I49=0,0,1/I49)","v":0.2},null,{"$f":"IF(K49=0,0,1/K49)","v":0.2},null,{"$f":"IF(M49=0,0,1/M49)","v":0.2},null,{"$f":"IF(O49=0,0,1/O49)","v":0.2},null,{"$f":"IF(Q49=0,0,1/Q49)","v":0.2},null,{"$f":"IF(S49=0,0,1/S49)","v":0.2}]
[null,null,"Tools & Equipment - years",null,null,null,10,null,10,null,10,null,10,null,10,null,10,null,10]
[null,null,"                             - rate (%)",null,null,null,{"$f":"IF(G51=0,0,1/G51)","v":0.1},null,{"$f":"IF(I51=0,0,1/I51)","v":0.1},null,{"$f":"IF(K51=0,0,1/K51)","v":0.1},null,{"$f":"IF(M51=0,0,1/M51)","v":0.1},null,{"$f":"IF(O51=0,0,1/O51)","v":0.1},null,{"$f":"IF(Q51=0,0,1/Q51)","v":0.1},null,{"$f":"IF(S51=0,0,1/S51)","v":0.1}]
[null,null,"Other Equipment    - years",null,null,null,10,null,10,null,10,null,10,null,10,null,10,null,10]
[null,null,"                             - rate (%)",null,null,null,{"$f":"IF(G53=0,0,1/G53)","v":0.1},null,{"$f":"IF(I53=0,0,1/I53)","v":0.1},null,{"$f":"IF(K53=0,0,1/K53)","v":0.1},null,{"$f":"IF(M53=0,0,1/M53)","v":0.1},null,{"$f":"IF(O53=0,0,1/O53)","v":0.1},null,{"$f":"IF(Q53=0,0,1/Q53)","v":0.1},null,{"$f":"IF(S53=0,0,1/S53)","v":0.1}]
[]
[null,"CCA Rates"]
[null,null,"Smart Meters - CCA Class",null,null,null,47,null,47,null,47,null,47,null,47,null,47,null,47]
[null,null,"Smart Meters - CCA Rate",null,null,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08]
[]
[null,null,"Computer Equipment - CCA Class",null,null,null,45,null,45,null,50,null,52,null,52,null,50,null,50]
[null,null,"Computer Equipment - CCA Rate",null,null,null,0.45,null,0.45,null,0.55000000000000004,null,1,null,1,null,0.55000000000000004,null,0.55000000000000004]
[]
[null,null,"General Equipment - CCA Class",null,null,null,8,null,8,null,8,null,8,null,8,null,8,null,8]
[null,null,"General Equipment - CCA Rate",null,null,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2]
[]
[null,null,"Applications Software - CCA Class",null,null,null,45,null,45,null,50,null,52,null,52,null,50,null,50]
[null,null,"Applications Software - CCA Rate",null,null,null,0.45,null,0.45,null,0.55000000000000004,null,1,null,1,null,0.55000000000000004,null,0.55000000000000004]
[]
[null,"Assumptions"]
[null,1,"Planned smart meter installations occur evenly throughout the year."]
[null,2,"Fiscal calendar year (January 1 to December 31) used."]
[null,3,"Amortization is done on a striaght line basis and has the \"half-year\" rule applied."]

{"sheet":"4. SM_Assets_and_Rate_Base","index":3,"n_rows":112,"n_cols":19,"rows_kept":112,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,2006,null,2007,null,2008,null,2009,null,2010,null,2011,null,"2012 and later"]
[null,"Net Fixed Assets - Smart Meters"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"G25","v":0},null,{"$f":"I25","v":10190},null,{"$f":"K25","v":14727},null,{"$f":"M25","v":221126},null,{"$f":"O25","v":525737},null,{"$f":"Q25","v":727807}]
[null,null,null,"Capital Additions during year (from Smart Meter Costs)",null,null,{"$f":"'2. Smart_Meter_Costs'!G181","v":0},null,{"$f":"'2. Smart_Meter_Costs'!I181","v":10190},null,{"$f":"'2. Smart_Meter_Costs'!K181","v":4537},null,{"$f":"'2. Smart_Meter_Costs'!M181","v":206399},null,{"$f":"'2. Smart_Meter_Costs'!O181","v":304611},null,{"$f":"'2. Smart_Meter_Costs'!Q181","v":202070},null,{"$f":"'2. Smart_Meter_Costs'!S181","v":3438}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G22+G23-G24","v":0},null,{"$f":"I22+I23-I24","v":10190},null,{"$f":"K22+K23-K24","v":14727},null,{"$f":"M22+M23-M24","v":221126},null,{"$f":"O22+O23-O24","v":525737},null,{"$f":"Q22+Q23-Q24","v":727807},null,{"$f":"S22+S23-S24","v":731245}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"G31","v":0},null,{"$f":"I31","v":-339.66666666666669},null,{"$f":"K31","v":-1170.2333333333333},null,{"$f":"M31","v":-9032},null,{"$f":"O31","v":-33927.433333333334},null,{"$f":"Q31","v":-75712.233333333337}]
[null,null,null,"Amortization expense during year",null,null,{"$f":"IF(ISERROR(-G23/('3. Cost_of_Service_Parameters'!G45*2)), 0, -G23/('3. Cost_of_Service_Parameters'!G45*2))","v":0},null,{"$f":"IF(ISERROR(-(I23/('3. Cost_of_Service_Parameters'!I45*2)+MIN((I22/'3. Cost_of_Service_Parameters'!I45),(I22+I28)))), 0, -(I23/('3. Cost_of_Service_Parameters'!I45*2)+MIN((I22/'3. Cost_of_Service_Parameters'!I45),(I22+I28))))","v":-339.66666666666669},null,{"$f":"IF(ISERROR(-(K23/('3. Cost_of_Service_Parameters'!K45*2)+MIN((K22/'3. Cost_of_Service_Parameters'!K45),(K22+K28)))), 0, -(K23/('3. Cost_of_Service_Parameters'!K45*2)+MIN((K22/'3. Cost_of_Service_Parameters'!K45),(K22+K28))))","v":-830.56666666666672},null,{"$f":"IF(ISERROR(-(M23/('3. Cost_of_Service_Parameters'!M45*2)+MIN((M22/'3. Cost_of_Service_Parameters'!M45),(M22+M28)))), 0,-(M23/('3. Cost_of_Service_Parameters'!M45*2)+MIN((M22/'3. Cost_of_Service_Parameters'!M45),(M22+M28))))","v":-7861.7666666666664},null,{"$f":"IF(ISERROR(-(O23/('3. Cost_of_Service_Parameters'!O45*2)+MIN((O22/'3. Cost_of_Service_Parameters'!O45),(O22+O28)))), 0, -(O23/('3. Cost_of_Service_Parameters'!O45*2)+MIN((O22/'3. Cost_of_Service_Parameters'!O45),(O22+O28))))","v":-24895.433333333334},null,{"$f":"IF(ISERROR(-(Q23/('3. Cost_of_Service_Parameters'!Q45*2)+MIN((Q22/'3. Cost_of_Service_Parameters'!Q45),(Q22+Q28)))), 0, -(Q23/('3. Cost_of_Service_Parameters'!Q45*2)+MIN((Q22/'3. Cost_of_Service_Parameters'!Q45),(Q22+Q28))))","v":-41784.799999999996},null,{"$f":"IF(ISERROR(-(S23/('3. Cost_of_Service_Parameters'!S45*2)+MIN((S22/'3. Cost_of_Service_Parameters'!S45),(S22+S28)))), 0, -(S23/('3. Cost_of_Service_Parameters'!S45*2)+MIN((S22/'3. Cost_of_Service_Parameters'!S45),(S22+S28))))","v":-48635.066666666666}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G28+G29-G30","v":0},null,{"$f":"I28+I29-I30","v":-339.66666666666669},null,{"$f":"K28+K29-K30","v":-1170.2333333333333},null,{"$f":"M28+M29-M30","v":-9032},null,{"$f":"O28+O29-O30","v":-33927.433333333334},null,{"$f":"Q28+Q29-Q30","v":-75712.233333333337},null,{"$f":"S28+S29-S30","v":-124347.3}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"G22+G28","v":0},null,{"$f":"G35","v":0},null,{"$f":"I35","v":9850.3333333333339},null,{"$f":"K35","v":13556.766666666666},null,{"$f":"M35","v":212094},null,{"$f":"O35","v":491809.56666666665},null,{"$f":"Q35","v":652094.7666666666}]
[null,null,null,"Closing Balance",null,null,{"$f":"G25+G31","v":0},null,{"$f":"I25+I31","v":9850.3333333333339},null,{"$f":"K25+K31","v":13556.766666666666},null,{"$f":"M25+M31","v":212094},null,{"$f":"O25+O31","v":491809.56666666665},null,{"$f":"Q25+Q31","v":652094.7666666666},null,{"$f":"S25+S31","v":606897.69999999995}]
[null,null,null,"Average Net Book Value",null,null,{"$f":"AVERAGE(G34:G35)","v":0},null,{"$f":"AVERAGE(I34:I35)","v":4925.166666666667},null,{"$f":"AVERAGE(K34:K35)","v":11703.55},null,{"$f":"AVERAGE(M34:M35)","v":112825.38333333333},null,{"$f":"AVERAGE(O34:O35)","v":351951.78333333333},null,{"$f":"AVERAGE(Q34:Q35)","v":571952.16666666663},null,{"$f":"AVERAGE(S34:S35)","v":629496.23333333328}]
[]
[null,"Net Fixed Assets - Computer Hardware"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"G44","v":0},null,{"$f":"I44","v":0},null,{"$f":"K44","v":0},null,{"$f":"M44","v":477},null,{"$f":"O44","v":5163},null,{"$f":"Q44","v":5748}]
[null,null,null,"Capital Additions during year (from Smart Meter Costs)",null,null,{"$f":"'2. Smart_Meter_Costs'!G183","v":0},null,{"$f":"'2. Smart_Meter_Costs'!I183","v":0},null,{"$f":"'2. Smart_Meter_Costs'!K183","v":0},null,{"$f":"'2. Smart_Meter_Costs'!M183","v":477},null,{"$f":"'2. Smart_Meter_Costs'!O183","v":4686},null,{"$f":"'2. Smart_Meter_Costs'!Q183","v":585},null,{"$f":"'2. Smart_Meter_Costs'!S183","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G41+G42-G43","v":0},null,{"$f":"I41+I42-I43","v":0},null,{"$f":"K41+K42-K43","v":0},null,{"$f":"M41+M42-M43","v":477},null,{"$f":"O41+O42-O43","v":5163},null,{"$f":"Q41+Q42-Q43","v":5748},null,{"$f":"S41+S42-S43","v":5748}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,0,null,{"$f":"G50","v":0},null,{"$f":"I50","v":0},null,{"$f":"K50","v":0},null,{"$f":"M50","v":-47.7},null,{"$f":"O50","v":-611.70000000000005},null,{"$f":"Q50","v":-1702.8}]
[null,null,null,"Amortization expense during year",null,null,{"$f":"IF(ISERROR(-G42/('3. Cost_of_Service_Parameters'!G47*2)), 0, -G42/('3. Cost_of_Service_Parameters'!G47*2))","v":0},null,{"$f":"IF(ISERROR(-(I42/('3. Cost_of_Service_Parameters'!I47*2)+MIN((I41/'3. Cost_of_Service_Parameters'!I47),(I41+I47)))), 0, -(I42/('3. Cost_of_Service_Parameters'!I47*2)+MIN((I41/'3. Cost_of_Service_Parameters'!I47),(I41+I47))))","v":0},null,{"$f":"IF(ISERROR(-(K42/('3. Cost_of_Service_Parameters'!K47*2)+MIN((K41/'3. Cost_of_Service_Parameters'!K47),(K41+K47)))), 0, -(K42/('3. Cost_of_Service_Parameters'!K47*2)+MIN((K41/'3. Cost_of_Service_Parameters'!K47),(K41+K47))))","v":0},null,{"$f":"IF(ISERROR(-(M42/('3. Cost_of_Service_Parameters'!M47*2)+MIN((M41/'3. Cost_of_Service_Parameters'!M47),(M41+M47)))), 0,-(M42/('3. Cost_of_Service_Parameters'!M47*2)+MIN((M41/'3. Cost_of_Service_Parameters'!M47),(M41+M47))))","v":-47.7},null,{"$f":"IF(ISERROR(-(O42/('3. Cost_of_Service_Parameters'!O47*2)+MIN((O41/'3. Cost_of_Service_Parameters'!O47),(O41+O47)))), 0, -(O42/('3. Cost_of_Service_Parameters'!O47*2)+MIN((O41/'3. Cost_of_Service_Parameters'!O47),(O41+O47))))","v":-564},null,{"$f":"IF(ISERROR(-(Q42/('3. Cost_of_Service_Parameters'!Q47*2)+MIN((Q41/'3. Cost_of_Service_Parameters'!Q47),(Q41+Q47)))), 0, -(Q42/('3. Cost_of_Service_Parameters'!Q47*2)+MIN((Q41/'3. Cost_of_Service_Parameters'!Q47),(Q41+Q47))))","v":-1091.0999999999999},null,{"$f":"IF(ISERROR(-(S42/('3. Cost_of_Service_Parameters'!S47*2)+MIN((S41/'3. Cost_of_Service_Parameters'!S47),(S41+S47)))), 0, -(S42/('3. Cost_of_Service_Parameters'!S47*2)+MIN((S41/'3. Cost_of_Service_Parameters'!S47),(S41+S47))))","v":-1149.5999999999999}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G47+G48-G49","v":0},null,{"$f":"I47+I48-I49","v":0},null,{"$f":"K47+K48-K49","v":0},null,{"$f":"M47+M48-M49","v":-47.7},null,{"$f":"O47+O48-O49","v":-611.70000000000005},null,{"$f":"Q47+Q48-Q49","v":-1702.8},null,{"$f":"S47+S48-S49","v":-2852.3999999999996}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"G41+G47","v":0},null,{"$f":"G54","v":0},null,{"$f":"I54","v":0},null,{"$f":"K54","v":0},null,{"$f":"M54","v":429.3},null,{"$f":"O54","v":4551.3},null,{"$f":"Q54","v":4045.2}]
[null,null,null,"Closing Balance",null,null,{"$f":"G44+G50","v":0},null,{"$f":"I44+I50","v":0},null,{"$f":"K44+K50","v":0},null,{"$f":"M44+M50","v":429.3},null,{"$f":"O44+O50","v":4551.3},null,{"$f":"Q44+Q50","v":4045.2},null,{"$f":"S44+S50","v":2895.6000000000004}]
[null,null,null,"Average Net Book Value",null,null,{"$f":"AVERAGE(G53:G54)","v":0},null,{"$f":"AVERAGE(I53:I54)","v":0},null,{"$f":"AVERAGE(K53:K54)","v":0},null,{"$f":"AVERAGE(M53:M54)","v":214.65},null,{"$f":"AVERAGE(O53:O54)","v":2490.3000000000002},null,{"$f":"AVERAGE(Q53:Q54)","v":4298.25},null,{"$f":"AVERAGE(S53:S54)","v":3470.4}]
[]
[null,"Net Fixed Assets - Computer Software (including Applications Software)"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"G63","v":0},null,{"$f":"I63","v":0},null,{"$f":"K63","v":0},null,{"$f":"M63","v":518},null,{"$f":"O63","v":4202},null,{"$f":"Q63","v":7021}]
[null,null,null,"Capital Additions during year (from Smart Meter Costs)",null,null,{"$f":"'2. Smart_Meter_Costs'!G185+'2. Smart_Meter_Costs'!G191","v":0},null,{"$f":"'2. Smart_Meter_Costs'!I185+'2. Smart_Meter_Costs'!I191","v":0},null,{"$f":"'2. Smart_Meter_Costs'!K185+'2. Smart_Meter_Costs'!K191","v":0},null,{"$f":"'2. Smart_Meter_Costs'!M185+'2. Smart_Meter_Costs'!M191","v":518},null,{"$f":"'2. Smart_Meter_Costs'!O185+'2. Smart_Meter_Costs'!O191","v":3684},null,{"$f":"'2. Smart_Meter_Costs'!Q185+'2. Smart_Meter_Costs'!Q191","v":2819},null,{"$f":"'2. Smart_Meter_Costs'!S185+'2. Smart_Meter_Costs'!S191","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G60+G61-G62","v":0},null,{"$f":"I60+I61-I62","v":0},null,{"$f":"K60+K61-K62","v":0},null,{"$f":"M60+M61-M62","v":518},null,{"$f":"O60+O61-O62","v":4202},null,{"$f":"Q60+Q61-Q62","v":7021},null,{"$f":"S60+S61-S62","v":7021}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,0,null,{"$f":"G69","v":0},null,{"$f":"I69","v":0},null,{"$f":"K69","v":0},null,{"$f":"M69","v":-51.8},null,{"$f":"O69","v":-523.79999999999995},null,{"$f":"Q69","v":-1646.1}]
[null,null,null,"Amortization expense during year",null,null,{"$f":"IF(ISERROR(-G61/('3. Cost_of_Service_Parameters'!G49*2)), 0, -G61/('3. Cost_of_Service_Parameters'!G49*2))","v":0},null,{"$f":"IF(ISERROR(-(I61/('3. Cost_of_Service_Parameters'!I49*2)+MIN((I60/'3. Cost_of_Service_Parameters'!I49),(I60+I66)))), 0, -(I61/('3. Cost_of_Service_Parameters'!I49*2)+MIN((I60/'3. Cost_of_Service_Parameters'!I49),(I60+I66))))","v":0},null,{"$f":"IF(ISERROR(-(K61/('3. Cost_of_Service_Parameters'!K49*2)+MIN((K60/'3. Cost_of_Service_Parameters'!K49),(K60+K66)))), 0, -(K61/('3. Cost_of_Service_Parameters'!K49*2)+MIN((K60/'3. Cost_of_Service_Parameters'!K49),(K60+K66))))","v":0},null,{"$f":"IF(ISERROR(-(M61/('3. Cost_of_Service_Parameters'!M49*2)+MIN((M60/'3. Cost_of_Service_Parameters'!M49),(M60+M66)))), 0,-(M61/('3. Cost_of_Service_Parameters'!M49*2)+MIN((M60/'3. Cost_of_Service_Parameters'!M49),(M60+M66))))","v":-51.8},null,{"$f":"IF(ISERROR(-(O61/('3. Cost_of_Service_Parameters'!O49*2)+MIN((O60/'3. Cost_of_Service_Parameters'!O49),(O60+O66)))), 0, -(O61/('3. Cost_of_Service_Parameters'!O49*2)+MIN((O60/'3. Cost_of_Service_Parameters'!O49),(O60+O66))))","v":-472},null,{"$f":"IF(ISERROR(-(Q61/('3. Cost_of_Service_Parameters'!Q49*2)+MIN((Q60/'3. Cost_of_Service_Parameters'!Q49),(Q60+Q66)))), 0, -(Q61/('3. Cost_of_Service_Parameters'!Q49*2)+MIN((Q60/'3. Cost_of_Service_Parameters'!Q49),(Q60+Q66))))","v":-1122.3},null,{"$f":"IF(ISERROR(-(S61/('3. Cost_of_Service_Parameters'!S49*2)+MIN((S60/'3. Cost_of_Service_Parameters'!S49),(S60+S66)))), 0, -(S61/('3. Cost_of_Service_Parameters'!S49*2)+MIN((S60/'3. Cost_of_Service_Parameters'!S49),(S60+S66))))","v":-1404.2}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G66+G67-G68","v":0},null,{"$f":"I66+I67-I68","v":0},null,{"$f":"K66+K67-K68","v":0},null,{"$f":"M66+M67-M68","v":-51.8},null,{"$f":"O66+O67-O68","v":-523.79999999999995},null,{"$f":"Q66+Q67-Q68","v":-1646.1},null,{"$f":"S66+S67-S68","v":-3050.3}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"G60+G66","v":0},null,{"$f":"G73","v":0},null,{"$f":"I73","v":0},null,{"$f":"K73","v":0},null,{"$f":"M73","v":466.2},null,{"$f":"O73","v":3678.2},null,{"$f":"Q73","v":5374.9}]
[null,null,null,"Closing Balance",null,null,{"$f":"G63+G69","v":0},null,{"$f":"I63+I69","v":0},null,{"$f":"K63+K69","v":0},null,{"$f":"M63+M69","v":466.2},null,{"$f":"O63+O69","v":3678.2},null,{"$f":"Q63+Q69","v":5374.9},null,{"$f":"S63+S69","v":3970.7}]
[null,null,null,"Average Net Book Value",null,null,{"$f":"AVERAGE(G72:G73)","v":0},null,{"$f":"AVERAGE(I72:I73)","v":0},null,{"$f":"AVERAGE(K72:K73)","v":0},null,{"$f":"AVERAGE(M72:M73)","v":233.1},null,{"$f":"AVERAGE(O72:O73)","v":2072.1999999999998},null,{"$f":"AVERAGE(Q72:Q73)","v":4526.5499999999993},null,{"$f":"AVERAGE(S72:S73)","v":4672.7999999999993}]
[]
[null,"Net Fixed Assets - Tools and Equipment"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"G82","v":0},null,{"$f":"I82","v":0},null,{"$f":"K82","v":0},null,{"$f":"M82","v":0},null,{"$f":"O82","v":0},null,{"$f":"Q82","v":0}]
[null,null,null,"Capital Additions during year (from Smart Meter Costs)",null,null,{"$f":"'2. Smart_Meter_Costs'!G187","v":0},null,{"$f":"'2. Smart_Meter_Costs'!I187","v":0},null,{"$f":"'2. Smart_Meter_Costs'!K187","v":0},null,{"$f":"'2. Smart_Meter_Costs'!M187","v":0},null,{"$f":"'2. Smart_Meter_Costs'!O187","v":0},null,{"$f":"'2. Smart_Meter_Costs'!Q187","v":0},null,{"$f":"'2. Smart_Meter_Costs'!S187","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G79+G80-G81","v":0},null,{"$f":"I79+I80-I81","v":0},null,{"$f":"K79+K80-K81","v":0},null,{"$f":"M79+M80-M81","v":0},null,{"$f":"O79+O80-O81","v":0},null,{"$f":"Q79+Q80-Q81","v":0},null,{"$f":"S79+S80-S81","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,0,null,{"$f":"G88","v":0},null,{"$f":"I88","v":0},null,{"$f":"K88","v":0},null,{"$f":"M88","v":0},null,{"$f":"O88","v":0},null,{"$f":"Q88","v":0}]
[null,null,null,"Amortization expense during year",null,null,{"$f":"IF(ISERROR(-G80/('3. Cost_of_Service_Parameters'!G51*2)), 0, -G80/('3. Cost_of_Service_Parameters'!G51*2))","v":0},null,{"$f":"IF(ISERROR(-(I80/('3. Cost_of_Service_Parameters'!I51*2)+MIN((I79/'3. Cost_of_Service_Parameters'!I51),(I79+I85)))), 0, -(I80/('3. Cost_of_Service_Parameters'!I51*2)+MIN((I79/'3. Cost_of_Service_Parameters'!I51),(I79+I85))))","v":0},null,{"$f":"IF(ISERROR(-(K80/('3. Cost_of_Service_Parameters'!K51*2)+MIN((K79/'3. Cost_of_Service_Parameters'!K51),(K79+K85)))), 0, -(K80/('3. Cost_of_Service_Parameters'!K51*2)+MIN((K79/'3. Cost_of_Service_Parameters'!K51),(K79+K85))))","v":0},null,{"$f":"IF(ISERROR(-(M80/('3. Cost_of_Service_Parameters'!M51*2)+MIN((M79/'3. Cost_of_Service_Parameters'!M51),(M79+M85)))), 0,-(M80/('3. Cost_of_Service_Parameters'!M51*2)+MIN((M79/'3. Cost_of_Service_Parameters'!M51),(M79+M85))))","v":0},null,{"$f":"IF(ISERROR(-(O80/('3. Cost_of_Service_Parameters'!O51*2)+MIN((O79/'3. Cost_of_Service_Parameters'!O51),(O79+O85)))), 0, -(O80/('3. Cost_of_Service_Parameters'!O51*2)+MIN((O79/'3. Cost_of_Service_Parameters'!O51),(O79+O85))))","v":0},null,{"$f":"IF(ISERROR(-(Q80/('3. Cost_of_Service_Parameters'!Q51*2)+MIN((Q79/'3. Cost_of_Service_Parameters'!Q51),(Q79+Q85)))), 0, -(Q80/('3. Cost_of_Service_Parameters'!Q51*2)+MIN((Q79/'3. Cost_of_Service_Parameters'!Q51),(Q79+Q85))))","v":0},null,{"$f":"IF(ISERROR(-(S80/('3. Cost_of_Service_Parameters'!S51*2)+MIN((S79/'3. Cost_of_Service_Parameters'!S51),(S79+S85)))), 0, -(S80/('3. Cost_of_Service_Parameters'!S51*2)+MIN((S79/'3. Cost_of_Service_Parameters'!S51),(S79+S85))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G85+G86-G87","v":0},null,{"$f":"I85+I86-I87","v":0},null,{"$f":"K85+K86-K87","v":0},null,{"$f":"M85+M86-M87","v":0},null,{"$f":"O85+O86-O87","v":0},null,{"$f":"Q85+Q86-Q87","v":0},null,{"$f":"S85+S86-S87","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"G79+G85","v":0},null,{"$f":"G92","v":0},null,{"$f":"I92","v":0},null,{"$f":"K92","v":0},null,{"$f":"M92","v":0},null,{"$f":"O92","v":0},null,{"$f":"Q92","v":0}]
[null,null,null,"Closing Balance",null,null,{"$f":"G82+G88","v":0},null,{"$f":"I82+I88","v":0},null,{"$f":"K82+K88","v":0},null,{"$f":"M82+M88","v":0},null,{"$f":"O82+O88","v":0},null,{"$f":"Q82+Q88","v":0},null,{"$f":"S82+S88","v":0}]
[null,null,null,"Average Net Book Value",null,null,{"$f":"AVERAGE(G91:G92)","v":0},null,{"$f":"AVERAGE(I91:I92)","v":0},null,{"$f":"AVERAGE(K91:K92)","v":0},null,{"$f":"AVERAGE(M91:M92)","v":0},null,{"$f":"AVERAGE(O91:O92)","v":0},null,{"$f":"AVERAGE(Q91:Q92)","v":0},null,{"$f":"AVERAGE(S91:S92)","v":0}]
[]
[null,"Net Fixed Assets - Other Equipment"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"G101","v":0},null,{"$f":"I101","v":0},null,{"$f":"K101","v":0},null,{"$f":"M101","v":0},null,{"$f":"O101","v":0},null,{"$f":"Q101","v":0}]
[null,null,null,"Capital Additions during year (from Smart Meter Costs)",null,null,{"$f":"'2. Smart_Meter_Costs'!G189","v":0},null,{"$f":"'2. Smart_Meter_Costs'!I189","v":0},null,{"$f":"'2. Smart_Meter_Costs'!K189","v":0},null,{"$f":"'2. Smart_Meter_Costs'!M189","v":0},null,{"$f":"'2. Smart_Meter_Costs'!O189","v":0},null,{"$f":"'2. Smart_Meter_Costs'!Q189","v":0},null,{"$f":"'2. Smart_Meter_Costs'!S189","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G98+G99-G100","v":0},null,{"$f":"I98+I99-I100","v":0},null,{"$f":"K98+K99-K100","v":0},null,{"$f":"M98+M99-M100","v":0},null,{"$f":"O98+O99-O100","v":0},null,{"$f":"Q98+Q99-Q100","v":0},null,{"$f":"S98+S99-S100","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,0,null,{"$f":"G107","v":0},null,{"$f":"I107","v":0},null,{"$f":"K107","v":0},null,{"$f":"M107","v":0},null,{"$f":"O107","v":0},null,{"$f":"Q107","v":0}]
[null,null,null,"Amortization expense during year",null,null,{"$f":"IF(ISERROR(-G99/('3. Cost_of_Service_Parameters'!G53*2)), 0, -G99/('3. Cost_of_Service_Parameters'!G53*2))","v":0},null,{"$f":"IF(ISERROR(-(I99/('3. Cost_of_Service_Parameters'!I53*2)+MIN((I98/'3. Cost_of_Service_Parameters'!I53),(I98+I104)))), 0, -(I99/('3. Cost_of_Service_Parameters'!I53*2)+MIN((I98/'3. Cost_of_Service_Parameters'!I53),(I98+I104))))","v":0},null,{"$f":"IF(ISERROR(-(K99/('3. Cost_of_Service_Parameters'!K53*2)+MIN((K98/'3. Cost_of_Service_Parameters'!K53),(K98+K104)))), 0, -(K99/('3. Cost_of_Service_Parameters'!K53*2)+MIN((K98/'3. Cost_of_Service_Parameters'!K53),(K98+K104))))","v":0},null,{"$f":"IF(ISERROR(-(M99/('3. Cost_of_Service_Parameters'!M53*2)+MIN((M98/'3. Cost_of_Service_Parameters'!M53),(M98+M104)))), 0,-(M99/('3. Cost_of_Service_Parameters'!M53*2)+MIN((M98/'3. Cost_of_Service_Parameters'!M53),(M98+M104))))","v":0},null,{"$f":"IF(ISERROR(-(O99/('3. Cost_of_Service_Parameters'!O53*2)+MIN((O98/'3. Cost_of_Service_Parameters'!O53),(O98+O104)))), 0, -(O99/('3. Cost_of_Service_Parameters'!O53*2)+MIN((O98/'3. Cost_of_Service_Parameters'!O53),(O98+O104))))","v":0},null,{"$f":"IF(ISERROR(-(Q99/('3. Cost_of_Service_Parameters'!Q53*2)+MIN((Q98/'3. Cost_of_Service_Parameters'!Q53),(Q98+Q104)))), 0, -(Q99/('3. Cost_of_Service_Parameters'!Q53*2)+MIN((Q98/'3. Cost_of_Service_Parameters'!Q53),(Q98+Q104))))","v":0},null,{"$f":"IF(ISERROR(-(S99/('3. Cost_of_Service_Parameters'!S53*2)+MIN((S98/'3. Cost_of_Service_Parameters'!S53),(S98+S104)))), 0, -(S99/('3. Cost_of_Service_Parameters'!S53*2)+MIN((S98/'3. Cost_of_Service_Parameters'!S53),(S98+S104))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G104+G105-G106","v":0},null,{"$f":"I104+I105-I106","v":0},null,{"$f":"K104+K105-K106","v":0},null,{"$f":"M104+M105-M106","v":0},null,{"$f":"O104+O105-O106","v":0},null,{"$f":"Q104+Q105-Q106","v":0},null,{"$f":"S104+S105-S106","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"G98+G104","v":0},null,{"$f":"G111","v":0},null,{"$f":"I111","v":0},null,{"$f":"K111","v":0},null,{"$f":"M111","v":0},null,{"$f":"O111","v":0},null,{"$f":"Q111","v":0}]
[null,null,null,"Closing Balance",null,null,{"$f":"G101+G107","v":0},null,{"$f":"I101+I107","v":0},null,{"$f":"K101+K107","v":0},null,{"$f":"M101+M107","v":0},null,{"$f":"O101+O107","v":0},null,{"$f":"Q101+Q107","v":0},null,{"$f":"S101+S107","v":0}]
[null,null,null,"Average Net Book Value",null,null,{"$f":"AVERAGE(G110:G111)","v":0},null,{"$f":"AVERAGE(I110:I111)","v":0},null,{"$f":"AVERAGE(K110:K111)","v":0},null,{"$f":"AVERAGE(M110:M111)","v":0},null,{"$f":"AVERAGE(O110:O111)","v":0},null,{"$f":"AVERAGE(Q110:Q111)","v":0},null,{"$f":"AVERAGE(S110:S111)","v":0}]

{"sheet":"5. SM_Rev_Reqt","index":4,"n_rows":70,"n_cols":19,"rows_kept":70,"cut":false,"hidden":false,"merged":[[22,2,22,4],[23,2,23,4],[24,2,24,4],[19,2,19,4],[20,2,20,4],[21,2,21,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,2006,null,2007,null,2008,null,2009,null,2010,null,2011,null,"2012 and Later"]
[null,"Average Net Fixed Asset Values (from Sheet 4)"]
[null,null,"Smart Meters",null,null,null,{"$f":"'4. SM_Assets_and_Rate_Base'!G36","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!I36","v":4925.166666666667},null,{"$f":"'4. SM_Assets_and_Rate_Base'!K36","v":11703.55},null,{"$f":"'4. SM_Assets_and_Rate_Base'!M36","v":112825.38333333333},null,{"$f":"'4. SM_Assets_and_Rate_Base'!O36","v":351951.78333333333},null,{"$f":"'4. SM_Assets_and_Rate_Base'!Q36","v":571952.16666666663},null,{"$f":"'4. SM_Assets_and_Rate_Base'!S36","v":629496.23333333328}]
[null,null,"Computer Hardware",null,null,null,{"$f":"'4. SM_Assets_and_Rate_Base'!G55","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!I55","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!K55","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!M55","v":214.65},null,{"$f":"'4. SM_Assets_and_Rate_Base'!O55","v":2490.3000000000002},null,{"$f":"'4. SM_Assets_and_Rate_Base'!Q55","v":4298.25},null,{"$f":"'4. SM_Assets_and_Rate_Base'!S55","v":3470.4}]
[null,null,"Computer Software",null,null,null,{"$f":"'4. SM_Assets_and_Rate_Base'!G74","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!I74","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!K74","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!M74","v":233.1},null,{"$f":"'4. SM_Assets_and_Rate_Base'!O74","v":2072.1999999999998},null,{"$f":"'4. SM_Assets_and_Rate_Base'!Q74","v":4526.5499999999993},null,{"$f":"'4. SM_Assets_and_Rate_Base'!S74","v":4672.7999999999993}]
[null,null,"Tools & Equipment",null,null,null,{"$f":"'4. SM_Assets_and_Rate_Base'!G93","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!I93","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!K93","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!M93","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!O93","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!Q93","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!S93","v":0}]
[null,null,"Other Equipment",null,null,null,{"$f":"'4. SM_Assets_and_Rate_Base'!G112","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!I112","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!K112","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!M112","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!O112","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!Q112","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!S112","v":0}]
[null,null,"Total Net Fixed Assets",null,null,null,{"$f":"SUM(G20:G24)","v":0},null,{"$f":"SUM(I20:I24)","v":4925.166666666667},null,{"$f":"SUM(K20:K24)","v":11703.55},null,{"$f":"SUM(M20:M24)","v":113273.13333333333},null,{"$f":"SUM(O20:O24)","v":356514.28333333333},null,{"$f":"SUM(Q20:Q24)","v":580776.96666666667},null,{"$f":"SUM(S20:S24)","v":637639.43333333335}]
[]
[null,"Working Capital"]
[null,null,"Operating Expenses (from Sheet 2)",null,null,null,{"$f":"'2. Smart_Meter_Costs'!G174","v":0},null,{"$f":"'2. Smart_Meter_Costs'!I174","v":0},null,{"$f":"'2. Smart_Meter_Costs'!K174","v":0},null,{"$f":"'2. Smart_Meter_Costs'!M174","v":17394},null,{"$f":"'2. Smart_Meter_Costs'!O174","v":25964},null,{"$f":"'2. Smart_Meter_Costs'!Q174","v":38676},null,{"$f":"'2. Smart_Meter_Costs'!S174","v":47954}]
[null,null,"Working Capital Factor (from Sheet 3)",null,null,null,{"$f":"'3. Cost_of_Service_Parameters'!G36","v":0.15},null,{"$f":"'3. Cost_of_Service_Parameters'!I36","v":0.15},null,{"$f":"'3. Cost_of_Service_Parameters'!K36","v":0.15},null,{"$f":"'3. Cost_of_Service_Parameters'!M36","v":0.15},null,{"$f":"'3. Cost_of_Service_Parameters'!O36","v":0.15},null,{"$f":"'3. Cost_of_Service_Parameters'!Q36","v":0.15},null,{"$f":"'3. Cost_of_Service_Parameters'!S36","v":0.15}]
[null,null,"Working Capital Allowance",null,null,null,{"$f":"G28*G29","v":0},null,{"$f":"I28*I29","v":0},null,{"$f":"K28*K29","v":0},null,{"$f":"M28*M29","v":2609.1},null,{"$f":"O28*O29","v":3894.6},null,{"$f":"Q28*Q29","v":5801.4},null,{"$f":"S28*S29","v":7193.0999999999995}]
[]
[null,"Incremental Smart Meter Rate Base",null,null,null,null,{"$f":"G25+G30","v":0},null,{"$f":"I25+I30","v":4925.166666666667},null,{"$f":"K25+K30","v":11703.55},null,{"$f":"M25+M30","v":115882.23333333334},null,{"$f":"O25+O30","v":360408.8833333333},null,{"$f":"Q25+Q30","v":586578.3666666667},null,{"$f":"S25+S30","v":644832.53333333333}]
[]
[null,"Return on Rate Base"]
[null,null,"Capital Structure"]
[null,null,"Deemed Short Term Debt",null,null,null,{"$f":"G$32*'3. Cost_of_Service_Parameters'!G22","v":0},null,{"$f":"I$32*'3. Cost_of_Service_Parameters'!I22","v":0},null,{"$f":"K$32*'3. Cost_of_Service_Parameters'!K22","v":0},null,{"$f":"M$32*'3. Cost_of_Service_Parameters'!M22","v":0},null,{"$f":"O$32*'3. Cost_of_Service_Parameters'!O22","v":14416.355333333333},null,{"$f":"Q$32*'3. Cost_of_Service_Parameters'!Q22","v":23463.134666666669},null,{"$f":"S$32*'3. Cost_of_Service_Parameters'!S22","v":25793.301333333333}]
[null,null,"Deemed Long Term Debt",null,null,null,{"$f":"G$32*'3. Cost_of_Service_Parameters'!G23","v":0},null,{"$f":"I$32*'3. Cost_of_Service_Parameters'!I23","v":2462.5833333333335},null,{"$f":"K$32*'3. Cost_of_Service_Parameters'!K23","v":6237.9921499999982},null,{"$f":"M$32*'3. Cost_of_Service_Parameters'!M23","v":65705.226300000009},null,{"$f":"O$32*'3. Cost_of_Service_Parameters'!O23","v":201828.97466666662},null,{"$f":"Q$32*'3. Cost_of_Service_Parameters'!Q23","v":328483.88533333334},null,{"$f":"S$32*'3. Cost_of_Service_Parameters'!S23","v":361106.21866666665}]
[null,null,"Equity",null,null,null,{"$f":"G$32*'3. Cost_of_Service_Parameters'!G24","v":0},null,{"$f":"I$32*'3. Cost_of_Service_Parameters'!I24","v":2462.5833333333335},null,{"$f":"K$32*'3. Cost_of_Service_Parameters'!K24","v":5465.5578500000011},null,{"$f":"M$32*'3. Cost_of_Service_Parameters'!M24","v":50177.007033333328},null,{"$f":"O$32*'3. Cost_of_Service_Parameters'!O24","v":144163.55333333334},null,{"$f":"Q$32*'3. Cost_of_Service_Parameters'!Q24","v":234631.34666666674},null,{"$f":"S$32*'3. Cost_of_Service_Parameters'!S24","v":257933.01333333339}]
[null,null,"Preferred Shares",null,null,null,{"$f":"G$32*'3. Cost_of_Service_Parameters'!G25","v":0},null,{"$f":"I$32*'3. Cost_of_Service_Parameters'!I25","v":0},null,{"$f":"K$32*'3. Cost_of_Service_Parameters'!K25","v":0},null,{"$f":"M$32*'3. Cost_of_Service_Parameters'!M25","v":0},null,{"$f":"O$32*'3. Cost_of_Service_Parameters'!O25","v":0},null,{"$f":"Q$32*'3. Cost_of_Service_Parameters'!Q25","v":0},null,{"$f":"S$32*'3. Cost_of_Service_Parameters'!S25","v":0}]
[null,null,"Total Capitalization",null,null,null,{"$f":"SUM(G36:G39)","v":0},null,{"$f":"SUM(I36:I39)","v":4925.166666666667},null,{"$f":"SUM(K36:K39)","v":11703.55},null,{"$f":"SUM(M36:M39)","v":115882.23333333334},null,{"$f":"SUM(O36:O39)","v":360408.8833333333},null,{"$f":"SUM(Q36:Q39)","v":586578.3666666667},null,{"$f":"SUM(S36:S39)","v":644832.53333333333}]
[null,null,null,null,null,null,{"$f":"IF(G40=G32,\"\",\"Error\")","v":""},null,{"$f":"IF(I40=I32,\"\",\"Error\")","v":""},null,{"$f":"IF(K40=K32,\"\",\"Error\")","v":""},null,{"$f":"IF(M40=M32,\"\",\"Error\")","v":""},null,{"$f":"IF(O40=O32,\"\",\"Error\")","v":""},null,{"$f":"IF(Q40=Q32,\"\",\"Error\")","v":""},null,{"$f":"IF(S40=S32,\"\",\"Error\")","v":""}]
[null,null,"Return on"]
[null,null,"Deemed Short Term Debt",null,null,null,{"$f":"G36*'3. Cost_of_Service_Parameters'!G29","v":0},null,{"$f":"I36*'3. Cost_of_Service_Parameters'!I29","v":0},null,{"$f":"K36*'3. Cost_of_Service_Parameters'!K29","v":0},null,{"$f":"M36*'3. Cost_of_Service_Parameters'!M29","v":0},null,{"$f":"O36*'3. Cost_of_Service_Parameters'!O29","v":298.4185554},null,{"$f":"Q36*'3. Cost_of_Service_Parameters'!Q29","v":485.68688760000003},null,{"$f":"S36*'3. Cost_of_Service_Parameters'!S29","v":533.92133760000002}]
[null,null,"Deemed Long Term Debt",null,null,null,{"$f":"G37*'3. Cost_of_Service_Parameters'!G30","v":0},null,{"$f":"I37*'3. Cost_of_Service_Parameters'!I30","v":148.98629166666666},null,{"$f":"K37*'3. Cost_of_Service_Parameters'!K30","v":377.3985250749999},null,{"$f":"M37*'3. Cost_of_Service_Parameters'!M30","v":3975.1661911500005},null,{"$f":"O37*'3. Cost_of_Service_Parameters'!O30","v":10353.826400399998},null,{"$f":"Q37*'3. Cost_of_Service_Parameters'!Q30","v":16851.223317600001},null,{"$f":"S37*'3. Cost_of_Service_Parameters'!S30","v":18524.749017599999}]
[null,null,"Equity",null,null,null,{"$f":"G38*'3. Cost_of_Service_Parameters'!G31","v":0},null,{"$f":"I38*'3. Cost_of_Service_Parameters'!I31","v":221.63249999999999},null,{"$f":"K38*'3. Cost_of_Service_Parameters'!K31","v":491.90020650000008},null,{"$f":"M38*'3. Cost_of_Service_Parameters'!M31","v":4515.930632999999},null,{"$f":"O38*'3. Cost_of_Service_Parameters'!O31","v":14200.110003333335},null,{"$f":"Q38*'3. Cost_of_Service_Parameters'!Q31","v":23111.187646666676},null,{"$f":"S38*'3. Cost_of_Service_Parameters'!S31","v":25406.401813333341}]
[null,null,"Preferred Shares",null,null,null,{"$f":"G39*'3. Cost_of_Service_Parameters'!G32","v":0},null,{"$f":"I39*'3. Cost_of_Service_Parameters'!I32","v":0},null,{"$f":"K39*'3. Cost_of_Service_Parameters'!K32","v":0},null,{"$f":"M39*'3. Cost_of_Service_Parameters'!M32","v":0},null,{"$f":"O39*'3. Cost_of_Service_Parameters'!O32","v":0},null,{"$f":"Q39*'3. Cost_of_Service_Parameters'!Q32","v":0},null,{"$f":"S39*'3. Cost_of_Service_Parameters'!S32","v":0}]
[null,null,"Total Return on Capital",null,null,null,{"$f":"SUM(G43:G46)","v":0},null,{"$f":"SUM(I43:I46)","v":370.61879166666665},null,{"$f":"SUM(K43:K46)","v":869.29873157499992},null,{"$f":"SUM(M43:M46)","v":8491.0968241499995},null,{"$f":"SUM(O43:O46)","v":24852.354959133332},null,{"$f":"SUM(Q43:Q46)","v":40448.097851866682},null,{"$f":"SUM(S43:S46)","v":44465.072168533341}]
[]
[]
[null,"Operating Expenses",null,null,null,null,{"$f":"G28","v":0},null,{"$f":"I28","v":0},null,{"$f":"K28","v":0},null,{"$f":"M28","v":17394},null,{"$f":"O28","v":25964},null,{"$f":"Q28","v":38676},null,{"$f":"S28","v":47954}]
[]
[null,"Amortization Expenses (from Sheet 4)"]
[null,null,"Smart Meters",null,null,null,{"$f":"-'4. SM_Assets_and_Rate_Base'!G29","v":0},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!I29","v":339.66666666666669},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!K29","v":830.56666666666672},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!M29","v":7861.7666666666664},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!O29","v":24895.433333333334},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!Q29","v":41784.799999999996},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!S29","v":48635.066666666666}]
[null,null,"Computer Hardware",null,null,null,{"$f":"-'4. SM_Assets_and_Rate_Base'!G48","v":0},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!I48","v":0},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!K48","v":0},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!M48","v":47.7},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!O48","v":564},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!Q48","v":1091.0999999999999},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!S48","v":1149.5999999999999}]
[null,null,"Computer Software",null,null,null,{"$f":"-'4. SM_Assets_and_Rate_Base'!G67","v":0},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!I67","v":0},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!K67","v":0},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!M67","v":51.8},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!O67","v":472},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!Q67","v":1122.3},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!S67","v":1404.2}]
[null,null,"Tools & Equipment",null,null,null,{"$f":"-'4. SM_Assets_and_Rate_Base'!G86","v":0},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!I86","v":0},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!K86","v":0},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!M86","v":0},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!O86","v":0},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!Q86","v":0},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!S86","v":0}]
[null,null,"Other Equipment",null,null,null,{"$f":"-'4. SM_Assets_and_Rate_Base'!G105","v":0},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!I105","v":0},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!K105","v":0},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!M105","v":0},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!O105","v":0},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!Q105","v":0},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!S105","v":0}]
[null,null,"Total Amortization Expense in Year",null,null,null,{"$f":"SUM(G53:G57)","v":0},null,{"$f":"SUM(I53:I57)","v":339.66666666666669},null,{"$f":"SUM(K53:K57)","v":830.56666666666672},null,{"$f":"SUM(M53:M57)","v":7961.2666666666664},null,{"$f":"SUM(O53:O57)","v":25931.433333333334},null,{"$f":"SUM(Q53:Q57)","v":43998.2},null,{"$f":"SUM(S53:S57)","v":51188.866666666661}]
[]
[null,"Incremental Revenue Requirement before Taxes/PILs",null,null,null,null,{"$f":"G47+G50+G58","v":0},null,{"$f":"I47+I50+I58","v":710.28545833333328},null,{"$f":"K47+K50+K58","v":1699.8653982416668},null,{"$f":"M47+M50+M58","v":33846.363490816671},null,{"$f":"O47+O50+O58","v":76747.788292466663},null,{"$f":"Q47+Q50+Q58","v":123122.29785186668},null,{"$f":"S47+S50+S58","v":143607.93883520001}]
[]
[null,"Calculation of Taxable Income"]
[null,null,"Incremental Operating Expenses",null,null,null,{"$f":"G50","v":0},null,{"$f":"I50","v":0},null,{"$f":"K50","v":0},null,{"$f":"M50","v":17394},null,{"$f":"O50","v":25964},null,{"$f":"Q50","v":38676},null,{"$f":"S50","v":47954}]
[null,null,"Amortization Expense",null,null,null,{"$f":"G58","v":0},null,{"$f":"I58","v":339.66666666666669},null,{"$f":"K58","v":830.56666666666672},null,{"$f":"M58","v":7961.2666666666664},null,{"$f":"O58","v":25931.433333333334},null,{"$f":"Q58","v":43998.2},null,{"$f":"S58","v":51188.866666666661}]
[null,null,"Interest Expense",null,null,null,{"$f":"G43+G44","v":0},null,{"$f":"I43+I44","v":148.98629166666666},null,{"$f":"K43+K44","v":377.3985250749999},null,{"$f":"M43+M44","v":3975.1661911500005},null,{"$f":"O43+O44","v":10652.244955799997},null,{"$f":"Q43+Q44","v":17336.910205200002},null,{"$f":"S43+S44","v":19058.6703552}]
[null,null,"Net Income for Taxes/PILs",null,null,null,{"$f":"G60-SUM(G63:G65)","v":0},null,{"$f":"I60-SUM(I63:I65)","v":221.63249999999994},null,{"$f":"K60-SUM(K63:K65)","v":491.90020650000019},null,{"$f":"M60-SUM(M63:M65)","v":4515.9306330000036},null,{"$f":"O60-SUM(O63:O65)","v":14200.110003333335},null,{"$f":"Q60-SUM(Q63:Q65)","v":23111.187646666673},null,{"$f":"S60-SUM(S63:S65)","v":25406.401813333345}]
[]
[null,"Grossed-up Taxes/PILs (from Sheet 7)",null,null,null,null,{"$f":"'7_Taxes_PILs'!C59","v":0},null,{"$f":"'7_Taxes_PILs'!E59","v":109.07016765810896},null,{"$f":"'7_Taxes_PILs'!G59","v":211.04751073057662},null,{"$f":"'7_Taxes_PILs'!I59","v":1787.0661506567185},null,{"$f":"'7_Taxes_PILs'!K59","v":3103.3571193543385},null,{"$f":"'7_Taxes_PILs'!M59","v":6656.7509130444778},null,{"$f":"'7_Taxes_PILs'!O59","v":7322.6042951475529}]
[]
[null,"Revenue Requirement, including Grossed-up Taxes/PILs",null,null,null,null,{"$f":"G60+G68","v":0},null,{"$f":"I60+I68","v":819.35562599144225},null,{"$f":"K60+K68","v":1910.9129089722433},null,{"$f":"M60+M68","v":35633.429641473391},null,{"$f":"O60+O68","v":79851.145411820995},null,{"$f":"Q60+Q68","v":129779.04876491116},null,{"$f":"S60+S68","v":150930.54313034756}]

{"sheet":"6. UCC_Calculation","index":5,"n_rows":76,"n_cols":14,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["For PILs Calculation"]
[]
["UCC - Smart Meters",{"$f":"'2. Smart_Meter_Costs'!G18","v":2006},null,{"$f":"'2. Smart_Meter_Costs'!I18","v":2007},null,{"$f":"'2. Smart_Meter_Costs'!K18","v":2008},null,{"$f":"'2. Smart_Meter_Costs'!M18","v":2009},null,{"$f":"'2. Smart_Meter_Costs'!O18","v":2010},null,{"$f":"'2. Smart_Meter_Costs'!Q18","v":2011},null,{"$f":"'2. Smart_Meter_Costs'!S18","v":"2012 and later"}]
[null,{"$f":"'2. Smart_Meter_Costs'!G19","v":"Audited Actual"},null,{"$f":"'2. Smart_Meter_Costs'!I19","v":"Audited Actual"},null,{"$f":"'2. Smart_Meter_Costs'!K19","v":"Audited Actual"},null,{"$f":"'2. Smart_Meter_Costs'!M19","v":"Audited Actual"},null,{"$f":"'2. Smart_Meter_Costs'!O19","v":"Audited Actual"},null,{"$f":"'2. Smart_Meter_Costs'!Q19","v":"Audited Actual"},null,{"$f":"'2. Smart_Meter_Costs'!S19","v":"Forecast"}]
[]
["Opening UCC",0,null,{"$f":"B26-B31","v":0},null,{"$f":"D26-D31","v":9782.4},null,{"$f":"F26-F31","v":13355.328},null,{"$f":"H26-H31","v":210429.94176000002},null,{"$f":"J26-J31","v":486022.10641920002},null,{"$f":"L26-L31","v":641127.53790566407}]
["Capital Additions",{"$f":"'4. SM_Assets_and_Rate_Base'!G23","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!I23","v":10190},null,{"$f":"'4. SM_Assets_and_Rate_Base'!K23","v":4537},null,{"$f":"'4. SM_Assets_and_Rate_Base'!M23","v":206399},null,{"$f":"'4. SM_Assets_and_Rate_Base'!O23","v":304611},null,{"$f":"'4. SM_Assets_and_Rate_Base'!Q23","v":202070},null,{"$f":"'4. SM_Assets_and_Rate_Base'!S23","v":3438}]
["Retirements/Removals (if applicable)"]
["UCC Before Half Year Rule",{"$f":"SUM(B23:B24)-B25","v":0},null,{"$f":"SUM(D23:D24)-D25","v":10190},null,{"$f":"SUM(F23:F24)-F25","v":14319.4},null,{"$f":"SUM(H23:H24)-H25","v":219754.32800000001},null,{"$f":"SUM(J23:J24)-J25","v":515040.94176000002},null,{"$f":"SUM(L23:L24)-L25","v":688092.10641920008},null,{"$f":"SUM(N23:N24)-N25","v":644565.53790566407}]
["Half Year Rule (1/2 Additions - Disposals)",{"$f":"IF(((B24-B25)/2)<0, 0, (B24-B25)/2)","v":0},null,{"$f":"IF(((D24-D25)/2)<0, 0, (D24-D25)/2)","v":5095},null,{"$f":"IF(((F24-F25)/2)<0, 0, (F24-F25)/2)","v":2268.5},null,{"$f":"IF(((H24-H25)/2)<0, 0, (H24-H25)/2)","v":103199.5},null,{"$f":"IF(((J24-J25)/2)<0, 0, (J24-J25)/2)","v":152305.5},null,{"$f":"IF(((L24-L25)/2)<0, 0, (L24-L25)/2)","v":101035},null,{"$f":"IF(((N24-N25)/2)<0, 0, (N24-N25)/2)","v":1719}]
["Reduced UCC",{"$f":"B27+B23","v":0},null,{"$f":"D27+D23","v":5095},null,{"$f":"F27+F23","v":12050.9},null,{"$f":"H27+H23","v":116554.82799999999},null,{"$f":"J27+J23","v":362735.44176000002},null,{"$f":"L27+L23","v":587057.10641920008},null,{"$f":"N27+N23","v":642846.53790566407}]
["CCA Rate Class",{"$f":"'3. Cost_of_Service_Parameters'!G57","v":47},null,{"$f":"'3. Cost_of_Service_Parameters'!I57","v":47},null,{"$f":"'3. Cost_of_Service_Parameters'!K57","v":47},null,{"$f":"'3. Cost_of_Service_Parameters'!M57","v":47},null,{"$f":"'3. Cost_of_Service_Parameters'!O57","v":47},null,{"$f":"'3. Cost_of_Service_Parameters'!Q57","v":47},null,{"$f":"'3. Cost_of_Service_Parameters'!S57","v":47}]
["CCA Rate ",{"$f":"'3. Cost_of_Service_Parameters'!G58","v":0.08},null,{"$f":"'3. Cost_of_Service_Parameters'!I58","v":0.08},null,{"$f":"'3. Cost_of_Service_Parameters'!K58","v":0.08},null,{"$f":"'3. Cost_of_Service_Parameters'!M58","v":0.08},null,{"$f":"'3. Cost_of_Service_Parameters'!O58","v":0.08},null,{"$f":"'3. Cost_of_Service_Parameters'!Q58","v":0.08},null,{"$f":"'3. Cost_of_Service_Parameters'!S58","v":0.08}]
["CCA",{"$f":"B28*B30","v":0},null,{"$f":"D28*D30","v":407.6},null,{"$f":"F28*F30","v":964.072},null,{"$f":"H28*H30","v":9324.3862399999998},null,{"$f":"J28*J30","v":29018.8353408},null,{"$f":"L28*L30","v":46964.568513536004},null,{"$f":"N28*N30","v":51427.723032453127}]
["Closing UCC",{"$f":"IF((B26-B31)<0, 0, B26-B31)","v":0},null,{"$f":"IF((D26-D31)<0, 0, D26-D31)","v":9782.4},null,{"$f":"IF((F26-F31)<0, 0, F26-F31)","v":13355.328},null,{"$f":"IF((H26-H31)<0, 0, H26-H31)","v":210429.94176000002},null,{"$f":"IF((J26-J31)<0, 0, J26-J31)","v":486022.10641920002},null,{"$f":"IF((L26-L31)<0, 0, L26-L31)","v":641127.53790566407},null,{"$f":"IF((N26-N31)<0, 0, N26-N31)","v":593137.81487321097}]
[]
["UCC - Computer Equipment",{"$f":"B20","v":2006},null,2007,null,2008,null,2009,null,2010,null,2011,null,{"$f":"N20","v":"2012 and later"}]
[null,"Audited Actual",null,"Audited Actual",null,"Audited Actual",null,"Audited Actual",null,"Audited Actual",null,"Audited Actual",null,{"$f":"N21","v":"Forecast"}]
[]
["Opening UCC",0,null,{"$f":"B41-B46","v":0},null,{"$f":"D41-D46","v":0},null,{"$f":"F41-F46","v":0},null,{"$f":"H41-H46","v":497.5},null,{"$f":"J41-J46","v":4185},null,{"$f":"L41-L46","v":4351.1499999999996}]
["Capital Additions Computer Hardware",{"$f":"'2. Smart_Meter_Costs'!G183","v":0},null,{"$f":"'2. Smart_Meter_Costs'!I183","v":0},null,{"$f":"'2. Smart_Meter_Costs'!K183","v":0},null,{"$f":"'2. Smart_Meter_Costs'!M183","v":477},null,{"$f":"'2. Smart_Meter_Costs'!O183","v":4686},null,{"$f":"'2. Smart_Meter_Costs'!Q183","v":585},null,{"$f":"'2. Smart_Meter_Costs'!S183","v":0}]
["Capital Additions Computer Software",{"$f":"'2. Smart_Meter_Costs'!G185","v":0},null,{"$f":"'2. Smart_Meter_Costs'!I185","v":0},null,{"$f":"'2. Smart_Meter_Costs'!K185","v":0},null,{"$f":"'2. Smart_Meter_Costs'!M185","v":518},null,{"$f":"'2. Smart_Meter_Costs'!O185","v":3684},null,{"$f":"'2. Smart_Meter_Costs'!Q185","v":2819},null,{"$f":"'2. Smart_Meter_Costs'!S185","v":0}]
["Retirements/Removals (if applicable)"]
["UCC Before Half Year Rule",{"$f":"SUM(B37:B39)-B40","v":0},null,{"$f":"SUM(D37:D39)-D40","v":0},null,{"$f":"SUM(F37:F39)-F40","v":0},null,{"$f":"SUM(H37:H39)-H40","v":995},null,{"$f":"SUM(J37:J39)-J40","v":8867.5},null,{"$f":"SUM(L37:L39)-L40","v":7589},null,{"$f":"SUM(N37:N39)-N40","v":4351.1499999999996}]
["Half Year Rule (1/2 Additions - Disposals)",{"$f":"IF((SUM(B38:B39)/2)<0, 0, SUM(B38:B39)/2)","v":0},null,{"$f":"IF((SUM(D38:D39)/2)<0, 0, SUM(D38:D39)/2)","v":0},null,{"$f":"IF((SUM(F38:F39)/2)<0, 0, SUM(F38:F39)/2)","v":0},null,{"$f":"IF((SUM(H38:H39)/2)<0, 0, SUM(H38:H39)/2)","v":497.5},null,{"$f":"IF((SUM(J38:J39)/2)<0, 0, SUM(J38:J39)/2)","v":4185},null,{"$f":"IF((SUM(L38:L39)/2)<0, 0, SUM(L38:L39)/2)","v":1702},null,{"$f":"IF((SUM(N38:N39)/2)<0, 0, SUM(N38:N39)/2)","v":0}]
["Reduced UCC",{"$f":"B42+B37","v":0},null,{"$f":"D42+D37","v":0},null,{"$f":"F42+F37","v":0},null,{"$f":"H42+H37","v":497.5},null,{"$f":"J42+J37","v":4682.5},null,{"$f":"L42+L37","v":5887},null,{"$f":"N42+N37","v":4351.1499999999996}]
["CCA Rate Class",{"$f":"'3. Cost_of_Service_Parameters'!G60","v":45},null,{"$f":"'3. Cost_of_Service_Parameters'!I60","v":45},null,{"$f":"'3. Cost_of_Service_Parameters'!K60","v":50},null,{"$f":"'3. Cost_of_Service_Parameters'!M60","v":52},null,{"$f":"'3. Cost_of_Service_Parameters'!O60","v":52},null,{"$f":"'3. Cost_of_Service_Parameters'!Q60","v":50},null,{"$f":"'3. Cost_of_Service_Parameters'!S60","v":50}]
["CCA Rate ",{"$f":"'3. Cost_of_Service_Parameters'!G61","v":0.45},null,{"$f":"'3. Cost_of_Service_Parameters'!I61","v":0.45},null,{"$f":"'3. Cost_of_Service_Parameters'!K61","v":0.55000000000000004},null,{"$f":"'3. Cost_of_Service_Parameters'!M61","v":1},null,{"$f":"'3. Cost_of_Service_Parameters'!O61","v":1},null,{"$f":"'3. Cost_of_Service_Parameters'!Q61","v":0.55000000000000004},null,{"$f":"'3. Cost_of_Service_Parameters'!S61","v":0.55000000000000004}]
["CCA",{"$f":"B45*B43","v":0},null,{"$f":"D45*D43","v":0},null,{"$f":"F45*F43","v":0},null,{"$f":"H45*H43","v":497.5},null,{"$f":"J45*J43","v":4682.5},null,{"$f":"L45*L43","v":3237.8500000000004},null,{"$f":"N45*N43","v":2393.1325000000002}]
["Closing UCC",{"$f":"IF((B41-B46)<0, 0, B41-B46)","v":0},null,{"$f":"IF((D41-D46)<0, 0, D41-D46)","v":0},null,{"$f":"IF((F41-F46)<0, 0, F41-F46)","v":0},null,{"$f":"IF((H41-H46)<0, 0, H41-H46)","v":497.5},null,{"$f":"IF((J41-J46)<0, 0, J41-J46)","v":4185},null,{"$f":"IF((L41-L46)<0, 0, L41-L46)","v":4351.1499999999996},null,{"$f":"IF((N41-N46)<0, 0, N41-N46)","v":1958.0174999999995}]
[]
["UCC - General Equipment",{"$f":"B34","v":2006},null,2007,null,2008,null,2009,null,2010,null,2011,null,{"$f":"N34","v":"2012 and later"}]
[null,"Audited Actual",null,"Audited Actual",null,"Audited Actual",null,"Audited Actual",null,"Audited Actual",null,"Audited Actual",null,{"$f":"N35","v":"Forecast"}]
[]
["Opening UCC",0,null,{"$f":"B56-B61","v":0},null,{"$f":"D56-D61","v":0},null,{"$f":"F56-F61","v":0},null,{"$f":"H56-H61","v":0},null,{"$f":"J56-J61","v":0},null,{"$f":"L56-L61","v":0}]
["Capital Additions Tools & Equipment",{"$f":"'2. Smart_Meter_Costs'!G187","v":0},null,{"$f":"'2. Smart_Meter_Costs'!I187","v":0},null,{"$f":"'2. Smart_Meter_Costs'!K187","v":0},null,{"$f":"'2. Smart_Meter_Costs'!M187","v":0},null,{"$f":"'2. Smart_Meter_Costs'!O187","v":0},null,{"$f":"'2. Smart_Meter_Costs'!Q187","v":0},null,{"$f":"'2. Smart_Meter_Costs'!S187","v":0}]
["Capital Additions Other Equipment",{"$f":"'2. Smart_Meter_Costs'!G189","v":0},null,{"$f":"'2. Smart_Meter_Costs'!I189","v":0},null,{"$f":"'2. Smart_Meter_Costs'!K189","v":0},null,{"$f":"'2. Smart_Meter_Costs'!M189","v":0},null,{"$f":"'2. Smart_Meter_Costs'!O189","v":0},null,{"$f":"'2. Smart_Meter_Costs'!Q189","v":0},null,{"$f":"'2. Smart_Meter_Costs'!S189","v":0}]
["Retirements/Removals (if applicable)"]
["UCC Before Half Year Rule",{"$f":"SUM(B52:B54)-B55","v":0},null,{"$f":"SUM(D52:D54)-D55","v":0},null,{"$f":"SUM(F52:F54)-F55","v":0},null,{"$f":"SUM(H52:H54)-H55","v":0},null,{"$f":"SUM(J52:J54)-J55","v":0},null,{"$f":"SUM(L52:L54)-L55","v":0},null,{"$f":"SUM(N52:N54)-N55","v":0}]
["Half Year Rule (1/2 Additions - Disposals)",{"$f":"IF(((SUM(B53:B54)-B55)/2)<0, 0, (SUM(B53:B54)-B55)/2)","v":0},null,{"$f":"IF(((SUM(D53:D54)-D55)/2)<0, 0, (SUM(D53:D54)-D55)/2)","v":0},null,{"$f":"IF(((SUM(F53:F54)-F55)/2)<0, 0, (SUM(F53:F54)-F55)/2)","v":0},null,{"$f":"IF(((SUM(H53:H54)-H55)/2)<0, 0, (SUM(H53:H54)-H55)/2)","v":0},null,{"$f":"IF(((SUM(J53:J54)-J55)/2)<0, 0, (SUM(J53:J54)-J55)/2)","v":0},null,{"$f":"IF(((SUM(L53:L54)-L55)/2)<0, 0, (SUM(L53:L54)-L55)/2)","v":0},null,{"$f":"IF(((SUM(N53:N54)-N55)/2)<0, 0, (SUM(N53:N54)-N55)/2)","v":0}]
["Reduced UCC",{"$f":"B57+B52","v":0},null,{"$f":"D57+D52","v":0},null,{"$f":"F57+F52","v":0},null,{"$f":"H57+H52","v":0},null,{"$f":"J57+J52","v":0},null,{"$f":"L57+L52","v":0},null,{"$f":"N57+N52","v":0}]
["CCA Rate Class",{"$f":"'3. Cost_of_Service_Parameters'!G63","v":8},null,{"$f":"'3. Cost_of_Service_Parameters'!I63","v":8},null,{"$f":"'3. Cost_of_Service_Parameters'!K63","v":8},null,{"$f":"'3. Cost_of_Service_Parameters'!M63","v":8},null,{"$f":"'3. Cost_of_Service_Parameters'!O63","v":8},null,{"$f":"'3. Cost_of_Service_Parameters'!Q63","v":8},null,{"$f":"'3. Cost_of_Service_Parameters'!S63","v":8}]
["CCA Rate ",{"$f":"'3. Cost_of_Service_Parameters'!G64","v":0.2},null,{"$f":"'3. Cost_of_Service_Parameters'!I64","v":0.2},null,{"$f":"'3. Cost_of_Service_Parameters'!K64","v":0.2},null,{"$f":"'3. Cost_of_Service_Parameters'!M64","v":0.2},null,{"$f":"'3. Cost_of_Service_Parameters'!O64","v":0.2},null,{"$f":"'3. Cost_of_Service_Parameters'!Q64","v":0.2},null,{"$f":"'3. Cost_of_Service_Parameters'!S64","v":0.2}]
["CCA",{"$f":"B60*B58","v":0},null,{"$f":"D60*D58","v":0},null,{"$f":"F60*F58","v":0},null,{"$f":"H60*H58","v":0},null,{"$f":"J60*J58","v":0},null,{"$f":"L60*L58","v":0},null,{"$f":"N60*N58","v":0}]
["Closing UCC",{"$f":"IF((B56-B61)<0, 0, B56-B61)","v":0},null,{"$f":"IF((D56-D61)<0, 0, D56-D61)","v":0},null,{"$f":"IF((F56-F61)<0, 0, F56-F61)","v":0},null,{"$f":"IF((H56-H61)<0, 0, H56-H61)","v":0},null,{"$f":"IF((J56-J61)<0, 0, J56-J61)","v":0},null,{"$f":"IF((L56-L61)<0, 0, L56-L61)","v":0},null,{"$f":"IF((N56-N61)<0, 0, N56-N61)","v":0}]
[]
["UCC - Applications Software",{"$f":"B49","v":2006},null,{"$f":"D49","v":2007},null,{"$f":"F49","v":2008},null,{"$f":"H49","v":2009},null,{"$f":"J49","v":2010},null,{"$f":"L49","v":2011},null,{"$f":"N49","v":"2012 and later"}]
[null,{"$f":"B50","v":"Audited Actual"},null,{"$f":"D50","v":"Audited Actual"},null,{"$f":"F50","v":"Audited Actual"},null,{"$f":"H50","v":"Audited Actual"},null,{"$f":"J50","v":"Audited Actual"},null,{"$f":"L50","v":"Audited Actual"},null,{"$f":"N50","v":"Forecast"}]
[]
["Opening UCC",0,null,{"$f":"B70-B75","v":0},null,{"$f":"D70-D75","v":0},null,{"$f":"F70-F75","v":0},null,{"$f":"H70-H75","v":0},null,{"$f":"J70-J75","v":0},null,{"$f":"L70-L75","v":0}]
["Capital Additions Applications Software",{"$f":"'2. Smart_Meter_Costs'!G191","v":0},null,{"$f":"'2. Smart_Meter_Costs'!I191","v":0},null,{"$f":"'2. Smart_Meter_Costs'!K191","v":0},null,{"$f":"'2. Smart_Meter_Costs'!M191","v":0},null,{"$f":"'2. Smart_Meter_Costs'!O191","v":0},null,{"$f":"'2. Smart_Meter_Costs'!Q191","v":0},null,{"$f":"'2. Smart_Meter_Costs'!S191","v":0}]
["Retirements/Removals (if applicable)"]
["UCC Before Half Year Rule",{"$f":"SUM(B67:B68)-B69","v":0},null,{"$f":"SUM(D67:D68)-D69","v":0},null,{"$f":"SUM(F67:F68)-F69","v":0},null,{"$f":"SUM(H67:H68)-H69","v":0},null,{"$f":"SUM(J67:J68)-J69","v":0},null,{"$f":"SUM(L67:L68)-L69","v":0},null,{"$f":"SUM(N67:N68)-N69","v":0}]
["Half Year Rule (1/2 Additions - Disposals)",{"$f":"IF(((SUM(B68:B68)-B69)/2)<0, 0, (SUM(B68:B68)-B69)/2)","v":0},null,{"$f":"IF(((SUM(D68:D68)-D69)/2)<0, 0, (SUM(D68:D68)-D69)/2)","v":0},null,{"$f":"IF(((SUM(F68:F68)-F69)/2)<0, 0, (SUM(F68:F68)-F69)/2)","v":0},null,{"$f":"IF(((SUM(H68:H68)-H69)/2)<0, 0, (SUM(H68:H68)-H69)/2)","v":0},null,{"$f":"IF(((SUM(J68:J68)-J69)/2)<0, 0, (SUM(J68:J68)-J69)/2)","v":0},null,{"$f":"IF(((SUM(L68:L68)-L69)/2)<0, 0, (SUM(L68:L68)-L69)/2)","v":0},null,{"$f":"IF(((SUM(N68:N68)-N69)/2)<0, 0, (SUM(N68:N68)-N69)/2)","v":0}]
["Reduced UCC",{"$f":"B71+B67","v":0},null,{"$f":"D71+D67","v":0},null,{"$f":"F71+F67","v":0},null,{"$f":"H71+H67","v":0},null,{"$f":"J71+J67","v":0},null,{"$f":"L71+L67","v":0},null,{"$f":"N71+N67","v":0}]
["CCA Rate Class",{"$f":"'3. Cost_of_Service_Parameters'!G66","v":45},null,{"$f":"'3. Cost_of_Service_Parameters'!I66","v":45},null,{"$f":"'3. Cost_of_Service_Parameters'!K66","v":50},null,{"$f":"'3. Cost_of_Service_Parameters'!M66","v":52},null,{"$f":"'3. Cost_of_Service_Parameters'!O66","v":52},null,{"$f":"'3. Cost_of_Service_Parameters'!Q66","v":50},null,{"$f":"'3. Cost_of_Service_Parameters'!S66","v":50}]
["CCA Rate ",{"$f":"'3. Cost_of_Service_Parameters'!G67","v":0.45},null,{"$f":"'3. Cost_of_Service_Parameters'!I67","v":0.45},null,{"$f":"'3. Cost_of_Service_Parameters'!K67","v":0.55000000000000004},null,{"$f":"'3. Cost_of_Service_Parameters'!M67","v":1},null,{"$f":"'3. Cost_of_Service_Parameters'!O67","v":1},null,{"$f":"'3. Cost_of_Service_Parameters'!Q67","v":0.55000000000000004},null,{"$f":"'3. Cost_of_Service_Parameters'!S67","v":0.55000000000000004}]
["CCA",{"$f":"B74*B72","v":0},null,{"$f":"D74*D72","v":0},null,{"$f":"F74*F72","v":0},null,{"$f":"H74*H72","v":0},null,{"$f":"J74*J72","v":0},null,{"$f":"L74*L72","v":0},null,{"$f":"N74*N72","v":0}]
["Closing UCC",{"$f":"IF((B70-B75)<0, 0, B70-B75)","v":0},null,{"$f":"IF((D70-D75)<0, 0, D70-D75)","v":0},null,{"$f":"IF((F70-F75)<0, 0, F70-F75)","v":0},null,{"$f":"IF((H70-H75)<0, 0, H70-H75)","v":0},null,{"$f":"IF((J70-J75)<0, 0, J70-J75)","v":0},null,{"$f":"IF((L70-L75)<0, 0, L70-L75)","v":0},null,{"$f":"IF((N70-N75)<0, 0, N70-N75)","v":0}]

{"sheet":"7_Taxes_PILs","index":6,"n_rows":59,"n_cols":15,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PILs Calculation"]
[]
[null,null,{"$f":"'2. Smart_Meter_Costs'!G18& \" \" &'2. Smart_Meter_Costs'!G19","v":"2006 Audited Actual"},null,{"$f":"'2. Smart_Meter_Costs'!I18& \" \" &'2. Smart_Meter_Costs'!I19","v":"2007 Audited Actual"},null,{"$f":"'2. Smart_Meter_Costs'!K18& \" \" &'2. Smart_Meter_Costs'!K19","v":"2008 Audited Actual"},null,{"$f":"'2. Smart_Meter_Costs'!M18& \" \" &'2. Smart_Meter_Costs'!M19","v":"2009 Audited Actual"},null,{"$f":"'2. Smart_Meter_Costs'!O18& \" \" &'2. Smart_Meter_Costs'!O19","v":"2010 Audited Actual"},null,{"$f":"'2. Smart_Meter_Costs'!Q18& \" \" &'2. Smart_Meter_Costs'!Q19","v":"2011 Audited Actual"},null,{"$f":"'2. Smart_Meter_Costs'!S18& \" \" &'2. Smart_Meter_Costs'!S19","v":"2012 and later Forecast"}]
[]
["INCOME TAX"]
[null,"Net Income",{"$f":"'5. SM_Rev_Reqt'!G$66","v":0},null,{"$f":"'5. SM_Rev_Reqt'!I$66","v":221.63249999999994},null,{"$f":"'5. SM_Rev_Reqt'!K$66","v":491.90020650000019},null,{"$f":"'5. SM_Rev_Reqt'!M$66","v":4515.9306330000036},null,{"$f":"'5. SM_Rev_Reqt'!O$66","v":14200.110003333335},null,{"$f":"'5. SM_Rev_Reqt'!Q$66","v":23111.187646666673},null,{"$f":"'5. SM_Rev_Reqt'!S$66","v":25406.401813333345}]
[null,"Amortization ",{"$f":"'5. SM_Rev_Reqt'!G$64","v":0},null,{"$f":"'5. SM_Rev_Reqt'!I$64","v":339.66666666666669},null,{"$f":"'5. SM_Rev_Reqt'!K$64","v":830.56666666666672},null,{"$f":"'5. SM_Rev_Reqt'!M$64","v":7961.2666666666664},null,{"$f":"'5. SM_Rev_Reqt'!O$64","v":25931.433333333334},null,{"$f":"'5. SM_Rev_Reqt'!Q$64","v":43998.2},null,{"$f":"'5. SM_Rev_Reqt'!S$64","v":51188.866666666661}]
[null,"CCA - Smart Meters",{"$f":"-'6. UCC_Calculation'!B31","v":0},null,{"$f":"-'6. UCC_Calculation'!D31","v":-407.6},null,{"$f":"-'6. UCC_Calculation'!F31","v":-964.072},null,{"$f":"-'6. UCC_Calculation'!H31","v":-9324.3862399999998},null,{"$f":"-'6. UCC_Calculation'!J31","v":-29018.8353408},null,{"$f":"-'6. UCC_Calculation'!L31","v":-46964.568513536004},null,{"$f":"-'6. UCC_Calculation'!N31","v":-51427.723032453127}]
[null,"CCA - Computers",{"$f":"-'6. UCC_Calculation'!B46","v":0},null,{"$f":"-'6. UCC_Calculation'!D46","v":0},null,{"$f":"-'6. UCC_Calculation'!F46","v":0},null,{"$f":"-'6. UCC_Calculation'!H46","v":-497.5},null,{"$f":"-'6. UCC_Calculation'!J46","v":-4682.5},null,{"$f":"-'6. UCC_Calculation'!L46","v":-3237.8500000000004},null,{"$f":"-'6. UCC_Calculation'!N46","v":-2393.1325000000002}]
[null,"CCA - Applications Software",{"$f":"-'6. UCC_Calculation'!B75","v":0},null,{"$f":"-'6. UCC_Calculation'!D75","v":0},null,{"$f":"-'6. UCC_Calculation'!F75","v":0},null,{"$f":"-'6. UCC_Calculation'!H75","v":0},null,{"$f":"-'6. UCC_Calculation'!J75","v":0},null,{"$f":"-'6. UCC_Calculation'!L75","v":0},null,{"$f":"-'6. UCC_Calculation'!N75","v":0}]
[null,"CCA -  Other Equipment",{"$f":"-'6. UCC_Calculation'!B61","v":0},null,{"$f":"-'6. UCC_Calculation'!D61","v":0},null,{"$f":"-'6. UCC_Calculation'!F61","v":0},null,{"$f":"-'6. UCC_Calculation'!H61","v":0},null,{"$f":"-'6. UCC_Calculation'!J61","v":0},null,{"$f":"-'6. UCC_Calculation'!L61","v":0},null,{"$f":"-'6. UCC_Calculation'!N61","v":0}]
[null,"Change in taxable income",{"$f":"SUM(C23:C28)","v":0},null,153.69916666666666,null,358.39487316666703,null,2655.3110596666702,null,6430.2079958666691,null,16906.969133130668,null,22774.412947546873]
[]
[null,"Tax Rate (from Sheet 3)",{"$f":"'3. Cost_of_Service_Parameters'!G40","v":0.36120000000000002},null,{"$f":"'3. Cost_of_Service_Parameters'!I40","v":0.36120000000000002},null,{"$f":"'3. Cost_of_Service_Parameters'!K40","v":0.33500000000000002},null,{"$f":"'3. Cost_of_Service_Parameters'!M40","v":0.33},null,{"$f":"'3. Cost_of_Service_Parameters'!O40","v":0.2979},null,{"$f":"'3. Cost_of_Service_Parameters'!Q40","v":0.28249999999999997},null,{"$f":"'3. Cost_of_Service_Parameters'!S40","v":0.24329999999999999}]
[]
[null,"Income Taxes Payable",{"$f":"C29*C31","v":0},null,55.516139000000003,null,120.06228251083346,null,876.25264969000125,null,1915.5589619686807,null,4776.2187801094133,null,5541.0146701381536]
[]
["ONTARIO CAPITAL TAX"]
[null,"Smart Meters",{"$f":"'4. SM_Assets_and_Rate_Base'!G35","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!I35","v":9850.3333333333339},null,{"$f":"'4. SM_Assets_and_Rate_Base'!K35","v":13556.766666666666},null,{"$f":"'4. SM_Assets_and_Rate_Base'!M35","v":212094},null,{"$f":"'4. SM_Assets_and_Rate_Base'!O35","v":491809.56666666665},null,{"$f":"'4. SM_Assets_and_Rate_Base'!Q35","v":652094.7666666666},null,{"$f":"'4. SM_Assets_and_Rate_Base'!S35","v":606897.69999999995}]
[null,"Computer Hardware",{"$f":"'4. SM_Assets_and_Rate_Base'!G54","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!I54","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!K54","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!M54","v":429.3},null,{"$f":"'4. SM_Assets_and_Rate_Base'!O54","v":4551.3},null,{"$f":"'4. SM_Assets_and_Rate_Base'!Q54","v":4045.2},null,{"$f":"'4. SM_Assets_and_Rate_Base'!S54","v":2895.6000000000004}]
[null,"Computer Software                                    (Including Application Software)",{"$f":"'4. SM_Assets_and_Rate_Base'!G73","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!I73","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!K73","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!M73","v":466.2},null,{"$f":"'4. SM_Assets_and_Rate_Base'!O73","v":3678.2},null,{"$f":"'4. SM_Assets_and_Rate_Base'!Q73","v":5374.9},null,{"$f":"'4. SM_Assets_and_Rate_Base'!S73","v":3970.7}]
[null,"Tools & Equipment",{"$f":"'4. SM_Assets_and_Rate_Base'!G92","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!I92","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!K92","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!M92","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!O92","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!Q92","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!S92","v":0}]
[null,"Other Equipment",{"$f":"'4. SM_Assets_and_Rate_Base'!G111","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!I111","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!K111","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!M111","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!O111","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!Q111","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!S111","v":0}]
[null,"Rate Base",{"$f":"SUM(C36:C40)","v":0},null,{"$f":"SUM(E36:E40)","v":9850.3333333333339},null,{"$f":"SUM(G36:G40)","v":13556.766666666666},null,{"$f":"SUM(I36:I40)","v":212989.5},null,{"$f":"SUM(K36:K40)","v":500039.06666666665},null,{"$f":"SUM(M36:M40)","v":661514.86666666658},null,{"$f":"SUM(O36:O40)","v":613763.99999999988}]
[null,"Less: Exemption"]
[null,"Deemed Taxable Capital",{"$f":"C41-C42","v":0},null,9850.3333333333339,null,13556.766666666666,null,212989.5,null,500039.06666666665,null,661514.86666666658,null,613763.99999999988]
[]
[null,"Ontario Capital Tax Rate (from Sheet 3)",{"$f":"'3. Cost_of_Service_Parameters'!G41","v":3.0000000000000001E-3},null,2.2499999999999998E-3,null,2.2499999999999998E-3,null,2.2499999999999998E-3,null,{"$f":"0.15%/2","v":7.5000000000000002E-4},null,0,null,0]
[]
[null,"Net Amount (Taxable Capital x Rate)",{"$f":"C43*C45","v":0},null,22.163250000000001,null,30.502724999999998,null,479.22637499999996,null,375.02929999999998,null,0,null,0]
[]
[]
[null,"Change in Income Taxes Payable",{"$f":"C33","v":0},null,55.516139000000003,null,120.06228251083346,null,876.25264969000125,null,1915.5589619686807,null,4776.2187801094133,null,5541.0146701381536]
[null,"Change in OCT",{"$f":"C47","v":0},null,22.163250000000001,null,30.502724999999998,null,479.22637499999996,null,375.02929999999998,null,0,null,0]
[null,"PILs",{"$f":"SUM(C50:C51)","v":0},null,77.679389,null,150.56500751083345,null,1355.4790246900011,null,2290.5882619686809,null,4776.2187801094133,null,5541.0146701381536]
[]
[]
["Gross Up PILs"]
[null,"Tax Rate",{"$f":"C31","v":0.36120000000000002},null,{"$f":"E31","v":0.36120000000000002},null,0.33500000000000002,null,0.33,null,0.2979,null,0.28249999999999997,null,0.24329999999999999]
[null,"Change in Income Taxes Payable",{"$f":"C50/(1-C56)","v":0},null,86.906917658108952,null,180.54478573057662,null,1307.8397756567185,null,2728.3278193543383,null,6656.7509130444778,null,7322.6042951475529]
[null,"Change in OCT",{"$f":"C51","v":0},null,22.163250000000001,null,30.502724999999998,null,479.22637499999996,null,375.02929999999998,null,0,null,0]
[null,"PILs",{"$f":"SUM(C57:C58)","v":0},null,109.07016765810896,null,211.04751073057662,null,1787.0661506567185,null,3103.3571193543385,null,6656.7509130444778,null,7322.6042951475529]

{"sheet":"8. Funding_Adder_Revs","index":7,"n_rows":109,"n_cols":16,"rows_kept":109,"cut":false,"hidden":false,"merged":[[21,3,22,3],[18,5,18,15]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Account 1555 - Sub-account Funding Adder Revenues"]
[]
[null,"Interest Rates","Approved Deferral and Variance Accounts","CWIP",null,"Date","Year","Quarter",null,"Opening Balance (Principal)","Funding Adder Revenues","Interest Rate","Interest","Closing Balance","Annual amounts","Board Approved Smart Meter Funding Adder (from Tariff)"]
[]
[null,"2006 Q1",null,null,null,"2006-01-01",{"$f":"YEAR(F24)","v":2006},{"$f":"IF(MONTH(F24)=0,\"\",IF(MONTH(F24)<4,\"Q1\",IF(MONTH(F24)<7,\"Q2\",IF(MONTH(F24)<10,\"Q3\",\"Q4\"))))","v":"Q1"},{"$f":"CONCATENATE(G24,\" \",H24)","v":"2006 Q1"},0,null,{"$f":"VLOOKUP(I24,$B$22:$D$51,2)","v":0},{"$f":"ROUND(J24*L24/12,2)","v":0},{"$f":"J24+K24+M24","v":0}]
[null,"2006 Q2",4.1399999999999999E-2,4.6800000000000001E-2,null,"2006-02-01",{"$f":"YEAR(F25)","v":2006},{"$f":"IF(MONTH(F25)=0,\"\",IF(MONTH(F25)<4,\"Q1\",IF(MONTH(F25)<7,\"Q2\",IF(MONTH(F25)<10,\"Q3\",\"Q4\"))))","v":"Q1"},{"$f":"CONCATENATE(G25,\" \",H25)","v":"2006 Q1"},{"$f":"J24+K24","v":0},null,0,{"$f":"ROUND(J25*L25/12,2)","v":0},{"$f":"J25+K25+M25","v":0}]
[null,"2006 Q3",4.5900000000000003E-2,5.0500000000000003E-2,null,"2006-03-01",2006,"Q1","2006 Q1",{"$f":"J25+K25","v":0},null,0,0,0]
[null,"2006 Q4",4.5900000000000003E-2,4.7199999999999999E-2,null,"2006-04-01",2006,"Q2","2006 Q2",0,null,4.1399999999999999E-2,0,0]
[null,"2007 Q1",4.5900000000000003E-2,4.7199999999999999E-2,null,"2006-05-01",2006,"Q2","2006 Q2",0,83.46,4.1399999999999999E-2,0,83.46,null,0.26]
[null,"2007 Q2",4.5900000000000003E-2,4.7199999999999999E-2,null,"2006-06-01",2006,"Q2","2006 Q2",83.46,525.72,4.1399999999999999E-2,0.28999999999999998,609.47,null,0.26]
[null,"2007 Q3",4.5900000000000003E-2,5.1799999999999999E-2,null,"2006-07-01",2006,"Q3","2006 Q3",609.18000000000006,557.17999999999995,4.5900000000000003E-2,2.33,1168.69,null,0.26]
[null,"2007 Q4",5.1400000000000001E-2,5.1799999999999999E-2,null,"2006-08-01",2006,"Q3","2006 Q3",1166.3600000000001,686.14,4.5900000000000003E-2,4.46,1856.96,null,0.26]
[null,"2008 Q1",5.1400000000000001E-2,5.1799999999999999E-2,null,"2006-09-01",2006,"Q3","2006 Q3",1852.5,509.34,4.5900000000000003E-2,7.09,2368.9300000000003,null,0.26]
[null,"2008 Q2",4.0800000000000003E-2,5.1799999999999999E-2,null,"2006-10-01",2006,"Q4","2006 Q4",2361.84,600.08000000000004,4.5900000000000003E-2,9.0299999999999994,2970.9500000000003,null,0.26]
[null,"2008 Q3",3.3500000000000002E-2,5.4300000000000001E-2,null,"2006-11-01",2006,"Q4","2006 Q4",2961.92,642.20000000000005,4.5900000000000003E-2,11.33,3615.45,null,0.26]
[null,"2008 Q4",3.3500000000000002E-2,5.4300000000000001E-2,null,"2006-12-01",2006,"Q4","2006 Q4",3604.12,558.48,4.5900000000000003E-2,13.79,4176.3900000000003,{"$f":"SUM(K24:K35)+SUM(M24:M35)","v":4210.92},0.26]
[null,"2009 Q1",2.4500000000000001E-2,6.6100000000000006E-2,null,"2007-01-01",2007,"Q1","2007 Q1",4162.6000000000004,600.34,4.5900000000000003E-2,15.92,4778.8600000000006,null,0.26]
[null,"2009 Q2",0.01,6.6100000000000006E-2,null,"2007-02-01",2007,"Q1","2007 Q1",4762.9400000000005,601.38,4.5900000000000003E-2,18.22,5382.5400000000009,null,0.26]
[null,"2009 Q3",5.4999999999999997E-3,5.67E-2,null,"2007-03-01",2007,"Q1","2007 Q1",5364.3200000000006,643.5,4.5900000000000003E-2,20.52,6028.3400000000011,null,0.26]
[null,"2009 Q4",5.4999999999999997E-3,4.6600000000000003E-2,null,"2007-04-01",2007,"Q2","2007 Q2",6007.8200000000006,558.74,4.5900000000000003E-2,22.98,6589.54,null,0.26]
[null,"2010 Q1",5.4999999999999997E-3,4.3400000000000001E-2,null,"2007-05-01",2007,"Q2","2007 Q2",6566.56,641.16,4.5900000000000003E-2,25.12,7232.84,null,0.26]
[null,"2010 Q2",5.4999999999999997E-3,4.3400000000000001E-2,null,"2007-06-01",2007,"Q2","2007 Q2",7207.72,603.98,4.5900000000000003E-2,27.57,7839.27,null,0.26]
[null,"2010 Q3",8.8999999999999999E-3,4.6600000000000003E-2,null,"2007-07-01",2007,"Q3","2007 Q3",7811.7000000000007,599.55999999999995,4.5900000000000003E-2,29.88,8441.14,null,0.26]
[null,"2010 Q4",1.2E-2,4.0099999999999997E-2,null,"2007-08-01",2007,"Q3","2007 Q3",8411.26,649.22,4.5900000000000003E-2,32.17,9092.65,null,0.26]
[null,"2011 Q1",1.47E-2,4.2900000000000001E-2,null,"2007-09-01",2007,"Q3","2007 Q3",9060.48,514.02,4.5900000000000003E-2,34.659999999999997,9609.16,null,0.26]
[null,"2011 Q2",1.47E-2,4.2900000000000001E-2,null,"2007-10-01",2007,"Q4","2007 Q4",9574.5,652.6,5.1400000000000001E-2,41.01,10268.11,null,0.26]
[null,"2011 Q3",1.47E-2,4.2900000000000001E-2,null,"2007-11-01",2007,"Q4","2007 Q4",10227.1,650.52,5.1400000000000001E-2,43.81,10921.43,null,0.26]
[null,"2011 Q4",{"$f":"C46","v":1.47E-2},4.2900000000000001E-2,null,"2007-12-01",2007,"Q4","2007 Q4",10877.62,518.96,5.1400000000000001E-2,46.59,11443.170000000002,{"$f":"SUM(K36:K47)+SUM(M36:M47)","v":7592.43},0.26]
[null,"2012 Q1",1.47E-2,4.2900000000000001E-2,null,"2008-01-01",2008,"Q1","2008 Q1",11396.580000000002,653.64,5.1400000000000001E-2,48.82,12099.04,null,0.26]
[null,"2012 Q2",1.47E-2,4.2900000000000001E-2,null,"2008-02-01",2008,"Q1","2008 Q1",12050.220000000001,565.24,5.1400000000000001E-2,51.62,12667.080000000002,null,0.26]
[null,"2012 Q3",1.47E-2,4.2900000000000001E-2,null,"2008-03-01",2008,"Q1","2008 Q1",12615.460000000001,514.02,5.1400000000000001E-2,54.04,13183.520000000002,null,0.26]
[null,"2012 Q4",0,4.2900000000000001E-2,null,"2008-04-01",2008,"Q2","2008 Q2",13129.480000000001,648.44000000000005,4.0800000000000003E-2,44.64,13822.560000000001,null,0.26]
[null,null,null,null,null,"2008-05-01",2008,"Q2","2008 Q2",13777.920000000002,604.76,4.0800000000000003E-2,46.84,14429.520000000002,null,0.26]
[null,null,null,null,null,"2008-06-01",2008,"Q2","2008 Q2",14382.680000000002,612.82000000000005,4.0800000000000003E-2,48.9,15044.400000000001,null,0.26]
[null,null,null,null,null,"2008-07-01",2008,"Q3","2008 Q3",14995.500000000002,665.6,3.3500000000000002E-2,41.86,15702.960000000003,null,0.26]
[null,null,null,null,null,"2008-08-01",2008,"Q3","2008 Q3",15661.100000000002,554.58000000000004,3.3500000000000002E-2,43.72,16259.400000000001,null,0.26]
[null,null,null,null,null,"2008-09-01",2008,"Q3","2008 Q3",16215.680000000002,571.22,{"$f":"VLOOKUP(I56,$B$22:$D$51,2)","v":3.3500000000000002E-2},45.27,16832.170000000002,null,0.26]
[null,null,null,null,null,"2008-10-01",2008,"Q4","2008 Q4",16786.900000000001,704.08,3.3500000000000002E-2,46.86,17537.840000000004,null,0.26]
[null,null,null,null,null,"2008-11-01",2008,"Q4","2008 Q4",17490.980000000003,555.62,3.3500000000000002E-2,48.83,18095.430000000004,null,0.26]
[null,null,null,null,null,"2008-12-01",2008,"Q4","2008 Q4",18046.600000000002,611.52,3.3500000000000002E-2,50.38,18708.500000000004,{"$f":"SUM(K48:K59)+SUM(M48:M59)","v":7833.3200000000006},0.26]
[null,null,null,null,null,"2009-01-01",2009,"Q1","2009 Q1",18658.120000000003,608.4,2.4500000000000001E-2,38.090000000000003,19304.610000000004,null,0.26]
[null,null,null,null,null,"2009-02-01",2009,"Q1","2009 Q1",19266.520000000004,528.84,2.4500000000000001E-2,39.340000000000003,19834.700000000004,null,0.26]
[null,null,null,null,null,"2009-03-01",2009,"Q1","2009 Q1",19795.360000000004,555.55999999999995,2.4500000000000001E-2,40.42,20391.340000000004,null,0.26]
[null,null,null,null,null,"2009-04-01",2009,"Q2","2009 Q2",20350.920000000006,695.94,0.01,16.96,21063.820000000003,null,0.26]
[null,null,null,null,null,"2009-05-01",2009,"Q2","2009 Q2",21046.860000000004,580.97,0.01,17.54,21645.370000000006,null,1]
[null,null,null,null,null,"2009-06-01",2009,"Q2","2009 Q2",21627.830000000005,2197.58,0.01,18.02,23843.430000000004,null,1]
[null,null,null,null,null,"2009-07-01",2009,"Q3","2009 Q3",23825.410000000003,2516.9,5.4999999999999997E-3,10.92,26353.230000000003,null,1]
[null,null,null,null,null,"2009-08-01",2009,"Q3","2009 Q3",26342.310000000005,2050.09,5.4999999999999997E-3,12.07,28404.470000000005,null,1]
[null,null,null,null,null,"2009-09-01",2009,"Q3","2009 Q3",28392.400000000005,2513.4299999999998,5.4999999999999997E-3,13.01,30918.840000000004,null,1]
[null,null,null,null,null,"2009-10-01",2009,"Q4","2009 Q4",30905.830000000005,2369.65,5.4999999999999997E-3,14.17,33289.65,null,1]
[null,null,null,null,null,"2009-11-01",2009,"Q4","2009 Q4",33275.480000000003,2369.9299999999998,5.4999999999999997E-3,15.25,35660.660000000003,null,1]
[null,null,null,null,null,"2009-12-01",2009,"Q4","2009 Q4",35645.410000000003,2524.17,5.4999999999999997E-3,16.34,38185.919999999998,{"$f":"SUM(K60:K71)+SUM(M60:M71)","v":19763.59},1]
[null,null,null,null,null,"2010-01-01",2010,"Q1","2010 Q1",38169.58,2210.35,5.4999999999999997E-3,17.489999999999998,40397.42,null,1]
[null,null,null,null,null,"2010-02-01",2010,"Q1","2010 Q1",40379.93,2069.66,5.4999999999999997E-3,18.510000000000002,42468.1,null,1]
[null,null,null,null,null,"2010-03-01",2010,"Q1","2010 Q1",42449.59,2652.72,5.4999999999999997E-3,19.46,45121.77,null,1]
[null,null,null,null,null,"2010-04-01",2010,"Q2","2010 Q2",45102.31,2517.41,5.4999999999999997E-3,20.67,47640.39,null,1]
[null,null,null,null,null,"2010-05-01",2010,"Q2","2010 Q2",47619.72,2385.46,5.4999999999999997E-3,21.83,50027.01,null,1.87]
[null,null,null,null,null,"2010-06-01",2010,"Q2","2010 Q2",50005.18,4292.3900000000003,5.4999999999999997E-3,22.92,54320.49,null,1.87]
[null,null,null,null,null,"2010-07-01",2010,"Q3","2010 Q3",54297.57,4428.59,8.8999999999999999E-3,40.270000000000003,58766.43,null,1.87]
[null,null,null,null,null,"2010-08-01",2010,"Q3","2010 Q3",58726.16,4431.5200000000004,8.8999999999999999E-3,43.56,63201.240000000005,null,1.87]
[null,null,null,null,null,"2010-09-01",2010,"Q3","2010 Q3",63157.680000000008,4428.83,8.8999999999999999E-3,46.84,67633.350000000006,null,1.87]
[null,null,null,null,null,"2010-10-01",2010,"Q4","2010 Q4",67586.510000000009,4140.38,1.2E-2,67.59,71794.48000000001,null,1.87]
[null,null,null,null,null,"2010-11-01",2010,"Q4","2010 Q4",71726.890000000014,4700.62,1.2E-2,71.73,76499.240000000005,null,1.87]
[null,null,null,null,null,"2010-12-01",2010,"Q4","2010 Q4",76427.510000000009,4413.16,1.2E-2,76.430000000000007,80917.100000000006,{"$f":"SUM(K72:K83)+SUM(M72:M83)","v":43138.39},1.87]
[null,null,null,null,null,"2011-01-01",2011,"Q1","2011 Q1",80840.670000000013,4144.55,1.47E-2,99.03,85084.250000000015,null,1.87]
[null,null,null,null,null,"2011-02-01",2011,"Q1","2011 Q1",84985.220000000016,3848.67,1.47E-2,104.11,88938.000000000015,null,1.87]
[null,null,null,null,null,"2011-03-01",2011,"Q1","2011 Q1",88833.890000000014,4974.3100000000004,1.47E-2,108.82,93917.020000000019,null,1.87]
[null,null,null,null,null,"2011-04-01",2011,"Q2","2011 Q2",93808.200000000012,3846.27,1.47E-2,114.92,97769.390000000014,null,1.87]
[null,null,null,null,null,"2011-05-01",2011,"Q2","2011 Q2",97654.470000000016,4393.7299999999996,{"$f":"VLOOKUP(I88,$B$22:$D$51,2)","v":1.47E-2},119.63,102167.83000000002,null,1.87]
[null,null,null,null,null,"2011-06-01",{"$f":"YEAR(F89)","v":2011},{"$f":"IF(MONTH(F89)=0,\"\",IF(MONTH(F89)<4,\"Q1\",IF(MONTH(F89)<7,\"Q2\",IF(MONTH(F89)<10,\"Q3\",\"Q4\"))))","v":"Q2"},{"$f":"CONCATENATE(G89,\" \",H89)","v":"2011 Q2"},102048.20000000001,4652.24,1.47E-2,{"$f":"ROUND(J89*L89/12,2)","v":125.01},{"$f":"J89+K89+M89","v":106825.45000000001},null,1.87]
[null,null,null,null,null,"2011-07-01",2011,"Q3","2011 Q3",{"$f":"J89+K89","v":106700.44000000002},4139.8599999999997,1.47E-2,130.71,110971.01000000002,null,1.87]
[null,null,null,null,null,"2011-08-01",2011,"Q3","2011 Q3",110840.30000000002,4670.45,1.47E-2,135.78,115646.53000000001,null,1.87]
[null,null,null,null,null,"2011-09-01",2011,"Q3","2011 Q3",115510.75000000001,4407.4799999999996,1.47E-2,141.5,120059.73000000001,null,1.87]
[null,null,null,null,null,"2011-10-01",2011,"Q4","2011 Q4",119918.23000000001,4074.93,1.47E-2,146.9,124140.06,null,1.87]
[null,null,null,null,null,"2011-11-01",2011,"Q4","2011 Q4",123993.16,4537.66,1.47E-2,151.88999999999999,128682.71,null,1.87]
[null,null,null,null,null,"2011-12-01",2011,"Q4","2011 Q4",128530.82,4288.82,1.47E-2,157.44999999999999,132977.09000000003,{"$f":"SUM(K84:K95)+SUM(M84:M95)","v":53514.719999999994},1.87]
[null,null,null,null,null,"2012-01-01",2012,"Q1","2012 Q1",132819.64000000001,4326.97,1.47E-2,162.69999999999999,137309.31000000003,null,1.87]
[null,null,null,null,null,"2012-02-01",2012,"Q1","2012 Q1",137146.61000000002,4396.74,1.47E-2,168,141711.35,null,1.87]
[null,null,null,null,null,"2012-03-01",2012,"Q1","2012 Q1",141543.35,4453.8500000000004,1.47E-2,173.39,146170.59000000003,null,1.87]
[null,null,null,null,null,"2012-04-01",2012,"Q2","2012 Q2",145997.20000000001,4256.99,1.47E-2,178.85,150433.04,null,1.87]
[null,null,null,null,null,"2012-05-01",2012,"Q2","2012 Q2",150254.19,4286.41,1.47E-2,184.06,154724.66]
[null,null,null,null,null,"2012-06-01",2012,"Q2","2012 Q2",154540.6,641.92999999999995,1.47E-2,189.31,155371.84]
[null,null,null,null,null,"2012-07-01",2012,"Q3","2012 Q3",155182.53,null,1.47E-2,190.1,155372.63]
[null,null,null,null,null,"2012-08-01",2012,"Q3","2012 Q3",155182.53,null,1.47E-2,190.1,155372.63]
[null,null,null,null,null,"2012-09-01",2012,"Q3","2012 Q3",155182.53,null,1.47E-2,190.1,155372.63]
[null,null,null,null,null,"2012-10-01",2012,"Q4","2012 Q4",155182.53,null,1.47E-2,190.1,155372.63]
[null,null,null,null,null,"2012-11-01",2012,"Q4","2012 Q4",155182.53,null,0,0,155182.53]
[null,null,null,null,null,"2012-12-01",2012,"Q4","2012 Q4",155182.53,null,0,0,155182.53,{"$f":"SUM(K96:K107)+SUM(M96:M107)","v":24179.599999999999}]
[]
[null,null,null,null,null,"Total Funding Adder Revenues Collected",null,null,null,null,{"$f":"SUM(K24:K107)","v":155182.53},null,{"$f":"SUM(M24:M107)","v":5050.4400000000014},{"$f":"K109+M109","v":160232.97},{"$f":"SUM(O24:O107)","v":160232.97}]

{"sheet":"8A. Opex_Interest_monthly","index":8,"n_rows":110,"n_cols":16,"rows_kept":110,"cut":false,"hidden":false,"merged":[[22,3,23,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Account 1556 - Sub-accounts Operating Expenses, Amortization Expenses, Carrying Charges"]
[]
[null,"Prescribed Interest Rates","Approved Deferral and Variance Accounts","CWIP",null,"Date","Year","Quarter",null,"Opening Balance (Principal)","OM&A Expenses","Amortization / Depreciation Expense","Closing Balance (Principal)","(Annual) Interest Rate","Interest (on opening balance)","Cumulative Interest"]
[]
[null,{"$f":"'8. Funding_Adder_Revs'!B24","v":"2006 Q1"},{"$f":"'8. Funding_Adder_Revs'!C24","v":0},{"$f":"'8. Funding_Adder_Revs'!D24","v":0},null,{"$f":"'8. Funding_Adder_Revs'!F24","v":"2006-01-01"},{"$f":"'8. Funding_Adder_Revs'!G24","v":2006},{"$f":"'8. Funding_Adder_Revs'!H24","v":"Q1"},null,0,null,null,{"$f":"J25+K25+L25","v":0},{"$f":"'8. Funding_Adder_Revs'!L24","v":0},{"$f":"J25*N25/12","v":0},{"$f":"O25","v":0}]
[null,{"$f":"'8. Funding_Adder_Revs'!B25","v":"2006 Q2"},{"$f":"'8. Funding_Adder_Revs'!C25","v":4.1399999999999999E-2},{"$f":"'8. Funding_Adder_Revs'!D25","v":4.6800000000000001E-2},null,{"$f":"'8. Funding_Adder_Revs'!F25","v":"2006-02-01"},{"$f":"'8. Funding_Adder_Revs'!G25","v":2006},{"$f":"'8. Funding_Adder_Revs'!H25","v":"Q1"},null,{"$f":"M25","v":0},null,null,{"$f":"J26+K26+L26","v":0},{"$f":"'8. Funding_Adder_Revs'!L25","v":0},{"$f":"J26*N26/12","v":0},{"$f":"O26+P25","v":0}]
[null,{"$f":"'8. Funding_Adder_Revs'!B26","v":"2006 Q3"},{"$f":"'8. Funding_Adder_Revs'!C26","v":4.5900000000000003E-2},{"$f":"'8. Funding_Adder_Revs'!D26","v":5.0500000000000003E-2},null,{"$f":"'8. Funding_Adder_Revs'!F26","v":"2006-03-01"},{"$f":"'8. Funding_Adder_Revs'!G26","v":2006},{"$f":"'8. Funding_Adder_Revs'!H26","v":"Q1"},null,{"$f":"M26","v":0},null,null,0,{"$f":"'8. Funding_Adder_Revs'!L26","v":0},0,{"$f":"O27+P26","v":0}]
[null,{"$f":"'8. Funding_Adder_Revs'!B27","v":"2006 Q4"},{"$f":"'8. Funding_Adder_Revs'!C27","v":4.5900000000000003E-2},{"$f":"'8. Funding_Adder_Revs'!D27","v":4.7199999999999999E-2},null,{"$f":"'8. Funding_Adder_Revs'!F27","v":"2006-04-01"},{"$f":"'8. Funding_Adder_Revs'!G27","v":2006},{"$f":"'8. Funding_Adder_Revs'!H27","v":"Q2"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L27","v":4.1399999999999999E-2},0,0]
[null,{"$f":"'8. Funding_Adder_Revs'!B28","v":"2007 Q1"},{"$f":"'8. Funding_Adder_Revs'!C28","v":4.5900000000000003E-2},{"$f":"'8. Funding_Adder_Revs'!D28","v":4.7199999999999999E-2},null,{"$f":"'8. Funding_Adder_Revs'!F28","v":"2006-05-01"},{"$f":"'8. Funding_Adder_Revs'!G28","v":2006},{"$f":"'8. Funding_Adder_Revs'!H28","v":"Q2"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L28","v":4.1399999999999999E-2},0,0]
[null,{"$f":"'8. Funding_Adder_Revs'!B29","v":"2007 Q2"},{"$f":"'8. Funding_Adder_Revs'!C29","v":4.5900000000000003E-2},{"$f":"'8. Funding_Adder_Revs'!D29","v":4.7199999999999999E-2},null,{"$f":"'8. Funding_Adder_Revs'!F29","v":"2006-06-01"},{"$f":"'8. Funding_Adder_Revs'!G29","v":2006},{"$f":"'8. Funding_Adder_Revs'!H29","v":"Q2"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L29","v":4.1399999999999999E-2},0,0]
[null,{"$f":"'8. Funding_Adder_Revs'!B30","v":"2007 Q3"},{"$f":"'8. Funding_Adder_Revs'!C30","v":4.5900000000000003E-2},{"$f":"'8. Funding_Adder_Revs'!D30","v":5.1799999999999999E-2},null,{"$f":"'8. Funding_Adder_Revs'!F30","v":"2006-07-01"},{"$f":"'8. Funding_Adder_Revs'!G30","v":2006},{"$f":"'8. Funding_Adder_Revs'!H30","v":"Q3"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L30","v":4.5900000000000003E-2},0,0]
[null,{"$f":"'8. Funding_Adder_Revs'!B31","v":"2007 Q4"},{"$f":"'8. Funding_Adder_Revs'!C31","v":5.1400000000000001E-2},{"$f":"'8. Funding_Adder_Revs'!D31","v":5.1799999999999999E-2},null,{"$f":"'8. Funding_Adder_Revs'!F31","v":"2006-08-01"},{"$f":"'8. Funding_Adder_Revs'!G31","v":2006},{"$f":"'8. Funding_Adder_Revs'!H31","v":"Q3"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L31","v":4.5900000000000003E-2},0,0]
[null,{"$f":"'8. Funding_Adder_Revs'!B32","v":"2008 Q1"},{"$f":"'8. Funding_Adder_Revs'!C32","v":5.1400000000000001E-2},{"$f":"'8. Funding_Adder_Revs'!D32","v":5.1799999999999999E-2},null,{"$f":"'8. Funding_Adder_Revs'!F32","v":"2006-09-01"},{"$f":"'8. Funding_Adder_Revs'!G32","v":2006},{"$f":"'8. Funding_Adder_Revs'!H32","v":"Q3"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L32","v":4.5900000000000003E-2},0,0]
[null,{"$f":"'8. Funding_Adder_Revs'!B33","v":"2008 Q2"},{"$f":"'8. Funding_Adder_Revs'!C33","v":4.0800000000000003E-2},{"$f":"'8. Funding_Adder_Revs'!D33","v":5.1799999999999999E-2},null,{"$f":"'8. Funding_Adder_Revs'!F33","v":"2006-10-01"},{"$f":"'8. Funding_Adder_Revs'!G33","v":2006},{"$f":"'8. Funding_Adder_Revs'!H33","v":"Q4"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L33","v":4.5900000000000003E-2},0,0]
[null,{"$f":"'8. Funding_Adder_Revs'!B34","v":"2008 Q3"},{"$f":"'8. Funding_Adder_Revs'!C34","v":3.3500000000000002E-2},{"$f":"'8. Funding_Adder_Revs'!D34","v":5.4300000000000001E-2},null,{"$f":"'8. Funding_Adder_Revs'!F34","v":"2006-11-01"},{"$f":"'8. Funding_Adder_Revs'!G34","v":2006},{"$f":"'8. Funding_Adder_Revs'!H34","v":"Q4"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L34","v":4.5900000000000003E-2},0,0]
[null,{"$f":"'8. Funding_Adder_Revs'!B35","v":"2008 Q4"},{"$f":"'8. Funding_Adder_Revs'!C35","v":3.3500000000000002E-2},{"$f":"'8. Funding_Adder_Revs'!D35","v":5.4300000000000001E-2},null,{"$f":"'8. Funding_Adder_Revs'!F35","v":"2006-12-01"},{"$f":"'8. Funding_Adder_Revs'!G35","v":2006},{"$f":"'8. Funding_Adder_Revs'!H35","v":"Q4"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L35","v":4.5900000000000003E-2},0,0]
[null,{"$f":"'8. Funding_Adder_Revs'!B36","v":"2009 Q1"},{"$f":"'8. Funding_Adder_Revs'!C36","v":2.4500000000000001E-2},{"$f":"'8. Funding_Adder_Revs'!D36","v":6.6100000000000006E-2},null,{"$f":"'8. Funding_Adder_Revs'!F36","v":"2007-01-01"},{"$f":"'8. Funding_Adder_Revs'!G36","v":2007},{"$f":"'8. Funding_Adder_Revs'!H36","v":"Q1"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L36","v":4.5900000000000003E-2},0,0]
[null,{"$f":"'8. Funding_Adder_Revs'!B37","v":"2009 Q2"},{"$f":"'8. Funding_Adder_Revs'!C37","v":0.01},{"$f":"'8. Funding_Adder_Revs'!D37","v":6.6100000000000006E-2},null,{"$f":"'8. Funding_Adder_Revs'!F37","v":"2007-02-01"},{"$f":"'8. Funding_Adder_Revs'!G37","v":2007},{"$f":"'8. Funding_Adder_Revs'!H37","v":"Q1"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L37","v":4.5900000000000003E-2},0,0]
[null,{"$f":"'8. Funding_Adder_Revs'!B38","v":"2009 Q3"},{"$f":"'8. Funding_Adder_Revs'!C38","v":5.4999999999999997E-3},{"$f":"'8. Funding_Adder_Revs'!D38","v":5.67E-2},null,{"$f":"'8. Funding_Adder_Revs'!F38","v":"2007-03-01"},{"$f":"'8. Funding_Adder_Revs'!G38","v":2007},{"$f":"'8. Funding_Adder_Revs'!H38","v":"Q1"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L38","v":4.5900000000000003E-2},0,0]
[null,{"$f":"'8. Funding_Adder_Revs'!B39","v":"2009 Q4"},{"$f":"'8. Funding_Adder_Revs'!C39","v":5.4999999999999997E-3},{"$f":"'8. Funding_Adder_Revs'!D39","v":4.6600000000000003E-2},null,{"$f":"'8. Funding_Adder_Revs'!F39","v":"2007-04-01"},{"$f":"'8. Funding_Adder_Revs'!G39","v":2007},{"$f":"'8. Funding_Adder_Revs'!H39","v":"Q2"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L39","v":4.5900000000000003E-2},0,0]
[null,{"$f":"'8. Funding_Adder_Revs'!B40","v":"2010 Q1"},{"$f":"'8. Funding_Adder_Revs'!C40","v":5.4999999999999997E-3},{"$f":"'8. Funding_Adder_Revs'!D40","v":4.3400000000000001E-2},null,{"$f":"'8. Funding_Adder_Revs'!F40","v":"2007-05-01"},{"$f":"'8. Funding_Adder_Revs'!G40","v":2007},{"$f":"'8. Funding_Adder_Revs'!H40","v":"Q2"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L40","v":4.5900000000000003E-2},0,0]
[null,{"$f":"'8. Funding_Adder_Revs'!B41","v":"2010 Q2"},{"$f":"'8. Funding_Adder_Revs'!C41","v":5.4999999999999997E-3},{"$f":"'8. Funding_Adder_Revs'!D41","v":4.3400000000000001E-2},null,{"$f":"'8. Funding_Adder_Revs'!F41","v":"2007-06-01"},{"$f":"'8. Funding_Adder_Revs'!G41","v":2007},{"$f":"'8. Funding_Adder_Revs'!H41","v":"Q2"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L41","v":4.5900000000000003E-2},0,0]
[null,{"$f":"'8. Funding_Adder_Revs'!B42","v":"2010 Q3"},{"$f":"'8. Funding_Adder_Revs'!C42","v":8.8999999999999999E-3},{"$f":"'8. Funding_Adder_Revs'!D42","v":4.6600000000000003E-2},null,{"$f":"'8. Funding_Adder_Revs'!F42","v":"2007-07-01"},{"$f":"'8. Funding_Adder_Revs'!G42","v":2007},{"$f":"'8. Funding_Adder_Revs'!H42","v":"Q3"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L42","v":4.5900000000000003E-2},0,0]
[null,{"$f":"'8. Funding_Adder_Revs'!B43","v":"2010 Q4"},{"$f":"'8. Funding_Adder_Revs'!C43","v":1.2E-2},{"$f":"'8. Funding_Adder_Revs'!D43","v":4.0099999999999997E-2},null,{"$f":"'8. Funding_Adder_Revs'!F43","v":"2007-08-01"},{"$f":"'8. Funding_Adder_Revs'!G43","v":2007},{"$f":"'8. Funding_Adder_Revs'!H43","v":"Q3"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L43","v":4.5900000000000003E-2},0,0]
[null,{"$f":"'8. Funding_Adder_Revs'!B44","v":"2011 Q1"},{"$f":"'8. Funding_Adder_Revs'!C44","v":1.47E-2},{"$f":"'8. Funding_Adder_Revs'!D44","v":4.2900000000000001E-2},null,{"$f":"'8. Funding_Adder_Revs'!F44","v":"2007-09-01"},{"$f":"'8. Funding_Adder_Revs'!G44","v":2007},{"$f":"'8. Funding_Adder_Revs'!H44","v":"Q3"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L44","v":4.5900000000000003E-2},0,0]
[null,{"$f":"'8. Funding_Adder_Revs'!B45","v":"2011 Q2"},{"$f":"'8. Funding_Adder_Revs'!C45","v":1.47E-2},{"$f":"'8. Funding_Adder_Revs'!D45","v":4.2900000000000001E-2},null,{"$f":"'8. Funding_Adder_Revs'!F45","v":"2007-10-01"},{"$f":"'8. Funding_Adder_Revs'!G45","v":2007},{"$f":"'8. Funding_Adder_Revs'!H45","v":"Q4"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L45","v":5.1400000000000001E-2},0,0]
[null,{"$f":"'8. Funding_Adder_Revs'!B46","v":"2011 Q3"},{"$f":"'8. Funding_Adder_Revs'!C46","v":1.47E-2},{"$f":"'8. Funding_Adder_Revs'!D46","v":4.2900000000000001E-2},null,{"$f":"'8. Funding_Adder_Revs'!F46","v":"2007-11-01"},{"$f":"'8. Funding_Adder_Revs'!G46","v":2007},{"$f":"'8. Funding_Adder_Revs'!H46","v":"Q4"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L46","v":5.1400000000000001E-2},0,0]
[null,{"$f":"'8. Funding_Adder_Revs'!B47","v":"2011 Q4"},{"$f":"'8. Funding_Adder_Revs'!C47","v":1.47E-2},{"$f":"'8. Funding_Adder_Revs'!D47","v":4.2900000000000001E-2},null,{"$f":"'8. Funding_Adder_Revs'!F47","v":"2007-12-01"},{"$f":"'8. Funding_Adder_Revs'!G47","v":2007},{"$f":"'8. Funding_Adder_Revs'!H47","v":"Q4"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L47","v":5.1400000000000001E-2},0,0]
[null,{"$f":"'8. Funding_Adder_Revs'!B48","v":"2012 Q1"},{"$f":"'8. Funding_Adder_Revs'!C48","v":1.47E-2},{"$f":"'8. Funding_Adder_Revs'!D48","v":4.2900000000000001E-2},null,{"$f":"'8. Funding_Adder_Revs'!F48","v":"2008-01-01"},{"$f":"'8. Funding_Adder_Revs'!G48","v":2008},{"$f":"'8. Funding_Adder_Revs'!H48","v":"Q1"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L48","v":5.1400000000000001E-2},0,0]
[null,{"$f":"'8. Funding_Adder_Revs'!B49","v":"2012 Q2"},{"$f":"'8. Funding_Adder_Revs'!C49","v":1.47E-2},{"$f":"'8. Funding_Adder_Revs'!D49","v":4.2900000000000001E-2},null,{"$f":"'8. Funding_Adder_Revs'!F49","v":"2008-02-01"},{"$f":"'8. Funding_Adder_Revs'!G49","v":2008},{"$f":"'8. Funding_Adder_Revs'!H49","v":"Q1"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L49","v":5.1400000000000001E-2},0,0]
[null,{"$f":"'8. Funding_Adder_Revs'!B50","v":"2012 Q3"},{"$f":"'8. Funding_Adder_Revs'!C50","v":1.47E-2},{"$f":"'8. Funding_Adder_Revs'!D50","v":4.2900000000000001E-2},null,{"$f":"'8. Funding_Adder_Revs'!F50","v":"2008-03-01"},{"$f":"'8. Funding_Adder_Revs'!G50","v":2008},{"$f":"'8. Funding_Adder_Revs'!H50","v":"Q1"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L50","v":5.1400000000000001E-2},0,0]
[null,{"$f":"'8. Funding_Adder_Revs'!B51","v":"2012 Q4"},{"$f":"'8. Funding_Adder_Revs'!C51","v":0},{"$f":"'8. Funding_Adder_Revs'!D51","v":4.2900000000000001E-2},null,{"$f":"'8. Funding_Adder_Revs'!F51","v":"2008-04-01"},{"$f":"'8. Funding_Adder_Revs'!G51","v":2008},{"$f":"'8. Funding_Adder_Revs'!H51","v":"Q2"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L51","v":4.0800000000000003E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F52","v":"2008-05-01"},{"$f":"'8. Funding_Adder_Revs'!G52","v":2008},{"$f":"'8. Funding_Adder_Revs'!H52","v":"Q2"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L52","v":4.0800000000000003E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F53","v":"2008-06-01"},{"$f":"'8. Funding_Adder_Revs'!G53","v":2008},{"$f":"'8. Funding_Adder_Revs'!H53","v":"Q2"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L53","v":4.0800000000000003E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F54","v":"2008-07-01"},{"$f":"'8. Funding_Adder_Revs'!G54","v":2008},{"$f":"'8. Funding_Adder_Revs'!H54","v":"Q3"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L54","v":3.3500000000000002E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F55","v":"2008-08-01"},{"$f":"'8. Funding_Adder_Revs'!G55","v":2008},{"$f":"'8. Funding_Adder_Revs'!H55","v":"Q3"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L55","v":3.3500000000000002E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F56","v":"2008-09-01"},{"$f":"'8. Funding_Adder_Revs'!G56","v":2008},{"$f":"'8. Funding_Adder_Revs'!H56","v":"Q3"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L56","v":3.3500000000000002E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F57","v":"2008-10-01"},{"$f":"'8. Funding_Adder_Revs'!G57","v":2008},{"$f":"'8. Funding_Adder_Revs'!H57","v":"Q4"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L57","v":3.3500000000000002E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F58","v":"2008-11-01"},{"$f":"'8. Funding_Adder_Revs'!G58","v":2008},{"$f":"'8. Funding_Adder_Revs'!H58","v":"Q4"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L58","v":3.3500000000000002E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F59","v":"2008-12-01"},{"$f":"'8. Funding_Adder_Revs'!G59","v":2008},{"$f":"'8. Funding_Adder_Revs'!H59","v":"Q4"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L59","v":3.3500000000000002E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F60","v":"2009-01-01"},{"$f":"'8. Funding_Adder_Revs'!G60","v":2009},{"$f":"'8. Funding_Adder_Revs'!H60","v":"Q1"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L60","v":2.4500000000000001E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F61","v":"2009-02-01"},{"$f":"'8. Funding_Adder_Revs'!G61","v":2009},{"$f":"'8. Funding_Adder_Revs'!H61","v":"Q1"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L61","v":2.4500000000000001E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F62","v":"2009-03-01"},{"$f":"'8. Funding_Adder_Revs'!G62","v":2009},{"$f":"'8. Funding_Adder_Revs'!H62","v":"Q1"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L62","v":2.4500000000000001E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F63","v":"2009-04-01"},{"$f":"'8. Funding_Adder_Revs'!G63","v":2009},{"$f":"'8. Funding_Adder_Revs'!H63","v":"Q2"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L63","v":0.01},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F64","v":"2009-05-01"},{"$f":"'8. Funding_Adder_Revs'!G64","v":2009},{"$f":"'8. Funding_Adder_Revs'!H64","v":"Q2"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L64","v":0.01},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F65","v":"2009-06-01"},{"$f":"'8. Funding_Adder_Revs'!G65","v":2009},{"$f":"'8. Funding_Adder_Revs'!H65","v":"Q2"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L65","v":0.01},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F66","v":"2009-07-01"},{"$f":"'8. Funding_Adder_Revs'!G66","v":2009},{"$f":"'8. Funding_Adder_Revs'!H66","v":"Q3"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L66","v":5.4999999999999997E-3},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F67","v":"2009-08-01"},{"$f":"'8. Funding_Adder_Revs'!G67","v":2009},{"$f":"'8. Funding_Adder_Revs'!H67","v":"Q3"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L67","v":5.4999999999999997E-3},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F68","v":"2009-09-01"},{"$f":"'8. Funding_Adder_Revs'!G68","v":2009},{"$f":"'8. Funding_Adder_Revs'!H68","v":"Q3"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L68","v":5.4999999999999997E-3},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F69","v":"2009-10-01"},{"$f":"'8. Funding_Adder_Revs'!G69","v":2009},{"$f":"'8. Funding_Adder_Revs'!H69","v":"Q4"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L69","v":5.4999999999999997E-3},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F70","v":"2009-11-01"},{"$f":"'8. Funding_Adder_Revs'!G70","v":2009},{"$f":"'8. Funding_Adder_Revs'!H70","v":"Q4"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L70","v":5.4999999999999997E-3},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F71","v":"2009-12-01"},{"$f":"'8. Funding_Adder_Revs'!G71","v":2009},{"$f":"'8. Funding_Adder_Revs'!H71","v":"Q4"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L71","v":5.4999999999999997E-3},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F72","v":"2010-01-01"},{"$f":"'8. Funding_Adder_Revs'!G72","v":2010},{"$f":"'8. Funding_Adder_Revs'!H72","v":"Q1"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L72","v":5.4999999999999997E-3},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F73","v":"2010-02-01"},{"$f":"'8. Funding_Adder_Revs'!G73","v":2010},{"$f":"'8. Funding_Adder_Revs'!H73","v":"Q1"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L73","v":5.4999999999999997E-3},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F74","v":"2010-03-01"},{"$f":"'8. Funding_Adder_Revs'!G74","v":2010},{"$f":"'8. Funding_Adder_Revs'!H74","v":"Q1"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L74","v":5.4999999999999997E-3},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F75","v":"2010-04-01"},{"$f":"'8. Funding_Adder_Revs'!G75","v":2010},{"$f":"'8. Funding_Adder_Revs'!H75","v":"Q2"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L75","v":5.4999999999999997E-3},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F76","v":"2010-05-01"},{"$f":"'8. Funding_Adder_Revs'!G76","v":2010},{"$f":"'8. Funding_Adder_Revs'!H76","v":"Q2"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L76","v":5.4999999999999997E-3},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F77","v":"2010-06-01"},{"$f":"'8. Funding_Adder_Revs'!G77","v":2010},{"$f":"'8. Funding_Adder_Revs'!H77","v":"Q2"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L77","v":5.4999999999999997E-3},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F78","v":"2010-07-01"},{"$f":"'8. Funding_Adder_Revs'!G78","v":2010},{"$f":"'8. Funding_Adder_Revs'!H78","v":"Q3"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L78","v":8.8999999999999999E-3},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F79","v":"2010-08-01"},{"$f":"'8. Funding_Adder_Revs'!G79","v":2010},{"$f":"'8. Funding_Adder_Revs'!H79","v":"Q3"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L79","v":8.8999999999999999E-3},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F80","v":"2010-09-01"},{"$f":"'8. Funding_Adder_Revs'!G80","v":2010},{"$f":"'8. Funding_Adder_Revs'!H80","v":"Q3"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L80","v":8.8999999999999999E-3},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F81","v":"2010-10-01"},{"$f":"'8. Funding_Adder_Revs'!G81","v":2010},{"$f":"'8. Funding_Adder_Revs'!H81","v":"Q4"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L81","v":1.2E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F82","v":"2010-11-01"},{"$f":"'8. Funding_Adder_Revs'!G82","v":2010},{"$f":"'8. Funding_Adder_Revs'!H82","v":"Q4"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L82","v":1.2E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F83","v":"2010-12-01"},{"$f":"'8. Funding_Adder_Revs'!G83","v":2010},{"$f":"'8. Funding_Adder_Revs'!H83","v":"Q4"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L83","v":1.2E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F84","v":"2011-01-01"},{"$f":"'8. Funding_Adder_Revs'!G84","v":2011},{"$f":"'8. Funding_Adder_Revs'!H84","v":"Q1"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L84","v":1.47E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F85","v":"2011-02-01"},{"$f":"'8. Funding_Adder_Revs'!G85","v":2011},{"$f":"'8. Funding_Adder_Revs'!H85","v":"Q1"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L85","v":1.47E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F86","v":"2011-03-01"},{"$f":"'8. Funding_Adder_Revs'!G86","v":2011},{"$f":"'8. Funding_Adder_Revs'!H86","v":"Q1"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L86","v":1.47E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F87","v":"2011-04-01"},{"$f":"'8. Funding_Adder_Revs'!G87","v":2011},{"$f":"'8. Funding_Adder_Revs'!H87","v":"Q2"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L87","v":1.47E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F88","v":"2011-05-01"},{"$f":"'8. Funding_Adder_Revs'!G88","v":2011},{"$f":"'8. Funding_Adder_Revs'!H88","v":"Q2"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L88","v":1.47E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F89","v":"2011-06-01"},{"$f":"'8. Funding_Adder_Revs'!G89","v":2011},{"$f":"'8. Funding_Adder_Revs'!H89","v":"Q2"},null,0,null,null,{"$f":"J90+K90+L90","v":0},{"$f":"'8. Funding_Adder_Revs'!L89","v":1.47E-2},{"$f":"J90*N90/12","v":0},0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F90","v":"2011-07-01"},{"$f":"'8. Funding_Adder_Revs'!G90","v":2011},{"$f":"'8. Funding_Adder_Revs'!H90","v":"Q3"},null,{"$f":"M90","v":0},null,null,0,{"$f":"'8. Funding_Adder_Revs'!L90","v":1.47E-2},0,{"$f":"O91+P90","v":0}]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F91","v":"2011-08-01"},{"$f":"'8. Funding_Adder_Revs'!G91","v":2011},{"$f":"'8. Funding_Adder_Revs'!H91","v":"Q3"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L91","v":1.47E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F92","v":"2011-09-01"},{"$f":"'8. Funding_Adder_Revs'!G92","v":2011},{"$f":"'8. Funding_Adder_Revs'!H92","v":"Q3"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L92","v":1.47E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F93","v":"2011-10-01"},{"$f":"'8. Funding_Adder_Revs'!G93","v":2011},{"$f":"'8. Funding_Adder_Revs'!H93","v":"Q4"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L93","v":1.47E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F94","v":"2011-11-01"},{"$f":"'8. Funding_Adder_Revs'!G94","v":2011},{"$f":"'8. Funding_Adder_Revs'!H94","v":"Q4"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L94","v":1.47E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F95","v":"2011-12-01"},{"$f":"'8. Funding_Adder_Revs'!G95","v":2011},{"$f":"'8. Funding_Adder_Revs'!H95","v":"Q4"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L95","v":1.47E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F96","v":"2012-01-01"},{"$f":"'8. Funding_Adder_Revs'!G96","v":2012},{"$f":"'8. Funding_Adder_Revs'!H96","v":"Q1"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L96","v":1.47E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F97","v":"2012-02-01"},{"$f":"'8. Funding_Adder_Revs'!G97","v":2012},{"$f":"'8. Funding_Adder_Revs'!H97","v":"Q1"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L97","v":1.47E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F98","v":"2012-03-01"},{"$f":"'8. Funding_Adder_Revs'!G98","v":2012},{"$f":"'8. Funding_Adder_Revs'!H98","v":"Q1"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L98","v":1.47E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F99","v":"2012-04-01"},{"$f":"'8. Funding_Adder_Revs'!G99","v":2012},{"$f":"'8. Funding_Adder_Revs'!H99","v":"Q2"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L99","v":1.47E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F100","v":"2012-05-01"},{"$f":"'8. Funding_Adder_Revs'!G100","v":2012},{"$f":"'8. Funding_Adder_Revs'!H100","v":"Q2"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L100","v":1.47E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F101","v":"2012-06-01"},{"$f":"'8. Funding_Adder_Revs'!G101","v":2012},{"$f":"'8. Funding_Adder_Revs'!H101","v":"Q2"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L101","v":1.47E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F102","v":"2012-07-01"},{"$f":"'8. Funding_Adder_Revs'!G102","v":2012},{"$f":"'8. Funding_Adder_Revs'!H102","v":"Q3"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L102","v":1.47E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F103","v":"2012-08-01"},{"$f":"'8. Funding_Adder_Revs'!G103","v":2012},{"$f":"'8. Funding_Adder_Revs'!H103","v":"Q3"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L103","v":1.47E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F104","v":"2012-09-01"},{"$f":"'8. Funding_Adder_Revs'!G104","v":2012},{"$f":"'8. Funding_Adder_Revs'!H104","v":"Q3"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L104","v":1.47E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F105","v":"2012-10-01"},{"$f":"'8. Funding_Adder_Revs'!G105","v":2012},{"$f":"'8. Funding_Adder_Revs'!H105","v":"Q4"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L105","v":1.47E-2},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F106","v":"2012-11-01"},{"$f":"'8. Funding_Adder_Revs'!G106","v":2012},{"$f":"'8. Funding_Adder_Revs'!H106","v":"Q4"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L106","v":0},0,0]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F107","v":"2012-12-01"},{"$f":"'8. Funding_Adder_Revs'!G107","v":2012},{"$f":"'8. Funding_Adder_Revs'!H107","v":"Q4"},null,0,null,null,0,{"$f":"'8. Funding_Adder_Revs'!L107","v":0},0,0]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K25:K108)","v":0},{"$f":"SUM(L25:L108)","v":0},{"$f":"K110+L110","v":0}]

{"sheet":"8B. Opex_Interest_annual","index":9,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Year",null,"OM&A",null,"Amortization Expense",null,"Cumulative OM&A and Amortization Expense",null,"Average Cumulative OM&A and Amortization Expense",null,"Average Annual Prescribed Interest Rate for Deferral and Variance Accounts (from Sheets 8A and 8B)",null,"Simple Interest on OM&A and Amortization Expenses"]
[null,null,null,"(from Sheet 5)",null,"(from Sheet 5)"]
[null,2006,null,{"$f":"'5. SM_Rev_Reqt'!G50","v":0},null,{"$f":"'5. SM_Rev_Reqt'!G58","v":0},null,{"$f":"D23+F23","v":0},null,{"$f":"H23/2","v":0},null,{"$f":"AVERAGE('8A. Opex_Interest_monthly'!$C$26:$C$28,'8A. Opex_Interest_monthly'!$C$26)","v":4.3650000000000001E-2},null,{"$f":"J23*L23","v":0}]
[null,2007,null,{"$f":"'5. SM_Rev_Reqt'!I50","v":0},null,{"$f":"'5. SM_Rev_Reqt'!I58","v":339.66666666666669},null,{"$f":"H23+D24+F24","v":339.66666666666669},null,{"$f":"(H24+H23)/2","v":169.83333333333334},null,{"$f":"AVERAGE('8A. Opex_Interest_monthly'!$C$29:$C$32)","v":4.7275000000000005E-2},null,8.0288708333333343]
[null,2008,null,{"$f":"'5. SM_Rev_Reqt'!K50","v":0},null,{"$f":"'5. SM_Rev_Reqt'!K58","v":830.56666666666672},null,1170.2333333333333,null,754.95,null,{"$f":"AVERAGE('8A. Opex_Interest_monthly'!$C$33:$C$36)","v":3.9800000000000002E-2},null,30.047010000000004]
[null,2009,null,{"$f":"'5. SM_Rev_Reqt'!M50","v":17394},null,{"$f":"'5. SM_Rev_Reqt'!M58","v":7961.2666666666664},null,26525.5,null,13847.866666666667,null,{"$f":"AVERAGE('8A. Opex_Interest_monthly'!$C$37:$C$40)","v":1.1375E-2},null,157.51948333333334]
[null,2010,null,{"$f":"'5. SM_Rev_Reqt'!O50","v":25964},null,{"$f":"'5. SM_Rev_Reqt'!O58","v":25931.433333333334},null,78420.933333333334,null,52473.216666666667,null,{"$f":"AVERAGE('8A. Opex_Interest_monthly'!$C$41:$C$44)","v":7.9749999999999995E-3},null,418.47390291666665]
[null,2011,null,{"$f":"'5. SM_Rev_Reqt'!Q50","v":38676},null,{"$f":"'5. SM_Rev_Reqt'!Q58","v":43998.2},null,161095.13333333333,null,119758.03333333333,null,{"$f":"AVERAGE('8A. Opex_Interest_monthly'!$C$45:$C$48)","v":1.47E-2},null,1760.4430899999998]
[null,2012,null,{"$f":"'5. SM_Rev_Reqt'!S50","v":47954},null,{"$f":"'5. SM_Rev_Reqt'!S58","v":51188.866666666661},null,260238,null,210666.56666666665,null,{"$f":"L28","v":1.47E-2},null,3096.7985299999996]
[]
[null,"Cumulative Interest to 2011",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N23:N28)","v":2374.512357083333}]
[null,"Cumulative Interest to 2012",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N23:N29)","v":5471.310887083333}]

{"sheet":"9. SMFA_SMDR_SMIRR","index":10,"n_rows":76,"n_cols":21,"rows_kept":76,"cut":false,"hidden":false,"merged":[[19,1,19,3],[52,5,52,6],[27,2,27,3],[25,6,26,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null," "]
[null,"Check if applicable"]
[]
[null,null,null,null,"Smart Meter Funding Adder (SMFA)"]
[]
[null,null,"X",null,"Smart Meter Disposition Rider (SMDR)",null,"The SMDR is calculated based on costs to December 31, 2011"]
[]
[null,null,"X",null,"Smart Meter Incremental Revenue Requirement Rate Rider (SMIRR)",null,"The SMIRR is calculated based on the incremental revenue requirement associated with the recovery of capital related costs to December 31, 2012 and associated OM&A."]
[]
[null,null,null,null,null,null,2006,null,2007,null,2008,null,2009,null,2010,null,2011,null,"2012 and later",null,"Total"]
[]
[null,null,"Deferred and forecasted Smart Meter Incremental Revenue Requirement (from Sheet 5)",null,null,null,{"$f":"'5. SM_Rev_Reqt'!G70","v":0},null,{"$f":"'5. SM_Rev_Reqt'!I70","v":819.35562599144225},null,{"$f":"'5. SM_Rev_Reqt'!K70","v":1910.9129089722433},null,{"$f":"'5. SM_Rev_Reqt'!M70","v":35633.429641473391},null,{"$f":"'5. SM_Rev_Reqt'!O70","v":79851.145411820995},null,{"$f":"'5. SM_Rev_Reqt'!Q70","v":129779.04876491116},null,{"$f":"'5. SM_Rev_Reqt'!S70","v":150930.54313034756},null,{"$f":"SUM(G30:S30)","v":398924.43548351678}]
[]
[null,null,"Interest on Deferred and forecasted OM&A and Amortization Expense (Sheet 8A/8B)",null,null,null,{"$f":"IF($C35=\"X\",G35,IF($C37=\"X\",G37,0))","v":0},null,{"$f":"IF($C35=\"X\",I35,IF($C37=\"X\",I37,0))","v":8.0288708333333343},null,{"$f":"IF($C35=\"X\",K35,IF($C37=\"X\",K37,0))","v":30.047010000000004},null,{"$f":"IF($C35=\"X\",M35,IF($C37=\"X\",M37,0))","v":157.51948333333334},null,{"$f":"IF($C35=\"X\",O35,IF($C37=\"X\",O37,0))","v":418.47390291666665},null,{"$f":"IF($C35=\"X\",Q35,IF($C37=\"X\",Q37,0))","v":1760.4430899999998},null,{"$f":"IF($C35=\"X\",S35,IF($C37=\"X\",S37,0))","v":2580.6654416666665},null,{"$f":"SUM(G32:S32)","v":4955.1777987499991}]
[null,null,"(Check one of the boxes below)"]
[]
[null,null,null,null,"Sheet 8A (Interest calculated on monthly balances)",null,{"$f":"IF(C35=\"X\",SUM('8A. Opex_Interest_monthly'!O25:O36),\"\")","v":""},null,{"$f":"IF(C35=\"X\",SUM('8A. Opex_Interest_monthly'!O37:O48),\"\")","v":""},null,{"$f":"IF(C35=\"X\",SUM('8A. Opex_Interest_monthly'!O49:O60),\"\")","v":""},null,{"$f":"IF(C35=\"X\",SUM('8A. Opex_Interest_monthly'!O61:O72),\"\")","v":""},null,{"$f":"IF(C35=\"X\",SUM('8A. Opex_Interest_monthly'!O73:O84),\"\")","v":""},null,{"$f":"IF($C35=\"X\",SUM('8A. Opex_Interest_monthly'!O85:O96),\"\")","v":""},null,{"$f":"IF($C35=\"X\",SUM('8A. Opex_Interest_monthly'!O97:O108),\"\")","v":""},null,{"$f":"SUM(G35:S35)","v":0}]
[]
[null,null,"X",null,"Sheet 8B (Interest calculated on average annual balances)",null,{"$f":"IF(C37=\"X\",'8B. Opex_Interest_annual'!N23,\"\")","v":0},null,{"$f":"IF(C37=\"X\",'8B. Opex_Interest_annual'!N24,\"\")","v":8.0288708333333343},null,{"$f":"IF(C37=\"X\",'8B. Opex_Interest_annual'!N25,\"\")","v":30.047010000000004},null,{"$f":"IF(C37=\"X\",'8B. Opex_Interest_annual'!N26,\"\")","v":157.51948333333334},null,{"$f":"IF(C37=\"X\",'8B. Opex_Interest_annual'!N27,\"\")","v":418.47390291666665},null,{"$f":"IF($C37=\"X\",'8B. Opex_Interest_annual'!N28,\"\")","v":1760.4430899999998},null,{"$f":"IF($C37=\"X\",'8B. Opex_Interest_annual'!N29*10/12,0)","v":2580.6654416666665},null,{"$f":"SUM(G37:Q37)","v":2374.512357083333}]
[]
[]
[null,null,"SMFA Revenues (from Sheet 8)",null,null,null,{"$f":"SUM('8. Funding_Adder_Revs'!K24:K35)","v":4162.6000000000004},null,{"$f":"SUM('8. Funding_Adder_Revs'!K36:K47)","v":7233.9800000000005},null,{"$f":"SUM('8. Funding_Adder_Revs'!K48:K59)","v":7261.5400000000009},null,{"$f":"SUM('8. Funding_Adder_Revs'!K60:K71)","v":19511.46},null,{"$f":"SUM('8. Funding_Adder_Revs'!K72:K83)","v":42671.09},null,{"$f":"SUM('8. Funding_Adder_Revs'!K84:K95)","v":51978.969999999994},null,{"$f":"SUM('8. Funding_Adder_Revs'!K96:K107)","v":22362.89},null,{"$f":"SUM(G40:S40)","v":155182.52999999997}]
[]
[null,null,"SMFA Interest (from Sheet 8)",null,null,null,{"$f":"SUM('8. Funding_Adder_Revs'!M24:M35)","v":48.32},null,{"$f":"SUM('8. Funding_Adder_Revs'!M36:M47)","v":358.45000000000005},null,{"$f":"SUM('8. Funding_Adder_Revs'!M48:M59)","v":571.78000000000009},null,{"$f":"SUM('8. Funding_Adder_Revs'!M60:M71)","v":252.12999999999997},null,{"$f":"SUM('8. Funding_Adder_Revs'!M72:M83)","v":467.3},null,{"$f":"SUM('8. Funding_Adder_Revs'!M84:M95)","v":1535.7500000000002},null,{"$f":"SUM('8. Funding_Adder_Revs'!M96:M107)","v":1816.7099999999996},null,{"$f":"SUM(G42:S42)","v":5050.4400000000005}]
[]
[null,null,"Net Deferred Revenue Requirement",null,null,null,{"$f":"(G30+G32)-(G40+G42)","v":-4210.92},null,{"$f":"(I30+I32)-(I40+I42)","v":-6765.0455031752244},null,{"$f":"(K30+K32)-(K40+K42)","v":-5892.3600810277576},null,{"$f":"(M30+M32)-(M40+M42)","v":16027.359124806721},null,{"$f":"(O30+O32)-(O40+O42)","v":37131.229314737662},null,{"$f":"(Q30+Q32)-(Q40+Q42)","v":78024.771854911145},null,{"$f":"(S30+S32)-(S40+S42)","v":129331.60857201423},null,{"$f":"(U30+U32)-(U40+U42)","v":243646.6432822668}]
[]
[null,null,"Number of Metered Customers (average for 2012 test year)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2361]
[]
[null,null,"Calculation of Smart Meter Funding Adder (per metered customer per month)"]
[]
[null,null,null,"Net Deferred Revenues from 2006 to April 30, 2012",null,null,{"$f":"U44","v":243646.6432822668}]
[]
[null,null,null,"SMFA",null,"May 1, 2012 to April 30, 201X",{"$f":"IF(S46=0,\"\",ROUND(S44/(S46*12),2))","v":4.5599999999999996}]
[]
[null,null,null,"Check:  Forecasted SMFA Revenues for 2012 test year",null,null,{"$f":"IF(S46=0,\"\",G52*S46*12)","v":129193.92}]
[]
[null,null,"Calculation of Smart Meter Disposition Rider (per metered customer per month)"]
[]
[null,null,null,"Years for collection or refunding",null,null,1.5]
[]
[null,null,null,"Deferred Incremental Revenue Requirement from 2006 to December 31, 2011",null,null,{"$f":"SUM(G30:Q30)+SUM(G32:S32)","v":252949.07015191924}]
[null,null,null,null,"plus Interest on OM&A and Amortization"]
[null,null,null,"SMFA Revenues collected from 2006 to 2012 test year (inclusive) ",null,null,{"$f":"U40+SUM(G42:S42)","v":160232.96999999997}]
[null,null,null,null,"Plus Simple Interest on SMFA Revenues"]
[null,null,null,"Net Deferred Revenue Requirement",null,null,{"$f":"G60-G62","v":92716.100151919265}]
[]
[null,null,null,"SMDR",null,"November 1, 2012 to April 30, 2014",{"$f":"IF(S46=0,\"\",ROUND(G64/(S46*12*G58),2))","v":2.1800000000000002},null,{"$f":"IF(ISERROR(G68/G64), \"Error\", IF(G68/G64>=95%, \"Match\", \"Error\"))","v":"Match"}]
[]
[null,null,null,"Check:  Forecasted SMDR Revenues",null,null,{"$f":"IF(ISERROR(G66*S46*12*G58), \"\", G66*S46*12*G58)","v":92645.640000000014}]
[]
[null,null,"Calculation of Smart Meter Incremental Revenue Requirement Rate Rider (per metered customer per month)"]
[]
[null,null,null,"Incremental Revenue Requirement for 2012",null,null,{"$f":"S30","v":150930.54313034756}]
[]
[null,null,null,"SMIRR",null,null,{"$f":"IF(ISERROR(ROUND(G72/(S46*12),2)), \"\", ROUND(G72/(S46*12),2))","v":5.33},null,{"$f":"IF(ISERROR(G76/G72), \"Error\", IF(G76/G72>=95%, \"Match\", \"Error\"))","v":"Match"}]
[]
[null,null,null,"Check:  Forecasted SMIRR Revenues",null,null,{"$f":"IF(ISERROR(G74*S46*12), \"\", G74*S46*12)","v":151009.56}]