3Com Palmone V Organiser Instructions Manual

Appendix B Page 193
Technical support
If, after reviewing the sources listed at the beginning of this appendix, 
you cannot solve your problem, contact your regional technical 
support office by e-mail, phone, or fax. 
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 experiencing...

Page 194  Frequently Asked Questions 

Appendix C Page 195
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 196  Creating a Custom Expense Report
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 
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...

Appendix C Page 197
change “Snack” to “Munchies,” and then all items 
entered on your organizer as “Snack” map to the cell(s) 
labeled “Munchies.”
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...

Page 198  Creating a Custom Expense Report
Examples of both Fixed and Variable labels appear in the sample 
expense templates. 
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...

Appendix C Page 199
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 200  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 organizer.
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...

Appendix C Page 201
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 202  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...