In addition to the main Mapsheet the program contains
| • | An individual worksheet for each of the 5 states. |
| • | A worksheet for transportation cost data. |
| • | A sheet called Inputs that transfers data from other sheets so it can be read with Gdxxrw along as discussed below with an Index set of Gdxxrw instructions for reading. |
| • | A sheet called Results that is addressed by other sheets when they require solution information that is the place Gdxxrw transfers data into along with an Index set of Gdxxrw instructions for writing. |
These sheets are interconnected. For example pressing on the Mapsheet picture of the state of Washington brings up the sheet
that contains a mixture of solution information and raw data. The solution information in the red box and is transferred by formula from the results sheet (which contains information passed back from GAMS) as in cell F14 where the formula is
=Results!C2
The input data in the blue box once entered is transferred to the inputs sheet that in turn will be read by Gdxxrw by formula. For example in cell C21 of the input data sheet the formula
=wash_supply
appears where wash_supply is the range name for the cell F4 in the Washington sheet.