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 table of expenses could have variable labels in the rows for day/date, and 
variable labels in the columns for expense type. In this case, neither day/date or expense type 
information would be “fixed” (as a header). Instead, the date and expense type information would 
be filled into the cells of the spreadsheet as appropriate.
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 mapping. To create additional Sections with different 
mapping, you create corresponding additional lines to the mapping table file named Maptable.xls. 
This procedure is explained later in this appendix.
If a section contains cells for prepaid (company paid) expenses, you need to create an additional 
line in the mapping table for “prepaid.” This will count as an additional section in the mapping table. 
The only data that differs in the prepaid section (from the non-prepaid section) is the row/column 
numbers for the expense type.
Section 1 
(not prepaid)
Section 2 
(prepaid)
Section 3  
						

							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 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 Sections, and the same data can be repeated in any Section.
nOn the printed copy, identify the type of Labels that apply to each Section. Each Section can 
have only one kind of Fixed or Variable Label for rows. Likewise, each Section can have only 
one kind of Fixed or Variable Label for columns.
nPlace a copy of your custom Expense Report in the Template folder (in the Palm Desktop 
software directory). Change the file name so it has the file extension .xlt (which defines it as 
a Microsoft Excel template). Make a note of the exact file name so it can be defined in the 
mapping table file.
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 communicator.
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. 
						

							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 Sections. Each row in a table defines how your communicator data will 
be placed in a Section of your custom Expense Report. Note that the prepaid portion of a 
section has its own row and counts as a separate section for map table purposes, even 
though it is not a separate section in your template.
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.
All rows related 
to template are 
selected 
Table with 
four sections 
						

							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 
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 Column section (columns 6–9).
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 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 the day (e.g., Sun, Mon, Tue).
In the Day cell, enter the row or column number where all the day information will be placed. 
If the dates are in a row or in a column, enter the row or column number. # of 
RowsRepresents the total number of rows in the Section, excluding any header or 
total rows. In other words, this includes only the number of rows in the Section 
where your communicator data will be placed.
# of 
ColumnsRepresents the total number of columns in the Section, excluding any header 
or total columns. In other words, this includes only the number of columns in 
the Section where your communicator data will be placed.
Start RowIs the number of the first row of the Section that will be filled with your 
communicator data.
Start 
ColumnIs the number of the first column of the Section that will be filled with your 
communicator data. 
						

							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 columns or rows if required by your template. Expense type labels must all 
appear in the same column.
13. Enter the row or column numbers for the expense types that appear in the Section. These 
settings appear in the aqua columns (20–48).
For these settings, simply enter the row or column number for the expense types that you 
want to appear in the Section. Note that the same row or column number can be used more 
than once. An example of this would be meals that encompass breakfast, lunch, dinner, and 
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 column that do not pertain to prepaid expenses.
16. Repeat steps 9 through 15 for each Section you defined for your custom Expense Report. 
17. Map Expense Report Options dialog (magenta section). The Expense Report Options dialog 
has five fields where you can fill in data for the header on your expense report. Use this 
section to specify the row and column on your template where this information is mapped. 
Because header data is not related to any particular Section, you have to fill in only one row. 
If the item does not appear on your template, leave these cells blank. 
						

							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 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 category, and lists the expenses for 
each category.
ExpensesShows the total number of expenses, and lists them chronologically. 
						

							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 value between 0 and 31. 
For example, ^M is converted to a carriage return. If char is a value between a and z, then the 
character sequence is translated to a single-byte value between 1 and 26. If char is any other 
value, then the character sequence is not subject to any special processing.
For example, the string “Joe^M” transmits Joe, followed by a carriage return.
Carriage return and line feed
You may include carriage return and line feed commands as part of the login script, when entered 
in the following format:
 Sends or receives a carriage return
 Sends or receives a line feed
For example, the string “waitfor Joe” waits to receive Joe followed by a carriage return 
and line feed from the remote computer before executing the next command in the script.
Literal characters
The backslash (  ) character defines that the next character is transmitted as a literal character, 
and is not subject to any special processing ordinarily associated with that character. 
Examples:
\^ Includes a caret as part of the string
\< Includes a < as part of the string
\\ Includes a backslash as part of the string 
						

							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 forwarding options:
1. Press PhoneBook   to access the Dial Pad view  .
2. Enter one of the codes from the charts that follow.
Note:  Where the charts indicates to enter a number_to_forward_to, enter a full phone 
number with a “1” and an area code if necessary. For example, you would use 
*67*16505551234# for the first code in the first chart.
3.
Press Return  to send the command.
Forwarding calls when your communicator is busy
Code What it does
*67*number_to_
forward_to#Forwards all calls you receive while you are busy on another call to the 
number you entered. This option typically forwards calls when you ignore a 
call, when you are on a wireless data call, or when you already have two 
active calls. You can still answer call waiting calls.
*#67#Reports whether you activated the call forwarding when busy option.
#67#Deactivates call forwarding when busy, and the network stores the number 
to which you were forwarding calls.
*67#Reactivates the call forwarding when busy option, and uses the number 
stored on the network when you deactivated this option with the #67# 
code.
##67#Deactivates call forwarding when busy, and the network erases the 
number to which you were forwarding calls. 
						

							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 stores the number to which you were forwarding calls.
*61#Reactivates the call forwarding for calls you do not answer option, and uses 
the number stored on the network when you deactivated this option with 
the #61# code.
##61#Deactivates the call forwarding for calls you do not answer option, and the 
network erases the number to which you were forwarding calls.
Code What it does
*62*number_to_
forward_to#Forwards all calls you receive when your communicator is unreachable. 
This option typically forwards calls when wireless mode is off or your 
communicator is outside a coverage area.
*#62#Reports whether you activated the call forwarding for calls when your 
communicator is unreachable option.
#62#Deactivates the call forwarding for calls when your communicator is 
unreachable option, and the network stores the number to which you were 
forwarding calls.
*62#Reactivates the call forwarding for calls when your communicator is 
unreachable option, and uses the number stored on the network when you 
deactivated this option with the #62# code.
##62#Deactivates the call forwarding for calls when your communicator is 
unreachable option, and the network erases the number to which you were 
forwarding calls.
Code What it does
#002#Deactivates all advanced call forwarding options, and the network stores 
the numbers to which you were forwarding calls.
##002#Deactivates all advanced call forwarding options, and the network erases 
the numbers to which you were forwarding calls.