Discuss football with over 60,000 fans. Free Membership. Join now!

 FAQFAQ  RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

FootballsFuture.com Forum Index
FootballsFuture.com Home

I need some support ... data diggin'

 
Post new topic   Reply to topic    FootballsFuture.com Forum Index -> Kansas City Chiefs
View previous topic :: View next topic  
Author Message
KC_Guy


Joined: 07 Jan 2008
Posts: 7172
Location: Brussels, Belgium
PostPosted: Thu Jan 17, 2013 7:34 pm    Post subject: I need some support ... data diggin' Reply with quote

As you may have noticed I'm getting into my pre-season mood. Digging data, doing cap simulations and all that stuff.

A project I wanted to get into for quite a while is setting up a database that on the one hand helps to keep track with the real world but on the other allows to run simulations. Roster size, cap limits, impact of roster moves and all the like. Updated continuously, so you always have a sound real world basis to do simulations (a noble term for mock drafts Wink) from.

However, to do it properly and the way I like it is extremely time consuming. Just putting in the data to make it neat and shiny is quite a lot of work.

Thus I'd like to ask for your support to provide me the data in an appropriate form so I can focus on programming the database itself.

All you'll need is your own copy of MS Access, some time, some patience, and some well coordinated fingers to hit the keyboard. If you know a thing or two about MS Access let me know, if not ... well, I'll tell you what to do.

Those who help will be the first to get access to the product - which I anticipate to be public domain once I'm satisfied with its performance.

So - who's willing tosign up on that endeavour??

Oh, lest I forget: I anticipate this thing to last well into the 2014 pre-season. That's why I ask for patience.
_________________
Be it known that this day, January 4, be known as Reid Friday from now until ... well, as long as it lasts ...
Back to top
View user's profile Send private message Send e-mail
nicfre2011


Joined: 15 Mar 2011
Posts: 6560
Location: SC
PostPosted: Thu Jan 17, 2013 8:22 pm    Post subject: Reply with quote

KCG,
I sent you a PM.

Also, when I was working on my mock offseason, I pulled the 2013 total cap charge for players that will be under contract for 2013 from spotrac.com

Jeff Allen, OG, $1,055,415.00
Javier Arenas, CB, $1,003,750.00
Jon Asamoah, OG, $858,030.00
Allen Bailey, DE, $718,986.00
Steven Baker, OT, $405,000.00
Jonathan Baldwin, WR, $2,189,528.00
Josh Bellamy, WR, $480,000.00
Eric Berry, S, $10,154,000.00
Kevin Boss, TE, $3,466,667.00
Steve Breaston, WR, $5,000,000.00
Jalil Brown, CB, $682,325.00
Matt Cassel, QB, $9,825,000.00
Jamaal Charles, RB, $3,333,333.00
Terrance Copper, WR, $840,000.00
Patrick DiMarco, FB, $480,000.00
Shaun Draughn, RB, $480,000.00
Nate Eachus, FB, $480,000.00
Brandon Flowers, CB, $9,600,000.00
Cyrus Gray, RB, $497,000.00
Cory Greenwood, LB, $656,250.00
Jose Gumbs, S, $405,000.00
Tamba Hali, LB, $15,500,000.00
Tysyn Hartman, S, $480,000.00
Justin Houston, LB, $747,812.00
Rodney Hudson, C, $956,209.00
Tyson Jackson, DE, $17,245,000.00
Derrick Johnson, LB, $2,500,000.00
Kendrick Lewis, S, $681,725.00
Dexter McCluster, WR/RB, $1,400,000.00
De’Quan Menzie, S, $528,613.00
Tony Moeaki, TE, $746,662.00
Jamar Newsome, WR, $480,000.00
Luke Patterson, NT, $405,000.00
Dontari Poe, NT, $2,572,728.00
Jerrell Powe, NT, $607,368.00
Rich Ranglin, OG, $390,000.00
Ricky Stanzi, QB, $619,763.00
Donald Stephenson, OT, $639,375.00
Andy Studebaker, LB, $2,055,000.00
Ryan Succop, K, $2,400,000.00
Matt Szymanski, K, $405,000.00
Alex Tanney, QB, $480,000.00
Neiko Thorpe, CB/S, $480,000.00
Anthony Toribio, NT, $555,000.00
Dustin Waldron, OT, $405,000.00
Eric Winston, OT, $7,000,000.00
Devon Wylie, WR, $593,850.00

Edit : 47 players under contract, 2013 contracts total : $113,484,389.00.
_________________


