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

Sum of Total Hours |  |  | Date
Nurse | License | Pay Rate | 2010-03-30 00:00:00 | 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 | (blank) | Grand Total
[NAME] | LPN | 22 | 8 |  |  |  |  |  |  |  |  |  | 8 | 8 |  |  |  |  | 8 |  |  |  |  |  |  |  | 8 | 8 |  |  |  |  | 8 |  | 56
 | LPN Total |  | 8 |  |  |  |  |  |  |  |  |  | 8 | 8 |  |  |  |  | 8 |  |  |  |  |  |  |  | 8 | 8 |  |  |  |  | 8 |  | 56
Alice Deets Total |  |  | 8 |  |  |  |  |  |  |  |  |  | 8 | 8 |  |  |  |  | 8 |  |  |  |  |  |  |  | 8 | 8 |  |  |  |  | 8 |  | 56
[NAME] | C.N.A | 12 |  | 8.25 |  |  | 8 | 8 | 11.75 |  | 8 |  |  | 8 | 8 | 8 | 12 | 8 |  | 8 |  | 8 | 12 | 8 | 12 |  |  | 12 | 8 | 12 |  | 16 |  |  | 184
 | C.N.A Total |  |  | 8.25 |  |  | 8 | 8 | 11.75 |  | 8 |  |  | 8 | 8 | 8 | 12 | 8 |  | 8 |  | 8 | 12 | 8 | 12 |  |  | 12 | 8 | 12 |  | 16 |  |  | 184
Brittany Avery Total |  |  |  | 8.25 |  |  | 8 | 8 | 11.75 |  | 8 |  |  | 8 | 8 | 8 | 12 | 8 |  | 8 |  | 8 | 12 | 8 | 12 |  |  | 12 | 8 | 12 |  | 16 |  |  | 184
[NAME] | C.N.A | 12.75 |  | 7.75 |  | 8 | 7.5 | 7.75 |  |  |  |  |  | 16 | 8 | 16 | 16 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  | 183
 | C.N.A Total |  |  | 7.75 |  | 8 | 7.5 | 7.75 |  |  |  |  |  | 16 | 8 | 16 | 16 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  | 183
[NAME] Total |  |  |  | 7.75 |  | 8 | 7.5 | 7.75 |  |  |  |  |  | 16 | 8 | 16 | 16 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  | 183
[NAME] | LPN | 24 |  | 8 |  |  |  |  |  |  |  | 8 |  |  |  |  | 8 | 8 |  |  |  |  |  | 8 |  |  |  |  |  | 8 | 8 | 8 |  |  | 64
 | LPN Total |  |  | 8 |  |  |  |  |  |  |  | 8 |  |  |  |  | 8 | 8 |  |  |  |  |  | 8 |  |  |  |  |  | 8 | 8 | 8 |  |  | 64
[NAME] |  |  |  | 8 |  |  |  |  |  |  |  | 8 |  |  |  |  | 8 | 8 |  |  |  |  |  | 8 |  |  |  |  |  | 8 | 8 | 8 |  |  | 64
Deb Eonta | LPN | 23 |  |  | 8.5 | 7.5 |  | 8.5 | 8 |  | 8 | 7.5 |  |  | 8 | 8 | 8 | 8 |  | 8 | 8 | 8 |  | 8 | 8 | 8 |  |  |  |  |  |  |  |  | 128
 |  | 34.5 |  |  |  | 1 | 8 |  |  |  |  | 0.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.75
 | LPN Total |  |  |  | 8.5 | 8.5 | 8 | 8.5 | 8 |  | 8 | 8.25 |  |  | 8 | 8 | 8 | 8 |  | 8 | 8 | 8 |  | 8 | 8 | 8 |  |  |  |  |  |  |  |  | 137.75
Deb Eonta Total |  |  |  |  | 8.5 | 8.5 | 8 | 8.5 | 8 |  | 8 | 8.25 |  |  | 8 | 8 | 8 | 8 |  | 8 | 8 | 8 |  | 8 | 8 | 8 |  |  |  |  |  |  |  |  | 137.75
[NAME] | C.N.A | 11 |  | 8 |  |  |  |  |  |  | 6.5 |  |  | 8 | 8 |  | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 |  | 8 | 8 | 8 |  | 126.5
 | C.N.A Total |  |  | 8 |  |  |  |  |  |  | 6.5 |  |  | 8 | 8 |  | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 |  | 8 | 8 | 8 |  | 126.5
