DHI Agronomy Turf Food & MilkWater & EnvironmentalAbout AgSourceLocations News Contact

How To - Genetic Selection Guide


 
  • Access the online Genetic Selection Guide
  • Select Heifer Report
  • Set Filter - Quartiles 1 and 2
  • If you want to select only heifers over 10 months, use Age range filter. Fill in Between 10 and 999 months.
  • Click on "Apply Filter"
  • Under File Exports, click on CSV (Excel)
  • This will export your file into Excel software (if that is on your computer)
  • Delete column E or move it to the right of "Est NetMerit Amt."
  • Save the Excel file
  • Go back to the Genetic Selection Guide and select "Cow Report" from the top menu bar.
  • Set Filter - Quartiles 1 and 2
  • If you want to select any other filters, you can do that here.
  • Click on "Apply Filter"
  • Under File Exports, click on CSV (Excel)
  • This will export your data into a new Excel file.
  • Delete columns E and F or move them to the right of "Net Merit"
  • Copy the remaining data below the column headings.
  • Paste it on the saved spreadsheet with the heifer data. Be sure you are pasting in column A.
  • Sort the sheet on Column E "Est NetMerit Amt." Largest to smallest.  If Excel prompts you, select "Expand the selection."
  • Select the number of animals that makes up 25% of your herd. Set the Print area for the first five columns and print your list.
 
;