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. For spreadsheet problems, any appropriate software may be used.

Use a spreadsheet program to solve one or more of the following: Example 8-4, Problem 1, 2, or 3. The user should be able to input the appropriate geometric properties for any shapes of the types shown and the program should then determine the appropriate quantities and display the result(s). Vary a single shape or dimension and observe the effect on the properties of the built-up cross section.

Problem 1

For the cross-sectional areas shown, calculate the moment of inertia with respect to the horizontal X–X centroidal axis.

Problem 2

Calculate the moments of inertia of the built-up steel member shown with respect to both centroidal axes.

Problem 3

Calculate the least radius of gyration for the areas shown. Use nominal timber sizes.