EXPONENTIALLY WEIGHTED MOVING AVERAGE WORKSHEET

1

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 I’ve spent the last few days working on comparing the exponentially weighted moving average equation with a simplified rolling average equation I use for 7 day vs 28 day acute:chronic ratios in excel.

It is interesting to see the differences between the two equations.

A noteworthy point is to ensure that when collecting data in this format to ensure days with no data are still shown in the spreadsheet too – as a formula like this only uses the data that is available.

Previously I’ve used pivot tables to automatically display days and dates with no data and input a 0 if no data is present. It may be a case with a formula and set up like this, that you have to get your athletes to submit ‘rest days’ with a zero training load, to ensure these days are accounted for in the calculations. Otherwise you can end up with a 28 day average that is spread over 40 days due to no data for rest days etc.

See the full paper here 

Click here to be taken to the downloads page and get this spreadsheet

Shout out to Sean Williams for his time and feedback on this!

 

Adam