Add "Solar Cost Saving" option to native Energy Dashboard

markpurcell · September 15, 2022, 5:41am

I have a bit of complexity as my electricity buy/ sell prices changes every five minute.

I calculate this as follows:

Benefit/ saving in $/hr.

    - name: Solar Benefit
      unit_of_measurement: $/h
      state: >
       {{states('sensor.apf_solar2house')|float(0) * states('sensor.amber_general_price')|float(0)/1000
       + states('sensor.apf_solar2batt')|float(0) * states('sensor.amber_feed_in_price')|float(0)/1000
       + states('sensor.apf_solar2grid')|float(0) * states('sensor.amber_feed_in_price')|float(0)/1000}}

    - name: Battery Benefit
      unit_of_measurement: $/h
      state: >
        {{states('sensor.apf_batt2grid')|float(0) * states('sensor.amber_feed_in_price')|float(0)/1000
        - states('sensor.apf_grid2batt')|float(0) * states('sensor.amber_general_price')|float(0)/1000
        - states('sensor.apf_solar2batt')|float(0) * states('sensor.amber_feed_in_price')|float(0)/1000
        + states('sensor.apf_batt2house')|float(0) * states('sensor.amber_general_price')|float(0)/1000}}

    - name: battery+solar benefit
      unit_of_measurement: $/h
      state: >
        {{states('sensor.battery_benefit')|float(0) + states('sensor.solar_benefit')|float(0)}}

Then a Riemann Sum integration to calculate total $ savings:

Then a utility meter to calcuclate savings as $/ day $/month…

Same for the battery savings $/ day

Then add them together to get a savings for battery+solar $/ month

Pretty up results with ApexCharts

TheRealSimonMlr · October 17, 2022, 1:59pm

Thank you for your work, markpurcell,
but I don’t understand your Configuration.
I mean, I get the idea, but I am wondering what value is in the sensor apf_solar2house: Current Watt, kWh in total? Why does it get divided by 1000?
And I was wondering, how is your Solar Benefit Integral configured (settings)?

Thanks for helping me out

markpurcell · October 18, 2022, 1:04am

apf_solar2house is in W, but amber_general_price is in $/ kWh so I need to divide by 1000 to get $/ Wh

TheRealSimonMlr · October 18, 2022, 6:13am

Ah okay, that makes sense. Thank you for the explanation .
So, for the Riemann-Summenintegral, it would be Left Riemann sum, no Metric Prefix and Time h (hours)?

markpurcell · October 18, 2022, 7:01am

Yes, but give it a go and see if the data is making sense for you.

marieper · December 5, 2022, 4:04pm

Isn’t this a duplicate of
Calculate/Display cost savings from self consumed solar energy?

However, I have voted for both of them…

Dave888 · February 6, 2023, 9:17am

Thanks for sharing this @markpurcell, I’ve been able to use this to help me put together some stats

znubbis · February 7, 2023, 11:42am

I think this is an excellent idea for the native energy dashboard to include.

vikonen · February 14, 2023, 4:50pm

Hi @markpurcell , thanks for the excellent guide!
I was able to follow it and create the sensors & helpers, but struggle with the Apex Chart.
I don’t suppose you’d be willing to share the code for that?

markpurcell · February 14, 2023, 8:26pm

I have extended the charts a little so here is the update:

FB_IMG_1676406289102

type: custom:apexcharts-card
graph_span: 11d
span:
  end: day
stacked: true
header:
  show: true
  title: Battery & Solar Savings
  show_states: true
  colorize_states: true
series:
  - entity: sensor.solar_savings_daily
    type: column
    group_by:
      func: max
      duration: 1d
    show:
      in_header: false
      legend_value: false
  - entity: sensor.battery_savings_daily
    type: column
    group_by:
      func: max
      duration: 1d
    show:
      in_header: false
      legend_value: false
  - entity: sensor.amber_vs_dmo_savings_daily
    type: column
    group_by:
      func: max
      duration: 1d
    show:
      in_header: false
      legend_value: false
  - entity: sensor.abs_savings_daily
    name: Amber+Battery+Solar Savings
    type: line
    stroke_width: 0
    unit: $
    show:
      extremas: true
      in_header: false
      legend_value: false
    group_by:
      func: max
      duration: 1d
  - entity: sensor.abs_savings_monthly
    unit: $
    name: month todate Amber+Battery+Solar
    show:
      legend_value: false
      in_chart: false
  - entity: sensor.battery_savings_monthly
    unit: $
    name: month todate Battery
    show:
      legend_value: false
      in_chart: false
  - entity: sensor.solar_savings_monthly
    unit: $
    name: month todate solar
    show:
      legend_value: false
      in_chart: false
yaxis:
  - id: first
    decimals: 1
    max: 50
    min: 0
    apex_config:
      tickAmount: 2
      logarithmic: false

severity8714 · April 3, 2023, 1:36pm

This looks exactly like what i’m looking for.

However, i live in Denmark, where the cost of electricty changes for every hour. How would this be done with that?
I have a two sensors, one that always is the current cost, and one that is the current sales price of electricty.

markpurcell · April 5, 2023, 10:47pm

My prices change every five minutes.

Were you able to follow my logic above?

severity8714 · April 7, 2023, 4:11pm

