I use AXLL::ReadSet to read the set element from Excel:
![](https://uploads-eu-west-1.insided.com/aimms-en/attachment/69655027-8350-48a1-ba52-e4f644617b8c.png)
And in excel the rank is
![](https://uploads-eu-west-1.insided.com/aimms-en/attachment/c33933e1-0a20-4240-acd9-8239281db25f.png)
However, the data in the set looks like this (the data is in a wrong ranking):
![](https://uploads-eu-west-1.insided.com/aimms-en/attachment/c7b35d17-ed06-43c8-a943-40f2be6ba704.png)
Sometimes, it ranks like this:
![](https://uploads-eu-west-1.insided.com/aimms-en/attachment/cc8310c0-26f0-4d9f-960c-b94435ba0f03.png)
Even though I define the elements directly:
![](https://uploads-eu-west-1.insided.com/aimms-en/attachment/4d77726d-3897-4af7-be2e-3d57b793867e.png)
Still, the data looks like this:
![](https://uploads-eu-west-1.insided.com/aimms-en/attachment/b45629c5-397c-4104-b10d-751a470e27ea.png)
I have ever encountered this problem before, and I was told to define the set as a subset of Integers and use Order by. However, I hope the data in the set is treated as element rather than value. So for a set Time := {1,3,5}, Time(1+1) := 3.
What wrong with this?
Best answer by Chris Kuip
View original