{"text_format":"1","workbook":"xlsx","n_sheets":14,"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. Adj Network to Current WS","10. Adj Conn. to Current WS","11. Adj Network to Forecast WS","12. Adj Conn. to Forecast WS","13. Final 2014 RTS Rates","hidden1"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":2,"defined_names":12,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1. Info","index":0,"n_rows":77,"n_cols":28,"rows_kept":77,"cut":false,"hidden":false,"merged":[[24,3,24,4],[20,3,20,4],[1,2,1,9],[2,2,2,9],[3,2,3,9],[4,2,4,9],[14,3,14,4],[16,3,16,4]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Algoma Power Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Atikokan Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attawapiskat Power Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bluewater Power Distribution Corp."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brant County Power"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brantford Power Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Burlington Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cambridge and North Dumfries Hydro"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Canadian Niagara Power Inc. – Eastern Ontario Power/Fort Erie/Port Colborne"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Centre Wellington Hydro Ltd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chapleau Public Utilities Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COLLUS Power Corp."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cooperative Hydro Embrun Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E.L.K. Energy Inc."]
[null,null,"Utility Name   ","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,"Enersource Hydro Mississauga Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Entegrus Powerlines Inc."]
[null,null,"Service Territory",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENWIN Utilities Ltd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Erie Thames Powerlines Corp."]
[null,null,"Assigned EB Number","EB-2013-0143",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,"Name and Title","Jane Scott, Manager Rates & Revenue",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,"Phone Number","613-738-5499 ext 7499",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,"Email Address","janescott@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,"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,"Date","2013-08-16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Haldimand County Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Halton Hills Hydro Inc."]
[null,null,"Last COS Re-based Year",2012,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hearst Power Distribution Co. Ltd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Horizon Utilities Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro 2000 Inc."]
["Note:  Drop-down lists are shaded blue; Input cells are shaded green.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro Hawkesbury Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro One Brampton Networks Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro One Networks Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro One Remote Communities Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro Ottawa Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Innisfil Hydro Dist. Systems Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kashechewan Power Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kenora Hydro Electric Corporation Ltd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kingston Hydro Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kitchener-Wilmot Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lakefront Utilities Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lakeland Power Distribution Ltd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"London Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Midland Power Utility Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Milton Hydro Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Newmarket – Tay Power Distribution Ltd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Niagara Peninsula Energy Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Niagara-on-the-Lake Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Norfolk Power Distribution Ltd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"North Bay Hydro Distribution Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Northern Ontario Wires Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oakville Hydro Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orangeville Hydro Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orillia Power Distribution Corp."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oshawa PUC Networks Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ottawa River Power Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parry Sound Power Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Peterborough Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PowerStream Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PUC Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Renfrew Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rideau St. Lawrence Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St. Thomas Energy Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sioux Lookout Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thunder Bay Hydro Electricity Distribution"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tillsonburg Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Toronto Hydro-Electric System Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Veridian Connections Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wasaga Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waterloo North Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Welland Hydro Electric System Corp."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wellington North Power Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"West Coast Huron Energy Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Westario Power Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whitby Hydro Electric Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Woodstock Hydro Services Inc."]

{"sheet":"2. Table of Contents","index":1,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"1. Info",null,null,null,null,"7. Current Wholesale"]
[]
[null,null,null,"2. Table of Contents",null,null,null,null,"8. Forecast Wholesale"]
[]
[null,null,null,"3. Rate Classes",null,null,null,null,"9. Adj Network to Current WS"]
[]
[null,null,null,"4. RRR Data",null,null,null,null,"10. Adj Conn. to Current WS"]
[]
[null,null,null,"5. UTRs and Sub-Transmission",null,null,null,null,"11. Adj Network to Forecast WS"]
[]
[null,null,null,"6. Historical Wholesale",null,null,null,null,"12. Adj Conn. to Forecast WS"]
[]
[null,null,null,null,null,null,null,null,"13. Final 2013 RTS Rates"]

{"sheet":"3. Rate Classes","index":2,"n_rows":115,"n_cols":28,"rows_kept":115,"cut":false,"hidden":false,"merged":[[12,2,12,13],[47,2,47,5],[43,2,43,5],[44,2,44,5],[45,2,45,5],[46,2,46,5],[42,2,42,5],[37,2,37,5],[38,9,38,10],[39,9,39,10],[44,12,44,13],[38,2,38,5],[40,12,40,13],[43,9,43,10],[29,2,29,5],[30,2,30,5],[44,9,44,10],[39,2,39,5],[40,2,40,5],[41,2,41,5],[40,9,40,10],[41,9,41,10],[42,9,42,10],[36,2,36,5],[23,2,23,5],[24,2,24,5],[25,2,25,5],[26,2,26,5],[27,2,27,5],[28,2,28,5],[34,12,34,13],[35,12,35,13],[31,2,31,5],[32,2,32,5],[33,2,33,5],[34,2,34,5],[35,2,35,5],[31,9,31,10],[32,9,32,10],[33,9,33,10],[31,12,31,13],[32,12,32,13],[33,12,33,13],[37,9,37,10],[23,9,23,10],[24,9,24,10],[25,9,25,10],[26,9,26,10],[27,9,27,10],[28,9,28,10],[29,9,29,10],[30,9,30,10],[34,9,34,10],[35,9,35,10],[36,9,36,10],[27,12,27,13],[28,12,28,13],[29,12,29,13],[30,12,30,13],[23,12,23,13],[24,12,24,13],[25,12,25,13],[26,12,26,13],[41,12,41,13],[42,12,42,13],[43,12,43,13],[36,12,36,13],[37,12,37,13],[38,12,38,13],[39,12,39,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,null,null,null,"Unit",null,"RTSR-Network",null,null,"RTSR-Connection"]
[]
[null,null,"Residential",null,null,null,null,"kWh",null,7.3000000000000001E-3,null,null,4.1999999999999997E-3,null,null,null,{"$f":"IF(OR(ISBLANK(C24), ISERROR(FIND(\"Choose\", C24))=FALSE), 0, 1)","v":1},{"$f":"\"C\" & ROW(C24)","v":"C24"},{"$f":"IF(OR(C24=\"General Service Intermediate Rate Class 1,000 To 4,999 kW (formerly General Service > 50 kW Customers)\", C24=\"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,null,null,null,"kWh",null,6.6E-3,null,null,4.0000000000000001E-3,null,null,null,1,"C25",{"$f":"IF(OR(C25=\"General Service Intermediate Rate Class 1,000 To 4,999 kW (formerly General Service > 50 kW Customers)\", C25=\"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,null,null,null,"kW",null,2.7448000000000001,null,null,1.5945,null,null,null,1,"C26","",null,null,null,null,null,null,null,null,"Residential Regular"]
[null,null,"General Service 1,500 to 4,999 kW",null,null,null,null,"kW",null,2.85,null,null,1.704,null,null,null,1,"C27","",null,null,null,null,null,null,null,null,"Residential Urban"]
[null,null,"Large Use",null,null,null,null,"kW",null,3.1593,null,null,1.9189000000000001,null,null,null,1,"C28","",null,null,null,null,null,null,null,null,"Residential Urban Year-Round"]
[null,null,"Unmetered Scattered Load",null,null,null,null,"kWh",null,6.6E-3,null,null,4.0000000000000001E-3,null,null,null,1,"C29","",null,null,null,null,null,null,null,null,"Residential Suburban"]
[null,null,"Standby Power General Service 50 to 1,499 kW",null,null,null,null,"kW",null,null,null,null,null,null,null,null,1,"C30","",null,null,null,null,null,null,null,null,"Residential Suburban Seasonal"]
[null,null,"Standby Power General Service 1,500 to 4,999 kW",null,null,null,null,"kW",null,null,null,null,null,null,null,null,1,"C31","",null,null,null,null,null,null,null,null,"Residential Suburban Year Round"]
[null,null,"Standby Power General Service Large Use",null,null,null,null,"kW",null,null,null,null,null,null,null,null,1,"C32","",null,null,null,null,null,null,null,null,"Residential - Time of Use"]
[null,null,"Sentinel Lighting",null,null,null,null,"kW",null,2.0261999999999998,null,null,1.1845000000000001,null,null,null,1,"C33","",null,null,null,null,null,null,null,null,"Residential - Hensall"]
[null,null,"Street Lighting",null,null,null,null,"kW",null,2.0365000000000002,null,null,1.2092000000000001,null,null,null,1,"C34","",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,null,null,null,null,null,0,"C35","",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,null,null,null,null,null,0,"C36","",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,null,null,null,null,null,0,"C37","",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,null,null,null,null,null,0,"C38","",null,null,null,null,null,null,null,null,"Residential – Urban [UR]"]
[null,null,"Choose Rate Class",null,null,null,null,null,null,null,null,null,null,null,null,null,0,"C39",""]
[null,null,"Choose Rate Class",null,null,null,null,null,null,null,null,null,null,null,null,null,0,"C40","",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,null,null,null,null,null,0,"C41","",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,null,null,null,null,null,0,"C42","",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,null,null,null,null,null,0,"C43","",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,null,null,null,null,null,0,"C44","",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,null,null,null,null,null,0,"C45","",null,null,null,null,null,null,null,null,"Westport Sewage Treatment Plant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(S24:S45, \"x\")","v":0},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,null,null,null,null,null,null,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,null,null,null,null,null,"General Service 1,500 to 4,999 kW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service Equal To Or Greater Than 1,500 kW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service Equal To Or Greater Than 1,500 kW - Interval Metered"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service Intermediate 1,000 To 4,999 kW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service 2,500 to 4,999 kW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service 3,000 to 4,999 kW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service 3,000 to 4,999 kW - Interval Metered"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service 3,000 to 4,999 kW - Intermediate Use"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service 3,000 to 4,999 kW - Time of Use"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Intermediate With Self Generation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service - Commercial"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service - Institutional"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,null,null,null,null,null,"Standby Distribution Service"]

{"sheet":"4. RRR Data","index":3,"n_rows":48,"n_cols":13,"rows_kept":48,"cut":false,"hidden":false,"merged":[[20,9,20,10],[23,9,23,10],[12,1,12,11],[38,9,38,10],[39,9,39,10],[32,9,32,10],[33,9,33,10],[34,9,34,10],[35,9,35,10],[36,9,36,10],[37,9,37,10],[32,7,32,8],[33,7,33,8],[34,7,34,8],[35,7,35,8],[36,7,36,8],[40,9,40,10],[41,9,41,10],[46,9,46,10],[47,9,47,10],[42,9,42,10],[43,9,43,10],[44,9,44,10],[45,9,45,10],[44,7,44,8],[45,7,45,8],[46,7,46,8],[47,7,47,8],[26,9,26,10],[27,9,27,10],[28,9,28,10],[29,9,29,10],[30,9,30,10],[31,9,31,10],[38,7,38,8],[39,7,39,8],[40,7,40,8],[41,7,41,8],[42,7,42,8],[43,7,43,8],[37,7,37,8],[26,7,26,8],[27,7,27,8],[28,7,28,8],[29,7,29,8],[30,7,30,8],[31,7,31,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"In the green shaded cells, enter the most recent reported RRR billing determinants.  Please ensure that billing determinants are non-loss adjusted."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Rate Class",null,"Unit",null,"Non-Loss Adjusted Metered kWh","Non-Loss Adjusted Metered kW","Applicable Loss Factor",null,"Load Factor",null,"Loss Adjusted Billed kWh","Billed kW"]
[]
[]
[null,{"$f":"IF('3. Rate Classes'!Q24=1,'3. Rate Classes'!C24, 0)","v":"Residential"},null,{"$f":"IF(OR(VLOOKUP($B27, '3. Rate Classes'!$C$24:$H$45,6,0)=0, ISERROR(VLOOKUP($B27, '3. Rate Classes'!$C$24:$H$45,6,0))), \"\", VLOOKUP($B27, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kWh"},null,2302188900,null,1.0358000000000001,null,{"$f":"IF(ISERROR(F27/(G27*30.4*24)), \"\", IF(D27=\"kW\", F27/(G27*30.4*24), \"\"))","v":""},null,{"$f":"IF(OR(H27=0, OR(ISBLANK(H27), TRIM(H27)=\"\")), F27, F27*H27)","v":2384607262.6200004},{"$f":"IF(OR(H27=0, OR(ISBLANK(H27), TRIM(H27)=\"\")), G27, G27)","v":0}]
[null,{"$f":"IF('3. Rate Classes'!Q25=1,'3. Rate Classes'!C25, 0)","v":"General Service Less Than 50 kW"},null,{"$f":"IF(OR(VLOOKUP($B28, '3. Rate Classes'!$C$24:$H$45,6,0)=0, ISERROR(VLOOKUP($B28, '3. Rate Classes'!$C$24:$H$45,6,0))), \"\", VLOOKUP($B28, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kWh"},null,702625952,null,1.0358000000000001,null,"",null,{"$f":"IF(OR(H28=0, OR(ISBLANK(H28), TRIM(H28)=\"\")), F28, F28*H28)","v":727779961.08160007},{"$f":"IF(OR(H28=0, OR(ISBLANK(H28), TRIM(H28)=\"\")), G28, G28)","v":0}]
[null,{"$f":"IF('3. Rate Classes'!Q26=1,'3. Rate Classes'!C26, 0)","v":"General Service 50 to 1,499 kW"},null,{"$f":"IF(OR(VLOOKUP($B29, '3. Rate Classes'!$C$24:$H$45,6,0)=0, ISERROR(VLOOKUP($B29, '3. Rate Classes'!$C$24:$H$45,6,0))), \"\", VLOOKUP($B29, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,2982426722,7288884,null,null,0.56082054863184272,null,2982426722,7288884]
[null,{"$f":"IF('3. Rate Classes'!Q27=1,'3. Rate Classes'!C27, 0)","v":"General Service 1,500 to 4,999 kW"},null,{"$f":"IF(OR(VLOOKUP($B30, '3. Rate Classes'!$C$24:$H$45,6,0)=0, ISERROR(VLOOKUP($B30, '3. Rate Classes'!$C$24:$H$45,6,0))), \"\", VLOOKUP($B30, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,870903316,1864369,null,null,0.6402553937090969,null,870903316,1864369]
[null,{"$f":"IF('3. Rate Classes'!Q28=1,'3. Rate Classes'!C28, 0)","v":"Large Use"},null,{"$f":"IF(OR(VLOOKUP($B31, '3. Rate Classes'!$C$24:$H$45,6,0)=0, ISERROR(VLOOKUP($B31, '3. Rate Classes'!$C$24:$H$45,6,0))), \"\", VLOOKUP($B31, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,646432433,1178836,null,null,0.75159680006862861,null,646432433,1178836]
[null,{"$f":"IF('3. Rate Classes'!Q29=1,'3. Rate Classes'!C29, 0)","v":"Unmetered Scattered Load"},null,{"$f":"IF(OR(VLOOKUP($B32, '3. Rate Classes'!$C$24:$H$45,6,0)=0, ISERROR(VLOOKUP($B32, '3. Rate Classes'!$C$24:$H$45,6,0))), \"\", VLOOKUP($B32, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kWh"},null,17594132,null,1.0358000000000001,null,"",null,18224001.9256,0]
[null,{"$f":"IF('3. Rate Classes'!Q30=1,'3. Rate Classes'!C30, 0)","v":"Standby Power General Service 50 to 1,499 kW"},null,{"$f":"IF(OR(VLOOKUP($B33, '3. Rate Classes'!$C$24:$H$45,6,0)=0, ISERROR(VLOOKUP($B33, '3. Rate Classes'!$C$24:$H$45,6,0))), \"\", VLOOKUP($B33, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,null,null,null,null,{"$f":"IF(ISERROR(F33/(G33*30.4*24)), \"\", IF(D33=\"kW\", F33/(G33*30.4*24), \"\"))","v":""},null,0,0]
[null,{"$f":"IF('3. Rate Classes'!Q31=1,'3. Rate Classes'!C31, 0)","v":"Standby Power General Service 1,500 to 4,999 kW"},null,{"$f":"IF(OR(VLOOKUP($B34, '3. Rate Classes'!$C$24:$H$45,6,0)=0, ISERROR(VLOOKUP($B34, '3. Rate Classes'!$C$24:$H$45,6,0))), \"\", VLOOKUP($B34, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,null,null,null,null,"",null,0,0]
[null,{"$f":"IF('3. Rate Classes'!Q32=1,'3. Rate Classes'!C32, 0)","v":"Standby Power General Service Large Use"},null,{"$f":"IF(OR(VLOOKUP($B35, '3. Rate Classes'!$C$24:$H$45,6,0)=0, ISERROR(VLOOKUP($B35, '3. Rate Classes'!$C$24:$H$45,6,0))), \"\", VLOOKUP($B35, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,null,null,null,null,"",null,0,0]
[null,{"$f":"IF('3. Rate Classes'!Q33=1,'3. Rate Classes'!C33, 0)","v":"Sentinel Lighting"},null,{"$f":"IF(OR(VLOOKUP($B36, '3. Rate Classes'!$C$24:$H$45,6,0)=0, ISERROR(VLOOKUP($B36, '3. Rate Classes'!$C$24:$H$45,6,0))), \"\", VLOOKUP($B36, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,59894,167,null,null,0.49156620968589132,null,59894,167]
[null,{"$f":"IF('3. Rate Classes'!Q34=1,'3. Rate Classes'!C34, 0)","v":"Street Lighting"},null,{"$f":"IF(OR(VLOOKUP($B37, '3. Rate Classes'!$C$24:$H$45,6,0)=0, ISERROR(VLOOKUP($B37, '3. Rate Classes'!$C$24:$H$45,6,0))), \"\", VLOOKUP($B37, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,44699159,123332,null,null,0.49675100283801082,null,44699159,123332]
[null,{"$f":"IF('3. Rate Classes'!Q35=1,'3. Rate Classes'!C35, 0)","v":0},null,{"$f":"IF(OR(VLOOKUP($B38, '3. Rate Classes'!$C$24:$H$45,6,0)=0, ISERROR(VLOOKUP($B38, '3. Rate Classes'!$C$24:$H$45,6,0))), \"\", VLOOKUP($B38, '3. Rate Classes'!$C$24:$H$45,6,0))","v":{"$error":"#N/A"}},null,null,null,null,null,"",null,0,0]
[null,{"$f":"IF('3. Rate Classes'!Q36=1,'3. Rate Classes'!C36, 0)","v":0},null,{"$f":"IF(OR(VLOOKUP($B39, '3. Rate Classes'!$C$24:$H$45,6,0)=0, ISERROR(VLOOKUP($B39, '3. Rate Classes'!$C$24:$H$45,6,0))), \"\", VLOOKUP($B39, '3. Rate Classes'!$C$24:$H$45,6,0))","v":{"$error":"#N/A"}},null,null,null,null,null,"",null,0,0]
[null,{"$f":"IF('3. Rate Classes'!Q37=1,'3. Rate Classes'!C37, 0)","v":0},null,{"$f":"IF(OR(VLOOKUP($B40, '3. Rate Classes'!$C$24:$H$45,6,0)=0, ISERROR(VLOOKUP($B40, '3. Rate Classes'!$C$24:$H$45,6,0))), \"\", VLOOKUP($B40, '3. Rate Classes'!$C$24:$H$45,6,0))","v":{"$error":"#N/A"}},null,null,null,null,null,"",null,0,0]
[null,{"$f":"IF('3. Rate Classes'!Q38=1,'3. Rate Classes'!C38, 0)","v":0},null,{"$f":"IF(OR(VLOOKUP($B41, '3. Rate Classes'!$C$24:$H$45,6,0)=0, ISERROR(VLOOKUP($B41, '3. Rate Classes'!$C$24:$H$45,6,0))), \"\", VLOOKUP($B41, '3. Rate Classes'!$C$24:$H$45,6,0))","v":{"$error":"#N/A"}},null,null,null,null,null,"",null,0,0]
[null,{"$f":"IF('3. Rate Classes'!Q39=1,'3. Rate Classes'!C39, 0)","v":0},null,{"$f":"IF(OR(VLOOKUP($B42, '3. Rate Classes'!$C$24:$H$45,6,0)=0, ISERROR(VLOOKUP($B42, '3. Rate Classes'!$C$24:$H$45,6,0))), \"\", VLOOKUP($B42, '3. Rate Classes'!$C$24:$H$45,6,0))","v":{"$error":"#N/A"}},null,null,null,null,null,"",null,0,0]
[null,{"$f":"IF('3. Rate Classes'!Q40=1,'3. Rate Classes'!C40, 0)","v":0},null,{"$f":"IF(OR(VLOOKUP($B43, '3. Rate Classes'!$C$24:$H$45,6,0)=0, ISERROR(VLOOKUP($B43, '3. Rate Classes'!$C$24:$H$45,6,0))), \"\", VLOOKUP($B43, '3. Rate Classes'!$C$24:$H$45,6,0))","v":{"$error":"#N/A"}},null,null,null,null,null,"",null,0,0]
[null,{"$f":"IF('3. Rate Classes'!Q41=1,'3. Rate Classes'!C41, 0)","v":0},null,{"$f":"IF(OR(VLOOKUP($B44, '3. Rate Classes'!$C$24:$H$45,6,0)=0, ISERROR(VLOOKUP($B44, '3. Rate Classes'!$C$24:$H$45,6,0))), \"\", VLOOKUP($B44, '3. Rate Classes'!$C$24:$H$45,6,0))","v":{"$error":"#N/A"}},null,null,null,null,null,"",null,0,0]
[null,{"$f":"IF('3. Rate Classes'!Q42=1,'3. Rate Classes'!C42, 0)","v":0},null,{"$f":"IF(OR(VLOOKUP($B45, '3. Rate Classes'!$C$24:$H$45,6,0)=0, ISERROR(VLOOKUP($B45, '3. Rate Classes'!$C$24:$H$45,6,0))), \"\", VLOOKUP($B45, '3. Rate Classes'!$C$24:$H$45,6,0))","v":{"$error":"#N/A"}},null,null,null,null,null,"",null,0,0]
[null,{"$f":"IF('3. Rate Classes'!Q43=1,'3. Rate Classes'!C43, 0)","v":0},null,{"$f":"IF(OR(VLOOKUP($B46, '3. Rate Classes'!$C$24:$H$45,6,0)=0, ISERROR(VLOOKUP($B46, '3. Rate Classes'!$C$24:$H$45,6,0))), \"\", VLOOKUP($B46, '3. Rate Classes'!$C$24:$H$45,6,0))","v":{"$error":"#N/A"}},null,null,null,null,null,"",null,0,0]
[null,{"$f":"IF('3. Rate Classes'!Q44=1,'3. Rate Classes'!C44, 0)","v":0},null,{"$f":"IF(OR(VLOOKUP($B47, '3. Rate Classes'!$C$24:$H$45,6,0)=0, ISERROR(VLOOKUP($B47, '3. Rate Classes'!$C$24:$H$45,6,0))), \"\", VLOOKUP($B47, '3. Rate Classes'!$C$24:$H$45,6,0))","v":{"$error":"#N/A"}},null,null,null,null,null,"",null,0,0]
[null,{"$f":"IF('3. Rate Classes'!Q45=1,'3. Rate Classes'!C45, 0)","v":0},null,{"$f":"IF(OR(VLOOKUP($B48, '3. Rate Classes'!$C$24:$H$45,6,0)=0, ISERROR(VLOOKUP($B48, '3. Rate Classes'!$C$24:$H$45,6,0))), \"\", VLOOKUP($B48, '3. Rate Classes'!$C$24:$H$45,6,0))","v":{"$error":"#N/A"}},null,null,null,null,null,"",null,0,0]

{"sheet":"5. UTRs and Sub-Transmission","index":4,"n_rows":95,"n_cols":9,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Uniform Transmission Rates","Unit",null,"Effective January 1, 2012",null,"Effective January 1, 2013",null,"Effective January 1, 2014"]
[]
[null,"Rate Description",null,null,"Rate",null,"Rate",null,"Rate"]
[]
[null,"Network Service Rate","kW",null,3.57,null,3.63,null,3.63]
[]
[null,"Line Connection Service Rate","kW",null,0.8,null,0.75,null,0.75]
[]
[null,"Transformation Connection Service Rate","kW",null,1.86,null,1.85,null,1.85]
[]
[]
[null,"Hydro One Sub-Transmission Rates","Unit",null,"Effective January 1, 2012",null,"Effective January 1, 2013",null,"Effective January 1, 2014"]
[]
[]
[]
[null,"Rate Description",null,null,"Rate",null,"Rate",null,"Rate"]
[]
[null,"Network Service Rate","kW",null,2.65,null,3.18,null,3.18]
[]
[null,"Line Connection Service Rate","kW",null,0.64,null,0.7,null,0.7]
[]
[null,"Transformation Connection Service Rate","kW",null,1.5,null,1.63,null,1.63]
[]
[null,"Both Line and Transformation Connection Service Rate","kW",null,{"$f":"E39+E37","v":2.14},null,{"$f":"G39+G37","v":2.33},null,{"$f":"I39+I37","v":2.33}]
[]
[]
[null,"If needed , add extra host here (I)","Unit",null,"Effective January 1, 2012",null,"Effective January 1, 2013",null,"Effective January 1, 2014"]
[]
[]
[]
[null,"Rate Description",null,null,"Rate",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":"E54+E52","v":0},null,{"$f":"G54+G52","v":0},null,{"$f":"I54+I52","v":0}]
[]
[]
[null,"If needed , add extra host here (II)","Unit",null,"Effective January 1, 2012",null,"Effective January 1, 2013",null,"Effective January 1, 2014"]
[]
[]
[]
[null,"Rate Description",null,null,"Rate",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":"E69+E67","v":0},null,{"$f":"G69+G67","v":0},null,{"$f":"I69+I67","v":0}]
[]
[]
[]
[null,"Hydro One Sub-Transmission Rate Rider 9A","Unit",null,"Effective January 1, 2012",null,"Effective January 1, 2013",null,"Effective January 1, 2014"]
[]
[null,"Rate Description",null,null,"Rate",null,"Rate",null,"Rate"]
[]
[null,"RSVA Transmission network – 4714 – which affects 1584","kW",null,0,null,0.14649999999999999,null,0.14649999999999999]
[]
[null,"RSVA Transmission connection – 4716 – which affects 1586","kW",null,0,null,6.6699999999999995E-2,null,6.6699999999999995E-2]
[]
[null,"RSVA LV – 4750 – which affects 1550","kW",null,0,null,4.7500000000000001E-2,null,4.7500000000000001E-2]
[]
[null,"RARA 1 – 2252 – which affects 1590 ","kW",null,0,null,4.19E-2,null,4.19E-2]
[]
[null,"RARA 1 – 2252 – which affects 1590 (2008)","kW",null,0,null,-2.7E-2,null,-2.7E-2]
[]
[null,"RARA 1 – 2252 – which affects 1590 (2009)","kW",null,0,null,-5.9999999999999995E-4,null,-5.9999999999999995E-4]
[]
[null,"Hydro One Sub-Transmission Rate Rider 9A","kW",null,{"$f":"SUM(E79:E89)","v":0},null,{"$f":"SUM(G79:G89)","v":0.27499999999999997},null,{"$f":"SUM(I79:I89)","v":0.27499999999999997}]
[]
[]
[null,null,null,null,"Historical 2012",null,"Current 2013",null,"Forecast 2014"]
[null,"Transformer Allowance Credit (if applicable, enter as a negative value)","$",null,-2804796,null,-2852866,null,-2921352]

{"sheet":"6. Historical Wholesale","index":5,"n_rows":117,"n_cols":16,"rows_kept":117,"cut":false,"hidden":false,"merged":[[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],[96,7,96,9],[96,11,96,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,1292701,{"$f":"IF(D24<>0,F24/D24,0)","v":3.2200010830037264},4162498.62,null,1179419,{"$f":"IF(H24<>0,J24/H24,0)","v":0.78999982194622953},931740.8,null,1007721,{"$f":"IF(L24<>0,N24/L24,0)","v":1.7699994343672505},1783665.6,null,{"$f":"J24+N24","v":2715406.4000000004}]
[null,"February",null,1169778,{"$f":"IF(D25<>0,F25/D25,0)","v":3.2200003590424848},3766685.58,null,1086579,{"$f":"IF(H25<>0,J25/H25,0)","v":0.7900001748607326},858397.6,null,939203,{"$f":"IF(L25<>0,N25/L25,0)","v":1.7700006068975502},1662389.88,null,2520787.48]
[null,"March",null,1181934,3.2199996446502088,3805827.06,null,1066863,0.78999984065432949,842821.6,null,927522,1.7700001940654777,1641714.12,null,2484535.7200000002]
[null,"April",null,980030,3.2200013571013133,3155697.93,null,908644,0.79000004402164103,717828.8,null,783636,1.7699996937353566,1387035.48,null,2104864.2800000003]
[null,"May",null,1108865,3.2200008206589619,3570546.21,null,1091264,0.7899998533810334,862098.4,null,927597,1.7699994501922709,1641846.18,null,2503944.58]
[null,"June",null,1493847,3.2199990159634821,4810185.87,null,1337783,0.79000017192623917,1056848.8,null,1135126,1.7700007400059554,2009173.86,null,3066022.66]
[null,"July",null,1421925,3.2200010338097997,4578599.97,null,1298586,0.79000020021777528,1025883.2,null,1105653,1.7700005697990238,1957006.44,null,2982889.6399999997]
[null,"August",null,1342532,3.2199994264568739,4322952.2699999996,null,1224639,0.78999999183432834,967464.8,null,1049295,1.7700006004031279,1857252.78,null,2824717.58]
[null,"September",null,1273093,3.2200001099683999,4099359.6,null,1124348,0.79000024903321742,888235.2,null,965589,1.7700000932073585,1709092.62,null,2597327.8200000003]
[null,"October",null,1013243,3.2199984110425635,3262640.85,null,931660,0.78999978532941195,736011.2,null,791229,1.7700006445668701,1400475.84,null,2136487.04]
[null,"November",null,1162647,3.2199999999999998,3743723.34,null,1036203,0.78999964292710989,818600,null,885810,1.7699995258576895,1567883.28,null,2386483.2800000003]
[null,"December",null,1215067,3.2200006337099105,3912516.51,null,1075242,0.78999964659118604,849440.8,null,922973,1.7699999674963405,1633662.18,null,2483102.98]
[]
[null,"Total",null,{"$f":"SUM(D24:D35)","v":14655662},{"$f":"IF(D37<>0,F37/D37,0)","v":3.2200001480656413},{"$f":"SUM(F24:F35)","v":47191233.809999995},null,{"$f":"SUM(H24:H35)","v":13361230},{"$f":"IF(H37<>0,J37/H37,0)","v":0.78999996257829563},{"$f":"SUM(J24:J35)","v":10555371.200000001},null,{"$f":"SUM(L24:L35)","v":11441354},{"$f":"IF(L37<>0,N37/L37,0)","v":1.7700001468357678},{"$f":"SUM(N24:N35)","v":20251198.259999998},null,{"$f":"SUM(P24:P35)","v":30806569.460000005}]
[]
[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,86303,{"$f":"IF(D43<>0,F43/D43,0)","v":2.6500000000000004},228702.95,null,58082,{"$f":"IF(H43<>0,J43/H43,0)","v":0.63999672876278368},37172.29,null,91309,{"$f":"IF(L43<>0,N43/L43,0)","v":1.5000006571093758},136963.56,null,{"$f":"J43+N43","v":174135.85}]
[null,"February",null,84994,{"$f":"IF(D44<>0,F44/D44,0)","v":2.65},225234.1,null,55570,{"$f":"IF(H44<>0,J44/H44,0)","v":0.64000431887709197},35565.040000000001,null,88718,{"$f":"IF(L44<>0,N44/L44,0)","v":1.5000049595347056},133077.44,null,168642.48]
[null,"March",null,69960,2.65,185394,null,52345,0.64000019104021388,33500.81,null,71992,1.4999947216357372,107987.62,null,141488.43]
[null,"April",null,79200,2.65,209880,null,52110,0.63999654576856657,33350.22,null,83226,1.5000052868094105,124839.44,null,158189.66]
[null,"May",null,76742,2.65,203366.3,null,56587,0.63999540530510535,36215.42,null,77633,1.5000054100704596,116449.92,null,152665.34]
[null,"June",null,99248,2.65,263007.2,null,64135,0.63999953223668826,41046.370000000003,null,101255,1.5000057281121919,151883.07999999999,null,192929.44999999998]
[null,"July",null,96154,2.65,254808.1,null,65835,0.64000273410799724,42134.58,null,97537,1.5000006151511733,146305.56,null,188440.14]
[null,"August",null,84296,2.65,223384.4,null,64770,0.64000339663424421,41453.019999999997,null,94979,1.4999932616683687,142467.85999999999,null,183920.87999999998]
[null,"September",null,81210,2.65,215206.5,null,58286,0.63999708334763072,37302.870000000003,null,83599,1.5000059809327864,125399,null,162701.87]
[null,"October",null,74365,2.65,197067.25,null,58600,0.6400034129692832,37504.199999999997,null,75969,1.5000026326527927,113953.7,null,151457.9]
[null,"November",null,92008,2.65,243821.2,null,61797,0.64000258912244923,39550.239999999998,null,93898,1.5000046859358027,140847.44,null,180397.68]
[null,"December",null,94602,2.6500023255322298,250695.52,null,66229,0.63999954702622719,42386.53,null,95160,1.4999932744850777,142739.35999999999,null,185125.88999999998]
[]
[null,"Total",null,{"$f":"SUM(D43:D54)","v":1019082},{"$f":"IF(D56<>0,F56/D56,0)","v":2.6500002158805671},{"$f":"SUM(F43:F54)","v":2700567.52},null,{"$f":"SUM(H43:H54)","v":714346},{"$f":"IF(H56<>0,J56/H56,0)","v":0.64000020998227747},{"$f":"SUM(J43:J54)","v":457181.58999999997},null,{"$f":"SUM(L43:L54)","v":1055275},{"$f":"IF(L56<>0,N56/L56,0)","v":1.500001402478027},{"$f":"SUM(N43:N54)","v":1582913.98},null,{"$f":"SUM(P43:P54)","v":2040095.5699999998}]
[]
[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":1379004},{"$f":"IF(D100<>0,F100/D100,0)","v":3.1843283775826614},{"$f":"F24+F43+F62+F81","v":4391201.57},null,{"$f":"H24+H43+H62+H81","v":1237501},{"$f":"IF(H100<>0,J100/H100,0)","v":0.78295944003277584},{"$f":"J24+J43+J62+J81","v":968913.09000000008},null,{"$f":"L24+L43+L62+L81","v":1099030},{"$f":"IF(L100<>0,N100/L100,0)","v":1.7475675459268629},{"$f":"N24+N43+N62+N81","v":1920629.1600000001},null,{"$f":"J100+N100","v":2889542.25}]
[null,"February",null,{"$f":"D25+D44+D63+D82","v":1254772},3.1813904677503166,{"$f":"F25+F44+F63+F82","v":3991919.68},null,{"$f":"H25+H44+H63+H82","v":1142149},0.7827022919076233,{"$f":"J25+J44+J63+J82","v":893962.64},null,{"$f":"L25+L44+L63+L82","v":1027921},1.7466977715213521,{"$f":"N25+N44+N63+N82","v":1795467.3199999998},null,2689429.96]
[null,"March",null,1251894,3.1881461689248449,3991221.06,null,1119208,0.78298440504356648,876322.40999999992,null,999514,1.7505525085191405,1749701.7400000002,null,2626024.1500000004]
[null,"April",null,1059230,3.1773816168348707,3365577.93,null,960754,0.78186405677207693,751179.02,null,866862,1.744077973195272,1511874.92,null,2263053.94]
[null,"May",null,1185607,3.1831057930663365,3773912.51,null,1147851,0.78260490255268333,898313.82000000007,null,1005230,1.7491480556688517,1758296.0999999999,null,2656609.92]
[null,"June",null,1593095,3.1844887279164142,5073193.07,null,1401918,0.78313793674095078,1097895.1700000002,null,1236381,1.7478891539096766,2161056.94,null,3258952.1100000003]
[null,"July",null,1518079,3.1838975903098583,4833408.0699999994,null,1364421,0.78276263704531079,1068017.78,null,1203190,1.7481129331194574,2103312,null,3171329.7800000003]
[null,"August",null,1426828,3.1863242591258372,4546336.67,null,1289409,0.78246531550501053,1008917.8200000001,null,1144274,1.7475889865539198,1999720.6400000001,null,3008638.46]
[null,"September",null,1354303,3.1858203814065238,4314566.0999999996,null,1182634,0.7826073578131526,925538.07,null,1049188,1.7484870395010237,1834491.62,null,2760029.69]
[null,"October",null,1087608,3.1810248729321593,3459708.1,null,990260,0.7811235433118574,773515.39999999991,null,867198,1.7463480543082435,1514429.54,null,2287944.94]
[null,"November",null,1254655,3.1782000151436054,3987544.54,null,1098000,0.78155759562841531,858150.24,null,979708,1.7441224528124706,1708730.72,null,2566880.96]
[null,"December",null,1309669,3.17882765034524,4163212.03,null,1141471,0.7812965287773409,891827.33000000007,null,1018133,1.7447637391185631,1776401.54,null,2668228.87]
[]
[null,"Total",null,{"$f":"SUM(D100:D111)","v":15674744},{"$f":"IF(D113<>0,F113/D113,0)","v":3.1829420199781255},{"$f":"SUM(F100:F111)","v":49891801.330000006},null,{"$f":"SUM(H100:H111)","v":14075576},{"$f":"IF(H113<>0,J113/H113,0)","v":0.78238736304645728},{"$f":"SUM(J100:J111)","v":11012552.790000001},null,{"$f":"SUM(L100:L111)","v":12496629},{"$f":"IF(L113<>0,N113/L113,0)","v":1.7472001641402652},{"$f":"SUM(N100:N111)","v":21834112.239999998},null,{"$f":"SUM(P100:P111)","v":32846665.030000009}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Transformer Allowance Credit (if applicable)",null,{"$f":"'5. UTRs and Sub-Transmission'!E95","v":-2804796}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total including deduction for Transformer Allowance Credit",null,{"$f":"P113+P115","v":30041869.030000009}]

{"sheet":"7. Current Wholesale","index":6,"n_rows":117,"n_cols":16,"rows_kept":117,"cut":false,"hidden":false,"merged":[[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],[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]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The purpose of this sheet is to calculate the expected billing when current 2013 Uniform Transmission Rates are applied against historical 2012 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":1292701},{"$f":"'5. UTRs and Sub-Transmission'!G22","v":3.63},{"$f":"D24*E24","v":4692504.63},null,{"$f":"'6. Historical Wholesale'!H24","v":1179419},{"$f":"'5. UTRs and Sub-Transmission'!G24","v":0.75},{"$f":"H24*I24","v":884564.25},null,{"$f":"'6. Historical Wholesale'!L24","v":1007721},{"$f":"'5. UTRs and Sub-Transmission'!G26","v":1.85},{"$f":"L24*M24","v":1864283.85},null,{"$f":"J24+N24","v":2748848.1}]
[null,"February",null,{"$f":"'6. Historical Wholesale'!D25","v":1169778},{"$f":"E24","v":3.63},{"$f":"D25*E25","v":4246294.1399999997},null,{"$f":"'6. Historical Wholesale'!H25","v":1086579},{"$f":"I24","v":0.75},{"$f":"H25*I25","v":814934.25},null,{"$f":"'6. Historical Wholesale'!L25","v":939203},{"$f":"M24","v":1.85},{"$f":"L25*M25","v":1737525.55},null,2552459.7999999998]
[null,"March",null,{"$f":"'6. Historical Wholesale'!D26","v":1181934},{"$f":"E25","v":3.63},4290420.42,null,{"$f":"'6. Historical Wholesale'!H26","v":1066863},{"$f":"I25","v":0.75},800147.25,null,{"$f":"'6. Historical Wholesale'!L26","v":927522},{"$f":"M25","v":1.85},1715915.7000000002,null,2516062.9500000002]
[null,"April",null,{"$f":"'6. Historical Wholesale'!D27","v":980030},3.63,3557508.9,null,{"$f":"'6. Historical Wholesale'!H27","v":908644},0.75,681483,null,{"$f":"'6. Historical Wholesale'!L27","v":783636},1.85,1449726.6,null,2131209.6]
[null,"May",null,{"$f":"'6. Historical Wholesale'!D28","v":1108865},3.63,4025179.9499999997,null,{"$f":"'6. Historical Wholesale'!H28","v":1091264},0.75,818448,null,{"$f":"'6. Historical Wholesale'!L28","v":927597},1.85,1716054.4500000002,null,2534502.4500000002]
[null,"June",null,{"$f":"'6. Historical Wholesale'!D29","v":1493847},3.63,5422664.6099999994,null,{"$f":"'6. Historical Wholesale'!H29","v":1337783},0.75,1003337.25,null,{"$f":"'6. Historical Wholesale'!L29","v":1135126},1.85,2099983.1,null,3103320.35]
[null,"July",null,{"$f":"'6. Historical Wholesale'!D30","v":1421925},3.63,5161587.75,null,{"$f":"'6. Historical Wholesale'!H30","v":1298586},0.75,973939.5,null,{"$f":"'6. Historical Wholesale'!L30","v":1105653},1.85,2045458.05,null,3019397.55]
[null,"August",null,{"$f":"'6. Historical Wholesale'!D31","v":1342532},3.63,4873391.16,null,{"$f":"'6. Historical Wholesale'!H31","v":1224639},0.75,918479.25,null,{"$f":"'6. Historical Wholesale'!L31","v":1049295},1.85,1941195.75,null,2859675]
[null,"September",null,{"$f":"'6. Historical Wholesale'!D32","v":1273093},3.63,4621327.59,null,{"$f":"'6. Historical Wholesale'!H32","v":1124348},0.75,843261,null,{"$f":"'6. Historical Wholesale'!L32","v":965589},1.85,1786339.6500000001,null,2629600.6500000004]
[null,"October",null,{"$f":"'6. Historical Wholesale'!D33","v":1013243},3.63,3678072.09,null,{"$f":"'6. Historical Wholesale'!H33","v":931660},0.75,698745,null,{"$f":"'6. Historical Wholesale'!L33","v":791229},1.85,1463773.6500000001,null,2162518.6500000004]
[null,"November",null,{"$f":"'6. Historical Wholesale'!D34","v":1162647},3.63,4220408.6100000003,null,{"$f":"'6. Historical Wholesale'!H34","v":1036203},0.75,777152.25,null,{"$f":"'6. Historical Wholesale'!L34","v":885810},1.85,1638748.5,null,2415900.75]
[null,"December",null,{"$f":"'6. Historical Wholesale'!D35","v":1215067},3.63,4410693.21,null,{"$f":"'6. Historical Wholesale'!H35","v":1075242},0.75,806431.5,null,{"$f":"'6. Historical Wholesale'!L35","v":922973},1.85,1707500.05,null,2513931.5499999998]
[]
[null,"Total",null,{"$f":"SUM(D24:D35)","v":14655662},{"$f":"IF(D37<>0,F37/D37,0)","v":3.6300000000000008},{"$f":"SUM(F24:F35)","v":53200053.06000001},null,{"$f":"SUM(H24:H35)","v":13361230},{"$f":"IF(H37<>0,J37/H37,0)","v":0.75},{"$f":"SUM(J24:J35)","v":10020922.5},null,{"$f":"SUM(L24:L35)","v":11441354},{"$f":"IF(L37<>0,N37/L37,0)","v":1.85},{"$f":"SUM(N24:N35)","v":21166504.900000002},null,{"$f":"SUM(P24:P35)","v":31187427.400000002}]
[]
[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":86303},{"$f":"'5. UTRs and Sub-Transmission'!G35+'5. UTRs and Sub-Transmission'!G79","v":3.3265000000000002},{"$f":"D43*E43","v":287086.92950000003},null,{"$f":"'6. Historical Wholesale'!H43","v":58082},{"$f":"'5. UTRs and Sub-Transmission'!G37+'5. UTRs and Sub-Transmission'!G81","v":0.76669999999999994},{"$f":"H43*I43","v":44531.469399999994},null,{"$f":"'6. Historical Wholesale'!L43","v":91309},{"$f":"'5. UTRs and Sub-Transmission'!G39","v":1.63},{"$f":"L43*M43","v":148833.66999999998},null,{"$f":"J43+N43","v":193365.13939999999}]
[null,"February",null,{"$f":"'6. Historical Wholesale'!D44","v":84994},{"$f":"E43","v":3.3265000000000002},{"$f":"D44*E44","v":282732.54100000003},null,{"$f":"'6. Historical Wholesale'!H44","v":55570},{"$f":"I43","v":0.76669999999999994},{"$f":"H44*I44","v":42605.518999999993},null,{"$f":"'6. Historical Wholesale'!L44","v":88718},{"$f":"M43","v":1.63},{"$f":"L44*M44","v":144610.34},null,187215.859]
[null,"March",null,{"$f":"'6. Historical Wholesale'!D45","v":69960},{"$f":"E44","v":3.3265000000000002},232721.94,null,{"$f":"'6. Historical Wholesale'!H45","v":52345},{"$f":"I44","v":0.76669999999999994},40132.911499999995,null,{"$f":"'6. Historical Wholesale'!L45","v":71992},{"$f":"M44","v":1.63},117346.95999999999,null,157479.87149999998]
[null,"April",null,{"$f":"'6. Historical Wholesale'!D46","v":79200},3.3265000000000002,263458.80000000005,null,{"$f":"'6. Historical Wholesale'!H46","v":52110},0.76669999999999994,39952.736999999994,null,{"$f":"'6. Historical Wholesale'!L46","v":83226},{"$f":"M45","v":1.63},135658.38,null,175611.117]
[null,"May",null,{"$f":"'6. Historical Wholesale'!D47","v":76742},3.3265000000000002,255282.26300000001,null,{"$f":"'6. Historical Wholesale'!H47","v":56587},0.76669999999999994,43385.252899999999,null,{"$f":"'6. Historical Wholesale'!L47","v":77633},1.63,126541.79,null,169927.0429]
[null,"June",null,{"$f":"'6. Historical Wholesale'!D48","v":99248},3.3265000000000002,330148.47200000001,null,{"$f":"'6. Historical Wholesale'!H48","v":64135},0.76669999999999994,49172.304499999998,null,{"$f":"'6. Historical Wholesale'!L48","v":101255},1.63,165045.65,null,214217.95449999999]
[null,"July",null,{"$f":"'6. Historical Wholesale'!D49","v":96154},3.3265000000000002,319856.28100000002,null,{"$f":"'6. Historical Wholesale'!H49","v":65835},0.76669999999999994,50475.694499999998,null,{"$f":"'6. Historical Wholesale'!L49","v":97537},1.63,158985.31,null,209461.00449999998]
[null,"August",null,{"$f":"'6. Historical Wholesale'!D50","v":84296},3.3265000000000002,280410.64400000003,null,{"$f":"'6. Historical Wholesale'!H50","v":64770},0.76669999999999994,49659.158999999992,null,{"$f":"'6. Historical Wholesale'!L50","v":94979},1.63,154815.76999999999,null,204474.92899999997]
[null,"September",null,{"$f":"'6. Historical Wholesale'!D51","v":81210},3.3265000000000002,270145.065,null,{"$f":"'6. Historical Wholesale'!H51","v":58286},0.76669999999999994,44687.876199999999,null,{"$f":"'6. Historical Wholesale'!L51","v":83599},1.63,136266.37,null,180954.24619999999]
[null,"October",null,{"$f":"'6. Historical Wholesale'!D52","v":74365},3.3265000000000002,247375.17250000002,null,{"$f":"'6. Historical Wholesale'!H52","v":58600},0.76669999999999994,44928.619999999995,null,{"$f":"'6. Historical Wholesale'!L52","v":75969},1.63,123829.46999999999,null,168758.08999999997]
[null,"November",null,{"$f":"'6. Historical Wholesale'!D53","v":92008},3.3265000000000002,306064.61200000002,null,{"$f":"'6. Historical Wholesale'!H53","v":61797},0.76669999999999994,47379.759899999997,null,{"$f":"'6. Historical Wholesale'!L53","v":93898},1.63,153053.74,null,200433.4999]
[null,"December",null,{"$f":"'6. Historical Wholesale'!D54","v":94602},3.3265000000000002,314693.55300000001,null,{"$f":"'6. Historical Wholesale'!H54","v":66229},0.76669999999999994,50777.774299999997,null,{"$f":"'6. Historical Wholesale'!L54","v":95160},1.63,155110.79999999999,null,205888.57429999998]
[]
[null,"Total",null,{"$f":"SUM(D43:D54)","v":1019082},{"$f":"IF(D56<>0,F56/D56,0)","v":3.3265000000000002},{"$f":"SUM(F43:F54)","v":3389976.273},null,{"$f":"SUM(H43:H54)","v":714346},{"$f":"IF(H56<>0,J56/H56,0)","v":0.76669999999999994},{"$f":"SUM(J43:J54)","v":547689.07819999999},null,{"$f":"SUM(L43:L54)","v":1055275},{"$f":"IF(L56<>0,N56/L56,0)","v":1.6300000000000001},{"$f":"SUM(N43:N54)","v":1720098.2500000002},null,{"$f":"SUM(P43:P54)","v":2267787.3281999994}]
[]
[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'!G50","v":0},{"$f":"D62*E62","v":0},null,{"$f":"'6. Historical Wholesale'!H62","v":0},{"$f":"'5. UTRs and Sub-Transmission'!G52","v":0},{"$f":"H62*I62","v":0},null,{"$f":"'6. Historical Wholesale'!L62","v":0},{"$f":"'5. UTRs and Sub-Transmission'!G54","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'!G65","v":0},{"$f":"D81*E81","v":0},null,{"$f":"'6. Historical Wholesale'!H81","v":0},{"$f":"'5. UTRs and Sub-Transmission'!G67","v":0},{"$f":"H81*I81","v":0},null,{"$f":"'6. Historical Wholesale'!L81","v":0},{"$f":"'5. UTRs and Sub-Transmission'!G69","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":1379004},{"$f":"IF(D100<>0,F100/D100,0)","v":3.6110058850445679},{"$f":"F24+F43+F62+F81","v":4979591.5594999995},null,{"$f":"H24+H43+H62+H81","v":1237501},{"$f":"IF(H100<>0,J100/H100,0)","v":0.75078381302318131},{"$f":"J24+J43+J62+J81","v":929095.71939999994},null,{"$f":"L24+L43+L62+L81","v":1099030},{"$f":"IF(L100<>0,N100/L100,0)","v":1.831722082199758},{"$f":"N24+N43+N62+N81","v":2013117.52},null,{"$f":"J100+N100","v":2942213.2393999998}]
[null,"February",null,{"$f":"D25+D44+D63+D82","v":1254772},3.6094419392527088,{"$f":"F25+F44+F63+F82","v":4529026.6809999999},null,{"$f":"H25+H44+H63+H82","v":1142149},0.75081252008275623,{"$f":"J25+J44+J63+J82","v":857539.76899999997},null,{"$f":"L25+L44+L63+L82","v":1027921},1.8310121984082435,{"$f":"N25+N44+N63+N82","v":1882135.8900000001},null,2739675.659]
[null,"March",null,1251894,3.6130394106849306,4523142.3600000003,null,1119208,0.7507810536557995,840280.16150000005,null,999514,1.8341540588726122,1833262.6600000001,null,2673542.8215000001]
[null,"April",null,1059230,3.607306911624482,3820967.7,null,960754,0.75090578545600639,721435.73699999996,null,866862,1.8288781605376634,1585384.98,null,2306820.7170000002]
[null,"May",null,1185607,3.6103550442937666,4280462.2129999995,null,1147851,0.75082328011213995,861833.25289999996,null,1005230,1.8330095997930824,1842596.2400000002,null,2704429.4929]
[null,"June",null,1593095,3.6110922964418313,5752813.0819999995,null,1401918,0.75076399225917645,1052509.5545000001,null,1236381,1.8319828192118772,2265028.75,null,3317538.3045000001]
[null,"July",null,1518079,3.6107765346862717,5481444.0310000004,null,1364421,0.75080579564518579,1024415.1945,null,1203190,1.8321656263765489,2204443.36,null,3228858.5544999996]
[null,"August",null,1426828,3.6120694323352223,5153801.8040000005,null,1289409,0.75083887967278029,968138.40899999999,null,1144274,1.8317391813499215,2096011.52,null,3064149.929]
[null,"September",null,1354303,3.6118007971628212,4891472.6550000003,null,1182634,0.75082305785221803,887948.87620000006,null,1049188,1.8324704628722404,1922606.02,null,2810554.8962000003]
[null,"October",null,1087608,3.6092482424733907,3925447.2624999997,null,990260,0.75098824551127985,743673.62,null,867198,1.8307273771387851,1587603.12,null,2331276.7400000002]
[null,"November",null,1254655,3.6077433413966391,4526473.2220000001,null,1098000,0.75093989972677588,824532.00989999995,null,979708,1.8289145745467017,1791802.24,null,2616334.2499000002]
[null,"December",null,1309669,3.6080771271214331,4725386.7630000003,null,1141471,0.75096894647345402,857209.27430000005,null,1018133,1.8294376569662314,1862610.85,null,2719820.1243000003]
[]
[null,"Total",null,{"$f":"SUM(D100:D111)","v":15674744},{"$f":"IF(D113<>0,F113/D113,0)","v":3.6102681698023269},{"$f":"SUM(F100:F111)","v":56590029.333000004},null,{"$f":"SUM(H100:H111)","v":14075576},{"$f":"IF(H113<>0,J113/H113,0)","v":0.7508475374791056},{"$f":"SUM(J100:J111)","v":10568611.578199999},null,{"$f":"SUM(L100:L111)","v":12496629},{"$f":"IF(L113<>0,N113/L113,0)","v":1.831422149925392},{"$f":"SUM(N100:N111)","v":22886603.150000002},null,{"$f":"SUM(P100:P111)","v":33455214.7282}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Transformer Allowance Credit (if applicable)",null,{"$f":"'5. UTRs and Sub-Transmission'!G95","v":-2852866}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total including deduction for Transformer Allowance Credit",null,{"$f":"P113+P115","v":30602348.7282}]

{"sheet":"8. Forecast Wholesale","index":7,"n_rows":117,"n_cols":16,"rows_kept":117,"cut":false,"hidden":false,"merged":[[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],[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]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The purpose of this sheet is to calculate the expected billing when forecasted 2014 Uniform Transmission Rates are applied against historical 2012 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":1292701},{"$f":"'5. UTRs and Sub-Transmission'!I22","v":3.63},{"$f":"D24*E24","v":4692504.63},null,{"$f":"'6. Historical Wholesale'!H24","v":1179419},{"$f":"'5. UTRs and Sub-Transmission'!I24","v":0.75},{"$f":"H24*I24","v":884564.25},null,{"$f":"'6. Historical Wholesale'!L24","v":1007721},{"$f":"'5. UTRs and Sub-Transmission'!I26","v":1.85},{"$f":"L24*M24","v":1864283.85},null,{"$f":"J24+N24","v":2748848.1}]
[null,"February",null,{"$f":"'6. Historical Wholesale'!D25","v":1169778},{"$f":"E24","v":3.63},4246294.1399999997,null,{"$f":"'6. Historical Wholesale'!H25","v":1086579},{"$f":"I24","v":0.75},814934.25,null,{"$f":"'6. Historical Wholesale'!L25","v":939203},{"$f":"M24","v":1.85},1737525.55,null,2552459.7999999998]
[null,"March",null,{"$f":"'6. Historical Wholesale'!D26","v":1181934},3.63,4290420.42,null,{"$f":"'6. Historical Wholesale'!H26","v":1066863},0.75,800147.25,null,{"$f":"'6. Historical Wholesale'!L26","v":927522},1.85,1715915.7000000002,null,2516062.9500000002]
[null,"April",null,{"$f":"'6. Historical Wholesale'!D27","v":980030},3.63,3557508.9,null,{"$f":"'6. Historical Wholesale'!H27","v":908644},0.75,681483,null,{"$f":"'6. Historical Wholesale'!L27","v":783636},1.85,1449726.6,null,2131209.6]
[null,"May",null,{"$f":"'6. Historical Wholesale'!D28","v":1108865},3.63,4025179.9499999997,null,{"$f":"'6. Historical Wholesale'!H28","v":1091264},0.75,818448,null,{"$f":"'6. Historical Wholesale'!L28","v":927597},1.85,1716054.4500000002,null,2534502.4500000002]
[null,"June",null,{"$f":"'6. Historical Wholesale'!D29","v":1493847},3.63,5422664.6099999994,null,{"$f":"'6. Historical Wholesale'!H29","v":1337783},0.75,1003337.25,null,{"$f":"'6. Historical Wholesale'!L29","v":1135126},1.85,2099983.1,null,3103320.35]
[null,"July",null,{"$f":"'6. Historical Wholesale'!D30","v":1421925},3.63,5161587.75,null,{"$f":"'6. Historical Wholesale'!H30","v":1298586},0.75,973939.5,null,{"$f":"'6. Historical Wholesale'!L30","v":1105653},1.85,2045458.05,null,3019397.55]
[null,"August",null,{"$f":"'6. Historical Wholesale'!D31","v":1342532},3.63,4873391.16,null,{"$f":"'6. Historical Wholesale'!H31","v":1224639},0.75,918479.25,null,{"$f":"'6. Historical Wholesale'!L31","v":1049295},1.85,1941195.75,null,2859675]
[null,"September",null,{"$f":"'6. Historical Wholesale'!D32","v":1273093},3.63,4621327.59,null,{"$f":"'6. Historical Wholesale'!H32","v":1124348},0.75,843261,null,{"$f":"'6. Historical Wholesale'!L32","v":965589},1.85,1786339.6500000001,null,2629600.6500000004]
[null,"October",null,{"$f":"'6. Historical Wholesale'!D33","v":1013243},3.63,3678072.09,null,{"$f":"'6. Historical Wholesale'!H33","v":931660},0.75,698745,null,{"$f":"'6. Historical Wholesale'!L33","v":791229},1.85,1463773.6500000001,null,2162518.6500000004]
[null,"November",null,{"$f":"'6. Historical Wholesale'!D34","v":1162647},3.63,4220408.6100000003,null,{"$f":"'6. Historical Wholesale'!H34","v":1036203},0.75,777152.25,null,{"$f":"'6. Historical Wholesale'!L34","v":885810},1.85,1638748.5,null,2415900.75]
[null,"December",null,{"$f":"'6. Historical Wholesale'!D35","v":1215067},3.63,4410693.21,null,{"$f":"'6. Historical Wholesale'!H35","v":1075242},0.75,806431.5,null,{"$f":"'6. Historical Wholesale'!L35","v":922973},1.85,1707500.05,null,2513931.5499999998]
[]
[null,"Total",null,{"$f":"SUM(D24:D35)","v":14655662},{"$f":"IF(D37<>0,F37/D37,0)","v":3.6300000000000008},{"$f":"SUM(F24:F35)","v":53200053.06000001},null,{"$f":"SUM(H24:H35)","v":13361230},{"$f":"IF(H37<>0,J37/H37,0)","v":0.75},{"$f":"SUM(J24:J35)","v":10020922.5},null,{"$f":"SUM(L24:L35)","v":11441354},{"$f":"IF(L37<>0,N37/L37,0)","v":1.85},{"$f":"SUM(N24:N35)","v":21166504.900000002},null,{"$f":"SUM(P24:P35)","v":31187427.400000002}]
[]
[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":86303},{"$f":"'5. UTRs and Sub-Transmission'!I35+'5. UTRs and Sub-Transmission'!I79","v":3.3265000000000002},{"$f":"D43*E43","v":287086.92950000003},null,{"$f":"'6. Historical Wholesale'!H43","v":58082},{"$f":"'5. UTRs and Sub-Transmission'!I37+'5. UTRs and Sub-Transmission'!I81","v":0.76669999999999994},{"$f":"H43*I43","v":44531.469399999994},null,{"$f":"'6. Historical Wholesale'!L43","v":91309},{"$f":"'5. UTRs and Sub-Transmission'!I39","v":1.63},{"$f":"L43*M43","v":148833.66999999998},null,{"$f":"J43+N43","v":193365.13939999999}]
[null,"February",null,{"$f":"'6. Historical Wholesale'!D44","v":84994},{"$f":"E43","v":3.3265000000000002},282732.54100000003,null,{"$f":"'6. Historical Wholesale'!H44","v":55570},{"$f":"I43","v":0.76669999999999994},42605.518999999993,null,{"$f":"'6. Historical Wholesale'!L44","v":88718},{"$f":"M43","v":1.63},144610.34,null,187215.859]
[null,"March",null,{"$f":"'6. Historical Wholesale'!D45","v":69960},3.3265000000000002,232721.94,null,{"$f":"'6. Historical Wholesale'!H45","v":52345},0.76669999999999994,40132.911499999995,null,{"$f":"'6. Historical Wholesale'!L45","v":71992},1.63,117346.95999999999,null,157479.87149999998]
[null,"April",null,{"$f":"'6. Historical Wholesale'!D46","v":79200},3.3265000000000002,263458.80000000005,null,{"$f":"'6. Historical Wholesale'!H46","v":52110},0.76669999999999994,39952.736999999994,null,{"$f":"'6. Historical Wholesale'!L46","v":83226},1.63,135658.38,null,175611.117]
[null,"May",null,{"$f":"'6. Historical Wholesale'!D47","v":76742},3.3265000000000002,255282.26300000001,null,{"$f":"'6. Historical Wholesale'!H47","v":56587},0.76669999999999994,43385.252899999999,null,{"$f":"'6. Historical Wholesale'!L47","v":77633},1.63,126541.79,null,169927.0429]
[null,"June",null,{"$f":"'6. Historical Wholesale'!D48","v":99248},3.3265000000000002,330148.47200000001,null,{"$f":"'6. Historical Wholesale'!H48","v":64135},0.76669999999999994,49172.304499999998,null,{"$f":"'6. Historical Wholesale'!L48","v":101255},1.63,165045.65,null,214217.95449999999]
[null,"July",null,{"$f":"'6. Historical Wholesale'!D49","v":96154},3.3265000000000002,319856.28100000002,null,{"$f":"'6. Historical Wholesale'!H49","v":65835},0.76669999999999994,50475.694499999998,null,{"$f":"'6. Historical Wholesale'!L49","v":97537},1.63,158985.31,null,209461.00449999998]
[null,"August",null,{"$f":"'6. Historical Wholesale'!D50","v":84296},3.3265000000000002,280410.64400000003,null,{"$f":"'6. Historical Wholesale'!H50","v":64770},0.76669999999999994,49659.158999999992,null,{"$f":"'6. Historical Wholesale'!L50","v":94979},1.63,154815.76999999999,null,204474.92899999997]
[null,"September",null,{"$f":"'6. Historical Wholesale'!D51","v":81210},3.3265000000000002,270145.065,null,{"$f":"'6. Historical Wholesale'!H51","v":58286},0.76669999999999994,44687.876199999999,null,{"$f":"'6. Historical Wholesale'!L51","v":83599},1.63,136266.37,null,180954.24619999999]
[null,"October",null,{"$f":"'6. Historical Wholesale'!D52","v":74365},3.3265000000000002,247375.17250000002,null,{"$f":"'6. Historical Wholesale'!H52","v":58600},0.76669999999999994,44928.619999999995,null,{"$f":"'6. Historical Wholesale'!L52","v":75969},1.63,123829.46999999999,null,168758.08999999997]
[null,"November",null,{"$f":"'6. Historical Wholesale'!D53","v":92008},3.3265000000000002,306064.61200000002,null,{"$f":"'6. Historical Wholesale'!H53","v":61797},0.76669999999999994,47379.759899999997,null,{"$f":"'6. Historical Wholesale'!L53","v":93898},1.63,153053.74,null,200433.4999]
[null,"December",null,{"$f":"'6. Historical Wholesale'!D54","v":94602},3.3265000000000002,314693.55300000001,null,{"$f":"'6. Historical Wholesale'!H54","v":66229},0.76669999999999994,50777.774299999997,null,{"$f":"'6. Historical Wholesale'!L54","v":95160},1.63,155110.79999999999,null,205888.57429999998]
[]
[null,"Total",null,{"$f":"SUM(D43:D54)","v":1019082},{"$f":"IF(D56<>0,F56/D56,0)","v":3.3265000000000002},{"$f":"SUM(F43:F54)","v":3389976.273},null,{"$f":"SUM(H43:H54)","v":714346},{"$f":"IF(H56<>0,J56/H56,0)","v":0.76669999999999994},{"$f":"SUM(J43:J54)","v":547689.07819999999},null,{"$f":"SUM(L43:L54)","v":1055275},{"$f":"IF(L56<>0,N56/L56,0)","v":1.6300000000000001},{"$f":"SUM(N43:N54)","v":1720098.2500000002},null,{"$f":"SUM(P43:P54)","v":2267787.3281999994}]
[]
[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'!I50","v":0},{"$f":"D62*E62","v":0},null,{"$f":"'6. Historical Wholesale'!H62","v":0},{"$f":"'5. UTRs and Sub-Transmission'!I52","v":0},{"$f":"H62*I62","v":0},null,{"$f":"'6. Historical Wholesale'!L62","v":0},{"$f":"'5. UTRs and Sub-Transmission'!I54","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'!I65","v":0},{"$f":"D81*E81","v":0},null,{"$f":"'6. Historical Wholesale'!H81","v":0},{"$f":"'5. UTRs and Sub-Transmission'!I67","v":0},{"$f":"H81*I81","v":0},null,{"$f":"'6. Historical Wholesale'!L81","v":0},{"$f":"'5. UTRs and Sub-Transmission'!I69","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","v":1379004},{"$f":"IF(D100<>0,F100/D100,0)","v":3.6110058850445679},{"$f":"F24+F43","v":4979591.5594999995},null,{"$f":"H24+H43","v":1237501},{"$f":"IF(H100<>0,J100/H100,0)","v":0.75078381302318131},{"$f":"J24+J43","v":929095.71939999994},null,{"$f":"L24+L43","v":1099030},{"$f":"IF(L100<>0,N100/L100,0)","v":1.831722082199758},{"$f":"N24+N43","v":2013117.52},null,{"$f":"J100+N100","v":2942213.2393999998}]
[null,"February",null,1254772,3.6094419392527088,4529026.6809999999,null,1142149,0.75081252008275623,857539.76899999997,null,1027921,1.8310121984082435,1882135.8900000001,null,2739675.659]
[null,"March",null,1251894,3.6130394106849306,4523142.3600000003,null,1119208,0.7507810536557995,840280.16150000005,null,999514,1.8341540588726122,1833262.6600000001,null,2673542.8215000001]
[null,"April",null,1059230,3.607306911624482,3820967.7,null,960754,0.75090578545600639,721435.73699999996,null,866862,1.8288781605376634,1585384.98,null,2306820.7170000002]
[null,"May",null,1185607,3.6103550442937666,4280462.2129999995,null,1147851,0.75082328011213995,861833.25289999996,null,1005230,1.8330095997930824,1842596.2400000002,null,2704429.4929]
[null,"June",null,1593095,3.6110922964418313,5752813.0819999995,null,1401918,0.75076399225917645,1052509.5545000001,null,1236381,1.8319828192118772,2265028.75,null,3317538.3045000001]
[null,"July",null,1518079,3.6107765346862717,5481444.0310000004,null,1364421,0.75080579564518579,1024415.1945,null,1203190,1.8321656263765489,2204443.36,null,3228858.5544999996]
[null,"August",null,1426828,3.6120694323352223,5153801.8040000005,null,1289409,0.75083887967278029,968138.40899999999,null,1144274,1.8317391813499215,2096011.52,null,3064149.929]
[null,"September",null,1354303,3.6118007971628212,4891472.6550000003,null,1182634,0.75082305785221803,887948.87620000006,null,1049188,1.8324704628722404,1922606.02,null,2810554.8962000003]
[null,"October",null,1087608,3.6092482424733907,3925447.2624999997,null,990260,0.75098824551127985,743673.62,null,867198,1.8307273771387851,1587603.12,null,2331276.7400000002]
[null,"November",null,1254655,3.6077433413966391,4526473.2220000001,null,1098000,0.75093989972677588,824532.00989999995,null,979708,1.8289145745467017,1791802.24,null,2616334.2499000002]
[null,"December",null,1309669,3.6080771271214331,4725386.7630000003,null,1141471,0.75096894647345402,857209.27430000005,null,1018133,1.8294376569662314,1862610.85,null,2719820.1243000003]
[]
[null,"Total",null,{"$f":"SUM(D100:D111)","v":15674744},{"$f":"IF(D113<>0,F113/D113,0)","v":3.6102681698023269},{"$f":"SUM(F100:F111)","v":56590029.333000004},null,{"$f":"SUM(H100:H111)","v":14075576},{"$f":"IF(H113<>0,J113/H113,0)","v":0.7508475374791056},{"$f":"SUM(J100:J111)","v":10568611.578199999},null,{"$f":"SUM(L100:L111)","v":12496629},{"$f":"IF(L113<>0,N113/L113,0)","v":1.831422149925392},{"$f":"SUM(N100:N111)","v":22886603.150000002},null,{"$f":"SUM(P100:P111)","v":33455214.7282}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Transformer Allowance Credit (if applicable)",null,{"$f":"'5. UTRs and Sub-Transmission'!I95","v":-2921352}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total including deduction for Transformer Allowance Credit",null,{"$f":"P113+P115","v":30533862.7282}]

{"sheet":"9. Adj Network to Current WS","index":8,"n_rows":49,"n_cols":18,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The purpose of this sheet is to re-align the current RTS Network Rates to recover current wholesale network costs."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Rate Class",null,"Unit",null,"Current RTSR-Network",null,"Loss Adjusted Billed kWh",null,"Loss Adjusted Billed kW",null,"Billed Amount",null,"Billed Amount %",null,"Current Wholesale Billing",null,"Proposed RTSR Network"]
[]
[]
[null,{"$f":"IF('3. Rate Classes'!Q24=1,'3. Rate Classes'!C24, 0)","v":"Residential"},null,{"$f":"IF(ISERROR(VLOOKUP($B25, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B25, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kWh"},null,{"$f":"IF(ISERROR(VLOOKUP($B25,'3. Rate Classes'!$C$24:$N$45, 8,0)), \"\", VLOOKUP($B25,'3. Rate Classes'!$C$24:$N$45, 8,0))","v":7.3000000000000001E-3},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B25, '4. RRR Data'!$B$27:$M$49,11,0)","v":2384607262.6200004},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B25, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,{"$f":"IF(F25=\"\", \"\", IF(D25=\"kWh\", F25*H25, F25*J25))","v":17407633.017126001},null,{"$f":"IF(ISERROR(L25/$L$49), \"\", L25/$L$49)","v":0.33718053468854753},null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N25), \"\", '7. Current Wholesale'!$F$113*N25)","v":19081056.348541532},null,{"$f":"IF(D25=\"\",\"\",IF(D25=\"kWh\",IF(H25<>0,P25/H25,),IF(J25<>0,P25/J25,0)))","v":8.0017605614338839E-3}]
[null,{"$f":"IF('3. Rate Classes'!Q25=1,'3. Rate Classes'!C25, 0)","v":"General Service Less Than 50 kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B26, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B26, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kWh"},null,{"$f":"IF(ISERROR(VLOOKUP($B26,'3. Rate Classes'!$C$24:$N$45, 8,0)), \"\", VLOOKUP($B26,'3. Rate Classes'!$C$24:$N$45, 8,0))","v":6.6E-3},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B26, '4. RRR Data'!$B$27:$M$49,11,0)","v":727779961.08160007},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B26, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,{"$f":"IF(F26=\"\", \"\", IF(D26=\"kWh\", F26*H26, F26*J26))","v":4803347.7431385601},null,{"$f":"IF(ISERROR(L26/$L$49), \"\", L26/$L$49)","v":9.3039378687102103E-2},null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N26), \"\", '7. Current Wholesale'!$F$113*N26)","v":5265101.1690272037},null,{"$f":"IF(D26=\"\",\"\",IF(D26=\"kWh\",IF(H26<>0,P26/H26,),IF(J26<>0,P26/J26,0)))","v":7.2344684528032376E-3}]
[null,{"$f":"IF('3. Rate Classes'!Q26=1,'3. Rate Classes'!C26, 0)","v":"General Service 50 to 1,499 kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B27, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B27, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B27,'3. Rate Classes'!$C$24:$N$45, 8,0)), \"\", VLOOKUP($B27,'3. Rate Classes'!$C$24:$N$45, 8,0))","v":2.7448000000000001},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B27, '4. RRR Data'!$B$27:$M$49,11,0)","v":2982426722},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B27, '4. RRR Data'!$B$27:$M$49,12,0)","v":7288884},null,20006528.803200003,null,0.38752035227811443,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N27), \"\", '7. Current Wholesale'!$F$113*N27)","v":21929788.102552991},null,3.0086619710991411]
[null,{"$f":"IF('3. Rate Classes'!Q27=1,'3. Rate Classes'!C27, 0)","v":"General Service 1,500 to 4,999 kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B28, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B28, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B28,'3. Rate Classes'!$C$24:$N$45, 8,0)), \"\", VLOOKUP($B28,'3. Rate Classes'!$C$24:$N$45, 8,0))","v":2.85},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B28, '4. RRR Data'!$B$27:$M$49,11,0)","v":870903316},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B28, '4. RRR Data'!$B$27:$M$49,12,0)","v":1864369},null,5313451.6500000004,null,0.10291993556080475,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N28), \"\", '7. Current Wholesale'!$F$113*N28)","v":5824242.1723364117},null,3.1239750137104894]
[null,{"$f":"IF('3. Rate Classes'!Q28=1,'3. Rate Classes'!C28, 0)","v":"Large Use"},null,{"$f":"IF(ISERROR(VLOOKUP($B29, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B29, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B29,'3. Rate Classes'!$C$24:$N$45, 8,0)), \"\", VLOOKUP($B29,'3. Rate Classes'!$C$24:$N$45, 8,0))","v":3.1593},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B29, '4. RRR Data'!$B$27:$M$49,11,0)","v":646432433},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B29, '4. RRR Data'!$B$27:$M$49,12,0)","v":1178836},null,3724296.5748000001,null,7.2138487133451543E-2,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N29), \"\", '7. Current Wholesale'!$F$113*N29)","v":4082319.1029202663},null,3.4630085125668595]
[null,{"$f":"IF('3. Rate Classes'!Q29=1,'3. Rate Classes'!C29, 0)","v":"Unmetered Scattered Load"},null,{"$f":"IF(ISERROR(VLOOKUP($B30, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B30, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kWh"},null,{"$f":"IF(ISERROR(VLOOKUP($B30,'3. Rate Classes'!$C$24:$N$45, 8,0)), \"\", VLOOKUP($B30,'3. Rate Classes'!$C$24:$N$45, 8,0))","v":6.6E-3},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B30, '4. RRR Data'!$B$27:$M$49,11,0)","v":18224001.9256},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B30, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,120278.41270895999,null,2.3297561172617503E-3,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N30), \"\", '7. Current Wholesale'!$F$113*N30)","v":131840.96701457864},null,7.2344684528032367E-3]
[null,{"$f":"IF('3. Rate Classes'!Q30=1,'3. Rate Classes'!C30, 0)","v":"Standby Power General Service 50 to 1,499 kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B31, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B31, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B31,'3. Rate Classes'!$C$24:$N$45, 8,0)), \"\", VLOOKUP($B31,'3. Rate Classes'!$C$24:$N$45, 8,0))","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B31, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B31, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,0,null,0,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N31), \"\", '7. Current Wholesale'!$F$113*N31)","v":0},null,0]
[null,{"$f":"IF('3. Rate Classes'!Q31=1,'3. Rate Classes'!C31, 0)","v":"Standby Power General Service 1,500 to 4,999 kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B32, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B32, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B32,'3. Rate Classes'!$C$24:$N$45, 8,0)), \"\", VLOOKUP($B32,'3. Rate Classes'!$C$24:$N$45, 8,0))","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B32, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B32, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,0,null,0,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N32), \"\", '7. Current Wholesale'!$F$113*N32)","v":0},null,0]
[null,{"$f":"IF('3. Rate Classes'!Q32=1,'3. Rate Classes'!C32, 0)","v":"Standby Power General Service Large Use"},null,{"$f":"IF(ISERROR(VLOOKUP($B33, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B33, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B33,'3. Rate Classes'!$C$24:$N$45, 8,0)), \"\", VLOOKUP($B33,'3. Rate Classes'!$C$24:$N$45, 8,0))","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B33, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B33, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,0,null,0,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N33), \"\", '7. Current Wholesale'!$F$113*N33)","v":0},null,0]
[null,{"$f":"IF('3. Rate Classes'!Q33=1,'3. Rate Classes'!C33, 0)","v":"Sentinel Lighting"},null,{"$f":"IF(ISERROR(VLOOKUP($B34, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B34, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B34,'3. Rate Classes'!$C$24:$N$45, 8,0)), \"\", VLOOKUP($B34,'3. Rate Classes'!$C$24:$N$45, 8,0))","v":2.0261999999999998},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B34, '4. RRR Data'!$B$27:$M$49,11,0)","v":59894},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B34, '4. RRR Data'!$B$27:$M$49,12,0)","v":167},null,338.37539999999996,null,6.5542281472273356E-6,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N34), \"\", '7. Current Wholesale'!$F$113*N34)","v":370.9039631067692},null,2.2209818150105938]
[null,{"$f":"IF('3. Rate Classes'!Q34=1,'3. Rate Classes'!C34, 0)","v":"Street Lighting"},null,{"$f":"IF(ISERROR(VLOOKUP($B35, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B35, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B35,'3. Rate Classes'!$C$24:$N$45, 8,0)), \"\", VLOOKUP($B35,'3. Rate Classes'!$C$24:$N$45, 8,0))","v":2.0365000000000002},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B35, '4. RRR Data'!$B$27:$M$49,11,0)","v":44699159},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B35, '4. RRR Data'!$B$27:$M$49,12,0)","v":123332},null,251165.61800000002,null,4.8650013065705986E-3,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N35), \"\", '7. Current Wholesale'!$F$113*N35)","v":275310.56664391351},null,2.232271970323302]
[null,{"$f":"IF('3. Rate Classes'!Q35=1,'3. Rate Classes'!C35, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B36, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B36, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($B36,'3. Rate Classes'!$C$24:$N$45, 8,0)), \"\", VLOOKUP($B36,'3. Rate Classes'!$C$24:$N$45, 8,0))","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B36, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B36, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N36), \"\", '7. Current Wholesale'!$F$113*N36)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q36=1,'3. Rate Classes'!C36, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B37, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B37, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($B37,'3. Rate Classes'!$C$24:$N$45, 8,0)), \"\", VLOOKUP($B37,'3. Rate Classes'!$C$24:$N$45, 8,0))","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B37, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B37, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N37), \"\", '7. Current Wholesale'!$F$113*N37)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q37=1,'3. Rate Classes'!C37, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B38, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B38, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($B38,'3. Rate Classes'!$C$24:$N$45, 8,0)), \"\", VLOOKUP($B38,'3. Rate Classes'!$C$24:$N$45, 8,0))","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B38, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B38, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N38), \"\", '7. Current Wholesale'!$F$113*N38)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q38=1,'3. Rate Classes'!C38, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B39, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B39, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($B39,'3. Rate Classes'!$C$24:$N$45, 8,0)), \"\", VLOOKUP($B39,'3. Rate Classes'!$C$24:$N$45, 8,0))","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B39, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B39, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,{"$f":"IF(F39=\"\", \"\", IF(D39=\"kWh\", F39*H39, F39*J39))","v":""},null,"",null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N39), \"\", '7. Current Wholesale'!$F$113*N39)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q39=1,'3. Rate Classes'!C39, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B40, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B40, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($B40,'3. Rate Classes'!$C$24:$N$45, 8,0)), \"\", VLOOKUP($B40,'3. Rate Classes'!$C$24:$N$45, 8,0))","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B40, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B40, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N40), \"\", '7. Current Wholesale'!$F$113*N40)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q40=1,'3. Rate Classes'!C40, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B41, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B41, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($B41,'3. Rate Classes'!$C$24:$N$45, 8,0)), \"\", VLOOKUP($B41,'3. Rate Classes'!$C$24:$N$45, 8,0))","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B41, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B41, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N41), \"\", '7. Current Wholesale'!$F$113*N41)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q41=1,'3. Rate Classes'!C41, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B42, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B42, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($B42,'3. Rate Classes'!$C$24:$N$45, 8,0)), \"\", VLOOKUP($B42,'3. Rate Classes'!$C$24:$N$45, 8,0))","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B42, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B42, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N42), \"\", '7. Current Wholesale'!$F$113*N42)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q42=1,'3. Rate Classes'!C42, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B43, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B43, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($B43,'3. Rate Classes'!$C$24:$N$45, 8,0)), \"\", VLOOKUP($B43,'3. Rate Classes'!$C$24:$N$45, 8,0))","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B43, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B43, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N43), \"\", '7. Current Wholesale'!$F$113*N43)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q43=1,'3. Rate Classes'!C43, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B44, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B44, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($B44,'3. Rate Classes'!$C$24:$N$45, 8,0)), \"\", VLOOKUP($B44,'3. Rate Classes'!$C$24:$N$45, 8,0))","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B44, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B44, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N44), \"\", '7. Current Wholesale'!$F$113*N44)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q44=1,'3. Rate Classes'!C44, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B45, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B45, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($B45,'3. Rate Classes'!$C$24:$N$45, 8,0)), \"\", VLOOKUP($B45,'3. Rate Classes'!$C$24:$N$45, 8,0))","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B45, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B45, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N45), \"\", '7. Current Wholesale'!$F$113*N45)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q45=1,'3. Rate Classes'!C45, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B46, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B46, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($B46,'3. Rate Classes'!$C$24:$N$45, 8,0)), \"\", VLOOKUP($B46,'3. Rate Classes'!$C$24:$N$45, 8,0))","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B46, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B46, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N46), \"\", '7. Current Wholesale'!$F$113*N46)","v":""},null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L25:L46)","v":51627040.194373526}]

{"sheet":"10. Adj Conn. to Current WS","index":9,"n_rows":49,"n_cols":18,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The purpose of this sheet is to re-align the current RTS Connection Rates to recover current wholesale connection costs."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Rate Class",null,"Unit",null,"Current RTSR-Connection",null,"Loss Adjusted Billed kWh",null,"Loss Adjusted Billed kW",null,"Billed Amount",null,"Billed Amount %",null,"Current Wholesale Billing",null,"Proposed RTSR Connection"]
[]
[]
[null,{"$f":"IF('3. Rate Classes'!Q24=1,'3. Rate Classes'!C24, 0)","v":"Residential"},null,{"$f":"IF(ISERROR(VLOOKUP($B25, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B25, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kWh"},null,{"$f":"IF(ISERROR(VLOOKUP($B25,'3. Rate Classes'!$C$24:$N$45, 11,0)), \"\", VLOOKUP($B25,'3. Rate Classes'!$C$24:$N$45, 11,0))","v":4.1999999999999997E-3},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B25, '4. RRR Data'!$B$27:$M$49,11,0)","v":2384607262.6200004},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B25, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,{"$f":"IF(F25=\"\", \"\", IF(D25=\"kWh\", F25*H25, F25*J25))","v":10015350.503004001},null,{"$f":"IF(ISERROR(L25/$L$49), \"\", L25/$L$49)","v":0.33152680524486211},null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N25), \"\", '7. Current Wholesale'!$P$117*N25)","v":10145498.906849315},null,{"$f":"IF(D25=\"\",\"\",IF(D25=\"kWh\",IF(H25<>0,P25/H25,),IF(J25<>0,P25/J25,0)))","v":4.2545785487973055E-3}]
[null,{"$f":"IF('3. Rate Classes'!Q25=1,'3. Rate Classes'!C25, 0)","v":"General Service Less Than 50 kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B26, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B26, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kWh"},null,{"$f":"IF(ISERROR(VLOOKUP($B26,'3. Rate Classes'!$C$24:$N$45, 11,0)), \"\", VLOOKUP($B26,'3. Rate Classes'!$C$24:$N$45, 11,0))","v":4.0000000000000001E-3},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B26, '4. RRR Data'!$B$27:$M$49,11,0)","v":727779961.08160007},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B26, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,2911119.8443264002,null,9.6363503342691378E-2,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N26), \"\", '7. Current Wholesale'!$P$117*N26)","v":2948949.5339641077},null,4.0519795702831478E-3]
[null,{"$f":"IF('3. Rate Classes'!Q26=1,'3. Rate Classes'!C26, 0)","v":"General Service 50 to 1,499 kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B27, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B27, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B27,'3. Rate Classes'!$C$24:$N$45, 11,0)), \"\", VLOOKUP($B27,'3. Rate Classes'!$C$24:$N$45, 11,0))","v":1.5945},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B27, '4. RRR Data'!$B$27:$M$49,11,0)","v":2982426722},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B27, '4. RRR Data'!$B$27:$M$49,12,0)","v":7288884},null,11622125.538000001,null,0.38471405954411514,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N27), \"\", '7. Current Wholesale'!$P$117*N27)","v":11773153.81081051},null,1.6152203562041199]
[null,{"$f":"IF('3. Rate Classes'!Q27=1,'3. Rate Classes'!C27, 0)","v":"General Service 1,500 to 4,999 kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B28, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B28, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B28,'3. Rate Classes'!$C$24:$N$45, 11,0)), \"\", VLOOKUP($B28,'3. Rate Classes'!$C$24:$N$45, 11,0))","v":1.704},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B28, '4. RRR Data'!$B$27:$M$49,11,0)","v":870903316},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B28, '4. RRR Data'!$B$27:$M$49,12,0)","v":1864369},null,3176884.7760000001,null,0.10516081889519655,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N28), \"\", '7. Current Wholesale'!$P$117*N28)","v":3218168.0523738884},null,1.726143296940621]
[null,{"$f":"IF('3. Rate Classes'!Q28=1,'3. Rate Classes'!C28, 0)","v":"Large Use"},null,{"$f":"IF(ISERROR(VLOOKUP($B29, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B29, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B29,'3. Rate Classes'!$C$24:$N$45, 11,0)), \"\", VLOOKUP($B29,'3. Rate Classes'!$C$24:$N$45, 11,0))","v":1.9189000000000001},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B29, '4. RRR Data'!$B$27:$M$49,11,0)","v":646432433},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B29, '4. RRR Data'!$B$27:$M$49,12,0)","v":1178836},null,2262068.4004000002,null,7.4878688449798336E-2,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N29), \"\", '7. Current Wholesale'!$P$117*N29)","v":2291463.73625097},null,1.9438358993540832]
[null,{"$f":"IF('3. Rate Classes'!Q29=1,'3. Rate Classes'!C29, 0)","v":"Unmetered Scattered Load"},null,{"$f":"IF(ISERROR(VLOOKUP($B30, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B30, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kWh"},null,{"$f":"IF(ISERROR(VLOOKUP($B30,'3. Rate Classes'!$C$24:$N$45, 11,0)), \"\", VLOOKUP($B30,'3. Rate Classes'!$C$24:$N$45, 11,0))","v":4.0000000000000001E-3},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B30, '4. RRR Data'!$B$27:$M$49,11,0)","v":18224001.9256},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B30, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,72896.007702400006,null,2.4129939877224364E-3,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N30), \"\", '7. Current Wholesale'!$P$117*N30)","v":73843.283491331953},null,4.0519795702831487E-3]
[null,{"$f":"IF('3. Rate Classes'!Q30=1,'3. Rate Classes'!C30, 0)","v":"Standby Power General Service 50 to 1,499 kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B31, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B31, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B31,'3. Rate Classes'!$C$24:$N$45, 11,0)), \"\", VLOOKUP($B31,'3. Rate Classes'!$C$24:$N$45, 11,0))","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B31, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B31, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,0,null,0,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N31), \"\", '7. Current Wholesale'!$P$117*N31)","v":0},null,0]
[null,{"$f":"IF('3. Rate Classes'!Q31=1,'3. Rate Classes'!C31, 0)","v":"Standby Power General Service 1,500 to 4,999 kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B32, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B32, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B32,'3. Rate Classes'!$C$24:$N$45, 11,0)), \"\", VLOOKUP($B32,'3. Rate Classes'!$C$24:$N$45, 11,0))","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B32, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B32, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,0,null,0,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N32), \"\", '7. Current Wholesale'!$P$117*N32)","v":0},null,0]
[null,{"$f":"IF('3. Rate Classes'!Q32=1,'3. Rate Classes'!C32, 0)","v":"Standby Power General Service Large Use"},null,{"$f":"IF(ISERROR(VLOOKUP($B33, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B33, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B33,'3. Rate Classes'!$C$24:$N$45, 11,0)), \"\", VLOOKUP($B33,'3. Rate Classes'!$C$24:$N$45, 11,0))","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B33, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B33, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,0,null,0,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N33), \"\", '7. Current Wholesale'!$P$117*N33)","v":0},null,0]
[null,{"$f":"IF('3. Rate Classes'!Q33=1,'3. Rate Classes'!C33, 0)","v":"Sentinel Lighting"},null,{"$f":"IF(ISERROR(VLOOKUP($B34, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B34, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B34,'3. Rate Classes'!$C$24:$N$45, 11,0)), \"\", VLOOKUP($B34,'3. Rate Classes'!$C$24:$N$45, 11,0))","v":1.1845000000000001},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B34, '4. RRR Data'!$B$27:$M$49,11,0)","v":59894},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B34, '4. RRR Data'!$B$27:$M$49,12,0)","v":167},null,197.81150000000002,null,6.5479300615614059E-6,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N34), \"\", '7. Current Wholesale'!$P$117*N34)","v":200.38203919176624},null,1.1998924502500972]
[null,{"$f":"IF('3. Rate Classes'!Q34=1,'3. Rate Classes'!C34, 0)","v":"Street Lighting"},null,{"$f":"IF(ISERROR(VLOOKUP($B35, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B35, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B35,'3. Rate Classes'!$C$24:$N$45, 11,0)), \"\", VLOOKUP($B35,'3. Rate Classes'!$C$24:$N$45, 11,0))","v":1.2092000000000001},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B35, '4. RRR Data'!$B$27:$M$49,11,0)","v":44699159},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B35, '4. RRR Data'!$B$27:$M$49,12,0)","v":123332},null,149133.05439999999,null,4.9365826055524191E-3,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N35), \"\", '7. Current Wholesale'!$P$117*N35)","v":151071.02242068131},null,1.2249134240965955]
[null,{"$f":"IF('3. Rate Classes'!Q35=1,'3. Rate Classes'!C35, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B36, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B36, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($B36,'3. Rate Classes'!$C$24:$N$45, 11,0)), \"\", VLOOKUP($B36,'3. Rate Classes'!$C$24:$N$45, 11,0))","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B36, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B36, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N36), \"\", '7. Current Wholesale'!$P$117*N36)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q36=1,'3. Rate Classes'!C36, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B37, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B37, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($B37,'3. Rate Classes'!$C$24:$N$45, 11,0)), \"\", VLOOKUP($B37,'3. Rate Classes'!$C$24:$N$45, 11,0))","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B37, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B37, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N37), \"\", '7. Current Wholesale'!$P$117*N37)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q37=1,'3. Rate Classes'!C37, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B38, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B38, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($B38,'3. Rate Classes'!$C$24:$N$45, 11,0)), \"\", VLOOKUP($B38,'3. Rate Classes'!$C$24:$N$45, 11,0))","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B38, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B38, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N38), \"\", '7. Current Wholesale'!$P$117*N38)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q38=1,'3. Rate Classes'!C38, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B39, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B39, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($B39,'3. Rate Classes'!$C$24:$N$45, 11,0)), \"\", VLOOKUP($B39,'3. Rate Classes'!$C$24:$N$45, 11,0))","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B39, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B39, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N39), \"\", '7. Current Wholesale'!$P$117*N39)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q39=1,'3. Rate Classes'!C39, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B40, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B40, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($B40,'3. Rate Classes'!$C$24:$N$45, 11,0)), \"\", VLOOKUP($B40,'3. Rate Classes'!$C$24:$N$45, 11,0))","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B40, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B40, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N40), \"\", '7. Current Wholesale'!$P$117*N40)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q40=1,'3. Rate Classes'!C40, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B41, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B41, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($B41,'3. Rate Classes'!$C$24:$N$45, 11,0)), \"\", VLOOKUP($B41,'3. Rate Classes'!$C$24:$N$45, 11,0))","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B41, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B41, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N41), \"\", '7. Current Wholesale'!$P$117*N41)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q41=1,'3. Rate Classes'!C41, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B42, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B42, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($B42,'3. Rate Classes'!$C$24:$N$45, 11,0)), \"\", VLOOKUP($B42,'3. Rate Classes'!$C$24:$N$45, 11,0))","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B42, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B42, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N42), \"\", '7. Current Wholesale'!$P$117*N42)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q42=1,'3. Rate Classes'!C42, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B43, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B43, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($B43,'3. Rate Classes'!$C$24:$N$45, 11,0)), \"\", VLOOKUP($B43,'3. Rate Classes'!$C$24:$N$45, 11,0))","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B43, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B43, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N43), \"\", '7. Current Wholesale'!$P$117*N43)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q43=1,'3. Rate Classes'!C43, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B44, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B44, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($B44,'3. Rate Classes'!$C$24:$N$45, 11,0)), \"\", VLOOKUP($B44,'3. Rate Classes'!$C$24:$N$45, 11,0))","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B44, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B44, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N44), \"\", '7. Current Wholesale'!$P$117*N44)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q44=1,'3. Rate Classes'!C44, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B45, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B45, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($B45,'3. Rate Classes'!$C$24:$N$45, 11,0)), \"\", VLOOKUP($B45,'3. Rate Classes'!$C$24:$N$45, 11,0))","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B45, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B45, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N45), \"\", '7. Current Wholesale'!$P$117*N45)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q45=1,'3. Rate Classes'!C45, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B46, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B46, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($B46,'3. Rate Classes'!$C$24:$N$45, 11,0)), \"\", VLOOKUP($B46,'3. Rate Classes'!$C$24:$N$45, 11,0))","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B46, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B46, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N46), \"\", '7. Current Wholesale'!$P$117*N46)","v":""},null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L25:L46)","v":30209775.935332805}]

