{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["1. Information Sheet","2. Related Links","lists","3. Rate Class Selection","4. Hidden","6. hidden","4. Growth Factor - NUM_CALC1","5. Growth Factor - NUM_CALC2","9. STS - Billing Det & Rate HID","6. Rev_Requ_Check","7. Growth Factor - DEN_CALC","7. Load Actual - HID","8. Revenue Proportions","8. Current Revenue - HID","9. Threshold Test","24. hidden","Sheet1","10a. Proposed ACM Projects","10b. Proposed ACM ICM Projects","11. Incremental Capital Adj.","12. Opt 1-Rate Rider Calc F & V"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":5,"defined_names":566,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1. Information Sheet","index":0,"n_rows":119,"n_cols":27,"rows_kept":119,"cut":false,"hidden":false,"merged":[[39,5,39,7],[37,0,37,4],[37,5,37,7],[92,7,92,12],[92,3,92,6],[60,0,60,11],[59,0,59,11],[43,5,43,7],[47,9,51,12],[52,2,52,11],[54,2,54,13],[56,2,56,12],[47,0,48,4],[47,5,47,7],[48,5,48,7],[13,5,13,11],[17,5,17,9],[21,5,21,9],[19,5,19,9],[23,5,23,9],[109,1,112,1],[113,1,118,1],[33,5,33,7],[33,0,33,4],[25,0,25,4],[25,5,25,7],[27,0,27,4],[31,5,31,7],[27,5,27,7],[29,0,29,4],[29,5,29,7],[31,0,31,4],[35,0,35,4],[35,5,35,7],[45,5,45,7],[41,5,41,7]]}
[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",4.2]
[]
[null,null,null,null,"Utility Name   ","Algoma Power Inc."]
[]
[]
[]
[null,null,null,null,"Assigned EB Number","EB-2019-0019 (Prospective Model for IRR Responses)"]
[]
[null,null,null,null,"Name of Contact and Title","Greg Beharriell; Manager, Regulatory Affairs"]
[]
[null,null,null,null,"Phone Number   ","905-871-0330; x3278"]
[]
[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,"Rate Year",2021]
[]
[{"$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]
[]
[{"$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":"IF(F26=\"COS\", K26-F28, VLOOKUP(F28, D109:E117,2,FALSE))","v":2019}]
[]
["Last COS OEB Application Number",null,null,null,null,"EB-2019-0019"]
[]
["The most recent complete year for which actual billing and load data exists",null,null,null,null,{"$f":"K26-2","v":2019}]
[]
[null,null,null,null,"Current IPI",1.4999999999999999E-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.2E-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\", $K$26 & \" Test Year Distribution Revenues\", VLOOKUP($F$28, $D$109:$G$117, 3,FALSE)))","v":"Revenues Based on 2019 Board-Approved Distribution Demand"},null,null,{"$f":"LEFT(RIGHT(F48,LEN(F48)-18),4)","v":"2019"},"These will be hidden later. For year three price cap IR, it should be most recent actuals for 2014 divided by 2013 CoS Board-approved. For year 4 price cap IR, should be 2014 actuals divided by 2012 CoS Board-approved."]
[null,null,null,null,null,{"$f":"CONCATENATE(\"Revenues Based on \",IF(F26=\"COS\",F38&\" Actual Distribution Revenues\",VLOOKUP($F$28, $D$109:$G$117, 4,FALSE)))","v":"Revenues Based on 2018 Actual Distribution Demand"},null,null,{"$f":"LEFT(RIGHT(F49,LEN(F49)-18),4)","v":"2018"}]
[]
[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"]
["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."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CoS",null,"Price Cap IR",null,null,null,"Deferred Rebasing (e.g. due to MAADs)"]
[null,null,"Year",1,2,3,4,5,6,7,8,9,10]
["RY",{"$f":"K26","v":2021},"t",{"$f":"$K$26","v":2021},2021,2021,2021,2021,2021,2021,{"$f":"$K$26","v":2021},2021,2021]
["LY ACTUALS",{"$f":"B95-2","v":2019},"t-2",{"$f":"D95-2","v":2019},{"$f":"E95-2","v":2019},2019,2019,2019,2019,2019,2019,2019,2019]
["LAST COS",null,null,{"$f":"D95-1","v":2020},{"$f":"E95-2","v":2019},{"$f":"F95-3","v":2018},{"$f":"G95-G94","v":2017},{"$f":"H95-H94","v":2016},{"$f":"I95-I94","v":2015},2014,2013,2012,2011]
[]
["Growth"]
["Numerator",{"$f":"CONCATENATE(B95,\" Test Year Distribution Demand\")","v":"2021 Test Year Distribution Demand"}," ",{"$f":"CONCATENATE(D97,\" Board-Approved Distribution Demand\")","v":"2020 Board-Approved Distribution Demand"},{"$f":"CONCATENATE(E97,\" Board-Approved Distribution Demand\")","v":"2019 Board-Approved Distribution Demand"},{"$f":"CONCATENATE(F97+1,\" Actual Distribution Demand\")","v":"2019 Actual Distribution Demand"},{"$f":"CONCATENATE(G97+2,\" Actual Distribution Demand\")","v":"2019 Actual Distribution Demand"},{"$f":"CONCATENATE(H97+3,\" Actual Distribution Demand\")","v":"2019 Actual Distribution Demand"},{"$f":"CONCATENATE(I97+4,\" Actual Distribution Demand\")","v":"2019 Actual Distribution Demand"},{"$f":"CONCATENATE(J97+5,\" Actual Distribution Demand\")","v":"2019 Actual Distribution Demand"},{"$f":"CONCATENATE(K97+6,\" Actual Distribution Demand\")","v":"2019 Actual Distribution Demand"},{"$f":"CONCATENATE(L97+7,\" Actual Distribution Demand\")","v":"2019 Actual Distribution Demand"},{"$f":"CONCATENATE(M97+8,\" Actual Distribution Demand\")","v":"2019 Actual Distribution Demand"}]
["Denominator",{"$f":"CONCATENATE(B96,\" Actual Distribution Demand\")","v":"2019 Actual Distribution Demand"}," ",{"$f":"CONCATENATE(D96,\" Actual Distribution Demand\")","v":"2019 Actual Distribution Demand"},{"$f":"CONCATENATE(E96-1,\" Actual Distribution Demand\")","v":"2018 Actual Distribution Demand"},{"$f":"CONCATENATE(F97,\" Board-Approved Distribution Demand\")","v":"2018 Board-Approved Distribution Demand"},"2017 Board-Approved Distribution Demand","2016 Board-Approved Distribution Demand","2015 Board-Approved Distribution Demand","2014 Board-Approved Distribution Demand","2013 Board-Approved Distribution Demand","2012 Board-Approved Distribution Demand","2011 Board-Approved Distribution Demand"]
["Annualized?","Yes",null,"No","No","No","Yes","Yes","Yes","Yes","Yes","Yes","Yes"]
["Divisor to Annualized",{"$f":"B106","v":2},null,1,1,1,2,3,4,5,6,7,8]
[null,{"$f":"LEFT(B100,4)","v":"2021"},null,{"$f":"LEFT(D100,4)","v":"2020"},"2019","2019","2019","2019","2019","2019","2019",{"$f":"LEFT(L100,4)","v":"2019"},"2019"]
[null,{"$f":"LEFT(B101,4)","v":"2019"},null,"2019","2018","2018","2017","2016","2015","2014","2013",{"$f":"LEFT(L101,4)","v":"2012"},"2011"]
[null,{"$f":"B104-B105","v":2},null,{"$f":"D104-D105","v":1},1,1,2,3,4,5,6,{"$f":"L104-L105","v":7},8]
[]
[]
[null,null,null,"Price Cap IR","Last CoS"]
[null,"Normal Price cap period term",null,1,{"$f":"D97","v":2020},{"$f":"D100","v":"2020 Board-Approved Distribution Demand"},{"$f":"D101","v":"2019 Actual Distribution Demand"}]
[null,null,null,2,{"$f":"E97","v":2019},{"$f":"E100","v":"2019 Board-Approved Distribution Demand"},{"$f":"E101","v":"2018 Actual Distribution Demand"}]
[null,null,null,3,{"$f":"F97","v":2018},{"$f":"F100","v":"2019 Actual Distribution Demand"},{"$f":"F101","v":"2018 Board-Approved Distribution Demand"}]
[null,null,null,4,{"$f":"G97","v":2017},{"$f":"G100","v":"2019 Actual Distribution Demand"},{"$f":"G101","v":"2017 Board-Approved Distribution Demand"}]
[null,"Deferred rebasng (including MAADs deferral period) (Max. 10 years)",null,5,{"$f":"H97","v":2016},{"$f":"H100","v":"2019 Actual Distribution Demand"},{"$f":"H101","v":"2016 Board-Approved Distribution Demand"}]
[null,null,null,6,{"$f":"I97","v":2015},{"$f":"I100","v":"2019 Actual Distribution Demand"},{"$f":"I101","v":"2015 Board-Approved Distribution Demand"}]
[null,null,null,7,{"$f":"J97","v":2014},{"$f":"J100","v":"2019 Actual Distribution Demand"},{"$f":"J101","v":"2014 Board-Approved Distribution Demand"}]
[null,null,null,8,{"$f":"K97","v":2013},{"$f":"K100","v":"2019 Actual Distribution Demand"},{"$f":"K101","v":"2013 Board-Approved Distribution Demand"}]
[null,null,null,9,{"$f":"L97","v":2012},{"$f":"L100","v":"2019 Actual Distribution Demand"},{"$f":"L101","v":"2012 Board-Approved Distribution Demand"}]
[null,null,null,10,{"$f":"M97","v":2011},{"$f":"M100","v":"2019 Actual Distribution Demand"},{"$f":"M101","v":"2011 Board-Approved Distribution Demand"}]

{"sheet":"2. Related Links","index":1,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":true,"merged":[[12,1,12,7],[14,0,14,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["intentionally blank"]

{"sheet":"lists","index":2,"n_rows":214,"n_cols":55,"rows_kept":214,"cut":false,"hidden":true,"merged":[[12,51,12,52],[1,51,1,52],[0,51,0,52],[11,51,11,52],[10,51,10,52],[9,51,9,52],[8,51,8,52],[7,51,7,52],[5,51,5,52],[4,51,4,52],[3,51,3,52],[2,51,2,52],[6,51,6,52],[13,51,13,52],[14,51,14,52],[15,51,15,52],[16,51,16,52],[17,51,17,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","Algoma Power Inc.",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","Atikokan Hydro Inc.",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 Rate Zone","Bluewater Power Distribution Corporation",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","Brant County Power Inc.",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,"Algoma Power Inc.","Brantford Power Inc.",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,"Atikokan Hydro Inc.","Burlington Hydro Inc.",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,"Attawapiskat Power Corp. ","Cambridge and North Dumfries Hydro Inc.",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","Canadian Niagara Power Inc.",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.","Centre Wellington Hydro Ltd.",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.","Chapleau Public Utilities Corporation",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.","Collus PowerStream Corporation",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.","Cooperative Hydro Embrun Inc.",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","E.L.K. Energy Inc.",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,"COLLUS Power Corporation","Enersource Hydro Mississauga Inc.",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,"Cooperative Hydro Embrun Inc.","Entegrus Powerlines Inc.",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,"E.L.K. Energy Inc.","Entegrus Powerlines Inc. - Dutton Service Area",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,"Energy Plus Inc. - Brant County Rate Zone","Entegrus Powerlines Inc. - former Chatham-Kent Hydro Service Area",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 Plus Inc. - Cambridge and North Dumfries Rate Zone","Entegrus Powerlines Inc. - Newbury Service Area",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.","Entegrus Powerlines Inc. - Strathroy, Mount Brydges and Parkhill Service Areas",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,"ENWIN Utilities Ltd.","ENWIN Utilities Ltd.",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,"Erie Thames Powerlines Corporation","Erie Thames Powerlines Corporation",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,"Espanola Regional Hydro Distribution Corporation","Espanola Regional Hydro Distribution Corporation",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,"Essex Powerlines Corporation","Essex Powerlines Corporation",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,"Festival Hydro Inc.","Festival Hydro Inc.",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,"Fort Frances Power Corporation","Fort Frances Power Corporation",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,"Greater Sudbury Hydro Inc.","Greater Sudbury Hydro Inc.",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,"Grimsby Power Inc.","Grimsby Power Inc.",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,"Guelph Hydro Electric Systems Inc.","Guelph Hydro Electric Systems Inc.",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,"Haldimand County Hydro Inc.","Haldimand County Hydro Inc.",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.","Halton Hills Hydro Inc.",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 Company Limited","Hearst Power Distribution Company Limited",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.","Horizon Utilities Corporation",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.","Hydro 2000 Inc.",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.","Hydro Hawkesbury Inc.",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 Ottawa Limited","Hydro One Brampton Networks Inc.",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,"Innpower Corporation","Hydro One Networks Inc.",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,"Kenora Hydro Electric Corporation Ltd.","Hydro Ottawa Limited",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,"Kingston Hydro Corporation","Innisfil Hydro Distribution Systems Limited",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,"Kitchener-Wilmot Hydro Inc.","Kenora Hydro Electric Corporation Ltd.",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,"Lakefront Utilities Inc.","Kingston Hydro Corporation",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,"Lakeland Power Distribution Ltd.","Kitchener-Wilmot Hydro Inc.",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,"Lakeland Power Distribution Ltd. - Parry Sound Rate Zone","Lakefront Utilities Inc.",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,"London Hydro Inc.","Lakeland Power Distribution Ltd.",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,"Midland Power Utility Corporation","London Hydro Inc.",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,"Milton Hydro Distribution inc.","Midland Power Utility Corporation",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,"Newmarket - Tay Power Distribution Ltd.","Milton Hydro Distribution Inc.",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,"Niagara Peninsula Energy Inc.","Newmarket - Tay Power Distribution Ltd.",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,"Niagara-on-the-Lake Hydro Inc.","Niagara Peninsula Energy Inc.",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,"Norfolk Power Distribution Inc.","Niagara-on-the-Lake Hydro Inc.",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,"North Bay Hydro Distribution Limited","Norfolk Power Distribution Inc.",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,"Northern Ontario Wires Inc.","North Bay Hydro Distribution Limited",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,"Oakville Hydro Electricity Distribution Inc.","Northern Ontario Wires Inc.",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,"Orangeville Hydro Limited","Oakville Hydro Electricity Distribution Inc.",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,"Orillia Power Distribution Corporation","Orangeville Hydro Limited",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,"Oshawa PUC Networks Inc.","Orillia Power Distribution Corporation",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,"Ottawa River Power Corporation","Oshawa PUC Networks Inc.",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,"Peterborough Distribution Incorporated","Ottawa River Power Corporation",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,"PUC Distribution Inc.","Parry Sound Power Corporation",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,"Renfrew Hydro Inc.","Peterborough Distribution Incorporated",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,"Rideau St. Lawrence Distribution Inc.","PowerStream Inc.",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,"Sioux Lookout Hydro Inc.","PUC Distribution Inc.",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,"St. Thomas Energy Inc.","Renfrew Hydro Inc.",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,"Thunder Bay Hydro Electricity Distribution Inc.","Rideau St. Lawrence Distribution Inc.",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,"Tillsonburg Hydro Inc.","Sioux Lookout Hydro Inc.",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,"Toronto Hydro-Electric System Limited","St. Thomas Energy Inc.",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,"Veridian Connections Inc.","Thunder Bay Hydro Electricity Distribution Inc.",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,"Wasaga Distribution Inc.","Tillsonburg Hydro Inc.",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,"Waterloo North Hydro Inc.","Toronto Hydro-Electric System Limited",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,"Welland Hydro-Electric System Corp.","Veridian Connections Inc.",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,"Wellington North Power Inc.","Wasaga Distribution Inc.",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,"West Coast Huron Energy Inc.","Waterloo North Hydro Inc.",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,"Westario Power Inc.","Welland Hydro-Electric System Corp.",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,"Whitby Hydro Electric Corporation","Wellington North Power Inc.",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,"Woodstock Hydro Services Inc.","West Coast Huron Energy Inc.",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,"Westario Power Inc.",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,"Whitby Hydro Electric Corporation",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,"Woodstock Hydro Services Inc.",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":"3. Rate Class Selection","index":3,"n_rows":33,"n_cols":17,"rows_kept":33,"cut":false,"hidden":false,"merged":[[21,1,21,9],[11,0,11,13],[17,1,17,9],[18,1,18,9],[19,1,19,9],[20,1,20,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Select the appropriate rate classes as they appear on your most recent Board-Approved Tariff of Rates and Charges, excluding the MicroFit Class."]
[]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# of duplicates"]
[1,"RESIDENTIAL R1",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($B$19:$J$40, B19)","v":1},{"$f":"COUNTIF(P19:P40, 2)/2","v":0}]
[2,"RESIDENTIAL R2",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($B$19:$J$40, B20)","v":1}]
[3,"SEASONAL CUSTOMERS",null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[4,"STREET LIGHTING",null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,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,null,null,null,0]
[null,null,null,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,null,null,null,0]
[null,null,null,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,null,null,null,0]
[null,null,null,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,null,null,null,0]
[null,null,null,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,null,null,null,0]

{"sheet":"4. Hidden","index":4,"n_rows":456,"n_cols":18,"rows_kept":456,"cut":false,"hidden":true,"merged":[[453,1,453,6],[454,1,454,6],[455,1,455,6],[444,1,444,6],[445,1,445,6],[446,1,446,6],[447,1,447,6],[448,1,448,6],[449,1,449,6],[450,1,450,6],[451,1,451,6],[452,1,452,6],[435,1,435,6],[436,1,436,6],[437,1,437,6],[438,1,438,6],[439,1,439,6],[440,1,440,6],[441,1,441,6],[442,1,442,6],[443,1,443,6],[426,1,426,6],[427,1,427,6],[428,1,428,6],[429,1,429,6],[430,1,430,6],[431,1,431,6],[432,1,432,6],[433,1,433,6],[434,1,434,6],[396,1,396,6],[397,1,397,6],[398,1,398,6],[401,1,401,8],[403,1,408,8],[411,1,413,8],[414,1,417,8],[418,1,420,8],[421,1,424,8],[385,1,385,6],[386,1,386,6],[387,1,387,6],[388,1,388,6],[389,1,389,6],[390,1,390,6],[391,1,391,6],[392,1,392,6],[395,1,395,6],[376,1,376,6],[377,1,377,6],[378,1,378,6],[379,1,379,6],[380,1,380,6],[381,1,381,6],[382,1,382,6],[383,1,383,6],[384,1,384,6],[367,1,367,6],[368,1,368,6],[369,1,369,6],[370,1,370,6],[371,1,371,6],[372,1,372,6],[373,1,373,6],[374,1,374,6],[375,1,375,6],[340,1,345,8],[348,1,350,8],[351,1,354,8],[355,1,357,8],[358,1,361,8],[363,1,363,6],[364,1,364,6],[365,1,365,6],[366,1,366,6],[326,1,326,6],[327,1,327,6],[328,1,328,6],[329,1,329,6],[332,1,332,6],[333,1,333,6],[334,1,334,6],[335,1,335,6],[338,1,338,8],[317,1,317,6],[318,1,318,6],[319,1,319,6],[320,1,320,6],[321,1,321,6],[322,1,322,6],[323,1,323,6],[324,1,324,6],[325,1,325,6],[308,1,308,6],[309,1,309,6],[310,1,310,6],[311,1,311,6],[312,1,312,6],[313,1,313,6],[314,1,314,6],[315,1,315,6],[316,1,316,6],[295,1,298,8],[300,1,300,6],[301,1,301,6],[302,1,302,6],[303,1,303,6],[304,1,304,6],[305,1,305,6],[306,1,306,6],[307,1,307,6],[269,1,269,6],[270,1,270,6],[271,1,271,6],[272,1,272,6],[275,1,275,8],[277,1,282,8],[285,1,287,8],[288,1,291,8],[292,1,294,8],[258,1,258,6],[259,1,259,6],[260,1,260,6],[261,1,261,6],[262,1,262,6],[263,1,263,6],[264,1,264,6],[265,1,265,6],[266,1,266,6],[249,1,249,6],[250,1,250,6],[251,1,251,6],[252,1,252,6],[253,1,253,6],[254,1,254,6],[255,1,255,6],[256,1,256,6],[257,1,257,6],[240,1,240,6],[241,1,241,6],[242,1,242,6],[243,1,243,6],[244,1,244,6],[245,1,245,6],[246,1,246,6],[247,1,247,6],[248,1,248,6],[212,1,212,8],[214,1,219,8],[222,1,224,8],[225,1,228,8],[229,1,231,8],[232,1,235,8],[237,1,237,6],[238,1,238,6],[239,1,239,6],[43,1,46,8],[48,1,48,6],[49,1,49,6],[50,1,50,6],[51,1,51,6],[23,1,23,8],[25,1,30,8],[33,1,35,8],[36,1,39,8],[40,1,42,8],[52,1,52,6],[58,1,58,6],[53,1,53,6],[54,1,54,6],[55,1,55,6],[56,1,56,6],[71,1,71,6],[72,1,72,6],[65,1,65,6],[63,1,63,6],[57,1,57,6],[59,1,59,6],[62,1,62,6],[64,1,64,6],[66,1,66,6],[60,1,60,6],[61,1,61,6],[75,1,75,6],[76,1,76,6],[67,1,67,6],[68,1,68,6],[69,1,69,6],[70,1,70,6],[106,1,109,8],[111,1,111,6],[112,1,112,6],[83,1,83,6],[80,1,80,6],[81,1,81,6],[82,1,82,6],[77,1,77,6],[73,1,73,6],[74,1,74,6],[113,1,113,6],[114,1,114,6],[86,1,86,8],[88,1,93,8],[96,1,98,8],[99,1,102,8],[103,1,105,8],[120,1,120,6],[121,1,121,6],[122,1,122,6],[123,1,123,6],[124,1,124,6],[115,1,115,6],[116,1,116,6],[117,1,117,6],[118,1,118,6],[119,1,119,6],[130,1,130,6],[131,1,131,6],[132,1,132,6],[133,1,133,6],[134,1,134,6],[125,1,125,6],[126,1,126,6],[127,1,127,6],[128,1,128,6],[129,1,129,6],[140,1,140,6],[143,1,143,6],[144,1,144,6],[145,1,145,6],[146,1,146,6],[135,1,135,6],[136,1,136,6],[137,1,137,6],[138,1,138,6],[139,1,139,6],[169,1,172,8],[174,1,174,6],[175,1,175,6],[176,1,176,6],[177,1,177,6],[149,1,149,8],[151,1,156,8],[159,1,161,8],[162,1,165,8],[166,1,168,8],[183,1,183,6],[184,1,184,6],[185,1,185,6],[186,1,186,6],[187,1,187,6],[178,1,178,6],[179,1,179,6],[180,1,180,6],[181,1,181,6],[182,1,182,6],[193,1,193,6],[194,1,194,6],[195,1,195,6],[196,1,196,6],[197,1,197,6],[188,1,188,6],[189,1,189,6],[190,1,190,6],[191,1,191,6],[192,1,192,6],[203,1,203,6],[206,1,206,6],[207,1,207,6],[208,1,208,6],[209,1,209,6],[198,1,198,6],[199,1,199,6],[200,1,200,6],[201,1,201,6],[202,1,202,6]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Current Rate Classes","Changed to Rate Classes","Values in A that are NOT in B","Values in B that are Not in A","Count of A","Count of B"]
[null,null,null,null,null,null,null,null,null,null,null,null,"RESIDENTIAL","RESIDENTIAL",null,null,3,3]
[null,null,null,null,null,null,null,null,null,null,null,null,"STREET LIGHTING","STREET LIGHTING"]
[null,null,null,null,null,null,null,null,null,null,null,null,"STANDBY POWER","STANDBY POWER"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["RESIDENTIAL","RESIDENTIAL Service Classification"]
["RESIDENTIAL"]
["RESIDENTIAL","This classification refers to the supply of electrical energy to residential customers residing in detached, semi detached, town house (freehold or condominium) dwelling units, duplexes or triplexes.  Suply will be limited up to a maximum of 200 amp @ 240/120 volt.  Further servicing details are available in the distributor's Conditions of Service"]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL","APPLICATION"]
["RESIDENTIAL"]
["RESIDENTIAL","The application of these rates and charges shall be in accordance with the Licence of the Distributor and any Code or Order of the Board, and amendments thereto as approved by the Board, which may be applicable to the administration of this schedule."]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL","No rates and charges for the distribution of electricity and charges to meet the costs of any work or service done or furnished for the purpose of the distribution of electricityshall be made except as prmitted by this schedule, unless required by the Distributor's Licence or a Code or Order of the Board, and amendments thereto as approved by the Board, or as specified herein."]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL","Unless specifically noted, this schedule does not contain any charges for the electricity commodity, be it under the Regulated Price Plan, a contract with a retailer or the wholesale market price, as applicable.  In addition, the charges in the MONTHLY RATES AND CHARGES - Regulatory Component of this schedule fo not apply to a customer that is an embedded wholesale market participant."]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL","It should be noted that this schedule does not list any charges, assessments or credits that are required by law to be invoiced by a distributor and that are not subject to Board approval, such as Debt Retirement Charge, the Global Adjustment, the Ontario Clean Energy Benefit and the HST."]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL","MONTHLY RATES AND CHARGES - Delivery Component      (If applicable, Effective Date MUST be included in rate description)"]
["RESIDENTIAL","Service Charge",null,null,null,null,null,"$",19.940000000000001]
["RESIDENTIAL","Rate Rider for Recovery of Stranded Meter Assets – effective until April 30, 2015",null,null,null,null,null,"$",1.27]
["RESIDENTIAL","Rate Rider for Smart Metering Entity Charge - effective until October 31, 2018",null,null,null,null,null,"$",0.79]
["RESIDENTIAL","Distribution Volumetric Rate",null,null,null,null,null,"$/kWh",1.46E-2]
["RESIDENTIAL","Low Voltage Service Rate",null,null,null,null,null,"$/kWh",3.3999999999999998E-3]
["RESIDENTIAL","Retail Transmission Rate - Network Service Rate",null,null,null,null,null,"$/kWh",6.0000000000000001E-3]
["RESIDENTIAL","Retail Transmission Rate - Line and Transformation Connection Service Rate",null,null,null,null,null,"$/kWh",4.1000000000000003E-3]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL"]
["RESIDENTIAL","MONTHLY RATES AND CHARGES - Regulatory Component"]
["RESIDENTIAL"]
["RESIDENTIAL","Wholesale Market Service Rate",null,null,null,null,null,"$/kWh",4.4000000000000003E-3]
["RESIDENTIAL","Rural or Remote Electricity Rate Protection Charge (RRRP)",null,null,null,null,null,"$/kWh",1.2999999999999999E-3]
["RESIDENTIAL","Standard Supply Service - Administrative Charge (if applicable)",null,null,null,null,null,"$",0.25]
["RESIDENTIAL"]
[]
[]
["GENERAL SERVICE LESS THAN 50 KW","GENERAL SERVICE LESS THAN 50 KW Service Classification"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW","This classification refers to a non-residential account taking electricity at 750 volts or less whose monthly peak demand is less than or is expected to be less than 50 kW.  Further servicing details are available in the distributor's Conditions of Service."]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW","APPLICATION"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW","The application of these rates and charges shall be in accordance with the Licence of the Distributor and any Code or Order of the Board, and amendments thereto as approved by the Board, which may be applicable to the administration of this schedule."]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW","No rates and charges for the distribution of electricity and charges to meet the costs of any work or service done or furnished for the purpose of the distribution of electricityshall be made except as prmitted by this schedule, unless required by the Distributor's Licence or a Code or Order of the Board, and amendments thereto as approved by the Board, or as specified herein."]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW","Unless specifically noted, this schedule does not contain any charges for the electricity commodity, be it under the Regulated Price Plan, a contract with a retailer or the wholesale market price, as applicable.  In addition, the charges in the MONTHLY RATES AND CHARGES - Regulatory Component of this schedule fo not apply to a customer that is an embedded wholesale market participant."]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW","It should be noted that this schedule does not list any charges, assessments or credits that are required by law to be invoiced by a distributor and that are not subject to Board approval, such as Debt Retirement Charge, the Global Adjustment, the Ontario Clean Energy Benefit and the HST."]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW","MONTHLY RATES AND CHARGES - Delivery Component      (If applicable, Effective Date MUST be included in rate description)"]
["GENERAL SERVICE LESS THAN 50 KW","Service Charge",null,null,null,null,null,"$",43.19]
["GENERAL SERVICE LESS THAN 50 KW","Rate Rider for Recovery of Stranded Meter Assets – effective until April 30, 2015",null,null,null,null,null,"$",5.26]
["GENERAL SERVICE LESS THAN 50 KW","Rate Rider for Smart Metering Entity Charge - effective until October 31, 2018",null,null,null,null,null,"$",0.79]
["GENERAL SERVICE LESS THAN 50 KW","Distribution Volumetric Rate",null,null,null,null,null,"$/kWh",8.8000000000000005E-3]
["GENERAL SERVICE LESS THAN 50 KW","Low Voltage Service Rate",null,null,null,null,null,"$/kWh",3.0000000000000001E-3]
["GENERAL SERVICE LESS THAN 50 KW","Retail Transmission Rate - Network Service Rate",null,null,null,null,null,"$/kWh",5.4999999999999997E-3]
["GENERAL SERVICE LESS THAN 50 KW","Retail Transmission Rate - Line and Transformation Connection Service Rate",null,null,null,null,null,"$/kWh",3.8999999999999998E-3]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW","MONTHLY RATES AND CHARGES - Regulatory Component"]
["GENERAL SERVICE LESS THAN 50 KW"]
["GENERAL SERVICE LESS THAN 50 KW","Wholesale Market Service Rate",null,null,null,null,null,{"$f":"H81","v":"$/kWh"},4.4000000000000003E-3]
["GENERAL SERVICE LESS THAN 50 KW","Rural or Remote Electricity Rate Protection Charge (RRRP)",null,null,null,null,null,"$/kWh",1.2999999999999999E-3]
["GENERAL SERVICE LESS THAN 50 KW","Standard Supply Service - Administrative Charge (if applicable)",null,null,null,null,null,"$",0.25]
["GENERAL SERVICE LESS THAN 50 KW"]
[]
[]
["GENERAL SERVICE 50 TO 4,999 KW","GENERAL SERVICE 50 TO 4,999 KW Service Classification"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW","This classification refers to a non residential account whose monthly average peak demand is equal to or greater than, or is espected to be equal to or greater than 50 kW but less then 5,000 kW.  Further servicing details are available in the distributor's Conditions of Service."]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW","APPLICATION"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW","The application of these rates and charges shall be in accordance with the Licence of the Distributor and any Code or Order of the Board, and amendments thereto as approved by the Board, which may be applicable to the administration of this schedule."]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW","No rates and charges for the distribution of electricity and charges to meet the costs of any work or service done or furnished for the purpose of the distribution of electricityshall be made except as prmitted by this schedule, unless required by the Distributor's Licence or a Code or Order of the Board, and amendments thereto as approved by the Board, or as specified herein."]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW","Unless specifically noted, this schedule does not contain any charges for the electricity commodity, be it under the Regulated Price Plan, a contract with a retailer or the wholesale market price, as applicable.  In addition, the charges in the MONTHLY RATES AND CHARGES - Regulatory Component of this schedule fo not apply to a customer that is an embedded wholesale market participant."]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW","It should be noted that this schedule does not list any charges, assessments or credits that are required by law to be invoiced by a distributor and that are not subject to Board approval, such as Debt Retirement Charge, the Global Adjustment, the Ontario Clean Energy Benefit and the HST."]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW","MONTHLY RATES AND CHARGES - Delivery Component      (If applicable, Effective Date MUST be included in rate description)"]
["GENERAL SERVICE 50 TO 4,999 KW","Service Charge",null,null,null,null,null,"$",304.2]
["GENERAL SERVICE 50 TO 4,999 KW","Distribution Volumetric Rate",null,null,null,null,null,"$/kW",2.7353999999999998]
["GENERAL SERVICE 50 TO 4,999 KW","Low Voltage Service Rate",null,null,null,null,null,"$/kW",1.387]
["GENERAL SERVICE 50 TO 4,999 KW","Retail Transmission Rate - Network Service Rate",null,null,null,null,null,"$/kW",2.3628999999999998]
["GENERAL SERVICE 50 TO 4,999 KW","Retail Transmission Rate - Line and Transformation Connection Service Rate",null,null,null,null,null,"$/kW",1.6344000000000001]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW","MONTHLY RATES AND CHARGES - Regulatory Component"]
["GENERAL SERVICE 50 TO 4,999 KW"]
["GENERAL SERVICE 50 TO 4,999 KW","Wholesale Market Service Rate",null,null,null,null,null,{"$f":"H81","v":"$/kWh"},4.4000000000000003E-3]
["GENERAL SERVICE 50 TO 4,999 KW","Rural or Remote Electricity Rate Protection Charge (RRRP)",null,null,null,null,null,"$/kWh",1.2999999999999999E-3]
["GENERAL SERVICE 50 TO 4,999 KW","Standard Supply Service - Administrative Charge (if applicable)",null,null,null,null,null,"$",0.25]
["GENERAL SERVICE 50 TO 4,999 KW"]
[]
[]
["UNMETERED SCATTERED LOAD","UNMETERED SCATTERED LOAD Service Classification"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD","This classification refers to a non-residiential account taking electricity at 240/120 or 120 volts whose monthly peak demand is less than or expected to be less than 50 kW and is unmetered.  A detailed calculation or the load will be calculated for billing purposes.  Further servicing detials are available in the distributor's Conditions of Service."]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD","APPLICATION"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD","The application of these rates and charges shall be in accordance with the Licence of the Distributor and any Code or Order of the Board, and amendments thereto as approved by the Board, which may be applicable to the administration of this schedule."]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD","No rates and charges for the distribution of electricity and charges to meet the costs of any work or service done or furnished for the purpose of the distribution of electricityshall be made except as prmitted by this schedule, unless required by the Distributor's Licence or a Code or Order of the Board, and amendments thereto as approved by the Board, or as specified herein."]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD","Unless specifically noted, this schedule does not contain any charges for the electricity commodity, be it under the Regulated Price Plan, a contract with a retailer or the wholesale market price, as applicable.  In addition, the charges in the MONTHLY RATES AND CHARGES - Regulatory Component of this schedule fo not apply to a customer that is an embedded wholesale market participant."]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD","It should be noted that this schedule does not list any charges, assessments or credits that are required by law to be invoiced by a distributor and that are not subject to Board approval, such as Debt Retirement Charge, the Global Adjustment, the Ontario Clean Energy Benefit and the HST."]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD","MONTHLY RATES AND CHARGES - Delivery Component      (If applicable, Effective Date MUST be included in rate description)"]
["UNMETERED SCATTERED LOAD","Service Charge",null,null,null,null,null,"$",12.35]
["UNMETERED SCATTERED LOAD","Distribution Volumetric Rate",null,null,null,null,null,"$/kWh",5.5999999999999999E-3]
["UNMETERED SCATTERED LOAD","Low Voltage Service Rate",null,null,null,null,null,"$/kWh",3.0000000000000001E-3]
["UNMETERED SCATTERED LOAD","Retail Transmission Rate - Network Service Rate",null,null,null,null,null,"$/kWh",5.4999999999999997E-3]
["UNMETERED SCATTERED LOAD","Retail Transmission Rate - Line and Transformation Connection Service Rate",null,null,null,null,null,"$/kWh",3.8999999999999998E-3]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD","MONTHLY RATES AND CHARGES - Regulatory Component"]
["UNMETERED SCATTERED LOAD"]
["UNMETERED SCATTERED LOAD","Wholesale Market Service Rate",null,null,null,null,null,{"$f":"H81","v":"$/kWh"},4.4000000000000003E-3]
["UNMETERED SCATTERED LOAD","Rural or Remote Electricity Rate Protection Charge (RRRP)",null,null,null,null,null,"$/kWh",1.2999999999999999E-3]
["UNMETERED SCATTERED LOAD","Standard Supply Service - Administrative Charge (if applicable)",null,null,null,null,null,"$",0.25]
["UNMETERED SCATTERED LOAD"]
[]
[]
["SENTINEL LIGHTING","SENTINEL LIGHTING Service Classification"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING","This classification refers to accounts that are unmetered lighting load supplied to a sentinel light.  Further servicing details are available in the distributor's Conditions of Service."]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING","APPLICATION"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING","The application of these rates and charges shall be in accordance with the Licence of the Distributor and any Code or Order of the Board, and amendments thereto as approved by the Board, which may be applicable to the administration of this schedule."]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING","No rates and charges for the distribution of electricity and charges to meet the costs of any work or service done or furnished for the purpose of the distribution of electricityshall be made except as prmitted by this schedule, unless required by the Distributor's Licence or a Code or Order of the Board, and amendments thereto as approved by the Board, or as specified herein."]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING","Unless specifically noted, this schedule does not contain any charges for the electricity commodity, be it under the Regulated Price Plan, a contract with a retailer or the wholesale market price, as applicable.  In addition, the charges in the MONTHLY RATES AND CHARGES - Regulatory Component of this schedule fo not apply to a customer that is an embedded wholesale market participant."]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING","It should be noted that this schedule does not list any charges, assessments or credits that are required by law to be invoiced by a distributor and that are not subject to Board approval, such as Debt Retirement Charge, the Global Adjustment, the Ontario Clean Energy Benefit and the HST."]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING","MONTHLY RATES AND CHARGES - Delivery Component      (If applicable, Effective Date MUST be included in rate description)"]
["SENTINEL LIGHTING","Service Charge",null,null,null,null,null,"$",6.19]
["SENTINEL LIGHTING","Distribution Volumetric Rate",null,null,null,null,null,"$/kW",21.418600000000001]
["SENTINEL LIGHTING","Low Voltage Service Rate",null,null,null,null,null,"$/kW",0.9526]
["SENTINEL LIGHTING","Retail Transmission Rate - Network Service Rate",null,null,null,null,null,"$/kW",1.7656000000000001]
["SENTINEL LIGHTING","Retail Transmission Rate - Line and Transformation Connection Service Rate",null,null,null,null,null,"$/kW",1.2044999999999999]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING","MONTHLY RATES AND CHARGES - Regulatory Component"]
["SENTINEL LIGHTING"]
["SENTINEL LIGHTING","Wholesale Market Service Rate",null,null,null,null,null,{"$f":"H81","v":"$/kWh"},4.4000000000000003E-3]
["SENTINEL LIGHTING","Rural or Remote Electricity Rate Protection Charge (RRRP)",null,null,null,null,null,"$/kWh",1.2999999999999999E-3]
["SENTINEL LIGHTING","Standard Supply Service - Administrative Charge (if applicable)",null,null,null,null,null,"$",0.25]
["SENTINEL LIGHTING"]
[]
[]
["STREET LIGHTING","STREET LIGHTING Service Classification"]
["STREET LIGHTING"]
["STREET LIGHTING","This classification refers too accounts concerning roadway lighting for a Municipality, Regional Municipality, and/or the Ministry of Transportation.  This lighting will be controlled by photocells.  The consumption for these customers will be based on the calculated connected load times as established in the approved OEB Street Lighting Load Shape Template.  Further servicing details are available in the distributor's Conditions of Service."]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING","APPLICATION"]
["STREET LIGHTING"]
["STREET LIGHTING","The application of these rates and charges shall be in accordance with the Licence of the Distributor and any Code or Order of the Board, and amendments thereto as approved by the Board, which may be applicable to the administration of this schedule."]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING","No rates and charges for the distribution of electricity and charges to meet the costs of any work or service done or furnished for the purpose of the distribution of electricityshall be made except as prmitted by this schedule, unless required by the Distributor's Licence or a Code or Order of the Board, and amendments thereto as approved by the Board, or as specified herein."]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING","Unless specifically noted, this schedule does not contain any charges for the electricity commodity, be it under the Regulated Price Plan, a contract with a retailer or the wholesale market price, as applicable.  In addition, the charges in the MONTHLY RATES AND CHARGES - Regulatory Component of this schedule fo not apply to a customer that is an embedded wholesale market participant."]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING","It should be noted that this schedule does not list any charges, assessments or credits that are required by law to be invoiced by a distributor and that are not subject to Board approval, such as Debt Retirement Charge, the Global Adjustment, the Ontario Clean Energy Benefit and the HST."]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING","MONTHLY RATES AND CHARGES - Delivery Component      (If applicable, Effective Date MUST be included in rate description)"]
["STREET LIGHTING","Service Charge",null,null,null,null,null,"$",5.0999999999999996]
["STREET LIGHTING","Distribution Volumetric Rate",null,null,null,null,null,"$/kW",15.6152]
["STREET LIGHTING","Low Voltage Service Rate",null,null,null,null,null,"$/kW",0.93300000000000005]
["STREET LIGHTING","Retail Transmission Rate - Network Service Rate",null,null,null,null,null,"$/kW",1.7211000000000001]
["STREET LIGHTING","Retail Transmission Rate - Line and Transformation Connection Service Rate",null,null,null,null,null,"$/kW",1.1929000000000001]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING"]
["STREET LIGHTING","MONTHLY RATES AND CHARGES - Regulatory Component"]
["STREET LIGHTING"]
["STREET LIGHTING","Wholesale Market Service Rate",null,null,null,null,null,"$/kWh",4.4000000000000003E-3]
["STREET LIGHTING","Rural or Remote Electricity Rate Protection Charge (RRRP)",null,null,null,null,null,"$/kWh",1.2999999999999999E-3]
["STREET LIGHTING","Standard Supply Service - Administrative Charge (if applicable)",null,null,null,null,null,"$",0.25]
["STREET LIGHTING"]
[]
[]
["microFIT","microFIT Service Classification"]
["microFIT"]
["microFIT","This classification applies to an electricity generation facility contracted under the Ontario Power Authority's microFIT prgram and connected to the distributor's distribution system.  Further servicing details are available in the distributor's Conditions of Service."]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT","APPLICATION"]
["microFIT"]
["microFIT","The application of these rates and charges shall be in accordance with the Licence of the Distributor and any Code or Order of the Board, and amendments thereto as approved by the Board, which may be applicable to the administration of this schedule."]
["microFIT"]
["microFIT"]
["microFIT","No rates and charges for the distribution of electricity and charges to meet the costs of any work or service done or furnished for the purpose of the distribution of electricityshall be made except as prmitted by this schedule, unless required by the Distributor's Licence or a Code or Order of the Board, and amendments thereto as approved by the Board, or as specified herein."]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT","Unless specifically noted, this schedule does not contain any charges for the electricity commodity, be it under the Regulated Price Plan, a contract with a retailer or the wholesale market price, as applicable.  In addition, the charges in the MONTHLY RATES AND CHARGES - Regulatory Component of this schedule fo not apply to a customer that is an embedded wholesale market participant."]
["microFIT"]
["microFIT"]
["microFIT","It should be noted that this schedule does not list any charges, assessments or credits that are required by law to be invoiced by a distributor and that are not subject to Board approval, such as Debt Retirement Charge, the Global Adjustment, the Ontario Clean Energy Benefit and the HST."]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT","MONTHLY RATES AND CHARGES - Delivery Component      (If applicable, Effective Date MUST be included in rate description)"]
["microFIT","Service Charge",null,null,null,null,null,"$",5.4]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT"]
["microFIT"]

{"sheet":"6. hidden","index":5,"n_rows":5,"n_cols":15,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,10,1,10],[0,12,1,12],[0,4,1,4],[0,5,1,5],[0,6,1,6],[0,7,1,7],[0,8,1,8],[0,9,1,9],[0,11,1,11]]}
[null,null,null,null,"Billed kWh for Non-RPP Customers","Estimated kW for Non-RPP Customers","Distribution Revenue 1","1590 Recovery Share Proportion*","1595 Recovery Share Proportion (2008) 2","1595 Recovery Share Proportion (2009) 2","1595 Recovery Share Proportion (2010) 2","1595 Recovery Share Proportion (2011) 2","1568 LRAM Variance Account Class Allocation"]
["Rate Class","Unit","Metered kWh","Metered kW"]
["RESIDENTIAL","$/kWh",0,0,0,null,0,0,0,0,0,0,0,0,0]
["STREET LIGHTING","$/kW",0,0,0,null,0,0,0,0,0,0,0,0,0]
["STANDBY POWER",0,0,0,0,null,0,0,0,0,0,0,0,0,0]

{"sheet":"4. Growth Factor - NUM_CALC1","index":6,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[14,6,14,8],[14,2,14,4],[12,0,12,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$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 2019 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":"2019 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,103931741.84820433,0,null,108.56,6.3899999999999998E-2,0]
["RESIDENTIAL R2","$/kW",37.282220262380214,85867986.524168611,196648.09194709637,null,1112.25,0,18.982700000000001]
["SEASONAL CUSTOMERS","$/kWh",2960.1858518389645,5439364.9283407871,0,null,58.75,0.17030000000000001,0]
["STREET LIGHTING","$/kWh",1117.0833333333333,595435.11416171514,0,null,1.37,0.32790000000000002,0]

{"sheet":"5. Growth Factor - NUM_CALC2","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":"IF('1. Information Sheet'!F26=\"COS\", \"Calculation of \" & '1. Information Sheet'!K26 & \" Revenue Requirement.  No input required.\", \"Calculation of pro forma \" & '1. Information Sheet'!F34 & \" Revenues.  No input required.\")","v":"Calculation of pro forma 2019 Revenues.  No input required."}]
[]
[null,null,{"$f":"'4. Growth Factor - NUM_CALC1'!C15","v":"2019 Board-Approved Distribution Demand"},null,null,null,{"$f":"'4. 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"]
["Total",null,{"$f":"SUM(C15:C16)","v":0},0,0,null,"D","E","F",null,{"$f":"SUM(K15:K16)","v":0},0,0,0,null,"K = G / J","L = H / J","M = I / J",{"$f":"SUM(S15:S16)","v":0}]
["RESIDENTIAL R1",null,9112.8451064303372,103931741.84820433,0,null,108.56,6.3899999999999998E-2,0,null,{"$f":"G17*C17*12","v":11871485.577048928},{"$f":"H17*D17","v":6641238.3041002564},0,{"$f":"SUM(K17,L17,M17)","v":18512723.881149184},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.71284749812583104}]
["RESIDENTIAL R2",null,37.282220262380214,85867986.524168611,196648.09194709637,null,1112.25,0,18.982700000000001,null,{"$f":"G18*C18*12","v":497605.79384198872},0,{"$f":"I18*E18","v":3732911.7350041466},{"$f":"SUM(K18,L18,M18)","v":4230517.5288461354},null,{"$f":"IF(ISERROR(K18/N18),0,ROUND(K18/N18,3))","v":0.11799999999999999},{"$f":"IF(ISERROR(L18/N18),0,ROUND(L18/N18,3))","v":0},{"$f":"IF(ISERROR(M18/N18),0,ROUND(M18/N18,3))","v":0.88200000000000001},{"$f":"N18/N21","v":0.1628995201125551}]
["SEASONAL CUSTOMERS",null,2960.1858518389645,5439364.9283407871,0,null,58.75,0.17030000000000001,0,null,{"$f":"G19*C19*12","v":2086931.0255464697},{"$f":"H19*D19","v":926323.84729643608},0,{"$f":"SUM(K19,L19,M19)","v":3013254.872842906},null,{"$f":"IF(ISERROR(K19/N19),0,ROUND(K19/N19,3))","v":0.69299999999999995},{"$f":"IF(ISERROR(L19/N19),0,ROUND(L19/N19,3))","v":0.307},{"$f":"IF(ISERROR(M19/N19),0,ROUND(M19/N19,3))","v":0},{"$f":"N19/N21","v":0.11602783097244561}]
["STREET LIGHTING",null,1117.0833333333333,595435.11416171514,0,null,1.37,0.32790000000000002,0,null,{"$f":"G20*C20*12","v":18364.849999999999},{"$f":"H20*D20","v":195243.17393362641},0,{"$f":"SUM(K20,L20,M20)","v":213608.02393362642},null,{"$f":"IF(ISERROR(K20/N20),0,ROUND(K20/N20,3))","v":8.5999999999999993E-2},{"$f":"IF(ISERROR(L20/N20),0,ROUND(L20/N20,3))","v":0.91400000000000003},{"$f":"IF(ISERROR(M20/N20),0,ROUND(M20/N20,3))","v":0},{"$f":"N20/N21","v":8.2251507891682556E-3}]
["Total",null,{"$f":"SUM(C17:C20)","v":13227.396511865018},{"$f":"SUM(D17:D20)","v":195834528.41487545},{"$f":"SUM(E17:E20)","v":196648.09194709637},null,null,null,null,null,{"$f":"SUM(K17:K20)","v":14474387.246437384},{"$f":"SUM(L17:L20)","v":7762805.3253303189},{"$f":"SUM(M17:M20)","v":3732911.7350041466},{"$f":"SUM(N17:N20)","v":25970104.306771852},null,null,null,null,{"$f":"SUM(S17:S20)","v":1}]

{"sheet":"9. STS - Billing Det & Rate HID","index":8,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Shared Tax Savings"]
[{"$f":"\"Enter your \" & '1. Information Sheet'!F36 & \" Board-Approved Billing Determinents into columns B, C and D.\"","v":"Enter your EB-2019-0019 Board-Approved Billing Determinents into columns B, C and D."}]
[]
[]
[]
["Rate Class","Units","Re-based \nBilled Customers or Connections","Re-based Billed kWh","Re-based Billed kW (if applicable)",null,{"$f":" '1. Information Sheet'!F36 &\" \nBase Monthly \nService Charge\"","v":"EB-2019-0019 \nBase Monthly \nService Charge"},{"$f":" '1. Information Sheet'!F36 &\" \nBase Distribution Volumetric Rate kWh\"","v":"EB-2019-0019 \nBase Distribution Volumetric Rate kWh"},{"$f":" '1. Information Sheet'!F36 &\" \nBase Distribution Volumetric Rate kW\"","v":"EB-2019-0019 \nBase Distribution Volumetric Rate kW"}]
["RESIDENTIAL R1","$/kWh",9112.8451064303372,103931741.84820433,0,null,108.56,6.3899999999999998E-2,0]
["RESIDENTIAL R2","$/kW",37.282220262380214,85867986.524168611,196648.09194709637,null,1111.5999999999999,0,18.971800000000002]
["SEASONAL CUSTOMERS","$/kWh",2960.1858518389645,5439364.9283407871,0,null,54.75,0.19639999999999999,0]
["STREET LIGHTING","$/kWh",1117.0833333333333,595435.11416171514,0,null,1.39,0.33160000000000001,0]

{"sheet":"6. Rev_Requ_Check","index":9,"n_rows":69,"n_cols":6,"rows_kept":69,"cut":false,"hidden":false,"merged":[[7,2,7,5]]}
[]
[]
[]
[]
[]
[]
[]
["Applicants Rate Base",null,{"$f":"IF('1. Information Sheet'!F26=\"COS\",CONCATENATE('1. Information Sheet'!K26,\" Test Year COS Rebasing\"),CONCATENATE(\"Last COS Rebasing: \",'1. Information Sheet'!F34))","v":"Last COS Rebasing: 2019"}]
["Average Net Fixed Assets"]
["Gross Fixed Assets - Re-based Opening",null,192209609.67000002,"A"]
["Add: CWIP Re-based Opening",null,1856895.4499999993,"B"]
["Re-based Capital Additions",null,8485738.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":200695347.73000002},"G"]
["Average Gross Fixed Assets",null,null,null,{"$f":"(C10+C16)/2","v":196452478.70000002},"H = ( A + G ) / 2"]
[]
["Accumulated Depreciation - Re-based Opening",null,76945669.36999996,"I"]
["Re-based Depreciation Expense",null,4497643,"J"]
["Re-based Disposals",null,0,"K"]
["Re-based Retirements",null,0,"L"]
["Accumulated Depreciation - Re-based Closing",null,{"$f":"SUM(C19:C22)","v":81443312.36999996},"M"]
["Average Accumulated Depreciation",null,null,null,{"$f":"SUM(C19,C23)/2","v":79194490.86999996},"N =  ( I + M ) / 2"]
[]
["Average Net Fixed Assets ",null,null,null,{"$f":"E17-E24","v":117257987.83000006},"O = H - N"]
[]
["Working Capital Allowance"]
["Working Capital Allowance Base",null,34872666.713494644,"P"]
["Working Capital Allowance Rate",null,7.4999999999999997E-2,"Q"]
["Working Capital Allowance",null,null,null,{"$f":"C29*C30","v":2615450.003512098},"R = P * Q"]
[]
["Rate Base",null,null,null,{"$f":"SUM(E26,E31)","v":119873437.83351216},"S =  O + R"]
[]
["Return on Rate Base"]
["Deemed ShortTerm Debt %",null,0.04,"T",{"$f":"E33*C36","v":4794937.5133404862},"W = S * T"]
["Deemed Long Term Debt %",null,0.56000000000000005,"U",{"$f":"E33*C37","v":67129125.186766818},"X = S * U"]
["Deemed Equity %",null,{"$f":"1-C36-C37","v":0.39999999999999991},"V",{"$f":"E33*C38","v":47949375.133404851},"Y = S * V"]
[]
["Short Term Interest",null,2.8199999999999999E-2,"Z",{"$f":"E36*C40","v":135217.23787620172},"AC = W * Z"]
["Long Term Interest",null,4.9500000000000002E-2,"AA",{"$f":"E37*C41","v":3322891.6967449575},"AD = X * AA"]
["Return on Equity",null,8.9800000000000005E-2,"AB",{"$f":"E38*C42","v":4305853.8869797559},"AE = Y * AB"]
["Return on Rate Base",null,null,null,{"$f":"SUM(E40:E42)","v":7763962.8216009149},"AF = AC + AD + AE"]
[]
["Distribution Expenses"]
["OM&A Expenses",null,13677187.390000002,"AG"]
["Amortization",null,4043341,"AH"]
["Ontario Capital Tax",null,0,"AI"]
["Grossed Up Taxes/PILs",null,333974.07192090555,"AJ"]
["Low Voltage",null,0,"AK"]
["Transformer Allowance",null,87159.166300354744,"AL"]
["Property Tax",null,118599.96,"AM"]
[null,null,null,"AN"]
[null,null,null,"AO"]
[null,null,null,null,{"$f":"SUM(C46:C54)","v":18260261.588221263},"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,535454.6,"AT",{"$f":"SUM(C57:C60)","v":-51889.240000000107},"AU = SUM ( AQ : AT )"]
[]
["Revenue Requirement from Distribution Rates",null,null,null,{"$f":"SUM(E60,E55,E43)","v":25972335.169822179},"AV = AF + AP + AU"]
[]
["Rate Classes Revenue"]
["Rate Classes Revenue - Total  (Sheet 5)",null,null,null,25970104.306771852,"AW"]
[]
["Difference",null,null,null,{"$f":"E62-E65","v":2230.863050326705},"AZ = AV - AW"]
[]
["Difference (Percentage - should be less than ±1%)",null,null,null,{"$f":"IF(ISERROR(E67/E65),0,E67/E65)","v":8.590119716018987E-5},"BA = AZ / AW"]

{"sheet":"7. Growth Factor - DEN_CALC","index":10,"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 2018 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":"2018 Actual Distribution Demand"},null,null,null,{"$f":"'4. 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"]
["Total",null,{"$f":"SUM(C15:C16)","v":0},{"$f":"SUM(D15:D16)","v":0},{"$f":"SUM(E15:E16)","v":0},null,"D","E","F",null,{"$f":"SUM(K15:K16)","v":0},{"$f":"SUM(L15:L16)","v":0},{"$f":"SUM(M15:M16)","v":0},{"$f":"SUM(N15:N16)","v":0},null,"K = G / Jtotal","L = H / Jtotal","M = I / Jtotal",{"$f":"SUM(S15:S16)","v":0}]
["RESIDENTIAL R1",null,8677.8043048205,99269363.071951643,0,null,108.56,6.3899999999999998E-2,0,null,{"$f":"G17*C17*12","v":11304749.223975763},{"$f":"H17*D17","v":6343312.3002977101},0,{"$f":"SUM(K17,L17,M17)","v":17648061.524273474},null,{"$f":"IF(ISERROR(K17/N21),0,ROUND(K17/N21,3))","v":0.438},{"$f":"IF(ISERROR(L17/N21),0,ROUND(L17/N21,3))","v":0.246},{"$f":"IF(ISERROR(M17/N21),0,ROUND(M17/N21,3))","v":0},{"$f":"N17/N21","v":0.68419125771058442}]
["RESIDENTIAL R2",null,39.009207316089025,99385190.083535731,229528.62807612104,null,1112.25,0,18.982700000000001,null,{"$f":"G18*C18*12","v":520655.89004784019},0,4357073.088180583,{"$f":"SUM(K18,L18,M18)","v":4877728.9782284228},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.16900000000000001},{"$f":"N18/N21","v":0.18910289494374691}]
["SEASONAL CUSTOMERS",null,3017.7417203975979,5500303.158293183,0,null,58.75,0.17030000000000001,0,null,{"$f":"G19*C19*12","v":2127507.9128803066},936701.62785732909,0,{"$f":"SUM(K19,L19,M19)","v":3064209.5407376355},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.5999999999999997E-2},{"$f":"IF(ISERROR(M19/N21),0,ROUND(M19/N21,3))","v":0},{"$f":"N19/N21","v":0.11879522159884146}]
["STREET LIGHTING",null,1067.0833333333333,568783.78491911688,0,null,1.37,0.32790000000000002,0,null,{"$f":"G20*C20*12","v":17542.849999999999},186504.20307497843,0,{"$f":"SUM(K20,L20,M20)","v":204047.05307497844},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.9106257468271792E-3}]
["Total",null,{"$f":"SUM(C17:C20)","v":12801.638565867521},{"$f":"SUM(D17:D20)","v":204723640.09869966},{"$f":"SUM(E17:E20)","v":229528.62807612104},null,null,null,null,null,{"$f":"SUM(K17:K20)","v":13970455.87690391},{"$f":"SUM(L17:L20)","v":7466518.1312300181},{"$f":"SUM(M17:M20)","v":4357073.088180583},{"$f":"SUM(N17:N20)","v":25794047.096314512},null,null,null,null,{"$f":"SUM(S17:S20)","v":1}]

{"sheet":"7. Load Actual - HID","index":11,"n_rows":20,"n_cols":19,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"Calculation of Most Recent Revenue.  Enter values into green shaded cells (\" & '1. Information Sheet'!#REF! & \")\"","v":{"$error":"#REF!"}}]
[]
[]
["Rate Class",null,"Billed Customers or Connections","Billed kWh","Billed kW",null,"Base Service Charge","Base Distribution Volumetric Rate kWh","Base 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 = A * D *12","H = B * E","I = C * F","J = G + H + I",null,"K = G / J","L = H / J","M = I / J","N = J / R"]
["RESIDENTIAL R1",null,8677.8043048205,99269363.071951643,0]
["RESIDENTIAL R2",null,39.009207316089025,99385190.083535731,229528.62807612104]
["SEASONAL CUSTOMERS",null,3017.7417203975979,5500303.158293183,0]
["STREET LIGHTING",null,1067.0833333333333,568783.78491911688,0]

{"sheet":"8. Revenue Proportions","index":12,"n_rows":21,"n_cols":19,"rows_kept":21,"cut":false,"hidden":false,"merged":[[12,0,12,6],[13,6,13,8],[13,2,13,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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":"'4. Growth Factor - NUM_CALC1'!C15","v":"2019 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"]
["Total",null,"A","B","C",null,"D","E","F",null,{"$f":"SUM(K15:K16)","v":0},0,0,0,null,"L = G / Jtotal","M = H / Jtotal","N = I / Jtotal",{"$f":"SUM(S15:S16)","v":0}]
["RESIDENTIAL R1",null,108.56,6.3899999999999998E-2,0,null,9112.8451064303372,103931741.84820433,0,null,{"$f":"G17*C17*12","v":11871485.577048928},{"$f":"H17*D17","v":6641238.3041002564},0,{"$f":"SUM(K17,L17,M17)","v":18512723.881149184},null,{"$f":"IF(ISERROR(K17/N21),0,K17/N21)","v":0.45712121279210149},{"$f":"IF(ISERROR(L17/N21),0,L17/N21)","v":0.25572628533372954},{"$f":"IF(ISERROR(M17/N21),0,M17/N21)","v":0},{"$f":"N17/N21","v":0.71284749812583104}]
["RESIDENTIAL R2",null,1112.25,0,18.982700000000001,null,37.282220262380214,85867986.524168611,196648.09194709637,null,{"$f":"G18*C18*12","v":497605.79384198872},0,3732911.7350041466,{"$f":"SUM(K18,L18,M18)","v":4230517.5288461354},null,{"$f":"IF(ISERROR(K18/N21),0,K18/N21)","v":1.9160716028092162E-2},{"$f":"IF(ISERROR(L18/N21),0,L18/N21)","v":0},{"$f":"IF(ISERROR(M18/N21),0,M18/N21)","v":0.14373880408446293},{"$f":"N18/N21","v":0.1628995201125551}]
["SEASONAL CUSTOMERS",null,58.75,0.17030000000000001,0,null,2960.1858518389645,5439364.9283407871,0,null,{"$f":"G19*C19*12","v":2086931.0255464697},926323.84729643608,0,{"$f":"SUM(K19,L19,M19)","v":3013254.872842906},null,{"$f":"IF(ISERROR(K19/N21),0,K19/N21)","v":8.0358977418596295E-2},{"$f":"IF(ISERROR(L19/N21),0,L19/N21)","v":3.5668853553849293E-2},{"$f":"IF(ISERROR(M19/N21),0,M19/N21)","v":0},{"$f":"N19/N21","v":0.11602783097244561}]
["STREET LIGHTING",null,1.37,0.32790000000000002,0,null,1117.0833333333333,595435.11416171514,0,null,{"$f":"G20*C20*12","v":18364.849999999999},195243.17393362641,0,{"$f":"SUM(K20,L20,M20)","v":213608.02393362642},null,{"$f":"IF(ISERROR(K20/N21),0,K20/N21)","v":7.071534939969902E-4},{"$f":"IF(ISERROR(L20/N21),0,L20/N21)","v":7.5179972951712653E-3},{"$f":"IF(ISERROR(M20/N21),0,M20/N21)","v":0},{"$f":"N20/N21","v":8.2251507891682556E-3}]
["Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K17:K20)","v":14474387.246437384},{"$f":"SUM(L17:L20)","v":7762805.3253303189},{"$f":"SUM(M17:M20)","v":3732911.7350041466},{"$f":"SUM(N17:N20)","v":25970104.306771852},null,null,null,null,{"$f":"SUM(S17:S20)","v":1}]

{"sheet":"8. Current Revenue - HID","index":13,"n_rows":20,"n_cols":19,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"Calculation of Most Recent Revenue.  Enter values into green shaded cells (\" & '1. Information Sheet'!#REF! & \")\"","v":{"$error":"#REF!"}}]
[]
[]
["Rate Class",null,"Current Base Service Charge","Current Base Distribution Volumetric Rate kWh","Current Base 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 = A * D *12","H = B * E","I = C * F","J = G + H + I",null,"K = G / J","L = H / J","M = I / J","N = J / R"]
["RESIDENTIAL R1",null,108.56,6.3899999999999998E-2,0]
["RESIDENTIAL R2",null,1111.5999999999999,0,18.971800000000002]
["SEASONAL CUSTOMERS",null,54.75,0.19639999999999999,0]
["STREET LIGHTING",null,1.39,0.33160000000000001,0]

{"sheet":"9. Threshold Test","index":14,"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'!K26,'1. Information Sheet'!F34)","v":2019}]
[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'!F40-0.3%","v":1.2E-2}]
[null,null,"Growth Factor Calculation"]
[null,null,{"$f":"'1. Information Sheet'!F48","v":"Revenues Based on 2019 Board-Approved Distribution Demand"},null,25970104.306771852]
[null,null,{"$f":"'1. Information Sheet'!F49","v":"Revenues Based on 2018 Actual Distribution Demand"},null,25794047.096314512]
[null,null,"Growth Factor",null,{"$f":"IF(ISERROR(E18/E19-1),0,(E18/E19-1)/('1. Information Sheet'!I48-'1. Information Sheet'!I49))","v":6.8254977514752291E-3}]
[null,null,"Dead Band",null,0.1]
[null,null,"Average Net Fixed Assets"]
[null,null,"Gross Fixed Assets Opening",null,{"$f":"'6. Rev_Requ_Check'!C10","v":192209609.67000002}]
[null,null,"Add: CWIP Opening",null,{"$f":"'6. Rev_Requ_Check'!C11","v":1856895.4499999993}]
[null,null,"Capital Additions",null,{"$f":"'6. Rev_Requ_Check'!C12","v":8485738.0599999987}]
[null,null,"Capital Disposals",null,{"$f":"'6. Rev_Requ_Check'!C13","v":0}]
[null,null,"Capital Retirements",null,{"$f":"'6. Rev_Requ_Check'!C14","v":0}]
[null,null,"Deduct: CWIP Closing",null,{"$f":"'6. Rev_Requ_Check'!C15","v":-1856895.45}]
[null,null,"Gross Fixed Assets - Closing",null,{"$f":"'6. Rev_Requ_Check'!C16","v":200695347.73000002}]
[]
[null,null,"Average Gross Fixed Assets",null,{"$f":"(E23+E29)/2","v":196452478.70000002}]
[]
[null,null,"Accumulated Depreciation - Opening",null,{"$f":"'6. Rev_Requ_Check'!C19","v":76945669.36999996}]
[null,null,"Depreciation Expense",null,{"$f":"'6. Rev_Requ_Check'!C20","v":4497643}]
[null,null,"Disposals",null,{"$f":"'6. Rev_Requ_Check'!C21","v":0}]
[null,null,"Retirements",null,{"$f":"'6. Rev_Requ_Check'!C22","v":0}]
[null,null,"Accumulated Depreciation - Closing",null,{"$f":"'6. Rev_Requ_Check'!C23","v":81443312.36999996}]
[]
[null,null,"Average Accumulated Depreciation",null,{"$f":"(E33+E37)/2","v":79194490.86999996}]
[]
[null,null,"Average Net Fixed Assets ",null,{"$f":"E31-E39","v":117257987.83000006}]
[]
[]
[null,null,"Working Capital Allowance"]
[null,null,"Working Capital Allowance Base",null,{"$f":"'6. Rev_Requ_Check'!C29","v":34872666.713494644}]
[null,null,"Working Capital Allowance Rate",null,{"$f":"'6. Rev_Requ_Check'!C30","v":7.4999999999999997E-2}]
[null,null,"Working Capital Allowance",null,{"$f":"E45*E46","v":2615450.003512098}]
[]
[null,null,"Rate Base",null,{"$f":"E41+E47","v":119873437.83351216}]
[]
[null,null,"Depreciation",null,{"$f":"E34","v":4497643}]
[]
[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 2020"},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":1.6039296104562146}]
[null,null,{"$f":"CONCATENATE(\"    Price Cap IR Year \",E13+2)","v":"    Price Cap IR Year 2021"},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":1.6134576110498369}]
[null,null,{"$f":"CONCATENATE(\"    Price Cap IR Year \",E13+3)","v":"    Price Cap IR Year 2022"},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":1.6231657613973698}]
[null,null,{"$f":"CONCATENATE(\"    Price Cap IR Year \",E13+4)","v":"    Price Cap IR Year 2023"},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":1.6330574676629415}]
[null,null,{"$f":"CONCATENATE(\"    Price Cap IR Year \",E13+5)","v":"    Price Cap IR Year 2024"},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":1.6431362004124006}]
[null,null,{"$f":"CONCATENATE(\"    Price Cap IR Year \",E13+6)","v":"    Price Cap IR Year 2025"},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":1.653405495830985}]
[null,null,{"$f":"CONCATENATE(\"    Price Cap IR Year \",E13+7)","v":"    Price Cap IR Year 2026"},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":1.6638689569640144}]
[null,null,{"$f":"CONCATENATE(\"    Price Cap IR Year \",E13+8)","v":"    Price Cap IR Year 2027"},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":1.6745302549810419}]
[null,null,{"$f":"CONCATENATE(\"    Price Cap IR Year \",E13+9)","v":"    Price Cap IR Year 2028"},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":1.685393130463904}]
[null,null,{"$f":"CONCATENATE(\"    Price Cap IR Year \",E13+10)","v":"    Price Cap IR Year 2029"},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":1.69646139471913}]
[]
[null,null,"Threshold CAPEX"]
[null,null,{"$f":"C54","v":"    Price Cap IR Year 2020"},null,{"$f":"IF(ISERROR(d*E54), \"\", d*E54)","v":7213902.7849611202}]
[null,null,{"$f":"C55","v":"    Price Cap IR Year 2021"},null,7256756.3301350214]
[null,null,{"$f":"C56","v":"    Price Cap IR Year 2022"},null,7300420.1245885501]
[null,null,{"$f":"C57","v":"    Price Cap IR Year 2023"},null,7344909.4880319554]
[null,null,{"$f":"C58","v":"    Price Cap IR Year 2024"},null,7390240.0298314309]
[null,null,"    Price Cap IR Year 2025",null,7436427.6544857584]
[null,null,"    Price Cap IR Year 2026",null,7483488.5672065001]
[null,null,"    Price Cap IR Year 2027",null,7531439.2796036983]
[null,null,"    Price Cap IR Year 2028",null,7580296.6154790651]
[null,null,"    Price Cap IR Year 2029",null,7630077.716728732]
[]
[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":"24. hidden","index":15,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Rate Class","MFC Adjustment from R/C Model","DVR Adjustment from R/C Model"]

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

{"sheet":"10a. Proposed ACM Projects","index":17,"n_rows":51,"n_cols":13,"rows_kept":51,"cut":false,"hidden":true,"merged":[[12,2,12,5],[25,12,26,12],[24,2,24,5],[12,6,12,11],[24,6,24,11]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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":2021},{"$f":"B15+1","v":2022},{"$f":"C15+1","v":2023},{"$f":"D15+1","v":2024},{"$f":"E15+1","v":2025},{"$f":"F15+1","v":2026},2027,2028,2029,{"$f":"J15+1","v":2030},{"$f":"K15+1","v":2031}]
["Distribution System Plan CAPEX",8485738.5600000024,14779288.006666396,21532503.853332791,8938847.2199991848,6980595.58666558]
[]
["Materiality Threshold",null,{"$f":"IF('9. Threshold Test'!$E$66=\"\", 0, '9. Threshold Test'!$E$66)","v":7213902.7849611202},{"$f":"IF('9. Threshold Test'!$E$67=\"\", 0, '9. Threshold Test'!$E$67)","v":7256756.3301350214},{"$f":"IF('9. Threshold Test'!$E$68=\"\", 0, '9. Threshold Test'!$E$68)","v":7300420.1245885501},{"$f":"IF('9. Threshold Test'!$E$69=\"\", 0, '9. Threshold Test'!$E$69)","v":7344909.4880319554},{"$f":"IF('9. Threshold Test'!$E$70=\"\", 0, '9. Threshold Test'!$E$70)","v":7390240.0298314309},{"$f":"IF('9. Threshold Test'!$E$71=\"\", 0, '9. Threshold Test'!$E$71)","v":7436427.6544857584},{"$f":"IF('9. Threshold Test'!$E$72=\"\", 0, '9. Threshold Test'!$E$72)","v":7483488.5672065001},{"$f":"IF('9. Threshold Test'!$E$73=\"\", 0, '9. Threshold Test'!$E$73)","v":7531439.2796036983},{"$f":"IF('9. Threshold Test'!$E$74=\"\", 0, '9. Threshold Test'!$E$74)","v":7580296.6154790651},{"$f":"IF('9. Threshold Test'!$E$75=\"\", 0, '9. Threshold Test'!$E$75)","v":7630077.716728732}]
[]
["Maximum Eligible Incremental Capital (Forecasted CAPEX less Threshold)",null,{"$f":"MAX(0,C16-C18)","v":7565385.2217052756},{"$f":"MAX(0,D16-D18)","v":14275747.52319777},{"$f":"MAX(0,E16-E18)","v":1638427.0954106348},{"$f":"MAX(0,F16-F18)","v":0},{"$f":"MAX(0,G16-G18)","v":0},0,0,0,{"$f":"MAX(0,K16-K18)","v":0},0]
[]
["Maximum Eligible Incremental Capital (Forecasted Capex less Threshold)",null,{"$f":"IF(C18>C16,0,C16-C18)","v":7565385.2217052756},{"$f":"IF(D18>D16,0,D16-D18)","v":14275747.52319777},{"$f":"IF(E18>E16,0,E16-E18)","v":1638427.0954106348},{"$f":"IF(F18>F16,0,F16-F18)","v":0},{"$f":"IF(G18>G16,0,G16-G18)","v":0},0,0,0,{"$f":"IF(K18>K16,0,K16-K18)","v":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":2021},{"$f":"C15","v":2022},{"$f":"D15","v":2023},{"$f":"E15","v":2024},{"$f":"F15","v":2025},{"$f":"G15","v":2026},2027,2028,2029,{"$f":"K15","v":2030},2031]
["Echo River TS - Add Second Transformer",null,7500000,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C28:F28)","v":7500000}]
["Sault Facility Project",null,null,14118000,null,null,null,null,null,null,null,null,14118000]
[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":7500000},{"$f":"SUM(D28:D47)","v":14118000},{"$f":"SUM(E28:E47)","v":0},{"$f":"SUM(F28:F47)","v":0},{"$f":"SUM(G28:G47)","v":0},0,0,0,0,0]
[]
["Maximum Allowed Incremental Capital",null,{"$f":"MIN(C49,C22)","v":7500000},14118000,0,0,0,0,0,0,{"$f":"MIN(K49,K22)","v":0},0]

{"sheet":"10b. Proposed ACM ICM Projects","index":18,"n_rows":156,"n_cols":15,"rows_kept":156,"cut":false,"hidden":false,"merged":[[95,6,95,8],[95,9,95,11],[95,12,95,14],[83,2,83,14],[94,3,94,5],[94,6,94,8],[94,9,94,11],[94,12,94,14],[88,1,91,1],[85,3,85,14],[48,3,48,14],[12,3,12,6],[51,1,54,1],[57,3,57,5],[57,6,57,8],[57,9,57,11],[57,12,57,14],[49,3,49,5],[49,6,49,8],[49,9,49,11],[49,12,49,14],[50,3,50,5],[50,6,50,8],[50,9,50,11],[125,1,128,1],[50,12,50,14],[123,3,123,5],[123,6,123,8],[123,9,123,11],[123,12,123,14],[122,9,122,11],[122,12,122,14],[122,3,122,8],[120,2,120,8],[120,9,120,11],[120,12,120,14],[121,9,121,11],[121,12,121,14],[58,3,58,5],[58,6,58,8],[132,3,132,5],[132,6,132,8],[132,9,132,11],[132,12,132,14],[124,3,124,5],[124,6,124,8],[124,9,124,11],[124,12,124,14],[12,7,12,12],[131,3,131,5],[131,6,131,8],[131,9,131,11],[131,12,131,14],[58,9,58,11],[58,12,58,14],[87,3,87,5],[87,6,87,8],[87,9,87,11],[87,12,87,14],[86,3,86,5],[86,6,86,8],[86,9,86,11],[86,12,86,14],[95,3,95,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Identify ALL Proposed ACM projects and related CAPEX costs in the relevant years"]
[]
[null,null,"Cost of Service","Price Cap IR",null,null,null,"Price Cap IR (Deferred Rebasing)"]
[null,null,"Test Year","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10"]
[null,null,{"$f":"'1. Information Sheet'!F34","v":2019},{"$f":"C15+1","v":2020},{"$f":"D15+1","v":2021},{"$f":"E15+1","v":2022},{"$f":"F15+1","v":2023},{"$f":"G15+1","v":2024},2025,2026,2027,{"$f":"K15+1","v":2028},{"$f":"L15+1","v":2029}]
["Distribution System Plan CAPEX",null,8485738.5600000024,{"$f":"14779288.0066664+D25","v":14779288.0066664},{"$f":"21532503.8533328-D25","v":21532503.853332799},8938847.2199991848,6980595.58666558]
[]
["Materiality Threshold",null,null,{"$f":"IF('9. Threshold Test'!$E$66=\"\", 0, '9. Threshold Test'!$E$66)","v":7213902.7849611202},{"$f":"IF('9. Threshold Test'!$E$67=\"\", 0, '9. Threshold Test'!$E$67)","v":7256756.3301350214},{"$f":"IF('9. Threshold Test'!$E$68=\"\", 0, '9. Threshold Test'!$E$68)","v":7300420.1245885501},{"$f":"IF('9. Threshold Test'!$E$69=\"\", 0, '9. Threshold Test'!$E$69)","v":7344909.4880319554},{"$f":"IF('9. Threshold Test'!$E$70=\"\", 0, '9. Threshold Test'!$E$70)","v":7390240.0298314309},{"$f":"IF('9. Threshold Test'!$E$71=\"\", 0, '9. Threshold Test'!$E$71)","v":7436427.6544857584},{"$f":"IF('9. Threshold Test'!$E$72=\"\", 0, '9. Threshold Test'!$E$72)","v":7483488.5672065001},{"$f":"IF('9. Threshold Test'!$E$73=\"\", 0, '9. Threshold Test'!$E$73)","v":7531439.2796036983},{"$f":"IF('9. Threshold Test'!$E$73=\"\", 0, '9. Threshold Test'!$E$73)","v":7531439.2796036983},{"$f":"IF('9. Threshold Test'!$E$73=\"\", 0, '9. Threshold Test'!$E$73)","v":7531439.2796036983}]
[]
["Maximum Eligible Incremental Capital (Forecasted Capex less Threshold)",null,0,{"$f":"IF(D18>D16,0,D16-D18)","v":7565385.2217052793},{"$f":"IF(E18>E16,0,E16-E18)","v":14275747.523197778},{"$f":"IF(F18>F16,0,F16-F18)","v":1638427.0954106348},{"$f":"IF(G18>G16,0,G16-G18)","v":0},{"$f":"IF(H18>H16,0,H16-H18)","v":0},0,0,0,{"$f":"IF(L18>L16,0,L16-L18)","v":0},0]
[]
["Project Descriptions:","Type","Test Year","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Total"]
[null,null,{"$f":"C15","v":2019},{"$f":"D15","v":2020},{"$f":"E15","v":2021},{"$f":"F15","v":2022},{"$f":"G15","v":2023},{"$f":"H15","v":2024},2025,2026,2027,{"$f":"L15","v":2028},2029]
["Echo River TS - Add Second Transformer","Approved ACM",null,7500000,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D24:K24)","v":7500000}]
["Sault Facility Project","Approved ACM",null,null,14118000,null,null,null,null,null,null,null,null,{"$f":"SUM(D25:G25)","v":14118000}]
[null,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,null,0]
[null,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,null,0]
[null,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,null,0]
[null,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,null,0]
[null,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,null,0]
[null,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,null,0]
[null,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,null,0]
[null,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,null,0]
[null,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,null,0]
[]
["Total Cost of ACM/ICM Projects",null,0,{"$f":"SUM(D24:D43)","v":7500000},{"$f":"SUM(E24:E43)","v":14118000},{"$f":"SUM(F24:F43)","v":0},{"$f":"SUM(G24:G43)","v":0},{"$f":"SUM(H24:H43)","v":0},0,0,0,{"$f":"SUM(L24:L43)","v":0},0,{"$f":"SUM(D45:G45)","v":21618000}]
[]
["Maximum Allowed Incremental Capital",null,null,{"$f":"MIN(D45,D20)","v":7500000},{"$f":"MIN(E45,E20)","v":14118000},{"$f":"MIN(F45,F20)","v":0},{"$f":"MIN(G45,G20)","v":0},{"$f":"MIN(H45,H20)","v":0},0,0,0,{"$f":"MIN(L45,L20)","v":0},0,{"$f":"SUM(D47:G47)","v":21618000}]
[]
[null,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":"C15","v":2019},{"$f":"D15","v":2020},null,null,{"$f":"E15","v":2021},null,null,{"$f":"F15","v":2022},null,null,{"$f":"G15","v":2023}]
["Distribution System Plan CAPEX",null,{"$f":"C16","v":8485738.5600000024},{"$f":"D16","v":14779288.0066664},null,null,{"$f":"E16","v":21532503.853332799},null,null,{"$f":"F16","v":8938847.2199991848},null,null,{"$f":"G16","v":6980595.58666558}]
[]
["Materiality Threshold",null,null,{"$f":"D18","v":7213902.7849611202},null,null,{"$f":"E18","v":7256756.3301350214},null,null,{"$f":"F18","v":7300420.1245885501},null,null,{"$f":"G18","v":7344909.4880319554}]
[]
["Maximum Eligible Incremental Capital (Forecasted Capex less Threshold)",null,0,{"$f":"D20","v":7565385.2217052793},null,null,{"$f":"E20","v":14275747.523197778},null,null,{"$f":"F20","v":1638427.0954106348},null,null,{"$f":"G20","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":2019},{"$f":"D51","v":2020},null,null,{"$f":"G51","v":2021},null,null,{"$f":"J51","v":2022},null,null,{"$f":"M51","v":2023}]
["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"]
[{"$f":"IF(OR(A24=\"\", A24=0), \"\", A24)","v":"Echo River TS - Add Second Transformer"},"Approved ACM",null,{"$f":"IF(OR(D24=\"\", D24=0), 0, D24)","v":7500000},{"$f":"0.025*D61","v":187500},{"$f":"D61*0.08","v":600000},{"$f":"IF(OR(E24=\"\", E24=0), 0, E24)","v":0},null,null,{"$f":"IF(OR(F24=\"\", F24=0), 0, F24)","v":0},null,null,{"$f":"IF(OR(G24=\"\", G24=0), 0, G24)","v":0}]
["Sault Facility Project","Approved ACM",null,{"$f":"IF(OR(D25=\"\", D25=0), 0, D25)","v":0},{"$f":"0.02*D62","v":0},{"$f":"D62*0.08","v":0},14118000,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
[]
["Total Cost of ACM/ICM Projects",null,null,{"$f":"SUM(D61:D80)","v":7500000},{"$f":"SUM(E61:E80)","v":187500},600000,14118000,0,0,0,0,0,0,0,0]
[]
[null,null,{"$f":"CONCATENATE(H13,\" (if necessary)\")","v":"Price Cap IR (Deferred Rebasing) (if necessary)"}]
[]
[null,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":"H15","v":2024},null,null,{"$f":"I15","v":2025},null,null,{"$f":"J15","v":2026},null,null,{"$f":"K15","v":2027}]
["Distribution System Plan CAPEX",null,null,{"$f":"H16","v":0},null,null,{"$f":"I16","v":0},null,null,{"$f":"J16","v":0},null,null,{"$f":"K16","v":0}]
[]
["Materiality Threshold",null,null,{"$f":"H18","v":7390240.0298314309},null,null,{"$f":"I18","v":7436427.6544857584},null,null,{"$f":"J18","v":7483488.5672065001},null,null,{"$f":"K18","v":7531439.2796036983}]
[]
["Maximum Eligible Incremental Capital (Forecasted Capex less Threshold)",null,0,{"$f":"H20","v":0},null,null,{"$f":"I20","v":0},null,null,{"$f":"J20","v":0},null,null,{"$f":"K20","v":0}]
[]
[null,null,null,{"$f":"D87","v":"Year 5"},null,null,{"$f":"G87","v":"Year 6"},null,null,{"$f":"J87","v":"Year 7"},null,null,{"$f":"M87","v":"Year 8"}]
[null,null,null,{"$f":"D88","v":2024},null,null,{"$f":"G88","v":2025},null,null,{"$f":"J88","v":2026},null,null,{"$f":"M88","v":2027}]
["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"]
[{"$f":"IF(OR(A61=\"\", A61=0), \"\", A61)","v":"Echo River TS - Add Second Transformer"},{"$f":"IF(OR(B24=\"\", B24=0), \"\", B24)","v":"Approved ACM"},null,{"$f":"IF(OR(H24=\"\", H24=0), 0,H24)","v":0},null,null,{"$f":"IF(OR(I24=\"\", I24=0), 0,I24)","v":0},{"$f":"0.1*G98","v":0},null,{"$f":"IF(OR(J24=\"\", J24=0), 0,J24)","v":0},null,null,{"$f":"IF(OR(K24=\"\", K24=0), 0,K24)","v":0}]
["Sault Facility Project","Approved ACM",null,0,null,null,0,{"$f":"0.1*G99","v":0},null,{"$f":"IF(OR(J25=\"\", J25=0), 0,J25)","v":0},null,null,{"$f":"IF(OR(K25=\"\", K25=0), 0,K25)","v":0}]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
[null,{"$f":"IF(OR(B42=\"\", B42=0), \"\", B42)","v":""},null,{"$f":"IF(OR(H42=\"\", H42=0), 0,H42)","v":0},null,null,{"$f":"IF(OR(I42=\"\", I42=0), 0,I42)","v":0},null,null,0,null,null,0]
[{"$f":"IF(OR(A79=\"\", A79=0), \"\", A79)","v":""},"",null,0,null,null,0,null,null,0,null,null,0]
[]
["Total Cost of ACM/ICM Projects",null,null,{"$f":"SUM(D98:D117)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,{"$f":"C84","v":"Price Cap IR (Deferred Rebasing) (if necessary)"}]
[]
[null,null,null,"Price Cap IR"]
[null,null,null,"Year 9",null,null,"Year 10"]
[null,null,null,{"$f":"L15","v":2028},null,null,{"$f":"M15","v":2029}]
["Distribution System Plan CAPEX",null,null,{"$f":"L16","v":0},null,null,{"$f":"M16","v":0}]
[]
["Materiality Threshold",null,null,{"$f":"L18","v":7531439.2796036983},null,null,{"$f":"M18","v":7531439.2796036983}]
[]
["Maximum Eligible Incremental Capital (Forecasted Capex less Threshold)",null,0,{"$f":"L20","v":0},null,null,{"$f":"M20","v":0}]
[]
[null,null,null,{"$f":"D124","v":"Year 9"},null,null,{"$f":"G124","v":"Year 10"}]
[null,null,null,{"$f":"D125","v":2028},null,null,{"$f":"G125","v":2029}]
["Project Descriptions:","Type",null,"Proposed ACM/ICM","Amortization Expense","CCA","Proposed ACM/ICM","Amortization Expense","CCA"]
[{"$f":"IF(OR(A98=\"\", A98=0), \"\", A98)","v":"Echo River TS - Add Second Transformer"},{"$f":"IF(OR(B61=\"\", B61=0), \"\", B61)","v":"Approved ACM"},null,{"$f":"IF(OR(L24=\"\", L24=0), 0,L24)","v":0},null,null,{"$f":"IF(OR(M24=\"\", M24=0), 0,M24)","v":0}]
["Sault Facility Project","Approved ACM",null,{"$f":"IF(OR(L25=\"\", L25=0), 0,L25)","v":0},null,null,{"$f":"IF(OR(M25=\"\", M25=0), 0,M25)","v":0}]
["","",null,0,null,null,0]
["","",null,0,null,null,0]
["","",null,0,null,null,0]
["","",null,0,null,null,0]
["","",null,0,null,null,0]
["","",null,0,null,null,0]
["","",null,0,null,null,0]
["","",null,0,null,null,0]
["","",null,0,null,null,0]
["","",null,0,null,null,0]
["","",null,0,null,null,0]
["","",null,0,null,null,0]
["","",null,0,null,null,0]
["","",null,0,null,null,0]
["","",null,0,null,null,0]
["","",null,0,null,null,0]
[null,"",null,0,null,null,0]
[{"$f":"IF(OR(A116=\"\", A116=0), \"\", A116)","v":""},"",null,0,null,null,0]
[]
["Total Cost ofACM/ICM Projects",null,null,{"$f":"SUM(D135:D154)","v":0},0,0,0,0,0]

{"sheet":"11. Incremental Capital Adj.","index":19,"n_rows":93,"n_cols":6,"rows_kept":93,"cut":false,"hidden":false,"merged":[[23,2,23,4],[28,1,28,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Incremental Capital Adjustment","Rate Year:",null,{"$f":"'1. Information Sheet'!K26","v":2021}]
[]
[]
[]
[null,"Current Revenue Requirement"]
[]
[null,"Current Revenue Requirement - Total",null,null,{"$f":"'6. Rev_Requ_Check'!E62","v":25972335.169822179},"A"]
[]
[]
[null,"Eligible Incremental Capital for ACM/ICM Recovery"]
[null,null,"Total Claim",null,"Eligible for ACM/ICM"]
[null,null,null,null,"(Prorated Amount)"]
[null,null,"(from Sheet 10b)"]
[null,"Amount of Capital Projects Claimed",{"$f":"IF('1. Information Sheet'!$F$26=\"COS\", 0, IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 1\", '10b. Proposed ACM ICM Projects'!$D$82, IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 2\", '10b. Proposed ACM ICM Projects'!$G$82, IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 3\", '10b. Proposed ACM ICM Projects'!$J$82, IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 4\", '10b. Proposed ACM ICM Projects'!$M$82, IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 5\", '10b. Proposed ACM ICM Projects'!$D$119, IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 6\", '10b. Proposed ACM ICM Projects'!$G$119, IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 7\", '10b. Proposed ACM ICM Projects'!$J$119, IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 8\", '10b. Proposed ACM ICM Projects'!$M$119,  IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 9\", '10b. Proposed ACM ICM Projects'!$D$156, IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 10\", '10b. Proposed ACM ICM Projects'!$G$156, “”)))))))))))","v":14118000},null,{"$f":"IF('1. Information Sheet'!$F$26=\"COS\",0, VLOOKUP(\"Maximum Allowed Incremental Capital\",'10b. Proposed ACM ICM Projects'!$A$14:$M$47,MATCH(\"Year \" & '1. Information Sheet'!$F$28,'10b. Proposed ACM ICM Projects'!$A$14:$M$14,0),FALSE))","v":14118000},"B"]
[null,"Depreciation Expense",{"$f":"IF('1. Information Sheet'!$F$26=\"COS\", 0, IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 1\", '10b. Proposed ACM ICM Projects'!$E$82, IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 2\", '10b. Proposed ACM ICM Projects'!$H$82, IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 3\", '10b. Proposed ACM ICM Projects'!$K$82, IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 4\", '10b. Proposed ACM ICM Projects'!$N$82, IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 5\", '10b. Proposed ACM ICM Projects'!$E$119, IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 6\", '10b. Proposed ACM ICM Projects'!$H$119, IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 7\", '10b. Proposed ACM ICM Projects'!$K$119, IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 8\", '10b. Proposed ACM ICM Projects'!$N$119,  IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 9\", '10b. Proposed ACM ICM Projects'!$E$156, IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 10\", '10b. Proposed ACM ICM Projects'!$H$156, “”)))))))))))","v":0},null,{"$f":"C26*(E25/C25)","v":0},"C"]
[null,"CCA",{"$f":"IF('1. Information Sheet'!$F$26=\"COS\", 0, IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 1\", '10b. Proposed ACM ICM Projects'!$F$82, IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 2\", '10b. Proposed ACM ICM Projects'!$I$82, IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 3\", '10b. Proposed ACM ICM Projects'!$L$82, IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 4\", '10b. Proposed ACM ICM Projects'!$O$82, IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 5\", '10b. Proposed ACM ICM Projects'!$F$119, IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 6\", '10b. Proposed ACM ICM Projects'!$I$119, IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 7\", '10b. Proposed ACM ICM Projects'!$L$119, IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 8\", '10b. Proposed ACM ICM Projects'!$O$119,  IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 9\", '10b. Proposed ACM ICM Projects'!$F$156, IF(\"Year \" & '1. Information Sheet'!$F$28=\"Year 10\", '10b. Proposed ACM ICM Projects'!$I$156, “”)))))))))))","v":0},null,{"$f":"C27*(E25/C25)","v":0},"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":14118000},"B"]
[null,"Depreciation Expense (prorated to Eligible Incremental Capital)",null,null,{"$f":"E26","v":0},"C"]
[null,"Incremental Capital to be included in Rate Base (average NBV in year)",null,null,{"$f":"E32-E33/2","v":14118000},"D = B - C/2"]
[null,null,"% of capital structure"]
[null,"Deemed Short-Term Debt",{"$f":"'6. Rev_Requ_Check'!C36","v":0.04},"E",{"$f":"E34*C36","v":564720},"G = D * E"]
[null,"Deemed Long-Term Debt",{"$f":"'6. Rev_Requ_Check'!C37","v":0.56000000000000005},"F",{"$f":"E34*C37","v":7906080.0000000009},"H = D * F"]
[null,null,"Rate (%)"]
[null,"Short-Term Interest",{"$f":"'6. Rev_Requ_Check'!C40","v":2.8199999999999999E-2},"I",{"$f":"E36*C39","v":15925.103999999999},"K = G * I"]
[null,"Long-Term Interest",{"$f":"'6. Rev_Requ_Check'!C41","v":4.9500000000000002E-2},"J",{"$f":"E37*C40","v":391350.96000000008},"L = H * J"]
[]
[null,"Return on Rate Base - Interest",null,null,{"$f":"SUM(E39:E40)","v":407276.06400000007},"M = K + L"]
[]
[null,null,{"$f":"C35","v":"% of capital structure"}]
[null,"Deemed Equity %",{"$f":"'6. Rev_Requ_Check'!C38","v":0.39999999999999991},"N",{"$f":"E34*C45","v":5647199.9999999991},"P = D * N"]
[null,null,{"$f":"C38","v":"Rate (%)"}]
[null,"Return on Rate Base -Equity",{"$f":"'6. Rev_Requ_Check'!C42","v":8.9800000000000005E-2},"O",{"$f":"E45*C47","v":507118.55999999994},"Q = P * O"]
[]
[null,"Return on Rate Base - Total",null,null,{"$f":"E42+E47","v":914394.62400000007},"R = M + Q"]
[]
[]
[]
[null,"Amortization Expense"]
[]
[null,"Amortization Expense - Incremental",null,"C",{"$f":"E33","v":0},"S"]
[]
[]
[null,"Grossed up Taxes/PILs"]
[]
[null,"Regulatory Taxable Income",null,"O",{"$f":"E47","v":507118.55999999994},"T "]
[]
[null,"Add Back Amortization Expense (Prorated to Eligible Incremental Capital)",null,"S",{"$f":"E55","v":0},"U"]
[]
[null,"Deduct CCA (Prorated to Eligible Incremental Capital)",null,null,{"$f":"E27","v":0},"V"]
[]
[null,"Incremental Taxable Income",null,null,{"$f":"E60+E62-E64","v":507118.55999999994},"W = T + U - V"]
[]
[null,"Current Tax Rate",0.26500000000000001,"X"]
[]
[null,"Taxes/PILs Before Gross Up",null,null,{"$f":"E66*C68","v":134386.4184},"Y = W * X"]
[]
[null,"Grossed-Up Taxes/PILs",null,null,{"$f":"E70/(1-C68)","v":182838.66448979592},"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":914394.62400000007},"AA"]
[null,"Amortization Expense - Total",null,"S",{"$f":"E55","v":0},"AB"]
[null,{"$f":"B72","v":"Grossed-Up Taxes/PILs"},null,"Z",{"$f":"E72","v":182838.66448979592},"AC"]
[]
[]
[null,"Incremental Revenue Requirement",null,null,{"$f":"SUM(E88:E90)","v":1097233.288489796},"AD = AA + AB + AC"]

{"sheet":"12. Opt 1-Rate Rider Calc F & V","index":20,"n_rows":23,"n_cols":26,"rows_kept":23,"cut":false,"hidden":false,"merged":[[12,0,12,3],[12,4,12,5]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Calculation of incremental rate rider.  Choose one of the 3 options:"]
[]
["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","Distribution Volumetric Rate kWh Rate Rider","Distribution Volumetric Rate kW Rate Rider"]
[null,null,"From Sheet 8","From Sheet 8","From Sheet 8","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 I / Col K / 12","Col I / Col L","Col I / Col M"]
["RESIDENTIAL R1",null,0.45712121279210149,0.25572628533372954,0,501568.61,280591.39,0,782160,null,9112.8451064303372,103931741.84820433,0,null,7.15,0,0]
["RESIDENTIAL R2",null,1.9160716028092162E-2,0,0.14373880408446293,21023.78,0,157715,178738.78,null,37.282220262380214,85867986.524168611,196648.09194709637,null,399.52,0,0]
["SEASONAL CUSTOMERS",null,8.0358977418596295E-2,3.5668853553849293E-2,0,88172.55,39137.050000000003,0,127309.6,null,2960.1858518389645,5439364.9283407871,0,null,3.58,0,0]
["STREET LIGHTING",null,7.071534939969902E-4,7.5179972951712653E-3,0,775.91,8249,0,9024.91,null,1117.0833333333333,595435.11416171514,0,null,0.67,0,0]
["Total",null,{"$f":"SUM(C17:C20)","v":0.55734805973278689},0.29891313618275012,0.14373880408446293,611540.85000000009,327977.44,157715,1097233.29,null,{"$f":"SUM(K17:K20)","v":13227.396511865018},{"$f":"SUM(L17:L20)","v":195834528.41487545},{"$f":"SUM(M17:M20)","v":196648.09194709637}]
[null,null,null,null,null,null,null,null,1097233.2885]
[null,null,null,null,null,null,null,null,"From Sheet 11, E93"]