litwiller.net

Liquid tank calculator

October 2, 2008 on 4:11 pm | In Excel |

This calculator is based on the dry calculator I made for measuring dry fertilizer. This one measures the wieght of liquid fertilizer in tanks.

Enter the products in the products sheet. the density column is calculated so enter nutrients, name and weight per Gallon.

Enter the measurements of the tanks in the tanks sheet.
Use is very similar to the other spreadsheet, but we only need the total product depth at each inventory. We have measured each tanks from a marked measure point in the top to the outlet at the bottom

Then we measure  from this marked measure point to the top of the product and subtract from the measured total. This is the height of the product.

So to use choose the tank in the pink drop down, choose the product in the yellow and enther the measured hieght of the product.It will give you the total tons of product in the tank and a graph so you can verify that it is accurate.

next move to the right and make sure you have a coumn with each product so it can add all the tanks and at the bottom you have the total inventory of products in the tank farm.

Download here

Report errors or problem to tim@litwiller.net.  License is creative commons. Please share any improvements you make on this spreadsheet.