Ok, I think you misunderstood me? It is not the jumps in kWh I need to see quickly, the energy graph (kWh) is fine to update slower.you would expect that the KWH does not go up fast from 500KWH!! if it would your electricity bill would be enormous!! I would expect to see an increase of ~ 10-20 a day (=10.5-21 SEK a DAY = 300-600/Month) which would hardly be visible. YOU NEED THE DELTA BETWEEN END and BEGINNING, that is your consumption.
In the wintertime I usually have approx 2000-4000 kWh usage per month and in the summer time around 900kWh. Lets assume that I use 3000 kWh in January, that is approx 96 kWh per day = 96 * 1.05 SEK = 100.80 SEK per day. On top of that I have the fixed monthly cost of 465 SEK so I tried to use the Offset = 465 to start the month at 465 SEK so that the plot would start every month on 465 SEK level and then keep on adding up the energy cost (approx 100 SEK per day in the wintertime on to the plot. I have also set the right scale for the cost to start at 465 SEK and to go up to max 3000 SEK.
The question was if the 465 offset would also be multiplied by the number I have set as a multiplier (if anything else than 1).
Do I also really need to use the delta between the end and beginning since I have configured the plugin to do a reset every month for the energy consumption? (as my screenshot in my previous post shows)
Yes fully understand and I have a separate plot for that on the minute graph showing power for the total as well the power for each of the three clamps. It is this graph I would like to be able to update more often than once per minute but no matter how I try to set lower than 60 seconds on the SQL batch import (all data) it always reverts back to 60 seconds. (Screenshots in my prev post.)In order to see the ups and down use Watt or KW (=power=Volt*Amps)
(I will of course have to update the URL that points to the graph more often but that was easily done in the control page creator in Indigo)
Yes this is exactly how I have set up as you can see in my screenshots in my previous post.The current cost mode does not have an offset, could add that, here a quick way:
use eConsumption and e-cost = 1.05 flat and pick your reset periods. i.e. day week month
That will give you the delta between the value at the end - value at the beginning of the reset period, i.e. how much consumption in a period (day, week, month, year or free period .. lets leave that for the next step)
THEN in the plot menu add 465 offset to it. I believe that should do it.
Ah! So this answers my question from above!as for the multiplier and offset: there are 2 place you can do it:
in the config menu it is
value = (value +offset) * multiple.
Then it is not good to use this method since my accumulated kWh value for the month, for example 50kWh, would be added with 465 and then multiplied with the multiplier (in this case 1) giving a total number of 465 kWh when then would be multiplied with my energy cost of 1.05 SEK/kWh. The result would be a number that is way too high... Ok I´ll play around with both methods described and see what effects I get.in the plot/line menu it is
value = value*mult + offset
you can use both together or independently
first comes the device must/offset . that stores it into the files indigoplotd/data/day.dat hour.dat .. minute.dat
then in plot it reads these values and applies the factor offset to it while plotting.
It looks like the graph is now updating (i.e. importing new SQL data properly) since this morning the graph was showing data for the night. Cool!
, here is the result:
