Energy Monitoring Data

Google Drive Spreadsheet


9 Responses to Energy Monitoring Data

  1. Celes Davar says:

    Hi there,

    Really appreciated reading the news piece on your home and your blog. Congrats!

    Our son (MArch grad from Dal) has designed our new Passive House that we will be building in the Gaspereau Valley next year in NS. We designed and built our first environmental home in Manitoba 20 years ago, an R-2000 standard. We are looking forward to building our home at Passive House standards. We may give you a call sometime when we are back to the Maritimes next year. Would you be amenable if we came to visit your home?

    I am curious and confused by the information in the spreadsheet which indicates that the first column shows house data for a house with water heater and electric heat; and then the water heater costs and electric heat costs are added to that in subsequent columns. So, what are the base costs for in the first column? Could you please clarify? Thank you kindly,

    Celes Davar
    Facebook: Celes Davar

  2. rbpeters04 says:

    Hi Celes,

    Very exciting that you will be building a Passive House as well! I would be very interested in learning about how you build your home!

    The first column in the spreadsheet is a grand total of all the kWh used in the house for the month; heat, hot water, and all other electrical usage. The other two columns show just what was used for the water heater and for the heater. So, the first column includes the values given in the other two columns. We separated those out so that we could track specifically what we were using for the water heater (our biggest energy user) and for the electric heater.

    I hope that makes sense!

    • Celes Davar says:

      Hi Beth,
      Thanks so much for your note. We will be happy to share our journey with you.

      I am still confused about your spreadsheet figures. Maybe, I just have a really thick head 🙂 Arghh!

      If Column B represents all of your KWh used for electrical appliances, fans heat pumps, etc., computers, and includes Electric Heat and Water Heater, then what is Column F? How is that figure calculated or what does it represent?

      If I understand your explanation above, for example:
      Your March costs are broken down as:
      $114.49 total cost for all KWh used (not including HST). Of that amount,
      -$55.00 is your baseline for all electrical appliances, computers, etc that are drawing electrical demand.
      -$49.88 is your water heater cost
      -$9.61 is your electrical heat

      So, what does Column F include or how was it calculated? $161.21

  3. James says:

    Just a quick comment, you add B5, B7, C5, C7, D5,D7 up twice in the totals which is why the total per section use, heat, hot water, house, does not add up to the total yearly cost

    • rbpeters04 says:

      Thanks for pointing that out! I was playing with the spreadsheet the other night trying to make it more readable and was having some issues with some of the formulas not copying correctly. I’ll get that fixed up 🙂

  4. Blair Arsenault says:

    Hey Beth,

    I’m using your house as a benchmark house in our Energy Auditing Course for something for folks to strive for. In that benchmark, we add up all the utility expenses (Wood, oil, electric, etc…).

    For these reasons, I’m wondering if you could add your propane deliveries onto your spreadsheet so I can get a total equivalent kWh for your house annually.

    Thank you,


    • rbpeters04 says:

      Hi Blair,
      Sorry it has taken me so long to respond! I had to look through our paperwork and check our tank and it looks as though we have used approximately 178L since we have moved in. So that would be from Feb 14, 2015 until April 23, 2016. We haven’t actually had to have a delivery yet besides the original one so I hadn’t thought to incorporate that into the spreadsheet. I’ll have to see what I can do to add that in.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s