UAMT in Google Sheets #2.2 - Database Calculations and Tips
The Ultimate Athlete Monitoring Toolkit (UAMT) in Google Sheets
Athlete Performance Testing
Module 2: Performance Testing Fundamentals
#2.2: Database Calculations and Tips
WHAT WE LEARN
In this tutorial video, we learn how to create calculations within an athlete performance testing database we developed in Module 2.1 (“Performance Testing Database Setup”) of the Ultimate Athlete Monitoring Toolkit (UAMT) in Google Sheets. These calculations include predicted one-repetition maximums (1RMs), relative strength indexes, and average and maximum countermovement jump heights from multiple trials of jumps. We also learn about array formulas in Google Sheets and why they can cause major problems if you aren’t careful.
FREE TEMPLATE
If you haven’t already, make sure to use the link below to make a copy of the datasets used in the Athlete Performance Testing portion of this project to save you time and effort as you follow along with the tutorials:
https://docs.google.com/spreadsheets/...
CHEAT CODE
The UAMT is a great Google Sheets learning experience, but it also requires a lot of time and effort to complete. If you want to take a shortcut to the gold at the end of the rainbow, I have an opportunity for you. You can purchase the Google Sheets file that is developed from accomplishing all tasks presented in the tutorial videos for The Athlete Performance Testing portion of The Ultimate Athlete Monitoring Toolkit (UAMT), here: https://adamvirgile.com/product/ultim...