MS Excell

EGR 110 - Excel Project 1 Part 1

House Plan Foundation Cost A local home builder is building ten houses and needs to know the cost to supply concrete in the footings to support the foundation of the house. The Architect provided us with the length of each footing (of each house plan). The local building code states that the width is 24 inches and the depth is 12 inches for all house plans. The Cost of concrete per cubic yard is $150 per cubic yard.

������ (��3) = �����ℎ (��) � ����ℎ (��) � ����ℎ (��) (must convert Width and Depth from inches to feet)

Also, you will then need to convert Volume for each from cubic feet, ft3, to cubic yard, yd3 because the cost is by cubic yard.

The assignment problem is to find cost of each foundation. You will need to set up the spreadsheet with the data and headings as below and use functions and formulas to calculate Width, Depth, Volume, and Total Cost.

����� ���� = ������ (��3) � ���� �� �������� ($/��3)

House Plan #

Length (ft)

Width (in)

Depth (in)

Width (ft)

Depth (ft)

Volume (Ft3 )

Volume (Yd3)

Cost $/yd3

Total Cost ($)

1 320 $150 2 448 3 550 4 682 5 736 6 870 7 904 8 927 9 952 10 983

Part 2

For part 2, using the same spreadsheet as before, switch to the second sheet tab or worksheet tab so that you will be working in the same Excel file for both parts.

Stress and Strain Tensile properties of metals may be determined by the standard testing. Applied loads are place on a specimen and the resulting elongations are measured. We will assume: A. Specimen material is ASI 1020 cold-rolled steel B. Loads are kips (thousand pounds) and stress in ksi (kips per square inch)

1. Click on spread sheet tab 2 and rename it as Stress vs Strain and then set up the spreadsheet with the following data and headings. Also, rename tab 1 as Foundation Cost. Note: This is not all the data collected on this actual test. It is only the straight line portion.

2. Determine the Stress by dividing load by the area of the test specimen. The diameter of the specimen is 0.71 inches. All results of calculations should display 3 decimal places.

3. Determine the Strain by dividing the elongation by the original length. The gauge length of the specimen is 8.05 inches.

4. Save the workbook and submit the finished workbook, ##ExcelProject1 (where ## are your initials) in the Assignment folder called Excel Project 1.

original gauge length [in.]