GAMS World Forum

Dear dasa,

Try using "" for example:
g("1","2","a")

Also have a look here for more information on GAMS syntax: https://www.gams.com/latest/docs/UG_MAI ... nvironment

Best,
GFA

p.xlsx Hi dasa, See code below, should be working with attached XLSX. Made some small changes, but most important is that every dimension needs its own column/row in Excel. Regards, GFA set m /1*3/; alias (m,n); parameter g(*,*,*) ; $onecho> p.txt Par=g rng=S1!B4:E7 rdim=2 cdim=1 $offecho $call GDX...

Hi,

You can try (in the case all conditions need to be met): converged = A + B + C (when using "iter$(not converged),")
EDIT: or maybe better: converged$(A + B + C <= 0.01) = 1;

Regards, GFA

Hi, there might be some problems with your GDXXRW statement, if thats the case data is not read correctly from Excel and GDX is not created. You can add a statement to your GDX call which makes a log file which might give some clues: $call gdxxrw.exe demand.xls par=Demand rng=A1:B672 rDim=1 log=log....

Not an expert on this, but once I had this problem too and rescaling helped a lot.
Also have a look here: https://www.ibm.com/support/knowledgece ... kappa.html

Don't think I understand your problem correctly (would be easier if you can post your full GAMS code), but it seems like if you minimize the cost (or costtub(nn)) L(nn) can be 0. If that is the case than costtub is 0 too.
Maybe try to write down your mathematical model first.

GFA

Not sure if I understand your question correctly, but you might find your answer here: https://www.gams.com/latest/docs/T_GDXMERGE.html

location..z=e=sum ( (ir,jr), t(ir,jr)*(k(ir)/c(ir)) ) *d(jr); Your summation ends before the multiplication with d(jr) (and Z does not have an index). Not sure what you want to achieve with your function, but changing to: location..z=e=sum ( (ir,jr), t(ir,jr)*(k(ir)/c(ir))*d(jr) ) ; should solve the...

Hi Luqman,

In your GDXXRW call you also have to specify an output file (GDX):

$CALL GDXXRW.EXE Pakdata.xlsx @Pakdata.txt Pakdata.gdx

Hope this helps.

GFA

Hi, Maybe you can do your parameter declaration first: Parameters FixC(u,k) VarC(u,k) GrsC(u,k) * etc. ; *And then make a text file of all your parameters + ranges + dimensions you want to read in: $onecho > GDXXRW.txt par=FixC rng=S2018!b120:c184 rdim=1 par=VarC rng=S2018!f120:g184 rdim=1 par=GrsC ...