The Mockinator draft simulator full 7 Rounds

[Staxxxx]

A few months ago I posted about a learning project I was working on. In order to teach myself SQL databases I decided to build a draft simulator which I've affectionately named the Mockinator. After tens of thousands of simulations and countless hours of tweaking I thought I'd post it's final draft. (not because I'm happpy with it, I just ran out of time).

Dallas 7 rounds
RND - Pick - TEAM - PLAYER - POS
1 - 14 - Dallas - MICHAEL BROCKERS - DE34
2 - 13 - Dallas - BRUCE IRVIN - OLB34
3 - 18 - Dallas - RYAN BROYLES - WR
4 - 18 - Dallas - CHASE MINNIFIELD - CB
4 - 40 - Dallas - SENIO KELEMETE - OG
5 - 17 - Dallas - RHETT ELLISON - TE
6 - 16 - Dallas - QUENTON SAULSBERRY - OC
7 - 15 - Dallas - TERRENCE FREDERICKS - CB

Round 1
RND - Pick - TEAM - PLAYER - POS
1 - 1 - Indianapolis - ANDREW LUCK - QB
1 - 2 - Washington - ROBERT GRIFFIN III - QB
1 - 3 - Minnesota - MATT KALIL - OT
1 - 4 - Cleveland - TRENT RICHARDSON - RB
1 - 5 - TampaBay - MORRIS CLAIBORNE - CB
1 - 6 - StLouis - JUSTIN BLACKMON - WR
1 - 7 - Jacksonville - STEPHON GILMORE - CB
1 - 8 - Miami - RYAN TANNEHILL - QB
1 - 9 - Carolina - FLETCHER COX - DT43
1 - 10 - Buffalo - RILEY REIFF - OT
1 - 11 - KansasCity - LUKE KUECHLY - ILB
1 - 12 - Seattle - MARK BARRON - FS
1 - 13 - Arizona - MELVIN INGRAM - OLB34
1 - 14 - Dallas - MICHAEL BROCKERS - DE34
1 - 15 - Philadelphia - DONTARI POE - DT43
1 - 16 - NewYorkJets - MICHAEL FLOYD - WR
1 - 17 - Cincinnati - QUINTON COPLES - DE43
1 - 18 - SanDiego - DAVID DECASTRO - OG
1 - 19 - Chicago - CHANDLER JONES - DE43
1 - 20 - Tennessee - DRE KIRKPATRICK - CB
1 - 21 - Cincinnati - DOUG MARTIN - RB
1 - 22 - Cleveland - STEPHEN HILL - WR
1 - 23 - Detroit - WHITNEY MERCILUS - DE43
1 - 24 - Pittsburgh - DONT'A HIGHTOWER - ILB
1 - 25 - Denver - JEREL WORTHY - DT43
1 - 26 - Houston - CORDY GLENN - OT
1 - 27 - NewEngland - HARRISON SMITH - FS
1 - 28 - GreenBay - SHEA MCCLELLIN - OLB34
1 - 29 - Baltimore - PETER KONZ - OC
1 - 30 - SanFrancisco - KENDALL WRIGHT - WR
1 - 31 - NewEngland - COURTNEY UPSHAW - DE43
1 - 32 - NewYorkGiants - JONATHAN MARTIN - OT

Round 2
RND - Pick - TEAM - PLAYER - POS
2 - 1 - StLouis - JOSH ROBINSON - CB
2 - 2 - Indianapolis - COBY FLEENER - TE
2 - 3 - Minnesota - DEVON STILL - DT43
2 - 4 - TampaBay - DAVID WILSON - RB
2 - 5 - Cleveland - NICK PERRY - DE43
2 - 6 - Jacksonville - VINNY CURRY - DE43
2 - 7 - StLouis - LAVONTE DAVID - OLB43
2 - 8 - Carolina - JANORIS JENKINS - CB
2 - 9 - Buffalo - JOSH NORMAN - CB
2 - 10 - Miami - BOBBIE MASSIE - OT
2 - 11 - Seattle - KEVIN ZEITLER - OG
2 - 12 - KansasCity - RUEBEN RANDLE - WR
2 - 13 - Dallas - BRUCE IRVIN - OLB34
2 - 14 - Philadelphia - AMINI SILATOLU - OG
2 - 15 - NewYorkJets - MIKE ADAMS - OT
2 - 16 - NewEngland - BRANDON THOMPSON - DT43
2 - 17 - SanDiego - BRANDON BROOKS - OG
2 - 18 - Chicago - BRANDON WEEDEN - QB
2 - 19 - Philadelphia - DWAYNE ALLEN - TE
2 - 20 - Tennessee - A.J. JENKINS - WR
2 - 21 - Cincinnati - JAMELL FLEMING - CB
2 - 22 - Detroit - KELECHI OSEMELE - OG
2 - 23 - Atlanta - LAMAR MILLER - RB
2 - 24 - Pittsburgh - MOHAMED SANU - WR
2 - 25 - Denver - LAMICHAEL JAMES - RB
2 - 26 - Houston - ALSHON JEFFERY - WR
2 - 27 - GreenBay - MARKELLE MARTIN - FS
2 - 28 - Baltimore - RONNELL LEWIS - OLB34
2 - 29 - SanFrancisco - BROCK OSWEILER - QB
2 - 30 - NewEngland - CASEY HAYWARD - CB
2 - 31 - NewYorkGiants - BOBBY WAGNER - ILB

