A-14
SPT 1700 Series Product Reference Guide
15. The Map Expense Report Options dialog (magenta section) has five fields where
you can specify the row and column on your template where header information
will be mapped.
Because header data is not related to any particular Section, you have to fill in only
one row. If the item does not display on your template, leave these cells blank.
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 SPT 1700
terminal 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 is easier to see these four groups if you
open the file with a spreadsheet application.
Trips
Shows the number of Expense application categories, and
lists each one followed by an “end” statement.
Currency
Shows how many currencies were used for the Expense
data, and lists the countries that correspond to that
currency.
Trip
Shows the number of expenses by category, and lists the
expenses for each category.
Expenses
Shows the total number of expenses, and lists them
chronologically.