{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["1. Info","2. Table of Contents","3. Data_Input_Sheet","4. Rate_Base","5. Utility Income","6. Taxes_PILs","7. Cost_of_Capital","8. Rev_Def_Suff","9. Rev_Reqt","10A. Bill Impacts - Res (1)","10A. Bill Impacts - Res (2)","10B. Bill Impacts -GS_LT_50 (1)","10B. Bill Impacts -GS_LT_50 (2)"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":1,"defined_names":15,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1. Info","index":0,"n_rows":107,"n_cols":29,"rows_kept":107,"cut":false,"hidden":false,"merged":[[34,1,40,11],[0,2,1,12],[2,2,3,12],[27,4,27,9],[25,4,25,9],[23,4,23,9],[21,4,21,9],[21,1,21,2],[23,1,23,2],[25,1,25,3],[27,1,27,3]]}
[null,null,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,{"$f":"VLOOKUP(AA1, Z21:AA107, 2,0)","v":"PowerStream Inc."},{"$f":"IF('3. Data_Input_Sheet'!M10=0, \"\", '3. Data_Input_Sheet'!M10)","v":"Settlement Agreement"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,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,null,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,"Name:",null,null,"Tom Barrett",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,null,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,"Title:","Title:",null,"Manager, Rates & Applications",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,null,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,"Phone Number:",null,null,"(905) 532-4640",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,null,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,"Email Address:",null,null,"tom.barrett@powersrteam.ca",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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,38,"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,39,"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,40,"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,41,"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,42,"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,43,"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,44,"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,45,"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,46,"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,47,"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,48,"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,49,"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,50,"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,51,"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,52,"Newmarket - Tay Power Distribution Ltd. - Newmarket"]
[null,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. - Tay"]
[null,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. - Niagara Falls"]
[null,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 Peninsula Energy Inc. - Peninsula West"]
[null,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,"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,57,"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,58,"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,59,"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,60,"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,61,"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,62,"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,63,"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,64,"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,65,"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,66,"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,67,"PowerStream 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,68]
[null,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,"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,70,"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,71,"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,72,"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,73,"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,74,"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,75,"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,76,"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,77,"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,78,"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,79,"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,80,"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,81,"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,82,"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,83,"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,84,"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,85,"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,86,"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,87,"Woodstock Hydro Services Inc."]

{"sheet":"2. Table of Contents","index":1,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,2,0,4],[1,3,1,6],[3,3,3,4],[27,1,27,11],[23,1,23,7],[24,1,24,7],[25,1,25,7],[26,1,26,11]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1. Info"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"1. Info",null,null,null,null,"7. Cost_of_Capital"]
[]
[null,null,null,"2. Table of Contents",null,null,null,null,"8. Rev_Def_Suff"]
[]
[null,null,null,"3. Data_Input_Sheet",null,null,null,null,"9. Rev_Reqt"]
[]
[null,null,null,"4. Rate_Base",null,null,null,null,"10A. Bill Impacts - Residential"]
[]
[null,null,null,"5. Utility Income",null,null,null,null,"10B. Bill Impacts - GS_LT_50kW"]
[]
[null,null,null,"6. Taxes_PILs"]
[]
[]
["Notes:"]
["(1)","Pale green cells represent inputs"]
["(2)","Pale green boxes at the bottom of each page are for additional notes"]
["(3)","Pale yellow cells represent drop-down lists"]
["(4)","Please note that this model uses MACROS.  Before starting, please ensure that macros have been enabled."]
["(5)","Completed versions of the Revenue Requirement Work Form are required to be filed in working Microsoft Excel format."]

{"sheet":"3. Data_Input_Sheet","index":2,"n_rows":77,"n_cols":23,"rows_kept":77,"cut":false,"hidden":false,"merged":[[77,2,77,20],[9,4,10,4],[9,8,10,8],[9,20,10,20],[70,2,70,20],[9,12,10,12],[9,16,10,16],[72,2,72,20],[73,2,73,20],[74,2,74,20],[0,2,0,12],[7,4,7,20],[17,24,18,24],[79,2,80,20],[67,2,67,20],[68,2,68,20],[66,2,66,20],[78,2,78,20],[71,2,71,20],[65,2,65,20],[75,2,75,20],[76,2,76,20],[3,2,3,10],[1,2,1,10],[2,2,2,10],[69,2,69,20]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE('2. Table of Contents'!$F$6,\" \",'2. Table of Contents'!$G$6)","v":" "}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Initial Application",null,null,null,{"$f":"IF(ISBLANK(M10),\"\",\"Adjustments\")","v":"Adjustments"},null,null,null,"Settlement Agreement",null,"(6)",null,{"$f":"IF(ISBLANK(M10),\"\",\"Adjustments\")","v":"Adjustments"},null,null,null,"Per Board Decision"]
[]
[]
[null,1,"Rate Base"]
[null,null,"   Gross Fixed Assets (average)",null,805987959.66000009,null,"(8)",null,-2936675,null,null,null,{"$f":"IF(ISBLANK(E14),0,E14+I14)","v":803051284.66000009},null,null,null,-7184145,null,null,null,{"$f":"IF(ISBLANK(E14),\"\",E14+I14+Q14)","v":795867139.66000009}]
[null,null,"   Accumulated Depreciation (average)",null,-86642887.808449835,null,"(5)",null,0,null,null,null,{"$f":"IF(ISBLANK(E15),0,E15+I15)","v":-86642887.808449835},null,null,null,941500.47159071267,null,null,null,{"$f":"IF(ISBLANK(E15),\"\",E15+I15+Q15)","v":-85701387.336859122}]
[null,null,"Allowance for Working Capital:"]
[null,null,"   Controllable Expenses",null,86041000,null,null,null,-6041000,null,null,null,{"$f":"IF(ISBLANK(E17),0,E17+I17)","v":80000000},null,null,null,0,null,null,null,{"$f":"IF(ISBLANK(E17),\"\",E17+I17+Q17)","v":80000000}]
[null,null,"   Cost of Power",null,857779706,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E18),0,E18+I18)","v":857779706},null,null,null,0,null,null,null,{"$f":"IF(ISBLANK(E18),\"\",E18+I18+Q18)","v":857779706}]
[null,null,"   Working Capital Rate (%)",null,0.13,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E19),0,E19)","v":0.13},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(M19),IF(ISBLANK(E19),0,E19),M19)","v":0.13}]
[]
[null,2,"Utility Income"]
[null,null,"Operating Revenues:"]
[null,null,"   Distribution Revenue at Current Rates",null,162044558.16217107,null,null,null,{"$f":"IF(ISBLANK(M23),\"\",IF(ISBLANK(E23),\"\",M23-E23))","v":139518.03675356507},null,null,null,162184076.19892463,null,null,null,{"$f":"IF(ISBLANK(U23),\"\",IF(ISBLANK(M23),\"\",U23-M23))","v":0},null,null,null,{"$f":"M23","v":162184076.19892463}]
[null,null,"   Distribution Revenue at Proposed Rates",null,169870651.28262034,null,null,null,{"$f":"IF(ISBLANK(M24),\"\",IF(ISBLANK(E24),\"\",M24-E24))","v":-7642643.8624749184},null,null,null,162228007.42014542,null,null,null,{"$f":"IF(ISBLANK(U24),\"\",IF(ISBLANK(M24),\"\",U24-M24))","v":-8003233.1226615608},null,null,null,154224774.29748386]
[null,null,"   Other Revenue:"]
[null,null,"      Specific Service Charges",null,3385000,null,null,null,{"$f":"IF(ISBLANK(M26),\"\",IF(ISBLANK(E26),\"\",M26-E26))","v":0},null,null,null,3385000,null,null,null,{"$f":"IF(ISBLANK(U26),\"\",IF(ISBLANK(M26),\"\",U26-M26))","v":0},null,null,null,{"$f":"M26","v":3385000}]
[null,null,"      Late Payment Charges",null,2500000,null,null,null,{"$f":"IF(ISBLANK(M27),\"\",IF(ISBLANK(E27),\"\",M27-E27))","v":0},null,null,null,2500000,null,null,null,{"$f":"IF(ISBLANK(U27),\"\",IF(ISBLANK(M27),\"\",U27-M27))","v":0},null,null,null,{"$f":"M27","v":2500000}]
[null,null,"      Other Distribution Revenue",null,2032000,null,null,null,{"$f":"IF(ISBLANK(M28),\"\",IF(ISBLANK(E28),\"\",M28-E28))","v":0},null,null,null,2032000,null,null,null,{"$f":"IF(ISBLANK(U28),\"\",IF(ISBLANK(M28),\"\",U28-M28))","v":0},null,null,null,{"$f":"M28","v":2032000}]
[null,null,"      Other Income and Deductions",null,1145000,null,null,null,{"$f":"IF(ISBLANK(M29),\"\",IF(ISBLANK(E29),\"\",M29-E29))","v":782598.27254684456},null,null,null,1927598.2725468446,null,null,null,{"$f":"IF(ISBLANK(U29),\"\",IF(ISBLANK(M29),\"\",U29-M29))","v":0},null,null,null,{"$f":"M29","v":1927598.2725468446}]
[]
[null,null,null,"Total Revenue Offsets",{"$f":"SUM(E26:E29)","v":9062000},null,"(7)",null,{"$f":"IF(ISBLANK(M31),\"\",IF(ISBLANK(E31),\"\",M31-E31))","v":782598.27254684456},null,null,null,{"$f":"SUM(M26:M29)","v":9844598.2725468446},null,null,null,{"$f":"IF(ISBLANK(U31),\"\",IF(ISBLANK(M31),\"\",U31-M31))","v":0},null,null,null,{"$f":"SUM(U26:U29)","v":9844598.2725468446}]
[]
[null,null,"Operating Expenses:"]
[null,null,"   OM+A Expenses",null,{"$f":"E17-E36","v":84245961},null,null,null,{"$f":"I17","v":-6041000},null,null,null,{"$f":"IF(ISBLANK(E34),\"\",E34+I34)","v":78204961},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E34),\"\",E34+I34+Q34)","v":78204961}]
[null,null,"   Depreciation/Amortization",null,36607421.642767914,null,"(9)",null,-75990,null,null,null,{"$f":"IF(ISBLANK(E35),\"\",E35+I35)","v":36531431.642767914},null,null,null,-3679036.2469871119,null,null,null,{"$f":"IF(ISBLANK(E35),\"\",E35+I35+Q35)","v":32852395.395780802}]
[null,null,"   Property taxes",null,1795039,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E36),\"\",E36+I36)","v":1795039},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E36),\"\",E36+I36+Q36)","v":1795039}]
[null,null,"   Capital taxes",null,{"$f":"IF(ISBLANK(E46),\"\",E46)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(M46),\"\",M46)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U46),\"\",U46)","v":""}]
[null,null,"   Other expenses",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E38),\"\",E38+I38)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E38),\"\",E38+I38+Q38)","v":""}]
[]
[null,3,"Taxes/PILs"]
[null,null,"Taxable Income:"]
[null,null,null,"Adjustments required to arrive at taxable income",-21082904,null,"(3)",null,null,null,null,null,-20849303.668951001,null,null,null,null,null,null,null,-22732304]
[null,null,"Utility Income Taxes and Rates:"]
[null,null,"   Income taxes (not grossed up)",null,1818117,null,null,null,null,null,null,null,1827039.3029876449,null,null,null,null,null,null,null,1100115.074462069]
[null,null,"   Income taxes (grossed up)",null,{"$f":"IF(ISBLANK(E44),\"\",E44/(1-SUM(E47:E48)))","v":2461463.0087701627},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(M44),\"\",M44/(1-SUM(M47:M48)))","v":2473664.7705855877},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U44),\"\",U44/(1-SUM(U47:U48)))","v":1486626.8895434567}]
[null,null,"   Capital Taxes"]
[null,null,"   Federal tax (%)",null,0.15,null,null,null,null,null,null,null,0.15,null,null,null,null,null,null,null,0.15]
[null,null,"   Provincial tax (%)",null,0.11136732767379762,null,null,null,null,null,null,null,0.111403839067841,null,null,null,null,null,null,null,0.10999248217559525]
[null,null,"Income Tax Credits",null,-710000,null,null,null,null,null,null,null,-717000,null,null,null,null,null,null,null,-717000]
[null,null,"   "]
[null,4,"Capitalization/Cost of Capital"]
[null,null,"Capital Structure:"]
[null,null,"   Long-term debt Capitalization Ratio (%)",null,0.56000000000000005,null,null,null,null,null,null,null,{"$f":"E53","v":0.56000000000000005},null,null,null,null,null,null,null,0.56000000000000005]
[null,null,"   Short-term debt Capitalization Ratio (%)",null,0.04,null,"(2)",null,null,null,null,null,{"$f":"E54","v":0.04},null,"(2)",null,null,null,null,null,0.04,null,"(2)"]
[null,null,"   Common Equity Capitalization Ratio (%)",null,0.4,null,null,null,null,null,null,null,{"$f":"E55","v":0.4},null,null,null,null,null,null,null,0.4]
[null,null,"   Prefered Shares Capitalization Ratio (%)"]
[null,null,null,null,{"$f":"SUM(E53:E56)","v":1},null,null,null,null,null,null,null,{"$f":"SUM(M53:M56)","v":1},null,null,null,null,null,null,null,{"$f":"SUM(U53:U56)","v":1}]
[null,null,null,null,{"$f":"IF(ISBLANK(E55),\"\",IF(SUM(E53:E56)=100%,\"\",\"Capital Structure must total 100%\"))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(M55),\"\",IF(SUM(M53:M56)=100%,\"\",\"Capital Structure must total 100%\"))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U55),\"\",IF(SUM(U53:U56)=100%,\"\",\"Capital Structure must total 100%\"))","v":""}]
[null,null,"Cost of Capital"]
[null,null,"   Long-term debt Cost Rate (%)",null,4.7512918839636299E-2,null,null,null,null,null,null,null,4.6411122931017151E-2,null,null,null,null,null,null,null,4.1454493039772139E-2]
[null,null,"   Short-term debt Cost Rate (%)",null,2.0799999999999999E-2,null,null,null,null,null,null,null,{"$f":"E61","v":2.0799999999999999E-2},null,null,null,null,null,null,null,2.0799999999999999E-2]
[null,null,"   Common Equity Cost Rate (%)",null,9.1200000000000003E-2,null,null,null,null,null,null,null,{"$f":"E62","v":9.1200000000000003E-2},null,null,null,null,null,null,null,8.9300000000000004E-2]
[null,null,"   Prefered Shares Cost Rate (%)"]
[]
["Notes:"]
[null,"General","Data inputs are required on Sheets 3, 10A and 10B. Data from Sheet 3 will automatically complete calculations on sheets 4 through 9 (Rate Base through Revenue Requirement).  Sheets 4 through 9 do not require any inputs except for notes that the Applicant may wish to enter to support the results.  Pale green cells are available on sheets 4 through 9 to enter both footnotes beside key cells and the related text for the notes at the bottom of each sheet."]
[null,"(1)","All inputs are in dollars ($) except where inputs are individually identified as percentages (%)"]
[null,"(2)","4.0% unless an Applicant has proposed or been approved for another amount."]
[null,"(3)","Net of addbacks and deductions to arrive at taxable income."]
[null,"(4)","Average of Gross Fixed Assets at beginning and end of the Test Year"]
[null,"(5)","Average of Accumulated Depreciation at the beginning and end of the Test Year.  Enter as a negative amount."]
[null,"(6)","Select option from drop-down list by clicking on cell M10.  This column allows for the application update reflecting the end of discovery or Argument-in-Chief.  Also, the outcome of any Settlement Process can be reflected."]
[null,"(7)","Input total revenue offsets for deriving the base revenue requirement from the service revenue requirement"]
[null,"(8)","Gross Fixed assets amount is adjusted by the amounts in PP&E deferral account and GEA capital deferral accounts"]
[null,"(9)","Depreciation amount is adjusted by the depreciation of amounts in PP&E deferral and GEA capital deferral accounts"]
[null,"(10)","the \"Initial Application\" amounts reflect the updates made as a result of Staff Interrogatory #5, on August 31, 2012"]
[null,"(11)","The GFA amount Settlement adjustment - due to the CC adjustment for $2M in 2012 and 2013"]

