{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

a2_cee3804_2011

# a2_cee3804_2011 - CEE 3804 Computer Applications in Civil...

This preview shows pages 1–2. Sign up to view the full content.

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.

{[ snackBarMessage ]}

### Page1 / 4

a2_cee3804_2011 - CEE 3804 Computer Applications in Civil...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online