How to Calculate Total Household Usage with DSMR P1 Data and Solar Panels during Daytime

Hi everyone,

I’m trying to calculate the total power usage of all devices in my house, including the energy directly consumed from my solar panels. However, the P1 meter offsets energy production and consumption when the solar panels are generating electricity, making it difficult to see the real-time total usage. For example, a variable like Power Produced drops to zero, which makes it challenging to calculate the actual household consumption.

I noticed that Home Assistant’s energy functionality seems to calculate total consumption correctly, but as far as I can see, this calculation isn’t directly accessible for my own custom formulas.


See consumed solar

Available variables from Slimmelezer:

Variable Value
Current Phase 1 2.0 A
Current Phase 2 3.0 A
Current Phase 3 0.0 A
Energy Consumed Tariff 1 14016.576 kWh
Energy Consumed Tariff 2 17536.861 kWh
Energy Produced Luxembourg NA
Energy Produced Tariff 1 3110.202 kWh
Energy Produced Tariff 2 6990.543 kWh
Gas Consumed 3774.730 m³
Long Electricity Failures 16
Power Consumed 0.000 kW
Power Consumed Phase 1 0.000 kW
Power Consumed Phase 2 0.000 kW
Power Consumed Phase 3 0.082 kW
Power Produced 1.063 kW
Power Produced Phase 1 0.069 kW
Power Produced Phase 2 0.022 kW
Power Produced Phase 3 0.000 kW
Voltage Phase 1 229.1 V
Voltage Phase 2 229.2 V
Voltage Phase 3 228.4 V

Context

I’m trying to calculate Verbruik accurately. When the solar panels generate electricity above the Grid, another stream will appear that merges into the Verbruik category. This will represent the sum of both Grid and Solar availability. On the bottom-right side (beneath Restverbruik), the energy sent back to the Grid will be shown, just like Restverbruik.

My Question:

Are there specific formulas or approaches you recommend for handling this with the DSMR P1 data to calculate the total household usage (grid + direct solar consumption) while solar panels are producing electricity?

I’d greatly appreciate any examples or insights. Thanks in advance!

Interresting. I’m trying to achieve the exact same thing.

Which sensor(s) do you use as total power consumed? I assumed that ‘Power Consumed’ is the total, but if I sum up the ‘Power Consumed Phase 1’, ‘…Phase 2’ and ‘…Phase 3’ I get a much higher value. Your overview showes the exact same behaviour though.