BREDSUM Reports

Using the \A switch will include all bulls, both AI and bulls in bullpens, in the BREDSUM report. BREDSUM by default does not include bull breedings unless the \A switch it used. This report requires you to select an additional option from a pop-up window after you enter the command. In the example below, the Sire option is selected.

The \A switch is used in addition to a second category switch, such as SIRES.

This switch displays conception rates by service number as well as overall conception rates. The columns in the table are identical to those under the sire option.

The \C switch displays a report that groups the breeding by the calendar month that the insemination occurred.

This option allows you to select a specific date range by entering start and end dates. After entering the BREDSUM\D command, you will be prompted to enter start and end dates.

To look at only the last 6 months, use BREDSUM\D180 to specify the number of previous days to view from the current day.

Using the\E switch displays the number of cows that are entering the interval and are eligible to be detected as "in heat". It provides an analysis of 21 day insemination rate and 21 day pregnancy rates.

At the end of the report, the total for the year is displayed (or another time interval if used). The insemination rate is calculated through yesterday. The pregnancy rate is current to 42 days ago. Conception rate is not displayed but could be roughly calculated by Number Pregnant/Number Inseminated. Keep in mind that inseminated cows with unknown or unreported outcomes may skew the results.

In addition, the insemination rate can be skewed falsely upwards by unknown outcome cows that are really OPEN because the "missed" heat at 21 days post insemination cannot be calculated. For example, a cow inseminated 28 days ago with an unknown outcome should have an estimated "missed" heat at day 21 if she is truly OPEN. If she is truly pregnant, she should not be included. There is not a way to know if she should be included or not, hence, none of the unknown outcome post-insemination cows can be included in the insemination rate calculation. This typically affects the last two 21-day intervals. For this reason, the last two cycles of values are shown but not included in the yearly value. The report provides an analysis of 21-day insemination rate and 21-day pregnancy rates.

The \F switch displays a report that groups the breeding in order of the straws used.

The \G switch displays a report that groups the breeding by Time Gap.

This option is similar to the Q-Sum graph used for conception. It is useful for small herds to track heat detection efficiency over time. The report is formatted to be limited to one page; therefore, the date range covered varies from herd to herd.

The columns displayed show the date of the heat, the cow ID, the lactation number, and the days in milk at the heat date. At the bottom, overall efficiency of heat detection is displayed. Youngstock will have their age in months displayed rather than days in milk. It starts out "in the middle", and for each heat or missed heat, if the estrus was detected, it moves the pointer to the right. If the estrus was not detected, the pointer is moved to the left, displaying trends in heat detection efficiency over time.

Each cow’s record is examined for known events such as heats, breedings, freshenings, etc. These known events are then used to insert a date for a "missed" heat, with the best estimate of the date of this missed heat being 21 days prior or after a known event. This should not be viewed as an absolute date, but as a best guess only. A related option under the EVENTS command allows you to insert a missed heat "event" into all cows' records, allowing this event and related items such as date of missed heat, days since last missed heat, etc. to be used for action and monitoring.

If the conception outcome of an inseminated estrus is known, the point is coded as follows:

• A: For cows known to conceive at that estrus (but aborting later)
• B: For a detected estrus that an insemination occurred, but the conception outcome has not yet been determined
• C: Animals that displayed heat signs even though they may already be pregnant from a prior estrus
• E: Estimated date of estrus of conception for a pregnant animal with no known breeding date
• H: An estrus that was detected and recorded, but no insemination occurred during this estrus
• I: An estrus that was induced by prostaglandin
• M: The date of the "missed" heat, determined by the method above
• O: A breeding that a cow is known to have not conceived at
• P: An estrus that resulted in a conception

This report requires an additional option to be selected. In the example below, the Stud Code option is selected.

This switch looks at the heat intervals between breedings, summarizing conception rates for each interval. This has more applicability for larger herds, with more animals per interval. The end of the report contains statistics for average days to first heat, days to first breeding, days to conception, and calving intervals when looking at the REPORT tab. Columns are similar to those described under the By Sire option.

The \J switch groups the breeding by Activity Level.

The \K switch uses the time the BRED event was entered.

This switch groups the breeding by stud code for the selected date range.

