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
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