This document details the process of modeling tests whose values are calculated from other quantitative test values using standard and scientific operators. The system provides the capability to define a test as calculated and also allows the assignment of a formula that may contain other tests as part of the equation. At the time test results are entered, the tests with a formula will substitute the variables with the test results of those tests used in the formula and hence compute the test result for the calculated test.
For more information on formulas, see Formula.
After a test template has been defined as calculated and then associated with a formula, a quality inspection (QI) request is created with a specification that has a calculated test. The actual values for the calculated test(s) are used as inputs to the corresponding formula variables in order to calculate the final test results.
The QMS702Fnc program has an operation that calculates the test status. The system updates the QI Request Test (QMSRQT) table with the correct formula operator and actual value when the test types are either quantitative or numeric qualitative or when the test result is qualitative.
When test result values are added or updated, the records are stored in the Test Results (QMSTRE) table.
Set up formula/lines, test template, QI request, and enter test results
Create a formula and formula lines.
Start 'Formula. Open' (CRS570).
On the E panel, specify a Formula identifier.
Specify a description.
In the Responsible field, specify the User ID of the person managing the formula.
Specify a value for each hierarchy (1-5).
To create a quality test formula, select '6 - Test' in one of the Hierarchy fields.
Select Related > Formula Lines.
In 'Formula Lines. Open' (CRS575), select the Create option to navigate to the E panel.
On each line in the grid that applies to a quality test, specify a '6' in the Ftp (Factor type) column to indicate the factor is for Quality Test.
Press F4 in the Factor 1 column to select the specific test name.
Specify the desired operator.
Specify the Result ID.
Repeat steps i-l for each line in the formula.
In the Negative results field, select the appropriate value to indicate how negative calculations results are treated.
In the Rounding-off multiple field, specify the rounding multiple to be used for the calculated value.
Click Next to return to the B panel of 'Formula. Open' (CRS575).
Press F3 to exit CRS575 and press F3 again in CRS570 to save your changes to the formula model.
Create or update a test template that has a calculated test and associate the test with a formula.
Start 'Test Template. Open' (QMS100).
Specify the required fields.
On the E panel, select the Calculated test check box.
In the Formula field, specify a Formula ID.
Save your changes.
Create a QI request with a specification that has a calculated test.
Start 'QI Request. Open' (QMS300).
On the A panel, select the Create option.
Specify the required fields.
In 'QI Request Spec Test. Open' (QMS302/E), select a test where the Calculated test check box is enabled and a Formula is assigned.
Specify test results for the QI request.
Start 'QI Test Results. Open' (QMS400).
On the B1 panel, specify values in the desired search fields in the header.
Highlight each desired test in the grid and enter the Test result value.
Click Next to save your changes.
When the test results are saved, the system identifies all components of the calculated test and applies them to the associated formula(s). When the test results are computed, the system updates the Test Results (QMSTRE) table for each calculated test.