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
