Optimization Tooling

In our app we use excel upload and downloads such that users are able to change and distribute data more easily. So we have written procedures that write and read excel files for the data in the app. With the new widget actions, it seems most logical to also place these download and upload actions there. But there is still an option to download the data as a .csv file. As not to confuse any users which download they should use, I would like to disable the option of downloading as a .csv file for certain tables. Is there a way to disable this feature?

The AimmsXLLibrary was introduced in AIMMS 4.20. You can deploy your AIMMS project to more platforms with less restrictions, because this library can communicate with Excel files in server environments where Excel is not installed. For instance, while running AIMMS through a WebUI on PRO or on Linux. The AimmsXLLibrary doesn’t require Excel to be installed in order to read from or write to an Excel (.xls/.xlsx) file. You first need to add the system library `AIMMSXLLibrary` to your model, and then you can use the predefined `axll::` functions. Read more...

Hello! While my mps are running on the server, I made a "progress window" (log), to know the state of the solving process. 🕘 In this log, because three mps are running in for cycle, and there are many rows, the latest one always apear at the end of the list. I would like to change the order, and show the latest log at the top of my table. If you have any idea, how to do that please let me know. I tried a several thing, and did't get the result. 😥 Thanks!

I have following unit consistency warning for the expression below: {i| sum((p,yr),TLin(i,p,yr)) <> 0} Warning: The units associated with the expression (sum( ( p, yr ) , TLin(i,p,yr) ) )[m3], and with the expression (0)[] are not commensurate. Is there a trick to get around this? I know I can define a parameter with a value 0 and unit m3, but do not want add modelling complexity for such a minor issue. Any suggestions are welcome. With kind regards, Binod

