Q: Additional Cost based on date... again

[boelle]

i use this template to add fee's on top of what nordpool reports

{% set s = {
"cost": 88.6,
"summer": {"night": 5.5125, "day": 8.2725, "eve": 21.5025, "eve2": 8.2725, "fail": 0.0},
"winter": {"night": 5.5125, "day": 16.545, "eve": 49.6275, "eve2": 16.545, "fail": 0.00}
}
%}
{% set season = 'summer' if 4 <= now().month < 10 else 'winter' %}
{% if 0 <= now().hour < 6 %}
{% set tod = 'night' %}
{% elif 6 <= now().hour < 17 %}
{% set tod = 'day' %}
{% elif 17 <= now().hour < 21 %}
{% set tod = 'eve' %}
{% elif 21 <= now().hour < 24 %}
{% set tod = 'eve2' %}
{% else %}
{% set tod = 'fail' %}
{% endif %}
{{ s[season][tod] + s.cost}}

it should work with the tariff model 3 in denmark

fee's for each kwh depends on summer/winter and what time of day it is

the prices today are:

but i get much lower prices

have i f'ed up or is the data pulled from nordpool wrong?

one thing i have never figured is to add VAT which is 25% for denmark... how do i do that?

[boelle]

as for the prices... they are listed in MWh

if during config i select that i get close

but my template is based on KWh... so do i just select KWh instead during config?

[boelle]

so, with this config i'm close....

its just 100x to big... the number should be 547,6402 Øre/kWh which would turn in to 5,476402 kr

[boelle]

so to sum it up, i need to add 25% and divide by 100

[boelle]

if i change the last line in my template to this would that add the 25% danish VAT?

{{ (s[season][tod] + s.cost)*0.25}}

[boelle]

i came even closer, this is more notes for others until i hit the nail fully

and this template. its need adjusting once a year when tarrif changes

{% set s = {
    "cost": 0,
    "summer": {"night": 0.0555125, "day": 0.082725, "eve": 0.215025, "eve2": 0.082725, "fail": 0.0},
    "winter": {"night": 0.0555125, "day": 0.16545, "eve": 0.496275, "eve2": 0.16545, "fail": 0.0}
}
%}
{% set season = 'summer' if 4 <= now().month < 10 else 'winter' %}
{% if 0 <= now().hour < 6 %}
  {% set tod = 'night' %}
{% elif 6 <= now().hour < 17 %}
  {% set tod = 'day' %}
{% elif 17 <= now().hour < 21 %}
  {% set tod = 'eve' %}
{% elif 21 <= now().hour < 24 %}
  {% set tod = 'eve2' %}
{% else %}
  {% set tod = 'fail' %}
{% endif %}
{{ s[season][tod] + s.cost}}

i guess i can now tick the VAT box, but that one does not say what % it uses