how to put zero values in gdx and excel output?

Archive of Gamsworld Google Group
Post Reply
Archiver
User
User
Posts: 7876
Joined: 7 years ago

how to put zero values in gdx and excel output?

Post by Archiver »


Hi,
I am looking for a way to show zero values in the gdx and excel output. I have tried the following but it is frustrating and I need to repeat it each time,

acronym zero;
x.l(t) $ (x.l(t) eq 0) = zero;

This works fine but as I said it is not convenient. Does anyone know a better way?
Omid,

--
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 https://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.
Archiver
User
User
Posts: 7876
Joined: 7 years ago

Re: how to put zero values in gdx and excel output?

Post by Archiver »


Hello Omid:

A Q&D way:

parameter xStored(t);

xStored(t)=x.l(t)+EPS;

Hope to help.
Regards
Claudio


On Fri, Jan 29, 2016 at 5:50 PM, omid ziaee wrote:

Hi,
I am looking for a way to show zero values in the gdx and excel output. I have tried the following but it is frustrating and I need to repeat it each time,

acronym zero;
x.l(t) $ (x.l(t) eq 0) = zero;

This works fine but as I said it is not convenient. Does anyone know a better way?
Omid,

--
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 https://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 https://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.
Archiver
User
User
Posts: 7876
Joined: 7 years ago

Re: how to put zero values in gdx and excel output?

Post by Archiver »


Thanks that seems a better way. However, it is still a burden. I was wondering why there is no setting for this in gams.

On Monday, February 1, 2016 at 7:39:00 AM UTC-6, Claudio Delpino wrote:

Hello Omid:

A Q&D way:

parameter xStored(t);

xStored(t)=x.l(t)+EPS;

Hope to help.
Regards
Claudio


On Fri, Jan 29, 2016 at 5:50 PM, omid ziaee wrote:

Hi,
I am looking for a way to show zero values in the gdx and excel output. I have tried the following but it is frustrating and I need to repeat it each time,

acronym zero;
x.l(t) $ (x.l(t) eq 0) = zero;

This works fine but as I said it is not convenient. Does anyone know a better way?
Omid,

--
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+...@googlegroups.com.
To post to this group, send email to gams...@googlegroups.com.
Visit this group at https://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 https://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.
Post Reply