1. Welcome to CowboysZone!  Join us!  Come on!  You know you want to!

2014 NFL Draft Spreadsheet and Cowboyszone "BIG BOARD"***Public Spreadsheet Post #19***

Discussion in 'Draft Zone' started by Fredd, Mar 16, 2014.

  1. Biggems

    Biggems White and Nerdy

    11,756 Messages
    125 Likes Received
    I dont have the time....that is why i am thankful you guys go through so much effort. TBH, I don't really care that the rankings are a little dated, it's still a great tool for analysis use. But, because Gaines and McAllister went to Judson, I am a lot more sensative to theirs. It is all about Rocket Pride for me.
    Fredd likes this.
  2. Fredd

    Fredd Well-Known Member

    3,701 Messages
    1,389 Likes Received
    haha...well, I expect to have an updated file by this time next week, another update by April 30th, and then a final update for the draft...I am hopeful that we can get some participation in the file so that we can create our own big board....hey, even if you give a first round or two, THAT helps greatly...it doesn't have to be 100

    Thanx again
  3. Fredd

    Fredd Well-Known Member

    3,701 Messages
    1,389 Likes Received
    update (copied this from the other thread)

    Here are some preliminary results from the rankings provided by those of you that have participated in the Cowboyszone Big Board. I used the CBS board, Mel Kiper's first two rounds, Tood McShay's first two rounds and picks supplied by 5 CZ members (myself, @tm1119 , @jterrell , @Doc50 , and @unionjack8 (thank you). I will show in here a few picks before and after our selections to give you an idea of how it is running currently:

    First Round: 1) Robinson, 2) Clowney, 3) Mack, 4) Bortles, 5) Matthews, Jake, 6) Watkins, 7) Evans, 8) Gilbert, 9) Ebron, 10) Manziel, 11) Lewan, 12) Bridgewater, 13) Dennard

    1st round (#16): 14) Donald, 15) Barr, 16) Mosley, 17) Clinton-Dix, 18) Martin, Zack

    Rest of first round: 19) Beckham Jr, 20) Pryor, 21) Jernigan, 22) Cooks, 23) Nix, 24) Verrett, 25) Hageman, 26) Shazier, 27) Ford, 28) Su'a-filo, 29) Roby, 30) Fuller, 31) Benjamin, 32) Moses

    2nd round (#47): 45) Borland, 46) Bitonio, 47) Amaro, 48) Lawrence, 49) Kouandijo

    3rd round (#78): 76) Smith, Telvin, 77) Desir , 78) Bryant, Martavis, 79) Jones, DaQuan, 80) Breeland
    Notables right after this: Easley, Sankey, Sutton, Thomas,B., Jeffcoat

    4th round (#119): 117) Reynolds, Ed, 118) Fleming, 119) Huff, Josh, 120) Murray, 121) Dixon
    Notables right after this: Reid, Turner,T.

    5th Round (#158): 156) Grant, 157) Mitchell, 158) Breslin, 159) Archer, 160) Jones,TJ
    Notables right after this: Sam, Fales, Shembo

    I didn't bother projecting anything into the 7th round as I only have CBS and other sites to go by.

    If you want to participate in creating the CZ Big Board, click on this link https://docs.google.com/spreadsheet/ccc?key=0AoBGPWKdYxpndEdseXlZT2I5aFJULUIzTzJkOElvNVE&usp=sharing and enter your projections. Put your username at the top and then enter the names (last name, first name please). The more people that use this, the better this will be. You can also go in an edit your picks at any point. I will be updating the list two more times before the draft and all of our picks will update the NFL Draft Spreadsheet. If you want a say in who is high on the spreadsheet, this is the way to do it. you don't have to give 100 to 150 names, you can just give one or two rounds, it can make a difference.

    You can find the Excel spreadsheet with everything on there in the NFL Draft Spreadsheet thread in the Draft Zone. That will get updated within the next week or so, once I get all of the rankings updated.

    Please let me know your thoughts.
    -Fredd-
  4. Floaty

    Floaty Well-Known Member

    754 Messages
    272 Likes Received
    This is awesome Fredd....

    Went a little over board today. Still need to update a few picks hence the gaps. And I'll come clean....still learning Excel. Is there an easier way to rank the players w/o erasing the players already ranked?
  5. Fredd

    Fredd Well-Known Member

    3,701 Messages
    1,389 Likes Received
    Thank you for participating. I would copy & paste it onto an open column and then update as you see fit. PM me if you have questions.

    -Fredd-
  6. Floaty

    Floaty Well-Known Member

    754 Messages
    272 Likes Received
    That's what I have been doing. Seems to me there should be a way to grab a player and then just slot them in....and then the rest of the players would slide down.
  7. hipfake08

    hipfake08 Well-Known Member

    4,283 Messages
    64 Likes Received
    Great to use to compare against other NFL guides.

    Thanks.
  8. Macnalty

    Macnalty Well-Known Member

    1,016 Messages
    87 Likes Received
    Need help moving my cells up and down in the row without deleting data(insert option in excel), I want to rearrange my picks non destructively. Thanks again for arranging this, it is a great tool.
  9. Floaty

    Floaty Well-Known Member

    754 Messages
    272 Likes Received
    I think you and I are having the same problem. there has got to be a way to move the players w/o erasing!!!!
  10. Fredd

    Fredd Well-Known Member

    3,701 Messages
    1,389 Likes Received
    I would suggest using an open column and putting your full list in there. then, you but & paste them over to the one where your username resides...that's what I did when I updated mine...there is a way to do this in excel, but it would take too long to go over that...
  11. Macnalty

    Macnalty Well-Known Member

    1,016 Messages
    87 Likes Received
    That is true, I can do it in Excel but do not seem to be able to figure out the commands for the google docs(it should). I will work on my 100(in excel) and then clear my cells(google docs) with the new data. Thanks for getting back to me, and Floaty just put you list into excel and you will see a nice way to insert names from the cell rows.

    My biggest changes for this week in talent are with J Attachou, Zack Martin, Baptiste CB, Juwan James OT, Murphy DE, Crichton DE, Demarcus Lawrence OLB, all moving up. My take is all the decent talent for DE will be gone before our pick in the 2nd rd. Not sure where all the love is coming from for Jimmy Ward FS(too small IMO).
    On the way down A Barr(raw talent),C Pryor, LaMarcus Joyner.
  12. Fredd

    Fredd Well-Known Member

    3,701 Messages
    1,389 Likes Received
    I took tomorrow off, so I am likely to update my own list

    we need more participants. I am likely going to close this down in about a week because I have to put the final NFL Draft Spreadsheet together based on our rankings.

    WE NEED MORE OF YOU!!!
  13. Floaty

    Floaty Well-Known Member

    754 Messages
    272 Likes Received
    What day are you gonna shut this down???? Was planning on editing until next Friday....
  14. Fredd

    Fredd Well-Known Member

    3,701 Messages
    1,389 Likes Received
    OK, I will give you until I wake on Saturday, the 3rd...
  15. jday

    jday Well-Known Member

    2,820 Messages
    686 Likes Received
    Excellent work. I appreciate the time you put into this.
  16. NJ22

    NJ22 Well-Known Member

    1,121 Messages
    894 Likes Received

    Dude..Love it! Well done brother. . Instead of making my own xls this year. I will take advantage of your hard work.
  17. Fredd

    Fredd Well-Known Member

    3,701 Messages
    1,389 Likes Received
    Thank you! Now, if you want to help create the rankings, then go into post #19, click the link and add your own players in...I am putting the final version together on Saturday/Sunday....so, your picks need to be in by Friday night (I get up early on Saturday)
  18. jobberone

    jobberone Genetically engineered moderating Orangutan Staff Member

    37,540 Messages
    3,828 Likes Received
    If they take Amaro (whom I see as a 4th rounder) over Easley I will send JJ a nastygram which will be my first communication with VR ever. I will have a hissy fit and rave and rant. It will be unbecoming to say the least. It won't last long but it won't be pretty.
  19. jobberone

    jobberone Genetically engineered moderating Orangutan Staff Member

    37,540 Messages
    3,828 Likes Received
    On phone. How to change my board. Need to switch Robinson for Lewan.

    EDIT: figured it out. Spreadsheets ain't my thing.
    Last edited: May 2, 2014
  20. Doc50

    Doc50 Original Fan Zone Supporter

    748 Messages
    231 Likes Received
    I have used this as an ranking tool -
    not a predictor of where I think players will be drafted. There will be no moves unless someone gets injured or arrested in the next week.
    Likewise, if I have a guy ranked at # 50, and he goes at #10, that doesn't change my mind at all.
    Need to reevaluate the stated worth in 2-3 years.
    jobberone likes this.

Share This Page