CEE 3804: Computer Applications in Civil Engineering
Spring 2011
Assignment 2: Excel Functions
Date Due: February 8, 2011
Instructor: Trani
Show all your work including VBA code and results of your computation in the spreadsheet as screen captures.
Problem 1
A set of formulas to calculate the deflection (
y
) and the maximum angle of deflection (
δ
max
) of a cantilever beam with a point
load P applied at the end of the beam are shown below.
y
=
Px
2
6
EI
(3
l
−
x
)
δ
max
=
Pl
3
3
EI
where:
y
is the deflection at any point along the beam (inches)
x
is the distance from the support point to any point in the beam (inches)
l
is the length of the beam (inches)
P
is the point load applied at the end point (lb)
E
is the Young’s modulus of elasticity (lb/in
2
)
I
is the beam inertia (in
4
)
a) Create an Excel Function (using Visual Basic For Applications) to calculate the deflection of a 400 inch beam deflection
(y) at points along the beam x spaced every 5 inches. The function created in Excel needs to have the following
arguments in the function list: x,
l
, P, E and
I
. These are inputs needed to estimate the deflection y. Use the following
numerical values: P = 5000 lb, E = 2.9e7 (lb/in
2
) and I = 100 (in
4
).
b) For the beam described in part (a) estimate the maximum deflection of a family of 400 inch long beams with inertias
ranging from 40 to 125 (in
4
).
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
This is the end of the preview.
Sign up
to
access the rest of the document.
 Spring '07
 AATrani
 Normal Distribution, Variance, probability density function, Inch

Click to edit the document details