Show or calculate self consumed solar energy or remove gauge

erickranendijk · June 2, 2022, 12:54pm

Hi,

A question I could not find an answer to: on the energy dashboard there is a gauge indicating the self consumed solar energy. My dsmr integration however does not provide me with such data. Is there a way to have the consumed solar energy be calculated? Should be a template sensor I assume. But how do I add that in my energy dashboard? Or should that be taken care of by HA’s magic? And if it is not there… how can I remove that gauge from the energt dashboard without removing the solar panel in the graphic? The numbers shown there are very useful.

Some pictures:

HiTechRedNeck · June 2, 2022, 9:11pm

I have multiple devices, and I’m in the US, so it may work differently for you… but here is my setup…

the grid consumption and return to grid are coming from my Rainforest EAGLE-200, which gathers my import and export to my utility directly from my utility meter over a form of Zigbee radio…

my solar production comes from my Sense energy monitor as my solar system doesn’t have direct integration with HA, but I’m working on a link there…

that makes it all work…

HiTechRedNeck · June 2, 2022, 9:15pm

here’s mine…

once I get my SunPower integration working, my SunPower system supervisor has all these numbers from the same source (different sensor/entities) and more accurate… I get a 3-5% variance within my multiple devices… I will be adding my gas as well… we have a smart gas meter, but there is no product that supports it… so I will be using a SDR (software defined radio) to capture the signal sent to the utility company…

erickranendijk · June 2, 2022, 9:56pm

Hi @HiTechRedNeck thanks! Not sure about the differences in setup between US and NL though. Fun (well…) part is that my smart meter records how much is produced by the panels, however the “local consumed” part is missing. That’s the part I need to calculate somehow to see my net usage and have the self consumed solar energy gauge do its thing.

But how… adding a template sensor using produced minus used yields a negative value. Energy dashboard does not like it. Converting the value using abs ends up in incorrect figures.
I am not a maths person so stuck a little bit.
Time to sleep, start thinking again tomorrow.

Interested about your setup though!

HiTechRedNeck · June 2, 2022, 10:25pm

ok, let me try to explain it better…

I have 3 numbers:

Daily from Grid (EAGLE-200, positive number) > HA Energy Dashboard > Grid consumption (imported from the grid)
Daily to Grid (EAGLE-200), negative number) > HA Energy Dashboard > Return to grid (exported to the grid)
Daily Production (Sense, positive number) > HA Energy Dashboard > Solar production (total production only from the PV system)

the Daily Production can be used against each of the other numbers to figure out the “consumed from grid” and “consumed from solar” so then the gauges all populate with percentages…

erickranendijk · June 3, 2022, 12:10pm

Got it!

Sensors in my example:

from grid (DSMR5 smart meter, positive number) → HA Energy Dashboard → Grid consumption (imported from the grid)
no such sensor…
daily production (DSMR5 smart meter, positive number) > HA Energy Dashboard > Solar production (total production only from the PV system)

So for 2 I need to do some calculations which basically would be like “3-1”. However if I do so, numbers are negative and Return to grid does not support negatives. Weird, isn’t it?

HiTechRedNeck · June 3, 2022, 6:42pm

return to grid is a negative number… its the only thing it can be… think of it as turning the meter backwards… mine is negative…

erickranendijk · June 3, 2022, 10:32pm

I understand, it is how my neighbor is using his old skool analog meter. Energy company does not like it
It seems however my sensors’ value is not supported by the return to grid. That’s why I am puzzled… It is Dutch, but the image is self explanatory I guess. “ computer says no”

erickranendijk · June 12, 2022, 9:24am

Still no luck, I assume I just produce and deliver to the net. No self usage… so the question remains: how do I remove the “self consumed solar energy” gauge from the dashboard?
I know I can remove it by removing the solar production, but for clarity I do want to see that.

Help?

Dynamix72 · August 17, 2022, 8:01am

Hi Eric, any luck yet to solve the problem?
I have the same problem. The DSMR device is sending the actually consumed - self-consumed solar energy as consumed energy.

Actually consumed energy is delivered (but can’t be used in the energy dashboard)
Self-consumed solar energy is missing (this can be calculated if the actually consumed energy is delivered by the DSMR device)
Consumed energy (with self-consumed solar subtracted) is delivered
Solar energy produced is delivered

