Excel
-

DRILL DATABASE & EXERCISE TEMPLATE
Utilising the same method as I’ve used in a post from a few years ago, which…
-

SOCCER SHOOTING VBA CHART
I haven’t put up anything with VBA at all as I like to keep things simple,…
-

DYNAMIC CHARTS & NAMED RANGES
Here’s a quick video showing how I create charts that shrink and expand depending on the…
-

FREE SAMPLE TESTING DATABASE
I’ve switched it up from GPS databases to a simple example of a testing database that…
-

FILTERING LARGE DATABASE FOR SIMPLE EXERCISE SELECTION
This is an example of a filtering techniqe I used for a client when building an…
-

FREE SAMPLE GPS DATABASE
I’ve mixed some techniques I’ve used to create a really simple GPS tool that might be…
-

BUILDING A WELLNESS QUESTIONNAIRE FROM START TO FINISH – WITH FREE DATABASE!
This video has been a long time coming – we’re using google forms and google drive…
-

COUPLED VS UNCOUPLED EWMA ACUTE:CHRONIC SPREADSHEET
This one has been on the back burner for a few months now, been toying…
-

RECOMMENDED EXCEL RESOURCES – UPDATE
These are some cool new spreadsheets & resources that have popped up in recent times…
-

LOAD PLANNER
This is the most extensive file I have released for free to date. I’ve been toying…
-

UPDATED AUTOMATED EWMA CALCULATIONS
In my previous worksheets and demonstrations, EWMA calculations have required you to build an average or…
-

OPTIMIZING TRAINING LOADS USING SOLVER IN EXCEL
Most of the donkey work on this was done by Sean Williams @statman_sean, this project was…
-

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

ACCOUNTING FOR REST DAYS IN ROLLING/EXPONENTIALLY WEIGHTED MOVING AVERAGE CALCULATIONS
This latest post/spreadsheet demonstrates how to calculate rolling averages and exponentially weighted moving averages, considering for…