[NAME] Total |  |  |  | 8 |  |  |  |  |  |  | 6.5 |  |  | 8 | 8 |  | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 |  | 8 | 8 | 8 |  | 126.5
[NAME] | C.N.A | 13.5 |  | 8 |  |  |  | 8 | 15.5 |  | 8.25 |  |  |  | 8 | 16 |  | 16 |  |  | 8 |  | 16 |  | 16 |  |  |  | 8 |  | 16 |  | 16 |  | 159.75
 | C.N.A Total |  |  | 8 |  |  |  | 8 | 15.5 |  | 8.25 |  |  |  | 8 | 16 |  | 16 |  |  | 8 |  | 16 |  | 16 |  |  |  | 8 |  | 16 |  | 16 |  | 159.75
[NAME] |  |  |  | 8 |  |  |  | 8 | 15.5 |  | 8.25 |  |  |  | 8 | 16 |  | 16 |  |  | 8 |  | 16 |  | 16 |  |  |  | 8 |  | 16 |  | 16 |  | 159.75
[NAME] | C.N.A | 14 |  |  |  |  |  |  |  |  | 8 | 8 |  | 8 | 8 |  | 8 | 8 |  |  |  | 8 | 8 |  | 8 | 8 |  | 8 | 8 |  | 8 | 8 |  |  | 112
 | C.N.A Total |  |  |  |  |  |  |  |  |  | 8 | 8 |  | 8 | 8 |  | 8 | 8 |  |  |  | 8 | 8 |  | 8 | 8 |  | 8 | 8 |  | 8 | 8 |  |  | 112
[NAME] |  |  |  |  |  |  |  |  |  |  | 8 | 8 |  | 8 | 8 |  | 8 | 8 |  |  |  | 8 | 8 |  | 8 | 8 |  | 8 | 8 |  | 8 | 8 |  |  | 112
[NAME] | C.N.A | 14 |  | 7.75 | 11.5 | 7.5 | 6 |  | 7.75 |  | 7.5 | 7.5 | 7.5 |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 |  | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 |  | 175
 |  | 21 |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 | C.N.A Total |  |  | 7.75 | 11.5 | 7.5 | 6 | 5 | 7.75 |  | 7.5 | 7.5 | 7.5 |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 |  | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 |  | 180
[NAME] |  |  |  | 7.75 | 11.5 | 7.5 | 6 | 5 | 7.75 |  | 7.5 | 7.5 | 7.5 |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 |  | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 |  | 180
[NAME] | LPN | 24 |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  | 8 | 8 |  |  |  |  |  |  | 8 |  |  | 32
 | LPN Total |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  | 8 | 8 |  |  |  |  |  |  | 8 |  |  | 32
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  | 8 | 8 |  |  |  |  |  |  | 8 |  |  | 32
[NAME] | C.N.A | 13 |  | 15.5 |  | 8 |  |  | 15.5 |  | 8 |  |  |  |  | 16 |  | 16 |  |  |  |  | 16 |  | 16 |  |  |  |  | 16 |  | 16 |  |  | 143
 | C.N.A Total |  |  | 15.5 |  | 8 |  |  | 15.5 |  | 8 |  |  |  |  | 16 |  | 16 |  |  |  |  | 16 |  | 16 |  |  |  |  | 16 |  | 16 |  |  | 143
[NAME] |  |  |  | 15.5 |  | 8 |  |  | 15.5 |  | 8 |  |  |  |  | 16 |  | 16 |  |  |  |  | 16 |  | 16 |  |  |  |  | 16 |  | 16 |  |  | 143
[NAME] | C.N.A | 14 |  |  |  | 15.5 |  |  | 8 |  | 8 |  |  |  |  | 8 | 8 | 8 |  | 8 |  |  | 8 | 8 | 8 |  |  |  |  | 8 |  |  |  |  | 95.5
 | C.N.A Total |  |  |  |  | 15.5 |  |  | 8 |  | 8 |  |  |  |  | 8 | 8 | 8 |  | 8 |  |  | 8 | 8 | 8 |  |  |  |  | 8 |  |  |  |  | 95.5
[NAME] |  |  |  |  |  | 15.5 |  |  | 8 |  | 8 |  |  |  |  | 8 | 8 | 8 |  | 8 |  |  | 8 | 8 | 8 |  |  |  |  | 8 |  |  |  |  | 95.5
[NAME] | RN | 28 |  |  |  |  |  |  | 8 |  | 7 |  |  |  |  |  |  | 8 |  |  |  |  | 8 |  | 8 |  |  |  |  | 8 |  | 8 |  |  | 55
 | RN Total |  |  |  |  |  |  |  | 8 |  | 7 |  |  |  |  |  |  | 8 |  |  |  |  | 8 |  | 8 |  |  |  |  | 8 |  | 8 |  |  | 55
