FanPost

UDFAs that Da Bears should target!

(Editor's note: Promoted to the front page)

What started out as a mini-project of gauging the various mocks accuracy, ended up showing some extremely talented UFDAs that Da Bears should target.

These are the ten UDFAs and after the jump, I will explain how I ended up with these players.

  1. Chris  L. Rucker, CB
  2. Kristofer O'Dowd, OC
  3. Zach Hurd, OG
  4. Terrance Toliver, WR
  5. DeAndre McDaniel, SS
  6. Chas Henry, P
  7. Tim Barnes, OC
  8. Josh Bynes, ILB
  9. David Mims, OT
  10. Deunta Williams, SS

In the uploaded Excel sheet here, there are three worksheets: DraftStatus, UDFA and Bears. DraftStatus contains the draftboards from 4 of my favorite mock sites: NFP (Wes Bunting)http://www.sbnation.com/javascripts/vendor/tiny_mce_3_0_7/plugins/pagebreak/img/trans.gif, Mocking the Draft (Dan Kadar), DrafTek and ProFootballWeekly. Then I added the actual draft as it turned out. By each mock, in the column "Picked", there is a simple Vlookup formula to the draft which returns the actual pick right next to where the mock had him ranked. This allowed me to easily locate players that went undrafted.

Additionally, by the actual draft I added a column for each mock, and again using the Vlookup, I was able to see how each pick was graded by the various mocks. An additional column averaged out the rankings from the four mocks which was then subtracted from the actual rank to receive some sort of value/reach number. For example, our own Gabe Carimi was averaged to be picked in the 21st spot and went at 29 so this pick was a +8. Chris Conte who wasn't supposed to be picked at all by NFP didn't even receive a value. (this has to be fixed when there will be time). But what clearly shows is that James Carpenter was the biggest reach in the 1st round, and that Jonas Mouton was even a bigger shocker than Chris Conte.

A note of warning is that if any of the mocks spelled a name different than the others or than the Draft itself, the formula won't do it's job. If anyone notices it, please comment and I will fix it when I can.

The UDFA worksheet then takes all the non drafted players and lined them up per ranking. If a player was ranked differently by different mocks, only the higher ranking was left. I also played a little with the positions as the different mocks had the same player at different positions. I only took positions that in my opinion are of interest to the Bears – no QB and no TE.

In the Bears worksheet, I picked based on grading and position of need who I think the Bears should go after strongly to sign and tryout.

<em>This FanPost was written by a Windy City Gridiron member, and does not necessarily reflect the ideas or opinions of its staff or community.</em>

X
Log In Sign Up

forgot?
Log In Sign Up

Please choose a new SB Nation username and password

As part of the new SB Nation launch, prior users will need to choose a permanent username, along with a new password.

Your username will be used to login to SB Nation going forward.

I already have a Vox Media account!

Verify Vox Media account

Please login to your Vox Media account. This account will be linked to your previously existing Eater account.

Please choose a new SB Nation username and password

As part of the new SB Nation launch, prior MT authors will need to choose a new username and password.

Your username will be used to login to SB Nation going forward.

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,

By becoming a registered user, you are also agreeing to our Terms and confirming that you have read our Privacy Policy.

Join Windy City Gridiron

You must be a member of Windy City Gridiron to participate.

We have our own Community Guidelines at Windy City Gridiron. You should read them.

Join Windy City Gridiron

You must be a member of Windy City Gridiron to participate.

We have our own Community Guidelines at Windy City Gridiron. You should read them.

Spinner.vc97ec6e

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