A commercial solid steel shaft, 3ft long is supported by two bearings at either end. Using an Excel spreadsheet calculate the ASME shaft diameter (in), maximum deflection (in), and maximum twist (degrees) as a concentrated bending load at the midpoint of the shaft and a torsional load from a chain drive at one end increase from 0 to 20,000 lbs, in increments of 500 lb. Assume Kt=1.0, Kb=1.5, G=12 x 10^6 psi, E=30 x 10^6 psi, Pitch radius of gear drive is 3 in, and the allowable stress is 8000 psi. The final table should have the following columns:
Polar Moment of Inertia J [in^4]
Bending Load P [lb]
Torsional Load Ft [lb]
Bending Moment Mb [in-lb]
Torsional Moment Mt [in-lb]
Shaft Diameter [in]
Shaft Deflection Y [in]
Shaft Twist [degrees]