If you’ve ever aspired to try to track your finances to monitor and/or analyze your finances, this Excel spreadsheet may be the easiest and most self-motivating way you’ve yet seen! I haven’t seen any bank’s free or paid online financial tracking system give you this much information about your immediate financial status, nor as quickly. With that constant immediate feedback as you enter each new piece of data, don’t be surprised if you find yourself constantly setting your own financial targets to hit, either!
This very “Canadian” song crossed my thoughts today so I thought I’d share it, in its very “Canadian” video. It’s primarily for the majority of visitors to my site, who happen to be from places other than Canada. However, it’s also for my Canadian visitors who may well love it just as much as I do, or who may be hearing it for the first time.
It’s about as “Canadian”, as indefinable as that maybe, as any song ever has been for me. But you can “feel” it’s “Canadian” as you listen to it. It would also certainly rank among the most “Canadian things” for me.
Thank you for visiting. I hope you’ll come back for more good stuff in the future. And definitely come to visit Canada if you’ve never experienced this great country! Enjoy!
The Log Driver’s Waltz is a Canadian folk song written by Wade Hemsworth. The version you hear in the animated National Film Board (NFB) Canadian Vignette video above is the most well known version, performed by the McGarrigle Sisters, (the late) Kate and Anna, and the Mountain City Four.
Jan 2 2015 update
Everything below from the original post still applies. The link immediately below is for a MS Excel 2010 version so you don’t have to put up with “compatibility issues” of the old log. I hope you’ll like it. The MS Excel 97-2003 version is far below if you’re still using that version of Excel.
This is a much updated version of the year long Excel spreadsheet running log I had posted two years ago. You may want to refer to that post for some instructions. Thank you to all of you who had downloaded it, used it, suggested improvements and recommended it to others. If you liked that log, I think you’ll love this one! This new log has some great features I think you’ll love like a spot for your training plan next to what you did. While the focus is on running, there is room for other exercises and things you might want to track, like sleep, injuries, supplements, heart rate averages and maximums, etc. There is a race predictor using Jack Daniels’ running formula, with a short, simplified, but effective and practical explanation on how to use it. There is a calculator to determine any of time, distance or pace you need to run if you know 2 of the 3 variables. There is also a routes table to help calculate routes you take that are not your normal ones, but piece together bits of various routes you have ran. There is no new “summary” feature where what you input is number crunched, but that was because I didn’t perceive the need for any. Otherwise, most cells you shouldn’t touch are still locked up, but you have the ability to manipulate some partially for your use, like if you write a long comment one day and want to show it all rather than have some of it hidden away. As you use this spreadsheet, change the view size if the info is too small for your comfort. It can be at least twice as large. Don’t strain your eyes over using this or feel like you have to put on glasses to use it. You’ll use it less frequently for every little annoyance like this. The best way to see all this is to jump in so here goes! There are a lot of features to this log so don’t be intimidated by all the description. You need very little instruction to start and the rest should be pretty intuitive once you get going. Please click here to download the Advanced Excel Running Log by Minh Tan, 2011 version 2 (2.1 MB) The file is MS Excel 2003 version for greater compatibility for people. If you use a version later than this, please do a Save As and choose the latest version so you won’t get the “compatibility” pop-up each time you close the file. Continue reading
If your friend had told you about this log, please tell them of the update in case they had not downloaded the 2011 update.
I keep this post up for those who had used this and found it sufficient for their needs and don’t want to deal with changes. Thank you.
This is an Excel spreadsheet running log I created, used and have improved for 10 years, which I would like to share with you.
I think it is fairly easy to learn and use, after 10 years of finessing out anything that still really annoys me. Instructions are included and cells you should not touch are locked to help avoid unintentional formula deletions and make it more user-friendly. It handles two runs per day and four extra types of workouts, plus up to 10 interval spaces for any workout so unless you train more than that (and I do know people that do!), this should suffice.
This spreadsheet does not have interfaces with new GPS and Heart Rate Monitors. I’m still training old skool on a 1998 Polar HRM.
I only regret to say I will not be providing technical support for this, unless you know me and can talk to me about it directly. I am sharing it out of good will and would like to minimize efforts beyond that. However, I welcome all feedback and suggestions. If I can do anything about it, I will to upgrade the file. That is why the date is beside the download. Otherwise, you can customize it further for yourself by adding your own worksheets and features within the file to suit your needs.
If you like it or want to show this post to your friends, you can either email the link or click on one of the social bookmarking tools in the bar below (for my less Net savvy friends). Thank you.
More about the Excel Running Log
The spreadsheet log requests a fair bit of data, of which you can decide how much or how little you want to enter. That, will in turn influence how much the log will be able to feed back to you about your training. It’s only as good as you are at keeping your own data, basically.
Detailed instructions are supplied on the worksheet you open the downloaded file to, but in the future, it should open to whatever page you closed and saved the file on. Instructions are probably only needed for your set-up and first few time you use it. It should become routine fairly quickly once you get the gist of it.
Among the data the log requests are time, distance (miles or km and you can change it for each entry), shoes worn to monitor your shoe mileage, etc. With some of this data, it does calculations, like pace given time and distance. With other data, it just gives you space to keep like comments, temperature (useful if you keep track of what you wore in your comments, for example), non-running workouts, your intervals that are not automatically comparable from time to time since intervals and workouts may change, and so on. An example of a filled out week is below (Pic #1).
Please use “k” for kilometre or “m” for miles under column E of “Distance”, to tell the spreadsheet what unit your number entered was in for the distance ran”.
Beyond the workout data and calculations, it also provides a summary chart with totals and averages of all sorts (Pic #2).
There are also graphic displays of this information for the visual types, as well as a more integrated look at your training (Pics #3 – #7).
Is that enough information for you? 🙂
I hope you enjoy it. All feedback are welcomed as if I can do anything about it, I will and update the file here accordingly. I hope you will find this of value. Thank you!
Flesch-Kincaid Grade Reading Level: 6.8