Spreadsheet: 100265d1298658530-excel-2007-excel-crashes-when-i-re-calculate-f9-workbook-worksheet-sample
Sheet: Sheet1

2011-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | WEEK 1 |  |  |  |  |  |  | WEEK 2 |  |  |  |  |  |  | WEEK 3 |  |  |  |  |  |  | WEEK 4
STAF NAME | TDW | Late | MC | NO SHOW | EL | AL | CL | [NAME] | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN
 |  |  |  |  |  |  |  |  | 2011-01-01 00:00:00 | 2011-01-02 00:00:00 | 2011-01-03 00:00:00 | 2011-01-04 00:00:00 | 2011-01-05 00:00:00 | 2011-01-06 00:00:00 | 2011-01-07 00:00:00 | 2011-01-08 00:00:00 | 2011-01-09 00:00:00 | 2011-01-10 00:00:00 | 2011-01-11 00:00:00 | 2011-01-12 00:00:00 | 2011-01-13 00:00:00 | 2011-01-14 00:00:00 | 2011-01-15 00:00:00 | 2011-01-16 00:00:00 | 2011-01-17 00:00:00 | 2011-01-18 00:00:00 | 2011-01-19 00:00:00 | 2011-01-20 00:00:00 | 2011-01-21 00:00:00 | 2011-01-22 00:00:00 | 2011-01-23 00:00:00 | 2011-01-24 00:00:00 | 2011-01-25 00:00:00 | 2011-01-26 00:00:00 | 2011-01-27 00:00:00 | 2011-01-28 00:00:00 | 2011-01-29 00:00:00 | 2011-01-30 00:00:00
A |  |  |  |  |  |  |  |  | 12:00:00 | 12:00:00 | 12:00:00 | X | MC | 14:00:00 | MC | MC | X | X | 09:00:00 | 09:00:00 | MC | X | AL | AL | X | 13:00:00 | 13:00:00 | 13:00:00 | 13:00:00 | 13:00:00 | X | 03:00:00 | MC | 03:00:00 | 03:00:00 | X | X | AL
B |  |  |  |  |  |  |  |  | X | X | AL | 10:00:00 | 07:00:00 | 07:00:00 | X | X | 00:00:00 | 00:00:00 | 00:00:00 | X | 06:00:00 | 06:00:00 | 06:00:00 | X | 06:00:00 | 06:00:00 | 06:00:00 | 06:00:00 | X | X | 14:00:00 | 07:00:00 | MC | MC | 07:00:00 | X | X | 11:00:00
C |  |  |  |  |  |  |  |  | X | 00:00:00 | 00:00:00 | X | 01:00:00 | 01:00:00 | 01:00:00 | X | 08:00:00 | 08:00:00 | 08:00:00 | MC | X | X | 11:00:00 | 11:00:00 | 11:00:00 | X | 03:00:00 | 03:00:00 | 03:00:00 | X | 15:00:00 | MC | X | X | 08:00:00 | 08:00:00 | 08:00:00 | 07:00:00
D |  |  |  |  |  |  |  |  | X | X | AL | 11:00:00 | 11:00:00 | 06:00:00 | X | X | 00:00:00 | 00:00:00 | 00:00:00 | X | MC | 06:00:00 | 06:00:00 | X | MC | 06:00:00 | 06:00:00 | X | 07:00:00 | 07:00:00 | X | 14:00:00 | 07:00:00 | 00:00:00 | AL | AL | X | X
E |  |  |  |  |  |  |  |  | X | X | Late | MC | Late | MC | X | X | 13:00:00 | 15:00:00 | X | 07:00:00 | 07:00:00 | 06:00:00 | 06:00:00 | X | X | 00:00:00 | MC | MC | 00:00:00 | 00:00:00 | X | X | MC | MC | MC | 13:00:00 | 13:00:00 | X
F |  |  |  |  |  |  |  |  | X | X | MC | 06:00:00 | MC | Late | X | X | 08:30:00 | X | X | Late | Late | Late | MC | Late | Late | X | X | Late | Late | Late | Late | X | EL | 15:00:00 | 15:00:00 | AL | AL | X
G |  |  |  |  |  |  |  |  | AL | AL | AL | 13:00:00 | 13:00:00 | X | X | 07:00:00 | MC | 07:00:00 | X | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | X | X | 15:00:00 | 07:00:00 | PHIL | PHIL | PHIL | X | X | X | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
H |  |  |  |  |  |  |  |  | X | X | Late | MC | X | X | 00:00:00 | MC | 00:00:00 | 00:00:00 | X | 14:00:00 | 14:00:00 | 14:00:00 | Late | X | X | Late | Late | Late | Late | Late | X | HMC | MC | X | X | Late | 15:00:00 | 15:00:00
I |  |  |  |  |  |  |  |  | 11:00:00 | X | X | 07:00:00 | 07:00:00 | 08:00:00 | 08:30:00 | 08:30:00 | X | X | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | X | X | X | AL | AL | AL | AL | AL | X | 15:00:00 | 15:00:00 | 15:00:00 | Late | X | 10:00:00
J |  |  |  |  |  |  |  |  | X | X | 08:00:00 | 08:00:00 | 12:00:00 | 12:00:00 | X | X | 14:00:00 | 14:00:00 | 14:00:00 | 14:00:00 | X | X | AL | AL | X | 15:00:00 | 15:00:00 | 15:00:00 | 15:00:00 | 15:00:00 | X | X | 00:00:00 | 01:00:00 | 00:00:00 | 00:00:00 | X | 08:00:00
 |  |  |  |  |  |  |  | No. of staffs scheduled | 7 | 10 | 7 | 10 | 10
 |  |  |  |  |  |  |  | Absent
 |  |  |  |  |  |  |  | No. of staffs present | 7 |  | 7
