Spreadsheet: 121342d1316004943-excel-2007-vlookup-with-the-option-of-manual-entry-work-in-progress
Sheet: Sheet1

 | WK 1 | WK 2
 |  |  |  |  |  | 01/09/2011 |  |  |  |  | Rota for period |  |  |  |  |  |  |  |  |  | to
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EMPLOYEES | CONTRACTED HOURS | COMMENTS |  | SHIFTS |  |  |  |  |  |  | CLIENTS | ACTIVITIES |  | [NAME] |  | Back
 |  |  | P | REST |  | T/OWED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 39 |  | A | A |  |  | 0 |  |  |  | STEVEN | SWIM |  | 1 | Sun | 1
 |  |  | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 39 |  | E | EARLY | 08:00:00 | 15:30:00 | 7.5 |  |  |  | ADAM | SHOP |  | 2 | Mon | 0
 |  |  | P | SICKNESS | 0 | SICKNESS | 1 | REST |  | LEAVE |  | REST |  | REST |  | REST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 37.5 |  | M | MID |  |  | 0 |  |  |  | CHRIS | TRIP |  | 3 | Tue | 0
 |  |  | A | CHRIS | SHOP |  |  | STEVEN | MEDICAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 37.5 |  | L | LATE | 14:30:00 | 22:00:00 | 7.5 |  |  |  | IAN | HOL |  | 4 | Wed | 0
 |  |  | P |  | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 37.5 |  | LS | L/SLEEP | 14:30:00 | 22:00:00 | 7.5 | Includes Fixed Price Sleepover |  |  | HARRY | MEDICAL |  | 5 | Thu | 0
 |  |  | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] cope | 37.5 |  | D | DAY | 09:00:00 | 16:30:00 | 7.5 |  |  |  | FRED | Other 1 |  | 6 | Fri | 0
 |  |  | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 22.5 |  | T | TRAINING |  |  | 7.5 |  |  |  |  | Other 2 |  | 7 | Sat | 1
 |  |  | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 22.5 |  | SK | SICKNESS |  |  | 0 |  |  |  |  | Other 3
 |  |  | P |  | 39 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 39 |  | TO | T/OWED |  |  | 0 |  |  |  |  | Other 4 |  | MONTHS
 |  |  | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 37.5 |  | OD | REST |  |  | 0 |  |  |  |  | Other 5 |  | 1 | Jan
 |  |  | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 37.5 |  | AL | LEAVE |  |  | 0 |  |  |  |  |  |  | 2 | Feb
 |  |  | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 37.5 |  | * | OTHER |  |  | 0 |  |  |  |  |  |  | 3 | Mar
 |  |  | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Carley Everitt | 39 |  |  |  |  |  | 0 |  |  |  |  |  |  | 4 | Apr
 |  |  | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Relief |  |  |  |  |  |  |  |  |  |  |  | 5 | May
 |  |  | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | Jun
 |  |  | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nicol Freeth |  | Relief |  |  |  |  |  |  |  |  |  |  |  | 7 | Jul
 |  |  | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 8 | Aug
 |  |  | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | Sep
 |  |  | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Spare Shifts |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | Oct
 |  |  | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | Nov
 |  |  | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | Dec
 |  |  | A
 |  |  | P
 |  |  | A
 |  |  | P
 |  |  | A
 |  |  | P
 |  |  | A
 |  |  | P
 |  |  | A
 |  |  | P
 |  |  | A
 |  |  | P | EARLY
 |  |  | A
 |  |  | P
 |  |  | A
 |  |  |  | Any Changes Please Consult |  |  |  |  | [NAME] or [NAME]