Chat with us, powered by LiveChat EGR 110 - Excel Project 1 Part 1 House Plan Foundation Cost A local home builder - Writeedu

## 22 Jun EGR 110 – Excel Project 1 Part 1 House Plan Foundation Cost A local home builder

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.]

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

Do you need an answer to this or any other questions?

Do you need help with this question?

Get assignment help from WriteEdu.com Paper Writing Website and forget about your problems.

WriteEdu provides custom & cheap essay writing 100% original, plagiarism free essays, assignments & dissertations.

With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Chat with us today! We are always waiting to answer all your questions.