Define the Variables
The text entry field labeled Vector Location holds the Excel cell address where the variable values will be stored. In the case above the cursor was in the upper left corner of the worksheet, so the location shows the address of the cell at the upper left corner, $A$1. This field is locked so it cannot be changed. If the location is wrong, simply click on the Cancel button. The cursor can then be placed at the desired cell before calling the dialog.
The Vector Name refers to the variable in the nonlinear programming formulation. It should be a simple letter or small number of letters. The name cannot resemble the address of a cell such as X1. Excel will not allow this and an error will occur. The program has built-in names: X, Y, Z, P, S, T, U, V and W (R is not allowed). These will be automatically presented when the dialog is called. When they are exhausted the letters are doubled: XX, YY etc. The Vector Name field can be changed by the student to any name that Excel will accept.
The Number of Elements field holds the number of components of the decision vector. The number can range from 1 to 9.
Research Models and Methods
by Paul A. Jensen and Jon Bard, University of Texas, Copyright by the Authors