Formula Specification in Templates
List of formula specification using in Templates.
Categories of functions:
Logical
| Name | Syntax, parameters | Description | Example |
|---|---|---|---|
| AND | AND(Boolean1;Boolean2; ... ) | Returns TRUE if all of its arguments are TRUE | AND(3=3;2=2) ⇒ TRUE |
| OR | OR(Boolean1;Boolean2; ... ) | Returns TRUE if any of its arguments are TRUE | OR(3=4;2=3) ⇒ FALSE |
| TRUE | TRUE() | Returns the logical value TRUE | IF(TRUE();1;2) ⇒ 1 |
| FALSE | FALSE() | Returns the logical value FALSE | IF(FALSE();1;2) ⇒ 2 |
| IF | IF(Test;Then;Else) | Specifies a logical test to perform
- inputs can be linked to data - result can be number, text, logical value |
Result is number (bold inputs linked to data X[0;1;2;3;4;5;6]):
IF(220>200;220-200;200-220) ⇒ 20 IF(120>MAX([X⇕]);120;-1) ⇒ 120 IF(MAX([X⇓2:⇓3])>[X⇓7];MAX([X⇓2:⇓3]);[X⇓7])) ⇒ 6 IF(MAX(⟨1;2⟩)>6;MAX(⟨1;2⟩);6) ⇒ 6 Result is text: Input [Coordinate Z] = 210;[GWT] = 180 IF([Coordinate Z]>0;"Above terrain";"Under terrain") ⇒ "Top above terrain" IF([GWT]<[Coordinate Z];"GWT under top of the test.";"Measure error.") ⇒ "GWT under top of the test." |
| IFS | IFS(Test1;Then1;Test2;Then2; ... ;Else) | Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition | Input [GWT] = 15
IFS([GWT]>8;10;[GWT]>6;9;[GWT]>3;8;-1) ⇒ 10 |
| NOT | NOT(Boolean) | Reverses the logic of its argument | IF(NOT(5>6);175;155) ⇒ 175
IF(NOT(5>4);175;155) ⇒ 155 IF(NOT("A"="B");175;155)⇒ 175 |
| SWITCH | SWITCH(Switch;Case1;Result1;Case2;Result2; ... ;[ Else ]) | Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned | SWITCH(50>6;TRUE();44;FALSE();56;-111) ⇒ 44
SWITCH(30/6;3;120;4;220;5;320;420) ⇒ 320 |
Mathematical
| Name | Syntax, parameters | Description | Example |
|---|---|---|---|
| ABS | ABS(Number) | Returns the absolute value of a number | ABS(120) ⇒ 120
ABS(-120) ⇒ 120 |
| ACOS | ACOS(Number) | ||
| ACOT | ACOT(Number) | ||
| ASIN | ASIN(Number) | ||
| ATAN | ATAN(Number) | ||
| COS | COS(Number) | ||
| SIN | SIN(Number) | ||
| COT | COT(Number) | ||
| TAN | TAN(Number) | ||
| EXP | |||
| LN | |||
| LOG | |||
| LOG10 | |||
| PI | |||
| POWER | |||
| SQR | |||
| SQRT | |||
| SUM | |||
| DEG | |||
| RAD | |||
| ROUNDUP | |||
| ROUNDDOWN |
Text
| Name | Syntax, parameters | Description | Example |
|---|---|---|---|
| CONCAT | |||
| LEFT | |||
| RIGHT | |||
| LENGTH | |||
| FIND |
Statistical
| Name | Syntax, parameters | Description | Example |
|---|---|---|---|
| AVERAGE | |||
| MAX | |||
| MIN | |||
| PERCENTIL | |||
| STDEV | |||
| MODUS | |||
| MEDIAN |
Matrix
| Name | Syntax, parameters | Description | Example |
|---|---|---|---|
| LINEARTREND | |||
| LINEARTRENDANDPOINTS | |||
| LINEARTRENDSC | |||
| LINEARTRENDSCANDPOINTS | |||
| LINEARTRENDTOPOINTS | |||
| SEMICIRCELTOPOINTS |