Survey Excel Template for Excel 2003

Document Sample
Survey Excel Template for Excel 2003 Powered By Docstoc
					3/22/2010 11:10 PM

         A           B          C          D       E               F         G       H        I      J      K      L               M         N                        O                 P     Q        R




                                                                                                                                           Provost




                                                                                                                                                                                            Delete
     RmRec#     Bldg Descr Floor     Room #    Row Type   Survey Action   Room      New   Survey    Sq Ft Stations A/C Room Type-SubType             Survey Comment       ORA Comment                Rm
                                                                          Exists   Room # Dept ID                                                                                                    Func %
 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
c4541451-ad38-487b-9251-ed3655d1ee05.xls                                                                          3/22/2010 11:10 PM                                                                          Page: 1 of 74
3/22/2010 11:10 PM

                 S                 T          U           V        W            X           Y          Z          AA          AB        AC          AD      AE               AF     AG           AH        AI      AJ           AK




                                            Delete2




                                                                                                                                        Delete3




                                                                                                                                                                                    Delete4
     RmFunc                    ORA Verify             ORA Proj     PG      PG Director   PG Title   Initial   PG needs    PG FY $ to-             Occ    OccDept   Occ Dept Descr             Occ Dept   Role % Unique   Role
                               Complete               Grt        EndDate                             Dept     OCR           date                  Dept % ID                                                     Name
 1                                                                                                            approval?
 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
c4541451-ad38-487b-9251-ed3655d1ee05.xls                                                            3/22/2010 11:10 PM                                                                                                               Page: 2 of 74
3/22/2010 11:10 PM

       AL
      Rm
      Occ
 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
