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.