Search found 11 matches
- 19 hours ago
- Forum: Tools
- Topic: ExcelWriter valueSubstitutions question
- Replies: 4
- Views: 378
Re: ExcelWriter valueSubstitutions question
Thanks. I think I'll try replacing small values with 0 in GAMS prior to calling ExcelWriter.
- 3 days ago
- Forum: Tools
- Topic: ExcelWriter valueSubstitutions question
- Replies: 4
- Views: 378
Re: ExcelWriter valueSubstitutions question
Hi Clemens,
Thanks. If I use the filter and let's say for a given row of output, if one column meets the criteria to be filtered but the other columns in that row do not meet the criteria, is the whole row filtered out? Or is the one value in the relevant column blank?
Eric
Thanks. If I use the filter and let's say for a given row of output, if one column meets the criteria to be filtered but the other columns in that row do not meet the criteria, is the whole row filtered out? Or is the one value in the relevant column blank?
Eric
- 4 days ago
- Forum: Tools
- Topic: ExcelWriter valueSubstitutions question
- Replies: 4
- Views: 378
ExcelWriter valueSubstitutions question
I'm running a large model with CPLEX using parallelmode -1, so it isn't deterministic, and most "0" values are not zero and have very small values. Just for output reading clarity, I was hoping that I would be able to use valueSubstitutions to replace values <0.000001 with zero: valueSubst...
- 3 months ago
- Forum: Modeling
- Topic: GAMS/CPLEX on Mac with M series CPU?
- Replies: 0
- Views: 3464
GAMS/CPLEX on Mac with M series CPU?
I was wondering if anyone has experience using GAMS/CPLEX on a Mac with an M series CPU. I understand that GDXXRW won't work on a Mac. Are there any other issues like this? Sorry if this isn't the best place to ask -- I wasn't sure where it should go. The reason I ask is that I have had quite bad lu...
- 4 months ago
- Forum: Modeling
- Topic: Best practice for 2 modelers developing a GAMS model?
- Replies: 3
- Views: 55261
Re: Best practice for 2 modelers developing a GAMS model?
GAMS syntax is very light-weighted so I am curious why you would need two people working on the GAMS modeling. But back to your question, if you think Git is too much, try SVN, though the latter one is far outdated for modern software development, but could be efficient as long as your team only ha...
- 4 months ago
- Forum: Modeling
- Topic: Best practice for 2 modelers developing a GAMS model?
- Replies: 3
- Views: 55261
Best practice for 2 modelers developing a GAMS model?
I have been developing a global energy model written in GAMS. I have had my model files on my Microsoft Onedrive so that they would be constantly backed up, but I have had to manually do version control, and it has always been cumbersome to do it, but workable since I was the only person working on ...
- 1 year ago
- Forum: API
- Topic: apifiles/Python/ missing in fresh GAMS 42 install
- Replies: 1
- Views: 5176
apifiles/Python/ missing in fresh GAMS 42 install
I'm trying to install GAMS transfer for python, but in my fresh GAMS 42 installation, there is no Python folder under apifiles. There is this: C:\GAMS\42\api\python but there is no setup.py in this folder or subfolders. If I search for 'setup.py' under GAMS\42, there are 17 that are found -- all und...
- 1 year ago
- Forum: Modeling
- Topic: Help translating dynamic set statement from GNU mathprog
- Replies: 1
- Views: 2489
Help translating dynamic set statement from GNU mathprog
I'm trying to translate a model written in GNU mathprog. Most of it is pretty straightforward, but there are some dynamic set declarations and operations that are puzzling me. This is an example of a statement for a dynamic set in GNU mathprog that I'm struggling to translate into GAMS: set MODExTEC...
- 2 years ago
- Forum: Modeling
- Topic: Model running much slower on new, faster computer
- Replies: 4
- Views: 4325
Re: Model running much slower on new, faster computer
Hi Michael, I am copying some relevant bits from the log files from the old computer and new computer. The beginning and end of the first and second solves for both computers. The subsequent solves follow the same pattern. Thanks again for your help. OLD computer 1st solve in loop (cutting out the m...
- 2 years ago
- Forum: Modeling
- Topic: Model running much slower on new, faster computer
- Replies: 4
- Views: 4325
Re: Model running much slower on new, faster computer
Michael, Thanks. I was looking at the log files, and it appears that on the first scenario, the new system outperforms the old system, and everything else looks identical. On the next loop and solve, the old system appears to be starting at a point much closer to the optimal; whereas the new system ...