Polar speed to fly and glider comp.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	V	W	X	Z	AA	AB
1		Glider = DG300	Wingload = 6.55 psf			WL =	6.55	724	lb mass	N300DU wingload = 7.11 psf
2			A	B	C = A / B	D = C * A				wing area	110.5												sqft
3	CHARTED DATA		Velocity (kts)	Sink (kts)	L/D (V/S)	(L/D) * V Vel-Rng	MC Speed		367.31
4	Velocity (kmh)	Sink (m/s)	Velocity (kts)	WL = 6.55 psf	WL = 6.55 psf	WL = 6.55 psf	WL = 6.55 psf
5	80	0.5999	43	-1.17	37.0	1600					From https://www.dropbox.com/s/2uw6zxkgkd06mrm/StillAirBestCruiseSpeed.pdf?dl=0
6	90	0.634	49	-1.23	39.4	1916
7	100	0.6923	54	-1.35	40.1	2167
8	110	0.7807	59	-1.52	39.1	2325	0.4
9	120	0.9052	65	-1.76	36.8	2386	1.6
10	130	1.0536	70	-2.05	34.3	2406	2.6															0.5126		0.5	x	0.5
11	140	1.2459	76	-2.42	31.2	2360	3.8															0.0748		0.5874	0.5126
12	150	1.4892	81	-2.89	28.0	2266	5															0.5874
13	160	1.7831	86	-3.47	24.9	2153	6.4															length
14	170	2.10722	92	-4.10	22.4	2057	8																	0.436329588	0.9363
15	180	2.48885	97	-4.84	20.1	1953	9.4
16	190	2.9111	103	-5.66	18.1	1860																		0.5	x	1
17																								0.5874	0.5126
18
19
20	N300DU	Glider = DG300	Wingload = 7.11 psf - Dry			WL =	7.11	786	lb mass															0.436329588	1.4363
21			A	B	C = A / B	D = C * A
22	INTERPOLATED DATA		Velocity (kts)	Sink (kts)	L/D (V/S)	(L/D) * V Vel-Rng	MC Speed		348.46				WL	Max Vel-Rng								x	y	0.5	x	1.5
23	Velocity (kmh)	Sink (m/s)	Velocity (kts)	WL = 7.11 psf	WL = 7.11 psf	WL = 7.11 psf	WL = 7.11 psf						6.55	2406							speed	sink	wl	0.5874	0.5126
24	80												7.11	2478							49	-1.2324	6.55
25	90		49	-1.3	38.5	1873							8.19	2651							49	-1.3160	8.19
26	100		54	-1.4	39.9	2157							10.2	2978										0.436329588	1.9363
27	110		59	-1.5	39.1	2324	0														48.6	x	7.11
28	120		65	-1.7	37.6	2434	1.2																	0.5	x	2
29	130		70	-2.0	35.3	2478	2.2															-1.26093582	-1.26093582	0.5874	0.5126
30	140		76	-2.3	32.4	2452	3.4
31	150		81	-2.7	29.5	2386	4.6
32	160		86	-3.3	26.5	2290	5.8																	0.436329588	2.4363
33	170		92	-3.8	23.9	2196	7.2
34	180		97	-4.5	21.5	2088	8.6																	0.5	x	2.5
35	190		103	-5.3	19.4	1991																		0.5874	0.5126
36
37
38	N300DU	Glider = DG300	Wingload = 8.19 psf - 54L (14.26gal) water			WL =	8.19	905	lb mass															0.436329588	2.9363
39			A	B	C = A / B	D = C * A
40	CHARTED DATA		Velocity (kts)	Sink (kts)	L/D (V/S)	(L/D) * V Vel-Rng	MC Speed		323.66
41	Velocity (kmh)	Sink (m/s)	Velocity (kts)	WL = 8.19 psf	WL = 8.19 psf	WL = 8.19 psf	WL = 8.19 psf
42
43	90	0.677	49	-1.3	36.9	1795
44	100	0.7022	54	-1.4	39.6	2136
45	110	0.7813	59	-1.5	39.7	2358							config	gwt	wing load	vel rng / WL	vel rng
46	120	0.8541	65	-1.7	39.0	2529	0.4						dry	786	7.11	352	2,505
47	130	0.9654	70	-1.9	37.4	2626	1.2						30gal	1043	9.44	305	2,874
48	140	1.1103	76	-2.2	35.0	2648	2.4						full	1157	10.47	283	2,967
49	150	1.2731	81	-2.5	32.7	2651	3.4
50	160	1.4761	86	-2.9	30.1	2601	4.6
51	170	1.7208	92	-3.3	27.4	2519	6
52	180	2.02	97	-3.9	24.8	2406	7.4
53	190	2.3552	103	-4.6	22.4	2299	9
54
55
56	N300DU	Glider = DG300	Wingload = 9.15 psf - 100L (26gal) water			WL =	9.15	1011	lb mass
57			A	B	C = A / B	D = C * A
58	INTERPOLATED DATA		Velocity (kts)	Sink (kts)	L/D (V/S)	(L/D) * V Vel-Rng	MC Speed		301.33
59	Velocity (kmh)	Sink (m/s)	Velocity (kts)	WL = 9.15 psf	WL = 9.15 psf	WL = 9.15 psf	WL = 9.15 psf
60	80
61	90		49	-1.4	35.6	1730
62	100		54	-1.4	37.8	2042
63	110		59	-1.5	39.2	2330
64	120		65	-1.6	39.4	2550
65	130		70	-1.8	38.1	2674	0.6
66	140		76	-2.1	36.2	2739	1.8
67	150		81	-2.4	34.0	2757	2.8
68	160		86	-2.7	31.7	2734	3.8
69	170		92	-3.1	29.3	2685	5.2
70	180		97	-3.6	26.7	2597	6.4
71	190		103	-4.2	24.2	2485	8
72
73
74	N300DU	Glider = DG300	Wingload = 10.2 psf - 155L (40.86gal) water			WL =	10.2	1127	lb mass
75			A	B	C = A / B	D = C * A
76	CHARTED DATA		Velocity (kts)	Sink (kts)	L/D (V/S)	(L/D) * V Vel-Rng	MC Speed		292.00
77	Velocity (kmh)	Sink (m/s)	Velocity (kts)	WL = 10.2 psf	WL = 10.2 psf	WL = 10.2 psf	WL = 10.2 psf
78
79
80	100	0.761	54	-1.5	36.5	1971
81	110	0.7772	59	-1.5	39.3	2335
82	120	0.8315	65	-1.6	40.1	2598
83	130	0.917	70	-1.8	39.4	2764	0
84	140	1.0183	76	-2.0	38.2	2887	1
85	150	1.1441	81	-2.2	36.4	2950	2
86	160	1.2892	86	-2.5	34.5	2978	3
87	170	1.4576	92	-2.8	32.4	2974	4.2
88	180	1.6666	97	-3.2	30.0	2916	5.4
89	190	1.9363	103	-3.8	27.3	2796	6.8
90
91
92
93
94
95
96	XCSOAR Polar Data					40	L			75	L			115	L			150	L
97	DG300		7.12	lbsqft			7.92	lbsqft			8.62	lbsqft			9.41	lbsqft			10.01	lbsqft
98		dry	787	lb wt		10 gal water	875	lb wt		20 gal water	952	lb wt		30 gal water	1040	lb wt		full water 40 gal	1106	lb wt
99	MC	Speed (kts)	GR	Vel Rng		Speed (kts)	GR	Vel Rng		Speed (kts)	GR	Vel Rng		Speed (kts)	GR	Vel Rng		Speed (kts)	GR	Vel Rng
100	0	55	40	2200		59	40	2360		61	40	2440		64	40	2560		67	40	2680