Search found 64 matches

by Jarenka
4 years ago
Forum: Syntax
Topic: How to execute many "programs" at one time?
Replies: 10
Views: 7735

Re: How to execute many "programs" at one time?

The most important think is to receive *gdx file with all parameters for each specified section. Usually, I start with running LINE1A_Data and create *gdx file (with the same name usually). Then I run LINE1A_Incomes.gms and create *.gdx file again. And so on ... The point is to run each section inde...
by Jarenka
4 years ago
Forum: Syntax
Topic: How to execute many "programs" at one time?
Replies: 10
Views: 7735

How to execute many "programs" at one time?

Dear, I have a couple of sections (see in the attachment, all LINE ...), which I would like to run at one time, not separately as I do it now. Each section contains parameters that might repeat in another section, but not necessary. How to do it in GAMS? My point is to run each of them and create *g...
by Jarenka
4 years ago
Forum: Syntax
Topic: Decimal option in gdx-otput file
Replies: 2
Views: 2260

Re: Decimal option in gdx-otput file

Thank you for your answer!!
by Jarenka
4 years ago
Forum: Syntax
Topic: Decimal option in gdx-otput file
Replies: 2
Views: 2260

Decimal option in gdx-otput file

Dear, I have not found a similar topic or discussion about gdx-view, so I am creating a new one. I would like to know how I can set up an option that suppresses number of decimals in gdx-file, for example to two. Currently, I have a something like this - see the attached file. gdx-output-employment....
by Jarenka
4 years ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 14536

Re: Structuring of Excel output-file in GAMS

Thank you very much for your help!

Best
Jarenka
by Jarenka
4 years ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 14536

Re: Structuring of Excel output-file in GAMS

Yes, I have already used gdxdump for csv-files and then open them in Access database.

So you mean that txt-files are not a good option as an export file for GAMS, right?

Best,
Jarenka
by Jarenka
4 years ago
Forum: Syntax
Topic: Error: overflow in + operation (addop)
Replies: 12
Views: 9933

Re: Error: overflow in + operation (addop)

Hi, it seems that the result of the assignment statement is > 1E300 which causes an overflow. Are you sure that you need such large numbers. And are you sure that you found the right line in your code? With include files this can be tricky, so I suggest to check the line number in the echo print of...
by Jarenka
4 years ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 14536

Re: Structuring of Excel output-file in GAMS

Hi,

I succeeded with Access database, finally. Over 15 mln. rows.
I have no experience in Access. Is it possible to do summations or PivotTable-kind of analysis?

Do you know also, whether there is a possibility to export directly to a txt-file from gdx-file or a csv-file?

Best
Jarenka
by Jarenka
4 years ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 14536

Re: Structuring of Excel output-file in GAMS

I have found "Data Query" in Excel 2016, see attachment (it did not succeed).
It stopped at around 10,000,000 rows.

I will try with Access, and others.

Thank YOU FOR YOUR HELP !!!
by Jarenka
4 years ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 14536

Re: Structuring of Excel output-file in GAMS

Everything would be perfect if I had PowerPivot :-)