Pay in$ US dollars₹ Indian rupees

Daily Milk Yield and Lactation Tracker for Dairy Farms (Excel)

From $2.00 Pay what you want. Suggested $299.00

Log each milking and see every animal’s litres to date, peak day, last-week trend, a simple 305-day projection and a daily chart, with an alert when an animal’s yield is falling.

Instant download. Price in Indian rupees; international buyers pay about $9 USD at the current rate.

$

Minimum $2.00. Pay the minimum, or more if you would like to support this work.

  • Instant download right after payment
  • Secure checkout by Razorpay. UPI, net banking and cards work in rupees
  • Pay what you want: from $2 (or ₹199). Pay more if you would like to support the work
  • All sales are final. Please read the delivery, refund and licence policy

Description

Know which animals are slipping, before the month ends. Milk records only help when you can read them. Log each milking in this Excel tracker and it works out, for every animal, how it is doing and where it is heading.

What it works out

  • For each animal: litres so far, peak day, average per day, days in milk, and milk income to date.
  • This week against last week, and persistency (this week against the peak).
  • A simple 305-day projection from the last 7 days.
  • A red alert when an animal’s yield falls by more than a level you choose.
  • A herd summary and a daily chart for any animal you pick.
  • Optional fat % logging.

What is inside (one Excel file, six sheets)

Start Here, Summary, Settings, Animals (up to 60), Daily Log (up to 5,000 rows) and Chart. Three example animals with 28 days of example milk are filled in: delete them and enter your own.

Good to know

  • The projection is a straight line from the last 7 days, not a lactation-curve model. A falling animal will finish lower, and a rising one higher. If days are missing from the log, litres to date are under-counted, and the sheet shows how complete each animal’s records are.
  • It does not give feeding, breeding or veterinary advice.
  • Every figure was checked against an independent calculation. It uses standard Excel formulas and was checked in LibreOffice. It has not been tested in Microsoft Excel itself or in Google Sheets. It holds many formulas, so it may open a little slowly on a phone.
  • Pay what you want, from $2 (or ₹199). The suggested price is $9. Pay the minimum, or more if you would like to support this work.
  • Instant download after payment: up to 5 downloads within 12 months.
  • All sales are final. Please read this page and our delivery, refund and licence policy before you buy. If the file is damaged or does not arrive, we will fix or replace it.
  • Licensed for use on your own farm. Please do not copy, share or resell the file.

By Dr. Rameez Bloch, BVSc & AH, MVSc (Gujarat Veterinary Council Reg. 3570).