{"sheet":"11. Adj Network to Forecast WS","index":10,"n_rows":49,"n_cols":18,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The purpose of this sheet is to update the re-align RTS Network Rates to recover forecast wholesale network costs."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Rate Class",null,"Unit",null,"Adjusted RTSR-Network",null,"Loss Adjusted Billed kWh",null,"Loss Adjusted Billed kW",null,"Billed Amount",null,"Billed Amount %",null,"Forecast Wholesale Billing",null,"Proposed RTSR Network"]
[]
[]
[null,{"$f":"IF('3. Rate Classes'!Q24=1,'3. Rate Classes'!C24, 0)","v":"Residential"},null,{"$f":"IF(ISERROR(VLOOKUP($B25, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B25, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kWh"},null,{"$f":"VLOOKUP($B25, '9. Adj Network to Current WS'!$B$25:$R$47, 17,0)","v":8.0017605614338839E-3},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B25, '4. RRR Data'!$B$27:$M$49,11,0)","v":2384607262.6200004},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B25, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,{"$f":"IF(F25=\"\", \"\", IF(D25=\"kWh\", F25*H25, F25*J25))","v":19081056.348541532},null,{"$f":"IF(ISERROR(L25/$L$49), \"\", L25/$L$49)","v":0.33718053468854753},null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N25), \"\", '8. Forecast Wholesale'!$F$113*N25)","v":19081056.348541532},null,{"$f":"IF(D25=\"\",\"\",IF(D25=\"kWh\",IF(H25<>0,P25/H25,),IF(J25<>0,P25/J25,0)))","v":8.0017605614338839E-3}]
[null,{"$f":"IF('3. Rate Classes'!Q25=1,'3. Rate Classes'!C25, 0)","v":"General Service Less Than 50 kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B26, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B26, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kWh"},null,{"$f":"VLOOKUP($B26, '9. Adj Network to Current WS'!$B$25:$R$47, 17,0)","v":7.2344684528032376E-3},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B26, '4. RRR Data'!$B$27:$M$49,11,0)","v":727779961.08160007},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B26, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,{"$f":"IF(F26=\"\", \"\", IF(D26=\"kWh\", F26*H26, F26*J26))","v":5265101.1690272037},null,9.3039378687102089E-2,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N26), \"\", '8. Forecast Wholesale'!$F$113*N26)","v":5265101.1690272028},null,7.2344684528032359E-3]
[null,{"$f":"IF('3. Rate Classes'!Q26=1,'3. Rate Classes'!C26, 0)","v":"General Service 50 to 1,499 kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B27, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B27, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"VLOOKUP($B27, '9. Adj Network to Current WS'!$B$25:$R$47, 17,0)","v":3.0086619710991411},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B27, '4. RRR Data'!$B$27:$M$49,11,0)","v":2982426722},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B27, '4. RRR Data'!$B$27:$M$49,12,0)","v":7288884},null,21929788.102552991,null,0.38752035227811438,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N27), \"\", '8. Forecast Wholesale'!$F$113*N27)","v":21929788.102552988},null,3.0086619710991407]
[null,{"$f":"IF('3. Rate Classes'!Q27=1,'3. Rate Classes'!C27, 0)","v":"General Service 1,500 to 4,999 kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B28, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B28, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"VLOOKUP($B28, '9. Adj Network to Current WS'!$B$25:$R$47, 17,0)","v":3.1239750137104894},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B28, '4. RRR Data'!$B$27:$M$49,11,0)","v":870903316},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B28, '4. RRR Data'!$B$27:$M$49,12,0)","v":1864369},null,5824242.1723364117,null,0.10291993556080475,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N28), \"\", '8. Forecast Wholesale'!$F$113*N28)","v":5824242.1723364117},null,3.1239750137104894]
[null,{"$f":"IF('3. Rate Classes'!Q28=1,'3. Rate Classes'!C28, 0)","v":"Large Use"},null,{"$f":"IF(ISERROR(VLOOKUP($B29, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B29, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"VLOOKUP($B29, '9. Adj Network to Current WS'!$B$25:$R$47, 17,0)","v":3.4630085125668595},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B29, '4. RRR Data'!$B$27:$M$49,11,0)","v":646432433},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B29, '4. RRR Data'!$B$27:$M$49,12,0)","v":1178836},null,4082319.1029202663,null,7.2138487133451529E-2,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N29), \"\", '8. Forecast Wholesale'!$F$113*N29)","v":4082319.1029202654},null,3.4630085125668586]
[null,{"$f":"IF('3. Rate Classes'!Q29=1,'3. Rate Classes'!C29, 0)","v":"Unmetered Scattered Load"},null,{"$f":"IF(ISERROR(VLOOKUP($B30, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B30, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kWh"},null,{"$f":"VLOOKUP($B30, '9. Adj Network to Current WS'!$B$25:$R$47, 17,0)","v":7.2344684528032367E-3},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B30, '4. RRR Data'!$B$27:$M$49,11,0)","v":18224001.9256},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B30, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,131840.96701457864,null,2.3297561172617499E-3,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N30), \"\", '8. Forecast Wholesale'!$F$113*N30)","v":131840.96701457864},null,7.2344684528032367E-3]
[null,{"$f":"IF('3. Rate Classes'!Q30=1,'3. Rate Classes'!C30, 0)","v":"Standby Power General Service 50 to 1,499 kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B31, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B31, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"VLOOKUP($B31, '9. Adj Network to Current WS'!$B$25:$R$47, 17,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B31, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B31, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,0,null,0,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N31), \"\", '8. Forecast Wholesale'!$F$113*N31)","v":0},null,0]
[null,{"$f":"IF('3. Rate Classes'!Q31=1,'3. Rate Classes'!C31, 0)","v":"Standby Power General Service 1,500 to 4,999 kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B32, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B32, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"VLOOKUP($B32, '9. Adj Network to Current WS'!$B$25:$R$47, 17,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B32, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B32, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,0,null,0,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N32), \"\", '8. Forecast Wholesale'!$F$113*N32)","v":0},null,0]
[null,{"$f":"IF('3. Rate Classes'!Q32=1,'3. Rate Classes'!C32, 0)","v":"Standby Power General Service Large Use"},null,{"$f":"IF(ISERROR(VLOOKUP($B33, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B33, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"VLOOKUP($B33, '9. Adj Network to Current WS'!$B$25:$R$47, 17,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B33, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B33, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,0,null,0,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N33), \"\", '8. Forecast Wholesale'!$F$113*N33)","v":0},null,0]
[null,{"$f":"IF('3. Rate Classes'!Q33=1,'3. Rate Classes'!C33, 0)","v":"Sentinel Lighting"},null,{"$f":"IF(ISERROR(VLOOKUP($B34, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B34, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"VLOOKUP($B34, '9. Adj Network to Current WS'!$B$25:$R$47, 17,0)","v":2.2209818150105938},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B34, '4. RRR Data'!$B$27:$M$49,11,0)","v":59894},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B34, '4. RRR Data'!$B$27:$M$49,12,0)","v":167},null,370.90396310676914,null,6.5542281472273339E-6,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N34), \"\", '8. Forecast Wholesale'!$F$113*N34)","v":370.90396310676908},null,2.2209818150105933]
[null,{"$f":"IF('3. Rate Classes'!Q34=1,'3. Rate Classes'!C34, 0)","v":"Street Lighting"},null,{"$f":"IF(ISERROR(VLOOKUP($B35, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B35, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"VLOOKUP($B35, '9. Adj Network to Current WS'!$B$25:$R$47, 17,0)","v":2.232271970323302},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B35, '4. RRR Data'!$B$27:$M$49,11,0)","v":44699159},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B35, '4. RRR Data'!$B$27:$M$49,12,0)","v":123332},null,275310.56664391351,null,4.8650013065705978E-3,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N35), \"\", '8. Forecast Wholesale'!$F$113*N35)","v":275310.56664391345},null,2.2322719703233016]
[null,{"$f":"IF('3. Rate Classes'!Q35=1,'3. Rate Classes'!C35, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B36, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B36, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B36, '9. Adj Network to Current WS'!$B$25:$R$47, 17,0)","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B36, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B36, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N36), \"\", '8. Forecast Wholesale'!$F$113*N36)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q36=1,'3. Rate Classes'!C36, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B37, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B37, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B37, '9. Adj Network to Current WS'!$B$25:$R$47, 17,0)","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B37, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B37, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N37), \"\", '8. Forecast Wholesale'!$F$113*N37)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q37=1,'3. Rate Classes'!C37, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B38, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B38, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B38, '9. Adj Network to Current WS'!$B$25:$R$47, 17,0)","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B38, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B38, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N38), \"\", '8. Forecast Wholesale'!$F$113*N38)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q38=1,'3. Rate Classes'!C38, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B39, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B39, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B39, '9. Adj Network to Current WS'!$B$25:$R$47, 17,0)","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B39, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B39, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N39), \"\", '8. Forecast Wholesale'!$F$113*N39)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q39=1,'3. Rate Classes'!C39, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B40, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B40, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B40, '9. Adj Network to Current WS'!$B$25:$R$47, 17,0)","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B40, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B40, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N40), \"\", '8. Forecast Wholesale'!$F$113*N40)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q40=1,'3. Rate Classes'!C40, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B41, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B41, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B41, '9. Adj Network to Current WS'!$B$25:$R$47, 17,0)","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B41, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B41, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N41), \"\", '8. Forecast Wholesale'!$F$113*N41)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q41=1,'3. Rate Classes'!C41, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B42, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B42, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B42, '9. Adj Network to Current WS'!$B$25:$R$47, 17,0)","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B42, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B42, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N42), \"\", '8. Forecast Wholesale'!$F$113*N42)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q42=1,'3. Rate Classes'!C42, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B43, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B43, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B43, '9. Adj Network to Current WS'!$B$25:$R$47, 17,0)","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B43, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B43, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N43), \"\", '8. Forecast Wholesale'!$F$113*N43)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q43=1,'3. Rate Classes'!C43, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B44, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B44, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B44, '9. Adj Network to Current WS'!$B$25:$R$47, 17,0)","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B44, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B44, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N44), \"\", '8. Forecast Wholesale'!$F$113*N44)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q44=1,'3. Rate Classes'!C44, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B45, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B45, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B45, '9. Adj Network to Current WS'!$B$25:$R$47, 17,0)","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B45, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B45, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N45), \"\", '8. Forecast Wholesale'!$F$113*N45)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q45=1,'3. Rate Classes'!C45, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B46, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B46, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B46, '9. Adj Network to Current WS'!$B$25:$R$47, 17,0)","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B46, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B46, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N46), \"\", '8. Forecast Wholesale'!$F$113*N46)","v":""},null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L25:L46)","v":56590029.333000012}]

