Individual Animal Record Card
A lifetime card for every goat: identity, parentage, origin, age, weights and every event from first service to sale. Age in months and days since last weighing are worked out for you.
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 lifetime card for every goat: identity, parentage, origin, age, weights and every event from first service to sale. Age in months and days since last weighing are worked out for you.
What is included
- Excel workbook (.xlsx) with 2 data sheets (Animal Cards, Animal Events), 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 (portrait) 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.
Animal Cards
One row per goat. Fill Tag ID, Breed, Sex, Class and Date of birth first; age is calculated from the date of birth. Record the latest weight and the date weighed so the card shows how long since the animal was last weighed. When an animal leaves the herd, set Status and the date and reason it left.
Columns: Tag ID, Name, Breed, Sex, Class, Date of birth, Sire tag, Dam tag, Origin, Date acquired, Purchase price (USD), Current weight (kg), Last weighed, Status, Date left herd, Reason left / notes. Calculated: Age (months), Days since weighed.
Summary cells: Animals on cards; Active animals; Average age (months); Average weight (kg); Does; Bucks.
Animal Events
Use this sheet as the running history for every animal. Choose the event from the drop-down and describe it. For treatments give the withdrawal period in days; the sheet calculates the date the animal is clear for sale or slaughter. Filter by Tag ID to see one animal's full history.
Columns: Date, Tag ID, Event, Detail (product, buck, buyer, result), Weight (kg), Cost (USD), Withdrawal (days), Recorded by. Calculated: Withdrawal ends.
Summary cells: Events recorded; Treatments; Total event cost (USD).
Formulas
Age in months uses DATEDIF(date of birth, TODAY(), "m"); days since weighed is TODAY() minus the last weigh date; withdrawal end date is the event date plus the withdrawal days. Counts and averages use COUNTA, COUNTIF, AVERAGE and SUM.
Benchmarks and good practice
- Tag every goat within the first week of life and record sire and dam where known: pedigree registration with the Zimbabwe Herd Book needs both parents.
- Weigh at birth, weaning (90 to 140 days), six months and twelve months, then at least twice a year.
- Keep the card for two years after the animal leaves the herd; medicine records should be kept for five years.
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.