Solving the traveling salesman problem using the online version of excel.
I know there a many templates out there that can auto calculate using Google Maps, but I’m using the online version, so I don’t have the luxury of using these.
As of now, I have individual tabs for our 9 drivers. Each tab is identical, consisting of a column for the name of the destination, the number of items being delivered, and any comments. These are then displayed on the main route tab so all the drivers and their routes are shown at once.
My assumption is that I would have to create another tab that lists all our accounts and either their addresses or how far they are from us in miles. Is this the most efficient way to start this, or is there another way that I don’t know of? Any help would be much appreciated.
[link] [comments]
Want to read more?
Check out the full article on the original site