CE En 270 - Homework #7

Simply Supported Beam Spreadsheet

The following diagram represents a simply supported beam:

The load (P) is offset from the left end of the beam by a distance (a).  The following equations can be used to compute the vertical deflection (v) at any point (x) along the length of the beam:

Notice that the deflection equation is different depending on whether x is less than or greater than a.

a.  Write a spreadsheet that has the following variables:

Write the equations for the blue cells using the values in the yellow input cells.  Note that the deflection will be computed as a negative value.

b. Use input validation (the Validation command in the Data menu) to make sure the value entered for a is greater than zero and less than L.  Also, make sure the value entered for x is greater than or equal to zero and less than or equal to L.

c. Using the input values shown above, use the Goal Seek command to compute the two x locations that result in a deflection of -2.0 inches.  Write your answer somewhere on your spreadsheet for the TA to see.

d. Using the input values shown above, use the Solver command to find the x value resulting in the maximum deflection (v).  Note that you will actually be finding a minimum value since the deflection is negative.  When running the solver, you will need to add some constraints so that x does not go less than zero or greater than L.  Write your answer (both the deflection and the corresponding x value) somewhere on your spreadsheet for the TA to see.

Submittal Instructions:

Click here to upload your homework assignment.