Did you check the model/solve status before you report things back to Excel? The solver might have told you that the model is (locally) infeasible.
-Michael
Search found 1047 matches
- 6 years ago
- Forum: Modeling
- Topic: Problem with ignoring GAMS constraints
- Replies: 4
- Views: 4576
- 6 years ago
- Forum: Solvers
- Topic: CPLEX time vs resUsd
- Replies: 5
- Views: 6881
Re: CPLEX time vs resUsd
The resUsd includes time to set up the model in Cplex and to report the solution to GAMS. For quadratic models it also included the time to extract the Q matrices from the non-linear instructions. Usually the time between resUsd and the time Cplex reports in the log is small and of not much practica...
- 6 years ago
- Forum: Syntax
- Topic: excel to gams
- Replies: 12
- Views: 21268
Re: excel to gams
If you look at the content of the GDX file it will be pretty obvious that the read did not succeed as you planned: C:\Users\Michael\Downloads>gdxdump Daten-TSP.gdx $onempty Parameter d(*,*) / 'j2'.'0' 8.9, 'j2'.'2.2' 9.3, 'j2'.'1.8' 10.5, 'j2'.'10.1' 11.4, 'j2'.'0.6' 8.6, 'j3'.'0' 2.3, ... Problem i...
- 6 years ago
- Forum: Syntax
- Topic: excel to gams
- Replies: 12
- Views: 21268
Re: excel to gams
You should check the return code after a $call and you should load data with $loadDC to make sure that you don't leave record behind. $call GDXXRW.exe Daten-TSP.xlsx trace=3 par=d rng=Tabelle1!A2 rdim=1 cdim=1 $if errorlevel 1 $abort problems with gdxxrw $GDXIN Daten-TSP.gdx $LOADDC d Hope this help...
- 6 years ago
- Forum: Modeling
- Topic: Quadratic constrained convex problem
- Replies: 2
- Views: 5026
Re: Quadratic constrained convex problem
Not sure what you mean. If I solve this with a global solver like Antigone, Baron, Couenne, LindoGlobal, or SCIP (since this is a non-convex QCP) I get a good solution: LOWER LEVEL UPPER MARGINAL ---- VAR OF -INF 4.472 +INF . ---- VAR x1 -INF 0.011 +INF . ---- VAR x2 -INF 4.472 +INF . Not sure what ...
- 6 years ago
- Forum: Syntax
- Topic: excel to gams
- Replies: 12
- Views: 21268
Re: excel to gams
Hi, Writing to an open workbook is possible but very much discouraged. You need to share you workbook (see https://support.office.com/en-us/article/About-the-shared-workbook-feature-49b833c0-873b-48d8-8bf2-c1c59a628534). Problem is that you only see the changes after "saving" the open work...
- 6 years ago
- Forum: Announcements
- Topic: GAMS Distribution 24.9.1 Announcement
- Replies: 0
- Views: 9213
GAMS Distribution 24.9.1 Announcement
Hi GAMS Users,
We started distributing GAMS Release 24.9.1 on August 30,2017
You can download the software from: https://www.gams.com/download/
Here are the release notes: https://www.gams.com/latest/docs/RN_249.html
-Michael
We started distributing GAMS Release 24.9.1 on August 30,2017
You can download the software from: https://www.gams.com/download/
Here are the release notes: https://www.gams.com/latest/docs/RN_249.html
-Michael
- 6 years ago
- Forum: Modeling
- Topic: load dimension are different
- Replies: 4
- Views: 7012
Re: load dimension are different
Dt has three dimensions in the GDX file and you declare it as Dt(r) (one dimensional). Not sure what your intension is but this is where GAMS chokes. The symbol Dt comes two dimensional out of gdxxrw (rdim=1 cdim=1) and then you merge things together (with gdxmerge) which add another index position....
- 6 years ago
- Forum: Modeling
- Topic: load dimension are different
- Replies: 4
- Views: 7012
Re: load dimension are different
Marina, You have declared the symbol in your GAMS program with a different number of dimensions than the symbol has in GDX. The following example has the same problem: set three(*,*,*) / 1.1.1, 2.2.2 /; $gdxOut three $unLoad three $gdxOut set two(*,*) $gdxIn three $load two=three gives: --- GDXin=C:...
- 6 years ago
- Forum: Modeling
- Topic: call external function
- Replies: 6
- Views: 5483
Re: call external function
Not sure I can be of any help if the examples and the documents are not sufficient. You can't just put a function in a DLL and hope GAMS works with it, You have to follow a strict API to make the function visible to GAMS. The trilib examples (https://www.gams.com/24.9/testlib_ml/libhtml/testlib_tril...