Predict every Power 5 game in 2017 [PUBLIC]
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJ
1
Spreadsheet by @ThomasNassiff.

Instructions (read first): Log into Gmail. Open up a new tab in your browser and create a new spreadsheet, and title it whatever you like. Come back into this sheet. At the bottom of this spreadsheet, where it says Sheet1 (below the SEC Team column), click the arrow on the right, then click Copy To. Copy this to your new spreadsheet. Go to your new sheet. This will be in the second tab (check that area where it says Sheet1). Delete the first tab, so this is the only one. Read the instructions in the next tab, then delete this row if you don't want the instructions to appear anymore.
HOW THE SHEET WORKS:

Put a W or L in the PREDICTION column for each game. Make sure you aren't accidentally predicting a W or L for both teams in the same game -- keep track as you go, because the sheet won't know if you make a mistake like this. Also, make sure you don't predict a W or L for a team in their bye week. The Ws and Ls will collect into a W-L record for each team below their schedule and at the bottom of each conference, separated by divisions. Use that to figure out your division winners -- you can create your own predicted standings if you cut-paste the group of the team name and their W and L projections. From there, predict your championship winners and create your projections for the final Top 25 and Playoff matchups (at the bottom). Boom! Your predictions are complete.

As the season goes on, plug a W or L into the RESULT? column to keep track of how each team actually did. The CORRECT? column will automatically fill in based on the RESULT? column to show whether you were right or wrong. As you do this, your correct/incorrect record will compile for each team, each conference and the whole nation (at the bottom). Make sure to use the inputs specificied (W/L/Y/N) -- otherwise it won't compile correctly. The sheet will also compile each team's real-life W-L record.

