Search found 56 matches

by Jarenka
4 months ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 1070

Re: Structuring of Excel output-file in GAMS

Hi Renger,

This is something that I also tried.
And I didn't get any Excel output file.
See the attachment.
by Jarenka
4 months ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 1070

Structuring of Excel output-file in GAMS

Dear, I refer to this post: https://forum.gamsworld.org/viewtopic.php?f=2&t=10904 I have a problem with structure of Excel file - output file with variables having many dimensions. I added as recommended: rdim=5 cdim=1 . My code looks like that in the attachment. Parameter "qabg" is six-dimensional....
by Jarenka
4 months ago
Forum: Archive Google Group
Topic: Large Numbers
Replies: 5
Views: 951

Re: Large Numbers

Hi, My problem is very similar to above. I get Error: overflow in + operation (addop) I was trying to find a solution to the summation I use in the equation (red line), but I couldn't find a solution with the similar problem. You can see that I use two "T"-temporary variables first to do this summat...
by Jarenka
5 months ago
Forum: Syntax
Topic: Help with gams, gdx and xlsx
Replies: 6
Views: 519

Re: Help with gams, gdx and xlsx

I need to transport some parameters from *.gdx file into excel. I would like to do it precisely column by column, no transportation of columns into rows. My code is the following: execute_unload 'VarToBrugegruppe.gdx', qabg quabg qsabg; execute 'gdxxrw VarToBrugegruppe.gdx o=TabelA15.xlsx filter=1 t...
by Jarenka
8 months ago
Forum: Syntax
Topic: Urgent HELP! , GDX output in a loop uses old variable values
Replies: 7
Views: 1291

Re: Urgent HELP! , GDX output in a loop uses old variable values

Now it works. It should be "\" and not "/". :D
by Jarenka
9 months ago
Forum: Syntax
Topic: Urgent HELP! , GDX output in a loop uses old variable values
Replies: 7
Views: 1291

Re: Urgent HELP! , GDX output in a loop uses old variable values

I have *.gdx files (created externally from R program) that are placed in a different directory "gdx", which is a sub-directory to my working directory. I want to read them in to GAMS. I tried the options above, but they do not work. How can I include them into GAMS from the "gdx" directory. I tried...
by Jarenka
9 months ago
Forum: Syntax
Topic: Urgent HELP! , GDX output in a loop uses old variable values
Replies: 7
Views: 1291

Re: Urgent HELP! , GDX output in a loop uses old variable values

Thank you! It seems it works on my 64bit computer, but I couldn't make it work on 32bit. There is no commend line in GAMS Studio installed on 32bit computer. Anyway, in case when you want to call/include this mymodel.gdx file from that folder, like this: $gdxin mymodel.gdx $load ... you just press F...
by Jarenka
9 months ago
Forum: Syntax
Topic: Urgent HELP! , GDX output in a loop uses old variable values
Replies: 7
Views: 1291

Re: Urgent HELP! , GDX output in a loop uses old variable values

Dear, I have a question concerning gdx-output changing path. I am writing a code in a normal *.gms file named LINE2.gms. I press F10 and automatically comes LINE2.gdx file in the same directory. I would like to have this LINE2.gdx file placed in a different directory, for example: ""gdx"". I tried o...
by Jarenka
11 months ago
Forum: Syntax
Topic: Macros containing equations
Replies: 6
Views: 5296

Re: Macros containing equations

I have been trying to use $macro commend instead of repeating the lines (attached file/snipping shot) 23 times. But I cannot make it work. What I need to do is the following: a. first I recalculate a sector using some variables, b. than I save recalculated values in a variable, c. I clean the variab...
by Jarenka
1 year ago
Forum: Syntax
Topic: searching string in set
Replies: 11
Views: 1344

Re: searching string in set

I have sth like this (se attachment). And I tried to apply your code, but it says: "Lags are not allowed on maps".