Excel for engineering homework

College of Engineering and Computing Department of Civil and Environmental Engineering

CGN 2420 - Computer Tools for Civil Engineers

Homework #1

Recommended practice

Solve the following problems from your Excel textbook answering all questions required for each problem. Problems are found at the end of each chapter.

Chapter 1: Fluid Statics application, and problems 1.3, 1.5

Chapter 2: Loan Amortization Table application, and problems 2.3, 2.4

Chapter 3: Material Testing application, and problems 3.3, 3.4, 3.7, 3.8, 3.9, 3.10

Chapter 4: Statics application-Resolving Forces, and problems 4.3, 4.5, 4.8, 4.9, 4.12

Mandatory Homework

1. The velocity (u) of a non-Newtonian fluid flowing in a circular pipe can be expressed as:

𝑢(𝑟)

𝑢 =

3𝑛 + 1

𝑛 + 1 1 −

𝑟

𝑅

Where 𝑢 is the mean velocity of the fluid in the pipe section, r is the radial distance from the center of the pipe, R is the pipe radius, and n is a constant whose value depends on the fluid (for example, n = 1 for a Newtonian fluid, n = 1.62 for a non-Newtonian fluid, and n = 3 for a dilatant fluid).

For 𝑢 = 12 ft/s and 𝑅 = 6”, plot 𝑢(𝑟) for a Newtonian fluid, non-Newtonian fluid, and for a dilatant fluid. Compare the three profiles in the same plot. Use different colors for the profiles and include the corresponding legend.

𝑢

𝑢(𝑟) 𝑟

𝑟 = 𝑅

2.- On average, the surface area A of human beings is related to weight W and height H. Measurements of a number of American individuals of height 180 cm and different weights (kg) give values of A (m2) in the following table:

W (kg) 70 75 77 80 82 84 87 90 A (m2) 2.10 2.12 2.15 2.20 2.22 2.23 2.26 2.30

a) Plot the data in a scatter plot.

b) Fit two or three different trendlines to the data (show equations on chart).

c) Predict body surface area for an individual weighting 120 Kg. Use the best mathematical model

(equation) to predict this value.

d) Compare your prediction in part (c) with the result using Du Bois formula:

BSA = 0.007184 × W0.425 × H0.725

where BSA is body surface area represented in m2, W is weight in kg, and H is height in cm.

Solve the two problems in only ONE Excel file, with one problem per worksheet.

Save the file as Homework#1_NAME_LASTNAME.

Please upload your file on Canvas and submit it on time.