{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["1. Info","2. Table of Contents","3. Re-Based Bill Det & Rates","4. Removal of Rate Adders","5. Re-Based Rev From Rates","6. Decision Cost Revenue Adj","7. Revenue Offsets Allocation","8. Transformer Allowance","9. R C Ratio Revenue","10. Proposed R C Ratio Adj","11. Proposed Revenue","12. Proposed F V Rev Alloc","13. Proposed F V Rates","14. Adjust To Proposed Rates","RateClasses","F1.2 CalcTaxChg RRider OptA FV","G4.2 Incr Cap RRider Opt A FV","Z1.0 OEB Control Sheet"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":7,"defined_names":110,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1. Info","index":0,"n_rows":71,"n_cols":28,"rows_kept":71,"cut":false,"hidden":false,"merged":[[18,3,18,4],[1,2,1,9],[2,2,2,9],[3,2,3,9],[4,2,4,9],[14,3,14,4]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alectra Utilities Corporation-Brampton Rate Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alectra Utilities Corporation-Enersource Rate Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alectra Utilities Corporation-Horizon Utilities Rate Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alectra Utilities Corporation-PowerStream Rate Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alectra Utilities Corporation-Guelph Rate Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Algoma Power Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Atikokan Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bluewater Power Distribution Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Burlington Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Canadian Niagara Power Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Centre Wellington Hydro Ltd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chapleau Public Utilities Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cooperative Hydro Embrun Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E.L.K. Energy Inc."]
[null,null,"Utility Name ","Synergy North Corporation-Thunder Bay Rate Zone ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elexicon Energy Inc.-Whitby Rate Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elexicon Energy Inc.-Veridian Rate Zone"]
[null,null,"Assigned EB Number","EB-2025-0008",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enova Power Corp.-Kitchener-Wilmot Hydro Rate Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enova Power Corp.-Waterloo North Rate Zone"]
[null,null,"Name and Title of Contact","Jillian Hanstead",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Entegrus Powerlines Inc.-For Entegrus-Main Rate Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Entegrus Powerlines Inc.-For Former St. Thomas Energy Rate Zone"]
[null,null,"Phone Number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENWIN Utilities Ltd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EPCOR Electricity Distribution Ontario Inc."]
[null,null,"Email Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ERTH Power Corporation - ERTH Power Main Rate Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ERTH POWER CORPORATION – GODERICH RATE ZONE"]
[null,null,"Last COS Re-based Year",2023,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Essex Powerlines Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Festival Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fort Frances Power Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GrandBridge Energy Inc.-Brantford Power Rate Zone "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GrandBridge Energy Inc.-Energy+ Rate Zone "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Greater Sudbury Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grimsby Power Incorporated"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Halton Hills Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hearst Power Distribution Co. Ltd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro 2000 Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro Hawkesbury Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro One Networks Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro One Networks Inc.-Former Orillia Power Distribution Corporation Service Area"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro One Networks Inc.-Former Peterborough Distribution Inc. Service Area"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro One Networks Inc.-Former Haldimand County Hydro Inc. Service Area"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro One Networks Inc.-Former Norfolk Power Distribution Inc. Service Area"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro One Networks Inc.-Former Woodstock Hydro Services Inc. Service Area"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro One Remote Communites Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro Ottawa Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InnPower Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kingston Hydro Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lakefront Utilities Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lakeland Power Distribution Ltd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"London Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Milton Hydro Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Newmarket-Tay Power Distribution Ltd.-For Former Midland Power Utility Rate Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Newmarket-Tay Power Distribution Ltd.-For Newmarket-Tay Power Main Rate Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Niagara Peninsula Energy Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Niagara-on-the-Lake Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"North Bay Hydro Distribution Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Northern Ontario Wires Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oakville Hydro Electricity Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orangeville Hydro Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oshawa PUC Networks Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ottawa River Power Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PUC Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Renfrew Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rideau St. Lawrence Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sioux Lookout Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Synergy North Corporation-Kenora Rate Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Synergy North Corporation-Thunder Bay Rate Zone "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tillsonburg Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Toronto Hydro-Electric System Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wasaga Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Welland Hydro-Electric System Corp."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wellington North Power Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Westario Power Inc."]

{"sheet":"2. Table of Contents","index":1,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"1. Info",null,"8. Transformer Allowance"]
[null,null,"2. Table of Contents",null,"9. R C Ratio Revenue"]
[null,null,"3. Re-Based Bill Det & Rates",null,"10. Proposed R C Ratio Adj"]
[null,null,"4. Removal of Rate Adders",null,"11. Proposed Revenue"]
[null,null,"5. Re-Based Rev From Rates",null,"12. Proposed F V Rev Alloc"]
[null,null,"6. Decision Cost Revenue Adj",null,"13. Proposed F V Rates"]
[null,null,"7. Revenue Offsets Allocation",null,"14. Adjust To Proposed Rates"]

{"sheet":"3. Re-Based Bill Det & Rates","index":2,"n_rows":59,"n_cols":52,"rows_kept":59,"cut":false,"hidden":false,"merged":[[9,0,9,13]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[]
[]
[]
[]
[]
[]
[]
["The purpose of this sheet is to set up the rate classes, enter the re-based billing determinants from your last cost of service application and enter the current service charge and volumetric distribution rates as found on your most current Tariff of Rates and Charges. \n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Control",null,"Rate Class","Fixed Metric","Vol Metric","OEB Audit",null,"Re-based Billed Customers or Connections","Re-based Billed kWh","Re-based Billed kW",null,"Current Tariff Service Charge","Current Tariff Distribution Volumetric Rate kWh","Current Tariff Distribution Volumetric Rate kW",null,null,null,null,null,null,null,null,null,null,null,"Residential","Threshold",null,"Less Than 50","Threshold",null,"Greater Than 50","Threshold",null,"Large Use","Threshold",null,"USL","Threshold",null,"Sentinel","Threshold",null,"Street","Threshold",null,"EMB",null,null,"SB"]
[null,null,null,null,null,null,null,null,"A","B","C",null,"D","E","F",null,null,null,null,null,null,null,null,null,null,null,"Residential","250 / 2,250",null,"General Service Less Than 50 kW","2,000 / 20,000",null,"General Service 50 to 499 kW","50 / 500",null,"Large Use","5,000 / 100,000",null,"Unmetered Scattered Load","500 / 20,000",null,"Sentinel Lighting","0.2 / 1.0",null,"Street Lighting","0.2 / 1.0",null,"Embedded Distributor",null,null,"Stand-By"]
[null,1,null,"RESIDENTIAL SERVICE CLASSIFICATION","Customers","kWh",null,null,51255,379776105,null,null,35.409999999999997,0,0,null,null,null,null,null,null,null,null,null,null,null,"Residential Regular","250 / 2,250",null,"General Service Less Than 50 kW – Single Phase energy-billed [G1]","2,000 / 20,000",null,"General Service 50 to 699 kW","50 / 700",null,"Large Use - Regular","5,000 / 100,000",null,null,null,null,null,null,null,null,null,null,"Low Voltage Wheeling Charge Rate",null,null,"Standby Power"]
[null,2,null,"GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","Customers","kWh",null,null,5487,171279860,null,null,40.5,2.2800000000000001E-2,0,null,null,null,null,null,null,null,null,null,null,null,"Residential Urban","250 / 2,250",null,"General Service Less Than 50 kW – Three Phase energy-billed [G3]","2,000 / 20,000",null,"General Service 50 to 999 kW","50 / 1,000",null,"Large Use > 5000 kW","5,000 / 100,000",null,null,null,null,null,null,null,null,null,null,null,null,null,"Standby Power – INTERIM APPROVAL"]
[null,3,null,"GENERAL SERVICE 50 TO 999 KW SERVICE CLASSIFICATION","Customers","kW",null,null,465,285468167,708872,null,237.07,0,5.3205,null,null,null,null,null,null,null,null,null,null,null,"Residential Urban Year-Round","250 / 2,250",null,"General Service Less Than 50 kW – Transmission Class energy-billed [T]","2,000 / 20,000",null,"General Service 50 to 999 kW - Interval Metered","50 / 1,000",null,"Large Use - 3TS","5,000 / 100,000",null,null,null,null,null,null,null,null,null,null,null,null,null,"Standby Power - APPROVED ON AN INTERIM BASIS"]
[null,4,null,"GENERAL SERVICE 1,000 KW OR GREATER SERVICE CLASSIFICATION","Customers","kW",null,null,15,147499803,472990,null,3391.93,0,4.1487999999999996,null,null,null,null,null,null,null,null,null,null,null,"Residential Suburban","250 / 2,250",null,"General Service Less Than 50 kW – Urban energy-billed [UG]","2,000 / 20,000",null,"General Service 50 to 1,000 kW","50 / 1,000",null,"Large Use - Ford Annex","5,000 / 100,000",null,null,null,null,null,null,null,null,null,null,null,null,null,"Standby - General Service 50 - 1,000 kW"]
[null,5,null,"UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","Connections","kWh",null,null,432,2088274,null,null,12.26,2.5899999999999999E-2,0,null,null,null,null,null,null,null,null,null,null,null,"Residential Suburban Seasonal","250 / 2,250",null,"Westport Sewage Treatment Plant","2,000 / 20,000",null,"General Service 50 to 1,000 kW - Interval Meters","50 / 1,500",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"]
[null,6,null,"SENTINEL LIGHTING SERVICE CLASSIFICATION","Connections","kW",null,null,113,96035,258,null,11.38,0,9.1216000000000008,null,null,null,null,null,null,null,null,null,null,null,"Residential Suburban Year Round","250 / 2,250",null,"Farms – Single Phase energy-billed [F1]","2,000 / 20,000",null,"General Service 50 to 1,000 kW - Non Interval Meters","50 / 2,500",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standby - General Service 1,000 - 5,000 kW"]
[null,7,null,"STREET LIGHTING SERVICE CLASSIFICATION","Connections","kW",null,null,13656,5592860,15924,null,2.04,0,10.6088,null,null,null,null,null,null,null,null,null,null,null,"Residential - Time of Use","250 / 2,250",null,"Small Commercial and USL - per meter","2,000 / 20,000",null,"General Service 50 to 1,499 kW","50 / 3,000",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"]
[null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Residential - Hensall","250 / 2,250",null,"Small Commercial and USL - per connection","2,000 / 20,000",null,"General Service 50 to 1,499 kW - Interval Metered","50 / 3,000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standby - Large Use"]
[null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Residential – High Density [R1]","250 / 2,250",null,null,null,null,"General Service 50 to 2,499 kW","50 / 5,000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standby Power General Service Large Use"]
[null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Residential – Normal Density [R2]","250 / 2,250",null,null,null,null,"General Service 50 to 2,999 kW","50 / 5,000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standby Distribution Service"]
[null,11,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]","250 / 2,250",null,null,null,null,"General Service 50 to 2,999 kW - Time of Use","50 / 5,000"]
[null,12,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]","250 / 2,250",null,null,null,null,"General Service 50 to 4,999 kW","50 / 5,000"]
[null,13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Residential – Urban [UR]","250 / 2,250",null,null,null,null,"General Service 50 to 4,999 kW – Interval Metered","50 / 5,000"]
[null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service 50 to 4,999 kW - Time of Use","50 / 5,000"]
[null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service 50 to 4,999 kW (CoGeneration)","500 / 5,000"]
[null,16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service 50 to 4,999 kW (formerly Time of Use)","700 / 5,000"]
[null,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service 500 to 4,999 kW","1,000 / 3,000"]
[null,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service 700 to 4,999 kW","1,000 / 5,000"]
[null,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service 1,000 to 2,999 kW","1,500 / 5,000"]
[null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service 1,000 to 4,999 kW","2,500 / 5,000"]
[null,21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service 1,000 to 4,999 kW - Interval Meters","3,000 / 5,000"]
[null,22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service 1,000 To 4,999 kW (co-generation)","3,000 / 5,000"]
[null,23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service Greater Than 1,000 kW","50 / 5,000"]
[null,24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service Intermediate Rate Class 1,000 To 4,999 kW (formerly Large Use Customers)","50 / 5,000"]
[null,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service Intermediate Rate Class 1,000 To 4,999 kW (formerly General Service > 50 kW Customers)","50 / 5,000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service 1,500 to 4,999 kW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service Equal To Or Greater Than 1,500 kW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service Equal To Or Greater Than 1,500 kW - 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,null,"General Service Intermediate 1,000 To 4,999 kW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service 2,500 to 4,999 kW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service 3,000 to 4,999 kW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service 3,000 to 4,999 kW - 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,null,"General Service 3,000 to 4,999 kW - Intermediate Use"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service 3,000 to 4,999 kW - Time of Use"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Intermediate With Self Generation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service - Commercial"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service - Institutional"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Farms – Three Phase energy-billed [F3]"]

{"sheet":"4. Removal of Rate Adders","index":3,"n_rows":46,"n_cols":52,"rows_kept":46,"cut":false,"hidden":false,"merged":[[9,0,10,6]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[]
[]
[]
[]
[]
[]
[]
["The purpose of this sheet is to remove any rate adders included in current rates. Most applicants will not need to make an entry on this sheet.\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Rate Class",null,"Current Tariff Service Charge","Current Tariff Distribution Volumetric Rate kWh","Current Tariff Distribution Volumetric Rate kW",null,"Service Charge Rate Adders","Distribution Volumetric kWh Rate Adders","Distribution Volumetric kW Rate Adders",null,"Base Service Charge","Base Distribution Volumetric Rate kWh","Base Distribution Volumetric Rate kW"]
[null,null,null,null,"A","B","C",null,"D","E","F",null,"H = A - D","I = B - E","J = C - F"]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D22","v":"RESIDENTIAL SERVICE CLASSIFICATION"},null,{"$f":"'3. Re-Based Bill Det & Rates'!M22","v":35.409999999999997},{"$f":"'3. Re-Based Bill Det & Rates'!N22","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O22","v":0},null,null,null,null,null,{"$f":"E22-I22","v":35.409999999999997},{"$f":"F22-J22","v":0},{"$f":"G22-K22","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D23","v":"GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION"},null,{"$f":"'3. Re-Based Bill Det & Rates'!M23","v":40.5},{"$f":"'3. Re-Based Bill Det & Rates'!N23","v":2.2800000000000001E-2},{"$f":"'3. Re-Based Bill Det & Rates'!O23","v":0},null,null,null,null,null,{"$f":"E23-I23","v":40.5},{"$f":"F23-J23","v":2.2800000000000001E-2},{"$f":"G23-K23","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D24","v":"GENERAL SERVICE 50 TO 999 KW SERVICE CLASSIFICATION"},null,{"$f":"'3. Re-Based Bill Det & Rates'!M24","v":237.07},{"$f":"'3. Re-Based Bill Det & Rates'!N24","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O24","v":5.3205},null,null,null,null,null,237.07,0,5.3205]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D25","v":"GENERAL SERVICE 1,000 KW OR GREATER SERVICE CLASSIFICATION"},null,{"$f":"'3. Re-Based Bill Det & Rates'!M25","v":3391.93},{"$f":"'3. Re-Based Bill Det & Rates'!N25","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O25","v":4.1487999999999996},null,null,null,null,null,3391.93,0,4.1487999999999996]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D26","v":"UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION"},null,{"$f":"'3. Re-Based Bill Det & Rates'!M26","v":12.26},{"$f":"'3. Re-Based Bill Det & Rates'!N26","v":2.5899999999999999E-2},{"$f":"'3. Re-Based Bill Det & Rates'!O26","v":0},null,null,null,null,null,12.26,2.5899999999999999E-2,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D27","v":"SENTINEL LIGHTING SERVICE CLASSIFICATION"},null,{"$f":"'3. Re-Based Bill Det & Rates'!M27","v":11.38},{"$f":"'3. Re-Based Bill Det & Rates'!N27","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O27","v":9.1216000000000008},null,null,null,null,null,11.38,0,9.1216000000000008]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D28","v":"STREET LIGHTING SERVICE CLASSIFICATION"},null,{"$f":"'3. Re-Based Bill Det & Rates'!M28","v":2.04},{"$f":"'3. Re-Based Bill Det & Rates'!N28","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O28","v":10.6088},null,null,null,null,null,2.04,0,10.6088]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D29","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!M29","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!N29","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O29","v":0},null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D30","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!M30","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!N30","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O30","v":0},null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D31","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!M31","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!N31","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O31","v":0},null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D32","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!M32","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!N32","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O32","v":0},null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D33","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!M33","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!N33","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O33","v":0},null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D34","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!M34","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!N34","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O34","v":0},null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D35","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!M35","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!N35","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O35","v":0},null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D36","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!M36","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!N36","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O36","v":0},null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D37","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!M37","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!N37","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O37","v":0},null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D38","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!M38","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!N38","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O38","v":0},null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D39","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!M39","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!N39","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O39","v":0},null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D40","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!M40","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!N40","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O40","v":0},null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D41","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!M41","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!N41","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O41","v":0},null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D42","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!M42","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!N42","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O42","v":0},null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D43","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!M43","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!N43","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O43","v":0},null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D44","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!M44","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!N44","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O44","v":0},null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D45","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!M45","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!N45","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O45","v":0},null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D46","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!M46","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!N46","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O46","v":0},null,null,null,null,null,0,0,0]

{"sheet":"5. Re-Based Rev From Rates","index":4,"n_rows":48,"n_cols":21,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The purpose of this sheet is to calculate current revenue from rate classes."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Rate Class",null,"Re-based Billed Customers or Connections","Re-based Billed kWh","Re-based Billed kW",null,"Current Base Service Charge","Current Base Distribution Volumetric Rate kWh","Current Base Distribution Volumetric Rate kW",null,"Service Charge Revenue","Distribution Volumetric Rate Revenue \nkWh","Distribution Volumetric Rate Revenue \nkW","Revenue Requirement from Rates",null,"Service Charge % Revenue","Distribution Volumetric Rate % Revenue \nkWh","Distribution Volumetric Rate % Revenue \nkW","Total % Revenue"]
[null,null,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"]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D22","v":"RESIDENTIAL SERVICE CLASSIFICATION"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I22","v":51255},{"$f":"'3. Re-Based Bill Det & Rates'!J22","v":379776105},{"$f":"'3. Re-Based Bill Det & Rates'!K22","v":0},null,{"$f":"'4. Removal of Rate Adders'!M22","v":35.409999999999997},{"$f":"'4. Removal of Rate Adders'!N22","v":0},{"$f":"'4. Removal of Rate Adders'!O22","v":0},null,{"$f":"IF(ISERROR(E22*I22*12),0,E22*I22*12)","v":21779274.599999998},{"$f":"IF(ISERROR(F22*J22),0,F22*J22)","v":0},{"$f":"IF(ISERROR(G22*K22),0,G22*K22)","v":0},{"$f":"SUM(M22:O22)","v":21779274.599999998},null,{"$f":"IF(ISERROR(M22/P22),\"\",M22/P22)","v":1},{"$f":"IF(ISERROR(N22/P22),\"\",N22/P22)","v":0},{"$f":"IF(ISERROR(O22/P22),\"\",O22/P22)","v":0},{"$f":"IF(ISERROR(P22/P$47),\"\",P22/P$47)","v":0.59413539378112279}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D23","v":"GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I23","v":5487},{"$f":"'3. Re-Based Bill Det & Rates'!J23","v":171279860},{"$f":"'3. Re-Based Bill Det & Rates'!K23","v":0},null,{"$f":"'4. Removal of Rate Adders'!M23","v":40.5},{"$f":"'4. Removal of Rate Adders'!N23","v":2.2800000000000001E-2},{"$f":"'4. Removal of Rate Adders'!O23","v":0},null,{"$f":"IF(ISERROR(E23*I23*12),0,E23*I23*12)","v":2666682},{"$f":"IF(ISERROR(F23*J23),0,F23*J23)","v":3905180.8080000002},{"$f":"IF(ISERROR(G23*K23),0,G23*K23)","v":0},{"$f":"SUM(M23:O23)","v":6571862.8080000002},null,{"$f":"IF(ISERROR(M23/P23),\"\",M23/P23)","v":0.40577262153948479},{"$f":"IF(ISERROR(N23/P23),\"\",N23/P23)","v":0.59422737846051521},{"$f":"IF(ISERROR(O23/P23),\"\",O23/P23)","v":0},{"$f":"IF(ISERROR(P23/P$47),\"\",P23/P$47)","v":0.17927944658480938}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D24","v":"GENERAL SERVICE 50 TO 999 KW SERVICE CLASSIFICATION"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I24","v":465},{"$f":"'3. Re-Based Bill Det & Rates'!J24","v":285468167},{"$f":"'3. Re-Based Bill Det & Rates'!K24","v":708872},null,{"$f":"'4. Removal of Rate Adders'!M24","v":237.07},{"$f":"'4. Removal of Rate Adders'!N24","v":0},{"$f":"'4. Removal of Rate Adders'!O24","v":5.3205},null,1322850.6000000001,0,3771553.4759999998,5094404.0759999994,null,0.25966738803308076,0,0.74033261196691935,0.13897459063096695]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D25","v":"GENERAL SERVICE 1,000 KW OR GREATER SERVICE CLASSIFICATION"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I25","v":15},{"$f":"'3. Re-Based Bill Det & Rates'!J25","v":147499803},{"$f":"'3. Re-Based Bill Det & Rates'!K25","v":472990},null,{"$f":"'4. Removal of Rate Adders'!M25","v":3391.93},{"$f":"'4. Removal of Rate Adders'!N25","v":0},{"$f":"'4. Removal of Rate Adders'!O25","v":4.1487999999999996},null,610547.39999999991,0,1962340.9119999998,2572888.3119999999,null,0.23730039005284265,0,0.76269960994715724,7.018801307574167E-2]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D26","v":"UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I26","v":432},{"$f":"'3. Re-Based Bill Det & Rates'!J26","v":2088274},{"$f":"'3. Re-Based Bill Det & Rates'!K26","v":0},null,{"$f":"'4. Removal of Rate Adders'!M26","v":12.26},{"$f":"'4. Removal of Rate Adders'!N26","v":2.5899999999999999E-2},{"$f":"'4. Removal of Rate Adders'!O26","v":0},null,63555.839999999997,54086.296600000001,0,117642.1366,null,0.54024724335038976,0.45975275664961018,0,3.2092601079603284E-3]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D27","v":"SENTINEL LIGHTING SERVICE CLASSIFICATION"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I27","v":113},{"$f":"'3. Re-Based Bill Det & Rates'!J27","v":96035},{"$f":"'3. Re-Based Bill Det & Rates'!K27","v":258},null,{"$f":"'4. Removal of Rate Adders'!M27","v":11.38},{"$f":"'4. Removal of Rate Adders'!N27","v":0},{"$f":"'4. Removal of Rate Adders'!O27","v":9.1216000000000008},null,15431.28,0,2353.3728000000001,17784.6528,null,0.8676739531288461,0,0.13232604687115399,4.8516270117594036E-4]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D28","v":"STREET LIGHTING SERVICE CLASSIFICATION"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I28","v":13656},{"$f":"'3. Re-Based Bill Det & Rates'!J28","v":5592860},{"$f":"'3. Re-Based Bill Det & Rates'!K28","v":15924},null,{"$f":"'4. Removal of Rate Adders'!M28","v":2.04},{"$f":"'4. Removal of Rate Adders'!N28","v":0},{"$f":"'4. Removal of Rate Adders'!O28","v":10.6088},null,334298.88,0,168934.5312,503233.41119999997,null,0.66430183799370124,0,0.33569816200629887,1.3728133118222848E-2]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D29","v":0},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D30","v":0},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D31","v":0},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D32","v":0},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D33","v":0},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D34","v":0},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D35","v":0},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D36","v":0},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D37","v":0},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D38","v":0},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D39","v":0},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D40","v":0},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D41","v":0},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D42","v":0},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D43","v":0},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D44","v":0},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D45","v":0},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D46","v":0},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M22:M46)","v":26792640.599999998},{"$f":"SUM(N22:N46)","v":3959267.1046000002},{"$f":"SUM(O22:O46)","v":5905182.2919999994},{"$f":"SUM(P22:P46)","v":36657089.996600002},null,null,null,null,{"$f":"SUM(U22:U46)","v":0.99999999999999989}]
[null,null,null,null,null,null,null,null,null,null,null,null,"O","P","Q","R"]

{"sheet":"6. Decision Cost Revenue Adj","index":5,"n_rows":46,"n_cols":12,"rows_kept":46,"cut":false,"hidden":false,"merged":[[6,0,6,10]]}
[]
[]
[]
[]
[]
[]
["The purpose of this sheet is to enter the Revenue Cost Ratios as determined from column G on Sheet \"10. Proposed R C Ratio Adj\" of the applicant's Revenue to Cost Ratio Adjustment Workform (V1.0) or latest COS Decision and Order.\n\nUnder the column labeled \"Direction\", the applicant can choose \"No Change\" (i.e. no change in that rate class ratio), \"Change\" (i.e. the OEB ordered change from COS decision) or \"Rebalance\" (i.e. to apply any offset adjustments required).\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Rate Class","Direction","Current Year","Transition Year 1","Transition Year 2","Transition Year 3","Transition Year 4","Transition Year 5"]
[null,null,null,null,2025,2026,{"$f":"IF(ISERROR(F21+1),\"\",F21+1)","v":2027},{"$f":"IF(ISERROR(F21+2),\"\",F21+2)","v":2028},{"$f":"IF(ISERROR(F21+3),\"\",F21+3)","v":2029},{"$f":"IF(ISERROR(F21+4),\"\",F21+4)","v":2030}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D22","v":"RESIDENTIAL SERVICE CLASSIFICATION"},"No Change",0.995,0.99500000476837158,0.99500000476837158,0.99500000476837158,0.99500000476837158,0.99500000476837158,null,"No Change"]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D23","v":"GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION"},"Rebalance",1.1599999999999999,"tbd","tbd","tbd","tbd","tbd",null,"Change"]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D24","v":"GENERAL SERVICE 50 TO 999 KW SERVICE CLASSIFICATION"},"No Change",0.877,0.87699997425079346,0.87699997425079346,0.87699997425079346,0.87699997425079346,0.87699997425079346,null,"Rebalance"]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D25","v":"GENERAL SERVICE 1,000 KW OR GREATER SERVICE CLASSIFICATION"},"No Change",1.0489999999999999,1.0490000247955322,1.0490000247955322,1.0490000247955322,1.0490000247955322,1.0490000247955322]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D26","v":"UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION"},"No Change",1.079,1.0789999961853027,1.0789999961853027,1.0789999961853027,1.0789999961853027,1.0789999961853027]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D27","v":"SENTINEL LIGHTING SERVICE CLASSIFICATION"},"No Change",0.90400000000000003,0.90399998426437378,0.90399998426437378,0.90399998426437378,0.90399998426437378,0.90399998426437378]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D28","v":"STREET LIGHTING SERVICE CLASSIFICATION"},"Change",0.74,0.8,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D29","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D30","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D31","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D32","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D33","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D34","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D35","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D36","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D37","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D38","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D39","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D40","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D41","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D42","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D43","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D44","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D45","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D46","v":0},null,0,0,0,0,0,0]

