Tracking your chickens' egg production is not only fun, it's a really good way to monitor the health of your flock. Often a reduction in laying is the first sign that something is wrong, since laying eggs takes so much energy out of a chicken, so by keeping track of who is laying what - when - you can sometimes get a jump on anything that's gone awry.
A former accountant, I'm a bit of a spreadsheet freak, I admit! So I created this customizable chart that you can use to track your girls' egg production. It's a Google Sheet which you will need to download and then make a copy of in order to enter your own data.
Alternatively, you can print out each month and write in the information by hand - but then all the totals will need to be manually calculated as well - or the data will then need to be entered into the spreadsheet at the end of the month. If you have children, you might want to print out the sheet for the month and have them write in how many eggs they collect each day in pencil, then either they or you can input the numbers into the spreadsheet.
To begin using the chart, first you'll want to enter your name or your farm name where the gold words are in brackets  at the top.
Then, down the left hand side, you have the option of setting up the categories you want to track. You can replace the [Color/Name] cell on each line with whatever you want.
If you have a small flock, you might want to enter the name of each hen to be able to count how many eggs she lays each month.
If your flock is larger and you can't match an egg to a specific chicken, you can track your egg production by egg color. Or if you have separate flocks, you might track the eggs by coop. It's up to you. Those rows where it says [Color/Name] in gold are for you to customize with what works for you.
(Note: you only need to type in your categories once - in January - they will autofill down the sheet for the remaining months.) If you need more lines, you can insert them easily and if there are too many lines, then go ahead and delete them. The formulas should all still work just fine.
And that's it. As you collect your eggs and type in numbers, you will get totals by day, by category, by month and for the entire year at the bottom of the chart. (I do apologize, I had meant to share this before the start of the new year, but better late than never, right?)
IMPORTANT: After you click on the link above and the template comes up, you'll need to click on "File", then "Make a Copy" and save it to your computer. Then you'll be able to edit your spreadsheet.
Remember that no chicken lays an egg every day, so there's no reason to panic if you notice one skip a day here and there, and production naturally slows during extreme heat, the molting season and the shorter days of winter, but you should be able to see a bit of a pattern over time - and use the chart for fun or an educational tool for your kids, if nothing else.
Enjoy! And if you have any trouble using the spreadsheet, please email me at Lisa@fresheggsdaily.com.
Be sure to subscribe to my newsletter so you get my weekly blog posts, advance notice of sales and promotions plus new product news delivered right to your inbox!