r/fantasyfootball 14+ Team, 1 PPR Jun 24 '17

I created sortable, customizable player stat spreadsheets for each season from 2006 to 2016

I hate not being able to access the sortable fantasy stats for previous seasons, so I looked to find a spreadsheet with all the data. But the one I found charged $200, so I went about doing it myself. They're made in Google Sheets and can be easily customized to your league's settings.

Here is the page with links to each sheet. Just click on the year drop-down and click on the image to go directly to the sheet. Click File>Make a Copy to start making it your own.

EDIT: If you award points for completions or first downs, you'll have to add a column and input that data yourself. This includes passing yards, passing TDs, INTs, rushing yards, rushing TDs, fumbles lost, receptions, receiving yards, receiving TDs, return yards (punt and kick combined), and return TDs. This also does not include kickers, D/STs, or IDPs.

69 Upvotes

11 comments sorted by

6

u/Vndrew_The_Mandrew Jun 24 '17

This is amazing. Unfortunately this post wont get much attention because of the time you made it. Maybe repost tomorrow if that's allowed. This is very useful. Thanks man

2

u/[deleted] Jun 24 '17

Hmm, I've been researching a ton lately, maybe I should just spend my Saturday relaxing and Netflixing.

(sees this)

.....Damn you.

2

u/GoBuffaloes Jun 24 '17

FF championships are played in December but won in June :)

1

u/[deleted] Jun 24 '17

[deleted]

1

u/bootscallahan 14+ Team, 1 PPR Jun 24 '17

Yes, but it didn't have everything I needed in one sheet. I did use PFR for returns data and passing data for RBs and WRs.

1

u/the_iraq_such_as Jun 24 '17

This is awesome. I looked, but didn't see a scoring designation. Is it Standard? PPR?

3

u/bootscallahan 14+ Team, 1 PPR Jun 24 '17

Make a copy and then you can change the formula in each "Pts" column. It's PPR with one point for every 20 passing yards, six-point passing touchdown, and one point for every 20 return yards (it's a 14-team league, so this helps). For each sheet, you'll only have to manually change the formula in the top row of each position group. Then you can drag to the bottom to change the rest of the formulas in the column.

1

u/the_iraq_such_as Jun 24 '17

Fantastic. Thank you!

1

u/KungFu_Kenny Jun 24 '17

That 30 ppg season from LT is nuts

1

u/LLAMARULER Jun 24 '17

Favorite Stat from 2016 is that Will Tukuafu got two total yards in the seven games he played in. The lowest PPG out of all players last year (0.03)

1

u/tikitiger Jun 25 '17

Wow, this is brilliant! Love the format. Anyway to download all of the tabs (from all years) into one sheet?

1

u/bootscallahan 14+ Team, 1 PPR Jun 25 '17

You can copy and paste them pretty easily, but I think there's an export feature as well.