Tag: eggs

Edit: We now have a 2021 Version Available!

We may already be a week into 2019, but it is not to late to start tracking your home chicken egg production with this easy spreadsheet.  In 2018 I released a version that allows you to track your chickens, egg production, sizes, colors, income, and expenses.  Everything the home chicken hobbiest might need to keep their flock’s statistics.  I’ve made some tweaks and am now happy to offer another free egg and chicken tracker for 2019.  This way everyone can keep up with how deeply in the hole their chickens are taking them :).

2019 Egg Laying and Chicken Flock Tracker

As with last year’s model I am releasing this utility for tracking eggs and other chicken statistics via Google Sheets.  I like Google Sheets because I can access it on my phone and easily enter in eggs while I collect them.  I used the sheet myself for all of 2018 and got the following charts at the end of the year.  We started with a new flock that did not start laying until July which is why there are no eggs for the first few months.:

So what’s New for 2019?

1. Added XL eggs.  Apparently some of you are all fancy and actually measure and grade these eggs out.  For you I added the calculations for XL eggs in all colors!
2. Created a separate sheet for the lazy in us.  It is a pared down version of the larger tracker for those that just want to track some basics.

Tell us more about the Easy Tracker!

So you want to know more about the simple egg tracker?  Well I took out the sizing, as I heard many people did not weigh their eggs nor did they want to guess the size.  I left in color, but you can skip that entirely and just put in a total. It also removes a chart and shortens the summary.  You still get all the totals, averages, and goodies.

So How do I Use the Free Chicken Egg Tracker?

I made a pretty good guide on how to use the tracker in 2018.  It still works just click that link!  Also there are some details and release notes inside the first page of both trackers.

Great I’m Sold! How do I get it?

I sure hope you are sold on this egg and chicken tracking spreadsheet because, well, it is free!  No catch, I just like making utilities for myself and if others find it useful then great.  Click on the links below and you will be prompted to make a copy for yourself.  As usual if there is enough demand I will consider making this in Excel or a printable pdf version.

• 2019 Simple Chicken Tracker and Egg Laying Spreadsheet (No More Size Tracking)
• 2019 Robust Chicken Tracker and Egg Laying Spreadsheet (Now with XL)

Other Helpful Links:

• Example Chicken Tracker and Egg Laying Spreadsheet with Data  (2018)
• 2018 Post that gives a walk through of the Tracker

All I ask for payment is that you share this post if you think others can use it and let me know your questions, comments, and ideas for improvement in the comments below!

If you purchased or hatched chicks for the first time this spring you may be wondering when your chickens will start laying. One of the things that will drive any chicken owner crazy is waiting for your first egg. BUT how do you know when your chicken will start laying? The general rule of thumb is that chickens will start laying around 6 months old (22-28 weeks) is the norm, but there are some precocious breeds that start earlier. Even if your chickens start laying in the normal range that still leaves 1-2 months of uncertainty, *le sigh*. While, we can’t predict with perfect accuracy when your chicken will start laying here are some signs that you may get an egg in a week or two, which, for my inpatient heart is a step in the right direction.

Signs Your Chicken Will Start Laying Her First Egg

How Much Time Since Hatch?

Remember below are just estimates of when these different breeds of chickens will start laying. However, it does help to know if you have a late or early egg laying breed.

• Buff Orpington: 24 Weeks
• Barred Plymouth Rock: 20 Weeks
• Easter Eggers: 20 Weeks
• Cochin: 30 Weeks
• Brahma: 30 Weeks
• Favorelle: 23 Weeks
• Silkie: 32 Weeks
• Polish: 26 Weeks
• Sussex: 22 Weeks

Your Chicken Should Be Fully Grown

