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.
| Country code | Country name |
| BE |
Belgium |
| BG |
Bulgaria |
| CZ |
Czechia |
| DK |
Denmark |
| DE |
Germany |
| EE |
Estonia |
| IE |
Ireland |
| EL |
Greece |
| ES |
Spain |
| FR |
France |
| HR |
Croatia |
| IS |
Iceland |
| IT |
Italy |
| CY |
Cyprus |
| LV |
Latvia |
| LI |
Liechtenstein |
| LT |
Lithuania |
| LU |
Luxembourg |
| HU |
Hungary |
| MT |
Malta |
| NL |
Netherlands |
| NO |
Norway |
| AT |
Austria |
| PL |
Poland |
| PT |
Portugal |
| RO |
Romania |
| SI |
Slovenia |
| SK |
Slovakia |
| FI |
Finland |
| SE |
Sweden |
| CH |
Switzerland |
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
| Column index | Column name | Type | Rules |
|
A |
Airport Name | String | None |
| B | ICAO Code | String | Not empty. Exactly 4 characters. |
| C | Total flights operated departing from the Union Airport (Nº flights) |
Integer | Not empty. Positive. Greater than 0. |
| D | Total flights hours operated departing from the Union Airport (Nº hours) |
Decimal | Not empty. Positive. Greater than 0. |
| E | Yearly aviation fuel required (tonnes) |
Decimal (tonnes) | Not empty. Positive. Greater than 0. |
| F | Yearly actual aviation fuel uplifted (tonnes) |
Decimal (tonnes) | Not empty. Positive. Greater than 0. |
| G | Yearly non-tanked quantity (tonnes) |
Decimal (tonnes) | Not empty. Positive. Greater than 0. |
| H | Yearly tanked quantity for fuel safety rules (tonnes) |
Decimal (tonnes) | Not empty. |
SAF Purchase Reporting
In case no SAF was purchased please keep the sheet empty.
| Column index | Column name | Type | Rules |
|
A |
Fuel Supplier | String | Not empty. |
| B | Batch Number |
String |
Not empty. |
| C | Amount Purchased (tonnes) |
Decimal (tonnes) |
Should match with the sum of columns G to K. Not empty. |
| D |
Category of eligible fuel for use in aircraft Note: Template contains predefined categories |
String | Not empty. |
| E | Feedstock | String | Not empty. |
| F | Lifecycle emissions of the Eligible Fuel (gCO2eq/MJ) | Decimal | Not empty. Positive. Greater than 0. |
| G | Eligible Fuel (tonnes) claimed under EU ETS | Decimal (tonnes) | Optional |
| H | Eligible Fuel (tonnes) claimed under CH ETS | Decimal (tonnes) | Optional |
| I | Eligible Fuel (tonnes) claimed under CORSIA | Decimal (tonnes) |
Optional |
|
J |
Eligible Fuel (tonnes) claimed under other MBMs | Decimal (tonnes) | Optional |
| K | Eligible Fuel (tonnes) not claimed | Decimal (tonnes) | Optional |
Changelog
-
18 March 2025: Column H of sheet number 1 ‘Fuel reporting’
Updated automated checks from ‘Not empty, Positive and Greater than 0.’ to ‘Not empty’