Go Back   Houston Texans Message Board & Forum - TexansTalk.com > Football Talk > College Football & the 2014 NFL Draft
Home Forums Register FAQDonate Automatic Monthly Contribution Members List Mark Forums Read


College Football & the 2014 NFL Draft The future stars of the NFL

Reply
 
Thread Tools Display Modes
Old 04-14-2010   #1
keyser
Hall of Fame
 
Join Date: Sep 2006
Posts: 1,276
Rep Power: 19314 keyser is a quality contributor and well respectedkeyser is a quality contributor and well respectedkeyser is a quality contributor and well respectedkeyser is a quality contributor and well respectedkeyser is a quality contributor and well respectedkeyser is a quality contributor and well respectedkeyser is a quality contributor and well respectedkeyser is a quality contributor and well respectedkeyser is a quality contributor and well respectedkeyser is a quality contributor and well respectedkeyser is a quality contributor and well respected
Default Draft Spreadsheet

Some of you might remember that I put together a Draft Spreadsheet (in Excel) last year. I've done the same this year, although I have not had (and probably won't have) the time to go through it in detail to clean it up, as I have in the past.

I have a Single Sheet spreadsheet that is probably the easiest to use.

I also have the Full spreadsheet that has the raw data in it.

If I update these, I'll post the most recent versions there. (Actually, I converted both from .xlsx to .xls, so hopefully there were no problems...)

The way I use this on draft day is to add a new column near the front that is the position actually selected. I then fill in the pick number as people are chosen. You can always resort to find the "best" remaining players.

Some details:
  • I pulled information from five sites, from last Friday through today. All are publicly available sites: NFL.com, NFLDraftScout.com, Scout.com, SI.com, and NationalFootballPost.com.
  • If you look at the full spreadsheet, the first sheet is the one used to make the single sheet, and aggregates other data. Each of the websites then has one sheet with raw data, and another sheet with processed data. Sheet 12 contains some weights for how to combine the 5 rankings. You should, in theory, be able to update the raw data (though I had to make some hand modifications) and everything else update.
  • Two of the websites give overall rankings, while three give grades. For the graded websites, I assigned a ranking based on the grades (tied score gives tied ranking).
  • The overall ranking on the single sheet was an average of four of the websites' rankings. I did not include NationalFootballPost in the average, since it was very different from the others. If you get the full spreadsheet, you can change the weights on page 12 to weight the values relative to each other.
  • The list of players on the first sheet/single sheet is taken from NFLDraftScout.com, since they had, by far, the largest list. However, some of the sites have other names that might not appear. I haven't had the time to go through and add other players that are on other websites but not on NFLDraftScout - if someone makes a list, please let me know, so that I can add it.
  • Some websites have different spellings of names (e.g. "Joe" vs. "Joseph") that makes the spreadsheet miss the player in the search. I tried to correct by hand for the top 200 or so, but I am sure I missed some players, especially at higher numbers. Again, if you notice problems, please let me know.
  • Note that in the full spreadsheet, a couple of the raw data sheets include hyperlinks to the website information about players (not for SI.com, although it is on the SI website). I usually found this more annoying than helpful, though.

No promises that things are accurate or not messed up. Again, I'd like to eventually post a "clean" version of the spreadsheet, but I doubt I'll have the time to fix it up enough in the mean time. I hope others will find this useful.
keyser is offline   Reply With Quote
Old 04-14-2010   #2
76Texan
Hall of Fame
 
76Texan's Avatar
 
Join Date: Dec 2006
Posts: 13,500
Rep Power: 81730 76Texan is a quality contributor and well respected76Texan is a quality contributor and well respected76Texan is a quality contributor and well respected76Texan is a quality contributor and well respected76Texan is a quality contributor and well respected76Texan is a quality contributor and well respected76Texan is a quality contributor and well respected76Texan is a quality contributor and well respected76Texan is a quality contributor and well respected76Texan is a quality contributor and well respected76Texan is a quality contributor and well respected
Default Re: Draft Spreadsheet

Very nice!

You have some duplicates though.
76Texan is offline   Reply With Quote
Old 04-14-2010   #3
The Pencil Neck
Hall of Fame
 
The Pencil Neck's Avatar
 
Join Date: Apr 2006
Location: Dallas, TX
Age: 52
Posts: 17,469
Rep Power: 218645 The Pencil Neck is a quality contributor and well respectedThe Pencil Neck is a quality contributor and well respectedThe Pencil Neck is a quality contributor and well respectedThe Pencil Neck is a quality contributor and well respectedThe Pencil Neck is a quality contributor and well respectedThe Pencil Neck is a quality contributor and well respectedThe Pencil Neck is a quality contributor and well respectedThe Pencil Neck is a quality contributor and well respectedThe Pencil Neck is a quality contributor and well respectedThe Pencil Neck is a quality contributor and well respectedThe Pencil Neck is a quality contributor and well respected
Default Re: Draft Spreadsheet

Quote:
Originally Posted by 76Texan View Post
Very nice!

