litwiller.net

Excel: Feed Ration Sheet

May 22, 2007 on 9:56 am | In Excel |

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