Using Excel Solver for A Traveling Salesman Problem

[@bsabrunosouza]

Thanks for showing off Solver's amazing features!

[@skenming]

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

[@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.

[@joshuabosquet8114]

Which chapter did you find this problem ?

[@akashbankar7721]

Hi can you please help with the MTSP code

[@Gtownrealist28]

Hi Scott can you help with another TSP?

[@GautamJr]

Can you share that excel file

[@Prof_C]

Yes, it is here: bit.ly/execfile1

[@GautamJr]

@@Prof_C Thank you so much!! 🙏

[@joshuabosquet8114]

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

[@NewPerspective86]

I think you can express the objective function as follows: Minimize Total Distance z = Σ[i=1, n] √(xi - x)^2 + (yi -y)^2, where n = no. of stores, and x & y are the respective store coordinates.

[@muhamadridhoherman-3750]

Is this consider with genetic algorithm?

[@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

[@robbyadyasmara2627]

Thanks Brother, i got the great technique

[@chinhonglee8570]

i need help with tsp also city to city

[@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 .