Tank 2: V = 20.9073465 * h * (1 + 0.0522617 * h)Īnd then finally, this is really not anything to do with Excel and more like math class. for example if the tanks are prismatic and the walls slope outward and then also assuming the 1" value is a true value for that prism then the formula would be something like V = c1 * h * ( 1 + c2 * h ) and with 2 points and 2 unknowns we can find c1 and c2: additional data points could confirm or help understand it better. Of course this is some assumptions and guesses. (12077 - 22)/95 => 126.89 gal/inch for tank 2 For certain applica-tions, one may want to show only the calculator function for a given vessel, so that an operator would only need to enter a liquid level to quickly calculate the corresponding liquid volume. Click the Charts tab at bottom and the chart will be calculated.
So my only guess is that the 1 inch value is given to take into account irregularities of the tank bottom so all the bolts and the slope of the tank floor and such results in a much smaller volume than the rest of the tank which mean means every inch ABOVE the 1 in would be so i'll ignore the dimensions on tank 2 as we don't have it for tank 1 either. is that 96" dimension the height? I assumed those were length and width but that would mean 159.6 gal/in but that times 95" (the height between those measurements) is over 15,000 gal. Also for tank 2 you give dimensions of 96"x32' 0" but that doesn't make sense either. by "flat ends" I assume you mean the tank has vertical walls so 120 inches should be 120x larger than 1 inch but 25.5x120 = 3060 which isn't close to 19975.6 and the same goes for tank 2.