iINDIGOplotD: how to plot consumption

Posted on
Tue Aug 01, 2017 11:12 am
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

iINDIGOplotD: how to plot consumption

if you want to plot e.g. the consumed power[watt hour] (= consumed energy in indigo terms ) over time and start at 0 every day / week/month/ year this is how you do it:

1. define your source:
in
Screen Shot 2017-08-01 at 11.49.58.png
Screen Shot 2017-08-01 at 11.49.58.png (15.22 KiB) Viewed 19178 times

you select the device and set:
Screen Shot 2017-08-01 at 11.47.03.png
Screen Shot 2017-08-01 at 11.47.03.png (45.59 KiB) Viewed 19178 times
to e.g. reset every day (options are day, week, months, year and "period"; you can define any time period (e.g. 5/5/2017 - 10/9/2018 which does not make sense .. but you can set 10+ + periods )m In addition to just adding this up you can also define cost per hour on a day / week / period. in the section at the end . Then you could show cost in $.

2. create a plot device, e.g. consumed power daily
- in the top section
=reset the x,y limits and set the descriptions as you like
=click confirm
- in the bottom section
= add new line
= select the data source you just created
= select line type eg solid line or histogram
= click confirm
= if you can see the indigo server screen you can enable experts tools and click on update and after 5 secs click on show.


Will add some more screen shots. unfortunately my energy meter is not working well. It has a bad z-wave connection and only updates when I push it . So i don't have nice data to show. .. one of the many things left to d.

Karl

Posted on
Tue Aug 01, 2017 12:26 pm
pcbiti offline
Posts: 6
Joined: Jun 07, 2017

Re: iINDIGOplotD: how to plot consumption

I have looked at these examples, but I can not find the menus where I can check the expert mode on/off for advanced parameters.

Posted on
Tue Aug 01, 2017 12:57 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: iINDIGOplotD: how to plot consumption

in device edit at the top,
but you only need this for "update" and "show"
Attachments
Screen Shot 2017-08-01 at 13.56.05.png
Screen Shot 2017-08-01 at 13.56.05.png (52.48 KiB) Viewed 19148 times

Posted on
Tue Aug 01, 2017 1:26 pm
pcbiti offline
Posts: 6
Joined: Jun 07, 2017

Re: iINDIGOplotD: how to plot consumption

Yes I find the Expert tool in Configure plots window but not in the plugin-Configure menu as several screenshots show.

Posted on
Tue Aug 01, 2017 2:40 pm
pcbiti offline
Posts: 6
Joined: Jun 07, 2017

Re: iINDIGOplotD: how to plot consumption

Sorry I have installed an old version.

Posted on
Tue Aug 01, 2017 5:14 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: iINDIGOplotD: how to plot consumption


Posted on
Wed Aug 02, 2017 11:14 am
pcbiti offline
Posts: 6
Joined: Jun 07, 2017

Re: iINDIGOplotD: how to plot consumption

Thanks
How can I change time in sqlite databases table to local time on my mac?

Posted on
Wed Aug 02, 2017 5:28 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: iINDIGOplotD: how to plot consumption

That's how indigo writes it to the dB.
But indigo plotd converts the dates to local time. At least it should.




Sent from my iPhone using Tapatalk

Posted on
Wed Aug 02, 2017 5:29 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: iINDIGOplotD: how to plot consumption

I can send you the sql string how to convert.


Sent from my iPhone using Tapatalk

Posted on
Fri Aug 04, 2017 11:12 am
pcbiti offline
Posts: 6
Joined: Jun 07, 2017

Re: iINDIGOplotD: how to plot consumption

Thanks it seems to works now, but please send the sql string.
I have made a plot and it seems to work very well. Thanks for the support.

Posted on
Fri Aug 04, 2017 1:58 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: iINDIGOplotD: how to plot consumption

this is the simplified SQL statement used inindigoplot d to get state avgSpeed from device id=375541516

Code: Select all
/usr/bin/sqlite3 -separator ";" indigo_history.sqlite " SELECT id, strftime('%Y%m%d%H%M%S',ts,'localtime') ,avgSpeed from device_history_375541516 WHERE  ID > 0  LIMIT 10000000;"   > /Users/karlwachs/Documents/INDIGOplotD/sql/375541516-avgSpeed.sqlOut


with ID (seq id of sql data) limited and # of lines limit output to /Users/karlwachs/Documents/INDIGOplotD/sql/375541516-avgSpeed.sqlOut

Karl

Posted on
Sat Aug 17, 2019 1:22 pm
ckeyes888 offline
Posts: 2417
Joined: Nov 26, 2009
Location: Kalispell, MT

Re: iINDIGOplotD: how to plot consumption

Hoping for some help in plotting my washing machine power consumption when running.
Not getting how it’s triggered to begin/end a plot and create a .png.

Thanks,

Carl

Posted on
Sat Aug 17, 2019 5:59 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: iINDIGOplotD: how to plot consumption

Checkout the pdf file in the main indigo plotd directory


Basic steps:
1. Define data source ( which device and state)
2. Create a indigo plot device
There you define the plot: size, binning colors and pick one or many of the data source you defined in step 1

The plugin will then create and update the plots every minute.

For very simple one line plots try the mini plot in menu


Before you do 1.2.... you need to set some items in config. Like which sql dB are you using.

Karl


Sent from my iPhone using Tapatalk

Posted on
Sat Aug 17, 2019 9:14 pm
ckeyes888 offline
Posts: 2417
Joined: Nov 26, 2009
Location: Kalispell, MT

Re: iINDIGOplotD: how to plot consumption

Thanks Karl, I’ll give it a go.

Carl

Page 1 of 1

Who is online

Users browsing this forum: No registered users and 1 guest

cron