How would I pick random team players using a 1 to 5 rating sys?

irish257 · 03-20-2006, 06:25 PM

I am a registrar for an over 40's soccer league. I have roughly 180 players
that are rated according to skill level...1 to 5, and postion. How could I
have the program randomly choose the teams so they would come out fairly even
each season?

From there I could tweek the teams if one is or more are "loaded".

Thanks,

Doug Maume
SCSC Registrar

alternative e-mail addresses: [email protected] & [email protected]

**Morrigan** · 03-21-2006, 01:45 PM

Originally Posted by irish257

I am a registrar for an over 40's soccer league. I have roughly 180 players
that are rated according to skill level...1 to 5, and postion. How could I
have the program randomly choose the teams so they would come out fairly even
each season?

From there I could tweek the teams if one is or more are "loaded".

Thanks,

Doug Maume
SCSC Registrar

alternative e-mail addresses: [email protected] & [email protected]

How many teams (11 players each) are you trying to form from the 180 players available?

irish257 · 03-21-2006, 03:10 PM

10 teams, 18 players on each team

thanks!

"Morrigan" wrote:

>
> irish257 Wrote:
> > I am a registrar for an over 40's soccer league. I have roughly 180
> > players
> > that are rated according to skill level...1 to 5, and postion. How
> > could I
> > have the program randomly choose the teams so they would come out
> > fairly even
> > each season?
> >
> > From there I could tweek the teams if one is or more are "loaded".
> >
> > Thanks,
> >
> > Doug Maume
> > SCSC Registrar
> >
> > alternative e-mail addresses: [email protected] &
> > [email protected]
>
>
> How many teams (11 players each) are you trying to form from the 180
> players available?
>
>
> --
> Morrigan
> ------------------------------------------------------------------------
> Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
> View this thread: http://www.excelforum.com/showthread...hreadid=524592
>
>

**Morrigan** · 03-22-2006, 05:44 PM

Check E-mail.

The spreadsheet has its limitations and may require a lot of modification to suit your applications. Hope it helps, good luck.

**hyperlite1215** · 08-30-2010, 05:48 PM

Looking for something like this as well. Can you send anything to build on?
Thanks!

**shg** · 08-30-2010, 06:12 PM

Welcome to the forum.

I doubt these guys are stopping back four years later. Please take a few minutes to read the forum rules, and then start your own thread.

Thanks.