sanscorp wrote: ↑Monday 21 September 2020 16:06
This is the data I got on my primary system.
Code: Select all
Verbruik|1|11981634;15017030;7;16;250;0
DeviceRowID|Value1|Value2|Value3|Value4|Value5|Value6|Date
1|11980868|7|160|0|15015501|16|2020-09-21 00:00:00
DeviceRowID|Value1|Value2|Value3|Value4|Value5|Value6|Date
1|11981634|7|220|0|15017028|16|2020-09-21 16:05:00
max(Date)|DeviceRowID|Value1|Value2|Value3|Value4|Value5|Value6|Counter1|Counter2|Counter3|Counter4|Date
2020-09-20|1|10566|6|2830|1|0|15|11980868|7|15015501|16|2020-09-20
You don't mention the domoticz version you are on. If not on the latest version the rounding errors that cause this behavior might have already been solved in a later version.
devicestatus:
This is the row containing current data from smartmeter.
first two numbers in Svalue is total energy from the grid (high tariff + low tariff) ==>> 11981634 + 15017030 = 26998.664 kWh
3rd and 4th number in Svalue is total energy to the grid (high tariff + low tariff) ==>> 7 + 16 = 0.023 kWh
5th number in sValue is current usage in Watt
6th number in sValue is current return in Watt
Code: Select all
Name|ID|sValue
Verbruik|1|11981634;15017030;7;16;250;0
multimeter (every 5 minutes) :
Value1: High Tariff from the grid
Value2: High Tariff to the grid
Value3: Usage from the grid (Watt)
Value4: Delivery to the grid (Watt)
Value5: Low Tariff from the grid
Value6: Hig Tariff to the grid
Code: Select all
DeviceRowID|Value1|Value2|Value3|Value4|Value5|Value6|Date
1|11980868|7|160|0|15015501|16|2020-09-21 00:00:00 -- first sample of today
DeviceRowID|Value1|Value2|Value3|Value4|Value5|Value6|Date
1|11981634|7|220|0|15017028|16|2020-09-21 16:05:00 -- last sample of today until now
multimeter_calendar (daily):
value1 used low on date
value2 returned low on date
value3 max value usage from the grid on date (Watt)
value4 min value usage from the grid on date (Watt)
value5 used high on date
value6 returned high on date
counter1 High Tariff from the grid
counter2 High Tariff to the grid
counter3 Low Tariff from the grid
counter4 Low Tariff to the grid
Code: Select all
max(Date)|DeviceRowID|Value1|Value2|Value3|Value4|Value5|Value6|Counter1|Counter2|Counter3|Counter4|Date
2020-09-20|1|10566|6|2830|1|0|15|11980868|7|15015501|16|2020-09-20
For your device Verbruik the display on the utility page tries to show the total return from yesterday ( 6 + 15 ) minus what it gets from the smartmeter ( 7 + 16 ) but it can only show positive numbers and the way C++ handles this is what you see on the utility page (it turns it into a very large number. The difference between 0.006 and 0.007 and 0.015 and 0.016 are probably rounding errors
The good part is that this large number is not in the database and when you start sending to the grid it will solve itself. Until then there is not much you can do about it because even if you correct it in the database it will return the next day
