Create Formula – A summary of the activity
This activity allows you to create a formula. This formula can be used to update parameter values based on other parameter values. Only parameters, for which the source of updation is specified as “Formula”, can be updated using a formula.
You can create a formula with a unique code and provide a description and status to it. You can specify the contents of the formula by specifying parameters along with arithmetic operators. You can enter the parameters directly or select parameters by carrying out a search based on the parameter, its description and type. You can specify only parameters that are of type “Range” or “Consumption”, in the formula.
You can also specify inspection points along with the parameters. You can specify the inspection points directly or select the inspection points by carrying out a search based on the inspection point and its description. Inspection points can be specified only for a range parameter. When an inspection point is specified along with a parameter in a formula, it indicates that the parameter value at the specific inspection point must be used in the formula for calculation purposes.
The system creates the formula and stores the login ID of the user who created the formula along with the date and time of creation.
Rules to be followed while creating a formula:
Only range and consumption parameters can be referred in a formula.
The numeric values such as positive, negative integers and decimals can take part in a formula.
The operators +, -, *, / are allowed, and a valid operator should be present between two parameters or between a parameter and a numeric factor.
An operator should have a parameter or a numeric value before and after.
Operators should always be separated by either numeric factors or parameter codes. P1/(P2+P3) is a valid formula, whereas P1//(P2+P3) is invalid.
Parentheses are allowed in a formula and they should be paired.
The factors specified in the formula must be numeric. Example: 2.1*(P1+P2) is a valid formula, whereas a*(P1+P2) is invalid.