-
14/11/2020
Google Sheets for Sports Science Course – Strength Template Part 3
By John Lythe on 14/11/2020Google Sheets for Sports Science Course Strength Template – Part 3 This is the final strength template video where further features are added using the HYPERLINK function and an image and video repository. The user can now select an exercise and have a link to an exercise photo and video demonstration become available for the athlete to open. About...
0 -
13/11/2020
Google Sheets for Sports Science Course – Strength Template Part 2
By John Lythe on 13/11/2020Google Sheets for Sports Science Course Strength Template – Part 2 This video focuses on the connection of a searchable exercises list, a Set-Rep table and an athlete 1RM table to the 4 week-strength template. A number of lookup and logic functions are combined to allow the user to make selections and see sets, reps and prescribed loads populate...
-
13/11/2020
Google Sheets for Sports Science Course – Module 4: Strength Template
By John Lythe on 13/11/2020In the 4th and last module, you will learn how to create a searchable picklist of all exercises, combine lookup and logic functions to populate the template automatically, use the HYPERLINK function to add an image and video repository and much more.
-
06/11/2020
Google Sheets for Sports Science Course – Reports Part 2
By John Lythe on 06/11/2020Google 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...
-
06/11/2020
Google Sheets for Sports Science Course – Module 3: Reports
By John Lythe on 06/11/2020Using a similar dashboard-style report, this module dives into detail about the connection of an athlete reporting dashboard to a master data set.
-
30/10/2020
Google Sheets for Sports Science Course – Dashboard Part 3
By John Lythe on 30/10/2020Google 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...
-
30/10/2020
Google Sheets for Sports Science Course – Dashboard Part 2
By John Lythe on 30/10/2020Google 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...
-
30/10/2020
Google Sheets for Sports Science Course – Module 2: Dashboard
By John Lythe on 30/10/2020Now 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.
-
23/10/2020
Google Sheets for Sports Science Course – Basics Part 3
By John Lythe on 23/10/2020Google 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...
-
23/10/2020
Google Sheets for Sports Science Course – Basics Part 2
By John Lythe on 23/10/2020Google Sheets for Sports Science Course Basics – Part 2: Core Features This progresses the introduction by discussing and demonstrating conditional formatting and the charting engine. It also covers find & replace, filters, pivot tables, language translation and the recording of macros. A winning feature of Google Sheets is also introduced, that of using the IMPORT RANGE function to...