User Manual
Table Of Contents
- Allegro CE™ Owner's Manual
- Table of Contents
- Chapter 1 Introduction
- Chapter 2 Hardware Components
- Chapter 3 Memory Configuration and Data Storage Options
- Chapter 4 Windows CE Operating System
- Chapter 5 Technical Reference
- Chapter 6 Software Developer’s Guide for Allegro CE 3.0 and CE .NET
- Chapter 7 FCC Information, Warranty, and Software License Agreement
- Chapter 8 Expansion Pods
- Index
- Table of Contents
- Chapter 1 Introduction
- Chapter 2 Hardware Components
- Case Design
- Keyboard
- Display
- System Tray Indicators
- Batteries
- Main Power Source
- Setting Battery Charge
- Battery Life
- Recharging the NiMH Battery Pack
- Battery Gauging Explained
- Battery Status Icons
- When the Battery Voltage Drops
- Power Management Feature
- Changing NiMH Battery Pack
- Alkaline Battery Holder: Inserting Batteries and Usage Information
- Storing the Allegro CE During Inactive Periods
- NiMH Battery Pack's Useful Life
- Spare NiMH Battery Packs
- Short-Term Backup Supply
- Real Time Clock
- Main Power Source
- Communication Ports
- USB/Power Dock
- PC Cards
- Expansion Pods
- Chapter 3 Memory Configuration and Data Storage Options
- Chapter 4 Windows CE Operating System
- Windows CE Overview
- CE .NET Viewers
- ActiveSync Transfer
- Downloading ActiveSync from the Internet
- Installing ActiveSync
- Establishing a First Time ActiveSync Connection
- Establishing Additional ActiveSync Connections
- New Partnership Set Up
- USB MultiSync
- USB MultiSync Connections
- Transferring Files Between the Allegro CE and the Desktop PC
- Windows Explorer
- Storing Files and Programs
- System Save/Restore Utilities
- Application Command Bars
- PTab Spreadsheet Program
- Pocket Word/WordPad
- Internet Explorer and Inbox
- Calculator Program
- Terminal Program
- Chapter 5 Technical Reference
- Chapter 6 Software Developer’s Guide for Allegro CE 3.0 and CE .NET
- Chapter 7 FCC Information, Warranty, and Software License Agreement
- Chapter 8 Expansion Pods
- Index

Windows CE Page 4-123
Sign(number) Returns 1 if the number is positive, 0 if the number is 0, and
-1 if the number is negative.
Example: Sign(-5) equals -1.
Sin(number) Returns the sine of the given angle.
Example: Sin(Pi()/2) equals 1.
Sinh(number) Returns the hyperbolic sine of the number.
Example: Sinh(3) equals 10.01787.
Sqrt(number) Returns the square root.
Example: Sqrt(4) equals 2.
Sum(number, number, ...) Return the sum of all the numbers in the list of
arguments.
Example: Sum(10, 20) equals 30.
SumIf(range, criteria, sumRange) It sums up the values of only those cells
from the sumRange for which the corresponding cells in the range satisfy the
criteria.
Example: Sumif(A1:A5,”>100000",B1:B5).
Tan(number) Returns the tangent of the given angle.
Example: Tan(5) equals -3.38051.
Tanh(number) Returns the hyperbolic tangent of the number.
Example: Tanh(1) equals 0.76159.
Trunc(number, numDigits) Truncates the number to an integer. The
argument numDigits is the precision of the truncation. The default value for
the numDigits is 0.
Example: Trunc(-7.8) equals -7.
Statistical Functions
Average(number, number, ...) Returns the average of the arguments.
Example: Average(1, 2, 3) equals 2.
Count(number, number, ...) Counts how many numbers are in the list of
arguments.
Example: B1 contains 5, B2 contains 3, Count(B1:B2) equals 2.
CountA(number, number, ...) Counts the number of nonblank values in the
list of arguments.
Example: A1 contains 2, A2 is blank, CountA(A1:A2) equals 1.
CountBlank(range) Counts empty cells in the specified range of cells.
CountIf(range, criteria) Counts the number of cells within the range
that meets the given criteria.
Example: A1 contains 6, A2 contains3, CountIf(A1:A2,”>5") equals 1.