Data freaks
Page 1 of 2 12 LastLast
Results 1 to 25 of 29

Thread: Data freaks

  1. #1
    Frog Whisperer
    Reputation: Touch0Gray's Avatar
    Join Date
    May 2003
    Posts
    40,268

    Data freaks

    Those of you who know anything about me know that I am kinds of a gps/data freak. I have been riding with gps since the end of 2005. I have been a dedicated SportTracks user since then. A few months ago, SportTracks informed its software users that we are reaching its "end of life"

    I decided that I could not risk losing all my data so I carefully exported them ALL to .gpx files and have 1271 gpx files from 2006, start of the season until present, and 3 .xls files with all rides including trainer from 2001 to 2006.

    New stuff is all being automatically uploaded to Garmin Connect but I archive them all myself as well.
    Of course I'm sure...that doesn't mean I'm right.....

    "There's no sense being stupid unless you show it."

    "that was like trying to teach a goldfish how to play basketball over the phone."

  2. #2
    Sweet Potato Kugel
    Reputation: Eretz's Avatar
    Join Date
    Jul 2012
    Posts
    5,437
    I what to see your work. That's a lot of data.
    Last edited by Eretz; 06-11-2019 at 03:51 PM.

  3. #3
    Frog Whisperer
    Reputation: Touch0Gray's Avatar
    Join Date
    May 2003
    Posts
    40,268
    Quote Originally Posted by Eretz View Post
    I what to see your work. That's a lot of data.
    Have it your way!
    Attached Images Attached Images
    Of course I'm sure...that doesn't mean I'm right.....

    "There's no sense being stupid unless you show it."

    "that was like trying to teach a goldfish how to play basketball over the phone."

  4. #4
    RoadBikeReview Member
    Reputation:
    Join Date
    Dec 2005
    Posts
    893
    A good friend of mine started riding in the early 1980s when I did, and we started riding together in the late 80s. He has and continues to record every ride with pen and paper in notebooks. He's probably averaged 5k miles per year since he started riding.

    He's not a luddite, he rides di2 and has other nice toys.

  5. #5
    What the what???
    Reputation: Opus51569's Avatar
    Join Date
    Jul 2009
    Posts
    10,431
    As hoarding goes, could be a lot worse.
    Attached Images Attached Images
    The Law of Headwinds states: If the ride out is easy you better leave something in the tank for the turn...

  6. #6
    Frog Whisperer
    Reputation: Touch0Gray's Avatar
    Join Date
    May 2003
    Posts
    40,268
    Quote Originally Posted by ogre View Post
    A good friend of mine started riding in the early 1980s when I did, and we started riding together in the late 80s. He has and continues to record every ride with pen and paper in notebooks. He's probably averaged 5k miles per year since he started riding.

    He's not a luddite, he rides di2 and has other nice toys.
    This might, or might not be easier. I like the fact that this provides me with maps, and minute details about the ride. I have a lot of difficulty locating papers and pencils that I JUST had in my hand, if you know what I mean.
    Of course I'm sure...that doesn't mean I'm right.....

    "There's no sense being stupid unless you show it."

    "that was like trying to teach a goldfish how to play basketball over the phone."

  7. #7
    tlg
    tlg is online now
    RoadBikeReview Member
    Reputation: tlg's Avatar
    Join Date
    May 2011
    Posts
    14,392
    https://tapiriik.com/ is a free app that can link multiple tracking apps and sync all your data.
    Custom Di2 & Garmin/GoPro mounts 2013 SuperSix EVO Hi-MOD Team * 2004 Klein Aura V

  8. #8
    RoadBikeReview Member
    Reputation:
    Join Date
    Jan 2002
    Posts
    2,612
    I started recording my ride data in Excel in 1993. To date, I've recorded 4,457 rides totaling 184,621 miles, which is about 77% of my lifetime goal. I have various tables and graphs that summarize the data. I also enter various notes about about the ride, e.g. who I rode with, where we went, what if anything significant happened, etc. I also use the spreadsheet to keep track of what maintenance and repairs have been done on my various bikes.
    Insert something clever here:

    Insert list of every bike I own here:

  9. #9
    Frog Whisperer
    Reputation: Touch0Gray's Avatar
    Join Date
    May 2003
    Posts
    40,268
    Quote Originally Posted by tlg View Post
    https://tapiriik.com/ is a free app that can link multiple tracking apps and sync all your data.
    I see it also works with SportTracks, which would be great EXCEPT only with the Mobi app. The stand-alone SportTracks software lives on my computer and was a one time purchase (well not really, it was freeware, then donate-ware then buy it...) so I actually paid twice but I like the fact that it is on my physical machine and I am responsible for backing up. I am what you might call "anal" about redundancy, I have all my important information of ANY kind in at least 3 places. As much as I love SportTracks, I cannot rationalize paying a $59 fee per year. ST3 works offline and it MAY continue working forever but they could not assure me due to the fact that there are several features (weather, maps, etc) that get date from the web.
    Of course I'm sure...that doesn't mean I'm right.....

    "There's no sense being stupid unless you show it."

    "that was like trying to teach a goldfish how to play basketball over the phone."

  10. #10
    Frog Whisperer
    Reputation: Touch0Gray's Avatar
    Join Date
    May 2003
    Posts
    40,268
    Quote Originally Posted by AlanE View Post
    I started recording my ride data in Excel in 1993. To date, I've recorded 4,457 rides totaling 184,621 miles, which is about 77% of my lifetime goal. I have various tables and graphs that summarize the data. I also enter various notes about about the ride, e.g. who I rode with, where we went, what if anything significant happened, etc. I also use the spreadsheet to keep track of what maintenance and repairs have been done on my various bikes.
    I don't think I had ever heard of excel in 1993, maybe LotusWorks...lol. Maintenance is also logged.

    since 2002, I am showing a total of 49,512 miles. Pre 2002 is gone forever!
    Of course I'm sure...that doesn't mean I'm right.....

    "There's no sense being stupid unless you show it."

    "that was like trying to teach a goldfish how to play basketball over the phone."

  11. #11
    Master debator.
    Reputation: nOOky's Avatar
    Join Date
    Mar 2009
    Posts
    8,533
    I'd love to see all of my ride data from about 1984 and on. Even when decent bike computers came out pre-GPS I never really wrote anything down. It's hard to brag about the rides you did as a kid when you can't prove it.
    "I felt bad because I couldn't wheelie; until I met a man with no bicycle"

  12. #12
    pmf
    pmf is offline
    RoadBikeReview Member
    Reputation:
    Join Date
    Feb 2004
    Posts
    5,199
    Quote Originally Posted by AlanE View Post
    I started recording my ride data in Excel in 1993. To date, I've recorded 4,457 rides totaling 184,621 miles, which is about 77% of my lifetime goal. I have various tables and graphs that summarize the data. I also enter various notes about about the ride, e.g. who I rode with, where we went, what if anything significant happened, etc. I also use the spreadsheet to keep track of what maintenance and repairs have been done on my various bikes.
    I've been doing the same thing for years. Most of my rides are commuting to work, but riding in DC, you see stuff, like a pink, sweaty Bill Clinton right behind at an intersection one morning, out jogging with three huge Secret Service guys. It's fun to go back and look at the noted over the years when I bored.

    I also have the jersey number for a century I do every year for the past 26 years. I started writing notes on the back of those things 15 years ago.

  13. #13
    gazing from the shadows
    Reputation: QuiQuaeQuod's Avatar
    Join Date
    Jan 2003
    Posts
    26,352
    Quote Originally Posted by nOOky View Post
    It's hard to brag about the rides you did as a kid when you can't prove it.
    It's easy when you can't prove it.
    .
    Stout beers under trees, please.

  14. #14
    gazing from the shadows
    Reputation: QuiQuaeQuod's Avatar
    Join Date
    Jan 2003
    Posts
    26,352
    So, how do you all use this data? What have you learned by looking at data from multiple years? For example, drop offs after ramping up miles in multiple years might give you an idea of what level of riding increase causes overtraining effects.

    Not yearly data (for training for a goal like a century or a particular race), not aggregate data for maintenance and repairs which could be done with an odometer, but multiple year data at the individual ride level of measurement. I am curious if people do anything with such detailed time series data.
    .
    Stout beers under trees, please.

  15. #15
    RoadBikeReview Member
    Reputation:
    Join Date
    Jan 2002
    Posts
    2,612
    Quote Originally Posted by Touch0Gray View Post
    I don't think I had ever heard of excel in 1993, maybe LotusWorks...lol.!
    Yeah, I started with Lotus 123. Actually VisiCalc before that - I'm an old nerd. Don't remember when I made the switch to Excel. But Wikipedia says Excel for Windows (ver. 2) came out in 1987.
    Insert something clever here:

    Insert list of every bike I own here:

  16. #16
    RoadBikeReview Member
    Reputation:
    Join Date
    Jan 2002
    Posts
    2,612
    Quote Originally Posted by QuiQuaeQuod View Post
    So, how do you all use this data? What have you learned by looking at data from multiple years? For example, drop offs after ramping up miles in multiple years might give you an idea of what level of riding increase causes overtraining effects.

    Not yearly data (for training for a goal like a century or a particular race), not aggregate data for maintenance and repairs which could be done with an odometer, but multiple year data at the individual ride level of measurement. I am curious if people do anything with such detailed time series data.
    I look at the data graphically. For example, this chart shows my cumulative miles each year, so I can see how I compare to prior years.
    Attached Images Attached Images
    Insert something clever here:

    Insert list of every bike I own here:

  17. #17
    RoadBikeReview Member
    Reputation:
    Join Date
    Jan 2002
    Posts
    2,612
    Here's another chart that shows how many rides I've done of varying distance.
    Attached Images Attached Images
    Insert something clever here:

    Insert list of every bike I own here:

  18. #18
    RoadBikeReview Member
    Reputation:
    Join Date
    Jan 2002
    Posts
    2,612
    Here's a chart that shows the breakdown on my miles each year by day of the week. You can see that from 2004 to 2008, I did most of my riding on the weekends - that's because I had a job that involved long hours and didn't give me much time to ride during the week. But the money was good, so I banked as much as I could and retired in 2008.
    Attached Images Attached Images
    Insert something clever here:

    Insert list of every bike I own here:

  19. #19
    RoadBikeReview Member
    Reputation:
    Join Date
    Jan 2002
    Posts
    2,612
    Here's another chart that I made for a few years where I kept track of vertical feet climbed each ride, and compared the data for each year with some linear regression analysis.
    Attached Images Attached Images
    Insert something clever here:

    Insert list of every bike I own here:

  20. #20
    RoadBikeReview Member
    Reputation:
    Join Date
    Jan 2002
    Posts
    2,612
    Want more? Here's a chart of miles broken out by month for each year.
    Attached Images Attached Images
    Insert something clever here:

    Insert list of every bike I own here:

  21. #21
    Frog Whisperer
    Reputation: Touch0Gray's Avatar
    Join Date
    May 2003
    Posts
    40,268
    Quote Originally Posted by QuiQuaeQuod View Post
    So, how do you all use this data? What have you learned by looking at data from multiple years? For example, drop offs after ramping up miles in multiple years might give you an idea of what level of riding increase causes overtraining effects.

    Not yearly data (for training for a goal like a century or a particular race), not aggregate data for maintenance and repairs which could be done with an odometer, but multiple year data at the individual ride level of measurement. I am curious if people do anything with such detailed time series data.
    Funny story, my wife was totally insistent that on a certain day, the weather was a certain way, my SportTracks has weather for that day recorded.

    So I was able to prove myself right!

    Also, I do look back and see where I was riding, elevation and effort.
    Of course I'm sure...that doesn't mean I'm right.....

    "There's no sense being stupid unless you show it."

    "that was like trying to teach a goldfish how to play basketball over the phone."

  22. #22
    Frog Whisperer
    Reputation: Touch0Gray's Avatar
    Join Date
    May 2003
    Posts
    40,268
    And these graphs are the reason I will miss SportTracks I can change data fields easily
    Attached Images Attached Images
    • File Type: jpg 2.jpg (98.9 KB, 64 views)
    Of course I'm sure...that doesn't mean I'm right.....

    "There's no sense being stupid unless you show it."

    "that was like trying to teach a goldfish how to play basketball over the phone."

  23. #23
    RoadBikeReview Member
    Reputation:
    Join Date
    Oct 2005
    Posts
    3,148
    Quote Originally Posted by AlanE View Post
    Want more? Here's a chart of miles broken out by month for each year.
    I thought your miles by day graph was trippy was but this one.... wow man.

  24. #24
    Sweet Potato Kugel
    Reputation: Eretz's Avatar
    Join Date
    Jul 2012
    Posts
    5,437
    Quote Originally Posted by dir-t View Post
    I thought your miles by day graph was trippy was but this one.... wow man.
    Total quaalude ^^^ He data pointed a great deal of info. Really amazing.
    In a time of universal deceit - telling the truth is a revolutionary act.
    Ben Franklin -Tis curious and amazing to observe how distinct and independent of each other the rattles of this animal are, and yet how firmly they are united together

  25. #25
    Sweet Potato Kugel
    Reputation: Eretz's Avatar
    Join Date
    Jul 2012
    Posts
    5,437

    Most of my rides were/are commuting. So olde sheit, but different day. I recorded weather and temperature to0 in logs, as well as the hours worked that day which impacted performance. The days I left later, and more tired gathered drafting of city buses and local traffic bringing up average speeds. The city stop lights synchronize at peak hours too. If I left at 14:30 my trips were slower through populated areas due to schools and schooling traffic. If I left at 17h00, loads of green lights on major suburban ways to keep congestion down.

Page 1 of 2 12 LastLast

Similar Threads

  1. Garmin Edge 1000 data v Strava app data
    By Mandeville in forum General Cycling Discussion
    Replies: 20
    Last Post: 12-28-2015, 03:33 AM
  2. Attn: shoe freaks (sz. 40-41) & Motta fans
    By Spirito in forum Retro-Classic
    Replies: 0
    Last Post: 12-21-2004, 07:39 PM
  3. Wheel durability data-base: enter your data here:
    By yzfrr11 in forum Components, Wrenching
    Replies: 26
    Last Post: 12-17-2004, 09:08 PM
  4. Any RC Car freaks out there?
    By 10kman in forum The Lounge
    Replies: 3
    Last Post: 05-19-2004, 10:03 AM
  5. Welcome all Colnago freaks
    By reddach in forum Colnago
    Replies: 8
    Last Post: 03-28-2004, 06:44 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

THE SITE

ABOUT ROADBIKEREVIEW

VISIT US AT

© Copyright 2019 VerticalScope Inc. All rights reserved.