min/max/average plugin DOWNLOAD

Code: Select all

changes in V 2022.15.23  @ 2023-02-06
================== 

1. added
      measurement "consumption" = end value of period - start value of period
      UpTime = % of time the value in the time window was not 0
      Simple Average
2. added other time bins
      day time,  night time , last 12 hours, previuos 12 hours

3. fixed calculation of std deviation, the simplified formula does not work for LARGE numbers, back to general formula : sqrt(sum((xi-av)**2))/N

3. added simple average to measures
- before it was ONLY time weighted average as some of the data is not in regular time intervals and some values are longer valid that others. ie when a state is not upated on a fixed time slot basis
  eg a lamp is off for 11, on for 1, off for 12 hours
  simple average would give (0+1+0)/3 = 1/3
  time weighted average would be  (0*11 + 1*1 * 0*12 )/24 = 1/24 instead of 1/3
  now you have both.

4. some print out improvements, shows definitions of time windows and measures

Code: Select all

changes in V 2022.15.25  @ 2023-02-07
================== 

1. removed debug logging
2. some grammar fixes
3. added std deviation simple besides std deviation time weighted


this should be it for some time

Karl

changes in V 2022.16.26 @ 2023-02-08
==================

1. optimized code, reduced cpu by ~ 90%
most of the cpu was used by the sql query (80%)
now only once an hour, in between subscription to dev / variable changes

2. some grammar fixes

changes in V 2022.16.27 @ 2023-02-11
==================

1. fix error when data is a mix of number and strings, convert all strings to numbers