ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
TOTAL FEED PER DAY
*Use to estimate total commodity usage and needs
2
YOU CANNOT EDIT THIS ONE, CLICK FILE - > MAKE A COPY TO GET YOUR OWN VERSION TO EDIT
3
Total Head44(Step 1)
4
~l/cow/day706(Step 2)
5
Mixer Cap. (l)6000(Step 3)
6
7
(Step 4)
8
Corn Silage25%7766liters/day
9
Haylage50%15532liters/day
10
Grain Products10%3106.4liters/day
11
HM Corn15%4659.6liters/day
12
Straw Filler0%0liters/day
13
0%0liters/day
14
0%0liters/day
15
16
TMR100%31064liters/dayActual Loads5.18
17
Total Loads6
18
19
TOTAL FEED PER LOAD
*Use during feeding
20
21
22
Actual %Accum%Actual (l)Accum (l)
23
Corn Silage22%22%1294.3333331294.333333
24
Haylage43%65%2588.6666673883
25
Grain Products9%73%517.73333334400.733333
26
HM Corn13%86%7775,177
27
Straw Filler0%86%05,177
28
0%86%05,177
29
0%86%05,177
30
31
TMR86%5,177liters/load
32
33
34
35
36
LEGEND
Default Mixer Capacities (l)
CommodityMin %Max %
37
User InputsKuhn RA14211893Corn Silage2050
38
Feed % InputsSiloKing 181416000Haylage2050
39
Good ValueAnderson A70023475Grain Products115
40
Bad ValueAnderson A95029393HM Corn325
41
Straw Filler035
42
INSTRUCTIONS
43
1. Start by inputting your number of owned cows into the box labeled "Total Head".
44
2. Next adjust how much you think your cows will eat in "~l/cow/day". You can find instructions on what value to use below.
45
Without seasons or the cattle breeds mod, cattle eat 500 liters per head per day and that value can remain as is.
46
With seasons or the cattle breeds mod, that value will be different and may need to be adjusted as you go.
47
With seasons, I recommend filling the bunk to it's full two day capacity and seeing how much it accepts.
48
You can then divide that number by the amount of head you have and that is your starting number.
49
But as the cattle get fatter, that number will change so be mindful of your bunks.
50
So with that in mind, the user input for l/cow/day may need to tuned daily to fit your operation.
51
24 hours after giving them 1 days worth of food, if they are out of food, you need to increase that value
52
If they have a lot of food leftover, you need to decrease that number.
53
I suggest starting in increments of 5 and working you way down to increments of 1 as you get it tuned in.
54
3. After inputting l/cow/day, you want to input the capacity of your mixer wagon in liters. The default values can be found above.
55
4. Next you can choose to adjust how much straw, hay and silage you wish to use in your ration or you can use my default values.
56
Note that those three percentages must add up to only 100% or else your ration will be incorrect.
57
58
Once you have completed these steps, the top section of the spreadsheet will tell you exactly how much all of your cattle
59
will be eating of each commodity as well as how much mixed feed for one 24 hour day.
60
61
The bottom section will now tell you how to load your mixer for each load. The amount of loads to be fed for that day can be
62
found in the box labeled "Total Loads".
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100