Thread: Ranking
View Single Post
  #71   Spotlight this post!  
Unread 08-03-2010, 01:19
davidfv davidfv is offline
Registered User
FRC #0399 (Eagle Robotics)
Team Role: Tactician
 
Join Date: Jan 2006
Rookie Year: 2004
Location: Lancaster, CA
Posts: 133
davidfv has a brilliant futuredavidfv has a brilliant futuredavidfv has a brilliant futuredavidfv has a brilliant futuredavidfv has a brilliant futuredavidfv has a brilliant futuredavidfv has a brilliant futuredavidfv has a brilliant futuredavidfv has a brilliant futuredavidfv has a brilliant futuredavidfv has a brilliant future
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.
Attached Files
File Type: xls RankSim.xls (101.0 KB, 32 views)
__________________
Davidfv
Mentor/Drive Coach
Reply With Quote