# Line-by-Line - only calculated lines

Note that the Cement CO2 and Energy Protocol and the Protocol Spreadsheet have a specific line number index (see Column B in the Excel® file). These line numbers are used throughout all documents of the Protocol. They differ from the Excel® row numbers. In the Internet Manual, the index of line numbers consists of the word “line” and the line number with three digits. For some lines a small letter is added to the number, e.g. “line059c”.

## Plant Sheet

Table 82: Plant Sheet - Clinker and Cement Production

Line Title Comment

011

 Comment: The calculated value which will be shown in this line (normally only if you have made the entries above) represents the consumed clinker at the plant level which is used for cement production. so you should not enter any values in this line. Formula: IF(COUNTBLANK( ​line008​ : ​line010c​ )=6,"", ​line008​ + ​line009​ - ​line010​ - ​line010a​ + ​line010b​ + ​line010c​ )

Used in lines: ​line020​ , ​line021​ , ​line091​ , ​line092a​ , ​line092

018

Total MIC consumed for Portland and blended cements (dry weight)

 Comment: The value shown in this line is the sum of the values you have entered above in this section. Formula: IF(COUNTBLANK( ​line012​ : ​line017a​ )=7,"",SUM( ​line012​ : ​line017a​ ))

Used in lines: ​line020​ , ​line021​ , ​line021a

019

Total processed MIC's used as clinker or cement substitute sold externally

 Formula: IF(COUNTBLANK( ​line019a​ : ​line019c​ )=3,"",SUM( ​line019a​ : ​line019c​ ))

Used in lines: ​line021​ , ​line021a

020

Total Portland and Blended cements

 Comment: Total cement produced (all types together except pure slag cement and direct fly ash sales) Formula: IF(OR( ​line011​ ="", ​line018​ =""),"", ​line011​ + ​line018​ )

Used in lines: ​line092a

021

Total cements + substitutes: Portland, Blended, Slag, etc.

 Comment: Total cements produced, excluding clinker sold, including clinker bought. Portland + Blended + Slag cements incl. direct fly ash sales Formula: IF(OR( ​line011​ ="", ​line018​ ="", ​line019​ =""),"", ​line011​ + ​line018​ + ​line019​ )

Used in lines: ​line092​ , ​line097​ , ​line098c

021a

Total cementitious products

 Comment: Total clinker produced plus MIC consumed for blending and production of cement substitutes, including clinker sold, excluding clinker bought Formula: IF(OR( ​line008​ ="", ​line018​ ="", ​line019​ =""),"", ​line008​ + ​line018​ + ​line019​ )

Used in lines: ​line062​ , ​line062a​ , ​line062b​ , ​line074​ , ​line082c​ , ​line082a​ , ​line082b

021b

Total cement equivalent

 Comment: Calculated based on Clinker production and Clinker/cement (eq.) ratio Formula: IF(OR( ​line008​ ="", ​line008​ =0, ​line092a​ ="n. appl."),"n. appl.", ​line008​ / ​line092a​ )

Used in lines: ​line063​ , ​line063a​ , ​line063b​ , ​line075​ , ​line082c

### Kiln Fuel Consumption incl. raw material and fuel drying

Table 83: Plant Sheet - Kiln Fuel Consumption incl. raw material and fuel drying

Line Title Comment

025

Total heat consumption of kilns

 Comment: Sum of conventional fossil fuels, alternative fossil fuels, and biomass fuels; including fuels for drying of raw amterials and fuels Formula: IF(COUNTBLANK( ​line026​ : ​line028​ )=3,"",SUM( ​line026​ : ​line028​ ))

Used in lines: ​line025a​ , ​line093​ , ​line094​ , ​line095​ , ​line096​ , ​line096a​ , ​line096b​ , ​line096c​ , ​line096d

025a

Total heat consumption of kilns excluding drying of fuels and raw materials

 Comment: Sum of conventional fossil fuels, alternative fossil fuels, and biomass fuels; excluding fuels for drying of raw amterials and fuels Formula: IF(OR( ​line025​ ="", ​line184​ ="", ​line184g​ ="", ​line184i​ =""),"", ​line025​ - ​line184​ - ​line184g​ - ​line184i​ )

026

Conventional fossil fuels

 Comment: Calculated based on consumption of individual fuels and their lower heating values Formula: IF(OR( ​line161​ ="", ​line184​ =""),"", ​line161​ + ​line184​ )

Used in lines: ​line025​ , ​line094​ , ​line096b

027

Alternative fuels, fossil content; excluding biomass fraction of mixed fuels

 Comment: Calculated based on consumption of individual fuels and their lower heating values Formula: IF(OR( ​line168​ ="", ​line184g​ =""),"", ​line168​ + ​line184g​ )

Used in lines: ​line025​ , ​line095​ , ​line096c

028

Biomass fuels, incl. biomass content of alternative fuels

 Comment: Calculated based on consumption of individual fuels and their lower heating values Formula: IF(OR( ​line175​ ="", ​line184i​ =""),"", ​line175​ + ​line184i​ )

Used in lines: ​line025​ , ​line096​ , ​line096d

### Non-Kiln Fuel Consumption

Table 84: Plant Sheet - Non-Kiln Fuel Consumption

Line Title Comment

030

Equipment and on-site vehicles

 Comment: Fuel used for quarry equipment and vehicles for internal transport Formula: ​line321​ + ​line321c​

Used in lines: ​line032

031a

Room heating and cooling

 Comment: Fuel used for office heating Formula: ​line322​

Used in lines: ​line032

031b

Drying of mineral components

 Comment: Fuel used for drying of mineral components Formula: IF(OR( ​line323k​ ="", ​line323g​ ="", ​line323i​ =""),"", ​line323k​ + ​line323g​ + ​line323i​ )

Used in lines: ​line032

031c

On-site power generation

 Comment: Fuel used for power generation on-site (autoproduction) Formula: IF(OR( ​line324aa​ ="", ​line324f​ ="", ​line324h​ =""),"", ​line324aa​ + ​line324f​ + ​line324h​ )

Used in lines: ​line032

032

Total non-kiln fuel consumption

 Formula: IF(COUNTBLANK( ​line030​ : ​line031c​ )=4,"",SUM( ​line030​ : ​line031c​ ))

### Power Balance

Table 85: Plant Sheet - Power Balance

Line Title Comment

033ac

Power consumed by on-site power generation equipment

 Comment: Power consumed in the power plant from separate on-site power generation in Mega Watt hours per year Formula: IF(OR( ​line033a​ ="", ​line033aa​ ="", ​line033ab​ =""),"", ​line033a​ - ​line033aa​ - ​line033ab​ )

CO2 per power unit produced by separate on-site power generation

 Comment: CO2 emission factor of power produced by on-site power generation Formula: IF( ​line033a​ =0,"", ​line045c​ / ​line033a​ *1000)

033bc

Power consumed by waste heat recovery equipment

 Comment: Power consumed in the power plant from waste heat recovery in Mega Watt hours per year Formula: IF(OR( ​line033b​ ="", ​line033ba​ ="", ​line033bb​ =""),"", ​line033b​ - ​line033ba​ - ​line033bb​ )

033c

Total external power consumption for cement manufacturing

 Comment: Power consumption for cement manufacturing including power plant (own consumption) obtained from the external grid or supplier Formula: IF(COUNTBLANK( ​line033ca​ : ​line033cc​ )=3,"",SUM( ​line033ca​ : ​line033cc​ ))

Used in lines: ​line049a

033

Total cement plant power consumption

 Formula: IF(AND( ​line033aa​ =0, ​line033ba​ =0, ​line033ca​ =""),"", ​line033aa​ + ​line033ba​ + ​line033ca​ )

Used in lines: ​line097​ , ​line098c

### CO2 from Raw Materials

Table 86: Plant Sheet - CO2 from Raw Materials

Line Title Comment

035a

Calcination emission factor, corrected for CaO- and MgO imports

 Comment: B1: Default set equal to 525 kg CO2/ t clinker. B2: To be replaced with more precise data by Company if available (see auxiliary sheet "CalcB2") Formula: IF( ​line034d​ ="B2", ​line034q​ ,IF( ​line034d​ ="B1", ​line034m​ ,"n. appl."))

Used in lines: ​line036​ , ​line037​ , ​line038a

035b

Organic carbon content of raw meal (average)

 Comment: B1, B2: Default set equal to 0.2%. To be replaced with company-specific data if raw materials with substantially higher or lower content of organic carbon are used. See Guidance document for details. Formula: IF( ​line034d​ ="B1", ​line034n​ ,IF( ​line034d​ ="B2", ​line034r​ ,"n. appl."))

Used in lines: ​line038b

035c

 Comment: B1, B2: Default set equal to 1.55. To be replaced with company-specific data (excluding fuel ash content) if organic carbon in raw materials is of relevance. Any dust leaving the kiln system should be reflected in this ratio. Ash content of fuels should be excluded. Formula: IF( ​line034d​ ="B1", ​line034o​ ,IF( ​line034d​ ="B2", ​line034s​ ,"n. appl."))

Used in lines: ​line035d

035d

Raw meal consumption

 Comment: A1, A2: Input from auxilary sheet "CalcA1", "CalcA2". B1, B2: Calculated from the raw meal : clinker ratio and the amount of clinker produced Formula: IF( ​line034d​ ="A1", ​line034e​ ,IF( ​line034d​ ="A2", ​line034i​ ,IF( ​line008​ ="","", ​line008​ * ​line035c​ )))

Used in lines: ​line038b

036

CO2 from calcination of raw materials consumed for clinker production

 Comment: B1, B2: Calculated from the calcination emission factor and the clinker production Formula: IF(OR( ​line034d​ ="A1", ​line034d​ ="A2"),"n. appl.",IF( ​line008​ ="","", ​line035a​ /1000* ​line008​ ))

Used in lines: ​line039

037

CO2 from calcination of bypass dust leaving the kiln system

 Comment: B1, B2: Calculated from the calcination emission factor and the amount of bypass dust leaving the kiln system (e.g. for landfilling) Formula: IF(OR( ​line034d​ ="A1", ​line034d​ ="A2"),"n. appl.",IF( ​line022​ ="","", ​line035a​ /1000* ​line022​ ))

Used in lines: ​line039

038a

CO2 from calcination of CKD leaving the kiln system

 Comment: B1, B2: Calculated from the calcination emission factor, the amount of CKD leaving the kiln system (e.g. for landfilling or sale), and the calcination rate of CKD Formula: IF(OR( ​line034d​ ="A1", ​line034d​ ="A2"),"n. appl.",IF( ​line023​ ="","", ​line023​ * ​line035a​ /1000/(1+ ​line035a​ /1000)* ​line024​ /(1- ​line035a​ /1000/(1+ ​line035a​ /1000)* ​line024​ )))

Used in lines: ​line039

