{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["Table of Contents","Sch. A","Sch. 1","Sch. 2","Sch. 3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":4,"defined_names":235,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Table of Contents","index":0,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,0,2,1],[5,0,5,1]]}
[]
[]
["AUC RULE 005:  ANNUAL DEFAULT RATE TARIFF (DRT) FINANCIAL AND OPERATIONAL RESULTS"]
[]
[]
["TABLE OF CONTENTS"]
[]
["Schedule","Description"]
[]
["A","Purpose of DRT schedules"]
[1,"Revenue by customer class"]
[2,"Sites and energy sales by customer class"]
[3,"Expenses"]

{"sheet":"Sch. A","index":1,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,0,10,10],[4,0,4,10]]}
[{"$nulls":10},"SCHEDULE A"]
["Purpose of DRT Schedules "]
[]
["Schedule 1 – Revenue by customer class"]
["To provide a detailed revenue breakdown of energy, non-energy and flow-through revenue by customer category relevant to each provider."]
[]
["Schedule 2 – Sites and energy sales by customer class"]
["To provide a breakdown of the average number of sites and energy sales by customer category relevant to each provider.  "]
[]
["Schedule 3 - Expenses"]
["To provide a detailed breakdown of expenses associated with the provision of gas services. Expenses are separated into energy related and operating expenses, flow-though, operating and income tax. Provider energy-related expenses are for the purchase of physical natural gas only."]

