Jr. High Track, Team Division Calculation										Created w/ MS Excel, Office 2000, for PC.
	Fill in the blanks below and press Enter.							Report
			Season start date (m/d/y):	3/19/2007					Value	Exponent		Division
			Gender (M or F):					Age
			Date of birth:					Height
			Height (inches):					Weight
			Weight (pounds):
	If you would like a copy of this worksheet, send e-mail to the address below, and I'll get you a copy.
	Dan Nechodom, Dayton School District					DanN@dayton.wednet.edu
	Doing the Calculation by Hand
	1.  Find the number (exponent) corresponding to the athlete's age, height and weight from the following tables and add the three together.
	Decimal Age (years plus months/12)				Height (inches)				Weight (pounds)
	From	To	Exponent		From	To	Exponent		From	To	Exponent
	9.9	10.2	20		0	47	22		53	59	9
	10.3	10.8	21		47.5	49	23		60	65	10
	10.9	11.2	22		49.5	51.5	24		66	71	11
	11.3	11.8	23		52	53.5	25		72	79	12
	11.9	12.2	24		54	55.5	26		79	84	13
	12.3	12.8	25		56	57.5	27		85	90	14
	12.9	13.2	26		58	59.5	28		91	96	15
	13.3	13.8	27		60	62	29		97	103	16
	13.9	14.2	28		62.5	64	30		104	109	17
	14.3	14.8	29		64.5	66	31		110	115	18
	14.9	15.2	30		66.5	68	32		116	121	19
	15.3	15.8	31		68.5	70	33		122	128	20
	15.9	16.2	32		70.5	72.5	34		129	134	21
	16.3	16.8	33		73	74.5	35		135	140	22
	16.9	17	34		75	up	36		141	146	23
									147	153	24
									154	159	25
									160	165	26
									166	171	27
	2.  Determine which division the athlete falls into according to the following table.								172	178	28
									179	184	29
									185	190	30
									191	up	31
					Girls				Boys
					Sum of the exponents is:				Sum of the exponents is:
					From	To	Division		From	To	Division
					0	71	C		0	71	C
					72	75	B		72	78	B
					76	up	A		79	up	A