volume in horizontal vessel.xls
Description
Liquid Volume in a Partly Filled Horizontal Vessel with Elliptical or Hemispherical Heads
Calculates the volume of liquid in a horizontal cylindrical vessel or tank filled to a given level, including the liquid in both heads. Choose 2:1 elliptical or hemispherical heads from a drop-down list. There are two identical sheets, one in millimetres giving m³ and one in inches giving ft³.
Method
The liquid depth is H1 = level × D. The filled fraction of the cylinder is f(zc) = (α − sinα cosα)/π, where α = 2 tan−1[H1/√(H1D − H1²)] is the half-angle of the wetted segment. The filled fraction of the two heads, which together form an ellipsoid, is f(ze) = (H1/D)²(3 − 2H1/D). Head depth b is D/4 for 2:1 elliptical heads and D/2 for hemispherical heads, and K1 = 2b/D.
V = (π/6)K1D³f(ze) + (π/4)D²L f(zc)
Inputs
- Length of the cylindrical (straight) part L and inside diameter D
- Head type: Elliptical 2:1 or Hemispherical
- Liquid level as a fraction of the diameter (0 to 1)
Outputs
Head depth b, K1, liquid depth H1, angle α, the two filled fractions, and the partial volume in mm³ and m³ (or in³ and ft³). Each step is shown as an equation.
The stored metric example, D = 4,523 mm, L = 30,580 mm, 2:1 elliptical heads, level 0.7537, gives about 417.8 m³ (our recalculation; the full vessel holds about 515.6 m³).
Please note
- Every result formula uses functions from the free XLC add-in; without it the sheet shows #NAME? instead of answers.
- The level is entered as a fraction of the diameter, not as a depth. L is the straight length only, excluding the heads. Inside dimensions should be used for liquid volume.
- Only 2:1 elliptical and hemispherical heads are offered; torispherical heads are not covered. No macros.
Calculation Preview
Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.