038b

CO2 from organic carbon content of raw meal

 Comment: B1, B2: Calculated from the organic carbon content of raw meal, the raw meal consumption, and the CO2 to C molar weight ratio Formula: IF(OR( ​line034d​ ="A1", ​line034d​ ="A2"),"n. appl.",IF( ​line035d​ ="","", ​line035b​ * ​line035d​ *3.664))

Used in lines: ​line039

039

Total CO2 from raw materials

 Comment: A1, A2: Input from auxilary sheet "CalcA1", "CalcA2". B1, B2 Formula: IF( ​line034d​ ="A1", ​line034f​ ,IF( ​line034d​ ="A2", ​line034j​ ,SUM( ​line036​ : ​line038b​ )))

Used in lines: ​line048​ , ​line059​ , ​line059a

### CO2 from Kiln Fuels (incl. drying of fuels and raw materials)

Table 87: Plant Sheet - CO2 from Kiln Fuels (incl. drying of fuels and raw materials)

Line Title Comment

040

CO2 from conventional fossil fuels

 Comment: Sum of CO2 emissions from conventional fossil fuels, including drying of fuels and raw materials Formula: IF(OR( ​line211​ ="", ​line234​ =""),"", ​line211​ + ​line234​ )

Used in lines: ​line043

041

CO2 from alternative fossil fuels

 Comment: Sum of CO2 emissions from alternative fossil fuels, including drying of fuels and raw materials Formula: IF(OR( ​line218​ ="", ​line235​ =""),"", ​line218​ + ​line235​ )

Used in lines: ​line043​ , ​line071

043

Total CO2 from fossil-based kiln fuels

 Formula: IF(COUNTBLANK( ​line040​ : ​line041​ )=2,"",SUM( ​line040​ : ​line041​ ))

Used in lines: ​line048​ , ​line059​ , ​line059b​ , ​line096a

### CO2 from Non-Kiln Fuels

Table 88: Plant Sheet - CO2 from Non-Kiln Fuels

Line Title Comment

044

CO2 from equipment and on-site vehicles (fossil fuels)

 Comment: Sum of CO2 emissions from equipment and on-site vehicles Formula: ​line331​

Used in lines: ​line046​ , ​line059b

045a

CO2 from room heating and cooling (fossil fuels)

 Comment: Sum of CO2 emissions from room heating and cooling Formula: ​line332​

Used in lines: ​line046​ , ​line059b

045b

CO2 from drying of mineral components (fossil fuels)

 Comment: Sum of CO2 emissions from drying of mineral components Formula: IF(OR( ​line333k​ ="", ​line333g​ =""),"", ​line333k​ + ​line333g​ )

Used in lines: ​line046​ , ​line059b

045c

CO2 from seperate on-site power generation (fossil fuels)

 Comment: Sum of CO2 emissions from on-site power generation (excl. biomass CO2) Formula: IF(OR( ​line334aa​ ="", ​line334f​ =""),"", ​line334aa​ + ​line334f​ )

Used in lines: ​line033ad​ , ​line046​ , ​line059c

046

Total CO2 from non-kiln fossil fuels

 Formula: IF(COUNTBLANK( ​line044​ : ​line045c​ )=4,"",SUM( ​line044​ : ​line045c​ ))

Used in lines: ​line048​ , ​line059

### Total Direct CO2 Emissions

Table 89: Plant Sheet - Total Direct CO2 Emissions

Line Title Comment

048

Total direct CO2: all fossil CO2 sources

 Formula: IF(OR( ​line039​ ="", ​line043​ ="", ​line046​ =""),"", ​line039​ + ​line043​ + ​line046​ )

### Indirect CO2 Emissions (Main Sources)

Table 90: Plant Sheet - Indirect CO2 Emissions (Main Sources)

Line Title Comment

049a

CO2 from external power generation

 Formula: IF( ​line033c​ =0,"", ​line033c​ * ​line033d​ /1000)

Used in lines: ​line049d​ , ​line082c​ , ​line082a

049c

CO2 from net inbound (+) / outbound (-) clinker

 Comment: Calculated by multiplying net clinker imports (= clinker bought minus clinker sold, including clinker transfers) by the default emission factor for bought clinker and subtracting CO2 emissions from sold clinker. Value will be negative if plant is net exporter of clinker. ; =(((line9 + line10b + line10c) * line49b) - (line10 * line60)) / 1000. Formula: IF(OR( ​line009​ ="", ​line010b​ ="", ​line010c​ ="", ​line010​ =""),"",IF( ​line060​ <>"n. appl.",((( ​line009​ + ​line010b​ + ​line010c​ )* ​line049b​ )-( ​line010​ * ​line060​ ))/1000,( ​line009​ + ​line010b​ + ​line010c​ )* ​line049b​ /1000))

Used in lines: ​line049d​ , ​line082b

049d

Total indirect CO2 (main sources)

 Formula: IF(OR( ​line049a​ ="", ​line049c​ =""),"", ​line049a​ + ​line049c​ )

### Direct CO2 from Biomass Fuels (Memo Item)

Table 91: Plant Sheet - Direct CO2 from Biomass Fuels (Memo Item)

Line Title Comment

050

CO2 from combustion of biomass (kiln and non-kiln fuels, incl. biomass content of mixed fuels)

 Comment: Direct CO2 emissions from combustion of kiln and non-kiln biomass fuels and biomass content of mixed fuels Formula: IF(OR( ​line225​ ="", ​line236​ ="", ​line331c​ ="", ​line333i​ ="", ​line334h​ =""),"", ​line225​ + ​line236​ + ​line331c​ + ​line333i​ + ​line334h​ )

Used in lines: ​line083a

### Gross CO2 Emissions (= total direct CO2; all sources), excluding CO2 from onsite power generation

Table 92: Plant Sheet - Gross CO2 Emissions (= total direct CO2; all sources), excluding CO2 from onsite power generation

Line Title Comment

059

Absolute gross CO2 including CO2 from on-site power generation

This line is marked as KPI.

 Comment: Total direct emissions from raw materials, kiln fuels and non-kiln fuels Formula: IF(OR( ​line039​ ="", ​line043​ ="", ​line046​ =""),"", ​line039​ + ​line043​ + ​line046​ )

Used in lines: ​line059c

059c

Absolute gross CO2

This line is marked as KPI.

 Comment: Total direct emissions from raw materials, kiln fuels and non-kiln fuels; excluding CO2 from on-site power generation ; Formula: IF(OR( ​line059​ ="", ​line045c​ =""),"", ​line059​ - ​line045c​ )

Used in lines: ​line071​ , ​line060​ , ​line063​ , ​line062

059a

calcination component

This line is marked as KPI.

 Comment: Direct emissions from raw materials; ; Formula: ​line039​

Used in lines: ​line060a​ , ​line063a​ , ​line062a

059b

fuel component

This line is marked as KPI.

 Comment: Direct emissions from kiln fuels and non-kiln fuels, excluding CO2 from on-site power generation Formula: IF(OR( ​line043​ ="", ​line044​ ="", ​line045a​ ="", ​line045b​ =""),"", ​line043​ + ​line044​ + ​line045a​ + ​line045b​ )

Used in lines: ​line060b​ , ​line063b​ , ​line062b

071

Absolute net CO2

This line is marked as KPI.

 Comment: Total direct emissions from raw materials, kiln fuels and non-kiln fuels, excluding CO2 from on-site power generation, minus alternative fossil fuels Formula: IF(OR( ​line059c​ ="", ​line041​ =""),"", ​line059c​ - ​line041​ )

Used in lines: ​line073​ , ​line075​ , ​line074

083a

Absolute CO2 from biomass sources (including biomass content of mixed fuels)

This line is marked as KPI.

 Formula: ​line050​

### Specific Gross and Net CO2 Emissions per Clinker Produced

Table 93: Plant Sheet - Specific Gross and Net CO2 Emissions per Clinker Produced

Line Title Comment

060

Specific gross CO2 per tonne of clinker produced

This line is marked as KPI.

 Comment: Total direct emissions, excluding CO2 from on-site power generation, divided by own clinker production Formula: IF( ​line008​ ="","",IF( ​line008​ =0,"n. appl.", ​line059c​ / ​line008​ *1000))

Used in lines: ​line049c

060a

calcination component

This line is marked as KPI.

 Comment: Direct emissions from raw materials, divided by own clinker production Formula: IF( ​line008​ ="","",IF( ​line008​ =0,"n. appl.", ​line059a​ / ​line008​ *1000))

060b

fuel component

This line is marked as KPI.

 Comment: Direct emissions from kiln fuels and non-kiln fuels, excluding CO2 from on-site power generation, divided by own clinker production Formula: IF( ​line008​ ="","",IF( ​line008​ =0,"n. appl.", ​line059b​ / ​line008​ *1000))

073

Specific net CO2 per tonne of clinker produced

This line is marked as KPI.

 Comment: Net emissions from raw materials, kiln fuels and non-kiln fuels, excluding CO2 from on-site power generation, divided by own clinker production Formula: IF( ​line008​ ="","",IF( ​line008​ =0,"n. appl.", ​line071​ / ​line008​ *1000))

### Specific Gross and Net CO2 Emissions per Cement (equivalent)

Table 94: Plant Sheet - Specific Gross and Net CO2 Emissions per Cement (equivalent)

Line Title Comment

063

Specific gross CO2per tonne of cement (eq.)

This line is marked as KPI.

 Comment: Total direct emissions, excluding CO2 from on-site power generation, divided by total cement (equivalent) Formula: IF(OR( ​line059c​ ="", ​line021b​ ="n. appl."),"n. appl.", ​line059c​ / ​line021b​ *1000)

063a

calcination component

This line is marked as KPI.

 Comment: Direct emissions from raw materials, divided by total cement (equivalent) Formula: IF( ​line008​ ="","",IF(OR( ​line008​ =0, ​line011​ =0),"n. appl.", ​line059a​ / ​line021b​ *1000))

063b

fuel component

This line is marked as KPI.

 Comment: Direct emissions from kiln fuels and non-kiln fuels, excluding CO2 from on-site power generation, divided by total cement (equivalent) Formula: IF( ​line008​ ="","",IF(OR( ​line008​ =0, ​line011​ =0),"n. appl.", ​line059b​ / ​line021b​ *1000))

075

Specific net CO2 per tonne of cement (eq.)

This line is marked as KPI.

 Comment: Net emissions from raw materials, kiln fuels and non-kiln fuels, excluding CO2 from on-site power generation, divided by own production of cement (equivalent) Formula: IF(OR( ​line021b​ ="n. appl.", ​line021b​ =0),"n. appl.", ​line071​ / ​line021b​ *1000)

### Specific Gross and Net CO2 Emissions per Cementitious Produced

Table 95: Plant Sheet - Specific Gross and Net CO2 Emissions per Cementitious Produced

