The Football Data Warehouse

General talk about Dynasty Leagues.
Telperion
Player of the Year
Player of the Year
Posts: 2090
Joined: Mon Jul 22, 2013 6:14 am

The Football Data Warehouse

Postby Telperion » Thu Mar 19, 2015 9:26 am

Update:

I'm working on updating this with 2015 and 2016 data. I changed my collection methods which should make this a much more sustainable project in the future. Hopefully there will be a new release in the coming months, if I have time to complete it.

-----

I've undertaken a project to acquire and assemble football data, and I'd like to share the results with the forum. A lot of this you can get elsewhere, but not much of it can be had together like this.

Downloadable version:
https://drive.google.com/folder/d/0B0zE ... kwY1U/edit

Appendix

Here are some of the advanced metrics being calculated:

Code: Select all

Burst Score: =((0.5*[Broad])+(1.7*[Vert]))

Agility Score: =([20YdShuttle]+[3Cone])

Speed Score:
=SWITCH(TRUE(),
   ([Pos]="RB" || [Pos]="FB" || [Pos]="QB") && [Wgt]>0 && [40Yd]>0,
      (([Wgt]*200)/([40Yd]^4)),
   [Pos]="WR" && [Wgt]>0 && [40Yd]>0 && [Hgt]>0,
      ((([Wgt]*200)*(([Hgt]/73.5)^2)-[Hgt])/([40Yd]^4)),
   [Pos]="TE" && [Wgt]>0 && [40Yd]>0 && [Hgt]>0,
      ((([Wgt]*200)*(([Hgt]/76.4)^2)-[Hgt])/([40Yd]^4)),
0)

Athlete Score:
=SWITCH(TRUE(),
  [AdvMet]=TRUE(),
((([SpeedScore]*1.268)+([BurstScore])+(11.5*(((1-1/[AgilityScore]*100)*-1)^2)/6))^1.5)/65,
0)
Last edited by Telperion on Fri Jul 14, 2017 7:53 pm, edited 18 times in total.
- Don't waste your time on late round NFL draft picks: Success rates by NFL draft round and speed.
- Team(s): Team 1

User avatar
evorzan
All Pro
All Pro
Posts: 1572
Joined: Tue Jul 02, 2013 4:01 pm

Re: The Football Data Warehouse

Postby evorzan » Thu Mar 19, 2015 9:33 am

Thanks for this, compiling data is the long and hard part of the journey towards analyzing things yourself.
Follow me @evorzan on Twitter
Formerly posting as Steveeb

TheChicken
Captain
Captain
Posts: 803
Joined: Tue Mar 17, 2015 10:14 am

Re: The Football Data Warehouse

Postby TheChicken » Thu Mar 19, 2015 10:06 am

Many thanks for this it looks like some great data. Having some issues with the date format as I use dd/mm/yyyy and some dates are text rather than serial numbers ... but I'll be able to sort that out. Will start playing around with it.
99 problems but your 10 team league ain't one!

Telperion
Player of the Year
Player of the Year
Posts: 2090
Joined: Mon Jul 22, 2013 6:14 am

Re: The Football Data Warehouse

Postby Telperion » Thu Mar 19, 2015 10:39 am

TheChicken wrote:Many thanks for this it looks like some great data. Having some issues with the date format as I use dd/mm/yyyy and some dates are text rather than serial numbers ... but I'll be able to sort that out. Will start playing around with it.
Good catch, I standardized them with ISO-8601 format so they should work better across platforms and locales now.

The concatenated ID fields are obviously text/string/varchar but those are only for joining tables in Excel.
- Don't waste your time on late round NFL draft picks: Success rates by NFL draft round and speed.
- Team(s): Team 1

TheChicken
Captain
Captain
Posts: 803
Joined: Tue Mar 17, 2015 10:14 am

Re: The Football Data Warehouse

Postby TheChicken » Thu Mar 19, 2015 11:02 am

Excellent. This may take up most of my day tomorrow.

Not had a reason to upgrade to Excel 2013 ... until now maybe? Is PowerPivot the game changer it looks like?
99 problems but your 10 team league ain't one!

Telperion
Player of the Year
Player of the Year
Posts: 2090
Joined: Mon Jul 22, 2013 6:14 am

Re: The Football Data Warehouse

Postby Telperion » Thu Mar 19, 2015 11:12 am

TheChicken wrote:Excellent. This may take up most of my day tomorrow.

Not had a reason to upgrade to Excel 2013 ... until now maybe? Is PowerPivot the game changer it looks like?
Yes and no; Getting relational data in Excel opens up tons of possibilities if you have a lot of static data, but you can't enforce referential integrity so maintaining data that changes is challenging. It's available in 2010 so you don't need to upgrade.

All in all once you have it you'll wonder how you ever did without it.
- Don't waste your time on late round NFL draft picks: Success rates by NFL draft round and speed.
- Team(s): Team 1

TheChicken
Captain
Captain
Posts: 803
Joined: Tue Mar 17, 2015 10:14 am

Re: The Football Data Warehouse

