View Single Post
Old 09-30-05, 07:02 PM
  #20  
2manybikes
Senior Member
 
Join Date: Jun 2003
Posts: 18,138

Bikes: 2 many

Mentioned: 13 Post(s)
Tagged: 0 Thread(s)
Quoted: 1266 Post(s)
Liked 323 Times in 169 Posts
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