TrnsxcllStarter.gms : Excel Spreadsheet in Charge of GAMS

Description

This Transportation Model text is implemented in conjuction with an Excel workbook

The worksheet writes the files included below named:
            supply.set
            demand.set
            supply.dat
            demand.dat
            distance.dat
            tran.dat
This code sends back solution in output.csv

Contributor: Bruce McCarl, March 2012


Category : GAMS Data Utilities library


Main file : TrnsxcllStarter.gms   includes :  TrnsxcllStarter.gms  Trnsxcll.xlsm  Trnsxcll.gms

$title  Trnsxcll: Excel Spreadsheet in Charge of GAMS
$onText

This Transportation Model text is implemented in conjuction with an Excel workbook

The worksheet writes the files included below named:
            supply.set
            demand.set
            supply.dat
            demand.dat
            distance.dat
            tran.dat
This code sends back solution in output.csv

Contributor: Bruce McCarl, March 2012

$offText

$callTool win32.msappavail Excel
$if errorlevel 1 $abort.noError "No Excel available"

$call "start Trnsxcll.xlsm"