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.