{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["App.2-W_Bill Impacts - Res","App.2-W_Bill Impacts- GS<50","App.2-W_Bill Impacts - GS>50","App.2-W_Bill Impacts - Sentinel","App.2-W_Bill Impacts - Street","App.2-W_Bill Impacts - USL","App.2-W_Bill Impacts -Embedded"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":28,"comments":7,"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":"App.2-W_Bill Impacts - Res","index":0,"n_rows":85,"n_cols":20,"rows_kept":85,"cut":false,"hidden":false,"merged":[[9,1,9,14],[2,0,2,10],[18,13,19,13],[18,14,19,14],[17,5,17,7],[17,9,17,11],[17,13,17,14],[13,3,13,14],[10,1,10,14],[60,1,60,3],[66,1,66,3],[67,1,67,3],[61,1,61,3],[18,3,19,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"File Number:",null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Exhibit:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tab:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[]
[null,"Appendix 2-W"]
[null,"Bill Impacts"]
[]
[]
[null,"Customer Class:",null,"Residential"]
[]
[null,null,null,"Consumption",null,800," kWh"]
[]
[null,null,null,null,null,"Current Board-Approved",null,null,null,"Proposed",null,null,null,"Impact"]
[null,null,null,"Charge Unit",null,"Rate","Volume","Charge",null,"Rate","Volume","Charge",null,"$ Change","% Change"]
[null,null,null,null,null,"($)",null,"($)",null,"($)",null,"($)"]
[null,"Monthly Service Charge",null,null,null,11.46,1,{"$f":"G21*F21","v":11.46},null,11.83,1,{"$f":"K21*J21","v":11.83},null,{"$f":"L21-H21","v":0.36999999999999922},{"$f":"IF((H21)=0,\"\",(N21/H21))","v":3.2286212914485093E-2}]
[null,"Smart Meter Rate Adder",null,null,null,null,1,{"$f":"G22*F22","v":0},null,null,1,{"$f":"K22*J22","v":0},null,{"$f":"L22-H22","v":0},{"$f":"IF((H22)=0,\"\",(N22/H22))","v":""}]
[null,"Smart Meter Disposition Rate Rider",null,null,null,null,1,0,null,-0.48,1,{"$f":"K23*J23","v":-0.48},null,{"$f":"L23-H23","v":-0.48},{"$f":"IF((H23)=0,\"\",(N23/H23))","v":""}]
[null,"Smart Metering Entity Charge",null,null,null,null,1,0,null,0.78800000000000003,1,0.78800000000000003,null,0.78800000000000003,""]
[null,"Stranded Meter Recovery Rate Rider ",null,null,null,null,1,0,null,1.47,1,1.47,null,1.47,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,"Distribution Volumetric Rate",null,null,null,1.38E-2,{"$f":"$F$16","v":800},11.04,null,1.4200000000000001E-2,{"$f":"$F$16","v":800},11.360000000000001,null,0.32000000000000206,2.8985507246376999E-2]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,"LRAM & SSM Rate Rider",null,null,null,1.2999999999999999E-3,{"$f":"$F$16","v":800},1.04,null,2.9999999999999997E-4,{"$f":"$F$16","v":800},0.24,null,-0.8,-0.76923076923076927]
[null,"Tax change",null,null,null,-5.0000000000000001E-4,{"$f":"$F$16","v":800},-0.4,null,null,800,0,null,0.4,{"$f":"IF((H30)=0,\"\",(N30/H30))","v":-1}]
[null,null,null,null,null,null,800,0,null,null,800,0,null,0,""]
[null,null,null,null,null,null,800,0,null,null,800,0,null,0,""]
[null,null,null,null,null,null,800,0,null,null,800,0,null,0,""]
[null,null,null,null,null,null,800,0,null,null,800,0,null,0,""]
[null,null,null,null,null,null,800,0,null,null,800,0,null,0,""]
[null,null,null,null,null,null,800,0,null,null,800,0,null,0,""]
[null,"Sub-Total A",null,null,null,null,null,{"$f":"SUM(H21:H36)","v":23.14},null,null,null,{"$f":"SUM(L21:L36)","v":25.208000000000002},null,2.0680000000000014,8.9369057908383814E-2]
[null,"Deferral/Variance Account Disposition Rate Rider",null,null,null,-7.0000000000000001E-3,{"$f":"$F$16","v":800},{"$f":"G38*F38","v":-5.6000000000000005},null,-5.0000000000000001E-3,{"$f":"$F$16","v":800},{"$f":"K38*J38","v":-4},null,{"$f":"L38-H38","v":1.6000000000000005},{"$f":"IF((H38)=0,\"\",(N38/H38))","v":-0.28571428571428581}]
[null,"Global Adjustment - Non RPP",null,null,null,null,{"$f":"$F$16","v":800},{"$f":"G39*F39","v":0},null,null,{"$f":"$F$16","v":800},{"$f":"K39*J39","v":0},null,{"$f":"L39-H39","v":0},{"$f":"IF((H39)=0,\"\",(N39/H39))","v":""}]
[null,null,null,null,null,null,800,0,null,null,800,0,null,0,""]
[null,null,null,null,null,null,800,0,null,null,800,0,null,0,""]
[null,"Low Voltage Service Charge",null,null,null,null,800,{"$f":"G42*F42","v":0},null,null,800,{"$f":"K42*J42","v":0},null,{"$f":"L42-H42","v":0},{"$f":"IF((H42)=0,\"\",(N42/H42))","v":""}]
[null,"Smart Meter Entity Charge",null,null,null,null,null,null,null,null,800,{"$f":"K43*J43","v":0},null,{"$f":"L43-H43","v":0}]
[null,"Sub-Total B - Distribution (includes Sub-Total A)",null,null,null,null,null,{"$f":"SUM(H38:H42)+H37","v":17.54},null,null,null,{"$f":"SUM(L38:L42)+L37","v":21.208000000000002},null,{"$f":"L44-H44","v":3.6680000000000028},{"$f":"IF((H44)=0,\"\",(N44/H44))","v":0.20912200684150531}]
[null,"RTSR - Network",null,null,null,8.0000000000000002E-3,{"$f":"F16*(1+F71)","v":833.6},{"$f":"G45*F45","v":6.6688000000000001},null,7.4999999999999997E-3,{"$f":"F16*(1+J71)","v":827.92},{"$f":"K45*J45","v":6.2093999999999996},null,-0.45940000000000047,-6.8887955854126756E-2]
[null,"RTSR - Line and Transformation Connection",null,null,null,5.4999999999999997E-3,{"$f":"G45","v":833.6},{"$f":"G46*F46","v":4.5847999999999995},null,5.3E-3,{"$f":"K45","v":827.92},{"$f":"K46*J46","v":4.3879760000000001},null,-0.19682399999999944,-4.2929680683999188E-2]
[null,"Sub-Total C - Delivery (including Sub-Total B)",null,null,null,null,null,{"$f":"SUM(H44:H46)","v":28.793599999999998},null,null,null,{"$f":"SUM(L44:L46)","v":31.805376000000003},null,3.0117760000000047,0.10459879973327423]
[null,"Wholesale Market Service Charge (WMSC)",null,null,null,4.4000000000000003E-3,{"$f":"G46","v":833.6},{"$f":"G48*F48","v":3.6678400000000004},null,4.4000000000000003E-3,{"$f":"K46","v":827.92},{"$f":"K48*J48","v":3.6428479999999999},null,-2.4992000000000569E-2,-6.8138195777352794E-3]
[null,"Rural and Remote Rate Protection (RRRP)",null,null,null,1.1999999999999999E-3,{"$f":"G46","v":833.6},1.0003199999999999,null,1.1999999999999999E-3,{"$f":"K46","v":827.92},0.99350399999999983,null,-6.8160000000000442E-3,-6.8138195777351701E-3]
[null,"Standard Supply Service Charge",null,null,null,0.25,1,0.25,null,0.25,1,0.25,null,0,0]
[null,"Debt Retirement Charge (DRC)",null,null,null,7.0000000000000001E-3,{"$f":"G49","v":833.6},5.8352000000000004,null,7.0000000000000001E-3,{"$f":"K49","v":827.92},5.7954400000000001,null,-3.976000000000024E-2,{"$f":"IF((H51)=0,\"\",(N51/H51))","v":-6.8138195777351657E-3}]
[null,"Energy - RPP - Tier 1",null,null,null,7.8E-2,{"$f":"IF($T$1=1,IF($F$16>=600,600,IF($F$16<600,$F$16*(1+$F$71),$F$16-600)),IF($T$1=2,IF($F$16>=1000,1000,IF($F$16<1000,$F$16*(1+$F$71),$F$16-1000))))","v":833.6},{"$f":"G52*F52","v":65.020800000000008},null,7.8E-2,{"$f":"IF($T$1=1,IF($F$16>=600,600,IF($F$16<600,$F$16*(1+$J$71),$F$16-600)),IF($T$1=2,IF($F$16>=1000,1000,IF($F$16<1000,$F$16*(1+$J$71),$F$16-1000))))","v":827.92},{"$f":"K52*J52","v":64.577759999999998},null,-0.44304000000001054,-6.8138195777352863E-3]
[null,"Energy - RPP - Tier 2",null,null,null,9.0999999999999998E-2,{"$f":"IF($T$1=1,IF($F$16>=600,$F$16*(1+$F$71)-600,IF($F$16<600,0,)), IF($T$1=2,IF($F$16>=1000,$F$16*(1+$F$71)-1000,IF($F$16<1000,0))))","v":0},{"$f":"G53*F53","v":0},null,9.0999999999999998E-2,{"$f":"IF($T$1=1,IF($F$16>=600,$F$16*(1+$J$71)-600,IF($F$16<600,0,)), IF($T$1=2,IF($F$16>=1000,$F$16*(1+$J$71)-1000,IF($F$16<1000,0))))","v":0},{"$f":"K53*J53","v":0},null,0,""]
[null,"TOU - Off Peak",null,null,null,6.7000000000000004E-2,{"$f":"0.64*$F$16*(1+$F$71)","v":533.50400000000002},35.744768000000001,null,6.7000000000000004E-2,{"$f":"0.64*$F$16*(1+$J$71)","v":529.86879999999996},35.501209600000003,null,-0.24355839999999773,-6.8138195777350608E-3]
[null,"TOU - Mid Peak",null,null,null,0.104,{"$f":"0.18*$F$16*(1+$F$71)","v":150.048},15.604991999999999,null,0.104,{"$f":"0.18*$F$16*(1+$J$71)","v":149.0256},15.498662399999999,null,-0.10632960000000047,-6.8138195777351553E-3]
[null,"TOU - On Peak",null,null,null,0.124,{"$f":"0.18*$F$16*(1+$F$71)","v":150.048},18.605951999999998,null,0.124,{"$f":"0.18*$F$16*(1+$J$71)","v":149.0256},18.479174399999998,null,-0.12677760000000049,-6.8138195777351519E-3]
[]
[null,"Total Bill on RPP (before Taxes)",null,null,null,null,null,{"$f":"SUM(H47:H53)","v":104.56776000000001},null,null,null,{"$f":"SUM(L47:L53)","v":107.06492800000001},null,2.4971680000000021,2.3880859645458618E-2]
[null,"HST",null,null,null,0.13,null,{"$f":"H58*F59","v":13.593808800000001},null,0.13,null,{"$f":"L58*J59","v":13.918440640000002},null,0.32463184000000034,2.3880859645458621E-2]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H58+H59","v":118.16156880000001},null,null,null,{"$f":"L58+L59","v":120.98336864000001},null,2.8217998399999971,2.3880859645458573E-2]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H60*10%,2)","v":-11.82},null,null,null,{"$f":"ROUND(-L60*10%,2)","v":-12.1},null,-0.27999999999999936,2.3688663282571857E-2]
[null,"Total Bill on RPP (including OCEB)",null,null,null,null,null,{"$f":"SUM(H60:H61)","v":106.3415688},null,null,null,{"$f":"SUM(L60:L61)","v":108.88336864000001},null,2.5417998400000101,2.3902222514513159E-2]
[]
[null,"Total Bill on TOU (before Taxes)",null,null,null,null,null,{"$f":"SUM(H47:H51,H54:H56)","v":109.502672},null,null,null,{"$f":"SUM(L47:L51,L54:L56)","v":111.96621440000001},null,{"$f":"L64-H64","v":2.4635424000000086},{"$f":"IF((H64)=0,\"\",(N64/H64))","v":2.2497555128152567E-2}]
[null,"HST",null,null,null,0.13,null,{"$f":"H64*F65","v":14.23534736},null,0.13,null,{"$f":"L64*J65","v":14.555607872000001},null,0.32026051200000083,2.2497555128152547E-2]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H64+H65","v":123.73801936000001},null,null,null,{"$f":"L64+L65","v":126.52182227200001},null,2.7838029119999987,2.2497555128152477E-2]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H66*10%,2)","v":-12.37},null,null,null,{"$f":"ROUND(-L66*10%,2)","v":-12.65},null,-0.28000000000000114,2.2635408245755953E-2]
[null,"Total Bill on TOU (including OCEB)",null,null,null,null,null,{"$f":"H66+H67","v":111.36801936000001},null,null,null,{"$f":"L66+L67","v":113.871822272},null,2.5038029119999976,2.248224334408238E-2]
[]
[]
[null,"Loss Factor (%)",null,null,null,4.2000000000000003E-2,null,null,null,3.49E-2]
[]
["1 Applicable to eligible customers only.  Refer to the Ontario Clean Energy Benefit Act, 2010."]
[]
["Note that the \"Charge $\" columns provide breakdowns of the amounts that each bill component contributes to the total monthly bill at the referenced "]
["consumption level at existing and proposed rates."]
[]
["Applicants must provide bill impacts for residential at 800 kWh and GS<50kW at 2000 kWh. In addition, their filing should cover the range that is relevant"]
["to their service territory, class by class. A general guideline of consumption levels follows:"]
[]
["Residential (kWh) - 100, 250, 500, 800, 1000, 1500, 2000"]
["GS<50kW (kWh) - 1000, 2000, 5000, 10000, 15000"]
["GS>50kW (kW) - 60, 100, 500, 1000"]
["Large User - range appropriate for utility"]
["Lighting Classes and USL - 150 kWh and 1 kW, range appropriate for utility."]

