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,355
    Likes Received:
    209
    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,507
    Likes Received:
    472
    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:
    7,999
    Likes Received:
    447
    This is fantastic man. Thanks!
     
  4. Dutchrudder

    Dutchrudder COOL BEANS!

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

    chicagotexan2 IDBLDogDareU

    Joined:
    Apr 27, 2007
    Messages:
    8,737
    Likes Received:
    1,068
    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,321
    Likes Received:
    144
    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:
    7,999
    Likes Received:
    447
    Starts around 8.
     
  8. Playoffs

    Playoffs Subscribed Contributor

    Joined:
    Apr 26, 2008
    Messages:
    19,868
    Likes Received:
    1,164
    + 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,355
    Likes Received:
    209
    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:
    7,999
    Likes Received:
    447
    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,355
    Likes Received:
    209
    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,654
    Likes Received:
    322
    great stuff
    you rock:clap:
     

Share This Page