General-Comments

Document Sample
General-Comments Powered By Docstoc
					General Comments

General Comments
1. Spaces that require input from the user of this spreadsheet are in light blue. 2. The simple spreadsheet can assist the feeder with several tasks including sample scheduling, inventory estimation, new feed weight calculation, mix sheet generation, and dry matter intake calculation. 3. If your farm has a feed sampling schedule, the first worksheet can help keep track of when each feed needs to be sampled next. Three inventory estimators can help monitor your silage inventories and, with additional input, project the number of days of feed remaining. One worksheet will estimate for a top-unloading tower silo and the next will estimate for a bottom-unloading. The third worksheet will provide estimates for a bunker silo. The look-up tables contained within these worksheets are estimates aggregated over a range of conditions and should be used conservatively. 4. The next worksheets convert wet weights to dry matter pound and back using user-entered dry matter percents. The following worksheet combines these two equations and will calculate a new wet feed weight when the feeder enters the old wet feed weight, old dry matter percent, and new dry matter percent. These two worksheets can help a new feeder learn the math required for the job. 5. With the next worksheet, the feeder can generate a batch mix sheet for a group by entering the information found on the nutritionist’s ration sheet. After the number of cows, feed identifiers, dry matter pounds of each feed, and dry matter percents are entered, the worksheet will calculate the mix sheet needed for the group which the feeder can print. 6. Finally, the last two worksheets work together to turn the raw data regarding intake (the five numbers described in August 2007 Farm Report) into dry matter intake information. The dry matter intake per cow per day is calculated in the first worksheet and plotted in the next worksheet. These worksheets track one group for one month. 7. This spreadsheet is generic and is should be considered a good start to meet the needs of your dairy. Work with your nutritionist to tailor this spreadsheet to your dairy or to create your own. The original was presented in the William H. Miner Agricultural Research Institute Farm Report October 2007 This spreadsheet is availabe for free download at www.whminer.org\outreach.html If comments or concerns arise, contact me. Steve Mooney, Ph.D., Research Post Doc mooney@whminer.com

MinerFeederToolsVersionOne.xls

Page 1

Feed Sample Scheduler
FEED ID #1 Enter Feed Number Enter Feed Number Enter Feed Number Enter Feed Number Enter Feed Number Enter Feed Number Enter Feed Number Enter Feed Number Enter Feed Number Enter Feed Number Enter Feed Number Enter Feed Number Enter Feed Number Enter Feed Number Enter Feed Number Enter Feed Number Enter Feed Number Enter Feed Number Enter Feed Number Enter Feed Number FEED ID #2 Enter Feed Name Enter Feed Name Enter Feed Name Enter Feed Name Enter Feed Name Enter Feed Name Enter Feed Name Enter Feed Name Enter Feed Name Enter Feed Name Enter Feed Name Enter Feed Name Enter Feed Name Enter Feed Name Enter Feed Name Enter Feed Name Enter Feed Name Enter Feed Name Enter Feed Name Enter Feed Name Enter Current Sample Date 6-Oct-07 6-Oct-07 6-Oct-07 6-Oct-07 6-Oct-07 6-Oct-07 6-Oct-07 6-Oct-07 6-Oct-07 6-Oct-07 6-Oct-07 6-Oct-07 6-Oct-07 6-Oct-07 6-Oct-07 6-Oct-07 6-Oct-07 6-Oct-07 6-Oct-07 6-Oct-07 Days to Next Sample 21 21 21 21 21 21 21 21 21 21 21 21 21 21 Date of Next Sample 27-Oct-07 27-Oct-07 27-Oct-07 27-Oct-07 27-Oct-07 27-Oct-07 27-Oct-07 27-Oct-07 27-Oct-07 27-Oct-07 27-Oct-07 27-Oct-07 27-Oct-07 27-Oct-07

5261d69b-cd49-4532-8a34-ac862f56a76c.xls

Page 2

