File link:  

1. Purpose of the file: 

This sheet is used to collect, track qualification on biogenic carbon and related data for finished products at the plant and material level. 
It centralizes information on product characteristics, calculation results, validation status, and relevant metadata. 
The data supports the monitoring and reporting of biogenic carbon content and other sustainability metrics across different sites and business units.

Most fields are automatically exported by the digital tool and should not be modified by the user. 
Only specific fields require user input to ensure data accuracy and completeness.


2. File Structure

2.1. List of tabs

Sheet NameDescriptionMandatoryComment
Biogenic_ValidationThis sheet is used to collect, track qualification on biogenic carbon and related data for finished products at the plant and material level. YESDon't delete this sheet


2.2. Main columns description
SHEET: Biogenic_Validation


gbusite_codesite_nameplant_codeplant_namematerial_codematerial_nameprod_yearproduct_typebom_balancetcc_rm_mappedbcc_finalrci_fptcc_fp_estimatedsource_biogenic_fpsource_biogenic_fp_commentfact_biogenic_is_validfact_biogenic_meta_insert_datefact_biogenic_meta_run_idfact_biogenic_meta_updated_datevalidation_inputcommentlast_validated_valuelast_bcc_finallast_rci_fplast_tcc_fp_estimatedbcc_valid_idlast_validated_commentvalidation_insert_date
Field DescriptionSAP code of the Global Business Unit (CS for Novecare, SP for Speciality Polymers, TS for Technology Solutions, etc.)Unique code assigned (for identification in Cerise) to the site where the material is producedName of the site where the material is producedUnique code assigned (for identification in SAP) to the plant where the material is produced Name of the plant where the material is producedUnique code assigned to the material for identification in SAPName of the material in SAPYear for which the biogenic KPIs are computedIndicates if the product is simple (only the Finished product is produced during the process) or complex (BOM recipe contains materials produced simultaneously with the Finished product)

Proportion of raw materials in the Bill of Materials (BOM) of the finished product. This value indicates the share of unmodified raw materials relative to the total composition of the finished product.

Indicates Percentage of raw material quantity for which the Total Carbon Content has been mappedFinal calculated value of Biogenic Carbon Content for the finished productRenewable Carbon Index of the material: percentage (%) of carbon in the material that comes from renewable sources, representing the ratio of renewable or biogenic carbon (BCC) to the total carbon content (TCC)Total Carbon Content of the material: amount of carbon present in one kilogram of a product, measured in kgC / kg of materialSource of biogenic data: can be manually imported ("Manual FP Biogenic") or computed by the PCF tool ("Computed FP biogenic")Comment on biogenic data (especially for manual import)Indicator confirming that the data is the most recent, valid, and relevantDate on which the data was first calculatedUnique identifier assigned to the specific calculation processDate on which the data was most recently updatedEvaluation of the data by the data owner = must be either YES or NONotes added by the data owner to highlight or explain the data insertedMost recent validation status (YES or NO) that was validated for the productMost recent final value of Biogenic Carbon Content validated for the productMost recent final value of Renewable Carbon Index validated for the productMost recent final value of Total Carbon Content validated for the productUnique identifier for the LAST biogenic carbon content validation recordMost recent comment associated with the validation processDate when the validation record was inserted
Data typeStringStringStringStringStringStringStringString YYYYStringFloatFloatFloatFloatFloatStringStringStringStringStringStringString / YES or NO onlyStringStringFloatFloatFloatStringStringString
SAMPLECS1869MEREVILLE40066422 MerevilleWP2_400/323578PERIDIAM EXTRA 317 1X200L DRM2024COMPLEX0.92624991661000.165Computed FP biogenic
YES2025-07-16 1:55:00b6T3F12025-08-28 12:58:44

YES000.1646553717

10f37e036ca512add92e8a6c9e3b9466


2025-07-09 5:43:08
MANDATORY / USER INPUT REQUIREDYES / Exported from PCF digital toolYES / Exported from PCF digital toolNO / Exported from PCF digital toolYES / Exported from PCF digital toolNO / Exported from PCF digital toolYES / Exported from PCF digital toolNO / Exported from PCF digital toolYES / Exported from PCF digital toolNO / Exported from PCF digital toolYES / Exported from PCF digital toolYES / Exported from PCF digital toolNO / Exported from PCF digital toolNO / Exported from PCF digital toolNO / Exported from PCF digital toolNO / Exported from PCF digital toolNO / Exported from PCF digital toolNO / Exported from PCF digital toolNO / Exported from PCF digital tool for WP2 onlyNO / Exported from PCF digital tool for WP2 onlyNO / Exported from PCF digital tool for WP2 onlyYES / INPUT REQUIRED / MANDATORYYES / INPUT REQUIRED / MANDATORYNO / Exported from PCF digital toolNO / Exported from PCF digital toolNO / Exported from PCF digital toolNO / Exported from PCF digital toolNO / Exported from PCF digital toolNO / Exported from PCF digital toolNO / Exported from PCF digital tool


