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)