unabowler

My log is an Excel spreadsheet that I've kept since 2010. I use websites, too, and among mapmyride, Garmin Connect, and Strava, I like Strava for logging rides and mapmyride for mapping out new courses.

DBA

Another spreadsheet user, here.
However, I'm looking at the SigmaSport data center and getting a Rox10 or similar that can link to said software.

Machka 

I've been logging my distances since April 29, 1990. 24 years.

In the beginning I kept track in notebooks, then I put it all into an Excel spreadsheet which I continue to use to this day.

I also use bikejournal and BigDogs.

rm -rf

I got a Garmin for it's route map display. But I found I like to see the ride statistics, too.

I've been using My Tourbook, free, open source software that runs on my PC. It took a while to get all it's options set up the way I like it.

I set the main display this way. Top left is a ride list with monthly and yearly subtotals. Click on a ride and show it's route on the map, with the route line color coded by speed. The ride's charts, with elevation, speed, and heart rate at the bottom. The map and charts are zoomable.



The map zoomed in. Each dot is from the one-per-second gps recording.


One year of rides, zoomed in:

Hammondc

Map my Ride

Huskysibe

Thanks for all the ideas. I don't care about speed etc, I ride for exercise and would like to see my progress in the future.

bulevardi

Made an excel sheet.
Pop's up a form where you can log your commuting or recreative miles, and it automatically logs it to a list via macros.
Calculates miles aswel as metric system. Shows average amount miles per biked days or per day, updates a graphic, etc...

Will put it online somewhere later on so you guys can use it too
I'm commuting since march now, just over 100 miles today (commuting only)

I update it each day at work. Send it to my email adres to have it at home, so I can update at home in holidays when I ride recreationally.

dave s

This sounds interesting, I went to the app stroe and found a bunch of gps logger apps. Do you mind sharing which one you like/use?

thx!

bulevardi

Don't have a GPS or smartphone or app-medium, yet.
But do have a desktop at home, works fine for me

DBA

Will have to check this out tonight when I get home. Grazie.

cyccommute 

I record the daily rides in a Week-at-a-Glance calendar. At the end of the year I transfer the data to an Excel spreadsheet. I used to keep them all in the same workbook but that got too cumbersome...I have 25 years of records I have summarized the data for the last 25 year and just keep a summary of each year separately. I break out commuting miles from recreational miles and calculate an estimate of each year's savings on car mileage, gas, and carbon. I save, roughly, 1.5 tons of carbon a year.

DBA

Does that carbon reduction take into account the extra burritos for all the riding?

spdracr39

Another vote for Map My Ride. My whole family uses it and we can share and compare.

Huskysibe

A lot of map my ride folks. I had the app but deleted it because it would take forever to lock onto GPS andI hated waiting for it. I use Strava and it does a decent job but I like the function in MMR where I can look for routes near me.

mrodgers

I did that when I was riding a motorcycle. Found out that it cost more to ride the motorcycle than it did to drive the 20 mpg car. The problem was, I rode 20 miles into work in the dark, but then at 3 pm, it was 80° and beautiful out and the home ride would be 80 miles or so, LOL.

For the bicycle record, I run a cheap bike computer from Walmart and record the distance, time, average speed, and calories burned (the computer gives the lowest amount of calories out of several phone apps and online calorie calculators.) I jot them down in Excel and also use this to post in the Clyde section on the monthly mileage thread.

I didn't last year because I only rode on the bike trail, but this year since I started riding on the roads, I run MapMyRide. The ride time and average is usually off from the bike computer though because the pause function doesn't always work compared to the bike computer positively seeing that the wheel is no longer spinning. I've found MapMyRide off by 15-20 minutes as I was stopping for some photography moments on an hour and 45 minute ride.

caffein8ed

Another Map My Ride user here. I don't use the device app, though - I just pop my bike computer off after a ride, and go enter the data on my PC.

Vanicent

I use Strava.

Ludkeh

CycliStats

JimF22003

I'm a software developer person, so I just use my work tools, once of which is SQL Server. A touch overkill, but the querying ability is pretty much unmatched I've got history going back many years saved there. At some point I'll get around to putting a UI on it (cobbler's children and all that), so for now when I update my daily ride I do it this-a-way:

update journal set bikeid = 5, bikemiles = 34.37 --r5
where entrydate = CONVERT( CHAR(8), GetDate(), 112) --'2014-05-17' --

If I want to find out how many century rides I've done so far this year, I can do:

select * from Journal where entrydate between '2014-01-01' and '2014-12-31 23:59' and bikemiles > 99

Too geeky for words, but what can I say?

krobinson103

Endomondo. Three years of data in there.

bulevardi

Ok, I put my sheet online here:
https://users.telenet.be/bulevardi/demo/bikemileage.xls

Make sure you enable the macro's, otherwise it won't run some automated parts

Someone else wants to share his/her log sheet?

MikeDVB

Clever... I wonder if there is anything out there PHP+MySQL based for this purpose... I'm a developer myself of over a couple decades and could whip something up that can be hosted on just about any shared hosting server. [I run a hosting provider myself, so I have plenty of access to that on my own personal account]...

If there's interest I may make it available to others. Being that this would be a personal project just for the fun of making something I can't make any promises but if anybody has any ideas of features that they would like included feel free to drop me a PM.

bulevardi

Could be very handy to log everything webbased. Than I don't have to transfer my excel file to different locations where I use it (work or home or somewhere else).

If you have too much spare time to make it
But personally, I like filling in my own made sheet at the moment, as I spend some time and work in it to make it.

MikeDVB

I can create a basic web-based logging system pretty quickly but it would be very basic - date/time, duration, distance. I will have to look and see what others are wanting logged.

I know I've never worried about gear ratios or crank sets before but I'm learning .

RoadTire 

Excel updated from whatever tracking device(s) I'm using. The spreadsheet is so I can change Apps w/o losing history. Currently using Endomondo, considering changing just don't know what too. Once every few rides my phone/Endomondo/User Error causes no ride data, but I have use a bike comp also, so always get some tracking data.