NAME | TWD | Late | MC | NO SHOW | EL | EL / AL | CL | [NAME] | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN
 |  |  |  |  |  |  |  |  | 2011-01-01 00:00:00 | 2011-01-02 00:00:00 | 2011-01-03 00:00:00 | 2011-01-04 00:00:00 | 2011-01-05 00:00:00 | 2011-01-06 00:00:00 | 2011-01-07 00:00:00 | 2011-01-08 00:00:00 | 2011-01-09 00:00:00 | 2011-01-10 00:00:00 | 2011-01-11 00:00:00 | 2011-01-12 00:00:00 | 2011-01-13 00:00:00 | 2011-01-14 00:00:00 | 2011-01-15 00:00:00 | 2011-01-16 00:00:00 | 2011-01-17 00:00:00 | 2011-01-18 00:00:00 | 2011-01-19 00:00:00 | 2011-01-20 00:00:00 | 2011-01-21 00:00:00 | 2011-01-22 00:00:00 | 2011-01-23 00:00:00 | 2011-01-24 00:00:00 | 2011-01-25 00:00:00 | 2011-01-26 00:00:00 | 2011-01-27 00:00:00 | 2011-01-28 00:00:00 | 2011-01-29 00:00:00 | 2011-01-30 00:00:00
AAMM
2011-02-01 00:00:00 |  |  |  |  |  |  |  |  | WEEK 1 |  |  |  |  |  |  | WEEK 2 |  |  |  |  |  |  | WEEK 3 |  |  |  |  |  |  | WEEK 4
NAME | TDW | Late | MC | NCNS | EL | AL | CL | [NAME] | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN
 |  |  |  |  |  |  |  |  | 2011-01-31 00:00:00 | 2011-02-01 00:00:00 | 2011-02-02 00:00:00 | 2011-02-03 00:00:00 | 2011-02-04 00:00:00 | 2011-02-05 00:00:00 | 2011-02-06 00:00:00 | 2011-02-07 00:00:00 | 2011-02-08 00:00:00 | 2011-02-09 00:00:00 | 2011-02-10 00:00:00 | 2011-02-11 00:00:00 | 2011-02-12 00:00:00 | 2011-02-13 00:00:00 | 2011-02-14 00:00:00 | 2011-02-15 00:00:00 | 2011-02-16 00:00:00 | 2011-02-17 00:00:00 | 2011-02-18 00:00:00 | 2011-02-19 00:00:00 | 2011-02-20 00:00:00 | 2011-02-21 00:00:00 | 2011-02-22 00:00:00 | 2011-02-23 00:00:00 | 2011-02-24 00:00:00 | 2011-02-25 00:00:00 | 2011-02-26 00:00:00 | 2011-02-27 00:00:00
