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?
Become a member and get unlimited access to all content on our website.

Limited offer!

With Complementary Training You Always Get More!

Enhance Your Knowledge and Perfect Your Skills

Reach the next level with our books


First 10 Premium members who join us get 1-year membership, ALL the Cool Bonuses + two paperback books

Premium Membership
$350 per year

Hurry Up


spots left!


Expand your library even more!

Sign up now and get a 40% lifetime discount on all orders from Ultimate Athlete Concepts!

Take a look at all the books and educational material that UAC offers


The best part is – it doesn’t end there!

All our Premium members ALSO get COURSES to elevate their performance & TOOLS to reduce their effort during every-day work!

‘An investment in knowledge always pays the best interest’

– Benjamin Franklin

Premium Membership
$350 per year

Don’t miss out! Only the first 10 new Premium Members get Bootstrap Magnitude-based Statistics for Sports Scientists and Strength Training Manual paperback books for FREE in addition to other bonuses!

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 weeks, 2 days 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.