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

 | FLIGHT PLANNING DATA MANAGEMENT |  |  |  |  |  |  |  |  | 04:00:00 | : Select Local-to-Zulu time adjustment
 | AIRCRAFT DATA |  |  |  |  | CREWMEMBER DATA |  |  |  |  |  |  |  |  |  | MISSION DATA
 | TAIL # | TYPE | FCR? | FMC? |  | RCMs (Last, First) | RCM Last 4 | ACFT | PC/PI | AMC? | UNIT | NCMs (Last, First) | NCM Last 4 | UNIT |  | TYPE | STATUS
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
2 | 05199 | AH64DI | N | Y |  | Pilot, One | XXXX | 64D | PC | Y |  | NCM, One | XXXX |  |  | APART | CX | 2
3 | 23451 | UH60A |  | Y |  | Pilot, Two | XXXX | 64D | PI | N |  | NCM, Two | XXXX |  |  | ATM | MC | 3
4 | 23274 | UH60A |  | Y |  | Pilot, Three | XXXX | 60A | PI | N |  |  |  |  |  | ATMR | NC | 4
5 | 24580 | UH60A |  | Y |  | Pilot, Four | XXXX | 60A | PC | Y |  |  |  |  |  | [NAME]. |  | 5
6 | 24582 | UH60A |  | Y |  | Pilot, Five | XXXX | 64D | PC | Y |  |  |  |  |  | C&S | RISK | 6
7 | 26147 | UH60A |  | Y |  |  |  |  |  |  |  |  |  |  |  | CDR's Evaluation |  | 7
8 | 95600 | AH64DII | Y | Y |  |  |  |  |  |  |  |  |  |  |  | Cross Country | L | 8
9 | 95603 | AH64DII | Y | Y |  |  |  |  |  |  |  |  |  |  |  | Day QRF | M | 9
10 | 95606 | AH64DII | N | Y |  |  |  |  |  |  |  |  |  |  |  | DLAO | H | 10
11 | 95610 | AH64DII | N | Y |  |  |  |  |  |  |  |  |  |  |  | Escort | EH | 11
12 | 95612 | AH64DII | N | Y |  |  |  |  |  |  |  |  |  |  |  | Flyover |  | 12
13 | 95616 | AH64DII | N | Y |  |  |  |  |  |  |  |  |  |  |  | Gunnery |  | 13
14 | 95617 | AH64DII | N | Y |  |  |  |  |  |  |  |  |  |  |  | ISR |  | 14
15 | 95629 | AH64DII | N | Y |  |  |  |  |  |  |  |  |  |  |  | MTF |  | 15
16 | 95630 | AH64DII | N | Y |  |  |  |  |  |  |  |  |  |  |  | Night QRF |  | 16
17 | 95631 | AH64DII | N | Y |  |  |  |  |  |  |  |  |  |  |  | PC Progression |  | 17
18 | 95635 | AH64DII | N | Y |  |  |  |  |  |  |  |  |  |  |  | R&S |  | 18
19 | 95636 | AH64DII | N | Y |  |  |  |  |  |  |  |  |  |  |  | RL Progression |  | 19
20 | 95637 | AH64DII | N | Y |  |  |  |  |  |  |  |  |  |  |  | Static Display |  | 20
21 | 95638 | AH64DII | N | Y |  |  |  |  |  |  |  |  |  |  |  | SAAO Mission |  | 21
22 | 95642 | AH64DII | N | Y |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
23 | 95663 | AH64DII | N | Y |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
24 | 95664 | AH64DII | N | Y |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25
26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26
27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27
28 | NOTE! TAIL NUMBERS MUST BE SORTED IN ASCENDING ORDER REGARDLESS OF AIRCRAFT TYPE IN ORDER TO WORK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28
29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32
33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33
34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34
35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35
36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36
37 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37
38 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38
39 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39
40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
41 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41
42 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42
43 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43
44 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44
45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45
46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46
47 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 47
48 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48
49 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49
50 | TIME / DATE DATA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50
51 | MONTH | ADJUST | YEAR | HOUR |  |  |  |  |  |  |  |  |  |  |  |  |  | 51
52 | JAN | 14:00:00 | 2012 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 52
53 | FEB | 13:00:00 | 2013 | 00:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 53
54 | MAR | 12:00:00 | 2014 | 01:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 54
55 | APR | 11:00:00 | 2015 | 01:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 55
56 | MAY | 10:00:00 | 2016 | 02:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 56
57 | JUN | 09:00:00 | 2017 | 02:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 57
58 | JUL | 08:00:00 | 2018 | 03:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 58
59 | AUG | 07:00:00 | 2019 | 03:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 59
60 | SEP | 06:00:00 | 2020 | 04:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
61 | OCT | 05:00:00 | 2021 | 04:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 61
62 | NOV | 04:00:00 | 2022 | 05:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 62
63 | DEC | 03:00:00 | 2023 | 05:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 63
64 |  | 02:00:00 |  | 06:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 64
65 | DATE | 01:00:00 |  | 06:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 65
66 | 1 | 00:00:00 |  | 07:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 66
67 | 2 | 01:00:00 |  | 07:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 67
68 | 3 | 02:00:00 |  | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 68
69 | 4 | 03:00:00 |  | 08:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 69
70 | 5 | 04:00:00 |  | 09:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 70
71 | 6 | 05:00:00 |  | 09:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 71
72 | 7 | 06:00:00 |  | 10:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 72
73 | 8 | 07:00:00 |  | 10:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 73
74 | 9 | 08:00:00 |  | 11:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 74
75 | 10 | 09:00:00 |  | 11:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 75
76 | 11 | 10:00:00 |  | 12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 76
77 | 12 | 11:00:00 |  | 12:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 77
78 | 13 | 12:00:00 |  | 13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 78
79 | 14 | 13:00:00 |  | 13:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 79
80 | 15 | 14:00:00 |  | 14:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 80
81 | 16 |  |  | 14:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 81
82 | 17 |  |  | 15:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 82
83 | 18 |  |  | 15:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 83
84 | 19 |  |  | 16:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 84
85 | 20 |  |  | 16:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 85
86 | 21 |  |  | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 86
87 | 22 |  |  | 17:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 87
88 | 23 |  |  | 18:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 88
89 | 24 |  |  | 18:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 89
90 | 25 |  |  | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 90
91 | 26 |  |  | 19:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 91
92 | 27 |  |  | 20:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 92
93 | 28 |  |  | 20:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 93
94 | 29 |  |  | 21:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 94
95 | 30 |  |  | 21:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 95
96 | 31 |  |  | 22:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 96
97 |  |  |  | 22:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 97
98 |  |  |  | 23:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 98
99 |  |  |  | 23:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 99
100 |  |  |  | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 100