Free Excel template · Excel for farms and growers

Free egg production log template

Q: How do I calculate lay rate for my hens?

Divide eggs collected by the number of hens: =C7/B7 for a day. For a week or month, divide total eggs by total hen-days, the sum of the daily hen counts.

Q: How do I convert eggs to dozens in Excel?

Divide by 12 for the exact number of dozens, =E21/12. For whole cartons use =INT(E21/12), and =MOD(E21,12) for the eggs left over.

For small flock owners and farms that sell eggs. Each day, enter the hens in the flock, eggs collected, eggs you could not sell and feed used. The template works out the lay rate, sellable eggs and dozens, feed cost per dozen, egg sales at your price, and whether laying went up or down from one week to the next.

cellwise-egg-production-log.xlsxExcel workbook · 4.8 KB · works in Excel, Google Sheets, Numbers and LibreOffice · no signup

Download free template

Preview and try it

This is the template's sheet, calculated by the same engine as the Cellwise app. Change any number to see the formulas react before you download.

	A	B	C	D	E	F	G	H
1	Egg production log
2	Flock	Layers, barn 1
3	Feed cost per lb	0.24
4	Price per dozen	6
5
6	Date	Hens	Eggs collected	Unsellable	Sellable	Lay rate	Dozens	Feed (lb)
7	Oct 19, 2026	48	38	2	36	0.79166666667	3	12.5
8	Oct 20, 2026	48	40	1	39	0.83333333333	3.25	12
9	Oct 21, 2026	48	36	3	33	0.75	2.75	12.5
10	Oct 22, 2026	48	41	1	40	0.85416666667	3.3333333333	12.5
11	Oct 23, 2026	48	39	2	37	0.8125	3.0833333333	12
12	Oct 24, 2026	48	37	1	36	0.77083333333	3	12.5
13	46320	48	42	2	40	0.875	3.3333333333	12.5
14	46321	48	35	2	33	0.72916666667	2.75	12
15	46322	47	38	1	37	0.8085106383	3.0833333333	12
16	46323	47	36	3	33	0.76595744681	2.75	12
17	46324	47	39	1	38	0.82978723404	3.1666666667	11.5
18	46325	47	40	2	38	0.85106382979	3.1666666667	12
19	46326	47	37	1	36	0.78723404255	3	12
20	46327	47	34	2	32	0.72340425532	2.6666666667	11.5

How the formulas work

Lay rate per day

F7=IF(B7>0,C7/B7,0)

Eggs collected divided by hens in the flock. 38 eggs from 48 hens is a 79.2% lay rate. Update the hen count the day you lose or add a bird, as on day 9, so the rate stays honest.

Lay rate for the period

F21=IF(B21>0,C21/B21,0)

Total eggs over total hen-days (the sum of daily hen counts), not the average of the daily rates. It weighs each day by the birds you actually had.

Whole dozens and leftovers

B23=INT(E21/12)

INT drops the fraction, so you get the full cartons you can sell. B24 uses MOD to show the loose eggs left over. Doing this on the total, not per day, stops you losing a carton to rounding every day.

Feed cost per dozen

B27=IF(E21>0,ROUND(B26/(E21/12),2),0)

Feed cost divided by sellable dozens. Here $40.68 of feed made 42.3 sellable dozen, so feed alone costs $0.96 a dozen. Add cartons, bedding and your time for the full cost.

Make it yours

Collect and count at the same time each day. Late collection means more dirty and cracked eggs.
Weigh feed when you fill the feeder and note the date; a lb figure per day is fine as an average between fills.
Copy the sheet for each month. A falling lay rate across months shows molt, short days or an aging flock.
Note anything unusual (heat, a predator scare, new birds) in a column to the right so the dips make sense later.

FAQ

How do I calculate lay rate for my hens?

Divide eggs collected by the number of hens: =C7/B7 for a day. For a week or month, divide total eggs by total hen-days, the sum of the daily hen counts.

How do I convert eggs to dozens in Excel?

Divide by 12 for the exact number of dozens, =E21/12. For whole cartons use =INT(E21/12), and =MOD(E21,12) for the eggs left over.

How do I work out feed cost per dozen eggs?

Multiply the pounds of feed used by the price per pound, then divide by the dozens of sellable eggs from the same period: =ROUND(feed_cost/(sellable_eggs/12),2).

Functions used

Related guides

More free templates

Updated November 2, 2026