Round 3
RND - Pick - TEAM - PLAYER - POS
3 - 1 - Indianapolis - BRANDON BOYKIN - CB
3 - 2 - StLouis - ANDRE BRANCH - DE43
3 - 3 - Minnesota - BRANDON WASHINGTON - OG
3 - 4 - Cleveland - DEREK WOLFE - DT43
3 - 5 - TampaBay - CAM JOHNSON - DE43
3 - 6 - Washington - BEN JONES - OC
3 - 7 - Jacksonville - TRUMAINE JOHNSON - FS
3 - 8 - Buffalo - ORSON CHARLES - TE
3 - 9 - Miami - ALAMEDA TA'AMU - DT43
3 - 10 - Miami - MARVIN JONES - WR
3 - 11 - KansasCity - T.Y. HILTON - WR
3 - 12 - Seattle - TRAVIS LEWIS - OLB43
3 - 13 - Houston - KENDALL REYES - DE34
3 - 14 - NewYorkJets - DEVON WYLIE - WR
3 - 15 - SanDiego - MITCHELL SCHWARTZ - OT
3 - 16 - Chicago - ALFONZO DENNARD - CB
3 - 17 - Arizona - ISAIAH PEAD - RB
3 - 18 - Dallas - RYAN BROYLES - WR
3 - 19 - Tennessee - DEMARIO DAVIS - OLB43
3 - 20 - Cincinnati - ZACH BROWN - OLB43
3 - 21 - Atlanta - JAMES HANNA - TE
3 - 22 - Detroit - ROBERT TURBIN - RB
3 - 23 - Pittsburgh - KIRK COUSINS - QB
3 - 24 - Denver - CHRIS POLK - RB
3 - 25 - Philadelphia - NICK FOLES - QB
3 - 26 - NewOrleans - CHRISTIAN THOMPSON - FS
3 - 27 - GreenBay - BRANDON TAYLOR - SS
3 - 28 - Baltimore - JAMES-MICHAEL JOHNSON - ILB
3 - 29 - SanFrancisco - GEORGE ILOKA - FS
3 - 30 - NewEngland - SEAN SPENCE - OLB43
3 - 31 - NewYorkGiants - AUDIE COLE - OLB43
3 - 32 - Oakland - BRANDON MOSLEY - OT

 

[Staxxxx]

