Creating formulas

Add operand (e.g. attribute) button: Open a window with the attributes of the network object type selected in the Object type box and select an attribute as term. The term is added in blue.

Add operator (e.g. +, -, *, /): Select an operator that combines the term with another term. The operator is added in black.

Insert function (e.g. min, max, exp): Open Insert function and select a function for teh formula. The function is added in turquoise.

Possible functions:

Floor (x)

Specifies the greatest integer that is smaller than or equal to x. At the cursor position FLOOR() is inserted.

Abs (x)

Absolute value of x

Truncate (x)

Truncates the decimal places of x. At the cursor position TRUNCATE() is inserted.

ArcSin (x)

ArcCos (x)

ArcTan (x)

Ceil (x)

Specifies the smallest integer that is greater than or equal to x. At the cursor position CEIL() is inserted.

Cosine (x)

Exp (x)

Forms the exponential of x. At the cursor position, EXP() is inserted.

Div (x; y)

GEH Statistic (x; y)

Calculates the GEH statistics for x and y. At the cursor position, GEH(;) is inserted. The GEH Statistic is a empirical formula widely used in traffic modeling for the analysis of values. The formula is as follows:

where:

M: modeled values

C: counted values

Reciprocal (x)

Corresponds to 1/x. At the cursor position RECIPROCAL() is inserted.

Log (x)

Forms the natural logarithm of x. At the cursor position, LN() is inserted.

Max (x; y)

Forms the maximum of x and y

Min (x; y)

Forms the minimum of x and y

Mod (x; y)

Power (x; y)

Corresponds to x^y. At the cursor position, POW(;) is inserted.

Percent (x; y)

Corresponds to 100*x/y. At the cursor position PERCENT() is inserted.

Round (x; p)

Rounds x to p decimal places. p is optional. At the cursor position ROUND(;) is inserted.

Sin (x)

Text to number ("x")

Converts a string into a floating-point number. Enter a period as the decimal separator. The following characters are not valid in the string: spaces at the beginning and end and non-numeric characters, except +, -, e/E. At the cursor position STRTONUM() is inserted.

Tan (x)

If (b; w; f)

Conditional branching. Outputs w if b is true. Outputs f if b is false. At the cursor position IF(;;) is inserted.

Root (x)

Forms the square root of x. At the cursor position, SQRT() is inserted.

Number to text (x)

Converts a floating-point number into a string. At the cursor position NUMTOSTR() is inserted.

Insert TableLookup:Open the Insert TableLookup window to insert a function of the type TableLookup into the formula. Select an attribute value of a network object type and continue to edit it in the formula. The TableLookup function is added in turquoise.

• Network object type: In the list, click the object type you want to use as the basis of the function. All conditions of the function that follow refer to the object type selected.

In addition to the network object types, you can select other object types, for instance Network settings (NETPARA) that contains a user-defined value. To select another object type, as condition of the TableLookup command, e.g. use the value 1 for TRUE.

• Variable name: Enter a variable name that starts with a letter. This name is a so-called loop variable. In each loop, it represents another network object of the type iterated over.
• Insert explaining comments: Inserts an example of a condition and result into the input field that you can overwrite.

The TableLookup function entry box must correspond to the following scheme:

TableLookup(<object type> <variable name>;(<condition>);(<result>)

The elements consist of:

TableLookup(<object type: English Name in capital letters> <entered variable name>; (<condition, for example <entered variable name>[<English attribute short name>]=<property>>);(<result, for example <identifier>[<attribute short name>]>))

See (Example of a user-defined attribute)

Insert brackets: Insert opening and closing brackets:

• Insert around selected part of formula
• None of the formula is selected: Insert at the position of the cursor