LDC (Yearbooks)

The Ontario Energy Board (OEB) has published a Yearbook of Electricity Distributors for every year since 2005, posting the reporting in both .pdf and Microsoft Excel Format.

I have tried to work the Excel format into a workable data format to allow viewing metrics across multiple years, and to aid deeper data analysis. Those familiar with the organization of the yearbooks, and excel may find these workbooks useful:

• Balance Sheets
• Income Statements
• Stats by (Customer) Class
• Service Quality Requirments/Indicators
• General Statistics
• Financial Ratios

These worksheets, along with the Microsoft Database they pulled data from, are located in a OneDrive folder.

I have also put together a very basic Power BI page.

Mistakes in working the data are my own. I've not added any data from sources other than OEB Yearbooks, so any discrepancies are due either to my errors today, or to revisions the OEB subsequently may make.