Adam

Most of the donkey work on this was done by Sean Williams @statman_sean, this project was inspired by the work from David Carey @dlcarey88 and co, in his recent paper on Optimizing Pre-Season Training Loads in Australian Football. This paper looked at the daily loads and periodisation strategy that would produce the largest total distance covered across […]

This latest download is something I have been working on for quite some time, having built some similar functions for projects before, but without a 28 day rolling average, standard deviation and z-score. Using Z scores is an effective way to monitor significant deviations away from baseline values for any metric you are measuring. This […]

This latest post/spreadsheet demonstrates how to calculate rolling averages and exponentially weighted moving averages, considering for rest days and days with zero data, without the need for entering data with zeros in them for each athlete on these days. Go to free downloads page Previously I have shown how to calculate the EWMA in a […]

I have received a number of emails from coaches that are concerned about using a drop down box with all their athlete’s names available to choose from – some of these concerns are athlete’s picking the wrong names by mistake or simply doing it on purpose! To avoid this, you can simply create an ID […]

This latest worksheet is based on the work of Sean Williams, Stephen West, Matthew Cross & Keith Stokes, where they examine if there is a better way to determine the acute:chronic workload ratio  I’ll leave the debate on the best way to calculate acute to chronic training ratios to people far more smarter than I am, but […]

  I’ve used google forms and docs extensively to build free questionnaires and spreadsheets to collect and display data I need to help monitor the wellbeing of my athletes. I’ve used this data to help build excel databases, such as the one I have made available here, as well as help build bespoke databases for […]

Using a simple bar chart, playing around with how it’s formatted and presented and you can create some cool progress bars to display things like intensity or highlight any variable that has a beginning and end value!  To create heart symbol beside heart rate simply insert the heart shape and format to your liking. To […]