OPTIMIZING TRAINING LOADS USING SOLVER IN EXCEL

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 […]

Read more

FORMATTING RAW WELLNESS DATA BASED ON ROLLING 28 DAY Z-SCORES

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 […]

Read more

CREATE ATHLETE ID FOR GOOGLE DOCS QUESTIONNAIRE

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 […]

Read more

EXPONENTIALLY WEIGHTED MOVING AVERAGE WORKSHEET

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 […]

Read more

TRIAL GOOGLE FORMS FOR WORKLOADS & WELLNESS

  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 […]

Read more

USING PROGRESS BAR CHARTS TO DISPLAY TESTING DATA

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 […]

Read more