The data and results for the variables
appears at the top of the worksheet in a row format. We
call it the row format because each row provides a vector of
values of a particular type. For example row 10 holds the
names of the variables and row 11 holds the values of the variables.
The solution shown is the optimal primal solution.
The variables section provides all the data for each variable
except the constraint coefficients. A variable has all its data
in a column of the worksheet. For example column M holds the information
for the first variable. Row 11 is outlined in green to indicate
that the algorithms of the add-in fill this array. The
names in row 10 and the data in rows 12 through 15 are filled
by the user to represent the situation under consideration.
The Type data has two recognized values, Real and Integer.
When all types are Real, the model is a linear program.
If all the types are Integer, the model is an integer
program. Problems with some real and some integer types are often
called mixed linear integer programs. Only the first letter is
used to identify the type, so i and r can replace integer and real.