Hello everyone,
I am trying to send the run results to excel. I am able to do that for individual variables, but for different parameters, I don’t know how I can write it.
Here is my code for variables. I can get the output excel file for variables and I want to get the result for parameter (given below) in excel output file.
parameter
operationcost1;
Thank you very much.
MODEL REVLOG /ALL/;
solve REVLOG using MIP minimize z;
Execute_Unload “results.gdx”,u;
Execute ‘GDXXRW.EXE results.gdx Output=results.xls var=u.l rng=sheet1!a1’
execute ‘gdxxrw.exe results.gdx o=output.xls @outtask0.txt trace=3’;
display z.l;
display u.l;
parameter
operationcost1;
operationcost1=sum((t2,i2),OMNN1(i2,“OMNN”)*U.l(i2,t2));
display operationcost1;
–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at https://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.
Hi Deniz
This is very well described in the GDX-help (see example 6 for reading several parameters from an excel file). If you need more help, just let us know.
Cheers
Renger
From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of deniz
Sent: Freitag, 8. Januar 2016 02:07
To: gamsworld
Subject: gams results output file to excel file- writing for parameters
Hello everyone,
I am trying to send the run results to excel. I am able to do that for individual variables, but for different parameters, I don’t know how I can write it.
Here is my code for variables. I can get the output excel file for variables and I want to get the result for parameter (given below) in excel output file.
parameter
operationcost1;
Thank you very much.
MODEL REVLOG /ALL/;
solve REVLOG using MIP minimize z;
Execute_Unload “results.gdx”,u;
Execute ‘GDXXRW.EXE results.gdx Output=results.xls var=u.l rng=sheet1!a1’
execute ‘gdxxrw.exe results.gdx o=output.xls @outtask0.txt trace=3’;
display z.l;
display u.l;
parameter
operationcost1;
operationcost1=sum((t2,i2),OMNN1(i2,“OMNN”)*U.l(i2,t2));
display operationcost1;
–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at https://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.
–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at https://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.
Thank you so much for the guidance!
I will certainly read the manual and hopefully I will solve the problem.
Regards.
On Friday, January 8, 2016 at 1:21:21 AM UTC-6, deniz wrote:
Hello everyone,
I am trying to send the run results to excel. I am able to do that for individual variables, but for different parameters, I don’t know how I can write it.
Here is my code for variables. I can get the output excel file for variables and I want to get the result for parameter (given below) in excel output file.
parameter
operationcost1;
Thank you very much.
MODEL REVLOG /ALL/;
solve REVLOG using MIP minimize z;
Execute_Unload “results.gdx”,u;
Execute ‘GDXXRW.EXE results.gdx Output=results.xls var=u.l rng=sheet1!a1’
execute ‘gdxxrw.exe results.gdx o=output.xls @outtask0.txt trace=3’;
display z.l;
display u.l;
parameter
operationcost1;
operationcost1=sum((t2,i2),OMNN1(i2,“OMNN”)*U.l(i2,t2));
display operationcost1;
–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at https://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.