Round 4
RND - Pick - TEAM - PLAYER - POS
4 - 1 - StLouis - MATT MCCANTS - OT
4 - 2 - Indianapolis - EVAN RODRIGUEZ - FB
4 - 3 - Minnesota - NICK TOON - WR
4 - 4 - Houston - LUCAS NIX - OG
4 - 5 - Cleveland - NATE POTTER - OT
4 - 6 - Jacksonville - BRIAN QUICK - WR
4 - 7 - Washington - JOE ADAMS - WR
4 - 8 - Miami - TYRONE CRAWFORD - DE43
4 - 9 - Carolina - TONY BERGSTROM - OG
4 - 10 - Buffalo - DEVON RAMSAY - FB
4 - 11 - Seattle - MYCHAL KENDRICKS - ILB
4 - 12 - KansasCity - JEFF ALLEN - OG
4 - 13 - Denver - JAYRON HOSLEY - CB
4 - 14 - Washington - GREG CHILDS - WR
4 - 15 - SanDiego - BRADIE EWING - FB
4 - 16 - Chicago - EMMANUEL ACHO - ILB
4 - 17 - Arizona - ANDREW DATKO - OT
4 - 18 - Dallas - CHASE MINNIFIELD - CB
4 - 19 - Philadelphia - MALIK JACKSON - DE43
4 - 20 - Tennessee - JARIUS WRIGHT - WR
4 - 21 - Cincinnati - JARED CRICK - DE43
4 - 22 - Detroit - MICHAEL BREWSTER - OC
4 - 23 - Cleveland - CYRUS GRAY - RB
4 - 24 - Pittsburgh - DAJOHN HARRIS - DE34
4 - 25 - Denver - MICHAEL EGNEW - TE
4 - 26 - Houston - LADARIUS GREEN - TE
4 - 27 - NewOrleans - KELCIE MCCRAY - SS
4 - 28 - GreenBay - KEENAN ROBINSON - ILB
4 - 29 - Buffalo - MARVIN MCNUTT - WR
4 - 30 - SanFrancisco - BERNARD PIERCE - RB
4 - 31 - NewEngland - DAVID MOLK - OC
4 - 32 - NewYorkGiants - MIKE MARTIN - DT43
4 - 33 - Minnesota - TRENTON ROBINSON - FS
4 - 34 - Oakland - CHRIS GIVENS - WR
4 - 35 - Baltimore - ASA JACKSON - CB
4 - 36 - NewYorkGiants - AKIEM HICKS - DE43
4 - 37 - GreenBay - AARON HENRY - FS
4 - 38 - GreenBay - KYLE ILBER - OLB34
4 - 39 - Minnesota - DEREK DENNIS - OG
4 - 40 - Dallas - SENIO KELEMETE - OG

Round 5
RND - Pick - TEAM - PLAYER - POS
5 - 1 - Indianapolis - TONY DYE - SS
5 - 2 - Denver - B.J COLEMAN - QB
5 - 3 - Minnesota - MARKUS ZUSEVICS - OT
5 - 4 - Cleveland - OMAR BOLDEN - CB
5 - 5 - TampaBay - JAYE HOWARD - DT43
5 - 6 - Washington - DOMINIQUE HAMILTON - DE34
5 - 7 - Jacksonville - BRETT ROY - DT43
5 - 8 - Carolina - JANZEN JACKSON - FS
5 - 9 - Buffalo - PHILIP BLAKE - OC
5 - 10 - Miami - CORYELL JUDIE - CB
5 - 11 - KansasCity - JOSH CHAPMAN - DT34
5 - 12 - Buffalo - DEVIER POSEY - WR
5 - 13 - Oakland - DWIGHT BENTLEY - CB
5 - 14 - SanDiego - ZEBRIE SANDERS - OT
5 - 15 - Chicago - BILLY WINN - DE43
5 - 16 - Arizona - MICAH PELLERIN - CB
5 - 17 - Dallas - RHETT ELLISON - TE
5 - 18 - Philadelphia - MARCUS FORSTON - DT43
5 - 19 - NewYorkJets - BRANDON LINDSEY - OLB34
5 - 20 - Tennessee - DAVID SNOW - OC
5 - 21 - Cincinnati - JOE LOONEY - OG
5 - 22 - Atlanta - KELVIN BEACHUM - OG
5 - 23 - Detroit - MIKE HARRIS - CB
5 - 24 - Pittsburgh - ROBERT GOLDEN - CB
5 - 25 - Cleveland - AARON CORP - QB
5 - 26 - Houston - B.J. CUNNINGHAM - WR
5 - 27 - NewOrleans - COTY SENSABAUGH - CB
5 - 28 - GreenBay - ANTONIO ALLEN - SS
5 - 29 - Baltimore - JOSH KADDU - ILB
5 - 30 - SanFrancisco - LEVY ADCOCK - OT
5 - 31 - Cincinnati - TAUREN POOLE - RB
5 - 32 - NewYorkGiants - JERRY FRANKLIN - ILB
5 - 33 - Oakland - JAKE BEQUETTE - DE43
5 - 34 - Baltimore - KHEESTON RANDALL - DE34
5 - 35 - Indianapolis - TREVOR GUYTON - DE34

Round 6
RND - Pick - TEAM - PLAYER - POS
6 - 1 - StLouis - TYDREKE POWELL - DT43
6 - 2 - Philadelphia - CHRIS GREENWOOD - CB
6 - 3 - Washington - HEBRON FANGUPO - DT34
6 - 4 - TampaBay - MILES BURRIS - OLB43
6 - 5 - Minnesota - KEITH TANDY - CB
6 - 6 - Jacksonville - DANNY TREVATHAN - OLB43
6 - 7 - Arizona - JURON CRINER - WR
6 - 8 - Buffalo - G.J. KINNE - QB
6 - 9 - NewOrleans - NIGEL BRADHAM - OLB43
6 - 10 - Carolina - TOMMY STREETER - WR
6 - 11 - Seattle - JARRETT BOYKIN - WR
6 - 12 - KansasCity - DONTE PAIGE-MOSS - OLB34
6 - 13 - SanDiego - SAMMY BROWN - OLB34
6 - 14 - Chicago - CHRIS JACOBSON - OG
6 - 15 - Arizona - JEFF FULLER - WR
6 - 16 - Dallas - QUENTON SAULSBERRY - OC
6 - 17 - NewYorkJets - OLIVIER VERNON - OLB34
6 - 18 - Denver - ERIC PAGE - WR
6 - 19 - Oakland - VICK BALLARD - RB
6 - 20 - Tennessee - LEONARD JOHNSON - CB
6 - 21 - Cincinnati - LANCE LEWIS - WR
6 - 23 - Atlanta - JUSTIN BETHAL - CB
6 - 24 - Pittsburgh - CHIGBO ANUNOBY - DT34
6 - 25 - Philadelphia - T.J. GRAHAM - WR
6 - 26 - Houston - RUSSELL WILSON - QB
6 - 27 - Miami - BRANDON BOLDEN - RB
6 - 28 - GreenBay - SHAUN PRATER - CB
6 - 29 - Baltimore - RYAN LINDLEY - QB
6 - 30 - SanFrancisco - JEREMY LANE - CB
6 - 31 - Philadelphia - JAMES BROWN - OT
6 - 32 - NewYorkGiants - DESMOND MARROW - CB
6 - 33 - NewYorkJets - JEFFERY DEMPS - RB
6 - 34 - NewYorkJets - DONNIE FLETCHER - CB
6 - 35 - Cleveland - ROBERT BLANTON - CB
6 - 36 - Cleveland - CODY PEARCY - WR
6 - 37 - Indianapolis - EMANUEL DAVIS - CB
6 - 38 - Carolina - DAN HERRON - RB

Round 7
RND - Pick - TEAM - PLAYER - POS
7 - 1 - Indianapolis - BRAD SMELLEY - TE
7 - 2 - StLouis - EMIL IGWENAGU - FB
7 - 3 - Minnesota - JULIAN MILLER - DE43
7 - 4 - Cleveland - CHANDLER HARNISH - QB
7 - 5 - TampaBay - JAMES CARMON - OT
7 - 6 - Washington - AL NETTER - OG
7 - 7 - Indianapolis - CASE KEENUM - QB
7 - 8 - Miami - COREY MOSLEY - FS
7 - 9 - Carolina - MIKE DANIELS - DT43
7 - 10 - Buffalo - KELLEN MOORE - QB
7 - 11 - KansasCity - JOSH CHICHESTER - TE
7 - 12 - Detroit - CAMERON CHISM - CB
7 - 13 - Chicago - TANK CARDER - OLB43
7 - 14 - Arizona - JAYMES BROOKS - OG
7 - 15 - Dallas - TERRENCE FREDERICKS - CB
7 - 16 - Minnesota - JERMAINE KEARSE - WR
7 - 17 - GreenBay - CODY JOHNSON - FB
7 - 18 - Seattle - TREVIN WADE - CB
7 - 19 - SanDiego - RYAN STEED - CB
7 - 20 - Tennessee - DELANO JOHNSON - DE43
7 - 21 - Jacksonville - DALE MOSS - WR
7 - 22 - Atlanta - JORDAN WHITE - WR
7 - 23 - Detroit - JERRELL HARRIS - OLB43
7 - 24 - Pittsburgh - DWIGHT JONES - WR
7 - 25 - NewYorkJets - MATT AUSTIN - WR
7 - 26 - Houston - TRAMAIN THOMAS - FS
7 - 27 - NewOrleans - CHRIS RAINEY - WR
7 - 28 - GreenBay - CHRIS MARVE - ILB
7 - 29 - Baltimore - MARQUIS MAZE - WR
7 - 30 - SanFrancisco - DARIUS HANKS - WR
7 - 31 - KansasCity - DERRIUS BROOKS - CB
7 - 32 - NewYorkGiants - TERRANCE GANAWAY - RB
7 - 33 - Pittsburgh - ADRIAN ROBINSON - OLB34
7 - 34 - GreenBay - WILLIAM VLACHOS - OC
7 - 35 - NewYorkJets - ADONIS THOMAS - RB
7 - 36 - GreenBay - DARRON THOMAS - QB
7 - 37 - NewYorkJets - SEAN RICHARDSON - SS
7 - 38 - Cleveland - BOBBY RAINEY - RB
7 - 39 - Pittsburgh - TOM COMPTON - OT
7 - 40 - Cleveland - SHAWN LOISEAU - OLB43
7 - 41 - Pittsburgh - CHARLES MITCHELL - SS
7 - 42 - Atlanta - FRANK ALEXANDER - DE43
7 - 43 - SanDiego - LAQUINTON EVANS - WR
7 - 44 - Buffalo - JERICO NELSON - SS
7 - 45 - StLouis - MARC TYLER - RB
7 - 46 - Indianapolis - JACQUIES SMITH - OLB34

 

