How to store the zero elements in a solution?

Hi guys

After I get the solutions, I use GDX to output the level values of the solution into a excel file. Then, I want to use Matlab to read the excel file and do some other things. However, since the GAMS eliminates a lot of zero elements in the solution, the excel file only contains a part of the solution.

My question is that whether these is some option so that I can output the whole level solution to the excel file.

Thank you.


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/groups/opt_out.

Hi Qiuin



From the gdxutils help file…



Squeeze = flag (default = Y)

or

SQ = flag

Writing to a spreadsheet:

The squeeze option affects the writing of sub-fields of variables and equations. A value for the

field that is the default value for that type of variable or equation will not be written to the

spreadsheet. For example, the default for .L (Level value) is 0.0, and therefore zero will not be

written to the spreadsheet. When we set SQ=N, all values will be written to the spreadsheet.



Cheers



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 Qiumin
Sent: Donnerstag, 22. August 2013 05:53
To: gamsworld@googlegroups.com
Subject: How to store the zero elements in a solution?



Hi guys



After I get the solutions, I use GDX to output the level values of the solution into a excel file. Then, I want to use Matlab to read the excel file and do some other things. However, since the GAMS eliminates a lot of zero elements in the solution, the excel file only contains a part of the solution.



My question is that whether these is some option so that I can output the whole level solution to the excel file.



Thank you.


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/groups/opt_out.


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/groups/opt_out.

Thanks a lot.

On Thursday, August 22, 2013 3:32:01 PM UTC+8, Renger van Nieuwkoop wrote:

Hi Qiuin



From the gdxutils help file…



Squeeze = flag (default = Y)

or

SQ = flag

Writing to a spreadsheet:

The squeeze option affects the writing of sub-fields of variables and equations. A value for the

field that is the default value for that type of variable or equation will not be written to the

spreadsheet. For example, the default for .L (Level value) is 0.0, and therefore zero will not be

written to the spreadsheet. When we set SQ=N, all values will be written to the spreadsheet.



Cheers



Renger


\


Modelworks

Gewerbestrasse 15

3600 Thun – Switzerland

+41 79 818 53 73

In…@modelworks.ch

blog.modelworks.ch







From: gams...@googlegroups.com [mailto:gams...@googlegroups.com] On Behalf Of Qiumin
Sent: Donnerstag, 22. August 2013 05:53
To: gams...@googlegroups.com
Subject: How to store the zero elements in a solution?



Hi guys



After I get the solutions, I use GDX to output the level values of the solution into a excel file. Then, I want to use Matlab to read the excel file and do some other things. However, since the GAMS eliminates a lot of zero elements in the solution, the excel file only contains a part of the solution.



My question is that whether these is some option so that I can output the whole level solution to the excel file.



Thank you.


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/groups/opt_out.


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/groups/opt_out.