gams-to-excel preferred way to extract results?

GAMS
1

Hello all:

I am a bit lost on the multiple ways to extract results from GAMS
results -
GDXXRW, XLexport, Put files, GDXDump, etc.

I would like to know the efficacy of this procedure: Would you
prescribe this? Do you have any other alternative that could be
simpler and informative?

Create a GDX file in GAMS-IDE (by typing GDX = Results in the upper
right hand corner box).
Then right-clicked to extract ALL results to Excel or HTML.
Is that a good, comprehensive method? Please let me know. What is your
preferred method?

Thanks
Subbu Kumarappan
Michigan State
–~–~---------~–~----~------------~-------~–~----~
To post to this group, send email to gamsworld@googlegroups.com
To unsubscribe from this group, send email to gamsworld+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/gamsworld?hl=en
-~----------~----~----~----~------~----~------~–~—

\

2

Hi Subbu

I usually send my results to the gdx file and then use gams code to send
everything to excel with gdxxrw. I do not like opening the gdx file and then
use a lot of mouse clicks to send it to excel. Using gams solves the export
automatically and very fast.
In the earlier days I used the xlimport/xlexport utilities by Tom
Rutherford, but the export utility is very slow compared to the gdxxrw
utility.
Cheers
Renger

-----Original Message-----
From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On
Behalf Of kmsubbu
Sent: Thursday, June 18, 2009 6:03 PM
To: gamsworld
Subject: gams-to-excel preferred way to extract results?


Hello all:

I am a bit lost on the multiple ways to extract results from GAMS results -
GDXXRW, XLexport, Put files, GDXDump, etc.

I would like to know the efficacy of this procedure: Would you prescribe
this? Do you have any other alternative that could be simpler and
informative?

Create a GDX file in GAMS-IDE (by typing GDX = Results in the upper right
hand corner box).
Then right-clicked to extract ALL results to Excel or HTML.
Is that a good, comprehensive method? Please let me know. What is your
preferred method?

Thanks
Subbu Kumarappan
Michigan State


–~–~---------~–~----~------------~-------~–~----~
To post to this group, send email to gamsworld@googlegroups.com
To unsubscribe from this group, send email to gamsworld+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/gamsworld?hl=en
-~----------~----~----~----~------~----~------~–~—

\