Formulas
Formulas are available in the links of Tests for Operations of Product Specifications. These formulas enable tests with specific controls to be created. They can be:
| • | time (measurement in hours and dates), |
| • | inches, |
| • | simple operations (addition, subtraction, multiplication, and division), |
| • | averages, |
| • | square root, etc. |
The field to be filled out is in Test of Specification Register, admin-IN-34177a1b-7a8f-487b-ba4f-48668ea8aafb-1509025661301-2876735a-517e-4820-8b7d-2266201c5473.
Values to be obtained through formulas are automatically calculated by the system as measurement values for each test are entered in the respective fields, if there is a totalizer test, that is, a test that has the formula to make calculations based on values entered in previous tests.
8a56bbb3-9906-486a-a388-9401e0920371Tip: Hence, so that the measurement that uses the calculated test enables the display of Formulas screen, an entry of test previous to this one must exist, since it uses values of previous tests because it is a calculated test. |
Besides, some notes are required, according to the following instruction:
| • | A test in Test Register must be created - a test specific to the use of formulas, with certain configured fields, for each type of calculation, according to the following table, that is, the test must be mainly of Calculated type: |
Status |
Fields/Contents |
||
Test Type |
Result |
||
DATE |
Test for Measurement |
Time (dd/mm) |
Entered |
Test for DATE Calculation |
Time (dd/mm) |
Calculated |
|
HOUR |
Test for Measurement |
Time (HH:MM) |
Entered |
Test for HOUR Calculation |
Time (HH:MM) |
Calculated |
|
Simple Operations |
Test for Measurement |
Dimens./Attribute |
Entered |
Test for Simple Operation Calculation |
Dimens./Attribute |
Calculated |
|
Averages |
Test for Measurement |
Dimens./Attribute |
Entered |
Test for Average Calculation |
Dimens./Attribute |
Calculated |
|
Calculations Made |
Test for Measurement |
Dimens./Attribute |
Entered |
Test for Calculations Made |
Dimens./Attribute |
Calculated |
8a56bbb3-9906-486a-a388-9401e0920371Important: For measurements with values in inches, the formula can be created normally, with simple operations. However, nominal value is shown in decimal places, and not in measurement format (4/64i). |
Calculation formulas to be registered in the product specification, when calculated tests are determined, follow the following criteria:
| • | Addition |
Each row of measurements are added. Example:
CALC test is the sum of ENS1 and ENS2 tests, that have 4 and 5 measurements respectively.
| • | CALC = ENS1 + ENS2 |
where:
| • | ENS1 -> it has 4 measurements |
| • | ENS2 -> it has 5 measurements |
In the calculation of CALC test, there are 4 measurements, which must be added in pairs, with concomitant rows.
Measurement |
CALC |
||||
01 |
ENS1 |
Measurement 01 |
+ |
ENS2 |
Measurement 01 |
02 |
ENS1 |
Measurement 02 |
+ |
ENS2 |
Measurement 02 |
03 |
ENS1 |
Measurement 03 |
+ |
ENS2 |
Measurement 03 |
04 |
ENS1 |
Measurement 04 |
+ |
ENS2 |
Measurement 04 |
-- |
-- |
-- |
+ |
ENS2 |
Measurement 05 |
ENS2 test, since it has 5 measurements, has the 5th measurement ignored because there is no other corresponding measurement to be added, since the addition must be in pairs.
| • | Subtraction |
It follows the rules presented for addition which are different from the subtraction operation.
| • | Multiplication |
It follows the rules presented for addition and subtraction which are different from the multiplication operation.
| • | Division |
It follows the rules presented for addition, subtraction, and multiplication which are different from the division operation.
| • | Square Root |
When the calculation formula requested for the test is square root, it will be concerning each one of the measurements defined for the test.
Example:
RQ1 Test -> 8 measurements -> 8 square roots, concerning each measurement
| • | Absolute Value |
It follows the rule presented for square root, being different from the absolute value operation.
| • | Average |
Average is calculated based on the sum of values obtained in each one of test measurements, and divided by the number of measurements.
Example:
MED1 Test -> it has 5 measurements
MED1 Test |
Value |
Measurement 01 |
10 |
Measurement 02 |
05 |
Measurement 03 |
10 |
Measurement 04 |
10 |
Measurement 05 |
15 |
Total (A) |
50 |
Average (B) |
10 |
Where:
A = total of measurements (measurement 01 + measurement 02 + ... + measurement 05)
B = average of measurements (total of measurements (A) / number of measurements (5))
See also
To query registers involved in this process, see the following topics:
| • | admin-IN-34177a1b-7a8f-487b-ba4f-48668ea8aafb-1509025661301-c43ae361-e5d9-4f3e-a1cb-fdda6632612a |