Excel output in Gams

HI All,
I have parameter D(p,k,t) demand of product p in market k in time period t.
and second parameter C(i,p,t) availability of product p at warehouse i in time period t.

Now want to get an output in excel file as for example:

product market demand warehouse1 warehouse 2 … warehouse i
p1 k1 48 10 0 100

Can anybody please share the possible suggestion.

Regards,
Dharmender Y


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

There is a utility gdxxrw (see the GDXUTILS-Tool.pdf file with the documentation and lots of examples in your gams\doc directory )

Cheers

Renger



From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of dharmender yadav
Sent: Thursday, July 05, 2012 4:00 AM
To: gamsworld@googlegroups.com
Subject: Excel output in Gams



HI All,

I have parameter D(p,k,t) demand of product p in market k in time period t.

and second parameter C(i,p,t) availability of product p at warehouse i in time period t.



Now want to get an output in excel file as for example:



product market demand warehouse1 warehouse 2 … warehouse i

p1 k1 48 10 0 100



Can anybody please share the possible suggestion.



Regards,

Dharmender Y


\

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

Hi Darhmender

I think that you could do it with a put statement which has loops…

I have not worked with them, but I think that might work…



What I do have done is to export the data sets to access, then cross reference query and finally export it to excel…

Maybe a pivot table in excel might do the trick, but I prefer to use queries than pivot tables…

Regards







MC. José Miguel Quesada Pérez
Departamento de Ingeniería Industrial

Tecnológico de Monterrey, Campus Querétaro

52 (442) 238 3100 Ext: 6349

Fax: (442) 238 32 70

Enlace intercampus: 8 0 776 6349



cid:image002.png@01CD2C58.E47E9EA0


El contenido de este mensaje de datos no se considera oferta, propuesta o acuerdo, sino hasta que sea confirmado en documento por escrito que contenga la firma autógrafa del apoderado legal del ITESM. El contenido de este mensaje de datos es confidencial y se entiende dirigido y para uso exclusivo del destinatario, por lo que no podrá distribuirse y/o difundirse por ningún medio sin la previa autorización del emisor original. Si usted no es el destinatario, se le prohíbe su utilización total o parcial para cualquier fin.

The content of this data transmission is not considered as an offer, proposal, understanding, or agreement unless it is confirmed in a document signed by a legal representative of ITESM. The content of this data transmission is confidential and it is intended to be delivered only to the addresses, therefore, it shall not be distributed and/or disclosed through any mean without the original sender’s previous authorization. If you are not the addressee you are forbidden to use it, either totally or partially, for any purpose.



From: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of dharmender yadav
Sent: miércoles, 04 de julio de 2012 09:00 p.m.
To: gamsworld@googlegroups.com
Subject: Excel output in Gams



HI All,

I have parameter D(p,k,t) demand of product p in market k in time period t.

and second parameter C(i,p,t) availability of product p at warehouse i in time period t.



Now want to get an output in excel file as for example:



product market demand warehouse1 warehouse 2 … warehouse i

p1 k1 48 10 0 100



Can anybody please share the possible suggestion.



Regards,

Dharmender Y


\

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

Thanks Mr, Renger and Mr. Bose for your valuable suggestion. I am trying to learn these new commands.

Regards,
Dharender Y.
91-7569990625

On Thursday, 5 July 2012 07:29:43 UTC+5:30, dharmender yadav wrote:

HI All,
I have parameter D(p,k,t) demand of product p in market k in time period t.
and second parameter C(i,p,t) availability of product p at warehouse i in time period t.

Now want to get an output in excel file as for example:

product market demand warehouse1 warehouse 2 … warehouse i
p1 k1 48 10 0 100

Can anybody please share the possible suggestion.

Regards,
Dharmender Y


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