Front Wing Mounting V2.xlsb.xlsx

	B	C	D	E	F	H	I	J	L	M	N	P	Q	R
1
2	Car Inputs					Drag Calculations			Bolt Outputs			Plate Outputs
3	Turning Speed	30	mph	13.4	m/s	Density of air	1.3	kg/m^3	Bolt Area	12.33	mm^2	Beam Area	20.16	mm^2
4	Turning Radius	25	ft	7.6	m	Inner Speed	12.25	m/s	Bolt Shear Force	242	N	Beam Force	242	N
5						Outer Speed	14.57	m/s	Shear Stress	20	Mpa	Beam Stress	12.0	MPa
6	Plate Inputs					Half Wing Vertical Area	0.15	m^2	Factor of Safety	52.64		Factor of Safety	23.0
7	Thickness	0.125	in	3.18	mm	Drag Coefficient	1.98		Margin of Safety	34.09		Margin of Safety	14.3
8	Beam Width	0.25	in	6.35	mm	Inner Wing Drag	29.2	N
9	Tensile Strength	276	MPa			Outer Wing Drag	41.3	N	Steel Wire Outputs
10									Wire Area	0.85	mm^2	Wire Stiffness	9836	N/mm
11	Bolt Inputs					External Forces			Wire Tension	90	N	Wire Elongation	0.009	mm
12	Minor Diameter	0.156	in	3.96	mm	Centripetal Force	78	N	Wire Stress	106	Mpa	Y Deflection	0.008	mm
13	Shear Strength	150,000	psi	1034	MPa	Downforce	300.0	N	Factor of Safety	4.90
14						Inner Wing Drag	29	N	Margin of Safety	2.26
15	Steel Wire Inputs					Outer Wing Drag	41	N
16	Diameter	0.041	in	1.04	mm
17	Length	17.32	in	440	mm	System Forces
18	Tensile Strength	75,000	psi	517	MPa	Wing Drag	70	N
19	Modulus of Elasticity	200,000	MPa			Wing Moment	6	Nm
20						Normal Force on Wire	90	N
21	Front Wing Inputs					Outer Goosneck Y Reaction	190	N
22	Downforce	300	N			Inner Gooseneck Y Reaction	-75	N
23	Width	52	in	1.32	m	Bolt Shear Force	242	N
24	Height	9	in	0.23	m
25	Weight	3.3	kg
26	Drag force distance	18	in	0.46	m
27	Goosneck distance	7.5	in	0.19	m
28
29
30
31
32
33
34
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