{"sheet":"7. Revenue Offsets Allocation","index":6,"n_rows":48,"n_cols":6,"rows_kept":48,"cut":false,"hidden":false,"merged":[[9,0,9,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The purpose of this sheet is to allocate the Revenue Offsets (miscellaneous revenue, cell F47) found in the last COS to the various rate classes in proportion to the allocation from the Cost Allocation informational filing."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Rate Class","Informational Filing Revenue Offsets","Percentage Split","Allocated Revenue Offsets"]
[null,null,null,"A","C= A / B","E = D * C"]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D22","v":"RESIDENTIAL SERVICE CLASSIFICATION"},1765081.2046465529,{"$f":"IF(ISERROR(D22/$D$47),0,D22/$D$47)","v":0.62278916433211828},{"$f":"$F$47*E22","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D23","v":"GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION"},400162.23175691208,{"$f":"IF(ISERROR(D23/$D$47),0,D23/$D$47)","v":0.14119276850102025},{"$f":"$F$47*E23","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D24","v":"GENERAL SERVICE 50 TO 999 KW SERVICE CLASSIFICATION"},417611.16540410649,0.14734942960874467,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D25","v":"GENERAL SERVICE 1,000 KW OR GREATER SERVICE CLASSIFICATION"},173789.05399500637,6.1319524236445884E-2,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D26","v":"UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION"},68712.149216212769,2.4244313449815497E-2,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D27","v":"SENTINEL LIGHTING SERVICE CLASSIFICATION"},1653.8510640776099,5.8354285310795704E-4,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D28","v":"STREET LIGHTING SERVICE CLASSIFICATION"},7145.6339171326372,2.5212570187474219E-3,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D29","v":0},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D30","v":0},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D31","v":0},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D32","v":0},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D33","v":0},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D34","v":0},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D35","v":0},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D36","v":0},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D37","v":0},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D38","v":0},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D39","v":0},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D40","v":0},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D41","v":0},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D42","v":0},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D43","v":0},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D44","v":0},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D45","v":0},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D46","v":0},0,0,0]
[null,null,null,{"$f":"SUM(D22:D46)","v":2834155.290000001},{"$f":"SUM(E22:E46)","v":0.99999999999999989}]
[null,null,null,"B",null,"D"]

