Spreadsheet: 524809d1498336112-formula-to-transfer-data-from-one-range-of-cells-to-another-based-on-conditions-example
Sheet: #1 vs #16

GAME SCORE HISTORY |  |  |  |  |  |  |  |  |  |  |  | #16 SEED UPSET #1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | STATISTICS |  |  |  |  |  |  | CHARTS & GRAPHS
GAMES |  | TEAMS |  |  |  |  | SCORES |  |  |  |  | TOTALS |  |  | MATCH-UP 1 |  |  |  | MATCH-UP 2 |  |  |  | MATCH-UP 3 |  |  |  | MATCH-UP 4 |  |  |  | BASIC
Game # | Year | 1st Seed | Conference 1 | Vs. | 16th Seed | Conference 16 | Seed 1 Score | Seed 16 Score | OT | Margin of Victory |  | Year | Upset |  | 16th Seed | 1st Seed | Score |  | 16th Seed | 1st Seed | Score |  | 16th Seed | 1st Seed | Score |  | 16th Seed | 1st Seed | Score |  | Total Tourneys
1 | 1985 | St. John's |  | Vs. | Southern |  | 83 | 85 |  |  |  | 1985 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Games/Yr | 4
2 | 1985 | Georgetown |  | Vs. | Lehigh |  | 68 | 70 |  |  |  | 1986
3 | 1985 | Oklahoma |  | Vs. | North Carolina A&T |  | 96 | 100 |  |  |  | 1987
4 | 1985 | Michigan |  | Vs. | [NAME] |  | 59 | 65 |  |  |  | 1988 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GENERAL UPSET INFORMATION
5 | 1986 | Kentucky |  | Vs. | [NAME] |  | 75 | 55 |  |  |  | 1989 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total % of Upsets | Total % of non Upsets | Total % of Years w/Upsets
6 | 1986 | St. John's |  | Vs. | Montana State |  | 83 | 74 |  |  |  | 1990
7 | 1986 | Duke |  | Vs. | Mississippi Valley State |  | 85 | 78 |  |  |  | 1991 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Upsets
8 | 1986 | Kansas |  | Vs. | North Carolina A&T |  | 71 | 46 |  |  |  | 1992 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Yrs w/Upsets
9 | 1987 | UNLV |  | Vs. | Idaho State |  | 95 | 70 |  |  |  | 1993 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Most Upsets/Yr
10 | 1987 | Indiana |  | Vs. | Fairfield |  | 92 | 58 |  |  |  | 1994 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
11 | 1987 | Georgetown |  | Vs. | Bucknell |  | 75 | 53 |  |  |  | 1995
12 | 1987 | North Carolina |  | Vs. | Pennsylvania |  | 113 | 82 |  |  |  | 1996
13 | 1988 | Purdue |  | Vs. | [NAME] |  | 94 | 79 |  |  |  | 1997 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UPSET TYPE INFORMATION
14 | 1988 | Temple |  | Vs. | Lehigh |  | 87 | 73 |  |  |  | 1998 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % of Total Games | % of Total Tourney Years
15 | 1988 | Arizona |  | Vs. | Cornell |  | 90 | 50 |  |  |  | 1999
16 | 1988 | Oklahoma |  | Vs. | Chattanooga |  | 94 | 66 |  |  |  | 2000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Single Game Upsets
17 | 1989 | Illinois |  | Vs. | McNeese State |  | 77 | 71 |  |  |  | 2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Double Game Upsets
18 | 1989 | Oklahoma |  | Vs. | East Tennessee State |  | 72 | 71 |  |  |  | 2002 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Triple Game Upsets
19 | 1989 | Georgetown |  | Vs. | Princeton |  | 50 | 49 |  |  |  | 2003 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Quadruple Game Upsets
20 | 1989 | Arizona |  | Vs. | [NAME] |  | 94 | 60 |  |  |  | 2004 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Upset
21 | 1990 | Michigan State |  | Vs. | [NAME] |  | 75 | 71 | Y |  |  | 2005
22 | 1990 | UNLV |  | Vs. | Arkansas-Little Rock |  | 102 | 72 |  |  |  | 2006
23 | 1990 | Uconn |  | Vs. | Boston University |  | 76 | 52 |  |  |  | 2007 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PROBABILITIES |  |  | TIME BETWEEN UPSETS
24 | 1990 | Oklahoma |  | Vs. | Towson |  | 77 | 68 |  |  |  | 2008 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mean |  |  | Start | End | Entry
25 | 1991 | UNLV |  | Vs. | Montana |  | 99 | 65 |  |  |  | 2009 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Standard Deviation |  |  | 1985 |  | 1
26 | 1991 | Ohio State |  | Vs. | Towson |  | 97 | 86 |  |  |  | 2010 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X Value | -1
27 | 1991 | North Carolina |  | Vs. | Northeastern |  | 101 | 66 |  |  |  | 2011 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Upset Probability |  |  | Avg. Yrs Between Upsets
28 | 1991 | Arkansas |  | Vs. | Georgia State |  | 117 | 76 |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Upset Probability %
29 | 1992 | Kansas |  | Vs. | [NAME] |  | 100 | 67 |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Projected Upsets
30 | 1992 | Ohio State |  | Vs. | Mississippi Valley State |  | 83 | 56 |  |  |  | 2014 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual Upsets |  |  | Avg. [NAME]
31 | 1992 | Duke |  | Vs. | Campbell |  | 82 | 56 |  |  |  | 2015 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Difference
32 | 1992 | UCLA |  | Vs. | [NAME] |  | 73 | 53 |  |  |  | 2016 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Single Upset
33 | 1993 | Kentucky |  | Vs. | Rider |  | 96 | 52 |  |  |  | 2017 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chance of Upset (1 out of _ Games) |  |  |  | Double Upset
34 | 1993 | Michigan |  | Vs. | Coastal Carolina |  | 84 | 53 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Triple Upset
35 | 1993 | North Carolina |  | Vs. | East Carolina |  | 85 | 65 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Quadruple Upset
36 | 1993 | Indiana |  | Vs. | [NAME] |  | 97 | 54
37 | 1994 | Missouri |  | Vs. | Navy |  | 76 | 53
38 | 1994 | Arkansas |  | Vs. | North Carolina A&T |  | 94 | 79
39 | 1994 | North Carolina |  | Vs. | Liberty |  | 71 | 51
40 | 1994 | Purdue |  | Vs. | UCF |  | 98 | 67
41 | 1995 | Kansas |  | Vs. | Colgate |  | 82 | 68
42 | 1995 | Kentucky |  | Vs. | Mount St. Mary's |  | 113 | 67
43 | 1995 | Wake Forest |  | Vs. | North Carolina A&T |  | 79 | 47
44 | 1995 | UCLA |  | Vs. | FIU |  | 92 | 56
45 | 1996 | UMASS |  | Vs. | UCF |  | 92 | 70
46 | 1996 | Uconn |  | Vs. | Colgate |  | 68 | 59
47 | 1996 | Kentucky |  | Vs. | San Jose State |  | 110 | 72
48 | 1996 | Purdue |  | Vs. | Western Carolina |  | 73 | 71
49 | 1997 | North Carolina |  | Vs. | Fairfield |  | 82 | 74
50 | 1997 | Kansas |  | Vs. | Jackson State |  | 78 | 64
51 | 1997 | Minnesota |  | Vs. | Texas State |  | 78 | 46
52 | 1997 | Kentucky |  | Vs. | Montana |  | 92 | 54
53 | 1998 | North Carolina |  | Vs. | Navy |  | 88 | 52
54 | 1998 | Arizona |  | Vs. | Nicholls State |  | 99 | 60
55 | 1998 | Kansas |  | Vs. | Prairie View A&M |  | 110 | 52
56 | 1998 | Duke |  | Vs. | Radford |  | 99 | 63
57 | 1999 | Auburn |  | Vs. | Winthrop |  | 80 | 41
58 | 1999 | Uconn |  | Vs. | UTSA |  | 91 | 66
59 | 1999 | Michigan State |  | Vs. | Mount St. Mary's |  | 76 | 53
60 | 1999 | Duke |  | Vs. | Florida A&M |  | 99 | 58
61 | 2000 | Stanford |  | Vs. | NC State |  | 84 | 65
62 | 2000 | Duke |  | Vs. | Lamar |  | 82 | 55
63 | 2000 | Arizona |  | Vs. | Jackson State |  | 71 | 47
64 | 2000 | Michigan State |  | Vs. | Valparaiso |  | 65 | 38
65 | 2001 | Duke |  | Vs. | Monmouth |  | 95 | 52
66 | 2001 | Stanford |  | Vs. | UNC-Greensboro |  | 89 | 60
67 | 2001 | Michigan State |  | Vs. | Alabama State |  | 69 | 35
68 | 2001 | Illinois |  | Vs. | Northwestern State |  | 96 | 54
69 | 2002 | Duke |  | Vs. | Winthrop |  | 84 | 37
70 | 2002 | Cincinatti |  | Vs. | Boston University |  | 90 | 52
71 | 2002 | Maryland |  | Vs. | Siena |  | 85 | 70
72 | 2002 | Kansas |  | Vs. | Holy Cross |  | 70 | 59
73 | 2003 | Kentucky |  | Vs. | IUPUI |  | 95 | 64
74 | 2003 | Arizona |  | Vs. | Vermont |  | 80 | 51
75 | 2003 | Texas |  | Vs. | UNC-Asheville |  | 82 | 61
76 | 2003 | Oklahoma |  | Vs. | South Carolina |  | 71 | 54
77 | 2004 | Kentucky |  | Vs. | Florida A&M |  | 96 | 76
78 | 2004 | St. Joseph's |  | Vs. | Liberty |  | 82 | 63
79 | 2004 | Duke |  | Vs. | Alabama State |  | 96 | 61
80 | 2004 | Stanford |  | Vs. | UTSA |  | 71 | 45
81 | 2005 | North Carolina |  | Vs. | Oakland |  | 96 | 68
82 | 2005 | Duke |  | Vs. | Delaware State |  | 57 | 46
83 | 2005 | Illinois |  | Vs. | [NAME] |  | 67 | 55
84 | 2005 | Washington |  | Vs. | Montana |  | 88 | 77
85 | 2006 | Uconn |  | Vs. | Albany |  | 72 | 59
86 | 2006 | Villanova |  | Vs. | Monmouth |  | 58 | 45
87 | 2006 | Duke |  | Vs. | Southern |  | 70 | 54
88 | 2006 | Memphis |  | Vs. | Oral Roberts |  | 94 | 78
89 | 2007 | Florida |  | Vs. | Jackson State |  | 112 | 69
90 | 2007 | Kansas |  | Vs. | [NAME] |  | 107 | 67
91 | 2007 | North Carolina |  | Vs. | Eastern Kentucky |  | 86 | 65
92 | 2007 | Ohio State |  | Vs. | Central Connecticut State |  | 78 | 57
93 | 2008 | North Carolina |  | Vs. | Mount St. Mary's |  | 113 | 74
94 | 2008 | Kansas |  | Vs. | Portland State |  | 85 | 61
95 | 2008 | Memphis |  | Vs. | UT-Arlington |  | 87 | 63
96 | 2008 | UCLA |  | Vs. | Mississippi Valley State |  | 70 | 29
97 | 2009 | Pittsburgh |  | Vs. | East Tennessee State |  | 72 | 62
98 | 2009 | North Carolina |  | Vs. | Radford |  | 101 | 58
99 | 2009 | Louisville |  | Vs. | Morehead State |  | 74 | 54
100 | 2009 | Uconn |  | Vs. | Chattanooga |  | 103 | 47
101 | 2010 | Kansas |  | Vs. | Lehigh |  | 90 | 74
102 | 2010 | Syracuse |  | Vs. | Vermont |  | 79 | 56
103 | 2010 | Kentucky |  | Vs. | East Tennessee State |  | 100 | 71
104 | 2010 | Duke |  | Vs. | Arkansas-Pine Bluff |  | 73 | 44
105 | 2011 | Ohio State |  | Vs. | UTSA |  | 75 | 46
106 | 2011 | Michigan |  | Vs. | Tennessee |  | 75 | 45
107 | 2011 | Pittsburgh |  | Vs. | UNC-Asheville |  | 74 | 51
108 | 2011 | Kansas |  | Vs. | Boston University |  | 72 | 53
109 | 2012 | Kentucky |  | Vs. | Western Kentucky |  | 81 | 66
110 | 2012 | Michigan State |  | Vs. | [NAME] |  | 89 | 67
111 | 2012 | Syracuse |  | Vs. | UNC-Asheville |  | 72 | 65
112 | 2012 | North Carolina |  | Vs. | Vermont |  | 77 | 58
113 | 2013 | Villanova |  | Vs. | Mount St. Mary's |  | 76 | 56
114 | 2013 | Kansas |  | Vs. | [NAME] |  | 100 | 62
115 | 2013 | Gonzaga |  | Vs. | South Dakota State |  | 66 | 46
116 | 2013 | North Carolina |  | Vs. | Texas Southern |  | 103 | 64
117 | 2014 | Florida |  | Vs. | Albany |  | 67 | 55
118 | 2014 | Arizona |  | Vs. | Weber State |  | 68 | 59
119 | 2014 | Virginia |  | Vs. | Coastal Carolina |  | 80 | 69
120 | 2014 | Wichita State |  | Vs. | [NAME] |  | 64 | 37
121 | 2015 | Kentucky |  | Vs. | Hampton |  | 79 | 56
122 | 2015 | Villanova |  | Vs. | Lafayette |  | 93 | 52
123 | 2015 | Wisconsin |  | Vs. | Coastal Carolina |  | 86 | 72
124 | 2015 | Duke |  | Vs. | [NAME] |  | 85 | 56
125 | 2016 | Kansas |  | Vs. | [NAME] |  | 105 | 79
126 | 2016 | North Carolina |  | Vs. | Florida Gulf Coast |  | 83 | 67
127 | 2016 | Oregon |  | Vs. | Holy Cross |  | 91 | 52
128 | 2016 | Virginia |  | Vs. | Hampton |  | 81 | 45
129 | 2017 | Villanova |  | Vs. | Mount St. Mary's |  | 76 | 56
130 | 2017 | Gonzaga |  | Vs. | South Dakota State |  | 66 | 46
131 | 2017 | Kansas |  | Vs. | [NAME] |  | 100 | 62
132 | 2017 | North Carolina |  | Vs. | Texas Southern |  | 103 | 64