Defining formulas

Define generic formulas to establish any calculation that produces a minimum or maximum critical value for an inspection point aspect combination or any calculation with entered monitored data, and then identify where those formulas are executed. First, define the actual formula, and then define parameters used within the formula. Formulas with SQL statements defined for the parameters used in the formula are calculated.

To define formulas:

  1. Select Work > Inspections > Formulas.
  2. Click New Record.
  3. Specify this information:
    Formula ID
    Specify a unique code identifying the formula, and then enter a description of the formula in the adjacent field.
    Class
    Specify the class of the formula.
    Formula
    Specify the actual formula using codes to identify parameters. For example, to calculate minimum allowable thickness (MAT) for a cylindrical shell using design pressure (DP), actual outside diameter (OD), and nominal design stress (NDS), enter the following equation:

    $MAT = $DP * $OD/ (2 * $NDS + $DP)

    Note: All parameters must have a dollar sign prefix ($).

    To create parameters immediately, click Verify Parameters. It is verified that the parameters exist. If they do not exist, you are asked if you want to create a new parameter. Click Yes. A new parameter is inserted for the formula and updates the Parameters list on the Parameters page.

    To perform a validation of a formula, click Validate Formula.

    Depending on your system configuration, Validate Parameters and Validate Formula may not be displayed. Contact your system administrator for additional information.

  4. Click Save Record.