1. If this is your first time on BYC, we suggest you start with one of these three options:
    Raising Chickens Chicken Coops Join BYC
    If you're already a member of our community, click here to login & click here to learn what's new!

Egg-laying chart

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

  1. 3peeps

    3peeps Chillin' With My Peeps

    368
    0
    139
    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
    Wisconsin
    I use a small calender and mark the number of eggs collected down on it. [​IMG]
     
  3. McChix

    McChix Out Of The Brooder

    59
    0
    29
    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 Chillin' With My Peeps

    135
    2
    143
    Apr 1, 2007
    Alberta, Canada
    I use Excel unfortunately Zoomshare won't save XLS files so I had to convert to txt.http://lumbergrader.zoomshare.com/files/Egg_chart.txt
    http://lumbergrader.zoomshare.com/files/Egg_Chart.zip

    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 Chillin' With My Peeps

    368
    0
    139
    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 Chillin' With My Peeps

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

    SandraChick Chillin' With My Peeps

    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!)...

    Sandra
     
  9. Matt Berry

    Matt Berry Out Of The Brooder

    54
    0
    29
    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 http://www.openoffice.org/

    It
    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 Out Of The Brooder

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

    However I am not sure how to handel the "lost" eggs...like 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

    billyroo
     

BackYard Chickens is proudly sponsored by