About Data Collect Plan - Formula Editor

You can specify formulas on Data Collect Plans.

This page discusses:

See Also
Formula Editor Dialog Box
Creating a Formula - Example Workflow
Using Create Data Collect Plan Instruction
Data Collect Checklist and Data Collect Plan Dialog Boxes
CATRule for Display Names for Functions and Math Functions

Click Play to watch the video:

The formulas can compose of:

  • Reference to custom attribute value on Requirements
  • Reference to collected values on the shop floor from Rows on the current or previous Data Collect Plan
  • Reference to computed value, or values, by formulas on previous Rows on the current or previous Data Collect Plan
  • Numbers (0…9)
  • Brackets for logical grouping ((A – B) x (C – D))
  • Mathematical functions: Sum(), Average(), Min(), and others.
  • Mathematical Operators: +, -, *, /

The formula types are:

  • Computed (Mono-value): one single result value computes for the formula.
  • Computed (Multi-values): several results are computed for a row using the Computed mode.

Computed (Mono-value)

Mono-value formulas uses for calculating exactly one resulting value.

Examples:

  1. Formula that references previously collected values.

    Here the formula of Row 3 uses the collected values from Req_A and Req_B to compute a single result.
  2. Formula that references a result of a previous formula.

    Here the formula of Row 4 uses the computed values from Req_C to compute a single result.
    Note: Specification of a formula that uses a result of a previous formula, imposes to reference it through a requirement.
  3. Dedicated, predefined formulas to compare sets of collected values. Intent is to compare the collected values for several dimensions (Requirements); the comparisons done for the same rank of collected value. Example: Four measures on items A, B, and C.

    The formula of Row 4 makes a computation based on the four collected values for each Requirement and give back a single result.

    In the example: REQ_A.x means the rank x of the collected value for REQ_A.

    Result = Minimum((REQ_A.1 - REQ_B.1 – REQ_C.1),

    (REQ_A.2 - REQ_B.2 – REQ_C.2),

    (REQ_A.3 - REQ_B.3 – REQ_C.3),

    (REQ_A.4 - REQ_B.4 – REQ_C.4))

    Similarly, the formula of Row 5 makes a computation based on the four collected values for each Requirement and gives back a single result.

    Result = Maximum((REQ_A.1 - REQ_B.1 – REQ_C.1),

    (REQ_A.2 - REQ_B.2 – REQ_C.2),

    (REQ_A.3 - REQ_B.3 – REQ_C.3),

    (REQ_A.4 - REQ_B.4 – REQ_C.4))

    Note: At execution in APRISO, the computation relevant only if the same number of measurements are done for each collect.

Computed (Multi-values)

Use multi value formulas when there is a need to calculate multiple results from a single formula definition.

Example: Intent is to support that the minimum, maximum and average values of a dimension can compute from a list of dimensions. Specify computation for a Requirement depending to a set of dimensions corresponding to several Requirements on which data collects.



For example, define one formula to calculate the minimum clearance between an assembly. However, the result composes of three values: the minimum (clearance), the maximum (clearance) and the average (clearance).

The other two formulas (maximum and average clearance) auto-generate by the software.

Alternatively, you could define the formula to calculate the maximum clearance. And the result is the same three values: minimum (clearance), maximum (clearance) and average (clearance).

The selection of Computed (multi-values) for the formula type and specify the formula for minimum or maximum.

Note: Only the specification of minimum or maximum formula allows you to automatically compute the two other formulas. Definition of the Average formula is not sufficient to compute the other formulas. Only the specified formula builds by you in the formula editor. The two other formulas define internally by the system.

Examples:

  1. One formula specified by you with three results.

    Here the formula of Row 5 defines to get the minimum clearance.

    Result (minimum) = REQ_A.CollectedMin -REQ_E.CollectedMax -REQ_M.CollectedMax -REQ_C.CollectedMax

    The other two formulas automatically define by the system.

    Result (maximum) = REQ_A.CollectedMax -REQ_E.CollectedMin -REQ_M.CollectedMin -REQ_C.CollectedMin

    Result (average) = REQ_A.CollectedAverage -REQ_E.CollectedAverage -REQ_M.CollectedAverage -REQ_C.CollectedAverage

    This results in three values computed on the shop floor.

  2. The formula references the multiple results of a previous multi value formula.

    Here the formula of Row 6 uses two of the three computed values from Req_J.