Tank Volume Calculation

[mianmazher]

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

 

[polly]

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]

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]

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

 

[mianmazher]

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]

horiztank.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M
25		1.figurefullvolumethesamehorizontalorvertical(10'DIAX20'LongorTall)=Volume										11750Gallons
26		tofigurepartialvolumeonhorizontaltakeheightoffluidintank/diameteroftank=aratio
27		example(2feetoffluidintank/10feetdiameter=.2)takethe.2tothechartandmatcheswith.142378
28		nowtakethe.142378Xtotalvolumeoftank=partialfluidvolumeinhorizontaltank
29		chartonlygoesto.59-soyouhavetodosomemathforsay.75--.500000(.5)-.195501(.25)=.304499nowtake.304499+.50000=.804499(.75)whichwouldbecoefficientfor3/4full
30
31	H/D		H/D		H/D		H/D		H/D		H/D
32	0.00	0.000000	0.10	0.052044	0.20	0.142378	0.30	0.252315	0.40	0.37353	0.50	0.5
33	0.01	0.001692	0.11	0.05985	0.21	0.152659	0.31	0.264039	0.41	0.38603	0.51	0.512731
34	0.02	0.004773	0.12	0.067972	0.22	0.16312	0.32	0.275869	0.42	0.398577	0.52	0.525459
35	0.03	0.006742	0.13	0.076393	0.23	0.173753	0.33	0.287795	0.43	0.411165	0.53	0.538175
36	0.04	0.013417	0.14	0.085094	0.24	0.18455	0.34	0.299814	0.44	0.423788	0.54	0.550875
37	0.05	0.018692	0.15	0.094061	0.25	0.195501	0.35	0.311918	0.45	0.436445	0.55	0.563555
38	0.06	0.024496	0.16	0.103275	0.26	0.2066	0.36	0.324104	0.46	0.449125	0.56	0.576212
39	0.07	0.030772	0.17	0.112728	0.27	0.217839	0.37	0.336363	0.47	0.461825	0.57	0.588835
40	0.08	0.037478	0.18	0.122403	0.28	0.229209	0.38	0.34869	0.48	0.474541	0.58	0.601423
41	0.09	0.044579	0.19	0.13229	0.29	0.240703	0.39	0.361082	0.49	0.487269	0.59	0.61397
42	VerticalTankAbovePartialFull				15'intank=		8812Gallons		Or15/20=.75*11750=8812
43	HorizontalTankAbovePartialFull				7.5'intank=		9452Gallons		Or7.5/10=.75(mathfromchart).804499*11750=9452
44					H/D	0.75
Sheet1

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

 

[Cricketer]

Hi

This may be of use

http://tierling.home.texas.net/HorizontalDrumShell.htm

Cricketer