For the following computer Problem, any appropriate software may be used. Input prompts sh...

For the following computer Problem, any appropriate software may be used. Input prompts should fully explain what is required of the user (the program should be user-friendly). The resulting output should be well labeled and self-explanatory.

Develop a spreadsheet application that will calculate the maximum deflection of a simply supported beam subjected to a full-span 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 Problem 1 and 2.

Problem 1

For Problem, use the formula method.

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  of the span length. Is the beam satisfactory?

Problem 2

For Problem, use the moment-area method.

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  of the span. Is the beam satisfactory?