The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Hi guys,

I know this is not the usual tech-related question but it does involve some formula making in Excel. I have a series of tanks (aproximately 500 barrels each) with a somewhat strange shape and I need to be able to calculate the amount that is contained in each one based on the level of the liquid contained in each one. Today I'm using a simple volume formula that I use on normal tanks but these ones have a ladder so it's kinda complex.

I'm attaching a simple image of the side and top views of the tanks so you have an idea of what I'm talking about. What I would like to do is divide/split the tanks in 3 areas so I can re-measure each tank (they'r not exactly the same size) and use the same formula for every tank. If I do it like this, all I have to do is calculate the volume of 2 rectangles and 1 3D triangle.

The problem is that I don't know how to measure or how to make a formula that progressively calculates the volume in that triangle part (below the stairs).

Hope someone can help me with this.

Thanks in advance!

sshot-2013-12-07--1-.png

I know this is not the usual tech-related question but it does involve some formula making in Excel. I have a series of tanks (aproximately 500 barrels each) with a somewhat strange shape and I need to be able to calculate the amount that is contained in each one based on the level of the liquid contained in each one. Today I'm using a simple volume formula that I use on normal tanks but these ones have a ladder so it's kinda complex.

I'm attaching a simple image of the side and top views of the tanks so you have an idea of what I'm talking about. What I would like to do is divide/split the tanks in 3 areas so I can re-measure each tank (they'r not exactly the same size) and use the same formula for every tank. If I do it like this, all I have to do is calculate the volume of 2 rectangles and 1 3D triangle.

The problem is that I don't know how to measure or how to make a formula that progressively calculates the volume in that triangle part (below the stairs).

Hope someone can help me with this.

Thanks in advance!

sshot-2013-12-07--1-.png

D = fluid depth

Lx = total internal length of tank

Wx = total internal width of tank

Lt = length of triangular area below stairs (to fluid depth)

Ws = width of stairs

On that basis,

total tank volume is obviously:

Lx * Wx * D

and volume of area lost due to the stairs is:

1/2 x (Lx * D) * Ws

The only tricky bit is to calculate Lx

and you could do that with either trig:

Tan (a) = Opp/Adj [where a is the stair angle]

Opp would equal the fluid depth D, and Adj would = Lx

rearranged would give Lx = D/Tan(a)

Or you could use pythagoras

- all depending how easy it is to measure your tank.

It might also help if you have any sample dimensions for us to work with?

and volume of area lost due to the stairs is:

1/2 x (Lx * D) * Ws

should be

and volume of area lost due to the stairs is:

1/2 * (Lx * D) * Ws

Take the following dimensions as example:

D = 20"

Lx = 45'

Wx = 7'

Ws = 3.3'

angle = 35°

Thanks again ;)

D = 50 cms

Lx = 14 mts (1400 cms)

Wx = 2.4 mts (240 cms)

Ws = 1 mt (100 cms)

angle = 35°

As for the final result, we use m3 (cubic meters).

I'm trying to apply the formulas you stated above but I'm missing where you use Lt. Actually I'm a little confused about what Lt means. Is it the new "adjacent" side created by the fluid's level?

Thanks again man... no hurry ;)

There's an image of the whole tank, the part of the stairs, the same part with measures and another one with a triangle I would have to draw in my mind in order to "close" the triangle.

The stairs themselves are not there... they just go on top of the ramp.

Also once the ramp reaches the top there's a rest. It doesn't really matter as we don't fill the tanks that high. Maybe 15 - 20 centimeters bellow it.

Tanque-01---Vista-compelta-later.png

Tanque-01---Vista-lateral-escale.png

Tanque-01---Vista-lateral-escale.png

Tanque-01---Vista-lateral-escale.png

All Courses

From novice to tech pro — start learning today.

Some of your dimensions are contradictory - stair width is shown as both 1m and 0.84m? I went with the 0.84...

Also, some dimensions are madly precise? The two lower lengths are to 1/100th of a cm???

I also ignored the top landing, as you say you don't fill that high.

Nice diagrams, by the way - what did you use to draw them?

Tank-Volume.xlsx