Functions

Choose a Calculate function from the drop down list. The chosen function will operate on the inputs you have specified in the same row of the table.

In addition to the common maths functions, functions applicable to the management of earth science data are also provided. In particular, functions have been designed which allow you to make global changes to the data in a file.

Unless stated otherwise in the tables below, Input 1 must be a numeric or a binary field.

Function	Description
Absolute value	Returns the absolute value of Input 1. Input 2 is disabled.
Accumulate	While Input 1 is constant, the contents of Input 2 are summed and placed in the Result. (Input 1 can be either a character or numeric field or a numeric value. Use a numeric value to sum the contents of a field. Input 2 must be a numeric or a binary field.)
Antilog base 10	Takes the antilog to the base 10 of the value in Input 1. Input 2 is disabled.
Antilog base e	Finds the natural antilog of the value in Input 1. Input 2 is disabled.
At change	Input 1 is a field. When the value of this field changes in the next record, then the value you enter in Input 2 is placed in the Result field of the next record. (Input 1 must be a field, either character or numeric or binary, and Input 2 a constant.). At change
At change increment	Input 1 is a field. When the value of this field changes in the next record, then the value you enter in Input 2 is placed in the Result field of the next record and is incremented by 1. (Input 1 must be a field, either character or numeric or binary, and Input 2 a constant.)
At last	Input 1 is a field. When the value of this field changes in the nextrecord, then the value you enter in Input 2 is placed in the Result field. (Input 1 must be a field, either character or numeric or binary, and Input 2 a constant.). At Last
Average	Averages the values of Input 1 and Input 2. (Input 1 must be a field and Input 2 either a field or a constant.)
Carry	While the contents of Input 1 remain constant, the value of Input 2 is carried into the result variable from the record above. This is similar to the Accumulate function but does not sum the values. (Input 1 must be a field, either character or numeric or binary, and Input 2 must be a field, normally numeric or binary.)
Cut highs to	If value of Input 1 is higher than values (not a field) specified in Input 2, the value in Input 2 is written to the Result field. If Input 1 is lower than the value in Input 2 then Input 1 is written to the result field. (Input 1 must be a field and Input 2 a constant.)
Div	Returns the integer of Input 1/Input 2. Inputs can be fields or constants.
Divide by	Divides Input 1 by Input 2. Inputs can be fields or constants.
Greater of	Finds greater of Input 1 and Input 2. (Input 1 must be a field and Input 2 can be a field or constant.)
Lesser of	Finds lesser of Input 1 and Input 2. (Input 1 must be a field and Input 2 can be a field or constant)
Log base 10	Takes the log to the base 10 of the value in Input 1. Input 2 is disabled.
Log base e	Takes the natural log of the value in Input 1. Input 2 is disabled.
Minus	Subtracts Input 2 from Input 1. Inputs can be fields or constants.
Mod	Returns the floating-point remainder of Input 1/Input 2. Inputs can be fields or constants.
Multiply by	Multiplies Input 1 by Input 2. Inputs can be fields or constants.
Plus	Adds Input 1 to Input 2. Inputs can be fields or constants.
Raise to power	Raises the values of the data in Input 1 to the power entered in Input 2.
Random	Inputs 1 and 2 are fields or constants and must contain numeric values. A random number is calculated between the range of the two input values and placed in the Result field.
Round (decimals)	Rounds the value in the Input 1 to the number of decimal places specified in the Input 2. If Input2 is zero, the number is rounded to the nearest integer. If Input2 is a negative number, the number is rounded to the left of the decimal point.
Round (significant)	Rounds the value in the Input 1 to the number of significant figures specified in the Input 2.
Square	Squares the value in Input 1. Input 2 is disabled.
Square root	Calculates the square root of the contents of Input 1. Input 2 is disabled.

Angle functions

The Angle units selected in the Field Calculate form is applied when one or more Angle functions are selected:

Function	Description
Add angle	Adds the value specified in Input 2 to the value in Input 1, using the selected Angle units. Results are automatically limited to the range of 0 - 360°.
Arccosine	Finds the ARCCOS of Input 1. Input 2 is disabled.
Arcsine	Finds the ARCSIN of Input 1. Input 2 is disabled.
Arctangent	Finds the ARCTAN of Input 1. Input 2 is disabled.
Arctangent 2	Computes the inverse tangent of Input 1 over Input 2 using the signs of the inputs to correctly determine the quadrant. (Input 1 and Input 2 may be any combination of numeric fields or binary fields or constants.)
Cosine	Finds the COS of Input 1. Input 2 is disabled.
D.DDD -> DMS	Converts Input 1 from decimal degrees to the selected Angle units. Input 2 is disabled.
Delta east	Assumes Input 1 is a bearing and Input 2 is a distance, calculates the X offset of a point at the given bearing and distance.
Delta north	Assumes Input 1 is a bearing and Input 2 is a distance, calculates the Y offset of a point at the given bearing and distance.
DMS -> D.DDD	Converts Input 1 (using the selected Angle units) to decimal degrees. Input 2 is disabled.
Missing line	Input 1 is an X value and Input 2 is a Y value. The bearing from a point with coordinates of 0,0 to the point X, Y is calculated and placed in the Result field.
Sine	Finds the sin of Input 1. Input 2 is disabled.
Subtract angle	Subtracts the value specified in Input 2 from the value in Input 1. Results are automatically limited to the range of 0 - 360°.
Tangent	Finds the tan of Input 1. Input 2 is disabled.

Date functions

The Date format selected in the Field Calculate form is applied when one or more Date functions are selected:

Function	Description
Date -> Numeric	Converts input 1 to a numeric value (which is the number of days since Jan 1st 1900) and puts the converted value in the Result field. Input 1 must have a format which matches the default date format. Input 2 is disabled.
Numeric -> Date	Converts input 1 to a date, in the default date format, and puts the converted value in the Result field. Input 1 must be a numeric value (which is the number of days since Jan 1st 1900). Input 2 is disabled.