The GAMS Data Utilities Library

The GAMS Data Utilities library contains models that demonstrate various utilities to interface GAMS with other applications.

Name Description
CheckListbox Multiple ask popups for entering values through listboxes or checklistboxes
CHP Optimize combined heat and power generation in Excel, using vba API (gamsx and opt) and GDXXRW
CHP2 Optimize combined heat and power generation in Excel, using vba API (gamsx, opt and gdx)
Combobox Multiple ask popups for entering values through comboboxes
CompTimeWriteTrnsportGDX Writes data to GDX file during compile time
csv2gdx1 Test gdxdump and csv2gdx
datatest Driver for datalib tests of all sorts
dBASE Reads a dBASE table from United Nations Statistics Division
DBTimestamp1 Retrieve data from database once each day
DBTimestamp2 Retrieves data from database once each day
Distances1 Single-valued tables
Distances2 Single-valued tables
embeddedMultiInstance Handling multiple instances of the embedded code facility at once
embeddedSort Sorting of numerical data using the embedded code facility
embeddedSplit Splitting of labels using the embedded code facility
Excel Reads data from Excel through ODBC
ExecTimeReadTrnsportGDX Reads data from a GDX file during execution time
Fileopenbox Ask popup for opening a file
Filesavebox Ask popup for saving a file
GDXCOPYExample19 Copies a GDX file to a compressed format for version 6
GDXDIFFExample16 Compares two GDX files and writes the difference to a third GDX file
GDXDUMPExample15 Generates first a GDX file and then lists symbols in the GDX file
GDXExecute_unloadExample4 Writes data to GDX file during execution time
GDXINExample1 Illustrates use of demand data from an external source in compile phase
GDXINExample2 Illustrates use of demand and market data from an external source in compile phase
GDXINExample3 Lists all the symbols in Trnsport.gdx in the listing file in compile phase
GDXMERGEExample17 Merges a number of GDX files into one
GDXMRWPlotting01 GDXMRW examples for plotting
GDXMRWShowJac1 Visualize model Jacobian in Matlab
gdxmrw_ext01_init Extended use of GDXMRW
gdxmrw_intro01_init Introduction to data transfer between Matlab and GAMS
gdxmrw_intro02_init Introduction to calling GAMS from Matlab
gdxmrw_irgdx01_init Reading data from a indexed GDX file with IRGDX
gdxmrw_iwgdx01_init Writing data into a indexed GDX file with IWGDX
gdxmrw_qp1_starter Portfolio Analysis with Matlab and GAMS
gdxmrw_qp2_starter Portfolio Analysis with Matlab and GAMS
gdxmrw_qp3 QP solver M-file using GAMS and GDXMRW
gdxmrw_qp4 Calling GAMS model from Matlab
gdxmrw_rgdx01_init Reading data from a GDX file into a structure with RGDX
gdxmrw_tr1 Transport LP with non-indexed GDX data interface
gdxmrw_tr2 Transport LP with indexed GDX data interface
gdxmrw_tr3 canonical form LP created in Matlab and solved via gams() Mex-function
gdxmrw_tr4 better example of gams() usage
gdxmrw_tr5 better example of gams() usage
gdxmrw_wgdx01_init Writing structured data into a GDX file with WGDX
GDXRANKExample18 Sorts a parameter, creates a sorted version and verifies that the sort works correctly
GDXViewerExample Illustrates conversion of GDX data into different formats
GDXXRWExample10 Reads a number of parameters and sets using the index option from an MS Excel file and writes it to a GDX file
GDXXRWExample11a Generates a GDX file and writes it to an MS Excel file at compile time
GDXXRWExample11b Generates a GDX file and writes it to an MS Excel file at execution time
GDXXRWExample12 Illustrates the use of merge and clear option
GDXXRWExample13 Reads a table from an MS Excel file, manipulates data and writes it to first a GDX file and then to the MS Excel file
GDXXRWExample14 This example illustrates reading from and writing to an MS Excel file using a modified version of trnsport.gms
GDXXRWExample15 Write spreadsheet using a filter
GDXXRWExample16 Write spreadsheet using text and hyperlinks
GDXXRWExample5 Reads a two dimensional parameter from an MS Excel file and writes it to a GDX file
GDXXRWExample6 Reads a two dimensional parameter from an MS Excel file and writes it to a GDX file
GDXXRWExample7 Reads a four dimensional parameter from an MS Excel file and writes it to a GDX file
GDXXRWExample8 Reads a parameter with special values from an MS Excel file and writes it to a GDX file
GDXXRWExample9 Reads a set using 'values' option from an MS Excel file and writes it to a GDX file
gdxxrw_autoopen Tests that gdxxrw calls the auto_open macro facility
IndexMapping1 Index mapping in GAMS code
IndexMapping2 Index mapping in MS Access
IndexMapping3 Index mapping in GAMS code
IndexMapping4 Index mapping in MS Access
invert1 Matrix inversion via R
invert2 Matrix inversion via Matlab
Loadpoint Illustrates use of "execute_loadpoint" command
MDB2GDX1 Creates a GDX file in execution time and displays it in GDXVIEWER
MDB2GDX2 Creates a GDX file in compile time
MDB2GMS Runs MDB2GMS interactively
MDBSr5 Sequence of GAMS models using save/restart facility
MultipleAsk Multiple ask popups for entering various data types
PopulateV Creates MS Access database
Portfolio Determines an efficient frontier in Excel, using the GDX DLL (vba API) and the GAMS executable
RadioButton Multiple ask popups for entering values through radio buttons
readdata Read data from .inc, .xls, .mdb and .csv file
ReadMultiDimPar Reads a multidimensional parameter
ReadMultiRange Reads a multi-area range and does post processing to eliminate invalid entries
ReadSet Reads set data
ReadTrnsportData1 Reads set data and the table of the transportation model in several calls
ReadTrnsportData2 Reads set data and the table of the transportation model in one call
SalesProfitDB1 Single-valued tables
SalesProfitDB2c Use of UNION to read multi-data column tables
SalesProfitDB2m Use of UNION to read multi-data column tables
SalesProfitDB3 Multiple queries in one call
SalesProfitDB4 Multiple queries in one call
SalesProfitDB5 Use of UNION to read multi-data column tables
SalesProfitDB6 Multiple queries in one call
SalesProfitDB7 Multiple queries in one call
Samurai Solve a Samurai Sudoku in Excel, using the GDX DLL (vba API) and the GAMS executable
Samurai2 Solve a Samurai Sudoku in Excel, using the GDX and GAMSX DLL (vba API)
Savepoint Saves solution to a log or GDX file
SingleAsk Single ask popup for entering an integer value
SpawnGAMSAccess Spawn GAMS from Access
SpawnGAMSExcel Spawn an arbitrary GAMS model from Excel
SQL2GDX1 Creates a GDX file in execution time and displays it in GDXVIEWER
SQL2GDX2 Creates a GDX file in compile time
SQL2GMS Runs SQL2GMS interactively
SQLServer Test timeouts against SQL Server
SQLSr5 Sequence of GAMS models using save/restart facility
Sudoku Solve a Sudoku in Excel, using the GDX DLL (vba API) and the GAMS executable
Text Reads table from a text file using the ODBC Text Driver
tompivot Little GAMS Program from Tom Rutherford that Illustrates Report Generation with Excel
transxls Solve classical transportation problem in Excel, using vba API (gamsx, opt and gdx)
triobal Tommasino-Rao Input Output Balance Software
TrnsxcllStarter Excel Spreadsheet in Charge of GAMS
tsvngdx Integrate gdxdiff with TortoiseSVN
Wiring Use of wiring option to read multi-data column tables