Difference between revisions of "Breedcow+ Breedcow"
| Line 10: | Line 10: | ||
This section specifies the calves weaned as a proportion of cows retained and deaths for each class of livestock where relevant. Each age group in this table is labelled with the age at both the start and end of the year and the groupings used should be the same as applied in the AE Calc worksheet. Entries for female classes up to 13/14 years of age is possible. | This section specifies the calves weaned as a proportion of cows retained and deaths for each class of livestock where relevant. Each age group in this table is labelled with the age at both the start and end of the year and the groupings used should be the same as applied in the AE Calc worksheet. Entries for female classes up to 13/14 years of age is possible. | ||
| + | A major change has been to the way the values for Calves weaned /Cows retained is calculated or entered in Version 6.02. | ||
| + | Values can now either be entered directly into the cells opposite Calves weaned/Cows Retained (row 16) or values can be entered into rows 11, 12, 13 and 14 to describe the reproductive performance for each age group of females. Once values have been entered in these four rows, the PregTest macro can be run and the Calves weaned/Cows retained values will be calculated and entered into Row 16 against the relevant age groups. | ||
| + | The PregTest macro of version 6.02 applies all of the data entered in rows 11, 12, 13, and 14 for each female age group to calculate all of the Calves weaned /Cows retained values. The PregTest macro of Version 6 required users to enter values for expected conception rate, calf loss, empties sold and pregnant females sold for individual age groups. | ||
| + | The PregTest macro of Version 6.02 will also calculate values for the percentage sales after mating for female age groups and enter them in Section E: Female Herd Structure when they are entered in Section A and the macro run. | ||
| − | + | ||
| + | |||
| + | ---- | ||
Revision as of 22:59, 12 August 2020
Step 5. Entering data in the Breedcow+ Breedcow worksheet
Once the Growth Path, AECalc, Prices, and Huscosts sheets have been completed, open the Breedcow worksheet, to complete the herd model and start to analyse the impact of alternative herd management strategies.
Section A: Calving and Death Rate Assumptions
This section specifies the calves weaned as a proportion of cows retained and deaths for each class of livestock where relevant. Each age group in this table is labelled with the age at both the start and end of the year and the groupings used should be the same as applied in the AE Calc worksheet. Entries for female classes up to 13/14 years of age is possible.
A major change has been to the way the values for Calves weaned /Cows retained is calculated or entered in Version 6.02. Values can now either be entered directly into the cells opposite Calves weaned/Cows Retained (row 16) or values can be entered into rows 11, 12, 13 and 14 to describe the reproductive performance for each age group of females. Once values have been entered in these four rows, the PregTest macro can be run and the Calves weaned/Cows retained values will be calculated and entered into Row 16 against the relevant age groups. The PregTest macro of version 6.02 applies all of the data entered in rows 11, 12, 13, and 14 for each female age group to calculate all of the Calves weaned /Cows retained values. The PregTest macro of Version 6 required users to enter values for expected conception rate, calf loss, empties sold and pregnant females sold for individual age groups. The PregTest macro of Version 6.02 will also calculate values for the percentage sales after mating for female age groups and enter them in Section E: Female Herd Structure when they are entered in Section A and the macro run.