This switch groups the breeding by the cycle number, grouped by days in milk that the insemination occurred.

This switch summarizes performance by the breeding code assigned during the BRED event. Typically, these codes indicate either treatments around or at the time of breeding or heat signs detected. The columns in the table are identical to those under the sire option. Before you can use this option, you must set up the table of breeding codes using ALTER, Breeding and Technicians. This table may contain up to 128 codes, identified by a one letter code and a 15 letter description. The breeding code letter is then specified when prompted during the BRED event entry. The breeding code letter number appears on cowcard page 1 beside the BRED event.

This switch groups the breeding by Pen for the BRED event.

This switch displays statistics regarding prostaglandin usage for treatments recorded as events in DC305. DC305 first displays the event list, then prompts for the event that is used as prostaglandin. The report includes event statistics reported between treatment and conception rate intervals. The event PROST must be defined using ALTER-defined events.

Prostaglandin used for estrus induction must be recorded separately from therapeutic and other uses. The EVENT PROST cannot only be a remark of another event.

This switch is useful for small herds to track conception efficiency over time. The report is formatted to be limited to one page; therefore, the date range covered varies from herd to herd. The date range can be further narrowed with the switch. The columns displayed show the date of the insemination, the cow ID, the sire used, the number of times bred, and the technician number. It starts in the middle, and for each insemination conception occurred at, the pointer is moved to the right. If the breeding was unsuccessful, the pointer is moved to the left.

The graph helps illustrate trends in conception over time. If the conception outcome of an inseminated estrus is known, the point is coded as follows:

• A: Cows known to conceive at that estrus (but aborting later)
• C: An already pregnant animal that receives an insemination
• E: Conception for a pregnant animal with no known breeding date
• O: Breeding that a cow is known to have not conceived at
• >P: Animals that conceived on the given estrus date
• R: For more than one breeding during a given 5 day period

Using the \R switch displays a graph conception rates for the specified time frame. This option is best viewed in the GRAPH tab. The graph contains four colors:

• Green: Normal
• Red: Early warning of conception problems
• Yellow: >10% unknown outcomes
• Purple: >10% of breedings occurred within 2 days of a prior breeding (repeats)

This switch summarizes performance for each sire with a recorded breeding in the herd. It lists the sires by their NAAB code name, then lists the percent pregnant (including confirmed abortions), the number pregnant, the number open, and number of "other" outcomes (breedings where either cow is still pending pregnancy confirmation, departed herd with an unknown outcome, or breedings that occurred post-conception). It lists the total number of services the sire used, as well as measures the percent usage of the sire versus the total services within herd. The last column, SPC, reports services per conception for each sire. This number is the inverse of the conception rate (%Preg). At the bottom of the list are the totals for all sires used in the herd.

This switch summarizes performance by the technician inseminating the animal. If the number of the technician is added to the command following the \T, the summary will be for that technician only. Before this option can be exercised however, a table must be set up to identify the technicians performing inseminations within the herd. This table is set up using ALTER, Breeding and Technicians, Modify Technician Table, and Add a Technician. The table may contain up to 128 technicians, identified by a one digit code number and a 15 letter name. The technician number is then specified when prompted during the BRED event entry. The technician number appears on cowcard page 1 beside the BRED event and is also stored in the item TECH.

By default, animals in the bullpen are not displayed in the BREDSUM reports. If using the \U switch, the analysis will display only bullpen animals.

Using the \V switch denotes the voluntary waiting period for DIM for cows and days old for heifers in the BREDSUM report. This report requires you to select an additional option from a pop-up window after you enter the command. If only \V is entered, the system will prompt for VWP to be used as well. The default VWP is 50 DIM for LACT>0, while it is 365 days of age for LACT=0. In the example below, the Sires option is selected.

This switch groups the breeding by the day of the week the insemination occurred.

The \X switch report provides advanced reproduction analysis. It allows for analysis of two conception rate parameters on the same report. Use \Xab, where a is the first parameter and b is the second. For example, BREDSUM\XTO.

Analysis of youngstock (heifers) in BREDSUM can be done by using the \Y switch. This report requires you to select an additional option from a pop-up window after you enter the command. In the example below, the Breeding Code option is selected.

The \Z switch can be used to compare the various breeds of the bull being used to service the cows.