Interpolation

Use

Interpolation offers you the possibility of referencing to an equipment number in an ETM BOM or in an ETM Catalog when this number does not actually exist, as such, in the ETM catalog. The interpolated catalog values are derived from the catalog items situated above and below the equipment number you wish to interpolate and are used to calculate values for the new items.

You have two options as far as interpolation is concerned. One the one hand, you can interpolate when you enter the ETM BOM. This interpolation is then only valid for this one BOM. On the other hand, you can interpolate an entry directly in the ETM catalog. This makes a permanent change to the ETM catalog. You can also use interpolation to change existing catalog values.

You can only interpolate if the ETM catalog item that is to be interpolated lies between two existing adjacent equipment sizes (technical statistics). The average value when new, monthly repair costs and monthly depreciation and interest rate can then be determined with sufficient exactness.

Prerequisites

The number logic for the numbers in the catalog has to be subject to encoding.

Example of Interpolation

Existing catalog number A.1.02.0760

Catalog number

Characteristic

A.1.02.0760

Average value when new € 108.500,00

Monthly depreciation and interest, lower value €2,170.00

Monthly repair costs € 1,410.00

Interpolated catalog number A.1.02.0800

Catalog number

Characteristic

A.1.02.0800

Average value when new € 116,200

Monthly depreciation and interest, lower value €2,320.00

Monthly repair costs € 1,510.00

Existing catalog number A.1.02.0910

Catalog number

Characteristic

A.1.02.0910

Average value when new € 136,500.00

Monthly depreciation and interest, lower value €2,730.00

Monthly repair costs € 1,770.00

Example With Two Interpolations

Existing catalog numbers

Catalog number

Characteristic

A.1.02.0760

Average value when new € 108.500,00

A.1.02.0910

Average value when new € 136,500.00

Interpolation 1 for catalog number A.1.02.0800

(Calculation formula: Difference of € 28,000.00 x 40/ 150 + € 108,500.00 = Average value when new of €116,000.00)

Catalog number

Characteristic

A.1.02.0760

Average value when new € 108.500,00

A.1.02.0800

Average value when new € 116,000.00

A.1.02.0910

Average value when new € 136,500.00

Interpolation 2 for catalog number A.1.02.0850

(Calculation formula: Difference of € 20,500.00 x 50/ 110 + € 116,000.00 = Average value when new of €150,000.00)

Catalog number

Characteristic

A.1.02.0800

Average value when new € 116,000.00

A.1.02.0850

Average value when new € 125,320.00

A.1.02.0910

Average value when new € 136,500.00

Note Note

Interpolation takes place if an equipment lies between two technical sizes. Extrapolation must take place if the technical size of an equipment is max. 20% below the smallest or above the largest technical size. If the variances are larger, you have to manually enter the value.

End of the note.