{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["1. Info","2. Table of Contents","3. Rate Classes","4. RRR Data","5. UTRs and Sub-Transmission","6. Historical Wholesale","7. Current Wholesale","8. Forecast Wholesale","9. RTSR Rates to Forecast","hidden1"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":2,"defined_names":20,"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":75,"n_cols":28,"rows_kept":75,"cut":false,"hidden":false,"merged":[[16,3,16,4],[20,3,20,4],[24,3,24,4],[1,2,1,9],[2,2,2,9],[3,2,3,9],[4,2,4,9],[14,3,14,4]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alectra Utilities Corporation - Enersource 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,"Alectra Utilities Corporation - Horizon Utilities"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alectra Utilities Corporation - Hydro One Brampton "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alectra Utilities Corporation - PowerStream 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,"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,"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,"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."]
["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,"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 PowerStream Corporation"]
[null,null,"Utility Name   ","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,"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,"Service Territory","Ottawa, ON",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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,"Entegrus Powerlines Inc."]
[null,null,"Assigned EB Number","EB-2018-0044 (Year 2019)",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 Corporation"]
[null,null,"Name and Title","Gregory Van Dusen  Director, Regulatory Affairs",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","613-738-5499 ext. 7472",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","RegulatoryAffairs@HydroOttawa.com",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","Original",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",2016,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,"Hydro 2000 Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro Hawkesbury Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro One Networks Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro One Networks Inc. - Haldimand County 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,"Hydro One Networks Inc. - Norfolk 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,"Hydro One Networks Inc. - Woodstock 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,"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,"Innpower Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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,"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,"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,"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,"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"]

{"sheet":"2. Table of Contents","index":1,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"1. Info",null,null,null,null,"6. Historical Wholesale"]
[]
[null,null,null,"2. Table of Contents",null,null,null,null,"7. Current Wholesale"]
[]
[null,null,null,"3. Rate Classes",null,null,null,null,"8. Forecast Wholesale"]
[]
[null,null,null,"4. RRR Data",null,null,null,null,"9. RTSR Rates to Forecast"]
[]
[null,null,null,"5. UTRs and Sub-Transmission"]

{"sheet":"3. Rate Classes","index":2,"n_rows":100,"n_cols":23,"rows_kept":100,"cut":false,"hidden":false,"merged":[[12,2,12,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"1.  Select the appropriate rate classes that appear on your most recent Board-Approved Tariff of Rates and Charges.\n2.  Enter the RTS Network and Connection Rate as it appears on the Tariff of Rates and Charges"]
[]
[null,null,"Rate Class",null,"Unit",null,"RTSR-Network",null,"RTSR-Connection"]
[]
[null,null,"Residential",null,"kWh",null,7.1999999999999998E-3,null,4.8999999999999998E-3,null,null,{"$f":"IF(OR(ISBLANK(C17), ISERROR(FIND(\"Choose\", C17))=FALSE), 0, 1)","v":1},{"$f":"\"C\" & ROW(C17)","v":"C17"},{"$f":"IF(OR(C17=\"General Service Intermediate Rate Class 1,000 To 4,999 kW (formerly General Service > 50 kW Customers)\", C17=\"General Service Intermediate Rate Class 1,000 To 4,999 kW (formerly Large Use Customers)\"), \"x\", \"\")","v":""},null,null,null,null,null,null,null,null,"Choose Rate Class"]
[null,null,"General Service Less Than 50 kW",null,"kWh",null,6.7000000000000002E-3,null,4.7000000000000002E-3,null,null,1,"C18",{"$f":"IF(OR(C18=\"General Service Intermediate Rate Class 1,000 To 4,999 kW (formerly General Service > 50 kW Customers)\", C18=\"General Service Intermediate Rate Class 1,000 To 4,999 kW (formerly Large Use Customers)\"), \"x\", \"\")","v":""},null,null,null,null,null,null,null,null,"Residential"]
[null,null,"General Service 50 to 1,499 kW",null,"kW",null,2.7422,null,1.9100999999999999,null,null,1,"C19","",null,null,null,null,null,null,null,null,"Residential Regular"]
[null,null,"General Service 1,500 to 4,999 kW",null,"kW",null,2.8472,null,2.0413999999999999,null,null,1,"C20","",null,null,null,null,null,null,null,null,"Residential Urban"]
[null,null,"Large Use > 5000 kW",null,"kW",null,3.1562999999999999,null,2.2989000000000002,null,null,1,"C21","",null,null,null,null,null,null,null,null,"Residential Urban Year-Round"]
[null,null,"Unmetered Scattered Load",null,"kWh",null,6.7000000000000002E-3,null,4.7000000000000002E-3,null,null,1,"C22","",null,null,null,null,null,null,null,null,"Residential Suburban"]
[null,null,"Sentinel Lighting",null,"kW",null,2.0243000000000002,null,1.419,null,null,1,"C23","",null,null,null,null,null,null,null,null,"Residential Suburban Seasonal"]
[null,null,"Street Lighting",null,"kW",null,2.0345,null,1.4486000000000001,null,null,1,"C24","",null,null,null,null,null,null,null,null,"Residential Suburban Year Round"]
[null,null,"Choose Rate Class",null,null,null,null,null,null,null,null,0,"C25","",null,null,null,null,null,null,null,null,"Residential - Time of Use"]
[null,null,"Choose Rate Class",null,null,null,null,null,null,null,null,0,"C26","",null,null,null,null,null,null,null,null,"Residential - Hensall"]
[null,null,"Choose Rate Class",null,null,null,null,null,null,null,null,0,"C27","",null,null,null,null,null,null,null,null,"Residential – High Density [R1]"]
[null,null,"Choose Rate Class",null,null,null,null,null,null,null,null,0,"C28","",null,null,null,null,null,null,null,null,"Residential – Normal Density [R2]"]
[null,null,"Choose Rate Class",null,null,null,null,null,null,null,null,0,"C29","",null,null,null,null,null,null,null,null,"Seasonal Residential – High Density [R3]"]
[null,null,"Choose Rate Class",null,null,null,null,null,null,null,null,0,"C30","",null,null,null,null,null,null,null,null,"Seasonal Residential – Normal Density [R4]"]
[null,null,"Choose Rate Class",null,null,null,null,null,null,null,null,0,"C31","",null,null,null,null,null,null,null,null,"Residential – Urban [UR]"]
[null,null,"Choose Rate Class",null,null,null,null,null,null,null,null,0,"C32","",null,null,null,null,null,null,null,null,"General Service Less Than 50 kW"]
[null,null,"Choose Rate Class",null,null,null,null,null,null,null,null,0,"C33","",null,null,null,null,null,null,null,null,"General Service Less Than 50 kW – Single Phase energy-billed [G1]"]
[null,null,"Choose Rate Class",null,null,null,null,null,null,null,null,0,"C34","",null,null,null,null,null,null,null,null,"General Service Less Than 50 kW – Three Phase energy-billed [G3]"]
[null,null,"Choose Rate Class",null,null,null,null,null,null,null,null,0,"C35","",null,null,null,null,null,null,null,null,"General Service Less Than 50 kW – Transmission Class energy-billed [T]"]
[null,null,"Choose Rate Class",null,null,null,null,null,null,null,null,0,"C36","",null,null,null,null,null,null,null,null,"General Service Less Than 50 kW – Urban energy-billed [UG]"]
[null,null,"Choose Rate Class",null,null,null,null,null,null,null,null,0,"C37","",null,null,null,null,null,null,null,null,"Westport Sewage Treatment Plant"]
[null,null,"Choose Rate Class",null,null,null,null,null,null,null,null,0,"C38","",null,null,null,null,null,null,null,null,"Small Commercial and USL - per meter"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N17:N38, \"x\")","v":0},null,null,null,null,null,null,null,null,"Small Commercial and USL - per connection"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Farms – Single Phase energy-billed [F1]"]
[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 499 kW"]
[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 699 kW"]
[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 999 kW"]
[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 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,"General Service 50 to 1,000 kW"]
[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 1,000 kW - Interval Meters"]
[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 1,000 kW - Non Interval Meters"]
[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 1,499 kW"]
[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 1,499 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,"General Service  50 to 2,499 kW"]
[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 2,999 kW"]
[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 2,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,"General Service 50 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,"General Service 50 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,"General Service 50 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,"General Service 50 to 4,999 kW (CoGeneration)"]
[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)"]
[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"]
[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"]
[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"]
[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"]
[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"]
[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)"]
[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"]
[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)"]
[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)"]
[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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"Farms – Three Phase energy-billed [F3]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Large Use"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Large Use - Regular"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Large Use > 5000 kW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Large Use - 3TS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Large Use - Ford Annex"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unmetered Scattered Load"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sentinel Lighting"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Street Lighting"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Embedded Distributor"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low Voltage Wheeling Charge Rate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stand-By"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standby Power"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standby Power – INTERIM APPROVAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standby Power - APPROVED ON AN INTERIM BASIS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standby - General Service 50 - 1,000 kW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standby Power General Service 50 to 1,499 kW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standby - General Service 1,000 - 5,000 kW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standby Power General Service 1,500 to 4,999 kW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standby - Large Use"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standby Power General Service Large Use"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standby Distribution Service"]

{"sheet":"4. RRR Data","index":3,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[12,1,12,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Rate Class","Rate Description","Unit","Rate","Non-Loss Adjusted Metered kWh","Non-Loss Adjusted Metered kW","Applicable \nLoss Factor\neg: (1.0325)","Loss Adjusted Billed kWh"]
[]
[null,"Residential","RTSR - Network","kWh",7.1999999999999998E-3,2188889238,null,1.0335000000000001,{"$f":"F17*H17","v":2262217027.473}]
[null,"Residential","RTSR - Connection","kWh",4.8999999999999998E-3,2188889238,null,1.0335000000000001,{"$f":"F18*H18","v":2262217027.473}]
[null,"General Service Less Than 50 kW","RTSR - Network","kWh",6.7000000000000002E-3,712368650,null,1.0335000000000001,{"$f":"F19*H19","v":736232999.7750001}]
[null,"General Service Less Than 50 kW","RTSR - Connection","kWh",4.7000000000000002E-3,712368650,null,1.0335000000000001,{"$f":"F20*H20","v":736232999.7750001}]
[null,"General Service 50 to 1,499 kW","RTSR - Network","kW",2.7422,2907121740,6985551]
[null,"General Service 50 to 1,499 kW","RTSR - Connection","kW",1.9100999999999999,2907121740,6985551]
[null,"General Service 1,500 to 4,999 kW","RTSR - Network","kW",2.8472,753196270,1649388]
[null,"General Service 1,500 to 4,999 kW","RTSR - Connection","kW",2.0413999999999999,753196270,1649388]
[null,"Large Use > 5000 kW","RTSR - Network","kW",3.1562999999999999,606156950,1100755]
[null,"Large Use > 5000 kW","RTSR - Connection","kW",2.2989000000000002,606156950,1100755]
[null,"Unmetered Scattered Load","RTSR - Network","kWh",6.7000000000000002E-3,15230364,null,1.0335000000000001,{"$f":"F27*H27","v":15740581.194000002}]
[null,"Unmetered Scattered Load","RTSR - Connection","kWh",4.7000000000000002E-3,15230364,null,1.0335000000000001,{"$f":"F28*H28","v":15740581.194000002}]
[null,"Sentinel Lighting","RTSR - Network","kW",2.0243000000000002,51051,142]
[null,"Sentinel Lighting","RTSR - Connection","kW",1.419,51051,142]
[null,"Street Lighting","RTSR - Network","kW",2.0345,38203631,106296]
[null,"Street Lighting","RTSR - Connection","kW",1.4486000000000001,38203631,106296]

{"sheet":"5. UTRs and Sub-Transmission","index":4,"n_rows":75,"n_cols":10,"rows_kept":75,"cut":false,"hidden":false,"merged":[[69,4,69,5],[71,4,71,5],[74,4,74,5],[73,4,73,5],[50,4,50,5],[52,4,52,5],[54,4,54,5],[56,4,56,5],[65,4,65,5],[67,4,67,5],[48,4,48,5],[44,4,44,5],[59,4,59,5],[28,4,28,5],[17,4,17,5],[33,4,33,5],[19,4,19,5],[21,4,21,5],[23,4,23,5],[25,4,25,5],[35,4,35,5],[37,4,37,5],[38,4,39,5],[41,4,41,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Uniform Transmission Rates","Unit",null,2017,null,null,2018,null,2019]
[]
[null,"Rate Description",null,null,"Rate",null,null,"Rate",null,"Rate"]
[]
[null,"Network Service Rate","kW",null,3.66,null,null,3.61,null,3.61]
[]
[null,"Line Connection Service Rate","kW",null,0.87,null,null,0.95,null,0.95]
[]
[null,"Transformation Connection Service Rate","kW",null,2.02,null,null,2.34,null,2.34]
[]
[]
[null,"Hydro One Sub-Transmission Rates","Unit",null,2017,null,null,2018,null,2019]
[]
[]
[]
[]
[null,"Rate Description",null,null,"Rate",null,null,"Rate",null,"Rate"]
[]
[null,"Network Service Rate","kW",null,3.1941999999999999,null,null,3.1941999999999999,null,3.1941999999999999]
[]
[null,"Line Connection Service Rate","kW",null,0.77100000000000002,null,null,0.77100000000000002,null,0.77100000000000002]
[null,null,null,null,1.7493000000000001]
[null,"Transformation Connection Service Rate","kW",null,null,null,null,1.7493000000000001,null,1.7493000000000001]
[]
[null,"Both Line and Transformation Connection Service Rate","kW",null,{"$f":"E39+E38","v":2.5203000000000002},null,null,{"$f":"SUM(H40,H38)","v":2.5203000000000002},null,{"$f":"SUM(J40,J38)","v":2.5203000000000002}]
[]
[]
[null,"If needed, add extra host here. (I)","Unit",null,2017,null,null,2018,null,2019]
[]
[]
[]
[null,"Rate Description",null,null,"Rate",null,null,"Rate",null,"Rate"]
[]
[null,"Network Service Rate","kW"]
[]
[null,"Line Connection Service Rate","kW"]
[]
[null,"Transformation Connection Service Rate","kW"]
[]
[null,"Both Line and Transformation Connection Service Rate","kW",null,{"$f":"SUM(E53,E55)","v":0},null,null,{"$f":"SUM(H53,H55)","v":0},null,{"$f":"J55+J53","v":0}]
[]
[]
[null,"If needed, add extra host here. (II)","Unit",null,"Effective \nJanuary 1, 2017",null,null,"Effective \nJanuary 1, 2018",null,"Effective \nJanuary 1, 2019"]
[]
[]
[]
[null,"Rate Description",null,null,"Rate",null,null,"Rate",null,"Rate"]
[]
[null,"Network Service Rate","kW"]
[]
[null,"Line Connection Service Rate","kW"]
[]
[null,"Transformation Connection Service Rate","kW"]
[]
[null,"Both Line and Transformation Connection Service Rate","kW",null,{"$f":"SUM(E68,E70)","v":0},null,null,{"$f":"SUM(H68,H70)","v":0},null,{"$f":"J70+J68","v":0}]
[]
[null,null,null,null,"Historical 2017",null,null,"Current 2018",null,"Forecast 2019"]
[null,"Low Voltage Switchgear Credit (if applicable, enter as a negative value)","$"]

{"sheet":"6. Historical Wholesale","index":5,"n_rows":117,"n_cols":16,"rows_kept":117,"cut":false,"hidden":false,"merged":[[96,7,96,9],[96,11,96,13],[20,3,20,5],[20,7,20,9],[20,11,20,13],[96,3,96,5],[38,3,38,5],[38,7,38,9],[38,11,38,13],[95,3,95,5],[57,3,57,5],[57,7,57,9],[57,11,57,13],[76,3,76,5],[76,7,76,9],[76,11,76,13],[95,7,95,9],[95,11,95,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"IESO",null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,1136860,{"$f":"IF(D24<>0,F24/D24,0)","v":3.66},4160907.6,null,1087748,{"$f":"IF(H24<>0,J24/H24,0)","v":0.87000000000000011},946340.76000000013,null,848417,{"$f":"IF(L24<>0,N24/L24,0)","v":2.02},1713802.34,null,{"$f":"J24+N24","v":2660143.1}]
[null,"February",null,1096423,{"$f":"IF(D25<>0,F25/D25,0)","v":3.66},4012908.18,null,1104665,{"$f":"IF(H25<>0,J25/H25,0)","v":0.87000000000000011},961058.55000000016,null,826309,{"$f":"IF(L25<>0,N25/L25,0)","v":2.0199999999999996},1669144.1799999997,null,2630202.73]
[null,"March",null,1033711,3.6599999999999997,3783382.26,null,1064220,0.87,925871.4,null,821084,2.0199999999999996,1658589.6799999997,null,2584461.0799999996]
[null,"April",null,915205,3.6599999999999997,3349650.3,null,902594,0.87192777705147606,786996.78,null,697439,2.0257926212901776,1412866.78,null,2199863.56]
[null,"May",null,1090675,3.66,3991870.5,null,1055778,0.86999999999999977,918526.85999999975,null,795710,2.02,1607334.2,null,2525861.0599999996]
[null,"June",null,1282127,3.66,4692584.82,null,1247413,0.86999999999999988,1085249.3099999998,null,959991,2.02,1939181.82,null,3024431.13]
[null,"July",null,1141223,3.66,4176876.18,null,1186537,0.87,1032287.1900000001,null,881830,2.0199999999999991,1781296.5999999994,null,2813583.7899999996]
[null,"August",null,1190589,3.66,4357555.74,null,1184128,0.86999999999999988,1030191.3599999999,null,890870,2.02,1799557.4,null,2829748.76]
[null,"September",null,1293444,3.66,4734005.04,null,1228077,0.87976492516348737,1080419.07,null,944243,2.0390909331602143,1925397.34,null,3005816.41]
[null,"October",null,922447,3.66,3376156.02,null,919807,0.87,800232.09,null,736724,2.02,1488182.48,null,2288414.5699999998]
[null,"November",null,1051724,2.0420660933857171,2147689.92,null,1004242,0.98948308276291941,993680.46999999974,null,793054,3.2967169070454205,2614474.5299999989,null,3608154.9999999986]
[null,"December",null,1171569,3.52,4123922.88,null,1170885,0.87999999999999989,1030378.7999999998,null,895877,2.1300000000000003,1908218.0100000005,null,2938596.8100000005]
[]
[null,"Total",null,{"$f":"SUM(D24:D35)","v":13325997},{"$f":"IF(D37<>0,F37/D37,0)","v":3.5200000000000005},{"$f":"SUM(F24:F35)","v":46907509.440000005},null,{"$f":"SUM(H24:H35)","v":13156094},{"$f":"IF(H37<>0,J37/H37,0)","v":0.88105425820156047},{"$f":"SUM(J24:J35)","v":11591232.640000001},null,{"$f":"SUM(L24:L35)","v":10091548},{"$f":"IF(L37<>0,N37/L37,0)","v":2.132283903321869},{"$f":"SUM(N24:N35)","v":21518045.359999999},null,{"$f":"SUM(P24:P35)","v":33109278}]
[]
[null,"Hydro One",null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,38503.179999999993,{"$f":"IF(D43<>0,F43/D43,0)","v":3.1941995440376618},122986.84,null,4304.0599999999995,{"$f":"IF(H43<>0,J43/H43,0)","v":0.77099761620423513},3318.42,null,40235.329999999994,{"$f":"IF(L43<>0,N43/L43,0)","v":1.7492999311798862},70383.66,null,{"$f":"J43+N43","v":73702.080000000002}]
[null,"February",null,39712.06,{"$f":"IF(D44<>0,F44/D44,0)","v":3.1941996965153661},126848.25,null,3883.49,{"$f":"IF(H44<>0,J44/H44,0)","v":0.7709997965747305},2994.17,null,38940.28,{"$f":"IF(L44<>0,N44/L44,0)","v":1.7492999536726495},68118.23,null,71112.399999999994]
[null,"March",null,38639.49,3.1942002857698171,123422.26999999999,null,4078.8,0.77099882318328916,3144.75,null,40286.699999999997,1.7492996447959253,70473.509999999995,null,73618.259999999995]
[null,"April",null,34126.94,3.1941999487794686,109008.27,null,3465.42,0.77100034050706701,2671.84,null,34382.07,1.7492992713934907,60144.53,null,62816.369999999995]
[null,"May",null,34711.700000000004,3.1942002264366187,110876.12,null,627.96,0.77098859799987263,484.15000000000003,null,34111.43,1.7492998681087248,59671.12,null,60155.270000000004]
[null,"June",null,46954.11,3.194200039144603,149980.82,null,744.19,0.77099934156599803,573.7700000000001,null,46249.69,1.7493001574713256,80904.59,null,81478.36]
[null,"July",null,42313,3.1942001276203533,135156.19,null,3716.05,0.77100146661105196,2865.08,null,41610.71,1.7492998797665313,72789.61,null,75654.69]
[null,"August",null,41704.980000000003,3.1942005487114487,133214.07,null,3689.31,0.77100053939625568,2844.46,null,40975.39,1.7493002507114639,71678.260000000009,null,74522.720000000016]
[null,"September",null,47105.590000000004,3.1941994570071199,150464.65000000002,null,3721.11,0.77099843863793327,2868.97,null,46575,1.7493000536768655,81473.650000000009,null,84342.62000000001]
[null,"October",null,36196.199999999997,3.1941996673683986,115617.89000000001,null,4714,0.770999151463725,3634.49,null,35622.54,1.7492997411189657,62314.5,null,65948.990000000005]
[null,"November",null,40811.39,3.1941994624539864,130359.72,null,5409.47,0.77099974674043847,4170.7,null,43988.25,1.749299869851608,76948.639999999999,null,81119.34]
[null,"December",null,42636.67,3.1941999691814589,136190.05000000002,null,6664.23,0.77099980042705607,5138.12,null,42045.880000000005,1.749300050325977,73550.86,null,78688.98]
[]
[null,"Total",null,{"$f":"SUM(D43:D54)","v":483415.31},{"$f":"IF(D56<>0,F56/D56,0)","v":3.1941999106317094},{"$f":"SUM(F43:F54)","v":1544125.1400000001},null,{"$f":"SUM(H43:H54)","v":45018.09},{"$f":"IF(H56<>0,J56/H56,0)","v":0.77099939157791908},{"$f":"SUM(J43:J54)","v":34708.92},null,{"$f":"SUM(L43:L54)","v":485023.26999999996},{"$f":"IF(L56<>0,N56/L56,0)","v":1.7492999047241591},{"$f":"SUM(N43:N54)","v":848451.16},null,{"$f":"SUM(P43:P54)","v":883160.08}]
[]
[null,"Add Extra Host Here (I)",null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[null,"(if needed)"]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,null,{"$f":"IF(D62<>0,F62/D62,0)","v":0},null,null,null,{"$f":"IF(H62<>0,J62/H62,0)","v":0},null,null,null,{"$f":"IF(L62<>0,N62/L62,0)","v":0},null,null,{"$f":"J62+N62","v":0}]
[null,"February",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"March",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"April",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"May",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"June",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"July",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"August",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"September",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"October",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"November",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"December",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[]
[null,"Total",null,{"$f":"SUM(D62:D73)","v":0},{"$f":"IF(D75<>0,F75/D75,0)","v":0},{"$f":"SUM(F62:F73)","v":0},null,{"$f":"SUM(H62:H73)","v":0},{"$f":"IF(H75<>0,J75/H75,0)","v":0},{"$f":"SUM(J62:J73)","v":0},null,{"$f":"SUM(L62:L73)","v":0},{"$f":"IF(L75<>0,N75/L75,0)","v":0},{"$f":"SUM(N62:N73)","v":0},null,{"$f":"SUM(P62:P73)","v":0}]
[]
[null,"Add Extra Host Here (II)",null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[null,"(if needed)"]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,null,{"$f":"IF(D81<>0,F81/D81,0)","v":0},null,null,null,{"$f":"IF(H81<>0,J81/H81,0)","v":0},null,null,null,{"$f":"IF(L81<>0,N81/L81,0)","v":0},null,null,{"$f":"J81+N81","v":0}]
[null,"February",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"March",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"April",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"May",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"June",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"July",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"August",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"September",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"October",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"November",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[null,"December",null,null,0,null,null,null,0,null,null,null,0,null,null,0]
[]
[null,"Total",null,{"$f":"SUM(D81:D92)","v":0},{"$f":"IF(D94<>0,F94/D94,0)","v":0},{"$f":"SUM(F81:F92)","v":0},null,{"$f":"SUM(H81:H92)","v":0},{"$f":"IF(H94<>0,J94/H94,0)","v":0},{"$f":"SUM(J81:J92)","v":0},null,{"$f":"SUM(L81:L92)","v":0},{"$f":"IF(L94<>0,N94/L94,0)","v":0},{"$f":"SUM(N81:N92)","v":0},null,{"$f":"SUM(P81:P92)","v":0}]
[]
[null,"Total",null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,{"$f":"D24+D43+D62+D81","v":1175363.18},{"$f":"IF(D100<>0,F100/D100,0)","v":3.6447410578235067},{"$f":"F24+F43+F62+F81","v":4283894.4400000004},null,{"$f":"H24+H43+H62+H81","v":1092052.06},{"$f":"IF(H100<>0,J100/H100,0)","v":0.86960980596474502},{"$f":"J24+J43+J62+J81","v":949659.18000000017},null,{"$f":"L24+L43+L62+L81","v":888652.33},{"$f":"IF(L100<>0,N100/L100,0)","v":2.0077435682861484},{"$f":"N24+N43+N62+N81","v":1784186},null,{"$f":"J100+N100","v":2733845.18}]
[null,"February",null,{"$f":"D25+D44+D63+D82","v":1136135.06},3.6437185821903957,{"$f":"F25+F44+F63+F82","v":4139756.43},null,{"$f":"H25+H44+H63+H82","v":1108548.49},0.86965318043958562,{"$f":"J25+J44+J63+J82","v":964052.7200000002},null,{"$f":"L25+L44+L63+L82","v":865249.28000000003},2.0078172269614596,{"$f":"N25+N44+N63+N82","v":1737262.4099999997},null,2701315.13]
[null,"March",null,1072350.49,3.6432160626886083,3906804.53,null,1068298.8,0.86962201024657149,929016.15,null,861370.7,2.0073392210810046,1729063.1899999997,null,2658079.34]
[null,"April",null,949331.94,3.6432552453676004,3458658.57,null,906059.42,0.87154175826569957,789668.62,null,731821.07,2.0128025420202786,1473011.31,null,2262679.9300000002]
[null,"May",null,1125386.7,3.6456327589441035,4102746.62,null,1056405.96,0.86994114459558691,919011.00999999978,null,829821.43,2.0088723425713408,1667005.32,null,2586016.33]
[null,"June",null,1329081.1100000001,3.6435441024363069,4842565.6400000006,null,1248157.19,0.8699409727391787,1085823.0799999998,null,1006240.69,2.0075578637154896,2020086.4100000001,null,3105909.49]
[null,"July",null,1183536,3.6433470295791595,4312032.37,null,1190253.05,0.86969091992664915,1035152.27,null,923440.71,2.0078021143339018,1854086.2099999995,null,2889238.4799999995]
[null,"August",null,1232293.98,3.6442357772452971,4490769.8100000005,null,1187817.31,0.86969251188972807,1033035.8199999998,null,931845.39,2.00809670797427,1871235.66,null,2904271.4799999995]
[null,"September",null,1340549.5900000001,3.6436322284802611,4884469.6900000004,null,1231798.1100000001,0.87943635503710904,1083288.04,null,990818,2.0254688449341858,2006870.99,null,3090159.0300000003]
[null,"October",null,958643.19999999995,3.6424124324879168,3491773.91,null,924521,0.86949520887032306,803866.58,null,772346.54,2.0075146319681836,1550496.98,null,2354363.56]
[null,"November",null,1092535.3899999999,2.0851037511929023,2278049.64,null,1009651.47,0.98831250154075423,997851.16999999969,null,837042.25,3.2153970364100486,2691423.169999999,null,3689274.3399999989]
[null,"December",null,1214205.67,3.5085595754136119,4260112.93,null,1177549.23,0.87938312354040593,1035516.9199999998,null,937922.88,2.112933709432486,1981768.8700000006,null,3017285.7900000005]
[]
[null,"Total",null,{"$f":"SUM(D100:D111)","v":13809412.310000001},{"$f":"IF(D113<>0,F113/D113,0)","v":3.5085949707587525},{"$f":"SUM(F100:F111)","v":48451634.580000006},null,{"$f":"SUM(H100:H111)","v":13201112.09},{"$f":"IF(H113<>0,J113/H113,0)","v":0.88067895195032775},{"$f":"SUM(J100:J111)","v":11625941.560000001},null,{"$f":"SUM(L100:L111)","v":10576571.270000001},{"$f":"IF(L113<>0,N113/L113,0)","v":2.114720919381655},{"$f":"SUM(N100:N111)","v":22366496.52},null,{"$f":"SUM(P100:P111)","v":33992438.079999998}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Low Voltage Switchgear Credit (if applicable)",null,{"$f":"'5. UTRs and Sub-Transmission'!E75","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total including deduction for Low Voltage Switchgear Credit",null,{"$f":"P113+P115","v":33992438.079999998}]

{"sheet":"7. Current Wholesale","index":6,"n_rows":117,"n_cols":16,"rows_kept":117,"cut":false,"hidden":false,"merged":[[96,7,96,9],[96,11,96,13],[20,3,20,5],[20,7,20,9],[20,11,20,13],[96,3,96,5],[95,3,95,5],[95,7,95,9],[95,11,95,13],[57,3,57,5],[57,7,57,9],[57,11,57,13],[76,3,76,5],[76,7,76,9],[76,11,76,13],[12,1,12,11],[19,3,19,5],[19,7,19,9],[19,11,19,13],[38,3,38,5],[38,7,38,9],[38,11,38,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The purpose of this sheet is to calculate the expected billing when current 2018 Uniform Transmission Rates are applied against historical 2017 transmission units."]
[]
[]
[]
[]
[]
[]
[null,"IESO",null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,{"$f":"'6. Historical Wholesale'!D24","v":1136860},{"$f":"'5. UTRs and Sub-Transmission'!H22","v":3.61},{"$f":"D24*E24","v":4104064.5999999996},null,{"$f":"'6. Historical Wholesale'!H24","v":1087748},{"$f":"'5. UTRs and Sub-Transmission'!H24","v":0.95},{"$f":"H24*I24","v":1033360.6},null,{"$f":"'6. Historical Wholesale'!L24","v":848417},{"$f":"'5. UTRs and Sub-Transmission'!H26","v":2.34},{"$f":"L24*M24","v":1985295.7799999998},null,{"$f":"J24+N24","v":3018656.38}]
[null,"February",null,{"$f":"'6. Historical Wholesale'!D25","v":1096423},{"$f":"E24","v":3.61},{"$f":"D25*E25","v":3958087.03},null,{"$f":"'6. Historical Wholesale'!H25","v":1104665},{"$f":"I24","v":0.95},{"$f":"H25*I25","v":1049431.75},null,{"$f":"'6. Historical Wholesale'!L25","v":826309},{"$f":"M24","v":2.34},{"$f":"L25*M25","v":1933563.0599999998},null,2982994.8099999996]
[null,"March",null,{"$f":"'6. Historical Wholesale'!D26","v":1033711},{"$f":"E25","v":3.61},3731696.71,null,{"$f":"'6. Historical Wholesale'!H26","v":1064220},{"$f":"I25","v":0.95},1011009,null,{"$f":"'6. Historical Wholesale'!L26","v":821084},{"$f":"M25","v":2.34},1921336.5599999998,null,2932345.5599999996]
[null,"April",null,{"$f":"'6. Historical Wholesale'!D27","v":915205},3.61,3303890.05,null,{"$f":"'6. Historical Wholesale'!H27","v":902594},0.95,857464.29999999993,null,{"$f":"'6. Historical Wholesale'!L27","v":697439},2.34,1632007.26,null,2489471.56]
[null,"May",null,{"$f":"'6. Historical Wholesale'!D28","v":1090675},3.61,3937336.75,null,{"$f":"'6. Historical Wholesale'!H28","v":1055778},0.95,1002989.1,null,{"$f":"'6. Historical Wholesale'!L28","v":795710},2.34,1861961.4,null,2864950.5]
[null,"June",null,{"$f":"'6. Historical Wholesale'!D29","v":1282127},3.61,4628478.47,null,{"$f":"'6. Historical Wholesale'!H29","v":1247413},0.95,1185042.3499999999,null,{"$f":"'6. Historical Wholesale'!L29","v":959991},2.34,2246378.94,null,3431421.29]
[null,"July",null,{"$f":"'6. Historical Wholesale'!D30","v":1141223},3.61,4119815.03,null,{"$f":"'6. Historical Wholesale'!H30","v":1186537},0.95,1127210.1499999999,null,{"$f":"'6. Historical Wholesale'!L30","v":881830},2.34,2063482.2,null,3190692.3499999996]
[null,"August",null,{"$f":"'6. Historical Wholesale'!D31","v":1190589},3.61,4298026.29,null,{"$f":"'6. Historical Wholesale'!H31","v":1184128},0.95,1124921.5999999999,null,{"$f":"'6. Historical Wholesale'!L31","v":890870},2.34,2084635.7999999998,null,3209557.3999999994]
[null,"September",null,{"$f":"'6. Historical Wholesale'!D32","v":1293444},3.61,4669332.84,null,{"$f":"'6. Historical Wholesale'!H32","v":1228077},0.95,1166673.1499999999,null,{"$f":"'6. Historical Wholesale'!L32","v":944243},2.34,2209528.6199999996,null,3376201.7699999996]
[null,"October",null,{"$f":"'6. Historical Wholesale'!D33","v":922447},3.61,3330033.67,null,{"$f":"'6. Historical Wholesale'!H33","v":919807},0.95,873816.64999999991,null,{"$f":"'6. Historical Wholesale'!L33","v":736724},2.34,1723934.16,null,2597750.8099999996]
[null,"November",null,{"$f":"'6. Historical Wholesale'!D34","v":1051724},3.61,3796723.6399999997,null,{"$f":"'6. Historical Wholesale'!H34","v":1004242},0.95,954029.89999999991,null,{"$f":"'6. Historical Wholesale'!L34","v":793054},2.34,1855746.3599999999,null,2809776.26]
[null,"December",null,{"$f":"'6. Historical Wholesale'!D35","v":1171569},3.61,4229364.09,null,{"$f":"'6. Historical Wholesale'!H35","v":1170885},0.95,1112340.75,null,{"$f":"'6. Historical Wholesale'!L35","v":895877},2.34,2096352.18,null,3208692.9299999997]
[]
[null,"Total",null,{"$f":"SUM(D24:D35)","v":13325997},{"$f":"IF(D37<>0,F37/D37,0)","v":3.6100000000000003},{"$f":"SUM(F24:F35)","v":48106849.170000002},null,{"$f":"SUM(H24:H35)","v":13156094},{"$f":"IF(H37<>0,J37/H37,0)","v":0.95000000000000007},{"$f":"SUM(J24:J35)","v":12498289.300000001},null,{"$f":"SUM(L24:L35)","v":10091548},{"$f":"IF(L37<>0,N37/L37,0)","v":2.34},{"$f":"SUM(N24:N35)","v":23614222.319999997},null,{"$f":"SUM(P24:P35)","v":36112511.619999997}]
[]
[null,"Hydro One",null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,{"$f":"'6. Historical Wholesale'!D43","v":38503.179999999993},{"$f":"'5. UTRs and Sub-Transmission'!H36","v":3.1941999999999999},{"$f":"D43*E43","v":122986.85755599997},null,{"$f":"'6. Historical Wholesale'!H43","v":4304.0599999999995},{"$f":"'5. UTRs and Sub-Transmission'!H38","v":0.77100000000000002},{"$f":"H43*I43","v":3318.4302599999996},null,{"$f":"'6. Historical Wholesale'!L43","v":40235.329999999994},{"$f":"'5. UTRs and Sub-Transmission'!H40","v":1.7493000000000001},{"$f":"L43*M43","v":70383.662768999988},null,{"$f":"J43+N43","v":73702.093028999981}]
[null,"February",null,{"$f":"'6. Historical Wholesale'!D44","v":39712.06},{"$f":"E43","v":3.1941999999999999},{"$f":"D44*E44","v":126848.26205199999},null,{"$f":"'6. Historical Wholesale'!H44","v":3883.49},{"$f":"I43","v":0.77100000000000002},{"$f":"H44*I44","v":2994.1707900000001},null,{"$f":"'6. Historical Wholesale'!L44","v":38940.28},{"$f":"M43","v":1.7493000000000001},{"$f":"L44*M44","v":68118.231803999995},null,71112.402593999999]
[null,"March",null,{"$f":"'6. Historical Wholesale'!D45","v":38639.49},3.1941999999999999,123422.25895799999,null,{"$f":"'6. Historical Wholesale'!H45","v":4078.8},0.77100000000000002,3144.7548000000002,null,{"$f":"'6. Historical Wholesale'!L45","v":40286.699999999997},{"$f":"M44","v":1.7493000000000001},70473.524309999993,null,73618.279109999989]
[null,"April",null,{"$f":"'6. Historical Wholesale'!D46","v":34126.94},3.1941999999999999,109008.271748,null,{"$f":"'6. Historical Wholesale'!H46","v":3465.42},0.77100000000000002,2671.8388199999999,null,{"$f":"'6. Historical Wholesale'!L46","v":34382.07},{"$f":"M45","v":1.7493000000000001},60144.555051000003,null,62816.393871]
[null,"May",null,{"$f":"'6. Historical Wholesale'!D47","v":34711.700000000004},3.1941999999999999,110876.11214000001,null,{"$f":"'6. Historical Wholesale'!H47","v":627.96},0.77100000000000002,484.15716000000003,null,{"$f":"'6. Historical Wholesale'!L47","v":34111.43},1.7493000000000001,59671.124499000005,null,60155.281659000007]
[null,"June",null,{"$f":"'6. Historical Wholesale'!D48","v":46954.11},3.1941999999999999,149980.81816200001,null,{"$f":"'6. Historical Wholesale'!H48","v":744.19},0.77100000000000002,573.77049000000011,null,{"$f":"'6. Historical Wholesale'!L48","v":46249.69},1.7493000000000001,80904.582717000012,null,81478.353207000007]
[null,"July",null,{"$f":"'6. Historical Wholesale'!D49","v":42313},3.1941999999999999,135156.18460000001,null,{"$f":"'6. Historical Wholesale'!H49","v":3716.05},0.77100000000000002,2865.0745500000003,null,{"$f":"'6. Historical Wholesale'!L49","v":41610.71},1.7493000000000001,72789.615002999999,null,75654.689553000004]
[null,"August",null,{"$f":"'6. Historical Wholesale'!D50","v":41704.980000000003},3.1941999999999999,133214.047116,null,{"$f":"'6. Historical Wholesale'!H50","v":3689.31},0.77100000000000002,2844.4580099999998,null,{"$f":"'6. Historical Wholesale'!L50","v":40975.39},1.7493000000000001,71678.249727000002,null,74522.707737000004]
[null,"September",null,{"$f":"'6. Historical Wholesale'!D51","v":47105.590000000004},3.1941999999999999,150464.67557799999,null,{"$f":"'6. Historical Wholesale'!H51","v":3721.11},0.77100000000000002,2868.9758100000004,null,{"$f":"'6. Historical Wholesale'!L51","v":46575},1.7493000000000001,81473.647500000006,null,84342.62331000001]
[null,"October",null,{"$f":"'6. Historical Wholesale'!D52","v":36196.199999999997},3.1941999999999999,115617.90203999999,null,{"$f":"'6. Historical Wholesale'!H52","v":4714},0.77100000000000002,3634.4940000000001,null,{"$f":"'6. Historical Wholesale'!L52","v":35622.54},1.7493000000000001,62314.509222000008,null,65949.003222000014]
[null,"November",null,{"$f":"'6. Historical Wholesale'!D53","v":40811.39},3.1941999999999999,130359.74193799999,null,{"$f":"'6. Historical Wholesale'!H53","v":5409.47},0.77100000000000002,4170.7013700000007,null,{"$f":"'6. Historical Wholesale'!L53","v":43988.25},1.7493000000000001,76948.645725000009,null,81119.347095000005]
[null,"December",null,{"$f":"'6. Historical Wholesale'!D54","v":42636.67},3.1941999999999999,136190.05131399998,null,{"$f":"'6. Historical Wholesale'!H54","v":6664.23},0.77100000000000002,5138.1213299999999,null,{"$f":"'6. Historical Wholesale'!L54","v":42045.880000000005},1.7493000000000001,73550.857884000012,null,78688.979214000006]
[]
[null,"Total",null,{"$f":"SUM(D43:D54)","v":483415.31},{"$f":"IF(D56<>0,F56/D56,0)","v":3.1942000000000004},{"$f":"SUM(F43:F54)","v":1544125.1832020001},null,{"$f":"SUM(H43:H54)","v":45018.09},{"$f":"IF(H56<>0,J56/H56,0)","v":0.77100000000000013},{"$f":"SUM(J43:J54)","v":34708.947390000001},null,{"$f":"SUM(L43:L54)","v":485023.26999999996},{"$f":"IF(L56<>0,N56/L56,0)","v":1.7493000000000005},{"$f":"SUM(N43:N54)","v":848451.20621100022},null,{"$f":"SUM(P43:P54)","v":883160.15360099997}]
[]
[null,{"$f":"'6. Historical Wholesale'!B58","v":"Add Extra Host Here (I)"},null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,{"$f":"'6. Historical Wholesale'!D62","v":0},{"$f":"'5. UTRs and Sub-Transmission'!H51","v":0},{"$f":"D62*E62","v":0},null,{"$f":"'6. Historical Wholesale'!H62","v":0},{"$f":"'5. UTRs and Sub-Transmission'!H53","v":0},{"$f":"H62*I62","v":0},null,{"$f":"'6. Historical Wholesale'!L62","v":0},{"$f":"'5. UTRs and Sub-Transmission'!H55","v":0},{"$f":"L62*M62","v":0},null,{"$f":"J62+N62","v":0}]
[null,"February",null,{"$f":"'6. Historical Wholesale'!D63","v":0},{"$f":"E62","v":0},{"$f":"D63*E63","v":0},null,{"$f":"'6. Historical Wholesale'!H63","v":0},{"$f":"I62","v":0},{"$f":"H63*I63","v":0},null,{"$f":"'6. Historical Wholesale'!L63","v":0},{"$f":"M62","v":0},{"$f":"L63*M63","v":0},null,0]
[null,"March",null,{"$f":"'6. Historical Wholesale'!D64","v":0},{"$f":"E63","v":0},0,null,{"$f":"'6. Historical Wholesale'!H64","v":0},{"$f":"I63","v":0},0,null,{"$f":"'6. Historical Wholesale'!L64","v":0},{"$f":"M63","v":0},0,null,0]
[null,"April",null,{"$f":"'6. Historical Wholesale'!D65","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H65","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L65","v":0},{"$f":"M64","v":0},0,null,0]
[null,"May",null,{"$f":"'6. Historical Wholesale'!D66","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H66","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L66","v":0},0,0,null,0]
[null,"June",null,{"$f":"'6. Historical Wholesale'!D67","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H67","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L67","v":0},0,0,null,0]
[null,"July",null,{"$f":"'6. Historical Wholesale'!D68","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H68","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L68","v":0},0,0,null,0]
[null,"August",null,{"$f":"'6. Historical Wholesale'!D69","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H69","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L69","v":0},0,0,null,0]
[null,"September",null,{"$f":"'6. Historical Wholesale'!D70","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H70","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L70","v":0},0,0,null,0]
[null,"October",null,{"$f":"'6. Historical Wholesale'!D71","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H71","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L71","v":0},0,0,null,0]
[null,"November",null,{"$f":"'6. Historical Wholesale'!D72","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H72","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L72","v":0},0,0,null,0]
[null,"December",null,{"$f":"'6. Historical Wholesale'!D73","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H73","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L73","v":0},0,0,null,0]
[]
[null,"Total",null,{"$f":"SUM(D62:D73)","v":0},{"$f":"IF(D75<>0,F75/D75,0)","v":0},{"$f":"SUM(F62:F73)","v":0},null,{"$f":"SUM(H62:H73)","v":0},{"$f":"IF(H75<>0,J75/H75,0)","v":0},{"$f":"SUM(J62:J73)","v":0},null,{"$f":"SUM(L62:L73)","v":0},{"$f":"IF(L75<>0,N75/L75,0)","v":0},{"$f":"SUM(N62:N73)","v":0},null,{"$f":"SUM(P62:P73)","v":0}]
[]
[null,{"$f":"'6. Historical Wholesale'!B77","v":"Add Extra Host Here (II)"},null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,{"$f":"'6. Historical Wholesale'!D81","v":0},{"$f":"'5. UTRs and Sub-Transmission'!H66","v":0},{"$f":"D81*E81","v":0},null,{"$f":"'6. Historical Wholesale'!H81","v":0},{"$f":"'5. UTRs and Sub-Transmission'!H68","v":0},{"$f":"H81*I81","v":0},null,{"$f":"'6. Historical Wholesale'!L81","v":0},{"$f":"'5. UTRs and Sub-Transmission'!H70","v":0},{"$f":"L81*M81","v":0},null,{"$f":"J81+N81","v":0}]
[null,"February",null,{"$f":"'6. Historical Wholesale'!D82","v":0},{"$f":"E81","v":0},{"$f":"D82*E82","v":0},null,{"$f":"'6. Historical Wholesale'!H82","v":0},{"$f":"I81","v":0},{"$f":"H82*I82","v":0},null,{"$f":"'6. Historical Wholesale'!L82","v":0},{"$f":"M81","v":0},{"$f":"L82*M82","v":0},null,0]
[null,"March",null,{"$f":"'6. Historical Wholesale'!D83","v":0},{"$f":"E82","v":0},0,null,{"$f":"'6. Historical Wholesale'!H83","v":0},{"$f":"I82","v":0},0,null,{"$f":"'6. Historical Wholesale'!L83","v":0},{"$f":"M82","v":0},0,null,0]
[null,"April",null,{"$f":"'6. Historical Wholesale'!D84","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H84","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L84","v":0},{"$f":"M83","v":0},0,null,0]
[null,"May",null,{"$f":"'6. Historical Wholesale'!D85","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H85","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L85","v":0},0,0,null,0]
[null,"June",null,{"$f":"'6. Historical Wholesale'!D86","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H86","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L86","v":0},0,0,null,0]
[null,"July",null,{"$f":"'6. Historical Wholesale'!D87","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H87","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L87","v":0},0,0,null,0]
[null,"August",null,{"$f":"'6. Historical Wholesale'!D88","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H88","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L88","v":0},0,0,null,0]
[null,"September",null,{"$f":"'6. Historical Wholesale'!D89","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H89","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L89","v":0},0,0,null,0]
[null,"October",null,{"$f":"'6. Historical Wholesale'!D90","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H90","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L90","v":0},0,0,null,0]
[null,"November",null,{"$f":"'6. Historical Wholesale'!D91","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H91","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L91","v":0},0,0,null,0]
[null,"December",null,{"$f":"'6. Historical Wholesale'!D92","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H92","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L92","v":0},0,0,null,0]
[]
[null,"Total",null,{"$f":"SUM(D81:D92)","v":0},{"$f":"IF(D94<>0,F94/D94,0)","v":0},{"$f":"SUM(F81:F92)","v":0},null,{"$f":"SUM(H81:H92)","v":0},{"$f":"IF(H94<>0,J94/H94,0)","v":0},{"$f":"SUM(J81:J92)","v":0},null,{"$f":"SUM(L81:L92)","v":0},{"$f":"IF(L94<>0,N94/L94,0)","v":0},{"$f":"SUM(N81:N92)","v":0},null,{"$f":"SUM(P81:P92)","v":0}]
[]
[null,"Total",null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,{"$f":"D24+D43+D62+D81","v":1175363.18},{"$f":"IF(D100<>0,F100/D100,0)","v":3.5963789996858675},{"$f":"F24+F43+F62+F81","v":4227051.457556},null,{"$f":"H24+H43+H62+H81","v":1092052.06},{"$f":"IF(H100<>0,J100/H100,0)","v":0.94929451464062986},{"$f":"J24+J43+J62+J81","v":1036679.03026},null,{"$f":"L24+L43+L62+L81","v":888652.33},{"$f":"IF(L100<>0,N100/L100,0)","v":2.3132549967758482},{"$f":"N24+N43+N62+N81","v":2055679.4427689998},null,{"$f":"J100+N100","v":3092358.4730289998}]
[null,"February",null,{"$f":"D25+D44+D63+D82","v":1136135.06},3.5954662749796662,{"$f":"F25+F44+F63+F82","v":4084935.2920519998},null,{"$f":"H25+H44+H63+H82","v":1108548.49},0.9493729234974646,{"$f":"J25+J44+J63+J82","v":1052425.9207899999},null,{"$f":"L25+L44+L63+L82","v":865249.28000000003},2.3134157266262041,{"$f":"N25+N44+N63+N82","v":2001681.2918039998},null,3054107.2125939997]
[null,"March",null,1072350.49,3.5950176783693171,3855118.9689579997,null,1068298.8,0.94931657210510767,1014153.7548,null,861370.7,2.3123726919315923,1991810.0843099998,null,3005963.8391100001]
[null,"April",null,949331.94,3.5950526659284212,3412898.3217479996,null,906059.42,0.9493153758282209,860136.13881999988,null,731821.07,2.3122480130983387,1692151.8150510001,null,2552287.9538710001]
[null,"May",null,1125386.7,3.5971749640723494,4048212.8621399999,null,1056405.96,0.9498935969274539,1003473.2571599999,null,829821.43,2.3157181232340549,1921632.5244989998,null,2925105.7816589996]
[null,"June",null,1329081.1100000001,3.5953105135637653,4778459.2881619995,null,1248157.19,0.94989327465236961,1185616.1204899999,null,1006240.69,2.3128497444453378,2327283.522717,null,3512899.6432069996]
[null,"July",null,1183536,3.5951345921036619,4254971.2145999996,null,1190253.05,0.94944114997226836,1130075.2245499999,null,923440.71,2.3133827563255251,2136271.8150029997,null,3266347.0395529997]
[null,"August",null,1232293.98,3.5959279271298561,4431240.3371160002,null,1187817.31,0.949444033619951,1127766.0580099998,null,931845.39,2.3140255592475483,2156314.0497269998,null,3284080.1077369996]
[null,"September",null,1340549.5900000001,3.595389198230257,4819797.5155779999,null,1231798.1100000001,0.94945926310115847,1169542.1258099999,null,990818,2.3122331926751429,2291002.2674999996,null,3460544.3933099993]
[null,"October",null,958643.19999999995,3.594300332010909,3445651.57204,null,924521,0.94908730466912039,877451.14399999985,null,772346.54,2.3127554494152323,1786248.6692219998,null,2663699.8132219994]
[null,"November",null,1092535.3899999999,3.594467893564528,3927083.3819379997,null,1009651.47,0.9490409610060786,958200.60136999993,null,837042.25,2.30895752959304,1932695.0057249998,null,2890895.6070949999]
[null,"December",null,1214205.67,3.5953992385112152,4365554.1413139999,null,1177549.23,0.94898696620098,1117478.87133,null,937922.88,2.3135196764620987,2169903.0378839998,null,3287381.9092139998]
[]
[null,"Total",null,{"$f":"SUM(D100:D111)","v":13809412.310000001},{"$f":"IF(D113<>0,F113/D113,0)","v":3.5954444141875288},{"$f":"SUM(F100:F111)","v":49650974.353202},null,{"$f":"SUM(H100:H111)","v":13201112.09},{"$f":"IF(H113<>0,J113/H113,0)","v":0.94938957884342901},{"$f":"SUM(J100:J111)","v":12532998.247389998},null,{"$f":"SUM(L100:L111)","v":10576571.270000001},{"$f":"IF(L113<>0,N113/L113,0)","v":2.3129115194068937},{"$f":"SUM(N100:N111)","v":24462673.526211001},null,{"$f":"SUM(P100:P111)","v":36995671.773600996}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Low Voltage Switchgear Credit (if applicable)",null,{"$f":"'5. UTRs and Sub-Transmission'!H75","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total including deduction for Low Voltage Switchgear Credit",null,{"$f":"P113+P115","v":36995671.773600996}]

{"sheet":"8. Forecast Wholesale","index":7,"n_rows":117,"n_cols":16,"rows_kept":117,"cut":false,"hidden":false,"merged":[[96,7,96,9],[96,11,96,13],[20,3,20,5],[20,7,20,9],[20,11,20,13],[96,3,96,5],[95,3,95,5],[95,7,95,9],[95,11,95,13],[57,3,57,5],[57,7,57,9],[57,11,57,13],[76,3,76,5],[76,7,76,9],[76,11,76,13],[12,1,12,12],[19,3,19,5],[19,7,19,9],[19,11,19,13],[38,3,38,5],[38,7,38,9],[38,11,38,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The purpose of this sheet is to calculate the expected billing when forecasted 2019 Uniform Transmission Rates are applied against historical 2017 transmission units."]
[]
[]
[]
[]
[]
[]
[null,"IESO",null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,{"$f":"'6. Historical Wholesale'!D24","v":1136860},{"$f":"'5. UTRs and Sub-Transmission'!J22","v":3.61},{"$f":"D24*E24","v":4104064.5999999996},null,{"$f":"'6. Historical Wholesale'!H24","v":1087748},{"$f":"'5. UTRs and Sub-Transmission'!J24","v":0.95},{"$f":"H24*I24","v":1033360.6},null,{"$f":"'6. Historical Wholesale'!L24","v":848417},{"$f":"'5. UTRs and Sub-Transmission'!J26","v":2.34},{"$f":"L24*M24","v":1985295.7799999998},null,{"$f":"J24+N24","v":3018656.38}]
[null,"February",null,{"$f":"'6. Historical Wholesale'!D25","v":1096423},{"$f":"E24","v":3.61},3958087.03,null,{"$f":"'6. Historical Wholesale'!H25","v":1104665},{"$f":"I24","v":0.95},1049431.75,null,{"$f":"'6. Historical Wholesale'!L25","v":826309},{"$f":"M24","v":2.34},1933563.0599999998,null,2982994.8099999996]
[null,"March",null,{"$f":"'6. Historical Wholesale'!D26","v":1033711},3.61,3731696.71,null,{"$f":"'6. Historical Wholesale'!H26","v":1064220},0.95,1011009,null,{"$f":"'6. Historical Wholesale'!L26","v":821084},2.34,1921336.5599999998,null,2932345.5599999996]
[null,"April",null,{"$f":"'6. Historical Wholesale'!D27","v":915205},3.61,3303890.05,null,{"$f":"'6. Historical Wholesale'!H27","v":902594},0.95,857464.29999999993,null,{"$f":"'6. Historical Wholesale'!L27","v":697439},2.34,1632007.26,null,2489471.56]
[null,"May",null,{"$f":"'6. Historical Wholesale'!D28","v":1090675},3.61,3937336.75,null,{"$f":"'6. Historical Wholesale'!H28","v":1055778},0.95,1002989.1,null,{"$f":"'6. Historical Wholesale'!L28","v":795710},2.34,1861961.4,null,2864950.5]
[null,"June",null,{"$f":"'6. Historical Wholesale'!D29","v":1282127},3.61,4628478.47,null,{"$f":"'6. Historical Wholesale'!H29","v":1247413},0.95,1185042.3499999999,null,{"$f":"'6. Historical Wholesale'!L29","v":959991},2.34,2246378.94,null,3431421.29]
[null,"July",null,{"$f":"'6. Historical Wholesale'!D30","v":1141223},3.61,4119815.03,null,{"$f":"'6. Historical Wholesale'!H30","v":1186537},0.95,1127210.1499999999,null,{"$f":"'6. Historical Wholesale'!L30","v":881830},2.34,2063482.2,null,3190692.3499999996]
[null,"August",null,{"$f":"'6. Historical Wholesale'!D31","v":1190589},3.61,4298026.29,null,{"$f":"'6. Historical Wholesale'!H31","v":1184128},0.95,1124921.5999999999,null,{"$f":"'6. Historical Wholesale'!L31","v":890870},2.34,2084635.7999999998,null,3209557.3999999994]
[null,"September",null,{"$f":"'6. Historical Wholesale'!D32","v":1293444},3.61,4669332.84,null,{"$f":"'6. Historical Wholesale'!H32","v":1228077},0.95,1166673.1499999999,null,{"$f":"'6. Historical Wholesale'!L32","v":944243},2.34,2209528.6199999996,null,3376201.7699999996]
[null,"October",null,{"$f":"'6. Historical Wholesale'!D33","v":922447},3.61,3330033.67,null,{"$f":"'6. Historical Wholesale'!H33","v":919807},0.95,873816.64999999991,null,{"$f":"'6. Historical Wholesale'!L33","v":736724},2.34,1723934.16,null,2597750.8099999996]
[null,"November",null,{"$f":"'6. Historical Wholesale'!D34","v":1051724},3.61,3796723.6399999997,null,{"$f":"'6. Historical Wholesale'!H34","v":1004242},0.95,954029.89999999991,null,{"$f":"'6. Historical Wholesale'!L34","v":793054},2.34,1855746.3599999999,null,2809776.26]
[null,"December",null,{"$f":"'6. Historical Wholesale'!D35","v":1171569},3.61,4229364.09,null,{"$f":"'6. Historical Wholesale'!H35","v":1170885},0.95,1112340.75,null,{"$f":"'6. Historical Wholesale'!L35","v":895877},2.34,2096352.18,null,3208692.9299999997]
[]
[null,"Total",null,{"$f":"SUM(D24:D35)","v":13325997},{"$f":"IF(D37<>0,F37/D37,0)","v":3.6100000000000003},{"$f":"SUM(F24:F35)","v":48106849.170000002},null,{"$f":"SUM(H24:H35)","v":13156094},{"$f":"IF(H37<>0,J37/H37,0)","v":0.95000000000000007},{"$f":"SUM(J24:J35)","v":12498289.300000001},null,{"$f":"SUM(L24:L35)","v":10091548},{"$f":"IF(L37<>0,N37/L37,0)","v":2.34},{"$f":"SUM(N24:N35)","v":23614222.319999997},null,{"$f":"SUM(P24:P35)","v":36112511.619999997}]
[]
[null,"Hydro One",null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,{"$f":"'6. Historical Wholesale'!D43","v":38503.179999999993},{"$f":"'5. UTRs and Sub-Transmission'!J36","v":3.1941999999999999},{"$f":"D43*E43","v":122986.85755599997},null,{"$f":"'6. Historical Wholesale'!H43","v":4304.0599999999995},{"$f":"'5. UTRs and Sub-Transmission'!J38","v":0.77100000000000002},{"$f":"H43*I43","v":3318.4302599999996},null,{"$f":"'6. Historical Wholesale'!L43","v":40235.329999999994},{"$f":"'5. UTRs and Sub-Transmission'!J40","v":1.7493000000000001},{"$f":"L43*M43","v":70383.662768999988},null,{"$f":"J43+N43","v":73702.093028999981}]
[null,"February",null,{"$f":"'6. Historical Wholesale'!D44","v":39712.06},{"$f":"E43","v":3.1941999999999999},126848.26205199999,null,{"$f":"'6. Historical Wholesale'!H44","v":3883.49},{"$f":"I43","v":0.77100000000000002},2994.1707900000001,null,{"$f":"'6. Historical Wholesale'!L44","v":38940.28},{"$f":"M43","v":1.7493000000000001},68118.231803999995,null,71112.402593999999]
[null,"March",null,{"$f":"'6. Historical Wholesale'!D45","v":38639.49},3.1941999999999999,123422.25895799999,null,{"$f":"'6. Historical Wholesale'!H45","v":4078.8},0.77100000000000002,3144.7548000000002,null,{"$f":"'6. Historical Wholesale'!L45","v":40286.699999999997},1.7493000000000001,70473.524309999993,null,73618.279109999989]
[null,"April",null,{"$f":"'6. Historical Wholesale'!D46","v":34126.94},3.1941999999999999,109008.271748,null,{"$f":"'6. Historical Wholesale'!H46","v":3465.42},0.77100000000000002,2671.8388199999999,null,{"$f":"'6. Historical Wholesale'!L46","v":34382.07},1.7493000000000001,60144.555051000003,null,62816.393871]
[null,"May",null,{"$f":"'6. Historical Wholesale'!D47","v":34711.700000000004},3.1941999999999999,110876.11214000001,null,{"$f":"'6. Historical Wholesale'!H47","v":627.96},0.77100000000000002,484.15716000000003,null,{"$f":"'6. Historical Wholesale'!L47","v":34111.43},1.7493000000000001,59671.124499000005,null,60155.281659000007]
[null,"June",null,{"$f":"'6. Historical Wholesale'!D48","v":46954.11},3.1941999999999999,149980.81816200001,null,{"$f":"'6. Historical Wholesale'!H48","v":744.19},0.77100000000000002,573.77049000000011,null,{"$f":"'6. Historical Wholesale'!L48","v":46249.69},1.7493000000000001,80904.582717000012,null,81478.353207000007]
[null,"July",null,{"$f":"'6. Historical Wholesale'!D49","v":42313},3.1941999999999999,135156.18460000001,null,{"$f":"'6. Historical Wholesale'!H49","v":3716.05},0.77100000000000002,2865.0745500000003,null,{"$f":"'6. Historical Wholesale'!L49","v":41610.71},1.7493000000000001,72789.615002999999,null,75654.689553000004]
[null,"August",null,{"$f":"'6. Historical Wholesale'!D50","v":41704.980000000003},3.1941999999999999,133214.047116,null,{"$f":"'6. Historical Wholesale'!H50","v":3689.31},0.77100000000000002,2844.4580099999998,null,{"$f":"'6. Historical Wholesale'!L50","v":40975.39},1.7493000000000001,71678.249727000002,null,74522.707737000004]
[null,"September",null,{"$f":"'6. Historical Wholesale'!D51","v":47105.590000000004},3.1941999999999999,150464.67557799999,null,{"$f":"'6. Historical Wholesale'!H51","v":3721.11},0.77100000000000002,2868.9758100000004,null,{"$f":"'6. Historical Wholesale'!L51","v":46575},1.7493000000000001,81473.647500000006,null,84342.62331000001]
[null,"October",null,{"$f":"'6. Historical Wholesale'!D52","v":36196.199999999997},3.1941999999999999,115617.90203999999,null,{"$f":"'6. Historical Wholesale'!H52","v":4714},0.77100000000000002,3634.4940000000001,null,{"$f":"'6. Historical Wholesale'!L52","v":35622.54},1.7493000000000001,62314.509222000008,null,65949.003222000014]
[null,"November",null,{"$f":"'6. Historical Wholesale'!D53","v":40811.39},3.1941999999999999,130359.74193799999,null,{"$f":"'6. Historical Wholesale'!H53","v":5409.47},0.77100000000000002,4170.7013700000007,null,{"$f":"'6. Historical Wholesale'!L53","v":43988.25},1.7493000000000001,76948.645725000009,null,81119.347095000005]
[null,"December",null,{"$f":"'6. Historical Wholesale'!D54","v":42636.67},3.1941999999999999,136190.05131399998,null,{"$f":"'6. Historical Wholesale'!H54","v":6664.23},0.77100000000000002,5138.1213299999999,null,{"$f":"'6. Historical Wholesale'!L54","v":42045.880000000005},1.7493000000000001,73550.857884000012,null,78688.979214000006]
[]
[null,"Total",null,{"$f":"SUM(D43:D54)","v":483415.31},{"$f":"IF(D56<>0,F56/D56,0)","v":3.1942000000000004},{"$f":"SUM(F43:F54)","v":1544125.1832020001},null,{"$f":"SUM(H43:H54)","v":45018.09},{"$f":"IF(H56<>0,J56/H56,0)","v":0.77100000000000013},{"$f":"SUM(J43:J54)","v":34708.947390000001},null,{"$f":"SUM(L43:L54)","v":485023.26999999996},{"$f":"IF(L56<>0,N56/L56,0)","v":1.7493000000000005},{"$f":"SUM(N43:N54)","v":848451.20621100022},null,{"$f":"SUM(P43:P54)","v":883160.15360099997}]
[]
[null,{"$f":"'6. Historical Wholesale'!B58","v":"Add Extra Host Here (I)"},null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,{"$f":"'6. Historical Wholesale'!D62","v":0},{"$f":"'5. UTRs and Sub-Transmission'!J51","v":0},{"$f":"D62*E62","v":0},null,{"$f":"'6. Historical Wholesale'!H62","v":0},{"$f":"'5. UTRs and Sub-Transmission'!J53","v":0},{"$f":"H62*I62","v":0},null,{"$f":"'6. Historical Wholesale'!L62","v":0},{"$f":"'5. UTRs and Sub-Transmission'!J55","v":0},{"$f":"L62*M62","v":0},null,{"$f":"J62+N62","v":0}]
[null,"February",null,{"$f":"'6. Historical Wholesale'!D63","v":0},{"$f":"E62","v":0},0,null,{"$f":"'6. Historical Wholesale'!H63","v":0},{"$f":"I62","v":0},0,null,{"$f":"'6. Historical Wholesale'!L63","v":0},{"$f":"M62","v":0},0,null,0]
[null,"March",null,{"$f":"'6. Historical Wholesale'!D64","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H64","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L64","v":0},0,0,null,0]
[null,"April",null,{"$f":"'6. Historical Wholesale'!D65","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H65","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L65","v":0},0,0,null,0]
[null,"May",null,{"$f":"'6. Historical Wholesale'!D66","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H66","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L66","v":0},0,0,null,0]
[null,"June",null,{"$f":"'6. Historical Wholesale'!D67","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H67","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L67","v":0},0,0,null,0]
[null,"July",null,{"$f":"'6. Historical Wholesale'!D68","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H68","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L68","v":0},0,0,null,0]
[null,"August",null,{"$f":"'6. Historical Wholesale'!D69","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H69","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L69","v":0},0,0,null,0]
[null,"September",null,{"$f":"'6. Historical Wholesale'!D70","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H70","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L70","v":0},0,0,null,0]
[null,"October",null,{"$f":"'6. Historical Wholesale'!D71","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H71","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L71","v":0},0,0,null,0]
[null,"November",null,{"$f":"'6. Historical Wholesale'!D72","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H72","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L72","v":0},0,0,null,0]
[null,"December",null,{"$f":"'6. Historical Wholesale'!D73","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H73","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L73","v":0},0,0,null,0]
[]
[null,"Total",null,{"$f":"SUM(D62:D73)","v":0},{"$f":"IF(D75<>0,F75/D75,0)","v":0},{"$f":"SUM(F62:F73)","v":0},null,{"$f":"SUM(H62:H73)","v":0},{"$f":"IF(H75<>0,J75/H75,0)","v":0},{"$f":"SUM(J62:J73)","v":0},null,{"$f":"SUM(L62:L73)","v":0},{"$f":"IF(L75<>0,N75/L75,0)","v":0},{"$f":"SUM(N62:N73)","v":0},null,{"$f":"SUM(P62:P73)","v":0}]
[]
[null,{"$f":"'6. Historical Wholesale'!B77","v":"Add Extra Host Here (II)"},null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,{"$f":"'6. Historical Wholesale'!D81","v":0},{"$f":"'5. UTRs and Sub-Transmission'!J66","v":0},{"$f":"D81*E81","v":0},null,{"$f":"'6. Historical Wholesale'!H81","v":0},{"$f":"'5. UTRs and Sub-Transmission'!J68","v":0},{"$f":"H81*I81","v":0},null,{"$f":"'6. Historical Wholesale'!L81","v":0},{"$f":"'5. UTRs and Sub-Transmission'!J70","v":0},{"$f":"L81*M81","v":0},null,{"$f":"J81+N81","v":0}]
[null,"February",null,{"$f":"'6. Historical Wholesale'!D82","v":0},{"$f":"E81","v":0},0,null,{"$f":"'6. Historical Wholesale'!H82","v":0},{"$f":"I81","v":0},0,null,{"$f":"'6. Historical Wholesale'!L82","v":0},{"$f":"M81","v":0},0,null,0]
[null,"March",null,{"$f":"'6. Historical Wholesale'!D83","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H83","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L83","v":0},0,0,null,0]
[null,"April",null,{"$f":"'6. Historical Wholesale'!D84","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H84","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L84","v":0},0,0,null,0]
[null,"May",null,{"$f":"'6. Historical Wholesale'!D85","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H85","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L85","v":0},0,0,null,0]
[null,"June",null,{"$f":"'6. Historical Wholesale'!D86","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H86","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L86","v":0},0,0,null,0]
[null,"July",null,{"$f":"'6. Historical Wholesale'!D87","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H87","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L87","v":0},0,0,null,0]
[null,"August",null,{"$f":"'6. Historical Wholesale'!D88","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H88","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L88","v":0},0,0,null,0]
[null,"September",null,{"$f":"'6. Historical Wholesale'!D89","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H89","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L89","v":0},0,0,null,0]
[null,"October",null,{"$f":"'6. Historical Wholesale'!D90","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H90","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L90","v":0},0,0,null,0]
[null,"November",null,{"$f":"'6. Historical Wholesale'!D91","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H91","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L91","v":0},0,0,null,0]
[null,"December",null,{"$f":"'6. Historical Wholesale'!D92","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!H92","v":0},0,0,null,{"$f":"'6. Historical Wholesale'!L92","v":0},0,0,null,0]
[]
[null,"Total",null,{"$f":"SUM(D81:D92)","v":0},{"$f":"IF(D94<>0,F94/D94,0)","v":0},{"$f":"SUM(F81:F92)","v":0},null,{"$f":"SUM(H81:H92)","v":0},{"$f":"IF(H94<>0,J94/H94,0)","v":0},{"$f":"SUM(J81:J92)","v":0},null,{"$f":"SUM(L81:L92)","v":0},{"$f":"IF(L94<>0,N94/L94,0)","v":0},{"$f":"SUM(N81:N92)","v":0},null,{"$f":"SUM(P81:P92)","v":0}]
[]
[null,"Total",null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,{"$f":"D24+D43+D62+D81","v":1175363.18},{"$f":"IF(D100<>0,F100/D100,0)","v":3.5963789996858675},{"$f":"F24+F43+F62+F81","v":4227051.457556},null,{"$f":"H24+H43+H62+H81","v":1092052.06},{"$f":"IF(H100<>0,J100/H100,0)","v":0.94929451464062986},{"$f":"J24+J43+J62+J81","v":1036679.03026},null,{"$f":"L24+L43+L62+L81","v":888652.33},{"$f":"IF(L100<>0,N100/L100,0)","v":2.3132549967758482},{"$f":"N24+N43+N62+N81","v":2055679.4427689998},null,{"$f":"J100+N100","v":3092358.4730289998}]
[null,"February",null,{"$f":"D25+D44+D63+D82","v":1136135.06},3.5954662749796662,4084935.2920519998,null,{"$f":"H25+H44+H63+H82","v":1108548.49},0.9493729234974646,{"$f":"J25+J44+J63+J82","v":1052425.9207899999},null,{"$f":"L25+L44+L63+L82","v":865249.28000000003},2.3134157266262041,{"$f":"N25+N44+N63+N82","v":2001681.2918039998},null,3054107.2125939997]
[null,"March",null,1072350.49,3.5950176783693171,3855118.9689579997,null,{"$f":"H26+H45+H64+H83","v":1068298.8},0.94931657210510767,{"$f":"J26+J45+J64+J83","v":1014153.7548},null,{"$f":"L26+L45+L64+L83","v":861370.7},2.3123726919315923,{"$f":"N26+N45+N64+N83","v":1991810.0843099998},null,3005963.8391100001]
[null,"April",null,949331.94,3.5950526659284212,3412898.3217479996,null,{"$f":"H27+H46+H65+H84","v":906059.42},0.9493153758282209,{"$f":"J27+J46+J65+J84","v":860136.13881999988},null,{"$f":"L27+L46+L65+L84","v":731821.07},2.3122480130983387,{"$f":"N27+N46+N65+N84","v":1692151.8150510001},null,2552287.9538710001]
[null,"May",null,1125386.7,3.5971749640723494,4048212.8621399999,null,{"$f":"H28+H47+H66+H85","v":1056405.96},0.9498935969274539,{"$f":"J28+J47+J66+J85","v":1003473.2571599999},null,{"$f":"L28+L47+L66+L85","v":829821.43},2.3157181232340549,{"$f":"N28+N47+N66+N85","v":1921632.5244989998},null,2925105.7816589996]
[null,"June",null,1329081.1100000001,3.5953105135637653,4778459.2881619995,null,{"$f":"H29+H48+H67+H86","v":1248157.19},0.94989327465236961,{"$f":"J29+J48+J67+J86","v":1185616.1204899999},null,{"$f":"L29+L48+L67+L86","v":1006240.69},2.3128497444453378,{"$f":"N29+N48+N67+N86","v":2327283.522717},null,3512899.6432069996]
[null,"July",null,1183536,3.5951345921036619,4254971.2145999996,null,{"$f":"H30+H49+H68+H87","v":1190253.05},0.94944114997226836,{"$f":"J30+J49+J68+J87","v":1130075.2245499999},null,{"$f":"L30+L49+L68+L87","v":923440.71},2.3133827563255251,{"$f":"N30+N49+N68+N87","v":2136271.8150029997},null,3266347.0395529997]
[null,"August",null,1232293.98,3.5959279271298561,4431240.3371160002,null,{"$f":"H31+H50+H69+H88","v":1187817.31},0.949444033619951,{"$f":"J31+J50+J69+J88","v":1127766.0580099998},null,{"$f":"L31+L50+L69+L88","v":931845.39},2.3140255592475483,{"$f":"N31+N50+N69+N88","v":2156314.0497269998},null,3284080.1077369996]
[null,"September",null,1340549.5900000001,3.595389198230257,4819797.5155779999,null,{"$f":"H32+H51+H70+H89","v":1231798.1100000001},0.94945926310115847,{"$f":"J32+J51+J70+J89","v":1169542.1258099999},null,{"$f":"L32+L51+L70+L89","v":990818},2.3122331926751429,{"$f":"N32+N51+N70+N89","v":2291002.2674999996},null,3460544.3933099993]
[null,"October",null,958643.19999999995,3.594300332010909,3445651.57204,null,{"$f":"H33+H52+H71+H90","v":924521},0.94908730466912039,{"$f":"J33+J52+J71+J90","v":877451.14399999985},null,{"$f":"L33+L52+L71+L90","v":772346.54},2.3127554494152323,{"$f":"N33+N52+N71+N90","v":1786248.6692219998},null,2663699.8132219994]
[null,"November",null,1092535.3899999999,3.594467893564528,3927083.3819379997,null,{"$f":"H34+H53+H72+H91","v":1009651.47},0.9490409610060786,{"$f":"J34+J53+J72+J91","v":958200.60136999993},null,{"$f":"L34+L53+L72+L91","v":837042.25},2.30895752959304,{"$f":"N34+N53+N72+N91","v":1932695.0057249998},null,2890895.6070949999]
[null,"December",null,1214205.67,3.5953992385112152,4365554.1413139999,null,{"$f":"H35+H54+H73+H92","v":1177549.23},0.94898696620098,{"$f":"J35+J54+J73+J92","v":1117478.87133},null,{"$f":"L35+L54+L73+L92","v":937922.88},2.3135196764620987,{"$f":"N35+N54+N73+N92","v":2169903.0378839998},null,3287381.9092139998]
[]
[null,"Total",null,{"$f":"SUM(D100:D111)","v":13809412.310000001},{"$f":"IF(D113<>0,F113/D113,0)","v":3.5954444141875288},{"$f":"SUM(F100:F111)","v":49650974.353202},null,{"$f":"SUM(H100:H111)","v":13201112.09},{"$f":"IF(H113<>0,J113/H113,0)","v":0.94938957884342901},{"$f":"SUM(J100:J111)","v":12532998.247389998},null,{"$f":"SUM(L100:L111)","v":10576571.270000001},{"$f":"IF(L113<>0,N113/L113,0)","v":2.3129115194068937},{"$f":"SUM(N100:N111)","v":24462673.526211001},null,{"$f":"SUM(P100:P111)","v":36995671.773600996}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Low Voltage Switchgear Credit (if applicable)",null,{"$f":"'5. UTRs and Sub-Transmission'!J75","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total including deduction for Low Voltage Switchgear Credit",null,{"$f":"P113+P115","v":36995671.773600996}]

{"sheet":"9. RTSR Rates to Forecast","index":8,"n_rows":60,"n_cols":10,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The purpose of this sheet is to re-align the current RTS Network Rates to recover current wholesale network costs."]
[]
["Rate Class","Rate Description","Unit","Current RTSR-Network","Loss Adjusted Billed kWh","Billed kW","Billed Amount","Billed Amount %","Current Wholesale Billing","Adjusted RTSR Network"]
[]
["Residential","RTSR - Network","kWh",7.1999999999999998E-3,2262217027.473,null,{"$f":"ROUND(D17*E17, 2)","v":16287962.6},{"$f":"G17/48868960.72","v":0.33329873113782071},{"$f":"H17*total_current_wholesale_network","v":16548606.751678705},{"$f":"IF(ISERROR(I17/E17), 0, I17/E17)","v":7.3152162461460456E-3}]
["General Service Less Than 50 kW","RTSR - Network","kWh",6.7000000000000002E-3,736232999.7750001,null,{"$f":"ROUND(D18*E18, 2)","v":4932761.0999999996},{"$f":"G18/48868960.72","v":0.10093853086548717},{"$f":"H18*total_current_wholesale_network","v":5011696.4072521916},{"$f":"IF(ISERROR(I18/E18), 0, I18/E18)","v":6.8072151191047054E-3}]
["General Service 50 to 1,499 kW","RTSR - Network","kW",2.7422,null,6985551,{"$f":"ROUND(D19*F19, 2)","v":19155777.949999999},{"$f":"G19/48868960.72","v":0.3919825113481562},{"$f":"H19*total_current_wholesale_network","v":19462313.617851015},{"$f":"IF(ISERROR(I19/F19), 0, I19/F19)","v":2.786081386829903}]
["General Service 1,500 to 4,999 kW","RTSR - Network","kW",2.8472,null,1649388,{"$f":"ROUND(D20*F20, 2)","v":4696137.51},{"$f":"G20/48868960.72","v":9.6096529183565579E-2},{"$f":"H20*total_current_wholesale_network","v":4771286.3059249418},{"$f":"IF(ISERROR(I20/F20), 0, I20/F20)","v":2.892761621840914}]
["Large Use > 5000 kW","RTSR - Network","kW",3.1562999999999999,null,1100755,{"$f":"ROUND(D21*F21, 2)","v":3474313.01},{"$f":"G21/48868960.72","v":7.1094473031797265E-2},{"$f":"H21*total_current_wholesale_network","v":3529909.8571561771},{"$f":"IF(ISERROR(I21/F21), 0, I21/F21)","v":3.2068079247027512}]
["Unmetered Scattered Load","RTSR - Network","kWh",6.7000000000000002E-3,15740581.194000002,null,{"$f":"ROUND(D22*E22, 2)","v":105461.89},{"$f":"G22/48868960.72","v":2.1580546925123968E-3},{"$f":"H22*total_current_wholesale_network","v":107149.51819074024},{"$f":"IF(ISERROR(I22/E22), 0, I22/E22)","v":6.8072148588505434E-3}]
["Sentinel Lighting","RTSR - Network","kW",2.0243000000000002,null,142,{"$f":"ROUND(D23*F23, 2)","v":287.45},{"$f":"G23/48868960.72","v":5.8820567445044697E-6},{"$f":"H23*total_current_wholesale_network","v":292.04984856547026},{"$f":"IF(ISERROR(I23/F23), 0, I23/F23)","v":2.0566890744047202}]
["Street Lighting","RTSR - Network","kW",2.0345,null,106296,{"$f":"ROUND(D24*F24, 2)","v":216259.21},{"$f":"G24/48868960.72","v":4.4252876839161884E-3},{"$f":"H24*total_current_wholesale_network","v":219719.84529966334},{"$f":"IF(ISERROR(I24/F24), 0, I24/F24)","v":2.0670565712695055}]
[]
["The purpose of this table is to re-align the current RTS Connection Rates to recover current wholesale connection costs."]
["Rate Class","Rate Description","Unit","Current RTSR-Connection","Loss Adjusted Billed kWh","Billed kW","Billed Amount","Billed Amount %","Current Wholesale Billing","Adjusted RTSR-Connection"]
[]
["Residential","RTSR - Connection","kWh",4.8999999999999998E-3,2262217027.473,null,{"$f":"ROUND(D29*E29, 2)","v":11084863.43},{"$f":"G29/34014008.45","v":0.32589112354383504},{"$f":"H29*Total_Current_Wholesale_Lineplus","v":12056561.040557772},{"$f":"IF(ISERROR(I29/E29), 0, I29/E29)","v":5.3295333268822149E-3}]
["General Service Less Than 50 kW","RTSR - Connection","kWh",4.7000000000000002E-3,736232999.7750001,null,{"$f":"ROUND(D30*E30, 2)","v":3460295.1},{"$f":"G30/34014008.45","v":0.10173147058179201},{"$f":"H30*Total_Current_Wholesale_Lineplus","v":3763624.0946897226},{"$f":"IF(ISERROR(I30/E30), 0, I30/E30)","v":5.1120013580482297E-3}]
["General Service 50 to 1,499 kW","RTSR - Connection","kW",1.9100999999999999,null,6985551,{"$f":"ROUND(D31*F31, 2)","v":13343100.970000001},{"$f":"G31/34014008.45","v":0.39228252058601459},{"$f":"H31*Total_Current_Wholesale_Lineplus","v":14512755.374121072},{"$f":"IF(ISERROR(I31/F31), 0, I31/F31)","v":2.0775391052360899}]
["General Service 1,500 to 4,999 kW","RTSR - Connection","kW",2.0413999999999999,null,1649388,{"$f":"ROUND(D32*F32, 2)","v":3367060.66},{"$f":"G32/34014008.45","v":9.8990410523050243E-2},{"$f":"H32*Total_Current_Wholesale_Lineplus","v":3662216.7364447848},{"$f":"IF(ISERROR(I32/F32), 0, I32/F32)","v":2.2203488423856514}]
["Large Use > 5000 kW","RTSR - Connection","kW",2.2989000000000002,null,1100755,{"$f":"ROUND(D33*F33, 2)","v":2530525.67},{"$f":"G33/34014008.45","v":7.4396573215410003E-2},{"$f":"H33*Total_Current_Wholesale_Lineplus","v":2752351.2037579836},{"$f":"IF(ISERROR(I33/F33), 0, I33/F33)","v":2.5004212597335318}]
["Unmetered Scattered Load","RTSR - Connection","kWh",4.7000000000000002E-3,15740581.194000002,null,{"$f":"ROUND(D34*E34, 2)","v":73980.73},{"$f":"G34/34014008.45","v":2.1750076915736166E-3},{"$f":"H34*Total_Current_Wholesale_Lineplus","v":80465.87066251511},{"$f":"IF(ISERROR(I34/E34), 0, I34/E34)","v":5.1120012451120363E-3}]
["Sentinel Lighting","RTSR - Connection","kW",1.419,null,142,{"$f":"ROUND(D35*F35, 2)","v":201.5},{"$f":"G35/34014008.45","v":5.9240298095474835E-6},{"$f":"H35*Total_Current_Wholesale_Lineplus","v":219.16346241104671},{"$f":"IF(ISERROR(I35/F35), 0, I35/F35)","v":1.5434046648665261}]
["Street Lighting","RTSR - Connection","kW",1.4486000000000001,null,106296,{"$f":"ROUND(D36*F36, 2)","v":153980.39000000001},{"$f":"G36/34014008.45","v":4.5269698285148744E-3},{"$f":"H36*Total_Current_Wholesale_Lineplus","v":167478.28990473106},{"$f":"IF(ISERROR(I36/F36), 0, I36/F36)","v":1.5755841226831777}]
[]
["The purpose of this table is to update the re-aligned RTS Network Rates to recover future wholesale network costs."]
["Rate Class","Rate Description","Unit","Adjusted RTSR-Network","Loss Adjusted Billed kWh","Billed kW","Billed Amount","Billed Amount %","Current Wholesale Billing","Proposed RTSR-Network"]
[]
["Residential","RTSR - Network","kWh",7.3152162461460456E-3,2262217027.473,null,{"$f":"IF(ISERROR(D41*E41), 0, ROUND(D41*E41, 2))","v":16548606.75},{"$f":"G41/49650974.37","v":0.33329873099124846},{"$f":"H41*forecast_wholesale_network","v":16548606.74440125},{"$f":"IF(ISERROR(I41/E41), 0, I41/E41)","v":7.3152162429290886E-3}]
["General Service Less Than 50 kW","RTSR - Network","kWh",6.8072151191047054E-3,736232999.7750001,null,{"$f":"IF(ISERROR(D42*E42), 0, ROUND(D42*E42, 2))","v":5011696.41},{"$f":"G42/49650974.37","v":0.10093853088667996},{"$f":"H42*forecast_wholesale_network","v":5011696.4083044352},{"$f":"IF(ISERROR(I42/E42), 0, I42/E42)","v":6.8072151205339311E-3}]
["General Service 50 to 1,499 kW","RTSR - Network","kW",2.786081386829903,null,6985551,{"$f":"ROUND(D43*F43, 2)","v":19462313.620000001},{"$f":"G43/49650974.37","v":0.39198251125882189},{"$f":"H43*forecast_wholesale_network","v":19462313.61341548},{"$f":"IF(ISERROR(I43/F43), 0, I43/F43)","v":2.7860813861949443}]
["General Service 1,500 to 4,999 kW","RTSR - Network","kW",2.892761621840914,null,1649388,{"$f":"ROUND(D44*F44, 2)","v":4771286.3099999996},{"$f":"G44/49650974.37","v":9.6096529233128114E-2},{"$f":"H44*forecast_wholesale_network","v":4771286.3083857698},{"$f":"IF(ISERROR(I44/F44), 0, I44/F44)","v":2.8927616233328783}]
["Large Use > 5000 kW","RTSR - Network","kW",3.2068079247027512,null,1100755,{"$f":"ROUND(D45*F45, 2)","v":3529909.86},{"$f":"G45/49650974.37","v":7.1094473065020744E-2},{"$f":"H45*forecast_wholesale_network","v":3529909.8588057552},{"$f":"IF(ISERROR(I45/F45), 0, I45/F45)","v":3.2068079262013391}]
["Unmetered Scattered Load","RTSR - Network","kWh",6.8072148588505434E-3,15740581.194000002,null,{"$f":"IF(ISERROR(D46*E46), 0, ROUND(D46*E46, 2))","v":107149.52},{"$f":"G46/49650974.37","v":2.1580547282218422E-3},{"$f":"H46*forecast_wholesale_network","v":107149.519963749},{"$f":"IF(ISERROR(I46/E46), 0, I46/E46)","v":6.8072149714898883E-3}]
["Sentinel Lighting","RTSR - Network","kW",2.0566890744047202,null,142,{"$f":"ROUND(D47*F47, 2)","v":292.05},{"$f":"G47/49650974.37","v":5.8820597924954683E-6},{"$f":"H47*forecast_wholesale_network","v":292.04999990119319},{"$f":"IF(ISERROR(I47/F47), 0, I47/F47)","v":2.0566901401492479}]
["Street Lighting","RTSR - Network","kW",2.0670565712695055,null,106296,{"$f":"ROUND(D48*F48, 2)","v":219719.85},{"$f":"G48/49650974.37","v":4.4252877770865791E-3},{"$f":"H48*forecast_wholesale_network","v":219719.84992566402},{"$f":"IF(ISERROR(I48/F48), 0, I48/F48)","v":2.0670566147894935}]
[]
["The purpose of this table is to update the re-aligned RTS Connection Rates to recover future wholesale connection costs."]
["Rate Class","Rate Description","Unit","Adjusted RTSR-Connection","Loss Adjusted Billed kWh","Billed kW","Billed Amount","Billed Amount %","Current Wholesale Billing","Proposed RTSR-Connection"]
[]
["Residential","RTSR - Connection","kWh",5.3295333268822149E-3,2262217027.473,null,{"$f":"ROUND(D53*E53, 2)","v":12056561.039999999},{"$f":"G53/36995671.76","v":0.32589112364856809},{"$f":"H53*forecast_wholesale_lineplus","v":12056561.044432443},{"$f":"IF(ISERROR(I53/E53), 0, I53/E53)","v":5.3295333285949906E-3}]
["General Service Less Than 50 kW","RTSR - Connection","kWh",5.1120013580482297E-3,736232999.7750001,null,{"$f":"ROUND(D54*E54, 2)","v":3763624.09},{"$f":"G54/36995671.76","v":0.10173147049242823},{"$f":"H54*forecast_wholesale_lineplus","v":3763624.0913836495},{"$f":"IF(ISERROR(I54/E54), 0, I54/E54)","v":5.1120013535577045E-3}]
["General Service 50 to 1,499 kW","RTSR - Connection","kW",2.0775391052360899,null,6985551,{"$f":"ROUND(D55*F55, 2)","v":14512755.369999999},{"$f":"G55/36995671.76","v":0.392282520618839},{"$f":"H55*forecast_wholesale_lineplus","v":14512755.375335433},{"$f":"IF(ISERROR(I55/F55), 0, I55/F55)","v":2.0775391054099286}]
["General Service 1,500 to 4,999 kW","RTSR - Connection","kW",2.2203488423856514,null,1649388,{"$f":"ROUND(D56*F56, 2)","v":3662216.74},{"$f":"G56/36995671.76","v":9.8990410655540984E-2},{"$f":"H56*forecast_wholesale_lineplus","v":3662216.7413463686},{"$f":"IF(ISERROR(I56/F56), 0, I56/F56)","v":2.2203488453574103}]
["Large Use > 5000 kW","RTSR - Connection","kW",2.5004212597335318,null,1100755,{"$f":"ROUND(D57*F57, 2)","v":2752351.2},{"$f":"G57/36995671.76","v":7.4396573141181976E-2},{"$f":"H57*forecast_wholesale_lineplus","v":2752351.2010118682},{"$f":"IF(ISERROR(I57/F57), 0, I57/F57)","v":2.5004212572387754}]
["Unmetered Scattered Load","RTSR - Connection","kWh",5.1120012451120363E-3,15740581.194000002,null,{"$f":"ROUND(D58*E58, 2)","v":80465.87},{"$f":"G58/36995671.76","v":2.1750076744653222E-3},{"$f":"H58*forecast_wholesale_lineplus","v":80465.870029582264},{"$f":"IF(ISERROR(I58/E58), 0, I58/E58)","v":5.1120012049017775E-3}]
["Sentinel Lighting","RTSR - Connection","kW",1.5434046648665261,null,142,{"$f":"ROUND(D59*F59, 2)","v":219.16},{"$f":"G59/36995671.76","v":5.9239362221003773E-6},{"$f":"H59*forecast_wholesale_lineplus","v":219.16000008057145},{"$f":"IF(ISERROR(I59/F59), 0, I59/F59)","v":1.5433802822575455}]
["Street Lighting","RTSR - Connection","kW",1.5755841226831777,null,106296,{"$f":"ROUND(D60*F60, 2)","v":167478.29},{"$f":"G60/36995671.76","v":4.5269698327542957E-3},{"$f":"H60*forecast_wholesale_lineplus","v":167478.29006157132},{"$f":"IF(ISERROR(I60/F60), 0, I60/F60)","v":1.5755841241586825}]

{"sheet":"hidden1","index":9,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[{"$f":"IF('3. Rate Classes'!L17=1, '3. Rate Classes'!C17, \"\")","v":"Residential"},1]
[{"$f":"IF('3. Rate Classes'!L18=1, '3. Rate Classes'!C18, \"\")","v":"General Service Less Than 50 kW"},2]
[{"$f":"IF('3. Rate Classes'!L19=1, '3. Rate Classes'!C19, \"\")","v":"General Service 50 to 1,499 kW"},3]
[{"$f":"IF('3. Rate Classes'!L20=1, '3. Rate Classes'!C20, \"\")","v":"General Service 1,500 to 4,999 kW"},4]
[{"$f":"IF('3. Rate Classes'!L21=1, '3. Rate Classes'!C21, \"\")","v":"Large Use > 5000 kW"},5]
[{"$f":"IF('3. Rate Classes'!L22=1, '3. Rate Classes'!C22, \"\")","v":"Unmetered Scattered Load"},6]
[{"$f":"IF('3. Rate Classes'!L23=1, '3. Rate Classes'!C23, \"\")","v":"Sentinel Lighting"},7]
[{"$f":"IF('3. Rate Classes'!L24=1, '3. Rate Classes'!C24, \"\")","v":"Street Lighting"},8]
[{"$f":"IF('3. Rate Classes'!L25=1, '3. Rate Classes'!C25, \"\")","v":""},9]
[{"$f":"IF('3. Rate Classes'!L26=1, '3. Rate Classes'!C26, \"\")","v":""},10]
[{"$f":"IF('3. Rate Classes'!L27=1, '3. Rate Classes'!C27, \"\")","v":""},11]
[{"$f":"IF('3. Rate Classes'!L28=1, '3. Rate Classes'!C28, \"\")","v":""},12]
[{"$f":"IF('3. Rate Classes'!L29=1, '3. Rate Classes'!C29, \"\")","v":""},13]
[{"$f":"IF('3. Rate Classes'!L30=1, '3. Rate Classes'!C30, \"\")","v":""},14]
[{"$f":"IF('3. Rate Classes'!L31=1, '3. Rate Classes'!C31, \"\")","v":""},15]
[{"$f":"IF('3. Rate Classes'!L32=1, '3. Rate Classes'!C32, \"\")","v":""},16]
[{"$f":"IF('3. Rate Classes'!L33=1, '3. Rate Classes'!C33, \"\")","v":""},17]
[{"$f":"IF('3. Rate Classes'!L34=1, '3. Rate Classes'!C34, \"\")","v":""},18]
[{"$f":"IF('3. Rate Classes'!L35=1, '3. Rate Classes'!C35, \"\")","v":""},19]
[{"$f":"IF('3. Rate Classes'!L36=1, '3. Rate Classes'!C36, \"\")","v":""},20]
[{"$f":"IF('3. Rate Classes'!L37=1, '3. Rate Classes'!C37, \"\")","v":""},21]
[{"$f":"IF('3. Rate Classes'!L38=1, '3. Rate Classes'!C38, \"\")","v":""},22]