Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 2
Default Fuel Tank Tilt volume from fuel point in Gallons

I'm having trouble creating a formula to tell me an accurate tank volume in a tank when it is tilted.

I know the following:

Step 1: Tank Capacity

Tank Diameter:96 inch
Tank Length: 256 inch

So total capacity is : 8021.59 Gallons

Formula [=(("Diameter"/2)*("Diameter"/2)*PI()*"Tank Length")/231]

Step 2: Tank Volume measurement using a dipstick

Striker plate: .25 inch
Stick Reading:78.75 inch

Volume in Tank:7,062.54 Gallons

Formula [="Tank Length"*((("Diameter"/2)^2*(ACOS((("Diameter"/2)-("Stick Reading"+"Striker plate"))/("Diameter"/2))))-(SQRT(2*(("Diameter"/2)*("Stick Reading"+"Striker plate"))-("Stick Reading"+"Striker plate")^2)*(("Diameter"/2)-("Stick Reading"+"Striker plate"))))/231]

Step 3: Tank Tilt

Fill point 1: 78.75 inch
Fill point 2: 75 inch
Distance between to two fill point: 198 inch
Difference is: 78.75(in)-75(in) = 3.75(in)
The ratio is: 256(in)/ 198(in) = 1.29(in)

So the tank tilt is: 1.29(in) * 3.75(in) = 4.85(in)

So I know the Tank Tilt, but what formula should I use to find out how much volume is in the tank when measuring from fill point 1 only. I'm sure it is more than the 7,062.54 Gallons from step 2.

Last edited by Harlemshake : March 2nd 13 at 04:24 PM
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default Fuel Tank Tilt vloume from fuel point in Gallons

On Fri, 22 Feb 2013 21:47:08 +0000, Harlemshake
wrote:


I'm having trouble creating a formula to tell me an accurate tank volume
in a tank when it is tilted.

I know the following:

Step 1: Tank Capacity

Tank Diameter:96 inch
Tank Length: 256 inch

So total capacity is : 8021.59 Gallons

Formula {=(("Diameter"/2)*("Diameter"/2)*PI()*"Tank Length")/231]

Step 2: Tank Volume measurement using a dipstick

Striker plate: .25 inch
Stick Reading:78.75 inch

Volume in Tank:3,854.11 Gallons

Formula [="Tank Length"*((("Diameter"/2)^2*(ACOS((("Diameter"/2)-("Stick
Reading"+"Striker
plate"))/("Diameter"/2))))-(SQRT(2*(("Diameter"/2)*("Stick
Reading"+"Striker plate"))-("Stick Reading"+"Striker
plate")^2)*(("Diameter"/2))))/231]

Step 3: Tank Tilt

Fill point 1: 78.75 inch
Fill point 2: 75 inch
Distance between to two fill point: 198 inch
Difference is: 78.75(in)-75(in) = 3.75(in)
The ratio is: 256(in)/ 198(in) = 1.29(in)

So the tank tilt is: 1.29(in) * 3.75(in) = 4.85(in)

So I know the Tank Tilt, but what formula should I use to find out how
much volume is in the tank when measuring from fill point 1 only. I'm
sure it is more than the 3,854.11 Gallons from step 2.



In a perfectly round cylinder, the vertical fill level remains in place
as the tank is tilted, and only the end points rise and fall against the
tank walls.

Without considering meniscus offset from surface tension, that fill
level point will always be the halfway point between the two crests in
the ellipsoid created by the tipping.

So, if you have one dimension, you have the other, and you can find the
actual fill level dimension at the center between those two points. That
center from the bottom of the cylinder is the fill measure.
  #3   Report Post  
Junior Member
 
Posts: 2
Default

Thanks for the help but I was able to build the spread sheet with the formula from this link http://planetcalc.com/1442/

Thanks again.

https://docs.google.com/file/d/0Bx6_...it?usp=sharing

Last edited by Harlemshake : March 2nd 13 at 05:10 PM
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto fuel cost Ron G Setting up and Configuration of Excel 1 April 22nd 08 06:17 PM
fuel cost Johnny Excel Discussion (Misc queries) 1 January 30th 07 03:23 PM
Fuel Consumption Figures Santa-D Excel Programming 0 August 15th 06 08:14 AM
template for fuel log? GWAR Excel Programming 0 April 27th 06 01:53 AM
Fuel Tank Formula's For Dip sticks DENNIS Charts and Charting in Excel 2 July 21st 05 04:37 PM


All times are GMT +1. The time now is 06:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"