Admin Sheet

The Admin Sheet is used to manage categories, category items and renaming these items, with all changes reflected throughout the model. As already mentioned in the section 1.4.2 Model Setup / Category Rows, categories are an important part of FD4Cast models.

At the very beginning, a default Admin Sheet will look like this:

As you can see, we have default category tables to the right. These categories are listed as:

 

Under each category table, we have category items. For example, “Sales” is an item under Income category. There may be other income items according to your business model (such as commissions, royalties etc.) During the initial model setup, you may add as many items as you wish for each of the categories (see: 1.4.2 ADD / REMOVE CATEGORY ROWS) and rename them according to your business dynamics.

After adding some items, our demo model’s Admin Sheet looks like this:

Managing the FD4Cast model is a recursive process, meaning you can tweak the configuration until you find a good balance which reflects your business dynamics. In this process, you will use Admin Sheet extensively to add/remove and rename category items.