energinet and other complex tariff configurations

[Maergsche]

Hello,
I already have EOS running on my system and am quite satisfied with it.

Now I am trying to configure it for a friend, which is proving to be much more difficult than I thought. But it would be much more useful for him.

He has a rather complex tariff. In EVCC, it is configured as follows:

currency: DKK

grid:
  type: template
  template: energinet-price
  region: dk1
  charges: 0.7673
  tax: 0.25
  formula: |
    // Determine if it's summer (April - September)
    isSummer := ts.Month() >= 4 && ts.Month() <= 9
     // Initialize gridfee
    gridfee := 0.0000  
     // Set grid fee based on season and time of day
    if isSummer {
      if ts.Hour() < 6 {
        gridfee = 0.0976  // low load summer
      } else if ts.Hour() >= 17 && ts.Hour() < 21 {
        gridfee = 0.3808  // peak load summer
      } else {
        gridfee = 0.1467  // high load summer
      }
    } else {
      if ts.Hour() < 6 {
        gridfee = 0.0976  // low load winter
      } else if ts.Hour() >= 17 && ts.Hour() < 21 {
        gridfee = 0.8788  // peak load winter
      } else {
        gridfee = 0.2929  // high load winter
      }
    }
    (price + charges + gridfee) * (1 + tax)    

feedin:
  type: template
  template: energinet-price
  region: dk1
  charges: 0.966
  tax: 0.25  

Is there any way to use the values from EVCC?

What is the best other way to display the tariff in EOS Connect (develop)?
It doesn't matter whether it is converted into euros or Danish kroner.

Best regards
Marc

[a8291]

I think basically we need an ability to modify the prices in eos connect since it also can be the source to query the prices from tibber or else.

[Maergsche]

Personally, it would help me to fill a Home Assistant sensor, which would then be used as the source for ‘fixed_24h_array’.

Is it possible to use a Home Assistant sensor as the source for the prices, and if so, how does it need to be formatted?

I currently use the Nordpool device to retrieve the prices and then prepare them for visual display.

For example, as follows:

graph_span: 24h
header:
 title: Energy price today (DKK/kWh)
 show: true
span:
 start: day
now:
 show: true
 label: Now
series:
 - entity: sensor.nordpool_energyprices
   color: green
   type: column
   float_precision: 2
   data_generator: |
     return entity.attributes.times.map((time, index) => {
       let price = entity.attributes.prices[index];

       // Originalpreis zurückrechnen (falls MWSt schon drauf)
       price = price / 1.25;

       let charges = 0.7673; // sonstige Gebühren
       let tax = 0.25;       // Mehrwertsteuer

       // Zeitabhängige Grid Fees
       let hour = new Date(time).getHours();
       let month = new Date(time).getMonth() + 1; // JS: 0 = Januar
       let gridfee = 0;

       if (month >= 4 && month <= 9) {
         // Sommermonate: reguläre Grid Fees
         if (hour >= 0 && hour < 6) {
           gridfee = 0.0976;
         } else if (hour >= 17 && hour <= 21) {
           gridfee = 0.3808;
         } else {
           gridfee = 0.1467;
         }
       } else {
         // Wintermonate: abweichende Grid Fees
         if (hour >= 0 && hour < 6) {
           gridfee = 0.0976;
         } else if (hour >= 17 && hour <= 21) {
           gridfee = 0.8788;
         } else {
           gridfee = 0.2929;
         }
       }

       // Zuschläge addieren + MWSt
       price = (price + charges + gridfee) * (1 + tax);

       return [new Date(time).getTime(), price];
     });
yaxis:
 - decimals: 2
   apex_config:
     tickAmount: 10 ```

[Maergsche]

Or even more comfortably would be to Integrate Nord Pool as a source
an then i can use the NT ST and HT configaration to calculate the prices.

Then I would just have to adjust the prices twice a year.

Basically as described here: #51