Thread created automatically to discuss a document in CD-Media.
Database scoring (Excel) - Waterloo
Excel tournement scoring tool that sorts base upon QP and RP. Base upon existing Rack and Roll tool developed by Setsanto.
This is an update to the tool posted by setsanto. It builds from an exiting Rack and Roll match scoring tool (author unknown to me) and uses a VB macro to aggregate the match results by team. These results are combined into a simple QP/RP display based upon the 2007 tournement rules. Note that the individual match results are available on the Match Results sheet by clicking on the ‘+’ at the top of the sheet
Data validation was added into the team entry on the scoreboard sheet to improve input. Protection in the Scoreboard sheet prevented adding macro buttons there. Very little error handling has been included, so use at your own risk. Should be adequate for most users; knock yourselves out
Database_Scoring_(Waterloo)(1).xls (379 KB)
Database_Scoring_(Waterloo)(1).xls (382 KB)