No sorry.
I’m very new to templates, which i’m guessing it is, your solution?

I have these sensors available

sensor.power_meter_consumption
sensor.inverter.daily_yield
sensor.power_meter_exported
sensor.energi_data_service - which is the current price of eletricity, updated every hour.
sensor.nettopower_salg - which is the current SALES price of eletricity, updated every hour.

Can your solution work with these sensors?
@markpurcell

severity8714 · April 12, 2023, 12:57pm

Where do you create this

- name: Solar Benefit
      unit_of_measurement: $/h
      state: >
       {{states('sensor.apf_solar2house')|float(0) * states('sensor.amber_general_price')|float(0)/1000
       + states('sensor.apf_solar2batt')|float(0) * states('sensor.amber_feed_in_price')|float(0)/1000
       + states('sensor.apf_solar2grid')|float(0) * states('sensor.amber_feed_in_price')|float(0)/1000}}

    - name: Battery Benefit
      unit_of_measurement: $/h
      state: >
        {{states('sensor.apf_batt2grid')|float(0) * states('sensor.amber_feed_in_price')|float(0)/1000
        - states('sensor.apf_grid2batt')|float(0) * states('sensor.amber_general_price')|float(0)/1000
        - states('sensor.apf_solar2batt')|float(0) * states('sensor.amber_feed_in_price')|float(0)/1000
        + states('sensor.apf_batt2house')|float(0) * states('sensor.amber_general_price')|float(0)/1000}}

    - name: battery+solar benefit
      unit_of_measurement: $/h
      state: >
        {{states('sensor.battery_benefit')|float(0) + states('sensor.solar_benefit')|float(0)}}

EDIT:
I got something working.
I did this


  - platform: template
    sensors:
      solceller_besparelse:
        friendly_name: "Solcelle besparelse"    
        unit_of_measurement: DKK/h
        value_template: >
          {{states('sensor.solcelle_til_eget_brug')|float(0) * states('sensor.energi_data_service')|float(0)/1000
          + states('sensor.solar_grid_production')|float(0) * states('sensor.nettopower_salg')|float(0)/1000}}
        unique_id: solcelle_besparelse

But this is just a running sensor, it doesn’t calculate my total savings, just what i’m saving right now, this second.

EDIT2:
Think i got it, i didn’t know that rieman and utilty meter was helpers xD Never used them
If it doesn’t work, ill get back to you, thanks for the help!

markpurcell · April 12, 2023, 8:26pm

Sounds like you should be able to get something working.

Can you post the graphs for each sensor?

Sounds like you want meter_consumption * energi

severity8714 · April 13, 2023, 7:18am

It looks like it’s working now.
There was just alot of new terms i didn’t know about, so i got confused.

I haven’t tried with the apex charts yet, but that’s just gui. As long as the data is there, i’ll manage

Haenn · April 24, 2023, 1:15pm

I am also missing exactly what OP writes. Sad that this is still missing after 15 months. Wondering if there could be any reason not to have it?

viezel · April 30, 2023, 7:04pm

@severity8714 dane here. Looking for the exact same solution.

What is your nettopower_salg sensor?

Did you just use the Energi data service for price or hour? What about taxes and the above 7000 kr rule for taxation?

Super helpful If you are able to post/explain your solution

severity8714 · May 2, 2023, 8:20am

I haven’t done anything about the 7000 kr tax rule, since i really don’t expect me to have that amount of payback for my exported power.

My Nettopower_salg sensor is a template i created, using the nordpool integration to calculate the price.
This shows the current sales price to Nettopower, and also the sales price for the next 48 hours, as long as the nordpool sensor also has the next 48 hours (which it usually has)

  - platform: template
    sensors:
      nettopower_salg:
        value_template: '{{ (states("sensor.nordpool_kwh_dk2_dkk_5_10_0")|float - 0.00375 - 0.000875 - 0.04)|round(3, floor) }}'
        friendly_name: "Nettopower salgspris"
        unit_of_measurement: "DKK/kWh"
        unique_id: nettopower_salg
        attribute_templates:
          today: >
            {% if state_attr('sensor.nordpool_kwh_dk2_dkk_5_10_0', 'today') %}
              {% set ns = namespace(prices=[]) %}
              {% for h in range(24) %}
                {% set ns.prices = ns.prices + [(float(state_attr('sensor.nordpool_kwh_dk2_dkk_5_10_0', 'today')[h]) - 0.00375 - 0.000875 - 0.04) | round(3, floor)] %}
              {% endfor %}
              {{ ns.prices }}
            {% endif %}
          tomorrow: >
            {% if state_attr('sensor.nordpool_kwh_dk2_dkk_5_10_0', 'tomorrow') %}
              {% set ns = namespace(prices=[]) %}
              {% for h in range(24) %}
                {% set ns.prices = ns.prices + [(float(state_attr('sensor.nordpool_kwh_dk2_dkk_5_10_0', 'tomorrow')[h]) - 0.00375 - 0.000875 - 0.04) | round(3, floor)] %}
              {% endfor %}
              {{ ns.prices }}
            {% endif %}

Branko · May 7, 2023, 9:20am

Hi @markpurcell

I am trying something like this to use for as long this is not a standard option in the energy dashboard.

I am not getting there completely, I think.
Can you share the settings for the Riemann Sum integration and the Utility meters please?