CODEWITHSUNDEEP
cplexopl
Kaveri Kala
Kaveri Kala

Reputation: 15

How to present distance data on excel (or retrieve data from excel) while using CPLEX OPL?

I have three locations, multiple depots,multiple stops and multiple landfills. All depots, stops and landfills are separate (each starting from 1)? My distance variable d[i][j] (distance between i and j) where i can take any value from depot or stops and landfill. Same is happening with j. How to retrieve such data in .dat file and present in excel so that I can use it?

Upvotes: 1

Views: 72

Answers (1)

Alex Fleischer
Alex Fleischer

Reputation: 10037

In

https://github.com/AlexFleischerParis/opltipsandtricks/blob/master/read2Darrayfromexcel.mod

You may see an example of a 2D array read. That could be your distance matrix

Upvotes: 1

Related Questions