Hello! I have 5 MPs, three of them running in for cycle, so somehow I want to track which MP is solved in a particular time. 🕖 I imagined that, I make five label, with the name of the MPs, and for those string parameter I make annotation, which defines the mp's status (running, finished). Can I make annotation for non indexed parameters? The css code I use is the following (maybe that here misses something 🤔, without the annotation it's working 😅) .tag-widget[data-widget\.uri="OptimizationLog_lbl_SMG1"] .annotation-Active{ border-radius: 5px; background: rgb(17, 255, 125); border-style: solid; border-width: 5px; border-color: rgb(17, 255, 125); color: #fff; } Thanks for your help!

Hello Aimms Community, I have to do a calculation with Parameter K_T(s,i,ii,t) in R and get the calculation results back to Aimms for the Optimization. I want to have the root of the matrix. i and ii are Indices for the same SetIdentifier Sn. code:dl::DataTables+={'MyDataFrame'};empty DataMap;DataMap(dl::dt,dl::idn,dl::cn,dl::dn) += data { !( table_name , identifier , col , dom ) : name_in_dataframe ( MyDataFrame , Sn , 2 , 1 ) : "i", ( MyDataFrame , Sn , 3 , 2 ) : "ii", ( MyDataFrame , P , 4 , 3 ) : "t", ( MyDataFrame , OL , 5 , 4 ) : "s" , ( MyDataFrame , K_T , 1 , 0 ) : "K" } ;MapName:="MyMapName";dl::RemoveDataSourceMapping(MapName);dl::AddDataSourceMapping( MapName, DataMap, dl::DependEmpty,dl::TableAttributesEmpty,dl::ColAttributeEmpty);dl::ExecScript("source('test_rlink.r')",MapName,XA); the R-Code in test_rlink.r code:# get data from AIMMSdfin <- aimms::GetData("MyDataFrame")# do the calculationdec0 <- eigen(dfin$K)ev0 <- dec0$vectorsew0 <-

I'm not able to start any PRO session anymore, keep getting this error "Cannot verify project validity" and it says to check logs. The error message in the server log is: java.io.IOException: C:\Program Files\AimmsPRO 2.0\AimmsPROLibrary\vc141\x64 doesn't exist. What could be wrong?

Hi all, i still need to implement a Minimax-Regret Function into Aimms. The Goal--Function is based on a deviation calculation by using the goal-programming approach. Therefore i added all the necessary constraints and variables. My main model looks like that: MathProgramm: Minimax_Regret Decision Variable Regret: max(k,sum(j,abs_Regret(j,k))) (k=scenarios and j= potential locations) MainExecution: myGmp := GMP::Instance::Generate(Minimax_Regret); GMPOuterApprox::CreateStatusFile :=1; GMPOuterApprox::UseMultistart :=1; GMPOuterApprox::DoOuterApproximation (myGmp); But my model still genereates the following error: GMP::Instance::CreateMasterMIP(): The objective column should be in the coefficient matrix exactly once. Does someone know how to fix this? Thank you very much! Alex

Hi Community, i have to build a robust optimization model for my masterthesis at the Technical University in Braunschweig. Therefore i choose the Minimax-Regret Function! These approach deals with different scenarios k. I need to implement this function in an existing basic model, which is a single factory location problem. The basic model calculates the minimal sum of all deviations "d" from target values (so it is a Goal Programming approach) and based on these deviations the output of the model is one compromise-optimal location solution (the basic model is based on one scenario). So first i implement a new index k for the scenarios to dealwith more than one scenario. How to deal with a minimax-obejctive function in AIMMS is already explained very well in one of the AIMMS Modeling Guides (https://download.aimms.com/aimms/download/manuals/AIMMS3OM_LinearProgrammingTricks.pdf). But i have some issues with the Regret. The definition of the regret is R = d - d*. Therefore, d is the de

Hello, At the moment I am performing a scheduling problem with time windows. The model is very similar to the second model which can be downloaded from the AIMMS website (see link) execpt from a number of elements: I try to minimize the sum of all the changeovers that are used. Base unit is in minutes. In total I have 3 datasets (one for each machine) that AIMMS can read in from an Excelfile, one at a time. Initially, my model is able to solve using CPOptimizer 12.8 for all machines, where each job has to be scheduled after the "StartTime" and finish before an "Endtime". After this solution I would like to decrease the StartTime by one week when a job meets a certain criteria and then solve it again. When I run the procedure that decreases the Startime by one week and try to solve it again it finds a solution for only one of the machines and for the other two AIMMS hasnt been able to find a solution yet after more than 9 hours. For the machine that could find a so

Is it possible to disconnect automatically users in AIMMS PRO after being inactive after some minutes?

Dear, In the attached model, you should only run the procedure ReadFromExcel. This should load all the relevant sets and parameters. When I try to solve this model, I encounter different memory errors. I either see: Memory allocation error Memory allocation error: while assigning "xxx" bytes Are there any steps that I could take with regards to the index domain of some parameters, constraints or variables, such that this model becomes solvable? I think there are no other errors in my model, but would also like to double check this. Kind regards, Koen

Dear all, I have a few questions about my model, which I hope the AIMMS community can answer. Please bear with me, as I should be drawing to the conclusion of my thesis (when this model works). Sum and indices In the accompanied model, I am trying to add several constraints. However, when setting these constraints I often encounter errors like "the index (p) does not denote a subset of the domain of set "FactoryLines"" for instance. I often find that I make mistakes with the indices in the constraint itself and within the constraint definition. I have tried looking at the guides online, but with no effect. Could anyone explain to me (preferably in layman's terms) how the indices in constraints work as well as indices within a sum argument? I am encountering similar problems with the parameters "IncomingStock" and "OutgoingStock" Stock balancing One of the decision variables, StockAtWarehouse is made from the following definition: StockAtWarehouse(p,w,t-1) + sum(p, IncomingStock

When reading a table from an excel (and putting in wrong data) I get a pop-up in the UI stating what index it can't recognize and is therefore wrong, so something like this: "ReadTable : Cell A2 in 'Excelfile': 'Wrong element' is not an existing element in the set 'Technical name of set'" And I would like to use this information to make a specific pop-up for the end-user, so I can specify how to solve this error and also change the name of 'Technical name of set' to a name that they would recognize. So the exact element and index that are wrong, is stored somewhere, I would like to make use of this, but I can't find where to get this information.

Dear community, When I try to solve the attached model, I get the following errors: Warning: The columns "TransportToCustomer(Warehouse1,Customer5,038.001,1)" and "TransportToCustomer(Warehouse1,Customer399,038.001,1)" are equal in the generated mathematical program "LeastCostPlan". This may lead to non-unique solutions. For more information regarding potential causes and consequences, see the help associated with the option "Warning_duplicate_column". Warning: Only 3 out of 11565909 duplicate column warnings were reported. See also option limit_reported_duplicate_column_row_warnings. Warning: After zero iterations CPLEX 12.7.1 concluded that an integer solution to LeastCostPlan does not exist. Firstly, I don't really what this error means. In the example above, the shipping of product 038.001 to Customer5 on Period 1 and the shipping of product 038.001 to customer 399 on Period 1 do not have anything to do with each other, other than that they originate from the same warehouse an

Hello. Is anyone out there working with OPC UA or other OPC protocols with AIMMS applications? If so I'd like to talk with you. Scott Bury

Is it possible to select not only one but more tasks on the WEBUI Gantt-chart? I couldn't find any description about that. Does somebody have any infos about that? Thanks, Zsófi

Dear staff, I need your help with an objective function where I have the product of two variables. I have the following variables and parameters: y(i,j,c,a) binary variable x(a) continuous variable P(c) parameter How can I linearise the following objective function: MIN: sum((i,j,c,a), P(c) * y(i,j,c,a) - P(c) * y(i,j,c,a) * x(a)) Thank you

Hi, The CSV Export DLL does seem to export 0-dim identifiers. Therefore I would like to use put. However I can't figure out how to obtain the value of that 0-dim variable. I have the next snippet of code, which works fine, but the value of the variable is still missing. code:for (IndexVariables) do if (IdentifierDimension(IndexVariables)) then !do something else else csv_alt_name := FolderName + IndexVariables + ".csv"; put csv_alt; put IndexVariables + "\n"; put name_of_some_variable; putclose; endif;endfor; The line "put name_of_some_variable;" prints the value of a variable. But it should of course print the value referred to by IndexVariables. How to do that?

The WinUI has a super obvious tab for the Legend of a linechart. But there seems to be NO way whatsoever to display the legend (or anything that will work as a legend) on a WebUI linechart. I even tried the (seemingly obvious) solution of using a legend widget. If this will work, I can't figure out how. Is there a way to show the legend? And if you don't have on yet, is there a workaround and do you have it in the plans in the future?

I do love the itty-bitty AIMMS A logo as the favicon, but being able to make that the client's favicon is a small but very nice thing. I can change it locally, but is there a way to change it so that it won't just happen on my own computer? And if not, can you put it on the list of things to add? Thanks!

This week I got the following request "Add functionality to 'watch' identifiers and view the data of all those watched items within a window panel". I did some probing with the requester to better understand the need for this and I learned it would help the developer to debug faster than using various data pages, or see values inline via the debugger. My thinking at this point is: - One would like to be able to watch the identifiers in the Developer IDE (something like you do in R Studio - see picture below) - One would be able to dive in details of the data via a DataPage option (only first items are shown; like x below in R Studio example) - One would select identifiers to watch from the model tree (or model) and not necessarily ALL identifiers that are touched (could be an extreme long list)? Wonder about your thoughts

Dear Staff, I need help writing the following constraint using the AIMMS language. I have two indexes: c a Where "a" indicates years. I have a variable y(c,a) I would like to define a summation over "c" and over "a" as less than or equal to a value. But the summation over "a" should be done only from the first year until the current year. I am trying this formulation but something is wrong with it: sum((c, a1|(a1="A01") and (a1=ord(a))), y(c,a1)) <= Value Can you please help me writing this correctly using the AIMMS syntax? Thank you,

I tried to set my Gantt-chart to readonly, such that users would not be able to move any tasks on the Gantt-chart. Unfortunately I cannot find neither this option in WebUI nor in any AIMMS Manual. Could you help me to set it up? Thanks !

Hi, is there a similar code that I can use if a project has set the option Data Management style to Disk files and folders? The below code was valid for projects using option Single Data Manager file. The code was available from https://techblog.aimms.com/2012/06/05/save-a-case-from-aimms-procedure/ (note this is blog is now not available) ************ !First try to find a case with the name indicated by CaseName. If AIMMS !can find this, it will store a reference to this case in the element !parameter CaseReference if ( not CaseFind( CaseName, CaseReference ) ) then !If no case with the name indicated by CaseName could be found, then !we try to create a case with this name. After creating the case, AIMMS !will store a reference in the CaseReference element parameter to the !newly created case if ( not CaseCreate( CaseName, CaseReference ) ) then !If there was an error while creating the case, notify the developer !by raising an error. If the raised error is not cau