Wednesday, March 27, 2013

Building NCAA Tournament Bracket Spreadsheets

Recently I wanted to do some analysis on the NCAA tournament brackets, but I couldn't find a simply source of data.  There are lots of .pdfs of previous year's brackets on the internet, but that doesn't convert to Excel very well.
So, let's do something about it.

I have a spreadsheet template built on one designed by the great folks at Vertex42.com that does a lot of the calculations.  We just have to input the first round's games and the scores for the following rounds.  I built spreadsheet brackets for 2000-2012.   I want to build brackets all the way back to 1985.  

When we do, we'll make them available for anyone to use.  There's great analytics here..we just need to get the data into a usable format.

So, download the .zip file.  Open the template file, input the first round games on the second tab, then flip back to the first tab and add score for the rest of the rounds.  The spreadsheet will populate the winners into the next round and add the info to the game summaries at the bottom.  Remember, make sure you get the seeds right...the box scores usually have the winner first.  We need to make sure the correct seed is first.


If you want to complete a year, please add a comment below about which year you're working on.  When you're done with a spreadsheet, email it to me at paul@huskermath.com and I'll add it to the .zip file.

I've been using the CBSSports site to fill in first round data.  

Thanks for the help!

Paul

2000-2012 - complete
1999
1998
1997
1996
1995
1994
1993
1992
1991
1990
1989
1988
1987
1986
- complete
1985- complete

No comments:

Post a Comment