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

I

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]
 
M

Morrigan

irish257 said:
I am a registrar for an over 40's soccer league. I have roughly 18
players
that are rated according to skill level...1 to 5, and postion. Ho
could I
have the program randomly choose the teams so they would come ou
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]
Click to expand...


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

Morrigan

Check E-mail.

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

bplumhoff

Hello,

I suggest to select 180 adjacent cells in your spreadsheet, then enter
=UniqRandInt(10,18)
as array-formula (enter with CTRL + SHIFT + ENTER).

Put my UDF UniqRandInt() from
http://www.sulprobil.com/html/uniqrandint.html into a macro module.

The function creates random integers between 1 and 10, each integer may
appear up to 18 times (since you create 180 numbers each one will
appear exactly 18 times).

HTH,
Bernd
 
Top