Daily and Monthly cost

[MrSimpa]

In the case of the graphs, I see that you also have a calculation based on daily and monthly costs. How do you get the balance for the previous months so that you can calculate the expenses? I am also interested in the past day, given that the data is "rarely" linked, I tried to do it at a specific time, e.g. 10 am to check the status according to the tariff for the previous day, but the status is usually "Unavailable".

[frlequ]

You can play with this, but keep in mind, that invoices can change significantly every month, so dont rely on it.

This is for monthly costs:

  - sensor:
     - name: "Energy Monthly Costs"
       unit_of_measurement: "EUR"
       state_class: total_increasing
       availability: "{{ states('sensor.mojelektro_monthly_input_peak') not in ['unavailable', 'unknown', None] and states('sensor.mojelektro_monthly_input_offpeak') not in ['unavailable', 'unknown', None] and states('sensor.mojelektro_monthly_input') not in ['unavailable', 'unknown', None] }}"
       device_class: monetary
       state: >
            {% set VT_kWh = float(states('sensor.mojelektro_monthly_input_peak')) %}
            {% set MT_kWh = float(states('sensor.mojelektro_monthly_input_offpeak')) %}
            {% set monthlyInput = VT_kWh + MT_kWh  %}
            
            {% set total_monthly_costs_neto =  float(state_attr('sensor.energy_monthly_costs', 'total_monthly_costs_neto')) %}


            {% set sodo_moc = float('0.796000') %}
            {% set sodo_VT = float('0.043080') %}
            {% set sodo_MT = float('0.033110') %}

            {% set prispevki1 = float('0.000130') %}
            {% set prispevki2 = float('0.000800') %}
            {% set SPTE = float('0.0') %}
            {% set prispevki3 = float('0.001530') %}

            {% set mesecno_nadomestilo = float('1.99') %}
            {% set jedrska_energija = float('0') %}
            {% set popust1 = float('-1.00') %}
            {% set popust_eko = float('-1.00') %}


            {% set prispevki4T =  10 * sodo_moc  %}
            {% set sodo_neto = (VT_kWh * sodo_VT) + (MT_kWh * sodo_MT) + prispevki4T  %}



            {% set prispevki1T = (monthlyInput * prispevki1) %}
            {% set prispevki2T = (monthlyInput * prispevki2 )  %}
            {% set prispevki3T =  (monthlyInput * prispevki3 )  %}
            {% set prispevki5T = SPTE %}
            {% set prispevki6T = (mesecno_nadomestilo ) + (jedrska_energija ) +  (popust_eko ) %}



            {% set eTotal = total_monthly_costs_neto  + sodo_neto +  prispevki1T  + prispevki2T + prispevki5T + prispevki3T  + prispevki6T     %}


            {{ (eTotal*1.22) | round(2) }}
       attributes:
          total_monthly_costs_vt_neto: >

            {% set price_VT = float(0.162900) %}
            {% set price_VT_regulated = float(0.118000) %}

            {% set VT_kWh =  float(states('sensor.mojelektro_monthly_input_peak'))  %}

            {% set VT_kWh_unregulated = (VT_kWh / 100 * 10) | round (0) %}

            {% set total_monthly_VT_regulated = (VT_kWh - VT_kWh_unregulated) * price_VT_regulated %}
            {% set total_monthly_VT_unregulated = VT_kWh_unregulated * price_VT %}

            {% set total_monthly_VT_costs = total_monthly_VT_unregulated + total_monthly_VT_regulated %}

            {{total_monthly_VT_costs  | round(2) }}
              
          total_monthly_costs_mt_neto: >

            {% set price_MT = float(0.162900) %}
            {% set price_MT_regulated = float(0.118000) %}

            {% set MT_kWh =  float(states('sensor.mojelektro_monthly_input_offpeak'))  %}

            {% set MT_kWh_unregulated = (MT_kWh / 100 * 10) | round (0) %}

            {% set total_monthly_MT_regulated = (MT_kWh - MT_kWh_unregulated) * price_MT_regulated %}
            {% set total_monthly_MT_unregulated = MT_kWh_unregulated * price_MT %}

            {% set total_monthly_MT_costs = total_monthly_MT_unregulated + total_monthly_MT_regulated %}

            {{total_monthly_MT_costs  | round(2)}}

          total_monthly_costs_neto: >
            {% set total_monthly_VT_costs = float(state_attr('sensor.energy_monthly_costs', 'total_monthly_costs_vt_neto')) %}
            {% set total_monthly_MT_costs = float(state_attr('sensor.energy_monthly_costs', 'total_monthly_costs_mt_neto')) %}
            {% set total_monthly_costs_neto = (total_monthly_VT_costs + total_monthly_MT_costs) | round(2) %}              
            {{ total_monthly_costs_neto  | round(2) }}

