Domoticz

Which device is best used for cost tracking? Or should we request a new device?

I am currently using a custom device to store the electricity costs during the day (=today's nett usage times price) . This could increase or decrease during the day, depending on usage and/or return as well as positive/negative price.

Issue is that daily values of custom devices are stored in the percentage_calendar table and only show min, max and avg in the table and daily graphs, no totals.

I would like to have a device that shows a total per day (and per month), just like counter devices. But a counter cannot be used for the costs since counters can only increase.

Any other suitable device available?

In principle the costs are available in the report function of the energy devices. So probably this is the reason there is no cost device.

You may use RFXmeter, with a "counter" type, value "Cost" and unit "€" (or whatever currency you're using).

waltervl wrote: ↑Sunday 27 November 2022 22:21 In principle the costs are available in the report function of the energy devices. So probably this is the reason there is no cost device.

That only allows the setting of rates per kWh and M3 and does not take into account fixed charges and/or returns per day/month, nor any variation in the charges depending on the time or situation.

I am now simulating the costs I would have if I had a dynamic contract with hourly variation of electricity prices (a lot of companies are now offering such contracts).

FlyingDomotic wrote: ↑Sunday 27 November 2022 23:39 You may use RFXmeter, with a "counter" type, value "Cost" and unit "€" (or whatever currency you're using).

I thought this only allowed counter increase, but I will test. Thanks.

willemd wrote: ↑Monday 28 November 2022 14:24

FlyingDomotic wrote: ↑Sunday 27 November 2022 23:39 You may use RFXmeter, with a "counter" type, value "Cost" and unit "€" (or whatever currency you're using).

I thought this only allowed counter increase, but I will test. Thanks.

I can now confirm that a counter devices does NOT handle negative values correctly and therefore is useless for handling increasing and decreasing costs.

I have the following values:
1) a startvalue 504
1) next value 509
2) 506
3) 495
4) 490
5) 488
6) 491

A custom sensor does display the increase and decrease correctly (but with the useless min,max,avg in the monthly graphs as stated above)
A counter device displays in the daily graph:
+5
+506
+495
+490
+488
+3
So for negative values it does not display the decrease (for example minus 0.03) but the new counter total minus the decrease (for example 5.09 minus 0.03 = 5.06) . whereas for positive numbers it just shows the increase like it should (note the device has a divider of 100)
Daily cumulative total shown in the icon is correct however, i.e. not adding the large positive numbers but subtracting the small negatives.
(this is in the daily graph, I don't have negative values in the other graphs yet)

So, back to my initial question .....

Below is the XLS download of the graph and the corresponding selection from the meter table and the calculation of difference from one meter value to the next.
Issue of incorrect graph display raised as an issue on github.

I made my own topic yesterday, didn't notice this was already discussed. Better keep in same place.

Interesting thing is, normal kWh counter already supports negatives, no issues there. I think you could just leave units at kWh and pretend they are euros. However if you change counter type to "custom" so you can change units to €, negatives no longer work.

Proof of the kWh negatives thingy, my kWh readings from last summer:

gizmocuz explained I had a bug in my managed counter code, it works now. see here:

viewtopic.php?p=295431#p295431

see final conclusion in this post:

viewtopic.php?p=296335#p296335