The totals will auto-calculate for you and update the summaries and charts as you go. It is pretty simple, just put how many eggs of each type and color in the appropriate slots. This is the fun spreadsheet! I simply pull this sheet up on my phone when I collect eggs and put in the numbers. Don’t worry you can track your roosters, they just won’t count in your hen totals. It will stop counting if you have sold or the hen passed away.

Those three items will automatically calculate if you have a laying chicken, duck, or quail hen. The key fields that need to be filled in correctly for the Egg Laying Spreadsheet to work: The whole spreadsheet links from knowing when your chicks start laying, if they died or were sold, and other notes. It started as a place to keep information about all of our new chicks but has evolved to meet a variety of your needs. This is the main portion of the spreadsheet. All items automatically populate from the items you enter in the next few sheets and is far expanded beyond the view you see below. Need more numbers? Average eggs per hen? Year-to-date profit on your chickens, quail, ducks? Then the Summary Statistics page in the Egg Laying Spreadsheet is all for you. Even if you have no interest in profit and loss you can see your total eggs, egg size, and color all compared! My favorite part are the egg spreadsheets. Trust me, the fake data you see below is nothing like my actual profit… Which is well below zero this year. First you can see how your monthly profit is going and how your running year-to-date profit is headed. For visual learners the Egg Laying spreadsheet starts with some at-a-glance charts. My day job is in Business Intelligence so I know people need a variety of ways to digest data. S ummary statistics, example: average eggs per hen, eggs per month (autofills)īest Part! You enter you expenses, income, and eggs in each sheet and the statistics and charts automatically update! Booyah!.Here is what the Egg Laying Spreadsheet contains: We have had a number of enhancements over the year thanks to people like you! Please keep giving us your feedback about what else you might want to see. If there is enough interest I’ll convert it for you. However, if you desperately need this Egg Laying Spreadsheet in an excel format let me know in the comments. Right now I am offering the poultry tracker and egg production spreadsheet only as a Google Sheet. I like using Google Sheets because they are free and easily accessible from my phone. I love tracking all types of things, but I just cannot do it on paper. Truth time: I made this egg production spreadsheet for myself because I am a geek and wanted to know if my chickens ever broke even, cost-wise, when I sell their excess eggs (Spoiler: I’d keep the chickens anyway). Who is this chicken tracker and egg laying spreadsheet for?īoth the home hobbyist, the small farmer, and geek extraordinaire. If you need the newest version see the link at the very top of the page! However, the guide below will still get you started. We have updated it over the years and it tracks all your poultry, not just chickens. Edit: We now have a 2024 Version Available!ĭo you have chickens? Do you like spreadsheets? Then I have the Egg Laying Spreadsheet for you! No really, joking pitch aside, I have created this free chicken tracker and egg production spreadsheet for you in 2018 and now use this post to show you how to fill it out.

Money and weight tracker excel