The inputs sheet is as follows
where
| • | The material in the red box will be read by Gdxxrw |
| • | The worksheet will be saved so that the material read by Gdxxrw is current |
| • | The material in the blue box is the set of commands telling Gdxxrw what types of items, item names, and ranges to read as covered in the Links to Other Programs Including Spreadsheets chapter using the index option where the input commands can be imbedded in a spreadsheet. This will be addressed in the excelincharge.gms file using the command |
$Call 'Gdxxrw Excelincharge.XLS skipempty=0 trace=2 index=inputs!g10'
In addition all of the numbers in the red box are the results of formulas that copy the numbers in the state and trandata sheets.