[ Home | Support | Sales | Solvers | Documentation | Model Libraries | Search | Contact Us ]

GAMS Data Utilities

Alphabetical Index

	Model	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
	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
	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
	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
	GDXXRWExample11b	Reads a table from an MS Excel file and writes it to a GDX file
	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
	IndexMapping1	Index mapping in GAMS code
	IndexMapping2	Index mapping in MS Access
	IndexMapping3	Index mapping in GAMS code
	IndexMapping4	Index mapping in MS Access
	Loadpoint	Illustrates use of "execute_loadpoint" command
	MakeQL	Create Querry Library routines for extrinsic functions
	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
	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)
	TrnsxcllStarter	This Transportation Model text is implemented in conjuction with an Excel workbook
	tsvngdx	Integrate gdxdiff with TortoiseSVN
	Wiring	Use of wiring option to read multi-data column tables