Hi Sergio
You can for example, instead of defining your problem in terms of Xi, define it in terms of Xij, where j is the run number within your for cycle, then you have at the end a matrix of variables and you can export all the results in one classical execute_unload. 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 Sérgio
Sent: jueves, 06 de septiembre de 2012 10:46 a.m.
To: gamsworld@googlegroups.com
Subject: Gams to excel
Hi everyone!!!
I created a model which I needed to run for 4 times. In each run my parameter data changes, so I will have 4 different results. For that I used a for cycle and it is working well. My problem now is that I need to export the solution of each run to excel in 4 different sheets. Before needed to run the model 4 times I was using the execute_unload and execute commands successfully. Now I don’t known how to do it…
Anyone knows how can I do it.
Regards
Sérgio
–
To view this discussion on the web visit https://groups.google.com/d/msg/gamsworld/-/ciBRBQnxXMwJ.
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.
