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)

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)
Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)
5th Edition
ISBN:9781305084766
Author:Saeed Moaveni
Publisher:Saeed Moaveni
Chapter14: Computational Engineering Tools Electronic Spreadsheets
Section: Chapter Questions
Problem 3P
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Engineering Fundamentals: An Introduction to Engi…
Engineering Fundamentals: An Introduction to Engi…
Civil Engineering
ISBN:
9781305084766
Author:
Saeed Moaveni
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS