Develop a spreadsheet application that will calculate the maximum deflection of a simply supported beam subjected to a fullspan uniformly distributed load w and a point load P at midspan. The allowable deflection is to be Span/x where x will be user input. Additionally, user input will be w, P, modulus of elasticity E, and moment of inertia I. Calculated deflection and allowable deflection are to be to 0.001 in. span lengths are to range from 10 ft to 30 ft in increments of 1 ft. Show a chart of the results that will display the relationship between calculated and allowable deflection at each value of span length. Use the spreadsheet to verify the solutions for Problems 1 and 2.

Problems 1
Compute the maximum deflection of a 10-in.-by-14-in. simply supported solid rectangular redwood (S4S) beam. The span length is 15 ft and the beam is subjected to a uniformly distributed load of 1000 lb/ft. The allowable deflection is 1 300 of the span length. Is the beam satisfactory?

Problems 2
A W12×30 structural steel beam is simply supported on a span of 12 ft. It is subjected to a uniformly distributed load of 675 lb/ft and a concentrated load of 14,000 lb at midspan. The allowable deflection is 1 360 of the span. Is the beam satisfactory?