Commercial and technical article data

All commercial and technical attributes of your profile system are entered in the article data.

If you already use an article database in another software, it may be possible to import and export it from the existing article database into Logikal. This can be very effective because only one article database has to be managed for both programs. Please contact us, if you have the possibility of an article export from your administration software.

For all other cases we provide you an Excel template.  All articles of the system have to be listed in the table: Profiles, gaskets, screws, hardware, accessories, etc. We can import this table at any time and make corrections if necessary (e.g. price adjustments).

The standard table contains required and optional fields. The required fields are highlighted in red in the column header

Table Description

Column A: Product / Catalogue Number

This column uniquely identifies the article (max. 20 characters).

Column B: Order / Colour Number

In this column an article including coating is identified. Enter the order number and the colour number of the article.

Column C: Color

Name Enter the color name in this column. Please note that the same name should always be used for the same colors (e.g. not „silver anodized" and „anodized silver").

Column D: Product Description

In this column you can enther an article description with max. 60 characters.

Column E: Price per Unit

In this column, you enter the article price per unit. In the column header, select the currency from the dropdown menu.

Column F: Packing unit (from quantity)

In this column, you enter the packaging unit (PU). Please do not enter the delivery length for the profiles, but the minimum order quantity of the bars. For gaskets and accessories (length), please enter the corresponding length of the PU.

Column G: Part type / Item type

In this column, select the article type or part type. The dropdown in the column header displays a list of the article types that are possible.

Column H: Unit of quantity

In this column, select the unit of quantity of the article. The dropdown in the column header displays a list of values that are possible.

Column I: Discount group/Item group

In this column you can assign the articles to discount groups, e.g. Profiles_Iso, Profiles_Uniso, Hardware, Accessories, Gaskets. You can assign different discounts to discount groups in later estimations.

Column J: Bar length standard in mm

In this column you enter the bar lengths for all length-dependent articles, e.g. half shells, insulated profiles, locking bars, uninsulated profiles, connector profiles, accessories (meters). These details are required for the cutting lists and for the cut optimisation.

Column K: Bar length alternative 1 in mm

In this column you enter the alternative bar lengths for all length-dependent articles, e.g. half shells, insulated profiles, locking bars, uninsulated profiles, connector profiles, accessories (meters). Attention! Alternative bar lengths can be approved during estimation and work preparation. This does not allow free selection of the bar length when building elements. Logikal automatically calculates the optimisation for the existing alternative bar lengths.

Column L: Bar length alternative 2 in mm

Explanation see column K

Column M: Ix-value standard length in cm4

In this column, you enter the Ix value for the standard article length. This specification is required for the structural analysis.

Column N: Ix-value up to 1500mm in cm4

For thermally separated profiles, the static values are set in relation to the profile length. In these columns you enter the determined values for the respective profile length. Attention! Values entered here are preferred to the value for the standard length."

Column O: Ix- value up to 2000mm in cm4

For thermally separated profiles, the static values are set in relation to the profile length. In these columns you enter the determined values for the respective profile length. Attention! Values entered here are preferred to the value for the standard length."

Column P: Ix- value up to 2500mm in cm4

For thermally separated profiles, the static values are set in relation to the profile length. In these columns you enter the determined values for the respective profile length. Attention! Values entered here are preferred to the value for the standard length."

Column Q: Ix-value up to 3000mm in cm4

For thermally separated profiles, the static values are set in relation to the profile length. In these columns you enter the determined values for the respective profile length. Attention! Values entered here are preferred to the value for the standard length."

Column R: Ix- value up to 3500mm in cm4

For thermally separated profiles, the static values are set in relation to the profile length. In these columns you enter the determined values for the respective profile length. Attention! Values entered here are preferred to the value for the standard length."

Column S: Iy-value standard length in cm4

In this column, you enter the Iy value for the standard length of an article. This specification is required for the structural analysis.

Column T: Wx-value standard length in cm3

In this column you enter the Wx – value of the profile.

Column U: Wy-value standard length in cm3

In this column you enter the Wy – value of the profile.

Column V: Surface area profile in mm

In this column you enter the coating area for the profile development, which calculates the coating costs.

Column W: Visible surface profile in mm

In this column you enter the profile face for the surface to be mechanically worked. This data is used to determine the coating costs including anodizing costs. It is also used to determine the coating costs including anodizing costs.

Column X: Weight per meter/piece in kg

In this column you enter the profile or article weight in kilograms per meter. This is necessary to determine the sash weight when you order your profiles by weight.

Column Y: b-value profile for b/B-ratio

In this column, enter the width of the isolated area. This specification is necessary for determining the U-value using b/B curves and must be specified by the system provider in tests.

Column Z: Width profile in mm

Enter the geometric profile depth in this column.

Column AA: Height profile in mm

Enter the geometric profile height in this column.

Column AB: Article Status

In this column you define the specification if a note is to be made for the article. Under the dropdown in the column header you find the variants that are available for this.

Column AC: Assembly place

In this column, you specify the assembly places. You can use this if you want to create different evaluations, e.g for construction site and production. In the dropdown in the column header you find the variants that are available for this.