4 replies to this topic

[VikingUK]

I am trying to make up an excel sheet to calculate the volume of a horizontal vessel (elipsoidal ended) at various levels when partially full.

Can anyone give me a formula to use (metric please) Im using this one...

=SUM((392.75*(3030-A2)*A2^2/3030))+(5280*(SQRT((2020-A2)*A2)*(A2-1010)+1010^2*(ACOS(1-((A2/1010)/1010)))))

which is from....

v= (pi*r(3R-y)y^2)/3R which gives volume of both end caps (formula is for a spheroid but assumes both ends are one)

plus

v = L(((2R-y)*y)^2(y-R)+R^2*acos(1-(y/R)))

volume of partially filled cylindrical section

where

y = vessel level
R = radius of vessel
r = radius of arc of end caps
L = cylinder length

Ive tried for hours but I keep getting a negative solution anyone got a better formula ?

[katmar]

See
http://www.cheresour...ume-calculator/

[VikingUK]

Please ignore me I am an idiot, I divided the diameter twice..!!
Formula works perfectly and if anyone wants to cut and paste it to an excel sheet here it is.

=SUM((((pi*r)*((3*R)-B2)*B2^2/(3*R)))+(L*(SQRT(((2R)-B2)*B2)*(B2-R)+R^2*(ACOS(1-((B2/R)))))))/1000000


you will have to put your own figures in for :

R = cylinder radius mm
r = elipse radius of ends mm
L = length of cylinder (not including elipse ends)mm

B2 is the cell on excel I used to enter the level (height of liquid in vessel)

dimensions are in mm and solution is in litres

[ankur2061]

Please ignore me I am an idiot, I divided the diameter twice..!!
Formula works perfectly and if anyone wants to cut and paste it to an excel sheet here it is.

=SUM((((pi*r)*((3*R)-B2)*B2^2/(3*R)))+(L*(SQRT(((2R)-B2)*B2)*(B2-R)+R^2*(ACOS(1-((B2/R)))))))/1000000


you will have to put your own figures in for :

R = cylinder radius mm
r = elipse radius of ends mm
L = length of cylinder (not including elipse ends)mm

B2 is the cell on excel I used to enter the level (height of liquid in vessel)

dimensions are in mm and solution is in litres

VikingUK,

Another recent one & it is quite good.

http://www.cheresour...__fromsearch__1

Regards,
Ankur.

[VikingUK]

VikingUK,

Another recent one & it is quite good.

http://www.cheresour...__fromsearch__1

Regards,
Ankur.
[/quote]

There is a huge discrepancy from my sheet and the one you mention
my calculation is based on :-

V= (∏ r (3R-y) y²/3R) + L(sqrt(2R-y)y) (y-R)+R² cos¯¹(1-(y/R))/10^6

Where

V = volume in litres
y = level in tank in mm
L = length of tank (tan – tan)
r = radius of elipsoid ends
R = radius of cylindrical section of tank