Home Energy Audit



Down load the excel spreadsheet below to perform an energy audit on your own home.


               Home Energy Audit 4



If you have problems, you can let me know (r e f 7  [at]  p s u  [dot]  e d u).  I will respond and I will eventually get an FAQ posted below.


Comments about version 4:

               This is updated from the previous 3.1 version and 3.1b version to include all drop-down menus for the water and heat section.  The lighting section has been removed all-together and will be added back in the next version.  Also less significant water uses (dish washing and lavatory sink) have been removed from this version and may be added back in the next version. 




Directions and Comments


Utility Bills:

               It is imperative that you enter your own utility rates as they vary a great deal around the country. 



               CFB (compact fluorescent bulbs) come in a variety of packages today.  If purchased at a discount home store (Lowes, Home Depot, Menards, etc.) they are cheaper than standard incandescent bulbs.  At $2.00/bulb, a CFB will last for about 8000 hours compared to 8 long-lasting bulbs at $0.50/each for $4.00 or 16 standard bulbs at $0.25/each for $4.00.  In my experience the widest variety of energy-efficient bulbs are found at Home Depot and Walmart/Sams Club.

               CFBs also come in packages for indoor/outdoor flood lights ($8.00/each) and indoor recessed lighting ($6.00/each) and even low-voltage R14 fixtures ($8.00/each).

               CFBs can be ordered over the internet for dimming fixtures as well, but are more expensive (~$15-20/each).  Even at this price, they will still save money over the life of the bulb due to lower electricity consumption.

               CFBs may not be suitable for ceiling fan fixtures or chandelier fixtures.


               It is typical to save about $150/yr to change all the lights in your house.


Water usage:

               It is also imperative that you determine the real flowrate of your showerhead, and the real flush volume for your toilet.

               Low flow toilets have 1.6 gpf printed on the bowl (just under the back of the seat).  Click here for directions on how to measure the flush volume if it is not printed on your toilet.

               Measure the shower by using a mop bucket or 5 gallon bucket and a watch with a second hand.  While one person does the timing, one person will hold the bucket under the shower head to collect all the water for 15 seconds.  Then measure the water in the bucket by pouring it into a 1 or 2 quart pitcher.  The number of quarts collected in 15 seconds is equal to the flow rate in gpm (gallons per minute).


General comments:

               First it is important to note that savings are not cumulative unless indicated.  Thus if you enter a new type of furnace and see a savings of $1000/yr and you also enter additional insulation for a savings of $500/yr.  The savings for doing both will NOT be $1500.  It will be somewhat less (between the largest single item and the sum), in this case somewhere between the $1000 and $1500.