Od pewnego czasu korzystam z integracji do HA pobierającej ceny dynamiczne dzięki integracji PGE TGE

Dynamiczne ceny bazowe za energię czynną są takie same niezależnie od operatora czy sprzedawcy - są ustalone odgórnie więc to, że integracja pobiera dane ze strony PGE nie ma znaczenia. Działa dla każdego sprzedawcy i operatora.

Bez dodatkowej konfiguracji pobiera ceny dynamiczne i zgodnie z tutorialem na stronie możemy wygenerować wykresy ApexChart.

Niedawno pojawił się problem z pobieraniem danych więc szukając rozwiązania "przy okazji" rozbudowałem narzędzie o możliwość porównywania cen w kilku taryfach i z cenami dynamicznymi (gwoli ścisłości to nie mamy taryf dynamicznych - tylko ceny na energię czynną). No to tutorial od zera...

  1. Instalujemy integrację Settings --> Marketplace --> Add From Link (w prawym górnym rogu) i wklejamy

https://github.com/PiotrMachowski/Home-Assistant-custom-components-PGE-TGE 2. Ustawiamy ceny w zł/MWh (wszystkie ceny podajemy w tych jednostkach), bez szablonu i zatwierdzamy konfigurację. Bywa, że na tym etapie integracja nie jest w stanie połączyć się i zakończyć konfiguracji przez problem z certyfikatem SSL (SSLCertVerificationError).

  1. Żeby obejść problem z certyfikatem trzeba edytować plik config/custom_components/pge_tge/connector.py

szukamy linii:

response = requests.get(url, headers={"User-Agent": ""})

uzupełniamy by finalnie wyglądała tak:

response = requests.get(url, headers={"User-Agent": ""}, verify=False)

Restart HA. W razie potrzeby, jak wcześniej nie wygenerował konfigu, jeszcze raz konfigurujemy dodatek.

Narzędzi do edytowania plików jest kilka. Jak nie masz jeszcze żadnego, proponuję settings --> apps --> install app (prawy dolny róg) --> File Editor

UWAGA: Konfiguracja jest bardzo wrażliwa na formatowanie - zwiększenie lub zmniejszenie wcięcia jakiejś linijki powoduje błąd.

  1. Jak integracja działa, to można wygenerować AppexChart zgodnie z tutorialem na stronie integracji - w wybranym ekranie -->edit --> add card --> appexchart tile potem edit danego kafelka --> show code exitor (lewy dolny róg) i wklejamy: dla dzisiejszego wykresu:
type: custom:apexcharts-card
graph_span: 24h
span:
  start: day
header:
  show: true
  title: PGE TGE Fixing 1 Today [zł/MWh]
now:
  show: true
  label: Now
series:
  - entity: sensor.pge_tge_fixing_1_rate
    type: column
    name: Fixing 1
    float_precision: 2
    data_generator: |
      return entity.attributes.prices_today.map((val, index) => {
        return [new Date(val['time']), val['price']];
      });

Analogicznie dodajemy kafelek dla cen jutrzejszych wklejając kod:

type: custom:apexcharts-card
graph_span: 24h
span:
  start: day
  offset: +1d
header:
  show: true
  title: PGE TGE Fixing 1 Tomorrow [zł/MWh]
now:
  show: true
  label: Now
series:
  - entity: sensor.pge_tge_fixing_1_rate
    type: column
    name: Fixing 1
    float_precision: 2
    data_generator: |
      return entity.attributes.prices_tomorrow.map((val, index) => {
        return [new Date(val['time']), val['price']];
      });

Wykresy powinny się zaczytać. Na dzień jutrzejszy może jeszcze nie być dostępnych cen bo pojawiają się po południu. Są to surowe ceny dynamiczne, bez dodatkowych składników. Ale mamy pewność, że sama integracja działa, pobiera dane i możemy przejść dalej.

  1. Przechodzimy do konfiguracji dodatkowych składników oraz stref czasowych. Ja chcę porównywać taryfy G12, G12w i G12e w dwóch wersjach - z cenami dynamicznymi i z cenami statycznymi z taryf zatwierdzanych przez URE. Dodajemy helpery i wpisujemy im wartości netto w zł/MWh:

energy_pstryk_mgmt
energy_excise

g12_dist_peak
g12_dist_offpeak
g12w_dist_peak
g12w_dist_offpeak
g12e_dist_offpeak
g12e_dist_peak

g12_ure_energy_offpeak
g12_ure_energy_peak
g12e_ure_energy_offpeak
g12e_ure_energy_peak
g12w_ure_energy_offpeak
g12w_ure_energy_peak

Upewniamy się, że w id HA nie dodał nic poza input_number. do nazwy helpera.

  1. W przypadku taryf G12w i G12e można pójść na skróty i ustawić tanią strefę tylko w weekendy, albo uwzględniając również święta. Do uwzględnienia świąt potrzebujemy informacji o nich.

