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 pre-season, whilst keeping ACWR and cumulative loads within specified constraints. Sean put together a mock loading template to replicate this idea by using solver in Excel, the original paper had used MATLAB for its simulations. He was kind enough to send this file to me … Continue reading OPTIMIZING TRAINING LOADS USING SOLVER IN EXCEL

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 spreadsheet demonstrates how to calculate an individual rolling 28 day mean, standard deviation and subsequently, Z scores from a bank of wellness raw data. The spreadsheet also uses conditional formatting to highlight raw wellness scores for a given day, based on the rolling z score … Continue reading FORMATTING RAW WELLNESS DATA BASED ON ROLLING 28 DAY Z-SCORES