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 Black Friday Offer

Master Google Sheets

Learn New Skills And Become Google Spreadsheet Power User!

Take this CoursePromo Discount: 33% OFF

OR

Become a Premium Member and Get Instant Access to All Courses, Books and Tools

Join Us TodayAnd Instantly Save $855

Premium Membership
$350 per year

Course Navigation

Introduction

Module 1: Basics

Module 2: Dashboard

Module 3: Reports

Module 4: Strength Template

mm
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 »
free-memeber-button
free-memeber-button

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

This topic contains 2 replies, has 2 voices, and was last updated by mm John Lythe 3 weeks, 1 day ago.

Viewing 2 posts - 1 through 2 (of 2 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?

    Thanks

    mm
    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.

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

You must be logged in to reply to this topic.