Domoticz

Code: Select all

--[[ script to estimate energy usage per phase for a 3 phase P1 meter   

    Before activating the script do:
    
    Create receiving devices as virtual device Type counter and on the utilities tab change them to 
    Type: Counter
    Counter Divider: 1000
    Value Quantity: Count
    Value Units: kWh
    
    The offset must NOT be set in this screen but if required must be entered in the settings below. Again only possible 
    before the first execution of the script
    
    tested with my 1 phase P1 meter for some hours and there the delta compared to real measurement is less then 1%
    but still: This is not a real measurement but an estimate !! and as always YMMV.
  
    In my situation the script fires every 10 seconds. You can change this by changing the scriptTrigger to be time
    based but it might have consequences for the delta between real values and estimated calculated values.
    The script writes to the kwH devices max. ones per minute and this frequency can be changed by changing the.  
    local writeDelay variable ( higher is less frequent and v.v.
    
--]]

 
 return
{
    on = 
    { 
        devices = 
        {
            1168,  -- change to id or 'name' of your L1 device. Only one device or the script will explode ! 
        },
    },

    logging =   
    {
        level = domoticz.LOG_ERROR, -- set to LOG_ERROR when tested and OK
        marker = 'kWh estimated values', 
    },

    data = 
    {
        usage =
        { 
            initial = 
            { 
                {},
            },
        },
    },
     
    execute = function(dz, item)
        
        local L1 = dz.devices('Usage L1') -- change to name / ID of your L1 usage device  
        local L2 = dz.devices('Usage L2') -- L2 watt
        local L3 = dz.devices('Usage L3') -- L3 watt 
        
        local L1C  = dz.devices('L1C') -- Change to name of your virtual device for L1 kWh used. (type counter, subtype counter, X-as kWh)
        local L2C  = dz.devices('L2C') -- L2
        local L3C  = dz.devices('L3C') -- L3
        
        local writeDelay = 60 
        
        local L1Offset = 15609      -- change to 
        local L2Offset = 0
        local L3Offset = 0
        
        -------
        -- No changes required below this line
        -------
        
        local function setPersistent(deltaSeconds)
            dz.log('setPersistent',dz.LOG_DEBUG)
            dz.data.usage.L1Wh = dz.data.usage.L1Wh + ( L1.actualWatt * deltaSeconds / 3600 )
            dz.data.usage.L2Wh = dz.data.usage.L2Wh + ( L2.actualWatt * deltaSeconds / 3600 )
            dz.data.usage.L3Wh = dz.data.usage.L3Wh + ( L3.actualWatt * deltaSeconds / 3600 )
            dz.data.usage.dDate = dz.time.dDate
        end

        local function resetPersistent()
            dz.log('resetPersistent',dz.LOG_DEBUG)
            dz.data.usage.L1Wh = 0
            dz.data.usage.L2Wh = 0
            dz.data.usage.L3Wh = 0
            dz.data.usage.dDate = dz.time.dDate
            dz.data.usage.reset = dz.time.dDate
        end

        local function update_kWhDevices()
            dz.log('updateCounter ' .. L1C.counter .. '  with ' .. dz.utils.round(dz.data.usage.L1Wh,3) ,dz.LOG_FORCE)
            
            L1C.updateCounter(L1C.counter + dz.data.usage.L1Wh / 1000 )
            L2C.updateCounter(L2C.counter + dz.data.usage.L2Wh / 1000 )
            L3C.updateCounter(L3C.counter + dz.data.usage.L3Wh / 1000 )
        end
        
        local function setOffset()
            if L1C.counter == 0 and L1Offset and L1Offset > 0 then L1C.setValues(0,L1Offset) end
            if L2C.counter == 0 and L2Offset and L2Offset > 0 then L2C.setValues(0,L2Offset) end
            if L3C.counter == 0 and L3Offset and L3Offset > 0 then L3C.setValues(0,L3Offset) end
        end
        
        
        -- initialize dz.data.usage data 
        if dz.data.usage.dDate == nil then
            setOffset()               -- Only once 
            resetPersistent()         -- Once initially and every time the datafile ihas been removed manually
        else    
           setPersistent(dz.time.dDate - dz.data.usage.dDate) -- every cycle
        end
        
        if dz.data.usage.reset < ( dz.time.dDate - writeDelay ) then 
            update_kWhDevices() 
            resetPersistent()
        end
    end
}

Code: Select all

--[[ script to estimate energy usage per phase for a 3 phase P1 meter   

    Before activating the script do:
    
    Create receiving L1C devices as virtual device Type counter and on the utilities tab change them to 
    Type: Counter
    Counter Divider: 1000
    Value Quantity: Count
    Value Units: kWh
    
    An offset must not be set in this screen but if required must be entered in the settings below. Again only possible 
    before the first execution of the script
            
    as explained by @FireWizard in post https://www.domoticz.com/forum/viewtopic.php?f=59&t=30823#p233241
    
    Create receiving L1U devices as virtual device Type (Electric (Instant + Counter)) and on the utilities tab change them to 
    use the 'Counted' method for Energy read
    
    tested with my 1 phase P1 meter for some hours and there the delta compared to real measurement is less then 1%
    but still: This is not a real measurement but an estimate !! and as always YMMV.
  
    In my situation the script fires every 10 seconds. You can change this by changing the scriptTrigger to be time
    based but it might have consequences for the delta between real values and estimated calculated values.
    
    The script writes to the daily usage devices every cycle and to the kwH devices max. ones per minute and this frequency can be changed by 
    changing the.  
    local writeDelay variable ( higher is less frequent and v.v.
    
--]]

 
 return
{
    on = 
    { 
        devices = 
        {
            1168,  -- change to id or 'name' of your L1 device. Only one device or the script will explode ! 
        },
    },

    logging =   
    {
        level = domoticz.LOG_ERROR, -- set to LOG_ERROR when tested and OK
        marker = 'kWh estimated values', 
    },

    data = 
    {
        usage =
        { 
            initial = 
            { 
                {},
            },
        },
    },
     
    execute = function(dz, item)
        
        local L1 = dz.devices('Usage L1') -- change to name / ID of your L1 usage device  
        local L2 = dz.devices('Usage L2') -- L2 watt
        local L3 = dz.devices('Usage L3') -- L3 watt 
        
        local L1C  = dz.devices('L1C') -- Change to name of your virtual device for L1 kWh used. (type counter, subtype counter, X-as kWh)
        local L2C  = dz.devices('L2C') -- L2
        local L3C  = dz.devices('L3C') -- L3
        
        local L1U = dz.devices('L1 daily use') -- change to name / ID of your L1 daily usage device  
        local L2U = dz.devices('L2 daily use') -- L2 
        local L3U = dz.devices('L3 daily use') -- L3 
                
        local writeDelay = 60 
        
        local L1Offset = 15609
        local L2Offset = 0
        local L3Offset = 5609
        
        -------
        -- No changes required below this line
        -------
        
        local function setPersistent(deltaSeconds)
            dz.log('setPersistent',dz.LOG_DEBUG)
            dz.data.usage.L1Wh = dz.data.usage.L1Wh + ( L1.WhActual * deltaSeconds / 3600 )
            dz.data.usage.L2Wh = dz.data.usage.L2Wh + ( L2.WhActual * deltaSeconds / 3600 )
            dz.data.usage.L3Wh = dz.data.usage.L3Wh + ( L3.WhActual * deltaSeconds / 3600 )
            dz.data.usage.dDate = dz.time.dDate
        end

        local function resetPersistent()
            dz.log('resetPersistent',dz.LOG_DEBUG)
            dz.data.usage.L1Wh = 0
            dz.data.usage.L2Wh = 0
            dz.data.usage.L3Wh = 0
            dz.data.usage.dDate = dz.time.dDate
            dz.data.usage.reset = dz.time.dDate
        end

        local function update_UsageDevices()
            if L1U then 
                dz.log('updateUsage' ,dz.LOG_DEBUG)
                L1U.updateElectricity(L1.WhActual)
            end
            if L2U then L2U.updateElectricity(L2.WhActual) end
            if L3U then L3U.updateElectricity(L3.WhActual) end
            
        end


        local function update_kWhDevices()
            
            if L1C then 
                dz.log('updateCounter ' .. L1C.counter .. '  with ' .. dz.utils.round(dz.data.usage.L1Wh,3) ,dz.LOG_FORCE)
                L1C.updateCounter(L1C.counter + dz.data.usage.L1Wh / 1000 ) 
            end
            if L2C then L2C.updateCounter(L2C.counter + dz.data.usage.L2Wh / 1000 ) end
            if L3C then L3C.updateCounter(L3C.counter + dz.data.usage.L3Wh / 1000 ) end
        end
        
        local function setOffset()
            if L1C.counter == 0 and L1Offset and L1Offset > 0 then L1C.setValues(0,L1Offset) end
            if L2C.counter == 0 and L2Offset and L2Offset > 0 then L2C.setValues(0,L2Offset) end
            if L3C.counter == 0 and L3Offset and L3Offset > 0 then L3C.setValues(0,L3Offset) end
        end
        
        
        -- initialize dz.data.usage data 
        if dz.data.usage.dDate == nil then
            setOffset()
            resetPersistent()
        else    
           setPersistent(dz.time.dDate - dz.data.usage.dDate) 
           update_UsageDevices()
        end
        
        if dz.data.usage.reset < ( dz.time.dDate - writeDelay ) then 
            update_kWhDevices()
            resetPersistent()
        end
    end
}

Code: Select all

local L1 = dz.devices('5') -- change to name / ID of your L1 usage device  
        local L2 = dz.devices('6') -- L2 watt
        local L3 = dz.devices('7') -- L3 watt 
        
        local L1C  = dz.devices('113') -- Change to name of your virtual device for L1 kWh used. (type counter, subtype counter, X-as kWh)
        local L2C  = dz.devices('114') -- L2
        local L3C  = dz.devices('115') -- L3
        
        local L1U = dz.devices('116') -- change to name / ID of your L1 daily usage device  
        local L2U = dz.devices('117') -- L2 
        local L3U = dz.devices('118') -- L3 

Code: Select all

local L1 = dz.devices(5) -- change to name / ID of your L1 usage device  
        local L2 = dz.devices(6) -- L2 watt
        local L3 = dz.devices(7) -- L3 watt 
        
        local L1C  = dz.devices(113) -- Change to name of your virtual device for L1 kWh used. (type counter, subtype counter, X-as kWh)
        local L2C  = dz.devices(114) -- L2
        local L3C  = dz.devices(115) -- L3
        
        local L1U = dz.devices(116) -- change to name / ID of your L1 daily usage device  
        local L2U = dz.devices(117) -- L2 
        local L3U = dz.devices(118) -- L3 

Code: Select all

local L1 = dz.devices('Verbruik L1 : kookplaat / oven / bg') -- change to name / ID of your L1 usage device  
        local L2 = dz.devices('Verbruik L2 : keuken, 1e, 2e') -- L2 watt
        local L3 = dz.devices('Verbruik L3 : qkr / mk / trap / schr'  ) -- L3 watt 
        
        local L1C  = dz.devices('L1C') -- Change to name of your virtual device for L1 kWh used. (type counter, subtype counter, X-as kWh)
        local L2C  = dz.devices('L2C') -- L2
        local L3C  = dz.devices('L3C') -- L3
        
        local L1U = dz.devices('L1U') -- change to name / ID of your L1 daily usage device  
        local L2U = dz.devices('L2U') -- L2 
        local L3U = dz.devices('L3U') -- L3