Fill in the calculation sheet
On the ”Calculation” tab in the design template, you can set up new calculations or copy calculations from other Excel sheets. On this tab you must name the cells so their input or output can be included in self-services as well as in case guide tasks.
Naming cells
Select a cell on the ”Calculation” tab that you want to use as an input or output field. Locate the Excel name box in the top left corner below the ribbon. Enter the cell name in the name box and press Enter.
| The cell name must be unique. It must only consist of letters, integers, and underscores (”_”). It cannot contain spaces, æ, ø, å, or other special characters. |
The cell now has a name and can be used in calculations in self-services and in case guide tasks defined via the ”Task layouts” tab.
If you are referring to an output field, remember to add its formula.
Add formula to output field
Select a cell on the "Calculation" tab to be used as an output field. Write an equals sign "=" in the cell and specify the cell names that the output field should perform a calculation on, as well as a calculation operator.
For example, if the output field should calculate the sum of the input fields "loc1" and "loc2", write the following in the output field: =loc1+loc2 and press Enter.