Twitter RSS
formats

2021 NFL Offensive Stats Spreadsheet Released

Published on August 28, 2021, by in NFL.

What a wild last couple of years! Besides the world turning upside-down (or right-side up some could say?), on a personal note I’ve moved to a new town and have made some big professional and personal changes. But you’re here for the data!

I’ve made two changes this year:

  1. The data is pulled by % Rostered / Owned instead of Projections. This is to try to catch any players that fall through the cracks.
  2. Quarterback pick sixes are now included!
  3. A better algorithm to catch the players with suffixes on their names that make matching data from different sources difficult (I’m talking about you, Melvin Gordon III).

And all the usual features you’ve come to love are included:

  • Links to Player Profiles.
  • Fully customizable stats to enter your pool’s scoring settings.
  • PPG (points per game) calculation – great for finding steals like players coming off injury or players with sneaky return yards if your pool counts those.

The Draft Board Tool has also been updated, and the pages for bye weeks and schedules will be updated soon but I didn’t want to hold up this spreadsheet so I’ll release it first:

2021 NFL Stats Spreadsheet

I missed last year and I apologize to all those looking for this data. Thanks for sticking with me!
Look out for an IDP update and possibly one more update before kickoff on September 9th.

formats

Final Update for 2019/20 NFL Season, New Rankings

Published on August 24, 2019, by in NFL.

It’s week 4 of the NFL preseason, and before I head on a camping trip I’ve squeezed in time to make one final update before the season kicks off.

All the rankings have been updated, but use the Std and PPR columns from FantasyPros, as is usual Yahoo’s projections aren’t updated in a timely manner (they get them from Rotowire). What’s most interesting is comparing the changes in FantasyPros rankings from last week (Aug 16 update) to this week.

Other notes:

  • The Player Notes (i.e. injury status) updated.
  • Player links fixed. Thanks for those who gave the time to report errors.
  • The Actuals tab had different Y Rankings from the Projected tab. That’s just how Yahoo does it, which doesn’t make sense, so I’ve removed that.
  • Yahoo rankings have been capped at 400, FantasyPros at 300. I’d normalize them all to 300 or 400, but I ran out of time for that 0.5% of you who have drafts that run that deep.

Get the final spreadsheet here: 2019 NFL Stats Spreadsheet

Enjoy the year!

formats

2019 NFL Offensive Stats Spreadsheet Released

Published on August 16, 2019, by in NFL.

The stats spreadsheet for the 2019/20 NFL season is now ready for download with stat projections for the upcoming 2019 season and detailed historical actuals from 2018, in Excel format.

The format remains the same as last year. Note that rookies do not appear on the 2018 tab, the sorting changed, and some free agents have been manually added (projections for these can vary widely from 0 to over ambitious).

Since pools are getting larger, I’ve included 100 more players. And as in previous years, the rankings have been normalized so unranked players get a 400 (previously 300). This should help with the larger pools I’ve been seeing out there. Kickers and defense excluded again.

The spreadsheet includes all the features you’ve come to know and love like player profile links, detailed stats (i.e. first downs and targets), fully customizable scoring settings, and pre-formatted notes fields. Yahoo! projections are used, based on Rotowire, so take them with a grain of salt, and have been painstakingly cross-referenced to FantasyPros’ default “expert consensus” ratings with standard and PPR scoring rankings. This is quite the chore with all the players with abbreviations after their name like “Jr” or “II” or “IV” in the case of Willie Snead. For Excel nerds, it’s conditionally formatted down to row 1000, but number formats only go down to 500 to keep the file size small.

Find out more about the spreadsheet here: 2019 NFL Stats Spreadsheet

The handy Draft Board Tool and downloadable NFL schedule grid have also been updated for the upcoming season.

These workbooks take much time to prepare, so if they’ve saved you any time in your draft prep, I’d love a share on a forum like reddit, or twitter, donate using the link on the right, or simply leave a comment showing your support. Happy pooling!

formats

The 2018 NFL Stats Spreadsheet is Here!

Published on August 20, 2018, by in NFL.

The stats spreadsheet for the 2017/18 NFL season is now available, with projected stats for 2018 and detailed historical actuals from the 2017 season in Excel format.