After knowing about when your chicken breed might start laying, the first way to tell that your chicken might be ready to lay an egg is the way your chicken looks! Most chickens need to be fully grown to lay an egg. Seems like a no-brainer, except with my first flock I wasn’t sure what ‘fully grown’ looked like. Pullets may look as though they are grown with large sizes and lots of beautiful feathers. To tell if a hen is fully grown you will need to inspect the comb and wattles. These should be dark red (or blue, or black, or whatever color your chicken breed has). The comb and wattles need to be fully pigmented and swollen to final size. The chickens will have all their adult feathers and finally lost their terrifying teenage look. Unless you were our speckled Sussex. She started laying waaaay before she was done with wattles and feathers… If I hadn’t seen her laying myself I still wouldn’t believe our pullet was capable of laying while looking so teenagery still.

Squatting behavior

When your chicken is ready to lay her first egg she will often do a funny little squat when you come up to her. Before our pullets began to lay even the tame ones would kind of sidle away and dart around when we would approach to pet them. Then suddenly, a few of them would stop and drop when we went to pet them. A quick brush of the hand and they’ll fan their rumps in the air. Not to be chicken graphic, but this is what they would also do for a rooster. If you want to be a little less gross think about how a cat will stick its butt in the air when you pet them at the base of their tale… Same concept.

Being in the Nesting Boxes

Another good way to know when your chickens will start laying is to note who suddenly started showing interest in the nesting boxes. We had a new flock this year and made sure to fill up the nesting boxes around 20 weeks with straw. They hens took a look at the boxes and then promptly ignored them.

Side note: If you have a small coop beware, they can get in the habit of hanging out in the nesting boxes due to lack of room. This makes for gross nesting boxes and problems later.

Anyway, a couple of weeks after I filled the nesting boxes with straw, I noticed the Barred Plymouth Rock rooting around in the box. Sure enough, she was the first to lay. Our larger Welsummer was in the coop a lot checking the nesting boxes out recently and I caught her laying this week!

There are a couple other ways that aren’t quite as easy to tell if your chicken is going to start laying. But they still they are generally true for a lot of chickens.

Start Making a Bock-Bock Noise

Don’t you just love my scientific description of chicken noises :)? I’m pretty sure my three year old can do a better impression of a chicken.  That being said, chickens that are about to start laying will often be noisier. They will develop an egg laying bock-bock noise. It is hard to describe for first time chicken owners, but once you get accustomed to the sound you will know when they start practicing that noise. There are some breeds that a quieter than others like our cochins and brahmas but most chickens get pretty verbal around laying time.

Chickens Become More Tame/Stand Ground

Some chickens are just not going to be squatters as mentioned above, but they all seems to settle down a bit when they are going to start laying eggs.. Generally speaking, chickens will also just lose some of their flightiness around laying time. Unless you are our Polish… That thing is always crazy. Chickens that are about to lay will just start to get more secure in their surroundings. Our layers will hold their ground when I open up the nesting boxes, even when they aren’t actively laying. They will come more when we called and just generally settle down and act like a mature, sensible chicken (again, minus our Polish). I have always assumed it was because they start to cement their adult pecking order and see us as the heads of the flock. Also, think about when you were a teenager (Crazy)… versus when you are an adult (sensible… Okay, less crazy).

All the above are pretty good signs to know when your chicken will start to lay, but also remember each chicken is an individual. We have two Welsummers that hatched at the same time. One had crop issues as a chick (we thought we might lose her at one point) and ended up smaller than the other Welsummer. She still hasn’t started laying and the other has been laying for over a week now.

Early Laying Breeds

Finally, if you just can’t wait to get some eggs consider raising breeds start young.  Here is a quick list of young egg layers, that also happen to be good egg producing chickens.

• Plymouth
• Sussex
• Easter Eggers
• Orpingtons (though in our case our Oprington was sloooow to lay)
• Australorps
• Leghorns

We would love to hear when your different breeds started egg laying.  If we get enough comments then we can work on honing down our averages!

