Hi, thanks for the P1 plugin, I find it very usefull.
I have a small issue though. I have version 3.0.0.12 installed, and I am logging all HS events to a MariaDB (MySQL) database. Recently I started reviewing the energy consumption of my devices, and specifically the P1. I am trying to use the usage value of today (Verbruik netwerk vandaag) and fit all the other device values and come up with a pie chart to see the main energy consumers.
And then I start noticing odd values of the P1 plugin.
The main values (total high/low tariff and return high/low tariff) are correct, however somewhere during the day the daily total jumps to 0, and after that to a higher value
Example: I have 1461 datapoints of april 17th, from which 1154 untill 19:06 and 307 after 19:06:13. Before and after this point in time the value incrreases in an expected rate, however at 19:10u it jumps. See the log below. The table shows a table-unique id and the HomeSeer ref, the third column is the kWh value, the fouth the devicestring (status, empty here) and the fifth the timestamp of the datapoint.
Een tweede voorbeeld hieronder is device 849, dat is de som van "Elektra teruglevering laag vandaag" en "Elektra teruglevering hoog vandaag". Die log ik nu niet afzonderlijk, dat kan ik evt wel gaan doen, maar nu om aan te geven dat de glitch ook op andere variabelen zit. Overigens niet op dezelfde tijdstippen.
In the main energy counters (total hight/low tariff and return)there is no such jump, so there is not really any jump in energy consumption happening.
+----------+-------+-------+--------------+---------------------+
| id | refid | value | devicestring | ts |
+----------+-------+-------+--------------+---------------------+
| 12136438 | 635 | 1.793 | | 2018-04-17 18:44:10 |
| 12136476 | 635 | 1.797 | | 2018-04-17 18:45:10 |
| 12136510 | 635 | 1.802 | | 2018-04-17 18:46:10 |
| 12136540 | 635 | 1.807 | | 2018-04-17 18:47:11 |
| 12136569 | 635 | 1.812 | | 2018-04-17 18:48:11 |
| 12136582 | 635 | 1.816 | | 2018-04-17 18:49:11 |
| 12136596 | 635 | 1.82 | | 2018-04-17 18:50:11 |
| 12136607 | 635 | 1.825 | | 2018-04-17 18:51:11 |
| 12136619 | 635 | 1.849 | | 2018-04-17 18:52:11 |
| 12136631 | 635 | 1.88 | | 2018-04-17 18:53:12 |
| 12136643 | 635 | 1.913 | | 2018-04-17 18:54:12 |
| 12136656 | 635 | 1.945 | | 2018-04-17 18:55:12 |
| 12136669 | 635 | 1.962 | | 2018-04-17 18:56:12 |
| 12136681 | 635 | 1.98 | | 2018-04-17 18:57:12 |
| 12136693 | 635 | 2 | | 2018-04-17 18:58:12 |
| 12136710 | 635 | 2.013 | | 2018-04-17 18:59:12 |
| 12136723 | 635 | 2.019 | | 2018-04-17 19:00:12 |
| 12136737 | 635 | 2.025 | | 2018-04-17 19:01:13 |
| 12136748 | 635 | 2.029 | | 2018-04-17 19:02:13 |
| 12136760 | 635 | 2.033 | | 2018-04-17 19:03:13 |
| 12136771 | 635 | 2.036 | | 2018-04-17 19:04:13 |
| 12136788 | 635 | 2.039 | | 2018-04-17 19:05:13 |
| 12136800 | 635 | 2.042 | | 2018-04-17 19:06:13 |
| 12136830 | 635 | 5.04 | | 2018-04-17 19:10:14 |
| 12136872 | 635 | 14.274 | | 2018-04-17 19:10:17 |
| 12136896 | 635 | 14.277 | | 2018-04-17 19:11:14 |
| 12136930 | 635 | 14.28 | | 2018-04-17 19:12:14 |
| 12136958 | 635 | 14.283 | | 2018-04-17 19:13:14 |
| 12136990 | 635 | 14.287 | | 2018-04-17 19:14:14 |
| 12137013 | 635 | 14.29 | | 2018-04-17 19:15:14 |
| 12137031 | 635 | 14.294 | | 2018-04-17 19:16:14 |
| 12137048 | 635 | 14.299 | | 2018-04-17 19:17:14 |
| 12137060 | 635 | 14.304 | | 2018-04-17 19:18:14 |
| 12137070 | 635 | 14.308 | | 2018-04-17 19:19:15 |
| 12137082 | 635 | 14.313 | | 2018-04-17 19:20:15 |
| 12137092 | 635 | 14.317 | | 2018-04-17 19:21:15 |
| 12137102 | 635 | 14.322 | | 2018-04-17 19:22:15 |
| 12137123 | 635 | 14.332 | | 2018-04-17 19:23:15 |
| 12137133 | 635 | 14.336 | | 2018-04-17 19:24:15 |
12135263 | 849 | 2.46 | 2 | 2018-04-17 17:48:03 |
| 12135300 | 849 | 2.462 | 2 | 2018-04-17 17:49:03 |
| 12135332 | 849 | 2.464 | 2 | 2018-04-17 17:50:04 |
| 12135361 | 849 | 2.466 | 2 | 2018-04-17 17:51:04 |
| 12135475 | 849 | 2.467 | 2 | 2018-04-17 17:59:04 |
| 12135924 | 849 | 2.469 | 2 | 2018-04-17 18:24:08 |
| 12135992 | 849 | 2.47 | 2 | 2018-04-17 18:26:08 |
| 12136832 | 849 | 0.36 | 0 | 2018-04-17 19:10:14 |
| 12136843 | 849 | 0 | 0 | 2018-04-17 19:10:15 |
| 12136853 | 849 | 0.002 | 0 | 2018-04-17 19:10:16 |
| 12143391 | 849 | 4.99 | 5 | 2018-04-18 00:00:49 |
| 12156510 | 849 | 0.002 | 0 | 2018-04-18 10:06:42 |
| 12156531 | 849 | 0.001 | 0 | 2018-04-18 10:08:42 |
| 12156547 | 849 | 0.003 | 0 | 2018-04-18 10:09:42 |
| 12156562 | 849 | 0.004 | 0 | 2018-04-18 10:10:42 |
| 12156584 | 849 | 0.006 | 0 | 2018-04-18 10:11:42 |
| 12156606 | 849 | 0.008 | 0 | 2018-04-18 10:12:42 |
| 12156608 | 849 | 0.01 | 0 | 2018-04-18 10:12:43 |
I installed 3.0.0.13 today, but not sure it solves this problem.
Any ideas?
I have a small issue though. I have version 3.0.0.12 installed, and I am logging all HS events to a MariaDB (MySQL) database. Recently I started reviewing the energy consumption of my devices, and specifically the P1. I am trying to use the usage value of today (Verbruik netwerk vandaag) and fit all the other device values and come up with a pie chart to see the main energy consumers.
And then I start noticing odd values of the P1 plugin.
The main values (total high/low tariff and return high/low tariff) are correct, however somewhere during the day the daily total jumps to 0, and after that to a higher value
Example: I have 1461 datapoints of april 17th, from which 1154 untill 19:06 and 307 after 19:06:13. Before and after this point in time the value incrreases in an expected rate, however at 19:10u it jumps. See the log below. The table shows a table-unique id and the HomeSeer ref, the third column is the kWh value, the fouth the devicestring (status, empty here) and the fifth the timestamp of the datapoint.
Een tweede voorbeeld hieronder is device 849, dat is de som van "Elektra teruglevering laag vandaag" en "Elektra teruglevering hoog vandaag". Die log ik nu niet afzonderlijk, dat kan ik evt wel gaan doen, maar nu om aan te geven dat de glitch ook op andere variabelen zit. Overigens niet op dezelfde tijdstippen.
In the main energy counters (total hight/low tariff and return)there is no such jump, so there is not really any jump in energy consumption happening.
+----------+-------+-------+--------------+---------------------+
| id | refid | value | devicestring | ts |
+----------+-------+-------+--------------+---------------------+
| 12136438 | 635 | 1.793 | | 2018-04-17 18:44:10 |
| 12136476 | 635 | 1.797 | | 2018-04-17 18:45:10 |
| 12136510 | 635 | 1.802 | | 2018-04-17 18:46:10 |
| 12136540 | 635 | 1.807 | | 2018-04-17 18:47:11 |
| 12136569 | 635 | 1.812 | | 2018-04-17 18:48:11 |
| 12136582 | 635 | 1.816 | | 2018-04-17 18:49:11 |
| 12136596 | 635 | 1.82 | | 2018-04-17 18:50:11 |
| 12136607 | 635 | 1.825 | | 2018-04-17 18:51:11 |
| 12136619 | 635 | 1.849 | | 2018-04-17 18:52:11 |
| 12136631 | 635 | 1.88 | | 2018-04-17 18:53:12 |
| 12136643 | 635 | 1.913 | | 2018-04-17 18:54:12 |
| 12136656 | 635 | 1.945 | | 2018-04-17 18:55:12 |
| 12136669 | 635 | 1.962 | | 2018-04-17 18:56:12 |
| 12136681 | 635 | 1.98 | | 2018-04-17 18:57:12 |
| 12136693 | 635 | 2 | | 2018-04-17 18:58:12 |
| 12136710 | 635 | 2.013 | | 2018-04-17 18:59:12 |
| 12136723 | 635 | 2.019 | | 2018-04-17 19:00:12 |
| 12136737 | 635 | 2.025 | | 2018-04-17 19:01:13 |
| 12136748 | 635 | 2.029 | | 2018-04-17 19:02:13 |
| 12136760 | 635 | 2.033 | | 2018-04-17 19:03:13 |
| 12136771 | 635 | 2.036 | | 2018-04-17 19:04:13 |
| 12136788 | 635 | 2.039 | | 2018-04-17 19:05:13 |
| 12136800 | 635 | 2.042 | | 2018-04-17 19:06:13 |
| 12136830 | 635 | 5.04 | | 2018-04-17 19:10:14 |
| 12136872 | 635 | 14.274 | | 2018-04-17 19:10:17 |
| 12136896 | 635 | 14.277 | | 2018-04-17 19:11:14 |
| 12136930 | 635 | 14.28 | | 2018-04-17 19:12:14 |
| 12136958 | 635 | 14.283 | | 2018-04-17 19:13:14 |
| 12136990 | 635 | 14.287 | | 2018-04-17 19:14:14 |
| 12137013 | 635 | 14.29 | | 2018-04-17 19:15:14 |
| 12137031 | 635 | 14.294 | | 2018-04-17 19:16:14 |
| 12137048 | 635 | 14.299 | | 2018-04-17 19:17:14 |
| 12137060 | 635 | 14.304 | | 2018-04-17 19:18:14 |
| 12137070 | 635 | 14.308 | | 2018-04-17 19:19:15 |
| 12137082 | 635 | 14.313 | | 2018-04-17 19:20:15 |
| 12137092 | 635 | 14.317 | | 2018-04-17 19:21:15 |
| 12137102 | 635 | 14.322 | | 2018-04-17 19:22:15 |
| 12137123 | 635 | 14.332 | | 2018-04-17 19:23:15 |
| 12137133 | 635 | 14.336 | | 2018-04-17 19:24:15 |
12135263 | 849 | 2.46 | 2 | 2018-04-17 17:48:03 |
| 12135300 | 849 | 2.462 | 2 | 2018-04-17 17:49:03 |
| 12135332 | 849 | 2.464 | 2 | 2018-04-17 17:50:04 |
| 12135361 | 849 | 2.466 | 2 | 2018-04-17 17:51:04 |
| 12135475 | 849 | 2.467 | 2 | 2018-04-17 17:59:04 |
| 12135924 | 849 | 2.469 | 2 | 2018-04-17 18:24:08 |
| 12135992 | 849 | 2.47 | 2 | 2018-04-17 18:26:08 |
| 12136832 | 849 | 0.36 | 0 | 2018-04-17 19:10:14 |
| 12136843 | 849 | 0 | 0 | 2018-04-17 19:10:15 |
| 12136853 | 849 | 0.002 | 0 | 2018-04-17 19:10:16 |
| 12143391 | 849 | 4.99 | 5 | 2018-04-18 00:00:49 |
| 12156510 | 849 | 0.002 | 0 | 2018-04-18 10:06:42 |
| 12156531 | 849 | 0.001 | 0 | 2018-04-18 10:08:42 |
| 12156547 | 849 | 0.003 | 0 | 2018-04-18 10:09:42 |
| 12156562 | 849 | 0.004 | 0 | 2018-04-18 10:10:42 |
| 12156584 | 849 | 0.006 | 0 | 2018-04-18 10:11:42 |
| 12156606 | 849 | 0.008 | 0 | 2018-04-18 10:12:42 |
| 12156608 | 849 | 0.01 | 0 | 2018-04-18 10:12:43 |
I installed 3.0.0.13 today, but not sure it solves this problem.
Any ideas?
Comment