Feed Formula.xls and Weight Gain excel Calculator.xls ENJOY

Help Support Steer Planet:

JoeDirt

Well-known member
Joined
May 1, 2007
Messages
283
I would like to Share my 2 EXCEL Files that I have made

1. Feed Formula.xls 

This file is for making up your owe feed and figuring out how much Protein Fat and Fiber and How much to add to get the % you want

Here is a EXAMPLE of what it looks like

WARNING Dont change the Formulas or the Excel file will not work
Corn Oats Beet Pulp Molasses Grand 4-T-Fyer A B C D E
Protein 9% 12% 9% 7% 32% 0% 0% 0% 0% 0%
Fat 4% 5% 1% 0% 7% 0% 0% 0% 0% 0%
Fiber 2% 11% 18% 0% 28% 0% 0% 0% 0% 0% As-Fed Dry Matter
Total Weight Total Percentage Total Percentage
1000 lbs 500 lbs 50 lbs 50 lbs 400 lbs 0 lbs 0 lbs 0 lbs 0 lbs 0 lbs 2000 lbs 100.00%
Protein 90 lbs 60 lbs 4.45 lbs 3.4 lbs 128 lbs 0 lbs 0 lbs 0 lbs 0 lbs 0 lbs 285.85 lbs 14.29% 16.24
Fat 35 lbs 27 lbs 0.25 lbs 0 lbs 28 lbs 0 lbs 0 lbs 0 lbs 0 lbs 0 lbs 90.25 lbs 4.51% 5.13
Fiber 20 lbs 55 lbs 9 lbs 0 lbs 110 lbs 0 lbs 0 lbs 0 lbs 0 lbs 0 lbs 194 lbs 9.70% 11.02


2. Weight Gain excel Calculator.xls

This File is to keep track of weight gain of you animals and to see how much they have gain in how much time. You can find out how much you need to gain before your SHOW or to a date.


WARNING Dont change the Formulas or the Excel file will not work

Only Change Dates, Previous weights and current weights.


2005 Steer's Weight
Mr. Magoo

Date "Previous
Weight" Days since last weight "Current
Weight" "Amount
Change per lb
(+ -)" % Weight Gain Estimated Weight Gain Per Day pre lb.

3/12/2005 Birth 85 85.0
10/8/2005 85 240 610 65.6 9.7% 2.1875
11/8/2005 610 30 690 80.0 13.1% 2.666666667
12/21/2005 690 43 750 60.0 8.7% 1.395348837
2/4/2006 750 43 863 113.0 15.1% 2.627906977
3/18/2006 863 44 990 127.0 14.7% 2.886363636
3/22/2006 990 4 1017 27.0 2.7% 6.75
4/20/2006 1017 28 1095 78.0 7.7% 2.785714286
5/7/2006 1095 17 1148 53.0 4.8% 3.117647059
6/8/2006 0
7/8/2006 0
8/1/006 0


Below is the files you need to use both Files





http://www.mediafire.com/?sharekey=e7e4ae137545cd9ad2db6fb9a8902bda
 

inthebarnagain

Well-known member
Joined
Oct 10, 2007
Messages
613
Location
Indiana
I don't know if anyone grinding their own feed has noticed or not but the dry molasses that I get is the Sweet 45 Lite, if you look at the analysis, where it used to be zeros all the way across there is now 4% protein and a whopping 24% fiber in it. 
 

inthebarnagain

Well-known member
Joined
Oct 10, 2007
Messages
613
Location
Indiana
Messed around and got it loaded to my computer and it works great!!!  Especially since I have a few other ingredients that weren't listed and I just added them to it.
 

willie

Active member
Joined
May 24, 2008
Messages
27
I can't seem to get to these files either, any help with this would be greatly appreciated. Thank you.
 

Cowsplusgoats

Member
Joined
Dec 3, 2017
Messages
17
I did a search for feed ration calculator. I see below someone posted an excel file. I can’t open it, is it posted somewhere else? Please send me a link.
Thank you
 
Top