Average power for the last clock hour

[Rune]

Hi guys!

Part of the energy cost in Norway is defined by the three hours in the month were the user spent the most power.

Can someone help me with a script that calculate the average power of the last clock hour? It would be nice to have that to confirm if I exceeded my 5kW limit or not.

[tomnord]

I think I have one of those.. we'll talk tomorrow ?

[Rune]

If there is more than a screenshot of half a script, then ok.

No, wait, I have KNX Basic course this week.

[admin]

Why not use Trends for this?

[tomnord]

I agree with Admin, a nice trendview would give you what you need.

[Rune]

Uhm.. Because I want it as a value in my other user interface. :|

[admin]

You can get values from trends and write them to objects: https://openrb.com/docs/trends-new.htm

[Rune]

I couldn't understand how to transform that to a script that could be useful, so I googled lua average value and found this in another thread:

-- storage key
key = 'temp_average'
-- time between average value send (in seconds)
maxtime = 60 * 60
-- resulting average value
result = '4/3/34'

time = os.time()

data = storage.get(key)
if not data then
  data = { values = {}, time = time }
end

value = event.getvalue()
table.insert(data.values, value)

delta = time - data.time
if delta >= maxtime or delta < 0 then
  storage.delete(key)

  avg = 0
  count = #data.values
  for _, value in ipairs(data.values) do
    avg = avg + value
  end

  grp.write(result, avg / count)
else
  storage.set(key, data)
end

Is there a way to make this start the count at the beginning of the clock hour?

[Dré]

you can use 'Scheduled' en put the scipt there.
Set running for every hour at 00 minutes

[Rune]

you can use 'Scheduled' en put the scipt there.
Set running for every hour at 00 minutes

But if I do that, since it is a event script today triggered by "4/6/1", how do I insert that GA into the script before I change it to a sceduled script?

[admin]

See this: https://forum.logicmachine.net/showthrea...1#pid27441

[Rune]

Event script:

Code:

local st_name = 'average' -- Local table name
local value_in = '4/6/1' -- GA data input



local st_table = storage.get(st_name)
if not st_table then
  log('Table Created')
  local st_values = {}
  storage.set(st_name, st_values)
end



table.insert(st_table, grp.getvalue(value_in))



storage.set(st_name, st_table)

Scheduled script sent every 0 minute:

Code:

local st_name = 'average' -- Name on local table
local result_avg = '4/3/34' -- GA for result output



local st_table = storage.get(st_name)
if st_table then
  local size = 0
  local sum_val = 0
  for i, v in pairs(st_table) do
    sum_val = v + sum_val
    size = size + 1
  end
 
  local avg_val = sum_val / size
  grp.write(result_avg, avg_val)
  local reset_table = {}
  log(avg_val)
  log(size)
  storage.set(st_name, reset_table)
  log(storage.get(st_name))
end