|
|
|
![]() |
|
|||||||
|
||||||||
|
|
Thread Tools | Rate Thread | Display Modes |
|
#1
|
||||
|
||||
|
National Rankings
I have been gathering all of the Standings data in a database over the last few weeks of regionals and I would like to build a National Standings page, just like the regional standings page, but aggregating all the standings data together.
Some of the fields to include are pretty obvious, but I am having trouble figuring out how best to present some of the fields when teams play at more than one regional and I am hoping the statistics genius out there might lend a hand... Rank -- Just like the regional, sort by QS, RS, then MP Team -- Another no brainer, one entry per team Wins -- Sum all wins Losses -- Sum of all losses Ties -- Sum of all ties Played -- Sum of all matches played Now here is where I get a bit lost... QS -- Can't just do a sum because the more regionals, the higher this value would be. Maybe a weighted average? How best to calculate this? RS -- Same thoughts as QS, maybe a weighted average? MP -- I think this is easy, MAX(MP) from all regionals the team played I would also add a new column... Regionals -- Number of regionals where the team competed. Any other data I should include? Thanks in advance = ![]() |
| Thread Tools | |
| Display Modes | Rate This Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| National Championship or National Chairman's | Eric Bareiss | General Forum | 95 | 20-06-2005 22:07 |
| National Rankings during the Season | Andrew | Scouting | 13 | 12-02-2004 15:17 |
| Rankings | archiver | 2001 | 3 | 24-06-2002 03:25 |
| NATIONAL RANKINGS! | archiver | 2001 | 1 | 24-06-2002 03:18 |
| NATIONAL RANKINGS... | archiver | 2001 | 0 | 24-06-2002 03:17 |