Twitter RSS

Updated 2013 / 2014 Spreadsheet with GP

Published on August 20, 2014, by in NFL.

I’ve just uploaded a major update to the stats spreadsheet with the following additions:

  • Games Played & Games Started in 2013
  • Updated Projections from Yahoo and FantasyPros
  • New players in the top 300
  • Ranking changes since June 19
  • See the full change log for more

A commentor asked about updating their customized version of the June spreadsheet. I’ve updated the stats without changing player order so no VLOOKUP / MATCH functions are needed, but this results in some players on IR remaining on the list.

As usual, email me any feedback or post in the comments!
And if you find any value in this sheet, please share, tweet this, and subscribe!

I’ve also removed all ads, and will never have them again, I’ve realized for the few dollars it barely makes, it’s just not worth it.
Thanks for all the kind words in the comments, and good luck with your draft!

Get the stats spreadsheet here: 2013 NFL Historical Stats w/ 2014 Projections.


New Season, New Spreadsheet!

Published on June 28, 2014, by in NFL.

What better way to celebrate the summer long weekends than getting a head start on fantasy football prep?

The offensive projected stats for 2014 are now up along with full 2013 season stats. This is the earliest I’ve ever got the offensive spreadsheet out, as I’m getting tired of procrastinating. 🙂 Rankings & IDP stats to come…

Two new stats this year: QB sacks taken and total fumbles. This is in addition to all the goodies you’re used to such as links to Yahoo! player profiles, customizable scoring settings and more!

Also updates will be much more reliable, as I’ve written a macro to automate the periodic updating of the stats. If you like it, please share, tweet, email, subscribe! Thanks!

See the full page and get the spreadsheet here: 2014 NFL Historical Stats with Projections.


Stats Spreadsheet Final Update with GP, Bye, Projection Change

Published on August 28, 2013, by in NFL.

This will be the last major update to the fantasy stats spreadsheet for the year.

Thank you for all the feedback, I hope you find this update useful!

New in this final version:

  • Added Games Played in 2012 and PPG calculation
  • Added Bye Weeks per player
  • Added Projection change. Shows a green or red icon (in Excel 2010+ only)
  • Updated Yahoo, Standard & PPR Projections

Get it here:

If you find any errors, please let me know by email or in the comments! Thanks for the support, and happy drafting! We’ll still be writing articles throughout the year!


6 Mock Draft Observations

Published on August 24, 2013, by in NFL.

With the start of the season just two weeks away, dedicated managers will be neckbeard-deep in player news and updates so that come draft day, they’ll take their league by storm. Mock drafts are an excellent way to get a sneak peak on what you might expect on the big day. Here are a few observations and tips that may come in handy for you when you draft.

Read more…


IDP Stats Spreadsheet Updated for 2013

Published on August 14, 2013, by in NFL.

The IDP (Individual Defensive Player) Stats Spreadsheet has been updated with 2012 historical stats and 2013 rankings.

What’s new this year?

  • 2013 IDP Rankings (Standard & PPR) from two sources
  • Tackle for Loss stats

This is in addition to some of the popular features from last year’s original Excel workbook with:

  • Games Played to calculate Points Per Game (PPG) (target players returning from major injuries)
  • Rankings by Position
  • Customize with your own league’s scoring settings
  • Links to Yahoo! Player Profiles

Click here for the IDP rankings spreadsheet

The old 2011 / 2012 stats are archived here.



2013 Fantasy Football Spreadsheets Updated

Published on August 2, 2013, by in NFL.

The offensive stats have been updated with 2013 projected data and 2012 actual stats, so you can now do your own analysis from the 2012 season!

IDP stats are coming soon, but I wanted to get this out before the weekend as I’ve had a lot of requests from people planning their upcoming fantasy season!

This Excel workbook has:

  • 2013 Projected Fantasy Stats (Offense)
  • 2012 Historical NFL Stats
  • Ability to enter your own league’s scoring settings!
  • Links to Player Profiles on Yahoo! Sports
  • Filter by position
  • Create your own notes
  • NFL Schedule Grid and Bye Week Quick Reference
  • Strength of Schedule

If you find this useful, leave a comment as we’re always curious how other poolies use this data! And if you have any suggestions, let us know!

Take me to the free fantasy football spreadsheets!

(Looking for last year’s stats? 2012 stats are archived here)


NFL Draft Board Updated for 2013

Published on July 21, 2013, by in NFL.

On draft day, are you still using pen and paper to track your picks?
Download our free Excel spreadsheet to use during your live draft.

Reasons why an automated draft board will help you on Draft Day:

  • Don’t let a value pick slide past the round you have targeted by keeping a watch list every round.
  • Keep track of your positions left to fill.
  • Help avoid drafting several players with the same bye week.
  • Enter your league settings, and the draft order and pick #’s are auto calculated.
  • Get a quick glance at playoff weeks 14-16 strength of schedules for quick draft day decisions.

Click here to get it!


NFL Wild Card Week Predictions

Published on January 5, 2013, by in NFL.

My predictions for the Super Bowl and four Wild Card match-ups this weekend:

Cincinnati at Houston (-4.5) 1/5/2013 4:30p ET NBC
My Pick: Texans 23-17

A month ago the Texans were 11-1 and the Super Bowl favorite. But after a drubbing to the Patriots and losses to the Vikings and Colts to finish the season, many are picking the Bengals for an upset.

Winners of 7 of their last 8, Cincinnati will be a good young team for many years to come but their lack of depth at receiver behind AJ Green means they will need to establish the run on a stout Texans D and JJ Watt, my vote for NFL defensive player of the year. Look for Schaub to get another big day out of Andre Johnson, and the consistent Arian Foster to find pay dirt twice.

Minnesota at Green Bay (-7.5)  1/5/2013 8:00p ET NBC
My Pick: Packers 34-20

As incredible as Adrian Peterson has been in carrying the Vikings on his back, I can’t see Green Bay not learning from last week’s loss to Minnesota, and this week they’re at home. The focus all week must have been on team tackling, so expect the Packers to limit AP to 150 yards (is that limiting?) and forcing Ponder to beat them through the air, which he won’t. Rodgers to Jordy Nelson and NFL touchdown leader James Jones all day.

Read more…