List Settings

Material lists - List settings

For each list type, multiple list settings or list templates can be saved and called up at any time. Exactly one setting must be set as current for each list type. The list settings contain the column settings for screen and output, as well as the other settings for saving into documents.

List types are distinguished according to the component types processed in these lists. This affects the values displayed in each row and the results calculated for the lists. For example, the 'area' in a timber list is the surface area of the longitudinal and end faces, while for a panel the area is usually only a visible face. The available list types are:

Article lists: Article lists record all materials that cannot be assigned to any other list type. For the materials in the article list, a quantity is entered directly according to the billing unit.

Only the total quantities according to the billing units are determined as results and measured values from article lists.

Materials from the measurement sets (calculation module) are recorded in article lists.

Fittings and fasteners lists: These lists record fittings (e.g. beam shoes) and fasteners (e.g. screws). Unlike shaped parts, fittings are procured as finished components. For fasteners, diameter and length can be recorded as separate values. The quantity can be specified for each list row.

As results and measured values from fittings and fasteners lists, quantity, lengths and weight are determined.

Windows - Doors list: The windows and doors list records windows, roof windows, exterior and interior doors. Typical information such as hinge side, number of leaves, etc. can be specified in the description. Width and height for roof windows are the nominal width and nominal height. For other windows and doors they are the enclosing width and height of the raw opening. A special value of this list type is the 'area': the exact area of the raw opening is passed by the programs. This value is suitable for a quick, approximate calculation.

As results and measured values from windows and doors lists, quantity, areas (raw opening) and weight are determined.

Shaped parts list: Shaped parts lists record components with the component type shaped part. These are, for example, gusset plates fabricated by the metalworker. Since they can have arbitrary shapes, only the weight per piece can be entered as a value; this must be determined manually.

As results and measured values from shaped parts lists, quantity and weight are determined.

Timber list: Timber lists record components with the component type bar. These are typically structural timbers, but can also be other materials. Accordingly, the values cross-section width and height, as well as length, are recorded here. Timber list rows also contain related measured values for the machining, e.g. the number of notches per bar of the row.

As results and measured values from timber lists, quantity, linear meters, surface (longitudinal + end faces), volume and weight are determined. In addition, the measurement totals for the machining operations are calculated.

Panel list: Panel lists record components with the component type panel. These are typically wood-based panels, but can also be other materials. Accordingly, the values thickness, width and length are recorded here. Width and length correspond to the bounding rectangle of the panel.

As results and measured values from panel lists, quantity, linear meters, panel area (a visible area of the bounding rectangle), volume (from bounding rectangle) and weight are determined.

Profile bar list: Profile bar lists record components with the component type profile bar. These are typically web beams and steel beams, but can also be other materials. Accordingly, length is recorded here. Profile bar list rows also contain related measured values for the machining, e.g. the number of notches per profile bar of the row.

As results and measured values from profile bar lists, quantity, linear meters and weight are determined. In addition, the measurement totals for the machining operations are calculated.

Roof tile list: The rows of the roof tile lists record the number of tiles or roofing shingles of this model and type.

As results and measured values from roof tile lists, quantity and weight are determined.

Material lists - List settings - Column settings

The material lists - column settings control the columns for the screen display and the output, i.e. saving to documents. For the columns that are available depending on the list type, the following can be set:

Column text: This is the text that is written as the column header on the screen and in the printout.

Rank: The rank specifies the order of the columns. If the rank is 0, the column is not displayed and is not output. When rows are consolidated during output, this column is also not considered accordingly.

Rounding: A rounding can be specified for numeric values. Not only the number of decimal places, but also an interval is taken into account. If the rounding is set to 0.5, values are rounded to the next half or whole. The rounding refers to the currently set unit.

Special roundings exist for the building element and the weight/reference. If only one roof is recorded in the list anyway, it is entirely sufficient for the building element to display only the roof area number. If, however, multiple roofs are recorded, the roof number must also be displayed.

Different materials, e.g. wood, have a range for their specific weight. For the weight/reference it can be specified whether the minimum, mean or maximum value of this range should be used for the calculation. This setting cannot be changed after a list has been created.

Unit: For numeric values, the unit can be specified in the column settings. Units can also be changed for existing lists. For example, the same list can be output once in [m] and once in [mm].

The unit for prices is specified in 'Extras - Settings' for the primary and secondary currency. During output it is then decided whether the primary or secondary currency should be used.

Tab stop: With the column settings - tab stop, the column width in [mm] and the tab stop type for output are set. The column width on the screen is determined automatically by the widest displayed column content.

WordPad recognizes only left-aligned tab stops. An attempt will be made to convert other tab stop types to left-aligned ones, which may result in differences. Therefore, in general we recommend using only left-aligned tab stops for WordPad.

Row / Total: It can be configured per column whether a value should be output per row and/or as a total for the entire table. The exact effect depends on the value:

If, for example, identifiers such as the order number should also be output as a 'Total', it will appear above the table. If only one order number is used in the table, it will be specified; if different ones are used, asterisks *** will be shown here.

If, for example, results such as linear meters should be output per row and as a total, the linear meters of each row are specified in an extra column and shown under the table as a sum in a totals row. If the result should only be output as a total, it will be displayed below the table in a separate block.

Material lists - List settings - Output settings

In the material lists - output, the material lists are saved into documents. In addition to the general options, there are special possibilities here for saving into documents:

Length surcharges: Length surcharges during output are only charged to the output list; the original lengths remain stored in the database.

Currency: It can be specified whether the primary or secondary currency should be indicated for prices. Additionally, an extra line with the conversion to the respective other currency can be output at the end. Primary and secondary currencies are defined in 'Extras - Settings'.

Prefix / Suffix text: It is specified which of these text elements should be included in the output.

Selection: In the selection during material list output it can be determined which part of the list should be output. In addition to 'All', the following options are possible:

Package / Element number: When outputting, a list of all existing package numbers appears first for the selection.

Building element: When outputting, a list of all existing building elements appears first for the selection.

Ident number: When outputting, a list of all existing ident numbers appears first for the selection.

Delivery location: For all rows of the lists it can be distinguished whether they are to be delivered to the workshop or to the construction site (installation). When outputting, it can be chosen whether the rows should be output only for one or for both delivery locations. If both are to be output, the rows can also optionally be consolidated if they are otherwise identical.

Source type: For all rows of the lists it can be distinguished whether the item is stock material or has to be ordered. When outputting, it can be chosen whether the rows should be output only for one or for both source types. If both are to be output, the rows can also optionally be consolidated if they are otherwise identical.

Consolidation: In the lists, the raw body numbers (= timber list numbers) and running numbers are distributed across the packages and building elements in the rows. Two identical rafters with the same running number that lie on two roof areas appear in two separate rows. In the output, these can be consolidated back into one row if consolidation by running number is selected.

If consolidation is done by the raw body number (= timber list number), then optionally all running numbers that were consolidated under this raw body number can be specified in the column with the running numbers.

Consolidation as a saw list does not take the raw body number (= timber list number) into account, but only width, height, length, description and order number for the consolidation. Here too, the consolidated running numbers can be specified.

Note: Due to the new sorting, it is, for example, possible to start with running number 1 in each wall (depending on the production process this has organizational advantages). This of course no longer guarantees that running number 1 from one wall corresponds to running number 1 from another wall. This must be taken into account when outputting and consolidating lists.

Total calculation: For the list, sums can be formed for certain values. These, if desired, are output as totals for the entire list. Additionally, intermediate totals can be generated for the existing ident numbers or order numbers.