Dictionary


Dictionary is the worksheet where you define the names, and the looks of the column headers used in the rest of the rollingPlan’s tables. In addition to this, here you can specify formats of the various cells in the Main.RollingPlan. The template is automatically generated.

rollingPlan is a collection of tables, each of which has a specific structure. On the one hand, these tables are interconnected, on the other, rollingPlan’s methods know where to look for the data they need, and where to put the results they produce. Therefore, table structures are hard-coded and it is not recommended to change them. When worksheets of the tool are built from scratch, the very first table to be populated with data is Dictionary. Initially, Dictionary is filled out with default names, and formats. They are copied, and pasted in the various tables to get the default appearance of the rollingPlan. You can change the look of the column headers, as well as the formats of the value cells by modifying their corresponding cells in the Dictionary.


Columns. 

1. Worksheets. As its name suggests, this column contains the names of all the worksheets in the rollingPlan tool. Column is locked for editing, but can be filtered.

2. Labels. This column contains the names of the columns, and cells in the rest of the worksheets as they are known to the tool. Similar to above, this column is locked for editing, but can be filtered.

3. Headers/Values. This column contains the names of columns, and cells, along with their formats as they appear in the rest of the worksheets of the tool. This is the place where you can put your creativity into work.


Common mistakes that may cause troubles later on.

There are quite a few things which may go wrong in this worksheet as most of the cells are locked for editing. One of them is worth mentioning, though:

1. Missing values. You may run into a situation like this when you decide to clear the contents of one or more cells in the Headers/Values column. In this case, you will get one or more blank column headers in the corresponding worksheets, and you will not be able to use the Add function properly.


Available Functions.

1. Build Template. This function rebuilds the Dictionary template from scratch. It clears completely the worksheet area, and populates it with default values, and formats.

2. Standard Microsoft Excel® Cell Formatting Functions. To modify contents of the cells in the Headers/Values column you can use almost all of the cell formatting functions available in Microsoft Excel®. You can change the background color, as well as size, color, and type of the font. You can also modify borders, center the text horizontally, or vertically, change number formats, etc. In order these changes to take effect, however, you have to rebuild the corresponding worksheets.


Important things to remember.

  1. In the Dictionary, you define the names, and the looks of the column headers used in the rest of the worksheets of both the Basic group, and the Main group. Here, you can also specify formats of the value cells in the Main.RollingPlan template.
  2. You can use any language, background color, font, border style, number format, etc.
  3. Do no leave blanks or gaps in the Headers/Values column.
  4. In order new formatting to take effect, rebuild  corresponding worksheets.

<< Main.Plans Ribbon Tab >>