Excel formula for converting tank volume in inches to gallons

[sethrose]

I have this formula for converting tank volume in inches to gallons for a 6000 gallon tank 8' diameter, 16' length

=192*(48^2*ACOS((48-K4)/48)-(48-K4)*SQRT(2*48*K4-K4^2))/231

I need the same formula for 2 other sized tanks and would appreciate some help:

2005.4 gallons 8' diameter, 5'4 length
4010.8 gallons 8' diameter, 10'8" length


Thanks!!

 

[West Man]

Is K4 the depth of liquid in the tank? If so, it appears that the 192 is the length of the tank in inches and 48 is the radius of the tank in inches. Just substitute the new values into your current formula.

 

[sethrose]

Got it, perfect. Thanks!