converting vertical inches in tank to gallons (have manual cha
Hmmm,
I'll get it right in a minute. The dip must be in feet. i.e 12ft 6in should
be entered as 12.5
Mike
"Mike H" wrote:
Scotty,
Use this formula
=(PI()*B1^2*A1)*6.22883288
Where
B1 is the radius of the tank
and
A1 is the dip depth in inches
the answer will be imperial gallons
Mike
"Scotty" wrote:
I have a tank that I measure daily to see how many gallons are in. I measure
it with a stick and then look at a chart made for the tank to see how many
gallons it equals. I would like to set up excel so that I can enter in the
stick measurement and it will give me the gallons in the next column
automatically. Any suggestions on how to do this?
|