Dynama+ AECalc
Step 1 - Complete the AECalc worksheet
To assist new users through the initial steps of compiling a budget that includes a detailed livestock schedule, an example Dynama+ file has been provided with the program files, based on the same central Queensland breeding and fattening beef cattle property modelled in the Breedcow+ section of this wiki user manual.
Enter the budget starting date.
This is the source for the year labels on all Dynama+ worksheets and tables, and will also be used to show first and last dates of the budget year to be compiled in the Dynama worksheet.
The AECalc worksheet requires users (for each year of the budget) to:
- identify the starting weight and annual weight gain for all classes of livestock in the herd,
- specify the month of peak calving and the month of sale of each livestock class, and
- specify the ages of sale cattle in months and their weights at sale.
The values entered in the first year of the AECalc worksheet flow automatically to the remaining years of the worksheet but can be overridden if the relative values of the adult equivalent ratings change over time or if the sale weights of livestock change over time.
In Dynama+, as in Breedcow+, the relative grazing pressure exerted by each class of livestock is estimated by comparing each class to a standard measure, in this case one adult equivalent. This is done in the Dynama+ worksheet AECalc, which is identical to the worksheet used in Breedcow+ except that it can have data entered for up to ten years, providing an opportunity to vary the adult equivalent ratings over time.
As in the Breedcow+ program, the calving peak month in AECalc is used to match the various classes of cattle to their birthdays. In this way, deaths, weaning rates and variable costs can be applied from birthday to birthday for livestock classes, i.e. from 12-24 months, 24-36 months etc. Weaners are an exception, since they are rated from 5 months (when they cease to be rated as calves) until 12 months. The other exception is sale cattle, which are included in the model from their “birthday” until the expected average sale month and given a rating in adult equivalents representing only that part of the year.
Weight entries in AECalc are in two groups:
- average paddock weights for each group at the beginning and end of the period selected
- expected average weight (in the paddock) at sale for each sale group. This weight can be adjusted for weight loss between the paddock and the point of sale in the Prices worksheet.
Ensure that weights on growing cattle correspond to the ages at the start and end of the period selected. Mature cows and bull groups have all ages combined, so cannot have start and end weights. Instead we can use “highest” and “lowest” to produce an average, or preferably just use a single weight to represent an average across the group for the whole year.
It is recommended that the "weight at sale" used in AECalc is the actual paddock weight. Entering paddock weights provides the most accurate estimate of adult equivalent ratings for the overall herd. An allowance for weight loss between the paddock and the point of sale can be made in the Prices worksheet.
Estimating the relative grazing pressure exerted by the various classes of livestock within the herd is not quite as critical in the Dynama+ program as it is in Breedcow+, since the herd data being entered is usually based on actual numbers of cattle running on a property. However, it can be useful to allocate an adult equivalent rating to the current herd as a check on the relative grazing pressure being exerted over time as the current herd changes in composition or total numbers. This is especially so for scenario analysis.
Note: Any loaded data will copy over the top of previously entered values.
The AECalc Example
Open the AECalc sheet in Dynama+ and copy the example file Dynamaplus 10 years user manual base herd. Once the file is showing in Dynama+ Scenario List select Open to view and edit the file.