Spreadsheet: 289065d1389383711-how-to-create-a-staff-roster-how-far-can-i-go-roster-program
Sheet: FO

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 (W) | 15 | F | F | 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 | 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 |  | 119
B | 1 | 15 | F | 1 | 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 | 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 |  | 121
C | 3 | 12 | 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 | 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 | 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 |  | 122
D | 4 | 18 | 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 | L | L | 1 | 1 | F | F | F | L | L | L | 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 | 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 | 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 | 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 |  | 115
E | 5 | 15 | 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 | L | L | F | F | F | L | L | L | L | L | F | F | F | L | L | L | 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 | L | L | F | F | F | 1 | 1 | 1 | L | L | F | F | F | L | 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 |  | 118
F | 6 | 10 | 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 | 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 |  | 124
Crews avail to work |  |  | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 4 | 3 | 2 | 2 | 2 | 2 | 2 | 3 | 4 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 2 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 4 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 3 | 3 |  | 594
Crews on days off |  |  | 3 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 2 | 2 |  | 481
Crews on leave |  |  | 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 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 0 | 1 | 1 | 2 | 2 | 2 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 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 | 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 |  | 85
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
 |  |  |  |  |  |  |  |  | PATTERN CHANGE
Guaranteed Leave
Requested Leave
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Please see the captain worksheet for details of the requirements