{"text_format":"1","workbook":"xlsx","n_sheets":17,"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","F1.2 CalcTaxChg RRider OptA FV","G4.2 Incr Cap RRider Opt A FV","Z1.0 OEB Control Sheet"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":1,"defined_names":14,"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":77,"n_cols":28,"rows_kept":77,"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,"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,"Attawapiskat 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,"Bluewater Power Distribution 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,"Brant County Power"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brantford Power Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Cambridge and North Dumfries Hydro"]
[null,null,null,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. – Eastern Ontario Power/Fort Erie/Port Colborne"]
[null,null,null,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,"COLLUS Power Corp."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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   ","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,"Enersource Hydro Mississauga Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Entegrus Powerlines Inc."]
[null,null,"Assigned EB Number","EB-2012-0150",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,"Erie Thames Powerlines Corp."]
[null,null,"Name and Title","Suzanne Wilson, VP Finance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Espanola Regional Hydro Distribution Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Essex Powerlines Corporation"]
[null,null,"Phone Number","905-353-6004",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 Albany Power Corporation"]
[null,null,"Email Address","suzanne.wilson@npei.ca",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,"Greater Sudbury Hydro Inc."]
[null,null,"Date","2013-05-01",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 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,"Guelph Hydro Electric Systems Inc."]
[null,null,"Last COS Re-based Year",2011,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Haldimand County Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Horizon Utilities Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 Brampton Networks Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 Remote Communities 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,"Innisfil Hydro Dist. Systems Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kashechewan Power Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kenora Hydro Electric Corporation Ltd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Kitchener-Wilmot Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Midland Power Utility Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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."]
[null,null,null,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,"Norfolk 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,"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 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,"Orillia Power Distribution 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,"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,"Parry Sound Power Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Peterborough 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,"PowerStream Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"St. Thomas Energy Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Thunder Bay Hydro Electricity Distribution"]
[null,null,null,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,"Veridian Connections Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Waterloo North Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"West Coast Huron Energy Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Westario Power Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whitby Hydro Electric Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Woodstock Hydro Services 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":51,"rows_kept":59,"cut":false,"hidden":false,"merged":[[9,0,9,12]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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 May 1, 2012 (or subsequent) Tariff of rates and charges.  \n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Control","Rate Group","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,"RES","Residential","Customer","kWh",null,null,46900,462790265,null,null,15.76,1.5800000000000002E-2,null,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,"GSLT50","General Service Less Than 50 kW","Customer","kWh",null,null,4352,122331880,null,null,37.090000000000003,1.35E-2,null,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,"GSGT50","General Service 50 to 4,999 kW","Customer","kW",null,null,848,628090148,1818411,null,177.4,null,4.1886999999999999,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,"USL","Unmetered Scattered Load","Connection","kWh",null,null,465,2335428,null,null,19.170000000000002,1.34E-2,null,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,"Sen","Sentinel Lighting","Connection","kW",null,null,560,292817,809,null,9.76,null,12.178699999999999,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,"SL","Street Lighting","Connection","kW",null,null,12408,7467591,20107,null,0.94,null,3.6880000000000002,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,"NA","Rate Class 7","NA","NA",null,null,null,null,null,null,null,null,null,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,"NA","Rate Class 8","NA","NA",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,"NA","Rate Class 9","NA","NA",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,"NA","Rate Class 10","NA","NA",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,"NA","Rate Class 11","NA","NA",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,"NA","Rate Class 12","NA","NA",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,"NA","Rate Class 13","NA","NA",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,"NA","Rate Class 14","NA","NA",null,null,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,"NA","Rate Class 15","NA","NA",null,null,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,"NA","Rate Class 16","NA","NA",null,null,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,"NA","Rate Class 17","NA","NA",null,null,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,"NA","Rate Class 18","NA","NA",null,null,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,"NA","Rate Class 19","NA","NA",null,null,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,"NA","Rate Class 20","NA","NA",null,null,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,"NA","Rate Class 21","NA","NA",null,null,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,"NA","Rate Class 22","NA","NA",null,null,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,"NA","Rate Class 23","NA","NA",null,null,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,"NA","Rate Class 24","NA","NA",null,null,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,"NA","Rate Class 25","NA","NA",null,null,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":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[9,0,10,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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"},null,{"$f":"'3. Re-Based Bill Det & Rates'!M22","v":15.76},{"$f":"'3. Re-Based Bill Det & Rates'!N22","v":1.5800000000000002E-2},{"$f":"'3. Re-Based Bill Det & Rates'!O22","v":0},null,0,0,0,null,{"$f":"E22-I22","v":15.76},{"$f":"F22-J22","v":1.5800000000000002E-2},{"$f":"G22-K22","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D23","v":"General Service Less Than 50 kW"},null,{"$f":"'3. Re-Based Bill Det & Rates'!M23","v":37.090000000000003},{"$f":"'3. Re-Based Bill Det & Rates'!N23","v":1.35E-2},{"$f":"'3. Re-Based Bill Det & Rates'!O23","v":0},null,0,0,0,null,{"$f":"E23-I23","v":37.090000000000003},{"$f":"F23-J23","v":1.35E-2},{"$f":"G23-K23","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D24","v":"General Service 50 to 4,999 kW"},null,{"$f":"'3. Re-Based Bill Det & Rates'!M24","v":177.4},{"$f":"'3. Re-Based Bill Det & Rates'!N24","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O24","v":4.1886999999999999},null,0,0,0,null,177.4,0,4.1886999999999999]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D25","v":"Unmetered Scattered Load"},null,{"$f":"'3. Re-Based Bill Det & Rates'!M25","v":19.170000000000002},{"$f":"'3. Re-Based Bill Det & Rates'!N25","v":1.34E-2},{"$f":"'3. Re-Based Bill Det & Rates'!O25","v":0},null,0,0,0,null,19.170000000000002,1.34E-2,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D26","v":"Sentinel Lighting"},null,{"$f":"'3. Re-Based Bill Det & Rates'!M26","v":9.76},{"$f":"'3. Re-Based Bill Det & Rates'!N26","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O26","v":12.178699999999999},null,0,0,0,null,9.76,0,12.178699999999999]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D27","v":"Street Lighting"},null,{"$f":"'3. Re-Based Bill Det & Rates'!M27","v":0.94},{"$f":"'3. Re-Based Bill Det & Rates'!N27","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O27","v":3.6880000000000002},null,0,0,0,null,0.94,0,3.6880000000000002]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D28","v":"Rate Class 7"},null,{"$f":"'3. Re-Based Bill Det & Rates'!M28","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!N28","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O28","v":0},null,0,0,0,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D29","v":"Rate Class 8"},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,0,0,0,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D30","v":"Rate Class 9"},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,0,0,0,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D31","v":"Rate Class 10"},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,0,0,0,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D32","v":"Rate Class 11"},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,0,0,0,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D33","v":"Rate Class 12"},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,0,0,0,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D34","v":"Rate Class 13"},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,0,0,0,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D35","v":"Rate Class 14"},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,0,0,0,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D36","v":"Rate Class 15"},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,0,0,0,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D37","v":"Rate Class 16"},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,0,0,0,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D38","v":"Rate Class 17"},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,0,0,0,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D39","v":"Rate Class 18"},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,0,0,0,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D40","v":"Rate Class 19"},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,0,0,0,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D41","v":"Rate Class 20"},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,0,0,0,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D42","v":"Rate Class 21"},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,0,0,0,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D43","v":"Rate Class 22"},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,0,0,0,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D44","v":"Rate Class 23"},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,0,0,0,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D45","v":"Rate Class 24"},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,0,0,0,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D46","v":"Rate Class 25"},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,0,0,0,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"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I22","v":46900},{"$f":"'3. Re-Based Bill Det & Rates'!J22","v":462790265},{"$f":"'3. Re-Based Bill Det & Rates'!K22","v":0},null,{"$f":"'4. Removal of Rate Adders'!M22","v":15.76},{"$f":"'4. Removal of Rate Adders'!N22","v":1.5800000000000002E-2},{"$f":"'4. Removal of Rate Adders'!O22","v":0},null,{"$f":"IF(ISERROR(E22*I22*12),0,E22*I22*12)","v":8869728},{"$f":"IF(ISERROR(F22*J22),0,F22*J22)","v":7312086.1870000008},{"$f":"IF(ISERROR(G22*K22),0,G22*K22)","v":0},{"$f":"SUM(M22:O22)","v":16181814.187000001},null,{"$f":"IF(ISERROR(M22/P22),\"\",M22/P22)","v":0.54812939374410086},{"$f":"IF(ISERROR(N22/P22),\"\",N22/P22)","v":0.4518706062558992},{"$f":"IF(ISERROR(O22/P22),\"\",O22/P22)","v":0},{"$f":"IF(ISERROR(P22/P$47),\"\",P22/P$47)","v":0.54631187658879055}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D23","v":"General Service Less Than 50 kW"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I23","v":4352},{"$f":"'3. Re-Based Bill Det & Rates'!J23","v":122331880},{"$f":"'3. Re-Based Bill Det & Rates'!K23","v":0},null,{"$f":"'4. Removal of Rate Adders'!M23","v":37.090000000000003},{"$f":"'4. Removal of Rate Adders'!N23","v":1.35E-2},{"$f":"'4. Removal of Rate Adders'!O23","v":0},null,{"$f":"IF(ISERROR(E23*I23*12),0,E23*I23*12)","v":1936988.1600000001},{"$f":"IF(ISERROR(F23*J23),0,F23*J23)","v":1651480.38},{"$f":"IF(ISERROR(G23*K23),0,G23*K23)","v":0},{"$f":"SUM(M23:O23)","v":3588468.54},null,{"$f":"IF(ISERROR(M23/P23),\"\",M23/P23)","v":0.53978128508268886},{"$f":"IF(ISERROR(N23/P23),\"\",N23/P23)","v":0.4602187149173112},{"$f":"IF(ISERROR(O23/P23),\"\",O23/P23)","v":0},{"$f":"IF(ISERROR(P23/P$47),\"\",P23/P$47)","v":0.12114976476136922}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D24","v":"General Service 50 to 4,999 kW"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I24","v":848},{"$f":"'3. Re-Based Bill Det & Rates'!J24","v":628090148},{"$f":"'3. Re-Based Bill Det & Rates'!K24","v":1818411},null,{"$f":"'4. Removal of Rate Adders'!M24","v":177.4},{"$f":"'4. Removal of Rate Adders'!N24","v":0},{"$f":"'4. Removal of Rate Adders'!O24","v":4.1886999999999999},null,1805222.4000000001,0,7616778.1557,9422000.5557000004,null,0.19159650748565282,0,0.80840349251434718,0.31809479118480583]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D25","v":"Unmetered Scattered Load"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I25","v":465},{"$f":"'3. Re-Based Bill Det & Rates'!J25","v":2335428},{"$f":"'3. Re-Based Bill Det & Rates'!K25","v":0},null,{"$f":"'4. Removal of Rate Adders'!M25","v":19.170000000000002},{"$f":"'4. Removal of Rate Adders'!N25","v":1.34E-2},{"$f":"'4. Removal of Rate Adders'!O25","v":0},null,106968.6,31294.735200000003,0,138263.3352,null,0.77365846733892474,0.22634153266107529,0,4.6678883618141848E-3]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D26","v":"Sentinel Lighting"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I26","v":560},{"$f":"'3. Re-Based Bill Det & Rates'!J26","v":292817},{"$f":"'3. Re-Based Bill Det & Rates'!K26","v":809},null,{"$f":"'4. Removal of Rate Adders'!M26","v":9.76},{"$f":"'4. Removal of Rate Adders'!N26","v":0},{"$f":"'4. Removal of Rate Adders'!O26","v":12.178699999999999},null,65587.199999999997,0,9852.568299999999,75439.768299999996,null,0.8693982163251156,0,0.13060178367488437,2.5469110516981703E-3]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D27","v":"Street Lighting"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I27","v":12408},{"$f":"'3. Re-Based Bill Det & Rates'!J27","v":7467591},{"$f":"'3. Re-Based Bill Det & Rates'!K27","v":20107},null,{"$f":"'4. Removal of Rate Adders'!M27","v":0.94},{"$f":"'4. Removal of Rate Adders'!N27","v":0},{"$f":"'4. Removal of Rate Adders'!O27","v":3.6880000000000002},null,139962.23999999999,0,74154.616000000009,214116.856,null,0.65367221719340018,0,0.34632778280659982,7.2287680515220479E-3]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D28","v":"Rate Class 7"},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D29","v":"Rate Class 8"},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":"Rate Class 9"},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":"Rate Class 10"},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":"Rate Class 11"},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":"Rate Class 12"},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":"Rate Class 13"},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":"Rate Class 14"},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":"Rate Class 15"},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":"Rate Class 16"},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":"Rate Class 17"},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":"Rate Class 18"},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":"Rate Class 19"},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":"Rate Class 20"},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":"Rate Class 21"},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":"Rate Class 22"},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":"Rate Class 23"},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":"Rate Class 24"},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":"Rate Class 25"},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":12924456.6},{"$f":"SUM(N22:N46)","v":8994861.3022000026},{"$f":"SUM(O22:O46)","v":7700785.3400000008},{"$f":"SUM(P22:P46)","v":29620103.242200002},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,9]]}
[]
[]
[]
[]
[]
[]
["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 2012 IRM3 Supplemental Filing Module or 2012 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: Board 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,2012,2013,{"$f":"IF(ISERROR(F21+1),\"\",F21+1)","v":2014},{"$f":"IF(ISERROR(F21+2),\"\",F21+2)","v":2015},{"$f":"IF(ISERROR(F21+3),\"\",F21+3)","v":2016},{"$f":"IF(ISERROR(F21+4),\"\",F21+4)","v":2017}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D22","v":"Residential"},"No Change",0.85,0,0,0,0,0,null,"No Change"]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D23","v":"General Service Less Than 50 kW"},"No Change",1.091,0,0,0,0,0,null,"Change"]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D24","v":"General Service 50 to 4,999 kW"},"Change",1.4701,1.4601519999999999,1.4601519999999999,1.4601519999999999,1.4601519999999999,1.4601519999999999,null,"Rebalance"]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D25","v":"Unmetered Scattered Load"},"No Change",1.0149999999999999,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D26","v":"Sentinel Lighting"},"Change",0.54100000000000004,0.7,0.7,0.7,0.7,0.7]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D27","v":"Street Lighting"},"Change",0.58899999999999997,0.7,0.7,0.7,0.7,0.7]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D28","v":"Rate Class 7"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D29","v":"Rate Class 8"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D30","v":"Rate Class 9"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D31","v":"Rate Class 10"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D32","v":"Rate Class 11"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D33","v":"Rate Class 12"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D34","v":"Rate Class 13"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D35","v":"Rate Class 14"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D36","v":"Rate Class 15"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D37","v":"Rate Class 16"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D38","v":"Rate Class 17"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D39","v":"Rate Class 18"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D40","v":"Rate Class 19"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D41","v":"Rate Class 20"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D42","v":"Rate Class 21"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D43","v":"Rate Class 22"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D44","v":"Rate Class 23"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D45","v":"Rate Class 24"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D46","v":"Rate Class 25"},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"},1346572,{"$f":"IF(ISERROR(D22/$D$47),0,D22/$D$47)","v":0.68641471096935536},{"$f":"$F$47*E22","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D23","v":"General Service Less Than 50 kW"},274930,{"$f":"IF(ISERROR(D23/$D$47),0,D23/$D$47)","v":0.14014549276741597},{"$f":"$F$47*E23","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D24","v":"General Service 50 to 4,999 kW"},333440,0.16997094936299126,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D25","v":"Unmetered Scattered Load"},2029,1.0342821984690176E-3,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D26","v":"Sentinel Lighting"},1778,9.0633501669685232E-4,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D27","v":"Street Lighting"},2998,1.5282296850715204E-3,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D28","v":"Rate Class 7"},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D29","v":"Rate Class 8"},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D30","v":"Rate Class 9"},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D31","v":"Rate Class 10"},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D32","v":"Rate Class 11"},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D33","v":"Rate Class 12"},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D34","v":"Rate Class 13"},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D35","v":"Rate Class 14"},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D36","v":"Rate Class 15"},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D37","v":"Rate Class 16"},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D38","v":"Rate Class 17"},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D39","v":"Rate Class 18"},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D40","v":"Rate Class 19"},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D41","v":"Rate Class 20"},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D42","v":"Rate Class 21"},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D43","v":"Rate Class 22"},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D44","v":"Rate Class 23"},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D45","v":"Rate Class 24"},0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D46","v":"Rate Class 25"},0,0,0]
[null,null,null,{"$f":"SUM(D22:D46)","v":1961747},{"$f":"SUM(E22:E46)","v":1}]
[null,null,null,"B",null,"D"]

