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

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 05-08-2014   #1
keyser
Hall of Fame
 
Join Date: Sep 2006
Posts: 1,300
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
 

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 11:42 AM.


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