Creating and manage a Model

The name of the example company is "Test S.A."
Test S.A. manufactures footballs and has operations in the United States, Canada and Mexico.
Sales Management is based in the United States and needs to consolidated the sales results for 2010, as well the costs that may be involved (as a simplified Income Statement).

Test S.A. sales points have the following structure:

With the above explained, let us now proceed with the Test S.A. example.

To create a new model follow the next instructions:

Choose the option create new consolidation.

Create new cosolidation

Click Next to Continue.

On the following screen enter the data for the new model.

Create new cosolidation2

Click Next to Continue.

Now you look at the new consolidation in the list of existing consolidations.
Also from this section you may remove and open the folder of consolidations if necessary.

Click Next to Continue.

Now must choose the workbook and the sheet for the template.
First thing you have to do is to associate a Template to this model, so please select Open Template.
Select this to copy the structure from an existing book and use it as a template for the active model. You will not be using the original book, but rather a copy has been made of the sheet we want to use as a template.
In our example, since you already have a similar model (IS2007) with a template already assigned to it you can get a copy for your model.
As you can see below, you get a copy of the template that you can work on and give format to.

Click Next to Continue.

In this new screen you must create the structure of consolidation.
Click on Test2010 as shown in the screenshot below. You will see that some options have been enabled in the menu, which we will explain.

Add Consolidation data book: Point to it to add a new consolidation item. This element groups other books and creates consolidation levels.

Add data book: Select it to create a new book that will be a copy of the Template.
You can send this book to the people who are to fill them out with the data to be consolidated.

Start creating the new consolidation levels as required, with as many levels as sales points.

Create the books required for each consolidation level.

Now you may send the books to be filled out to the people responsible for entering the information. You may send them via email or any other electronic messaging media at your discretion.

You can get to this folder from the Consolidations dialog, as shown in this screenshot:



The books you have created with Consolidator Enterprise are located in the same folder as the add-in; in this example the path is:

C:\Program Files\JABSOFT\Consolidator Enterprise for Excel\Consolidations\test2010\Files

*Note: Please instruct the people you are emailing the books to that they should only fill them out with the required data without changing such other information as book name or sheet names; otherwise, errors may occur when consolidating.
When you get the books back with the required information, save them in the same folder, namely:

C:\Program Files\JABSOFT\Consolidator Enterprise for Excel\Consolidations\test2010\Files

Microsoft Windows will ask you if you want to replace the existing book. Click Yes.

*Note: You will have to close the Consolidator Enterprise dialog box before saving the books returned; otherwise Microsoft Windows will not let you overwrite the original book.

Now that you have all the books in place, you will see how enjoyably useful Consolidator Enterprise for Excel can be.