Volume in horizontal round tanks???

Has anyone set up a spreadsheet to calculate gallonage in horizontal round
tanks that are partially full? I am trying to calibrate a rod to determine
the amount of gas or diesel left in underground tanks...

Thanks
RKL

Found an article that may help:

http://mathforum.org/library/drmath/view/54954.html

Hi,

The following formula will calculate the volume of a fluid in a partially
full tank (cylindrical and flat on sides, and set up horizontally) based on
the tank dimensions and the fluid depth.

Enter the length of tank in A2, diameter of the tank in B2, and fluid depth
in C2,
and the following formula in D2.

=$A$2*(0.25*$B$2^2*ACOS(1-2*$C$2/$B$2)-0.5*($B$2-2*$C$2)*SQRT($C$2*$B$2-$C$2^2))

If the dimenions are in feet, the volume calculated will be in cubic feet.
Convert that into gallons by multiplying the cubic footage by an appropriate
value from the following:

1 cubic foot = 7.480519 US gallons (liquid) = 6.228835 UK gallons.

Sorry about my reply to your earlier posting on the same question; I wasn't
sure whether you wanted to calculate the total capacity of the tank or the
fluid volume in a partially filled tank.

Regards,
B. R. Ramachandran

"Richard Larson" wrote:

> Has anyone set up a spreadsheet to calculate gallonage in horizontal round
> tanks that are partially full? I am trying to calibrate a rod to determine
> the amount of gas or diesel left in underground tanks...
>
> Thanks
> RKL
>
>
>

Ramachandran: Your formula works perfectly. Any idea how to account for rounded or hemispherical end caps?