Re: How to use loop to run model several times when some random data is being imported from excel.
Posted: Thu May 09, 2019 8:35 am
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.
Hope this helps!
Cheers
Renger
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;
Cheers
Renger