Edit: We now have a 2021 Version Available!

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.  You can scroll to the bottom of the directions to get your free egg laying and chicken production spreadsheet if you aren’t into reading about the spreadsheet.  There is also a link copy that shows you what it looks like with data.

Who is this chicken tracker and egg laying spreadsheet for?

Both the home hobbyist, the small farmer, and geek extraordinaire.

Truth time: I made this chicken 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). I love tracking all types of things, but I just cannot do it on paper. I like using Google Sheets because they are free and easily accessible from my phone.  Right now I am offering the chicken tracker and egg production spreadsheet only as a Google Sheet. However, if you desperately need this Egg Laying Spreadsheet in an excel format let me know in the comments. If there is enough interest I’ll convert it for you.

I envision a number of enhancements for 2019! But I wanted to get it out there for other people to use this year and give me feedback about what else they might want to see.

Here is what the Egg Laying Spreadsheet contains:

• At a glance chart (auto fills)
• Summary statistics, example: average eggs per hen, eggs per month (autofills)
• Chicken Log
• Egg Log
• Expense Tracking (optional)
• Income Tracking (optional)

Best Part! You enter you expenses, income, and eggs in each sheet and the statistics and charts automatically update! Booyah!

Egg Laying Spreadsheet Dashboard

My day job is in Business Intelligence so I know people need a variety of ways to digest data. For visual learners the Egg Laying spreadsheet starts with some at-a-glance charts. First you can see how your monthly profit is going and how your running year-to-date profit is headed.  Trust me, the fake data you see below is nothing like my actual profit…  Which is well below zero this year.

My favorite part are the egg spreadsheets. Even if you have no interest in profit and loss you can see your total eggs, egg size, and color all compared!

Chicken Summary Statistics

Need more numbers?  Average eggs per hen? Year-to-date profit on your chickens?  Then the Summary Statistics page in the Egg Laying Spreadsheet is all for you.  All items automatically populate from the items you enter in the next few sheets.

Chicken Log

This is the main portion of the spreadsheet. It started as a place to keep information about all of our new chicks but has evolved to meet a variety of your needs. The whole spreadsheet links from knowing when your chicks start laying, if they died or were sold, and other notes. The key fields that need to be filled in correctly for the Egg Laying Spreadsheet to work:

• Laying Date
• Death/Sale date if applicable

Egg Log

This is the fun spreadsheet! I simply pull this sheet up on my phone when I collect eggs and put in the numbers. It is pretty simple, just put how many eggs of each type and color in the appropriate slots. The totals will auto-calculate for you and update the summaries and charts as you go. I have left what exactly goes in sizes and colors up to you.  I tend to put cream eggs with white and tan eggs with brown, etc. but that decision is up to the individual chicken owner.  Pro-tip: you can put in total eggs, and skip color and sizes but you will lose you size and color charts.

Expense & Income Tracker

For those chicken owners that want to get a little more into the numbers the expense and income sheets exist. I have some suggested categories for chicken owners, but in reality you can put whatever you want. I am hoping to add more statistics and charts based on the categories in the future. Some examples I am considering: Cost of each egg per amount of feed, Average Carton Price, etc.

If you are a hobbyist and just want to look at how many eggs you have, you can skip these pages or fill out the bare minimum:

• Date
• Amount

Categories that must be filled out are marked with an asterisk *.  Filling those columns in is all that is required to use the Chicken Egg Tracking Spreadsheet. I really want feedback from you about what else you might want this spreadsheet to do. Please let me know in the comments and if you found it useful then please share this on social media. 

Empty Chicken Tracker You Can Use This sheet will prompt you to make a clean copy ready for you to fill in with your information.

Example Chicken Tracker and Egg Laying Spreadsheet with Data   Use this sheet to view how you might want to fill your in

I spent a lot of time creating something I thought might be of value to you, chicken owners, and would like to have your feedback. Please let me know in the comments what other items you might want to see in the spreadsheet. I’ll see about future enhancements for later this year!