| Sign Up | Google+

Excel-based Draft Value Calculator for the group

I built some Lookup formulas in XLS so that we can crunch any trade evaluations as they come up for the draft. Feel free to download it - the first tab is where you enter pick numbers to evaluate trades - tab 8 lists the picks by team (excl. compensatory picks that can't be traded).

I tried to embed the calculator in HTML and put it on a blog, but that failed.


I also have calculators for the Schuckers Model, which bases draft value on actual player performance -- 1991-2001 drafts vs. player performance through 2010 (data from pro-football focus). I also built a 'mixed model' that averages the Schuckers model with the traditional model.


Enjoy.


https://docs.google.com/file/d/0B2Eu1DDN514kSW0xa3RjeHJpakE/edit?usp=sharing


Also, if you want to nerd-out on this, below is the link to Schuckers' journal paper on the subject.


http://statsportsconsulting.com/main/wp-content/uploads/Schuckers_JQAS_NFL_Draft.pdf


                                                                                                                                                                                                               

This is a FanPost and does not necessarily reflect the views of Niners Nation's writers or editors. It does reflect the views of this particular fan though, which is as important as the views of Niners Nation's writers or editors.

Recent FanPosts

View All Fan Posts

The Next FanPosts

There are 2 Comments. Load Now. Loading

Shortcuts to mastering the comment thread. Use wisely.

C - Next Comment
X - Mark as Read

R - Reply
Z - Mark Read & Next

Shift + C - Previous
Shift + A - Mark All Read

Comment Settings

Live comment alert: Hide it!

Comments for this post are closed.

tracking_pixel_5341_tracker tracking_pixel_5351_tracker