Testing maintain_herd_size with example_freestall.xlsx

	A	B	C	D
1		mcr 53 ("baseline")	mcr 30 (more heifer calves to keep )	mcr 70 (fewer heifer calves to keep)
2	"herd_size_sell_threshold": 101,
3	"herd_size_buy_threshold": 95,
4
5
6	Calves_ver_agg	9	15	2
7	Heifers_hor_ver_agg	85	143	35
8	Dry cows_ver_agg	13	10	6
9	Milking cows_ver_agg	86	93	92
10	Total cows_ver_agg	99	103	99
11	Total milk, kg_ver_agg	1279927	1384837	799161
12	Milk per cow/d, kg_hor_ver_agg	41	41	24
13
14	Calves born_ver_agg	122	130	57
15	Calves sold_ver_agg	55	34	41
16	Calves stillborn_herd statistics_ver_agg	7	8	2
17	Heifers sold repro culls_ver_agg	8	17	3
18	Heifers sold_ver_hor_agg	8	17	3
19	Heifers bought_ver_agg	3	0	0
20	Average age at first calving_ver_agg	689	691	689
21
22	Total cows died_hor_agg	5	4	5
23	Cow mortality_hor_agg	5%	4%	5%
24
25	Cows sold_ver_agg	33	65	12
26	Cows sold oversupply_ver_agg	9	46	3
27	Cows sold acute_hor_agg	24	19	9
28	Cow sales plus deaths_hor_agg	38	69	17
29	% herd turnover_herdexits_hor_agg	38%	67%	17%
30
31	Open cows_ver_agg	33.3	39.3	64.5
32	VWP cows_ver_agg	28.0	27.0	13.5
33	Preg cows_ver_agg	65.6	63.6	34.0
34	Average DIM_ver_agg	159.7	139.2	719.6
35	Average DCC_ver_agg	134.9	118.1	131.2
36	Average parity_num_ver_agg	2.4	1.6	2.3
37	% L1_hor_ver_agg	34%	57%	40%
38	% L2_hor_ver_agg	23%	30%	25%
39	% L3_hor_ver_agg	26%	9%	18%
40	% L4_hor_ver_agg	9%	3%	7%
41	% L5_hor_ver_agg	2%	1%	5%
42	% L6+_hor_ver_agg	5%	0%	5%
43	Average calving interval_herd statistics_ver_agg	379.881445	384.992001	383.7035428
44	Lact cow DMI, kg_ver_agg	863317.7948	919007.0822	739938.6043
45	DMI / lact cow / d	27.6	27.0	22.0
46
47	Total calf bw sold, kg_ver_agg	2415.766062	1490.49438	1800.125881
48	Avg calf bw sold, kg_hor_agg	43.92301931	43.83806999	43.90550929
49	Total heiferII bw sold, kg_ver_agg	3710.871373	7941.452921	1447.569444
50	Avg heiferII bw sold, kg_hor_agg	463.8589217	467.1442895	482.5231481
51	Total heiferIII bw sold, kg_ver_agg	0	0	0
52	Total cow bw sold, kg_ver_agg	21583.48221	41091.46668	8093.769801
53	Avg cow bw sold, kg_hor_agg	654.0449154	632.1764104	674.4808167
54	Avg mature bodyweight, kg_ver_agg	737.7362686	735.0450283	747.8646908
55	Total heiferIII bw bought, kg_hor_agg	1814.831221	0	0
56	Net heiferIII bw sold, kg_hor_agg	-1814.831221	0	0
57	NE_g calves sold, MJ_hor_agg	66433.56671	40988.59544	49503.46173
58	NE_g heiferIIs sold, MJ_hor_agg	40819.58511	87355.98213	15923.26389
59	NE_g NET heiferIIIs sold, MJ_hor_agg	-19963.14343	0	0
60	NE_g cows sold, MJ_hor_agg	323752.2331	616372.0002	121406.547
61	NE_g all meat sold, MJ_hor_agg	411042.2415	744716.5777	186833.2726
62	NE_l all milk sold, MJ_hor_agg	3905876.022	4226024.036	2438752.146
63	total NE milk and meat_hor_agg	4316918.263	4970740.614	2625585.419
64
65	milk allocation factor_hor_agg	0.90	0.85	0.93
66
67
68	summarize from the oversupply log: of cows sold in the last year…
69	# sold	9	46	3
70	avg milk	25	34	0
71	% L1	11%	48%	0%
72	% L2	56%	39%	67%
73	% L3+	33%	13%	33%
74	avg dim	383	259	1710
75	avg dcc	34	97	0
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