File link: 

1. Purpose of the file: 

This sheet is used to collect data related to the transfer of products between plants, specifically for calculating emissions associated with transportation routes. 
It records the details of outbound and inbound plants, the emission factor for each route, and the relevant activity year. 
This information is essential for accurately assessing the carbon footprint of inter-plant logistics.

To list or check which are the missing routes, following file is giving the list of routes to be mapped:  PCF PROD Missing routes


2. File Structure

2.1. List of tabs

Sheet NameDescriptionMandatoryComment
Sheet1This sheet is used to collect data related to the transfer of products between plants, specifically for calculating emissions associated with transportation routes. YESDon't delete this sheet


2.2. Main columns description
SHEET: Sheet1

FIELDOutbound PlantOutbound Plant CodeInbound PlantInbound Plant CodeRoute Emission factor (kgCO2e/kg)Activity_Year
DESCRIPTIONName of the plant from which the product is shipped
Unique code assigned to the outbound plant (as defined in SAP or other systems)
Name of the plant receiving the product
Unique code assigned to the inbound plant (as defined in SAP or other systems)
Emission factor associated with the transportation route, expressed in kilograms of CO₂-equivalent per kilogram of product transported
Calendar year for which the emissions are calculated
DATA TYPEStringStringStringStringFloatString YYYY
SAMPLEOldbury0214Taboão82870.092023
MANDATORYNOYESNOYESYESYES


3. Filling instructions

Sheet NameInstructions
Sheet1• All fields are mandatory. Do not leave any cells blank

• Enter only raw values. Do not use formulas, merged cells, or special formatting

• For both outbound and inbound plants, use the official plant names and codes as defined in SAP

• Double-check for spelling errors and code accuracy

• Enter the emission factor for each route in kilograms of CO₂-equivalent per kilogram of product transported

• Specify the calendar year for which the emission factor and route data apply. Use the format YYYY (e.g., 2024)

• Each row should represent a unique outbound-inbound plant combination for a specific year

• Duplicate rows will be rejected during the data upload. Please ensure that no duplicate entries are present in the sheet.


4. Maintenance best practices

Please comply with the following instructions to maintain the file:                                                                                                    
• Always keep the original structure (do not add/remove columns without approval).                                                                                                    
• Update only the necessary fields.                                                                                                    
• Save a backup copy before any major changes.                                                                                                    
• Respect data confidentiality.   


5. Contact Points         

File ownerSébastien Willemse Hubert Sizaret
Technical SupportCamille Faure Laëtitia Arantes

For any questions or issues, please contact the responsible person listed above.
Please strictly follow these guidelines to ensure data quality and reliability.