Sure, I understand.
Introducing a 3rd party method for obtaining energy import (grid consumption) and energy export (return to grid) opens up a whole new topic which could further confuse new users.
Not sure if it will help, but you could try my version in post 116. It retrieves total values from the cloud and others from local endpoints. If your setup is not exactly like mine, you might have to fool with indexes in the code to get the correct values from local endpoints, but the cloud should work if populated in the app. The code is not robust and I do not plan to improve it.
Was wondering if anyone here could help me out, or at least point me in the right direction.
The Energy dashboard in HA provides a nice summary of Off Peak, Shoulder and Peak grid consumption. But what I was hoping to do is create some sensors that would give me the solar usage for those same periods.
At the moment, I can get the result by manually adding up the solar production for those hours, but I wanted a sensor to do it for me. I tried setting up something like this, but Iām drawing a blank on how to get it to calculate the right usage for that particular period.
- name: Daily OffPeak Solar Usage
state_class: total
unit_of_measurement: kWh
device_class: energy
state: >
{% if is_state('sensor.tou_period', 'offpeak') %}
{{ (states('sensor.energy_import') | float(0) - states('sensor.energy_export') | float(0)) | round(2) }}
{% endif %}
- name: Daily Shoulder Solar Usage
state_class: total
unit_of_measurement: kWh
device_class: energy
state: >
{% if is_state('sensor.tou_period', 'shoulder') %}
{{ (states('sensor.energy_import') | float(0) - states('sensor.energy_export') | float(0)) | round(2) | round(2) }}
{% endif %}
- name: Daily Peak Solar Usage
state_class: total
unit_of_measurement: kWh
device_class: energy
state: >
{% if is_state('sensor.tou_period', 'peak') %}
{{ (states('sensor.energy_import') | float(0) - states('sensor.energy_export') | float(0)) | round(2) | round(2) }}
{% endif %}
Hello @yesterdayshero
-
Any time you are exporting to grid, your panels are producing more than your house is consuming.
-
Anytime you are importing from grid, your house is consuming more than your panels are producing.
-
Anytime your production is > 0W, you are āusing solarā.
May I ask what do you mean by āsolar usageā and what is your motivation/goal in measuring it?
Hi @del13r
Iām trying to get how much solar Iāve used (ie. consumed, not sent back to the grid), but broken out into the specific Off-peak, Shoulder and Peak periods.
For example, if I consumed 10kWh during the Shoulder period, Iād like to know how much of that Shoulder consumption was from Solar. I believe from the Energy dashboard, I can already get the grid consumption. I was looking for a way to easily get the Solar consumption during those periods also.
Perhaps Iām overthinking it though and missing something obvious.
I suppose the basic formula for finding self consumption might look like this for power figures occuring right now:
value_template: >-
{% if states('sensor.power_production') | int(0) > 0 %}
{{ states('sensor.power_consumption') | int(0)
- states('sensor.power_import') | int(0) }}
{% else %}
0
{% endif %}
This formula will not work for accumulated energy in Wh or kWh as your daily consumption starts accumulating before the sun rises and therefore the formula will not yield the results you are after when applying this to daily energy in Wh or kWh.
Instead, you would have to use the Integration - Riemann sum integral to convert the the self consumed power into self consumed energy over time after setting up the above template sensor as it has the IF statement which excludes consumption before sunrise and after sunset.
In energy dashboard, it already calculates and displays self consumption when I roll my mouse over each hour and shows as consumed solar (the yellow bar).
For 4pm-5pm for example, my house consumed 2.4 kWh including the 0.14 kWh imported from the grid. To find consumed solar, energy dashboard subtracts the 0.14 kWh import from the 2.4 kWh total consumption to get 2.26 kWh self consumption (consumed solar).
Self consumption for the day is also shown on the right as Self-Consumed solar energy.
I would not recommend trying to get the data from the above template sensor into Energy Dashboard as this sensor is not intended for that purpose as Energy dashboard already calculates this per hour based on the expected inputs for energy dashboard being Grid consumption(import), Return to grid(export), Solar production.
Here is my energy dashboard config as an example
You can use the following template in the Developer Tools for logic testing.
Consuming:
{{ states('sensor.power_consumption') | int(0) }}
Importing:
{{ states('sensor.power_import') | int(0) }}
Self Consuming:
{% if states('sensor.power_production') | int(0) > 0 %}
{{ states('sensor.power_consumption') | int(0)
- states('sensor.power_import') | int(0) }}
{% else %}
0
{% endif %}
Example output on the right of what was happening just before sunset:
Example output on the right of what was happening just after sunset:
1 Like
Thanks for the detailed response @del13r. Iām going through it and seeing what I might be able to do.
Yes, this is actually what Iām doing at the moment. Iām basically hovering over each hour in the Off-Peak/Shoulder/Peak periods to add up my solar consumption for each. I was seeing if there was a way to create a sensor that captures this so I wouldnāt need to manually do it.
Agree. I wasnāt looking to add it to the energy dashboard. Just wanted to see if I could capture it myself for my own usage.
1 Like
Hi @yesterdayshero
Cheers. Yeah I only tested the self consumption sensor in dev tools, but the theory and logic make sense.
Not sure if you know this, but you can get the self consumption for each day as well by zooming out to the week view in energy dashboard.
1 Like
Yeah this would be ideal if the solar usage was grouped similar to how the grid usage is grouped by Peak, Shoulder, OffPeak
It looks like Enphase has changed their API and even the Brian Campbell integration doesnāt work now. I should have figured out a way to restrict Enphase fw updates. Im not on FW 8.2.127
There were more reports like your experience. you may want to try this to see if it helps in your case.
AFAIK the API they changed is for the web api, not the Envoy api.
Edit to correct non working approach.
Hi,
To accommodate for the occasional loss of communication to the Envoy, I modified the sensors to define the Energy Consumption in the REST sensor rather than in a template sensor. I also decided to get the Power information from another API so that I donāt have to calculate Power Consumption:
rest:
- resource: https://envoy.local/ivp/meters/reports
headers:
Authorization: !secret enphase_api
verify_ssl: False
scan_interval: 60
sensor:
- name: "Solar Power Production"
value_template: >
{% set value = value_json[0].cumulative.currW | int(0) %}
{% if value <= 5 -%}
0
{% elif is_state('sun.sun','below_horizon') %}
0
{%- else -%}
{{ value }}
{%- endif %}
device_class: power
unit_of_measurement: W
state_class: measurement
icon: mdi:solar-power-variant
- name: "Power Consumption"
value_template: "{{ value_json[2].cumulative.currW | int(0) }}"
state_class: measurement
device_class: power
unit_of_measurement: W
icon: mdi:home-lightning-bolt
- name: "Power Net"
value_template: "{{ value_json[1].cumulative.currW | int(0) }}"
state_class: measurement
device_class: power
unit_of_measurement: W
icon: mdi:transmission-tower
- name: Grid Power Import
# Max (0, Power Net)
value_template: "{{ [0, value_json[1].cumulative.currW | int(0)] | max }}"
state_class: measurement
icon: mdi:transmission-tower
unit_of_measurement: W
device_class: power
- name: Grid Power Export
# Min (0, Power Net) * -1
value_template: "{{ -1 * ([0, value_json[1].cumulative.currW | int(0)] | min) }}"
state_class: measurement
icon: mdi:transmission-tower
unit_of_measurement: W
device_class: power
- resource: https://envoy.local/ivp/meters/readings
headers:
Authorization: !secret enphase_api
verify_ssl: False
scan_interval: 900
sensor:
- name: "Energy Production"
value_template: "{{ (value_json[0].actEnergyDlvd / 1000 | float(0)) | round(2) }}"
device_class: energy
unit_of_measurement: kWh
state_class: total_increasing
icon: mdi:solar-power-variant
- name: "Grid Energy Import"
value_template: "{{ (value_json[1].actEnergyDlvd / 1000 | float(0)) | round(2) }}"
device_class: energy
unit_of_measurement: kWh
state_class: total_increasing
icon: mdi:transmission-tower-import
- name: "Grid Energy Export"
value_template: "{{ (value_json[1].actEnergyRcvd / 1000 | float(0)) | round(2) }}"
device_class: energy
unit_of_measurement: kWh
state_class: total_increasing
icon: mdi:transmission-tower-export
- name: Energy Consumption
# Consumption = Production + Import - Export
value_template: "{{ (value_json[0].actEnergyDlvd + value_json[1].actEnergyDlvd - value_json[1].actEnergyRcvd) / 1000 | float(0) | round(2) }}"
state_class: total_increasing
icon: mdi:home-lightning-bolt
unit_of_measurement: kWh
device_class: energy