Solar, Battery, Grid and Consumption

[kloppy]

Inspired by this and this idea, I modified the former one to:

• look similar to the style of the default history and statistics plots in dark mode
• use the colors from the energy dashboard
• show all directions of power flow, including: solar to grid, grid to battery, battery to grid

The upper plot uses 5 minute average data over a day, the lower one hourly data over a week. The code for the template sensors is below as well.

upper plot

type: custom:plotly-graph
entities:
  - entity: sensor.power_flow_solar_to_consumption
    name: solar consumption
    type: scatter
    mode: lines
    statistic: mean
    period: 5minute
    fillcolor: rgba(255, 152, 0,0.6)
    stackgroup: a
    line:
      shape: linear
      width: 0
  - entity: sensor.power_flow_marstek_to_consumption
    name: battery consumption
    type: scatter
    mode: lines
    stackgroup: a
    statistic: mean
    period: 5minute
    fillcolor: rgba(77, 182, 172,0.6)
    line:
      shape: linear
      width: 0
  - entity: sensor.power_flow_grid_to_consumption
    name: grid consumption
    type: scatter
    mode: lines
    statistic: mean
    period: 5minute
    fillcolor: rgba(64, 128, 171,0.6)
    stackgroup: a
    line:
      shape: linear
      width: 0
  - entity: sensor.power_flow_solar_to_marstek
    name: charge from solar
    type: scatter
    mode: lines
    statistic: mean
    period: 5minute
    fillcolor: rgba(240, 98, 146,0.6)
    stackgroup: a
    line:
      shape: linear
      width: 0
  - entity: sensor.power_flow_solar_to_grid
    name: excess solar
    type: scatter
    mode: lines
    statistic: mean
    period: 5minute
    fillcolor: rgba(162, 128, 219,0.6)
    stackgroup: a
    line:
      shape: linear
      width: 0
  - entity: sensor.power_flow_marstek_to_grid
    name: excess battery
    type: scatter
    mode: lines
    statistic: mean
    period: 5minute
    fillcolor: rgba(196, 175, 233,0.6)
    stackgroup: a
    line:
      shape: linear
      width: 0
  - entity: sensor.power_flow_grid_to_marstek
    name: charge from grid
    type: scatter
    mode: lines
    statistic: mean
    period: 5minute
    fillcolor: rgba(246, 162, 190,0.6)
    stackgroup: a
    line:
      shape: linear
      width: 0
  - entity: sensor.total_power_without_solar
    name: home consumption
    type: scatter
    mode: lines
    statistic: mean
    period: 5minute
    line:
      shape: linear
      width: 1
      color: "#FFF"
  - entity: sensor.solar_power
    name: solar generation
    type: scatter
    mode: lines
    statistic: mean
    period: 5minute
    line:
      shape: linear
      width: 1
      color: "#FF9800"
  - entity: sensor.marstek_1_battery_soc
    name: battery SoC
    type: scatter
    mode: lines
    yaxis: y2
    line:
      shape: spline
      width: 1
      color: "#44A047"
  - entity: sensor.epex_spot_data_quantile
    filters:
      - multiply: 100
    name: energy price
    type: scatter
    mode: lines
    yaxis: y2
    line:
      shape: spline
      width: 0.5
      color: "#88f"
layout:
  paper_bgcolor: "#1B1B1B"
  height: 400
  margin:
    l: 40
    r: 40
    t: 0
  showlegend: false
  xaxis:
    gridcolor: "#313131"
    tickfont:
      size: 10
      color: "#E1E1E1"
    rangeselector:
      "y": 1.05
      buttons:
        - count: 3
          step: hour
        - count: 6
          step: hour
        - count: 12
          step: hour
        - count: 1
          step: day
        - count: 2
          step: day
  yaxis:
    showgrid: true
    autorangeoptions:
      minallowed: 0
    gridcolor: "#313131"
    title:
      visible: false
    tickfont:
      size: 10
      color: "#E1E1E1"
    side: left
  yaxis2:
    showgrid: false
    range:
      - 0
      - 101
    linecolor: "#313131"
    title:
      visible: false
    tickfont:
      size: 10
      color: "#E1E1E1"
    side: right
hours_to_show: 24
refresh_interval: 30
config:
  scrollZoom: false
grid_options:
  columns: full

lower plot

