JAO Static Grid Model Converter Function

The from_jao function allows users to convert the Static Grid Model provided by JAO (Joint Allocation Office) into a pandapower network by reading and processing the provided Excel and HTML files.

Function Overview

pandapower.converter.from_jao(excel_file_path: str, html_file_path: str | None, extend_data_for_grid_group_connections: bool, drop_grid_groups_islands: bool = False, apply_data_correction: bool = True, max_i_ka_fillna: float | int = 999, **kwargs) → pandapowerNet

Converts European (Core) EHV grid data provided by JAO (Joint Allocation Office), the “Single Allocation Platform (SAP) for all European Transmission System Operators (TSOs) that operate in accordance to EU legislation”.

Data Sources and Availability:

The data are available at the website JAO Static Grid Model (November 2024). There, a map is provided to get an fine overview of the geographical extent and the scope of the data. These inlcude information about European (Core) lines, tielines, and transformers.

Limitations:

No information is available on load or generation. The data quality with regard to the interconnection of the equipment, the information provided and the (incomplete) geodata should be considered with caution.

Features of the converter:

Data Correction: corrects known data inconsistencies, such as inconsistent spellings and missing necessary information.
Geographical Data Parsing: Parses geographical data from the HTML file to add geolocation information to buses and lines.
Grid Group Connections: Optionally extends the network by connecting islanded grid groups to avoid disconnected components.
Data Customization: Allows for customization through additional parameters to control transformer creation, grid group dropping, and voltage level deviations.

Parameters:

excel_file_pathstr: input data including electrical parameters of grids’ utilities, stored in multiple sheets of an excel file
html_file_pathstr: input data for geo information. If The converter should be run without geo information, None can be passed., provided by an html file
extend_data_for_grid_group_connectionsbool: if True, connections (additional transformers and merging buses) are created to avoid islanded grid groups, by default False
drop_grid_groups_islandsbool, optional: if True, islanded grid groups will be dropped if their number of buses is below min_bus_number (default is 6), by default False
apply_data_correctionbool, optional: _description_, by default True
max_i_ka_fillnafloat | int, optional: value to fill missing values or data of false type in max_i_ka of lines and transformers. If no value should be set, you can also pass np.nan. By default 999

Returns:

pandapowerNet: net created from the jao data

Examples

>>> from pathlib import Path
>>> import os
>>> import pandapower as pp
>>> net = pp.converter.from_jao()
>>> home = str(Path.home())
>>> # assume that the files are located at your desktop:
>>> excel_file_path = os.path.join(home, "desktop", "202409_Core Static Grid Mode_6th release")
>>> html_file_path = os.path.join(home, "desktop", "2024-09-13_Core_SGM_publication.html")
>>> net = from_jao(excel_file_path, html_file_path, True, drop_grid_groups_islands=True)