COUPLED VS UNCOUPLED EWMA ACUTE:CHRONIC SPREADSHEET

  This one has been on the back burner for a few months now, been toying around with some ideas as well as getting ideas from Sean Williams and Mladen Jovanović, the latter put up a great tutorial video on his website with similar thoughts here. Rather than talk through the research behind this latest update in the ‘acute:chronic journey’, here are links to the mathematical coupling paper by Lolli and colleagues, as well as a recent editorial by Windt and Gabbett. http://bjsm.bmj.com/content/early/2017/11/03/bjsports-2017-098110 http://bjsm.bmj.com/content/early/2018/05/28/bjsports-2017-098925 I’ve played around with a few ideas on what to do with the load in the ‘lag’ … Continue reading COUPLED VS UNCOUPLED EWMA ACUTE:CHRONIC SPREADSHEET

UPDATED AUTOMATED EWMA CALCULATIONS

  In my previous worksheets and demonstrations, EWMA calculations have required you to build an average or copy the first day’s workload to build up some data for the EWMA formula to work from. In previous downloads I have put out, when adding in a new athlete, you would have to change the formulas manually to ensure the first time an athlete’s name appeared, their load in the EWMA column would match their raw score. As seen below, the second time an athlete appears, the formula for EWMA could kick in. I struggled for a while to make this process … Continue reading UPDATED AUTOMATED EWMA CALCULATIONS

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