Palm M500 Handheld Instructions Manual

Appendix C Page 251
5. Click the Save as type drop-down list and choose Template (*.xlt).
6. Navigate to the Template folder (in the Palm Desktop software 
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 Save to save your...

Page 252  Creating a Custom Expense Report
common for an Expense report to have more than one Section. For 
example, the following sample Expense Report named Sample3.xlt 
contains several Sections.
Because your Expense data maps to row and column areas of your 
final report, different Sections require different definitions for the data 
mapping. To create additional Sections with different mapping, you 
create corresponding additional lines to the mapping table file named 
Maptable.xls. This procedure...

Appendix C Page 253
Column Headings option in the Sheet settings of the Page Setup 
command. This enables you to quickly determine the size of the 
Section(s), as well as the numbers for the start rows and columns.
nOn the printed copy, identify the data Sections. A Section is an area 
of data with common row and column formatting. A yellow 
highlighter marking pen can make it easy to see the Sections as you 
work with programming the mapping table. Your custom Expense 
Report can contain any number of...

Page 254  Creating a Custom Expense Report
4. From the Edit menu, choose Copy.
5. Scroll down to a blank area of the Maptable.xls file (below the rows 
used for Sample4.xlt), and click on a row number to select a blank 
row.
6. From the Edit menu, choose Paste. A copy of the rows you selected 
in step 3 is pasted into the Maptable.xls file.
7.
Name the table. In the cell immediately to the right of the cell 
entitled Template Name, enter the exact file name of your custom 
Expense Report template. 
8....

Appendix C Page 255
You may add or delete rows as necessary so that the total number 
of rows corresponds to the number of Sections in your custom 
Expense Report. To clear all of the existing settings in a row, click 
to select the row and press Ctrl+Delete. Name each row to 
correspond to a Section of your custom Expense Report.
9.
Determine the Label settings. The orientation of the data fields 
(Row, Column) appears in the yellow section of the table.
Determine whether the Rows will contain expense...

Page 256  Creating a Custom Expense Report
dates appears in the light blue columns (14–17).
In the Date cell, enter the row or column number where all the date 
information will be placed.
In the Dates cell, enter the number of blank columns (or rows) 
separating the date fields. If there are no blank columns (or rows) 
between date entries, leave this number set to zero.
In the Start Day cell, enter the day of the week that starts the 
expense reporting period. Enter a three-character abbreviation for...

Appendix C Page 257
snacks. In the previous example, all expense items would be 
populated into row/column 4 of the custom Expense Report.
14.
Complete the table. All of the remaining columns (49–57) in the 
table are used to define the column or row number that 
corresponds to the description. 
15.
Mark a Section for prepaid expenses (yellow column). If a row in the 
map table is for prepaid (company paid) expenses, type a “yes” in 
the cell on that Section’s row. Type “no” in all the cells of this...

Page 258  Creating a Custom Expense Report
Expense file details
The Expense.txt file contains four groups of data. It will be easier to see 
these four distinct groups of data if you open the file with a 
spreadsheet application.
TripsShows the number of Expense application 
categories, and lists each one followed by an 
“end” statement.
CurrencyShows how many currencies were used for the 
Expense data, and lists the countries that 
correspond to that currency.
TripShows the number of expenses by...

Appendix D Page 259
Appendix D
Non-ASCII Characters 
for Login Scripts
The following information enables you to create custom login scripts 
that require non-ASCII characters. It is provided for advanced users 
who understand the use and requirements of such characters in a 
custom login script.
Use of ^char
You may use the caret ( ^ ) to transmit ASCII command characters. If 
you send ^char, and the ASCII value of char is between @ and _, then 
the character is automatically translated to a single-byte...

Page 260  Non-ASCII Characters for Login Scripts
Examples:
n\^Includes a caret as part of the string
n\