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: The data is pulled by % Rostered / Owned instead of Projections. This is to try to catch any players that fall through the cracks. Quarterback pick sixes are now included! A better algorithm to catch the players with suffixes on their names that make matching data from different sources difficult

Read More…

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

Read More…

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

Read More…

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

Read More…

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

Read More…

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

Read More…

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

Read More…

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

Read More…

Home Articles posted by Victor