Hi,

I am having difficulty to add one constraint in excel.

It is travelling salesperson problem. Let's say there are 7 cities. Origin is 0 and the rest cities are 1 to 6. After travelling all cities, salesperson must come back to origin.

To avoid subtour, we need constraint of ui - uj + Nxij <= (N-1).

Anybody can know how to put this constraint in excel spreadsheet to solve the problem with excel solver?

Your reply will be very much appreciated!!

Thanks!