litwiller.net

Liquid tank calculator

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

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.

Clamav on Plesk

You like plesk but don’t like the Dr Web antivirus that comes with it? Change to Clamav here are the instructions

http://www.hostbird.com/beta/index.php?loc=0602-0602

Excel: Feed Ration Sheet

I am working on a feed ration spreadsheet. I’ve got it working well enough for our current needs but there are other items on my wish list that I may or may not get to.

Here it is if you need a feed ration spreadsheet.

This spreadsheet lets you setup , farmers, rations, feed components and weekly price per component. Then when you select the farmer and ration put in the amount of feed they need it will calculate the wieghts of the individual components. Then look up the price for the date you choose and the farmers delivery and other charges. and will calculate the price per ton and for the entire batch.

Wishlist

• Some farms bank grain in our bins. When we make feed for them we need to use from thier banked grain and keep track of amount they have banked. This spread sheet should do this automatically.
• I want to get rid of the hand tickets that they make in the feed mill. So i need this spreadsheet to automatically number orders as they are created and the also keep a database of these orders so we can look them up. I started tabs for these two features but haven’t got them working yet.

I license this spreadsheet GPLv2. Any changes or enhancements added to this spreadsheet need to be contributed back to me. And will be made available as an updated version here.

Download here

Web site hosting and design.

One of my hobbies is developing and hosting web sites. I preferred to develop based on either Wordpress or Joomla. They take care of the back end of the site and allow me to save much time and make a site that the client can use easily. Also they are used widely enough that if they decide to move to another host they can move their site and there are many other people that can support them.

http://www.kyea.org is one of the more recent site that I upgraded to using Joomla as thier CMS. They moved from a static site that they managed with Macromedia Contribute. But with contribute I had to add the pages as they needed new pages, and I had to add those new pages to the menus each time. With Joomla they have more control. Still without having to worry about not knowing html and if what they post will break their site.