Compare Calculations

In order to quickly and easily compare or evaluate possible costing alternatives, FACTON offers a visual comparison of calculations. This gives you a quick overview on the differences between two Should Cost Calculations or versions.

All properties of the elements in the calculation structure are compared, except for properties that are listed in the Details ► Information. The following differences are recognized:

  • Differences in the structure of the calculation, such as missing element, added or removed element, or change of order
  • Differences in properties, such as changed element properties
  • Combination of both (differences in structure and properties)
Note

The calculation or version you selected first in the Result view is shown on the left side of the Structural Comparison view.

With every change of the underlying calculation, the comparison needs to be repeated to keep the data up-to-date.

The calculation comparison can be used for two different cases:

Compare two Calculations / Versions

You can either compare two Should Cost Calculations / Overhead Rate Calculations or two versions.

Compare two Calculations / Versions

  • You are logged in as Calculator.
  • You are in the Calculations workspace.
  1. Run query to search for the calculations / versions.Closed

    Run Query on Calculations

    1. In the Explorer ► Queries, click on button in front of SC calculations.

      You can run queries for the following calculation groups:

      • All Overhead Rate Calculations - CSW
      • All Overhead Rate Calculations - Versions
      • All Should Cost Calculations - CSW
      • All Should Cost Calculations - Versions
      • All Should Cost Calculations - Versions - Exportable
    2. Click on a calculation group whose calculation you are looking for.

      A new »Query : <Calculation>« tab opens where you can set query parameters.

    3. Set any query parameters.
    4. Click the Run button to run the query.

      All calculations found for the selected calculation group are displayed in the Result view.
  2. Select the two calculations / versions in the Result view you want to compare.
  3. Right-click on the selected elements ► Compare.

    The comparison of the selected calculations / versions opens in a new tab.

Compare Calculation with its Version

You can compare a Should Cost Calculation / Overhead Rate Calculation with one of its versions.

Compare Calculation with its Version

  • You are logged in as Calculator.
  • You are in the Calculations workspace.
  • You have opened a calculation which you want to compare it with its version.
  1. Use the selection view to switch to the Work History view.

    All available versions and the calculation with the current status of work (CSW) are shown.

  2. In the Work History view, select the calculation and a version you want to compare.
  3. Right-click on the selected elements ► Compare.

    The comparison of the selected calculation and version opens in a new tab.

Views and Symbols

Structural Comparison View Details View
  • Overview of differences in the calculation structure of both calculations / versions
  • Direct comparison of the calculation structure is possible
  • Column »Different« shows a symbol, if two elements or values of the same property are different
  • Detailed overview on differences of the selected calculation element in the Structural Comparison view
  • Column »Different« shows a symbol if two elements or values of the same property are different
  • Column »Value #1« and »Value #2« show the properties of the selected calculation elements in direct comparison
Symbol Description
This element has properties with different values.
This element and its sub-elements have properties with different values.
This element has different sub-elements.

Comparison Algorithm

FACTON provides two algorithm to compare calculations:

The matching algorithm opposes two elements, one from the left and one from the right calculation. The comparing algorithm compares this match.

Matching Algorithm

The matching algorithm iterates the calculation, element by element and sub-element by sub-element. The sub-element can only match if they are under matching elements. A left element that does not match a right element (or vice versa) is opposed to an empty row in the Structural Comparison view.

Whether elements match is determined by the following matching rules:

Elements in a calculation match, if

  1. they have the same type and element properties
  2. they point to the same master data
  3. they have the same the top level element (roots) in a calculation

The following element properties for matching elements are:

  • quantity type (e.g. for material in mass is the material price in [currency]/kg)
  • label

Comparing Algorithm

The comparison algorithm on the other hand compares elements not by all of their properties, but by a set of comparison properties, you can configure. The property value is also compared according to its amount and not according to its representation.

ClosedAn example:

The material price is compared according to its amount and not according to its presentation, i.e. »1,000 g« equal »1 kg« or »1 EUR« (depending on the exchange rate) equals »1.2 USD«.