# NFL Yardage Pool competition **URL:** \ **Category:** The Game Room\ **Created:** [September 9, 2009, 3:22am UTC](https://boards.straightdope.com/t/nfl-yardage-pool-competition/509386 "2009-09-09T03:22:49Z")\ **Posts on this page:** 20\ **Page:** 8
**Author:** ![Wilson](https://avatars.discourse-cdn.com/v4/letter/w/96bed5/32.png) [@Wilson](https://boards.straightdope.com/u/Wilson)\ **Post date:** [October 25, 2009, 4:36pm UTC](https://boards.straightdope.com/t/nfl-yardage-pool-competition/509386/141 "2009-10-25T16:36:58Z")
Just in time this week - Tony Romo, Matt Forte, Roddy White. ---
**Author:** ![Omniscient](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/omniscient/32/3290_2.png) [@Omniscient](https://boards.straightdope.com/u/Omniscient)\ **Post date:** [October 25, 2009, 9:04pm UTC](https://boards.straightdope.com/t/nfl-yardage-pool-competition/509386/142 "2009-10-25T21:04:44Z")
I officially hate the rule that RBs only get credit for rushing yards. Screens are completely useless in this league and that’s what it seems like 50% of RBs do these days. ---
**Author:** ![notfrommensa](https://avatars.discourse-cdn.com/v4/letter/n/f14d63/32.png) [@notfrommensa](https://boards.straightdope.com/u/notfrommensa)\ **Post date:** [October 26, 2009, 2:17am UTC](https://boards.straightdope.com/t/nfl-yardage-pool-competition/509386/143 "2009-10-26T02:17:11Z")
Week 7 Passing - Brett Favre MIN – 334 Rushing - Ryan Grant CHI (Green Bay) – 148 Receiving - Andre Johnson HOU – 62 544 yds I somewhat screwed up my running back pick again this week. I chose Ryan Grant but I labelled his team as the Bears instead of the Packers. Mea Culpa. At this time, I am taking the yardages that Ryan Grant of the Packers rushed for. FWIW, I checked roster of the Bears, there is no Ryan Grant on their team. Moderator, do what you have to do, but I did intend my RB to be Ryan Grant of the Packers. (and I desperately need yardage by my running back.) ---
**Author:** ![SenorBeef](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/senorbeef/32/2220_2.png) [@SenorBeef](https://boards.straightdope.com/u/SenorBeef)\ **Post date:** [October 26, 2009, 4:01am UTC](https://boards.straightdope.com/t/nfl-yardage-pool-competition/509386/144 "2009-10-26T04:01:22Z")
> [@](#): > > Moderator, do what you have to do, but I did intend my RB to be Ryan Grant of the Packers. (and I desperately need yardage by my running back.) I’m not a moderator, I’m just the guy who organized this game. But yeah, your yards will count - it’s clear it was a little honest mistake so that’s fine. When dropping the lowest score, should I drop the lowest combined score for the person’s lowest scoring weak, or drop the lowest RB/WR/QB score of the season individually? To someone who missed one week it makes no difference. ---
**Author:** ![lieu](https://avatars.discourse-cdn.com/v4/letter/l/c2a13f/32.png) [@lieu](https://boards.straightdope.com/u/lieu)\ **Post date:** [October 26, 2009, 12:07pm UTC](https://boards.straightdope.com/t/nfl-yardage-pool-competition/509386/145 "2009-10-26T12:07:44Z")
> [@SenorBeef](#): > > … lowest scoring weak… You got that right. Philip Rivers - 268 DeAngelo Williams - 89 Randy Moss - 69 Total Week 7 - **426** ---
**Author:** ![Really\_Not\_All\_That\_Bright](https://avatars.discourse-cdn.com/v4/letter/r/e8c25b/32.png) [@Really\_Not\_All\_That\_Bright](https://boards.straightdope.com/u/Really_Not_All_That_Bright)\ **Post date:** [October 26, 2009, 3:14pm UTC](https://boards.straightdope.com/t/nfl-yardage-pool-competition/509386/146 "2009-10-26T15:14:56Z")
> [@Really\_Not\_All\_That\_Bright](#): > > Anyway, on with my Week 7 lineup: > [del]Matt Hasselbeck, Santonio Holmes, Cedric Benson, Kurt Warner, Clinton Portis, Andre Johnson, Matt Schaub, Ryan Grant, Reggie Wayne, Kerry Collins, Darren McFadden, Jerricho Cotchery, Tony Romo, Rashard Mendenhall, Roddy White, Tom Brady, Maurice Jones-Drew, Nate Burleson[/del] > Ben Roethlisberger > Thomas Jones > Wes Welker 175 + 121 + 107 = **403**. By far my worst week QB-wise, but otherwise solid. > [@SenorBeef](#): > > When dropping the lowest score, should I drop the lowest combined score for the person’s lowest scoring weak, or drop the lowest RB/WR/QB score of the season individually? To someone who missed one week it makes no difference. I was under the impression you’d drop the lowest scoring week, rather than the lowest scoring position weeks, but I guess I’m okay with either method. It’ll actually help me out if we do the position thing, because that way I get rid of that -5 week by McFadden without dumping the rather good QB and WR performances that went with it. ---
**Author:** ![Omniscient](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/omniscient/32/3290_2.png) [@Omniscient](https://boards.straightdope.com/u/Omniscient)\ **Post date:** [October 26, 2009, 4:37pm UTC](https://boards.straightdope.com/t/nfl-yardage-pool-competition/509386/147 "2009-10-26T16:37:00Z")
> [@Omniscient](#): > > Used Players: > QB - Carson Palmer, Joe Flacco, Eli Manning, Matt Schaub, Mark Sanchez > RB - Thomas Jones, Ryan Grant, Cedric Benson, Ronnie Brown, Maurice Jones-Drew > WR - Marques Colston, Roy Williams, Santonio Holmes, Larry Fitzgerald, Wes Welker > > **Week 7:** > QB - Ben Roethlisberger > RB - Donald Brown > WR - Roddy White > > Taking a gamble at RB this week, we’ll see how that pans out. Week 7 Scores: 175 + 58 + 50 = 283 Yuck. Things were looking up before Brown got hurt and Big Ben wasn’t helped by those defensive scores. ---
**Author:** ![Wilson](https://avatars.discourse-cdn.com/v4/letter/w/96bed5/32.png) [@Wilson](https://boards.straightdope.com/u/Wilson)\ **Post date:** [October 26, 2009, 5:06pm UTC](https://boards.straightdope.com/t/nfl-yardage-pool-competition/509386/148 "2009-10-26T17:06:21Z")
> [@Wilson](#): > > Just in time this week - > Tony Romo, Matt Forte, Roddy White. That’s 311 + 24 + 50 = 385. I stink at this - I think I’ve picked one WR all year that’s had a good game. ---
**Author:** ![notfrommensa](https://avatars.discourse-cdn.com/v4/letter/n/f14d63/32.png) [@notfrommensa](https://boards.straightdope.com/u/notfrommensa)\ **Post date:** [October 26, 2009, 5:58pm UTC](https://boards.straightdope.com/t/nfl-yardage-pool-competition/509386/149 "2009-10-26T17:58:59Z")
> [@SenorBeef](#): > > Raw totals. I wasn’t going to drop the lowest score until the end of the year because due to the spreadsheet method I’m using I would have to delete and re-add data as someone’s lowest week changed. > > However, if anyone who knows Excel better than me knows a way I can program the formula to drop the lowest score, I’ll implement that. Omni method can work, but I think this is simpler: =SUM(Range)-Min(Range) ---
**Author:** ![lieu](https://avatars.discourse-cdn.com/v4/letter/l/c2a13f/32.png) [@lieu](https://boards.straightdope.com/u/lieu)\ **Post date:** [October 29, 2009, 12:29pm UTC](https://boards.straightdope.com/t/nfl-yardage-pool-competition/509386/150 "2009-10-29T12:29:14Z")
[del]Joe Flacco, Aaron Rodgers, Drew Brees, Peyton Manning, Matt Schaub, Donovan McNabb, Philip Rivers Thomas Jones, Adrian Peterson, Brandon Jacobs, Chris Johnson, Rashard Mendenhall, Cedric Benson, DeAngelo Williams Marques Colston, Terrell Owens, Reggie Wayne, Santana Moss, Mohammed Massaquoi, Larry Fitzgerald, Randy Moss[/del] Week 8 Tony Romo Steven Jackson Miles Austin ---
**Author:** ![Really\_Not\_All\_That\_Bright](https://avatars.discourse-cdn.com/v4/letter/r/e8c25b/32.png) [@Really\_Not\_All\_That\_Bright](https://boards.straightdope.com/u/Really_Not_All_That_Bright)\ **Post date:** [October 29, 2009, 3:46pm UTC](https://boards.straightdope.com/t/nfl-yardage-pool-competition/509386/151 "2009-10-29T15:46:44Z")
Week 8: [del]Matt Hasselbeck, Santonio Holmes, Cedric Benson, Kurt Warner, Clinton Portis, Andre Johnson, Matt Schaub, Ryan Grant, Reggie Wayne, Kerry Collins, Darren McFadden, Jerricho Cotchery, Tony Romo, Rashard Mendenhall, Roddy White, Tom Brady, Maurice Jones-Drew, Nate Burleson, Ben Roethlisberger, Thomas Jones, Wes Welker[/del] David Garrard Kevin Smith Steve Smith (CAR) ---
**Author:** ![notfrommensa](https://avatars.discourse-cdn.com/v4/letter/n/f14d63/32.png) [@notfrommensa](https://boards.straightdope.com/u/notfrommensa)\ **Post date:** [October 29, 2009, 5:27pm UTC](https://boards.straightdope.com/t/nfl-yardage-pool-competition/509386/152 "2009-10-29T17:27:24Z")
Weeks 1-7 (so I don’t repeat) [del]Passing - Tom Brady, Kyle Orton, Joe Flacco, Jay Cutler, Peyton Manning, Matt Schaub, Brett Favre Rushing - Reggie Bush, Ray Rice, Ray Rice, Chris Johnson, Adrian Petersen, Cedric Benson, Ryan Grant Receiving - Terrell Owen, Tim Hightower, Dallas Clark, Reggie Wayne, Steve Smith (NYG) , T.J. Houshmandzadeh, Andre Johnson [/del] Week 8 Passing - Philip Rivers SD Rushing - Thomas Jones NYJ Receiving - Antonio Gates SD I think I got the teams correct this week. Have our standings been updated? I think I made up some ground this week. ---
**Author:** ![Really\_Not\_All\_That\_Bright](https://avatars.discourse-cdn.com/v4/letter/r/e8c25b/32.png) [@Really\_Not\_All\_That\_Bright](https://boards.straightdope.com/u/Really_Not_All_That_Bright)\ **Post date:** [October 29, 2009, 5:34pm UTC](https://boards.straightdope.com/t/nfl-yardage-pool-competition/509386/153 "2009-10-29T17:34:30Z")
You made up a ton on me - 155 yards. ---
**Author:** ![notfrommensa](https://avatars.discourse-cdn.com/v4/letter/n/f14d63/32.png) [@notfrommensa](https://boards.straightdope.com/u/notfrommensa)\ **Post date:** [October 29, 2009, 5:39pm UTC](https://boards.straightdope.com/t/nfl-yardage-pool-competition/509386/154 "2009-10-29T17:39:41Z")
I’ll take the 155 yds but I think it is 141 yds I posted 544 yds and you posted 403 yds. ---
**Author:** ![Really\_Not\_All\_That\_Bright](https://avatars.discourse-cdn.com/v4/letter/r/e8c25b/32.png) [@Really\_Not\_All\_That\_Bright](https://boards.straightdope.com/u/Really_Not_All_That_Bright)\ **Post date:** [October 29, 2009, 5:58pm UTC](https://boards.straightdope.com/t/nfl-yardage-pool-competition/509386/155 "2009-10-29T17:58:18Z")
Fine, you win at mathematics too! :smack: ---
**Author:** ![SenorBeef](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/senorbeef/32/2220_2.png) [@SenorBeef](https://boards.straightdope.com/u/SenorBeef)\ **Post date:** [October 31, 2009, 4:55am UTC](https://boards.straightdope.com/t/nfl-yardage-pool-competition/509386/156 "2009-10-31T04:55:01Z")
Got it [updated](http://members.cox.net/senorbeef/SDMByardagecomp.htm) along with the new “adjusted total” line on the bottom. That’s the official score - that takes into account dropping a player’s worst weekly score. Week 7 scores: 1. notfrommensa 544 2. Varlos 466 3. Lieu 426 4. RNATB 406 5. SenorBeef 391 6. Wilson 385 7. Omniscient 283 As of now, the overall standings are: 1. RNATB 3076 2. Lieu 2662 3. notfrommensa 2615 4. VarlosZ 2578 5. Wilson 2520 6. Omni 2482 7. Anyone who isn’t participating in this 0 8. SenorBeef 2096 Yes, I’m actually doing worse off than everyone who chose not to play. For my next trick, I was hoping to add sorted lists of who’s leading in each category (passing, rushing, receiving). So along the bottom right we’d have rows labelled Pass/Rush/Rec, and each column would be the player who had the most score in that category (and their score), then the next highest player, etc. Each category would have a different sorting, since people have different rankings within the different categories. Is there any way to do this with excel? ---
**Author:** ![Really\_Not\_All\_That\_Bright](https://avatars.discourse-cdn.com/v4/letter/r/e8c25b/32.png) [@Really\_Not\_All\_That\_Bright](https://boards.straightdope.com/u/Really_Not_All_That_Bright)\ **Post date:** [October 31, 2009, 5:15am UTC](https://boards.straightdope.com/t/nfl-yardage-pool-competition/509386/157 "2009-10-31T05:15:10Z")
I hear NBC is considering calling the competition for me before the polls close 😉 ---
**Author:** ![SenorBeef](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/senorbeef/32/2220_2.png) [@SenorBeef](https://boards.straightdope.com/u/SenorBeef)\ **Post date:** [October 31, 2009, 5:18am UTC](https://boards.straightdope.com/t/nfl-yardage-pool-competition/509386/158 "2009-10-31T05:18:21Z")
Don’t make me pull out the big guns. I’ll start picking whoever you pick each week, knowing that it’ll make quarterbacks lose 2/3rds of their yardage, and then you will get crushed by Lieu and mensa. Edit: This made it occur to me that we could have an issue at the end where if one person leads the competition, they could mirror the picks of the closest competitor thereby preventing them from being overtaken. It’s a pretty cheap tactic and I doubt anyone here will do it, but if it becomes an issue we could finish the year by submitting secret PMs I suppose. ---
**Author:** ![notfrommensa](https://avatars.discourse-cdn.com/v4/letter/n/f14d63/32.png) [@notfrommensa](https://boards.straightdope.com/u/notfrommensa)\ **Post date:** [October 31, 2009, 3:14pm UTC](https://boards.straightdope.com/t/nfl-yardage-pool-competition/509386/159 "2009-10-31T15:14:03Z")
By the time we get to the later weeks, options (especially QBs) are going to be compromised. Edit: How did **RNATB** get an extra 3 yds last week? ---
**Author:** ![Really\_Not\_All\_That\_Bright](https://avatars.discourse-cdn.com/v4/letter/r/e8c25b/32.png) [@Really\_Not\_All\_That\_Bright](https://boards.straightdope.com/u/Really_Not_All_That_Bright)\ **Post date:** [October 31, 2009, 5:48pm UTC](https://boards.straightdope.com/t/nfl-yardage-pool-competition/509386/160 "2009-10-31T17:48:55Z")
> [@SenorBeef](#): > > Edit: This made it occur to me that we could have an issue at the end where if one person leads the competition, they could mirror the picks of the closest competitor thereby preventing them from being overtaken. It’s a pretty cheap tactic and I doubt anyone here will do it, but if it becomes an issue we could finish the year by submitting secret PMs I suppose. That’s why I’ve been making a point of posting my picks in the middle of the week - didn’t want anyone accusing me of playing defense. [Previous page](https://boards.straightdope.com/t/nfl-yardage-pool-competition/509386.md?page=7) [Next page](https://boards.straightdope.com/t/nfl-yardage-pool-competition/509386.md?page=9)