GAMS World Forum

Since you run gdxxrw at compile time ($call) using a calculated scalar makes little sense (because the calculation happens at run time, so after the compile phase). You could store the 92 in a compile time variable: $set art_lastrow 92 $call gdxxrw.exe Test.xlsx set=art rng=CO!A7:A%art_lastrow% You...

Hello everyone, does anyone know if there is the possibility to index the value of a range when importing from excel with GDXXRW? For example: $call gdxxrw.exe Test.xlsx set=art rng=CO!A7:A92 I would like to store that "92" in a variable, so that i could just modify an initial (ie) scalar ...

Hi In your excel sheet, your data is organized as follows: P1 P2 P3 TIMES [H] QTY DOMINIO 0 1 0 1.983333333 210 pp1 0 1 0 1.983333333 182 pp2 1 0 0 1.983333333 628 pp3 1 0 0 1.983333333 838 pp4 Gams expects the indices in the first columns and/or rows, so you have to move DOMINIO to the first colum...

Hello everyone, I am a very beginner of GAMS. I have just completed my first model in gams, but I was not able to test it on the real dataset because I was not able to import data. So this is the code I'm working with: Set pp "New production" / pp1, pp2, pp3, pp4, pp5, pp6, pp7, pp8, pp9, ...

Hello Leonardo, if the solver reports "integer infeasible" then there is no feasible solution for the data you have provided. However, the model being infeasible does not mean the problem you want to solve is infeasible. You might have just modelled the reality too restrictive. One way to...

Hi all, my name is Leonardo from Italy. I'm a gams beginner. Reading the online doucmentation I have came up with this model I would like to employ to optimize the production planning process of my company. I'm attaching here a sample of the model ( data has been taken randomly ): Sets art "Con...