Hi,
I have been working with GAMS (newbie) and having an issue with dealing with a lot of data which is more than the number required in excel (.xlsx), thus my data is more than 1million.
Please what is the best way to overcome this problem?
Secondly I have to import Set mc (shown below) data from Excel into GAMS to display like this in GAMS: /1.(1,2), 2.(1,36), 3.(1,1851), 4.(2,3), 5.(2,37), 6.(2,1852), 7.(2,1886)/
The Sets are:
i ‘number of blocks’ /1,2,36,1851,1885,3,37,1852,1886/
mcs ‘number of mutually exclusive sets’ /1*7/
mc(mcs,i)’ description of mutually exclusive projects’ /1.(1,2), 2.(1,36), 3.(1,1851), 4.(2,3), 5.(2,37), 6.(2,1852), 7.(2,1886)/
Please how do I arrange the data in excel to display like the above in blue in GAMS.
Kindly assist.
Thanks,
Isaac
Curtin University