Mileage tracking

So, I’ve gone ahead and put together a custom spreadsheet in Microsoft Excel to track mileage. All you really have to do is plug your distance into the Data input sheet, and the rest of the heavy lifting is handled automatically by the formulas. Does it work? Is it overkill? I’m open to any suggestions, critiques, or even a bit of praise if you think it hits the mark.

http://www.filedropper.com/cyclingtr...logver14042014

Best regards,
Robert Murphy6

It might be useful if the Average speed could be automatically calculated within the Data input sheet 🤔

Ryan Thomas4 said:It wouldn't be the worst idea if the average speed in the Data input sheet were to calculate itself automatically, would it? 🤔

I might just give that a shot myself—assuming I can actually figure out how to pull it off, of course. Thanks for the suggestion.

It’s actually pretty straightforward 😉
=cell with mileage/cell with time/24
For instance, if you were looking at April 16, 2014, the formula would look like this:
=C121/D121/24

Ryan Thomas4 said:It isn't actually that complicated, 😉 if you just use
=cell with mileage/cell with time/24
for instance; for April 16, 2014, the formula would look like this:
=C121/D121/24

I understand the theory behind it—you know, distance divided by time—but it doesn't quite work out using the method you described. I did some digging online and discovered that you need to utilize the INT function to get it right. On top of that, I went ahead and layered in an IF statement to ensure the fields remain blank until actual values are entered. Does that make sense?

The updated version is available at http://www.filedropper.com/cyclingtr...gver14042014_1

Hope I'm not crashing the party here... anyway, check out my latest handiwork!



- monthly stats -



- yearly stats -

And everything else is over at...

Chris Kelly16's BikeLog 1.0

P.S. ...I feel like I might've posted this somewhere before, so sorry if I'm being a total nuisance... 🙂

Robert Murphy6 said:I understand the theory behind calculating distance and time, but it doesn't quite work the way you described. I found an online workaround using the INT function. I also ended up adding some IF statements just to keep the fields blank until a value is actually entered.

It works on my end. 🤔

(I added an IF statement to prevent those #DIV/0 errors from popping up in the statistics.)

Hey, can you fix that link? Looks like there's a colon missing somewhere... :-)

My apologies, I accidentally included an extra https:// link. I've fixed it now. 👍

Chris Kelly16 said:I hope I’m not stepping on anyone's toes here... anyway, here is my handiwork.



- monthly stats -



- annual stats -

And everything else can be found at...

Zeljko's BikeLog 1.0

P.S. ...it feels somewhat like I might have posted this already, so please forgive me if I'm being a bit redundant... 🙂

How could you possibly be an interruption? Every single suggestion or idea is more than welcome.

Here is the latest iteration 🙂 I caught a few details floating around in Chris Kelly16's BikeLog that really needed to be accounted for, so I’ve integrated them into this version.

http://www.filedropper.com/cyclingtr...gver14042014_2

You can grab the Cyclinglog 2016 version directly from the blog here: https://oxygenbikeclub.wordpress.com...clinglog-2016/

As always, I’m more than happy to hear what you all think—every suggestion or bit of feedback is genuinely appreciated.

I honestly don't see the point of using this data input sheet when every smartphone out there has built-in GPS that tracks everything automatically.
Maybe I'm just missing something here? 🤷

Austin Rodriguez5 said:I don't really get the point of this spreadsheet when every single phone has GPS built-in to track everything.
Am I missing something here? 🤷

I keep a log just like this because I run a bike computer and my phone at the same time.
Phones fail. Sometimes I forget to hit record or the battery dies mid-ride. This way I stay in control and actually enjoy tracking my stats.

Robert Murphy6 said:You can grab the Cyclinglog 2016 version over on the blog here: https://oxygenbikeclub.wordpress.com...clinglog-2016/

I'm all ears for any suggestions or ideas you guys have.

Got it downloaded. I'll give it a spin as soon as the weather clears up enough to actually get out on a ride. Either way, thanks for putting in the work and sharing this with us. 👍

Jeffrey Hall5 said:Downloaded. I'll give it a test run as soon as the weather clears up enough to actually get out on the road. Regardless, thanks for putting in the work and being so selfless 👍

Thanks. You can even test it out without hitting the road first; that way, if there's some glaring error I need to fix, I can get it sorted before the season really kicks into high gear. 🙂

I've put together a new mileage tracking spreadsheet in Microsoft Excel for the 2017 season. You can grab the file over on my blog at Oxygen Bike Club
.
If you have any ideas on how to make it better, please don't hold back—I'm all ears.

Best,

Last year's spreadsheet was way easier to read—at least if you ask me. This new one feels a bit cluttered, honestly. That’s why I just swapped out the year on my old setup, ditched February 29th, and I'm using it for 2017 too. The 2016 version gives me everything I actually care about—total mileage, total hours, and how many rides I took. For me, that's plenty.
Anyway, thanks for putting in the work to build such a solid, functional log for tracking rides. I'm also a big fan of your blog—you've got a great collection of useful tips and advice all in one spot.

Jeffrey Hall5 said:Last year's spreadsheet was much cleaner and easier to navigate (at least if you ask me). This current one feels a bit cluttered with too much data shoved into one view. That's actually why I just updated the year on last year's version, stripped out February 29th, and I'm still using it for 2017. Honestly, the 2016 layout gives me everything I actually care about: total mileage, total hours, and number of rides. For my purposes, it’s more than enough.
Regardless, I really appreciate the effort you're putting in to build such a functional tool for tracking rides. I also enjoy reading your blog; you manage to gather so many useful tips and insights all in one convenient spot.

Thanks. I always try to tweak things a little so the whole process doesn't become a monotonous chore, you know? 🙂

I actually attempted to include average speed and pace per mile right under the date alongside the distance and duration, but the screen became an absolute mess of numbers. To save my eyesight, I decided to split them into two separate tabs instead.
And thanks for the kind words about the blog. My whole goal here is to promote cycling as a fantastic way to stay active and enjoy life, so whenever I stumble upon a great article, how could I possibly justify not sharing it with the rest of you?

I’ve gone ahead and put together an Excel spreadsheet to help track mileage for the 2018 season. You can grab the file over on my blog at Marquee New York.

If you have any ideas on how to make it better, please don't hold back—I'm all ears.

Best,