This file contains a template to enable the electronic submission of information relevant to your mating program to BREEDPLAN for inclusion in the calculation of Days to Calving EBVs.
Do not delete columns from these templates under any circumstances. If the column does not apply to you, simply leave the column blank. Information submitted in the incorrect format will not be processed by BREEDPLAN.
The "Example Data Submission" sheet provides example records to show how to enter the matings information into the template. Use these examples in conjunction with the explanations below as a guide when recording your matings data.
Once you have entered your matings information into the template, please email the completed file to BREEDPLAN for processing. When emailing the file, please ensure you also include a short note providing a brief description of the mating data included in the file. (eg Autumn 2010 mating program)
BREEDPLAN takes no responsibility for data entered via the Excel template other than to try and load the information as supplied. It is the breeders responsibility to ensure that the information entered is accurate and complete.
Entering Information into the Template
This column is for internal BREEDPLAN processing purposes only. A "V" should be entered for any records in which information has been entered. Note - This value should not need to be manually entered - it should appear automatically when the Cow Ident is entered.
Enter your Breed Society Herd Ident. You should only need to enter this in the first row. Once the first row is completed, the Herd Ident should automatically appear when you enter the Cow Ident.
Enter the Breed Society Ident of the cow for which the joining information is being submitted. Note: the full Society Ident of the cow must be entered, not just the Tattoo.
Enter the date of the mating program event described by the event code for the cow in this particular mating season.
Enter the event code for this mating program event for the cow in this particular mating program:
Enter the Breed Society Ident of the sire for the joining for the cow in this particular mating season. Leave blank for Z, E and M events.
Enter a management group to identify mobs of cows in the same mating program. Also identify any cow/s whose fertility may have been affected by other circumstances and should be subgrouped from the mob. A maximum of three characters (letters or numbers) can be used to describe each management group.
|Bull Out Date||
For Natural mating events (N), enter the date the sire was removed from the cow mob. For mating periods (event code = M), enter the expected date to complete this mating program. Leave blank for Z, E, A and I events. The date should be entered in the format of ddmmyyyy (eg. 01012000)
Repeat for up to two more mating program events for the cow. Use multiple lines for each cow if more than three events are required.
If the cow was flushed to collect ovum, enter the date that the cow was flushed. You do not need to record a mating that corresponds to the flush (the flush date is all we need). The date should be entered in the format of ddmmyyyy (eg. 01012000).
|Number of Embyros||
(Optional) Enter the number of embryos that were flushed from the donor dam. Values between between 0 - 20 will be considered valid.
|Preg Test Result||
Enter the pregnancy test result for the cow in this particular mating season. The pregnancy test result should be either:
Enter the date of pregnancy testing for the cow in this particular mating season. The date should be entered in the format of ddmmyyyy (eg. 01012000)
Enter the date that the cow was disposed of in this column. The date should be entered in the format of ddmmyyyy (eg. 01012000)
Enter the disposal code that best describes the reason why the female was disposed in this field. NOTE - THIS DISPOSAL IS FOR BREEDPLAN USE ONLY. This disposal is not available to the Society and the Society disposal code may be different.
This value should be automatically included when the cow ident is entered. The column is important and is for internal BREEDPLAN processing purposes only.
- Where a cow has more than 3 different joinings in the one mating season, start a second row for the cow and specify the 4th joining in the Event 1 columns. Note: the Herd Ident and Cow Ident must be specified in each and every row.
- If it is easier to enter only one joining per row for each cow, multiple rows can be used for each cow. Note: the Herd Ident and Cow Ident must be specified in each and every row.
- Pregnancy test results can be entered as a separate record to the joining information. Note: the Herd Ident and the Cow Ident must be specified in both rows.
- The Data Input Form is automatically set to print the first 1000 lines. If you wish to print less than 1000 lines, you will need to reset the print area.
- If you wish to remove the information boxes that display when you click in each cell, select "Data" from the toolbar at the top of the page, then "Validation". From within this area, select the "Input Message" tab and unclick the "show input message when cell is selected" option.
Should you require any further assistance, please contact staff at BREEDPLAN.