Spreadsheet: 73578d1274216174-auto-populating-columns-in-one-sheet-from-another-based-on-criteria-daily-sched-automation-test
Sheet: PilotDuty-CurrentMonth

MAY 2009
CHANGE 2A
 | S | S |  |  |  |  |  | S | S |  |  |  |  |  | S | S | S |  |  |  |  | S | S |  |  |  |  |  | S | S | S
 | 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
 | 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 |  | [NAME] | W/H | LV | TAD
Pilot 1 | O | O |  |  |  |  |  | W | O | O |  |  |  |  | W | O | T | T | T | T | T | O | O |  |  |  |  |  | O | O | O |  | CO
Pilot 2 | O | O |  | N |  |  |  | W | O | O |  |  | X | Z | W | O | O |  |  |  |  | O | O |  |  |  | X | Z | O | O | O |  | XO
Pilot 3 | O | O | N |  | X | Z |  | W | O | X | Z |  |  |  | W | O | O |  |  |  |  | O | O |  |  |  |  |  | O | O | O |  | OP
Pilot 4 | L | L | X | I |  | N | L | L | L | O | N | X | Z | L | L | L | O |  |  |  | O | O | X |  |  |  |  | L | L | L | L | X | Mi
Pilot 5 | T | T | T | T | T | T | T | T | T | T | T | T | T | T | W | O | O | I | X | Z |  | O | O | T | T | T | T | X | N | N | N | R | Ms
Pilot 6 | X | O | O | I |  | X | Z | W | O | O | X | Z |  | X | O | T | T | T | T | T | T | O | O |  | T | T | T | T | T | T | T | T | Me
Pilot 7 | T | T | T | T | T | T | L | L | L | O |  |  | L | L | L | L | O | I |  |  | O | X | O |  | T | T | T | T | T | T | T | T | Jo
Pilot 8 | O | X |  |  |  |  | O | W | X | O |  | D |  |  | O | P | O | X | Z |  |  | O | O | X | Z |  |  |  | O | X | O | O | Pk
Pilot 9 | P | P | O | O |  | N | L | L | T | T | T | T | T | T | O | X | O | L |  | N | X | O | O | R |  |  | O | T | T | T | O | O | [NAME]
Pilot 10 | O | O | R |  |  |  |  | X | N | O | E | E |  |  | L | O | X |  |  |  |  | O | O |  | X | Z | N | O | X | O | O |  | Ro
Pilot 11 | N | N |  |  |  |  | X | W | O | O | R | D |  |  | X | O | O |  | N |  | L | L | T | T | T | T | T | T | L | L | L | T | De
Pilot 12 | O | O | O | X | Z |  | N | L | L | O |  |  |  |  | P | O | O | R |  | X | Z | O | O |  |  | X | Z | O | O | O | X | N | Mc
Pilot 13 | O | O |  | X | Z |  | X | W | O | O |  | L | L | L | L | L | O |  | N |  |  | X | N | L | L | L | L | L | L | L | L | N | So
Pilot 14 | X | O | O |  |  | X | Z | W | O | O | R |  |  |  | W | O | O |  |  | X | Z | O | O |  | L | L | L | L | X | N | O | O | Zi
Pilot 15 | O | X |  |  | T | T | T | T | O | O |  | X | Z | P | W | O | O | N |  |  | X | O | O | R |  |  |  | X | L | L | L | R | Cp
Pilot 16 | T | T | T | T | T | T | L | L | L | X | Z | D |  |  | X | O | O |  |  |  | N | N | N | L | L | N | N | O | O | X | O | T | Hu
Pilot 17 | O | P | R | O |  |  |  | X | O | O | E | E |  | O | W | P | O | X | Z | L | L | O | O |  | X | Z |  | O | O | O | X |  | Bo
Pilot 18 | O | N |  |  | X | Z |  | W | O | O |  |  | X | Z | P | O | O |  | X | Z |  | O | O |  |  |  |  | T | T | T | O | O | Sc
Pilot 19 | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | L | X |  | N |  | O | O | X |  |  |  | X | Z | L | L | L |  | Ni
Pilot 20 | N | N | X | N |  |  |  | W | O | O | X | Z |  | P | W | X | O | O |  |  | N | N | N |  |  | X | Z | N | L | L | L | X | Mu
Pilot 21 | N | N |  | N |  | N | O | W | X | O |  |  |  | X | W | O | O | R |  |  |  | O | O | X | Z |  |  |  | L | L | L | T | Ea
Pilot 22 | L | L | L | L | L | . | . | W | O | O | . | . | . | . | W | O | O | . | . | . | . | O | O | . | . | . | . | O | O | O | T | T | Hm
LEGEND
 | X | Duty (relief @ 1345) |  |  |  |  |  | M | Medical
 | Z | Off-going duty |  |  |  |  |  | N | Request no duty  (personal)
 | O | Off Day/ Slider |  |  |  |  |  | U | Unavailable (out of town)
 | R | Dog Watch (Ready) |  |  |  |  |  |  | No duty  (Cmd designated)
 | L | Leave |  |  |  |  |  |  | In transition/PCS
 | T | TAD |  |  |  |  |  |  | Weekend/ Holiday
 | I | RW Air Intercept |  |  |  |  |  |  | Schedule change from original
 | D | DLQ's |  |  |  |  |  |  | Req duty
 | P | Public Affairs |  |  |  |  |  |  | Standby Ready (B2)