Wchodzimy więc w settings --> devices & servicess --> add integration (prawy dolny róg) i dodajemy integrację workaday, ustawiamy pl, i zatwierdzamy dwa razy i dajemy nazwę Dzień roboczy dziś i zostawiamy area puste i zatwierdzamy

Czynność powtarzamy dla "jutro":

settings --> devices & servicess --> add integration (prawy dolny róg) i dodajemy integrację workaday, ustawiamy pl, zatwierdzamy raz a na następnym ekranie ustawiamy offset na 1 i dajemy nazwę Dzień roboczy jutro, zostawiamy area puste i zatwierdzamy. Warto upewnić się, czy do ID sensorów HA nie dodał nic oprócz binary_sensor.

  1. Edytujemy plik /homeassistant/configuration.yaml dodając:
template:
  - sensor:
      # ========================================================================
      # 1. TARYFA G12 (DYNAMICZNA - TGE)
      # ========================================================================
      - name: "PGE Taryfa G12"
        unique_id: pge_taryfa_g12_full
        unit_of_measurement: "zł/MWh"
        state: >
          {% set base = states('sensor.pge_tge_fixing_1_rate') | float(0) %}
          {% set m = now().month %}
          {% set h = now().hour %}
          {% set is_summer = m in [4,5,6,7,8,9] %}
          {% set is_peak = ((6 <= h < 15) or (17 <= h < 22)) if is_summer else ((6 <= h < 13) or (15 <= h < 22)) %}
          {% set dist = states('input_number.g12_dist_peak' if is_peak else 'input_number.g12_dist_offpeak') | float(0) %}
          {% set mgmt = states('input_number.energy_pstryk_mgmt') | float(0) %}
          {% set excise = states('input_number.energy_excise') | float(0) %}
          {{ (((base + dist + mgmt+ excise) * 1.23) ) | round(2) }}
        attributes:
          prices_today: >
            {% set ns = namespace(items=[]) %}
            {% set peak_d = states('input_number.g12_dist_peak') | float(0) %}
            {% set off_d = states('input_number.g12_dist_offpeak') | float(0) %}
            {% set mgmt = states('input_number.energy_pstryk_mgmt') | float(0) %}
            {% set excise = states('input_number.energy_excise') | float(0) %}
            {% for item in state_attr('sensor.pge_tge_fixing_1_rate', 'prices_today') | default([]) %}
              {% set t = as_datetime(item.time) %}
              {% set is_summer = t.month in [4,5,6,7,8,9] %}
              {% set is_peak = ((6 <= t.hour < 15) or (17 <= t.hour < 22)) if is_summer else ((6 <= t.hour < 13) or (15 <= t.hour < 22)) %}
              {% set dist = peak_d if is_peak else off_d %}
              {% set final_p = (((item.price + dist + mgmt+ excise) * 1.23) ) | round(2) %}
              {% set ns.items = ns.items + [{'time': t.isoformat(), 'price': final_p}] %}
            {% endfor %}
            {{ ns.items }}
          prices_tomorrow: >
            {% set ns = namespace(items=[]) %}
            {% set peak_d = states('input_number.g12_dist_peak') | float(0) %}
            {% set off_d = states('input_number.g12_dist_offpeak') | float(0) %}
            {% set mgmt = states('input_number.energy_pstryk_mgmt') | float(0) %}
            {% set excise = states('input_number.energy_excise') | float(0) %}
            {% for item in state_attr('sensor.pge_tge_fixing_1_rate', 'prices_tomorrow') | default([]) %}
              {% set t = as_datetime(item.time) %}
              {% set is_summer = t.month in [4,5,6,7,8,9] %}
              {% set is_peak = ((6 <= t.hour < 15) or (17 <= t.hour < 22)) if is_summer else ((6 <= t.hour < 13) or (15 <= t.hour < 22)) %}
              {% set dist = peak_d if is_peak else off_d %}
              {% set final_p = (((item.price + dist + mgmt+ excise) * 1.23) ) | round(2) %}
              {% set ns.items = ns.items + [{'time': t.isoformat(), 'price': final_p}] %}
            {% endfor %}
            {{ ns.items }}
          prices: >
            {% set ns = namespace(items=[]) %}
            {% set peak_d = states('input_number.g12_dist_peak') | float(0) %}
            {% set off_d = states('input_number.g12_dist_offpeak') | float(0) %}
            {% set mgmt = states('input_number.energy_pstryk_mgmt') | float(0) %}
            {% set excise = states('input_number.energy_excise') | float(0) %}
            {% for item in state_attr('sensor.pge_tge_fixing_1_rate', 'prices') | default([]) %}
              {% set t = as_datetime(item.time) %}
              {% set is_summer = t.month in [4,5,6,7,8,9] %}
              {% set is_peak = ((6 <= t.hour < 15) or (17 <= t.hour < 22)) if is_summer else ((6 <= t.hour < 13) or (15 <= t.hour < 22)) %}
              {% set dist = peak_d if is_peak else off_d %}
              {% set final_p = (((item.price + dist + mgmt+ excise) * 1.23) ) | round(2) %}
              {% set ns.items = ns.items + [{'time': t.isoformat(), 'price': final_p}] %}
            {% endfor %}
            {{ ns.items }}

      # ========================================================================
      # 2. TARYFA G12W (DYNAMICZNA - TGE)
      # ========================================================================
      - name: "PGE Taryfa G12W"
        unique_id: pge_taryfa_g12w_full
        unit_of_measurement: "zł/MWh"
        state: >
          {% set base = states('sensor.pge_tge_fixing_1_rate') | float(0) %}
          {% set is_workday = is_state('binary_sensor.dzien_roboczy_dzis', 'on') %}
          {% set is_summer = now().month in [4,5,6,7,8,9] %}
          {% set is_peak = is_workday and (((6 <= now().hour < 15) or (17 <= now().hour < 22)) if is_summer else ((6 <= now().hour < 13) or (15 <= now().hour < 22))) %}
          {% set dist = states('input_number.g12w_dist_peak' if is_peak else 'input_number.g12w_dist_offpeak') | float(0) %}
          {% set mgmt = states('input_number.energy_pstryk_mgmt') | float(0) %}
          {% set excise = states('input_number.energy_excise') | float(0) %}
          {{ (((base + dist + mgmt+ excise) * 1.23) ) | round(2) }}
        attributes:
          prices_today: >
            {% set ns = namespace(items=[]) %}
            {% set peak_d = states('input_number.g12w_dist_peak') | float(0) %}
            {% set off_d = states('input_number.g12w_dist_offpeak') | float(0) %}
            {% set mgmt = states('input_number.energy_pstryk_mgmt') | float(0) %}
            {% set excise = states('input_number.energy_excise') | float(0) %}
            {% set is_workday = is_state('binary_sensor.dzien_roboczy_dzis', 'on') %}
            {% for item in state_attr('sensor.pge_tge_fixing_1_rate', 'prices_today') | default([]) %}
              {% set t = as_datetime(item.time) %}
              {% set is_summer = t.month in [4,5,6,7,8,9] %}
              {% set is_peak = is_workday and (((6 <= t.hour < 15) or (17 <= t.hour < 22)) if is_summer else ((6 <= t.hour < 13) or (15 <= t.hour < 22))) %}
              {% set dist = peak_d if is_peak else off_d %}
              {% set final_p = (((item.price + dist + mgmt+ excise) * 1.23) ) | round(2) %}
              {% set ns.items = ns.items + [{'time': t.isoformat(), 'price': final_p}] %}
            {% endfor %}
            {{ ns.items }}
          prices_tomorrow: >
            {% set ns = namespace(items=[]) %}
            {% set peak_d = states('input_number.g12w_dist_peak') | float(0) %}
            {% set off_d = states('input_number.g12w_dist_offpeak') | float(0) %}
            {% set mgmt = states('input_number.energy_pstryk_mgmt') | float(0) %}
            {% set excise = states('input_number.energy_excise') | float(0) %}
            {% set is_workday = is_state('binary_sensor.dzien_roboczy_jutro', 'on') %}
            {% for item in state_attr('sensor.pge_tge_fixing_1_rate', 'prices_tomorrow') | default([]) %}
              {% set t = as_datetime(item.time) %}
              {% set is_summer = t.month in [4,5,6,7,8,9] %}
              {% set is_peak = is_workday and (((6 <= t.hour < 15) or (17 <= t.hour < 22)) if is_summer else ((6 <= t.hour < 13) or (15 <= t.hour < 22))) %}
              {% set dist = peak_d if is_peak else off_d %}
              {% set final_p = (((item.price + dist + mgmt+ excise) * 1.23) ) | round(2) %}
              {% set ns.items = ns.items + [{'time': t.isoformat(), 'price': final_p}] %}
            {% endfor %}
            {{ ns.items }}
          prices: >
            {% set ns = namespace(items=[]) %}
            {% set peak_d = states('input_number.g12w_dist_peak') | float(0) %}
            {% set off_d = states('input_number.g12w_dist_offpeak') | float(0) %}
            {% set mgmt = states('input_number.energy_pstryk_mgmt') | float(0) %}
            {% set excise = states('input_number.energy_excise') | float(0) %}
            {% for item in state_attr('sensor.pge_tge_fixing_1_rate', 'prices') | default([]) %}
              {% set t = as_datetime(item.time) %}
              {% set is_workday = is_state('binary_sensor.dzien_roboczy_dzis' if t.date() == now().date() else 'binary_sensor.dzien_roboczy_jutro', 'on') %}
              {% set is_summer = t.month in [4,5,6,7,8,9] %}
              {% set is_peak = is_workday and (((6 <= t.hour < 15) or (17 <= t.hour < 22)) if is_summer else ((6 <= t.hour < 13) or (15 <= t.hour < 22))) %}
              {% set dist = peak_d if is_peak else off_d %}
              {% set final_p = (((item.price + dist + mgmt+ excise) * 1.23) ) | round(2) %}
              {% set ns.items = ns.items + [{'time': t.isoformat(), 'price': final_p}] %}
            {% endfor %}
            {{ ns.items }}

      # ========================================================================
      # 3. TARYFA G12e (DYNAMICZNA - TGE)
      # ========================================================================
      - name: "PGE Taryfa G12e"
        unique_id: pge_taryfa_g12e_full
        unit_of_measurement: "zł/MWh"
        state: >
          {% set base = states('sensor.pge_tge_fixing_1_rate') | float(0) %}
          {% set is_workday = is_state('binary_sensor.dzien_roboczy_dzis', 'on') %}
          {% set m = now().month %}
          {% set h = now().hour %}
          {% if not is_workday %}
            {% set is_peak = false %}
          {% elif m in [1,2,11,12] %}{% set is_peak = (6 <= h < 13) or (15 <= h < 22) %}
          {% elif m in [3,10] %}{% set is_peak = (6 <= h < 11) or (15 <= h < 22) %}
          {% elif m in [4,9] %}{% set is_peak = (6 <= h < 10) or (17 <= h < 22) %}
          {% else %}{% set is_peak = (6 <= h < 9) or (17 <= h < 22) %}{% endif %}
          {% set dist = states('input_number.g12e_dist_peak' if is_peak else 'input_number.g12e_dist_offpeak') | float(0) %}
          {% set mgmt = states('input_number.energy_pstryk_mgmt') | float(0) %}
          {% set excise = states('input_number.energy_excise') | float(0) %}
          {{ (((base + dist + mgmt+ excise) * 1.23) ) | round(2) }}
        attributes:
          prices_today: >
            {% set ns = namespace(items=[]) %}
            {% set peak_d = states('input_number.g12e_dist_peak') | float(0) %}
            {% set off_d = states('input_number.g12e_dist_offpeak') | float(0) %}
            {% set mgmt = states('input_number.energy_pstryk_mgmt') | float(0) %}
            {% set excise = states('input_number.energy_excise') | float(0) %}
            {% set is_workday = is_state('binary_sensor.dzien_roboczy_dzis', 'on') %}
            {% for item in state_attr('sensor.pge_tge_fixing_1_rate', 'prices_today') | default([]) %}
              {% set t = as_datetime(item.time) %}
              {% set m = t.month %}
              {% set h = t.hour %}
              {% if not is_workday %}
                {% set is_peak = false %}
              {% elif m in [1,2,11,12] %}{% set is_peak = (6 <= h < 13) or (15 <= h < 22) %}
              {% elif m in [3,10] %}{% set is_peak = (6 <= h < 11) or (15 <= h < 22) %}
              {% elif m in [4,9] %}{% set is_peak = (6 <= h < 10) or (17 <= h < 22) %}
              {% else %}{% set is_peak = (6 <= h < 9) or (17 <= h < 22) %}{% endif %}
              {% set dist = peak_d if is_peak else off_d %}
              {% set final_p = (((item.price + dist + mgmt+ excise) * 1.23) ) | round(2) %}
              {% set ns.items = ns.items + [{'time': t.isoformat(), 'price': final_p}] %}
            {% endfor %}
            {{ ns.items }}
          prices_tomorrow: >
            {% set ns = namespace(items=[]) %}
            {% set peak_d = states('input_number.g12e_dist_peak') | float(0) %}
            {% set off_d = states('input_number.g12e_dist_offpeak') | float(0) %}
            {% set mgmt = states('input_number.energy_pstryk_mgmt') | float(0) %}
            {% set excise = states('input_number.energy_excise') | float(0) %}
            {% set is_workday = is_state('binary_sensor.dzien_roboczy_jutro', 'on') %}
            {% for item in state_attr('sensor.pge_tge_fixing_1_rate', 'prices_tomorrow') | default([]) %}
              {% set t = as_datetime(item.time) %}
              {% set m = t.month %}
              {% set h = t.hour %}
              {% if not is_workday %}
                {% set is_peak = false %}
              {% elif m in [1,2,11,12] %}{% set is_peak = (6 <= h < 13) or (15 <= h < 22) %}
              {% elif m in [3,10] %}{% set is_peak = (6 <= h < 11) or (15 <= h < 22) %}
              {% elif m in [4,9] %}{% set is_peak = (6 <= h < 10) or (17 <= h < 22) %}
              {% else %}{% set is_peak = (6 <= h < 9) or (17 <= h < 22) %}{% endif %}
              {% set dist = peak_d if is_peak else off_d %}
              {% set final_p = (((item.price + dist + mgmt+ excise) * 1.23) ) | round(2) %}
              {% set ns.items = ns.items + [{'time': t.isoformat(), 'price': final_p}] %}
            {% endfor %}
            {{ ns.items }}
          prices: >
            {% set ns = namespace(items=[]) %}
            {% set peak_d = states('input_number.g12e_dist_peak') | float(0) %}
            {% set off_d = states('input_number.g12e_dist_offpeak') | float(0) %}
            {% set mgmt = states('input_number.energy_pstryk_mgmt') | float(0) %}
            {% set excise = states('input_number.energy_excise') | float(0) %}
            {% for item in state_attr('sensor.pge_tge_fixing_1_rate', 'prices') | default([]) %}
              {% set t = as_datetime(item.time) %}
              {% set is_workday = is_state('binary_sensor.dzien_roboczy_dzis' if t.date() == now().date() else 'binary_sensor.dzien_roboczy_jutro', 'on') %}
              {% set m = t.month %}
              {% set h = t.hour %}
              {% if not is_workday %}
                {% set is_peak = false %}
              {% elif m in [1,2,11,12] %}{% set is_peak = (6 <= h < 13) or (15 <= h < 22) %}
              {% elif m in [3,10] %}{% set is_peak = (6 <= h < 11) or (15 <= h < 22) %}
              {% elif m in [4,9] %}{% set is_peak = (6 <= h < 10) or (17 <= h < 22) %}
              {% else %}{% set is_peak = (6 <= h < 9) or (17 <= h < 22) %}{% endif %}
              {% set dist = peak_d if is_peak else off_d %}
              {% set final_p = (((item.price + dist + mgmt+ excise) * 1.23) ) | round(2) %}
              {% set ns.items = ns.items + [{'time': t.isoformat(), 'price': final_p}] %}
            {% endfor %}
            {{ ns.items }}

      # ========================================================================
      # 4. TARYFA G12 STATIC (URE)
      # ========================================================================
      - name: "PGE Taryfa G12 Static"
        unique_id: pge_taryfa_g12_static
        unit_of_measurement: "zł/MWh"
        state: >
          {% set energy_peak = states('input_number.g12_ure_energy_peak') | float(0) %}
          {% set energy_offpeak = states('input_number.g12_ure_energy_offpeak') | float(0) %}
          {% set m = now().month %}
          {% set h = now().hour %}
          {% set is_summer = m in [4,5,6,7,8,9] %}
          {% set is_peak = ((6 <= h < 15) or (17 <= h < 22)) if is_summer else ((6 <= h < 13) or (15 <= h < 22)) %}
          {% set base = energy_peak if is_peak else energy_offpeak %}
          {% set dist = states('input_number.g12_dist_peak' if is_peak else 'input_number.g12_dist_offpeak') | float(0) %}
          {% set excise = states('input_number.energy_excise') | float(0) %}
          {{ (((base + dist+ excise) * 1.23) ) | round(2) }}
        attributes:
          prices_today: >
            {% set ns = namespace(items=[]) %}
            {% set energy_peak = states('input_number.g12_ure_energy_peak') | float(0) %}
            {% set energy_offpeak = states('input_number.g12_ure_energy_offpeak') | float(0) %}
            {% set peak_d = states('input_number.g12_dist_peak') | float(0) %}
            {% set off_d = states('input_number.g12_dist_offpeak') | float(0) %}
            {% set excise = states('input_number.energy_excise') | float(0) %}
            {% for item in state_attr('sensor.pge_tge_fixing_1_rate', 'prices_today') | default([]) %}
              {% set t = as_datetime(item.time) %}
              {% set is_summer = t.month in [4,5,6,7,8,9] %}
              {% set is_peak = ((6 <= t.hour < 15) or (17 <= t.hour < 22)) if is_summer else ((6 <= t.hour < 13) or (15 <= t.hour < 22)) %}
              {% set base = energy_peak if is_peak else energy_offpeak %}
              {% set dist = peak_d if is_peak else off_d %}
              {% set final_p = (((base + dist+ excise) * 1.23) ) | round(2) %}
              {% set ns.items = ns.items + [{'time': t.isoformat(), 'price': final_p}] %}
            {% endfor %}
            {{ ns.items }}
          prices_tomorrow: >
            {% set ns = namespace(items=[]) %}
            {% set energy_peak = states('input_number.g12_ure_energy_peak') | float(0) %}
            {% set energy_offpeak = states('input_number.g12_ure_energy_offpeak') | float(0) %}
            {% set peak_d = states('input_number.g12_dist_peak') | float(0) %}
            {% set off_d = states('input_number.g12_dist_offpeak') | float(0) %}
            {% set excise = states('input_number.energy_excise') | float(0) %}
            {% for item in state_attr('sensor.pge_tge_fixing_1_rate', 'prices_tomorrow') | default([]) %}
              {% set t = as_datetime(item.time) %}
              {% set is_summer = t.month in [4,5,6,7,8,9] %}
              {% set is_peak = ((6 <= t.hour < 15) or (17 <= t.hour < 22)) if is_summer else ((6 <= t.hour < 13) or (15 <= t.hour < 22)) %}
              {% set base = energy_peak if is_peak else energy_offpeak %}
              {% set dist = peak_d if is_peak else off_d %}
              {% set final_p = (((base + dist+ excise) * 1.23) ) | round(2) %}
              {% set ns.items = ns.items + [{'time': t.isoformat(), 'price': final_p}] %}
            {% endfor %}
            {{ ns.items }}
          prices: >
            {% set ns = namespace(items=[]) %}
            {% set energy_peak = states('input_number.g12_ure_energy_peak') | float(0) %}
            {% set energy_offpeak = states('input_number.g12_ure_energy_offpeak') | float(0) %}
            {% set peak_d = states('input_number.g12_dist_peak') | float(0) %}
            {% set off_d = states('input_number.g12_dist_offpeak') | float(0) %}
            {% set excise = states('input_number.energy_excise') | float(0) %}
            {% for item in state_attr('sensor.pge_tge_fixing_1_rate', 'prices') | default([]) %}
              {% set t = as_datetime(item.time) %}
              {% set is_summer = t.month in [4,5,6,7,8,9] %}
              {% set is_peak = ((6 <= t.hour < 15) or (17 <= t.hour < 22)) if is_summer else ((6 <= t.hour < 13) or (15 <= t.hour < 22)) %}
              {% set base = energy_peak if is_peak else energy_offpeak %}
              {% set dist = peak_d if is_peak else off_d %}
              {% set final_p = (((base + dist+ excise) * 1.23) ) | round(2) %}
              {% set ns.items = ns.items + [{'time': t.isoformat(), 'price': final_p}] %}
            {% endfor %}
            {{ ns.items }}

      # ========================================================================
      # 5. TARYFA G12W STATIC (URE)
      # ========================================================================
      - name: "PGE Taryfa G12W Static"
        unique_id: pge_taryfa_g12w_static
        unit_of_measurement: "zł/MWh"
        state: >
          {% set energy_peak = states('input_number.g12w_ure_energy_peak') | float(0) %}
          {% set energy_offpeak = states('input_number.g12w_ure_energy_offpeak') | float(0) %}
          {% set is_workday = is_state('binary_sensor.dzien_roboczy_dzis', 'on') %}
          {% set is_summer = now().month in [4,5,6,7,8,9] %}
          {% set is_peak = is_workday and (((6 <= now().hour < 15) or (17 <= now().hour < 22)) if is_summer else ((6 <= now().hour < 13) or (15 <= now().hour < 22))) %}
          {% set base = energy_peak if is_peak else energy_offpeak %}
          {% set dist = states('input_number.g12w_dist_peak' if is_peak else 'input_number.g12w_dist_offpeak') | float(0) %}
          {% set excise = states('input_number.energy_excise') | float(0) %}
          {{ (((base + dist+ excise) * 1.23) ) | round(2) }}
        attributes:
          prices_today: >
            {% set ns = namespace(items=[]) %}
            {% set energy_peak = states('input_number.g12w_ure_energy_peak') | float(0) %}
            {% set energy_offpeak = states('input_number.g12w_ure_energy_offpeak') | float(0) %}
            {% set peak_d = states('input_number.g12w_dist_peak') | float(0) %}
            {% set off_d = states('input_number.g12w_dist_offpeak') | float(0) %}
            {% set excise = states('input_number.energy_excise') | float(0) %}
            {% set is_workday = is_state('binary_sensor.dzien_roboczy_dzis', 'on') %}
            {% for item in state_attr('sensor.pge_tge_fixing_1_rate', 'prices_today') | default([]) %}
              {% set t = as_datetime(item.time) %}
              {% set is_summer = t.month in [4,5,6,7,8,9] %}
              {% set is_peak = is_workday and (((6 <= t.hour < 15) or (17 <= t.hour < 22)) if is_summer else ((6 <= t.hour < 13) or (15 <= t.hour < 22))) %}
              {% set base = energy_peak if is_peak else energy_offpeak %}
              {% set dist = peak_d if is_peak else off_d %}
              {% set final_p = (((base + dist+ excise) * 1.23) ) | round(2) %}
              {% set ns.items = ns.items + [{'time': t.isoformat(), 'price': final_p}] %}
            {% endfor %}
            {{ ns.items }}
          prices_tomorrow: >
            {% set ns = namespace(items=[]) %}
            {% set energy_peak = states('input_number.g12w_ure_energy_peak') | float(0) %}
            {% set energy_offpeak = states('input_number.g12w_ure_energy_offpeak') | float(0) %}
            {% set peak_d = states('input_number.g12w_dist_peak') | float(0) %}
            {% set off_d = states('input_number.g12w_dist_offpeak') | float(0) %}
            {% set excise = states('input_number.energy_excise') | float(0) %}
            {% set is_workday = is_state('binary_sensor.dzien_roboczy_jutro', 'on') %}
            {% for item in state_attr('sensor.pge_tge_fixing_1_rate', 'prices_tomorrow') | default([]) %}
              {% set t = as_datetime(item.time) %}
              {% set is_summer = t.month in [4,5,6,7,8,9] %}
              {% set is_peak = is_workday and (((6 <= t.hour < 15) or (17 <= t.hour < 22)) if is_summer else ((6 <= t.hour < 13) or (15 <= t.hour < 22))) %}
              {% set base = energy_peak if is_peak else energy_offpeak %}
              {% set dist = peak_d if is_peak else off_d %}
              {% set final_p = (((base + dist+ excise) * 1.23) ) | round(2) %}
              {% set ns.items = ns.items + [{'time': t.isoformat(), 'price': final_p}] %}
            {% endfor %}
            {{ ns.items }}

      # ========================================================================
      # 6. TARYFA G12e STATIC (URE)
      # ========================================================================
      - name: "PGE Taryfa G12e Static"
        unique_id: pge_taryfa_g12e_static
        unit_of_measurement: "zł/MWh"
        state: >
          {% set energy_peak = states('input_number.g12e_ure_energy_peak') | float(0) %}
          {% set energy_offpeak = states('input_number.g12e_ure_energy_offpeak') | float(0) %}
          {% set is_workday = is_state('binary_sensor.dzien_roboczy_dzis', 'on') %}
          {% set m = now().month %}
          {% set h = now().hour %}
          {% if not is_workday %}
            {% set is_peak = false %}
          {% elif m in [1,2,11,12] %}{% set is_peak = (6 <= h < 13) or (15 <= h < 22) %}
          {% elif m in [3,10] %}{% set is_peak = (6 <= h < 11) or (15 <= h < 22) %}
          {% elif m in [4,9] %}{% set is_peak = (6 <= h < 10) or (17 <= h < 22) %}
          {% else %}{% set is_peak = (6 <= h < 9) or (17 <= h < 22) %}{% endif %}
          {% set base = energy_peak if is_peak else energy_offpeak %}
          {% set dist = states('input_number.g12e_dist_peak' if is_peak else 'input_number.g12e_dist_offpeak') | float(0) %}
          {% set excise = states('input_number.energy_excise') | float(0) %}
          {{ (((base + dist+ excise) * 1.23) ) | round(2) }}
        attributes:
          prices_today: >
            {% set ns = namespace(items=[]) %}
            {% set energy_peak = states('input_number.g12e_ure_energy_peak') | float(0) %}
            {% set energy_offpeak = states('input_number.g12e_ure_energy_offpeak') | float(0) %}
            {% set peak_d = states('input_number.g12e_dist_peak') | float(0) %}
            {% set off_d = states('input_number.g12e_dist_offpeak') | float(0) %}
            {% set excise = states('input_number.energy_excise') | float(0) %}
            {% set is_workday = is_state('binary_sensor.dzien_roboczy_dzis', 'on') %}
            {% for item in state_attr('sensor.pge_tge_fixing_1_rate', 'prices_today') | default([]) %}
              {% set t = as_datetime(item.time) %}
              {% set m = t.month %}
              {% set h = t.hour %}
              {% if not is_workday %}
                {% set is_peak = false %}
              {% elif m in [1,2,11,12] %}{% set is_peak = (6 <= h < 13) or (15 <= h < 22) %}
              {% elif m in [3,10] %}{% set is_peak = (6 <= h < 11) or (15 <= h < 22) %}
              {% elif m in [4,9] %}{% set is_peak = (6 <= h < 10) or (17 <= h < 22) %}
              {% else %}{% set is_peak = (6 <= h < 9) or (17 <= h < 22) %}{% endif %}
              {% set base = energy_peak if is_peak else energy_offpeak %}
              {% set dist = peak_d if is_peak else off_d %}
              {% set final_p = (((base + dist+ excise) * 1.23) ) | round(2) %}
              {% set ns.items = ns.items + [{'time': t.isoformat(), 'price': final_p}] %}
            {% endfor %}
            {{ ns.items }}
          prices_tomorrow: >
            {% set ns = namespace(items=[]) %}
            {% set energy_peak = states('input_number.g12e_ure_energy_peak') | float(0) %}
            {% set energy_offpeak = states('input_number.g12e_ure_energy_offpeak') | float(0) %}
            {% set peak_d = states('input_number.g12e_dist_peak') | float(0) %}
            {% set off_d = states('input_number.g12e_dist_offpeak') | float(0) %}
            {% set excise = states('input_number.energy_excise') | float(0) %}
            {% set is_workday = is_state('binary_sensor.dzien_roboczy_jutro', 'on') %}
            {% for item in state_attr('sensor.pge_tge_fixing_1_rate', 'prices_tomorrow') | default([]) %}
              {% set t = as_datetime(item.time) %}
              {% set m = t.month %}
              {% set h = t.hour %}
              {% if not is_workday %}
                {% set is_peak = false %}
              {% elif m in [1,2,11,12] %}{% set is_peak = (6 <= h < 13) or (15 <= h < 22) %}
              {% elif m in [3,10] %}{% set is_peak = (6 <= h < 11) or (15 <= h < 22) %}
              {% elif m in [4,9] %}{% set is_peak = (6 <= h < 10) or (17 <= h < 22) %}
              {% else %}{% set is_peak = (6 <= h < 9) or (17 <= h < 22) %}{% endif %}
              {% set base = energy_peak if is_peak else energy_offpeak %}
              {% set dist = peak_d if is_peak else off_d %}
              {% set final_p = (((base + dist+ excise) * 1.23) ) | round(2) %}
              {% set ns.items = ns.items + [{'time': t.isoformat(), 'price': final_p}] %}
            {% endfor %}
            {{ ns.items }}

