Spreadsheet: 58254d1258544968-summing-numeric-parts-of-alphanumeric-strings-test-book-for-help
Sheet: January 2010

2009  Duke Urgent Care Clinician Schedule
m=7a-7:30p, e=5p-11p | 2009-12-28 00:00:00 |  |  |  |  |  | 2009-12-29 00:00:00 |  |  |  |  |  | 2009-12-30 00:00:00 |  |  |  |  |  | 2009-12-31 00:00:00 |  |  |  |  |  | 2010-01-01 00:00:00 |  |  |  |  |  | 2010-01-02 00:00:00 |  |  |  |  |  | 2010-01-03 00:00:00
d=8:30a-9p, x=8a-8:30p | Monday |  |  |  |  |  | Tuesday |  |  |  |  |  | Wednesday |  |  |  |  |  | Thursday |  |  |  |  |  | Friday |  |  |  |  |  | Saturday |  |  |  |  |  | Sunday
a = admin 8h, c=cme 8h | H | S | M | K | BC |  | H | S | M | K | BC |  | H | S | M | K | BC |  | H | S | M | K | BC |  | H | S | M | K | BC |  | H | S | M | K | BC |  | H | S | M | K | BC |  | Hours | PTO | CME | [NAME] | Total | Wknd | Eve
P=PTO 8h, # = #h |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Physician
person 1 | x |  |  |  |  |  | a |  |  |  |  |  | a |  |  |  |  |  | a |  |  |  |  |  | p |  |  |  |  |  | e |  |  |  |  |  | r |  |  |  |  | person 1 | 18.5 | 8 | 0 | 24 | 50.5 | 6 | 6
person 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | p |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | person 2 | 0 | 8 | 0 | 0 | 8 | 0 | 0
person 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | person 3 | 12.5 | 0 | 0 | 0 | 12.5 | 0 | 0
person 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | p |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | person 4 | 0 | 8 | 0 | 0 | 8 | 0 | 0
person 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | person 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0
person 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | person 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0
person 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | r |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  | person 7 | 25 | 0 | 0 | 0 | 25 | 25 | 0
person 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | person 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
person 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | person 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0
person 13 |  |  |  |  |  |  |  |  |  |  |  |  | a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | person 13 | 0 | 0 | 0 | 8 | 8 | 0 | 0
person 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  | person 14 | 25 | 0 | 0 | 0 | 25 | 12.5 | 0
person 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  | person 15 | 37.5 | 0 | 0 | 0 | 37.5 | 25 | 0
person 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d |  |  |  |  |  | d |  |  |  |  |  | d |  |  |  | person 16 | 37.5 | 0 | 0 | 0 | 37.5 | 25 | 0
person 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | p |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | person 17 | 0 | 8 | 0 | 0 | 8 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
person 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | person 19 | 0 | 0 | 0 | 0 | 0 | 0 | 0
person 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | r |  |  |  |  |  | r |  |  |  |  |  | r |  |  |  |  | person 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0
person 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | person 21 | 0 | 0 | 0 | 0 | 0 | 0 | 0
person 22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  | person 22 | 25 | 0 | 0 | 0 | 25 | 12.5 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 0 | 0
person 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  | person 24 | 12.5 | 0 | 0 | 0 | 12.5 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
person 26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  | x |  |  | person 26 | 25 | 0 | 0 | 0 | 25 | 25 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  | 37.5 | 0 | 0 | 0 | 37.5 | 25 | 0
person 28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | person 28 | 0 | 0 | 0 | 0 | 0 | 0 | 0
person 29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  | m |  |  |  |  |  | m |  |  |  | person 29 | 37.5 | 0 | 0 | 0 | 37.5 | 25 | 0
person 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  | x |  | person 30 | 25 | 0 | 0 | 0 | 25 | 25 | 0