Production Units

Retrieving Data from Dairy Comp 305

Revised 11/12

PRODUCTION UNITS

Average number of cows- most easily determined from your end of year DHI Herd Summary

If you do not have a DHI Herd Summary, in Dairy Comp use ECON\ID to average your animal numbers.

Type ECON\ID on the command line and press enter. Then, when prompted, enter the beginning and ending dates for the time period you wish to review.

Next it will prompt for the events you want to look at. Select the events you would like to look at by left clicking a “check” in the associated box. (You do not have to select any events to proceed to seeing the weekly animal counts for the last year.)

(Note that EGRAPH is more powerful for analyzing individual events. This function is a very nice way to look at what has happened on the farm historically with many different parameters integrated.)

Then click the OK box.

Once you are looking at the graph you can,

Turn lines on and off, by left clicking on categories in the “key” box on the right.
Zoom in by left clicking and dragging a box from upper left to bottom right, (zoom out by making a box in the opposite direction).
Force the graph to display the weekly averages for a line by double left clicking the line. Turn the values off by double clicking the line again.

This box is zoomed in and we double clicked on the “Milking” line to get an idea of the number of animals milking throughout the year. (Add Dry to get adult totals.)

To see the detailed number of animals for each week through the last year, click on the Report Tab below.

You can also send this report to Excel (if Excel is installed on your PC) for averaging the weeks or calculating the percentages. Left click on the “Send to Spreadsheet” button.

The red box to the right of the spreadsheet button will send the report to PowerPoint (if you have it installed on your PC).

Note the average number of cows by either eyeballing the line in the graphor by sending the numbers to your spreadsheet and calculating the averages.

Number of Stalls

Number of stalls can be found in Dairy Comp if you are running Version 8 and have setup the stall counts.

ALTER\4

CULLING REASONS

The best way to get reasons animals were sold is the “dead cow” report in monitor.

ECON\ED FOR LACT>0 will give for all animals that have calved at least once.

E designates the dEad cow report.

D designates prompt for Date. If you do not prompt for dates the default is the last 365 days.

Enter the dates when prompted.

- Dairy Comp 305 ----- Farm Credit Dairy Benchmark Example ------Page Command : ECON\ED FOR LACT>0

------Dairy One ------12/20/11--

Cows sold/dead from 1/ 1/11 through 12/30/11

CAR Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec TOT

======

Low Production 1 8 0 2 5 2 2 12 8 1 6 6 53

Reproduction 0 1 0 1 0 1 4 0 0 2 0 10 19

Disease/Injury/Other 1 3 3 1 3 6 0 3 7 1 2 2 32

Died 7 11 8 8 4 1 3 7 6 8 6 4 73

Mastitis / Udder 7 2 2 2 2 1 3 1 2 4 3 3 32

Johnes 3 0 0 1 0 0 0 0 0 0 1 0 5

Injured 5 5 4 5 2 0 1 3 4 2 3 3 37

Mean 0 0 2 0 1 2 1 2 2 1 0 1 12

Tough Milker 0 0 1 2 0 0 2 2 1 2 0 0 10

Totals 24 30 20 22 17 13 16 30 30 21 21 29 273

Like most things with Dairy Comp you may have customized your reasons sold. Your reasons sold are defined in Setup under the codes tab. If you care about the way the reasons sold line up in your DHI processing center, do not change them. If you do not care how they line up at DHI, you can change them any way you prefer.

CALCULATED RATE

Number of animals culled and number culled in the 1st 60 days by lactations

EVENTS\6SI FOR LACT=1

EVENTS\6SI FOR LACT=2

EVENTS\6SI FOR LACT>2

You will be prompted for the dates you want reflected and the events (select sold and died), and then a table of events by 30 day in milk increments will be created.

In this example, you would count SOLD 7+5, and Died 6+2, for a total of 20 animals sold at 60 or fewer days in milk in first lactation animals. There were a total of 111 1st lactation animals sold and died this year. Repeat for 2nd lactation and 3rd and greater.

NOTE- This will include any animals sold for dairy, you will need to subtract them for your total number.

HERD QUALITY DATA

Calving Interval

SUM CINT for Lact>1 (There has to be more than one calving to find the interval between them, thus the “for lact>1”.)

This gives the average calving interval as 407 days. If you would like that in months, divide the 407 by 30.4 (the average number of days in a month). In this case, that would be 407/30.4=13.4 months.

Breedings (Services) per Conception

BREDSUM\BD will prompt for the Date range, and then will return the %CONC (Conception Rate and SPC service per conception by Breeding number and for all breeding codes).

- Dairy Comp 305 ----- Farm Credit Dairy Benchmark Example ------

- Command : BREDSUM\BD