c4541451-ad38-487b-9251-ed3655d1ee05.xls   3/22/2010 11:10 PM   Page: 3 of 74
3/22/2010 11:10 PM

         A           B          C          D       E               F         G       H        I      J      K      L               M         N                        O                 P     Q        R




                                                                                                                                           Provost




                                                                                                                                                                                            Delete
      RmRec#    Bldg Descr Floor     Room #    Row Type   Survey Action   Room      New   Survey    Sq Ft Stations A/C Room Type-SubType             Survey Comment       ORA Comment                Rm
                                                                          Exists   Room # Dept ID                                                                                                    Func %
 1
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
c4541451-ad38-487b-9251-ed3655d1ee05.xls                                                                          3/22/2010 11:10 PM                                                                          Page: 4 of 74
3/22/2010 11:10 PM

                 S                 T          U           V        W            X           Y          Z          AA          AB        AC          AD      AE               AF     AG           AH        AI      AJ           AK




                                            Delete2




                                                                                                                                        Delete3




                                                                                                                                                                                    Delete4
      RmFunc                   ORA Verify             ORA Proj     PG      PG Director   PG Title   Initial   PG needs    PG FY $ to-             Occ    OccDept   Occ Dept Descr             Occ Dept   Role % Unique   Role
                               Complete               Grt        EndDate                             Dept     OCR           date                  Dept % ID                                                     Name
 1                                                                                                            approval?
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
c4541451-ad38-487b-9251-ed3655d1ee05.xls                                                            3/22/2010 11:10 PM                                                                                                               Page: 5 of 74
3/22/2010 11:10 PM

       AL
      Rm
      Occ
 1
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
c4541451-ad38-487b-9251-ed3655d1ee05.xls   3/22/2010 11:10 PM   Page: 6 of 74
3/22/2010 11:10 PM

         A           B          C          D       E               F         G       H        I      J      K      L               M         N                        O                 P     Q        R




                                                                                                                                           Provost




                                                                                                                                                                                            Delete
      RmRec#    Bldg Descr Floor     Room #    Row Type   Survey Action   Room      New   Survey    Sq Ft Stations A/C Room Type-SubType             Survey Comment       ORA Comment                Rm
                                                                          Exists   Room # Dept ID                                                                                                    Func %
 1
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
c4541451-ad38-487b-9251-ed3655d1ee05.xls                                                                          3/22/2010 11:10 PM                                                                          Page: 7 of 74
3/22/2010 11:10 PM

                 S                 T          U           V        W            X           Y          Z          AA          AB        AC          AD      AE               AF     AG           AH        AI      AJ           AK




                                            Delete2




                                                                                                                                        Delete3




                                                                                                                                                                                    Delete4
      RmFunc                   ORA Verify             ORA Proj     PG      PG Director   PG Title   Initial   PG needs    PG FY $ to-             Occ    OccDept   Occ Dept Descr             Occ Dept   Role % Unique   Role
                               Complete               Grt        EndDate                             Dept     OCR           date                  Dept % ID                                                     Name
 1                                                                                                            approval?
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
c4541451-ad38-487b-9251-ed3655d1ee05.xls                                                            3/22/2010 11:10 PM                                                                                                               Page: 8 of 74
3/22/2010 11:10 PM

       AL
      Rm
      Occ
 1
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
c4541451-ad38-487b-9251-ed3655d1ee05.xls   3/22/2010 11:10 PM   Page: 9 of 74
3/22/2010 11:10 PM

         A           B          C          D       E               F         G       H        I      J      K      L               M         N                        O                 P     Q        R




                                                                                                                                           Provost




                                                                                                                                                                                            Delete
      RmRec#    Bldg Descr Floor     Room #    Row Type   Survey Action   Room      New   Survey    Sq Ft Stations A/C Room Type-SubType             Survey Comment       ORA Comment                Rm
                                                                          Exists   Room # Dept ID                                                                                                    Func %
 1
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
c4541451-ad38-487b-9251-ed3655d1ee05.xls                                                                          3/22/2010 11:10 PM                                                                          Page: 10 of 74
3/22/2010 11:10 PM

                 S                 T          U           V        W            X           Y          Z          AA          AB        AC          AD      AE               AF     AG           AH        AI      AJ           AK




                                            Delete2




                                                                                                                                        Delete3




                                                                                                                                                                                    Delete4
      RmFunc                   ORA Verify             ORA Proj     PG      PG Director   PG Title   Initial   PG needs    PG FY $ to-             Occ    OccDept   Occ Dept Descr             Occ Dept   Role % Unique   Role
                               Complete               Grt        EndDate                             Dept     OCR           date                  Dept % ID                                                     Name
 1                                                                                                            approval?
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
c4541451-ad38-487b-9251-ed3655d1ee05.xls                                                            3/22/2010 11:10 PM                                                                                                               Page: 11 of 74
3/22/2010 11:10 PM

       AL
      Rm
      Occ
 1
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
c4541451-ad38-487b-9251-ed3655d1ee05.xls   3/22/2010 11:10 PM   Page: 12 of 74
3/22/2010 11:10 PM

         A           B          C          D       E               F         G       H        I      J      K      L               M         N                        O                 P     Q        R




                                                                                                                                           Provost




                                                                                                                                                                                            Delete
      RmRec#    Bldg Descr Floor     Room #    Row Type   Survey Action   Room      New   Survey    Sq Ft Stations A/C Room Type-SubType             Survey Comment       ORA Comment                Rm
                                                                          Exists   Room # Dept ID                                                                                                    Func %
 1
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
c4541451-ad38-487b-9251-ed3655d1ee05.xls                                                                          3/22/2010 11:10 PM                                                                          Page: 13 of 74
3/22/2010 11:10 PM

                 S                 T          U           V        W            X           Y          Z          AA          AB        AC          AD      AE               AF     AG           AH        AI      AJ           AK




                                            Delete2




                                                                                                                                        Delete3




                                                                                                                                                                                    Delete4
      RmFunc                   ORA Verify             ORA Proj     PG      PG Director   PG Title   Initial   PG needs    PG FY $ to-             Occ    OccDept   Occ Dept Descr             Occ Dept   Role % Unique   Role
                               Complete               Grt        EndDate                             Dept     OCR           date                  Dept % ID                                                     Name
 1                                                                                                            approval?
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
c4541451-ad38-487b-9251-ed3655d1ee05.xls                                                            3/22/2010 11:10 PM                                                                                                               Page: 14 of 74
3/22/2010 11:10 PM

       AL
      Rm
      Occ
 1
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
c4541451-ad38-487b-9251-ed3655d1ee05.xls   3/22/2010 11:10 PM   Page: 15 of 74
3/22/2010 11:10 PM

         A           B          C          D       E               F         G       H        I      J      K      L               M         N                        O                 P     Q        R




                                                                                                                                           Provost




                                                                                                                                                                                            Delete
      RmRec#    Bldg Descr Floor     Room #    Row Type   Survey Action   Room      New   Survey    Sq Ft Stations A/C Room Type-SubType             Survey Comment       ORA Comment                Rm
                                                                          Exists   Room # Dept ID                                                                                                    Func %
 1
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
c4541451-ad38-487b-9251-ed3655d1ee05.xls                                                                          3/22/2010 11:10 PM                                                                          Page: 16 of 74
3/22/2010 11:10 PM

                 S                 T          U           V        W            X           Y          Z          AA          AB        AC          AD      AE               AF     AG           AH        AI      AJ           AK




                                            Delete2




                                                                                                                                        Delete3




                                                                                                                                                                                    Delete4
      RmFunc                   ORA Verify             ORA Proj     PG      PG Director   PG Title   Initial   PG needs    PG FY $ to-             Occ    OccDept   Occ Dept Descr             Occ Dept   Role % Unique   Role
                               Complete               Grt        EndDate                             Dept     OCR           date                  Dept % ID                                                     Name
 1                                                                                                            approval?
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
c4541451-ad38-487b-9251-ed3655d1ee05.xls                                                            3/22/2010 11:10 PM                                                                                                               Page: 17 of 74
3/22/2010 11:10 PM

       AL
      Rm
      Occ
 1
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
c4541451-ad38-487b-9251-ed3655d1ee05.xls   3/22/2010 11:10 PM   Page: 18 of 74
3/22/2010 11:10 PM

         A           B          C          D       E               F         G       H        I      J      K      L               M         N                        O                 P     Q        R




                                                                                                                                           Provost




                                                                                                                                                                                            Delete
      RmRec#    Bldg Descr Floor     Room #    Row Type   Survey Action   Room      New   Survey    Sq Ft Stations A/C Room Type-SubType             Survey Comment       ORA Comment                Rm
                                                                          Exists   Room # Dept ID                                                                                                    Func %
 1
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
c4541451-ad38-487b-9251-ed3655d1ee05.xls                                                                          3/22/2010 11:10 PM                                                                          Page: 19 of 74
3/22/2010 11:10 PM

                 S                 T          U           V        W            X           Y          Z          AA          AB        AC          AD      AE               AF     AG           AH        AI      AJ           AK




                                            Delete2




                                                                                                                                        Delete3




                                                                                                                                                                                    Delete4
      RmFunc                   ORA Verify             ORA Proj     PG      PG Director   PG Title   Initial   PG needs    PG FY $ to-             Occ    OccDept   Occ Dept Descr             Occ Dept   Role % Unique   Role
                               Complete               Grt        EndDate                             Dept     OCR           date                  Dept % ID                                                     Name
 1                                                                                                            approval?
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
c4541451-ad38-487b-9251-ed3655d1ee05.xls                                                            3/22/2010 11:10 PM                                                                                                               Page: 20 of 74
3/22/2010 11:10 PM

       AL
      Rm
      Occ
 1
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
c4541451-ad38-487b-9251-ed3655d1ee05.xls   3/22/2010 11:10 PM   Page: 21 of 74
3/22/2010 11:10 PM

         A           B          C          D       E               F         G       H        I      J      K      L               M         N                        O                 P     Q        R




                                                                                                                                           Provost




                                                                                                                                                                                            Delete
      RmRec#    Bldg Descr Floor     Room #    Row Type   Survey Action   Room      New   Survey    Sq Ft Stations A/C Room Type-SubType             Survey Comment       ORA Comment                Rm
                                                                          Exists   Room # Dept ID                                                                                                    Func %
 1
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
c4541451-ad38-487b-9251-ed3655d1ee05.xls                                                                          3/22/2010 11:10 PM                                                                          Page: 22 of 74
3/22/2010 11:10 PM

                 S                 T          U           V        W            X           Y          Z          AA          AB        AC          AD      AE               AF     AG           AH        AI      AJ           AK




                                            Delete2




                                                                                                                                        Delete3




                                                                                                                                                                                    Delete4
      RmFunc                   ORA Verify             ORA Proj     PG      PG Director   PG Title   Initial   PG needs    PG FY $ to-             Occ    OccDept   Occ Dept Descr             Occ Dept   Role % Unique   Role
                               Complete               Grt        EndDate                             Dept     OCR           date                  Dept % ID                                                     Name
 1                                                                                                            approval?
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
c4541451-ad38-487b-9251-ed3655d1ee05.xls                                                            3/22/2010 11:10 PM                                                                                                               Page: 23 of 74
3/22/2010 11:10 PM

       AL
      Rm
      Occ
 1
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
c4541451-ad38-487b-9251-ed3655d1ee05.xls   3/22/2010 11:10 PM   Page: 24 of 74
3/22/2010 11:10 PM

         A           B          C          D       E               F         G       H        I      J      K      L               M         N                        O                 P     Q        R




                                                                                                                                           Provost




                                                                                                                                                                                            Delete
      RmRec#    Bldg Descr Floor     Room #    Row Type   Survey Action   Room      New   Survey    Sq Ft Stations A/C Room Type-SubType             Survey Comment       ORA Comment                Rm
                                                                          Exists   Room # Dept ID                                                                                                    Func %
 1
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
c4541451-ad38-487b-9251-ed3655d1ee05.xls                                                                          3/22/2010 11:10 PM                                                                          Page: 25 of 74
3/22/2010 11:10 PM

                 S                 T          U           V        W            X           Y          Z          AA          AB        AC          AD      AE               AF     AG           AH        AI      AJ           AK




                                            Delete2




                                                                                                                                        Delete3




                                                                                                                                                                                    Delete4
      RmFunc                   ORA Verify             ORA Proj     PG      PG Director   PG Title   Initial   PG needs    PG FY $ to-             Occ    OccDept   Occ Dept Descr             Occ Dept   Role % Unique   Role
                               Complete               Grt        EndDate                             Dept     OCR           date                  Dept % ID                                                     Name
 1                                                                                                            approval?
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
c4541451-ad38-487b-9251-ed3655d1ee05.xls                                                            3/22/2010 11:10 PM                                                                                                               Page: 26 of 74
3/22/2010 11:10 PM

       AL
      Rm
      Occ
 1
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
c4541451-ad38-487b-9251-ed3655d1ee05.xls   3/22/2010 11:10 PM   Page: 27 of 74
3/22/2010 11:10 PM

         A           B          C          D       E               F         G       H        I      J      K      L               M         N                        O                 P     Q        R




                                                                                                                                           Provost




                                                                                                                                                                                            Delete
      RmRec#    Bldg Descr Floor     Room #    Row Type   Survey Action   Room      New   Survey    Sq Ft Stations A/C Room Type-SubType             Survey Comment       ORA Comment                Rm
                                                                          Exists   Room # Dept ID                                                                                                    Func %
 1
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
c4541451-ad38-487b-9251-ed3655d1ee05.xls                                                                          3/22/2010 11:10 PM                                                                          Page: 28 of 74
3/22/2010 11:10 PM

                 S                 T          U           V        W            X           Y          Z          AA          AB        AC          AD      AE               AF     AG           AH        AI      AJ           AK




                                            Delete2




                                                                                                                                        Delete3




                                                                                                                                                                                    Delete4
      RmFunc                   ORA Verify             ORA Proj     PG      PG Director   PG Title   Initial   PG needs    PG FY $ to-             Occ    OccDept   Occ Dept Descr             Occ Dept   Role % Unique   Role
                               Complete               Grt        EndDate                             Dept     OCR           date                  Dept % ID                                                     Name
 1                                                                                                            approval?
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
c4541451-ad38-487b-9251-ed3655d1ee05.xls                                                            3/22/2010 11:10 PM                                                                                                               Page: 29 of 74
3/22/2010 11:10 PM

       AL
      Rm
      Occ
 1
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
c4541451-ad38-487b-9251-ed3655d1ee05.xls   3/22/2010 11:10 PM   Page: 30 of 74
3/22/2010 11:10 PM

         A           B          C          D       E               F         G       H        I      J      K      L               M         N                        O                 P     Q        R




                                                                                                                                           Provost




                                                                                                                                                                                            Delete
      RmRec#    Bldg Descr Floor     Room #    Row Type   Survey Action   Room      New   Survey    Sq Ft Stations A/C Room Type-SubType             Survey Comment       ORA Comment                Rm
                                                                          Exists   Room # Dept ID                                                                                                    Func %
 1
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591




