Formula interpreter 3.0

Getting started

Core idea is to let define users rules either directly (e.g. via editable Grid)
OR via specialized EXCELS thare are used to specify rules (talk with or WernerS about it).

It allows testing a solution and makes calculations and results visible.

Define a table for the formula interpreter.

For the formula interpreter you need a table with the following columns:

• Identifier
• Variable
• Formula
• Value
  
  This table can origin from several other tables which will be merged or from an Editable Grid from the [TIS]Board.
  Example:
  
  Here we have defined three variables (Length, Depth and Height) which should be multiplied (Rows 4, 5 and 6).
  Additionally several columns representing indices can be defined.

Insert the operation, choose the suitable columns, define names for the description column and the error column and define the formatting of the number values.

PLEASE NOTE:

• Column INDEX must be an Integer Column
• Column GLOBAL (from Version 3.1. on) must be boolean 

Indices are used like this: [L215](1), or if there are several indices [L215](2,2) 

Calculation

As soon as the formula field is defined, the formula interpreter tries to solve the formula and overwrite the value filed.
The formula itself can hold the names of one or several variable names and/or numbers.
The following formula inputs can be made:

• Variables are defined by square brackets: [variable name]
• if-then formulas are defined like that: IF ([V1] == [V2], 1, 2)
• AND and OR is defined like in the formula operator: && and  ||
• MIN([V1], [V2]) for minimum value
• MAX([V1], [V2]) for minimum value
• ABS([V1]) for absolute values
• ROUND([V1]) for rounding to an integer; see also MidpointRounding.AwayFromZero (MSDN)
• ROUND([V1], x) for rounding to an defined number of decimals (x).
• MOD([V2], 3) for Modulo calculations

Result

As mentioned before, the value fields in rows holding a formula were calculated.
Two additional columns were generated. The description column gives information about the calculation steps. The error column shows errors within the calculations. In the example the variable Height2 does not exist.

...

...

...

...