If you are managing a basketball pool of NCAA brackets, or you know someone who is, please feel free to download the NCAA Basketball Pool Manager file. This is used in conjunction with the basketball bracket file to automatically tabulate results, highlight winners in brackets, and cross out losing games. It allows scenario generation and modifying of point totals for each round (since each person prefers his/her own point total weighting, it allows for some customization).
Please feel free to share these files, but I ask that you reference this site when you do so. Also, these files are intended for not-for-profit use.
March Madness Excel Bracket
Click here to download the basketball bracket. When prompted, choose to save this file to your computer (the desktop is fine). Microsoft Excel is needed in order to use this program. It works best when macros are enabled (see below for info on macros). If you cannot use macros (because of security settings or personal preference), you will not be able to one-click to advance teams, but the bracket is still very easy to complete. Many thanks to Tom Szarek for developing the macroless capabilities, and doing the majority of the work in building the new bracket for the 68-team field.
You will find instructions on the first tab for filling out the bracket (it just involves clicking). The basketball bracket is on the second tab. Once done, save the file and submit it to your pool manager.
Basketball Pool Manager File
This requires Microsoft Excel and macros must be enabled. See below for info on macros.
Click here to download the NCAA basketball bracket pool manager file. NOTE: this is missing some of the functionality from past year’s versions (download the version 7 pool manager file and bracket here with 2013 teams pre-populated). I redid a lot of it in order to make it flexible for counting the First Four games, if that’s something the pool manager wants. Unfortunately, the pool manager file will not have any custom scoring this year, but that feature will return in future years (along with other improvements).
This is free code. Please share with others, make your own improvements, or offer suggestions for future upgrades. Please let me know how the program has worked for you – I’d love to hear your stories.
Note: This has been extensively tested using Excel 2002 (part of MS Office XP) and Excel 2007-2010 on Windows XP, Vista, and 7 platforms. You may see errors if you use this file on a different Excel/Windows version or on a Macintosh computer, but these should not cause any damage to your computer. Please feel free to alert me about any bugs; if they’re easy to fix, I’ll make the changes and post a new version of the file. Someday I’ll get this to work well on a Mac, but it won’t be this year.
NCAA Women’s Basketball bracket
I hope that you enjoy watching the tournament and that these Excel basketball bracket files somehow contribute to your fun. ~B. David Tyler
While I understand that some people choose to gamble on the NCAA tournament results, the effort is not meant to either endorse or enable gambling. I share this as a way for you to brag to peers about your superior basketball clairvoyance. Please note that this is not supported by or in any way connected to the NCAA.
Starting in 2011, the NCAA bracket includes the “First Four” matchups to be played on the Tuesday and Wednesday of the first week of March Madness. The winners of those games advance to the round of 64. Pools that wish to use these games may do so, but it is not required. Regardless of whether these games count in a pool, a participant wishing to advance the winner of one of the First Four games to the round of 32 must advance the correct winner of the First Four game for points to be awarded in the round of 64. If the participant advances the loser of the First Four game, the participant will not be awarded any points even if upsets take place later in the bracket. As an example:
First Four Game: Team 12A vs. Team 12B
Second Round Game: Team 5 vs. Winner Team 12A/Team 12B
Jane predicts that Team 12A defeats Team 5 in the round of 64. Jane will be awarded points only if Team 12A defeats Team 12B and then Team 12A defeats Team 5.
Jane will not be awarded any points if Team 12B defeats Team 12A and then Team 12B defeats Team 5.
The results of the First Four games should be known before most bracket deadlines, so participants are encouraged to wait for the completion of those games before submitting their brackets. Pool Managers are encouraged to double-check for mistakes before importing and bracket into the Pool Manager file. That said, the decision is up to the pool manager, so be sure to check with your pool manager about the policy.
How to do I enable macros to use the Bracket file?
When opening the document, select ENABLE MACROS when prompted to do so. If you are not prompted, check your security settings under: Tools… Options… Security… Macro Security… [set your level to "Medium", then click OK twice]. Once this is done, close Excel completely and reopen the document.
After the document opens, click on the “Options…” box at the top of the screen. In the following window, click “Enable this content” and then “Ok”.
What is a macro?
When talking about Microsoft Office (Word, Excel, etc), a macro is a piece of hand-generated code that adds functionality to the software application; the code is written in the “Visual Basic for Applications” language and is part of the Excel file. In the case of the bracket, I wrote code to automatically advance teams through the bracket when you click on the team names; this is not something that Excel does normally, but through macros I could tell Excel exactly what I want to happen.
What is the exact macro code in the bracket file?
Good for you to ask. Open the Excel document and press Alt-F11. This will open up the Visual Basic editor, and by clicking on sheet and module names on the left side of the screen you will be able to view all code. You can do this before enabling macros, that way your computer isn’t at risk. Once you’re satisfied that this is no malicious code, you can close the file, reopen it, and enable macros. There is no malicious code in my files, but I won’t be offended if you’d rather check for yourself.