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 (opt) and GDXXRW |
CHP2 | Optimize combined heat and power generation in Excel, using vba API (opt and gdx) |
Combobox | Multiple ask popups for entering values through comboboxes |
CompTimeWriteTrnsportGDX | Writes data to GDX file during compile time |
connect01 | Complex Connect Example with Spreadsheets |
connect02 | Complex Connect Example with CSV Files |
connect03 | Simple Connect Example with CSV Files |
connect04 | Simple Connect Example for SQL |
connect05 | Simple Connect Example for Excel |
csv2gdx1 | Test gdxdump and csvread |
csv2gdx10 | CSVRead Example 10 - Reading Set Elements with explanatory Text |
csv2gdx2 | CSVRead Example 2 - Reading CSV Files with CSVRead |
csv2gdx3 | CSVRead Example 3 - Reading Semicolon separated Data |
csv2gdx4 | CSVRead Example 4 - Dealing with missing Labels and Duplicates |
csv2gdx5 | CSVRead Example 5 - Reading more than one Parameter from a single Input File |
csv2gdx6 | CSVRead Example 6 - Reading economic Data from the World Bank Data Catalog |
csv2gdx7 | CSV2GDX Example 7 - Reading special Values with CSV2GDX |
csv2gdx8 | CSV2GDX Example 8 - Reading an compressed encrypted Input File |
csv2gdx9 | CSVRead Example 9 - Reading Options from an external File |
datatest | Driver for datalib tests of all sorts |
dBASE | Reads a dBASE table from United Nations Statistics Division |
DBTimestamp1 | Retrieves Data from Database once each Day |
DBTimestamp2 | Retrieves Data from Database once each Day |
Distances1 | MDB2GMS Example 1 - Reading a single valued Table |
Distances2 | SQL2GMS Example 1 - Reading a single valued Table |
embeddedSort | Sorting of numerical data using the embedded code facility |
embeddedSplit | Splitting of labels using the embedded code facility |
EngineSolve | Demonstrate how to submit just a solve statement to Engine |
EngineSolveAsync | Demonstrate how to asynchronously submit solve statements to Engine |
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 |
GDX2ACCESSExample1 | Dumping the Contents of trnsport.gdx |
GDX2ACCESSExample2 | Writing Explanatory Text to Database |
GDX2ACCESSExample3 | Dumping a large Table to Database |
GDX2ACCESSExample4 | Special Value Mapping |
GDX2ACCESSExample5 | Renaming Fields |
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 |
GDXDUMPExample1 | GDXDUMP - Adding double Quotes to an user defined Header when writing to CSV |
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 |
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 | Reading Spreadsheet using the index Option |
GDXXRWExample11a | Writing Sets and Parameter to Spreadsheet at Compile Time |
GDXXRWExample11b | Writing Sets and Parameter to Spreadsheet at Execution Time |
GDXXRWExample12 | Writing to Spreadsheet using the merge and clear Option |
GDXXRWExample13 | Reads a Table from Spreadsheet, manipulates the Data and writes back to Spreadsheet |
GDXXRWExample14 | Reading Data from Spreadsheet and writing Data to Spreadsheet after Solve |
GDXXRWExample15 | Writing to Spreadsheet using a Filter |
GDXXRWExample16 | Writing to Spreadsheet adding Text and Hyperlinks |
GDXXRWExample17 | Reading several Scalars from Spreadsheet |
GDXXRWExample18 | Reading Sets from Spreadsheet |
GDXXRWExample19 | Writing Parameter to Spreadsheet including Zero Values |
GDXXRWExample20 | Reading empty Cells with colMerge and reading merged Excel Ranges with cMerge |
GDXXRWExample21 | Skipping empty Rows or Columns and Ignoring Rows or Columns |
GDXXRWExample5 | Reading Parameter from Spreadsheet |
GDXXRWExample6 | Reading Parameter from Spreadsheet with Duplication |
GDXXRWExample7 | Reading Multi-dimensional Parameter from Spreadsheet |
GDXXRWExample8 | Reading Special Values from Spreadsheet and writing to Spreadsheet |
GDXXRWExample9 | Reading Set Elements associated with Data or Text using the values Option |
gdxxrw_autoopen | Tests that gdxxrw calls the auto_open macro facility |
GMSPythonCheck | Consistency check for GMSPython |
GMSPythonLib | GMSPYTHONLIB compatibility check |
gtmvn | Demonstrate the use of numpy.multivariate_normal on stock return data using Transfer |
IndexMapping1 | MDB2GMS Example 6 - Index Mapping done in GAMS |
IndexMapping2 | MDB2GMS Example 6 - Index mapping done in Database |
IndexMapping3 | SQL2GMS Example 6 - Index Mapping done in GAMS |
IndexMapping4 | SQL2GMS Example 6 - Index mapping done in Database |
LeastSquares | Demonstrate the use of numpy.linalg.lstsq on the diabetes test problem using linalg ols |
Loadpoint | Illustrates use of "execute_loadpoint" command |
MDB2GDX1 | Creates a GDX File using MDB2GMS at execution Time and displays it in GDXVIEWER |
MDB2GDX2 | Creates a GDX File using MDB2GMS at compile Time |
MDB2GMS | Runs MDB2GMS interactively |
mdbReadingSets | MDB2GMS Example 3,4,5 - Reading Sets from Database using MDB2GMS |
MDBSr5 | Sequence of GAMS Models using the save/restart Facility |
moo01 | Solve scalable multi-objective knapsack model |
moo02 | Solve multi-objective power generation model |
moo03 | Solve Bensolvehedron model |
MultipleAsk | Multiple ask popups for entering various data types |
pickstock | Stock selection problem with MIRO |
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 |
rank01 | Rank a vector, and display the data in sorted order |
rank02 | Generate percentiles for a random vector |
rank03 | Use libinclude rank to report multisectoral Monte Carlo results |
rank04 | Repeated computation of percentiles within a loop |
rank05 | Percentile ranking of household expenditure data with heterogenous household size |
readdata | Read data from .inc, .xlsx, .accdb and .csv file |
ReadingSets | SQL2GMS Example 3,4,5 - Reading Sets from Database using SQL2GMS |
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 | MDB2GMS Example 2 - Reading a multi valued Table using separate Queries and Parameters |
SalesProfitDB2c | MDB2GMS Example 2 - Reading a multi valued Table using a Parameter with an extra Index Position |
SalesProfitDB2m | MDB2GMS Example 2 - Reading a multi valued Table (mute Version) |
SalesProfitDB3 | MDB2GMS Example 7 - Multi-Query Batch Example (Output: Several include Files) |
SalesProfitDB4 | MDB2GMS Example 7 - Multi-Query Batch Example (Output: A single GDX File) |
SalesProfitDB5 | SQL2GMS Example 2 - Reading a multi valued Table |
SalesProfitDB6 | SQL2GMS Example 7 - Multi-Query Batch Example (Output: Several include Files) |
SalesProfitDB7 | SQL2GMS Example 7 - Multi-Query Batch Example (Output: A single GDX File) |
Samurai | Solve a Samurai Sudoku in Excel, using the GDX DLL (vba API) and the GAMS executable |
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 using SQL2GMS at execution Time and displays it in GDXVIEWER |
SQL2GDX2 | Creates a GDX File using SQL2GMS at compile Time |
SQL2GMS | Runs SQL2GMS interactively |
SQLServer | Test timeouts against SQL Server |
SQLSr5 | Sequence of GAMS Models using the 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 |
transport | Classical transportation problem with MIRO |
transxls | Solve classical transportation problem in Excel, using vba API (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 |