Egg-laying chart

[3peeps]

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

 

[Farmer Kitty]

I use a small calender and mark the number of eggs collected down on it.

 

[McChix]

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.

 

[FrozenChicken]

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.

 

[mdbucks]

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.

 

[3peeps]

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.

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.

 

[chickbea]

Quote:
Me too.

 

[SandraChick]

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

 

[Matt Berry]

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.

 

[billyroo]

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