The coefficients are stored in a table starting
in column U and continuing until column AA. The coefficient
list for the example is below. Each coefficient occupies a
row of the list. Columns V and W refer to the coefficient matrix
of the tableau representation. Column V holds the index of
a variable (column), and column W holds the index of a constraint
(row). Together they define a cell of the coefficient matrix.
The first column entry (row 13) indicates that the coefficient
for this row is the coefficient for variable 1 (X_01) in constraint
1 (A_1). The names of the variable and constraint are concatenated
in column X (X_01-A_1) to help identify the combination. The
value (10) of the coefficient is in column Y. This particular
model has 50 constraint coefficients, so the list has 50 entries.
Reading down the table, you can see that the first column of
the coefficient matrix is the first five entries in the table.
During the solution process this list is always sorted with
column V the primary sorting index and column W the secondary
The last two columns, Z and AA,
are computed with formulas. Column Z uses an INDEX function
to recover the value of the variable for each row of the table.
Since the first five entries are for X_01, column Z reports
0 for the value of that variable. This is obtained from column
D of the variable table shown at the top of this page. Column
AA holds the product of column Y and column Z. For each row,
this is the contribution of the term to the constraint equation.
The constraint value shown as column Q in the constraint display
is the sum of all cells with a specified constraint index.
For example the value of P13 is the sum of cells AA13, AA18,
AA23, and so on through the coefficient list. Column Q uses
the SUMIF Excel function to compute the constraint values.