A p p e n d i x — C r e a t i n g a c u s t o m E x p e n s e R e p o r t
Determining the layout of the Expense Report
309
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
• expense
Each kind of label can be either be:
• Fixed. The label
always
appears as a header at the beginning of a row or
column, or
• Variable. 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 inthe 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, a sample Expense Report
named Sample3.xlt contains several Sections.
Illustration suggestion (Delete this suggestion when completed):
Sample3.xlt
template
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, you create corresponding additional lines
to the mapping table file named Maptable.xls. This procedure is explained later in this
appendix.
If a section contains cells for prepaid (company paid) expenses, you need to create an
additional line in the mapping table for “prepaid.” This will count as an additional
section in the mapping table. The only data that differs in the prepaid section (from
the non-prepaid section) is the row/column numbers for the expense type.
Analyzing your custom Expense Report
If you already have a custom Excel expense report, you can use it with a modified
mapping table. However, before you can create a Maptable.xls file that corresponds
to your custom Expense Report, you must first analyze the characteristics of your
report.
Содержание s10
Страница 1: ...Manual for Acer s10 handheld ...
Страница 4: ...About this Manual iv ...
Страница 10: ...First things first Assigning security options x ...
Страница 40: ...1 Getting started Entering data 22 ...
Страница 84: ...Working with your basic applications Getting information on an application 66 ...
Страница 98: ...Working with your basic applications Using Date Book 80 Record menu Edit menu Options menu ...
Страница 100: ...Working with your basic applications Using Date Book 82 ...
Страница 116: ...Working with your basic applications Using To Do List 98 ...
Страница 125: ...Working with your basic applications Using Expense 107 ...
Страница 134: ...Working with your basic applications Using Expense 116 Record menu Edit menu Options menu ...
Страница 144: ...5 Working with your supplementary applications Service Launcher 126 ...
Страница 158: ...Working with your supplementary applications Using Clock 140 ...
Страница 166: ...Working with your supplementary applications Using AudioBox 148 ...
Страница 178: ...Working with your supplementary applications Using Recorder 160 ...
Страница 197: ...Working with your supplementary applications Using eBook Reader 179 Bookmark menu Note menu ...
Страница 198: ...Working with your supplementary applications Using eBook Reader 180 ...
Страница 212: ...Working with your supplementary applications Using Service Launcher 194 ...
Страница 234: ...Working with your PC end utilities Using eBook Converter 216 ...
Страница 246: ...8 Using the Attention Manager Subtle alarms 228 ...
Страница 266: ...9 Managing your desktop email Managing your email application with HotSync 248 ...
Страница 286: ...11 Exchanging and updating data using HotSync operations Using File Link 268 ...
Страница 314: ...12 Setting preferences for your Acer s10 ShortCuts preferences 296 ...
Страница 324: ...13 Frequently Asked Questions Technical support 306 ...
Страница 332: ...Appendix Creating a custom Expense Report Expense file details 314 ...
Страница 338: ...320 ...