house_consumption_energy_daily and battery charge from grid...

[ward0]

Hello,

https://github.com/wlcrs/huawei_solar/wiki/Daily-Solar-Yield

This wiki mentions this:
Warning

This solution will yield incorrect results when charging from the grid.

Using this sensor for the moment:

• name: house_consumption_energy_daily
  unique_id: house_consumption_energy_daily
  #friendly_name: "Hausverbrauch daily"
  state_class: "total"
  device_class: "energy"
  unit_of_measurement: "kWh"
  icon: "mdi:solar-power"
  state: >-
  {% set inv_out = states('sensor.inverter_daily_yield')|float(0) %}
  {% set grid_out = states('sensor.power_meter_exported_energy_daily')|float(0) %}
  {% set grid_in = states('sensor.power_meter_consumption_energy_daily')|float(0) %}
  {{ (inv_out - grid_out + grid_in)|float(0) }}
  availability: >-
  {{ (states('sensor.inverter_daily_yield')|is_number)
  and (states('sensor.power_meter_exported_energy_daily')|is_number)
  and (states('sensor.power_meter_consumption_energy_daily')|is_number) }}

The result is 6.31kWh for today.
Of that 6.31, i charged 3,67kWh from the net.

The Huawei app is also showing this:
House use : 2,9kWh
From net: 3,67kWh

Tried with this sensor then (ChatGpt), but not working either:

• name: "House Consumption Energy Daily New"
  unique_id: house_consumption_energy_daily_new
  unit_of_measurement: "kWh"
  device_class: energy
  state_class: total_increasing
  icon: mdi:home-lightning-bolt
  state: >
  {% set discharge = states('sensor.battery_day_discharge') | float(0) %}
  {% set charge = states('sensor.battery_day_charge') | float(0) %}
  {% set pv = states('sensor.inverter_daily_yield') | float(0) %}
  {% set import = states('sensor.power_meter_consumption_energy_daily') | float(0) %}
  {% set export = states('sensor.power_meter_exported_energy_daily') | float(0) %}
  {{ (pv + import - export - charge + discharge) | round(2) }}
  attributes:
  description: >
  Dagelijks totaal energieverbruik van de woning (huis + apparaten), inclusief energie van zon, batterij en net.

The result is 6.31kWh for today.

Does anyone have a working formula?

The reason i want this fixed (if possible), is because i'm using predbat to charge the battery.
But for that, I need correct house load.

Regards,
Ward

[ward0]

Working formula at the moment:

• name: "House Consumption Energy Daily New"
  unique_id: house_consumption_energy_daily_new
  unit_of_measurement: "kWh"
  device_class: energy
  state_class: total_increasing
  icon: mdi:home-lightning-bolt
  state: >
  {% set pv = states('sensor.inverter_daily_yield') | float(0) %}
  {% set import_e = states('sensor.power_meter_consumption_energy_daily') | float(0) %}
  {% set export_e = states('sensor.power_meter_exported_energy_daily') | float(0) %}
  {% set discharge = states('sensor.batteries_day_discharge') | float(0) %}
  {{ (pv + import_e - export_e - discharge) | round(2) }}
  attributes:
  description: >
  Dagelijks totaal energieverbruik van de woning (huis + apparaten).
  Batterijlading wordt uitgesloten, batterijontlading wordt afgetrokken.

