This tool identifies problem areas and potential risks to udder health and gives farmers and vets a way of tracking progress in the herd.
The Mastitis Pattern Analysis Tool uses some of the information found in a Milk Recording File known as a CDL (common data layer) file. Obtain the herd CDL from NMR, CIS or QMMS, and use the CDL converter to extract the required information, in .csv format
If clinical mastitis cases are not recorded in the CDL they can be merged in from a CSV file using the converter.
The data must be laid out exactly as in the example file MastitisExample.csv. The first two columns (date and cow line number) are necessary, the rest are optional. Download the template file Mastitis.csv. Make a copy of this file containing your own data and use to merge in when prompted by the converter. The file can be opened in Excel, data typed in, then save it again in CSV format. Make sure the file name still begins with "mastitis". e.g. mastitis_ManorFarm.csv NOT ManorFarm_mastitis.csv
For assistance contact firstname.lastname@example.org
Herd Pattern Analysis Tool
The tool will analyse data from your individual herd and produces a report on the pattern of mastitis on your farm. It will also identify the predominant mastitis infection pattern present on your farm.
This will allow farmers and vets to work together to assess and prioritise key management areas and potentially detect emerging problems. Milk recording herds are at an advantage as cow SCC information is readily available.