OT: Calling all MGOstatletes. I need help finding an NFL salary standard distribution (table)
Does anyone know where to find a NFL salary standard distribution or table? I'm working on a research project to find out what BCS programs would look like under the NFL's CBA. I have most of the necessary data, including the median salary. However, I'd like to have the standard deviation and/or table to get a sense how how much a 5 star, transfer, or grad transfer could command on the open market.
Additional notes (constructive feedback is always useful):
This is a what if, not a should be
Bullet points: including some of the primary factors.
- Salary caps by conference
- using conference revenue to establish salary caps
- Total conference revenue: 47% (nfl min.) for players, 53% (max) for Ath. Dept.
- cap floor: 89% min for a year. Roll over
- 95% conference cap avg for 10 year period
- 15.74% of total conference revenue for player benefits.
-long-term medical coverage, scholarships, worker's comp, unemployment etc.
- Using two teams for each P5 and G5 conference plus ND
- revenue and expense reports/ breakdown
--apparel contracts (cash and apparel from company are separate categories)
-- ticket sales, conferenece payouts, media, licensing/ branding/royalties, donations etc
-- Staff packages (HC, assistants, supports staff), equip/apparel, travel, promo etc.
April 15th, 2017 at 10:36 AM ^
You are probably going to have to make one yourself.
April 15th, 2017 at 10:43 AM ^
Not sure if there is time. Last day of classes is Tuesday!
April 15th, 2017 at 10:57 AM ^
If it's just for a paper do it for one team like the Lions. It's not perfect but it shouldn't be too hard and it will get your paper done.
April 15th, 2017 at 10:40 PM ^
Wait, did you just not as fun RDT yourself?
April 15th, 2017 at 11:10 AM ^
then going team by team from here seems doable:
http://www.spotrac.com/nfl/arizona-cardinals/cap/
or if you want their full contact amount instead of just their 2017 salary:
http://www.spotrac.com/nfl/contracts/
I agree with wesq's advice though if you don't know how web scraping tools work and don't have time to manually copy down all the team salaries.
April 15th, 2017 at 11:46 AM ^
I was able to cut an paste those into excel without any manipulation. I've tried to figure out web scraping tools before to no avail (in the 20 minutes I spent), but I'm curious why you would need to scrape that info if it is all laid out in table format already.
Do you have a good webscraper or webscraper tutorial that you recommend?
April 15th, 2017 at 12:43 PM ^
I've gotten used to scraping the data automatically so my brain automatically went to that method of acquiring the data. You're absolutely right though that copy/paste from tables is way quicker and more sensible in this case.
Also because you asked, I use the rvest package in R or beautifulsoup in python. I dont have a particular good tutorial offhand, but if I look and remember one I'll post it back here.
April 15th, 2017 at 12:57 PM ^
Oh wow. Thats huge. I spent the last hour putting them in cell by cell from sports trac. Thanks a lot. This saves me a good bit of time.
Google sheets also makes it really easy to scrape.
In A1 type =IMPORTHTML("http://www.websiteyouwant.com/page", "table", 1)
The last number is the number of the table on the page. So the menu might be a table as 1, something else as 2, then the data you want as 3. A little trial and error will get you there.
April 15th, 2017 at 11:10 AM ^
$10,500 per locker apparently
Yeah, but for all that, you get a decent TV and a locker which can be used as a navigational beacon for both seaborne and airborne craft, so there's that at least. How much of it you can actually use as a locker is what I am concerned about.
Solomon not at the freshmen walkout
Is he on campus? I know that he's not an EE.