Spreadsheet: 70917d1271679276-pivot-table-data-summary-settings-april-schedule-2007_test4pivota
Sheet: Humbert 

Date | Day | License | Nurse | Shift Start | Shift End | Total Hours | Short Notice | Billing Rate | Total Billed | Pay Rate | Total Paid | Difference | [NAME] | Expenses
2010-04-01 00:00:00 | Thursday | LPN | [NAME] | 7a | 3p |  |  | 40 | 0 | 19 | 0 | 0 | 21
2010-04-01 00:00:00 | Thursday | LPN | Shawntay Truly | 11p | 7a |  |  | 40 | 0 | 20 | 0 | 0 | 20
2010-04-01 00:00:00 | Thursday | LPN | [NAME] | 11p | 7a | 8 |  | 40 | 320 | 19 | 152 | 168 | 21
2010-04-01 00:00:00 | Thursday | C.N.A | [NAME] | 11p | 7a |  |  | 25 | 0 | 13 | 0 | 0 | 12
2010-04-01 00:00:00 | Thursday | LPN | [NAME] | 11p | 7a | 8 |  | 40 | 320 | 22 | 176 | 144 | 18
2010-04-01 00:00:00 | Thursday | C.N.A | [NAME] | 3p | 11p |  |  | 25 | 0 | 14 | 0 | 0 | 11
2010-04-02 00:00:00 | Friday | LPN | Shawntay Truly | 11p | 7a | 8 |  | 40 | 320 | 20 | 160 | 160 | 20
2010-04-02 00:00:00 | Friday | LPN | [NAME] | 3P | 11p | 8 |  | 40 | 320 | 22 | 176 | 144 | 18
2010-04-02 00:00:00 | Friday | LPN | [NAME] | 7a | 3p | 8 |  | 40 | 320 | 19 | 152 | 168 | 21
2010-04-03 00:00:00 | Saturday | RN | [NAME] | 11p | 730a | 8.5 |  | 50 | 425 | 30 | 255 | 170 | 20
2010-04-03 00:00:00 | Saturday | LPN | [NAME] | 3p | 11p |  |  | 40 | 0 | 19 | 0 | 0 | 21
2010-04-03 00:00:00 | Sunday | LPN | [NAME] | 11p | 7a |  |  | 40 | 0 | 19 | 0 | 0 | 21
2010-04-04 00:00:00 | Sunday | LPN | [NAME] | 3p | 11p |  |  | 40 | 0 | 19 | 0 | 0 | 21
2010-04-04 00:00:00 | Sunday | LPN | [NAME] | 11p | 7a |  |  | 40 | 0 | 19 | 0 | 0 | 21
2010-04-04 00:00:00 | Sunday | C.N.A | [NAME] | 3p | 11p | 8 |  | 37.5 | 300 | 24 | 192 | 108 | 13.5
2010-04-04 00:00:00 | Sunday | LPN | [NAME] | 3p | 1130p | 8 |  | 60 | 480 | 33 | 264 | 216 | 27
2010-04-05 00:00:00 | Monday | C.N.A | [NAME] | 3p | 11p | 8 |  | 25 | 200 | 16 | 128 | 72 | 9
2010-04-05 00:00:00 | Monday | C.N.A | [NAME] | 3p | 11p | 8 |  | 25 | 200 | 14 | 112 | 88 | 11
2010-04-05 00:00:00 | Monday | C.N.A | [NAME] | 11p | 7a |  |  | 25 | 0 | 14 | 0 | 0 | 11
2010-04-05 00:00:00 | Monday | LPN | Shawntay Truly | 3p | 11p | 8 |  | 40 | 320 | 20 | 160 | 160 | 20
2010-04-06 00:00:00 | Tuesday | LPN | [NAME] | 11p | 7a |  |  | 40 | 0 | 22 | 0 | 0 | 18
2010-04-07 00:00:00 | Wednesday | LPN | Shawntay Truly | 3p | 11p |  |  | 40 | 0 | 20 | 0 | 0 | 20
2010-04-08 00:00:00 | Thursday | C.N.A | [NAME] | 3p | 11p | 8 |  | 25 | 200 | 16 | 128 | 72 | 9
2010-04-08 00:00:00 | Thursday | LPN | [NAME] | 11p | 7a |  |  | 40 | 0 | 22 | 0 | 0 | 18
2010-04-08 00:00:00 | Thursday | LPN | [NAME] | 7a | 3p | 8 |  | 40 | 320 | 22 | 176 | 144 | 18
2010-04-08 00:00:00 | Thursday | LPN | [NAME] | 3p | 11p | 8 |  | 40 | 320 | 22 | 176 | 144 | 18
2010-04-08 00:00:00 | Thursday | LPN | [NAME] | 3p | 11a |  |  | 40 | 0 | 19 | 0 | 0 | 21
2010-04-08 00:00:00 | Thursday | LPN | [NAME] | 7a | 3p | 8 |  | 40 | 320 | 22 | 176 | 144 | 18
2010-04-09 00:00:00 | Friday | LPN | [NAME] | 11a | 7a |  |  | 40 | 0 | 19 | 0 | 0 | 21
2010-04-10 00:00:00 | Saturday | LPN | [NAME] | 3p | 11a |  |  | 40 | 0 | 19 | 0 | 0 | 21
2010-04-10 00:00:00 | Saturday | LPN | [NAME] | 11a | 7a |  |  | 40 | 0 | 19 | 0 | 0 | 21
2010-04-10 00:00:00 | Saturday | LPN | [NAME] | 3p | 11p | 8 |  | 40 | 320 | 22 | 176 | 144 | 18
2010-04-10 00:00:00 | Saturday | RN | [NAME] | 9a | 11a |  |  | 0 | 0 | 7.25 | 0 | 0 | -7.25
2010-04-10 00:00:00 | Saturday | RN | [NAME] | 11a | 7p |  |  | 50 | 0 | 32 | 0 | 0 | 18
2010-04-11 00:00:00 | Sunday | LPN | [NAME] | 3p | 11p | 8 |  | 40 | 320 | 22 | 176 | 144 | 18
2010-04-11 00:00:00 | Sunday | LPN | [NAME] | 3p | 11a |  |  | 40 | 0 | 19 | 0 | 0 | 21
2010-04-11 00:00:00 | Sunday | C.N.A | [NAME] | 3p | 11p |  |  | 25 | 0 | 16 | 0 | 0 | 9
2010-04-11 00:00:00 | Sunday | LPN | Shawntay Truly | 3p | 11p |  |  | 40 | 0 | 20 | 0 | 0 | 20
2010-04-11 00:00:00 | Sunday | LPN | [NAME] | 11a | 7a |  |  | 40 | 0 | 19 | 0 | 0 | 21
2010-04-11 00:00:00 | Sunday | LPN | [NAME] | 7a | 3p |  |  | 40 | 0 | 22 | 0 | 0 | 18
2010-04-11 00:00:00 | Sunday | LPN | [NAME] | 3p | 11p |  |  | 40 | 0 | 22 | 0 | 0 | 18
2010-04-11 00:00:00 | Sunday | C.N.A | [NAME] | 11p | 7a |  |  | 25 | 0 | 13 | 0 | 0 | 12
2010-04-12 00:00:00 | Monday | LPN | [NAME] | 3p | 11a |  |  | 40 | 0 | 19 | 0 | 0 | 21
2010-04-12 00:00:00 | Monday | LPN | [NAME] | 11a | 7a |  |  | 40 | 0 | 19 | 0 | 0 | 21
2010-04-13 00:00:00 | Tuesday | C.N.A | [NAME] | 3p | 11p | 8 |  | 25 | 200 | 16 | 128 | 72 | 9
2010-04-13 00:00:00 | Tuesday | LPN | [NAME] | 3p | 11p |  |  | 40 | 0 | 22 | 0 | 0 | 18
2010-04-13 00:00:00 | Tuesday | LPN | [NAME] | 4p | 11p | 7 |  | 40 | 280 | 22 | 154 | 126 | 18
2010-04-13 00:00:00 | Tuesday | C.N.A | [NAME] | 11p | 7a | 8 |  | 25 | 200 | 12 | 96 | 104 | 13
2010-04-14 00:00:00 | Wednesday | C.N.A | [NAME] | 3p | 11p | 8 |  | 25 | 200 | 16 | 128 | 72 | 9
2010-04-14 00:00:00 | Wednesday | LPN | Virginia Chilzer | 6a | 7a | 1 |  | 0 | 0 | 7.25 | 7.25 | -7.25 | -7.25
2010-04-14 00:00:00 | Wednesday | LPN | Virginia Chilzer | 7a | 3p | 8 |  | 40 | 320 | 25 | 200 | 120 | 15
2010-04-15 00:00:00 | Thursday | C.N.A | [NAME] | 11p | 7a | 8 |  | 25 | 200 | 12 | 96 | 104 | 13
2010-04-16 00:00:00 | Friday | C.N.A | [NAME] | 11p | 7a | 8 |  | 25 | 200 | 14 | 112 | 88 | 11
2010-04-17 00:00:00 | Saturday | RN | [NAME] | 11p | 7a |  |  | 50 | 0 | 30 | 0 | 0 | 20
2010-04-17 00:00:00 | Saturday | C.N.A | [NAME] | 3p | 11p | 8 |  | 25 | 200 | 12 | 96 | 104 | 13
2010-04-17 00:00:00 | Saturday | LPN | [NAME] | 3p | 11p | 8 |  | 40 | 320 | 22 | 176 | 144 | 18
2010-04-18 00:00:00 | Sunday | C.N.A | [NAME] | 3p | 11p | 8 |  | 25 | 200 | 16 | 128 | 72 | 9
2010-04-18 00:00:00 | Sunday | C.N.A | [NAME] | 3p | 11p | 8 |  | 25 | 200 | 12 | 96 | 104 | 13
2010-04-18 00:00:00 | Sunday | C.N.A | [NAME] | 3p | 11p | 8 |  | 25 | 200 | 14 | 112 | 88 | 11
2010-04-18 00:00:00 | Sunday | LPN | [NAME] | 7a | 3p | 8 |  | 40 | 320 | 22 | 176 | 144 | 18
2010-04-18 00:00:00 | Sunday | LPN | [NAME] | 3p | 11p | 8 |  | 40 | 320 | 22 | 176 | 144 | 18
2010-04-19 00:00:00 | Monday | C.N.A | [NAME] | 3p | 11p | 8 |  | 25 | 200 | 16 | 128 | 72 | 9
2010-04-19 00:00:00 | Monday | C.N.A | [NAME] | 11p | 7a | 8 |  | 25 | 200 | 16 | 128 | 72 | 9
2010-04-19 00:00:00 | Monday | LPN | [NAME] | 3p | 11p | 8 |  | 40 | 320 | 22 | 176 | 144 | 18
2010-04-19 00:00:00 | Monday | LPN | [NAME] | 7a | 3p | 8 |  | 40 | 320 | 22 | 176 | 144 | 18
2010-04-19 00:00:00 | Monday | LPN | [NAME] | 3p | 11p | 8 |  | 40 | 320 | 22 | 176 | 144 | 18
2010-04-20 00:00:00 | Tuesday |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0
2010-04-21 00:00:00 | Wednesday |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0
2010-04-22 00:00:00 | Thursday |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0
2010-04-23 00:00:00 | Friday |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0
2010-04-24 00:00:00 | Saturday | RN | [NAME] | 11p | 7a |  |  | 50 | 0 | 30 | 0 | 0 | 20
2010-04-25 00:00:00 | Sunday |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0
2010-04-26 00:00:00 | Monday |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0
2010-04-27 00:00:00 | Tuesday |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0
2010-04-28 00:00:00 | Wednesday |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0
2010-04-29 00:00:00 | Thursday |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0
2010-04-30 00:00:00 | Friday |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0