Search found 63 matches

by Jarenka
11 months ago
Forum: Syntax
Topic: How to execute many "programs" at one time?
Replies: 10
Views: 2138

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
1 year ago
Forum: Syntax
Topic: Decimal option in gdx-otput file
Replies: 2
Views: 601

Re: Decimal option in gdx-otput file

Thank you for your answer!!
by Jarenka
1 year ago
Forum: Syntax
Topic: Decimal option in gdx-otput file
Replies: 2
Views: 601

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
1 year ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 4360

Re: Structuring of Excel output-file in GAMS

Thank you very much for your help!

Best
Jarenka
by Jarenka
1 year ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 4360

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
1 year ago
Forum: Syntax
Topic: Error: overflow in + operation (addop)
Replies: 3
Views: 746

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
1 year ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 4360

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
1 year ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 4360

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
1 year ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 4360

Re: Structuring of Excel output-file in GAMS

Everything would be perfect if I had PowerPivot :-)
by Jarenka
1 year ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 4360

Re: Structuring of Excel output-file in GAMS

Yes. I corrected the code. There are no errors.
But the problems appears when I want to look at results.csv file. It shows only 1,048,576 rows (I increased dimensions in test-parameter) and no more.