Obtaining very large data sets from GAMS. Any applications other excel

Hello board,

I have a gams implementation that works fine for single scenarios. Only problem is that when I try to batch run the file, excel can handle the large amount of data for all the runs (not even when I break up in 1/100). I am sure a lot of people have experienced this before, can you recommend a different application with better memory management XML or XQL??

Thanks


To view this discussion on the web visit https://groups.google.com/d/msg/gamsworld/-/gMWarMNmVfcJ.
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.

Hi ?

Are you using a version of excel before version 2007? Excel 2007/2010 can have 2^20 (1,048,576) rows and 2^14 (16,384) columns. I can’t imagine that you have more data…

I never had any problems with transferring lots of data to Excel, so what is exactly the problem?

Renger


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 Leye
Sent: Montag, 14. Januar 2013 06:59
To: gamsworld@googlegroups.com
Subject: Obtaining very large data sets from GAMS. Any applications other excel



Hello board,



I have a gams implementation that works fine for single scenarios. Only problem is that when I try to batch run the file, excel can handle the large amount of data for all the runs (not even when I break up in 1/100). I am sure a lot of people have experienced this before, can you recommend a different application with better memory management XML or XQL??



Thanks


\

To view this discussion on the web visit https://groups.google.com/d/msg/gamsworld/-/gMWarMNmVfcJ.
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.


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.