Postby TheChicken » Thu Mar 19, 2015 11:33 am

Thanks for the info .... Unfortunately I'm still on 2007!
99 problems but your 10 team league ain't one!

Telperion
Player of the Year
Player of the Year
Posts: 2090
Joined: Mon Jul 22, 2013 6:14 am

Re: The Football Data Warehouse

Postby Telperion » Wed Mar 25, 2015 1:07 pm

2 updates:
- Online viewable sheet has been removed, it's not feasible to keep both that and the CSV's updated.
- Updated Metrics CSV to include Player Profiler data.
- Don't waste your time on late round NFL draft picks: Success rates by NFL draft round and speed.
- Team(s): Team 1

User avatar
dlf_jules
Administrator
Posts: 9044
Joined: Fri Apr 12, 2013 12:15 pm

Re: The Football Data Warehouse

Postby dlf_jules » Wed Mar 25, 2015 1:09 pm

Big thanks for sharing this!
Download the 2019 Cohort Report for free today!

User avatar
maxhyde
GOAT
GOAT
Posts: 10737
Joined: Thu Aug 08, 2013 10:06 pm
Location: Nashville

Re: The Football Data Warehouse

Postby maxhyde » Wed Mar 25, 2015 5:09 pm

Thanks alot for the time and effort...great data compilation
DLF HOF League 16 team PPR
QB: Brees, Bradford, Lock(3.07)
RB: David Johnson, Penny, Sanders(1.07), Montgomery(1.06), Love(2.07) Bernard, MLynch, Morris, TJLogan, Joe Williams, Shaun Wilson
WR: Jeffery,Cooper, Josh Gordon, Dede Westbrook, Cam Meredith, Brice Butler, Chester Rogers, Lockett, Switzer, Malone, Cain (IR)
TE: Gronk, Swaim, Maxx Williams

Dingram
All Pro
All Pro
Posts: 1614
Joined: Tue Apr 30, 2013 12:15 pm

Re: The Football Data Warehouse

Postby Dingram » Thu Mar 26, 2015 12:19 am

Just another reason why my apple products suck....

Telperion
Player of the Year
Player of the Year
Posts: 2090
Joined: Mon Jul 22, 2013 6:14 am

Re: The Football Data Warehouse

Postby Telperion » Fri Mar 27, 2015 4:38 pm

I updated the folder, all the duplicate players are removed and the data all-in-all is refined to have more accurate player data. I also got rid of the CSV's and instead wrote an export tool so any individual table can be dumped to a CSV if needed.

Also, the 2015 rookies are now imported and integrated.
- Don't waste your time on late round NFL draft picks: Success rates by NFL draft round and speed.
- Team(s): Team 1

Telperion
Player of the Year
Player of the Year
Posts: 2090
Joined: Mon Jul 22, 2013 6:14 am

Re: The Football Data Warehouse

Postby Telperion » Tue Mar 31, 2015 7:32 am

Some interesting historical numbers since 1990:

- The top 5 career leaders in standard scoring PPG with a minimum of 5 years experience are Aaron Rodgers, Steve Young, Peyton Manning, and Matthew Stafford (all around 19PPG). For non QB's, it's Arian Foster, Tomlinson, Peterson, Terrell Davis, and Barry Sanders (~16 PPG). WR is Calvin Johnson, Marvin Harrison, Terrell Owens, and Randy Moss.
- In PPR RB / WR, Marshall Faulk jumps to #3, and Jerry Rice moves ahead of Randy Moss (~11 PPG).
- The top 7 PPR seasons all belong to Faulk, Priest Holmes, and Tomlinson. For a frame of reference, Faulk's best season was 7PPG better than Charles' 2013 season.
- Beckham's rookie year was the 24th best PPR season since 1990.
- Beckham's 39.6 PPR average in the fantasy playoffs 15/16 is the 5th highest since 1990. Faulk averaged over 40 in the fantasy playoffs in back to back seasons. Jerry Rice and Jamaal Charles are the other 2. In the 1995 fantasy championship, Rice put up a 14/289/3 line with 10 rushing yards, good for 61.9 fantasy points.
- Don't waste your time on late round NFL draft picks: Success rates by NFL draft round and speed.
- Team(s): Team 1

User avatar
Plank
Ring of Fame
Ring of Fame
Posts: 3783
Joined: Fri Sep 12, 2014 6:01 am

Re: The Football Data Warehouse

Postby Plank » Thu Apr 02, 2015 7:25 am

Thank you Telperion :)
@PlankMelody

Telperion
Player of the Year
Player of the Year
Posts: 2090
Joined: Mon Jul 22, 2013 6:14 am

Re: The Football Data Warehouse

Postby Telperion » Thu Apr 02, 2015 12:22 pm

Position and draft round cross tabulated with measurables (undrafted is round 0). Includes agility score, speed score, and burst score.
Image
- Don't waste your time on late round NFL draft picks: Success rates by NFL draft round and speed.
- Team(s): Team 1


Who is online

Users browsing this forum: PR0v3, StripesOfKC and 10 guests