{"sheet":"App.2-W_Bill Impacts- GS<50","index":1,"n_rows":85,"n_cols":20,"rows_kept":85,"cut":false,"hidden":false,"merged":[[2,0,2,10],[9,1,9,14],[10,1,10,14],[13,3,13,14],[17,5,17,7],[17,9,17,11],[17,13,17,14],[67,1,67,3],[18,3,19,3],[18,13,19,13],[18,14,19,14],[60,1,60,3],[61,1,61,3],[66,1,66,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"File Number:","EB-2012-0109",null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Exhibit:",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tab:",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule:",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page:",53]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:","July 17 2013"]
[]
[]
[null,"Appendix 2-W"]
[null,"Bill Impacts"]
[]
[]
[null,"Customer Class:",null,"GS<50"]
[]
[null,null,null,"Consumption",null,2000," kWh"]
[]
[null,null,null,null,null,"Current Board-Approved",null,null,null,"Proposed",null,null,null,"Impact"]
[null,null,null,"Charge Unit",null,"Rate","Volume","Charge",null,"Rate","Volume","Charge",null,"$ Change","% Change"]
[null,null,null,null,null,"($)",null,"($)",null,"($)",null,"($)"]
[null,"Monthly Service Charge",null,null,null,24.81,1,{"$f":"G21*F21","v":24.81},null,25.66,1,{"$f":"K21*J21","v":25.66},null,{"$f":"L21-H21","v":0.85000000000000142},{"$f":"IF((H21)=0,\"\",(N21/H21))","v":3.4260378879484139E-2}]
[null,"Smart Meter Rate Adder",null,null,null,null,1,{"$f":"G22*F22","v":0},null,null,1,{"$f":"K22*J22","v":0},null,{"$f":"L22-H22","v":0},{"$f":"IF((H22)=0,\"\",(N22/H22))","v":""}]
[null,"Smart Meter Disposition Rate Rider ",null,null,null,null,1,0,null,2.9,1,{"$f":"K23*J23","v":2.9},null,{"$f":"L23-H23","v":2.9},{"$f":"IF((H23)=0,\"\",(N23/H23))","v":""}]
[null,"Smart Metering Entity Charge",null,null,null,null,1,0,null,0.78800000000000003,1,0.78800000000000003,null,0.78800000000000003,""]
[null,"Stranded Meter Recovery Rate Rider",null,null,null,null,1,0,null,4.41,1,4.41,null,4.41,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,"Distribution Volumetric Rate",null,null,null,6.4999999999999997E-3,{"$f":"$F$16","v":2000},13,null,{"$f":"'[2]Distribution Rate Schedule'!$E$10","v":6.7000000000000002E-3},{"$f":"$F$16","v":2000},13.4,null,0.40000000000000036,3.0769230769230795E-2]
[null,"Smart Meter Disposition Rider",null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,"LRAM & SSM Rate Rider",null,null,null,4.0000000000000002E-4,{"$f":"$F$16","v":2000},0.8,null,2.9999999999999997E-4,{"$f":"$F$16","v":2000},0.6,null,-0.20000000000000007,-0.25000000000000006]
[null,"Tax change",null,null,null,-2.0000000000000001E-4,{"$f":"$F$16","v":2000},-0.4,null,null,2000,0,null,0.4,-1]
[null,null,null,null,null,null,2000,0,null,null,2000,0,null,0,""]
[null,null,null,null,null,null,2000,0,null,null,2000,0,null,0,""]
[null,null,null,null,null,null,2000,0,null,null,2000,0,null,0,""]
[null,null,null,null,null,null,2000,0,null,null,2000,0,null,0,""]
[null,null,null,null,null,null,2000,0,null,null,2000,0,null,0,""]
[null,null,null,null,null,null,2000,0,null,null,2000,0,null,0,""]
[null,"Sub-Total A",null,null,null,null,null,{"$f":"SUM(H21:H36)","v":38.21},null,null,null,{"$f":"SUM(L21:L36)","v":47.757999999999996},null,9.5479999999999947,0.24988222978277924]
[null,"Deferral/Variance Account Disposition Rate Rider",null,null,null,-5.1999999999999998E-3,{"$f":"$F$16","v":2000},{"$f":"G38*F38","v":-10.4},null,-5.0000000000000001E-3,{"$f":"$F$16","v":2000},{"$f":"K38*J38","v":-10},null,{"$f":"L38-H38","v":0.40000000000000036},{"$f":"IF((H38)=0,\"\",(N38/H38))","v":-3.8461538461538491E-2}]
[null,"Global Adjustment - Non RPP",null,null,null,null,{"$f":"$F$16","v":2000},{"$f":"G39*F39","v":0},null,null,{"$f":"$F$16","v":2000},{"$f":"K39*J39","v":0},null,{"$f":"L39-H39","v":0},{"$f":"IF((H39)=0,\"\",(N39/H39))","v":""}]
[null,null,null,null,null,null,2000,0,null,null,2000,0,null,0,""]
[null,null,null,null,null,null,2000,0,null,null,2000,0,null,0,""]
[null,"Low Voltage Service Charge",null,null,null,null,2000,{"$f":"G42*F42","v":0},null,null,2000,{"$f":"K42*J42","v":0},null,{"$f":"L42-H42","v":0},{"$f":"IF((H42)=0,\"\",(N42/H42))","v":""}]
[null,"Smart Meter Entity Charge",null,null,null,null,null,null,null,null,2000,{"$f":"K43*J43","v":0},null,{"$f":"L43-H43","v":0}]
[null,"Sub-Total B - Distribution (includes Sub-Total A)",null,null,null,null,null,{"$f":"SUM(H38:H42)+H37","v":27.810000000000002},null,null,null,{"$f":"SUM(L38:L42)+L37","v":37.757999999999996},null,{"$f":"L44-H44","v":9.9479999999999933},{"$f":"IF((H44)=0,\"\",(N44/H44))","v":0.35771305285868366}]
[null,"RTSR - Network",null,null,null,7.1999999999999998E-3,{"$f":"F16*(1+F71)","v":2084},{"$f":"G45*F45","v":15.004799999999999},null,6.7000000000000002E-3,{"$f":"F16*(1+J71)","v":2069.7999999999997},{"$f":"K45*J45","v":13.867659999999999},null,-1.1371400000000005,-7.5785082107059115E-2]
[null,"RTSR - Line and Transformation Connection",null,null,null,4.7999999999999996E-3,{"$f":"G45","v":2084},{"$f":"G46*F46","v":10.0032},null,4.5999999999999999E-3,{"$f":"K45","v":2069.7999999999997},{"$f":"K46*J46","v":9.5210799999999978},null,-0.48212000000000188,-4.8196577095329686E-2]
[null,"Sub-Total C - Delivery (including Sub-Total B)",null,null,null,null,null,{"$f":"SUM(H44:H46)","v":52.818000000000005},null,null,null,{"$f":"SUM(L44:L46)","v":61.146739999999994},null,8.3287399999999892,0.15768753076602651]
[null,"Wholesale Market Service Charge (WMSC)",null,null,null,4.4000000000000003E-3,{"$f":"G46","v":2084},{"$f":"G48*F48","v":9.1696000000000009},null,4.4000000000000003E-3,{"$f":"K46","v":2069.7999999999997},{"$f":"K48*J48","v":9.1071200000000001},null,-6.2480000000000757E-2,-6.8138195777352065E-3]
[null,"Rural and Remote Rate Protection (RRRP)",null,null,null,1.1999999999999999E-3,{"$f":"G46","v":2084},2.5007999999999999,null,1.1999999999999999E-3,{"$f":"K46","v":2069.7999999999997},2.4837599999999993,null,-1.704000000000061E-2,-6.8138195777353687E-3]
[null,"Standard Supply Service Charge",null,null,null,0.25,1,0.25,null,0.25,1,0.25,null,0,0]
[null,"Debt Retirement Charge (DRC)",null,null,null,7.0000000000000001E-3,{"$f":"G49","v":2084},14.588000000000001,null,7.0000000000000001E-3,{"$f":"K49","v":2069.7999999999997},14.488599999999998,null,-9.9400000000002819E-2,{"$f":"IF((H51)=0,\"\",(N51/H51))","v":-6.8138195777353175E-3}]
[null,"Energy - RPP - Tier 1",null,null,null,7.8E-2,{"$f":"IF($T$1=1,IF($F$16>=600,600,IF($F$16<600,$F$16*(1+$F$71),$F$16-600)),IF($T$1=2,IF($F$16>=1000,1000,IF($F$16<1000,$F$16*(1+$F$71),$F$16-1000))))","v":1000},{"$f":"G52*F52","v":78},null,7.8E-2,{"$f":"IF($T$1=1,IF($F$16>=600,600,IF($F$16<600,$F$16*(1+$J$71),$F$16-600)),IF($T$1=2,IF($F$16>=1000,1000,IF($F$16<1000,$F$16*(1+$J$71),$F$16-1000))))","v":1000},{"$f":"K52*J52","v":78},null,0,0]
[null,"Energy - RPP - Tier 2",null,null,null,9.0999999999999998E-2,{"$f":"IF($T$1=1,IF($F$16>=600,$F$16*(1+$F$71)-600,IF($F$16<600,0,)), IF($T$1=2,IF($F$16>=1000,$F$16*(1+$F$71)-1000,IF($F$16<1000,0))))","v":1084},{"$f":"G53*F53","v":98.643999999999991},null,9.0999999999999998E-2,{"$f":"IF($T$1=1,IF($F$16>=600,$F$16*(1+$J$71)-600,IF($F$16<600,0,)), IF($T$1=2,IF($F$16>=1000,$F$16*(1+$J$71)-1000,IF($F$16<1000,0))))","v":1069.7999999999997},{"$f":"K53*J53","v":97.351799999999969},null,-1.2922000000000224,-1.3099630996310192E-2]
[null,"TOU - Off Peak",null,null,null,6.7000000000000004E-2,{"$f":"0.64*$F$16*(1+$F$71)","v":1333.76},89.361919999999998,null,6.7000000000000004E-2,{"$f":"0.64*$F$16*(1+$J$71)","v":1324.672},88.753024000000011,null,-0.60889599999998723,-6.8138195777349819E-3]
[null,"TOU - Mid Peak",null,null,null,0.104,{"$f":"0.18*$F$16*(1+$F$71)","v":375.12},39.012479999999996,null,0.104,{"$f":"0.18*$F$16*(1+$J$71)","v":372.56399999999996},38.746655999999994,null,-0.26582400000000206,-6.8138195777351779E-3]
[null,"TOU - On Peak",null,null,null,0.124,{"$f":"0.18*$F$16*(1+$F$71)","v":375.12},46.514879999999998,null,0.124,{"$f":"0.18*$F$16*(1+$J$71)","v":372.56399999999996},46.197935999999999,null,-0.31694399999999945,-6.8138195777351128E-3]
[]
[null,"Total Bill on RPP (before Taxes)",null,null,null,null,null,{"$f":"SUM(H47:H53)","v":255.97039999999998},null,null,null,{"$f":"SUM(L47:L53)","v":262.82801999999992},null,6.8576199999999403,2.6790675796888784E-2]
[null,"HST",null,null,null,0.13,null,{"$f":"H58*F59","v":33.276151999999996},null,0.13,null,{"$f":"L58*J59","v":34.167642599999994},null,0.89149059999999736,2.679067579688894E-2]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H58+H59","v":289.24655199999995},null,null,null,{"$f":"L58+L59","v":296.99566259999995},null,7.7491105999999945,2.6790675796888999E-2]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H60*10%,2)","v":-28.92},null,null,null,{"$f":"ROUND(-L60*10%,2)","v":-29.7},null,-0.77999999999999758,2.6970954356846388E-2]
[null,"Total Bill on RPP (including OCEB)",null,null,null,null,null,{"$f":"SUM(H60:H61)","v":260.32655199999994},null,null,null,{"$f":"SUM(L60:L61)","v":267.29566259999996},null,6.9691106000000218,2.6770648427748636E-2]
[]
[null,"Total Bill on TOU (before Taxes)",null,null,null,null,null,{"$f":"SUM(H47:H51,H54:H56)","v":254.21568000000002},null,null,null,{"$f":"SUM(L47:L51,L54:L56)","v":261.17383599999999},null,{"$f":"L64-H64","v":6.958155999999974},{"$f":"IF((H64)=0,\"\",(N64/H64))","v":2.7371073255591367E-2}]
[null,"HST",null,null,null,0.13,null,{"$f":"H64*F65","v":33.048038400000003},null,0.13,null,{"$f":"L64*J65","v":33.952598680000001},null,0.90456027999999833,2.7371073255591419E-2]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H64+H65","v":287.26371840000002},null,null,null,{"$f":"L64+L65","v":295.12643467999999},null,7.8627162799999724,2.7371073255591374E-2]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H66*10%,2)","v":-28.73},null,null,null,{"$f":"ROUND(-L66*10%,2)","v":-29.51},null,-0.78000000000000114,2.7149321266968365E-2]
[null,"Total Bill on TOU (including OCEB)",null,null,null,null,null,{"$f":"H66+H67","v":258.5337184},null,null,null,{"$f":"L66+L67","v":265.61643468},null,7.0827162799999996,2.7395715823193761E-2]
[]
[]
[null,"Loss Factor (%)",null,null,null,4.2000000000000003E-2,null,null,null,3.49E-2]
[]
["1 Applicable to eligible customers only.  Refer to the Ontario Clean Energy Benefit Act, 2010."]
[]
["Note that the \"Charge $\" columns provide breakdowns of the amounts that each bill component contributes to the total monthly bill at the referenced "]
["consumption level at existing and proposed rates."]
[]
["Applicants must provide bill impacts for residential at 800 kWh and GS<50kW at 2000 kWh. In addition, their filing should cover the range that is relevant"]
["to their service territory, class by class. A general guideline of consumption levels follows:"]
[]
["Residential (kWh) - 100, 250, 500, 800, 1000, 1500, 2000"]
["GS<50kW (kWh) - 1000, 2000, 5000, 10000, 15000"]
["GS>50kW (kW) - 60, 100, 500, 1000"]
["Large User - range appropriate for utility"]
["Lighting Classes and USL - 150 kWh and 1 kW, range appropriate for utility."]

