B-4
SPT 1700 Series Product Reference Guide
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 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.
Summary of Contents for SPT 1700
Page 1: ...SPT 1700 Series Product Reference Guide...
Page 3: ...SPT 1700 Series Product Reference Guide 70 37544 02 Revision A April 2000...
Page 14: ...xii SPT 1700 Series Product Reference Guide...
Page 24: ...1 2 SPT 1700 Series Product Reference Guide...
Page 48: ...2 2 SPT 1700 Series Product Reference Guide...
Page 84: ...4 2 SPT 1700 Series Product Reference Guide...
Page 88: ...4 6 SPT 1700 Series Product Reference Guide...
Page 90: ...5 2 SPT 1700 Series Product Reference Guide...
Page 104: ...5 16 SPT 1700 Series Product Reference Guide...
Page 106: ...6 2 SPT 1700 Series Product Reference Guide...
Page 110: ...6 6 SPT 1700 Series Product Reference Guide...
Page 112: ...7 2 SPT 1700 Series Product Reference Guide...
Page 130: ...8 2 SPT 1700 Series Product Reference Guide...
Page 146: ...9 2 SPT 1700 Series Product Reference Guide...
Page 168: ...9 24 SPT 1700 Series Product Reference Guide...
Page 198: ...11 2 SPT 1700 Series Product Reference Guide...
Page 234: ...13 2 SPT 1700 Series Product Reference Guide...
Page 240: ...13 8 SPT 1700 Series Product Reference Guide...
Page 242: ...14 2 SPT 1700 Series Product Reference Guide...
Page 252: ...15 2 SPT 1700 Series Product Reference Guide...
Page 260: ...16 2 SPT 1700 Series Product Reference Guide...
Page 266: ...16 8 SPT 1700 Series Product Reference Guide...
Page 268: ...17 2 SPT 1700 Series Product Reference Guide...
Page 282: ...17 16 SPT 1700 Series Product Reference Guide...
Page 284: ...18 2 SPT 1700 Series Product Reference Guide...
Page 290: ...A 2 SPT 1700 Series Product Reference Guide Sample 1...
Page 291: ...A 3 Expense Templates Sample 2...
Page 292: ...A 4 SPT 1700 Series Product Reference Guide Sample 3...
Page 293: ...A 5 Expense Templates Sample 4...
Page 294: ...A 6 SPT 1700 Series Product Reference Guide...
Page 306: ...B 12 SPT 1700 Series Product Reference Guide...