How to add a market price with the use of a price template

In this article, you will learn how to use the project templates to record various remuneration systems or electricity price developments.

There are three different types of price templates:

  1. Simple: A constant price throughout the entire lifetime.
  2. Serial: A variable electricity curve or a fixed feed-in tariff whose amount depends on the commissioning of a production unit.
  3. Matrix: A tariff whose amount depends on the commissioning of the production unit and the installed capacity or the production of the production unit.

To create a price template, go to the detail view of a sales object, select “Template” in the input field Value and click on “Add new template” in the next field.

Simple

If you choose “simple” you can define a driver (e.g. Production) and a tariff, which is constantly valid throughout the entire lifetime of the respective sales object. You get the same result if you choose the driver directly in the sales object and input the respective tariff.

Serial

Choose “Serial” if you want to input either a variable electricity curve or a fixed feed-in tariff, which depends on the time of commissioning of the production unit.

  1. Choose the driver (e.g. Produktion)
  2. In the input field reference point you can choose between two options:
    • If you choose “Production Unit Start” the price which was entered in the period in which the production unit is connected to the grid applies. It applies constantly over the entire period (or from the start to the end of the sales object in which this price template was assigned). Possible application: Detection of a feed-in tariff, where the amount depends on the commissioning of the production unit.

Example: In the screenshot below, the production units which are connected to the grid between August 2014 and December 2015 receive a tariff of 89 EUR / MWh over the entire lifetime of the feed-in tariff, production units that will be connected between January 2016 and March 2016 receive 87.93 EUR / MWh and installations after April 2016 receive 86.88 EUR / MWh.

  • If “Date range” is selected, the entered tariff applies in the respective period. Possible application: Recording of an electricity price study.

Example: The entered data can be interpreted as follows: The electricity produced can be sold at a tariff of 41 EUR / MWh in 2017, 42 EUR / MWh in 2018, etc.

  1. In the input field segments, you can capture time periods and define the appropriate tariff. “Add” allows you to add as many segments as you wish. Press the “Create” button to save the template.

Matrix

  1. If you choose “matrix” as the model, you can capture a tariff whose amount depends on the commissioning of the production unit and the power or the production of the production unit.
  1. In the input field “Columns Driver” you can choose between “Production” and “Power”. The columns driver describes the horizontal axis of the matrix.
  • Example: If you select “Power” as the columns driver, the compensation will depend on the installed capacity of the production unit. In our example this means that production units will receive a different compensation depending on their installed capacity: ≤ 10 kW, 10-30 kW, 30-100 kW, 100 – 1’000 kW and > 1’000 kW. Examples for this application form: EEG Germany 2014, KEV Switzerland.
  1. In the Columns Mode you can choose between “Weighted” and “Interval”:
  • Example “Weighted”: A production unit with 30 kW power receives a tariff of 53,3 ct./kWh for the first 10 kW and a tariff of 44,3 ct./kWh for the remaining 20 kW. Thus the compensation is 47,3 ct./kWh ([10 kW x 53,3 ct./kWh + 20 kW x 44,3 ct./kWh] / 30 kW).

* Example “Interval”: Each system receives the tariff applicable in Interval:

A unit with 10 kW receives 53.3 ct./kWh

A unit with 25 kW receives 44.3 ct./kWh

A unit with 50 kW receives 41.8 ct./kWh

A unit with 200 kW receives 40.2 ct./kWh

etc.

  1. The input field “Reference Point” is analogous to the model “Serial”. A unit with 25 kW reveives 44.3 ct./kWh

Application example

Example 1: A fixed feed-in tariff depends on the installed power and the time of commissioning of the production unit (eg. feed-in tariff for photovoltaics in Switzerland).

  • Reference Point “Production Unit Start”: This input means that the tariff depends on the commissioning date of the production unit (defined in the rows).
  • Columns Driver “Power”: This input means that the tariff depends on the installed power (defined in the columns).
  • Columns Mode “Weighted”: This input means that the performance-dependent tariff is weighted. In our example, this means that the first 10 kW is compensated at the tariff shown in the first column, the next 20 kW at the tariff in the second column, etc.
  • Let us assume that we have a 30 kW production unit with grid connection in January 2017. This production unit will now receive a tariff of 42.7 ct./kWh for the first 10 kW and a tariff of 40.0 ct./kWh for the remaining 20 kW. Thus, the compensation is 40.9 ct./kWh ([10 kW x 42.7 ct./kWh + 20 kW x 40.0 ct./kWh] / 30 kW).

Example 2: A variable feed-in tariff depends on the installed power.

  • Reference Point “Date range”: This input means that the tariff is variable over time. This means in our example that the tariffs defined in the first line are valid for the year 2016 and for the year 2017 the tariffs from the second row, etc.
  • Columns Driver “Power”: This input means that the tariff depends on the installed power (defined in the columns).
  • Columns Mode “Interval”: This input means that a production unit with power of 10 kW receives the tariffs from the first column, production units with 10 – 30 kW the tariffs from the second column, etc.
  • Let’s assume that we have a 30 kW power production unit. We can sell the electricity produced in 2016 at a rate of 44.3 EUR / MWh, in 2017 for 40.0 EUR / MWh, etc.