New version of the Virtual Applications Mc driver:
For users who use Numeric fields to store variables and use them in rules and need to perform some basic calculations with the variables, I have added new fields to the profile number-field-5, to enter the calculation formula and show the result.
For example, to calculate the average, maximum or minimum temperature value of several sensors.
I have also added a Capability of information that explains how to introduce the formula and whether the formula entered is correct or not.
Calculations that can be performed:
-
Average of up to 5 consecutive fields:
- Write an “A” or “a” followed by the last field number to perform the calculation.
For example A4: Returns the Average value of the values of fields 1 to 4
- Write an “A” or “a” followed by the last field number to perform the calculation.
-
Maximum value of up to 5 consecutive fields:
- Write a “>” followed by the last field number to perform the calculation.
For example >3: Returns the maximum value of the values of fields 1 to 3
- Write a “>” followed by the last field number to perform the calculation.
-
Minimum value of up to 5 consecutive fields:
- Write a “<” followed by the last field number to perform the calculation.
For example <4: Returns the minimum value of the values of field 1 to 4
- Write a “<” followed by the last field number to perform the calculation.
-
Formula with Free Text for 5 field numbers:
-
Operators “+”, “-”, “x” or “*”, “/” or “:” can be used
-
The beginning and end of the formula must be a field number.
-
After each field number an operator character will always follow
-
Field numbers and operators can be repeated
-
1+3-2x5:4+3…
-
Operations are performed sequentially from left to right.
-
If the formula is not written correctly, a warning of incorrect formula and result = 0 will appear.
-
If the formula is well written, a Correct Calculation notice and the result will appear. After 5 seconds the instructions for use are shown again.
-
Currently the numerical fields, including the result field, do not show decimals in the details view due to a problem with the presentations. It is already reported to @Nayelyz. In the data entry, tile and history window you can see the decimals.
-
To make it easy to use, every time a value in one of the 5 numerical fields is changed or updated, the calculation of the formula that is entered in the Formula field is updated. This allows the result to be automatically updated with each change of the operands.
-
If a formula is not entered, the fields continue to function as numerical fields and a result is not calculated. In this case the result field can be used as another additional numerical field.
-
More calculations could be added, but I don’t see possible uses, if anyone needs any additional calculation formula or see some error, please tell me.
New driver version will be automatically updated in 12 hours max
───────────────────────────────────────────────────
Name Aplicaciones Virtuales Mc
Version 2024-01-19T16:11:15.982360253
───────────────────────────────────────────────────