About    Download    Order    Support

Recent News

InnPlanner 2010 Released New faster database engine, more customization features, weekly tariffs, full multi-user work support and much more... 2010 Feb 10

InnPlanner 2010 RC1 InnPlanner 2010 Release Candidate 1 is ready for downloading and testing. You can download it from the "Downloads" section. 2010 Jan 14

Hotel Software Documentation

Math/Logic Functions

Math/Logic Functions

V (|VariableName|)

Returns the value of a variable with name VariableName. You can also simply type [$VariableName] into formula to get the value of the variable. See the variables section to learn more about variables.

Abs (Value)

Returns the absolute value of a Value.

Examples:

Abs(-9), returns 9;

Abs(3), returns 3.

Cos (Angle)

Returns the value specifying the cosine of an angle.

Examples:

Cos(90), returns 0;

Cos(60), returns 0.5.

Exp (Value)

Returns e (exponent) raised to the power of Value.

Examples:

Exp(1), returns 2.7182.

Exp(0), returns 1;

If (valueA, |opearation|, valueB)

Returns 1 if valueA operation valueB is true;

Returns 0 if valueA operation valueB is false.

List of operations: equal, more, less, more or equal, less or equal.

Examples:

If(5, |more|, 3), returns 1, because 5 is more than 3;

If(2, |equal|, 7), returns 0, because 2 is not equal to 7.

If you need advanced logical structures, please use scripts.

Int (Value)

Returns the integer portion of a number.

Examples:

Int(1.76), returns 1

Int(-6.32), returns -7

Log (Value)

Returns the value specifying the natural logarithm of a Value.

Examples:

Log(1), returns 0

Log(2.7182), returns 1

Pow (Base, Exp)

Returns Base raised to the power of Exp.

Examples:

Pow(1, 12), returns 1

Pow(2, 3), returns 8

Round (Value, Precision)

Returns the rounded Value to specified Precision (number of digits after the decimal point).

Examples:

Round(1.234), returns 1

Round(2.23835324, 2), returns 2.24

Round(-2.234, 2), returns -2.23

Sgn (Value)

Returns the number indicating the sign of a Value:
-1 if less than zero;
 0 if equal to zero;
 1 if more than zero.

Examples:

Sgn(-12), returns -1

Sgn(0), returns 0

Sgn(3.4), returns 1

Sin (Angle)

Returns the value specifying the sine of an angle.

Examples:

Sin(90), returns 1;

Sin(0), returns 0.

Sqr (Value)

Returns the square root of a number [A1].

Examples:

Sqr(9), returns 3;

Sqr(1), returns 1.

Today"s Poll

What software do use for your inn/b&b/hotel/etc?

Home Page | Contacs | Terms and Conditions

Copyright (C) 2001-2010 Binary Brilliant Inc