View Single Post
Old 09-30-05, 06:50 PM
  #19  
HiYoSilver
Rides again
 
HiYoSilver's Avatar
 
Join Date: Oct 2004
Location: SW. Sacramento Region, aka, down river
Posts: 3,282

Bikes: Giant OCR T, Trek SC

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 6 Post(s)
Likes: 0
Liked 1 Time in 1 Post
Get the new openoffice 2, it's so much better.

Slvoid,

Some hints for next time you work on this:
1. put brand name on same line as each model, have to duplicate many
2. add a MSRP column as so many are price sensitive
3. put speeds in mph and kph in separate columns.

After those changes you can sort to get your needed info.

Some cool sorts:
Find brightest for time
1. sort 1, col f, road speed, decreasing
2. sort 2, col c, run time decreasing

Find best for highest speeds
1. sort col f, max speed, decreasing
2. sort col e, city speed, decreasing

Find best for long rides
1. sort col c, run time, decreasing
2. sort col d, avg speed, decreasing
HiYoSilver is offline