Interpolation 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.
The number logic for the numbers in the catalog has to be subject to encoding.
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 |
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 |
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 |
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
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.