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

Read more

RECOMMENDED EXCEL RESOURCES

  These are some cool new spreadsheets & resources that have popped up in recent times that deserved some attention to be brought to them. Spreadsheet for Sprint acceleration force-velocity-power profiling Click to view   Build your own CMJ Analyser in excel https://buff.ly/2DyDzKS Excel Tricks for S&C Coaches Course with John Lythe from Excel Tricks […]

Read more

LOAD PLANNER

This is the most extensive file I have released for free to date. I’ve been toying around with the idea of a load planner for a long while. The idea behind this build was so practitioners could plan future loads and see how these planned loads would affect a:c ratios. I think ‘predicting injury’ is […]

Read more

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

Read more

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