Homework Help is Here – Start Your Trial Now!
Engineering
Civil Engineering
I can't figure out what I'm doing wrong. I placed the following formula for column B: =1.94*32.2*A3/144 and the following formulas to find what the water level should be at 70 psi: =D3/(1.94*32.2)

I can't figure out what I'm doing wrong. I placed the following formula for column B: =1.94*32.2*A3/144 and the following formulas to find what the water level should be at 70 psi: =D3/(1.94*32.2)

Structural Analysis
Structural Analysis
6th Edition
ISBN:9781337630931
Author:KASSIMALI, Aslam.
Publisher:KASSIMALI, Aslam.
Chapter2: Loads On Structures
Section: Chapter Questions
Problem 1P
See similar textbooks
icon
Related questions
Question
100%

I can't figure out what I'm doing wrong. I placed the following formula for column B:
=1.94*32.2*A3/144

and the following formulas to find what the water level should be at 70 psi:

=D3/(1.94*32.2)

E4 A B 1 Height (ft) Water Pressure (lb/in²) 20 0.00 3 10 4 20 5 30 6 40 7 50 8 60 9 70 10 80 fxx 4.34 8.68 13.01 17.35 21.69 26.03 30.37 34.70 =D3/(1.94*32.2) с D E 70 lb/in² (psi) water level = 1.12057373 F
Transcribed Image Text:E4 A B 1 Height (ft) Water Pressure (lb/in²) 20 0.00 3 10 4 20 5 30 6 40 7 50 8 60 9 70 10 80 fxx 4.34 8.68 13.01 17.35 21.69 26.03 30.37 34.70 =D3/(1.94*32.2) с D E 70 lb/in² (psi) water level = 1.12057373 F
Recall that the function of a water tower is to create a desirable municipal water pressure for households and other usage in a town. To achieve this purpose, water is stored in large quantities in elevated tanks. Also recall that the municipal water pressure may vary from town to town, but it generally falls somewhere between 50 and 80 lb/in² (psi). In this assignment, use Excel to create a table that shows the relationship between the height of water above ground in the water tower and the water pressure in a pipeline located at the base of the water tower. The relationship is given by P = pgh, where we have the following. P = the water pressure at the base of the water tower in pounds per square foot (lb/ft²) p = the density of water in slugs per cubic foot, p = 1.94 slugs/ft³ g = the acceleration due to gravity, g = 32.2 ft/s² h = the height of water above ground in feet (ft) In Excel, create a table that shows the water pressure in lb/in2 in a pipe located at the base of the water tower as you vary the height of water in increments of 10 ft. Also plot water pressure (lb/in2) versus the height of water in feet. (Submit a file with a maximum size of 1 MB.) Choose File No file chosen This answer has not been graded yet. What should be the water level in the water tower to create 70 psi water pressure in a pipe at the base of the water tower? (Enter the height in feet above ground.)
Transcribed Image Text:Recall that the function of a water tower is to create a desirable municipal water pressure for households and other usage in a town. To achieve this purpose, water is stored in large quantities in elevated tanks. Also recall that the municipal water pressure may vary from town to town, but it generally falls somewhere between 50 and 80 lb/in² (psi). In this assignment, use Excel to create a table that shows the relationship between the height of water above ground in the water tower and the water pressure in a pipeline located at the base of the water tower. The relationship is given by P = pgh, where we have the following. P = the water pressure at the base of the water tower in pounds per square foot (lb/ft²) p = the density of water in slugs per cubic foot, p = 1.94 slugs/ft³ g = the acceleration due to gravity, g = 32.2 ft/s² h = the height of water above ground in feet (ft) In Excel, create a table that shows the water pressure in lb/in2 in a pipe located at the base of the water tower as you vary the height of water in increments of 10 ft. Also plot water pressure (lb/in2) versus the height of water in feet. (Submit a file with a maximum size of 1 MB.) Choose File No file chosen This answer has not been graded yet. What should be the water level in the water tower to create 70 psi water pressure in a pipe at the base of the water tower? (Enter the height in feet above ground.)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Unit conversion
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, civil-engineering and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Structural Analysis
Structural Analysis
Civil Engineering
ISBN:
9781337630931
Author:
KASSIMALI, Aslam.
Publisher:
Cengage,
Structural Analysis (10th Edition)
Structural Analysis (10th Edition)
Civil Engineering
ISBN:
9780134610672
Author:
Russell C. Hibbeler
Publisher:
PEARSON
Principles of Foundation Engineering (MindTap Cou…
Principles of Foundation Engineering (MindTap Cou…
Civil Engineering
ISBN:
9781337705028
Author:
Braja M. Das, Nagaratnam Sivakugan
Publisher:
Cengage Learning
Fundamentals of Structural Analysis
Fundamentals of Structural Analysis
Civil Engineering
ISBN:
9780073398006
Author:
Kenneth M. Leet Emeritus, Chia-Ming Uang, Joel Lanning
Publisher:
McGraw-Hill Education
Sustainable Energy
Sustainable Energy
Civil Engineering
ISBN:
9781337551663
Author:
DUNLAP, Richard A.
Publisher:
Cengage,
Traffic and Highway Engineering
Traffic and Highway Engineering
Civil Engineering
ISBN:
9781305156241
Author:
Garber, Nicholas J.
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS