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

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.