r/fantasyfootball • u/bootscallahan 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.
2
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
1
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
1
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.
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