This file contains a template to enable the electronic submission of information relevant to your embryo transfer (ET) program to BREEDPLAN. This information is not currently included in the calculation of Days to Calving EBVs, but will be used to assist AGBU researchers identify how it may be used in the BREEDPLAN analysis in future.
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 mating information into the template. Use these examples in conjunction with the explanations below as a guide when recording your mating data.
Once you have entered your mating 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 data included in the file (e.g. Autumn 2021 - 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. |
| Herd Ident |
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. |
| 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. |
| Event Date |
Enter the date of the mating program event described by the event code for the cow in this particular mating season. |
| Event Code |
Enter the event code for this mating program event for the cow in this particular mating program: |
| Sire Ident |
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. |
| Man Grp |
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 (e.g. 01012019) |
|
Use multiple lines for each cow if more than one event is required. |
|
| 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. |
Helpful Hints
- If the cow has had more than one joining event, use multiple lines to record these. Note: the Herd Ident and Cow Ident must be specified in each and every row.
- 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 your BREEDPLAN processing centre.
