Handspring Visor Handheld Platinum User Guide

Appendix B Page 241
Technical support
If you cannot solve your problem after reviewing the sources 
listed at the beginning of this appendix, check our web site 
www.handspring.com for the latest technical support information.
Before requesting support, please experiment a bit to reproduce and 
isolate the problem. When you do contact support, please be ready to 
provide the following information:
nThe name and version of the operating system you are using
nThe actual error message or state you are...

Page 242  Troubleshooting Tips 

Appendix C Page 243
Appendix C
Creating a Custom 
Expense Report
This section explains how to modify existing Expense application 
templates and how to create your own custom expense report 
templates for use with the Expense application.
Note:This section assumes that you are familiar with Microsoft 
Excel or a similar spreadsheet application. If you are not 
familiar with Microsoft Excel, consult your company’s 
Information Services department or another experienced user.
About mapping tables
Before...

Page 244  Creating a Custom Expense Report
Customizing existing sample templates
Four sample Expense Report templates come with Palm Desktop 
software. These templates are stored in the Template folder (which is 
in the same folder as the Palm Desktop software 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...

Appendix C Page 245
4. From the File menu, choose Save As.
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...

Page 246  Creating a Custom Expense Report
Sections
A Section is an area of the report that has common formatting. It is 
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...

Appendix C Page 247
Analyzing your custom Expense Report
If you already have a custom Excel expense report, you can use it with 
a modified mapping table. However, before you can create a 
Maptable.xls file that corresponds to your custom Expense Report, 
you must first analyze the characteristics of your report. 
Perform the following before you begin a custom mapping table:
nPrint a copy of your custom expense report. Activate the Row and 
Column Headings option in the Sheet settings of the Page Setup...

Page 248  Creating a Custom Expense Report
Programming the mapping table
Once you have analyzed the components of your custom Expense 
Report, you can program the mapping table to fill the report with data 
from the handheld.
To program a new custom mapping table:
1. Open a copy of the Maptable.xls file in Microsoft Excel. 
Note:This file is located in the same folder as the Palm Desktop 
software application. Make a backup copy of this file before 
you make your modifications.
2.
Mapping a new template....

Appendix C Page 249
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.
Define the number of Sections. Each row in a table defines...

Page 250  Creating a Custom Expense Report
10.Define the dimensions of the Section. The dimensions of the Section 
appear in the green columns (10–13).
11.
Define the Dates and Intervals. The dates and intervals between 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...