+- LogicMachine Forum (https://forum.logicmachine.net)
+-- Forum: LogicMachine eco-system (https://forum.logicmachine.net/forumdisplay.php?fid=1)
+--- Forum: Scripting (https://forum.logicmachine.net/forumdisplay.php?fid=8)
+--- Thread: Minimum power consumption (/showthread.php?tid=4252)
Minimum power consumption - gilles38 - 20.09.2022
Hi all,
Since years I'm calculating the "always on" power value by taking the minimum value in the data base everyday.
the power value is coming from the main power meter of my installation, and is placed in a trend.
I just have installed some PV... so I need to modify my calculation ... and need now to do the calculation when the PV is not producing ...
between 0:00AM and 6AM and from 9PM to 11h59PM
Code:
require('trends')
function get_days_in_month(month, year)
local days_in_month = { 31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31 }
local d = days_in_month[month]
-- check for leap year
if (month == 2) then
if (math.mod(year,4) == 0) then
if (math.mod(year,100) == 0)then
if (math.mod(year,400) == 0) then
d = 29
end
else
d = 29
end
end
end
return d
end
dates = {}
dates['start'] = os.date('*t')
dates['end'] = os.date('*t')
if(dates['start'].day==1)then
if(dates['start'].month==1) then
month=12
year=dates['start'].year-1
else
month=dates['start'].month
year=dates['start'].year
end
day=get_days_in_month(month,year)
month=dates['start'].month
year=dates['start'].year
else
day=dates['start'].day-1
month=dates['start'].month
year=dates['start'].year
end
dates['start'].day=day
dates['start'].month=month
dates['start'].year=year
-- fetch value
resolution = 86400/4
Values = trends.fetch('Total Power', dates, resolution)
min = math.min(unpack(Values))*1000
grp.write('15/1/61', min)as in documentation I have seen that for dates [start] and [ends] the time is not taken in consideration ....how can I do ?
thanks all for support
Gilles