A BRP export contains energy nominations from Otark for a single delivery day (in Europe/Berlin timezone),
containing data for all balance groups that the BRP has registered.
Concepts and Conventions
| Term | Description |
|---|
| Balance Group | A part of the grid that the BRP is responsible for, identified by a TSO and EIC. |
| Customer | A power buyer or seller using Otark. Each customer is assigned to a balance group by the BRP. |
| PPA | A power delivery contract between two customers. |
| Time slot | A 15-minute segment of a day, numbered 1–96 on normal days. On DST spring-forward days, slots 9–12 are omitted (92 slots total). On DST fall-back days, slots 9–12 are repeated as 9a, 10a, 11a, 12a, 9b, 10b, 11b, 12b (100 slots total). |
| Transaction | Power to be delivered between two customers through Otark, at one time slot. |
| Nomination | Netted power to be delivered between a balance group managed by the BRP and Otark, at one time slot. This is an aggregate over all transactions relating to the balance group, which are routed through Otark. |
- All power values are in MW. If you want MWh (energy) per quarter hour, you’ll need to divide by 4.
- Local times are in “Europe/Berlin” time (CET/CEST), unless explicitly stated otherwise
- Each nomination/transaction is represented by three columns:
SALDO/IN/OUT, with SALDO = IN - OUT
IN refers to power flowing into the BRP’s balance group, OUT to power flowing out- Transmission System Operators (TSOs) are referred to by these abbreviations:
50H: 50HertzTEN: TenneTAMP: AmprionTBW: TransnetBW
For example files, see the Example Exports page.
CSV Export
The CSV export contains nominations per balance group (net, in, and out).
- Field separator: Comma (
,)
- Header row as the first row
- One row per time slot
Columns
| Column | Description |
|---|
# | Time slot identifier. Numeric on normal days (1–96). On DST fall-back days, the repeated slots use string suffixes: 9a…12a, 9b…12b |
datetime_iso8601_from | Slot start in ISO 8601 with UTC offset |
datetime_iso8601_to | Slot end in ISO 8601 with UTC offset |
datetime_utc_from | Slot start in UTC (DD.MM.YYYY HH:MM:SS) |
datetime_utc_to | Slot end in UTC (DD.MM.YYYY HH:MM:SS) |
datetime_local_from | Slot start in local time (DD.MM.YYYY HH:MM) |
datetime_local_to | Slot end in local time (DD.MM.YYYY HH:MM) |
On DST fall-back days, the datetime_local columns are ambiguous during the repeated hour (02:00–03:00 appears twice). Use the # column suffix (a vs b) or the datetime_iso8601 columns (which include the UTC offset: +02:00 for CEST, +01:00 for CET) to distinguish between the two occurrences.
| Column pattern | Description |
|---|
{TSO}_{BG_EIC} | Net nomination (SALDO) |
{TSO}_{BG_EIC}_IN | Inbound nomination |
{TSO}_{BG_EIC}_OUT | Outbound nomination |
{TSO} is the TSO abbreviation (e.g. 50H, AMP) and {BG_EIC} is the balance group EIC identifier.
Excel Export
The Excel export contains three sheets with detailed nomination and transaction data.
Sheet 1: PPAs
Lists all active PPAs going through balance groups managed by this BRP. A PPA appears once per customer involved. If both sides of a PPA are managed by the same BRP, the PPA will have two rows (one for the seller, one for the buyer).
| Column | Description |
|---|
| PPA | PPA identifier (e.g. PPA #ext_ppa_001) |
| Period | Contract period short name (e.g. 2025-2026) |
| Delivery Start | Start date of power delivery |
| Delivery End | End date of power delivery |
| Nominal Power (MW) | Contracted nominal power capacity |
| Type | PPA type (e.g. pay-as-indexed) |
| Index | Energy index (delivery profile) |
| Name | Customer name |
| Role | Customer role (Seller or Buyer) |
Sheet 2: Transactions
The main data sheet with one row per time slot. It is divided into a left side (nominations) and a right side (transactions).
Note that some columns are hidden by default and may need to be expanded.
Row columns (all rows):
| Column | Description |
|---|
| # | Time slot number |
| Period | Human-readable time range (e.g. 00:00 - 00:15) |
| Datetime From | Slot start (YYYY-MM-DD HH:MM) |
| Datetime To | Slot end (YYYY-MM-DD HH:MM) |
| Column group | Description |
|---|
| All nominations | Sum of all nominations across all balance groups |
{BG_EIC} ({TSO}) | Nomination for a specific balance group (repeated per balance group) |
| Column group | Description |
|---|
| All transactions | Sum of all transaction types (Spot + PPAs) |
| Green SPOT — Day ahead | Day-ahead spot market transactions (reserved for future use) |
| Green SPOT — Intraday | Intraday spot market transactions (reserved for future use) |
| 1-Click-PPAs — Total | Sum of all 1-Click PPA transactions |
PPA #{id} — {BG_ID} ({TSO}) | Individual PPA transactions per balance group (repeated per PPA) |
The SALDO and TOTAL columns use Excel formulas (e.g. =IN - OUT and =A1+B1+C1+..., respectively),
but also contain precalculated display values that can be read.
The Green SPOT columns are currently always zero and are reserved for future use.
SUM formulas over all time slots.
Contains information about the export.
| Field | Explanation |
|---|
| Export range | always Day |
| Delivery Day | date in ISO 8601 format: 2025-03-30 |
| Resolution | time slot granularity, always 15 Minutes |
| Time Zone | timezone for timestamps, always Europe/Berlin |
| Version | version of this export, in case of amendments |
| Last Update | date-time of last data change (e.g. 2025-12-22 15:54:55) |
| Counterparty | Other side of nominations (Otark) |
| Phone | Otark’s BRP hotline |
| E-Mail | Otark’s BRP support email address |
| Operating Areas | TSOs that Otark operates in |
| Counterparty EIC | always 11Y0-0000-3333-F |
| Exported by | always Otark Schedule System |
| Exported | Timestamp of when the export was generated |
