View Single Post
Old 09-30-05 | 07:02 PM
  #20  
2manybikes
Senior Member
20 Anniversary
 
Joined: Jun 2003
Posts: 18,138
Likes: 324

Bikes: 2 many

Originally Posted by HiYoSilver
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
This is really getting good. It can answer so many questions. It should be a sticky, or at least saved for easy posting. I'm almost thinking there should be a Night Riding section in the forums.
2manybikes is offline  
Reply