So, for this year's contest, I'm going all-out with keeping track of this thing. As soon as picks come in, I put the picks in an Excel table that kinda sorta looks like this:
Attachment:
NFL Picks Contest Setup.png [ 116.26 KiB | Viewed 6613 times ]
I have it set up that when I put the winner of the games in the bottom row with the Matchup/Winner in it, the boxes of the people who got the matchups right will light up green, while the ones who got it wrong stay red (I can't get it to stay clear when there's nothing in the "winner" box; someone more astute with Excel could possibly help out with this, because that would be flipping awesome.) At the end of the week, I'll tally up the number of green boxes and the number of red boxes (I was hoping there was a way for Excel to do this automatically; again people more astute, yadda yadda) and place them in the corresponding wins and losses column for the week. The totals will transfer into the Wins Total and Losses Total columns, and will carry over to the other sheets week-to-week. There's a Standings sheet that helps with this, too.
So, this is just a peek as to how I'm working the Standings this season, and rest assured, the results and standings posts will be accurate this year.
