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-129
Database Functions
Daverage(database, field, criteria) Averages the values in the specified
database column matching the conditions.
Dcount(database, field, criteria) Counts the cells containing numbers in
the specified database column matching the conditions.
Dcounta(database, field, criteria) Counts nonblank cells in the specified
database column matching the conditions.
Dget(database, field, criteria) Extracts a single value from the specified
database column matching the conditions.
Dmax(database, field, criteria) Returns the largest number in the specified
database column matching the conditions.
Dmin(database, field, criteria) Returns the smallest number in the
specified database column matching the conditions.
Dproduct(database, field, criteria) Multiplies the values in the specified
database column matching the conditions.
Dstdev(database, field, criteria) Estimates the standard deviation based
on a sample, using the numbers in the specified database column matching
the conditions.
Dstdevp(database, field, criteria) Calculates the standard deviation of a
population based on the entire population, using the numbers in the
specified database column matching the conditions.
Dsum(database, field, criteria) Adds the numbers in the specified database
column matching the conditions.
Dvar(database, field, criteria) Estimates variance based on a sample, using
the numbers in the specified database column matching the conditions.
Dvarp(database, field, criteria) Calculates the variance of a population
based on the entire population, using the numbers in the specified database
column matching the conditions.
Help
Use the on-line Help [?] located in the upper right-hand corner of the
display for more details about the PTab spreadsheet program.
▲ ▲
▲ ▲
▲ Automating Tasks
The Tasks function allows you to create simple spreadsheet
applications (macros) to automate tasks.