Subsets from Excel

Question

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 asSpreadsheet::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");

deannezhang · Accepted Answer

Welcome to AIMMScommunity!In your case, I suggestin excel, add a column (for example column B)to your spreadsheet to indicate whether the element in column A belongs to the subset - 1 is yes, 0 or empty is no.in AIMMS, add a parameter (for example isSubFacility(f) ) to take the value of column Bin AIMMS, add a set (for example subFacility, with index sf), make it a subset of Facility, and add definiton: {f|isSubFacility(f)=1}then reading in column A to Facility and column B to isSubFacilityandindex sf can be used where the subset is needed.

Subsets from Excel

1 reply

Reply

Reply

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded