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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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: (e-mail address removed) & (e-mail address removed)
 
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: (e-mail address removed) &
(e-mail address removed)
Click to expand...


How many teams (11 players each) are you trying to form from the 18
players available
 
Check E-mail.

The spreadsheet has its limitations and may require a lot o
modification to suit your applications. Hope it helps, good luck
 
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
 
Back
Top