Fuel Tank Tilt vloume from fuel point in Gallons

Discussion in 'Excel Charting' started by Harlemshake, Feb 22, 2013.

  1. Harlemshake

    Harlemshake Guest

    I'm having trouble creating a formula to tell me an accurate tank volum
    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)-("Stic
    Reading"+"Strike
    plate"))/("Diameter"/2))))-(SQRT(2*(("Diameter"/2)*("Stic
    Reading"+"Striker plate"))-("Stick Reading"+"Strike
    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 ho
    much volume is in the tank when measuring from fill point 1 only. I'
    sure it is more than the 3,854.11 Gallons from step 2


    --
    Harlemshake
     
    Harlemshake, Feb 22, 2013
    #1
    1. Advertisements

  2. Harlemshake

    MrTallyman Guest

    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.
     
    MrTallyman, Feb 23, 2013
    #2
    1. Advertisements

  3. Harlemshake

    Harlemshake Guest

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

    Thanks again


    --
    Harlemshake
     
    Harlemshake, Feb 28, 2013
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Sheela
    Replies:
    3
    Views:
    78
    Tushar Mehta
    Jan 16, 2004
  2. Philip

    Fuel Guage charts

    Philip, Jan 26, 2004, in forum: Excel Charting
    Replies:
    2
    Views:
    95
    Andy Pope
    Jan 26, 2004
  3. Bernard Liengme

    Fuel Tank Formula's For Dip sticks

    Bernard Liengme, Jul 21, 2005, in forum: Excel Charting
    Replies:
    1
    Views:
    128
    BenjieLop
    Jul 21, 2005
  4. spazminator
    Replies:
    12
    Views:
    119
    spazminator
    Dec 19, 2005
  5. Nightowl

    chart: mileage MPG Fuel total paid

    Nightowl, Mar 11, 2006, in forum: Excel Charting
    Replies:
    0
    Views:
    110
    Nightowl
    Mar 11, 2006
  6. Gene Flood
    Replies:
    2
    Views:
    89
    begraphic addin
    May 13, 2010
  7. Raj
    Replies:
    3
    Views:
    119
    Jon Peltier
    Jul 27, 2007
  8. Shevvie

    PIE: tilt a 3d chart

    Shevvie, Feb 13, 2008, in forum: Excel Charting
    Replies:
    2
    Views:
    239
    Shevvie
    Feb 14, 2008
Loading...