Spreadsheet: 138839d1327940154-advancing-arrays-based-on-value-shedule_example-modified-by-tigeravatar-
Sheet: NOV-JAN

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-30 00:00:00
 | January |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | February |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | March
 | 2012-01-09 00:00:00 | 2012-01-10 00:00:00 | 2012-01-11 00:00:00 | 2012-01-12 00:00:00 | 2012-01-13 00:00:00 | 2012-01-14 00:00:00 | 2012-01-15 00:00:00 | 2012-01-16 00:00:00 | 2012-01-17 00:00:00 | 2012-01-18 00:00:00 | 2012-01-19 00:00:00 | 2012-01-20 00:00:00 | 2012-01-21 00:00:00 | 2012-01-22 00:00:00 | 2012-01-23 00:00:00 | 2012-01-24 00:00:00 | 2012-01-25 00:00:00 | 2012-01-26 00:00:00 | 2012-01-27 00:00:00 | 2012-01-28 00:00:00 | 2012-01-29 00:00:00 | 2012-01-30 00:00:00 | 2012-01-31 00:00:00 | 2012-02-01 00:00:00 | 2012-02-02 00:00:00 | 2012-02-03 00:00:00 | 2012-02-04 00:00:00 | 2012-02-05 00:00:00 | 2012-02-06 00:00:00 | 2012-02-07 00:00:00 | 2012-02-08 00:00:00 | 2012-02-09 00:00:00 | 2012-02-10 00:00:00 | 2012-02-11 00:00:00 | 2012-02-12 00:00:00 | 2012-02-13 00:00:00 | 2012-02-14 00:00:00 | 2012-02-15 00:00:00 | 2012-02-16 00:00:00 | 2012-02-17 00:00:00 | 2012-02-18 00:00:00 | 2012-02-19 00:00:00 | 2012-02-20 00:00:00 | 2012-02-21 00:00:00 | 2012-02-22 00:00:00 | 2012-02-23 00:00:00 | 2012-02-24 00:00:00 | 2012-02-25 00:00:00 | 2012-02-26 00:00:00 | 2012-02-27 00:00:00 | 2012-02-28 00:00:00 | 2012-02-29 00:00:00 | 2012-03-01 00:00:00 | 2012-03-02 00:00:00 | 2012-03-03 00:00:00 | 2012-03-04 00:00:00
 | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S
 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 1 | 2 | 3 | 4
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56
Location 1
Person 1 | OL | 8 | 11 | 16 | 16 |  |  |  | 8 | 8 | 11 | 16 | 16 |  |  |  | 8 | 8 | 11 | 16 | 16 |  |  |  | 8 | 8 | 11 | 16 | 16 |  |  |  | 8 | 8 | 11 | 16 | 16 |  |  |  | 8 | 8 | 11 | 16 | 16 |  |  |  | 8 | 8 | 11 | 16 | 16 |  |  |  | Person 1
Person 2 |  | 8 | 8 | 8/S | 16 | 16 |  |  |  | 8 | 8 | 8/S | 16 | 16 |  |  |  | 8 | 8 | 8/S | 16 | 16 |  |  |  | 8 | 8 | 8/S | 16 | 16 |  |  |  | 8 | 8 | 8/S | 16 | 16 |  |  |  | 8 | 8 | 8/S | 16 | 16 |  |  |  | 8 | 8 | 8/S | 16 | 16 |  |  | Person 2
Person 3 |  |  | 8 | 8 | 8/S | 16 | 16 |  |  |  | 8 | 8 | 8/S | 16 | 16 |  |  |  | 8 | 8 | 8/S | 16 | 16 |  |  |  | 8 | 8 | 8/S | 16 | 16 |  |  |  | 8 | 8 | 8/S | 16 | 16 |  |  |  | 8 | 8 | 8/S | 16 | 16 |  |  |  | 8 | 8 | 8/S | 16 | 16 |  | Person 3
Person 4 |  |  |  | 8 | 8 | 8/S | 16 | 16 |  |  |  |  | V | V | V | V |  |  |  | 8 | 8 | 8/S | 16 | 16 |  |  |  | 8 | 8 | 8/M | 16 | 16 | 16 |  |  | 8 | 8 | 8/S | 16 | 16 |  |  |  | 8 | 8 | 8/S | 16 | 16 |  |  |  | 8 | 8 | 8/S | 16 | 16 | Person 4
Person 5 | 16 |  |  |  | 8 | 8 | 8/S | 16 | 16 |  |  | 8 | 8 | 8 | 11 | 16 | 16 |  |  |  | V | 8 | 8/S | 16 | 16 |  |  |  | 8 | 8 | 8/S | V |  |  |  |  | 8 | 8 | 8/S | 16 | 16 |  |  |  | 8 | 8 | 8/S | 16 | 16 |  |  |  | 8 | 8 | 8/S | 16 | Person 5
Person 6 | 16 | 16 |  |  |  | OL | OL | OL | OL | OL |  |  |  | 8 | 8 | 11 | 16 | 16 |  |  |  | 8 | 8 | 8/S | 16 | 16 |  |  |  | V | 8 | 11 | 16 | 16 |  |  |  | 8 | 8 | 8/S | 16 | 16 |  |  |  | 8 | 8 | 8/S | 16 | 16 |  |  |  | 8 | 8 | 8/S | Person 6
Person 7 | 11 | 16 | 16 |  |  |  | 8 | 8 | 11 | 16 | 16 |  |  |  | 8 | 8 | 11 | 16 | 16 |  |  |  | 8 | 8 | 11 | 16 | 16 |  |  |  | 8 | 8 | 11 | 16 | 16 |  |  |  | 8 | 8 | 11 | 16 | 16 |  |  |  | 8 | 8 | 11 | 16 | 16 |  |  |  | 8 | 8 | Person 7
Person 8 | 8 | 8/S | 16 | 16 |  |  |  | 8 | 8 | 11 | 16 | 16 |  |  |  | 8 | 8 | 11 | 16 | 16 |  |  |  | 8 | 8 | 11 | 16 | 16 |  |  |  | 8 | 8 | 11 | 16 | 16 |  |  |  | 8 | 8 | 8/S | 16 | 16 |  |  |  | 8 | 8 | 11 | 16 | 16 |  |  |  | 8 | Person 8
Person 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | Person 9
Location 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Location 2
Person 10 | 9 |  |  | S | 9 | 9 | 9 | 9 | 9 | 9 | 9 |  |  |  |  | 9 | 9 | V | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 |  |  |  |  | 9 | 9 | 9 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 |  |  |  | Person 10
Person 11 |  | 9 | 9 | 9 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 |  |  |  |  | 9 | 9 | 9 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 |  |  |  |  | 9 | 9 | 9 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | Person 11
Person 12 | 9 | 9 | 9 | 9 |  |  |  |  | 9 | 9 | 9 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 |  |  |  |  | V | 9 | 9 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 |  |  |  |  | 9 | 9 | 9 | 9 | 9 | 9 | Person 12
 |  |  |  |  |  |  | 12 | 24 | 26 | 34
8 | #N/A
 | #N/A
 | #N/A
8/S
11
16
9