gams – data exchange (gdx) tools and utilities attilities
TRANSCRIPT
![Page 1: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/1.jpg)
GAMS – Data Exchange (GDX)
Tools and Utilitiesattilities
Paul van der Eijk [email protected]
GAMS Development Corp. www.gams.com
GAMS Software GmbH www.gams.de
Informs,
San Diego,
2009
![Page 2: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/2.jpg)
GDX files
Data file for multiple GAMS symbols
2
![Page 3: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/3.jpg)
GDX files
Data file for multiple GAMS symbols
No Symbolic Equations
3
![Page 4: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/4.jpg)
GDX files
Data file for multiple GAMS symbols
No Symbolic Equations
Binary (no loss of precision)
4
![Page 5: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/5.jpg)
GDX files
Data file for multiple GAMS symbols
No Symbolic Equations
Binary (no loss of precision)
5
Platform independent
![Page 6: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/6.jpg)
GDX files
Data file for multiple GAMS symbols
No Symbolic Equations
Binary (no loss of precision)
6
Platform independent
Contains domain information
![Page 7: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/7.jpg)
GDX files
Data file for multiple GAMS symbols
No Symbolic Equations
Binary (no loss of precision)
7
Platform independent
Contains domain information
Can be compressed
![Page 8: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/8.jpg)
GDX files
Data file for multiple GAMS symbols
No Symbolic Equations
Binary (no loss of precision)
8
Platform independent
Contains domain information
Can be compressed
GDX Tools do not require a licenseies
![Page 9: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/9.jpg)
GDX files
Data file for multiple GAMS symbols
No Symbolic Equations
Binary (no loss of precision)
9
Platform independent
Contains domain information
Can be compressed
GDX Tools do not require a license
Open API for multi language/platformes
![Page 10: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/10.jpg)
Create a GDX file
10
![Page 11: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/11.jpg)
Viewing a GDX file
11
![Page 12: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/12.jpg)
Viewing a GDX file (GAMS IDE)
12
![Page 13: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/13.jpg)
Export GDX file (GAMS IDE)
13
![Page 14: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/14.jpg)
View file in Excel
14
![Page 15: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/15.jpg)
Export GDX file (GAMS IDE)
15
![Page 16: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/16.jpg)
View file in Excel (TOC)
16
![Page 17: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/17.jpg)
View file in Excel
17
![Page 18: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/18.jpg)
View GDX File GAMS IDE
18
![Page 19: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/19.jpg)
GDXDiff
19
![Page 20: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/20.jpg)
GDXDiff
20
![Page 21: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/21.jpg)
GDXMerge* Generate a few gdx files
$call rm *.gdx
$call gamslib trnsport
$call gams trnsport lp=bdmlp gdx=bdmlp
$call gams trnsport lp=cplex gdx=cplex
21
$call gams trnsport lp=cplex gdx=cplex
$call gams trnsport lp=conopt gdx=conopt
$call gams trnsport lp=gurobi gdx=gurobi
$call gams trnsport lp=minos gdx=minos
$call gams trnsport lp=snopt gdx=snopt
$call gams trnsport lp=xa gdx=xa
$call gams trnsport lp=xpress gdx=xpress
$call gdxmerge *.gdx
$call shellexecute /verb=open merged.gdx
![Page 22: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/22.jpg)
GDXMerge
22
![Page 23: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/23.jpg)
GDXXRW
Reading and writing Excel spreadsheets
Requires that MS Excel is installed
23
![Page 24: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/24.jpg)
GDXXRW
24
![Page 25: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/25.jpg)
GDXXRW
$call =gdxxrw.exe data1.xls cmerge=1 par=A rng=sheet1!A1
rdim=2 cdim=2
25
![Page 26: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/26.jpg)
GDXXRW
26
![Page 27: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/27.jpg)
GDXXRW
27
![Page 28: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/28.jpg)
GDXXRW
XLSTalk utility
28
![Page 29: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/29.jpg)
GDXXRW
XLSTalk utility
Test if Excel is installed
Open / Close Excel file
29
Open / Close Excel file
Run an Excel Macro
![Page 30: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/30.jpg)
GDX API
Support for multiple languages
30
![Page 31: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/31.jpg)
GDX API
Support for multiple languages
CC++
Delphi (Pascal)
31
Delphi (Pascal)FortranJavaVisual Basic
![Page 32: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/32.jpg)
GDX API
Support for multiple platforms
32
![Page 33: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/33.jpg)
GDX API
Support for multiple platforms
All platforms where GAMS is available
33
![Page 34: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/34.jpg)
GDX API Examples / Documentation
34
![Page 35: GAMS – Data Exchange (GDX) Tools and Utilities attilities](https://reader034.vdocuments.us/reader034/viewer/2022051323/627bdac77f51ea7c7a2a3051/html5/thumbnails/35.jpg)
Contacting GAMS
Europe
GAMS Software GmbH
Eupener Str. 135-137
50933 Cologne
USA
GAMS Development Corp. 1217 Potomac Street, NW
50933 CologneGermany
Phone: +49 221 949 9170
Fax: +49 221 949 9171
http://www.gams.de
1217 Potomac Street, NW
Washington, DC 20007USA
Phone: +1 202 342 0180
Fax: +1 202 342 0181
http://www.gams.com
35