Palm 3C80401U Handbook - Page 221

correspond to a of your custom Expense Report.

Page 221 highlights

5. Scroll down to a blank area of the Maptable.xls file (below the rows used for Sample4.xlt), and click on a row number to select a blank row. 6. From the Edit menu, choose Paste. A copy of the rows you selected in step 3 is pasted into the Maptable.xls file. 7. Name the table. In the cell immediately to the right of the cell entitled Template Name, enter the exact file name of your custom Expense Report template. 8. Define the number of Sections. Each row in a table defines how your organizer data will be placed in a Section of your custom Expense Report. Note that the prepaid portion of a section has its own row and counts as a separate section for map table purposes, even though it is not a separate section in your template. Table with four sections You may add or delete rows as necessary so that the total number of rows corresponds to the number of Sections in your custom Expense Report. To clear all of the existing settings in a row, click to select the row and press Ctrl+Delete. Name each row to correspond to a Section of your custom Expense Report. 9. Determine the Label settings. The orientation of the data fields (Row, Column) appears in the yellow section of the table. Determine whether the Rows will contain expense or date information, and place an "x" in the appropriate cell. When you do this, you also define whether the label is Fixed or Variable. You can place only one "x" in the Row section (columns 2-5). Determine whether the Columns will contain expense or date information, and place an "x" in the appropriate cell. When you do this, you also define whether the label is Fixed or Variable. You can place only one "x" in the Column section (columns 6-9). Appendix C Page 213

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204
  • 205
  • 206
  • 207
  • 208
  • 209
  • 210
  • 211
  • 212
  • 213
  • 214
  • 215
  • 216
  • 217
  • 218
  • 219
  • 220
  • 221
  • 222
  • 223
  • 224
  • 225
  • 226
  • 227
  • 228
  • 229
  • 230
  • 231
  • 232
  • 233
  • 234
  • 235
  • 236
  • 237
  • 238
  • 239
  • 240
  • 241
  • 242
  • 243
  • 244

Appendix C
Page 213
5.
Scroll down to a blank area of the Maptable.xls file (below the rows
used for Sample4.xlt), and click on a row number to select a blank
row.
6.
From the Edit menu, choose Paste. A copy of the rows you selected
in step 3 is pasted into the Maptable.xls file.
7.
Name the table.
In the cell immediately to the right of the cell entitled
Template Name, enter the
exact
file name of your custom Expense
Report template.
8.
Define the number of Sections.
Each row in a table defines how your
organizer data will be placed in a Section of your custom Expense
Report. Note that the prepaid portion of a section has its own row
and counts as a separate section for map table purposes,
even
though it is not a separate section in your template
.
You may add or delete rows as necessary so that the total number
of rows corresponds to the number of Sections in your custom
Expense Report. To clear all of the existing settings in a row, click
to select the row and press Ctrl+Delete. Name each row to
correspond to a Section of your custom Expense Report.
9.
Determine the Label settings.
The orientation of the data fields (Row,
Column) appears in the yellow section of the table.
Determine whether the
Rows
will contain expense or date
information, and place an “x” in the appropriate cell. When you do
this, you also define whether the label is Fixed or Variable. You can
place only one “x” in the Row section (columns 2–5).
Determine whether the
Columns
will contain expense or date
information, and place an “x” in the appropriate cell. When you do
this, you also define whether the label is Fixed or Variable. You can
place only one “x” in the Column section (columns 6–9).
Table with
four sections