1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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.

submitted by /u/Shiftythemuse
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#rows.com
#Excel alternatives
#google sheets
#traveling salesman problem
#Excel
#Google Maps
#drivers
#delivery
#routes
#addresses
#miles
#template
#tabs
#accounts
#columns
#efficiency