Your employer is planning to build several cylindrical storage tanks that will hold fuel. He has decided that all of the cylindrical storage tanks should be the same size, but due to space constraints, is unsure what the diameter and height of each tank should be. Also, he currently does not know exactly how much fuel he will need to store. You are tasked with creating a "flexible" spreadsheet for your employer that will calculate the total volume of several cylindrical storage Canks. The following requirements should be met: The input section should include inputs for: tank diameter (feet), tank height (feet), number of tanks built and total amount of fuel to be stored (gallons). • Enter the following values in the input section of your spreadsheet: o Tank Diameter (feet) = 28 o Tank Height (feet) = 20 O Number of Tanks Built (ea) = 3 o Total Amount of Fuel to be Stored (gal) = 275,000 The calculation section should compute: o Volume of One Tank (cubic feet AND gallons) o Total Volume of All Tanks (cubic feet AND gallons) Cylinder Volume = r²h, where r = radius, h = height. Unit conversion: 1 ft³ = 7.48 gallons. In the output section of your spreadsheet, add an IF statement that will compare the total volume of all tanks to the total amount of fuel to be stored: o If the total volume of all tanks is more than the total amount of fuel to be stored, the IF statement should display "Design OK. o If the total volume of all tanks is less than the total amount of fuel to be stored, the IF statement should compute (and display) the tank volume (in gallons) still required to hold the excess fuel.
Your employer is planning to build several cylindrical storage tanks that will hold fuel. He has decided that all of the cylindrical storage tanks should be the same size, but due to space constraints, is unsure what the diameter and height of each tank should be. Also, he currently does not know exactly how much fuel he will need to store. You are tasked with creating a "flexible" spreadsheet for your employer that will calculate the total volume of several cylindrical storage Canks. The following requirements should be met: The input section should include inputs for: tank diameter (feet), tank height (feet), number of tanks built and total amount of fuel to be stored (gallons). • Enter the following values in the input section of your spreadsheet: o Tank Diameter (feet) = 28 o Tank Height (feet) = 20 O Number of Tanks Built (ea) = 3 o Total Amount of Fuel to be Stored (gal) = 275,000 The calculation section should compute: o Volume of One Tank (cubic feet AND gallons) o Total Volume of All Tanks (cubic feet AND gallons) Cylinder Volume = r²h, where r = radius, h = height. Unit conversion: 1 ft³ = 7.48 gallons. In the output section of your spreadsheet, add an IF statement that will compare the total volume of all tanks to the total amount of fuel to be stored: o If the total volume of all tanks is more than the total amount of fuel to be stored, the IF statement should display "Design OK. o If the total volume of all tanks is less than the total amount of fuel to be stored, the IF statement should compute (and display) the tank volume (in gallons) still required to hold the excess fuel.
Related questions
Question
Transcribed Image Text:Your employer is planning to build several cylindrical storage tanks that will hold fuel. He has
decided that all of the cylindrical storage tanks should be the same size, but due to space
constraints, is unsure what the diameter and height of each tank should be. Also, he currently does
not know exactly how much fuel he will need to store. You are tasked with creating a "flexible"
spreadsheet for your employer that will calculate the total volume of several cylindrical storage
tanks.
The following requirements should be met:
• The input section should include inputs for: tank diameter (feet), tank height (feet), number of
tanks built and total amount of fuel to be stored (gallons).
Enter the following values in the input section of your spreadsheet:
O Tank Diameter (feet) = 28
o Tank Height (feet) = 20
o Number of Tanks Built (ea) = 3
O Total Amount of Fuel to be Stored (gal) = 275,000
• The calculation section should compute:
o Volume of One Tank (cubic feet AND gallons)
o Total Volume of All Tanks (cubic feet AND gallons)
Cylinder Volume = r²h, where r = radius, h = height.
Unit conversion: 1 ft3 = 7.48 gallons.
● In the output section of your spreadsheet, add an IF statement that will compare the total volume
of all tanks to the total amount of fuel to be stored:
o If the total volume of all tanks is more than the total amount of fuel to be stored, the IF
statement should display "Design OK."
o If the total volume of all tanks is less than the total amount of fuel to be stored, the IF
statement should compute (and display) the tank volume (in gallons) still required to hold the
excess fuel.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
