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 =
