For the following computer problem, any appropriate softwaremay be used. Input prompts sho...

For the following computer problem, any appropriate softwaremay be used. Input prompts should fully explain what isrequired 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 for the centroid location of built-up areas such as shown in Problems 1 and 2. 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 centroid location and display the result. Vary a single shape or dimension and observe how the location of the centroid is affected.

Problem 1

For the following problem, refer to Appendix G if unit weights are not stated.

A built-up steel member is composed of a W18 × 50 wide-flange section with a 12-in.-by  in. plate welded to its top flange, as shown. Locate the X−X centroidal axis.

Problem 2

For the following problem, refer to Appendix G if unit weights are not stated.

Locate the X−X and Y−Y centroidal axes for the built-up structural steel areas shown.