Company Sheet

The Company sheet is mostly the same as the Plant sheet, but all of its cells should contain the data consolidated at company level. This means that the numbers which should be entered on the Company sheet should be the sum of all the plants which you have within your company.

Most of the lines of the Plant sheet can be found in the Company sheet. All of them have the same title and line number, but you must take care that the values entered in the Company sheet are values at company level. E.g. if you have 3 plants within your company and each one produces 1000 tonnes clinker per year, you have to insert 3000 tonnes as the annual production amount of clinker at the company level in the Company sheet.

Entering internal transfers among plants within the same company does not make sense in this sheet, simply because they will not affect the gross sum at company level. Positive and negative values for internal transfers in the Plant sheets should cancel each other out and add up to 0 (zero).

A possible solution for consolidating Plant sheet data for the Company sheet in the Protocol Spreadsheet: In Excel® you can use the "SUM" function and manually link the lines in the Plant sheets to the relevant lines in the Company sheet - the sums of all relevant Plant sheet values are then updated automatically when you change a value in the Plant sheet. See a more detailed description in the following task.

Tasks

Line-by-Line

In the Company sheet the same line numbers are used as for the corresponding lines in the Plant sheet. Thus, you can use the same Line-by-Line reference for finding more detailed information about the cells in the Pant sheet and in the Company sheet.

FAQs