|
Re: Ranking
Just to let people see how a regional could work with the seeding points, we put this ranking simulation together in the beginning of the year. We are pretty sure it is correct. If you find it in error, let me know. It is a good training to help with understanding the seeding system.
The workbook contains two sheets, matches and Rankings:
Matches
Initial Matches were set up with a 57 team regional and 8 matches
Penalties
Random Number between 0 to 5
Score
Random Number between 0 to 10
To Run Simulation is a two step process
Matches Worksheet:
To obtain a random penalty and Score press control+= on the Matches Worksheet
Rankings Worksheet:
To obtain the rankings, prese (ctrl+shft+z) on the Rankings Worksheet to run the macro.
This macro will tally the wins, losses and ties
Will calculate seeding points and coopertition bonus
Add the qualification seeding and sort based on the total qualification points
Match played:
On the ranking sheet, it shows each match the team played to review the scores
The visual basic Macro simply searches through the scores and tally's wins/losses, and calculates seeding points and coopertition (TM) bonus. Hope it helps.
__________________
Davidfv
Mentor/Drive Coach
|