{"sheet":"4. Rate_Base","index":3,"n_rows":34,"n_cols":23,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,3,33,22],[16,22,17,22],[0,2,0,10],[1,2,1,22],[20,3,20,22],[16,6,17,6],[16,10,17,10],[2,2,2,6],[31,1,31,22],[7,5,7,22],[3,2,3,6],[16,3,17,3],[16,14,17,14],[16,18,17,18],[32,3,32,22],[34,3,34,22],[39,3,39,22],[40,3,40,22],[35,3,35,22],[36,3,36,22],[37,3,37,22],[38,3,38,22]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Line No.",null,"Particulars",null,null,"Initial Application",null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M10:M11),\"\",\"Adjustments\")","v":"Adjustments"},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M10:M11),\"\",'3. Data_Input_Sheet'!M10:M11)","v":"Settlement Agreement"},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!Q10:Q11),\"\",'3. Data_Input_Sheet'!Q10:Q11)","v":"Adjustments"},null,null,null,{"$f":"'3. Data_Input_Sheet'!U10","v":"Per Board Decision"}]
[]
[null,1,null,"Gross Fixed Assets (average)","(3)",null,{"$f":"'3. Data_Input_Sheet'!E14","v":805987959.66000009},null,null,null,{"$f":"'3. Data_Input_Sheet'!I14","v":-2936675},null,null,null,{"$f":"G12+K12","v":803051284.66000009},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q14","v":-7184145},null,null,null,{"$f":"G12+K12+S12","v":795867139.66000009}]
[null,2,null,"Accumulated Depreciation (average)","(3)",null,{"$f":"'3. Data_Input_Sheet'!E15","v":-86642887.808449835},null,null,null,{"$f":"'3. Data_Input_Sheet'!I15","v":0},null,null,null,{"$f":"G13+K13","v":-86642887.808449835},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q15","v":941500.47159071267},null,null,null,{"$f":"G13+K13+S13","v":-85701387.336859122}]
[null,3,null,"Net Fixed Assets (average)","(3)",null,{"$f":"SUM(G12:G13)","v":719345071.85155022},null,null,null,{"$f":"SUM(K12:K13)","v":-2936675},null,null,null,{"$f":"SUM(O12:O13)","v":716408396.85155022},null,null,null,{"$f":"SUM(S12:S13)","v":-6242644.5284092873},null,null,null,{"$f":"SUM(W12:W13)","v":710165752.32314098}]
[]
[null,4,null,"Allowance for Working Capital","(1)",null,{"$f":"G29","v":122696691.78},null,null,null,{"$f":"K29","v":-785330},null,null,null,{"$f":"O29","v":121911361.78},null,null,null,{"$f":"S29","v":0},null,null,null,{"$f":"W29","v":121911361.78}]
[null,null,null,"Total Rate Base",null,null,{"$f":"G16+G14","v":842041763.63155019},null,null,null,{"$f":"K16+K14","v":-3722005},null,null,null,{"$f":"O16+O14","v":838319758.63155019},null,null,null,{"$f":"S16+S14","v":-6242644.5284092873},null,null,null,{"$f":"W14+W16","v":832077114.10314095}]
[null,5]
[]
[]
[null,null,"(1)"]
[]
[null,6,null,"Controllable Expenses",null,null,{"$f":"'3. Data_Input_Sheet'!E17","v":86041000},null,null,null,{"$f":"'3. Data_Input_Sheet'!I17","v":-6041000},null,null,null,{"$f":"G23+K23","v":80000000},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q17","v":0},null,null,null,{"$f":"G23+K23+S23","v":80000000}]
[null,7,null,"Cost of Power",null,null,{"$f":"'3. Data_Input_Sheet'!E18","v":857779706},null,null,null,{"$f":"'3. Data_Input_Sheet'!I18","v":0},null,null,null,{"$f":"G24+K24","v":857779706},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q18","v":0},null,null,null,{"$f":"G24+K24+S24","v":857779706}]
[null,8,null,"Working Capital Base",null,null,{"$f":"SUM(G23:G24)","v":943820706},null,null,null,{"$f":"K23+K24","v":-6041000},null,null,null,{"$f":"SUM(O23:O24)","v":937779706},null,null,null,{"$f":"S23+S24","v":0},null,null,null,{"$f":"SUM(W23:W24)","v":937779706}]
[]
[null,9,null,"Working Capital Rate % ","(2)",null,{"$f":"'3. Data_Input_Sheet'!E19","v":0.13},null,null,null,{"$f":"O27-G27","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!M19","v":0.13},null,null,null,{"$f":"W27-O27","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!U19","v":0.13}]
[]
[null,10,null,"Working Capital Allowance",null,null,{"$f":"G25*G27","v":122696691.78},null,null,null,{"$f":"O29-G29","v":-785330},null,null,null,{"$f":"O25*O27","v":121911361.78},null,null,null,{"$f":"W29-O29","v":0},null,null,null,{"$f":"W25*W27","v":121911361.78}]
[]
[]
[null,"Notes"]
[null,"(2)",null,"Some Applicants may have a unique rate as a result of a lead-lag study."]
[null,"(3)",null,"Average of opening and closing balances for the year."]

{"sheet":"5. Utility Income","index":4,"n_rows":46,"n_cols":22,"rows_kept":46,"cut":false,"hidden":false,"merged":[[33,21,34,21],[33,5,34,5],[31,13,32,13],[23,13,24,13],[29,13,30,13],[31,9,32,9],[33,9,34,9],[23,17,24,17],[29,17,30,17],[23,21,24,21],[29,21,30,21],[31,21,32,21],[31,5,32,5],[29,5,30,5],[0,2,0,11],[2,2,2,7],[3,2,3,7],[1,2,1,21],[7,5,7,21],[14,9,15,9],[14,21,15,21],[23,9,24,9],[14,5,15,5],[23,5,24,5],[14,13,15,13],[14,17,15,17],[53,3,53,21],[51,3,51,21],[52,3,52,21],[48,3,48,21],[29,9,30,9],[50,3,50,21],[49,3,49,21],[44,13,45,13],[44,17,45,17],[31,17,32,17],[44,5,45,5],[44,21,45,21],[38,1,38,21],[33,13,34,13],[33,17,34,17],[44,9,45,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Line No.",null,"Particulars                                ",null,"Initial Application   ",null,null,null,{"$f":"IF(N10=\"\",\"\",\"Adjustments\")","v":"Adjustments"},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M10:M11),\"\",'3. Data_Input_Sheet'!M10:M11)","v":"Settlement Agreement"},null,null,null,{"$f":"IF(N10=\"\",\"\",\"Adjustments\")","v":"Adjustments"},null,null,null,{"$f":"'3. Data_Input_Sheet'!U10","v":"Per Board Decision"}]
[]
[null,null,null,"Operating Revenues:"]
[null,1,null,"Distribution Revenue (at Proposed Rates)",null,{"$f":"'3. Data_Input_Sheet'!E24","v":169870651.28262034},null,null,null,{"$f":"N13-F13","v":-7642643.8624749184},null,null,null,{"$f":"'3. Data_Input_Sheet'!M24","v":162228007.42014542},null,null,null,{"$f":"V13-N13","v":-8003233.1226615608},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U24),'5. Utility Income'!N13,'3. Data_Input_Sheet'!U24)","v":154224774.29748386}]
[null,2,null,"Other Revenue","(1)",{"$f":"F45","v":9062000},null,null,null,{"$f":"N14-F14","v":782598.27254684456},null,null,null,{"$f":"N45","v":9844598.2725468446},null,null,null,{"$f":"V14-N14","v":0},null,null,null,{"$f":"V45","v":9844598.2725468446}]
[null,null,null,null,null,{"$f":"SUM(F13:F14)","v":178932651.28262034},null,null,null,{"$f":"SUM(J13:J14)","v":-6860045.5899280738},null,null,null,{"$f":"SUM(N13:N14)","v":172072605.69269228},null,null,null,{"$f":"SUM(R13:R14)","v":-8003233.1226615608},null,null,null,{"$f":"SUM(V13:V14)","v":164069372.57003072}]
[null,3,null,"Total Operating Revenues"]
[]
[null,null,null,"Operating Expenses:"]
[null,4,null,"OM+A Expenses",null,{"$f":"'3. Data_Input_Sheet'!E34","v":84245961},null,null,null,{"$f":"'3. Data_Input_Sheet'!I34","v":-6041000},null,null,null,{"$f":"'3. Data_Input_Sheet'!M34","v":78204961},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q34","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!U34","v":78204961}]
[null,5,null,"Depreciation/Amortization",null,{"$f":"'3. Data_Input_Sheet'!E35","v":36607421.642767914},null,null,null,{"$f":"'3. Data_Input_Sheet'!I35","v":-75990},null,null,null,{"$f":"'3. Data_Input_Sheet'!M35","v":36531431.642767914},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q35","v":-3679036.2469871119},null,null,null,{"$f":"'3. Data_Input_Sheet'!U35","v":32852395.395780802}]
[null,6,null,"Property taxes",null,{"$f":"'3. Data_Input_Sheet'!E36","v":1795039},null,null,null,{"$f":"'3. Data_Input_Sheet'!I36","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!M36","v":1795039},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q36","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!U36","v":1795039}]
[null,7,null,"Capital taxes",null,{"$f":"'6. Taxes_PILs'!G23","v":0},null,null,null,{"$f":"N22-F22","v":0},null,null,null,{"$f":"'6. Taxes_PILs'!K23","v":0},null,null,null,{"$f":"V22-N22","v":0},null,null,null,{"$f":"'6. Taxes_PILs'!O23","v":0}]
[null,8,null,"Other expense",null,{"$f":"'3. Data_Input_Sheet'!E38","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!I38","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!M38","v":""},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q38","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!U38","v":""}]
[null,null,null,null,null,{"$f":"SUM(F19:F23)","v":122648421.64276791},null,null,null,{"$f":"SUM(J19:J23)","v":-6116990},null,null,null,{"$f":"SUM(N19:N23)","v":116531431.64276791},null,null,null,{"$f":"SUM(R19:R23)","v":-3679036.2469871119},null,null,null,{"$f":"SUM(V19:V23)","v":112852395.3957808}]
[null,9,null,"Subtotal (lines 4 to 8)"]
[]
[null,10,null,"Deemed Interest Expense",null,{"$f":"'7. Cost_of_Capital'!P19","v":23104981.453347083},null,null,null,{"$f":"N27-F27","v":-619377.04508991167},null,null,null,{"$f":"'7. Cost_of_Capital'!P35","v":22485604.408257172},null,null,null,{"$f":"V27-N27","v":-2477048.6856436431},null,null,null,{"$f":"'7. Cost_of_Capital'!P51","v":20008555.722613528}]
[]
[null,11,null,"Total Expenses (lines 9 to 10)",null,{"$f":"F24+F27","v":145753403.09611499},null,null,null,{"$f":"J27+J24","v":-6736367.0450899117},null,null,null,{"$f":"N27+N24","v":139017036.05102509},null,null,null,{"$f":"R27+R24","v":-6156084.932630755},null,null,null,{"$f":"V24+V27","v":132860951.11839433}]
[null,null,null,null,null,{"$f":"F15-F29","v":33179248.186505347},null,null,null,{"$f":"J15-J29","v":-123678.54483816214},null,null,null,{"$f":"N15-N29","v":33055569.641667187},null,null,null,{"$f":"R15-R29","v":-1847148.1900308058},null,null,null,{"$f":"V15-V29","v":31208421.451636389}]
[null,12,null,"Utility income before income taxes"]
[null,null,null,null,null,{"$f":"'6. Taxes_PILs'!G29","v":2461463.0087701627},null,null,null,{"$f":"N32-F32","v":12201.761815425009},null,null,null,{"$f":"'6. Taxes_PILs'!K29","v":2473664.7705855877},null,null,null,{"$f":"V32-N32","v":-987037.88104213099},null,null,null,{"$f":"IF('6. Taxes_PILs'!O29=0,N32,'6. Taxes_PILs'!O29)","v":1486626.8895434567}]
[null,13,null,"Income taxes (grossed-up)"]
[null,null,null,null,null,{"$f":"F30-F32","v":30717785.177735183},null,null,null,{"$f":"J30-J32","v":-135880.30665358715},null,null,null,{"$f":"N30-N32","v":30581904.871081598},null,null,null,{"$f":"R30-R32","v":-860110.30898867478},null,null,null,{"$f":"V30-V32","v":29721794.562092934}]
[null,14,null,"Utility net income"]
[]
[]
[]
[null,"Notes"]
[]
[null,"(1)",null,"  Specific Service Charges",null,{"$f":"'3. Data_Input_Sheet'!E26","v":3385000},null,null,null,{"$f":"'3. Data_Input_Sheet'!I26","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!M26","v":3385000},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q26","v":0},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U26),N41,'3. Data_Input_Sheet'!U26)","v":3385000}]
[null,null,null,"  Late Payment Charges",null,{"$f":"'3. Data_Input_Sheet'!E27","v":2500000},null,null,null,{"$f":"'3. Data_Input_Sheet'!I27","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!M27","v":2500000},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q27","v":0},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U27),N42,'3. Data_Input_Sheet'!U27)","v":2500000}]
[null,null,null,"  Other Distribution Revenue",null,{"$f":"'3. Data_Input_Sheet'!E28","v":2032000},null,null,null,{"$f":"'3. Data_Input_Sheet'!I28","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!M28","v":2032000},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q28","v":0},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U28),N43,'3. Data_Input_Sheet'!U28)","v":2032000}]
[null,null,null,"  Other Income and Deductions",null,{"$f":"'3. Data_Input_Sheet'!E29","v":1145000},null,null,null,{"$f":"'3. Data_Input_Sheet'!I29","v":782598.27254684456},null,null,null,{"$f":"'3. Data_Input_Sheet'!M29","v":1927598.2725468446},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q29","v":0},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U29),N44,'3. Data_Input_Sheet'!U29)","v":1927598.2725468446}]
[null,null,null,null,null,{"$f":"SUM(F41:F44)","v":9062000},null,null,null,{"$f":"SUM(J41:J44)","v":782598.27254684456},null,null,null,{"$f":"SUM(N41:N44)","v":9844598.2725468446},null,null,null,{"$f":"SUM(R41:R44)","v":0},null,null,null,{"$f":"SUM(V41:V44)","v":9844598.2725468446}]
[null,null,null,"Total Revenue Offsets"]

{"sheet":"6. Taxes_PILs","index":5,"n_rows":43,"n_cols":15,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,3,42,14],[49,3,49,14],[50,3,50,14],[43,3,43,14],[47,3,47,14],[48,3,48,14],[0,3,0,12],[2,2,2,6],[3,2,3,6],[1,2,1,14],[41,1,41,14],[7,3,7,14],[23,6,24,6],[23,14,24,14],[13,3,13,4],[15,3,15,4],[17,3,17,4],[30,3,30,4],[23,10,24,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Line No.",null,"Particulars ",null,null,"Application",null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M10:M11),\"\",'3. Data_Input_Sheet'!M10:M11)","v":"Settlement Agreement"},null,null,null,{"$f":"'3. Data_Input_Sheet'!U10","v":"Per Board Decision"}]
[]
[null,null,null,"Determination of Taxable Income"]
[]
[null,1,null,"Utility net income before taxes",null,null,{"$f":"'7. Cost_of_Capital'!P22","v":30717683.537278954},null,null,null,{"$f":"'7. Cost_of_Capital'!P38","v":30581904.794878952},null,null,null,{"$f":"'7. Cost_of_Capital'!P54","v":29721794.515764195}]
[]
[null,2,null,"Adjustments required to arrive at taxable utility income",null,null,{"$f":"'3. Data_Input_Sheet'!E42","v":-21082904},null,null,null,{"$f":"'3. Data_Input_Sheet'!M42","v":-20849303.668951001},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U42),G16,'3. Data_Input_Sheet'!U42)","v":-22732304}]
[]
[null,3,null,"Taxable income",null,null,{"$f":"G14+G16","v":9634779.5372789539},null,null,null,{"$f":"K14+K16","v":9732601.1259279512},null,null,null,{"$f":"O14+O16","v":6989490.5157641955}]
[]
[null,null,null,"Calculation of Utility income Taxes"]
[]
[null,4,null,"Income taxes",null,null,{"$f":"'3. Data_Input_Sheet'!E44","v":1818117},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M44),'6. Taxes_PILs'!G22,'3. Data_Input_Sheet'!M44)","v":1827039.3029876449},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U44),'6. Taxes_PILs'!K22,'3. Data_Input_Sheet'!U44)","v":1100115.074462069}]
[null,5,null,"Capital taxes",null,null,{"$f":"'3. Data_Input_Sheet'!E46","v":0},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M46),'6. Taxes_PILs'!G23,'3. Data_Input_Sheet'!M46)","v":0},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U46),'6. Taxes_PILs'!K23,'3. Data_Input_Sheet'!U46)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G22:G23)","v":1818117},null,null,null,{"$f":"SUM(K22:K23)","v":1827039.3029876449},null,null,null,{"$f":"SUM(O22:O23)","v":1100115.074462069}]
[null,6,null,"Total taxes"]
[]
[null,7,null,"Gross-up of Income Taxes",null,null,{"$f":"(G22/(1-G39))-G22","v":643346.00877016271},null,null,null,{"$f":"(K22/(1-K39))-K22","v":646625.4675979428},null,null,null,{"$f":"(O22/(1-O39))-O22","v":386511.81508138776}]
[]
[null,8,null,"Grossed-up Income Taxes",null,null,{"$f":"G22+G27","v":2461463.0087701627},null,null,null,{"$f":"K22+K27","v":2473664.7705855877},null,null,null,{"$f":"O22+O27","v":1486626.8895434567}]
[]
[null,9,null,"PILs / tax Allowance (Grossed-up Income taxes + Capital taxes)",null,null,{"$f":"G24+G27","v":2461463.0087701627},null,null,null,{"$f":"K27+K24","v":2473664.7705855877},null,null,null,{"$f":"O27+O24","v":1486626.8895434567}]
[]
[null,10,null,"Other tax Credits",null,null,{"$f":"'3. Data_Input_Sheet'!E49","v":-710000},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M49),G33,'3. Data_Input_Sheet'!M49)","v":-717000},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U49),K33,'3. Data_Input_Sheet'!U49)","v":-717000}]
[]
[null,null,null,"Tax Rates"]
[]
[null,11,null,"Federal tax (%)",null,null,{"$f":"'3. Data_Input_Sheet'!E47","v":0.15},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M47),G37,'3. Data_Input_Sheet'!M47)","v":0.15},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U47),K37,'3. Data_Input_Sheet'!U47)","v":0.15}]
[null,12,null,"Provincial tax (%)",null,null,{"$f":"'3. Data_Input_Sheet'!E48","v":0.11136732767379762},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M48),G38,'3. Data_Input_Sheet'!M48)","v":0.111403839067841},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U48),K38,'3. Data_Input_Sheet'!U48)","v":0.10999248217559525}]
[null,13,null,"Total tax rate (%)",null,null,{"$f":"G37+G38","v":0.26136732767379761},null,null,null,{"$f":"K37+K38","v":0.26140383906784098},null,null,null,{"$f":"O37+O38","v":0.25999248217559523}]
[]
[]
[null,"Notes"]
[null,null,null,"Capital Taxes not applicable after July 1, 2010 (i.e. for 2011 and later test years)"]

