Reference no: EM13555043
Design a spreadsheet to estimate the dimensions of a tank for holding water. The spreadsheet should use input values from the user to return the height and diameter for a tank that will use the smallest amount of steel and therefore cost the least to produce.
Attached you will find an example of how a working spreadsheet should look. The layout of the sheet that you design does not have to match the layout of this example, but your spreadsheet must use the same input values and return the same results.
The spreadsheet must be capable of approximating the lowest cost dimensions for any value of the input variables.
The "Input Variables" are Volume (gal), Price of Steel ($/lb), Budget ($), Thickness (in), and Density (lb/ft^3).
The Calculations: Diameter (ft) are given and are 2-9. Height (ft), Surface area (ft^2), steel volume (ft^3), and cost ($).
The Results: Cost ($), under budget?, Diameter (ft), Height (ft).
|
Calculate the atmospheric pressure head
: A barometer filed with non-toxic glycerin is used to measure standard sea level atmospheric pressure. neglecting the effect vapor pressure and surface tension. calculate the atmospheric pressure head.
|
|
How many days will it take for 90 per- cent of the chemical
: How long will it take for 99 percent of the chemical to be destroyed? (c) How long will it take for 99.9 percent of the chemical to be destroyed?
|
|
What is the length of shrinkage
: A meter long steel plate with a rectangular cross section(10mm x 50mm) is resting on a frictionless surface under the sun.the plate temperature is measures to be at 40C.the plate is then moved into a cold room and is left to rest on a frictionless su..
|
|
How many revolutions did the disc make during this time
: a spinning disc rotating at 130 rev/min slows and stops 31 s later. how many revolutions did the disc make during this time
|
|
Design a spreadsheet to estimate the dimensions of a tank
: Design a spreadsheet to estimate the dimensions of a tank for holding water. The spreadsheet should use input values from the user to return the height and diameter for a tank that will use the smallest amount of steel and therefore cost the least to..
|
|
Calculate the mass of the aluminum chunk
: A student drops two metallic objects into a 120 g steel container holding 150 g of water at 25°C. What is the mass of the aluminum chunk
|
|
What is the total distance traveled during time interval
: A Particle is traveling on a straight line with velocity v=(3t^2-6t) where t is in sec. if s=4 ft when t=0, determine the position of the particle when t=4s. what is the total distance traveled during time interval t=0 to t=4s?
|
|
What is the linear speed of the sphere
: A solid sphere of mass 4.0 kg and radius 0.12 m starts from rest at the top of a ramp inclined 15' degree and rolls to the bottom. What is the linear speed of the sphere when it reaches the bottom of the ramp
|
|
Estimate the net rate at which the sphere radiates energy
: A sphere that is a perfect blackbody radiator has a radius of 0.120 m and is at 200°C in a room where the temperature is 20°C. Calculate the net rate at which the sphere radiates energy
|