Team generator based on avgs.

[rcarbo]

Hey all, I've been looking through the threads here, and found answers close to what I'm looking for, but not exact. It's relatively simple in theory, but I have a dart league consisting of 30 players. I'm trying to divide them up into 6 teams of 5 players each based on player averages to keep the teams all evenly matched, and if possible a way to track the rankings of the teams throughout the season.
If anymore info is needed, I'll gladly provide it if I can.
Thanks in advance for any suggestions

[Bernie Deitrick]

I would sort the players by average from best to worst, then match the top twelve with the bottom twelve (in reverse order- kind of 'fold' the players #1 with #30, 2 with 29, etc.) to make pairs whose averages should be closer together. Then sort those twelve teams by total or average (again, best to worst), and match the top six with the bottom (again, in reverse order) - and then randomly assign the middle six (who were left out of the first step) to complete the teams. Do you want to mix up the players on the teams every week?

[rcarbo]

Thanks for the suggestion. That could work, too. The teams will stay the same throughout the season once they are setup

[shg]

I'd do it like this (which may be the same as Bernie's suggestion):

Player	Avg	Team		Team	Avg
	117.2	1		1	99.4	F2: =AVERAGEIF($C$2:$C$31, E2, $B$2:$B$31)
	115.0	2		2	100.7
	111.0	3		3	100.5
	107.5	4		4	100.2
	106.9	5		5	99.6
	105.3	5
	104.3	4
	103.9	3
	102.8	2
	102.0	1
	101.8	1
	100.9	2
	100.9	3
	100.8	4
	99.7	5
	99.4	5
	99.1	4
	98.7	3
	98.4	2
	97.9	1
	97.9	1
	97.8	2
	97.7	3
	97.5	4
	94.6	5
	91.8	5
	91.8	4
	91.0	3
	89.0	2
	79.4	1

[Bernie Deitrick]

Ignore this bad post.... I got confused after I saw shg's post where he created 5 teams.. You did want 6 teams....

[rcarbo]

I'd do it like this (which may be the same as Bernie's suggestion):

Player	Avg	Team		Team	Avg
	117.2	1		1	99.4	F2: =AVERAGEIF($C$2:$C$31, E2, $B$2:$B$31)
	115.0	2		2	100.7
	111.0	3		3	100.5
	107.5	4		4	100.2
	106.9	5		5	99.6
	105.3	5
	104.3	4
	103.9	3
	102.8	2
	102.0	1
	101.8	1
	100.9	2
	100.9	3
	100.8	4
	99.7	5
	99.4	5
	99.1	4
	98.7	3
	98.4	2
	97.9	1
	97.9	1
	97.8	2
	97.7	3
	97.5	4
	94.6	5
	91.8	5
	91.8	4
	91.0	3
	89.0	2
	79.4	1

Thanks! I'll try that when I get home

[rcarbo]

I appreciate it

[shg]

I got confused after I saw shg's post where he created 5 teams.. You did want 6 teams....

My bad:

	A	B	C	D	E	F	G
1	Player	Avg	Team		Team	Avg
2		117.2	1		1	102.22	F2: =AVERAGEIF($C$2:$C$31, E2, $B$2:$B$31)
3		115.0	2		2	101.42
4		111.0	3		3	100.46
5		107.5	4		4	99.72
6		106.9	5		5	99.36
7		105.3	6		6	97.22
8		104.3	6
9		103.9	5
10		102.8	4
11		102.0	3
12		101.8	2
13		100.9	1
14		100.9	1
15		100.8	2
16		99.7	3
17		99.4	4
18		99.1	5
19		98.7	6
20		98.4	6
21		97.9	5
22		97.9	4
23		97.8	3
24		97.7	2
25		97.5	1
26		94.6	1
27		91.8	2
28		91.8	3
29		91.0	4
30		89.0	5
31		79.4	6

[rcarbo]

Thanks for the input shg. It worked out great. I had to do some tweaking because someone threw an average way over the others, but in the end all the teams evened out. Thanks again for all the help!

[shg]

You're welcome.