Versions Compared

Old Version 14

changes.mady.by.user GUIRARDEL, Matthieu

Saved on

compared with

New Version Current

changes.mady.by.user DANILA-ext, Andrea

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

File link: 

Google Drive Live Link
urlhttps://docs.google.com/spreadsheets/d/1wKfGn5seuwux-arDAtOg9la3KqoAWRAUapi9GwEvSwQ/edit?usp=drive_link

1. Purpose of the file: 

This file provides manual PCF manually entered Product Carbon Footprint (PCF) KPIs calculated by experts for some finished products.specific finished products.
For each combination of GBU, finished product, plant, and activity year, it records the global PCF value, together with data quality indicators (Primary Data Share and Data Quality Rating) and a free-text comment field for the data owner's notes.
This file is used where standard PCF calculation through the tool is not applicable and expert-derived values must be imported directly. Note: as no master data tables are available for validation, product codes, product names, plant codes, and plant names cannot be cross-validated against SAP reference data during upload.


2. File Structure

2.1. List of tabs

Sheet NameDescriptionMandatoryComment

Sheet1

Main data entry sheet. Contains manually entered PCF values for finished products per GBU, plant, and activity year.YESDon't delete this sheet


2.2. Main columns description
SHEET: Sheet1


GBU
FIELDGBU
Finish_Product_CodeFinish_Product_NamePlant_CodePlant_NameActivity_YearPCF_finish_productPDS_finish_productDQR_finish_product
CommentSample DataCSWP1_400/101479JAGUAR C 500 25 KG PAPER BAG (55.115 LB)02677424 Vernon20220.784628254310.8785866762Manual data from expertMandatory?Mandatory field; Must be filled. Validation if the GBU exists.Mandatory field; Must be filled inMandatory field; Must be filled inMandatory field; Must be filled inMandatory field; Must be filled inMandatory field; Must be filled inMandatory field; Must be filled inNot mandatory field. If the field is filled, the values should be between 0 and 1Not mandatory field. If the field is filled, the values should be between 1 and 3Not mandatory field.Data typestringstringstringstringstringstringfloat >= 0float between 0 and 1float between 1 and 3stringField Description
DESCRIPTIONSAP code of the Global Business Unit
(CS for Novecare, SP for Speciality Polymers, TS for Technology Solutions, etc
.
)
Unique SAP code assigned to the finished product
for identification in SAP
. Cannot be cross-validated against master data during upload.Name of the finished product as registered in SAP. Cannot be cross-validated against master data during upload.Unique SAP code assigned
(for identification in SAP)
to the plant where the
material
finished product is produced. Cannot be cross-validated against master data during upload.Name of the plant where the
material
finished product is produced
Year
. Cannot be cross-validated against master data during upload.Calendar year for which the PCF is manually imported.Global
PCF (carbon footprint
Product Carbon Footprint (kgCO₂e/kg) for the finished product, manually entered by the data owner. An error message will be sent to the data owner if this field is missing or invalid.Primary Data Share
=
: proportion of PCF data
that is
collected directly from suppliers
, as opposed to secondary data which is
rather than derived from generic databases
such as EcoInvent
(e.g. EcoInvent). A warning message will be sent to the data owner if the value is out of range.Data Quality Rating
=
: measure of the data quality of the emissions in the footprint
, number of 1-3, with 1 being the best possible score Notes added by the data owner to highlight or explain the data insertedCommentAs we don't have master data tables, we cannot validate whether the values exist or not through comparison.As we don't have master data tables, we cannot validate whether the values exist or not through comparison.As we don't have master data tables, we cannot validate whether the values exist or not through comparison.As we don't have master data tables, we cannot validate whether the values exist or not through comparison.As we don't have master data tables, we cannot validate whether the values exist or not through comparison.An error message should be sent to the Data Owner.A warning message should be sent to the Data Owner.A warning message should be sent to the Data Owner.
. 1 = best possible score, 3 = lowest. A warning message will be sent to the data owner if the value is out of range.
DATA TYPEStringStringStringStringStringStringFloat ≥ 0Float 0–1Float 1–3
MANDATORYYESYESYESYESYESYESYESNONO
VALIDATION / ALLOWED VALUESe.g. CS (Novecare), SP (Specialty Polymers), TS (Technology Solutions). Validated against known GBU list.e.g. WP1_400/101479Free text; must match SAP recorde.g. 267, 0246e.g. 7424 Vernone.g. 2022, 2023, 2024Must be a non-negative floatBetween 0 and 1Between 1 and 3 (1 = best)


3. Filling instructions

Sheet NameInstructions
Sheet1

•  Complete all mandatory fields for every row. Rows with missing mandatory values will be rejected during upload.

•  GBU must match a valid GBU code (e.g. CS, SP, TS). Values not in the validated list will be rejected.

•  PCF_finish_product is mandatory and must be a non-negative float (≥ 0). An error message will be sent to the data owner if this value is missing or invalid.

•  PDS_finish_product, if filled, must be a float between 0 and 1. A warning message will be sent to the data owner if the value is out of range.

•  DQR_finish_product, if filled, must be a float between 1 and 3. A warning message will be sent to the data owner if the value is out of range.

•  Finish_Product_Code, Finish_Product_Name, Plant_Code, and Plant_Name cannot be cross-validated against SAP master data during upload. Please ensure these values are accurate.

•  Use the Comment field to document the source and methodology of the manual PCF calculation (e.g. "Manual data from expert").

•  Do not modify, add, or remove columns.

•  Duplicate rows (same GBU + Finish_Product_Code + Plant_Code + Activity_Year) will be rejected during data upload. Ensure no duplicate entries are present.

•  Do not leave mandatory fields blank.


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 ownerHubert Sizaret
Technical SupportCamille Faure Laëtitia Arantes

The data owner Data Owner - Hubert Sizaret and Damien Bourcier (the data owner will receive the error file by email and will be responsible for making any necessary manual corrections.). 
For any questions or issues, please contact the responsible person listed above.
Please strictly follow these guidelines to ensure data quality and reliability.