Solved

Calculate volume progressively on a triangle

Posted on 2013-12-07
10
419 Views
Last Modified: 2013-12-07
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
0
Comment
Question by:Caracena
  • 6
  • 4
10 Comments
 
LVL 23

Expert Comment

by:DanCh99
ID: 39703115
I'd say the easiest way to calculate this is to view the tank as one very large cuboid, and then to SUBTRACT the triangular prism volume occupied by the stairs.  

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.
0
 
LVL 23

Expert Comment

by:DanCh99
ID: 39703120
by the way... I can't see all your comment starting with "The 3 areas where I have to calculate the ...."

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

Expert Comment

by:DanCh99
ID: 39703121
minor correction:
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
0
 
LVL 6

Author Comment

by:Caracena
ID: 39703136
Thanks for the answers DanCh99.

Take the following dimensions as example:

D = 20"
Lx = 45'
Wx = 7'
Ws = 3.3'
angle = 35°

Thanks again ;)
0
 
LVL 23

Expert Comment

by:DanCh99
ID: 39703254
Thanks, Caracena - I'll work on this a bit later, no time now, but will come back to you.  I'm a metric boy, but can happily convert all your info above.  What's your desired final unit of capacity - US gallons, etc?
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
LVL 6

Author Comment

by:Caracena
ID: 39703269
Hi Dan. We use metric too hehe. Here they are in metrics:

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 ;)
0
 
LVL 6

Author Comment

by:Caracena
ID: 39703522
Ok, here is a 3D drawing of one of the tanks. There are like 5 different models of tanks but this is the more complex so I grabbed this one to try and understand how to measure the volume correctly under those stairs.

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
0
 
LVL 23

Accepted Solution

by:
DanCh99 earned 500 total points
ID: 39703654
OK, try this file for size, it's pretty self-explanatory.

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
0
 
LVL 6

Author Comment

by:Caracena
ID: 39703686
Dan, you are really good man! I had a headache but you putted it extremely simple in the file.

For that kind of drawings I use Google's Sketchup. Much more friendly and light that AutoCAD or software alike. Really easy to learn too!

Thank you very much again Dan... excellent solution!
0
 
LVL 23

Expert Comment

by:DanCh99
ID: 39703712
No problem, thanks for posing an interesting question.
cheers, Danny
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
How to Win a Jar of Candy Corn: A Scientific Approach! I love mathematics. If you love mathematics also, you may enjoy this tip on how to use math to win your own jar of candy corn and to impress your friends. As I said, I love math, but I gu…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now