Draft Simulator v1

Discussion in 'Draft Zone' started by Staxxxx, Feb 5, 2012.

  1. Staxxxx

    Staxxxx Member

    293 Messages
    19 Likes Received
    A little history:

    I don't post much on here but I've been reading the site and posting periodically on other Cowboys sites for years. About four or five years back I was as into the draft and mocking as anyone not named Cowboyjoe. Well as most of you know a passion like that takes an inordinate amount of time to keep it properly fed and due to family committments and evolution of my job I haven't had enough to take it very seriously the last few years. I've been forced to live vicariously through you guys on this draft forum.

    Fast forward to now
    Over the last couple of years I've been asked at work to transition from Server Admin to Web Developer and most recently I've been asked to transition to the ever short handed database developer team and as usual there isn't time for any OJT. Whether I sink or swim will be up to me on my own time. Well as most of you can probably guess reading text books on SQL programming ranks right up there with bamboo under the fingernails and waterboarding on my 'want to do' list, as does my desire to fail.

    So I came up with the bright idea of teaching myself sql by building a draft simulater. As my skill set evolves my hope is that the simulator will too. So after 2 weeks of late nights and endless cups of coffee I finally have output from Version one. My goals are two fold here. Number one to learn as much as I can and number two to end up with something that can stand up to anything on the internet.

    I must admit that a month ago this wasn't in my plans and I'm not bringing alot of my own draft knowledge to the table here. The player rankings are derived from a combination of a simple algorithm that is heavily weighted toward Wes Bunting, as I found his grading scale the easiest to incorporate. Mike Mayok's top 5 for each position has significant influence where applicable. Rob Rang and Draftek also contributed and I finished it off with a little manual tweaking where needed. I hope to keep adding sources and keep tweaking the forumla to eventually come up with a better board.

    My Team needs are a combination of Draftek and my own thoughts and I'm definetly not happy with what I have there yet. The simulator currently drafts primarily by need with some BPA influence mixed in. It basically creates a mini draft board at each team pick based on top x amount of positions of need and tries to pick BPA. The number of positions of need it looks at vary by where the pick is in the draft. I hope to eventually make this some thing that is easily tweakable with each run.

    Finally I'm trying to do some weighting of positions based on where in the draft the pick is to try to compensate for the over drafting and underdrafting of certain positions at different points in the draft. There is quite a bit I hope to add and or fix in the future if time and my learning curve permit.

    At this time it's still quite crude but I thought I'd post my first output and see if I could garner some constructive feedback to decide where to put my focus next. Never one to pass on an oppurtunity to make a short story long, here is my first 6 and 3/4 round mock. Darn thing keeps blowing up in the 7th round on the Giants. Go figure.

    Round 1

    RND-Pk First Last Pos Ht Wt Team School
    1-1 ANDREW LUCK QB 76 235 Indianapolis Stanford
    1-2 MORRIS CLAIBORNE CB 73 185 StLouis Louisiana State
    1-3 JUSTIN BLACKMON WR 73 215 Minnesota Oklahoma State
    1-4 ROBERT GRIFFIN III QB 74 220 Cleveland Baylor
    1-5 MATT KALIL OT 79 295 TampaBay Southern California
    1-6 RYAN TANNEHILL QB 76 222 Washington Texas A&M
    1-7 QUINTON COPLES DE 78 285 Jacksonville North Carolina
    1-8 RILEY REIFF OT 78 300 Miami Iowa
    1-9 DEVON STILL DT 77 310 Carolina Penn State
    1-10 MELVIN INGRAM DE 74 276 Buffalo South Carolina
    1-11 TRENT RICHARDSON RB 71 224 KansasCity Alabama
    1-12 MICHAEL BROCKERS DT 78 306 Seattle Louisiana State
    1-13 MIKE ADAMS OT 80 320 Arizona Ohio State
    1-14 DRE KIRKPATRICK CB 75 192 Dallas Alabama
    1-15 LUKE KUECHLY ILB 75 237 Philadelphia Boston College
    1-16 KENDALL WRIGHT WR 70 190 NewYorkJets Baylor
    1-17 DAVID DECASTRO OG 77 310 Cincinnati Stanford
    1-18 DWAYNE ALLEN TE 76 255 SanDiego Clemson
    1-19 MICHAEL FLOYD WR 75 224 Chicago Notre Dame
    1-20 JANORIS JENKINS CB 70 182 Tennessee North Alabama
    1-21 DAVID WILSON RB 70 205 Cincinnati Virginia Tech
    1-22 ALSHON JEFFERY WR 76 229 Cleveland South Carolina
    1-23 NICK PERRY OLB 75 250 Detroit Southern California
    1-24 DONT'A HIGHTOWER ILB 76 260 Pittsburgh Alabama
    1-25 MARK BARRON SS 74 218 Denver Alabama
    1-26 JONATHAN MARTIN OT 78 304 Houston Stanford
    1-27 PETER KONZ OC 77 315 NewEngland Wisconsin
    1-28 COURTNEY UPSHAW OLB 74 265 GreenBay Alabama
    1-29 KEVIN ZEITLER OG 76 315 Baltimore Wisconsin
    1-30 LAMAR MILLER RB 71 212 SanFrancisco Miami
    1-31 COBY FLEENER TE 78 244 NewYorkGiants Stanford
    1-32 ALFONZO DENNARD CB 70 205 NewEngland Nebraska

    Round 2

    2-1 JEREL WORTHY DT 75 310 StLouis Michigan State
    2-2 BRANDON THOMPSONDT 74 310 Indianapolis Clemson
    2-3 LEONARD JOHNSON CB 70 202 Minnesota Iowa State
    2-4 VONTAZE BURFICT ILB 75 250 TampaBay Arizona State
    2-5 CORDY GLENN OG 77 348 Cleveland Georgia
    2-6 ORSON CHARLES TE 75 241 Jacksonville Georgia
    2-7 AMINI SILATOLU OG 75 324 Washington Midwestern State
    2-8 LAVONTE DAVID OLB 73 225 Carolina Nebraska
    2-9 CASEY HAYWARD CB 71 188 Buffalo Vanderbilt
    2-10 BRUCE IRVIN OLB 75 245 Miami West Virginia
    2-11 TRAVIS LEWIS OLB 74 227 Seattle Oklahoma
    2-12 KELECHI OSEMELE OG 78 347 KansasCity Iowa State
    2-13 BRANDON WASHINGTON OG 76 320 Dallas Miami
    2-14 ZACH BROWN OLB 74 230 Philadelphia North Carolina
    2-15 MARKELLE MARTIN FS 73 198 NewYorkJets Oklahoma State
    2-16 DONTARI POE DT 77 350 NewEngland Memphis
    2-17 JAMELL FLEMING CB 71 191 SanDiego Oklahoma
    2-18 BRANDON BROOKS OG 77 343 Chicago Miami (Ohio)
    2-19 ALAMEDA TA'AMU DT 75 337 Philadelphia Washington
    2-20 BRANDON BOYKIN CB 70 183 Tennessee Georgia
    2-21 STEPHON GILMORE CB 73 193 Cincinnati South Carolina
    2-22 JOSH NORMAN CB 73 190 Detroit Coastal Carolina
    2-23 DOUG MARTIN RB 69 215 Atlanta Boise State
    2-24 GEORGE ILOKA SS 75 216 Pittsburgh Boise State
    2-25 JARIUS WRIGHT WR 70 180 Denver Arkansas
    2-26 ANDRE BRANCH DE 77 260 Houston Clemson
    2-27 CHANDLER JONES DE 77 265 NewOrleans Syracuse
    2-28 FLETCHER COX DE 76 295 GreenBay Mississippi State
    2-29 BEN JONES OC 75 316 Baltimore Georgia
    2-30 SENIO KELEMETE OG 76 301 SanFrancisco Washington
    2-31 JAMES-MICHAEL JOHNSON ILB 74 240 NewYorkGiants Nevada
    2-32 HARRISON SMITH SS 74 214 NewEngland Notre Dame

    Round 3

    3-1 TRUMAINE JOHNSON CB 74 204 Indianapolis Montana
    3-2 RONNELL LEWIS OLB 74 244 StLouis Oklahoma
    3-3 ANTONIO ALLEN SS 74 202 Minnesota South Carolina
    3-4 JARED CRICK DE 78 285 Cleveland Nebraska
    3-5 BOBBY WAGNER ILB 73 232 TampaBay Utah State
    3-6 JOSH CHAPMAN DT 73 310 Washington Alabama
    3-7 LAMICHAEL JAMES RB 69 195 Jacksonville Oregon
    3-8 JOE ADAMS WR 71 190 Buffalo Arkansas
    3-9 BRANDON WEEDEN QB 76 218 Miami Oklahoma State
    3-10 CAM JOHNSON DE 76 270 Chicago Virginia
    3-11 MYCHAL KENDRICKS ILB 73 240 KansasCity California
    3-12 NICK FOLES QB 77 240 Seattle Arizona
    3-13 SHEA MCCLELLIN OLB 75 258 Philadelphia Boise State
    3-14 LUCAS NIX OG 78 310 NewYorkJets Pittsburgh
    3-15 CORYELL JUDIE CB 71 190 Oakland Texas A&M
    3-16 EMMANUEL ACHO ILB 74 245 SanDiego Texas
    3-17 ROBERT TURBIN RB 70 216 Chicago Utah State
    3-18 EVAN RODRIGUEZ FB 75 250 Arizona Temple
    3-19 WHITNEY MERCILUS DE 76 265 Dallas Illinois
    3-20 AUDIE COLE OLB 77 239 Tennessee North Carolina State
    3-21 CHASE MINNIFIELD CB 73 185 Cincinnati Virginia
    3-22 DEVON RAMSAY FB 74 250 Atlanta North Carolina
    3-23 JEFF ALLEN OG 77 315 Detroit Illinois
    3-24 ZEBRIE SANDERS OT 78 307 Pittsburgh Florida State
    3-25 ISAIAH PEAD RB 71 200 Denver Cincinnati
    3-26 NICK TOON WR 75 220 Houston Wisconsin
    3-27 SEAN SPENCE OLB 73 224 NewOrleans Miami
    3-28 TRENTON ROBINSON FS 70 195 GreenBay Michigan State
    3-29 VINNY CURRY DE 76 263 Baltimore Marshall
    3-30 JAMES BROWN OT 76 312 SanFrancisco Troy
    3-31 CHRIS POLK RB 71 222 NewYorkGiants Washington
    3-32 DAJOHN HARRIS DT 76 310 NewEngland Southern California
  2. Staxxxx

    Staxxxx Member

    293 Messages
    19 Likes Received
    Round 4

    4-1 BERNARD PIERCE RB 73 218 StLouis Temple
    4-2 TYRONE CRAWFORD DE 76 276 Indianapolis Boise State
    4-3 BRANDON TAYLOR FS 73 195 Minnesota Louisiana State
    4-4 TONY BERGSTROM OG 78 315 Philadelphia Utah
    4-5 CYRUS GRAY RB 70 200 Cleveland Texas A&M
    4-6 MARVIN JONES WR 75 202 Jacksonville California
    4-7 BROCK OSWEILER QB 80 240 Washington Arizona State
    4-8 LADARIUS GREEN TE 78 236 Miami UL Lafayette
    4-9 KEENAN ROBINSON OLB 75 239 Carolina Texas
    4-10 B.J COLEMAN QB 76 220 Buffalo Tennessee-Chattanooga
    4-11 BILLY WINN DT 76 295 Seattle Boise State
    4-12 JERRY FRANKLIN ILB 73 245 KansasCity Arkansas
    4-13 LEVY ADCOCK OT 78 322 NewYorkJets Oklahoma State
    4-14 MARVIN MCNUTT WR 76 215 Washington Iowa
    4-15 MATT MCCANTS OT 79 295 SanDiego Alabama-Birmingham
    4-16 JAYRON HOSLEY CB 70 171 Chicago Virginia Tech
    4-17 ANDREW DATKO OT 78 321 Arizona Florida State
    4-18 ASA JACKSON CB 70 188 Dallas California Poly
    4-19 BRANDON MOSLEY OT 78 305 Philadelphia Auburn
    4-20 DAVID MOLK OC 74 286 Tennessee Michigan
    4-21 MICHAEL BREWSTER OC 77 305 Cincinnati Ohio State
    4-22 MARKUS ZUSEVICS OT 77 300 Detroit Iowa
    4-23 MIKE MARTIN DT 74 304 Cleveland Michigan
    4-24 NATE POTTER OT 78 300 Pittsburgh Boise State
    4-25 MICHAEL EGNEW TE 78 245 Denver Missouri
    4-26 SHAUN PRATER CB 71 185 Houston Iowa
    4-27 MALIK JACKSON DE 77 270 NewOrleans Tennessee
    4-28 AARON HENRY FS 73 210 GreenBay Wisconsin
    4-29 DEANGELO PETERSON TE 76 243 Buffalo Louisiana State
    4-30 CHRISTIAN THOMPSON FS 73 213 SanFrancisco South Carolina State
    4-31 KELVIN BEACHUM OG 75 306 NewYorkGiants Southern Methodist
    4-32 KYLE WILBER OLB 77 240 NewEngland Wake Forest

    Round 5

    5-1 DEREK DENNIS OG 77 328 Indianapolis Temple
    5-2 BRIAN QUICK WR 75 215 Denver Appalachian State
    5-3 ROBERT BLANTON CB 73 200 Minnesota Notre Dame
    5-4 TONY DYE SS 73 216 Cleveland UCLA
    5-5 MICAH PELLERIN CB 73 195 TampaBay Hampton
    5-6 DOMINIQUE HAMILTON DT 77 305 Washington Missouri
    5-7 DONNIE FLETCHER CB 73 195 Jacksonville Boston College
    5-8 MARCUS FORSTON DT 75 300 Carolina Miami
    5-9 KENDALL REYES DT 76 295 Buffalo Connecticut
    5-10 WINSTON GUY JR. SS 73 216 Miami Kentucky
    5-11 DEVIER POSEY WR 74 210 KansasCity Ohio State
    5-12 JAYE HOWARD DT 75 303 Seattle Florida
    5-13 AKIEM HICKS DT 77 324 Oakland University of Regina
    5-14 BRANDON LINDSEY OLB 74 250 SanDiego Pittsburgh
    5-15 OMAR BOLDEN CB 71 195 Chicago Arizona State
    5-16 JACK CRAWFORD DE 77 273 Arizona Penn State
    5-17 RHETT ELLISON TE 77 250 Dallas Southern California
    5-18 JOE LOONEY OG 75 320 Philadelphia Wake Forest
    5-19 B.J. CUNNINGHAM WR 74 215 NewYorkJets Michigan State
    5-20 CHASE FORD TE 78 245 Tennessee Miami
    5-21 TAUREN POOLE RB 70 215 Cincinnati Tennessee
    5-22 JAKE BEQUETTE DE 77 271 Atlanta Arkansas
    5-23 JAYMES BROOKS OG 74 307 Detroit Virginia Tech
    5-24 A.J. JENKINS WR 73 190 Pittsburgh Illinois
    5-25 KIRK COUSINS QB 75 205 Denver Michigan State
    5-26 MIKE HARRIS CB 71 195 Houston Florida State
    5-27 CHRIS RAINEY WR 69 174 NewOrleans Florida
    5-28 JOSH KADDU OLB 75 235 GreenBay Oregon
    5-29 ROBERT GOLDEN CB 71 200 Baltimore Arizona
    5-30 DAN HERRON RB 70 205 SanFrancisco Ohio State
    5-31 MITCHELL SCHWARTZ OT 78 318 NewYorkGiants California
    5-32 NIGEL BRADHAM ILB 75 240 Cincinnati Florida State

    Round 6

    6-1 JARRETT BOYKIN WR 74 218 StLouis Virginia Tech
    6-2 TRAMAIN THOMAS FS 73 204 Indianapolis Arkansas
    6-3 AL NETTER OG 78 310 Minnesota Northwestern
    6-4 DANNY TREVATHAN OLB 73 232 TampaBay Kentucky
    6-5 VICK BALLARD RB 71 220 Cleveland Mississippi State
    6-6 T.Y. HILTON WR 70 183 Jacksonville Florida International
    6-7 OLIVIER VERNON DE 76 265 NewOrleans Miami
    6-8 RYAN BROYLES WR 70 188 Buffalo Oklahoma
    6-9 CHIGBO ANUNOBY DT 76 324 Miami Morehouse
    6-10 LANCE LEWIS WR 75 209 Carolina East Carolina
    6-11 RYAN LINDLEY QB 76 230 Seattle San Diego State
    6-12 BRIAN LINTHICUM TE 77 245 KansasCity Michigan State
    6-13 CHRIS JACOBSON OG 75 295 SanDiego Pittsburgh
    6-14 JURON CRINER WR 76 215 Chicago Arizona
    6-15 JEFF FULLER WR 76 220 Arizona Texas A&M
    6-16 DEREK WOLFE DE 77 300 Dallas Cincinnati
    6-17 QUENTON SAULSBERRY OC 74 300 Philadelphia Mississippi State
    6-18 SAMMY BROWN OLB 75 240 NewYorkJets Houston
    6-19 TOMMY STREETER WR 77 215 Oakland Miami
    6-20 BRETT ROY DE 76 280 Tennessee Nevada
    6-21 JULIAN MILLER DE 76 268 Cincinnati West Virginia
    6-22 KELCIE MCCRAY SS 74 195 Detroit Arkansas State
    6-23 BRAD SMELLEY TE 75 229 Atlanta Alabama
    6-24 WAYNE TRIBUE OG 76 324 Pittsburgh Temple
    6-25 G.J. KINNE QB 74 234 Philadelphia Tulsa
    6-26 RUSSELL WILSON QB 71 210 Houston Wisconsin
    6-27 DESMOND MARROW CB 75 210 NewOrleans Toledo
    6-28 JUSTIN BETHAL CB 71 196 GreenBay Presbyterian
    6-29 DWIGHT BENTLEY CB 71 179 Baltimore UL Lafayette
    6-30 KEITH TANDY CB 70 199 SanFrancisco West Virginia
    6-31 MIKE DANIELS DT 73 280 NewYorkGiants Iowa
    6-32 COREY MOSLEY FS 70 200 Philadelphia Virginia

    Round 7

    7-1 JAMES CARMON OT 79 320 Indianapolis Mississippi State
    7-2 TANK CARDER ILB 75 237 StLouis Texas Christian
    7-3 D'ANTON LYNN CB 73 208 Minnesota Penn State
    7-4 BOBBY RAINEY RB 68 205 Cleveland Western Kentucky
    7-5 CHRIS MARVE ILB 73 242 TampaBay Vanderbilt
    7-6 MARC TYLER RB 71 230 Washington Southern California
    7-7 CHANDLER HARNISH QB 74 220 Jacksonville Northern Illinois
    7-8 JERMAINE KEARSE WR 74 208 Miami Washington
    7-9 DESMOND WYNN OG 78 295 Carolina Rutgers
    7-10 HEBRON FANGUPO DT 73 330 Buffalo BYU
    7-11 KELLEN MOORE QB 73 191 KansasCity Boise State
    7-12 CASE KEENUM QB 74 210 Seattle Houston
    7-13 CODY JOHNSON FB 71 250 Chicago Texas
    7-14 JORDAN WHITE WR 73 215 Arizona Western Michigan
    7-15 TERRANCE GANAWAY RB 73 240 Dallas Baylor
    7-16 CHAD DIEHL FB 74 260 Minnesota Clemson
    7-17 ADONIS THOMAS RB 70 185 NewYorkJets Toledo
    7-18 DAMON HARRISON DT 74 340 Seattle William Penn
    7-19 KHEESTON RANDALL DT 77 295 SanDiego Texas
    7-20 DWIGHT JONES WR 76 225 Tennessee North Carolina
    7-21 GREG CHILDS WR 75 217 Cincinnati Arkansas
    7-22 FRANK ALEXANDER DE 76 255 Atlanta Oklahoma
    7-23 SCOTT SOLOMON DE 75 270 Detroit Rice
    7-24 MARQUIS MAZE WR 70 182 Pittsburgh Alabama
    7-25 TREVOR GUYTON DE 75 280 Denver California
    7-26 GEORGE BRYAN TE 77 265 Houston North Carolina State
    7-27 RYAN HOUSTON FB 74 245 NewOrleans North Carolina
    7-28 JACQUIES SMITH DE 76 255 GreenBay Missouri
    7-29 CHRIS GALIPPO ILB 74 250 Baltimore Southern California
    7-30 CHRIS OWUSU WR 74 200 SanFrancisco Stanford
  3. Staxxxx

    Staxxxx Member

    293 Messages
    19 Likes Received

    RND-Pk Fname Lname Pos P1Grade Height wt Team School
    1-14 DRE KIRKPATRICK CB 7.6 75 192 Dallas Alabama
    2-13 BRANDON WASHINGTON OG 6.9 76 320 Dallas Miami
    3-19 WHITNEY MERCILUS DE 6.5 76 265 Dallas Illinois
    4-18 ASA JACKSON CB 6.2 70 188 Dallas California Poly
    5-17 RHETT ELLISON TE 5.9 77 250 Dallas Southern California
    6-16 DEREK WOLFE DE 5.8 77 300 Dallas Cincinnati
    7-15 TERRANCE GANAWAY RB 5.7 73 240 Dallas Baylor

    Dallas's Top 5 at Pick 1
    WeightedGrade Player Pos

    Dallas's Top 5 at Pick 2
    WeightedGrade Player Pos
    6.83 BEN JONES OC
    Tie 6.81 ANDRE BRANCH DE

    Top 5 at pick 3
    WeightedGrade Player Pos

    Top 5 at pick 4
    WeightedGrade Player Pos

    Top 5 at pick 5
    WeightedGrade Player Pos
    5.91 CHASE FORD TE
    5.91 DAN HERRON RB

    Top 5 at pick 6
    WeightedGrade Player Pos

    Top 5 at pick 7
    WeightedGrade Player Pos

    Thanks guys
  4. Primetime42

    Primetime42 Well-Known Member

    3,383 Messages
    658 Likes Received
    Nice work. If our draft fell like that I'd take it, run and never look back.
  5. robert70x7

    robert70x7 Well-Known Member

    1,075 Messages
    34 Likes Received
    Nice work. It's obvious you put a lot into this and I really appreciate when people try to accomplish this.

    A couple of the players I have seen graded differently (Kheeston Randall, for example, I have ranked between the 3rd and 4th rounds).

    You'll probably have to toy with the number of players drafted throughout the draft (DraftScout has a positional breakdown for the averages over the past 10 years).

    Good job, I'll look at it more in depth tomorrow.
  6. RS12

    RS12 Well-Known Member

    21,730 Messages
    8,884 Likes Received
    I like the bottom better than the top.
  7. robert70x7

    robert70x7 Well-Known Member

    1,075 Messages
    34 Likes Received
    So if DeCastro was there, the top would look like this.....

  8. batman36

    batman36 Active Member

    691 Messages
    181 Likes Received
    Nice effort. Thanks!
  9. Staxxxx

    Staxxxx Member

    293 Messages
    19 Likes Received
    Thanks I appreciate all feedback. I'll look for the positional breakdown on draft scout. I don't know much about Kheeston Randall but I'll look around for info on him an manually adjust if what I find supports it. I'll be the first to admit that my knowledge on this draft at this point isn't nearly as high as some on this board.
  10. Staxxxx

    Staxxxx Member

    293 Messages
    19 Likes Received
    I'd like to hear your thoughts on what could be improved at the top. I think the biggest issues I'm seeing there are:
    • Kirkpatrick sliding all the way to us. This one has me perplexed. Due to his recent troubles and Mayock ranking him as the number 5 CB I docked his original grade a full point. Basically putting him in a tie with Janoris Jenkins. When I did that he was falling to the end of the first round which I thought was way too far. I then gave him 0.2 back which have virtually no effect so I gave him another 0.1 which pushed him up to us. I have since given him another 0.3 thinking I've still probably dinged him too hard and he still lands on us. If I give him any more he goes 3rd which I think is a little high for him right now given the negative buzz he has right now. I'm not sure how many top 5 or 10 teams would be ok blowing that high of a pick on a guy who does something that stupid right before the biggest job interview of his young life. For now I'm going to leave it alone and try to figure out some sort of character flag system that's weighted by team and round to deal with that type of stuff.
    • I think Tannehill might be a little more over drafted than I wanted. I think I need to adjust the QB round 1 reach settings a bit.
    • I think Poe might be sliding a little too far. I think I need to tweek the reach factor on true 3-4 NTs
    • I need to rework the 34 vs 43 front 7 positional logic into the system a little better
  11. rash

    rash Member

    859 Messages
    3 Likes Received
    This is brilliant Staxxx!

    I myself am trying to teach myself the programming language PHP and database management system MySQL...so I can say I really appreciate the effort you put into this. So far everything I have learned based off rote learning hasn't necessarily translated into great hands-on database/programming skills. Needless to say, I'm struggling :eek::

    Any advice?

    Are you creating a draft web-site as well or just working with SQL?
  12. Staxxxx

    Staxxxx Member

    293 Messages
    19 Likes Received
    Thanks for the kind words. I've been programming .Net for a couple of years now so I can appreciate where your at. Though I really didn't know much more than some basic Select and Update type stuff I did have a little bit of a head start from my .Net programming.
    When the company first asked me to start programming they sent me to a couple of boot camps where their goal is to cram about a years worth of material down your throat in a couple of weeks so you can get the industry certifications. If that's not the definition of rote learning I don't know what is. I passed the certifications and they expected me to come back and hit the ground running. Of course I didn't, I struggled with a couple of projects that were way over my head and I'd really like to pretend that I never had anything to do with them. But I stuck with it and in the last year really hit my stride with the programming. Rote learning just doesn't stick with me. I have to get my hands dirty and figure thing out, not just the how but the why too. So with the switch to SQL I decided to go with what I know works, hands on figuring things out. I am trying to it incorporate something I'm passionate about to help me push through the tough parts of the learning curve. So far I couldn't be happier with my decision.

    I'd like to get this to the point where I could build a web front end that other people could input their own parameters into, adjust draft boards, team needs boards and run drafts. I have lots of ideas about how I'd like to do it but I'm not sure I'll get that far before this years draft. Right now I'm building it all in SQL and when I get it to the point that as far as learning SQL I'm ready to move on to something else, I think I'll try on doing something like that.
  13. visionary

    visionary Well-Known Member

    11,583 Messages
    6,528 Likes Received
    good job, that is a lot of work

    if those were the options, i would pick the highlighted ones

    IMO the focus has to be OL and front 7, then CB

    if our front 7 is not the focus this off season then we deserve what will happen next season
  14. cobra

    cobra Salty Bastard

    3,134 Messages
    0 Likes Received
    Thanks for the effort.

    You don't have Devon Wylie being drafted. Wow! I hope the Cowboys take this kid in Round 7 (or as early as needed to get him).
  15. Staxxxx

    Staxxxx Member

    293 Messages
    19 Likes Received
    Thanks for pointing that out. It looks like there was a glitch with the receivers. Wylie should have gone somewhere in the late 3 to early 5 range. Looks like he's not the only receiver either I see Chris Givens is undrafted as well. I'll see if I can't fix that tonight and run it agian.

    Thanks again this is exactly the reason I posted it here.
  16. Staxxxx

    Staxxxx Member

    293 Messages
    19 Likes Received
    Yes those were what it chose from at those picks or at least the top 5 at that time. For every pick it builds a 10 person draft board based on the top x amount of needs for the team drafting and players that fit those needs with the highest remaining base grades. Then it assigns those players a weighted grade that combines their base grade with several other factors including the round, the position, and how big of a positional need it is and then it chooses the player with the highest weighted grade.

    For example Ryan Tennehill has a base grade that places him in the top to middle of the second round but his weighted grade pushes him all the way up to Washington in the First which I think is too high. He benefits from Washington's desperate need for a QB and a first round premium that is usually placed on QBs.

    I have set it so that Dallas's top two needs are set equally to Guard and Corner. Followed by OLB and Center, then NT, ILB, DE in that order. Off the top of my head I don't remember how I set the rest but I think I have it FS, QB, TE, Slot Receiver, Running Back, SS, Tackle, WR

    I'd be interested to know what everyone thinks our needs should be.
  17. rash

    rash Member

    859 Messages
    3 Likes Received

    Good luck on the web-site, and if I can get up to par to the standards of a web-programmer, I would love to do some labor for your project.

    You mentioned this earlier and I have to say that I can not agree more-revolving your programming around a hobby or something you are passionate about makes it exponentially less arduous.

    I admire what you are doing and one of my goals is to actually make a fantasy football web-site (which is why I have been wanting to learn MySQL and PHP).
  18. RS12

    RS12 Well-Known Member

    21,730 Messages
    8,884 Likes Received
    IMO pass rush makes secondary. You could put Deion Sanders and Mike Haynes at corner and if the pass rush is mediocre they will still get beat. Only corner that excites me at all or that I think will be a difference maker is Clayborne who will go top 5. Not saying the others CBs wont be good but I am looking for a difference maker at 14 and to me Kirkpatrick isnt that guy. Also I dont see a guarenteed difference maker at pass rusher at 14. I'd concentrate on the trenches.
  19. jterrell

    jterrell Penguinite

    22,952 Messages
    3,550 Likes Received
    Check out drafttek. They do this same thing basically.

    Cool stuff and kudos on a way to make a hobby a learning and professional experience.

    You can use PHP for the web front end and Perl as the back end crunching tool to basically emulate every web site that runs decently on the web.

    I know some ajax/ruby guys would disagree but I get sick of seeing 'Jax errors.

Share This Page