Daily is currently not correct, because it's 90% regulated and 10% not, but you can change energy price sensors accordingly:

  - sensor:
     - name: "Energy Price VT"
       unit_of_measurement: "EUR/kWh"
       state_class: total_increasing
       device_class: monetary
       state: "0.1750029"
        
  - sensor:
     - name: "Energy Price MT"
       unit_of_measurement: "EUR/kWh"
       state_class: total_increasing
       device_class: monetary
       state: "0.12499425"

  - sensor:
     - name: "Energy Daily Costs"
       unit_of_measurement: "EUR"
       state_class: total_increasing
       device_class: monetary
       availability: "{{ states('sensor.mojelektro_daily_input_peak') not in ['unavailable', 'unknown', None] and states('sensor.mojelektro_daily_input_offpeak') not in ['unavailable', 'unknown', None]}}"       
       state: >
          {% set price_VT = (states('sensor.energy_price_VT')) %}
          {% set price_MT = (states('sensor.energy_price_MT')) %}
          {% set offpeak = (states('sensor.mojelektro_daily_input_offpeak')) %}
          {% set peak = (states('sensor.mojelektro_daily_input_peak')) %}
         
          {% set totalDailyOffPeak = (float(offpeak) * float(price_MT)) %}
          {% set totalDailyPeak = (float(peak) * float(price_VT)) %}
        
          {{ (totalDailyOffPeak + totalDailyPeak) | round(2) }}
       attributes:
          total_daily_peak: >
            {% set price_VT = (states('sensor.energy_price_VT')) %}
            {% set peak = (states('sensor.mojelektro_daily_input_peak')) %}
            {% set totalDailyPeak = (float(peak) * float(price_VT)) %}
            
            {{ totalDailyPeak | round(2) }}
            
          total_daily_offpeak: >
            {% set price_MT = (states('sensor.energy_price_MT')) %}
            {% set offpeak = (states('sensor.mojelektro_daily_input_offpeak')) %}
            {% set totalDailyOffPeak = (float(offpeak) * float(price_MT)) %}
            
            {{ totalDailyOffPeak | round(2) }}

[MrSimpa]

Thank you, what about graph,

I created an entity price_day_mojelektro, which calculates (at specific time - 9am morning) the price based on the daily readings for the previous day. But the graph, although I used practically the same parameters as for daily consumption, is very "strange".

My code:

``type: custom:apexcharts-card
apex_config:
dataLabels:
enabled: true
offsetY: -8
style:
fontSize: 10px
fontFamily: SegoeUI
background:
enabled: false
plotOptions:
bar:
borderRadius: 3
borderRadiusApplication: around
borderRadiusWhenStacked: all
columnWidth: 100%
stroke:
colors: transperent
width: 1
xaxis:
floating: false
labels:
show: true
axisTicks:
show: false
axisBorder:
show: false
tooltip:
enabled: false
crosshairs:
show: false
width: 25
position: front
opacity: 0.2
yaxis:
min: 0
decimals: 2
tickAmount: 1
floating: true
labels:
show: true
offsetX: 31
offsetY: -6
grid:
strokeDashArray: 2
borderColor: '#666666'
padding:
left: 0
right: 0
chart:
stacked: true
height: 200px
animations:
enabled: false
graph_span: 6d
hours_12: false
show:
loading: false
cache: true
span:
end: day
offset: '-2day'
experimental:
hidden_by_default: true
color_list:

• '#335272'
• var(--paper-item-icon-active-color)
  update_interval: 1hour
  series:
• entity: sensor.cena_dan_mojelektro
  name: Cena dnevno
  type: column
  float_precision: 2
  show:
  legend_value: false
  offset_in_name: false
  offset: +1day
  ``

[frlequ]

Are you talking about strange data or strange graph visuals?

for apex-chart-card i'm using code below:

type: custom:apexcharts-card
card_mod:
  style: |
    ha-card .apexcharts-gridlines-horizontal{
       /*transform: translate(-14px, 0px);*/
       /* margin-left: -20px*/
          /*transform: scaleX(0.99);*/
    }
    ha-card .apexcharts-grid{
      /*transform: translate(14px, 0px);*/
     /*transform: scaleX(0.5);*/
      overflow:hidden !important;
    }
    ha-card .apexcharts-xcrosshairs{
      /*transform: translate(-13px, 0px);*/
    }
    ha-card {
       overflow:visible !important;
      }
    ha-card .apexcharts-tooltip{
      border-radius: 0px;
      border: 0 !important;
      box-shadow: unset;
    }
          ha-card .apexcharts-legend{
          display: none;
          
          }
apex_config:
  dataLabels:
    enabled: true
    offsetY: -8
    style:
      fontSize: 10px
      fontFamily: SegoeUI
      color: red
    background:
      enabled: false
  tooltip:
    x:
      format: dddd, d MMMM
    enabled: true
    fixed:
      enabled: true
      position: topleft
    items:
      display: flex
  plotOptions:
    bar:
      borderRadius: 3
      borderRadiusApplication: end
      columnWidth: 100%
  stroke:
    colors: transparent
    width: 1
  xaxis:
    floating: true
    labels:
      show: false
    axisTicks:
      show: false
    axisBorder:
      show: false
    tooltip:
      enabled: false
    crosshairs:
      show: true
      width: 25
      position: front
      opacity: 0.2
  yaxis:
    decimals: 2
    tickAmount: 2
    floating: true
    labels:
      show: true
      offsetX: 31
      offsetY: -6
  grid:
    strokeDashArray: 2
    borderColor: '#666666'
    padding:
      left: 0
      right: 0
  chart:
    height: 180px
    animations:
      enabled: false
graph_span: 14day
color_list:
  - var(--paper-item-icon-active-color)
update_interval: 1hour
show:
  loading: false
hours_12: false
span:
  end: day
  offset: '-2day'
cache: true
series:
  - entity: sensor.energy_daily_costs
    name: ET
    type: column
    float_precision: 2
    show:
      datalabels: total
      legend_value: false
      offset_in_name: false
    statistics:
      type: state
      period: day
      align: start
    offset: +1day