{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["lists","tempcopy","1. Information Sheet","2. Rate Class Selection","3. Growth Factor - NUM_CALC1","4. Growth Factor - NUM_CALC2","5. Rev_Requ_Check","6. Growth Factor - DEN_CALC","7. Revenue Proportions","8. Threshold Test","9a. Proposed ACM Projects","9b. Proposed ACM ICM Projects","10. Incremental Capital Adj.","11. Rate Rider Calc"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":39,"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":"lists","index":0,"n_rows":214,"n_cols":55,"rows_kept":214,"cut":false,"hidden":true,"merged":[[5,51,5,52],[0,51,0,52],[1,51,1,52],[2,51,2,52],[3,51,3,52],[4,51,4,52],[17,51,17,52],[6,51,6,52],[7,51,7,52],[8,51,8,52],[9,51,9,52],[10,51,10,52],[11,51,11,52],[12,51,12,52],[13,51,13,52],[14,51,14,52],[15,51,15,52],[16,51,16,52]]}
[null,"Embedded Distributor",{"$f":"COUNTA(B1:B17)","v":4},null,null,null,null,null,"A Standby Service Charge will be applied for a month where standby power is not provided. The applicable rate is the approved Distribution Volumetric Rate of the applicable service class and is applied to gross metered demand or contracted amount, whichever is greater. A monthly administration charge of $200, for simple metering arrangements, or $500, for complex metering arrangements, will also be applied.",null,null,"Loss Factors",null,"Units","Units1","Units2",null,null,null,null,null,null,null,null,null,"Account History","Account set up charge/change of occupancy charge (plus credit agency costs if applicable)","Total Loss Factor – Embedded Distributor – Hydro One Networks Inc.",null,null,null,null,null,null,null,null,null,"Alectra Utilities Corporation-Brampton Rate Zone",null,null,"DISTRIBUTED GENERATION [DGEN]","kW",null,null,null,"Sub-Total:  Delivery (Distribution and Retail Transmission)"]
["RESIDENTIAL R1","General Service 3,000 to 4,999 kW",null,null,null,null,null,null,"Distribution Volumetric Rate",null,null,"Total Loss Factor – Primary Metered Customer",null,"$","$/kWh","$",null,null,null,null,null,null,null,null,null,"Account set up charge/change of occupancy charge","Administrative Billing Charge","Total Loss Factor – Primary Metered Customer",null,null,null,null,null,null,null,null,null,"Alectra Utilities Corporation-Enersource Rate Zone",null,null,"EMBEDDED DISTRIBUTOR","kW",null,null,null,"Wholesale Market Service Rate ",null,null,{"$f":"AU2*AV2","v":0},{"$f":"AU2","v":0},0,{"$f":"AX2*AY2","v":0},null,{"$f":"AZ2-AW2","v":0},{"$f":"BB2/AW2","v":{"$error":"#DIV/0!"}}]
["RESIDENTIAL R2","General Service 1,000 to 4,999 kW",null,null,null,null,null,null,"Distribution Volumetric Rate - $/kW of contracted amount",null,null,"Total Loss Factor – Primary Metered Customer < 5,000 kW",null,"$/kWh","$/kW","%",null,null,null,null,null,null,"MSC",null,null,"Account set up charge/change of occupancy charge (plus credit agency costs if applicable – Residential)","Bell Canada Pole Rentals","Total Loss Factor – Primary Metered Customer < 5,000 kW",null,null,null,null,null,null,null,null,null,"Alectra Utilities Corporation-Horizon Utilities Rate Zone",null,null,"EMBEDDED DISTRIBUTOR","kW",null,null,null,"Rural or Remote Electricity Rate Protection Charge (RRRP)",null,null,{"$f":"AU3*AV3","v":0},0,0,{"$f":"AX3*AY3","v":0},null,{"$f":"AZ3-AW3","v":0},{"$f":"BB3/AW3","v":{"$error":"#DIV/0!"}}]
["SEASONAL CUSTOMERS","General Service Equal To Or Greater Than 1,500 kW - Interval Metered",null,null,null,null,null,null,"Distribution Wheeling Service Rate",null,null,"Total Loss Factor – Primary Metered Customer > 5,000 kW",null,"$/kW","$/kVA",null,null,null,null,null,null,null,"SM_Rate_Adder",null,null,"Account set up charge/change of occupancy charge (plus credit agency costs if applicable)","Clearance Pole Attachment charge $/pole/year","Total Loss Factor – Primary Metered Customer > 5,000 kW",null,null,null,null,null,null,null,null,null,"Alectra Utilities Corporation-PowerStream Rate Zone",null,null,"FARMS - SINGLE PHASE ENERGY-BILLED [F1]","kWh",null,null,null,"Standard Supply Service – Administration Charge (if applicable)",null,null,{"$f":"AU4*AV4","v":0},0,0,{"$f":"AX4*AY4","v":0},null,{"$f":"AZ4-AW4","v":0},{"$f":"BB4/AW4","v":{"$error":"#DIV/0!"}}]
["STREET LIGHTING",null,null,null,null,null,null,null,"Electricity Rate",null,null,"Total Loss Factor – Secondary Metered Customer",null,"$/kVA",null,null,null,null,null,null,null,null,"MSC_Rate_Rider_",null,null,"Arrears certificate","Collection of account charge – no disconnection","Total Loss Factor – Secondary Metered Customer",null,null,null,null,null,null,null,null,null,"Alectra Utilities Corporation-Guelph Rate Zone",null,null,"FARMS - THREE PHASE ENERGY-BILLED [F3]","kWh",null,null,null,"Sub-Total:  Regulatory",null,null,{"$f":"SUM(AW2:AW4)","v":0},null,null,{"$f":"SUM(AZ2:BA4)","v":0},null,{"$f":"AZ5-AW5","v":0},{"$f":"BB5/AW5","v":{"$error":"#DIV/0!"}}]
["RESIDENTIAL",null,null,null,null,null,null,null,"Electricity Rate - All Additional kWh",null,null,"Total Loss Factor – Secondary Metered Customer < 5,000 kW",null,null,null,null,null,null,null,null,null,null,"VC",null,null,"Arrears certificate (credit reference)","Collection of account charge – no disconnection – after regular hours","Total Loss Factor – Secondary Metered Customer < 5,000 kW",null,null,null,null,null,null,null,null,null,"Algoma Power Inc.",null,null,"GENERAL SERVICE - COMMERCIAL","kW",null,null,null,"Debt Retirement Charge (DRC)",null,null,{"$f":"AU6*AV6","v":0},{"$f":"AU6","v":0},{"$f":"AV6","v":0},{"$f":"AX6*AY6","v":0},null,{"$f":"AZ6-AW6","v":0},{"$f":"BB6/AW6","v":{"$error":"#DIV/0!"}}]
["GENERAL SERVICE LESS THAN 50 kW",null,null,null,null,null,null,null,"Electricity Rate - First 250 kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Atikokan Hydro Inc.",null,null,"GENERAL SERVICE - INSTITUTIONAL","kW"]
["GENERAL SERVICE 50 TO 4,999 KW",null,null,null,null,null,null,null,"Electricity Rate -All Additional kWh",null,null,"Total Loss Factor – Secondary Metered Customer > 5,000 kW",null,null,null,null,null,null,null,null,null,null,"VC_Rate_Rider_",null,null,"Charge to certify cheque","Collection of account charge – no disconnection - during regular business hours","Total Loss Factor – Secondary Metered Customer > 5,000 kW",null,null,null,null,null,null,null,null,null,"Bluewater Power Distribution Corporation",null,null,"GENERAL SERVICE 1,000 TO 2,999 KW","kW",null,null,null,"Total Bill on RPP (before taxes)",null,null,null,null,null,null,null,{"$f":"AZ8-AW8","v":0}]
["GENERAL SERVICE 50 TO 999 kW",null,null,null,null,null,null,null,"Electricity Rate First 1,000 kWh",null,null,"Distribution Loss Factor - Secondary Metered Customer < 5,000 kW",null,null,null,null,null,null,null,null,null,null,"VC_GA_Rate_Rider_kW_",null,null,"Collection of Account Charge – No Disconnection","Collection of account charge – no disconnection – during regular hours",null,null,null,null,null,null,null,null,null,null,"Brantford Power Inc.",null,null,"GENERAL SERVICE 1,000 TO 4,999 KW","kW",null,null,null,"HST",null,null,{"$f":"AV9*AW8","v":0},null,{"$f":"AV9","v":0},{"$f":"AY9*AZ8","v":0},null,{"$f":"AZ9-AW9","v":0},{"$f":"BB9/AW9","v":{"$error":"#DIV/0!"}}]
["GENERAL SERVICE 1,000 TO 4,999 kW",null,null,null,null,null,null,null,"Electricity Rate First 25,000 kWh",null,null,"Distribution Loss Factor - Secondary Metered Customer > 5,000 kW",null,null,null,null,null,null,null,null,null,null,"VC_LV_Rate",null,null,"Credit Card Convenience Charge","Collection/Disconnection/Load Limiter/Reconnection – if in Community",null,null,null,null,null,null,null,null,null,null,"Burlington Hydro Inc.",null,null,"GENERAL SERVICE 1,000 TO 4,999 KW - INTERVAL METERS","kW",null,null,null,"Total Bill (including HST)",null,null,{"$f":"AW9+AW8","v":0},null,null,{"$f":"AZ9+AZ8","v":0},null,{"$f":"AZ10-AW10","v":0},{"$f":"BB10/AW10","v":{"$error":"#DIV/0!"}}]
["LARGE USE",null,null,null,null,null,null,null,"Electricity Rate First 6,000 kWh",null,null,"Distribution Loss Factor - Primary Metered Customer < 5,000 kW",null,null,null,null,null,null,null,null,null,null,"RTSR_Network",null,null,"Credit check (plus credit agency costs)","Credit Card Convenience Charge",null,null,null,null,null,null,null,null,null,null,"Canadian Niagara Power Inc.",null,null,"GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION)","kW",null,null,null,"Ontario Clean Energy Benefit (OCEB)",null,null,{"$f":"-0.1*AW10","v":0},null,{"$f":"AV11","v":0},{"$f":"-0.1*AZ10","v":0},null,{"$f":"AZ11-AW11","v":0},{"$f":"BB11/AW11","v":{"$error":"#DIV/0!"}}]
["UNMETERED SCATTERED LOAD",null,null,null,null,null,null,null,"Electricity Rate Next 1,500 kWh",null,null,"Distribution Loss Factor - Primary Metered Customer > 5,000 kW",null,null,null,null,null,null,null,null,null,null,"RTSR_Connection",null,null,"Credit reference Letter","Disconnect/Reconnect at meter – after regular hours",null,null,null,null,null,null,null,null,null,null,"Centre Wellington Hydro Ltd.",null,null,"GENERAL SERVICE 1,500 TO 4,999 KW","kW",null,null,null,"Total Bill on RPP (including OCEB)",null,null,{"$f":"AW10+AW11","v":0},null,null,{"$f":"AZ10+AZ11","v":0},null,{"$f":"AZ12-AW12","v":0},{"$f":"BB12/AW12","v":{"$error":"#DIV/0!"}}]
["SENTINEL LIGHTING",null,null,null,null,null,null,null,"General Service 1,500 to 4,999 kW customer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chapleau Public Utilities Corporation",null,null,"GENERAL SERVICE 2,500 TO 4,999 KW","kW"]
["EMBEDDED DISTRIBUTOR",null,null,null,null,null,null,null,"General Service 50 to 1,499 kW customer",null,null,"Total Loss Factor - Embedded Distributor",null,null,null,null,null,null,null,null,null,null,"RTSR_Network_Interval",null,null,"Credit reference/credit check (plus credit agency costs – General Service)","Disconnect/Reconnect at meter – during regular hours",null,null,null,null,null,null,null,null,null,null,"Cooperative Hydro Embrun Inc.",null,null,"GENERAL SERVICE 3,000 TO 4,999 KW","kW",null,null,null,"Total Bill on TOU (before taxes)",null,null,null,null,null,null,null,{"$f":"AZ14-AW14","v":0}]
["STANDBY POWER",null,null,null,null,null,null,null,"General Service Large Use customer",null,null,"Total Loss Factor – Embedded Distributor – Hydro One Networks Inc.",null,null,null,null,null,null,null,null,null,null,"RTSR_Connection_Interval",null,null,"Credit Reference/credit check (plus credit agency costs)","Disconnect/Reconnect at pole – after regular hours",null,null,null,null,null,null,null,null,null,null,"E.L.K. Energy Inc.",null,null,"GENERAL SERVICE 3,000 TO 4,999 KW - INTERMEDIATE USE","kW",null,null,null,"HST",null,null,{"$f":"AV15*AW14","v":0},null,{"$f":"AV15","v":0},{"$f":"AY15*AZ14","v":0},null,{"$f":"AZ15-AW15","v":0},{"$f":"BB15/AW15","v":{"$error":"#DIV/0!"}}]
["GENERAL SERVICE 50 TO 2,999 KW",null,null,null,null,null,null,null,"Green Energy Act Initiatives Funding Adder - effective until the date of the next \n      cost of service-based rate order",null,null,null,null,null,null,null,null,null,null,null,null,null,"RTSR_Network_Interval_GR1000kW",null,null,"Dispute Test – Commercial self contained -- MC","Disconnect/Reconnect at pole – during regular hours",null,null,null,null,null,null,null,null,null,null,"Elexicon Energy Inc.-Whitby Rate Zone",null,null,"GENERAL SERVICE 3,000 TO 4,999 KW - INTERVAL METERED","kW",null,null,null,"Total Bill (including HST)",null,null,{"$f":"AW15+AW14","v":0},null,null,{"$f":"AZ15+AZ14","v":0},null,{"$f":"AZ16-AW16","v":0},{"$f":"BB16/AW16","v":{"$error":"#DIV/0!"}}]
["GENERAL SERVICE 3,000 TO 4,999 KW",null,null,null,null,null,null,null,"Green Energy Act Plan Funding Adder",null,null,null,null,null,null,null,null,null,null,null,null,null,"RTSR_Connection_Interval_GR1000kW",null,null,"Dispute Test – Commercial TT -- MC","Disconnect/Reconnect Charge – At Meter – After Hours",null,null,null,null,null,null,null,null,null,null,"Elexicon Energy Inc.-Veridian Rate Zone",null,null,"GENERAL SERVICE 3,000 TO 4,999 KW - TIME OF USE","kW",null,null,null,"Ontario Clean Energy Benefit (OCEB)",null,null,{"$f":"-0.1*AW16","v":0},null,{"$f":"AV17","v":0},{"$f":"-0.1*AZ16","v":0},null,{"$f":"AZ17-AW17","v":0},{"$f":"BB17/AW17","v":{"$error":"#DIV/0!"}}]
["GENERAL SERVICE 3,000 TO 4,999 KW - INTERMEDIATE USE",null,null,null,null,null,null,null,"Green Energy Act Plan Funding Adder - effective April 1, 2013 until March 31, 2014",null,null,null,null,null,null,null,null,null,null,null,null,null,"RTSR_Line_Connection",null,null,"Dispute Test – Residential","Disconnect/Reconnect Charge – At Meter – During Regular Hours",null,null,null,null,null,null,null,null,null,null,"Energy+ Inc.",null,null,"GENERAL SERVICE 50 TO 1,000 KW","kW",null,null,null,"Total Bill on TOU (including OCEB)",null,null,{"$f":"AW16+AW17","v":0},null,null,{"$f":"AZ16+AZ17","v":0},null,{"$f":"AZ18-AW18","v":0},{"$f":"BB18/AW18","v":{"$error":"#DIV/0!"}}]
["LARGE USE - REGULAR",null,null,null,null,null,null,null,"Green Energy Act Plan Funding Adder - effective April 1, 2014 until March 31, 2015",null,null,null,null,null,null,null,null,null,null,null,null,null,"RTSR_Transformer_Connection",null,null,"Duplicate Invoices for previous billing","Disconnect/Reconnect Charge – At Pole – After Hours",null,null,null,null,null,null,null,null,null,null,"Entegrus Powerlines Inc.-For Entegrus-Main Rate Zone",null,null,"GENERAL SERVICE 50 TO 1,000 KW - INTERVAL METERS","kW"]
["LARGE USE - 3TS",null,null,null,null,null,null,null,"ICM Rate Rider (2014) - in effect until the effective date of the next cost of service rates",null,null,null,null,null,null,null,null,null,null,null,null,null,"WMSR",null,null,"Easement Letter","Disconnect/Reconnect Charge – At Pole – During Regular Hours",null,null,null,null,null,null,null,null,null,null,"Entegrus Powerlines Inc.-For Former St. Thomas Energy Rate Zone",null,null,"GENERAL SERVICE 50 TO 1,000 KW - NON INTERVAL METERS","kW"]
["LARGE USE - FORD ANNEX",null,null,null,null,null,null,null,"Low Voltage Service Charge",null,null,null,null,null,null,null,null,null,null,null,null,null,"RRRP",null,null,"Income Tax Letter","Disconnect/Reconnect Charges for non payment of account - At Meter After Hours",null,null,null,null,null,null,null,null,null,null,"ENWIN Utilities Ltd.",null,null,"GENERAL SERVICE 50 TO 1,499 KW","kW"]
["GENERAL SERVICE 50 TO 499 kW",null,null,null,null,null,null,null,"Low Voltage Service Rate",null,null,null,null,null,null,null,null,null,null,null,null,null,"SPC",null,null,"Interval Meter Interrogation","Disconnect/Reconnect charges for non payment of account – at meter after regular hours",null,null,null,null,null,null,null,null,null,null,"EPCOR Electricity Distribution Ontario Inc.",null,null,"GENERAL SERVICE 50 TO 1,499 KW - INTERVAL METERED","kW"]
["GENERAL SERVICE 500 TO 4,999 kW",null,null,null,null,null,null,null,"Low Voltage Volumetric Rate",null,null,null,null,null,null,null,null,null,null,null,null,null,"DRC",null,null,"Interval meter request change","Disconnect/Reconnect Charges for non payment of account - At Meter During Regular Hours",null,null,null,null,null,null,null,null,null,null,"ERTH Power Corporation - ERTH Power Main Rate Zone",null,null,"GENERAL SERVICE 50 TO 2,499 KW","kW"]
["GENERAL SERVICE 50 TO 1,499 kW",null,null,null,null,null,null,null,"LRAM Rate Rider - Effective Until April 30, 2015",null,null,null,null,null,null,null,null,null,null,null,null,null,"SSS",null,null,"Legal letter","Disconnect/Reconnect charges for non payment of account – at meter during regular hours",null,null,null,null,null,null,null,null,null,null,"ERTH POWER CORPORATION – GODERICH RATE ZONE",null,null,"GENERAL SERVICE 50 TO 2,999 KW","kW"]
["INTERMEDIATE USER",null,null,null,null,null,null,null,"Minimum Distribution Charge - per KW of maximum billing demand in the previous 11 months",null,null,null,null,null,null,null,null,null,null,null,null,null,"SFLF",null,null,"Legal letter charge","Disconnect/Reconnect charges for non payment of account – at pole after regular hours",null,null,null,null,null,null,null,null,null,null,"Essex Powerlines Corporation",null,null,"GENERAL SERVICE 50 TO 2,999 KW - INTERVAL METERED","kW"]
["LARGE USE WITH DEDICATED ASSETS","January",null,null,null,null,null,null,"Monthly Distribution Wheeling Service Rate - Dedicated LV Line",null,null,null,null,null,null,null,null,null,null,null,null,null,"DLF_Secondary_LT_5000kW",null,null,"Meter dispute charge plus Measurement Canada fees (if meter found correct)","Disconnect/Reconnect charges for non payment of account – at pole during regular hours",null,null,null,null,null,null,null,null,null,null,"Festival Hydro Inc.",null,null,"GENERAL SERVICE 50 TO 2,999 KW - TIME OF USE","kW"]
["GENERAL SERVICE 50 TO 699 KW","February",null,null,null,null,null,null,"Monthly Distribution Wheeling Service Rate - Hydro One Networks",null,null,null,null,null,null,null,null,null,null,null,null,null,"DLF_Secondary_GT_5000kW",null,null,"Notification charge","Disconnect/Reconnection for >300 volts - after regular hours",null,null,null,null,null,null,null,null,null,null,"Fort Frances Power Corporation",null,null,"GENERAL SERVICE 50 TO 4,999 KW","kW"]
["GENERAL SERVICE 700 TO 4,999 KW","March",null,null,null,null,null,null,"Monthly Distribution Wheeling Service Rate - Shared LV Line",null,null,null,null,null,null,null,null,null,null,null,null,null,"DLF_Primary_LT_5000kW",null,null,"Pulling Post Dated Cheques","Disconnect/Reconnection for >300 volts - during regular hours",null,null,null,null,null,null,null,null,null,null,"Greater Sudbury Hydro Inc.",null,null,"GENERAL SERVICE 50 TO 4,999 KW - INTERVAL METERED","kW"]
["DISTRIBUTED GENERATION [DGEN]","April",null,null,null,null,null,null,"Monthly Distribution Wheeling Service Rate - Waterloo North Hydro",null,null,null,null,null,null,null,null,null,null,null,null,null,"DLF_Primary_GT_5000kW",null,null,"Request for other billing information","Disposal of Concrete Poles",null,null,null,null,null,null,null,null,null,null,"Grimsby Power Incorporated",null,null,"GENERAL SERVICE 50 TO 4,999 KW - TIME OF USE","kW"]
["ENERGY FROM WASTE","May",null,null,null,null,null,null,"Rate Rider for Application of Tax Change - effective until April 30, 2015",null,null,null,null,null,null,null,null,null,null,null,null,null,"TLF_Secondary_LT_5000kW",null,null,"Returned cheque (plus bank charges)","Dispute Test – Commercial TT -- MC",null,null,null,null,null,null,null,null,null,null,"Halton Hills Hydro Inc.",null,null,"GENERAL SERVICE 50 TO 4,999 KW (COGENERATION)","kW"]
["UR RESIDENTIAL","June",null,null,null,null,null,null,"Rate Rider for Application of Tax Change - effective until December 31, 2014",null,null,null,null,null,null,null,null,null,null,null,null,null,"TLF_Secondary_GT_5000kW",null,null,"Returned cheque charge (plus bank charges)","Install/Remove load control device – after regular hours",null,null,null,null,null,null,null,null,null,null,"Hearst Power Distribution Co. Ltd.",null,null,"GENERAL SERVICE 50 TO 4,999 KW (FORMERLY TIME OF USE)","kW"]
["R1 RESIDENTIAL","July",null,null,null,null,null,null,"Rate Rider for Application of Tax Change (2014) - effective until April 30, 2015",null,null,null,null,null,null,null,null,null,null,null,null,null,"TLF_Primary_LT_5000kW",null,null,"Special Billing Service (aggregation)","Install/Remove load control device – during regular hours",null,null,null,null,null,null,null,null,null,null,"Hydro 2000 Inc.",null,null,"GENERAL SERVICE 50 TO 499 KW","kW"]
["R2 RESIDENTIAL","August",null,null,null,null,null,null,"Rate Rider for Application of Tax Change (per connection) - effective until April 30, 2015",null,null,null,null,null,null,null,null,null,null,null,null,null,"TLF_Primary_GT_5000kW",null,null,"Special Billing Service (sub-metering charge per meter)","Interval Meter Interrogation",null,null,null,null,null,null,null,null,null,null,"Hydro Hawkesbury Inc.",null,null,"GENERAL SERVICE 50 TO 699 KW","kW"]
["SEASONAL","September",null,null,null,null,null,null,"Rate Rider for CGAAP Accounting Changes (2013) - effective until April 30, 2017",null,null,null,null,null,null,null,null,null,null,null,null,null,"TLF_EmbeddedDistributor",null,null,"Special meter reads","Interval Meter Load Management Tool Charge $/month",null,null,null,null,null,null,null,null,null,null,"Hydro One Networks Inc.",null,null,"GENERAL SERVICE 50 TO 999 KW","kW"]
["URBAN GENERAL SERVICE ENERGY BILLED","October",null,null,null,null,null,null,"Rate Rider for Deferral/Variance Account (2012) - effective unitl April 30, 2016",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statement of Account","Interval meter request change",null,null,null,null,null,null,null,null,null,null,"Hydro One Networks Inc.-Former Haldimand County Hydro Inc. Service Area",null,null,"GENERAL SERVICE 50 TO 999 KW - INTERVAL METERED","kW"]
["GENERAL SERVICE ENERGY BILLED","November",null,null,null,null,null,null,"Rate Rider for Deferral/Variance Account Disposition – effective until April 30, 2015",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unprocessed Payment Charge (plus bank charges)","Late Payment – per annum",null,null,null,null,null,null,null,null,null,null,"Hydro One Networks Inc.-Former Norfolk Power Distribution Inc. Service Area",null,null,"GENERAL SERVICE 500 TO 4,999 KW","kW"]
["URBAN GENERAL SERVICE DEMAND BILLED","December",null,null,null,null,null,null,"Rate Rider for Deferral/Variance Account Disposition (2012) - effective until April 30, 2016",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Late Payment – per month",null,null,null,null,null,null,null,null,null,null,"Hydro One Networks Inc.-Former Woodstock Hydro Services Inc. Service Area",null,null,"GENERAL SERVICE 700 TO 4,999 KW","kW"]
["GENERAL SERVICE DEMAND BILLED",null,null,null,null,null,null,null,"Rate Rider for Deferral/Variance Account Disposition (2013) - effective until April 30, 2014",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Layout fees",null,null,null,null,null,null,null,null,null,null,"Hydro One Remote Communites Inc.",null,null,"GENERAL SERVICE DEMAND BILLED (50 KW AND ABOVE) [GSD]","kW"]
["DISTRIBUTED GENERATION",null,null,null,null,null,null,null,"Rate Rider for Deferral/Variance Account Disposition (2014) - effective until April 28, 2016",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meter dispute charge plus Measurement Canada fees (if meter found correct)",null,null,null,null,null,null,null,null,null,null,"Hydro Ottawa Limited",null,null,"GENERAL SERVICE ENERGY BILLED (LESS THAN 50 KW) [GSE-METERED]","kWh"]
["SUB TRANSMISSION",null,null,null,null,null,null,null,"Rate Rider for Deferral/Variance Account Disposition (2014) - effective until April 30, 2015",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meter Interrogation Charge",null,null,null,null,null,null,null,null,null,null,"InnPower Corporation",null,null,"GENERAL SERVICE ENERGY BILLED (LESS THAN TO 50 KW) [GSE-UNMETERED]","kWh"]
["GENERAL SERVICE GREATER THAN ,000 kW",null,null,null,null,null,null,null,"Rate Rider for Deferral/Variance Account Disposition (2014) - effective until December 31, 2014",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Missed Service Appointment",null,null,null,null,null,null,null,null,null,null,"Kingston Hydro Corporation",null,null,"GENERAL SERVICE EQUAL TO OR GREATER THAN 1,500 KW","kW"]
["GENERAL SERVICE 1,500 TO 4,999 kW",null,null,null,null,null,null,null,"Rate Rider for Deferral/Variance Account Disposition (2014) - effective until December 31, 2015",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Norfolk Pole Rentals – Billed",null,null,null,null,null,null,null,null,null,null,"Kitchener-Wilmot Hydro Inc.",null,null,"GENERAL SERVICE EQUAL TO OR GREATER THAN 1,500 KW - INTERVAL METERED","kW"]
["HCI, RESOP, OTHER ENERGY RESOURCE",null,null,null,null,null,null,null,"Rate Rider for Deferral/Variance Account Dispositon (2012) - effective until April 30, 2016",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Optional Interval/TOU Meter charge $/month",null,null,null,null,null,null,null,null,null,null,"Lakefront Utilities Inc.",null,null,"GENERAL SERVICE GREATER THAN 1,000 KW","kW"]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION)",null,null,null,null,null,null,null,"Rate Rider for Disposition of Accounting Changes Under CGAAP Account 1576 \n      - effective until April 30, 2016",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overtime Locate",null,null,null,null,null,null,null,null,null,null,"Lakeland Power Distribution Ltd.",null,null,"GENERAL SERVICE GREATER THAN 50 kW - WMP","kW"]
["GENERAL SERVICE 1,000 KW AND GREATER",null,null,null,null,null,null,null,"Rate Rider for Disposition of Deferral/Variance Accounts (2010) - effective until December 31, 2014",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Owner Requested Disconnection/Reconnection – after regular hours",null,null,null,null,null,null,null,null,null,null,"Lakeland Power Distribution Ltd.-Parry Sound Service Area",null,null,"GENERAL SERVICE INTERMEDIATE 1,000 TO 4,999 KW","kW"]
["GENERAL SERVICE GREATER THAN 1,000kW",null,null,null,null,null,null,null,"Rate Rider for Disposition of Deferral/Variance Accounts (2011) - effective until April 30, 2015",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Owner Requested Disconnection/Reconnection – during regular hours",null,null,null,null,null,null,null,null,null,null,"London Hydro Inc.",null,null,"GENERAL SERVICE INTERMEDIATE RATE CLASS 1,000 TO 4,999 KW (FORMERLY GENERAL SERVICE > 50 KW CUSTOMERS)","kW"]
["GENERAL SERVICE 500 TO 1,499 KW",null,null,null,null,null,null,null,"Rate Rider for Disposition of Deferral/Variance Accounts (2011) - effective until April 30, 2016",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Returned cheque (plus bank charges)",null,null,null,null,null,null,null,null,null,null,"Milton Hydro Distribution Inc.",null,null,"GENERAL SERVICE INTERMEDIATE RATE CLASS 1,000 TO 4,999 KW (FORMERLY LARGE USE CUSTOMERS)","kW"]
["GENERAL SERVICE EQUAL TO OR GREATER THAN 1,500 KW",null,null,null,null,null,null,null,"Rate Rider for Disposition of Deferral/Variance Accounts (2012) - effective until April 30, 2014",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rural system expansion / line connection fee",null,null,null,null,null,null,null,null,null,null,"Newmarket-Tay Power Distribution Ltd.-For Former Midland Power Utility Rate Zone",null,null,"GENERAL SERVICE LESS THAN 50 KW","kWh"]
["COMPETITIVE SECTOR MULTI-UNIT RESIDENTIAL",null,null,null,null,null,null,null,"Rate Rider for Disposition of Deferral/Variance Accounts (2012) - effective until April 30, 2015",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Same Day Open Trench",null,null,null,null,null,null,null,null,null,null,"Newmarket-Tay Power Distribution Ltd.-For Newmarket-Tay Power Main Rate Zone",null,null,"GENERAL SERVICE LESS THAN 50 KW - SINGLE PHASE ENERGY-BILLED [G1]","kWh"]
["SEASONAL RESIDENTIAL",null,null,null,null,null,null,null,"Rate Rider for Disposition of Deferral/Variance Accounts (2012) - effective until April 30, 2016",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scheduled Day Open Trench",null,null,null,null,null,null,null,null,null,null,"Niagara Peninsula Energy Inc.",null,null,"GENERAL SERVICE LESS THAN 50 KW - THREE PHASE ENERGY-BILLED [G3]","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Deferral/Variance Accounts (2012) - effective until August 31, 2014",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Service call – after regular hours",null,null,null,null,null,null,null,null,null,null,"Niagara-on-the-Lake Hydro Inc.",null,null,"GENERAL SERVICE LESS THAN 50 KW - TRANSMISSION CLASS ENERGY-BILLED [T]","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Deferral/Variance Accounts (2012) - effective until December 31, 2015",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Service call – customer owned equipment",null,null,null,null,null,null,null,null,null,null,"North Bay Hydro Distribution Limited - Espanola service territory",null,null,"GENERAL SERVICE LESS THAN 50 KW - URBAN ENERGY-BILLED [UG]","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Deferral/Variance Accounts (2012) - effective until December 31, 2016 \n      Applicable only in the former service area of Clinton Power",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Service Call – Customer-owned Equipment – After Regular Hours",null,null,null,null,null,null,null,null,null,null,"North Bay Hydro Distribution Limited - North Bay service territory",null,null,"GENERAL SERVICE SINGLE PHASE - G1","kW"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Deferral/Variance Accounts (2012) – effective until December 31, 2016 \n      Applicable only in the former service area of Clinton Power",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Service Call – Customer-owned Equipment – During Regular Hours",null,null,null,null,null,null,null,null,null,null,"Northern Ontario Wires Inc.",null,null,"GENERAL SERVICE THREE PHASE - G3","kW"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Deferral/Variance Accounts (2012) - effective until January 31, 2014",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Service Charge for onsite interrogation of interval meter due to customer phone line failure - required weekly until line repaired $ 6",null,null,null,null,null,null,null,null,null,null,"Oakville Hydro Electricity Distribution Inc.",null,null,"INTERMEDIATE USERS","kW"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Deferral/Variance Accounts (2012) - effective until June 30, 2014",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Service Layout - Commercial",null,null,null,null,null,null,null,null,null,null,"Orangeville Hydro Limited",null,null,"INTERMEDIATE WITH SELF GENERATION","kW"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Deferral/Variance Accounts (2013) - Applicable only to \n      Wholesale Market Participants - effective until April 30, 2015",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Service Layout - ResidentiaI",null,null,null,null,null,null,null,null,null,null,"Orillia Power Distribution Corporation",null,null,"LARGE USE","kW"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Deferral/Variance Accounts (2013) - effective until April 30, 2014",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Special Billing Service (sub-metering charge per meter)",null,null,null,null,null,null,null,null,null,null,"Oshawa PUC Networks Inc.",null,null,"LARGE USE - 3TS","kW"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Deferral/Variance Accounts (2013) - effective until April 30, 2015",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Special meter reads",null,null,null,null,null,null,null,null,null,null,"Ottawa River Power Corporation",null,null,"LARGE USE - FORD ANNEX","kW"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Deferral/Variance Accounts (2013) - effective until April 30, 2015 \n      - not applicable to Wholesale Market Participants",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Specific Charge for Access to the Power Poles - $/pole/year",null,null,null,null,null,null,null,null,null,null,"Peterborough Distribution Incorporated",null,null,"LARGE USE - REGULAR","kW"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Deferral/Variance Accounts (2013) - effective until April 30, 2017",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Specific Charge for Bell Canada Access to the Power Poles – per pole/year",null,null,null,null,null,null,null,null,null,null,"PUC Distribution Inc.",null,null,"LARGE USE > 5000 KW","kW"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Deferral/Variance Accounts (2013) - effective until August 31, 2014",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Switching for company maintenance – Charge based on Time and Materials",null,null,null,null,null,null,null,null,null,null,"Renfrew Hydro Inc.",null,null,"microFIT","$"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Deferral/Variance Accounts (2013) - effective until December 31, 2014",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temporary Service – Install & remove – overhead – no transformer",null,null,null,null,null,null,null,null,null,null,"Rideau St. Lawrence Distribution Inc.",null,null,"RESIDENTIAL","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Deferral/Variance Accounts (2013) - effective until May 31, 2014",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temporary Service – Install & remove – overhead – with transformer",null,null,null,null,null,null,null,null,null,null,"Sioux Lookout Hydro Inc.",null,null,"RESIDENTIAL - HENSALL","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Deferral/Variance Accounts (2014) - effective until December 31, 2015",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temporary Service – Install & remove – underground – no transformer",null,null,null,null,null,null,null,null,null,null,"Synergy North Corporation-Kenora Rate Zone",null,null,"RESIDENTIAL - HIGH DENSITY [R1]","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Deferred PILs Variance Account 1562 - effective until March 31, 2016",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temporary service install & remove – overhead – no transformer",null,null,null,null,null,null,null,null,null,null,"Synergy North Corporation-Thunder Bay Rate Zone ",null,null,"RESIDENTIAL - LOW DENSITY [R2]","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Deferred PILs Variance Account 1562 (2012) - effective until April 30, 2015",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temporary Service Install & Remove – Overhead – With Transformer",null,null,null,null,null,null,null,null,null,null,"Tillsonburg Hydro Inc.",null,null,"RESIDENTIAL - MEDIUM DENSITY [R1]","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Deferred PILs Variance Account 1562 (2012) - effective until April 30, 2016",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temporary Service Install & Remove – Underground – No Transformer",null,null,null,null,null,null,null,null,null,null,"Toronto Hydro-Electric System Limited",null,null,"RESIDENTIAL - NORMAL DENSITY [R2]","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Deferred PILs Variance Account 1562 (2nd Installment - 2012) \n      - effective until April 30, 2016",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temporary service installation and removal – overhead – no transformer",null,null,null,null,null,null,null,null,null,null,"Wasaga Distribution Inc.",null,null,"RESIDENTIAL - TIME OF USE","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Deferred PILs Variance Account 1562 (per connection) (2012) \n      - effective until April 30, 2015",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temporary service installation and removal – overhead – with transformer",null,null,null,null,null,null,null,null,null,null,"Waterloo North Hydro Inc.",null,null,"RESIDENTIAL - URBAN [UR]","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Deferred PILs Variance Account 1562 (per connection) (2012) \n      - effective until April 30, 2016",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temporary service installation and removal – underground – no transformer",null,null,null,null,null,null,null,null,null,null,"Welland Hydro-Electric System Corp.",null,null,"RESIDENTIAL REGULAR","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Global Adjustment Sub-Account (2011)  - effective until April 30, 2015 \n      Applicable only for Non-RPP Customers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wellington North Power Inc.",null,null,"RESIDENTIAL SUBURBAN","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Global Adjustment Sub-Account (2011) - effective until April 30, 2016 \n      Applicable only for Non-RPP Customers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Westario Power Inc.",null,null,"RESIDENTIAL SUBURBAN SEASONAL","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Global Adjustment Sub-Account (2012) - effective until April 30, 2014 \n      Applicable only for Non-RPP Customers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RESIDENTIAL SUBURBAN YEAR ROUND","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Global Adjustment Sub-Account (2012) - effective until April 30, 2015 \n      Applicable only for Non-RPP Customers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RESIDENTIAL URBAN","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Global Adjustment Sub-Account (2012) - effective until April 30, 2015 \n      Applicatble only for Non-RPP Customers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RESIDENTIAL URBAN YEAR-ROUND","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Global Adjustment Sub-Account (2012) - effective until April 30, 2016 \n      Applicable only for Non-RPP Customers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEASONAL RESIDENTIAL","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Global Adjustment Sub-Account (2012) - effective until January 31, 2014. \n      Applicable only for Non-RPP Customers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEASONAL RESIDENTIAL - HIGH DENSITY [R3]","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Global Adjustment Sub-Account (2012) - effective until June 30, 2014 \n      Applicable only for Non-RPP Customers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEASONAL RESIDENTIAL - NORMAL DENSITY [R4]","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Global Adjustment Sub-Account (2012) Applicable only for Non-RPP Customers \n      - effective until August 31, 2014",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SENTINEL LIGHTING","kW"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Global Adjustment Sub-Account (2012) Applicable only to Non-RPP Customers \n      - effective until August 31, 2014",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SMALL COMMERCIAL AND USL - PER CONNECTION","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Global Adjustment Sub-Account (2013) - effective until April 30, 2014 \n      Applicable only for Non-RPP Customers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SMALL COMMERCIAL AND USL - PER METER","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Global Adjustment Sub-Account (2013) - effective until April 30, 2015 \n      Applicable only for Non-RPP Customers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STANDARD A GENERAL SERVICE AIR ACCESS","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Global Adjustment Sub-Account (2013) - effective until April 30, 2015 \n      Applicable only for Non-RPP Customers and excluding Wholesale Market Participants",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STANDARD A GENERAL SERVICE ROAD/RAIL","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Global Adjustment Sub-Account (2013) - effective until April 30, 2017 \n      Applicable only for Non-RPP Customers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STANDARD A GRID CONNECTED","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider For Disposition of Global Adjustment Sub-Account (2013) - effective until August 31, 2014 \n      Applicable only for Non-RPP Customers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STANDARD A RESIDENTIAL AIR ACCESS","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Global Adjustment Sub-Account (2013) - effective until December 31, 2014 \n      Applicable only for Non-RPP Customers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STANDARD A RESIDENTIAL ROAD/RAIL","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Global Adjustment Sub-Account (2013) - effective until May 31, 2014 \n      Applicable only for Non-RPP Customers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STANDBY - GENERAL SERVICE 1,000 - 5,000 KW","kW"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Global Adjustment Sub-Account (2014) - effective until December 31, 2014. \n      Applicable only for Non-RPP - Class B Customers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STANDBY - GENERAL SERVICE 50 - 1,000 KW","kW"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Global Adjustment Sub-Account (2014) - effective until December 31, 2014. \n      Applicable only for Non-RPP Customers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STANDBY - LARGE USE","kW"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Global Adjustment Sub-Account (2014) - effective until December 31, 2014. \n      Applicable only for Non-RPP Customers - Class A Customers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STANDBY DISTRIBUTION SERVICE","kW"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Global Adjustment Sub-Account (2014) - effective until December 31, 2014. \n      Applicable only for Non-RPP Customers - Interval Metered",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STANDBY POWER","kW"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Global Adjustment Sub-Account (2014) - effective until December 31, 2014. \n      Applicable only for Non-RPP Customers - Non Interval Metered",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STANDBY POWER - APPROVED ON AN INTERIM BASIS","kW"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Global Adjustment Sub-Account (2014) \n      - effective until December 31, 2015. Applicable only for Non-RPP Customers.  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STANDBY POWER GENERAL SERVICE 1,500 TO 4,999 KW","kW"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Post Retirement Actuarial Gain - effective until March 31, 2025",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STANDBY POWER GENERAL SERVICE 50 TO 1,499 KW","kW"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Residual Hisotrical Smart Meter Costs - effective until April 30, 2015",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STANDBY POWER GENERAL SERVICE LARGE USE","kW"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Residual Hisotrical Smart Meter Costs - effective until April 30, 2017",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STREET LIGHTING","kW"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Residual Historical Smart Meter Costs - effective until April 30, 2014",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUB TRANSMISSION [ST]","kW"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Residual Historical Smart Meter Costs - effective until April 30, 2016",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UNMETERED SCATTERED LOAD","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Residual Historical Smart Meter Costs - effective until August 31, 2014",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"URBAN GENERAL SERVICE DEMAND BILLED (50 KW AND ABOVE) [UGD]","kW"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Residual Historical Smart Meter Costs - effective until August 31, 2015",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"URBAN GENERAL SERVICE ENERGY BILLED (LESS THAN 50 KW) [UGE]","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Residual Historical Smart Meter Costs - effective until December 31, 2014",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WESTPORT SEWAGE TREATMENT PLANT","kW"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Residual Historical Smart Meter Costs – effective until December 31, 2014",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YEAR-ROUND RESIDENTIAL - R2","kWh"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Residual Historical Smart Meter Costs - effective until December 31, 2015"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Residual Historical Smart Meter Costs - effective until December 31, 2016"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Residual Historical Smart Meter Costs - effective until October 31, 2014"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Residual Historical Smart Meter Costs - effective until September 30, 2014"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Residual Historical Smart Meter Costs - Non-Interval Metered \n      - effective until April 30, 2014"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Residual Historical Smart Meter Costs 2 - in effect until the effective date\n      of the next cost of service-based rate order"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Residual Historical Smart Meter Costs 3 - in effect until the effective date of\n      the next cost of service-based rate order"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Residual Incremental Historical Smart Meter Costs \n      - effective until August 31, 2015"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Stranded Meter costs - effective until April 30, 2015"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Stranded Meter Costs - effective until April 30, 2016"]
[null,null,null,null,null,null,null,null,"Rate Rider for Disposition of Stranded Meter Costs - effective until April 30, 2017"]
[null,null,null,null,null,null,null,null,"Rate Rider for Global Adjustment Sub Account Disposition - effective until April 30, 2016 \n      Applicable only for Non RPP Customers"]
[null,null,null,null,null,null,null,null,"Rate Rider for Global Adjustment Sub-Account Disposition (2014) - effective until April 28, 2016 \n      Applicable only for Non-RPP Customers"]
[null,null,null,null,null,null,null,null,"Rate Rider for Global Adjustment Sub-Account Disposition (2014) - effective until April 30, 2015 \n      Applicable only for Non-RPP Customers"]
[null,null,null,null,null,null,null,null,"Rate Rider for Global Adjustment Sub-Account Disposition (2014) - effective until December 30, 2015 \n      Applicable only for Non-RPP Customers"]
[null,null,null,null,null,null,null,null,"Rate Rider for Global Adjustment Sub-Account Disposition (2014) - effective until December 31, 2014 \n      Applicable only for Non-RPP Customers"]
[null,null,null,null,null,null,null,null,"Rate Rider for Global Adjustment Sub-Account Disposition (2014) - effective until December 31, 2015 \n      Applicable only for Non-RPP Customers"]
[null,null,null,null,null,null,null,null,"Rate Rider for Global Adjustment Sub-Account Disposition Applicable only for Non-RPP Customers \n      - effective until April 30, 2015"]
[null,null,null,null,null,null,null,null,"Rate Rider for Incremental Capital - Distribution Volumetric - effective until April 30, 2016"]
[null,null,null,null,null,null,null,null,"Rate Rider for Incremental Capital - Service Charge - effective until April 30, 2016"]
[null,null,null,null,null,null,null,null,"Rate Rider for Incremental Capital (2012) - effective until April 30, 2015"]
[null,null,null,null,null,null,null,null,"Rate Rider for Lost Revenue Adjustment Mechanism Variance Account (LRAMVA) Recovery (2012 CDM Activities) \n      - effective until April 30, 2015"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recover of Residual Historical Smart meter Costs - effective until June 30, 2014"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of CGAAP/CWIP Differential - in effect until December 31, 2016"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Foregone Revenue - effective until April 30, 2015"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Forgone Revenue - effective until April 30, 2015"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Forgone Revenue - effective until December 31, 2014"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Green Energy Act related costs - effective until December 31, 2014"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Incremental Capital (2013) - in effect until the effective date of \n      the next cost of service-based rate order"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Incremental Capital (2013) - in effect until the effective date of \n      the next cost of service-based rate order"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Incremental Capital (2013) (per connection) - in effect until the effective date of \n      the next cost of service-based rate order"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Incremental Capital (2013) (per connection)- in effect until the effective date of \n      the next cost of service-based rate order"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Incremental Capital Costs"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Incremental Capital Costs - effective until April 30, 2015"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Incremental Capital Module Costs (2014) - in effect until the effective date\n      of the next cost of service-based rate order"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Incremental Capital Module Costs (2014) - in effect until the effective date\n      of the next cost of service-based rate order"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Lost Revenue Adjustment Mechanism ( LRAM)/Shared Savings Mechanism (SSM) (2012) \n      - effective until August 31, 2014"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Lost Revenue Adjustment Mechanism (2013) \n      - effective until December 31, 2014"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Lost Revenue Adjustment Mechanism (LRAM) - effective until April 30, 2016"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Lost Revenue Adjustment Mechanism (LRAM) (pre-2011 CDM Activities) \n      - effective until April 30, 2015"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Lost Revenue Adjustment Mechanism (LRAM) (pre-2011 CDM Activities) (2013) \n      - effective until April 30, 2015"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Lost Revenue Adjustment Mechanism (LRAM)/Shared Savings"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Lost Revenue Adjustment Mechanism (LRAM)/Shared Savings Mechanism \n      (SSM) - effective until December 31, 2018 and applicable in the service area excluding the former \n      service areas of Clinton Power and West Perth Power"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Lost Revenue Adjustment Mechanism (LRAM)/Shared Savings Mechanism (SSM) - effective until \n      December 31, 2014 and applicable in the service area excluding the former service areas of Clinton Power and West Perth Power"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Lost Revenue Adjustment Mechanism (LRAM)/Shared Savings Mechanism (SSM) - effective until \n      December 31, 2014 and applicable only in the former service area of Clinton Power"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Lost Revenue Adjustment Mechanism (LRAM)/Shared Savings Mechanism (SSM) - effective until \n      December 31, 2014 and applicable only in the former service area of West Perth Power"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Lost Revenue Adjustment Mechanism (LRAM)/Shared Savings Mechanism (SSM) - effective until December 31, 2014 and applicable in the service area excluding the former service area of Clinton Power"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Lost Revenue Adjustment Mechanism (LRAM)/Shared Savings Mechanism (SSM) \n      - effective until March 31, 2016"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Lost Revenue Adjustment Mechanism (LRAM)/Shared Savings Mechanism (SSM) (2012) \n      - effective until August 31, 2014"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Lost Revenue Adjustment Mechanism (LRAM)/Shared Savings Mechanism (SSM) Recovery \n      - effective until April 30, 2015"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Lost Revenue Adjustment Mechanism Variance Account (LRAMVA) (2014) \n      - effective until April 30, 2015"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Residual Historical Smart Meter Costs - effective July 1, 2012 - April 30, 2016"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Smart Meter Incremental Revenue Requirement - effective until the date of \n      the next cost of service-based rate order"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Smart Meter Incremental Revenue Requirement - effective until the effective \n      date of the next cost of service-based rate order, or October 31, 2017, whichever occurs earlier"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Smart Meter Incremental Revenue Requirement - in effect until the effective date of \n      the next cost of service-based rate order"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Smart Meter Incremental Revenue Requirement - Non-Interval Metered - in effect until \n      the effective date of the next cost of service-based rate order"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Smart Meter Incremental Revenue Requirements - in effect until the effective date \n      of the next cost of service application"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Smart Meter Stranded Assets - effective until April 30, 2016"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Storm Damage Costs - effective until August 31, 2017"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Stranded Assets - effective until April 30, 2016"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Stranded Meter Assets - effective July 1, 2012 - April 30, 2016"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Stranded Meter Assets – effective until April 30, 2015"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Stranded Meter Assets - effective until April 30, 2016"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Stranded Meter Assets - effective until April 30, 2017"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Stranded Meter Assets - effective until August 31, 2015"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Stranded Meter Assets - effective until August 31, 2017"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Stranded Meter Assets - effective until December 31, 2014"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Stranded Meter Assets - effective until December 31, 2015"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Stranded Meter Assets - effective until June 30, 2016"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Stranded Meter Assets - effective until March 31, 2016"]
[null,null,null,null,null,null,null,null,"Rate Rider for Recovery of Stranded Meter Assets - effective until May 31, 2014"]
[null,null,null,null,null,null,null,null,"Rate Rider for Reversal of Deferral/Variance Account Disposition (2011) - effective until April 30, 2015"]
[null,null,null,null,null,null,null,null,"Rate Rider for Smart Meter Disposition - effective until April 30, 2016"]
[null,null,null,null,null,null,null,null,"Rate Rider for Smart Meter Incremental Revenue Requirement - in effect until the effective date of \n      the next cost of service-based rate order"]
[null,null,null,null,null,null,null,null,"Rate Rider for Smart Metering Entity Charge - effective until October 31, 2018"]
[null,null,null,null,null,null,null,null,"Rate Rider for Stranded Meter Cost Recovery - effective until April 30, 2017"]
[null,null,null,null,null,null,null,null,"Rate Rider for Tax Change"]
[null,null,null,null,null,null,null,null,"Rate Rider for Tax Change - effective until April 30, 2015"]
[null,null,null,null,null,null,null,null,"Rate Rider for Tax Change (2014) - effective until April 30, 2015"]
[null,null,null,null,null,null,null,null,"Retail Transmission Rate - Line and Transformation Connection Service Rate"]
[null,null,null,null,null,null,null,null,"Retail Transmission Rate - Line and Transformation Connection Service Rate - (less than 1,000 kW)"]
[null,null,null,null,null,null,null,null,"Retail Transmission Rate - Line and Transformation Connection Service Rate - Interval Metered"]
[null,null,null,null,null,null,null,null,"Retail Transmission Rate - Line and Transformation Connection Service Rate \n      - Interval Metered (1,000 to 4,999 kW)"]
[null,null,null,null,null,null,null,null,"Retail Transmission Rate - Line and Transformation Connection Service Rate \n      - Interval Metered (less than 1,000 kW)"]
[null,null,null,null,null,null,null,null,"Retail Transmission Rate - Line and Transformation Connection Service Rate \n      - Interval Metered < 1,000 kW"]
[null,null,null,null,null,null,null,null,"Retail Transmission Rate - Line and Transformation Connection Service Rate \n      FOR ALL SERVICE AREAS EXCEPT HENSALL"]
[null,null,null,null,null,null,null,null,"Retail Transmission Rate - Line and Transformation Connection Service Rate\n      - Interval Metered > 1,000 kW"]
[null,null,null,null,null,null,null,null,"Retail Transmission Rate - Line Connection Service Rate"]
[null,null,null,null,null,null,null,null,"Retail Transmission Rate - Network Service Rate"]
[null,null,null,null,null,null,null,null,"Retail Transmission Rate - Network Service Rate - (less than 1,000 kW)"]
[null,null,null,null,null,null,null,null,"Retail Transmission Rate - Network Service Rate - Interval Metered"]
[null,null,null,null,null,null,null,null,"Retail Transmission Rate - Network Service Rate - Interval Metered (1,000 to 4,999 kW)"]
[null,null,null,null,null,null,null,null,"Retail Transmission Rate - Network Service Rate - Interval Metered (less than 1,000 kW)"]
[null,null,null,null,null,null,null,null,"Retail Transmission Rate - Network Service Rate - Interval Metered > 1,000 kW"]
[null,null,null,null,null,null,null,null,"Retail Transmission Rate - Transformation Connection Service Rate"]
[null,null,null,null,null,null,null,null,"Rider for Global Adjustment Sub-Account Disposition (2012) - effective until April 30, 2016 \n      Applicable only for Non-RPP Customers"]
[null,null,null,null,null,null,null,null,"Rural or Remote Electricity Rate Protection Charge (RRRP)"]
[null,null,null,null,null,null,null,null,"Sentinel lights (dusk-to-dawn) connected to unmetered wires will have a flat rate monthly energy charge \nadded to the regular customer bill. Further servicing details are available in the distributor’s Conditions \nof Service."]
[null,null,null,null,null,null,null,null,"Service Charge"]
[null,null,null,null,null,null,null,null,"Service Charge (per connection)"]
[null,null,null,null,null,null,null,null,"Service Charge (per customer)"]
[null,null,null,null,null,null,null,null,"Service Charge (per light)"]
[null,null,null,null,null,null,null,null,"Smart Grid Funding Adder (2014) - in effect until December 31, 2014"]
[null,null,null,null,null,null,null,null,"Smart Meter Disposition Rider"]
[null,null,null,null,null,null,null,null,"Smart Meter Entity Charge"]
[null,null,null,null,null,null,null,null,"Smart Meter Incremental Revenue Requirement Rate Rider"]
[null,null,null,null,null,null,null,null,"Standard Supply Service - Administrative Charge (if applicable)"]
[null,null,null,null,null,null,null,null,"Standby Charge - for a month where standby power is not provided, the charge is based on the applicable \nGeneral Service 50 to 4,999 kW or Large Use Distribution Volumetric Charge applied to the contracted \namount (e.g. Nameplate rating of generating facility)."]
[null,null,null,null,null,null,null,null,"Standby Charge - for a month where standby power is not provided. The charge is applied to the amount of \nreserved load transfer capacity contracted or the amount of monthly peak load displaced by a generating \nfacility"]
[null,null,null,null,null,null,null,null,"Standby Charge - for a month where standby power is not provided. The charge is applied to the contracted \namount (e.g. nameplate rating of the generation facility)."]
[null,null,null,null,null,null,null,null,"Wholesale Market Service Rate"]

{"sheet":"tempcopy","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"1. Information Sheet","index":2,"n_rows":61,"n_cols":27,"rows_kept":61,"cut":false,"hidden":false,"merged":[[60,0,60,11],[33,0,33,4],[33,5,33,7],[35,0,35,4],[35,5,35,7],[37,0,37,4],[37,5,37,7],[59,0,59,11],[39,5,39,7],[41,5,41,7],[43,5,43,7],[45,5,45,7],[47,0,48,4],[47,5,47,7],[48,5,48,7],[52,2,52,11],[54,2,54,13],[56,2,56,12],[31,5,31,7],[25,0,25,4],[25,5,25,7],[27,9,27,11],[27,0,27,4],[27,5,27,7],[29,0,29,4],[29,5,29,7],[31,0,31,4],[13,5,13,11],[17,5,17,9],[19,5,19,9],[21,5,21,9],[23,5,23,9]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a",null,null,null,null,null,{"$f":"IF(OR(F16=\"\", F16=\"(if applicable)\"), F14, F14 & \" - \" & F16)","v":"Algoma Power Inc."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Note:  Depending on the selections made below, certain worksheets in this workbook will be hidden.",null,null,null,null,null,null,null,null,null,null,null,"Version",1]
[]
[null,null,null,null,"Utility Name   ","Algoma Power Inc."]
[]
[]
[]
[null,null,null,null,"Assigned EB Number","EB-2021-0003"]
[]
[null,null,null,null,"Name of Contact and Title","Trevor Wilde, Manager, Regulatory Affairs"]
[]
[null,null,null,null,"Phone Number   ","289-808-2236"]
[]
[null,null,null,null,"Email Address   ","RegulatoryAffairs@FortisOntario.com"]
[]
["Is this Capital Module being filed in a CoS or \nPrice-Cap IR Application?",null,null,null,null,"Price-Cap IR",null,null,null,null,null,"Rate Year",2022]
[]
[{"$f":"\"Indicate the Price-Cap IR Year (1, 2, 3, 4, etc) in which \" &F14 & \" is applying:\"","v":"Indicate the Price-Cap IR Year (1, 2, 3, 4, etc) in which Algoma Power Inc. is applying:"},null,null,null,null,2,null,null,null,{"$f":"\"Next OEB Scheduled Rebasing Year\"","v":"Next OEB Scheduled Rebasing Year"},null,null,2025]
[]
[{"$f":"\"For which Rate Year is \" &F14 & \" seeking approval for its CoS application?\"","v":"For which Rate Year is Algoma Power Inc. seeking approval for its CoS application?"}]
[]
[{"$f":"F14 & \" is applying for:\"","v":"Algoma Power Inc. is applying for:"},null,null,null,null,"ACM and ICM Approval"]
[]
["Last Rebasing Year:",null,null,null,null,{"$f":"M26-F28","v":2020}]
[]
["Last COS OEB Application Number"]
[]
["The most recent complete year for which actual billing and load data exists",null,null,null,null,{"$f":"M26-2","v":2020}]
[]
[null,null,null,null,"Current IPI",2.1999999999999999E-2]
[]
[null,null,null,null,"Strech Factor Assigned to Middle Cohort*","III"]
[]
[null,null,null,null,"Stretch Factor Value",3.0000000000000001E-3]
[]
[null,null,null,null,"Price Cap Index",{"$f":"F40-F44","v":1.9E-2}]
[]
["Based on the inputs above, the growth factor utilized in the Materiality Threshold Calculation will be determined by:",null,null,null,null,{"$f":"CONCATENATE(\"Revenues Based on \",IF($F$26=\"COS\",$M$26&\" Test Year Distribution Revenues\",MAX(F34,F38) & IF(F38>F34,\" Actual Distribution Demand\",\" Board-Approved Distribution Demand\")))","v":"Revenues Based on 2020 Board-Approved Distribution Demand"},null,null,{"$f":"LEFT(RIGHT(F48,LEN(F48)-18),4)","v":"2020"}]
[null,null,null,null,null,{"$f":"CONCATENATE(\"Revenues Based on \",IF(F26=\"COS\",F38&\" Actual Distribution Revenues\", IF(F34>F38,F38,IF(F34=F38,F34-1,F34)) & IF(F38>F34, \" Board-Approved Distribution Demand\", \" Actual Distribution Demand\")))","v":"Revenues Based on 2019 Actual Distribution Demand"},null,null,{"$f":"LEFT(RIGHT(F49,LEN(F49)-18),4)","v":"2019"}]
[]
[null,"Notes"]
[]
[null,null,"Pale green cells represent input cells."]
[]
[null,null,"Pale blue cells represent drop-down lists.  The applicant should select the appropriate item from the drop-down list."]
[]
[null,null,"White cells contain fixed values, automatically generated values or formulae. "]
[]
[]
["This Workbook Model is protected by copyright and is being made available to you solely for the purpose of filing your ICM application.   You may use and copy this model for that purpose, and provide a copy of this model to any person that is advising or assisting you in that regard.  Except as indicated above, any copying, reproduction, publication, sale, adaptation, translation, modification, reverse engineering or other use or dissemination of this model without the express written consent of the Ontario Energy Board is prohibited.  If you provide a copy of this model to a person that is advising or assisting you in preparing the application or reviewing your draft rate order, you must ensure that the person understands and agrees to the restrictions noted above.\n\nWhile this model has been provided in Excel format and is required to be filed with the applications, the onus remains on the applicant to ensure the accuracy of the data and the results.\n\n*As per ACM/ICM policy, the middle cohort stretch factor is applied to all ACM/ICM applications."]
["OEB policies regarding rate-setting and rebasing following distributor consolidations could allow a distributor to not rebase rates for up to ten years. A distributor could also apply for and receive OEB approval to defer rebasing. If a distributor is under Price Cap IR for more than four years after rebasing and applies for an ICM, this spreadsheet will need to be adapted to accommodate those circumstances. The distributor should contact OEB staff to discuss the circumstances so that a customized model can be provided."]

{"sheet":"2. Rate Class Selection","index":3,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[[20,1,20,9],[21,1,21,9],[11,0,11,13],[17,1,17,9],[12,14,16,16],[18,1,18,9],[19,1,19,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Select the appropriate rate classes as they appear on your most recent Board-Approved Tariff of Rates and Charges, excluding the MicroFit Class."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Once all rate class classifications have been entered, please press the update button."]
["How many classes are on your most recent Board-Approved Tariff of Rates and Charges?",null,null,null,null,null,null,null,null,4]
[]
["Select Your Rate Classes from the Blue Cells below.  Please ensure that a rate class is assigned to each shaded cell."]
[]
[null,"Rate Class Classification"]
[1,"RESIDENTIAL R1"]
[2,"RESIDENTIAL R2"]
[3,"SEASONAL CUSTOMERS"]
[4,"STREET LIGHTING"]

{"sheet":"3. Growth Factor - NUM_CALC1","index":4,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[12,0,12,4],[14,2,14,4],[14,6,14,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"Input the billing determinants associated with \" & '1. Information Sheet'!F14 & \"'s \" & '1. Information Sheet'!F48 & \". Input the current approved distribution rates.  Sheets 4 & 5 calculate the NUMERATOR portion of the growth factor calculation.\"","v":"Input the billing determinants associated with Algoma Power Inc.'s Revenues Based on 2020 Board-Approved Distribution Demand. Input the current approved distribution rates.  Sheets 4 & 5 calculate the NUMERATOR portion of the growth factor calculation."}]
[]
[null,null,{"$f":"RIGHT('1. Information Sheet'!F48,LEN('1. Information Sheet'!F48)-18)","v":"2020 Board-Approved Distribution Demand"},null,null,null,{"$f":"IF('1. Information Sheet'!F26=\"COS\",\"Proposed Distribution Rates\",\"Current Approved Distribution Rates\")","v":"Current Approved Distribution Rates"}]
["Rate Class","Units","Billed Customers or Connections","Billed kWh","Billed kW\n(if applicable)",null,"Monthly Service Charge","Distribution Volumetric Rate kWh","Distribution Volumetric Rate kW"]
["RESIDENTIAL R1","$/kWh",9112.8451064303372,113337066.32818118,0,null,103.43,5.5899999999999998E-2]
["RESIDENTIAL R2","$/kW",37.282220262380214,107645160.05587883,248604.90668572392,null,1264.08,null,16.666699999999999]
["SEASONAL CUSTOMERS","$/kWh",2960.1858518389645,5874372.3645382812,0,null,55.68,0.152]
["STREET LIGHTING","$/kWh",1127.6033016645551,581104.4520676051,0,null,1.89,0.30470000000000003]

{"sheet":"4. Growth Factor - NUM_CALC2","index":5,"n_rows":21,"n_cols":19,"rows_kept":21,"cut":false,"hidden":false,"merged":[[13,2,13,4],[13,6,13,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF('1. Information Sheet'!F26=\"COS\", \"Calculation of \" & '1. Information Sheet'!M26 & \" Revenue Requirement.  No input required.\", \"Calculation of pro forma \" & '1. Information Sheet'!F34 & \" Revenues.  No input required.\")","v":"Calculation of pro forma 2020 Revenues.  No input required."}]
[]
[null,null,{"$f":"'3. Growth Factor - NUM_CALC1'!C15","v":"2020 Board-Approved Distribution Demand"},null,null,null,{"$f":"'3. Growth Factor - NUM_CALC1'!G15:I15","v":"Current Approved Distribution Rates"}]
["Rate Class",null,"Billed Customers or Connections","Billed kWh","Billed kW\n(if applicable)",null,"Monthly Service Charge","Distribution Volumetric Rate kWh","Distribution Volumetric Rate kW",null,"Service Charge Revenue","Distribution Volumetric Rate Revenue \nkWh","Distribution Volumetric Rate Revenue \nkW","Revenues from Rates",null,"Service Charge % Revenue","Distribution Volumetric Rate % Revenue \nkWh","Distribution Volumetric Rate % Revenue \nkW","Total % Revenue"]
[null,null,"A","B","C",null,"D","E","F",null,"G","H","I","J",null,"K = G / J","L = H / J","M = I / J","N"]
["RESIDENTIAL R1",null,{"$f":"'3. Growth Factor - NUM_CALC1'!C17","v":9112.8451064303372},{"$f":"'3. Growth Factor - NUM_CALC1'!D17","v":113337066.32818118},{"$f":"'3. Growth Factor - NUM_CALC1'!E17","v":0},null,{"$f":"'3. Growth Factor - NUM_CALC1'!G17","v":103.43},{"$f":"'3. Growth Factor - NUM_CALC1'!H17","v":5.5899999999999998E-2},{"$f":"'3. Growth Factor - NUM_CALC1'!I17","v":0},null,{"$f":"G17*C17*12","v":11310498.832297077},{"$f":"H17*D17","v":6335542.0077453274},0,{"$f":"SUM(K17,L17,M17)","v":17646040.840042405},null,{"$f":"IF(ISERROR(K17/N17),0,ROUND(K17/N17,3))","v":0.64100000000000001},{"$f":"IF(ISERROR(L17/N17),0,ROUND(L17/N17,3))","v":0.35899999999999999},{"$f":"IF(ISERROR(M17/N17),0,ROUND(M17/N17,3))","v":0},{"$f":"N17/N21","v":0.69394967632069238}]
["RESIDENTIAL R2",null,{"$f":"'3. Growth Factor - NUM_CALC1'!C18","v":37.282220262380214},{"$f":"'3. Growth Factor - NUM_CALC1'!D18","v":107645160.05587883},{"$f":"'3. Growth Factor - NUM_CALC1'!E18","v":248604.90668572392},null,{"$f":"'3. Growth Factor - NUM_CALC1'!G18","v":1264.08},{"$f":"'3. Growth Factor - NUM_CALC1'!H18","v":0},{"$f":"'3. Growth Factor - NUM_CALC1'!I18","v":16.666699999999999},null,{"$f":"G18*C18*12","v":565532.50787123502},0,4143423.3982589548,{"$f":"SUM(K18,L18,M18)","v":4708955.90613019},null,{"$f":"IF(ISERROR(K18/N18),0,ROUND(K18/N18,3))","v":0.12},{"$f":"IF(ISERROR(L18/N18),0,ROUND(L18/N18,3))","v":0},{"$f":"IF(ISERROR(M18/N18),0,ROUND(M18/N18,3))","v":0.88},{"$f":"N18/N21","v":0.18518479337598573}]
["SEASONAL CUSTOMERS",null,{"$f":"'3. Growth Factor - NUM_CALC1'!C19","v":2960.1858518389645},{"$f":"'3. Growth Factor - NUM_CALC1'!D19","v":5874372.3645382812},{"$f":"'3. Growth Factor - NUM_CALC1'!E19","v":0},null,{"$f":"'3. Growth Factor - NUM_CALC1'!G19","v":55.68},{"$f":"'3. Growth Factor - NUM_CALC1'!H19","v":0.152},{"$f":"'3. Growth Factor - NUM_CALC1'!I19","v":0},null,{"$f":"G19*C19*12","v":1977877.7787647224},892904.59940981877,0,{"$f":"SUM(K19,L19,M19)","v":2870782.3781745411},null,{"$f":"IF(ISERROR(K19/N19),0,ROUND(K19/N19,3))","v":0.68899999999999995},{"$f":"IF(ISERROR(L19/N19),0,ROUND(L19/N19,3))","v":0.311},{"$f":"IF(ISERROR(M19/N19),0,ROUND(M19/N19,3))","v":0},{"$f":"N19/N21","v":0.11289662764469625}]
["STREET LIGHTING",null,{"$f":"'3. Growth Factor - NUM_CALC1'!C20","v":1127.6033016645551},{"$f":"'3. Growth Factor - NUM_CALC1'!D20","v":581104.4520676051},{"$f":"'3. Growth Factor - NUM_CALC1'!E20","v":0},null,{"$f":"'3. Growth Factor - NUM_CALC1'!G20","v":1.89},{"$f":"'3. Growth Factor - NUM_CALC1'!H20","v":0.30470000000000003},{"$f":"'3. Growth Factor - NUM_CALC1'!I20","v":0},null,{"$f":"G20*C20*12","v":25574.04288175211},177062.5265449993,0,{"$f":"SUM(K20,L20,M20)","v":202636.5694267514},null,{"$f":"IF(ISERROR(K20/N20),0,ROUND(K20/N20,3))","v":0.126},{"$f":"IF(ISERROR(L20/N20),0,ROUND(L20/N20,3))","v":0.874},{"$f":"IF(ISERROR(M20/N20),0,ROUND(M20/N20,3))","v":0},{"$f":"N20/N21","v":7.9689026586255898E-3}]
["Total",null,{"$f":"SUM(C17:C20)","v":13237.91648019624},{"$f":"SUM(D17:D20)","v":227437703.20066592},{"$f":"SUM(E17:E20)","v":248604.90668572392},null,null,null,null,null,{"$f":"SUM(K17:K20)","v":13879483.161814786},{"$f":"SUM(L17:L20)","v":7405509.1337001454},{"$f":"SUM(M17:M20)","v":4143423.3982589548},{"$f":"SUM(N17:N20)","v":25428415.693773888},null,null,null,null,{"$f":"SUM(S17:S20)","v":0.99999999999999989}]

{"sheet":"5. Rev_Requ_Check","index":6,"n_rows":65,"n_cols":6,"rows_kept":65,"cut":false,"hidden":false,"merged":[[7,2,7,5]]}
[]
[]
[]
[]
[]
[]
[]
["Applicants Rate Base",null,{"$f":"IF('1. Information Sheet'!F26=\"COS\",CONCATENATE('1. Information Sheet'!M26,\" Test Year COS Rebasing\"),CONCATENATE(\"Last COS Rebasing: \",'1. Information Sheet'!F34))","v":"Last COS Rebasing: 2020"}]
["Average Net Fixed Assets"]
["Gross Fixed Assets - Re-based Opening",null,191735585.34000003,"A"]
["Add: CWIP Re-based Opening",null,1856895.4499999993,"B"]
["Re-based Capital Additions",null,8743776.0599999987,"C"]
["Re-based Capital Disposals",null,0,"D"]
["Re-based Capital Retirements",null,0,"E"]
["Deduct: CWIP Re-based Closing",null,-1856895.45,"F"]
["Gross Fixed Assets - Re-based Closing",null,{"$f":"SUM(C10:C15)","v":200479361.40000004},"G"]
["Average Gross Fixed Assets",null,null,null,{"$f":"(C10+C16)/2","v":196107473.37000003},"H = ( A + G ) / 2"]
[]
["Accumulated Depreciation - Re-based Opening",null,76934177.486666635,"I"]
["Re-based Depreciation Expense",null,4488904.3111111112,"J"]
["Re-based Disposals",null,0,"K"]
["Re-based Retirements",null,0,"L"]
["Accumulated Depreciation - Re-based Closing",null,{"$f":"SUM(C19:C22)","v":81423081.797777742},"M"]
["Average Accumulated Depreciation",null,null,null,{"$f":"SUM(C19,C23)/2","v":79178629.642222196},"N =  ( I + M ) / 2"]
[]
["Average Net Fixed Assets ",null,null,null,{"$f":"E17-E24","v":116928843.72777784},"O = H - N"]
[]
["Working Capital Allowance"]
["Working Capital Allowance Base",null,37222950.982468992,"P"]
["Working Capital Allowance Rate",null,7.4999999999999997E-2,"Q"]
["Working Capital Allowance",null,null,null,{"$f":"C29*C30","v":2791721.3236851743},"R = P * Q"]
[]
["Rate Base",null,null,null,{"$f":"SUM(E26,E31)","v":119720565.05146301},"S =  O + R"]
[]
["Return on Rate Base"]
["Deemed ShortTerm Debt %",null,0.04,"T",{"$f":"E33*C36","v":4788822.6020585205},"W = S * T"]
["Deemed Long Term Debt %",null,0.56000000000000005,"U",{"$f":"E33*C37","v":67043516.428819291},"X = S * U"]
["Deemed Equity %",null,{"$f":"1-C36-C37","v":0.39999999999999991},"V",{"$f":"E33*C38","v":47888226.020585194},"Y = S * V"]
[]
["Short Term Interest",null,2.75E-2,"Z",{"$f":"E36*C40","v":131692.62155660932},"AC = W * Z"]
["Long Term Interest",null,4.7699999999999999E-2,"AA",{"$f":"E37*C41","v":3197975.7336546802},"AD = X * AA"]
["Return on Equity",null,8.5199999999999998E-2,"AB",{"$f":"E38*C42","v":4080076.8569538584},"AE = Y * AB"]
["Return on Rate Base",null,null,null,{"$f":"SUM(E40:E42)","v":7409745.212165148},"AF = AC + AD + AE"]
[]
["Distribution Expenses"]
["OM&A Expenses",null,13688281.990000002,"AG"]
["Amortization",null,4034602,"AH"]
["Ontario Capital Tax",null,null,"AI"]
["Grossed Up Taxes/PILs",null,259083.88350206241,"AJ"]
["Low Voltage",null,null,"AK"]
["Transformer Allowance",null,110188,"AL"]
["Property Tax",null,118599.96,"AM"]
[null,null,null,"AN"]
[null,null,null,"AO"]
[null,null,null,null,{"$f":"SUM(C46:C54)","v":18210755.833502065},"AP = SUM ( AG : AO )"]
["Revenue Offsets"]
["Specific Service Charges",null,-69365.88,"AQ"]
["Late Payment Charges",null,-33000,"AR"]
["Other Distribution Income",null,-484977.96,"AS"]
["Other Income and Deductions",null,98553,"AT",{"$f":"SUM(C57:C60)","v":-488790.84000000008},"AU = SUM ( AQ : AT )"]
[]
["Revenue Requirement from Distribution Rates",null,null,null,{"$f":"SUM(E60,E55,E43)","v":25131710.205667213},"AV = AF + AP + AU"]
[]
["Rate Classes Revenue"]
["Rate Classes Revenue - Total  (Sheet 4)",null,null,null,{"$f":"'4. Growth Factor - NUM_CALC2'!N21","v":25428415.693773888},"AW"]

{"sheet":"6. Growth Factor - DEN_CALC","index":7,"n_rows":21,"n_cols":19,"rows_kept":21,"cut":false,"hidden":false,"merged":[[13,2,13,4],[13,6,13,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"Input the billing determinants associated with \"&'1. Information Sheet'!F14&\"'s \"&'1. Information Sheet'!F49&\".  This sheet calculates the DENOMINATOR portion of the growth factor calculation.\"","v":"Input the billing determinants associated with Algoma Power Inc.'s Revenues Based on 2019 Actual Distribution Demand.  This sheet calculates the DENOMINATOR portion of the growth factor calculation."}]
["Pro forma Revenue Calculation."]
[null,null,{"$f":"RIGHT('1. Information Sheet'!F49,LEN('1. Information Sheet'!F49)-18)","v":"2019 Actual Distribution Demand"},null,null,null,{"$f":"'3. Growth Factor - NUM_CALC1'!G15","v":"Current Approved Distribution Rates"}]
["Rate Class",null,"Billed Customers or Connections","Billed kWh","Billed kW",null,"Monthly Service Charge","Distribution Volumetric Rate kWh","Distribution Volumetric Rate kW",null,"Service Charge Revenue","Distribution Volumetric Rate Revenue \nkWh","Distribution Volumetric Rate Revenue \nkW","Total Revenue By Rate Class",null,"Service Charge % Revenue","Distribution Volumetric Rate % Revenue \nkWh","Distribution Volumetric Rate % Revenue \nkW","Total % Revenue"]
[null,null,"A","B","C",null,"D","E","F",null,"G","H","I","J",null,"K = G / Jtotal","L = H / Jtotal","M = I / Jtotal","N"]
["RESIDENTIAL R1",null,8529,113325084.34999999,null,null,{"$f":"'3. Growth Factor - NUM_CALC1'!G17","v":103.43},{"$f":"'3. Growth Factor - NUM_CALC1'!H17","v":5.5899999999999998E-2},{"$f":"'3. Growth Factor - NUM_CALC1'!I17","v":0},null,{"$f":"G17*C17*12","v":10585853.640000001},{"$f":"H17*D17","v":6334872.2151649995},0,{"$f":"SUM(K17,L17,M17)","v":16920725.855165001},null,{"$f":"IF(ISERROR(K17/N21),0,ROUND(K17/N21,3))","v":0.43},{"$f":"IF(ISERROR(L17/N21),0,ROUND(L17/N21,3))","v":0.25700000000000001},{"$f":"IF(ISERROR(M17/N21),0,ROUND(M17/N21,3))","v":0},{"$f":"N17/N21","v":0.68718579735496588}]
["RESIDENTIAL R2",null,33,115631848.81,243009.88,null,{"$f":"'3. Growth Factor - NUM_CALC1'!G18","v":1264.08},{"$f":"'3. Growth Factor - NUM_CALC1'!H18","v":0},{"$f":"'3. Growth Factor - NUM_CALC1'!I18","v":16.666699999999999},null,{"$f":"G18*C18*12","v":500575.68},0,4050172.766996,{"$f":"SUM(K18,L18,M18)","v":4550748.4469959997},null,{"$f":"IF(ISERROR(K18/N21),0,ROUND(K18/N21,3))","v":0.02},{"$f":"IF(ISERROR(L18/N21),0,ROUND(L18/N21,3))","v":0},{"$f":"IF(ISERROR(M18/N21),0,ROUND(M18/N21,3))","v":0.16400000000000001},{"$f":"N18/N21","v":0.18481533989017659}]
["SEASONAL CUSTOMERS",null,3009,6277417.3700000001,null,null,{"$f":"'3. Growth Factor - NUM_CALC1'!G19","v":55.68},{"$f":"'3. Growth Factor - NUM_CALC1'!H19","v":0.152},{"$f":"'3. Growth Factor - NUM_CALC1'!I19","v":0},null,{"$f":"G19*C19*12","v":2010493.44},954167.44024000003,0,{"$f":"SUM(K19,L19,M19)","v":2964660.8802399999},null,{"$f":"IF(ISERROR(K19/N21),0,ROUND(K19/N21,3))","v":8.2000000000000003E-2},{"$f":"IF(ISERROR(L19/N21),0,ROUND(L19/N21,3))","v":3.9E-2},{"$f":"IF(ISERROR(M19/N21),0,ROUND(M19/N21,3))","v":0},{"$f":"N19/N21","v":0.12040103174728334}]
["STREET LIGHTING",null,643,566130,null,null,{"$f":"'3. Growth Factor - NUM_CALC1'!G20","v":1.89},{"$f":"'3. Growth Factor - NUM_CALC1'!H20","v":0.30470000000000003},{"$f":"'3. Growth Factor - NUM_CALC1'!I20","v":0},null,{"$f":"G20*C20*12","v":14583.24},172499.81100000002,0,{"$f":"SUM(K20,L20,M20)","v":187083.05100000001},null,{"$f":"IF(ISERROR(K20/N21),0,ROUND(K20/N21,3))","v":1E-3},{"$f":"IF(ISERROR(L20/N21),0,ROUND(L20/N21,3))","v":7.0000000000000001E-3},{"$f":"IF(ISERROR(M20/N21),0,ROUND(M20/N21,3))","v":0},{"$f":"N20/N21","v":7.5978310075741785E-3}]
["Total",null,{"$f":"SUM(C17:C20)","v":12214},{"$f":"SUM(D17:D20)","v":235800480.53},{"$f":"SUM(E17:E20)","v":243009.88},null,null,null,null,null,{"$f":"SUM(K17:K20)","v":13111506},{"$f":"SUM(L17:L20)","v":7461539.4664049996},{"$f":"SUM(M17:M20)","v":4050172.766996},{"$f":"SUM(N17:N20)","v":24623218.233401},null,null,null,null,{"$f":"SUM(S17:S20)","v":1}]

{"sheet":"7. Revenue Proportions","index":8,"n_rows":21,"n_cols":19,"rows_kept":21,"cut":false,"hidden":false,"merged":[[12,0,12,6],[13,2,13,4],[13,6,13,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Current Revenue from Rates"]
["This sheet is used to determine the applicant's most current allocation of revenues (after the most recent revenue to cost ratio adjustment, if applicable) to appropriately allocate the incremental revenue requirement to the classes.\n"]
[null,null,{"$f":"IF('1. Information Sheet'!F26=\"COS\", \"Proposed Base Rates in Current CoS Application\", \"Current OEB-Approved Base Rates\")","v":"Current OEB-Approved Base Rates"},null,null,null,{"$f":"'3. Growth Factor - NUM_CALC1'!C15","v":"2020 Board-Approved Distribution Demand"}]
["Rate Class",null,"Monthly Service Charge","Distribution Volumetric Rate kWh","Distribution Volumetric Rate kW",null,"Re-based Billed Customers or Connections","Re-based Billed kWh","Re-based Billed kW",null,"Current Base Service Charge Revenue","Current Base Distribution Volumetric Rate kWh Revenue","Current Base Distribution Volumetric Rate kW Revenue","Total Current Base Revenue",null,"Service Charge % Total Revenue","Distribution Volumetric Rate % Total Revenue ","Distribution Volumetric Rate % Total Revenue ","Total % Revenue"]
[null,null,"A","B","C",null,"D","E","F",null,"G","H","I","J",null,"L = G / Jtotal","M = H / Jtotal","N = I / Jtotal","O"]
["RESIDENTIAL R1",null,{"$f":"'3. Growth Factor - NUM_CALC1'!G17","v":103.43},{"$f":"'3. Growth Factor - NUM_CALC1'!H17","v":5.5899999999999998E-2},{"$f":"'3. Growth Factor - NUM_CALC1'!I17","v":0},null,{"$f":"'3. Growth Factor - NUM_CALC1'!C17","v":9112.8451064303372},{"$f":"'3. Growth Factor - NUM_CALC1'!D17","v":113337066.32818118},{"$f":"'3. Growth Factor - NUM_CALC1'!E17","v":0},null,{"$f":"G17*C17*12","v":11310498.832297077},{"$f":"H17*D17","v":6335542.0077453274},0,{"$f":"SUM(K17,L17,M17)","v":17646040.840042405},null,{"$f":"IF(ISERROR(K17/N21),0,K17/N21)","v":0.4447976220188361},{"$f":"IF(ISERROR(L17/N21),0,L17/N21)","v":0.24915205430185633},{"$f":"IF(ISERROR(M17/N21),0,M17/N21)","v":0},{"$f":"N17/N21","v":0.69394967632069238}]
["RESIDENTIAL R2",null,{"$f":"'3. Growth Factor - NUM_CALC1'!G18","v":1264.08},{"$f":"'3. Growth Factor - NUM_CALC1'!H18","v":0},{"$f":"'3. Growth Factor - NUM_CALC1'!I18","v":16.666699999999999},null,{"$f":"'3. Growth Factor - NUM_CALC1'!C18","v":37.282220262380214},{"$f":"'3. Growth Factor - NUM_CALC1'!D18","v":107645160.05587883},{"$f":"'3. Growth Factor - NUM_CALC1'!E18","v":248604.90668572392},null,{"$f":"G18*C18*12","v":565532.50787123502},0,4143423.3982589548,{"$f":"SUM(K18,L18,M18)","v":4708955.90613019},null,{"$f":"IF(ISERROR(K18/N21),0,K18/N21)","v":2.2240178652172374E-2},{"$f":"IF(ISERROR(L18/N21),0,L18/N21)","v":0},{"$f":"IF(ISERROR(M18/N21),0,M18/N21)","v":0.16294461472381333},{"$f":"N18/N21","v":0.18518479337598573}]
["SEASONAL CUSTOMERS",null,{"$f":"'3. Growth Factor - NUM_CALC1'!G19","v":55.68},{"$f":"'3. Growth Factor - NUM_CALC1'!H19","v":0.152},{"$f":"'3. Growth Factor - NUM_CALC1'!I19","v":0},null,{"$f":"'3. Growth Factor - NUM_CALC1'!C19","v":2960.1858518389645},{"$f":"'3. Growth Factor - NUM_CALC1'!D19","v":5874372.3645382812},{"$f":"'3. Growth Factor - NUM_CALC1'!E19","v":0},null,{"$f":"G19*C19*12","v":1977877.7787647224},892904.59940981877,0,{"$f":"SUM(K19,L19,M19)","v":2870782.3781745411},null,{"$f":"IF(ISERROR(K19/N21),0,K19/N21)","v":7.7782186770251796E-2},{"$f":"IF(ISERROR(L19/N21),0,L19/N21)","v":3.5114440874444458E-2},{"$f":"IF(ISERROR(M19/N21),0,M19/N21)","v":0},{"$f":"N19/N21","v":0.11289662764469625}]
["STREET LIGHTING",null,{"$f":"'3. Growth Factor - NUM_CALC1'!G20","v":1.89},{"$f":"'3. Growth Factor - NUM_CALC1'!H20","v":0.30470000000000003},{"$f":"'3. Growth Factor - NUM_CALC1'!I20","v":0},null,{"$f":"'3. Growth Factor - NUM_CALC1'!C20","v":1127.6033016645551},{"$f":"'3. Growth Factor - NUM_CALC1'!D20","v":581104.4520676051},{"$f":"'3. Growth Factor - NUM_CALC1'!E20","v":0},null,{"$f":"G20*C20*12","v":25574.04288175211},177062.5265449993,0,{"$f":"SUM(K20,L20,M20)","v":202636.5694267514},null,{"$f":"IF(ISERROR(K20/N21),0,K20/N21)","v":1.0057269469609103E-3},{"$f":"IF(ISERROR(L20/N21),0,L20/N21)","v":6.9631757116646797E-3},{"$f":"IF(ISERROR(M20/N21),0,M20/N21)","v":0},{"$f":"N20/N21","v":7.9689026586255898E-3}]
["Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K17:K20)","v":13879483.161814786},{"$f":"SUM(L17:L20)","v":7405509.1337001454},{"$f":"SUM(M17:M20)","v":4143423.3982589548},{"$f":"SUM(N17:N20)","v":25428415.693773888},null,null,null,null,{"$f":"SUM(S17:S20)","v":0.99999999999999989}]

{"sheet":"8. Threshold Test","index":9,"n_rows":77,"n_cols":5,"rows_kept":77,"cut":false,"hidden":false,"merged":[[8,2,8,4],[76,2,76,5]]}
[]
[]
[]
[]
[]
[]
[]
["No Input Required."]
[null,null,{"$f":"IF('1. Information Sheet'!F26 = \"COS\", \"Preliminary Materiality Threshold Calculation\", \"Final Materiality Threshold Calculation\")","v":"Final Materiality Threshold Calculation"}]
[]
[]
[]
[null,null,"Cost of Service Rebasing Year",null,{"$f":"IF('1. Information Sheet'!F26=\"COS\",'1. Information Sheet'!M26,'1. Information Sheet'!F34)","v":2020}]
[null,null,"Price Cap IR Year in which Application is made",null,{"$f":"IF('1. Information Sheet'!F26=\"CoS\", \"COS\",'1. Information Sheet'!F28)","v":2}]
[]
[null,null,"Price Cap Index",null,{"$f":"'1. Information Sheet'!F46","v":1.9E-2}]
[null,null,"Growth Factor Calculation"]
[null,null,{"$f":"'1. Information Sheet'!F48","v":"Revenues Based on 2020 Board-Approved Distribution Demand"},null,{"$f":"'4. Growth Factor - NUM_CALC2'!N21","v":25428415.693773888}]
[null,null,{"$f":"'1. Information Sheet'!F49","v":"Revenues Based on 2019 Actual Distribution Demand"},null,{"$f":"'6. Growth Factor - DEN_CALC'!N21","v":24623218.233401}]
[null,null,"Growth Factor",null,{"$f":"IF(ISERROR(E18/E19-1),0,(E18/E19-1)/('1. Information Sheet'!I48-'1. Information Sheet'!I49))","v":3.2700740120178429E-2}]
[null,null,"Dead Band",null,0.1]
[null,null,"Average Net Fixed Assets"]
[null,null,"Gross Fixed Assets Opening",null,{"$f":"'5. Rev_Requ_Check'!C10","v":191735585.34000003}]
[null,null,"Add: CWIP Opening",null,{"$f":"'5. Rev_Requ_Check'!C11","v":1856895.4499999993}]
[null,null,"Capital Additions",null,{"$f":"'5. Rev_Requ_Check'!C12","v":8743776.0599999987}]
[null,null,"Capital Disposals",null,{"$f":"'5. Rev_Requ_Check'!C13","v":0}]
[null,null,"Capital Retirements",null,{"$f":"'5. Rev_Requ_Check'!C14","v":0}]
[null,null,"Deduct: CWIP Closing",null,{"$f":"'5. Rev_Requ_Check'!C15","v":-1856895.45}]
[null,null,"Gross Fixed Assets - Closing",null,{"$f":"'5. Rev_Requ_Check'!C16","v":200479361.40000004}]
[]
[null,null,"Average Gross Fixed Assets",null,{"$f":"(E23+E29)/2","v":196107473.37000003}]
[]
[null,null,"Accumulated Depreciation - Opening",null,{"$f":"'5. Rev_Requ_Check'!C19","v":76934177.486666635}]
[null,null,"Depreciation Expense",null,{"$f":"'5. Rev_Requ_Check'!C20","v":4488904.3111111112}]
[null,null,"Disposals",null,{"$f":"'5. Rev_Requ_Check'!C21","v":0}]
[null,null,"Retirements",null,{"$f":"'5. Rev_Requ_Check'!C22","v":0}]
[null,null,"Accumulated Depreciation - Closing",null,{"$f":"'5. Rev_Requ_Check'!C23","v":81423081.797777742}]
[]
[null,null,"Average Accumulated Depreciation",null,{"$f":"(E33+E37)/2","v":79178629.642222196}]
[]
[null,null,"Average Net Fixed Assets ",null,{"$f":"E31-E39","v":116928843.72777784}]
[]
[]
[null,null,"Working Capital Allowance"]
[null,null,"Working Capital Allowance Base",null,{"$f":"'5. Rev_Requ_Check'!C29","v":37222950.982468992}]
[null,null,"Working Capital Allowance Rate",null,{"$f":"'5. Rev_Requ_Check'!C30","v":7.4999999999999997E-2}]
[null,null,"Working Capital Allowance",null,{"$f":"E45*E46","v":2791721.3236851743}]
[]
[null,null,"Rate Base",null,{"$f":"E41+E47","v":119720565.05146301}]
[]
[null,null,"Depreciation",null,{"$f":"E34","v":4488904.3111111112}]
[]
[null,null,"Threshold Value (varies by Price Cap IR Year subsequent to CoS rebasing)"]
[null,null,{"$f":"CONCATENATE(\"    Price Cap IR Year \",E13+1)","v":"    Price Cap IR Year 2021"},null,{"$f":"IF(ISERROR(1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(1-1) + 10%), 0, 1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(1-1) + 10%)","v":2.4954465181787526}]
[null,null,{"$f":"CONCATENATE(\"    Price Cap IR Year \",E13+2)","v":"    Price Cap IR Year 2022"},null,{"$f":"IF(ISERROR(1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(2-1) + 10%), 0, 1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(2-1) + 10%)","v":2.5684591465116289}]
[null,null,{"$f":"CONCATENATE(\"    Price Cap IR Year \",E13+3)","v":"    Price Cap IR Year 2023"},null,{"$f":"IF(ISERROR(1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(3-1) + 10%), 0, 1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(3-1) + 10%)","v":2.645291945540142}]
[null,null,{"$f":"CONCATENATE(\"    Price Cap IR Year \",E13+4)","v":"    Price Cap IR Year 2024"},null,{"$f":"IF(ISERROR(1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(4-1) + 10%), 0, 1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(4-1) + 10%)","v":2.7261447944424151}]
[null,null,{"$f":"CONCATENATE(\"    Price Cap IR Year \",E13+5)","v":"    Price Cap IR Year 2025"},null,{"$f":"IF(ISERROR(1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(5-1) + 10%), 0, 1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(5-1) + 10%)","v":2.81122803048576}]
[null,null,{"$f":"CONCATENATE(\"    Price Cap IR Year \",E13+6)","v":"    Price Cap IR Year 2026"},null,{"$f":"IF(ISERROR(1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(6-1) + 10%), 0, 1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(6-1) + 10%)","v":2.9007629962153834}]
[null,null,{"$f":"CONCATENATE(\"    Price Cap IR Year \",E13+7)","v":"    Price Cap IR Year 2027"},null,{"$f":"IF(ISERROR(1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(7-1) + 10%), 0, 1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(7-1) + 10%)","v":2.9949826152731371}]
[null,null,{"$f":"CONCATENATE(\"    Price Cap IR Year \",E13+8)","v":"    Price Cap IR Year 2028"},null,{"$f":"IF(ISERROR(1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(8-1) + 10%), 0, 1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(8-1) + 10%)","v":3.0941319983442814}]
[null,null,{"$f":"CONCATENATE(\"    Price Cap IR Year \",E13+9)","v":"    Price Cap IR Year 2029"},null,{"$f":"IF(ISERROR(1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(9-1) + 10%), 0, 1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(9-1) + 10%)","v":3.198469080808632}]
[null,null,{"$f":"CONCATENATE(\"    Price Cap IR Year \",E13+10)","v":"    Price Cap IR Year 2030"},null,{"$f":"IF(ISERROR(1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(10-1) + 10%), 0, 1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(10-1) + 10%)","v":3.3082652937549222}]
[]
[null,null,"Threshold CAPEX"]
[null,null,{"$f":"C54","v":"    Price Cap IR Year 2021"},null,{"$f":"IF(ISERROR(d*E54), \"\", d*E54)","v":11201820.633599814}]
[null,null,{"$f":"C55","v":"    Price Cap IR Year 2022"},null,11529567.335688816]
[null,null,{"$f":"C56","v":"    Price Cap IR Year 2023"},null,11874462.418482643]
[null,null,{"$f":"C57","v":"    Price Cap IR Year 2024"},null,12237403.120485671]
[null,null,{"$f":"C58","v":"    Price Cap IR Year 2025"},null,12619333.625563927]
[null,null,"    Price Cap IR Year 2026",null,13021247.519222818]
[null,null,"    Price Cap IR Year 2027",null,13444190.373402417]
[null,null,"    Price Cap IR Year 2028",null,13889262.466514483]
[null,null,"    Price Cap IR Year 2029",null,14357621.645797461]
[null,null,"    Price Cap IR Year 2030",null,14850486.339435738]
[]
[null,"Note 1:","The growth factor g is annualized, depending on the number of years between the numerator and denominator for the calculation. Typically, for ACM review in a cost of service and in the fourth year of Price Cap IR, the ratio is divided by 2 to annualize it. No division is normally required for the first three years under Price Cap IR."]

{"sheet":"9a. Proposed ACM Projects","index":10,"n_rows":51,"n_cols":13,"rows_kept":51,"cut":false,"hidden":true,"merged":[[12,2,12,5],[12,6,12,11],[24,2,24,5],[24,6,24,11],[25,12,26,12]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Identify ALL Proposed ACM projects and related CAPEX costs in the relevant years"]
[]
[null,"Cost of Service","Price Cap IR",null,null,null,"(if necessary)"]
[null,"Test Year","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10"]
[null,{"$f":"'1. Information Sheet'!K26","v":0},{"$f":"B15+1","v":1},2,3,4,5,6,7,8,9,10]
["Distribution System Plan CAPEX"]
[]
["Materiality Threshold",null,{"$f":"IF('8. Threshold Test'!$E$66=\"\", 0, '8. Threshold Test'!$E$66)","v":11201820.633599814},{"$f":"IF('8. Threshold Test'!$E$67=\"\", 0, '8. Threshold Test'!$E$67)","v":11529567.335688816},{"$f":"IF('8. Threshold Test'!$E$68=\"\", 0, '8. Threshold Test'!$E$68)","v":11874462.418482643},{"$f":"IF('8. Threshold Test'!$E$69=\"\", 0, '8. Threshold Test'!$E$69)","v":12237403.120485671},{"$f":"IF('8. Threshold Test'!$E$70=\"\", 0, '8. Threshold Test'!$E$70)","v":12619333.625563927},{"$f":"IF('8. Threshold Test'!$E$71=\"\", 0, '8. Threshold Test'!$E$71)","v":13021247.519222818},{"$f":"IF('8. Threshold Test'!$E$72=\"\", 0, '8. Threshold Test'!$E$72)","v":13444190.373402417},{"$f":"IF('8. Threshold Test'!$E$73=\"\", 0, '8. Threshold Test'!$E$73)","v":13889262.466514483},{"$f":"IF('8. Threshold Test'!$E$74=\"\", 0, '8. Threshold Test'!$E$74)","v":14357621.645797461},{"$f":"IF('8. Threshold Test'!$E$75=\"\", 0, '8. Threshold Test'!$E$75)","v":14850486.339435738}]
[]
["Maximum Eligible Incremental Capital (Forecasted CAPEX less Threshold)",null,{"$f":"MAX(0,C16-C18)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Maximum Eligible Incremental Capital (Forecasted Capex less Threshold)",null,{"$f":"IF(C18>C16,0,C16-C18)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Proposed Capital Projects Eligible for ACM treatment"]
[null,{"$f":"B13","v":"Cost of Service"},{"$f":"C13","v":"Price Cap IR"},null,null,null,"(if necessary)"]
["Project Descriptions:","Test Year","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Total"]
[null,{"$f":"B15","v":0},1,2,3,4,5,6,7,8,9,10]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C28:F28)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
["Total Cost of ACM Projects",null,{"$f":"SUM(C28:C47)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Maximum Allowed Incremental Capital",null,{"$f":"MIN(C49,C22)","v":0},0,0,0,0,0,0,0,0,0]

{"sheet":"9b. Proposed ACM ICM Projects","index":11,"n_rows":128,"n_cols":15,"rows_kept":128,"cut":false,"hidden":false,"merged":[[49,0,52,1],[88,0,91,1],[127,0,130,1],[88,9,88,11],[88,12,88,14],[89,12,89,14],[61,3,61,5],[61,6,61,8],[61,9,61,11],[61,12,61,14],[54,1,57,1],[60,3,60,5],[60,6,60,8],[60,9,60,11],[60,12,60,14],[100,3,100,5],[15,1,18,1],[21,3,21,5],[21,6,21,8],[21,9,21,11],[21,12,21,14],[22,12,22,14],[53,6,53,8],[53,9,53,11],[53,12,53,14],[51,9,51,11],[51,12,51,14],[100,6,100,8],[100,9,100,11],[100,12,100,14],[91,3,91,5],[91,6,91,8],[91,9,91,11],[91,12,91,14],[92,3,92,5],[92,6,92,8],[92,9,92,11],[92,12,92,14],[93,1,96,1],[99,3,99,5],[99,6,99,8],[99,9,99,11],[99,12,99,14],[12,12,12,14],[49,3,49,5],[49,6,49,8],[49,9,49,11],[49,12,49,14],[13,3,13,5],[13,6,13,8],[13,9,13,11],[13,12,13,14],[14,3,14,5],[14,6,14,8],[14,9,14,11],[14,12,14,14],[22,3,22,5],[22,6,22,8],[22,9,22,11],[51,3,51,5],[51,6,51,8],[12,3,12,5],[12,6,12,8],[12,9,12,11],[90,9,90,11],[90,12,90,14],[89,9,89,11],[52,3,52,5],[52,6,52,8],[52,9,52,11],[52,12,52,14],[53,3,53,5],[88,3,88,5],[88,6,88,8],[90,6,90,8],[90,3,90,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Identify ALL Proposed ACM and ICM projects and related CAPEX costs in the relevant years"]
[]
[null,null,"Cost of Service","Price Cap IR",null,null,"Price Cap IR",null,null,"Price Cap IR",null,null,"Price Cap IR"]
[null,null,"Test Year","Year 1",null,null,"Year 2",null,null,"Year 3",null,null,"Year 4"]
[null,null,{"$f":"'1. Information Sheet'!F34","v":2020},{"$f":"C15+1","v":2021},null,null,{"$f":"D15+1","v":2022},null,null,{"$f":"G15+1","v":2023},null,null,{"$f":"J15+1","v":2024}]
["CAPEX1",null,8485738.5600000005,{"$f":"21009131-3735000-9627429","v":7646702},null,null,{"$f":"32672939-4062805+9627429","v":38237563}]
[]
["Materiality Threshold",null,null,{"$f":"IF('8. Threshold Test'!$E$66=\"\", 0, '8. Threshold Test'!$E$66)","v":11201820.633599814},null,null,{"$f":"IF('8. Threshold Test'!$E$67=\"\", 0, '8. Threshold Test'!$E$67)","v":11529567.335688816},null,null,{"$f":"IF('8. Threshold Test'!$E$68=\"\", 0, '8. Threshold Test'!$E$68)","v":11874462.418482643},null,null,{"$f":"IF('8. Threshold Test'!$E$69=\"\", 0, '8. Threshold Test'!$E$69)","v":12237403.120485671}]
[]
["Maximum Eligible Incremental Capital (Forecasted Capex less Threshold)",null,null,{"$f":"IF(D18>D16,0,D16-D18)","v":0},null,null,{"$f":"IF(G18>G16,0,G16-G18)","v":26707995.664311185},null,null,{"$f":"IF(J18>J16,0,J16-J18)","v":0},null,null,{"$f":"IF(M18>M16,0,M16-M18)","v":0}]
[]
[null,null,"Test Year","Year 1",null,null,"Year 2",null,null,"Year 3",null,null,"Year 4"]
[null,null,{"$f":"C15","v":2020},{"$f":"D15","v":2021},null,null,{"$f":"G15","v":2022},null,null,{"$f":"J15","v":2023},null,null,{"$f":"M15","v":2024}]
["Project Descriptions:","Type",null,"Proposed ACM/ICM","Amortization Expense","CCA","Proposed ACM/ICM","Amortization Expense","CCA","Proposed ACM/ICM","Amortization Expense","CCA","Proposed ACM/ICM","Amortization Expense","CCA"]
["Sault Facility Project","Approved ACM",null,0,0,0,{"$f":"12690000","v":12690000},{"$f":"G25/50","v":253800},{"$f":"0.04*G25","v":507600}]
["Echo River TS","Approved ACM",null,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total Cost of ACM/ICM Projects",null,null,{"$f":"SUM(D25:D44)","v":0},{"$f":"SUM(E25:E44)","v":0},0,12690000,253800,507600,0,0,0,0,0,0]
[]
["Maximum Allowed Incremental Capital",null,null,{"$f":"MIN(D46,D20)","v":0},null,null,{"$f":"MIN(G46,G20)","v":12690000},null,null,{"$f":"MIN(J46,J20)","v":0},null,null,{"$f":"MIN(M46,M20)","v":0}]
[]
["1.  For the Cost of Service Test Year, CAPEX refers to the CAPEX approved in the DSP. For subsequent Price CAP IR years, the CAPEX to be entered is the actual CAPEX. For the current Price Cap IR year, the CAPEX to be entered is the proposed CAPEX including any ICM/updated ACM project CAPEX for the year.",null,null,"Price Cap IR (Deferred Rebasing) (if necessary)",null,null,"Price Cap IR (Deferred Rebasing) (if necessary)",null,null,"Price Cap IR (Deferred Rebasing) (if necessary)",null,null,"Price Cap IR (Deferred Rebasing) (if necessary)"]
[]
[null,null,null,"Price Cap IR",null,null,"Price Cap IR",null,null,"Price Cap IR",null,null,"Price Cap IR"]
[null,null,null,"Year 5",null,null,"Year 6",null,null,"Year 7",null,null,"Year 8"]
[null,null,null,{"$f":"M15+1","v":2025},null,null,{"$f":"D54+1","v":2026},null,null,{"$f":"G54+1","v":2027},null,null,{"$f":"J54+1","v":2028}]
["Distribution System Plan CAPEX"]
[]
["Materiality Threshold",null,null,{"$f":"IF('8. Threshold Test'!$E$70=\"\", 0, '8. Threshold Test'!$E$70)","v":12619333.625563927},null,null,{"$f":"IF('8. Threshold Test'!$E$71=\"\", 0, '8. Threshold Test'!$E$71)","v":13021247.519222818},null,null,{"$f":"IF('8. Threshold Test'!$E$72=\"\", 0, '8. Threshold Test'!$E$72)","v":13444190.373402417},null,null,{"$f":"IF('8. Threshold Test'!$E$73=\"\", 0, '8. Threshold Test'!$E$73)","v":13889262.466514483}]
[]
["Maximum Eligible Incremental Capital (Forecasted Capex less Threshold)",null,null,{"$f":"IF(D57>D55,0,D55-D57)","v":0},null,null,{"$f":"IF(G57>G55,0,G55-G57)","v":0},null,null,{"$f":"IF(J57>J55,0,J55-J57)","v":0},null,null,{"$f":"IF(M57>M55,0,M55-M57)","v":0}]
[]
[null,null,null,{"$f":"D53","v":"Year 5"},null,null,{"$f":"G53","v":"Year 6"},null,null,{"$f":"J53","v":"Year 7"},null,null,{"$f":"M53","v":"Year 8"}]
[null,null,null,{"$f":"D54","v":2025},null,null,{"$f":"G54","v":2026},null,null,{"$f":"J54","v":2027},null,null,{"$f":"M54","v":2028}]
["Project Descriptions:","Type",null,"Proposed ACM/ICM","Amortization Expense","CCA","Proposed ACM/ICM","Amortization Expense","CCA","Proposed ACM/ICM","Amortization Expense","CCA","Proposed ACM/ICM","Amortization Expense","CCA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total Cost of ACM/ICM Projects",null,null,{"$f":"SUM(D64:D83)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["Maximum Allowed Incremental Capital",null,null,{"$f":"MIN(D85,D59)","v":0},null,null,{"$f":"MIN(G85,G59)","v":0},null,null,{"$f":"MIN(J85,J59)","v":0},null,null,{"$f":"MIN(M85,M59)","v":0}]
[]
["1.  For the Cost of Service Test Year, CAPEX refers to the CAPEX approved in the DSP. For subsequent Price CAP IR years, the CAPEX to be entered is the actual CAPEX. For the current Price Cap IR year, the CAPEX to be entered is the proposed CAPEX including any ICM/updated ACM project CAPEX for the year.",null,null,{"$f":"D50","v":"Price Cap IR (Deferred Rebasing) (if necessary)"},null,null,{"$f":"G50","v":"Price Cap IR (Deferred Rebasing) (if necessary)"}]
[]
[null,null,null,"Price Cap IR",null,null,"Price Cap IR"]
[null,null,null,"Year 9",null,null,"Year 10"]
[null,null,null,{"$f":"M54+1","v":2029},null,null,{"$f":"D93+1","v":2030}]
["Distribution System Plan CAPEX"]
[]
["Materiality Threshold",null,null,{"$f":"IF('8. Threshold Test'!$E$74=\"\", 0, '8. Threshold Test'!$E$74)","v":14357621.645797461},null,null,{"$f":"IF('8. Threshold Test'!$E$75=\"\", 0, '8. Threshold Test'!$E$75)","v":14850486.339435738}]
[]
["Maximum Eligible Incremental Capital (Forecasted Capex less Threshold)",null,null,{"$f":"IF(D96>D94,0,D94-D96)","v":0},null,null,{"$f":"IF(G96>G94,0,G94-G96)","v":0}]
[]
[null,null,null,{"$f":"D92","v":"Year 9"},null,null,{"$f":"G92","v":"Year 10"}]
[null,null,null,{"$f":"D93","v":2029},null,null,{"$f":"G93","v":2030}]
["Project Descriptions:","Type",null,"Proposed ACM/ICM","Amortization Expense","CCA","Proposed ACM/ICM","Amortization Expense","CCA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total Cost of ACM/ICM Projects",null,null,{"$f":"SUM(D103:D122)","v":0},0,0,0,0,0]
[]
["Maximum Allowed Incremental Capital",null,null,{"$f":"MIN(D124,D98)","v":0},null,null,{"$f":"MIN(G124,G98)","v":0}]
[]
["1.  For the Cost of Service Test Year, CAPEX refers to the CAPEX approved in the DSP. For subsequent Price CAP IR years, the CAPEX to be entered is the actual CAPEX. For the current Price Cap IR year, the CAPEX to be entered is the proposed CAPEX including any ICM/updated ACM project CAPEX for the year."]

{"sheet":"10. Incremental Capital Adj.","index":12,"n_rows":93,"n_cols":6,"rows_kept":93,"cut":false,"hidden":false,"merged":[[23,2,23,4],[28,1,28,5],[22,5,23,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Incremental Capital Adjustment","Rate Year:",null,{"$f":"'1. Information Sheet'!M26","v":2022}]
[]
[]
[]
[null,"Current Revenue Requirement"]
[]
[null,"Current Revenue Requirement - Total",null,null,{"$f":"'5. Rev_Requ_Check'!E62","v":25131710.205667213},"A"]
[]
[]
[null,"Eligible Incremental Capital for ACM/ICM Recovery"]
[null,null,"Total Claim",null,"Eligible for ACM/ICM"]
[null,null,null,null,{"$f":"\"(\"&IF(('1. Information Sheet'!M28-'1. Information Sheet'!M26)=1,\"Half Year*\",\"Full Year\")&\" Prorated Amount)\"","v":"(Full Year Prorated Amount)"},{"$f":"IF(('1. Information Sheet'!M28-'1. Information Sheet'!M26)=1,\"*The half year rule is applied as the distributor is scheduled to rebase in the next rate year.\",\"\")","v":""}]
[null,null,"(from Sheet 10b)"]
[null,"Amount of Capital Projects Claimed",{"$f":"INDIRECT(\"'9b. Proposed ACM ICM Projects'!\"&CHAR(68+MOD('1. Information Sheet'!$F$28-1,4)*3)&(39*INT(('1. Information Sheet'!$F$28-1)/4))+46)","v":12690000},null,{"$f":"IF(('1. Information Sheet'!M28-'1. Information Sheet'!M26)=1,INDIRECT(\"'9b. Proposed ACM ICM Projects'!\"&CHAR(68+MOD('1. Information Sheet'!$F$28-1,4)*3)&(39*INT(('1. Information Sheet'!$F$28-1)/4))+48)/2,INDIRECT(\"'9b. Proposed ACM ICM Projects'!\"&CHAR(68+MOD('1. Information Sheet'!$F$28-1,4)*3)&(39*INT(('1. Information Sheet'!$F$28-1)/4))+48))","v":12690000},"B"]
[null,"Depreciation Expense",{"$f":"INDIRECT(\"'9b. Proposed ACM ICM Projects'!\"&CHAR(69+MOD('1. Information Sheet'!$F$28-1,4)*3)&(39*INT(('1. Information Sheet'!$F$28-1)/4))+46)","v":253800},null,{"$f":"C26*(E25/C25)","v":253800},"C"]
[null,"CCA",{"$f":"INDIRECT(\"'9b. Proposed ACM ICM Projects'!\"&CHAR(70+MOD('1. Information Sheet'!$F$28-1,4)*3)&(39*INT(('1. Information Sheet'!$F$28-1)/4))+46)","v":507600},null,{"$f":"C27*(E25/C25)","v":507600},"V"]
[]
[null,"ACM/ICM Incremental Revenue Requirement Based on Eligible Amount in Rate Year"]
[]
[null,"Return on Rate Base"]
[null,"Incremental Capital",null,null,{"$f":"E25","v":12690000},"B"]
[null,"Depreciation Expense (prorated to Eligible Incremental Capital)",null,null,{"$f":"E26","v":253800},"C"]
[null,"Incremental Capital to be included in Rate Base (average NBV in year)",null,null,{"$f":"E32-E33/2","v":12563100},"D = B - C/2"]
[null,null,"% of capital structure"]
[null,"Deemed Short-Term Debt",{"$f":"'5. Rev_Requ_Check'!C36","v":0.04},"E",{"$f":"E34*C36","v":502524},"G = D * E"]
[null,"Deemed Long-Term Debt",{"$f":"'5. Rev_Requ_Check'!C37","v":0.56000000000000005},"F",{"$f":"E34*C37","v":7035336.0000000009},"H = D * F"]
[null,null,"Rate (%)"]
[null,"Short-Term Interest",{"$f":"'5. Rev_Requ_Check'!C40","v":2.75E-2},"I",{"$f":"E36*C39","v":13819.41},"K = G * I"]
[null,"Long-Term Interest",{"$f":"'5. Rev_Requ_Check'!C41","v":4.7699999999999999E-2},"J",{"$f":"E37*C40","v":335585.52720000001},"L = H * J"]
[]
[null,"Return on Rate Base - Interest",null,null,{"$f":"SUM(E39:E40)","v":349404.93719999999},"M = K + L"]
[]
[null,null,{"$f":"C35","v":"% of capital structure"}]
[null,"Deemed Equity %",{"$f":"'5. Rev_Requ_Check'!C38","v":0.39999999999999991},"N",{"$f":"E34*C45","v":5025239.9999999991},"P = D * N"]
[null,null,{"$f":"C38","v":"Rate (%)"}]
[null,"Return on Rate Base -Equity",{"$f":"'5. Rev_Requ_Check'!C42","v":8.5199999999999998E-2},"O",{"$f":"E45*C47","v":428150.44799999992},"Q = P * O"]
[]
[null,"Return on Rate Base - Total",null,null,{"$f":"E42+E47","v":777555.3851999999},"R = M + Q"]
[]
[]
[]
[null,"Amortization Expense"]
[]
[null,"Amortization Expense - Incremental",null,"C",{"$f":"E33","v":253800},"S"]
[]
[]
[null,"Grossed up Taxes/PILs"]
[]
[null,"Regulatory Taxable Income",null,"O",{"$f":"E47","v":428150.44799999992},"T "]
[]
[null,"Add Back Amortization Expense (Prorated to Eligible Incremental Capital)",null,"S",{"$f":"E55","v":253800},"U"]
[]
[null,"Deduct CCA (Prorated to Eligible Incremental Capital)",null,null,{"$f":"E27","v":507600},"V"]
[]
[null,"Incremental Taxable Income",null,null,{"$f":"E60+E62-E64","v":174350.44799999986},"W = T + U - V"]
[]
[null,"Current Tax Rate",0.26500000000000001,"X"]
[]
[null,"Taxes/PILs Before Gross Up",null,null,{"$f":"E66*C68","v":46202.868719999962},"Y = W * X"]
[]
[null,"Grossed-Up Taxes/PILs",null,null,{"$f":"E70/(1-C68)","v":62861.045877550969},"Z = Y / ( 1 - X ) "]
[]
[]
[null,"Ontario Capital Tax"]
[null,"Incremental Capital CAPEX",null,null,null,"AA"]
[]
[null,"Less : Available Capital Exemption (if any)",null,null,null,"AB"]
[]
[null,"Incremental Capital CAPEX subject to OCT",null,null,null,"AC = AA - AB"]
[]
[null,"Ontario Capital Tax Rate (F1.1 Z-Factor Tax Changes)",null,"AD"]
[]
[null,"Incremental Ontario Capital Tax",null,null,null,"AE = AC * AD"]
[]
[]
[null,"Incremental Revenue Requirement"]
[null,"Return on Rate Base - Total",null,"Q",{"$f":"E49","v":777555.3851999999},"AA"]
[null,"Amortization Expense - Total",null,"S",{"$f":"E55","v":253800},"AB"]
[null,{"$f":"B72","v":"Grossed-Up Taxes/PILs"},null,"Z",{"$f":"E72","v":62861.045877550969},"AC"]
[]
[]
[null,"Incremental Revenue Requirement",null,null,{"$f":"SUM(E88:E90)","v":1094216.4310775509},"AD = AA + AB + AC"]

{"sheet":"11. Rate Rider Calc","index":13,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[[12,0,12,3],[12,4,12,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Calculation of incremental rate rider.  Choose one of the 3 options:",null,null,null,"Fixed Only Rate Rider"]
[]
["Rate Class",null,"Service Charge % Revenue","Distribution Volumetric Rate % Revenue kWh","Distribution Volumetric Rate % Revenue kW","Service Charge Revenue","Distribution Volumetric Rate Revenue kWh","Distribution Volumetric Rate Revenue kW","Total Revenue by Rate Class",null,"Billed Customers or Connections","Billed kWh","Billed kW",null,"Service Charge Rate Rider"]
[null,null,"From Sheet 7","From Sheet 7","From Sheet 7","Col C * Col Itotal","Col  D* Col Itotal","Col  E* Col Itotal","Col Itotal",null,"From Sheet 4","From Sheet 4","From Sheet 4",null,"Col F / Col K / 12"]
["RESIDENTIAL R1",null,{"$f":"'7. Revenue Proportions'!P17","v":0.4447976220188361},{"$f":"'7. Revenue Proportions'!Q17","v":0.24915205430185633},{"$f":"'7. Revenue Proportions'!R17","v":0},{"$f":"ROUND(C17*I22, 2)","v":486704.87},{"$f":"ROUND(D17*I22, 2)","v":272626.27},{"$f":"ROUND(E17*I22, 2)","v":0},{"$f":"ROUND(F17+G17+H17, 2)","v":759331.14},null,{"$f":"'3. Growth Factor - NUM_CALC1'!C17","v":9112.8451064303372},{"$f":"'3. Growth Factor - NUM_CALC1'!D17","v":113337066.32818118},{"$f":"'3. Growth Factor - NUM_CALC1'!E17","v":0},null,{"$f":"IF(ISERROR(ROUND(I17 / K17 / 12, 2)),0,ROUND(I17 / K17 / 12, 2))","v":6.94}]
["RESIDENTIAL R2",null,{"$f":"'7. Revenue Proportions'!P18","v":2.2240178652172374E-2},{"$f":"'7. Revenue Proportions'!Q18","v":0},{"$f":"'7. Revenue Proportions'!R18","v":0.16294461472381333},{"$f":"ROUND(C18*I22, 2)","v":24335.57},{"$f":"ROUND(D18*I22, 2)","v":0},{"$f":"ROUND(E18*I22, 2)","v":178296.67},{"$f":"ROUND(F18+G18+H18, 2)","v":202632.24},null,{"$f":"'3. Growth Factor - NUM_CALC1'!C18","v":37.282220262380214},{"$f":"'3. Growth Factor - NUM_CALC1'!D18","v":107645160.05587883},{"$f":"'3. Growth Factor - NUM_CALC1'!E18","v":248604.90668572392},null,{"$f":"IF(ISERROR(ROUND(I18 / K18 / 12, 2)),0,ROUND(I18 / K18 / 12, 2))","v":452.92}]
["SEASONAL CUSTOMERS",null,{"$f":"'7. Revenue Proportions'!P19","v":7.7782186770251796E-2},{"$f":"'7. Revenue Proportions'!Q19","v":3.5114440874444458E-2},{"$f":"'7. Revenue Proportions'!R19","v":0},{"$f":"ROUND(C19*I22, 2)","v":85110.55},{"$f":"ROUND(D19*I22, 2)","v":38422.800000000003},{"$f":"ROUND(E19*I22, 2)","v":0},{"$f":"ROUND(F19+G19+H19, 2)","v":123533.35},null,{"$f":"'3. Growth Factor - NUM_CALC1'!C19","v":2960.1858518389645},{"$f":"'3. Growth Factor - NUM_CALC1'!D19","v":5874372.3645382812},{"$f":"'3. Growth Factor - NUM_CALC1'!E19","v":0},null,{"$f":"IF(ISERROR(ROUND(I19 / K19 / 12, 2)),0,ROUND(I19 / K19 / 12, 2))","v":3.48}]
["STREET LIGHTING",null,{"$f":"'7. Revenue Proportions'!P20","v":1.0057269469609103E-3},{"$f":"'7. Revenue Proportions'!Q20","v":6.9631757116646797E-3},{"$f":"'7. Revenue Proportions'!R20","v":0},{"$f":"ROUND(C20*I22, 2)","v":1100.48},{"$f":"ROUND(D20*I22, 2)","v":7619.22},{"$f":"ROUND(E20*I22, 2)","v":0},{"$f":"ROUND(F20+G20+H20, 2)","v":8719.7000000000007},null,{"$f":"'3. Growth Factor - NUM_CALC1'!C20","v":1127.6033016645551},{"$f":"'3. Growth Factor - NUM_CALC1'!D20","v":581104.4520676051},{"$f":"'3. Growth Factor - NUM_CALC1'!E20","v":0},null,{"$f":"IF(ISERROR(ROUND(I20 / K20 / 12, 2)),0,ROUND(I20 / K20 / 12, 2))","v":0.64}]
["Total",null,{"$f":"SUM(C17:C20)","v":0.54582571438822114},0.29122967088796542,0.16294461472381333,597251.47,318668.28999999998,178296.67,1094216.43,null,{"$f":"SUM(K17:K20)","v":13237.91648019624},{"$f":"SUM(L17:L20)","v":227437703.20066592},{"$f":"SUM(M17:M20)","v":248604.90668572392}]
[null,null,null,null,null,null,null,null,{"$f":"'10. Incremental Capital Adj.'!E93","v":1094216.4310775509}]
[null,null,null,null,null,null,null,null,"From Sheet 11, E93"]