{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["1. Info","2. Table of Contents","3. Re-Based Bill Det & Rates","4.  Re-Based Rev From Rates","5. Z-Factor Tax Changes","6. Calc Tax Chg RRider Var","Sheet1","G4.2 Incr Cap RRider Opt A FV","Z1.0 OEB Control Sheet"],"not_rendered":{"charts":0,"images":3,"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":78,"n_cols":28,"rows_kept":78,"cut":false,"hidden":false,"merged":[[14,3,14,4],[20,3,20,4],[1,2,1,9],[2,2,2,9],[3,2,3,9],[4,2,4,9]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 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,"Bluewater Power Distribution Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brant County 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,"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 Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Canadian Niagara Power Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Centre Wellington Hydro Ltd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chapleau Public Utilities Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clinton Power Corporation"]
[null,null,null,null,null,null,"Version",1.1000000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COLLUS Power Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cooperative Hydro Embrun Inc."]
[null,null,"Utility Name   ","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,"E.L.K. Energy Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enersource Hydro Mississauga Inc."]
[null,null,"Service Territory Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Entegrus Powerlines 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,"ENWIN Utilities Ltd."]
[null,null,"Assigned EB Number","EB-2013-0176",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 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,"Espanola Regional Hydro Distribution Corporation"]
[null,null,"Name and Title","Albert P. Singh, CFO & Vice-President Administration",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Essex Powerlines Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Festival Hydro Inc."]
[null,null,"Phone Number","519-888-5542",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fort Frances Power Corporation"]
[null,null,"Email Address","asingh@wnhydro.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Greater Sudbury Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grimsby Power Inc."]
[null,null,"Date","2014-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,"Guelph Hydro Electric Systems Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Haldimand County Hydro 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,"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 Company Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Horizon Utilities Corporation"]
["Note:  Drop-down lists are shaded blue; Input cells are shaded green.",null,null,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 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 Distribution Systems Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"North Bay Hydro Distribution Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Northern Ontario Wires Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oakville Hydro Electricity Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orangeville Hydro Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orillia Power Distribution Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 Incorporated"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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,"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,"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,"Thunder Bay Hydro Electricity Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"West Perth Power Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"1. Info"]
[]
[null,null,"2. Table of Contents"]
[]
[null,null,"3. Re-Based Billing Determinants and Rates"]
[]
[null,null,"4. Re-Based Revenue from Rates"]
[]
[null,null,"5. Z-Factor Tax Changes"]
[]
[null,null,"6. Calculation of Tax Change Variable Rate Rider"]

{"sheet":"3. Re-Based Bill Det & Rates","index":2,"n_rows":59,"n_cols":51,"rows_kept":59,"cut":false,"hidden":false,"merged":[[12,0,12,12]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Enter your 2013 Base Monthly Fixed Charge and Distribution Volumetric Charge into columns labeled \"Rate ReBal Base Service Charge\" and \"Rate ReBal Base Distribution Volumetric Rate kWh/kW\" respectively."]
[]
[]
[]
[]
[null,null,{"$f":"\"Last COS Re-based Year was in \" & '1. Info'!D29","v":"Last COS Re-based Year was in 2011"}]
[]
[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,"Rate ReBal Base Service Charge","Rate ReBal Base Distribution Volumetric Rate kWh","Rate ReBal Base 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,46238,393848053.66683358,null,null,14.79,1.8700000000000001E-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,5427.5475781548648,179687810.22845057,null,null,31.11,1.3899999999999999E-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,666.64314649328287,705732689.02312505,1581206.5193224901,null,116.22,null,4.6140999999999996,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,"LU","Large Use","Customer","kW",null,null,1,79638262.482273534,153851.807669359,null,6791.21,null,3.2492000000000001,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,"USL","Unmetered Scattered Load","Connection","kWh",null,null,547.02239356778341,1648665.9189081476,null,null,15.55,1.9300000000000001E-2,null,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,13259.205566319015,7792005.6676361058,21835.28338443664,null,0.33,null,8.4535,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,"EMB","Embedded Distributor","Connection","kW",null,null,1,28618000,71600,null,null,null,1.2200000000000001E-2,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.  Re-Based Rev From Rates","index":3,"n_rows":48,"n_cols":21,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Calculating Re-Based Revenue from rates.  No input required."]
[]
[]
[]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!C18","v":"Last COS Re-based Year was in 2011"}]
[]
[null,null,"Rate Class",null,"Re-based Billed Customers or Connections","Re-based Billed kWh","Re-based Billed kW",null,"Rate ReBal Base Service Charge","Rate ReBal Base Distribution Volumetric Rate kWh","Rate ReBal 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":46238},{"$f":"'3. Re-Based Bill Det & Rates'!J22","v":393848053.66683358},{"$f":"'3. Re-Based Bill Det & Rates'!K22","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!M22","v":14.79},{"$f":"'3. Re-Based Bill Det & Rates'!N22","v":1.8700000000000001E-2},{"$f":"'3. Re-Based Bill Det & Rates'!O22","v":0},null,{"$f":"IF(ISERROR(E22*I22*12),0,E22*I22*12)","v":8206320.2400000002},{"$f":"IF(ISERROR(F22*J22),0,F22*J22)","v":7364958.6035697889},{"$f":"IF(ISERROR(G22*K22),0,G22*K22)","v":0},{"$f":"SUM(M22:O22)","v":15571278.843569789},null,{"$f":"IF(ISERROR(M22/P22),\"\",M22/P22)","v":0.52701645911304373},{"$f":"IF(ISERROR(N22/P22),\"\",N22/P22)","v":0.47298354088695632},{"$f":"IF(ISERROR(O22/P22),\"\",O22/P22)","v":0},{"$f":"IF(ISERROR(P22/P$47),\"\",P22/P$47)","v":0.53191548547913603}]
[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":5427.5475781548648},{"$f":"'3. Re-Based Bill Det & Rates'!J23","v":179687810.22845057},{"$f":"'3. Re-Based Bill Det & Rates'!K23","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!M23","v":31.11},{"$f":"'3. Re-Based Bill Det & Rates'!N23","v":1.3899999999999999E-2},{"$f":"'3. Re-Based Bill Det & Rates'!O23","v":0},null,{"$f":"IF(ISERROR(E23*I23*12),0,E23*I23*12)","v":2026212.0618767743},{"$f":"IF(ISERROR(F23*J23),0,F23*J23)","v":2497660.562175463},{"$f":"IF(ISERROR(G23*K23),0,G23*K23)","v":0},{"$f":"SUM(M23:O23)","v":4523872.6240522377},null,{"$f":"IF(ISERROR(M23/P23),\"\",M23/P23)","v":0.44789326098704441},{"$f":"IF(ISERROR(N23/P23),\"\",N23/P23)","v":0.55210673901295548},{"$f":"IF(ISERROR(O23/P23),\"\",O23/P23)","v":0},{"$f":"IF(ISERROR(P23/P$47),\"\",P23/P$47)","v":0.15453566320676454}]
[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":666.64314649328287},{"$f":"'3. Re-Based Bill Det & Rates'!J24","v":705732689.02312505},{"$f":"'3. Re-Based Bill Det & Rates'!K24","v":1581206.5193224901},null,{"$f":"'3. Re-Based Bill Det & Rates'!M24","v":116.22},{"$f":"'3. Re-Based Bill Det & Rates'!N24","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O24","v":4.6140999999999996},null,929727.19782539201,0,7295845.0008059014,8225572.1986312931,null,0.11302887815878578,0,0.88697112184121429,0.28098586335350656]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D25","v":"Large Use"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I25","v":1},{"$f":"'3. Re-Based Bill Det & Rates'!J25","v":79638262.482273534},{"$f":"'3. Re-Based Bill Det & Rates'!K25","v":153851.807669359},null,{"$f":"'3. Re-Based Bill Det & Rates'!M25","v":6791.21},{"$f":"'3. Re-Based Bill Det & Rates'!N25","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O25","v":3.2492000000000001},null,81494.52,0,499895.29347928124,581389.81347928126,null,0.14017190895090251,0,0.85982809104909752,1.9860298437668924E-2]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D26","v":"Unmetered Scattered Load"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I26","v":547.02239356778341},{"$f":"'3. Re-Based Bill Det & Rates'!J26","v":1648665.9189081476},{"$f":"'3. Re-Based Bill Det & Rates'!K26","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!M26","v":15.55},{"$f":"'3. Re-Based Bill Det & Rates'!N26","v":1.9300000000000001E-2},{"$f":"'3. Re-Based Bill Det & Rates'!O26","v":0},null,102074.37863974839,31819.252234927251,0,133893.63087467564,null,0.76235425070584539,0.23764574929415463,0,4.5738115915044389E-3]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D27","v":"Street Lighting"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I27","v":13259.205566319015},{"$f":"'3. Re-Based Bill Det & Rates'!J27","v":7792005.6676361058},{"$f":"'3. Re-Based Bill Det & Rates'!K27","v":21835.28338443664},null,{"$f":"'3. Re-Based Bill Det & Rates'!M27","v":0.33},{"$f":"'3. Re-Based Bill Det & Rates'!N27","v":0},{"$f":"'3. Re-Based Bill Det & Rates'!O27","v":8.4535},null,52506.4540426233,0,184584.56809033515,237091.02213295846,null,0.2214611652953192,0,0.77853883470468077,8.0990384545502961E-3]
[null,null,{"$f":"'3. Re-Based Bill Det & Rates'!D28","v":"Embedded Distributor"},null,{"$f":"'3. Re-Based Bill Det & Rates'!I28","v":1},{"$f":"'3. Re-Based Bill Det & Rates'!J28","v":28618000},{"$f":"'3. Re-Based Bill Det & Rates'!K28","v":71600},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":1.2200000000000001E-2},null,0,0,873.5200000000001,873.5200000000001,null,0,0,1,2.9839476869146754E-5]
[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":11398334.852384537},{"$f":"SUM(N22:N46)","v":9894438.4179801773},{"$f":"SUM(O22:O46)","v":7981198.3823755179},{"$f":"SUM(P22:P46)","v":29273971.652740236},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":"5. Z-Factor Tax Changes","index":4,"n_rows":53,"n_cols":17,"rows_kept":53,"cut":false,"hidden":false,"merged":[[9,0,9,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["This worksheet calculates the tax sharing amount. \n\nStep 1:  Press the Update Button (this will clear all input cells and reveal your latest cost of service re-basing year).\nStep 2:  In the green input cells below, please enter the information related to the last Cost of Service Filing.\n"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Summary - Sharing of Tax Change Forecast Amounts"]
[]
[null,null,{"$f":"\"For the \" & '1. Info'!D27 & \" year, enter any Tax Credits from the Cost of Service Tax Calculation (Positive #)\"","v":"For the 41760 year, enter any Tax Credits from the Cost of Service Tax Calculation (Positive #)"},null,null,null,null,null,null,null,136997]
[null,null,null,null,null,null,null,null," "]
[]
[null,null,"1. Tax Related Amounts Forecast from Capital Tax Rate Changes ",null,2008,null,2009,null,2010,null,2011,null,2012,null,2013,null,2014]
[]
[null,null,"Taxable Capital",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K25","v":0}]
[]
[null,null,"Deduction from taxable capital up to $15,000,000",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K27","v":0}]
[]
[null,null,"Net Taxable Capital ",null,null,null,null,null,null,null,{"$f":"K25-K27","v":0},null,null,null,null,null,{"$f":"Q25-Q27","v":0}]
[]
[null,null,"Rate",null,null,null,null,null,null,null,0,null,null,null,null,null,0]
[]
[null,null,"Ontario Capital Tax (Deductible, not grossed-up)",null,null,null,null,null,null,null,{"$f":"(IF(K29>0,K29*K31,0))*181/365","v":0},null,null,null,null,null,{"$f":"IF(Q29>0, Q29*Q31, 0)","v":0}]
[]
[null,null,"2. Tax Related Amounts Forecast from lncome Tax Rate Changes ",null,2008,null,2009,null,2010,null,2011,null,2012,null,2013,null,2014]
[null,null,"Regulatory Taxable Income",null,null,null,null,null,null,null,3183169.703824874,null,null,null,null,null,{"$f":"K36","v":3183169.703824874}]
[]
[null,null,"Corporate Tax Rate",null,null,null,null,null,null,null,0.241201689467959,null,null,null,null,null,{"$f":"fedinctax2014(Q36) + OntIncTax2014(Q36)","v":0.25400467042073888}]
[]
[null,null,"Tax Impact ",null,null,null,null,null,null,null,767785.91042578232,null,null,null,null,null,{"$f":"Q36*Q38-K20","v":671542.97151331813}]
[]
[null,null,"Grossed-up Tax Amount",null,null,null,null,null,null,null,1011844.5175338351,null,null,null,null,null,{"$f":"Q40/(1-Q38)","v":900197.28661312943}]
[]
[]
[null,null,"Tax Related Amounts Forecast from Capital Tax Rate Changes ",null,null,null,null,null,null,null,{"$f":"K33","v":0},null,null,null,null,null,{"$f":"Q33","v":0}]
[]
[null,null,"Tax Related Amounts Forecast from lncome Tax Rate Changes ",null,null,null,null,null,null,null,{"$f":"K42","v":1011844.5175338351},null,null,null,null,null,{"$f":"Q42","v":900197.28661312943}]
[]
[null,null,"Total Tax Related Amounts",null,null,null,null,null,null,null,{"$f":"K45+K47","v":1011844.5175338351},null,null,null,null,null,{"$f":"Q45+Q47","v":900197.28661312943}]
[]
[null,null,"Incremental Tax Savings",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q49-K49","v":-111647.23092070571}]
[]
[null,null,"Sharing of Tax Savings (50%)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q51/2","v":-55823.615460352856}]

{"sheet":"6. Calc Tax Chg RRider Var","index":5,"n_rows":49,"n_cols":21,"rows_kept":49,"cut":false,"hidden":false,"merged":[[49,16,49,18],[13,0,13,12]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["This worksheet calculates a tax change volumetric rate rider.  No input required.  The outputs in column Q and S are to be entered into Sheet 11 \"Proposed Rates\" of the 2014 IRM Rate Generator Model.  Rate description should be entered as \"Rate Rider for Tax Change\"."]
[]
[]
[]
[]
[]
[null,"Control","Rate Class","Fixed Metric","Vol Metric",null,"Total Revenue $ by Rate Class",null,"Total Revenue % by Rate Class",null,"Total Z-Factor Tax Change$ by Rate Class",null,"Billed kWh",null,"Billed kW",null,"Distribution Volumetric Rate kWh Rate Rider",null,"Distribution Volumetric Rate kW Rate Rider"]
[null,null,null,null,null,null,"A",null,"B = A / $H",null,"C = $I * B",null,"D",null,"E",null,"F = C / D",null,"G = C / E"]
[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":"'4.  Re-Based Rev From Rates'!P22","v":15571278.843569789},null,{"$f":"IF(ISERROR(G22/$G$47),0,G22/$G$47)","v":0.53191548547913603},null,{"$f":"IF(ISERROR(I22*$K$47),0,I22*$K$47)","v":-29693.445518794193},null,{"$f":"'3. Re-Based Bill Det & Rates'!J22","v":393848053.66683358},null,{"$f":"'3. Re-Based Bill Det & Rates'!K22","v":0},null,{"$f":"IF($E22=\"kWh\",IF(ISERROR($K22/$M22),\"\",ROUND($K22/$M22,4)),\"\")","v":-1E-4},null,{"$f":"IF($E22=\"kW\",IF(ISERROR($K22/$O22),\"\",ROUND($K22/$O22,4)),\"\")","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":"'4.  Re-Based Rev From Rates'!P23","v":4523872.6240522377},null,0.15453566320676454,null,-8626.7394377650235,null,{"$f":"'3. Re-Based Bill Det & Rates'!J23","v":179687810.22845057},null,{"$f":"'3. Re-Based Bill Det & Rates'!K23","v":0},null,{"$f":"IF($E23=\"kWh\",IF(ISERROR($K23/$M23),\"\",ROUND($K23/$M23,4)),\"\")","v":0},null,{"$f":"IF($E23=\"kW\",IF(ISERROR($K23/$O23),\"\",ROUND($K23/$O23,4)),\"\")","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":"'4.  Re-Based Rev From Rates'!P24","v":8225572.1986312931},null,0.28098586335350656,null,-15685.646785641404,null,{"$f":"'3. Re-Based Bill Det & Rates'!J24","v":705732689.02312505},null,{"$f":"'3. Re-Based Bill Det & Rates'!K24","v":1581206.5193224901},null,"",null,-9.9000000000000008E-3]
[null,4,{"$f":"'3. Re-Based Bill Det & Rates'!D25","v":"Large Use"},{"$f":"'3. Re-Based Bill Det & Rates'!E25","v":"Customer"},{"$f":"'3. Re-Based Bill Det & Rates'!F25","v":"kW"},null,{"$f":"'4.  Re-Based Rev From Rates'!P25","v":581389.81347928126},null,1.9860298437668924E-2,null,-1108.6736629122765,null,{"$f":"'3. Re-Based Bill Det & Rates'!J25","v":79638262.482273534},null,{"$f":"'3. Re-Based Bill Det & Rates'!K25","v":153851.807669359},null,"",null,-7.1999999999999998E-3]
[null,5,{"$f":"'3. Re-Based Bill Det & Rates'!D26","v":"Unmetered Scattered Load"},{"$f":"'3. Re-Based Bill Det & Rates'!E26","v":"Connection"},{"$f":"'3. Re-Based Bill Det & Rates'!F26","v":"kWh"},null,{"$f":"'4.  Re-Based Rev From Rates'!P26","v":133893.63087467564},null,4.5738115915044389E-3,null,-255.32669947224829,null,{"$f":"'3. Re-Based Bill Det & Rates'!J26","v":1648665.9189081476},null,{"$f":"'3. Re-Based Bill Det & Rates'!K26","v":0},null,-2.0000000000000001E-4,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":"'4.  Re-Based Rev From Rates'!P27","v":237091.02213295846},null,8.0990384545502961E-3,null,-452.11760828542623,null,{"$f":"'3. Re-Based Bill Det & Rates'!J27","v":7792005.6676361058},null,{"$f":"'3. Re-Based Bill Det & Rates'!K27","v":21835.28338443664},null,"",null,-2.07E-2]
[null,7,{"$f":"'3. Re-Based Bill Det & Rates'!D28","v":"Embedded Distributor"},{"$f":"'3. Re-Based Bill Det & Rates'!E28","v":"Connection"},{"$f":"'3. Re-Based Bill Det & Rates'!F28","v":"kW"},null,{"$f":"'4.  Re-Based Rev From Rates'!P28","v":873.5200000000001},null,2.9839476869146754E-5,null,-1.6657474822813421,null,{"$f":"'3. Re-Based Bill Det & Rates'!J28","v":28618000},null,{"$f":"'3. Re-Based Bill Det & Rates'!K28","v":71600},null,"",null,0]
[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":"'4.  Re-Based Rev From Rates'!P29","v":0},null,0,null,0,null,{"$f":"'3. Re-Based Bill Det & Rates'!J29","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!K29","v":0},null,"",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":"'4.  Re-Based Rev From Rates'!P30","v":0},null,0,null,0,null,{"$f":"'3. Re-Based Bill Det & Rates'!J30","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!K30","v":0},null,"",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":"'4.  Re-Based Rev From Rates'!P31","v":0},null,0,null,0,null,{"$f":"'3. Re-Based Bill Det & Rates'!J31","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!K31","v":0},null,"",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":"'4.  Re-Based Rev From Rates'!P32","v":0},null,0,null,0,null,{"$f":"'3. Re-Based Bill Det & Rates'!J32","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!K32","v":0},null,"",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":"'4.  Re-Based Rev From Rates'!P33","v":0},null,0,null,0,null,{"$f":"'3. Re-Based Bill Det & Rates'!J33","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!K33","v":0},null,"",null,"",null,"aaa"]
[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":"'4.  Re-Based Rev From Rates'!P34","v":0},null,0,null,0,null,{"$f":"'3. Re-Based Bill Det & Rates'!J34","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!K34","v":0},null,"",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":"'4.  Re-Based Rev From Rates'!P35","v":0},null,0,null,0,null,{"$f":"'3. Re-Based Bill Det & Rates'!J35","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!K35","v":0},null,"",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":"'4.  Re-Based Rev From Rates'!P36","v":0},null,0,null,0,null,{"$f":"'3. Re-Based Bill Det & Rates'!J36","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!K36","v":0},null,"",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":"'4.  Re-Based Rev From Rates'!P37","v":0},null,0,null,0,null,{"$f":"'3. Re-Based Bill Det & Rates'!J37","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!K37","v":0},null,"",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":"'4.  Re-Based Rev From Rates'!P38","v":0},null,0,null,0,null,{"$f":"'3. Re-Based Bill Det & Rates'!J38","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!K38","v":0},null,"",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":"'4.  Re-Based Rev From Rates'!P39","v":0},null,0,null,0,null,{"$f":"'3. Re-Based Bill Det & Rates'!J39","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!K39","v":0},null,"",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":"'4.  Re-Based Rev From Rates'!P40","v":0},null,0,null,0,null,{"$f":"'3. Re-Based Bill Det & Rates'!J40","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!K40","v":0},null,"",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":"'4.  Re-Based Rev From Rates'!P41","v":0},null,0,null,0,null,{"$f":"'3. Re-Based Bill Det & Rates'!J41","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!K41","v":0},null,"",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":"'4.  Re-Based Rev From Rates'!P42","v":0},null,0,null,0,null,{"$f":"'3. Re-Based Bill Det & Rates'!J42","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!K42","v":0},null,"",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":"'4.  Re-Based Rev From Rates'!P43","v":0},null,0,null,0,null,{"$f":"'3. Re-Based Bill Det & Rates'!J43","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!K43","v":0},null,"",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":"'4.  Re-Based Rev From Rates'!P44","v":0},null,0,null,0,null,{"$f":"'3. Re-Based Bill Det & Rates'!J44","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!K44","v":0},null,"",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":"'4.  Re-Based Rev From Rates'!P45","v":0},null,0,null,0,null,{"$f":"'3. Re-Based Bill Det & Rates'!J45","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!K45","v":0},null,"",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":"'4.  Re-Based Rev From Rates'!P46","v":0},null,0,null,0,null,{"$f":"'3. Re-Based Bill Det & Rates'!J46","v":0},null,{"$f":"'3. Re-Based Bill Det & Rates'!K46","v":0},null,"",null,""]
[null,null,null,null,null,null,{"$f":"SUM(G22:G46)","v":29273971.652740236},null,{"$f":"SUM(I22:I46)","v":0.99999999999999989},null,{"$f":"'5. Z-Factor Tax Changes'!Q53","v":-55823.615460352856}]
[null,null,null,null,null,null,"H",null,null,null,{"$f":"SUM(K22:K46)-K47","v":0}]
[null,null,null,null,null,null,null,null,null,null,"I "]

{"sheet":"Sheet1","index":6,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Ontario Small Business Deduction"]
[null,2008,2009,2010,2011,2012,2013,2014]
[]
["Ontario tax rate",0.14000000000000001,0.14000000000000001,0.13,0.11749999999999999,0.1125,0.105,0.1]
["Ontario small business deduction rate",8.5000000000000006E-2,8.5000000000000006E-2,0.08,7.2499999999999995E-2,6.7500000000000004E-2,0.06,5.5E-2]
["Ontario small business rate",{"$f":"B4-B5","v":5.5000000000000007E-2},5.5000000000000007E-2,0.05,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.5000000000000005E-2]
[]
["Ontario small business limit",500000,500000,500000,500000,500000,500000,500000]
[]
["Small business deduction",{"$f":"B5*B8","v":42500},42500,40000,36250,33750,30000,27500]

{"sheet":"G4.2 Incr Cap RRider Opt A FV","index":7,"n_rows":49,"n_cols":22,"rows_kept":49,"cut":false,"hidden":true,"merged":[[48,19,48,21]]}
[]
[null,null,{"$f":"'1. Info'!C2","v":0}]
[null,null,{"$f":"'1. Info'!C3","v":0}]
[null,null,{"$f":"'1. Info'!C4","v":0}]
[]
[]
[]
[]
[]
[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":46238},{"$f":"'3. Re-Based Bill Det & Rates'!J22","v":393848053.66683358},{"$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":5427.5475781548648},{"$f":"'3. Re-Based Bill Det & Rates'!J23","v":179687810.22845057},{"$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":666.64314649328287},{"$f":"'3. Re-Based Bill Det & Rates'!J24","v":705732689.02312505},{"$f":"'3. Re-Based Bill Det & Rates'!K24","v":1581206.5193224901},null,"","",""]
[null,4,{"$f":"'3. Re-Based Bill Det & Rates'!D25","v":"Large Use"},{"$f":"'3. Re-Based Bill Det & Rates'!E25","v":"Customer"},{"$f":"'3. Re-Based Bill Det & Rates'!F25","v":"kW"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I25","v":1},{"$f":"'3. Re-Based Bill Det & Rates'!J25","v":79638262.482273534},{"$f":"'3. Re-Based Bill Det & Rates'!K25","v":153851.807669359},null,"","",""]
[null,5,{"$f":"'3. Re-Based Bill Det & Rates'!D26","v":"Unmetered Scattered Load"},{"$f":"'3. Re-Based Bill Det & Rates'!E26","v":"Connection"},{"$f":"'3. Re-Based Bill Det & Rates'!F26","v":"kWh"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I26","v":547.02239356778341},{"$f":"'3. Re-Based Bill Det & Rates'!J26","v":1648665.9189081476},{"$f":"'3. Re-Based Bill Det & Rates'!K26","v":0},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":13259.205566319015},{"$f":"'3. Re-Based Bill Det & Rates'!J27","v":7792005.6676361058},{"$f":"'3. Re-Based Bill Det & Rates'!K27","v":21835.28338443664},null,"","",""]
[null,7,{"$f":"'3. Re-Based Bill Det & Rates'!D28","v":"Embedded Distributor"},{"$f":"'3. Re-Based Bill Det & Rates'!E28","v":"Connection"},{"$f":"'3. Re-Based Bill Det & Rates'!F28","v":"kW"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'3. Re-Based Bill Det & Rates'!I28","v":1},{"$f":"'3. Re-Based Bill Det & Rates'!J28","v":28618000},{"$f":"'3. Re-Based Bill Det & Rates'!K28","v":71600},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":8,"n_rows":9,"n_cols":7,"rows_kept":9,"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"]
["Sheet5","B1.1","Rate Class and Re-Based Billing Determinants & Rates","B1.1 Re-Based Bill Det & Rates",30,"No","Set Up Rate Classes and enter Re-Based Billing Determinants and Tariff Rates "]
["Sheet7","B1.3","Calculated Re-Based Revenue From Rates","B1.3 Re-Based Rev From Rates",28,"No","Calculated Re-Based Revenue From Rates"]
["Sheet23","F1.1","Z-Factor Tax Changes","F1.1 Z-Factor Tax Changes",25,"No","Sharing formula for Tax changes - this is very preliminary"]
["Sheet24","F1.2","Calculate Tax Change Rate Rider Option A Fixed and Volumetric","F1.2 CalcTaxChg RRider OptA FV",30,"No","Option A - Calculation of Tax Sharing Rate Rider - Fixed Variable Split"]
["Sheet25","F1.3","Calculate Tax Change Rate Rider Volumetric","F1.3 Calc Tax Chg RRider Var",28,"No","Option B - Calculation of Tax Sharing Rate Rider - Volumetric Allocation"]
["Sheet32","Z1.0","OEB Control Sheet","Z1.0 OEB Control Sheet",22,"N/A","Not Shown"]