{"sheet":"App.2-W_Bill Impacts - GS>50","index":2,"n_rows":84,"n_cols":20,"rows_kept":84,"cut":false,"hidden":false,"merged":[[2,0,2,10],[59,1,59,3],[65,1,65,3],[60,1,60,3],[66,1,66,3],[9,1,9,14],[10,1,10,14],[13,3,13,14],[18,5,18,7],[18,9,18,11],[18,13,18,14],[19,3,20,3],[19,13,20,13],[19,14,20,14]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"File Number:",{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Exhibit:",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tab:",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule:",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page:",54]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:","July 17,2013"]
[]
[]
[null,"Appendix 2-W"]
[null,"Bill Impacts"]
[]
[]
[null,"Customer Class:",null,"GS>50"]
[]
[null,null,null,"Consumption",null,100,"kW"]
[null,null,null,"Consumption ",null,{"$f":"ROUND(F16*1/0.002542,0)","v":39339},"kWh"]
[]
[null,null,null,null,null,"Current Board-Approved",null,null,null,"Proposed",null,null,null,"Impact"]
[null,null,null,"Charge Unit",null,"Rate","Volume","Charge",null,"Rate","Volume","Charge",null,"$ Change","% Change"]
[null,null,null,null,null,"($)",null,"($)",null,"($)",null,"($)"]
[null,"Monthly Service Charge",null,"Monthly",null,293.70999999999998,1,{"$f":"G22*F22","v":293.70999999999998},null,{"$f":"'[2]Distribution Rate Schedule'!$C$12","v":225},{"$f":"G22","v":1},{"$f":"K22*J22","v":225},null,{"$f":"L22-H22","v":-68.70999999999998},{"$f":"IF((H22)=0,\"\",(N22/H22))","v":-0.23393823839842015}]
[null,"Smart Meter Rate Adder",null,"Monthly",null,null,1,{"$f":"G23*F23","v":0},null,null,{"$f":"G23","v":1},{"$f":"K23*J23","v":0},null,{"$f":"L23-H23","v":0},{"$f":"IF((H23)=0,\"\",(N23/H23))","v":""}]
[null,null,null,null,null,null,1,0,null,null,{"$f":"G24","v":1},{"$f":"K24*J24","v":0},null,{"$f":"L24-H24","v":0},{"$f":"IF((H24)=0,\"\",(N24/H24))","v":""}]
[null,null,null,null,null,null,1,0,null,null,{"$f":"G25","v":1},0,null,0,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,"Distribution Volumetric Rate",null,"per kW",null,2.6042999999999998,{"$f":"F16","v":100},260.43,null,2.9678,100,296.77999999999997,null,36.349999999999966,{"$f":"IF((H28)=0,\"\",(N28/H28))","v":0.1395768536650922}]
[null,"Smart Meter Disposition Rider",null,"Monthly",null,null,1,0,null,null,1,0,null,0,""]
[null,"LRAM & SSM Rate Rider",null,"per kW",null,6.3299999999999995E-2,{"$f":"F16","v":100},6.3299999999999992,null,1.8700000000000001E-2,100,1.87,null,-4.4599999999999991,-0.70458135860979454]
[null,"Tax change",null,"per kW",null,-6.0900000000000003E-2,{"$f":"F16","v":100},-6.09,null,null,100,0,null,6.09,-1]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,"Sub-Total A",null,null,null,null,null,{"$f":"SUM(H22:H37)","v":554.38},null,null,null,{"$f":"SUM(L22:L37)","v":523.65},null,-30.730000000000018,-5.5431292615173738E-2]
[null,"Deferral/Variance Account Disposition Rate Rider",null,"per kW",null,-1.8203,{"$f":"F16","v":100},{"$f":"G39*F39","v":-182.03},null,-1.9701,{"$f":"G39","v":100},{"$f":"K39*J39","v":-197.01},null,{"$f":"L39-H39","v":-14.97999999999999},{"$f":"IF((H39)=0,\"\",(N39/H39))","v":8.2294127341646928E-2}]
[null,"Global Adjustment - Non RPP",null,"per kWh",null,-0.57899999999999996,{"$f":"F16","v":100},{"$f":"G40*F40","v":-57.9},null,0.84709999999999996,{"$f":"G40","v":100},{"$f":"K40*J40","v":84.71},null,{"$f":"L40-H40","v":142.60999999999999},{"$f":"IF((H40)=0,\"\",(N40/H40))","v":-2.4630397236614852}]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,"Low Voltage Service Charge",null,null,null,null,null,{"$f":"G43*F43","v":0},null,null,0,{"$f":"K43*J43","v":0},null,{"$f":"L43-H43","v":0},{"$f":"IF((H43)=0,\"\",(N43/H43))","v":""}]
[null,"Smart Meter Entity Charge",null,null,null,null,null,null,null,null,0,{"$f":"K44*J44","v":0},null,{"$f":"L44-H44","v":0}]
[null,"Sub-Total B - Distribution (includes Sub-Total A)",null,null,null,null,null,{"$f":"SUM(H39:H43)+H38","v":314.45},null,null,null,{"$f":"SUM(L39:L43)+L38","v":411.34999999999997},null,{"$f":"L45-H45","v":96.899999999999977},{"$f":"IF((H45)=0,\"\",(N45/H45))","v":0.30815709969788513}]
[null,"RTSR - Network",null,"per kW",null,2.4601000000000002,{"$f":"F16*(1+F70)","v":104.2},{"$f":"G46*F46","v":256.34242},null,2.3035999999999999,{"$f":"$F$16*(1+$J$70)","v":103.49},{"$f":"K46*J46","v":238.39956399999997},null,-17.942856000000035,-6.9995656590899138E-2]
[null,"RTSR - Line and Transformation Connection",null,"per kW",null,1.6397999999999999,{"$f":"G46","v":104.2},{"$f":"G47*F47","v":170.86715999999998},null,1.5708,{"$f":"$F$16*(1+$J$70)","v":103.49},{"$f":"K47*J47","v":162.56209199999998},null,-8.3050680000000057,-4.8605407850168557E-2]
[null,"Sub-Total C - Delivery (including Sub-Total B)",null,null,null,null,null,{"$f":"SUM(H45:H47)","v":741.65958000000001},null,null,null,{"$f":"SUM(L45:L47)","v":812.31165599999997},null,{"$f":"L48-H48","v":70.652075999999965},9.5262136302479858E-2]
[null,"Wholesale Market Service Charge (WMSC)",null,"per kWh",null,4.4000000000000003E-3,{"$f":"$F$17*(1+$F$70)","v":40991.238000000005},{"$f":"G49*F49","v":180.36144720000004},null,4.4000000000000003E-3,{"$f":"$F$17*(1+$J$70)","v":40711.931099999994},{"$f":"K49*J49","v":179.13249683999999},null,-1.2289503600000558,-6.813819577735432E-3]
[null,"Rural and Remote Rate Protection (RRRP)",null,"per kWh",null,1.1999999999999999E-3,{"$f":"$F$17*(1+$F$70)","v":40991.238000000005},49.189485600000005,null,1.1999999999999999E-3,{"$f":"$F$17*(1+$J$70)","v":40711.931099999994},48.854317319999986,null,-0.33516828000001908,-6.8138195777355118E-3]
[null,"Standard Supply Service Charge",null,"Monthly",null,0.25,1,0.25,null,0.25,{"$f":"G51","v":1},0.25,null,0,0]
[null,"Debt Retirement Charge (DRC)",null,"per kWh",null,7.0000000000000001E-3,{"$f":"$F$17*(1+$F$70)","v":40991.238000000005},286.93866600000001,null,7.0000000000000001E-3,{"$f":"$F$17*(1+$J$70)","v":40711.931099999994},284.98351769999999,null,-1.9551483000000189,{"$f":"IF((H52)=0,\"\",(N52/H52))","v":-6.8138195777351909E-3}]
[null,"Energy - RPP - Tier 1",null,null,null,7.8E-2,0,{"$f":"G53*F53","v":0},null,7.8E-2,0,{"$f":"K53*J53","v":0},null,0,""]
[null,"Energy - RPP - Tier 2",null,null,null,9.0999999999999998E-2,0,{"$f":"G54*F54","v":0},null,9.0999999999999998E-2,0,{"$f":"K54*J54","v":0},null,0,""]
[null,"Energy - COP",null,null,null,8.5449999999999998E-2,{"$f":"$F$17*(1+$F$70)","v":40991.238000000005},{"$f":"G55*F55","v":3502.7012871000002},null,8.5449999999999998E-2,{"$f":"$F$17*(1+$J$70)","v":40711.931099999994},3478.8345124949992,null,-23.866774605000955,-6.8138195777353973E-3]
[]
[null,"Total Bill on RPP (before Taxes)",null,null,null,null,null,{"$f":"SUM(H48:H54)","v":1258.3991788000001},null,null,null,{"$f":"SUM(L48:L54)","v":1325.5319878600001},null,67.13280906,5.334778517895835E-2]
[null,"HST",null,null,null,0.13,null,{"$f":"H57*F58","v":163.591893244},null,0.13,null,{"$f":"L57*J58","v":172.31915842180001},null,8.7272651778000068,5.3347785178958392E-2]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H57+H58","v":1421.991072044},null,null,null,{"$f":"L57+L58","v":1497.8511462818001},null,75.860074237800063,5.3347785178958392E-2]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H59*10%,2)","v":-142.19999999999999},null,null,null,{"$f":"ROUND(-L59*10%,2)","v":-149.79},null,-7.5900000000000034,5.3375527426160363E-2]
[null,"Total Bill on RPP (including OCEB)",null,null,null,null,null,{"$f":"SUM(H59:H60)","v":1279.791072044},null,null,null,{"$f":"SUM(L59:L60)","v":1348.0611462818001},null,68.270074237800145,5.3344702685543491E-2]
[]
[null,"Total Bill",null,null,null,null,null,{"$f":"SUM(H48:H52,H55:H55)","v":4761.1004659},null,null,null,{"$f":"SUM(L48:L52,L55:L55)","v":4804.3665003549995},null,{"$f":"L63-H63","v":43.266034454999499},{"$f":"IF((H63)=0,\"\",(N63/H63))","v":9.087402117405401E-3}]
[null,"HST",null,null,null,0.13,null,{"$f":"H63*F64","v":618.94306056699997},null,0.13,null,{"$f":"L63*J64","v":624.56764504615001},null,5.6245844791500303,9.0874021174055554E-3]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H63+H64","v":5380.0435264669995},null,null,null,{"$f":"L63+L64","v":5428.9341454011492},null,48.890618934149643,9.0874021174054409E-3]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H65*10%,2)","v":-538},null,null,null,{"$f":"ROUND(-L65*10%,2)","v":-542.89},null,-4.8899999999999864,9.0892193308549935E-3]
[null,"Total Bill (including OCEB)",null,null,null,null,null,{"$f":"H65+H66","v":4842.0435264669995},null,null,null,{"$f":"L65+L66","v":4886.0441454011489},null,44.000618934149315,9.0872002066149128E-3]
[]
[]
[null,"Loss Factor (%)",null,null,null,4.2000000000000003E-2,null,null,null,3.49E-2]
[]
["1 Applicable to eligible customers only.  Refer to the Ontario Clean Energy Benefit Act, 2010."]
[]
["Note that the \"Charge $\" columns provide breakdowns of the amounts that each bill component contributes to the total monthly bill at the referenced "]
["consumption level at existing and proposed rates."]
[]
["Applicants must provide bill impacts for residential at 800 kWh and GS<50kW at 2000 kWh. In addition, their filing should cover the range that is relevant"]
["to their service territory, class by class. A general guideline of consumption levels follows:"]
[]
["Residential (kWh) - 100, 250, 500, 800, 1000, 1500, 2000"]
["GS<50kW (kWh) - 1000, 2000, 5000, 10000, 15000"]
["GS>50kW (kW) - 60, 100, 500, 1000"]
["Large User - range appropriate for utility"]
["Lighting Classes and USL - 150 kWh and 1 kW, range appropriate for utility."]

