LookupTables are simple Excel spreadsheets that provide the basis for calculations. They can contain one, two or at most three dimensions â namely:
Columns (e.g. formats)
Rows (e.g. print run quantities)
Sheets (e.g. different machines or material types)
To keep things clear, we recommend working with a maximum of three dimensions.
The structure of these LookupTables is defined when they are created in the system and forms the basis for linking them to formulas in the Estimator later.
At the bottom of this article, you will find an example LookupTable to help you with its setup and structure.
After a successful upload, you can:
specifically search for values in the table
download the entire table as an Excel file
or edit the data directly in the system
This gives you full control of your pricing matrix at all times â without any additional tools.
đ Interpolation between values
You can also interpolate between two defined values.
Example:
If your LookupTable contains print runs of 200, 300 and 500 and you calculate a quantity of 350, the system automatically calculates the appropriate intermediate value between 300 and 500.
đ This gives you a realistic, dynamically calculated price even for values that are not explicitly stored â without any additional formulas.
â ď¸ Important note on interpolation
Please note: Only one interpolation is possible per LookupTable.
This means that interpolation cannot take place across several axes at the same time â for example, the X and Y axes in a multidimensional table.
â Interpolation only works in one dimension, for example across a single quantity scale such as print run quantities.