Using excel how can i get hc Part 1 - Problem Statement:Vertical tanks with a conical base are often used for storing solids such as grain, salt,and gravel. The sloping sides prevent plugging as the material is withdrawn.Variables:h = height of the tankh = height of the conical sectionD = diameter of the tank❖r = radius of the conical section.0= angle of the conical section is 0.Determine:Develop a table at 1 ft intervals (from 0 to 20 ft inheight) that summarizes the volume of the tankAssume the following:h = 20 ftD = 10 ft0 = 35 degreesHelpful Equations:Volume of a Cone:V = = πr²hVolume of a cylinder:π(27)²(h – n.)V =D-diameter of tankrhhc

Answered: Part 1 - Problem Statement: Vertical…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Using excel how can i get hc

Part 1 - Problem Statement:
Vertical tanks with a conical base are often used for storing solids such as grain, salt,
and gravel. The sloping sides prevent plugging as the material is withdrawn.
Variables:
h = height of the tank
h = height of the conical section
D = diameter of the tank
❖
r = radius of the conical section.
0= angle of the conical section is 0.
Determine:
Develop a table at 1 ft intervals (from 0 to 20 ft in
height) that summarizes the volume of the tank
Assume the following:
h = 20 ft
D = 10 ft
0 = 35 degrees
Helpful Equations:
Volume of a Cone:
V = = πr²h
Volume of a cylinder:
π(27)²(h – n.)
V =
D-diameter of tank
r
h
hc

Expert Solution

Step 1

To calculate the volume of the tank using Microsoft Excel, you can use the following steps:

Create a table with two columns: "Height" and "Volume".
In the "Height" column, enter values from 0 to 20 in increments of 1 (for a total of 21 rows).
In the "Volume" column, enter a formula to calculate the volume based on the height and the given variables. To calculate the radius of the conical section, use the formula: r = D/2. To calculate the volume, use the formula: V = (π/3) * r^2 * h, where π is the mathematical constant pi (approximated as 3.14159).
Copy the formula down the column to calculate the volume for each height.
The resulting table will show the volume of the tank at 1-foot intervals, from 0 to 20 feet in height.

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions