paper: 2013 Qual Schedule Analysis

CD-Media: Papers
1

Thread created automatically to discuss a document in CD-Media.

2013 Qual Schedule Analysis
by: Ether

162 spreadsheets summarize the scheduling of the Qual Matches at each of the 81 events in the 2013 season.

All 81 Qual Schedules for 2013 (Weeks 1 thru 7 Regionals & Districts, plus MAR, MSC, Archimedes, Curie, Galileo, & Newton) are summarized in 162 individual CSV files (which can be opened directly in Excel if file association is set).

For each event, a matrix shows which teams each team played With and Against.

FWIW, this shows anomalies in the scheduling algorithm where oftentimes a team will play with or against another team more than once, while not playing with or against dozens of other teams in the event.

QualScheduleAnalysis.zip (169 KB)
QualScheduleAnalysisSummary.xls (23 KB)

2

Is it just a straight 1 or 0 whether you played with/against or not (1 being true, 0 being false)? Because if this is the case I can already see an error or two in just the schedules we’re in

3

No, the numbers in the cells are counts. Please let me know where you think the errors are so I can check them out.

Thanks.

PS - Please use this thread to discuss the paper:

http://www.chiefdelphi.com/forums/showthread.php?t=116505

… because for some reason the “Thread created automatically to discuss a document in CD-Media” always disallows attachments, which I find very inconvenient.

4

I just hand-checked every team 3310 played with and against at the Hub City event, and I can find no errors in the spreadsheets for that event.

Please tell me where you think the errors are.

5