Predict the Season Competition - Deadline 9/4/2009

Status
Not open for further replies.
Thanks for doing this, Rick!

DATE ....... OPPONENT ............ ....... ....... Winner
09/05 ....... Syracuse (away) .......Gophers
09/12 ....... Air Force .......Gophers
09/19 ....... California .......California
09/26 ....... Northwestern (away) .......Gophers
10/03 ....... Wisconsin .......Wisconsin
10/10 ....... Purdue .......Gophers
10/17 ....... Penn State (away) .......Penn State
10/24 ....... Ohio State (away) .......Ohio State
10/31 ....... Michigan State .......Michigan State
11/07 ....... Illinois .......Gophers
11/14 ....... South Dakota State .......Gophers
11/21 ....... Iowa (away) .......Iowa
....... ....... ....... Gopher score against Iowa: ___14______
 

DATE ....... OPPONENT ............ ....... ....... Winner
09/05 ....... Syracuse (away) ....... GOPHERS
09/12 ....... Air Force ....... GOPHERS
09/19 ....... California ....... Cal
09/26 ....... Northwestern (away) ....... Gophers
10/03 ....... Wisconsin ....... GOPHERS
10/10 ....... Purdue ....... GOPHERS
10/17 ....... Penn State (away) ....... Penn St
10/24 ....... Ohio State (away) ....... Ohio St
10/31 ....... Michigan State ....... Michigan St
11/07 ....... Illinois ....... GOPHERS
11/14 ....... South Dakota State ....... GOPHERS
11/21 ....... Iowa (away) ....... Iowa
....... ....... ....... Gopher score against Iowa: ___20___
 

DATE ....... OPPONENT ............ ....... ....... Winner
09/05 ....... Syracuse (away) US.......
09/12 ....... Air Force ....... US
09/19 ....... California ....... THEM
09/26 ....... Northwestern (away) ....... US
10/03 ....... Wisconsin ....... US
10/10 ....... Purdue ....... US
10/17 ....... Penn State (away) ....... THEM
10/24 ....... Ohio State (away) ....... THEM
10/31 ....... Michigan State ....... US
11/07 ....... Illinois ....... US
11/14 ....... South Dakota State ....... US
11/21 ....... Iowa (away) ....... THEM
....... ....... ....... Gopher score against Iowa: ___23______
 

DATE ....... OPPONENT ............ ....... ....... Winner
09/05 ....... Syracuse (away) .... Gophers
09/12 ....... Air Force ....... Gophers
09/19 ....... California ....... Cal
09/26 ....... Northwestern (away) ....... Gophers
10/03 ....... Wisconsin ....... Gophers
10/10 ....... Purdue ....... Gophers
10/17 ....... Penn State (away) ....... Penn State
10/24 ....... Ohio State (away) ....... Ohio State
10/31 ....... Michigan State ....... Gophers
11/07 ....... Illinois ....... Illinois
11/14 ....... South Dakota State ....... Gophers
11/21 ....... Iowa (away) ....... Gophers
....... ....... ....... Gopher score against Iowa: ___27______
 

For every consecutive game you guess correctly you get a bonus. So if you're on a streak you build points faster than someone who is more hit-and-miss. For someone on a 2-game streak, they get 1 bonus point for guessing that second game correctly. For someone on a 3-game streak they get a +2 on top of the 3 points for guessing the third game correctly and so on.

Let me reiterate this way:
Guess a game right--> 1 game win streak--> +3 points to the previous total
Guess the next game--2 game win streak--> +4 points to the previous total
Guess third game right-->3 game streak--> +5 points to the previous total
Fourth game guessed right--> +6 points to the previous total
And so on...

It's an intriguing idea. The major problem I have with it is the complexity of administering it. I'm using an Excel spreadsheet, and in order to make it work, I'd have to write a set of "nested" Booleian calculations in order to calculate each week's score correctly as we get deeper into the season.

I'll noodle it over and figure out if there's a way I can make it work without spending a lot of time (and gnashing of teeth). ;) Or maybe I can short-circuit the nested formulae by setting up subordinate tables where the first table is that week's game and the second table is a "bonus" table that looks at preceding game(s).

We've got about 50 or so entries and I'd assume we might get another 20-30 by the deadline. Just keeping the "normal" scoring correct can be a PITA for me -- and the bonus concept, while intriguing, complicates the score-keeping and violates the first principle of running these things: KISS! But thanks for the idea -- like I say, I'll think some more about it and see if there's a way I can figure to do it easily.
 