{"sheet":"8. Transformer Allowance","index":7,"n_rows":49,"n_cols":13,"rows_kept":49,"cut":false,"hidden":false,"merged":[[9,0,11,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 2012 IRM3 Supplemental Filing Module 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"},"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"},"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 4,999 kW"},"Yes",{"$f":"IF(ISERROR(F24*G24),0,F24*G24)","v":392475.6},654126,0.6,{"$f":"'5. Re-Based Rev From Rates'!K24","v":4.1886999999999999},{"$f":"'3. Re-Based Bill Det & Rates'!K24","v":1818411},{"$f":"IF(ISERROR((H24*(I24-F24) + (H24-G24)*F24)/I24),0,(H24*(I24-F24) + (H24-G24)*F24)/I24)","v":3.9728656259228528}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D25","v":"Unmetered Scattered Load"},"No"]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D26","v":"Sentinel Lighting"},"No"]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D27","v":"Street Lighting"},"No"]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D28","v":"Rate Class 7"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D29","v":"Rate Class 8"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D30","v":"Rate Class 9"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D31","v":"Rate Class 10"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D32","v":"Rate Class 11"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D33","v":"Rate Class 12"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D34","v":"Rate Class 13"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D35","v":"Rate Class 14"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D36","v":"Rate Class 15"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D37","v":"Rate Class 16"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D38","v":"Rate Class 17"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D39","v":"Rate Class 18"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D40","v":"Rate Class 19"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D41","v":"Rate Class 20"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D42","v":"Rate Class 21"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D43","v":"Rate Class 22"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D44","v":"Rate Class 23"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D45","v":"Rate Class 24"},null,0,0,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D46","v":"Rate Class 25"},null,0,0,0,0,0,0]
[null,null,null,null,392476,{"$f":"SUM(F22:F46)","v":654126},null,null,{"$f":"SUM(I22:I46)","v":1818411}]
[null,null,null,null,"B","D",null,null,"H"]
[null,null,null,null,{"$f":"SUM(E22:E28)-E47","v":-0.40000000002328306}]

