Handbook
Table Of Contents
- Applications Handbook for the Palm III™ Organizer
- Copyright
- Disclaimer and Limitation of Liability
- 3.5" Software Diskettes Available
- Getting Started With Address Book Entries
- Working With Address Book Entries
- Address Book Menu Commands
- Using the Calculator Screen
- Calculator Menu Commands
- Scheduling an Event
- Rescheduling an Event
- Setting an Alarm for an Event
- Scheduling Repeating Events
- Marking a Private Event
- Deleting an Event
- Changing the Date Book View
- Date Book Menu Commands
- Creating an Expense Item
- Entering Receipt Details
- Show Options
- Transferring Your Data to Microsoft Excel
- Expense Menu Commands
- The HotSync Process and the HotSync Manager
- Performing a HotSync Operation for the First Time
- Conducting a Local HotSync Operation
- Selecting HotSync Setup Options
- Customizing HotSync Application Settings
- Conducting a HotSync Operation via Modem
- Conducting HotSync Operation via a Network
- Creating a User Profile
- Using File Link
- Setting Up Mail on the Desktop
- Synchronizing Mail with your E-Mail Application
- Opening Mail on your Palm III organizer
- Viewing Messages
- Creating Messages
- Looking Up an Address
- Adding Message Details
- Sending Messages
- Editing an Unsent Message
- Draft Messages
- Filing a Message
- Deleting Messages
- Message List Options
- HotSync Options
- Creating Special Filters
- Defining Filter Strings
- High-Priority Messages
- Truncating Messages
- Mail Menu Commands
- Working With Memos
- Arranging Memos
- Marking a Private Memo
- Deleting a Memo
- Memo Pad Menu Commands
- Buttons Preferences
- Digitizer Preferences
- Formats Preferences
- General Preferences
- Modem Preferences
- Network Preferences and Palm TCP/IP Software
- Selecting a Service
- Entering a User Name
- Entering a Password
- Adding Telephone Settings
- Connecting to your Service
- Creating Additional Service Templates
- Adding Detailed Information to a Service Template
- Creating a Login Script
- Deleting a Service Template
- Network Preferences Menu Commands
- TCP/IP Troubleshooting
- Owner Preferences
- ShortCuts Preferences
- Assigning a Password
- Hiding Private Entries
- Showing Private Entries
- Locking Your Palm III Organizer
- Changing or Deleting a Password
- Recovering from a Forgotten Password
- Opening the To Do List
- Working With To Do Items
- To Do Item Details
- Deleting a To Do Item
- To Do Show Options
- To Do List Menu Commands
- About Mapping Tables
- Customizing Existing Sample Templates
- Determining the Layout of the Expense Report
- Analyzing Your Custom Expense Report
- Programming the Mapping Table
- Using Applications Other Than Microsoft Excel
- Expense File Details
- Use of ^char
- Carriage Return and Line Feed
- Literal Characters
- A
- B
- C
- D
- E
- F
- G
- H
- I
- K
- L
- M
- N
- O
- P
- R
- S
- T
- U
- V
- W
Appendix B Page 149
4. Choose Save As from the File menu to open the Save As dialog.
5. Click the Save as type drop-down list and choose Template (*.xlt).
6. Navigate to the Templates folder (in the Palm Desktop directory).
Note: If you do not need to change the Maptable.xls file, save the
template file with its original file name (e.g., Sample2.xlt).
If you do need to change the Maptable.xls file, give your modified
template a unique name. Be sure to use the .xlt file suffix, which
defines the file as a Microsoft Excel template.
7. Click the Save button to save your modified template and make it
available for future use.
Note: If you need to modify the Maptable.xls file, you must do this
before you can use the modified template with your Expense
data. To modify the Maptable.xls file for your new template,
see “Programming the Mapping Table” later in this appendix.
Read all of the sections of this appendix before making changes to the
Maptable.xls file.
Determining the Layout of the Expense Report
This section describes the layout considerations for the Expense
Report and explains the terms used for creating the report.
Labels
There are two kinds of labels that you need to define for your report:
day/date and expense type. Each kind of label can be either Fixed or
Variable. A Fixed label means that the label always appears as a header
at the beginning of a row or column. If a label is not Fixed, it is
variable.
For example, a list table of expenses could have variable labels in the
rows for day/date, and variable labels in the columns for expense
type. In this case, neither day/date–or expense type information
would be “fixed” (as a header). Instead, the date and expense type
information would be filled into the cells of the spreadsheet as
appropriate.
Examples of both Fixed and Variable labels appear in the sample
expense templates.
apps.bk : apps.fm5 Page 149 Thursday, June 4, 1998 12:54 PM