{"sheet":"12. Adj Conn. to Forecast WS","index":11,"n_rows":49,"n_cols":18,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The purpose of this sheet is to update the re-aligned RTS Connection Rates to recover forecast wholesale connection costs."]
[]
[]
[]
[]
[]
[null,"Rate Class"]
[]
[]
[null,"Rate Class",null,"Unit",null,"Adjusted RTSR-Connection",null,"Loss Adjusted Billed kWh",null,"Loss Adjusted Billed kW",null,"Billed Amount",null,"Billed Amount %",null,"Forecast Wholesale Billing",null,"Proposed RTSR Connection"]
[]
[]
[null,{"$f":"IF('3. Rate Classes'!Q24=1,'3. Rate Classes'!C24, 0)","v":"Residential"},null,{"$f":"IF(ISERROR(VLOOKUP($B25, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B25, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kWh"},null,{"$f":"VLOOKUP($B25, '10. Adj Conn. to Current WS'!$B$25:$R$47, 17,0)","v":4.2545785487973055E-3},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B25, '4. RRR Data'!$B$27:$M$49,11,0)","v":2384607262.6200004},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B25, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,{"$f":"IF(F25=\"\", \"\", IF(D25=\"kWh\", F25*H25, F25*J25))","v":10145498.906849317},null,{"$f":"IF(ISERROR(L25/$L$49), \"\", L25/$L$49)","v":0.33152680524486217},null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N25), \"\", '8. Forecast Wholesale'!$P$117*N25)","v":10122793.962065317},null,{"$f":"IF(D25=\"\",\"\",IF(D25=\"kWh\",IF(H25<>0,P25/H25,),IF(J25<>0,P25/J25,0)))","v":4.2450570879094219E-3}]
[null,{"$f":"IF('3. Rate Classes'!Q25=1,'3. Rate Classes'!C25, 0)","v":"General Service Less Than 50 kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B26, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B26, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kWh"},null,{"$f":"VLOOKUP($B26, '10. Adj Conn. to Current WS'!$B$25:$R$47, 17,0)","v":4.0519795702831478E-3},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B26, '4. RRR Data'!$B$27:$M$49,11,0)","v":727779961.08160007},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B26, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,2948949.5339641077,null,9.6363503342691365E-2,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N26), \"\", '8. Forecast Wholesale'!$P$117*N26)","v":2942349.9830741799},null,4.0429115122946864E-3]
[null,{"$f":"IF('3. Rate Classes'!Q26=1,'3. Rate Classes'!C26, 0)","v":"General Service 50 to 1,499 kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B27, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B27, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"VLOOKUP($B27, '10. Adj Conn. to Current WS'!$B$25:$R$47, 17,0)","v":1.6152203562041199},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B27, '4. RRR Data'!$B$27:$M$49,11,0)","v":2982426722},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B27, '4. RRR Data'!$B$27:$M$49,12,0)","v":7288884},null,11773153.81081051,null,0.38471405954411508,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N27), \"\", '8. Forecast Wholesale'!$P$117*N27)","v":11746806.283728572},null,1.6116056015884697]
[null,{"$f":"IF('3. Rate Classes'!Q27=1,'3. Rate Classes'!C27, 0)","v":"General Service 1,500 to 4,999 kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B28, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B28, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"VLOOKUP($B28, '10. Adj Conn. to Current WS'!$B$25:$R$47, 17,0)","v":1.726143296940621},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B28, '4. RRR Data'!$B$27:$M$49,11,0)","v":870903316},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B28, '4. RRR Data'!$B$27:$M$49,12,0)","v":1864369},null,3218168.0523738884,null,0.10516081889519653,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N28), \"\", '8. Forecast Wholesale'!$P$117*N28)","v":3210966.0085310317},null,1.7222803042375365]
[null,{"$f":"IF('3. Rate Classes'!Q28=1,'3. Rate Classes'!C28, 0)","v":"Large Use"},null,{"$f":"IF(ISERROR(VLOOKUP($B29, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B29, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"VLOOKUP($B29, '10. Adj Conn. to Current WS'!$B$25:$R$47, 17,0)","v":1.9438358993540832},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B29, '4. RRR Data'!$B$27:$M$49,11,0)","v":646432433},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B29, '4. RRR Data'!$B$27:$M$49,12,0)","v":1178836},null,2291463.73625097,null,7.4878688449798322E-2,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N29), \"\", '8. Forecast Wholesale'!$P$117*N29)","v":2286335.5943937968},null,1.9394857252355686]
[null,{"$f":"IF('3. Rate Classes'!Q29=1,'3. Rate Classes'!C29, 0)","v":"Unmetered Scattered Load"},null,{"$f":"IF(ISERROR(VLOOKUP($B30, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B30, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kWh"},null,{"$f":"VLOOKUP($B30, '10. Adj Conn. to Current WS'!$B$25:$R$47, 17,0)","v":4.0519795702831487E-3},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B30, '4. RRR Data'!$B$27:$M$49,11,0)","v":18224001.9256},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B30, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,73843.283491331968,null,2.4129939877224368E-3,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N30), \"\", '8. Forecast Wholesale'!$P$117*N30)","v":73678.027185088795},null,4.0429115122946873E-3]
[null,{"$f":"IF('3. Rate Classes'!Q30=1,'3. Rate Classes'!C30, 0)","v":"Standby Power General Service 50 to 1,499 kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B31, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B31, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"VLOOKUP($B31, '10. Adj Conn. to Current WS'!$B$25:$R$47, 17,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B31, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B31, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,0,null,0,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N31), \"\", '8. Forecast Wholesale'!$P$117*N31)","v":0},null,0]
[null,{"$f":"IF('3. Rate Classes'!Q31=1,'3. Rate Classes'!C31, 0)","v":"Standby Power General Service 1,500 to 4,999 kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B32, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B32, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"VLOOKUP($B32, '10. Adj Conn. to Current WS'!$B$25:$R$47, 17,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B32, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B32, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,0,null,0,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N32), \"\", '8. Forecast Wholesale'!$P$117*N32)","v":0},null,0]
[null,{"$f":"IF('3. Rate Classes'!Q32=1,'3. Rate Classes'!C32, 0)","v":"Standby Power General Service Large Use"},null,{"$f":"IF(ISERROR(VLOOKUP($B33, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B33, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"VLOOKUP($B33, '10. Adj Conn. to Current WS'!$B$25:$R$47, 17,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B33, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B33, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,0,null,0,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N33), \"\", '8. Forecast Wholesale'!$P$117*N33)","v":0},null,0]
[null,{"$f":"IF('3. Rate Classes'!Q33=1,'3. Rate Classes'!C33, 0)","v":"Sentinel Lighting"},null,{"$f":"IF(ISERROR(VLOOKUP($B34, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B34, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"VLOOKUP($B34, '10. Adj Conn. to Current WS'!$B$25:$R$47, 17,0)","v":1.1998924502500972},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B34, '4. RRR Data'!$B$27:$M$49,11,0)","v":59894},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B34, '4. RRR Data'!$B$27:$M$49,12,0)","v":167},null,200.38203919176624,null,6.5479300615614051E-6,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N34), \"\", '8. Forecast Wholesale'!$P$117*N34)","v":199.9335976535701},null,1.1972071715782642]
[null,{"$f":"IF('3. Rate Classes'!Q34=1,'3. Rate Classes'!C34, 0)","v":"Street Lighting"},null,{"$f":"IF(ISERROR(VLOOKUP($B35, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B35, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"VLOOKUP($B35, '10. Adj Conn. to Current WS'!$B$25:$R$47, 17,0)","v":1.2249134240965955},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B35, '4. RRR Data'!$B$27:$M$49,11,0)","v":44699159},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B35, '4. RRR Data'!$B$27:$M$49,12,0)","v":123332},null,151071.02242068131,null,4.9365826055524182E-3,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N35), \"\", '8. Forecast Wholesale'!$P$117*N35)","v":150732.93562435743},null,1.2221721501666836]
[null,{"$f":"IF('3. Rate Classes'!Q35=1,'3. Rate Classes'!C35, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B36, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B36, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B36, '10. Adj Conn. to Current WS'!$B$25:$R$47, 17,0)","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B36, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B36, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N36), \"\", '8. Forecast Wholesale'!$P$117*N36)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q36=1,'3. Rate Classes'!C36, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B37, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B37, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B37, '10. Adj Conn. to Current WS'!$B$25:$R$47, 17,0)","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B37, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B37, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N37), \"\", '8. Forecast Wholesale'!$P$117*N37)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q37=1,'3. Rate Classes'!C37, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B38, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B38, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B38, '10. Adj Conn. to Current WS'!$B$25:$R$47, 17,0)","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B38, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B38, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N38), \"\", '8. Forecast Wholesale'!$P$117*N38)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q38=1,'3. Rate Classes'!C38, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B39, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B39, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B39, '10. Adj Conn. to Current WS'!$B$25:$R$47, 17,0)","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B39, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B39, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N39), \"\", '8. Forecast Wholesale'!$P$117*N39)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q39=1,'3. Rate Classes'!C39, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B40, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B40, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B40, '10. Adj Conn. to Current WS'!$B$25:$R$47, 17,0)","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B40, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B40, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N40), \"\", '8. Forecast Wholesale'!$P$117*N40)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q40=1,'3. Rate Classes'!C40, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B41, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B41, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B41, '10. Adj Conn. to Current WS'!$B$25:$R$47, 17,0)","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B41, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B41, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N41), \"\", '8. Forecast Wholesale'!$P$117*N41)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q41=1,'3. Rate Classes'!C41, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B42, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B42, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B42, '10. Adj Conn. to Current WS'!$B$25:$R$47, 17,0)","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B42, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B42, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N42), \"\", '8. Forecast Wholesale'!$P$117*N42)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q42=1,'3. Rate Classes'!C42, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B43, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B43, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B43, '10. Adj Conn. to Current WS'!$B$25:$R$47, 17,0)","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B43, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B43, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N43), \"\", '8. Forecast Wholesale'!$P$117*N43)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q43=1,'3. Rate Classes'!C43, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B44, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B44, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B44, '10. Adj Conn. to Current WS'!$B$25:$R$47, 17,0)","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B44, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B44, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N44), \"\", '8. Forecast Wholesale'!$P$117*N44)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q44=1,'3. Rate Classes'!C44, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B45, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B45, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B45, '10. Adj Conn. to Current WS'!$B$25:$R$47, 17,0)","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B45, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B45, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N45), \"\", '8. Forecast Wholesale'!$P$117*N45)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q45=1,'3. Rate Classes'!C45, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B46, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B46, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B46, '10. Adj Conn. to Current WS'!$B$25:$R$47, 17,0)","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B46, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B46, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N46), \"\", '8. Forecast Wholesale'!$P$117*N46)","v":""},null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L25:L46)","v":30602348.728200004}]

