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 Name | Description | Mandatory | Comment |
| Sheet1 | This sheet is used to collect data related to the transfer of products between plants, specifically for calculating emissions associated with transportation routes. | YES | Don't delete this sheet |
2.2. Main columns description
SHEET: Sheet1
| FIELD | Outbound Plant | Outbound Plant Code | Inbound Plant | Inbound Plant Code | Route Emission factor (kgCO2e/kg) | Activity_Year |
| DESCRIPTION | Name 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 TYPE | String | String | String | String | Float | String YYYY |
| SAMPLE | Oldbury | 0214 | Taboão | 8287 | 0.09 | 2023 |
| MANDATORY | NO | YES | NO | YES | YES | YES |
3. Filling instructions
| Sheet Name | Instructions |
| 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 owner | Sébastien Willemse Hubert Sizaret |
| Technical Support | Camille 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.