Domoticz

Code: Select all

Percentage.updatePercentage(PercZonnepanelen)

Code: Select all

-- Helper functions
local function spaces(count)
    return (" "):rep(count)
end

local function round(num, decimals)
    local mult = 10^(decimals or 0)
    return math.floor(num * mult + 0.5) / mult
    end

local function formatPowerValue(value)
    return math.floor(value * 100 + 0.5) / 100
end

-- Energy calculations
local function calculateEigenGebruik(domoticz)
    local solar = domoticz.devices('Zonnepanelen').counterToday
    local returned = domoticz.devices('Power').counterDeliveredToday
    return round(solar - returned, 2)
end

local function getPowerUsageInfo(domoticz)
    local powerDevice = domoticz.devices('Power')
    local isUsing = tonumber(powerDevice.rawData[5]) > 0
    
    return {
        colorFlag = isUsing and "red" or "green",
        balance = formatPowerValue(isUsing and powerDevice.usage/1000 or -powerDevice.usage/1000),
        type = isUsing and 'usage' or 'return'
    }
end

-- Update functions
local function updateEnergyInfo(domoticz)
    local powerInfo = getPowerUsageInfo(domoticz)
    local eigenGebruik = calculateEigenGebruik(domoticz)
    local solarDevice = domoticz.devices('Zonnepanelen')
    local eigenGebruikPercentage = math.floor((eigenGebruik * 100) / solarDevice.counterToday)
    
    local text = string.format(
        'Gas today'..spaces(19)..'%s m³\n' ..
        'Gas yesterday'..spaces(11)..' %s m³\n' ..
        'Gas the day before'..spaces(3)..' %s m³\n\n\n' ..
        spaces(15)..'Solar actual'..spaces(16)..'%s <font color="green">kW</font>\n' ..
        spaces(15)..'Solar today'..spaces(17)..'%s kWh\n\n' ..
        spaces(15)..'Power actual %s'..spaces(2)..' %.2f <font color="%s">kW</font>\n' ..
        spaces(15)..'Power usage today'..spaces(4)..'%.2f <font color="red">kWh</font>\n' ..
        spaces(15)..'Power return today'..spaces(4)..'%.2f <font color="green">kWh</font>\n\n' ..
        spaces(15)..'Eigen gebruik'..spaces(14)..'%s kWh/%s%%\n',
        
        domoticz.devices('Gas').counterToday,
        domoticz.devices('Gas gisteren').sensorValue,
        domoticz.devices('Gas eergisteren').sensorValue,
        
        round(solarDevice.usage / 1000, 2),
        round(solarDevice.counterToday, 2),
        
        powerInfo.type, powerInfo.balance, powerInfo.colorFlag,
        round(domoticz.devices('Power').counterToday, 2),
        round(domoticz.devices('Power').counterDeliveredToday, 2),
        
        eigenGebruik,
        eigenGebruikPercentage
    )
    
    domoticz.devices('Energie').updateText(text)
end

-- Main script
return {
    on = {
        timer = {'every 1 minutes'},
    },
    
    logging = {
        level = domoticz.LOG_ERROR,
        marker = '---- Alles in text -----'
    },

    execute = function(domoticz, item)

            updateEnergyInfo(domoticz)
    end
}

Code: Select all

local percentageDevice = domoticz.devices(IDX)

Code: Select all

percentageDevice.updatePercentage(PercZonnepanelen)

Code: Select all

-- This script collects the values below from Domoticz
--   * The Power and energy values (import and export) from a smartmeter 
--   * The Power and energy values from a Solar power inverter
-- It then calculates the consumed power and energy from the values above with the formula's
--   * EnergyConsumption = EnergyGeneration + EnergyImport - EnergyExport
--   * PowerConsumption = PowerGeneration + PowerImport - PowerExport
-- It then updates a virtual device which displays the % consumed energy Solar panels own use.
 

return {

    on = {
        devices = {
					-- Devices on which this calculation script should trigger. These should be the same as the IDX of Smartmeter and/or IDX of Solar Panels
                    171, -- IDX of Smart meter (youless or P1)
                    258, -- IDX of Solar Panels
                   -- 1081 -- IDX of Aandeel zonnepanelen
                }
        },

    logging = {
        level = domoticz.LOG_INFO,
      --  level = domoticz.LOG_ERROR,
        marker = "Percentage"
               },   

	execute = function(dz, item)

	   
		----------------------------------------------------------------------------------------------------------
		-- Domoticz IDX of the needed devices
		----------------------------------------------------------------------------------------------------------
   
        local Smartmeter = dz.devices(171)   -- IDX of Smart meter (youless or P1)
        local Generation = dz.devices(258)   -- IDX of Solar Panels
        local DevPercZonnepanelen = dz.devices(1081)  -- IDX of Percentage

        -- Smartmeter

        local EnergyExportLow = Smartmeter.rawData[3]
        local EnergyExportHigh = Smartmeter.rawData[4]

        -- Generation

        local EnergyGeneration = Generation.rawData[2]           -- (P) Productie zonnepalen
        local EnergyExport = EnergyExportLow + EnergyExportHigh  -- (I) Export naar electriciteitsnet

        local PercZonnepanelen = tonumber((( EnergyGeneration - EnergyExport))/EnergyGeneration) * 100
        dz.log('PercZonnepanelen: ' .. PercZonnepanelen, dz.LOG_INFO)
        
		--Update
	
        DevPercZonnepanelen.updatePercentage(PercZonnepanelen) -- Update device DevPercZonnepanelen with value PercZonnepanelen
    end
}

Code: Select all

return {
    on = {
        devices = { 171, 258 }
        },
    logging = {
        level = domoticz.LOG_INFO,
        marker = "Percentage"
               },   

    execute = function(dz, item)
        local Smartmeter = dz.devices(171)   		-- IDX of Smart meter (youless or P1)
        local Generation = dz.devices(258)			-- IDX of Solar Panels
        local PercZonnepanelen = dz.devices(1081)  	-- IDX of Percentage

        local EnergyExportLow = Smartmeter.rawData[3]
        local EnergyExportHigh = Smartmeter.rawData[4]
        local EnergyGeneration = Generation.rawData[2]           -- (P) Productie zonnepalen

        local EnergyExport = EnergyExportLow + EnergyExportHigh  -- (I) Export naar electriciteitsnet
        local PercZonnepanelen = tonumber((( EnergyGeneration - EnergyExport))/EnergyGeneration) * 100,

        Percentage.updatePercentage(PercZonnepanelen)
    end
}

Code: Select all

      local EnergyExportLow = Smartmeter.rawData[3]

Code: Select all

      local EnergyExportLow = tonumber(Smartmeter.rawData[3])

Code: Select all

        local PercZonnepanelen = tonumber((( EnergyGeneration - EnergyExport))/EnergyGeneration) * 100,