{"sheet":"8. Transformer Allowance","index":7,"n_rows":48,"n_cols":13,"rows_kept":48,"cut":false,"hidden":false,"merged":[[11,0,11,5],[9,0,10,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The purpose of this sheet is to remove the transformer allowance from volumetric rates.  In Cell E47, enter your Transformer Allowance as per your 2019 Revenue to Cost Ratio Adjustment Workform (V1.0) or your last CoS Decision. Under the column labeled \"Transformer Allowance in Rates\" select \"Yes\" if included in that rate class or \"No\" if not included. Once selected, apply the update button to reveal input cells in which you can enter the number of kW's and the transfromer rate for each rate class."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Rate Class","Transformer Allowance In Rate","Transformer Allowance","Transformer Allowance kW's","Transformer Allowance Rate","Volumetric Distribution Rate","Billed kW's","Adjusted Volumetric Distribution Rate"]
[null,null,null,null,"A","C","E","F","G","I =( F * (G - C) + (F - E) * C) / G"]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D22","v":"RESIDENTIAL SERVICE CLASSIFICATION"},"No",null,null,null,null,null,null,{"$f":"(I22*(J22-G22) + (I22-H22)*G22)/J22","v":{"$error":"#DIV/0!"}},null,"Yes"]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D23","v":"GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION"},"No",null,null,null,null,null,null,null,null,"No"]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D24","v":"GENERAL SERVICE 50 TO 999 KW SERVICE CLASSIFICATION"},"Yes",{"$f":"IF(ISERROR(F24*G24),0,F24*G24)","v":67158},111930,0.6,{"$f":"'5. Re-Based Rev From Rates'!K24","v":5.3205},{"$f":"'3. Re-Based Bill Det & Rates'!K24","v":708872},{"$f":"IF(ISERROR((H24*(I24-F24) + (H24-G24)*F24)/I24),0,(H24*(I24-F24) + (H24-G24)*F24)/I24)","v":5.2257607522937848}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D25","v":"GENERAL SERVICE 1,000 KW OR GREATER SERVICE CLASSIFICATION"},"Yes",{"$f":"IF(ISERROR(F25*G25),0,F25*G25)","v":283794},472990,0.6,{"$f":"'5. Re-Based Rev From Rates'!K25","v":4.1487999999999996},{"$f":"'3. Re-Based Bill Det & Rates'!K25","v":472990},{"$f":"IF(ISERROR((H25*(I25-F25) + (H25-G25)*F25)/I25),0,(H25*(I25-F25) + (H25-G25)*F25)/I25)","v":3.5487999999999995}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D26","v":"UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION"},"No"]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D27","v":"SENTINEL LIGHTING SERVICE CLASSIFICATION"},"No"]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D28","v":"STREET LIGHTING SERVICE CLASSIFICATION"},"No"]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D29","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D30","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D31","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D32","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D33","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D34","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D35","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D36","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D37","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D38","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D39","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D40","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D41","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D42","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D43","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D44","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D45","v":0},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D46","v":0},null,0,0,0,0,0,0]
[null,null,null,null,350952,{"$f":"SUM(F22:F46)","v":584920},null,null,{"$f":"SUM(I22:I46)","v":1181862}]
[null,null,null,null,"B","D",null,null,"H"]

{"sheet":"9. R C Ratio Revenue","index":8,"n_rows":48,"n_cols":19,"rows_kept":48,"cut":false,"hidden":false,"merged":[[9,2,10,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"The purpose of this sheet is to calculate revenue by rate class that inlcudes Revenue Offsets and excludes Transformer Allowance prior to Revenue Cost Ratio Adjustment re-allocation."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"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","Distribution Volumetric Rate\nkWh","Distribution Volumetric Rate\nkW","Revenue Requirement from Rates",null,"Allocated Revenue Offset","Adjusted Revenue"]
[null,null,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","L = J + K"]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D22","v":"RESIDENTIAL SERVICE CLASSIFICATION"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I22","v":51255},{"$f":"'3. Re-Based Bill Det & Rates'!J22","v":379776105},{"$f":"'3. Re-Based Bill Det & Rates'!K22","v":0},null,{"$f":"'5. Re-Based Rev From Rates'!I22","v":35.409999999999997},{"$f":"'5. Re-Based Rev From Rates'!J22","v":0},{"$f":"'5. Re-Based Rev From Rates'!K22","v":0},null,{"$f":"E22*I22*12","v":21779274.599999998},{"$f":"F22*J22","v":0},{"$f":"G22*K22","v":0},{"$f":"SUM(M22:O22)","v":21779274.599999998},null,{"$f":"'7. Revenue Offsets Allocation'!F22","v":0},{"$f":"SUM(P22,R22)","v":21779274.599999998}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D23","v":"GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I23","v":5487},{"$f":"'3. Re-Based Bill Det & Rates'!J23","v":171279860},{"$f":"'3. Re-Based Bill Det & Rates'!K23","v":0},null,{"$f":"'5. Re-Based Rev From Rates'!I23","v":40.5},{"$f":"'5. Re-Based Rev From Rates'!J23","v":2.2800000000000001E-2},{"$f":"'5. Re-Based Rev From Rates'!K23","v":0},null,{"$f":"E23*I23*12","v":2666682},{"$f":"F23*J23","v":3905180.8080000002},{"$f":"G23*K23","v":0},{"$f":"SUM(M23:O23)","v":6571862.8080000002},null,{"$f":"'7. Revenue Offsets Allocation'!F23","v":0},{"$f":"SUM(P23,R23)","v":6571862.8080000002}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D24","v":"GENERAL SERVICE 50 TO 999 KW SERVICE CLASSIFICATION"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I24","v":465},{"$f":"'3. Re-Based Bill Det & Rates'!J24","v":285468167},{"$f":"'3. Re-Based Bill Det & Rates'!K24","v":708872},null,{"$f":"'5. Re-Based Rev From Rates'!I24","v":237.07},{"$f":"'5. Re-Based Rev From Rates'!J24","v":0},{"$f":"'8. Transformer Allowance'!J24","v":5.2257607522937848},null,{"$f":"E24*I24*12","v":1322850.6000000001},{"$f":"F24*J24","v":0},{"$f":"G24*K24","v":3704395.4759999998},{"$f":"SUM(M24:O24)","v":5027246.0759999994},null,{"$f":"'7. Revenue Offsets Allocation'!F24","v":0},{"$f":"SUM(P24,R24)","v":5027246.0759999994}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D25","v":"GENERAL SERVICE 1,000 KW OR GREATER SERVICE CLASSIFICATION"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I25","v":15},{"$f":"'3. Re-Based Bill Det & Rates'!J25","v":147499803},{"$f":"'3. Re-Based Bill Det & Rates'!K25","v":472990},null,{"$f":"'5. Re-Based Rev From Rates'!I25","v":3391.93},{"$f":"'5. Re-Based Rev From Rates'!J25","v":0},{"$f":"'8. Transformer Allowance'!J25","v":3.5487999999999995},null,{"$f":"E25*I25*12","v":610547.39999999991},{"$f":"F25*J25","v":0},{"$f":"G25*K25","v":1678546.9119999998},{"$f":"SUM(M25:O25)","v":2289094.3119999999},null,{"$f":"'7. Revenue Offsets Allocation'!F25","v":0},{"$f":"SUM(P25,R25)","v":2289094.3119999999}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D26","v":"UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I26","v":432},{"$f":"'3. Re-Based Bill Det & Rates'!J26","v":2088274},{"$f":"'3. Re-Based Bill Det & Rates'!K26","v":0},null,{"$f":"'5. Re-Based Rev From Rates'!I26","v":12.26},{"$f":"'5. Re-Based Rev From Rates'!J26","v":2.5899999999999999E-2},{"$f":"'5. Re-Based Rev From Rates'!K26","v":0},null,{"$f":"E26*I26*12","v":63555.839999999997},{"$f":"F26*J26","v":54086.296600000001},{"$f":"G26*K26","v":0},{"$f":"SUM(M26:O26)","v":117642.1366},null,{"$f":"'7. Revenue Offsets Allocation'!F26","v":0},{"$f":"SUM(P26,R26)","v":117642.1366}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D27","v":"SENTINEL LIGHTING SERVICE CLASSIFICATION"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I27","v":113},{"$f":"'3. Re-Based Bill Det & Rates'!J27","v":96035},{"$f":"'3. Re-Based Bill Det & Rates'!K27","v":258},null,{"$f":"'5. Re-Based Rev From Rates'!I27","v":11.38},{"$f":"'5. Re-Based Rev From Rates'!J27","v":0},{"$f":"'5. Re-Based Rev From Rates'!K27","v":9.1216000000000008},null,{"$f":"E27*I27*12","v":15431.28},{"$f":"F27*J27","v":0},{"$f":"G27*K27","v":2353.3728000000001},{"$f":"SUM(M27:O27)","v":17784.6528},null,{"$f":"'7. Revenue Offsets Allocation'!F27","v":0},{"$f":"SUM(P27,R27)","v":17784.6528}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D28","v":"STREET LIGHTING SERVICE CLASSIFICATION"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I28","v":13656},{"$f":"'3. Re-Based Bill Det & Rates'!J28","v":5592860},{"$f":"'3. Re-Based Bill Det & Rates'!K28","v":15924},null,{"$f":"'5. Re-Based Rev From Rates'!I28","v":2.04},{"$f":"'5. Re-Based Rev From Rates'!J28","v":0},{"$f":"'5. Re-Based Rev From Rates'!K28","v":10.6088},null,{"$f":"E28*I28*12","v":334298.88},{"$f":"F28*J28","v":0},{"$f":"G28*K28","v":168934.5312},{"$f":"SUM(M28:O28)","v":503233.41119999997},null,{"$f":"'7. Revenue Offsets Allocation'!F28","v":0},{"$f":"SUM(P28,R28)","v":503233.41119999997}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D29","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D30","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D31","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D32","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D33","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D34","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D35","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D36","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D37","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D38","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D39","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D40","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D41","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D42","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D43","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D44","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D45","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D46","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M22:M46)","v":26792640.599999998},{"$f":"SUM(N22:N46)","v":3959267.1046000002},{"$f":"SUM(O22:O46)","v":5554230.2919999994},{"$f":"SUM(P22:P46)","v":36306137.996600002},null,{"$f":"SUM(R22:R46)","v":0},{"$f":"SUM(S22:S46)","v":36306137.996600002}]
[null,null,null,null,null,null,null,null,null,null,null,null,"O","P","Q","R"]

{"sheet":"10. Proposed R C Ratio Adj","index":9,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[[11,0,12,6],[14,0,14,6],[15,0,15,6],[16,0,16,6],[17,0,17,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Proposed Revenue Cost Ratio Adjustment"]
["This worksheet adjusts revenue-to-cost ratios in order to address any shortfall or over recovery (Out of Balance) that would result from implementing the revenue-to-cost ratios entered on sheet \"6. Decision Cost Revenue Adj\". To do this, one or more rate classes must indicate \"Rebalance\" on sheet 6."]
[]
[]
["There are three options for attributing any Out of Balance to rate classes."]
["    1.  To adjust a single rate class so that the entire Out of Balance is absorbed by that rate class, select the green cell for the rate class under \"Proposed Revenue to Cost Ratio\" labelled Column D. \n    To use this option, click the button \"Iterate Selected Cell to Zero.\""]
["    2.  To apportion the Out of Balance across all green cells such that all green cells are increased by the same amount relative to Column B. To use this option, click the button \"Iterate All Equal Percentage Change.\""]
["    3.  To apportion the Out of Balance such that each class is allocated the Out of Balance in proportion to its share of the allocated costs in Column C. To use this option, click the button \"Iterate All Proportionate Change.\""]
[]
[null,null,"Rate Class","Adjusted Revenue","Current Revenue Cost Ratio","Re-Allocated Cost","Proposed Revenue Cost Ratio","Final Adjusted Revenue",null,"Dollar Change","Percentage Change"]
[null,null,null,"A","B","C = A / B","D","E = C * D",null,"F = E - C","G = (E / C) - 1"]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D22","v":"RESIDENTIAL SERVICE CLASSIFICATION"},{"$f":"'9. R C Ratio Revenue'!S22","v":21779274.599999998},{"$f":"'6. Decision Cost Revenue Adj'!E22","v":0.995},{"$f":"IF(ISERROR(D22/(E22)),0,D22/(E22))","v":21888718.190954771},{"$f":"'6. Decision Cost Revenue Adj'!F22","v":0.99500000476837158},{"$f":"IF(ISERROR(F22*(G22)),\"\",F22*(G22))","v":21779274.704373538},null,{"$f":"H22-D22","v":0.10437354072928429},{"$f":"IF(ISERROR(H22/D22-1),0,H22/D22-1)","v":4.7923331969457195E-9}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D23","v":"GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION"},{"$f":"'9. R C Ratio Revenue'!S23","v":6571862.8080000002},{"$f":"'6. Decision Cost Revenue Adj'!E23","v":1.1599999999999999},{"$f":"IF(ISERROR(D23/(E23)),0,D23/(E23))","v":5665398.9724137932},1.152797908961358,{"$f":"IF(ISERROR(F23*(G23)),\"\",F23*(G23))","v":6531060.0888304478},null,{"$f":"H23-D23","v":-40802.719169552438},{"$f":"IF(ISERROR(H23/D23-1),0,H23/D23-1)","v":-6.208699171243004E-3}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D24","v":"GENERAL SERVICE 50 TO 999 KW SERVICE CLASSIFICATION"},{"$f":"'9. R C Ratio Revenue'!S24","v":5027246.0759999994},{"$f":"'6. Decision Cost Revenue Adj'!E24","v":0.877},{"$f":"IF(ISERROR(D24/(E24)),0,D24/(E24))","v":5732321.6374002276},{"$f":"'6. Decision Cost Revenue Adj'!F24","v":0.87699997425079346},{"$f":"IF(ISERROR(F24*(G24)),\"\",F24*(G24))","v":5027245.9283972662},null,-0.14760273322463036,-2.9360554654189741E-8]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D25","v":"GENERAL SERVICE 1,000 KW OR GREATER SERVICE CLASSIFICATION"},{"$f":"'9. R C Ratio Revenue'!S25","v":2289094.3119999999},{"$f":"'6. Decision Cost Revenue Adj'!E25","v":1.0489999999999999},{"$f":"IF(ISERROR(D25/(E25)),0,D25/(E25))","v":2182168.0762631078},{"$f":"'6. Decision Cost Revenue Adj'!F25","v":1.0490000247955322},{"$f":"IF(ISERROR(F25*(G25)),\"\",F25*(G25))","v":2289094.3661080189},null,5.4108018986880779E-2,2.3637304336077136E-8]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D26","v":"UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION"},{"$f":"'9. R C Ratio Revenue'!S26","v":117642.1366},{"$f":"'6. Decision Cost Revenue Adj'!E26","v":1.079},{"$f":"IF(ISERROR(D26/(E26)),0,D26/(E26))","v":109028.85690454124},{"$f":"'6. Decision Cost Revenue Adj'!F26","v":1.0789999961853027},{"$f":"IF(ISERROR(F26*(G26)),\"\",F26*(G26))","v":117642.13618408793},null,-4.1591207263991237E-4,-3.5354005278875889E-9]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D27","v":"SENTINEL LIGHTING SERVICE CLASSIFICATION"},{"$f":"'9. R C Ratio Revenue'!S27","v":17784.6528},{"$f":"'6. Decision Cost Revenue Adj'!E27","v":0.90400000000000003},{"$f":"IF(ISERROR(D27/(E27)),0,D27/(E27))","v":19673.28849557522},{"$f":"'6. Decision Cost Revenue Adj'!F27","v":0.90399998426437378},{"$f":"IF(ISERROR(F27*(G27)),\"\",F27*(G27))","v":17784.652490428485},null,-3.0957151466282085E-4,-1.7406666219521583E-8]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D28","v":"STREET LIGHTING SERVICE CLASSIFICATION"},{"$f":"'9. R C Ratio Revenue'!S28","v":503233.41119999997},{"$f":"'6. Decision Cost Revenue Adj'!E28","v":0.74},{"$f":"IF(ISERROR(D28/(E28)),0,D28/(E28))","v":680045.1502702703},{"$f":"'6. Decision Cost Revenue Adj'!F28","v":0.8},{"$f":"IF(ISERROR(F28*(G28)),\"\",F28*(G28))","v":544036.12021621631},null,40802.709016216337,8.1081081081081363E-2]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D29","v":0},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D30","v":0},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D31","v":0},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D32","v":0},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D33","v":0},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D34","v":0},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D35","v":0},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D36","v":0},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D37","v":0},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D38","v":0},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D39","v":0},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D40","v":0},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D41","v":0},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D42","v":0},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D43","v":0},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D44","v":0},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D45","v":0},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D46","v":0},0,0,0,0,0,null,0,0]
[null,null,null,{"$f":"SUM(D22:D46)","v":36306137.996600002},null,{"$f":"SUM(F22:F46)","v":36277354.17270229},null,{"$f":"SUM(H22:H46)","v":36306137.99660001},null,{"$f":"SUM(J22:J46)","v":6.8030203692615032E-9},2.2204460492503131E-16]
[]
[null,null,null,null,null,null,"Out of Balance",{"$f":"D47-H47","v":0}]
[]
[null,null,null,null,null,null,"Final ?","Yes"]