{"sheet":"9. R C Ratio Revenue","index":8,"n_rows":48,"n_cols":19,"rows_kept":48,"cut":false,"hidden":false,"merged":[[9,0,10,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I22","v":46900},{"$f":"'3. Re-Based Bill Det & Rates'!J22","v":462790265},{"$f":"'3. Re-Based Bill Det & Rates'!K22","v":0},0,{"$f":"'5. Re-Based Rev From Rates'!I22","v":15.76},{"$f":"'5. Re-Based Rev From Rates'!J22","v":1.5800000000000002E-2},{"$f":"'5. Re-Based Rev From Rates'!K22","v":0},null,{"$f":"E22*I22*12","v":8869728},{"$f":"F22*J22","v":7312086.1870000008},0,{"$f":"SUM(M22:O22)","v":16181814.187000001},null,{"$f":"'7. Revenue Offsets Allocation'!F22","v":0},{"$f":"SUM(P22,R22)","v":16181814.187000001}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D23","v":"General Service Less Than 50 kW"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I23","v":4352},{"$f":"'3. Re-Based Bill Det & Rates'!J23","v":122331880},{"$f":"'3. Re-Based Bill Det & Rates'!K23","v":0},0,{"$f":"'5. Re-Based Rev From Rates'!I23","v":37.090000000000003},{"$f":"'5. Re-Based Rev From Rates'!J23","v":1.35E-2},{"$f":"'5. Re-Based Rev From Rates'!K23","v":0},null,1936988.1600000001,1651480.38,0,3588468.54,null,{"$f":"'7. Revenue Offsets Allocation'!F23","v":0},3588468.54]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D24","v":"General Service 50 to 4,999 kW"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I24","v":848},{"$f":"'3. Re-Based Bill Det & Rates'!J24","v":628090148},{"$f":"'3. Re-Based Bill Det & Rates'!K24","v":1818411},0,{"$f":"'5. Re-Based Rev From Rates'!I24","v":177.4},{"$f":"'5. Re-Based Rev From Rates'!J24","v":0},{"$f":"'8. Transformer Allowance'!J24","v":3.9728656259228528},null,1805222.4000000001,0,7224302.5557000004,9029524.9557000007,null,{"$f":"'7. Revenue Offsets Allocation'!F24","v":0},9029524.9557000007]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D25","v":"Unmetered Scattered Load"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I25","v":465},{"$f":"'3. Re-Based Bill Det & Rates'!J25","v":2335428},{"$f":"'3. Re-Based Bill Det & Rates'!K25","v":0},0,{"$f":"'5. Re-Based Rev From Rates'!I25","v":19.170000000000002},{"$f":"'5. Re-Based Rev From Rates'!J25","v":1.34E-2},{"$f":"'5. Re-Based Rev From Rates'!K25","v":0},null,106968.6,31294.735200000003,0,138263.3352,null,{"$f":"'7. Revenue Offsets Allocation'!F25","v":0},138263.3352]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D26","v":"Sentinel Lighting"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I26","v":560},{"$f":"'3. Re-Based Bill Det & Rates'!J26","v":292817},{"$f":"'3. Re-Based Bill Det & Rates'!K26","v":809},0,{"$f":"'5. Re-Based Rev From Rates'!I26","v":9.76},{"$f":"'5. Re-Based Rev From Rates'!J26","v":0},{"$f":"'5. Re-Based Rev From Rates'!K26","v":12.178699999999999},null,65587.199999999997,0,9852.568299999999,75439.768299999996,null,{"$f":"'7. Revenue Offsets Allocation'!F26","v":0},75439.768299999996]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D27","v":"Street Lighting"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I27","v":12408},{"$f":"'3. Re-Based Bill Det & Rates'!J27","v":7467591},{"$f":"'3. Re-Based Bill Det & Rates'!K27","v":20107},0,{"$f":"'5. Re-Based Rev From Rates'!I27","v":0.94},{"$f":"'5. Re-Based Rev From Rates'!J27","v":0},{"$f":"'5. Re-Based Rev From Rates'!K27","v":3.6880000000000002},null,139962.23999999999,0,74154.616000000009,214116.856,null,{"$f":"'7. Revenue Offsets Allocation'!F27","v":0},214116.856]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D28","v":"Rate Class 7"},null,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D29","v":"Rate Class 8"},null,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D30","v":"Rate Class 9"},null,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D31","v":"Rate Class 10"},null,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D32","v":"Rate Class 11"},null,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D33","v":"Rate Class 12"},null,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D34","v":"Rate Class 13"},null,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D35","v":"Rate Class 14"},null,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D36","v":"Rate Class 15"},null,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D37","v":"Rate Class 16"},null,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D38","v":"Rate Class 17"},null,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D39","v":"Rate Class 18"},null,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D40","v":"Rate Class 19"},null,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D41","v":"Rate Class 20"},null,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D42","v":"Rate Class 21"},null,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D43","v":"Rate Class 22"},null,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D44","v":"Rate Class 23"},null,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D45","v":"Rate Class 24"},null,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D46","v":"Rate Class 25"},null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M22:M46)","v":12924456.6},{"$f":"SUM(N22:N46)","v":8994861.3022000026},{"$f":"SUM(O22:O46)","v":7308309.7400000012},{"$f":"SUM(P22:P46)","v":29227627.642200001},null,{"$f":"SUM(R22:R46)","v":0},{"$f":"SUM(S22:S46)","v":29227627.642200001}]
[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":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Proposed Revenue Cost Ratio Adjustment"]
[]
[]
[]
[]
[]
[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"},{"$f":"'9. R C Ratio Revenue'!S22","v":16181814.187000001},{"$f":"'6. Decision Cost Revenue Adj'!E22","v":0.85},{"$f":"IF(ISERROR(D22/(E22)),0,D22/(E22))","v":19037428.455294117},{"$f":"'6. Decision Cost Revenue Adj'!F22","v":0},{"$f":"IF(ISERROR(F22*(G22)),\"\",F22*(G22))","v":0},null,{"$f":"H22-D22","v":-16181814.187000001},{"$f":"IF(ISERROR(H22/D22-1),0,H22/D22-1)","v":-1}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D23","v":"General Service Less Than 50 kW"},{"$f":"'9. R C Ratio Revenue'!S23","v":3588468.54},{"$f":"'6. Decision Cost Revenue Adj'!E23","v":1.091},3289155.3987167738,{"$f":"'6. Decision Cost Revenue Adj'!F23","v":0},0,null,{"$f":"H23-D23","v":-3588468.54},{"$f":"IF(ISERROR(H23/D23-1),0,H23/D23-1)","v":-1}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D24","v":"General Service 50 to 4,999 kW"},{"$f":"'9. R C Ratio Revenue'!S24","v":9029524.9557000007},{"$f":"'6. Decision Cost Revenue Adj'!E24","v":1.4701},6142116.1524386099,{"$f":"'6. Decision Cost Revenue Adj'!F24","v":1.4601519999999999},8968423.1842155401,null,-61101.771484460682,-6.7668866063534949E-3]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D25","v":"Unmetered Scattered Load"},{"$f":"'9. R C Ratio Revenue'!S25","v":138263.3352},{"$f":"'6. Decision Cost Revenue Adj'!E25","v":1.0149999999999999},136220.03467980298,{"$f":"'6. Decision Cost Revenue Adj'!F25","v":0},0,null,-138263.3352,-1]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D26","v":"Sentinel Lighting"},{"$f":"'9. R C Ratio Revenue'!S26","v":75439.768299999996},{"$f":"'6. Decision Cost Revenue Adj'!E26","v":0.54100000000000004},139445.04306839185,{"$f":"'6. Decision Cost Revenue Adj'!F26","v":0.7},97611.530147874291,null,22171.761847874295,0.29390018484288349]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D27","v":"Street Lighting"},{"$f":"'9. R C Ratio Revenue'!S27","v":214116.856},{"$f":"'6. Decision Cost Revenue Adj'!E27","v":0.58899999999999997},363526.07130730053,{"$f":"'6. Decision Cost Revenue Adj'!F27","v":0.7},254468.24991511035,null,40351.393915110355,0.18845500848896424]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D28","v":"Rate Class 7"},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D29","v":"Rate Class 8"},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D30","v":"Rate Class 9"},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D31","v":"Rate Class 10"},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D32","v":"Rate Class 11"},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D33","v":"Rate Class 12"},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D34","v":"Rate Class 13"},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D35","v":"Rate Class 14"},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D36","v":"Rate Class 15"},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D37","v":"Rate Class 16"},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D38","v":"Rate Class 17"},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D39","v":"Rate Class 18"},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D40","v":"Rate Class 19"},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D41","v":"Rate Class 20"},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D42","v":"Rate Class 21"},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D43","v":"Rate Class 22"},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D44","v":"Rate Class 23"},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D45","v":"Rate Class 24"},0,0,0,0,0,null,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D46","v":"Rate Class 25"},0,0,0,0,0,null,0,0]
[null,null,null,{"$f":"SUM(D22:D46)","v":29227627.642200001},null,{"$f":"SUM(F22:F46)","v":29107891.155504998},null,{"$f":"SUM(H22:H46)","v":9320502.9642785247},null,{"$f":"SUM(J22:J46)","v":-19907124.677921478},-0.68110641484903778]
[]
[null,null,null,null,null,null,"Out of Balance",{"$f":"D47-H47","v":19907124.677921474}]
[]
[null,null,null,null,null,null,"Final ?","No"]

