Ultrasound Data Final.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Lot #	Anm Tag	Anm Birth Date	Assn	Reg No.	YR Adj SC	Marb EPD	RE EPD	USND Actual Scan Wt	USND Scan Wt Ratio	USND Adj PCT IMF	USND PCT IMF Ratio	USND Adj Ribeye	USND Ribeye Ratio	USND Rib Fat
2	1	L52	05/27/23	AAA	20745883	40.72	1.03	1.02	1115	99	3.08	87	13.1	104	0.24
3	2	L67	05/22/23	AAA	20745888	41.23	0.75	1.41	1115	98	3.01	85	11.9	94	0.25
4	3	L309	08/11/23	AAA	20928625		0.91	0.89	1160	121	3.18	95	11.6	117	0.26
5	4	L57	05/25/23	AAA	20745884	38.14	1.53	0.85	1110	95	4.71	133	12.6	100	0.28
6	5	L91	05/25/23	AAA	20745878	38.14	1.07	0.74	1100	103	3.42	97	11.4	100	0.21
7	6	L159	05/26/23	AAA	20747082	39.17	1.45	0.71	1070	101	4.71	133	10.8	95	0.21
8	7	M20	01/21/24	AAA	20935527	41.07	1.26	1.41	1220	107	5.2	102	15.3	113	0.34
9	8	M24	01/13/24	AAA	20935528	41.31	1.65	0.95	1230	109	5.45	107	13.6	101	0.3
10	9	M50	02/13/24	AAA	20935516	38.28	0.99	0.95	1205	105	3.91	77	14	105	0.35
11	10	M19	01/25/24	AAA	20935522	42.2	1.4	0.98	1060	94	6.34	124	12.7	94	0.27
12	11	M43	02/05/24	AAA	20935517	39.05	1.09	0.9	1225	105	6.15	121	13.3	100	0.42
13	12	M58	02/25/24	AAA	20935537		0.84	1.14	1135						0.26
14	13	M15	01/21/24	AAA	20935514	41.64	1.25	0.83	1205	103	5.16	101	13	96	0.46
15	14	L72	06/08/23	AAA	20747870	39.11	1.54	0.8	872	92	3.78	107	11.9	104	0.22
16	15	L53	05/28/23	AAA	20747868	44.26	0.63	0.49	1280	109	3.57	101	12	95	0.39
17	16	L45	04/15/23	AAA	20832175	36.88	1.09	0.86	1010	100	2.73	100	10.7	100	0.14
18	17	L312	08/11/23	AAA	20931719		1.54	0.95	916	96	2.92	87	9.6	97	0.18
19	18	L313	08/11/23	AAA	20932955		1.35	0.96	776	80	3.67	110	7.8	79	0.17
20	19	L314	08/11/23	AAA	20932959		1.34	1.16	982	104	3.6	107	11	111	0.19
21	20	L318	08/11/23	AAA	20928628		1.22	1.23	970	103	2.78	83	11.3	114	0.22
22	21	M737	11/13/23	AAA	20827412		0.67	0.8	1000						0.26
23	22	M49	02/04/24	AAA	20935518	37.99	1.43	0.96	1110	94	5.18	102	11.5	86	0.3
24	23	M26	01/28/24	AAA	20935539	42.79	1.18	0.76	1035	96	4.33	85	14.6	108	0.36
25	24	M66	02/04/24	AAA	20935540	44.02	1.4	1.24	1135	103	5.47	107	14.2	107	0.32
26	25	L114	07/13/23	AAA	20802672	37.73	0.98	0.49	756	100	3.29	100	8.8	100	0.09
27	26	L122	08/22/23	AAA	20797806		1.08	0.94	1080	100	3.5	100	12.9	100	0.21
28	27	L61	06/02/23	AAA	20745885	39.58	0.93	0.91	1150	112	3.85	98	13.1	115	0.24
29	28	L92	06/08/23	AAA	20745879	38.58	1.1	0.91	1059	102	3.77	106	12.6	111	0.17
30	29	L85	05/30/23	AAA	20745875	37.3	0.7	0.95	1040	99	3.03	86	11.3	99	0.23
31	30	L93	06/08/23	AAA	20745880	40.08	0.54	0.91	928	90	3.87	109	10.2	89	0.22
32	31	L95	05/25/23	AAA	20745881	37.14	0.83	0.82	1025	96	3.8	107	11.6	102	0.25
33	Lot #	Anm Tag	Anm Birth Date	Assn	Reg No.	YR Adj SC	Marb EPD	RE EPD	USND Actual Scan Wt	USND Scan Wt Ratio	USND Adj PCT IMF	USND PCT IMF Ratio	USND Adj Ribeye	USND Ribeye Ratio	USND Rib Fat
34	32	L89	05/27/23	AAA	20745877	36.2	0.77	0.85	964	100	3.68	100	11.5	100	0.26
35	33	L102	06/22/23	AAA	20745868	41.03	1.12	0.84	1081	107	3.74	106	11.9	104	0.18
36	34	L98	06/23/23	AAA	20747148	39.59	1.05	0.87	872	95	3.94	101	10.5	92	0.14
37	35	L56	06/18/23	AAA	20747867	37.9	1.25	0.53	862	93	4.33	110	9.7	85	0.17
38	36	M10	01/16/24	AAA	20935520	41.57	1.09	1.14	1025	88	4.37	86	12.1	90	0.25
39	37	M42	02/07/24	AAA	20935533	39.11	1.2	1.17	1025	100	4.06	100	12.5	100	0.32
40	38	M13	01/13/24	AAA	20935523	42.81	1.05	0.59	1195	103	4.82	95	13.5	100	0.33
41	39	M18	01/16/24	AAA	20935519	42.57	1.28	0.88	1205	98	4.82	95	13	98	0.43
42	40	M48	02/10/24	AAA	20935536	39.21	0.99	0.84	1045	96	4.04	79	12.4	93	0.22
43	41	L303	08/11/23	AAA	20928619		0.65	0.83	830	88	2.77	83	9.2	93	0.11
44	42	L308	08/11/23	AAA	20928624		0.61	1.34	894	96	2.34	70	10.8	109	0.16
45	43	M38	02/07/24	AAA	20935543	40.11	0.97	1.39	1090	99	6.07	119	14.8	111	0.33
46	44	L106	06/22/23	AAA	20832179	39.22	1.29	0.35	944	96	3.78	96	11.2	98	0.24
47	45	L110	06/12/23	AAA	20745869	39.74	0.95	0.68	1005	100	3.77	106	10.6	93	0.15
48	46	L81	05/22/23	AAA	20834225	38.04	1.08	0.79	988	100	2.89	100	10.9	100	0.15
49	47	L82	05/25/23	AAA	20745872	39.14	1.09	0.6	1160	108	2.78	79	11.5	101	0.14
50	48	L104	06/22/23	AAA	20765880	37.03	0.79	0.68	960	96	3.09	79	11.5	101	0.14
51	49	L316	08/11/23	AAA	20928626		1.13	0.59	970	103	4.58	137	9.4	95	0.21
52	50	M29	1/17/2024	ASA	4336752	39.7	1.23	1.09	1256	100	7.55	100	16.21	100	0.3
53	51	M32	1/23/2024	ASA	4336725	42	0.62	0.88	1421	116	3.47	52	15.21	115	0.34
54	52	M39	2/10/2024	ASA	4336729	46	0.74	1.01	1090	100	4.83	119	13.6	103	0.27
55	53	M52	2/14/2024	ASA	4336732	39.2	0.72	0.46	984	94	3.64	89	11.26	85	0.21
56	54	M46	2/7/2024	ASA	4336738		1.04	0.95	1155	100	4.32	100	12.15	100	0.23
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