Overview
Consolidation models are made up of three components:
1 .Basic model data
2. Template associated to the model
3. A consolidation tree, which may be for one or many level(s)
A detailed explanation of each component follows:
1. Basic information of the model
Name: This is the name of the model, which should be no longer than 20 characters.
Short names without blanks are recommended.
For example, IS2007 may mean Income Statement 2007.
Author: You may enter the model author's name here.
Description: You may describe the model in a few lines.
2. Template associated to the model
A template is a Microsoft Excel book and is key for the model because many things depend on this book,
including the consolidation itself.
Consolidator Enterprise for Excel use templates to give a customized treatment to consolidations by coloring,
certain cells which you do not want included in the consolidation (such as percentages, statistical data,
prices, interest rates, taxes, etc.); some cell values may not need to be shown in consolidated reports, etc.
Consolidator Enterprise for Excel has a small color palette for this purpose. For that reason, you should
not change the color palette in the Template book or some errors may occur (just leave the default
Excel color palette)
3. One-level or multiple-level consolidation tree
A consolidation tree is but a group of books to be consolidated.
One-Level consolidation tree
Three-Level consolidation tree
With Consolidator Enterprise for Excel you will have a good time creating consolidation trees
'-- you will easily and intuitively add, edit and delete items.
Now you are ready to use Consolidator Enterprise. Following is a full-scale example.
See Creating a new model