Docstoc

NCAA Bracket

Document Sample
NCAA Bracket Powered By Docstoc
					                                               NCAA Basketball Bracket


General Instructions

Macros (Excel 2007)
This document and the Bracket file contain macros (non-malicious). When opening the document,
please ENABLE MACROS by clicking on the "Options…" box at the top of the screen.
In the following window, click "Enable this content" and then "Ok".

Note: if you do not enable macros, you will still be able to use the program,
but some functionality will be lost.

Entering Data
For each game, enter the team you think will win on the "Bracket" tab.
This can be done in three ways:
  1. click on the team you think will win each game. That team will advance to the next round.
       Option 1 will only work if you have macros enabled.
  2. type the team name you think will win in the proper position in the next round.
       In most cases, the space will autocomplete for you as you type.
  3. click in the next round's cell and select the team name from the dropdown box.
       The dropdown box will appear once you click into the blank cell.

Error messages will appear if you skip a game or create an
invalid entry. Don't forget to put tiebreaker points in cell H43;
the tiebreaker will be who is closest to the actual total, regardless of whether or
not the guess is larger (i.e., we are not using 'Price is Right' theory).
When completed, there will be no red text Error messages in the middle of the sheet.

Please enter your name (Last, First) in cell H6 of the Bracket tab. Also please enter the
last 4 digits of your phone number in G9. This will be used (in combination with your name)
in case two people with the same name are involved in the same pool.


Questions?
If you have questions or comments about the bracket functionality, please email me or
post a comment at http://whenthewhistleblows.wordpress.com/2010/03/08/ncaa-basketball-march-madness-excel-brackets/
I'd love to hear how the bracket has been useful, or especially if you make any improvements.
       Midwest                                                                                                                                                                                                                                                                                            East
                                      Kansas                                                           The 2010 NCAA Men's Basketball Tournament                                                                                                          Kentucky




#1     Kansas                         Lehigh                                                                                                                                                                                                              E Tennessee State

                                                                                                                                                                                                                                                                                                       Kentucky #1
                        Kansas                                  Kansas                                                                                                                                                             Kentucky

                                                                                                                                                                                                                                                                                  Kentucky
#16 Lehigh                                                   Northern Iowa                                                                                                                                                          Texas

                                                                                                                                                                                                                                                                                              E Tennessee State #16
                                      UNLV

                                                    Kansas                                                                                                                                                                        Kentucky                Texas




#8     UNLV                        Northern Iowa                                                                                                                                                                                                          Wake Forest

                                                                                                                                                                                                                                                                                                          Texas #8
                        Northern Iowa                                                    Kansas                                                                                                          Kentucky

                                                                                                                                                                                                                                                                                     Texas
#9     Northern Iowa                                                                    Maryland                                                                                                        Wisconsin

                                                                                                                                                                                                                                                                                                   Wake Forest #9
                                  Michigan State

                                                                              Kansas                                                                                                                   Wisconsin                                          Temple




#5     Michigan State            New Mexico State                                                                                                                                                                                                         Cornell

                                                                                                                                                                                                                                                                                                        Temple #5
                        Michigan State                       Michigan State                                                                                                                                                         Temple

                                                                                                                                                                                                                                                                                   Temple
#12 New Mexico State                                           Maryland                                                                                                                                                           Wisconsin

                                                                                                                                                                                                                                                                                                         Cornell #12
                                     Maryland

                                                    Maryland                                                                                                                                                                    Wisconsin                 Wisconsin




#4     Maryland                      Houston                                                                                                                                                                                                              Wofford

                                                                                                                                                                                                                                                                                                      Wisconsin #4
                        Maryland                                                                                 Kansas                                                             Wisconsin

                                                                                                                                                                                                                                                                                Wisconsin
#13 Houston                                                                                                     Ohio State                                                          Marquette

                                                                                                                                                                                                                                                                                                        Wofford #13
                                    Tennessee

                                                                                                      Kansas                                                                       Wisconsin                                                              Marquette




#6     Tennessee                  San Diego State                                                                                                                                                                                                         Washington

                                                                                                                                                                                                                                                                                                      Marquette #6
                        Tennessee                             Tennessee                                                                                                                                                           Marquette

                                                                                                                                                                                                                                                                                 Marquette