{"sheet":"11. Proposed Revenue","index":10,"n_rows":47,"n_cols":10,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Proposed Revenue from Revenue Cost Ratio Adjustment"]
[]
[]
[]
[]
[]
[null,null,"Rate Class","Adjusted Revenue By Revenue Cost Ratio","Allocated Re-Based Revenue Offsets","Revenue Requirement from Rates Before Transformer Allowance",null,"Re-based Transformer Allowance",null,"Revenue Requirement from Rates"]
[null,null,null,"A","B","C = A - B",null,"D",null,"E = C + D"]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D22","v":"RESIDENTIAL SERVICE CLASSIFICATION"},{"$f":"IF(('10. Proposed R C Ratio Adj'!H22=\"\"),0,'10. Proposed R C Ratio Adj'!H22)","v":21779274.704373538},{"$f":"'7. Revenue Offsets Allocation'!F22","v":0},{"$f":"D22-E22","v":21779274.704373538},null,{"$f":"'8. Transformer Allowance'!E22","v":0},null,{"$f":"F22+H22","v":21779274.704373538}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D23","v":"GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION"},{"$f":"IF(('10. Proposed R C Ratio Adj'!H23=\"\"),0,'10. Proposed R C Ratio Adj'!H23)","v":6531060.0888304478},{"$f":"'7. Revenue Offsets Allocation'!F23","v":0},6531060.0888304478,null,{"$f":"'8. Transformer Allowance'!E23","v":0},null,{"$f":"F23+H23","v":6531060.0888304478}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D24","v":"GENERAL SERVICE 50 TO 999 KW SERVICE CLASSIFICATION"},{"$f":"IF(('10. Proposed R C Ratio Adj'!H24=\"\"),0,'10. Proposed R C Ratio Adj'!H24)","v":5027245.9283972662},{"$f":"'7. Revenue Offsets Allocation'!F24","v":0},5027245.9283972662,null,{"$f":"'8. Transformer Allowance'!E24","v":67158},null,5094403.9283972662]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D25","v":"GENERAL SERVICE 1,000 KW OR GREATER SERVICE CLASSIFICATION"},{"$f":"IF(('10. Proposed R C Ratio Adj'!H25=\"\"),0,'10. Proposed R C Ratio Adj'!H25)","v":2289094.3661080189},{"$f":"'7. Revenue Offsets Allocation'!F25","v":0},2289094.3661080189,null,{"$f":"'8. Transformer Allowance'!E25","v":283794},null,2572888.3661080189]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D26","v":"UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION"},{"$f":"IF(('10. Proposed R C Ratio Adj'!H26=\"\"),0,'10. Proposed R C Ratio Adj'!H26)","v":117642.13618408793},{"$f":"'7. Revenue Offsets Allocation'!F26","v":0},117642.13618408793,null,{"$f":"'8. Transformer Allowance'!E26","v":0},null,117642.13618408793]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D27","v":"SENTINEL LIGHTING SERVICE CLASSIFICATION"},{"$f":"IF(('10. Proposed R C Ratio Adj'!H27=\"\"),0,'10. Proposed R C Ratio Adj'!H27)","v":17784.652490428485},{"$f":"'7. Revenue Offsets Allocation'!F27","v":0},17784.652490428485,null,{"$f":"'8. Transformer Allowance'!E27","v":0},null,17784.652490428485]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D28","v":"STREET LIGHTING SERVICE CLASSIFICATION"},{"$f":"IF(('10. Proposed R C Ratio Adj'!H28=\"\"),0,'10. Proposed R C Ratio Adj'!H28)","v":544036.12021621631},{"$f":"'7. Revenue Offsets Allocation'!F28","v":0},544036.12021621631,null,{"$f":"'8. Transformer Allowance'!E28","v":0},null,544036.12021621631]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D29","v":0},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D30","v":0},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D31","v":0},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D32","v":0},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D33","v":0},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D34","v":0},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D35","v":0},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D36","v":0},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D37","v":0},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D38","v":0},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D39","v":0},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D40","v":0},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D41","v":0},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D42","v":0},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D43","v":0},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D44","v":0},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D45","v":0},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D46","v":0},null,null,0,null,null,null,0]
[null,null,null,{"$f":"SUM(D22:D46)","v":36306137.99660001},{"$f":"SUM(E22:E46)","v":0},{"$f":"SUM(F22:F46)","v":36306137.99660001},null,{"$f":"SUM(H22:H46)","v":350952},null,{"$f":"SUM(J22:J46)","v":36657089.99660001}]

{"sheet":"12. Proposed F V Rev Alloc","index":11,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Proposed fixed and variable revenue allocation"]
[]
[]
[]
[]
[]
[]
[null,null,"Rate Class","Revenue Requirement from Rates ",null,"Service Charge % Revenue","Distribution Volumetric Rate % Revenue \nkWh","Distribution Volumetric Rate % Revenue \nkW",null,"Service Charge Revenue","Distribution Volumetric Rate Revenue \nkWh","Distribution Volumetric Rate Revenue \nkW","Revenue Requirement from Rates by Rate Class"]
[null,null,null,"A",null,"B","C","D",null,"E = A * B","F = A * C","G = A * D","H = E + F + G"]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D22","v":"RESIDENTIAL SERVICE CLASSIFICATION"},{"$f":"'11. Proposed Revenue'!J22","v":21779274.704373538},null,{"$f":"'5. Re-Based Rev From Rates'!R22","v":1},{"$f":"'5. Re-Based Rev From Rates'!S22","v":0},{"$f":"'5. Re-Based Rev From Rates'!T22","v":0},null,{"$f":"IF(ISERROR($D22*F22),0,$D22*F22)","v":21779274.704373538},{"$f":"IF(ISERROR($D22*G22),0,$D22*G22)","v":0},{"$f":"IF(ISERROR($D22*H22),0,$D22*H22)","v":0},{"$f":"SUM(J22:L22)","v":21779274.704373538}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D23","v":"GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION"},{"$f":"'11. Proposed Revenue'!J23","v":6531060.0888304478},null,{"$f":"'5. Re-Based Rev From Rates'!R23","v":0.40577262153948479},{"$f":"'5. Re-Based Rev From Rates'!S23","v":0.59422737846051521},{"$f":"'5. Re-Based Rev From Rates'!T23","v":0},null,2650125.3736766311,3880934.7151538166,0,6531060.0888304478]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D24","v":"GENERAL SERVICE 50 TO 999 KW SERVICE CLASSIFICATION"},{"$f":"'11. Proposed Revenue'!J24","v":5094403.9283972662},null,{"$f":"'5. Re-Based Rev From Rates'!R24","v":0.25966738803308076},{"$f":"'5. Re-Based Rev From Rates'!S24","v":0},{"$f":"'5. Re-Based Rev From Rates'!T24","v":0.74033261196691935},null,1322850.5616723839,0,3771553.3667248827,5094403.9283972662]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D25","v":"GENERAL SERVICE 1,000 KW OR GREATER SERVICE CLASSIFICATION"},{"$f":"'11. Proposed Revenue'!J25","v":2572888.3661080189},null,{"$f":"'5. Re-Based Rev From Rates'!R25","v":0.23730039005284265},{"$f":"'5. Re-Based Rev From Rates'!S25","v":0},{"$f":"'5. Re-Based Rev From Rates'!T25","v":0.76269960994715724},null,610547.4128398539,0,1962340.9532681648,2572888.3661080189]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D26","v":"UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION"},{"$f":"'11. Proposed Revenue'!J26","v":117642.13618408793},null,{"$f":"'5. Re-Based Rev From Rates'!R26","v":0.54024724335038976},{"$f":"'5. Re-Based Rev From Rates'!S26","v":0.45975275664961018},{"$f":"'5. Re-Based Rev From Rates'!T26","v":0},null,63555.839775304645,54086.296408783273,0,117642.13618408793]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D27","v":"SENTINEL LIGHTING SERVICE CLASSIFICATION"},{"$f":"'11. Proposed Revenue'!J27","v":17784.652490428485},null,{"$f":"'5. Re-Based Rev From Rates'!R27","v":0.8676739531288461},{"$f":"'5. Re-Based Rev From Rates'!S27","v":0},{"$f":"'5. Re-Based Rev From Rates'!T27","v":0.13232604687115399},null,15431.279731392862,0,2353.3727590356252,17784.652490428489]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D28","v":"STREET LIGHTING SERVICE CLASSIFICATION"},{"$f":"'11. Proposed Revenue'!J28","v":544036.12021621631},null,{"$f":"'5. Re-Based Rev From Rates'!R28","v":0.66430183799370124},{"$f":"'5. Re-Based Rev From Rates'!S28","v":0},{"$f":"'5. Re-Based Rev From Rates'!T28","v":0.33569816200629887},null,361404.19459459471,0,182631.92562162166,544036.12021621643]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D29","v":0},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D30","v":0},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D31","v":0},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D32","v":0},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D33","v":0},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D34","v":0},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D35","v":0},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D36","v":0},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D37","v":0},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D38","v":0},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D39","v":0},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D40","v":0},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D41","v":0},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D42","v":0},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D43","v":0},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D44","v":0},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D45","v":0},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D46","v":0},null,null,null,null,null,null,0,0,0,0]
[null,null,null,{"$f":"SUM(D22:D46)","v":36657089.99660001},null,null,null,null,null,{"$f":"SUM(J22:J46)","v":26803189.366663702},{"$f":"SUM(K22:K46)","v":3935021.0115625998},{"$f":"SUM(L22:L46)","v":5918879.6183737041},{"$f":"SUM(M22:M46)","v":36657089.99660001}]

