This is one of 3 IT projects that we have successfully completed with our customers.

How can we support you?

Analysis of customer-related entries in the market master data register (Federal Network Agency)

Project duration: 2 months

Brief description

In order to validate the completeness of the data procurement via interfaces implemented by third parties (independent of these interfaces), the master data stock supplied by the Federal Network Agency relevant to the customer's area with regard to locations, (power generation and other) units and power plants are determined and made available in form of CSV files.


At the time the project was being carried out, the database of the market master data register of the Federal Network Agency comprised 175 differently structured UTF-16-coded XML files with a total size of around 22GB. This data is recoded to UTF-8 and filtered with awk scripts for data relevant to the customer and analyzed with regard to their relationships between locations, units and systems. The results are provided as CSV data in a way that is suitable for comparison with existing productive data.

Subject description

According to the Renewable Energy Sources Act (EEG), a transmission provider has the following responsibilities: (a) Discharge and reimbursement of the energy received by the distribution system operators within the transmission provider's control area, as defined by EEG, and the accruing market premiums in the case of direct marketing. (b) Recording the energy received (quantity and chronological sequence) and the reimbursement payments made. (c) Horizontal adjustment: Adjusting the received energy and the reimbursements provided among the 4 transmission providers in Germany. (d) Marketing the energy remaining with the transmission provider after horizontal adjustment. (e) Proportionate distribution of the incurred costs to all electricity supply companies supplying end consumers within its control area. (f) Implementation of a skimming process for excess profits from energy producers on the spot market.


Project period14.11.2022 - 31.12.2022

Have we sparked your interest?

Dr. Andreas Schneider

Sector Manager Energy

Jetzt Kontakt aufnehmen

Zum Umgang mit den hier erhobenen Daten informieren wir in unserer Datenschutzerklärung.

Contact now

We provide information on the handling of the data collected here in our privacy policy.

Download file

We provide information on the handling of the data collected here in our privacy policy.