This spread sheet was created in order to aid with the processing and analysis of building energy usage. In order to operate this spread sheet you will need the following bills for each month in the period you wish to analyze:
In addition, weather data for the location of project is needed. This information can be obtained from the provided link with the instructions below.
The sheet will automatically calculate actual and expected energy usage and create graphs that can be found in the "Output Figures" tab. More detailed analysis can be found in the "Calculated Values" and "Regression Visualization" tabs.