c4541451-ad38-487b-9251-ed3655d1ee05.xls                                                                          3/22/2010 11:10 PM                                                                          Page: 31 of 74
3/22/2010 11:10 PM

                 S                 T          U           V        W            X           Y          Z          AA          AB        AC          AD      AE               AF     AG           AH        AI      AJ           AK




                                            Delete2




                                                                                                                                        Delete3




                                                                                                                                                                                    Delete4
      RmFunc                   ORA Verify             ORA Proj     PG      PG Director   PG Title   Initial   PG needs    PG FY $ to-             Occ    OccDept   Occ Dept Descr             Occ Dept   Role % Unique   Role
                               Complete               Grt        EndDate                             Dept     OCR           date                  Dept % ID                                                     Name
 1                                                                                                            approval?
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591




c4541451-ad38-487b-9251-ed3655d1ee05.xls                                                            3/22/2010 11:10 PM                                                                                                               Page: 32 of 74
3/22/2010 11:10 PM

       AL
      Rm
      Occ
 1
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591




c4541451-ad38-487b-9251-ed3655d1ee05.xls   3/22/2010 11:10 PM   Page: 33 of 74
NOTE: This tab contains lists for data verification.
Please DO NOT change any values here. Click on the 'SurveyData' tab below to get back to the survey data.

