Google Sheets for Sports Science Course – Dashboard Part 1

John Lythe

30/10/2020 at 14:12 #30006

Google Sheets for Sports Science Course Dashboard – Part 1 This project seeks to revisit and reinforce some of the basic concepts covered in videos 1-
[See the full post at: Google Sheets for Sports Science Course – Dashboard Part 1]

Andy Ward

06/11/2020 at 07:47 #30071

This is great stuff! What is a Session Performance Score? Is it how much load a player has experienced compared to a match based on game values?

Thanks

John Lythe

09/11/2020 at 12:13 #30090

Hi Andy, don’t take this metric too literally, it was merely a number to demonstrate the technical capabilities of sheets. However, that said, when I worked with the NZ Field Hockey team, the video analyst would collect stats at every session and produce a technical performance score for each player. These numbers were generated from basic activity counts such as tackles made, tackles missed, shooting accuracy, players eliminated in 1 v 1s etc.

Quinn Henoch

13/02/2021 at 22:47 #31199

@john Lythe – quick question:

In the ‘Dashboarding in Google Sheets Demo’, in the ‘FitnessProfile’ tab – are those Z-scores intra-athlete? As in, are they z-scores based off of the athlete’s individual mean from a repeated test; or are they z-scores based off the individual’s test score compared to the mean of the group for that test? I hope that makes sense. Thank you!