Scope 1, Scope 2 and Scope 3.3: 

General informations: 

Data Source: CERISE and BOM

Extraction with specific filters: 

Data sourceExtraction with specific filters
CERISE

Prod_Conso_Indic = 'P'

specific Vector code or Vector group

Unit conversion 

BOM

specific Activity code 

Unit conversion

Type of energy:

Energy typeBOM Activity_codeBOM Activity_nameCerise Vector Unit conversion
Electricity

contains  “/ELEC”

ELECTRICITY, Electricity, Z025/ELEC

For site CLAMECY , MELLE - ST LEGER DE LA MARTINIERE,  OLDBURY (TRINITY STREET), ZHANGJIAGANG (FENG HUANG TOWN): Vector_code= UT_EL_DIS and Prod_Conso_Indic = 'P'

For all others Site: VECTOR_GROUP= 'PU_EL_REN','PU_EL_NREN', 'PU_EL_SOL'


Unit = MWH

Conversion WHEN:

  • Unit = 'KWH' THEN Adjusted Qty / 1000
  • Unit = 'MEJ'  THEN  Adjusted Qty / 3600
  • Unit = 'BZ'     THEN  Adjusted Qty * 0.29307
  • Unit = 'BTU’'  THEN  Adjusted Qty * 0.293071 *10^-6

  • Unit = 'KCA’'  THEN  Adjusted Qty * 1,16222 10^-6

Exclude when other unit

Gas

contains  “/GA”

GAS, Gas, Natural Ga

For site CLAMECY , MELLE - ST LEGER DE LA MARTINIERE,  OLDBURY (TRINITY STREET), ZHANGJIAGANG (FENG HUANG TOWN): Vector_code= UT_GAS and Prod_Conso_Indic = 'P'

For all others Site: VECTOR_GROUP= ''PU_FU_GASEOUS' or 'PU_GAS'

Stream

contains  “/STE”

Medium pressure stea

STEAM

STEAM

Steam

Steam - Package

Steam - Package

Steam 30

Steam PE

Z006/STE14

Z006/STEAMP

Z006/STEAMV

Z025/STE14

Z025/STE40

Z025/STE6-5

Z025/STEAM

Z025/STEAMV

Z026/STE14

Z026/STE30

Z026/STE40

Z026/STE6-5

Z028/STE14

Z028/STEAMV

For site CLAMECY , MELLE - ST LEGER DE LA MARTINIERE,  OLDBURY (TRINITY STREET), ZHANGJIAGANG (FENG HUANG TOWN): Vector_code= UT_ST_DIS and Prod_Conso_Indic = 'P'

For all others Site: VECTOR_GROUP= 'PU_ST', 'PU_HE', 'UT_ST_DIS'

Unit = TO

Conversion WHEN:

  • Unit = 'TON', THEN   Adjusted Qty * 0,90718749965598)
  • Unit = 'KG',    THEN   Adjusted Qty / 1000)
  • Unit = 'GT',    THEN   Adjusted Qty * 1.01605 )

  • Unit = 'DTN',    THEN   Adjusted Qty * 0.1 )

  • Unit = 'CWA',    THEN   Adjusted Qty * 45,3592*10^-3 )

Exclude when other unit

Fuel

contains   “/OILLT” or “/FUEL”

Fuel and Oil, Z006/FUEL ,  Z026/FUEL

For all Site except CLAMECY , MELLE - ST LEGER DE LA MARTINIERE,  OLDBURY (TRINITY STREET), ZHANGJIAGANG (FENG HUANG TOWN) : Vector_code= ''PU_FU_LIQUID', 'PU_LFO'





  • No labels