Excel

DRILL DATABASE & EXERCISE TEMPLATE

DRILL DATABASE & EXERCISE TEMPLATE

Utilising the same method as I've used in a post from a few years ago, which can be found here, I've created a drill library and exercise template Check it out on the free downloads page

FOLLOWING NOBODY – AN EXPERIMENT IN FINDING CALM

FOLLOWING NOBODY – AN EXPERIMENT IN FINDING CALM

This post is not ground-breaking, it may not even be helpful. I’ve nothing to sell here, I’m not a self-help/self-improvement guru…these are just some experiences I’ve had whilst trying to be more purposeful with how I live. Social media, when used without crystal clear intentions, can lead to a feeling of inadequacy, uncertainty, frustration and anxiety. This [...]

DYNAMIC CHARTS & NAMED RANGES

DYNAMIC CHARTS & NAMED RANGES

Here's a quick video showing how I create charts that shrink and expand depending on the amount of data you have, I have used this technique in the sample testing database on the free downloads page    

FREE SAMPLE TESTING DATABASE

FREE SAMPLE TESTING DATABASE

I've switched it up from GPS databases to a simple example of a testing database that might be a useful template, or maybe you'll get one or two ideas to add in to your current system! Check out the video below and click here to get your free template To see how I've created the [...]

FILTERING LARGE DATABASE FOR SIMPLE EXERCISE SELECTION

FILTERING LARGE DATABASE FOR SIMPLE EXERCISE SELECTION

This is an example of a filtering techniqe I used for a client when building an extensive strength template. There was a database with over 1000 exercises split up into different categories, this is just a sample of the function, in the actual buid there were four slicers to sub-categorize the exercises. I have found [...]

WHAT DO YOU WANT TO SEE?

WHAT DO YOU WANT TO SEE?

I'm hard to reach, this is by design. Unfortunately I no longer do custom excel builds due to time constraints. If you leave some suggestions below and if enough people have the same idea, then I'll put some free content together that will address these suggestions sometime in the near future.

FREE SAMPLE GPS DATABASE

FREE SAMPLE GPS DATABASE

I've mixed some techniques I've used to create a really simple GPS tool that might be useful to those who are new to excel or collecting gps data and want something affordable and simple to get started with! Check out the video below and click here to get your free template!

COUPLED VS UNCOUPLED EWMA ACUTE:CHRONIC SPREADSHEET

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

RECOMMENDED EXCEL RESOURCES – UPDATE

RECOMMENDED EXCEL RESOURCES – UPDATE

  These are some cool new spreadsheets & resources that have popped up in recent times that deserved some attention to be brought to them. Database and G.A.A template for Analysts - Johnny Bradley Click to view https://vimeo.com/240068522 Spreadsheet for sprint acceleration force-velocity-power profiling - JB Morin Click to view https://www.youtube.com/watch?v=ze8rCm38Kvw&feature=youtu.be Build your own CMJ [...]

LOAD PLANNER

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

UPDATED AUTOMATED EWMA CALCULATIONS

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

OPTIMIZING TRAINING LOADS USING SOLVER IN EXCEL

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