#11 San Diego State                                           Georgetown                                                                                                                                                          New Mexico

                                                                                                                                                                                                                                                                                                    Washington #11
                                   Georgetown

                                                    Georgetown                                                                                                                                                                   Marquette                New Mexico




#3     Georgetown                      Ohio                                                                                                                                                                                                               Montana

                                                                                                                                                                                                                                                                                                    New Mexico #3
                        Georgetown                                                     Georgetown                                                                                                       Marquette

                                                                                                                                                                                                                                                                               New Mexico
#14 Ohio                                                                                Ohio State                                                                                                     West Virginia

                                                                                                                                                                                                                                                                                                       Montana #14
                                  Oklahoma State

                                                                              Ohio State                                                                                                               Marquette                                          Clemson




#7     Oklahoma State              Georgia Tech                                                                                                                                                                                                           Missouri

                                                                                                                                                                                                                                                                                                       Clemson #7
                        Georgia Tech                         Georgia Tech                                                                                                                                                          Missouri

                                                                                                                                                                                                                                                                                  Missouri
#10 Georgia Tech                                               Ohio State                                                                                                                                                        West Virginia

                                                                                                                                                                                                                                                                                                        Missouri #10
                                    Ohio State

                                                    Ohio State                                                                                                                                                                West Virginia               West Virginia




#2     Ohio State                UC Santa Barbara                                                                                                                                                                                                         Morgan State

                                                                                                                                                                                                                                                                                                   West Virginia #2
                        Ohio State                                                                                                      Kansas                Wisconsin

                                                                                                                                                                                                                                                                              West Virginia
#15 UC Santa Barbara                                                                                                                   Syracuse               Duke

                                                                                                                                                                                                                                                                                                   Morgan State #15
                                     Syracuse

                                                                                                      FINAL FOUR              Kansas                                      Duke   FINAL FOUR                                                               Duke




#1     Syracuse                      Vermont                                                                                                         Kansas                                                                                               AK-Pine Bluff

                                                                                                                                                                                                                                                                                                           Duke #1
                        Syracuse                               Syracuse                                                                              Duke                                                                            Duke

                                                                                                                                                                                                                                                                                     Duke
#16 Vermont                                                    Gonzaga                                                                                                                                                            California

                                                                                                                                                                                                                                                                                                   AK-Pine Bluff #16
                                     Gonzaga

                                                    Syracuse                                                                                        Duke                                                                                          Duke    California




#8     Gonzaga                     Florida State

                                                                                                                                                  CHAMPION                                                                                                Louisville

                                                                                                                                                                                                                                                                                                      California #8
                        Gonzaga                                                         Syracuse                                                                                                           Duke

                                                                                                                                                                                                                                                                                 California
#9     Florida State                                                                    Vanderbilt                                                                                                        Purdue

                                                                                                                                                                                                                                                                                                       Louisville #9
                                      Butler

                                                                              Syracuse                                                                                                                                 Duke                               Texas A&M




#5     Butler                         UTEP                                                                                                                                                                                                                Utah State

                                                                                                                                                                                                                                                                                                    Texas A&M #5
                        Butler                                   Butler                                                                                                                                                           Texas A&M

                                                                                                                                                                                                                                                                               Texas A&M
#12 UTEP                                                       Vanderbilt                                                                                                                                                           Purdue

                                                                                                                                                                                                                                                                                                     Utah State #12
                                    Vanderbilt

                                                    Vanderbilt                                                                                                                                                                                   Purdue   Purdue




#4     Vanderbilt                  Murray State                                                                                                                                                                                                           Siena

                                                                                                                                                                                                                                                                                                         Purdue #4
                        Vanderbilt                                                                              Syracuse                                                              Duke

                                                                                                                                                                                                                                                                                   Purdue
#13 Murray State                                                                                               Kansas State                                                         Villanova

                                                                                                                                                                                                                                                                                                          Siena #13
                                      Xavier

                                                                                                      Syracuse                                                                                  Duke                                                      Notre Dame




#6     Xavier                       Minnesota                                                                                                                                                                                                             Old Dominion

                                                                                                                                                                                                                                                                                                    Notre Dame #6
                        Minnesota                              Minnesota                                                                                                                                                          Notre Dame

                                                                                                                                                                                                                                                                               Notre Dame
#11 Minnesota                                                  Pittsburgh                                                                                                                                                           Baylor

                                                                                                                                                                                                                                                                                                  Old Dominion #11
                                    Pittsburgh

                                                    Minnesota                                                                                                                                                                                    Baylor   Baylor




#3     Pittsburgh                    Oakland                                                                                                                                                                                                              Sam Houston

                                                                                                                                                                                                                                                                                                          Baylor #3
                        Pittsburgh                                                      Minnesota                                                                                                         Baylor

                                                                                                                                                                                                                                                                                    Baylor
#14 Oakland                                                                            Kansas State                                                                                                      Villanova

                                                                                                                                                                                                                                                                                                  Sam Houston #14
                                       BYU

                                                                              Kansas State                                                                                                              Villanova                                         Richmond




#7     BYU                            Florida                                                                                                                                                                                                             St. Mary's (CA)

                                                                                                                                                                                                                                                                                                      Richmond #7
                        BYU                                      BYU                                                                                                                                                              Richmond

                                                                                                                                                                                                                                                                                 Richmond
#10 Florida                                                  Kansas State                                                                                                                                                          Villanova

                                                                                                                                                                                                                                                                                                 St. Mary's (CA) #10
                                   Kansas State

                                                    Kansas State                                                                                                                                                                  Villanova               Villanova




#2     Kansas State                North Texas                                                                                                                                                                                                            Robert Morris

                                                                                                                                                                                                                                                                                                       Villanova #2
                        Kansas State                                                                                                                                                                                                                                              Villanova
#15 North Texas                                                                                                                                                                                                                                                                                    Robert Morris #15
Seed




                                                                                                                                                                                                                                                                                                                  Seed
       West                                                                                                                                                                                                                                                                                             South
Region    Team              Conference RPI End RPI Strength of Schedule
South     Duke                    3            4            11
Midwest   Kansas                  1            1             6
Midwest   Ohio State              5           12            28
West      Syracuse                2            3             9
West      Kansas State            1            6             4
East      Wisconsin               5           19            21
South     Villanova               2            7             3
East      Marquette               2           23             7
West      BYU                     6           13            73
East      West Virginia           2            5             2
Midwest   Maryland                3           16            19
East      Missouri                1           31            32
South     Baylor                  1            9             8
Midwest   Georgetown              2           11             1
East      New Mexico              6           15            74
West      Minnesota               5           50            27
South     Purdue                  5           10            31
South     Richmond                7           30            58
South     Texas A&M               1           14             5
East      Kentucky                4            2            51
West      Vanderbilt              4           28            34
West      Xavier                  7           22            42
East      Temple                  7            8            55
East      Texas                   1           21            15
East      Clemson                 3           33            23
Midwest   Northern Iowa           9           26            98
South     California              8           36            43
West      Butler                 14           18            84
Midwest   Tennessee               4           20            30
South     Utah State             10           42           113
Midwest   Georgia Tech            3           41            16
South     Notre Dame              2           24            17
West      UTEP                   11           39            95
South     Louisville              2           38            12
Midwest   UNLV                    6           40            67
West      Pittsburgh              2           17            14
Midwest   Oklahoma State          1           32            24
West      Gonzaga                13           29            75
South     Old Dominion           12           48            87
East      Cornell                22           43           160
South     St. Mary's (CA)        13           25            96
West      Florida                 4           49            38
East      Washington              8           44            61
Midwest   Michigan State          5           27            33
Midwest   San Diego State         6           34            62
West      Florida State           3           35            29
South     Siena                  15           47           128
West      Murray State           20           59           224
East      Wofford                17           70           168
East      Wake Forest             3           45            26
Midwest   Houston                11          111           100
South     Sam Houston            26          106           211
Midwest   Ohio                   16          108           130
Midwest   New Mexico State    10    74    97
East      Montana             18   100   163
Midwest   UC Santa Barbara    19   112   169
West      Oakland             23    82   171
East      E Tennessee State   25   163   201
South     Robert Morris       29   181   267
East      Morgan State        30   147   261
West      North Texas         21   148   248
Midwest   Lehigh              28   206   303
West      Vermont             24   143   250
South     AK-Pine Bluff       31   213   254
Start Power Rankings End Power Rankings   Change in Power Rankings   Offensive Efficiency
         8                    4                       -4                       2
        11                    1                      -10                       1
        24                   11                      -13                       7
        13                    3                      -10                       9
        51                    6                      -45                      15
        32                   19                      -13                      14
         7                    8                        1                       8
        22                   23                        1                      23
        36                   14                      -22                      11
        19                    5                      -14                      12
        41                   15                      -26                       6
        10                   29                       19                      49
        37                    9                      -28                       4
        60                   12                      -48                      10
        70                   16                      -54                      22
        33                   49                       16                      24
        12                   10                       -2                      51
       109                   30                      -79                      67
        31                   13                      -18                      37
        69                    2                      -67                      18
        85                   24                      -61                      25
        25                   22                       -3                      16
        53                    7                      -46                      80
        26                   21                       -5                      26
        30                   33                        3                      47
        75                   28                      -47                      83
        34                   40                        6                       3
        38                   17                      -21                      54
        46                   20                      -26                     103
        45                   42                       -3                      13
       102                   38                      -64                      57
        47                   27                      -20                       5
        84                   37                      -47                      82
         5                   39                       34                      19
        72                   41                      -31                      60
         3                   18                       15                      42
        23                   32                        9                      34
        14                   31                       17                      46
        89                   46                      -43                      75
       138                   43                      -95                      28
        44                   26                      -18                      21
        54                   47                       -7                      35
        15                   48                       33                      36
         4                   25                       21                      38
        48                   35                      -13                      43
        21                   34                       13                     117
        42                   45                        3                      68
       165                   58                     -107                      69
       193                   69                     -124                     149
        17                   44                       27                      94
        87                  112                       25                      39
       152                  104                      -48                      52
       191                  107                      -84                     106