type: custom:plotly-graph
entities:
  - entity: sensor.power_flow_solar_to_consumption
    name: solar consumption
    type: scatter
    mode: lines
    statistic: mean
    period: hour
    fillcolor: rgba(255, 152, 0,0.6)
    stackgroup: a
    line:
      shape: linear
      width: 0
  - entity: sensor.power_flow_marstek_to_consumption
    name: battery consumption
    type: scatter
    mode: lines
    stackgroup: a
    statistic: mean
    period: hour
    fillcolor: rgba(77, 182, 172,0.6)
    line:
      shape: linear
      width: 0
  - entity: sensor.power_flow_grid_to_consumption
    name: grid consumption
    type: scatter
    mode: lines
    statistic: mean
    period: hour
    fillcolor: rgba(64, 128, 171,0.6)
    stackgroup: a
    line:
      shape: linear
      width: 0
  - entity: sensor.power_flow_solar_to_marstek
    name: charge from solar
    type: scatter
    mode: lines
    statistic: mean
    period: hour
    fillcolor: rgba(240, 98, 146,0.6)
    stackgroup: a
    line:
      shape: linear
      width: 0
  - entity: sensor.power_flow_solar_to_grid
    name: excess solar
    type: scatter
    mode: lines
    statistic: mean
    period: hour
    fillcolor: rgba(162, 128, 219,0.6)
    stackgroup: a
    line:
      shape: linear
      width: 0
  - entity: sensor.power_flow_marstek_to_grid
    name: excess battery
    type: scatter
    mode: lines
    statistic: mean
    period: hour
    fillcolor: rgba(196, 175, 233,0.6)
    stackgroup: a
    line:
      shape: linear
      width: 0
  - entity: sensor.power_flow_grid_to_marstek
    name: charge from grid
    type: scatter
    mode: lines
    statistic: mean
    period: hour
    fillcolor: rgba(246, 162, 190,0.6)
    stackgroup: a
    line:
      shape: linear
      width: 0
  - entity: sensor.total_power_without_solar
    name: home consumption
    type: scatter
    mode: lines
    statistic: mean
    period: hour
    line:
      shape: linear
      width: 1
      color: "#FFF"
  - entity: sensor.solar_power
    name: solar generation
    type: scatter
    mode: lines
    statistic: mean
    period: hour
    line:
      shape: linear
      width: 1
      color: "#FF9800"
  - entity: sensor.marstek_1_battery_soc
    name: battery SoC
    type: scatter
    mode: lines
    statistic: mean
    period: hour
    yaxis: y2
    line:
      shape: spline
      width: 1
      color: "#44A047"
  - entity: sensor.epex_spot_data_quantile
    filters:
      - multiply: 100
    name: energy price
    type: scatter
    mode: lines
    statistic: mean
    period: hour
    yaxis: y2
    visible: legendonly
    line:
      shape: spline
      width: 0.5
      color: "#88f"
layout:
  paper_bgcolor: "#1B1B1B"
  height: 400
  margin:
    l: 40
    r: 40
  xaxis:
    gridcolor: "#313131"
    tickfont:
      size: 10
      color: "#E1E1E1"
  yaxis:
    showgrid: true
    autorangeoptions:
      minallowed: 0
    gridcolor: "#313131"
    title:
      visible: false
    tickfont:
      size: 10
      color: "#E1E1E1"
    side: left
  yaxis2:
    showgrid: false
    range:
      - 0
      - 100
    linecolor: "#313131"
    title:
      visible: false
    tickfont:
      size: 10
      color: "#E1E1E1"
    side: right
hours_to_show: 168
refresh_interval: 600
config:
  scrollZoom: false
grid_options:
  columns: full

power flow sensor
This template sensor generates the data for the 7 individual energy flow sensors, it should be excluded from recorder because it generates a lot of states.

{% set nope = -1000000 -%}
{% macro clipf(value, minv, maxv, returns) -%}
{% do returns(([minv, value, maxv] | sort)[1]) -%}
{% endmacro -%}
{% set clip = clipf | as_function -%}
{% macro checkf(value1, value2 = 1, value3 = 1, returns=false) -%}
{% do returns(value1|float(nope) > 0.5*nope and value2|float(nope) > 0.5*nope and value3|float(nope) > 0.5*nope) -%}
{% endmacro -%}
{% set check = checkf | as_function -%}
{# inputs -#}
{% set solar = states('sensor.solar_power') | float(nope) -%}
{% set marstek = states('sensor.marstek_1_ac_power') | float(nope) -%}
{% set marstekcharge = clip(-marstek, 0, -nope) -%}
{% set grid = states('sensor.total_power') | float(nope) -%}
{% set consumption = check(grid, solar, marstek) | iif(grid + solar + marstek, nope) -%}
{# calculations -#}
{% if consumption >= 0.0 -%}
{% set solar2consumption = check(solar, consumption) | iif(clip(solar, 0, consumption), nope) -%}
{% set solar2marstek = check(solar, solar2consumption, marstek) | iif(clip(solar - solar2consumption, 0, marstekcharge), nope) -%}
{% set solar2grid = check(solar, solar2consumption, solar2marstek) | iif((solar - solar2consumption - solar2marstek), nope) -%}
{% set marstek2consumption = check(marstek, consumption, solar2consumption) | iif(clip(marstek, 0, consumption - solar2consumption), nope) -%}
{% set marstek2grid = check(marstek, solar2marstek, marstek2consumption) | iif(clip(marstek + solar2marstek - marstek2consumption, 0, -nope), nope) -%}
{% set grid2consumption = check(consumption, solar2consumption, marstek2consumption) | iif(consumption - solar2consumption - marstek2consumption, nope) -%}
{% set grid2marstek = check(grid, grid2consumption) | iif(clip(grid - grid2consumption, 0, -nope), nope) -%}
{# "solar": solar, "marstek": marstek, "grid": grid, -#}
{{ { 
"solar2consumption": solar2consumption,
"solar2marstek": solar2marstek,
"solar2grid": solar2grid,
"marstek2consumption": marstek2consumption,
"marstek2grid": marstek2grid,
"grid2consumption": grid2consumption,
"grid2marstek": grid2marstek } | to_json -}}
{% else -%}None{% endif -%}

single sensors
There are 7 individual template sensors for each kind of power flow, e.g. for solar to battery ("marstek"):

{% set key = 'solar2marstek' -%}
{% set values = states('sensor.power_flow') | from_json(false) -%}
{% if values is mapping and key in values -%}
{% set val = values[key] | float(-1000000) %}
{{ iif(val > -500000, val, 'None') -}}
{% else -%}None{%- endif -%}