I would like to create a project with AIMMS about transport problems. All my figures are in an excel table. How can I rearrange my table for use in AIMMS?
I have successfully added the AIMMS tool to my Excel spreadsheet.
Thank you in advance.
Best answer by Jess Es
You may want to look at using the AIMMS Excel Library (axll) functions https://how-to.aimms.com/Articles/85/85-using-axll-library.html (also https://how-to.aimms.com/Articles/197/197-reading-data-from-excel.html )
This should give you enough flexibility to read in the parts that you want to use without much rearranging.
I should note that I’m a docs specialist, not support specialist - but this should help you get started anyway :)