Create Formula – A summary of the activity

Transportation Industry, especially Aviation, requires that the values of various attributes such as “Running Hours” and “Cycles” of the operating assets must be tracked for the purpose of usage based maintenance, reliability studies and replacement analysis. Some of these attributes (parameters) are independent, whereas others are dependent on certain parameters. This activity allows you to define a formula that helps in calculating the value of such dependent parameters.

In this activity, the parameters that participate in a formula are selected and the relationship between the parameters is defined with the help of mathematical operators. The formula is then associated to the dependent parameter (associated parameter) in the “Create Aircraft Information” activity under the “Aircraft” business component.

Example:

• The value of the dependent parameter, “Fuel efficiency” is calculated by defining the relationship between the participating parameters “Fuel Consumed” and “Distance Run”.

• The formula “F1= Distance Run / Fuel Consumed” is created, where F1 is the formula ID, "Distance Run" and "Fuel Consumed" are the participating parameters and "/" is the mathematical operator used.

• F1 is associated to “Fuel Efficiency”, which is the associated or dependent parameter, in the “Create Aircraft Information” activity under “Aircraft” business component.

You can provide a unique identifier for the formula. You can select the participating parameters for the formula and you can define the relationship between them using mathematical operators and constant coefficients.

The system creates the formula and sets the status of the formula to “Active”. Whenever the participating parameter values are updated, the formula builder computes the value of the dependent parameter as per the relationship defined and returns the computed value as the output value.

Follow these rules while creating a formula

•  Only the consumption and range parameters created in the “Aircraft” business component that are in “Active” status, can participate 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 seperated 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.

       Click here to learn about creating formula