{"sheet":"7. Cost_of_Capital","index":6,"n_rows":62,"n_cols":16,"rows_kept":62,"cut":false,"hidden":false,"merged":[[0,2,0,13],[2,2,2,13],[3,2,3,9],[1,2,1,17],[66,3,66,15],[64,3,64,15],[7,3,7,15],[10,5,10,9],[60,1,60,15],[45,3,45,15],[13,3,13,15],[29,3,29,15],[67,3,67,15],[65,3,65,15],[61,3,61,15],[62,3,62,15],[63,3,63,15]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Line No.",null,"Particulars",null,"Capitalization Ratio",null,null,null,null,null,"Cost Rate",null,null,null,"Return"]
[]
[]
[]
[null,null,null,null,null,"(%)",null,null,null,"($)",null,"(%)",null,null,null,"($)"]
[null,null,null,"Debt"]
[null,1,null,"  Long-term Debt",null,{"$f":"'3. Data_Input_Sheet'!E53","v":0.56000000000000005},null,null,null,{"$f":"$J$26*F17","v":471543387.63366812},null,{"$f":"'3. Data_Input_Sheet'!E60","v":4.7512918839636299E-2},null,null,null,{"$f":"L17*J17","v":22404402.706005633}]
[null,2,null,"  Short-term Debt",null,{"$f":"'3. Data_Input_Sheet'!E54","v":0.04},null,null,null,{"$f":"$J$26*F18","v":33681670.545262009},null,{"$f":"'3. Data_Input_Sheet'!E61","v":2.0799999999999999E-2},null,null,null,{"$f":"L18*J18","v":700578.74734144972}]
[null,3,null,"Total Debt",null,{"$f":"SUM(F17:F18)","v":0.60000000000000009},null,null,null,{"$f":"SUM(J17:J18)","v":505225058.17893016},null,{"$f":"IF(F19=0,0,SUMPRODUCT(F17:F18,L17:L18)/F19)","v":4.5732057583660543E-2},null,null,null,{"$f":"SUM(P17:P18)","v":23104981.453347083}]
[]
[null,null,null,"Equity"]
[null,4,null,"  Common Equity",null,{"$f":"'3. Data_Input_Sheet'!E55","v":0.4},null,null,null,{"$f":"$J$26*F22","v":336816705.45262009},null,{"$f":"'3. Data_Input_Sheet'!E62","v":9.1200000000000003E-2},null,null,null,{"$f":"L22*J22","v":30717683.537278954}]
[null,5,null,"  Preferred Shares",null,{"$f":"'3. Data_Input_Sheet'!E56","v":0},null,null,null,{"$f":"$J$26*F23","v":0},null,{"$f":"'3. Data_Input_Sheet'!E63","v":0},null,null,null,{"$f":"L23*J23","v":0}]
[null,6,null,"Total Equity",null,{"$f":"SUM(F22:F23)","v":0.4},null,null,null,{"$f":"SUM(J22:J23)","v":336816705.45262009},null,{"$f":"IF(F24=0,0,SUMPRODUCT(F22:F23,L22:L23)/F24)","v":9.1200000000000003E-2},null,null,null,{"$f":"SUM(P22:P23)","v":30717683.537278954}]
[]
[null,7,null,"Total",null,{"$f":"SUM(F19,F24)","v":1},null,null,null,{"$f":"'4. Rate_Base'!G17","v":842041763.63155019},null,{"$f":"(L19*F19)+(L24*F24)","v":6.3919234550196338E-2},null,null,null,{"$f":"P19+P24","v":53822664.990626037}]
[]
[]
[]
[]
[null,null,null,null,null,"(%)",null,null,null,"($)",null,"(%)",null,null,null,"($)"]
[null,null,null,"Debt"]
[null,1,null,"  Long-term Debt",null,{"$f":"'3. Data_Input_Sheet'!M53","v":0.56000000000000005},null,null,null,{"$f":"$J$42*F33","v":469459064.83366817},null,{"$f":"'3. Data_Input_Sheet'!M60","v":4.6411122931017151E-2},null,null,null,{"$f":"L33*J33","v":21788122.369075723}]
[null,2,null,"  Short-term Debt",null,{"$f":"'3. Data_Input_Sheet'!M54","v":0.04},null,null,null,{"$f":"$J$42*F34","v":33532790.34526201},null,{"$f":"'3. Data_Input_Sheet'!M61","v":2.0799999999999999E-2},null,null,null,{"$f":"L34*J34","v":697482.0391814498}]
[null,3,null,"Total Debt",null,{"$f":"SUM(F33:F34)","v":0.60000000000000009},null,null,null,{"$f":"SUM(J33:J34)","v":502991855.17893016},null,{"$f":"IF(F35=0,0,SUMPRODUCT(F33:F34,L33:L34)/F35)","v":4.4703714735616004E-2},null,null,null,{"$f":"SUM(P33:P34)","v":22485604.408257172}]
[]
[null,null,null,"Equity"]
[null,4,null,"  Common Equity",null,{"$f":"'3. Data_Input_Sheet'!M55","v":0.4},null,null,null,{"$f":"$J$42*F38","v":335327903.45262009},null,{"$f":"'3. Data_Input_Sheet'!M62","v":9.1200000000000003E-2},null,null,null,{"$f":"L38*J38","v":30581904.794878952}]
[null,5,null,"  Preferred Shares",null,{"$f":"'3. Data_Input_Sheet'!M56","v":0},null,null,null,{"$f":"$J$42*F39","v":0},null,{"$f":"'3. Data_Input_Sheet'!M63","v":0},null,null,null,{"$f":"L39*J39","v":0}]
[null,6,null,"Total Equity",null,{"$f":"SUM(F38:F39)","v":0.4},null,null,null,{"$f":"SUM(J38:J39)","v":335327903.45262009},null,{"$f":"IF(F40=0,0,SUMPRODUCT(F38:F39,L38:L39)/F40)","v":9.1200000000000003E-2},null,null,null,{"$f":"SUM(P38:P39)","v":30581904.794878952}]
[]
[null,7,null,"Total",null,{"$f":"F35+F40","v":1},null,null,null,{"$f":"'4. Rate_Base'!O17","v":838319758.63155019},null,{"$f":"(L35*F35)+(L40*F40)","v":6.3302228841369615E-2},null,null,null,{"$f":"P35+P40","v":53067509.203136124}]
[]
[]
[]
[]
[null,null,null,null,null,"(%)",null,null,null,"($)",null,"(%)",null,null,null,"($)"]
[null,null,null,"Debt"]
[null,8,null,"  Long-term Debt",null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U53),F33,'3. Data_Input_Sheet'!U53)","v":0.56000000000000005},null,null,null,{"$f":"$J$58*F49","v":465963183.89775896},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U60),L17,'3. Data_Input_Sheet'!U60)","v":4.1454493039772139E-2},null,null,null,{"$f":"L49*J49","v":19316267.563679714}]
[null,9,null,"  Short-term Debt",null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U54),F34,'3. Data_Input_Sheet'!U54)","v":0.04},null,null,null,{"$f":"$J$58*F50","v":33283084.564125638},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U61),L18,'3. Data_Input_Sheet'!U61)","v":2.0799999999999999E-2},null,null,null,{"$f":"L50*J50","v":692288.15893381322}]
[null,10,null,"Total Debt",null,{"$f":"SUM(F49:F50)","v":0.60000000000000009},null,null,null,{"$f":"SUM(J49:J50)","v":499246268.46188462},null,{"$f":"IF(F51=0,0,SUMPRODUCT(F49:F50,L49:L50)/F51)","v":4.007752683712066E-2},null,null,null,{"$f":"SUM(P49:P50)","v":20008555.722613528}]
[]
[null,null,null,"Equity"]
[null,11,null,"  Common Equity",null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U55),F38,'3. Data_Input_Sheet'!U55)","v":0.4},null,null,null,{"$f":"$J$58*F54","v":332830845.64125639},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U62),L22,'3. Data_Input_Sheet'!U62)","v":8.9300000000000004E-2},null,null,null,{"$f":"L54*J54","v":29721794.515764195}]
[null,12,null,"  Preferred Shares",null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U56),F39,'3. Data_Input_Sheet'!U56)","v":0},null,null,null,{"$f":"$J$58*F55","v":0},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U63),L23,'3. Data_Input_Sheet'!U63)","v":0},null,null,null,{"$f":"L55*J55","v":0}]
[null,13,null,"Total Equity",null,{"$f":"SUM(F54:F55)","v":0.4},null,null,null,{"$f":"SUM(J54:J55)","v":332830845.64125639},null,{"$f":"IF(F56=0,0,SUMPRODUCT(F54:F55,L54:L55)/F56)","v":8.9300000000000004E-2},null,null,null,{"$f":"SUM(P54:P55)","v":29721794.515764195}]
[]
[null,14,null,"Total",null,{"$f":"F51+F56","v":1},null,null,null,{"$f":"'4. Rate_Base'!W17","v":832077114.10314095},null,{"$f":"(L51*F51)+(L56*F56)","v":5.9766516102272405E-2},null,null,null,{"$f":"P51+P56","v":49730350.23837772}]
[]
[]
[null,"Notes"]
[null,"(1)",null,{"$f":"'3. Data_Input_Sheet'!C68","v":"4.0% unless an Applicant has proposed or been approved for another amount."}]