Inventory Estimator - Tower(T)
Instructions for Inventory Estimation for Tower Silo, Top-Unloading 0. Determine diameter of silo, height of silage at fill (post-settling), and, where appropriate, current height of silage. 1. Determine the quantity of dry matter when filled using the table below. a. match the diameter and height of silage at fill (post-settling). b. enter tons of dry matter at fill into matching blank. 2. Determine the quantity of dry matter removed using the table below. a. match the diameter and height of silage used so far (which equals fill height minus current height). b. enter tons of dry matter used into matching input space. 3. If desired, enter dry matter percent of silage and estimate of wet tons used per day into appropriate blanks. 4. With these inputs, estimates of tons remaining (dry matter and wet) and days of silage remaining will be calculated.

0. Diameter of silo 0. Height of silage at fill (post-settling) 0. Current height of silage 1. Estimated dry matter in silo at fill 2. Estimated dry matter used 3. DM% of silage 3. Estimated wet tons used per day Estimated tons of DM Estimated tons of wet silage Estimated days of silage left in inventory 350 200 45 10

ft ft ft tons of dry matter tons of dry matter % tons of wet silage

150 tons of dry matter 333 tons of wet silage 33 days

ESTIMATED TONS OF DRY MATTER IN UPRIGHT SILO
Height of Silage, ft 20 24 28 32 36 40 44 48 52 56 60 64 68 72 76 80 12 12 15 19 23 28 32 37 42 14 16 21 26 32 37 44 50 56 64 71 78 16 21 27 35 41 48 57 65 74 83 93 102 Diameter of Upright Silo, ft 18 20 22 24 27 33 40 47 34 43 52 61 44 53 64 76 52 65 78 93 62 76 92 109 72 89 107 127 82 102 123 147 93 115 140 166 105 129 157 186 117 144 174 207 129 159 192 228 142 174 210 250 155 190 228 272 293 314 334 26 56 72 90 109 129 150 172 195 219 243 273 298 324 350 376 392 28 65 83 104 127 150 173 200 226 254 282 309 340 370 400 427 455 30 74 96 119 145 172 199 229 260 291 324 357 391 425 458 489 520
Source: ASAE, 1997

FeederByMinerDRAFT.xls

Page 3

Inventory Estimator - Tower(B)
Instructions for Inventory Estimation for Tower Silo, Bottom-Unloading 0. Determine diameter of silo and current height of silage. 1. Determine the quantity of dry matter currently. a. match the diameter and height of silage at fill. b. enter tons of dry matter into matching blank. 2. If desired, enter dry matter percent of silage and estimate of wet tons used per day into appropriate blanks. 3. With these inputs, estimates of tons remaining (dry matter and wet) and days of silage remaining will be calculated.

0. Diameter of silo 0. Current height of silage 1. Estimated dry matter in silo 3. DM% of silage 3. Estimated wet tons used per day

ft ft 400 tons of dry matter 45 % 10 tons of wet silage

Estimated tons of DM Estimated tons of wet silage Estimated days of silage left in inventory

400 tons of dry matter 889 tons of wet silage 89 days

ESTIMATED TONS OF DRY MATTER IN UPRIGHT SILO
Height of Silage, ft 20 24 28 32 36 40 44 48 52 56 60 64 68 72 76 80 12 12 15 19 23 28 32 37 42 14 16 21 26 32 37 44 50 56 64 71 78 16 21 27 35 41 48 57 65 74 83 93 102 Diameter of Upright Silo, ft 18 20 22 24 27 33 40 47 34 43 52 61 44 53 64 76 52 65 78 93 62 76 92 109 72 89 107 127 82 102 123 147 93 115 140 166 105 129 157 186 117 144 174 207 129 159 192 228 142 174 210 250 155 190 228 272 293 314 334 26 56 72 90 109 129 150 172 195 219 243 273 298 324 350 376 392 28 65 83 104 127 150 173 200 226 254 282 309 340 370 400 427 455 30 74 96 119 145 172 199 229 260 291 324 357 391 425 458 489 520
Source: ASAE, 1997

FeederByMinerDRAFT.xls

Page 4