123    73   -50    44
179   100   -79   110
170   114   -56   209
107    78   -29    96
134   158    24   195
147   181    34   198
140   145     5   136
136   148    12   159
266   207   -59   134
 96   138    42   141
318   231   -87   295
Defensive Efficency   Turnover Rate   3-Pt %   Weighted Points
        4                  16           28          -1.05
        5                 108            5           3.65
       23                  32           22           9.11
       20                 106           25          15.05
       19                  40          100          18.70
        7                  24           85          21.85
       62                  93           40          25.55
       48                   7            6          26.50
       21                  11            3          28.62
       25                  63          184          35.75
       38                  21          261          35.95
       11                   2           55          38.41
       47                 272           20          38.80
       33                 221           23          39.95
       88                  35           41          40.41
       41                  71            7          41.70
        6                   4          237          43.11
       35                  15          119          45.51
       22                  60          196          46.50
       12                 206          164          47.86
       63                 186           62          48.15
       51                 183           53          48.66
        3                 138          175          49.11
       24                 113          150          50.20
       10                  36          183          50.95
       13                  69          112          52.62
       85                 128           46          52.81
       16                  99          162          53.27
        8                  19          249          53.35
       55                 127            2          56.58
       18                 244           54          56.90
       139                176           16          57.39
       15                  33          145          57.97
       75                  74          174          58.10
       31                  12          210          58.71
       32                 269          151          59.85
       61                 146          117          61.45
       65                 175           80          64.06
       17                  80          284          69.57
       134                 77            1          70.79
       82                 207            4          72.62
       67                  78          250          74.25
       37                  23          224          75.41
       29                 240          284          76.35
       42                 177          230          80.11
        1                 223          187          81.70
       58                  30          283          84.23
       44                  37           63          85.76
       53                  42          133          89.89
       26                 239          283          94.00
       168                  1           98          98.86
       177                 52           38         106.20
       108                 41           89         106.52