Line Title Comment

062

Specific gross CO2 per tonne of cementitious product

This line is marked as KPI.

 Comment: Total direct emissions, excluding CO2 from on-site power generation, divided by own production of cementitious products (excluding bought clinker in cement) Formula: IF( ​line021a​ ="","",IF( ​line021a​ =0,"n. appl.", ​line059c​ / ​line021a​ *1000))

062a

calcination component

This line is marked as KPI.

 Comment: Direct emissions from raw material calcination, divided by own production of cementitious products Formula: IF( ​line021a​ ="","",IF( ​line021a​ =0,"n. appl.", ​line059a​ / ​line021a​ *1000))

062b

fuel component

This line is marked as KPI.

 Comment: Direct emissions from kiln fuels and non-kiln fuels, excluding CO2 from on-site power generation, divided by own production of cementitious products Formula: IF( ​line021a​ ="","",IF( ​line021a​ =0,"n. appl.", ​line059b​ / ​line021a​ *1000))

074

Specific net CO2 per tonne of cementitious product

This line is marked as KPI.

 Comment: Net emissions from raw materials, kiln fuels and non-kiln fuels, excluding CO2 from on-site power generation, divided by own production of cementitious products Formula: IF( ​line021a​ ="","",IF( ​line021a​ =0,"n. appl.", ​line071​ / ​line021a​ *1000))

Used in lines: ​line077

077

Improvement rate - net CO2 per tonne of cementitious product

This line is marked as KPI.

 Comment: Reduction of specific emissions relative to base year (default 1990) Formula: IF( ​line074​ ="","",IF(OR( ​line074​ ="n. appl.", ​line074​ =0),"n. appl.",( ​line074​ - ​line074​ )/ ​line074​ ))

### Specific CO2 from Indirect and Biomass Sources

Table 96: Plant Sheet - Specific CO2 from Indirect and Biomass Sources

Line Title Comment

082c

Specific indirect CO2 from external power generation per tonne of cement (eq.)

This line is marked as KPI.

 Formula: IF(OR( ​line021b​ ="n. appl.", ​line021b​ =0),"n. appl.", ​line049a​ / ​line021b​ *1000)

082a

Specific indirect CO2 from external power generation per tonne of cementitious product

This line is marked as KPI.

 Formula: IF( ​line021a​ ="","",IF( ​line021a​ =0,"n. appl.", ​line049a​ / ​line021a​ *1000))

082b

Specific indirect CO2 from net clinker imports (+) / exports (-) per tonne of cementitious product

This line is marked as KPI.

 Formula: IF( ​line021a​ ="","",IF( ​line021a​ =0,"n. appl.", ​line049c​ / ​line021a​ *1000))

### General Performance Indicators

Table 97: Plant Sheet - General Performance Indicators

Line Title Comment

091

This line is marked as KPI.

 Comment: percentage of direct clinker sales versus clinker consumed to produce cement Formula: IF( ​line011​ ="","",IF( ​line011​ =0,"n. appl.",( ​line010​ - ​line009​ - ​line010b​ - ​line010c​ )/ ​line011​ ))

092a

This line is marked as KPI.

Used in lines: ​line021b

092

This line is marked as KPI.

 Comment: Total clinker consumed divided by the total of cements produced Comment: * Clinker/cementitious factor Definition of clinker / cementitious factor as in Protocol Guidance Document Version 3, Section 6.3. The factor is based on clinker consumption. Hence, in the denominator sold clinker is excluded and bought clinker is included. Furthermore, cement substitutes are included. See also the equation for its calculation in the comment sheet. Formula: IF( ​line021​ ="","",IF( ​line021​ =0,"n. appl.", ​line011​ / ​line021​ ))

Used in lines: ​line098c

093

Specific heat consumption of clinker production

This line is marked as KPI.

 Comment: Total heat consumption of kilns divided by the clinker production Formula: IF( ​line008​ ="","",IF( ​line008​ =0,"n. appl.", ​line025​ *10^6/ ​line008​ ))

Used in lines: ​line098b

094

Conventional fossil fuel rate (kiln fuels)

This line is marked as KPI.

 Comment: Consumption of conventional fossil fuels divided by the total heat consumption of kilns Formula: IF( ​line025​ ="","",IF( ​line025​ =0,"n. appl.", ​line026​ / ​line025​ ))

095

Alternative fossil fuel rate (kiln fuels)

This line is marked as KPI.

 Comment: Consumption of alternative fossil fuels divided by the total heat consumption of kilns Formula: IF( ​line025​ ="","",IF( ​line025​ =0,"n. appl.", ​line027​ / ​line025​ ))

096

Biomass fuel rate (kiln fuels)

This line is marked as KPI.

 Comment: Consumption of biomass fuels divided by the total heat consumption of kilns Formula: IF( ​line025​ ="","",IF( ​line025​ =0,"n. appl.", ​line028​ / ​line025​ ))

096a

CO2 emission factor for kiln fuel mix

This line is marked as KPI.

 Comment: Total CO2 from fossil-based kiln fuels divided by total heat consumption of kilns Formula: IF( ​line043​ ="","",IF( ​line043​ =0,"n. appl.", ​line043​ / ​line025​ ))

096b

Total conventional fossil fuel rate at plant level

This line is marked as KPI.

 Comment: Total conventional fossil fuel energy used in the whole plant divided by total fuel energy use in % Formula: IF(AND( ​line025​ =0, ​line321​ =0, ​line321c​ =0, ​line322​ =0, ​line323k​ =0, ​line323g​ =0, ​line323i​ =0, ​line324aa​ =0, ​line324f​ =0, ​line324h​ =0),"n. appl.",( ​line026​ + ​line321​ +( ​line321c​ *(1- ​line200g​ ))+ ​line322​ + ​line323k​ + ​line324aa​ )/( ​line025​ + ​line321​ + ​line321c​ + ​line322​ + ​line323k​ + ​line323g​ + ​line323i​ + ​line324aa​ + ​line324f​ + ​line324h​ ))

096c

Total alternative fossil fuel rate at plant level

This line is marked as KPI.

 Comment: Total alternative fossil fuel energy used in the whole plant divided by total fuel energy use in % Formula: IF(AND( ​line025​ =0, ​line321​ =0, ​line321c​ =0, ​line322​ =0, ​line323k​ =0, ​line323g​ =0, ​line323i​ =0, ​line324aa​ =0, ​line324f​ =0, ​line324h​ =0),"n. appl.",( ​line027​ + ​line323g​ + ​line324f​ )/( ​line025​ + ​line321​ + ​line321c​ + ​line322​ + ​line323k​ + ​line323g​ + ​line323i​ + ​line324aa​ + ​line324f​ + ​line324h​ ))

096d

Total biomass fuel rate at plant level

This line is marked as KPI.

 Comment: Total biomass fuel energy used in the whole plant divided by total fuel energy use in % Formula: IF(AND( ​line025​ =0, ​line321​ =0, ​line321c​ =0, ​line322​ =0, ​line323k​ =0, ​line323g​ =0, ​line323i​ =0, ​line324aa​ =0, ​line324f​ =0, ​line324h​ =0),"n. appl.",( ​line028​ +( ​line321c​ * ​line200g​ )+ ​line323i​ + ​line324h​ )/( ​line025​ + ​line321​ + ​line321c​ + ​line322​ + ​line323k​ + ​line323g​ + ​line323i​ + ​line324aa​ + ​line324f​ + ​line324h​ ))

097

Specific total power consumption*

This line is marked as KPI.

 Comment: Total plant power consumption divided by total cements and substitutes produced Comment: * In this KPI the total power consumption is related to the processing of cementitous products. Hence, it is referenced to cements and substitutes produced. In the denominator sold clinker is excluded and bought clinker is included. See also the equation for its calculation in the comment sheet. Note: The reference is different from the definition, which is used to report specific CO2 emissions per ton of cementitous product in the Protocol Guidance Document Version 3, Section 6.2. Formula: IF( ​line021​ ="","",IF( ​line021​ =0,"n. appl.", ​line033​ / ​line021​ *1000))

098

Specific power consumption of clinker production

This line is marked as KPI.

 Comment: Power consumption up to and including clinker production divided by clinker production Formula: IF( ​line008​ ="","",IF( ​line008​ =0,"n. appl.", ​line033e​ / ​line008​ *1000))

Used in lines: ​line098c​ , ​line098b

098c

Specific power consumption of cement production*

This line is marked as KPI.

 Comment: Power consumption of cement production incl. power consumption of production of clinker consumed divided by cement and substitute production Comment: * In this KPI the power consumption of cement production is related to the processing of cementitous products. Hence, it is referenced to cements and substitutes produced. In the denominator sold clinker is excluded and bought clinker is included. See also the equation for its calculation in the comment sheet. Note: The reference is different from the definition, which is used to report specific CO2 emissions per ton of cementitous product in the Protocol Guidance Document Version 3, Section 6.2. Formula: IF(OR( ​line021​ ="", ​line021​ =0),"n. appl.",IF( ​line098​ <>"n. appl.",( ​line098​ * ​line092​ )+( ​line033​ - ​line033e​ )*1000/ ​line021​ ,( ​line033​ - ​line033e​ )*1000/ ​line021​ ))

098a

National energy conversion factor

This line is marked as KPI.

 Comment: Optional parameter

Used in lines: ​line098b

098b

Total energy intensity of clinker production (fuel and power)

This line is marked as KPI.

 Comment: Optional result Formula: IF( ​line098a​ <>"", ​line098​ * ​line098a​ + ​line093​ ,"")

### Kiln Fuel Consumption in terajoules (TJ) per year

Table 98: Plant Sheet - Kiln Fuel Consumption in terajoules (TJ) per year

Line Title Comment

161

Conventional fossil fuels

 Comment: This is the total heat consumption of all conventional fossil kiln fuels. This result is registered in line 26 above Formula: IF(COUNTBLANK( ​line162​ : ​line167a​ )=7,"",SUM( ​line162​ : ​line167a​ ))

Used in lines: ​line026

162

coal + anthracite

 Formula: IF( ​line102​ ="","", ​line102​ * ​line132​ /1000)

Used in lines: ​line161​ , ​line212

163

petrol coke

 Formula: IF( ​line103​ ="","", ​line103​ * ​line133​ /1000)

Used in lines: ​line161​ , ​line213

164

(ultra) heavy fuel

 Formula: IF( ​line104​ ="","", ​line104​ * ​line134​ /1000)

Used in lines: ​line161​ , ​line214

165

diesel oil

 Formula: IF( ​line105​ ="","", ​line105​ * ​line135​ /1000)

Used in lines: ​line161​ , ​line215

166

natural gas

 Formula: IF( ​line106​ ="","", ​line106​ * ​line136​ /1000)

Used in lines: ​line161​ , ​line216

167

