Add "Solar Cost Saving" option to native Energy Dashboard

[nelgmo]

Similar as the existing compensation (money) tracker for Return to Grid I would like to be able to see how much my investment in Solar panels has payed off over time. Monetarily speaking. Return On Investment.

“How much would I have payed for my consumed solar energy if I instead needed to buy it from the grid”. “Will it yield as much money as the sales guy promised me in their proposal.” “You will get your money back in x years”.

I think it could work almost exactly as the Return to Grid functionality. I already have a sensor that calculates this based on my current grid price. But it would be nice to get this into the Energy Dashboard accumulated over time.

Sure it feels good to save our climate and it would feel even better to know when my investment has payed of financially. Speaking like a true capitalist

[Mr-Alicates]

@nelgmo

Sure it feels good to save our climate and it would feel even better to know when my investment has payed of financially. Speaking like a true capitalist

I’m specifically looking into calculating this. I have all the data available but I don’t know (yet) how to put all the numbers together in HA

[ankerstal (Peter Ankerstål)]

I would also like this feature. Just add a tariff for “self consumed solar” (or take it from the comsumption tariff)

[markpurcell]

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 (Simon Müller)]

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]

@TheRealSimonMlr

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?

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

[TheRealSimonMlr (Simon Müller)]

@markpurcell

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

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]

@TheRealSimonMlr

Riemann-Summenintegral, it would be Left Riemann sum, no Metric Prefix and Time h (hours)?

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

[marieper (Per Lundborg)]

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

However, I have voted for both of them…

[Dave888]

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

[znubbis]

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

[vikonen]

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]

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

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]

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]

My prices change every five minutes.

Were you able to follow my logic above?

Add "Solar Cost Saving" option to native Energy Dashboard

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. [image] - 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('senso…

[severity8714]

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]

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]

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]

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]

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?