Forum Discussion
Unique values in excel
We supply products to 24 shops. Each worker must visit 4 shops daily. However they are not able to meet daily targets due to traffic and the wide distance between shops. I worked out the shortest poss...
I think you are not alone in the world with this problem :).
It is commonly known as (TSP) Travelling salesman problem.
The best thing to do is to enter "traveling salesman's problem" in google search, then it will quickly become clear to you (e.g. Wikipedia) what kind of problem you have encountered.
But there are several options on Excel: Implementation of the algorithm in VBA or using an optimization component such as solver.
Examble of a solution proposal with Solver
Examble of a solution proposal with VBA
Furthermore, I wish you much success in your project
Hope I was able to help you with this info.
NikolinoDE
Was the answer useful? Mark them as helpful!
This will help all forum participants.