{"sheet":"13. Final 2014 RTS Rates","index":12,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[[12,1,12,11]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"For Cost of Service Applicants, please enter the following Proposed RTS rates into your rates model.\n\nFor IRM applicants, please enter these rates into the 2013 IRM Rate Generator, Sheet 11 \"Proposed Rates\", column I.  \nPlease note that the rate descriptions for the RTSRs are transfered automatically from Sheet 4 to Sheet 11, Column A.\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Rate Class",null,"Unit",null,"Proposed RTSR Network",null,"Proposed RTSR Connection"]
[]
[]
[null,{"$f":"IF('3. Rate Classes'!Q24=1,'3. Rate Classes'!C24, 0)","v":"Residential"},null,{"$f":"IF(ISERROR(VLOOKUP($B26, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B26, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kWh"},null,{"$f":"VLOOKUP($B26, '11. Adj Network to Forecast WS'!$B$25:$R$48,17,0)","v":8.0017605614338839E-3},null,{"$f":"VLOOKUP($B26, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":4.2450570879094219E-3}]
[null,{"$f":"IF('3. Rate Classes'!Q25=1,'3. Rate Classes'!C25, 0)","v":"General Service Less Than 50 kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B27, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B27, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kWh"},null,{"$f":"VLOOKUP($B27, '11. Adj Network to Forecast WS'!$B$25:$R$48,17,0)","v":7.2344684528032359E-3},null,{"$f":"VLOOKUP($B27, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":4.0429115122946864E-3}]
[null,{"$f":"IF('3. Rate Classes'!Q26=1,'3. Rate Classes'!C26, 0)","v":"General Service 50 to 1,499 kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B28, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B28, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"VLOOKUP($B28, '11. Adj Network to Forecast WS'!$B$25:$R$48,17,0)","v":3.0086619710991407},null,{"$f":"VLOOKUP($B28, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":1.6116056015884697}]
[null,{"$f":"IF('3. Rate Classes'!Q27=1,'3. Rate Classes'!C27, 0)","v":"General Service 1,500 to 4,999 kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B29, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B29, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"VLOOKUP($B29, '11. Adj Network to Forecast WS'!$B$25:$R$48,17,0)","v":3.1239750137104894},null,{"$f":"VLOOKUP($B29, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":1.7222803042375365}]
[null,{"$f":"IF('3. Rate Classes'!Q28=1,'3. Rate Classes'!C28, 0)","v":"Large Use"},null,{"$f":"IF(ISERROR(VLOOKUP($B30, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B30, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"VLOOKUP($B30, '11. Adj Network to Forecast WS'!$B$25:$R$48,17,0)","v":3.4630085125668586},null,{"$f":"VLOOKUP($B30, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":1.9394857252355686}]
[null,{"$f":"IF('3. Rate Classes'!Q29=1,'3. Rate Classes'!C29, 0)","v":"Unmetered Scattered Load"},null,{"$f":"IF(ISERROR(VLOOKUP($B31, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B31, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kWh"},null,{"$f":"VLOOKUP($B31, '11. Adj Network to Forecast WS'!$B$25:$R$48,17,0)","v":7.2344684528032367E-3},null,{"$f":"VLOOKUP($B31, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":4.0429115122946873E-3}]
[null,{"$f":"IF('3. Rate Classes'!Q30=1,'3. Rate Classes'!C30, 0)","v":"Standby Power General Service 50 to 1,499 kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B32, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B32, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"VLOOKUP($B32, '11. Adj Network to Forecast WS'!$B$25:$R$48,17,0)","v":0},null,{"$f":"VLOOKUP($B32, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":0}]
[null,{"$f":"IF('3. Rate Classes'!Q31=1,'3. Rate Classes'!C31, 0)","v":"Standby Power General Service 1,500 to 4,999 kW"},null,{"$f":"IF(ISERROR(VLOOKUP($B33, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B33, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"VLOOKUP($B33, '11. Adj Network to Forecast WS'!$B$25:$R$48,17,0)","v":0},null,{"$f":"VLOOKUP($B33, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":0}]
[null,{"$f":"IF('3. Rate Classes'!Q32=1,'3. Rate Classes'!C32, 0)","v":"Standby Power General Service Large Use"},null,{"$f":"IF(ISERROR(VLOOKUP($B34, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B34, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"VLOOKUP($B34, '11. Adj Network to Forecast WS'!$B$25:$R$48,17,0)","v":0},null,{"$f":"VLOOKUP($B34, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":0}]
[null,{"$f":"IF('3. Rate Classes'!Q33=1,'3. Rate Classes'!C33, 0)","v":"Sentinel Lighting"},null,{"$f":"IF(ISERROR(VLOOKUP($B35, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B35, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"VLOOKUP($B35, '11. Adj Network to Forecast WS'!$B$25:$R$48,17,0)","v":2.2209818150105933},null,{"$f":"VLOOKUP($B35, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":1.1972071715782642}]
[null,{"$f":"IF('3. Rate Classes'!Q34=1,'3. Rate Classes'!C34, 0)","v":"Street Lighting"},null,{"$f":"IF(ISERROR(VLOOKUP($B36, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B36, '3. Rate Classes'!$C$24:$H$45,6,0))","v":"kW"},null,{"$f":"VLOOKUP($B36, '11. Adj Network to Forecast WS'!$B$25:$R$48,17,0)","v":2.2322719703233016},null,{"$f":"VLOOKUP($B36, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":1.2221721501666836}]
[null,{"$f":"IF('3. Rate Classes'!Q35=1,'3. Rate Classes'!C35, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B37, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B37, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B37, '11. Adj Network to Forecast WS'!$B$25:$R$48,17,0)","v":""},null,{"$f":"VLOOKUP($B37, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":""}]
[null,{"$f":"IF('3. Rate Classes'!Q36=1,'3. Rate Classes'!C36, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B38, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B38, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B38, '11. Adj Network to Forecast WS'!$B$25:$R$48,17,0)","v":""},null,{"$f":"VLOOKUP($B38, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":""}]
[null,{"$f":"IF('3. Rate Classes'!Q37=1,'3. Rate Classes'!C37, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B39, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B39, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B39, '11. Adj Network to Forecast WS'!$B$25:$R$48,17,0)","v":""},null,{"$f":"VLOOKUP($B39, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":""}]
[null,{"$f":"IF('3. Rate Classes'!Q38=1,'3. Rate Classes'!C38, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B40, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B40, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B40, '11. Adj Network to Forecast WS'!$B$25:$R$48,17,0)","v":""},null,{"$f":"VLOOKUP($B40, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":""}]
[null,{"$f":"IF('3. Rate Classes'!Q39=1,'3. Rate Classes'!C39, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B41, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B41, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B41, '11. Adj Network to Forecast WS'!$B$25:$R$48,17,0)","v":""},null,{"$f":"VLOOKUP($B41, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":""}]
[null,{"$f":"IF('3. Rate Classes'!Q40=1,'3. Rate Classes'!C40, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B42, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B42, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B42, '11. Adj Network to Forecast WS'!$B$25:$R$48,17,0)","v":""},null,{"$f":"VLOOKUP($B42, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":""}]
[null,{"$f":"IF('3. Rate Classes'!Q41=1,'3. Rate Classes'!C41, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B43, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B43, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B43, '11. Adj Network to Forecast WS'!$B$25:$R$48,17,0)","v":""},null,{"$f":"VLOOKUP($B43, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":""}]
[null,{"$f":"IF('3. Rate Classes'!Q42=1,'3. Rate Classes'!C42, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B44, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B44, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B44, '11. Adj Network to Forecast WS'!$B$25:$R$48,17,0)","v":""},null,{"$f":"VLOOKUP($B44, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":""}]
[null,{"$f":"IF('3. Rate Classes'!Q43=1,'3. Rate Classes'!C43, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B45, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B45, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B45, '11. Adj Network to Forecast WS'!$B$25:$R$48,17,0)","v":""},null,{"$f":"VLOOKUP($B45, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":""}]
[null,{"$f":"IF('3. Rate Classes'!Q44=1,'3. Rate Classes'!C44, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B46, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B46, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B46, '11. Adj Network to Forecast WS'!$B$25:$R$48,17,0)","v":""},null,{"$f":"VLOOKUP($B46, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":""}]
[null,{"$f":"IF('3. Rate Classes'!Q45=1,'3. Rate Classes'!C45, 0)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP($B47, '3. Rate Classes'!$C$24:$H$45,6,0)), \"\", VLOOKUP($B47, '3. Rate Classes'!$C$24:$H$45,6,0))","v":""},null,{"$f":"VLOOKUP($B47, '11. Adj Network to Forecast WS'!$B$25:$R$48,17,0)","v":""},null,{"$f":"VLOOKUP($B47, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":""}]

{"sheet":"hidden1","index":13,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[{"$f":"IF('3. Rate Classes'!Q24=1, '3. Rate Classes'!C24, \"\")","v":"Residential"},1]
[{"$f":"IF('3. Rate Classes'!Q25=1, '3. Rate Classes'!C25, \"\")","v":"General Service Less Than 50 kW"},2]
[{"$f":"IF('3. Rate Classes'!Q26=1, '3. Rate Classes'!C26, \"\")","v":"General Service 50 to 1,499 kW"},3]
[{"$f":"IF('3. Rate Classes'!Q27=1, '3. Rate Classes'!C27, \"\")","v":"General Service 1,500 to 4,999 kW"},4]
[{"$f":"IF('3. Rate Classes'!Q28=1, '3. Rate Classes'!C28, \"\")","v":"Large Use"},5]
[{"$f":"IF('3. Rate Classes'!Q29=1, '3. Rate Classes'!C29, \"\")","v":"Unmetered Scattered Load"},6]
[{"$f":"IF('3. Rate Classes'!Q30=1, '3. Rate Classes'!C30, \"\")","v":"Standby Power General Service 50 to 1,499 kW"},7]
[{"$f":"IF('3. Rate Classes'!Q31=1, '3. Rate Classes'!C31, \"\")","v":"Standby Power General Service 1,500 to 4,999 kW"},8]
[{"$f":"IF('3. Rate Classes'!Q32=1, '3. Rate Classes'!C32, \"\")","v":"Standby Power General Service Large Use"},9]
[{"$f":"IF('3. Rate Classes'!Q33=1, '3. Rate Classes'!C33, \"\")","v":"Sentinel Lighting"},10]
[{"$f":"IF('3. Rate Classes'!Q34=1, '3. Rate Classes'!C34, \"\")","v":"Street Lighting"},11]
[{"$f":"IF('3. Rate Classes'!Q35=1, '3. Rate Classes'!C35, \"\")","v":""},12]
[{"$f":"IF('3. Rate Classes'!Q36=1, '3. Rate Classes'!C36, \"\")","v":""},13]
[{"$f":"IF('3. Rate Classes'!Q37=1, '3. Rate Classes'!C37, \"\")","v":""},14]
[{"$f":"IF('3. Rate Classes'!Q38=1, '3. Rate Classes'!C38, \"\")","v":""},15]
[{"$f":"IF('3. Rate Classes'!Q39=1, '3. Rate Classes'!C39, \"\")","v":""},16]
[{"$f":"IF('3. Rate Classes'!Q40=1, '3. Rate Classes'!C40, \"\")","v":""},17]
[{"$f":"IF('3. Rate Classes'!Q41=1, '3. Rate Classes'!C41, \"\")","v":""},18]
[{"$f":"IF('3. Rate Classes'!Q42=1, '3. Rate Classes'!C42, \"\")","v":""},19]
[{"$f":"IF('3. Rate Classes'!Q43=1, '3. Rate Classes'!C43, \"\")","v":""},20]
[{"$f":"IF('3. Rate Classes'!Q44=1, '3. Rate Classes'!C44, \"\")","v":""},21]
[{"$f":"IF('3. Rate Classes'!Q45=1, '3. Rate Classes'!C45, \"\")","v":""},22]