shale

 Formula: IF( ​line107​ ="","", ​line107​ * ​line137​ /1000)

Used in lines: ​line161​ , ​line217

167a

lignite

 Formula: IF( ​line107a​ ="","", ​line107a​ * ​line137a​ /1000)

Used in lines: ​line161​ , ​line217a

168

Alternative fossil and mixed fuels, excluding biomass fraction of mixed fuels

 Comment: This is the total heat consumption of all alternative fossil kiln fuels. This result is registered in line 27 above Formula: IF(COUNTBLANK( ​line169​ : ​line174​ )=7,"",SUM( ​line169​ : ​line174​ ))

Used in lines: ​line027

169

waste oil

 Formula: IF( ​line109​ ="","", ​line109​ *( ​line139​ /1000)*(1- ​line200a​ ))

Used in lines: ​line168​ , ​line219

170

tyres

 Formula: IF( ​line110​ ="","", ​line110​ *( ​line140​ /1000)*(1- ​line200b​ ))

Used in lines: ​line168​ , ​line220

171

RDF including plastics

 Formula: IF( ​line111​ ="","", ​line111​ *( ​line141​ /1000)*(1- ​line200c​ ))

Used in lines: ​line168​ , ​line221

172

solvents

 Formula: IF( ​line112​ ="","", ​line112​ *( ​line142​ /1000)*(1- ​line200d​ ))

Used in lines: ​line168​ , ​line222

173

impregnated saw dust

 Formula: IF( ​line113​ ="","", ​line113​ *( ​line143​ /1000)*(1- ​line200e​ ))

Used in lines: ​line168​ , ​line223

173a

mixed industrial waste

 Formula: IF( ​line113a​ ="","", ​line113a​ *( ​line143a​ /1000)*(1- ​line200f​ ))

Used in lines: ​line168​ , ​line223a

174

other fossil based wastes (excl. biomass content of mixed fuels)

 Formula: IF( ​line114​ ="","", ​line114​ *( ​line144​ /1000)*(1- ​line200h​ ))

Used in lines: ​line168​ , ​line224

175

Biomass fuels - total, incl. biomass cont. from alternative fossil fuels

 Comment: This is the total heat consumption of all biomass kiln fuels. This result is registered in line 28 above Formula: IF(COUNTBLANK( ​line176​ : ​line183a​ )=9,"",SUM( ​line176​ : ​line183a​ ))

Used in lines: ​line028

176

sewage sludge

 Formula: IF( ​line116​ ="","", ​line116​ * ​line146​ /1000)

Used in lines: ​line175​ , ​line226

177

wood, non impregnated saw dust

 Formula: IF( ​line117​ ="","", ​line117​ * ​line147​ /1000)

Used in lines: ​line175​ , ​line227

178

paper, carton

 Formula: IF( ​line118​ ="","", ​line118​ * ​line148​ /1000)

Used in lines: ​line175​ , ​line228

179

animal meal

 Formula: IF( ​line119​ ="","", ​line119​ * ​line149​ /1000)

Used in lines: ​line175​ , ​line229

180

animal bone meal

 Formula: IF( ​line120​ ="","", ​line120​ * ​line150​ /1000)

Used in lines: ​line175​ , ​line230

181

animal fat

 Formula: IF( ​line121​ ="","", ​line121​ * ​line151​ /1000)

Used in lines: ​line175​ , ​line231

182

agricultural, organic, diaper waste, charcoal

 Formula: IF( ​line122​ ="","", ​line122​ * ​line152​ /1000)

Used in lines: ​line175​ , ​line232

183

other biomass

 Formula: IF( ​line123​ ="","", ​line123​ * ​line153​ /1000)

Used in lines: ​line175​ , ​line233

183a

biomass content from alternative fuels

 Formula: ( ​line109​ * ​line139​ * ​line200a​ + ​line110​ * ​line140​ * ​line200b​ + ​line111​ * ​line141​ * ​line200c​ + ​line112​ * ​line142​ * ​line200d​ + ​line113​ * ​line143​ * ​line200e​ + ​line113a​ * ​line143a​ * ​line200f​ + ​line114​ * ​line144​ * ​line200h​ )/1000

Used in lines: ​line175

### Drying of raw materials and fuels

Table 99: Plant Sheet - Drying of raw materials and fuels

Line Title Comment

184

Conventional fossil fuels

 Comment: This is the total heat consumption of all conventional fossil fuels for drying of raw materials and fuels. This result is registered in line 25a and line 26 above Formula: IF(COUNTBLANK( ​line184a​ : ​line184f​ )=6,"",SUM( ​line184a​ : ​line184f​ ))

Used in lines: ​line025a​ , ​line026

184a

coal + anthracite + lignite

 Formula: IF( ​line124a​ ="","", ​line124a​ * ​line154a​ /1000)

Used in lines: ​line184​ , ​line234a

184b

petrol coke

 Formula: IF( ​line124b​ ="","", ​line124b​ * ​line154b​ /1000)

Used in lines: ​line184​ , ​line234b

184c

(ultra) heavy fuel

 Formula: IF( ​line124c​ ="","", ​line124c​ * ​line154c​ /1000)

Used in lines: ​line184​ , ​line234c

184d

diesel oil

 Formula: IF( ​line124d​ ="","", ​line124d​ * ​line154d​ /1000)

Used in lines: ​line184​ , ​line234d

184e

natural gas

 Formula: IF( ​line124e​ ="","", ​line124e​ * ​line154e​ /1000)

Used in lines: ​line184​ , ​line234e

184f

shale

 Formula: IF( ​line124f​ ="","", ​line124f​ * ​line154f​ /1000)

Used in lines: ​line184​ , ​line234f

184g

Alternative fossil fuels

 Comment: This is the total heat consumption of all alternative fossil fuels for drying of raw materials and fuels. This result is registered in line 25a line 27 above Formula: ​line184h​

Used in lines: ​line025a​ , ​line027

184h

other fossil based wastes (excl. biomass content of mixed fuels)

 Comment: Heat consumption of alternative fossil fuels, for drying of raw materials and fuels, calculated from the amount of each fuel and their lower heating values Formula: IF( ​line125a​ ="","", ​line125a​ *( ​line155a​ /1000)*(1- ​line200h​ ))

Used in lines: ​line184g​ , ​line235a

184i

Alternative biomass fuels

 Comment: This is the total heat consumption of all biomass fuels, for drying of raw materials and fuels. This result is registered in line 25a and line 28 above Formula: ​line184j​

Used in lines: ​line025a​ , ​line028

184j

other biomass (incl. biomass content of mixed fuels)

 Comment: Heat consumption of biomass fuels, for drying of raw materials and fuels, calculated from the amount of each fuel and their lower heating values Formula: IF( ​line126a​ ="","",( ​line126a​ * ​line156a​ /1000)+( ​line125a​ * ​line155a​ /1000* ​line200h​ ))

Used in lines: ​line184i​ , ​line236a

### CO2 Emissions from Kiln Fuels

Table 100: Plant Sheet - CO2 Emissions from Kiln Fuels

Line Title Comment

211

Conventional fossil fuels - total emissions

 Comment: These are the total CO2 emissions from all conventional fossil kiln fuels. This result is registered in line 40 above Formula: IF(COUNTBLANK( ​line212​ : ​line217a​ )=7,"",SUM( ​line212​ : ​line217a​ ))

Used in lines: ​line040

212

coal + anthracite

 Formula: IF( ​line162​ ="","", ​line162​ * ​line186​ )

Used in lines: ​line211

213

petrol coke

 Formula: IF( ​line163​ ="","", ​line163​ * ​line187​ )

Used in lines: ​line211

214

(ultra) heavy fuel

 Formula: IF( ​line164​ ="","", ​line164​ * ​line188​ )

Used in lines: ​line211

215

diesel oil

 Formula: IF( ​line165​ ="","", ​line165​ * ​line189​ )

Used in lines: ​line211

216

natural gas

 Formula: IF( ​line166​ ="","", ​line166​ * ​line190​ )

Used in lines: ​line211

217

shale

 Formula: IF( ​line167​ ="","", ​line167​ * ​line191​ )

Used in lines: ​line211

217a

lignite

 Formula: IF( ​line167a​ ="","", ​line167a​ * ​line192​ )

Used in lines: ​line211

218

Alternative fossil and mixed fuels - total fossil emissions

 Formula: IF(COUNTBLANK( ​line219​ : ​line224​ )=7,"",SUM( ​line219​ : ​line224​ ))

Used in lines: ​line041

219

waste oil / fossil content

 Formula: IF( ​line169​ ="","", ​line169​ * ​line194​ )

Used in lines: ​line218

220

waste tyres / fossil content

 Formula: IF( ​line170​ ="","", ​line170​ * ​line195​ )

Used in lines: ​line218

221

RDF including plastics / fossil content

 Formula: IF( ​line171​ ="","", ​line171​ * ​line196​ )

Used in lines: ​line218

222

solvents / fossil content

 Formula: IF( ​line172​ ="","", ​line172​ * ​line197​ )

Used in lines: ​line218

223

impregnated saw dust / fossil content

 Formula: IF( ​line173​ ="","", ​line173​ * ​line198​ )

Used in lines: ​line218

223a

mixed industrial waste / fossil content

 Formula: IF( ​line173a​ ="","", ​line173a​ * ​line199​ )

Used in lines: ​line218

224

other fossil based wastes / fossil content

 Formula: IF( ​line174​ ="","", ​line174​ * ​line200​ )

Used in lines: ​line218

225

Biomass fuels - total, incl. biomass cont. from alternative mixed fuels

 Comment: These are the total CO2 emissions from all biomass kiln fuels. This result is registered in line 50 above Formula: IF(COUNTBLANK( ​line226​ : ​line233a​ )=9,"",SUM( ​line226​ : ​line233a​ ))

Used in lines: ​line050

226

sewage sludge

 Formula: IF( ​line176​ ="","", ​line176​ * ​line202​ )

Used in lines: ​line225

227

wood, non impregnated saw dust

 Formula: IF( ​line177​ ="","", ​line177​ * ​line203​ )

Used in lines: ​line225

228

paper, carton

 Formula: IF( ​line178​ ="","", ​line178​ * ​line204​ )

Used in lines: ​line225

229

animal meal

 Formula: IF( ​line179​ ="","", ​line179​ * ​line205​ )

Used in lines: ​line225

230

animal bone meal

 Formula: IF( ​line180​ ="","", ​line180​ * ​line206​ )

Used in lines: ​line225

231

animal fat

 Formula: IF( ​line181​ ="","", ​line181​ * ​line207​ )

Used in lines: ​line225

232

agricultural, organic, diaper waste, charcoal

 Formula: IF( ​line182​ ="","", ​line182​ * ​line208​ )

Used in lines: ​line225

233

