Awards_YJM.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	ENTER: before competition						Weigh-in		Session				INSTRUCTIONS:
2	First Name	Last Name	Team	Session	Sex	Age	Bodywt	HP factor	Total	Adjusted Total	Place		Before the competition: Enter names, team, session, sex, ages
3	YOUTH												Weigh-in: Enter bodyweight
4	Female	EXAMPLE		1	F	14	30.6	2.955	10	29.54526807			Session: Enter total
5	Nea	Kerppola	LWL	1	F	6		#N/A		#N/A			Adjusted Total: Multiply the total with the HP factor
6	Evie	Seguin	LWL	1	F	7		#N/A		#N/A
7	Clara	Fonseca	LWL	1	F	11		#N/A		#N/A
8	Kiera	Woods	LWL	1	F	12		#N/A		#N/A
9	Claudia	Robichaud	Forged	2	F	14	57.2	1.762	77	135.6584773			Youth:
10	Finnigan	Woznicki	Forged	2	F	14	63.9	1.673	101	168.9533141			Award: Determine place based on adjusted totals
11	Katrusya	Karchenko	LWL		F	17	80.1	1.311	132	173.0648092			Weigh-in: HP is calculated automatically
12
13
14													Youth/Junior online calculator
15	Male	EXAMPLE		2	M	14	40.4	3.235	10	32.34908644			https://huebner.shinyapps.io/HPstandardization/
16	Anri	Haglund	Lily Weightlfiting	1	M	16	89	1.472	128	188.3952327		overallyouth
17	Vaughn	Haglund	Lily Weightlfiting	1	M	13	43.6	3.387	96	325.1584986			Weigh-in: HP is calculated automatically
18	Jack	Welsh	Forged		M	15	54.6	2.232	82	182.9844528
19	Lucien	Sammartino	Lily Weightlfiting	1	M	14	88.2	1.932	112	216.3807766			Junior:
20	Joseph	Powell	Optimus	1	M	15	80.7	1.665	118	196.5086233
21										0			Adjusted Total: Multiply the total with the HP factor
22
23										0
24
25										0			WORKSHEET CREATED BY M. HUEBNER
26										0
27
28	ENTER: before competition						Weigh-in		Session
29	First Name	Last Name	Team	Session	Sex	Age	Bodywt	HP factor	Total	Adjusted Total	Place
30	JUNIOR
31	Female	EXAMPLE		1	F	19	70.1	1.180	10	11.80025607
32	Sofie	Shaft	Optimus Barbell	6	F	19		#N/A		#N/A
33	Maggie	Brazier	STS Weightlifting	4	F	20	70.7	1.112	128	142.3238876
34	Lucia	Page Sander	LWL	2	F	18	72	1.235	139	171.7127897
35								#N/A		#N/A
36
37
38
39	Male	EXAMPLE		2	M	18	80.7	1.262	10	12.62481224
40	Dylan	Schafer	West Michigan Muscle	10	M	19	108.2	1.192	268	319.5512303	1	overall junior
41	Bryan	Emrich	Team Variant	8	M	18	77.4	1.299	243	315.5956444	2
42	Zachary	Kirsner	University of Michigan Weightlifting	3	M	20	87.3	1.153	212	244.4926635	3
43					M			#N/A		#N/A
44					M			#N/A		#N/A
45
46
47	ENTER: before competition						Weigh-in	Session
48	First Name	Last Name	Team	Session	Sex	Age	Bodywt	Total	Sinclair	SMF/SHMF	Place
49	MASTER												Master:
50	Female	EXAMPLE		1	F	35	70	100	124.4265813	133.3852952			Adjusted total= SMF/SHMF is calculated automatically
51	Katie	Page Sander	Lily Weightlifting	1	F	51	104.2	110	115.4121347	157.9992124			SMF for men; SHMF for women
52
53	Laura	Diller	Mid Mitten Barbell Club	1	F	37	111.1	81	83.64124524	91.75444603			SMF/SHMF online calculator:
54
55	Mary	Marco	Motor City Babebll Club	1	F	44	91.7	87	95.13200437	114.6340653			https://huebner.shinyapps.io/SHMF/
56
57	Corinna	Yerke	Forged Barbel	1	F	37			#NUM!	#NUM!
58	Laura	Wonch	Lily Weightlifting	1	F	43	57.1	98	139.5698417	165.6694021
59	Crystal	Wrubel	Optimus Barbell	4	F	40	61.4	153	206.890056	235.4408837
60
61	Amanda	Piecynzky	Optimus Barbll	4	F	37	69.5	169	211.1667861	231.6499643			Abbreviations:
62	Traci	Beaune	Optimus Barbell Club	4	F	39	65.7	181	234.0676291	263.0920152
80
81	Male	EXAMPLE		2	M	35	90	200	232.590085	249.3365712
82	Connor	Howell	Lily Weightlifting	2	M	36	79.8	123	151.8717993	164.4771587
83	Jason	Coleman	Lily Weightlifting	2	M	36	72.6	152	198.1102009	214.5533475
84	James	Downing	Lily Weightlifting		M	46	124.2	144	149.838379	182.5031456
85	Axel	Andre	Lily Weightlifting		M	48	78.3	148	184.6430842	230.434569
86	Justin	Tebedo	Motor City Barbell Club		M	36	86.6	232	274.7291708	297.5316919
87	Martin	Szeljack	Motor City Barbell Club		M	38	94.5	169	192.3682572	213.3363972
88	Jack	Mosher	Lily Weightlifting		M	56			#NUM!	#NUM!
94									#NUM!	#N/A	3
95									#NUM!	#N/A	4
96									#NUM!	#N/A
97									#NUM!	#N/A	1	overall master
98									#NUM!	#N/A	2
99									#NUM!	#N/A	3
100									#NUM!	#N/A	ineligable
101									#NUM!	#N/A
102									#NUM!	#N/A	1
103									#NUM!	#N/A	2
104									#NUM!	#N/A	3
105									#NUM!	#N/A	4
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122