Hi All,
I am relatively new to GAMS.
I have 2 issues to solve with my results.
- Results are displayed in an Excel file orizontally
h1 h2 h3
3 64 98
while I need them to be dispalyed vertically
h1 3
h2 64
h3 98
- from those results I need the second coloumn (3, 64, 98, …) to be displayed in an exisitng Excel file called “results_CNORD_2013.gdx” (in a specific sheet called “produciton” and specific coulumn E2:E8761)
here is the code I use for the results.
display production.L ;
execute_unload “results_CNORD_2013.gdx”, production;
execute ‘gdxxrw results_CNORD_2013.xlsx Squeeze=N, var=produciton Rng=“Prod”!e2:e8761 Rdim=1’;
Can anybody help?
THanks
Amanda,
\
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.
Hi Amanda
Replace Rdim by Cdim
I would put them somewhere else and then link the values in Excel to the cells E2:E8761
Cheers
Renger
From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of amanda2007
Sent: Sunday, January 4, 2015 10:52
To: gamsworld@googlegroups.com
Subject: dispay results in a pre-existing excel file
Hi All,
I am relatively new to GAMS.
I have 2 issues to solve with my results.
\
- Results are displayed in an Excel file orizontally
h1 h2 h3
3 64 98
while I need them to be dispalyed vertically
h1 3
h2 64
h3 98
2. from those results I need the second coloumn (3, 64, 98, …) to be displayed in an exisitng Excel file called “results_CNORD_2013.gdx” (in a specific sheet called “produciton” and specific coulumn E2:E8761)
here is the code I use for the results.
display production.L ;
execute_unload “results_CNORD_2013.gdx”, production;
execute ‘gdxxrw results_CNORD_2013.xlsx Squeeze=N, var=produciton Rng=“Prod”!e2:e8761 Rdim=1’;
Can anybody help?
THanks
Amanda,
\
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.