Templates Luzboa que uso:
Custo kWh/dia:
---
sensor:
- name: Luzboa Daily Spot Cost
unit_of_measurement: €/kWh
state_class: measurement
state: |-
{% set PMD = state_attr(this.entity_id, 'PMD') | float(default=0) -%}
{% set MIBEL = state_attr(this.entity_id, 'MIBEL') | float(default=0) -%}
{% set Desvios = state_attr(this.entity_id, 'Desvios') | float(default=0) -%}
{% set SAJ = state_attr(this.entity_id, 'SAJ') | float(default=0) -%}
{% set PFC = ((PMD+MIBEL)/1000) + Desvios + SAJ -%}
{% set FA = state_attr(this.entity_id, 'FA') | float(default=0) -%}
{% set PT = state_attr(this.entity_id, 'PT') | float(default=0) -%}
{% set CG = state_attr(this.entity_id, 'CG') | float(default=0) -%}
{% set TEPAi = state_attr(this.entity_id, 'TEPAi') | float(default=0) -%}
{{( (PFC*(1+PT))*FA+(CG)+(TEPAi) ) | round(4) }}
attributes:
friendly_name: "Luzboa €/kWh"
formula: (ER*PFC*(1+PT)*FA)+(ER*CG)+(ER*TEPAi)
PMD: "{{ state_attr('sensor.omie_spot_price_pt', 'today_average') | float(default=0) }}"
MIBEL: "{{ state_attr('sensor.omie_adjustment_price_pt', 'today_average') | float(default=0) }}"
Desvios: "{{ 0 | round(4) }}"
SAJ: "{{ 0.004 | round(4) }}"
FA: "{{ 1.02 | round(4) }}"
PT: "{{ 0.1507 | round(4) }}"
CG: "{{ 0.005 | round(4) }}"
TEPAi: "{{ -0.09580 | round(4) }}"
Luzboa custo médio mensal, usa o SQL do month to date, o que partilhei acima, para tentar estimar o custo kWh total do mês.
---
sensor:
- name: Luzboa Average Monthly Cost
unit_of_measurement: €/kWh
state_class: measurement
state: |-
{% set PMD = state_attr(this.entity_id, 'PMD') | float(default=0) -%}
{% set MIBEL = state_attr(this.entity_id, 'MIBEL') | float(default=0) -%}
{% set Desvios = state_attr(this.entity_id, 'Desvios') | float(default=0) -%}
{% set SAJ = state_attr(this.entity_id, 'SAJ') | float(default=0) -%}
{% set PFC = ((PMD+MIBEL)/1000) + Desvios + SAJ -%}
{% set FA = state_attr(this.entity_id, 'FA') | float(default=0) -%}
{% set PT = state_attr(this.entity_id, 'PT') | float(default=0) -%}
{% set CG = state_attr(this.entity_id, 'CG') | float(default=0) -%}
{% set TEPAi = state_attr(this.entity_id, 'TEPAi') | float(default=0) -%}
{{( (PFC*(1+PT))*FA+(CG)+(TEPAi) ) | round(4) }}
attributes:
friendly_name: "Luzboa €/kWh"
formula: (ER*PFC*(1+PT)*FA)+(ER*CG)+(ER*TEPAi)
PMD: "{{ states('sensor.omie_pt_spot_price_month_to_date_average') | float(default=0) }}"
MIBEL: "{{ state_attr('sensor.omie_adjustment_price_pt', 'today_average') | float(default=0) }}"
Desvios: "{{ 0 | round(4) }}"
SAJ: "{{ 0.004 | round(4) }}"
FA: "{{ 1.02 | round(4) }}"
PT: "{{ 0.1507 | round(4) }}"
CG: "{{ 0.005 | round(4) }}"
TEPAi: "{{ -0.09580 | round(4) }}"
Basei-me nuns templates partilhados acima, só adaptei para a versão 1.0.0 e o meu template SQL
(Acho que devia usar um SQL para o MIBEL, mas lá chegarei).