Tank Volume Calculation

mianmazher

Active Member
Joined
Jan 24, 2004
Messages
412
Is there any way to calculate the volume of the following tnaks


Vertical Tank With Spherical Top and bottom.


horizontal Tank with spherical Ends



I think this is related to some sort of Enigineering mathematics .

so Plz Engineers Mathematicians and Excel Experts Heklp Needed.


Regards


Mian Mazher
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

polly

Board Regular
Joined
Apr 5, 2002
Messages
55
For a vertical cylinder shape tank;

(Inside diameter in inches X Inside diameter in inches) / 1029.4 = bbls per foot
(a bbls in this case is = to 42 gallons)

OR

(radius in inches squared X 3.14 X 12)/231 = gallons per foot

I have other formulas for horizontal tank but I can't get to it until I get to work in the morning

Paul
 

mianmazher

Active Member
Joined
Jan 24, 2004
Messages
412
Thanx polly Bro


plz mail me at zenabmazher@hotmail.com I will be waiting


further more The Tank I am discussing is a Vertical and teh horizontal tanl with the spherical Ends

I think its formula will be different



Regards


Mian Mazher
 

polly

Board Regular
Joined
Apr 5, 2002
Messages
55
The full volume would be the same for both, but if the tank is 1/3, 1/4, 1/5 full....the formula I gave you can be used for figuring partial volumes for a vertical spherical ended (a circle) tank. But yes partial volumes for a horizontal spherical ended tank is very different from vertical because its laying on its side instead of standing on its end

Paul
:biggrin:
 

mianmazher

Active Member
Joined
Jan 24, 2004
Messages
412

ADVERTISEMENT

Dear Polly


I have a horizontal tank and is also partially filled


I basically need teh formula for the Horrizontal and teh Vertical tanks with spherical ends and partially filled


Regards


Main Mazher
 

polly

Board Regular
Joined
Apr 5, 2002
Messages
55
horiztank.xls
ABCDEFGHIJKLM
251.figurefullvolumethesamehorizontalorvertical(10'DIAX20'LongorTall)=Volume11750Gallons
26tofigurepartialvolumeonhorizontaltakeheightoffluidintank/diameteroftank=aratio
27example(2feetoffluidintank/10feetdiameter=.2)takethe.2tothechartandmatcheswith.142378
28nowtakethe.142378Xtotalvolumeoftank=partialfluidvolumeinhorizontaltank
29chartonlygoesto.59-soyouhavetodosomemathforsay.75--.500000(.5)-.195501(.25)=.304499nowtake.304499+.50000=.804499(.75)whichwouldbecoefficientfor3/4full
30
31H/DH/DH/DH/DH/DH/D
320.000.0000000.100.0520440.200.1423780.300.2523150.400.373530.500.5
330.010.0016920.110.059850.210.1526590.310.2640390.410.386030.510.512731
340.020.0047730.120.0679720.220.163120.320.2758690.420.3985770.520.525459
350.030.0067420.130.0763930.230.1737530.330.2877950.430.4111650.530.538175
360.040.0134170.140.0850940.240.184550.340.2998140.440.4237880.540.550875
370.050.0186920.150.0940610.250.1955010.350.3119180.450.4364450.550.563555
380.060.0244960.160.1032750.260.20660.360.3241040.460.4491250.560.576212
390.070.0307720.170.1127280.270.2178390.370.3363630.470.4618250.570.588835
400.080.0374780.180.1224030.280.2292090.380.348690.480.4745410.580.601423
410.090.0445790.190.132290.290.2407030.390.3610820.490.4872690.590.61397
42VerticalTankAbovePartialFull15'intank=8812GallonsOr15/20=.75*11750=8812
43HorizontalTankAbovePartialFull7.5'intank=9452GallonsOr7.5/10=.75(mathfromchart).804499*11750=9452
44H/D0.75
Sheet1


231 in the formulas refers to 231cu.inches in 1 US Gallon
12 is used alot to convert feet to inches
Paul :biggrin:
 
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,491
Messages
5,764,675
Members
425,229
Latest member
Rashid mahmood

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top