224   157    56   111.01
115   144     8   119.83
94    181    35   127.13
210   220   219   139.03
87     62   259   168.49
153   122    73   173.55
189   132   179   174.65
180   276   186   177.95
243   143    10   181.86
127   209   283   197.05
98    312   283   228.20
Reg. Season Conf. Champs   Post Season Conf. Champs   Won Both?
           -5                         5                  -10
           -5                         5                  -10
           -5                         5                  -10
           -5                         0                    0
            0                         0                    0
            0                         0                    0
            0                         0                    0
            0                         0                    0
            0                         0                    0
            0                         5                    0
           -5                         0                    0
            0                         0                    0
            0                         0                    0
            0                         0                    0
           -5                         0                    0
            0                         0                    0
            0                         0                    0
            0                         0                    0
            0                         0                    0
           -5                         5                   -6
            0                         0                    0
            0                         0                    0
           -5                         5                  -10
            0                         0                    0
            0                         0                    0
           -5                         5                  -10
           -5                         0                    0
           -5                         5                  -10
            0                         0                    0
           -5                         0                    0
            0                         0                    0
            0                         0                    0
           -5                         0                    0
            0                         0                    0
            0                         0                    0
            0                         0                    0
            0                         0                    0
           -5                         0                    0
           -5                         5                  -10
           -5                         5                  -10
            0                         5                    0
            0                         0                    0
            0                         5                    0
            0                         0                    0
            0                         5                    0
            0                         0                    0
           -5                         5                  -10
           -5                         5                  -10
           -5                         5                  -10
            0                         0                    0
            0                         5                    0
           -5                         5                  -10
            0                         5                    0
 0   5    0
 0   5    0
-5   5   -10
-5   5   -10
 0   5    0
-5   5   -10
-5   5   -10
-5   5   -10
-5   5   -10
 0   5    0
 0   5    0
# of Losses <9
      0
      0
      0
      0
      0
      0
      0
     10
      0
      0
      0
     10
      0
     10
      0
     10
      0
      0
     10
      0
      0
      0
      0
     10
     10
      0
     10
      0
      0
      0
     10
     10
      0
     10
      0
      0
     10
      0
      0
      0
      0
     10
     10
      0
      0
     10
      0
      0
      0
     10
     10
      0
     10
10
10
10
 0
10
10
10
 0
10
10
10
Region            (Multiple Items)
Conference Champs (All)

                    Data
Team                Sum of Tounament Seed Sum of End of Season Ranking Sum of Strength of Schedule
Kansas                                   1                             1                           6
Kentucky                                 1                             2                         51
Duke                                     1                             4                         11
Ohio St.                                 2                            12                         28
West Virginia                            2                             5                           2
Villanova                                2                             7                           3
Baylor                                   3                             9                           8
New Mexico                               3                            15                         74
Georgetown                               3                            11                           1
Maryland                                 4                            16                         19
Wisconsin                                4                            19                         21
Purdue                                   4                            10                         31
Texas A&M                                5                            14                           5
Michigan State                           5                            27                         33
Temple                                   5                             8                         55
Notre Dame                               6                            24                         17
Tennessee                                6                            20                         30
Marquette                                6                            23                           7
Oklahoma State                           7                            32                         24
Clemson                                  7                            33                         23
Richmond                                 7                            30                         58
Texas                                    8                            21                         15
California                               8                            36                         43
UNLV                                     8                            40                         67
Northern Iowa                            9                            26                         98
Wake Forest                              9                            45                         26
Louisville                               9                            38                         12
Saint Mary's                            10                            25                         96
Missouri                                10                            31                         32
Georgia Tech                            10                            41                         16
Old Dominion                            11                            48                         87
Washington                              11                            44                         61
San Diego St.                           11                            34                         62
Utah St.                                12                            42                        113
New Mexico St.                          12                            74                         97
Cornell                                 12                            43                        160
Siena                                   13                            47                        128
Wofford                                 13                            70                        168
Houston                                 13                           111                        100
Ohio                                    14                           108                        130
Montana                                 14                           100                        163
Sam Houston St.                         14                           106                        211
Robert Morris                           15                           181                        267
Morgan State                            15                           147                        261
UC Santa Barbara                        15                           112                        169
East Tenn. St.                          16                           163                        201
Lehigh                                  16                           206                        303
Winthrop                                16                           213                        254

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:14
posted:12/14/2011
language:English
pages:13