Juniper Systems Allegro DOS Manual - Manual (Page 133)

Windows CE Page 4-67
- Select (or confirm you have selected) Conversion from Excel(*.xls)
to PTab(*.pt) in the Desktop-Device tab. Select "Microsoft Excel
Worksheet in the list box, press the Edit button, and select "PTab
filter (*.pt)" in the combo box.
- Select Conversion from PTab(*.pt) to Excel(*.xls) in the Device-
Desktop tab. Select "PTab file" in the list box, press the Edit button,
and select "PTab filter (*.xls)" in the combo box.
2) Convert your files: Conversion is done by dragging the files from/to
the desktop computer to/from the document folder on the Allegro.
▲ ▲ ▲ ▲ ▲ Spreadsheet Functions
The following sections are the available spreadsheet functions available
in PTab.
Math & Trig Functions
Abs(number) Returns the absolute value of a number. Example: Abs
(-3) equals 3.
Acos(number) Returns the arccosine of a number. The number must be
from -1 to 1.
Example: Acos(-0.5) equals 2.094395.
Acosh(number) Returns the inverse hyperbolic cosine of a number. The
number must be greater or equal to 1.
Example: Acosh(1) equals 0.04613.
Asin(number) Returns the arcsine of a number. The number must be from
-1 to 1.
Example: Asin(-0.5) equals -0.5236.
Asinh(number) Returns the inverse hyperbolic sine of a number.
Example: Asinh(8) equals 2.77647.
Atan(number) Returns the arctangent of a number.
Example: Atan(0.5) equals 0.46365.
Atan2(x,y) Returns the arctangent of the specified x and y coordinates.
Example: Atan2(1, 1) equals 0.785398.
Atanh(number) Returns the inverse hyperbolic tangent of a number. The
number must be between -1 and 1 (excluding -1 and 1).
Example: Atanh(-0.1) equals -0.10034.
Ceiling(number, significance) Returns the number rounded up to the
nearest multiple of the significance.
Example: Ceiling(10.43, 0.1) equals 10.5.