other biomass

 Formula: IF( ​line183​ ="","", ​line183​ * ​line209​ )

Used in lines: ​line225

233a

biomass content from alternative fuels

 Formula: ( ​line109​ * ​line139​ * ​line200a​ * ​line194​ + ​line110​ * ​line140​ * ​line200b​ * ​line195​ + ​line111​ * ​line141​ * ​line200c​ * ​line196​ + ​line112​ * ​line142​ * ​line200d​ * ​line197​ + ​line113​ * ​line143​ * ​line200e​ * ​line198​ + ​line113a​ * ​line143a​ * ​line200f​ * ​line199​ + ​line114​ * ​line144​ * ​line200h​ * ​line200​ )/1000

Used in lines: ​line225

### Drying of raw materials and fuels

Table 101: Plant Sheet - Drying of raw materials and fuels

Line Title Comment

234

Conventional fossil fuels - total emissions

 Comment: These are the total CO2 emissions from all conventional fossil fuels, for drying of raw materials and fuels. This result is registered in line 40 above Formula: IF(COUNTBLANK( ​line234a​ : ​line234f​ )=6,"",SUM( ​line234a​ : ​line234f​ ))

Used in lines: ​line040

234a

coal + anthracite + lignite

 Comment: line184a (TJ/yr of coal, anthracite and lignite) * line186 (EF of coal and anthracite). This means, if a plant uses a mixture of coal, anthracite and lignite for drying of raw materials, the consumed energy amount is multiplied with a slightly incorrect emission factor for anthracite and coal. The emission factor in line186 shall not be adapted, because otherwise the more important main input stream of coal and anthracite into the kiln would be result in really wrong CO2 emissions. Formula: IF( ​line184a​ ="","", ​line184a​ * ​line186​ )

Used in lines: ​line234

234b

petrol coke

 Formula: IF( ​line184b​ ="","", ​line184b​ * ​line187​ )

Used in lines: ​line234

234c

(ultra) heavy fuel

 Formula: IF( ​line184c​ ="","", ​line184c​ * ​line188​ )

Used in lines: ​line234

234d

diesel oil

 Formula: IF( ​line184d​ ="","", ​line184d​ * ​line189​ )

Used in lines: ​line234

234e

natural gas

 Formula: IF( ​line184e​ ="","", ​line184e​ * ​line190​ )

Used in lines: ​line234

234f

shale

 Formula: IF( ​line184f​ ="","", ​line184f​ * ​line191​ )

Used in lines: ​line234

235

Alternative fossil fuels - fossil total emissions

 Comment: These are the total CO2 emissions from all alternative fossil fuels, for drying of raw materials and fuels. This result is registered in line 41 above Formula: ​line235a​

Used in lines: ​line041

235a

other fossil based wastes / fossil content

 Comment: This cell calculates CO2 emissions by multiplying the heat consumption (in TJ/year, line184h) with the corresponding emission factors (given in line200) Formula: IF( ​line184h​ ="","", ​line184h​ * ​line200​ )

Used in lines: ​line235

236

Alternative biomass fuels - biomass total emissions

 Comment: These are the total CO2 emissions from all biomass fuels, for drying of raw materials and fuels. This result is registered in line 50 above Formula: ​line236a​

Used in lines: ​line050

236a

other biomass (incl. biomass content of mixed fuels)

 Comment: This cell calculates CO2 emissions by multiplying the heat consumption (in TJ/year, line184j) with the corresponding emission factors (given in line 209) Formula: IF( ​line184j​ ="","",( ​line126a​ * ​line156a​ /1000* ​line209​ )+( ​line125a​ * ​line155a​ /1000* ​line200​ * ​line200h​ ))

Used in lines: ​line236

### Non-Kiln Fuel Consumption in terajoules (TJ) per year

Table 102: Plant Sheet - Non-Kiln Fuel Consumption in terajoules (TJ) per year

Line Title Comment

321

Equipment and On-Site Vehicles fossil fuels

 Comment: This is the sum of equipment and on-site vehicles. The result is registered in line 30 above Comment: This line shows the calculated total value of annual fossil fuel consumption in terajoules of equipment and on-site vehicles Formula: IF(COUNTBLANK( ​line321a​ : ​line321ba​ )=3,"",SUM( ​line321a​ : ​line321ba​ ))

Used in lines: ​line030​ , ​line096b​ , ​line096c​ , ​line096d

321a

diesel oil

 Comment: This line shows the calculated value of annual fuel consumption of diesel oil used as fossil fuel in equipment and on-site vehicles in terajoules. Formula: IF( ​line301a​ ="","", ​line301a​ * ​line311a​ /1000)

Used in lines: ​line321​ , ​line331a

321b

gasoline

 Comment: This line shows the calculated value of annual fuel consumption of gasoline used as fossil fuel in equipment and on-site vehicles in terajoules. Formula: IF( ​line301b​ ="","", ​line301b​ * ​line311b​ /1000)

Used in lines: ​line321​ , ​line331b

321ba

other fossil fuels

 Comment: This line shows the calculated value of annual fuel consumption of other fossil based wastes (if entered above) used as fossil fuel in equipment and on-site vehicles in terajoules. Formula: IF( ​line301ba​ ="","", ​line301ba​ * ​line311ba​ /1000)

Used in lines: ​line321​ , ​line331ba

321c

Equipment and On-Site Vehicles fuels (containing biomass)

 Comment: This is the sum of equipment and on-site vehicles of biomass fuels Comment: This line shows the calculated total annual consumption value of fuel which contains biomass and are used for equipment and on-site vehicles, in terajoules Formula: ​line321d​

Used in lines: ​line030​ , ​line096b​ , ​line096c​ , ​line096d​ , ​line331a

321d

bio and mixed diesel

 Comment: Heat consumption calculated from non-kiln fuel consumption and lower heating values of biomass fuels. Comment: This line shows the calculated annual consumption value of diesel oil which contains biomass and is used for equipment and on/site vehicles, e.g. bio diesel, in terajoules Formula: IF( ​line301d​ ="","", ​line301d​ * ​line311d​ /1000)

Used in lines: ​line321c​ , ​line331a​ , ​line331d

322

Room Heating and Cooling

 Comment: This is the sum of room heating and cooling. The result is registered in line 31a above Comment: This line shows the calculated total value of annual fuel consumption used for room heating and cooling Formula: IF(COUNTBLANK( ​line322a​ : ​line322c​ )=3,"",SUM( ​line322a​ : ​line322c​ ))

Used in lines: ​line031a​ , ​line096b​ , ​line096c​ , ​line096d

322a

diesel oil

 Comment: This line shows the calculated value of annual diesel oil consumption used for room heating and cooling in terajoules Formula: IF( ​line302a​ ="","", ​line302a​ * ​line312a​ /1000)

Used in lines: ​line322​ , ​line332a

322b

natural gas

 Comment: This line shows the calculated value of annual natural gas consumption which used for room heating and cooling in terajoules Formula: IF( ​line302b​ ="","", ​line302b​ * ​line312b​ /1000)

Used in lines: ​line322​ , ​line332b

322c

other fossil fuels

 Comment: This line shows the calculated value of annual other fossil fuels (in case you have entered above) consumption which used for room heating and cooling in terajoules Formula: IF( ​line302c​ ="","", ​line302c​ * ​line312c​ /1000)

Used in lines: ​line322​ , ​line332c

323k

Conventional fossil fuels

 Comment: This is the sum of drying of raw materials and mineral components from conventional fossil fuels. The result is registered in line 31b above Comment: This line shows the calculated total value of annual conventional fossil fuels consumption used for drying of mineral components in terajoules Formula: IF(COUNTBLANK( ​line323a​ : ​line323f​ )=6,"",SUM( ​line323a​ : ​line323f​ ))

Used in lines: ​line031b​ , ​line096b​ , ​line096c​ , ​line096d

323a

coal + anthracite + lignite

 Comment: This line shows the calculated value of annual coal, anthracite, waste coal and lignite mix consumption which used for drying of mineral components in terajoules Formula: IF( ​line303a​ ="","", ​line303a​ * ​line313a​ /1000)

Used in lines: ​line323k​ , ​line333a

323b

petrol coke

 Comment: This line shows the calculated value of annual petrol coke consumption used for drying of mineral components in terajoules Formula: IF( ​line303b​ ="","", ​line303b​ * ​line313b​ /1000)

Used in lines: ​line323k​ , ​line333b

323c

(ultra) heavy fuel

 Comment: This line shows the calculated value of annual ultra heavy fuel consumption used for drying of mineral components in terajoules Formula: IF( ​line303c​ ="","", ​line303c​ * ​line313c​ /1000)

Used in lines: ​line323k​ , ​line333c

323d

diesel oil

 Comment: This line shows the calculated value of annual diesel oil consumption which used for drying of mineral components in terajoules Formula: IF( ​line303d​ ="","", ​line303d​ * ​line313d​ /1000)

Used in lines: ​line323k​ , ​line333d

323e

natural gas

 Comment: This line shows the calculated value of annual natural gas consumption which used for drying of mineral components in terajoules Formula: IF( ​line303e​ ="","", ​line303e​ * ​line313e​ /1000)

Used in lines: ​line323k​ , ​line333e

323f

shale

 Comment: This line shows the calculated value of annual shale consumption used for the drying of mineral components in terajoules Formula: IF( ​line303f​ ="","", ​line303f​ * ​line313f​ /1000)

Used in lines: ​line323k​ , ​line333f

323g

Alternative fossil and mixed fuels

 Comment: This is the sum of drying of raw materials and mineral components from alternative fossil fuels. The result is registered in line 31b above Comment: This line shows the calculated total value of annual alternative fossil fuels consumption used for the drying of mineral components in terajoules Formula: ​line323h​

Used in lines: ​line031b​ , ​line096b​ , ​line096c​ , ​line096d

323h

other fossil based wastes and mixed fuels

 Comment: Heat consumption calculated from non-kiln fuel consumption and lower heating values Comment: This line shows the calculated value of annual other fossil based wastes (in case you have entered above) consumption used for the drying of mineral components in terajoules Formula: IF( ​line303h​ ="","", ​line303h​ * ​line313h​ /1000)

Used in lines: ​line323g​ , ​line333h​ , ​line333j

323i

Alternative biomass fuels

 Comment: This is the sum of drying of raw materials and mineral components from alternative biomass fuels. The result is registered in line 31b above Comment: This line shows the calculated total value of annual alternative biomass fuels consumption used for the drying of mineral components in terajoules Formula: ​line323j​

Used in lines: ​line031b​ , ​line096b​ , ​line096c​ , ​line096d

323j

other biomass

 Comment: Heat consumption calculated from non-kiln fuel consumption and lower heating values Comment: This line shows the calculated value of annual other biomass (in case you have entered above) consumption which used for drying of mineral components in terajoules Formula: IF( ​line303j​ ="","", ​line303j​ * ​line313j​ /1000)

