Available software (updated 28 November 2011):
Please click on the software you want to know more about.
GAMS and Data software:
ASCII and CSV tools:
GDX tools:
Other Tools:
ElementTree.exe
This program makes it possible to view/edit the content of an Access database (any version). When the database is password protected you are asked for the password.
A tool to convert ASCII files to other ASCII files, i.e. it is used to convert e.g. TAB separated files into CSV files. This tool has less functionality then the ASCII tool within MetaBase.exe
Tool to convert DFT and DFZ files (DFT is old Eurostat file type, DFZ is the zipped version of a DFT) into CSV files that can be used in many other programs.
With this tools you can convert CSV files (even UNIX files or Unicode files) and use the GDX tab to create from a CSV file a GDX file.
This program displays the contents of GDX files and uses the meta-information stored in .GREF files. See the documentation about Data Explorer (DataExplorer.doc).
Open a GDX file, select a parameter and make a selection which elements you want to view (i.e. a data filtering system). Can also be used in combination with SQL2GAMS.
Elementtree.exe
This program is used to create classification trees for GAMS, i.e. see Using classifications in
GAMS.doc)
With this program you can browse through all your folders and see the
content of your GDX files and even apply filters to your data.
DEM communicates with web-GSE and web-MetaBase, i.e it downloads GDX and other files from the web and start the DataExplorer.
Convert Eurostat TSV files (special Tab separated files from Eurostat) into clean CSV files.
Show information over a GDX file. You can also use this tool to convert between different GDX formats. See GDXtools.doc
The GAMS GDXmerge doesn’t really merge two GDX files, but when a parameter is defined in both GDX files, the parameter will get an additional set (with as elements the 2 file names). A real merging, according to us, would mean that you take the values of the first GDX file and that add the values of the second GDX files, this means adding new values and overwriting some values of the first file. See GDXtools.doc
Gams Simulation Environment (see GSE documentation: gse.doc). Create a user interface on any GAMS model. Store versions, run scenarios and compare results. You could also try our webversion of GSE: http://www3.lei.wur.nl/gse/
Standalone tool to make GIS plots. This tool can load data from MS-Access as well as from GDX or CSV files (see DataExplorer.doc).
GAMS editor with a bulk of interesting features, see the documentation: gtree.doc.
Single user interface for all kind of different data suppliers. See MetaBase documentation: metabase.doc and “new in MetaBase 2”. If you have an interest in this product please contact us: LEI.software@wur.nl. The software and data is too big to put on the internet, you could try http://www3.lei.wur.nl/metabase/ our web version of MetaBase.
Install the GAMS tools, create shortcuts, look at the documentation, and add file association.
Make any database connection, use any table or query and create a GDX file out of the results (see GDXtools.doc).
Use sample data as well as population data to estimate small area statistics (see: stars.pdf).
The ODBC/Excel/Access to GDX tool (i.e. xxx2GDX.exe) makes it possible to connect to an Excel spreadsheet, any ODBC connection, or to an Access database and convert it into a GDX file. See GDXtools.doc
