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-28-2011   #1
keyser
Hall of Fame
 
Join Date: Sep 2006
Posts: 1,284
Rep Power: 22043 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

As I've done the past few years, I put together a draft spreadsheet. I use this to follow the draft, and keep track of the "best" players remaining. I include rankings of players from 7 different sites, and you can adjust the relative weight of those (right now, I weight 4 of them equally, give one just 75% weight (since they only ranked the first 50 in order), and gave two just 25% weight, since I know less about them.

The "single sheet" version, which most people will probably prefer, is HERE. This is an older Excel format, and has a column you can enter in players as they are chosen. It does not have the raw data. Sheet 2 has the relative weighting for the 7 sites, and Sheet 3 has copied explanation of grades from two of the sites. It is currently sorted based on my weighting.

The "full" version, which has the raw data, including lots of hyperlinks and individual data (like height/weight/40/etc.) on the subsequent sheets, is available HERE. Use that if you want lots of details and to see how I put together the main sheet (note: it is not sorted).

All of the data is freely available data - I did not include anything like ESPN insider. The data was from the last couple of days (it says when I got it in the header line), but may not be the "final" version from each site.

I haven't had as much time to fix the sheet as usual, so there are probably some errors in places, but hopefully stuff near the top is accurate, at least. Let me know if you find errors, but I probably won't have time to fix much today unless it's something big.
keyser is offline   Reply With Quote
Old 04-28-2011   #2
kiwitexansfan
Site Contributor
 
kiwitexansfan's Avatar
 
Join Date: Jun 2005
Location: Auckland, New Zealand
Age: 37
Posts: 9,409
Rep Power: 94067 kiwitexansfan is a quality contributor and well respectedkiwitexansfan is a quality contributor and well respectedkiwitexansfan is a quality contributor and well respectedkiwitexansfan is a quality contributor and well respectedkiwitexansfan is a quality contributor and well respectedkiwitexansfan is a quality contributor and well respectedkiwitexansfan is a quality contributor and well respectedkiwitexansfan is a quality contributor and well respectedkiwitexansfan is a quality contributor and well respectedkiwitexansfan is a quality contributor and well respectedkiwitexansfan is a quality contributor and well respected
Default Re: Draft Spreadsheet

Only 1971 players on your list? Weak Sauce.


No really, awesome job on this. Always appreciate your effort!
__________________
Season Prediction: WAS - W, @ OAK - W, @ NYG - W, BUF - W, @ DAL - W, IND - L, @ PIT - L, @ TEN - W, PHI - L, @ CLE - W, CIN - L, TEN - W, @ JAX - W, @ IND - L, BAL - L, JAX - W = 10-6
kiwitexansfan is offline   Reply With Quote
Old 04-28-2011   #3
rmartin65
I'm Score
 
rmartin65's Avatar
 
Join Date: Jul 2005
Age: 24
Posts: 7,980
Rep Power: 64727 rmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respected
Default Re: Draft Spreadsheet

This is fantastic man. Thanks!
rmartin65 is offline   Reply With Quote
Old 04-28-2011   #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

Wow, great work! Rep sandwich for you!
__________________
Life is too important to be taken seriously. -Oscar Wilde
Dutchrudder is offline   Reply With Quote
Old 04-28-2011   #5
chicagotexan2
IDBLDogDareU
 
chicagotexan2's Avatar
 
Join Date: Apr 2007
Location: Somewhere most interesting
Posts: 8,076
Rep Power: 137757 chicagotexan2 is a quality contributor and well respectedchicagotexan2 is a quality contributor and well respectedchicagotexan2 is a quality contributor and well respectedchicagotexan2 is a quality contributor and well respectedchicagotexan2 is a quality contributor and well respectedchicagotexan2 is a quality contributor and well respectedchicagotexan2 is a quality contributor and well respectedchicagotexan2 is a quality contributor and well respectedchicagotexan2 is a quality contributor and well respectedchicagotexan2 is a quality contributor and well respectedchicagotexan2 is a quality contributor and well respected
Default Re: Draft Spreadsheet

Quote:
Originally Posted by keyser View Post
As I've done the past few years, I put together a draft spreadsheet. I use this to follow the draft, and keep track of the "best" players remaining. I include rankings of players from 7 different sites, and you can adjust the relative weight of those (right now, I weight 4 of them equally, give one just 75% weight (since they only ranked the first 50 in order), and gave two just 25% weight, since I know less about them.

The "single sheet" version, which most people will probably prefer, is HERE. This is an older Excel format, and has a column you can enter in players as they are chosen. It does not have the raw data. Sheet 2 has the relative weighting for the 7 sites, and Sheet 3 has copied explanation of grades from two of the sites. It is currently sorted based on my weighting.

The "full" version, which has the raw data, including lots of hyperlinks and individual data (like height/weight/40/etc.) on the subsequent sheets, is available HERE. Use that if you want lots of details and to see how I put together the main sheet (note: it is not sorted).

All of the data is freely available data - I did not include anything like ESPN insider. The data was from the last couple of days (it says when I got it in the header line), but may not be the "final" version from each site.

