Consolidate Company Data (Aggregate Data from Plants)

The structure of the Company Sheet corresponds to the structure of the Plant sheet. It serves to provide consolidated values for the whole company or a defined unit of the company (see also Organisational Boundaries and Division into Plants).

It is a task of the user of the Protocol Spreadsheet to aggregate the values from all Plant sheets. This is done by calculating the consolidated “SUM” in the Company Sheet. Please note the following information before starting:

Sheets

FAQs

Line-by-Line

The Company Sheet is not contained in the Line-by-Line reference since its lines contain items identical to the lines in the Plant sheet.