{% set discharge = states('sensor.batteries_day_discharge') | float(0) %} {% set charge = states('sensor.batteries_day_charge') | float(0) %} {% set pv = states('sensor.inverter_daily_yield') | float(0) %} {% set import_e = states('sensor.power_meter_consumption_energy_daily') | float(0) %} {% set export_e = states('sensor.power_meter_exported_energy_daily') | float(0) %} ### DEBUG OUTPUT BELOW ### == RAW SENSOR VALUES == batteries_day_discharge: {{ states('sensor.batteries_day_discharge') }} batteries_day_charge: {{ states('sensor.batteries_day_charge') }} inverter_daily_yield: {{ states('sensor.inverter_daily_yield') }} grid_import_daily: {{ states('sensor.power_meter_consumption_energy_daily') }} grid_export_daily: {{ states('sensor.power_meter_exported_energy_daily') }} == CONVERTED FLOATS == discharge (float): {{ discharge }} charge (float): {{ charge }} pv (float): {{ pv }} import (float): {{ import_e }} export (float): {{ export_e }} == CHECKS == Total energy from PV: {{ pv }} Net import minus export: {{ import_e - export_e }} Battery effect (discharge-charge): {{ discharge - charge }} == ORIGINAL FORMULA RESULT == pv + import - export - charge + discharge: {{ (pv + import_e - export_e - charge + discharge) }} == NEW FORMULA RESULT == pv + import - export - discharge: {{ (pv + import_e - export_e - discharge) }} == NEUTRAL BASELINE == (pv + import - export): {{ (pv + import_e - export_e) }} == EXTRA VERIFICATION == Actual house use (Huawei app): (not calculated here, but expected ≈ 2.9 kWh) Energy-from-grid (Huawei app): (not calculated here, but expected ≈ 3.67 kWh) ### DEBUG OUTPUT BELOW ### == RAW SENSOR VALUES == batteries_day_discharge: 3.27 batteries_day_charge: 2.97 inverter_daily_yield: 2.79 grid_import_daily: 3.67 grid_export_daily: 0.04 == CONVERTED FLOATS == discharge (float): 3.27 charge (float): 2.97 pv (float): 2.79 import (float): 3.67 export (float): 0.04 == CHECKS == Total energy from PV: 2.79 Net import minus export: 3.63 Battery effect (discharge-charge): 0.2999999999999998 == ORIGINAL FORMULA RESULT == pv + import - export - charge + discharge: 6.72 == NEW FORMULA RESULT == pv + import - export - discharge: 3.15 == NEUTRAL BASELINE == (pv + import - export): 6.42 == EXTRA VERIFICATION == Actual house use (Huawei app): (not calculated here, but expected ≈ 2.9 kWh) Energy-from-grid (Huawei app): (not calculated here, but expected ≈ 3.67 kWh)

[sotatech]

This template uses sensor.power_meter_exported_energy_daily and sensor.power_meter_consumption_energy_daily but my meter only has sensor.power_meter_exported and sensor.power_meter_consumption. How do I derive the daily values?

[ward0]

@sotatech You still need help?

[sotatech]

Yes, I did make some progress but I'm finding getting all the data from the integration into HA confusing! I gave up on it, but I had a look again and I used your template sensor above, but I was getting errors with the attributes section. Is the highlighted text above starting with "{% set discharge = states('sensor.batteries_day_discharge') | ...." suppposed to be included in the sensor definition? This is what I used:

- sensor:
    - name: "House Daily Energy Consumption"
      unique_id: "house_daily_energy_consumption"
      unit_of_measurement: "kWh"
      device_class: energy
      state_class: total_increasing
      icon: mdi:home-lightning-bolt
      state: >-
        {% set pv = states('sensor.inverter_daily_yield') | float(0) %}
        {% set import_e = states('sensor.power_meter_consumption_energy_daily') | float(0) %}
        {% set export_e = states('sensor.power_meter_exported_energy_daily') | float(0) %}
        {% set discharge = states('sensor.batteries_day_discharge') | float(0) %}
        {{ (pv + import_e - export_e - discharge) | round(2) }}
 # attributes:
 # description: >
 #   Total daily energy consumption of the home (house + appliances).
 #   Battery charging is excluded, and battery discharge is subtracted.

However, this gives me an error: Entity sensor.house_daily_energy_consumption from integration template has state class total_increasing, but its state is not strictly increasing. Also get the same error with sensor.solar_total_yield and sensor.solar_daily_yield. It's totally confusing for me, as the values produced bear little or not relationship to what I see in the Fusion Solar app.

[ward0]

@sotatech You have a battery like me? Or what would you like exactly?