Tools for Systematic Sensitivity Analysis with GAMS and Excel

Three new tools for stochastic programming (probtree.gms, treeplot.gms and fanplot.gms) will be posted shortly. Here is a talk which introduces how these work.

xlsnz: An Automation Tool for Extracting Numeric Nonzeros from Excel Workbooks

gdxxls: An Automation Tool for Generating Formatted Excel Tables from GAMS GDX Data Files

runjobs: An XP Automation Tool for Parallel Processing of GAMS Jobs

Windows menu selection at execution time from a GAMS program, both effective and compact. This utility is less than 4K in two flat files.

A little GAMS utility for passing data to XLS files in PivotTable-friendly format.

GAMS utility for efficient domain extraction.

An Automation Tool for Formatting Excel Tables

A GAMS utility for generating Excel Charts

A utility routine for assigning households to deciles with (roughly) equal numbers of individuals

A GAMS Interface to Mark Horridge's SHADEMAP

GDX2DAT and GDXF90: Tools for Reading and Writing GDX Files.

A GAMS Utility for Mapping Tuples to Linear Sets

Translation Tools for GDX and HAR Files.

A Utility for Ranking One-Dimensional Numeric Data.

GAMSsm: A Scenario Manager.

Libinclude files for GAMS-readable data file management.

GAMS2CSV: A LIBINCLUDE Tool for Writing Comma-Delimited Data Files.

XLWrite: A Console Application for Creating Excel Workbooks from CSV Files.

Workbook data transfer programs for use with GAMS and Excel.

Libinclude files for calling GNUPLOT from GAMS.

A GAMS interface for MATLAB (by Michael Ferris)

Libinclude files for report writing .

A preprocessor for function definitions in GAMS.

Libinclude files for reading and writing GEMPACK header array files.

Bruce McCarl: "As suspected GAMS did not have anything on set global etc that I could extract from Alex. Thus I put togeather these notes based on looking at your stuff, talking to Alex and just guessing at what some things did. I am committed to use these as is in class but if you have any comments or suggestions where I should add, elaborate or correct let me know. Otherwise use for your purposes when people ask questions."

Recommended Text Editors for Programming in GAMS

• EMACS command-based editors:
  • Epsilon (not free, but great; very compact, extensible with a C-like language.)

  • GNU NTEmacs (free, fully-featured. EMACS now has a GAMS mode provided by Shiro Takedo).

  • NotGNU (free, reliable, small, but non-extensible.)

  • JED (free, under development but reasonably stable, easily extensible using Slang)

• Other editors:
  • MetaPAD (free, small)

  • OxEdit+GAMS : Another GAMS IDE Philip Viton's programming environment for GAMS. (free, lots of people like it)

  • Crimson is a pretty good editor with two limitations: line length max of 2048 and line max of 65536. Otherwise, it's a powerful, extensible tool.

  • TextPad is not freeware but it's not expensive, and there is a syntax file for GAMS. The really great feature of Textpad is that you can manipulate columns (not just rows).

GAMS Amusements

Notes on Creating PDF Slides with Handouts

1. Use the following document header:

   
   \documentclass[landscape]{slides}
   \usepackage[dvips]{graphicx}
   
   \special{papersize=11in,8.5in}
   
   

2. Process with LaTeX as usual:

   
   call miktex
   latex %1
   dvips %1
   
   

3. Use the PSNUP utility to generate notes with two slides per page:

   
   psnup -2 -r %1.ps %1_h.ps
   
   

4. Call Distiller to generate the PDF files. The trick here is to pass the full path name to the program using "%~f":

   
   call "c:\Program Files\Adobe\Acrobat 5.0\Distillr\acrodist.exe" "%~f1.ps" 
   call "c:\Program Files\Adobe\Acrobat 5.0\Distillr\acrodist.exe" "%~f1_h.ps"