BUCK AND DOE RATIO.xlsx

	A	B	C	D	E
1	MANAGING A DEER HERD ON 250 ACRES
2	This spreadsheet proves that it takes twice the land to grow 3 year old bucks as it does for 2 year old bucks
3	This is a theoretical 250 acre piece of hunting land that is being managed for an optimum deer herd of 1 deer per 10 acres, therefore the maximum herd size is 25 deer after hunting season. Each Doe averages 2 Fawns a year, and half are bucks. 10 deer are lost per year to fawn mortality, poaching, and accidents. The charts show two different possible examples of balanced herd sizes. To maintain balanced herd numbers, the harvest must be 1 Doe for every Buck.
4
5
6
7
8	Simple math tells us that to shoot all 3 year old Bucks on average, the size of any given Buck herd must be 3 times the amount of Bucks that the hunters shoot each year (4 yr old Bucks, herd size must be 4 times the number harvested etc.)
9
10
11	Chart 1 shows a continuously balanced herd size of 10 Bucks and 15 Does, and the hunters needing to shoot 10 Bucks and 10 Does each year to keep the balance, which means on average they are shooting smaller 2nd year Bucks.
12
13
14	Chart 2 shows a continuously balanced herd of 15 Bucks and 10 Does, and the hunters shooting 5 Bucks and 5 Does each year, which means on average they are shooting 3rd year Bucks, but only half as many.
15
16
17
18
19	ENTER Buck Hunters=	10	CHART 1 Starting Herd Size (BUCKS)=		10
20	ENTER Doe Hunters=	10	Starting Herd Size (DOES)=		15
21	These charts show the only way to keep the deer numbers balanced is to shoot one Doe for every Buck
22	This chart shows that with higher doe numbers and lower buck numbers a lot of small buck will be shot
23	YEAR	BUCKS	DOES	Buck Harvest	Doe Harvest
24	Herd Size year 1	10	15	10	10
25	Herd Size year 2	10	15	10	10
26	Herd Size year 3	10	15	10	10
27	Herd Size year 4	10	15	10	10
28	Herd Size year 5	10	15	10	10
29	Herd Size year 6	10	15	10	10
30	Herd Size year 7	10	15	10	10
31	Herd Size year 8	10	15	10	10
32	Herd Size year 9	10	15	10	10
33	Herd Size year 10	10	15	10	10
34
35
36	ENTER Buck Hunters=	5	CHART 2 Starting Herd Size (BUCKS)=		15
37	ENTER Doe Hunters=	5	Starting Herd Size (DOES)=		10
38	This chart shows the only way to keep the numbers balanced is to shoot one Doe for every Buck
39	This chart shows with lower doe numbers and higher buck numbers larger buck will be shot, but in smaller numbers
40	YEAR	BUCKS	DOES	Buck Harvest	Doe Harvest
41	Herd Size year 1	15	10	5	5
42	Herd Size year 2	15	10	5	5
43	Herd Size year 3	15	10	5	5
44	Herd Size year 4	15	10	5	5
45	Herd Size year 5	15	10	5	5
46	Herd Size year 6	15	10	5	5
47	Herd Size year 7	15	10	5	5
48	Herd Size year 8	15	10	5	5
49	Herd Size year 9	15	10	5	5
50	Herd Size year 10	15	10	5	5
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100