Biofuel FQD Reports Overview
In this overview, the Biofuel FQD Reports detail the process of reporting biofuel data for the worksheet Biofuels with specific criteria such as status, destination market, sustainability, and more. The module covers preparing data for download, valuelists in the Excel template, and the download process to Excel. It provides a comprehensive understanding of the reporting structure and requirements for biofuel-related data in the European context.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
Biofuel FQD Reports 12/11/2019
FQD Reports Module Reporting Biofuel Objective: supply data for worksheet Biofuels Which data? Partitions with status Approved Released for Consumption Destination market Belgium/Luxembourg Structure: same number of columns as in the EUR Template
FQD Reports Module Reporting Biofuel Row in the report = Sum of Delivered quantity of partitions 1. Same Biofuel type (Biofuel product type short name) Excel Column B: Biofuel/energy type 2. Same Biomass type (Biomass short name) Excel Column E: feedstock 3. Same Biomass type (Biomass long name) Excel Column F: Biofuel production pathway) 4. Same Sustainability (Y/N) Excel Column C: Sustainable biofuel (yes,no) 5. Same Land of origin of the biomass Excel Column G: Country of origin of feedstock 6. Same Place of Purchase country for the Biofuel Product Type Excel Column H: Place of purchase Country 7. Same GHG Intensity Excel Column N: GHG Intensity
FQD Reports Module Reporting Biofuel Prepare data for download 1. In order to prepare the reports for download some of the data need to be adapted or converted. 2. Convert values in ton to values in kilogram (kg) 3. Convert values in m3 to values in litre (l) 4. Calculation for GHG emissions produced on the whole life cycle (when consignment is Sustainable) 5. The same number of columns as the worksheet in the Europe Template Supplier: 16 columns
FQD Reports Module Reporting Biofuel Valuelists in excel-template + impacted columns 1. Column B: Biofuel type Column D: Biofuel component CN Code 2. Column C: Sustainable (Y/N) Column N: GHG Intensity (automatic if Sustainable=Y) 3. Column E: Feedstock Column O: ILUC Feedstock category Column P: ILUC emissions intensity 4. Column J: Quantity (Unit) Litre / Kilo Column K: Lower Calorific Value Column L: Lower Calorific Unit Column M: Quantity Energy (MJ)
FQD Reports Download 1. Download result to Excel 2. Add results to excel Europe Template Supplier Few rows: Copy-paste (column by column) Many rows: V-Lookup
FQD Reports Module
FQD Reports Download
FQD Reports Download
Copy-Paste OR V-Lookup 9 Columns of the downloaded file have to be added to the EUR template: Column B (2) : Biofuel type Column C (3) : Sustainable biofuel (filter op Y/N) Column E (5) : Feedstock Column F (6) : Biofuel production pathway Column G (7) : Country of origin of feedstock Column H (8) : Place of purchase country Column I (9) : Quantity Column J (10) : Quantity (unit) Column N (14) : GHG Intensity (only if Sustainable=Y)
V-Lookup How to Combine 2 Excel Workbooks Using VLOOKUP https://www.youtube.com/watch?v=809m6kLTfgI
Questions? Thank you!
