|
3. Division names
|
Choose the I-divQ sheet and enter the division
names of the company to the cells E9:E18
(max 10 divisions).
You can leave those division name cells empty that
you do not need, but do NOT
remove any rows.
|
Click picture for full-size map.
|
|
|
No divisions?
If you do not want to divide group information
to division level, please still set the first division's
name for example to 'Group' or 'Total'.
Then every time you insert net sales or EBIT information
in I-divQ, use the first "division", not
the total row.
|
Tip: If you think that the rows for unused divisions
take too much space, you can hide them with the following
way: Choose the rows you would like to hide, right-click
with your mouse and select Hide. If you would like to
get the rows back to visible, do the same and select Unhide.
(In any case, do not remove any rows permanently.)
Possible problems?
 Net
sales is in division level but EBIT is in group level.
|
