Tuesday, December 28, 2021

New Year, New Statistics

As you can tell from the December 13th edition of this blog, I'm kinda sorta into technology and data. But in order for that data to be useful, I need to correlate that data into statistics. For example, here's a post that members of one of my Facebook running clubs saw from me back in November:

2021 was a good November for me. I blasted through the annual mileage goal (1700 miles) that I failed to achieve last year. New target: 2,021 miles in 2021! The good news: as of the end of November, I am on track to reach my annual goal by 12/29 and to end the year with 2030. With 1 day off each week, the holidays & travel days, I’m guessing I have 22 running days left this year. So, I need 7.4 miles each of those days I run to reach my goal. Here are the November details:
200.01 miles in November, which is 2.5 miles less than last month. I am at 1854 miles for the year so far. I’m on track for 2030 by 12/31/20, currently running about 4 miles ahead of schedule on my annual goal of 2,021. November’s miles are an average of 9.1 miles per day for 22 running days, which was 73% of the month. An average of 6.7 miles per day over all 30 days in November. That is above my 8.3 miles-per-running-day average for the year and also above my YTD average (67%) of days running (223 days out of 334). My November average of 43.1 miles per week was less than October but above my annual average of 38.7 miles per week 2021 YTD. 

As I described in the December 20th edition of this blog, there are many different things out there that can motivate us as runners. Call me a nerd, but setting a goal and tracking the statistics along the way motivates me! If you, like me, are motivated or at least interested in tracking your running statistics, keep reading for more details. On the other hand, if your eyes roll back in your head when you think of such details, or if you have arithmophobia, you may want to stop reading now.

There is Raw Data

Here's a snapshot of a spreadsheet that I've been using and refining for a few years now to generate all 
those statistics:


As I update this sheet during the year, all I have to do is add a new line, enter the distance run that day, and the sheet does the rest. If you're interested in having a spreadsheet like this of your very own, leave me a comment on this blog or in the Facebook group Realistic Running and I'll fix you right up!

There are Daily Statistics

Date
Day of the Year (1-365)
Days Left in the Year
Total Miles in the Last 7 Days
Monthly Miles to Date
Annual Miles to Date
Miles You Should Have Run to Date
Miles Remaining to Reach Your Goal
Miles Per Day Needed to Reach Your Goal
Days Until You Reach Your Goal
Projected Date to Reach Your Goal
Projected mileage at End of the Year

There are Monthly Statistics

Average Miles Per Day This Month
Running Days This Month
Average Miles Per Running Day This Month
Average Miles Per Day This Year

There are Annual Statistics 

Number of Running Days This Year
Average Miles-Per-Running Day This Year
Average Miles Per Week This Year
Maximum Miles Per Week This Year
Average Miles Per Week for Each Month

And Then There are the Graphs!

A picture is worth a thousand words. Here are two pictures! The top graph has the "target" line for Miles Per Year in red, and the actual mileage in blue. The bottom graph has the target 2021 MPY as the horizontal centerline, and my actual mileage in blue, wavering around the centerline.

No comments:

Post a Comment