11.12.2022, 20:17
Thank you admin.
I believe I have tried all variants I could think of regarding setting up the trends, but I feel the data is far off expected numbers when trying to get a SUM of daily consumption.
JACUZZI EXAMPLE (Same for other circuits too)
---------------------------------------------------------------
a) POWERTAG COUNTER: The power tags built in resettable counter show me something between 15-40kwh of consumption for the jacuzzi circuit near midnight every day (reset counter at midnight by script). Varies much according to outdoor temperatures, water temperature and of course usage. Which I feel is all quite acurate to my expectations and bills. Quite precise also for the large mains circuits power tag counter. The data is fetched via modbus/IP and is collected via a resettable counter named "PowerTag_152kw - Active Energy Resettable". (152 is the powertag ID and KW due to diveded to get k instead of w).
b) Logic Machine trend:
Settings: Object: "Active Power total", Name "..", Category "...", Log Type "Absolute value", Aggregate func: "Average", Trend res. "5minutes, Dec places "0", Res.data "180days", Daily data "2 years", Show Zero "yes".
For the trend i am now using the "Active Power Total" which shows the current power consumption from the power tag. Seems very precise and correct in view mode "day" or "week". When changing to month it shows correcty the average conspumption for the days as expected. BUT the numbers listed in the "data" is average and I guess they must be multiplied with x24 to get a per-day-consumption. Which for December is between 762- 1152w average consumption (762*24 =18.29kw/h and 1533*24=36.790kw/h). Also very near the expected and very close to the powerTags counter.
SO I want to get the numbers per day and month summed up and visualized so i can calculate my monthly consumption. I have attempted several ways in the trends dialog, but did not get any numbers that make sense.
c) Identical as B, but with "Counter":
SETTINGS: Object "Active Power Total" (Same as for b), Name: "...", Category "...", LogType: Counter, Aggregate function: Average, Trend Res: 5min, Decimal 0, Res data 30d, Daily data, 5yrs, Show Zero.
This setup give me numbers which are very off compared to my expectations. All values in December are as between 80.000W and 117.213W which is far off. It is also not peaking or low on the same days as in the a and b example above.
I am pretty sure I am doing something wrong here. The first question is what is the correct data source to use from the power tags. Is it the Current consumption as in a and b or should I use the power tags logging function?
Alternatively: Can I code a script writing data directly to a trends table in the database? (Are there examples of how to do this and how to retrieve this - preferably directly in trends as a normal trends graph).
I believe I have tried all variants I could think of regarding setting up the trends, but I feel the data is far off expected numbers when trying to get a SUM of daily consumption.
JACUZZI EXAMPLE (Same for other circuits too)
---------------------------------------------------------------
a) POWERTAG COUNTER: The power tags built in resettable counter show me something between 15-40kwh of consumption for the jacuzzi circuit near midnight every day (reset counter at midnight by script). Varies much according to outdoor temperatures, water temperature and of course usage. Which I feel is all quite acurate to my expectations and bills. Quite precise also for the large mains circuits power tag counter. The data is fetched via modbus/IP and is collected via a resettable counter named "PowerTag_152kw - Active Energy Resettable". (152 is the powertag ID and KW due to diveded to get k instead of w).
b) Logic Machine trend:
Settings: Object: "Active Power total", Name "..", Category "...", Log Type "Absolute value", Aggregate func: "Average", Trend res. "5minutes, Dec places "0", Res.data "180days", Daily data "2 years", Show Zero "yes".
For the trend i am now using the "Active Power Total" which shows the current power consumption from the power tag. Seems very precise and correct in view mode "day" or "week". When changing to month it shows correcty the average conspumption for the days as expected. BUT the numbers listed in the "data" is average and I guess they must be multiplied with x24 to get a per-day-consumption. Which for December is between 762- 1152w average consumption (762*24 =18.29kw/h and 1533*24=36.790kw/h). Also very near the expected and very close to the powerTags counter.
SO I want to get the numbers per day and month summed up and visualized so i can calculate my monthly consumption. I have attempted several ways in the trends dialog, but did not get any numbers that make sense.
c) Identical as B, but with "Counter":
SETTINGS: Object "Active Power Total" (Same as for b), Name: "...", Category "...", LogType: Counter, Aggregate function: Average, Trend Res: 5min, Decimal 0, Res data 30d, Daily data, 5yrs, Show Zero.
This setup give me numbers which are very off compared to my expectations. All values in December are as between 80.000W and 117.213W which is far off. It is also not peaking or low on the same days as in the a and b example above.
I am pretty sure I am doing something wrong here. The first question is what is the correct data source to use from the power tags. Is it the Current consumption as in a and b or should I use the power tags logging function?
Alternatively: Can I code a script writing data directly to a trends table in the database? (Are there examples of how to do this and how to retrieve this - preferably directly in trends as a normal trends graph).
Schneider Wiser (homeLynk), Power Tags, DALI, Multitouch Pro, Panasonic Heating pump, Flexit balansed ventilation, HUE integration, Lemus Speaker system. Tibber integration.