How to use loop to run model several times when some random data is being imported from excel.

Problems with modeling
Post Reply
mbh
User
User
Posts: 10
Joined: 1 year ago

How to use loop to run model several times when some random data is being imported from excel.

Post by mbh » 7 months ago

Hi All,
I import some random data from excel into GAMS. So every time that I run the model the results change because the random numbers change. I'd like to use a loop to rum the model several times by that loop rather than running manually. I would appreciate it if anyone can help me. Sorry if the question is very basic.

Best,
Mary

User avatar
Renger
Posts: 406
Joined: 3 years ago

Re: How to use loop to run model several times when some random data is being imported from excel.

Post by Renger » 7 months ago

Hi
If you want, for example, loop over 10 sets of random data, you could define your data indexed over your loop and read all of them before the loop.

Code: Select all

set 
	iteration /1*10/,
	sectors   /s1*s20/;

parameter randSectors(sectors, iteration) Random data for sectors;

** Pseudo code
* Read your data from Excel organized in a two-dimensional table (sectors * iteration)
**
loop(iteration,
      randData(sectors) = randSectors(sectors, iteration);
      solve mymodel
end;
      
Hope this helps!
Cheers
Renger
____________________________________
Enjoy modeling even more: Read my blog on modeling at The lazy economist

mbh
User
User
Posts: 10
Joined: 1 year ago

Re: How to use loop to run model several times when some random data is being imported from excel.

Post by mbh » 7 months ago

Hi Renger,
Thank you very much for your help.

Best,
Mary

Post Reply