Show a chart of results that will display the relationship

Assignment Help Mechanical Engineering

Reference no: EM131381963

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?

Reference no: EM131381963

Questions Cloud

Paper topic - childhood obesity in saudi arabia : Term paper topic: Childhood obesity in Saudi Arabia. There is significant evidence for the existence of worldwide increase of obesity in children

What’s the probability that you win the tv : After hearing some protest about the plan, the organizers decide to award the prize by not returning the white balls to the box, thus ensuring that 1 of the 100 people will draw the red ball and win the TV. Now what position in line would you choo..

How many different outfits can she make : Michelle works at a western themed restaurant. She has to wear jeans with a white shirt and a bolo tie. She has 3 pairs of jeans, 4 white shirts, and 2 bolo ties. How many different outfits can she make?

What kind of learning or experience matters most : Beyond merely summarizing the object(s) being portrayed, the most common (and in many ways, the easiest) ways to analyze a painting are-To talk about its affects on ME,To talk about the life and psychology of the artist.This course would not be do..

Show a chart of results that will display the relationship : 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.

What role did the pharmacist have as a patient advocate : Discuss the rights and expectations that a patient has when interacting with an organization or person providing some level of healthcare services. What role did the pharmacist have as a patient advocate? Did he uphold that obligation

What''s the probability that a recalled car is american : Recalls. In a car rental company's fleet, 70% of the cars are American brands, 20% are Japanese, and the rest are German. The company notes that manufacturers' recalls seem to affect 2% of the American cars, but only 1% of the others.

What kind of information would found on financial statements : What kind of information would be found on the financial statements? Explain how the users of these statements could use the information to help make better informed decisions.

Calculate the slope of the elastic curve at the tenth points : Write a program that will calculate the slope of the elastic curve at the tenth points of the span for a cantilever beam subjected to a concentrated load at its free end.

User Account

All Pages