BOM Matrix

With a BOM matrix, values can be provided with filters in tabular form. The configurator determines the first value matching the filter from the matrix and returns it. This makes it possible to react automatically to different dimensions or weights of a packaged good and to adapt the design.

Example for determining the skids

In the following example, a matrix is used to define the number of skids and the width and thickness of the skid based on the weight of the packaged goods and the outer length.

If the weight of the packaged goods is up to 1000kg and the length is up to 5000mm, 3 skids with the dimensions 80x80 are defined in the following example. If the weight is heavier, 4 skids with the dimensions 120x80 are used. If none of the filters apply, the last line is used (5 skids 120x120).

Note

The matrix does not independently establish the link to the filter values. This is done by the call in the formula.

Setup

In the matrix setup group the headers for values and filters can be defined. This is giving a clearer and better overview of the matrix.

The filters can be set up for two types: Number and Text.

In Number a filter size can be specified, for example the packed weight. This is illustrated in the example.

It is also possible to set the filter value to Text. This way you can filter on properties of a construction. As an example, the properties Vertical and Horizontal are entered in the rows. For each line a different thickness and number of runners is entered. When calculating the construction, it is looked which of the two properties is used. Depending on the property set, the skids entered are then used for the construction.

Using the matrix in a formula

In a formula, a matrix can be used via the MAT(...) function.

Example:

MAT("SKIDS", 1, PGW, LOM)

In this example, the first value (in the above example, this would be the number of skids) of the Skid matrix is retrieved. The first filter is applied to PGW, the second filter to LOM.

If the user wants to retrieve the width of the skid instead of the number of skids, the formula looks like this:

MAT("SKIDS", 2, PGW, LOM)