BREDSUM Reports
3 min
bredsum is the dairycomp command used to examine the effectiveness of a breeding program bredsum has options to produce most of the traditionally used reproductive statistics and measures, including services per conception, conception rates, days to conception, and q sum conception graphs it also contains options to produce some other less familiar measures such as prostaglandin effectiveness, interval analysis, and q sum for heat detection efficiency most of the bredsum outputs create a table that groups individual breedings by categories and displays numbers of breedings and percentage totals in each category there are some predefined options for grouping available (by sire, by stud code, by technician, by breeding code, etc ) you will be prompted to select your preferred grouping option when you run the bredsum command further grouping can be done by use of for and by statements, used in the standard manner of other commands within dairycomp bredsum looks at all breedings for animals in the condition list if no condition list is entered, the entire herd over the past 365 days, including dead cows, is used see the topics below to get started with bredsum reports run a bredsum report start by typing the bredsum command followed by any switches docid\ xyinqirjavg7x2 1rpyab and any for or by statements for instance, the following command runs a bredsum report for heifers/youngstock bredsum\y bredsum\y after entering the bredsum command, dairycomp will prompt you to select a bredsum grouping option; double‑click to select the option when including switches in the command, consider the following information if you prefer to use a different time frame than the entire past year, the switch \d ( bredsum\d ) will prompt for the starting date and the ending date of the time interval to be examined to look at only the last 6 months, use bredsum\d180 to specify the number of previous days to view from the current day bredsum by default only runs the reports for cows using bredsum\y only runs reports for heifers/youngstock cows and youngstock cannot be combined in one report see bredsum switches for a full list of bredsum switches docid\ xyinqirjavg7x2 1rpyab you can use in the bredsum command click here to see a bredsum report example docid\ xyinqirjavg7x2 1rpyab bredsum report example the below bredsum report example is displayed in the grid window after selecting the sire grouping option note that bredsum examines the "breeding result code" set for each breeding; these codes are set by the different events such as preg, open, and bred itself the result codes are p p pregnant o o open r r rebred c c post conception breedings e e estimated breedings (used in natural service herds when no known breeding date can be identified) non‑ai breedings (bull or no sire) are listed separately from the ai breedings and are not included in the ai calculations report columns bredsum report columns are described below 95% ci 95% ci 95% confidence interval range %conc %conc conception risk from breedings with known outcomes #preg #preg count of inseminations with know outcome of pregnant #open #open count of inseminations with know outcome of open other other inseminations with unkown outcomes or 2 day re breeds abort abort count of inseminations that resulted in an abortion total total total inseminations (preg + open + other) %tot %tot percentage of total inseminations in this category spc spc services per conception (inverse of conception rate) bredsum switches when you enter the bredsum command, you can add any of the switches listed in the table below for example, you can enter bredsum\s to run the bredsum by sire report after you press enter, you may also be prompted to select an additional option for the report double‑click on an option to run the corresponding report the table below defines each of the bredsum options expand each description for details switch switch description description \a by all bulls ai \b by times bred \c by calendar month \d by select date range \e by 21 day insemination rate \f by order straws \g by breeding time gap \h bredsum heat detection \i by interval analysis \j by activity level \k by hour of the day \m by stud code \n by breeding cycle \o by breeding code \p by pen of the bred event \pg by prostaglandin analysis \q by q sum graphs \r by week of conception \s by sire \t by ai technician \u use bullpen breeding only \v denote voluntary waiting period \w by day of week \x cross table analysis \y include youngstock \z by breed of sire \\ by semen type bredsum syntax this section summarizes the syntax used with the bredsum command in the command line and outlines the options available through either use of switches or by selections from a menu for statement for statement bredsum will accept conditional statements using for followed by item constraints these for statements can be used in an identical manner to for statements used with other commands (list, graph, etc ) in dairycomp common examples would include limiting analysis to adult cows (for lact>0), to heifers (for lact=0), to certain breeds (for cbrd=h), or to specific freshening groups (for dim>120 dim<180) by statement by statement by statements can be used with bredsum in an identical manner to by statements used with other dairycomp commands common examples would be by lact, by stage, or by cbrd see command line docid\ u nbrveqbf6nzsp1bc9e0 for more information on using conditional statements in your commands