WMA-AgeGradedCalculator-2022.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1	Instructions
2	A		Type age as number
3	D		Select sex from pulldown (click in cell to see and use pulldown)
4	E		01:54.8
5	F		Type performance: - Time, height or distance as number - Time in minutes and seconds (mm:ss.xx). Example: 5 minutes and 25.37 seconds as 5:25.37 - Time in hours must be typed using one of the above. Example: 2 hours, 35 minutes and 25 seconds as 155:25 or 9325
6	Age	First	Last	Sex	Event	Performance	One-Year Age Grade	Five-Year Age Grade	Numeric Performance	One-Year Age Graded Performance	Five-Year Age Graded Performance	Combined Event Score

7	35			Female	Sprint Hurdles	18.35	66.94%	66.94%	18.35	18.23	18.23	465
8	46			Female	High Jump	1.48	80.20%	79.44%	1.48	1.68	1.66	806
9	35			Female	Shot Put	9.01	18.63%	44.05%	9.01	9.36	9.36	487
10	65			Female	400m	70.23	90.59%	90.59%	70.23	53.14	53.14	997
11	35			Female	Long Jump	4.78	67.00%	67.00%	4.78	4.97	4.97	551
12	35			Female	Javelin	29.06	41.32%	41.32%	29.06	29.86	29.86	474
13	35			Female	800m	2:34.63	74.48%	74.48%	154.63	153.08	153.08	655
14	80			Male	100m	19.4	67.48%	67.48%	19.40	14.20	14.20	284
15	40			Female	Javelin	26.22	40.99%	40.99%	26.22	29.63	29.63	470
16	35			Female	Steeplechase	7:07	125.89%	125.89%	427.00	416.50	416.50	0
17	35			Female	200m	28.23	76.62%	76.62%	28.23	28.23	28.23	613
18	85			Male	Discus	15.08	35.33%	35.33%	15.08	25.39	25.39	375
19	95			Female	Mile	13:41.36	77.48%	77.48%	821.36	325.67	325.67	0
20	31			Male	Marathon	127:31	95.40%	95.40%	7651.00	7651.00	7651.00	0
21	60			Male	Weight	21.18	82.28%	82.28%	21.18	21.28	21.28	1098
22	50			Female	800m	179.2	71.78%	71.78%	179.20	158.82	158.82	586
23	80			Female	Hammer	21.74	51.77%	51.77%	21.74	42.96	42.96	606
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
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