Cement CO2 and Energy Protocol Spreadsheet

The Protocol Spreadsheet contains the following sheets:

1. Read Me:

This sheet explains the meaning of the different colours used in the Protocol Spreadsheet and provides essential instructions for the user. You will find more recent updates and additional questions and answers in the section Frequently Asked Questions (FAQs) in this online manual. Detailed information on more recent releases of the Protocol Spreadsheet are provided in the News and Updates section of this manual.

2. Comments:

This sheet gives a short explanation for every line of the Plant sheet. The same comments are included in the Line-by-Line section in this Internet Manual.

3. Plant:

This is the primary sheet of the Protocol Spreadsheet. In the end, each plant of the reporting company should have its own Plant sheet. Additional Plant sheets can be created with the button “New Plant Sheet V3.1” in line001. For transferring plant data from version 3.04 to version 3.1 of the Protocol Spreadsheet use the button "New Plant Sheet Transfer V3.04 > V3.1".

It is recommended to name all Plant sheets "Plant_xyz", with xyz could be for example the name of the plant.

4. CalcA1 (Calcination Sheet):

Simple Input Method (A1) auxiliary sheet for determining CO2 emissions from raw material calcination (can be created for plants with kiln operation, line007c = yes).

The sheet is hidden by default and one auxiliary sheet must be created for each plant which uses this calculation method (see Plant sheet line007n and z Select a Method for Determining CO2 Emissions from Calcination).

5. CalcA2 (Calcination Sheet):

Detailed Input Method (A2) auxiliary sheet for determining CO2 emissions from raw material calcination (can be created for plants with kiln operation, line007c = yes).

The sheet is hidden by default. One auxiliary sheet must be created for each plant which uses this calculation method (see Plant sheet line007n and z Select a Method for Determining CO2 Emissions from Calcination).

6. CalcB2 (Calcination Sheet):

Detailed Output Method (B2) auxiliary sheet for determining the corrected CO2 emission factor of clinker (can be created for plants with kiln operation, line007c = yes).

The sheet is hidden by default and one auxiliary sheet must be created for each plant which uses this calculation method (see Plant sheet line007n and z Select a Method for Determining CO2 Emissions from Calcination).

7. Company:

This sheet serves to consolidate data and information of all plants of one company. Please note that the data of each Plant sheet must be added manually to the cells as appropriate, e.g. by editing the formulas in all white or light green cells, which contain the word "SUM"!

8. Validation:

Validation tool for first general check of input data quality.

9. Control Plant:

Detailed validation tool report at plant level.

10. Fuel CO2 Factors:

Default CO2 emission factors for fuels used in cement plants.

FAQs

See General Questions in the FAQ section for questions related to the functioning of the Protocol Spreadsheet and Excel®.