{"sheet":"8. Rev_Def_Suff","index":7,"n_rows":53,"n_cols":16,"rows_kept":53,"cut":false,"hidden":false,"merged":[[55,3,55,15],[52,3,52,15],[53,3,53,15],[54,3,54,15],[51,1,51,8],[7,5,7,15],[11,11,12,11],[0,2,0,14],[1,2,1,14],[2,2,2,14],[3,2,3,7],[9,5,9,7],[11,1,12,1],[11,3,12,3],[9,9,9,11],[11,7,12,7],[11,15,12,15],[11,13,12,13],[11,5,12,5],[11,9,12,9],[9,13,9,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE('2. Table of Contents'!$F$6,\" \",'2. Table of Contents'!$G$6)","v":" "}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Initial Application",null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M10:M11),\"\",'3. Data_Input_Sheet'!M10:M11)","v":"Settlement Agreement"},null,null,null,{"$f":"'3. Data_Input_Sheet'!U10","v":"Per Board Decision"}]
[]
[null,"Line No.",null,"Particulars",null,"At Current Approved Rates",null,"At Proposed Rates",null,"At Current Approved Rates",null,"At Proposed Rates",null,"At Current Approved Rates",null,"At Proposed Rates"]
[]
[]
[]
[null,1,null,"Revenue Deficiency from Below",null,null,null,{"$f":"F49","v":7812587.7679909328},null,null,null,{"$f":"J49","v":44066.530836811078},null,null,null,{"$f":"N49","v":-7959166.9303921973}]
[null,2,null,"Distribution Revenue",null,{"$f":"'3. Data_Input_Sheet'!E23","v":162044558.16217107},null,{"$f":"'3. Data_Input_Sheet'!E24-H16","v":162058063.51462939},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M23),'3. Data_Input_Sheet'!E23,'3. Data_Input_Sheet'!M23)","v":162184076.19892463},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M24),'3. Data_Input_Sheet'!E24-L16,'3. Data_Input_Sheet'!M24-L16)","v":162183940.8893086},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U23),'3. Data_Input_Sheet'!M23,'3. Data_Input_Sheet'!U23)","v":162184076.19892463},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U24),'3. Data_Input_Sheet'!M24-P16,'3. Data_Input_Sheet'!U24-P16)","v":162183941.22787607}]
[null,3,null,"Other Operating Revenue Offsets - net",null,{"$f":"'5. Utility Income'!F45","v":9062000},null,{"$f":"'5. Utility Income'!F45","v":9062000},null,{"$f":"'5. Utility Income'!N45","v":9844598.2725468446},null,{"$f":"J18","v":9844598.2725468446},null,{"$f":"'5. Utility Income'!V45","v":9844598.2725468446},null,{"$f":"'5. Utility Income'!V45","v":9844598.2725468446}]
[null,4,null,"Total Revenue",null,{"$f":"SUM(F17:F18)","v":171106558.16217107},null,{"$f":"SUM(H16:H18)","v":178932651.28262034},null,{"$f":"SUM(J17:J18)","v":172028674.47147149},null,{"$f":"SUM(L16:L18)","v":172072605.69269228},null,{"$f":"SUM(N17:N18)","v":172028674.47147149},null,{"$f":"SUM(P16:P18)","v":164069372.57003072}]
[]
[null,5,null,"Operating Expenses",null,{"$f":"'5. Utility Income'!F24","v":122648421.64276791},null,{"$f":"'5. Utility Income'!F24","v":122648421.64276791},null,{"$f":"'5. Utility Income'!N24","v":116531431.64276791},null,{"$f":"'5. Utility Income'!N24","v":116531431.64276791},null,{"$f":"'5. Utility Income'!V24","v":112852395.3957808},null,{"$f":"'5. Utility Income'!V24","v":112852395.3957808}]
[null,6,null,"Deemed Interest Expense",null,{"$f":"'5. Utility Income'!F27","v":23104981.453347083},null,{"$f":"'5. Utility Income'!F27","v":23104981.453347083},null,{"$f":"'5. Utility Income'!N27","v":22485604.408257172},null,{"$f":"'5. Utility Income'!N27","v":22485604.408257172},null,{"$f":"'5. Utility Income'!V27","v":20008555.722613528},null,{"$f":"'5. Utility Income'!V27","v":20008555.722613528}]
[null,null,null,"Total Cost and Expenses",null,{"$f":"SUM(F21:F22)","v":145753403.09611499},null,{"$f":"SUM(H21:H22)","v":145753403.09611499},null,{"$f":"SUM(J21:J22)","v":139017036.05102509},null,{"$f":"SUM(L21:L22)","v":139017036.05102509},null,{"$f":"SUM(N21:N22)","v":132860951.11839433},null,{"$f":"SUM(P21:P22)","v":132860951.11839433}]
[]
[null,7,null,"Utility Income Before Income Taxes",null,{"$f":"F19-F23","v":25353155.066056073},null,{"$f":"H19-H23","v":33179248.186505347},null,{"$f":"J19-J23","v":33011638.420446396},null,{"$f":"L19-L23","v":33055569.641667187},null,{"$f":"N19-N23","v":39167723.353077158},null,{"$f":"P19-P23","v":31208421.451636389}]
[null,null,null,"   "]
[null,8,null,"Tax Adjustments to Accounting               Income per 2009 PILs",null,{"$f":"'3. Data_Input_Sheet'!E42","v":-21082904},null,{"$f":"'3. Data_Input_Sheet'!E42","v":-21082904},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M42),'3. Data_Input_Sheet'!E42,'3. Data_Input_Sheet'!M42)","v":-20849303.668951001},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M42),'3. Data_Input_Sheet'!E42,'3. Data_Input_Sheet'!M42)","v":-20849303.668951001},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U42),'3. Data_Input_Sheet'!M42,'3. Data_Input_Sheet'!U42)","v":-22732304},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U42),'3. Data_Input_Sheet'!M42,'3. Data_Input_Sheet'!U42)","v":-22732304}]
[null,9,null,"Taxable Income",null,{"$f":"SUM(F25:F27)","v":4270251.0660560727},null,{"$f":"SUM(H25:H27)","v":12096344.186505347},null,{"$f":"SUM(J25+J27)","v":12162334.751495395},null,{"$f":"L25+L27","v":12206265.972716186},null,{"$f":"SUM(N25+N27)","v":16435419.353077158},null,{"$f":"P25+P27","v":8476117.4516363889}]
[]
[null,10,null,"Income Tax Rate",null,{"$f":"'6. Taxes_PILs'!G39","v":0.26136732767379761},null,{"$f":"'6. Taxes_PILs'!G39","v":0.26136732767379761},null,{"$f":"'6. Taxes_PILs'!K39","v":0.26140383906784098},null,{"$f":"'6. Taxes_PILs'!K39","v":0.26140383906784098},null,{"$f":"'6. Taxes_PILs'!O39","v":0.25999248217559523},null,{"$f":"'6. Taxes_PILs'!O39","v":0.25999248217559523}]
[null,11,null,"Income Tax on Taxable Income",null,{"$f":"F28*F30","v":1116104.1096312611},null,{"$f":"H28*H30","v":3161589.1546493801},null,{"$f":"J28*J30","v":3179280.9960691119},null,{"$f":"L28*L30","v":3190764.7859511655},null,{"$f":"N28*N30","v":4273085.4732033461},null,{"$f":"P28*P30","v":2203726.8154628254}]
[null,12,null,"Income Tax Credits",null,{"$f":"'3. Data_Input_Sheet'!E49","v":-710000},null,{"$f":"'3. Data_Input_Sheet'!E49","v":-710000},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M49),'3. Data_Input_Sheet'!E49,'3. Data_Input_Sheet'!M49)","v":-717000},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M49),'3. Data_Input_Sheet'!E49,'3. Data_Input_Sheet'!M49)","v":-717000},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U49),'3. Data_Input_Sheet'!M49,'3. Data_Input_Sheet'!U49)","v":-717000},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U49),'3. Data_Input_Sheet'!M49,'3. Data_Input_Sheet'!U49)","v":-717000}]
[null,13,null,"Utility Net Income ",null,{"$f":"F25-SUM(F31:F32)","v":24947050.95642481},null,{"$f":"'5. Utility Income'!F34","v":30717785.177735183},null,{"$f":"J25-SUM(J31:J32)","v":30549357.424377285},null,{"$f":"'5. Utility Income'!N34","v":30581904.871081598},null,{"$f":"N25-SUM(N31:N32)","v":35611637.879873812},null,{"$f":"'5. Utility Income'!V34","v":29721794.562092934}]
[]
[null,14,null,"Utility Rate Base",null,{"$f":"'4. Rate_Base'!G17","v":842041763.63155019},null,{"$f":"'4. Rate_Base'!G17","v":842041763.63155019},null,{"$f":"'4. Rate_Base'!O17","v":838319758.63155019},null,{"$f":"'4. Rate_Base'!O17","v":838319758.63155019},null,{"$f":"'4. Rate_Base'!W17","v":832077114.10314095},null,{"$f":"'4. Rate_Base'!W17","v":832077114.10314095}]
[]
[null,null,null,"Deemed Equity Portion of Rate Base ",null,{"$f":"'7. Cost_of_Capital'!J24","v":336816705.45262009},null,{"$f":"F37","v":336816705.45262009},null,{"$f":"'7. Cost_of_Capital'!J40","v":335327903.45262009},null,{"$f":"J37","v":335327903.45262009},null,{"$f":"'7. Cost_of_Capital'!J56","v":332830845.64125639},null,{"$f":"N37","v":332830845.64125639}]
[]
[null,15,null,"Income/(Equity Portion of Rate Base)",null,{"$f":"IF(F37=0,0,F33/F37)","v":7.4067142610698397E-2},null,{"$f":"IF(H37=0,0,H33/H37)","v":9.1200301767859454E-2},null,{"$f":"IF(J37=0,0,J33/J37)","v":9.110293867534866E-2},null,{"$f":"IF(L37=0,0,L33/L37)","v":9.1200000227248154E-2},null,{"$f":"IF(N37=0,0,N33/N37)","v":0.106996206470172},null,{"$f":"IF(P37=0,0,P33/P37)","v":8.9300000139196048E-2}]
[null,16,null,"Target Return - Equity on Rate Base",null,{"$f":"'7. Cost_of_Capital'!L24","v":9.1200000000000003E-2},null,{"$f":"'7. Cost_of_Capital'!L24","v":9.1200000000000003E-2},null,{"$f":"'7. Cost_of_Capital'!L40","v":9.1200000000000003E-2},null,{"$f":"'7. Cost_of_Capital'!L40","v":9.1200000000000003E-2},null,{"$f":"'7. Cost_of_Capital'!L56","v":8.9300000000000004E-2},null,{"$f":"'7. Cost_of_Capital'!L56","v":8.9300000000000004E-2}]
[null,17,null,"Deficiency/Sufficiency in Return on Equity",null,{"$f":"F39-F40","v":-1.7132857389301606E-2},null,{"$f":"H39-H40","v":3.0176785945079665E-7},null,{"$f":"J39-J40","v":-9.7061324651342984E-5},null,{"$f":"L39-L40","v":2.2724815085251038E-10},null,{"$f":"N39-N40","v":1.7696206470171991E-2},null,{"$f":"P39-P40","v":1.3919604358036963E-10}]
[]
[null,18,null,"Indicated Rate of Return",null,{"$f":"IF(F35=0,0,(F33+F22)/F35)","v":5.7066091594475683E-2},null,{"$f":"IF(H35=0,0,(H33+H22)/H35)","v":6.3919355257340105E-2},null,{"$f":"IF(J35=0,0,(J33+J22)/J35)","v":6.3263404311509078E-2},null,{"$f":"IF(L37=0,0,(L33+L22)/L35)","v":6.3302228932268861E-2},null,{"$f":"IF(N35=0,0,(N33+N22)/N35)","v":6.6844998690341204E-2},null,{"$f":"IF(P37=0,0,(P33+P22)/P35)","v":5.9766516157950818E-2}]
[null,19,null,"Requested Rate of Return on Rate Base",null,{"$f":"'7. Cost_of_Capital'!L26","v":6.3919234550196338E-2},null,{"$f":"'7. Cost_of_Capital'!L26","v":6.3919234550196338E-2},null,{"$f":"'7. Cost_of_Capital'!L42","v":6.3302228841369615E-2},null,{"$f":"'7. Cost_of_Capital'!L42","v":6.3302228841369615E-2},null,{"$f":"'7. Cost_of_Capital'!L58","v":5.9766516102272405E-2},null,{"$f":"'7. Cost_of_Capital'!L58","v":5.9766516102272405E-2}]
[null,20,null,"Deficiency/Sufficiency in Rate of Return",null,{"$f":"F43-F44","v":-6.853142955720655E-3},null,{"$f":"H43-H44","v":1.2070714376644087E-7},null,{"$f":"J43-J44","v":-3.8824529860537194E-5},null,{"$f":"L43-L44","v":9.0899246463216343E-11},null,{"$f":"N43-N44","v":7.078482588068799E-3},null,{"$f":"P43-P44","v":5.5678413268811511E-11}]
[]
[null,21,null,"Target Return on Equity",null,{"$f":"H47","v":30717683.537278954},null,{"$f":"'7. Cost_of_Capital'!P24","v":30717683.537278954},null,{"$f":"L47","v":30581904.794878952},null,{"$f":"'7. Cost_of_Capital'!P40","v":30581904.794878952},null,{"$f":"P47","v":29721794.515764195},null,{"$f":"'7. Cost_of_Capital'!P56","v":29721794.515764195}]
[null,22,null,"Revenue Deficiency/(Sufficiency)",null,{"$f":"F47-F33","v":5770632.5808541439}," ",{"$f":"H35*H45","v":101.64045622002095},null,{"$f":"J47-J33","v":32547.370501667261},null,{"$f":"L35*L45","v":7.6202634354833321E-2},null,{"$f":"N47-N33","v":-5889843.3641096167},null,{"$f":"P35*P45","v":4.6328733430554714E-2}]
[null,23,null,"Gross Revenue Deficiency/(Sufficiency)",null,{"$f":"F48/(1-F30)","v":7812587.7679909328},"(1)",null,null,{"$f":"J48/(1-J30)","v":44066.530836811078},"(1)",null,null,{"$f":"N48/(1-N30)","v":-7959166.9303921973},"(1)"]
[]
[]
[null,"Notes:"]
[null,"(1)",null,"Revenue Deficiency/Sufficiency divided by (1 - Tax Rate)"]