{"sheet":"13. Proposed F V Rates","index":12,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Proposed fixed and variable rates"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Rate Class",null,"Service Charge Revenue","Distribution Volumetric Rate Revenue \nkWh","Distribution Volumetric Rate Revenue \nkW",null,"Re-based Billed Customers or Connections","Re-based Billed kWh","Re-based Billed kW",null,"Proposed Base Service Charge","Proposed Base Distribution Volumetric Rate kWh","Proposed Base Distribution Volumetric Rate kW"]
[null,null,null,null,"A","B","C",null,"D","E","F",null,"G = A / D / 12","H = B / E","I = C / F"]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D22","v":"RESIDENTIAL SERVICE CLASSIFICATION"},null,{"$f":"'12. Proposed F V Rev Alloc'!J22","v":21779274.704373538},{"$f":"'12. Proposed F V Rev Alloc'!K22","v":0},{"$f":"'12. Proposed F V Rev Alloc'!L22","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!I22","v":51255},{"$f":"'3. Re-Based Bill Det & Rates'!J22","v":379776105},{"$f":"'3. Re-Based Bill Det & Rates'!K22","v":0},null,{"$f":"IF('6. Decision Cost Revenue Adj'!D22=\"No Change\",'5. Re-Based Rev From Rates'!I22,IF(ISERROR(E22/I22/12),0,E22/I22/12))","v":35.409999999999997},{"$f":"IF('6. Decision Cost Revenue Adj'!D22=\"No Change\",'5. Re-Based Rev From Rates'!J22,IF(ISERROR(F22/J22),0,F22/J22))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D22=\"No Change\",'5. Re-Based Rev From Rates'!K22,IF(ISERROR(G22/K22),0,G22/K22))","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D23","v":"GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION"},null,{"$f":"'12. Proposed F V Rev Alloc'!J23","v":2650125.3736766311},{"$f":"'12. Proposed F V Rev Alloc'!K23","v":3880934.7151538166},{"$f":"'12. Proposed F V Rev Alloc'!L23","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!I23","v":5487},{"$f":"'3. Re-Based Bill Det & Rates'!J23","v":171279860},{"$f":"'3. Re-Based Bill Det & Rates'!K23","v":0},null,{"$f":"IF('6. Decision Cost Revenue Adj'!D23=\"No Change\",'5. Re-Based Rev From Rates'!I23,IF(ISERROR(E23/I23/12),0,E23/I23/12))","v":40.248547683564659},{"$f":"IF('6. Decision Cost Revenue Adj'!D23=\"No Change\",'5. Re-Based Rev From Rates'!J23,IF(ISERROR(F23/J23),0,F23/J23))","v":2.2658441658895662E-2},{"$f":"IF('6. Decision Cost Revenue Adj'!D23=\"No Change\",'5. Re-Based Rev From Rates'!K23,IF(ISERROR(G23/K23),0,G23/K23))","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D24","v":"GENERAL SERVICE 50 TO 999 KW SERVICE CLASSIFICATION"},null,{"$f":"'12. Proposed F V Rev Alloc'!J24","v":1322850.5616723839},{"$f":"'12. Proposed F V Rev Alloc'!K24","v":0},{"$f":"'12. Proposed F V Rev Alloc'!L24","v":3771553.3667248827},null,{"$f":"'3. Re-Based Bill Det & Rates'!I24","v":465},{"$f":"'3. Re-Based Bill Det & Rates'!J24","v":285468167},{"$f":"'3. Re-Based Bill Det & Rates'!K24","v":708872},null,{"$f":"IF('6. Decision Cost Revenue Adj'!D24=\"No Change\",'5. Re-Based Rev From Rates'!I24,IF(ISERROR(E24/I24/12),0,E24/I24/12))","v":237.07},{"$f":"IF('6. Decision Cost Revenue Adj'!D24=\"No Change\",'5. Re-Based Rev From Rates'!J24,IF(ISERROR(F24/J24),0,F24/J24))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D24=\"No Change\",'5. Re-Based Rev From Rates'!K24,IF(ISERROR(G24/K24),0,G24/K24))","v":5.3205}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D25","v":"GENERAL SERVICE 1,000 KW OR GREATER SERVICE CLASSIFICATION"},null,{"$f":"'12. Proposed F V Rev Alloc'!J25","v":610547.4128398539},{"$f":"'12. Proposed F V Rev Alloc'!K25","v":0},{"$f":"'12. Proposed F V Rev Alloc'!L25","v":1962340.9532681648},null,{"$f":"'3. Re-Based Bill Det & Rates'!I25","v":15},{"$f":"'3. Re-Based Bill Det & Rates'!J25","v":147499803},{"$f":"'3. Re-Based Bill Det & Rates'!K25","v":472990},null,{"$f":"IF('6. Decision Cost Revenue Adj'!D25=\"No Change\",'5. Re-Based Rev From Rates'!I25,IF(ISERROR(E25/I25/12),0,E25/I25/12))","v":3391.93},{"$f":"IF('6. Decision Cost Revenue Adj'!D25=\"No Change\",'5. Re-Based Rev From Rates'!J25,IF(ISERROR(F25/J25),0,F25/J25))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D25=\"No Change\",'5. Re-Based Rev From Rates'!K25,IF(ISERROR(G25/K25),0,G25/K25))","v":4.1487999999999996}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D26","v":"UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION"},null,{"$f":"'12. Proposed F V Rev Alloc'!J26","v":63555.839775304645},{"$f":"'12. Proposed F V Rev Alloc'!K26","v":54086.296408783273},{"$f":"'12. Proposed F V Rev Alloc'!L26","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!I26","v":432},{"$f":"'3. Re-Based Bill Det & Rates'!J26","v":2088274},{"$f":"'3. Re-Based Bill Det & Rates'!K26","v":0},null,{"$f":"IF('6. Decision Cost Revenue Adj'!D26=\"No Change\",'5. Re-Based Rev From Rates'!I26,IF(ISERROR(E26/I26/12),0,E26/I26/12))","v":12.26},{"$f":"IF('6. Decision Cost Revenue Adj'!D26=\"No Change\",'5. Re-Based Rev From Rates'!J26,IF(ISERROR(F26/J26),0,F26/J26))","v":2.5899999999999999E-2},{"$f":"IF('6. Decision Cost Revenue Adj'!D26=\"No Change\",'5. Re-Based Rev From Rates'!K26,IF(ISERROR(G26/K26),0,G26/K26))","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D27","v":"SENTINEL LIGHTING SERVICE CLASSIFICATION"},null,{"$f":"'12. Proposed F V Rev Alloc'!J27","v":15431.279731392862},{"$f":"'12. Proposed F V Rev Alloc'!K27","v":0},{"$f":"'12. Proposed F V Rev Alloc'!L27","v":2353.3727590356252},null,{"$f":"'3. Re-Based Bill Det & Rates'!I27","v":113},{"$f":"'3. Re-Based Bill Det & Rates'!J27","v":96035},{"$f":"'3. Re-Based Bill Det & Rates'!K27","v":258},null,{"$f":"IF('6. Decision Cost Revenue Adj'!D27=\"No Change\",'5. Re-Based Rev From Rates'!I27,IF(ISERROR(E27/I27/12),0,E27/I27/12))","v":11.38},{"$f":"IF('6. Decision Cost Revenue Adj'!D27=\"No Change\",'5. Re-Based Rev From Rates'!J27,IF(ISERROR(F27/J27),0,F27/J27))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D27=\"No Change\",'5. Re-Based Rev From Rates'!K27,IF(ISERROR(G27/K27),0,G27/K27))","v":9.1216000000000008}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D28","v":"STREET LIGHTING SERVICE CLASSIFICATION"},null,{"$f":"'12. Proposed F V Rev Alloc'!J28","v":361404.19459459471},{"$f":"'12. Proposed F V Rev Alloc'!K28","v":0},{"$f":"'12. Proposed F V Rev Alloc'!L28","v":182631.92562162166},null,{"$f":"'3. Re-Based Bill Det & Rates'!I28","v":13656},{"$f":"'3. Re-Based Bill Det & Rates'!J28","v":5592860},{"$f":"'3. Re-Based Bill Det & Rates'!K28","v":15924},null,{"$f":"IF('6. Decision Cost Revenue Adj'!D28=\"No Change\",'5. Re-Based Rev From Rates'!I28,IF(ISERROR(E28/I28/12),0,E28/I28/12))","v":2.205405405405406},{"$f":"IF('6. Decision Cost Revenue Adj'!D28=\"No Change\",'5. Re-Based Rev From Rates'!J28,IF(ISERROR(F28/J28),0,F28/J28))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D28=\"No Change\",'5. Re-Based Rev From Rates'!K28,IF(ISERROR(G28/K28),0,G28/K28))","v":11.468972972972976}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D29","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF('6. Decision Cost Revenue Adj'!D29=\"No Change\",'5. Re-Based Rev From Rates'!I29,IF(ISERROR(E29/I29/12),0,E29/I29/12))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D29=\"No Change\",'5. Re-Based Rev From Rates'!J29,IF(ISERROR(F29/J29),0,F29/J29))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D29=\"No Change\",'5. Re-Based Rev From Rates'!K29,IF(ISERROR(G29/K29),0,G29/K29))","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D30","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF('6. Decision Cost Revenue Adj'!D30=\"No Change\",'5. Re-Based Rev From Rates'!I30,IF(ISERROR(E30/I30/12),0,E30/I30/12))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D30=\"No Change\",'5. Re-Based Rev From Rates'!J30,IF(ISERROR(F30/J30),0,F30/J30))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D30=\"No Change\",'5. Re-Based Rev From Rates'!K30,IF(ISERROR(G30/K30),0,G30/K30))","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D31","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF('6. Decision Cost Revenue Adj'!D31=\"No Change\",'5. Re-Based Rev From Rates'!I31,IF(ISERROR(E31/I31/12),0,E31/I31/12))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D31=\"No Change\",'5. Re-Based Rev From Rates'!J31,IF(ISERROR(F31/J31),0,F31/J31))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D31=\"No Change\",'5. Re-Based Rev From Rates'!K31,IF(ISERROR(G31/K31),0,G31/K31))","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D32","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF('6. Decision Cost Revenue Adj'!D32=\"No Change\",'5. Re-Based Rev From Rates'!I32,IF(ISERROR(E32/I32/12),0,E32/I32/12))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D32=\"No Change\",'5. Re-Based Rev From Rates'!J32,IF(ISERROR(F32/J32),0,F32/J32))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D32=\"No Change\",'5. Re-Based Rev From Rates'!K32,IF(ISERROR(G32/K32),0,G32/K32))","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D33","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF('6. Decision Cost Revenue Adj'!D33=\"No Change\",'5. Re-Based Rev From Rates'!I33,IF(ISERROR(E33/I33/12),0,E33/I33/12))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D33=\"No Change\",'5. Re-Based Rev From Rates'!J33,IF(ISERROR(F33/J33),0,F33/J33))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D33=\"No Change\",'5. Re-Based Rev From Rates'!K33,IF(ISERROR(G33/K33),0,G33/K33))","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D34","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF('6. Decision Cost Revenue Adj'!D34=\"No Change\",'5. Re-Based Rev From Rates'!I34,IF(ISERROR(E34/I34/12),0,E34/I34/12))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D34=\"No Change\",'5. Re-Based Rev From Rates'!J34,IF(ISERROR(F34/J34),0,F34/J34))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D34=\"No Change\",'5. Re-Based Rev From Rates'!K34,IF(ISERROR(G34/K34),0,G34/K34))","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D35","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF('6. Decision Cost Revenue Adj'!D35=\"No Change\",'5. Re-Based Rev From Rates'!I35,IF(ISERROR(E35/I35/12),0,E35/I35/12))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D35=\"No Change\",'5. Re-Based Rev From Rates'!J35,IF(ISERROR(F35/J35),0,F35/J35))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D35=\"No Change\",'5. Re-Based Rev From Rates'!K35,IF(ISERROR(G35/K35),0,G35/K35))","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D36","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF('6. Decision Cost Revenue Adj'!D36=\"No Change\",'5. Re-Based Rev From Rates'!I36,IF(ISERROR(E36/I36/12),0,E36/I36/12))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D36=\"No Change\",'5. Re-Based Rev From Rates'!J36,IF(ISERROR(F36/J36),0,F36/J36))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D36=\"No Change\",'5. Re-Based Rev From Rates'!K36,IF(ISERROR(G36/K36),0,G36/K36))","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D37","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF('6. Decision Cost Revenue Adj'!D37=\"No Change\",'5. Re-Based Rev From Rates'!I37,IF(ISERROR(E37/I37/12),0,E37/I37/12))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D37=\"No Change\",'5. Re-Based Rev From Rates'!J37,IF(ISERROR(F37/J37),0,F37/J37))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D37=\"No Change\",'5. Re-Based Rev From Rates'!K37,IF(ISERROR(G37/K37),0,G37/K37))","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D38","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF('6. Decision Cost Revenue Adj'!D38=\"No Change\",'5. Re-Based Rev From Rates'!I38,IF(ISERROR(E38/I38/12),0,E38/I38/12))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D38=\"No Change\",'5. Re-Based Rev From Rates'!J38,IF(ISERROR(F38/J38),0,F38/J38))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D38=\"No Change\",'5. Re-Based Rev From Rates'!K38,IF(ISERROR(G38/K38),0,G38/K38))","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D39","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF('6. Decision Cost Revenue Adj'!D39=\"No Change\",'5. Re-Based Rev From Rates'!I39,IF(ISERROR(E39/I39/12),0,E39/I39/12))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D39=\"No Change\",'5. Re-Based Rev From Rates'!J39,IF(ISERROR(F39/J39),0,F39/J39))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D39=\"No Change\",'5. Re-Based Rev From Rates'!K39,IF(ISERROR(G39/K39),0,G39/K39))","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D40","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF('6. Decision Cost Revenue Adj'!D40=\"No Change\",'5. Re-Based Rev From Rates'!I40,IF(ISERROR(E40/I40/12),0,E40/I40/12))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D40=\"No Change\",'5. Re-Based Rev From Rates'!J40,IF(ISERROR(F40/J40),0,F40/J40))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D40=\"No Change\",'5. Re-Based Rev From Rates'!K40,IF(ISERROR(G40/K40),0,G40/K40))","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D41","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF('6. Decision Cost Revenue Adj'!D41=\"No Change\",'5. Re-Based Rev From Rates'!I41,IF(ISERROR(E41/I41/12),0,E41/I41/12))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D41=\"No Change\",'5. Re-Based Rev From Rates'!J41,IF(ISERROR(F41/J41),0,F41/J41))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D41=\"No Change\",'5. Re-Based Rev From Rates'!K41,IF(ISERROR(G41/K41),0,G41/K41))","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D42","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF('6. Decision Cost Revenue Adj'!D42=\"No Change\",'5. Re-Based Rev From Rates'!I42,IF(ISERROR(E42/I42/12),0,E42/I42/12))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D42=\"No Change\",'5. Re-Based Rev From Rates'!J42,IF(ISERROR(F42/J42),0,F42/J42))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D42=\"No Change\",'5. Re-Based Rev From Rates'!K42,IF(ISERROR(G42/K42),0,G42/K42))","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D43","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF('6. Decision Cost Revenue Adj'!D43=\"No Change\",'5. Re-Based Rev From Rates'!I43,IF(ISERROR(E43/I43/12),0,E43/I43/12))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D43=\"No Change\",'5. Re-Based Rev From Rates'!J43,IF(ISERROR(F43/J43),0,F43/J43))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D43=\"No Change\",'5. Re-Based Rev From Rates'!K43,IF(ISERROR(G43/K43),0,G43/K43))","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D44","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF('6. Decision Cost Revenue Adj'!D44=\"No Change\",'5. Re-Based Rev From Rates'!I44,IF(ISERROR(E44/I44/12),0,E44/I44/12))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D44=\"No Change\",'5. Re-Based Rev From Rates'!J44,IF(ISERROR(F44/J44),0,F44/J44))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D44=\"No Change\",'5. Re-Based Rev From Rates'!K44,IF(ISERROR(G44/K44),0,G44/K44))","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D45","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF('6. Decision Cost Revenue Adj'!D45=\"No Change\",'5. Re-Based Rev From Rates'!I45,IF(ISERROR(E45/I45/12),0,E45/I45/12))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D45=\"No Change\",'5. Re-Based Rev From Rates'!J45,IF(ISERROR(F45/J45),0,F45/J45))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D45=\"No Change\",'5. Re-Based Rev From Rates'!K45,IF(ISERROR(G45/K45),0,G45/K45))","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D46","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF('6. Decision Cost Revenue Adj'!D46=\"No Change\",'5. Re-Based Rev From Rates'!I46,IF(ISERROR(E46/I46/12),0,E46/I46/12))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D46=\"No Change\",'5. Re-Based Rev From Rates'!J46,IF(ISERROR(F46/J46),0,F46/J46))","v":0},{"$f":"IF('6. Decision Cost Revenue Adj'!D46=\"No Change\",'5. Re-Based Rev From Rates'!K46,IF(ISERROR(G46/K46),0,G46/K46))","v":0}]

