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 [...]
This latest post/spreadsheet demonstrates how to calculate rolling averages and exponentially weighted moving averages, considering for rest days and days with zero data, without the need for entering data with zeros in them for each athlete on these days. Go to free downloads page Previously I have shown how to calculate the EWMA in a [...]
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 [...]
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! http://gifmaker.cc/PlayGIFAnimation.php?folder=20160705231N0ZXlRHbS7THIg3hNHSqB&file=output_fiCRyJ.gif To create heart symbol beside heart rate simply insert the heart shape and format to your liking. [...]
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 [...]
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 [...]
This is a nice little table I have made using the work of Mladen Jovanovic and his load exertion table, which is based off the work of Dan Baker. I've also combined this with a 1 rep max prediction equation I found courtesy of Jim Wendler many moons ago. It's not near as detailed as some of the [...]
This is a small simple spreadsheet that is based off the excellent work of Anthony Turner, who's videos I came across on YouTube about assessing the reliability of your data and setting targets using the smallest worthwhile change. I would encourage everyone to watch these videos for a more in depth description of these methods than I [...]
I decided to go down the nutrition path with this latest post. This post will run through how to create a very simple calorie and macronutrient calculator that you can use on yourself or your athletes, IF YOU KNOW WHAT YOU ARE DOING! As always, the data this chart spits out is not to be [...]
Athlete monitoring tools are all the rage these days..DATA DATA DATA! Data is only as good as you use it though! But for those who are working with athletes and teams on a budget here is a cool way you can do it exactly the way you want to, with the only cost being your [...]
