| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How would I pick random team players using a 1 to 5 rating sys?
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: & |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How would I pick random team players using a 1 to 5 rating sys?
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: & 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How would I pick random team players using a 1 to 5 rating sys
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: & 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How would I pick random team players using a 1 to 5 rating sys?
Check E-mail. The spreadsheet has its limitations and may require a lot of modification to suit your applications. Hope it helps, good luck. -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=524592 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Random Team Generation | Excel Discussion (Misc queries) | |||
| Help with a Ladder | Excel Worksheet Functions | |||
| sort list of players by team from player list on separate sheet | Excel Worksheet Functions | |||
| Barb Reinhardt: HOW TO: Plot a Team Name .... | Charts and Charting in Excel | |||
Linear Mode
