combine 4 different results in one single (excel) file

GAMS
1

Hi All,
Here I have 4 results diplayed in 4 excel file.
I need them to be dispalyed in one single excel, either in 4 different sheets or in one single sheet, it doesnt matter.
Thanks

Amanda

code I am running

display profit.L ;

display production.L ;

display pumping.L ;

display level.L ;

execute_unload “profit.gdx” profit;
execute ‘gdxxrw.exe profit.gdx var=profit’;

execute_unload “production.gdx” production;
execute ‘gdxxrw.exe production.gdx Squeeze=N var=production Rdim=1’;

execute_unload “pumping.gdx” pumping;
execute ‘gdxxrw.exe pumping.gdx Squeeze=N var=pumping Rdim=1’;

execute_unload “level.gdx” level;
execute ‘gdxxrw.exe level.gdx Squeeze=N var=level Rdim=1’;

my gues to put everything in one file “resutls” (but it does’t work…)

execute_unload “results.gdx” profit, production, pumping;
execute ‘gdxxrw.exe results.gdx var=profit Squeeze=N var=production var=pumping Rdim=1’;


\

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 http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.

2

Hi Amanda

You should add the range in the excel sheet for every parameter (see page 22 of the gdxutils documentation).

Cheers

Renger

Dr. Renger van Nieuwkoop

Modelworks

Gewerbestrasse 15

3600 Thun – Switzerland

+41 79 818 53 73

Info@modelworks.ch

blog.modelworks.ch







From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of Amanda S
Sent: Monday, January 5, 2015 17:35
To: gamsworld@googlegroups.com
Subject: combine 4 different results in one single (excel) file



Hi All,
Here I have 4 results diplayed in 4 excel file.
I need them to be dispalyed in one single excel, either in 4 different sheets or in one single sheet, it doesnt matter.
Thanks

Amanda

code I am running

display profit.L ;

display production.L ;

display pumping.L ;

display level.L ;

execute_unload “profit.gdx” profit;
execute ‘gdxxrw.exe profit.gdx var=profit’;

execute_unload “production.gdx” production;
execute ‘gdxxrw.exe production.gdx Squeeze=N var=production Rdim=1’;

execute_unload “pumping.gdx” pumping;
execute ‘gdxxrw.exe pumping.gdx Squeeze=N var=pumping Rdim=1’;

execute_unload “level.gdx” level;
execute ‘gdxxrw.exe level.gdx Squeeze=N var=level Rdim=1’;

my gues to put everything in one file “resutls” (but it does’t work…)

execute_unload “results.gdx” profit, production, pumping;
execute ‘gdxxrw.exe results.gdx var=profit Squeeze=N var=production var=pumping Rdim=1’;

\

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 http://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 http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.

3

Dear Frank,

thanks a lot!
Here is the code and the spread sheet (results_CNORD). Results should go to the sheet “results”, on cell A1:A8760 and B1:B8760.

Amanda

From: fward@nmsu.edu
To: gamsworld@googlegroups.com
Subject: combine 4 different results in one single (excel) file
Date: Tue, 6 Jan 2015 15:51:50 +0000

Dear Amanda,



Please send me your GAMS code and spreadsheet, and I will try to help.



Frank



Frank A. Ward

Distinguished Achievement Professor

New Mexico State University

Las Cruces, NM USA

fward@nmsu.edu

http://agecon.nmsu.edu/fward/water/







From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of Amanda S
Sent: Monday, January 05, 2015 9:35 AM
To: gamsworld@googlegroups.com
Subject: combine 4 different results in one single (excel) file



Hi All,
Here I have 4 results diplayed in 4 excel file.
I need them to be dispalyed in one single excel, either in 4 different sheets or in one single sheet, it doesnt matter.
Thanks

Amanda

code I am running

display profit.L ;

display production.L ;

display pumping.L ;

display level.L ;

execute_unload “profit.gdx” profit;
execute ‘gdxxrw.exe profit.gdx var=profit’;

execute_unload “production.gdx” production;
execute ‘gdxxrw.exe production.gdx Squeeze=N var=production Rdim=1’;

execute_unload “pumping.gdx” pumping;
execute ‘gdxxrw.exe pumping.gdx Squeeze=N var=pumping Rdim=1’;

execute_unload “level.gdx” level;
execute ‘gdxxrw.exe level.gdx Squeeze=N var=level Rdim=1’;

my gues to put everything in one file “resutls” (but it does’t work…)

execute_unload “results.gdx” profit, production, pumping;
execute ‘gdxxrw.exe results.gdx var=profit Squeeze=N var=production var=pumping Rdim=1’;

\

CNORD - Copy.7z (1.31 MB)