Jump to content

Welcome to Smart Home Forum by FIBARO

Dear Guest,

 

as you can notice parts of Smart Home Forum by FIBARO is not available for you. You have to register in order to view all content and post in our community. Don't worry! Registration is a simple free process that requires minimal information for you to sign up. Become a part of of Smart Home Forum by FIBARO by creating an account.

 

As a member you can:

  •     Start new topics and reply to others
  •     Follow topics and users to get email updates
  •     Get your own profile page and make new friends
  •     Send personal messages
  •     ... and learn a lot about our system!

 

Regards,

Smart Home Forum by FIBARO Team


Export Historical Data


vmuscariello

Recommended Posts

Who knows how to interpreter the  Export Historical Data in the energy Panel in .CSV

For example Time stamp 1541595737 what date it correspond?

I cannot interpreter it

 

Please login or register to see this attachment.

Link to comment
Share on other sites

  • Topic Author
  • Thx Jakub I have found a way in xls to transalte the date (=timestamp/(60 * 60 * 24) + "1/1/1970) . the point now is how to interpreter the value. Here attached and example

     

     

     

    Please login or register to see this attachment.

    • Like 1
    Link to comment
    Share on other sites

    • 1 month later...

    Did anybody found the meaning of the column "VALUE"? I assume it is Watt?

    Edited by sigharen
    Link to comment
    Share on other sites

    Join the conversation

    You can post now and register later. If you have an account, sign in now to post with your account.

    Guest
    Reply to this topic...

    ×   Pasted as rich text.   Paste as plain text instead

      Only 75 emoji are allowed.

    ×   Your link has been automatically embedded.   Display as a link instead

    ×   Your previous content has been restored.   Clear editor

    ×   You cannot paste images directly. Upload or insert images from URL.

    ×
    ×
    • Create New...