Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Saving Energy Data before Hohm goes away

How can I extract my energy data from Hohm to excel (or anything else)?
3 people have
this question
+1
Reply
  • I’m anxious
    I haven't found a way to export energy data. Hopefully someone at Microsoft will be tasked with creating a data export mechanism for us.

    Otherwise, you'll need to manually transcribe your data from Holm into your own spreadsheets.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited sad, anxious, confused, frustrated

  • It seems that we will now be talking into a black hole until Hohm goes away. I am trying to conserve energy because of the ultra-tight budget I now have to live on. I am going to have to create my own database to gather my own statistics. It is sad that this didn't catch on. Better advertising may have helped!
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited sad, anxious, confused, frustrated

  • This reply was removed on 2012-02-21.
    see the change log
  • We have introduced functionality in Microsoft Hohm to allow users to download their energy usage data in ".csv" format file.

    Given below are the steps to access the functionality
    1) From the My Hohm Center page, navigate to Energy Data > Downloads
    2) From the download page you can get data from your Blueline device, your connected energy provider or manually entered data by clicking on the appropriate link.
    3) Once you click on the link a file will be generated (Note: this may take a few minutes for Blueline devices. Do NOT navigate away from the page)
    4) Once the file is generated click the "Download" button that appears and chose a location to save the file.

    Each row in the data file represents usage for a period of time. In the case of the connected utility or manually entered data a row will represent a month of data. The Blueline data represents about 30 seconds worth of readings.

    To help understand how to read your data here are some definitions of important columns in your device data file
    Meter Reading - Meter reading at the end of time interval (kWh)
    Usage - Amount of electricity used during time interval (kWh)
    Demand - Amount of energy consumed at the end of time interval (kW)

    Thanks,
    Suresh
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited sad, anxious, confused, frustrated