Cement CO₂ 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.

• See Plant Sheet

4. CalcA1 (Calcination Sheet):

Simple Input Method (A1) auxiliary sheet for determining CO₂ 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 CO₂ Emissions from Calcination).

• See Sheet CalcA1 (Simple Input Method)

5. CalcA2 (Calcination Sheet):

Detailed Input Method (A2) auxiliary sheet for determining CO₂ 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 CO₂ Emissions from Calcination).

• See Sheet CalcA2 (Detailed Input Method)

6. CalcB2 (Calcination Sheet):

Detailed Output Method (B2) auxiliary sheet for determining the corrected CO₂ 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 CO₂ Emissions from Calcination).

• See Sheet CalcB2 (Detailed Output Method)

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"!

• See Company Sheet

8. Validation:

Validation tool for first general check of input data quality.

• See Validation Sheet

9. Control Plant:

Detailed validation tool report at plant level.

• See Control Plant Sheet

10. Fuel CO₂ Factors:

Default CO₂ emission factors for fuels used in cement plants.

• See Fuel CO₂ Factors Sheet

FAQs

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