Live display "PV surplus" or grid reference

Energy
1

Dear Community, I am new - but very enthusiastic and have tried a lot myself. I am looking for a live display “PV surplus” or grid reference.

I have a Shelly 1 pm on my PV inverter and a Shelly 3em on my house power supply.

How can I use live, or at least with an update rate of ca. 5 seconds, the pointer of a gauge diagram (I am open to alternatives or alternative displays!) for this? I would like to have, similar to the gauge display in the predefined energy dashboard, a chart where I can see live if I have surplus power or draw from the grid.

I thought I can simply form by means of a helper the function: “Current power grid draw (3em)” minus "Current power at inverter output (1pm) and then plot this in a gauge chart with a range of - 0.6 kW*(“left” in the gauge chart); 0 at the top of the chart (at 12 o’clock in fly language) and all positive differences on the right of the chart (from 12 o’clock).

I am failing, for example, to configure the gauge so that I can also plot a minus value.

Does anyone have any ideas? I would find that already great, if wife and children could see whether they should / can add something at the moment or not :wink:

Is that possibly possible with further statistic cards (mushroom cards (?)?

Best thanks to you,
I am curious if I was the first with this question :slight_smile:

*Yes, so little since we are talking about a German balcony power plant and not a roof full of PV panels. :smirk:

2

You can configure a gauge with negative values like this:

entity: sensor.stromzahler_sm_16_7_0
name: Verbrauch
unit: W
min: -6000
max: 6000
needle: true
severity:
  green: -6000
  yellow: -1500
  red: 0

But I think you need a helper entity in your configuration.yaml / sensor.yaml to do the math.
Example:

    sensors:

      solax_pv_power:
        friendly_name: "Solax Total PV Power"
        value_template: "{{ (states('sensor.qcells_swapw8csx5_pv1_power')|int + states('sensor.qcells_swapw8csx5_pv2_power')|int) }}"
        unit_of_measurement: "W"
        icon_template: "mdi:solar-power-variant"
        device_class: "power"

My solution looks like this in the end:

PNG-Bild 4
PNG-Bild 4777×946 63.9 KB

Verbrauch is consumption and green is the negative / grid return part. Yellow shows normal consumption and red is for high consumption like washing machine.
Btw the device signs are yellow if there is enough excessive solar or battery power to use them without grid.

Is this what you are looking for?

3

[quote=“Is this what you are looking for?”
[/quote]

(English version below!)

Hi Alexander,
vielen vielen Dank! Ja, genau das ist es, wonach ich suche! Ich freue mich, dass Du es so schön dargestellt hast und ich bin gespannt, ob ich das so nachbauen kann. Wie gesagt, ich bin noch Anfänger - so verzeih mir auch gleich die erste Frage:

You can configure a gauge with negative values like this:

Wo mache ich das? In der YAML?

Gelbe Symbole für “mögliche” nutzbare el. Verbraucher

Wo hast Du die Verbrauchswerte definiert und die “wenn-dann” Funktion bzw. die “bedingte Formatierung” in Farbe?

Sorry, bin Anfänger -aber dafür total begeistert :slight_smile:

Now in english, friends :wink:

Hi Alexander,
thank you very much! Yes, that’s exactly what I’m looking for! I’m glad you presented it so nicely and I’m curious if I can replicate it that way. As I said, I’m still a beginner - so forgive me for the first question:

You can configure a gauge with negative values like this:

Where do I do that? In the YAML?

Yellow symbols for “possible” usable el. consumers

Where did you define the consumption values and the “if-then” function or the “conditional formatting” in color?

Sorry, I’m a beginner - but totally enthusiastic :slight_smile:

4

The gauge code can be entered if you configure a dashboard with their, add a gauge and click on show code afterwards. This let you configure ui elements far beyond the ui possibilities.

My code for colouring the icons is still in a beta stage. I have to clean it up and maybe share the complete solution afterwards. For now I try to paste already working stuff here.
UI code using HACS custom button card:

type: custom:button-card
name: Waschmaschine
show_name: false
entity: sensor.washing_machine_aeg_auto
state:
  - value: 'off'
    icon: mdi:washing-machine
  - value: solar
    icon: mdi:washing-machine
    color: yellow

The sensor is configured like this:

        
      washing_machine_aeg_auto:
        unique_id: 8bbca4a8-150c-4749-95a5-e0789f69d308
        value_template: >-
    {% if states('sensor.solar_estimated_upcoming_energy') | float - states('input_number.solar_battery_backup_capacity') | float > 1.5%} 
                     solar
                     {% else %}
                     off 
                     {% endif %}

The formatting might need some work, because I removed some parts that are not fully working yet.

@ all
If you have better ideas how to do this please share them

@ Franz
You can send me a pm if you are living in the Ruhr area or if you want to discuss a few things in German.