Here's to a great new year of college football. Go Gators!
2
SECACCBig TenPac-12Big 12Notre Dame, if u care
3
TeamWeekOpponent
Prediction (W/L)
Result? (W/L)Correct? (Y/N)TeamWeekOpponent
Prediction (W/L)
Result? (W/L)Correct? (Y/N)TeamWeekOpponent
Prediction (W/L)
Result? (W/L)Correct? (Y/N)TeamWeekOpponent
Prediction (W/L)
Result? (W/L)Correct? (Y/N)TeamWeekOpponent
Prediction (W/L)
Result? (W/L)Correct? (Y/N)TeamWeekOpponent
Prediction (W/L)
Result? (W/L)Correct? (Y/N)
4
AlabamaAug. 26--Boston CollegeAug. 26--IllinoisAug. 26--ArizonaAug. 26--BaylorAug. 26--Notre DameAug. 26--
5
Alabama1Florida State (N)Boston College1at Northern IllinoisIllinois1Ball StateArizona1NAUBaylor1LibertyNotre Dame1Temple
6
Alabama2Fresno StateBoston College2Wake ForestIllinois2Western KentuckyArizona2HoustonBaylor2UTSANotre Dame2Georgia
7
Alabama3Colorado StateBoston College3Notre DameIllinois3at USFArizona3at UTEPBaylor3at DukeNotre Dame3at Boston College
8
Alabama4at VanderbiltBoston College4at ClemsonIllinois4OFFArizona4UtahBaylor4OklahomaNotre Dame4at Michigan State
9
Alabama5Ole MissBoston College5Central MichiganIllinois5NebraskaArizona5OFFBaylor5at Kansas StateNotre Dame5Miami (OH)
10
Alabama6at Texas A&MBoston College6Virginia TechIllinois6at IowaArizona6at ColoradoBaylor6OFFNotre Dame6at North Carolina
11
Alabama7ArkansasBoston College7at LouisvilleIllinois7RutgersArizona7UCLABaylor7at Oklahoma State CoNotre Dame7OFF
12
Alabama8TennesseeBoston College8at VirginiaIllinois8at MinnesotaArizona8at CaliforniaBaylor8West VirginiaNotre Dame8USC
13
Alabama9OFFBoston College9Florida StateIllinois9WisconsinArizona9Washington StateBaylor9TexasNotre Dame9NC State
14
Alabama10LSU Tigers Boston College10OFFIllinois10at PurdueArizona10at Southern CaliforniaBaylor10at KansasNotre Dame10Wake Forest
15
Alabama11at Mississippi StateBoston College11NC StateIllinois11IndianaArizona11Oregon StateBaylor11Texas Tech (N)Notre Dame11at Miami (FL)
16
Alabama12MercerBoston College12at UConn (N)Illinois12at Ohio StateArizona12at OregonBaylor12Iowa StateNotre Dame12Navy
17
Alabama13at AuburnBoston College13at SyracuseIllinois13NorthwesternArizona13at Arizona StateBaylor13at TCUNotre Dame13at Stanford
18
Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)
19
Real Life Wins0Real Life Losses000Real Life Wins0Real Life Losses000Real Life Wins0Real Life Losses000Real Life Wins0Real Life Losses000Real Life Wins0Real Life Losses000Real Life Wins0Real Life Losses000
20
ArkansasAug. 26--ClemsonAug. 26--IndianaAug. 26--Arizona St.Aug. 26--Iowa St.Aug. 26--
21
Arkansas1Florida A&MClemson1Kent StateIndiana1Ohio StateArizona St.1New Mexico StateIowa St.1Northern Iowa
22
Arkansas2TCU Horned FrogsClemson2AuburnIndiana2at VirginiaArizona St.2San Diego StateIowa St.2Iowa
23
Arkansas3OFFClemson3at LouisvilleIndiana3FIUArizona St.3at Texas TechIowa St.3at Akron
24
Arkansas4Texas A&M Aggies (N)Clemson4Boston CollegeIndiana4Georgia SouthernArizona St.4OregonIowa St.4OFF
25
Arkansas5
New Mexico State Aggies
Clemson5at Virginia TechIndiana5at Penn StateArizona St.5at StanfordIowa St.5Texas
26
Arkansas6at South CarolinaClemson6Wake ForestIndiana6OFFArizona St.6OFFIowa St.6at Oklahoma
27
Arkansas7at AlabamaClemson7at SyracuseIndiana7MichiganArizona St.7WashingtonIowa St.7Kansas
28
Arkansas8AuburnClemson8OFFIndiana8at Michigan StateArizona St.8at UtahIowa St.8at Texas Tech Red
29
Arkansas9at Ole MissClemson9Georgia TechIndiana9at MarylandArizona St.9Southern CaliforniaIowa St.9TCU
30
Arkansas10Coastal CarolinaClemson10at NC StateIndiana10WisconsinArizona St.10ColoradoIowa St.10at West Virginia
31
Arkansas11at LSUClemson11Florida StateIndiana11at IllinoisArizona St.11at UCLAIowa St.11Oklahoma
32
Arkansas12Mississippi StateClemson12The CitadelIndiana12RutgersArizona St.12at Oregon StateIowa St.12at Baylor
33
Arkansas13Missouri TigersClemson13at South CarolinaIndiana13at PurdueArizona St.13ArizonaIowa St.13at Kansas State
34
Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)
35
Real Life Wins0Real Life Losses000Real Life Wins0Real Life Losses000Real Life Wins0Real Life Losses000Real Life Wins0Real Life Losses000Real Life Wins0Real Life Losses000
36
AuburnAug. 26--DukeAug. 26--IowaAug. 26--CaliforniaAug. 26--KansasAug. 26--
37
Auburn1Georgia SouthernDuke1NC CentralIowa1WyomingCalifornia1at North CarolinaKansas1Southeast Missouri
38
Auburn2at ClemsonDuke2NorthwesternIowa2at Iowa StateCalifornia2Weber StateKansas2Central Michigan
39
Auburn3MercerDuke3BaylorIowa3North TexasCalifornia3Ole MissKansas3at Ohio
40
Auburn4at MissouriDuke4at North CarolinaIowa4Penn StateCalifornia4Southern CaliforniaKansas4West Virginia
41
Auburn5Mississippi StateDuke5MiamiIowa5at Michigan StateCalifornia5at OregonKansas5OFF
42
Auburn6Ole MissDuke6at VirginiaIowa6IllinoisCalifornia6at WashingtonKansas6Texas Tech
43
Auburn7at LSUDuke7Florida StateIowa7OFFCalifornia7Washington StateKansas7at Iowa State
44
Auburn8at ArkansasDuke8PittsburghIowa8at NorthwesternCalifornia8ArizonaKansas8at TCU
45
Auburn9OFFDuke9at Virginia TechIowa9MinnesotaCalifornia9at ColoradoKansas9Kansas State
46
Auburn10at Texas A&MDuke10OFFIowa10Ohio StateCalifornia10Oregon StateKansas10Baylor
47
Auburn11GeorgiaDuke11at ArmyIowa11at WisconsinCalifornia11OFFKansas11at Texas
48
Auburn12ULMDuke12Georgia TechIowa12PurdueCalifornia12at StanfordKansas12Oklahoma
49
Auburn13AlabamaDuke13at Wake ForestIowa13at NebraskaCalifornia13at UCLAKansas13at Oklahoma State
50
Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)
51
Real Life Wins0Real Life Losses000Real Life Wins0Real Life Losses000Real Life Wins0Real Life Losses000Real Life Wins0Real Life Losses000Real Life Wins0Real Life Losses000
52
FloridaAug. 26--Florida St.Aug. 26--MarylandAug. 26--ColoradoAug. 26--Kansas St.Aug. 26--
53
Florida1Michigan (N)Florida St.1Alabama (N)Maryland1at TexasColorado1Colorado State (N)Kansas St.1Central Arkansas
54
Florida2Northern ColoradoFlorida St.2ULMMaryland2TowsonColorado2Texas StateKansas St.2Charlotte
55
Florida3TennesseeFlorida St.3MiamiMaryland3OFFColorado3Northern ColoradoKansas St.3at Vanderbilt
56
Florida4at KentuckyFlorida St.4NC StateMaryland4UCFColorado4WashingtonKansas St.4OFF
57
Florida5VanderbiltFlorida St.5at Wake ForestMaryland5at MinnesotaColorado5at UCLAKansas St.5Baylor
58
Florida6LSUFlorida St.6OFFMaryland6at Ohio StateColorado6ArizonaKansas St.6at Texas
59
Florida7Texas A&MFlorida St.7at DukeMaryland7NorthwesternColorado7at Oregon StateKansas St.7TCU
60
Florida8OFFFlorida St.8LouisvilleMaryland8at WisconsinColorado8at Washington StateKansas St.8Oklahoma
61
Florida9Georgia (N)Florida St.9at Boston CollegeMaryland9IndianaColorado9CaliforniaKansas St.9at Kansas
62
Florida10at MissouriFlorida St.10SyracuseMaryland10at Rutgers (N)Colorado10at Arizona StateKansas St.10at Texas Tech
63
Florida11at South CarolinaFlorida St.11at ClemsonMaryland11MichiganColorado11Southern CaliforniaKansas St.11West Virginia
64
Florida12UABFlorida St.12Delaware StateMaryland12at Michigan StateColorado12OFFKansas St.12at Oklahoma Stae
65
Florida13Florida StateFlorida St.13at FloridaMaryland13Penn StateColorado13at UtahKansas St.13Iowa State
66
Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)
67
Real Life Wins0Real Life Losses000Real Life Wins0Real Life Losses000Real Life Wins0Real Life Losses000Real Life Wins0Real Life Losses000Real Life Wins0Real Life Losses000
68
GeorgiaAug. 26--Georgia TechAug. 26--MichiganAug. 26--OregonAug. 26--OklahomaAug. 26--
69
Georgia1Appalachian StateGeorgia Tech1Tennessee (N)Michigan1Florida (N)Oregon1Southern UtahOklahoma1UTEP
70
Georgia2at Notre DameGeorgia Tech2Jacksonville StateMichigan2CincinnatiOregon2NebraskaOklahoma2at Ohio State
71
Georgia3SamfordGeorgia Tech3at UCFMichigan3Air ForceOregon3at WyomingOklahoma3Tulane
72
Georgia4Mississippi StateGeorgia Tech4PittsburghMichigan4at PurdueOregon4at Arizona StateOklahoma4at Baylor
73
Georgia5at TennesseeGeorgia Tech5North CarolinaMichigan5OFFOregon5CaliforniaOklahoma5OFF
74
Georgia6at VanderbiltGeorgia Tech6OFFMichigan6Michigan StateOregon6Washington StateOklahoma6Iowa State
75
Georgia7MissouriGeorgia Tech7at MiamiMichigan7at IndianaOregon7at StanfordOklahoma7Texas (N)
76
Georgia8OFFGeorgia Tech8Wake ForestMichigan8at Penn StateOregon8at UCLAOklahoma8at Kansas State
77
Georgia9Florida (N)Georgia Tech9at ClemsonMichigan9RutgersOregon9UtahOklahoma9Texas Tech
78
Georgia10South CarolinaGeorgia Tech10at VirginiaMichigan10MinnesotaOregon10at WashingtonOklahoma10at Oklahoma State
79
Georgia11at AuburnGeorgia Tech11Virginia TechMichigan11at MarylandOregon11OFFOklahoma11TCU
80
Georgia12KentuckyGeorgia Tech12at DukeMichigan12at WisconsinOregon12ArizonaOklahoma12at Kansas
81
Georgia13at Georgia TechGeorgia Tech13GeorgiaMichigan13Ohio StateOregon13Oregon StateOklahoma13West Virginia
82
Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)
83
Real Life Wins0Real Life Losses000Real Life Wins0Real Life Losses000Real Life Wins0Real Life Losses000Real Life Wins0Real Life Losses000Real Life Wins0Real Life Losses000
84
KentuckyAug. 26--LouisvilleAug. 26--Michigan St.Aug. 26--Oregon St.Aug. 26at Colorado StateOklahoma St.Aug. 26--
85
Kentucky1at Southern MissLouisville1Purdue (N)Michigan St.1Bowling GreenOregon St.1Portland StateOklahoma St.1Tulsa
86
Kentucky2Eastern KentuckyLouisville2at North CarolinaMichigan St.2Western MichiganOregon St.2MinnesotaOklahoma St.2at South Alabama
87
Kentucky3at South CarolinaLouisville3ClemsonMichigan St.3OFFOregon St.3at Washington StateOklahoma St.3at Pittsburgh
88
Kentucky4FloridaLouisville4Kent StateMichigan St.4Notre DameOregon St.4OFFOklahoma St.4TCU
89
Kentucky5Eastern MichiganLouisville5Murray StateMichigan St.5IowaOregon St.5WashingtonOklahoma St.5at Texas Tech
90
Kentucky6MissouriLouisville6at NC StateMichigan St.6at MichiganOregon St.6at Southern CaliforniaOklahoma St.6OFF
91
Kentucky7OFFLouisville7Boston CollegeMichigan St.7at MinnesotaOregon St.7ColoradoOklahoma St.7Baylor
92
Kentucky8at Mississippi StateLouisville8at Florida StateMichigan St.8IndianaOregon St.8OFFOklahoma St.8at Texas
93
Kentucky9TennesseeLouisville9at Wake ForestMichigan St.9at NorthwesternOregon St.9StanfordOklahoma St.9at West Virginia
94
Kentucky10Ole MissLouisville10OFFMichigan St.10Penn StateOregon St.10at CaliforniaOklahoma St.10Oklahoma
95
Kentucky11at VanderbiltLouisville11VirginiaMichigan St.11at Ohio StateOregon St.11at ArizonaOklahoma St.11at Iowa State
96
Kentucky12at GeorgiaLouisville12SyracuseMichigan St.12MarylandOregon St.12Arizona StateOklahoma St.12Kansas State
97
Kentucky13LouisvilleLouisville13at KentuckyMichigan St.13at RutgersOregon St.13at OregonOklahoma St.13Kansas
98
Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)Projected Wins0Projected Losses0Your Record (Correct)Your Record (Wrong)
99
Real Life Wins0Real Life Losses000Real Life Wins0Real Life Losses000Real Life Wins0Real Life Losses000Real Life Wins0Real Life Losses000Real Life Wins0Real Life Losses000
100
LSUAug. 26--Miami (FL)Aug. 26--MinnesotaAug. 26--Southern CaliforniaAug. 26--TCUAug. 26--
Loading...
 
 
 
Copy of Sheet1