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)	Returns the arccosine of a number ⟨-Pi/2; Pi/2⟩	for X=0.5 ... DEGREES(ACOS(0.5)) ⇒ 60°
ACOT	ACOT(Number)	Returns the arccotangent of a number ⟨0; Pi⟩	for X=1 ... DEGREES(ACOT(1)) ⇒ 45°
ASIN	ASIN(Number)	Returns the arcsine of a number ⟨-Pi/2; Pi/2⟩	for X=0.5 ... DEGREES(ASIN(0.5)) ⇒ 30°
ATAN	ATAN(Number)	Returns the arctangent of a number ⟨-Pi/2; Pi/2⟩	for X=1 ... DEGREES(ATAN(1)) ⇒ 45°
COS	COS(Angle[rad])	Returns the cosine of the given angle in rad	for α=60° ... COS(RADIANS(60)) ⇒ 0.5
SIN	SIN(Angle[rad])	Returns the sine of the given angle in rad	for α=30° ... SIN(RADIANS(30)) ⇒ 0.5
COT	COT(Angle[rad])	Returns the cotangent of an angle in rad	for α=45° ... COT(RADIANS(45)) ⇒ 1
TAN	TAN(Angle[rad])	Returns the tangent of an angle in rad	for α=45° ... TAN(RADIANS(45)) ⇒ 1
EXP	EXP(Number)	Returns e raised to the power of a given number	EXP(1) ⇒ 2.71828
LN	LN(Number)	Returns the natural logarithm of a number	LN(1)) ⇒ 0; LN(EXP(1)) ⇒ 1
LOG	LOG(Number;[Base=10])	Returns the logarithm of a number to a specified base (10 if missing)	LOG(1; 10) ⇒ 0; LOG(10; 10) ⇒ 1
LOG10	LOG10(Number)	Returns the base-10 logarithm of a number	LOG10(1) ⇒ 0; LOG10(10) ⇒ 1
PI	PI()	Returns the value of pi	PI() ⇒ 3.141592653
POWER	POWER(Base;Number)	Returns the result of a number raised to a power	POWER(2;4) ⇒ 16
SQR	SQR(Number)	Returns the result of a squared number	SQR(5) ⇒ 25; SQR(-5) ⇒ 25
SQRT	SQRT(Number)	Returns a positive square root of a positive Number	SQRT(36) ⇒ 6; SQRT(-36) ⇒ NAN
SUM	SUM(Number1;Number2; ... )	Returns the sum of a series of numbers	Result is number (bold inputs linked to data X[0;1;2;3;4;5;6]): SUM([X_PDL⇓2:⇓5]) ... SUM(⟨1; 2; 3; 4⟩) ⇒ 10 SUM([X_PDL⇕]) ⇒ 21
DEG	DEGREES(Angle [rad])	Converts radians into degrees	DEGREES(PI()) ⇒ 180°; DEGREES(PI()/2) ⇒ 90°
RAD	RADIANS(Number)	Converts degrees to radians	RADIANS(180) ⇒ π (3.141592653)
ROUND	ROUND(Number;Places)	Rounds a number to a specified number of digits - negative Places round to the left of the decimal point	ROUND(58.563;3) ⇒ 58.563 ROUND(58.563;2) ⇒ 58.56 ROUND(58.563;1) ⇒ 58.6 ROUND(58.563;0) ⇒ 59 ROUND(58.563;-1) ⇒ 60 ROUND(58.563;-2) ⇒ 100
ROUNDUP	ROUNDUP(Number;Places)	Rounds a number up, toward zero	ROUNDUP(58.563;3) ⇒ 58.564 ROUNDUP(58.563;2) ⇒ 58.57 ROUNDUP(58.563;1) ⇒ 58.6 ROUNDUP(58.563;0) ⇒ 59
ROUNDDOWN	ROUNDDOWN(Number;Places)	Rounds a number down, toward zero	ROUNDDOWN(58.563;3) ⇒ 58.563 ROUNDDOWN(58.563;2) ⇒ 58.56 ROUNDDOWN(58.563;1) ⇒ 58.5 ROUNDDOWN(58.563;0) ⇒ 58 ROUNDDOWN(58.563;-1) ⇒ 50 ROUNDDOWN(58.563;-2) ⇒ 0

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