{"sheet":"Sch. 1","index":2,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[[41,3,41,10],[42,3,42,10],[2,0,2,9],[3,0,3,9],[5,7,5,9],[20,7,20,9],[40,3,40,10],[39,3,39,10],[38,3,38,10]]}
[{"$nulls":10},"SCHEDULE 1"]
[]
["REVENUE BY CUSTOMER CLASS"]
["($000s)"]
[]
["Line",{"$nulls":6},2009]
["No.",null,null,null,"Description",null,null,"Residential","Commercial","Total *"]
[]
[null,null,"Revenue: "]
[1,null,"Energy revenue",{"$nulls":6},{"$f":"SUM(H10:I10)","v":0}]
[2,null,"Non-energy revenue",{"$nulls":6},{"$f":"SUM(H11:I11)","v":0}]
[3,null,"Flow-through revenue",{"$nulls":6},{"$f":"SUM(H12:I12)","v":0}]
[4,{"$nulls":4},"Total revenue",null,{"$f":"SUM(H10:H12)","v":0},{"$f":"SUM(I10:I12)","v":0},{"$f":"SUM(J10:J12)","v":0}]
[]
[]
[5,null,"Revenue offsets and other adjustments:",{"$nulls":6},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
[]
[6,{"$nulls":4},"Total",null,null,null,{"$f":"J13+J16","v":{"$error":"#REF!"}}]
[]
[]
["Line",{"$nulls":6},2008]
["No.",null,null,null,"Description",null,null,"Residential","Commercial","Total *"]
[]
[null,null,"Revenue: "]
[1,null,"Energy revenue"]
[2,null,"Non-energy revenue"]
[3,null,"Flow-through revenue"]
[4,{"$nulls":4},"Total revenue",null,{"$f":"SUM(H25:H27)","v":0},{"$f":"SUM(I25:I27)","v":0},{"$f":"SUM(J25:J27)","v":0}]
[]
[5,null,"Revenue offsets and other adjustments:",{"$nulls":6},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
[]
[6,{"$nulls":4},"Total",null,null,null,{"$f":"J28+J30","v":{"$error":"#REF!"}}]
[]
[]
[]
["* If other customer categories exist, please insert and report in an additional column(s)."]
[]
["Line No.",null,"Line Item Definitions:"]
[1,null,null,"Energy revenue: revenue associated with the energy charges billed (gas cost flow through rate or gas cost recovery rate) and approved return margin as applicable."]
[2,null,null,"Non-energy revenue: revenue associated with administration charges or customer charges (billed at a fixed amount per day or month). "]
[3,null,null,"Flow-through revenue: revenue associated with the total distribution tariff, transmission tariff, franchise fee, and local access fee charges billed to customers, on behalf of the distribution utility."]
[5,null,null,"Revenue offsets and other adjustments: Final notice fees + Title search fees + Application fees + Penalty revenue + Other; where:\nTitle search fees: fees associated with the recovery of costs for land title search costs and business registries costs (used to locate owners of a premise when there is no applicant for service and the meter is registering consumption or the site is being charged idle distribution / transmission charges by the distribution company).\nApplication fees: fees charged by the provider to set up service. \nPenalty revenue: revenue associated with the collection of late fees charged to accounts when customers do not pay their bills on time.\nOther: includes all miscellaneous revenues that are not accounted for in another line."]
[6,null,null,"Total: equal to line 4 plus line 5."]

{"sheet":"Sch. 2","index":3,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[31,2,31,7],[32,2,32,7],[4,5,4,7],[1,0,1,7],[16,5,16,7],[30,2,30,7],[27,0,27,9]]}
[{"$nulls":7},"SCHEDULE 2"]
["SITES AND ENERGY SALES BY CUSTOMER CLASS"]
[]
[]
["Line",{"$nulls":4},2009]
["No.",null,null,"Description",null,"Residential","Commercial","Total *"]
[]
[{"$f":"A7+1","v":1},null,"Sites - average",{"$nulls":4},{"$f":"SUM(F8:G8)","v":0}]
[]
[2,null,"Energy sales (terajoules) ",{"$nulls":4},{"$f":"SUM(F10:G10)","v":0}]
[]
[3,null,"Energy sales per site (gigajoules per site)",null,null,{"$f":"(+F10/F8)*1000","v":{"$error":"#DIV/0!"}},{"$f":"(+G10/G8)*1000","v":{"$error":"#DIV/0!"}}]
[]
[4,null,"Sites as of December 31"]
[]
[]
["Line",{"$nulls":4},2008]
["No.",null,null,"Description",null,"Residential","Commercial","Total *"]
[]
[{"$f":"A19+1","v":1},null,"Sites - average",{"$nulls":4},{"$f":"SUM(F20:G20)","v":0}]
[]
[2,null,"Energy sales (terajoules) ",{"$nulls":4},{"$f":"SUM(F22:G22)","v":0}]
[]
[3,null,"Energy sales per site (gigajoules per site)",null,null,{"$f":"(+F22/F20)*1000","v":{"$error":"#DIV/0!"}},{"$f":"(+G22/G20)*1000","v":{"$error":"#DIV/0!"}}]
[]
[4,null,"Sites as of December 31"]
[]
["* If other customer categories exist, please insert and report each additional customer category in a separate column."]
[]
["Line No.",null,"Line Item Definitions:"]
[1,null,"Sites - average:  number of sites based on monthly average for the calendar year.  A  “site” is generally defined as being the finest or lowest level of consumption or usage data.  A “site” generally represents a meter installation."]
[2,null,"Energy sales (terajoules): total energy billed and accrued for the applicable customer class."]
[3,null,"Energy sales per site: line 2 multiplied by 1,000 and divided by line 1."]

{"sheet":"Sch. 3","index":4,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[[35,2,35,8],[33,2,33,8],[37,2,37,8],[39,2,39,8],[1,0,1,8],[2,0,2,8],[30,2,30,8],[32,2,32,8],[27,2,27,8],[31,2,31,8],[34,2,34,8],[36,2,36,8],[38,2,38,8]]}
[{"$nulls":9},"SCHEDULE 3"]
["EXPENSES"]
["($000s)"]
[]
["Line",{"$nulls":6},"Variance","Variance"]
["No.",null,"Description",null,2009,2008,null,"higher/(lower)","%"]
[]
[null,null,"Energy"]
[1,null,"Gas purchases",{"$nulls":4},{"$f":"E9-F9","v":0},{"$f":"H9/F9","v":{"$error":"#DIV/0!"}}]
[]
[2,null,"Flow-through expenses",{"$nulls":4},{"$f":"E11-F11","v":0},{"$f":"H11/F11","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Operating expenses (Note)"]
[3,null,"Credit costs",{"$nulls":4},{"$f":"E14-F14","v":0},{"$f":"H14/F14","v":{"$error":"#DIV/0!"}}]
[4,null,"Billing and customer care",{"$nulls":4},0,{"$error":"#DIV/0!"}]
[5,null,"Corporate allocations ",{"$nulls":4},0,{"$error":"#DIV/0!"}]
[6,null,"Operational and administration costs",{"$nulls":4},{"$f":"E17-F17","v":0},{"$f":"H17/F17","v":{"$error":"#DIV/0!"}}]
[7,null,"Bad debts expense",{"$nulls":4},0,{"$error":"#DIV/0!"}]
[8,null,"AUC administration fee",{"$nulls":4},0,{"$error":"#DIV/0!"}]
[9,null,"Hearing costs",{"$nulls":4},0,{"$error":"#DIV/0!"}]
[10,null,"Other",{"$nulls":4},0,{"$error":"#DIV/0!"}]
[]
[11,null,"Income tax",{"$nulls":4},{"$f":"E23-F23","v":0},{"$f":"H23/F23","v":{"$error":"#DIV/0!"}}]
[]
[12,null,"Total expenses",null,{"$f":"SUM(E9:E23)","v":0},{"$f":"SUM(F9:F23)","v":0},null,{"$f":"E25-F25","v":0},{"$f":"H25/F25","v":{"$error":"#DIV/0!"}}]
[]
[]
["Note",null,"The expenses reported above should exclude regulatory disallowances.\nA regulatory cost disallowance is a cost incurred by a default supply provider in the course of business, but the Commission specifically disallowed the inclusion of the cost in a rate setting decision or an AUC rule."]
[]
["Line No.",null,"Line Item Definitions:"]
[1,null,"Gas purchases: the cost of physical gas purchased and expensed associated with the gas cost flow through rate or gas cost recovery rate as applicable."]
[2,null,"Credit costs: costs associated with collateral requirements (parental guarantee, letter of credit) of trading exchanges or counterparties."]
[3,null,"Billing & customer care: costs related to billing, call centre and other customer support functions."]
[4,null,"Corporate allocations: allocated corporate overhead based on AUC approved methodologies."]
[5,null,"Operational and administration costs: expenses associated with the management of the DRT, including salaries, consultant fees, and travel expenses."]
[6,null,"Bad debts expense: the amount of non-collectible accounts receivable associated with DRT billings."]
[7,null,"AUC administration fee: a fee sufficient to pay for the Commissions's estimated net expenditures associated with carrying out its powers, duties and functions as assessed by the AUC under Rule 025.  "]
[8,null,"Hearing costs: costs associated with proceedings for DRT applications that are approved by the Commission.  "]
[9,null,"Other: includes all expenses not accounted for in line items above. Please identify."]
[11,null,"Income tax: Total income tax provision, as the total income tax expense recognized for regulatory purposes as approved by the AUC. "]