Inventory Estimator - Bunker
Instructions for Inventory Estimation for Bunker Silo 0. Determine height, width (at base of face), and length of silage in bunker. 1. Determine the quantity of dry matter in 10 ft length. a. match the height and width of silage face to determine the tons of dry matter per 10 ft of length. b. enter tons of dry matter at fill into matching blank. 2. Enter the length of silage in the bunker into the matching blank. 3. If desired, enter dry matter percent of silage and estimate of wet tons used per day into appropriate blanks. 4. With these inputs, estimates of tons present (dry matter and wet) and days of silage remaining will be calculated.

0. Height of silage face 0. Width of silage face at base 0. Length of silage in the bunker 1. Estimated dry matter in 10 ft of length 2. Length of silage in bunker 3. DM% of silage 3. Estimated wet tons used per day Estimated tons of DM Estimated tons of wet silage Estimated days of silage left in inventory 50 100 24 20

ft ft ft tons of dry matter ft % tons of wet silage

500 tons of dry matter 2083 tons of wet silage 104 days

HORIZONTAL SILO CAPACITY IN TONS DRY MATTER PER 10 FT OF LENGTH (Rounded to the Nearest 5 Tons)
Height of Silage, ft 10 12 14 16 18 20 20 15 15 20 20 25 30 30 20 25 30 35 40 40 40 30 35 40 45 50 55 Silo Width at Floor, ft 50 60 70 35 40 50 40 50 60 50 60 70 55 65 80 65 75 90 70 85 100 80 55 65 80 90 100 110 90 65 75 90 100 115 125 100 70 85 100 110 125 140

Source: Dairy Facilities Han

FeederByMinerDRAFT.xls

Page 5

DM WT<-> Wet Wt

Dry Matter Pounds 45.0 Wet Pounds 2000.0

/

Dry Matter Percent 45.0 =

Wet Pounds 100.0

Dry Matter Percent Dry Matter Pounds X 35.0 = 700.0

5261d69b-cd49-4532-8a34-ac862f56a76c.xls

Page 6

New Wet Weight Calculator

CHANGING OLD to NEW WET POUNDS Old Wet Pounds = 1000 lbs Old Dry Matter Percent = 36.0 % New Dry Matter Percent = 20.0 % New Wet Pounds = 1800 lbs

FeederByMinerDRAFT.xls

Page 7

Batch Mix Sheet

Date: GroupBatch: Number of animals in group: 84 Batch Mix Sheet % DM 35.0 45.0 90.0 90.0 90.0 Feed ID Corn Silage Haylage #5 Hay Grain #1 Cottonseed 0 0 0 0 0 TOTALS 57 9187 Wet lbs to Mix 4800 1867 187 1867 467 Dry Matter Adjustment if +5%DM 4200 1680 177 1768 442 if -5%DM 5600 2100 198 1976 494

Ration Balanced Mix Order 1 2 3 4 5 6 7 8 9 10 Feed ID Corn Silage Haylage #5 Hay Grain #1 Cottonseed lbs DM/cow 20.0 10.0 2.0 20.0 5.0

5261d69b-cd49-4532-8a34-ac862f56a76c.xls

Page 8

DMI Calculator For Month
GROUP: MONTH: YEAR: High October 2007 Dry Matter Intake (DMI) lbs DM/cow/day Pounds DM Percent Pounds DM Percent in Group

Day Of Month Feed Offered Feed Offered Feed Refused Feed Refused Number of Cows

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000

45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45

200 333 250 150 175 200 225 260 400 250 190 100 0 100 180 230 500 300 269 20 200 250 300 100 100

50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50

50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50

43.0 41.7 42.5 43.5 43.3 43.0 42.8 42.4 41.0 42.5 43.1 44.0 45.0 44.0 43.2 42.7 40.0 42.0 42.3 44.8 43.0 42.5 42.0 44.0 44.0

5261d69b-cd49-4532-8a34-ac862f56a76c.xls

Page 9

DMI Graph

Group _____ Month _____ Year _____
70

65

60

55

Dry Matter Intake, pounds

50

45

40

35

30

25

20

15 0 5 10 15 20 25 30 35 Day of Month

5261d69b-cd49-4532-8a34-ac862f56a76c.xls

Page 10


				
DOCUMENT INFO
Shared By:
Tags: Gener, al-Co
Stats:
views:12
posted:11/28/2009
language:English
pages:10
Description: General-Comments