When Joe is finally done running for the year he can curl up with a healthy smoothie and enter his December running total in Excel! I also created three additional sheets with charts and Year to Date stats for Joe. Rank Totals YTD Jan to Nov ranks based on the same number of completed months. Total Runs Joe enters these numbers and then it’s easy to calculate Average Km per run.Īt the bottom Joe can study is Year to Date totals! Totals YTD Jan to Nov allows Joe to quickly compare this year to previous years at the same point in time. Km needed to reach 1st, 2nd, 3rd Important numbers for Joe! It looks like Joe’s 2018 totals have a chance of pulling into 3rd place! Run joe run there’s only a few days until the new year! Lots of stats here! Yearly Totals is obvious. What do his running stats tell us?ĭark green highlights top months across all years. Joe has been tracking his running stats since 2013. Other Sheets I created sheets ‘Chart’, ‘YTD Stats’, ‘YTD Chart’ to help Joe visualize and study his data. Conditional formatting highlights the data. Now you can get in shape like Joe and participate in Tough Mudders! Running Tracker Enter data in this sheet. Instructions Screen shot indicates input cells, formula cells and conditional formatting. Set-up A couple of simple selections to set it up. I’ll do the nerdy stuff while you play in the mud.ĭownload Joe’s Running Tracker. He just wants to enter a few numbers at the end of the month and quickly study the results. Joe doesn’t want to get nerdy with the data. Joe enters his monthly data in a spreadsheet.
How does Joe know if he’s on pace for a good year of running? That’s where I came in handy.
To keep in shape he has an incredible workout routine. As you can see above, Joe is known for his many painted faces. He has completed many Tough Mudders and he’s also an ambassador. When Joe isn’t running Internet Kent (his ISP) he’s often participating in Tough Mudder competitions throughout the U.S. My super fit cousin Joe Perry contacted me with a few questions about an Excel spreadsheet he uses to track his running.
0 kommentar(er)
