@alexeiw123 - you can limit or exclude entities from being recorded in your database - this is the file that stores your data and it can grow very big with one second updates from the mqtt sensors - mine grew to over 2Gb before I took action. Following is an extract from my configuration.yaml -
Notes -
purge_keep_days limits how many days of history your database holds
auto_purge will automatically delete history older than purge_keep_days
the Exclude section won’t record any history for those entities (although they are still recorded in the Energy graph section)
Yes, this helps immensely - I’m learning a lot. It lead me to read Recorder - Home Assistant which also had a tonne of useful information. It may be worth adding this as an important consideration in your add-on documentation?
It’s very interesting that the energy dashboard can plot data that isn’t recorded in the database. It must be storing the sensor data as 1 hour averages somehow seperately. Quite handy.
I spent some time sorting out my entities that need to be recorded and those that don’t.
I’m getting 1m data using the built in enphase integration and using that for the energy dashboard and historicals. I’m also using your add on to calculate 1s ‘real-time’ costs, but also to plot my 3 phase voltages. I’ve minised the entities I’m recording and keeping an eye on my database size. Thanks for your help.
Has anyone figured out how to make it work with more recent software versions which I think require a JWT token that’s obtained through https://entrez.enphaseenergy.com ? (Which by the way only seem to last an hour though Enphase says they last 6 months)
That’s the only way I have of accessing the local API, AFAIK with a gateway running D7.0.85 (e269f2) (20 Oct, 2021 1:44 PM)
I’ve noticed recently that my Solar Forecast has a super high peak at the end of the day when using Solar Energy Corrected. I can fix this by using a damping factor of 0.25 in the Forecast.solar integration, but this makes the forecast shift a bit. I’m just being too nitpicky, but was wondering if other’s are seeing this.
Hi everybody, i need help for my poor skill in templating.
I have an enphase integration for the production/consume side and a Huawei solar integration for the battery (in Italy enphase batteries are not imported yet so i installed as retrofit a huawei inverter with its batteries). The huawei inverter is linked to enphase in AC and act only for charge/discharge the batteries.
From huawei integration i have a sensor.charge_discharge_power with positive values when charges and negative on discharges, it’s a power sensor in W
From enphase integration:
sensor.envoy_XXXXXXXXX_current_power_consumption, power sensor in W
sensor.envoy_XXXXXXXXXXXX_current_power_production, also in W
My idea is creat a chart with over 0 in Y there are the sources of power so import, solar production and battery discharge; below 0 there are the uses of power so export, home consumption, battery charge.
I think need these sensors:
a sensor like sensor.envoy_XXXXXXXXX_current_power_consumption but negative because i’d like see consumption below 0 in a Y axis in the chart.
a sensor like sensor.charge_discharge_power but inverted, with charge value positive and discharge negative.
a sensor.import_from_grid. it should be = sensor.envoy_XXXXXXXXX_current_power_consumption - sensor.envoy_XXXXXXXXXXXX_current_power_production + sensor.charge_discharge (remember that it is negative when battery discharges so sum to a negative value will be a minus). This value should be only positive.
a sensor.export_to_grid. it should be = sensor.envoy_XXXXXXXXXXXX_current_power_production - sensor.envoy_XXXXXXXXX_current_power_consumption - sensor.charge_discharge (remember that it is positive when battery charges). This value should be only negative.
Import and export sensors should have a treshold somewhere around 50 w because the readings of production and consumption are simultaneous instead of the value of charge_discharge sensor that has a different timing. So, for example, in night when the power is supply only from the buttery and it should be equal to consumption, there is always a little difference that should be readed as an importation or exportation of power.
My skill with templates are too poor for the tasks so i beg for an help. Sorry also for my english
Thank
Thanks @angusc, i was able to write almost all the sensor except this function: “Import and export sensors should have a treshold somewhere around 50 w”.
My sensor now are:
- name: Import potenza
unit_of_measurement: W
device_class: power
state: >-
{{ [0, states('sensor.envoy_XXXXXXXXXX_current_power_consumption') | float - states('sensor.envoy_XXXXXXXXXX_current_power_production') | float + states('sensor.charge_discharge_power') | float] | max }}
- name: Export potenza
unit_of_measurement: W
device_class: power
state: >
{{ [0, states('sensor.envoy_XXXXXXXXXX_current_power_production') | float - states('sensor.envoy_XXXXXXXXXX_current_power_consumption') | float - states('sensor.charge_discharge_power') | float] | max }}
What is missing is that if the value is below 50 the value is 0.
I tried to inspiring from @del13r configuration
- sensor:
name: Solar Power Corrected
state_class: measurement
icon: mdi:solar-panel
unit_of_measurement: W
device_class: power
state: >
{% set value = states('sensor.envoy_SERIALNUMBER_current_power_production') | int %}
{% if value <= 4 -%}
0
{% elif is_state('sun.sun','below_horizon') %}
0
{%- else -%}
{{ value }}
{%- endif %}
deleting the elif part but in my sensor the value is the result of an operation and i am unable to write it correctly.
I plays with the templates in the Developer template section of my HA, are you sure your envot production sensor is called “power” and not “energy”?
{% set value = states('sensor.envoy_12201xxxxxxx_current_energy_production') | int(default=0) %}
{% if value <= 4 -%}
0
{% elif is_state('sun.sun','below_horizon') %}
0
{%- else -%}
{{ value }}
{%- endif %}
For me this Energy Difference Sensor works well, it is reading + value when importing power from the grid and a - value when Exporting from the grid… Also the icon is templated to change with Grid import or export
What is the purpose for that 50w threshold? I see up a sensor for solar “awake” and solar “sleeping” and set that to operate when production was below 30w. Then I can use that sensor in certain automatons that I only want to trigger when the solar is awake.
Yes, my sensors are ‘power’.
I need two different sensors for Energy dashboard that has two entries.
For the purpose make an example:
Import= consumption-production-discharge_battery
During night of course production=0 and the battery_discharge = consumption so import should be 0.
But battery_discharge value is supplied from a different integration (Huawei solar) then consumption (enphase integration) so there is almost always a little (few W) difference.
But few W for days became kW so now my import sensor reports kWh of value when in this period i am totally self-sufficient.
So the idea to set a threshold
In your case the threshold is set on the “single” sensor.envoy_1220xxxxxxx_current_energy_production. In my case the variable under the condition is a result of an algebric sum.
What i’m not able to write is:
if (sensor.envoy_122122047974_current_power_production - sensor.envoy_122122047974_current_power_consumption - sensor.charge_discharge_power) <50)
the value is 0
else
the value
endif
So i need to change this:
- name: Export potenza
unit_of_measurement: W
device_class: power
state: >
{{ [0, states('sensor.envoy_XXXXXXXXXX_current_power_production') | float - states('sensor.envoy_XXXXXXXXXX_current_power_consumption') | float - states('sensor.charge_discharge_power') | float] | max }}
I am setting up the Energy integration to work with my Enphase system and I have looked at the instructions at the top of this thread.
The question I have is why an integrator of instantaneous power is used to determine grid import/export instead of using the delta in the lifetime energy consumption - lifetime energy production?
My assumption is that using the actual energy figures would end up with a more accurate result and I assume the biggest source of error would be when flipping from import to export.
Also is there documentation on the yaml configuration options that I can look at?
I get the feeling that because my system is in a container that I don’t have the same editor options available to me