{"sheet":"9. Rev_Reqt","index":8,"n_rows":35,"n_cols":17,"rows_kept":35,"cut":false,"hidden":false,"merged":[[27,13,27,14],[28,9,29,9],[30,9,31,9],[30,5,31,5],[28,5,29,5],[28,13,29,14],[30,13,31,14],[26,13,26,14],[14,13,14,14],[15,13,15,14],[18,13,18,14],[19,13,19,14],[25,13,25,14],[23,13,23,14],[24,13,24,14],[33,1,33,14],[0,2,0,13],[0,14,0,16],[40,3,40,14],[35,3,35,14],[36,3,36,14],[37,3,37,14],[38,3,38,14],[16,13,16,14],[12,13,12,14],[13,13,13,14],[17,13,17,14],[21,13,21,14],[1,2,1,17],[2,2,2,17],[39,3,39,14],[3,2,3,13],[11,13,11,14],[10,13,10,14],[9,13,9,14],[7,5,7,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Line No.",null,"Particulars",null,"Application   ",null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M10:M11),\"\",'3. Data_Input_Sheet'!M10:M11)","v":"Settlement Agreement"},null,null,null,{"$f":"'3. Data_Input_Sheet'!U10","v":"Per Board Decision"}]
[]
[null,1,null,"OM&A Expenses",null,{"$f":"'5. Utility Income'!F19","v":84245961},null,null,null,{"$f":"'5. Utility Income'!N19","v":78204961},null,null,null,{"$f":"'5. Utility Income'!V19","v":78204961}]
[null,2,null,"Amortization/Depreciation",null,{"$f":"'5. Utility Income'!F20","v":36607421.642767914},null,null,null,{"$f":"'5. Utility Income'!N20","v":36531431.642767914},null,null,null,{"$f":"'5. Utility Income'!V20","v":32852395.395780802}]
[null,3,null,"Property Taxes",null,{"$f":"'5. Utility Income'!F21","v":1795039},null,null,null,{"$f":"'5. Utility Income'!N21","v":1795039},null,null,null,{"$f":"'5. Utility Income'!V21","v":1795039}]
[null,4,null,"Capital Taxes",null,{"$f":"'6. Taxes_PILs'!G23","v":0},null,null,null,{"$f":"'6. Taxes_PILs'!K23","v":0},null,null,null,{"$f":"'6. Taxes_PILs'!O23","v":0}]
[null,5,null,"Income Taxes (Grossed up)",null,{"$f":"'6. Taxes_PILs'!G31-F15","v":2461463.0087701627},null,null,null,{"$f":"'6. Taxes_PILs'!K31-J15","v":2473664.7705855877},null,null,null,{"$f":"'6. Taxes_PILs'!O31-N15","v":1486626.8895434567}]
[null,6,null,"Other Expenses",null,{"$f":"'5. Utility Income'!F23","v":0},null,null,null,{"$f":"'5. Utility Income'!N23","v":""},null,null,null,{"$f":"'5. Utility Income'!V23","v":""}]
[null,7,null,"Return"]
[null,null,null,"  Deemed Interest Expense",null,{"$f":"'8. Rev_Def_Suff'!F22","v":23104981.453347083},null,null,null,{"$f":"'8. Rev_Def_Suff'!L22","v":22485604.408257172},null,null,null,{"$f":"'8. Rev_Def_Suff'!P22","v":20008555.722613528}]
[null,null,null,"  Return on Deemed Equity",null,{"$f":"'8. Rev_Def_Suff'!F47","v":30717683.537278954},null,null,null,{"$f":"'8. Rev_Def_Suff'!L47","v":30581904.794878952},null,null,null,{"$f":"'8. Rev_Def_Suff'!P47","v":29721794.515764195}]
[]
[null,8,null,"Service Revenue Requirement (before Revenues)",null,{"$f":"SUM(F12:F20)","v":178932549.64216411},null,null,null,{"$f":"SUM(J12:J20)","v":172072605.61648962},null,null,null,{"$f":"SUM(N12:O20)","v":164069372.523702}]
[]
[null,9,null,"Revenue Offsets",null,{"$f":"'3. Data_Input_Sheet'!E31","v":9062000},null,null,null,{"$f":"'3. Data_Input_Sheet'!M31","v":9844598.2725468446},null,null,null,{"$f":"'3. Data_Input_Sheet'!U31","v":9844598.2725468446}]
[null,10,null,"Base Revenue Requirement",null,{"$f":"F22-F24","v":169870549.64216411},null,null,null,{"$f":"J22-J24","v":162228007.34394276},null,null,null,{"$f":"N22-N24","v":154224774.25115514}]
[]
[null,11,null,"Distribution revenue",null,{"$f":"'5. Utility Income'!F13","v":169870651.28262034},null,null,null,{"$f":"'5. Utility Income'!N13","v":162228007.42014542},null,null,null,{"$f":"'5. Utility Income'!V13","v":154224774.29748386}]
[null,12,null,"Other revenue",null,{"$f":"'5. Utility Income'!F14","v":9062000},null,null,null,{"$f":"'5. Utility Income'!N14","v":9844598.2725468446},null,null,null,{"$f":"'5. Utility Income'!V14","v":9844598.2725468446}]
[null,null,null,null,null,{"$f":"SUM(F27:F28)","v":178932651.28262034},null,null,null,{"$f":"SUM(J27:J28)","v":172072605.69269228},null,null,null,{"$f":"SUM(N27:N28)","v":164069372.57003072}]
[null,13,null,"Total revenue"]
[null,null,null,null,null,{"$f":"F29-F22","v":101.64045622944832},null,null,null,{"$f":"J29-J22","v":7.6202660799026489E-2},null,null,null,{"$f":"N29-N22","v":4.6328723430633545E-2}]
[null,14,null,"Difference (Total Revenue Less Distribution Revenue Requirement before Revenues)",null,null,null,"(1)",null,null,null,"(1)",null,null,null,null,"(1)"]
[]
[null,"Notes"]
[null,"(1)",null,"Line 11 - Line 8"]

{"sheet":"10A. Bill Impacts - Res (1)","index":9,"n_rows":53,"n_cols":23,"rows_kept":53,"cut":false,"hidden":false,"merged":[[50,1,50,16],[51,1,51,16],[1,2,1,14],[53,1,53,16],[54,1,54,16],[52,1,52,16],[11,5,12,5],[11,15,12,15],[11,16,12,16],[0,16,0,17],[10,7,10,9],[10,11,10,13],[10,15,10,16],[7,5,7,16],[0,2,0,12],[2,2,2,12],[3,2,3,9]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE('2. Table of Contents'!$F$6,\" \",'2. Table of Contents'!$G$6)","v":" "},null,null,null,null,null,1]
[]
[]
[]
[]
[]
[]
[null,"monthly"]
[null,"per kWh",null,null,null,"Consumption",null,800," kWh"]
[null,"per kW"]
[null,null,null,null,null,null,null,"Current Board-Approved",null,null,null,"Proposed",null,null,null,"Impact"]
[null,null,null,null,null,"Charge Unit",null,"Rate","Volume","Charge",null,"Rate","Volume","Charge",null,"$ Change","% Change"]
[null,null,null,null,null,null,null,"($)",null,"($)",null,"($)",null,"($)"]
[null,1,null,"Monthly Service Charge",null,"monthly",null,11.99,1,{"$f":"I14*H14","v":11.99},null,12.34,1,{"$f":"M14*L14","v":12.34},null,{"$f":"N14-J14","v":0.34999999999999964},{"$f":"IF((J14)=0,\"\",(P14/J14))","v":2.9190992493744756E-2}]
[null,2,null,"Smart Meter Rate Adder",null,"monthly",null,1.28,1,{"$f":"I15*H15","v":1.28},null,null,1,{"$f":"M15*L15","v":0},null,{"$f":"N15-J15","v":-1.28},{"$f":"IF((J15)=0,\"\",(P15/J15))","v":-1}]
[null,3,null,"Service Charge Rate Adder(s)",null,"monthly",null,null,1,0,null,0.2,1,{"$f":"M16*L16","v":0.2},null,{"$f":"N16-J16","v":0.2},{"$f":"IF((J16)=0,\"\",(P16/J16))","v":""}]
[null,4,null,"Service Charge Rate Rider(s)",null,"monthly",null,0.14000000000000001,1,0.14000000000000001,null,-0.04,1,-0.04,null,-0.18000000000000002,-1.2857142857142858]
[null,5,null,"Distribution Volumetric Rate",null,"per kWh",null,1.35E-2,{"$f":"H9","v":800},10.8,null,1.3599999999999999E-2,{"$f":"H9","v":800},10.879999999999999,null,7.9999999999998295E-2,7.407407407407249E-3]
[null,6,null,"Low Voltage Rate Adder",null,"per kWh",null,1E-4,{"$f":"I18","v":800},0.08,null,2.9999999999999997E-4,{"$f":"M18","v":800},0.24,null,0.15999999999999998,1.9999999999999996]
[null,7,null,"Volumetric Rate Adder(s)",null,"per kWh",null,-4.0000000000000002E-4,800,-0.32,null,null,800,0,null,0.32,-1]
[null,8,null,"Volumetric Rate Rider(s)",null,null,null,null,800,0,null,null,800,0,null,0,""]
[null,9,null,"Smart Meter Disposition Rider",null,null,null,null,800,0,null,null,800,0,null,0,""]
[null,10,null,"LRAM & SSM Rate Rider",null,null,null,null,800,0,null,null,800,0,null,0,""]
[null,11,null,"Deferral/Variance Account Disposition Rate Rider",null,null,null,null,800,0,null,-1.9E-3,800,-1.52,null,-1.52,""]
[null,12,null,"Stranded Assets Rate Rider",null,null,null,null,null,0,null,1.4E-3,{"$f":"M24","v":800},1.1199999999999999,null,1.1199999999999999,""]
[null,13,null,null,null,null,null,null,null,0,null,null,null,0,null,0,""]
[null,14,null,null,null,null,null,null,null,0,null,null,null,0,null,0,""]
[null,15,null,null,null,null,null,null,null,0,null,null,null,0,null,0,""]
[null,16,null,"Sub-Total A - Distribution",null,null,null,null,null,{"$f":"SUM(J14:J28)","v":23.97},null,null,null,{"$f":"SUM(N14:N28)","v":23.22},null,-0.75,-3.1289111389236547E-2]
[null,17,null,"RTSR - Network",null,"per kWh",null,7.3000000000000001E-3,{"$f":"H9*(1+H47)","v":823.92000000000007},6.0146160000000002,null,7.1000000000000004E-3,{"$f":"H9*(1+L47)","v":827.6},{"$f":"M30*L30","v":5.8759600000000001},null,-0.13865600000000011,-2.3053175797091634E-2]
[null,18,null,"RTSR - Line and Transformation Connection",null,"per kWh",null,2.7000000000000001E-3,{"$f":"I30","v":823.92000000000007},2.2245840000000001,null,3.2000000000000002E-3,{"$f":"M30","v":827.6},{"$f":"M31*L31","v":2.64832},null,0.42373599999999989,0.19047875917474902]
[null,19,null,"Sub-Total B - Delivery (including Sub-Total A)",null,null,null,null,null,{"$f":"SUM(J29:J31)","v":32.209199999999996},null,null,null,{"$f":"SUM(N29:N31)","v":31.744279999999996},null,-0.46491999999999933,-1.4434385206711108E-2]
[null,20,null,"Wholesale Market Service Charge (WMSC)",null,"per kWh",null,5.1999999999999998E-3,{"$f":"I31","v":823.92000000000007},4.2843840000000002,null,5.1999999999999998E-3,{"$f":"IF(W1=2, H9*(1+H47), H9*(1+L47))","v":827.6},{"$f":"M33*L33","v":4.3035199999999998},null,1.9135999999999598E-2,4.4664530536944391E-3]
[null,21,null,"Rural and Remote Rate Protection (RRRP)",null,"per kWh",null,1.1000000000000001E-3,{"$f":"I31","v":823.92000000000007},0.90631200000000012,null,1.1000000000000001E-3,{"$f":"IF(W1=2, H9*(1+H47), H9*(1+L47))","v":827.6},0.91036000000000006,null,4.0479999999999405E-3,4.4664530536944668E-3]
[null,22,null,"Special Purpose Charge",null,"per kWh",null,0,{"$f":"I31","v":823.92000000000007},{"$f":"I35*H35","v":0},null,0,{"$f":"IF(W1=2, H9*(1+H47), H9*(1+L47))","v":827.6},{"$f":"M35*L35","v":0},null,{"$f":"N35-J35","v":0},{"$f":"IF((J35)=0,\"\",(P35/J35))","v":""}]
[null,23,null,"Standard Supply Service Charge",null,"monthly",null,0.25,1,0.25,null,0.25,1,0.25,null,0,0]
[null,24,null,"Debt Retirement Charge (DRC)",null,"per kWh",null,7.0000000000000001E-3,{"$f":"H9","v":800},5.6000000000000005,null,7.0000000000000001E-3,{"$f":"H9","v":800},5.6000000000000005,null,0,0]
[null,25,null,"Energy",null,"per kWh",null,7.6162099999999996E-2,{"$f":"I35","v":823.92000000000007},62.751477432000001,null,{"$f":"H38","v":7.6162099999999996E-2},{"$f":"IF(W1=2, H9*(1+H47), H9*(1+L47))","v":827.6},63.031753959999996,null,0.28027652799999458,4.4664530536944469E-3]
[null,26,null,null,null,"per kWh",null,null,null,0,null,null,null,0,null,0,""]
[null,27,null,null,null,null,null,null,null,0,null,null,null,0,null,0,""]
[null,28,null,"Total Bill (before Taxes)",null,null,null,null,null,{"$f":"SUM(J32:J40)","v":106.00137343200001},null,null,null,{"$f":"SUM(N32:N40)","v":105.83991395999999},null,-0.16145947200001842,-1.5231828303016739E-3]
[null,29,null,"HST",null,null,null,0.13,null,{"$f":"J41*H42","v":13.780178546160002},null,0.13,null,{"$f":"N41*L42","v":13.7591888148},null,-2.098973136000204E-2,-1.5231828303016478E-3]
[null,30,null,"Total Bill (including Sub-total B)",null,null,null,null,null,{"$f":"ROUND(SUM(J41:J42),2)","v":119.78},null,null,null,{"$f":"ROUND(SUM(N41:N42),2)","v":119.6},null,-0.18000000000000682,-1.5027550509267558E-3]
[null,31,null,"Ontario Clean Energy Benefit (OCEB)",null,null,null,-0.1,null,{"$f":"ROUND(-J43*10%,2)","v":-11.98},null,-0.1,null,{"$f":"ROUND(-N43*10%,2)","v":-11.96},null,{"$f":"N44-J44","v":1.9999999999999574E-2},{"$f":"IF((J44)=0,\"\",(P44/J44))","v":-1.6694490818029693E-3}]
[null,32,null,"Total Bill (including OCEB)",null,null,null,null,null,{"$f":"J43+J44","v":107.8},null,null,null,{"$f":"N43+N44","v":107.63999999999999},null,{"$f":"N45-J45","v":-0.1600000000000108},{"$f":"IF((J45)=0,\"\",(P45/J45))","v":-1.4842300556587274E-3}]
[]
[null,33,null,"Loss Factor (%)",null,"Note 1",null,2.9899999999999999E-2,null,null,null,3.4500000000000003E-2]
[]
[null,"Notes:"]
[null,"(1):  Enter existing and proposed total loss factor (Secondary Metered Customer < 5,000 kW) as a percentage."]
[null,"(2) The weighted average commodity charge is used in this template, so the results will be comparable with"]
[null,"the calculation when two tier prices are used.There is a small rounding difference to Appendix 2-V."]
[null,"(3) These Bill Impacts are for PowerStream South  rate zone"]

{"sheet":"10A. Bill Impacts - Res (2)","index":10,"n_rows":53,"n_cols":23,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,16,0,17],[10,7,10,9],[10,11,10,13],[10,15,10,16],[7,5,7,16],[0,2,0,12],[2,2,2,12],[3,2,3,9],[11,15,12,15],[11,16,12,16],[1,2,1,14],[53,1,53,16],[54,1,54,16],[50,1,50,16],[51,1,51,16],[52,1,52,16],[11,5,12,5]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE('2. Table of Contents'!$F$6,\" \",'2. Table of Contents'!$G$6)","v":" "},null,null,null,null,null,1]
[]
[]
[]
[]
[]
[]
[null,"monthly"]
[null,"per kWh",null,null,null,"Consumption",null,800," kWh"]
[null,"per kW"]
[null,null,null,null,null,null,null,"Current Board-Approved",null,null,null,"Proposed",null,null,null,"Impact"]
[null,null,null,null,null,"Charge Unit",null,"Rate","Volume","Charge",null,"Rate","Volume","Charge",null,"$ Change","% Change"]
[null,null,null,null,null,null,null,"($)",null,"($)",null,"($)",null,"($)"]
[null,1,null,"Monthly Service Charge",null,"monthly",null,15.34,1,{"$f":"I14*H14","v":15.34},null,12.34,1,{"$f":"M14*L14","v":12.34},null,{"$f":"N14-J14","v":-3},{"$f":"IF((J14)=0,\"\",(P14/J14))","v":-0.19556714471968709}]
[null,2,null,"Smart Meter Rate Adder",null,"monthly",null,null,1,0,null,null,1,0,null,0,""]
[null,3,null,"Service Charge Rate Adder(s)",null,"monthly",null,null,1,0,null,0.2,1,0.2,null,0.2,""]
[null,4,null,"Service Charge Rate Rider(s)",null,"monthly",null,1.78,1,1.78,null,-0.04,1,-0.04,null,-1.82,-1.0224719101123596]
[null,5,null,"Distribution Volumetric Rate",null,"per kWh",null,1.37E-2,{"$f":"H9","v":800},10.96,null,1.3599999999999999E-2,{"$f":"H9","v":800},10.879999999999999,null,-8.0000000000001847E-2,-7.2992700729928688E-3]
[null,6,null,"Low Voltage Rate Adder",null,"per kWh",null,8.0000000000000004E-4,{"$f":"I18","v":800},0.64,null,2.9999999999999997E-4,{"$f":"M18","v":800},0.24,null,-0.4,-0.625]
[null,7,null,"Volumetric Rate Adder(s)",null,"per kWh",null,null,800,0,null,null,800,0,null,0,""]
[null,8,null,"Volumetric Rate Rider(s)",null,"per kWh",null,-5.9999999999999995E-4,800,-0.48,null,null,800,0,null,0.48,-1]
[null,9,null,"Smart Meter Disposition Rider",null,"per kWh",null,null,800,0,null,null,800,0,null,0,""]
[null,10,null,"LRAM & SSM Rate Rider",null,"per kWh",null,4.0000000000000002E-4,800,0.32,null,4.0000000000000002E-4,800,0.32,null,0,0]
[null,11,null,"Deferral/Variance Account Disposition Rate Rider",null,"per kWh",null,-5.9999999999999995E-4,800,-0.48,null,-2.0999999999999999E-3,800,-1.68,null,-1.2,2.5]
[null,12,null,"Stranded Assets Rate Rider",null,"per kWh",null,null,null,0,null,1.6999999999999999E-3,{"$f":"M24","v":800},1.3599999999999999,null,1.3599999999999999,""]
[null,13,null,null,null,null,null,null,null,0,null,null,null,0,null,0,""]
[null,14,null,null,null,null,null,null,null,0,null,null,null,0,null,0,""]
[null,15,null,null,null,null,null,null,null,0,null,null,null,0,null,0,""]
[null,16,null,"Sub-Total A - Distribution",null,null,null,null,null,{"$f":"SUM(J14:J28)","v":28.080000000000002},null,null,null,{"$f":"SUM(N14:N28)","v":23.619999999999997},null,-4.4600000000000044,-0.15883190883190898]
[null,17,null,"RTSR - Network",null,"per kWh",null,6.8999999999999999E-3,{"$f":"H9*(1+H47)","v":845.2},{"$f":"I30*H30","v":5.83188},null,7.1000000000000004E-3,{"$f":"H9*(1+L47)","v":827.6},{"$f":"M30*L30","v":5.8759600000000001},null,4.4080000000000119E-2,7.5584545635369932E-3]
[null,18,null,"RTSR - Line and Transformation Connection",null,"per kWh",null,5.4000000000000003E-3,{"$f":"I30","v":845.2},{"$f":"I31*H31","v":4.5640800000000006},null,3.2000000000000002E-3,{"$f":"M30","v":827.6},{"$f":"M31*L31","v":2.64832},null,-1.9157600000000006,-0.41974724369423855]
[null,19,null,"Sub-Total B - Delivery (including Sub-Total A)",null,null,null,null,null,{"$f":"SUM(J29:J31)","v":38.475960000000001},null,null,null,{"$f":"SUM(N29:N31)","v":32.144279999999995},null,-6.3316800000000057,-0.16456197584153862]
[null,20,null,"Wholesale Market Service Charge (WMSC)",null,"per kWh",null,5.1999999999999998E-3,{"$f":"I31","v":845.2},{"$f":"I33*H33","v":4.3950399999999998},null,{"$f":"H33","v":5.1999999999999998E-3},{"$f":"IF(W1=2, H9*(1+H47), H9*(1+L47))","v":827.6},{"$f":"M33*L33","v":4.3035199999999998},null,-9.1520000000000046E-2,-2.0823473734027459E-2]
[null,21,null,"Rural and Remote Rate Protection (RRRP)",null,"per kWh",null,1.1000000000000001E-3,{"$f":"I31","v":845.2},0.9297200000000001,null,1.1000000000000001E-3,{"$f":"IF(W1=2, H9*(1+H47), H9*(1+L47))","v":827.6},0.91036000000000006,null,-1.9360000000000044E-2,-2.0823473734027494E-2]
[null,22,null,"Special Purpose Charge",null,"per kWh",null,null,{"$f":"I31","v":845.2},0,null,0,{"$f":"IF(W1=2, H9*(1+H47), H9*(1+L47))","v":827.6},0,null,0,""]
[null,23,null,"Standard Supply Service Charge",null,"monthly",null,0.25,1,0.25,null,0.25,1,0.25,null,0,0]
[null,24,null,"Debt Retirement Charge (DRC)",null,"per kWh",null,7.0000000000000001E-3,{"$f":"H9","v":800},5.6000000000000005,null,7.0000000000000001E-3,{"$f":"H9","v":800},5.6000000000000005,null,0,0]
[null,25,null,"Energy",null,"per kWh",null,7.6466000000000006E-2,{"$f":"I35","v":845.2},64.629063200000004,null,7.6466000000000006E-2,{"$f":"IF(W1=2, H9*(1+H47), H9*(1+L47))","v":827.6},63.28326160000001,null,-1.3458015999999944,-2.0823473734027362E-2]
[null,26,null,null,null,null,null,null,null,0,null,null,null,0,null,0,""]
[null,27,null,null,null,null,null,null,null,0,null,null,null,0,null,0,""]
[null,28,null,"Total Bill (before Taxes)",null,null,null,null,null,{"$f":"SUM(J32:J40)","v":114.27978320000001},null,null,null,{"$f":"SUM(N32:N40)","v":106.4914216},null,-7.788361600000016,-6.8151700868820123E-2]
[null,29,null,"HST",null,null,null,0.13,null,{"$f":"J41*H42","v":14.856371816000001},null,0.13,null,{"$f":"N41*L42","v":13.843884808},null,-1.0124870080000008,-6.8151700868820039E-2]
[null,30,null,"Total Bill (including Sub-total B)",null,null,null,null,null,{"$f":"ROUND(SUM(J41:J42),2)","v":129.13999999999999},null,null,null,{"$f":"ROUND(SUM(N41:N42),2)","v":120.34},null,-8.7999999999999829,-6.8143100511073126E-2]
[null,31,null,"Ontario Clean Energy Benefit (OCEB)",null,null,null,-0.1,null,{"$f":"ROUND(-J43*10%,2)","v":-12.91},null,-0.1,null,{"$f":"ROUND(-N43*10%,2)","v":-12.03},null,0.88000000000000078,-6.8164213787761482E-2]
[null,32,null,"Total Bill (including OCEB)",null,null,null,null,null,{"$f":"J43+J44","v":116.22999999999999},null,null,null,{"$f":"N43+N44","v":108.31},null,-7.9199999999999875,-6.8140755398778188E-2]
[]
[null,33,null,"Loss Factor (%)",null,"Note 1",null,5.6500000000000002E-2,null,null,null,3.4500000000000003E-2]
[]
[null,"Notes:"]
[null,"(1):  Enter existing and proposed total loss factor (Secondary Metered Customer < 5,000 kW) as a percentage."]
[null,"(2) The weighted average commodity charge is used in this template, so the results will be comparable with"]
[null,"the calculation when two tier prices are used. There is a small rounding difference to Appendix 2-V."]
[null,"(3) These Bill Impacts are for PowerStream Barrie  rate zone"]

{"sheet":"10B. Bill Impacts -GS_LT_50 (1)","index":11,"n_rows":53,"n_cols":23,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,16,0,17],[10,7,10,9],[10,11,10,13],[10,15,10,16],[7,5,7,16],[51,1,51,16],[52,1,52,16],[53,1,53,16],[54,1,54,16],[11,15,12,15],[11,16,12,16],[11,5,12,5],[50,1,50,16]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE('2. Table of Contents'!$F$6,\" \",'2. Table of Contents'!$G$6)","v":" "},null,null,null,null,null,1]
[]
[]
[]
[]
[]
[]
[null,"monthly"]
[null,"per kWh",null,null,null,"Consumption",null,2000," kWh"]
[null,"per kW"]
[null,null,null,null,null,null,null,"Current Board-Approved",null,null,null,"Proposed",null,null,null,"Impact"]
[null,null,null,null,null,"Charge Unit",null,"Rate","Volume","Charge",null,"Rate","Volume","Charge",null,"$ Change","% Change"]
[null,null,null,null,null,null,null,"($)",null,"($)",null,"($)",null,"($)"]
[null,1,null,"Monthly Service Charge",null,"monthly",null,28.64,1,{"$f":"I14*H14","v":28.64},null,25.39,1,{"$f":"M14*L14","v":25.39},null,{"$f":"N14-J14","v":-3.25},{"$f":"IF((J14)=0,\"\",(P14/J14))","v":-0.11347765363128491}]
[null,2,null,"Smart Meter Rate Adder",null,"monthly",null,1.01,1,1.01,null,null,1,0,null,-1.01,-1]
[null,3,null,"Service Charge Rate Adder(s)",null,"monthly",null,null,1,0,null,0.55000000000000004,1,0.55000000000000004,null,0.55000000000000004,""]
[null,4,null,"Service Charge Rate Rider(s)",null,"monthly",null,3.37,1,3.37,null,0.22,1,0.22,null,-3.15,-0.93471810089020768]
[null,5,null,"Distribution Volumetric Rate",null,"per kWh",null,1.1599999999999999E-2,{"$f":"H9","v":2000},23.2,null,1.35E-2,{"$f":"H9","v":2000},27,null,3.8000000000000007,0.16379310344827588]
[null,6,null,"Low Voltage Rate Adder",null,"per kWh",null,1E-4,{"$f":"I18","v":2000},0.2,null,2.9999999999999997E-4,{"$f":"M18","v":2000},0.6,null,0.39999999999999997,1.9999999999999998]
[null,7,null,"Volumetric Rate Adder(s)",null,"per kWh",null,null,2000,0,null,null,2000,0,null,0,""]
[null,8,null,"Volumetric Rate Rider(s)",null,"per kWh",null,-2.9999999999999997E-4,2000,-0.6,null,null,2000,0,null,0.6,-1]
[null,9,null,"Smart Meter Disposition Rider",null,"per kWh",null,null,2000,0,null,null,2000,0,null,0,""]
[null,10,null,"LRAM & SSM Rider",null,"per kWh",null,null,2000,0,null,null,2000,0,null,0,""]
[null,11,null,"Deferral/Variance Account Disposition Rate Rider",null,"per kWh",null,null,2000,0,null,-1.8E-3,2000,-3.6,null,-3.6,""]
[null,12,null,"Stranded Assets Rate Rider",null,null,null,null,null,0,null,1.6999999999999999E-3,{"$f":"M24","v":2000},3.4,null,3.4,""]
[null,13,null,null,null,null,null,null,null,0,null,null,null,0,null,0,""]
[null,14,null,null,null,null,null,null,null,0,null,null,null,0,null,0,""]
[null,15,null,null,null,null,null,null,null,0,null,null,null,0,null,0,""]
[null,16,null,"Sub-Total A - Distribution",null,null,null,null,null,{"$f":"SUM(J14:J28)","v":55.82},null,null,null,{"$f":"SUM(N14:N28)","v":53.559999999999995},null,-2.2600000000000051,-4.0487280544607762E-2]
[null,17,null,"RTSR - Network",null,"per kWh",null,6.6E-3,{"$f":"H9*(1+H47)","v":2059.8000000000002},{"$f":"I30*H30","v":13.59468},null,6.4999999999999997E-3,{"$f":"H9*(1+L47)","v":2069},{"$f":"M30*L30","v":13.448499999999999},null,-0.14618000000000109,-1.0752735628937282E-2]
[null,18,null,"RTSR - Line and Transformation Connection",null,"per kWh",null,2.3999999999999998E-3,{"$f":"I30","v":2059.8000000000002},{"$f":"I31*H31","v":4.9435200000000004},null,2.8E-3,{"$f":"M30","v":2069},{"$f":"M31*L31","v":5.7931999999999997},null,0.84967999999999932,0.17187752856264346]
[null,19,null,"Sub-Total B - Delivery (including Sub-Total A)",null,null,null,null,null,{"$f":"SUM(J29:J31)","v":74.358200000000011},null,null,null,{"$f":"SUM(N29:N31)","v":72.801699999999997},null,-1.556500000000014,-2.093245936561151E-2]
[null,20,null,"Wholesale Market Service Charge (WMSC)",null,"per kWh",null,5.1999999999999998E-3,{"$f":"I31","v":2059.8000000000002},{"$f":"I33*H33","v":10.71096},null,5.1999999999999998E-3,{"$f":"IF(W1=2, H9*(1+H47), H9*(1+L47))","v":2069},{"$f":"M33*L33","v":10.758799999999999},null,4.7839999999998994E-2,4.46645305369444E-3]
[null,21,null,"Rural and Remote Rate Protection (RRRP)",null,"per kWh",null,1.1000000000000001E-3,{"$f":"I31","v":2059.8000000000002},2.2657800000000003,null,1.1000000000000001E-3,{"$f":"IF(W1=2, H9*(1+H47), H9*(1+L47))","v":2069},2.2759,null,1.0119999999999685E-2,4.466453053694394E-3]
[null,22,null,"Special Purpose Charge",null,"per kWh",null,null,{"$f":"I31","v":2059.8000000000002},0,null,null,{"$f":"IF(W1=2, H9*(1+H47), H9*(1+L47))","v":2069},0,null,0,""]
[null,23,null,"Standard Supply Service Charge",null,"monthly",null,0.25,1,0.25,null,0.25,1,0.25,null,0,0]
[null,24,null,"Debt Retirement Charge (DRC)",null,"per kWh",null,7.0000000000000001E-3,{"$f":"H9","v":2000},14,null,7.0000000000000001E-3,{"$f":"H9","v":2000},14,null,0,0]
[null,25,null,"Energy",null,"per kWh",null,8.3260000000000001E-2,{"$f":"I35","v":2059.8000000000002},171.49894800000001,null,8.3260000000000001E-2,{"$f":"IF(W1=2, H9*(1+H47), H9*(1+L47))","v":2069},172.26494,null,0.76599199999998291,4.4664530536944339E-3]
[null,26,null,null,null,null,null,null,null,{"$f":"I39*H39","v":0},null,null,null,0,null,0,""]
[null,27,null,null,null,null,null,null,null,{"$f":"I40*H40","v":0},null,null,null,0,null,0,""]
[null,28,null,"Total Bill (before Taxes)",null,null,null,null,null,{"$f":"SUM(J32:J40)","v":273.083888},null,null,null,{"$f":"SUM(N32:N40)","v":272.35133999999999},null,-0.73254800000000841,-2.682501722694121E-3]
[null,29,null,"HST",null,null,null,{"$f":"'10A. Bill Impacts - Res (1)'!H42","v":0.13},null,{"$f":"J41*H42","v":35.500905440000004},null,{"$f":"'10A. Bill Impacts - Res (1)'!L42","v":0.13},null,{"$f":"N41*L42","v":35.4056742},null,-9.5231240000003936E-2,-2.6825017226942008E-3]
[null,30,null,"Total Bill (including Sub-total B)",null,null,null,null,null,{"$f":"ROUND(SUM(J41:J42),2)","v":308.58},null,null,null,{"$f":"ROUND(SUM(N41:N42),2)","v":307.76},null,-0.81999999999999318,-2.6573335925853692E-3]
[null,31,null,"Ontario Clean Energy Benefit (OCEB)",null,null,null,-0.1,null,{"$f":"ROUND(-J43*10%,2)","v":-30.86},null,-0.1,null,{"$f":"ROUND(-N43*10%,2)","v":-30.78},null,7.9999999999998295E-2,-2.5923525599480979E-3]
[null,32,null,"Total Bill (including OCEB)",null,null,null,null,null,{"$f":"J43+J44","v":277.71999999999997},null,null,null,{"$f":"N43+N44","v":276.98},null,-0.73999999999995225,-2.6645542272791026E-3]
[]
[null,33,null,"Loss Factor",null,"(1)",null,2.9899999999999999E-2,null,null,null,3.4500000000000003E-2]
[]
[null,"Notes:"]
[null,"(1):  See Note (1) from Sheet 10A. Bill Impacts - Residential"]
[null,"(2) The weighted average commodity charge is used in this template, so the results will be comparable with"]
[null,"the calculation when two tier prices are used. There is a rounding difference to Appendix 2-V."]
[null,"(3) These Bill Impacts are for PowerStream South  rate zone"]

