Draft Spreadsheet

Discussion in 'College Football & the NFL Draft' started by keyser, Apr 28, 2011.

  1. keyser

    keyser Hall of Fame

    Joined:
    Sep 24, 2006
    Messages:
    1,357
    Likes Received:
    214
    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.
     
  2. kiwitexansfan

    kiwitexansfan Site Contributor

    Joined:
    Jun 26, 2005
    Messages:
    9,770
    Likes Received:
    569
    Location:
    Auckland, New Zealand
    Only 1971 players on your list? Weak Sauce.


    No really, awesome job on this. Always appreciate your effort! :clap:
     
  3. rmartin65

    rmartin65 I'm Score

    Joined:
    Jul 12, 2005
    Messages:
    8,020
    Likes Received:
    459
    This is fantastic man. Thanks!
     
  4. Dutchrudder

    Dutchrudder King of the Potato People

    Joined:
    Jan 25, 2010
    Messages:
    15,130
    Likes Received:
    1,374
    Location:
    Houston
    Wow, great work! Rep sandwich for you!
     
  5. chicagotexan2

    chicagotexan2 IDBLDogDareU

    Joined:
    Apr 27, 2007
    Messages:
    9,365
    Likes Received:
    1,394
    Location:
    Somewhere most interesting
    Man I'd rep you 100 times if I could. THis is what I've been whishing for. Thanks man.
     
  6. Brandon420tx

    Brandon420tx Flounder

    Joined:
    Apr 29, 2006
    Messages:
    4,589
    Likes Received:
    197
    Location:
    Albuquerque, NM
    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?
     
  7. rmartin65

    rmartin65 I'm Score

    Joined:
    Jul 12, 2005
    Messages:
    8,020
    Likes Received:
    459
    Starts around 8.
     
  8. Playoffs

    Playoffs Subscribed Contributor

    Joined:
    Apr 26, 2008
    Messages:
    21,449
    Likes Received:
    1,751
    + Rep.

    I'm gonna strip out all but Goose's Top 100 --- simple minded. ;)
     
  9. keyser

    keyser Hall of Fame

    Joined:
    Sep 24, 2006
    Messages:
    1,357
    Likes Received:
    214
    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.
     
  10. rmartin65

    rmartin65 I'm Score

    Joined:
    Jul 12, 2005
    Messages:
    8,020
    Likes Received:
    459
    True that. I am on east coast time though, which is why I said 8. My bad dude.
     


  11. keyser

    keyser Hall of Fame

    Joined:
    Sep 24, 2006
    Messages:
    1,357
    Likes Received:
    214
    Actually it looks like Brandon420tx is also on Eastern time, so I probably should have just not said anything!
     
  12. Heath Shuler

    Heath Shuler worst 2 1st

    Joined:
    Apr 30, 2006
    Messages:
    3,779
    Likes Received:
    400
    great stuff
    you rock:clap:
     

Share This Page