DATE ....... OPPONENT ............ ....... ....... Winner
09/05 ....... Syracuse (away) ....... Gophers
09/12 ....... Air Force ....... Gophers
09/19 ....... California ....... Cal
09/26 ....... Northwestern (away) ....... Gophers
10/03 ....... Wisconsin ....... Gophers
10/10 ....... Purdue ....... Gophers
10/17 ....... Penn State ....... Gophers
10/24 ....... Ohio State (away) ....... Ohio State
10/31 ....... Michigan State ....... Gophers
11/07 ....... Illinois ....... Illinois
11/14 ....... South Dakota State ....... Gophers
11/21 ....... Iowa (away) ....... Iowa
....... ....... ....... Gopher score against Iowa: __10_______
 

DATE ....... OPPONENT ............ ....... ....... Winner
09/05 ....... Syracuse (away) ....... Gophers
09/12 ....... Air Force ....... Gophers
09/19 ....... California ....... Cal
09/26 ....... Northwestern (away) ....... Gophers
10/03 ....... Wisconsin ....... Gophers
10/10 ....... Purdue ....... Gophers
10/17 ....... Penn State ....... PSU
10/24 ....... Ohio State (away) ....... Ohio State
10/31 ....... Michigan State ....... Gophers
11/07 ....... Illinois ....... Gophers
11/14 ....... South Dakota State ....... Gophers
11/21 ....... Iowa (away) ....... Iowa
....... ....... ....... Gopher score against Iowa: __20_______
 

I hope its better than this.

DATE ....... OPPONENT ............ ....... ....... Winner
09/05 ....... Syracuse (away) ....... Gophers
09/12 ....... Air Force ....... Gophers
09/19 ....... California ....... Cal
09/26 ....... Northwestern (away) ....... NU
10/03 ....... Wisconsin ....... WI
10/10 ....... Purdue ....... Gophers
10/17 ....... Penn State (away) ....... Lions
10/24 ....... Ohio State (away) ....... Bucs
10/31 ....... Michigan State ....... MSU
11/07 ....... Illinois ....... Gophers
11/14 ....... South Dakota State ....... Gophers
11/21 ....... Iowa (away) ....... UI
....... ....... ....... Gopher score against Iowa: _19_______
 

DATE ....... OPPONENT ............ ....... ....... Winner
09/05 ....... Syracuse (away) .......Gophers
09/12 ....... Air Force .......Gophers
09/19 ....... California .......Cal
09/26 ....... Northwestern (away) .......Gophers
10/03 ....... Wisconsin .......Gophers
10/10 ....... Purdue .......Gophers
10/17 ....... Penn State (away) .......Penn State
10/24 ....... Ohio State (away) .......Ohio State
10/31 ....... Michigan State .......Gophers
11/07 ....... Illinois .......Gophers
11/14 ....... South Dakota State .......Gophers
11/21 ....... Iowa (away) .......Gophers
....... ....... ....... Gopher score against Iowa: ____31-24_____
 



DATE ....... OPPONENT ............ ....... ....... Winner
09/05 ....... Syracuse (away) ....... Gophers
09/12 ....... Air Force ....... Gophers
09/19 ....... California ....... Gophers
09/26 ....... Northwestern (away) ....... Gophers
10/03 ....... Wisconsin ....... Wisconsin
10/10 ....... Purdue ....... Gophers
10/17 ....... Penn State (away) ....... Penn State
10/24 ....... Ohio State (away) ....... Ohio State
10/31 ....... Michigan State ....... Gophers
11/07 ....... Illinois ....... Gophers
11/14 ....... South Dakota State ....... Gophers
11/21 ....... Iowa (away) ....... Iowa
....... ....... ....... Gopher score against Iowa: __31__
 

DATE ....... OPPONENT ............ ....... ....... Winner
09/05 ....... Syracuse (away) .......Gophers
09/12 ....... Air Force .......Gophers
09/19 ....... California .......Cal
09/26 ....... Northwestern (away) .......Gophers
10/03 ....... Wisconsin .......Gophers
10/10 ....... Purdue .......Gophers
10/17 ....... Penn State (away) .......PSU
10/24 ....... Ohio State (away) .......OSU
10/31 ....... Michigan State .......Gophers
11/07 ....... Illinois .......Gophers
11/14 ....... South Dakota State .......Gophers
11/21 ....... Iowa (away) .......Iowa
....... ....... ....... Gopher score against Iowa: ___17______
 

DATE ....... OPPONENT ............ ....... ....... Winner
09/05 ....... Syracuse (away) ....... Gophers
09/12 ....... Air Force ....... Gophers
09/19 ....... California ....... Gophers
09/26 ....... Northwestern (away) ....... Gophers
10/03 ....... Wisconsin ....... Gophers
10/10 ....... Purdue ....... Gophers
10/17 ....... Penn State (away) ....... Penn State
10/24 ....... Ohio State (away) ....... Ohio State
10/31 ....... Michigan State ....... Gophers
11/07 ....... Illinois ....... Gophers
11/14 ....... South Dakota State ....... Gophers
11/21 ....... Iowa (away) ....... Iowa
....... ....... ....... Gopher score against Iowa: ___24______
 

DATE ....... OPPONENT ............ ....... ....... Winner
09/05 ....... Syracuse (away) ....... Gophers
09/12 ....... Air Force ....... Gophers
09/19 ....... California ....... Gophers
09/26 ....... Northwestern (away) ....... Gophers
10/03 ....... Wisconsin ....... Gophers
10/10 ....... Purdue ....... Gophers
10/17 ....... Penn State (away) ....... Pn St
10/24 ....... Ohio State (away) ....... Gophers
10/31 ....... Michigan State ....... Gophers
11/07 ....... Illinois ....... Gophers
11/14 ....... South Dakota State ....... Gophers
11/21 ....... Iowa (away) ....... Gophers
....... ....... ....... Gopher score against Iowa: __45__
 



DATE ....... OPPONENT ............ ....... ....... Winner
09/05 ....... Syracuse (away) ....... MN
09/12 ....... Air Force ....... MN
09/19 ....... California ....... CAL
09/26 ....... Northwestern (away) .......NW
10/03 ....... Wisconsin .......MN
10/10 ....... Purdue .......MN
10/17 ....... Penn State (away) .......PSU
10/24 ....... Ohio State (away) ....... OSU
10/31 ....... Michigan State ....... MSU
11/07 ....... Illinois ....... MN
11/14 ....... South Dakota State ....... MN
11/21 ....... Iowa (away) .......IA
....... ....... ....... Gopher score against Iowa: _17________
 

DATE ....... OPPONENT ............ ....... ....... Winner
09/05 ....... Syracuse (away) ....... GOPHERS
09/12 ....... Air Force ....... GOPHERS
09/19 ....... California ....... Cal
09/26 ....... Northwestern (away) ....... GOPHERS
10/03 ....... Wisconsin ....... GOPHERS
10/10 ....... Purdue ....... GOPHERS
10/17 ....... Penn State (away) ....... Penn St
10/24 ....... Ohio State (away) ....... Ohio St
10/31 ....... Michigan State ....... Michigan St
11/07 ....... Illinois ....... GOPHERS
11/14 ....... South Dakota State ....... GOPHERS
11/21 ....... Iowa (away) ....... Iowa
....... ....... ....... Gopher score against Iowa: ___20______
 

DATE ....... OPPONENT ............ ....... ....... Winner
09/05 ....... Syracuse (away) ....... MN
09/12 ....... Air Force ....... MN
09/19 ....... California ....... MN
09/26 ....... Northwestern (away) ....... MN
10/03 ....... Wisconsin ....... MN
10/10 ....... Purdue ....... MN
10/17 ....... Penn State (away) ....... psu
10/24 ....... Ohio State (away) ....... osu
10/31 ....... Michigan State ....... MN
11/07 ....... Illinois ....... MN
11/14 ....... South Dakota State ....... MN
11/21 ....... Iowa (away) ....... MN
....... ....... ....... Gopher score against Iowa: ___24____


I feel like we'll lose to someone we shouldnt early in the year but i just couldnt pick who...
 

DATE ....... OPPONENT ............ ....... ....... Winner
09/05 ....... Syracuse (away) ....... GOPHERS
09/12 ....... Air Force ....... GOPHERS
09/19 ....... California ....... GOPHERS
09/26 ....... Northwestern (away) ....... GOPHERS
10/03 ....... Wisconsin ....... GOPHERS
10/10 ....... Purdue ....... GOPHERS
10/17 ....... Penn State (away) ....... GOPHERS
10/24 ....... Ohio State (away) ....... Ohio State
10/31 ....... Michigan State ....... GOPHERS
11/07 ....... Illinois ....... GOPHERS
11/14 ....... South Dakota State ....... GOPHERS
11/21 ....... Iowa (away) ....... GOPHERS
....... ....... ....... Gopher score against Iowa: ___38______
 

DATE ....... OPPONENT ............ ....... ....... Winner
09/05 ....... Syracuse (away) ....... GOPHS
09/12 ....... Air Force ....... GOPHS
09/19 ....... California ....... CAL
09/26 ....... Northwestern (away) ....... GOPHS
10/03 ....... Wisconsin ....... GOPHS
10/10 ....... Purdue ....... GOPHS
10/17 ....... Penn State (away) ....... PSU
10/24 ....... Ohio State (away) ....... OSU
10/31 ....... Michigan State ....... MSU
11/07 ....... Illinois ....... GOPHS
11/14 ....... South Dakota State ....... GOPHS
11/21 ....... Iowa (away) ....... IOWA
....... ....... ....... Gopher score against Iowa: ___17______
 

DATE ....... OPPONENT ............ ....... ....... Winner
09/05 ....... Syracuse (away) ....... Gophers
09/12 ....... Air Force ....... Gophers
09/19 ....... California ....... Cal
09/26 ....... Northwestern (away) ....... Gophers
10/03 ....... Wisconsin ....... Gophers
10/10 ....... Purdue ....... Gophers
10/17 ....... Penn State (away) ....... Penn State
10/24 ....... Ohio State (away) ....... Ohio State
10/31 ....... Michigan State ....... Michigan State
11/07 ....... Illinois ....... Illinois
11/14 ....... South Dakota State ....... Gophers
11/21 ....... Iowa (away) .......Iowa
....... ....... ....... Gopher score against Iowa: 17
 

DATE ....... OPPONENT ............ ....... ....... Winner
09/05 ....... Syracuse (away) ....... GOPHERS
09/12 ....... Air Force ....... GOPHERS
09/19 ....... California ....... GOPHERS
09/26 ....... Northwestern (away) ......GOPHERS
10/03 ....... Wisconsin ....... GOPHERS
10/10 ....... Purdue ....... GOPHERS
10/17 ....... Penn State (away) ....... PENN STATE
10/24 ....... Ohio State (away) ....... OHIO STATE
10/31 ....... Michigan State ....... GOPHERS
11/07 ....... Illinois ....... GOPHERS
11/14 ....... South Dakota State ....... GOPHERS
11/21 ....... Iowa (away) ....... GOPHERS
....... ....... ....... Gopher score against Iowa: 28
 


DATE ....... OPPONENT ............ ....... ....... Winner
09/05 ....... Syracuse (away) .......Gophers
09/12 ....... Air Force .......Gophers
09/19 ....... California .......Gophers
09/26 ....... Northwestern (away) .......Gophers
10/03 ....... Wisconsin .......Gophers
10/10 ....... Purdue .......Gophers
10/17 ....... Penn State (away) .......Penn St
10/24 ....... Ohio State (away) .......Ohio St
10/31 ....... Michigan State .......Mich St
11/07 ....... Illinois .......Illinois
11/14 ....... South Dakota State .......Gophers
11/21 ....... Iowa (away) .......Iowa
....... ....... ....... Gopher score against Iowa: ____14_____
 

DATE ....... OPPONENT ............ ....... ....... Winner
09/05 ....... Syracuse (away) ....... GOPHERS
09/12 ....... Air Force ....... GOPHERS
09/19 ....... California ....... Cal
09/26 ....... Northwestern (away) .......Northwestern
10/03 ....... Wisconsin ....... GOPHERS
10/10 ....... Purdue ....... GOPHERS
10/17 ....... Penn State (away) .......PSU
10/24 ....... Ohio State (away) ....... OSU
10/31 ....... Michigan State ....... MSU
11/07 ....... Illinois ....... Illinois
11/14 ....... South Dakota State .......GOPHERS
11/21 ....... Iowa (away) ....... Iowa
....... ....... ....... Gopher score against Iowa: 35-17_________
 

DATE ....... OPPONENT ............ ....... ....... Winner
09/05 ....... Syracuse (away) ....................GOPHERS
09/12 ....... Air Force ...............................GOPHERS
09/19 ....... California ...............................Cal
09/26 ....... Northwestern (away) ...............GOPHERS
10/03 ....... Wisconsin ..............................GOPHERS
10/10 ....... Purdue ..................................GOPHERS
10/17 ....... Penn State (away) ..................GOPHERS
10/24 ....... Ohio State (away) ..................Ohio State
10/31 ....... Michigan State .......................GOPHERS
11/07 ....... Illinois ...................................Illinois
11/14 ....... South Dakota State ................GOPHERS
11/21 ....... Iowa (away) ..........................Iowa
....... ....... ....... Gopher score against Iowa: 20
 

