{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["20. Bill Impacts"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":6,"defined_names":174,"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":"20. Bill Impacts","index":0,"n_rows":635,"n_cols":79,"rows_kept":635,"cut":false,"hidden":false,"merged":[[51,3,53,5],[51,6,53,6],[51,7,51,12],[51,13,51,14],[52,7,52,8],[52,9,52,10],[52,11,52,12],[52,13,52,14],[2,2,2,10],[9,3,9,12],[10,3,10,12],[10,13,10,14],[11,3,11,13],[28,3,28,5],[60,3,60,5],[61,3,61,5],[62,3,62,5],[63,3,63,5],[64,3,64,5],[65,3,65,5],[54,3,54,5],[55,3,55,5],[56,3,56,5],[57,3,57,5],[58,3,58,5],[59,3,59,5],[72,3,72,5],[73,3,73,5],[77,4,77,9],[78,4,78,6],[84,5,84,7],[84,8,84,10],[66,3,66,5],[67,3,67,5],[68,3,68,5],[69,3,69,5],[70,3,70,5],[71,3,71,5],[129,3,129,4],[133,4,133,9],[134,4,134,6],[140,5,140,7],[140,8,140,10],[140,11,140,12],[84,11,84,12],[85,4,86,4],[85,11,86,11],[85,12,86,12],[119,3,119,4],[124,3,124,4],[196,11,196,12],[197,4,198,4],[197,11,198,11],[197,12,198,12],[141,4,142,4],[141,11,142,11],[141,12,142,12],[175,3,175,4],[180,3,180,4],[185,3,185,4],[231,3,231,4],[236,3,236,4],[241,3,241,4],[245,4,245,9],[246,4,246,6],[252,5,252,7],[252,8,252,10],[189,4,189,9],[190,4,190,6],[196,5,196,7],[196,8,196,10],[297,3,297,4],[301,4,301,9],[302,4,302,6],[308,5,308,7],[308,8,308,10],[308,11,308,12],[252,11,252,12],[253,4,254,4],[253,11,254,11],[253,12,254,12],[287,3,287,4],[292,3,292,4],[364,11,364,12],[365,4,366,4],[365,11,366,11],[365,12,366,12],[309,4,310,4],[309,11,310,11],[309,12,310,12],[343,3,343,4],[348,3,348,4],[353,3,353,4],[399,3,399,4],[404,3,404,4],[409,3,409,4],[413,4,413,9],[414,4,414,6],[420,5,420,7],[420,8,420,10],[357,4,357,9],[358,4,358,6],[364,5,364,7],[364,8,364,10],[465,3,465,4],[469,4,469,9],[470,4,470,6],[476,5,476,7],[476,8,476,10],[476,11,476,12],[420,11,420,12],[421,4,422,4],[421,11,422,11],[421,12,422,12],[455,3,455,4],[460,3,460,4],[525,4,525,9],[526,4,526,6],[532,5,532,7],[532,8,532,10],[532,11,532,12],[533,4,534,4],[533,11,534,11],[533,12,534,12],[477,4,478,4],[477,11,478,11],[477,12,478,12],[511,3,511,4],[516,3,516,4],[521,3,521,4],[633,3,633,4],[588,11,588,12],[589,4,590,4],[589,11,590,11],[589,12,590,12],[623,3,623,4],[628,3,628,4],[567,3,567,4],[572,3,572,4],[577,3,577,4],[581,4,581,9],[582,4,582,6],[588,5,588,7],[588,8,588,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"The bill comparisons below must be provided for typical customers and consumption levels. Bill impacts must be provided for residential customers consuming 750 kWh per month and general service customers consuming 2,000 kWh per month and having a monthly demand of less than 50 kW. Include bill comparisons for Non-RPP (retailer) as well. To assess the combined effects of the shift to fixed rates and other bill impacts associated with changes in the cost of distribution service, applicants are to include a total bill impact for a residential customer at the distributor’s 10th consumption percentile (In other words, 10% of a distributor’s residential customers consume at or less than this level of consumption on a monthly basis). Refer to section 3.2.3 of the Chapter 3 Filing Requirements For Electricity Distribution Rate Applications.\n\nFor certain classes where one or more customers have unique consumption and demand patterns and which may be significantly impacted by the proposed rate changes, the distributor must show a typical comparison, and provide an explanation.\n\nNote:  \n1. For those classes that are not eligible for the RPP price, the weighted average price including Class B GA through end of May 2018 of $0.1117/kWh (IESO's Monthly Market Report for May 2018, page 22) has been used to represent the cost of power. For those classes on a retailer contract, applicants should enter the contract price (plus GA) for a more accurate estimate. Changes to the cost of power can be made directly on the bill impact table for the specific class.\n2. Please enter the applicable billing determinant (e.g. number of connections or devices) to be applied to the monthly service charge for unmetered rate classes in column N. If the monthly service charge is applied on a per customer basis, enter the number “1”. Distributors should provide the number of connections or devices reflective of a typical customer in each class."]
[null,null,null,"Note that cells with the highlighted color shown to the left indicate quantities that are loss adjusted."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Table 1"]
[null,null,null,"RATE CLASSES / CATEGORIES \n(eg: Residential TOU, Residential Retailer)",null,null,"Units","RPP?\nNon-RPP Retailer?\nNon-RPP\nOther?","Current \nLoss Factor \n(eg: 1.0351)","Proposed Loss Factor","Consumption (kWh)","Demand kW\n(if applicable)","RTSR\nDemand or \nDemand-Interval?","Billing Determinant Applied to Fixed Charge for Unmetered Classes (e.g. # of devices/connections)."]
[null,1,1,"RESIDENTIAL SERVICE CLASSIFICATION",null,null,{"$f":"IF(ISERROR(VLOOKUP(D30, '[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE)),\"\", VLOOKUP(D30,'[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE))","v":"kWh"},"RPP",1.0315000000000001,{"$f":"IF(ISBLANK(I30),\"\", I30)","v":1.0315000000000001},750,null,null,null,null,null,null,null,null,{"$f":"SUM(I30:L30)","v":752.06299999999999},78,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,2,2,"GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION",null,null,{"$f":"IF(ISERROR(VLOOKUP(D31, '[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE)),\"\", VLOOKUP(D31,'[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE))","v":"kWh"},"RPP",1.0315000000000001,1.0315000000000001,2000,null,null,null,null,null,null,null,null,2002.0630000000001,{"$f":"U30+68","v":146},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,3,3,"GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION",null,null,{"$f":"IF(ISERROR(VLOOKUP(D32, '[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE)),\"\", VLOOKUP(D32,'[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE))","v":"kW"},"Non-RPP (Other)",1.0315000000000001,1.0315000000000001,1095000,2500,"DEMAND - INTERVAL",null,null,null,null,null,null,1097502.0630000001,{"$f":"U31+68","v":214},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,4,4,"GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION",null,null,{"$f":"IF(ISERROR(VLOOKUP(D33, '[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE)),\"\", VLOOKUP(D33,'[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE))","v":"kW"},"Non-RPP (Other)",1.0315000000000001,1.0315000000000001,1095000,2500,"DEMAND",null,null,null,null,null,null,1097502.0630000001,282,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,5,5,"STANDBY POWER SERVICE CLASSIFICATION",null,null,{"$f":"IF(ISERROR(VLOOKUP(D34, '[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE)),\"\", VLOOKUP(D34,'[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE))","v":"kW"},"Non-RPP (Other)",1.0315000000000001,1.0315000000000001,null,3500,"DEMAND",null,null,null,null,null,null,3502.0630000000001,350,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,6,6,"LARGE USE SERVICE CLASSIFICATION",null,null,{"$f":"IF(ISERROR(VLOOKUP(D35, '[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE)),\"\", VLOOKUP(D35,'[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE))","v":"kW"},"Non-RPP (Other)",1.0315000000000001,1.0315000000000001,5600000,10700,"DEMAND",null,null,null,null,null,null,5610702.0630000001,418,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,7,7,"STREET LIGHTING SERVICE CLASSIFICATION",null,null,{"$f":"IF(ISERROR(VLOOKUP(D36, '[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE)),\"\", VLOOKUP(D36,'[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE))","v":"kW"},"Non-RPP (Other)",1.0315000000000001,1.0315000000000001,256,0.5,"DEMAND",null,null,null,null,null,null,258.56299999999999,486,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,8,8,"SENTINEL LIGHTING SERVICE CLASSIFICATION",null,null,{"$f":"IF(ISERROR(VLOOKUP(D37, '[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE)),\"\", VLOOKUP(D37,'[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE))","v":"kW"},"Non-RPP (Other)",1.0315000000000001,1.0315000000000001,180,0.1,"DEMAND",null,null,null,null,null,null,182.16299999999998,554,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,9,9,"UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION",null,null,{"$f":"IF(ISERROR(VLOOKUP(D38, '[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE)),\"\", VLOOKUP(D38,'[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE))","v":"kWh"},"RPP",1.0315000000000001,1.0315000000000001,2000,null,null,null,null,null,null,null,null,2002.0630000000001,622,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,10,{"$f":"IF(ISERROR(VLOOKUP(D39, D30:AS49, 42, FALSE)),\"\", VLOOKUP(D39, D30:AS49, 42, FALSE))","v":10},"Add additional scenarios if required",null,null,{"$f":"IF(ISERROR(VLOOKUP(D39, '[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE)),\"\", VLOOKUP(D39,'[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE))","v":""},null,1.0315000000000001,1.0315000000000001,null,null,null,null,null,null,null,null,null,2.0630000000000002,690,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,11,{"$f":"IF(ISERROR(VLOOKUP(D40, D30:AS49, 42, FALSE)),\"\", VLOOKUP(D40, D30:AS49, 42, FALSE))","v":10},"Add additional scenarios if required",null,null,{"$f":"IF(ISERROR(VLOOKUP(D40, '[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE)),\"\", VLOOKUP(D40,'[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE))","v":""},null,1.0315000000000001,1.0315000000000001,null,null,null,null,null,null,null,null,null,2.0630000000000002,758,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,12,{"$f":"IF(ISERROR(VLOOKUP(D41, D30:AS49, 42, FALSE)),\"\", VLOOKUP(D41, D30:AS49, 42, FALSE))","v":10},"Add additional scenarios if required",null,null,{"$f":"IF(ISERROR(VLOOKUP(D41, '[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE)),\"\", VLOOKUP(D41,'[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE))","v":""},null,1.0315000000000001,1.0315000000000001,null,null,null,null,null,null,null,null,null,2.0630000000000002,826]
[null,13,{"$f":"IF(ISERROR(VLOOKUP(D42, D30:AS49, 42, FALSE)),\"\", VLOOKUP(D42, D30:AS49, 42, FALSE))","v":10},"Add additional scenarios if required",null,null,{"$f":"IF(ISERROR(VLOOKUP(D42, '[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE)),\"\", VLOOKUP(D42,'[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE))","v":""},null,1.0315000000000001,1.0315000000000001,null,null,null,null,null,null,null,null,null,2.0630000000000002,894]
[null,14,{"$f":"IF(ISERROR(VLOOKUP(D43, D30:AS49, 42, FALSE)),\"\", VLOOKUP(D43, D30:AS49, 42, FALSE))","v":10},"Add additional scenarios if required",null,null,{"$f":"IF(ISERROR(VLOOKUP(D43, '[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE)),\"\", VLOOKUP(D43,'[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE))","v":""},null,1.0315000000000001,1.0315000000000001,null,null,null,null,null,null,null,null,null,2.0630000000000002,962]
[null,15,{"$f":"IF(ISERROR(VLOOKUP(D44, D30:AS49, 42, FALSE)),\"\", VLOOKUP(D44, D30:AS49, 42, FALSE))","v":10},"Add additional scenarios if required",null,null,{"$f":"IF(ISERROR(VLOOKUP(D44, '[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE)),\"\", VLOOKUP(D44,'[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE))","v":""},null,1.0315000000000001,1.0315000000000001,null,null,null,null,null,null,null,null,null,2.0630000000000002,1030]
[null,16,{"$f":"IF(ISERROR(VLOOKUP(D45, D30:AS49, 42, FALSE)),\"\", VLOOKUP(D45, D30:AS49, 42, FALSE))","v":10},"Add additional scenarios if required",null,null,{"$f":"IF(ISERROR(VLOOKUP(D45, '[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE)),\"\", VLOOKUP(D45,'[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE))","v":""},null,1.0315000000000001,1.0315000000000001,null,null,null,null,null,null,null,null,null,2.0630000000000002,1098]
[null,17,{"$f":"IF(ISERROR(VLOOKUP(D46, D30:AS49, 42, FALSE)),\"\", VLOOKUP(D46, D30:AS49, 42, FALSE))","v":10},"Add additional scenarios if required",null,null,{"$f":"IF(ISERROR(VLOOKUP(D46, '[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE)),\"\", VLOOKUP(D46,'[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE))","v":""},null,1.0315000000000001,1.0315000000000001,null,null,null,null,null,null,null,null,null,2.0630000000000002,1166]
[null,18,{"$f":"IF(ISERROR(VLOOKUP(D47, D30:AS49, 42, FALSE)),\"\", VLOOKUP(D47, D30:AS49, 42, FALSE))","v":10},"Add additional scenarios if required",null,null,{"$f":"IF(ISERROR(VLOOKUP(D47, '[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE)),\"\", VLOOKUP(D47,'[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE))","v":""},null,1.0315000000000001,1.0315000000000001,null,null,null,null,null,null,null,null,null,2.0630000000000002,1234]
[null,19,{"$f":"IF(ISERROR(VLOOKUP(D48, D30:AS49, 42, FALSE)),\"\", VLOOKUP(D48, D30:AS49, 42, FALSE))","v":10},"Add additional scenarios if required",null,null,{"$f":"IF(ISERROR(VLOOKUP(D48, '[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE)),\"\", VLOOKUP(D48,'[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE))","v":""},null,1.0315000000000001,1.0315000000000001,null,null,null,null,null,null,null,null,null,2.0630000000000002,1302]
[null,20,{"$f":"IF(ISERROR(VLOOKUP(D49, D30:AS49, 42, FALSE)),\"\", VLOOKUP(D49, D30:AS49, 42, FALSE))","v":10},"Add additional scenarios if required",null,null,{"$f":"IF(ISERROR(VLOOKUP(D49, '[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE)),\"\", VLOOKUP(D49,'[2]4. Billing Det. for Def-Var'!$A$16:$B$50, 2, FALSE))","v":""},null,1.0315000000000001,1.0315000000000001,null,null,null,null,null,null,null,null,null,2.0630000000000002,1370]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,"Table 2"]
[null,null,null,"RATE CLASSES / CATEGORIES \n(eg: Residential TOU, Residential Retailer)",null,null,"Units","Sub-Total",null,null,null,null,null,"Total"]
[null,null,null,null,null,null,null,"A",null,"B",null,"C",null,"Total Bill"]
[null,null,null,null,null,null,null,"$","%","$","%","$","%","$","%"]
[null,{"$f":"H30","v":"RPP"},1,{"$f":"IF(ISBLANK(D30), \"\", IF(D30 = \"Add additional scenarios if required\", \"\", IF(M30=\"YES\", D30 & \" - \" & H30 & \" - Interval Customers\", D30 & \" - \" &H30)))","v":"RESIDENTIAL SERVICE CLASSIFICATION - RPP"},null,null,{"$f":"IF(ISBLANK(G30), \"\", G30)","v":"kWh"},{"$f":"IF(LEN($G55)>1, (SUMPRODUCT(--($C$78:$C$2000=$B30), --($A$78:$A$2000=$D30), --($B$78:$B$2000=\"ST_A\"), $L$78:$L$2000)), \"\")","v":7.4999999999999289E-2},{"$f":"IF(LEN($G55)>1, (SUMPRODUCT(--($C$78:$C$2000=$B30), --($A$78:$A$2000=$D30), --($B$78:$B$2000=\"ST_A\"), $M$78:$M$2000)), \"\")","v":2.797985450475631E-3},{"$f":"IF(LEN($G55)>1, (SUMPRODUCT(--($C$78:$C$2000=$B30), --($A$78:$A$2000=$D30), --($B$78:$B$2000=\"ST_B\"), $L$78:$L$2000)), \"\")","v":7.4999999999999289E-2},{"$f":"IF(LEN($G55)>1, (SUMPRODUCT(--($C$78:$C$2000=$B30), --($A$78:$A$2000=$D30), --($B$78:$B$2000=\"ST_B\"), $M$78:$M$2000)), \"\")","v":2.5579356436181496E-3},{"$f":"IF(LEN($G55)>1, (SUMPRODUCT(--($C$78:$C$2000=$B30), --($A$78:$A$2000=$D30), --($B$78:$B$2000=\"ST_C\"), $L$78:$L$2000)), \"\")","v":0.53917500000000018},{"$f":"IF(LEN($G55)>1, (SUMPRODUCT(--($C$78:$C$2000=$B30), --($A$78:$A$2000=$D30), --($B$78:$B$2000=\"ST_C\"), $M$78:$M$2000)), \"\")","v":1.363882350207006E-2},{"$f":"IF(LEN($G55)>1, (SUMPRODUCT(--($C$78:$C$2000=$B30), --($A$78:$A$2000=$D30), --($B$78:$B$2000=$B55&\"_TOTAL\"), $L$78:$L$2000)), \"\")","v":0.56613374999999166},{"$f":"IF(LEN($G55)>1, (SUMPRODUCT(--($C$78:$C$2000=$B30), --($A$78:$A$2000=$D30), --($B$78:$B$2000=$B55&\"_TOTAL\"), $M$78:$M$2000)), \"\")","v":5.1565097049770118E-3}]
[null,{"$f":"H31","v":"RPP"},2,"GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION - RPP",null,null,"kWh",{"$f":"IF(LEN($G56)>1, (SUMPRODUCT(--($C$78:$C$2000=$B31), --($A$78:$A$2000=$D31), --($B$78:$B$2000=\"ST_A\"), $L$78:$L$2000)), \"\")","v":-1},{"$f":"IF(LEN($G56)>1, (SUMPRODUCT(--($C$78:$C$2000=$B31), --($A$78:$A$2000=$D31), --($B$78:$B$2000=\"ST_A\"), $M$78:$M$2000)), \"\")","v":-1.6559032952475579E-2},{"$f":"IF(LEN($G56)>1, (SUMPRODUCT(--($C$78:$C$2000=$B31), --($A$78:$A$2000=$D31), --($B$78:$B$2000=\"ST_B\"), $L$78:$L$2000)), \"\")","v":-1},{"$f":"IF(LEN($G56)>1, (SUMPRODUCT(--($C$78:$C$2000=$B31), --($A$78:$A$2000=$D31), --($B$78:$B$2000=\"ST_B\"), $M$78:$M$2000)), \"\")","v":-1.5117603617944902E-2},{"$f":"IF(LEN($G56)>1, (SUMPRODUCT(--($C$78:$C$2000=$B31), --($A$78:$A$2000=$D31), --($B$78:$B$2000=\"ST_C\"), $L$78:$L$2000)), \"\")","v":-0.17479999999999052},{"$f":"IF(LEN($G56)>1, (SUMPRODUCT(--($C$78:$C$2000=$B31), --($A$78:$A$2000=$D31), --($B$78:$B$2000=\"ST_C\"), $M$78:$M$2000)), \"\")","v":-1.9185526122991576E-3},{"$f":"IF(LEN($G56)>1, (SUMPRODUCT(--($C$78:$C$2000=$B31), --($A$78:$A$2000=$D31), --($B$78:$B$2000=$B56&\"_TOTAL\"), $L$78:$L$2000)), \"\")","v":-0.1835399999999936},{"$f":"IF(LEN($G56)>1, (SUMPRODUCT(--($C$78:$C$2000=$B31), --($A$78:$A$2000=$D31), --($B$78:$B$2000=$B56&\"_TOTAL\"), $M$78:$M$2000)), \"\")","v":-6.618553418219459E-4}]
[null,"Non-RPP (Other)",3,"GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION - Non-RPP (Other)",null,null,"kW",-61.819999999999709,-6.91489599692171E-3,-61.819999999999709,-6.91489599692171E-3,520.43000000000029,2.2325396634739141E-2,588.08590000000549,3.4222264146390306E-3]
[null,"Non-RPP (Other)",4,"GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION - Non-RPP (Other)",null,null,"kW",54.889999999999418,4.2750752752824025E-3,54.889999999999418,4.2750752752824025E-3,696.88999999999942,2.4237300102007472E-2,787.48570000001928,4.4242718567103047E-3]
[null,"Non-RPP (Other)",5,"STANDBY POWER SERVICE CLASSIFICATION - Non-RPP (Other)",null,null,"kW",11.899999999999636,9.5296821570712924E-4,11.899999999999636,9.5296821570712924E-4,11.899999999999636,9.5296821570712924E-4,13.447000000000116,9.5294913734079968E-4]
[null,"Non-RPP (Other)",6,"LARGE USE SERVICE CLASSIFICATION - Non-RPP (Other)",null,null,"kW",1097.4600000000064,2.014640684228132E-2,1097.4600000000064,2.014640684228132E-2,1097.4600000000064,2.014640684228132E-2,1240.1298000001116,1.5392489548996643E-3]
[null,"Non-RPP (Other)",7,"STREET LIGHTING SERVICE CLASSIFICATION - Non-RPP (Other)",null,null,"kW",0.11979999999999968,2.6808991529880317E-2,0.11979999999999968,2.2365365540057046E-2,0.1963499999999998,2.7070636949545753E-2,0.221875500000003,5.3840696689567025E-3]
[null,"Non-RPP (Other)",8,"SENTINEL LIGHTING SERVICE CLASSIFICATION - Non-RPP (Other)",null,null,"kW",3.9370000000000127E-2,2.4382238186660139E-2,3.9369999999999905E-2,1.7584001908022704E-2,5.4699999999999971E-2,2.0887134250814364E-2,6.1811000000002281E-2,2.3617338667024455E-3]
[null,"RPP",9,"UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION - RPP",null,null,"kWh",0.79999999999999716,1.8099547511312153E-2,0.79999999999999716,1.6198250386480071E-2,1.6252000000000066,2.1858673160247484E-2,1.8364760000000047,6.577199433175902E-3]
[null,0,10,"",null,null,"","","","","","","","",""]
[null,0,11,"",null,null,"","","","","","","","",""]
[null,0,12,"",null,null,"","","","","","","","",""]
[null,0,13,"",null,null,"","","","","","","","",""]
[null,0,14,"",null,null,"","","","","","","","",""]
[null,0,15,"",null,null,"","","","","","","","",""]
[null,0,16,"",null,null,{"$f":"IF(ISBLANK(G45), \"\", G45)","v":""},"","","","","","","",""]
[null,0,17,"",null,null,{"$f":"IF(ISBLANK(G46), \"\", G46)","v":""},"","","","","","","",""]
[null,0,18,"",null,null,{"$f":"IF(ISBLANK(G47), \"\", G47)","v":""},"","","","","","","",""]
[null,0,19,"",null,null,{"$f":"IF(ISBLANK(G48), \"\", G48)","v":""},"","","","","","","",""]
[null,0,20,"",null,null,{"$f":"IF(ISBLANK(G49), \"\", G49)","v":""},"","","","","","","",""]
[]
[]
[]
[null,null,null,"Customer Class:",{"$f":"D30","v":"RESIDENTIAL SERVICE CLASSIFICATION"},null,null,null,null,null,{"$f":"IF(N30=\"DEMAND - INTERVAL\",\"RTSR - INTERVAL METERED\",\"\")","v":""},null,null,null,null,null,null,null,null,"X"]
[null,null,null,"RPP / Non-RPP:",{"$f":"H30","v":"RPP"}]
[null,null,null,"Consumption",{"$f":"K30","v":750},"kWh"]
[null,null,null,"Demand",{"$f":"L30","v":0},"kW"]
[null,null,null,"Current Loss Factor",{"$f":"I30","v":1.0315000000000001}]
[null,null,null,"Proposed/Approved Loss Factor",{"$f":"J30","v":1.0315000000000001}]
[]
[null,null,null,null,null,"Current OEB-Approved",null,null,"Proposed",null,null,"Impact"]
[null,null,null,null,null,"Rate","Volume","Charge","Rate","Volume","Charge","$ Change","% Change"]
[null,null,null,null,null,"($)",null,"($)","($)",null,"($)"]
[{"$f":"$E78","v":"RESIDENTIAL SERVICE CLASSIFICATION"},null,null,"Monthly Service Charge",null,25.07,1,{"$f":"G88*F88","v":25.07},25.37,{"$f":"G88","v":1},{"$f":"J88*I88","v":25.37},{"$f":"K88-H88","v":0.30000000000000071},{"$f":"IF(ISERROR(L88/H88), \"\", L88/H88)","v":1.1966493817311555E-2}]
[{"$f":"A88","v":"RESIDENTIAL SERVICE CLASSIFICATION"},null,null,"Distribution Volumetric Rate",null,0,{"$f":"IF($E81>0, $E81, $E80)","v":750},{"$f":"G89*F89","v":0},0,{"$f":"IF($E81>0, $E81, $E80)","v":750},{"$f":"J89*I89","v":0},0,{"$f":"IF(ISERROR(L89/H89), \"\", L89/H89)","v":""}]
[{"$f":"A89","v":"RESIDENTIAL SERVICE CLASSIFICATION"},null,null,"RRRP Credit",null,null,{"$f":"IF($E81>0, $E81, $E80)","v":750},0,null,{"$f":"IF($E81>0, $E81, $E80)","v":750},0]
["RESIDENTIAL SERVICE CLASSIFICATION",null,null,"DRP Adjustment",null,null,{"$f":"IF($E81>0, $E81, $E80)","v":750},0,null,{"$f":"IF($E81>0, $E81, $E80)","v":750},0,{"$f":"K91-H91","v":0},{"$f":"IF(ISERROR(L91/H91), \"\", L91/H91)","v":""}]
["RESIDENTIAL SERVICE CLASSIFICATION",null,null,"Fixed Rate Riders",null,0.31,1,0.31,0.31,{"$f":"G92","v":1},{"$f":"J92*I92","v":0.31},0,0]
["RESIDENTIAL SERVICE CLASSIFICATION",null,null,"Volumetric Rate Riders",null,1.9E-3,{"$f":"IF($E81>0, $E81, $E80)","v":750},1.425,1.6000000000000001E-3,{"$f":"IF($E81>0, $E81, $E80)","v":750},1.2,-0.22500000000000009,-0.15789473684210531]
["RESIDENTIAL SERVICE CLASSIFICATION","ST_A",{"$f":"B30","v":1},"Sub-Total A (excluding pass through)",null,null,null,{"$f":"SUM(H88:H93)","v":26.805},null,null,{"$f":"SUM(K88:K93)","v":26.88},7.4999999999999289E-2,{"$f":"IF((H94)=0,\"\",(L94/H94))","v":2.797985450475631E-3}]
["RESIDENTIAL SERVICE CLASSIFICATION",null,null,"Line Losses on Cost of Power",null,{"$f":"IF((E80*12>=150000), 0, IF(E79=\"RPP\",(F111*0.65+F112*0.17+F113*0.18),IF(E79=\"Non-RPP (Retailer)\",F114,F115)))","v":8.2350000000000007E-2},{"$f":"IF(F95=0, 0, $E80*E82-E80)","v":23.625000000000114},{"$f":"G95*F95","v":1.9455187500000095},{"$f":"IF((E80*12>=150000), 0, IF(E79=\"RPP\",(I111*0.65+I112*0.17+I113*0.18),IF(E79=\"Non-RPP (Retailer)\",I114,I115)))","v":8.2350000000000007E-2},{"$f":"IF(I95=0, 0, E80*E83-E80)","v":23.625000000000114},{"$f":"J95*I95","v":1.9455187500000095},{"$f":"K95-H95","v":0},{"$f":"IF(ISERROR(L95/H95), \"\", L95/H95)","v":0}]
["RESIDENTIAL SERVICE CLASSIFICATION",null,null,"Total Deferral/Variance Account Rate Riders",null,0,{"$f":"IF($E81>0, $E81, $E80)","v":750},0,0,{"$f":"IF($E81>0, $E81, $E80)","v":750},0,0,""]
["RESIDENTIAL SERVICE CLASSIFICATION",null,null,"CBR Class B Rate Riders",null,0,{"$f":"IF($E81>0, $E81, $E80)","v":750},{"$f":"G97*F97","v":0},0,{"$f":"IF($E81>0, $E81, $E80)","v":750},{"$f":"J97*I97","v":0},0,""]
["RESIDENTIAL SERVICE CLASSIFICATION",null,null,"GA Rate Riders",null,0,{"$f":"E80","v":750},{"$f":"G98*F98","v":0},0,{"$f":"E80","v":750},0,0,""]
["RESIDENTIAL SERVICE CLASSIFICATION",null,null,"Low Voltage Service Charge",null,0,{"$f":"IF($E81>0, $E81, $E80)","v":750},0,null,{"$f":"IF($E81>0, $E81, $E80)","v":750},0,0,""]
["RESIDENTIAL SERVICE CLASSIFICATION",null,null,"Smart Meter Entity Charge (if applicable)",null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"RESIDENTIAL\", E78))=TRUE, ISNUMBER(SEARCH(\"GENERAL SERVICE LESS THAN 50\", E78))=TRUE), SME, 0)","v":0.56999999999999995},1,{"$f":"G100*F100","v":0.56999999999999995},{"$f":"IF(OR(ISNUMBER(SEARCH(\"RESIDENTIAL\", E78))=TRUE, ISNUMBER(SEARCH(\"GENERAL SERVICE LESS THAN 50\", E78))=TRUE), SME, 0)","v":0.56999999999999995},1,{"$f":"J100*I100","v":0.56999999999999995},0,{"$f":"IF(ISERROR(L100/H100), \"\", L100/H100)","v":0}]
["RESIDENTIAL SERVICE CLASSIFICATION",null,null,"Additional Fixed Rate Riders ",null,0,1,0,0,1,{"$f":"J101*I101","v":0},{"$f":"K101-H101","v":0},{"$f":"IF(ISERROR(L101/H101), \"\", L101/H101)","v":""}]
["RESIDENTIAL SERVICE CLASSIFICATION",null,null,"Additional Volumetric Rate Riders ",null,null,{"$f":"IF($E81>0, $E81, $E80)","v":750},{"$f":"G102*F102","v":0},0,{"$f":"IF($E81>0, $E81, $E80)","v":750},{"$f":"J102*I102","v":0},0,{"$f":"IF(ISERROR(L102/H102), \"\", L102/H102)","v":""}]
["RESIDENTIAL SERVICE CLASSIFICATION","ST_B",{"$f":"B30","v":1},"Sub-Total B - Distribution (includes Sub-Total A)",null,null,null,{"$f":"SUM(H94:H102)","v":29.320518750000009},null,null,{"$f":"SUM(K94:K102)","v":29.395518750000008},7.4999999999999289E-2,{"$f":"IF((H103)=0,\"\",(L103/H103))","v":2.5579356436181496E-3}]
["RESIDENTIAL SERVICE CLASSIFICATION",null,null,"RTSR - Network",null,7.0000000000000001E-3,{"$f":"IF($E81>0, $E81, $E80*$E82)","v":773.62500000000011},{"$f":"G104*F104","v":5.4153750000000009},7.3000000000000001E-3,{"$f":"IF($E81>0, $E81, $E80*$E83)","v":773.62500000000011},{"$f":"J104*I104","v":5.6474625000000005},0.23208749999999956,{"$f":"IF(ISERROR(L104/H104), \"\", L104/H104)","v":4.2857142857142767E-2},{"$f":"IF(ISERROR(ABS(M104)), \"\", IF(ABS(M104)>=4%, \"In the manager's summary, discuss the reasoning for the change in RTSR rates\", \"\"))","v":"In the manager's summary, discuss the reasoning for the change in RTSR rates"}]
["RESIDENTIAL SERVICE CLASSIFICATION",null,null,"RTSR - Connection and/or Line and Transformation Connection",null,6.1999999999999998E-3,{"$f":"IF($E81>0, $E81, $E80*$E82)","v":773.62500000000011},{"$f":"G105*F105","v":4.7964750000000009},6.4999999999999997E-3,{"$f":"IF($E81>0, $E81, $E80*$E83)","v":773.62500000000011},{"$f":"J105*I105","v":5.0285625000000005},0.23208749999999956,{"$f":"IF(ISERROR(L105/H105), \"\", L105/H105)","v":4.838709677419345E-2},{"$f":"IF(ISERROR(ABS(M105)), \"\", IF(ABS(M105)>=4%, \"In the manager's summary, discuss the reasoning for the change in RTSR rates\", \"\"))","v":"In the manager's summary, discuss the reasoning for the change in RTSR rates"}]
["RESIDENTIAL SERVICE CLASSIFICATION","ST_C",{"$f":"B30","v":1},"Sub-Total C - Delivery (including Sub-Total B)",null,null,null,{"$f":"SUM(H103:H105)","v":39.53236875000001},null,null,{"$f":"SUM(K103:K105)","v":40.071543750000011},0.53917500000000018,{"$f":"IF((H106)=0,\"\",(L106/H106))","v":1.363882350207006E-2}]
["RESIDENTIAL SERVICE CLASSIFICATION",null,null,"Wholesale Market Service Charge (WMSC)",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$E$14),'[2]17. Regulatory Charges'!$D$15+'[2]17. Regulatory Charges'!$D$16,'[2]17. Regulatory Charges'!$E$15+'[2]17. Regulatory Charges'!$E$16)","v":3.4000000000000002E-3},{"$f":"E80*E82","v":773.62500000000011},{"$f":"G107*F107","v":2.6303250000000005},{"$f":"'[2]17. Regulatory Charges'!$E$15+'[2]17. Regulatory Charges'!$E$16","v":3.4000000000000002E-3},{"$f":"E80*E83","v":773.62500000000011},{"$f":"J107*I107","v":2.6303250000000005},0,{"$f":"IF(ISERROR(L107/H107), \"\", L107/H107)","v":0}]
["RESIDENTIAL SERVICE CLASSIFICATION",null,null,"Rural and Remote Rate Protection (RRRP)",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$D$14),'[2]17. Regulatory Charges'!$D$17,'[2]17. Regulatory Charges'!$E$17)","v":5.0000000000000001E-4},{"$f":"E80*E82","v":773.62500000000011},0.38681250000000006,{"$f":"'[2]17. Regulatory Charges'!$E$17","v":5.0000000000000001E-4},{"$f":"E80*E83","v":773.62500000000011},0.38681250000000006,0,0]
["RESIDENTIAL SERVICE CLASSIFICATION",null,null,"Standard Supply Service Charge",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$D$14),'[2]17. Regulatory Charges'!$D$18,'[2]17. Regulatory Charges'!$E$18)","v":0.25},1,0.25,{"$f":"'[2]17. Regulatory Charges'!$E$18","v":0.25},1,0.25,0,0]
["RESIDENTIAL SERVICE CLASSIFICATION",null,null,"Ontario Electricity Support Program \n(OESP) "]
["RESIDENTIAL SERVICE CLASSIFICATION","RPP",null,"TOU - Off Peak",null,{"$f":"OffPeak","v":6.5000000000000002E-2},{"$f":"IF(AND(E80*12>=150000),0.65*E80*E82,0.65*E80)","v":487.5},31.6875,{"$f":"OffPeak","v":6.5000000000000002E-2},{"$f":"IF(AND(E80*12>=150000),0.65*E80*E83,0.65*E80)","v":487.5},31.6875,{"$f":"K111-H111","v":0},0]
["RESIDENTIAL SERVICE CLASSIFICATION","RPP",null,"TOU - Mid Peak",null,{"$f":"MidPeak","v":9.4E-2},{"$f":"IF(AND(E80*12>=150000),0.17*E80*E82,0.17*E80)","v":127.50000000000001},11.985000000000001,{"$f":"MidPeak","v":9.4E-2},{"$f":"IF(AND(E80*12>=150000),0.17*E80*E83,0.17*E80)","v":127.50000000000001},11.985000000000001,{"$f":"K112-H112","v":0},0]
["RESIDENTIAL SERVICE CLASSIFICATION","RPP",null,"TOU - On Peak",null,{"$f":"OnPeak","v":0.13400000000000001},{"$f":"IF(AND(E80*12>=150000),0.18*E80*E82,0.18*E80)","v":135},18.09,{"$f":"OnPeak","v":0.13400000000000001},{"$f":"IF(AND(E80*12>=150000),0.18*E80*E83,0.18*E80)","v":135},18.09,{"$f":"K113-H113","v":0},0]
["RESIDENTIAL SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"Non-RPP Retailer Avg. Price",null,0.1101,{"$f":"IF(AND(E80*12>=150000),E80*E82,E80)","v":750},{"$f":"G114*F114","v":82.575000000000003},{"$f":"F114","v":0.1101},{"$f":"IF(AND(E80*12>=150000),E80*E83,E80)","v":750},{"$f":"J114*I114","v":82.575000000000003},{"$f":"K114-H114","v":0},0]
["RESIDENTIAL SERVICE CLASSIFICATION","Non-RPP (Other)",null,"Average IESO Wholesale Market Price",null,0.1101,{"$f":"IF(AND(E80*12>=150000),E80*E82,E80)","v":750},{"$f":"G115*F115","v":82.575000000000003},{"$f":"F115","v":0.1101},{"$f":"IF(AND(E80*12>=150000),E80*E83,E80)","v":750},{"$f":"J115*I115","v":82.575000000000003},{"$f":"K115-H115","v":0},0]
["RESIDENTIAL SERVICE CLASSIFICATION"]
["RESIDENTIAL SERVICE CLASSIFICATION","RPP",null,"Total Bill on TOU (before Taxes)",null,null,null,{"$f":"SUM(H107:H113,H106)","v":104.56200625000002},null,null,{"$f":"SUM(K107:K113,K106)","v":105.10118125000002},{"$f":"K117-H117","v":0.53917500000000018},{"$f":"IF((H117)=0,\"\",(L117/H117))","v":5.156509704977089E-3}]
["RESIDENTIAL SERVICE CLASSIFICATION","RPP",null,"HST",null,0.13,null,{"$f":"H117*F118","v":13.593060812500005},0.13,null,{"$f":"K117*I118","v":13.663153562500003},{"$f":"K118-H118","v":7.0092749999998816E-2},{"$f":"IF((H118)=0,\"\",(L118/H118))","v":5.1565097049769996E-3}]
["RESIDENTIAL SERVICE CLASSIFICATION","RPP",null,"8% Rebate",null,0.08,null,{"$f":"H117*-F119","v":-8.3649605000000022},0.08,null,{"$f":"K117*-I119","v":-8.4080945000000025},{"$f":"K119-H119","v":-4.3134000000000228E-2}]
["RESIDENTIAL SERVICE CLASSIFICATION","RPP_TOTAL",{"$f":"B30","v":1},"Total Bill on TOU",null,null,null,{"$f":"H117+H118+H119","v":109.79010656250003},null,null,{"$f":"K117+K118+K119","v":110.35624031250002},{"$f":"K120-H120","v":0.56613374999999166},{"$f":"IF((H120)=0,\"\",(L120/H120))","v":5.1565097049770118E-3}]
["RESIDENTIAL SERVICE CLASSIFICATION","RPP"]
["RESIDENTIAL SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"Total Bill on Non-RPP Avg. Price",null,null,null,{"$f":"SUM(H114,H107:H110,H106)","v":125.37450625000002},null,null,{"$f":"SUM(K114,K107:K110,K106)","v":125.91368125000002},{"$f":"K122-H122","v":0.53917500000000018},{"$f":"IF((H122)=0,\"\",(L122/H122))","v":4.3005154407138495E-3}]
["RESIDENTIAL SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"HST",null,0.13,null,{"$f":"H122*F123","v":16.298685812500004},0.13,null,{"$f":"K122*I123","v":16.368778562500005},{"$f":"K123-H123","v":7.0092750000000592E-2},{"$f":"IF((H123)=0,\"\",(L123/H123))","v":4.3005154407138842E-3}]
["RESIDENTIAL SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"8% Rebate",null,0.08,null,null,0.08]
["RESIDENTIAL SERVICE CLASSIFICATION","Non-RPP (Retailer)_TOTAL",null,"Total Bill on Non-RPP Avg. Price",null,null,null,{"$f":"SUM(H122,H123)","v":141.67319206250002},null,null,{"$f":"SUM(K122,K123)","v":142.28245981250004},{"$f":"K125-H125","v":0.60926775000001498},{"$f":"IF((H125)=0,\"\",(L125/H125))","v":4.3005154407139545E-3}]
["RESIDENTIAL SERVICE CLASSIFICATION","Non-RPP (Retailer)"]
["RESIDENTIAL SERVICE CLASSIFICATION","Non-RPP (Other)",null,"Total Bill on Average IESO Wholesale Market Price",null,null,null,{"$f":"SUM(H115,H107:H110,H106)","v":125.37450625000002},null,null,{"$f":"SUM(K115,K107:K110,K106)","v":125.91368125000002},{"$f":"K127-H127","v":0.53917500000000018},{"$f":"IF((H127)=0,\"\",(L127/H127))","v":4.3005154407138495E-3}]
["RESIDENTIAL SERVICE CLASSIFICATION","Non-RPP (Other)",null,"HST",null,0.13,null,{"$f":"H127*F128","v":16.298685812500004},0.13,null,{"$f":"K127*I128","v":16.368778562500005},{"$f":"K128-H128","v":7.0092750000000592E-2},{"$f":"IF((H128)=0,\"\",(L128/H128))","v":4.3005154407138842E-3}]
["RESIDENTIAL SERVICE CLASSIFICATION","Non-RPP (Other)",null,"8% Rebate",null,0.08,null,null,0.08]
["RESIDENTIAL SERVICE CLASSIFICATION","Non-RPP (Other)_TOTAL",null,"Total Bill on Average IESO Wholesale Market Price",null,null,null,{"$f":"SUM(H127,H128)","v":141.67319206250002},null,null,{"$f":"SUM(K127,K128)","v":142.28245981250004},{"$f":"K130-H130","v":0.60926775000001498},{"$f":"IF((H130)=0,\"\",(L130/H130))","v":4.3005154407139545E-3}]
["RESIDENTIAL SERVICE CLASSIFICATION","Non-RPP (Other)"]
[]
[]
[null,null,null,"Customer Class:",{"$f":"D31","v":"GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION"},null,null,null,null,null,{"$f":"IF(N31=\"DEMAND - INTERVAL\",\"RTSR - INTERVAL METERED\",\"\")","v":""},null,null,null,null,null,null,null,null,"X"]
[null,null,null,"RPP / Non-RPP:",{"$f":"H31","v":"RPP"}]
[null,null,null,"Consumption",{"$f":"K31","v":2000},"kWh"]
[null,null,null,"Demand",{"$f":"L31","v":0},"kW"]
[null,null,null,"Current Loss Factor",{"$f":"I31","v":1.0315000000000001}]
[null,null,null,"Proposed/Approved Loss Factor",{"$f":"J31","v":1.0315000000000001}]
[]
[null,null,null,null,null,"Current OEB-Approved",null,null,"Proposed",null,null,"Impact"]
[null,null,null,null,null,"Rate","Volume","Charge","Rate","Volume","Charge","$ Change","% Change"]
[null,null,null,null,null,"($)",null,"($)","($)",null,"($)"]
[{"$f":"$E134","v":"GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION"},null,null,"Monthly Service Charge",null,32.979999999999997,1,{"$f":"G144*F144","v":32.979999999999997},33.380000000000003,{"$f":"G144","v":1},{"$f":"J144*I144","v":33.380000000000003},{"$f":"K144-H144","v":0.40000000000000568},{"$f":"IF(ISERROR(L144/H144), \"\", L144/H144)","v":1.2128562765312484E-2}]
[{"$f":"A144","v":"GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION"},null,null,"Distribution Volumetric Rate",null,1.0999999999999999E-2,{"$f":"IF($E137>0, $E137, $E136)","v":2000},{"$f":"G145*F145","v":22},1.11E-2,{"$f":"IF($E137>0, $E137, $E136)","v":2000},{"$f":"J145*I145","v":22.2},0.19999999999999929,{"$f":"IF(ISERROR(L145/H145), \"\", L145/H145)","v":9.0909090909090592E-3}]
[{"$f":"A145","v":"GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION"},null,null,"RRRP Credit",null,null,{"$f":"IF($E137>0, $E137, $E136)","v":2000},0,null,{"$f":"IF($E137>0, $E137, $E136)","v":2000},0]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION",null,null,"DRP Adjustment",null,null,{"$f":"IF($E137>0, $E137, $E136)","v":2000},0,null,{"$f":"IF($E137>0, $E137, $E136)","v":2000},0,{"$f":"K147-H147","v":0},{"$f":"IF(ISERROR(L147/H147), \"\", L147/H147)","v":""}]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION",null,null,"Fixed Rate Riders",null,0.41,1,0.41,0.41,{"$f":"G148","v":1},{"$f":"J148*I148","v":0.41},0,0]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION",null,null,"Volumetric Rate Riders",null,2.5000000000000001E-3,{"$f":"IF($E137>0, $E137, $E136)","v":2000},5,1.7000000000000001E-3,{"$f":"IF($E137>0, $E137, $E136)","v":2000},3.4000000000000004,-1.5999999999999996,-0.31999999999999995]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","ST_A",{"$f":"B31","v":2},"Sub-Total A (excluding pass through)",null,null,null,{"$f":"SUM(H144:H149)","v":60.389999999999993},null,null,{"$f":"SUM(K144:K149)","v":59.389999999999993},-1,{"$f":"IF((H150)=0,\"\",(L150/H150))","v":-1.6559032952475579E-2}]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION",null,null,"Line Losses on Cost of Power",null,{"$f":"IF((E136*12>=150000), 0, IF(E135=\"RPP\",(F167*0.65+F168*0.17+F169*0.18),IF(E135=\"Non-RPP (Retailer)\",F170,F171)))","v":8.2350000000000007E-2},{"$f":"IF(F151=0, 0, $E136*E138-E136)","v":63},{"$f":"G151*F151","v":5.1880500000000005},{"$f":"IF((E136*12>=150000), 0, IF(E135=\"RPP\",(I167*0.65+I168*0.17+I169*0.18),IF(E135=\"Non-RPP (Retailer)\",I170,I171)))","v":8.2350000000000007E-2},{"$f":"IF(I151=0, 0, E136*E139-E136)","v":63},{"$f":"J151*I151","v":5.1880500000000005},{"$f":"K151-H151","v":0},{"$f":"IF(ISERROR(L151/H151), \"\", L151/H151)","v":0}]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION",null,null,"Total Deferral/Variance Account Rate Riders",null,0,{"$f":"IF($E137>0, $E137, $E136)","v":2000},0,0,{"$f":"IF($E137>0, $E137, $E136)","v":2000},0,0,""]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION",null,null,"CBR Class B Rate Riders",null,0,{"$f":"IF($E137>0, $E137, $E136)","v":2000},{"$f":"G153*F153","v":0},0,{"$f":"IF($E137>0, $E137, $E136)","v":2000},{"$f":"J153*I153","v":0},0,""]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION",null,null,"GA Rate Riders",null,0,{"$f":"E136","v":2000},{"$f":"G154*F154","v":0},0,{"$f":"E136","v":2000},0,0,""]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION",null,null,"Low Voltage Service Charge",null,0,{"$f":"IF($E137>0, $E137, $E136)","v":2000},0,null,{"$f":"IF($E137>0, $E137, $E136)","v":2000},0,0,""]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION",null,null,"Smart Meter Entity Charge (if applicable)",null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"RESIDENTIAL\", E134))=TRUE, ISNUMBER(SEARCH(\"GENERAL SERVICE LESS THAN 50\", E134))=TRUE), SME, 0)","v":0.56999999999999995},1,{"$f":"G156*F156","v":0.56999999999999995},{"$f":"IF(OR(ISNUMBER(SEARCH(\"RESIDENTIAL\", E134))=TRUE, ISNUMBER(SEARCH(\"GENERAL SERVICE LESS THAN 50\", E134))=TRUE), SME, 0)","v":0.56999999999999995},1,{"$f":"J156*I156","v":0.56999999999999995},0,{"$f":"IF(ISERROR(L156/H156), \"\", L156/H156)","v":0}]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION",null,null,"Additional Fixed Rate Riders ",null,0,1,0,0,1,{"$f":"J157*I157","v":0},{"$f":"K157-H157","v":0},{"$f":"IF(ISERROR(L157/H157), \"\", L157/H157)","v":""}]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION",null,null,"Additional Volumetric Rate Riders ",null,null,{"$f":"IF($E137>0, $E137, $E136)","v":2000},{"$f":"G158*F158","v":0},0,{"$f":"IF($E137>0, $E137, $E136)","v":2000},{"$f":"J158*I158","v":0},0,{"$f":"IF(ISERROR(L158/H158), \"\", L158/H158)","v":""}]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","ST_B",{"$f":"B31","v":2},"Sub-Total B - Distribution (includes Sub-Total A)",null,null,null,{"$f":"SUM(H150:H158)","v":66.148049999999984},null,null,{"$f":"SUM(K150:K158)","v":65.148049999999984},-1,{"$f":"IF((H159)=0,\"\",(L159/H159))","v":-1.5117603617944902E-2}]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION",null,null,"RTSR - Network",null,6.6E-3,{"$f":"IF($E137>0, $E137, $E136*$E138)","v":2063},{"$f":"G160*F160","v":13.6158},6.7999999999999996E-3,{"$f":"IF($E137>0, $E137, $E136*$E139)","v":2063},{"$f":"J160*I160","v":14.0284},0.41259999999999941,{"$f":"IF(ISERROR(L160/H160), \"\", L160/H160)","v":3.0303030303030259E-2},{"$f":"IF(ISERROR(ABS(M160)), \"\", IF(ABS(M160)>=4%, \"In the manager's summary, discuss the reasoning for the change in RTSR rates\", \"\"))","v":""}]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION",null,null,"RTSR - Connection and/or Line and Transformation Connection",null,5.4999999999999997E-3,{"$f":"IF($E137>0, $E137, $E136*$E138)","v":2063},{"$f":"G161*F161","v":11.346499999999999},5.7000000000000002E-3,{"$f":"IF($E137>0, $E137, $E136*$E139)","v":2063},{"$f":"J161*I161","v":11.7591},0.41260000000000119,{"$f":"IF(ISERROR(L161/H161), \"\", L161/H161)","v":3.6363636363636473E-2},{"$f":"IF(ISERROR(ABS(M161)), \"\", IF(ABS(M161)>=4%, \"In the manager's summary, discuss the reasoning for the change in RTSR rates\", \"\"))","v":""}]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","ST_C",{"$f":"B31","v":2},"Sub-Total C - Delivery (including Sub-Total B)",null,null,null,{"$f":"SUM(H159:H161)","v":91.110349999999983},null,null,{"$f":"SUM(K159:K161)","v":90.935549999999992},-0.17479999999999052,{"$f":"IF((H162)=0,\"\",(L162/H162))","v":-1.9185526122991576E-3}]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION",null,null,"Wholesale Market Service Charge (WMSC)",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$E$14),'[2]17. Regulatory Charges'!$D$15+'[2]17. Regulatory Charges'!$D$16,'[2]17. Regulatory Charges'!$E$15+'[2]17. Regulatory Charges'!$E$16)","v":3.4000000000000002E-3},{"$f":"E136*E138","v":2063},{"$f":"G163*F163","v":7.0142000000000007},{"$f":"'[2]17. Regulatory Charges'!$E$15+'[2]17. Regulatory Charges'!$E$16","v":3.4000000000000002E-3},{"$f":"E136*E139","v":2063},{"$f":"J163*I163","v":7.0142000000000007},0,{"$f":"IF(ISERROR(L163/H163), \"\", L163/H163)","v":0}]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION",null,null,"Rural and Remote Rate Protection (RRRP)",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$D$14),'[2]17. Regulatory Charges'!$D$17,'[2]17. Regulatory Charges'!$E$17)","v":5.0000000000000001E-4},{"$f":"E136*E138","v":2063},1.0315000000000001,{"$f":"'[2]17. Regulatory Charges'!$E$17","v":5.0000000000000001E-4},{"$f":"E136*E139","v":2063},1.0315000000000001,0,0]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION",null,null,"Standard Supply Service Charge",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$D$14),'[2]17. Regulatory Charges'!$D$18,'[2]17. Regulatory Charges'!$E$18)","v":0.25},1,0.25,{"$f":"'[2]17. Regulatory Charges'!$E$18","v":0.25},1,0.25,0,0]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION",null,null,"Ontario Electricity Support Program \n(OESP) "]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","RPP",null,"TOU - Off Peak",null,{"$f":"OffPeak","v":6.5000000000000002E-2},{"$f":"IF(AND(E136*12>=150000),0.65*E136*E138,0.65*E136)","v":1300},84.5,{"$f":"OffPeak","v":6.5000000000000002E-2},{"$f":"IF(AND(E136*12>=150000),0.65*E136*E139,0.65*E136)","v":1300},84.5,{"$f":"K167-H167","v":0},0]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","RPP",null,"TOU - Mid Peak",null,{"$f":"MidPeak","v":9.4E-2},{"$f":"IF(AND(E136*12>=150000),0.17*E136*E138,0.17*E136)","v":340},31.96,{"$f":"MidPeak","v":9.4E-2},{"$f":"IF(AND(E136*12>=150000),0.17*E136*E139,0.17*E136)","v":340},31.96,{"$f":"K168-H168","v":0},0]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","RPP",null,"TOU - On Peak",null,{"$f":"OnPeak","v":0.13400000000000001},{"$f":"IF(AND(E136*12>=150000),0.18*E136*E138,0.18*E136)","v":360},48.24,{"$f":"OnPeak","v":0.13400000000000001},{"$f":"IF(AND(E136*12>=150000),0.18*E136*E139,0.18*E136)","v":360},48.24,{"$f":"K169-H169","v":0},0]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"Non-RPP Retailer Avg. Price",null,0.1101,{"$f":"IF(AND(E136*12>=150000),E136*E138,E136)","v":2000},{"$f":"G170*F170","v":220.20000000000002},{"$f":"F170","v":0.1101},{"$f":"IF(AND(E136*12>=150000),E136*E139,E136)","v":2000},{"$f":"J170*I170","v":220.20000000000002},{"$f":"K170-H170","v":0},0]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","Non-RPP (Other)",null,"Average IESO Wholesale Market Price",null,0.1101,{"$f":"IF(AND(E136*12>=150000),E136*E138,E136)","v":2000},{"$f":"G171*F171","v":220.20000000000002},{"$f":"F171","v":0.1101},{"$f":"IF(AND(E136*12>=150000),E136*E139,E136)","v":2000},{"$f":"J171*I171","v":220.20000000000002},{"$f":"K171-H171","v":0},0]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION"]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","RPP",null,"Total Bill on TOU (before Taxes)",null,null,null,{"$f":"SUM(H163:H169,H162)","v":264.10604999999998},null,null,{"$f":"SUM(K163:K169,K162)","v":263.93124999999998},{"$f":"K173-H173","v":-0.17480000000000473},{"$f":"IF((H173)=0,\"\",(L173/H173))","v":-6.6185534182198677E-4}]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","RPP",null,"HST",null,0.13,null,{"$f":"H173*F174","v":34.333786500000002},0.13,null,{"$f":"K173*I174","v":34.311062499999998},{"$f":"K174-H174","v":-2.2724000000003741E-2},{"$f":"IF((H174)=0,\"\",(L174/H174))","v":-6.6185534182207773E-4}]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","RPP",null,"8% Rebate",null,0.08,null,{"$f":"H173*-F175","v":-21.128484},0.08,null,{"$f":"K173*-I175","v":-21.1145},{"$f":"K175-H175","v":1.3984000000000663E-2}]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","RPP_TOTAL",{"$f":"B31","v":2},"Total Bill on TOU",null,null,null,{"$f":"H173+H174+H175","v":277.31135249999994},null,null,{"$f":"K173+K174+K175","v":277.12781249999995},{"$f":"K176-H176","v":-0.1835399999999936},{"$f":"IF((H176)=0,\"\",(L176/H176))","v":-6.618553418219459E-4}]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","RPP"]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"Total Bill on Non-RPP Avg. Price",null,null,null,{"$f":"SUM(H170,H163:H166,H162)","v":319.60604999999998},null,null,{"$f":"SUM(K170,K163:K166,K162)","v":319.43124999999998},{"$f":"K178-H178","v":-0.17480000000000473},{"$f":"IF((H178)=0,\"\",(L178/H178))","v":-5.4692331387345375E-4}]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"HST",null,0.13,null,{"$f":"H178*F179","v":41.548786499999999},0.13,null,{"$f":"K178*I179","v":41.526062500000002},{"$f":"K179-H179","v":-2.2723999999996636E-2},{"$f":"IF((H179)=0,\"\",(L179/H179))","v":-5.4692331387335791E-4}]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"8% Rebate",null,0.08,null,null,0.08]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","Non-RPP (Retailer)_TOTAL",null,"Total Bill on Non-RPP Avg. Price",null,null,null,{"$f":"SUM(H178,H179)","v":361.15483649999999},null,null,{"$f":"SUM(K178,K179)","v":360.9573125},{"$f":"K181-H181","v":-0.19752399999998715},{"$f":"IF((H181)=0,\"\",(L181/H181))","v":-5.4692331387340334E-4}]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","Non-RPP (Retailer)"]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","Non-RPP (Other)",null,"Total Bill on Average IESO Wholesale Market Price",null,null,null,{"$f":"SUM(H171,H163:H166,H162)","v":319.60604999999998},null,null,{"$f":"SUM(K171,K163:K166,K162)","v":319.43124999999998},{"$f":"K183-H183","v":-0.17480000000000473},{"$f":"IF((H183)=0,\"\",(L183/H183))","v":-5.4692331387345375E-4}]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","Non-RPP (Other)",null,"HST",null,0.13,null,{"$f":"H183*F184","v":41.548786499999999},0.13,null,{"$f":"K183*I184","v":41.526062500000002},{"$f":"K184-H184","v":-2.2723999999996636E-2},{"$f":"IF((H184)=0,\"\",(L184/H184))","v":-5.4692331387335791E-4}]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","Non-RPP (Other)",null,"8% Rebate",null,0.08,null,null,0.08]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","Non-RPP (Other)_TOTAL",null,"Total Bill on Average IESO Wholesale Market Price",null,null,null,{"$f":"SUM(H183,H184)","v":361.15483649999999},null,null,{"$f":"SUM(K183,K184)","v":360.9573125},{"$f":"K186-H186","v":-0.19752399999998715},{"$f":"IF((H186)=0,\"\",(L186/H186))","v":-5.4692331387340334E-4}]
["GENERAL SERVICE LESS THAN 50 KW SERVICE CLASSIFICATION","Non-RPP (Other)"]
[]
[]
[null,null,null,"Customer Class:",{"$f":"D32","v":"GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION"},null,null,null,null,null,{"$f":"IF(N32=\"DEMAND - INTERVAL\",\"RTSR - INTERVAL METERED\",\"\")","v":""},null,null,null,null,null,null,null,null,"X"]
[null,null,null,"RPP / Non-RPP:",{"$f":"H32","v":"Non-RPP (Other)"}]
[null,null,null,"Consumption",{"$f":"K32","v":1095000},"kWh"]
[null,null,null,"Demand",{"$f":"L32","v":2500},"kW"]
[null,null,null,"Current Loss Factor",{"$f":"I32","v":1.0315000000000001}]
[null,null,null,"Proposed/Approved Loss Factor",{"$f":"J32","v":1.0315000000000001}]
[]
[null,null,null,null,null,"Current OEB-Approved",null,null,"Proposed",null,null,"Impact"]
[null,null,null,null,null,"Rate","Volume","Charge","Rate","Volume","Charge","$ Change","% Change"]
[null,null,null,null,null,"($)",null,"($)","($)",null,"($)"]
[{"$f":"$E190","v":"GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION"},null,null,"Monthly Service Charge",null,161.11000000000001,1,{"$f":"G200*F200","v":161.11000000000001},163.04,{"$f":"G200","v":1},{"$f":"J200*I200","v":163.04},{"$f":"K200-H200","v":1.9299999999999784},{"$f":"IF(ISERROR(L200/H200), \"\", L200/H200)","v":1.1979392961330633E-2}]
[{"$f":"A200","v":"GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION"},null,null,"Distribution Volumetric Rate",null,2.7818000000000001,{"$f":"IF($E193>0, $E193, $E192)","v":2500},{"$f":"G201*F201","v":6954.5},2.8151999999999999,{"$f":"IF($E193>0, $E193, $E192)","v":2500},{"$f":"J201*I201","v":7038},83.5,{"$f":"IF(ISERROR(L201/H201), \"\", L201/H201)","v":1.2006614422316486E-2}]
[{"$f":"A201","v":"GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION"},null,null,"RRRP Credit",null,null,{"$f":"IF($E193>0, $E193, $E192)","v":2500},0,null,{"$f":"IF($E193>0, $E193, $E192)","v":2500},0]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION",null,null,"DRP Adjustment",null,null,{"$f":"IF($E193>0, $E193, $E192)","v":2500},0,null,{"$f":"IF($E193>0, $E193, $E192)","v":2500},0,{"$f":"K203-H203","v":0},{"$f":"IF(ISERROR(L203/H203), \"\", L203/H203)","v":""}]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION",null,null,"Fixed Rate Riders",null,2.0099999999999998,1,2.0099999999999998,2.0099999999999998,{"$f":"G204","v":1},{"$f":"J204*I204","v":2.0099999999999998},0,0]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION",null,null,"Volumetric Rate Riders",null,0.72899999999999998,{"$f":"IF($E193>0, $E193, $E192)","v":2500},1822.5,0.67009999999999992,{"$f":"IF($E193>0, $E193, $E192)","v":2500},1675.2499999999998,-147.25000000000023,-8.079561042524018E-2]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","ST_A",{"$f":"B32","v":3},"Sub-Total A (excluding pass through)",null,null,null,{"$f":"SUM(H200:H205)","v":8940.119999999999},null,null,{"$f":"SUM(K200:K205)","v":8878.2999999999993},-61.819999999999709,{"$f":"IF((H206)=0,\"\",(L206/H206))","v":-6.91489599692171E-3}]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION",null,null,"Line Losses on Cost of Power",null,{"$f":"IF((E192*12>=150000), 0, IF(E191=\"RPP\",(F223*0.65+F224*0.17+F225*0.18),IF(E191=\"Non-RPP (Retailer)\",F226,F227)))","v":0},{"$f":"IF(F207=0, 0, $E192*E194-E192)","v":0},{"$f":"G207*F207","v":0},{"$f":"IF((E192*12>=150000), 0, IF(E191=\"RPP\",(I223*0.65+I224*0.17+I225*0.18),IF(E191=\"Non-RPP (Retailer)\",I226,I227)))","v":0},{"$f":"IF(I207=0, 0, E192*E195-E192)","v":0},{"$f":"J207*I207","v":0},{"$f":"K207-H207","v":0},{"$f":"IF(ISERROR(L207/H207), \"\", L207/H207)","v":""}]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION",null,null,"Total Deferral/Variance Account Rate Riders",null,0,{"$f":"IF($E193>0, $E193, $E192)","v":2500},0,0,{"$f":"IF($E193>0, $E193, $E192)","v":2500},0,0,""]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION",null,null,"CBR Class B Rate Riders",null,0,{"$f":"IF($E193>0, $E193, $E192)","v":2500},{"$f":"G209*F209","v":0},0,{"$f":"IF($E193>0, $E193, $E192)","v":2500},{"$f":"J209*I209","v":0},0,""]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION",null,null,"GA Rate Riders",null,0,{"$f":"E192","v":1095000},{"$f":"G210*F210","v":0},0,{"$f":"E192","v":1095000},0,0,""]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION",null,null,"Low Voltage Service Charge",null,0,{"$f":"IF($E193>0, $E193, $E192)","v":2500},0,null,{"$f":"IF($E193>0, $E193, $E192)","v":2500},0,0,""]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION",null,null,"Smart Meter Entity Charge (if applicable)",null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"RESIDENTIAL\", E190))=TRUE, ISNUMBER(SEARCH(\"GENERAL SERVICE LESS THAN 50\", E190))=TRUE), SME, 0)","v":0},1,{"$f":"G212*F212","v":0},{"$f":"IF(OR(ISNUMBER(SEARCH(\"RESIDENTIAL\", E190))=TRUE, ISNUMBER(SEARCH(\"GENERAL SERVICE LESS THAN 50\", E190))=TRUE), SME, 0)","v":0},1,{"$f":"J212*I212","v":0},0,{"$f":"IF(ISERROR(L212/H212), \"\", L212/H212)","v":""}]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION",null,null,"Additional Fixed Rate Riders ",null,0,1,0,0,1,{"$f":"J213*I213","v":0},{"$f":"K213-H213","v":0},{"$f":"IF(ISERROR(L213/H213), \"\", L213/H213)","v":""}]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION",null,null,"Additional Volumetric Rate Riders ",null,null,{"$f":"IF($E193>0, $E193, $E192)","v":2500},{"$f":"G214*F214","v":0},0,{"$f":"IF($E193>0, $E193, $E192)","v":2500},{"$f":"J214*I214","v":0},0,{"$f":"IF(ISERROR(L214/H214), \"\", L214/H214)","v":""}]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","ST_B",{"$f":"B32","v":3},"Sub-Total B - Distribution (includes Sub-Total A)",null,null,null,{"$f":"SUM(H206:H214)","v":8940.119999999999},null,null,{"$f":"SUM(K206:K214)","v":8878.2999999999993},-61.819999999999709,{"$f":"IF((H215)=0,\"\",(L215/H215))","v":-6.91489599692171E-3}]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION",null,null,"RTSR - Network",null,2.9458000000000002,{"$f":"IF($E193>0, $E193, $E192*$E194)","v":2500},{"$f":"G216*F216","v":7364.5000000000009},3.0533000000000001,{"$f":"IF($E193>0, $E193, $E192*$E195)","v":2500},{"$f":"J216*I216","v":7633.25},268.74999999999909,{"$f":"IF(ISERROR(L216/H216), \"\", L216/H216)","v":3.649263358001209E-2},{"$f":"IF(ISERROR(ABS(M216)), \"\", IF(ABS(M216)>=4%, \"In the manager's summary, discuss the reasoning for the change in RTSR rates\", \"\"))","v":""}]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION",null,null,"RTSR - Connection and/or Line and Transformation Connection",null,2.8026,{"$f":"IF($E193>0, $E193, $E192*$E194)","v":2500},{"$f":"G217*F217","v":7006.5},2.9279999999999999,{"$f":"IF($E193>0, $E193, $E192*$E195)","v":2500},{"$f":"J217*I217","v":7320},313.5,{"$f":"IF(ISERROR(L217/H217), \"\", L217/H217)","v":4.4744166131449367E-2},{"$f":"IF(ISERROR(ABS(M217)), \"\", IF(ABS(M217)>=4%, \"In the manager's summary, discuss the reasoning for the change in RTSR rates\", \"\"))","v":"In the manager's summary, discuss the reasoning for the change in RTSR rates"}]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","ST_C",{"$f":"B32","v":3},"Sub-Total C - Delivery (including Sub-Total B)",null,null,null,{"$f":"SUM(H215:H217)","v":23311.119999999999},null,null,{"$f":"SUM(K215:K217)","v":23831.55},520.43000000000029,{"$f":"IF((H218)=0,\"\",(L218/H218))","v":2.2325396634739141E-2}]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION",null,null,"Wholesale Market Service Charge (WMSC)",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$E$14),'[2]17. Regulatory Charges'!$D$15+'[2]17. Regulatory Charges'!$D$16,'[2]17. Regulatory Charges'!$E$15+'[2]17. Regulatory Charges'!$E$16)","v":3.4000000000000002E-3},{"$f":"E192*E194","v":1129492.5},{"$f":"G219*F219","v":3840.2745000000004},{"$f":"'[2]17. Regulatory Charges'!$E$15+'[2]17. Regulatory Charges'!$E$16","v":3.4000000000000002E-3},{"$f":"E192*E195","v":1129492.5},{"$f":"J219*I219","v":3840.2745000000004},0,{"$f":"IF(ISERROR(L219/H219), \"\", L219/H219)","v":0}]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION",null,null,"Rural and Remote Rate Protection (RRRP)",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$D$14),'[2]17. Regulatory Charges'!$D$17,'[2]17. Regulatory Charges'!$E$17)","v":5.0000000000000001E-4},{"$f":"E192*E194","v":1129492.5},564.74625000000003,{"$f":"'[2]17. Regulatory Charges'!$E$17","v":5.0000000000000001E-4},{"$f":"E192*E195","v":1129492.5},564.74625000000003,0,0]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION",null,null,"Standard Supply Service Charge",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$D$14),'[2]17. Regulatory Charges'!$D$18,'[2]17. Regulatory Charges'!$E$18)","v":0.25},1,0.25,{"$f":"'[2]17. Regulatory Charges'!$E$18","v":0.25},1,0.25,0,0]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION",null,null,"Ontario Electricity Support Program \n(OESP) "]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","RPP",null,"TOU - Off Peak",null,{"$f":"OffPeak","v":6.5000000000000002E-2},{"$f":"IF(AND(E192*12>=150000),0.65*E192*E194,0.65*E192)","v":734170.12500000012},47721.05812500001,{"$f":"OffPeak","v":6.5000000000000002E-2},{"$f":"IF(AND(E192*12>=150000),0.65*E192*E195,0.65*E192)","v":734170.12500000012},47721.05812500001,{"$f":"K223-H223","v":0},0]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","RPP",null,"TOU - Mid Peak",null,{"$f":"MidPeak","v":9.4E-2},{"$f":"IF(AND(E192*12>=150000),0.17*E192*E194,0.17*E192)","v":192013.72500000001},18049.290150000001,{"$f":"MidPeak","v":9.4E-2},{"$f":"IF(AND(E192*12>=150000),0.17*E192*E195,0.17*E192)","v":192013.72500000001},18049.290150000001,{"$f":"K224-H224","v":0},0]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","RPP",null,"TOU - On Peak",null,{"$f":"OnPeak","v":0.13400000000000001},{"$f":"IF(AND(E192*12>=150000),0.18*E192*E194,0.18*E192)","v":203308.65000000002},27243.359100000005,{"$f":"OnPeak","v":0.13400000000000001},{"$f":"IF(AND(E192*12>=150000),0.18*E192*E195,0.18*E192)","v":203308.65000000002},27243.359100000005,{"$f":"K225-H225","v":0},0]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"Non-RPP Retailer Avg. Price",null,0.1101,{"$f":"IF(AND(E192*12>=150000),E192*E194,E192)","v":1129492.5},{"$f":"G226*F226","v":124357.12425000001},{"$f":"F226","v":0.1101},{"$f":"IF(AND(E192*12>=150000),E192*E195,E192)","v":1129492.5},{"$f":"J226*I226","v":124357.12425000001},{"$f":"K226-H226","v":0},0]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","Non-RPP (Other)",null,"Average IESO Wholesale Market Price",null,0.1101,{"$f":"IF(AND(E192*12>=150000),E192*E194,E192)","v":1129492.5},{"$f":"G227*F227","v":124357.12425000001},{"$f":"F227","v":0.1101},{"$f":"IF(AND(E192*12>=150000),E192*E195,E192)","v":1129492.5},{"$f":"J227*I227","v":124357.12425000001},{"$f":"K227-H227","v":0},0]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION"]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","RPP",null,"Total Bill on TOU (before Taxes)",null,null,null,{"$f":"SUM(H219:H225,H218)","v":120730.09812500002},null,null,{"$f":"SUM(K219:K225,K218)","v":121250.52812500003},{"$f":"K229-H229","v":520.43000000000757},{"$f":"IF((H229)=0,\"\",(L229/H229))","v":4.3106897789577815E-3}]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","RPP",null,"HST",null,0.13,null,{"$f":"H229*F230","v":15694.912756250003},0.13,null,{"$f":"K229*I230","v":15762.568656250003},{"$f":"K230-H230","v":67.655899999999747},{"$f":"IF((H230)=0,\"\",(L230/H230))","v":4.3106897789577025E-3}]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","RPP",null,"8% Rebate",null,0.08,null,0,0.08,null,0,{"$f":"K231-H231","v":0}]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","RPP_TOTAL",null,"Total Bill on TOU",null,null,null,{"$f":"H229+H230+H231","v":136425.01088125003},null,null,{"$f":"K229+K230+K231","v":137013.09678125003},{"$f":"K232-H232","v":588.08590000000549},{"$f":"IF((H232)=0,\"\",(L232/H232))","v":4.3106897789577589E-3}]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","RPP"]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"Total Bill on Non-RPP Avg. Price",null,null,null,{"$f":"SUM(H226,H219:H222,H218)","v":152073.51500000001},null,null,{"$f":"SUM(K226,K219:K222,K218)","v":152593.94500000001},{"$f":"K234-H234","v":520.42999999999302},{"$f":"IF((H234)=0,\"\",(L234/H234))","v":3.4222264146389525E-3}]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"HST",null,0.13,null,{"$f":"H234*F235","v":19769.556950000002},0.13,null,{"$f":"K234*I235","v":19837.21285},{"$f":"K235-H235","v":67.655899999997928},{"$f":"IF((H235)=0,\"\",(L235/H235))","v":3.4222264146388935E-3}]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"8% Rebate",null,0.08,null,0,0.08,null,0]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","Non-RPP (Retailer)_TOTAL",null,"Total Bill on Non-RPP Avg. Price",null,null,null,{"$f":"SUM(H234,H235)","v":171843.07195000001},null,null,{"$f":"SUM(K234,K235)","v":172431.15785000002},{"$f":"K237-H237","v":588.08590000000549},{"$f":"IF((H237)=0,\"\",(L237/H237))","v":3.4222264146390306E-3}]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","Non-RPP (Retailer)"]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","Non-RPP (Other)",null,"Total Bill on Average IESO Wholesale Market Price",null,null,null,{"$f":"SUM(H227,H219:H222,H218)","v":152073.51500000001},null,null,{"$f":"SUM(K227,K219:K222,K218)","v":152593.94500000001},{"$f":"K239-H239","v":520.42999999999302},{"$f":"IF((H239)=0,\"\",(L239/H239))","v":3.4222264146389525E-3}]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","Non-RPP (Other)",null,"HST",null,0.13,null,{"$f":"H239*F240","v":19769.556950000002},0.13,null,{"$f":"K239*I240","v":19837.21285},{"$f":"K240-H240","v":67.655899999997928},{"$f":"IF((H240)=0,\"\",(L240/H240))","v":3.4222264146388935E-3}]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","Non-RPP (Other)",null,"8% Rebate",null,0.08,null,0,0.08,null,0]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","Non-RPP (Other)_TOTAL",{"$f":"B32","v":3},"Total Bill on Average IESO Wholesale Market Price",null,null,null,{"$f":"SUM(H239,H240)","v":171843.07195000001},null,null,{"$f":"SUM(K239,K240)","v":172431.15785000002},{"$f":"K242-H242","v":588.08590000000549},{"$f":"IF((H242)=0,\"\",(L242/H242))","v":3.4222264146390306E-3}]
["GENERAL SERVICE 50 to 4,999 kW SERVICE CLASSIFICATION","Non-RPP (Other)"]
[]
[]
[null,null,null,"Customer Class:",{"$f":"D33","v":"GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION"},null,null,null,null,null,{"$f":"IF(N33=\"DEMAND - INTERVAL\",\"RTSR - INTERVAL METERED\",\"\")","v":""},null,null,null,null,null,null,null,null,"X"]
[null,null,null,"RPP / Non-RPP:",{"$f":"H33","v":"Non-RPP (Other)"}]
[null,null,null,"Consumption",{"$f":"K33","v":1095000},"kWh"]
[null,null,null,"Demand",{"$f":"L33","v":2500},"kW"]
[null,null,null,"Current Loss Factor",{"$f":"I33","v":1.0315000000000001}]
[null,null,null,"Proposed/Approved Loss Factor",{"$f":"J33","v":1.0315000000000001}]
[]
[null,null,null,null,null,"Current OEB-Approved",null,null,"Proposed",null,null,"Impact"]
[null,null,null,null,null,"Rate","Volume","Charge","Rate","Volume","Charge","$ Change","% Change"]
[null,null,null,null,null,"($)",null,"($)","($)",null,"($)"]
[{"$f":"$E246","v":"GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION"},null,null,"Monthly Service Charge",null,2199.58,1,{"$f":"G256*F256","v":2199.58},2225.9699999999998,{"$f":"G256","v":1},{"$f":"J256*I256","v":2225.9699999999998},{"$f":"K256-H256","v":26.389999999999873},{"$f":"IF(ISERROR(L256/H256), \"\", L256/H256)","v":1.1997745024049988E-2}]
[{"$f":"A256","v":"GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION"},null,null,"Distribution Volumetric Rate",null,3.8424,{"$f":"IF($E249>0, $E249, $E248)","v":2500},{"$f":"G257*F257","v":9606},3.8885000000000001,{"$f":"IF($E249>0, $E249, $E248)","v":2500},{"$f":"J257*I257","v":9721.25},115.25,{"$f":"IF(ISERROR(L257/H257), \"\", L257/H257)","v":1.1997709764730377E-2}]
[{"$f":"A257","v":"GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION"},null,null,"RRRP Credit",null,null,{"$f":"IF($E249>0, $E249, $E248)","v":2500},0,null,{"$f":"IF($E249>0, $E249, $E248)","v":2500},0]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION",null,null,"DRP Adjustment",null,null,{"$f":"IF($E249>0, $E249, $E248)","v":2500},0,null,{"$f":"IF($E249>0, $E249, $E248)","v":2500},0,{"$f":"K259-H259","v":0},{"$f":"IF(ISERROR(L259/H259), \"\", L259/H259)","v":""}]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION",null,null,"Fixed Rate Riders",null,27.46,1,27.46,27.46,{"$f":"G260","v":1},{"$f":"J260*I260","v":27.46},0,0]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION",null,null,"Volumetric Rate Riders",null,0.40260000000000001,{"$f":"IF($E249>0, $E249, $E248)","v":2500},1006.5,0.3679,{"$f":"IF($E249>0, $E249, $E248)","v":2500},919.75,-86.75,-8.6189766517635366E-2]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION","ST_A",{"$f":"B33","v":4},"Sub-Total A (excluding pass through)",null,null,null,{"$f":"SUM(H256:H261)","v":12839.539999999999},null,null,{"$f":"SUM(K256:K261)","v":12894.429999999998},54.889999999999418,{"$f":"IF((H262)=0,\"\",(L262/H262))","v":4.2750752752824025E-3}]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION",null,null,"Line Losses on Cost of Power",null,{"$f":"IF((E248*12>=150000), 0, IF(E247=\"RPP\",(F279*0.65+F280*0.17+F281*0.18),IF(E247=\"Non-RPP (Retailer)\",F282,F283)))","v":0},{"$f":"IF(F263=0, 0, $E248*E250-E248)","v":0},{"$f":"G263*F263","v":0},{"$f":"IF((E248*12>=150000), 0, IF(E247=\"RPP\",(I279*0.65+I280*0.17+I281*0.18),IF(E247=\"Non-RPP (Retailer)\",I282,I283)))","v":0},{"$f":"IF(I263=0, 0, E248*E251-E248)","v":0},{"$f":"J263*I263","v":0},{"$f":"K263-H263","v":0},{"$f":"IF(ISERROR(L263/H263), \"\", L263/H263)","v":""}]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION",null,null,"Total Deferral/Variance Account Rate Riders",null,0,{"$f":"IF($E249>0, $E249, $E248)","v":2500},0,0,{"$f":"IF($E249>0, $E249, $E248)","v":2500},0,0,""]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION",null,null,"CBR Class B Rate Riders",null,0,{"$f":"IF($E249>0, $E249, $E248)","v":2500},{"$f":"G265*F265","v":0},0,{"$f":"IF($E249>0, $E249, $E248)","v":2500},{"$f":"J265*I265","v":0},0,""]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION",null,null,"GA Rate Riders",null,0,{"$f":"E248","v":1095000},{"$f":"G266*F266","v":0},0,{"$f":"E248","v":1095000},0,0,""]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION",null,null,"Low Voltage Service Charge",null,0,{"$f":"IF($E249>0, $E249, $E248)","v":2500},0,null,{"$f":"IF($E249>0, $E249, $E248)","v":2500},0,0,""]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION",null,null,"Smart Meter Entity Charge (if applicable)",null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"RESIDENTIAL\", E246))=TRUE, ISNUMBER(SEARCH(\"GENERAL SERVICE LESS THAN 50\", E246))=TRUE), SME, 0)","v":0},1,{"$f":"G268*F268","v":0},{"$f":"IF(OR(ISNUMBER(SEARCH(\"RESIDENTIAL\", E246))=TRUE, ISNUMBER(SEARCH(\"GENERAL SERVICE LESS THAN 50\", E246))=TRUE), SME, 0)","v":0},1,{"$f":"J268*I268","v":0},0,{"$f":"IF(ISERROR(L268/H268), \"\", L268/H268)","v":""}]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION",null,null,"Additional Fixed Rate Riders ",null,0,1,0,0,1,{"$f":"J269*I269","v":0},{"$f":"K269-H269","v":0},{"$f":"IF(ISERROR(L269/H269), \"\", L269/H269)","v":""}]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION",null,null,"Additional Volumetric Rate Riders ",null,null,{"$f":"IF($E249>0, $E249, $E248)","v":2500},{"$f":"G270*F270","v":0},0,{"$f":"IF($E249>0, $E249, $E248)","v":2500},{"$f":"J270*I270","v":0},0,{"$f":"IF(ISERROR(L270/H270), \"\", L270/H270)","v":""}]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION","ST_B",{"$f":"B33","v":4},"Sub-Total B - Distribution (includes Sub-Total A)",null,null,null,{"$f":"SUM(H262:H270)","v":12839.539999999999},null,null,{"$f":"SUM(K262:K270)","v":12894.429999999998},54.889999999999418,{"$f":"IF((H271)=0,\"\",(L271/H271))","v":4.2750752752824025E-3}]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION",null,null,"RTSR - Network",null,3.4007000000000001,{"$f":"IF($E249>0, $E249, $E248*$E250)","v":2500},{"$f":"G272*F272","v":8501.75},3.5247999999999999,{"$f":"IF($E249>0, $E249, $E248*$E251)","v":2500},{"$f":"J272*I272","v":8812},310.25,{"$f":"IF(ISERROR(L272/H272), \"\", L272/H272)","v":3.6492486840944513E-2},{"$f":"IF(ISERROR(ABS(M272)), \"\", IF(ABS(M272)>=4%, \"In the manager's summary, discuss the reasoning for the change in RTSR rates\", \"\"))","v":""}]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION",null,null,"RTSR - Connection and/or Line and Transformation Connection",null,2.9645999999999999,{"$f":"IF($E249>0, $E249, $E248*$E250)","v":2500},{"$f":"G273*F273","v":7411.5},3.0973000000000002,{"$f":"IF($E249>0, $E249, $E248*$E251)","v":2500},{"$f":"J273*I273","v":7743.25},331.75,{"$f":"IF(ISERROR(L273/H273), \"\", L273/H273)","v":4.4761519260608514E-2},{"$f":"IF(ISERROR(ABS(M273)), \"\", IF(ABS(M273)>=4%, \"In the manager's summary, discuss the reasoning for the change in RTSR rates\", \"\"))","v":"In the manager's summary, discuss the reasoning for the change in RTSR rates"}]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION","ST_C",{"$f":"B33","v":4},"Sub-Total C - Delivery (including Sub-Total B)",null,null,null,{"$f":"SUM(H271:H273)","v":28752.79},null,null,{"$f":"SUM(K271:K273)","v":29449.68},696.88999999999942,{"$f":"IF((H274)=0,\"\",(L274/H274))","v":2.4237300102007472E-2}]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION",null,null,"Wholesale Market Service Charge (WMSC)",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$E$14),'[2]17. Regulatory Charges'!$D$15+'[2]17. Regulatory Charges'!$D$16,'[2]17. Regulatory Charges'!$E$15+'[2]17. Regulatory Charges'!$E$16)","v":3.4000000000000002E-3},{"$f":"E248*E250","v":1129492.5},{"$f":"G275*F275","v":3840.2745000000004},{"$f":"'[2]17. Regulatory Charges'!$E$15+'[2]17. Regulatory Charges'!$E$16","v":3.4000000000000002E-3},{"$f":"E248*E251","v":1129492.5},{"$f":"J275*I275","v":3840.2745000000004},0,{"$f":"IF(ISERROR(L275/H275), \"\", L275/H275)","v":0}]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION",null,null,"Rural and Remote Rate Protection (RRRP)",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$D$14),'[2]17. Regulatory Charges'!$D$17,'[2]17. Regulatory Charges'!$E$17)","v":5.0000000000000001E-4},{"$f":"E248*E250","v":1129492.5},564.74625000000003,{"$f":"'[2]17. Regulatory Charges'!$E$17","v":5.0000000000000001E-4},{"$f":"E248*E251","v":1129492.5},564.74625000000003,0,0]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION",null,null,"Standard Supply Service Charge",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$D$14),'[2]17. Regulatory Charges'!$D$18,'[2]17. Regulatory Charges'!$E$18)","v":0.25},1,0.25,{"$f":"'[2]17. Regulatory Charges'!$E$18","v":0.25},1,0.25,0,0]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION",null,null,"Ontario Electricity Support Program \n(OESP) "]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION","RPP",null,"TOU - Off Peak",null,{"$f":"OffPeak","v":6.5000000000000002E-2},{"$f":"IF(AND(E248*12>=150000),0.65*E248*E250,0.65*E248)","v":734170.12500000012},47721.05812500001,{"$f":"OffPeak","v":6.5000000000000002E-2},{"$f":"IF(AND(E248*12>=150000),0.65*E248*E251,0.65*E248)","v":734170.12500000012},47721.05812500001,{"$f":"K279-H279","v":0},0]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION","RPP",null,"TOU - Mid Peak",null,{"$f":"MidPeak","v":9.4E-2},{"$f":"IF(AND(E248*12>=150000),0.17*E248*E250,0.17*E248)","v":192013.72500000001},18049.290150000001,{"$f":"MidPeak","v":9.4E-2},{"$f":"IF(AND(E248*12>=150000),0.17*E248*E251,0.17*E248)","v":192013.72500000001},18049.290150000001,{"$f":"K280-H280","v":0},0]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION","RPP",null,"TOU - On Peak",null,{"$f":"OnPeak","v":0.13400000000000001},{"$f":"IF(AND(E248*12>=150000),0.18*E248*E250,0.18*E248)","v":203308.65000000002},27243.359100000005,{"$f":"OnPeak","v":0.13400000000000001},{"$f":"IF(AND(E248*12>=150000),0.18*E248*E251,0.18*E248)","v":203308.65000000002},27243.359100000005,{"$f":"K281-H281","v":0},0]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"Non-RPP Retailer Avg. Price",null,0.1101,{"$f":"IF(AND(E248*12>=150000),E248*E250,E248)","v":1129492.5},{"$f":"G282*F282","v":124357.12425000001},{"$f":"F282","v":0.1101},{"$f":"IF(AND(E248*12>=150000),E248*E251,E248)","v":1129492.5},{"$f":"J282*I282","v":124357.12425000001},{"$f":"K282-H282","v":0},0]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION","Non-RPP (Other)",null,"Average IESO Wholesale Market Price",null,0.1101,{"$f":"IF(AND(E248*12>=150000),E248*E250,E248)","v":1129492.5},{"$f":"G283*F283","v":124357.12425000001},{"$f":"F283","v":0.1101},{"$f":"IF(AND(E248*12>=150000),E248*E251,E248)","v":1129492.5},{"$f":"J283*I283","v":124357.12425000001},{"$f":"K283-H283","v":0},0]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION"]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION","RPP",null,"Total Bill on TOU (before Taxes)",null,null,null,{"$f":"SUM(H275:H281,H274)","v":126171.76812500003},null,null,{"$f":"SUM(K275:K281,K274)","v":126868.65812500002},{"$f":"K285-H285","v":696.88999999998487},{"$f":"IF((H285)=0,\"\",(L285/H285))","v":5.523343378287025E-3}]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION","RPP",null,"HST",null,0.13,null,{"$f":"H285*F286","v":16402.329856250006},0.13,null,{"$f":"K285*I286","v":16492.925556250004},{"$f":"K286-H286","v":90.595699999998033},{"$f":"IF((H286)=0,\"\",(L286/H286))","v":5.5233433782870241E-3}]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION","RPP",null,"8% Rebate",null,0.08,null,0,0.08,null,0,{"$f":"K287-H287","v":0}]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION","RPP_TOTAL",null,"Total Bill on TOU",null,null,null,{"$f":"H285+H286+H287","v":142574.09798125003},null,null,{"$f":"K285+K286+K287","v":143361.58368125002},{"$f":"K288-H288","v":787.48569999999017},{"$f":"IF((H288)=0,\"\",(L288/H288))","v":5.5233433782870761E-3}]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION","RPP"]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"Total Bill on Non-RPP Avg. Price",null,null,null,{"$f":"SUM(H282,H275:H278,H274)","v":157515.185},null,null,{"$f":"SUM(K282,K275:K278,K274)","v":158212.07500000001},{"$f":"K290-H290","v":696.89000000001397},{"$f":"IF((H290)=0,\"\",(L290/H290))","v":4.4242718567102848E-3}]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"HST",null,0.13,null,{"$f":"H290*F291","v":20476.974050000001},0.13,null,{"$f":"K290*I291","v":20567.569750000002},{"$f":"K291-H291","v":90.595700000001671},{"$f":"IF((H291)=0,\"\",(L291/H291))","v":4.424271856710277E-3}]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"8% Rebate",null,0.08,null,0,0.08,null,0]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION","Non-RPP (Retailer)_TOTAL",null,"Total Bill on Non-RPP Avg. Price",null,null,null,{"$f":"SUM(H290,H291)","v":177992.15904999999},null,null,{"$f":"SUM(K290,K291)","v":178779.64475000001},{"$f":"K293-H293","v":787.48570000001928},{"$f":"IF((H293)=0,\"\",(L293/H293))","v":4.4242718567103047E-3}]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION","Non-RPP (Retailer)"]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION","Non-RPP (Other)",null,"Total Bill on Average IESO Wholesale Market Price",null,null,null,{"$f":"SUM(H283,H275:H278,H274)","v":157515.185},null,null,{"$f":"SUM(K283,K275:K278,K274)","v":158212.07500000001},{"$f":"K295-H295","v":696.89000000001397},{"$f":"IF((H295)=0,\"\",(L295/H295))","v":4.4242718567102848E-3}]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION","Non-RPP (Other)",null,"HST",null,0.13,null,{"$f":"H295*F296","v":20476.974050000001},0.13,null,{"$f":"K295*I296","v":20567.569750000002},{"$f":"K296-H296","v":90.595700000001671},{"$f":"IF((H296)=0,\"\",(L296/H296))","v":4.424271856710277E-3}]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION","Non-RPP (Other)",null,"8% Rebate",null,0.08,null,0,0.08,null,0]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION","Non-RPP (Other)_TOTAL",{"$f":"B33","v":4},"Total Bill on Average IESO Wholesale Market Price",null,null,null,{"$f":"SUM(H295,H296)","v":177992.15904999999},null,null,{"$f":"SUM(K295,K296)","v":178779.64475000001},{"$f":"K298-H298","v":787.48570000001928},{"$f":"IF((H298)=0,\"\",(L298/H298))","v":4.4242718567103047E-3}]
["GENERAL SERVICE 1,000 TO 4,999 KW (CO-GENERATION) SERVICE CLASSIFICATION","Non-RPP (Other)"]
[]
[]
[null,null,null,"Customer Class:",{"$f":"D34","v":"STANDBY POWER SERVICE CLASSIFICATION"},null,null,null,null,null,{"$f":"IF(N34=\"DEMAND - INTERVAL\",\"RTSR - INTERVAL METERED\",\"\")","v":""},null,null,null,null,null,null,null,null,"X"]
[null,null,null,"RPP / Non-RPP:",{"$f":"H34","v":"Non-RPP (Other)"}]
[null,null,null,"Consumption",{"$f":"K34","v":0},"kWh"]
[null,null,null,"Demand",{"$f":"L34","v":3500},"kW"]
[null,null,null,"Current Loss Factor",{"$f":"I34","v":1.0315000000000001}]
[null,null,null,"Proposed/Approved Loss Factor",{"$f":"J34","v":1.0315000000000001}]
[]
[null,null,null,null,null,"Current OEB-Approved",null,null,"Proposed",null,null,"Impact"]
[null,null,null,null,null,"Rate","Volume","Charge","Rate","Volume","Charge","$ Change","% Change"]
[null,null,null,null,null,"($)",null,"($)","($)",null,"($)"]
[{"$f":"$E302","v":"STANDBY POWER SERVICE CLASSIFICATION"},null,null,"Monthly Service Charge",null,0,1,{"$f":"G312*F312","v":0},0,{"$f":"G312","v":1},{"$f":"J312*I312","v":0},{"$f":"K312-H312","v":0},{"$f":"IF(ISERROR(L312/H312), \"\", L312/H312)","v":""}]
[{"$f":"A312","v":"STANDBY POWER SERVICE CLASSIFICATION"},null,null,"Distribution Volumetric Rate",null,3.1736,{"$f":"IF($E305>0, $E305, $E304)","v":3500},{"$f":"G313*F313","v":11107.6},3.2117,{"$f":"IF($E305>0, $E305, $E304)","v":3500},{"$f":"J313*I313","v":11240.95},133.35000000000036,{"$f":"IF(ISERROR(L313/H313), \"\", L313/H313)","v":1.2005293672800637E-2}]
[{"$f":"A313","v":"STANDBY POWER SERVICE CLASSIFICATION"},null,null,"RRRP Credit",null,null,{"$f":"IF($E305>0, $E305, $E304)","v":3500},0,null,{"$f":"IF($E305>0, $E305, $E304)","v":3500},0]
["STANDBY POWER SERVICE CLASSIFICATION",null,null,"DRP Adjustment",null,null,{"$f":"IF($E305>0, $E305, $E304)","v":3500},0,null,{"$f":"IF($E305>0, $E305, $E304)","v":3500},0,{"$f":"K315-H315","v":0},{"$f":"IF(ISERROR(L315/H315), \"\", L315/H315)","v":""}]
["STANDBY POWER SERVICE CLASSIFICATION",null,null,"Fixed Rate Riders",null,0,1,0,0,{"$f":"G316","v":1},{"$f":"J316*I316","v":0},0,""]
["STANDBY POWER SERVICE CLASSIFICATION",null,null,"Volumetric Rate Riders",null,0.39420000000000005,{"$f":"IF($E305>0, $E305, $E304)","v":3500},1379.7000000000003,0.35950000000000004,{"$f":"IF($E305>0, $E305, $E304)","v":3500},1258.2500000000002,-121.45000000000005,-8.8026382546930501E-2]
["STANDBY POWER SERVICE CLASSIFICATION","ST_A",{"$f":"B34","v":5},"Sub-Total A (excluding pass through)",null,null,null,{"$f":"SUM(H312:H317)","v":12487.300000000001},null,null,{"$f":"SUM(K312:K317)","v":12499.2},11.899999999999636,{"$f":"IF((H318)=0,\"\",(L318/H318))","v":9.5296821570712924E-4}]
["STANDBY POWER SERVICE CLASSIFICATION",null,null,"Line Losses on Cost of Power",null,{"$f":"IF((E304*12>=150000), 0, IF(E303=\"RPP\",(F335*0.65+F336*0.17+F337*0.18),IF(E303=\"Non-RPP (Retailer)\",F338,F339)))","v":0.1101},{"$f":"IF(F319=0, 0, $E304*E306-E304)","v":0},{"$f":"G319*F319","v":0},{"$f":"IF((E304*12>=150000), 0, IF(E303=\"RPP\",(I335*0.65+I336*0.17+I337*0.18),IF(E303=\"Non-RPP (Retailer)\",I338,I339)))","v":0.1101},{"$f":"IF(I319=0, 0, E304*E307-E304)","v":0},{"$f":"J319*I319","v":0},{"$f":"K319-H319","v":0},{"$f":"IF(ISERROR(L319/H319), \"\", L319/H319)","v":""}]
["STANDBY POWER SERVICE CLASSIFICATION",null,null,"Total Deferral/Variance Account Rate Riders",null,0,{"$f":"IF($E305>0, $E305, $E304)","v":3500},0,0,{"$f":"IF($E305>0, $E305, $E304)","v":3500},0,0,""]
["STANDBY POWER SERVICE CLASSIFICATION",null,null,"CBR Class B Rate Riders",null,0,{"$f":"IF($E305>0, $E305, $E304)","v":3500},{"$f":"G321*F321","v":0},0,{"$f":"IF($E305>0, $E305, $E304)","v":3500},{"$f":"J321*I321","v":0},0,""]
["STANDBY POWER SERVICE CLASSIFICATION",null,null,"GA Rate Riders",null,0,{"$f":"E304","v":0},{"$f":"G322*F322","v":0},0,{"$f":"E304","v":0},0,0,""]
["STANDBY POWER SERVICE CLASSIFICATION",null,null,"Low Voltage Service Charge",null,0,{"$f":"IF($E305>0, $E305, $E304)","v":3500},0,null,{"$f":"IF($E305>0, $E305, $E304)","v":3500},0,0,""]
["STANDBY POWER SERVICE CLASSIFICATION",null,null,"Smart Meter Entity Charge (if applicable)",null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"RESIDENTIAL\", E302))=TRUE, ISNUMBER(SEARCH(\"GENERAL SERVICE LESS THAN 50\", E302))=TRUE), SME, 0)","v":0},1,{"$f":"G324*F324","v":0},{"$f":"IF(OR(ISNUMBER(SEARCH(\"RESIDENTIAL\", E302))=TRUE, ISNUMBER(SEARCH(\"GENERAL SERVICE LESS THAN 50\", E302))=TRUE), SME, 0)","v":0},1,{"$f":"J324*I324","v":0},0,{"$f":"IF(ISERROR(L324/H324), \"\", L324/H324)","v":""}]
["STANDBY POWER SERVICE CLASSIFICATION",null,null,"Additional Fixed Rate Riders ",null,0,1,0,0,1,{"$f":"J325*I325","v":0},{"$f":"K325-H325","v":0},{"$f":"IF(ISERROR(L325/H325), \"\", L325/H325)","v":""}]
["STANDBY POWER SERVICE CLASSIFICATION",null,null,"Additional Volumetric Rate Riders ",null,null,{"$f":"IF($E305>0, $E305, $E304)","v":3500},{"$f":"G326*F326","v":0},0,{"$f":"IF($E305>0, $E305, $E304)","v":3500},{"$f":"J326*I326","v":0},0,{"$f":"IF(ISERROR(L326/H326), \"\", L326/H326)","v":""}]
["STANDBY POWER SERVICE CLASSIFICATION","ST_B",{"$f":"B34","v":5},"Sub-Total B - Distribution (includes Sub-Total A)",null,null,null,{"$f":"SUM(H318:H326)","v":12487.300000000001},null,null,{"$f":"SUM(K318:K326)","v":12499.2},11.899999999999636,{"$f":"IF((H327)=0,\"\",(L327/H327))","v":9.5296821570712924E-4}]
["STANDBY POWER SERVICE CLASSIFICATION",null,null,"RTSR - Network",null,0,{"$f":"IF($E305>0, $E305, $E304*$E306)","v":3500},{"$f":"G328*F328","v":0},0,{"$f":"IF($E305>0, $E305, $E304*$E307)","v":3500},{"$f":"J328*I328","v":0},0,{"$f":"IF(ISERROR(L328/H328), \"\", L328/H328)","v":""},{"$f":"IF(ISERROR(ABS(M328)), \"\", IF(ABS(M328)>=4%, \"In the manager's summary, discuss the reasoning for the change in RTSR rates\", \"\"))","v":""}]
["STANDBY POWER SERVICE CLASSIFICATION",null,null,"RTSR - Connection and/or Line and Transformation Connection",null,0,{"$f":"IF($E305>0, $E305, $E304*$E306)","v":3500},{"$f":"G329*F329","v":0},0,{"$f":"IF($E305>0, $E305, $E304*$E307)","v":3500},{"$f":"J329*I329","v":0},0,{"$f":"IF(ISERROR(L329/H329), \"\", L329/H329)","v":""},{"$f":"IF(ISERROR(ABS(M329)), \"\", IF(ABS(M329)>=4%, \"In the manager's summary, discuss the reasoning for the change in RTSR rates\", \"\"))","v":""}]
["STANDBY POWER SERVICE CLASSIFICATION","ST_C",{"$f":"B34","v":5},"Sub-Total C - Delivery (including Sub-Total B)",null,null,null,{"$f":"SUM(H327:H329)","v":12487.300000000001},null,null,{"$f":"SUM(K327:K329)","v":12499.2},11.899999999999636,{"$f":"IF((H330)=0,\"\",(L330/H330))","v":9.5296821570712924E-4}]
["STANDBY POWER SERVICE CLASSIFICATION",null,null,"Wholesale Market Service Charge (WMSC)",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$E$14),'[2]17. Regulatory Charges'!$D$15+'[2]17. Regulatory Charges'!$D$16,'[2]17. Regulatory Charges'!$E$15+'[2]17. Regulatory Charges'!$E$16)","v":3.4000000000000002E-3},{"$f":"E304*E306","v":0},{"$f":"G331*F331","v":0},{"$f":"'[2]17. Regulatory Charges'!$E$15+'[2]17. Regulatory Charges'!$E$16","v":3.4000000000000002E-3},{"$f":"E304*E307","v":0},{"$f":"J331*I331","v":0},0,{"$f":"IF(ISERROR(L331/H331), \"\", L331/H331)","v":""}]
["STANDBY POWER SERVICE CLASSIFICATION",null,null,"Rural and Remote Rate Protection (RRRP)",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$D$14),'[2]17. Regulatory Charges'!$D$17,'[2]17. Regulatory Charges'!$E$17)","v":5.0000000000000001E-4},{"$f":"E304*E306","v":0},0,{"$f":"'[2]17. Regulatory Charges'!$E$17","v":5.0000000000000001E-4},{"$f":"E304*E307","v":0},0,0,""]
["STANDBY POWER SERVICE CLASSIFICATION",null,null,"Standard Supply Service Charge",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$D$14),'[2]17. Regulatory Charges'!$D$18,'[2]17. Regulatory Charges'!$E$18)","v":0.25},1,0.25,{"$f":"'[2]17. Regulatory Charges'!$E$18","v":0.25},1,0.25,0,0]
["STANDBY POWER SERVICE CLASSIFICATION",null,null,"Ontario Electricity Support Program \n(OESP) "]
["STANDBY POWER SERVICE CLASSIFICATION","RPP",null,"TOU - Off Peak",null,{"$f":"OffPeak","v":6.5000000000000002E-2},{"$f":"IF(AND(E304*12>=150000),0.65*E304*E306,0.65*E304)","v":0},0,{"$f":"OffPeak","v":6.5000000000000002E-2},{"$f":"IF(AND(E304*12>=150000),0.65*E304*E307,0.65*E304)","v":0},0,{"$f":"K335-H335","v":0},""]
["STANDBY POWER SERVICE CLASSIFICATION","RPP",null,"TOU - Mid Peak",null,{"$f":"MidPeak","v":9.4E-2},{"$f":"IF(AND(E304*12>=150000),0.17*E304*E306,0.17*E304)","v":0},0,{"$f":"MidPeak","v":9.4E-2},{"$f":"IF(AND(E304*12>=150000),0.17*E304*E307,0.17*E304)","v":0},0,{"$f":"K336-H336","v":0},""]
["STANDBY POWER SERVICE CLASSIFICATION","RPP",null,"TOU - On Peak",null,{"$f":"OnPeak","v":0.13400000000000001},{"$f":"IF(AND(E304*12>=150000),0.18*E304*E306,0.18*E304)","v":0},0,{"$f":"OnPeak","v":0.13400000000000001},{"$f":"IF(AND(E304*12>=150000),0.18*E304*E307,0.18*E304)","v":0},0,{"$f":"K337-H337","v":0},""]
["STANDBY POWER SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"Non-RPP Retailer Avg. Price",null,0.1101,{"$f":"IF(AND(E304*12>=150000),E304*E306,E304)","v":0},{"$f":"G338*F338","v":0},{"$f":"F338","v":0.1101},{"$f":"IF(AND(E304*12>=150000),E304*E307,E304)","v":0},{"$f":"J338*I338","v":0},{"$f":"K338-H338","v":0},""]
["STANDBY POWER SERVICE CLASSIFICATION","Non-RPP (Other)",null,"Average IESO Wholesale Market Price",null,0.1101,{"$f":"IF(AND(E304*12>=150000),E304*E306,E304)","v":0},{"$f":"G339*F339","v":0},{"$f":"F339","v":0.1101},{"$f":"IF(AND(E304*12>=150000),E304*E307,E304)","v":0},{"$f":"J339*I339","v":0},{"$f":"K339-H339","v":0},""]
["STANDBY POWER SERVICE CLASSIFICATION"]
["STANDBY POWER SERVICE CLASSIFICATION","RPP",null,"Total Bill on TOU (before Taxes)",null,null,null,{"$f":"SUM(H331:H337,H330)","v":12487.550000000001},null,null,{"$f":"SUM(K331:K337,K330)","v":12499.45},{"$f":"K341-H341","v":11.899999999999636},{"$f":"IF((H341)=0,\"\",(L341/H341))","v":9.5294913734076216E-4}]
["STANDBY POWER SERVICE CLASSIFICATION","RPP",null,"HST",null,0.13,null,{"$f":"H341*F342","v":1623.3815000000002},0.13,null,{"$f":"K341*I342","v":1624.9285000000002},{"$f":"K342-H342","v":1.5470000000000255},{"$f":"IF((H342)=0,\"\",(L342/H342))","v":9.5294913734080705E-4}]
["STANDBY POWER SERVICE CLASSIFICATION","RPP",null,"8% Rebate",null,0.08,null,0,0.08,null,0,{"$f":"K343-H343","v":0}]
["STANDBY POWER SERVICE CLASSIFICATION","RPP_TOTAL",null,"Total Bill on TOU",null,null,null,{"$f":"H341+H342+H343","v":14110.931500000001},null,null,{"$f":"K341+K342+K343","v":14124.378500000001},{"$f":"K344-H344","v":13.447000000000116},{"$f":"IF((H344)=0,\"\",(L344/H344))","v":9.5294913734079968E-4}]
["STANDBY POWER SERVICE CLASSIFICATION","RPP"]
["STANDBY POWER SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"Total Bill on Non-RPP Avg. Price",null,null,null,{"$f":"SUM(H338,H331:H334,H330)","v":12487.550000000001},null,null,{"$f":"SUM(K338,K331:K334,K330)","v":12499.45},{"$f":"K346-H346","v":11.899999999999636},{"$f":"IF((H346)=0,\"\",(L346/H346))","v":9.5294913734076216E-4}]
["STANDBY POWER SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"HST",null,0.13,null,{"$f":"H346*F347","v":1623.3815000000002},0.13,null,{"$f":"K346*I347","v":1624.9285000000002},{"$f":"K347-H347","v":1.5470000000000255},{"$f":"IF((H347)=0,\"\",(L347/H347))","v":9.5294913734080705E-4}]
["STANDBY POWER SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"8% Rebate",null,0.08,null,0,0.08,null,0]
["STANDBY POWER SERVICE CLASSIFICATION","Non-RPP (Retailer)_TOTAL",null,"Total Bill on Non-RPP Avg. Price",null,null,null,{"$f":"SUM(H346,H347)","v":14110.931500000001},null,null,{"$f":"SUM(K346,K347)","v":14124.378500000001},{"$f":"K349-H349","v":13.447000000000116},{"$f":"IF((H349)=0,\"\",(L349/H349))","v":9.5294913734079968E-4}]
["STANDBY POWER SERVICE CLASSIFICATION","Non-RPP (Retailer)"]
["STANDBY POWER SERVICE CLASSIFICATION","Non-RPP (Other)",null,"Total Bill on Average IESO Wholesale Market Price",null,null,null,{"$f":"SUM(H339,H331:H334,H330)","v":12487.550000000001},null,null,{"$f":"SUM(K339,K331:K334,K330)","v":12499.45},{"$f":"K351-H351","v":11.899999999999636},{"$f":"IF((H351)=0,\"\",(L351/H351))","v":9.5294913734076216E-4}]
["STANDBY POWER SERVICE CLASSIFICATION","Non-RPP (Other)",null,"HST",null,0.13,null,{"$f":"H351*F352","v":1623.3815000000002},0.13,null,{"$f":"K351*I352","v":1624.9285000000002},{"$f":"K352-H352","v":1.5470000000000255},{"$f":"IF((H352)=0,\"\",(L352/H352))","v":9.5294913734080705E-4}]
["STANDBY POWER SERVICE CLASSIFICATION","Non-RPP (Other)",null,"8% Rebate",null,0.08,null,0,0.08,null,0]
["STANDBY POWER SERVICE CLASSIFICATION","Non-RPP (Other)_TOTAL",{"$f":"B34","v":5},"Total Bill on Average IESO Wholesale Market Price",null,null,null,{"$f":"SUM(H351,H352)","v":14110.931500000001},null,null,{"$f":"SUM(K351,K352)","v":14124.378500000001},{"$f":"K354-H354","v":13.447000000000116},{"$f":"IF((H354)=0,\"\",(L354/H354))","v":9.5294913734079968E-4}]
["STANDBY POWER SERVICE CLASSIFICATION","Non-RPP (Other)"]
[]
[]
[null,null,null,"Customer Class:",{"$f":"D35","v":"LARGE USE SERVICE CLASSIFICATION"},null,null,null,null,null,{"$f":"IF(N35=\"DEMAND - INTERVAL\",\"RTSR - INTERVAL METERED\",\"\")","v":""},null,null,null,null,null,null,null,null,"X"]
[null,null,null,"RPP / Non-RPP:",{"$f":"H35","v":"Non-RPP (Other)"}]
[null,null,null,"Consumption",{"$f":"K35","v":5600000},"kWh"]
[null,null,null,"Demand",{"$f":"L35","v":10700},"kW"]
[null,null,null,"Current Loss Factor",{"$f":"I35","v":1.0315000000000001}]
[null,null,null,"Proposed/Approved Loss Factor",{"$f":"J35","v":1.0315000000000001}]
[]
[null,null,null,null,null,"Current OEB-Approved",null,null,"Proposed",null,null,"Impact"]
[null,null,null,null,null,"Rate","Volume","Charge","Rate","Volume","Charge","$ Change","% Change"]
[null,null,null,null,null,"($)",null,"($)","($)",null,"($)"]
[{"$f":"$E358","v":"LARGE USE SERVICE CLASSIFICATION"},null,null,"Monthly Service Charge",null,20745.650000000001,1,{"$f":"G368*F368","v":20745.650000000001},20994.6,{"$f":"G368","v":1},{"$f":"J368*I368","v":20994.6},{"$f":"K368-H368","v":248.94999999999709},{"$f":"IF(ISERROR(L368/H368), \"\", L368/H368)","v":1.2000106046327643E-2}]
[{"$f":"A368","v":"LARGE USE SERVICE CLASSIFICATION"},null,null,"Distribution Volumetric Rate",null,2.3151000000000002,{"$f":"IF($E361>0, $E361, $E360)","v":10700},{"$f":"G369*F369","v":24771.570000000003},2.3429000000000002,{"$f":"IF($E361>0, $E361, $E360)","v":10700},{"$f":"J369*I369","v":25069.030000000002},297.45999999999913,{"$f":"IF(ISERROR(L369/H369), \"\", L369/H369)","v":1.2008120599542099E-2}]
[{"$f":"A369","v":"LARGE USE SERVICE CLASSIFICATION"},null,null,"RRRP Credit",null,null,{"$f":"IF($E361>0, $E361, $E360)","v":10700},0,null,{"$f":"IF($E361>0, $E361, $E360)","v":10700},0]
["LARGE USE SERVICE CLASSIFICATION",null,null,"DRP Adjustment",null,null,{"$f":"IF($E361>0, $E361, $E360)","v":10700},0,null,{"$f":"IF($E361>0, $E361, $E360)","v":10700},0,{"$f":"K371-H371","v":0},{"$f":"IF(ISERROR(L371/H371), \"\", L371/H371)","v":""}]
["LARGE USE SERVICE CLASSIFICATION",null,null,"Fixed Rate Riders",null,258.98,1,258.98,258.98,{"$f":"G372","v":1},{"$f":"J372*I372","v":258.98},0,0]
["LARGE USE SERVICE CLASSIFICATION",null,null,"Volumetric Rate Riders",null,0.81290000000000007,{"$f":"IF($E361>0, $E361, $E360)","v":10700},8698.0300000000007,0.86440000000000006,{"$f":"IF($E361>0, $E361, $E360)","v":10700},9249.08,551.04999999999927,6.3353426005658658E-2]
["LARGE USE SERVICE CLASSIFICATION","ST_A",{"$f":"B35","v":6},"Sub-Total A (excluding pass through)",null,null,null,{"$f":"SUM(H368:H373)","v":54474.23},null,null,{"$f":"SUM(K368:K373)","v":55571.69000000001},1097.4600000000064,{"$f":"IF((H374)=0,\"\",(L374/H374))","v":2.014640684228132E-2}]
["LARGE USE SERVICE CLASSIFICATION",null,null,"Line Losses on Cost of Power",null,{"$f":"IF((E360*12>=150000), 0, IF(E359=\"RPP\",(F391*0.65+F392*0.17+F393*0.18),IF(E359=\"Non-RPP (Retailer)\",F394,F395)))","v":0},{"$f":"IF(F375=0, 0, $E360*E362-E360)","v":0},{"$f":"G375*F375","v":0},{"$f":"IF((E360*12>=150000), 0, IF(E359=\"RPP\",(I391*0.65+I392*0.17+I393*0.18),IF(E359=\"Non-RPP (Retailer)\",I394,I395)))","v":0},{"$f":"IF(I375=0, 0, E360*E363-E360)","v":0},{"$f":"J375*I375","v":0},{"$f":"K375-H375","v":0},{"$f":"IF(ISERROR(L375/H375), \"\", L375/H375)","v":""}]
["LARGE USE SERVICE CLASSIFICATION",null,null,"Total Deferral/Variance Account Rate Riders",null,0,{"$f":"IF($E361>0, $E361, $E360)","v":10700},0,0,{"$f":"IF($E361>0, $E361, $E360)","v":10700},0,0,""]
["LARGE USE SERVICE CLASSIFICATION",null,null,"CBR Class B Rate Riders",null,0,{"$f":"IF($E361>0, $E361, $E360)","v":10700},{"$f":"G377*F377","v":0},0,{"$f":"IF($E361>0, $E361, $E360)","v":10700},{"$f":"J377*I377","v":0},0,""]
["LARGE USE SERVICE CLASSIFICATION",null,null,"GA Rate Riders",null,0,{"$f":"E360","v":5600000},{"$f":"G378*F378","v":0},0,{"$f":"E360","v":5600000},0,0,""]
["LARGE USE SERVICE CLASSIFICATION",null,null,"Low Voltage Service Charge",null,0,{"$f":"IF($E361>0, $E361, $E360)","v":10700},0,null,{"$f":"IF($E361>0, $E361, $E360)","v":10700},0,0,""]
["LARGE USE SERVICE CLASSIFICATION",null,null,"Smart Meter Entity Charge (if applicable)",null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"RESIDENTIAL\", E358))=TRUE, ISNUMBER(SEARCH(\"GENERAL SERVICE LESS THAN 50\", E358))=TRUE), SME, 0)","v":0},1,{"$f":"G380*F380","v":0},{"$f":"IF(OR(ISNUMBER(SEARCH(\"RESIDENTIAL\", E358))=TRUE, ISNUMBER(SEARCH(\"GENERAL SERVICE LESS THAN 50\", E358))=TRUE), SME, 0)","v":0},1,{"$f":"J380*I380","v":0},0,{"$f":"IF(ISERROR(L380/H380), \"\", L380/H380)","v":""}]
["LARGE USE SERVICE CLASSIFICATION",null,null,"Additional Fixed Rate Riders ",null,0,1,0,0,1,{"$f":"J381*I381","v":0},{"$f":"K381-H381","v":0},{"$f":"IF(ISERROR(L381/H381), \"\", L381/H381)","v":""}]
["LARGE USE SERVICE CLASSIFICATION",null,null,"Additional Volumetric Rate Riders ",null,null,{"$f":"IF($E361>0, $E361, $E360)","v":10700},{"$f":"G382*F382","v":0},0,{"$f":"IF($E361>0, $E361, $E360)","v":10700},{"$f":"J382*I382","v":0},0,{"$f":"IF(ISERROR(L382/H382), \"\", L382/H382)","v":""}]
["LARGE USE SERVICE CLASSIFICATION","ST_B",{"$f":"B35","v":6},"Sub-Total B - Distribution (includes Sub-Total A)",null,null,null,{"$f":"SUM(H374:H382)","v":54474.23},null,null,{"$f":"SUM(K374:K382)","v":55571.69000000001},1097.4600000000064,{"$f":"IF((H383)=0,\"\",(L383/H383))","v":2.014640684228132E-2}]
["LARGE USE SERVICE CLASSIFICATION",null,null,"RTSR - Network",null,0,{"$f":"IF($E361>0, $E361, $E360*$E362)","v":10700},{"$f":"G384*F384","v":0},0,{"$f":"IF($E361>0, $E361, $E360*$E363)","v":10700},{"$f":"J384*I384","v":0},0,{"$f":"IF(ISERROR(L384/H384), \"\", L384/H384)","v":""},{"$f":"IF(ISERROR(ABS(M384)), \"\", IF(ABS(M384)>=4%, \"In the manager's summary, discuss the reasoning for the change in RTSR rates\", \"\"))","v":""}]
["LARGE USE SERVICE CLASSIFICATION",null,null,"RTSR - Connection and/or Line and Transformation Connection",null,0,{"$f":"IF($E361>0, $E361, $E360*$E362)","v":10700},{"$f":"G385*F385","v":0},0,{"$f":"IF($E361>0, $E361, $E360*$E363)","v":10700},{"$f":"J385*I385","v":0},0,{"$f":"IF(ISERROR(L385/H385), \"\", L385/H385)","v":""},{"$f":"IF(ISERROR(ABS(M385)), \"\", IF(ABS(M385)>=4%, \"In the manager's summary, discuss the reasoning for the change in RTSR rates\", \"\"))","v":""}]
["LARGE USE SERVICE CLASSIFICATION","ST_C",{"$f":"B35","v":6},"Sub-Total C - Delivery (including Sub-Total B)",null,null,null,{"$f":"SUM(H383:H385)","v":54474.23},null,null,{"$f":"SUM(K383:K385)","v":55571.69000000001},1097.4600000000064,{"$f":"IF((H386)=0,\"\",(L386/H386))","v":2.014640684228132E-2}]
["LARGE USE SERVICE CLASSIFICATION",null,null,"Wholesale Market Service Charge (WMSC)",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$E$14),'[2]17. Regulatory Charges'!$D$15+'[2]17. Regulatory Charges'!$D$16,'[2]17. Regulatory Charges'!$E$15+'[2]17. Regulatory Charges'!$E$16)","v":3.4000000000000002E-3},{"$f":"E360*E362","v":5776400.0000000009},{"$f":"G387*F387","v":19639.760000000006},{"$f":"'[2]17. Regulatory Charges'!$E$15+'[2]17. Regulatory Charges'!$E$16","v":3.4000000000000002E-3},{"$f":"E360*E363","v":5776400.0000000009},{"$f":"J387*I387","v":19639.760000000006},0,{"$f":"IF(ISERROR(L387/H387), \"\", L387/H387)","v":0}]
["LARGE USE SERVICE CLASSIFICATION",null,null,"Rural and Remote Rate Protection (RRRP)",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$D$14),'[2]17. Regulatory Charges'!$D$17,'[2]17. Regulatory Charges'!$E$17)","v":5.0000000000000001E-4},{"$f":"E360*E362","v":5776400.0000000009},2888.2000000000007,{"$f":"'[2]17. Regulatory Charges'!$E$17","v":5.0000000000000001E-4},{"$f":"E360*E363","v":5776400.0000000009},2888.2000000000007,0,0]
["LARGE USE SERVICE CLASSIFICATION",null,null,"Standard Supply Service Charge",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$D$14),'[2]17. Regulatory Charges'!$D$18,'[2]17. Regulatory Charges'!$E$18)","v":0.25},1,0.25,{"$f":"'[2]17. Regulatory Charges'!$E$18","v":0.25},1,0.25,0,0]
["LARGE USE SERVICE CLASSIFICATION",null,null,"Ontario Electricity Support Program \n(OESP) "]
["LARGE USE SERVICE CLASSIFICATION","RPP",null,"TOU - Off Peak",null,{"$f":"OffPeak","v":6.5000000000000002E-2},{"$f":"IF(AND(E360*12>=150000),0.65*E360*E362,0.65*E360)","v":3754660.0000000005},244052.90000000005,{"$f":"OffPeak","v":6.5000000000000002E-2},{"$f":"IF(AND(E360*12>=150000),0.65*E360*E363,0.65*E360)","v":3754660.0000000005},244052.90000000005,{"$f":"K391-H391","v":0},0]
["LARGE USE SERVICE CLASSIFICATION","RPP",null,"TOU - Mid Peak",null,{"$f":"MidPeak","v":9.4E-2},{"$f":"IF(AND(E360*12>=150000),0.17*E360*E362,0.17*E360)","v":981988.00000000023},92306.872000000018,{"$f":"MidPeak","v":9.4E-2},{"$f":"IF(AND(E360*12>=150000),0.17*E360*E363,0.17*E360)","v":981988.00000000023},92306.872000000018,{"$f":"K392-H392","v":0},0]
["LARGE USE SERVICE CLASSIFICATION","RPP",null,"TOU - On Peak",null,{"$f":"OnPeak","v":0.13400000000000001},{"$f":"IF(AND(E360*12>=150000),0.18*E360*E362,0.18*E360)","v":1039752.0000000001},139326.76800000001,{"$f":"OnPeak","v":0.13400000000000001},{"$f":"IF(AND(E360*12>=150000),0.18*E360*E363,0.18*E360)","v":1039752.0000000001},139326.76800000001,{"$f":"K393-H393","v":0},0]
["LARGE USE SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"Non-RPP Retailer Avg. Price",null,0.1101,{"$f":"IF(AND(E360*12>=150000),E360*E362,E360)","v":5776400.0000000009},{"$f":"G394*F394","v":635981.64000000013},{"$f":"F394","v":0.1101},{"$f":"IF(AND(E360*12>=150000),E360*E363,E360)","v":5776400.0000000009},{"$f":"J394*I394","v":635981.64000000013},{"$f":"K394-H394","v":0},0]
["LARGE USE SERVICE CLASSIFICATION","Non-RPP (Other)",null,"Average IESO Wholesale Market Price",null,0.1101,{"$f":"IF(AND(E360*12>=150000),E360*E362,E360)","v":5776400.0000000009},{"$f":"G395*F395","v":635981.64000000013},{"$f":"F395","v":0.1101},{"$f":"IF(AND(E360*12>=150000),E360*E363,E360)","v":5776400.0000000009},{"$f":"J395*I395","v":635981.64000000013},{"$f":"K395-H395","v":0},0]
["LARGE USE SERVICE CLASSIFICATION"]
["LARGE USE SERVICE CLASSIFICATION","RPP",null,"Total Bill on TOU (before Taxes)",null,null,null,{"$f":"SUM(H387:H393,H386)","v":552688.9800000001},null,null,{"$f":"SUM(K387:K393,K386)","v":553786.44000000018},{"$f":"K397-H397","v":1097.4600000000792},{"$f":"IF((H397)=0,\"\",(L397/H397))","v":1.9856737509043134E-3}]
["LARGE USE SERVICE CLASSIFICATION","RPP",null,"HST",null,0.13,null,{"$f":"H397*F398","v":71849.567400000014},0.13,null,{"$f":"K397*I398","v":71992.237200000032},{"$f":"K398-H398","v":142.66980000001786},{"$f":"IF((H398)=0,\"\",(L398/H398))","v":1.9856737509044184E-3}]
["LARGE USE SERVICE CLASSIFICATION","RPP",null,"8% Rebate",null,0.08,null,0,0.08,null,0,{"$f":"K399-H399","v":0}]
["LARGE USE SERVICE CLASSIFICATION","RPP_TOTAL",null,"Total Bill on TOU",null,null,null,{"$f":"H397+H398+H399","v":624538.54740000016},null,null,{"$f":"K397+K398+K399","v":625778.67720000027},{"$f":"K400-H400","v":1240.1298000001116},{"$f":"IF((H400)=0,\"\",(L400/H400))","v":1.9856737509043485E-3}]
["LARGE USE SERVICE CLASSIFICATION","RPP"]
["LARGE USE SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"Total Bill on Non-RPP Avg. Price",null,null,null,{"$f":"SUM(H394,H387:H390,H386)","v":712984.08000000007},null,null,{"$f":"SUM(K394,K387:K390,K386)","v":714081.54000000015},{"$f":"K402-H402","v":1097.4600000000792},{"$f":"IF((H402)=0,\"\",(L402/H402))","v":1.5392489548996368E-3}]
["LARGE USE SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"HST",null,0.13,null,{"$f":"H402*F403","v":92687.930400000012},0.13,null,{"$f":"K402*I403","v":92830.60020000003},{"$f":"K403-H403","v":142.66980000001786},{"$f":"IF((H403)=0,\"\",(L403/H403))","v":1.5392489548997183E-3}]
["LARGE USE SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"8% Rebate",null,0.08,null,0,0.08,null,0]
["LARGE USE SERVICE CLASSIFICATION","Non-RPP (Retailer)_TOTAL",null,"Total Bill on Non-RPP Avg. Price",null,null,null,{"$f":"SUM(H402,H403)","v":805672.01040000003},null,null,{"$f":"SUM(K402,K403)","v":806912.14020000014},{"$f":"K405-H405","v":1240.1298000001116},{"$f":"IF((H405)=0,\"\",(L405/H405))","v":1.5392489548996643E-3}]
["LARGE USE SERVICE CLASSIFICATION","Non-RPP (Retailer)"]
["LARGE USE SERVICE CLASSIFICATION","Non-RPP (Other)",null,"Total Bill on Average IESO Wholesale Market Price",null,null,null,{"$f":"SUM(H395,H387:H390,H386)","v":712984.08000000007},null,null,{"$f":"SUM(K395,K387:K390,K386)","v":714081.54000000015},{"$f":"K407-H407","v":1097.4600000000792},{"$f":"IF((H407)=0,\"\",(L407/H407))","v":1.5392489548996368E-3}]
["LARGE USE SERVICE CLASSIFICATION","Non-RPP (Other)",null,"HST",null,0.13,null,{"$f":"H407*F408","v":92687.930400000012},0.13,null,{"$f":"K407*I408","v":92830.60020000003},{"$f":"K408-H408","v":142.66980000001786},{"$f":"IF((H408)=0,\"\",(L408/H408))","v":1.5392489548997183E-3}]
["LARGE USE SERVICE CLASSIFICATION","Non-RPP (Other)",null,"8% Rebate",null,0.08,null,0,0.08,null,0]
["LARGE USE SERVICE CLASSIFICATION","Non-RPP (Other)_TOTAL",{"$f":"B35","v":6},"Total Bill on Average IESO Wholesale Market Price",null,null,null,{"$f":"SUM(H407,H408)","v":805672.01040000003},null,null,{"$f":"SUM(K407,K408)","v":806912.14020000014},{"$f":"K410-H410","v":1240.1298000001116},{"$f":"IF((H410)=0,\"\",(L410/H410))","v":1.5392489548996643E-3}]
["LARGE USE SERVICE CLASSIFICATION","Non-RPP (Other)"]
[]
[]
[null,null,null,"Customer Class:",{"$f":"D36","v":"STREET LIGHTING SERVICE CLASSIFICATION"},null,null,null,null,null,{"$f":"IF(N36=\"DEMAND - INTERVAL\",\"RTSR - INTERVAL METERED\",\"\")","v":""},null,null,null,null,null,null,null,null,"X"]
[null,null,null,"RPP / Non-RPP:",{"$f":"H36","v":"Non-RPP (Other)"}]
[null,null,null,"Consumption",{"$f":"K36","v":256},"kWh"]
[null,null,null,"Demand",{"$f":"L36","v":0.5},"kW"]
[null,null,null,"Current Loss Factor",{"$f":"I36","v":1.0315000000000001}]
[null,null,null,"Proposed/Approved Loss Factor",{"$f":"J36","v":1.0315000000000001}]
[]
[null,null,null,null,null,"Current OEB-Approved",null,null,"Proposed",null,null,"Impact"]
[null,null,null,null,null,"Rate","Volume","Charge","Rate","Volume","Charge","$ Change","% Change"]
[null,null,null,null,null,"($)",null,"($)","($)",null,"($)"]
[{"$f":"$E414","v":"STREET LIGHTING SERVICE CLASSIFICATION"},null,null,"Monthly Service Charge",null,1.68,null,{"$f":"G424*F424","v":0},1.7,null,{"$f":"J424*I424","v":0},{"$f":"K424-H424","v":0},{"$f":"IF(ISERROR(L424/H424), \"\", L424/H424)","v":""}]
[{"$f":"A424","v":"STREET LIGHTING SERVICE CLASSIFICATION"},null,null,"Distribution Volumetric Rate",null,8.3930000000000007,{"$f":"IF($E417>0, $E417, $E416)","v":0.5},{"$f":"G425*F425","v":4.1965000000000003},8.4937000000000005,{"$f":"IF($E417>0, $E417, $E416)","v":0.5},{"$f":"J425*I425","v":4.2468500000000002},5.0349999999999895E-2,{"$f":"IF(ISERROR(L425/H425), \"\", L425/H425)","v":1.1998093649469771E-2}]
[{"$f":"A425","v":"STREET LIGHTING SERVICE CLASSIFICATION"},null,null,"RRRP Credit",null,null,{"$f":"IF($E417>0, $E417, $E416)","v":0.5},0,null,{"$f":"IF($E417>0, $E417, $E416)","v":0.5},0]
["STREET LIGHTING SERVICE CLASSIFICATION",null,null,"DRP Adjustment",null,null,{"$f":"IF($E417>0, $E417, $E416)","v":0.5},0,null,{"$f":"IF($E417>0, $E417, $E416)","v":0.5},0,{"$f":"K427-H427","v":0},{"$f":"IF(ISERROR(L427/H427), \"\", L427/H427)","v":""}]
["STREET LIGHTING SERVICE CLASSIFICATION",null,null,"Fixed Rate Riders",null,0.02,null,0,0.02,null,{"$f":"J428*I428","v":0},0,""]
["STREET LIGHTING SERVICE CLASSIFICATION",null,null,"Volumetric Rate Riders",null,0.54430000000000001,{"$f":"IF($E417>0, $E417, $E416)","v":0.5},0.27215,0.68320000000000003,{"$f":"IF($E417>0, $E417, $E416)","v":0.5},0.34160000000000001,6.9450000000000012E-2,0.255190152489436]
["STREET LIGHTING SERVICE CLASSIFICATION","ST_A",{"$f":"B36","v":7},"Sub-Total A (excluding pass through)",null,null,null,{"$f":"SUM(H424:H429)","v":4.4686500000000002},null,null,{"$f":"SUM(K424:K429)","v":4.5884499999999999},0.11979999999999968,{"$f":"IF((H430)=0,\"\",(L430/H430))","v":2.6808991529880317E-2}]
["STREET LIGHTING SERVICE CLASSIFICATION",null,null,"Line Losses on Cost of Power",null,{"$f":"IF((E416*12>=150000), 0, IF(E415=\"RPP\",(F447*0.65+F448*0.17+F449*0.18),IF(E415=\"Non-RPP (Retailer)\",F450,F451)))","v":0.1101},{"$f":"IF(F431=0, 0, $E416*E418-E416)","v":8.0640000000000214},{"$f":"G431*F431","v":0.88784640000000237},{"$f":"IF((E416*12>=150000), 0, IF(E415=\"RPP\",(I447*0.65+I448*0.17+I449*0.18),IF(E415=\"Non-RPP (Retailer)\",I450,I451)))","v":0.1101},{"$f":"IF(I431=0, 0, E416*E419-E416)","v":8.0640000000000214},{"$f":"J431*I431","v":0.88784640000000237},{"$f":"K431-H431","v":0},{"$f":"IF(ISERROR(L431/H431), \"\", L431/H431)","v":0}]
["STREET LIGHTING SERVICE CLASSIFICATION",null,null,"Total Deferral/Variance Account Rate Riders",null,0,{"$f":"IF($E417>0, $E417, $E416)","v":0.5},0,0,{"$f":"IF($E417>0, $E417, $E416)","v":0.5},0,0,""]
["STREET LIGHTING SERVICE CLASSIFICATION",null,null,"CBR Class B Rate Riders",null,0,{"$f":"IF($E417>0, $E417, $E416)","v":0.5},{"$f":"G433*F433","v":0},0,{"$f":"IF($E417>0, $E417, $E416)","v":0.5},{"$f":"J433*I433","v":0},0,""]
["STREET LIGHTING SERVICE CLASSIFICATION",null,null,"GA Rate Riders",null,0,{"$f":"E416","v":256},{"$f":"G434*F434","v":0},0,{"$f":"E416","v":256},0,0,""]
["STREET LIGHTING SERVICE CLASSIFICATION",null,null,"Low Voltage Service Charge",null,0,{"$f":"IF($E417>0, $E417, $E416)","v":0.5},0,null,{"$f":"IF($E417>0, $E417, $E416)","v":0.5},0,0,""]
["STREET LIGHTING SERVICE CLASSIFICATION",null,null,"Smart Meter Entity Charge (if applicable)",null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"RESIDENTIAL\", E414))=TRUE, ISNUMBER(SEARCH(\"GENERAL SERVICE LESS THAN 50\", E414))=TRUE), SME, 0)","v":0},1,{"$f":"G436*F436","v":0},{"$f":"IF(OR(ISNUMBER(SEARCH(\"RESIDENTIAL\", E414))=TRUE, ISNUMBER(SEARCH(\"GENERAL SERVICE LESS THAN 50\", E414))=TRUE), SME, 0)","v":0},1,{"$f":"J436*I436","v":0},0,{"$f":"IF(ISERROR(L436/H436), \"\", L436/H436)","v":""}]
["STREET LIGHTING SERVICE CLASSIFICATION",null,null,"Additional Fixed Rate Riders ",null,0,1,0,0,1,{"$f":"J437*I437","v":0},{"$f":"K437-H437","v":0},{"$f":"IF(ISERROR(L437/H437), \"\", L437/H437)","v":""}]
["STREET LIGHTING SERVICE CLASSIFICATION",null,null,"Additional Volumetric Rate Riders ",null,null,{"$f":"IF($E417>0, $E417, $E416)","v":0.5},{"$f":"G438*F438","v":0},0,{"$f":"IF($E417>0, $E417, $E416)","v":0.5},{"$f":"J438*I438","v":0},0,{"$f":"IF(ISERROR(L438/H438), \"\", L438/H438)","v":""}]
["STREET LIGHTING SERVICE CLASSIFICATION","ST_B",{"$f":"B36","v":7},"Sub-Total B - Distribution (includes Sub-Total A)",null,null,null,{"$f":"SUM(H430:H438)","v":5.3564964000000028},null,null,{"$f":"SUM(K430:K438)","v":5.4762964000000025},0.11979999999999968,{"$f":"IF((H439)=0,\"\",(L439/H439))","v":2.2365365540057046E-2}]
["STREET LIGHTING SERVICE CLASSIFICATION",null,null,"RTSR - Network",null,2.0226000000000002,{"$f":"IF($E417>0, $E417, $E416*$E418)","v":0.5},{"$f":"G440*F440","v":1.0113000000000001},2.0964,{"$f":"IF($E417>0, $E417, $E416*$E419)","v":0.5},{"$f":"J440*I440","v":1.0482},3.6899999999999933E-2,{"$f":"IF(ISERROR(L440/H440), \"\", L440/H440)","v":3.6487689113022775E-2},{"$f":"IF(ISERROR(ABS(M440)), \"\", IF(ABS(M440)>=4%, \"In the manager's summary, discuss the reasoning for the change in RTSR rates\", \"\"))","v":""}]
["STREET LIGHTING SERVICE CLASSIFICATION",null,null,"RTSR - Connection and/or Line and Transformation Connection",null,1.7708999999999999,{"$f":"IF($E417>0, $E417, $E416*$E418)","v":0.5},{"$f":"G441*F441","v":0.88544999999999996},1.8502000000000001,{"$f":"IF($E417>0, $E417, $E416*$E419)","v":0.5},{"$f":"J441*I441","v":0.92510000000000003},3.9650000000000074E-2,{"$f":"IF(ISERROR(L441/H441), \"\", L441/H441)","v":4.4779490654469567E-2},{"$f":"IF(ISERROR(ABS(M441)), \"\", IF(ABS(M441)>=4%, \"In the manager's summary, discuss the reasoning for the change in RTSR rates\", \"\"))","v":"In the manager's summary, discuss the reasoning for the change in RTSR rates"}]
["STREET LIGHTING SERVICE CLASSIFICATION","ST_C",{"$f":"B36","v":7},"Sub-Total C - Delivery (including Sub-Total B)",null,null,null,{"$f":"SUM(H439:H441)","v":7.2532464000000028},null,null,{"$f":"SUM(K439:K441)","v":7.4495964000000026},0.1963499999999998,{"$f":"IF((H442)=0,\"\",(L442/H442))","v":2.7070636949545753E-2}]
["STREET LIGHTING SERVICE CLASSIFICATION",null,null,"Wholesale Market Service Charge (WMSC)",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$E$14),'[2]17. Regulatory Charges'!$D$15+'[2]17. Regulatory Charges'!$D$16,'[2]17. Regulatory Charges'!$E$15+'[2]17. Regulatory Charges'!$E$16)","v":3.4000000000000002E-3},{"$f":"E416*E418","v":264.06400000000002},{"$f":"G443*F443","v":0.8978176000000001},{"$f":"'[2]17. Regulatory Charges'!$E$15+'[2]17. Regulatory Charges'!$E$16","v":3.4000000000000002E-3},{"$f":"E416*E419","v":264.06400000000002},{"$f":"J443*I443","v":0.8978176000000001},0,{"$f":"IF(ISERROR(L443/H443), \"\", L443/H443)","v":0}]
["STREET LIGHTING SERVICE CLASSIFICATION",null,null,"Rural and Remote Rate Protection (RRRP)",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$D$14),'[2]17. Regulatory Charges'!$D$17,'[2]17. Regulatory Charges'!$E$17)","v":5.0000000000000001E-4},{"$f":"E416*E418","v":264.06400000000002},0.13203200000000001,{"$f":"'[2]17. Regulatory Charges'!$E$17","v":5.0000000000000001E-4},{"$f":"E416*E419","v":264.06400000000002},0.13203200000000001,0,0]
["STREET LIGHTING SERVICE CLASSIFICATION",null,null,"Standard Supply Service Charge",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$D$14),'[2]17. Regulatory Charges'!$D$18,'[2]17. Regulatory Charges'!$E$18)","v":0.25},null,0,{"$f":"'[2]17. Regulatory Charges'!$E$18","v":0.25},null,0,0,""]
["STREET LIGHTING SERVICE CLASSIFICATION",null,null,"Ontario Electricity Support Program \n(OESP) "]
["STREET LIGHTING SERVICE CLASSIFICATION","RPP",null,"TOU - Off Peak",null,{"$f":"OffPeak","v":6.5000000000000002E-2},{"$f":"IF(AND(E416*12>=150000),0.65*E416*E418,0.65*E416)","v":166.4},10.816000000000001,{"$f":"OffPeak","v":6.5000000000000002E-2},{"$f":"IF(AND(E416*12>=150000),0.65*E416*E419,0.65*E416)","v":166.4},10.816000000000001,{"$f":"K447-H447","v":0},0]
["STREET LIGHTING SERVICE CLASSIFICATION","RPP",null,"TOU - Mid Peak",null,{"$f":"MidPeak","v":9.4E-2},{"$f":"IF(AND(E416*12>=150000),0.17*E416*E418,0.17*E416)","v":43.52},4.0908800000000003,{"$f":"MidPeak","v":9.4E-2},{"$f":"IF(AND(E416*12>=150000),0.17*E416*E419,0.17*E416)","v":43.52},4.0908800000000003,{"$f":"K448-H448","v":0},0]
["STREET LIGHTING SERVICE CLASSIFICATION","RPP",null,"TOU - On Peak",null,{"$f":"OnPeak","v":0.13400000000000001},{"$f":"IF(AND(E416*12>=150000),0.18*E416*E418,0.18*E416)","v":46.08},6.1747199999999998,{"$f":"OnPeak","v":0.13400000000000001},{"$f":"IF(AND(E416*12>=150000),0.18*E416*E419,0.18*E416)","v":46.08},6.1747199999999998,{"$f":"K449-H449","v":0},0]
["STREET LIGHTING SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"Non-RPP Retailer Avg. Price",null,0.1101,{"$f":"IF(AND(E416*12>=150000),E416*E418,E416)","v":256},{"$f":"G450*F450","v":28.185600000000001},{"$f":"F450","v":0.1101},{"$f":"IF(AND(E416*12>=150000),E416*E419,E416)","v":256},{"$f":"J450*I450","v":28.185600000000001},{"$f":"K450-H450","v":0},0]
["STREET LIGHTING SERVICE CLASSIFICATION","Non-RPP (Other)",null,"Average IESO Wholesale Market Price",null,0.1101,{"$f":"IF(AND(E416*12>=150000),E416*E418,E416)","v":256},{"$f":"G451*F451","v":28.185600000000001},{"$f":"F451","v":0.1101},{"$f":"IF(AND(E416*12>=150000),E416*E419,E416)","v":256},{"$f":"J451*I451","v":28.185600000000001},{"$f":"K451-H451","v":0},0]
["STREET LIGHTING SERVICE CLASSIFICATION"]
["STREET LIGHTING SERVICE CLASSIFICATION","RPP",null,"Total Bill on TOU (before Taxes)",null,null,null,{"$f":"SUM(H443:H449,H442)","v":29.364696000000002},null,null,{"$f":"SUM(K443:K449,K442)","v":29.561046000000005},{"$f":"K453-H453","v":0.19635000000000247},{"$f":"IF((H453)=0,\"\",(L453/H453))","v":6.6866008079907403E-3}]
["STREET LIGHTING SERVICE CLASSIFICATION","RPP",null,"HST",null,0.13,null,{"$f":"H453*F454","v":3.8174104800000004},0.13,null,{"$f":"K453*I454","v":3.8429359800000009},{"$f":"K454-H454","v":2.5525500000000534E-2},{"$f":"IF((H454)=0,\"\",(L454/H454))","v":6.6866008079907958E-3}]
["STREET LIGHTING SERVICE CLASSIFICATION","RPP",null,"8% Rebate",null,0.08,null,0,0.08,null,0,{"$f":"K455-H455","v":0}]
["STREET LIGHTING SERVICE CLASSIFICATION","RPP_TOTAL",null,"Total Bill on TOU",null,null,null,{"$f":"H453+H454+H455","v":33.182106480000002},null,null,{"$f":"K453+K454+K455","v":33.403981980000005},{"$f":"K456-H456","v":0.221875500000003},{"$f":"IF((H456)=0,\"\",(L456/H456))","v":6.6866008079907464E-3}]
["STREET LIGHTING SERVICE CLASSIFICATION","RPP"]
["STREET LIGHTING SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"Total Bill on Non-RPP Avg. Price",null,null,null,{"$f":"SUM(H450,H443:H446,H442)","v":36.468696000000001},null,null,{"$f":"SUM(K450,K443:K446,K442)","v":36.665046000000004},{"$f":"K458-H458","v":0.19635000000000247},{"$f":"IF((H458)=0,\"\",(L458/H458))","v":5.3840696689566982E-3}]
["STREET LIGHTING SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"HST",null,0.13,null,{"$f":"H458*F459","v":4.7409304800000003},0.13,null,{"$f":"K458*I459","v":4.7664559800000008},{"$f":"K459-H459","v":2.5525500000000534E-2},{"$f":"IF((H459)=0,\"\",(L459/H459))","v":5.3840696689567433E-3}]
["STREET LIGHTING SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"8% Rebate",null,0.08,null,0,0.08,null,0]
["STREET LIGHTING SERVICE CLASSIFICATION","Non-RPP (Retailer)_TOTAL",null,"Total Bill on Non-RPP Avg. Price",null,null,null,{"$f":"SUM(H458,H459)","v":41.209626480000004},null,null,{"$f":"SUM(K458,K459)","v":41.431501980000007},{"$f":"K461-H461","v":0.221875500000003},{"$f":"IF((H461)=0,\"\",(L461/H461))","v":5.3840696689567025E-3}]
["STREET LIGHTING SERVICE CLASSIFICATION","Non-RPP (Retailer)"]
["STREET LIGHTING SERVICE CLASSIFICATION","Non-RPP (Other)",null,"Total Bill on Average IESO Wholesale Market Price",null,null,null,{"$f":"SUM(H451,H443:H446,H442)","v":36.468696000000001},null,null,{"$f":"SUM(K451,K443:K446,K442)","v":36.665046000000004},{"$f":"K463-H463","v":0.19635000000000247},{"$f":"IF((H463)=0,\"\",(L463/H463))","v":5.3840696689566982E-3}]
["STREET LIGHTING SERVICE CLASSIFICATION","Non-RPP (Other)",null,"HST",null,0.13,null,{"$f":"H463*F464","v":4.7409304800000003},0.13,null,{"$f":"K463*I464","v":4.7664559800000008},{"$f":"K464-H464","v":2.5525500000000534E-2},{"$f":"IF((H464)=0,\"\",(L464/H464))","v":5.3840696689567433E-3}]
["STREET LIGHTING SERVICE CLASSIFICATION","Non-RPP (Other)",null,"8% Rebate",null,0.08,null,0,0.08,null,0]
["STREET LIGHTING SERVICE CLASSIFICATION","Non-RPP (Other)_TOTAL",{"$f":"B36","v":7},"Total Bill on Average IESO Wholesale Market Price",null,null,null,{"$f":"SUM(H463,H464)","v":41.209626480000004},null,null,{"$f":"SUM(K463,K464)","v":41.431501980000007},{"$f":"K466-H466","v":0.221875500000003},{"$f":"IF((H466)=0,\"\",(L466/H466))","v":5.3840696689567025E-3}]
["STREET LIGHTING SERVICE CLASSIFICATION","Non-RPP (Other)"]
[]
[]
[null,null,null,"Customer Class:",{"$f":"D37","v":"SENTINEL LIGHTING SERVICE CLASSIFICATION"},null,null,null,null,null,{"$f":"IF(N37=\"DEMAND - INTERVAL\",\"RTSR - INTERVAL METERED\",\"\")","v":""},null,null,null,null,null,null,null,null,"X"]
[null,null,null,"RPP / Non-RPP:",{"$f":"H37","v":"Non-RPP (Other)"}]
[null,null,null,"Consumption",{"$f":"K37","v":180},"kWh"]
[null,null,null,"Demand",{"$f":"L37","v":0.1},"kW"]
[null,null,null,"Current Loss Factor",{"$f":"I37","v":1.0315000000000001}]
[null,null,null,"Proposed/Approved Loss Factor",{"$f":"J37","v":1.0315000000000001}]
[]
[null,null,null,null,null,"Current OEB-Approved",null,null,"Proposed",null,null,"Impact"]
[null,null,null,null,null,"Rate","Volume","Charge","Rate","Volume","Charge","$ Change","% Change"]
[null,null,null,null,null,"($)",null,"($)","($)",null,"($)"]
[{"$f":"$E470","v":"SENTINEL LIGHTING SERVICE CLASSIFICATION"},null,null,"Monthly Service Charge",null,4.7300000000000004,null,{"$f":"G480*F480","v":0},4.79,null,{"$f":"J480*I480","v":0},{"$f":"K480-H480","v":0},{"$f":"IF(ISERROR(L480/H480), \"\", L480/H480)","v":""}]
[{"$f":"A480","v":"SENTINEL LIGHTING SERVICE CLASSIFICATION"},null,null,"Distribution Volumetric Rate",null,15.5619,{"$f":"IF($E473>0, $E473, $E472)","v":0.1},{"$f":"G481*F481","v":1.55619},15.7486,{"$f":"IF($E473>0, $E473, $E472)","v":0.1},{"$f":"J481*I481","v":1.5748600000000001},1.8670000000000186E-2,{"$f":"IF(ISERROR(L481/H481), \"\", L481/H481)","v":1.1997249693160981E-2}]
[{"$f":"A481","v":"SENTINEL LIGHTING SERVICE CLASSIFICATION"},null,null,"RRRP Credit",null,null,{"$f":"IF($E473>0, $E473, $E472)","v":0.1},0,null,{"$f":"IF($E473>0, $E473, $E472)","v":0.1},0]
["SENTINEL LIGHTING SERVICE CLASSIFICATION",null,null,"DRP Adjustment",null,null,{"$f":"IF($E473>0, $E473, $E472)","v":0.1},0,null,{"$f":"IF($E473>0, $E473, $E472)","v":0.1},0,{"$f":"K483-H483","v":0},{"$f":"IF(ISERROR(L483/H483), \"\", L483/H483)","v":""}]
["SENTINEL LIGHTING SERVICE CLASSIFICATION",null,null,"Fixed Rate Riders",null,0.06,null,0,0.06,null,{"$f":"J484*I484","v":0},0,""]
["SENTINEL LIGHTING SERVICE CLASSIFICATION",null,null,"Volumetric Rate Riders",null,0.58509999999999995,{"$f":"IF($E473>0, $E473, $E472)","v":0.1},5.851E-2,0.79210000000000003,{"$f":"IF($E473>0, $E473, $E472)","v":0.1},7.9210000000000003E-2,2.0700000000000003E-2,0.35378567766193819]
["SENTINEL LIGHTING SERVICE CLASSIFICATION","ST_A",{"$f":"B37","v":8},"Sub-Total A (excluding pass through)",null,null,null,{"$f":"SUM(H480:H485)","v":1.6147},null,null,{"$f":"SUM(K480:K485)","v":1.6540700000000002},3.9370000000000127E-2,{"$f":"IF((H486)=0,\"\",(L486/H486))","v":2.4382238186660139E-2}]
["SENTINEL LIGHTING SERVICE CLASSIFICATION",null,null,"Line Losses on Cost of Power",null,{"$f":"IF((E472*12>=150000), 0, IF(E471=\"RPP\",(F503*0.65+F504*0.17+F505*0.18),IF(E471=\"Non-RPP (Retailer)\",F506,F507)))","v":0.1101},{"$f":"IF(F487=0, 0, $E472*E474-E472)","v":5.6700000000000159},{"$f":"G487*F487","v":0.62426700000000179},{"$f":"IF((E472*12>=150000), 0, IF(E471=\"RPP\",(I503*0.65+I504*0.17+I505*0.18),IF(E471=\"Non-RPP (Retailer)\",I506,I507)))","v":0.1101},{"$f":"IF(I487=0, 0, E472*E475-E472)","v":5.6700000000000159},{"$f":"J487*I487","v":0.62426700000000179},{"$f":"K487-H487","v":0},{"$f":"IF(ISERROR(L487/H487), \"\", L487/H487)","v":0}]
["SENTINEL LIGHTING SERVICE CLASSIFICATION",null,null,"Total Deferral/Variance Account Rate Riders",null,0,{"$f":"IF($E473>0, $E473, $E472)","v":0.1},0,0,{"$f":"IF($E473>0, $E473, $E472)","v":0.1},0,0,""]
["SENTINEL LIGHTING SERVICE CLASSIFICATION",null,null,"CBR Class B Rate Riders",null,0,{"$f":"IF($E473>0, $E473, $E472)","v":0.1},{"$f":"G489*F489","v":0},0,{"$f":"IF($E473>0, $E473, $E472)","v":0.1},{"$f":"J489*I489","v":0},0,""]
["SENTINEL LIGHTING SERVICE CLASSIFICATION",null,null,"GA Rate Riders",null,0,{"$f":"E472","v":180},{"$f":"G490*F490","v":0},0,{"$f":"E472","v":180},0,0,""]
["SENTINEL LIGHTING SERVICE CLASSIFICATION",null,null,"Low Voltage Service Charge",null,0,{"$f":"IF($E473>0, $E473, $E472)","v":0.1},0,null,{"$f":"IF($E473>0, $E473, $E472)","v":0.1},0,0,""]
["SENTINEL LIGHTING SERVICE CLASSIFICATION",null,null,"Smart Meter Entity Charge (if applicable)",null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"RESIDENTIAL\", E470))=TRUE, ISNUMBER(SEARCH(\"GENERAL SERVICE LESS THAN 50\", E470))=TRUE), SME, 0)","v":0},1,{"$f":"G492*F492","v":0},{"$f":"IF(OR(ISNUMBER(SEARCH(\"RESIDENTIAL\", E470))=TRUE, ISNUMBER(SEARCH(\"GENERAL SERVICE LESS THAN 50\", E470))=TRUE), SME, 0)","v":0},1,{"$f":"J492*I492","v":0},0,{"$f":"IF(ISERROR(L492/H492), \"\", L492/H492)","v":""}]
["SENTINEL LIGHTING SERVICE CLASSIFICATION",null,null,"Additional Fixed Rate Riders ",null,0,1,0,0,1,{"$f":"J493*I493","v":0},{"$f":"K493-H493","v":0},{"$f":"IF(ISERROR(L493/H493), \"\", L493/H493)","v":""}]
["SENTINEL LIGHTING SERVICE CLASSIFICATION",null,null,"Additional Volumetric Rate Riders ",null,null,{"$f":"IF($E473>0, $E473, $E472)","v":0.1},{"$f":"G494*F494","v":0},0,{"$f":"IF($E473>0, $E473, $E472)","v":0.1},{"$f":"J494*I494","v":0},0,{"$f":"IF(ISERROR(L494/H494), \"\", L494/H494)","v":""}]
["SENTINEL LIGHTING SERVICE CLASSIFICATION","ST_B",{"$f":"B37","v":8},"Sub-Total B - Distribution (includes Sub-Total A)",null,null,null,{"$f":"SUM(H486:H494)","v":2.2389670000000019},null,null,{"$f":"SUM(K486:K494)","v":2.2783370000000018},3.9369999999999905E-2,{"$f":"IF((H495)=0,\"\",(L495/H495))","v":1.7584001908022704E-2}]
["SENTINEL LIGHTING SERVICE CLASSIFICATION",null,null,"RTSR - Network",null,2.0253000000000001,{"$f":"IF($E473>0, $E473, $E472*$E474)","v":0.1},{"$f":"G496*F496","v":0.20253000000000002},2.0992000000000002,{"$f":"IF($E473>0, $E473, $E472*$E475)","v":0.1},{"$f":"J496*I496","v":0.20992000000000002},7.3900000000000077E-3,{"$f":"IF(ISERROR(L496/H496), \"\", L496/H496)","v":3.6488421468424466E-2},{"$f":"IF(ISERROR(ABS(M496)), \"\", IF(ABS(M496)>=4%, \"In the manager's summary, discuss the reasoning for the change in RTSR rates\", \"\"))","v":""}]
["SENTINEL LIGHTING SERVICE CLASSIFICATION",null,null,"RTSR - Connection and/or Line and Transformation Connection",null,1.7734000000000001,{"$f":"IF($E473>0, $E473, $E472*$E474)","v":0.1},{"$f":"G497*F497","v":0.17734000000000003},1.8528,{"$f":"IF($E473>0, $E473, $E472*$E475)","v":0.1},{"$f":"J497*I497","v":0.18528},7.9399999999999749E-3,{"$f":"IF(ISERROR(L497/H497), \"\", L497/H497)","v":4.4772752904026013E-2},{"$f":"IF(ISERROR(ABS(M497)), \"\", IF(ABS(M497)>=4%, \"In the manager's summary, discuss the reasoning for the change in RTSR rates\", \"\"))","v":"In the manager's summary, discuss the reasoning for the change in RTSR rates"}]
["SENTINEL LIGHTING SERVICE CLASSIFICATION","ST_C",{"$f":"B37","v":8},"Sub-Total C - Delivery (including Sub-Total B)",null,null,null,{"$f":"SUM(H495:H497)","v":2.6188370000000019},null,null,{"$f":"SUM(K495:K497)","v":2.6735370000000018},5.4699999999999971E-2,{"$f":"IF((H498)=0,\"\",(L498/H498))","v":2.0887134250814364E-2}]
["SENTINEL LIGHTING SERVICE CLASSIFICATION",null,null,"Wholesale Market Service Charge (WMSC)",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$E$14),'[2]17. Regulatory Charges'!$D$15+'[2]17. Regulatory Charges'!$D$16,'[2]17. Regulatory Charges'!$E$15+'[2]17. Regulatory Charges'!$E$16)","v":3.4000000000000002E-3},{"$f":"E472*E474","v":185.67000000000002},{"$f":"G499*F499","v":0.63127800000000012},{"$f":"'[2]17. Regulatory Charges'!$E$15+'[2]17. Regulatory Charges'!$E$16","v":3.4000000000000002E-3},{"$f":"E472*E475","v":185.67000000000002},{"$f":"J499*I499","v":0.63127800000000012},0,{"$f":"IF(ISERROR(L499/H499), \"\", L499/H499)","v":0}]
["SENTINEL LIGHTING SERVICE CLASSIFICATION",null,null,"Rural and Remote Rate Protection (RRRP)",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$D$14),'[2]17. Regulatory Charges'!$D$17,'[2]17. Regulatory Charges'!$E$17)","v":5.0000000000000001E-4},{"$f":"E472*E474","v":185.67000000000002},9.2835000000000015E-2,{"$f":"'[2]17. Regulatory Charges'!$E$17","v":5.0000000000000001E-4},{"$f":"E472*E475","v":185.67000000000002},9.2835000000000015E-2,0,0]
["SENTINEL LIGHTING SERVICE CLASSIFICATION",null,null,"Standard Supply Service Charge",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$D$14),'[2]17. Regulatory Charges'!$D$18,'[2]17. Regulatory Charges'!$E$18)","v":0.25},null,0,{"$f":"'[2]17. Regulatory Charges'!$E$18","v":0.25},null,0,0,""]
["SENTINEL LIGHTING SERVICE CLASSIFICATION",null,null,"Ontario Electricity Support Program \n(OESP) "]
["SENTINEL LIGHTING SERVICE CLASSIFICATION","RPP",null,"TOU - Off Peak",null,{"$f":"OffPeak","v":6.5000000000000002E-2},{"$f":"IF(AND(E472*12>=150000),0.65*E472*E474,0.65*E472)","v":117},7.6050000000000004,{"$f":"OffPeak","v":6.5000000000000002E-2},{"$f":"IF(AND(E472*12>=150000),0.65*E472*E475,0.65*E472)","v":117},7.6050000000000004,{"$f":"K503-H503","v":0},0]
["SENTINEL LIGHTING SERVICE CLASSIFICATION","RPP",null,"TOU - Mid Peak",null,{"$f":"MidPeak","v":9.4E-2},{"$f":"IF(AND(E472*12>=150000),0.17*E472*E474,0.17*E472)","v":30.6},2.8764000000000003,{"$f":"MidPeak","v":9.4E-2},{"$f":"IF(AND(E472*12>=150000),0.17*E472*E475,0.17*E472)","v":30.6},2.8764000000000003,{"$f":"K504-H504","v":0},0]
["SENTINEL LIGHTING SERVICE CLASSIFICATION","RPP",null,"TOU - On Peak",null,{"$f":"OnPeak","v":0.13400000000000001},{"$f":"IF(AND(E472*12>=150000),0.18*E472*E474,0.18*E472)","v":32.4},4.3415999999999997,{"$f":"OnPeak","v":0.13400000000000001},{"$f":"IF(AND(E472*12>=150000),0.18*E472*E475,0.18*E472)","v":32.4},4.3415999999999997,{"$f":"K505-H505","v":0},0]
["SENTINEL LIGHTING SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"Non-RPP Retailer Avg. Price",null,0.1101,{"$f":"IF(AND(E472*12>=150000),E472*E474,E472)","v":180},{"$f":"G506*F506","v":19.818000000000001},{"$f":"F506","v":0.1101},{"$f":"IF(AND(E472*12>=150000),E472*E475,E472)","v":180},{"$f":"J506*I506","v":19.818000000000001},{"$f":"K506-H506","v":0},0]
["SENTINEL LIGHTING SERVICE CLASSIFICATION","Non-RPP (Other)",null,"Average IESO Wholesale Market Price",null,0.1101,{"$f":"IF(AND(E472*12>=150000),E472*E474,E472)","v":180},{"$f":"G507*F507","v":19.818000000000001},{"$f":"F507","v":0.1101},{"$f":"IF(AND(E472*12>=150000),E472*E475,E472)","v":180},{"$f":"J507*I507","v":19.818000000000001},{"$f":"K507-H507","v":0},0]
["SENTINEL LIGHTING SERVICE CLASSIFICATION"]
["SENTINEL LIGHTING SERVICE CLASSIFICATION","RPP",null,"Total Bill on TOU (before Taxes)",null,null,null,{"$f":"SUM(H499:H505,H498)","v":18.165950000000002},null,null,{"$f":"SUM(K499:K505,K498)","v":18.220650000000003},{"$f":"K509-H509","v":5.4700000000000415E-2},{"$f":"IF((H509)=0,\"\",(L509/H509))","v":3.0111279619287959E-3}]
["SENTINEL LIGHTING SERVICE CLASSIFICATION","RPP",null,"HST",null,0.13,null,{"$f":"H509*F510","v":2.3615735000000004},0.13,null,{"$f":"K509*I510","v":2.3686845000000005},{"$f":"K510-H510","v":7.1110000000000895E-3},{"$f":"IF((H510)=0,\"\",(L510/H510))","v":3.0111279619288106E-3}]
["SENTINEL LIGHTING SERVICE CLASSIFICATION","RPP",null,"8% Rebate",null,0.08,null,0,0.08,null,0,{"$f":"K511-H511","v":0}]
["SENTINEL LIGHTING SERVICE CLASSIFICATION","RPP_TOTAL",null,"Total Bill on TOU",null,null,null,{"$f":"H509+H510+H511","v":20.527523500000001},null,null,{"$f":"K509+K510+K511","v":20.589334500000003},{"$f":"K512-H512","v":6.1811000000002281E-2},{"$f":"IF((H512)=0,\"\",(L512/H512))","v":3.0111279619288844E-3}]
["SENTINEL LIGHTING SERVICE CLASSIFICATION","RPP"]
["SENTINEL LIGHTING SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"Total Bill on Non-RPP Avg. Price",null,null,null,{"$f":"SUM(H506,H499:H502,H498)","v":23.160950000000007},null,null,{"$f":"SUM(K506,K499:K502,K498)","v":23.215650000000007},{"$f":"K514-H514","v":5.4700000000000415E-2},{"$f":"IF((H514)=0,\"\",(L514/H514))","v":2.3617338667023761E-3}]
["SENTINEL LIGHTING SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"HST",null,0.13,null,{"$f":"H514*F515","v":3.010923500000001},0.13,null,{"$f":"K514*I515","v":3.0180345000000011},{"$f":"K515-H515","v":7.1110000000000895E-3},{"$f":"IF((H515)=0,\"\",(L515/H515))","v":2.3617338667023878E-3}]
["SENTINEL LIGHTING SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"8% Rebate",null,0.08,null,0,0.08,null,0]
["SENTINEL LIGHTING SERVICE CLASSIFICATION","Non-RPP (Retailer)_TOTAL",null,"Total Bill on Non-RPP Avg. Price",null,null,null,{"$f":"SUM(H514,H515)","v":26.171873500000007},null,null,{"$f":"SUM(K514,K515)","v":26.23368450000001},{"$f":"K517-H517","v":6.1811000000002281E-2},{"$f":"IF((H517)=0,\"\",(L517/H517))","v":2.3617338667024455E-3}]
["SENTINEL LIGHTING SERVICE CLASSIFICATION","Non-RPP (Retailer)"]
["SENTINEL LIGHTING SERVICE CLASSIFICATION","Non-RPP (Other)",null,"Total Bill on Average IESO Wholesale Market Price",null,null,null,{"$f":"SUM(H507,H499:H502,H498)","v":23.160950000000007},null,null,{"$f":"SUM(K507,K499:K502,K498)","v":23.215650000000007},{"$f":"K519-H519","v":5.4700000000000415E-2},{"$f":"IF((H519)=0,\"\",(L519/H519))","v":2.3617338667023761E-3}]
["SENTINEL LIGHTING SERVICE CLASSIFICATION","Non-RPP (Other)",null,"HST",null,0.13,null,{"$f":"H519*F520","v":3.010923500000001},0.13,null,{"$f":"K519*I520","v":3.0180345000000011},{"$f":"K520-H520","v":7.1110000000000895E-3},{"$f":"IF((H520)=0,\"\",(L520/H520))","v":2.3617338667023878E-3}]
["SENTINEL LIGHTING SERVICE CLASSIFICATION","Non-RPP (Other)",null,"8% Rebate",null,0.08,null,0,0.08,null,0]
["SENTINEL LIGHTING SERVICE CLASSIFICATION","Non-RPP (Other)_TOTAL",{"$f":"B37","v":8},"Total Bill on Average IESO Wholesale Market Price",null,null,null,{"$f":"SUM(H519,H520)","v":26.171873500000007},null,null,{"$f":"SUM(K519,K520)","v":26.23368450000001},{"$f":"K522-H522","v":6.1811000000002281E-2},{"$f":"IF((H522)=0,\"\",(L522/H522))","v":2.3617338667024455E-3}]
["SENTINEL LIGHTING SERVICE CLASSIFICATION","Non-RPP (Other)"]
[]
[]
[null,null,null,"Customer Class:",{"$f":"D38","v":"UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION"},null,null,null,null,null,{"$f":"IF(N38=\"DEMAND - INTERVAL\",\"RTSR - INTERVAL METERED\",\"\")","v":""},null,null,null,null,null,null,null,null,"X"]
[null,null,null,"RPP / Non-RPP:",{"$f":"H38","v":"RPP"}]
[null,null,null,"Consumption",{"$f":"K38","v":2000},"kWh"]
[null,null,null,"Demand",{"$f":"L38","v":0},"kW"]
[null,null,null,"Current Loss Factor",{"$f":"I38","v":1.0315000000000001}]
[null,null,null,"Proposed/Approved Loss Factor",{"$f":"J38","v":1.0315000000000001}]
[]
[null,null,null,null,null,"Current OEB-Approved",null,null,"Proposed",null,null,"Impact"]
[null,null,null,null,null,"Rate","Volume","Charge","Rate","Volume","Charge","$ Change","% Change"]
[null,null,null,null,null,"($)",null,"($)","($)",null,"($)"]
[{"$f":"$E526","v":"UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION"},null,null,"Monthly Service Charge",null,2.37,null,{"$f":"G536*F536","v":0},2.4,null,{"$f":"J536*I536","v":0},{"$f":"K536-H536","v":0},{"$f":"IF(ISERROR(L536/H536), \"\", L536/H536)","v":""}]
[{"$f":"A536","v":"UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION"},null,null,"Distribution Volumetric Rate",null,2.0400000000000001E-2,{"$f":"IF($E529>0, $E529, $E528)","v":2000},{"$f":"G537*F537","v":40.800000000000004},2.06E-2,{"$f":"IF($E529>0, $E529, $E528)","v":2000},{"$f":"J537*I537","v":41.2},0.39999999999999858,{"$f":"IF(ISERROR(L537/H537), \"\", L537/H537)","v":9.8039215686274144E-3}]
[{"$f":"A537","v":"UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION"},null,null,"RRRP Credit",null,null,{"$f":"IF($E529>0, $E529, $E528)","v":2000},0,null,{"$f":"IF($E529>0, $E529, $E528)","v":2000},0]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION",null,null,"DRP Adjustment",null,null,{"$f":"IF($E529>0, $E529, $E528)","v":2000},0,null,{"$f":"IF($E529>0, $E529, $E528)","v":2000},0,{"$f":"K539-H539","v":0},{"$f":"IF(ISERROR(L539/H539), \"\", L539/H539)","v":""}]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION",null,null,"Fixed Rate Riders",null,0.03,null,0,0.03,null,{"$f":"J540*I540","v":0},0,""]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION",null,null,"Volumetric Rate Riders",null,1.7000000000000001E-3,{"$f":"IF($E529>0, $E529, $E528)","v":2000},3.4000000000000004,1.9E-3,{"$f":"IF($E529>0, $E529, $E528)","v":2000},3.8,0.39999999999999947,0.11764705882352924]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","ST_A",{"$f":"B38","v":9},"Sub-Total A (excluding pass through)",null,null,null,{"$f":"SUM(H536:H541)","v":44.2},null,null,{"$f":"SUM(K536:K541)","v":45},0.79999999999999716,{"$f":"IF((H542)=0,\"\",(L542/H542))","v":1.8099547511312153E-2}]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION",null,null,"Line Losses on Cost of Power",null,{"$f":"IF((E528*12>=150000), 0, IF(E527=\"RPP\",(F559*0.65+F560*0.17+F561*0.18),IF(E527=\"Non-RPP (Retailer)\",F562,F563)))","v":8.2350000000000007E-2},{"$f":"IF(F543=0, 0, $E528*E530-E528)","v":63},{"$f":"G543*F543","v":5.1880500000000005},{"$f":"IF((E528*12>=150000), 0, IF(E527=\"RPP\",(I559*0.65+I560*0.17+I561*0.18),IF(E527=\"Non-RPP (Retailer)\",I562,I563)))","v":8.2350000000000007E-2},{"$f":"IF(I543=0, 0, E528*E531-E528)","v":63},{"$f":"J543*I543","v":5.1880500000000005},{"$f":"K543-H543","v":0},{"$f":"IF(ISERROR(L543/H543), \"\", L543/H543)","v":0}]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION",null,null,"Total Deferral/Variance Account Rate Riders",null,0,{"$f":"IF($E529>0, $E529, $E528)","v":2000},0,0,{"$f":"IF($E529>0, $E529, $E528)","v":2000},0,0,""]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION",null,null,"CBR Class B Rate Riders",null,0,{"$f":"IF($E529>0, $E529, $E528)","v":2000},{"$f":"G545*F545","v":0},0,{"$f":"IF($E529>0, $E529, $E528)","v":2000},{"$f":"J545*I545","v":0},0,""]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION",null,null,"GA Rate Riders",null,0,{"$f":"E528","v":2000},{"$f":"G546*F546","v":0},0,{"$f":"E528","v":2000},0,0,""]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION",null,null,"Low Voltage Service Charge",null,0,{"$f":"IF($E529>0, $E529, $E528)","v":2000},0,null,{"$f":"IF($E529>0, $E529, $E528)","v":2000},0,0,""]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION",null,null,"Smart Meter Entity Charge (if applicable)",null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"RESIDENTIAL\", E526))=TRUE, ISNUMBER(SEARCH(\"GENERAL SERVICE LESS THAN 50\", E526))=TRUE), SME, 0)","v":0},1,{"$f":"G548*F548","v":0},{"$f":"IF(OR(ISNUMBER(SEARCH(\"RESIDENTIAL\", E526))=TRUE, ISNUMBER(SEARCH(\"GENERAL SERVICE LESS THAN 50\", E526))=TRUE), SME, 0)","v":0},1,{"$f":"J548*I548","v":0},0,{"$f":"IF(ISERROR(L548/H548), \"\", L548/H548)","v":""}]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION",null,null,"Additional Fixed Rate Riders ",null,0,1,0,0,1,{"$f":"J549*I549","v":0},{"$f":"K549-H549","v":0},{"$f":"IF(ISERROR(L549/H549), \"\", L549/H549)","v":""}]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION",null,null,"Additional Volumetric Rate Riders ",null,null,{"$f":"IF($E529>0, $E529, $E528)","v":2000},{"$f":"G550*F550","v":0},0,{"$f":"IF($E529>0, $E529, $E528)","v":2000},{"$f":"J550*I550","v":0},0,{"$f":"IF(ISERROR(L550/H550), \"\", L550/H550)","v":""}]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","ST_B",{"$f":"B38","v":9},"Sub-Total B - Distribution (includes Sub-Total A)",null,null,null,{"$f":"SUM(H542:H550)","v":49.388050000000007},null,null,{"$f":"SUM(K542:K550)","v":50.188050000000004},0.79999999999999716,{"$f":"IF((H551)=0,\"\",(L551/H551))","v":1.6198250386480071E-2}]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION",null,null,"RTSR - Network",null,6.6E-3,{"$f":"IF($E529>0, $E529, $E528*$E530)","v":2063},{"$f":"G552*F552","v":13.6158},6.7999999999999996E-3,{"$f":"IF($E529>0, $E529, $E528*$E531)","v":2063},{"$f":"J552*I552","v":14.0284},0.41259999999999941,{"$f":"IF(ISERROR(L552/H552), \"\", L552/H552)","v":3.0303030303030259E-2},{"$f":"IF(ISERROR(ABS(M552)), \"\", IF(ABS(M552)>=4%, \"In the manager's summary, discuss the reasoning for the change in RTSR rates\", \"\"))","v":""}]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION",null,null,"RTSR - Connection and/or Line and Transformation Connection",null,5.4999999999999997E-3,{"$f":"IF($E529>0, $E529, $E528*$E530)","v":2063},{"$f":"G553*F553","v":11.346499999999999},5.7000000000000002E-3,{"$f":"IF($E529>0, $E529, $E528*$E531)","v":2063},{"$f":"J553*I553","v":11.7591},0.41260000000000119,{"$f":"IF(ISERROR(L553/H553), \"\", L553/H553)","v":3.6363636363636473E-2},{"$f":"IF(ISERROR(ABS(M553)), \"\", IF(ABS(M553)>=4%, \"In the manager's summary, discuss the reasoning for the change in RTSR rates\", \"\"))","v":""}]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","ST_C",{"$f":"B38","v":9},"Sub-Total C - Delivery (including Sub-Total B)",null,null,null,{"$f":"SUM(H551:H553)","v":74.350350000000006},null,null,{"$f":"SUM(K551:K553)","v":75.975550000000013},1.6252000000000066,{"$f":"IF((H554)=0,\"\",(L554/H554))","v":2.1858673160247484E-2}]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION",null,null,"Wholesale Market Service Charge (WMSC)",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$E$14),'[2]17. Regulatory Charges'!$D$15+'[2]17. Regulatory Charges'!$D$16,'[2]17. Regulatory Charges'!$E$15+'[2]17. Regulatory Charges'!$E$16)","v":3.4000000000000002E-3},{"$f":"E528*E530","v":2063},{"$f":"G555*F555","v":7.0142000000000007},{"$f":"'[2]17. Regulatory Charges'!$E$15+'[2]17. Regulatory Charges'!$E$16","v":3.4000000000000002E-3},{"$f":"E528*E531","v":2063},{"$f":"J555*I555","v":7.0142000000000007},0,{"$f":"IF(ISERROR(L555/H555), \"\", L555/H555)","v":0}]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION",null,null,"Rural and Remote Rate Protection (RRRP)",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$D$14),'[2]17. Regulatory Charges'!$D$17,'[2]17. Regulatory Charges'!$E$17)","v":5.0000000000000001E-4},{"$f":"E528*E530","v":2063},1.0315000000000001,{"$f":"'[2]17. Regulatory Charges'!$E$17","v":5.0000000000000001E-4},{"$f":"E528*E531","v":2063},1.0315000000000001,0,0]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION",null,null,"Standard Supply Service Charge",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$D$14),'[2]17. Regulatory Charges'!$D$18,'[2]17. Regulatory Charges'!$E$18)","v":0.25},null,0,{"$f":"'[2]17. Regulatory Charges'!$E$18","v":0.25},null,0,0,""]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION",null,null,"Ontario Electricity Support Program \n(OESP) "]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","RPP",null,"TOU - Off Peak",null,{"$f":"OffPeak","v":6.5000000000000002E-2},{"$f":"IF(AND(E528*12>=150000),0.65*E528*E530,0.65*E528)","v":1300},84.5,{"$f":"OffPeak","v":6.5000000000000002E-2},{"$f":"IF(AND(E528*12>=150000),0.65*E528*E531,0.65*E528)","v":1300},84.5,{"$f":"K559-H559","v":0},0]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","RPP",null,"TOU - Mid Peak",null,{"$f":"MidPeak","v":9.4E-2},{"$f":"IF(AND(E528*12>=150000),0.17*E528*E530,0.17*E528)","v":340},31.96,{"$f":"MidPeak","v":9.4E-2},{"$f":"IF(AND(E528*12>=150000),0.17*E528*E531,0.17*E528)","v":340},31.96,{"$f":"K560-H560","v":0},0]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","RPP",null,"TOU - On Peak",null,{"$f":"OnPeak","v":0.13400000000000001},{"$f":"IF(AND(E528*12>=150000),0.18*E528*E530,0.18*E528)","v":360},48.24,{"$f":"OnPeak","v":0.13400000000000001},{"$f":"IF(AND(E528*12>=150000),0.18*E528*E531,0.18*E528)","v":360},48.24,{"$f":"K561-H561","v":0},0]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"Non-RPP Retailer Avg. Price",null,0.1101,{"$f":"IF(AND(E528*12>=150000),E528*E530,E528)","v":2000},{"$f":"G562*F562","v":220.20000000000002},{"$f":"F562","v":0.1101},{"$f":"IF(AND(E528*12>=150000),E528*E531,E528)","v":2000},{"$f":"J562*I562","v":220.20000000000002},{"$f":"K562-H562","v":0},0]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","Non-RPP (Other)",null,"Average IESO Wholesale Market Price",null,0.1101,{"$f":"IF(AND(E528*12>=150000),E528*E530,E528)","v":2000},{"$f":"G563*F563","v":220.20000000000002},{"$f":"F563","v":0.1101},{"$f":"IF(AND(E528*12>=150000),E528*E531,E528)","v":2000},{"$f":"J563*I563","v":220.20000000000002},{"$f":"K563-H563","v":0},0]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION"]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","RPP",null,"Total Bill on TOU (before Taxes)",null,null,null,{"$f":"SUM(H555:H561,H554)","v":247.09604999999999},null,null,{"$f":"SUM(K555:K561,K554)","v":248.72125},{"$f":"K565-H565","v":1.6252000000000066},{"$f":"IF((H565)=0,\"\",(L565/H565))","v":6.5771994331759115E-3}]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","RPP",null,"HST",null,0.13,null,{"$f":"H565*F566","v":32.122486500000001},0.13,null,{"$f":"K565*I566","v":32.333762499999999},{"$f":"K566-H566","v":0.21127599999999802},{"$f":"IF((H566)=0,\"\",(L566/H566))","v":6.5771994331758231E-3}]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","RPP",null,"8% Rebate",null,0.08,null,0,0.08,null,0,{"$f":"K567-H567","v":0}]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","RPP_TOTAL",{"$f":"B38","v":9},"Total Bill on TOU",null,null,null,{"$f":"H565+H566+H567","v":279.21853649999997},null,null,{"$f":"K565+K566+K567","v":281.05501249999998},{"$f":"K568-H568","v":1.8364760000000047},{"$f":"IF((H568)=0,\"\",(L568/H568))","v":6.577199433175902E-3}]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","RPP"]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"Total Bill on Non-RPP Avg. Price",null,null,null,{"$f":"SUM(H562,H555:H558,H554)","v":302.59604999999999},null,null,{"$f":"SUM(K562,K555:K558,K554)","v":304.22125},{"$f":"K570-H570","v":1.6252000000000066},{"$f":"IF((H570)=0,\"\",(L570/H570))","v":5.3708566255243808E-3}]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"HST",null,0.13,null,{"$f":"H570*F571","v":39.337486499999997},0.13,null,{"$f":"K570*I571","v":39.548762500000002},{"$f":"K571-H571","v":0.21127600000000513},{"$f":"IF((H571)=0,\"\",(L571/H571))","v":5.3708566255244892E-3}]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","Non-RPP (Retailer)",null,"8% Rebate",null,0.08,null,0,0.08,null,0]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","Non-RPP (Retailer)_TOTAL",null,"Total Bill on Non-RPP Avg. Price",null,null,null,{"$f":"SUM(H570,H571)","v":341.9335365},null,null,{"$f":"SUM(K570,K571)","v":343.77001250000001},{"$f":"K573-H573","v":1.8364760000000047},{"$f":"IF((H573)=0,\"\",(L573/H573))","v":5.3708566255243721E-3}]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","Non-RPP (Retailer)"]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","Non-RPP (Other)",null,"Total Bill on Average IESO Wholesale Market Price",null,null,null,{"$f":"SUM(H563,H555:H558,H554)","v":302.59604999999999},null,null,{"$f":"SUM(K563,K555:K558,K554)","v":304.22125},{"$f":"K575-H575","v":1.6252000000000066},{"$f":"IF((H575)=0,\"\",(L575/H575))","v":5.3708566255243808E-3}]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","Non-RPP (Other)",null,"HST",null,0.13,null,{"$f":"H575*F576","v":39.337486499999997},0.13,null,{"$f":"K575*I576","v":39.548762500000002},{"$f":"K576-H576","v":0.21127600000000513},{"$f":"IF((H576)=0,\"\",(L576/H576))","v":5.3708566255244892E-3}]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","Non-RPP (Other)",null,"8% Rebate",null,0.08,null,0,0.08,null,0]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","Non-RPP (Other)_TOTAL",null,"Total Bill on Average IESO Wholesale Market Price",null,null,null,{"$f":"SUM(H575,H576)","v":341.9335365},null,null,{"$f":"SUM(K575,K576)","v":343.77001250000001},{"$f":"K578-H578","v":1.8364760000000047},{"$f":"IF((H578)=0,\"\",(L578/H578))","v":5.3708566255243721E-3}]
["UNMETERED SCATTERED LOAD SERVICE CLASSIFICATION","Non-RPP (Other)"]
[]
[]
[null,null,null,"Customer Class:",{"$f":"D49","v":"Add additional scenarios if required"},null,null,null,null,null,{"$f":"IF(N49=\"DEMAND - INTERVAL\",\"RTSR - INTERVAL METERED\",\"\")","v":""},null,null,null,null,null,null,null,null,"X"]
[null,null,null,"RPP / Non-RPP:"]
[null,null,null,"Consumption",null,"kWh"]
[null,null,null,"Demand",null,"kW"]
[null,null,null,"Current Loss Factor"]
[null,null,null,"Proposed/Approved Loss Factor"]
[]
[null,null,null,null,null,"Current OEB-Approved",null,null,"Proposed",null,null,"Impact"]
[null,null,null,null,null,"Rate","Volume","Charge","Rate","Volume","Charge","$ Change","% Change"]
[null,null,null,null,null,"($)",null,"($)","($)",null,"($)"]
[{"$f":"$E582","v":"Add additional scenarios if required"},null,null,"Monthly Service Charge",null,null,1,{"$f":"G592*F592","v":0},null,{"$f":"G592","v":1},{"$f":"J592*I592","v":0},{"$f":"K592-H592","v":0},{"$f":"IF(ISERROR(L592/H592), \"\", L592/H592)","v":""}]
[{"$f":"A592","v":"Add additional scenarios if required"},null,null,"Distribution Volumetric Rate",null,null,{"$f":"IF($E585>0, $E585, $E584)","v":0},{"$f":"G593*F593","v":0},null,{"$f":"IF($E585>0, $E585, $E584)","v":0},{"$f":"J593*I593","v":0},0,{"$f":"IF(ISERROR(L593/H593), \"\", L593/H593)","v":""}]
[{"$f":"A593","v":"Add additional scenarios if required"},null,null,"RRRP Credit",null,null,{"$f":"IF($E585>0, $E585, $E584)","v":0},0,null,{"$f":"IF($E585>0, $E585, $E584)","v":0},0]
["Add additional scenarios if required",null,null,"DRP Adjustment",null,null,{"$f":"IF($E585>0, $E585, $E584)","v":0},0,null,{"$f":"IF($E585>0, $E585, $E584)","v":0},0,{"$f":"K595-H595","v":0},{"$f":"IF(ISERROR(L595/H595), \"\", L595/H595)","v":""}]
["Add additional scenarios if required",null,null,"Fixed Rate Riders",null,null,1,0,null,{"$f":"G596","v":1},{"$f":"J596*I596","v":0},0,""]
["Add additional scenarios if required",null,null,"Volumetric Rate Riders",null,null,{"$f":"IF($E585>0, $E585, $E584)","v":0},0,null,{"$f":"IF($E585>0, $E585, $E584)","v":0},0,0,""]
["Add additional scenarios if required","ST_A",{"$f":"B49","v":20},"Sub-Total A (excluding pass through)",null,null,null,{"$f":"SUM(H592:H597)","v":0},null,null,{"$f":"SUM(K592:K597)","v":0},0,{"$f":"IF((H598)=0,\"\",(L598/H598))","v":""}]
["Add additional scenarios if required",null,null,"Line Losses on Cost of Power",null,{"$f":"IF((E584*12>=150000), 0, IF(E583=\"RPP\",(F615*0.65+F616*0.17+F617*0.18),IF(E583=\"Non-RPP (Retailer)\",F618,F619)))","v":0.1101},{"$f":"IF(F599=0, 0, $E584*E586-E584)","v":0},{"$f":"G599*F599","v":0},{"$f":"IF((E584*12>=150000), 0, IF(E583=\"RPP\",(I615*0.65+I616*0.17+I617*0.18),IF(E583=\"Non-RPP (Retailer)\",I618,I619)))","v":0.1101},{"$f":"IF(I599=0, 0, E584*E587-E584)","v":0},{"$f":"J599*I599","v":0},{"$f":"K599-H599","v":0},{"$f":"IF(ISERROR(L599/H599), \"\", L599/H599)","v":""}]
["Add additional scenarios if required",null,null,"Total Deferral/Variance Account Rate Riders",null,null,{"$f":"IF($E585>0, $E585, $E584)","v":0},0,null,{"$f":"IF($E585>0, $E585, $E584)","v":0},0,0,""]
["Add additional scenarios if required",null,null,"CBR Class B Rate Riders",null,null,{"$f":"IF($E585>0, $E585, $E584)","v":0},{"$f":"G601*F601","v":0},null,{"$f":"IF($E585>0, $E585, $E584)","v":0},{"$f":"J601*I601","v":0},0,""]
["Add additional scenarios if required",null,null,"GA Rate Riders",null,null,{"$f":"E584","v":0},{"$f":"G602*F602","v":0},null,{"$f":"E584","v":0},0,0,""]
["Add additional scenarios if required",null,null,"Low Voltage Service Charge",null,null,{"$f":"IF($E585>0, $E585, $E584)","v":0},0,null,{"$f":"IF($E585>0, $E585, $E584)","v":0},0,0,""]
["Add additional scenarios if required",null,null,"Smart Meter Entity Charge (if applicable)",null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"RESIDENTIAL\", E582))=TRUE, ISNUMBER(SEARCH(\"GENERAL SERVICE LESS THAN 50\", E582))=TRUE), SME, 0)","v":0},1,{"$f":"G604*F604","v":0},{"$f":"IF(OR(ISNUMBER(SEARCH(\"RESIDENTIAL\", E582))=TRUE, ISNUMBER(SEARCH(\"GENERAL SERVICE LESS THAN 50\", E582))=TRUE), SME, 0)","v":0},1,{"$f":"J604*I604","v":0},0,{"$f":"IF(ISERROR(L604/H604), \"\", L604/H604)","v":""}]
["Add additional scenarios if required",null,null,"Additional Fixed Rate Riders ",null,null,1,0,null,1,{"$f":"J605*I605","v":0},{"$f":"K605-H605","v":0},{"$f":"IF(ISERROR(L605/H605), \"\", L605/H605)","v":""}]
["Add additional scenarios if required",null,null,"Additional Volumetric Rate Riders ",null,null,{"$f":"IF($E585>0, $E585, $E584)","v":0},{"$f":"G606*F606","v":0},null,{"$f":"IF($E585>0, $E585, $E584)","v":0},{"$f":"J606*I606","v":0},0,{"$f":"IF(ISERROR(L606/H606), \"\", L606/H606)","v":""}]
["Add additional scenarios if required","ST_B",{"$f":"B49","v":20},"Sub-Total B - Distribution (includes Sub-Total A)",null,null,null,{"$f":"SUM(H598:H606)","v":0},null,null,{"$f":"SUM(K598:K606)","v":0},0,{"$f":"IF((H607)=0,\"\",(L607/H607))","v":""}]
["Add additional scenarios if required",null,null,"RTSR - Network",null,null,{"$f":"IF($E585>0, $E585, $E584*$E586)","v":0},{"$f":"G608*F608","v":0},null,{"$f":"IF($E585>0, $E585, $E584*$E587)","v":0},{"$f":"J608*I608","v":0},0,{"$f":"IF(ISERROR(L608/H608), \"\", L608/H608)","v":""},{"$f":"IF(ISERROR(ABS(M608)), \"\", IF(ABS(M608)>=4%, \"In the manager's summary, discuss the reasoning for the change in RTSR rates\", \"\"))","v":""}]
["Add additional scenarios if required",null,null,"RTSR - Connection and/or Line and Transformation Connection",null,null,{"$f":"IF($E585>0, $E585, $E584*$E586)","v":0},{"$f":"G609*F609","v":0},null,{"$f":"IF($E585>0, $E585, $E584*$E587)","v":0},{"$f":"J609*I609","v":0},0,{"$f":"IF(ISERROR(L609/H609), \"\", L609/H609)","v":""},{"$f":"IF(ISERROR(ABS(M609)), \"\", IF(ABS(M609)>=4%, \"In the manager's summary, discuss the reasoning for the change in RTSR rates\", \"\"))","v":""}]
["Add additional scenarios if required","ST_C",{"$f":"B49","v":20},"Sub-Total C - Delivery (including Sub-Total B)",null,null,null,{"$f":"SUM(H607:H609)","v":0},null,null,{"$f":"SUM(K607:K609)","v":0},0,{"$f":"IF((H610)=0,\"\",(L610/H610))","v":""}]
["Add additional scenarios if required",null,null,"Wholesale Market Service Charge (WMSC)",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$E$14),'[2]17. Regulatory Charges'!$D$15+'[2]17. Regulatory Charges'!$D$16,'[2]17. Regulatory Charges'!$E$15+'[2]17. Regulatory Charges'!$E$16)","v":3.4000000000000002E-3},{"$f":"E584*E586","v":0},{"$f":"G611*F611","v":0},{"$f":"'[2]17. Regulatory Charges'!$E$15+'[2]17. Regulatory Charges'!$E$16","v":3.4000000000000002E-3},{"$f":"E584*E587","v":0},{"$f":"J611*I611","v":0},0,{"$f":"IF(ISERROR(L611/H611), \"\", L611/H611)","v":""}]
["Add additional scenarios if required",null,null,"Rural and Remote Rate Protection (RRRP)",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$D$14),'[2]17. Regulatory Charges'!$D$17,'[2]17. Regulatory Charges'!$E$17)","v":5.0000000000000001E-4},{"$f":"E584*E586","v":0},0,{"$f":"'[2]17. Regulatory Charges'!$E$17","v":5.0000000000000001E-4},{"$f":"E584*E587","v":0},0,0,""]
["Add additional scenarios if required",null,null,"Standard Supply Service Charge",null,{"$f":"IF(AND('[2]1. Information Sheet'!$F$26:$H$26>='[2]17. Regulatory Charges'!$D$14,'[2]1. Information Sheet'!$F$26:$H$26<'[2]17. Regulatory Charges'!$D$14),'[2]17. Regulatory Charges'!$D$18,'[2]17. Regulatory Charges'!$E$18)","v":0.25},1,0.25,{"$f":"'[2]17. Regulatory Charges'!$E$18","v":0.25},1,0.25,0,0]
["Add additional scenarios if required",null,null,"Ontario Electricity Support Program \n(OESP) "]
["Add additional scenarios if required","RPP",null,"TOU - Off Peak",null,{"$f":"OffPeak","v":6.5000000000000002E-2},{"$f":"IF(AND(E584*12>=150000),0.65*E584*E586,0.65*E584)","v":0},0,{"$f":"OffPeak","v":6.5000000000000002E-2},{"$f":"IF(AND(E584*12>=150000),0.65*E584*E587,0.65*E584)","v":0},0,{"$f":"K615-H615","v":0},""]
["Add additional scenarios if required","RPP",null,"TOU - Mid Peak",null,{"$f":"MidPeak","v":9.4E-2},{"$f":"IF(AND(E584*12>=150000),0.17*E584*E586,0.17*E584)","v":0},0,{"$f":"MidPeak","v":9.4E-2},{"$f":"IF(AND(E584*12>=150000),0.17*E584*E587,0.17*E584)","v":0},0,{"$f":"K616-H616","v":0},""]
["Add additional scenarios if required","RPP",null,"TOU - On Peak",null,{"$f":"OnPeak","v":0.13400000000000001},{"$f":"IF(AND(E584*12>=150000),0.18*E584*E586,0.18*E584)","v":0},0,{"$f":"OnPeak","v":0.13400000000000001},{"$f":"IF(AND(E584*12>=150000),0.18*E584*E587,0.18*E584)","v":0},0,{"$f":"K617-H617","v":0},""]
["Add additional scenarios if required","Non-RPP (Retailer)",null,"Non-RPP Retailer Avg. Price",null,0.1101,{"$f":"IF(AND(E584*12>=150000),E584*E586,E584)","v":0},{"$f":"G618*F618","v":0},{"$f":"F618","v":0.1101},{"$f":"IF(AND(E584*12>=150000),E584*E587,E584)","v":0},{"$f":"J618*I618","v":0},{"$f":"K618-H618","v":0},""]
["Add additional scenarios if required","Non-RPP (Other)",null,"Average IESO Wholesale Market Price",null,0.1101,{"$f":"IF(AND(E584*12>=150000),E584*E586,E584)","v":0},{"$f":"G619*F619","v":0},{"$f":"F619","v":0.1101},{"$f":"IF(AND(E584*12>=150000),E584*E587,E584)","v":0},{"$f":"J619*I619","v":0},{"$f":"K619-H619","v":0},""]
["Add additional scenarios if required"]
["Add additional scenarios if required","RPP",null,"Total Bill on TOU (before Taxes)",null,null,null,{"$f":"SUM(H611:H617,H610)","v":0.25},null,null,{"$f":"SUM(K611:K617,K610)","v":0.25},{"$f":"K621-H621","v":0},{"$f":"IF((H621)=0,\"\",(L621/H621))","v":0}]
["Add additional scenarios if required","RPP",null,"HST",null,0.13,null,{"$f":"H621*F622","v":3.2500000000000001E-2},0.13,null,{"$f":"K621*I622","v":3.2500000000000001E-2},{"$f":"K622-H622","v":0},{"$f":"IF((H622)=0,\"\",(L622/H622))","v":0}]
["Add additional scenarios if required","RPP",null,"8% Rebate",null,0.08,null,{"$f":"H621*-F623","v":-0.02},0.08,null,{"$f":"K621*-I623","v":-0.02},{"$f":"K623-H623","v":0}]
["Add additional scenarios if required","RPP_TOTAL",null,"Total Bill on TOU",null,null,null,{"$f":"H621+H622+H623","v":0.26249999999999996},null,null,{"$f":"K621+K622+K623","v":0.26249999999999996},{"$f":"K624-H624","v":0},{"$f":"IF((H624)=0,\"\",(L624/H624))","v":0}]
["Add additional scenarios if required","RPP"]
["Add additional scenarios if required","Non-RPP (Retailer)",null,"Total Bill on Non-RPP Avg. Price",null,null,null,{"$f":"SUM(H618,H611:H614,H610)","v":0.25},null,null,{"$f":"SUM(K618,K611:K614,K610)","v":0.25},{"$f":"K626-H626","v":0},{"$f":"IF((H626)=0,\"\",(L626/H626))","v":0}]
["Add additional scenarios if required","Non-RPP (Retailer)",null,"HST",null,0.13,null,{"$f":"H626*F627","v":3.2500000000000001E-2},0.13,null,{"$f":"K626*I627","v":3.2500000000000001E-2},{"$f":"K627-H627","v":0},{"$f":"IF((H627)=0,\"\",(L627/H627))","v":0}]
["Add additional scenarios if required","Non-RPP (Retailer)",null,"8% Rebate",null,0.08,null,null,0.08]
["Add additional scenarios if required","Non-RPP (Retailer)_TOTAL",null,"Total Bill on Non-RPP Avg. Price",null,null,null,{"$f":"SUM(H626,H627)","v":0.28249999999999997},null,null,{"$f":"SUM(K626,K627)","v":0.28249999999999997},{"$f":"K629-H629","v":0},{"$f":"IF((H629)=0,\"\",(L629/H629))","v":0}]
["Add additional scenarios if required","Non-RPP (Retailer)"]
["Add additional scenarios if required","Non-RPP (Other)",null,"Total Bill on Average IESO Wholesale Market Price",null,null,null,{"$f":"SUM(H619,H611:H614,H610)","v":0.25},null,null,{"$f":"SUM(K619,K611:K614,K610)","v":0.25},{"$f":"K631-H631","v":0},{"$f":"IF((H631)=0,\"\",(L631/H631))","v":0}]
["Add additional scenarios if required","Non-RPP (Other)",null,"HST",null,0.13,null,{"$f":"H631*F632","v":3.2500000000000001E-2},0.13,null,{"$f":"K631*I632","v":3.2500000000000001E-2},{"$f":"K632-H632","v":0},{"$f":"IF((H632)=0,\"\",(L632/H632))","v":0}]
["Add additional scenarios if required","Non-RPP (Other)",null,"8% Rebate",null,0.08,null,null,0.08]
["Add additional scenarios if required","Non-RPP (Other)_TOTAL",null,"Total Bill on Average IESO Wholesale Market Price",null,null,null,{"$f":"SUM(H631,H632)","v":0.28249999999999997},null,null,{"$f":"SUM(K631,K632)","v":0.28249999999999997},{"$f":"K634-H634","v":0},{"$f":"IF((H634)=0,\"\",(L634/H634))","v":0}]
["Add additional scenarios if required","Non-RPP (Other)"]