Jeżeli mamy już sekcję "template" to skopiuj bez pierwszej linii (nie może być 2x "template") i doklejamy na końcu sekcji.

  1. Idziemy do karty, gdzie chcemy wykres. Ponieważ na jednym wykresie mamy 6 taryf polecam dać na całą kartę Panel (single card), dodajemy appexcharts-card --> tile --> edit --> show code editor i zastępujemy domyślną zawartość kodem:
type: custom:apexcharts-card
header:
  show: true
  title: Ceny Dynamiczne (TGE) vs Statyczne URE w PGE [zł/MWh]
graph_span: 48h
span:
  start: day
now:
  show: true
  label: Teraz
yaxis:
  - decimals: 0
    apex_config:
      forceNiceScale: true
series:
  - entity: sensor.pge_taryfa_g12
    name: G12 (Dynamiczna)
    type: line
    stroke_width: 2
    data_generator: >
      let today = entity.attributes.prices_today || [];

      let tomorrow = entity.attributes.prices_tomorrow || [];

      return [...today, ...tomorrow].map((val) => [new Date(val.time),
      val.price]);
  - entity: sensor.pge_taryfa_g12w
    name: G12W (Dynamiczna)
    type: line
    stroke_width: 2
    data_generator: >
      let today = entity.attributes.prices_today || [];

      let tomorrow = entity.attributes.prices_tomorrow || [];

      return [...today, ...tomorrow].map((val) => [new Date(val.time),
      val.price]);
  - entity: sensor.pge_taryfa_g12e
    name: G12e (Dynamiczna)
    type: line
    stroke_width: 2
    data_generator: >
      let today = entity.attributes.prices_today || [];

      let tomorrow = entity.attributes.prices_tomorrow || [];

      return [...today, ...tomorrow].map((val) => [new Date(val.time),
      val.price]);
  - entity: sensor.pge_taryfa_g12_static
    name: G12 (Statyczna URE)
    type: line
    stroke_width: 2
    data_generator: >
      let today = entity.attributes.prices_today || [];

      let tomorrow = entity.attributes.prices_tomorrow || [];

      return [...today, ...tomorrow].map((val) => [new Date(val.time),
      val.price]);
  - entity: sensor.pge_taryfa_g12w_static
    name: G12W (Statyczna URE)
    type: line
    stroke_width: 2
    data_generator: >
      let today = entity.attributes.prices_today || [];

      let tomorrow = entity.attributes.prices_tomorrow || [];

      return [...today, ...tomorrow].map((val) => [new Date(val.time),
      val.price]);
  - entity: sensor.pge_taryfa_g12e_static
    name: G12e (Statyczna URE)
    type: line
    stroke_width: 2
    data_generator: >
      let today = entity.attributes.prices_today || [];

      let tomorrow = entity.attributes.prices_tomorrow || [];

      return [...today, ...tomorrow].map((val) => [new Date(val.time),
      val.price]);

To wszystko. Konfiguracja powinna rozpoznawać dni dodatkowo wolne od pracy, przestawiać godziny taniego okienka (w PGE przez część roku jest 13-15 a przez część 15-17). Powinna też automatycznie poszerzać dzienne okienko w G12e (jest zmienne w różnych miesiącach - minimum 2h w ciągu dnia). Mamy tu koszt brutto wszystkich składników. Gdy zmienią się ceny dystrybucji czy statyczne energii - trzeba edytować helpery.

W chwili, gdy to piszę (2026-11-16) wychodzi mi, że g12e w cenach statycznych jest zarzynana przez opłatę stałą i wyższą cenę energii w drogiej strefie. Ceny dynamiczne z kolei są zarzynane wysokimi cenami w szczycie popołudniowym - zwłaszcza (co może dziwić) w okresie dużej produkcji PV. Dzięki wykresom każdy może sobie wygodnie wyrobić własną opinię obserwując ceny w poszczególne dni i odnosząc do własnego zużycia.