You have some duplicates though.
Like he said, these aren't spotlessly cleaned up versions.
The Pencil Neck is offline   Reply With Quote
Old 04-14-2010   #4
Dutchrudder 
COOL BEANS!
 
Dutchrudder's Avatar
 
Join Date: Jan 2010
Location: Houston
Section: Fort Kickass
Age: 30
Posts: 15,063
Rep Power: 150980 Dutchrudder is a quality contributor and well respectedDutchrudder is a quality contributor and well respectedDutchrudder is a quality contributor and well respectedDutchrudder is a quality contributor and well respectedDutchrudder is a quality contributor and well respectedDutchrudder is a quality contributor and well respectedDutchrudder is a quality contributor and well respectedDutchrudder is a quality contributor and well respectedDutchrudder is a quality contributor and well respectedDutchrudder is a quality contributor and well respectedDutchrudder is a quality contributor and well respected
Default Re: Draft Spreadsheet

Good sheet! Repped for effort!
__________________
Life is too important to be taken seriously. -Oscar Wilde
Dutchrudder is offline   Reply With Quote
Old 04-15-2010   #5
drs23 
Veteran
 
drs23's Avatar
 
Join Date: Mar 2010
Location: No more VIP Suite so back to the recliner
Section: No more VIP suite so back to the recliner
Age: 57
Posts: 4,380
Rep Power: 77871 drs23 is a quality contributor and well respecteddrs23 is a quality contributor and well respecteddrs23 is a quality contributor and well respecteddrs23 is a quality contributor and well respecteddrs23 is a quality contributor and well respecteddrs23 is a quality contributor and well respecteddrs23 is a quality contributor and well respecteddrs23 is a quality contributor and well respecteddrs23 is a quality contributor and well respecteddrs23 is a quality contributor and well respecteddrs23 is a quality contributor and well respected
Default Re: Draft Spreadsheet

Thanks. Great effort.
drs23 is online now   Reply With Quote
Old 04-15-2010   #6
Heath Shuler
worst 2 1st
 
Heath Shuler's Avatar
 
Join Date: Apr 2006
Section: 521
Age: 45
Posts: 2,989
Rep Power: 49148 Heath Shuler is a quality contributor and well respectedHeath Shuler is a quality contributor and well respectedHeath Shuler is a quality contributor and well respectedHeath Shuler is a quality contributor and well respectedHeath Shuler is a quality contributor and well respectedHeath Shuler is a quality contributor and well respectedHeath Shuler is a quality contributor and well respectedHeath Shuler is a quality contributor and well respectedHeath Shuler is a quality contributor and well respectedHeath Shuler is a quality contributor and well respectedHeath Shuler is a quality contributor and well respected
Default Re: Draft Spreadsheet

thanks
__________________
I've been obnoxious
I've been unconscious
I've been all kinds of things that are hard to spell

The Highwaymen
Heath Shuler is offline   Reply With Quote
Old 04-15-2010   #7
Hoss
i need a beer..
 
Hoss's Avatar
 
Join Date: Apr 2005
Location: San Antonio,Texas
Age: 37
Posts: 1,184
Rep Power: 445 Hoss is a quality contributor and well respectedHoss is a quality contributor and well respectedHoss is a quality contributor and well respectedHoss is a quality contributor and well respectedHoss is a quality contributor and well respectedHoss is a quality contributor and well respectedHoss is a quality contributor and well respectedHoss is a quality contributor and well respectedHoss is a quality contributor and well respectedHoss is a quality contributor and well respectedHoss is a quality contributor and well respected
Send a message via AIM to Hoss
Default Re: Draft Spreadsheet

sweet...
__________________

sig-False Start
Hoss is offline   Reply With Quote
Sponsored links
Old 04-22-2010   #8
keyser
Hall of Fame
 
Join Date: Sep 2006
Posts: 1,276
Rep Power: 19314 keyser is a quality contributor and well respectedkeyser is a quality contributor and well respectedkeyser is a quality contributor and well respectedkeyser is a quality contributor and well respectedkeyser is a quality contributor and well respectedkeyser is a quality contributor and well respectedkeyser is a quality contributor and well respectedkeyser is a quality contributor and well respectedkeyser is a quality contributor and well respectedkeyser is a quality contributor and well respectedkeyser is a quality contributor and well respected
Default Re: Draft Spreadsheet

Just in case anyone wants it, I did manage to update just a bit. I grabbed the latest NFLDraftScout data, and I included Gosselin's top 100 list into the sheet. Gosselin's rankings are now part of the average in the single sheet (NFP is not), also.

I still didn't have time to do a thorough clean on the data, but it should be pretty good. Sorry if there are duplcates or errors (I think some were removed, though, since the NFLDraftScout website had a smaller list, today...).

Again, during the draft it helps to add one column for "actual spot taken". Then, if you sort on that column, you will get the "best" remaining list below.
keyser is offline   Reply With Quote
Reply

Go Back   Houston Texans Message Board & Forum - TexansTalk.com > Football Talk > College Football & the 2014 NFL Draft
Home Forums Register FAQ Members List Calendar Mark Forums Read


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -5. The time now is 03:03 PM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Ad Management by RedTyger