Handspring Treo 270 User Guide

Appendix CPage 231
Determining the layout of the Expense Report
This section describes the layout considerations for the Expense Report and explains the terms 
used for creating the report. 
Labels
There are two kinds of labels that you need to define for your report: day/date and expense type. 
Each kind of label can be either Fixed or Variable. A Fixed label means that the label always 
appears as a header at the beginning of a row or column. If a label is not Fixed, it is variable.
For example, a list...

Page 232  Creating a Custom Expense Report
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...

Appendix CPage 233
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. Define the number of...

Page 234  Creating a 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 or date information, and place an “x” in the 
appropriate cell. When you do this, you also define whether the label is Fixed or Variable. You 
can place only one “x” in the Row section (columns 2–5).
Determine whether the Columns will contain expense or date information, and place an “x” in...

Appendix CPage 235
12. Define whether the Section is in list format. This setting appears in the light purple columns 
(18–19).
If the Section will present the data in a list format, enter the word “yes”. Otherwise, enter the 
word “no”. The following diagram shows data presented in a list format:
Only if your section is in list format: In the Expense Type cell, enter the number of the row or 
column where the expense description will be placed. Expense amounts can be entered in 
several different...

Page 236  Creating a Custom Expense Report
Using applications other than Microsoft Excel
You can use applications other than Microsoft Excel (such as Lotus 1-2-3 or Quattro Pro) to open 
and manipulate the Expense data on your computer. The data file is named “Expense.txt,” and is 
stored in the Expense folder, within the folder containing the communicator user data.
Expense data in the Expense.txt file is in tab-delimited format.
Expense file details
The Expense.txt file contains four groups of data. It...

Appendix DPage 237
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 238  Non-ASCII Characters for Login Scripts 

Appendix EPage 239
Appendix E
Advanced Call Forwarding Options
Some wireless service providers support advanced call forwarding options through the use of 
GSM feature codes. These advanced call forwarding options are turned on and off and configured 
by dialing specific code numbers with your communicator.
Note:  Not all wireless service providers support all of these codes. Contact your wireless service 
provider for more information about which services are available to you.
To use the advanced call...

Page 240  Advanced Call Forwarding Options
Forwarding calls that you do not answer
Forwarding calls when your communicator is unreachable
General Commands
Code What it does
*61*number_to_
forward_to#Forwards all calls you receive and do not answer. This option is similar to 
the way that voicemail typically works.
*#61# Reports whether or not you activated the call forwarding for calls you do 
not answer option.
#61#Deactivates the call forwarding for calls you do not answer option, and the 
network...