Free chicken egg tracker spreadsheet: Henstead Lite
Henstead Chicken & Egg Tracker Lite is a free egg production tracker for backyard keepers. Add your hens, log the eggs you collect each day, and the spreadsheet works out your totals, average eggs per day and laying rate, with charts on a mini dashboard.
Who it’s for
New backyard keepers who want to see how many eggs their hens really lay, families who want a simple daily habit for the kids, and anyone curious about which hen is the star layer. Logging takes under a minute a day, and the dashboard fills in by itself.
What’s included
- Start Here tab with a quick start and clickable tab links
- Flock records for 15 birds with breed, egg color, hatch date, automatic age and status dropdowns
- Egg Log with 400 rows: log by hen or by whole flock
- Egg Stats: laying rate for 7 and 30 days, month-by-month and week-by-week totals, hen-by-hen stats and top 10 hens
- Dashboard with 4 KPI tiles, an egg goal progress bar and 3 charts
- Settings with editable dropdown lists
Excel-format .xlsx for Microsoft Excel; tested in LibreOffice Calc; built with standard functions that also work when you open it in Google Sheets.
What the full version adds
The full Henstead Chicken & Egg Tracker adds feed and supply expenses with cost per dozen, egg sales and customers with unpaid balances, a money summary with profit, a health log with egg withdrawal countdown, a coop chores checklist, a 21-day hatch calendar with lockdown date, seasonal notes with a year-vs-year chart, an 8-tile dashboard with 5 charts, room for 60 hens and 5,000 egg entries, and a printable user guide.
How to download
Downloading is free with a free Taskdale account. Free downloads are limited to 3 per day. Your hens and egg rows copy straight into the full version if you upgrade later.
License
Personal use only. Please don’t resell, share or redistribute the file. Author: Taskdale.
Reviews
There are no reviews yet.