a2_cee3804_2011

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

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

View Full Document Right Arrow Icon
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 ).
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/01/2012 for the course CEE 3804 taught by Professor Aatrani during the Spring '07 term at Virginia Tech.

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 Right Arrow Icon
Ask a homework question - tutors are online