# Tank Volume Calculation

This is a discussion on Tank Volume Calculation within the Excel Questions forums, part of the Question Forums category; Is there any way to calculate the volume of the following tnaks Vertical Tank With Spherical Top and bottom. horizontal ...

1. ## Tank Volume Calculation

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

2. ## Re: Tank Volume Calculation

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

3. ## Re: Tank Volume Calculation

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

4. ## Re: Tank Volume Calculation

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

5. ## Re: Tank Volume Calculation

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

6. ## Re: Tank Volume Calculation

******** ******************** ************************************************************************>
 Microsoft Excel - horiztank.xls ___Running: xl97 : OS = Windows 98
 (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
 L25G42G43F44 =

A
B
C
D
E
F
G
H
I
J
K
L
M
25
*1.*figure*full*volume*the*same*horizontal*or*vertical(10'*DIA*X*20'*Long*or*Tall)=Volume11750*Gallons*
26
*to*figure*partial*volume*on*horizontal**take*height*of*fluid*in*tank*/*diameter*of*tank*=*a*ratio*
27
*example(2*feet*of*fluid*in*tank/10feet*diameter=.2)*take*the*.2*to*the*chart*and*matches*with*.142378
28
*now*take*the*.142378*X*total*volume*of*tank=partial*fluid*volume*in*horizontal*tank
29
*chart*only*goes*to*.59-so*you*have*to*do*some*math*for*say.75--.500000(.5)*-.195501(.25)=**.304499**now*take*.304499*+*.50000*=*.804499*(.75)*which*would*be*coefficient*for*3/4*full*
30
**
31
H/D*H/D*H/D*H/D*H/D*H/D**
32
0.000.0000000.100.0520440.200.1423780.300.2523150.400.373530.500.5*
33
0.010.0016920.110.059850.210.1526590.310.2640390.410.386030.510.512731*
34
0.020.0047730.120.0679720.220.163120.320.2758690.420.3985770.520.525459*
35
0.030.0067420.130.0763930.230.1737530.330.2877950.430.4111650.530.538175*
36
0.040.0134170.140.0850940.240.184550.340.2998140.440.4237880.540.550875*
37
0.050.0186920.150.0940610.250.1955010.350.3119180.450.4364450.550.563555*
38
0.060.0244960.160.1032750.260.20660.360.3241040.460.4491250.560.576212*
39
0.070.0307720.170.1127280.270.2178390.370.3363630.470.4618250.570.588835*
40
0.080.0374780.180.1224030.280.2292090.380.348690.480.4745410.580.601423*
41
0.090.0445790.190.132290.290.2407030.390.3610820.490.4872690.590.61397*
42
*Vertical*Tank*Above*Partial*Full15'*in*tank*=8812*GallonsOr*15/20=.75*11750=8812*
43
HorizontalTank*Above*Partial*Full7.5'*in*tank*=9452*GallonsOr*7.5/10=.75*(math*from*chart)**.804499*11750=9452*
44
****H/D0.75**
 Sheet1 *

[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

231 in the formulas refers to 231cu.inches in 1 US Gallon
12 is used alot to convert feet to inches
Paul

7. ## Re: Tank Volume Calculation

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•