Are you with me
Join Date: May 2002
Location: Washington D.C.
Bikes: Giant TCR Advanced SL, Blue T-14 TT bike
Mentioned: 2 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Make your own bike-tracking database
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.