{"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":21,"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,1]
[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$106, 2,0)","v":"Algoma Power Inc."},{"$f":"VLOOKUP($AB1, $AA$20:$AF$106, MATCH(AC$20, $AA$20:$AF$20,0),FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($AB1, $AA$20:$AF$106, MATCH(AD$20, $AA$20:$AF$20,0),FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($AB1, $AA$20:$AF$106, MATCH(AE$20, $AA$20:$AF$20,0),FALSE)","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2011-12-12",null,"Notes pages removed - kcr"]
[]
[]
[]
[null,null,"Name:","Douglas R. Bradbury"]
[]
[null,null,"Title:","Director, Regulatory Affairs"]
[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-994-3634",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:","doug.bradbury@fortisontario.com",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:","2013-01-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":23,"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,null,2013,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,"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,363,null,9978,null,247,null,null,null,null,null,{"$f":"SUM(G25,I25,K25,M25,O25,Q25,S25,U25)","v":10588}]
[]
[null,null,"General Service < 50 kW",null,null,null,null,null,null,null,null,null,45,null,689,null,213,null,null,null,null,null,{"$f":"SUM(G27,I27,K27,M27,O27,Q27,S27,U27)","v":947}]
[]
[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":408},null,{"$f":"O25+O27","v":10667},null,{"$f":"Q25+Q27","v":460},null,{"$f":"S25+S27","v":0},null,{"$f":"U25+U27","v":0},null,{"$f":"SUM(G29,I29,K29,M29,O29,Q29,S2,U29)","v":11535}]
[]
[null,null,"Percentage of Residential and GS < 50 kW Smart Meter Installations Completed",null,null,null,{"$f":"IF($W29=0,0,G29/$W29)","v":0},null,{"$f":"IF(G31=100%, 0, IF(ISERROR(SUM(G29:I29)/$W29),0,SUM(G29:I29)/$W29))","v":0},null,{"$f":"IF(I31=100%, 0, IF(ISERROR(SUM(G29:K29)/$W29), 0, SUM(G29:K29)/$W29))","v":0},null,{"$f":"IF(K31=100%,0,IF(ISERROR(SUM(G29:M29)/$W29),0,SUM(G29:M29)/$W29))","v":3.5370611183355008E-2},null,{"$f":"IF(M31=100%,0,IF(ISERROR(SUM(G29:O29)/$W29),0,SUM(G29:O29)/$W29))","v":0.96012136974425666},null,{"$f":"IF(O31=100%,0,IF(ISERROR(SUM(G29:Q29)/$W29),0,SUM(G29:Q29)/$W29))","v":1},null,{"$f":"IF(Q31=100%,0,IF(ISERROR(SUM(G29:S29)/$W29),0,SUM(G29:S29)/$W29))","v":0},null,{"$f":"IF(S31=100%,0,IF(ISERROR(SUM(I29:U29)/$W29),0,SUM(I29:U29)/$W29))","v":1},null,{"$f":"IF($W29=0,\"\",W29/$W29)","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,34,null,null,null,null,null,{"$f":"SUM(G33,I33,K33,M33,O33,Q33,S33,U33)","v":34}]
[]
[null,null,"Other (please identify)",null,null,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,U35)","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":408},null,{"$f":"SUM(O29,O33,O35)","v":10667},null,{"$f":"SUM(Q29,Q33,Q35)","v":494},null,{"$f":"SUM(S29,S33,S35)","v":0},null,{"$f":"SUM(U29,U33,U35)","v":0},null,{"$f":"SUM(G37,I37,K37,M37,O37,Q37,S37,U37)","v":11569}]
[]
[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,{"$f":"IF(ISBLANK(U19),\"\",U19)","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,99526,null,886374,null,63315,null,null,null,null,null,{"$f":"SUM(G42,I42,K42,M42,O42,Q42,S42,U42)","v":1049215}]
[]
[null,null,"1.1.2  Installation Costs (may include socket kits, labour, vehicle, benefits, etc.)",null,"Smart Meter",null,null,null,null,null,null,null,15314,null,421129,null,244210,null,null,null,null,null,{"$f":"SUM(G44,I44,K44,M44,O44,Q44,S44,U44)","v":680653}]
[]
[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,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G46,I46,K46,M46,O46,Q46,S46,U46)","v":0}]
[]
[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,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G48,I48,K48,M48,O48,Q48,S48,U48)","v":0}]
[]
[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":0},null,{"$f":"SUM(K42,K44,K46,K48)","v":0},null,{"$f":"SUM(M42,M44,M46,M48)","v":114840},null,{"$f":"SUM(O42,O44,O46,O48)","v":1307503},null,{"$f":"SUM(Q42,Q44,Q46,Q48)","v":307525},null,{"$f":"SUM(S42,S44,S46,S48)","v":0},null,{"$f":"SUM(U42,U44,U46,U48)","v":0},null,{"$f":"W42+W44+W46+W48","v":1729868}]
[]
[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,{"$f":"U41","v":"Forecast"}]
[null,null,"1.2.1  Collectors",null,"Smart Meter",null,null,null,null,null,null,null,1039887,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G54,I54,K54,M54,O54,Q54,S54,U54)","v":1039887}]
[]
[null,null,"1.2.2  Repeaters (may include radio licence, etc.)",null,"Smart Meter",null,null,null,null,null,null,null,32810,null,90327,null,null,null,null,null,15000,null,{"$f":"SUM(G56,I56,K56,M56,O56,Q56,S56,U56)","v":138137}]
[]
[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,187613,null,140096,null,164997,null,52085.13,null,22000,null,{"$f":"SUM(G58,I58,K58,M58,O58,Q58,S58,U58)","v":566791.13}]
[]
[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":1260310},null,{"$f":"O54+O56+O58","v":230423},null,{"$f":"Q54+Q56+Q58","v":164997},null,{"$f":"S54+S56+S58","v":52085.13},null,{"$f":"U54+U56+U58","v":37000},null,{"$f":"W54+W56+W58","v":1744815.13}]
[]
[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,{"$f":"U53","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,null,null,{"$f":"SUM(G64,I64,K64,M64,O64,Q64,S64,U64)","v":0}]
[]
[null,null,"1.3.2  Computer Software",null,"Computer Software",null,null,null,null,null,null,null,950,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G66,I66,K66,M66,O66,Q66,S66,U66)","v":950}]
[]
[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,null,null,{"$f":"SUM(G68,I68,K68,M68,O68,Q68,S68,U68)","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":950},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,{"$f":"W64+W66+W68","v":950}]
[]
[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,{"$f":"U63","v":"Forecast"}]
[]
[null,null,"1.4.1  Activiation Fees",null,"Tools & Equipment",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,U75)","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,{"$f":"W75","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,{"$f":"U73","v":"Forecast"}]
[]
[null,null,"1.5.1  Customer Equipment (including repair of damaged equipment)",null,"Other Equipment",null,null,null,null,null,null,null,123690,null,47681,null,22692,null,null,null,null,null,{"$f":"SUM(G82,I82,K82,M82,O82,Q82,S82,U82)","v":194063}]
[]
[null,null,"1.5.2  AMI Interface to CIS",null,"Computer Software",null,null,null,null,null,null,null,710,null,8805,null,1164,null,null,null,null,null,{"$f":"SUM(G84,I84,K84,M84,O84,Q84,S8,U84)","v":10679}]
[]
[null,null,"1.5.3  Professional Fees",null,"Computer Software",null,null,null,19914,null,33572,null,48351,null,34739,null,14709,null,2990.84,null,null,null,{"$f":"SUM(G86,I86,K86,M86,O86,Q86,S86,U86)","v":154275.84}]
[]
[null,null,"1.5.4  Integration",null,"Computer Software",null,null,null,null,null,null,null,null,null,4988,null,null,null,null,null,null,null,{"$f":"SUM(G88,I88,K88,M88,O88,Q88,S88,U88)","v":4988}]
[]
[null,null,"1.5.5  Program Management",null,"Computer Software",null,null,null,11514,null,45348,null,236267,null,117015,null,52725,null,6248,null,null,null,{"$f":"SUM(G90,I90,K90,M90,O90,Q90,S90,U90)","v":469117}]
[]
[null,null,"1.5.6  Other AMI Capital",null,"Computer Software",null,null,null,null,null,null,null,null,null,16795,null,1500,null,null,null,null,null,{"$f":"SUM(G92,I92,K92,M92,O92,Q92,S92,U92)","v":18295}]
[]
[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":31428},null,{"$f":"SUM(K82,K84,K86,K88,K90,K92)","v":78920},null,{"$f":"SUM(M82,M84,M86,M88,M90,M92)","v":409018},null,{"$f":"SUM(O82,O84,O86,O88,O90,O92)","v":230023},null,{"$f":"SUM(Q82,Q84,Q86,Q88,Q90,Q92)","v":92790},null,{"$f":"SUM(S82,S84,S86,S88,S90,S92)","v":9238.84},null,{"$f":"SUM(U82,U84,U86,U88,U90,U92)","v":0},null,{"$f":"SUM(W82,W84,W86,W88,W90,W92)","v":851417.84}]
[]
[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":31428},null,{"$f":"SUM(K50,K60,K70,K77,K94)","v":78920},null,{"$f":"SUM(M50,M60,M70,M77,M94)","v":1785118},null,{"$f":"SUM(O50,O60,O70,O77,O94)","v":1767949},null,{"$f":"SUM(Q50,Q60,Q70,Q77,Q94)","v":565312},null,{"$f":"SUM(S50,S60,S70,S77,S94)","v":61323.97},null,{"$f":"SUM(U50,U60,U70,U77,U94)","v":37000},null,{"$f":"SUM(W50,W60,W70,W77,W94)","v":4327050.97}]
[]
[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,{"$f":"U80","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G101,I101,K101,M101,O101,Q101,S101,U101)","v":0}]
[]
[null,null,"1.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,null,null,{"$f":"SUM(G103,I103,K103,M103,O103,Q103,S103,U103)","v":0}]
[]
[null,null,"1.6.3  Costs for TOU rate implementation, CIS system upgrades, web presentation,                                     integration with the MDM/R, etc.  ",null,"Computer Software",null,null,null,null,null,null,null,null,null,null,null,43368.83,null,88021.54,null,null,null,{"$f":"SUM(G105,I105,K105,M105,O105,Q105,S105,U105)","v":131390.37}]
[]
[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":0},null,{"$f":"SUM(Q101,Q103,Q105)","v":43368.83},null,{"$f":"SUM(S101,S103,S105)","v":88021.54},null,{"$f":"SUM(U101,U103,U105)","v":0},null,{"$f":"SUM(W101,W103,W105)","v":131390.37}]
[]
[null,null,"Total Smart Meter Capital Costs",null,null,null,{"$f":"G96+G107","v":0},null,{"$f":"I96+I107","v":31428},null,{"$f":"K96+K107","v":78920},null,{"$f":"M96+M107","v":1785118},null,{"$f":"O96+O107","v":1767949},null,{"$f":"Q96+Q107","v":608680.82999999996},null,{"$f":"S96+S107","v":149345.51},null,{"$f":"U96+U107","v":37000},null,{"$f":"W96+W107","v":4458441.34}]
[]
[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,{"$f":"U99","v":"Forecast"}]
[]
[null,null,"2.1.1  Maintenance (may include meter reverification costs, etc.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G114,I114,K114,M114,O114,Q114,S114,U114)","v":0}]
[]
[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,null,null,{"$f":"SUM(G116,I116,K116,M116,O116,Q116,S116,U116)","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":0},null,{"$f":"SUM(O114,O116)","v":0},null,{"$f":"SUM(Q114,Q116)","v":0},null,{"$f":"SUM(S114,S116)","v":0},null,{"$f":"SUM(U114,U116)","v":0},null,{"$f":"SUM(W114,W116)","v":0}]
[]
[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,null,null,{"$f":"119161.13-20102.56","v":99058.57},null,0,null,0,null,null,null,{"$f":"SUM(G122,I122,K122,M122,O122,Q122,S122,U122)","v":99058.57}]
[]
[null,null,"2.2.2  Other (please specifiy)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G124,I124,K124,M124,O124,Q124,S124,U124)","v":0}]
[]
[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":0},null,{"$f":"SUM(O122,O124)","v":99058.57},null,{"$f":"SUM(Q122,Q124)","v":0},null,{"$f":"SUM(S122,S124)","v":0},null,{"$f":"SUM(U122,U124)","v":0},null,{"$f":"SUM(W122,W124)","v":99058.57}]
[]
[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,0,null,null,null,{"$f":"SUM(G130,I130,K130,M130,O130,Q130,S130,U130)","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,null,null,{"$f":"SUM(G132,I132,K132,M132,O132,Q132,S132,U132)","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,null,null,{"$f":"SUM(G134,I134,K134,M134,O134,Q134,S134,U134)","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,{"$f":"SUM(W130,W132,W134)","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,809,null,0,null,0,null,null,null,{"$f":"SUM(G140,I140,K140,M140,O140,Q140,S140,U140)","v":809}]
[]
[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,null,null,{"$f":"SUM(G142,I142,K142,M142,O142,Q142,S142,U142)","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":809},null,{"$f":"SUM(Q140,Q142)","v":0},null,{"$f":"SUM(S140,S142)","v":0},null,{"$f":"SUM(U140,U142)","v":0},null,{"$f":"SUM(W140,W142)","v":809}]
[]
[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,null,null,{"$f":"SUM(G148,I148,K148,M148,O148,Q148,S148,U148)","v":0}]
[]
[null,null,"2.5.2  Customer Communication (may include project communication, etc.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G150,I150,K150,M150,O150,Q150,S150,U150)","v":0}]
[]
[null,null,"2.5.3  Program Management",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUM(G152,I152,K152,M152,O152,Q152,S152,U152)","v":0}]
[]
[null,null,"2.5.4  Change Management (may include training, etc.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G154,I154,K154,M154,O154,Q154,S154,U154)","v":0}]
[]
[null,null,"2.5.5  Administration Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G156,I156,K156,M156,O156,Q156,S156,U156)","v":0}]
[]
[null,null,"2.5.6  Other AMI Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,null,{"$f":"SUM(G158,I158,K158,M158,O158,Q158,S158,U158)","v":0}]
[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":0},null,{"$f":"SUM(O158,O156,O154,O152,O150,O148)","v":0},null,{"$f":"SUM(Q158,Q156,Q154,Q152,Q150,Q148)","v":0},null,{"$f":"SUM(S158,S156,S154,S152,S150,S148)","v":0},null,{"$f":"SUM(U158,U156,U154,U152,U150,U148)","v":0},null,{"$f":"SUM(W154,W156,W158,W152,W150,W148)","v":0}]
[]
[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":0},null,{"$f":"SUM(O118,O126,O136,O144,O160)","v":99867.57},null,{"$f":"SUM(Q118,Q126,Q136,Q144,Q160)","v":0},null,{"$f":"SUM(S118,S126,S136,S144,S160)","v":0},null,{"$f":"SUM(U118,U126,U136,U144,U160)","v":0},null,{"$f":"SUM(W118,W126,W136,W144,W160)","v":99867.57}]
[]
[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,null,null,{"$f":"SUM(G166,I166,K166,M166,O166,Q166,S166,U166)","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,null,null,{"$f":"SUM(G168,I168,K168,M168,O168,Q168,S168,U168)","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,null,null,null,null,null,null,null,null,{"$f":"SUM(G170,I170,K170,M170,O170,Q170,S170,U170)","v":0}]
[]
[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":0},null,{"$f":"SUM(Q166,Q168,Q170)","v":0},null,{"$f":"SUM(S166,S168,S170)","v":0},null,{"$f":"SUM(U166,U168,U170)","v":0},null,{"$f":"SUM(W166,W168,W170)","v":0}]
[]
[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":0},null,{"$f":"O162+O172","v":99867.57},null,{"$f":"Q162+Q172","v":0},null,{"$f":"S162+S172","v":0},null,{"$f":"U162+U172","v":0},null,{"$f":"W162+W172","v":99867.57}]
[]
[]
[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":0},null,{"$f":"SUMIF($E$42:$E$105,$D181,K$42:K$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D181,M$42:M$105)","v":1375150},null,{"$f":"SUMIF($E$42:$E$105,$D181,O$42:O$105)","v":1537926},null,{"$f":"SUMIF($E$42:$E$105,$D181,Q$42:Q$105)","v":472522},null,{"$f":"SUMIF($E$42:$E$105,$D181,S$42:S$105)","v":52085.13},null,{"$f":"SUMIF($E$42:$E$105,$D181,U$42:U$105)","v":37000},null,{"$f":"SUM(G181:U181)","v":3474683.13}]
[]
[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":0},null,{"$f":"SUMIF($E$42:$E$105,$D183,O$42:O$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D183,Q$42:Q$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D183,S$42:S$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D183,U$42:U$105)","v":0},null,{"$f":"SUM(G183:U183)","v":0}]
[]
[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":31428},null,{"$f":"SUMIF($E$42:$E$105,$D185,K$42:K$105)","v":78920},null,{"$f":"SUMIF($E$42:$E$105,$D185,M$42:M$105)","v":286278},null,{"$f":"SUMIF($E$42:$E$105,$D185,O$42:O$105)","v":182342},null,{"$f":"SUMIF($E$42:$E$105,$D185,Q$42:Q$105)","v":113466.83},null,{"$f":"SUMIF($E$42:$E$105,$D185,S$42:S$105)","v":97260.37999999999},null,{"$f":"SUMIF($E$42:$E$105,$D185,U$42:U$105)","v":0},null,{"$f":"SUM(G185:U185)","v":789695.21}]
[]
[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":"SUMIF($E$42:$E$105,$D187,U$42:U$105)","v":0},null,{"$f":"SUM(G187:U187)","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":123690},null,{"$f":"SUMIF($E$42:$E$105,$D189,O$42:O$105)","v":47681},null,{"$f":"SUMIF($E$42:$E$105,$D189,Q$42:Q$105)","v":22692},null,{"$f":"SUMIF($E$42:$E$105,$D189,S$42:S$105)","v":0},null,{"$f":"SUMIF($E$42:$E$105,$D189,U$42:U$105)","v":0},null,{"$f":"SUM(G189:U189)","v":194063}]
[]
[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":"SUMIF($E$42:$E$105,$D191,U$42:U$105)","v":0},null,{"$f":"SUM(G191:U191)","v":0}]
[]
[null,null,"3.1.7","Total Capital Costs",null,null,{"$f":"SUM(G181:G191)","v":0},null,{"$f":"SUM(I181:I191)","v":31428},null,{"$f":"SUM(K181:K191)","v":78920},null,{"$f":"SUM(M181:M191)","v":1785118},null,{"$f":"SUM(O181:O191)","v":1767949},null,{"$f":"SUM(Q181:Q191)","v":608680.82999999996},null,{"$f":"SUM(S181:S191)","v":149345.50999999998},null,{"$f":"SUM(U181:U191)","v":37000},null,{"$f":"SUM(W181:W191)","v":4458441.34}]
[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,{"$f":"IF(W193=W109,\"\",\"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":0},null,{"$f":"O174","v":99867.57},null,{"$f":"Q174","v":0},null,{"$f":"S174","v":0},null,{"$f":"U174","v":0},null,{"$f":"W174","v":99867.57}]

{"sheet":"3. Cost_of_Service_Parameters","index":2,"n_rows":72,"n_cols":21,"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,null,2013]
[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,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,0.5,null,0.5,null,0.5,null,0.56000000000000005,null,{"$f":"Q23-(S22-Q22)","v":0.56000000000000005},null,{"$f":"S23-(U22-S22)","v":0.56000000000000005}]
[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.5},null,{"$f":"100%-M23-M25-M22","v":0.5},null,{"$f":"100%-O23-O25-O22","v":0.5},null,{"$f":"100%-Q23-Q25-Q22","v":0.39999999999999997},null,{"$f":"100%-S23-S25-S22","v":0.39999999999999997},null,{"$f":"100%-U23-U25-U22","v":0.39999999999999997}]
[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,{"$f":"SUM(U22:U25)","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,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,5.7999999999999996E-2,null,6.0999999999999999E-2,null,{"$f":"+I30","v":6.0999999999999999E-2},null,{"$f":"+K30","v":6.0999999999999999E-2},null,6.0999999999999999E-2,null,5.8700000000000002E-2,null,5.8700000000000002E-2,null,5.8700000000000002E-2]
[null,null,null,"Target Return on Equity (ROE)",null,null,8.5699999999999998E-2,null,{"$f":"G31","v":8.5699999999999998E-2},null,8.5699999999999998E-2,null,8.5699999999999998E-2,null,8.5699999999999998E-2,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.1849999999999997E-2},null,{"$f":"SUMPRODUCT(I22:I25,I29:I32)","v":7.3349999999999999E-2},null,{"$f":"SUMPRODUCT(K22:K25,K29:K32)","v":7.3349999999999999E-2},null,{"$f":"SUMPRODUCT(M22:M25,M29:M32)","v":7.3349999999999999E-2},null,{"$f":"SUMPRODUCT(O22:O25,O29:O32)","v":7.3349999999999999E-2},null,{"$f":"SUMPRODUCT(Q22:Q25,Q29:Q32)","v":7.3099999999999998E-2},null,{"$f":"SUMPRODUCT(S22:S25,S29:S32)","v":7.3099999999999998E-2},null,{"$f":"SUMPRODUCT(U22:U25,U29:U32)","v":7.3099999999999998E-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,0.13]
[null,null,"(% of the sum of Cost of Power + controllable expenses)"]
[]
[null,"Taxes/PILs"]
[null,null,"Aggregate Corporate Income Tax Rate",null,null,null,0.36120000000000002,null,0.36120000000000002,null,0.36120000000000002,null,0.36120000000000002,null,0.36120000000000002,null,0.28249999999999997,null,0.26500000000000001,null,0.26500000000000001]
[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,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,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,{"$f":"IF(U45=0,0,1/U45)","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,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,{"$f":"IF(U47=0,0,1/U47)","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,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,{"$f":"IF(U49=0,0,1/U49)","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,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,{"$f":"IF(U51=0,0,1/U51)","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,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,{"$f":"IF(U53=0,0,1/U53)","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,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,0.08]
[]
[null,null,"Computer Equipment - CCA Class",null,null,null,45,null,50,null,50,null,50,null,50,null,50,null,50,null,50]
[null,null,"Computer Equipment - CCA Rate",null,null,null,0.45,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,null,0.55000000000000004,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,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,0.2]
[]
[null,null,"Applications Software - CCA Class"]
[null,null,"Applications Software - CCA Rate"]
[]
[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":21,"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,null,2013]
[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":0},null,{"$f":"K25","v":0},null,{"$f":"M25","v":1375150},null,{"$f":"O25","v":2913076},null,{"$f":"Q25","v":3385598},null,{"$f":"S25","v":3437683.13}]
[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":0},null,{"$f":"'2. Smart_Meter_Costs'!K181","v":0},null,{"$f":"'2. Smart_Meter_Costs'!M181","v":1375150},null,{"$f":"'2. Smart_Meter_Costs'!O181","v":1537926},null,{"$f":"'2. Smart_Meter_Costs'!Q181","v":472522},null,{"$f":"'2. Smart_Meter_Costs'!S181","v":52085.13},null,{"$f":"'2. Smart_Meter_Costs'!U181","v":37000}]
[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":0},null,{"$f":"K22+K23-K24","v":0},null,{"$f":"M22+M23-M24","v":1375150},null,{"$f":"O22+O23-O24","v":2913076},null,{"$f":"Q22+Q23-Q24","v":3385598},null,{"$f":"S22+S23-S24","v":3437683.13},null,{"$f":"U22+U23-U24","v":3474683.13}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"G31","v":0},null,{"$f":"I31","v":0},null,{"$f":"K31","v":0},null,{"$f":"M31","v":-45838.333333333336},null,{"$f":"O31","v":-188779.2},null,{"$f":"Q31","v":-398735},null,{"$f":"S31","v":-626177.7043333333}]
[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":0},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":0},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":-45838.333333333336},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":-142940.86666666667},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":-209955.80000000002},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":-227442.70433333333},null,{"$f":"IF(ISERROR(-(U23/('3. Cost_of_Service_Parameters'!U45*2)+MIN((U22/'3. Cost_of_Service_Parameters'!U45),(U22+U28)))), 0, -(U23/('3. Cost_of_Service_Parameters'!U45*2)+MIN((U22/'3. Cost_of_Service_Parameters'!U45),(U22+U28))))","v":-230412.20866666667}]
[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":0},null,{"$f":"K28+K29-K30","v":0},null,{"$f":"M28+M29-M30","v":-45838.333333333336},null,{"$f":"O28+O29-O30","v":-188779.2},null,{"$f":"Q28+Q29-Q30","v":-398735},null,{"$f":"S28+S29-S30","v":-626177.7043333333},null,{"$f":"U28+U29-U30","v":-856589.91299999994}]
[]
[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":0},null,{"$f":"K35","v":0},null,{"$f":"M35","v":1329311.6666666667},null,{"$f":"O35","v":2724296.8},null,{"$f":"Q35","v":2986863},null,{"$f":"S35","v":2811505.4256666666}]
[null,null,null,"Closing Balance",null,null,{"$f":"G25+G31","v":0},null,{"$f":"I25+I31","v":0},null,{"$f":"K25+K31","v":0},null,{"$f":"M25+M31","v":1329311.6666666667},null,{"$f":"O25+O31","v":2724296.8},null,{"$f":"Q25+Q31","v":2986863},null,{"$f":"S25+S31","v":2811505.4256666666},null,{"$f":"U25+U31","v":2618093.2170000002}]
[null,null,null,"Average Net Book Value",null,null,{"$f":"AVERAGE(G34:G35)","v":0},null,{"$f":"AVERAGE(I34:I35)","v":0},null,{"$f":"AVERAGE(K34:K35)","v":0},null,{"$f":"AVERAGE(M34:M35)","v":664655.83333333337},null,{"$f":"AVERAGE(O34:O35)","v":2026804.2333333334},null,{"$f":"AVERAGE(Q34:Q35)","v":2855579.9},null,{"$f":"AVERAGE(S34:S35)","v":2899184.2128333333},null,{"$f":"AVERAGE(U34:U35)","v":2714799.3213333334}]
[]
[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":0},null,{"$f":"O44","v":0},null,{"$f":"Q44","v":0},null,{"$f":"S44","v":0}]
[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":0},null,{"$f":"'2. Smart_Meter_Costs'!O183","v":0},null,{"$f":"'2. Smart_Meter_Costs'!Q183","v":0},null,{"$f":"'2. Smart_Meter_Costs'!S183","v":0},null,{"$f":"'2. Smart_Meter_Costs'!U183","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":0},null,{"$f":"O41+O42-O43","v":0},null,{"$f":"Q41+Q42-Q43","v":0},null,{"$f":"S41+S42-S43","v":0},null,{"$f":"U41+U42-U43","v":0}]
[]
[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":0},null,{"$f":"O50","v":0},null,{"$f":"Q50","v":0},null,{"$f":"S50","v":0}]
[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":0},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":0},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":0},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":0},null,{"$f":"IF(ISERROR(-(U42/('3. Cost_of_Service_Parameters'!U47*2)+MIN((U41/'3. Cost_of_Service_Parameters'!U47),(U41+U47)))), 0, -(U42/('3. Cost_of_Service_Parameters'!U47*2)+MIN((U41/'3. Cost_of_Service_Parameters'!U47),(U41+U47))))","v":0}]
[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":0},null,{"$f":"O47+O48-O49","v":0},null,{"$f":"Q47+Q48-Q49","v":0},null,{"$f":"S47+S48-S49","v":0},null,{"$f":"U47+U48-U49","v":0}]
[]
[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":0},null,{"$f":"O54","v":0},null,{"$f":"Q54","v":0},null,{"$f":"S54","v":0}]
[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":0},null,{"$f":"O44+O50","v":0},null,{"$f":"Q44+Q50","v":0},null,{"$f":"S44+S50","v":0},null,{"$f":"U44+U50","v":0}]
[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":0},null,{"$f":"AVERAGE(O53:O54)","v":0},null,{"$f":"AVERAGE(Q53:Q54)","v":0},null,{"$f":"AVERAGE(S53:S54)","v":0},null,{"$f":"AVERAGE(U53:U54)","v":0}]
[]
[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":31428},null,{"$f":"K63","v":110348},null,{"$f":"M63","v":396626},null,{"$f":"O63","v":578968},null,{"$f":"Q63","v":692434.83},null,{"$f":"S63","v":789695.21}]
[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":31428},null,{"$f":"'2. Smart_Meter_Costs'!K185+'2. Smart_Meter_Costs'!K191","v":78920},null,{"$f":"'2. Smart_Meter_Costs'!M185+'2. Smart_Meter_Costs'!M191","v":286278},null,{"$f":"'2. Smart_Meter_Costs'!O185+'2. Smart_Meter_Costs'!O191","v":182342},null,{"$f":"'2. Smart_Meter_Costs'!Q185+'2. Smart_Meter_Costs'!Q191","v":113466.83},null,{"$f":"'2. Smart_Meter_Costs'!S185+'2. Smart_Meter_Costs'!S191","v":97260.37999999999},null,{"$f":"'2. Smart_Meter_Costs'!U185+'2. Smart_Meter_Costs'!U191","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":31428},null,{"$f":"K60+K61-K62","v":110348},null,{"$f":"M60+M61-M62","v":396626},null,{"$f":"O60+O61-O62","v":578968},null,{"$f":"Q60+Q61-Q62","v":692434.83},null,{"$f":"S60+S61-S62","v":789695.21},null,{"$f":"U60+U61-U62","v":789695.21}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,0,null,{"$f":"G69","v":0},null,{"$f":"I69","v":-3142.8},null,{"$f":"K69","v":-17320.400000000001},null,{"$f":"M69","v":-68017.799999999988},null,{"$f":"O69","v":-165577.19999999998},null,{"$f":"Q69","v":-292717.48300000001},null,{"$f":"S69","v":-440930.48699999996}]
[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":-3142.8},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":-14177.6},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":-50697.399999999994},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":-97559.4},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":-127140.28300000001},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":-148213.00399999999},null,{"$f":"IF(ISERROR(-(U61/('3. Cost_of_Service_Parameters'!U49*2)+MIN((U60/'3. Cost_of_Service_Parameters'!U49),(U60+U66)))), 0, -(U61/('3. Cost_of_Service_Parameters'!U49*2)+MIN((U60/'3. Cost_of_Service_Parameters'!U49),(U60+U66))))","v":-157939.04199999999}]
[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":-3142.8},null,{"$f":"K66+K67-K68","v":-17320.400000000001},null,{"$f":"M66+M67-M68","v":-68017.799999999988},null,{"$f":"O66+O67-O68","v":-165577.19999999998},null,{"$f":"Q66+Q67-Q68","v":-292717.48300000001},null,{"$f":"S66+S67-S68","v":-440930.48699999996},null,{"$f":"U66+U67-U68","v":-598869.52899999998}]
[]
[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":28285.200000000001},null,{"$f":"K73","v":93027.6},null,{"$f":"M73","v":328608.2},null,{"$f":"O73","v":413390.80000000005},null,{"$f":"Q73","v":399717.34699999995},null,{"$f":"S73","v":348764.723}]
[null,null,null,"Closing Balance",null,null,{"$f":"G63+G69","v":0},null,{"$f":"I63+I69","v":28285.200000000001},null,{"$f":"K63+K69","v":93027.6},null,{"$f":"M63+M69","v":328608.2},null,{"$f":"O63+O69","v":413390.80000000005},null,{"$f":"Q63+Q69","v":399717.34699999995},null,{"$f":"S63+S69","v":348764.723},null,{"$f":"U63+U69","v":190825.68099999998}]
[null,null,null,"Average Net Book Value",null,null,{"$f":"AVERAGE(G72:G73)","v":0},null,{"$f":"AVERAGE(I72:I73)","v":14142.6},null,{"$f":"AVERAGE(K72:K73)","v":60656.4},null,{"$f":"AVERAGE(M72:M73)","v":210817.90000000002},null,{"$f":"AVERAGE(O72:O73)","v":370999.5},null,{"$f":"AVERAGE(Q72:Q73)","v":406554.0735},null,{"$f":"AVERAGE(S72:S73)","v":374241.03499999997},null,{"$f":"AVERAGE(U72:U73)","v":269795.20199999999}]
[]
[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,{"$f":"S82","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,{"$f":"'2. Smart_Meter_Costs'!U187","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,{"$f":"U79+U80-U81","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,{"$f":"S88","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,{"$f":"IF(ISERROR(-(U80/('3. Cost_of_Service_Parameters'!U51*2)+MIN((U79/'3. Cost_of_Service_Parameters'!U51),(U79+U85)))), 0, -(U80/('3. Cost_of_Service_Parameters'!U51*2)+MIN((U79/'3. Cost_of_Service_Parameters'!U51),(U79+U85))))","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,{"$f":"U85+U86-U87","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,{"$f":"S92","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,{"$f":"U82+U88","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,{"$f":"AVERAGE(U91:U92)","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":123690},null,{"$f":"O101","v":171371},null,{"$f":"Q101","v":194063},null,{"$f":"S101","v":194063}]
[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":123690},null,{"$f":"'2. Smart_Meter_Costs'!O189","v":47681},null,{"$f":"'2. Smart_Meter_Costs'!Q189","v":22692},null,{"$f":"'2. Smart_Meter_Costs'!S189","v":0},null,{"$f":"'2. Smart_Meter_Costs'!U189","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":123690},null,{"$f":"O98+O99-O100","v":171371},null,{"$f":"Q98+Q99-Q100","v":194063},null,{"$f":"S98+S99-S100","v":194063},null,{"$f":"U98+U99-U100","v":194063}]
[]
[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":-6184.5},null,{"$f":"O107","v":-20937.55},null,{"$f":"Q107","v":-39209.25},null,{"$f":"S107","v":-58615.55}]
[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":-6184.5},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":-14753.05},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":-18271.699999999997},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":-19406.3},null,{"$f":"IF(ISERROR(-(U99/('3. Cost_of_Service_Parameters'!U53*2)+MIN((U98/'3. Cost_of_Service_Parameters'!U53),(U98+U104)))), 0, -(U99/('3. Cost_of_Service_Parameters'!U53*2)+MIN((U98/'3. Cost_of_Service_Parameters'!U53),(U98+U104))))","v":-19406.3}]
[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":-6184.5},null,{"$f":"O104+O105-O106","v":-20937.55},null,{"$f":"Q104+Q105-Q106","v":-39209.25},null,{"$f":"S104+S105-S106","v":-58615.55},null,{"$f":"U104+U105-U106","v":-78021.850000000006}]
[]
[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":117505.5},null,{"$f":"O111","v":150433.45000000001},null,{"$f":"Q111","v":154853.75},null,{"$f":"S111","v":135447.45000000001}]
[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":117505.5},null,{"$f":"O101+O107","v":150433.45000000001},null,{"$f":"Q101+Q107","v":154853.75},null,{"$f":"S101+S107","v":135447.45000000001},null,{"$f":"U101+U107","v":116041.15}]
[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":58752.75},null,{"$f":"AVERAGE(O110:O111)","v":133969.47500000001},null,{"$f":"AVERAGE(Q110:Q111)","v":152643.6},null,{"$f":"AVERAGE(S110:S111)","v":145150.6},null,{"$f":"AVERAGE(U110:U111)","v":125744.3}]

{"sheet":"5. SM_Rev_Reqt","index":4,"n_rows":70,"n_cols":21,"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,null,2013]
[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":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!K36","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!M36","v":664655.83333333337},null,{"$f":"'4. SM_Assets_and_Rate_Base'!O36","v":2026804.2333333334},null,{"$f":"'4. SM_Assets_and_Rate_Base'!Q36","v":2855579.9},null,{"$f":"'4. SM_Assets_and_Rate_Base'!S36","v":2899184.2128333333},null,{"$f":"'4. SM_Assets_and_Rate_Base'!U36","v":2714799.3213333334}]
[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":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!O55","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!Q55","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!S55","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!U55","v":0}]
[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":14142.6},null,{"$f":"'4. SM_Assets_and_Rate_Base'!K74","v":60656.4},null,{"$f":"'4. SM_Assets_and_Rate_Base'!M74","v":210817.90000000002},null,{"$f":"'4. SM_Assets_and_Rate_Base'!O74","v":370999.5},null,{"$f":"'4. SM_Assets_and_Rate_Base'!Q74","v":406554.0735},null,{"$f":"'4. SM_Assets_and_Rate_Base'!S74","v":374241.03499999997},null,{"$f":"'4. SM_Assets_and_Rate_Base'!U74","v":269795.20199999999}]
[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,{"$f":"'4. SM_Assets_and_Rate_Base'!U93","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":58752.75},null,{"$f":"'4. SM_Assets_and_Rate_Base'!O112","v":133969.47500000001},null,{"$f":"'4. SM_Assets_and_Rate_Base'!Q112","v":152643.6},null,{"$f":"'4. SM_Assets_and_Rate_Base'!S112","v":145150.6},null,{"$f":"'4. SM_Assets_and_Rate_Base'!U112","v":125744.3}]
[null,null,"Total Net Fixed Assets",null,null,null,{"$f":"SUM(G20:G24)","v":0},null,{"$f":"SUM(I20:I24)","v":14142.6},null,{"$f":"SUM(K20:K24)","v":60656.4},null,{"$f":"SUM(M20:M24)","v":934226.4833333334},null,{"$f":"SUM(O20:O24)","v":2531773.2083333335},null,{"$f":"SUM(Q20:Q24)","v":3414777.5734999999},null,{"$f":"SUM(S20:S24)","v":3418575.8478333335},null,{"$f":"SUM(U20:U24)","v":3110338.8233333332}]
[]
[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":0},null,{"$f":"'2. Smart_Meter_Costs'!O174","v":99867.57},null,{"$f":"'2. Smart_Meter_Costs'!Q174","v":0},null,{"$f":"'2. Smart_Meter_Costs'!S174","v":0},null,{"$f":"'2. Smart_Meter_Costs'!U174","v":0}]
[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,{"$f":"'3. Cost_of_Service_Parameters'!U36","v":0.13}]
[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":0},null,{"$f":"O28*O29","v":14980.1355},null,{"$f":"Q28*Q29","v":0},null,{"$f":"S28*S29","v":0},null,{"$f":"U28*U29","v":0}]
[]
[null,"Incremental Smart Meter Rate Base",null,null,null,null,{"$f":"G25+G30","v":0},null,{"$f":"I25+I30","v":14142.6},null,{"$f":"K25+K30","v":60656.4},null,{"$f":"M25+M30","v":934226.4833333334},null,{"$f":"O25+O30","v":2546753.3438333333},null,{"$f":"Q25+Q30","v":3414777.5734999999},null,{"$f":"S25+S30","v":3418575.8478333335},null,{"$f":"U25+U30","v":3110338.8233333332}]
[]
[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":0},null,{"$f":"Q$32*'3. Cost_of_Service_Parameters'!Q22","v":136591.10294000001},null,{"$f":"S$32*'3. Cost_of_Service_Parameters'!S22","v":136743.03391333335},null,{"$f":"U$32*'3. Cost_of_Service_Parameters'!U22","v":124413.55293333333}]
[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":7071.3},null,{"$f":"K$32*'3. Cost_of_Service_Parameters'!K23","v":30328.2},null,{"$f":"M$32*'3. Cost_of_Service_Parameters'!M23","v":467113.2416666667},null,{"$f":"O$32*'3. Cost_of_Service_Parameters'!O23","v":1273376.6719166667},null,{"$f":"Q$32*'3. Cost_of_Service_Parameters'!Q23","v":1912275.4411600002},null,{"$f":"S$32*'3. Cost_of_Service_Parameters'!S23","v":1914402.4747866669},null,{"$f":"U$32*'3. Cost_of_Service_Parameters'!U23","v":1741789.7410666668}]
[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":7071.3},null,{"$f":"K$32*'3. Cost_of_Service_Parameters'!K24","v":30328.2},null,{"$f":"M$32*'3. Cost_of_Service_Parameters'!M24","v":467113.2416666667},null,{"$f":"O$32*'3. Cost_of_Service_Parameters'!O24","v":1273376.6719166667},null,{"$f":"Q$32*'3. Cost_of_Service_Parameters'!Q24","v":1365911.0293999999},null,{"$f":"S$32*'3. Cost_of_Service_Parameters'!S24","v":1367430.3391333334},null,{"$f":"U$32*'3. Cost_of_Service_Parameters'!U24","v":1244135.5293333333}]
[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,{"$f":"U$32*'3. Cost_of_Service_Parameters'!U25","v":0}]
[null,null,"Total Capitalization",null,null,null,{"$f":"SUM(G36:G39)","v":0},null,{"$f":"SUM(I36:I39)","v":14142.6},null,{"$f":"SUM(K36:K39)","v":60656.4},null,{"$f":"SUM(M36:M39)","v":934226.4833333334},null,{"$f":"SUM(O36:O39)","v":2546753.3438333333},null,{"$f":"SUM(Q36:Q39)","v":3414777.5734999999},null,{"$f":"SUM(S36:S39)","v":3418575.8478333335},null,{"$f":"SUM(U36:U39)","v":3110338.8233333332}]
[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,{"$f":"IF(U40=U32,\"\",\"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":0},null,{"$f":"Q36*'3. Cost_of_Service_Parameters'!Q29","v":2827.4358308580004},null,{"$f":"S36*'3. Cost_of_Service_Parameters'!S29","v":2830.5808020060003},null,{"$f":"U36*'3. Cost_of_Service_Parameters'!U29","v":2575.3605457199997}]
[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":431.34930000000003},null,{"$f":"K37*'3. Cost_of_Service_Parameters'!K30","v":1850.0201999999999},null,{"$f":"M37*'3. Cost_of_Service_Parameters'!M30","v":28493.90774166667},null,{"$f":"O37*'3. Cost_of_Service_Parameters'!O30","v":77675.976986916663},null,{"$f":"Q37*'3. Cost_of_Service_Parameters'!Q30","v":112250.56839609201},null,{"$f":"S37*'3. Cost_of_Service_Parameters'!S30","v":112375.42526997735},null,{"$f":"U37*'3. Cost_of_Service_Parameters'!U30","v":102243.05780061334}]
[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":606.01040999999998},null,{"$f":"K38*'3. Cost_of_Service_Parameters'!K31","v":2599.1267400000002},null,{"$f":"M38*'3. Cost_of_Service_Parameters'!M31","v":40031.604810833334},null,{"$f":"O38*'3. Cost_of_Service_Parameters'!O31","v":109128.38078325833},null,{"$f":"Q38*'3. Cost_of_Service_Parameters'!Q31","v":134542.23639589999},null,{"$f":"S38*'3. Cost_of_Service_Parameters'!S31","v":134691.88840463336},null,{"$f":"U38*'3. Cost_of_Service_Parameters'!U31","v":122547.34963933333}]
[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,{"$f":"U39*'3. Cost_of_Service_Parameters'!U32","v":0}]
[null,null,"Total Return on Capital",null,null,null,{"$f":"SUM(G43:G46)","v":0},null,{"$f":"SUM(I43:I46)","v":1037.35971},null,{"$f":"SUM(K43:K46)","v":4449.1469400000005},null,{"$f":"SUM(M43:M46)","v":68525.512552500004},null,{"$f":"SUM(O43:O46)","v":186804.35777017497},null,{"$f":"SUM(Q43:Q46)","v":249620.24062285002},null,{"$f":"SUM(S43:S46)","v":249897.8944766167},null,{"$f":"SUM(U43:U46)","v":227365.76798566669}]
[]
[]
[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":0},null,{"$f":"O28","v":99867.57},null,{"$f":"Q28","v":0},null,{"$f":"S28","v":0},null,{"$f":"U28","v":0}]
[]
[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":0},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!K29","v":0},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!M29","v":45838.333333333336},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!O29","v":142940.86666666667},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!Q29","v":209955.80000000002},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!S29","v":227442.70433333333},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!U29","v":230412.20866666667}]
[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":0},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!O48","v":0},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!Q48","v":0},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!S48","v":0},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!U48","v":0}]
[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":3142.8},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!K67","v":14177.6},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!M67","v":50697.399999999994},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!O67","v":97559.4},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!Q67","v":127140.28300000001},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!S67","v":148213.00399999999},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!U67","v":157939.04199999999}]
[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,{"$f":"-'4. SM_Assets_and_Rate_Base'!U86","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":6184.5},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!O105","v":14753.05},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!Q105","v":18271.699999999997},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!S105","v":19406.3},null,{"$f":"-'4. SM_Assets_and_Rate_Base'!U105","v":19406.3}]
[null,null,"Total Amortization Expense in Year",null,null,null,{"$f":"SUM(G53:G57)","v":0},null,{"$f":"SUM(I53:I57)","v":3142.8},null,{"$f":"SUM(K53:K57)","v":14177.6},null,{"$f":"SUM(M53:M57)","v":102720.23333333334},null,{"$f":"SUM(O53:O57)","v":255253.31666666665},null,{"$f":"SUM(Q53:Q57)","v":355367.78300000005},null,{"$f":"SUM(S53:S57)","v":395062.0083333333},null,{"$f":"SUM(U53:U57)","v":407757.55066666665}]
[]
[null,"Incremental Revenue Requirement before Taxes/PILs",null,null,null,null,{"$f":"G47+G50+G58","v":0},null,{"$f":"I47+I50+I58","v":4180.1597099999999},null,{"$f":"K47+K50+K58","v":18626.746940000001},null,{"$f":"M47+M50+M58","v":171245.74588583334},null,{"$f":"O47+O50+O58","v":541925.24443684169},null,{"$f":"Q47+Q50+Q58","v":604988.02362285007},null,{"$f":"S47+S50+S58","v":644959.90280995006},null,{"$f":"U47+U50+U58","v":635123.31865233334}]
[]
[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":0},null,{"$f":"O50","v":99867.57},null,{"$f":"Q50","v":0},null,{"$f":"S50","v":0},null,{"$f":"U50","v":0}]
[null,null,"Amortization Expense",null,null,null,{"$f":"G58","v":0},null,{"$f":"I58","v":3142.8},null,{"$f":"K58","v":14177.6},null,{"$f":"M58","v":102720.23333333334},null,{"$f":"O58","v":255253.31666666665},null,{"$f":"Q58","v":355367.78300000005},null,{"$f":"S58","v":395062.0083333333},null,{"$f":"U58","v":407757.55066666665}]
[null,null,"Interest Expense",null,null,null,{"$f":"G43+G44","v":0},null,{"$f":"I43+I44","v":431.34930000000003},null,{"$f":"K43+K44","v":1850.0201999999999},null,{"$f":"M43+M44","v":28493.90774166667},null,{"$f":"O43+O44","v":77675.976986916663},null,{"$f":"Q43+Q44","v":115078.00422695001},null,{"$f":"S43+S44","v":115206.00607198336},null,{"$f":"U43+U44","v":104818.41834633335}]
[null,null,"Net Income for Taxes/PILs",null,null,null,{"$f":"G60-SUM(G63:G65)","v":0},null,{"$f":"I60-SUM(I63:I65)","v":606.01040999999987},null,{"$f":"K60-SUM(K63:K65)","v":2599.1267399999997},null,{"$f":"M60-SUM(M63:M65)","v":40031.604810833349},null,{"$f":"O60-SUM(O63:O65)","v":109128.38078325836},null,{"$f":"Q60-SUM(Q63:Q65)","v":134542.23639590002},null,{"$f":"S60-SUM(S63:S65)","v":134691.88840463338},null,{"$f":"U60-SUM(U63:U65)","v":122547.34963933332}]
[]
[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":-2703.5356949718225},null,{"$f":"'7_Taxes_PILs'!G59","v":-9662.1619130118997},null,{"$f":"'7_Taxes_PILs'!I59","v":-18881.85285992016},null,{"$f":"'7_Taxes_PILs'!K59","v":-3626.7478222872473},null,{"$f":"'7_Taxes_PILs'!M59","v":25306.846369833922},null,{"$f":"'7_Taxes_PILs'!O59","v":49365.613018577496},null,{"$f":"'7_Taxes_PILs'!S59","v":0}]
[]
[null,"Revenue Requirement, including Grossed-up Taxes/PILs",null,null,null,null,{"$f":"G60+G68","v":0},null,{"$f":"I60+I68","v":1476.6240150281774},null,{"$f":"K60+K68","v":8964.5850269881012},null,{"$f":"M60+M68","v":152363.89302591319},null,{"$f":"O60+O68","v":538298.49661455443},null,{"$f":"Q60+Q68","v":630294.86999268399},null,{"$f":"S60+S68","v":694325.51582852751},null,{"$f":"U60+U68","v":635123.31865233334}]

{"sheet":"6. UCC_Calculation","index":5,"n_rows":76,"n_cols":16,"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},null,{"$f":"'2. Smart_Meter_Costs'!U18","v":2013}]
[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"},null,{"$f":"'2. Smart_Meter_Costs'!U19","v":"Forecast"}]
[]
["Opening UCC",0,null,{"$f":"B26-B31","v":0},null,{"$f":"D26-D31","v":0},null,{"$f":"F26-F31","v":0},null,{"$f":"H26-H31","v":1320144},null,{"$f":"J26-J31","v":2690941.44},null,{"$f":"L26-L31","v":2929287.2448},null,{"$f":"N26-N31","v":2744945.9900159999}]
["Capital Additions",{"$f":"'4. SM_Assets_and_Rate_Base'!G23","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!I23","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!K23","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!M23","v":1375150},null,{"$f":"'4. SM_Assets_and_Rate_Base'!O23","v":1537926},null,{"$f":"'4. SM_Assets_and_Rate_Base'!Q23","v":472522},null,{"$f":"'4. SM_Assets_and_Rate_Base'!S23","v":52085.13},null,{"$f":"'4. SM_Assets_and_Rate_Base'!U23","v":37000}]
["Retirements/Removals (if applicable)"]
["UCC Before Half Year Rule",{"$f":"SUM(B23:B24)-B25","v":0},null,{"$f":"SUM(D23:D24)-D25","v":0},null,{"$f":"SUM(F23:F24)-F25","v":0},null,{"$f":"SUM(H23:H24)-H25","v":1375150},null,{"$f":"SUM(J23:J24)-J25","v":2858070},null,{"$f":"SUM(L23:L24)-L25","v":3163463.44},null,{"$f":"SUM(N23:N24)-N25","v":2981372.3747999999},null,{"$f":"SUM(P23:P24)-P25","v":2781945.9900159999}]
["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":0},null,{"$f":"IF(((F24-F25)/2)<0, 0, (F24-F25)/2)","v":0},null,{"$f":"IF(((H24-H25)/2)<0, 0, (H24-H25)/2)","v":687575},null,{"$f":"IF(((J24-J25)/2)<0, 0, (J24-J25)/2)","v":768963},null,{"$f":"IF(((L24-L25)/2)<0, 0, (L24-L25)/2)","v":236261},null,{"$f":"IF(((N24-N25)/2)<0, 0, (N24-N25)/2)","v":26042.564999999999},null,{"$f":"IF(((P24-P25)/2)<0, 0, (P24-P25)/2)","v":18500}]
["Reduced UCC",{"$f":"B27+B23","v":0},null,{"$f":"D27+D23","v":0},null,{"$f":"F27+F23","v":0},null,{"$f":"H27+H23","v":687575},null,{"$f":"J27+J23","v":2089107},null,{"$f":"L27+L23","v":2927202.44},null,{"$f":"N27+N23","v":2955329.8097999999},null,{"$f":"P27+P23","v":2763445.9900159999}]
["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},null,{"$f":"'3. Cost_of_Service_Parameters'!U57","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},null,{"$f":"'3. Cost_of_Service_Parameters'!U58","v":0.08}]
["CCA",{"$f":"B28*B30","v":0},null,{"$f":"D28*D30","v":0},null,{"$f":"F28*F30","v":0},null,{"$f":"H28*H30","v":55006},null,{"$f":"J28*J30","v":167128.56},null,{"$f":"L28*L30","v":234176.19519999999},null,{"$f":"N28*N30","v":236426.38478399999},null,{"$f":"P28*P30","v":221075.67920128}]
["Closing UCC",{"$f":"IF((B26-B31)<0, 0, B26-B31)","v":0},null,{"$f":"IF((D26-D31)<0, 0, D26-D31)","v":0},null,{"$f":"IF((F26-F31)<0, 0, F26-F31)","v":0},null,{"$f":"IF((H26-H31)<0, 0, H26-H31)","v":1320144},null,{"$f":"IF((J26-J31)<0, 0, J26-J31)","v":2690941.44},null,{"$f":"IF((L26-L31)<0, 0, L26-L31)","v":2929287.2448},null,{"$f":"IF((N26-N31)<0, 0, N26-N31)","v":2744945.9900159999},null,{"$f":"IF((P26-P31)<0, 0, P26-P31)","v":2560870.3108147196}]
[]
["UCC - Computer Equipment",{"$f":"B20","v":2006},null,2007,null,2008,null,2009,null,2010,null,2011,null,{"$f":"N20","v":2012},null,{"$f":"P20","v":2013}]
[null,"Audited Actual",null,"Audited Actual",null,"Audited Actual",null,"Audited Actual",null,"Audited Actual",null,"Audited Actual",null,{"$f":"N21","v":"Forecast"},null,{"$f":"P21","v":"Forecast"}]
[]
["Opening UCC",0,null,{"$f":"B41-B46","v":0},null,{"$f":"D41-D46","v":22785.3},null,{"$f":"F41-F46","v":67470.385000000009},null,{"$f":"H41-H46","v":237913.22324999998},null,{"$f":"J41-J46","v":239258.90046249997},null,{"$f":"L41-L46","v":189929.95695812497},null,{"$f":"N41-N46","v":155982.2561311562}]
["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":0},null,{"$f":"'2. Smart_Meter_Costs'!O183","v":0},null,{"$f":"'2. Smart_Meter_Costs'!Q183","v":0},null,{"$f":"'2. Smart_Meter_Costs'!S183","v":0},null,{"$f":"'2. Smart_Meter_Costs'!U183","v":0}]
["Capital Additions Computer Software",{"$f":"'2. Smart_Meter_Costs'!G185","v":0},null,{"$f":"'2. Smart_Meter_Costs'!I185","v":31428},null,{"$f":"'2. Smart_Meter_Costs'!K185","v":78920},null,{"$f":"'2. Smart_Meter_Costs'!M185","v":286278},null,{"$f":"'2. Smart_Meter_Costs'!O185","v":182342},null,{"$f":"'2. Smart_Meter_Costs'!Q185","v":113466.83},null,{"$f":"'2. Smart_Meter_Costs'!S185","v":97260.37999999999},null,{"$f":"'2. Smart_Meter_Costs'!U185","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":31428},null,{"$f":"SUM(F37:F39)-F40","v":101705.3},null,{"$f":"SUM(H37:H39)-H40","v":353748.38500000001},null,{"$f":"SUM(J37:J39)-J40","v":420255.22324999998},null,{"$f":"SUM(L37:L39)-L40","v":352725.73046249995},null,{"$f":"SUM(N37:N39)-N40","v":287190.33695812494},null,{"$f":"SUM(P37:P39)-P40","v":155982.2561311562}]
["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":15714},null,{"$f":"IF((SUM(F38:F39)/2)<0, 0, SUM(F38:F39)/2)","v":39460},null,{"$f":"IF((SUM(H38:H39)/2)<0, 0, SUM(H38:H39)/2)","v":143139},null,{"$f":"IF((SUM(J38:J39)/2)<0, 0, SUM(J38:J39)/2)","v":91171},null,{"$f":"IF((SUM(L38:L39)/2)<0, 0, SUM(L38:L39)/2)","v":56733.415000000001},null,{"$f":"IF((SUM(N38:N39)/2)<0, 0, SUM(N38:N39)/2)","v":48630.189999999995},null,{"$f":"IF((SUM(P38:P39)/2)<0, 0, SUM(P38:P39)/2)","v":0}]
["Reduced UCC",{"$f":"B42+B37","v":0},null,{"$f":"D42+D37","v":15714},null,{"$f":"F42+F37","v":62245.3},null,{"$f":"H42+H37","v":210609.38500000001},null,{"$f":"J42+J37","v":329084.22324999998},null,{"$f":"L42+L37","v":295992.31546249997},null,{"$f":"N42+N37","v":238560.14695812497},null,{"$f":"P42+P37","v":155982.2561311562}]
["CCA Rate Class",{"$f":"'3. Cost_of_Service_Parameters'!G60","v":45},null,{"$f":"'3. Cost_of_Service_Parameters'!I60","v":50},null,{"$f":"'3. Cost_of_Service_Parameters'!K60","v":50},null,{"$f":"'3. Cost_of_Service_Parameters'!M60","v":50},null,{"$f":"'3. Cost_of_Service_Parameters'!O60","v":50},null,{"$f":"'3. Cost_of_Service_Parameters'!Q60","v":50},null,{"$f":"'3. Cost_of_Service_Parameters'!S60","v":50},null,{"$f":"'3. Cost_of_Service_Parameters'!U60","v":50}]
["CCA Rate ",{"$f":"'3. Cost_of_Service_Parameters'!G61","v":0.45},null,{"$f":"'3. Cost_of_Service_Parameters'!I61","v":0.55000000000000004},null,{"$f":"'3. Cost_of_Service_Parameters'!K61","v":0.55000000000000004},null,{"$f":"'3. Cost_of_Service_Parameters'!M61","v":0.55000000000000004},null,{"$f":"'3. Cost_of_Service_Parameters'!O61","v":0.55000000000000004},null,{"$f":"'3. Cost_of_Service_Parameters'!Q61","v":0.55000000000000004},null,{"$f":"'3. Cost_of_Service_Parameters'!S61","v":0.55000000000000004},null,{"$f":"'3. Cost_of_Service_Parameters'!U61","v":0.55000000000000004}]
["CCA",{"$f":"B45*B43","v":0},null,{"$f":"D45*D43","v":8642.7000000000007},null,{"$f":"F45*F43","v":34234.915000000001},null,{"$f":"H45*H43","v":115835.16175000001},null,{"$f":"J45*J43","v":180996.32278750002},null,{"$f":"L45*L43","v":162795.77350437499},null,{"$f":"N45*N43","v":131208.08082696874},null,{"$f":"P45*P43","v":85790.240872135924}]
["Closing UCC",{"$f":"IF((B41-B46)<0, 0, B41-B46)","v":0},null,{"$f":"IF((D41-D46)<0, 0, D41-D46)","v":22785.3},null,{"$f":"IF((F41-F46)<0, 0, F41-F46)","v":67470.385000000009},null,{"$f":"IF((H41-H46)<0, 0, H41-H46)","v":237913.22324999998},null,{"$f":"IF((J41-J46)<0, 0, J41-J46)","v":239258.90046249997},null,{"$f":"IF((L41-L46)<0, 0, L41-L46)","v":189929.95695812497},null,{"$f":"IF((N41-N46)<0, 0, N41-N46)","v":155982.2561311562},null,{"$f":"IF((P41-P46)<0, 0, P41-P46)","v":70192.015259020278}]
[]
["UCC - General Equipment",{"$f":"B34","v":2006},null,2007,null,2008,null,2009,null,2010,null,2011,null,{"$f":"N34","v":2012},null,{"$f":"P34","v":2013}]
[null,"Audited Actual",null,"Audited Actual",null,"Audited Actual",null,"Audited Actual",null,"Audited Actual",null,"Audited Actual",null,{"$f":"N35","v":"Forecast"},null,{"$f":"P35","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":111321},null,{"$f":"J56-J61","v":131969.70000000001},null,{"$f":"L56-L61","v":125998.56000000001},null,{"$f":"N56-N61","v":100798.84800000001}]
["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},null,{"$f":"'2. Smart_Meter_Costs'!U187","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":123690},null,{"$f":"'2. Smart_Meter_Costs'!O189","v":47681},null,{"$f":"'2. Smart_Meter_Costs'!Q189","v":22692},null,{"$f":"'2. Smart_Meter_Costs'!S189","v":0},null,{"$f":"'2. Smart_Meter_Costs'!U189","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":123690},null,{"$f":"SUM(J52:J54)-J55","v":159002},null,{"$f":"SUM(L52:L54)-L55","v":154661.70000000001},null,{"$f":"SUM(N52:N54)-N55","v":125998.56000000001},null,{"$f":"SUM(P52:P54)-P55","v":100798.84800000001}]
["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":61845},null,{"$f":"IF(((SUM(J53:J54)-J55)/2)<0, 0, (SUM(J53:J54)-J55)/2)","v":23840.5},null,{"$f":"IF(((SUM(L53:L54)-L55)/2)<0, 0, (SUM(L53:L54)-L55)/2)","v":11346},null,{"$f":"IF(((SUM(N53:N54)-N55)/2)<0, 0, (SUM(N53:N54)-N55)/2)","v":0},null,{"$f":"IF(((SUM(P53:P54)-P55)/2)<0, 0, (SUM(P53:P54)-P55)/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":61845},null,{"$f":"J57+J52","v":135161.5},null,{"$f":"L57+L52","v":143315.70000000001},null,{"$f":"N57+N52","v":125998.56000000001},null,{"$f":"P57+P52","v":100798.84800000001}]
["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},null,{"$f":"'3. Cost_of_Service_Parameters'!U63","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},null,{"$f":"'3. Cost_of_Service_Parameters'!U64","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":12369},null,{"$f":"J60*J58","v":27032.300000000003},null,{"$f":"L60*L58","v":28663.140000000003},null,{"$f":"N60*N58","v":25199.712000000003},null,{"$f":"P60*P58","v":20159.769600000003}]
["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":111321},null,{"$f":"IF((J56-J61)<0, 0, J56-J61)","v":131969.70000000001},null,{"$f":"IF((L56-L61)<0, 0, L56-L61)","v":125998.56000000001},null,{"$f":"IF((N56-N61)<0, 0, N56-N61)","v":100798.84800000001},null,{"$f":"IF((P56-P61)<0, 0, P56-P61)","v":80639.078400000013}]
[]
["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},null,{"$f":"P49","v":2013}]
[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"},null,{"$f":"P50","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},null,{"$f":"N70-N75","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},null,{"$f":"'2. Smart_Meter_Costs'!U191","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},null,{"$f":"SUM(P67:P68)-P69","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},null,{"$f":"IF(((SUM(P68:P68)-P69)/2)<0, 0, (SUM(P68:P68)-P69)/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},null,{"$f":"P71+P67","v":0}]
["CCA Rate Class",{"$f":"'3. Cost_of_Service_Parameters'!G66","v":0},null,{"$f":"'3. Cost_of_Service_Parameters'!I66","v":0},null,{"$f":"'3. Cost_of_Service_Parameters'!K66","v":0},null,{"$f":"'3. Cost_of_Service_Parameters'!M66","v":0},null,{"$f":"'3. Cost_of_Service_Parameters'!O66","v":0},null,{"$f":"'3. Cost_of_Service_Parameters'!Q66","v":0},null,{"$f":"'3. Cost_of_Service_Parameters'!S66","v":0},null,{"$f":"'3. Cost_of_Service_Parameters'!U66","v":0}]
["CCA Rate ",{"$f":"'3. Cost_of_Service_Parameters'!G67","v":0},null,{"$f":"'3. Cost_of_Service_Parameters'!I67","v":0},null,{"$f":"'3. Cost_of_Service_Parameters'!K67","v":0},null,{"$f":"'3. Cost_of_Service_Parameters'!M67","v":0},null,{"$f":"'3. Cost_of_Service_Parameters'!O67","v":0},null,{"$f":"'3. Cost_of_Service_Parameters'!Q67","v":0},null,{"$f":"'3. Cost_of_Service_Parameters'!S67","v":0},null,{"$f":"'3. Cost_of_Service_Parameters'!U67","v":0}]
["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},null,{"$f":"P74*P72","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},null,{"$f":"IF((P70-P75)<0, 0, P70-P75)","v":0}]

{"sheet":"7_Taxes_PILs","index":6,"n_rows":59,"n_cols":17,"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 Forecast"},null,{"$f":"'2. Smart_Meter_Costs'!U18& \" \" &'2. Smart_Meter_Costs'!U19","v":"2013 Forecast"}]
[]
["INCOME TAX"]
[null,"Net Income",{"$f":"'5. SM_Rev_Reqt'!G$66","v":0},null,{"$f":"'5. SM_Rev_Reqt'!I$66","v":606.01040999999987},null,{"$f":"'5. SM_Rev_Reqt'!K$66","v":2599.1267399999997},null,{"$f":"'5. SM_Rev_Reqt'!M$66","v":40031.604810833349},null,{"$f":"'5. SM_Rev_Reqt'!O$66","v":109128.38078325836},null,{"$f":"'5. SM_Rev_Reqt'!Q$66","v":134542.23639590002},null,{"$f":"'5. SM_Rev_Reqt'!S$66","v":134691.88840463338},null,{"$f":"'5. SM_Rev_Reqt'!U$66","v":122547.34963933332}]
[null,"Amortization ",{"$f":"'5. SM_Rev_Reqt'!G$64","v":0},null,{"$f":"'5. SM_Rev_Reqt'!I$64","v":3142.8},null,{"$f":"'5. SM_Rev_Reqt'!K$64","v":14177.6},null,{"$f":"'5. SM_Rev_Reqt'!M$64","v":102720.23333333334},null,{"$f":"'5. SM_Rev_Reqt'!O$64","v":255253.31666666665},null,{"$f":"'5. SM_Rev_Reqt'!Q$64","v":355367.78300000005},null,{"$f":"'5. SM_Rev_Reqt'!S$64","v":395062.0083333333},null,{"$f":"'5. SM_Rev_Reqt'!U$64","v":407757.55066666665}]
[null,"CCA - Smart Meters",{"$f":"-'6. UCC_Calculation'!B31","v":0},null,{"$f":"-'6. UCC_Calculation'!D31","v":0},null,{"$f":"-'6. UCC_Calculation'!F31","v":0},null,{"$f":"-'6. UCC_Calculation'!H31","v":-55006},null,{"$f":"-'6. UCC_Calculation'!J31","v":-167128.56},null,{"$f":"-'6. UCC_Calculation'!L31","v":-234176.19519999999},null,{"$f":"-'6. UCC_Calculation'!N31","v":-236426.38478399999},null,{"$f":"-'6. UCC_Calculation'!P31","v":-221075.67920128}]
[null,"CCA - Computers",{"$f":"-'6. UCC_Calculation'!B46","v":0},null,{"$f":"-'6. UCC_Calculation'!D46","v":-8642.7000000000007},null,{"$f":"-'6. UCC_Calculation'!F46","v":-34234.915000000001},null,{"$f":"-'6. UCC_Calculation'!H46","v":-115835.16175000001},null,{"$f":"-'6. UCC_Calculation'!J46","v":-180996.32278750002},null,{"$f":"-'6. UCC_Calculation'!L46","v":-162795.77350437499},null,{"$f":"-'6. UCC_Calculation'!N46","v":-131208.08082696874},null,{"$f":"-'6. UCC_Calculation'!P46","v":-85790.240872135924}]
[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,{"$f":"-'6. UCC_Calculation'!P75","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":-12369},null,{"$f":"-'6. UCC_Calculation'!J61","v":-27032.300000000003},null,{"$f":"-'6. UCC_Calculation'!L61","v":-28663.140000000003},null,{"$f":"-'6. UCC_Calculation'!N61","v":-25199.712000000003},null,{"$f":"-'6. UCC_Calculation'!P61","v":-20159.769600000003}]
[null,"Change in taxable income",{"$f":"SUM(C23:C28)","v":0},null,-4893.8895900000007,null,-17458.188260000003,null,-40458.323605833328,null,-10775.48533757501,null,64274.910691525103,null,136919.71912699795,null,203279.210632584]
[]
[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.36120000000000002},null,{"$f":"'3. Cost_of_Service_Parameters'!M40","v":0.36120000000000002},null,{"$f":"'3. Cost_of_Service_Parameters'!O40","v":0.36120000000000002},null,{"$f":"'3. Cost_of_Service_Parameters'!Q40","v":0.28249999999999997},null,{"$f":"'3. Cost_of_Service_Parameters'!S40","v":0.26500000000000001},null,{"$f":"'3. Cost_of_Service_Parameters'!U40","v":0.26500000000000001}]
[]
[null,"Income Taxes Payable",{"$f":"C29*C31","v":0},null,-1767.6729199080003,null,-6305.8975995120018,null,-14613.546486426998,null,-3892.1053039320936,null,18157.662270355839,null,36283.725568654459,null,{"$f":"Q29*Q31","v":53868.99081763476}]
[]
["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":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!K35","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!M35","v":1329311.6666666667},null,{"$f":"'4. SM_Assets_and_Rate_Base'!O35","v":2724296.8},null,{"$f":"'4. SM_Assets_and_Rate_Base'!Q35","v":2986863},null,{"$f":"'4. SM_Assets_and_Rate_Base'!S35","v":2811505.4256666666},null,{"$f":"'4. SM_Assets_and_Rate_Base'!U35","v":2618093.2170000002}]
[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":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!O54","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!Q54","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!S54","v":0},null,{"$f":"'4. SM_Assets_and_Rate_Base'!U54","v":0}]
[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":28285.200000000001},null,{"$f":"'4. SM_Assets_and_Rate_Base'!K73","v":93027.6},null,{"$f":"'4. SM_Assets_and_Rate_Base'!M73","v":328608.2},null,{"$f":"'4. SM_Assets_and_Rate_Base'!O73","v":413390.80000000005},null,{"$f":"'4. SM_Assets_and_Rate_Base'!Q73","v":399717.34699999995},null,{"$f":"'4. SM_Assets_and_Rate_Base'!S73","v":348764.723},null,{"$f":"'4. SM_Assets_and_Rate_Base'!U73","v":190825.68099999998}]
[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,{"$f":"'4. SM_Assets_and_Rate_Base'!U92","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":117505.5},null,{"$f":"'4. SM_Assets_and_Rate_Base'!O111","v":150433.45000000001},null,{"$f":"'4. SM_Assets_and_Rate_Base'!Q111","v":154853.75},null,{"$f":"'4. SM_Assets_and_Rate_Base'!S111","v":135447.45000000001},null,{"$f":"'4. SM_Assets_and_Rate_Base'!U111","v":116041.15}]
[null,"Rate Base",{"$f":"SUM(C36:C40)","v":0},null,{"$f":"SUM(E36:E40)","v":28285.200000000001},null,{"$f":"SUM(G36:G40)","v":93027.6},null,{"$f":"SUM(I36:I40)","v":1775425.3666666667},null,{"$f":"SUM(K36:K40)","v":3288121.05},null,{"$f":"SUM(M36:M40)","v":3541434.0970000001},null,{"$f":"SUM(O36:O40)","v":3295717.598666667},null,{"$f":"SUM(Q36:Q40)","v":2924960.048}]
[null,"Less: Exemption"]
[null,"Deemed Taxable Capital",{"$f":"C41-C42","v":0},null,28285.200000000001,null,93027.6,null,1775425.3666666667,null,3288121.05,null,3541434.0970000001,null,3295717.598666667,null,2924960.048]
[]
[null,"Ontario Capital Tax Rate (from Sheet 3)",{"$f":"'3. Cost_of_Service_Parameters'!G41","v":3.0000000000000001E-3},null,{"$f":"'3. Cost_of_Service_Parameters'!I41","v":2.2499999999999998E-3},null,{"$f":"'3. Cost_of_Service_Parameters'!K41","v":2.2499999999999998E-3},null,{"$f":"'3. Cost_of_Service_Parameters'!M41","v":2.2499999999999998E-3},null,{"$f":"'3. Cost_of_Service_Parameters'!O41","v":7.5000000000000002E-4},null,{"$f":"'3. Cost_of_Service_Parameters'!Q41","v":0},null,{"$f":"'3. Cost_of_Service_Parameters'!S41","v":0},null,{"$f":"'3. Cost_of_Service_Parameters'!U41","v":0}]
[]
[null,"Net Amount (Taxable Capital x Rate)",{"$f":"C43*C45","v":0},null,63.6417,null,209.31209999999999,null,3994.7070749999998,null,2466.0907874999998,null,0,null,0,null,{"$f":"Q43*Q45","v":0}]
[]
[]
[null,"Change in Income Taxes Payable",{"$f":"C33","v":0},null,-1767.6729199080003,null,-6305.8975995120018,null,-14613.546486426998,null,-3892.1053039320936,null,18157.662270355839,null,36283.725568654459,null,{"$f":"Q33","v":53868.99081763476}]
[null,"Change in OCT",{"$f":"C47","v":0},null,63.6417,null,209.31209999999999,null,3994.7070749999998,null,2466.0907874999998,null,0,null,0,null,{"$f":"Q47","v":0}]
[null,"PILs",{"$f":"SUM(C50:C51)","v":0},null,-1704.0312199080004,null,-6096.5854995120017,null,-10618.839411426998,null,-1426.0145164320938,null,18157.662270355839,null,36283.725568654459,null,53868.99081763476]
[]
[]
["Gross Up PILs"]
[null,"Tax Rate",{"$f":"C31","v":0.36120000000000002},null,{"$f":"E31","v":0.36120000000000002},null,0.36120000000000002,null,0.36120000000000002,null,0.36120000000000002,null,0.28249999999999997,null,0.26500000000000001,null,{"$f":"Q31","v":0.26500000000000001}]
[null,"Change in Income Taxes Payable",{"$f":"C50/(1-C56)","v":0},null,-2767.1773949718227,null,-9871.4740130118989,null,-22876.559934920158,null,-6092.8386097872472,null,25306.846369833922,null,49365.613018577496,null,73291.143969571101]
[null,"Change in OCT",{"$f":"C51","v":0},null,63.6417,null,209.31209999999999,null,3994.7070749999998,null,2466.0907874999998,null,0,null,0,null,{"$f":"Q51","v":0}]
[null,"PILs",{"$f":"SUM(C57:C58)","v":0},null,-2703.5356949718225,null,-9662.1619130118997,null,-18881.85285992016,null,-3626.7478222872473,null,25306.846369833922,null,49365.613018577496,null,73291.143969571101]

{"sheet":"8. Funding_Adder_Revs","index":7,"n_rows":121,"n_cols":16,"rows_kept":121,"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$55,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,null,4.1399999999999999E-2,0,0]
[null,"2007 Q2",4.5900000000000003E-2,4.7199999999999999E-2,null,"2006-06-01",2006,"Q2","2006 Q2",0,null,4.1399999999999999E-2,0,0]
[null,"2007 Q3",4.5900000000000003E-2,5.1799999999999999E-2,null,"2006-07-01",2006,"Q3","2006 Q3",0,null,4.5900000000000003E-2,0,0]
[null,"2007 Q4",5.1400000000000001E-2,5.1799999999999999E-2,null,"2006-08-01",2006,"Q3","2006 Q3",0,null,4.5900000000000003E-2,0,0]
[null,"2008 Q1",5.1400000000000001E-2,5.1799999999999999E-2,null,"2006-09-01",2006,"Q3","2006 Q3",0,null,4.5900000000000003E-2,0,0]
[null,"2008 Q2",4.0800000000000003E-2,5.1799999999999999E-2,null,"2006-10-01",2006,"Q4","2006 Q4",0,null,4.5900000000000003E-2,0,0]
[null,"2008 Q3",3.3500000000000002E-2,5.4300000000000001E-2,null,"2006-11-01",2006,"Q4","2006 Q4",0,null,4.5900000000000003E-2,0,0]
[null,"2008 Q4",3.3500000000000002E-2,5.4300000000000001E-2,null,"2006-12-01",2006,"Q4","2006 Q4",0,null,4.5900000000000003E-2,0,0,{"$f":"SUM(K24:K35)+SUM(M24:M35)","v":0}]
[null,"2009 Q1",2.4500000000000001E-2,6.6100000000000006E-2,null,"2007-01-01",2007,"Q1","2007 Q1",0,null,4.5900000000000003E-2,0,0]
[null,"2009 Q2",0.01,6.6100000000000006E-2,null,"2007-02-01",2007,"Q1","2007 Q1",0,null,4.5900000000000003E-2,0,0]
[null,"2009 Q3",5.4999999999999997E-3,5.67E-2,null,"2007-03-01",2007,"Q1","2007 Q1",0,null,4.5900000000000003E-2,0,0]
[null,"2009 Q4",5.4999999999999997E-3,4.6600000000000003E-2,null,"2007-04-01",2007,"Q2","2007 Q2",0,null,4.5900000000000003E-2,0,0]
[null,"2010 Q1",5.4999999999999997E-3,4.3400000000000001E-2,null,"2007-05-01",2007,"Q2","2007 Q2",0,null,4.5900000000000003E-2,0,0]
[null,"2010 Q2",5.4999999999999997E-3,4.3400000000000001E-2,null,"2007-06-01",2007,"Q2","2007 Q2",0,null,4.5900000000000003E-2,0,0]
[null,"2010 Q3",8.8999999999999999E-3,4.6600000000000003E-2,null,"2007-07-01",2007,"Q3","2007 Q3",0,null,4.5900000000000003E-2,0,0]
[null,"2010 Q4",1.2E-2,4.0099999999999997E-2,null,"2007-08-01",2007,"Q3","2007 Q3",0,null,4.5900000000000003E-2,0,0]
[null,"2011 Q1",1.47E-2,4.2900000000000001E-2,null,"2007-09-01",2007,"Q3","2007 Q3",0,null,4.5900000000000003E-2,0,0]
[null,"2011 Q2",1.47E-2,4.2900000000000001E-2,null,"2007-10-01",2007,"Q4","2007 Q4",0,null,5.1400000000000001E-2,0,0]
[null,"2011 Q3",1.47E-2,4.2900000000000001E-2,null,"2007-11-01",2007,"Q4","2007 Q4",0,null,5.1400000000000001E-2,0,0]
[null,"2011 Q4",{"$f":"C46","v":1.47E-2},3.9199999999999999E-2,null,"2007-12-01",2007,"Q4","2007 Q4",0,null,5.1400000000000001E-2,0,0,{"$f":"SUM(K36:K47)+SUM(M36:M47)","v":0}]
[null,"2012 Q1",1.47E-2,3.9199999999999999E-2,null,"2008-01-01",2008,"Q1","2008 Q1",0,null,5.1400000000000001E-2,0,0]
[null,"2012 Q2",1.47E-2,3.5099999999999999E-2,null,"2008-02-01",2008,"Q1","2008 Q1",0,null,5.1400000000000001E-2,0,0]
[null,"2012 Q3",1.47E-2,3.5099999999999999E-2,null,"2008-03-01",2008,"Q1","2008 Q1",0,null,5.1400000000000001E-2,0,0]
[null,"2012 Q4",1.47E-2,3.5099999999999999E-2,null,"2008-04-01",2008,"Q2","2008 Q2",0,null,4.0800000000000003E-2,0,0]
[null,"2013 Q1",null,null,null,"2008-05-01",2008,"Q2","2008 Q2",0,null,4.0800000000000003E-2,0,0]
[null,"2013 Q2",null,null,null,"2008-06-01",2008,"Q2","2008 Q2",0,null,4.0800000000000003E-2,0,0]
[null,"2013 Q3",null,null,null,"2008-07-01",2008,"Q3","2008 Q3",0,null,3.3500000000000002E-2,0,0]
[null,"2013 Q4",null,null,null,"2008-08-01",2008,"Q3","2008 Q3",0,null,3.3500000000000002E-2,0,0]
[null,null,null,null,null,"2008-09-01",2008,"Q3","2008 Q3",0,null,{"$f":"VLOOKUP(I56,$B$22:$D$55,2)","v":3.3500000000000002E-2},0,0]
[null,null,null,null,null,"2008-10-01",2008,"Q4","2008 Q4",0,null,3.3500000000000002E-2,0,0]
[null,null,null,null,null,"2008-11-01",2008,"Q4","2008 Q4",0,null,3.3500000000000002E-2,0,0]
[null,null,null,null,null,"2008-12-01",2008,"Q4","2008 Q4",0,null,3.3500000000000002E-2,0,0,{"$f":"SUM(K48:K59)+SUM(M48:M59)","v":0}]
[null,null,null,null,null,"2009-01-01",2009,"Q1","2009 Q1",0,null,2.4500000000000001E-2,0,0]
[null,null,null,null,null,"2009-02-01",2009,"Q1","2009 Q1",0,null,2.4500000000000001E-2,0,0]
[null,null,null,null,null,"2009-03-01",2009,"Q1","2009 Q1",0,null,2.4500000000000001E-2,0,0]
[null,null,null,null,null,"2009-04-01",2009,"Q2","2009 Q2",0,null,0.01,0,0]
[null,null,null,null,null,"2009-05-01",2009,"Q2","2009 Q2",0,null,0.01,0,0]
[null,null,null,null,null,"2009-06-01",2009,"Q2","2009 Q2",0,null,0.01,0,0]
[null,null,null,null,null,"2009-07-01",2009,"Q3","2009 Q3",0,null,5.4999999999999997E-3,0,0]
[null,null,null,null,null,"2009-08-01",2009,"Q3","2009 Q3",0,null,5.4999999999999997E-3,0,0]
[null,null,null,null,null,"2009-09-01",2009,"Q3","2009 Q3",0,null,5.4999999999999997E-3,0,0]
[null,null,null,null,null,"2009-10-01",2009,"Q4","2009 Q4",0,null,5.4999999999999997E-3,0,0]
[null,null,null,null,null,"2009-11-01",2009,"Q4","2009 Q4",0,null,5.4999999999999997E-3,0,0]
[null,null,null,null,null,"2009-12-01",2009,"Q4","2009 Q4",0,null,5.4999999999999997E-3,0,0,{"$f":"SUM(K60:K71)+SUM(M60:M71)","v":0}]
[null,null,null,null,null,"2010-01-01",2010,"Q1","2010 Q1",0,null,5.4999999999999997E-3,0,0]
[null,null,null,null,null,"2010-02-01",2010,"Q1","2010 Q1",0,null,5.4999999999999997E-3,0,0]
[null,null,null,null,null,"2010-03-01",2010,"Q1","2010 Q1",0,null,5.4999999999999997E-3,0,0]
[null,null,null,null,null,"2010-04-01",2010,"Q2","2010 Q2",0,null,5.4999999999999997E-3,0,0]
[null,null,null,null,null,"2010-05-01",2010,"Q2","2010 Q2",0,null,5.4999999999999997E-3,0,0]
[null,null,null,null,null,"2010-06-01",2010,"Q2","2010 Q2",0,null,5.4999999999999997E-3,0,0]
[null,null,null,null,null,"2010-07-01",2010,"Q3","2010 Q3",0,null,8.8999999999999999E-3,0,0]
[null,null,null,null,null,"2010-08-01",2010,"Q3","2010 Q3",0,null,8.8999999999999999E-3,0,0]
[null,null,null,null,null,"2010-09-01",2010,"Q3","2010 Q3",0,null,8.8999999999999999E-3,0,0]
[null,null,null,null,null,"2010-10-01",2010,"Q4","2010 Q4",0,null,1.2E-2,0,0]
[null,null,null,null,null,"2010-11-01",2010,"Q4","2010 Q4",0,null,1.2E-2,0,0]
[null,null,null,null,null,"2010-12-01",2010,"Q4","2010 Q4",0,null,1.2E-2,0,0,{"$f":"SUM(K72:K83)+SUM(M72:M83)","v":0}]
[null,null,null,null,null,"2011-01-01",2011,"Q1","2011 Q1",0,1317.6,1.47E-2,0,1317.6]
[null,null,null,null,null,"2011-02-01",2011,"Q1","2011 Q1",1317.6,9904.7000000000007,1.47E-2,1.61,11223.910000000002]
[null,null,null,null,null,"2011-03-01",2011,"Q1","2011 Q1",11222.300000000001,10780.43,1.47E-2,13.75,22016.480000000003]
[null,null,null,null,null,"2011-04-01",2011,"Q2","2011 Q2",22002.730000000003,5778.64,1.47E-2,26.95,27808.320000000003]
[null,null,null,null,null,"2011-05-01",2011,"Q2","2011 Q2",27781.370000000003,10163.459999999999,{"$f":"VLOOKUP(I88,$B$22:$D$55,2)","v":1.47E-2},34.03,37978.86]
[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"},37944.83,9802.0300000000007,1.47E-2,{"$f":"ROUND(J89*L89/12,2)","v":46.48},{"$f":"J89+K89+M89","v":47793.340000000004}]
[null,null,null,null,null,"2011-07-01",2011,"Q3","2011 Q3",{"$f":"J89+K89","v":47746.86},2871.43,1.47E-2,58.49,50676.78]
[null,null,null,null,null,"2011-08-01",2011,"Q3","2011 Q3",50618.29,12788.15,1.47E-2,62.01,63468.450000000004]
[null,null,null,null,null,"2011-09-01",2011,"Q3","2011 Q3",63406.44,10508.5,1.47E-2,77.67,73992.61]
[null,null,null,null,null,"2011-10-01",2011,"Q4","2011 Q4",73914.94,40693.879999999997,1.47E-2,90.55,114699.37000000001]
[null,null,null,null,null,"2011-11-01",2011,"Q4","2011 Q4",114608.82,7938.41,1.47E-2,140.4,122687.63]
[null,null,null,null,null,"2011-12-01",2011,"Q4","2011 Q4",122547.23000000001,6325.39,1.47E-2,150.12,129022.74,{"$f":"SUM(K84:K95)+SUM(M84:M95)","v":129574.68000000001}]
[null,null,null,null,null,"2012-01-01",2012,"Q1","2012 Q1",128872.62000000001,10651.61,1.47E-2,157.87,139682.1]
[null,null,null,null,null,"2012-02-01",2012,"Q1","2012 Q1",139524.23000000001,6312.65,1.47E-2,170.92,146007.80000000002]
[null,null,null,null,null,"2012-03-01",2012,"Q1","2012 Q1",145836.88,10424.030000000001,1.47E-2,178.65,156439.56]
[null,null,null,null,null,"2012-04-01",2012,"Q2","2012 Q2",156260.91,6293.85,1.47E-2,191.42,162746.18000000002]
[null,null,null,null,null,"2012-05-01",2012,"Q2","2012 Q2",162554.76,10718.85,1.47E-2,199.13,173472.74000000002]
[null,null,null,null,null,"2012-06-01",2012,"Q2","2012 Q2",173273.61000000002,6496.62,1.47E-2,212.26,179982.49000000002]
[null,null,null,null,null,"2012-07-01",2012,"Q3","2012 Q3",179770.23,6037.14,1.47E-2,220.22,186027.59000000003]
[null,null,null,null,null,"2012-08-01",2012,"Q3","2012 Q3",185807.37000000002,9659.1,1.47E-2,227.61,195694.08000000002]
[null,null,null,null,null,"2012-09-01",2012,"Q3","2012 Q3",195466.47000000003,6465.15,1.47E-2,239.45,202171.07000000004]
[null,null,null,null,null,"2012-10-01",2012,"Q4","2012 Q4",201931.62000000002,56165.599999999999,1.47E-2,247.37,258344.59000000003]
[null,null,null,null,null,"2012-11-01",2012,"Q4","2012 Q4",258097.22000000003,25857.18,1.47E-2,316.17,284270.57]
[null,null,null,null,null,"2012-12-01",2012,"Q4","2012 Q4",283954.40000000002,13861,1.47E-2,347.84,298163.24000000005,{"$f":"SUM(K96:K107)+SUM(M96:M107)","v":171651.69}]
[null,null,null,null,null,"2013-01-01",2013,"Q1","2013 Q1",297815.40000000002,null,null,{"$f":"ROUND(J108*L108/12,2)","v":0},{"$f":"J108+K108+M108","v":297815.40000000002}]
[null,null,null,null,null,"2013-02-01",2013,"Q1","2013 Q1",297815.40000000002,null,null,0,297815.40000000002]
[null,null,null,null,null,"2013-03-01",2013,"Q1","2013 Q1",297815.40000000002,null,null,0,297815.40000000002]
[null,null,null,null,null,"2013-04-01",2013,"Q2","2013 Q2",297815.40000000002,null,null,0,297815.40000000002]
[null,null,null,null,null,"2013-05-01",2013,"Q2","2013 Q2",297815.40000000002,null,null,0,297815.40000000002]
[null,null,null,null,null,"2013-06-01",2013,"Q2","2013 Q2",297815.40000000002,null,null,0,297815.40000000002]
[null,null,null,null,null,"2013-07-01",2013,"Q3","2013 Q3",297815.40000000002,null,null,0,297815.40000000002]
[null,null,null,null,null,"2013-08-01",2013,"Q3","2013 Q3",297815.40000000002,null,null,0,297815.40000000002]
[null,null,null,null,null,"2013-09-01",2013,"Q3","2013 Q3",297815.40000000002,null,null,0,297815.40000000002]
[null,null,null,null,null,"2013-10-01",2013,"Q4","2013 Q4",297815.40000000002,null,null,0,297815.40000000002]
[null,null,null,null,null,"2013-11-01",2013,"Q4","2013 Q4",297815.40000000002,null,null,0,297815.40000000002]
[null,null,null,null,null,"2013-12-01",2013,"Q4","2013 Q4",297815.40000000002,null,null,0,297815.40000000002,{"$f":"SUM(K108:K119)+SUM(M108:M119)","v":0}]
[]
[null,null,null,null,null,"Total Funding Adder Revenues Collected",null,null,null,null,{"$f":"SUM(K24:K107)","v":297815.40000000002},null,{"$f":"SUM(M24:M107)","v":3410.9700000000003},{"$f":"K121+M121","v":301226.37},{"$f":"SUM(O24:O107)","v":301226.37}]

{"sheet":"8A. Opex_Interest_monthly","index":8,"n_rows":122,"n_cols":16,"rows_kept":122,"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,628.55999999999995,628.55999999999995,{"$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,628.55999999999995,null,628.55999999999995,1257.1199999999999,{"$f":"'8. Funding_Adder_Revs'!L44","v":4.5900000000000003E-2},2.404242,2.404242]
[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,1257.1199999999999,null,628.55999999999995,1885.6799999999998,{"$f":"'8. Funding_Adder_Revs'!L45","v":5.1400000000000001E-2},5.3846639999999999,7.7889059999999999]
[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,1885.6799999999998,null,628.55999999999995,2514.2399999999998,{"$f":"'8. Funding_Adder_Revs'!L46","v":5.1400000000000001E-2},8.0769959999999994,15.865901999999998]
[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":3.9199999999999999E-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,2514.2399999999998,null,628.55999999999995,3142.7999999999997,{"$f":"'8. Funding_Adder_Revs'!L47","v":5.1400000000000001E-2},10.769328,26.63523]
[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":3.9199999999999999E-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,3142.7999999999997,null,1181.47,4324.2699999999995,{"$f":"'8. Funding_Adder_Revs'!L48","v":5.1400000000000001E-2},13.46166,40.096890000000002]
[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":3.5099999999999999E-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,4324.2699999999995,null,1181.47,5505.74,{"$f":"'8. Funding_Adder_Revs'!L49","v":5.1400000000000001E-2},18.522289833333332,58.619179833333334]
[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":3.5099999999999999E-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,5505.74,null,1181.47,6687.21,{"$f":"'8. Funding_Adder_Revs'!L50","v":5.1400000000000001E-2},23.582919666666665,82.202099500000003]
[null,{"$f":"'8. Funding_Adder_Revs'!B51","v":"2012 Q4"},{"$f":"'8. Funding_Adder_Revs'!C51","v":1.47E-2},{"$f":"'8. Funding_Adder_Revs'!D51","v":3.5099999999999999E-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,6687.21,null,1181.47,7868.68,{"$f":"'8. Funding_Adder_Revs'!L51","v":4.0800000000000003E-2},22.736514,104.9386135]
[null,{"$f":"'8. Funding_Adder_Revs'!B52","v":"2013 Q1"},{"$f":"'8. Funding_Adder_Revs'!C52","v":0},{"$f":"'8. Funding_Adder_Revs'!D52","v":0},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,7868.68,null,1181.47,9050.15,{"$f":"'8. Funding_Adder_Revs'!L52","v":4.0800000000000003E-2},26.753512000000001,131.6921255]
[null,{"$f":"'8. Funding_Adder_Revs'!B53","v":"2013 Q2"},{"$f":"'8. Funding_Adder_Revs'!C53","v":0},{"$f":"'8. Funding_Adder_Revs'!D53","v":0},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,9050.15,null,1181.47,10231.619999999999,{"$f":"'8. Funding_Adder_Revs'!L53","v":4.0800000000000003E-2},30.770510000000002,162.4626355]
[null,{"$f":"'8. Funding_Adder_Revs'!B54","v":"2013 Q3"},{"$f":"'8. Funding_Adder_Revs'!C54","v":0},{"$f":"'8. Funding_Adder_Revs'!D54","v":0},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,10231.619999999999,null,1181.47,11413.089999999998,{"$f":"'8. Funding_Adder_Revs'!L54","v":3.3500000000000002E-2},28.563272499999997,191.02590800000002]
[null,{"$f":"'8. Funding_Adder_Revs'!B55","v":"2013 Q4"},{"$f":"'8. Funding_Adder_Revs'!C55","v":0},{"$f":"'8. Funding_Adder_Revs'!D55","v":0},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,11413.089999999998,null,1181.47,12594.559999999998,{"$f":"'8. Funding_Adder_Revs'!L55","v":3.3500000000000002E-2},31.861542916666664,222.88745091666669]
[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,12594.559999999998,null,1181.47,13776.029999999997,{"$f":"'8. Funding_Adder_Revs'!L56","v":3.3500000000000002E-2},35.159813333333325,258.04726425000001]
[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,13776.029999999997,null,1181.47,14957.499999999996,{"$f":"'8. Funding_Adder_Revs'!L57","v":3.3500000000000002E-2},38.458083749999993,296.50534800000003]
[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,14957.499999999996,null,1181.47,16138.969999999996,{"$f":"'8. Funding_Adder_Revs'!L58","v":3.3500000000000002E-2},41.756354166666661,338.26170216666668]
[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,16138.969999999996,null,1181.43,17320.399999999994,{"$f":"'8. Funding_Adder_Revs'!L59","v":3.3500000000000002E-2},45.054624583333322,383.31632675000003]
[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,17320.399999999994,null,8560.02,25880.419999999995,{"$f":"'8. Funding_Adder_Revs'!L60","v":2.4500000000000001E-2},35.362483333333323,418.67881008333336]
[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,25880.419999999995,null,8560.02,34440.439999999995,{"$f":"'8. Funding_Adder_Revs'!L61","v":2.4500000000000001E-2},52.839190833333326,471.51800091666667]
[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,34440.439999999995,null,8560.02,43000.459999999992,{"$f":"'8. Funding_Adder_Revs'!L62","v":2.4500000000000001E-2},70.315898333333323,541.83389924999994]
[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,43000.459999999992,null,8560.02,51560.479999999996,{"$f":"'8. Funding_Adder_Revs'!L63","v":0.01},35.83371666666666,577.66761591666659]
[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,51560.479999999996,null,8560.02,60120.5,{"$f":"'8. Funding_Adder_Revs'!L64","v":0.01},42.967066666666661,620.6346825833333]
[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,60120.5,null,8560.02,68680.52,{"$f":"'8. Funding_Adder_Revs'!L65","v":0.01},50.100416666666668,670.73509924999996]
[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,68680.52,null,8560.02,77240.540000000008,{"$f":"'8. Funding_Adder_Revs'!L66","v":5.4999999999999997E-3},31.478571666666667,702.21367091666662]
[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,77240.540000000008,null,8560.02,85800.560000000012,{"$f":"'8. Funding_Adder_Revs'!L67","v":5.4999999999999997E-3},35.401914166666664,737.61558508333326]
[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,85800.560000000012,null,8560.02,94360.580000000016,{"$f":"'8. Funding_Adder_Revs'!L68","v":5.4999999999999997E-3},39.325256666666668,776.94084174999989]
[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,94360.580000000016,null,8560.02,102920.60000000002,{"$f":"'8. Funding_Adder_Revs'!L69","v":5.4999999999999997E-3},43.248599166666672,820.18944091666651]
[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,102920.60000000002,null,8560.02,111480.62000000002,{"$f":"'8. Funding_Adder_Revs'!L70","v":5.4999999999999997E-3},47.171941666666669,867.36138258333312]
[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,111480.62000000002,null,8560.01,120040.63000000002,{"$f":"'8. Funding_Adder_Revs'!L71","v":5.4999999999999997E-3},51.09528416666668,918.45666674999984]
[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,120040.63000000002,null,21271.11,141311.74000000002,{"$f":"'8. Funding_Adder_Revs'!L72","v":5.4999999999999997E-3},55.018622083333334,973.47528883333314]
[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,141311.74000000002,2473.5100000000002,21271.11,165056.36000000004,{"$f":"'8. Funding_Adder_Revs'!L73","v":5.4999999999999997E-3},64.767880833333336,1038.2431696666665]
[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,165056.36000000004,4890.2299999999996,21271.11,191217.70000000007,{"$f":"'8. Funding_Adder_Revs'!L74","v":5.4999999999999997E-3},75.65083166666669,1113.8940013333331]
[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,191217.70000000007,4662.58,21271.11,217151.39000000007,{"$f":"'8. Funding_Adder_Revs'!L75","v":5.4999999999999997E-3},87.641445833333364,1201.5354471666665]
[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,217151.39000000007,9372.17,21271.11,247794.6700000001,{"$f":"'8. Funding_Adder_Revs'!L76","v":5.4999999999999997E-3},99.527720416666696,1301.0631675833331]
[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,247794.6700000001,5674.86,21271.11,274740.64000000007,{"$f":"'8. Funding_Adder_Revs'!L77","v":5.4999999999999997E-3},113.57255708333338,1414.6357246666664]
[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,274740.64000000007,4062,21271.11,300073.75000000006,{"$f":"'8. Funding_Adder_Revs'!L78","v":8.8999999999999999E-3},203.76597466666672,1618.4016993333332]
[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,300073.75000000006,9652.49,21271.11,330997.35000000003,{"$f":"'8. Funding_Adder_Revs'!L79","v":8.8999999999999999E-3},222.5546979166667,1840.95639725]
[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,330997.35000000003,18898.54,21271.11,371167,{"$f":"'8. Funding_Adder_Revs'!L80","v":8.8999999999999999E-3},245.48970125000002,2086.4460985000001]
[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,371167,492.77,21271.11,392930.88,{"$f":"'8. Funding_Adder_Revs'!L81","v":1.2E-2},371.16699999999997,2457.6130985]
[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,392930.88,9854.52,21271.11,424056.51,{"$f":"'8. Funding_Adder_Revs'!L82","v":1.2E-2},392.93088000000006,2850.5439784999999]
[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,424056.51,{"$f":"49936.46-20102.56","v":29833.899999999998},21271.11,475161.52,{"$f":"'8. Funding_Adder_Revs'!L83","v":1.2E-2},424.05651000000006,3274.6004884999998]
[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,475161.52,null,29613.98,504775.5,{"$f":"'8. Funding_Adder_Revs'!L84","v":1.47E-2},582.07286199999999,3856.6733504999997]
[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,504775.5,null,29613.98,534389.48,{"$f":"'8. Funding_Adder_Revs'!L85","v":1.47E-2},618.3499875,4475.023338]
[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,534389.48,null,29613.98,564003.46,{"$f":"'8. Funding_Adder_Revs'!L86","v":1.47E-2},654.62711299999989,5129.6504509999995]
[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,564003.46,null,29613.98,593617.43999999994,{"$f":"'8. Funding_Adder_Revs'!L87","v":1.47E-2},690.90423849999991,5820.5546894999998]
[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,593617.43999999994,null,29613.98,623231.41999999993,{"$f":"'8. Funding_Adder_Revs'!L88","v":1.47E-2},727.18136399999992,6547.7360534999998]
[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,623231.41999999993,null,29613.98,{"$f":"J90+K90+L90","v":652845.39999999991},{"$f":"'8. Funding_Adder_Revs'!L89","v":1.47E-2},{"$f":"J90*N90/12","v":763.45848949999981},7311.1945429999996]
[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":652845.39999999991},null,29613.98,682459.37999999989,{"$f":"'8. Funding_Adder_Revs'!L90","v":1.47E-2},799.73561499999994,{"$f":"O91+P90","v":8110.9301579999992}]
[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,682459.37999999989,null,29613.98,712073.35999999987,{"$f":"'8. Funding_Adder_Revs'!L91","v":1.47E-2},836.01274049999984,8946.9428984999995]
[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,712073.35999999987,null,29613.98,741687.33999999985,{"$f":"'8. Funding_Adder_Revs'!L92","v":1.47E-2},872.28986599999973,9819.2327644999987]
[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,741687.33999999985,null,29613.98,771301.31999999983,{"$f":"'8. Funding_Adder_Revs'!L93","v":1.47E-2},908.56699149999986,10727.799755999999]
[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,771301.31999999983,null,29613.98,800915.29999999981,{"$f":"'8. Funding_Adder_Revs'!L94","v":1.47E-2},944.84411699999976,11672.643872999999]
[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,800915.29999999981,null,29614,830529.29999999981,{"$f":"'8. Funding_Adder_Revs'!L95","v":1.47E-2},981.12124249999977,12653.765115499999]
[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,830529.29999999981,null,33064.15,863593.44999999984,{"$f":"'8. Funding_Adder_Revs'!L96","v":1.47E-2},1017.3983924999998,13671.163507999998]
[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,863593.44999999984,null,33064.15,896657.59999999986,{"$f":"'8. Funding_Adder_Revs'!L97","v":1.47E-2},1057.9019762499997,14729.065484249997]
[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,896657.59999999986,null,33064.15,929721.74999999988,{"$f":"'8. Funding_Adder_Revs'!L98","v":1.47E-2},1098.4055599999999,15827.471044249996]
[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,929721.74999999988,null,33064.15,962785.89999999991,{"$f":"'8. Funding_Adder_Revs'!L99","v":1.47E-2},1138.9091437499999,16966.380187999996]
[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,962785.89999999991,null,33064.15,995850.04999999993,{"$f":"'8. Funding_Adder_Revs'!L100","v":1.47E-2},1179.4127274999998,18145.792915499995]
[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,995850.04999999993,null,33064.15,1028914.2,{"$f":"'8. Funding_Adder_Revs'!L101","v":1.47E-2},1219.9163112499998,19365.709226749994]
[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,1028914.2,null,33064.15,1061978.3499999999,{"$f":"'8. Funding_Adder_Revs'!L102","v":1.47E-2},1260.4198949999998,20626.129121749993]
[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,1061978.3499999999,null,33064.15,1095042.4999999998,{"$f":"'8. Funding_Adder_Revs'!L103","v":1.47E-2},1300.9234787499997,21927.052600499992]
[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,1095042.4999999998,null,33064.15,1128106.6499999997,{"$f":"'8. Funding_Adder_Revs'!L104","v":1.47E-2},1341.4270624999997,23268.479662999991]
[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,1128106.6499999997,null,33064.15,1161170.7999999996,{"$f":"'8. Funding_Adder_Revs'!L105","v":1.47E-2},1381.9306462499997,24650.41030924999]
[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,1161170.7999999996,null,33064.15,1194234.9499999995,{"$f":"'8. Funding_Adder_Revs'!L106","v":1.47E-2},1422.4342299999996,26072.844539249989]
[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,1194234.9499999995,null,33064.15,1227299.0999999994,{"$f":"'8. Funding_Adder_Revs'!L107","v":1.47E-2},1462.9378137499991,27535.782352999988]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F108","v":"2013-01-01"},{"$f":"'8. Funding_Adder_Revs'!G108","v":2013},{"$f":"'8. Funding_Adder_Revs'!H108","v":"Q1"},null,{"$f":"M108","v":1227299.0999999994},null,null,{"$f":"J109+K109+L109","v":1227299.0999999994},{"$f":"'8. Funding_Adder_Revs'!L108","v":0},{"$f":"J109*N109/12","v":0},{"$f":"O109+P108","v":27535.782352999988}]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F109","v":"2013-02-01"},{"$f":"'8. Funding_Adder_Revs'!G109","v":2013},{"$f":"'8. Funding_Adder_Revs'!H109","v":"Q1"},null,1227299.0999999994,null,null,1227299.0999999994,{"$f":"'8. Funding_Adder_Revs'!L109","v":0},0,27535.782352999988]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F110","v":"2013-03-01"},{"$f":"'8. Funding_Adder_Revs'!G110","v":2013},{"$f":"'8. Funding_Adder_Revs'!H110","v":"Q1"},null,1227299.0999999994,null,null,1227299.0999999994,{"$f":"'8. Funding_Adder_Revs'!L110","v":0},0,27535.782352999988]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F111","v":"2013-04-01"},{"$f":"'8. Funding_Adder_Revs'!G111","v":2013},{"$f":"'8. Funding_Adder_Revs'!H111","v":"Q2"},null,1227299.0999999994,null,null,1227299.0999999994,{"$f":"'8. Funding_Adder_Revs'!L111","v":0},0,27535.782352999988]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F112","v":"2013-05-01"},{"$f":"'8. Funding_Adder_Revs'!G112","v":2013},{"$f":"'8. Funding_Adder_Revs'!H112","v":"Q2"},null,1227299.0999999994,null,null,1227299.0999999994,{"$f":"'8. Funding_Adder_Revs'!L112","v":0},0,27535.782352999988]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F113","v":"2013-06-01"},{"$f":"'8. Funding_Adder_Revs'!G113","v":2013},{"$f":"'8. Funding_Adder_Revs'!H113","v":"Q2"},null,1227299.0999999994,null,null,1227299.0999999994,{"$f":"'8. Funding_Adder_Revs'!L113","v":0},0,27535.782352999988]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F114","v":"2013-07-01"},{"$f":"'8. Funding_Adder_Revs'!G114","v":2013},{"$f":"'8. Funding_Adder_Revs'!H114","v":"Q3"},null,1227299.0999999994,null,null,1227299.0999999994,{"$f":"'8. Funding_Adder_Revs'!L114","v":0},0,27535.782352999988]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F115","v":"2013-08-01"},{"$f":"'8. Funding_Adder_Revs'!G115","v":2013},{"$f":"'8. Funding_Adder_Revs'!H115","v":"Q3"},null,1227299.0999999994,null,null,1227299.0999999994,{"$f":"'8. Funding_Adder_Revs'!L115","v":0},0,27535.782352999988]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F116","v":"2013-09-01"},{"$f":"'8. Funding_Adder_Revs'!G116","v":2013},{"$f":"'8. Funding_Adder_Revs'!H116","v":"Q3"},null,1227299.0999999994,null,null,1227299.0999999994,{"$f":"'8. Funding_Adder_Revs'!L116","v":0},0,27535.782352999988]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F117","v":"2013-10-01"},{"$f":"'8. Funding_Adder_Revs'!G117","v":2013},{"$f":"'8. Funding_Adder_Revs'!H117","v":"Q4"},null,1227299.0999999994,null,null,1227299.0999999994,{"$f":"'8. Funding_Adder_Revs'!L117","v":0},0,27535.782352999988]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F118","v":"2013-11-01"},{"$f":"'8. Funding_Adder_Revs'!G118","v":2013},{"$f":"'8. Funding_Adder_Revs'!H118","v":"Q4"},null,1227299.0999999994,null,null,1227299.0999999994,{"$f":"'8. Funding_Adder_Revs'!L118","v":0},0,27535.782352999988]
[null,null,null,null,null,{"$f":"'8. Funding_Adder_Revs'!F119","v":"2013-12-01"},{"$f":"'8. Funding_Adder_Revs'!G119","v":2013},{"$f":"'8. Funding_Adder_Revs'!H119","v":"Q4"},null,1227299.0999999994,null,null,1227299.0999999994,{"$f":"'8. Funding_Adder_Revs'!L119","v":0},0,27535.782352999988]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K25:K108)","v":99867.569999999992},{"$f":"SUM(L25:L108)","v":1127431.5299999998},{"$f":"K122+L122","v":1227299.0999999999}]

{"sheet":"8B. Opex_Interest_annual","index":9,"n_rows":34,"n_cols":14,"rows_kept":34,"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":3142.8},null,{"$f":"H23+D24+F24","v":3142.8},null,{"$f":"(H24+H23)/2","v":1571.4},null,{"$f":"AVERAGE('8A. Opex_Interest_monthly'!$C$29:$C$32)","v":4.7275000000000005E-2},null,74.287935000000004]
[null,2008,null,{"$f":"'5. SM_Rev_Reqt'!K50","v":0},null,{"$f":"'5. SM_Rev_Reqt'!K58","v":14177.6},null,17320.400000000001,null,10231.6,null,{"$f":"AVERAGE('8A. Opex_Interest_monthly'!$C$33:$C$36)","v":3.9800000000000002E-2},null,407.21768000000003]
[null,2009,null,{"$f":"'5. SM_Rev_Reqt'!M50","v":0},null,{"$f":"'5. SM_Rev_Reqt'!M58","v":102720.23333333334},null,120040.63333333333,null,68680.516666666663,null,{"$f":"AVERAGE('8A. Opex_Interest_monthly'!$C$37:$C$40)","v":1.1375E-2},null,781.24087708333332]
[null,2010,null,{"$f":"'5. SM_Rev_Reqt'!O50","v":99867.57},null,{"$f":"'5. SM_Rev_Reqt'!O58","v":255253.31666666665},null,475161.52,null,297601.07666666666,null,{"$f":"AVERAGE('8A. Opex_Interest_monthly'!$C$41:$C$44)","v":7.9749999999999995E-3},null,2373.3685864166664]
[null,2011,null,{"$f":"'5. SM_Rev_Reqt'!Q50","v":0},null,{"$f":"'5. SM_Rev_Reqt'!Q58","v":355367.78300000005},null,830529.30300000007,null,652845.41150000005,null,{"$f":"AVERAGE('8A. Opex_Interest_monthly'!$C$45:$C$48)","v":1.47E-2},null,9596.82754905]
[null,2012,null,{"$f":"'5. SM_Rev_Reqt'!S50","v":0},null,{"$f":"'5. SM_Rev_Reqt'!S58","v":395062.0083333333},null,1225591.3113333334,null,1028060.3071666667,null,{"$f":"AVERAGE('8A. Opex_Interest_monthly'!N97:N108)","v":1.4699999999999998E-2},null,15112.486515349998]
[null,2013,null,{"$f":"'5. SM_Rev_Reqt'!U50","v":0},null,{"$f":"'5. SM_Rev_Reqt'!U58","v":407757.55066666665},null,1633348.862,null,1429470.0866666667,null,{"$f":"AVERAGE('8A. Opex_Interest_monthly'!N109:N120)","v":0},null,0]
[]
[null,"Cumulative Interest to 2011",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N23:N28)","v":13232.942627550001}]
[null,"Cumulative Interest to 2012",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N23:N29)","v":28345.4291429}]
[null,"Cumulative Interest to 2013",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N23:N30)","v":28345.4291429}]

{"sheet":"9. SMFA_SMDR_SMIRR","index":10,"n_rows":77,"n_cols":23,"rows_kept":77,"cut":false,"hidden":false,"merged":[[19,1,19,3],[53,5,53,6],[27,2,27,3],[25,6,26,14],[50,3,50,4],[46,3,46,18]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,null,2013,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":1476.6240150281774},null,{"$f":"'5. SM_Rev_Reqt'!K70","v":8964.5850269881012},null,{"$f":"'5. SM_Rev_Reqt'!M70","v":152363.89302591319},null,{"$f":"'5. SM_Rev_Reqt'!O70","v":538298.49661455443},null,{"$f":"'5. SM_Rev_Reqt'!Q70","v":630294.86999268399},null,{"$f":"'5. SM_Rev_Reqt'!S70","v":694325.51582852751},null,{"$f":"'5. SM_Rev_Reqt'!U70","v":635123.31865233334},null,{"$f":"SUM(G30:S30)","v":2025723.9845036953}]
[]
[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":26.63523},null,{"$f":"IF($C35=\"X\",K35,IF($C37=\"X\",K37,0))","v":356.68109674999994},null,{"$f":"IF($C35=\"X\",M35,IF($C37=\"X\",M37,0))","v":535.14033999999992},null,{"$f":"IF($C35=\"X\",O35,IF($C37=\"X\",O37,0))","v":2356.1438217500004},null,{"$f":"IF($C35=\"X\",Q35,IF($C37=\"X\",Q37,0))","v":9379.1646269999983},null,{"$f":"IF($C35=\"X\",S35,IF($C37=\"X\",S37,0))","v":14882.017237499995},null,null,null,{"$f":"SUM(G32:S32)","v":27535.782352999995}]
[null,null,"(Check one of the boxes below)"]
[]
[null,null,"X",null,"Sheet 8A (Interest calculated on monthly balances)",null,{"$f":"IF($C35=\"X\",SUM('8A. Opex_Interest_monthly'!O25:O36),\"\")","v":0},null,{"$f":"IF($C35=\"X\",SUM('8A. Opex_Interest_monthly'!O37:O48),\"\")","v":26.63523},null,{"$f":"IF($C35=\"X\",SUM('8A. Opex_Interest_monthly'!O49:O60),\"\")","v":356.68109674999994},null,{"$f":"IF($C35=\"X\",SUM('8A. Opex_Interest_monthly'!O61:O72),\"\")","v":535.14033999999992},null,{"$f":"IF($C35=\"X\",SUM('8A. Opex_Interest_monthly'!O73:O84),\"\")","v":2356.1438217500004},null,{"$f":"IF($C35=\"X\",SUM('8A. Opex_Interest_monthly'!O85:O96),\"\")","v":9379.1646269999983},null,{"$f":"IF($C35=\"X\",SUM('8A. Opex_Interest_monthly'!O97:O108),\"\")","v":14882.017237499995},null,{"$f":"IF($C35=\"X\",SUM('8A. Opex_Interest_monthly'!O109:O120),\"\")","v":0},null,{"$f":"IF($C$35=\"X\",SUM(G35:S35),\"\")","v":27535.782352999995}]
[]
[null,null,null,null,"Sheet 8B (Interest calculated on average annual balances)",null,{"$f":"IF($C37=\"X\",'8B. Opex_Interest_annual'!N23,\"\")","v":""},null,{"$f":"IF($C37=\"X\",'8B. Opex_Interest_annual'!N24,\"\")","v":""},null,{"$f":"IF($C37=\"X\",'8B. Opex_Interest_annual'!N25,\"\")","v":""},null,{"$f":"IF($C37=\"X\",'8B. Opex_Interest_annual'!N26,\"\")","v":""},null,{"$f":"IF($C37=\"X\",'8B. Opex_Interest_annual'!N27,\"\")","v":""},null,{"$f":"IF($C37=\"X\",'8B. Opex_Interest_annual'!N28,\"\")","v":""},null,{"$f":"IF($C37=\"X\",'8B. Opex_Interest_annual'!N29,\"\")","v":""},null,{"$f":"IF($C37=\"X\",'8B. Opex_Interest_annual'!N30,\"\")","v":""},null,{"$f":"IF($C$37=\"X\",SUM(G37:S37),\"\")","v":""}]
[]
[]
[null,null,"SMFA Revenues (from Sheet 8)",null,null,null,{"$f":"SUM('8. Funding_Adder_Revs'!K24:K35)","v":0},null,{"$f":"SUM('8. Funding_Adder_Revs'!K36:K47)","v":0},null,{"$f":"SUM('8. Funding_Adder_Revs'!K48:K59)","v":0},null,{"$f":"SUM('8. Funding_Adder_Revs'!K60:K71)","v":0},null,{"$f":"SUM('8. Funding_Adder_Revs'!K72:K83)","v":0},null,{"$f":"SUM('8. Funding_Adder_Revs'!K84:K95)","v":128872.62000000001},null,{"$f":"SUM('8. Funding_Adder_Revs'!K96:K107)","v":168942.78},null,{"$f":"SUM('8. Funding_Adder_Revs'!K108:K119)","v":0},null,{"$f":"SUM(G40:U40)","v":297815.40000000002}]
[]
[null,null,"SMFA Interest (from Sheet 8)",null,null,null,{"$f":"SUM('8. Funding_Adder_Revs'!M24:M35)","v":0},null,{"$f":"SUM('8. Funding_Adder_Revs'!M36:M47)","v":0},null,{"$f":"SUM('8. Funding_Adder_Revs'!M48:M59)","v":0},null,{"$f":"SUM('8. Funding_Adder_Revs'!M60:M71)","v":0},null,{"$f":"SUM('8. Funding_Adder_Revs'!M72:M83)","v":0},null,{"$f":"SUM('8. Funding_Adder_Revs'!M84:M95)","v":702.06000000000006},null,{"$f":"SUM('8. Funding_Adder_Revs'!M96:M107)","v":2708.9100000000003},null,{"$f":"SUM('8. Funding_Adder_Revs'!M108:M119)","v":0},null,{"$f":"SUM(G42:U42)","v":3410.9700000000003}]
[]
[null,null,"Net Deferred Revenue Requirement",null,null,null,{"$f":"(G30+G32)-(G40+G42)","v":0},null,{"$f":"(I30+I32)-(I40+I42)","v":1503.2592450281775},null,{"$f":"(K30+K32)-(K40+K42)","v":9321.2661237381017},null,{"$f":"(M30+M32)-(M40+M42)","v":152899.0333659132},null,{"$f":"(O30+O32)-(O40+O42)","v":540654.64043630438},null,{"$f":"(Q30+Q32)-(Q40+Q42)","v":510099.35461968399},null,{"$f":"(S30+S32)-(S40+S42)","v":537555.84306602739},null,{"$f":"(U30+U32)-(U40+U42)","v":635123.31865233334},null,{"$f":"(W30+W32)-(W40+W42)","v":1752033.3968566954}]
[]
[null,null,"Number of Metered Customers (average for 2013 test year)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11749]
[null,null,null,"- Number of metered customers for which smart meter were deployed as part of program).  Residential and GS < 50 kW customer classes and any other metered classes involved (e.g. GS 50 to 4999 kW for which interval meters were upgraded to utilize AMI and ODS assets)"]
[]
[null,null,"Calculation of Smart Meter Funding Adder (per metered customer per month)"]
[]
[null,null,null,"Net Deferred Revenues ",null,"May 1, 2006 to December 31, 2012",{"$f":"W44","v":1752033.3968566954}]
[]
[null,null,null,"SMFA",null,"May 1, 2012 to April 30, 201X",{"$f":"IF(U46=0,\"\",ROUND(S44/(U46*12),2))","v":3.81}]
[]
[null,null,null,"Check:  Forecasted SMFA Revenues for 2012 test year",null,null,{"$f":"IF(S46=0,\"\",G53*S46*12)","v":""}]
[]
[null,null,"Calculation of Smart Meter Disposition Rider (per metered customer per month)"]
[]
[null,null,null,"Years for collection or refunding",null,null,4]
[]
[null,null,null,"Deferred Incremental Revenue Requirement from 2006 to December 31, 2012",null,null,{"$f":"SUM(G30:S30)+SUM(G32:S32)","v":2053259.7668566953}]
[null,null,null,null,"plus Interest on OM&A and Amortization"]
[null,null,null,"SMFA Revenues collected from 2006 to 2013 test year (inclusive) ",null,null,{"$f":"W40+SUM(G42:U42)","v":301226.37}]
[null,null,null,null,"Plus Simple Interest on SMFA Revenues"]
[null,null,null,"Net Deferred Revenue Requirement",null,null,{"$f":"G61-G63","v":1752033.3968566954}]
[]
[null,null,null,"SMDR",null,"January 1, 2013 to December 31, 2016",{"$f":"IF(U46=0,\"\",ROUND(G65/(U46*12*G59),2))","v":3.11},null,{"$f":"IF(ISERROR(G69/G65), \"Error\", IF(G69/G65>=95%, \"Match\", \"Error\"))","v":"Match"}]
[]
[null,null,null,"Check:  Forecasted SMDR Revenues",null,null,{"$f":"IF(ISERROR(G67*U46*12*G59), \"\", G67*U46*12*G59)","v":1753890.72}]
[]
[null,null,"Calculation of Smart Meter Incremental Revenue Requirement Rate Rider (per metered customer per month)"]
[]
[null,null,null,"Incremental Revenue Requirement for 2013",null,null,{"$f":"U30","v":635123.31865233334}]
[]
[null,null,null,"SMIRR",null,null,{"$f":"IF(ISERROR(ROUND(G73/(U46*12),2)), \"\", ROUND(G73/(U46*12),2))","v":4.5},null,{"$f":"IF(ISERROR(G77/G73), \"Error\", IF(G77/G73>=95%, \"Match\", \"Error\"))","v":"Match"}]
[]
[null,null,null,"Check:  Forecasted SMIRR Revenues",null,null,{"$f":"IF(ISERROR(G75*U46*12), \"\", G75*U46*12)","v":634446}]