PLEASE READ Use the data below to solve the following prob

(PLEASE READ ) :)

Use the data below to solve the following problem using excel: ( I would like to know how do you input the formula for each situation, so please explain the process)

I will RATE and comment your answer accordingly

Problem 1 This problem deals with a beam supported at one end and with a single load W. More information about the equations of the beam can be found at: http://www.engineersedge.com/beam bending/beam bending10.htmm Figure 1. A simple beam supported at both ends. Source Nomenclature for beam deflection and stress calculation equations W-load (lb) E-Modulus of elasticity (lb/sq-in) I-Moment of inertia (in-in-in-in) x = distance from datum point (wall) to the station of the single point load (W) (units are inches) 1- beam length to point of single load (in) b- distance from single load point (W) to the end of the beanm v-distance past single point load W measured from the wall (in) = deflection (in) Task 1 Create an Excel function (no regular Excel calculations are allowed) to estimate the deflection of the beam (y) between the support (i.e., wall) and the load W. The function should take the following inputs: W, E, I (inertia), x, and 1 (length) 6EI Task 2 Create an Excel function (not just Excel calculations) to estimate the deflection of the beam (y) beyond the load W. The function should take the following inputs: W, E, I (inertia), x, and 1 (length) 6EI

Solution

Press Alt + F11.

This gets you to the Visual Basic Editor, where VBA is written

Choose InsertModule in the editor.

You have an empty code module sitting in front of you

Type this programming code

Function deflection(W As Double, E As Double, I As Double, X As Double, L As Double)
deflection = W * X ^ 2 * (3 * L - X) / (6 * E * I)
End Function

Save the function

Return to Excel. and Click the Insert Function button on the Formulas tab to display the Insert Function dialog box cleck ok

.