HW #9
CE 432/532, Spring 2008
1 / 2
Beam Analysis Using a Spreadsheet
Use the spreadsheet you developed for HW #8 to analyze the beams below. For each beam:
1. Analyze the beam using your spreadsheet. Print a copy of the spreadsheet input and
output.
2. Draw the deflected shape of the beam. Indicate the magnitude of all displacements
(deflections and rotations).
3. Draw an exploded free body diagram of the beam showing the member end forces.
Also draw the shear and moment diagrams.
Problem 1.
4
I = 1000 in
E = 3,000 ksi
10 k
1.0 klf
20 k
10 ft
8 ft
17 ft
Problem 2.
4
I = 100 in
E = 29,000 ksi
1.5 klf
1.5 klf
10 k
20 ft
15 ft
15 ft
20 ft
Answers:
- - - - - Problem 1 - - - - - -
- - - - - Problem 2 - - - - - -
Dispalcement
Element‐End Forces
Dispalcements
Element‐End Forces
‐4.54E‐01
‐1.00E+01
0.00E+00
1.25E+01
5.54E‐02
‐9.41E‐14
‐1.67E‐02
0.00E+00
0.00E+00
2.00E+01
0.00E+00
1.75E+01
2.34E‐02
‐1.50E+02
8.59E‐03
‐4.90E+01
0.00E+00
1.96E+01
0.00E+00
5.00E+00
‐1.28E‐03
1.50E+02
‐8.59E‐03
4.90E+01
4.00E‐01
0.00E+00
5.00E+00
0.00E+00
1.67E‐02
‐4.90E+01
1.75E+01
4.90E+01
1.25E+01
0.00E+00