Re: [rrd-users] Calculation that is a bit over my head.

2013-11-26 Thread Simon Hobson
Jan Johansson wrote: >I do not suppose there is any "magic" subsitution for replacing (in this case) >86400 with "The number of seconds between -s and -e params? As I said, I script generate my graphs (actually, they are CGI scripts written in Bash). So I have something along the lines of : cas

Re: [rrd-users] Calculation that is a bit over my head.

2013-11-26 Thread Tobias Oetiker
Jan, Today Jan Johansson wrote: > Is there any way to use print without generating a graph? The docs seem > suggest that "-" supresses all output tho, so I am guessing "No"? if you do only use PRINT and not GPRINT, LINE, AREA, COMMENT then no graph will be generated. cheers tobi -- Tobi Oetik

Re: [rrd-users] Calculation that is a bit over my head.

2013-11-26 Thread Jan Johansson
Hello! I would like o start with giving you a HUGE compliment for your answer. It is verbose, clearly written and quite frankly a joy to read! Thank you! >DEF:onpercent=/opt/Krokopool/RRDDatabases/Styrning_Varmare.rrd:Styrning_Varmar>e:AVERAGE > CDEF:ontime=onpercent,86400,*,3600,/ > CDEF:totp

Re: [rrd-users] Calculation that is a bit over my head.

2013-11-25 Thread Simon Hobson
Jan Johansson wrote: >Is that something I can build into the query? To do the arithmetics and be >able to feed an arbitrary start/end into the query? > >Such as > >rrdtool graph /usr/share/nginx/www/test.png -s "20130101" -e "now" >DEF:ds0=/opt/Krokopool/RRDDatabases/Styrning_Varmare.rrd:Styrning

Re: [rrd-users] Calculation that is a bit over my head.

2013-11-25 Thread Jan Johansson
>Yes, it would be 21.67% >Multiply by the length of time (86400 seconds in this case) to get total >running time (5.2 >hours in the day), and multiply that by the nominal running >power to get energy >consumed. Thanks! Is that something I can build into the query? To do the arithmetics and be a

Re: [rrd-users] Calculation that is a bit over my head.

2013-11-24 Thread Jan Johansson
>yes 21.7% seems right. I figured out why it seemed off. I forgot about the five hour power failure yesterday. :) When I re-ran it for another timespan, I got values that seem reasonable. Thanks all! ___ rrd-users mailing list rrd-users@lists.oetik

Re: [rrd-users] Calculation that is a bit over my head.

2013-11-24 Thread Simon Hobson
Jan Johansson wrote: >rrdtool graph /usr/share/nginx/www/test.png -s "now-1 day" -e "now" >DEF:ds0=/opt/Krokopool/RRDDatabases/Styrning_Varmare.rrd:Styrning_Varmare:AVERAGE > VDEF:ds1=ds0,AVERAGE LINE:ds0\#FF:ds0 PRINT:ds1:%20.2lf%s >481x155 > 216.71m > >Does this mean 21,67% "on"

Re: [rrd-users] Calculation that is a bit over my head.

2013-11-24 Thread Tobias Oetiker
On 24.11.2013, at 23:56, Jan Johansson wrote: >> no problem, then you just log 0 or 1 (again with GAUGE) and if you ask >> rrdtool for the average over a given timespan this will be the ratio of time >> the value has been 1. > > > Thanks! > > Ok, I found an old post and try to modify that to

Re: [rrd-users] Calculation that is a bit over my head.

2013-11-24 Thread Jan Johansson
>no problem, then you just log 0 or 1 (again with GAUGE) and if you ask rrdtool >for the average over a given timespan this will be the ratio of time the value >has been 1. Thanks! Ok, I found an old post and try to modify that to my needs rrdtool graph /usr/share/nginx/www/test.png -s "now-1

Re: [rrd-users] Calculation that is a bit over my head.

2013-11-17 Thread Tobias Oetiker
Hi Jan, Yesterday Jan Johansson wrote: > >I would suggest to set the DS to GAUGE > > > >and then log 3000 when your heater is on and 0 when it is off > > > >cheers > >tobi > > Hello! > > The DS is set to gauge, but I cannot really change the value, as > the controller in use actually talks to RR

Re: [rrd-users] Calculation that is a bit over my head.

2013-11-17 Thread Steve Shipway
and.ac...@lists.oetiker.ch [mailto:rrd-users-bounces+s.shipway=auckland.ac...@lists.oetiker.ch] On Behalf Of Jan Johansson Sent: Monday, 18 November 2013 12:35 p.m. Cc: rrd-users@lists.oetiker.ch Subject: Re: [rrd-users] Calculation that is a bit over my head. >I would suggest to set the DS to GAUGE >

Re: [rrd-users] Calculation that is a bit over my head.

2013-11-17 Thread Jan Johansson
>I would suggest to set the DS to GAUGE > >and then log 3000 when your heater is on and 0 when it is off > >cheers >tobi Hello! The DS is set to gauge, but I cannot really change the value, as the controller in use actually talks to RRD directly, so I only have control over the “read side” of

Re: [rrd-users] Calculation that is a bit over my head.

2013-11-17 Thread Tobias Oetiker
Hi Jan > On 18.11.2013, at 00:19, Jan Johansson wrote: > > > Hello! > > I have a data source that logs either 0 or 1. > This data point relates to the state of a relay that controls a 3kW water > heater > > I would like to be able to do dead reckoning of the power consumption of this > h