how do i get my spreadsheet to give me tank gage amounts.

tankerman · 01-05-2006, 10:15 AM

I have a fuel tank that is a round but is laying down ways. how do i get
excell spreadsheet to give me the correct amount of gallons in tank the if we
have the correct gage in inches, with the tank being round i can not figure
out how to get the sheet to give me the amount because of the graduation of
the amount in the tank.

**BenjieLop** · 01-05-2006, 10:37 AM

Originally Posted by tankerman

I have a fuel tank that is a round but is laying down ways. how do i get
excell spreadsheet to give me the correct amount of gallons in tank the if we
have the correct gage in inches, with the tank being round i can not figure
out how to get the sheet to give me the amount because of the graduation of
the amount in the tank.

For this simple situation, you do not really need a spreadsheet to determine the volume of the fuel in the tank. All you need is the strapping table for this tank.

Regards.

tankerman · 01-05-2006, 12:15 PM

I have the strappings for the tank but how can I get the spreadsheet (we use
it for several different enteries of different products and other things) to
enter the amount of fuel in one cell with the gages in another.

"BenjieLop" wrote:

>
> tankerman Wrote:
> > I have a fuel tank that is a round but is laying down ways. how do i
> > get
> > excell spreadsheet to give me the correct amount of gallons in tank the
> > if we
> > have the correct gage in inches, with the tank being round i can not
> > figure
> > out how to get the sheet to give me the amount because of the
> > graduation of
> > the amount in the tank.
>
> For this simple situation, you do not really need a spreadsheet to
> determine the volume of the fuel in the tank. All you need is the
> strapping table for this tank.
>
> Regards.
>
>
> --
> BenjieLop
>
>
> ------------------------------------------------------------------------
> BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
> View this thread: http://www.excelforum.com/showthread...hreadid=498275
>
>