Filter
Top Products
A-8
SPT 1700 Series Product Reference Guide
displays as a header at the beginning of a row or column. A variable label means the
location of the header can vary.
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 display in the sample expense templates,
which were discussed previously in this appendix.
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
(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, create corresponding additional lines to the mapping table file,
Maptable.xls. Refer to
Programming the Mapping Table
on page A-9 for details.
Section 1
(not prepaid)
Section 2
(prepaid)
Section 3