SurveyActionLookup                    RoomTypeSubTypeLookup
Hold                                  010:Custodial
Hold Square Footage                   010-01:Custodial-Linen
Hold Termination-Inactive             010-02:Custodial-JanClos
Hold New Room                         020:Circulat'n
Hold Room Renumber                    020-01:Circulat'n-PubCorr
In Process                            020-02:Circulat'n-InCourtyd
None                                  020-03:Circulat'n-Dock
To Authorizer                         020-04:Circulat'n-Elevator
To Space Analysis                     020-05:Circulat'n-Escalator
To Submitter                          020-06:Circulat'n-LobbyVest
Verified                              020-07:Circulat'n-Stair
                                      030:Mechanical
                                      030-01:Mechanical-MaintRm
                                      030-02:Mechanical-Comm
                                      030-03:Mechanical-Elect
                                      030-04:Mechanical-Mech
                                      030-05:Mechanical-VertShaft
                                      030-06:Mechanical-RestRm
                                      040:PubRestRm
                                      040-01:PubRestRm-UniRestRm
                                      040-02:PubRestRm-WomRestRm
                                      040-03:PubRestRm-MenRestRm
                                      040-04:PubRestRm-Uni-Handic
                                      040-05:PubRestRm-Wom-Handic
                                      040-06:PubRestRm-Men-Handic
                                      050:Inactive
                                      050-00:Inactive-Inactive
                                      050-01:Inactive-InatvNCLab
                                      060:Renovation
                                      060-00:Renovation-Alteration
                                      070:Unfinished
                                      070-00:Unfinished-Unfinished
                                      110:Classroom
                                      110-00:Classroom-Classroom
                                      110-01:Classroom-Aud
                                      110-02:Classroom-Lecture
                                      110-03:Classroom-Stnd
                                      115:Class Serv
                                      115-00:Class Serv-ClassrmSrv
                                      210:Class Lab
                                      210-00:Class Lab-Class Lab
                                      210-01:Class Lab-Dry
