litwiller.net

Liquid tank calculator

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

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.

Dry product volume calculator

October 2, 2008 on 3:54 pm | In Excel | Comments Off

I recently needed this for work.  We needed a quicker way to get a fairly accurate measure of how much dry product we have for inventory.

The way this spreadsheet works:
Edit the products sheet with the product you are storing. Density is the product weight per cubic foot. US Measurements only at this time.

Edit the Bins sheet with the size of the storage areas. Default sheet is 10 flat bins and 3 cone bottom upright bins.

So you go to your bins, give them each a name or number and then start measuring.

The measuring procedure: We have 1ft and 6in line painted inside our bins and use a rake to level across the bin if it is uneven across the width.
Measure how high the pile goes up the back wall this number goes in as ft’ in” like 3′ 8″
next look at the pile and determine where the next change of the slope of the pile is, take a measurement of distance from the back of the bin and from the floor. Do this for any place the pile shape changes.

Enter these in the spreadsheet  Several of the graphs have sample data.

The sheet calculates the area of the cross section you measured. multiplied by the width of the bin. multiplied by the density of the the product you have chosen. It gets the bin and product information from the pink bin dropdown and yellow product downdown boxes.

at the bottom there are 3 cone bottom bins. where you measure the depth of the product from the bottom of the bin to the top of the product - try to flatten or estimate the level of flattening the top.

to the right you choose a product in each column then it will add all the bins and fill in the inventory totals report at the bottom.

Download here

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