Tank Volume


Spreadsheet template for tank volume calculations

$39 -- Buy Now

TankVolume is designed to do one thing: compute the volume in a vertical or horizontal vessel at any level of fill. Data entry is grouped onto an input worksheet and results are displayed immediately. A second worksheet contains a Datasheet that can be printed and filed with the project information. There is an Instructions worksheet that includes definitions of the different types of tank heads. 

Buy Now

Data entry

This screen shot (click on it for a larger version) shows the Data Input screen. Note that a horizontal tank with cylindrical shell are selected, and that both heads are the same (torispherical, or F&D). The dish and knuckle radii are input (user is prompted that standard ASME F&D heads use f=1.0 and k = 0.06).

At the bottom, results are shown for the tank being completely full and at the fill level that was specified by the user. The picture shows a horizontal tank with torispherical heads and the fill level picture corresponds approximately to that which was input by the user.

The second example is for a horizontal tank with an elliptical shell. The picture changes to show a vertical ellipse or horizontal ellipse, depending on which dimension is larger as entered by the user. Also, on the right hand side of the screen you can see a choice of “vertical” or “horizontal” – this is the selection of which tank axis to use when calculating the head dimensions. 

The third data entry example shows a vertical tank that has different top and bottom heads. The bottom head is elliptical and the top head is flat. Any combination of heads may be selected, each with its own dimensional parameters. The picture always depicts the combination that is selected. 

At the bottom of the screen are the results. For vertical tanks a third result is shown: volume to the top tangent (for a flat-top tank this is the same as full volume). 


The datasheet view is automatically created. Tank dimensions are summarized, a sketch is drawn (not to scale), and the graph of fill level versus volume drawn. Units (length and volume) match the “English” or “SI” units selected on the Data Input screen.

Users can easily customize the datasheet to include their logo and project information.


The instructions tab completes the Excel workbook. Screen shots are not provided here – send an e-mail if they are needed.

Most calculations and screen manipulations are performed with Visual Basic subroutines, embedded in the Excel workbook. All code is commented to enable the user to validate or modify the routines.

The formulas and methods utilized by TankVolume were published in Chemical Processing magazine (November 2002 and December 2003) in articles written by Dan Jones, Ph.D., P.E. Mr. Jones reviewed TankVolume and validated the results.


TankVolume Screenshots (pdf)