billryan
Joined: Nov 2, 2009
• Posts: 7395
February 2nd, 2019 at 10:35:23 AM permalink
Quote: SOOPOO

Yes, to make money. Second purpose is to find out what happens to that prop if there is no field goal. Will the person who picked the lowest yardage win the bet? Or does that bet become a tie for all participants?

Bullshit.
gordonm888
Joined: Feb 18, 2015
• Posts: 1758
February 2nd, 2019 at 10:45:42 AM permalink
Only 2 of my 20 answers agreed with Nathan. Who has the most Nathan matches? Least?
Sometimes, people are just a bottomless mystery. And, after all, this is just a sh*tty little forum in the sun-less backwaters of the online world.
EdCollins
Joined: Oct 21, 2011
• Posts: 1038
Thanks for this post from:
February 2nd, 2019 at 10:51:31 AM permalink
Quote: SOOPOO

Yes, to make money. Second purpose is to find out what happens to that prop if there is no field goal. Will the person who picked the lowest yardage win the bet? Or does that bet become a tie for all participants?

If there are no field goals at all, Keeneone will be dancing a jig as he is the only one that answered "0 total field goals" for Prop #6. As for the answer to longest field goal (Prop #16), if there are no field goals, I suspect that would have to be 0 points for everyone.
EdCollins
Joined: Oct 21, 2011
• Posts: 1038
Thanks for this post from:
February 2nd, 2019 at 11:10:32 AM permalink
I put together a spreadsheet of everyone's picks. Please review it for accuracy.

Enter the correct answers to each prop in the appropriate cell, and the spreadsheet will automatically determine everyone's score and the overall winner. (100 points divided equally among all those with the correct answer.)

http://www.edcollins.com/wizard_super_bowl_53_prop_bet_challenge.xlsx

I expect this spreadsheet can be improved upon, as I just threw it together in a few minutes. Assuming I put it together correctly, it should make the job of grading the Prop Bet Challenge very easy.

If my spreadsheet is correct, my max score is 134.467. (That's my score if I answered every prop correctly.)
charliepatrick
Joined: Jun 17, 2011
• Posts: 1654
February 2nd, 2019 at 12:21:18 PM permalink
Great work - many thanks. Sadly mine is only 97.

btw there are some "Yes" "No" "TD" "FG" with additional blanks depending on how you check the results these may not matchup. How I found these was because I wanted the average and COUNTIF of each column with the possible votes and they weren't all 47 (ignoring some numeric entries that are ??).

Interestingly if the average or favourite results come in there's a tie for first place. Also that the average for longest field goal (46) and touchdown (45.826) are so similar.
Correct
Prop
1PatsWinning team
2TailsWill the coin toss land on heads or tails?
356Total points
46Margin of victory
57Total number of touchdowns
63Total number of field goals
7PatsTeam to score first
8PatsTeam to score last
9YesWill the team to score first win?
10TDFirst score (TD, FG, or safety)
11TDLast score (TD, FG, or safety)
12NoWill there be a safety?
13NoWill the game go into overtime?
14NoWill there be a successful two-point conversion?
15NoWill there be a failed field goal attempt?
1646Longest field goal
1746Longest touchdown
18NoWill there be a defensive or special teams touchdown?
19NoWill the total points be a prime number?
2016Total Scrabble points in the last name of the first player to score a touchdown.
EdCollins
Joined: Oct 21, 2011
• Posts: 1038
February 2nd, 2019 at 12:45:14 PM permalink
Quote: charliepatrick

Great work - many thanks. Sadly mine is only 97.

btw there are some "Yes" "No" "TD" "FG" with additional blanks depending on how you check the results these may not matchup.

Good work! Yes, I found those extra spaces in some of the answers. I believe I've removed them all. If you downloaded the spreadsheet within the past 90 minutes, you will need to download it again. (Look for Version 2.0)
Wizard
Joined: Oct 14, 2009
• Posts: 19981
February 2nd, 2019 at 12:48:26 PM permalink
Quote: SOOPOO

I will lay 100-1 odds for a \$10 bet that Nathan does not win the contest.

I'll take it!

Quote:

(Longest field goal of 10 yards.... if there is no field goal what happens?)

Nobody gets any points for that one.
It's not whether you win or lose; it's whether or not you had a good bet.
Wizard
Joined: Oct 14, 2009
• Posts: 19981
February 2nd, 2019 at 12:50:22 PM permalink
Quote: billryan

Bullshit.

Warning -- profanity.
It's not whether you win or lose; it's whether or not you had a good bet.
Wizard
Joined: Oct 14, 2009
• Posts: 19981
February 2nd, 2019 at 12:52:08 PM permalink
Quote: EdCollins

I put together a spreadsheet of everyone's picks.

Thank you! I'd like to nominate you to be the official scorekeeper. In the event of a dispute, I'd be happy to advise.
It's not whether you win or lose; it's whether or not you had a good bet.
djatc
Joined: Jan 15, 2013