{"sheet":"App.2-W_Bill Impacts - Sentinel","index":3,"n_rows":84,"n_cols":20,"rows_kept":84,"cut":false,"hidden":false,"merged":[[2,0,2,10],[59,1,59,3],[65,1,65,3],[60,1,60,3],[66,1,66,3],[9,1,9,14],[10,1,10,14],[13,3,13,14],[18,5,18,7],[18,9,18,11],[18,13,18,14],[19,3,20,3],[19,13,20,13],[19,14,20,14]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"File Number:",{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Exhibit:",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tab:",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule:",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page:",55]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:","July 17,2013"]
[]
[]
[null,"Appendix 2-W"]
[null,"Bill Impacts"]
[]
[]
[null,"Customer Class:",null,"Sentinel Lights "]
[]
[null,null,null,"Consumption",null,1,"kW"]
[null,null,null,"Consumption ",null,150,"kWh"]
[]
[null,null,null,null,null,"Current Board-Approved",null,null,null,"Proposed",null,null,null,"Impact"]
[null,null,null,"Charge Unit",null,"Rate","Volume","Charge",null,"Rate","Volume","Charge",null,"$ Change","% Change"]
[null,null,null,null,null,"($)",null,"($)",null,"($)",null,"($)"]
[null,"Monthly Service Charge",null,"Monthly",null,2.3199999999999998,1,{"$f":"G22*F22","v":2.3199999999999998},null,3.9272999999999998,{"$f":"G22","v":1},{"$f":"K22*J22","v":3.9272999999999998},null,{"$f":"L22-H22","v":1.6073},{"$f":"IF((H22)=0,\"\",(N22/H22))","v":0.69280172413793106}]
[null,"Smart Meter Rate Adder",null,"Monthly",null,0,1,{"$f":"G23*F23","v":0},null,null,{"$f":"G23","v":1},{"$f":"K23*J23","v":0},null,{"$f":"L23-H23","v":0},{"$f":"IF((H23)=0,\"\",(N23/H23))","v":""}]
[null,"Stranded Meter Recovery ",null,null,null,null,1,0,null,null,{"$f":"G24","v":1},{"$f":"K24*J24","v":0},null,{"$f":"L24-H24","v":0},{"$f":"IF((H24)=0,\"\",(N24/H24))","v":""}]
[null,null,null,null,null,null,1,0,null,null,{"$f":"G25","v":1},0,null,0,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,"Distribution Volumetric Rate",null,"per kW",null,11.1228,{"$f":"F16","v":1},11.1228,null,18.828600000000002,1,18.828600000000002,null,7.7058000000000018,{"$f":"IF((H28)=0,\"\",(N28/H28))","v":0.69279318157298542}]
[null,"Smart Meter Disposition Rider",null,"Monthly",null,null,1,0,null,null,1,0,null,0,""]
[null,"LRAM & SSM Rate Rider",null,"per kW",null,null,{"$f":"F16","v":1},0,null,null,1,0,null,0,""]
[null,"Tax change",null,"per kW",null,-0.39710000000000001,{"$f":"F16","v":1},-0.39710000000000001,null,null,1,0,null,0.39710000000000001,-1]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,"Sub-Total A",null,null,null,null,null,{"$f":"SUM(H22:H37)","v":13.0457},null,null,null,{"$f":"SUM(L22:L37)","v":22.7559},null,9.7102000000000004,0.74432188383911946]
[null,"Deferral/Variance Account Disposition Rate Rider",null,"per kW",null,-4.1578999999999997,{"$f":"F16","v":1},{"$f":"G39*F39","v":-4.1578999999999997},null,-1.6400999999999999,{"$f":"G39","v":1},{"$f":"K39*J39","v":-1.6400999999999999},null,2.5177999999999998,{"$f":"IF((H39)=0,\"\",(N39/H39))","v":-0.60554606892902663}]
[null,"Global Adjustment - Non RPP",null,"per kW",null,-0.441,{"$f":"F16","v":1},{"$f":"G40*F40","v":-0.441},null,0.70520000000000005,1,0.70520000000000005,null,1.1462000000000001,{"$f":"IF((H40)=0,\"\",(N40/H40))","v":-2.599092970521542}]
[null,null,null,null,null,null,null,{"$f":"G41*F41","v":0},null,null,0,0,null,0,{"$f":"IF((H41)=0,\"\",(N41/H41))","v":""}]
[null,null,null,null,null,null,null,{"$f":"G42*F42","v":0},null,null,0,0,null,0,{"$f":"IF((H42)=0,\"\",(N42/H42))","v":""}]
[null,"Low Voltage Service Charge",null,null,null,null,null,{"$f":"G43*F43","v":0},null,null,0,0,null,0,{"$f":"IF((H43)=0,\"\",(N43/H43))","v":""}]
[null,"Smart Meter Entity Charge",null,null,null,null,null,null,null,null,0,0,null,0]
[null,"Sub-Total B - Distribution (includes Sub-Total A)",null,null,null,null,null,{"$f":"SUM(H39:H43)+H38","v":8.4467999999999996},null,null,null,{"$f":"SUM(L39:L43)+L38","v":21.821000000000002},null,13.374200000000002,{"$f":"IF((H45)=0,\"\",(N45/H45))","v":1.583345172136194}]
[null,"RTSR - Network",null,"per kW",null,2.2972999999999999,{"$f":"F16*(1+F70)","v":1.042},{"$f":"G46*F46","v":2.3937865999999999},null,2.1511,{"$f":"$F$16*(1+$J$70)","v":1.0348999999999999},{"$f":"K46*J46","v":2.22617339},null,-0.16761320999999985,-7.0020113739461931E-2]
[null,"RTSR - Line and Transformation Connection",null,"per kW",null,1.5315000000000001,{"$f":"G46","v":1.042},{"$f":"G47*F47","v":1.5958230000000002},null,1.4671000000000001,{"$f":"$F$16*(1+$J$70)","v":1.0348999999999999},{"$f":"K47*J47","v":1.51830179},null,-7.7521210000000229E-2,-4.8577574079330992E-2]
[null,"Sub-Total C - Delivery (including Sub-Total B)",null,null,null,null,null,{"$f":"SUM(H45:H47)","v":12.436409600000001},null,null,null,{"$f":"SUM(L45:L47)","v":25.56547518},null,13.129065579999999,1.055695815937101]
[null,"Wholesale Market Service Charge (WMSC)",null,"per kWh",null,4.4000000000000003E-3,{"$f":"$F$17*(1+$F$70)","v":156.30000000000001},{"$f":"G49*F49","v":0.68772000000000011},null,4.4000000000000003E-3,{"$f":"$F$17*(1+$J$70)","v":155.23499999999999},{"$f":"K49*J49","v":0.68303400000000003},null,-4.686000000000079E-3,-6.8138195777352386E-3]
[null,"Rural and Remote Rate Protection (RRRP)",null,"per kWh",null,1.1999999999999999E-3,{"$f":"$F$17*(1+$F$70)","v":156.30000000000001},0.18756,null,1.1999999999999999E-3,{"$f":"$F$17*(1+$J$70)","v":155.23499999999999},0.18628199999999998,null,-1.2780000000000291E-3,-6.8138195777352802E-3]
[null,"Standard Supply Service Charge",null,"Monthly",null,0.25,1,0.25,null,0.25,{"$f":"G51","v":1},0.25,null,0,0]
[null,"Debt Retirement Charge (DRC)",null,"per kWh",null,7.0000000000000001E-3,{"$f":"$F$17*(1+$F$70)","v":156.30000000000001},1.0941000000000001,null,7.0000000000000001E-3,{"$f":"$F$17*(1+$J$70)","v":155.23499999999999},1.0866449999999999,null,-7.4550000000002115E-3,{"$f":"IF((H52)=0,\"\",(N52/H52))","v":-6.8138195777353175E-3}]
[null,"Energy - RPP - Tier 1",null,null,null,7.8E-2,0,{"$f":"G53*F53","v":0},null,7.8E-2,{"$f":"G53","v":0},{"$f":"K53*J53","v":0},null,0,""]
[null,"Energy - RPP - Tier 2",null,null,null,9.0999999999999998E-2,0,{"$f":"G54*F54","v":0},null,9.0999999999999998E-2,{"$f":"G54","v":0},{"$f":"K54*J54","v":0},null,0,""]
[null,"Energy - COP",null,null,null,8.5449999999999998E-2,{"$f":"$F$17*(1+$F$70)","v":156.30000000000001},13.355835000000001,null,8.5449999999999998E-2,{"$f":"$F$17*(1+$J$70)","v":155.23499999999999},13.264830749999998,null,-9.1004250000002784E-2,-6.8138195777353331E-3]
[]
[null,"Total Bill on RPP (before Taxes)",null,null,null,null,null,{"$f":"SUM(H48:H54)","v":14.655789600000002},null,null,null,{"$f":"SUM(L48:L54)","v":27.771436179999998},null,13.115646579999996,0.89491231369751612]
[null,"HST",null,null,null,0.13,null,{"$f":"H57*F58","v":1.9052526480000003},null,0.13,null,{"$f":"L57*J58","v":3.6102867033999999},null,1.7050340553999996,0.89491231369751623]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H57+H58","v":16.561042248000003},null,null,null,{"$f":"L57+L58","v":31.381722883399998},null,14.820680635399995,0.894912313697516]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H59*10%,2)","v":-1.66},null,null,null,{"$f":"ROUND(-L59*10%,2)","v":-3.14},null,-1.4800000000000002,0.89156626506024117]
[null,"Total Bill on RPP (including OCEB)",null,null,null,null,null,{"$f":"SUM(H59:H60)","v":14.901042248000003},null,null,null,{"$f":"SUM(L59:L60)","v":28.241722883399998},null,13.340680635399995,0.89528506888104165]
[]
[null,"Total Bill Impact",null,null,null,null,null,{"$f":"SUM(H48:H52,H55:H55)","v":28.011624600000005},null,null,null,{"$f":"SUM(L48:L52,L55:L55)","v":41.036266929999996},null,{"$f":"L63-H63","v":13.024642329999992},{"$f":"IF((H63)=0,\"\",(N63/H63))","v":0.46497275741728988}]
[null,"HST",null,null,null,0.13,null,{"$f":"H63*F64","v":3.6415111980000008},null,0.13,null,{"$f":"L63*J64","v":5.3347147008999993},null,1.6932035028999985,0.46497275741728977]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H63+H64","v":31.653135798000005},null,null,null,{"$f":"L63+L64","v":46.370981630899998},null,14.717845832899993,0.46497275741728994]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H65*10%,2)","v":-3.17},null,null,null,{"$f":"ROUND(-L65*10%,2)","v":-4.6399999999999997},null,-1.4699999999999998,0.46372239747634064]
[null,"Total Bill (including OCEB)",null,null,null,null,null,{"$f":"H65+H66","v":28.483135798000006},null,null,null,{"$f":"L65+L66","v":41.730981630899997},null,13.247845832899991,0.46511191488369097]
[]
[]
[null,"Loss Factor (%)",null,null,null,4.2000000000000003E-2,null,null,null,3.49E-2]
[]
["1 Applicable to eligible customers only.  Refer to the Ontario Clean Energy Benefit Act, 2010."]
[]
["Note that the \"Charge $\" columns provide breakdowns of the amounts that each bill component contributes to the total monthly bill at the referenced "]
["consumption level at existing and proposed rates."]
[]
["Applicants must provide bill impacts for residential at 800 kWh and GS<50kW at 2000 kWh. In addition, their filing should cover the range that is relevant"]
["to their service territory, class by class. A general guideline of consumption levels follows:"]
[]
["Residential (kWh) - 100, 250, 500, 800, 1000, 1500, 2000"]
["GS<50kW (kWh) - 1000, 2000, 5000, 10000, 15000"]
["GS>50kW (kW) - 60, 100, 500, 1000"]
["Large User - range appropriate for utility"]
["Lighting Classes and USL - 150 kWh and 1 kW, range appropriate for utility."]

