Price template: Tauron G12W + Tauron G12W

[KrzysztofHajdamowicz]

Your electricity invoice contains two things: Price of electricity and price of distribution.
One is money you left in power plant for making energy, other one you left to your grid operator for connecting power plant to your utility meter.

To fully maximize price reduction, it's wise to combine dynamic prices with distribution tariff that are cheaper near peak renewables generation, let's say it's G12W.

I'm showing you template to be used as Fixing 1 price to factor prices of G12W distribution tariff into resulting price.
You need to prepare two input_number entities that return price gr/kWh for delivering electrons to your home.

1. Create input_numbers for peak and off-peak distribution rates (For example, Tauron in G12W uses: 0,36898 PLN/kWh as peak and 0,09028 PLN/kWh off-peak during 2024H2)
2. Create input_number for comission that Tauron takes for access for dynamic tariffs (~0,11 PLN/kWh if I remember correctly)
3. Use this price modifyer template:

{% set s = {
    "exchange_rate": states('sensor.eur_to_pln_exchange_rate')|float,
    "VAT": 1.23,
    "peak_distribution_rate": states('input_number.dystrybucja_g12w_szczyt')|float,
    "offpeak_distribution_rate": states('input_number.dystrybucja_g12w_pozaszczyt')|float,
    "market_access_fee": states('input_number.tauron_taryfa_dynamiczna_prowizja')|float
} %}

{# Define peak periods for G12W tariff as a list of tuples (start_hour, stop_hour) #}
{% set peaks = [(6, 13), (15, 22)] %}

{# Determine if it's a weekend (offpeak all day) #}
{% set is_weekend = now().weekday() >= 5 %}

{# Check if the current time falls within any peak period #}
{% set is_peak = False %}
{% if not is_weekend %}
    {% for peak in peaks %}
        {% if now().hour >= peak[0] and now().hour < peak[1] %}
            {% set is_peak = True %}
        {% endif %}
    {% endfor %}
{% endif %}

{# Set distribution rate based on peak or offpeak time #}
{% set distribution_rate = s.peak_distribution_rate if is_peak else s.offpeak_distribution_rate %}

{# Final price calculation: convert current_price to PLN, add distribution rate, market access fee, and apply VAT #}
{{ ((fixing1_rate * s.exchange_rate) + distribution_rate + s.market_access_fee) * s.VAT | float }}

[nerodoxus]

Why you define here exchange_rate? The data acquired from TGE is in PLN.

[nerodoxus]

I found a bug in this code. You set is_peak in the loop but this is only local setting. Specifically, the set statement inside the loop only updates is_peak locally within that specific iteration of the loop. It does not persist the change to is_peak across subsequent iterations of the loop.

Solutions is here. You can experiment with static tmp_hour value and see how ns.is_peak is changed over the loop.

{# Define peak periods for G12W tariff as a list of tuples (start_hour, stop_hour) #}
{% set peaks = [(6, 13), (15, 20), (22, 23)] %}

{# Determine if it's a weekend (offpeak all day) #}
{# set is_weekend = now().weekday() >= 5 #}

{% set is_weekend = False %}

{# set tmp_hour = now().hour #}

{% set tmp_hour = 17 %}

{# Check if the current time falls within any peak period #}
{% set ns = namespace(is_peak=False) %}
{% if not is_weekend %}
    {% for peak in peaks %}
        {% if tmp_hour >= peak[0] and tmp_hour < peak[1] %}
            {% set ns.is_peak = True %}
            set peak {{ ns.is_peak }}  range-> {{ peak[0] }} {{ peak[1] }}
        {% endif %}
        loop - {{ ns.is_peak }} for range-> {{ peak[0] }} {{ peak[1] }}
    {% endfor %}
{% endif %}

{{ ns.is_peak }}
{{ is_weekend }}

[nerodoxus]

It is worth mentioning that peak_distribution_rate, offpeak_distribution_rate, and market_access_fee modifiers in this template must be defined in the unit PLN/MWh, regardless of the unit setting in the add-on setup.

[PiotrMachowski]

I have added this info to the documentation and config flow.

[Jordan2872]

dzień dobry, chciał bym prosić o pomoc bo nie mam pojęcia jak wypełnić wartościami ten szablon cenowy dla tauron, zaznaczam że nie jestem żadnym programistą itp:/ z góry dziękuję

[Mice30]

Wstawiasz kod i sprawdzasz czy działa:

Potem możesz wstawić wpis w configuration.yaml i przeładować HA, żeby widzieć encję i używać jej gdziekolwiek chcesz:

tutaj cały kod:

sensor:
  - platform: template
    sensors:
      dynamic_energy_price:
        friendly_name: "Dynamiczna cena energii"
        unit_of_measurement: "zł/kWh"
        value_template: >
          {% set s = {
              "exchange_rate": states('sensor.eur_to_pln_exchange_rate')|float(default=4.5),
              "VAT": 1.23,
              "peak_distribution_rate": states('input_number.dystrybucja_g12w_szczyt')|float(default=0.2),
              "offpeak_distribution_rate": states('input_number.dystrybucja_g12w_pozaszczyt')|float(default=0.1),
              "market_access_fee": states('input_number.tauron_taryfa_dynamiczna_prowizja')|float(default=0.03)
          } %}
          
          {% set peaks = [(6, 13), (15, 22)] %}
          {% set is_weekend = now().weekday() >= 5 %}
          {% set ns = namespace(is_peak=False) %}
          
          {% if not is_weekend %}
              {% for peak in peaks %}
                  {% if now().hour >= peak[0] and now().hour < peak[1] %}
                      {% set ns.is_peak = True %}
                  {% endif %}
              {% endfor %}
          {% endif %}
          
          {% set distribution_rate = s.peak_distribution_rate if ns.is_peak else s.offpeak_distribution_rate %}
          {% set fixing1_rate = states('sensor.fixing1_rate')|float(default=0) %}
          
          {{ ((fixing1_rate * s.exchange_rate) + distribution_rate + s.market_access_fee) * s.VAT | float }}