Optimization Tooling

Hi AIMMS Community,Does anyone know if (and how) you can give a complete row in a webUI table a color, instead of just the data fields?For example, I want to go from:Data field colored with annotationTo:Desired coloringThank you!

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

Hi there, I’m an AIMMS newbee - needing it for a uni-project. I’m having a lot of trouble connecting my Excel file to the AIMMS Project. When I try to run my procedures to read the data I’m getting an error: permission denied. Tried to insert the procedures in the Interface Setup in my Excel Add-In but am still not getting it right  Any common fixes there for regular newbee-mistakes?   

Erros in proyect when migrate AIMMS 4.0 to 4.7.When reading a proccedure that before worked now appeared some errors: The element 71 not found for domain set ….is not an element of the domain set...

Hello,    I have a set of 30 Customers, {1,2,...30}. I want to create subsets of these customers. Specifically, I want to get subsets with cardinality 1,2 and 3. These sets combined should then form the set ‘Routes’, such that the set ‘Routes’  looks as follows: {1}, {2}, … , {30}, {1,2}, {1,3},… { 29,30}, {1,2,3} , {1,2,4} ….. So the idea is to obtain routes containing 1,2 or 3 customers.   I would really appreciate some hints about implementing this in AIMMS.  Thank you in advance.   

 Doğrusal programa ile ilgili bu 2 soruyu AIMMS programında rica etsem çözermisiniz. Çözümümden emin olmak istiyorum.

Hi, I’ve been developing some stuffs using webUI. But, somehow, some part of it (what I did earlier) is still there when I refresh the Chrome while the other part of it is gone whenever I refresh or go to the previous page. How to save the pages and interfaces that we have made in webUI ya? I’m using the latest version of AIMMS (AIMMS 4.84.6.2 64-bit).Thanks,Zulfan 

How should I set a default layout for pivot tables in developer mode. I want this layout to be used when the application is opened by users in WebUI. Thanks 

Hi,Many of our projects include export functionality to Excel; which is a good way to allow the end-user to continue to work on the data and/or use it as a report out. Proper formatting of the excel file is in these cases high on the priority list of the users. One can think of: setting fonts, right number of decimals, putting data in a pivot (correctly organized). Basically, saving the user the manual work to redo these formatting actions after each export to excel.In the win-ui we applied the following trick to get the excel file formatted as desired:Create an excel macro to perform all the required actions Include an excel file with the macro in the aimms project When exporting, use a copy of that excel file, put the data in and run the macro via the aimms function Spreadsheet::RunMacroSince we are developing web-ui apps, which are cloud deployed, this trick is not available any more. The model runs in the cloud without the ability to running an excel macro. Because the AIMMS Excel

In this How-To article we explain how to implement the usage of the data formats (JSON, XML, CSV, Excel, Parquet) in mapping files and, if applicable, format-specific requirements. This article is part of a How-To series on the DEX. Let us know if you have any questions about using the DEX and/or suggestions for follow-up articles! Go to article: Dealing with different data types in the DEXNew to DEX? Start here! 

Hi AIMMS community,I am having problems to activate my academic license. This error reported by AIMMS:Logging on to AIMMS License Server failed: No logon response from serverAny ideas on how to solve it? 

 Dear Community,   As mentioned in earlier product update, with 4.85.1 version release the new Combination Chart Widget type now comes with significant feature enhancements. Though in its initial version, the Combination Chart Widget type supported only data representation with Columns. The recent enhancements include:Support for multiple chart types, namely Column, Line, Area, Area Spline. Spline and Scatter. Support for Secondary Y-Axis Support to control X-Axis intervals\StepSize Support to hide an index from UI. Better coloring options by using the color index and the transparency index. Curious to know if you got a chance to try out this new widget type.   Are you happy to use this feature in its current state? If not, why? Do you see something you would like to improve? Please leave your feedback and suggestions in the comments. Thanks,WebUI Team

