volume in horizontal vessel.xls

(4/25)

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

Darren Reid (Quintaros)
28 Apr 2023
File Size 198.00Kb
Downloads: 759
File Version: 1.0
File Rating (4/25)

 
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.
Comments: 1
johndoyle-admin 19 years ago
Thank you Quintaros for your first upload. You have kindly included both SI and Imperial units too.