{"sheet":"App.2-W_Bill Impacts - Street","index":4,"n_rows":84,"n_cols":20,"rows_kept":84,"cut":false,"hidden":false,"merged":[[2,0,2,10],[59,1,59,3],[65,1,65,3],[60,1,60,3],[66,1,66,3],[9,1,9,14],[10,1,10,14],[13,3,13,14],[18,5,18,7],[18,9,18,11],[18,13,18,14],[19,3,20,3],[19,13,20,13],[19,14,20,14]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"File Number:",{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Exhibit:",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tab:",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule:",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page:",56]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:","July 17,2013"]
[]
[]
[null,"Appendix 2-W"]
[null,"Bill Impacts"]
[]
[]
[null,"Customer Class:",null,"Street lights "]
[]
[null,null,null,"Consumption",null,1,"kW"]
[null,null,null,"Consumption ",null,{"$f":"ROUND(F16*1/0.003106,0)","v":322},"kWh"]
[]
[null,null,null,null,null,"Current Board-Approved",null,null,null,"Proposed",null,null,null,"Impact"]
[null,null,null,"Charge Unit",null,"Rate","Volume","Charge",null,"Rate","Volume","Charge",null,"$ Change","% Change"]
[null,null,null,null,null,"($)",null,"($)",null,"($)",null,"($)"]
[null,"Monthly Service Charge",null,"Monthly",null,0.65,1,{"$f":"G22*F22","v":0.65},null,{"$f":"'[2]Distribution Rate Schedule'!$B$15","v":0.67169999999999996},{"$f":"G22","v":1},{"$f":"K22*J22","v":0.67169999999999996},null,{"$f":"L22-H22","v":2.1699999999999942E-2},{"$f":"IF((H22)=0,\"\",(N22/H22))","v":3.338461538461529E-2}]
[null,"Smart Meter Rate Adder",null,"Monthly",null,null,1,{"$f":"G23*F23","v":0},null,null,{"$f":"G23","v":1},{"$f":"K23*J23","v":0},null,{"$f":"L23-H23","v":0},{"$f":"IF((H23)=0,\"\",(N23/H23))","v":""}]
[null,"Stranded Meter Recovery ",null,null,null,null,1,0,null,null,{"$f":"G24","v":1},{"$f":"K24*J24","v":0},null,{"$f":"L24-H24","v":0},{"$f":"IF((H24)=0,\"\",(N24/H24))","v":""}]
[null,null,null,null,null,null,1,0,null,null,{"$f":"G25","v":1},0,null,0,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,"Distribution Volumetric Rate",null,"per kW",null,2.7126999999999999,{"$f":"F16","v":1},2.7126999999999999,null,2.8001999999999998,1,2.8001999999999998,null,8.7499999999999911E-2,{"$f":"IF((H28)=0,\"\",(N28/H28))","v":3.2255686216684454E-2}]
[null,"Smart Meter Disposition Rider",null,"Monthly",null,null,1,0,null,null,1,0,null,0,""]
[null,"LRAM & SSM Rate Rider",null,"per kW",null,null,{"$f":"F16","v":1},0,null,null,1,0,null,0,""]
[null,"Tax change",null,"per kW",null,-9.8400000000000001E-2,{"$f":"F16","v":1},-9.8400000000000001E-2,null,null,1,0,null,9.8400000000000001E-2,-1]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,"Sub-Total A",null,null,null,null,null,{"$f":"SUM(H22:H37)","v":3.2643},null,null,null,{"$f":"SUM(L22:L37)","v":3.4718999999999998},null,0.20759999999999978,6.359709585516031E-2]
[null,"Deferral/Variance Account Disposition Rate Rider",null,"per kW",null,-1.8738999999999999,{"$f":"F16","v":1},{"$f":"G39*F39","v":-1.8738999999999999},null,-1.615,{"$f":"G39","v":1},{"$f":"K39*J39","v":-1.615},null,0.25889999999999991,{"$f":"IF((H39)=0,\"\",(N39/H39))","v":-0.138161054485298}]
[null,"Global Adjustment - Non RPP",null,"per kW",null,-0.48099999999999998,{"$f":"F16","v":1},{"$f":"G40*F40","v":-0.48099999999999998},null,0.69440000000000002,1,0.69440000000000002,null,1.1754,{"$f":"IF((H40)=0,\"\",(N40/H40))","v":-2.4436590436590437}]
[null,null,null,null,null,null,null,{"$f":"G41*F41","v":0},null,null,0,0,null,0,{"$f":"IF((H41)=0,\"\",(N41/H41))","v":""}]
[null,null,null,null,null,null,null,{"$f":"G42*F42","v":0},null,null,0,0,null,0,{"$f":"IF((H42)=0,\"\",(N42/H42))","v":""}]
[null,"Low Voltage Service Charge",null,null,null,null,null,{"$f":"G43*F43","v":0},null,null,0,0,null,0,{"$f":"IF((H43)=0,\"\",(N43/H43))","v":""}]
[null,"Smart Meter Entity Charge",null,null,null,null,null,null,null,null,0,0,null,0]
[null,"Sub-Total B - Distribution (includes Sub-Total A)",null,null,null,null,null,{"$f":"SUM(H39:H43)+H38","v":0.90940000000000021},null,null,null,{"$f":"SUM(L39:L43)+L38","v":2.5512999999999999},null,1.6418999999999997,{"$f":"IF((H45)=0,\"\",(N45/H45))","v":1.8054761381130409}]
[null,"RTSR - Network",null,"per kW",null,2.2707999999999999,{"$f":"F16*(1+F70)","v":1.042},{"$f":"G46*F46","v":2.3661736000000002},null,2.1263000000000001,{"$f":"$F$16*(1+$J$70)","v":1.0348999999999999},{"$f":"K46*J46","v":2.20050787},null,-0.16566573000000018,-7.0014190843816437E-2]
[null,"RTSR - Line and Transformation Connection",null,"per kW",null,1.5138,{"$f":"G46","v":1.042},{"$f":"G47*F47","v":1.5773796},null,1.4500999999999999,{"$f":"$F$16*(1+$J$70)","v":1.0348999999999999},{"$f":"K47*J47","v":1.5007084899999998},null,-7.6671110000000153E-2,-4.8606632163874917E-2]
[null,"Sub-Total C - Delivery (including Sub-Total B)",null,null,null,null,null,{"$f":"SUM(H45:H47)","v":4.8529532},null,null,null,{"$f":"SUM(L45:L47)","v":6.2525163600000004},null,1.3995631600000005,0.28839411845142054]
[null,"Wholesale Market Service Charge (WMSC)",null,"per kWh",null,4.4000000000000003E-3,{"$f":"$F$17*(1+$F$70)","v":335.524},{"$f":"G49*F49","v":1.4763056000000001},null,4.4000000000000003E-3,{"$f":"$F$17*(1+$J$70)","v":333.23779999999999},{"$f":"K49*J49","v":1.46624632},null,-1.0059280000000115E-2,-6.8138195777352022E-3]
[null,"Rural and Remote Rate Protection (RRRP)",null,"per kWh",null,1.1999999999999999E-3,{"$f":"$F$17*(1+$F$70)","v":335.524},0.40262879999999995,null,1.1999999999999999E-3,{"$f":"$F$17*(1+$J$70)","v":333.23779999999999},0.39988535999999997,null,-2.7434399999999859E-3,-6.8138195777350903E-3]
[null,"Standard Supply Service Charge",null,"Monthly",null,0.25,1,0.25,null,0.25,{"$f":"G51","v":1},0.25,null,0,0]
[null,"Debt Retirement Charge (DRC)",null,"per kWh",null,7.0000000000000001E-3,{"$f":"$F$17*(1+$F$70)","v":335.524},2.348668,null,7.0000000000000001E-3,{"$f":"$F$17*(1+$J$70)","v":333.23779999999999},2.3326646000000002,null,-1.6003399999999779E-2,{"$f":"IF((H52)=0,\"\",(N52/H52))","v":-6.8138195777350304E-3}]
[null,"Energy - RPP - Tier 1",null,null,null,7.8E-2,0,{"$f":"G53*F53","v":0},null,7.8E-2,{"$f":"G53","v":0},{"$f":"K53*J53","v":0},null,0,""]
[null,"Energy - RPP - Tier 2",null,null,null,9.0999999999999998E-2,0,{"$f":"G54*F54","v":0},null,9.0999999999999998E-2,{"$f":"G54","v":0},{"$f":"K54*J54","v":0},null,0,""]
[null,"Energy - COP",null,null,null,8.5449999999999998E-2,{"$f":"$F$17*(1+$F$70)","v":335.524},28.6705258,null,8.5449999999999998E-2,{"$f":"$F$17*(1+$J$70)","v":333.23779999999999},28.475170009999999,null,-0.1953557900000007,-6.8138195777351493E-3]
[]
[null,"Total Bill on RPP (before Taxes)",null,null,null,null,null,{"$f":"SUM(H48:H54)","v":9.3305556000000003},null,null,null,{"$f":"SUM(L48:L54)","v":10.701312640000001},null,1.3707570400000009,0.14691054839220943]
[null,"HST",null,null,null,0.13,null,{"$f":"H57*F58","v":1.2129722280000002},null,0.13,null,{"$f":"L57*J58","v":1.3911706432000002},null,0.17819841520000002,0.14691054839220935]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H57+H58","v":10.543527828},null,null,null,{"$f":"L57+L58","v":12.092483283200002},null,1.5489554552000016,0.14691054839220949]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H59*10%,2)","v":-1.05},null,null,null,{"$f":"ROUND(-L59*10%,2)","v":-1.21},null,-0.15999999999999992,0.15238095238095231]
[null,"Total Bill on RPP (including OCEB)",null,null,null,null,null,{"$f":"SUM(H59:H60)","v":9.4935278279999995},null,null,null,{"$f":"SUM(L59:L60)","v":10.882483283200003},null,1.3889554552000032,0.14630551259390095]
[]
[null,"Total Bill",null,null,null,null,null,{"$f":"SUM(H48:H52,H55:H55)","v":38.001081400000004},null,null,null,{"$f":"SUM(L48:L52,L55:L55)","v":39.176482649999997},null,{"$f":"L63-H63","v":1.1754012499999931},{"$f":"IF((H63)=0,\"\",(N63/H63))","v":3.0930731618600542E-2}]
[null,"HST",null,null,null,0.13,null,{"$f":"H63*F64","v":4.9401405820000006},null,0.13,null,{"$f":"L63*J64","v":5.0929427445000002},null,0.15280216249999956,3.0930731618600635E-2]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H63+H64","v":42.941221982000002},null,null,null,{"$f":"L63+L64","v":44.269425394499997},null,1.3282034124999953,3.0930731618600618E-2]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H65*10%,2)","v":-4.29},null,null,null,{"$f":"ROUND(-L65*10%,2)","v":-4.43},null,-0.13999999999999968,3.2634032634032556E-2]
[null,"Total Bill (including OCEB)",null,null,null,null,null,{"$f":"H65+H66","v":38.651221982000003},null,null,null,{"$f":"L65+L66","v":39.839425394499997},null,1.1882034124999947,3.0741677793611411E-2]
[]
[]
[null,"Loss Factor (%)",null,null,null,4.2000000000000003E-2,null,null,null,3.49E-2]
[]
["1 Applicable to eligible customers only.  Refer to the Ontario Clean Energy Benefit Act, 2010."]
[]
["Note that the \"Charge $\" columns provide breakdowns of the amounts that each bill component contributes to the total monthly bill at the referenced "]
["consumption level at existing and proposed rates."]
[]
["Applicants must provide bill impacts for residential at 800 kWh and GS<50kW at 2000 kWh. In addition, their filing should cover the range that is relevant"]
["to their service territory, class by class. A general guideline of consumption levels follows:"]
[]
["Residential (kWh) - 100, 250, 500, 800, 1000, 1500, 2000"]
["GS<50kW (kWh) - 1000, 2000, 5000, 10000, 15000"]
["GS>50kW (kW) - 60, 100, 500, 1000"]
["Large User - range appropriate for utility"]
["Lighting Classes and USL - 150 kWh and 1 kW, range appropriate for utility."]