Thanks to ryknowssd for the sig!

Trent Baalke for 2013 NFL executive of the year.


Last edited by nicfre2011 on Fri Jan 18, 2013 10:47 am; edited 2 times in total
Back to top
View user's profile Send private message
KC_Guy


Joined: 07 Jan 2008
Posts: 7172
Location: Brussels, Belgium
PostPosted: Thu Jan 17, 2013 8:28 pm    Post subject: Reply with quote

The Chiefs have 46 under contract ... and as promised, I'll have a look at the figures.

PM an e-mail-addy and I'll send you something
_________________
Be it known that this day, January 4, be known as Reid Friday from now until ... well, as long as it lasts ...
Back to top
View user's profile Send private message Send e-mail
nicfre2011


Joined: 15 Mar 2011
Posts: 6560
Location: SC
PostPosted: Thu Jan 17, 2013 9:05 pm    Post subject: Reply with quote

Edit : Updated players originally omitted.

I think spotrac.com updated some of the contracts between the time I started pulling the contract numbers and now. I remember Anthony Toribio was noted as a RFA for example. Patrick DiMarco was another player I remember being listed as an RFA in 2013. Here are the players I missed or were not signed when I started :

Anthony Toribio, NT, $555,000.00
Dustin Waldron, OT, $405,000.00
Luke Patterson, NT, $405,000.00
Rich Ranglin, OG, $390,000.00
Patrick DiMarco, FB, $480,000.00
Jamar Newson, WR, $480,000.00
Jose Gumbs, S, $405,000.00 (Edit)
Matt Szymanski, K, $405,000.00 (Edit)

The total for the above contracts comes out to an additional $3,525,000.00 (Edit)
_________________


Thanks to ryknowssd for the sig!

Trent Baalke for 2013 NFL executive of the year.


Last edited by nicfre2011 on Fri Jan 18, 2013 8:18 am; edited 2 times in total
Back to top
View user's profile Send private message
KC_Guy


Joined: 07 Jan 2008
Posts: 7172
Location: Brussels, Belgium
PostPosted: Thu Jan 17, 2013 9:07 pm    Post subject: Reply with quote

so who do you believe?? Wink
_________________
Be it known that this day, January 4, be known as Reid Friday from now until ... well, as long as it lasts ...
Back to top
View user's profile Send private message Send e-mail
nicfre2011


Joined: 15 Mar 2011
Posts: 6560
Location: SC
PostPosted: Thu Jan 17, 2013 9:09 pm    Post subject: Reply with quote

KC_Guy wrote:
so who do you believe?? Wink


What are Gumba and Szymanski's 2013 contracts charges?
_________________


Thanks to ryknowssd for the sig!

Trent Baalke for 2013 NFL executive of the year.
Back to top
View user's profile Send private message
KC_Guy


Joined: 07 Jan 2008
Posts: 7172
Location: Brussels, Belgium
PostPosted: Fri Jan 18, 2013 3:24 am    Post subject: Reply with quote

nicfre2011 wrote:
KC_Guy wrote:
so who do you believe?? Wink


What are Gumba and Szymanski's 2013 contracts charges?


minimum pay for 1st year players: 405,000$

The Safety's name is Gumbs ...
_________________
Be it known that this day, January 4, be known as Reid Friday from now until ... well, as long as it lasts ...
Back to top
View user's profile Send private message Send e-mail
KC_Guy


Joined: 07 Jan 2008
Posts: 7172
Location: Brussels, Belgium
PostPosted: Tue Jan 29, 2013 6:13 pm    Post subject: Reply with quote

Anyone else willing to help out?

If you don't have/know Access - I'm pretty sure I can find some work for you using Excel ... or provide raw data from the web ...
_________________
Be it known that this day, January 4, be known as Reid Friday from now until ... well, as long as it lasts ...
Back to top
View user's profile Send private message Send e-mail
KC_Guy


Joined: 07 Jan 2008
Posts: 7172
Location: Brussels, Belgium
PostPosted: Fri Feb 08, 2013 5:09 pm    Post subject: Reply with quote

anyone willing to provide me a list of links to KC Chiefs' facebook profiles???
_________________
Be it known that this day, January 4, be known as Reid Friday from now until ... well, as long as it lasts ...
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   

Post new topic   Reply to topic    FootballsFuture.com Forum Index -> Kansas City Chiefs All times are GMT - 4 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




Powered by phpBB © 2001, 2005 phpBB Group