troubleshooting Question

Calculate volume progressively on a triangle

Avatar of Cesar Aracena
Cesar AracenaFlag for Argentina asked on
Math / ScienceMicrosoft ExcelSpreadsheets
10 Comments1 Solution493 ViewsLast Modified:
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!
Danny Child
IT Manager

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros