FanPost

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.

X
Log In Sign Up

forgot?
Log In Sign Up

Forgot password?

We'll email you a reset link.

If you signed up using a 3rd party account like Facebook or Twitter, please login with it instead.

Forgot password?

Try another email?

Almost done,

Join Niners Nation

You must be a member of Niners Nation to participate.

We have our own Community Guidelines at Niners Nation. You should read them.

Join Niners Nation

You must be a member of Niners Nation to participate.

We have our own Community Guidelines at Niners Nation. You should read them.

Spinner

Authenticating

Great!

Choose an available username to complete sign up.

In order to provide our users with a better overall experience, we ask for more information from Facebook when using it to login so that we can learn more about our audience and provide you with the best possible experience. We do not store specific user data and the sharing of it is not required to login with Facebook.

tracking_pixel_9341_tracker