A |  |  |  |  |  |  |  |  | 11:00:00 | 11:00:00 | 11:00:00 | X | X | X | PHIL | PHIL | X | MC | Late | 08:00:00 | AL | X | 03:00:00 | X | MC | 15:00:00 | 15:00:00 | 15:00:00 | X | 22:00:00 | 22:00:00 | X | 08:00:00 | 15:00:00 | 15:00:00 | 15:00:00
B |  |  |  |  |  |  |  |  | 15:00:00 | X | 07:00:00 | 07:00:00 | 11:00:00 | 07:00:00 | X | 01:00:00 | 01:00:00 | 01:00:00 | X | X | 08:30:00 | 08:30:00 | 08:30:00 | 08:30:00 | X | 06:00:00 | 06:00:00 | 06:00:00 | X | X | 08:30:00 | 08:30:00 | 08:30:00 | 08:30:00 | X | 10:00:00
C |  |  |  |  |  |  |  |  | X | 09:00:00 | 09:00:00 | X | PHIL | PHIL | X | 07:00:00 | MC | MC | 07:00:00 | 07:00:00 | X | 15:00:00 | 15:00:00 | MC | 15:00:00 | X | 15:00:00 | 15:00:00 | X | 21:00:00 | 21:00:00 | 21:00:00 | 21:00:00 | 21:00:00 | X | X
D |  |  |  |  |  |  |  |  | X | 06:00:00 | NCNS | 06:00:00 | 06:00:00 | 06:00:00 | X | MC | 01:00:00 | 01:00:00 | X | X | 08:00:00 | 08:00:00 | 08:00:00 | Late | X | EL | 06:00:00 | 06:00:00 | 06:00:00 | X | X | 13:00:00 | 13:00:00 | 13:00:00 | X | 10:00:00
E |  |  |  |  |  |  |  |  | MC | 08:00:00 | X | EL | 23:00:00 | 23:00:00 | X | MC | MC | X | X | MC | MC | 07:00:00 | 07:00:00 | Late | X | X | Late | MC | MC | MC | MC | X | 07:00:00 | 07:00:00 | 07:00:00 | X
F |  |  |  |  |  |  |  |  | MC | 09:00:00 | X | 06:00:00 | 14:00:00 | X | MC | 07:00:00 | MC | X | Late | 23:00:00 | MC | 23:00:00 | 23:00:00 | X | X | Late | 11:00:00 | AL | AL | X | 07:00:00 | 07:00:00 | 07:00:00 | 07:00:00 | X | X
G |  |  |  |  |  |  |  |  | MC | MC | MC | MC | MC | X | X | 07:00:00 | 07:00:00 | 07:00:00 | 07:00:00 | 07:00:00 | X | X | 06:00:00 | Late | 06:00:00 | 01:00:00 | 01:00:00 | X | X | X | X | 00:00:00 | 00:00:00 | 00:00:00 | PHIL | PHIL
H |  |  |  |  |  |  |  |  | HMC | X | 09:00:00 | MC | 09:00:00 | X | MC | MC | X | Late' | Late | HMC | Late | X | 00:00:00 | 00:00:00 | MC | MC | 00:00:00 | X | 13:00:00 | 13:00:00 | 13:00:00 | 10:00:00 | X | X | 14:00:00 | X
I |  |  |  |  |  |  |  |  | 10:00:00 | X | 15:00:00 | MC | 13:00:00 | 13:00:00 | X | 08:00:00 | 08:00:00 | X | X | Late | Late | 12:00:00 | 12:00:00 | 12:00:00 | X | X | 22:00:00 | 22:00:00 | 22:00:00 | X | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 | X
J |  |  |  |  |  |  |  |  | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 | X | PHIL | PHIL | X | X | 11:00:00 | Late | MC | MC | X | 14:00:00 | MC | 07:00:00 | 07:00:00 | 07:00:00 | X | X | 03:00:00 | 03:00:00 | 03:00:00 | X | X | 07:00:00 | 07:00:00
 |  |  |  |  |  |  |  | No. of staffs scheduled
 |  |  |  |  |  |  |  | Absent
 |  |  |  |  |  |  |  | No. of staffs present
NAME | TWD | Late | MC | NO SHOW | EL | EL / AL | CL | [NAME] | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN
 |  |  |  |  |  |  |  |  | 2011-01-31 00:00:00 | 2011-02-01 00:00:00 | 2011-02-02 00:00:00 | 2011-02-03 00:00:00 | 2011-02-04 00:00:00 | 2011-02-05 00:00:00 | 2011-02-06 00:00:00 | 2011-02-07 00:00:00 | 2011-02-08 00:00:00 | 2011-02-09 00:00:00 | 2011-02-10 00:00:00 | 2011-02-11 00:00:00 | 2011-02-12 00:00:00 | 2011-02-13 00:00:00 | 2011-02-14 00:00:00 | 2011-02-15 00:00:00 | 2011-02-16 00:00:00 | 2011-02-17 00:00:00 | 2011-02-18 00:00:00 | 2011-02-19 00:00:00 | 2011-02-20 00:00:00 | 2011-02-21 00:00:00 | 2011-02-22 00:00:00 | 2011-02-23 00:00:00 | 2011-02-24 00:00:00 | 2011-02-25 00:00:00 | 2011-02-26 00:00:00 | 2011-02-27 00:00:00
AAMM