Used in lines: ​line323i​ , ​line333j

324aa

Conventional fossil fuels

 Comment: This is the sum of on-site power generation from conventional fossil fuels. The result is registered in line 31c above Comment: This line shows the calculated total value of annual conventional fossil fuels consumption used for on-site power generation in terajoules Formula: IF(COUNTBLANK( ​line324a​ : ​line324j​ )=6,"",SUM( ​line324a​ : ​line324j​ ))

Used in lines: ​line031c​ , ​line096b​ , ​line096c​ , ​line096d

324a

coal + anthracite + lignite

 Comment: This line shows the calculated value of annual coal, anthracite and waste coal mix consumption used for on-site power generation in terajoules Formula: IF( ​line304a​ ="","", ​line304a​ * ​line314a​ /1000)

Used in lines: ​line324aa​ , ​line334a

324b

(ultra) heavy fuel

 Comment: This line shows the calculated value of annual ultra heavy fuel consumption used for on-site power generation in terajoules Formula: IF( ​line304b​ ="","", ​line304b​ * ​line314b​ /1000)

Used in lines: ​line324aa​ , ​line334b

324c

diesel oil

 Comment: This line shows the calculated value of annual diesel oil consumption used for on-site power generation in terajoules Formula: IF( ​line304c​ ="","", ​line304c​ * ​line314c​ /1000)

Used in lines: ​line324aa​ , ​line334c

324d

natural gas

 Comment: This line shows the calculated value of annual natural gas consumption used for on-site power generation in terajoules Formula: IF( ​line304d​ ="","", ​line304d​ * ​line314d​ /1000)

Used in lines: ​line324aa​ , ​line334d

324i

petrol coke

 Comment: This line shows the calculated value of annual petrol coke consumption used for on-site power generation in terajoules Formula: IF( ​line304i​ ="","", ​line304i​ * ​line314i​ /1000)

Used in lines: ​line324aa​ , ​line334i

324j

other fossil fuels

 Comment: This line shows the calculated value of annual other fossil fuel (if entered above) consumption used for on-site power generation in terajoules Formula: IF( ​line304j​ ="","", ​line304j​ * ​line314j​ /1000)

Used in lines: ​line324aa​ , ​line334j

324f

Alternative fossil and mixed fuels

 Comment: This is the sum of on-site power generation from alternative fossil fuels. The result is registered in line 31c above Comment: This line shows the calculated total value of annual alternative fossil fuels consumption used for on-site power generation in terajoules Formula: ​line324g​

Used in lines: ​line031c​ , ​line096b​ , ​line096c​ , ​line096d

324g

other fossil based wastes and mixed fuels

 Comment: Heat consumption calculated from non-kiln fuel consumption and lower heating values Comment: This line shows the calculated value of annual other fossil based wastes (iif entered above) consumption used for on-site power generation in terajoules Formula: IF( ​line304g​ ="","", ​line304g​ * ​line314g​ /1000)

Used in lines: ​line324f​ , ​line334g​ , ​line334e

324h

Alternative biomass fuels

 Comment: This is the sum of on-site power generation from biomass fuels. The result is registered in line 31c above Comment: This line shows the calculated total value of annual alternative biomass fuels consumption used for on-site power generation in terajoules Formula: ​line324e​

Used in lines: ​line031c​ , ​line096b​ , ​line096c​ , ​line096d

324e

other biomass

 Comment: Heat consumption calculated from non-kiln fuel consumption and lower heating values Comment: This line shows the calculated value of annual other biomass (iif entered above) consumption which used for on-site power generation in terajoules Formula: IF( ​line304e​ ="","", ​line304e​ * ​line314e​ /1000)

Used in lines: ​line324h​ , ​line334e

### CO2 Emissions from Non-Kiln fuels

Table 103: Plant Sheet - CO2 Emissions from Non-Kiln fuels

Line Title Comment

331

Equipment and On-Site Vehicles

 Comment: This is the sum of equipment and on-site vehicles. The result is registered in line 44 above Comment: This line shows the calculated total value of annual CO2 emission from fossil fuel in tonnes used in equipment and on-site vehicles Formula: IF(COUNTBLANK( ​line331a​ : ​line331ba​ )=3,"",SUM( ​line331a​ : ​line331ba​ ))

Used in lines: ​line044

331a

diesel oil (incl. fossil CO2 of mixed diesel)

 Comment: This line shows the calculated value of annual CO2 emissions in tonnes from diesel oil used as fossil fuel in equipment and on-site vehicles. Formula: IF(OR( ​line321a​ ="", ​line321c​ =""),"", ​line321a​ * ​line189​ + ​line321d​ * ​line199a​ *(1- ​line200g​ ))

Used in lines: ​line331

331b

gasoline

 Comment: This line shows the calculated value of annual CO2 emissions in tonnes from gasoline used as fossil fuel in equipment and on-site vehicles. Formula: IF( ​line321b​ ="","", ​line321b​ * ​line192a​ )

Used in lines: ​line331

331ba

other fossil fuels

 Comment: This line shows the calculated value of annual CO2 emissions in tonnes from other fossil based wastes (if entered above) used as fossil fuel in equipment and on-site vehicles . Formula: IF( ​line321ba​ ="","", ​line321ba​ * ​line192d​ )

Used in lines: ​line331

331c

Equipment and On-Site Vehicles biomass fuels

 Comment: This is the sum of equipment and on-site vehicles(biomass fuels).The result is registered in line 50 above Comment: This line shows the calculated total annual value of CO2 emissions in tonnes from fuel which contains biomass and is used for equipment and on-site vehicles Formula: ​line331d​

Used in lines: ​line050

331d

bio diesel (biogenic CO2 of bio or mixed diesel)

 Comment: This cell calculates CO2 emissions by multiplying the Heat consumption (in TJ/year, lines 321d) with the emission factor (lines 199a) and Biomass content (line200g) Comment: This line shows the calculated annual CO2 emissions in tonnes from diesel oil which contains biomass and is used for equipments and on/site vehicles, e.g. bio diesel Formula: IF( ​line321d​ ="","", ​line321d​ * ​line199a​ * ​line200g​ )

Used in lines: ​line331c

332

Room Heating and Cooling

 Comment: This is the sum of room heating and cooling. The result is registered in line 45a above Comment: This line shows the calculated total value of annual CO2 emissions in tonnes from fuel used for room heating and cooling Formula: IF(COUNTBLANK( ​line332a​ : ​line332c​ )=3,"",SUM( ​line332a​ : ​line332c​ ))

Used in lines: ​line045a

332a

diesel oil

 Comment: This line shows the calculated value of annual CO2 emissions in tonnes from diesel oil used for room heating and cooling Formula: IF( ​line322a​ ="","", ​line322a​ * ​line189​ )

Used in lines: ​line332

332b

natural gas

 Comment: This line shows the calculated value of annual CO2 emissions in tonnes from natural gas used for room heating and cooling Formula: IF( ​line322b​ ="","", ​line322b​ * ​line190​ )

Used in lines: ​line332

332c

other fossil fuels

 Comment: This line shows the calculated value of annual CO2 emissions in tonnes from other fossil fuels (in case you have entered above) which used for room heating and cooling Formula: IF( ​line322c​ ="","", ​line322c​ * ​line192b​ )

Used in lines: ​line332

333k

Conventional fossil fuels

 Comment: This is the sum of drying of raw materials and mineral components from conventional fossil fuels. The result is registered in line 45b above Comment: This line shows the calculated total value of annual CO2 emissions in tonnes from conventional fossil fuels used for the drying of mineral components Formula: IF(COUNTBLANK( ​line333a​ : ​line333f​ )=6,"",SUM( ​line333a​ : ​line333f​ ))

Used in lines: ​line045b

333a

coal + anthracite + lignite

 Comment: This line shows the calculated value of annual CO2 emissions in tonnes from coal, anthracite, waste coal and lignite mix used for drying of mineral components Formula: IF( ​line323a​ ="","", ​line323a​ * ​line186​ )

Used in lines: ​line333k

333b

petrol coke

 Comment: This line shows the calculated value of annual CO2 emissions in tonnes from petrol coke consumption used for drying of mineral components Formula: IF( ​line323b​ ="","", ​line323b​ * ​line187​ )

Used in lines: ​line333k

333c

(ultra) heavy fuel

 Comment: This line shows the calculated value of annual CO2 emissions in tonnes from ultra heavy fuel consumption used for the drying of mineral components Formula: IF( ​line323c​ ="","", ​line323c​ * ​line188​ )

Used in lines: ​line333k

333d

diesel oil

 Comment: This line shows the calculated value of annual CO2 emissions in tonnes from diesel oil used for the drying of mineral components Formula: IF( ​line323d​ ="","", ​line323d​ * ​line189​ )

Used in lines: ​line333k

333e

natural gas

 Comment: This line shows the calculated value of annual CO2 emissions in tonnes from natural gas which used for drying of mineral components Formula: IF( ​line323e​ ="","", ​line323e​ * ​line190​ )

Used in lines: ​line333k

333f

shale

 Comment: This line shows the calculated value of annual CO2 emissions in tonnes from shale used for drying of mineral components Formula: IF( ​line323f​ ="","", ​line323f​ * ​line191​ )

Used in lines: ​line333k

333g

Alternative fossil fuels - fossil total emissions

 Comment: This is the sum of drying of raw materials and mineral components from alternative fossil fuels. The result is registered in line 45b above Comment: This line shows the calculated total value of annual CO2 emissions in tonnes from alternative fossil fuels used for the drying of mineral components Formula: ​line333h​

Used in lines: ​line045b

333h

other fossil based wastes / fossil content

 Comment: This cell calculates CO2 emissions by multiplying the Heat consumption (in TJ/year, lines 323h) with the emission factors (lines200) and biomass content (line200h) Comment: This line shows the calculated value of annual CO2 emissions in tonnes from other fossil based wastes (if entered above) used for the drying of mineral components Formula: IF( ​line323h​ ="","", ​line323h​ * ​line200​ *(1- ​line200h​ ))

Used in lines: ​line333g

333i

Alternative biomass fuels - biomass total emissions

 Comment: This is the sum of drying of raw materials and mineral components from biomass fuels. The result is registered in line 50 above Comment: This line shows the calculated total value of annual alternative biomass fuels consumption used for the drying of mineral components in terajoules Formula: ​line333j​

Used in lines: ​line050

333j

other biomass (incl. biomass content of mixed fuels)

 Comment: This cell calculates CO2 emissions by multiplying the Heat consumption (in TJ/year, lines 323j) with the emission factors (line209) Comment: This line shows the calculated value of annual CO2 emissions in tonnes from other biomass (if entered above) used for the drying of mineral components Formula: IF( ​line323j​ ="","",( ​line323j​ * ​line209​ )+( ​line323h​ * ​line200​ * ​line200h​ ))

