Data Analyst
Today (12th April 2021), I ran my fastest 10k since a one-off race in 1997. When I started running again back in 2019, I started keeping records to track my progression, so my ‘personal bests’ refer to the period 2019 to today. Here is a chart to show the progression of my 10k personal best…
Today I interpolated the 10km pace of all of my recorded runs of longer than 10km and those of my friend and plotted them on the chart below. (Click to view in full size.) Many of the runs were of far longer than 10km, so working out the average pace does not always allow for…
Today I used Excel to compare my current training for a half marathon in early September 2021 with the training of my friend who is training for the London Marathon in late April 2022. I looked only at runs of over 5km so far (8th April) in 2021 with my data coming from my own…
Below is a chart to show the WMA age grading (measure of quality) of my runs so far during 2021 up to and including today, 5th April 2021. Red markers are used to show the runs of 10km or above, and blue markers for the shorter runs. Each marker is labelled with the distance run,…
During the month of March 2021, I ran 11 times for a total distance of 123.54km with an average run distance of 11.23 km. The longest run was 15.19 km. No walk breaks were taken all month. The chart below shows that as of today (April 1st), I have run 341.56 km during 2021, and…
I got the Strava data for a couple of my friend’s long runs: a city half marathon from May 2019 and a 16 mile training run (for the London Marathon) from early-March 2020 before the marathon was cancelled. With Excel I tidied up the data and extracted the numerical data of interest. The chart below…
Getting back into running in 2020 after a slow start to the year and then the first Covid-19 lockdown resulted in some tactical walks being required during runs – particularly as the runs increased in length. The chart below, plotted in Excel, shows the distance and average speed of each of my runs of 2020.…
Today I quickly tried out a few different techniques with Excel to visualise my 2021 running data (up to and including 25th March) – mostly conditional formatting of charts and their data labels to try and show as much information as possible in single charts of different types. The first chart did not turn out…
I recently used Power BI to visualise some Coronavirus data for different countries, and conditionally formatting the data series markers was very easy and intuitive. I wanted to try something similar with Excel (no VBA) on my running data to visualise the quality of my runs month by month so far through 2021. I found…
Below is an Excel chart to show the 7-day rolling total distance that I have covered running from the start of 2019 until today (11th March 2021). 30km or more in 7 days is highlighted with bold white font, and 37km or more in 7 days is highlighted in bold yellow font. Dates shown in…