Generate a spreadsheet for the design of a tubular

Chapter 16, Problem 16.2SS

(choose chapter or problem)

Generate a spreadsheet for the design of a tubular composite shaft (Design Example 16.1) that is, for determining which of available fiber materials provide the required stiffness, and, of these possibilities, which cost the least. The fibers are continuous and are to be aligned parallel to the tube axis. The user is allowed to input values for the following parameters: inside and outside tube diameters, tube length, maximum deflection at the axial midpoint for some given applied load, maximum fiber volume fraction, elastic moduli of matrix and all fiber materials, densities of matrix and fiber materials, and cost per unit mass for the matrix and all fiber materials.