Spreadsheet: 158265d1338126164-need-help-transferring-multiple-cells-on-a-conditional-basis-flight-scheduler
Sheet: Week Schedule

DATE: | # | MISSION TYPE | TAIL # | FLT COND | ETD (L)                        (hh:[NAME]) | ETE                  (hh:[NAME]) | ETA (L)                  (hh:[NAME]) | RATED CREWMEMBERS |  | CALLSIGN | NON-RATED CREWMEMBERS |  | RAV
3 |  |  |  |  |  |  |  | PC | PI |  | IF APPLICABLE | IF APPLICABLE
MONTH: | 1 | APART | 95600 | 1,2,3 | 00:30:00 | 02:00:00 |  | Pilot, One | Pilot, Two | PREDATOR 11 | NCM, One | NCM, Two | L
MAY | 2 | ATM | 95603 | 1,2,3 | 00:30:00 | 02:00:00 |  | Pilot, Three | Pilot, Four | PREDATOR 12 |  |  | L
MONDAY | 3 | ATMR | 05199 | 1,2,3 | 01:00:00 | 01:00:00 |  | Pilot, One | Pilot, One | OUTCAST 12 |  |  | L
 | 4 | ATMR | 95600 | 2 | 01:00:00 | 01:00:00 |  | Pilot, Five | Pilot, Three | PREDATOR 11 | NCM, Two | NCM, One | L
 | 5 | ATMR | 95603 | 2 | 01:00:00 | 01:00:00 |  | Pilot, Five | Pilot, Three | REAPER 11 |  |  | M
 | 6 | APART | 95603 | 2 | 22:00:00 | 01:00:00 |  | Pilot, One | Pilot, Two | REAPER 12 |  |  | M
 | 7 | APART | 95606 | 2 | 02:30:00 | 03:00:00 |  | Pilot, Four | Pilot, Five | OUTCAST 22 | NCM, One | NCM, One | H
 | 8 | ATM | 95610 | 3 | 02:30:00 | 02:30:00 |  | Pilot, Three | Pilot, Five | OUTCAST 34 |  |  | H
 | 9 | APART | 95612 | 4 | 02:30:00 | 01:00:00 |  | Pilot, Two | Pilot, Two | OUTCAST 45 |  |  | EH
 | 10 | ATM | 24582 | 4 | 01:00:00 | 01:00:00 |  | Pilot, Two | Pilot, One | PREDATOR 11 |  |  | EH
 | 11 | [NAME]. | 95606 | 4 | 00:00:00 | 01:30:00 |  | Pilot, Three | Pilot, Five | PREDATOR 12 |  |  | L
 | 12 | CDR's Evaluation | 24582 | 4 | 00:30:00 | 01:00:00 |  | Pilot, Three | Pilot, Three | PREDATOR 41 | NCM, One | NCM, One | L
 | 13 | C&S | 95606 | 5 | 01:00:00 | 01:00:00 |  | Pilot, Two | Pilot, One | OUTCAST 11 |  |  | L
 | 14 | RL Progression | 95600 | 5 | 01:00:00 | 02:30:00 |  | Pilot, Three | Pilot, Four | OUTCAST 22 |  |  | M
 | 15 | RL Progression | 95603 | 6 | 01:30:00 | 03:00:00 |  | Pilot, One | Pilot, Three | OUTCAST 33 |  |  | L
DATE: | # | MISSION TYPE | TAIL # | FLT COND | ETD (L)                        (hh:[NAME]) | ETE                  (hh:[NAME]) | ETA (L)                  (hh:[NAME]) | RATED CREWMEMBERS |  | CALLSIGN | NON-RATED CREWMEMBERS |  | RAV
4 |  |  |  |  |  |  |  | PC | PI |  | IF APPLICABLE | IF APPLICABLE
MONTH: | 1
MAY | 2
TUESDAY | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
DATE: | # | MISSION TYPE | TAIL # | FLT COND | ETD (L)                        (hh:[NAME]) | ETE                  (hh:[NAME]) | ETA (L)                  (hh:[NAME]) | RATED CREWMEMBERS |  | CALLSIGN | NON-RATED CREWMEMBERS |  | RAV
5 |  |  |  |  |  |  |  | PC | PI |  | IF APPLICABLE | IF APPLICABLE
MONTH: | 1
MAY | 2
WEDNESDAY | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
DATE: | # | MISSION TYPE | TAIL # | FLT COND | ETD (L)                        (hh:[NAME]) | ETE                  (hh:[NAME]) | ETA (L)                  (hh:[NAME]) | RATED CREWMEMBERS |  | CALLSIGN | NON-RATED CREWMEMBERS |  | RAV
6 |  |  |  |  |  |  |  | PC | PI |  | IF APPLICABLE | IF APPLICABLE
MONTH: | 1
MAY | 2
THURSDAY | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
DATE: | # | MISSION TYPE | TAIL # | FLT COND | ETD (L)                        (hh:[NAME]) | ETE                  (hh:[NAME]) | ETA (L)                  (hh:[NAME]) | RATED CREWMEMBERS |  | CALLSIGN | NON-RATED CREWMEMBERS |  | RAV
7 |  |  |  |  |  |  |  | PC | PI |  | IF APPLICABLE | IF APPLICABLE
MONTH: | 1
MAY | 2
FRIDAY | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15