3. Filling instructions

Sheet NameInstructions


Sheet1• Fields to Complete (User Input Required):
→ validation_input: Enter the input or value used for validation purposes. This field is mandatory. Values = YES or NO only
→ comment: Provide any additional comments or notes regarding the validation. This field is optional.

• Fields Not to Edit:
→ All other fields are automatically exported from the PCF digital tool and must not be modified, deleted, or overwritten by the user.
→ This includes all identification, calculation, and metadata fields (e.g., gbu, site_code, plant_code, material_code, prod_year, bom_balance, tcc_rm_mapped, bcc_final, rci_fp, tcc_fp_estimated, etc.).


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
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 is exported from Fact PCF table; Gsheet to be completed by Process Owner.


gbusite_codesite_nameplant_codeplant_namematerial_codematerial_nameprod_yearproduct_typebom_balancetcc_rm_mappedbcc_finalrci_fptcc_fp_estimatedSource_biogenic_fpfact_biogenic_is_validfact_biogenic_meta_insert_datefact_biogenic_meta_run_idfact_biogenic_meta_updated_datevalidation_inputcomment
Sample DataCS1307ZHANGJIAGANG (FENG HUANG TOWN)81606526 ZhangjiagangWP1_400/101478JAGUAR C 500 BULK2022SIMPLE0.8376430.983673


Manual FP biogenicYES2024-04-11 16:46:14qbIFs42024-05-23 20:47:25yestest
Mandatory?Mandatory field; Must be filledMandatory field; Must be filledNot mandatory field.Mandatory field; Must be filledNot mandatory field.Mandatory field; Must be filledNot mandatory field.Mandatory field; Must be filledNot mandatory field.Mandatory field; Must be filledMandatory field; Must be filledNot mandatory field.Not mandatory field.Not mandatory field.Mandatory field; Must be filledMandatory field; Must be filledMandatory field; Must be filledMandatory field; Must be filledMandatory field; Must be filledNot mandatory field.Not mandatory field.
Data typeSTRINGSTRINGSTRINGSTRINGSTRINGSTRINGSTRINGSTRINGSTRINGFLOATFLOATFLOATFLOATFLOATSTRINGSTRINGTIMESTAMPSTRINGTIMESTAMPSTRINGSTRING
Field DescriptionSAP code of the Global Business Unit (CS for Novecare, SP for Speciality Polymers, TS for Technology Solutions, etc.)Unique code assigned (for identification in Cerise) to the site where the material is producedName of the site where the material is producedUnique code assigned (for identification in SAP) to the plant where the material is produced Name of the plant where the material is producedUnique code assigned to the material for identification in SAPName of the material in SAPYear for which the biogenic KPIs are computedIndicates if the product is simple (only the Finished product is produced during the process) or complex (BOM recipe contains materials produced simultaneously with the Finished product)

Proportion of raw materials quantities compared to the finish product quantity

Proportion of raw materials in the finished product recipe (BOM) for which biogenic data (TCC) is availableBiogenic Carbon Content of the material: amount of carbon in the finished product that is derived from renewable biological sources, measured in kgC per kg of product.  BCC = TCC * RCIRenewable Carbon Index of the material: percentage (%) of carbon in the material that comes from renewable sources, representing the ratio of renewable or biogenic carbon (BCC) to the total carbon content (TCC)Total Carbon Content of the material: amount of carbon present in one kilogram of a product, measured in kgC / kg of materialSource of biogenic data: can be manually imported ("Manual FP Biogenic") or computed by the PCF tool ("Computed FP biogenic")Indicator confirming that the data is the most recent, valid, and relevantDate on which the data was first calculatedUnique identifier assigned to the specific calculation processDate on which the data was most recently updatedEvaluation of the data by the data owner = must be either YES or NONotes added by the data owner to highlight or explain the data inserted
Comment













Only 2 possible values: "Manual FP biogenic" or "Computed FP biogenic"



YES or NO only


Data Owner - TBD