DATE ....... OPPONENT ............ ....... ....... Winner
09/05 ....... Syracuse (away) .......MN
09/12 ....... Air Force .......mn
09/19 ....... California .......cal
09/26 ....... Northwestern (away) .......mn
10/03 ....... Wisconsin .......wi
10/10 ....... Purdue .......mn
10/17 ....... Penn State (away) .......penn state
10/24 ....... Ohio State (away) .......ohio state
10/31 ....... Michigan State .......michigan state
11/07 ....... Illinois .......mn
11/14 ....... South Dakota State .......mn
11/21 ....... Iowa (away) .......iowa
....... ....... ....... Gopher score against Iowa: _13________
 

DATE ....... OPPONENT ............ ....... ....... Winner
09/05 ....... Syracuse (away) ....................GOPHERS
09/12 ....... Air Force ...............................GOPHERS
09/19 ....... California ...............................GOPHERS
09/26 ....... Northwestern (away) ...............GOPHERS
10/03 ....... Wisconsin ..............................GOPHERS
10/10 ....... Purdue ..................................GOPHERS
10/17 ....... Penn State (away) ..................PSU
10/24 ....... Ohio State (away) ..................OSU
10/31 ....... Michigan State .......................GOPHERS
11/07 ....... Illinois ...................................GOPHERS
11/14 ....... South Dakota State ................GOPHERS
11/21 ....... Iowa (away) ..........................Iowa
....... ....... ....... Gopher score against Iowa: 17
 

DATE ....... OPPONENT ............ ....... ....... Winner
09/05 ....... Syracuse (away) ....................GOPHERS
09/12 ....... Air Force .................................GOPHERS
09/19 ....... California ................................California
09/26 ....... Northwestern (away) .............GOPHERS
10/03 ....... Wisconsin ...............................GOPHERS
10/10 ....... Purdue ...................................GOPHERS
10/17 ....... Penn State (away) .................Penn State
10/24 ....... Ohio State (away) ..................Ohio State
10/31 ....... Michigan State .......................Michigan State
11/07 ....... Illinois ....................................GOPHERS
11/14 ....... South Dakota State ...............GOPHERS
11/21 ....... Iowa (away) ..........................GOPHERS
....... ....... ....... Gopher score against Iowa: 23
 

DATE ....... OPPONENT ............ ....... ....... Winner
09/05 ....... Syracuse (away) ....... Gophers
09/12 ....... Air Force .......Gophers
09/19 ....... California ....... California
09/26 ....... Northwestern (away) ....... Gophers
10/03 ....... Wisconsin ....... Gophers
10/10 ....... Purdue ....... Gophers
10/17 ....... Penn State (away) ....... Penn State
10/24 ....... Ohio State (away) ....... Ohio State
10/31 ....... Michigan State ....... Gophers
11/07 ....... Illinois ....... Illinois
11/14 ....... South Dakota State ....... Gophers
11/21 ....... Iowa (away) ....... Gophers
....... ....... ....... Gopher score against Iowa: __27___

Illinois and Iowa could easily flip flop bur I just can't pic Iowa
 

DATE ....... OPPONENT ............ ....... ....... Winner
09/05 ....... Syracuse (away) .......GOPHERS
09/12 ....... Air Force .......GOPHERS
09/19 ....... California .......California
09/26 ....... Northwestern (away) .......GOPHERS
10/03 ....... Wisconsin .......GOPHERS
10/10 ....... Purdue .......GOPHERS
10/17 ....... Penn State (away) .......Penn St
10/24 ....... Ohio State (away) .......Ohio St
10/31 ....... Michigan State .......Gophers
11/07 ....... Illinois .......Illinois
11/14 ....... South Dakota State .......Gophers
11/21 ....... Iowa (away) .......Iowa
....... ....... ....... Gopher score against Iowa: _____24____
 

Here is GoGopherRah's prediction (7-5 with a victorious trip to Tempe)

DATE ....... OPPONENT ............ ....... ....... Winner
09/05 ....... Syracuse (away) ....... Gophers
09/12 ....... Air Force ....... Gophers
09/19 ....... California ....... Cal
09/26 ....... Northwestern (away) ....... Gophers
10/03 ....... Wisconsin ....... Gophers
10/10 ....... Purdue ....... Gophers
10/17 ....... Penn State (away) ....... Penn State
10/24 ....... Ohio State (away) ....... Ohio State
10/31 ....... Michigan State ....... Gophers
11/07 ....... Illinois ....... Illinois
11/14 ....... South Dakota State ....... Gophers
11/21 ....... Iowa (away) ....... Iowa
....... ....... ....... Gopher score against Iowa: __32_______

oops, I changed it a bit because I realized it was EXACTLY the same as ZepplinGophers.
 

Status
Not open for further replies.



Top Bottom