The Football Data Warehouse
- Dynasty DeLorean
- Degenerate
- Posts: 8856
- Joined: Tue Feb 24, 2015 8:45 am
Re: The Football Data Warehouse
very cool
Re: The Football Data Warehouse
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.
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
- Team(s): Team 1
Re: The Football Data Warehouse
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.
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
- Team(s): Team 1
Re: The Football Data Warehouse
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
- Team(s): Team 1
Re: The Football Data Warehouse
You're one of my heroes for doing this.Telperion wrote:2015 game logs and 2016 combine data coming shortly, for all the data nerds.
Follow me @evorzan on Twitter
Formerly posting as Steveeb
Formerly posting as Steveeb
- clarion contrarion
- Hall of Fame
- Posts: 4953
- Joined: Sun Feb 12, 2012 4:11 am
Re: The Football Data Warehouse
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!
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
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
-
- Captain
- Posts: 803
- Joined: Tue Mar 17, 2015 10:14 am
Re: The Football Data Warehouse
Looking forward to getting stuck into these numbers again. Cheers Telperion.
99 problems but your 10 team league ain't one!
Re: The Football Data Warehouse
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!
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
- Team(s): Team 1
- holy_stromboli
- MVP
- Posts: 2940
- Joined: Tue Oct 04, 2011 10:47 pm
Re: The Football Data Warehouse
Telperion wrote:Some interesting historical numbers since 1990:
- The top 5 career leaders in standard scoring PPG ...... Matthew Stafford.
-
- Combine Attendee
- Posts: 4
- Joined: Fri Dec 09, 2016 1:02 pm
Re: The Football Data Warehouse
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!
Re: The Football Data Warehouse
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.
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
- Team(s): Team 1
Who is online
Users browsing this forum: Bing [Bot], Google [Bot], Hottoddies and 44 guests