{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["1. Information Sheet","List","GA Analysis ","GA 2016","GA 2015","GA 2019","GA 2020","GA 2021","GA 2022","GA 2023","Account 1588","Principal Adjustments","GA Rates","4705","RRR_2017","RRR_2018","RRR_2019","RRR_2020","RRR_2021","RRR_2022"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":10,"defined_names":177,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1. Information Sheet","index":0,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[[19,1,19,2],[20,3,23,3],[27,1,27,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[26,1,26,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Version 1.0"]
[]
[]
[]
[null,"Input cells"]
[null,"Drop down cells"]
[]
[null,"Utility Name   ","ERTH POWER CORPORATION – GODERICH RATE ZONE"]
[]
["Note 1"]
[null,"For Account 1589 and Account 1588, determine if a or b below applies and select the appropriate year related to the account balance in the drop-down box to the right.",null,"Year Selected"]
[null,"a) If the account balances were last approved on a final basis, select the year of the year-end balances that were last approved on a final basis. ",null,2021]
[null,"b) If the account balances were last approved on an interim basis, and "]
[null,"i) there are no changes to the previously approved interim balances, select the year of the year-end balances that were last approved for diposition on an interim basis. OR"]
[null,"ii) there are changes to the previously approved interim balances, select the year of the year-end balances that were last approved for disposition on a final basis. An explanation should be provided to explain the reason for the change in the previously approved interim balances."]
[null,"(e.g. If the 2022 balances that were reviewed in the 2024 rate application were to be selected, select 2022)"]
[]
[null,"Instructions:\n1) Determine which scenario above applies (a, bi or bii). Select the appropriate year to generate the appropriate GA Analysis Workform tabs, and information in the Principal Adjustments tab and Account 1588 tab.\nFor example:\n     • Scenario a -If 2022 balances were last approved on a final basis - Select 2022 and a GA Analysis Workform for 2023 will be generated. The input cells required in the Principal Adjustment and Account 1588 tabs will be generated accordingly as well.  \n     • Scenario bi - If 2022 balances were last approved on an interim basis and there are no changes to 2022 balances - Select 2022 and a GA Analysis Workform for 2023 will be generated. The input cells required in the Principal Adjustment and Account 1588 tabs will be generated accordingly as well.  \n     • Scenario bii - If 2022 balances were last approved on an interim basis, there are changes to 2022 balances, and 2021 balances were last approved for disposition - Select 2021 and GA Analysis Workforms for 2022 and 2023 will be generated. The input cells required in the Principal Adjustment and Account 1588 tabs will be generated accordingly as well.  \n2) Complete the GA Analysis Workform for each year generated.\n3) Complete the Account 1588 tab. Note that the number of years that require the reasonability test to be completed are shown in the Account 1588 tab, depending on the year selected on the Information Sheet. \n4) Complete the Principal Adjustments tab. Note that the number of years that require principal adjustment reconciliations are all shown in the one Principal Adjustments tab, depending on the year selected on the Information Sheet.\n\nSee the separate document GA Analysis Workform Instructions for detailed instructions on how to complete the Workform and examples of reconciling items and principal adjustments."]
[null," "]
[null,"GA Analysis Workform Summary"]
[null,"Year","Annual Net Change in Expected GA Balance from GA Analysis"," Net Change in Principal Balance in the GL","Reconciling Items ","Adjusted Net Change in Principal Balance in the GL","Unresolved Difference","$ Consumption at Actual Rate Paid ","Unresolved Difference as % of Expected GA Payments to IESO"]
[null,2018,null,null,null,null,null,null,{"$f":"IF(ISERROR(G31/H31),0,G31/H31)","v":0}]
[null,2019,{"$f":"'GA 2019'!$C$91","v":0},{"$f":"'GA 2019'!$C$75","v":0},{"$f":"SUM('GA 2019'!$C$76:$C$89)","v":0},{"$f":"'GA 2019'!$C$90","v":0},{"$f":"F32-C32","v":0},{"$f":"'GA 2019'!$J$53","v":0},0]
[null,2020,{"$f":"'GA 2020'!$C$91","v":0},{"$f":"'GA 2020'!$C$75","v":0},{"$f":"SUM('GA 2020'!$C$76:$C$89)","v":0},{"$f":"'GA 2020'!$C$90","v":0},{"$f":"F33-C33","v":0},{"$f":"'GA 2020'!$J$53","v":0},0]
[null,2021,{"$f":"'GA 2021'!$C$91","v":0},{"$f":"'GA 2021'!$C$75","v":0},{"$f":"SUM('GA 2021'!$C$76:$C$89)","v":0},{"$f":"'GA 2021'!$C$90","v":0},{"$f":"F34-C34","v":0},{"$f":"'GA 2021'!$J$53","v":0},0]
[null,2022,{"$f":"'GA 2022'!$C$91","v":7153.0299760001508},{"$f":"'GA 2022'!$C$75","v":16587.949600000014},{"$f":"SUM('GA 2022'!$C$76:$C$89)","v":-17861.310954951303},{"$f":"'GA 2022'!$C$90","v":-1273.3613549512884},{"$f":"F35-C35","v":-8426.3913309514392},{"$f":"'GA 2022'!$J$53","v":1332289.9554678001},-6.3247428207118201E-3]
[null,2023,{"$f":"'GA 2023'!$C$91","v":147134.32998524842},{"$f":"'GA 2023'!$C$75","v":82471.215493148251},{"$f":"SUM('GA 2023'!$C$76:$C$89)","v":46282.281031616803},{"$f":"'GA 2023'!$C$90","v":128753.49652476505},{"$f":"F36-C36","v":-18380.833460483365},{"$f":"'GA 2023'!$J$53","v":1885212.6431423},-9.7500054051440719E-3]
[null,"Cumulative Balance ",{"$f":"SUM(C32:C36)","v":154287.35996124859},99059.165093148273,28420.970076665501,127480.13516981376,-26807.224791434805,3217502.5986101003,"N/A"]
[]
[]
[null,"Account 1588 Reconciliation Summary"]
[null,"Year","Account 1588 as a % of Account 4705"]
[null,2018,{"$f":"'Account 1588'!G15","v":0}]
[null,2019,{"$f":"'Account 1588'!G16","v":0}]
[null,2020,{"$f":"'Account 1588'!G17","v":0}]
[null,2021,{"$f":"'Account 1588'!G18","v":0}]
[null,2022,{"$f":"'Account 1588'!G19","v":-3.9453815910043578E-3}]
[null,2023,{"$f":"'Account 1588'!G20","v":2.3825310943196855E-3}]
[null,"Cumulative Balance ",{"$f":"'Account 1588'!G21","v":-1.210311778098419E-3}]

{"sheet":"List","index":1,"n_rows":71,"n_cols":1,"rows_kept":71,"cut":false,"hidden":true,"merged":[]}
["Alectra Utilities Corporation-Brampton Rate Zone"]
["Alectra Utilities Corporation-Enersource Rate Zone"]
["Alectra Utilities Corporation-Horizon Utilities Rate Zone"]
["Alectra Utilities Corporation-PowerStream Rate Zone"]
["Alectra Utilities Corporation-Guelph Rate Zone"]
["Algoma Power Inc."]
["Atikokan Hydro Inc."]
["Bluewater Power Distribution Corporation"]
["Burlington Hydro Inc."]
["Canadian Niagara Power Inc."]
["Centre Wellington Hydro Ltd."]
["Chapleau Public Utilities Corporation"]
["Cooperative Hydro Embrun Inc."]
["E.L.K. Energy Inc."]
["Elexicon Energy Inc.-Whitby Rate Zone"]
["Elexicon Energy Inc.-Veridian Rate Zone"]
["Enova Power Corp.-Kitchener-Wilmot Hydro Rate Zone"]
["Enova Power Corp.-Waterloo North Rate Zone"]
["Entegrus Powerlines Inc.-For Entegrus-Main Rate Zone"]
["Entegrus Powerlines Inc.-For Former St. Thomas Energy Rate Zone"]
["ENWIN Utilities Ltd."]
["EPCOR Electricity Distribution Ontario Inc."]
["ERTH Power Corporation - ERTH Power Main Rate Zone"]
["ERTH POWER CORPORATION – GODERICH RATE ZONE"]
["Essex Powerlines Corporation"]
["Festival Hydro Inc."]
["Fort Frances Power Corporation"]
["GrandBridge Energy Inc.-Brantford Power Rate Zone "]
["GrandBridge Energy Inc.-Energy+ Rate Zone "]
["Greater Sudbury Hydro Inc."]
["Grimsby Power Incorporated"]
["Halton Hills Hydro Inc."]
["Hearst Power Distribution Co. Ltd."]
["Hydro 2000 Inc."]
["Hydro Hawkesbury Inc."]
["Hydro One Networks Inc."]
["Hydro One Networks Inc.-Former Orillia Power Distribution Corporation Service Area"]
["Hydro One Networks Inc.-Former Peterborough Distribution Inc. Service Area"]
["Hydro One Networks Inc.-Former Haldimand County Hydro Inc. Service Area"]
["Hydro One Networks Inc.-Former Norfolk Power Distribution Inc. Service Area"]
["Hydro One Networks Inc.-Former Woodstock Hydro Services Inc. Service Area"]
["Hydro One Remote Communites Inc."]
["Hydro Ottawa Limited"]
["InnPower Corporation"]
["Kingston Hydro Corporation"]
["Lakefront Utilities Inc."]
["Lakeland Power Distribution Ltd."]
["London Hydro Inc."]
["Milton Hydro Distribution Inc."]
["Newmarket-Tay Power Distribution Ltd.-For Former Midland Power Utility Rate Zone"]
["Newmarket-Tay Power Distribution Ltd.-For Newmarket-Tay Power Main Rate Zone"]
["Niagara Peninsula Energy Inc."]
["Niagara-on-the-Lake Hydro Inc."]
["North Bay Hydro Distribution Limited"]
["Northern Ontario Wires Inc."]
["Oakville Hydro Electricity Distribution Inc."]
["Orangeville Hydro Limited"]
["Oshawa PUC Networks Inc."]
["Ottawa River Power Corporation"]
["PUC Distribution Inc."]
["Renfrew Hydro Inc."]
["Rideau St. Lawrence Distribution Inc."]
["Sioux Lookout Hydro Inc."]
["Synergy North Corporation-Kenora Rate Zone"]
["Synergy North Corporation-Thunder Bay Rate Zone "]
["Tillsonburg Hydro Inc."]
["Toronto Hydro-Electric System Limited"]
["Wasaga Distribution Inc."]
["Welland Hydro-Electric System Corp."]
["Wellington North Power Inc."]
["Westario Power Inc."]

{"sheet":"GA Analysis ","index":2,"n_rows":95,"n_cols":24,"rows_kept":95,"cut":false,"hidden":true,"merged":[[44,17,44,19],[44,20,44,22],[64,4,64,8],[69,4,69,8],[20,1,20,2],[20,4,20,5],[26,1,26,7],[44,14,44,16],[63,4,63,8],[65,4,65,8],[66,4,66,8],[67,4,67,8],[68,4,68,8],[64,0,64,2],[76,4,76,8],[77,4,77,8],[70,4,70,8],[71,4,71,8],[72,4,72,8],[73,4,73,8],[74,4,74,8],[75,4,75,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account 1589 Global Adjustment (GA) Analysis Workform"]
[]
[null,"Input cells",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014]
[null,"Drop down cells"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015]
["Note 1","Year(s) Requested for Disposition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016]
[]
[]
["Note 2","Consumption Data Excluding for Loss Factor (Data to agree with RRR as applicable)"]
[null,"Year"]
[null,"Total Metered excluding WMP","C = A+B",{"$f":"D23+D24","v":0},"kWh",1]
[null,"RPP ","A",null,"kWh",{"$f":"IFERROR(D23/$D$22,0)","v":0}]
[null,"Non RPP","B = D+E",{"$f":"D25+D26","v":0},"kWh",{"$f":"IFERROR(D24/$D$22,0)","v":0}]
[null,"Non-RPP Class A","D",null,"kWh",{"$f":"IFERROR(D25/$D$22,0)","v":0}]
[null,"Non-RPP Class B*","E",null,"kWh",{"$f":"IFERROR(D26/$D$22,0)","v":0}]
[null,"*Non-RPP Class B consumption reported in this table is not expected to directly agree with the Non-RPP Class B Including Loss Adjusted Billed Consumption in the GA Analysis of Expected Balance table below.  The difference should be equal to the loss factor."]
[]
["Note 3","GA Billing Rate"]
[]
[null,"GA is billed on the "]
[]
[null,"GA Billing Rate Description"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Note 4","Analysis of Expected GA Amount"]
[null,"Year",null,null,null,null,null,null,null,null,null,null,null,"GA Rates per IESO website"]
[null,"Calendar Month","Non-RPP Class B Including Loss Factor Billed Consumption (kWh)","Deduct Previous Month Unbilled Loss Adjusted Consumption (kWh)","Add Current Month Unbilled Loss Adjusted Consumption (kWh)","Non-RPP Class B Including Loss Adjusted Consumption, Adjusted for Unbilled (kWh)","GA Rate Billed  ($/kWh)","$ Consumption at GA Rate Billed","GA Actual Rate Paid ($/kWh)","$ Consumption at Actual Rate Paid","Expected GA Variance ($)",null,null,null,2017,null,null,2016,null,null,2015]
[null,null,"F","G","H","I = F-G+H","J","K = I*J","L","M = I*L","=M-K",null,null,"($/kWh)","First Estimate","Second Estimate","Actual","First Estimate","Second Estimate","Actual","First Estimate","Second Estimate","Actual"]
[null,"January",null,null,null,{"$f":"C47-D47+E47","v":0},null,{"$f":"F47*G47","v":0},null,{"$f":"F47*I47","v":0},{"$f":"J47-H47","v":0},null,null,"January",6.6869999999999999E-2,8.677E-2,8.2269999999999996E-2,8.4229999999999999E-2,9.214E-2,9.1789999999999997E-2,5.5490000000000005E-2,6.1609999999999998E-2,5.0680000000000003E-2]
[null,"February",null,null,null,{"$f":"C48-D48+E48","v":0},null,{"$f":"F48*G48","v":0},null,{"$f":"F48*I48","v":0},{"$f":"J48-H48","v":0},null,null,"February",0.10559,8.43E-2,8.6389999999999995E-2,0.10384,9.6780000000000005E-2,9.851E-2,6.9809999999999997E-2,4.095E-2,3.9609999999999999E-2]
[null,"March",null,null,null,0,null,0,null,0,0,null,null,"March",8.4089999999999998E-2,6.8860000000000005E-2,7.1349999999999997E-2,9.0219999999999995E-2,0.10299,0.1061,3.6040000000000003E-2,5.74E-2,6.2899999999999998E-2]
[null,"April",null,null,null,0,null,0,null,0,0,null,null,"April",6.8739999999999996E-2,0.10218000000000001,0.10778,0.12114999999999999,0.11176999999999999,0.11132,6.7049999999999998E-2,9.2679999999999998E-2,9.5590000000000008E-2]
[null,"May",null,null,null,0,null,0,null,0,0,null,null,"May",0.10623,0.12776000000000001,0.12307,0.10405,0.11493,0.10749,9.4159999999999994E-2,9.7299999999999998E-2,9.6680000000000002E-2]
[null,"June",null,null,null,0,null,0,null,0,0,null,null,"June",0.11953999999999999,0.12536,0.11848,0.11650000000000001,9.3600000000000003E-2,9.5449999999999993E-2,9.2280000000000001E-2,9.7680000000000003E-2,9.5400000000000013E-2]
[null,"July",null,null,null,0,null,0,null,0,0,null,null,"July",0.10652,0.10197000000000001,0.1128,7.6670000000000002E-2,8.412E-2,8.3059999999999995E-2,8.8880000000000001E-2,8.4129999999999996E-2,7.8829999999999997E-2]
[null,"August",null,null,null,0,null,0,null,0,0,null,null,"August",0.115,0.10476000000000001,0.10109,8.5690000000000002E-2,7.0499999999999993E-2,7.1029999999999996E-2,8.8050000000000003E-2,7.3550000000000004E-2,8.0099999999999991E-2]
[null,"September",null,null,null,0,null,0,null,0,0,null,null,"September",0.12739,9.8949999999999996E-2,8.8639999999999997E-2,7.0599999999999996E-2,9.1480000000000006E-2,9.5310000000000006E-2,8.270000000000001E-2,7.1910000000000002E-2,6.7030000000000006E-2]
[null,"October",null,null,null,0,null,0,null,0,0,null,null,"October",0.10212,0.11973,0.12562999999999999,9.7199999999999995E-2,0.1178,0.11226,6.3710000000000003E-2,7.1929999999999994E-2,7.5439999999999993E-2]
[null,"November ",null,null,null,0,null,0,null,0,0,null,null,"November ",0.11164,9.6689999999999998E-2,9.7040000000000001E-2,0.12271,0.115,0.11108999999999999,7.6230000000000006E-2,0.12447999999999999,0.11320000000000001]
[null,"December",null,null,null,0,null,0,null,0,0,null,null,"December",8.3909999999999998E-2,9.6689999999999998E-2,9.2069999999999999E-2,0.10594000000000001,7.8719999999999998E-2,8.7080000000000005E-2,0.11462,8.8090000000000002E-2,9.4709999999999989E-2]
[null,"Net Change in Expected GA Balance in the Year (i.e. Transactions in the Year)",{"$f":"SUM(C47:C58)","v":0},{"$f":"SUM(D47:D58)","v":0},{"$f":"SUM(E47:E58)","v":0},{"$f":"SUM(F47:F58)","v":0},null,{"$f":"SUM(H47:H58)","v":0},null,{"$f":"SUM(J47:J58)","v":0},{"$f":"SUM(K47:K58)","v":0}]
[]
[]
["Note 5 ","Reconciling Items "]
[]
[null," Item","Applicability of Reconciling Item (Y/N)","Amount (Quantify if it is a significant reconciling item)","Explanation"]
[" Net Change in Principal Balance in the GL (i.e. Transactions in the Year)"]
["1a","Remove impacts to GA from prior year RPP Settlement true up process that are booked in current year"]
["1b","Add impacts to GA from current year RPP Settlement true up process that are booked in subsequent year"]
["2a","Remove prior year end unbilled to actual revenue differences"]
["2b","Add current year end unbilled to actual revenue differences"]
["3a","Remove difference between prior year accrual to forecast from long term load transfers"]
["3b","Add difference between current year accrual to forecast from long term load transfers"]
[4,"Remove GA balances pertaining to Class A customers"]
[5,"Significant prior period billing adjustments included in current year GL balance but would not be included in the billing consumption used in the GA Analysis"]
[6,"Differences in GA IESO posted rate and rate charged on IESO invoice"]
[7]
[8]
[9]
[10]
["Note 6","Adjusted Net Change in Principal Balance in the GL",null,{"$f":"SUM(D65:D78)","v":0}]
[null,"Net Change in Expected GA Balance in the Year Per Analysis",null,{"$f":"K59","v":0}]
[null,"Unresolved Difference",null,{"$f":"D79-D80","v":0}]
[null,"Unresolved Difference as % of Expected GA Payments to IESO",null,{"$f":"IF(ISERROR(D81/J59),0,D81/J59)","v":0},{"$f":"IF(AND(D82<0.01,D82>-0.01),\"\",\"Unresolved differences of greater than + or - 1% should be explained\")","v":""}]
[]
[]
["Note 7 ","Summary of GA  (if multiple years requested for disposition)"]
[]
[null,"Year","Annual Net Change in Expected GA Balance from GA Analysis (cell K59)"," Net Change in Principal Balance in the  GL (cell D65)","Reconciling Items (sum of cells D66 to D78)","Adjusted Net Change in Principal Balance in the GL","Unresolved Difference","Payments to IESO (cell J59)","Unresolved Difference as % of Expected GA Payments to IESO"]
[null,null,null,null,null,{"$f":"SUM(D88:E88)","v":0},{"$f":"F88-C88","v":0},null,{"$f":"IF(ISERROR(G88/H88),0,G88/H88)","v":0}]
[null,null,null,null,null,{"$f":"SUM(D89:E89)","v":0},{"$f":"F89-C89","v":0},null,{"$f":"IF(ISERROR(G89/H89),0,G89/H89)","v":0}]
[null,null,null,null,null,{"$f":"SUM(D90:E90)","v":0},{"$f":"F90-C90","v":0},null,{"$f":"IF(ISERROR(G90/H90),0,G90/H90)","v":0}]
[null,null,null,null,null,{"$f":"SUM(D91:E91)","v":0},{"$f":"F91-C91","v":0},null,{"$f":"IF(ISERROR(G91/H91),0,G91/H91)","v":0}]
[null,"Cumulative Balance ",{"$f":"SUM(C88:C91)","v":0},0,0,0,{"$f":"SUM(G88:G91)","v":0},0,"N/A"]
[]
[]
[null,"Additional Notes and Comments"]

{"sheet":"GA 2016","index":3,"n_rows":93,"n_cols":11,"rows_kept":93,"cut":false,"hidden":true,"merged":[[84,9,84,10],[85,9,85,10],[86,9,86,10],[87,9,87,10],[79,9,79,10],[80,9,80,10],[81,9,81,10],[82,9,82,10],[83,9,83,10],[24,1,24,5],[61,7,61,9],[62,7,62,9],[77,3,77,7],[78,3,78,7],[73,8,73,10],[74,9,74,10],[75,9,75,10],[76,9,76,10],[77,9,77,10],[78,9,78,10],[64,1,70,3],[65,5,70,10],[63,1,63,3],[58,6,58,10],[57,6,57,10],[82,3,82,7],[83,3,83,7],[84,3,84,7],[85,3,85,7],[86,3,86,7],[88,3,88,7],[88,9,88,10],[12,1,12,2],[12,4,12,5],[18,1,18,7],[60,7,60,9],[26,1,26,5],[74,0,74,1],[73,3,73,7],[79,3,79,7],[80,3,80,7],[81,3,81,7],[74,3,74,7],[75,3,75,7],[76,3,76,7],[87,3,87,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Note 2","Consumption Data Excluding for Loss Factor (Data to agree with RRR as applicable)"]
[null,"Year",null,2016]
[null,"Total Metered excluding WMP","C = A+B",{"$f":"D15+D16","v":0},"kWh",1]
[null,"RPP ","A",null,"kWh",{"$f":"IFERROR(D15/$D$14,0)","v":0}]
[null,"Non RPP","B = D+E",{"$f":"D17+D18","v":0},"kWh",{"$f":"IFERROR(D16/$D$14,0)","v":0}]
[null,"Non-RPP Class A","D",null,"kWh",{"$f":"IFERROR(D17/$D$14,0)","v":0}]
[null,"Non-RPP Class B*","E",null,"kWh",{"$f":"IFERROR(D18/$D$14,0)","v":0}]
[null,"*Non-RPP Class B consumption reported in this table is not expected to directly agree with the Non-RPP Class B Including Loss Adjusted Billed Consumption in the GA Analysis of Expected Balance table below.  The difference should be equal to the loss factor."]
[]
["Note 3","GA Billing Rate"]
[]
[null,"GA is billed on the "]
[]
[null,"Please confirm that the same GA rate is used to bill all customer classes. If not, please provide further details"]
[]
[null,"Please confirm that the GA Rate used for unbilled revenue is the same as the one used for billed revenue in any paticular month"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Note 4","Analysis of Expected GA Amount"]
[null,"Year",2016]
[null,"Calendar Month","Non-RPP Class B Including Loss Factor Billed Consumption (kWh)","Deduct Previous Month Unbilled Loss Adjusted Consumption (kWh)","Add Current Month Unbilled Loss Adjusted Consumption (kWh)","Non-RPP Class B Including Loss Adjusted Consumption, Adjusted for Unbilled (kWh)","GA Rate Billed  ($/kWh)","$ Consumption at GA Rate Billed","GA Actual Rate Paid ($/kWh)","$ Consumption at Actual Rate Paid","Expected GA Price Variance ($)"]
[null,null,"F","G","H","I = F-G+H","J","K = I*J","L","M = I*L","N=M-K"]
[null,"January",null,null,null,{"$f":"C41-D41+E41","v":0},{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!R4,IF($C$23=\"2nd Estimate\",'GA Rates'!S4,IF($C$23=\"Actual\",'GA Rates'!T4,0)))","v":0},{"$f":"F41*G41","v":0},{"$f":"'GA Rates'!T4","v":9.1789999999999997E-2},{"$f":"F41*I41","v":0},{"$f":"J41-H41","v":0}]
[null,"February",null,null,null,{"$f":"C42-D42+E42","v":0},{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!R5,IF($C$23=\"2nd Estimate\",'GA Rates'!S5,IF($C$23=\"Actual\",'GA Rates'!T5,0)))","v":0},{"$f":"F42*G42","v":0},{"$f":"'GA Rates'!T5","v":9.851E-2},{"$f":"F42*I42","v":0},{"$f":"J42-H42","v":0}]
[null,"March",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!R6,IF($C$23=\"2nd Estimate\",'GA Rates'!S6,IF($C$23=\"Actual\",'GA Rates'!T6,0)))","v":0},0,{"$f":"'GA Rates'!T6","v":0.1061},0,0]
[null,"April",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!R7,IF($C$23=\"2nd Estimate\",'GA Rates'!S7,IF($C$23=\"Actual\",'GA Rates'!T7,0)))","v":0},0,{"$f":"'GA Rates'!T7","v":0.11132},0,0]
[null,"May",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!R8,IF($C$23=\"2nd Estimate\",'GA Rates'!S8,IF($C$23=\"Actual\",'GA Rates'!T8,0)))","v":0},0,{"$f":"'GA Rates'!T8","v":0.10749},0,0]
[null,"June",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!R9,IF($C$23=\"2nd Estimate\",'GA Rates'!S9,IF($C$23=\"Actual\",'GA Rates'!T9,0)))","v":0},0,{"$f":"'GA Rates'!T9","v":9.5449999999999993E-2},0,0]
[null,"July",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!R10,IF($C$23=\"2nd Estimate\",'GA Rates'!S10,IF($C$23=\"Actual\",'GA Rates'!T10,0)))","v":0},0,{"$f":"'GA Rates'!T10","v":8.3059999999999995E-2},0,0]
[null,"August",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!R11,IF($C$23=\"2nd Estimate\",'GA Rates'!S11,IF($C$23=\"Actual\",'GA Rates'!T11,0)))","v":0},0,{"$f":"'GA Rates'!T11","v":7.1029999999999996E-2},0,0]
[null,"September",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!R12,IF($C$23=\"2nd Estimate\",'GA Rates'!S12,IF($C$23=\"Actual\",'GA Rates'!T12,0)))","v":0},0,{"$f":"'GA Rates'!T12","v":9.5310000000000006E-2},0,0]
[null,"October",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!R13,IF($C$23=\"2nd Estimate\",'GA Rates'!S13,IF($C$23=\"Actual\",'GA Rates'!T13,0)))","v":0},0,{"$f":"'GA Rates'!T13","v":0.11226},0,0]
[null,"November ",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!R14,IF($C$23=\"2nd Estimate\",'GA Rates'!S14,IF($C$23=\"Actual\",'GA Rates'!T14,0)))","v":0},0,{"$f":"'GA Rates'!T14","v":0.11108999999999999},0,0]
[null,"December",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!R15,IF($C$23=\"2nd Estimate\",'GA Rates'!S15,IF($C$23=\"Actual\",'GA Rates'!T15,0)))","v":0},0,{"$f":"'GA Rates'!T15","v":8.7080000000000005E-2},0,0]
[null,"Net Change in Expected GA Balance in the Year (i.e. Transactions in the Year)",{"$f":"SUM(C41:C52)","v":0},{"$f":"SUM(D41:D52)","v":0},{"$f":"SUM(E41:E52)","v":0},{"$f":"SUM(F41:F52)","v":0},null,{"$f":"SUM(H41:H52)","v":0},null,{"$f":"SUM(J41:J52)","v":0},{"$f":"SUM(K41:K52)","v":0}]
[]
[null,null,null,null,null,null,"Annual Non-RPP Class B Wholesale kWh *","Annual Non-RPP Class B Retail billed kWh","Annual Unaccounted for Energy Loss kWh","Weighted Average GA Actual Rate Paid ($/kWh)**","Expected GA Volume Variance ($)"]
[null,null,null,null,null,null,"O","P","Q=O-P","R","P= Q*R"]
[null,null,null,null,null,null,null,{"$f":"F53","v":0},{"$f":"G57-H57","v":0},null,{"$f":"I57*J57","v":0}]
[null,null,null,null,null,null,"*Equal to (AQEW - Class A + embedded generation kWh)*(Non-RPP Class B retail kwh/Total retail Class B kWh)"]
[null,null,null,null,null,null,"**Equal to annual Non-RPP Class B $ GA paid (i.e. non-RPP portion of CT 148 on IESO invoice) divided by Non-RPP Class B Wholesale kWh (as quantified in column O of the table above)"]
[null,null,null,null,null,null,null,null,null,"Total Expected GA Variance",{"$f":"K53+K57","v":0}]
[null,null,null,null,null,null,null,"Calculated Loss Factor",null,null,{"$f":"IFERROR(F53/D18,0)","v":0}]
[null,null,null,null,null,null,null,"Most Recent Approved Loss Factor for Secondary Metered Customer < 5,000kW"]
[null,null,null,null,null,null,null,"Difference",null,null,{"$f":"K61-K62","v":0}]
[null,"a) Please provide an explanation in the text box below if columns G and H for unbilled consumption are not used in the table above."]
[null,null,null,null,null,"b) Please provide an explanation in the text box below if the difference in loss factor is greater than 1%"]
[]
[]
[]
[]
[]
[]
["Note 5 ","Reconciling Items "]
[]
[null," Item","Amount","Explanation",null,null,null,null,"Principal Adjustments"]
[" Net Change in Principal Balance in the GL (i.e. Transactions in the Year)",null,null,null,null,null,null,null,"Principal Adjustment on DVA Continuity Schedule","If \"no\", please provide an explanation"]
["1a","CT 148 True-up of GA Charges based on Actual Non-RPP Volumes - prior year"]
["1b","CT 148 True-up of GA Charges based on Actual Non-RPP Volumes - current year"]
["2a","Remove prior year end unbilled to actual revenue differences"]
["2b","Add current year end unbilled to actual revenue differences"]
["3a","Remove difference between prior year accrual/forecast to actual from long term load transfers"]
["3b","Add difference between current year accrual/forecast to actual from long term load transfers"]
[4,"Remove GA balances pertaining to Class A customers"]
["5a","Significant prior period billing adjustments recorded in current year"]
["5b","Significant current period billing adjustments recorded in other year(s)"]
[6,"Differences in GA IESO posted rate and rate charged on IESO invoice"]
[7]
[8]
[9]
[10]
["Note 6","Adjusted Net Change in Principal Balance in the GL",{"$f":"SUM(C75:C89)","v":0}]
[null,"Net Change in Expected GA Balance in the Year Per Analysis",{"$f":"K60","v":0}]
[null,"Unresolved Difference",{"$f":"C90-C91","v":0}]
[null,"Unresolved Difference as % of Expected GA Payments to IESO",{"$f":"IF(ISERROR(C92/J53),0,C92/J53)","v":0},{"$f":"IF(AND(C93<0.01,C93>-0.01),\"\",\"Unresolved differences of greater than + or - 1% should be explained\")","v":""}]

{"sheet":"GA 2015","index":4,"n_rows":93,"n_cols":11,"rows_kept":93,"cut":false,"hidden":true,"merged":[[88,3,88,7],[88,9,88,10],[85,3,85,7],[85,9,85,10],[86,3,86,7],[86,9,86,10],[87,3,87,7],[87,9,87,10],[82,3,82,7],[82,9,82,10],[83,3,83,7],[83,9,83,10],[84,3,84,7],[84,9,84,10],[79,3,79,7],[79,9,79,10],[80,3,80,7],[80,9,80,10],[81,3,81,7],[81,9,81,10],[76,3,76,7],[76,9,76,10],[77,3,77,7],[77,9,77,10],[78,3,78,7],[78,9,78,10],[75,3,75,7],[75,9,75,10],[58,6,58,10],[60,7,60,9],[61,7,61,9],[62,7,62,9],[63,1,63,3],[64,1,70,3],[65,5,70,10],[73,3,73,7],[73,8,73,10],[74,0,74,1],[74,3,74,7],[74,9,74,10],[57,6,57,10],[12,1,12,2],[12,4,12,5],[18,1,18,7],[24,1,24,5],[26,1,26,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Note 2","Consumption Data Excluding for Loss Factor (Data to agree with RRR as applicable)"]
[null,"Year",null,2015]
[null,"Total Metered excluding WMP","C = A+B",null,"kWh",1]
[null,"RPP ","A",null,"kWh",{"$f":"IFERROR(D15/$D$14,0)","v":0}]
[null,"Non RPP","B = D+E",null,"kWh",{"$f":"IFERROR(D16/$D$14,0)","v":0}]
[null,"Non-RPP Class A","D",null,"kWh",{"$f":"IFERROR(D17/$D$14,0)","v":0}]
[null,"Non-RPP Class B*","E",null,"kWh",{"$f":"IFERROR(D18/$D$14,0)","v":0}]
[null,"*Non-RPP Class B consumption reported in this table is not expected to directly agree with the Non-RPP Class B Including Loss Adjusted Billed Consumption in the GA Analysis of Expected Balance table below.  The difference should be equal to the loss factor."]
[]
["Note 3","GA Billing Rate"]
[]
[null,"GA is billed on the "]
[]
[null,"Please confirm that the same GA rate is used to bill all customer classes. If not, please provide further details"]
[]
[null,"Please confirm that the GA Rate used for unbilled revenue is the same as the one used for billed revenue in any paticular month"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Note 4","Analysis of Expected GA Amount"]
[null,"Year",2017]
[null,"Calendar Month","Non-RPP Class B Including Loss Factor Billed Consumption (kWh)","Deduct Previous Month Unbilled Loss Adjusted Consumption (kWh)","Add Current Month Unbilled Loss Adjusted Consumption (kWh)","Non-RPP Class B Including Loss Adjusted Consumption, Adjusted for Unbilled (kWh)","GA Rate Billed  ($/kWh)","$ Consumption at GA Rate Billed","GA Actual Rate Paid ($/kWh)","$ Consumption at Actual Rate Paid","Expected GA Price Variance ($)"]
[null,null,"F","G","H","I = F-G+H","J","K = I*J","L","M = I*L","N=M-K"]
[null,"January",null,null,null,{"$f":"C41-D41+E41","v":0},{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!V4,IF($C$23=\"2nd Estimate\",'GA Rates'!W4,IF($C$23=\"Actual\",'GA Rates'!X4,0)))","v":0},{"$f":"F41*G41","v":0},{"$f":"'GA Rates'!X4","v":5.0680000000000003E-2},{"$f":"F41*I41","v":0},{"$f":"J41-H41","v":0}]
[null,"February",null,null,null,{"$f":"C42-D42+E42","v":0},{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!V5,IF($C$23=\"2nd Estimate\",'GA Rates'!W5,IF($C$23=\"Actual\",'GA Rates'!X5,0)))","v":0},{"$f":"F42*G42","v":0},{"$f":"'GA Rates'!X5","v":3.9609999999999999E-2},{"$f":"F42*I42","v":0},{"$f":"J42-H42","v":0}]
[null,"March",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!V6,IF($C$23=\"2nd Estimate\",'GA Rates'!W6,IF($C$23=\"Actual\",'GA Rates'!X6,0)))","v":0},0,{"$f":"'GA Rates'!X6","v":6.2899999999999998E-2},0,0]
[null,"April",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!V7,IF($C$23=\"2nd Estimate\",'GA Rates'!W7,IF($C$23=\"Actual\",'GA Rates'!X7,0)))","v":0},0,{"$f":"'GA Rates'!X7","v":9.5590000000000008E-2},0,0]
[null,"May",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!V8,IF($C$23=\"2nd Estimate\",'GA Rates'!W8,IF($C$23=\"Actual\",'GA Rates'!X8,0)))","v":0},0,{"$f":"'GA Rates'!X8","v":9.6680000000000002E-2},0,0]
[null,"June",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!V9,IF($C$23=\"2nd Estimate\",'GA Rates'!W9,IF($C$23=\"Actual\",'GA Rates'!X9,0)))","v":0},0,{"$f":"'GA Rates'!X9","v":9.5400000000000013E-2},0,0]
[null,"July",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!V10,IF($C$23=\"2nd Estimate\",'GA Rates'!W10,IF($C$23=\"Actual\",'GA Rates'!X10,0)))","v":0},0,{"$f":"'GA Rates'!X10","v":7.8829999999999997E-2},0,0]
[null,"August",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!V11,IF($C$23=\"2nd Estimate\",'GA Rates'!W11,IF($C$23=\"Actual\",'GA Rates'!X11,0)))","v":0},0,{"$f":"'GA Rates'!X11","v":8.0099999999999991E-2},0,0]
[null,"September",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!V12,IF($C$23=\"2nd Estimate\",'GA Rates'!W12,IF($C$23=\"Actual\",'GA Rates'!X12,0)))","v":0},0,{"$f":"'GA Rates'!X12","v":6.7030000000000006E-2},0,0]
[null,"October",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!V13,IF($C$23=\"2nd Estimate\",'GA Rates'!W13,IF($C$23=\"Actual\",'GA Rates'!X13,0)))","v":0},0,{"$f":"'GA Rates'!X13","v":7.5439999999999993E-2},0,0]
[null,"November ",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!V14,IF($C$23=\"2nd Estimate\",'GA Rates'!W14,IF($C$23=\"Actual\",'GA Rates'!X14,0)))","v":0},0,{"$f":"'GA Rates'!X14","v":0.11320000000000001},0,0]
[null,"December",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!V15,IF($C$23=\"2nd Estimate\",'GA Rates'!W15,IF($C$23=\"Actual\",'GA Rates'!X15,0)))","v":0},0,{"$f":"'GA Rates'!X15","v":9.4709999999999989E-2},0,0]
[null,"Net Change in Expected GA Balance in the Year (i.e. Transactions in the Year)",{"$f":"SUM(C41:C52)","v":0},{"$f":"SUM(D41:D52)","v":0},{"$f":"SUM(E41:E52)","v":0},{"$f":"SUM(F41:F52)","v":0},null,{"$f":"SUM(H41:H52)","v":0},null,{"$f":"SUM(J41:J52)","v":0},{"$f":"SUM(K41:K52)","v":0}]
[]
[null,null,null,null,null,null,"Annual Non-RPP Class B Wholesale kWh *","Annual Non-RPP Class B Retail billed kWh","Annual Unaccounted for Energy Loss kWh","Weighted Average GA Actual Rate Paid ($/kWh)**","Expected GA Volume Variance ($)"]
[null,null,null,null,null,null,"O","P","Q=O-P","R","P= Q*R"]
[null,null,null,null,null,null,null,{"$f":"F53","v":0},{"$f":"G57-H57","v":0},null,{"$f":"I57*J57","v":0}]
[null,null,null,null,null,null,"*Equal to (AQEW - Class A + embedded generation kWh)*(Non-RPP Class B retail kwh/Total retail Class B kWh)"]
[null,null,null,null,null,null,"**Equal to annual Non-RPP Class B $ GA paid (i.e. non-RPP portion of CT 148 on IESO invoice) divided by Non-RPP Class B Wholesale kWh (as quantified in column O of the table above)"]
[null,null,null,null,null,null,null,null,null,"Total Expected GA Variance",{"$f":"K53+K57","v":0}]
[null,null,null,null,null,null,null,"Calculated Loss Factor",null,null,{"$f":"IFERROR(F53/D18,0)","v":0}]
[null,null,null,null,null,null,null,"Most Recent Approved Loss Factor for Secondary Metered Customer < 5,000kW"]
[null,null,null,null,null,null,null,"Difference",null,null,{"$f":"K61-K62","v":0}]
[null,"a) Please provide an explanation in the text box below if columns G and H for unbilled consumption are not used in the table above."]
[null,null,null,null,null,"b) Please provide an explanation in the text box below if the difference in loss factor is greater than 1%"]
[]
[]
[]
[]
[]
[]
["Note 5 ","Reconciling Items "]
[]
[null," Item","Amount","Explanation",null,null,null,null,"Principal Adjustments"]
[" Net Change in Principal Balance in the GL (i.e. Transactions in the Year)",null,null,null,null,null,null,null,"Principal Adjustment on DVA Continuity Schedule","If \"no\", please provide an explanation"]
["1a","CT 148 True-up of GA Charges based on Actual Non-RPP Volumes - prior year"]
["1b","CT 148 True-up of GA Charges based on Actual Non-RPP Volumes - current year"]
["2a","Remove prior year end unbilled to actual revenue differences"]
["2b","Add current year end unbilled to actual revenue differences"]
["3a","Remove difference between prior year accrual/forecast to actual from long term load transfers"]
["3b","Add difference between current year accrual/forecast to actual from long term load transfers"]
[4,"Remove GA balances pertaining to Class A customers"]
["5a","Significant prior period billing adjustments recorded in current year"]
["5b","Significant current period billing adjustments recorded in other year(s)"]
[6,"Differences in GA IESO posted rate and rate charged on IESO invoice"]
[7]
[8]
[9]
[10]
["Note 6","Adjusted Net Change in Principal Balance in the GL",{"$f":"SUM(C75:C89)","v":0}]
[null,"Net Change in Expected GA Balance in the Year Per Analysis",{"$f":"K60","v":0}]
[null,"Unresolved Difference",{"$f":"C90-C91","v":0}]
[null,"Unresolved Difference as % of Expected GA Payments to IESO",{"$f":"IF(ISERROR(C92/J53),0,C92/J53)","v":0},{"$f":"IF(AND(C93<0.01,C93>-0.01),\"\",\"Unresolved differences of greater than + or - 1% should be explained\")","v":""}]

{"sheet":"GA 2019","index":5,"n_rows":93,"n_cols":11,"rows_kept":93,"cut":false,"hidden":true,"merged":[[86,3,86,7],[86,9,86,10],[87,3,87,7],[87,9,87,10],[88,3,88,7],[88,9,88,10],[83,3,83,7],[83,9,83,10],[84,3,84,7],[84,9,84,10],[85,3,85,7],[85,9,85,10],[80,3,80,7],[80,9,80,10],[81,3,81,7],[81,9,81,10],[82,3,82,7],[82,9,82,10],[77,3,77,7],[77,9,77,10],[78,3,78,7],[78,9,78,10],[79,3,79,7],[79,9,79,10],[76,3,76,7],[76,9,76,10],[61,7,61,9],[62,7,62,9],[64,1,70,3],[65,5,70,10],[73,3,73,7],[73,8,73,10],[74,0,74,1],[74,3,74,7],[74,9,74,10],[75,3,75,7],[75,9,75,10],[63,1,63,3],[60,7,60,9],[12,1,12,2],[12,4,12,5],[18,1,18,7],[24,1,24,5],[26,1,26,5],[58,6,58,10],[57,6,57,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Note 2","Consumption Data Excluding for Loss Factor (Data to agree with RRR as applicable)"]
[null,"Year",null,2019]
[null,"Total Metered excluding WMP","C = A+B",{"$f":"VLOOKUP('1. Information Sheet'!$C$17,RRR_2019!$B$4:$U$68,19,FALSE)","v":{"$error":"#N/A"}},"kWh",1]
[null,"RPP ","A",{"$f":"VLOOKUP('1. Information Sheet'!$C$17,RRR_2019!$B$4:$U$68,7,FALSE)","v":{"$error":"#N/A"}},"kWh",{"$f":"IFERROR(D15/$D$14,0)","v":0}]
[null,"Non RPP","B = D+E",{"$f":"VLOOKUP('1. Information Sheet'!$C$17,RRR_2019!$B$4:$U$68,20,FALSE)","v":{"$error":"#N/A"}},"kWh",{"$f":"IFERROR(D16/$D$14,0)","v":0}]
[null,"Non-RPP Class A","D",{"$f":"VLOOKUP('1. Information Sheet'!$C$17,RRR_2019!$B$4:$U$68,13,FALSE)","v":{"$error":"#N/A"}},"kWh",{"$f":"IFERROR(D17/$D$14,0)","v":0}]
[null,"Non-RPP Class B*","E",{"$f":"D16-D17","v":{"$error":"#N/A"}},"kWh",{"$f":"IFERROR(D18/$D$14,0)","v":0}]
[null,"*Non-RPP Class B consumption reported in this table is not expected to directly agree with the Non-RPP Class B Including Loss Adjusted Billed Consumption in the GA Analysis of Expected Balance table below.  The difference should be equal to the loss factor."]
[]
["Note 3","GA Billing Rate"]
[]
[null,"GA is billed on the "]
[]
[null,"Please confirm that the same GA rate is used to bill all customer classes. If not, please provide further details"]
[]
[null,"Please confirm that the GA Rate used for unbilled revenue is the same as the one used for billed revenue in any paticular month"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Note 4","Analysis of Expected GA Amount"]
[null,"Year",2019]
[null,"Calendar Month","Non-RPP Class B Including Loss Factor Billed Consumption (kWh)","Deduct Previous Month Unbilled Loss Adjusted Consumption (kWh)","Add Current Month Unbilled Loss Adjusted Consumption (kWh)","Non-RPP Class B Including Loss Adjusted Consumption, Adjusted for Unbilled (kWh)","GA Rate Billed  ($/kWh)","$ Consumption at GA Rate Billed","GA Actual Rate Paid ($/kWh)","$ Consumption at Actual Rate Paid","Expected GA Price Variance ($)"]
[null,null,"F","G","H","I = F-G+H","J","K = I*J","L","M = I*L","N=M-K"]
[null,"January",null,null,null,{"$f":"C41-D41+E41","v":0},{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!F4,IF($C$23=\"2nd Estimate\",'GA Rates'!G4,IF($C$23=\"Actual\",'GA Rates'!H4,0)))","v":0},{"$f":"F41*G41","v":0},{"$f":"'GA Rates'!H4","v":8.0920000000000006E-2},{"$f":"F41*I41","v":0},{"$f":"J41-H41","v":0}]
[null,"February",null,null,null,{"$f":"C42-D42+E42","v":0},{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!F5,IF($C$23=\"2nd Estimate\",'GA Rates'!G5,IF($C$23=\"Actual\",'GA Rates'!H5,0)))","v":0},{"$f":"F42*G42","v":0},{"$f":"'GA Rates'!H5","v":8.8120000000000004E-2},{"$f":"F42*I42","v":0},{"$f":"J42-H42","v":0}]
[null,"March",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!F6,IF($C$23=\"2nd Estimate\",'GA Rates'!G6,IF($C$23=\"Actual\",'GA Rates'!H6,0)))","v":0},0,{"$f":"'GA Rates'!H6","v":8.0409999999999995E-2},0,0]
[null,"April",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!F7,IF($C$23=\"2nd Estimate\",'GA Rates'!G7,IF($C$23=\"Actual\",'GA Rates'!H7,0)))","v":0},0,{"$f":"'GA Rates'!H7","v":0.12333},0,0]
[null,"May",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!F8,IF($C$23=\"2nd Estimate\",'GA Rates'!G8,IF($C$23=\"Actual\",'GA Rates'!H8,0)))","v":0},0,{"$f":"'GA Rates'!H8","v":0.12604000000000001},0,0]
[null,"June",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!F9,IF($C$23=\"2nd Estimate\",'GA Rates'!G9,IF($C$23=\"Actual\",'GA Rates'!H9,0)))","v":0},0,{"$f":"'GA Rates'!H9","v":0.13728000000000001},0,0]
[null,"July",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!F10,IF($C$23=\"2nd Estimate\",'GA Rates'!G10,IF($C$23=\"Actual\",'GA Rates'!H10,0)))","v":0},0,{"$f":"'GA Rates'!H10","v":9.6450000000000008E-2},0,0]
[null,"August",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!F11,IF($C$23=\"2nd Estimate\",'GA Rates'!G11,IF($C$23=\"Actual\",'GA Rates'!H11,0)))","v":0},0,{"$f":"'GA Rates'!H11","v":0.12606999999999999},0,0]
[null,"September",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!F12,IF($C$23=\"2nd Estimate\",'GA Rates'!G12,IF($C$23=\"Actual\",'GA Rates'!H12,0)))","v":0},0,{"$f":"'GA Rates'!H12","v":0.12262999999999999},0,0]
[null,"October",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!F13,IF($C$23=\"2nd Estimate\",'GA Rates'!G13,IF($C$23=\"Actual\",'GA Rates'!H13,0)))","v":0},0,{"$f":"'GA Rates'!H13","v":0.1368},0,0]
[null,"November ",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!F14,IF($C$23=\"2nd Estimate\",'GA Rates'!G14,IF($C$23=\"Actual\",'GA Rates'!H14,0)))","v":0},0,{"$f":"'GA Rates'!H14","v":9.9530000000000007E-2},0,0]
[null,"December",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!F15,IF($C$23=\"2nd Estimate\",'GA Rates'!G15,IF($C$23=\"Actual\",'GA Rates'!H15,0)))","v":0},0,{"$f":"'GA Rates'!H15","v":9.3209999999999987E-2},0,0]
[null,"Net Change in Expected GA Balance in the Year (i.e. Transactions in the Year)",{"$f":"SUM(C41:C52)","v":0},{"$f":"SUM(D41:D52)","v":0},{"$f":"SUM(E41:E52)","v":0},{"$f":"SUM(F41:F52)","v":0},null,{"$f":"SUM(H41:H52)","v":0},null,{"$f":"SUM(J41:J52)","v":0},{"$f":"SUM(K41:K52)","v":0}]
[]
[null,null,null,null,null,null,"Annual Non-RPP Class B Wholesale kWh *","Annual Non-RPP Class B Retail billed kWh","Annual Unaccounted for Energy Loss kWh","Weighted Average GA Actual Rate Paid ($/kWh)**","Expected GA Volume Variance ($)"]
[null,null,null,null,null,null,"O","P","Q=O-P","R","P= Q*R"]
[null,null,null,null,null,null,null,{"$f":"F53","v":0},{"$f":"G57-H57","v":0},null,{"$f":"I57*J57","v":0}]
[null,null,null,null,null,null,"*Equal to (AQEW - Class A + embedded generation kWh)*(Non-RPP Class B retail kwh/Total retail Class B kWh)"]
[null,null,null,null,null,null,"**Equal to annual Non-RPP Class B $ GA paid (i.e. non-RPP portion of CT 148 on IESO invoice) divided by Non-RPP Class B Wholesale kWh (as quantified in column O in the table above)"]
[null,null,null,null,null,null,null,null,null,"Total Expected GA Variance",{"$f":"K53+K57","v":0}]
[null,null,null,null,null,null,null,"Calculated Loss Factor",null,null,{"$f":"IFERROR(F53/D18,0)","v":0}]
[null,null,null,null,null,null,null,"Most Recent Approved Loss Factor for Secondary Metered Customer < 5,000kW"]
[null,null,null,null,null,null,null,"Difference",null,null,{"$f":"K61-K62","v":0}]
[null,"a) Please provide an explanation in the text box below if columns G and H for unbilled consumption are not used in the table above."]
[null,null,null,null,null,"b) Please provide an explanation in the text box below if the difference in loss factor is greater than 1%"]
[]
[]
[]
[]
[]
[]
["Note 5 ","Reconciling Items "]
[]
[null," Item","Amount","Explanation",null,null,null,null,"Principal Adjustments"]
[" Net Change in Principal Balance in the GL (i.e. Transactions in the Year)",null,null,null,null,null,null,null,"Principal Adjustment on DVA Continuity Schedule","If \"no\", please provide an explanation"]
["1a","CT 148 True-up of GA Charges based on Actual Non-RPP Volumes - prior year"]
["1b","CT 148 True-up of GA Charges based on Actual Non-RPP Volumes - current year"]
["2a","Remove prior year end unbilled to actual revenue differences"]
["2b","Add current year end unbilled to actual revenue differences"]
["3a","Remove difference between prior year accrual/unbilled to actual from load transfers"]
["3b","Add difference between current year accrual/unbilled to actual from load transfers"]
["4a","Significant prior period billing adjustments recorded in current year"]
["4b","Significant current period billing adjustments recorded in other year(s)"]
[5,"CT 2148 for prior period corrections"]
[6]
[7]
[8]
[9]
[10]
["Note 6","Adjusted Net Change in Principal Balance in the GL",{"$f":"SUM(C75:C89)","v":0}]
[null,"Net Change in Expected GA Balance in the Year Per Analysis",{"$f":"K60","v":0}]
[null,"Unresolved Difference",{"$f":"C90-C91","v":0}]
[null,"Unresolved Difference as % of Expected GA Payments to IESO",{"$f":"IF(ISERROR(C92/J53),0,C92/J53)","v":0},{"$f":"IF(AND(C93<0.01,C93>-0.01),\"\",\"Unresolved differences of greater than + or - 1% should be explained\")","v":""}]

{"sheet":"GA 2020","index":6,"n_rows":93,"n_cols":11,"rows_kept":93,"cut":false,"hidden":true,"merged":[[86,3,86,7],[86,9,86,10],[87,3,87,7],[87,9,87,10],[88,3,88,7],[88,9,88,10],[83,3,83,7],[83,9,83,10],[84,3,84,7],[84,9,84,10],[85,3,85,7],[85,9,85,10],[80,3,80,7],[80,9,80,10],[81,3,81,7],[81,9,81,10],[82,3,82,7],[82,9,82,10],[77,3,77,7],[77,9,77,10],[78,3,78,7],[78,9,78,10],[79,3,79,7],[79,9,79,10],[76,3,76,7],[76,9,76,10],[61,7,61,9],[62,7,62,9],[64,1,70,3],[65,5,70,10],[73,3,73,7],[73,8,73,10],[74,0,74,1],[74,3,74,7],[74,9,74,10],[75,3,75,7],[75,9,75,10],[63,1,63,3],[60,7,60,9],[12,1,12,2],[12,4,12,5],[18,1,18,7],[58,6,58,10],[57,6,57,10],[24,1,24,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Note 2","Consumption Data Excluding for Loss Factor (Data to agree with RRR as applicable)"]
[null,"Year",null,2020]
[null,"Total Metered excluding WMP","C = A+B",{"$f":"VLOOKUP('1. Information Sheet'!$C$17,RRR_2020!$B$4:$U$68,19,FALSE)","v":{"$error":"#N/A"}},"kWh",1]
[null,"RPP ","A",{"$f":"VLOOKUP('1. Information Sheet'!$C$17,RRR_2020!$B$4:$U$68,7,FALSE)","v":{"$error":"#N/A"}},"kWh",{"$f":"IFERROR(D15/$D$14,0)","v":0}]
[null,"Non RPP","B = D+E",{"$f":"VLOOKUP('1. Information Sheet'!$C$17,RRR_2020!$B$4:$U$68,20,FALSE)","v":{"$error":"#N/A"}},"kWh",{"$f":"IFERROR(D16/$D$14,0)","v":0}]
[null,"Non-RPP Class A","D",{"$f":"VLOOKUP('1. Information Sheet'!$C$17,RRR_2020!$B$4:$U$68,13,FALSE)","v":{"$error":"#N/A"}},"kWh",{"$f":"IFERROR(D17/$D$14,0)","v":0}]
[null,"Non-RPP Class B*","E",{"$f":"D16-D17","v":{"$error":"#N/A"}},"kWh",{"$f":"IFERROR(D18/$D$14,0)","v":0}]
[null,"*Non-RPP Class B consumption reported in this table is not expected to directly agree with the Non-RPP Class B Including Loss Adjusted Billed Consumption in the GA Analysis of Expected Balance table below.  The difference should be equal to the loss factor."]
[]
["Note 3","GA Billing Rate"]
[]
[null,"GA is billed on the ",null,"Note that the GA actual rates for April to June 2020 are based on the unadjusted GA rates, without the impacts of the GA deferral."]
[]
[null,"Please confirm that the adjusted GA rate was used to bill customers from April to June 2020. \nFor the months of April to June 2020, the IESO provided adjusted GA rates, which reflected the deferral of a portion of the GA as per the May 1, 2020 Emergency Order, and unadjusted GA rates which did not consider the GA deferral."]
[]
[null,"Please confirm that the same GA rate is used to bill all customer classes. If not, please provide further details"]
[]
[null,"Please confirm that the GA Rate used for unbilled revenue is the same as the one used for billed revenue in any paticular month"]
[]
[]
[]
[]
[]
[]
[]
["Note 4","Analysis of Expected GA Amount"]
[null,"Year",2020]
[null,"Calendar Month","Non-RPP Class B Including Loss Factor Billed Consumption (kWh)","Deduct Previous Month Unbilled Loss Adjusted Consumption (kWh)","Add Current Month Unbilled Loss Adjusted Consumption (kWh)","Non-RPP Class B Including Loss Adjusted Consumption, Adjusted for Unbilled (kWh)","GA Rate Billed  ($/kWh)","$ Consumption at GA Rate Billed","GA Actual Rate Paid ($/kWh)","$ Consumption at Actual Rate Paid","Expected GA Price Variance ($)"]
[null,null,"F","G","H","I = F-G+H","J","K = I*J","L","M = I*L","N=M-K"]
[null,"January",null,null,null,{"$f":"C41-D41+E41","v":0},{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!B4,IF($C$23=\"2nd Estimate\",'GA Rates'!C4,IF($C$23=\"Actual\",'GA Rates'!D4,0)))","v":0},{"$f":"F41*G41","v":0},{"$f":"'GA Rates'!D4","v":0.10231999999999999},{"$f":"F41*I41","v":0},{"$f":"J41-H41","v":0}]
[null,"February",null,null,null,{"$f":"C42-D42+E42","v":0},{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!B5,IF($C$23=\"2nd Estimate\",'GA Rates'!C5,IF($C$23=\"Actual\",'GA Rates'!D5,0)))","v":0},{"$f":"F42*G42","v":0},{"$f":"'GA Rates'!D5","v":0.11331000000000001},{"$f":"F42*I42","v":0},{"$f":"J42-H42","v":0}]
[null,"March",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!B6,IF($C$23=\"2nd Estimate\",'GA Rates'!C6,IF($C$23=\"Actual\",'GA Rates'!D6,0)))","v":0},0,{"$f":"'GA Rates'!D6","v":0.11942},0,0]
[null,"April",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!B7,IF($C$23=\"2nd Estimate\",'GA Rates'!C7,IF($C$23=\"Actual\",'GA Rates'!D7,0)))","v":0},0,{"$f":"'GA Rates'!D7","v":0.115},0,0]
[null,"May",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!B8,IF($C$23=\"2nd Estimate\",'GA Rates'!C8,IF($C$23=\"Actual\",'GA Rates'!D8,0)))","v":0},0,{"$f":"'GA Rates'!D8","v":0.115},0,0]
[null,"June",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!B9,IF($C$23=\"2nd Estimate\",'GA Rates'!C9,IF($C$23=\"Actual\",'GA Rates'!D9,0)))","v":0},0,{"$f":"'GA Rates'!D9","v":0.115},0,0]
[null,"July",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!B10,IF($C$23=\"2nd Estimate\",'GA Rates'!C10,IF($C$23=\"Actual\",'GA Rates'!D10,0)))","v":0},0,{"$f":"'GA Rates'!D10","v":9.9019999999999997E-2},0,0]
[null,"August",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!B11,IF($C$23=\"2nd Estimate\",'GA Rates'!C11,IF($C$23=\"Actual\",'GA Rates'!D11,0)))","v":0},0,{"$f":"'GA Rates'!D11","v":0.10348},0,0]
[null,"September",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!B12,IF($C$23=\"2nd Estimate\",'GA Rates'!C12,IF($C$23=\"Actual\",'GA Rates'!D12,0)))","v":0},0,{"$f":"'GA Rates'!D12","v":0.12176000000000001},0,0]
[null,"October",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!B13,IF($C$23=\"2nd Estimate\",'GA Rates'!C13,IF($C$23=\"Actual\",'GA Rates'!D13,0)))","v":0},0,{"$f":"'GA Rates'!D13","v":0.12806000000000001},0,0]
[null,"November ",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!B14,IF($C$23=\"2nd Estimate\",'GA Rates'!C14,IF($C$23=\"Actual\",'GA Rates'!D14,0)))","v":0},0,{"$f":"'GA Rates'!D14","v":0.11705},0,0]
[null,"December",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!B15,IF($C$23=\"2nd Estimate\",'GA Rates'!C15,IF($C$23=\"Actual\",'GA Rates'!D15,0)))","v":0},0,{"$f":"'GA Rates'!D15","v":0.10557999999999999},0,0]
[null,"Net Change in Expected GA Balance in the Year (i.e. Transactions in the Year)",{"$f":"SUM(C41:C52)","v":0},{"$f":"SUM(D41:D52)","v":0},{"$f":"SUM(E41:E52)","v":0},{"$f":"SUM(F41:F52)","v":0},null,{"$f":"SUM(H41:H52)","v":0},null,{"$f":"SUM(J41:J52)","v":0},{"$f":"SUM(K41:K52)","v":0}]
[]
[null,null,null,null,null,null,"Annual Non-RPP Class B Wholesale kWh *","Annual Non-RPP Class B Retail billed kWh**","Annual Unaccounted for Energy Loss kWh","Weighted Average GA Actual Rate Paid ($/kWh)***","Expected GA Volume Variance ($)"]
[null,null,null,null,null,null,"O","P","Q=O-P","R","P= Q*R"]
[null,null,null,null,null,null,null,null,{"$f":"G57-H57","v":0},null,{"$f":"I57*J57","v":0}]
[null,null,null,null,null,null,"*Equal to (AQEW - Class A + embedded generation kWh)*(Non-RPP Class B retail kwh/Total retail Class B kWh). Note that if a reconciling item for #5 Impacts from GA deferral is quantified, then the the data for April to June 2020 should be excluded as the line loss volume variance would be reflected in the reconciling item. \n**Should equal to the total Non-RPP Class B Including Loss Adjusted Consmption, Adjusted for Unbilled (i.e. cell F53), unless a reconciling item for #5 Impacts from GA deferral is quantified. If the reconciling item is quantified, then the data from April to June 2020 should be excluded (i.e. cell F53 minus F44 to F46)."]
[null,null,null,null,null,null,"***Equal to annual Non-RPP Class B $ GA paid (i.e. non-RPP portion of CT 148 on IESO invoice) divided by Non-RPP Class B Wholesale kWh (as quantified in column O in the table above). Note if a reconciling item for #5 Impacts from GA deferral is quantified, then the data for April to June 2020 should be excluded as the line loss volume variance would be reflected in the reconciling item."]
[null,null,null,null,null,null,null,null,null,"Total Expected GA Variance",{"$f":"K53+K57","v":0}]
[null,null,null,null,null,null,null,"Calculated Loss Factor",null,null,{"$f":"IFERROR(F53/D18,0)","v":0}]
[null,null,null,null,null,null,null,"Most Recent Approved Loss Factor for Secondary Metered Customer < 5,000kW"]
[null,null,null,null,null,null,null,"Difference",null,null,{"$f":"K61-K62","v":0}]
[null,"a) Please provide an explanation in the text box below if columns G and H for unbilled consumption are not used in the table above."]
[null,null,null,null,null,"b) Please provide an explanation in the text box below if the difference in loss factor is greater than 1%"]
[]
[]
[]
[]
[]
[]
["Note 5 ","Reconciling Items "]
[]
[null," Item","Amount","Explanation",null,null,null,null,"Principal Adjustments"]
[" Net Change in Principal Balance in the GL (i.e. Transactions in the Year)",null,null,null,null,null,null,null,"Principal Adjustment on DVA Continuity Schedule","If \"no\", please provide an explanation"]
["1a","CT 148 True-up of GA Charges based on Actual Non-RPP Volumes - prior year"]
["1b","CT 148 True-up of GA Charges based on Actual Non-RPP Volumes - current year"]
["2a","Remove prior year end unbilled to actual revenue differences"]
["2b","Add current year end unbilled to actual revenue differences"]
["3a","Significant prior period billing adjustments recorded in current year"]
["3b","Significant current period billing adjustments recorded in other year(s)"]
[4,"CT 2148 for prior period corrections"]
[5,"Impacts of GA deferral "]
[6]
[7]
[8]
[9]
[10]
[11]
["Note 6","Adjusted Net Change in Principal Balance in the GL",{"$f":"SUM(C75:C89)","v":0}]
[null,"Net Change in Expected GA Balance in the Year Per Analysis",{"$f":"K60","v":0}]
[null,"Unresolved Difference",{"$f":"C90-C91","v":0}]
[null,"Unresolved Difference as % of Expected GA Payments to IESO",{"$f":"IF(ISERROR(C92/J53),0,C92/J53)","v":0},{"$f":"IF(AND(C93<0.01,C93>-0.01),\"\",\"Unresolved differences of greater than + or - 1% should be explained\")","v":""}]

{"sheet":"GA 2021","index":7,"n_rows":93,"n_cols":11,"rows_kept":93,"cut":false,"hidden":true,"merged":[[58,6,58,10],[12,1,12,2],[12,4,12,5],[18,1,18,7],[24,1,24,4],[57,6,57,10],[75,3,75,7],[75,9,75,10],[60,7,60,9],[61,7,61,9],[62,7,62,9],[63,1,63,3],[64,1,70,3],[65,5,70,10],[73,3,73,7],[73,8,73,10],[74,0,74,1],[74,3,74,7],[74,9,74,10],[76,3,76,7],[76,9,76,10],[77,3,77,7],[77,9,77,10],[78,3,78,7],[78,9,78,10],[79,3,79,7],[79,9,79,10],[80,3,80,7],[80,9,80,10],[81,3,81,7],[81,9,81,10],[82,3,82,7],[82,9,82,10],[83,3,83,7],[83,9,83,10],[84,3,84,7],[84,9,84,10],[88,3,88,7],[88,9,88,10],[85,3,85,7],[85,9,85,10],[86,3,86,7],[86,9,86,10],[87,3,87,7],[87,9,87,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Note 2","Consumption Data Excluding for Loss Factor (Data to agree with RRR as applicable)"]
[null,"Year",null,2021]
[null,"Total Metered excluding WMP","C = A+B",{"$f":"VLOOKUP('1. Information Sheet'!$C$17,RRR_2021!$B$4:$U$68,19,FALSE)","v":{"$error":"#N/A"}},"kWh",1]
[null,"RPP ","A",{"$f":"VLOOKUP('1. Information Sheet'!$C$17,RRR_2021!$B$4:$U$68,7,FALSE)","v":{"$error":"#N/A"}},"kWh",{"$f":"IFERROR(D15/$D$14,0)","v":0}]
[null,"Non RPP","B = D+E",{"$f":"VLOOKUP('1. Information Sheet'!$C$17,RRR_2021!$B$4:$U$68,20,FALSE)","v":{"$error":"#N/A"}},"kWh",{"$f":"IFERROR(D16/$D$14,0)","v":0}]
[null,"Non-RPP Class A","D",{"$f":"VLOOKUP('1. Information Sheet'!$C$17,RRR_2021!$B$4:$U$68,13,FALSE)","v":{"$error":"#N/A"}},"kWh",{"$f":"IFERROR(D17/$D$14,0)","v":0}]
[null,"Non-RPP Class B*","E",{"$f":"D16-D17","v":{"$error":"#N/A"}},"kWh",{"$f":"IFERROR(D18/$D$14,0)","v":0}]
[null,"*Non-RPP Class B consumption reported in this table is not expected to directly agree with the Non-RPP Class B Including Loss Adjusted Billed Consumption in the GA Analysis of Expected Balance table below.  The difference should be equal to the loss factor."]
[]
["Note 3","GA Billing Rate"]
[]
[null,"GA is billed on the ",null,"Note that this GA rate for 2021 includes the GA recovery rate to recover the 2020 deferred Class B amount for non-RPP market participants and consumers."]
[]
[null,"Please confirm that the adjusted GA rate was used to bill customers from April to June 2021. \nFor the months of April to June 2020, the IESO provided adjusted GA rates, which reflected the deferral of a portion of the GA as per the May 1, 2020 Emergency Order, and unadjusted GA rates which did not consider the GA deferral."]
[]
[null,"Please confirm that the same GA rate is used to bill all customer classes. If not, please provide further details"]
[]
[null,"Please confirm that the GA Rate used for unbilled revenue is the same as the one used for billed revenue in any paticular month"]
[]
[]
[]
[]
[]
[]
[]
["Note 4","Analysis of Expected GA Amount"]
[null,"Year",2021]
[null,"Calendar Month","Non-RPP Class B Including Loss Factor Billed Consumption (kWh)","Deduct Previous Month Unbilled Loss Adjusted Consumption (kWh)","Add Current Month Unbilled Loss Adjusted Consumption (kWh)","Non-RPP Class B Including Loss Adjusted Consumption, Adjusted for Unbilled (kWh)","GA Rate Billed  ($/kWh)","$ Consumption at GA Rate Billed","GA Actual Rate Paid ($/kWh)","$ Consumption at Actual Rate Paid","Expected GA Price Variance ($)"]
[null,null,"F","G","H","I = F-G+H","J","K = I*J","L","M = I*L","N=M-K"]
[null,"January",null,null,null,{"$f":"C41-D41+E41","v":0},{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!B20,IF($C$23=\"2nd Estimate\",'GA Rates'!C20,IF($C$23=\"Actual\",'GA Rates'!D20,0)))","v":0},{"$f":"F41*G41","v":0},{"$f":"'GA Rates'!D20","v":8.7980000000000003E-2},{"$f":"F41*I41","v":0},{"$f":"J41-H41","v":0}]
[null,"February",null,null,null,{"$f":"C42-D42+E42","v":0},{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!B21,IF($C$23=\"2nd Estimate\",'GA Rates'!C21,IF($C$23=\"Actual\",'GA Rates'!D21,0)))","v":0},{"$f":"F42*G42","v":0},{"$f":"'GA Rates'!D21","v":5.7510000000000006E-2},{"$f":"F42*I42","v":0},{"$f":"J42-H42","v":0}]
[null,"March",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!B22,IF($C$23=\"2nd Estimate\",'GA Rates'!C22,IF($C$23=\"Actual\",'GA Rates'!D22,0)))","v":0},0,{"$f":"'GA Rates'!D22","v":9.6679999999999988E-2},0,0]
[null,"April",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!B23,IF($C$23=\"2nd Estimate\",'GA Rates'!C23,IF($C$23=\"Actual\",'GA Rates'!D23,0)))","v":0},0,{"$f":"'GA Rates'!D23","v":0.11589000000000001},0,0]
[null,"May",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!B24,IF($C$23=\"2nd Estimate\",'GA Rates'!C24,IF($C$23=\"Actual\",'GA Rates'!D24,0)))","v":0},0,{"$f":"'GA Rates'!D24","v":0.10675},0,0]
[null,"June",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!B25,IF($C$23=\"2nd Estimate\",'GA Rates'!C25,IF($C$23=\"Actual\",'GA Rates'!D25,0)))","v":0},0,{"$f":"'GA Rates'!D25","v":9.2159999999999992E-2},0,0]
[null,"July",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!B26,IF($C$23=\"2nd Estimate\",'GA Rates'!C26,IF($C$23=\"Actual\",'GA Rates'!D26,0)))","v":0},0,{"$f":"'GA Rates'!D26","v":7.9179999999999987E-2},0,0]
[null,"August",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!B27,IF($C$23=\"2nd Estimate\",'GA Rates'!C27,IF($C$23=\"Actual\",'GA Rates'!D27,0)))","v":0},0,{"$f":"'GA Rates'!D27","v":5.1069999999999997E-2},0,0]
[null,"September",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!B28,IF($C$23=\"2nd Estimate\",'GA Rates'!C28,IF($C$23=\"Actual\",'GA Rates'!D28,0)))","v":0},0,{"$f":"'GA Rates'!D28","v":8.2339999999999997E-2},0,0]
[null,"October",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!B29,IF($C$23=\"2nd Estimate\",'GA Rates'!C29,IF($C$23=\"Actual\",'GA Rates'!D29,0)))","v":0},0,{"$f":"'GA Rates'!D29","v":5.8400000000000001E-2},0,0]
[null,"November ",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!B30,IF($C$23=\"2nd Estimate\",'GA Rates'!C30,IF($C$23=\"Actual\",'GA Rates'!D30,0)))","v":0},0,{"$f":"'GA Rates'!D30","v":6.0120000000000007E-2},0,0]
[null,"December",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!B31,IF($C$23=\"2nd Estimate\",'GA Rates'!C31,IF($C$23=\"Actual\",'GA Rates'!D31,0)))","v":0},0,{"$f":"'GA Rates'!D31","v":6.515E-2},0,0]
[null,"Net Change in Expected GA Balance in the Year (i.e. Transactions in the Year)",{"$f":"SUM(C41:C52)","v":0},{"$f":"SUM(D41:D52)","v":0},{"$f":"SUM(E41:E52)","v":0},{"$f":"SUM(F41:F52)","v":0},null,{"$f":"SUM(H41:H52)","v":0},null,{"$f":"SUM(J41:J52)","v":0},{"$f":"SUM(K41:K52)","v":0}]
[]
[null,null,null,null,null,null,"Annual Non-RPP Class B Wholesale kWh *","Annual Non-RPP Class B Retail billed kWh**","Annual Unaccounted for Energy Loss kWh","Weighted Average GA Actual Rate Paid ($/kWh)***","Expected GA Volume Variance ($)"]
[null,null,null,null,null,null,"O","P","Q=O-P","R","P= Q*R"]
[null,null,null,null,null,null,null,null,{"$f":"G57-H57","v":0},null,{"$f":"I57*J57","v":0}]
[null,null,null,null,null,null,"*Equal to (AQEW - Class A + embedded generation kWh)*(Non-RPP Class B retail kwh/Total retail Class B kWh).\n**Equal to the total Non-RPP Class B Including Loss Adjusted Consmption, Adjusted for Unbilled (i.e. cell F53), unless a reconciling item for \"Impacts of GA deferral/recovery\" is quantified and an alternative methodology for calculating the Expected GA Volume Variance is proposed."]
[null,null,null,null,null,null,"**Equal to annual Non-RPP Class B $ GA paid (i.e. non-RPP portion of CT 148 on IESO invoice) divided by Non-RPP Class B Wholesale kWh (as quantified in column O in the table above). The weighted average GA actual rate paid in 2021 is generally expected to include the GA recovery rate, unless a reconciling item for \"Impacts of GA deferral/recovery\" is quantified and an alternative methodology for calculating the Expected GA Volume Variance is proposed.\n\nThe weighted average GA actual rate paid in 2021 is generally expected to include the GA recovery rate, unless the distributor is proposing an alternative methodology in calculating the Expected GA Volume Variance and proposing to quantify the reconciling item for \"Impacts of GA deferral/recovery."]
[null,null,null,null,null,null,null,null,null,"Total Expected GA Variance",{"$f":"K53+K57","v":0}]
[null,null,null,null,null,null,null,"Calculated Loss Factor",null,null,{"$f":"IFERROR(F53/D18,0)","v":0}]
[null,null,null,null,null,null,null,"Most Recent Approved Loss Factor for Secondary Metered Customer < 5,000kW"]
[null,null,null,null,null,null,null,"Difference",null,null,{"$f":"K61-K62","v":0}]
[null,"a) Please provide an explanation in the text box below if columns G and H for unbilled consumption are not used in the table above."]
[null,null,null,null,null,"b) Please provide an explanation in the text box below if the difference in loss factor is greater than 1%"]
[]
[]
[]
[]
[]
[]
["Note 5 ","Reconciling Items "]
[]
[null," Item","Amount","Explanation",null,null,null,null,"Principal Adjustments"]
[" Net Change in Principal Balance in the GL (i.e. Transactions in the Year)",null,null,null,null,null,null,null,"Principal Adjustment on DVA Continuity Schedule","If \"no\", please provide an explanation"]
["1a","CT 148 True-up of GA Charges based on Actual Non-RPP Volumes - prior year"]
["1b","CT 148 True-up of GA Charges based on Actual Non-RPP Volumes - current year"]
["2a","Remove prior year end unbilled to actual revenue differences"]
["2b","Add current year end unbilled to actual revenue differences"]
["3a","Significant prior period billing adjustments recorded in current year"]
["3b","Significant current period billing adjustments recorded in other year(s)"]
[4,"CT 2148 for prior period corrections"]
[5,"Impacts of GA deferral/recovery"]
[6]
[7]
[8]
[9]
[10]
[11]
["Note 6","Adjusted Net Change in Principal Balance in the GL",{"$f":"SUM(C75:C89)","v":0}]
[null,"Net Change in Expected GA Balance in the Year Per Analysis",{"$f":"K60","v":0}]
[null,"Unresolved Difference",{"$f":"C90-C91","v":0}]
[null,"Unresolved Difference as % of Expected GA Payments to IESO",{"$f":"IF(ISERROR(C92/J53),0,C92/J53)","v":0},{"$f":"IF(AND(C93<0.01,C93>-0.01),\"\",\"Unresolved differences of greater than + or - 1% should be explained\")","v":""}]

{"sheet":"GA 2022","index":8,"n_rows":93,"n_cols":11,"rows_kept":93,"cut":false,"hidden":false,"merged":[[57,6,57,10],[12,1,12,2],[12,4,12,5],[18,1,18,7],[24,1,24,5],[26,1,26,5],[75,3,75,7],[75,9,75,10],[58,6,58,10],[60,7,60,9],[61,7,61,9],[62,7,62,9],[63,1,63,3],[64,1,70,3],[65,5,70,10],[73,3,73,7],[73,8,73,10],[74,0,74,1],[74,3,74,7],[74,9,74,10],[76,3,76,7],[76,9,76,10],[77,3,77,7],[77,9,77,10],[78,3,78,7],[78,9,78,10],[79,3,79,7],[79,9,79,10],[80,3,80,7],[80,9,80,10],[81,3,81,7],[81,9,81,10],[82,3,82,7],[82,9,82,10],[83,3,83,7],[83,9,83,10],[84,3,84,7],[84,9,84,10],[88,3,88,7],[88,9,88,10],[85,3,85,7],[85,9,85,10],[86,3,86,7],[86,9,86,10],[87,3,87,7],[87,9,87,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Note 2","Consumption Data Excluding for Loss Factor (Data to agree with RRR as applicable)"]
[null,"Year",null,2022]
[null,"Total Metered excluding WMP","C = A+B",83495463,"kWh",1]
[null,"RPP ","A",39948118,"kWh",{"$f":"IFERROR(D15/$D$14,0)","v":0.47844657140232877}]
[null,"Non RPP","B = D+E",43547345,"kWh",{"$f":"IFERROR(D16/$D$14,0)","v":0.52155342859767118}]
[null,"Non-RPP Class A","D",19400137,"kWh",{"$f":"IFERROR(D17/$D$14,0)","v":0.23234959485163884}]
[null,"Non-RPP Class B*","E",24147208,"kWh",{"$f":"IFERROR(D18/$D$14,0)","v":0.28920383374603242}]
[null,"*Non-RPP Class B consumption reported in this table is not expected to directly agree with the Non-RPP Class B Including Loss Adjusted Billed Consumption in the GA Analysis of Expected Balance table below.  The difference should be equal to the loss factor."]
[]
["Note 3","GA Billing Rate"]
[]
[null,"GA is billed on the ","1st Estimate"]
[]
[null,"Please confirm that the same GA rate is used to bill all customer classes. If not, please provide further details",null,null,null,null,"Yes"]
[]
[null,"Please confirm that the GA Rate used for unbilled revenue is the same as the one used for billed revenue in any paticular month",null,null,null,null,"Yes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Note 4","Analysis of Expected GA Amount"]
[null,"Year",2022]
[null,"Calendar Month","Non-RPP Class B Including Loss Factor Billed Consumption (kWh)","Deduct Previous Month Unbilled Loss Adjusted Consumption (kWh)","Add Current Month Unbilled Loss Adjusted Consumption (kWh)","Non-RPP Class B Including Loss Adjusted Consumption, Adjusted for Unbilled (kWh)","GA Rate Billed  ($/kWh)","$ Consumption at GA Rate Billed","GA Actual Rate Paid ($/kWh)","$ Consumption at Actual Rate Paid","Expected GA Price Variance ($)"]
[null,null,"F","G","H","I = F-G+H","J","K = I*J","L","M = I*L","N=M-K"]
[null,"January",2433109.2800000003,null,null,{"$f":"C41-D41+E41","v":2433109.2800000003},{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!F20,IF($C$23=\"2nd Estimate\",'GA Rates'!G20,IF($C$23=\"Actual\",'GA Rates'!H20,0)))","v":4.829E-2},{"$f":"F41*G41","v":117494.84713120002},{"$f":"'GA Rates'!H20","v":4.3529999999999999E-2},{"$f":"F41*I41","v":105913.24695840001},{"$f":"J41-H41","v":-11581.600172800012}]
[null,"February",2170649.1700000004,null,null,{"$f":"C42-D42+E42","v":2170649.1700000004},{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!F21,IF($C$23=\"2nd Estimate\",'GA Rates'!G21,IF($C$23=\"Actual\",'GA Rates'!H21,0)))","v":5.0189999999999999E-2},{"$f":"F42*G42","v":108944.88184230002},{"$f":"'GA Rates'!H21","v":5.246E-2},{"$f":"F42*I42","v":113872.25545820002},{"$f":"J42-H42","v":4927.3736158999964}]
[null,"March",2236001.06,null,null,2236001.06,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!F22,IF($C$23=\"2nd Estimate\",'GA Rates'!G22,IF($C$23=\"Actual\",'GA Rates'!H22,0)))","v":5.5E-2},122980.0583,{"$f":"'GA Rates'!H22","v":5.9409999999999998E-2},132840.82297459999,9860.7646745999809]
[null,"April",1970979.0099999998,null,null,1970979.0099999998,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!F23,IF($C$23=\"2nd Estimate\",'GA Rates'!G23,IF($C$23=\"Actual\",'GA Rates'!H23,0)))","v":5.9150000000000001E-2},116583.4084415,{"$f":"'GA Rates'!H23","v":8.2930000000000004E-2},163453.2892993,46869.880857800003]
[null,"May",2020153.5699999987,null,null,2020153.5699999987,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!F24,IF($C$23=\"2nd Estimate\",'GA Rates'!G24,IF($C$23=\"Actual\",'GA Rates'!H24,0)))","v":5.9679999999999997E-2},120562.76505759991,{"$f":"'GA Rates'!H24","v":8.4750000000000006E-2},171208.0150574999,50645.249999899985]
[null,"June",2014204.8999999997,null,null,2014204.8999999997,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!F25,IF($C$23=\"2nd Estimate\",'GA Rates'!G25,IF($C$23=\"Actual\",'GA Rates'!H25,0)))","v":8.2930000000000004E-2},167038.01235699997,{"$f":"'GA Rates'!H25","v":7.868E-2},158477.64153199998,-8560.3708249999909]
[null,"July",2129737.35,null,null,2129737.35,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!F26,IF($C$23=\"2nd Estimate\",'GA Rates'!G26,IF($C$23=\"Actual\",'GA Rates'!H26,0)))","v":8.4750000000000006E-2},180495.24041250002,{"$f":"'GA Rates'!H26","v":4.0079999999999998E-2},85359.872988000003,-95135.367424500015]
[null,"August",2220532.6100000008,null,null,2220532.6100000008,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!F27,IF($C$23=\"2nd Estimate\",'GA Rates'!G27,IF($C$23=\"Actual\",'GA Rates'!H27,0)))","v":4.8710000000000003E-2},108162.14343310005,{"$f":"'GA Rates'!H27","v":4.9899999999999996E-3},11080.457723900003,-97081.685709200043]
[null,"September",1992890.3200000003,null,null,1992890.3200000003,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!F28,IF($C$23=\"2nd Estimate\",'GA Rates'!G28,IF($C$23=\"Actual\",'GA Rates'!H28,0)))","v":4.0079999999999998E-2},79875.0440256,{"$f":"'GA Rates'!H28","v":3.2410000000000001E-2},64589.57527120001,-15285.46875439999]
[null,"October",1987019.3900000022,null,null,1987019.3900000022,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!F29,IF($C$23=\"2nd Estimate\",'GA Rates'!G29,IF($C$23=\"Actual\",'GA Rates'!H29,0)))","v":4.9899999999999996E-3},9915.2267561000099,{"$f":"'GA Rates'!H29","v":5.7709999999999997E-2},114670.88899690012,104755.66224080011]
[null,"November ",1995877.4300000009,null,null,1995877.4300000009,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!F30,IF($C$23=\"2nd Estimate\",'GA Rates'!G30,IF($C$23=\"Actual\",'GA Rates'!H30,0)))","v":4.7390000000000002E-2},94584.631407700042,{"$f":"'GA Rates'!H30","v":6.9889999999999994E-2},139491.87358270003,44907.242174999992]
[null,"December",2081471.129999998,null,null,2081471.129999998,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!F31,IF($C$23=\"2nd Estimate\",'GA Rates'!G31,IF($C$23=\"Actual\",'GA Rates'!H31,0)))","v":5.9619999999999999E-2},124097.30877059988,{"$f":"'GA Rates'!H31","v":3.4270000000000002E-2},71332.015625099943,-52765.293145499934]
[null,"Net Change in Expected GA Balance in the Year (i.e. Transactions in the Year)",{"$f":"SUM(C41:C52)","v":25252625.219999999},{"$f":"SUM(D41:D52)","v":0},{"$f":"SUM(E41:E52)","v":0},{"$f":"SUM(F41:F52)","v":25252625.219999999},null,{"$f":"SUM(H41:H52)","v":1350733.5679351997},null,{"$f":"SUM(J41:J52)","v":1332289.9554678001},{"$f":"SUM(K41:K52)","v":-18443.612467399915}]
[]
[null,null,null,null,null,null,"Annual Non-RPP Class B Wholesale kWh *","Annual Non-RPP Class B Retail billed kWh","Annual Unaccounted for Energy Loss kWh","Weighted Average GA Actual Rate Paid ($/kWh)**","Expected GA Volume Variance ($)"]
[null,null,null,null,null,null,"O","P","Q=O-P","R","P= Q*R"]
[null,null,null,null,null,null,25730799,{"$f":"F53","v":25252625.219999999},{"$f":"G57-H57","v":478173.78000000119},5.3530000000000001E-2,{"$f":"I57*J57","v":25596.642443400066}]
[null,null,null,null,null,null,"*Equal to (AQEW - Class A + embedded generation kWh)*(Non-RPP Class B retail kwh/Total retail Class B kWh)"]
[null,null,null,null,null,null,"**Equal to annual Non-RPP Class B $ GA paid (i.e. non-RPP portion of CT 148 on IESO invoice) divided by Non-RPP Class B Wholesale kWh (as quantified in column O in the table above)"]
[null,null,null,null,null,null,null,null,null,"Total Expected GA Variance",{"$f":"K53+K57","v":7153.0299760001508}]
[null,null,null,null,null,null,null,"Calculated Loss Factor",null,null,{"$f":"IFERROR(F53/D18,0)","v":1.0457782622322216}]
[null,null,null,null,null,null,null,"Most Recent Approved Loss Factor for Secondary Metered Customer < 5,000kW",null,null,1.0467]
[null,null,null,null,null,null,null,"Difference",null,null,{"$f":"K61-K62","v":-9.2173776777837446E-4}]
[null,"a) Please provide an explanation in the text box below if columns G and H for unbilled consumption are not used in the table above."]
[null,"Consumption in column F is actual consumption including unbilled revenue",null,null,null,"b) Please provide an explanation in the text box below if the difference in loss factor is greater than 1%"]
[]
[]
[]
[]
[]
[]
["Note 5 ","Reconciling Items "]
[]
[null," Item","Amount","Explanation",null,null,null,null,"Principal Adjustments"]
[" Net Change in Principal Balance in the GL (i.e. Transactions in the Year)",null,16587.949600000014,null,null,null,null,null,"Principal Adjustment on DVA Continuity Schedule","If \"no\", please provide an explanation"]
["1a","CT 148 True-up of GA Charges based on Actual Non-RPP Volumes - prior year"]
["1b","CT 148 True-up of GA Charges based on Actual Non-RPP Volumes - current year",-17861.310954951303,null,null,null,null,null,"Yes"]
["2a","Remove prior year end unbilled to actual revenue differences"]
["2b","Add current year end unbilled to actual revenue differences"]
["3a","Significant prior period billing adjustments recorded in current year"]
["3b","Significant current period billing adjustments recorded in other year(s)"]
["4a","CT 2148 for prior period corrections"]
["4b"]
[5]
[6]
[7]
[8]
[9]
[10]
["Note 6","Adjusted Net Change in Principal Balance in the GL",{"$f":"SUM(C75:C89)","v":-1273.3613549512884}]
[null,"Net Change in Expected GA Balance in the Year Per Analysis",{"$f":"K60","v":7153.0299760001508}]
[null,"Unresolved Difference",{"$f":"C90-C91","v":-8426.3913309514392}]
[null,"Unresolved Difference as % of Expected GA Payments to IESO",{"$f":"IF(ISERROR(C92/J53),0,C92/J53)","v":-6.3247428207118201E-3},{"$f":"IF(AND(C93<0.01,C93>-0.01),\"\",\"Unresolved differences of greater than + or - 1% should be explained\")","v":""}]

{"sheet":"GA 2023","index":9,"n_rows":93,"n_cols":11,"rows_kept":93,"cut":false,"hidden":false,"merged":[[86,3,86,7],[86,9,86,10],[87,3,87,7],[87,9,87,10],[88,3,88,7],[88,9,88,10],[83,3,83,7],[83,9,83,10],[84,3,84,7],[84,9,84,10],[85,3,85,7],[85,9,85,10],[80,3,80,7],[80,9,80,10],[81,3,81,7],[81,9,81,10],[82,3,82,7],[82,9,82,10],[77,3,77,7],[77,9,77,10],[78,3,78,7],[78,9,78,10],[79,3,79,7],[79,9,79,10],[76,3,76,7],[76,9,76,10],[61,7,61,9],[62,7,62,9],[64,1,70,3],[65,5,70,10],[73,3,73,7],[73,8,73,10],[74,0,74,1],[74,3,74,7],[74,9,74,10],[75,3,75,7],[75,9,75,10],[63,1,63,3],[60,7,60,9],[12,1,12,2],[12,4,12,5],[18,1,18,7],[24,1,24,5],[26,1,26,5],[58,6,58,10],[57,6,57,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Note 2","Consumption Data Excluding for Loss Factor (Data to agree with RRR as applicable)"]
[null,"Year",null,2023]
[null,"Total Metered excluding WMP","C = A+B",82602476.210000008,"kWh",1]
[null,"RPP ","A",38550500.749999993,"kWh",{"$f":"IFERROR(D15/$D$14,0)","v":0.4666990932813343}]
[null,"Non RPP","B = D+E",44051975.460000008,"kWh",{"$f":"IFERROR(D16/$D$14,0)","v":0.53330090671866559}]
[null,"Non-RPP Class A","D",19760983.460000001,"kWh",{"$f":"IFERROR(D17/$D$14,0)","v":0.23922991618025732}]
[null,"Non-RPP Class B*","E",{"$f":"D16-D17","v":24290992.000000007},"kWh",{"$f":"IFERROR(D18/$D$14,0)","v":0.29407099053840829}]
[null,"*Non-RPP Class B consumption reported in this table is not expected to directly agree with the Non-RPP Class B Including Loss Adjusted Billed Consumption in the GA Analysis of Expected Balance table below.  The difference should be equal to the loss factor."]
[]
["Note 3","GA Billing Rate"]
[]
[null,"GA is billed on the ","1st Estimate"]
[]
[null,"Please confirm that the same GA rate is used to bill all customer classes. If not, please provide further details",null,null,null,null,"Yes"]
[]
[null,"Please confirm that the GA Rate used for unbilled revenue is the same as the one used for billed revenue in any paticular month",null,null,null,null,"Yes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Note 4","Analysis of Expected GA Amount"]
[null,"Year",2023]
[null,"Calendar Month","Non-RPP Class B Including Loss Factor Billed Consumption (kWh)","Deduct Previous Month Unbilled Loss Adjusted Consumption (kWh)","Add Current Month Unbilled Loss Adjusted Consumption (kWh)","Non-RPP Class B Including Loss Adjusted Consumption, Adjusted for Unbilled (kWh)","GA Rate Billed  ($/kWh)","$ Consumption at GA Rate Billed","GA Actual Rate Paid ($/kWh)","$ Consumption at Actual Rate Paid","Expected GA Price Variance ($)"]
[null,null,"F","G","H","I = F-G+H","J","K = I*J","L","M = I*L","N=M-K"]
[null,"January",2205045.9600000009,null,null,{"$f":"C41-D41+E41","v":2205045.9600000009},{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!J20,IF($C$23=\"2nd Estimate\",'GA Rates'!K20,IF($C$23=\"Actual\",'GA Rates'!L20,0)))","v":3.1379999999999998E-2},{"$f":"F41*G41","v":69194.342224800028},{"$f":"'GA Rates'!L20","v":5.3770000000000005E-2},{"$f":"F41*I41","v":118565.32126920005},{"$f":"J41-H41","v":49370.979044400025}]
[null,"February",2026103.3799999997,null,null,{"$f":"C42-D42+E42","v":2026103.3799999997},{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!J21,IF($C$23=\"2nd Estimate\",'GA Rates'!K21,IF($C$23=\"Actual\",'GA Rates'!L21,0)))","v":6.2850000000000003E-2},{"$f":"F42*G42","v":127340.59743299999},{"$f":"'GA Rates'!L21","v":8.2489999999999994E-2},{"$f":"F42*I42","v":167133.26781619995},{"$f":"J42-H42","v":39792.670383199962}]
[null,"March",2183531.04,null,null,2183531.04,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!J22,IF($C$23=\"2nd Estimate\",'GA Rates'!K22,IF($C$23=\"Actual\",'GA Rates'!L22,0)))","v":6.9889999999999994E-2},152606.98438559999,{"$f":"'GA Rates'!L22","v":8.0310000000000006E-2},175359.37782240001,22752.393436800019]
[null,"April",1966519.5399999998,null,null,1966519.5399999998,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!J23,IF($C$23=\"2nd Estimate\",'GA Rates'!K23,IF($C$23=\"Actual\",'GA Rates'!L23,0)))","v":8.2489999999999994E-2},162218.19685459998,{"$f":"'GA Rates'!L23","v":9.8530000000000006E-2},193761.17027619999,31542.973421600007]
[null,"May",2041182.5500000003,null,null,2041182.5500000003,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!J24,IF($C$23=\"2nd Estimate\",'GA Rates'!K24,IF($C$23=\"Actual\",'GA Rates'!L24,0)))","v":8.2489999999999994E-2},168377.14854950001,{"$f":"'GA Rates'!L24","v":9.962E-2},203342.60563100004,34965.457081500033]
[null,"June",2025591.95,null,null,2025591.95,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!J25,IF($C$23=\"2nd Estimate\",'GA Rates'!K25,IF($C$23=\"Actual\",'GA Rates'!L25,0)))","v":9.8530000000000006E-2},199581.5748335,{"$f":"'GA Rates'!L25","v":8.2930000000000004E-2},167982.3404135,-31599.234419999993]
[null,"July",2287784.4300000002,null,null,2287784.4300000002,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!J26,IF($C$23=\"2nd Estimate\",'GA Rates'!K26,IF($C$23=\"Actual\",'GA Rates'!L26,0)))","v":9.962E-2},227909.08491660003,{"$f":"'GA Rates'!L26","v":4.9489999999999999E-2},113222.45144070001,-114686.63347590002]
[null,"August",2272007.1999999997,null,null,2272007.1999999997,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!J27,IF($C$23=\"2nd Estimate\",'GA Rates'!K27,IF($C$23=\"Actual\",'GA Rates'!L27,0)))","v":5.3770000000000005E-2},122165.827144,{"$f":"'GA Rates'!L27","v":7.6060000000000003E-2},172808.86763199998,50643.040487999984]
[null,"September",2093211.25,null,null,2093211.25,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!J28,IF($C$23=\"2nd Estimate\",'GA Rates'!K28,IF($C$23=\"Actual\",'GA Rates'!L28,0)))","v":5.8369999999999998E-2},122180.7406625,{"$f":"'GA Rates'!L28","v":5.0930000000000003E-2},106607.2489625,-15573.491699999999]
[null,"October",2087239.2000000002,null,null,2087239.2000000002,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!J29,IF($C$23=\"2nd Estimate\",'GA Rates'!K29,IF($C$23=\"Actual\",'GA Rates'!L29,0)))","v":7.3319999999999996E-2},153036.37814400002,{"$f":"'GA Rates'!L29","v":8.498E-2},177373.58721600001,24337.209071999998]
[null,"November ",2109338.1700000004,null,null,2109338.1700000004,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!J30,IF($C$23=\"2nd Estimate\",'GA Rates'!K30,IF($C$23=\"Actual\",'GA Rates'!L30,0)))","v":7.0400000000000004E-2},148497.40716800003,{"$f":"'GA Rates'!L30","v":7.0900000000000005E-2},149552.07625300004,1054.6690850000014]
[null,"December",2106679.6800000002,null,null,2106679.6800000002,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!J31,IF($C$23=\"2nd Estimate\",'GA Rates'!K31,IF($C$23=\"Actual\",'GA Rates'!L31,0)))","v":8.3400000000000002E-2},175697.08531200001,{"$f":"'GA Rates'!L31","v":6.6220000000000001E-2},139504.32840960001,-36192.756902399997]
[null,"Net Change in Expected GA Balance in the Year (i.e. Transactions in the Year)",{"$f":"SUM(C41:C52)","v":25404234.350000001},{"$f":"SUM(D41:D52)","v":0},{"$f":"SUM(E41:E52)","v":0},{"$f":"SUM(F41:F52)","v":25404234.350000001},null,{"$f":"SUM(H41:H52)","v":1828805.3676281001},null,{"$f":"SUM(J41:J52)","v":1885212.6431423},{"$f":"SUM(K41:K52)","v":56407.275514200039}]
[]
[null,null,null,null,null,null,"Annual Non-RPP Class B Wholesale kWh *","Annual Non-RPP Class B Retail billed kWh","Annual Unaccounted for Energy Loss kWh","Weighted Average GA Actual Rate Paid ($/kWh)**","Expected GA Volume Variance ($)"]
[null,null,null,null,null,null,"O","P","Q=O-P","R","P= Q*R"]
[null,null,null,null,null,null,26654217.251385301,{"$f":"F53","v":25404234.350000001},{"$f":"G57-H57","v":1249982.9013852999},7.2582636426866048E-2,{"$f":"I57*J57","v":90727.054471048381}]
[null,null,null,null,null,null,"*Equal to (AQEW - Class A + embedded generation kWh)*(Non-RPP Class B retail kwh/Total retail Class B kWh)"]
[null,null,null,null,null,null,"**Equal to annual Non-RPP Class B $ GA paid (i.e. non-RPP portion of CT 148 on IESO invoice) divided by Non-RPP Class B Wholesale kWh (as quantified in column O in the table above)"]
[null,null,null,null,null,null,null,null,null,"Total Expected GA Variance",{"$f":"K53+K57","v":147134.32998524842}]
[null,null,null,null,null,null,null,"Calculated Loss Factor",null,null,{"$f":"IFERROR(F53/D18,0)","v":1.0458294313381682}]
[null,null,null,null,null,null,null,"Most Recent Approved Loss Factor for Secondary Metered Customer < 5,000kW",null,null,1.0467]
[null,null,null,null,null,null,null,"Difference",null,null,{"$f":"K61-K62","v":-8.7056866183177206E-4}]
[null,"a) Please provide an explanation in the text box below if columns G and H for unbilled consumption are not used in the table above."]
[null,null,null,null,null,"b) Please provide an explanation in the text box below if the difference in loss factor is greater than 1%"]
[]
[]
[]
[]
[]
[]
["Note 5 ","Reconciling Items "]
[]
[null," Item","Amount","Explanation",null,null,null,null,"Principal Adjustments"]
[" Net Change in Principal Balance in the GL (i.e. Transactions in the Year)",null,82471.215493148251,null,null,null,null,null,"Principal Adjustment on DVA Continuity Schedule","If \"no\", please provide an explanation"]
["1a","CT 148 True-up of GA Charges based on Actual Non-RPP Volumes - prior year",17861.310954951299,null,null,null,null,null,"Yes"]
["1b","CT 148 True-up of GA Charges based on Actual Non-RPP Volumes - current year",28420.970076665501,null,null,null,null,null,"Yes"]
["2a","Remove prior year end unbilled to actual revenue differences"]
["2b","Add current year end unbilled to actual revenue differences"]
["3a","Remove difference between prior year accrual/forecast to actual from long term load transfers"]
["3b","Add difference between current year accrual/forecast to actual from long term load transfers"]
[4,"Remove GA balances pertaining to Class A customers"]
["5a","Significant prior period billing adjustments recorded in current year"]
["5b","Significant current period billing adjustments recorded in other year(s)"]
[6,"Differences in GA IESO posted rate and rate charged on IESO invoice"]
[7]
[8]
[9]
[10]
["Note 6","Adjusted Net Change in Principal Balance in the GL",{"$f":"SUM(C75:C89)","v":128753.49652476505}]
[null,"Net Change in Expected GA Balance in the Year Per Analysis",{"$f":"K60","v":147134.32998524842}]
[null,"Unresolved Difference",{"$f":"C90-C91","v":-18380.833460483365}]
[null,"Unresolved Difference as % of Expected GA Payments to IESO",{"$f":"IF(ISERROR(C92/J53),0,C92/J53)","v":-9.7500054051440719E-3},{"$f":"IF(AND(C93<0.01,C93>-0.01),\"\",\"Unresolved differences of greater than + or - 1% should be explained\")","v":""}]

{"sheet":"Account 1588","index":10,"n_rows":73,"n_cols":22,"rows_kept":73,"cut":false,"hidden":false,"merged":[[9,17,11,22],[24,1,24,6],[33,1,38,6],[41,1,46,6],[49,1,54,6],[25,1,25,6],[73,1,78,6],[12,2,12,4],[12,5,13,5],[12,6,13,6],[57,1,62,6],[65,1,70,6]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The annual Account 1588 balance relative to cost of power is expected to be small. If it is greater than +/-1%, provide an explanation in the text box below."]
[]
[]
[]
["Note 7","Account 1588 Reasonability Test"]
[]
[null,null,"Account 1588 - RSVA Power",null,null,"Account 4705 - Power Purchased","Account 1588 as % of Account 4705"]
[null,"Year","Transactions1","Principal Adjustments1","Total Activity in Calendar Year"]
[null,2018,null,null,null,null,null,{"$f":"IF(ABS(G15)>0.01,$V$7,\"\")","v":""}]
[null,2019,null,null,{"$f":"SUM(C16:D16)","v":0},{"$f":"IFERROR(VLOOKUP('1. Information Sheet'!$C$17,'4705'!$A:$H,5,FALSE),0)","v":0},{"$f":"IFERROR(E16/F16,0)","v":0},""]
[null,2020,null,null,{"$f":"SUM(C17:D17)","v":0},{"$f":"IFERROR(VLOOKUP('1. Information Sheet'!$C$17,'4705'!$A:$H,6,FALSE),0)","v":0},0,""]
[null,2021,null,null,{"$f":"SUM(C18:D18)","v":0},{"$f":"IFERROR(VLOOKUP('1. Information Sheet'!$C$17,'4705'!$A:$H,7,FALSE),0)","v":0},0,""]
[null,2022,-108216.70611488291,85064.248211142723,{"$f":"SUM(C19:D19)","v":-23152.457903740185},5868243,-3.9453815910043578E-3,""]
[null,2023,68245.683674079337,-57602.370076665502,{"$f":"SUM(C20:D20)","v":10643.313597413835},4467229.6713310918,2.3825310943196855E-3,""]
[null,"Cumulative",{"$f":"SUM(C15:C20)","v":-39971.022440803572},{"$f":"SUM(D15:D20)","v":27461.878134477221},{"$f":"SUM(E15:E20)","v":-12509.14430632635},{"$f":"IF('1. Information Sheet'!D21=2022,F20,IF('1. Information Sheet'!D21=2021,SUM(F19:F20),IF('1. Information Sheet'!D21=2020,SUM(F18:F20),IF('1. Information Sheet'!D21=2019,SUM(F17:F20),IF('1. Information Sheet'!D21=2018,SUM(F16:F20),IF('1. Information Sheet'!D21=2016,SUM(F15:F20),0))))))","v":10335472.671331093},-1.210311778098419E-3]
[]
[]
[null,"Notes"]
[null,"1) The transactions should equal the \"Transaction\" column in the DVA Continuity Schedule. This is also expected to equal the transactions in the general ledger (excluding transactions relating to the removal of approved disposition amounts as that is shown in a separate column in the DVA Continuity Schedule)"]
[null,"2) Principal adjustments should equal the \"Principal Adjustments\" column in the DVA Continuity Schedule. Principal adjustments adjust the transactions in the general ledger to the amount that should be requested for disposition."]
[]
[]
[]
[]
[null,"Reasons for large Account 1588 balance, relative to cost of power purchased"]
[]
[null,2016]
[]
[]
[]
[]
[]
[]
[]
[null,2017]
[]
[]
[]
[]
[]
[]
[]
[null,2018]
[]
[]
[]
[]
[]
[]
[]
[null,2019]
[]
[]
[]
[]
[]
[]
[]
[null,2020]
[]
[]
[]
[]
[]
[]
[]
[null,2021]

{"sheet":"Principal Adjustments","index":11,"n_rows":189,"n_cols":24,"rows_kept":189,"cut":false,"hidden":false,"merged":[[186,2,186,8],[186,14,186,20],[187,1,187,8],[187,13,187,20],[188,1,188,8],[188,13,188,20],[181,2,181,8],[181,14,181,20],[182,2,182,8],[182,14,182,20],[183,2,183,8],[183,14,183,20],[184,2,184,8],[184,14,184,20],[185,2,185,8],[185,14,185,20],[176,2,176,8],[176,14,176,20],[177,1,177,8],[177,13,177,20],[178,1,178,10],[178,13,178,22],[179,2,179,8],[179,14,179,20],[180,2,180,8],[180,14,180,20],[171,2,171,8],[171,14,171,20],[172,2,172,8],[172,14,172,20],[173,2,173,8],[173,14,173,20],[174,2,174,8],[174,14,174,20],[175,2,175,8],[175,14,175,20],[166,1,166,10],[166,13,166,22],[167,1,167,8],[167,13,167,20],[168,1,168,10],[168,13,168,22],[169,2,169,8],[169,14,169,20],[170,2,170,8],[170,14,170,20],[162,1,162,8],[162,13,162,20],[163,1,163,8],[163,13,163,20],[159,2,159,8],[159,14,159,20],[160,2,160,8],[160,14,160,20],[161,2,161,8],[161,14,161,20],[156,2,156,8],[156,14,156,20],[157,2,157,8],[157,14,157,20],[158,2,158,8],[158,14,158,20],[153,1,153,10],[153,13,153,22],[154,2,154,8],[154,14,154,20],[155,2,155,8],[155,14,155,20],[150,2,150,8],[150,14,150,20],[151,2,151,8],[151,14,151,20],[152,1,152,8],[152,13,152,20],[147,2,147,8],[147,14,147,20],[148,2,148,8],[148,14,148,20],[149,2,149,8],[149,14,149,20],[144,2,144,8],[144,14,144,20],[145,2,145,8],[145,14,145,20],[146,2,146,8],[146,14,146,20],[141,1,141,10],[141,13,141,22],[142,1,142,8],[142,13,142,20],[143,1,143,10],[143,13,143,22],[136,2,136,8],[136,14,136,20],[137,1,137,8],[137,13,137,20],[138,1,138,8],[138,13,138,20],[133,2,133,8],[133,14,133,20],[134,2,134,8],[134,14,134,20],[135,2,135,8],[135,14,135,20],[130,2,130,8],[130,14,130,20],[131,2,131,8],[131,14,131,20],[132,2,132,8],[132,14,132,20],[127,1,127,8],[127,13,127,20],[128,1,128,10],[128,13,128,22],[129,2,129,8],[129,14,129,20],[124,2,124,8],[124,14,124,20],[125,2,125,8],[125,14,125,20],[126,2,126,8],[126,14,126,20],[121,2,121,8],[121,14,121,20],[122,2,122,8],[122,14,122,20],[123,2,123,8],[123,14,123,20],[118,1,118,10],[118,13,118,22],[119,2,119,8],[119,14,119,20],[120,2,120,8],[120,14,120,20],[113,1,113,8],[113,13,113,20],[116,1,116,10],[116,13,116,22],[117,1,117,8],[117,13,117,20],[110,2,110,8],[110,14,110,20],[111,2,111,8],[111,14,111,20],[112,1,112,8],[112,13,112,20],[107,2,107,8],[107,14,107,20],[108,2,108,8],[108,14,108,20],[109,2,109,8],[109,14,109,20],[104,2,104,8],[104,14,104,20],[105,2,105,8],[105,14,105,20],[106,2,106,8],[106,14,106,20],[101,2,101,8],[101,14,101,20],[102,1,102,8],[102,13,102,20],[103,1,103,10],[103,13,103,22],[98,2,98,8],[98,14,98,20],[99,2,99,8],[99,14,99,20],[100,2,100,8],[100,14,100,20],[95,2,95,8],[95,14,95,20],[96,2,96,8],[96,14,96,20],[97,2,97,8],[97,14,97,20],[92,1,92,8],[92,13,92,20],[93,1,93,10],[93,13,93,22],[94,2,94,8],[94,14,94,20],[87,1,87,8],[87,13,87,20],[88,1,88,8],[88,13,88,20],[91,1,91,10],[91,13,91,22],[84,2,84,8],[84,14,84,20],[85,2,85,8],[85,14,85,20],[86,2,86,8],[86,14,86,20],[81,2,81,8],[81,14,81,20],[82,2,82,8],[82,14,82,20],[83,2,83,8],[83,14,83,20],[78,1,78,10],[78,13,78,22],[79,2,79,8],[79,14,79,20],[80,2,80,8],[80,14,80,20],[75,2,75,8],[75,14,75,20],[76,2,76,8],[76,14,76,20],[77,1,77,8],[77,13,77,20],[72,2,72,8],[72,14,72,20],[73,2,73,8],[73,14,73,20],[74,2,74,8],[74,14,74,20],[69,2,69,8],[69,14,69,20],[70,2,70,8],[70,14,70,20],[71,2,71,8],[71,14,71,20],[66,1,66,10],[66,13,66,22],[67,1,67,8],[67,13,67,20],[68,1,68,10],[68,13,68,22],[16,1,16,11],[16,13,16,23],[17,1,17,8],[17,13,17,20],[18,2,18,8],[18,14,18,20],[19,2,19,8],[19,14,19,20],[20,2,20,8],[20,14,20,20],[21,2,21,8],[21,14,21,20],[28,1,28,8],[28,13,28,20],[22,2,22,8],[22,14,22,20],[23,2,23,8],[23,14,23,20],[24,2,24,8],[24,14,24,20],[25,2,25,8],[25,14,25,20],[26,1,26,8],[26,13,26,20],[27,1,27,8],[27,13,27,20],[34,22,38,25],[37,1,37,21],[40,1,40,10],[40,13,40,22],[42,1,42,10],[42,13,42,22],[41,1,41,8],[41,13,41,20],[38,1,38,21],[43,2,43,8],[43,14,43,20],[44,2,44,8],[44,14,44,20],[45,2,45,8],[45,14,45,20],[46,2,46,8],[46,14,46,20],[47,2,47,8],[47,14,47,20],[48,2,48,8],[48,14,48,20],[49,2,49,8],[49,14,49,20],[50,2,50,8],[50,14,50,20],[51,1,51,8],[51,13,51,20],[52,1,52,10],[52,13,52,22],[53,2,53,8],[53,14,53,20],[62,1,62,8],[62,13,62,20],[58,2,58,8],[58,14,58,20],[59,2,59,8],[59,14,59,20],[60,2,60,8],[60,14,60,20],[54,2,54,8],[54,14,54,20],[55,2,55,8],[55,14,55,20],[56,2,56,8],[56,14,56,20],[57,2,57,8],[57,14,57,20],[61,1,61,8],[61,13,61,20]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Note 8","Breakdown of principal adjustments included in last approved balance:"]
[]
[null,"Account 1589 - RSVA Global Adjustment",null,null,null,null,null,null,null,null,null,null,null,"Account 1588 - RSVA Power"]
[null,"Adjustment Description",null,null,null,null,null,null,null,"Amount","To be reversed in current application?","Explanation if not to be reversed in current application",null,"Adjustment Description",null,null,null,null,null,null,null,"Amount","To be Reversed in Current Application?","Explanation if not to be reversed in current application"]
[null,1,"Reversal of prior year CT-148 true-up of GA Charges based on actual Non-RPP volumes",null,null,null,null,null,null,-62824,"No",null,null,1,"CT 148 True-up of GA Chages based on actual RPP volumes",null,null,null,null,null,null,-15769,"No","Reversed in 2024"]
[null,2,"CT 148 true-up of GA Charges based on actual Non-RPP volumes ",null,null,null,null,null,null,15769,"No","Reversed in 2024",null,2,"Reversal of CT 148 true-up GA Charges based on actual RPP volumes",null,null,null,null,null,null,62824,"No","Reversal"]
[null,3,null,null,null,null,null,null,null,null,null,null,null,3]
[null,4,null,null,null,null,null,null,null,null,null,null,null,4]
[null,5,null,null,null,null,null,null,null,null,null,null,null,5]
[null,6,null,null,null,null,null,null,null,null,null,null,null,6]
[null,7,null,null,null,null,null,null,null,null,null,null,null,7]
[null,8,null,null,null,null,null,null,null,null,null,null,null,8]
[null,"Total",null,null,null,null,null,null,null,{"$f":"SUM(J19:J26)","v":-47055},null,null,null,"Total",null,null,null,null,null,null,null,{"$f":"SUM(V19:V26)","v":47055}]
[null,"Total principal adjustments included in last approved balance",null,null,null,null,null,null,null,null,null,null,null,"Total principal adjustments included in last approved balance"]
[null,"Difference",null,null,null,null,null,null,null,{"$f":"J27-J28","v":-47055},null,null,null,"Difference",null,null,null,null,null,null,null,{"$f":"V27-V28","v":47055}]
[]
[]
["Note 9","Principal adjustment reconciliation in current application:"]
[]
[null,"Notes"]
[null,"1) The \"Transaction\" column in the DVA Continuity Schedule is to equal the transactions in the general ledger (excluding transactions relating to the removal of approved disposition amounts as that is shown in a separate column in the DVA Continuity Schedule)"]
[null,"2) Any principal adjustments needed to adjust the transactions in the general ledger to the amount that should be requested for disposition should be shown separately in the \"Principal Adjustments\" column of the DVA Continuity Schedule"]
[null,"3) The \"Variance RRR vs. 2023 Balance\" column in the DVA Continuity Schedule should equal principal adjustments made in the current disposition period. It should not be impacted by reversals from prior year approved principal adjustments."]
[null,"4) Principal adjustments to the pro-ration of CT 148 true-ups (i.e. principal adjustment #1 in tables below) are expected to be equal and offsetting between Account 1588 and Account 1589, if not, please explain. If this results in further adjustments to RPP settlements, this should be shown separately as a principal adjustment to CT 1142/142 (i.e. principal adjustment #2 in tables below)"]
[null,"Complete the table below for the current disposition period. Complete a table for each year included in the balance under review in this rate application. The number of tables to be completed is automatically generated based on data provided in the Information Sheet"]
[]
[null,"Account 1589 - RSVA Global Adjustment",null,null,null,null,null,null,null,null,null,null,null,"Account 1588 - RSVA Power"]
["Year","Adjustment Description",null,null,null,null,null,null,null,"Amount","Year Recorded in GL",null,"Year","Adjustment Description",null,null,null,null,null,null,null,"Amount","Year Recorded in GL"]
[2022,"Reversals of prior approved principal adjustments (auto-populated from table above)",null,null,null,null,null,null,null,null,null,null,2022,"Reversals of prior approved principal adjustments (auto-populated from table above)"]
[null,1,{"$f":"IF(K19=\"Yes\",C19,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(K19=\"Yes\",-J19,\"\")","v":""},null,null,null,1,{"$f":"IF(W19=\"Yes\",O19,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(W19=\"Yes\",-V19,\"\")","v":""}]
[null,2,{"$f":"IF(K20=\"Yes\",C20,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(K20=\"Yes\",-J20,\"\")","v":""},null,null,null,2,{"$f":"IF(W20=\"Yes\",O20,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(W20=\"Yes\",-V20,\"\")","v":""}]
[null,3,"",null,null,null,null,null,null,"",null,null,null,3,"",null,null,null,null,null,null,""]
[null,4,"",null,null,null,null,null,null,"",null,null,null,4,"",null,null,null,null,null,null,""]
[null,5,"",null,null,null,null,null,null,"",null,null,null,5,"",null,null,null,null,null,null,""]
[null,6,"",null,null,null,null,null,null,"",null,null,null,6,"",null,null,null,null,null,null,""]
[null,7,"",null,null,null,null,null,null,"",null,null,null,7,"",null,null,null,null,null,null,""]
[null,8,"",null,null,null,null,null,null,"",null,null,null,8,"",null,null,null,null,null,null,""]
[null,"Total Reversal Principal Adjustments",null,null,null,null,null,null,null,{"$f":"SUM(J44:J51)","v":0},null,null,null,"Total Reversal Principal Adjustments",null,null,null,null,null,null,null,{"$f":"SUM(V44:V51)","v":0}]
[2022,"Current year principal adjustments",null,null,null,null,null,null,null,null,null,null,null,"Current year principal adjustments"]
[null,1,"CT 148 true-up of GA Charges based on actual Non-RPP volumes ",null,null,null,null,null,null,-17861.310954951303,null,null,null,1,"CT 148 true-up of GA Charges based on actual RPP volumes ",null,null,null,null,null,null,17861.310954951303,2024]
[null,2,"Unbilled to actual revenue differences",null,null,null,null,null,null,null,null,null,null,2,"CT 1142/142 true-up based on actuals",null,null,null,null,null,null,67202.937256191421,2024]
[null,3,null,null,null,null,null,null,null,null,null,null,null,3,"Unbilled to actual revenue differences"]
[null,4,null,null,null,null,null,null,null,null,null,null,null,4]
[null,5,null,null,null,null,null,null,null,null,null,null,null,5]
[null,6,null,null,null,null,null,null,null,null,null,null,null,6]
[null,7,null,null,null,null,null,null,null,null,null,null,null,7]
[null,8,null,null,null,null,null,null,null,null,null,null,null,8]
[null,"Total Current Year Principal Adjustments",null,null,null,null,null,null,null,{"$f":"SUM(J54:J61)","v":-17861.310954951303},null,null,null,"Total Current Year Principal Adjustments",null,null,null,null,null,null,null,{"$f":"SUM(V54:V61)","v":85064.248211142723}]
[null,"Total Principal Adjustments to be Included on DVA Continuity Schedule/Tab 3 - IRM Rate Generator Model",null,null,null,null,null,null,null,{"$f":"J62+J52","v":-17861.310954951303},null,null,null,"Total Principal Adjustments to be Included on DVA Continuity Schedule/Tab 3 - IRM Rate Generator Model",null,null,null,null,null,null,null,{"$f":"V62+V52","v":85064.248211142723}]
[]
[]
[]
[null,"Account 1589 - RSVA Global Adjustment",null,null,null,null,null,null,null,null,null,null,null,"Account 1588 - RSVA Power"]
["Year","Adjustment Description",null,null,null,null,null,null,null,"Amount","Year Recorded in GL",null,"Year","Adjustment Description",null,null,null,null,null,null,null,"Amount","Year Recorded in GL"]
[2023,"Reversals of prior year principal adjustments ",null,null,null,null,null,null,null,null,null,null,2023,"Reversals of prior year principal adjustments "]
[null,1,"Reversal of prior year CT-148 true-up of GA Charges based on actual Non-RPP volumes",null,null,null,null,null,null,17861,null,null,null,1,"Reversal of CT 148 true-up of GA Charges based on actual RPP volumes ",null,null,null,null,null,null,-17861]
[null,2,"Reversal of Unbilled to actual revenue differences",null,null,null,null,null,null,null,null,null,null,2,"Reversal of CT 1142/142 true-up based on actuals"]
[null,3,null,null,null,null,null,null,null,null,null,null,null,3,"Reversal of Unbilled to actual revenue differences"]
[null,4,null,null,null,null,null,null,null,null,null,null,null,4]
[null,5,null,null,null,null,null,null,null,null,null,null,null,5]
[null,6,null,null,null,null,null,null,null,null,null,null,null,6]
[null,7,null,null,null,null,null,null,null,null,null,null,null,7]
[null,8,null,null,null,null,null,null,null,null,null,null,null,8]
[null,"Total Reversal Principal Adjustments",null,null,null,null,null,null,null,{"$f":"SUM(J70:J77)","v":17861},null,null,null,"Total Reversal Principal Adjustments",null,null,null,null,null,null,null,{"$f":"SUM(V70:V77)","v":-17861}]
[2023,"Current year principal adjustments",null,null,null,null,null,null,null,null,null,null,2023,"Current year principal adjustments"]
[null,1,"CT 148 true-up of GA Charges based on actual Non-RPP volumes ",null,null,null,null,null,null,28420.970076665501,null,null,null,1,"CT 148 true-up of GA Charges based on actual RPP volumes ",null,null,null,null,null,null,-28420.970076665501]
[null,2,"Unbilled to actual revenue differences",null,null,null,null,null,null,null,null,null,null,2,"Reversal of CT 1142/142 true-up based on actuals",null,null,null,null,null,null,-11320.400000000001]
[null,3,null,null,null,null,null,null,null,null,null,null,null,3,"Unbilled to actual revenue differences"]
[null,4,null,null,null,null,null,null,null,null,null,null,null,4]
[null,5,null,null,null,null,null,null,null,null,null,null,null,5]
[null,6,null,null,null,null,null,null,null,null,null,null,null,6]
[null,7,null,null,null,null,null,null,null,null,null,null,null,7]
[null,8,null,null,null,null,null,null,null,null,null,null,null,8]
[null,"Total Current Year Principal Adjustments",null,null,null,null,null,null,null,{"$f":"SUM(J80:J87)","v":28420.970076665501},null,null,null,"Total Current Year Principal Adjustments",null,null,null,null,null,null,null,{"$f":"SUM(V80:V87)","v":-39741.370076665502}]
[null,"Total Principal Adjustments to be Included on DVA Continuity Schedule/Tab 3 - IRM Rate Generator Model",null,null,null,null,null,null,null,{"$f":"J88+J78","v":46281.970076665501},null,null,null,"Total Principal Adjustments to be Included on DVA Continuity Schedule/Tab 3 - IRM Rate Generator Model",null,null,null,null,null,null,null,{"$f":"V88+V78","v":-57602.370076665502}]
[]
[]
[null,"Account 1589 - RSVA Global Adjustment",null,null,null,null,null,null,null,null,null,null,null,"Account 1588 - RSVA Power"]
["Year","Adjustment Description",null,null,null,null,null,null,null,"Amount","Year Recorded in GL",null,"Year","Adjustment Description",null,null,null,null,null,null,null,"Amount","Year Recorded in GL"]
[null,"Reversals of prior year principal adjustments ",null,null,null,null,null,null,null,null,null,null,null,"Reversals of prior year principal adjustments "]
[null,1,"Reversal of prior year CT-148 true-up of GA Charges based on actual Non-RPP volumes",null,null,null,null,null,null,null,null,null,null,1,"Reversal of CT 148 true-up of GA Charges based on actual RPP volumes "]
[null,2,"Reversal of Unbilled to actual revenue differences",null,null,null,null,null,null,null,null,null,null,2,"Reversal of CT 1142/142 true-up based on actuals"]
[null,3,null,null,null,null,null,null,null,null,null,null,null,3,"Reversal of Unbilled to actual revenue differences"]
[null,4,null,null,null,null,null,null,null,null,null,null,null,4]
[null,5,null,null,null,null,null,null,null,null,null,null,null,5]
[null,6,null,null,null,null,null,null,null,null,null,null,null,6]
[null,7,null,null,null,null,null,null,null,null,null,null,null,7]
[null,8,null,null,null,null,null,null,null,null,null,null,null,8]
[null,"Total Reversal Principal Adjustments",null,null,null,null,null,null,null,{"$f":"SUM(J95:J102)","v":0},null,null,null,"Total Reversal Principal Adjustments",null,null,null,null,null,null,null,{"$f":"SUM(V95:V102)","v":0}]
[null,"Current year principal adjustments",null,null,null,null,null,null,null,null,null,null,null,"Current year principal adjustments"]
[null,1,"CT 148 true-up of GA Charges based on actual Non-RPP volumes ",null,null,null,null,null,null,null,null,null,null,1,"CT 148 true-up of GA Charges based on actual RPP volumes "]
[null,2,"Unbilled to actual revenue differences",null,null,null,null,null,null,null,null,null,null,2,"Reversal of CT 1142/142 true-up based on actuals"]
[null,3,null,null,null,null,null,null,null,null,null,null,null,3,"Unbilled to actual revenue differences"]
[null,4,null,null,null,null,null,null,null,null,null,null,null,4]
[null,5,null,null,null,null,null,null,null,null,null,null,null,5]
[null,6,null,null,null,null,null,null,null,null,null,null,null,6]
[null,7,null,null,null,null,null,null,null,null,null,null,null,7]
[null,8,null,null,null,null,null,null,null,null,null,null,null,8]
[null,"Total Current Year Principal Adjustments",null,null,null,null,null,null,null,{"$f":"SUM(J105:J112)","v":0},null,null,null,"Total Current Year Principal Adjustments",null,null,null,null,null,null,null,{"$f":"SUM(V105:V112)","v":0}]
[null,"Total Principal Adjustments to be Included on DVA Continuity Schedule/Tab 3 - IRM Rate Generator Model",null,null,null,null,null,null,null,{"$f":"J113+J103","v":0},null,null,null,"Total Principal Adjustments to be Included on DVA Continuity Schedule/Tab 3 - IRM Rate Generator Model",null,null,null,null,null,null,null,{"$f":"V113+V103","v":0}]
[]
[]
[null,"Account 1589 - RSVA Global Adjustment",null,null,null,null,null,null,null,null,null,null,null,"Account 1588 - RSVA Power"]
["Year","Adjustment Description",null,null,null,null,null,null,null,"Amount","Year Recorded in GL",null,"Year","Adjustment Description",null,null,null,null,null,null,null,"Amount","Year Recorded in GL"]
[null,"Reversals of prior year principal adjustments ",null,null,null,null,null,null,null,null,null,null,null,"Reversals of prior year principal adjustments "]
[null,1,"Reversal of prior year CT-148 true-up of GA Charges based on actual Non-RPP volumes",null,null,null,null,null,null,null,null,null,null,1,"Reversal of CT 148 true-up of GA Charges based on actual RPP volumes "]
[null,2,"Reversal of Unbilled to actual revenue differences",null,null,null,null,null,null,null,null,null,null,2,"Reversal of CT 1142/142 true-up based on actuals"]
[null,3,null,null,null,null,null,null,null,null,null,null,null,3,"Reversal of Unbilled to actual revenue differences"]
[null,4,null,null,null,null,null,null,null,null,null,null,null,4]
[null,5,null,null,null,null,null,null,null,null,null,null,null,5]
[null,6,null,null,null,null,null,null,null,null,null,null,null,6]
[null,7,null,null,null,null,null,null,null,null,null,null,null,7]
[null,8,null,null,null,null,null,null,null,null,null,null,null,8]
[null,"Total Reversal Principal Adjustments",null,null,null,null,null,null,null,{"$f":"SUM(J120:J127)","v":0},null,null,null,"Total Reversal Principal Adjustments",null,null,null,null,null,null,null,{"$f":"SUM(V120:V127)","v":0}]
[null,"Current year principal adjustments",null,null,null,null,null,null,null,null,null,null,null,"Current year principal adjustments"]
[null,1,"CT 148 true-up of GA Charges based on actual Non-RPP volumes ",null,null,null,null,null,null,null,null,null,null,1,"CT 148 true-up of GA Charges based on actual RPP volumes "]
[null,2,"Unbilled to actual revenue differences",null,null,null,null,null,null,null,null,null,null,2,"Reversal of CT 1142/142 true-up based on actuals"]
[null,3,null,null,null,null,null,null,null,null,null,null,null,3,"Unbilled to actual revenue differences"]
[null,4,null,null,null,null,null,null,null,null,null,null,null,4]
[null,5,null,null,null,null,null,null,null,null,null,null,null,5]
[null,6,null,null,null,null,null,null,null,null,null,null,null,6]
[null,7,null,null,null,null,null,null,null,null,null,null,null,7]
[null,8,null,null,null,null,null,null,null,null,null,null,null,8]
[null,"Total Current Year Principal Adjustments",null,null,null,null,null,null,null,{"$f":"SUM(J130:J137)","v":0},null,null,null,"Total Current Year Principal Adjustments",null,null,null,null,null,null,null,{"$f":"SUM(V130:V137)","v":0}]
[null,"Total Principal Adjustments to be Included on DVA Continuity Schedule/Tab 3 - IRM Rate Generator Model",null,null,null,null,null,null,null,{"$f":"J138+J128","v":0},null,null,null,"Total Principal Adjustments to be Included on DVA Continuity Schedule/Tab 3 - IRM Rate Generator Model",null,null,null,null,null,null,null,{"$f":"V138+V128","v":0}]
[]
[]
[null,"Account 1589 - RSVA Global Adjustment",null,null,null,null,null,null,null,null,null,null,null,"Account 1588 - RSVA Power"]
["Year","Adjustment Description",null,null,null,null,null,null,null,"Amount","Year Recorded in GL",null,"Year","Adjustment Description",null,null,null,null,null,null,null,"Amount","Year Recorded in GL"]
[null,"Reversals of prior year principal adjustments ",null,null,null,null,null,null,null,null,null,null,null,"Reversals of prior year principal adjustments "]
[null,1,"Reversal of prior year CT-148 true-up of GA Charges based on actual Non-RPP volumes",null,null,null,null,null,null,null,null,null,null,1,"Reversal of CT 148 true-up of GA Charges based on actual RPP volumes "]
[null,2,"Reversal of Unbilled to actual revenue differences",null,null,null,null,null,null,null,null,null,null,2,"Reversal of CT 1142 true-up based on actuals"]
[null,3,null,null,null,null,null,null,null,null,null,null,null,3,"Reversal of Unbilled to actual revenue differences"]
[null,4,null,null,null,null,null,null,null,null,null,null,null,4]
[null,5,null,null,null,null,null,null,null,null,null,null,null,5]
[null,6,null,null,null,null,null,null,null,null,null,null,null,6]
[null,7,null,null,null,null,null,null,null,null,null,null,null,7]
[null,8,null,null,null,null,null,null,null,null,null,null,null,8]
[null,"Total Reversal Principal Adjustments",null,null,null,null,null,null,null,{"$f":"SUM(J145:J152)","v":0},null,null,null,"Total Reversal Principal Adjustments",null,null,null,null,null,null,null,{"$f":"SUM(V145:V152)","v":0}]
[null,"Current year principal adjustments",null,null,null,null,null,null,null,null,null,null,null,"Current year principal adjustments"]
[null,1,"CT 148 true-up of GA Charges based on actual Non-RPP volumes ",null,null,null,null,null,null,null,null,null,null,1,"CT 148 true-up of GA Charges based on actual RPP volumes "]
[null,2,"Unbilled to actual revenue differences",null,null,null,null,null,null,null,null,null,null,2,"CT 1142 true-up based on actuals"]
[null,3,null,null,null,null,null,null,null,null,null,null,null,3,"Unbilled to actual revenue differences"]
[null,4,null,null,null,null,null,null,null,null,null,null,null,4]
[null,5,null,null,null,null,null,null,null,null,null,null,null,5]
[null,6,null,null,null,null,null,null,null,null,null,null,null,6]
[null,7,null,null,null,null,null,null,null,null,null,null,null,7]
[null,8,null,null,null,null,null,null,null,null,null,null,null,8]
[null,"Total Current Year Principal Adjustments",null,null,null,null,null,null,null,{"$f":"SUM(J155:J162)","v":0},null,null,null,"Total Current Year Principal Adjustments",null,null,null,null,null,null,null,{"$f":"SUM(V155:V162)","v":0}]
[null,"Total Principal Adjustments to be Included on DVA Continuity Schedule/Tab 3 - IRM Rate Generator Model",null,null,null,null,null,null,null,{"$f":"J163+J153","v":0},null,null,null,"Total Principal Adjustments to be Included on DVA Continuity Schedule/Tab 3 - IRM Rate Generator Model",null,null,null,null,null,null,null,{"$f":"V163+V153","v":0}]
[]
[]
[null,"Account 1589 - RSVA Global Adjustment",null,null,null,null,null,null,null,null,null,null,null,"Account 1588 - RSVA Power"]
["Year","Adjustment Description",null,null,null,null,null,null,null,"Amount","Year Recorded in GL",null,"Year","Adjustment Description",null,null,null,null,null,null,null,"Amount","Year Recorded in GL"]
[null,"Reversals of prior year principal adjustments ",null,null,null,null,null,null,null,null,null,null,null,"Reversals of prior year principal adjustments "]
[null,1,"Reversal of prior year CT-148 true-up of GA Charges based on actual Non-RPP volumes",null,null,null,null,null,null,null,null,null,null,1,"Reversal of CT 148 true-up of GA Charges based on actual RPP volumes "]
[null,2,"Reversal of Unbilled to actual revenue differences",null,null,null,null,null,null,null,null,null,null,2,"Reversal of CT 1142 true-up based on actuals"]
[null,3,null,null,null,null,null,null,null,null,null,null,null,3,"Reversal of Unbilled to actual revenue differences"]
[null,4,null,null,null,null,null,null,null,null,null,null,null,4]
[null,5,null,null,null,null,null,null,null,null,null,null,null,5]
[null,6,null,null,null,null,null,null,null,null,null,null,null,6]
[null,7,null,null,null,null,null,null,null,null,null,null,null,7]
[null,8,null,null,null,null,null,null,null,null,null,null,null,8]
[null,"Total Reversal Principal Adjustments",null,null,null,null,null,null,null,{"$f":"SUM(J170:J177)","v":0},null,null,null,"Total Reversal Principal Adjustments",null,null,null,null,null,null,null,{"$f":"SUM(V170:V177)","v":0}]
[null,"Current year principal adjustments",null,null,null,null,null,null,null,null,null,null,null,"Current year principal adjustments"]
[null,1,"CT 148 true-up of GA Charges based on actual Non-RPP volumes ",null,null,null,null,null,null,null,null,null,null,1,"CT 148 true-up of GA Charges based on actual RPP volumes "]
[null,2,"Unbilled to actual revenue differences",null,null,null,null,null,null,null,null,null,null,2,"CT 1142 true-up based on actuals"]
[null,3,null,null,null,null,null,null,null,null,null,null,null,3,"Unbilled to actual revenue differences"]
[null,4,null,null,null,null,null,null,null,null,null,null,null,4]
[null,5,null,null,null,null,null,null,null,null,null,null,null,5]
[null,6,null,null,null,null,null,null,null,null,null,null,null,6]
[null,7,null,null,null,null,null,null,null,null,null,null,null,7]
[null,8,null,null,null,null,null,null,null,null,null,null,null,8]
[null,"Total Current Year Principal Adjustments",null,null,null,null,null,null,null,{"$f":"SUM(J180:J187)","v":0},null,null,null,"Total Current Year Principal Adjustments",null,null,null,null,null,null,null,{"$f":"SUM(V180:V187)","v":0}]
[null,"Total Principal Adjustments to be Included on DVA Continuity Schedule/Tab 3 - IRM Rate Generator Model",null,null,null,null,null,null,null,{"$f":"J188+J178","v":0},null,null,null,"Total Principal Adjustments to be Included on DVA Continuity Schedule/Tab 3 - IRM Rate Generator Model",null,null,null,null,null,null,null,{"$f":"V188+V178","v":0}]

{"sheet":"GA Rates","index":12,"n_rows":31,"n_cols":28,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["GA Rates per IESO website"]
[null,2020,null,null,null,2019,null,null,null,2018,null,null,null,2017,null,null,null,2016,null,null,null,2015,null,null,null,2014]
["($/kWh)","First Estimate","Second Estimate","Actual","($/kWh)","First Estimate","Second Estimate","Actual","($/kWh)","First Estimate","Second Estimate","Actual","($/kWh)","First Estimate","Second Estimate","Actual","($/kWh)","First Estimate","Second Estimate","Actual","($/kWh)","First Estimate","Second Estimate","Actual","($/kWh)","First Estimate","Second Estimate","Actual"]
["January",8.3229999999999998E-2,9.9930000000000005E-2,0.10231999999999999,"January",6.7409999999999998E-2,8.3060000000000009E-2,8.0920000000000006E-2,"January",8.7770000000000001E-2,6.3700000000000007E-2,6.7360000000000003E-2,"January",6.6869999999999999E-2,8.677E-2,8.2269999999999996E-2,"January",8.4229999999999999E-2,9.214E-2,9.1789999999999997E-2,"January",5.5490000000000005E-2,6.1609999999999998E-2,5.0680000000000003E-2,"January",3.6260000000000001E-2,1.806E-2,1.261E-2]
["February",0.12451000000000001,0.11434999999999999,0.11331000000000001,"February",9.6569999999999989E-2,8.2360000000000003E-2,8.8120000000000004E-2,"February",7.3329999999999992E-2,7.7049999999999993E-2,8.1670000000000006E-2,"February",0.10559,8.43E-2,8.6389999999999995E-2,"February",0.10384,9.6780000000000005E-2,9.851E-2,"February",6.9809999999999997E-2,4.095E-2,3.9609999999999999E-2,"February",2.231E-2,1.1180000000000001E-2,1.3300000000000001E-2]
["March",0.10432,0.11212000000000001,0.11942,"March",8.1049999999999997E-2,7.5749999999999998E-2,8.0409999999999995E-2,"March",7.8769999999999993E-2,8.5949999999999999E-2,9.4810000000000005E-2,"March",8.4089999999999998E-2,6.8860000000000005E-2,7.1349999999999997E-2,"March",9.0219999999999995E-2,0.10299,0.1061,"March",3.6040000000000003E-2,5.74E-2,6.2899999999999998E-2,"March",1.103E-2,-8.0000000000000002E-3,-2.7E-4]
["April",0.13707,0.115,0.115,"April",8.1290000000000001E-2,0.12487999999999999,0.12333,"April",9.8099999999999993E-2,0.10074,9.9589999999999998E-2,"April",6.8739999999999996E-2,0.10218000000000001,0.10778,"April",0.12114999999999999,0.11176999999999999,0.11132,"April",6.7049999999999998E-2,9.2679999999999998E-2,9.5590000000000008E-2,"April",-9.6500000000000006E-3,5.4530000000000002E-2,5.1979999999999998E-2]
["May",9.2930000000000013E-2,0.115,0.115,"May",0.12859999999999999,0.13049000000000002,0.12604000000000001,"May",9.3920000000000003E-2,0.13199,0.10793000000000001,"May",0.10623,0.12776000000000001,0.12307,"May",0.10405,0.11493,0.10749,"May",9.4159999999999994E-2,9.7299999999999998E-2,9.6680000000000002E-2,"May",5.3560000000000003E-2,7.3520000000000002E-2,7.1959999999999996E-2]
["June",0.115,0.115,0.115,"June",0.12444,0.14771999999999999,0.13728000000000001,"June",0.13336000000000001,0.10238999999999999,0.11896,"June",0.11954000000000001,0.12562999999999999,0.11848,"June",0.11650000000000001,9.3600000000000003E-2,9.5449999999999993E-2,"June",9.2280000000000001E-2,9.7680000000000003E-2,9.5400000000000013E-2,"June",7.1900000000000006E-2,6.6640000000000005E-2,6.0249999999999998E-2]
["July",0.10305,9.493E-2,9.9019999999999997E-2,"July",0.13527,8.8540000000000008E-2,9.6450000000000008E-2,"July",8.5019999999999998E-2,8.1230000000000011E-2,7.7370000000000008E-2,"July",0.10651999999999999,0.10197000000000001,0.1128,"July",7.6670000000000002E-2,8.412E-2,8.3059999999999995E-2,"July",8.8880000000000001E-2,8.4129999999999996E-2,7.8829999999999997E-2,"July",5.9760000000000001E-2,5.7529999999999998E-2,6.2560000000000004E-2]
["August",0.10231999999999999,0.10621999999999999,0.10348,"August",7.2109999999999994E-2,0.10973999999999999,0.12606999999999999,"August",7.7900000000000011E-2,7.324E-2,7.4900000000000008E-2,"August",0.115,0.10476000000000001,0.10109,"August",8.5690000000000002E-2,7.0499999999999993E-2,7.1029999999999996E-2,"August",8.8050000000000003E-2,7.3550000000000004E-2,8.0099999999999991E-2,"August",6.1079999999999995E-2,6.8970000000000004E-2,6.7610000000000003E-2]
["September",0.11573,0.12792000000000001,0.12176000000000001,"September",0.12934000000000001,0.16391999999999998,0.12262999999999999,"September",8.4239999999999995E-2,8.6599999999999996E-2,8.584E-2,"September",0.12739,9.8949999999999996E-2,8.8639999999999997E-2,"September",7.0599999999999996E-2,9.1480000000000006E-2,9.5310000000000006E-2,"September",8.270000000000001E-2,7.1910000000000002E-2,6.7030000000000006E-2,"September",8.0489999999999992E-2,8.072E-2,7.9629999999999992E-2]
["October",0.14953999999999998,0.13266,0.12806000000000001,"October",0.17877999999999999,0.11885999999999999,0.1368,"October",8.9209999999999998E-2,0.11998,0.12059,"October",0.10212,0.11973,0.12562999999999999,"October",9.7199999999999995E-2,0.1178,0.11226,"October",6.3710000000000003E-2,7.1929999999999994E-2,7.5439999999999993E-2,"October",7.492E-2,0.10135,0.10014000000000001]
["November ",0.1167,0.1142,0.11705,"November ",0.10726999999999999,0.10109,9.9530000000000007E-2,"November ",0.12235,0.10540000000000001,9.8549999999999999E-2,"November ",0.11164,9.6689999999999998E-2,9.7040000000000001E-2,"November ",0.12271,0.115,0.11108999999999999,"November ",7.6230000000000006E-2,0.12447999999999999,0.11320000000000001,"November ",9.9010000000000001E-2,8.5040000000000004E-2,8.231999999999999E-2]
["December",0.10704000000000001,0.10031,0.10557999999999999,"December",8.5690000000000002E-2,9.0659999999999991E-2,9.3209999999999987E-2,"December",9.1980000000000006E-2,7.0669999999999997E-2,7.4040000000000009E-2,"December",8.3909999999999998E-2,9.6689999999999998E-2,9.2069999999999999E-2,"December",0.10594000000000001,7.8719999999999998E-2,8.7080000000000005E-2,"December",0.11462,8.8090000000000002E-2,9.4709999999999989E-2,"December",7.3180000000000009E-2,5.7889999999999997E-2,7.4439999999999992E-2]
[]
[]
[null,2021,null,null,null,2022,null,null,null,2023]
["($/kWh)","First Estimate","Second Estimate","Actual","($/kWh)","First Estimate","Second Estimate","Actual","($/kWh)","First Estimate","Second Estimate","Actual"]
["January",9.0919999999999987E-2,9.1820000000000013E-2,8.7980000000000003E-2,"January",4.829E-2,4.514E-2,4.3529999999999999E-2,"January",3.1379999999999998E-2,5.1450000000000003E-2,5.3770000000000005E-2]
["February",0.10485000000000001,4.2559999999999994E-2,5.7510000000000006E-2,"February",5.0189999999999999E-2,5.3249999999999999E-2,5.246E-2,"February",6.2850000000000003E-2,8.3699999999999997E-2,8.2489999999999994E-2]
["March",8.4199999999999997E-2,9.8390000000000005E-2,9.6679999999999988E-2,"March",5.5E-2,5.3859999999999998E-2,5.9409999999999998E-2,"March",6.9889999999999994E-2,6.8640000000000007E-2,8.0310000000000006E-2]
["April",6.9690000000000002E-2,0.12595999999999999,0.11589000000000001,"April",5.9150000000000001E-2,8.6400000000000005E-2,8.2930000000000004E-2,"April",8.2489999999999994E-2,0.11617,9.8530000000000006E-2]
["May",0.10531,0.10690999999999999,0.10675,"May",5.9679999999999997E-2,8.6849999999999997E-2,8.4750000000000006E-2,"May",8.2489999999999994E-2,9.3840000000000007E-2,9.962E-2]
["June",0.11352000000000001,9.4890000000000002E-2,9.2159999999999992E-2,"June",8.2930000000000004E-2,8.7639999999999996E-2,7.868E-2,"June",9.8530000000000006E-2,8.9719999999999994E-2,8.2930000000000004E-2]
["July",7.6120000000000007E-2,7.8200000000000006E-2,7.9179999999999987E-2,"July",8.4750000000000006E-2,3.7039999999999997E-2,4.0079999999999998E-2,"July",9.962E-2,5.1049999999999998E-2,4.9489999999999999E-2]
["August",8.7340000000000001E-2,5.33E-2,5.1069999999999997E-2,"August",4.8710000000000003E-2,3.4000000000000002E-4,4.9899999999999996E-3,"August",5.3770000000000005E-2,5.1540000000000002E-2,7.6060000000000003E-2]
["September",5.5189999999999996E-2,7.2419999999999984E-2,8.2339999999999997E-2,"September",4.0079999999999998E-2,2.7550000000000002E-2,3.2410000000000001E-2,"September",5.8369999999999998E-2,7.4540000000000009E-2,5.0930000000000003E-2]
["October",7.4020000000000016E-2,6.8640000000000007E-2,5.8400000000000001E-2,"October",4.9899999999999996E-3,6.8029999999999993E-2,5.7709999999999997E-2,"October",7.3319999999999996E-2,8.4330000000000002E-2,8.498E-2]
["November ",6.341999999999999E-2,5.8449999999999995E-2,6.0120000000000007E-2,"November ",4.7390000000000002E-2,6.719E-2,6.9889999999999994E-2,"November ",7.0400000000000004E-2,8.2879999999999995E-2,7.0900000000000005E-2]
["December",5.4430000000000006E-2,5.9179999999999996E-2,6.515E-2,"December",5.9619999999999999E-2,3.5810000000000002E-2,3.4270000000000002E-2,"December",8.3400000000000002E-2,6.7589999999999997E-2,6.6220000000000001E-2]

{"sheet":"4705","index":13,"n_rows":81,"n_cols":8,"rows_kept":81,"cut":false,"hidden":true,"merged":[]}
["Account 4705"]
["Time run: 6/16/2023 2:08:39 PM"]
[]
[null,null,2018,2019,2020,2021,2022,2023]
["Company Name","Licence Number","January 1, 2017 - December 31, 2017","January 1, 2018 - December 31, 2018","January 1, 2019 - December 31, 2019","January 1, 2020 - December 31, 2020","January 1, 2021 - December 31, 2021","January 1, 2022 - December 31, 2022"]
["Alectra Utilities Corporation","ED-2016-0360",1014890149,1180134300,1262398966.51,1628605783.3699999,1587460828.1600001,1928803305.6199999]
["Algoma Power Inc.","ED-2009-0072",12703182.199999999,13063801.970000001,13556749.18,18497291.18,17294634.309999999,20309052.260000002]
["Atikokan Hydro Inc.","ED-2003-0001",397310.71,329699.33,89266.37,385682.53,1003765.04,2347181.92]
["Bluewater Power Distribution Corporation","ED-2002-0517",42563174.759999998,45004208,44193152,56514280,54771604,63453240]
["Brantford Power Inc.","ED-2003-0060",44881232.030000001,47321659.149999999,48265531.009999998,59756414.990000002,58725319.359999999]
["Burlington Hydro Inc.","ED-2003-0004",86580144.079999998,89918883.590000004,85146095.049999997,114488823.8,105226413.13,119337932.5]
["Canadian Niagara Power Inc.","ED-2002-0572",28867682.5,29490087.379999999,29561762.32,39962506.689999998,36235752.899999999,40820116.530000001]
["Centre Wellington Hydro Ltd.","ED-2002-0498",7411980.1399999997,7599130.8200000003,7568699.6600000001,10020335.300000001,9723758.1699999999,11232528.9]
["Chapleau Public Utilities Corporation","ED-2002-0528",1704549.43,1745868.6,2042894.82,2513469.4,2039731.37,2210741.08]
["Cooperative Hydro Embrun Inc.","ED-2002-0493",-272036.92,2544543.5099999998,2082241.89,3456791,2953541.63,3070299.62]
["Cornwall Street Railway Light and Power Company Limited","ED-2004-0405",null,null,null,0,0,0]
["E.L.K. Energy Inc.","ED-2003-0015",13936404.98,12890539.93,12777701.310000001,17463622.809999999,14884669.439999999,22814971.280000001]
["Elexicon Energy Inc.","ED-2019-0128",null,null,139698760.25,261647627.69999999,244640671.69999999,277073506.75]
["Energy Plus Inc.","ED-2002-0574",82040566.909999996,75202638.019999996,65605109.240000002,98606054.680000007,98823259.620000005]
["Enersource Hydro Mississauga Inc.","ED-2003-0017"]
["Enova Power Corp.","ED-2022-0006",null,null,null,null,null,271270155.58999997]
["Entegrus Powerlines Inc.","ED-2002-0563",94527381.709999993,117578734.59999999,123877363.59,141975433.80000001,123497841.73999999,96266067.920000002]
["ENWIN Utilities Ltd.","ED-2002-0527",107796308.70999999,112529652,107355893.69,138280156.55000001,129117342.93000001,148694797.75999999]
["EPCOR Electricity Distribution Ontario Inc.","ED-2002-0518",17731802.379999999,18275384.34,18820762.620000001,25073322.600000001,29803273.300000001,29290281.460000001]
["ERTH Power Corporation","ED-2002-0516",1111131.07,5284996.4000000004,1831305.86,5239494,15747795.92,39151724.119999997]
["Espanola Regional Hydro Distribution Corporation","ED-2002-0502",6034566.2699999996,5446767.7599999998,5885076.6299999999,7523773.7199999997,6076580.6399999997]
["Essex Powerlines Corporation","ED-2002-0499",31221321.559999999,32410120.16,32238763.390000001,43869065.460000001,41670641.189999998,44319843.859999999]
["Festival Hydro Inc.","ED-2002-0513",24576757.550000001,26626313.629999999,24752757.620000001,29283484.32,26844832.84,32341931.039999999]
["Fort Frances Power Corporation","ED-2003-0028",5767375.4400000004,5292599.45,5754441.7400000002,7434773.8300000001,6235507.8300000001,6769196.7199999997]
["GrandBridge Energy Inc.","ED-2021-0280",null,null,null,null,null,189666698.38]
["Greater Sudbury Hydro Inc.","ED-2002-0559",57062553.43,54892983.539999999,58048633.82,74877687.870000005,64974529.25,71835133.390000001]
["Grimsby Power Incorporated","ED-2002-0554",11387955.01,12230205.51,12576544.720000001,16901949.109999999,16900119.640000001,18991786.239999998]
["Guelph Hydro Electric Systems Inc.","ED-2002-0565",126442921.06,93136363.629999995]
["Haldimand County Hydro Inc.","ED-2002-0539"]
["Halton Hills Hydro Inc.","ED-2002-0552",26372895.170000002,25384688.260000002,28559829.199999999,36876214.270000003,34977452.359999999,39169215.460000001]
["Hearst Power Distribution Company Limited","ED-2002-0533",4174712.46,4172913,4277988.51,4917885.74,4680133.42,5574113.2699999996]
["Horizon Utilities Corporation","ED-2006-0031"]
["Hydro 2000 Inc.","ED-2002-0542",1688797.41,621818.44999999995,1068208.45,2204989.6800000002,1903075.25,1712337.91]
["Hydro Hawkesbury Inc.","ED-2003-0027",7285143.2599999998,7290411.3499999996,6807619.5899999999,7725953.8700000001,8754975.4299999997,9952178.6400000006]
["Hydro One Brampton Networks Inc.","ED-2003-0038"]
["Hydro One Networks Inc.","ED-2003-0043",388880263.69999999,664302318.10000002,512373616.77999997,2339278786.5700002,2158788306.1599998,2413023305.2800002]
["Hydro One Networks Inc. (Orillia-Peterborough service areas)","ED-2002-0530",17552161,17981951,18185635,22845407]
["Hydro One Networks Inc. - 1937680 Ontario Inc. (Peterborough Distribution)","ED-2002-0504",46080864.5,44871359.960000001,46242861.969999999,61884632.210000001]
["Hydro One Remote Communities Inc.","ED-2003-0037",25079.72,14212.27,1462979.54,1778723.8400000001,1583795.98,840942.17]
["Hydro Ottawa Limited","ED-2002-0556",759072358.29999995,378957228.50999999,373128686.88999999,479451463.51999998,461324159.35000002,535123899]
["InnPower Corporation","ED-2002-0520",18126688.77,17889560.809999999,19090131.379999999,29318209.649999999,25744519.789999999,27152901.760000002]
["Kenora Hydro Electric Corporation Ltd.","ED-2003-0030",6295825,6090944]
["Kingston Hydro Corporation","ED-2003-0057",32853710,34240773,34201059.57,41587045.840000004,39681134.859999999,48278579.939999998]
["Kitchener-Wilmot Hydro Inc.","ED-2002-0573",106137759.09,106160556.36,105280940.18000001,144381328.34999999,130326507.75]
["Lakefront Utilities Inc.","ED-2002-0545",12802250.359999999,11215248.220000001,12678046.93,16205224.24,15520683.74,18333153.579999998]
["Lakeland Power Distribution Ltd.","ED-2002-0540",17922134.469999999,17748995.34,18598237.460000001,23447665.559999999,21759916.370000001,24875149.48]
["London Hydro Inc.","ED-2002-0557",169355007.91999999,175704100.40000001,174762988.68000001,231765489.18000001,216185837.41999999,248668253.05000001]
["Midland Power Utility Corporation","ED-2002-0541",1612702.45]
["Milton Hydro Distribution Inc.","ED-2003-0014",45651670,48076620,47312834,63900115,61853099,72915590]
["Newmarket-Tay Power Distribution Ltd.","ED-2007-0624",40184380.899999999,64958062.039999999,76962052.510000005,54343328.530000001,61340756.710000001,64534435.509999998]
["Niagara Peninsula Energy Inc.","ED-2007-0749",65298861.719999999,65058587.340000004,61169795.479999997,79138273.469999999,76452462.969999999,90140193.060000002]
["Niagara-on-the-Lake Hydro Inc.","ED-2002-0547",12445325.01,12837074.210000001,13078378.51,16824688.170000002,15623253.439999999,17187656.289999999]
["North Bay Hydro Distribution Limited","ED-2003-0024",29218002.260000002,29058366.870000001,29045952.149999999,37007826.509999998,34006395.390000001,43127525.859999999]
["Northern Ontario Wires Inc.","ED-2003-0018",6214844.5899999999,6288047.5700000003,6516422.5700000003,7952951.8499999996,7512027.6299999999,8745393.2300000004]
["Oakville Hydro Electricity Distribution Inc.","ED-2003-0135",71230904.579999998,82140257.010000005,69711904.370000005,112368335.40000001,103018031.34,116245729.67]
["Orangeville Hydro Limited","ED-2002-0500",14138779.640000001,14336792,14165804.210000001,18230291.34,17453963.82,20735581.449999999]
["Oshawa PUC Networks Inc.","ED-2002-0560",63307617.149999999,64828533,59002842.560000002,85219781.430000007,68629169.349999994,83011108.5]
["Ottawa River Power Corporation","ED-2003-0033",12917295.689999999,12334020.279999999,11163089.779999999,15961225.439999999,15013713.060000001,15824003.039999999]
["PowerStream Inc.","ED-2004-0420"]
["PUC Distribution Inc.","ED-2002-0546",68428557.719999999,61672850.939999998,69598321.280000001,79247240.469999999,63431384.979999997,63731010.600000001]
["Renfrew Hydro Inc.","ED-2002-0577",4874471.74,4916429.3499999996,5050519.8600000003,6482912.75,5962443.1900000004,6852144.5199999996]
["Rideau St. Lawrence Distribution Inc.","ED-2003-0003",6697181.1900000004,6582824.8799999999,6823526.6100000003,8891577.7699999996,7927866.4100000001,9548838.2599999998]
["Sioux Lookout Hydro Inc.","ED-2002-0514",5223541.4400000004,4565190.7300000004,5160942.6900000004,6666605.0300000003,5667570.8099999996,7076068.3399999999]
["St. Thomas Energy Inc.","ED-2002-0523",28175317.09]
["Synergy North Corporation","ED-2018-0233",null,null,59045091.630000003,73228636.870000005,69498202.530000001,78063817.310000002]
["Thunder Bay Hydro Electricity Distribution Inc.","ED-2002-0529",52844523.130000003,50944829.520000003]
["Tillsonburg Hydro Inc.","ED-2003-0026",8932078.9399999995,9412935.5700000003,8673930.75,11469020.140000001,11847987.779999999,13832753.82]
["Toronto Hydro-Electric System Limited","ED-2002-0497",1172692119.4300001,1225222494.6600001,1189125381.54,1503809264,1440535653.01,1712083694.4400001]
["Veridian Connections Inc.","ED-2002-0503",134681655,141704997]
["Wasaga Distribution Inc.","ED-2002-0544",10729581.99,10210077.720000001,11221742.51,16113117.07,13831191.039999999,14296845.75]
["Waterloo North Hydro Inc.","ED-2002-0575",72628032,76715892,73606674,96399343,93436100]
["Welland Hydro-Electric System Corp.","ED-2003-0002",22156613.199999999,23449528.82,23188616.43,30564009.969999999,28294072.030000001,31153551.789999999]
["Wellington North Power Inc.","ED-2002-0511",3694395.83,4038573.45,3814397.74,5060328.3600000003,5367008.08,6856507.7199999997]
["West Coast Huron Energy Inc.","ED-2002-0510",4405864,4497254]
["Westario Power Inc.","ED-2002-0515",23401325,22977534.239999998,24451221.91,34071696.280000001,32497492.739999998,35342409.649999999]
["Whitby Hydro Electric Corporation","ED-2002-0571",50031791.950000003,50907415.159999996]

{"sheet":"RRR_2017","index":14,"n_rows":69,"n_cols":22,"rows_kept":69,"cut":false,"hidden":true,"merged":[[0,0,0,7],[1,0,1,7]]}
["2.1.5 TotalConsumptionData_Dist_Ret_Total_Combined_Without RateClass_2018"]
["Time run: 5/29/2018 3:56:03 PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H + F + J","F + J"]
["Filing_Year","Company_Name",null,null,null,"Ret_Metered_consumption_in_kWhs","Ret_Metered_consumption_in_kWs","Dist_RPPMeterCustkWh","Dist_RPPMeterCustkW","Dist_NonRPPMeterCustkWh","Dist_NonRPPMeterCustkW","IESOMeterCustkWh","IESOMeterCustKW","Class_A_Consumption_kWhs","Class_A_Consumption_kWs","TotConsmptionforDistCustkWh","TotConsmptionforDistCustkW","Calculated_TOTAL_KWH","Calculated_TOTAL_KW","Total Metered Excluding WMP","Non RPP"]
["2018","ALECTRA UTILITIES CORPORATION",null,null,null,2735166167,5493928,8730758764,3183669,9692001985,23895726,811776337,1381122,3450770317,6672805,19234537086,28460517,21969703253,33954445,21157926916,12427168152]
["2018","ALECTRA UTILITIES - GUELPH",null,null,null,197114360.37,375574,477444082.88,94778.64,921412854.80999994,2146272.7000000002,6196613.7000000002,13103.85,562293627.92999995,1084589.18,1405053551.3900001,2254155.19,1602167911.76,2629729.92,1595971298.0599999,1118527215.1799998]
["2018","ALGOMA POWER INC.",null,null,null,7589178.4400000004,8592,107041096.09,9869.01,88433502.849999994,192374.8,0,0,58917721.789999999,99618.3,195474598.94,202243.81,203063777.38,210836.14,203063777.38,96022681.289999992]
["2018","ATIKOKAN HYDRO INC.",null,null,null,1232089.98,2603,13371836.82,0,15005971.630000001,42253.94,0,0,4563646.5599999996,18088.38,28377808.449999999,42253.94,29609898.43,44857.54,29609898.43,16238061.610000001]
["2018","BLUEWATER POWER DISTRIBUTION CORPORATION",null,null,null,60613020,100189,360840844,96062,439293405,938025,116775525,190405,280305798,480944,916909774,1224492,977522794,1324681,860747269,499906425]
["2018","BRANTFORD POWER INC.",null,null,null,158219509.30000001,332352,383768359.55000001,112785.16,350272883.18000001,978161.98,49798281,119621.52,116262049,226480.18,783839523.73000002,1210568.6599999999,942059033.02999997,1542920.96,892260752.02999997,508492392.48000002]
["2018","BURLINGTON HYDRO INC.",null,null,null,176577660,405566,762645853,366461,617809779,1631018,0,0,126515929,310497,1380455632,1997479,1557033292,2403045,1557033292,794387439]
["2018","CANADIAN NIAGARA POWER INC.",null,null,null,29686787.5,33427,254865795.34,45229.73,168246626.28999999,528462.72,0,0,58621262.450000003,176722.29,423112421.63,573692.44999999995,452799209.13,607120.19999999995,452799209.13,197933413.78999999]
["2018","CENTRE WELLINGTON HYDRO LTD.",null,null,null,15455698,22790,61928647,5373.88,57244721,150396.32,2990901.7,5479.21,0,0,122164269.7,161249.41,137619967.69999999,184040.21,134629066,72700419]
["2018","CHAPLEAU PUBLIC UTILITIES CORPORATION",null,null,null,478450,750,17529372,826.69,6565386,16771,0,0,0,0,24094758,17597.689999999999,24573208,18348.29,24573208,7043836]
["2018","COOPERATIVE HYDRO EMBRUN INC.",null,null,null,798369,0,23247457,0,3782579,11209,0,0,0,0,27030036,11209,27828405,11209,27828405,4580948]
["2018","ELEXICON ENERGY INC.-VERIDIAN RATE ZONE",null,null,null,250846891,390824,1202178782,257570,1017409890,2245224,38095925,74250,413770175,787331,2257684597,2577044,2508531488,2967868,2470435563,1268256781]
["2018","ELEXICON ENERGY INC.-WHITBY RATE ZONE",null,null,null,106725615,185907,449207866,135039,263146477,601259,4279141,8605,98787815,171705,716633484,744903,823359099,930810,819079958,369872092]
["2018","E.L.K. ENERGY INC.",null,null,null,1,1,107468847,7540,112352023,187474,0,0,10527574,55609,219820870,195014,219820871,195015,219820871,112352024]
["2018","ENERGY+ INC.",null,null,null,227507289,504762,650599864.13999999,121226.4,724724625.66999996,2171002.7599999998,40066139.259999998,67941.7,177256773.63999999,388700.96,1415390629.0699999,2360170.86,1642897918.0699999,2864932.86,1602831778.8099999,952231914.66999996]
["2018","ENTEGRUS POWERLINES INC.",null,null,null,183353413.86000001,337747,520193823.5402,124114.82333300001,447522831.73300004,1269751.25,8368766.4000000004,18909.099999999999,259693420.31,599210.93000000005,976085421.67320001,1412775.1733329999,1159438835.5332,1750523.0733329998,1151070069.1332002,630876245.59299994,"(this is St. thomas and entegrus combined)"]
["2018","ENWIN UTILITIES LTD.",null,null,null,210569707,444018,911300246.80999994,483761.84,1002407655.7,2271498.2000000002,242857315.5,463568.8,495677164.07999998,975912,2156565218.0100002,3218828.84,2367134925.0100002,3662847.64,2124277609.51,1212977362.7]
["2018","EPCOR ELECTRICITY DISTRIBUTION ONTARIO INC.",null,null,null,36838997.079999998,62008,156368050.84,27806.93,95469385.260000005,223834.7,2622219.85,4948.96,43660807.75,88754.7,254459655.94999999,256590.59,291298653.02999997,318599.03000000003,288676433.18000001,132308382.34]
["2018","ERTH POWER CORPORATION - ERTH POWER MAIN RATE ZONE",null,null,null,52664112,109464,170501882,53268.71,255076321,502211.92,0,0,108673765,247265.74,425578203,555480.63,478242315,664944.63,478242315,307740433]
["2018","ERTH POWER CORPORATION – GODERICH RATE ZONE",null,null,null,16301729,28280,37879556,10155.73,21704799,60671.87,63334264,158301.4,8950719,16378.6,122918619,229129,139220348,257409.34,75886084,38006528]
["2018","ESPANOLA REGIONAL HYDRO DISTRIBUTION CORPORATION",null,null,null,8259498.4000000004,14739,37401936.700000003,2791.9,8855247.9000000004,21742.1,0,0,0,0,46257184.600000001,24534,54516683,39273,54516683,17114746.300000001]
["2018","ESSEX POWERLINES CORPORATION",null,null,null,68913583.099999994,169060,299644634.06999999,56516.35,111682700.55,322405.03999999998,10695832.890000001,20658.14,4507656.12,12525.04,422023167.50999999,399579.53,490936750.61000001,568640.38,480240917.71999997,180596283.64999998]
["2018","FESTIVAL HYDRO INC.",null,null,null,127658497.11,282391,192146831.27000001,54830.8,269823282.29000002,601038.38,3139758.12,5723.72,178028756.16999999,370404.2,465109871.68000001,661592.9,592768368.78999996,943984.14,589628610.67000008,397481779.40000004]
["2018","FORT FRANCES POWER CORPORATION",null,null,null,727134.55,0,52620671,0,18961128,49880,0,0,0,0,71581799,49880,72308933.549999997,49880,72308933.549999997,19688262.550000001]
["2018","GREATER SUDBURY HYDRO INC.",null,null,null,83591639.680000007,147260,514629970.98000002,173561.67,245875032.91999999,570066.76,3624729.23,6810.36,36594283.759999998,138457.79,764129733.13,750438.79,847721372.80999994,897699.23,844096643.58000004,329466672.60000002]
["2018","GRIMSBY POWER INCORPORATED",null,null,null,17783005.859999999,33510,105239592.08,7372.42,76441698.939999998,249262.46,3429861.18,6718.85,1987519.2,4930.41,185111152.19999999,263353.73,202894158.06,296864.11,199464296.88,94224704.799999997]
["2018","HALTON HILLS HYDRO INC.",null,null,null,67385238,128208,245359146,54012,164250010,471178,4234039,7376,44894121,128188,413843195,532566,481228433,660774,476994394,231635248]
["2018","HEARST POWER DISTRIBUTION CO. LTD.",null,null,null,4459529,8648,34531487,15231,38261730,97243,0,0,9182319,24138,72793217,112474,77252746,121122,77252746,42721259]
["2018","HYDRO 2000 INC.",null,null,null,791335,0,6896834,5327,1308656,389.4,0,0,0,0,8205490,5716.4,8996825,5716.4,8996825,2099991]
["2018","HYDRO HAWKESBURY INC.",null,null,null,11823941.73,17702,60851387,199,66281756,170891,0,0,6068661.7400000002,14240.84,127133143,171090,138957084.72999999,188792.4,138957084.73000002,78105697.730000004]
["2018","HYDRO ONE NETWORKS INC.",null,null,null,2601735430.5799999,2058232,14216239677.58,0,7130075922.6099997,20184160.969999999,9848217318.2900009,19492592.780000001,3007063245.8699999,6506853.9400000004,31194532918.48,39676753.75,33796268349.060001,41734986.549999997,23948051030.77,9731811353.1899986]
["2018","HYDRO ONE REMOTE COMMUNITIES INC.",null,null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0]
["2018","HYDRO OTTAWA LIMITED",null,null,null,596269945,1018231,3073564932,839071,3517410049,7921222,33972968,63608,792796607,1509115,6624947949,8823901,7221217894,9842132,7187244926,4113679994]
["2018","INNPOWER CORPORATION",null,null,null,19743663.52,26895,169038199.53,11536.66,53490349.799999997,126552.88,0,0,0,0,222528549.33000001,138089.54,242272212.84999999,164985.39000000001,242272212.85000002,73234013.319999993]
["2018","SYNERGY NORTH CORPORATION – KENORA RATE DISTRICT",null,null,null,17441922,34899,76633740,12938,0,47808,0,0,0,0,76633740,60746,94075662,95645,94075662,17441922]
["2018","KINGSTON HYDRO CORPORATION",null,null,null,114319077.89,187110,282569526.48000002,91031.89,286949290.81999999,655846.54,3991091.73,7194.82,167050916.54499999,309046.13,573509909.02999997,754073.25,687828986.91999996,941183.38,683837895.19000006,401268368.70999998]
["2018","KITCHENER-WILMOT HYDRO INC.",null,null,null,228479344.14809999,483788,920148191.60609996,0,544745702.98979998,1696000.82,36015512.644599997,75203.73,101928298.7033,246827.27,1500909407.2405,1771204.55,1729388751.3886001,2254993.34,1693373238.744,773225047.13789999]
["2018","LAKEFRONT UTILITIES INC.",null,null,null,47054173.200000003,98097,107185873.77,37571.910000000003,82165013.349999994,217260.25,0,0,35989737.780000001,67522.600000000006,189350887.12,254832.16,236405060.31999999,352929.99,236405060.31999999,129219186.55]
["2018","LAKELAND POWER DISTRIBUTION LTD.",null,null,null,40223748.530000001,63614,153225832.69,13735.84,85383662.409999996,205934.76,0,0,21850617.449999999,46473.14,238609495.09999999,219670.6,278833243.63,283285.49,278833243.63,125607410.94]
["2018","LONDON HYDRO INC.",null,null,null,308291183,544177,1460615181,326018.82,1301468785,3339530.28,0,29977.91,380970587.80000001,882768.7,2762083966,3695527.01,3070375149,4239704.01,3070375149,1609759968]
["2018","MILTON HYDRO DISTRIBUTION INC.",null,null,null,55999485,83880,392752396,111784,408481334,937468,4746499,10149,172175189,348415,805980229,1059401,861979714,1143281,857233215,464480819]
["2018","NEWMARKET-TAY POWER DISTRIBUTION LTD.",null,null,null,105108463.28,186978,414624260.27999997,27565.94,245576659.44,734211.71,8346156.71,16586.13,58022674,78458.95,668547076.43000007,778363.78,773655539.71000004,965341.84000000008,765309383,350685122.72000003,"(this is midland and NT combined)"]
["2018","NIAGARA PENINSULA ENERGY INC.",null,null,null,106112631.2,173790,526127849,75196,532194727,1358241,0,0,54341326,124075,1058322576,1433437,1164435207.2,1607227.04,1164435207.2,638307358.20000005]
["2018","NIAGARA-ON-THE-LAKE HYDRO INC.",null,null,null,27480635.140000001,50044,110282243.64,16035.96,59196383.850000001,148921.26999999999,0,0,2849283,5918.4,169478627.49000001,164957.23000000001,196959262.63,215002.21,196959262.63,86677018.99000001]
["2018","NORTH BAY HYDRO DISTRIBUTION LIMITED",null,null,null,45530674.259999998,75924,258570810.02000001,41533.81,178297061.84,447819.35,0,0,29330105.559999999,62610.49,436867871.86000001,489353.16,482398546.12,565277.42000000004,482398546.12,223827736.09999999]
["2018","NORTHERN ONTARIO WIRES INC.",null,null,null,13624092,34796,51609507,0,50707181,61694.21,0,0,5163181,15783,102316688,61694.21,115940780,96490.21,115940780,64331273]
["2018","OAKVILLE HYDRO ELECTRICITY DISTRIBUTION INC.",null,null,null,199562514.25999999,396925,750012566.38,181933.94,593521151.40999997,1524680.94,4447403.88,8578.57,117050989,231635,1347981121.6700001,1715193.45,1547543635.9300001,2112118.5299999998,1543096232.05,793083665.66999996]
["2018","ORANGEVILLE HYDRO LIMITED",null,null,null,37582777.5,70650,117466613.44,27469.53,89339545.299999997,203879.72,3134543.98,5789.36,46742885.719999999,43117.86,209940702.72,237138.61,247523480.22,307788.63,244388936.24000001,126922322.8]
["2018","ORILLIA POWER DISTRIBUTION CORPORATION",null,null,null,42657306,75668,151684388,61764,105779745,293102,3101125,5729,42926384,111749,260565258,360595,303222564,436263,300121439,148437051]
["2018","OSHAWA PUC NETWORKS INC.",null,null,null,134435450,228900,633383354,256359,261438191,685710,7037828,12794,67594546,149891,901859373,954863,1036294823,1183763,1029256995,395873641]
["2018","OTTAWA RIVER POWER CORPORATION",null,null,null,22393970,29784,113931089.02,40369.410000000003,41609122,152669.37,0,0,0,0,155540211.02000001,193038.78,177934181.02000001,222823.18,177934181.01999998,64003092]
["2018","PETERBOROUGH DISTRIBUTION INCORPORATED",null,null,null,134391196,287869,431934965,102367,195336597,520693,0,5698,112820304,202403,627271562,628758,761662758,916627,761662758,329727793]
["2018","PUC DISTRIBUTION INC.",null,null,null,68328727.819999993,94384,391333852.5,125818.98,162879933.00999999,398210.38,0,0,13841829,24617,554213785.50999999,524029.36,622542513.33000004,618413.44999999995,622542513.32999992,231208660.82999998]
["2018","RENFREW HYDRO INC.",null,null,null,7962918,11075,40532948,0,36668859,106335,0,0,6097514.3399999999,11612.5,77201807,106335,85164725,117410,85164725,44631777]
["2018","RIDEAU ST. LAWRENCE DISTRIBUTION INC.",null,null,null,8271777,11849,57793632,6443.02,32772900,95654.09,0,0,2193596,7375.6,90566532,102097.11,98838309,113946.93,98838309,41044677]
["2018","SIOUX LOOKOUT HYDRO INC.",null,null,null,8357674.8600000003,0,49069036.509999998,12717.37,16606348.609999999,50073.69,0,0,0,0,65675385.119999997,62791.06,74033059.980000004,62791.06,74033059.979999989,24964023.469999999]
["2018","SYNERGY NORTH CORPORATION – THUNDER BAY RATE DISTRICT",null,null,null,102344002,208552,500532638,182825,285232196,805578,0,0,85869306,236694,785764834,988403,888108836,1196955,888108836,387576198]
["2018","TILLSONBURG HYDRO INC.",null,null,null,47401197.270000003,99170,91370321.400000006,180162.14,44870438.420000002,301517.93,0,0,48585894,108682.9,136240759.81999999,481680.07,183641957.09,580850.74,183641957.09000003,92271635.689999998]
["2018","TORONTO HYDRO-ELECTRIC SYSTEM LIMITED",null,null,null,2716005307.6086302,5227202,9761714371,7467371,11113172094,26791726,330749827,609405,3698003210,7128105,21205636292,34868502,23921641599.608601,40095704.229800001,23590891772.608631,13829177401.608631]
["2018","WASAGA DISTRIBUTION INC.",null,null,null,5949165,7692,102876476,0,13049895,43991,2803203,5557.58,0,0,118729574,49548.58,124678739,57241.279999999999,121875536,18999060]
["2018","WATERLOO NORTH HYDRO INC.",null,null,null,160419170,0,622290344,226725,613994469,1806390,6231611,0,196274835,0,1242516424,2033115,1402935594,2033115,1396703983,774413639]
["2018","WELLAND HYDRO-ELECTRIC SYSTEM CORP.",null,null,null,21700736,21361,206509127,39819,122493159,336940,3013780,5518,14542159,61045,332016066,382277,353716802,403638,350703022,144193895]
["2018","WELLINGTON NORTH POWER INC.",null,null,null,32532737,61566,32600314,1329,35644424,91077,0,0,11318188.359999999,19738.8,68244738,92406,100777475,153972,100777475,68177161]
["2018","WESTARIO POWER INC.",null,null,null,87932552.5,158356,229816799,25979,98535155,262152,1827725,4899,36676918,75716,330179679,293030,418112231.5,451386.9,416284506.5,186467707.5]
[""]

{"sheet":"RRR_2018","index":15,"n_rows":69,"n_cols":21,"rows_kept":69,"cut":false,"hidden":true,"merged":[[0,0,0,7],[1,0,1,7]]}
["2.1.5 TotalConsumptionData_Dist_Ret_Total_Combined_Without RateClass_2019_v2"]
["Time run: 6/25/2019 2:37:25 PM"]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H + F + J","F + J"]
["Filing_Year","Company_Name",null,null,null,"Ret_Metered_consumption_in_kWhs","Ret_Metered_consumption_in_kWs","Dist_RPPMeterCustkWh","Dist_RPPMeterCustkW","Dist_NonRPPMeterCustkWh","Dist_NonRPPMeterCustkW","IESOMeterCustkWh","IESOMeterCustKW","Class_A_Consumption_kWhs","Class_A_Consumption_kWs","TotConsmptionforDistCustkWh","TotConsmptionforDistCustkW","Calculated_TOTAL_KWH","Calculated_TOTAL_KW","Total Metered Excluding WMP","Non RPP"]
["2019","ALECTRA UTILITIES CORPORATION",null,null,null,2643543563,5306056,10538278650,3342107,11355078515,27494395,902662836,1504000,5208559700,10695302,22796020001,32340502,25439563564,37646558,{"$f":"H5+J5+F5","v":24536900728},{"$f":"F5+J5","v":13998622078}]
["2019","ALECTRA UTILITIES - GUELPH",null,null,null,139512542.19999999,265010,532946021.62,117294.49,999441906.29999995,2281720.5299999998,6559026,20552.63,779216989.89999998,1648782.32,1538946953.9200001,2419567.65,1678459496.1199999,2684578.6,{"$f":"H6+J6+F6","v":1671900470.1200001},{"$f":"F6+J6","v":1138954448.5}]
["2019","ALGOMA POWER INC.",null,null,null,8104728.9846560396,9879,113771913.95748501,9707.85,102689132.133068,215211.14,0,0,73319688.890000001,123205.79,216461046.09055299,224918.99,224565775.07520899,234798.3,{"$f":"H7+J7+F7","v":224565775.07520902},{"$f":"F7+J7","v":110793861.11772403}]
["2019","ATIKOKAN HYDRO INC.",null,null,null,1122634.7,2303,13762612.42,0,15260256.6,54782.51,0,0,494323.58,3072.48,29022869.02,54782.51,30145503.719999999,57086.21,30145503.719999999,16382891.299999999]
["2019","BLUEWATER POWER DISTRIBUTION CORPORATION",null,null,null,57766757,104890,382526578,283664,435190437,738360,115951909,194303,308027905,562016,933668924,1216327,991435681,1321217,875483772,492957194]
["2019","BRANTFORD POWER INC.",null,null,null,159763507.93000001,333728,411053419.08999997,107364.83,363693815.06,1016899.08,47558080,107477.02,186988209.28999999,395519.8,822305314.14999998,1231740.93,982068822.08000004,1565469,934510742.07999992,523457322.99000001]
["2019","BURLINGTON HYDRO INC.",null,null,null,161789062,346060,808942246,385372,626905508,1667547,0,0,211575464,514564,1435847754,2052919,1597636816,2398979,1597636816,788694570]
["2019","CANADIAN NIAGARA POWER INC.",null,null,null,28150219.754871801,32318,280729011.89716798,46456.02,167897944.95622,521211.82,0,0,76022382.517866194,234135.95,448626956.85338801,567667.84,476777176.60825998,599986.36,476777176.60825974,196048164.71109182]
["2019","CENTRE WELLINGTON HYDRO LTD.",null,null,null,15230552,22913,65921792,5446.52,59304118,155089.26,2866640.26,5504.57,10816566.6,26242.16,128092550.26000001,166040.35,143323102.25999999,188953.60000000001,140456462,74534670]
["2019","CHAPLEAU PUBLIC UTILITIES CORPORATION",null,null,null,419097,750,18548446,823.47,5557973,15581.98,0,0,0,0,24106419,16405.45,24525516,17156.05,24525516,5977070]
["2019","COOPERATIVE HYDRO EMBRUN INC.",null,null,null,891546,24,24592390,0,3861532,11494,0,0,0,0,28453922,11494,29345468,11518,29345468,4753078]
["2019","ELEXICON ENERGY INC.-VERIDIAN RATE ZONE",null,null,null,234578684,364175,1292705429,262519,1077042490,2337833,37358789,64063,566953030,1075068,2407106708,2664415,2641685392,3028590,{"$f":"H16+J16+F16","v":2604326603},{"$f":"F16+J16","v":1311621174}]
["2019","ELEXICON ENERGY INC.-WHITBY RATE ZONE",null,null,null,98406490,161721,482183513,127998,286158671,676281,4147619,8467,139259185,253691,772489803,812746,870896293,974467,{"$f":"H17+J17+F17","v":866748674},{"$f":"F17+J17","v":384565161}]
["2019","E.L.K. ENERGY INC.",null,null,null,1,1,118340134,6951,110692781,316370,0,0,17393686,56726,229032915,323321,229032916,323322,229032916,110692782]
["2019","ENERGY+ INC.",null,null,null,213617993,480875,714025368,110572,737302096,2434864,36346563,63214,316960389.94999999,720245.15,1487674027,2608650,1701292020,3089525,1664945457,950920089]
["2019","ENTEGRUS POWERLINES INC.",null,null,null,184897046,341850,570339569,110517,444761905,1287598,7285666,16349,265498756,591066,1022387140,1414464,1207284186,1756314,1199998520,629658951]
["2019","ENWIN UTILITIES LTD.",null,null,null,184302087.09999999,381322,975320388.60000002,483913.6,1031176259.4,2347313.6,247726371,458576.4,614300193.79999995,1249448.8999999999,2254223019,3289803.6,2438525106.0999999,3671125.9,2190798735.0999999,1215478346.5]
["2019","EPCOR ELECTRICITY DISTRIBUTION ONTARIO INC.",null,null,null,33946468.759999998,54528,162016384.22999999,553.02,110669174.13,262850.65000000002,2605162.29,4968.28,57347355.140000001,117162.92,275290720.64999998,268371.95,309237189.41000003,322899.96999999997,306632027.12,144615642.88999999]
["2019","ERTH POWER CORPORATION - ERTH POWER MAIN RATE ZONE",null,null,null,56120662,98388,186557152,30057,322802932,670911,0,0,192178811,362309.96,509360084,700968,565480746,799356,565480746,378923594]
["2019","ERTH POWER CORPORATION – GODERICH RATE ZONE",null,null,null,16755114,28189,40654051,10261.58,22091555,61576.88,58174766,148823.29999999999,19202849,31139.01,120920372,220661.76000000001,137675486,248851.56,79500720,38846669]
["2019","ESPANOLA REGIONAL HYDRO DISTRIBUTION CORPORATION",null,null,null,7990795.4000000004,13940,40295493.090000004,3271.1,8637486.4000000004,21104.799999999999,0,0,0,0,48932979.490000002,24375.9,56923774.890000001,38316.800000000003,56923774.890000001,16628281.800000001]
["2019","ESSEX POWERLINES CORPORATION",null,null,null,72529274.180000007,189726,320353669.42000002,48666.85,115872895.59,290965.18,10169680.380000001,19510.53,26951834.91,63884.7,446396245.38999999,359142.56,518925519.56999999,548868.56000000006,508755839.19,188402169.77000001]
["2019","FESTIVAL HYDRO INC.",null,null,null,104333898,277262,206833328,50763,298093570,634713,3931816,41919,298260804,591678,508858714,727395,613192612,1004657,609260796,402427468]
["2019","FORT FRANCES POWER CORPORATION",null,null,null,480198.16,0,55643045,0,17683713,49047,0,0,0,0,73326758,49047,73806956.159999996,49047,73806956.159999996,18163911.16]
["2019","GREATER SUDBURY HYDRO INC.",null,null,null,86589713.430000007,137147,546758131.71000004,171720.98,245822856.78999999,587028.73,3477473.24,6618.54,72343263.060000002,144546.38,796058461.74000001,765368.25,882648175.16999996,902515.86,879170701.93000007,332412570.22000003]
["2019","GRIMSBY POWER INCORPORATED",null,null,null,17743405.350000001,33661,114024977.81,12323.7,92175040.829999998,280231.17,3378435.9,6492.73,3221178.2,8379.7099999999991,209578454.53999999,299047.59999999998,227321859.88999999,332708.96999999997,223943423.98999998,109918446.18000001]
["2019","HALTON HILLS HYDRO INC.",null,null,null,61498570,119491,263704857,48418,170368632,487797,3870953,7360,78045311,232310,437944442,543575,499443012,663066,495572059,231867202]
["2019","HEARST POWER DISTRIBUTION CO. LTD.",null,null,null,1875368.45,2995,42658091.670000002,52106.17,33746660.75,68553.38,0,0,24419620,63606.93,76404752.420000002,120659.55,78280120.870000005,123655.11,78280120.870000005,35622029.200000003]
["2019","HYDRO 2000 INC.",null,null,null,603818,648,17038217,0,4432468,11013.5,0,0,0,0,21470685,11013.5,22074503,11662.3,22074503,5036286]
["2019","HYDRO HAWKESBURY INC.",null,null,null,13546397.6,24359,64445530,194,66147208,168510,0,0,15041117,35472.949999999997,130592738,168704,144139135.59999999,193063.2,144139135.59999999,79693605.599999994]
["2019","HYDRO ONE NETWORKS INC.",null,null,null,2762318132.3800001,4446986,15223236928.25,1707565.41,7641034132.6899996,24462989.809999999,10514016865.59,23627456.289999999,3469922835,7536555.8399999999,33378287926.529999,49798011.509999998,36140606058.910004,54244998.259999998,25626589193.32,10403352265.07]
["2019","HYDRO ONE REMOTE COMMUNITIES INC.",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["2019","HYDRO OTTAWA LIMITED",null,null,null,529200425,881454,3257669549,854940,3577015024,8143062,33622545,61844,1292613290,2539078,6868307118,9059846,7397507543,9941300,7363884998,4106215449]
["2019","INNPOWER CORPORATION",null,null,null,19799368.620000001,28255,188770098.27000001,11169.93,54929918.990000002,131353.22,0,0,0,0,243700017.25999999,142523.15,263499385.88,170778.97,263499385.88000003,74729287.609999999]
["2019","KINGSTON HYDRO CORPORATION",null,null,null,115926873.75,198605,301013829.81,93635.97,284822515.69,660199.12,3616283.42,6712.69,178413924.15000001,370251.46,589452628.91999996,760547.78,705379502.66999996,959152.9,701763219.25,400749389.44]
["2019","KITCHENER-WILMOT HYDRO INC.",null,null,null,220917011.61989999,473569,996619966.50960004,0,573631444.95640004,1784992.56,27520828.09,67145.37,208734455.96599999,504203.43,1597772239.556,1852137.93,1818689251.1759,2325707.77,1791168423.0859001,794548456.57630002]
["2019","LAKEFRONT UTILITIES INC.",null,null,null,49967760.200000003,106446,112958527.87,31976.85,86508921.629999995,226695.14,0,0,75373730.260000005,142771.1,199467449.5,258671.99,249435209.69999999,365118.75,249435209.69999999,136476681.82999998]
["2019","LAKELAND POWER DISTRIBUTION LTD.",null,null,null,33709687,52176,162638933.21000001,13949.43,92388255.099999994,223147.58,0,0,42961261.43,92945.44,255027188.31,237097.01,288736875.31,289273.13,288736875.31,126097942.09999999]
["2019","LONDON HYDRO INC.",null,null,null,283475855.89999998,512927,1593339762,369323.89,1324042645,3380078.44,0,28511.5,560302674.70000005,1321732.3,2917382407,3777913.83,3200858262.9000001,4290841.53,3200858262.9000001,1607518500.9000001]
["2019","MILTON HYDRO DISTRIBUTION INC.",null,null,null,55831685,89670,423561691,104104,428250487,976171,4331691,9327,243610967,481341,856143869,1089602,911975554,1179272,907643863,484082172]
["2019","NEWMARKET-TAY POWER DISTRIBUTION LTD.",null,null,null,108434492,168064,453677279,28772,279660379,693975,3726295,15698,115174314,235949,737063953,738445,845498445,906509,841772150,388094871]
["2019","NIAGARA PENINSULA ENERGY INC.",null,null,null,98091083,160249,569593895,68933,552870731,1396343,3166943,6075,154666015,346570,1125631569,1471351,1223722652,1631600,1220555709,650961814]
["2019","NIAGARA-ON-THE-LAKE HYDRO INC.",null,null,null,18692405.5,36126,119479628.73999999,18525.8,79359827.450000003,191447.67,0,0,18134723.359999999,47569.04,198839456.19,209973.47,217531861.69,246099.6,217531861.69,98052232.950000003]
["2019","NORTH BAY HYDRO DISTRIBUTION LIMITED",null,null,null,50250020.909999996,90271,273151806.37,39565.24,173579143.83000001,423504.25,0,0,42947474.799999997,97139.06,446730950.19999999,463069.49,496980971.11000001,553340.68000000005,496980971.11000001,223829164.74000001]
["2019","NORTHERN ONTARIO WIRES INC.",null,null,null,16400363,35103,53317626,0,47310018,151059,0,0,16061836,70915,100627644,151059,117028007,186162,117028007,63710381]
["2019","OAKVILLE HYDRO ELECTRICITY DISTRIBUTION INC.",null,null,null,195945742.34999999,399529,815037861.46000004,206312,602543597.25999999,1548397.82,4255917.71,8394.59,177344123,376812,1421837376.4300001,1763104.41,1617783118.78,2162633.77,1613527201.0699999,798489339.61000001]
["2019","ORANGEVILLE HYDRO LIMITED",null,null,null,35045017,67115,129637291.55,24498.080000000002,87062013,209067.05,3013333.2,5683.77,39164593,91113,219712637.75,239248.9,254757654.75,306363.90000000002,251744321.55000001,122107030]
["2019","ORILLIA POWER DISTRIBUTION CORPORATION",null,null,null,39404847,66779,163720463,59021,117092755,295223,2872560,5624,48922409,125187,283685778,359868,323090625,426647,320218065,156497602]
["2019","OSHAWA PUC NETWORKS INC.",null,null,null,127367388,234849,697359913,317881,266192520,703166,6881329,13219,92817186,197198,970433762,1034266,1097801150,1269115,1090919821,393559908]
["2019","OTTAWA RIVER POWER CORPORATION",null,null,null,19857561,36112,120339783,40928,45001361,155755,0,0,0,0,165341144,196683,185198705,232795,185198705,64858922]
["2019","PETERBOROUGH DISTRIBUTION INCORPORATED",null,null,null,122722540,230369,463446765,119489,208500369,576387,0,5438,137979417,302762,671947134,701314,794669674,931683,794669674,331222909]
["2019","PUC DISTRIBUTION INC.",null,null,null,68682996.280000001,100674,407046124.01999998,122305.32,157968806.49000001,389211.23,0,0,32510299,83491,565014930.50999999,511516.55,633697926.78999996,612190.67000000004,633697926.78999996,226651802.77000001]
["2019","RENFREW HYDRO INC.",null,null,null,7052122,10370,42302019,0,37438563,100062,0,0,12237109.16,23498.19,79740582,100062,86792704,110432.2,86792704,44490685]
["2019","RIDEAU ST. LAWRENCE DISTRIBUTION INC.",null,null,null,7978657,13050,62057846,6789.9,31812128,94884.26,0,0,5806605,17467,93869974,101674.16,101848631,114724.5,101848631,39790785]
["2019","SIOUX LOOKOUT HYDRO INC.",null,null,null,2844255.2,0,53789301.969999999,12500.6,21936591.719999999,51853.73,0,0,0,0,75725893.689999998,64354.33,78570148.890000001,64354.33,78570148.890000001,24780846.919999998]
["2019","SYNERGY NORTH CORPORATION – KENORA RATE DISTRICT",null,null,null,16940486,36316,60730246,14059,20712772,41199,0,0,0,0,81443018,55258,98383504,91574,98383504,37653258]
["2019","SYNERGY NORTH CORPORATION – THUNDER BAY RATE DISTRICT",null,null,null,56532737,111236,516602001,205225,323287406,876980,0,0,126330844.81999999,351616.3,839889407,1082205,896422144,1193441,896422144,379820143]
["2019","TILLSONBURG HYDRO INC.",null,null,null,48021260.549999997,64475,71061293.459999993,14391.28,64228347.390000001,188787.42,0,0,49026950.640000001,106418.7,135289640.84999999,203178.7,183310901.40000001,267653.78000000003,183310901.39999998,112249607.94]
["2019","TORONTO HYDRO-ELECTRIC SYSTEM LIMITED",null,null,null,2670024832,5224394,10416743189.190001,7637432.3300000001,11379662370.83,27768255.68,326638701.93000001,610483.75,5208597011,10983550,22123044261.950001,36016171.759999998,24793069093.950001,41240565.759999998,24466430392.02,14049687202.83]
["2019","WASAGA DISTRIBUTION INC.",null,null,null,5564326,9576,111614860,0,14284813,38557.9,2678677,5394.51,0,0,128578350,43952.41,134142676,53529.11,131463999,19849139]
["2019","WATERLOO NORTH HYDRO INC.",null,null,null,148661297,0,667953593,234573,633479732,1854258,8585533,0,295995447,0,1310018858,2088831,1458680155,2088831,1450094622,782141029]
["2019","WELLAND HYDRO-ELECTRIC SYSTEM CORP.",null,null,null,20050471,20166,224580275,26132,131537026,367640,2923062,5287,24020461,87485,359040363,399059,379090834,419225,376167772,151587497]
["2019","WELLINGTON NORTH POWER INC.",null,null,null,33615988,60278,36064093,52,36730903,91593,0,0,36721328.939999998,73180,72794996,91645,106410984,151923,106410984,70346891]
["2019","WESTARIO POWER INC.",null,null,null,93715034,209000,259647460,24597,109725687,322962,1827725,4899,77936554,160533,371200872,352458,464915906,561458,463088181,203440721]
[""]

{"sheet":"RRR_2019","index":16,"n_rows":64,"n_cols":21,"rows_kept":64,"cut":false,"hidden":true,"merged":[[0,0,0,7],[1,0,1,7]]}
["2.1.5 TotalConsumptionData_Dist_Ret_Total_Combined_Without RateClass_2020_v2"]
["Time run: 8/10/2020 4:46:09 PM"]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H + F + J","F + J"]
["Filing_Year","Company_Name",null,null,null,"Ret_Metered_consumption_in_kWhs","Ret_Metered_consumption_in_kWs","Dist_RPPMeterCustkWh","Dist_RPPMeterCustkW","Dist_NonRPPMeterCustkWh","Dist_NonRPPMeterCustkW","IESOMeterCustkWh","IESOMeterCustKW","Class_A_Consumption_kWhs","Class_A_Consumption_kWs","TotConsmptionforDistCustkWh","TotConsmptionforDistCustkW","Calculated_TOTAL_KWH","Calculated_TOTAL_KW","Total Metered Excluding WMP","Non RPP"]
["2020","ALECTRA UTILITIES CORPORATION",null,null,null,2655028918,5307211,10826156503,3310053,12100792658,29915470,908014632,1511540,6159397525,12564498,23834963793,34737063,26489992711,40044274,25581978079,14755821576]
["2020","ALGOMA POWER INC.",null,null,null,8277614,9889,118567534,9019,108955335,225676,0,0,81535209,141198,227522869,234695,235800483,244584,235800483,117232949]
["2020","ATIKOKAN HYDRO INC.",null,null,null,1113870.2,2232,13625950.300000001,0,14834259.1,47352.56,0,0,5254738.18,16897.599999999999,28460209.399999999,47352.56,29574079.600000001,49584.88,29574079.600000001,15948129.299999999]
["2020","BLUEWATER POWER DISTRIBUTION CORPORATION",null,null,null,56915003,97513,376632667,136471,421863758,854524,119513820,194559,310820090,558916,918010245,1185554,974925248,1283067,855411428,478778761]
["2020","BRANTFORD POWER INC.",null,null,null,164629761.88,335779,400456387.01999998,95814.23,381874018.63999999,1039886.61,47347679.009999998,108645.51,200352505,453512,829678084.66999996,1244346.3500000001,994307846.54999995,1580126.15,946960167.53999996,546503780.51999998]
["2020","BURLINGTON HYDRO INC.",null,null,null,145916367,309090,778072601,356753,606484940,1669741,0,0,193111332,480613,1384557541,2026494,1530473908,2335584,1530473908,752401307]
["2020","CANADIAN NIAGARA POWER INC.",null,null,null,26215439,28711,276529595,47012,165591892,497662,0,0,79045580,243850,442121487,544674,468336926,573385,468336926,191807331]
["2020","CENTRE WELLINGTON HYDRO LTD.",null,null,null,14837635,25820,64685736.869999997,5261.71,57951295.149999999,151886.26999999999,2736305.22,5130.53,21983577.399999999,52158.3,125373337.23999999,162278.51,140210972.24000001,188098.84,137474667.02000001,72788930.150000006]
["2020","CHAPLEAU PUBLIC UTILITIES CORPORATION",null,null,null,514286,1316,19463336,822,5344967,14434,0,0,0,0,24808303,15256,25322589,16572,25322589,5859253]
["2020","COOPERATIVE HYDRO EMBRUN INC.",null,null,null,1012513,0,24987194,0,2622780,11159,0,0,0,0,27609974,11159,28622487,11159,28622487,3635293]
["2020","E.L.K. ENERGY INC.",null,null,null,1,1,133941009,8041,108935713,336339,0,0,17721776,59481,242876722,344380,242876723,344381,242876723,108935714]
["2020","ELEXICON ENERGY INC.",null,null,null,318181285,566511,1744143910,368006,1341784634,2909032,39344625,67355,737940260,1384836,3125273169,3344393,3443454454,3910904,3404109829,1659965919]
["2020","ENERGY+ INC.",null,null,null,197509740,445419,700405544,169125,734133242,1958091,99467807,182568,337039077.63,778284.87,1534006593,2309784,1731516333,2755203,1632048526,931642982]
["2020","ENTEGRUS POWERLINES INC.",null,null,null,181981751,334429,555879995,126304,441669153,1169047,9715904,27076,281796954,636519,1007265052,1322427,1189246803,1656856,1179530899,623650904]
["2020","ENWIN UTILITIES LTD.",null,null,null,156056697.30000001,308659,935974729.39999998,440320.92,983867627.11000001,2341663.38,252977275.02000001,461902.43,594967199.22000003,1283646,2172819631.5300002,3243886.73,2328876328.8299999,3552546.43,2075899053.8099999,1139924324.4100001]
["2020","EPCOR ELECTRICITY DISTRIBUTION ONTARIO INC.",null,null,null,34787516.049999997,55257,167778936.75999999,15532.21,98194115.799999997,235156.08,2541775.7000000002,4895.04,55254523.149999999,17544,268514828.25999999,255583.33,303302344.31,310841.14,300760568.61000001,132981631.84999999]
["2020","ERTH POWER CORPORATION",null,null,null,69980266.239999995,128590,224238428.83000001,39101,297045778.07999998,649381,73939748,189938.85,222781062.90000001,422219.6,595223954.90999997,878420.85,665204221.14999998,1007011.78,591264473.14999998,367026044.31999999]
["2020","ESPANOLA REGIONAL HYDRO DISTRIBUTION CORPORATION",null,null,null,7836135.0899999999,0,41367424.100000001,3347.22,8228965,20370.599999999999,0,0,0,0,49596389.100000001,23717.82,57432524.189999998,23717.82,57432524.189999998,16065100.09]
["2020","ESSEX POWERLINES CORPORATION",null,null,null,67983579.459999993,177397,323143908.95999998,69860.710000000006,136902898.41999999,373002.38,10041533.609999999,19024.29,17770355.170000002,45159.35,470088340.99000001,461887.38,538071920.45000005,639285.35,528030386.83999991,204886477.88]
["2020","FESTIVAL HYDRO INC.",null,null,null,84201027,226801,203073047,47219,319713797,693615,3611938,52613,277827791,601783,526398782,793447,610599809,1020248,606987871,403914824]
["2020","FORT FRANCES POWER CORPORATION",null,null,null,436518,0,55949876,0,17106600,50053,0,0,0,0,73056476,50053,73492994,50053,73492994,17543118]
["2020","GREATER SUDBURY HYDRO INC.",null,null,null,86350871.950000003,133470,542415991.69000006,177297.38,238838440.49000001,550558.71999999997,3377730.4,6216.86,72271401.900000006,138882.47,784632162.58000004,734072.96,870983034.52999997,867543.03,867605304.13000011,325189312.44]
["2020","GRIMSBY POWER INCORPORATED",null,null,null,18006631.059999999,33032,112954906.48,14858.03,95200511.540000007,268524.65000000002,3311799.6,6616.78,3590576.2,8929.84,211467217.62,289999.46000000002,229473848.68000001,323031.46000000002,226162049.08000001,113207142.60000001]
["2020","HALTON HILLS HYDRO INC.",null,null,null,60788935,122583,253507410,35596,176011397,475608,3652820,7699,72582256,161438,433171627,518903,493960562,641486,490307742,236800332]
["2020","HEARST POWER DISTRIBUTION CO. LTD.",null,null,null,1626424.74,2829,35887562.560000002,10706.3,40234088.710000001,115295.03,0,0,28186955.260000002,84187.66,76121651.269999996,126001.33,77748076.010000005,128830.81,77748076.010000005,41860513.450000003]
["2020","HYDRO 2000 INC.",null,null,null,841285,0,17072356,0,3077103,10710.11,0,0,0,0,20149459,10710.11,20990744,10710.11,20990744,3918388]
["2020","HYDRO HAWKESBURY INC.",null,null,null,14076109,20304,63970070,158,63225182,163584,0,0,13264976,29926,127195252,163742,141271361,184046,141271361,77301291]
["2020","HYDRO ONE NETWORKS INC.",null,null,null,2630536220.29,4515674,15252207483.3424,1910702.1535132001,7790519231.28549,21618089.461800002,10070502214.591999,20339525.256999999,3975247802,738992,33113228929.219898,43868316.872313201,35743765149.509903,48383991.512313202,25673262934.917892,10421055451.575489]
["2020","HYDRO ONE REMOTE COMMUNITIES INC.",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["2020","HYDRO OTTAWA LIMITED",null,null,null,497448293,814147,3195741529,857805,3542769011,7864706,32832434,103645,1326677094,2554373,6771342974,8826156,7268791267,9640303,7235958833,4040217304]
["2020","INNPOWER CORPORATION",null,null,null,14133795.890000001,17796,196656060.56999999,9167.7999999999993,59308495.439999998,139443.53,0,0,10965508.560000001,22955.62,255964556.00999999,148611.32999999999,270098351.89999998,166408.22,270098351.89999998,73442291.329999998]
["2020","KINGSTON HYDRO CORPORATION",null,null,null,114698392.53,206960,270234716.30000001,87675.89,307279580.10000002,618936.47,3672307.71,6469.39,189867289.18000001,366171.6,581186604.11000001,713081.75,695884996.63999999,920042.48,692212688.93000007,421977972.63]
["2020","KITCHENER-WILMOT HYDRO INC.",null,null,null,206553534.4472,444843,971533977.16040003,0,574722418.59560001,1767493.32,32138347.3123,80867.899999999994,232087654.24599999,569239.61,1578394743.0683,1848361.22,1784948277.5155001,2293205.0299999998,1752809930.2031999,781275953.04279995]
["2020","LAKEFRONT UTILITIES INC.",null,null,null,52843807.740000002,103743,110491127.04000001,33508.32,75387582.030000001,204420.04,0,0,71074772.219999999,153227.87,185878709.06999999,237928.36,238722516.81,341672.33,238722516.81,128231389.77000001]
["2020","LAKELAND POWER DISTRIBUTION LTD.",null,null,null,35794243.369999997,56606,163693356.72,15590.97,92005365.840000004,224301.09,0,0,40625025.560000002,92159.06,255698722.56,239892.06,291492965.93000001,296498.82,291492965.93000001,127799609.21000001]
["2020","LONDON HYDRO INC.",null,null,null,268954633.24000001,491144,1554894976.1900001,338174.31,1281634538.5999999,3305022.14,14578191.91,26585.78,544777056.51999998,1209692.57,2851107706.6999998,3669782.23,3120062339.9400001,4160926.71,3105484148.0299997,1550589171.8399999]
["2020","MILTON HYDRO DISTRIBUTION INC.",null,null,null,53496024,84345,408175994,86143,446349358,1010727,4419712,9228,276753344,553511,858945064,1106098,912441088,1190443,908021376,499845382]
["2020","NEWMARKET-TAY POWER DISTRIBUTION LTD.",null,null,null,96191415,169792,440109771,124566,278015871,668164,10276031,50468,124824783,264638,728401673,843198,824593088,1012990,814317057,374207286]
["2020","NIAGARA PENINSULA ENERGY INC.",null,null,null,87752216,143096,523526294,14131,595671400,1490330,3070169,5800,202624554,471812,1122267863,1510261,1210020079,1653357,1206949910,683423616]
["2020","NIAGARA-ON-THE-LAKE HYDRO INC.",null,null,null,19341875.73,37573,116852324.84,13915.68,93118604.780000001,252241.93,0,0,35841899.439999998,107227.2,209970929.62,266157.61,229312805.34999999,303731.09999999998,229312805.34999999,112460480.51000001]
["2020","NORTH BAY HYDRO DISTRIBUTION LIMITED",null,null,null,50625869.530000001,91622,273948238.81999999,46963.88,171187702.03,419983.38,0,0,44341187.829999998,93047.48,445135940.85000002,466947.26,495761810.38,558570.18000000005,495761810.38,221813571.56]
["2020","NORTHERN ONTARIO WIRES INC.",null,null,null,16097098,33601,53048833,0,48309449,138917,0,0,23758522,74518,101358282,138917,117455380,172518,117455380,64406547]
["2020","OAKVILLE HYDRO ELECTRICITY DISTRIBUTION INC.",null,null,null,169724359.44,329808,801492810.28999996,15853.59,583664393.71000004,1689552.76,4047657.56,8027.89,179151972.83000001,385902.7,1389204861.5599999,1713434.24,1558929221,2043243.13,1554881563.4400001,753388753.1500001]
["2020","ORANGEVILLE HYDRO LIMITED",null,null,null,33642138.789999999,61542,125081745.62,24902.02,90552836.239999995,209510.93,2981689.24,5653.66,54676133.899999999,105163.96,218616271.09999999,240066.61,252258409.88999999,301608.63,249276720.64999998,124194975.03]
["2020","ORILLIA POWER DISTRIBUTION CORPORATION",null,null,null,39056693,65598,160300163,55279,115166000,282631,2769406,5430,60088068,146863,278235569,343340,317292262,408938,314522856,154222693]
["2020","OSHAWA PUC NETWORKS INC.",null,null,null,71434068,106400,672800558,248344,298723064,737525,6533879,12465,90242032,200157,978057501,998334,1049491569,1104734,1042957690,370157132]
["2020","OTTAWA RIVER POWER CORPORATION",null,null,null,21308040,37885,120619011,40861,41585877,155195,0,0,1305027.1200000001,5703.36,162204888,196056,183512928,233941,183512928,62893917]
["2020","PETERBOROUGH DISTRIBUTION INCORPORATED",null,null,null,115534314.41,210226,426295632.75999999,112850.12,219832478.78999999,531932.1,0,5209,122349066,259899,646128111.54999995,649991.22,761662425.96000004,860218.22,761662425.95999992,335366793.19999999]
["2020","PUC DISTRIBUTION INC.",null,null,null,66424123.270000003,101709,406959170.67000002,116043.95,158562520.09,384467.04,0,0,35960742,89900,565521690.75999999,500510.99,631945814.02999997,602220.68999999994,631945814.02999997,224986643.36000001]
["2020","RENFREW HYDRO INC.",null,null,null,7068695.4699999997,9005,42528775,0,36787287,90503,0,0,12768084.02,24739.26,79316062,90503,86384757.469999999,99508.79,86384757.469999999,43855982.469999999]
["2020","RIDEAU ST. LAWRENCE DISTRIBUTION INC.",null,null,null,8326720,12696,60890011,5964.95,31002361,93261.88,0,0,7983849,25619,91892372,99226.83,100219092,111922.94,100219092,39329081]
["2020","SIOUX LOOKOUT HYDRO INC.",null,null,null,6783475.7000000002,0,54722673.890000001,11072.19,19031574.210000001,41537.29,0,0,0,0,73754248.099999994,52609.48,80537723.799999997,52609.48,80537723.800000012,25815049.91]
["2020","SYNERGY NORTH CORPORATION",null,null,null,43537567.310000002,53299,536232423.86000001,98583.34,400546332.97000003,1087671.03,0,0,127674309.20999999,340435.96,936778756.83000004,1186254.3700000001,980316324.13999999,1239554.08,980316324.1400001,444083900.28000003]
["2020","TILLSONBURG HYDRO INC.",null,null,null,31268618.43,72622,74180702.719999999,16086.09,68725439.329999998,187888.85,0,0,42367786.969999999,89627.21,142906142.05000001,203974.94,174174760.47999999,276597.84999999998,174174760.48000002,99994057.75999999]
["2020","TORONTO HYDRO-ELECTRIC SYSTEM LIMITED",null,null,null,2404106122.2210698,4726932,10013654669.789301,7279403.7425781405,11258688976.932699,27046461.615674999,297526414.00295401,587486.14058000001,5475133418.3299999,11524057.689999999,21569870060.724998,34913351.498833098,23973976182.945999,39640283.686238602,23676449768.943069,13662795099.153769]
["2020","WASAGA DISTRIBUTION INC.",null,null,null,5666829,8806,110677510,0,14641813,37133.760000000002,2668244,5263.75,0,0,127987567,42397.51,133654396,51204.41,130986152,20308642]
["2020","WATERLOO NORTH HYDRO INC.",null,null,null,141815891,0,658616599,187453,629006499,1815569,8606064,18270,291537126,0,1296229162,2021292,1438045053,2021292,1429438989,770822390]
["2020","WELLAND HYDRO-ELECTRIC SYSTEM CORP.",null,null,null,18383460,16815,217495982,39758,131899355,359377,2829418,5114,33268121,109709,352224755,404249,370608215,421064,367778797,150282815]
["2020","WELLINGTON NORTH POWER INC.",null,null,null,30820940.469999999,59486,33434893.57,48.38,34318492.990000002,90245.05,0,0,47435897.18,102890.4,67753386.560000002,90293.43,98574327.030000001,149780.24,98574327.030000001,65139433.460000001]
["2020","WESTARIO POWER INC.",null,null,null,89228112,155994,242809299,15601,108932499,272634,2687566,6518,81697050,186612,354429364,294753,443657476,450747,440969910,198160611]

{"sheet":"RRR_2020","index":17,"n_rows":65,"n_cols":21,"rows_kept":65,"cut":false,"hidden":true,"merged":[[0,0,0,7],[1,0,1,7]]}
["2.1.5 TotalConsumptionData_Dist_Ret_Total_Combined_Without RateClass_2020_v2"]
["Time run: 6/16/2021 4:49:12 PM"]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H + F + J","F + J"]
["Filing_Year","Company_Name",null,null,null,"Ret_Metered_consumption_in_kWhs","Ret_Metered_consumption_in_kWs","Dist_RPPMeterCustkWh","Dist_RPPMeterCustkW","Dist_NonRPPMeterCustkWh","Dist_NonRPPMeterCustkW","IESOMeterCustkWh","IESOMeterCustKW","Class_A_Consumption_kWhs","Class_A_Consumption_kWs","TotConsmptionforDistCustkWh","TotConsmptionforDistCustkW","Calculated_TOTAL_KWH","Calculated_TOTAL_KW","Total Metered Excluding WMP","Non RPP"]
["2021","1937680 ONTARIO INC.",null,null,null,110264267,197497,437816214,128011,202934553,492106,0,5278,115957906,242416,640750767,625395,751015034,822892,751015034,313198820]
["2021","ALECTRA UTILITIES CORPORATION",null,null,null,2525742733,5181518,11410346075.99,3079758.68,11448041878.82,28662490.350000001,827007387.28999996,1394965.56,5946341455.6999998,12262885.039999999,23685395342.099998,33137214.59,26211138075.099998,38318732.590000004,25384130687.809998,13973784611.82]
["2021","ALGOMA POWER INC.",null,null,null,7314397.0499999998,9840,125568566.31999999,13674.34,96257256.469999999,211025.23,0,0,78703754.099999994,147690.22,221825822.78999999,224699.57,229140219.84,234539.94,229140219.83999997,103571653.52]
["2021","ATIKOKAN HYDRO INC.",null,null,null,1087992.93,2121,13425982.48,0,15983952.5,46301.760000000002,0,0,11196734,35416.67,29409934.98,46301.760000000002,30497927.91,48423.199999999997,30497927.91,17071945.43]
["2021","BLUEWATER POWER DISTRIBUTION CORPORATION",null,null,null,53701595,98622,386377896,122389,406618525,818113,110220914,185942,299485009,530547,903217335,1126444,956918930,1225066,846698016,460320120]
["2021","BRANTFORD POWER INC.",null,null,null,93012170.489999995,223306,411203331.42000002,77800.58,428932727.98000002,1149127.6599999999,49059529.369999997,112260.93,208309021.09,424940,889195588.76999998,1339189.17,982207759.25999999,1562495.2,933148229.8900001,521944898.47000003]
["2021","BURLINGTON HYDRO INC.",null,null,null,124324848,299098,806133163,335053,574334702,1564525,0,0,188143335,482407,1380467865,1899578,1504792713,2198676,1504792713,698659550]
["2021","CANADIAN NIAGARA POWER INC.",null,null,null,23159677.920000002,31043,286866305.87,50536.46,151605493.18000001,466315.03,0,0,69967994.700000003,229622.35,438471799.05000001,516851.49,461631476.97000003,547894.79,461631476.97000003,174765171.10000002]
["2021","CENTRE WELLINGTON HYDRO LTD.",null,null,null,15652695,28237,68991717.239999995,4449.1400000000003,54239172.579999998,145335.38,2742231.82,5245.35,18333712.800000001,47599.3,125973121.64,155029.87,141625816.63999999,183267.5,138883584.81999999,69891867.579999998]
["2021","CHAPLEAU PUBLIC UTILITIES CORPORATION",null,null,null,714434,1284,18356701,793,4378625,12918,0,0,0,0,22735326,13711,23449760,14995.4,23449760,5093059]
["2021","COOPERATIVE HYDRO EMBRUN INC.",null,null,null,958931,0,25536089,0,2420926,10064,0,0,0,0,27957015,10064,28915946,10064,28915946,3379857]
["2021","CORNWALL STREET RAILWAY LIGHT AND POWER COMPANY LIMITED",null,null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0]
["2021","E.L.K. ENERGY INC.",null,null,null,0,0,138000152,5078,101102624,265407,0,0,18907938,63611.519999999997,239102776,270485,239102776,270485,239102776,101102624]
["2021","ELEXICON ENERGY INC.",null,null,null,268154034,450197,1834688591,356881,1333475212,2985484,38750816,70779,736462350,1424447,3206914619,3413144,3475068653,3863341,3436317837,1601629246]
["2021","ENERGY+ INC.",null,null,null,174054452.80000001,409214,734905299.94000006,172723.12,699405305.30999994,1920547.18,98343365.390000001,934263.03,329931323.56,837085.68,1532653970.6400001,3027533.33,1706708423.4400001,3436747.54,1608365058.05,873459758.1099999]
["2021","ENTEGRUS POWERLINES INC.",null,null,null,178258809,339034,577734739,129076,408308042,1126707,9991343,24863,256610387,583352,996034124,1280646,1174292933,1619680,1164301590,586566851]
["2021","ENWIN UTILITIES LTD.",null,null,null,140053448.96000001,270155,966747541.61000001,399802.04,861774021.42999995,2130569.06,185372464.96000001,336589.51,504101767.66000003,1160873,2013894028,2866960.61,2153947476.96,3137116.22,1968575012,1001827470.39]
["2021","EPCOR ELECTRICITY DISTRIBUTION ONTARIO INC.",null,null,null,29743517.02,48565,176654209.58000001,22742.91,88367945.980000004,215671.64,2539213.02,4917.2700000000004,48385446.159999996,106918.85,267561368.58000001,243331.82,297304885.60000002,291897.71000000002,294765672.58000004,118111463]
["2021","ERTH POWER CORPORATION",null,null,null,68011485,127625,231287278,32174,276488070,611602,74563562,197773,216950291,429387.75,582338910,841549,650350395,969174,575786833,344499555]
["2021","ESPANOLA REGIONAL HYDRO DISTRIBUTION CORPORATION",null,null,null,7242900.7300000004,13072,41124493.909999996,387.32,7770010.7999999998,19989.97,0,0,0,0,48894504.710000001,20377.29,56137405.439999998,33449.83,56137405.439999998,15012911.530000001]
["2021","ESSEX POWERLINES CORPORATION",null,null,null,62214686.780000001,170636,336538643.75,69054.240000000005,127429093.40000001,378028,10003470.029999999,18968.349999999999,28696443.100000001,69594.95,473971207.18000001,466050.59,536185893.95999998,636687.44999999995,526182423.92999995,189643780.18000001]
["2021","FESTIVAL HYDRO INC.",null,null,null,82343549,208668,205634847.88,42058.05,302771729.06999999,663416.93999999994,3347054.46,55632.4,250809335.18000001,561209.59,511753631.41000003,761107.39,594097180.40999997,969775.39,590750125.95000005,385115278.06999999]
["2021","FORT FRANCES POWER CORPORATION",null,null,null,383112.14,0,55064499,0,15584310,47713,0,0,0,0,70648809,47713,71031921.140000001,47713,71031921.140000001,15967422.140000001]
["2021","GREATER SUDBURY HYDRO INC.",null,null,null,80852425.689999998,125665,540379778.22000003,149994.82,213461518.09999999,511709.42,3291003.43,6257.46,63842839.359999999,127307.35,757132299.75,667961.69999999995,837984725.44000006,793627.15,834693722.01000011,294313943.78999996]
["2021","GRIMSBY POWER INCORPORATED",null,null,null,15434287.130000001,27360,120664984.84,13360.43,107623677.3,301124.51,3220636.58,6393.31,5292286.3,12408.73,231509298.72,320878.25,246943585.84999999,348239.01,243722949.26999998,123057964.42999999]
["2021","HALTON HILLS HYDRO INC.",null,null,null,55102269,112714,266978897,34275,177634218,477271,3683237,6989,69749927,145039,448296352,518535,503398621,631249,499715384,232736487]
["2021","HEARST POWER DISTRIBUTION CO. LTD.",null,null,null,1171351.8,1964,33987228.93,7914.2,39236960.420000002,115596.87,0,0,26278009.32,81903.88,73224189.349999994,123511.07,74395541.150000006,125475.43,74395541.150000006,40408312.219999999]
["2021","HYDRO 2000 INC.",null,null,null,785941,0,16544492,0,3093576,9673.2999999999993,0,0,0,0,19638068,9673.2999999999993,20424009,9673.2999999999993,20424009,3879517]
["2021","HYDRO HAWKESBURY INC.",null,null,null,15349780.189999999,24497,62831181,136,58893786,153597,0,0,13664277,32248,121724967,153733,137074747.19,178230.03,137074747.19,74243566.189999998]
["2021","HYDRO ONE NETWORKS INC.",null,null,null,2345661982.8499999,4162240,15889662049.66,1764778.01,7793504712.6300001,22269344.120000001,9949659113,19900942,4186146405.6999998,9522854.75,33632825875.290001,43935064.130000003,35978487858.139999,48097304.490000002,26028828745.139999,10139166695.48]
["2021","HYDRO ONE REMOTE COMMUNITIES INC.",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["2021","HYDRO OTTAWA LIMITED",null,null,null,447228753,736635,3324671135,826568,3262093758,7426118,32404319,94176,1316072090,2548531,6619169212,8346862,7066397965,9083497,7033993646,3709322511]
["2021","INNPOWER CORPORATION",null,null,null,12751358.15,16935,208348286.19999999,8634.27,54793178.119999997,130393.2,0,0,10131924.779999999,22716.58,263141464.31999999,139027.47,275892822.47000003,155963.42000000001,275892822.46999997,67544536.269999996]
["2021","KINGSTON HYDRO CORPORATION",null,null,null,111582632.95999999,202219,291689180.68000001,92273.54,253033373.25999999,596151.43000000005,3589567.13,6261.78,190731299.90000001,408158.74,548312121.07000005,694686.75,659894754.02999997,896906.26,656305186.89999998,364616006.21999997]
["2021","KITCHENER-WILMOT HYDRO INC.",null,null,null,171486044.19999999,375741,1017526315.75,0,557470232.37,1730857.05,33278455.629999999,87690.84,258991768.72999999,623261.6,1608275003.75,1818547.89,1779761047.95,2194289.6,1746482592.3200002,728956276.56999993]
["2021","LAKEFRONT UTILITIES INC.",null,null,null,49809031.030000001,104826,190365708.36000001,226538.91,0,0,0,0,64538994.280000001,146455,190365708.36000001,226538.91,240174739.38999999,331365.34000000003,240174739.39000002,49809031.030000001]
["2021","LAKELAND POWER DISTRIBUTION LTD.",null,null,null,30309928.16,45450,162499095.86000001,17453.78,93363362.769999996,231042.1,0,0,47392497,101885,255862458.63,248495.88,286172386.79000002,293946.69,286172386.79000002,123673290.92999999]
["2021","LONDON HYDRO INC.",null,null,null,251073819.78999999,457660,1637995869.6099999,426303.01,1178789040.21,3000563.08,15096527.83,29024.55,507754510.06999999,1193453.3,2831881437.6500001,3455890.64,3082955257.4400001,3913551.57,3067858729.6099997,1429862860]
["2021","MILTON HYDRO DISTRIBUTION INC.",null,null,null,48174787,80723,444778779,69902,416499649,970264,4342865,9041,263205127,517046,865621293,1049207,913796080,1129930,909453215,464674436]
["2021","NEWMARKET-TAY POWER DISTRIBUTION LTD.",null,null,null,90880802.079999998,173787,460974628.79000002,55683,255990090.09999999,685312.8,12512518,55617,91273937,255956.1,729477236.88999999,796612.8,820358038.97000003,970400.32,807845520.97000003,346870892.18000001]
["2021","NIAGARA PENINSULA ENERGY INC.",null,null,null,78458851,133698,545130506,911,522438653,1318893,2939507,5663,143401848,343288,1070508666,1325467,1148967517,1459165,1146028010,600897504]
["2021","NIAGARA-ON-THE-LAKE HYDRO INC.",null,null,null,18008307.190000001,37027,118641630.36,10754.04,85411178.349999994,235200.71,0,0,30407916.600000001,97952.1,204052808.71000001,245954.75,222061115.90000001,282982.2,222061115.90000001,103419485.53999999]
["2021","NORTH BAY HYDRO DISTRIBUTION LIMITED",null,null,null,45214358.049999997,86450,271883361.72000003,47881.11,159552500.19,393524.44,0,0,40971371.719999999,89566.39,431435861.91000003,441405.55,476650219.95999998,527855.94999999995,476650219.96000004,204766858.24000001]
["2021","NORTHERN ONTARIO WIRES INC.",null,null,null,15221119,30503,52999559,0,46782861,132084,0,0,24067489,71690,99782420,132084,115003539,162587,115003539,62003980]
["2021","OAKVILLE HYDRO ELECTRICITY DISTRIBUTION INC.",null,null,null,154618829.91999999,307515,857696252.34000003,237994.66,545391396.5,1363549.56,4173859.04,7724.84,0,378845.01,1407261507.8800001,1609269.06,1561880337.8,1916784.52,1557706478.76,700010226.41999996]
["2021","ORANGEVILLE HYDRO LIMITED",null,null,null,29465562.449999999,53304,129619170.63,11899.97,92428718.439999998,216286.48,2833631.12,5460.18,59082613.490000002,115396.77,224881520.19,233646.63,254347082.63999999,286950.95,251513451.51999998,121894280.89]
["2021","ORILLIA POWER DISTRIBUTION CORPORATION",null,null,null,37046147,64510,158433073,49139,107300095,270049,2852029,5596,57124368,145172,268585197,324784,305631344,389294,302779315,144346242]
["2021","OSHAWA PUC NETWORKS INC.",null,null,null,64353892,94101,709511182,265875,261808793,662546,6595334,12747,83195958,189436,977915309,941168,1042269201,1035269,1035673867,326162685]
["2021","OTTAWA RIVER POWER CORPORATION",null,null,null,21411435,31237,118508116,38610.559999999998,38433687,150089.26,0,0,3066581.88,9971.0400000000009,156941803,188699.82,178353238,219937.08,178353238,59845122]
["2021","PUC DISTRIBUTION INC.",null,null,null,55044762.450000003,81051,407902888.57999998,120254.15,150684548.37,353400.97,0,0,37839473.020000003,88926.66,558587436.95000005,473655.12,613632199.39999998,554706.93999999994,613632199.39999998,205729310.81999999]
["2021","RENFREW HYDRO INC.",null,null,null,7036171.3700000001,10043,44333939,0,33242698,84686,0,0,13146991.67,25099.09,77576637,84686,84612808.370000005,94729.72,84612808.370000005,40278869.369999997]
["2021","RIDEAU ST. LAWRENCE DISTRIBUTION INC.",null,null,null,7244139,10353,61686603,7447.4,30513173,93359,0,0,919193478,29177,92199776,100806.39999999999,99443915,111160.03,99443915,37757312]
["2021","SIOUX LOOKOUT HYDRO INC.",null,null,null,1629299.53,2406,53021908.049999997,8922.0499999999993,23888320,56381.62,0,0,0,0,76910228.049999997,65303.67,78539527.579999998,67710.38,78539527.579999998,25517619.530000001]
["2021","SYNERGY NORTH CORPORATION",null,null,null,40303882.100000001,44765,533552812.39999998,101404.42,370299509.75,1020367.24,0,0,124175830.95,334200.48,903852322.14999998,1121771.6599999999,944156204.25,1166537.1499999999,944156204.25,410603391.85000002]
["2021","TILLSONBURG HYDRO INC.",null,null,null,28542338.949999999,68719,78661359.549999997,90282.53,63048012.060000002,105080.38,0,0,34626840.149999999,94370,141709371.61000001,195362.91,170251710.56,264082.49,170251710.56,91590351.010000005]
["2021","TORONTO HYDRO-ELECTRIC SYSTEM LIMITED",null,null,null,2228304767.3699999,4439180,10285544493.120001,7327811.0199999996,10439704825.34,24998000.140000001,298858277.68000001,574443.74,5196986948.9200001,10790058.699999999,21024107596.139999,32900254.899999999,23252412363.509998,37339435.710000001,22953554085.830002,12668009592.709999]
["2021","WASAGA DISTRIBUTION INC.",null,null,null,5036790,8141,117994661,1592.64,13715273,35121.040000000001,2734869.57,5526.12,0,0,134444803.56999999,42239.8,139481593.56999999,50381.54,136746724,18752063]
["2021","WATERLOO NORTH HYDRO INC.",null,null,null,128453641,0,682992733,254154,572543595,1619976,7939234,16282,263651994,0,1263475562,1890412,1391929203,1890412,1383989969,700997236]
["2021","WELLAND HYDRO-ELECTRIC SYSTEM CORP.",null,null,null,17294548,17222,219666822,2951,124917963,362058,2757773,4924,32842150,118895,347342558,369933,364637106,387155,361879333,142212511]
["2021","WELLINGTON NORTH POWER INC.",null,null,null,28638744.600000001,58880,34669326.780000001,48.94,31029744.449999999,84401.31,0,0,43533655.030000001,98239.6,65699071.229999997,84450.25,94337815.829999998,143331.23000000001,94337815.829999998,59668489.049999997]
["2021","WESTARIO POWER INC.",null,null,null,84128710,145219,245123109,14955,105985900,268099,1921209,4601,86104847,198081,353030218,287655,437158928,432874,435237719,190114610]

{"sheet":"RRR_2021","index":18,"n_rows":63,"n_cols":21,"rows_kept":63,"cut":false,"hidden":true,"merged":[[0,0,0,7],[1,0,1,7]]}
["2.1.5 TotalConsumptionData_Dist_Ret_Total_Combined_Without RateClass_2020_v2"]
[]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H + F + J","F + J"]
["Filing_Year","Company_Name",null,null,null,"Ret_Metered_consumption_in_kWhs","Ret_Metered_consumption_in_kWs","Dist_RPPMeterCustkWh","Dist_RPPMeterCustkW","Dist_NonRPPMeterCustkWh","Dist_NonRPPMeterCustkW","IESOMeterCustkWh","IESOMeterCustKW","Class_A_Consumption_kWhs","Class_A_Consumption_kWs","TotConsmptionforDistCustkWh","TotConsmptionforDistCustkW","Calculated_TOTAL_KWH","Calculated_TOTAL_KW","Total Metered Excluding WMP","Non RPP"]
[2022,"Alectra Utilities Corporation",null,null,null,2504699608,5149307,11507309301,3317629,11523672933,28600772,865092714,1503767,6262667010,12967616,23896074948,33422168,26400774556,38571475,25535681842,14028372541]
[2022,"Algoma Power Inc.",null,null,null,4987503.74,1968.3,126924113.84999999,15987.67,112402726.2,235369.29,null,null,93431047.609999999,175025.41,239326840.05000001,251356.96,244314343.78999999,253325.26,244314343.78999999,117390229.94]
[2022,"Atikokan Hydro Inc.",null,null,null,1078512.8600000001,2244.16,13737777.380000001,null,16871074.550000001,48435.38,null,null,11678536,33100.94,30608851.93,48435.38,31687364.789999999,50679.54,31687364.789999999,17949587.41]
[2022,"Bluewater Power Distribution Corporation",null,null,null,53144219,99557,391165750,111591,408364897,846444,105273048,193483,294521899,537420,904803695,1151518,957947914,1251075,852674866,461509116]
[2022,"Brantford Power Inc.",null,null,null,91673797.060000002,225963.58,408882859.17000002,78436.28,455925079.75,1415160.37,50439935.359999999,116449.67,228008887.06999999,576700.11,915247874.27999997,1610046.32,1006921671.34,1836009.9,956481735.98000002,547598876.80999994]
[2022,"Burlington Hydro Inc.",null,null,null,142881954,315320,804208250,336132,566753301,1524316,null,null,210380851,498047,1370961551,1860448,1513843505,2175768,1513843505,709635255]
[2022,"Canadian Niagara Power Inc.",null,null,null,23172136.620000001,43243.88,290858785.95999998,50460.5,154827130.28,487718.76,null,null,73900656.150000006,240048.38,445685916.24000001,538179.26,468858052.86000001,581423.14,468858052.86000001,177999266.90000001]
[2022,"Centre Wellington Hydro Ltd.",null,null,null,17619674,34069.910000000003,70819271,4868.82,55191660.25,147828.01,2711389.61,4997.83,21350193.399999999,51795.48,128722320.86,157694.66,146341994.86000001,191764.57,143630605.25,72811334.25]
[2022,"Chapleau Public Utilities Corporation",null,null,null,1020196,1642.88,17466568,613,4230779,11803,null,null,0,0,21697347,12416,22717543,14058.88,22717543,5250975]
[2022,"Cooperative Hydro Embrun Inc.",null,null,null,1154776,0,25717148,0,3400671,9833,0,0,0,0,29117819,9833,30272595,9833,30272595,4555447]
[2022,"Cornwall Street Railway Light and Power Company Limited",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2022,"E.L.K. Energy Inc.",null,null,null,25782470,3399,165764366,231007,51245355,115955,0,0,19769610,64438.92,217009721,346962,242792191,350361,242792191,77027825]
[2022,"ENWIN Utilities Ltd.",null,null,null,137092051.41999999,260369.38,977417207.75,369399.72,790163016.82000005,2042138.39,179564730.88999999,322621.63,413053203.83999997,1019198,1947144955.46,2734159.74,2084237006.8800001,2994529.12,1904672275.9900002,927255068.24000001]
[2022,"EPCOR Electricity Distribution Ontario Inc.",null,null,null,28072501.460000001,44035.02,186704180.91,41896.28,87559491.810000002,210091.01,2389303.7000000002,4662.9399999999996,50868804.439999998,113630.99,276652976.42000002,256650.23,304725477.88,300685.25,302336174.18000001,115631993.27000001]
[2022,"ERTH Power Corporation",null,null,null,74751027,126497,231283596,36359,259683899,580328,74563562,187051,205760585,422337,565531057,803738,640282084,930235,565718522,334434926]
[2022,"Elexicon Energy Inc.",null,null,null,263044329,459341,1864235387,374002,1350093797,3023939,38286829,66184,760889887,1467361,3252616013,3464125,3515660342,3923466,3477373513,1613138126]
[2022,"ENERGY+ INC.",null,null,null,181887561.22,419674.62,747794368.89999998,184494.52,709804310.62,1945905.02,107413039.52,199542.86,355125105.13,912763.99,1565011719.04,2329942.4,1746899280.26,2749617.02,1639486240.74,891691871.84000003]
[2022,"Entegrus Powerlines Inc.",null,null,null,176444327,351757,599344016,165435,429607737,1069474,7668489,20184,283324894,599672,1036620242,1255093,1213064569,1606850,1205396080,606052064]
[2022,"Espanola Regional Hydro Distribution Corporation",null,null,null,7127953.4500000002,13408.44,40340599.369999997,4174.54,7354032,18515.669999999998,null,null,null,null,47694631.369999997,22690.21,54822584.82,36098.65,54822584.82,14481985.449999999]
[2022,"Essex Powerlines Corporation",null,null,null,64035044.869999997,171816.78,346317597.68000001,66782.720000000001,129486284.09,382752.15,9552767.8200000003,18119.11,40032313.229999997,104775.46,485356649.58999997,467653.98,549391694.46000004,639470.76,539838926.63999999,193521328.96000001]
[2022,"Festival Hydro Inc.",null,null,null,79062078.420000002,182441.1,227169206.41999999,44836.18,291373620.82999998,699436.25,3211585.03,28640.5,254642117.44999999,569224.81000000006,521754412.27999997,772912.93,600816490.70000005,955354.03,597604905.66999996,370435699.25]
[2022,"Fort Frances Power Corporation",null,null,null,212315.35,null,54448971,null,15826684,43020,null,null,null,null,70275655,43020,70487970.349999994,null,70487970.349999994,16038999.35]
[2022,"Greater Sudbury Hydro Inc.",null,null,null,79895048.290000007,139800,530822307.83999997,143335.60999999999,210472427.68000001,498229.08,3311424.71,5923.56,59690569.829999998,121155.86,744606160.23000002,647488.25,824501208.51999998,787288.25,821189783.80999994,290367475.97000003]
[2022,"Grimsby Power Incorporated",null,null,null,19009883.920000002,33709.39,121938100.59,14187.4,122150378.03,320357.82,3223620.08,6138.67,13708886.439999999,32163.35,247312098.69999999,340683.89,266321982.62,374393.28,263098362.53999999,141160261.94999999]
[2022,"Halton Hills Hydro Inc.",null,null,null,51699871,101537,266274635,30213,177988908,461240,3450785,7008,78785743,168243,447714328,498461,499414199,599998,495963414,229688779]
[2022,"HEARST POWER DISTRIBUTION CO. LTD.",null,null,null,1952475.3,3755.56,33195698,7822,38900060,124254,null,null,27390320.98,88486.16,72095758,132076,74048233.299999997,135831.56,74048233.299999997,40852535.299999997]
[2022,"Hydro 2000 Inc.",null,null,null,996925,null,15877201,null,3024697,9348.6,null,null,0,0,18901898,9348.6,19898823,null,19898823,4021622]
[2022,"Hydro Hawkesbury Inc.",null,null,null,14979858.560000001,23815.4,62344349,129,60953910,154364,0,0,17887986.440000001,36913.730000000003,123298259,154493,138278117.56,178308.4,138278117.56,75933768.560000002]
[2022,"Hydro One Networks Inc.",null,null,null,2336620393.3299999,3789836.69,16900763317.48,1744033.95,8705656051.2399998,24163167.579999998,9697105664.2999992,19327890.84,4946699626,11569221,35303525033.019997,45235092.369999997,37640145426.349998,49024929.060000002,27943039762.049995,11042276444.57]
[2022,"Hydro One Remote Communities Inc.",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0]
[2022,"Hydro Ottawa Limited",null,null,null,431628977,705489.51,3347515401,759978.68,3324886562,7531339.5599999996,31892249,74266.7,1344361497,2439284.4,6704294212,8365584.9400000004,7135923189,9071074.4499999993,7104030940,3756515539]
[2022,"Innpower Corporation",null,null,null,11194530.33,14147.4,214466588.08000001,16112.51,52712013.530000001,130200.96000000001,0,0,8490540.1799999997,20120.53,267178601.61000001,146313.47,278373131.94,160460.87,278373131.94000006,63906543.859999999]
[2022,"Kingston Hydro Corporation",null,null,null,106923017.19,180453.43,289743138.10000002,85925.13,260935967.31,564111.73,3564987.87,6312.17,196721873.81999999,381432.58,554244093.27999997,656349.03,661167110.47000003,836802.46,657602122.60000002,367858984.5]
[2022,"Kitchener-Wilmot Hydro Inc.",null,null,null,166040952.75999999,363813.87,1039873475.35,null,560393778.5,1775829.87,35786517.32,89302.25,264006172.69999999,633655.82999999996,1636053771.1700001,1865132.12,1802094723.9300001,2228945.9900000002,1766308206.6100001,726434731.25999999]
[2022,"Lakefront Utilities Inc.",null,null,null,42081423.310000002,92013.72,112703386.59999999,18180.259999999998,87098311.780000001,212086.16,null,null,62327690.920000002,138682.51999999999,199801698.38,230266.42,241883121.69,322280.14,241883121.69,129179735.09]
[2022,"Lakeland Power Distribution Ltd.",null,null,null,27974015.829999998,41976.24,165600101.09,17445.849999999999,96711411,229195.12,null,null,53117180.280000001,105877.82,262311512.09,246640.97,290285527.92000002,288617.21000000002,290285527.92000002,124685426.83]
[2022,"London Hydro Inc.",null,null,null,208799432.87,447349.49,1665512323.49,362668.56,1213218609.8299999,3271351.38,15115032.09,53084.9,548017956,1301987.32,2893845965.4099998,3687104.84,3102645398.2800002,4134454.33,3087530366.1900001,1422018042.6999998]
[2022,"Milton Hydro Distribution Inc.",null,null,null,46544560,76801,458537750,45749,429921911,1005599,4238817,9208,277190157,537910,892698478,1060556,939243038,1137357,935004221,476466471]
[2022,"Newmarket-Tay Power Distribution Ltd.",null,null,null,87894907,169229,463144704,81508,267836045,762043,11967072,54313,97214004,272296,742947821,897864,830842728,1067093,818875656,355730952]
[2022,"Niagara Peninsula Energy Inc.",null,null,null,74385098,129850,553577099,588,544081095,1359275,2771944,5566,156113158.61000001,379403.82,1100430138,1365429,1174815236,1495279,1172043292,618466193]
[2022,"Niagara-on-the-Lake Hydro Inc.",null,null,null,19498329.260000002,38583.360000000001,119692499.90000001,10219.200000000001,78262830.069999993,215493.14,0,0,24120199.280000001,80623.199999999997,197955329.97,225712.34,217453659.22999999,264295.7,217453659.22999999,97761159.329999998]
[2022,"North Bay Hydro Distribution Limited",null,null,null,31959717.75,56302.41,271546588.02999997,49332.59,171658089.71000001,421157.64,0,0,39723141.920000002,89386.64,443204677.74000001,470490.23,475164395.49000001,526792.64,475164395.49000001,203617807.46000001]
[2022,"Northern Ontario Wires Inc.",null,null,null,15040541,30185,52254401,null,46894913,127574,null,null,25659304,73541,99149314,127574,114189855,157759,114189855,61935454]
[2022,"Oakville Hydro Electricity Distribution Inc.",null,null,null,158386396.75999999,332081.18,857458116.98000002,219321.42,534287649.68000001,1391464.98,3912171.86,7261.14,196664453.02000001,421576.36,1395657938.52,1618047.54,1554044335.28,1950128.72,1550132163.4200001,692674046.44000006]
[2022,"Orangeville Hydro Limited",null,null,null,33503938.329999998,64679.6,130750973.91,27985.32,92269020.25,202909.74,2570983.2999999998,5452.74,60822724.609999999,112268.36,225590977.46000001,236347.8,259094915.78999999,301027.40000000002,256523932.49000001,125772958.58]
[2022,"Oshawa PUC Networks Inc.",null,null,null,61055229,97117,713841483,269622,272718041,675789,6438736,12276,82987741,184841,992998260,957687,1054053489,1054804,1047614753,333773270]
[2022,"Ottawa River Power Corporation",null,null,null,21216269,44026.8,119675708,26400.32,41220519,120959.48,null,null,3244175.52,9970.56,160896227,147359.79999999999,182112496,191386.6,182112496,62436788]
[2022,"PUC Distribution Inc.",null,null,null,50379913.5,70064.92,405718161.56999999,119269.69,148220437.13999999,355170.67,null,null,37810243.020000003,88766.09,553938598.71000004,474440.36,604318512.21000004,544505.28,604318512.21000004,198600350.63999999]
[2022,"Renfrew Hydro Inc.",null,null,null,8873512,14188,43380703,null,31636641,86776,null,null,13224412.58,25027.64,75017344,86776,83890856,100964,83890856,40510153]
[2022,"Rideau St. Lawrence Distribution Inc.",null,null,null,7317771,13995.18,61177902,6651,31976753,92179,null,null,10169065,29658,93154655,98830,100472426,112825.18,100472426,39294524]
[2022,"Sioux Lookout Hydro Inc.",null,null,null,2058580.37,2777.06,51886465.880000003,7741.9,24275737.309999999,57124.71,null,null,null,null,76162203.189999998,64866.61,78220783.560000002,67643.67,78220783.560000002,26334317.68]
[2022,"Synergy North Corporation",null,null,null,65210580,102890,521249917,38755,356925183,1002148,null,null,125260228,349355,878175100,1040903,943385680,1143793,943385680,422135763]
[2022,"Tillsonburg Hydro Inc.",null,null,null,13706539.82,26058.080000000002,82967337.760000005,28536.86,79097414.930000007,222304.19,null,null,39469349.640000001,112194.84,162064752.69,250841.05,175771292.50999999,276899.13,175771292.51000002,92803954.75]
[2022,"Toronto Hydro-Electric System Limited",null,null,null,2021333153.2,4018098.3,10291022054.040001,7232056.2199999997,10458592587.610001,24934860.629999999,288751889.56999999,541980.01,5275228843,11176854,21038366531.220001,32708896.859999999,23059699684.419998,36726995.159999996,22770947794.850002,12479925740.810001]
[2022,"Wasaga Distribution Inc.",null,null,null,4680042,null,121197574,1347.7,14486591,35686.1,2738840,5291.6,null,null,138423005,42325.4,143103047,null,140364207,19166633]
[2022,"Waterloo North Hydro Inc.",null,null,null,127669024,null,686178939,269242,596519060,1679783,7808857,15944,269139765,null,1290506856,1964969,1418175880,null,1410367023,724188084]
[2022,"Welland Hydro-Electric System Corp.",null,null,null,32329443,49336,226991972,2536,106416938,297639,2744430,4975,32820395,102607,336153340,305150,368482783,354486,365738353,138746381]
[2022,"Wellington North Power Inc.",null,null,null,31279600.609999999,58877.05,35509142.630000003,53.06,32073161.559999999,101191.39,null,null,45094739.789999999,101140.4,67582304.189999998,101244.45,98861904.799999997,160121.5,98861904.799999997,63352762.170000002]
[2022,"Westario Power Inc.",null,null,null,82560544,143940,247458698,14176,109115372,274287,1194366,3265,76428202,195578,357768436,291728,440328980,435668,439134614,191675916]

{"sheet":"RRR_2022","index":19,"n_rows":60,"n_cols":21,"rows_kept":60,"cut":false,"hidden":true,"merged":[[0,0,0,7]]}
["2.1.5 TotalConsumptionData_Dist_Ret_Total_Combined_Without RateClass_2022_v2"]
[]
[]
["Filing Year","Company Name",null,null,null,"Total kWhs","Total kWs","Metered Consumption on RPP - Kwh","Metered Consumption on RPP - Kw","Metered Consumption on Non-RPP - Kwh","Metered Consumption on Non-RPP - Kw","Billed by IESO For Commodity - Kwh","Billed by IESO For Commodity - Kw","Table 5, Class A - Consumption kWhs","Table 5, Class A - Consumption kWs","Total Consumption - Kwh","Total Consumption - Kw","Calc Total KWH","Calc Total KW","Total Metered Excluding WMP","Non RPP"]
[2023,"Alectra Utilities Corporation",null,null,null,2422962294,5048266,11882095225,3748482,11805342125,29358417,870016492,1443533,6600724182.9499998,13602825.02,24557453842,34550432,26980416136,39598698,26110399644,14228304419]
[2023,"Algoma Power Inc.",null,null,null,5099874.76,1584.93,136363156.78,15973.73,114824548.52,244973.34,null,null,95465853.609999999,187012.96,251187705.30000001,260947.07,256287580.06,262532,256287580.06,119924423.28]
[2023,"Atikokan Hydro Inc.",null,null,null,1167131.19,2270.88,13865204.16,null,14948855.710000001,45471.57,null,null,9315383.3200000003,31695.72,28814059.870000001,45471.57,29981191.059999999,47742.45,29981191.060000002,16115986.9]
[2023,"Bluewater Power Distribution Corporation",null,null,null,55483330,107477,393004281,108145,397874117,831532,117555881,190249,283132238,519235,908434279,1129926,963917609,1237403,846361728,453357447]
[2023,"Burlington Hydro Inc.",null,null,null,155957525,368831,807858618,356800,567882107,1469861,null,null,222035575,524608,1375740725,1826661,1531698250,2195492,1531698250,723839632]
[2023,"Canadian Niagara Power Inc.",null,null,null,23931957.609999999,40596.86,300908188.55000001,58333.71,158132836.81999999,492442.06,null,null,78217369.680000007,247535.89,459041025.37,550775.77,482972982.98000002,591372.63,482972982.98000002,182064794.43000001]
[2023,"Centre Wellington Hydro Ltd.",null,null,null,18648325,37257.26,72828903,7478.08,52926984.93,147170.62,2632776.4300000002,4940.9399999999996,23136324.199999999,58882.43,128388664.36,159589.64000000001,147036989.36000001,196846.9,144404212.93000001,71575309.930000007]
[2023,"Chapleau Public Utilities Corporation",null,null,null,1353432,2472.5,18728372,511,3252804,11807,null,null,0,0,21981176,12318,23334608,14790.5,23334608,4606236]
[2023,"Cooperative Hydro Embrun Inc.",null,null,null,1225231,0,26383103,0,3086769,10846,0,0,0,0,29469872,10846,30695103,10846,30695103,4312000]
[2023,"Cornwall Street Railway Light and Power Company Limited",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[2023,"E.L.K. Energy Inc.",null,null,null,21489373,null,128528198,5859,85251983,273893,2671090.56,4636.07,17805574.920000002,61694.64,216451271.56,284388.07,237940644.56,null,235269554,106741356]
[2023,"ENWIN Utilities Ltd.",null,null,null,131511185.88,227124.14,997578696.34000003,337326.7,807300794,2031133.97,185092215.19,324494.12,438771305.79000002,1037029.45,1989971705.53,2692954.79,2121482891.4100001,2920078.93,1936390676.22,938811979.88]
[2023,"EPCOR Electricity Distribution Ontario Inc.",null,null,null,28094135.18,42825.83,191715705.97999999,49573.87,91908874.599999994,218676.89,2302949.0699999998,4656.49,52743390.710000001,114084.1,285927529.64999998,272907.25,314021664.82999998,315733.08,311718715.75999999,120003009.78]
[2023,"ERTH Power Corporation",null,null,null,64154998,125947,244437114,37749,255717118,565189,73438997,179185,203961568,406676,573593229,782123,637748227,908070,564309230,319872116]
[2023,"Elexicon Energy Inc.",null,null,null,285032592,499755,1867405690,363370,1387854488,3020774,37944359,67594,781879969,1514366,3293204537,3451738,3578237129,3951493,3540292770,1672887080]
[2023,"Enova Power Corp.",null,null,null,275960611.82999998,600545.39,1768434014.0599999,234300.61,1214035490.9400001,3375324.85,42636803.609999999,93777.81,556380628.58899999,1283281.6129999999,3025106308.6100001,3703403.27,3301066920.4400001,4303948.66,3258430116.8299999,1489996102.77]
[2023,"Entegrus Powerlines Inc.",null,null,null,162223553,335803,607576081,164917,472274538.00999999,1159554.01,6572810,12836,303166016,653642,1086423429.01,1337307.01,1248646982.01,1673110.01,1242074172.01,634498091.00999999]
[2023,"Essex Powerlines Corporation",null,null,null,60980507.530000001,156447.34,350927798.94,78096.22,134501628.65000001,384675.51,9394709.1199999992,17894.02,22077597.25,54555.93,494824136.70999998,480665.75,555804644.24000001,637113.09,546409935.12,195482136.18000001]
[2023,"Festival Hydro Inc.",null,null,null,84602805.609999999,199755.62,219311563.72,51690.720000000001,307776013.66000003,680446.23,3263932.02,10174.799999999999,258025299.30000001,565856.17000000004,530351509.39999998,742311.75,614954315.00999999,942067.37,611690382.99000001,392378819.27000004]
[2023,"Fort Frances Power Corporation",null,null,null,253713.82,null,56180979,null,16685108,49535,null,null,null,null,72866087,49535,73119800.819999993,null,73119800.819999993,16938821.82]
[2023,"GrandBridge Energy Inc.",null,null,null,303376651.73000002,696340.01,1175625058.6400001,241027.82,1182732044.47,3142988.39,138893419.83000001,272898.33,612319732.54999995,1398852.05,2497250522.9400001,3656914.54,2800627174.6700001,4353254.55,2661733754.8400002,1486108696.2]
[2023,"Greater Sudbury Hydro Inc.",null,null,null,82851767.269999996,134734.45000000001,543796206.85000002,177000.95,220354007.81,482889.29,3328282.83,6061.51,58388640.759999998,110637.26,767478497.49000001,665951.75,850330264.75999999,800686.2,847001981.93000007,303205775.07999998]
[2023,"Grimsby Power Incorporated",null,null,null,25367243.670000002,64636.89,120934350.54000001,14645.25,109243386,351587.88,3275831.51,6367.26,13419172.880000001,41480.36,233453568.05000001,372600.39,258820811.72,437237.28,255544980.21000001,134610629.67000002]
[2023,"Halton Hills Hydro Inc.",null,null,null,45595620,90704,268246656,33248,183533196,499860,3500134,7395,84312699,185835,455279986,540503,500875606,631207,497375472,229128816]
[2023,"Hearst Power Distribution Company Limited",null,null,null,2248516,4427,34590935,9771,38931182,116602,null,null,27523,86250,73522117,126373,75770633,130800,75770633,41179698]
[2023,"Hydro 2000 Inc.",null,null,null,981819,null,15974912,null,3179140,9178.7999999999993,null,null,0,0,19154052,9178.7999999999993,20135871,null,20135871,4160959]
[2023,"Hydro Hawkesbury Inc.",null,null,null,15134281.699999999,32373.58,63755915.920000002,117.36,62280276.359999999,158015.6,0,0,16645866.07,36835.61,126036192.28,158132.96,141170473.97999999,190506.54,141170473.98000002,77414558.060000002]
[2023,"Hydro One Networks Inc.",null,null,null,2372015881.73,3745688.08,17241782660.84,1231922.1399999999,8598056675.4099998,24879861.059999999,9269841955.8199997,18802407.539999999,5089912715,11923831,35109681292.07,44914190.740000002,37481697173.800003,48659878.82,28211855217.98,10970072557.139999]
[2023,"Hydro One Remote Communities Inc.",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0]
[2023,"Hydro Ottawa Limited",null,null,null,460086452,744870,3369996951,735199,3370787772,7572774,30473699,58268,1373999970,2705866,6771258422,8366241,7231344874,9111111,7200871175,3830874224]
[2023,"InnPower Corporation",null,null,null,10424837.74,15129.72,221856675.91,13412.57,51250822.020000003,131559.91,null,null,9029763.1799999997,19681.78,273107497.93000001,144972.48000000001,283532335.67000002,160102.20000000001,283532335.67000002,61675659.760000005]
[2023,"Kingston Hydro Corporation",null,null,null,106954464.76000001,182101.52,297390367.24000001,85979.14,277027008.43000001,637229.55000000005,3540245.55,6347.58,203822684.12,404660.21,577957621.22000003,729556.27,684912085.98000002,911657.79,681371840.43000007,383981473.19]
[2023,"Lakefront Utilities Inc.",null,null,null,40172300.630000003,85837.66,112982817.81,14481.69,93342096.159999996,223621.14,null,null,60679596.990000002,130547.85,206324913.97,238102.83,246497214.59999999,323940.49,246497214.59999999,133514396.78999999]
[2023,"Lakeland Power Distribution Ltd.",null,null,null,28360289.390000001,44678.12,173218546.13999999,17246.75,101500008.47,249495.3,null,null,56894697.479999997,118918.85,274718554.61000001,266742.05,303078844,311420.17,303078844,129860297.86]
[2023,"London Hydro Inc.",null,null,null,230006396.59999999,391083.54,1685467032.25,336163.83,1262403299.04,3349923.26,15394925.02,57753.17,576960855.44000006,1405780.7,2963265256.3099999,3743840.26,3193271652.9099998,4134923.8,3177876727.8899999,1492409695.6399999]
[2023,"Milton Hydro Distribution Inc.",null,null,null,46477820,74178,470616608,47868,436384304,1049189,4161956,8156,275705238,544288,911162868,1105213,957640688,1179391,953478732,482862124]
[2023,"Newmarket-Tay Power Distribution Ltd.",null,null,null,73051669,121474,457934213,108275,292857664,717771,11375210,51740,121171097,269098,762167087,877786,835218756,999260,823843546,365909333]
[2023,"Niagara Peninsula Energy Inc.",null,null,null,81954514,146553.42000000001,561892258,581.65,594180108,1453820.1,2953784,5728.7,208200122.50999999,493992.85,1159026150,1460130.45,1240980664,1606683.87,1238026880,676134622]
[2023,"Niagara-on-the-Lake Hydro Inc.",null,null,null,18295789.789999999,34924.71,121354620.12,10185.799999999999,71260552.450000003,199046.39,0,0,8945376.9199999999,28987,192615172.56999999,209232.19,210910962.36000001,244156.9,210910962.36000001,89556342.24000001]
[2023,"North Bay Hydro Distribution Limited",null,null,null,52697105.659999996,98371.39,323662729.60000002,58241.89,174200739.37,436848.26,null,null,43203032.109999999,94318.11,497863468.97000003,495090.15,550560574.63,593461.54,550560574.63,226897845.03]
[2023,"Northern Ontario Wires Inc.",null,null,null,26221395,63125,53425143,null,35384979,94241,null,null,26858911,77629,88810122,94241,115031517,157366,115031517,61606374]
[2023,"Oakville Hydro Electricity Distribution Inc.",null,null,null,156943154.75999999,338161.25,864871406.63999999,233772.09,586612570.95000005,1500197.29,4007714.78,7312.45,202659681.19,452530.35,1455491692.3699999,1741281.83,1612434847.1300001,2079443.08,1608427132.3499999,743555725.71000004]
[2023,"Orangeville Hydro Limited",null,null,null,29210293.469999999,58201.5,135816956.25,37710.18,100553523.7,218948.91,2536172.29,5533.15,66370348.909999996,127034.69,238906652.24000001,262192.24,268116945.71000001,320393.74,265580773.42000002,129763817.17]
[2023,"Oshawa PUC Networks Inc.",null,null,null,62049243,100688,716941659,290905,297079748,728442,6436207,11967,84336643,191816,1020457614,1031314,1082506857,1132002,1076070650,359128991]
[2023,"Ottawa River Power Corporation",null,null,null,22736814,43579.71,116483978,20768.97,44339988,130132.42,null,null,3112822.11,8734.08,160823966,150901.39000000001,183560780,194481.1,183560780,67076802]
[2023,"PUC Distribution Inc.",null,null,null,55936990.039999999,79970.240000000005,416846109.16000003,121808.62,142208200.11000001,343502.7,null,null,38022530.420000002,87074.98,559054309.26999998,465311.32,614991299.30999994,545281.56000000006,614991299.31000006,198145190.15000001]
[2023,"Renfrew Hydro Inc.",null,null,null,12404936,21578.89,43757943,0,29953835,81589,0,0,13397355.08,25314.53,73711778,81589,86116714,103167.89,86116714,42358771]
[2023,"Rideau St. Lawrence Distribution Inc.",null,null,null,7586886,15293.66,61793921,6820.27,33789167,96506.71,null,null,10629083,28940.9,95583088,103326.98,103169974,118620.64,103169974,41376053]
[2023,"Sioux Lookout Hydro Inc.",null,null,null,1632425.28,2670.41,58228827.159999996,7825.38,23728245.300000001,55690.47,null,null,null,null,81957072.459999993,63515.85,83589497.739999995,66186.259999999995,83589497.739999995,25360670.580000002]
[2023,"Synergy North Corporation",null,null,null,59108553.030000001,88470.03,553168693,89360,358802055,981010,null,null,132105628,378791,911970748,1070370,971079301.02999997,1158840.03,971079301.02999997,417910608.02999997]
[2023,"Tillsonburg Hydro Inc.",null,null,null,21999246.32,59129.599999999999,86765882.590000004,28561.279999999999,73704459.969999999,194286.46,0,0,49472475.030000001,134865.72,160470342.56,222847.74,182469588.88,281977.34000000003,182469588.88,95703706.289999992]
[2023,"Toronto Hydro-Electric System Limited",null,null,null,2008699770.95,3994613.94,10466471018.32,7528550.1799999997,10879297487.690001,25903202.469999999,286136797.62,552035.5,5633827539.6899996,12006264.869999999,21631905303.630001,33983788.149999999,23640605074.580002,37978402.090000004,23354468276.959999,12887997258.640001]
[2023,"Wasaga Distribution Inc.",null,null,null,4006667,null,123144537,1207,15904511,46185.1,2821873,5657.5,0,0,141870921,53049.599999999999,145877588,null,143055715,19911178]
[2023,"Welland Hydro-Electric System Corp.",null,null,null,23149050,38348,227857345,2240,123459078,317013,2665199,4730,39512055,109689,353981622,323983,377130672,362331,374465473,146608128]
[2023,"Wellington North Power Inc.",null,null,null,33810297.07,68321.63,36402614.140000001,46.32,35052141.310000002,106400.97,0,0,49151738.539999999,112359.2,71454755.450000003,106447.29,105265052.52,174768.92,105265052.52000001,68862438.379999995]
[2023,"Westario Power Inc.",null,null,null,79039286,131279,253289943,12556,112123565,288816,659219,2663,74356737,190564,366072727,304035,445112013,435314,444452794,191162851]