------Dairy One ------

Summarized By Times Bred from 1/1/11

Bred Number %Conc #Preg #Open Other Abort Total %Tot SPC

======

1 24 204 636 85 13 925 27 4.1

2 29 178 440 78 11 696 21 3.5

3 28 130 329 42 7 501 15 3.5

4 28 91 236 33 7 360 11 3.6

5 30 70 165 29 2 264 8 3.4

6 27 42 113 14 4 169 5 3.7

7 18 21 93 11 2 125 4 5.4

8 21 18 69 11 1 98 3 4.8

OTHERS 14 28 173 41 3 242 7 7.2

TOTALS 26 782 2254 344 50 3380 100 3.9

This herd has 3.9 Services per Conception (SPC) or a 26% Conception Rate.

Somatic Cell Counts

SUM %88.50.0.AVSCC FOR LACT>0

The yearly SCC average is 196,000 in this example.

Average Age of First Calf Heifers

SUM AGEFR FOR LACT=1

The Average Age of Freshening for first lactation animals is 24 months for this herd.

Average Days in Milk

Average Days In Milk is best taken from the Dairy One Herd Summary, or use ECON\ID, select your date range and select all events. On the graph uncheck all the boxes EXCEPT the DIM box and click on the DIM line to estimate.

Herd Summary (Page 2)

ECON\ID

Average Age Entire Herd

SUM AGE FOR LACT>0

The average age for the milking herd is 45 months in this example.

Average Days Dry

SUM DDRY FOR LACT>1

There needs to be more than 1 calving to have a number of days dry, thus the “for lact>0”.

1st, 2nd, and 3rd Lactation Peak Days in Milk

SUM %81.99.DPEAK FOR FDAT>-365 DIM>60 BY LCTGP

Alternatively you can run each lactation separately by using FOR FDAT>-365 DIM>60 LACT=1, FOR FDAT>-365 DIM>60 LACT=2, and FOR FDAT>-365 DIM>60 LACT>2

This report will have cows that have freshened in the last year and are over 60 days in milk.

Average MUN

Note- This will only work if you are testing for MUN and have had the item setup in Dairy Comp when downloading testday data.

SUM %84.50.0.AVMUN FOR LACT>0

CALF DATA

Bull and Heifer calves DOA

EVENTS\3S

Select the date range

In this example Bull DOA=40 and Heifer DOA=43

First Lactation and Older Lactation Freshenings

EVENTS\3S FOR LACT=1 will return the same table as seen above for only first lactation animals. Use the total under the Fresh column.

EVENTS\3S FOR LACT>1 will return the same table as above for 2nd and greater lactation animals. Use the total under the Fresh column.

NUMBER OF FRESHENING (COWS/HEIFERS)

Total Number Live Heifer and Bull Calves

EVENTS\3S Take the total number of female calves minus the number of female dead. In example above it would be 630-43 or 587 live heifer calves. Do the same for Bull calves.

Number of Twin Events

EVENTS\3S Use the total number of twins, in the example above there are 51 twin events

Number of 1st Calf Heifers DOA

EVENTS\3S FOR LACT=1 Use the total dead column

Heifer Non-Completion- Wet Calves and Weaned Calves

EVENTS\2SI FOR LACT=0

Select the date range

Select the SOLD and DIED Events.

Create the list and left click on the DIM column to sort it. When this report is run for Heifers, DIM is Days in Age of the calf. Use your age at weaning and count the number of animals until that point. This is your non completion for wet calves. Use the total number and subtract your wet calf number for your non-completion for weaned calves.

In this example farm animals are weaned at 70 days. There are 10 Heifers sold or died up to 70 days of age and 16 (26-10) that were sold or died after 70 days of age.

REPRODUCTION

21 Day Preg Rate

BREDSUM\ED

This example herd has a pregnancy risk of 21%, meaning that 21% of all eligible, 21 day cycles, resulted in a pregnancy for this time period.

Percent Cows Pregnant at 150 Days in Milk

BREDSUM\ER Click on the Graph Tab at the bottom, click on the cross hairs button and find the point where the black line intersects with 150 days in milk (DIM)

In this example the percent still open is 32% so the percent pregnant is 100-32 or 68% of the herd is pregnant by 150 DIM.

Number of DNB (Do Not Breed) Cows

PCT RC=1 LACT>0

There are 16 cows or 1% of the herd in this example.

Percent Sexed Semen

BREDSUM\MD Select the start and end date. Look for all the sexed semen stud codes and add them together for the total percentage of sexed semen being used in the entire herd.

In this example 12% of heifers are getting bred to sexed semen.

-- The Dairy Benchmark team thanks Jack van Almelo of Dairy One for providing this summary.