{"sheet":"14. Adjust To Proposed Rates","index":13,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[47,12,47,14],[10,0,10,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Proposed adjustments to Base Service Charge and Distribution Volumetric Rate. Enter the adjustments found in column M and N below into Tab 16 of the IRM Rate Generator Model."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Rate Class",null,"Proposed Base Service Charge","Proposed Base Distribution Volumetric Rate kWh","Proposed Base Distribution Volumetric Rate kW",null,"Current Base Service Charge","Current Base Distribution Volumetric Rate kWh","Current Base Distribution Volumetric Rate kW",null,"Adjustment Required Base Service Charge","Adjustment Required Base Distribution Volumetric Rate kWh","Adjustment Required Base Distribution Volumetric Rate kW"]
[null,null,null,null,"A","B","C",null,"D","E","F",null,"G = A - D","H = B - E","I = C - F"]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D22","v":"RESIDENTIAL SERVICE CLASSIFICATION"},null,{"$f":"'13. Proposed F V Rates'!M22","v":35.409999999999997},{"$f":"'13. Proposed F V Rates'!N22","v":0},{"$f":"'13. Proposed F V Rates'!O22","v":0},null,{"$f":"'5. Re-Based Rev From Rates'!I22","v":35.409999999999997},{"$f":"'5. Re-Based Rev From Rates'!J22","v":0},{"$f":"'5. Re-Based Rev From Rates'!K22","v":0},null,{"$f":"IF(ISERROR(E22-I22),0,E22-I22)","v":0},{"$f":"IF(ISERROR(F22-J22),0,F22-J22)","v":0},{"$f":"IF(ISERROR(G22-K22),0,G22-K22)","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D23","v":"GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION"},null,{"$f":"'13. Proposed F V Rates'!M23","v":40.248547683564659},{"$f":"'13. Proposed F V Rates'!N23","v":2.2658441658895662E-2},{"$f":"'13. Proposed F V Rates'!O23","v":0},null,{"$f":"'5. Re-Based Rev From Rates'!I23","v":40.5},{"$f":"'5. Re-Based Rev From Rates'!J23","v":2.2800000000000001E-2},{"$f":"'5. Re-Based Rev From Rates'!K23","v":0},null,{"$f":"IF(ISERROR(E23-I23),0,E23-I23)","v":-0.25145231643534061},{"$f":"IF(ISERROR(F23-J23),0,F23-J23)","v":-1.4155834110433918E-4},{"$f":"IF(ISERROR(G23-K23),0,G23-K23)","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D24","v":"GENERAL SERVICE 50 TO 999 KW SERVICE CLASSIFICATION"},null,{"$f":"'13. Proposed F V Rates'!M24","v":237.07},{"$f":"'13. Proposed F V Rates'!N24","v":0},{"$f":"'13. Proposed F V Rates'!O24","v":5.3205},null,{"$f":"'5. Re-Based Rev From Rates'!I24","v":237.07},{"$f":"'5. Re-Based Rev From Rates'!J24","v":0},{"$f":"'5. Re-Based Rev From Rates'!K24","v":5.3205},null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D25","v":"GENERAL SERVICE 1,000 KW OR GREATER SERVICE CLASSIFICATION"},null,{"$f":"'13. Proposed F V Rates'!M25","v":3391.93},{"$f":"'13. Proposed F V Rates'!N25","v":0},{"$f":"'13. Proposed F V Rates'!O25","v":4.1487999999999996},null,{"$f":"'5. Re-Based Rev From Rates'!I25","v":3391.93},{"$f":"'5. Re-Based Rev From Rates'!J25","v":0},{"$f":"'5. Re-Based Rev From Rates'!K25","v":4.1487999999999996},null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D26","v":"UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION"},null,{"$f":"'13. Proposed F V Rates'!M26","v":12.26},{"$f":"'13. Proposed F V Rates'!N26","v":2.5899999999999999E-2},{"$f":"'13. Proposed F V Rates'!O26","v":0},null,{"$f":"'5. Re-Based Rev From Rates'!I26","v":12.26},{"$f":"'5. Re-Based Rev From Rates'!J26","v":2.5899999999999999E-2},{"$f":"'5. Re-Based Rev From Rates'!K26","v":0},null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D27","v":"SENTINEL LIGHTING SERVICE CLASSIFICATION"},null,{"$f":"'13. Proposed F V Rates'!M27","v":11.38},{"$f":"'13. Proposed F V Rates'!N27","v":0},{"$f":"'13. Proposed F V Rates'!O27","v":9.1216000000000008},null,{"$f":"'5. Re-Based Rev From Rates'!I27","v":11.38},{"$f":"'5. Re-Based Rev From Rates'!J27","v":0},{"$f":"'5. Re-Based Rev From Rates'!K27","v":9.1216000000000008},null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D28","v":"STREET LIGHTING SERVICE CLASSIFICATION"},null,{"$f":"'13. Proposed F V Rates'!M28","v":2.205405405405406},{"$f":"'13. Proposed F V Rates'!N28","v":0},{"$f":"'13. Proposed F V Rates'!O28","v":11.468972972972976},null,{"$f":"'5. Re-Based Rev From Rates'!I28","v":2.04},{"$f":"'5. Re-Based Rev From Rates'!J28","v":0},{"$f":"'5. Re-Based Rev From Rates'!K28","v":10.6088},null,0.16540540540540594,0,0.86017297297297546]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D29","v":0},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D30","v":0},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D31","v":0},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D32","v":0},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D33","v":0},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D34","v":0},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D35","v":0},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D36","v":0},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D37","v":0},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D38","v":0},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D39","v":0},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D40","v":0},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D41","v":0},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D42","v":0},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D43","v":0},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D44","v":0},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D45","v":0},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D46","v":0},null,null,null,null,null,null,null,null,null,0,0,0]

