Weather Normalization

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:
  • Natural Gas
  • Electricity
  • Geothermal (if applicable)

  • In addition, weather data for the location of project is needed. This information can be obtained from the provided link with the instructions below.
  • NOAA National Weather Service
  • Select the nearest data center.
  • Go to the NOWData Tab and refine the location if needed.
  • Under the "Product" select "Monthly Summarized Data".
  • Input the desired range of years.
  • Set the "variable" drop down to either CDD or HDD.
  • Click go and copy data to the Data Entry tab of this file.

  • 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.