I am currently running my model in GAMS to get the results. I have a simple problem that could not find any solution for that yet. I need to run my model 500 times over a loop and unload the outputs in an excel spreadsheet but in different rows. is there is any way to solve this issue?

For example:

Sets

Parameters

Travel_Time â€˜Random timeâ€™

Equations

â€¦

Model Test /all/

For (i= 1 to 500,

Travel_time (k) = Uniform(10,100)

Solve test using MIP Maximising TC

Execute_unload â€œ Result.gdxâ€ X

execute â€˜gdxxrw.exe Result.gdx var=X rng=â€Sheet1!A2â€™

);

Is it possible to dynamically change the row number “A2” or the sheet number in the excel range in each run so that the I can have all the 500 different outputs in one spreadsheet?

Thank you very much for your time and help in advance.

–

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.