SFTP: Nomination File Formats

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 enabled by providing a TSO.

Concepts and Conventions

Term	Description
Balance Group	A virtual energy account the BRP is responsible for.
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 BRP’s and Otark’s balance group, at one time slot. This is an aggregate over all transactions relating to the balance group, which are routed through Otark.

Units and conventions:

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: 50Hertz
- TEN: TenneT
- AMP: Amprion
- TRA: TransnetBW

For example files, see the Example Exports page.

CSV Export

The CSV export contains nominations per balance group (net, in, and out).

Format

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.

After the timestamp columns, three columns are repeated for each balance group:

Column pattern	Description
`{TSO}_{BG_EIC}`	Net nomination (SALDO)
`{TSO}_{BG_EIC}_IN`	Inbound nomination
`{TSO}_{BG_EIC}_OUT`	Outbound nomination

Where {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 #6D5AZ`)
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 delivery volume
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`)

Left side — Nominations: For each of the following groups, three columns are provided: SALDO (net), IN, and OUT.

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)

Right side — Transactions: For each of the following groups, three columns are provided: SALDO (net), IN, and OUT.

Column group	Description
All transactions	Sum of all transaction types (Spot + PPAs)
Green SPOT — Day ahead	Day-ahead spot market transactions (closed beta)
Green SPOT — Intraday	Intraday spot market transactions (closed beta)
1-Click-PPAs — Total	Sum of all 1-Click PPA transactions
`PPA #{id}` — `{BG_ID} ({TSO})`	Individual 1-Click 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 last row contains Totals with SUM formulas over all time slots.

Sheet 3: Metadata

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

BRP Connect

SFTP

Webhooks

BRP API

Contracts

Transactions

Nominations

Customers

SFTP: Nomination File Formats

Concepts and Conventions

CSV Export

Format

Columns

Excel Export

Sheet 1: PPAs

Sheet 2: Transactions

Sheet 3: Metadata

​Concepts and Conventions

​CSV Export

​Format

​Columns

​Excel Export

​Sheet 1: PPAs

​Sheet 2: Transactions

​Sheet 3: Metadata

Concepts and Conventions

CSV Export

Format

Columns

Excel Export

Sheet 1: PPAs

Sheet 2: Transactions

Sheet 3: Metadata