GAMS World Forum

No, GAMS does not allow duplicate records. If you post the spreadsheet and what you want to read into GAMS then we might be able to help better.

-Michael

Hi, Study the documentation of gdxxrw and how to use a gdxxrw option/parameteri file. You seem to have destroyed your xlsx workbook with your command sequence. What you probably want to do is: $onecho> Data-x-y-z.txt input = Data-x-y-z.xlsx set=t rng=Tabelle5!E2:E201 cdim=0 rdim=1 par=x rng=Tabelle5...

Sure, the model attribute "modStat" (https://www.gams.com/latest/docs/UG_GamsCall.html#GAMSAOmodelstat) gives you programmatic access to the model status. You can save the model status in a parameter: "mstat(day) = mymodel.modstat;" and save this to GDX. Be aware that there are m...

I suggest that you run recent versions of the software. Cplex still solves the root LP and stops after a little more than an hour. If your "super computer" uses some kind of batch submission system I guess the system has imposed some resource limits (time and/or memory) and kills the job a...

The typical solution for this in GAMS is to write you the model equations with a dynamic subset of the domain sets: set i /AF,A,B,C/, ii(i) set j /A,B,C,EF/m jj(j); Variable F(i,j) OF .. FT =e= sum((ii,jj),F(ii,jj)); model m /OF/; loop((i,j), option clear=ii, clear=jj; ii(i) = yes; jj(j) = yes; solv...

Hi, please follow thew forum rules. Don't just paste program in your text. At least use a code section or better attach the file. All the table formatting is broken if you just paste in the text! The error is pretty clear 254 Pw.up(bus,t)=DataWDL(t,'w')*Wcap(bus)/Sbase; **** $141 **** 141 Symbol dec...

If this is your UF1 image.png then obviously with x1 in [0,1] and xj in [-1,1] there is no chance in getting a negative value for f1 or f2. If you have negative values you probably made a mistake. Did you check the model status (for feasible solution)? It would help if you post some source. -Michael

The GAMS/IPOPT link has to map any of the IPOPT internal status (e.g. Solved To Acceptable Level ) to a combination given in the list of GAMS' model and solve status, GAMS support many solvers so all solvers need to map into the GAMS status world. Now see how the GAMS/IPOPT link maps Solved To Accep...

You should find out why IPOPT can't evaluate the input point. Some solvers don't like gradients that are too large. Usually GAMS already complains if you have a truly bad input point that can't be evaluated (at least for the function evaluation and to some extent for the gradient). IPOPT works also ...

The GAMS/IPOPT link maps this status to some combination of model and solve status, see https://www.gams.com/38/docs/UG_GamsCall.html#GAMSAOmodelstat and https://www.gams.com/38/docs/UG_GamsCall.html#GAMSAOsolvestat. You should check if this combination is any different than with the other solves an...