|
A simple form for finding the volume of a cylinder oriented vertically or horizontally. |
|
As a request I created an MS Excel® and OpenOffice® spread
sheet to list volumes at depth intervals. It is a simple form and not
pretty but functional. It calculates volume in gallons (US), barrels of
oil and Liters. Down load MS Excel® 2000 file here ,
MS Excel® 2000 in Metric Units here
or the OpenOffice® file here
Another resource for volume calculations is: ABE Volume Calculator Page The most FAQ is :'What about inclined cylinder?'
If you have found this script useful, please make a donation to your favorite charity or organization. | Support our troops![]() |
|
How it works. The images below hopefully will illustrate the geometry used in solving the problem. Total view of horizontal tank. Assumptions made: tank is level, ends are flat, measurements are ID and must be in like units.The calculation for the horizontal cylinder is based on the formula: [(r2 acos (r-df) / r) - (r - df) * sqrt(2rdf - df2)] x LWhere r = radius , df = depth of fluid , angles are in radians and L = length acos = inverse cosine, arccosine, or cos-1 This yields the section area. Area x Length = Volume
Below are some graphics to help explain the geometry. (pardon the crude graphics) minus
leaving bottom segment.
For fluid levels that are > r, the volume is: (area of the circle - top segment) x length. |
If you find this script useful and would like to have a copy, you can down load the
Cylinder file in Zip format here.
| If you have any comments, suggestions, or problems with the script, contact |
This page has been viewed |
| Browser Safe Colors
| Windows Colors
| Character Entities
|
| Home
| Angel Story
| PGP keys
| Web Tools
|
| Bluegrass Music
| My Bios
| My Resume
| Lotto #'s
|