Payge Sofranko Total |  |  |  |  |  |  |  |  | 8 |  | 7 |  |  |  |  |  |  | 8 |  |  |  |  | 8 |  | 8 |  |  |  |  | 8 |  | 8 |  |  | 55
[NAME] | C.N.A | 14 |  |  |  |  |  | 8 |  |  | 8 | 8 |  |  |  |  |  | 8 | 8 |  | 8 |  |  |  |  |  |  |  | 8 |  |  |  |  |  | 56
 | C.N.A Total |  |  |  |  |  |  | 8 |  |  | 8 | 8 |  |  |  |  |  | 8 | 8 |  | 8 |  |  |  |  |  |  |  | 8 |  |  |  |  |  | 56
[NAME] |  |  |  |  |  |  |  | 8 |  |  | 8 | 8 |  |  |  |  |  | 8 | 8 |  | 8 |  |  |  |  |  |  |  | 8 |  |  |  |  |  | 56
[NAME] | C.N.A | 14 |  |  |  |  |  | 8 |  |  |  |  |  |  | 8 |  |  |  |  |  |  | 8 |  |  |  |  |  |  | 8 |  |  |  |  |  | 32
 | C.N.A Total |  |  |  |  |  |  | 8 |  |  |  |  |  |  | 8 |  |  |  |  |  |  | 8 |  |  |  |  |  |  | 8 |  |  |  |  |  | 32
[NAME] |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  | 8 |  |  |  |  |  |  | 8 |  |  |  |  |  |  | 8 |  |  |  |  |  | 32
[NAME] | C.N.A | 12.5 |  |  |  | 15.5 | 8 |  |  |  |  |  | 15.5 | 16 |  |  |  |  |  | 16 | 16 |  |  |  |  |  | 16 | 16 |  |  |  |  |  |  | 119
 |  | 18.75 |  |  |  |  | 7.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.25
 | C.N.A Total |  |  |  |  | 15.5 | 15.25 |  |  |  |  |  | 15.5 | 16 |  |  |  |  |  | 16 | 16 |  |  |  |  |  | 16 | 16 |  |  |  |  |  |  | 126.25
[NAME] |  |  |  |  |  | 15.5 | 15.25 |  |  |  |  |  | 15.5 | 16 |  |  |  |  |  | 16 | 16 |  |  |  |  |  | 16 | 16 |  |  |  |  |  |  | 126.25
[NAME] | C.N.A | 12.5
 |  | 12.75 |  | 7.75 | 12.5 |  |  | 8 |  |  |  | 13 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 |  | 193.25
 |  | 19 |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | C.N.A Total |  |  | 7.75 | 15.5 |  |  | 8 |  |  |  | 13 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 |  | 196.25
Shanice Franklin Total |  |  |  | 7.75 | 15.5 |  |  | 8 |  |  |  | 13 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 |  | 196.25
[NAME] | C.N.A | 12 |  |  |  |  |  | 8 | 8 |  |  |  |  | 8 | 8 |  |  |  | 8 |  | 8 | 8 | 8 |  |  | 8 | 8 |  | 8 | 8 |  |  | 8 |  | 104
 |  | 18
 | C.N.A Total |  |  |  |  |  |  | 8 | 8 |  |  |  |  | 8 | 8 |  |  |  | 8 |  | 8 | 8 | 8 |  |  | 8 | 8 |  | 8 | 8 |  |  | 8 |  | 104
Shawnya McMasters Total |  |  |  |  |  |  |  | 8 | 8 |  |  |  |  | 8 | 8 |  |  |  | 8 |  | 8 | 8 | 8 |  |  | 8 | 8 |  | 8 | 8 |  |  | 8 |  | 104
[NAME] | C.N.A | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  | 8
 | C.N.A Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  | 8
[NAME] Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  | 8
(blank) | (blank) | (blank)
 | (blank) Total
(blank) Total
Grand Total |  |  | 8 | 71 | 35.5 | 63 | 44.75 | 69.25 | 82.5 |  | 77.25 | 52.75 | 39 | 80 | 80 | 80 | 84 | 120 | 56 | 48 | 56 | 72 | 108 | 64 | 116 | 56 | 56 | 52 | 72 | 84 | 64 | 96 | 64 |  | 2051