{"sheet":"App.2-W_Bill Impacts - USL","index":5,"n_rows":84,"n_cols":20,"rows_kept":84,"cut":false,"hidden":false,"merged":[[2,0,2,10],[59,1,59,3],[65,1,65,3],[60,1,60,3],[66,1,66,3],[9,1,9,14],[10,1,10,14],[13,3,13,14],[18,5,18,7],[18,9,18,11],[18,13,18,14],[19,3,20,3],[19,13,20,13],[19,14,20,14]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"File Number:",{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Exhibit:",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tab:",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule:",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page:",57]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:","July 17,2013"]
[]
[]
[null,"Appendix 2-W"]
[null,"Bill Impacts"]
[]
[]
[null,"Customer Class:",null,"USL"]
[]
[null,null,null,"Consumption",null,0,"kW"]
[null,null,null,"Consumption ",null,150,"kWh"]
[]
[null,null,null,null,null,"Current Board-Approved",null,null,null,"Proposed",null,null,null,"Impact"]
[null,null,null,"Charge Unit",null,"Rate","Volume","Charge",null,"Rate","Volume","Charge",null,"$ Change","% Change"]
[null,null,null,null,null,"($)",null,"($)",null,"($)",null,"($)"]
[null,"Monthly Service Charge",null,"Monthly",null,12.06,1,{"$f":"G22*F22","v":12.06},null,12.449,{"$f":"G22","v":1},{"$f":"K22*J22","v":12.449},null,{"$f":"L22-H22","v":0.38899999999999935},{"$f":"IF((H22)=0,\"\",(N22/H22))","v":3.2255389718076233E-2}]
[null,"Smart Meter Rate Adder",null,null,null,null,1,{"$f":"G23*F23","v":0},null,null,{"$f":"G23","v":1},{"$f":"K23*J23","v":0},null,{"$f":"L23-H23","v":0},{"$f":"IF((H23)=0,\"\",(N23/H23))","v":""}]
[null,"Stranded Meter Recovery ",null,null,null,null,1,0,null,null,{"$f":"G24","v":1},{"$f":"K24*J24","v":0},null,{"$f":"L24-H24","v":0},{"$f":"IF((H24)=0,\"\",(N24/H24))","v":""}]
[null,null,null,null,null,null,1,0,null,null,{"$f":"G25","v":1},0,null,0,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,"Distribution Volumetric Rate",null,"per kWh",null,7.1999999999999998E-3,{"$f":"F17","v":150},1.08,null,{"$f":"'[2]Distribution Rate Schedule'!$E$16","v":7.4000000000000003E-3},150,1.1100000000000001,null,3.0000000000000027E-2,{"$f":"IF((H28)=0,\"\",(N28/H28))","v":2.7777777777777801E-2}]
[null,"Smart Meter Disposition Rider",null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,"LRAM & SSM Rate Rider",null,"per kWh",null,9.2999999999999992E-3,{"$f":"F17","v":150},1.3949999999999998,null,null,150,0,null,-1.3949999999999998,-1]
[null,"Tax change",null,"per kWh",null,-5.9999999999999995E-4,{"$f":"F17","v":150},-0.09,null,null,150,0,null,0.09,-1]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,"Sub-Total A",null,null,null,null,null,{"$f":"SUM(H22:H37)","v":14.445},null,null,null,{"$f":"SUM(L22:L37)","v":13.558999999999999},null,-0.88600000000000101,-6.1336102457597852E-2]
[null,"Deferral/Variance Account Disposition Rate Rider",null,"per kWh",null,-9.5999999999999992E-3,{"$f":"F17","v":150},{"$f":"G39*F39","v":-1.44},null,-5.0000000000000001E-3,{"$f":"G39","v":150},{"$f":"K39*J39","v":-0.75},null,{"$f":"L39-H39","v":0.69},{"$f":"IF((H39)=0,\"\",(N39/H39))","v":-0.47916666666666663}]
[null,"Global Adjustment - Non RPP",null,null,null,0,{"$f":"F16","v":0},{"$f":"G40*F40","v":0},null,2.2000000000000001E-3,{"$f":"G40","v":0},{"$f":"K40*J40","v":0},null,{"$f":"L40-H40","v":0},{"$f":"IF((H40)=0,\"\",(N40/H40))","v":""}]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,"Low Voltage Service Charge",null,null,null,null,null,{"$f":"G43*F43","v":0},null,null,0,{"$f":"K43*J43","v":0},null,{"$f":"L43-H43","v":0},{"$f":"IF((H43)=0,\"\",(N43/H43))","v":""}]
[null,"Smart Meter Entity Charge",null,null,null,null,null,null,null,null,0,{"$f":"K44*J44","v":0},null,{"$f":"L44-H44","v":0}]
[null,"Sub-Total B - Distribution (includes Sub-Total A)",null,null,null,null,null,{"$f":"SUM(H39:H43)+H38","v":13.005000000000001},null,null,null,{"$f":"SUM(L39:L43)+L38","v":12.808999999999999},null,{"$f":"L45-H45","v":-0.19600000000000151},{"$f":"IF((H45)=0,\"\",(N45/H45))","v":-1.5071126489811727E-2}]
[null,"RTSR - Network",null,"per kWh",null,7.1999999999999998E-3,{"$f":"F17","v":150},{"$f":"G46*F46","v":1.08},null,6.7000000000000002E-3,{"$f":"F17","v":150},{"$f":"K46*J46","v":1.0050000000000001},null,-7.4999999999999956E-2,-6.9444444444444392E-2]
[null,"RTSR - Line and Transformation Connection",null,"per kWh",null,4.7999999999999996E-3,{"$f":"F17","v":150},{"$f":"G47*F47","v":0.72},null,4.5999999999999999E-3,{"$f":"F17","v":150},{"$f":"K47*J47","v":0.69},null,-3.0000000000000027E-2,-4.1666666666666706E-2]
[null,"Sub-Total C - Delivery (including Sub-Total B)",null,null,null,null,null,{"$f":"SUM(H45:H47)","v":14.805000000000001},null,null,null,{"$f":"SUM(L45:L47)","v":14.504},null,-0.30100000000000193,-2.033096926713961E-2]
[null,"Wholesale Market Service Charge (WMSC)",null,"per kWh",null,4.4000000000000003E-3,{"$f":"F17","v":150},{"$f":"G49*F49","v":0.66},null,4.4000000000000003E-3,{"$f":"$F$17*(1+$J$70)","v":155.23499999999999},{"$f":"K49*J49","v":0.68303400000000003},null,2.3033999999999999E-2,3.4899999999999994E-2]
[null,"Rural and Remote Rate Protection (RRRP)",null,"per kWh",null,1.1999999999999999E-3,{"$f":"F17","v":150},0.18,null,1.1999999999999999E-3,{"$f":"$F$17*(1+$J$70)","v":155.23499999999999},0.18628199999999998,null,6.281999999999982E-3,3.4899999999999903E-2]
[null,"Standard Supply Service Charge",null,"Monthly",null,0.25,1,0.25,null,0.25,{"$f":"G51","v":1},0.25,null,0,0]
[null,"Debt Retirement Charge (DRC)",null,"per kWh",null,7.0000000000000001E-3,{"$f":"F17","v":150},1.05,null,7.0000000000000001E-3,{"$f":"$F$17*(1+$J$70)","v":155.23499999999999},1.0866449999999999,null,3.6644999999999817E-2,{"$f":"IF((H52)=0,\"\",(N52/H52))","v":3.4899999999999827E-2}]
[null,"Energy - RPP - Tier 1",null,null,null,7.8E-2,0,{"$f":"G53*F53","v":0},null,7.8E-2,0,{"$f":"K53*J53","v":0},null,0,""]
[null,"Energy - RPP - Tier 2",null,null,null,9.0999999999999998E-2,0,{"$f":"G54*F54","v":0},null,9.0999999999999998E-2,0,{"$f":"K54*J54","v":0},null,0,""]
[null,"Energy - COP",null,"per kWh",null,8.5449999999999998E-2,{"$f":"F17","v":150},12.817499999999999,null,8.5449999999999998E-2,{"$f":"$F$17*(1+$J$70)","v":155.23499999999999},13.264830749999998,null,0.447330749999999,3.4899999999999924E-2]
[]
[null,"Total Bill on RPP (before Taxes)",null,null,null,null,null,{"$f":"SUM(H48:H54)","v":16.945},null,null,null,{"$f":"SUM(L48:L54)","v":16.709961},null,-0.23503900000000044,-1.3870699321333753E-2]
[null,"HST",null,null,null,0.13,null,{"$f":"H57*F58","v":2.2028500000000002},null,0.13,null,{"$f":"L57*J58","v":2.1722949300000001},null,-3.0555070000000129E-2,-1.3870699321333784E-2]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H57+H58","v":19.147850000000002},null,null,null,{"$f":"L57+L58","v":18.882255929999999},null,-0.26559407000000235,-1.3870699321333849E-2]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H59*10%,2)","v":-1.91},null,null,null,{"$f":"ROUND(-L59*10%,2)","v":-1.89},null,2.0000000000000018E-2,-1.0471204188481685E-2]
[null,"Total Bill on RPP (including OCEB)",null,null,null,null,null,{"$f":"SUM(H59:H60)","v":17.237850000000002},null,null,null,{"$f":"SUM(L59:L60)","v":16.992255929999999},null,-0.24559407000000277,-1.4247372497150326E-2]
[]
[null,"Total Bill  (before Taxes)",null,null,null,null,null,{"$f":"SUM(H48:H52,H55:H55)","v":29.762499999999999},null,null,null,{"$f":"SUM(L48:L52,L55:L55)","v":29.974791749999998},null,{"$f":"L63-H63","v":0.21229174999999856},{"$f":"IF((H63)=0,\"\",(N63/H63))","v":7.1328601427970957E-3}]
[null,"HST",null,null,null,0.13,null,{"$f":"H63*F64","v":3.8691249999999999},null,0.13,null,{"$f":"L63*J64","v":3.8967229274999999},null,2.7597927500000008E-2,7.1328601427971461E-3]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H63+H64","v":33.631625},null,null,null,{"$f":"L63+L64","v":33.871514677499995},null,0.23988967749999546,7.132860142797009E-3]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H65*10%,2)","v":-3.36},null,null,null,{"$f":"ROUND(-L65*10%,2)","v":-3.39},null,-3.0000000000000249E-2,8.9285714285715027E-3]
[null,"Total Bill (including OCEB)",null,null,null,null,null,{"$f":"H65+H66","v":30.271625},null,null,null,{"$f":"L65+L66","v":30.481514677499995},null,0.20988967749999432,6.9335451103135137E-3]
[]
[]
[null,"Loss Factor (%)",null,null,null,4.2000000000000003E-2,null,null,null,3.49E-2]
[]
["1 Applicable to eligible customers only.  Refer to the Ontario Clean Energy Benefit Act, 2010."]
[]
["Note that the \"Charge $\" columns provide breakdowns of the amounts that each bill component contributes to the total monthly bill at the referenced "]
["consumption level at existing and proposed rates."]
[]
["Applicants must provide bill impacts for residential at 800 kWh and GS<50kW at 2000 kWh. In addition, their filing should cover the range that is relevant"]
["to their service territory, class by class. A general guideline of consumption levels follows:"]
[]
["Residential (kWh) - 100, 250, 500, 800, 1000, 1500, 2000"]
["GS<50kW (kWh) - 1000, 2000, 5000, 10000, 15000"]
["GS>50kW (kW) - 60, 100, 500, 1000"]
["Large User - range appropriate for utility"]
["Lighting Classes and USL - 150 kWh and 1 kW, range appropriate for utility."]