210-02:Class Lab-Wet
210-03:Class Lab-Physical
210-04:Class Lab-Comp
215:ClasLabSv
215-00:ClasLabSv-ClasLabSv
215-01:ClasLabSv-ScopeRm
215-02:ClasLabSv-TmCtlRm
215-03:ClasLabSv-EqmtRm
215-04:ClasLabSv-ShEqmtRm
215-05:ClasLabSv-PrepRm
215-06:ClasLabSv-SvcStRm
215-07:ClasLabSv-DarkRm
215-08:ClasLabSv-TmpHazStRm
215-09:ClasLabSv-TisCulRm
215-10:ClasLabSv-DishAutclv
220:Open Lab
220-00:Open Lab-Open Lab
225:OpenLabSvc
225-00:OpenLabSvc-OpenLabSvc
250:ResNCLab
250-00:ResNCLab-ResNCLab
250-01:ResNCLab-Dry
250-02:ResNCLab-Wet
250-03:ResNCLab-Physical
250-04:ResNCLab-Comp
250-05:ResNCLab-Core Lab
250-06:ResNCLab-Shared Lab
250-07:ResNCLab-Fac Shared
250-08:ResNCLab-ResCentLab
250-09:ResNCLab-Faculty
255:ResLabSvc
255-00:ResLabSvc-ResLabSvc
255-01:ResLabSvc-ScopeRm
255-02:ResLabSvc-TmCtlRm
255-03:ResLabSvc-EqmtRm
255-04:ResLabSvc-ShEqmtRm
255-05:ResLabSvc-PrepRm
255-06:ResLabSvc-SvcStRm
255-07:ResLabSvc-DarkRm
255-08:ResLabSvc-TmpHazStRm
255-09:ResLabSvc-TisCulRm
255-10:ResLabSvc-CldRm
255-11:ResLabSvc-WmRm
255-12:ResLabSvc-DW/AC
255-13:ResLabSvc-FlmXR
255-14:ResLabSvc-Tank
255-15:ResLabSvc-Chem
255-16:ResLabSvc-ChemSynth
255-17:ResLabSvc-Clean
255-18:ResLabSvc-DkRmPhoto
255-19:ResLabSvc-DkRmScope
310:Office
310-00:Office-Office
310-01:Office-Faculty
310-02:Office-Staff
310-03:Office-Student
310-04:Office-MD
310-05:Office-HsOfr
310-06:Office-Nurse
310-07:Office-MedAsst
310-08:Office-Trainee
310-09:Office-Visiting
310-10:Office-GSRA
310-11:Office-Post Doc
310-12:Office-GSI
310-13:Office-FacShared
310-14:Office-ResCenter
310-15:Office-OpenWkSta
315:Office Svc
315-00:Office Svc-Office Svc
315-01:Office Svc-SupplyRm
315-02:Office Svc-CopyRm
315-03:Office Svc-FileRm
315-04:Office Svc-CompSuppt
315-05:Office Svc-RecepArea
315-06:Office Svc-AsgToilt
315-07:Office Svc-StaffLkRm
315-08:Office Svc-AssignCir
315-09:Office Svc-DptLnge
315-10:Office Svc-DptKitchen
315-11:Office Svc-DptStorage
315-12:Office Svc-DptMail
315-13:Office Svc-DptBreak
315-14:Office Svc-Closet
315-15:Office Svc-UMH Elect
315-16:Office Svc-UMH Mech
315-17:Office Svc-UMH Jan
315-18:Office Svc-UMH Stair
315-19:Office Svc-UMH Elev
315-20:Office Svc-Privacy
350:Conference
350-00:Conference-Conference
350-01:Conference-TraingRm
355:ConfRmSvc
355-00:ConfRmSvc-ConfRmSvc
410:Study Rm
410-00:Study Rm-Study Rm
420:Stack
420-00:Stack-Stack
430:OpnStackSt
430-00:OpnStackSt-OpnStackSt
430-01:OpnStackSt-Dept
430-02:OpnStackSt-Patnt
430-03:OpnStackSt-Central
440:Proc Rm
440-00:Proc Rm-Proc Rm
455:Study Serv
455-00:Study Serv-Study Serv
510:Armory
510-00:Armory-Armory
515:Armory Svc
515-00:Armory Svc-Armory Svc
520:Ath/PhyEdu
520-00:Ath/PhyEdu-Ath/PhyEdu
520-01:Ath/PhyEdu-FitEqCntr
523:Spec Seat
523-00:Spec Seat-Spec Seat
525:Ath/PEServ
525-00:Ath/PEServ-Ath/PEServ
525-01:Ath/PEServ-LkrRm
530:Media Prod
530-00:Media Prod-Media Prod
530-01:Media Prod-PhotogRm
535:MedProdSvc
535-00:MedProdSvc-MedProdSvc
535-01:MedProdSvc-PhotogSvc
540:Clinic
540-00:Clinic-Clinic
545:Clinic Svc
545-00:Clinic Svc-Clinic Svc
550:Demo
550-00:Demo-Demo
555:Demo Serv
555-00:Demo Serv-Demo Serv
560:Field Bldg
560-00:Field Bldg-Field Bldg
570:Animal Qtr
570-00:Animal Qtr-Animal Qtr
570-01:Animal Qtr-Hsg
570-02:Animal Qtr-RecvrRm
575:AnimQtrSvc
575-00:AnimQtrSvc-AnimQtrSvc
575-01:AnimQtrSvc-AutoclvRm
575-02:AnimQtrSvc-BedgStRm
575-03:AnimQtrSvc-CageWashRm
575-04:AnimQtrSvc-TmCtlRm
575-05:AnimQtrSvc-DiagSvc
575-06:AnimQtrSvc-EuthChmbr
575-07:AnimQtrSvc-FoodStg
575-08:AnimQtrSvc-Laundry
575-09:AnimQtrSvc-Necropsy
575-10:AnimQtrSvc-Surgery
575-11:AnimQtrSvc-AnteRm
580:Greenhouse
580-00:Greenhouse-Greenhouse
585:GrnhseServ
585-00:GrnhseServ-GrnhseServ
610:Assembly
610-00:Assembly-Assembly
610-01:Assembly-Chapel
610-02:Assembly-NonClsAud
615:AssemblySv
615-00:AssemblySv-AssemblySv
615-01:AssemblySv-NClsAudSvc
620:Exhibition
620-00:Exhibition-Exhibition
625:ExhibitSrv
625-00:ExhibitSrv-ExhibitSrv
630:Food Fac
630-00:Food Fac-Food Fac
630-01:Food Fac-DingHlCaf
630-02:Food Fac-VndgSeatg
635:FoodFacSvc
635-00:FoodFacSvc-FoodFacSvc
635-01:FoodFacSvc-DingHlCaf
635-02:FoodFacSvc-VndgSeatg
635-03:FoodFacSvc-Other
635-04:FoodFacSvc-FoodStPrep
635-05:FoodFacSvc-Kitchen
635-06:FoodFacSvc-RefrigRm
635-07:FoodFacSvc-DRServ
640:Day Care
640-00:Day Care-Day Care
640-01:Day Care-GymDCare
640-02:Day Care-InfantTodl
640-03:Day Care-PreschlRm
645:DayCareSvc
645-00:DayCareSvc-DayCareSvc
650:Lounge
650-00:Lounge-Lounge
650-01:Lounge-Staff
650-02:Lounge-Visitor
655:LoungeServ
655-00:LoungeServ-LoungeServ
660:Merchandsg
660-00:Merchandsg-Merchandsg
660-01:Merchandsg-VndgWOStg
660-02:Merchandsg-Gift Shop
665:MerchServ
665-00:MerchServ-MerchServ
670:Recreation
670-00:Recreation-Recreation
675:Rec Serv
675-00:Rec Serv-Rec Serv
680:Meeting Rm
680-00:Meeting Rm-Meeting Rm
685:MtgRmServ
685-00:MtgRmServ-MtgRmServ
710:ComputTele
710-00:ComputTele-ComputTele
715:CompTeleSe
715-00:CompTeleSe-CompTeleSe
720:Shop
720-00:Shop-Shop
725:Shop Serv
725-00:Shop Serv-Shop Serv
725-01:Shop Serv-Storage
725-02:Shop Serv-StockRm
725-03:Shop Serv-General
725-04:Shop Serv-Toilet
725-05:Shop Serv-Locker Rm
725-06:Shop Serv-Shower
730:CenStorage
730-00:CenStorage-CenStorage
730-01:CenStorage-RemoteLoc
735:CenStorSrv
735-00:CenStorSrv-CenStorSrv
740:AutoStorag
740-00:AutoStorag-AutoStorag
745:AutoStorFa
745-00:AutoStorFa-AutoStorFa
750:CentralSvc
750-00:CentralSvc-CentralSvc
750-01:CentralSvc-Laundry
750-02:CentralSvc-MailRm
750-03:CentralSvc-RecvShip
755:CServSupp
755-00:CServSupp-CServSupp
755-01:CServSupp-GenHldg
755-02:CServSupp-ClnLaunHld
755-03:CServSupp-SoilLaunHl
755-04:CServSupp-RecShpHldg
764:HazardMat
764-00:HazardMat-HazardMat
765:HazMatServ
765-00:HazMatServ-HazMatServ
810:PatienBdrm
810-00:PatienBdrm-PatienBdrm
810-01:PatienBdrm-InPatnt
810-02:PatienBdrm-LbrDeliv
810-03:PatienBdrm-LbrDeliIso
810-04:PatienBdrm-Nursery
810-05:PatienBdrm-NrsryICU
810-06:PatienBdrm-InPatnICU
810-07:PatienBdrm-InPatnIso
810-08:PatienBdrm-NeoICUIso
815:PatBedSvc
815-00:PatBedSvc-PatBedSvc
815-01:PatBedSvc-ActPlayRm
815-02:PatBedSvc-AnteRm
815-03:PatBedSvc-PatntClsRm
815-04:PatBedSvc-PatnKitchn
815-05:PatBedSvc-PatnLounge
815-06:PatBedSvc-General
820:PatientBth
820-00:PatientBth-PatientBth
820-01:PatientBth-PatnToilt
830:Nurse Stat
830-00:Nurse Stat-Nurse Stat
830-01:Nurse Stat-ChartRm
830-02:Nurse Stat-StaffRm
830-03:Nurse Stat-Triage
835:NurseStnSr
835-00:NurseStnSr-NurseStnSr
835-01:NurseStnSr-ChartFFRm
835-02:NurseStnSr-CleanRm
835-03:NurseStnSr-SterileStg
835-04:NurseStnSr-SupplyRm
835-05:NurseStnSr-PrepStgRm
835-06:NurseStnSr-NurismtRm
835-07:NurseStnSr-SoiledRm
835-08:NurseStnSr-TubRm
840:Surgery
840-00:Surgery-Surgery
840-01:Surgery-Delivery
840-02:Surgery-Operating
840-03:Surgery-ProcedRm
845:SurgerySvc
845-00:SurgerySvc-SurgerySvc
845-01:SurgerySvc-ClnLinSupl
845-02:SurgerySvc-SrgySupEqm
845-03:SurgerySvc-LaborRm
845-04:SurgerySvc-StaffLkrRm
845-05:SurgerySvc-PreOpPtPre
845-06:SurgerySvc-RecovryRm
845-07:SurgerySvc-ScrubRm
845-08:SurgerySvc-SoiLinSupl
845-09:SurgerySvc-SterInsSup
850:Treat/Exam
850-00:Treat/Exam-Treat/Exam
850-01:Treat/Exam-ConsultRm
850-02:Treat/Exam-DiagTrtmt
850-03:Treat/Exam-ExamRm
850-04:Treat/Exam-TherTrtmt
850-05:Treat/Exam-AcThTrtRm
850-06:Treat/Exam-DyQtTrtRm
850-07:Treat/Exam-BedShort
855:Tr/ExamSvc
855-00:Tr/ExamSvc-Tr/ExamSvc
855-01:Tr/ExamSvc-ClnLinSupl
855-02:Tr/ExamSvc-CtrlExamRm
855-03:Tr/ExamSvc-EqmtStrgRm
855-04:Tr/ExamSvc-FilmPrView
855-05:Tr/ExamSvc-ObsrvtnRm
855-06:Tr/ExamSvc-PtDrssPrep
855-07:Tr/ExamSvc-SoiLinSupl
855-08:Tr/ExamSvc-SuplStgRm
860:DiagSrvLab
860-00:DiagSrvLab-DiagSrvLab
860-01:DiagSrvLab-AutopsyRm
860-02:DiagSrvLab-IsotopeRm
860-03:DiagSrvLab-OpticalSvc
860-04:DiagSrvLab-Pharmacy
860-05:DiagSrvLab-ProsthShop
860-06:DiagSrvLab-BldDrawSta
865:DiagLabSup
865-00:DiagLabSup-DiagLabSup
865-01:DiagLabSup-Morgue
865-02:DiagLabSup-PharSupply
865-03:DiagLabSup-General
870:CentralSup
870-00:CentralSup-CentralSup
870-01:CentralSup-MedEqmtSt
870-02:CentralSup-MedGasStrg
870-03:CentralSup-MedRecStrg
870-04:CentralSup-MedSuppSt
870-05:CentralSup-WaterTrtmt
870-06:CentralSup-X-RayStrg
880:PublicWait
880-00:PublicWait-PublicWait
880-01:PublicWait-Admitting
880-02:PublicWait-ReceptWtg
880-03:PublicWait-Lobby
880-04:PublicWait-ReceptClk
890:StaffOnCal
890-00:StaffOnCal-StaffOnCal
890-01:StaffOnCal-On-CallRm
890-02:StaffOnCal-HseOfcrOnC
895:StfOnCallS
895-00:StfOnCallS-StfOnCallS
910:SleepWOBth
910-00:SleepWOBth-SleepWOBth
910-04:SleepWOBth-Sleep/Clst
910-05:SleepWOBth-Sleep/Liv
910-06:SleepWOBth-Sleep/Slp
919:Toilet/Bat
919-00:Toilet/Bat-Toilet/Bat
920:SleepWBath
920-00:SleepWBath-SleepWBath
920-01:SleepWBath-HtlSuite
920-02:SleepWBath-HtlW/Bath
920-03:SleepWBath-Sleep/Tlt
920-04:SleepWBath-Sleep/Clst
920-05:SleepWBath-Sleep/Liv
920-06:SleepWBath-Sleep/Slp
935:Sleep Serv
935-00:Sleep Serv-Sleep Serv
935-01:Sleep Serv-Htl LLaund
935-02:Sleep Serv-Htl Regist
935-03:Sleep Serv-Htl Serv
950:Apt/Efficy
950-00:Apt/Efficy-Apt/Efficy
950-01:Apt/Efficy-Apt/Tlt
950-02:Apt/Efficy-Apt/Clst
950-03:Apt/Efficy-Apt/Ktchn
950-04:Apt/Efficy-Apt/Lvg Rm
950-05:Apt/Efficy-Apt/Sleep
951:1BedrmApt
951-00:1BedrmApt-1BedrmApt
951-01:1BedrmApt-Apt/Tlt
951-02:1BedrmApt-Apt/Clst
951-03:1BedrmApt-Apt/Ktchn
951-04:1BedrmApt-Apt/Lvg Rm
951-05:1BedrmApt-Apt/Sleep
952:2BedrmApt
952-00:2BedrmApt-2BedrmApt
952-01:2BedrmApt-Apt/Tlt
952-02:2BedrmApt-Apt/Clst
952-03:2BedrmApt-Apt/Ktchn
952-04:2BedrmApt-Apt/Lvg Rm
952-05:2BedrmApt-Apt/Sleep
953:3BedrmApt
953-00:3BedrmApt-3BedrmApt
953-01:3BedrmApt-Apt/Tlt
953-02:3BedrmApt-Apt/Clst
953-03:3BedrmApt-Apt/Ktchn
953-04:3BedrmApt-Apt/Lvg Rm
953-05:3BedrmApt-Apt/Sleep
955:Apt Serv
955-00:Apt Serv-Apt Serv
970:House
970-00:House-House
970-01:House-Hse/Tlt
970-02:House-Hse/Clst
970-03:House-Hse/Ktchn
970-04:House-Hse/Lvg Rm
970-05:House-Hse/Sleep
970-06:House-Hse/Study
970-07:House-Hse/Dining
970-08:House-Hse/Pantry
970-09:House-Hse/Family
                                                              NOTE: This tab contains lists for data ver
