Using Excel Solver for A Traveling Salesman Problem

Download the file to start with at bit.ly/execfile1
Thanks for watching my video!! Please check out my newsletter "The Free-Range Technologist" on Substack, where I share all my latest discoveries, tutorials, books, useful apps, and lifehacks. Check it out and sign up here: frtech.substack.com/welcome
I am a technologist and an Associate Teaching Professor of management at the Trulaske College of Business, where my interests focus on technology's impact on society. You can connect with me on my website (www.christiansonjs.com/), LinkedIn ( / jscottchristianson , or Twitter ( / jscottmo .

[@bsabrunosouza]

Thanks for showing off Solver's amazing features!

[@robbyadyasmara2627]

Thanks Brother, i got the great technique

[@skenming]

The solver stop after around 1 minute even I left my 'time limit' setting blank. How could yours run over time limit?

[@joshuabosquet8114]

And how would you define the objective function of this problem mathematicaly for example
Minimise total distance z =

[@Gtownrealist28]

Hi Scott can you help with another TSP?

[@akashbankar7721]

Hi can you please help with the MTSP code

[@COOLDUDE090]

do you know how to do it in latitude and longitude, can you give formula for distance if its real coordinates?

[@ciobicaana-maria2730]

you can use haversine formula or Lambert's

[@joshuabosquet8114]

Which chapter did you find this problem ?

[@winnieng6102]

Can I do multiple visit as some location requires visit in every 2/4/8wks

[@Prof_C]

Good question. You would have to break that into seperate trips. This will just work for one Trip if I remember right.

[@chinhonglee8570]

i need help with tsp also city to city

[@muhamadridhoherman-3750]

Is this consider with genetic algorithm?

[@DAcutech]

How do I download the file to follow along?

[@Prof_C]

bit.ly/execfile1

[@DAcutech]

@@Prof_C Thanks a lot. Your video has been really helpful for me .

[@GautamJr]

Can you share that excel file

[@Prof_C]

Yes, it is here: bit.ly/execfile1

[@GautamJr]

@@Prof_C Thank you so much!! 🙏