Processor milk data downloaded, reshaped in Excel and imported into herd software every morning, replaced by an automatic import with exceptions flagged.
- 120 hoursEstimated annual time released (20 min × 365 days)
- 1 listExceptions to review instead of every row
- 06:42Typical time the import has finished, before milking is done
Illustrative example. Figures are calculated from typical timings, not a measured customer result. Real case studies will replace these as implementations are measured.
Before
Every morning after milking someone downloads the processor file, opens it in Excel, deletes columns, fixes the date format, saves it as a new file and imports it into the herd software, then deals with the warning about unmatched animals. About 20 minutes a day, seven days a week.
After
The file is detected when it arrives, validated, converted into the herd software's import format and imported. Unmatched animal IDs are listed for a person to check. Every run is logged with the time and record count.