{"sheet":"App.2-W_Bill Impacts -Embedded","index":6,"n_rows":84,"n_cols":20,"rows_kept":84,"cut":false,"hidden":false,"merged":[[2,0,2,10],[59,1,59,3],[65,1,65,3],[60,1,60,3],[66,1,66,3],[9,1,9,14],[10,1,10,14],[13,3,13,14],[18,5,18,7],[18,9,18,11],[18,13,18,14],[19,3,20,3],[19,13,20,13],[19,14,20,14]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"File Number:",{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Exhibit:",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tab:",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule:",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page:",58]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:","July 17,2013"]
[]
[]
[null,"Appendix 2-W"]
[null,"Bill Impacts"]
[]
[]
[null,"Customer Class:",null,"Embedded Distributor"]
[]
[null,null,null,"Consumption",null,158473,"kW"]
[null,null,null,"Consumption ",null,78857860,"kWh"]
[]
[null,null,null,null,null,"Current Board-Approved",null,null,null,"Proposed",null,null,null,"Impact"]
[null,null,null,"Charge Unit",null,"Rate","Volume","Charge",null,"Rate","Volume","Charge",null,"$ Change","% Change"]
[null,null,null,null,null,"($)",null,"($)",null,"($)",null,"($)"]
[null,"Monthly Service Charge",null,"Monthly",null,293.70999999999998,1,{"$f":"G22*F22","v":293.70999999999998},null,277.82,{"$f":"G22","v":1},{"$f":"K22*J22","v":277.82},null,{"$f":"L22-H22","v":-15.889999999999986},{"$f":"IF((H22)=0,\"\",(N22/H22))","v":-5.4100983963773747E-2}]
[null,"Smart Meter Rate Adder",null,"Monthly",null,null,1,{"$f":"G23*F23","v":0},null,null,{"$f":"G23","v":1},{"$f":"K23*J23","v":0},null,{"$f":"L23-H23","v":0},{"$f":"IF((H23)=0,\"\",(N23/H23))","v":""}]
[null,"Stranded Meter Recovery ",null,null,null,null,1,0,null,null,{"$f":"G24","v":1},{"$f":"K24*J24","v":0},null,{"$f":"L24-H24","v":0},{"$f":"IF((H24)=0,\"\",(N24/H24))","v":""}]
[null,null,null,null,null,null,1,0,null,null,{"$f":"G25","v":1},0,null,0,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,"Distribution Volumetric Rate",null,"per kW",null,1.7487999999999999,{"$f":"F16","v":158473},277137.58240000001,null,1.6541999999999999,158473,262146.03659999999,null,-14991.545800000022,{"$f":"IF((H28)=0,\"\",(N28/H28))","v":-5.4094236047575558E-2}]
[null,"Smart Meter Disposition Rider",null,"Monthly",null,null,1,0,null,null,1,0,null,0,""]
[null,"LRAM & SSM Rate Rider",null,"per kW",null,0,{"$f":"F16","v":158473},0,null,null,158473,0,null,0,""]
[null,"Tax change",null,"per kW",null,-3.0700000000000002E-2,{"$f":"F16","v":158473},-4865.1211000000003,null,null,158473,0,null,4865.1211000000003,-1]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,"Sub-Total A",null,null,null,null,null,{"$f":"SUM(H22:H37)","v":272566.17130000005},null,null,null,{"$f":"SUM(L22:L37)","v":262423.8566},null,-10142.314700000046,-3.7210467651309906E-2]
[null,"Deferral/Variance Account Disposition Rate Rider",null,"per kW",null,0,{"$f":"F16","v":158473},{"$f":"G39*F39","v":0},null,null,{"$f":"G39","v":158473},{"$f":"K39*J39","v":0},null,{"$f":"L39-H39","v":0},{"$f":"IF((H39)=0,\"\",(N39/H39))","v":""}]
[null,"Global Adjustment - Non RPP",null,"per kW",null,0,{"$f":"F16","v":158473},{"$f":"G40*F40","v":0},null,null,{"$f":"G40","v":158473},{"$f":"K40*J40","v":0},null,{"$f":"L40-H40","v":0},{"$f":"IF((H40)=0,\"\",(N40/H40))","v":""}]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,null,null,null,null,null,null,0,null,null,0,0,null,0,""]
[null,"Low Voltage Service Charge",null,null,null,null,null,{"$f":"G43*F43","v":0},null,null,0,{"$f":"K43*J43","v":0},null,{"$f":"L43-H43","v":0},{"$f":"IF((H43)=0,\"\",(N43/H43))","v":""}]
[null,"Smart Meter Entity Charge",null,null,null,null,null,null,null,null,0,{"$f":"K44*J44","v":0},null,{"$f":"L44-H44","v":0}]
[null,"Sub-Total B - Distribution (includes Sub-Total A)",null,null,null,null,null,{"$f":"SUM(H39:H43)+H38","v":272566.17130000005},null,null,null,{"$f":"SUM(L39:L43)+L38","v":262423.8566},null,{"$f":"L45-H45","v":-10142.314700000046},{"$f":"IF((H45)=0,\"\",(N45/H45))","v":-3.7210467651309906E-2}]
[null,"RTSR - Network",null,"per kW",null,2.4601000000000002,{"$f":"F16*(1+F70)","v":158473},{"$f":"G46*F46","v":389859.42730000004},null,2.3035999999999999,{"$f":"$F$16*(1+$J$70)","v":158473},{"$f":"K46*J46","v":365058.40279999998},null,-24801.024500000058,-6.3615300191049287E-2]
[null,"RTSR - Line and Transformation Connection",null,"per kW",null,1.6397999999999999,{"$f":"G46","v":158473},{"$f":"G47*F47","v":259864.02539999998},null,1.5708,{"$f":"$F$16*(1+$J$70)","v":158473},{"$f":"K47*J47","v":248929.3884},null,-10934.636999999988,-4.2078302231979468E-2]
[null,"Sub-Total C - Delivery (including Sub-Total B)",null,null,null,null,null,{"$f":"SUM(H45:H47)","v":922289.62400000007},null,null,null,{"$f":"SUM(L45:L47)","v":876411.64779999992},null,-45877.97620000015,-4.9743567536871855E-2]
[null,"Wholesale Market Service Charge (WMSC)",null,"per kWh",null,4.4000000000000003E-3,{"$f":"$F$17*(1+$F$70)","v":78857860},{"$f":"G49*F49","v":346974.58400000003},null,4.4000000000000003E-3,{"$f":"$F$17*(1+$J$70)","v":78857860},{"$f":"K49*J49","v":346974.58400000003},null,0,0]
[null,"Rural and Remote Rate Protection (RRRP)",null,"per kWh",null,1.1999999999999999E-3,{"$f":"$F$17*(1+$F$70)","v":78857860},94629.431999999986,null,1.1999999999999999E-3,{"$f":"$F$17*(1+$J$70)","v":78857860},94629.431999999986,null,0,0]
[null,"Standard Supply Service Charge",null,"Monthly",null,0.25,1,0.25,null,0.25,{"$f":"G51","v":1},0.25,null,0,0]
[null,"Debt Retirement Charge (DRC)",null,"per kWh",null,7.0000000000000001E-3,{"$f":"$F$17*(1+$F$70)","v":78857860},552005.02,null,7.0000000000000001E-3,{"$f":"$F$17*(1+$J$70)","v":78857860},552005.02,null,0,{"$f":"IF((H52)=0,\"\",(N52/H52))","v":0}]
[null,"Energy - RPP - Tier 1",null,null,null,7.8E-2,0,{"$f":"G53*F53","v":0},null,7.8E-2,0,{"$f":"K53*J53","v":0},null,0,""]
[null,"Energy - RPP - Tier 2",null,null,null,9.0999999999999998E-2,0,{"$f":"G54*F54","v":0},null,9.0999999999999998E-2,0,{"$f":"K54*J54","v":0},null,0,""]
[null,"Energy - COP",null,null,null,8.5449999999999998E-2,{"$f":"$F$17*(1+$F$70)","v":78857860},6738404.1370000001,null,8.5449999999999998E-2,{"$f":"$F$17*(1+$J$70)","v":78857860},6738404.1370000001,null,0,0]
[]
[null,"Total Bill on RPP (before Taxes)",null,null,null,null,null,{"$f":"SUM(H48:H54)","v":1915898.9100000001},null,null,null,{"$f":"SUM(L48:L54)","v":1870020.9338},null,-45877.97620000015,-2.3945927397599567E-2]
[null,"HST",null,null,null,0.13,null,{"$f":"H57*F58","v":249066.85830000002},null,0.13,null,{"$f":"L57*J58","v":243102.72139400002},null,-5964.1369059999997,-2.3945927397599487E-2]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H57+H58","v":2164965.7683000001},null,null,null,{"$f":"L57+L58","v":2113123.6551939999},null,-51842.113106000237,-2.3945927397599598E-2]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H59*10%,2)","v":-216496.58},null,null,null,{"$f":"ROUND(-L59*10%,2)","v":-211312.37},null,5184.2099999999919,-2.3945920993301568E-2]
[null,"Total Bill on RPP (including OCEB)",null,null,null,null,null,{"$f":"SUM(H59:H60)","v":1948469.1883},null,null,null,{"$f":"SUM(L59:L60)","v":1901811.2851939998},null,-46657.903106000274,-2.3945928109188296E-2]
[]
[null,"Total Bill  (before Taxes)",null,null,null,null,null,{"$f":"SUM(H48:H52,H55:H55)","v":8654303.0470000003},null,null,null,{"$f":"SUM(L48:L52,L55:L55)","v":8608425.0708000008},null,{"$f":"L63-H63","v":-45877.976199999452},{"$f":"IF((H63)=0,\"\",(N63/H63))","v":-5.3011751438381827E-3}]
[null,"HST",null,null,null,0.13,null,{"$f":"H63*F64","v":1125059.3961100001},null,0.13,null,{"$f":"L63*J64","v":1119095.2592040002},null,-5964.1369059998542,-5.3011751438381167E-3]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H63+H64","v":9779362.4431100003},null,null,null,{"$f":"L63+L64","v":9727520.330004001},null,-51842.113105999306,-5.3011751438381757E-3]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H65*10%,2)","v":-977936.24},null,null,null,{"$f":"ROUND(-L65*10%,2)","v":-972752.03},null,5184.2099999999627,-5.3011738270380112E-3]
[null,"Total Bill (including OCEB)",null,null,null,null,null,{"$f":"H65+H66","v":8801426.2031100001},null,null,null,{"$f":"L65+L66","v":8754768.3000040017},null,-46657.903105998412,-5.3011752901491981E-3]
[]
[]
[null,"Loss Factor (%)",null,null,null,0,null,null,null,0]
[]
["1 Applicable to eligible customers only.  Refer to the Ontario Clean Energy Benefit Act, 2010."]
[]
["Note that the \"Charge $\" columns provide breakdowns of the amounts that each bill component contributes to the total monthly bill at the referenced "]
["consumption level at existing and proposed rates."]
[]
["Applicants must provide bill impacts for residential at 800 kWh and GS<50kW at 2000 kWh. In addition, their filing should cover the range that is relevant"]
["to their service territory, class by class. A general guideline of consumption levels follows:"]
[]
["Residential (kWh) - 100, 250, 500, 800, 1000, 1500, 2000"]
["GS<50kW (kWh) - 1000, 2000, 5000, 10000, 15000"]
["GS>50kW (kW) - 60, 100, 500, 1000"]
["Large User - range appropriate for utility"]
["Lighting Classes and USL - 150 kWh and 1 kW, range appropriate for utility."]