Description
This video shows how you can use Excel to manipulate GPS data and extract maximum velocity and speed threshold information. Tricks used include MAXIFS, AGGREGATE, COUNTIFS.
If you are interested in more Excel tutorials check out my three series on Vimeo for S&Cs and Sport Scientists
https://vimeo.com/ondemand/athletemon...
https://vimeo.com/ondemand/strengthte...
https://vimeo.com/ondemand/excelforst...
Discount codes below (note the different codes for US v rest of world)
Intro to Excel for S&Cs
Tricks or TricksUS = 50%
Excel Tricks for Sports: Create an Athlete Monitoring System
Track or TrackUSA = 50%
Excel Tricks for Sports - Strength Training Manager
ET4S or ET4SUSA = 50%
If you are a performance analyst then consider this video series and other excellent resources from the videoanalyst