{"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"},{"$f":"IF(('10. Proposed R C Ratio Adj'!H22=\"\"),0,'10. Proposed R C Ratio Adj'!H22)","v":0},{"$f":"'7. Revenue Offsets Allocation'!F22","v":0},{"$f":"D22-E22","v":0},null,{"$f":"'8. Transformer Allowance'!E22","v":0},null,{"$f":"F22+H22","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D23","v":"General Service Less Than 50 kW"},{"$f":"IF(('10. Proposed R C Ratio Adj'!H23=\"\"),0,'10. Proposed R C Ratio Adj'!H23)","v":0},{"$f":"'7. Revenue Offsets Allocation'!F23","v":0},0,null,{"$f":"'8. Transformer Allowance'!E23","v":0},null,{"$f":"F23+H23","v":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D24","v":"General Service 50 to 4,999 kW"},{"$f":"IF(('10. Proposed R C Ratio Adj'!H24=\"\"),0,'10. Proposed R C Ratio Adj'!H24)","v":8968423.1842155401},{"$f":"'7. Revenue Offsets Allocation'!F24","v":0},8968423.1842155401,null,{"$f":"'8. Transformer Allowance'!E24","v":392475.6},null,9360898.7842155397]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D25","v":"Unmetered Scattered Load"},{"$f":"IF(('10. Proposed R C Ratio Adj'!H25=\"\"),0,'10. Proposed R C Ratio Adj'!H25)","v":0},{"$f":"'7. Revenue Offsets Allocation'!F25","v":0},0,null,{"$f":"'8. Transformer Allowance'!E25","v":0},null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D26","v":"Sentinel Lighting"},{"$f":"IF(('10. Proposed R C Ratio Adj'!H26=\"\"),0,'10. Proposed R C Ratio Adj'!H26)","v":97611.530147874291},{"$f":"'7. Revenue Offsets Allocation'!F26","v":0},97611.530147874291,null,{"$f":"'8. Transformer Allowance'!E26","v":0},null,97611.530147874291]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D27","v":"Street Lighting"},{"$f":"IF(('10. Proposed R C Ratio Adj'!H27=\"\"),0,'10. Proposed R C Ratio Adj'!H27)","v":254468.24991511035},{"$f":"'7. Revenue Offsets Allocation'!F27","v":0},254468.24991511035,null,{"$f":"'8. Transformer Allowance'!E27","v":0},null,254468.24991511035]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D28","v":"Rate Class 7"},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D29","v":"Rate Class 8"},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D30","v":"Rate Class 9"},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D31","v":"Rate Class 10"},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D32","v":"Rate Class 11"},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D33","v":"Rate Class 12"},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D34","v":"Rate Class 13"},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D35","v":"Rate Class 14"},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D36","v":"Rate Class 15"},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D37","v":"Rate Class 16"},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D38","v":"Rate Class 17"},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D39","v":"Rate Class 18"},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D40","v":"Rate Class 19"},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D41","v":"Rate Class 20"},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D42","v":"Rate Class 21"},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D43","v":"Rate Class 22"},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D44","v":"Rate Class 23"},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D45","v":"Rate Class 24"},null,null,0,null,null,null,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D46","v":"Rate Class 25"},null,null,0,null,null,null,0]
[null,null,null,{"$f":"SUM(D22:D46)","v":9320502.9642785247},{"$f":"SUM(E22:E46)","v":0},{"$f":"SUM(F22:F46)","v":9320502.9642785247},null,{"$f":"SUM(H22:H46)","v":392475.6},null,{"$f":"SUM(J22:J46)","v":9712978.5642785244}]

