ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
beam_cantilever.xls
3
To determine deflection of a cantilever beam under superimposed loads
4
By Alex Slocum, 1/1/04, last modified 06/11/04 by Xue'en Yang
5
Enters numbers in BOLD, Results in RED
6
Schematic
7
8
9
10
11
12
13
14
15
16
17
18
19
Beam dimensions and propertiesValuesInstructions
20
Length, L (mm)2750Enter total length of beam in mm
21
Width, W (mm)300Enter width of beam in mm
22
Height, H (mm)450Enter height of beam in mm
23
Length increment, Linc (mm)27,5Enter length increment to be used in finite difference calculation
24
Modulus of elasticity, E (N/mm^2)200000Enter elastic modulus in N/mm^2
25
Moment of inertia, I (mm^4)2278125000 =1/12*W*H^3
26
Distance from farthest fiber to neutral axis, cc (mm)
225 = H/2
27
LoadingSee schematic for definitions of loads and positions
28
Point load, F (N)0Enter amplitude of the point load, in N
29
Location of point load, af (mm)0Enter location of the point load, in mm
30
Distributed load amplitude, wa, (N/mm)10000
Enter amplitude of the distributed load near the cantilever end, in N/mm
31
Distributed load amplitude, wL, (N/mm)1
Enter amplitude of the distributed load at the clamped end, in N/mm
32
Starting point of distributed load, aw (mm)50Enter location for wa, in mm
33
Moment load, M (N-mm)1250000000Enter amplitude of the applied moment, in N*mm
34
Location of moment load, am (mm)25Enter location of the moment load, in mm
35
Maximum deflection (microns)-99251,036Return maximum deflection along the beam in microns
36
Maximum slope (milli radians)47,531Return maximum slope along the beam in milli radians
37
Reactions at beam ends
38
RA, Ra (N)0,000Reaction force at A
39
RB, Rb (N)13501350,000Reaction force at B
40
MA, Ma (N)0,000Reaction moment at A
41
MB, Mb (N-mm)-23051215000,000Reaction moment at B
42
qA, ta (radians)0,047Rotation at A
43
qB, tb (radians)0,000Rotation at B
44
dA, da (mm)-99,251Deflection at A
45
dB, db (mm)0,000Deflection at B
46
47
Equations
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
Note: For other types of distributed loads, use principle of superposition
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100