#Energy Dashboard data dosen't add up

1 messages · Page 1 of 1 (latest)

quick bridge
#

Hi there,

I’m having some issues integrating my new solar system to the energy dashboard.

It seems like the solar energy produced is also being counted as consumed energy, or something along those lines.

I’m using two Shelly 3PMs:

• One is connected to the cable coming from the solar inverter to the distribution board.

• The other one is connected from the distribution board to the house.

Since, as I understand it, I can’t use just the energy meter for solar power directly, I’m using the following helpers:

 - platform: integration
    source: sensor.einspeiseleistung
    name: Einspeiseenergie
    unit_prefix: k
    unit_time: h
    round: 2
    method: trapezoidal

  - sensor:
      - name: "Einspeiseleistung"
        unique_id: einspeiseleistung_watt
        unit_of_measurement: "W"
        device_class: power
        state: >-
          {% set pv_power = states('sensor.pwr_hak_pv_total_active_power')|float | abs %}
          {% set grid_power = states('sensor.pwr_hak_ott_total_active_power')|float %}
          {% set net_power = pv_power - grid_power %}
          {{ 0 if net_power < 0 else net_power }}

It would be great if someone could point out what I’m doing wrong.

Next week, I’ll be replacing the entire electrical cabinet (the one with the energy meters and breakers) with a newer model.
If a different setup would make the integration easier, I could easily make those changes during the upgrade.

slender junco
#

Can you attach an energy csv download, specifically pointing out what datapoints you don't feel are correct?

quick bridge
#

Sorry my description wasnt that clear.The usage dosent add up in my opinion. The unknown energy usage is very low except when solar energy is produced as shown in the image. It is always like this, most noteable on days where the sun shines a lot. Wasn't aware of the export feature. Looking into that right now and will report when i managed to export the data to a csv file.

slender junco
#

and what in this data is bothering you (please be specific)

quick bridge
#

In the screenshot the daily solar energy is 80 kwh. The usage was 44 kwh. So the net energy returend should be 36 kwh and not 4,62 kwh.

If you also check the gray bars on top of the wallbox energy ones at 1 to 3 pm. This is a huge amount of unknown energy used that is not plausible to me.

slender junco
#

Energy returned is a sensor that you provide. It doesn't come from energy integration.

#

Lets focus on a specific hour, and not the entire day. It's easier to analyze.

#

I think your CSV is from a different day than your screenshot? (it ends at ~7pm)

quick bridge
#

Yes its from today. I thought this is a complete dump. I will post the correct one in a sec

slender junco
#

It may be complete for today, but your screenshot shows a full 24 hour day, so I assume it is not from today .

quick bridge
#

The screenshot is from Monday of this week

slender junco
#

So like 1PM, has 11kWh of untracked.

Your data says you're pulling 11kWh from grid, 14kWh from your panels, returning 3kWh, and individual devices consuming ~10kWh

#

11 + 14 - 3 - 10 ~= 11 kWh

#

Does it make sense how that number is computed?

quick bridge
#

Yes that makes sense to me, thank you very much. I assume there is an issue with my setup/config because that 11kwh of untracked makes no sense. It should be a couple hundred wh at the most. I wonder if the grid measurement also needs to measure the returned energy of the solar system and not like I do to run it in parallel.

slender junco
#

Yeah must not be correct. I'll guess you're not really buying 11kWh of energy from the power company at that time? As that's what your sensor is saying.

quick bridge
#

Yep, that’s because it sits at a position where the energy goes through the solar meter and then through the grid measurement again. I thought HA is doing some magic and is canceling that out. The longer I think about it the less it makes sense. 😅 I could fix that with extra virtual sensors I guess, but will go for a different placement for the grid meter.

slender junco
#

No magic 😅 . That's supposed to be the amount you buy from the power company.