Spreadsheet: 28752d1223295485-linking-to-another-workbook-and-pivot-table-dorm-roster-test-06-oct-2008
Sheet: 1st

ROOM | KEY | LAST NAME | Ph | TM | Accountability |  |  |  |  |  |  | ROOM | KEY | LAST NAME | Ph | TM | Accountability
# |  |  | # |  | S | M | T | W | T | F | S | # |  |  | # | # | S | M | T | W | T | F | S
100 B |  | MTL Room |  | 4 |  |  |  |  |  |  |  | 108 A | 1 | BYFORD |  | 5
101 A |  | MRE/Linen |  | 4 |  |  |  |  |  |  |  | 108 A | 1 | CALEB |  | 5
101 B |  | Supplies |  | 4 |  |  |  |  |  |  |  | 108 A |  |  |  | 5
102 A | 2 | ALLYN |  | 4 |  |  |  |  |  |  |  | 108 B | 1 | CLARK |  | 5
102 A | 4 | AUSTIN |  | 4 |  |  |  |  |  |  |  | 108 B | 3 | GRAY |  | 5
102 A |  |  |  |  |  |  |  |  |  |  |  | 108 B | 4 | [NAME]
102 B | 2 | BROCK |  | 4 |  |  |  |  |  |  |  | 109 A | 1 | DEVENS |  | 3
102 B | 3 | BROWN |  | 4 |  |  |  |  |  |  |  | 109 A | 4 | ELLIOT |  | 3
102 B | 1 | BUNCH |  | 4 |  |  |  |  |  |  |  | 109 A |  | GOODWIN |  | 3
103 A |  | CHACANACA |  | 4 |  |  |  |  |  |  |  | 109 B |  | HARPER |  | 3
103 A | 2 | CLARK |  | 4 |  |  |  |  |  |  |  | 109 B
103 A | 3 | DWIGANS |  | 4 |  |  |  |  |  |  |  | 109 B | 1 | HART |  | 3
103 B | 1 | GONZALEZ |  | 4 |  |  |  |  |  |  |  | 110 A | 3 | JENKINS |  | 3
103 B | 4 | HANSEN |  | 4 |  |  |  |  |  |  |  | 110 A
103 B | 1 | [NAME] |  | 4 |  |  |  |  |  |  |  | 110 A
104 A | 1 | HUSS |  | 4 |  |  |  |  |  |  |  | 110 B | 2 | GRIGGS |  | 5
104 A | 3 | [NAME] |  | 4 |  |  |  |  |  |  |  | 110 B |  |  |  | 5
104 A | 2 | LILLARD |  | 4 |  |  |  |  |  |  |  | 110 B | 3 | [NAME] |  | 5
104 B | 2 | LOHMANN |  | 4 |  |  |  |  |  |  |  | 111 A | 1 | ODAY |  | 3
104 B | 4 | MERCADO |  | 4 |  |  |  |  |  |  |  | 111 A | 4 | PERALES |  | 3
104 B | 3 | MOODY |  | 4 |  |  |  |  |  |  |  | 111 A
105 A | 2 | PERSON |  | 4 |  |  |  |  |  |  |  | 111 B | 4 | PRYSTAJKO |  | 3
105 A | 2 | QUIROS |  | 4 |  |  |  |  |  |  |  | 111 B |  | RUBIO |  | 3
105 A | 4 | [NAME] |  | 4 |  |  |  |  |  |  |  | 111 B
105 B | 3 | SAUER |  | 4 |  |  |  |  |  |  |  | 112 A | 3 | MORRIS |  | 5
105 B | 2 | SWEENEY |  | 4 |  |  |  |  |  |  |  | 112 A |  |  |  | 5
105 B | 2 | THOMPSON |  | 4 |  |  |  |  |  |  |  | 112 A | 1 | ROBINSON |  | 5
106 A |  |  |  |  |  |  |  |  |  |  |  | 112 B | 2 | ROMERO |  | 5
106 A | 3 | AFOA |  | 3 |  |  |  |  |  |  |  | 112 B | 1 | THOMAS |  | 5
106 A | 2 | OCHOA |  | 3 |  |  |  |  |  |  |  | 112 B | 2 | MILLIMAN |  | 3
106 B | 3 | WALKER |  | 4 |  |  |  |  |  |  |  | 113 A | 1 | HOEHN |  | 3
106 B | 1 | WILLFRED |  | 4 |  |  |  |  |  |  |  | 113 A | 4 | WEAVER |  | 3
106 B |  |  |  |  |  |  |  |  |  |  |  | 113 A
107 A | 4 | SMITH, C. |  | 3 |  |  |  |  |  |  |  | 113 B | 1 | WILSON |  | 3
107 A | 3 | BACINSKY |  | 4 |  |  |  |  |  |  |  | 113 B | 2 | WHITWORTH |  | 3
107 A |  |  |  |  |  |  |  |  |  |  |  | 113 B
107 B | 1 | BREWER |  | 3 |  |  |  |  |  |  |  | 114 A | 2 | VALERO |  | 5
107 B | 2 | CATHEY |  | 3 |  |  |  |  |  |  |  | 114 A | 4 | WHITTINGTON |  | 5
107 B |  |  |  |  |  |  |  |  |  |  |  | 114 A
Total Females |  |  |  |  |  |  |  |  |  |  |  | 114 B
Total Males |  |  |  |  |  |  |  |  |  |  |  | 114 B | 1 | LEHENBAUER |  | 3
DORM TOTAL |  |  |  |  |  |  |  |  |  |  |  | 114 B | 2 | MEARISE |  | 3
HUTMENT  TOTAL |  |  |  |  |  |  |  |  |  |  |  | 115 A
BULLIS TOTAL |  |  |  |  |  |  |  |  |  |  |  | 115 A
Dormitory 1st Floor |  |  |  |  |  |  |  |  |  |  |  | 115 A
Dormitory 2nd Floor |  |  |  |  |  |  |  |  |  |  |  | 115 B | 2 | CAPERELL |  | 3
Dormitory 3rd Floor |  |  |  |  |  |  |  |  |  |  |  | 115 B | 3 | BRENNAN |  | 3
Hutments |  |  |  |  |  |  |  |  |  |  |  | 115 B
MAL DM CAP |  | 192
FEM DM CAP |  | 84
MAL HUT CAP |  | 231
Total Mal CAP
DORM CAP:
[NAME] drm
Avail Fem drm
[NAME]
Tot Fem Avail
[NAME]