{"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"},{"$f":"'11. Proposed Revenue'!J22","v":0},null,{"$f":"'5. Re-Based Rev From Rates'!R22","v":0.54812939374410086},{"$f":"'5. Re-Based Rev From Rates'!S22","v":0.4518706062558992},{"$f":"'5. Re-Based Rev From Rates'!T22","v":0},null,{"$f":"IF(ISERROR($D22*F22),0,$D22*F22)","v":0},{"$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":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D23","v":"General Service Less Than 50 kW"},{"$f":"'11. Proposed Revenue'!J23","v":0},null,{"$f":"'5. Re-Based Rev From Rates'!R23","v":0.53978128508268886},{"$f":"'5. Re-Based Rev From Rates'!S23","v":0.4602187149173112},{"$f":"'5. Re-Based Rev From Rates'!T23","v":0},null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D24","v":"General Service 50 to 4,999 kW"},{"$f":"'11. Proposed Revenue'!J24","v":9360898.7842155397},null,{"$f":"'5. Re-Based Rev From Rates'!R24","v":0.19159650748565282},{"$f":"'5. Re-Based Rev From Rates'!S24","v":0},{"$f":"'5. Re-Based Rev From Rates'!T24","v":0.80840349251434718},null,1793515.513982391,0,7567383.2702331487,9360898.7842155397]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D25","v":"Unmetered Scattered Load"},{"$f":"'11. Proposed Revenue'!J25","v":0},null,{"$f":"'5. Re-Based Rev From Rates'!R25","v":0.77365846733892474},{"$f":"'5. Re-Based Rev From Rates'!S25","v":0.22634153266107529},{"$f":"'5. Re-Based Rev From Rates'!T25","v":0},null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D26","v":"Sentinel Lighting"},{"$f":"'11. Proposed Revenue'!J26","v":97611.530147874291},null,{"$f":"'5. Re-Based Rev From Rates'!R26","v":0.8693982163251156},{"$f":"'5. Re-Based Rev From Rates'!S26","v":0},{"$f":"'5. Re-Based Rev From Rates'!T26","v":0.13060178367488437},null,84863.290203327153,0,12748.239944547133,97611.530147874291]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D27","v":"Street Lighting"},{"$f":"'11. Proposed Revenue'!J27","v":254468.24991511035},null,{"$f":"'5. Re-Based Rev From Rates'!R27","v":0.65367221719340018},{"$f":"'5. Re-Based Rev From Rates'!S27","v":0},{"$f":"'5. Re-Based Rev From Rates'!T27","v":0.34632778280659982},null,166338.82512733445,0,88129.424787775904,254468.24991511035]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D28","v":"Rate Class 7"},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D29","v":"Rate Class 8"},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D30","v":"Rate Class 9"},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D31","v":"Rate Class 10"},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D32","v":"Rate Class 11"},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D33","v":"Rate Class 12"},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D34","v":"Rate Class 13"},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D35","v":"Rate Class 14"},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D36","v":"Rate Class 15"},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D37","v":"Rate Class 16"},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D38","v":"Rate Class 17"},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D39","v":"Rate Class 18"},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D40","v":"Rate Class 19"},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D41","v":"Rate Class 20"},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D42","v":"Rate Class 21"},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D43","v":"Rate Class 22"},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D44","v":"Rate Class 23"},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D45","v":"Rate Class 24"},null,null,null,null,null,null,0,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D46","v":"Rate Class 25"},null,null,null,null,null,null,0,0,0,0]
[null,null,null,{"$f":"SUM(D22:D46)","v":9712978.5642785244},null,null,null,null,null,{"$f":"SUM(J22:J46)","v":2044717.6293130526},{"$f":"SUM(K22:K46)","v":0},{"$f":"SUM(L22:L46)","v":7668260.9349654717},{"$f":"SUM(M22:M46)","v":9712978.5642785244}]

