Spreadsheet: 289274d1389475998-solver-constraints-help-solver-problem
Sheet: Capt

Month | Priority | Leave Days | Mar | Apr |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JUN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JUL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OCT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Summer Totals
Day |  | Requested | 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 | 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 | 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 | 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
Date |  |  | 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 | 30 | 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 | 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 | 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 | 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 | 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 | 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
A | 2 | 15 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | L | L | L | L | L | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | L | L | L | L | L | F | F | F | L | L | L | L | L | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 |  | 118
B | 7 | 16 | GL | GL | GL | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | L | F | F | F | L | L | L | L | L | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | L | L | L | L | L | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | L | L | L | L | L | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 |  | 114
C | 1 | 15 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | L | L | L | L | L | F | F | F | L | L | L | L | L | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | L | L | L | L | L | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F |  | 120
D | 5 (W) | 19 | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | L | L | L | L | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | L | L | L | L | L | F | F | F | L | L | L | L | L | F | F | F | L | L | L | L | L | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F |  | 116
E | 4 | 15 | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | L | L | L | L | L | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | L | L | L | L | L | F | F | F | L | L | L | L | L | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F |  | 120
F | 6 | 5 | F | F | GL | GL | GL | GL | GL | F | F | F | GL | GL | GL | GL | GL | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | L | L | L | L | L | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 |  | 119
G | 3 | 15 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | L | L | L | L | L | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | L | L | L | L | L | F | F | F | L | L | L | L | L | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 |  | 118
Crews avail to work |  |  | 3 | 4 | 3 | 3 | 2 | 2 | 2 | 3 | 4 | 5 | 4 | 3 | 2 | 2 | 2 | 3 | 4 | 5 | 5 | 4 | 3 | 3 | 3 | 3 | 4 | 5 | 5 | 4 | 3 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 3 | 4 | 5 | 5 | 4 | 3 | 3 | 3 | 3 | 4 | 5 | 5 | 4 | 3 | 3 | 3 | 3 | 4 | 5 | 4 | 3 | 2 | 2 | 2 | 3 | 4 | 5 | 4 | 4 | 3 | 3 | 2 | 2 | 3 | 3 | 3 | 3 | 2 | 2 | 3 | 3 | 4 | 4 | 4 | 3 | 2 | 2 | 3 | 3 | 4 | 5 | 5 | 4 | 3 | 3 | 3 | 3 | 4 | 5 | 5 | 4 | 3 | 3 | 3 | 2 | 3 | 4 | 4 | 3 | 3 | 3 | 3 | 2 | 3 | 4 | 4 | 3 | 3 | 3 | 2 | 2 | 3 | 4 | 4 | 4 | 3 | 2 | 2 | 2 | 3 | 4 | 5 | 4 | 3 | 2 | 2 | 2 | 3 | 4 | 5 | 4 | 3 | 3 | 3 | 2 | 3 | 4 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 3 | 2 | 3 | 3 | 3 | 3 | 4 | 4 | 3 | 2 | 3 | 3 | 3 | 3 | 4 | 4 | 3 | 2 | 3 | 2 | 2 | 3 | 4 | 4 | 4 | 3 | 3 | 3 | 3 | 4 | 5 | 5 | 4 | 3 | 3 | 3 | 3 | 4 | 5 | 5 | 4 | 3 | 3 | 3 | 3 | 4 | 5 | 5 | 4 | 3 | 3 | 3 | 3 | 4 | 5 | 5 | 4 | 3 | 3 | 3 |  | 706
Crews on days off |  |  | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 |  | 561
Crews on leave |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 2 | 3 | 2 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 100
Crews Required |  |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 |  | 642
Guaranteed Leave
Requested Leave
 |  |  |  |  | This sheet has some basic formulas and conditional formatting for colour etc.
 |  |  |  |  | I will expand this down to maybe 200 rows. If I do this can I freeze Colyumn a,b and C (already done ),also colum HL to be always shown.
 |  |  |  |  | I would also like to be able to always show rows 14-17, meaning if I had a roster template of 200 names,
 |  |  |  |  | I could always see the relevant data at the bottom of the screen.
 |  |  |  |  | See bottom of spreadsheet for details.
 |  |  |  |  | Is it possible for excel to create the patterns based on the lists worksheet, by the roster pattern data?
Crews avail to work |  |  | 3 | 4 | 3 | 4 | 3 | 3 | 3 | 4 | 4 | 5 | 4 | 4 | 3 | 3 | 3 | 4 | 4 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 2 | 2 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 3 | 3 | 5 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 3 | 2 | 4 | 4 | 4 | 4 | 5 | 5 | 3 | 2 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 4 | 4 | 4 |  | 903
Crews on days off |  |  | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 |  | 561
Crews on leave |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 2 | 3 | 2 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 100
Crews Required |  |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 |  | 642
Guaranteed Leave
Requested Leave
 |  |  |  |  | This sheet has some basic formulas and conditional formatting for colour etc.