### Liquid Volume in Partially Filled Horizontal Tanks

This Excel spreadsheet helps you calculate the liquid volume in partially filled horizontal tanks.

Tanks are often used in storing chemicals. Often, only the liquid height from a level indicator is known. This means you need a method of calculating the liquid volume based on the liquid height and the tank dimensions.

The tank ends can be

• flat (so the tank is just a horizontal cylinder)#
• dished (ASME F&D, or Flanged & Dished)
• 2:1 elliptical
• hemispherical
The liquid volumes in a horizontal cylinder, and ASME F&D, 2:1 elliptical and hemispherical ends are given by these equations.

where
• D is the diameter of the cylinder and the heads
• L is the length of the cylindrical shell
• h is the height of liquid in the tank
The diagram at the top illustrates the notation.

Hence the total volume of liquid in the tank is simply the liquid volume in the cylinder plus 2 times the liquid volume in the heads.

The dimensions can be specified in any length unit. The unit of the volumes will simply be the length unit cubed.

This spreadsheet can be easily modified to created a Dip chart (i.e. a chart giving the liquid volume as a function of liquid height).