Palm M505 Handbook - Page 267
Using applications other than Microsoft Excel, The Expense
UPC - 805931000323
View all Palm M505 manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 267 highlights
snacks. In the previous example, all expense items would be populated into row/column 4 of the custom Expense Report. 14. Complete the table. All of the remaining columns (49-57) in the table are used to define the column or row number that corresponds to the description. 15. Mark a Section for prepaid expenses (yellow column). If a row in the map table is for prepaid (company paid) expenses, type a "yes" in the cell on that Section's row. Type "no" in all the cells of this column that do not pertain to prepaid expenses. 16. Repeat steps 9 through 15 for each Section that you have defined for your custom Expense Report. 17. Map Expense Report Options dialog (magenta section). The Expense Report Options dialog has five fields where you can fill in data for the header on your expense report. Use this section to specify the row and column on your template where this information will be mapped. Because header data is not related to any particular Section, you have to fill in only one row. If the item does not appear on your template, leave these cells blank. Using applications other than Microsoft Excel You can use applications other than Microsoft Excel (such as Lotus 1-2-3 or Quattro Pro) to open and manipulate the Expense data on your computer. The data file is named "Expense.txt," and is stored in the Expense folder, within the folder containing the handheld user data. Expense data in the Expense.txt file is in tab-delimited format. Appendix C Page 257
-
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
-
245
-
246
-
247
-
248
-
249
-
250
-
251
-
252
-
253
-
254
-
255
-
256
-
257
-
258
-
259
-
260
-
261
-
262
-
263
-
264
-
265
-
266
-
267
-
268
-
269
-
270
-
271
-
272
-
273
-
274
-
275
-
276
-
277
-
278
-
279
-
280
-
281
-
282
-
283
-
284
-
285
-
286