Symbol Technologies SPT 1500 - Manual (Page 242)

B-2
SPT 1500 Product Reference Guide
t City
t Amount
t Attendees
t Payment Method
t Note
When you perform a HotSync ® operation between your SPT 1500 terminal and the Palm
Desktop on your computer, the Expense data is stored on your computer (in a file named
Expense.txt). When you open the Expense application in Palm Desktop, an Excel macro
starts, and populates an expense template with your data based on the rules specified in a
spreadsheet file named Maptable.xls.
The Maptable.xls file is an editable spreadsheet that functions as a “mapping table.” The
function of the mapping table is to guide the Excel macro in extracting the Expense data. The
mapping table tells the Excel macro how large the spreadsheet is and provides the data-cell
layout of the Excel template used for the Expense Report.
Customizing Existing Sample Templates
Four sample Expense Report templates come with Palm Desktop. These templates are stored
in the Templates folder (which is in the same folder as the Palm Desktop application).
If the layout of one (or more) of these templates is appropriate for your reporting needs, you
can easily customize the templates with your company name and other information.
To customize a sample Expense Report template:
1. Make a backup copy of the contents of the Templates folder.
2. Double-click the name of the sample template you want to modify to open it in
Microsoft Excel.