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

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

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

HIGHLIGHT INJURIES ON HUMAN BODY

Nice little one that could be incorporated in wellness dashboards or physio reports if desired. Lots of potential with this type of creation and you could go into as much injury detail as possible. I’ve basically started out by combining two images into one picture using microsoft word. By sending the human body picture behind […]

Read more

CREATING A PICTURE DASHBOARD

This is an incredibly simple and cool way to create a main dashboard that will take you to any tab within a given sheet. Not one I would have thought to do a post about but something that has been requested a lot so here you go! I have found that if you only have […]

Read more