[robert70x7]

Thank you for posting this. I can't imagine all the time and effort that went into it. I like this better than some of the drafts that DraftTek spit out. You obviously knew what you were doing!

 

[Staxxxx]

Thank you for posting this. I can't imagine all the time and effort that went into it. I like this better than some of the drafts that DraftTek spit out. You obviously knew what you were doing!

Thanks for the kind words. I'm not sure I did know what I was doing but I sure figured a lot of stuff out during the process.:laugh2:
There are a lot of great posters on this board that post a lot of great information and a lot of that input went into this.

 

[JoeyBoy718]

I actually like this draft for the Boys more than any other drafts I've seen on here. I like a big NT in the first. Call me crazy but I wouldn't mind getting Poe in the first and possibly trading down in doing so. I think Irvin is a steal at #45. Broyles is a good pick up in the 3rd. I don't think we need to spend a super high pick on interior OL. Maybe I'm in the minority. I honestly think this team likes Costa, and I think they hope Arkin will be the future. Costa just really needs to improve on his snaps or else he'd be better off as a OG.

 

[jswalker1981]

Sign me up for this draft. I think I emailed you a week or so ago in regards to SQL.

 

[Staxxxx]

Sign me up for this draft. I think I emailed you a week or so ago in regards to SQL.

Thanks I apologize I must have missed your email if it's still relevant go ahead and resend it I'll keep an eye out for it.

 

[xwalker]

Good work! I think you nailed some picks like Leonard Johnson in the 6th, not the 3rd/4th.

Since it's earier for me to analyze your mock than to create one myself, here are a few thoughts:

Brockers - IMO, Dallas believes that DeCasto can play OC in which case they would not pass him up for Brockers.
Josh Norman - Lower, IMO.
Irvin - Not shocked.
Hayward - Lower, IMO.
Branch - Much Higher, IMO.
Wolfe - Maybe Higher.
Reyes - Higher, IMO.
Blake - Much Higher, Maybe 3rd round, IMO.
Jeffery Demps - He is not playing in 2012.

 

[Sledge]

Did the program have a chance to pick from kicker and punters ???

I cant find one selected in the rounds. I was interested to see if it was possible to see if we could claim Anger(P) in the 5th...

 

[Staxxxx]

Did the program have a chance to pick from kicker and punters ???

I cant find one selected in the rounds. I was interested to see if it was possible to see if we could claim Anger(P) in the 5th...

No I didn't get that far. I have special teams data in the database but didn't get as far as programming it into the draft. I just ran out of time. Maybe next year

 

[Staxxxx]

Thanks for the feedback.

Brockers - IMO, Dallas believes that DeCasto can play OC in which case they would not pass him up for Brockers.

Yeah I didn't see that until today. I only have DeCastro listed at Guard in my DB. Had I listed him at Center as well I think he might of been the pick. I'm not sure though. I'll have to change that and do a couple of runs to see what would have happened.

Irvin - Not shocked.

I don't think this one will happen due to character concerns. I had planned on putting in a way for it to deal with flags on players on a Team by Team basis as each team deals with flags differently but didn't bet that far.

Branch - Much Higher, IMO.

He has an upper 2nd round grade in the database but the recent rise of Chandler jones and the resurgance of Bruce Irvin are probably why he slid here. As of last week with the same grade he was consistently getting drafted in the top half of the 2nd and even ocassionally sneaking into the end of the first. More supply than demand I guess.

Reyes - Higher, IMO.

Same as above except in my Database he carried a mid to lower mid 2nd round grade.

Blake - Much Higher, Maybe 3rd round, IMO.

I gave him a late 3rd early 4th grade.

Jeffery Demps - He is not playing in 2012.

OOps :laugh1:

 

[67CowboysFan]

I just bookmarked this page. Can't wait to see how many you got right.