Assumptions, decision variables, and forecasts are assigned an automatically-generated, default name when they are defined, either directly or by pasting. You can accept the generated names or enter another name:
If the object is created in a cell with a range name, that name is assigned.
If the cell is located within a formal or informal table, the name is created from column and row headers or indexes. First, the row header is used and then the column header is added, separated by a small dot.
For example, suppose the row headers are Project1, Project2, and Project3 and column headers are North America, Europe, Asia. An assumption created at the intersection of Project 2 and Europe is named Project2 • Europe.
If there are no column or row headers, an index number is used, depending on the intersection’s position in the table’s columns or rows.
Note: | Crystal Ball uses information from Microsoft Excel to determine whether a cell is part of a table. You can select a cell and then press Ctrl+a to display any table boundaries around it. If automatically-generated names are different from what you expect, you can add blank columns or rows between groups of cells to change or remove table boundaries. |
If the cell is not part of a table and does not have a range name, the cell reference is used.
You can replace the generated name by typing a different one, or by entering a formula containing references to text in the spreadsheet.