Spreadsheet: 71019d1271773467-pivot-table-with-mulitple-sheets-april-schedule-2007_test4pivota
Sheet: Sheet1

Sum of Total Hours |  |  | Date
Nurse | License | Pay Rate | 2010-04-01 00:00:00 | 2010-04-02 00:00:00 | 2010-04-03 00:00:00 | 2010-04-04 00:00:00 | 2010-04-05 00:00:00 | 2010-04-06 00:00:00 | 2010-04-07 00:00:00 | 2010-04-08 00:00:00 | 2010-04-09 00:00:00 | 2010-04-10 00:00:00 | 2010-04-11 00:00:00 | 2010-04-12 00:00:00 | 2010-04-13 00:00:00 | 2010-04-14 00:00:00 | 2010-04-15 00:00:00 | 2010-04-16 00:00:00 | 2010-04-17 00:00:00 | 2010-04-18 00:00:00 | 2010-04-19 00:00:00 | 2010-04-20 00:00:00 | 2010-04-21 00:00:00 | 2010-04-22 00:00:00 | 2010-04-23 00:00:00 | 2010-04-24 00:00:00 | 2010-04-25 00:00:00 | 2010-04-26 00:00:00 | 2010-04-27 00:00:00 | 2010-04-28 00:00:00 | 2010-04-29 00:00:00 | 2010-04-30 00:00:00 | Grand Total
[NAME] | LPN | 22 | 8 | 8 |  |  |  |  |  | 8 |  | 8 | 8 |  |  |  |  |  | 8 | 16 | 8 |  |  |  |  |  |  |  |  |  |  |  | 72
 |  | 33 |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 | LPN Total |  | 8 | 8 |  | 8 |  |  |  | 8 |  | 8 | 8 |  |  |  |  |  | 8 | 16 | 8 |  |  |  |  |  |  |  |  |  |  |  | 80
[NAME] |  |  | 8 | 8 |  | 8 |  |  |  | 8 |  | 8 | 8 |  |  |  |  |  | 8 | 16 | 8 |  |  |  |  |  |  |  |  |  |  |  | 80
[NAME] | RN | 7.25
 |  | 32
 | RN Total
[NAME]
[NAME] | RN | 30 |  |  | 8.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.5
 | RN Total |  |  |  | 8.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.5
[NAME] |  |  |  |  | 8.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.5
[NAME] | C.N.A | 14 |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  | 8 |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  | 24
 | C.N.A Total |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  | 8 |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  | 24
[NAME] Total |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  | 8 |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  | 24
[NAME] | LPN | 22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  | 8
 | LPN Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  | 8
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  | 8
[NAME] | LPN | 22 |  |  |  |  |  |  |  | 16 |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  | 24
 | LPN Total |  |  |  |  |  |  |  |  | 16 |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  | 24
[NAME] |  |  |  |  |  |  |  |  |  | 16 |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  | 24
[NAME] | C.N.A | 13
 | C.N.A Total
[NAME]
[NAME] | LPN | 19 | 8 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 | LPN Total |  | 8 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
[NAME] Total |  |  | 8 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
[NAME] | C.N.A | 16 |  |  |  |  | 8 |  |  | 8 |  |  |  |  | 8 | 8 |  |  |  | 8 | 16 |  |  |  |  |  |  |  |  |  |  |  | 56
 |  | 24 |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 | C.N.A Total |  |  |  |  | 8 | 8 |  |  | 8 |  |  |  |  | 8 | 8 |  |  |  | 8 | 16 |  |  |  |  |  |  |  |  |  |  |  | 64
[NAME] Total |  |  |  |  |  | 8 | 8 |  |  | 8 |  |  |  |  | 8 | 8 |  |  |  | 8 | 16 |  |  |  |  |  |  |  |  |  |  |  | 64
[NAME] | C.N.A | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 8 |  |  |  |  |  |  |  |  |  |  |  |  | 16
 | C.N.A Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 8 |  |  |  |  |  |  |  |  |  |  |  |  | 16
Raynelle Cooper Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 8 |  |  |  |  |  |  |  |  |  |  |  |  | 16
Shawntay Truly | LPN | 20 |  | 8 |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 | LPN Total |  |  | 8 |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
Shawntay Truly Total |  |  |  | 8 |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
[NAME] | LPN | 22 |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 | LPN Total |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
[NAME] Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
[NAME] | C.N.A | 12 |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 | C.N.A Total |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
Virginia Chilzer | LPN | 7.25 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 | LPN Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
Virginia Chilzer Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
(blank) | (blank) | (blank)
 | (blank) Total
(blank) Total
Grand Total |  |  | 16 | 24 | 8.5 | 16 | 24 |  |  | 32 |  | 8 | 8 |  | 23 | 17 | 8 | 8 | 16 | 40 | 40 |  |  |  |  |  |  |  |  |  |  |  | 288.5