Fantasy Football Keepers: Finding Value Pt 2

Posted by

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
3 Todd Gurley RB 53 17.67
7 David Johnson RB 119 17.00
16 Jordy Nelson WR 204 12.75
22 Thomas Rawls RB 198 9.00
30 Kelvin Benjamin WR 190 6.33
17 Devonta Freeman RB 87 5.12
1 Antonio Brown WR 5 5.00
39 Jeremy Langford RB 181 4.64
40 Jordan Reed TE 180 4.50
47 Doug Baldwin WR 173 3.68
48 Dion Lewis RB 172 3.58
15 Allen Robinson WR 51 3.40
54 Jay Ajayi RB 166 3.07
8 DeAndre Hopkins WR 24 3.00
32 Cam Newton QB 88 2.75
4 Odell Beckham Jr WR 11 2.75
56 Allen Hurns WR 128 2.29
46 Matt Jones RB 93 2.02

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.

 

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s