Controlling Route Order in MS Streets & Trips

August 15, 2010
By Bill/Dad/Grandpa

Bill Gates uses some magical sort order on the routes that one imports into Micro$oft Streets & Trips. Unfortunately, the order specified by Bill is NOT the order that I want. Nowhere could I find a resource to fix this problem ……. so I wrote one. The resource can be accessed (without charge) at my web page … www.my-teacher.ca .

Documentation is pretty thin, so I prepared a video describing how to operate the program.  The instructional video can be reached here.

Basically, you import data from a spreadsheet into Streets & Trips. The NAME of the items contain a numeric prefix describing the order that your route is to follow. You then export this data into a GPX file, upload the GPX file to the program residing on my web page. It will sort the data, attach the sorted file to an email that gets sent to you. Finally, you import the sorted file back into a blank Streets & Trip map. The data appears in YOUR order….not in Bill Gates order.

I hope that you find this tool useful. If it works for you, let me know. IF IT DOESN’T WORK FOR YOU, let me know as well…. so that I can resolve the problem.

6 Responses to Controlling Route Order in MS Streets & Trips

  1. scholarships on November 5, 2010 at 07:51

    TYVM, wonderful job! Just what I had to have.

  2. educational grants on September 21, 2010 at 20:32

    nice post. thanks.

  3. Heather on August 25, 2010 at 06:11

    PS – Nice video too!

  4. Heather on August 25, 2010 at 06:08

    I’m impressed too! Althought definitely not surprised… :)

    Funny, because I was out for dinner with friends last night, who are also former colleagues, and I received an email from Dad. Upon telling them this, my friend Les said,
    “Oh, let’s ask him something and see if he knows the answer…” as he was part of the crew that was at a work meeting once upon a time when I needed to know an answer to something … so I called Dad … and, of course, he knew the answer. Dad is now known for being the guy who knows everything (which he pretty much does).

  5. Bill/Dad/Grandpa on August 16, 2010 at 06:37

    It means that when planning a route in a table (Excel), we can change our minds as often as necessary and still be able to use Streets & Trips without getting frustrated by having to resort the data manually (a VERY time consuming affair).

  6. Ann/Mom/MaeMae on August 15, 2010 at 22:43

    WOW I’m impressed, even if I don’t understand what this means!!!

Powered by Netfirms