2019 update: I’ve uploaded new files (in one zip archive this time) with a few changes and fixes. These files are also set up as “master” files: The idea is you duplicate one, rename it for the current year, then use it. When the next year rolls around, repeat the process. This way, you don’t have to use the macro-enabled version to delete data at each new year. Download the new files.
About two years ago, I created a basic-but-functional run tracking workbook (created in Excel). It worked well, and helped me through my 2,016 mile year in 2016. I didn’t run nearly as much in 2017 (on purpose), but 2018 is upon us, and I’m going to up my mileage this year—probably not to 2,018, though!
In preparing this year’s version of the workbook, I addressed a few things that bugged me about the first one: It was ugly, changing years was difficult, and it was ugly. It was also really ugly. Did I mention it was ugly? Anyway, here’s what I’ve changed with the new version:
- Years are now easily handled; just input the year you wish to track, and the workbook does the rest, including leap years.
- All run data can be deleted with one button click—and yes, there’s a confirmation first. (Requires macro version of workbook.)
- The pace calculator is no longer a separate worksheet; it’s integrated into the Overall worksheet.
- It’s not nearly as ugly as it was before—layout is improved, gridlines are gone, tables are cleaned up, etc.
As noted, there are two versions of the workbook—one contains a macro that can erase the run data from each monthly worksheet, the other does not contain that macro. This is something you’ll only do once a year, but it’s much easier with the macro version.