{"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"},null,{"$f":"'12. Proposed F V Rev Alloc'!J22","v":0},{"$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":46900},{"$f":"'3. Re-Based Bill Det & Rates'!J22","v":462790265},{"$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":15.76},{"$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":1.5800000000000002E-2},{"$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"},null,{"$f":"'12. Proposed F V Rev Alloc'!J23","v":0},{"$f":"'12. Proposed F V Rev Alloc'!K23","v":0},{"$f":"'12. Proposed F V Rev Alloc'!L23","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!I23","v":4352},{"$f":"'3. Re-Based Bill Det & Rates'!J23","v":122331880},{"$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":37.090000000000003},{"$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":1.35E-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 4,999 kW"},null,{"$f":"'12. Proposed F V Rev Alloc'!J24","v":1793515.513982391},{"$f":"'12. Proposed F V Rev Alloc'!K24","v":0},{"$f":"'12. Proposed F V Rev Alloc'!L24","v":7567383.2702331487},null,{"$f":"'3. Re-Based Bill Det & Rates'!I24","v":848},{"$f":"'3. Re-Based Bill Det & Rates'!J24","v":628090148},{"$f":"'3. Re-Based Bill Det & Rates'!K24","v":1818411},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":176.2495591570746},{"$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":4.16153623698556}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D25","v":"Unmetered Scattered Load"},null,{"$f":"'12. Proposed F V Rev Alloc'!J25","v":0},{"$f":"'12. Proposed F V Rev Alloc'!K25","v":0},{"$f":"'12. Proposed F V Rev Alloc'!L25","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!I25","v":465},{"$f":"'3. Re-Based Bill Det & Rates'!J25","v":2335428},{"$f":"'3. Re-Based Bill Det & Rates'!K25","v":0},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":19.170000000000002},{"$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":1.34E-2},{"$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":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D26","v":"Sentinel Lighting"},null,{"$f":"'12. Proposed F V Rev Alloc'!J26","v":84863.290203327153},{"$f":"'12. Proposed F V Rev Alloc'!K26","v":0},{"$f":"'12. Proposed F V Rev Alloc'!L26","v":12748.239944547133},null,{"$f":"'3. Re-Based Bill Det & Rates'!I26","v":560},{"$f":"'3. Re-Based Bill Det & Rates'!J26","v":292817},{"$f":"'3. Re-Based Bill Det & Rates'!K26","v":809},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.628465804066542},{"$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":0},{"$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":15.758022181146023}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D27","v":"Street Lighting"},null,{"$f":"'12. Proposed F V Rev Alloc'!J27","v":166338.82512733445},{"$f":"'12. Proposed F V Rev Alloc'!K27","v":0},{"$f":"'12. Proposed F V Rev Alloc'!L27","v":88129.424787775904},null,{"$f":"'3. Re-Based Bill Det & Rates'!I27","v":12408},{"$f":"'3. Re-Based Bill Det & Rates'!J27","v":7467591},{"$f":"'3. Re-Based Bill Det & Rates'!K27","v":20107},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":1.1171477079796264},{"$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":4.3830220713073009}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D28","v":"Rate Class 7"},null,null,null,null,null,null,null,null,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":0},{"$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":0}]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D29","v":"Rate Class 8"},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":"Rate Class 9"},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":"Rate Class 10"},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":"Rate Class 11"},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":"Rate Class 12"},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":"Rate Class 13"},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":"Rate Class 14"},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":"Rate Class 15"},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":"Rate Class 16"},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":"Rate Class 17"},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":"Rate Class 18"},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":"Rate Class 19"},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":"Rate Class 20"},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":"Rate Class 21"},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":"Rate Class 22"},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":"Rate Class 23"},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":"Rate Class 24"},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":"Rate Class 25"},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 Sheet 9 of the 2013 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"},null,{"$f":"'13. Proposed F V Rates'!M22","v":15.76},{"$f":"'13. Proposed F V Rates'!N22","v":1.5800000000000002E-2},{"$f":"'13. Proposed F V Rates'!O22","v":0},null,{"$f":"'5. Re-Based Rev From Rates'!I22","v":15.76},{"$f":"'5. Re-Based Rev From Rates'!J22","v":1.5800000000000002E-2},{"$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"},null,{"$f":"'13. Proposed F V Rates'!M23","v":37.090000000000003},{"$f":"'13. Proposed F V Rates'!N23","v":1.35E-2},{"$f":"'13. Proposed F V Rates'!O23","v":0},null,{"$f":"'5. Re-Based Rev From Rates'!I23","v":37.090000000000003},{"$f":"'5. Re-Based Rev From Rates'!J23","v":1.35E-2},{"$f":"'5. Re-Based Rev From Rates'!K23","v":0},null,{"$f":"IF(ISERROR(E23-I23),0,E23-I23)","v":0},{"$f":"IF(ISERROR(F23-J23),0,F23-J23)","v":0},{"$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 4,999 kW"},null,{"$f":"'13. Proposed F V Rates'!M24","v":176.2495591570746},{"$f":"'13. Proposed F V Rates'!N24","v":0},{"$f":"'13. Proposed F V Rates'!O24","v":4.16153623698556},null,{"$f":"'5. Re-Based Rev From Rates'!I24","v":177.4},{"$f":"'5. Re-Based Rev From Rates'!J24","v":0},{"$f":"'5. Re-Based Rev From Rates'!K24","v":4.1886999999999999},null,-1.1504408429254056,0,-2.7163763014439901E-2]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D25","v":"Unmetered Scattered Load"},null,{"$f":"'13. Proposed F V Rates'!M25","v":19.170000000000002},{"$f":"'13. Proposed F V Rates'!N25","v":1.34E-2},{"$f":"'13. Proposed F V Rates'!O25","v":0},null,{"$f":"'5. Re-Based Rev From Rates'!I25","v":19.170000000000002},{"$f":"'5. Re-Based Rev From Rates'!J25","v":1.34E-2},{"$f":"'5. Re-Based Rev From Rates'!K25","v":0},null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D26","v":"Sentinel Lighting"},null,{"$f":"'13. Proposed F V Rates'!M26","v":12.628465804066542},{"$f":"'13. Proposed F V Rates'!N26","v":0},{"$f":"'13. Proposed F V Rates'!O26","v":15.758022181146023},null,{"$f":"'5. Re-Based Rev From Rates'!I26","v":9.76},{"$f":"'5. Re-Based Rev From Rates'!J26","v":0},{"$f":"'5. Re-Based Rev From Rates'!K26","v":12.178699999999999},null,2.8684658040665418,0,3.5793221811460239]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D27","v":"Street Lighting"},null,{"$f":"'13. Proposed F V Rates'!M27","v":1.1171477079796264},{"$f":"'13. Proposed F V Rates'!N27","v":0},{"$f":"'13. Proposed F V Rates'!O27","v":4.3830220713073009},null,{"$f":"'5. Re-Based Rev From Rates'!I27","v":0.94},{"$f":"'5. Re-Based Rev From Rates'!J27","v":0},{"$f":"'5. Re-Based Rev From Rates'!K27","v":3.6880000000000002},null,0.17714770797962642,0,0.69502207130730076]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D28","v":"Rate Class 7"},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D29","v":"Rate Class 8"},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D30","v":"Rate Class 9"},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D31","v":"Rate Class 10"},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D32","v":"Rate Class 11"},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D33","v":"Rate Class 12"},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D34","v":"Rate Class 13"},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D35","v":"Rate Class 14"},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D36","v":"Rate Class 15"},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D37","v":"Rate Class 16"},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D38","v":"Rate Class 17"},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D39","v":"Rate Class 18"},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D40","v":"Rate Class 19"},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D41","v":"Rate Class 20"},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D42","v":"Rate Class 21"},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D43","v":"Rate Class 22"},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D44","v":"Rate Class 23"},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D45","v":"Rate Class 24"},null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D46","v":"Rate Class 25"},null,null,null,null,null,null,null,null,null,0,0,0]

