3ERL Zero-Inject Instructions and Daily PRE+ Estimate

[mathieucarbou]

Hi,

Thanks a lot for this awesome integration I am using since a year now (switched from apexcharts-card without regret!).

I wanted to to share 2 of the graphs I did that deserve sharing I think. They are used to track electricity prices in France with regard to exported solar energy.

=> https://gist.github.com/mathieucarbou/8d83d25247821e85a693dea61fe4f0d2

Features used:

• Greyed area to track some states (when we have to do some zero-export)
• custom legend labels with last values
• computed metric line (sum of all quarter prices by kWh exported since the start of the graph to
• separating negative and positive prices in 2 graphs (blue and red) with filled area
• shifting and grouping data points per quarter of hour to align the data
• some buttons to control the graph interval

First one at the top:

type: custom:plotly-graph
title: Prices
refresh_interval: 60s
hours_to_show: 1d
defaults:
  entity:
    connectgaps: true
layout:
  height: 440
  yaxis9:
    visible: false
    fixedrange: true
  xaxis:
    rangeselector:
      "y": 1.4
      bgcolor: grey
      buttons:
        - count: 6
          step: hour
        - count: 12
          step: hour
        - count: 1
          step: day
        - count: 2
          step: day
        - count: 7
          step: day
        - count: 30
          step: day
        - count: 60
          step: day
        - count: 90
          step: day
entities:
  - entity: sensor.electricite_prix_de_reglement_des_ecarts_positifs
    name: |
      $ex "Positive PRE+ (" + (ys[ys.length - 1] * 0.1).toFixed(2) + " c€/kWh)"
    unit_of_measurement: c€/kWh
    show_value: false
    time_offset: "-18m"
    filters:
      - map_y_numbers: "y >= 0 ? y * 0.1 : 0"
    line:
      color: deepskyblue
    fill: tozeroy
  - entity: sensor.electricite_prix_de_reglement_des_ecarts_positifs
    name: |
      $ex "Negative PRE+ (" + (ys[ys.length - 1] * 0.1).toFixed(2) + " c€/kWh)"
    unit_of_measurement: c€/kWh
    show_value: false
    time_offset: "-18m"
    filters:
      - map_y_numbers: "y < 0 ? y * 0.1 : 0"
    line:
      color: red
    fill: tozeroy
  - entity: sensor.electricite_prd3_factor
    time_offset: "-18m"
    name: >
      $ex "PRD3 Profile (" + (meta.date ? meta.date.substring(0, 10) : "????") +
      ")"
    line:
      color: orange
  - entity: sensor.electricite_prep_daily_estimation
    name: >
      $ex "PRE+ Daily Est (" + (ys[ys.length - 1] * 0.1).toFixed(2) + " c€/kWh)"
      + (ys[ys.length - 1] < 0 ? ' ⚠️' : '')
    unit_of_measurement: c€/kWh
    show_value: false
    time_offset: "-18m"
    filters:
      - multiply: 0.1
    line:
      color: lightgreen
      width: 2
  - entity: binary_sensor.3erl_bridage_demande
    name: |
      $ex "Zero-Inject (3ERL API)" + (ys[ys.length - 1] == 'on' ? ' ⚠️' : '')
    showlegend: true
    yaxis: y9
    filters:
      - map_y: "y === 'on' ? 1 : 0"
    fill: tozeroy
    line:
      color: rgba(100,100,100,0.1)
      shape: hv
      connectgaps: false
      width: 0

At the bottom:

type: custom:plotly-graph
title: Prices
refresh_interval: 60s
hours_to_show: 1d
defaults:
  entity:
    connectgaps: true
layout:
  height: 440
  yaxis9:
    visible: false
    fixedrange: true
  xaxis:
    rangeselector:
      "y": 1.5
      bgcolor: grey
      buttons:
        - count: 6
          step: hour
        - count: 12
          step: hour
        - count: 1
          step: day
        - count: 2
          step: day
        - count: 7
          step: day
        - count: 30
          step: day
        - count: 60
          step: day
        - count: 90
          step: day
entities:
  - entity: sensor.electricite_prix_de_reglement_des_ecarts_positifs
    name: |
      $ex "Positive PRE+ (" + (ys[ys.length - 1] * 0.1).toFixed(2) + " c€/kWh)"
    show_value: false
    unit_of_measurement: c€/kWh
    time_offset: "-20m"
    line:
      color: deepskyblue
    fill: tozeroy
    filters:
      - map_y_numbers: "y >= 0 ? y * 0.1 : 0"
      - resample: 15m
      - store_var: prep_pos
  - entity: sensor.electricite_prix_de_reglement_des_ecarts_positifs
    name: |
      $ex "Negative PRE+ (" + (ys[ys.length - 1] * 0.1).toFixed(2) + " c€/kWh)"
    show_value: false
    unit_of_measurement: c€/kWh
    time_offset: "-20m"
    line:
      color: red
    fill: tozeroy
    filters:
      - map_y_numbers: "y < 0 ? y * 0.1 : 0"
      - resample: 15m
      - store_var: prep_neg
  - entity: input_number.electricite_acc_sell_price
    name: |
      $ex "ACC Sell Price (" + (ys[ys.length - 1] * 1.0).toFixed(2) + " c€/kWh)"
    show_value: false
    unit_of_measurement: c€/kWh
    line:
      color: yellow
    time_offset: "-20m"
    filters:
      - resample: 15m
      - store_var: sell_price
  - entity: sensor.linky_energie_injectee
    yaxis: y2
    name: |
      $ex "Exported Energy (kWh)"
    unit_of_measurement: kWh
    show_value: false
    time_offset: "-20m"
    type: bar
    opacity: 0.3
    marker:
      color: orange
    statistic: sum
    period: 5minute
    filters:
      - resample: 15m
      - delta
      - store_var: quarter_hour_energy
  - entity: ""
    name: |
      $fn (_) => { 
        var income = ([...Array(_.vars.quarter_hour_energy.ys.length).keys()].map(i => _.vars.quarter_hour_energy.ys[i] * (-1 + (_.vars.prep_pos.ys[i+1] || 0) + (_.vars.prep_neg.ys[i+1] || 0))).reduce((acc, num) => acc + num, 0)).toFixed(2)
        return "Income (" + income + "c€)" + (income < 0 ? ' ⚠️' : '')
      }
    unit_of_measurement: c€
    time_offset: "-20m"
    yaxis: y1
    show_value: false
    type: line
    line:
      color: lightgreen
      width: 2
    filters:
      - load_var: prep_pos
      - load_var: prep_neg
      - load_var: quarter_hour_energy
      - map_y: >-
          [...Array(i).keys()].map(i => vars.quarter_hour_energy.ys[i] * (-1 +
          (vars.prep_pos.ys[i+1] || 0) + (vars.prep_neg.ys[i+1] ||
          0))).reduce((acc, num) => acc + num, 0)
  - entity: binary_sensor.3erl_bridage_cdc_demande
    name: |
      $ex "Zero-Inject (3ERL API)" + (ys[ys.length - 1] == 'on' ? ' ⚠️' : '')
    showlegend: true
    yaxis: y9
    filters:
      - map_y: "y === 'on' ? 1 : 0"
    fill: tozeroy
    line:
      color: rgba(100,100,100,0.1)
      shape: hv
      connectgaps: false
      width: 0