Formula Specification in Templates

List of formula specification using in Templates. (Notes: bold inputs for functions are linked to the data in program).

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	Inputs linked to data X[0;1;2;3;4;5;6]): SUM([X⇓2:⇓5]) ... SUM(⟨1; 2; 3; 4⟩) ⇒ 10 SUM([X⇕]) ⇒ 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	CONCAT(Value1;Value2; ... )	Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments - Value1, Value2, ... can be as Text or Number	CONCAT(12;34;56) ⇒ 123456.000 CONCAT("12";"34";"56") ⇒ 123456.000 CONCAT(12;"34";56) ⇒ 123456.000 Input [GWTb] = 15 CONCAT([GWTb];" m") ⇒ "15 m"
LEFT	LEFT(Text;[Count=1])	Returns the leftmost characters from a text value	LEFT("qwert";3) ⇒ "qwe" LEFT("qwert";1) ⇒ "q"
RIGHT	RIGHT(Text;[Count=1])	Returns the rightmost characters from a text value	RIGHT("qwert";3) ⇒ "ert" RIGHT("qwert";1) ⇒ "t"
LEN	LEN(Text)	Returns the number of characters in a text string	LEN("qwert") ⇒ 5 LEN("") ⇒ 0
SEARCH	SEARCH(Find text;Within text;[Start=1])	Finds one text value within another (not case-sensitive)	SEARCH("H";"Hello GEO!";1) ⇒ 1 v helpu je Start=1 ale hleda asi od 0!!

Statistical

Name	Syntax, parameters	Description	Example
AVERAGE	AVERAGE(Number1;Number2; ... )	Returns the average of its arguments	Inputs linked to data X[0;1;2;3;4;5;6]): AVERAGE([X⇓3:⇓5]) AVERAGE([X⇓3:⇓5]) ... AVERAGE(⟨2; 3; 4⟩) ⇒ 3
MAX
MIN
PERCENTIL
STDEV
MODUS
MEDIAN

Matrix

Name	Syntax, parameters	Description	Example
LINEARTREND
LINEARTRENDANDPOINTS
LINEARTRENDSC
LINEARTRENDSCANDPOINTS
LINEARTRENDTOPOINTS
SEMICIRCELTOPOINTS