Before I get to the table/spreadsheet and what it all means. I want to give you a little background on this “project”.
The purpose of this “project” was to use last season’s ADP comparative to the season’s ADP to find likely keepers. I used my handy-dandy site www.fantasyfootballcalculator.com to compare 2015 info to 2016 info and I was jotting down notes on my notepad. This player improved this many rounds, this player decreased this many rounds, etc. etc. etc.
Then my husband got involved.
My husband, God bless his soul, is an extremely intelligent man and oh-so helpful. He suggested I move all of the info to a google spreadsheet, and come up with a more precise comparison. Plus it would surely look more professional than all this chicken scratch I was currently working with. Okay, that doesn’t seem too bad.
Until I realized I had somehow copied and pasted wrong. Alright let’s delete all that info, and start over.
Then I had to go through and take out all the players from 2015 that were not being drafted, and all of the rookies being drafted in this seasons draft. Now my cells didn’t line up so that’s going to throw off my equation. I need to go through and tidy this up. By tidying, now my color coded lines don’t match up to player positions like they should, so I fix that.
Finally I have my values. I format the table to highlight the players who have had the most drastic increase in average draft position, but that’s just not enough. After tinkering I go a step further and feature all the players who not only increased their draft value but also offered you, the dedicated fantasy player, the most bang for your buck. How did I do this? By dividing their draft position increase by their current average draft round giving you their ultimate Fantasy Keeper Value.
2(+) hours later*, I am so glad that I took the easy way out. Thank you husband.
I sincerely hope that someone, somewhere out there finds this chart useful. Without further ado:
|2016 ADP||Player||Position||ADP Increase||FKV|
|4||Odell Beckham Jr||WR||11||2.75|
These are your top 18 keeper prospects based on trending ADP numbers. Of course, this is based on their Average Draft Position and not their Actual Draft Position. So if you took Antonio brown 1st overall he’s not going to have the same FKV (fantasy keeper value-another suggestion by my husband) as the chart suggests. But, it does give you a good idea of trending players, and a good smattering of fantasy prospects that I would suggest you at least consider keeping.
Some of my personal favorites are David Johnson, Dion Lewis, and Allen Hurns.
I hope this chart changes your life, as much as it changed mine.
*In my husbands defense, he is far better with mathematical analysis and chart building than I am. He expected this “project” to take me thirty minutes. He was wrong.