[Add items] 

The [Add items] dialogue will open. The dialogue contains all [Job ticket items] that are not available in the job ticket table.

You can select the items one by one via the check boxes or Select all / deselect all. You can also type part of the name in the search box in order to ease your search for a specific item.

The selected items are added at the bottom of the job ticket table.

1. Define the multiplier for the [Job ticket item] and its [Item values] in the first pricing column.
2. Select all cells of the new [Job ticket item] in the first pricing column, including the cell in row [Total:]. Copy the selected cells to all other pricing columns.
3. Add the new [Job ticket item] to the result table.

   Copy one of the available rows. Type the name of the [Job ticket item] in the cell of column A in the result table.

4. Create a cell reference from the result table to the cell in row [Total:] in the job ticket table. Create the cell reference in the same column as the first pricing column.

   • Create a relative reference to collect the value of the cell in row [Total:] in the job ticket table. For example: =D79. A relative reference is usually used for [Item type:] [Number] 

   • Create an absolute reference to collect a value from column [Amount:]. For example: =$C$84. An absolute reference is usually used for [Item type:] [Yes/No], [Date] or [Text].

5. Select the cell with the cell reference in the result table. Copy the selected cell to all other columns in the result table.
6. You can use the cells from the result table in the calculations.