Dear All,I want to model a conditional constraint of:where QUR, QP, QT, and Gpv are variables, and load and Qmin are parameters. t is time index.How to implement this function in AIMMS?Thank You.

Hi, I’ve been trying to run some Monte Carlo simulations, but apparently if the number of runs is more than 500, the Histogram cannot be made. AIMMS returns some arithmetic error that I don’t understand. How can we increase the number of data that Histogram can make?Thanks,Zulfan

Hi, I was trying to play around with Monte Carlo simulation in AIMMS. I can save the results from MP.Objective for every run. But, how can I save the solution for every run? I tried to use something like below for every run:Variable_Result(run, param1, param2) := Variable(param1,param2);It’s in the procedure “RunMonteCarlo” in the attached file. But, it doesn’t work. Any idea?Thanks,Zulfan

Our AIMMS Community License has completed it's first year! 🎉🎊🎈And we are very happy in the reception that this free edition got by our users.Looking back at the original post, I love the proposed intentions for this release. To quote @Gloria Quintanilla :Whether it’s crafting a plan to reduce your personal carbon footprint, creating a schedule for your kids’ school or simply to learn and experiment, AIMMS Community Edition is ideal for those who want to apply modeling to improve decision making. It’s also a great companion for recent graduates who previously used an AIMMS Academic License but want to continue playing with the software at no cost, or showcase their AIMMS skills to prospective employers.   So, what did the community edition do for you? Please share with us!And if you still don't have a license, jump right on:https://licensing.cloud.aimms.com/license/community.htm?utm_source=website&utm_medium=footer

Would be great to have the ability to export the Math Program Inspector results to a file to do further analysis (i.e. using Python)

Hello! I want to present production lines in my gantt chart. Production is separated to different levels: Is it possible the show theese levels in the same line bellow each other? Or I need to create another line for each? Thanks for the help!

Hello,  I want to save the results of various variables into an Excel Workbook. All the results I want to save are on the “Multiple Iteration Dashboard ” Page I created. I read about the function PageCopyTableToExcel  that would allow me to save those results (https://documentation.aimms.com/functionreference/user-interface-related-functions/page-functions/pagecopytabletoexcel.html#pagecopytabletoexcel). You can find my projects attached to this question. To do so, I created a Procedure named “ExportExcel” where you can find the following code :  if not axll::WorkBookIsOpen(WorkbookFilename : "Book1.xlsx" ) then          axll::OpenWorkBook(WorkbookFilename : "Book1.xlsx" );endif; PageCopyTableToExcel(pageName: "Multiple Iteration Dashboard",        tag: "FuelEfficiency",        includeHeaders: 1,        selectionOnly: 0,        ExcelWorkbook: "Book1.xlsx",        Range: "A1:Z150"); I went into the Fuel Efficiency Table Properties to correctly tag it as “FuelEfficiency”.However, I got t

Hello everyone,in contrast to other programming languages, the source code of an AIMMS model usually is in a single file. Our code is hosted at a GitLab instance. Our team notices, that GitLab struggles with the large .ams-file, especially in merge requests. Sometimes the diff is too large to be shown, posting comments (as a reviewer as part of a code review) fails, or loading already posted comments fails. The size of our .ams-file is usually between 1 MB and 5 MB.Has anyone else experienced similar issues? Does anyone know a good alternative to conduct code reviews, which does not involve hosting the code on a different platform?I’m aware that we could use libraries to divide the code in smaller chunks, however, I feel like this is not as easy as in other programming languages and not the way it’s “supposed to be” in AIMMS.Best regardsBenedikt

Hey Guys,I have a small problem by modeling my MILP.I created a Matrix do define some Binary Variables. Now I want to create a constraint, which contains a multiplication between the Matrix of the Variables an a Matrix with some parameters. The result should be a scalar value comparable to the sumproduct-function in Excel. I want to do a multiplication between the matrices an the result should be a scalar?Hopefully there is a simple function in Aimms to solve my problem.I am thankful for every help!Best regardsSimon