For those familiar with these spreadsheets, little has changed from last year. I stuck to a basic Yahoo! dump with little intervention other than adding two free agents, while normalizing all rankings to max out at 300 for the delta columns, including almost 400 offensive players, excluding kickers and defense.

As always, the spreadsheet includes Yahoo! projections (not the best) and FantasyPros default “expert consensus” ratings for standard and PPR scoring. And then there’s all the features you’ve come to know and love like player profile links, detailed stats (i.e. first downs and targets), fully customizable scoring settings, and pre-formatted customizable fields for your own notes.

Find out more about the spreadsheet here: 2018 NFL Stats Spreadsheet

The handy Draft Board Tool and downloadable NFL schedule grid have also been updated for the upcoming season.

These workbooks take much time to prepare, so if they’ve saved you any time in your draft prep, I’d love a share on a forum like reddit, or twitter, donate using the link on the right, or simply leave a comment showing your support. Happy pooling!

formats

September 1st Projections & Rankings Update

Published on September 1, 2017, by in NFL.

The spreadsheet has been updated with September 1 data. Changes:

  • Projected 2017 stats from Yahoo*
  • Standard & PPR ECR Rankings from Fantasy Pros
  • Change in Rankings (Fantasy Pros is the most useful)
  • Injury Status (Q/O/Susp/PUP)

Go to the stats spreadsheet permalink.

* Next year other sources for projections will be considered, because Yahoo keeps altering their website (likely to prevent data scraping) and their projections (via Rotowire) are rarely updated. For example, only a handful of players have different stats compared to the August 22nd projections, and a glaring omission is that Games Played shows 16 for all players, despite suspensions and injury updates, and few players had any stat updates.

Note: This will be the final update of the season.

formats

August 22 Update – Offensive Projections and Rankings

Published on August 22, 2017, by in NFL.

Preseason week 2 is in the books, so it’s a good time to update the NFL offensive stats spreadsheet for those with early fantasy draft dates.

The spreadsheet has these updates with August 22 data:

  • Projected stats from Yahoo.
  • Standard & PPR ECR Rankings from Fantasy Pros
  • NFL Injury Status (Q/O/Susp/PUP)
  • Strength of Schedule

Go to the stats spreadsheet permalink.

For those who are curious, Yahoo! changed their website again, making this update more time consuming than it should have been! I’ve also removed the prior rankings (so no delta/change will appear) because Yahoo’s projected rankings were all over the place, but I will add them in the next update after the weekend. The next update will come after the weekend.

formats

2017 NFL Historical and Projected Stats Spreadsheet

Published on August 10, 2017, by in NFL.

Is it August already? It took a little longer than usual, but the first stats spreadsheet for the 2017/18 NFL season is now available.

There are no changes from last year, but in an effort to get it this out quicker, the first version only includes Yahoo! rankings. Yes, Yahoo! projections aren’t the best (whose are?), but I know many are still on Yahoo! leagues (as well as ESPN, CBS, and Fox), but they’re still a good source for scraping detailed actual stats.

As usual, the spreadsheet includes links to Yahoo! player profiles, customizable scoring settings and projections. IDP stats will be updated in a week, as I’m swamped at the moment.

Get the new Excel workbook here: 2017 NFL Historical Stats with Projections

I’ve also updated the Draft Board Tool and update the updated and downloadable NFL schedule grid (with the two renamed LA teams) and bye weeks.

As promised, this site is ad-free and will stay that way. It takes a lot of time to put these sheets together, so if you find it useful, buy me a coffee via PayPal, or share this on reddit or twitter means a lot.

formats

IDP 2015 Historical Stats & 2016 Projections Added

Published on August 30, 2016, by in NFL.

The IDP (Individual Defensive Players) spreadsheet has been uploaded! Gathering data and updating these spreadsheets is time consuming but I finally set aside a few hours to get the data for you.

    Features:

  • Detailed player positions broken down by LB/DT/DL/CB/S and LB/DL/DB
  • Detailed stats including Tackle for Loss, PD, Return Yards, Turnover Yards
  • Custom rankings with formulas that auto-rank by position
  • Games Played and Points Per Game (PPG) Analysis & Rankings Formula

Note: This will be the only update for the IDP sheet. As in previous years, it only contains historical stats from 2015 as projections are difficult.

Open data for all!

Get the IDP historical stats spreadsheet here:
IDP 2015 Historical Stats Spreadsheet w/ 2016 Rankings