2010 NFL Mock Draft Creator Spreadsheet..

Beerfish · 02-08-2010, 09:08 PM

Here is my 2010 Mock Draft Creator Spreadsheet. Some of you may remember the sheet from previous years. (I’ve created these sheets each of the last 4 or 5 years). As a refresher here are some of the features of the spreadsheet.

Features:

Over 1500 players (Name, Position, Height, Weight, College) ranked by averaging various player rankings on the net.

Ability to view by specific player position.

Team statistical rankings from this past year (Passing, running, against the pass, against the run)

List of players who will be attending the NFL combine and combine results. (The players are listed but their numbers will obviously not be filled in until after the combine.)

Draft Point Value Chart (For estimating value of specific draft positions for trades.)

Easy to use, just put the number where you think a player will be picked next to his name on the Player Data page and it fills in his position on your mock draft page. The final draft position list won’t be until coin flips are held to determine some ties in draft order (usually takes place at the combine) and after compensatory picks are awarded (late March if I recall)

Ability to filter the mock draft page to only include the picks for the team you cheer for.

Here is the link to download the spreadsheet: (bottom of the page orange download button)

[url]http://www.sendspace.com/file/2axubt[/url]

hatnlvr · 02-08-2010, 10:10 PM

Great spreadsheet (man must of took you a ton of time)! Thanks for posting.

Beerfish · 02-08-2010, 11:07 PM

[QUOTE=hatnlvr;3495468]Great spreadsheet (man must of took you a ton of time)! Thanks for posting.[/QUOTE]

I'm getting much more efficient at the info gathering info and the spreadsheet itself is basically the same the last few years.

10PennyToColes87 · 02-09-2010, 10:32 PM

Thanks Fish (from BG) ;)

Jets Things · 02-10-2010, 12:23 AM

Why did I get a video of Sammy Case repeatedly getting a D rammed in his A when I clicked download?

long island leprechaun · 02-10-2010, 07:04 AM

Thanks, Beerfish. Your spreadsheet is a work of art. Much appreciated.

PatS4 · 02-25-2010, 02:15 PM

Thanks Beerfish!!
Great tool!!
I basically stalked you from the
Titans board to find it this year.

jetswin · 02-25-2010, 02:19 PM

spreadsheet is blocked here at work, but I assume a bunch of work went into it, so I'll leave it here instead of moving to draft forum.

You should post it in there as well, those guys will like it. :cool:

Beerfish · 02-25-2010, 03:03 PM

I did post it there as well. The reason I posted it here as well as the draft forum is that this forum gets a fair bit more traffic and it might encourage more people to head to the draft forum if they had this tool to help them out.

I will be updating it after the combine and then probably just after compensatory picks are awarded.

02-08-2010, 09:08 PM	#1
Beerfish Hall Of Fame Join Date: Aug 2004 Posts: 19,066	2010 NFL Mock Draft Creator Spreadsheet.. Here is my 2010 Mock Draft Creator Spreadsheet. Some of you may remember the sheet from previous years. (I’ve created these sheets each of the last 4 or 5 years). As a refresher here are some of the features of the spreadsheet. Features: Over 1500 players (Name, Position, Height, Weight, College) ranked by averaging various player rankings on the net. Ability to view by specific player position. Team statistical rankings from this past year (Passing, running, against the pass, against the run) List of players who will be attending the NFL combine and combine results. (The players are listed but their numbers will obviously not be filled in until after the combine.) Draft Point Value Chart (For estimating value of specific draft positions for trades.) Easy to use, just put the number where you think a player will be picked next to his name on the Player Data page and it fills in his position on your mock draft page. The final draft position list won’t be until coin flips are held to determine some ties in draft order (usually takes place at the combine) and after compensatory picks are awarded (late March if I recall) Ability to filter the mock draft page to only include the picks for the team you cheer for. Here is the link to download the spreadsheet: (bottom of the page orange download button) [url]http://www.sendspace.com/file/2axubt[/url]

02-08-2010, 10:10 PM	#2
hatnlvr Jets Fan for Life! All Pro Join Date: Jul 2004 Posts: 5,267	Great spreadsheet (man must of took you a ton of time)! Thanks for posting.

02-08-2010, 11:07 PM	#3
Beerfish Hall Of Fame Join Date: Aug 2004 Posts: 19,066	[QUOTE=hatnlvr;3495468]Great spreadsheet (man must of took you a ton of time)! Thanks for posting.[/QUOTE] I'm getting much more efficient at the info gathering info and the spreadsheet itself is basically the same the last few years.

02-09-2010, 10:32 PM	#4
10PennyToColes87 Hall Of Fame Join Date: May 2005 Location: SoFla Posts: 15,374	Thanks Fish (from BG) ;)

02-10-2010, 12:23 AM	#5
Jets Things All Pro Join Date: May 2003 Location: 742 Evergreen Terrace Posts: 9,405	Why did I get a video of Sammy Case repeatedly getting a D rammed in his A when I clicked download?

02-10-2010, 07:04 AM	#6
long island leprechaun Don't mess with Angel Eyes. All Pro Join Date: Jan 2006 Location: greenwich village, NYC Posts: 7,221	Thanks, Beerfish. Your spreadsheet is a work of art. Much appreciated.

02-25-2010, 02:15 PM	#7
PatS4 Cheesehead Waterboy Join Date: Feb 2010 Posts: 1	Thanks Beerfish!! Great tool!! I basically stalked you from the Titans board to find it this year.

02-25-2010, 02:19 PM	#8
jetswin stumblin mumblin butt fumblin Board Moderator Jets Insider VIP JetsInsider.com Legend Charter JI Member Join Date: May 1999 Location: Westchester Co. Posts: 35,461	spreadsheet is blocked here at work, but I assume a bunch of work went into it, so I'll leave it here instead of moving to draft forum. You should post it in there as well, those guys will like it. :cool:

02-25-2010, 03:03 PM	#9
Beerfish Hall Of Fame Join Date: Aug 2004 Posts: 19,066	I did post it there as well. The reason I posted it here as well as the draft forum is that this forum gets a fair bit more traffic and it might encourage more people to head to the draft forum if they had this tool to help them out. I will be updating it after the combine and then probably just after compensatory picks are awarded.