Membership Content

  • Google Sheets for Sports Science Course – Reports Part 2

    By on 06/11/2020

    Google Sheets for Sports Science Course Reports – Part 2 Further application of the IMPORTRANGE function to connect report filters on the athlete file back to the coaches master file so that the athlete can explore their own live data without being able to see data from any of the other athletes. About John Lythe John Lythe was a...

  • Google Sheets for Sports Science Course – Module 3: Reports

    By on 06/11/2020

    Using a similar dashboard-style report, this module dives into detail about the connection of an athlete reporting dashboard to a master data set.

  • Google Sheets for Sports Science Course – Dashboard Part 3

    By on 30/10/2020

    Google Sheets for Sports Science Course Dashboard – Part 3 This is the final video in the Dashboard project. The focus is on chart creation and customization. Donut, Stacked Columns, and Panel charts are used to glue together the more traditional visualization options and some final presentation steps are applied to make the dashboard consistent and presentable. About John...

  • Google Sheets for Sports Science Course – Dashboard Part 2

    By on 30/10/2020

    Google Sheets for Sports Science Course Dashboard – Part 2 Here we see the continued development of the dashboard with a lot of formula writing and chart creation. The sophisticated QUERY function is used to extract information into the workings area for the charting of raw, ranked, and normalized fitness test scores. About John Lythe John Lythe was a...

  • Google Sheets for Sports Science Course – Module 2: Dashboard

    By on 30/10/2020

    Now that we covered the basics, in this next module we will learn how to create a dashboard, build the first of many charts, and make the dashboard consistent and presentable.

  • Google Sheets for Sports Science Course – Basics Part 3

    By on 23/10/2020

    Google Sheets for Sports Science Course Basics – Part 3: Forms This video is dedicated to Google Forms. A run-through of how Forms feed into Sheets, how to build them from scratch and how they can provide a cheap alternative to expensive athlete monitoring systems. Also described is a method to add a Google Form as an app/icon on...

  • Google Sheets for Sports Science Course – Module1: Basics

    By on 23/10/2020

    This is the first video in the series and presents a quick summary of key differences between Excel and Google Sheets as well as a run-through of the menus and layout. It finishes with demonstrations of formula writing, named ranges, data validation, and collaborative comments.

  • Google Sheets for Sports Science Course

    By on 23/10/2020

    We are proud to present to you Google Sheets for Sports Science course. The intention of this course is to open your eyes to Google Sheets and gain skills to become a Google Spreadsheet power user!

  • Mesocycles Course – Lesson 11: Deadlift Best Practices

    By on 16/10/2020

    In the last video of the Mesocycles Course, Mike Tuchscherer shares his deadlift best practices. Mike discusses exercises selection based on weak ROM and muscles, as well as intensity, volume, frequency and RPE selections.

  • Mesocycles Course – Lesson 10: Bench Best Practices

    By on 30/09/2020

    Developing bench press generally affords and demands higher intensities, higher volumes, and higher frequencies compared to other lifts. In this video, Mike T shares these and other best practices for developing your bench press.