Used in lines: ​line333i

334aa

Conventional fossil fuels

 Comment: This is the sum of on-site power generation from conventional fossil fuels. The result is registered in line 45c above Comment: This line shows the calculated total value of annual CO2 emissions in tonnes from conventional fossil fuels used for on-site power generation Formula: IF(COUNTBLANK( ​line334a​ : ​line334j​ )=6,"",SUM( ​line334a​ : ​line334j​ ))

Used in lines: ​line045c

334a

coal + anthracite + lignite

 Comment: This line shows the calculated value of annual CO2 emissions in tonnes from coal, anthracite and waste coal mix used for on-site power generation Formula: IF( ​line324a​ ="","", ​line324a​ * ​line186​ )

Used in lines: ​line334aa

334b

(ultra) heavy fuel

 Comment: This line shows the calculated value of annual CO2 emissions in tonnes from ultra heavy fuel used for on-site power generation Formula: IF( ​line324b​ ="","", ​line324b​ * ​line188​ )

Used in lines: ​line334aa

334c

diesel oil

 Comment: This line shows the calculated value of annual CO2 emissions in tonnes from diesel oil used for on-site power generation Formula: IF( ​line324c​ ="","", ​line324c​ * ​line189​ )

Used in lines: ​line334aa

334d

natural gas

 Comment: This line shows the calculated value of annual CO2 emissions in tonnes from natural gas used for on-site power generation Formula: IF( ​line324d​ ="","", ​line324d​ * ​line190​ )

Used in lines: ​line334aa

334i

petrol coke

 Comment: This line shows the calculated value of annual CO2 emissions in tonnes from petrol coke used for on-site power generation Formula: IF( ​line324i​ ="","", ​line324i​ * ​line187​ )

Used in lines: ​line334aa

334j

other fossil fuels

 Comment: This line shows the calculated value of annual CO2 emissions in tonnes from other fossil fuel (in case you have entered above) used for on-site power generation Formula: IF( ​line324j​ ="","", ​line324j​ * ​line192c​ )

Used in lines: ​line334aa

334f

Alternative fossil fuels - fossil total emissions

 Comment: This is the sum of on-site power generation from alternative fossil fuels. The result is registered in line 45c above Comment: This line shows the calculated total value of annual CO2 emissions in tonnes from alternative fossil fuels used for on-site power generation Formula: ​line334g​

Used in lines: ​line045c

334g

other fossil based wastes / fossil content

 Comment: This cell calculates CO2 emissions by multiplying the Heat consumption (in TJ/year, line324g) with the emission factors (line200) and biomass content (line200h) Comment: This line shows the calculated value of annual CO2 emissions in tonnes from other fossil based wastes (if entered above) used for on-site power generation Formula: IF( ​line324g​ ="","", ​line324g​ * ​line200​ *(1- ​line200h​ ))

Used in lines: ​line334f

334h

Alternative biomass fuels - biomass total emissions

 Comment: This is the sum of on-site power generation. The result is registered in line 50 above Comment: This line shows the calculated total value of annual CO2 emissions in tonnes from alternative biomass fuels used for on-site power generation Formula: ​line334e​

Used in lines: ​line050

334e

other biomass (incl. biomass content of mixed fuels)

 Comment: This cell calculates CO2 emissions by multiplying the Heat consumption (in TJ/year, lines 324e) with the emission factors (line209) Comment: This line shows the calculated value of annual CO2 emissions in tonnes from other biomass (if entered above) used for on-site power generation Formula: IF( ​line324e​ ="","",( ​line324e​ * ​line209​ )+( ​line324g​ * ​line200​ * ​line200h​ ))

Used in lines: ​line334h

## Calcination Sheet A1

### Raw meal

Table 104: Calcination Sheet A1 - Raw meal

Line Title Comment

503

Raw meal consumed = Kiln feed *(1-Dust return correction)

 Comment: This line does not require any data. It shows the calculated number of tonnes of raw meal consumed per year. Formula: ​line500​ *(1- ​line501​ )

504

CO2 amount (LOI raw meal consumed)

 Comment: This line shows the calculated value of CO2 in tonnes resulting from consumed LOI raw material per year. Formula: ​line500​ *(1- ​line501​ )* ​line502​

505

Emission factor of raw meal consumed

 Comment: The calculated value of emission factor is shown on this line in unites of tonnes of CO2 per tonne of raw meal. Formula: IF( ​line503​ =0,"", ​line504​ / ​line503​ )

### CKD leaving the kiln system

Table 105: Calcination Sheet A1 - CKD leaving the kiln system

Line Title Comment

512

CKD calcination rate d

 Comment: The line shows the calculated percentage which represents the CKD calcination rate. Formula: 1-(( ​line511​ *(1- ​line502​ ))/((1- ​line511​ )* ​line502​ ))

513

Emission factor CKD

 Comment: This line has a calculated value of the emission factor in units of tonne of CO2 per tonne CKD. Formula: ​line502​ * ​line512​ /(1- ​line502​ * ​line512​ )

514

CO2 amount of CKD leaving the kiln system

 Comment: The calculated value of CO2 amount of CKD leaving the kiln system is shown on this line in unites of tonnes of CO2 per year. Formula: IF( ​line510​ =0,0, ​line510​ * ​line513​ )

### Absolute CO2 emissions from calcination

Table 106: Calcination Sheet A1 - Absolute CO2 emissions from calcination

Line Title Comment

520

CO2 amount (LOI raw meal consumed, fully calcined clinker and bypass dust)

 Comment: This line shows the calculated value of CO2 amount from LOI raw material consumed in annual tonnes of CO2. Formula: ​line504​

521

CO2 amount of CKD leaving the kiln system

 Comment: This line shows the calculated value of CO2 amount from CKD which is leaving the kiln system in annual tonnes of CO2. Formula: ​line514​

522

Total CO2 from raw materials (including CKD leaving the kiln system and organic carbon content)

 Comment: This line shows the calculated total value of CO2 amount from raw materials (including CKD leaving the kiln system and organic carbon content). Formula: SUM( ​line520​ : ​line521​ )

### Data Simple Output Method (A1)

Table 107: Calcination Sheet A1 - Data Simple Output Method (A1)

Line Title Comment

525

Output CalcA1: Raw meal consumption (=Plant sheet lines 34e)

 Comment: The final output value of raw meal consumption of this sheet is stated here as a calculated result in annual tonnes of raw meal. Formula: ​line503​

526

Output CalcA1: Total CO2 from raw materials (=Plant sheet line 34f)

 Comment: The final output value of total CO2 from raw material of this sheet is stated here as a calculated result in annual tonnes of CO2. Formula: ​line522​

## Calcination Sheet A2

### Raw meal

Table 108: Calcination Sheet A2 - Raw meal

Line Title Comment

603

Raw meal consumed = Kiln feed *(1-Dust return correction)

 Comment: The line shows the calculated number of tonnes of raw meal consumed per year Formula: ​line600​ *(1- ​line601​ )

604

CO2 amount (CO2 of raw meal consumed)

 Comment: This line shows the calculated value of CO2 in tonnes resulting from consumed raw material per year Formula: ​line603​ * ​line602​

605

Emission factor of raw meal consumed

 Comment: The calculated value of emission factor is shown on this line in unites of tonne CO2 per tonne of raw meal. Formula: IF( ​line603​ =0,"", ​line604​ / ​line603​ )

### Additional raw material # 1 (not part of kiln feed)

Table 109: Calcination Sheet A2 - Additional raw material # 1 (not part of kiln feed)

Line Title Comment

612

ARM CO2 amount

 Comment: This line shows the calculated value of CO2 amount in tonne per year resulting from the additional raw material you have entered above. Formula: ​line610​ * ​line611​

### Additional raw material # 2 (not part of kiln feed)

Table 110: Calcination Sheet A2 - Additional raw material # 2 (not part of kiln feed)

Line Title Comment

615

ARM CO2 amount

 Comment: This line shows the calculated value of CO2 amount in tonne per year resulting from additional raw material you have entered above. Formula: ​line613​ * ​line614​

### Additional raw material # 3 (not part of kiln feed)

Table 111: Calcination Sheet A2 - Additional raw material # 3 (not part of kiln feed)

Line Title Comment

618

ARM CO2 amount

 Comment: This line shows the calculated value of CO2 amount in tonne per year resulting from the additional raw material you have entered above. CO2 from total carbon is used as clarification for the analytical parameters of the Detailed Input Method A2. The term "CO2 content", which is used in the and in the, leads to misunderstandings. Formula: ​line616​ * ​line617​

### Additional raw material # 4 (not part of kiln feed)

Table 112: Calcination Sheet A2 - Additional raw material # 4 (not part of kiln feed)

Line Title Comment

621

ARM CO2 amount

 Comment: This line shows the calculated value of CO2 amount in tonne per year which resultung from the additional raw material you have entered above. Formula: ​line619​ * ​line620​

### Additional raw material # 5 (not part of kiln feed)

Table 113: Calcination Sheet A2 - Additional raw material # 5 (not part of kiln feed)

Line Title Comment

624

ARM CO2 amount

 Comment: This line shows the calculated value of CO2 amount in tonne per year resulting from the additional raw material you have entered above. Formula: ​line622​ * ​line623​

### Additional raw material # 6 (not part of kiln feed)

Table 114: Calcination Sheet A2 - Additional raw material # 6 (not part of kiln feed)

Line Title Comment

627

ARM CO2 amount

 Comment: This line shows the calculated value of CO2 amount in tonne per year resulting from the additional raw material you have entered above. Formula: ​line625​ * ​line626​

### Additional raw material # 7 (not part of kiln feed)

Table 115: Calcination Sheet A2 - Additional raw material # 7 (not part of kiln feed)

Line Title Comment

630

ARM CO2 amount

 Comment: This line shows the calculated value of CO2 amount in tonne per year resulting from the additional raw material you have entered above. Formula: ​line628​ * ​line629​

### Additional raw material # 8 (not part of kiln feed)

Table 116: Calcination Sheet A2 - Additional raw material # 8 (not part of kiln feed)

Line Title Comment

633

ARM CO2 amount

 Comment: This line shows the calculated value of CO2 amount in tonne per year resulting from the additional raw material you have entered above. Formula: ​line631​ * ​line632​

### Additional raw material # 9 (not part of kiln feed)

Table 117: Calcination Sheet A2 - Additional raw material # 9 (not part of kiln feed)

Line Title Comment

636

ARM CO2 amount

 Comment: This line shows the calculated value of CO2 amount in tonne per year which is resultingfrom the additional raw material you have entered above. Formula: ​line634​ * ​line635​

### Additional raw material # 10 (not part of kiln feed)

Table 118: Calcination Sheet A2 - Additional raw material # 10 (not part of kiln feed)