erickranendijk · August 22, 2022, 8:55pm

Hi @Dynamix72 until now… nope. And I did not have time to dig into it. So far I just ignore the gauge. Not my preferred option though.
In HA I find it very hard to create nice graphs for things like net usage (produced-consumed). I used to work with domoticz+dashticz and that was easy peasy. However the interface is bad for WAF

notacoderjustauser · September 20, 2022, 2:39pm

Hello,
I found your problem while searching somethinge else.
Have you tried to make a sensor template which inverts the Value of your Sensor which representates your net energy consumption?

example

- sensor:
    - name: "netto_stroomverbruik_pos"
      device_class: energy
      state_class: total_increasing
      unit_of_measurement: "kWh"
      state: >
              {%set temp = states('netto_stroomverbruik') | float(0)%}
              {{ temp * -1 }}

not tested, but when u add this sensor and delete the other (including Paneelen) in the section “Teruglevering” it should calculate right.

Bleda22 · October 9, 2022, 12:52pm

Hi there,

I had the same problem but the solution is actually very simple!
Like you i had my solar power feed back to grid set to the same entity as my solar power total AC production (solaredge (AC Energy kWh) in my case). which obviously results in them having the same value in the dashboard.

Your calculated solar power feed back to grid is actually measured separately by your slimme meter. if you set it up like this it should work.

erickranendijk · October 10, 2022, 7:50am

Hi @Bleda22 that should work, however I do not have a separate entity to monitor what my solar panels produce (Zonneplan) so this is not working for me unfortunately.
The best option would be in my opinion to create a sensor which makes the “teruglevering” a Net-value: take the value of the “Electricity Meter Energy consumption” from the “slimmemeter” and substract the “Electricity Meter Energy production” from it in the same time period.

But then… that could be negative and that is not what HA energy dashboard supports.

Bleda22 · October 10, 2022, 9:24am

Sorry I must have misunderstood.
A dumb question maybe but if you don’t have a separate entity to monitor you PV production, then I assume you use the slimme meter production value to visualize your solar production in the energy dashboard?

If so, this is incorrect.
The slimme meter is not aware of your total PV production or your own PV production consumption.
slimme meter production value is the excess power delivered back to the grid.

Edit:
So your self consumed PV production should be: total PV production of today - Slimme meter production

erickranendijk · October 13, 2022, 7:34pm

I found the solution by adding the HACS integration Zonneplan ONE and use the yield sensor for the solar panels in the energy dashboard. Now it shows what I actually use of my solar energy and what is returned to the grid! Gauges are working as well.
Next step is to reliably make sensors which are a combination of high and low tariff for production and consumption. I thought I had a solution but the sensors all of a sudden stopped calculating and I did not find a solution yet. This thread

madtraxx18 · October 24, 2022, 7:32pm

So but is there a way then to use this without having an additional reader to measure the solar panels?

Subtract the current consumption from the current production seems to be the easiest way to get this going.

AndyIoT · October 31, 2022, 7:39am

Hi, happy to know you solved the problem!

Please, can you share also a picture of ‘energy configuration page’ (Where you set grid consumption/ return to grid / solar production) and a short description of the source of these entities?

Here mine:

I use PVOutput as data source:
for ‘grid consumption’ I put the ‘Energy consumed’ that actually is the total amount of energy consumed by the house, not the energy pulled from the grid.
In ‘return to grid’ the energy generated.

In addition, from PVOutput I can have also ’ power generated/ power consumption ', but probably useless for that.

Thanks!

erickranendijk · October 31, 2022, 7:40pm

Hi @AndyIoT sure, no problem.
For “Netverbruik” I use the dsmr delivery high and low, “Teruglevering” is dsmr return high and low. I use the P1 dsmr interface for my Dutch smart meter.
For the “Zonne-energieproductie” I use the “Zonneplan one” HACS integration and the counter is the “sensor.zonneplan_yield_total”.

Picture with some nice grafitti on it.

AndyIoT · October 31, 2022, 10:56pm

Thanks! I’ll try to review my settings following yours.