Multiobjective Output exports

GAMS
1

Hello,

How can I iterate the txt file name (trial-1, trial-2, … etc.) to get variable values for each weight set (w1, w2) in multi objective opt. model? OR, is it possible to get these in an excel file with different sheets? For example; the results of weight set (5,2) will be exported to the sheet name (5,2) then results of weightset (5,3) will be exported to the sheet named (5,3) but in same excel file?

Thanks,

Code Block:

file results/C:\Users\Desktop\trial\res\trial-1.txt/;
put results;
put system.ifile/;
put system.date/;
put system.time/;
put w1/;
put w2/;
put 'i       j       var 1		var 2'/;
put'****************************************************************************'/;
loop((i,j), 
put i.tl,   j.tl,   put var1.l(i), put var2.l(i)/
);
putclose results;
2

You can use w1 and w2 to compose your file name:

scalar w1,w2;
w1=5; w2=3;
file fx /'trial_w1_w2.txt'/; put_utility fx 'ren' / 'trial_' w1:0:0 '_' w2:0:0 '.txt';
put 'w1=' w1 / 'w2=' w2;

If you run under Windows with Excel installed you can use the gdxxrw tool:

set i /i1*i10/, j /j1*j5/;
parameter rep(i,j); rep(i,j) = uniformInt(1,10);
scalar w1 /5/, w2 /2/;
file fgdxxrw / 'gdxxrw.in' /;
putclose fgdxxrw 'i=rep.gdx o=trials.xlsx par=rep rng=' w1:0:0 '_' w2:0:0 '!A1';
execute_unload 'rep.gdx', rep;
execute 'gdxxrw @gdxxrw.in';

-Michael