GAMS World Forum

there isn't a way to do this. I might suggest using python to read the excel file (the openpyxl package will work). then you can write a gdxfile with the gdxtools package Example file: https://github.com/boxblox/gdxtools

best,
adam

It kinda sounds like you are using gams to do scripting? This seems a bit off topic for the forum, but I like being helpful... if you are just doing a bunch of data manipulation you might want to go into a python environment and work there... or if you have a massive dataset you could put it all int...

Hi Omidi, I am not as clear on why you would need an MPS file... but NEOS is a great tool... so this is worth figuring out. I typically engage with NEOS through the Kestrel 'solver' rather than their webforms. https://www.gams.com/latest/docs/S_KESTREL.html By using Kestrel the gams model is package...

Hi there ayledith, If you are familar with python you can use a tool I wrote to get data into a GDX and then you can load that data into a gams model through a $GDXIN statement... gdxtools can be installed with pip install gdxtools an example file of several different read/write operations can be fo...

hi there... i think we might need a bit of clarifying information here to help out. Do you have a superset that includes all elements j+n? Or are you trying to do some sort of circular lead/lag operation? If so, check out the documentation here: https://www.gams.com/latest/docs/UG_OrderedSets.html (...

If you use the Atom editor to write gams code (and run things in the terminal) there is some nice syntax highlighting built into the language_gams package (https://github.com/xhokir/atom-language-gams). it doesn't get everything but I find it really helpful.
-- adam

I suspect that you might not be redefining your original parameter within the loop

something like:

PARAMETER sample(iter);
*create some fake parameter to sample from
sample(iter) = uniform(0,1);

loop(iter,
my_original_parameter = sample(iter);
SOLVE my model....
);

does that help?
best,
adam

Hi eisenhee, No problem about being new to GAMS! It's important to note that a table and a parameter are the same thing... just a slightly different syntax for entry. Tables are really helpful for 2D data, but can get a bit messy with higher dimensional data. I have gotten in the habit of just using...