w to get back to the survey data.                             Please DO NOT change any values here. Click on the

            RmFunctionLookup                                  RmRoleLookup
            0010:Custodial Area                               *Faculty - Allocated Space
            0020:Circulation Area                             Adjunct
            0030:Mechanical Area                              Contact Person
            0040:Public Restroom                              Department Administrator
            0050:Inactive Area                                Emergency Contact
            0060:Alteration Area                              Facilities Manager
            0070:Unfinished Area                              Faculty
            0102:Instruction/Departmental Research            Grad Student Research Asst
            0202:Organized Research                           Graduate Student
            0302:Other Sponsored Activ/Public Service         Graduate Student Instructor
            0402:Departmental Administration                  Junior Investigator
            0502:General Administration                       Non-Designated
            0602:Sponsored Projects Administration            Post Doctoral
            0702:Student Administration and Services          Primary Research
            0802:Plant Operations and Maintenance             Principal Investigator
            0902:Heating Plant and Utilities                  Professor Emeritus
            1002:Library                                      Research Assistant
            1102:Internal Service Operations                  Research Associate
            1202:Specialized Service Facilities               Room Scheduler
            1302:Other Institutional Activities               Staff
            1303:Other Institutional Activities/Private Use   Staff - Administrative
                                                              Staff - Research
                                                              Temporary Employee
                                                              Tenure Track
                                                              Visiting
ins lists for data verification.                                                   NOTE: This tab contains lists
values here. Click on the 'SurveyData' tab below to get back to the survey data.   Please DO NOT change any values he

           ORAverifyflag                      DeleteFlag          ValidRowTypes    ACflag
           Y                                  X                   SURVEY           Y
           N                                                      SVYCHG           N
                                                                  FUNC
                                                                  FUNC+
                                                                  ORA
                                                                  ORA+
                                                                  PERSON
                                                                  PERSON+
                                                                  DEPT
                                                                  DEPT+
                                                                  Row Type
                                                                  ORAV
                                                                  ORAVCHG
This tab contains lists for data verification.
O NOT change any values here. Click on the 'SurveyData' tab below to get back to the survey data.

            RoomExistsflag         ProvostFlag            RmOccupantFlag
            Yes                    Y                      Y
            No                     N                      N