Question
Using an Excel spreadsheet keeping the beam geometry the same, find the maximum permissible load F for each material considering the following cases
Using an Excel spreadsheet keeping the beam geometry the same, find the maximum permissible load "
F
" for each material considering the following cases in your analysis (starting from zero, increase the center load by
2000lb_(f)
increments):\ Maximum deflection considerations (loss of function
y_(max)=0.25
inch; therefore, maximum allowable midspan deflection
=0.125
inch, factor of safety
=2
)\ Maximum stress considerations (
\\\\sigma
shall not exceed
(S_(y))/(2)
of the material, factor of safety
=2
)\ Minimum cost considerations (which material can handle the highest load at minimum cost?)\ Minimum weight considerations (which material is the lightest weight and able to handle maximum load?)\ Show all formulas and label all cell ranges.\ Upload your EXCEL spreadsheet to Blackboard HW 2\ Neatness counts! Make sure I can follow your work.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started