BER  -  "&TEXT(sams!$AD$8,"TTTT TT.MM.JJ","  -  Sunrise: ",TEXT(VLOOKUP(sams!AD8,'[Stammdaten Tagesplan.xlsx]SUNSET'!$A:$D,2,FALSE,"HH:MM"," - Sunset: ",TEXT(VLOOKUP(sams!AD8,'[Stammdaten Tagesplan.xlsx]SUNSET'!$A:$D,3,FALSE,"HH:MM","  -  last update ",TEXT(NOW(,"TT.MM.JJ HH:MM"
Arr Dep	STA STD	flight #	destination	aircraft type	Registration	airline	remark	EXP RWY	# Visit 2020
Arr	0540	ABR6228	Köln	Boeing 757-28A F	OE-LFE	ASL Airlines Belgium	all white	N	6
Arr	0545	3V 4067	Lüttich	Boeing 737-490 SF	OE-IBL	ASL Airlines Belgium		N	3
Dep	0615	KL 1818	Amsterdam	Boeing 737-7K2 W	PH-BGX	KLM Royal Dutch Airlines	100 year sicker	N
Dep	0620	EW 8000	Stuttgart	Airbus A319-132	D-AGWJ	Eurowings		N
Dep	0620	FR 170	Athen	Boeing 737-8AS W	9H-QDL	Malta Air - Ryanair		N
Dep	0630	3V 4067	Örebro-Bofors	Boeing 737-490 SF	OE-IBL	ASL Airlines Belgium		N
Arr	0645	FX 4634	CDG) / Hannover	Boeing 737-4Y0 SF	F-GIXN	ASL Airlines France	all white	N	6
Dep	0645	LH 173	Frankfurt	Airbus A319-112	D-AIBD	Lufthansa		N
Arr	0725	EW 012	Köln	Airbus A320-214 SL	D-AEWL	Eurowings		N	9
Dep	0730	LH 1959	München	Airbus A319-114	D-AILP	Lufthansa - Lufthansa CityLine	Star Alliance cls.	N
Arr	0735	EW 9048	Düsseldorf	Airbus A319-112	D-ABGQ	Eurowings		N	5
Dep	0800	BA 981	LHR)	Airbus A319-131	G-EUOG	British Airways		N
Dep	0800	EW 013	Köln	Airbus A320-214 SL	D-AEWL	Eurowings		N
Dep	0810	EW 9049	Düsseldorf	Airbus A319-112	D-ABGQ	Eurowings		N
Arr	0900	DX 121	Saarbrücken	ATR 42	LY-DAT	DOT Danu Ora Transportas		N	46
Arr	0905	OS 223	Wien	Bombardier Q400	OE-LGO	Austrian Airlines	Star Alliance cls. - first visit	N	1
Arr	0935	EW 8001	Stuttgart	Airbus A319-132	D-AGWJ	Eurowings		N	48
Arr	0935	TK 1721	IST)	Airbus A321-271NX	TC-LSK	Turkish Airlines		N	5
Arr	0950	BT 201	Tallinn	Airbus A220-300	YL-AAP	Air Baltic		N	3
Dep	0950	OS 224	Wien	Bombardier Q400	OE-LGO	Austrian Airlines	Star Alliance cls.	N
Arr	0955	LH 176	Frankfurt	Airbus A320-271N	D-AINC	Lufthansa		N	3
Dep	1030	TK 1722	IST)	Airbus A321-271NX	TC-LSK	Turkish Airlines		N
Arr	1040	BA 992	LHR)	Airbus A319-131	G-EUPR	British Airways	first visit	N	1
Dep	1045	LH 183	Frankfurt	Airbus A320-271N	D-AINC	Lufthansa		N
Dep	1050	BT 202	Tallinn	Airbus A220-300	YL-AAP	Air Baltic		N
Dep	1100	EJU5915	TFS)	Airbus A320-214 SL	OE-IVD	easyJet Europe Airline		N
Dep	1100	FR 1011	CIA)	Boeing 737-8AS W	9H-QAD	Malta Air - Ryanair		N
Arr	1100	I2 3676	Madrid	Airbus A320-216 SL	EC-LUS	Iberia Express		N	4
Arr	1105	KL 1823	Amsterdam	Boeing 737-7K2 W	PH-BGQ	KLM Royal Dutch Airlines	100 year sicker	N	2
Arr	1130	AY 1433	Helsinki	Embraer E190LR	OH-LKR	Finnair		N	6
Dep	1130	BA 993	LHR)	Airbus A319-131	G-EUPR	British Airways		N
Dep	1150	I2 3677	Madrid	Airbus A320-216 SL	EC-LUS	Iberia Express		N
Dep	1150	KL 1824	Amsterdam	Boeing 737-7K2 W	PH-BGQ	KLM Royal Dutch Airlines	100 year sicker	N
Dep	1210	AY 1434	Helsinki	Embraer E190LR	OH-LKR	Finnair		N
Dep	1215	EJU9050	BER)	Airbus A320-214	OE-IZE	easyJet Europe Airline		N
Arr	1220	QR 081	Doha	Boeing 787-8 Dreamliner	A7-BCJ	Qatar Airways		N	2
Arr	1225	LH 1936	München	Airbus A319-114	D-AILP	Lufthansa - Lufthansa CityLine	Star Alliance cls.	N	2
Arr	1230	TK 7728	SAW)	Boeing 737-8F2 W	TC-JFF	AnadoluJet		N	2
Arr	1235	XQ 160	Antalya	Boeing 737-8HC SW	TC-SEZ	SunExpress	30 years sticker	N	2
Arr	1245	EJU9050	BER)	Airbus A320-214	OE-IZE	easyJet Europe Airline		N	2
Arr	1245	FR 171	Athen	Boeing 737-8AS W	9H-QDL	Malta Air - Ryanair		N	10
Arr	1300	TK 3307	SAW)	Boeing 737-8F2 W	TC-JGY	Turkish Airlines	first visit	N	1
Dep	1310	LH 1937	München	Airbus A319-114	D-AILP	Lufthansa - Lufthansa CityLine	Star Alliance cls.	N
Arr	1310	PC 979	SAW)	Boeing 737-82R W	TC-CRE	Pegasus Airlines		N	4
Arr	1320	LY 337	Tel Aviv	Boeing 737-958 ER W	4X-EHB	El Al - Israel Airlines	first visit	N	1
Dep	1325	XQ 161	Antalya	Boeing 737-8HC SW	TC-SEZ	SunExpress	30 years sticker	N
Dep	1335	FR 1594	Sofia	Boeing 737-8AS	9H-QAZ	Malta Air - Ryanair		N
Dep	1345	TK 7729	SAW)	Boeing 737-8F2 W	TC-JFF	AnadoluJet		N
Arr	1355	OM 3137	Ulan Bator	Boeing 767-3BG ER	EI-FGN	MIAT Mongolian Airlines		N	5
Dep	1405	LY 337	Amsterdam	Boeing 737-958 ER W	4X-EHB	El Al - Israel Airlines		N
Dep	1405	PC 980	SAW)	Boeing 737-82R W	TC-CRE	Pegasus Airlines		N
Arr	1455	LH 186	Frankfurt	Embraer E190LR	D-AECE	Lufthansa CityLine - Lufthansa		N	3
Arr	1455	TP 536	Lissabon	Embraer E190LR	CS-TPT	TAP Express		N	4
Arr	1510	BT 215	Vilnius	Airbus A220-300	YL-CSK	Air Baltic	Lithuanian Flag	N	2
Dep	1510	DX 124	Saarbrücken	ATR 42	LY-DAT	DOT Danu Ora Transportas		N
Arr	1535	FR 1012	CIA)	Boeing 737-8AS W	9H-QAD	Malta Air - Ryanair		N	4
Dep	1540	TP 537	Lissabon	Embraer E190LR	CS-TPT	TAP Express		N
Arr	1550	EW 2004	Stuttgart	Airbus A320-214 SL	D-AEWM	Eurowings	Boomerang Club cls.	N	15
Dep	1555	OM 3138	Ulan Bator	Boeing 767-3BG ER	EI-FGN	MIAT Mongolian Airlines		N
Dep	1610	BT 216	Vilnius	Airbus A220-300	YL-CSK	Air Baltic	Lithuanian Flag	N
Dep	1610	QR 082	Doha	Boeing 787-8 Dreamliner	A7-BCJ	Qatar Airways		N
Dep	1625	EW 2005	Stuttgart	Airbus A320-214 SL	D-AEWM	Eurowings	Boomerang Club cls.	N
Arr	1630	EW 9040	Düsseldorf	Airbus A319-132	D-AGWH	Eurowings		N	5
Arr	1635	EW 006	Köln	Airbus A320-214 SL	D-AEWL	Eurowings		N	10
Dep	1705	EW 9041	Düsseldorf	Airbus A319-132	D-AGWH	Eurowings		N
Dep	1710	EW 007	Köln	Airbus A320-214 SL	D-AEWL	Eurowings		N
Arr	1715	AF 1134	CDG)	Airbus A318-111	F-GUGJ	Air France	first visit	N	1
Arr	1740	KL 1831	Amsterdam	Embraer E190STD	PH-EZY	KLM Cityhopper	first visit	N	1
Arr	1745	LX 970	Zürich	Airbus A220-300	HB-JCR	Swiss International Air Lines		N	3
Arr	1755	BA 986	LHR)	Airbus A319-131	G-EUOF	British Airways		N	2
Arr	1800	KM 376	Malta	Airbus A320-214	9H-AHS	Air Malta		N	2
Arr	1810	LH 1948	München	Airbus A319-112	D-AIBC	Lufthansa		N	9
Dep	1815	LH 167	Frankfurt	Embraer E190LR	D-AECE	Lufthansa CityLine - Lufthansa		N
Dep	1825	KL 1832	Amsterdam	Embraer E190STD	PH-EZY	KLM Cityhopper		N
Dep	1835	EW 8046	Düsseldorf	Airbus A319-132	D-AGWJ	Eurowings		N
Arr	1835	FR 1595	Sofia	Boeing 737-8AS	9H-QAZ	Malta Air - Ryanair		N	11
Dep	1835	LX 971	Zürich	Airbus A220-300	HB-JCR	Swiss International Air Lines		N
Dep	1840	EW 8006	Stuttgart	Airbus A320-214 SL	D-AEWG	Eurowings		N
Arr	1840	OS 235	Wien	Embraer E195LR	OE-LWC	Austrian Airlines		N	2
Dep	1850	KM 377	Malta	Airbus A320-214	9H-AHS	Air Malta		N
Arr	1855	LH 194	Frankfurt	Canadair CRJ-900LR	D-ACNW	Lufthansa CityLine - Lufthansa		N	4
Dep	1900	LH 1949	München	Airbus A319-112	D-AIBC	Lufthansa		N
Arr	1915	EW 020	Köln	Airbus A319-132	D-AGWV	Eurowings		N	16
Dep	1925	OS 236	Wien	Embraer E195LR	OE-LWC	Austrian Airlines		N
Arr	1930	EJU9053	Mailand	Airbus A319-111	OE-LQI	easyJet Europe Airline		N	2
Dep	1945	LH 201	Frankfurt	Canadair CRJ-900LR	D-ACNW	Lufthansa CityLine - Lufthansa		N
Dep	1950	EW 021	Köln	Airbus A319-132	D-AGWV	Eurowings		N
Arr	2035	SR 833F	Leipzig	Airbus A319-111	D-ASMF	Sundair		N	4
Arr	2110	LH 1958	München	Airbus A319-114	D-AILX	Lufthansa		N	12
Arr	2145	3V 4537	Tallinn	Boeing 737-45D BDSF	OO-TNP	ASL Airlines Belgium	FedEx Express cls.	N	3
Arr	2145	EW 8047	Düsseldorf	Airbus A319-132	D-AGWJ	Eurowings		N	49
Arr	2155	EW 8007	Stuttgart	Airbus A320-214 SL	D-AEWG	Eurowings		N	37
Arr	2155	KL 1835	Amsterdam	Boeing 737-7K2 W	PH-BGL	KLM Royal Dutch Airlines	100 year sicker	N	5
Dep	2200	FX 4635	CDG) / Hannover	Boeing 737-4Y0 SF	F-GIXN	ASL Airlines France	all white	N
Arr	2225	EJU5916	TFS)	Airbus A320-214 SL	OE-IVD	easyJet Europe Airline		N	18
Dep	2230	3V 4537	Lüttich	Boeing 737-45D BDSF	OO-TNP	ASL Airlines Belgium	FedEx Express cls.	N
Arr	2240	LH 202	Frankfurt	Airbus A319-112	D-AIBE	Lufthansa		N	5
Dep	2300	ABR6227	Köln	Boeing 757-28A F	OE-LFE	ASL Airlines Belgium	all white	N