{"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":5,"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   ","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,"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-2015-0108",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","Albert P. Singh, Vice-President Finance & CFO",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","519-888-5542",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fort 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","asingh@wnhydro.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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","2015-04-30",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",2011,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":118,"n_cols":28,"rows_kept":118,"cut":false,"hidden":false,"merged":[[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],[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],[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],[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],[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],[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],[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]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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.6E-3,null,null,2.3E-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.8999999999999999E-3,null,null,2.0999999999999999E-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 4,999 KW (less than 1,000 kW)",null,null,null,null,"kW",null,2.8420999999999998,null,null,0.8165,null,null,null,1,"C26","",null,null,null,null,null,null,null,null,"Residential Regular"]
[null,null,"Large Use",null,null,null,null,"kW",null,3.3422999999999998,null,null,1.0234000000000001,null,null,null,1,"C27","",null,null,null,null,null,null,null,null,"Residential Urban"]
[null,null,"Unmetered Scattered Load",null,null,null,null,"kWh",null,6.8999999999999999E-3,null,null,2.0999999999999999E-3,null,null,null,1,"C28","",null,null,null,null,null,null,null,null,"Residential Urban Year-Round"]
[null,null,"Street Lighting",null,null,null,null,"kW",null,2.1436999999999999,null,null,0.63100000000000001,null,null,null,1,"C29","",null,null,null,null,null,null,null,null,"Residential Suburban"]
[null,null,"Embedded Distributor",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,"General Service 50 To 4,999 KW (Interval Metered less than 1,000 kW)",null,null,null,null,"kW",null,3.0186999999999999,null,null,1.0198,null,null,null,1,"C31","",null,null,null,null,null,null,null,null,"Residential Suburban Year Round"]
[null,null,"General Service 50 To 4,999 KW (Interval Metered 1,000 to 4,999 kW)",null,null,null,null,"kW",null,3.0148000000000001,null,null,1.0186999999999999,null,null,null,1,"C32","",null,null,null,null,null,null,null,null,"Residential - Time of Use"]
[null,null,"Choose Rate Class",null,null,null,null,null,null,null,null,null,null,null,null,null,0,"C33","",null,null,null,null,null,null,null,null,"Residential - Hensall"]
[null,null,"Choose Rate Class",null,null,null,null,null,null,null,null,null,null,null,null,null,0,"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 (less 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 50 To 4,999 KW (Interval Metered less 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 50 To 4,999 KW (Interval Metered 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 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":[[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],[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],[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],[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]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,410104641.97000003,null,1.0404,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":426672869.50558805},{"$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,197096101.55000001,null,1.0404,null,"",null,{"$f":"IF(OR(H28=0, OR(ISBLANK(H28), TRIM(H28)=\"\")), F28, F28*H28)","v":205058784.05262002},{"$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 4,999 KW (less than 1,000 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,166711215.83858913,494924.32671949943,null,null,0.46168013956689163,null,166711215.83858913,494924.32671949943]
[null,{"$f":"IF('3. Rate Classes'!Q27=1,'3. Rate Classes'!C27, 0)","v":"Large Use"},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,91205251.099502489,166648.90999999997,null,null,0.75012310149930039,null,91205251.099502489,166648.90999999997]
[null,{"$f":"IF('3. Rate Classes'!Q28=1,'3. Rate Classes'!C28, 0)","v":"Unmetered Scattered Load"},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":"kWh"},null,2544974,null,1.0404,null,"",null,2647790.9495999999,0]
[null,{"$f":"IF('3. Rate Classes'!Q29=1,'3. Rate Classes'!C29, 0)","v":"Street Lighting"},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":"kW"},null,7720856.5263360236,21568.221999999994,null,null,0.49064379613186349,null,7720856.5263360236,21568.221999999994]
[null,{"$f":"IF('3. Rate Classes'!Q30=1,'3. Rate Classes'!C30, 0)","v":"Embedded Distributor"},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,31728984.630911194,72406.850000000006,null,null,{"$f":"IF(ISERROR(F33/(G33*30.4*24)), \"\", IF(D33=\"kW\", F33/(G33*30.4*24), \"\"))","v":0.60060880502617386},null,31728984.630911194,72406.850000000006]
[null,{"$f":"IF('3. Rate Classes'!Q31=1,'3. Rate Classes'!C31, 0)","v":"General Service 50 To 4,999 KW (Interval Metered less than 1,000 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,265938556.30000001,687810.83999999985,null,null,0.5299409322129115,null,265938556.30000001,687810.83999999985]
[null,{"$f":"IF('3. Rate Classes'!Q32=1,'3. Rate Classes'!C32, 0)","v":"General Service 50 To 4,999 KW (Interval Metered 1,000 to 4,999 kW)"},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,267192915.52999997,556657.26,null,null,0.65788841072768078,null,267192915.52999997,556657.26]
[null,{"$f":"IF('3. Rate Classes'!Q33=1,'3. Rate Classes'!C33, 0)","v":0},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":{"$error":"#N/A"}},null,null,null,null,null,"",null,0,0]
[null,{"$f":"IF('3. Rate Classes'!Q34=1,'3. Rate Classes'!C34, 0)","v":0},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":{"$error":"#N/A"}},null,null,null,null,null,"",null,0,0]
[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, 2013",null,"Effective January 1, 2014",null,"Effective January 1, 2015"]
[]
[null,"Rate Description",null,null,"Rate",null,"Rate",null,"Rate"]
[]
[null,"Network Service Rate","kW",null,3.63,null,3.82,null,3.78]
[]
[null,"Line Connection Service Rate","kW",null,0.75,null,0.82,null,0.86]
[]
[null,"Transformation Connection Service Rate","kW",null,1.85,null,1.98,null,2]
[]
[]
[null,"Hydro One Sub-Transmission Rates","Unit",null,"Effective January 1, 2013",null,"Effective January 1, 2014",null,"Effective January 1, 2015"]
[]
[]
[]
[null,"Rate Description",null,null,"Rate",null,"Rate",null,"Rate"]
[]
[null,"Network Service Rate","kW",null,3.18,null,3.23,null,3.23]
[]
[null,"Line Connection Service Rate","kW",null,0.7,null,0.65,null,0.65]
[]
[null,"Transformation Connection Service Rate","kW",null,1.63,null,1.62,null,1.62]
[]
[null,"Both Line and Transformation Connection Service Rate","kW",null,{"$f":"E39+E37","v":2.33},null,{"$f":"G39+G37","v":2.27},null,2.27]
[]
[]
[null,"If needed , add extra host here (I)","Unit",null,"Effective January 1, 2013",null,"Effective January 1, 2014",null,"Effective January 1, 2015"]
[]
[]
[]
[null,"Rate Description",null,null,"Rate",null,"Rate",null,"Rate"]
[]
[null,"Network Service Rate","kW",null,2.8965000000000001,null,3.0960000000000001,null,3.1105]
[]
[null,"Line Connection Service Rate","kW",null,0.63560000000000005,null,0.64610000000000001,null,0.71489999999999998]
[]
[null,"Transformation Connection Service Rate","kW"]
[]
[null,"Both Line and Transformation Connection Service Rate","kW",null,{"$f":"E54+E52","v":0.63560000000000005},null,{"$f":"G54+G52","v":0.64610000000000001},null,{"$f":"I54+I52","v":0.71489999999999998}]
[]
[]
[null,"If needed , add extra host here (II)","Unit",null,"Effective January 1, 2013",null,"Effective January 1, 2014",null,"Effective January 1, 2015"]
[]
[]
[]
[null,"Rate Description",null,null,"Rate",null,"Rate",null,"Rate"]
[]
[null,"Network Service Rate","kW",null,2.5278999999999998,null,2.7206999999999999,null,2.6534]
[]
[null,"Line Connection Service Rate","kW",null,1.6586000000000001,null,1.9124000000000001,null,1.8472999999999999]
[]
[null,"Transformation Connection Service Rate","kW"]
[]
[null,"Both Line and Transformation Connection Service Rate","kW",null,{"$f":"E69+E67","v":1.6586000000000001},null,{"$f":"G69+G67","v":1.9124000000000001},null,{"$f":"I69+I67","v":1.8472999999999999}]
[]
[]
[]
[null,"Hydro One Sub-Transmission Rate Rider 9A","Unit",null,"Effective January 1, 2013",null,"Effective January 1, 2014",null,"Effective January 1, 2015"]
[]
[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]
[]
[null,"RSVA Transmission connection – 4716 – which affects 1586","kW",null,0,null,6.6699999999999995E-2,null,0]
[]
[null,"RSVA LV – 4750 – which affects 1550","kW",null,0,null,4.7500000000000001E-2,null,0]
[]
[null,"RARA 1 – 2252 – which affects 1590 ","kW",null,0,null,4.19E-2,null,0]
[]
[null,"RARA 1 – 2252 – which affects 1590 (2008)","kW",null,0,null,-2.7E-2,null,0]
[]
[null,"RARA 1 – 2252 – which affects 1590 (2009)","kW",null,0,null,-5.9999999999999995E-4,null,0]
[]
[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}]
[]
[]
[null,null,null,null,"Historical 2013",null,"Current 2014",null,"Forecast 2015"]
[null,"Low Voltage Switchgear Credit (if applicable, enter as a negative value)","$"]

{"sheet":"6. Historical Wholesale","index":5,"n_rows":117,"n_cols":16,"rows_kept":117,"cut":false,"hidden":false,"merged":[[96,7,96,9],[96,11,96,13],[20,3,20,5],[20,7,20,9],[20,11,20,13],[96,3,96,5],[38,3,38,5],[38,7,38,9],[38,11,38,13],[95,3,95,5],[57,3,57,5],[57,7,57,9],[57,11,57,13],[76,3,76,5],[76,7,76,9],[76,11,76,13],[95,7,95,9],[95,11,95,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"IESO",null,"Network",null,null,null,"Line Connection",null,null,null,"Transformation Connection",null,null,null,"Total Line"]
[null,"Month",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Units Billed","Rate","Amount",null,"Amount"]
[]
[null,"January",null,220024.00000000003,{"$f":"IF(D24<>0,F24/D24,0)","v":0.82272061229684024},181018.28,null,220754,{"$f":"IF(H24<>0,J24/H24,0)","v":0.82},181018.28,null,24863,{"$f":"IF(L24<>0,N24/L24,0)","v":1.98},49228.74,null,{"$f":"J24+N24","v":230247.02}]
[null,"February",null,211990.00000000003,{"$f":"IF(D25<>0,F25/D25,0)","v":0.87447068257936689},185379.04,null,226072.00000000003,{"$f":"IF(H25<>0,J25/H25,0)","v":0.82},185379.04,null,24543,{"$f":"IF(L25<>0,N25/L25,0)","v":1.98},48595.14,null,233974.18]
[null,"March",null,207223,0.83310983819363671,172639.52,null,210536,0.82,172639.52,null,24558,1.9799999999999998,48624.84,null,221264.36]
[null,"April",null,177021,0.91808260036944767,162519.9,null,198195,0.82,162519.9,null,18084,1.98,35806.32,null,198326.22]
[null,"May",null,203397.00000000003,0.83895219693505785,170640.36,null,208098,0.82,170640.36,null,17649,1.9799999999999998,34945.019999999997,null,205585.37999999998]
[null,"June",null,208439,0.95134068000710037,198296.5,null,241825,0.82,198296.5,null,23043,1.98,45625.14,null,243921.64]
[null,"July",null,226964,0.84116080083184996,190913.22,null,232821.00000000003,0.82,190913.22,null,23367.000000000004,1.9799999999999998,46266.66,null,237179.88]
[null,"August",null,223330,0.8568161017328616,191352.74,null,233357,0.82,191352.74,null,23260,1.9800000000000002,46054.8,null,237407.53999999998]
[null,"September",null,235558.00000000003,0.83578328904134003,196875.44,null,240092.00000000003,0.82,196875.44,null,21051,1.9800000000000002,41680.980000000003,null,238556.42]
[null,"October",null,177750,0.88212624472573842,156797.94,null,191217,0.82000000000000006,156797.94,null,21278,1.9800000000000002,42130.44,null,198928.38]
[null,"November",null,203088.00000000003,0.85111015914283461,172850.26,null,210793.00000000003,0.82,172850.26,null,21239,1.98,42053.22,null,214903.48]
[null,"December",null,201194,0.86579013290654794,174191.78,null,212429,0.82,174191.78,null,23492.000000000004,1.9799999999999998,46514.16,null,220705.94]
[]
[null,"Total",null,{"$f":"SUM(D24:D35)","v":2495978},{"$f":"IF(D37<>0,F37/D37,0)","v":0.86277802929352743},{"$f":"SUM(F24:F35)","v":2153474.98},null,{"$f":"SUM(H24:H35)","v":2626189},{"$f":"IF(H37<>0,J37/H37,0)","v":0.82},{"$f":"SUM(J24:J35)","v":2153474.98},null,{"$f":"SUM(L24:L35)","v":266427},{"$f":"IF(L37<>0,N37/L37,0)","v":1.9799999999999998},{"$f":"SUM(N24:N35)","v":527525.46},null,{"$f":"SUM(P24:P35)","v":2681000.4399999995}]
[]
[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,9891.3100000000013,{"$f":"IF(D43<>0,F43/D43,0)","v":3.1956242398630712},31608.91,null,9933.1,{"$f":"IF(H43<>0,J43/H43,0)","v":0.68434728332544725},6797.6900000000005,null,9933.1,{"$f":"IF(L43<>0,N43/L43,0)","v":1.6268747923608944},16159.91,null,{"$f":"J43+N43","v":22957.599999999999}]
[null,"February",null,9405.2899999999991,{"$f":"IF(D44<>0,F44/D44,0)","v":3.2299982244035008},30379.07,null,9611.17,{"$f":"IF(H44<>0,J44/H44,0)","v":0.65000098843325005},6247.27,null,9611.17,{"$f":"IF(L44<>0,N44/L44,0)","v":1.6200004786097844},15570.1,null,21817.370000000003]
[null,"March",null,40811.730000000003,0.72113826098526079,29430.9,null,9428.77,0.6499988863870898,6128.6900000000005,null,9428.77,1.6199992151680442,15274.6,null,21403.29]
[null,"April",null,8516.9700000000012,3.2299972877678327,27509.79,null,8516.9700000000012,0.64999876716719673,5536.02,null,8516.9700000000012,1.6199986614958133,13797.48,null,19333.5]
[null,"May",null,7087.32,3.2299980810800131,22892.03,null,7362.79,0.6499995246367205,4785.8099999999995,null,7362.79,1.6199986689828176,11927.71,null,16713.519999999997]
[null,"June",null,6945.7000000000007,3.2299998560260303,22434.61,null,7181.2699999999995,0.64999923411875615,4667.82,null,7181.2699999999995,1.6199989695415995,11633.650000000001,null,16301.470000000001]
[null,"July",null,7739.97,3.22999830748698,25000.09,null,7922.43,0.65000132535093402,5149.59,null,7922.43,1.6200016914002395,12834.35,null,17983.940000000002]
[null,"August",null,7681.4000000000005,3.229999739630796,24810.92,null,7977.98,0.65000037603503646,5185.6899999999996,null,7977.98,1.6200003008280293,12924.33,null,18110.02]
[null,"September",null,7665.17,3.2300027266192401,24758.52,null,7739.9,0.64999935399682174,5030.93,null,7739.9,1.6200002584012714,12538.64,null,17569.57]
[null,"October",null,4806.24,3.2299989180731719,15524.150000000001,null,5143.99,0.65000126361054356,3343.6,null,5143.99,1.6200012052900572,8333.27,null,11676.87]
[null,"November",null,5228.9799999999996,3.2300180914824694,16889.7,null,5445.21,0.65000064276676195,3539.39,null,5445.21,1.6199999632704707,8821.24,null,12360.63]
[null,"December",null,6065.02,3.2299992415523775,19590.010000000002,null,6243.76,0.64999935936038544,4058.44,null,6243.76,1.6199998078081155,10114.89,null,14173.33]
[]
[null,"Total",null,{"$f":"SUM(D43:D54)","v":121845.09999999999},{"$f":"IF(D56<>0,F56/D56,0)","v":2.3868723485802881},{"$f":"SUM(F43:F54)","v":290828.7},null,{"$f":"SUM(H43:H54)","v":92507.34},{"$f":"IF(H56<>0,J56/H56,0)","v":0.65368802086407418},{"$f":"SUM(J43:J54)","v":60470.94},null,{"$f":"SUM(L43:L54)","v":92507.34},{"$f":"IF(L56<>0,N56/L56,0)","v":1.6207380949446821},{"$f":"SUM(N43:N54)","v":149930.16999999998},null,{"$f":"SUM(P43:P54)","v":210401.11}]
[]
[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,3392.59,{"$f":"IF(D62<>0,F62/D62,0)","v":2.8965009034395548},9826.64,null,3392.59,{"$f":"IF(H62<>0,J62/H62,0)","v":0.63559993986894958},2156.33,null,null,{"$f":"IF(L62<>0,N62/L62,0)","v":0},null,null,{"$f":"J62+N62","v":2156.33}]
[null,"February",null,3023.33,2.8965015396929874,8757.08,null,3023.33,0.63560048026513816,1921.63,null,null,0,null,null,1921.63]
[null,"March",null,2786.45,2.8964991297170237,8070.95,null,2921.18,0.63559931260654945,1856.7,null,null,0,null,null,1856.7]
[null,"April",null,2417.7600000000002,2.8964992389649922,7003.04,null,2417.7600000000002,0.63560072132883327,1536.73,null,null,0,null,null,1536.73]
[null,"May",null,2116.13,3.0960007182923541,6551.54,null,2116.13,0.6460992472107101,1367.23,null,null,0,null,null,1367.23]
[null,"June",null,2509.92,3.0960110282399436,7770.74,null,2509.92,0.64610027411232229,1621.66,null,null,0,null,null,1621.66]
[null,"July",null,2606.35,3.09600015347133,8069.26,null,2606.35,0.64609895063978362,1683.96,null,null,0,null,null,1683.96]
[null,"August",null,2569.39,3.0959994395556922,7954.83,null,2569.39,0.64609887950058187,1660.08,null,null,0,null,null,1660.08]
[null,"September",null,2422.2199999999998,3.0959987119254238,7499.19,null,2444.06,0.64610115954600134,1579.11,null,null,0,null,null,1579.11]
[null,"October",null,0,0,0,null,0,0,0,null,null,0,null,null,0]
[null,"November",null,4329.0200000000004,3.096000942476588,13402.65,null,4329.0200000000004,0.64610004111785113,2796.98,null,null,0,null,null,2796.98]
[null,"December",null,4281.6499999999996,3.0960003736877142,13255.99,null,4281.6499999999996,0.646099050599652,2766.37,null,null,0,null,null,2766.37]
[]
[null,"Total",null,{"$f":"SUM(D62:D73)","v":32454.809999999998},{"$f":"IF(D75<>0,F75/D75,0)","v":3.0245720125922788},{"$f":"SUM(F62:F73)","v":98161.91},null,{"$f":"SUM(H62:H73)","v":32611.380000000005},{"$f":"IF(H75<>0,J75/H75,0)","v":0.64231504462552635},{"$f":"SUM(J62:J73)","v":20946.78},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":20946.78}]
[]
[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,9368.81,{"$f":"IF(D81<>0,F81/D81,0)","v":2.5278994877684573},23683.41,null,9368.81,{"$f":"IF(H81<>0,J81/H81,0)","v":1.6586001850822039},15539.11,null,null,{"$f":"IF(L81<>0,N81/L81,0)","v":0},null,null,{"$f":"J81+N81","v":15539.11}]
[null,"February",null,8754.08,2.5279001334235005,22129.439999999999,null,8828.43,1.6585995471448489,14642.83,null,null,0,null,null,14642.83]
[null,"March",null,8403.4,2.5278994216626605,21242.95,null,8709.84,1.6585999283568928,14446.14,null,null,0,null,null,14446.14]
[null,"April",null,7627.85,2.5278997358364412,19282.439999999999,null,8006.64,1.6585996123217728,13279.81,null,null,0,null,null,13279.81]
[null,"May",null,8330.2199999999993,2.5278996232992648,21057.96,null,8330.2199999999993,1.6585996528302975,13816.5,null,null,0,null,null,13816.5]
[null,"June",null,8751.76,2.527899531065751,22123.57,null,8751.76,1.6586000987229996,14515.67,null,null,0,null,null,14515.67]
[null,"July",null,8883.15,2.5278994500824594,22455.71,null,8883.15,1.6585997084367596,14733.59,null,null,0,null,null,14733.59]
[null,"August",null,9280.9,2.7206995011259685,25250.54,null,9280.9,1.9123996595157799,17748.79,null,null,0,null,null,17748.79]
[null,"September",null,10082.66,2.720699696310299,27431.89,null,10082.66,1.9124001007670597,19282.080000000002,null,null,0,null,null,19282.080000000002]
[null,"October",null,868.1,27.166570671581614,23583.3,null,8763.9,1.9123997307134954,16760.080000000002,null,null,0,null,null,16760.080000000002]
[null,"November",null,9055.4599999999991,2.7206999975705268,24637.19,null,9055.4599999999991,1.9123998118262353,17317.66,null,null,0,null,null,17317.66]
[null,"December",null,9069.35,2.7206999399074903,24674.98,null,9069.35,1.9123994553082635,17344.22,null,null,0,null,null,17344.22]
[]
[null,"Total",null,{"$f":"SUM(D81:D92)","v":98475.74000000002},{"$f":"IF(D94<>0,F94/D94,0)","v":2.8184949917614222},{"$f":"SUM(F81:F92)","v":277553.38},null,{"$f":"SUM(H81:H92)","v":107131.12},{"$f":"IF(H94<>0,J94/H94,0)","v":1.7681741775872413},{"$f":"SUM(J81:J92)","v":189426.48000000004},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":189426.48000000004}]
[]
[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":242676.71000000002},{"$f":"IF(D100<>0,F100/D100,0)","v":1.0142598356471868},{"$f":"F24+F43+F62+F81","v":246137.24000000002},null,{"$f":"H24+H43+H62+H81","v":243448.5},{"$f":"IF(H100<>0,J100/H100,0)","v":0.84416790409470577},{"$f":"J24+J43+J62+J81","v":205511.40999999997},null,{"$f":"L24+L43+L62+L81","v":34796.1},{"$f":"IF(L100<>0,N100/L100,0)","v":1.8791947948189596},{"$f":"N24+N43+N62+N81","v":65388.649999999994},null,{"$f":"J100+N100","v":270900.05999999994}]
[null,"February",null,{"$f":"D25+D44+D63+D82","v":233172.7},1.0577766179316874,{"$f":"F25+F44+F63+F82","v":246644.63},null,{"$f":"H25+H44+H63+H82","v":247534.93000000002},0.8410561289269356,{"$f":"J25+J44+J63+J82","v":208190.77},null,{"$f":"L25+L44+L63+L82","v":34154.17},1.8786941682377292,{"$f":"N25+N44+N63+N82","v":64165.24},null,272356.01]
[null,"March",null,259224.58000000002,0.89260177410645236,231384.32000000001,null,231595.78999999998,0.84229100192192619,195071.05,null,33986.770000000004,1.8801268846671804,63899.439999999995,null,258970.49]
[null,"April",null,195583.58000000002,1.1059986221747244,216315.17,null,217136.37000000002,0.84220096338535999,182872.46,null,26600.97,1.8647365114881149,49603.8,null,232476.26]
[null,"May",null,220930.67000000004,1.0009560465280802,221141.88999999998,null,225907.14,0.84375332271481096,190609.9,null,25011.79,1.8740254096168245,46872.729999999996,null,237482.63]
[null,"June",null,226646.38000000003,1.1057993513948907,250625.41999999998,null,260267.95,0.84183108215975122,219101.65000000002,null,30224.27,1.8944639523138194,57258.79,null,276360.44]
[null,"July",null,246193.47,1.0009943805576971,246438.28,null,252232.93000000002,0.84239738245121276,212480.36,null,31289.430000000004,1.8888490458279359,59101.01,null,271581.37]
[null,"August",null,242861.69,1.026794427725509,249369.02999999997,null,253185.27000000002,0.85292205190294035,215947.3,null,31237.98,1.8880583827763513,58979.130000000005,null,274926.43]
[null,"September",null,255728.05000000005,1.0032729690778932,256565.03999999998,null,260358.62000000002,0.85561814700047178,222767.56,null,28790.9,1.8832207398865615,54219.62,null,276987.18]
[null,"October",null,183424.34,1.0680446771677083,195905.38999999998,null,205124.88999999998,0.8624093351128671,176901.62,null,26421.989999999998,1.9099132957055851,50463.710000000006,null,227365.33000000002]
[null,"November",null,221701.46000000002,1.0274167793031224,227779.80000000002,null,229622.69,0.85577035091784714,196504.29000000004,null,26684.21,1.9065379863222482,50874.46,null,247378.75000000003]
[null,"December",null,220610.02,1.0503274511284666,231712.76,null,232023.76,0.85491593619549988,198360.81,null,29735.760000000002,1.9044090347783276,56629.05,null,254989.86]
[]
[null,"Total",null,{"$f":"SUM(D100:D111)","v":2748753.65},{"$f":"IF(D113<>0,F113/D113,0)","v":1.0259264121395528},{"$f":"SUM(F100:F111)","v":2820018.9699999997},null,{"$f":"SUM(H100:H111)","v":2858438.84},{"$f":"IF(H113<>0,J113/H113,0)","v":0.84812700767807936},{"$f":"SUM(J100:J111)","v":2424319.1800000002},null,{"$f":"SUM(L100:L111)","v":358934.34},{"$f":"IF(L113<>0,N113/L113,0)","v":1.8874082373951735},{"$f":"SUM(N100:N111)","v":677455.63},null,{"$f":"SUM(P100:P111)","v":3101774.8099999996}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Low Voltage Switchgear Credit (if applicable)",null,{"$f":"'5. UTRs and Sub-Transmission'!E95","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total including deduction for Low Voltage Switchgear Credit",null,{"$f":"P113+P115","v":3101774.8099999996}]

{"sheet":"7. Current Wholesale","index":6,"n_rows":117,"n_cols":16,"rows_kept":117,"cut":false,"hidden":false,"merged":[[96,7,96,9],[96,11,96,13],[20,3,20,5],[20,7,20,9],[20,11,20,13],[96,3,96,5],[95,3,95,5],[95,7,95,9],[95,11,95,13],[57,3,57,5],[57,7,57,9],[57,11,57,13],[76,3,76,5],[76,7,76,9],[76,11,76,13],[12,1,12,11],[19,3,19,5],[19,7,19,9],[19,11,19,13],[38,3,38,5],[38,7,38,9],[38,11,38,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The purpose of this sheet is to calculate the expected billing when current 2014 Uniform Transmission Rates are applied against historical 2013 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":220024.00000000003},{"$f":"'5. UTRs and Sub-Transmission'!G22","v":3.82},{"$f":"D24*E24","v":840491.68},null,{"$f":"'6. Historical Wholesale'!H24","v":220754},{"$f":"'5. UTRs and Sub-Transmission'!G24","v":0.82},{"$f":"H24*I24","v":181018.28},null,{"$f":"'6. Historical Wholesale'!L24","v":24863},{"$f":"'5. UTRs and Sub-Transmission'!G26","v":1.98},{"$f":"L24*M24","v":49228.74},null,{"$f":"J24+N24","v":230247.02}]
[null,"February",null,{"$f":"'6. Historical Wholesale'!D25","v":211990.00000000003},{"$f":"E24","v":3.82},{"$f":"D25*E25","v":809801.8},null,{"$f":"'6. Historical Wholesale'!H25","v":226072.00000000003},{"$f":"I24","v":0.82},{"$f":"H25*I25","v":185379.04},null,{"$f":"'6. Historical Wholesale'!L25","v":24543},{"$f":"M24","v":1.98},{"$f":"L25*M25","v":48595.14},null,233974.18]
[null,"March",null,{"$f":"'6. Historical Wholesale'!D26","v":207223},{"$f":"E25","v":3.82},791591.86,null,{"$f":"'6. Historical Wholesale'!H26","v":210536},{"$f":"I25","v":0.82},172639.52,null,{"$f":"'6. Historical Wholesale'!L26","v":24558},{"$f":"M25","v":1.98},48624.84,null,221264.36]
[null,"April",null,{"$f":"'6. Historical Wholesale'!D27","v":177021},3.82,676220.22,null,{"$f":"'6. Historical Wholesale'!H27","v":198195},0.82,162519.9,null,{"$f":"'6. Historical Wholesale'!L27","v":18084},1.98,35806.32,null,198326.22]
[null,"May",null,{"$f":"'6. Historical Wholesale'!D28","v":203397.00000000003},3.82,776976.54,null,{"$f":"'6. Historical Wholesale'!H28","v":208098},0.82,170640.36,null,{"$f":"'6. Historical Wholesale'!L28","v":17649},1.98,34945.019999999997,null,205585.37999999998]
[null,"June",null,{"$f":"'6. Historical Wholesale'!D29","v":208439},3.82,796236.98,null,{"$f":"'6. Historical Wholesale'!H29","v":241825},0.82,198296.5,null,{"$f":"'6. Historical Wholesale'!L29","v":23043},1.98,45625.14,null,243921.64]
[null,"July",null,{"$f":"'6. Historical Wholesale'!D30","v":226964},3.82,867002.48,null,{"$f":"'6. Historical Wholesale'!H30","v":232821.00000000003},0.82,190913.22,null,{"$f":"'6. Historical Wholesale'!L30","v":23367.000000000004},1.98,46266.66,null,237179.88]
[null,"August",null,{"$f":"'6. Historical Wholesale'!D31","v":223330},3.82,853120.6,null,{"$f":"'6. Historical Wholesale'!H31","v":233357},0.82,191352.74,null,{"$f":"'6. Historical Wholesale'!L31","v":23260},1.98,46054.8,null,237407.53999999998]
[null,"September",null,{"$f":"'6. Historical Wholesale'!D32","v":235558.00000000003},3.82,899831.56,null,{"$f":"'6. Historical Wholesale'!H32","v":240092.00000000003},0.82,196875.44,null,{"$f":"'6. Historical Wholesale'!L32","v":21051},1.98,41680.980000000003,null,238556.42]
[null,"October",null,{"$f":"'6. Historical Wholesale'!D33","v":177750},3.82,679005,null,{"$f":"'6. Historical Wholesale'!H33","v":191217},0.82,156797.94,null,{"$f":"'6. Historical Wholesale'!L33","v":21278},1.98,42130.44,null,198928.38]
[null,"November",null,{"$f":"'6. Historical Wholesale'!D34","v":203088.00000000003},3.82,775796.16,null,{"$f":"'6. Historical Wholesale'!H34","v":210793.00000000003},0.82,172850.26,null,{"$f":"'6. Historical Wholesale'!L34","v":21239},1.98,42053.22,null,214903.48]
[null,"December",null,{"$f":"'6. Historical Wholesale'!D35","v":201194},3.82,768561.08,null,{"$f":"'6. Historical Wholesale'!H35","v":212429},0.82,174191.78,null,{"$f":"'6. Historical Wholesale'!L35","v":23492.000000000004},1.98,46514.16,null,220705.94]
[]
[null,"Total",null,{"$f":"SUM(D24:D35)","v":2495978},{"$f":"IF(D37<>0,F37/D37,0)","v":3.8200000000000003},{"$f":"SUM(F24:F35)","v":9534635.9600000009},null,{"$f":"SUM(H24:H35)","v":2626189},{"$f":"IF(H37<>0,J37/H37,0)","v":0.82},{"$f":"SUM(J24:J35)","v":2153474.98},null,{"$f":"SUM(L24:L35)","v":266427},{"$f":"IF(L37<>0,N37/L37,0)","v":1.9799999999999998},{"$f":"SUM(N24:N35)","v":527525.46},null,{"$f":"SUM(P24:P35)","v":2681000.4399999995}]
[]
[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":9891.3100000000013},{"$f":"'5. UTRs and Sub-Transmission'!G35+'5. UTRs and Sub-Transmission'!G79","v":3.3765000000000001},{"$f":"D43*E43","v":33398.008215000002},null,{"$f":"'6. Historical Wholesale'!H43","v":9933.1},{"$f":"'5. UTRs and Sub-Transmission'!G37+'5. UTRs and Sub-Transmission'!G81","v":0.7167},{"$f":"H43*I43","v":7119.0527700000002},null,{"$f":"'6. Historical Wholesale'!L43","v":9933.1},{"$f":"'5. UTRs and Sub-Transmission'!G39","v":1.62},{"$f":"L43*M43","v":16091.622000000001},null,{"$f":"J43+N43","v":23210.674770000001}]
[null,"February",null,{"$f":"'6. Historical Wholesale'!D44","v":9405.2899999999991},{"$f":"E43","v":3.3765000000000001},{"$f":"D44*E44","v":31756.961684999998},null,{"$f":"'6. Historical Wholesale'!H44","v":9611.17},{"$f":"I43","v":0.7167},{"$f":"H44*I44","v":6888.3255390000004},null,{"$f":"'6. Historical Wholesale'!L44","v":9611.17},{"$f":"M43","v":1.62},{"$f":"L44*M44","v":15570.095400000002},null,22458.420939000003]
[null,"March",null,{"$f":"'6. Historical Wholesale'!D45","v":40811.730000000003},{"$f":"E44","v":3.3765000000000001},137800.80634500002,null,{"$f":"'6. Historical Wholesale'!H45","v":9428.77},{"$f":"I44","v":0.7167},6757.599459,null,{"$f":"'6. Historical Wholesale'!L45","v":9428.77},{"$f":"M44","v":1.62},15274.607400000003,null,22032.206859000002]
[null,"April",null,{"$f":"'6. Historical Wholesale'!D46","v":8516.9700000000012},3.3765000000000001,28757.549205000003,null,{"$f":"'6. Historical Wholesale'!H46","v":8516.9700000000012},0.7167,6104.1123990000006,null,{"$f":"'6. Historical Wholesale'!L46","v":8516.9700000000012},{"$f":"M45","v":1.62},13797.491400000003,null,19901.603799000004]
[null,"May",null,{"$f":"'6. Historical Wholesale'!D47","v":7087.32},3.3765000000000001,23930.33598,null,{"$f":"'6. Historical Wholesale'!H47","v":7362.79},0.7167,5276.9115929999998,null,{"$f":"'6. Historical Wholesale'!L47","v":7362.79},1.62,11927.719800000001,null,17204.631393]
[null,"June",null,{"$f":"'6. Historical Wholesale'!D48","v":6945.7000000000007},3.3765000000000001,23452.156050000001,null,{"$f":"'6. Historical Wholesale'!H48","v":7181.2699999999995},0.7167,5146.8162089999996,null,{"$f":"'6. Historical Wholesale'!L48","v":7181.2699999999995},1.62,11633.6574,null,16780.473609000001]
[null,"July",null,{"$f":"'6. Historical Wholesale'!D49","v":7739.97},3.3765000000000001,26134.008705,null,{"$f":"'6. Historical Wholesale'!H49","v":7922.43},0.7167,5678.0055810000003,null,{"$f":"'6. Historical Wholesale'!L49","v":7922.43},1.62,12834.336600000001,null,18512.342181]
[null,"August",null,{"$f":"'6. Historical Wholesale'!D50","v":7681.4000000000005},3.3765000000000001,25936.247100000001,null,{"$f":"'6. Historical Wholesale'!H50","v":7977.98},0.7167,5717.8182659999993,null,{"$f":"'6. Historical Wholesale'!L50","v":7977.98},1.62,12924.327600000001,null,18642.145865999999]
[null,"September",null,{"$f":"'6. Historical Wholesale'!D51","v":7665.17},3.3765000000000001,25881.446505,null,{"$f":"'6. Historical Wholesale'!H51","v":7739.9},0.7167,5547.1863299999995,null,{"$f":"'6. Historical Wholesale'!L51","v":7739.9},1.62,12538.638000000001,null,18085.824329999999]
[null,"October",null,{"$f":"'6. Historical Wholesale'!D52","v":4806.24},3.3765000000000001,16228.26936,null,{"$f":"'6. Historical Wholesale'!H52","v":5143.99},0.7167,3686.6976329999998,null,{"$f":"'6. Historical Wholesale'!L52","v":5143.99},1.62,8333.2638000000006,null,12019.961433]
[null,"November",null,{"$f":"'6. Historical Wholesale'!D53","v":5228.9799999999996},3.3765000000000001,17655.650969999999,null,{"$f":"'6. Historical Wholesale'!H53","v":5445.21},0.7167,3902.582007,null,{"$f":"'6. Historical Wholesale'!L53","v":5445.21},1.62,8821.2402000000002,null,12723.822207000001]
[null,"December",null,{"$f":"'6. Historical Wholesale'!D54","v":6065.02},3.3765000000000001,20478.54003,null,{"$f":"'6. Historical Wholesale'!H54","v":6243.76},0.7167,4474.9027919999999,null,{"$f":"'6. Historical Wholesale'!L54","v":6243.76},1.62,10114.891200000002,null,14589.793992000003]
[]
[null,"Total",null,{"$f":"SUM(D43:D54)","v":121845.09999999999},{"$f":"IF(D56<>0,F56/D56,0)","v":3.3765000000000001},{"$f":"SUM(F43:F54)","v":411409.98014999996},null,{"$f":"SUM(H43:H54)","v":92507.34},{"$f":"IF(H56<>0,J56/H56,0)","v":0.7167},{"$f":"SUM(J43:J54)","v":66300.010578000001},null,{"$f":"SUM(L43:L54)","v":92507.34},{"$f":"IF(L56<>0,N56/L56,0)","v":1.6200000000000003},{"$f":"SUM(N43:N54)","v":149861.89080000002},null,{"$f":"SUM(P43:P54)","v":216161.90137799998}]
[]
[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":3392.59},{"$f":"'5. UTRs and Sub-Transmission'!G50","v":3.0960000000000001},{"$f":"D62*E62","v":10503.458640000001},null,{"$f":"'6. Historical Wholesale'!H62","v":3392.59},{"$f":"'5. UTRs and Sub-Transmission'!G52","v":0.64610000000000001},{"$f":"H62*I62","v":2191.9523990000002},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":2191.9523990000002}]
[null,"February",null,{"$f":"'6. Historical Wholesale'!D63","v":3023.33},{"$f":"E62","v":3.0960000000000001},{"$f":"D63*E63","v":9360.2296800000004},null,{"$f":"'6. Historical Wholesale'!H63","v":3023.33},{"$f":"I62","v":0.64610000000000001},{"$f":"H63*I63","v":1953.373513},null,{"$f":"'6. Historical Wholesale'!L63","v":0},{"$f":"M62","v":0},{"$f":"L63*M63","v":0},null,1953.373513]
[null,"March",null,{"$f":"'6. Historical Wholesale'!D64","v":2786.45},{"$f":"E63","v":3.0960000000000001},8626.8492000000006,null,{"$f":"'6. Historical Wholesale'!H64","v":2921.18},{"$f":"I63","v":0.64610000000000001},1887.3743979999999,null,{"$f":"'6. Historical Wholesale'!L64","v":0},{"$f":"M63","v":0},0,null,1887.3743979999999]
[null,"April",null,{"$f":"'6. Historical Wholesale'!D65","v":2417.7600000000002},3.0960000000000001,7485.3849600000012,null,{"$f":"'6. Historical Wholesale'!H65","v":2417.7600000000002},0.64610000000000001,1562.1147360000002,null,{"$f":"'6. Historical Wholesale'!L65","v":0},{"$f":"M64","v":0},0,null,1562.1147360000002]
[null,"May",null,{"$f":"'6. Historical Wholesale'!D66","v":2116.13},3.0960000000000001,6551.5384800000002,null,{"$f":"'6. Historical Wholesale'!H66","v":2116.13},0.64610000000000001,1367.231593,null,{"$f":"'6. Historical Wholesale'!L66","v":0},0,0,null,1367.231593]
[null,"June",null,{"$f":"'6. Historical Wholesale'!D67","v":2509.92},3.0960000000000001,7770.7123200000005,null,{"$f":"'6. Historical Wholesale'!H67","v":2509.92},0.64610000000000001,1621.659312,null,{"$f":"'6. Historical Wholesale'!L67","v":0},0,0,null,1621.659312]
[null,"July",null,{"$f":"'6. Historical Wholesale'!D68","v":2606.35},3.0960000000000001,8069.2596000000003,null,{"$f":"'6. Historical Wholesale'!H68","v":2606.35},0.64610000000000001,1683.9627350000001,null,{"$f":"'6. Historical Wholesale'!L68","v":0},0,0,null,1683.9627350000001]
[null,"August",null,{"$f":"'6. Historical Wholesale'!D69","v":2569.39},3.0960000000000001,7954.8314399999999,null,{"$f":"'6. Historical Wholesale'!H69","v":2569.39},0.64610000000000001,1660.082879,null,{"$f":"'6. Historical Wholesale'!L69","v":0},0,0,null,1660.082879]
[null,"September",null,{"$f":"'6. Historical Wholesale'!D70","v":2422.2199999999998},3.0960000000000001,7499.1931199999999,null,{"$f":"'6. Historical Wholesale'!H70","v":2444.06},0.64610000000000001,1579.107166,null,{"$f":"'6. Historical Wholesale'!L70","v":0},0,0,null,1579.107166]
[null,"October",null,{"$f":"'6. Historical Wholesale'!D71","v":0},3.0960000000000001,0,null,{"$f":"'6. Historical Wholesale'!H71","v":0},0.64610000000000001,0,null,{"$f":"'6. Historical Wholesale'!L71","v":0},0,0,null,0]
[null,"November",null,{"$f":"'6. Historical Wholesale'!D72","v":4329.0200000000004},3.0960000000000001,13402.645920000001,null,{"$f":"'6. Historical Wholesale'!H72","v":4329.0200000000004},0.64610000000000001,2796.9798220000002,null,{"$f":"'6. Historical Wholesale'!L72","v":0},0,0,null,2796.9798220000002]
[null,"December",null,{"$f":"'6. Historical Wholesale'!D73","v":4281.6499999999996},3.0960000000000001,13255.988399999998,null,{"$f":"'6. Historical Wholesale'!H73","v":4281.6499999999996},0.64610000000000001,2766.374065,null,{"$f":"'6. Historical Wholesale'!L73","v":0},0,0,null,2766.374065]
[]
[null,"Total",null,{"$f":"SUM(D62:D73)","v":32454.809999999998},{"$f":"IF(D75<>0,F75/D75,0)","v":3.0960000000000001},{"$f":"SUM(F62:F73)","v":100480.09176},null,{"$f":"SUM(H62:H73)","v":32611.380000000005},{"$f":"IF(H75<>0,J75/H75,0)","v":0.6460999999999999},{"$f":"SUM(J62:J73)","v":21070.212618000001},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":21070.212618000001}]
[]
[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":9368.81},{"$f":"'5. UTRs and Sub-Transmission'!G65","v":2.7206999999999999},{"$f":"D81*E81","v":25489.721366999998},null,{"$f":"'6. Historical Wholesale'!H81","v":9368.81},{"$f":"'5. UTRs and Sub-Transmission'!G67","v":1.9124000000000001},{"$f":"H81*I81","v":17916.912243999999},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":17916.912243999999}]
[null,"February",null,{"$f":"'6. Historical Wholesale'!D82","v":8754.08},{"$f":"E81","v":2.7206999999999999},{"$f":"D82*E82","v":23817.225456},null,{"$f":"'6. Historical Wholesale'!H82","v":8828.43},{"$f":"I81","v":1.9124000000000001},{"$f":"H82*I82","v":16883.489532000003},null,{"$f":"'6. Historical Wholesale'!L82","v":0},{"$f":"M81","v":0},{"$f":"L82*M82","v":0},null,16883.489532000003]
[null,"March",null,{"$f":"'6. Historical Wholesale'!D83","v":8403.4},{"$f":"E82","v":2.7206999999999999},22863.130379999999,null,{"$f":"'6. Historical Wholesale'!H83","v":8709.84},{"$f":"I82","v":1.9124000000000001},16656.698016000002,null,{"$f":"'6. Historical Wholesale'!L83","v":0},{"$f":"M82","v":0},0,null,16656.698016000002]
[null,"April",null,{"$f":"'6. Historical Wholesale'!D84","v":7627.85},2.7206999999999999,20753.091495000001,null,{"$f":"'6. Historical Wholesale'!H84","v":8006.64},1.9124000000000001,15311.898336000002,null,{"$f":"'6. Historical Wholesale'!L84","v":0},{"$f":"M83","v":0},0,null,15311.898336000002]
[null,"May",null,{"$f":"'6. Historical Wholesale'!D85","v":8330.2199999999993},2.7206999999999999,22664.029553999997,null,{"$f":"'6. Historical Wholesale'!H85","v":8330.2199999999993},1.9124000000000001,15930.712728,null,{"$f":"'6. Historical Wholesale'!L85","v":0},0,0,null,15930.712728]
[null,"June",null,{"$f":"'6. Historical Wholesale'!D86","v":8751.76},2.7206999999999999,23810.913432000001,null,{"$f":"'6. Historical Wholesale'!H86","v":8751.76},1.9124000000000001,16736.865824,null,{"$f":"'6. Historical Wholesale'!L86","v":0},0,0,null,16736.865824]
[null,"July",null,{"$f":"'6. Historical Wholesale'!D87","v":8883.15},2.7206999999999999,24168.386204999999,null,{"$f":"'6. Historical Wholesale'!H87","v":8883.15},1.9124000000000001,16988.136060000001,null,{"$f":"'6. Historical Wholesale'!L87","v":0},0,0,null,16988.136060000001]
[null,"August",null,{"$f":"'6. Historical Wholesale'!D88","v":9280.9},2.7206999999999999,25250.544629999997,null,{"$f":"'6. Historical Wholesale'!H88","v":9280.9},1.9124000000000001,17748.793160000001,null,{"$f":"'6. Historical Wholesale'!L88","v":0},0,0,null,17748.793160000001]
[null,"September",null,{"$f":"'6. Historical Wholesale'!D89","v":10082.66},2.7206999999999999,27431.893061999999,null,{"$f":"'6. Historical Wholesale'!H89","v":10082.66},1.9124000000000001,19282.078984,null,{"$f":"'6. Historical Wholesale'!L89","v":0},0,0,null,19282.078984]
[null,"October",null,{"$f":"'6. Historical Wholesale'!D90","v":868.1},2.7206999999999999,2361.8396699999998,null,{"$f":"'6. Historical Wholesale'!H90","v":8763.9},1.9124000000000001,16760.08236,null,{"$f":"'6. Historical Wholesale'!L90","v":0},0,0,null,16760.08236]
[null,"November",null,{"$f":"'6. Historical Wholesale'!D91","v":9055.4599999999991},2.7206999999999999,24637.190021999995,null,{"$f":"'6. Historical Wholesale'!H91","v":9055.4599999999991},1.9124000000000001,17317.661703999998,null,{"$f":"'6. Historical Wholesale'!L91","v":0},0,0,null,17317.661703999998]
[null,"December",null,{"$f":"'6. Historical Wholesale'!D92","v":9069.35},2.7206999999999999,24674.980544999999,null,{"$f":"'6. Historical Wholesale'!H92","v":9069.35},1.9124000000000001,17344.22494,null,{"$f":"'6. Historical Wholesale'!L92","v":0},0,0,null,17344.22494]
[]
[null,"Total",null,{"$f":"SUM(D81:D92)","v":98475.74000000002},{"$f":"IF(D94<>0,F94/D94,0)","v":2.720699999999999},{"$f":"SUM(F81:F92)","v":267922.94581799995},null,{"$f":"SUM(H81:H92)","v":107131.12},{"$f":"IF(H94<>0,J94/H94,0)","v":1.9123999999999997},{"$f":"SUM(J81:J92)","v":204877.55388799997},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":204877.55388799997}]
[]
[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":242676.71000000002},{"$f":"IF(D100<>0,F100/D100,0)","v":3.7493621378911888},{"$f":"F24+F43+F62+F81","v":909882.86822200008},null,{"$f":"H24+H43+H62+H81","v":243448.5},{"$f":"IF(H100<>0,J100/H100,0)","v":0.85540143978295213},{"$f":"J24+J43+J62+J81","v":208246.19741300002},null,{"$f":"L24+L43+L62+L81","v":34796.1},{"$f":"IF(L100<>0,N100/L100,0)","v":1.8772322760309346},{"$f":"N24+N43+N62+N81","v":65320.362000000001},null,{"$f":"J100+N100","v":273566.55941300001}]
[null,"February",null,{"$f":"D25+D44+D63+D82","v":233172.7},3.751452107476561,{"$f":"F25+F44+F63+F82","v":874736.21682099998},null,{"$f":"H25+H44+H63+H82","v":247534.93000000002},0.85282601766142663,{"$f":"J25+J44+J63+J82","v":211104.22858400003},null,{"$f":"L25+L44+L63+L82","v":34154.17},1.8786940335543216,{"$f":"N25+N44+N63+N82","v":64165.235400000005},null,275269.46398400003]
[null,"March",null,259224.58000000002,3.7067574607508287,960882.64592500008,null,231595.78999999998,0.85468389504403341,197941.19187299997,null,33986.770000000004,1.8801271023989625,63899.447399999997,null,261840.63927299998]
[null,"April",null,195583.58000000002,3.7488640184416298,733216.24566000002,null,217136.37000000002,0.85429274455955939,185498.025471,null,26600.97,1.8647369400439158,49603.811400000006,null,235101.83687100001]
[null,"May",null,220930.67000000004,3.7573888859070577,830122.44401400001,null,225907.14,0.85528600784375375,193215.215914,null,25011.79,1.8740258014320443,46872.739799999996,null,240087.95571399998]
[null,"June",null,226646.38000000003,3.7559424589177195,851270.76180199999,null,260267.95,0.85220574160206819,221801.84134500002,null,30224.27,1.8944641971501708,57258.797399999996,null,279060.638745]
[null,"July",null,246193.47,3.7587273720541816,925374.13451,null,252232.93000000002,0.85343069351016132,215263.324376,null,31289.430000000004,1.888848617568297,59100.996600000006,null,274364.32097599999]
[null,"August",null,242861.69,3.7563035288521629,912262.22317000001,null,253185.27000000002,0.8550238104491622,216479.43430499997,null,31237.98,1.8880583059467997,58979.127600000007,null,275458.56190500001]
[null,"September",null,255728.05000000005,3.7565065415663237,960644.09268700005,null,260358.62000000002,0.85760099849968463,223283.81247999999,null,28790.9,1.8832206704201675,54219.618000000002,null,277503.43047999998]
[null,"October",null,183424.34,3.8031763343403613,697595.10903000005,null,205124.88999999998,0.86408197461068725,177244.71999300001,null,26421.989999999998,1.9099130610525554,50463.703800000003,null,227708.42379299999]
[null,"November",null,221701.46000000002,3.7505014487139596,831491.64691200003,null,229622.69,0.85735204797487563,196867.48353299999,null,26684.21,1.9065379938173175,50874.460200000001,null,247741.94373299999]
[null,"December",null,220610.02,3.7485631385872682,826970.58897499996,null,232023.76,0.85671088942356599,198777.28179700003,null,29735.760000000002,1.9044090751337783,56629.051200000002,null,255406.33299700002]
[]
[null,"Total",null,{"$f":"SUM(D100:D111)","v":2748753.65},{"$f":"IF(D113<>0,F113/D113,0)","v":3.7524093793301558},{"$f":"SUM(F100:F111)","v":10314448.977728},null,{"$f":"SUM(H100:H111)","v":2858438.84},{"$f":"IF(H113<>0,J113/H113,0)","v":0.85561486321113678},{"$f":"SUM(J100:J111)","v":2445722.7570840004},null,{"$f":"SUM(L100:L111)","v":358934.34},{"$f":"IF(L113<>0,N113/L113,0)","v":1.8872180098454774},{"$f":"SUM(N100:N111)","v":677387.35080000001},null,{"$f":"SUM(P100:P111)","v":3123110.1078840005}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Low Voltage Switchgear Credit (if applicable)",null,{"$f":"'5. UTRs and Sub-Transmission'!G95","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total including deduction for Low Voltage Switchgear Credit",null,{"$f":"P113+P115","v":3123110.1078840005}]

{"sheet":"8. Forecast Wholesale","index":7,"n_rows":117,"n_cols":16,"rows_kept":117,"cut":false,"hidden":false,"merged":[[96,7,96,9],[96,11,96,13],[20,3,20,5],[20,7,20,9],[20,11,20,13],[96,3,96,5],[95,3,95,5],[95,7,95,9],[95,11,95,13],[57,3,57,5],[57,7,57,9],[57,11,57,13],[76,3,76,5],[76,7,76,9],[76,11,76,13],[12,1,12,12],[19,3,19,5],[19,7,19,9],[19,11,19,13],[38,3,38,5],[38,7,38,9],[38,11,38,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The purpose of this sheet is to calculate the expected billing when forecasted 2015 Uniform Transmission Rates are applied against historical 2013 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":220024.00000000003},{"$f":"'5. UTRs and Sub-Transmission'!I22","v":3.78},{"$f":"D24*E24","v":831690.72000000009},null,{"$f":"'6. Historical Wholesale'!H24","v":220754},{"$f":"'5. UTRs and Sub-Transmission'!I24","v":0.86},{"$f":"H24*I24","v":189848.44},null,{"$f":"'6. Historical Wholesale'!L24","v":24863},{"$f":"'5. UTRs and Sub-Transmission'!I26","v":2},{"$f":"L24*M24","v":49726},null,{"$f":"J24+N24","v":239574.44}]
[null,"February",null,{"$f":"'6. Historical Wholesale'!D25","v":211990.00000000003},{"$f":"E24","v":3.78},801322.20000000007,null,{"$f":"'6. Historical Wholesale'!H25","v":226072.00000000003},{"$f":"I24","v":0.86},194421.92,null,{"$f":"'6. Historical Wholesale'!L25","v":24543},{"$f":"M24","v":2},49086,null,243507.92]
[null,"March",null,{"$f":"'6. Historical Wholesale'!D26","v":207223},3.78,783302.94,null,{"$f":"'6. Historical Wholesale'!H26","v":210536},0.86,181060.96,null,{"$f":"'6. Historical Wholesale'!L26","v":24558},2,49116,null,230176.96]
[null,"April",null,{"$f":"'6. Historical Wholesale'!D27","v":177021},3.78,669139.38,null,{"$f":"'6. Historical Wholesale'!H27","v":198195},0.86,170447.7,null,{"$f":"'6. Historical Wholesale'!L27","v":18084},2,36168,null,206615.7]
[null,"May",null,{"$f":"'6. Historical Wholesale'!D28","v":203397.00000000003},3.78,768840.66,null,{"$f":"'6. Historical Wholesale'!H28","v":208098},0.86,178964.28,null,{"$f":"'6. Historical Wholesale'!L28","v":17649},2,35298,null,214262.28]
[null,"June",null,{"$f":"'6. Historical Wholesale'!D29","v":208439},3.78,787899.41999999993,null,{"$f":"'6. Historical Wholesale'!H29","v":241825},0.86,207969.5,null,{"$f":"'6. Historical Wholesale'!L29","v":23043},2,46086,null,254055.5]
[null,"July",null,{"$f":"'6. Historical Wholesale'!D30","v":226964},3.78,857923.91999999993,null,{"$f":"'6. Historical Wholesale'!H30","v":232821.00000000003},0.86,200226.06000000003,null,{"$f":"'6. Historical Wholesale'!L30","v":23367.000000000004},2,46734.000000000007,null,246960.06000000003]
[null,"August",null,{"$f":"'6. Historical Wholesale'!D31","v":223330},3.78,844187.39999999991,null,{"$f":"'6. Historical Wholesale'!H31","v":233357},0.86,200687.02,null,{"$f":"'6. Historical Wholesale'!L31","v":23260},2,46520,null,247207.02]
[null,"September",null,{"$f":"'6. Historical Wholesale'!D32","v":235558.00000000003},3.78,890409.24000000011,null,{"$f":"'6. Historical Wholesale'!H32","v":240092.00000000003},0.86,206479.12000000002,null,{"$f":"'6. Historical Wholesale'!L32","v":21051},2,42102,null,248581.12000000002]
[null,"October",null,{"$f":"'6. Historical Wholesale'!D33","v":177750},3.78,671895,null,{"$f":"'6. Historical Wholesale'!H33","v":191217},0.86,164446.62,null,{"$f":"'6. Historical Wholesale'!L33","v":21278},2,42556,null,207002.62]
[null,"November",null,{"$f":"'6. Historical Wholesale'!D34","v":203088.00000000003},3.78,767672.64,null,{"$f":"'6. Historical Wholesale'!H34","v":210793.00000000003},0.86,181281.98,null,{"$f":"'6. Historical Wholesale'!L34","v":21239},2,42478,null,223759.98]
[null,"December",null,{"$f":"'6. Historical Wholesale'!D35","v":201194},3.78,760513.32,null,{"$f":"'6. Historical Wholesale'!H35","v":212429},0.86,182688.94,null,{"$f":"'6. Historical Wholesale'!L35","v":23492.000000000004},2,46984.000000000007,null,229672.94]
[]
[null,"Total",null,{"$f":"SUM(D24:D35)","v":2495978},{"$f":"IF(D37<>0,F37/D37,0)","v":3.7800000000000007},{"$f":"SUM(F24:F35)","v":9434796.8400000017},null,{"$f":"SUM(H24:H35)","v":2626189},{"$f":"IF(H37<>0,J37/H37,0)","v":0.86},{"$f":"SUM(J24:J35)","v":2258522.54},null,{"$f":"SUM(L24:L35)","v":266427},{"$f":"IF(L37<>0,N37/L37,0)","v":2},{"$f":"SUM(N24:N35)","v":532854},null,{"$f":"SUM(P24:P35)","v":2791376.54}]
[]
[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":9891.3100000000013},{"$f":"'5. UTRs and Sub-Transmission'!I35+'5. UTRs and Sub-Transmission'!I79","v":3.23},{"$f":"D43*E43","v":31948.931300000004},null,{"$f":"'6. Historical Wholesale'!H43","v":9933.1},{"$f":"'5. UTRs and Sub-Transmission'!I37+'5. UTRs and Sub-Transmission'!I81","v":0.65},{"$f":"H43*I43","v":6456.5150000000003},null,{"$f":"'6. Historical Wholesale'!L43","v":9933.1},{"$f":"'5. UTRs and Sub-Transmission'!I39","v":1.62},{"$f":"L43*M43","v":16091.622000000001},null,{"$f":"J43+N43","v":22548.137000000002}]
[null,"February",null,{"$f":"'6. Historical Wholesale'!D44","v":9405.2899999999991},{"$f":"E43","v":3.23},30379.086699999996,null,{"$f":"'6. Historical Wholesale'!H44","v":9611.17},{"$f":"I43","v":0.65},6247.2605000000003,null,{"$f":"'6. Historical Wholesale'!L44","v":9611.17},{"$f":"M43","v":1.62},15570.095400000002,null,21817.355900000002]
[null,"March",null,{"$f":"'6. Historical Wholesale'!D45","v":40811.730000000003},3.23,131821.8879,null,{"$f":"'6. Historical Wholesale'!H45","v":9428.77},0.65,6128.7005000000008,null,{"$f":"'6. Historical Wholesale'!L45","v":9428.77},1.62,15274.607400000003,null,21403.307900000003]
[null,"April",null,{"$f":"'6. Historical Wholesale'!D46","v":8516.9700000000012},3.23,27509.813100000003,null,{"$f":"'6. Historical Wholesale'!H46","v":8516.9700000000012},0.65,5536.0305000000008,null,{"$f":"'6. Historical Wholesale'!L46","v":8516.9700000000012},1.62,13797.491400000003,null,19333.521900000003]
[null,"May",null,{"$f":"'6. Historical Wholesale'!D47","v":7087.32},3.23,22892.043599999997,null,{"$f":"'6. Historical Wholesale'!H47","v":7362.79},0.65,4785.8135000000002,null,{"$f":"'6. Historical Wholesale'!L47","v":7362.79},1.62,11927.719800000001,null,16713.533300000003]
[null,"June",null,{"$f":"'6. Historical Wholesale'!D48","v":6945.7000000000007},3.23,22434.611000000001,null,{"$f":"'6. Historical Wholesale'!H48","v":7181.2699999999995},0.65,4667.8254999999999,null,{"$f":"'6. Historical Wholesale'!L48","v":7181.2699999999995},1.62,11633.6574,null,16301.482899999999]
[null,"July",null,{"$f":"'6. Historical Wholesale'!D49","v":7739.97},3.23,25000.1031,null,{"$f":"'6. Historical Wholesale'!H49","v":7922.43},0.65,5149.5795000000007,null,{"$f":"'6. Historical Wholesale'!L49","v":7922.43},1.62,12834.336600000001,null,17983.916100000002]
[null,"August",null,{"$f":"'6. Historical Wholesale'!D50","v":7681.4000000000005},3.23,24810.922000000002,null,{"$f":"'6. Historical Wholesale'!H50","v":7977.98},0.65,5185.6869999999999,null,{"$f":"'6. Historical Wholesale'!L50","v":7977.98},1.62,12924.327600000001,null,18110.014600000002]
[null,"September",null,{"$f":"'6. Historical Wholesale'!D51","v":7665.17},3.23,24758.499100000001,null,{"$f":"'6. Historical Wholesale'!H51","v":7739.9},0.65,5030.9349999999995,null,{"$f":"'6. Historical Wholesale'!L51","v":7739.9},1.62,12538.638000000001,null,17569.573]
[null,"October",null,{"$f":"'6. Historical Wholesale'!D52","v":4806.24},3.23,15524.155199999999,null,{"$f":"'6. Historical Wholesale'!H52","v":5143.99},0.65,3343.5934999999999,null,{"$f":"'6. Historical Wholesale'!L52","v":5143.99},1.62,8333.2638000000006,null,11676.8573]
[null,"November",null,{"$f":"'6. Historical Wholesale'!D53","v":5228.9799999999996},3.23,16889.605399999997,null,{"$f":"'6. Historical Wholesale'!H53","v":5445.21},0.65,3539.3865000000001,null,{"$f":"'6. Historical Wholesale'!L53","v":5445.21},1.62,8821.2402000000002,null,12360.626700000001]
[null,"December",null,{"$f":"'6. Historical Wholesale'!D54","v":6065.02},3.23,19590.014600000002,null,{"$f":"'6. Historical Wholesale'!H54","v":6243.76},0.65,4058.4440000000004,null,{"$f":"'6. Historical Wholesale'!L54","v":6243.76},1.62,10114.891200000002,null,14173.335200000001]
[]
[null,"Total",null,{"$f":"SUM(D43:D54)","v":121845.09999999999},{"$f":"IF(D56<>0,F56/D56,0)","v":3.2300000000000004},{"$f":"SUM(F43:F54)","v":393559.67300000001},null,{"$f":"SUM(H43:H54)","v":92507.34},{"$f":"IF(H56<>0,J56/H56,0)","v":0.65000000000000013},{"$f":"SUM(J43:J54)","v":60129.771000000008},null,{"$f":"SUM(L43:L54)","v":92507.34},{"$f":"IF(L56<>0,N56/L56,0)","v":1.6200000000000003},{"$f":"SUM(N43:N54)","v":149861.89080000002},null,{"$f":"SUM(P43:P54)","v":209991.66180000003}]
[]
[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":3392.59},{"$f":"'5. UTRs and Sub-Transmission'!I50","v":3.1105},{"$f":"D62*E62","v":10552.651195},null,{"$f":"'6. Historical Wholesale'!H62","v":3392.59},{"$f":"'5. UTRs and Sub-Transmission'!I52","v":0.71489999999999998},{"$f":"H62*I62","v":2425.3625910000001},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":2425.3625910000001}]
[null,"February",null,{"$f":"'6. Historical Wholesale'!D63","v":3023.33},{"$f":"E62","v":3.1105},9404.0679650000002,null,{"$f":"'6. Historical Wholesale'!H63","v":3023.33},{"$f":"I62","v":0.71489999999999998},2161.3786169999998,null,{"$f":"'6. Historical Wholesale'!L63","v":0},{"$f":"M62","v":0},0,null,2161.3786169999998]
[null,"March",null,{"$f":"'6. Historical Wholesale'!D64","v":2786.45},3.1105,8667.2527250000003,null,{"$f":"'6. Historical Wholesale'!H64","v":2921.18},0.71489999999999998,2088.3515819999998,null,{"$f":"'6. Historical Wholesale'!L64","v":0},0,0,null,2088.3515819999998]
[null,"April",null,{"$f":"'6. Historical Wholesale'!D65","v":2417.7600000000002},3.1105,7520.4424800000006,null,{"$f":"'6. Historical Wholesale'!H65","v":2417.7600000000002},0.71489999999999998,1728.4566240000001,null,{"$f":"'6. Historical Wholesale'!L65","v":0},0,0,null,1728.4566240000001]
[null,"May",null,{"$f":"'6. Historical Wholesale'!D66","v":2116.13},3.1105,6582.2223650000005,null,{"$f":"'6. Historical Wholesale'!H66","v":2116.13},0.71489999999999998,1512.8213370000001,null,{"$f":"'6. Historical Wholesale'!L66","v":0},0,0,null,1512.8213370000001]
[null,"June",null,{"$f":"'6. Historical Wholesale'!D67","v":2509.92},3.1105,7807.1061600000003,null,{"$f":"'6. Historical Wholesale'!H67","v":2509.92},0.71489999999999998,1794.3418079999999,null,{"$f":"'6. Historical Wholesale'!L67","v":0},0,0,null,1794.3418079999999]
[null,"July",null,{"$f":"'6. Historical Wholesale'!D68","v":2606.35},3.1105,8107.0516749999997,null,{"$f":"'6. Historical Wholesale'!H68","v":2606.35},0.71489999999999998,1863.2796149999999,null,{"$f":"'6. Historical Wholesale'!L68","v":0},0,0,null,1863.2796149999999]
[null,"August",null,{"$f":"'6. Historical Wholesale'!D69","v":2569.39},3.1105,7992.087595,null,{"$f":"'6. Historical Wholesale'!H69","v":2569.39},0.71489999999999998,1836.8569109999999,null,{"$f":"'6. Historical Wholesale'!L69","v":0},0,0,null,1836.8569109999999]
[null,"September",null,{"$f":"'6. Historical Wholesale'!D70","v":2422.2199999999998},3.1105,7534.315309999999,null,{"$f":"'6. Historical Wholesale'!H70","v":2444.06},0.71489999999999998,1747.2584939999999,null,{"$f":"'6. Historical Wholesale'!L70","v":0},0,0,null,1747.2584939999999]
[null,"October",null,{"$f":"'6. Historical Wholesale'!D71","v":0},3.1105,0,null,{"$f":"'6. Historical Wholesale'!H71","v":0},0.71489999999999998,0,null,{"$f":"'6. Historical Wholesale'!L71","v":0},0,0,null,0]
[null,"November",null,{"$f":"'6. Historical Wholesale'!D72","v":4329.0200000000004},3.1105,13465.416710000001,null,{"$f":"'6. Historical Wholesale'!H72","v":4329.0200000000004},0.71489999999999998,3094.8163980000004,null,{"$f":"'6. Historical Wholesale'!L72","v":0},0,0,null,3094.8163980000004]
[null,"December",null,{"$f":"'6. Historical Wholesale'!D73","v":4281.6499999999996},3.1105,13318.072324999999,null,{"$f":"'6. Historical Wholesale'!H73","v":4281.6499999999996},0.71489999999999998,3060.9515849999998,null,{"$f":"'6. Historical Wholesale'!L73","v":0},0,0,null,3060.9515849999998]
[]
[null,"Total",null,{"$f":"SUM(D62:D73)","v":32454.809999999998},{"$f":"IF(D75<>0,F75/D75,0)","v":3.1105000000000009},{"$f":"SUM(F62:F73)","v":100950.68650500002},null,{"$f":"SUM(H62:H73)","v":32611.380000000005},{"$f":"IF(H75<>0,J75/H75,0)","v":0.71489999999999987},{"$f":"SUM(J62:J73)","v":23313.875561999997},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":23313.875561999997}]
[]
[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":9368.81},{"$f":"'5. UTRs and Sub-Transmission'!I65","v":2.6534},{"$f":"D81*E81","v":24859.200453999998},null,{"$f":"'6. Historical Wholesale'!H81","v":9368.81},{"$f":"'5. UTRs and Sub-Transmission'!I67","v":1.8472999999999999},{"$f":"H81*I81","v":17307.002712999998},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":17307.002712999998}]
[null,"February",null,{"$f":"'6. Historical Wholesale'!D82","v":8754.08},{"$f":"E81","v":2.6534},23228.075872000001,null,{"$f":"'6. Historical Wholesale'!H82","v":8828.43},{"$f":"I81","v":1.8472999999999999},16308.758739000001,null,{"$f":"'6. Historical Wholesale'!L82","v":0},{"$f":"M81","v":0},0,null,16308.758739000001]
[null,"March",null,{"$f":"'6. Historical Wholesale'!D83","v":8403.4},2.6534,22297.581559999999,null,{"$f":"'6. Historical Wholesale'!H83","v":8709.84},1.8472999999999999,16089.687432000001,null,{"$f":"'6. Historical Wholesale'!L83","v":0},0,0,null,16089.687432000001]
[null,"April",null,{"$f":"'6. Historical Wholesale'!D84","v":7627.85},2.6534,20239.73719,null,{"$f":"'6. Historical Wholesale'!H84","v":8006.64},1.8472999999999999,14790.666072,null,{"$f":"'6. Historical Wholesale'!L84","v":0},0,0,null,14790.666072]
[null,"May",null,{"$f":"'6. Historical Wholesale'!D85","v":8330.2199999999993},2.6534,22103.405747999997,null,{"$f":"'6. Historical Wholesale'!H85","v":8330.2199999999993},1.8472999999999999,15388.415405999998,null,{"$f":"'6. Historical Wholesale'!L85","v":0},0,0,null,15388.415405999998]
[null,"June",null,{"$f":"'6. Historical Wholesale'!D86","v":8751.76},2.6534,23221.919984,null,{"$f":"'6. Historical Wholesale'!H86","v":8751.76},1.8472999999999999,16167.126248,null,{"$f":"'6. Historical Wholesale'!L86","v":0},0,0,null,16167.126248]
[null,"July",null,{"$f":"'6. Historical Wholesale'!D87","v":8883.15},2.6534,23570.550209999998,null,{"$f":"'6. Historical Wholesale'!H87","v":8883.15},1.8472999999999999,16409.842994999999,null,{"$f":"'6. Historical Wholesale'!L87","v":0},0,0,null,16409.842994999999]
[null,"August",null,{"$f":"'6. Historical Wholesale'!D88","v":9280.9},2.6534,24625.940059999997,null,{"$f":"'6. Historical Wholesale'!H88","v":9280.9},1.8472999999999999,17144.60657,null,{"$f":"'6. Historical Wholesale'!L88","v":0},0,0,null,17144.60657]
[null,"September",null,{"$f":"'6. Historical Wholesale'!D89","v":10082.66},2.6534,26753.330043999998,null,{"$f":"'6. Historical Wholesale'!H89","v":10082.66},1.8472999999999999,18625.697818000001,null,{"$f":"'6. Historical Wholesale'!L89","v":0},0,0,null,18625.697818000001]
[null,"October",null,{"$f":"'6. Historical Wholesale'!D90","v":868.1},2.6534,2303.4165400000002,null,{"$f":"'6. Historical Wholesale'!H90","v":8763.9},1.8472999999999999,16189.552469999999,null,{"$f":"'6. Historical Wholesale'!L90","v":0},0,0,null,16189.552469999999]
[null,"November",null,{"$f":"'6. Historical Wholesale'!D91","v":9055.4599999999991},2.6534,24027.757563999996,null,{"$f":"'6. Historical Wholesale'!H91","v":9055.4599999999991},1.8472999999999999,16728.151257999998,null,{"$f":"'6. Historical Wholesale'!L91","v":0},0,0,null,16728.151257999998]
[null,"December",null,{"$f":"'6. Historical Wholesale'!D92","v":9069.35},2.6534,24064.613290000001,null,{"$f":"'6. Historical Wholesale'!H92","v":9069.35},1.8472999999999999,16753.810255,null,{"$f":"'6. Historical Wholesale'!L92","v":0},0,0,null,16753.810255]
[]
[null,"Total",null,{"$f":"SUM(D81:D92)","v":98475.74000000002},{"$f":"IF(D94<>0,F94/D94,0)","v":2.6533999999999995},{"$f":"SUM(F81:F92)","v":261295.52851599999},null,{"$f":"SUM(H81:H92)","v":107131.12},{"$f":"IF(H94<>0,J94/H94,0)","v":1.8472999999999999},{"$f":"SUM(J81:J92)","v":197903.31797599999},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":197903.31797599999}]
[]
[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":242676.71000000002},{"$f":"IF(D100<>0,F100/D100,0)","v":3.7047292381250765},{"$f":"F24+F43+F62+F81","v":899051.50294900022},null,{"$f":"H24+H43+H62+H81","v":243448.5},{"$f":"IF(H100<>0,J100/H100,0)","v":0.88740460632947016},{"$f":"J24+J43+J62+J81","v":216037.32030400002},null,{"$f":"L24+L43+L62+L81","v":34796.1},{"$f":"IF(L100<>0,N100/L100,0)","v":1.8915229580326534},{"$f":"N24+N43+N62+N81","v":65817.622000000003},null,{"$f":"J100+N100","v":281854.94230400003}]
[null,"February",null,{"$f":"D25+D44+D63+D82","v":233172.7},3.7068380240782908,{"$f":"F25+F44+F63+F82","v":864333.43053700007},null,{"$f":"H25+H44+H63+H82","v":247534.93000000002},0.88528644363847975,{"$f":"J25+J44+J63+J82","v":219139.31785600004},null,{"$f":"L25+L44+L63+L82","v":34154.17},1.8930659243073396,{"$f":"N25+N44+N63+N82","v":64656.095400000006},null,283795.41325600003]
[null,"March",null,259224.58000000002,3.6496911758329391,946089.66218499991,null,231595.78999999998,0.88675057311706762,205367.69951400001,null,33986.770000000004,1.894578608087794,64390.607400000001,null,269758.30691400002]
[null,"April",null,195583.58000000002,3.7038353259000574,724409.37277000002,null,217136.37000000002,0.88655278337756127,192502.85319600001,null,26600.97,1.878333436713022,49965.491399999999,null,242468.34459600001]
[null,"May",null,220930.67000000004,3.7134650961453199,820418.33171300008,null,225907.14,0.88820269356249637,200651.33024299997,null,25011.79,1.888138345956047,47225.719799999999,null,247877.05004299997]
[null,"June",null,226646.38000000003,3.7122280847547615,841363.05714399996,null,260267.95,0.88600534009661958,230598.79355599999,null,30224.27,1.9097122081029583,57719.657399999996,null,288318.45095600002]
[null,"July",null,246193.47,3.7149710956387261,914601.62498499989,null,252232.93000000002,0.8866755110444936,223648.76211000001,null,31289.430000000004,1.9037846518776469,59568.33660000001,null,283217.09871000005]
[null,"August",null,242861.69,3.7124683998328432,901616.34965500003,null,253185.27000000002,0.88810131205895193,224854.17048100001,null,31237.98,1.902950434054955,59444.327600000004,null,284298.498081]
[null,"September",null,255728.05000000005,3.7127541716835517,949455.38445400004,null,260358.62000000002,0.89062928399297869,231883.01131200005,null,28790.9,1.8978440409990656,54640.637999999999,null,286523.64931200002]
[null,"October",null,183424.34,3.7602565272416957,689722.57174000004,null,205124.88999999998,0.89691585438510169,183979.76596999998,null,26421.989999999998,1.9260193422221417,50889.263800000001,null,234869.02976999996]
[null,"November",null,221701.46000000002,3.7079386832815624,822055.419674,null,229622.69,0.89122000162962989,204644.334156,null,26684.21,1.922456771251613,51299.2402,null,255943.574356]
[null,"December",null,220610.02,3.7055706726965529,817486.02021499991,null,232023.76,0.8902629016959297,206562.14583999998,null,29735.760000000002,1.9202095793078775,57098.891200000013,null,263661.03703999997]
[]
[null,"Total",null,{"$f":"SUM(D100:D111)","v":2748753.65},{"$f":"IF(D113<>0,F113/D113,0)","v":3.707353959501245},{"$f":"SUM(F100:F111)","v":10190602.728021},null,{"$f":"SUM(H100:H111)","v":2858438.84},{"$f":"IF(H113<>0,J113/H113,0)","v":0.88855128505670611},{"$f":"SUM(J100:J111)","v":2539869.5045380001},null,{"$f":"SUM(L100:L111)","v":358934.34},{"$f":"IF(L113<>0,N113/L113,0)","v":1.9020634548368927},{"$f":"SUM(N100:N111)","v":682715.89079999994},null,{"$f":"SUM(P100:P111)","v":3222585.3953379998}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Low Voltage Switchgear Credit (if applicable)",null,{"$f":"'5. UTRs and Sub-Transmission'!I95","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total including deduction for Low Voltage Switchgear Credit",null,{"$f":"P113+P115","v":3222585.3953379998}]

{"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.6E-3},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B25, '4. RRR Data'!$B$27:$M$49,11,0)","v":426672869.50558805},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":3242713.8082424691},null,{"$f":"IF(ISERROR(L25/$L$49), \"\", L25/$L$49)","v":0.31059748363660838},null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N25), \"\", '7. Current Wholesale'!$F$113*N25)","v":3203641.8975805044},null,{"$f":"IF(D25=\"\",\"\",IF(D25=\"kWh\",IF(H25<>0,P25/H25,),IF(J25<>0,P25/J25,0)))","v":7.508426540672155E-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.8999999999999999E-3},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B26, '4. RRR Data'!$B$27:$M$49,11,0)","v":205058784.05262002},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":1414905.6099630781},null,{"$f":"IF(ISERROR(L26/$L$49), \"\", L26/$L$49)","v":0.13552417759495108},null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N26), \"\", '7. Current Wholesale'!$F$113*N26)","v":1397857.215051671},null,{"$f":"IF(D26=\"\",\"\",IF(D26=\"kWh\",IF(H26<>0,P26/H26,),IF(J26<>0,P26/J26,0)))","v":6.8168609382418246E-3}]
[null,{"$f":"IF('3. Rate Classes'!Q26=1,'3. Rate Classes'!C26, 0)","v":"General Service 50 To 4,999 KW (less than 1,000 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.8420999999999998},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B27, '4. RRR Data'!$B$27:$M$49,11,0)","v":166711215.83858913},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B27, '4. RRR Data'!$B$27:$M$49,12,0)","v":494924.32671949943},null,1406624.4289694892,null,0.13473097963477029,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N27), \"\", '7. Current Wholesale'!$F$113*N27)","v":1389675.8151621483},null,2.8078551409532015]
[null,{"$f":"IF('3. Rate Classes'!Q27=1,'3. Rate Classes'!C27, 0)","v":"Large Use"},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":3.3422999999999998},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B28, '4. RRR Data'!$B$27:$M$49,11,0)","v":91205251.099502489},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B28, '4. RRR Data'!$B$27:$M$49,12,0)","v":166648.90999999997},null,556990.65189299989,null,5.3350343298055269E-2,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N28), \"\", '7. Current Wholesale'!$F$113*N28)","v":550279.39389206399},null,3.3020281614327036]
[null,{"$f":"IF('3. Rate Classes'!Q28=1,'3. Rate Classes'!C28, 0)","v":"Unmetered Scattered Load"},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":"kWh"},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":6.8999999999999999E-3},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B29, '4. RRR Data'!$B$27:$M$49,11,0)","v":2647790.9495999999},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B29, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,18269.75755224,null,1.7499357198753943E-3,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N29), \"\", '7. Current Wholesale'!$F$113*N29)","v":18049.622696958471},null,6.8168609382418264E-3]
[null,{"$f":"IF('3. Rate Classes'!Q29=1,'3. Rate Classes'!C29, 0)","v":"Street Lighting"},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":"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":2.1436999999999999},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B30, '4. RRR Data'!$B$27:$M$49,11,0)","v":7720856.5263360236},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B30, '4. RRR Data'!$B$27:$M$49,12,0)","v":21568.221999999994},null,46235.797501399989,null,4.428612331240556E-3,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N30), \"\", '7. Current Wholesale'!$F$113*N30)","v":45678.695932717768},null,2.1178702598998553]
[null,{"$f":"IF('3. Rate Classes'!Q30=1,'3. Rate Classes'!C30, 0)","v":"Embedded Distributor"},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":31728984.630911194},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B31, '4. RRR Data'!$B$27:$M$49,12,0)","v":72406.850000000006},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":"General Service 50 To 4,999 KW (Interval Metered less than 1,000 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":3.0186999999999999},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B32, '4. RRR Data'!$B$27:$M$49,11,0)","v":265938556.30000001},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B32, '4. RRR Data'!$B$27:$M$49,12,0)","v":687810.83999999985},null,2076294.5827079995,null,0.19887412544339025,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N32), \"\", '7. Current Wholesale'!$F$113*N32)","v":2051277.0198761267},null,2.9823272629377682]
[null,{"$f":"IF('3. Rate Classes'!Q32=1,'3. Rate Classes'!C32, 0)","v":"General Service 50 To 4,999 KW (Interval Metered 1,000 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":"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":3.0148000000000001},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B33, '4. RRR Data'!$B$27:$M$49,11,0)","v":267192915.52999997},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B33, '4. RRR Data'!$B$27:$M$49,12,0)","v":556657.26},null,1678210.3074480002,null,0.16074434234110871,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N33), \"\", '7. Current Wholesale'!$F$113*N33)","v":1657989.3175358083},null,2.9784742545813709]
[null,{"$f":"IF('3. Rate Classes'!Q33=1,'3. Rate Classes'!C33, 0)","v":0},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":""},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":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B34, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B34, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N34), \"\", '7. Current Wholesale'!$F$113*N34)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q34=1,'3. Rate Classes'!C34, 0)","v":0},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":""},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":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B35, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B35, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('7. Current Wholesale'!$F$113*N35), \"\", '7. Current Wholesale'!$F$113*N35)","v":""},null,""]
[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":10440244.944277676}]

{"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":2.3E-3},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B25, '4. RRR Data'!$B$27:$M$49,11,0)","v":426672869.50558805},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":981347.59986285248},null,{"$f":"IF(ISERROR(L25/$L$49), \"\", L25/$L$49)","v":0.29971296917372192},null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N25), \"\", '7. Current Wholesale'!$P$117*N25)","v":936036.60349037685},null,{"$f":"IF(D25=\"\",\"\",IF(D25=\"kWh\",IF(H25<>0,P25/H25,),IF(J25<>0,P25/J25,0)))","v":2.1938038961207438E-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":2.0999999999999999E-3},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B26, '4. RRR Data'!$B$27:$M$49,11,0)","v":205058784.05262002},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B26, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,430623.44651050202,null,0.13151653070484012,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N26), \"\", '7. Current Wholesale'!$P$117*N26)","v":410740.60639812268},null,2.0030383399363312E-3]
[null,{"$f":"IF('3. Rate Classes'!Q26=1,'3. Rate Classes'!C26, 0)","v":"General Service 50 To 4,999 KW (less than 1,000 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":0.8165},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B27, '4. RRR Data'!$B$27:$M$49,11,0)","v":166711215.83858913},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B27, '4. RRR Data'!$B$27:$M$49,12,0)","v":494924.32671949943},null,404105.71276647126,null,0.12341776048591628,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N27), \"\", '7. Current Wholesale'!$P$117*N27)","v":385447.2552659717},null,0.77880038312286404]
[null,{"$f":"IF('3. Rate Classes'!Q27=1,'3. Rate Classes'!C27, 0)","v":"Large Use"},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.0234000000000001},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B28, '4. RRR Data'!$B$27:$M$49,11,0)","v":91205251.099502489},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B28, '4. RRR Data'!$B$27:$M$49,12,0)","v":166648.90999999997},null,170548.49449399998,null,5.2087145961378541E-2,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N28), \"\", '7. Current Wholesale'!$P$117*N28)","v":162673.89204281062},null,0.97614735099563898]
[null,{"$f":"IF('3. Rate Classes'!Q28=1,'3. Rate Classes'!C28, 0)","v":"Unmetered Scattered Load"},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":"kWh"},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":2.0999999999999999E-3},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B29, '4. RRR Data'!$B$27:$M$49,11,0)","v":2647790.9495999999},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B29, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,5560.3609941599998,null,1.6981875774397818E-3,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N29), \"\", '7. Current Wholesale'!$P$117*N29)","v":5303.6267881852264},null,2.0030383399363312E-3]
[null,{"$f":"IF('3. Rate Classes'!Q29=1,'3. Rate Classes'!C29, 0)","v":"Street Lighting"},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":"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":0.63100000000000001},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B30, '4. RRR Data'!$B$27:$M$49,11,0)","v":7720856.5263360236},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B30, '4. RRR Data'!$B$27:$M$49,12,0)","v":21568.221999999994},null,13609.548081999996,null,4.1564865143999975E-3,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N30), \"\", '7. Current Wholesale'!$P$117*N30)","v":12981.165046406169},null,0.6018653297618215]
[null,{"$f":"IF('3. Rate Classes'!Q30=1,'3. Rate Classes'!C30, 0)","v":"Embedded Distributor"},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":31728984.630911194},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B31, '4. RRR Data'!$B$27:$M$49,12,0)","v":72406.850000000006},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":"General Service 50 To 4,999 KW (Interval Metered less than 1,000 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":1.0198},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B32, '4. RRR Data'!$B$27:$M$49,11,0)","v":265938556.30000001},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B32, '4. RRR Data'!$B$27:$M$49,12,0)","v":687810.83999999985},null,701429.49463199987,null,0.21422329512148411,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N32), \"\", '7. Current Wholesale'!$P$117*N32)","v":669042.93833812431},null,0.97271357098431954]
[null,{"$f":"IF('3. Rate Classes'!Q32=1,'3. Rate Classes'!C32, 0)","v":"General Service 50 To 4,999 KW (Interval Metered 1,000 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":"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":1.0186999999999999},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B33, '4. RRR Data'!$B$27:$M$49,11,0)","v":267192915.52999997},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B33, '4. RRR Data'!$B$27:$M$49,12,0)","v":556657.26},null,567066.75076199998,null,0.1731876244608192,null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N33), \"\", '7. Current Wholesale'!$P$117*N33)","v":540884.02051400277},null,0.97166436042530513]
[null,{"$f":"IF('3. Rate Classes'!Q33=1,'3. Rate Classes'!C33, 0)","v":0},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":""},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":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B34, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B34, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N34), \"\", '7. Current Wholesale'!$P$117*N34)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q34=1,'3. Rate Classes'!C34, 0)","v":0},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":""},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":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B35, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B35, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('7. Current Wholesale'!$P$117*N35), \"\", '7. Current Wholesale'!$P$117*N35)","v":""},null,""]
[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":3274291.4081039857}]

{"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":7.508426540672155E-3},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B25, '4. RRR Data'!$B$27:$M$49,11,0)","v":426672869.50558805},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":3203641.8975805044},null,{"$f":"IF(ISERROR(L25/$L$49), \"\", L25/$L$49)","v":0.31059748363660838},null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N25), \"\", '8. Forecast Wholesale'!$F$113*N25)","v":3165175.564063679},null,{"$f":"IF(D25=\"\",\"\",IF(D25=\"kWh\",IF(H25<>0,P25/H25,),IF(J25<>0,P25/J25,0)))","v":7.4182723821445721E-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":6.8168609382418246E-3},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B26, '4. RRR Data'!$B$27:$M$49,11,0)","v":205058784.05262002},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":1397857.215051671},null,0.13552417759495108,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N26), \"\", '8. Forecast Wholesale'!$F$113*N26)","v":1381073.0539119109},null,6.7350104522102038E-3]
[null,{"$f":"IF('3. Rate Classes'!Q26=1,'3. Rate Classes'!C26, 0)","v":"General Service 50 To 4,999 KW (less than 1,000 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":2.8078551409532015},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B27, '4. RRR Data'!$B$27:$M$49,11,0)","v":166711215.83858913},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B27, '4. RRR Data'!$B$27:$M$49,12,0)","v":494924.32671949943},null,1389675.8151621483,null,0.13473097963477029,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N27), \"\", '8. Forecast Wholesale'!$F$113*N27)","v":1372989.888615032},null,2.7741410443806696]
[null,{"$f":"IF('3. Rate Classes'!Q27=1,'3. Rate Classes'!C27, 0)","v":"Large Use"},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.3020281614327036},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B28, '4. RRR Data'!$B$27:$M$49,11,0)","v":91205251.099502489},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B28, '4. RRR Data'!$B$27:$M$49,12,0)","v":166648.90999999997},null,550279.39389206399,null,5.3350343298055269E-2,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N28), \"\", '8. Forecast Wholesale'!$F$113*N28)","v":543672.15395401884},null,3.2623804977423432]
[null,{"$f":"IF('3. Rate Classes'!Q28=1,'3. Rate Classes'!C28, 0)","v":"Unmetered Scattered Load"},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":"kWh"},null,{"$f":"VLOOKUP($B29, '9. Adj Network to Current WS'!$B$25:$R$47, 17,0)","v":6.8168609382418264E-3},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B29, '4. RRR Data'!$B$27:$M$49,11,0)","v":2647790.9495999999},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B29, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,18049.622696958471,null,1.7499357198753943E-3,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N29), \"\", '8. Forecast Wholesale'!$F$113*N29)","v":17832.899720823585},null,6.7350104522102055E-3]
[null,{"$f":"IF('3. Rate Classes'!Q29=1,'3. Rate Classes'!C29, 0)","v":"Street Lighting"},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, '9. Adj Network to Current WS'!$B$25:$R$47, 17,0)","v":2.1178702598998553},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B30, '4. RRR Data'!$B$27:$M$49,11,0)","v":7720856.5263360236},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B30, '4. RRR Data'!$B$27:$M$49,12,0)","v":21568.221999999994},null,45678.695932717768,null,4.428612331240556E-3,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N30), \"\", '8. Forecast Wholesale'!$F$113*N30)","v":45130.228904087446},null,2.0924408560004371]
[null,{"$f":"IF('3. Rate Classes'!Q30=1,'3. Rate Classes'!C30, 0)","v":"Embedded Distributor"},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":31728984.630911194},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B31, '4. RRR Data'!$B$27:$M$49,12,0)","v":72406.850000000006},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":"General Service 50 To 4,999 KW (Interval Metered less than 1,000 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":2.9823272629377682},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B32, '4. RRR Data'!$B$27:$M$49,11,0)","v":265938556.30000001},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B32, '4. RRR Data'!$B$27:$M$49,12,0)","v":687810.83999999985},null,2051277.0198761267,null,0.19887412544339025,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N32), \"\", '8. Forecast Wholesale'!$F$113*N32)","v":2026647.2052762031},null,2.9465182684183975]
[null,{"$f":"IF('3. Rate Classes'!Q32=1,'3. Rate Classes'!C32, 0)","v":"General Service 50 To 4,999 KW (Interval Metered 1,000 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, '9. Adj Network to Current WS'!$B$25:$R$47, 17,0)","v":2.9784742545813709},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B33, '4. RRR Data'!$B$27:$M$49,11,0)","v":267192915.52999997},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B33, '4. RRR Data'!$B$27:$M$49,12,0)","v":556657.26},null,1657989.3175358083,null,0.16074434234110871,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N33), \"\", '8. Forecast Wholesale'!$F$113*N33)","v":1638081.733575244},null,2.9427115233801926]
[null,{"$f":"IF('3. Rate Classes'!Q33=1,'3. Rate Classes'!C33, 0)","v":0},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":""},null,{"$f":"VLOOKUP($B34, '9. Adj Network to Current WS'!$B$25:$R$47, 17,0)","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B34, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B34, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N34), \"\", '8. Forecast Wholesale'!$F$113*N34)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q34=1,'3. Rate Classes'!C34, 0)","v":0},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":""},null,{"$f":"VLOOKUP($B35, '9. Adj Network to Current WS'!$B$25:$R$47, 17,0)","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B35, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B35, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$F$113*N35), \"\", '8. Forecast Wholesale'!$F$113*N35)","v":""},null,""]
[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":10314448.977728}]

{"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":2.1938038961207438E-3},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B25, '4. RRR Data'!$B$27:$M$49,11,0)","v":426672869.50558805},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":936036.60349037673},null,{"$f":"IF(ISERROR(L25/$L$49), \"\", L25/$L$49)","v":0.29971296917372192},null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N25), \"\", '8. Forecast Wholesale'!$P$117*N25)","v":965850.63725262438},null,{"$f":"IF(D25=\"\",\"\",IF(D25=\"kWh\",IF(H25<>0,P25/H25,),IF(J25<>0,P25/J25,0)))","v":2.2636795219058915E-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":2.0030383399363312E-3},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B26, '4. RRR Data'!$B$27:$M$49,11,0)","v":205058784.05262002},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B26, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,410740.60639812262,null,0.13151653070484012,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N26), \"\", '8. Forecast Wholesale'!$P$117*N26)","v":423823.25109493942},null,2.0668378243488576E-3]
[null,{"$f":"IF('3. Rate Classes'!Q26=1,'3. Rate Classes'!C26, 0)","v":"General Service 50 To 4,999 KW (less than 1,000 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":0.77880038312286404},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B27, '4. RRR Data'!$B$27:$M$49,11,0)","v":166711215.83858913},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B27, '4. RRR Data'!$B$27:$M$49,12,0)","v":494924.32671949943},null,385447.2552659717,null,0.12341776048591629,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N27), \"\", '8. Forecast Wholesale'!$P$117*N27)","v":397724.27246723714},null,0.80360623027659162]
[null,{"$f":"IF('3. Rate Classes'!Q27=1,'3. Rate Classes'!C27, 0)","v":"Large Use"},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":0.97614735099563898},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B28, '4. RRR Data'!$B$27:$M$49,11,0)","v":91205251.099502489},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B28, '4. RRR Data'!$B$27:$M$49,12,0)","v":166648.90999999997},null,162673.89204281062,null,5.2087145961378548E-2,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N28), \"\", '8. Forecast Wholesale'!$P$117*N28)","v":167855.27585997718},null,1.0072389663993433]
[null,{"$f":"IF('3. Rate Classes'!Q28=1,'3. Rate Classes'!C28, 0)","v":"Unmetered Scattered Load"},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":"kWh"},null,{"$f":"VLOOKUP($B29, '10. Adj Conn. to Current WS'!$B$25:$R$47, 17,0)","v":2.0030383399363312E-3},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B29, '4. RRR Data'!$B$27:$M$49,11,0)","v":2647790.9495999999},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B29, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,5303.6267881852255,null,1.6981875774397818E-3,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N29), \"\", '8. Forecast Wholesale'!$P$117*N29)","v":5472.5544856018596},null,2.0668378243488576E-3]
[null,{"$f":"IF('3. Rate Classes'!Q29=1,'3. Rate Classes'!C29, 0)","v":"Street Lighting"},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, '10. Adj Conn. to Current WS'!$B$25:$R$47, 17,0)","v":0.6018653297618215},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B30, '4. RRR Data'!$B$27:$M$49,11,0)","v":7720856.5263360236},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B30, '4. RRR Data'!$B$27:$M$49,12,0)","v":21568.221999999994},null,12981.165046406169,null,4.1564865143999983E-3,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N30), \"\", '8. Forecast Wholesale'!$P$117*N30)","v":13394.632737224783},null,0.62103555579244252]
[null,{"$f":"IF('3. Rate Classes'!Q30=1,'3. Rate Classes'!C30, 0)","v":"Embedded Distributor"},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":31728984.630911194},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B31, '4. RRR Data'!$B$27:$M$49,12,0)","v":72406.850000000006},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":"General Service 50 To 4,999 KW (Interval Metered less than 1,000 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.97271357098431954},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B32, '4. RRR Data'!$B$27:$M$49,11,0)","v":265938556.30000001},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B32, '4. RRR Data'!$B$27:$M$49,12,0)","v":687810.83999999985},null,669042.93833812431,null,0.21422329512148414,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N32), \"\", '8. Forecast Wholesale'!$P$117*N32)","v":690352.86219967692},null,1.0036958158433169]
[null,{"$f":"IF('3. Rate Classes'!Q32=1,'3. Rate Classes'!C32, 0)","v":"General Service 50 To 4,999 KW (Interval Metered 1,000 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, '10. Adj Conn. to Current WS'!$B$25:$R$47, 17,0)","v":0.97166436042530513},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B33, '4. RRR Data'!$B$27:$M$49,11,0)","v":267192915.52999997},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B33, '4. RRR Data'!$B$27:$M$49,12,0)","v":556657.26},null,540884.02051400277,null,0.1731876244608192,null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N33), \"\", '8. Forecast Wholesale'!$P$117*N33)","v":558111.90924071812},null,1.0026131865067531]
[null,{"$f":"IF('3. Rate Classes'!Q33=1,'3. Rate Classes'!C33, 0)","v":0},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":""},null,{"$f":"VLOOKUP($B34, '10. Adj Conn. to Current WS'!$B$25:$R$47, 17,0)","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B34, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B34, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N34), \"\", '8. Forecast Wholesale'!$P$117*N34)","v":""},null,""]
[null,{"$f":"IF('3. Rate Classes'!Q34=1,'3. Rate Classes'!C34, 0)","v":0},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":""},null,{"$f":"VLOOKUP($B35, '10. Adj Conn. to Current WS'!$B$25:$R$47, 17,0)","v":""},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B35, '4. RRR Data'!$B$27:$M$49,11,0)","v":0},null,{"$f":"VLOOKUP('9. Adj Network to Current WS'!$B35, '4. RRR Data'!$B$27:$M$49,12,0)","v":0},null,"",null,"",null,{"$f":"IF(ISERROR('8. Forecast Wholesale'!$P$117*N35), \"\", '8. Forecast Wholesale'!$P$117*N35)","v":""},null,""]
[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":3123110.1078840001}]

{"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,"Please enter the following Proposed RTS rates into your rates model."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":7.4182723821445721E-3},null,{"$f":"VLOOKUP($B26, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":2.2636795219058915E-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":6.7350104522102038E-3},null,{"$f":"VLOOKUP($B27, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":2.0668378243488576E-3}]
[null,{"$f":"IF('3. Rate Classes'!Q26=1,'3. Rate Classes'!C26, 0)","v":"General Service 50 To 4,999 KW (less than 1,000 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":2.7741410443806696},null,{"$f":"VLOOKUP($B28, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":0.80360623027659162}]
[null,{"$f":"IF('3. Rate Classes'!Q27=1,'3. Rate Classes'!C27, 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, '11. Adj Network to Forecast WS'!$B$25:$R$48,17,0)","v":3.2623804977423432},null,{"$f":"VLOOKUP($B29, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":1.0072389663993433}]
[null,{"$f":"IF('3. Rate Classes'!Q28=1,'3. Rate Classes'!C28, 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, '11. Adj Network to Forecast WS'!$B$25:$R$48,17,0)","v":6.7350104522102055E-3},null,{"$f":"VLOOKUP($B30, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":2.0668378243488576E-3}]
[null,{"$f":"IF('3. Rate Classes'!Q29=1,'3. Rate Classes'!C29, 0)","v":"Street Lighting"},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, '11. Adj Network to Forecast WS'!$B$25:$R$48,17,0)","v":2.0924408560004371},null,{"$f":"VLOOKUP($B31, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":0.62103555579244252}]
[null,{"$f":"IF('3. Rate Classes'!Q30=1,'3. Rate Classes'!C30, 0)","v":"Embedded Distributor"},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":"General Service 50 To 4,999 KW (Interval Metered less than 1,000 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":2.9465182684183975},null,{"$f":"VLOOKUP($B33, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":1.0036958158433169}]
[null,{"$f":"IF('3. Rate Classes'!Q32=1,'3. Rate Classes'!C32, 0)","v":"General Service 50 To 4,999 KW (Interval Metered 1,000 to 4,999 kW)"},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":2.9427115233801926},null,{"$f":"VLOOKUP($B34, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":1.0026131865067531}]
[null,{"$f":"IF('3. Rate Classes'!Q33=1,'3. Rate Classes'!C33, 0)","v":0},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":""},null,{"$f":"VLOOKUP($B35, '11. Adj Network to Forecast WS'!$B$25:$R$48,17,0)","v":""},null,{"$f":"VLOOKUP($B35, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":""}]
[null,{"$f":"IF('3. Rate Classes'!Q34=1,'3. Rate Classes'!C34, 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, '11. Adj Network to Forecast WS'!$B$25:$R$48,17,0)","v":""},null,{"$f":"VLOOKUP($B36, '12. Adj Conn. to Forecast WS'!$B$25:$R$48,17,0)","v":""}]
[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 4,999 KW (less than 1,000 kW)"},3]
[{"$f":"IF('3. Rate Classes'!Q27=1, '3. Rate Classes'!C27, \"\")","v":"Large Use"},4]
[{"$f":"IF('3. Rate Classes'!Q28=1, '3. Rate Classes'!C28, \"\")","v":"Unmetered Scattered Load"},5]
[{"$f":"IF('3. Rate Classes'!Q29=1, '3. Rate Classes'!C29, \"\")","v":"Street Lighting"},6]
[{"$f":"IF('3. Rate Classes'!Q30=1, '3. Rate Classes'!C30, \"\")","v":"Embedded Distributor"},7]
[{"$f":"IF('3. Rate Classes'!Q31=1, '3. Rate Classes'!C31, \"\")","v":"General Service 50 To 4,999 KW (Interval Metered less than 1,000 kW)"},8]
[{"$f":"IF('3. Rate Classes'!Q32=1, '3. Rate Classes'!C32, \"\")","v":"General Service 50 To 4,999 KW (Interval Metered 1,000 to 4,999 kW)"},9]
[{"$f":"IF('3. Rate Classes'!Q33=1, '3. Rate Classes'!C33, \"\")","v":""},10]
[{"$f":"IF('3. Rate Classes'!Q34=1, '3. Rate Classes'!C34, \"\")","v":""},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]