1. Pardon our mess as we continue to update the new forum software. Big thanks to Mike and Preditan for all their help in the transition. If you run into any problems, put them in the Update Thread.

2007 NFL mock draft creator spreadsheet...

Discussion in 'NFL Draft' started by Beerfish, Feb 9, 2007.

Thread Status:
Not open for further replies.
  1. Beerfish

    Beerfish Camp Fodder

    Joined:
    Feb 7, 2007
    Messages:
    9
    Greetings, I’m a Jets fan (booo! hisss!) but I’ve put together a 2007 NFL mock draft creator spreadsheet and thought the fans of other NFL teams might find a use for it so I’m posting this here. It’s just a little tool that should be of use to those who have not tried to create mock drafts before and can be useful even to the seasoned draft guru. To those that are Excel savvy feel free to make any changes or improvements you wish to the sheet. If I have posted this in the incorrect forum my apologies and I trust the moderators will move it to the proper place.

    Features:

    Over 300 players (Name, Position, Height, Weight, College) ranked by averaging various player rankings on the net.

    Ability to view by specific player position.

    Team statistical rankings from this past year (Passing, running, against the pass, against the run)

    List of players who will be attending the NFL combine.

    Draft Point Value Chart (For estimating value of specific draft positions for trades.)

    Easy to use, just put the number where you think a player will be picked next to his name on the Player Data page and it fills in his position on your mock draft page.

    Ability to filter the mock draft page to only include the picks for the team you cheer for.

    To download the excel file just click on the link, then click on 'Download File', you will then have to type in a short code they provide on the site and then click on 'Get' and the file will be on it's way. The name of the file is Generic2007NFLMockDraftCreator.xls

    http://www.wikiupload.com/download_page.php?id=73469

    If by any chance the link doesn’t work properly just send me a pm and I’ll be happy to email the spreadsheet to anyone that wants it.

    (The draft order on the mock draft sheet is subject to change because the coin flip between Tampa and Cleveland has not taken place and a few trades for conditional draft picks have not been officially determined as of yet.)
    #1
  2. titansfan9

    titansfan9 Camp Fodder

    Joined:
    Apr 17, 2005
    Messages:
    1,101
    Welcome. Nice tool, thanks...
    #2
  3. Blitzburgh55

    Blitzburgh55 Guest

    Thats cool Thax
    #3
  4. Gut

    Gut Starter

    Joined:
    Jan 7, 2003
    Messages:
    3,731
    Nice!

    Excellent idea and thank you posting it here. Does this have the additional picks (from trades) and if not, how easy is it to add them (as well as compensatory picks)?

    Thanks again,
    Gut
    #4
  5. Beerfish

    Beerfish Camp Fodder

    Joined:
    Feb 7, 2007
    Messages:
    9
    Yes it has the picks from trades though there might be a couple missing because there was some conditional picks. I have added room for compensatory picks near the bottom, once it is known exactly what they are the list will be updated. It is easy to update the draft list yourself, should be just a matter of inserting rows with the appropriate comp picks.
    #5
  6. Gut

    Gut Starter

    Joined:
    Jan 7, 2003
    Messages:
    3,731
    Great...

    Thanks again. I haven't been able to check it out yet but am looking forward to it.

    Any other helpful things you can share with us?

    Gut
    #6
  7. Beerfish

    Beerfish Camp Fodder

    Joined:
    Feb 7, 2007
    Messages:
    9
    Nothing too much more other than the fact that as always some players will soar and others drop like a stone after the combine, so expect some of these general rankings to move.
    #7
Thread Status:
Not open for further replies.