Author Topic: Buying Microsoft Autoroute  (Read 1241 times)

Buying Microsoft Autoroute
« on: December 18, 2013, 01:56:43 pm »
Is it best to get version 13 or are earlier ones just as good?
When does the 2014 version come out, is it worth hanging on for it?
Can I get it cheaper than from Amazon £44.77?
http://www.amazon.co.uk/Microsoft-AutoRoute-Euro-2013-PC/dp/B00960K51E
Am I better off with the PC disk version (above), or will the download be OK for only £29.58?
http://www.amazon.co.uk/gp/product/B00DRP5C5S/ref=pd_lpo_sbs_dp_ss_1?pf_rd_p=103612307&pf_rd_s=lpo-top-stripe&pf_rd_t=201&pf_rd_i=B00960K51E&pf_rd_m=A3P5ROKL5A1OLE&pf_rd_r=15NCM07KX0MMZP1VTHQ5

Apologies for stupid Q

frankly frankie

  • I kid you not
    • Fuchsiaphile
Re: Buying Microsoft Autoroute
« Reply #1 on: December 18, 2013, 02:19:32 pm »
I've not got a more recent version than ... er, ... 2001 (which still does get some use, amazingly).

I had bought several versions before that one, but each version seemed worse than the previous one, so I stopped.  That is, maybe the maps improved, but the UI invariably got worse. There always seem to be file compatibility problems between versions as well, which is a pain.

Hopefully recent versions have improved on this, but it's hard to believe you wouldn't be better off using Google Maps or one of the many Gmaps-derivative Planners.
It's not dark yet but it's getting there.

Re: Buying Microsoft Autoroute
« Reply #2 on: December 18, 2013, 04:31:50 pm »
For most things google maps is fine, but I need the functions of 'import data ' & 'optimise stops' to help generate a route between a list of unsorted destination postcodes - see https://yacf.co.uk/forum/index.php?topic=78621.0

Richard Fairhurst

  • on the trail of the little blue stickers
Re: Buying Microsoft Autoroute
« Reply #3 on: December 18, 2013, 05:33:01 pm »
At the risk of sounding a bit JFGI, have you tried just... um... Googling it?

In the previous thread, tom_e correctly observed that this is called the "Travelling Salesman problem". So if I Google 'travelling salesman google maps', I get http://gebweb.net/optimap/ .

I've tried it out and, well, it seems to work. Note: "If more than 15 locations are specified, you are not guaranteed to get the optimal solution, but the solution is likely to be close to the best possible."
cycle.travel - maps and route-planner

Re: Buying Microsoft Autoroute
« Reply #4 on: December 19, 2013, 07:08:13 am »
At the risk of sounding a bit JFGI, have you tried just... um... Googling it?

In the previous thread, tom_e correctly observed that this is called the "Travelling Salesman problem". So if I Google 'travelling salesman google maps', I get http://gebweb.net/optimap/ .

I've tried it out and, well, it seems to work. Note: "If more than 15 locations are specified, you are not guaranteed to get the optimal solution, but the solution is likely to be close to the best possible."

 ;D
Incredible !

And it exported a TomTom Itinerary file of the 'round trip' route.

Although, when I check the route ON the TomTom, its shorter than the suggested roads on Optimap.


What's really incredible is when I load in the Controls and Info of one particular BP 100', it tells me to go to the INFO before the first control and gets the distance to 92 km.

Re: Buying Microsoft Autoroute
« Reply #5 on: December 19, 2013, 05:58:57 pm »



What's really incredible is when I load in the Controls and Info of one particular BP 100', it tells me to go to the INFO before the first control and gets the distance to 92 km.


That's quite interesting.  I noticed that one of my Old Squit 200 rides was short-cuttable in this way.  Only saw it a few days before when it was far too late to alter anything, so kept quiet hoping nobody would notice ;D

Keith

Re: Buying Microsoft Autoroute
« Reply #6 on: December 19, 2013, 08:37:16 pm »
Thanks Richard - that is perfect, I had googled, but sometimes its hard to find what you are looking for when you are not sure what it looks like.

It works fine up to around 60 locations (100 in theory, but it timed out when I tried with 99).

It has an interesting feature, which is to look up the suggested route in google maps. I hadn't realised until I saw the search it generated that I could use text to search for multiple location directions in google e.g. :

from:bs8 1tm to:bs8 1le to:bs8 1hj

This seems to work up to 25 locations at once, not sure what the limit is

Re: Buying Microsoft Autoroute
« Reply #7 on: December 20, 2013, 07:17:39 am »
Am I missing something?

Can I export the directions listing?

Otherwise, when I copy and paste the directions list to an Excel spreadsheet, each instruction and distance is on the spreadsheet in alternate rows, and is very messy ( deliberately , I feel ).

The distances come in either “mi” for miles or “ft” for feet.

With the value in column A and the unit in column B, I used

=IF(B3="mi",A3,IF(B3="ft",A3*0.0001893939," "))

To get the values all in miles.

Then, it is a case of moving the values to make a Routesheet.

Spreadsheet saved as 'Gebweb Routesheet Template.xlsx'.  ;D :thumbsup:

Re: Buying Microsoft Autoroute
« Reply #8 on: December 20, 2013, 07:34:37 am »
PS.

Duplicate the list of Instructions and distances to another column off to the right to do the workings.

Once you’ve got the result of the formula, copy and paste as Value.
Delete a cell above to align the values to the instruction.
Highlight the entire block of workings and apply Filter and disclude ‘Blanks’ from the column of distance values.
You get the instruction and distance compressed, which can be copied and pasted onto a new tab.

That has incredibly reduced the time to write an Audax Routesheet.
Very happy chappy.  :thumbsup: ;D

Re: Buying Microsoft Autoroute
« Reply #9 on: December 20, 2013, 01:10:17 pm »