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. Scroll to where you find the name of the original template that you chose for your modifications. The name of the template will appear in column B of the Maptable.xls file, next to the cell highlighted in green that reads “Template Name:”. If you did not modify an existing template, move to any table in the Maptable.xls file.

3.Select all the rows associated with the template name. To select the rows, click and drag on the row numbers (left side), so they appear highlighted.

All rows related to template are selected

4. From the Edit menu, choose Copy.

Page 240

Creating a Custom Expense Report

Page 248
Image 248
Handspring Visor manual Programming the mapping table