{"sheet":"F1.2 CalcTaxChg RRider OptA FV","index":14,"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"},{"$f":"'3. Re-Based Bill Det & Rates'!E22","v":"Customer"},{"$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":46900},{"$f":"'3. Re-Based Bill Det & Rates'!J22","v":462790265},{"$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"},{"$f":"'3. Re-Based Bill Det & Rates'!E23","v":"Customer"},{"$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":4352},{"$f":"'3. Re-Based Bill Det & Rates'!J23","v":122331880},{"$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 4,999 kW"},{"$f":"'3. Re-Based Bill Det & Rates'!E24","v":"Customer"},{"$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":848},{"$f":"'3. Re-Based Bill Det & Rates'!J24","v":628090148},{"$f":"'3. Re-Based Bill Det & Rates'!K24","v":1818411},null,"","",""]
[null,4,{"$f":"'3. Re-Based Bill Det & Rates'!D25","v":"Unmetered Scattered Load"},{"$f":"'3. Re-Based Bill Det & Rates'!E25","v":"Connection"},{"$f":"'3. Re-Based Bill Det & Rates'!F25","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'!I25","v":465},{"$f":"'3. Re-Based Bill Det & Rates'!J25","v":2335428},{"$f":"'3. Re-Based Bill Det & Rates'!K25","v":0},null,"","",""]
[null,5,{"$f":"'3. Re-Based Bill Det & Rates'!D26","v":"Sentinel Lighting"},{"$f":"'3. Re-Based Bill Det & Rates'!E26","v":"Connection"},{"$f":"'3. Re-Based Bill Det & Rates'!F26","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'!I26","v":560},{"$f":"'3. Re-Based Bill Det & Rates'!J26","v":292817},{"$f":"'3. Re-Based Bill Det & Rates'!K26","v":809},null,"","",""]
[null,6,{"$f":"'3. Re-Based Bill Det & Rates'!D27","v":"Street Lighting"},{"$f":"'3. Re-Based Bill Det & Rates'!E27","v":"Connection"},{"$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":12408},{"$f":"'3. Re-Based Bill Det & Rates'!J27","v":7467591},{"$f":"'3. Re-Based Bill Det & Rates'!K27","v":20107},null,"","",""]
[null,7,{"$f":"'3. Re-Based Bill Det & Rates'!D28","v":"Rate Class 7"},{"$f":"'3. Re-Based Bill Det & Rates'!E28","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F28","v":"NA"},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":0},{"$f":"'3. Re-Based Bill Det & Rates'!J28","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K28","v":0},null,"","",""]
[null,8,{"$f":"'3. Re-Based Bill Det & Rates'!D29","v":"Rate Class 8"},{"$f":"'3. Re-Based Bill Det & Rates'!E29","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F29","v":"NA"},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":"Rate Class 9"},{"$f":"'3. Re-Based Bill Det & Rates'!E30","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F30","v":"NA"},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":"Rate Class 10"},{"$f":"'3. Re-Based Bill Det & Rates'!E31","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F31","v":"NA"},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":"Rate Class 11"},{"$f":"'3. Re-Based Bill Det & Rates'!E32","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F32","v":"NA"},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":"Rate Class 12"},{"$f":"'3. Re-Based Bill Det & Rates'!E33","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F33","v":"NA"},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":"Rate Class 13"},{"$f":"'3. Re-Based Bill Det & Rates'!E34","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F34","v":"NA"},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":"Rate Class 14"},{"$f":"'3. Re-Based Bill Det & Rates'!E35","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F35","v":"NA"},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":"Rate Class 15"},{"$f":"'3. Re-Based Bill Det & Rates'!E36","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F36","v":"NA"},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":"Rate Class 16"},{"$f":"'3. Re-Based Bill Det & Rates'!E37","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F37","v":"NA"},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":"Rate Class 17"},{"$f":"'3. Re-Based Bill Det & Rates'!E38","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F38","v":"NA"},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":"Rate Class 18"},{"$f":"'3. Re-Based Bill Det & Rates'!E39","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F39","v":"NA"},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":"Rate Class 19"},{"$f":"'3. Re-Based Bill Det & Rates'!E40","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F40","v":"NA"},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":"Rate Class 20"},{"$f":"'3. Re-Based Bill Det & Rates'!E41","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F41","v":"NA"},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":"Rate Class 21"},{"$f":"'3. Re-Based Bill Det & Rates'!E42","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F42","v":"NA"},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":"Rate Class 22"},{"$f":"'3. Re-Based Bill Det & Rates'!E43","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F43","v":"NA"},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":"Rate Class 23"},{"$f":"'3. Re-Based Bill Det & Rates'!E44","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F44","v":"NA"},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":"Rate Class 24"},{"$f":"'3. Re-Based Bill Det & Rates'!E45","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F45","v":"NA"},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":"Rate Class 25"},{"$f":"'3. Re-Based Bill Det & Rates'!E46","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F46","v":"NA"},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":15,"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"},{"$f":"'3. Re-Based Bill Det & Rates'!E22","v":"Customer"},{"$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":46900},{"$f":"'3. Re-Based Bill Det & Rates'!J22","v":462790265},{"$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"},{"$f":"'3. Re-Based Bill Det & Rates'!E23","v":"Customer"},{"$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":4352},{"$f":"'3. Re-Based Bill Det & Rates'!J23","v":122331880},{"$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 4,999 kW"},{"$f":"'3. Re-Based Bill Det & Rates'!E24","v":"Customer"},{"$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":848},{"$f":"'3. Re-Based Bill Det & Rates'!J24","v":628090148},{"$f":"'3. Re-Based Bill Det & Rates'!K24","v":1818411},null,"","",""]
[null,4,{"$f":"'3. Re-Based Bill Det & Rates'!D25","v":"Unmetered Scattered Load"},{"$f":"'3. Re-Based Bill Det & Rates'!E25","v":"Connection"},{"$f":"'3. Re-Based Bill Det & Rates'!F25","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'!I25","v":465},{"$f":"'3. Re-Based Bill Det & Rates'!J25","v":2335428},{"$f":"'3. Re-Based Bill Det & Rates'!K25","v":0},null,"","",""]
[null,5,{"$f":"'3. Re-Based Bill Det & Rates'!D26","v":"Sentinel Lighting"},{"$f":"'3. Re-Based Bill Det & Rates'!E26","v":"Connection"},{"$f":"'3. Re-Based Bill Det & Rates'!F26","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'!I26","v":560},{"$f":"'3. Re-Based Bill Det & Rates'!J26","v":292817},{"$f":"'3. Re-Based Bill Det & Rates'!K26","v":809},null,"","",""]
[null,6,{"$f":"'3. Re-Based Bill Det & Rates'!D27","v":"Street Lighting"},{"$f":"'3. Re-Based Bill Det & Rates'!E27","v":"Connection"},{"$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":12408},{"$f":"'3. Re-Based Bill Det & Rates'!J27","v":7467591},{"$f":"'3. Re-Based Bill Det & Rates'!K27","v":20107},null,"","",""]
[null,7,{"$f":"'3. Re-Based Bill Det & Rates'!D28","v":"Rate Class 7"},{"$f":"'3. Re-Based Bill Det & Rates'!E28","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F28","v":"NA"},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":0},{"$f":"'3. Re-Based Bill Det & Rates'!J28","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!K28","v":0},null,"","",""]
[null,8,{"$f":"'3. Re-Based Bill Det & Rates'!D29","v":"Rate Class 8"},{"$f":"'3. Re-Based Bill Det & Rates'!E29","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F29","v":"NA"},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":"Rate Class 9"},{"$f":"'3. Re-Based Bill Det & Rates'!E30","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F30","v":"NA"},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":"Rate Class 10"},{"$f":"'3. Re-Based Bill Det & Rates'!E31","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F31","v":"NA"},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":"Rate Class 11"},{"$f":"'3. Re-Based Bill Det & Rates'!E32","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F32","v":"NA"},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":"Rate Class 12"},{"$f":"'3. Re-Based Bill Det & Rates'!E33","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F33","v":"NA"},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":"Rate Class 13"},{"$f":"'3. Re-Based Bill Det & Rates'!E34","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F34","v":"NA"},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":"Rate Class 14"},{"$f":"'3. Re-Based Bill Det & Rates'!E35","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F35","v":"NA"},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":"Rate Class 15"},{"$f":"'3. Re-Based Bill Det & Rates'!E36","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F36","v":"NA"},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":"Rate Class 16"},{"$f":"'3. Re-Based Bill Det & Rates'!E37","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F37","v":"NA"},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":"Rate Class 17"},{"$f":"'3. Re-Based Bill Det & Rates'!E38","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F38","v":"NA"},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":"Rate Class 18"},{"$f":"'3. Re-Based Bill Det & Rates'!E39","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F39","v":"NA"},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":"Rate Class 19"},{"$f":"'3. Re-Based Bill Det & Rates'!E40","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F40","v":"NA"},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":"Rate Class 20"},{"$f":"'3. Re-Based Bill Det & Rates'!E41","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F41","v":"NA"},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":"Rate Class 21"},{"$f":"'3. Re-Based Bill Det & Rates'!E42","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F42","v":"NA"},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":"Rate Class 22"},{"$f":"'3. Re-Based Bill Det & Rates'!E43","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F43","v":"NA"},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":"Rate Class 23"},{"$f":"'3. Re-Based Bill Det & Rates'!E44","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F44","v":"NA"},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":"Rate Class 24"},{"$f":"'3. Re-Based Bill Det & Rates'!E45","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F45","v":"NA"},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":"Rate Class 25"},{"$f":"'3. Re-Based Bill Det & Rates'!E46","v":"NA"},{"$f":"'3. Re-Based Bill Det & Rates'!F46","v":"NA"},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":16,"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"]