|
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
Updated June 30, 2006
Another resource for volume calculations is: ABE Volume Calculator Page
The most FAQ is 'What about inclined cylinder?'
The math for this problem is beyond my abilities, but for those of you who really want to inflict brain damage on your self I found a site that can help you:
Inclined Cylinder Calculator
|
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-d) / r)) - ((r - d) * sqrt(2rd - d2))Where r = radius , d = depth of fluid , angles are in radians This yields the section area. Area x Length = Volume 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
|