Appendix — Creating a custom Expense Report

Using applications other than Microsoft Excel

313
expense report. Use this section to specify the row and column on your template
where this 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 appear 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 Acer s10 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.
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.