View Full Version : AGS Top 35 vs AGS Top 35
grizband
November 14th, 2017, 10:30 PM
I created this spreadsheet that illustrates the records of everyone in the AGS poll (top 25 plus ORV), versus the other teams in the poll.
Rank
Team
Conference
OOC
Total
1
James Madison
CAA
2-0
2
North Dakota State
MVFC
1-0
4-1
3
Central Arkansas
SLC
2-0
4
Jacksonville State
OVC
1-0
5
South Dakota State
MVFC
3-1
6
Sam Houston State
SLC
1-0
2-1
7
Wofford
Southern
2-1
8
Southern Utah
Big Sky
1-0
3-2
9
Stony Brook
CAA
2-1
10
Weber State
Big Sky
3-1
11
Western Illinois
MVFC
1-0
3-3
12
Elon
CAA
1-0
2-1
13
North Carolina A&T
MEAC
0-0
14
Furman
Southern
1-0
2-2
15
South Dakota
MVFC
1-3
16
Northern Arizona
Big Sky
0-1
3-2
17
Northern Iowa
MVFC
0-1
2-3
18
Samford
Southern
1-0
2-1
19
Delaware
CAA
2-1
20
New Hampshire
CAA
1-2
21
Monmouth
Big South
0-0
22
Montana
Big Sky
1-2
23
McNeese State
SLC
0-2
24
Kennesaw State
Big South
0-1
0-1
25
Eastern Washington
Big Sky
0-1
2-3
26
Illinois State
MVFC
0-1
1-3
27
Nicholls State
SLC
1-1
28
Western Carolina
Southern
1-2
29
Grambling State
SWAC
0-0
30
Yale
IVY
0-0
31
Richmond
CAA
1-1
1-4
32
Colgate
Patriot
0-2
0-2
33
Sacramento State
Big Sky
1-3
34
Austin Peay
OVC
1-1
35
North Carolina Central
MEAC
0-0
grizband
November 14th, 2017, 10:31 PM
Here is the full spreadsheet, including games each of the teams played against the AGS top 35.
Rank
Team
Conference
OOC
Total
Opponent (Result)
Opponent (Result)
Opponent (Result)
Opponent (Result)
Opponent (Result)
Opponent (Result)
1
James Madison
CAA
3-0
Delaware (W 20-10)
New Hampshire (W 21-0)
Richmond (W 20-13)
2
North Dakota State
MVFC
1-0
4-1
EWU (W 40-13)
Western Illinois (W 24-12)
Northern Iowa (W 30-14)
South Dakota State (L 33-21)
South Dakota (W 49-14
3
Central Arkansas
SLC
2-0
SHSU (W 41-30)
McNeese State (W 47-17)
4
Jacksonville State
OVC
1-0
Austin Peay (W 34-14)
5
South Dakota State
MVFC
3-1
Nothern Iowa (L 38-18)
Western Illinois (W 52-24)
NDSU (W 33-21)
Illinois State (W 27-24)
6
Sam Houston State
SLC
1-0
2-1
Nicholls State (W 66-7)
Central Arkansas (L 41-30)
Richmond (W 48-34)
7
Wofford
Southern
2-1
Furman (W 24-23)
Western Carolina (W 35-28)
Samford (L 24-21)
8
Southern Utah
Big Sky
1-0
3-2
Northern Iowa (W 24-21)
Sacramento State (L 54-27)
Weber State (W 32-16)
EWU (W 46-28)
Sacramento State (L 54-27)
9
Stony Brook
CAA
2-1
Delaware (L 24-20)
New Hampshire (W 27-24)
Richmond (W 27-24)
10
Weber State
Big Sky
3-1
Sacramento State (W 31-24)
Southern Utah (L 32-16)
Montana (W 41-27)
EWU (W 28-20)
11
Western Illinois
MVFC
1-0
3-3
Nothern Arizona (W 38-20)
South Dakota (L 38-33)
Nothern Iowa (W 38-29)
NDSU (L 24-12)
South Dakota State (L 52-24)
Illinois State (W 31-14)
12
Elon
CAA
1-0
2-1
Furman (W 34-31)
Richmond (W 36-33)
New Hampshire (L 16-6)
13
North Carolina A&T
MEAC
0-0
14
Furman
Southern
1-0
2-2
Wofford (L 24-23)
Elon (L 34-31)
Western Carolina (W 28-6)
Colgate (W 45-14)
15
South Dakota
MVFC
1-3
Western Illinois (W 38-33)
Illinois State (L 37-21)
Northern Iowa (L 34-29)
NDSU (L 49-14)
16
Northern Arizona
Big Sky
0-1
3-2
Western Illinois (L 38-20)
Illinois State (W 37-16)
Sacramento State (W 37-17)
Montana (L 17-15)
Sacramento State (W 37-17)
17
Northern Iowa
MVFC
0-1
2-3
Southern Utah (L 24-21)
Western Illinois (L 38-29)
South Dakota State (W 38-18)
NDSU (L 30-14)
South Dakota (W 34-29)
18
Samford
Southern
1-0
2-1
Kennesaw State (W 28-23)
Western Carolina (L 38-34)
Wofford (W 24-21)
19
Delaware
CAA
2-1
James Madison (L 20-10)
Stony Brook (W 24-20)
Richmond (W 42-35)
20
New Hampshire
CAA
1-2
Stony Brook (L 38-24)
James Madison (L 21-0)
Elon (W 16-6)
21
Monmouth
Big South
0-0
22
Montana
Big Sky
1-2
EWU (L 48-41)
Weber State (L 41-27)
Northern Arizona (W 17-15)
23
McNeese State
SLC
0-2
Nicholls State (L 37-35)
Central Arkansas (L 47-17)
24
Kennesaw State
Big South
0-1
0-1
Samford (L 28-23)
25
Eastern Washington
Big Sky
0-1
2-3
NDSU (L 40-13)
Montana (W 48-41)
Sacramento State (W 52-31)
Southern Utah (L 46-28)
Weber State (L 28-20)
26
Illinois State
MVFC
0-1
1-3
Nothern Arizona (L 37-16)
South Dakota (W 37-21)
Western Illinois (L 31-14)
South Dakota State (L 27-24)
27
Nicholls State
SLC
1-1
McNeese State (W 37-35)
SHSU (L 66-17)
28
Western Carolina
Southern
1-2
Samford (W 38-34)
Wofford (L 38-28)
Furman (L 28-6)
29
Grambling State
SWAC
0-0
30
Yale
IVY
0-0
31
Richmond
CAA
1-1
1-4
SHSU (L 48-34)
Elon (L 36-33)
Delaware (L 42-35)
Stony Brook (L 27-24)
James Madison (L 20-13)
Colgate (W 20-17)
32
Colgate
Patriot
0-2
0-2
Richmond (L 20-17)
Furman (L 45-14)
33
Sacramento State
Big Sky
1-3
Weber State (L 31-24)
Southern Utah (W 54-27)
EWU (L 52-31)
Northern Arizona (L 37-17)
34
Austin Peay
OVC
1-1
Jacksonville State (L 34-14)
35
North Carolina Central
MEAC
0-0
MR. CHICKEN
November 15th, 2017, 08:43 AM
Here is the full spreadsheet, including games each of the teams played against the AGS top 35.
Rank
Team
Conference
OOC
Total
Opponent (Result)
Opponent (Result)
Opponent (Result)
Opponent (Result)
Opponent (Result)
Opponent (Result)
1
James Madison
CAA
2-0
Delaware (W 20-10)
New Hampshire (W 21-0)
Richmond (W 20-13)
2
North Dakota State
MVFC
1-0
4-1
EWU (W 40-13)
Western Illinois (W 24-12)
Northern Iowa (W 30-14)
South Dakota State (L 33-21)
South Dakota (W 49-14
3
Central Arkansas
SLC
2-0
SHSU (W 41-30)
McNeese State (W 47-17)
4
Jacksonville State
OVC
1-0
Austin Peay (W 34-14)
5
South Dakota State
MVFC
3-1
Nothern Iowa (L 38-18)
Western Illinois (W 52-24)
NDSU (W 33-21)
Illinois State (W 27-24)
6
Sam Houston State
SLC
1-0
2-1
Nicholls State (W 66-7)
Central Arkansas (L 41-30)
Richmond (W 48-34)
7
Wofford
Southern
2-1
Furman (W 24-23)
Western Carolina (W 35-28)
Samford (L 24-21)
8
Southern Utah
Big Sky
1-0
3-2
Northern Iowa (W 24-21)
Sacramento State (L 54-27)
Weber State (W 32-16)
EWU (W 46-28)
Sacramento State (L 54-27)
9
Stony Brook
CAA
2-1
Delaware (L 24-20)
New Hampshire (W 27-24)
Richmond (W 27-24)
10
Weber State
Big Sky
3-1
Sacramento State (W 31-24)
Southern Utah (L 32-16)
Montana (W 41-27)
EWU (W 28-20)
11
Western Illinois
MVFC
1-0
3-3
Nothern Arizona (W 38-20)
South Dakota (L 38-33)
Nothern Iowa (W 38-29)
NDSU (L 24-12)
South Dakota State (L 52-24)
Illinois State (W 31-14)
12
Elon
CAA
1-0
2-1
Furman (W 34-31)
Richmond (W 36-33)
New Hampshire (L 16-6)
13
North Carolina A&T
MEAC
0-0
14
Furman
Southern
1-0
2-2
Wofford (L 24-23)
Elon (L 34-31)
Western Carolina (W 28-6)
Colgate (W 45-14)
15
South Dakota
MVFC
1-3
Western Illinois (W 38-33)
Illinois State (L 37-21)
Northern Iowa (L 34-29)
NDSU (L 49-14)
16
Northern Arizona
Big Sky
0-1
3-2
Western Illinois (L 38-20)
Illinois State (W 37-16)
Sacramento State (W 37-17)
Montana (L 17-15)
Sacramento State (W 37-17)
17
Northern Iowa
MVFC
0-1
2-3
Southern Utah (L 24-21)
Western Illinois (L 38-29)
South Dakota State (W 38-18)
NDSU (L 30-14)
South Dakota (W 34-29)
18
Samford
Southern
1-0
2-1
Kennesaw State (W 28-23)
Western Carolina (L 38-34)
Wofford (W 24-21)
19
Delaware
CAA
2-1
James Madison (L 20-10)
Stony Brook (W 24-20)
Richmond (W 42-35)
20
New Hampshire
CAA
1-2
Stony Brook (L 38-24)
James Madison (L 21-0)
Elon (W 16-6)
21
Monmouth
Big South
0-0
22
Montana
Big Sky
1-2
EWU (L 48-41)
Weber State (L 41-27)
Northern Arizona (W 17-15)
23
McNeese State
SLC
0-2
Nicholls State (L 37-35)
Central Arkansas (L 47-17)
24
Kennesaw State
Big South
0-1
0-1
Samford (L 28-23)
25
Eastern Washington
Big Sky
0-1
2-3
NDSU (L 40-13)
Montana (W 48-41)
Sacramento State (W 52-31)
Southern Utah (L 46-28)
Weber State (L 28-20)
26
Illinois State
MVFC
0-1
1-3
Nothern Arizona (L 37-16)
South Dakota (W 37-21)
Western Illinois (L 31-14)
South Dakota State (L 27-24)
27
Nicholls State
SLC
1-1
McNeese State (W 37-35)
SHSU (L 66-17)
28
Western Carolina
Southern
1-2
Samford (W 38-34)
Wofford (L 38-28)
Furman (L 28-6)
29
Grambling State
SWAC
0-0
30
Yale
IVY
0-0
31
Richmond
CAA
1-1
1-4
SHSU (L 48-34)
Elon (L 36-33)
Delaware (L 42-35)
Stony Brook (L 27-24)
James Madison (L 20-13)
Colgate (W 20-17)
32
Colgate
Patriot
0-2
0-2
Richmond (L 20-17)
Furman (L 45-14)
33
Sacramento State
Big Sky
1-3
Weber State (L 31-24)
Southern Utah (W 54-27)
EWU (L 52-31)
Northern Arizona (L 37-17)
34
Austin Peay
OVC
1-1
Jacksonville State (L 34-14)
35
North Carolina Central
MEAC
0-0
...AUSTIN PEAY'S......W?..........YEAH..........AH COOD LOOKY UP......xscanx...BRAWK!!
jmufan999
November 15th, 2017, 09:24 AM
JMU has 3 wins. UNH, Delaware, and Richmond.
KPSUL
November 15th, 2017, 10:44 AM
I'm not sure why you are including 26-35. There's a huge difference between a game vs a top 10 teams compared to 20-25, let alone 30-35. If this process is to offer any meaningful comparison there needs to be a method to weight wins against top teams, and losses to lower ranked teams more heavily.
grizband
November 15th, 2017, 11:48 AM
I'm not sure why you are including 26-35. There's a huge difference between a game vs a top 10 teams compared to 20-25, let alone 30-35. If this process is to offer any meaningful comparison there needs to be a method to weight wins against top teams, and losses to lower ranked teams more heavily.Main reason waa to include all teams in the pool, approximately the top 25% of FCS.
Sent from my SM-N920V using Tapatalk
Reign of Terrier
November 15th, 2017, 11:54 AM
Western Illinois is the definition of an enigma lol
ST_Lawson
November 15th, 2017, 12:30 PM
Western Illinois is the definition of an enigma lol
https://cdn.someecards.com/someecards/usercards/im-just-a-riddle-wrapped-in-a-mystery-inside-an-enigma-cloaked-in-bacon-03b2a.png
grizband
November 15th, 2017, 05:55 PM
I'm not sure why you are including 26-35. There's a huge difference between a game vs a top 10 teams compared to 20-25, let alone 30-35. If this process is to offer any meaningful comparison there needs to be a method to weight wins against top teams, and losses to lower ranked teams more heavily.
Main reason waa to include all teams in the pool, approximately the top 25% of FCS.
Sent from my SM-N920V using Tapatalk
And, if I'm being honest, the top 35 teams are usually a representative of the top quality teams in FCS. If I only did games versus top 10 teams, this would have been a pretty sparse list.
grizband
November 15th, 2017, 05:56 PM
JMU has 3 wins. UNH, Delaware, and Richmond.
Good catch, I updated the spreadsheet.
Engineer86
November 15th, 2017, 07:02 PM
Good catch, I updated the spreadsheet.
Nice work, one fix
Furman is 1-1 OOC
AmsterBison
November 16th, 2017, 09:47 AM
Nice work!
I noticed that somebody has been putting FCS poll results on Wikipedia so I wrote some code to show a teams' records versus ranked teams.
Note: Since there are two polls, I used the higher ranking for each week. And, oh yeah, I haven't checked the results too carefully.
Every team who has played more than 2 ranked teams:
Query10
TeamId
vTop25
vTop10
Abilene Christian
0-3
0-1
Chattanooga
1-2
1-2
Delaware
2-1
1-1
East Tennessee State
0-5
0-2
Eastern Illinois
1-2
0-1
Elon
4-1
1-0
Gardner-Webb
0-4
0-1
Illinois State
2-2
1-1
Incarnate Word
0-4
0-2
Indiana State
0-5
0-3
Maine
0-3
0-1
Mercer (GA)
2-2
0-1
Missouri State
0-6
0-1
Montana
1-2
0-0
Montana State
1-5
0-2
Murray State
1-2
0-1
Norfolk State
1-2
0-2
North Dakota
0-4
0-0
North Dakota State
5-1
4-1
Northern Iowa
3-2
3-1
Northwestern State (LA)
0-5
0-2
Presbyterian
0-3
0-1
Rhode Island
0-3
0-1
Richmond
3-3
0-2
Sacramento State
0-3
0-1
Sam Houston State
2-1
1-0
South Dakota
3-2
2-1
South Dakota State
3-1
1-1
Southeastern LA
0-3
0-1
Southern Illinois
1-3
0-2
Southern Utah
3-0
1-0
Stephen F. Austin
0-4
0-2
SUNY-Albany
1-3
1-0
Tennessee-Martin
2-1
0-1
The Citadel
0-4
0-1
Towson
1-4
0-1
UC Davis
0-4
0-1
Villanova
1-2
0-2
VMI
0-3
0-1
Western Illinois
2-3
0-3
William & Mary
0-3
0-1
Wofford
2-1
0-0
Youngstown State
1-3
1-2
Professor Chaos
November 16th, 2017, 10:02 AM
Nice work!
I noticed that somebody has been putting FCS poll results on Wikipedia so I wrote some code to show a teams' records versus ranked teams.
Note: Since there are two polls, I used the higher ranking for each week. And, oh yeah, I haven't checked the results too carefully.
Every team who has played more than 2 ranked teams:
Query10
TeamId
vTop25
vTop10
Abilene Christian
0-3
0-1
Chattanooga
1-2
1-2
Delaware
2-1
1-1
East Tennessee State
0-5
0-2
Eastern Illinois
1-2
0-1
Elon
4-1
1-0
Gardner-Webb
0-4
0-1
Illinois State
2-2
1-1
Incarnate Word
0-4
0-2
Indiana State
0-5
0-3
Maine
0-3
0-1
Mercer (GA)
2-2
0-1
Missouri State
0-6
0-1
Montana
1-2
0-0
Montana State
1-5
0-2
Murray State
1-2
0-1
Norfolk State
1-2
0-2
North Dakota
0-4
0-0
North Dakota State
5-1
4-1
Northern Iowa
3-2
3-1
Northwestern State (LA)
0-5
0-2
Presbyterian
0-3
0-1
Rhode Island
0-3
0-1
Richmond
3-3
0-2
Sacramento State
0-3
0-1
Sam Houston State
2-1
1-0
South Dakota
3-2
2-1
South Dakota State
3-1
1-1
Southeastern LA
0-3
0-1
Southern Illinois
1-3
0-2
Southern Utah
3-0
1-0
Stephen F. Austin
0-4
0-2
SUNY-Albany
1-3
1-0
Tennessee-Martin
2-1
0-1
The Citadel
0-4
0-1
Towson
1-4
0-1
UC Davis
0-4
0-1
Villanova
1-2
0-2
VMI
0-3
0-1
Western Illinois
2-3
0-3
William & Mary
0-3
0-1
Wofford
2-1
0-0
Youngstown State
1-3
1-2
So 3-7 Missouri St has lost to 6 ranked FCS teams and FBS Missouri.
Quality losses!!!
kalm
November 16th, 2017, 10:05 AM
Nice work!
I noticed that somebody has been putting FCS poll results on Wikipedia so I wrote some code to show a teams' records versus ranked teams.
Note: Since there are two polls, I used the higher ranking for each week. And, oh yeah, I haven't checked the results too carefully.
Every team who has played more than 2 ranked teams:
Query10
TeamId
vTop25
vTop10
Abilene Christian
0-3
0-1
Chattanooga
1-2
1-2
Delaware
2-1
1-1
East Tennessee State
0-5
0-2
Eastern Illinois
1-2
0-1
Elon
4-1
1-0
Gardner-Webb
0-4
0-1
Illinois State
2-2
1-1
Incarnate Word
0-4
0-2
Indiana State
0-5
0-3
Maine
0-3
0-1
Mercer (GA)
2-2
0-1
Missouri State
0-6
0-1
Montana
1-2
0-0
Montana State
1-5
0-2
Murray State
1-2
0-1
Norfolk State
1-2
0-2
North Dakota
0-4
0-0
North Dakota State
5-1
4-1
Northern Iowa
3-2
3-1
Northwestern State (LA)
0-5
0-2
Presbyterian
0-3
0-1
Rhode Island
0-3
0-1
Richmond
3-3
0-2
Sacramento State
0-3
0-1
Sam Houston State
2-1
1-0
South Dakota
3-2
2-1
South Dakota State
3-1
1-1
Southeastern LA
0-3
0-1
Southern Illinois
1-3
0-2
Southern Utah
3-0
1-0
Stephen F. Austin
0-4
0-2
SUNY-Albany
1-3
1-0
Tennessee-Martin
2-1
0-1
The Citadel
0-4
0-1
Towson
1-4
0-1
UC Davis
0-4
0-1
Villanova
1-2
0-2
VMI
0-3
0-1
Western Illinois
2-3
0-3
William & Mary
0-3
0-1
Wofford
2-1
0-0
Youngstown State
1-3
1-2
Maybe I'm missing something, but EWU has played NDSU, Montana, Weber, and SUU.
Professor Chaos
November 16th, 2017, 10:06 AM
Maybe I'm missing something, but EWU has played NDSU, Montana, Weber, and SUU.
Montana, for some reason, is not currently ranked in either the STATS or Coaches polls.
Catbooster
November 16th, 2017, 10:49 AM
Nice work!
I noticed that somebody has been putting FCS poll results on Wikipedia so I wrote some code to show a teams' records versus ranked teams.
Note: Since there are two polls, I used the higher ranking for each week. And, oh yeah, I haven't checked the results too carefully.
Every team who has played more than 2 ranked teams:
TeamId
vTop25
vTop10
Abilene Christian
0-3
0-1
Chattanooga
1-2
1-2
Delaware
2-1
1-1
East Tennessee State
0-5
0-2
Eastern Illinois
1-2
0-1
Elon
4-1
1-0
Gardner-Webb
0-4
0-1
Illinois State
2-2
1-1
Incarnate Word
0-4
0-2
Indiana State
0-5
0-3
Maine
0-3
0-1
Mercer (GA)
2-2
0-1
Missouri State
0-6
0-1
Montana
1-2
0-0
Montana State
1-5
0-2
Murray State
1-2
0-1
Norfolk State
1-2
0-2
North Dakota
0-4
0-0
North Dakota State
5-1
4-1
Northern Iowa
3-2
3-1
Northwestern State (LA)
0-5
0-2
Presbyterian
0-3
0-1
Rhode Island
0-3
0-1
Richmond
3-3
0-2
Sacramento State
0-3
0-1
Sam Houston State
2-1
1-0
South Dakota
3-2
2-1
South Dakota State
3-1
1-1
Southeastern LA
0-3
0-1
Southern Illinois
1-3
0-2
Southern Utah
3-0
1-0
Stephen F. Austin
0-4
0-2
SUNY-Albany
1-3
1-0
Tennessee-Martin
2-1
0-1
The Citadel
0-4
0-1
Towson
1-4
0-1
UC Davis
0-4
0-1
Villanova
1-2
0-2
VMI
0-3
0-1
Western Illinois
2-3
0-3
William & Mary
0-3
0-1
Wofford
2-1
0-0
Youngstown State
1-3
1-2
Thanks - this is ranked when the game occurred? We've played Washington State (ranked FBS), SDSU, Weber, EWU, Kennesaw St, NAU and UND (ranked at the time, but fell like a rock). If we're 1-5, the only win out of those is UND (and it doesn't count FBS).
Average margin of loss is 5.4 points. Quality losses, baby! xthumbsupx xeyebrowx xsmhx xthumbsdownx
AmsterBison
November 16th, 2017, 10:52 AM
Thanks - this is ranked when the game occurred? We've played Washington State (ranked FBS), SDSU, Weber, EWU, Kennesaw St, NAU and UND (ranked at the time, but fell like a rock). If we're 1-5, the only win out of those is UND (and it doesn't count FBS).
Quality losses, baby! xthumbsupx xeyebrowx xsmhx xthumbsdownx
I should have noted that: I'm showing rankings at the time of the game because teams change a heckuva lot between week 1 and week 11.
The raw data: https://docs.google.com/spreadsheets/d/1Zo3mjiFQCIhR4rNaXs8RB98Yl7gGJb2BKOysw9DUOiA/edit#gid=0
I don't use Google docs much so apologies if the link doesn't work.
MR. CHICKEN
November 16th, 2017, 11:33 AM
Good catch, I updated the spreadsheet.
.....HEY....GRIZZWOLD..........AH HAD UH...GOOD CATCH..............TOO!.......:(........BRAWK!
grizband
November 16th, 2017, 02:09 PM
Montana, for some reason, is not currently ranked in either the STATS or Coaches polls.Partially why I used AGS, and expanded it to 35 teams.
Sent from my SM-N920V using Tapatalk
grizband
November 16th, 2017, 02:10 PM
.....HEY....GRIZZWOLD..........AH HAD UH...GOOD CATCH..............TOO!.......:(........BRAWK! How could I forget! Thanks Mr. Chicken!
Sent from my SM-N920V using Tapatalk
Powered by vBulletin® Copyright © 2024 vBulletin Solutions Inc. All rights reserved.