Beam Analysis Using A Spreadsheet (Hw 9)

ADVERTISEMENT

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 

ADVERTISEMENT

00 votes

Related Articles

Related forms

Related Categories

Parent category: Business
Go
Page of 2