{"sheet":"RateClasses","index":14,"n_rows":76,"n_cols":14,"rows_kept":76,"cut":false,"hidden":true,"merged":[]}
[]
["Alectra Utilities Corporation-Brampton Rate Zone","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 TO 699 KW SERVICE CLASSIFICATION","GENERAL SERVICE 700 TO 4,999 KW SERVICE CLASSIFICATION","LARGE USE SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION","EMBEDDED DISTRIBUTOR SERVICE CLASSIFICATION","DISTRIBUTED GENERATION [DGEN] SERVICE CLASSIFICATION"]
["Alectra Utilities Corporation-Enersource Rate Zone","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 TO 499 KW SERVICE CLASSIFICATION","GENERAL SERVICE 500 TO 4,999 KW SERVICE CLASSIFICATION","LARGE USE SERVICE CLASSIFICATION - Interval Metered","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Alectra Utilities Corporation-Horizon Utilities Rate Zone","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","LARGE USE SERVICE CLASSIFICATION","LARGE USE WITH DEDICATED ASSETS SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Alectra Utilities Corporation-PowerStream Rate Zone","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","LARGE USE SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Algoma Power Inc.","RESIDENTIAL R1 SERVICE CLASSIFICATION","RESIDENTIAL R2 SERVICE CLASSIFICATION","SEASONAL CUSTOMERS SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Centre Wellington Hydro Ltd.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 TO 2,999 KW SERVICE CLASSIFICATION","GENERAL SERVICE 3,000 TO 4,999 KW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Canadian Niagara Power Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","EMBEDDED DISTRIBUTOR SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Entegrus Powerlines Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","LARGE USE SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION","EMBEDDED DISTRIBUTOR SERVICE CLASSIFICATION"]
["Entegrus Powerlines Inc.-For Former St. Thomas Energy Rate Zone","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Festival Hydro Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","LARGE USE SERVICE CLASSIFICATION - Interval Metered","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Grimsby Power Incorporated","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION","EMBEDDED DISTRIBUTOR SERVICE CLASSIFICATION"]
["Guelph Hydro Electric Systems Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 TO 999 KW SERVICE CLASSIFICATION","GENERAL SERVICE 1,000 TO 4,999 KW SERVICE CLASSIFICATION - Interval Metered","LARGE USE SERVICE CLASSIFICATION - Interval Metered","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Hydro Hawkesbury Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Hydro Ottawa Limited","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 TO 1,499 KW SERVICE CLASSIFICATION","GENERAL SERVICE 1,500 TO 4,999 KW SERVICE CLASSIFICATION","LARGE USE SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["InnPower Corporation","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Kingston Hydro Corporation","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","LARGE USE SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Kitchener-Wilmot Hydro Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","LARGE USE SERVICE CLASSIFICATION - Interval Metered","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION","EMBEDDED DISTRIBUTOR SERVICE CLASSIFICATION"]
["Renfrew Hydro Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Cooperative Hydro Embrun Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Lakefront Utilities Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 TO 2,999 KW SERVICE CLASSIFICATION","GENERAL SERVICE 3,000 TO 4,999 KW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Toronto Hydro-Electric System Limited","RESIDENTIAL SERVICE CLASSIFICATION","COMPETITIVE SECTOR MULTI-UNIT RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 TO 999 KW SERVICE CLASSIFICATION","GENERAL SERVICE 1,000 TO 4,999 KW SERVICE CLASSIFICATION","LARGE USE SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Waterloo North Hydro Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","LARGE USE SERVICE CLASSIFICATION - Interval Metered","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Westario Power Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Whitby Hydro Electric Corporation","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Erie Thames Powerlines Corporation","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 TO 999 KW SERVICE CLASSIFICATION","GENERAL SERVICE 1,000 TO 4,999 KW SERVICE CLASSIFICATION","LARGE USE SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION","EMBEDDED DISTRIBUTOR SERVICE CLASSIFICATION"]
["Entegrus Powerlines Inc.-For Entegrus-Main Rate Zone","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","LARGE USE SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION","EMBEDDED DISTRIBUTOR SERVICE CLASSIFICATION"]
["Lakeland Power Distribution Ltd.-Parry Sound Service Area","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Lakeland Power Distribution Ltd.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Newmarket-Tay Power Distribution Ltd.-For Former Midland Power Utility Rate Zone","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Newmarket-Tay Power Distribution Ltd.-For Newmarket-Tay Power Main Rate Zone","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Bluewater Power Distribution Corporation","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 TO 999 KW SERVICE CLASSIFICATION","GENERAL SERVICE 1,000 TO 4,999 KW SERVICE CLASSIFICATION","LARGE USE SERVICE CLASSIFICATION - Interval Metered","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Atikokan Hydro Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Burlington Hydro Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION - Interval Metered","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["E.L.K. Energy Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION","EMBEDDED DISTRIBUTOR SERVICE CLASSIFICATION"]
["EPCOR Electricity Distribution Ontario Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Essex Powerlines Corporation","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Fort Frances Power Corporation","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Greater Sudbury Hydro Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Halton Hills Hydro Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 TO 999 KW SERVICE CLASSIFICATION","GENERAL SERVICE 1,000 TO 4,999 KW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Hydro One Networks Inc.","YEAR-ROUND URBAN DENSITY - UR SERVICE CLASSIFICATION","YEAR-ROUND MEDIUM DENSITY - R1 SERVICE CLASSIFICATION","YEAR-ROUND LOW DENSITY - R2 SERVICE CLASSIFICATION","SEASONAL SERVICE CLASSIFICATION","URBAN GENERAL SERVICE ENERGY BILLED - UGe SERVICE CLASSIFICATION","GENERAL SERVICE ENERGY BILLED - GSe SERVICE CLASSIFICATION","URBAN GENERAL SERVICE DEMAND BILLED - UGd SERVICE CLASSIFICATION","GENERAL SERVICE DEMAND BILLED - GSd SERVICE CLASSIFICATION","DISTRIBUTED GENERATION - DGen SERVICE CLASSIFICATION","SUB TRANSMISSION - ST SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Hydro One Networks Inc.-Former Haldimand County Hydro Inc. Service Area","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION","EMBEDDED DISTRIBUTOR SERVICE CLASSIFICATION FOR HYDRO ONE NETWORKS INC."]
["Hydro One Networks Inc.-Former Norfolk Power Distribution Inc. Service Area","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Hydro One Networks Inc.-Former Woodstock Hydro Services Inc. Service Area","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 TO 999 KW SERVICE CLASSIFICATION","GENERAL SERVICE GREATER THAN 1,000 KW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Synergy North Corporation-Kenora Rate Zone","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["London Hydro Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION","LARGE USE SERVICE CLASSIFICATION - Interval Metered","STREET LIGHTING SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION"]
["Milton Hydro Distribution Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 TO 999 KW SERVICE CLASSIFICATION","GENERAL SERVICE 1,000 TO 4,999 KW SERVICE CLASSIFICATION","LARGE USE SERVICE CLASSIFICATION - Interval Metered","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["North Bay Hydro Distribution Limited","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 TO 2,999 KW SERVICE CLASSIFICATION","GENERAL SERVICE 3,000 TO 4,999 KW SERVICE CLASSIFICATION - Interval Metered","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Northern Ontario Wires Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Niagara Peninsula Energy Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Orangeville Hydro Limited","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION"]
["Orillia Power Distribution Corporation","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Ottawa River Power Corporation","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION"]
["Peterborough Distribution Incorporated","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","LARGE USE SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Rideau St. Lawrence Distribution Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Sioux Lookout Hydro Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Synergy North Corporation-Thunder Bay Rate Zone ","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 TO 999 KW SERVICE CLASSIFICATION","GENERAL SERVICE 1,000 KW OR GREATER SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["ENWIN Utilities Ltd.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","GENERAL SERVICE 3,000 TO 4,999 KW - INTERMEDIATE USE SERVICE CLASSIFICATION","LARGE USE - REGULAR SERVICE CLASSIFICATION","LARGE USE - 3TS SERVICE CLASSIFICATION","LARGE USE - FORD ANNEX SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Hearst Power Distribution Co. Ltd.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 TO 1,499 KW SERVICE CLASSIFICATION","INTERMEDIATE USER SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["ERTH Power Corporation - ERTH Power Main Rate Zone","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 TO 999 KW SERVICE CLASSIFICATION","GENERAL SERVICE 1,000 TO 4,999 KW SERVICE CLASSIFICATION","LARGE USE SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION","EMBEDDED DISTRIBUTOR SERVICE CLASSIFICATION"]
["Welland Hydro-Electric System Corp.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Wellington North Power Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 TO 999 KW SERVICE CLASSIFICATION","GENERAL SERVICE 1,000 TO 4,999 KW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Tillsonburg Hydro Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 TO 499 KW SERVICE CLASSIFICATION","GENERAL SERVICE 500 TO 1,499 KW SERVICE CLASSIFICATION - Interval Metered","GENERAL SERVICE EQUAL TO OR GREATER THAN 1,500 KW SERVICE CLASSIFICATION - Interval Metered","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Veridian Connections Inc.","RESIDENTIAL SERVICE CLASSIFICATION","SEASONAL RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 TO 2,999 KW SERVICE CLASSIFICATION","GENERAL SERVICE 3,000 TO 4,999 KW SERVICE CLASSIFICATION","LARGE USE SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Wasaga Distribution Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["ERTH POWER CORPORATION – GODERICH RATE ZONE","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 TO 499 KW SERVICE CLASSIFICATION","GENERAL SERVICE 500 TO 4,999 KW SERVICE CLASSIFICATION","LARGE USE SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Oshawa PUC Networks Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 TO 999 KW SERVICE CLASSIFICATION","GENERAL SERVICE 1,000 TO 4,999 KW SERVICE CLASSIFICATION - Interval Metered","LARGE USE SERVICE CLASSIFICATION - Interval Metered","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Brantford Power Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","EMBEDDED DISTRIBUTOR SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION"]
["Oakville Hydro Electricity Distribution Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 TO 999 KW SERVICE CLASSIFICATION","GENERAL SERVICE 1,000 KW AND GREATER SERVICE CLASSIFICATION - Interval Metered","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION","EMBEDDED DISTRIBUTOR SERVICE CLASSIFICATION"]
["Chapleau Public Utilities Corporation","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 kW SERVICE CLASSIFICATION","GENERAL SERVICE 50 TO 4,999 KW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Espanola Regional Hydro Distribution Corporation","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 kW SERVICE CLASSIFICATION","GENERAL SERVICE 50 TO 4,999 KW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Energy+ Inc.-For Former Brant County Power Service Area","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["Energy+ Inc.-For Former Cambridge and North Dumfries Hydro Service Area","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 TO 999 KW SERVICE CLASSIFICATION","GENERAL SERVICE 1,000 TO 4,999 KW SERVICE CLASSIFICATION","LARGE USE SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION","EMBEDDED DISTRIBUTOR SERVICE CLASSIFICATION"]
["Hydro 2000 Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 kW SERVICE CLASSIFICATION","GENERAL SERVICE 50 TO 4,999 KW SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION"]
["Niagara-on-the-Lake Hydro Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]
["PUC Distribution Inc.","RESIDENTIAL SERVICE CLASSIFICATION","GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","SENTINEL LIGHTING SERVICE CLASSIFICATION","STREET LIGHTING SERVICE CLASSIFICATION"]

{"sheet":"F1.2 CalcTaxChg RRider OptA FV","index":15,"n_rows":50,"n_cols":22,"rows_kept":50,"cut":false,"hidden":true,"merged":[[49,19,49,21]]}
[]
[null,null,{"$f":"'1. Info'!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"'1. Info'!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"'1. Info'!#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[null,null,{"$f":"'Z1.0 OEB Control Sheet'!#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Control","Rate Class","Fixed Metric","Vol Metric",null,"Service Charge % Revenue","Distribution Volumetric Rate % Revenue \nkWh","Distribution Volumetric Rate % Revenue \nkW",null,"Service Charge Revenue","Distribution Volumetric Rate Revenue \nkWh","Distribution Volumetric Rate Revenue \nkW","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,null,null,null,null,"A","B","C",null,"D = $N * A","E = $N * B","F = $N * C","G = D + E + F",null,"H","I ","J ",null,"K = D / H / 12","L = E / I","M = F / J"]
[null,1,{"$f":"'3. Re-Based Bill Det & Rates'!D22","v":"RESIDENTIAL SERVICE CLASSIFICATION"},{"$f":"'3. Re-Based Bill Det & Rates'!E22","v":"Customers"},{"$f":"'3. Re-Based Bill Det & Rates'!F22","v":"kWh"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,{"$f":"IF(ISERROR($N$47*G22),\"\",$N$47*G22)","v":""},{"$f":"IF(ISERROR($N$47*H22),\"\",$N$47*H22)","v":""},{"$f":"IF(ISERROR($N$47*I22),\"\",$N$47*I22)","v":""},{"$f":"SUM(K22:M22)","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!I22","v":51255},{"$f":"'3. Re-Based Bill Det & Rates'!J22","v":379776105},{"$f":"'3. Re-Based Bill Det & Rates'!K22","v":0},null,{"$f":"IF(ISERROR(K22/P22/12),\"\",ROUND(K22/P22/12,6))","v":""},{"$f":"IF(ISERROR(L22/Q22),\"\",ROUND(L22/Q22,6))","v":""},{"$f":"IF(ISERROR(M22/R22),\"\",ROUND(M22/R22,6))","v":""}]
[null,2,{"$f":"'3. Re-Based Bill Det & Rates'!D23","v":"GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION"},{"$f":"'3. Re-Based Bill Det & Rates'!E23","v":"Customers"},{"$f":"'3. Re-Based Bill Det & Rates'!F23","v":"kWh"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I23","v":5487},{"$f":"'3. Re-Based Bill Det & Rates'!J23","v":171279860},{"$f":"'3. Re-Based Bill Det & Rates'!K23","v":0},null,{"$f":"IF(ISERROR(K23/P23/12),\"\",ROUND(K23/P23/12,6))","v":""},{"$f":"IF(ISERROR(L23/Q23),\"\",ROUND(L23/Q23,6))","v":""},{"$f":"IF(ISERROR(M23/R23),\"\",ROUND(M23/R23,6))","v":""}]
[null,3,{"$f":"'3. Re-Based Bill Det & Rates'!D24","v":"GENERAL SERVICE 50 TO 999 KW SERVICE CLASSIFICATION"},{"$f":"'3. Re-Based Bill Det & Rates'!E24","v":"Customers"},{"$f":"'3. Re-Based Bill Det & Rates'!F24","v":"kW"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I24","v":465},{"$f":"'3. Re-Based Bill Det & Rates'!J24","v":285468167},{"$f":"'3. Re-Based Bill Det & Rates'!K24","v":708872},null,"","",""]
[null,4,{"$f":"'3. Re-Based Bill Det & Rates'!D25","v":"GENERAL SERVICE 1,000 KW OR GREATER SERVICE CLASSIFICATION"},{"$f":"'3. Re-Based Bill Det & Rates'!E25","v":"Customers"},{"$f":"'3. Re-Based Bill Det & Rates'!F25","v":"kW"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I25","v":15},{"$f":"'3. Re-Based Bill Det & Rates'!J25","v":147499803},{"$f":"'3. Re-Based Bill Det & Rates'!K25","v":472990},null,"","",""]
[null,5,{"$f":"'3. Re-Based Bill Det & Rates'!D26","v":"UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION"},{"$f":"'3. Re-Based Bill Det & Rates'!E26","v":"Connections"},{"$f":"'3. Re-Based Bill Det & Rates'!F26","v":"kWh"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I26","v":432},{"$f":"'3. Re-Based Bill Det & Rates'!J26","v":2088274},{"$f":"'3. Re-Based Bill Det & Rates'!K26","v":0},null,"","",""]
[null,6,{"$f":"'3. Re-Based Bill Det & Rates'!D27","v":"SENTINEL LIGHTING SERVICE CLASSIFICATION"},{"$f":"'3. Re-Based Bill Det & Rates'!E27","v":"Connections"},{"$f":"'3. Re-Based Bill Det & Rates'!F27","v":"kW"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I27","v":113},{"$f":"'3. Re-Based Bill Det & Rates'!J27","v":96035},{"$f":"'3. Re-Based Bill Det & Rates'!K27","v":258},null,"","",""]
[null,7,{"$f":"'3. Re-Based Bill Det & Rates'!D28","v":"STREET LIGHTING SERVICE CLASSIFICATION"},{"$f":"'3. Re-Based Bill Det & Rates'!E28","v":"Connections"},{"$f":"'3. Re-Based Bill Det & Rates'!F28","v":"kW"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I28","v":13656},{"$f":"'3. Re-Based Bill Det & Rates'!J28","v":5592860},{"$f":"'3. Re-Based Bill Det & Rates'!K28","v":15924},null,"","",""]
[null,8,{"$f":"'3. Re-Based Bill Det & Rates'!D29","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E29","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F29","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I29","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J29","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K29","v":0},null,"","",""]
[null,9,{"$f":"'3. Re-Based Bill Det & Rates'!D30","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E30","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F30","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I30","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J30","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K30","v":0},null,"","",""]
[null,10,{"$f":"'3. Re-Based Bill Det & Rates'!D31","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E31","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F31","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I31","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J31","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K31","v":0},null,"","",""]
[null,11,{"$f":"'3. Re-Based Bill Det & Rates'!D32","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E32","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F32","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I32","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J32","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K32","v":0},null,"","",""]
[null,12,{"$f":"'3. Re-Based Bill Det & Rates'!D33","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E33","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F33","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I33","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J33","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K33","v":0},null,"","",""]
[null,13,{"$f":"'3. Re-Based Bill Det & Rates'!D34","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E34","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F34","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I34","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J34","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K34","v":0},null,"","",""]
[null,14,{"$f":"'3. Re-Based Bill Det & Rates'!D35","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E35","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F35","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I35","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J35","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K35","v":0},null,"","",""]
[null,15,{"$f":"'3. Re-Based Bill Det & Rates'!D36","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E36","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F36","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I36","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J36","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K36","v":0},null,"","",""]
[null,16,{"$f":"'3. Re-Based Bill Det & Rates'!D37","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E37","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F37","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I37","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J37","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K37","v":0},null,"","",""]
[null,17,{"$f":"'3. Re-Based Bill Det & Rates'!D38","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E38","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F38","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I38","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J38","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K38","v":0},null,"","",""]
[null,18,{"$f":"'3. Re-Based Bill Det & Rates'!D39","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E39","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F39","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I39","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J39","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K39","v":0},null,"","",""]
[null,19,{"$f":"'3. Re-Based Bill Det & Rates'!D40","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E40","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F40","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I40","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J40","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K40","v":0},null,"","",""]
[null,20,{"$f":"'3. Re-Based Bill Det & Rates'!D41","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E41","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F41","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I41","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J41","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K41","v":0},null,"","",""]
[null,21,{"$f":"'3. Re-Based Bill Det & Rates'!D42","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E42","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F42","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I42","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J42","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K42","v":0},null,"","",""]
[null,22,{"$f":"'3. Re-Based Bill Det & Rates'!D43","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E43","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F43","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I43","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J43","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K43","v":0},null,"","",""]
[null,23,{"$f":"'3. Re-Based Bill Det & Rates'!D44","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E44","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F44","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I44","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J44","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K44","v":0},null,"","",""]
[null,24,{"$f":"'3. Re-Based Bill Det & Rates'!D45","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E45","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F45","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I45","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J45","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K45","v":0},null,"","",""]
[null,25,{"$f":"'3. Re-Based Bill Det & Rates'!D46","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E46","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F46","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I46","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J46","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K46","v":0},null,"","",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K22:K46)","v":0},{"$f":"SUM(L22:L46)","v":0},{"$f":"SUM(M22:M46)","v":0},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N22:N46)-N47","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter the above value onto Sheet \n\"J2.1 Tax Change Rate Rider\" \nof the 2010 OEB IRM3 Rate Generator."]

{"sheet":"G4.2 Incr Cap RRider Opt A FV","index":16,"n_rows":49,"n_cols":22,"rows_kept":49,"cut":false,"hidden":true,"merged":[[48,19,48,21]]}
[]
[null,null,{"$f":"'1. Info'!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"'1. Info'!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"'1. Info'!#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[null,null,{"$f":"'Z1.0 OEB Control Sheet'!#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Control","Rate Class","Fixed Metric","Vol Metric",null,"Service Charge % Revenue","Distribution Volumetric Rate % Revenue \nkWh","Distribution Volumetric Rate % Revenue \nkW",null,"Service Charge Revenue","Distribution Volumetric Rate Revenue \nkWh","Distribution Volumetric Rate Revenue \nkW","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,null,null,null,null,"A","B","C",null,"D = $N * A","E = $N * B","F = $N * C","G = D + E + F",null,"H","I ","J ",null,"K = D / H / 12","L = E / I","M = F / J"]
[null,1,{"$f":"'3. Re-Based Bill Det & Rates'!D22","v":"RESIDENTIAL SERVICE CLASSIFICATION"},{"$f":"'3. Re-Based Bill Det & Rates'!E22","v":"Customers"},{"$f":"'3. Re-Based Bill Det & Rates'!F22","v":"kWh"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,{"$f":"IF(ISERROR($N$47*G22),\"\",$N$47*G22)","v":""},{"$f":"IF(ISERROR($N$47*H22),\"\",$N$47*H22)","v":""},{"$f":"IF(ISERROR($N$47*I22),\"\",$N$47*I22)","v":""},{"$f":"SUM(K22:M22)","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!I22","v":51255},{"$f":"'3. Re-Based Bill Det & Rates'!J22","v":379776105},{"$f":"'3. Re-Based Bill Det & Rates'!K22","v":0},null,{"$f":"IF(ISERROR(K22/P22/12),\"\",ROUND(K22/P22/12,6))","v":""},{"$f":"IF(ISERROR(L22/Q22),\"\",ROUND(L22/Q22,6))","v":""},{"$f":"IF(ISERROR(M22/R22),\"\",ROUND(M22/R22,6))","v":""}]
[null,2,{"$f":"'3. Re-Based Bill Det & Rates'!D23","v":"GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION"},{"$f":"'3. Re-Based Bill Det & Rates'!E23","v":"Customers"},{"$f":"'3. Re-Based Bill Det & Rates'!F23","v":"kWh"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I23","v":5487},{"$f":"'3. Re-Based Bill Det & Rates'!J23","v":171279860},{"$f":"'3. Re-Based Bill Det & Rates'!K23","v":0},null,{"$f":"IF(ISERROR(K23/P23/12),\"\",ROUND(K23/P23/12,6))","v":""},{"$f":"IF(ISERROR(L23/Q23),\"\",ROUND(L23/Q23,6))","v":""},{"$f":"IF(ISERROR(M23/R23),\"\",ROUND(M23/R23,6))","v":""}]
[null,3,{"$f":"'3. Re-Based Bill Det & Rates'!D24","v":"GENERAL SERVICE 50 TO 999 KW SERVICE CLASSIFICATION"},{"$f":"'3. Re-Based Bill Det & Rates'!E24","v":"Customers"},{"$f":"'3. Re-Based Bill Det & Rates'!F24","v":"kW"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I24","v":465},{"$f":"'3. Re-Based Bill Det & Rates'!J24","v":285468167},{"$f":"'3. Re-Based Bill Det & Rates'!K24","v":708872},null,"","",""]
[null,4,{"$f":"'3. Re-Based Bill Det & Rates'!D25","v":"GENERAL SERVICE 1,000 KW OR GREATER SERVICE CLASSIFICATION"},{"$f":"'3. Re-Based Bill Det & Rates'!E25","v":"Customers"},{"$f":"'3. Re-Based Bill Det & Rates'!F25","v":"kW"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I25","v":15},{"$f":"'3. Re-Based Bill Det & Rates'!J25","v":147499803},{"$f":"'3. Re-Based Bill Det & Rates'!K25","v":472990},null,"","",""]
[null,5,{"$f":"'3. Re-Based Bill Det & Rates'!D26","v":"UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION"},{"$f":"'3. Re-Based Bill Det & Rates'!E26","v":"Connections"},{"$f":"'3. Re-Based Bill Det & Rates'!F26","v":"kWh"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I26","v":432},{"$f":"'3. Re-Based Bill Det & Rates'!J26","v":2088274},{"$f":"'3. Re-Based Bill Det & Rates'!K26","v":0},null,"","",""]
[null,6,{"$f":"'3. Re-Based Bill Det & Rates'!D27","v":"SENTINEL LIGHTING SERVICE CLASSIFICATION"},{"$f":"'3. Re-Based Bill Det & Rates'!E27","v":"Connections"},{"$f":"'3. Re-Based Bill Det & Rates'!F27","v":"kW"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I27","v":113},{"$f":"'3. Re-Based Bill Det & Rates'!J27","v":96035},{"$f":"'3. Re-Based Bill Det & Rates'!K27","v":258},null,"","",""]
[null,7,{"$f":"'3. Re-Based Bill Det & Rates'!D28","v":"STREET LIGHTING SERVICE CLASSIFICATION"},{"$f":"'3. Re-Based Bill Det & Rates'!E28","v":"Connections"},{"$f":"'3. Re-Based Bill Det & Rates'!F28","v":"kW"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I28","v":13656},{"$f":"'3. Re-Based Bill Det & Rates'!J28","v":5592860},{"$f":"'3. Re-Based Bill Det & Rates'!K28","v":15924},null,"","",""]
[null,8,{"$f":"'3. Re-Based Bill Det & Rates'!D29","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E29","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F29","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I29","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J29","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K29","v":0},null,"","",""]
[null,9,{"$f":"'3. Re-Based Bill Det & Rates'!D30","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E30","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F30","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I30","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J30","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K30","v":0},null,"","",""]
[null,10,{"$f":"'3. Re-Based Bill Det & Rates'!D31","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E31","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F31","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I31","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J31","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K31","v":0},null,"","",""]
[null,11,{"$f":"'3. Re-Based Bill Det & Rates'!D32","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E32","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F32","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I32","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J32","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K32","v":0},null,"","",""]
[null,12,{"$f":"'3. Re-Based Bill Det & Rates'!D33","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E33","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F33","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I33","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J33","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K33","v":0},null,"","",""]
[null,13,{"$f":"'3. Re-Based Bill Det & Rates'!D34","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E34","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F34","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I34","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J34","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K34","v":0},null,"","",""]
[null,14,{"$f":"'3. Re-Based Bill Det & Rates'!D35","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E35","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F35","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I35","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J35","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K35","v":0},null,"","",""]
[null,15,{"$f":"'3. Re-Based Bill Det & Rates'!D36","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E36","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F36","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I36","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J36","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K36","v":0},null,"","",""]
[null,16,{"$f":"'3. Re-Based Bill Det & Rates'!D37","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E37","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F37","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I37","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J37","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K37","v":0},null,"","",""]
[null,17,{"$f":"'3. Re-Based Bill Det & Rates'!D38","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E38","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F38","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I38","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J38","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K38","v":0},null,"","",""]
[null,18,{"$f":"'3. Re-Based Bill Det & Rates'!D39","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E39","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F39","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I39","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J39","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K39","v":0},null,"","",""]
[null,19,{"$f":"'3. Re-Based Bill Det & Rates'!D40","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E40","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F40","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I40","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J40","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K40","v":0},null,"","",""]
[null,20,{"$f":"'3. Re-Based Bill Det & Rates'!D41","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E41","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F41","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I41","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J41","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K41","v":0},null,"","",""]
[null,21,{"$f":"'3. Re-Based Bill Det & Rates'!D42","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E42","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F42","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I42","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J42","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K42","v":0},null,"","",""]
[null,22,{"$f":"'3. Re-Based Bill Det & Rates'!D43","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E43","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F43","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I43","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J43","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K43","v":0},null,"","",""]
[null,23,{"$f":"'3. Re-Based Bill Det & Rates'!D44","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E44","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F44","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I44","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J44","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K44","v":0},null,"","",""]
[null,24,{"$f":"'3. Re-Based Bill Det & Rates'!D45","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E45","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F45","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I45","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J45","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K45","v":0},null,"","",""]
[null,25,{"$f":"'3. Re-Based Bill Det & Rates'!D46","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!E46","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!F46","v":0},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I46","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!J46","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K46","v":0},null,"","",""]
[null,null,null,null,null,null,{"$f":"SUM(G22:G46)","v":0},{"$f":"SUM(H22:H46)","v":0},{"$f":"SUM(I22:I46)","v":0},null,{"$f":"SUM(K22:K46)","v":0},{"$f":"SUM(L22:L46)","v":0},{"$f":"SUM(M22:M46)","v":0},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N22:N46)-N47","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"N",null,null,null,null,null,"Enter the above value onto Sheet \n\"J1.2 Incremental Cap Fund Adder\" \nof the 2010 OEB IRM3 Rate Generator."]

{"sheet":"Z1.0 OEB Control Sheet","index":17,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["Sheet Number","Assignment","Sheet Title","Core Sheet Name","Chrs","OEB Audit","Purpose of Sheet"]
["Sheet1","A1.1","LDC Information","A1.1 LDC Information",{"$f":"LEN(D2)","v":20},"No","Enter LDC Data"]
["Sheet2","A2.1","Table of Contents","A2.1 Table of Contents",22,"No","Table of Contents"]
["Sheet3","B1.1","Rate Class Selection, Re-Based Billing Determinants & Current Tariff Rates","B1.1 Re-Based Bill Det & Rates",30,"No","Set Up Rate Classes and enter Re-Based Billing Determinants and Current Tariff Rates "]
["Sheet4","B1.2","Removal of Rate Adders","B1.2 Removal of Rate Adders",27,"No","Removal of Rate Adders"]
["Sheet5","B1.3","Calculated Current Revenue From Rates","B1.3 Re-Based Rev From Rates",28,"No","Calculated Current Revenue From Rates"]
["Sheet6","C1.1","Decision - Cost Revenue Adjustments by Rate Class","C1.1 Decision Cost Revenue Adj",30,"No","Decision - Cost Revenue Adjustments by Rate Class"]
["Sheet7","C1.2","Revenue Offsets Allocation","C1.2 Revenue Offsets Allocation",31,"No","Revenue Offsets Allocation"]
["Sheet8","C1.3","Transformer Allowance","C1.3 Transformer Allowance",26,"No","Transformer Allowance"]
["Sheet9","C1.4","Revenue / Cost Ratio Revenue","C1.4 R C Ratio Revenue",22,"No","Revenue / Cost Ratio Revenue"]
["Sheet10","C1.5","Proposed Revenue / Cost  Ratio Adjustment","C1.5 Proposed R C Ratio Adj",27,"No","Proposed Revenue / Cost  Ratio Adjustment"]
["Sheet11","C1.6","Proposed Revenue from Revenue / Cost Ratio Adjustment","C1.6 Proposed Revenue",21,"No","Proposed Revenue from Revenue / Cost Ratio Adjustment"]
["Sheet12","C1.7","Proposed Fixed  Variable  Revenue Allocation","C1.7 Proposed F V Rev Alloc",27,"No","Proposed Fixed  Variable  Revenue Allocation"]
["Sheet13","C1.8","Proposed Fixed and Variable Rates","C1.8 Proposed F V Rates",23,"No","Proposed Fixed and Variable Rates"]
["Sheet14","C1.9","Adjustment required to Proposed Rates","C1.9 Adjust To Proposed Rates",29,"No","Adjustment required to Proposed Rates"]
["Sheet15","Z1.0","OEB Control Sheet","Z1.0 OEB Control Sheet",22,"No","Not Shown"]