The error says: ExcelRetrieveParameter(FINAL DATA.xlsx, N(E), B16:DQ16, , 0) failed: Actual cardinality (0) of domain #1 is smaller than specified cardinality (120).
what should I do?
Best answer by mateusarakawa
I think your set, which has "E" as index, is empty.
Therefore, AIMMS can't link the excel table index to your set elements.
If you want to automatically populate your set, I would try Spreadsheet::RetrieveTable with argument "AutomaticallyExtendSets" : 1.