In structural engineering applications, it is often necessary to predict the deflection at the tip of a cantilever beam. Write a spreadsheet to compute the deflection of a cantilever beam using the following parameters and equations:

Beam cross-section:

where:

P = applied load a = length from fixed end to applied load E = modulus of elasticity of beam material I = moment of inertia of the beam = d = deflection of beam =

Known quantities:

E = 5500 lb/in ^{2}B = 7 in H = 14 in

**Problem:**

Write a spreadsheet to compute the deflection of the tip of the beam as a function of the applied load. The spreadsheet should have the following features:

a. Create a drawing of the cantilever beam as shown above using the
built-in drawing tools in Excel. **Do not copy.** Embed the
drawing shown above.

b. Use the Equation Editor (Insert|Symbols|Equation) to add a drawing of the equations shown above for the moment of inertia and beam deflection.

c. Assume that a = 30 in and length = 60 in. Make a table showing deflection vs. P. Let P vary from 0 - 500 lbs in increments of 50 lbs. Make a plot showing deflection vs. P.

d. Solve the deflection equation shown above for P (you should do this
manually). Add another table to your spreadsheet to compute the load (P)
which would result in a deflection of 2 in assuming that the load is
applied at the end of the beam (a = L) and the beam length varies from 30
in to 60 in by increments of 3 in. Make a graph of your solution (P vs.
L). Note: Do not use **
a**
from the previous table!

In summary, you may want to lay out your spreadsheet something like this:

1. Be sure to save the changes to your spreadsheet.

2. Upload your spreadsheet via Learning Suite.