Calculation Needed
Calculation Needed
(OP)
I'm trying to calculate the volume of a tank with a base that slopes in two directions. The four corners have different lengths. I can solve the problem with sorting the four different lengths.
Does anyone know of a formula that can calculate the volume just using the four measurements. They may or may not be equal and one or more can be zero.
Alternatively, does anyone know how to sort four rows of data without using an if command? I want to use the four values, but sort them by reference without using the Data menu...
Dik
Does anyone know of a formula that can calculate the volume just using the four measurements. They may or may not be equal and one or more can be zero.
Alternatively, does anyone know how to sort four rows of data without using an if command? I want to use the four values, but sort them by reference without using the Data menu...
Dik





RE: Calculation Needed
good luck
RE: Calculation Needed
Dik
RE: Calculation Needed
good luck
RE: Calculation Needed
RE: Calculation Needed
One of the maddening things about these fora is the difficulty in trying to convey questions clearly, using only words. Probably one sketch would make your question a lot clearer.
Nevertheless, it sounds like you have a rectangular tank (?) and know the plan dimensions of the rectangle (?). You also know the depth of the tank at each of its four (90°?)corners. You say the tank bottom slopes in two directions (?) but you don't say in what direction these slopes are or whether or not they are uniform. It sounds like you don't have enough information to calculate the volume, or you haven't told us everything you know.
If you have more information, please share it. If not, no spreadsheet can provide it for you. Also, it would help a lot if you answer the questions in the previous post.
good luck
RE: Calculation Needed
I'm trying to calculate the volume of a tank with a base that slopes in two directions.
Dik
RE: Calculation Needed
RE: Calculation Needed
RE: Calculation Needed
Cheers
Greg Locock
Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.
RE: Calculation Needed
RE: Calculation Needed
It is an overcosntrained solution. 3 depths define the plane, the fourth is along for the ride.
Cheers
Greg Locock
Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.
RE: Calculation Needed
htt
RE: Calculation Needed
If I understand it right, the shape of the tank is a truncated pyramid, then
CODE
Answering your second question about sorting without using data commands: try function LARGE in combination with MATCH or LOOKUP for associated columns.
yakpol
RE: Calculation Needed
One way to create a sorted list of input data is with the "SMALL" command. The input format is "=SMALL(array,k)" where "array" is the range of data you are trying to sort, and the function gives the k'th smallest value. You would have to input this formula once for each cell in the array, with k=1 to k=4 in the situation you describe.
NKT
RE: Calculation Needed
Dik