Line Title Comment

639

ARM CO2 amount

 Comment: This line shows the calculated value of CO2 amount in tonne per year which resulting from the additional raw material you have entered above. Formula: ​line637​ * ​line638​

### bypass dust correction for uncalcined fraction

Table 119: Calcination Sheet A2 - bypass dust correction for uncalcined fraction

Line Title Comment

652

Correction for uncalcined fraction of Bypass dust (residual CO2 content)

 Comment: This line shows the calculated value of correction for uncalcined fraction of bypass dust. Formula: ​line650​ * ​line651​

### CKD leaving the kiln system

Table 120: Calcination Sheet A2 - CKD leaving the kiln system

Line Title Comment

657

d (CKD calcination rate)

 Comment: The line shows the calculated percentage which represents the CKD calcination rate. Formula: 1-(( ​line656​ *(1- ​line602​ ))/((1- ​line656​ )* ​line602​ ))

658

Emission Factor CKD

 Comment: This line has a calculated value of emission factor in units of tonne CO2 per tonne CKD. Formula: ​line602​ * ​line657​ /(1- ​line602​ * ​line657​ )

659

CO2 amount of CKD leaving the kiln system

 Comment: The calculated value of CO2 amount of CKD leaving the kiln system is shown on this line in units of tonne CO2 per year. Formula: IF( ​line655​ =0,0, ​line655​ * ​line658​ )

### Total of additional raw materials (not part of kiln feed)

Table 121: Calcination Sheet A2 - Total of additional raw materials (not part of kiln feed)

Line Title Comment

665

 Comment: This line shows the calculated value of additional raw material (ARM) ,which is not part of the kiln, in annual dry tonnes. Formula: SUM( ​line610​ , ​line613​ , ​line616​ , ​line619​ , ​line622​ , ​line625​ , ​line628​ , ​line631​ , ​line634​ , ​line637​ )

666

ARM CO2 content

 Comment: This line shows the calculated value of CO2 content in additional raw material (ARM), which is not part of the kiln, in percentage of dry weight. CO2 from total carbon is used as clarification for the analytical parameters of the Detailed Input Method A2. The term "CO2 content", which is used in the and in the, leads to misunderstandings. Formula: IF(G116>0, ​line667​ /G116,"")

667

CO2 amount of additional raw materials

 Comment: This line shows the calculated value of CO2 amount from additional raw material (which is not a part of kiln system) in annual tonnes. Formula: SUM( ​line612​ , ​line615​ , ​line618​ , ​line621​ , ​line624​ , ​line627​ , ​line630​ , ​line633​ , ​line636​ , ​line639​ )

### Absolute CO2 emissions from raw material calcination and organic carbon content

Table 122: Calcination Sheet A2 - Absolute CO2 emissions from raw material calcination and organic carbon content

Line Title Comment

671

CO2 amount of raw material consumed

 Comment: This line shows the calculated value of CO2 amount from raw material consumed in annual tonnes of CO2. Formula: ​line604​

672

CO2 amount of CKD leaving the kiln system

 Comment: This line shows the calculated value of CO2 amount from CKD which is leaving the kiln system in annual tonnes of CO2. Formula: ​line659​

673

Correction for uncalcined fraction of bypass dust

 Comment: This line shows the calculated value of correction for uncalcined fraction of bypass dust in annual tonnes of CO2. Formula: ​line652​

674

CO2 amount of additional raw materials

 Comment: This line shows the calculated value of CO2 amount from additional raw materials in annual tonnes of CO2. Formula: ​line667​

676

Total CO2 from raw materials (including CKD leaving the kiln system and organic carbon content)

 Comment: This line shows the calculated value of CO2 amount from raw materials (including CKD leaving the kiln system and organic carbon content). Formula: IF(G123>0,G123+ ​line672​ - ​line673​ + ​line674​ ,"")

### Data Detailed Output Method (A2)

Table 123: Calcination Sheet A2 - Data Detailed Output Method (A2)

Line Title Comment

681

Output CalcA2: Raw meal consumption (=Plant sheet lines 34i)

 Comment: The final output value of raw meal consumption of this sheet is stated here as a calculated result in annual tonnes of raw meal. Formula: ​line603​

682

Output CalcA2: Total CO2 from raw materials (=Plant sheet line 34j)

 Comment: The final output value of total CO2 from raw material of this sheet is stated here as a calculated result in annual tonnes of CO2. Formula: ​line676​

## Calcination Sheet B2

Table 124: Calcination Sheet B2 - Clinker # 1

Line Title Comment

703

CaO amount

 Comment: This line is a result line and therefore does not need to be filled with data. The value shown in this line represents the annual tonnes of CaO in clinker type1. Formula: ​line700​ * ​line701​

704

MgO amount

 Comment: This line is a result line and therefore does not need to be filled with data. The shown value in this line represents the annual tonnes of MgO in clinker type1. Formula: ​line700​ * ​line702​

Table 125: Calcination Sheet B2 - Clinker # 2

Line Title Comment

708

CaO amount

 Comment: This line is a result line and therefore does not need to be filled with data. The value shown in this line represents the annual tonnes of CaO in clinker type2. Formula: ​line705​ * ​line706​

709

MgO amount

 Comment: This line is a result line and therefore does not need to be filled with data.The value shown in this line represents the annual tonnes of MgO in clinker type2. Formula: ​line705​ * ​line707​

Table 126: Calcination Sheet B2 - Total clinker

Line Title Comment

730

 Comment: This line shows the calculated value of annual clinker amount produced in tonnes, so you do not have to enter any data here. Formula: ​line700​ + ​line705​

731

Average CaO content (incl. free lime)

 Comment: This line shows the calculated value of average CaO content in percentage, so you do not have to enter any data here. Formula: IF( ​line730​ =0,0, ​line733​ / ​line730​ )

732

Average MgO content

 Comment: This line shows the calculated value of average MgO content in percentage, so you do not have to enter any data here. Formula: IF( ​line730​ =0,0, ​line734​ / ​line730​ )

733

Total CaO amount

 Comment: This line shows the calculated value of total annual CaO amount, so you do not have to enter any data here. Formula: ​line703​ + ​line708​

734

Total MgO amount

 Comment: This line shows the calculated value of total annual MgO amount, so you do not have to enter any data here. Formula: ​line704​ + ​line709​

### Raw material # 1

Table 127: Calcination Sheet B2 - Raw material # 1

Line Title Comment

743

CaO amount

 Comment: This line shows the calculated value of annual tonnes of CaO in raw material #1. Formula: ​line740​ * ​line741​

744

MgO amount

 Comment: This line shows the calculated value of annual tonnes of MgO in raw material #1. Formula: ​line740​ * ​line742​

### Raw material # 2

Table 128: Calcination Sheet B2 - Raw material # 2

Line Title Comment

748

CaO amount

 Comment: This line shows the calculated value of annual tonnes of CaO in raw material #2. Formula: ​line745​ * ​line746​

749

MgO amount

 Comment: This line shows the calculated value of annual tonnes of MgO in raw material #2. Formula: ​line745​ * ​line747​

### Total of raw materials

Table 129: Calcination Sheet B2 - Total of raw materials

Line Title Comment

770

Total raw material consumed

 Formula: ​line740​ + ​line745​

771

Average CaO content

 Formula: IF( ​line770​ =0,0, ​line773​ / ​line770​ )

772

Average MgO content

 Formula: IF( ​line770​ =0,0, ​line774​ / ​line770​ )

773

Total CaO amount

 Formula: ​line743​ + ​line748​

774

Total MgO amount

 Formula: ​line744​ + ​line749​

### Raw material # 1

Table 130: Calcination Sheet B2 - Raw material # 1

Line Title Comment

783

CaSi amount

 Comment: This line shows the calculated value of annual tonnes of CaSi amount in raw material #1. Formula: ​line780​ * ​line781​

784

MgSi amount

 Comment: This line shows the calculated value of annual tonnes of MgSi amount in raw material #1. Formula: ​line780​ * ​line782​

### Raw material # 2

Table 131: Calcination Sheet B2 - Raw material # 2

Line Title Comment

788

Ca amount

 Comment: This line shows the calculated value of annual tonnes of CaSi amount in raw material #2. Formula: ​line785​ * ​line786​

789

Mg amount

 Comment: This line shows the calculated value of annual tonnes of MgSi amount in raw material #2. Formula: ​line785​ * ​line787​

### Total of raw materials

Table 132: Calcination Sheet B2 - Total of raw materials

Line Title Comment

800

Total raw material consumed

 Comment: This line shows the calculated value of annual total dry tonnes of raw material consumed. Only raw materials entering the kiln and raw materials with relevant content of Ca-silicate and Mg-silicate must be reported here. Recycled dust should not be counted. Formula: ​line780​ + ​line785​

801

Average Ca content

 Comment: This line shows the calculated value of Ca content of Ca-Silicate raw material in percentage. Formula: IF( ​line800​ =0,0, ​line803​ / ​line800​ )

802

Average Mg content

 Comment: This line shows the calculated value of Mg content of raw material in percentage. Formula: IF( ​line800​ =0,0, ​line804​ / ​line800​ )

803

Total Ca amount

 Formula: ​line783​ + ​line788​

804

Total Mg amount

 Formula: ​line784​ + ​line789​

### Absolute CO2 emissions

Table 133: Calcination Sheet B2 - Absolute CO2 emissions

Line Title Comment

810

Uncorrected CO2 emissions, based on CaO- and MgO content of clinker

 Formula: ​line733​ / ​56,078​ * ​44,010​ + ​line734​ / ​40,304​ * ​44,010​

811

Correction for non-carbonate sources of CaO and MgO

 Formula: ​line773​ / ​56,078​ * ​44,010​ + ​line774​ / ​40,304​ * ​44,010​

812

Correction for silicate sources of CaO and MgO found in clinker

 Formula: ​line803​ / ​40,078​ * ​44,010​ + ​line804​ / ​24,305​ * ​44,010​

813

Corrected, direct CO2 emissions

 Formula: ​line810​ - ​line811​ - ​line812​

### Specific CO2 emissions per ton of clinker

Table 134: Calcination Sheet B2 - Specific CO2 emissions per ton of clinker

Line Title Comment

815

Calcination factor, uncorrected

 Formula: IF( ​line730​ =0,0, ​line810​ / ​line730​ *1000)

816

Calcination emission factor corrected for non-carbonate and silicate sources of CaO,MgO

 Formula: IF( ​line730​ =0,0, ​line813​ / ​line730​ *1000)

### Data Detailed Input Method (B2)

Table 135: Calcination Sheet B2 - Data Detailed Input Method (B2)

Line Title Comment

820

Output CalcB2: Calcination emission factor corrected for non-carbonate and silicate sources of CaO, MgO in clinker (=Plant sheet line 34q)

 Formula: ​line816​