 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
Getting into some serious training for an event in October and would like to record my mileage in excel and graph it. I've seen you can buy 'Prolog Cycling' for US$10 online - anyone using it? Any other suggestions of free/cheap excel based cycling logs to download rather than create my own? Thanx...
Unless you want to do more than log miles and make a graph, why pay for anything? Excel can do that anyway.
Loads of web based places: Mapmyride, bikejournal, Livestrong all offer free logging
search for "Excel exercise log template" or similar on google and you'll find free download templates
http://www.vertex42.com/ExcelTemplates/running-log.html
Fair point TooTall, but for US$10 I thought it might be worth it for someone else to have done all the hard work! And you never know, I might get to like the extra features like calculating how much per km your tyres or chain cost!?!
Best to just make your own I reckon, it's not hard in Excel. I've done a fairly simple one that I input a weekly summary into from connect.garmin.com, then it highlights the top 5 weeks in each category i'm interested in and does rolling averages for distance. It also totals everything up and tells me how many more training weeks I've got until Keilder and what percentage of the time from when I started training for Keilder has gone. It's not overly complicated, but it could be if I decided I wanted to know something else as well.
The obvious thing to add would be a log for each ride that would then feed the weekly summary, but using a Garmin to record training emans it's easier to use connect.garmin.com and then just pull the weekly summary out. I'm not bothered what I've done each day, so long as each week is consistently decent. I'll probably add a monthly summary as well for tracking longer-term fitness.
"hard work! "
are you at all familiar with excel or live under a rock ? even doing a cost per mile of tires is still just =sum(tire cost / total milage)
Er..um..yes Trail Rat, I am familiar with excel as I'm an engineer. I could also maintain my own car, but I choose to pay someone else to do it because I'd rather be doing something else (bike is a different matter - I always work on that myself - it's half the fun). But with excel- if someone else has put together all the features that are useful, has ironed out the bugs, will send me an update every few months with the latest tweak, then maybe he deserves ten bucks, and I go riding instead!
=sum(tire cost / total milage)
That'll be =tire cost / total milage
HTH
haha so it would - i learnt spreadsheets on amigas and you had to put sum in - ive always done it since then
20 minutes work for 10 bucks .... although as with anything its only as good as the guy using it is at updating it.
That log is riddled with errors as VB & VBA developer I sent him a copy with a list of the errors and a unlocked setup as I had the password in minutes. Save your money. If you can't wrie your own, let me know what you want and I'll knock it up 🙂
Yeah I've kept a Daily commute log in the past, just milage, time taken and working out averages, it allowed me to work out my average speed, and do a trip by trip, week to week type graph simply to see if I was improving or not (Mostly not)...
These days I'm giving Sports tracker a whirl which isn't bad at all, although I might start looking a bit more at the upload options for it as it might be nice to turn the data into a spreadsheet.
The reason you should make your own is that you can decide what you want it for, what is useful for you and what you want to know etc. You can also look at the information you are recording and setup the sheet around that. That way you'll end up with something simple to use and clear in it's output that might actually be useful. Rather than something that's a pain to input data to so you don't use it for long and has an overly complicated output so you get no real benefit from the information.
If you only record time and distance then anything more complicated than a mileage and pace log will be largely useless for you. If you have altitude, temperature, calories, average heart rate etc, you might want something more complicated.
For example, you might ride road and mtb and want some sort of equivalence output so you can track your training taking into account which bike you've been on. Eg average MTB speed is 11mph, average road speed is 18mph, so have an output where mtb mileage is multiplied up to an 18mph average. Then you might want to factor altitude gained into the equivalence and reduce the 18mph based on how much climbing you do.
Hmmm, didnothingfatal, if its buggy, then maybe they don't deserve my ten bucks afterall! I'll check out the free options others have suggested above... and yes, trail rat, just to make you happy I might even see if I can write one myself - lets see.. a few nested if/then loops and a bit of boolean algebra should do it...