Heads-up: Huge Sports Tech Sale Underway – 20% Off All Smart Trainers!
There’s a massive sales on smart cycling trainers right now, plus plenty other sports tech. There’s 20% off the Wahoo KICKR, KICKR CORE, CLIMB, Headwind, 20% off the Tacx NEO 2T, Flux 2, and Flux S, 20% off Saris Hammer 3 trainer and Saris MP1 Motion Platform. Plus also 20% off the Elite Direto X and Suito too, even the new Sterzo. Plus even steeper deals including with the Kinetic trainers at 30% off.
I’ve used a lot of training logs over the past two years. I’m kinda a training records nut-case. I want to know what I did, when I did it, and I want to be able to follow trends (which as a side note are tough because of temperature variables over the course of a year). About two years ago I started using an Excel spreadsheet I found on a web site. It wasn’t visually fancy, but it did do the trick, plus it had lots of nifty calculations and graphs on it.
The reason I bring this up is after last week’s post on schedules, a bunch of ya e-mailed me asking what logs I use
Which…brings me to one minor detail. I use three different logs. Really…it happened by accident. I used to use exclusively my Excel log. But then I started using Sport Tracks to import/analyze all my data. Because that’s how I get my data off the Garmin. So for a while it was Sports Tracks and my little Excel log as the two authoritative sources. And then in May came along the coach – which uses Training Peaks (TP). So I had to enter the data in TP as well for him. So before I knew it I was tracking in three different things. So for the most part, I don’t use the log portions of the Excel sheet anymore.
Excel, that little Excel sheet I mentioned – I kinda heavily customized it. I added all sorts of random pages. Stuff like pace calculators, calendars, etc.. So I still use those.
At any rate, here’s a few screenshots of the Excel Sheet:
The above is from last year’s log, you’ll note the drop-off in Nov/December, that’s when I hurt my knee. 🙁 I like how it tracks my shoes though – which I generally use to about 500 miles. Below is the ‘Plan’ page, which allows you to specify what you plan – kinda a way to hold you accountable.
I’ve added this bike and swim section. It’s occasionally clunky, but it works.
It also includes a weight tracking chart – which I found really useful. There are two lines, the day by day weight, and then a 7 day moving average – which is more accurate (the below graph is from 2007 – I haven’t really lost or gained anything this year)
And lots of other pretty graphs as well:
Oh, and here’s a little pace calculator page I added, that allows me to keep track on various ‘PR’s’ within random distances. I use colors to define goals, and current training/race ‘records’. I forget to update a lot of the more obscure distances. Some of the random distances are based on specific routes I run/bike.
Buuuuutttt….as I said before – I’ve mostly converted to Sports Tracks and TP now (with the exception of stuff like the pace charts above). It does all the pretty graphing and recording keeping, as well as adding in the satellite views of my workouts.
And finally, here’s what it looks like in Training Peaks:
So, with that – here’s the downloadable workbook I use:
My modified and slightly confusing version: (Excel 2003) (Excel 2007) – Note I haven’t double-checked every cell that the 2003 version is all-happy after I down-converted it, but it seems to work fine.
I didn’t spend a ton of time cleaning up my version – because…well…it’s like a a rat’s nest that only I understand. I emptied out all of my data for the most part though, except a few things (examples) so you can make sense of it.
(Note, if for some reason you can’t get to the above files, please e-mail me or leave me a comment, and I’ll fix it)
I swim, bike and run. Then, I come here and write about my adventures. It’s as simple as that. Most of the time. If you’re new around these parts, here’s the long version of my story.
You'll support the site, and get ad-free DCR! Plus, you'll be more awesome. Click above for all the details. Oh, and you can sign-up for the newsletter here!
Here’s how to save!
Wanna save some cash and support the site? You have two options. The first is to use Clever Training with either the coupon code (DCR10BTF) or the VIP program. Both save 10%, see details by clicking below:
In the UK/EU/Australia/New Zealand? Then hit up Wiggle at the link below!
Alternatively, for everything else on the planet, simply buy your goods from Amazon via the link below and I get a tiny bit back. No cost to you, easy as pie!
You probably stumbled upon here looking for a review of a sports gadget. If you’re trying to decide which unit to buy – check out my in-depth reviews section. Some reviews are over 60 pages long when printed out, with hundreds of photos! I aim to leave no stone unturned.
I travel a fair bit, both for work and for fun. Here’s a bunch of random trip reports and daily trip-logs that I’ve put together and posted. I’ve sorted it all by world geography, in an attempt to make it easy to figure out where I’ve been.
The most common question I receive outside of the “what’s the best GPS watch for me” variant, are photography-esq based. So in efforts to combat the amount of emails I need to sort through on a daily basis, I’ve complied this “My Photography Gear” post for your curious minds! It’s a nice break from the day to day sports-tech talk, and I hope you get something out of it!
Many readers stumble into my website in search of information on the latest and greatest sports tech products. But at the end of the day, you might just be wondering “What does Ray use when not testing new products?”. So here is the most up to date list of products I like and fit the bill for me and my training needs best! DC Rainmaker 2019 swim, bike, run, and general gear list. But wait, are you a female and feel like these things might not apply to you? If that’s the case (but certainly not saying my choices aren’t good for women), and you just want to see a different gear junkies “picks”, check out The Girl’s 2018 Gear Guide too.