Go Back  Bike Forums > Bike Forums > Mountain Biking
Reload this Page >

Make your own bike-tracking database

Mountain Biking Mountain biking is one of the fastest growing sports in the world. Check out this forum to discuss the latest tips, tricks, gear and equipment in the world of mountain biking.

Make your own bike-tracking database

Old 08-24-07, 08:39 AM
  #1  
Flash
Are you with me
Thread Starter
 
Flash's Avatar
 
Join Date: May 2002
Location: Washington D.C.
Posts: 1,311

Bikes: Giant TCR Advanced SL, Blue T-14 TT bike

Mentioned: 2 Post(s)
Tagged: 0 Thread(s)
Quoted: 2 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
Make your own bike-tracking database

I plan to buy my first full SUS bike later this year or early '08. I generally check specs on manufacturer websites (most of these websites are complete disasters in terms of user interfaces, but that's another story), then I check reviews on mtbr.com and search for threads here. Ultimately I will end up with a list of bikes to test ride.

I got tired of continually returning to manufacturer websites, re-typing keyword search terms in the mtbr.com interface, trying to compare bikes in my head. So, I designed an Excel spreadsheet to keep track of key info. I hyperlink to manufacturer pages and mtbr reviews/relevant bikeforums threads to get expanded information. I can rank the bikes, sort on any of the numeric fields (standover, bb height, top tube length, price etc.) A good deal of legwork up front, but worth it in the end.

I'm a database designer by trade and this would be a nice web app, but Excel is great for personal use when data integrity only matters to me and a real database would be overkill.

Below is a screen shot of the xls. Currently the Iron Horse 6 point series is top-ranked as I'm looking for an all-mountain full sus bike I can afford and I currently ride an IH warrior comp which I really like, so I'm somewhat brand-loyal. The rankings can change daily, however, as I seem have a weak spot for FR hardtails. Actual riding impressions will be added once I start testing. It's a lot of fun to mess around with.

Enjoy.


Flash is offline  
Old 08-24-07, 09:06 AM
  #2  
DoYlE_RiD3r
Senior Member
 
DoYlE_RiD3r's Avatar
 
Join Date: Apr 2006
Location: Canada, Quebec
Posts: 206

Bikes: Norco Rival "06

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
looks like a nice comparing table
DoYlE_RiD3r is offline  

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Thread Tools
Search this Thread

Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.