Salary Cap Database (1 Viewer)

[ncwxpanther]

I am interested in starting a league that is based off of real world NFL player salaries. The USA today site is a great resource for Salaries, Bonuses, and Cap Values per player and team, but the amount of time it would take to manually import this info into a MyFL salary cap league would be exponential.

Does anyone know a good resource to import/export salary cap values from/to?

 

[Portis 26]

This is obviously complicated by the fact that there aren't straightforward annual salaries because of the whole bonuses being pro-rated thing, and often players will convert their entire annual salary one year into a bonus.

 

[ncwxpanther]

This is obviously complicated by the fact that there aren't straightforward annual salaries because of the whole bonuses being pro-rated thing, and often players will convert their entire annual salary one year into a bonus.

Good point, but I am really only interested in what that players cap value is against his NFL team for that year.

 

[Thorpe]

Wouldn't take that long to go team by team, year by year, and do a copy and paste of the cap $ for each player on that team. The trick is to paste the text into Notepad, and then cut and paste from Notepad to Excel. I'd say it would take 10 to 20 minutes to do all of 2007.

 

[AB in DC]

This is obviously complicated by the fact that there aren't straightforward annual salaries because of the whole bonuses being pro-rated thing, and often players will convert their entire annual salary one year into a bonus.

Good point, but I am really only interested in what that players cap value is against his NFL team for that year.

I don't think this is public information, unfortunately.A few months ago, NFLPA.org had a working link for about a week, but then it became password-protected. I wonder if the link ever got reactivated...

 

[GregR_2]

Wouldn't take that long to go team by team, year by year, and do a copy and paste of the cap $ for each player on that team. The trick is to paste the text into Notepad, and then cut and paste from Notepad to Excel. I'd say it would take 10 to 20 minutes to do all of 2007.

Sometimes going through notepad can give you problems getting the right information to go into columns. An easier way in this case would be:1. Open up Excel. Under the Data menu select "Import External Data -> New Web Query"

2. Cut and paste in the URL for a team and hit "Go". I.e. cut and paste in:

http://content.usatoday.com/sports/footbal...1&year=2007

which will bring up the Cardinals 2007 salaries.

3. Click on the yellow arrow next to the player salaries table, turning it into a green checkmark. Don't turn any of the others into checkmarks.

4. At the bottom right, hit "Import".

5. Tell it whichever cell you want it to go into.

It will import the data for you and get it all lined up properly in columns. You can also right click anywhere in the table and choose Refresh Data and it will reload it for you should the data get updated over time.

Once you've set this up once for each team, changing it for the next year's data would be easy. Just right click in each team's table and choose Edit Query and go change the URL from 2007 to 2008.

 

[massraider]

Geez, GregR, nicely done.

One thing about the USA Today data, IIRC, it doesn't do the current year. So the commish would have to use last year's data in any league he wanted to do.