I haven't had as much time to fix the sheet as usual, so there are probably some errors in places, but hopefully stuff near the top is accurate, at least. Let me know if you find errors, but I probably won't have time to fix much today unless it's something big.
Man I'd rep you 100 times if I could. THis is what I've been whishing for. Thanks man.
__________________
Having a guy on your payroll that went to Harvard is a good thing UNLESS they are your starting QB. Give me a G.E.D. Charter School drop out that doesn't turn the ball over all the effing time.
chicagotexan2 is online now   Reply With Quote
Old 04-28-2011   #6
Brandon420tx
Flounder
 
Brandon420tx's Avatar
 
Join Date: Apr 2006
Location: Albuquerque, NM
Age: 26
Posts: 4,100
Rep Power: 14154 Brandon420tx is a quality contributor and well respectedBrandon420tx is a quality contributor and well respectedBrandon420tx is a quality contributor and well respectedBrandon420tx is a quality contributor and well respectedBrandon420tx is a quality contributor and well respectedBrandon420tx is a quality contributor and well respectedBrandon420tx is a quality contributor and well respectedBrandon420tx is a quality contributor and well respectedBrandon420tx is a quality contributor and well respectedBrandon420tx is a quality contributor and well respectedBrandon420tx is a quality contributor and well respected
Send a message via AIM to Brandon420tx
Default Re: Draft Spreadsheet

Since the decertification and lockout process started, I haven't gone to NFL.com, ESPN.com, or watched NFL Network or ESPN (and affiliates), so I forgot, what is the precise time the draft starts so I can follow it on the MB?
__________________
New more casual style goalline blitz game
http://glb2.warriorgeneral.com/game/signup?ref=66361
Brandon420tx is offline   Reply With Quote
Old 04-28-2011   #7
rmartin65
I'm Score
 
rmartin65's Avatar
 
Join Date: Jul 2005
Age: 24
Posts: 7,980
Rep Power: 64727 rmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respected
Default Re: Draft Spreadsheet

Quote:
Originally Posted by Brandon420tx View Post
Since the decertification and lockout process started, I haven't gone to NFL.com, ESPN.com, or watched NFL Network or ESPN (and affiliates), so I forgot, what is the precise time the draft starts so I can follow it on the MB?
Starts around 8.
rmartin65 is offline   Reply With Quote
Sponsored links
Old 04-28-2011   #8
Playoffs 
Subscribed Contributor
 
Playoffs's Avatar
 
Join Date: Apr 2008
Posts: 15,307
Rep Power: 307979 Playoffs is a quality contributor and well respectedPlayoffs is a quality contributor and well respectedPlayoffs is a quality contributor and well respectedPlayoffs is a quality contributor and well respectedPlayoffs is a quality contributor and well respectedPlayoffs is a quality contributor and well respectedPlayoffs is a quality contributor and well respectedPlayoffs is a quality contributor and well respectedPlayoffs is a quality contributor and well respectedPlayoffs is a quality contributor and well respectedPlayoffs is a quality contributor and well respected
Default Re: Draft Spreadsheet

+ Rep.

I'm gonna strip out all but Goose's Top 100 --- simple minded.
Playoffs is offline   Reply With Quote
Old 04-28-2011   #9
keyser
Hall of Fame
 
Join Date: Sep 2006
Posts: 1,284
Rep Power: 22043 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

Quote:
Originally Posted by rmartin65 View Post
Starts around 8.
Actually, I'm pretty sure it is stated as starting at 7 Central Time (8 is for the Eastern time zone). Tomorrow, round 2 starts at 5 Central time, and Saturday round 4 starts at 11 a.m. Central time.
keyser is offline   Reply With Quote
Old 04-28-2011   #10
rmartin65
I'm Score
 
rmartin65's Avatar
 
Join Date: Jul 2005
Age: 24
Posts: 7,980
Rep Power: 64727 rmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respectedrmartin65 is a quality contributor and well respected
Default Re: Draft Spreadsheet

Quote:
Originally Posted by keyser View Post
Actually, I'm pretty sure it is stated as starting at 7 Central Time (8 is for the Eastern time zone). Tomorrow, round 2 starts at 5 Central time, and Saturday round 4 starts at 11 a.m. Central time.
True that. I am on east coast time though, which is why I said 8. My bad dude.
rmartin65 is offline   Reply With Quote
Old 04-28-2011   #11
keyser
Hall of Fame
 
Join Date: Sep 2006
Posts: 1,284
Rep Power: 22043 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

Quote:
Originally Posted by rmartin65 View Post
True that. I am on east coast time though, which is why I said 8. My bad dude.
Actually it looks like Brandon420tx is also on Eastern time, so I probably should have just not said anything!
keyser is offline   Reply With Quote
Old 04-28-2011   #12
Heath Shuler
worst 2 1st
 
Heath Shuler's Avatar
 
Join Date: Apr 2006
Section: 521
Age: 45
Posts: 3,080
Rep Power: 66263 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

great stuff
you rock
__________________
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
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 01:26 PM.


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