I wrote an article a long time ago about using power outputs to track and monitor athlete progress. If you’re unfamiliar with the idea of power outputs or why they can be a useful metric to keep on your athletes, please catch up on the old post. Today, I’m just uploading the workbook that I use to track athlete data, and possibly save you some time if you choose to do the same thing.
Here is the link to the file so you can follow along:
It’s really simple. All you have to do is input data for athletes body weight, and three vertical jump attempts taken on the testing day.
For each week you will fill them in here:
- Hit the small “+” sign shown in the red circle above, this will expand the data entry columns for each week.
- Enter Athlete Bodyweight (in pounds) in the blue box.
- Enter three Vertical Jump attempts (In Inches) in the purple box
Of course you can delete rows if you don’t have 22 athletes, or add rows if you need to. Familiarize yourself with the formulas so you understand how to format the lookup functions in the printable charts.
Once you’re finished with the data entry, clean up your averages so they do not show #DIV/O! by removing blank cells from the calculations. What you’ll be left with is a great visual to share with your coaches and players: