Flight_Catalog.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
1	Date	UTC flight begin	UTC flight end	UTC domain begin	UTC domain end	Flight Number	Flight Pattern	WLEF leg up	WLEF leg dn	Primary Objective	Forecast Flight	Wind Dir (deg)	Wind Dir (deg)	Wind Speed (mph)	Wind Speed (m/s)	Temp (F)	Temp (C)	RH (%)	RH (%)	Sky Cover (%)	Precip potential (%)	Mixing Height (ft)	Cloud height (>2000' AGL)	Visibility (>3 miles)	Comments
2	Source					UWKA						NWS	ISS Sodar	NWS	ISS Sodar	NWS	ISS radiosonde	NWS	ISS_surfaceRH	NWS	NWS	NWS	KRHI	KRHI

3	2019-07-08	14:03	16:53			TF02	WE2	leg_10	leg_12	ebal, esbl	AM-KA	210	210	6	5	78	NA	54	100	9	4	5900	12000	6
4	2019-07-09	13:57	16:47	14:06	16:16	RF01	WE2	leg_10	leg_12	ebal, esbl	AM-KA	210	180	16	6	77	23	60	100	33	0	4100	12000	6	- from 16:18 CRL calibration (stack passes)
5	2019-07-09	19:02	21:32	19:11	21:22	RF02	WE2	leg_10	leg_12	ebal, esbl	PM-KA	180	210	16	5	82	23	46	58	63	0	6000	12000	6
6	2019-07-11	14:10	17:00	14:22	16:36	RF03	WE1	leg_10	leg_12	ebal, esbl	AM-KA	10	345	7	3	65	17	57	100	11	0	3900	1700	6	- scattered clouds at 1700 feet AGL
7	2019-07-11	19:00	21:40	19:15	21:28	RF04	WE1	leg_10	leg_12	ebal, esbl	PM-KA	0	45	3	5	78	22	40	45	0	0	6000	0	6	- clear skies
8	2019-07-12	13:40	16:45	13:49	16:06:50	RF05	WE2	leg_10	leg_12	esbl, dsgn	AM-KA	240	225	9	6	76	19	62	100	59	12	3400	12000	6
9	2019-07-12	17:52	21:00	18:03:30	20:46:20	RF06	WE2	leg_10	leg_12	esbl, dsgn	PM-KA	270	225	11	5	82	21	64	65	57	40	6400	7000	6
10	2019-07-13	14:05	16:52	14:21:50	16:32:10	RF07	SE2	leg_10	leg_12	avct, cvrg, dsgn	AM-KA	0	330	6	3	75	20	56	100	31	0	5000	12000	6
11	2019-07-13	18:56:20	21:30	19:11:50	21:15:30	RF08	SW1	leg_10	leg_12	cvrg, ebal, dsgn	PM-KA	315	330	6	3	81	20	40	50	19	0	6900	12000	6
12	2019-08-19	14:59	16:17			TF04	SE1 (partial)	leg_10	leg_12	ebal	AM-KA	245	270	8	5	70	13	49	100	1	0	3700	12000	6
13	2019-08-20	13:40	16:23	13:51	16:12	RF09	SE1	leg_10	leg_12	cvrg, ebal, dsgn	AM-KA	200	215	8	3	75	20	62	100	65	14	2300	12000	6	overcast
14	2019-08-20	19:12	22:22	19:23	21:51	RF10	SE1	leg_10	leg_12	cvrg, ebal, dsgn	PM-KA	235	180	8	1	79	21	60	80	45	24	3900	10000	6	overcast; ceilometer at ISS says clouds are at 8800' (at roughly noon CDT)
15	2019-08-21	13:54	16:50	14:08	16:36	RF11	SW1	leg_10	leg_12	cvrg, ebal	AM-KA	315	0	8	5	67	15	58	100	12	0	5300	12000	6
16	2019-08-21	18:55	21:50	19:11	21:37:30	RF12	SW1	leg_10	leg_12	cvrg, ebal	PM-KA		315		6		18.5		45						Missed updating record in real time. Missing forecast data.
17	2019-08-22	13:57	17:15	14:10:38	16:54:30	RF13	SW2	leg_10	leg_12	cvrg, dsgn	AM-KA	30	30	3	3	62	13.5	70	100	69	4	5900	7000	6	overcast with 3000 ft cumulus below
18	2019-08-22	19:00	22:01	19:13:20	21:46:20	RF14	SW2	leg_10	leg_12	cvrg, dsgn	PM-KA	30	30	5	1	67	15	55	62	72	12	7700	6000	6	overcast with 3000 ft cumulus below
19	2019-08-23	13:57	16:48	14:07	16:38	RF15	WE2	leg_10	leg_12	avct, esbl, dsgn	AM-KA	90	80	3	0.5	64	12	65	100	15	0	4400	12000	6
20	2019-08-23	19:07	22:03	19:17	21:46	RF16	WE2	leg_10	leg_12	avct, esbl, dsgn	PM-KA	100	120	2	3	72	18	41	50	12	0	6100	12000	6
21	2019-09-23	17:10:00	18:27			TF06	SE1 (partial)	leg_10	leg_12	ebal, cvrg, cmpr	AM-KA	280	280	6	3	61	12	75	100	38	0	4300	3000	6	scattered clouds at 1000 feet AGL, broken clouds at 3000 feet AGL
22	2019-09-24	13:37:00	17:00	13:53:00	16:24:00	RF17	SE1	leg_10	leg_12	ebal, cvrg, cmpr	AM-KA	190	230	7	4	68	13	65	100	8	0	1600	12000	6	few clouds at 4000 feet AGL, ceiling at least 12,000 feet AGL
23	2019-09-24	18:57:00	21:49	19:10:00	21:39:20	RF18	SE1	leg_10	leg_12	ebal, cvrg, cmpr	PM-KA	225	180	8	5	74	23	64	60	65	6	3100	25000	6	scattered clouds at 5000 feet AGL, broken clouds at 25000 feet AGL
24	2019-09-25	14:20:00	17:22	14:41:00	17:09:00	RF19	SW1	leg_10	leg_12	ebal, cvrg, cmpr	AM-KA	285	270	13	5	58	12	79	100	57	15	4100	12000	6	scattered clouds at 4500 feet AGL
25	2019-09-25	19:12:00	22:06	19:29:09	21:53:00	RF20	SW1	leg_10	leg_12	ebal, cvrg, cmpr	PM-KA	280	310	13	5	60	15	53	60	58	24	6800	12000	6	scattered clouds at 4500 feet AGL
26	2019-09-26	13:52:00	16:46	14:05:20	16:34:45	RF21	SE1	leg_10	leg_12	ebal, cvrg	AM-KA	255	270	8	3	54	4	57	100	8	0	4200	12000	6
27	2019-09-26	18:31:00	21:40	18:44:44	21:14:20	RF22	SE1	leg_10	leg_12	ebal, cvrg	PM-KA	250	265	10	5	60	15	51	53	58	3	7000			Missed updating this record in real time. Means we missed the forecast data for these entries. Blue means those NWS predictions were a day old. The browser window was still up from the previous day. KRHI wasn't up, so it was left blank.
28	2019-09-28					RF23	WE1	leg_10	leg_12	ebal, cvrg	AM-KA	15	353	5	3	51	6	68	96	26	0	3400	12000	6	few clouds at 3000 feet AGL
29	2019-09-28					RF24	WE1	leg_10	leg_12	ebal, cvrg	PM-KA	15	15	6	3	56	10	36	59	13	0	5000	12000	6
30
31							Number of patterns to date
32							WE	11
33							SW	7
34							SE	8
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100