Hello,
i am looking for a formula to measure the fuel in a cylindrical tank by entering the diameter of the tank and height of fuel in a tank ( fuel height should be in inches). And same for rectangular and Base tanks. Any one can help me here please.
Volume in a Cylinder: pi x r² x Depth
rectangle: Width x Length x Depth
Is the cylindrical tank laying on its side or is the axis vertical?
For any object whose sides are vertical (like a cylinder with vertical axis or a parallel piped) the volume is the (area of the base)*(height)
Last edited by mikerickson; 09-16-2012 at 02:45 AM.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
kindly see the attached file. This may help us.
Hi,
See attached the volume in liters of each tank depending on level height
Each value are custom format for inches, feets and liters
Hope this help
Best regards
Hi jpr73
Is the OP using imperial inches! If so there are 12" (inches) to 1' (foot)
Hi Kevin UK,
For cylindrical tank, koolboy65 use inches for all measures
For rectangular tank, koolboy use feets for width and lenght then inches for dept
See the formula, I have talk care of feets to inches
Best regards
Hi koolboy65
You need to enter numbers in your spread sheet instead of text! Then format the cells.
I'll ask the question again, is the cylindrical tank lying on its side? (like the tank of a tanker truck?)
Also, since the desired answer is in liters, there are 61.0237438366662 cu. in. in a liter
I don't see where the units for the diameter of the cylinder are mentioned.Originally Posted by jpr73
I am curious about this as well since I have a cylindrical tank as well plus it is lying on its side.
EDIT - I've done some looking around and have found the following base formula for a partial horizontal cylindrical tank with flat ends/heads. Just replace R with the radius of the tank in inches, H with the height of the liquid in inches and L with the length of the cylinder in inches. This should give you a volume in U.S. gallons
(R^2*ACOS((R-H)/R)-(R-H)*(2*R*H-H^2)^0.5)*L*7.4805/1728
Last edited by LoneWolf3574; 09-17-2012 at 07:53 AM. Reason: New Information
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks