|
Any spreadsheet that calculates team rankings based on match scores?
Hi folks, are there any existing spreadsheets out there that can help us keep track of team ranking in qualifying rounds where we just have to enter scores after each match?
I suppose the easiest thing to do is have a pre-generated match list, and have cells that will automatically calculate rank points and qualifying points based on match scores, and more cells on the side the add these points up.
I don't suppose there is a way to sort in real time a list of teams based on their points without having to click sort everytime, right?
-Ken L
__________________
Hardware Test Engineer supporting RE<C, Google.
1999-2001: Team 192 Gunn Robotics Team
2001-2002: Team 100, 192, 258, 419
2002-2004: Western Region Robotics Forum, Score Keeper @ Sac, Az, SVR, SC, CE, IRI, CalGames
2003-2004, 2006-2007: California Robot Games Manager
2008: MC in training @ Sac, CalGames
2009: Master of Ceremony @ Sac, CalGames
2010: GA in training @ SVR, Sac.
2010-2011: Mechanical Mentor, Team 115 MVRT
|