Handbook

page 174 PalmPilot Handbook
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, or expense type. Each kind of label can either be
a Fixed or Variable label. 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 sample Expense Report named SAMPLE3.XLT
contains several Sections, as highlighted in the following diagram:
Section 1
(not prepaid)
Section 3
Section 2
(prepaid)
Because your Expense data is mapped to row and column areas of
your final report, different Sections require different definitions for
the data mapping. To create additional Sections with different