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 SupportMatthieu GUIRARDEL 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.  


 

                                           

TO BE DELETED:

Purpose of the file: This file contains emission factors for each route between plants.


Outbound PlantOutbound Plant CodeInbound PlantInbound Plant CodeRoute Emission factor (kgCO2e/kg)Activity_Year
Sample DataItatiba8227Paulinia75250.0042023
Mandatory?Not mandatory field.Mandatory field; Must be filledNot mandatory field.Mandatory field; Must be filledMandatory field; Positive float onlyMandatory field; Must be filled
Data typestringstringstringstringfloatstring
Field DescriptionSAP Plant Name from which the intermediate leavesSAP Plant Code from which the intermediate leavesSAP Plant Name to which the intermediates arrivesSAP Plant Code to which the intermediates arrivesRoute Emission FactorYear for which PCF is calculated
CommentRefers to the outbound plant

Refers to the inbound plant

Data Owner - Sebatien Willemse and Hubert Sizaret (the data owner will receive the error file by email and will be responsible for making any necessary manual corrections.)


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