Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
|
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Volume in horizontal round tank... | Excel Discussion (Misc queries) | |||
Round a number in nested function | Excel Worksheet Functions | |||
Round whole numbers up and down | Excel Discussion (Misc queries) | |||
Can you format a whole column of numbers to round? | Excel Worksheet Functions | |||
How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions |