{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["1. Information Sheet","List","GA Analysis ","GA 2014","GA 2015","GA 2016","GA 2017","GA Rates","2 1 5 TotalConsumptionData_Dist"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":7,"defined_names":98,"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":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Version 1.0"]
[]
["Account 1589 Global Adjustment (GA) Analysis Workform"]
[]
[null,"Input cells"]
[null,"Drop down cells"]
[]
[null,"Utility Name   ","ORANGEVILLE HYDRO LIMITED"]
[]
["Note 1","Year(s) Requested for Disposition"]
[]
[]
[]
[]
[]
[]
["Note 7 ","Summary of GA  (if multiple years requested for disposition)"]
[]
[null,"Year","Annual Net Change in Expected GA Balance from GA Analysis (cell K51)"," Net Change in Principal Balance in the  GL (cell C62)","Reconciling Items (sum of cells C63 to C75)","Adjusted Net Change in Principal Balance in the GL (cell C76)","Unresolved Difference","$ Consumption at Actual Rate Paid (cell J51)","Unresolved Difference as % of Expected GA Payments to IESO"]
[null,2014,{"$f":"'GA 2014'!K51","v":0},{"$f":"'GA 2014'!C62","v":0},{"$f":"SUM('GA 2014'!$C$63:$C$75)","v":0},{"$f":"'GA 2014'!$C$76","v":0},{"$f":"F29-C29","v":0},{"$f":"'GA 2014'!$J$51","v":0},{"$f":"IF(ISERROR(G29/H29),0,G29/H29)","v":0}]
[null,2015,{"$f":"'GA 2015'!K51","v":0},{"$f":"'GA 2015'!C62","v":0},{"$f":"SUM('GA 2015'!$C$63:$C$75)","v":0},{"$f":"'GA 2015'!$C$76","v":0},{"$f":"F30-C30","v":0},{"$f":"'GA 2015'!$J$51","v":0},{"$f":"IF(ISERROR(G30/H30),0,G30/H30)","v":0}]
[null,2016,{"$f":"'GA 2016'!K51","v":-1176.2002528001321},{"$f":"'GA 2016'!C62","v":175457.55},{"$f":"SUM('GA 2016'!$C$63:$C$75)","v":517857.31999999995},{"$f":"'GA 2016'!$C$76","v":693314.87},{"$f":"F31-C31","v":694491.07025280013},{"$f":"'GA 2016'!$J$51","v":12736981.204344602},{"$f":"IF(ISERROR(G31/H31),0,G31/H31)","v":5.452556293448154E-2}]
[null,2017,{"$f":"'GA 2017'!K51","v":216925.61052691378},{"$f":"'GA 2017'!C62","v":695800},{"$f":"SUM('GA 2017'!$C$63:$C$75)","v":-141484},{"$f":"'GA 2017'!$C$76","v":554316},{"$f":"F32-C32","v":337390.38947308622},{"$f":"'GA 2017'!$J$51","v":10533083.315749623},{"$f":"IF(ISERROR(G32/H32),0,G32/H32)","v":3.2031493472438624E-2}]
[null,"Cumulative Balance ",{"$f":"SUM(C29:C32)","v":215749.41027411364},871257.55,376373.31999999995,1247630.8700000001,{"$f":"SUM(G29:G32)","v":1031881.4597258864},23270064.520094223,"N/A"]

{"sheet":"List","index":1,"n_rows":66,"n_cols":2,"rows_kept":66,"cut":false,"hidden":true,"merged":[]}
["ALECTRA UTILITIES CORPORATION","HHPNS717"]
["ALGOMA POWER INC.","WKBSV849"]
["ATIKOKAN HYDRO INC.","NJYBW716"]
["BLUEWATER POWER DISTRIBUTION CORPORATION","GQQHM388"]
["BRANTFORD POWER INC.","SFXZP935"]
["BURLINGTON HYDRO INC.","OARZC118"]
["CANADIAN NIAGARA POWER INC.","HJHBH994"]
["CENTRE WELLINGTON HYDRO LTD.","KQEEH473"]
["CHAPLEAU PUBLIC UTILITIES CORPORATION","KQEEH474"]
["COLLUS POWERSTREAM CORP.","CPEFQ593"]
["COOPERATIVE HYDRO EMBRUN INC.","QXHJU641"]
["E.L.K. ENERGY INC.","AVXSO594"]
["ENERGY+ INC.","JMNNR431"]
["ENTEGRUS POWERLINES INC.","JKBZG525"]
["ENWIN UTILITIES LTD.","YEOQG654"]
["ERIE THAMES POWERLINES CORPORATION","PTLUC812"]
["ESPANOLA REGIONAL HYDRO DISTRIBUTION CORPORATION","ADICB565"]
["ESSEX POWERLINES CORPORATION","LRECV427"]
["FESTIVAL HYDRO INC.","KTCNY552"]
["FORT FRANCES POWER CORPORATION","YEPCI143"]
["GREATER SUDBURY HYDRO INC.","GRHTW113"]
["GRIMSBY POWER INCORPORATED","GMGHU415"]
["GUELPH HYDRO ELECTRIC SYSTEMS INC.","YTPWF351"]
["HALTON HILLS HYDRO INC.","YCYKQ642"]
["HEARST POWER DISTRIBUTION COMPANY LTD.","ADZFM459"]
["HYDRO 2000 INC.","RVWKN794"]
["HYDRO HAWKESBURY INC.","KESKM585"]
["HYDRO ONE NETWORKS INC.","MQFNL784"]
["HYDRO ONE REMOTE COMMUNITIES INC.","FNDHH648"]
["HYDRO OTTAWA LIMITED","PTREM828"]
["INNPOWER CORPORATION","UBBYF452"]
["KENORA HYDRO ELECTRIC CORPORATION LTD.","NSBED625"]
["KINGSTON HYDRO CORPORATION","TXKTT167"]
["KITCHENER-WILMOT HYDRO INC.","ZHKLA874"]
["LAKEFRONT UTILITIES INC.","YLJHT264"]
["LAKELAND POWER DISTRIBUTION LTD.","YLCEC559"]
["LONDON HYDRO INC.","NHKJF259"]
["MIDLAND POWER UTILITY CORPORATION","SLRXO177"]
["MILTON HYDRO DISTRIBUTION INC.","UIFEM157"]
["NEWMARKET - TAY POWER DISTRIBUTION LTD.","RUZIU984"]
["NIAGARA PENINSULA ENERGY INC.","KSUYD122"]
["NIAGARA-ON-THE-LAKE HYDRO INC.","QHCKN852"]
["NORTH BAY HYDRO DISTRIBUTION LIMITED","FUIJX538"]
["NORTHERN ONTARIO WIRES INC.","PWKJP953"]
["OAKVILLE HYDRO ELECTRICITY DISTRIBUTION INC.","JEGGW178"]
["ORANGEVILLE HYDRO LIMITED","TVKSH414"]
["ORILLIA POWER DISTRIBUTION CORPORATION","DUISI693"]
["OSHAWA PUC NETWORKS INC.","PQZCY963"]
["OTTAWA RIVER POWER CORPORATION","GTLBW445"]
["PETERBOROUGH DISTRIBUTION INCORPORATED","XCFPH269"]
["PUC DISTRIBUTION INC.","MLWYG784"]
["RENFREW HYDRO INC.","QDKIF127"]
["RIDEAU ST. LAWRENCE DISTRIBUTION INC.","AMZEN437"]
["SIOUX LOOKOUT HYDRO INC.","ACEVX242"]
["ST. THOMAS ENERGY INC.","DSPWZ318"]
["THUNDER BAY HYDRO ELECTRICITY DISTRIBUTION INC.","OLIUU862"]
["TILLSONBURG HYDRO INC.","OLIUU863"]
["TORONTO HYDRO-ELECTRIC SYSTEM LIMITED","OLIUU864"]
["VERIDIAN CONNECTIONS INC.","OLIUU865"]
["WASAGA DISTRIBUTION INC.","OLIUU866"]
["WATERLOO NORTH HYDRO INC.","OLIUU867"]
["WELLAND HYDRO-ELECTRIC SYSTEM CORP.","OLIUU868"]
["WELLINGTON NORTH POWER INC.","OLIUU869"]
["WEST COAST HURON ENERGY INC.","OLIUU870"]
["WESTARIO POWER INC.","OLIUU871"]
["WHITBY HYDRO ELECTRIC CORPORATION","OLIUU872"]

{"sheet":"GA Analysis ","index":2,"n_rows":95,"n_cols":24,"rows_kept":95,"cut":false,"hidden":true,"merged":[[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],[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]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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 2014","index":3,"n_rows":79,"n_cols":11,"rows_kept":79,"cut":false,"hidden":true,"merged":[[12,1,12,2],[12,4,12,5],[18,1,18,7],[55,7,55,9],[56,7,56,9],[24,1,24,5],[61,0,61,1],[60,3,60,7],[66,3,66,7],[67,3,67,7],[68,3,68,7],[61,3,61,7],[62,3,62,7],[63,3,63,7],[64,3,64,7],[65,3,65,7],[74,3,74,7],[69,3,69,7],[70,3,70,7],[71,3,71,7],[72,3,72,7],[73,3,73,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Note 2","Consumption Data Excluding for Loss Factor (Data to agree with RRR as applicable)"]
[null,"Year",null,2014]
[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 GA Rate used for unbilled revenue is the same as the one used for billed revenue in any particular month"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Note 4","Analysis of Expected GA Amount"]
[null,"Year",2014]
[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,"F","G","H","I = F-G+H","J","K = I*J","L","M = I*L","=M-K"]
[null,"January",null,null,null,{"$f":"C39-D39+E39","v":0},{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!N4,IF($C$23=\"2nd Estimate\",'GA Rates'!O4,IF($C$23=\"Actual\",'GA Rates'!P4,0)))","v":0},{"$f":"F39*G39","v":0},{"$f":"VLOOKUP(B39,'GA Rates'!$M$3:$P$15,4,FALSE)","v":1.261E-2},{"$f":"F39*I39","v":0},{"$f":"J39-H39","v":0}]
[null,"February",null,null,null,{"$f":"C40-D40+E40","v":0},{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!N5,IF($C$23=\"2nd Estimate\",'GA Rates'!O5,IF($C$23=\"Actual\",'GA Rates'!P5,0)))","v":0},{"$f":"F40*G40","v":0},{"$f":"VLOOKUP(B40,'GA Rates'!$M$3:$P$15,4,FALSE)","v":1.3300000000000001E-2},{"$f":"F40*I40","v":0},{"$f":"J40-H40","v":0}]
[null,"March",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!N6,IF($C$23=\"2nd Estimate\",'GA Rates'!O6,IF($C$23=\"Actual\",'GA Rates'!P6,0)))","v":0},0,{"$f":"VLOOKUP(B41,'GA Rates'!$M$3:$P$15,4,FALSE)","v":-2.7E-4},0,0]
[null,"April",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!N7,IF($C$23=\"2nd Estimate\",'GA Rates'!O7,IF($C$23=\"Actual\",'GA Rates'!P7,0)))","v":0},0,{"$f":"VLOOKUP(B42,'GA Rates'!$M$3:$P$15,4,FALSE)","v":5.1979999999999998E-2},0,0]
[null,"May",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!N8,IF($C$23=\"2nd Estimate\",'GA Rates'!O8,IF($C$23=\"Actual\",'GA Rates'!P8,0)))","v":0},0,{"$f":"VLOOKUP(B43,'GA Rates'!$M$3:$P$15,4,FALSE)","v":7.1959999999999996E-2},0,0]
[null,"June",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!N9,IF($C$23=\"2nd Estimate\",'GA Rates'!O9,IF($C$23=\"Actual\",'GA Rates'!P9,0)))","v":0},0,{"$f":"VLOOKUP(B44,'GA Rates'!$M$3:$P$15,4,FALSE)","v":6.0249999999999998E-2},0,0]
[null,"July",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!N10,IF($C$23=\"2nd Estimate\",'GA Rates'!O10,IF($C$23=\"Actual\",'GA Rates'!P10,0)))","v":0},0,{"$f":"VLOOKUP(B45,'GA Rates'!$M$3:$P$15,4,FALSE)","v":6.2560000000000004E-2},0,0]
[null,"August",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!N11,IF($C$23=\"2nd Estimate\",'GA Rates'!O11,IF($C$23=\"Actual\",'GA Rates'!P11,0)))","v":0},0,{"$f":"VLOOKUP(B46,'GA Rates'!$M$3:$P$15,4,FALSE)","v":6.7610000000000003E-2},0,0]
[null,"September",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!N12,IF($C$23=\"2nd Estimate\",'GA Rates'!O12,IF($C$23=\"Actual\",'GA Rates'!P12,0)))","v":0},0,{"$f":"VLOOKUP(B47,'GA Rates'!$M$3:$P$15,4,FALSE)","v":7.9629999999999992E-2},0,0]
[null,"October",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!N13,IF($C$23=\"2nd Estimate\",'GA Rates'!O13,IF($C$23=\"Actual\",'GA Rates'!P13,0)))","v":0},0,{"$f":"VLOOKUP(B48,'GA Rates'!$M$3:$P$15,4,FALSE)","v":0.10014000000000001},0,0]
[null,"November ",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!N14,IF($C$23=\"2nd Estimate\",'GA Rates'!O14,IF($C$23=\"Actual\",'GA Rates'!P14,0)))","v":0},0,{"$f":"VLOOKUP(B49,'GA Rates'!$M$3:$P$15,4,FALSE)","v":8.231999999999999E-2},0,0]
[null,"December",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!N15,IF($C$23=\"2nd Estimate\",'GA Rates'!O15,IF($C$23=\"Actual\",'GA Rates'!P15,0)))","v":0},0,{"$f":"VLOOKUP(B50,'GA Rates'!$M$3:$P$15,4,FALSE)","v":7.4439999999999992E-2},0,0]
[null,"Net Change in Expected GA Balance in the Year (i.e. Transactions in the Year)",{"$f":"SUM(C39:C50)","v":0},{"$f":"SUM(D39:D50)","v":0},{"$f":"SUM(E39:E50)","v":0},{"$f":"SUM(F39:F50)","v":0},null,{"$f":"SUM(H39:H50)","v":0},null,{"$f":"SUM(J39:J50)","v":0},{"$f":"SUM(K39:K50)","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Calculated Loss Factor",null,null,{"$f":"IFERROR(F51/D18,0)","v":0}]
[]
["Note 5 ","Reconciling Items "]
[]
[null," Item","Amount","Explanation"]
[" Net Change in Principal Balance in the GL (i.e. Transactions in the Year)"]
["1a","True-up of GA Charges based on Actual Non-RPP Volumes - prior year"]
["1b","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"]
[5,"Significant prior period billing adjustments recorded in current year"]
[6,"Differences in GA IESO posted rate and rate charged on IESO invoice"]
[7,"Differences in actual system losses and billed TLFs"]
[8,"Others as justified by distributor"]
[9]
[10]
["Note 6","Adjusted Net Change in Principal Balance in the GL",{"$f":"SUM(C62:C75)","v":0}]
[null,"Net Change in Expected GA Balance in the Year Per Analysis",{"$f":"K51","v":0}]
[null,"Unresolved Difference",{"$f":"C76-C77","v":0}]
[null,"Unresolved Difference as % of Expected GA Payments to IESO",{"$f":"IF(ISERROR(C78/J51),0,C78/J51)","v":0},{"$f":"IF(AND(C79<0.01,C79>-0.01),\"\",\"Unresolved differences of greater than + or - 1% should be explained\")","v":""}]

{"sheet":"GA 2015","index":4,"n_rows":79,"n_cols":11,"rows_kept":79,"cut":false,"hidden":true,"merged":[[12,1,12,2],[12,4,12,5],[18,1,18,7],[55,7,55,9],[56,7,56,9],[24,1,24,5],[61,0,61,1],[60,3,60,7],[66,3,66,7],[67,3,67,7],[68,3,68,7],[61,3,61,7],[62,3,62,7],[63,3,63,7],[64,3,64,7],[65,3,65,7],[74,3,74,7],[69,3,69,7],[70,3,70,7],[71,3,71,7],[72,3,72,7],[73,3,73,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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",{"$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 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",2015]
[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,"F","G","H","I = F-G+H","J","K = I*J","L","M = I*L","=M-K"]
[null,"January",null,null,null,{"$f":"C39-D39+E39","v":0},{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!J4,IF($C$23=\"2nd Estimate\",'GA Rates'!K4,IF($C$23=\"Actual\",'GA Rates'!L4,0)))","v":0},{"$f":"F39*G39","v":0},{"$f":"VLOOKUP(B39,'GA Rates'!$I$3:$L$15,4,FALSE)","v":5.0680000000000003E-2},{"$f":"F39*I39","v":0},{"$f":"J39-H39","v":0}]
[null,"February",null,null,null,{"$f":"C40-D40+E40","v":0},{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!J5,IF($C$23=\"2nd Estimate\",'GA Rates'!K5,IF($C$23=\"Actual\",'GA Rates'!L5,0)))","v":0},{"$f":"F40*G40","v":0},{"$f":"VLOOKUP(B40,'GA Rates'!$I$3:$L$15,4,FALSE)","v":3.9609999999999999E-2},{"$f":"F40*I40","v":0},{"$f":"J40-H40","v":0}]
[null,"March",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!J6,IF($C$23=\"2nd Estimate\",'GA Rates'!K6,IF($C$23=\"Actual\",'GA Rates'!L6,0)))","v":0},0,{"$f":"VLOOKUP(B41,'GA Rates'!$I$3:$L$15,4,FALSE)","v":6.2899999999999998E-2},0,0]
[null,"April",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!J7,IF($C$23=\"2nd Estimate\",'GA Rates'!K7,IF($C$23=\"Actual\",'GA Rates'!L7,0)))","v":0},0,{"$f":"VLOOKUP(B42,'GA Rates'!$I$3:$L$15,4,FALSE)","v":9.5590000000000008E-2},0,0]
[null,"May",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!J8,IF($C$23=\"2nd Estimate\",'GA Rates'!K8,IF($C$23=\"Actual\",'GA Rates'!L8,0)))","v":0},0,{"$f":"VLOOKUP(B43,'GA Rates'!$I$3:$L$15,4,FALSE)","v":9.6680000000000002E-2},0,0]
[null,"June",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!J9,IF($C$23=\"2nd Estimate\",'GA Rates'!K9,IF($C$23=\"Actual\",'GA Rates'!L9,0)))","v":0},0,{"$f":"VLOOKUP(B44,'GA Rates'!$I$3:$L$15,4,FALSE)","v":9.5400000000000013E-2},0,0]
[null,"July",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!J10,IF($C$23=\"2nd Estimate\",'GA Rates'!K10,IF($C$23=\"Actual\",'GA Rates'!L10,0)))","v":0},0,{"$f":"VLOOKUP(B45,'GA Rates'!$I$3:$L$15,4,FALSE)","v":7.8829999999999997E-2},0,0]
[null,"August",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!J11,IF($C$23=\"2nd Estimate\",'GA Rates'!K11,IF($C$23=\"Actual\",'GA Rates'!L11,0)))","v":0},0,{"$f":"VLOOKUP(B46,'GA Rates'!$I$3:$L$15,4,FALSE)","v":8.0099999999999991E-2},0,0]
[null,"September",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!J12,IF($C$23=\"2nd Estimate\",'GA Rates'!K12,IF($C$23=\"Actual\",'GA Rates'!L12,0)))","v":0},0,{"$f":"VLOOKUP(B47,'GA Rates'!$I$3:$L$15,4,FALSE)","v":6.7030000000000006E-2},0,0]
[null,"October",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!J13,IF($C$23=\"2nd Estimate\",'GA Rates'!K13,IF($C$23=\"Actual\",'GA Rates'!L13,0)))","v":0},0,{"$f":"VLOOKUP(B48,'GA Rates'!$I$3:$L$15,4,FALSE)","v":7.5439999999999993E-2},0,0]
[null,"November ",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!J14,IF($C$23=\"2nd Estimate\",'GA Rates'!K14,IF($C$23=\"Actual\",'GA Rates'!L14,0)))","v":0},0,{"$f":"VLOOKUP(B49,'GA Rates'!$I$3:$L$15,4,FALSE)","v":0.11320000000000001},0,0]
[null,"December",null,null,null,0,{"$f":"IF($C$23=\"1st Estimate\",'GA Rates'!J15,IF($C$23=\"2nd Estimate\",'GA Rates'!K15,IF($C$23=\"Actual\",'GA Rates'!L15,0)))","v":0},0,{"$f":"VLOOKUP(B50,'GA Rates'!$I$3:$L$15,4,FALSE)","v":9.4709999999999989E-2},0,0]
[null,"Net Change in Expected GA Balance in the Year (i.e. Transactions in the Year)",{"$f":"SUM(C39:C50)","v":0},{"$f":"SUM(D39:D50)","v":0},{"$f":"SUM(E39:E50)","v":0},{"$f":"SUM(F39:F50)","v":0},null,{"$f":"SUM(H39:H50)","v":0},null,{"$f":"SUM(J39:J50)","v":0},{"$f":"SUM(K39:K50)","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Calculated Loss Factor",null,null,{"$f":"IFERROR(F51/D18,0)","v":0}]
[]
["Note 5 ","Reconciling Items "]
[]
[null," Item","Amount","Explanation"]
[" Net Change in Principal Balance in the GL (i.e. Transactions in the Year)"]
["1a","True-up of GA Charges based on Actual Non-RPP Volumes - prior year"]
["1b","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"]
[5,"Significant prior period billing adjustments recorded in current year"]
[6,"Differences in GA IESO posted rate and rate charged on IESO invoice"]
[7,"Differences in actual system losses and billed TLFs"]
[8,"Others as justified by distributor"]
[9]
[10]
["Note 6","Adjusted Net Change in Principal Balance in the GL",{"$f":"SUM(C62:C75)","v":0}]
[null,"Net Change in Expected GA Balance in the Year Per Analysis",{"$f":"K51","v":0}]
[null,"Unresolved Difference",{"$f":"C76-C77","v":0}]
[null,"Unresolved Difference as % of Expected GA Payments to IESO",{"$f":"IF(ISERROR(C78/J51),0,C78/J51)","v":0},{"$f":"IF(AND(C79<0.01,C79>-0.01),\"\",\"Unresolved differences of greater than + or - 1% should be explained\")","v":""}]

{"sheet":"GA 2016","index":5,"n_rows":79,"n_cols":11,"rows_kept":79,"cut":false,"hidden":false,"merged":[[12,1,12,2],[12,4,12,5],[18,1,18,7],[55,7,55,9],[56,7,56,9],[24,1,24,5],[61,0,61,1],[60,3,60,7],[66,3,66,7],[67,3,67,7],[68,3,68,7],[61,3,61,7],[62,3,62,7],[63,3,63,7],[64,3,64,7],[65,3,65,7],[74,3,74,7],[69,3,69,7],[70,3,70,7],[71,3,71,7],[72,3,72,7],[73,3,73,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":241665676},"kWh",1]
[null,"RPP ","A",117299185,"kWh",{"$f":"IFERROR(D15/$D$14,0)","v":0.4853779276457944}]
[null,"Non RPP","B = D+E",{"$f":"D17+D18","v":124366491},"kWh",{"$f":"IFERROR(D16/$D$14,0)","v":0.51462207235420554}]
[null,"Non-RPP Class A","D",null,"kWh",{"$f":"IFERROR(D17/$D$14,0)","v":0}]
[null,"Non-RPP Class B*","E",124366491,"kWh",{"$f":"IFERROR(D18/$D$14,0)","v":0.51462207235420554}]
[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 ","2nd Estimate"]
[]
[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 Variance ($)"]
[null,null,"F","G","H","I = F-G+H","J","K = I*J","L","M = I*L","=M-K"]
[null,"January",10023674.379999999,10086740.27,10408936.829999994,{"$f":"C39-D39+E39","v":10345870.939999994},{"$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":9.214E-2},{"$f":"F39*G39","v":953268.54841159948},{"$f":"VLOOKUP(B39,'GA Rates'!$E$3:$H$15,4,FALSE)","v":9.1789999999999997E-2},{"$f":"F39*I39","v":949647.49358259945},{"$f":"J39-H39","v":-3621.0548290000297}]
[null,"February",11277989.039999999,10408936.829999994,10308648.34,{"$f":"C40-D40+E40","v":11177700.550000004},{"$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":9.6780000000000005E-2},{"$f":"F40*G40","v":1081777.8592290005},{"$f":"VLOOKUP(B40,'GA Rates'!$E$3:$H$15,4,FALSE)","v":9.851E-2},{"$f":"F40*I40","v":1101115.2811805005},{"$f":"J40-H40","v":19337.4219515}]
[null,"March",9817547.4400000013,10308648.34,11401052.559999999,10909951.66,{"$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.10299},1123615.9214633999,{"$f":"VLOOKUP(B41,'GA Rates'!$E$3:$H$15,4,FALSE)","v":0.1061},1157545.8711260001,33929.949662600178]
[null,"April",10935294.649999999,11401052.559999999,11019433.570000002,10553675.660000002,{"$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.11176999999999999},1179584.3285182002,{"$f":"VLOOKUP(B42,'GA Rates'!$E$3:$H$15,4,FALSE)","v":0.11132},1174835.1744712002,-4749.1540469999891]
[null,"May",11006262,11019433.570000002,10888099.689999998,10874928.119999995,{"$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.11493},1249855.4888315995,{"$f":"VLOOKUP(B43,'GA Rates'!$E$3:$H$15,4,FALSE)","v":0.10749},1168946.0236187996,-80909.465212799842]
[null,"June",10425952.5,10888099.689999998,10212324.449999999,9750177.2600000016,{"$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":9.3600000000000003E-2},912616.59153600014,{"$f":"VLOOKUP(B44,'GA Rates'!$E$3:$H$15,4,FALSE)","v":9.5449999999999993E-2},930654.41946700006,18037.82793099992]
[null,"July",11152274.59,10212324.449999999,11567300.159999998,12507250.299999999,{"$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":8.412E-2},1052109.895236,{"$f":"VLOOKUP(B45,'GA Rates'!$E$3:$H$15,4,FALSE)","v":8.3059999999999995E-2},1038852.2099179998,-13257.685318000149]
[null,"August",11251303.630000001,11567300.159999998,11038762.289999999,10722765.760000002,{"$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":7.0499999999999993E-2},755954.98608000006,{"$f":"VLOOKUP(B46,'GA Rates'!$E$3:$H$15,4,FALSE)","v":7.1029999999999996E-2},761638.0519328001,5683.0658528000349]
[null,"September",11863639.849999998,11038762.289999999,11388711.950000001,12213589.51,{"$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":9.1480000000000006E-2},1117299.1683748001,{"$f":"VLOOKUP(B47,'GA Rates'!$E$3:$H$15,4,FALSE)","v":9.5310000000000006E-2},1164077.2161981,46778.047823299887]
[null,"October",10991444.550000001,11388711.950000001,11411183.640000001,11013916.24,{"$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.1178},1297439.333072,{"$f":"VLOOKUP(B48,'GA Rates'!$E$3:$H$15,4,FALSE)","v":0.11226},1236422.2371024,-61017.095969599904]
[null,"November ",11318697.600000001,11411183.640000001,10967739.040000003,10875253.000000004,{"$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.115},1250654.0950000004,{"$f":"VLOOKUP(B49,'GA Rates'!$E$3:$H$15,4,FALSE)","v":0.11108999999999999},1208131.8557700003,-42522.239230000181]
[null,"December",10981882.49,10967739.040000003,9690902.1400000006,9705045.589999998,{"$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":7.8719999999999998E-2},763981.18884479988,{"$f":"VLOOKUP(B50,'GA Rates'!$E$3:$H$15,4,FALSE)","v":8.7080000000000005E-2},845115.36997719982,81134.181132399943]
[null,"Net Change in Expected GA Balance in the Year (i.e. Transactions in the Year)",{"$f":"SUM(C39:C50)","v":131045962.71999998},{"$f":"SUM(D39:D50)","v":130698932.79000001},{"$f":"SUM(E39:E50)","v":130303094.66},{"$f":"SUM(F39:F50)","v":130650124.59},null,{"$f":"SUM(H39:H50)","v":12738157.4045974},null,{"$f":"SUM(J39:J50)","v":12736981.204344602},{"$f":"SUM(K39:K50)","v":-1176.2002528001321}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Calculated Loss Factor",null,null,{"$f":"IFERROR(F51/D18,0)","v":1.0505251337355817}]
[]
["Note 5 ","Reconciling Items "]
[]
[null," Item","Amount","Explanation"]
[" Net Change in Principal Balance in the GL (i.e. Transactions in the Year)",null,175457.55]
["1a","True-up of GA Charges based on Actual Non-RPP Volumes - prior year"]
["1b","True-up of GA Charges based on Actual Non-RPP Volumes - current year",602574.66]
["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",91211.06]
["3b","Add difference between current year accrual/forecast to actual from long term load transfers",-103347.37]
[4,"Remove GA balances pertaining to Class A customers"]
[5,"Significant prior period billing adjustments recorded in current year"]
[6,"Differences in GA IESO posted rate and rate charged on IESO invoice"]
[7,"Differences in actual system losses and billed TLFs"]
[8,"Others as justified by distributor"]
[9,"Load transfer for the period of Jan 1/15 to Dec 31/15.  ",-72581.03,"Booked in G/L in 2016 incorrectly as a credit to Energy instead of GA"]
[10]
["Note 6","Adjusted Net Change in Principal Balance in the GL",{"$f":"SUM(C62:C75)","v":693314.87}]
[null,"Net Change in Expected GA Balance in the Year Per Analysis",{"$f":"K51","v":-1176.2002528001321}]
[null,"Unresolved Difference",{"$f":"C76-C77","v":694491.07025280013}]
[null,"Unresolved Difference as % of Expected GA Payments to IESO",{"$f":"IF(ISERROR(C78/J51),0,C78/J51)","v":5.452556293448154E-2},{"$f":"IF(AND(C79<0.01,C79>-0.01),\"\",\"Unresolved differences of greater than + or - 1% should be explained\")","v":"Unresolved differences of greater than + or - 1% should be explained"}]

{"sheet":"GA 2017","index":6,"n_rows":79,"n_cols":11,"rows_kept":79,"cut":false,"hidden":false,"merged":[[64,3,64,7],[12,1,12,2],[12,4,12,5],[18,1,18,7],[55,7,55,9],[56,2,56,4],[60,3,60,7],[61,3,61,7],[62,3,62,7],[63,3,63,7],[24,1,24,5],[61,0,61,1],[71,3,71,7],[72,3,72,7],[73,3,73,7],[74,3,74,7],[65,3,65,7],[66,3,66,7],[67,3,67,7],[68,3,68,7],[69,3,69,7],[70,3,70,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Note 2","Consumption Data Excluding for Loss Factor (Data to agree with RRR as applicable)"]
[null,"Year",null,2017]
[null,"Total Metered excluding WMP","C = A+B",{"$f":"VLOOKUP('1. Information Sheet'!C17,'2 1 5 TotalConsumptionData_Dist'!B4:U70,19,FALSE)","v":244388936.24000001},"kWh",1]
[null,"RPP ","A",{"$f":"VLOOKUP('1. Information Sheet'!C17,'2 1 5 TotalConsumptionData_Dist'!B4:U70,7,FALSE)","v":117466613.44},"kWh",{"$f":"IFERROR(D15/$D$14,0)","v":0.4806543833254503}]
[null,"Non RPP","B = D+E",{"$f":"VLOOKUP('1. Information Sheet'!C17,'2 1 5 TotalConsumptionData_Dist'!B4:U70,20,FALSE)","v":126922322.8},"kWh",{"$f":"IFERROR(D16/$D$14,0)","v":0.51934561667454959}]
[null,"Non-RPP Class A","D",{"$f":"VLOOKUP('1. Information Sheet'!C17,'2 1 5 TotalConsumptionData_Dist'!B4:U70,13,FALSE)","v":23243911},"kWh",{"$f":"IFERROR(D17/$D$14,0)","v":9.5110324377260358E-2}]
[null,"Non-RPP Class B*","E",{"$f":"D16-D17","v":103678411.8},"kWh",{"$f":"IFERROR(D18/$D$14,0)","v":0.42423529229728929}]
[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 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 Variance ($)"]
[null,null,"F","G","H","I = F-G+H","J","K = I*J","L","M = I*L","=M-K"]
[null,"January",9640088.1400000006,9690902.1400000006,9677325.2200000007,{"$f":"C39-D39+E39","v":9626511.2200000007},{"$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":6.6869999999999999E-2},{"$f":"F39*G39","v":643724.80528139998},{"$f":"VLOOKUP(B39,'GA Rates'!$A$3:$D$15,4,FALSE)","v":8.2269999999999996E-2},{"$f":"F39*I39","v":791973.07806940004},{"$f":"J39-H39","v":148248.27278800006}]
[null,"February",11184946.710000001,9677325.2200000007,10070139,{"$f":"C40-D40+E40","v":11577760.49},{"$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.10559},{"$f":"F40*G40","v":1222495.7301391},{"$f":"VLOOKUP(B40,'GA Rates'!$A$3:$D$15,4,FALSE)","v":8.6389999999999995E-2},{"$f":"F40*I40","v":1000202.7287311},{"$f":"J40-H40","v":-222293.00140800001}]
[null,"March",10032727.26,10070139,11092294.529999999,11054882.789999999,{"$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":8.4089999999999998E-2},929605.09381109988,{"$f":"VLOOKUP(B41,'GA Rates'!$A$3:$D$15,4,FALSE)","v":7.1349999999999997E-2},788765.88706649991,-140839.20674459997]
[null,"April",11253267.309999999,11092294.529999999,10904118.199999999,11065090.979999999,{"$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":6.8739999999999996E-2},760614.3539651999,{"$f":"VLOOKUP(B42,'GA Rates'!$A$3:$D$15,4,FALSE)","v":0.10778},1192595.5058243999,431981.15185919998]
[null,"May",10317915.029999999,10904118.199999999,10639480.970000001,10053277.800000001,{"$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.10623},1067959.7006940001,{"$f":"VLOOKUP(B43,'GA Rates'!$A$3:$D$15,4,FALSE)","v":0.12307},1237256.898846,169297.19815199985]
[null,"June",10760108.68,10639480.970000001,10598082.289999997,10718709.999999996,{"$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.11954000000000001},1281314.5933999997,{"$f":"VLOOKUP(B44,'GA Rates'!$A$3:$D$15,4,FALSE)","v":0.11848},1269952.7607999996,-11361.832600000082]
[null,"July",6049942.4299999997,10598082.289999997,11149541.390000002,6601401.5300000049,{"$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.10651999999999999},703181.29097560048,{"$f":"VLOOKUP(B45,'GA Rates'!$A$3:$D$15,4,FALSE)","v":0.1128},744638.09258400055,41456.80160840007]
[null,"August",7174324.5700000003,11149541.390000002,6994738.257600002,3019521.4375999998,{"$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.115},347244.96532399999,{"$f":"VLOOKUP(B46,'GA Rates'!$A$3:$D$15,4,FALSE)","v":0.10109},305243.42212698399,-42001.543197015999]
[null,"September",7898999.7399999993,6994738.257600002,7120454.1037000027,8024715.5861,{"$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.12739},1022268.518513279,{"$f":"VLOOKUP(B47,'GA Rates'!$A$3:$D$15,4,FALSE)","v":8.8639999999999997E-2},711310.78955190396,-310957.72896137508]
[null,"October",7663875.29,7120454.1037000027,7229841.8088000026,7773262.9950999999,{"$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.10212},793805.61705961206,{"$f":"VLOOKUP(B48,'GA Rates'!$A$3:$D$15,4,FALSE)","v":0.12562999999999999},976555.03007441293,182749.41301480087]
[null,"November ",7121569.3099999996,7229841.8088000026,7159386.6376000009,7051114.138799998,{"$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.11164},787186.38245563174,{"$f":"VLOOKUP(B49,'GA Rates'!$A$3:$D$15,4,FALSE)","v":9.7040000000000001E-2},684240.11602915183,-102946.26642647991]
[null,"December",7689067.75,7159386.6376000009,8488989.5300000012,9018670.6424000002,{"$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":8.3909999999999998E-2},756756.65360378404,{"$f":"VLOOKUP(B50,'GA Rates'!$A$3:$D$15,4,FALSE)","v":9.2069999999999999E-2},830349.00604576804,73592.352441983996]
[null,"Net Change in Expected GA Balance in the Year (i.e. Transactions in the Year)",{"$f":"SUM(C39:C50)","v":106786832.22},{"$f":"SUM(D39:D50)","v":112326304.54769999},{"$f":"SUM(E39:E50)","v":111124391.9377},{"$f":"SUM(F39:F50)","v":105584919.61},null,{"$f":"SUM(H39:H50)","v":10316157.705222709},null,{"$f":"SUM(J39:J50)","v":10533083.315749623},{"$f":"SUM(K39:K50)","v":216925.61052691378}]
[]
[]
[]
[]
[]
[null,null,"Calculated Loss Factor",null,null,{"$f":"IFERROR(F51/D18,0)","v":1.0183886671959996}]
[]
["Note 5 ","Reconciling Items "]
[]
[null," Item","Amount","Explanation"]
[" Net Change in Principal Balance in the GL (i.e. Transactions in the Year)",null,695800]
["1a","True-up of GA Charges based on Actual Non-RPP Volumes - prior year"]
["1b","True-up of GA Charges based on Actual Non-RPP Volumes - current year",-244831]
["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",103347]
["3b","Add difference between current year accrual/forecast to actual from long term load transfers"]
[4,"Remove GA balances pertaining to Class A customers"]
[5,"Significant prior period billing adjustments recorded in current year"]
[6,"Differences in GA IESO posted rate and rate charged on IESO invoice"]
[7,"Differences in actual system losses and billed TLFs"]
[8,"Others as justified by distributor"]
[9]
[10]
["Note 6","Adjusted Net Change in Principal Balance in the GL",{"$f":"SUM(C62:C75)","v":554316}]
[null,"Net Change in Expected GA Balance in the Year Per Analysis",{"$f":"K51","v":216925.61052691378}]
[null,"Unresolved Difference",{"$f":"C76-C77","v":337390.38947308622}]
[null,"Unresolved Difference as % of Expected GA Payments to IESO",{"$f":"IF(ISERROR(C78/J51),0,C78/J51)","v":3.2031493472438624E-2},{"$f":"IF(AND(C79<0.01,C79>-0.01),\"\",\"Unresolved differences of greater than + or - 1% should be explained\")","v":"Unresolved differences of greater than + or - 1% should be explained"}]

{"sheet":"GA Rates","index":7,"n_rows":15,"n_cols":16,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["GA Rates per IESO website"]
[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"]
["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.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",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",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",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.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.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.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.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.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.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",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]

{"sheet":"2 1 5 TotalConsumptionData_Dist","index":8,"n_rows":71,"n_cols":21,"rows_kept":71,"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,"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","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","COLLUS POWERSTREAM CORP.",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","COOPERATIVE HYDRO EMBRUN INC.",null,null,null,798369,0,23247457,0,3782579,11209,0,0,0,0,27030036,11209,27828405,11209,27828405,4580948]
["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,136208932.96000001,265808,375649810.44019997,99051.963333000007,367692738.333,1063877.45,4583831.7300000004,11680.77,238476526,548902,747926380.50320005,1174610.1833329999,884135313.46319997,1440418.1833329999,879551481.73320007,503901671.29299998]
["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","ERIE THAMES POWERLINES CORPORATION",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","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","GUELPH HYDRO ELECTRIC SYSTEMS INC.",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","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 COMPANY LTD.",null,null,null,4459529,8648,34531487,15231,38261730,97243,0,0,0,0,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","KENORA HYDRO ELECTRIC CORPORATION LTD.",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","MIDLAND POWER UTILITY CORPORATION",null,null,null,38551704.280000001,77134,70437021.280000001,27565.94,69549138.439999998,177384.71,3744910.71,6972.13,22526218,7643.95,143731070.43000001,211922.78,182282774.71000001,289056.84000000003,178537864,108100842.72]
["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,66556759,109844,344187239,0,176027521,556827,4601246,9614,35496456,70815,524816006,566441,591372765,676285,586771519,242584280]
["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,23243911,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","ST. THOMAS ENERGY INC.",null,null,null,47144480.899999999,71939,144544013.09999999,25062.86,79830093.400000006,205873.8,3784934.67,7228.33,21216894.309999999,50308.93,228159041.16999999,238164.99,275303522.06999999,310104.89,271518587.39999998,126974574.30000001]
["2018","THUNDER BAY HYDRO ELECTRICITY DISTRIBUTION INC.",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","VERIDIAN CONNECTIONS INC.",null,null,null,250846891,390824,1202178782,257570,1017409890,2245224,38095925,74250,413770175,787331,2257684597,2577044,2508531488,2967868,2470435563,1268256781]
["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","WEST COAST HURON ENERGY INC.",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","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]
["2018","WHITBY HYDRO ELECTRIC CORPORATION",null,null,null,106725615,185907,449207866,135039,263146477,601259,4279141,8605,98787815,171705,716633484,744903,823359099,930810,819079958,369872092]
[""]