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. Finally, a Calculations worksheet is used for all
of the intermediate results.
 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).
 Datasheet
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.
The user can easily customize the datasheet to include their logo
and project information.
Instructions and Calculations
The instructions tab and calculations worksheet complete the Excel
workbook. Screen shots are not provided here – send an e-mail if they
are needed.
Some 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 has reviewed
TankVolume and validated the results.
Order Info
|
