Automated data checks on the data reporting template

Common issues with automated checks

• Column H of sheet 1 'Fuel Reporting sheet' should not be left empty. If nothing should be reported, please include 0.
• If you are getting many 'Required property' errors it could be related
  • to adding/removing of rows or removing the formula of column G when filling in the template. We suggest downloading the template again and copy-pasting the data.
  • to cells being empty, if nothing can be reported, please include 0.

We suggest to also view the common issues section of the Step-by-step guide for Aircraft Operators.

Automated checks explained

When reporting data for ReFuelEU Aviation, the Sustainability Portal does some automated checks on the data. If a check finds an error, such as an empty cell, it will add it to the error report.

More information on the data reporting feature via the Step-by-step guide for Aircraft Operators.

It is important to note that there can be a difference between the actual cell value and the displayed value of a cell. The value of a selected cell can be found in the formula bar at the top, while the displayed value is what you will see in the spreadsheet.

In the example below, the cell value is "1893867.566" (visible at the top in the formula bar), while the displayed value is formatted to the user's localization settings in the tool of his preference.

The below rules apply to the cell values, so the value is visible in the formula bar.

General rules

Numbers

Decimals separator

The decimal separator MUST use the dot (.) notation.

Thousand separator

There SHALL NOT be any thousand separator in a cell.

Negative value

No negative value is to be accepted.

Cell formatting

It is RECOMMENDED that no formatting is applied to files submitted to the Sustainability Portal.

File encoding

Files MUST be UTF-8 encoded, do avoid character encoding issues

Columns

Only the defined columns (i.e. A-K) will be considered for both validation and import, regardless of column headers in the first row. Any additional columns will be ignored.

Rows

First row is always considered to contain the header, not data, thus it is skipped for validation and processing.

The data range is calculated based on the last row containing non-empty cells in the defined column rage.

Airport

The airports are validated on their provided ICAO Code. Only airports that fall in scope of the current reporting period are accepted. 

Member state

2 characters country code, as defined in the ISO 3166-1 alpha-2 specification.

Below is a list of accepted member states.

Tonnes

• Can have a precision of 3 decimals, allowing kilogram level accuracy to be provided
• Minimum value 0

Valid values: 123545; 12345.1; 12345.10; 12345.100

Invalid values: -1; 12345.4586; 12345,458 (notice the , used as separator)

Automatic checks and expected data per sheet

Fuel Reporting sheet