9 numerical limitations, 10 mathematical functions, details, and examples, 9 numerical – Campbell Scientific PC400 Datalogger Support Software User Manual
Page 71: Limitations -23, 6. split operators and math functions -23

Section 5. Split
variable X). A comma must follow each variable statement, as with all
parameters in the Select line. Once the variables have been declared they can
be used later in the Select line (i.e., x=4-5
∗(6∗3.0), y=6/3,2,3,6,7,7∗x,6+y).
Variables can be defined in the first four Input File’s Select
lines only, but may be used in subsequent Input File’s Select
lines.
NOTE
Illegal operations (e.g., logarithm of a negative number) will cause Split to
store blanks for the Output. It is possible to get a run time error (error 0/1) if
the floating point math exceeds the limits of the PC.
5.3.1.9
5
Numerical Limitations
The greatest number that can be output is determined by the field width (Output
File tab). If the width is eleven or greater, the maximum number is 99,999,999;
for widths from eight through ten the maximum is 99,999; for widths less than
eight the maximum is 9999. If a column is not large enough for a value, it will
be stored as a 9,999, 99,999 or 99,999,999 based on the column width. In some
instances, such as when a column is not large enough for the date function, you
will see the text “bad data” on the Split Runtime window.
.3.1.10 Mathematical Functions, Details, and Examples
TABLE 5-6. Split Operators and Math Functions
OPERATORS
OPERATOR
PRECEDENCE
ORDER
(3 = high, 1 = low)
^
= raise to the power
3
x Mod y = Modulo divide of x by y
2
∗ /
= multiplication, division
2
+ -
= addition, subtraction
1
EXAMPLES OF SYNTAX FOR MATHEMATICAL OPERATORS
3
∗5
multiply element 3 by element 5
3/5
divide element 3 by element 5
(3..5)/(8..10)
same as 3/8, 4/9, 5/10
3+5
add element 3 to element 5
3-5
subtract element 5 from element 3
(3,9,5)-(8,7,10)
same as 3-8, 9-7, 5-10
3
∗2.0
multiply element 3 by a fixed number 2
2^3.0
raise element 2 to the third power
MATH
FUNCTIONS
Abs(x)
= Absolute value of x
Arctan(x)
= Arc tangent of x (in degrees)
Cos(x)
= Cosine of x (in degrees)
Exp(x)
= Natural Exponent function (e
x
)
Frac(x)
= Fractional portion of x
Int(x)
= Integer portion of x
Ln(x)
= Natural logarithm of x
Sin(x)
= Sine of x (in degrees)
SpaAvg(x..y)
= Spatial average of elements x through y
SpaMax(x..y)
= Spatial maximum of elements x through y
SpaMin(x..y)
= Spatial minimum of elements x through y
SpaSd(x..y)
= Spatial standard deviation of elements x through y
Sqrt(x)
= Square root of x
5-23