Problem Set 7 for CEE 379: Truss Analysis using Excel - Prof. Marc Eberhard, Assignments of Civil Engineering

Problem set 7 for the cee 379 course focusing on truss analysis using excel. Students are required to develop a spreadsheet to automatically compute element stiffness matrices, equations of equilibrium, joint displacements, member forces, and axial stresses for various load conditions. The problem set includes three different load scenarios.

Typology: Assignments

Pre 2010

Uploaded on 03/10/2009

koofers-user-4xu
koofers-user-4xu 🇺🇸

3

(1)

10 documents

1 / 2

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
CEE 379 Problem Set 7 Autumn 2007
(Due Nov. 2nd, in class or 4:30 PM in 233 More)
Problem 1. Consider the same truss (shown in the figures below) that you considered in
Problem Set 4. For each member, the elastic modulus, E = 29,000 ksi. the cross-sectional
area, A = 8 in.2 and the yield stress is 50 ksi.
USING EXCEL, develop a spreadsheet to automatically complete this problem and the
next one. The equations should be dynamic, such that updating the member properties,
jont locations and applied forces should automatically lead to the updating of the end
displacements and member forces.
For each problem, submit the printout of a neat spreadsheet output, in which major results
are clearly identified.
a) Compute the element stiffness matrix, k, for each of the six truss members.
b) Express the equations of equilibrium at the free kinematic DOF in terms of the
applied external loads, the member properties and the displacements at the free kinematic
DOF. (i.e., Qk = K11Du)
c) For θ = 135 degrees, compute the unknown joint displacements, and sketch the
deflected structure.
d) For θ = 135 degrees, compute the element forces at the end of each truss member.
Then, show the member axial forces on a neat drawing of the structure.
e) Compute the axial stress in each member. (σ = P/A). Compare this value with
the yield stress? Which members have yielded, if any?
12 ft
15
ft
15
ft
15
ft
θ
P2=5
0k
1
4
2
3
5
6
2
1
4
3
6
5
8
7
DOF
θ
P1=20k
pf2

Partial preview of the text

Download Problem Set 7 for CEE 379: Truss Analysis using Excel - Prof. Marc Eberhard and more Assignments Civil Engineering in PDF only on Docsity!

CEE 379 Problem Set 7 Autumn 2007

(Due Nov. 2nd, in class or 4:30 PM in 233 More)

Problem 1. Consider the same truss (shown in the figures below) that you considered in Problem Set 4. For each member, the elastic modulus, E = 29,000 ksi. the cross-sectional area, A = 8 in. 2 and the yield stress is 50 ksi.

USING EXCEL, develop a spreadsheet to automatically complete this problem and the next one. The equations should be dynamic, such that updating the member properties, jont locations and applied forces should automatically lead to the updating of the end displacements and member forces.

For each problem, submit the printout of a neat spreadsheet output, in which major results are clearly identified.

a) Compute the element stiffness matrix, k, for each of the six truss members.

b) Express the equations of equilibrium at the free kinematic DOF in terms of the applied external loads, the member properties and the displacements at the free kinematic DOF. (i.e., Qk = K 11 Du )

c) For θ = 135 degrees, compute the unknown joint displacements, and sketch the deflected structure.

d) For θ = 135 degrees, compute the element forces at the end of each truss member. Then, show the member axial forces on a neat drawing of the structure.

e) Compute the axial stress in each member. (σ = P/A). Compare this value with the yield stress? Which members have yielded, if any?

12 ft

15 ft

15 ft (^15) ft

θ

P2=50k

1

4

2 3

5

6

2 1 4 3 6 5

8

7

DOF

θ

P1=20k

Problem 2.

Repeat all of Problem 1, but assume that the top node (DOF #1 and 2) is initially located 6 ft above the location shown in the sketch. The other nodes are initially located in the same location as shown on the sketch. If the original spreadsheet was written correctly, this problem should take only a few minutes to complete.

Problem 3. Consider again the original truss geometry shown in the sketches above. Assume that the load at the top joint (DOF #1 and #2) remains the same, but now, assume that imposed displacements of 0.05 in. to the right, 0.04 inches downward and 0.03 inches to the right are imposed at DOF #3, #4 and #5.

a) For θ = 135 degrees, compute the unknown joint displacements, and sketch the deflected structure.

b) For θ = 135 degrees, compute the element forces at the end of each truss member. Then, show the member axial forces on a neat drawing of the structure.

c) Compute the axial stress in each member. (σ = P/A). Compare this value with the yield stress? Which members have yielded, if any?

You may solve this problem by modifying the spreadsheet from Problem 1, or by taking the key results from Problem 1 and computing the answer with paper and pencil.

YOU MAY WORK ALONE OR IN GROUPS OF 2 ON THIS PROBLEM SET.

PLEASE NEATLY WRITE THE NAMES OF BOTH GROUP MEMBERS ON THE

FRONT PAGE OF THE ASSIGNMENT.