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 05-08-2014   #1
keyser
Hall of Fame
 
Join Date: Sep 2006
Posts: 1,301
Rep Power: 24723 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

Most years (couldn't do it last year), I put together a large spreadsheet to help me keep track of all the players during the draft. I pull the info from 6 public sites and basically rank the players by the average from those 6 sites. In the past, some other people have enjoyed having this, also.

If you want to get the spreadsheet (it is in Excel), there are three options:
  • A Really Basic Spreadsheet (just data)
  • A Spreadsheet Where You Can Set Weights. To change weights, go to the Weights tab at the bottom. It will let you change the relative weighting of the 6 draft websites (larger values mean more weight, smaller ones less weight).
  • A Spreadsheet With a Sort Button. You can set weights here, also. There is an extra column for actual pick. I use this one during the draft: enter the actual pick next to each person's name, and then just press the SORT button. It will sort by actual pick number, and the remaining ones will be sorted by Overall Average Rank. Note: the button is a macro, so this is a macro-enabled workbook. Some software will block macros (including possibly downloading the file).
  • And, for those who want to see the original setup, you can get the full spreadsheet here (without some of the features/formatting). I expect most people would want one of the others, though.

Enjoy!
keyser is offline   Reply With Quote
Old 05-08-2014   #2
thunderkyss 
& so it begins
 
thunderkyss's Avatar
 
Join Date: Sep 2005
Location: Texas
Age: 42
Posts: 36,415
Rep Power: 326894 thunderkyss is a quality contributor and well respectedthunderkyss is a quality contributor and well respectedthunderkyss is a quality contributor and well respectedthunderkyss is a quality contributor and well respectedthunderkyss is a quality contributor and well respectedthunderkyss is a quality contributor and well respectedthunderkyss is a quality contributor and well respectedthunderkyss is a quality contributor and well respectedthunderkyss is a quality contributor and well respectedthunderkyss is a quality contributor and well respectedthunderkyss is a quality contributor and well respected
Send a message via Yahoo to thunderkyss
Default Re: Draft Spreadsheet

Quote:
Originally Posted by keyser View Post
Most years (couldn't do it last year), I put together a large spreadsheet to help me keep track of all the players during the draft. I pull the info from 6 public sites and basically rank the players by the average from those 6 sites. In the past, some other people have enjoyed having this, also.
Uh... wow, thanks.

Very interesting.

I like how some of these sites grades as As, or 5s
NationalFootballPost Round
Scout Stars

Then some give grades
NationalFootballPost Grade
NFL.com Grade


Looking at those, I think, gives you a clearer picture of how it's as much about personal preference once you get to a certain level. These QBs for instance, several of them get the same grade, which is more likely the case. One team will weigh certain things higher than another team so one team might have Bortles as the best QB in this draft & another might have Manziel.

I don't like how some of these sites rank them. It makes joe blow think that so&so is the best QB & has been the best QB since they stopped playing football & yada, yada, yada... as if Mike Mayock ever drafted a QB to play for an NFL team.

In a draft like this, you should expect a QB with a first round grade to drop out of the first, maybe even to the third through no fault of his own, & that's true value. His chances of being a successful NFL QB is no less after falling to the 2nd or 3rd.

If I were a Teddybot, nothing could make me happier than knowing the Texans won't draft a QB with the #1 overall & my guy is falling into the second.

If he is who we think he is, it's going to show. Falling may even provide the motivation to be even better than he would have been.
__________________
thunderkyss is offline   Reply With Quote
Old 05-11-2014   #3
Playoffs 
Subscribed Contributor
 
Playoffs's Avatar
 
Join Date: Apr 2008
Posts: 16,424
Rep Power: 387845 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

Quote:
Originally Posted by keyser View Post
Enjoy!
Nicely offered, nicely done. Repped.
Playoffs is offline   Reply With Quote
Old 05-11-2014   #4
beerlover
Site Contributor
 
beerlover's Avatar
 
Join Date: May 2004
Posts: 12,557
Rep Power: 66422 beerlover is a quality contributor and well respectedbeerlover is a quality contributor and well respectedbeerlover is a quality contributor and well respectedbeerlover is a quality contributor and well respectedbeerlover is a quality contributor and well respectedbeerlover is a quality contributor and well respectedbeerlover is a quality contributor and well respectedbeerlover is a quality contributor and well respectedbeerlover is a quality contributor and well respectedbeerlover is a quality contributor and well respectedbeerlover is a quality contributor and well respected
Default Re: Draft Spreadsheet

ranking is a *****, really not in agreement with multiple sources/outlets but thanks for the spread sheet. Mike Mayock had Barr @ #20 & Donald #24 hence I lost a lot of respect for his rankings which in turn contaminated group as a whole.
__________________

2012 Draft was Mercilus
beerlover is offline   Reply With Quote
Old 05-11-2014   #5
badboy
Site Contributor
 
Join Date: Apr 2007
Location: Clear Lake
Posts: 24,173
Rep Power: 198627 badboy is a quality contributor and well respectedbadboy is a quality contributor and well respectedbadboy is a quality contributor and well respectedbadboy is a quality contributor and well respectedbadboy is a quality contributor and well respectedbadboy is a quality contributor and well respectedbadboy is a quality contributor and well respectedbadboy is a quality contributor and well respectedbadboy is a quality contributor and well respectedbadboy is a quality contributor and well respectedbadboy is a quality contributor and well respected
Default Re: Draft Spreadsheet

I was not too happy with any of the ranking sites I use. Glad Texans did not panic and buy into the hype of Savage and got him much cheaper. I had mocked him at round seven about 1/2 way through season. I had him late round five & he is as good a prospect as any other.
__________________
I want to be able to recognize the difference between a "want" and a "need" and then I want to be satisfied with getting a need
badboy 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 09:50 AM.


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