The Football Data Warehouse

General talk about Dynasty Leagues.
User avatar
Dynasty DeLorean
Legend
Legend
Posts: 6736
Joined: Tue Feb 24, 2015 8:45 am

Re: The Football Data Warehouse

Postby Dynasty DeLorean » Thu Apr 02, 2015 12:42 pm

very cool

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 Apr 03, 2015 1:44 pm

I updated the original post with the advanced metric formulas, and uploaded the latest workbook with the metrics baked in.

I didn't have Roto's Athleticism formula so I created my own based on what I did have of the true formula. It has an R-squared value of 0.996 (good) but a steeper slope. It's valid to compare athletes within my data set, just not to Roto's Athleticism score. When I get time I'll play with the formula to align the slope too. 100 is calibrated to represent an average NFL athlete. For example, the top 5 are Matt Jones (WR '05), Vernon Davis, Vincent Jackson, Jackie Battle, and Javon Walker. Megatron would likely be there too but didn't run a full set of drills.

Burst, Speed, and HaSS are externally accurate too and are directly comparable to what you see on Roto, etc.
- 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 » Mon Apr 06, 2015 9:11 am

I created a version that works with Office 365 online, you can run reports on stats, players (with metrics) and ADP.

The link to One Drive is in the original post.
- 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 » Mon Mar 14, 2016 8:06 pm

2015 game logs and 2016 combine data coming shortly, for all the data nerds.
- 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 » Tue Mar 15, 2016 9:09 am

Telperion wrote:2015 game logs and 2016 combine data coming shortly, for all the data nerds.
You're one of my heroes for doing this.

:clap: :thumbup:
Follow me @evorzan on Twitter
Formerly posting as Steveeb

User avatar
clarion contrarion
Hall of Fame
Hall of Fame
Posts: 4953
Joined: Sun Feb 12, 2012 4:11 am

Re: The Football Data Warehouse

Postby clarion contrarion » Tue Mar 15, 2016 10:24 am

I wanted to like this and then I saw the name alfred papunu ...... thus epic fail since he cost the steelers a trip to the super bowl .

just kidding dude exhaustive amount of work ! be proud!
.....this has been a public service announcement from forum superstar clarion contrarion
QB luck- driskell
WR ant brown evans c davis golladay godwin gordon j washington doctson watson lazard patrick henderson
RB mixon cohen chubb aaron jones hunt malcolm brown
TE eifert howard njoku
K tucker DEF pittsburgh chicago
2012 , 2014 2015 2016 2017 & 2018 ACDL Champion 5 IN A ROW 6 in 7 years- now that is dynasty!
2013 ACDL runner up
2013 2014 2017 & 2018 (Undefeated 15-0 ) WORILDS OF HURT CHAMPION
2010 2014 & 2015 7 Rings for Steeltown CHAMPION 2011 & 2013 7 rings runner up
2018 Experts Dynasty League Champion
there is no after football
Simplicity is the ultimate sophistication.
— Leonardo da Vinci

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

Re: The Football Data Warehouse

Postby TheChicken » Tue Mar 15, 2016 10:37 am

Looking forward to getting stuck into these numbers again. Cheers Telperion.
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 » Tue Mar 15, 2016 10:41 am

A small peek behind the curtain of this project, this is just part of the code, it's definitely not trivial:

https://defuse.ca/b/UsjHu1Z4

But definitely worth it!
- 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
holy_stromboli
MVP
MVP
Posts: 2940
Joined: Tue Oct 04, 2011 10:47 pm

Re: The Football Data Warehouse

Postby holy_stromboli » Tue Mar 15, 2016 10:48 am

Telperion wrote:Some interesting historical numbers since 1990:

- The top 5 career leaders in standard scoring PPG ...... Matthew Stafford.
:wtf: :wtf:

jwesthoff89
Combine Attendee
Combine Attendee
Posts: 4
Joined: Fri Dec 09, 2016 1:02 pm

Re: The Football Data Warehouse

Postby jwesthoff89 » Fri Dec 09, 2016 4:44 pm

Where were you getting this data? This is the closest I have got to getting data in the format I want. I have done some customizing to create reporting that I find useful. However, I need 2015 and 2016 data as well. Please let me know!

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 Jul 14, 2017 7:54 pm

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.

The way I assembled it the first time around required *far* too much manual work, which wasn't sustainable at all. This time around I'm doing it differently and hopefully it will be much easier to keep it current.
- 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: CGW, Flatlander19 and 2 guests