Columns model

The columns data sheet has 3 fixed columns: ATTRIB, ATTCNT, ATTVAL that must be positioned in the first row of the sheet. It is not necessary that the columns are the first three. Let's see the meaning of the columns:

ATTRIB
is the key attribute to look for and the syntax is <attribute name> = <attribute value>. By default, the key attribute is CODE and can be omitted. Typing:

FAMILY=FILLERS

you specify if you want to take all the parts that have the FAMILY attribute filled with FILLERS value. Specifying only:

KB1234

indicherò al software di catturare tutte le parti che hanno l'attributo CODICE impostato a KB1234. Ovviamente il caso descritto può essere inserito anche come:

CODE=KB1234

There are special cases in which the selection should not be made by attribute. For example:

$TOP

indicates selecting the TOP part regardless of the code.

You can also use regular expressions to have the finest selection filters. For example, if you want to capture all of the parts with the BH code prefix and 4-digit numerical code, you could write an expression like this:

CODICE=BH%d%d%d%d

For more information on regular expressions, refer to the documentation of the LUA programming language.

ATTCNT
is the attribute to be counted for the previous filter. By default, the count attribute is QTA that can then be omitted (empty cell). Typing LENGTH, you can indicate the software that you intend to count the LENGTH attribute of parts that meet the criteria defined by ATTRIB
ATTVAL
is the column that contains the values calculated by the software.

This criterion allows us to perform several calculations on the same side. The following example shows how to extract four fields from the TOP

The value of each field will be entered into ATTVAL column at the compiling time.