Hello AIMMS community!
I currently working with aimms on my thesis and for my model i need the MainExecution read a huge amount of sets and parameters. For that I’m using Excel-Sheets. I also going to need subsets and here is my, i think, for you, very simple question:
How can I exclude Excel cells from being readed? For example one of my sets is readed as
Spreadsheet::RetrieveSet ( WorkbookName, facilities, "A4:A75");
If now a subset of facilities is not contigious in this column A4:A75 but instead maybe the cells A10 to A15 and A20 to A30 and A50. How would i retrieve this subset? I tried this (see below) and many other variants and nothing worked. Hope you can help me.
Spreadsheet::RetrieveSet ( WorkbookName, facilities, "A10:A15+A20:A30+A50");
Best answer by deannezhangView original
Welcome to AIMMS community!
In your case, I suggest
and index sf can be used where the subset is needed.