Free Utility Bill Tracking Spreadsheet Updated - Home Energy Savings For Energy Watchers

Free Utility Bill Tracking Spreadsheet Updated

What comes after "New & Improved"? We have just finished making additional improvements to our free utility bill tracking spreadsheet. This is by far the most popular item on Energy Watcher — we've tracked over 400 downloads of the spreadsheet in the past four months. How do you like it? Is there anything we can do to make it easier to use?

Would you be willing to share your data with us and the rest of the world? If so, please drop us a line at info@@energywatcher.com.

Click here to download the free Energy Watcher Utility Bill Tracking Spreadsheet and start tracking your utility bills today!
What's changed in this version?

  • We are now tracking utility bills at our house in this spreadsheet, which means that anyone who wants to see our data can just download this spreadsheet. We actually had separate copies, one for download and one for our utility bills — and since keeping track of changes was getting cumbersome, we merged the two versions.
  • The spreadsheet now calculates and tracks BTUs consumed per square foot. (There is a place on the first tab of the spreadsheet to enter the number of square feet in your house.) We have been tracking heating degree days (HDD) and cooling degree days (CDD) for years now — this lets us make useful comparisons between months, especially the same month on different years. Tracking BTUs per square foot now lets us make useful comparisons between houses. If your next-door neighbor is using this spreadsheet to keep track of his utility bills, you can now conveniently compare your results. And if you wanted to share your results with Energy Watcher — and our readers — we could compare our results with your results.
  • The spreadsheet now keeps track of the number of people living in your house. We only track this number for reference right now but we hope to incorporate it into a meaningful formula in the future. Why? The more people who live in your house, the more energy you use, regardless of how efficient you are. If we have five people living in our home and we use an average of 4,000 BTUs per square foot per month, and you have three people living in your home and your BTUs per square foot is the same, then we are more efficient than you are.
Using the utility bill tracking spreadsheet is very simple. (Obviously, you need to have a copy of Excel first.) First, download the spreadsheet to your computer. Then:
  • Click on the Introduction tab (at the bottom of the screen) and enter the number of square feet in your house in the space provided. (You may also want to enter your name.)

    Click here to download the free Energy Watcher Utility Bill Tracking Spreadsheet and start tracking your utility bills today!
  • Click on the Utility Bill Data tab (at the bottom of the screen) and enter your utility bill data. You can delete the existing data but if you do, be sure to save at least one row of it so you can copy that row to get the cell formulas. (There are formulas in columns D, G, J, K, and N.)
  • Click on the Monthly Utility Bills and Monthly Weather Chart tabs (at the bottom of the screen) to see handy graphs of your utility bill data:

    Sample Monthly Utility Bills Graph

    Sample Monthly Weather Chart