{"sheet":"10B. Bill Impacts -GS_LT_50 (2)","index":12,"n_rows":53,"n_cols":23,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,16,0,17],[10,7,10,9],[10,11,10,13],[10,15,10,16],[7,5,7,16],[53,1,53,16],[54,1,54,16],[11,15,12,15],[11,16,12,16],[11,5,12,5],[50,1,50,16],[51,1,51,16],[52,1,52,16]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE('2. Table of Contents'!$F$6,\" \",'2. Table of Contents'!$G$6)","v":" "},null,null,null,null,null,1]
[]
[]
[]
[]
[]
[]
[null,"monthly"]
[null,"per kWh",null,null,null,"Consumption",null,2000," kWh"]
[null,"per kW"]
[null,null,null,null,null,null,null,"Current Board-Approved",null,null,null,"Proposed",null,null,null,"Impact"]
[null,null,null,null,null,"Charge Unit",null,"Rate","Volume","Charge",null,"Rate","Volume","Charge",null,"$ Change","% Change"]
[null,null,null,null,null,null,null,"($)",null,"($)",null,"($)",null,"($)"]
[null,1,null,"Monthly Service Charge",null,"monthly",null,16.11,1,{"$f":"I14*H14","v":16.11},null,25.39,1,{"$f":"M14*L14","v":25.39},null,{"$f":"N14-J14","v":9.2800000000000011},{"$f":"IF((J14)=0,\"\",(P14/J14))","v":0.57603972687771576}]
[null,2,null,"Smart Meter Rate Adder",null,"monthly",null,null,1,0,null,null,1,0,null,0,""]
[null,3,null,"Service Charge Rate Adder(s)",null,"monthly",null,4.7300000000000004,1,4.7300000000000004,null,0.55000000000000004,1,0.55000000000000004,null,-4.1800000000000006,-0.88372093023255816]
[null,4,null,"Service Charge Rate Rider(s)",null,"monthly",null,null,1,0,null,0.22,1,0.22,null,0.22,""]
[null,5,null,"Distribution Volumetric Rate",null,"per kWh",null,1.6400000000000001E-2,{"$f":"H9","v":2000},32.800000000000004,null,1.35E-2,{"$f":"H9","v":2000},27,null,-5.8000000000000043,-0.17682926829268303]
[null,6,null,"Low Voltage Rate Adder",null,"per kWh",null,6.9999999999999999E-4,{"$f":"I18","v":2000},1.4,null,2.9999999999999997E-4,{"$f":"M18","v":2000},0.6,null,-0.79999999999999993,-0.5714285714285714]
[null,7,null,"Volumetric Rate Adder(s)",null,"per kWh",null,null,2000,0,null,null,2000,0,null,0,""]
[null,8,null,"Volumetric Rate Rider(s)",null,"per kWh",null,-4.0000000000000002E-4,2000,-0.8,null,null,2000,0,null,0.8,-1]
[null,9,null,"Smart Meter Disposition Rider",null,"per kWh",null,null,2000,0,null,null,2000,0,null,0,""]
[null,10,null,"LRAM & SSM Rider",null,"per kWh",null,6.9999999999999999E-4,2000,1.4,null,{"$f":"H23","v":6.9999999999999999E-4},2000,1.4,null,0,0]
[null,11,null,"Deferral/Variance Account Disposition Rate Rider",null,"per kWh",null,-4.0000000000000002E-4,2000,-0.8,null,{"$f":"H24","v":-4.0000000000000002E-4},2000,-0.8,null,0,0]
[null,12,null,"Deferral/Variance Account Disposition Rate Rider",null,"per kWh",null,null,null,0,null,-1.6000000000000001E-3,{"$f":"M24","v":2000},-3.2,null,-3.2,""]
[null,13,null,"Stranded Assets Rate Rider",null,"per kWh",null,null,null,0,null,2.2000000000000001E-3,{"$f":"M25","v":2000},4.4000000000000004,null,4.4000000000000004,""]
[null,14,null,null,null,null,null,null,null,0,null,null,null,0,null,0,""]
[null,15,null,null,null,null,null,null,null,0,null,null,null,0,null,0,""]
[null,16,null,"Sub-Total A - Distribution",null,null,null,null,null,{"$f":"SUM(J14:J28)","v":54.84},null,null,null,{"$f":"SUM(N14:N28)","v":55.559999999999995},null,0.71999999999999176,1.3129102844638798E-2]
[null,17,null,"RTSR - Network",null,"per kWh",null,6.3E-3,{"$f":"H9*(1+H47)","v":2113},{"$f":"I30*H30","v":13.3119},null,6.4999999999999997E-3,{"$f":"H9*(1+L47)","v":2069},{"$f":"M30*L30","v":13.448499999999999},null,0.13659999999999961,1.0261495353781175E-2]
[null,18,null,"RTSR - Line and Transformation Connection",null,"per kWh",null,4.7999999999999996E-3,{"$f":"I30","v":2113},{"$f":"I31*H31","v":10.142399999999999},null,2.8E-3,{"$f":"M30","v":2069},{"$f":"M31*L31","v":5.7931999999999997},null,-4.3491999999999988,-0.42881369301151595]
[null,19,null,"Sub-Total B - Delivery (including Sub-Total A)",null,null,null,null,null,{"$f":"SUM(J29:J31)","v":78.294299999999993},null,null,null,{"$f":"SUM(N29:N31)","v":74.801699999999997},null,-3.4925999999999959,-4.4608611354849538E-2]
[null,20,null,"Wholesale Market Service Charge (WMSC)",null,"per kWh",null,5.1999999999999998E-3,{"$f":"I31","v":2113},{"$f":"I33*H33","v":10.987599999999999},null,5.1999999999999998E-3,{"$f":"IF(W1=2, H9*(1+H47), H9*(1+L47))","v":2069},{"$f":"M33*L33","v":10.758799999999999},null,-0.22879999999999967,-2.0823473734027421E-2]
[null,21,null,"Rural and Remote Rate Protection (RRRP)",null,"per kWh",null,1.1000000000000001E-3,{"$f":"I31","v":2113},2.3243,null,1.1000000000000001E-3,{"$f":"IF(W1=2, H9*(1+H47), H9*(1+L47))","v":2069},2.2759,null,-4.8399999999999999E-2,-2.0823473734027449E-2]
[null,22,null,"Special Purpose Charge",null,"per kWh",null,null,{"$f":"I31","v":2113},0,null,null,{"$f":"IF(W1=2, H9*(1+H47), H9*(1+L47))","v":2069},0,null,0,""]
[null,23,null,"Standard Supply Service Charge",null,"monthly",null,0.25,1,0.25,null,0.25,1,0.25,null,0,0]
[null,24,null,"Debt Retirement Charge (DRC)",null,"per kWh",null,7.0000000000000001E-3,{"$f":"H9","v":2000},14,null,7.0000000000000001E-3,{"$f":"H9","v":2000},14,null,0,0]
[null,25,null,"Energy",null,"per kWh",null,8.3383799999999994E-2,{"$f":"I35","v":2113},176.1899694,null,8.3349999999999994E-2,{"$f":"IF(W1=2, H9*(1+H47), H9*(1+L47))","v":2069},172.45114999999998,null,-3.7388194000000112,-2.1220387362187777E-2]
[null,26,null,null,null,null,null,null,null,0,null,null,null,0,null,0,""]
[null,27,null,null,null,null,null,null,null,0,null,null,null,0,null,0,""]
[null,28,null,"Total Bill (before Taxes)",null,null,null,null,null,{"$f":"SUM(J32:J40)","v":282.0461694},null,null,null,{"$f":"SUM(N32:N40)","v":274.53755000000001},null,-7.5086193999999864,-2.6621951349217604E-2]
[null,29,null,"HST",null,null,null,{"$f":"'10A. Bill Impacts - Res (1)'!H42","v":0.13},null,{"$f":"J41*H42","v":36.666002022000001},null,{"$f":"'10A. Bill Impacts - Res (1)'!L42","v":0.13},null,{"$f":"N41*L42","v":35.689881500000006},null,-0.97612052199999511,-2.6621951349217517E-2]
[null,30,null,"Total Bill (including Sub-total B)",null,null,null,null,null,{"$f":"ROUND(SUM(J41:J42),2)","v":318.70999999999998},null,null,null,{"$f":"ROUND(SUM(N41:N42),2)","v":310.23},null,-8.4799999999999613,-2.6607260518966967E-2]
[null,31,null,"Ontario Clean Energy Benefit (OCEB)",null,null,null,-0.1,null,{"$f":"ROUND(-J43*10%,2)","v":-31.87},null,-0.1,null,{"$f":"ROUND(-N43*10%,2)","v":-31.02},null,0.85000000000000142,-2.6670850329463491E-2]
[null,32,null,"Total Bill (including OCEB)",null,null,null,null,null,{"$f":"J43+J44","v":286.83999999999997},null,null,null,{"$f":"N43+N44","v":279.21000000000004},null,-7.6299999999999386,-2.6600195230790474E-2]
[]
[null,33,null,"Loss Factor",null,"(1)",null,5.6500000000000002E-2,null,null,null,3.4500000000000003E-2]
[]
[null,"Notes:"]
[null,"(1):  See Note (1) from Sheet 10A. Bill Impacts - Residential"]
[null,"(2) The weighted average commodity charge is used in this template, so the results will be comparable with"]
[null,"the calculation when two tier prices are used. There is a rounding difference to Appendix 2-V."]
[null,"(3) These Bill Impacts are for PowerStream Barrie  rate zone"]