Mastitis pattern analysis tool

identify problem areas and potential risks to udder health and gives farmers and vets a way of tracking progress in the herd.

Automated mastitis reports 

Register for pattern analysis reports to be sent automatically after every milk recording - Sign up

CDL converter

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

CDL converter

Instruction for installing the CDL converter file

Instruction to use the CDL converter file to convert data to 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

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.

This tool is only compatible with Microsoft Excel running on PC and is not currently support on Mac OS