Egg-laying chart

Discussion in 'Chicken Behaviors and Egglaying' started by 3peeps, Nov 5, 2007.

  1. 3peeps

    3peeps Songster

    Jul 4, 2007
    I know this could be done simply with just a notebook, but has anyone ever made or used an egg chart to keep track of your hens' laying records? Would you be willing to share examples?

    I know Excel could be used to generate one, but I don't have that program...what are some other programs that could be used? (I'm not up to date on my computer literacy, but I learn quickly.)
  2. Farmer Kitty

    Farmer Kitty Flock Mistress

    Sep 18, 2007
    I use a small calender and mark the number of eggs collected down on it. [​IMG]
  3. McChix

    McChix In the Brooder

    Oct 30, 2007
    Hi, 3peeps!

    I love the chicken stats! I use graph paper to keep track of my 3 chickens' eggs. Their names across the top, SMTWThFS under each name, and build down week by week. Easy to see production by chicken, week and month - each lays a different color so it's extremely easy to know who's producing. I bring the eggs in and then make a mark in the appropriate square. The computer's great, but if I had to turn it on each time I wanted to log an egg, it just wouldn't happen.
  4. FrozenChicken

    FrozenChicken Songster

    Apr 1, 2007
    Alberta, Canada
    I use Excel unfortunately Zoomshare won't save XLS files so I had to convert to txt.

    The zip file contains the XLS file which you can open with any spreadsheet program and all the formulas are in place.

    How I use the graph:
    On the left under orders I put the customers name,under dozen I put the amount in dozens they want,and under date I put the date they ordered the eggs,under paid I put the date they paid ,delivery status etc of the order. In the sales date I enter the sales each day. So if on the 5th someone paid me 2.00 for a dozen eggs I enter 2 in the amount column. And the last row is for egg production for each day. Under Eggs I just enter the amount.
    At the end of each month I just change from say Janeggssales to Febeggsales, change the dates and zero all the amounts. I change the amount in the H3 formula after each month.

    At the bottom I track anybody I owe eggs to. Some people like to pay in advance for eggs at a later date so I keep track of this as well. And lastly I have 3 types of orders which I track personally as I sell lots of eggs to family, pickup and delivery so I charge different rates. This is for tracking how much is owed to me from these type of customers. It is added to a formula on G5 to track monthly sales.
    Last edited: Nov 5, 2007
  5. mdbucks

    mdbucks Cooped Up

    Jul 14, 2007
    EXIT 109 on 95
    do you have trapboxes so you know who laid what egg? I keep track of eggs laid, but to track each hen seems a little overboard. I tally on a white board and transfer those numbers to a calendar.
  6. 3peeps

    3peeps Songster

    Jul 4, 2007
    Thanks everyone! McChix, that was exactly what I was thinking...just wasn't sure about the layout.

    Frozenchicken...thanks for the links and your descriptions. I'm sure with the number you sell, this is necessary.

    mdbucks, we only have three hens right now, so I can tell who laid what. [​IMG]

    I'm doing this for the entertainment value, as well as to learn about what affects my girls' laying. If I'm really ambitious, I might record the temperature, hours of light provided, treats given, or if a large egg turned out to be a double yolker. Not sure how sustainable this project is, but it will be fun for a while.
    Last edited: Nov 6, 2007
  7. chickbea

    chickbea Songster

    Jan 18, 2007
    Quote:Me too.
  8. SandraChick

    SandraChick Songster

    I keep track daily...who laid and the total for the day.

    I am lucky and have EE's as well as other mutts---they all lay different color, size, shape, textured eggs. I have two that are hard to tell apart- so they get theirs "lumped".

    I use excel....each chicken has their own column and the date is each line. I also have a comment section as the last column---this helps when I'm looking for patterns (like when I suspect they're hiding eggs!)...

  9. Matt Berry

    Matt Berry In the Brooder

    Jun 1, 2007
    SE Michigan
    Excel is a great program for tracking egg production, but like you said you don't have excel.

    As an alternative you can download Open Office from

    is completely FREE, and is an excellent alternative to MS office. It is very powerful, and useful. I normally install it on peoples computers who don't want to shell out the money for MS office.
  10. billyroo

    billyroo In the Brooder

    Oct 14, 2007
    I used excell and created a spead sheet.......

    However I am not sure how to handel the "lost" when we uncovered our RIR on a nest in the weeds with 13 eggs in it.

    Last weekend we found our Pr on 3 in the barn.

    Now I take what we can find and go with it


BackYard Chickens is proudly sponsored by: