Calculation Import Templates

This section describes the properties of the Excel templates (Version: 9.0.0.1) for importing and updating to the Should Costing Solution.

With each release, you are provided with new Excel templates for the import into the FACTON Should Costing Solution.

Download the Excel templates:

	Excel template: SC Calculation
	Excel template: Sub-structure of a calculation

Structure of Excel templates

Metadata of Excel templates

The metadata of the Excel template is required for the correct allocation of the imported data and should not be edited. In the orange table, you maintain the metadata or data that applies equally to the entire data table.

• SheetVersion shows the version of the Excel template.

Data Table

The data table contains all data for the Excel import.

Extract of the Excel template

Excel rows

With every Excel row, you determine an additional calculation element for the import.

For each of these calculation elements you have to indicate the level depending on the element above or below - with the help of a numeration in the #Level column.

For an import of a complete calculation, the top-level element is equal to the calculation and thus must have the lowest number, e.g. »0«.

For an import of a sub-structure, several elements can have the lowest number.

Excel columns

With every Excel column, you determine an additional property of the calculation element. The column names can vary with every Release. The version of the Excel template needs to match the Release version of FACTON.

Required columns

Column	Description
#Structure	Display of the calculation structure. This column is irrelevant for the import process; it only purposes visualizing the structure.
#Level	Display and input of the structural level of the element. This column is relevant for the import process only; it does not purpose building the calculation structure.
_Signature	Indication of the type of calculation element, e.g. Assembly or Material.

Supported Data Types

Unit values:

Master data with unit values (e.g. Duration) always consist of two columns: one for the value and one for the unit.

Localized values

Localized values can be shown as dependent or independent from language.

In order to show language independent texts, you need to use »Invariant« as suffix (e.g. column »Label.Invariant« or »Description.Invariant«). In order to show language dependent texts, use the ISO Two letter Language Code as suffix for the property name (e.g. column »Label.de« and »Label.en«).

Boolean (logical values):

The Boolean type has two value forms. The truth value is either »TRUE« or »FALSE« .

Integer:

The number type is for integers.

Number:

The number type is for floating point figures with or without decimal places. In FACTON, the values are rounded to the twelfth decimal place.

Text

The text type is for character strings of variable length.

Date:

The date type is for date specification.

Single Selection list:

A single semantic key is entered into the single selection list.

An example for illustration:

This entry of the Excel template in the FACTON client stands for the Material Classification "Basic Material » Metal » Steel » Basic Steel".

Multi-Selection list:

Several semantic keys are entered into the multi-selection list.

An example for illustration:

This entry of the Excel template in the FACTON client stands for the Manufacturing Method "Primary Shaping » Casting" and "Primary Shaping » Extrusion".

Identify semantic keys in FACTON

You can identify the semantic keys to use them for Excel imports by running queries in FACTON. The place where to use the semantic key in the Excel template is shown in the column XXX.Key.