Municipal Internal Energy Data Management Workbook 

This workbook is the main workbook in the tool and has most of the functionality you will need. Its purpose is to combine Municipal and Eskom accounts and billing data into one data set and then report on that data.  Access workbook user guide links in the table below 

No.  Tab  Description  Video 
1  Introduction and How To  What the workbook is about  Here 
2  Assumptions  Assumptions used in this tool  Here 
3  Report  A summary report with all the key data points  Here 
4  Dashboard  An interactive dashboard that lets you visualize the data differently  Here 
5  POS Dashboard  An interactive dashboard that lets you visualize the point of supply data differently  Here 
6  Internal Accounts  This is a list of facilities or infrastructure that is supplied directly by the municipality.   Here 
7  Eskom Accounts  This is a list of facilities or infrastructure that is supplied directly by Eskom.   Here 
8  Internal Data  This is a list of monthly readings for all the points supplied directly by the municipality  Here 
9  Eskom Data  This is a list of monthly readings for all the points supplied directly by Eskom  Here 
10  All Consumption  This table combines the metered data from the municipal supplied accounts with the Eskom-supplied accounts  Here 
10  Point Of Supply  This table has a summary of the metered data for the main Eskom points of supply (distribution points)  Here 
12  Errors  A summary of errors in the data  Here 
13  Dropdown  Dropdown lists  Here