Health and Treatment Register
A medicine register that satisfies good-practice requirements: product, batch and expiry, dose and route, meat and milk withdrawal periods, and an automatic clear-to-sell date. It counts animals still in withdrawal and totals treatment costs.
2 files to download
- XLSXExcel workbook (.xlsx)
- PDFPrint-ready PDF (A4)
Downloads unlock on your private order page as soon as payment is confirmed, and a link is emailed to you.
A medicine register that satisfies good-practice requirements: product, batch and expiry, dose and route, meat and milk withdrawal periods, and an automatic clear-to-sell date. It counts animals still in withdrawal and totals treatment costs.
What is included
- Excel workbook (.xlsx) with 2 data sheets (Treatment Register, Medicine Stock), an Instructions sheet and a Lists sheet that feeds the drop-downs. Opens in Excel 2010 or later, LibreOffice and Google Sheets.
- Print-ready A4 PDF (landscape) with GBAZ branding, ruled rows, an instructions panel and a notes box on every page.
- Farm details block, yellow input cells, drop-down lists, data validation, frozen headers, filters and print titles on every sheet.
Treatment Register
Record every medicine given, including dips, sprays and dewormers if you do not keep the separate log. Copy the batch number and expiry from the pack and the withdrawal periods from the label or your veterinarian. The register works out the earliest slaughter date, how many days have passed and whether the animal is clear to sell today. Never sell or slaughter an animal marked No.
Columns: Date, Tag ID or group, No. treated, Symptoms / diagnosis, Product (trade name), Batch no., Expiry, Dose (ml / g per animal), Route, Meat withdrawal (days), Milk withdrawal (days), Treated by, Cost (USD), Outcome / notes. Calculated: Clear for slaughter from, Days since treatment, Clear to sell?.
Summary cells: Treatments recorded; Animals treated; Still in withdrawal; Treatment cost (USD); Average cost per treatment.
Medicine Stock
Log each medicine when you buy it so you can trace batches and avoid using expired products. Days to expiry turns negative once a product has expired: dispose of it through your veterinarian or supplier and note the disposal in the Notes box.
Columns: Date bought, Product, Use (disease / parasite), Supplier, Batch no., Expiry, Quantity (ml / g / doses), Cost (USD), Stored where (fridge / cupboard). Calculated: Days to expiry.
Summary cells: Products in stock; Expiring within 60 days; Expired; Medicine purchases (USD).
Formulas
Clear for slaughter from = treatment date + meat withdrawal days; days since treatment = TODAY() - treatment date; clear to sell = IF(TODAY() >= clear date, "Yes", "No"); days to expiry = expiry - TODAY(). Totals use SUM, COUNTA and COUNTIF.
Benchmarks and good practice
- Good practice (Cornell Small Farms, Uganda MAAIF guidelines): record product, batch, dose, route, who treated and the earliest date the animal clears withdrawal; keep medicine records for five years.
- Withdrawal periods differ for meat and milk and are longer when a product is used off label. Ask your veterinarian or the Department of Veterinary Services if the label is unclear.
- Mark treated animals (marker spray or coloured tag) so they are not sold by mistake. Tell buyers about any animal that has not cleared withdrawal.
- Use only ivermectin and other injectables registered for goats; some products registered for cattle cause severe reactions in goats.
Layouts follow the record books recommended by extension services (FAO, ILRI, Heifer International Zimbabwe, Cornell Small Farms, Uganda MAAIF and WormBoss guidance), adapted for Zimbabwean goat breeders by GBAZ.
Goat Breeders Association of Zimbabwe
Sold on the GBAZ platform on behalf of Goat Breeders Association of Zimbabwe, who delivers the product.