Google Sheets for Sports Science Course – Module 2: Dashboard - Complementary Training
Google Sheets for Sports Science Course – Module 2: Dashboard

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-3. The foundation steps of dashboard creation are demonstrated including data preparation, construction of two Google Forms for athlete data entry, the use of named ranges and data validation to apply filters to the dashboard, the use of aggregation formula and the building of the first of many charts.

Google Sheets Course

Ready to watch this course?
Take advantage of our promotional offer

Master Google Sheets

Learn New Skills And Become Google Spreadsheet Power User!

Take this CoursePromo Discount: 33% OFF


Seize the Moment and Watch This Course Within 7-Day FREE Trial!

Learn new skills, get instant access to our knowledge base!

  1. Newest applied research, technology, analytics, and top-level coaching experiences
  2. 700+ high-quality articles and research reviews
  3. 300+ hours of video material​
  4. and much more

Start Your Free TrialNew skills are just a click away

First 7 days are completely FREE,
then regular price will be in effect
($35 per month)

Course Navigation


Module 1: Basics

Module 2: Dashboard

Module 3: Reports

Module 4: Strength Template

I am a former sport scientist, now I just build Excel systems and work with software tools (CRM, Salesforce, PM, Sharepoint) and technology. My day job requires me to sit between the IT department and the sports performance department to make sure that Strength and Conditioning Coaches, Nutritionists, Performance Analysts etc have the hardware and software tools they need to do their jobs. Read More »

Welcome to Complementary Training Community! Forums Google Sheets for Sports Science Course – Dashboard Part 1

This topic contains 3 replies, has 3 voices, and was last updated by  Quinn Henoch 3 years, 3 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • 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?


    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.

    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!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.