Wks-Mat-Conversion-Expand
Some screen editors used to create ASCII files may have an upper limit for the number of characters allowed on a single line. This upper limit may even be less than the number of columns needed in the matrix. To compensate for this, one row of matrix data can be stored in multiple rows of an ASCII file.
Displaying this type of ASCII file in a matrix requires two steps. The first step creates a new worksheet and imports the ASCII file into it. The second step "expands" the worksheet data into a matrix.
Controls recalculation of results
For more information, see: Recalculating Analysis Results
The data input range.
For help with range controls, see: Specifying Your Input Data
Specifies the number of rows/columns comprising one matrix row/column.
Expanding order Option list:
Specify three columns for the output XYZ range. X, Y and Z data can be output to different sheets and books.
For help with the range controls, see: Output Results
Origin copies your worksheet data from the number of ASCII file rows into the first row of the matrix, repeating this procedure until all ASCII file rows have been converted. For example, if a matrix of 24 columns is stored in an ASCII file that is limited to 8 columns of data, then each row of matrix data (24 different values) would require 3 rows in the ASCII file. In this case, you would type 3 in the Expand for Every Row dialog box. After clicking OK, a new matrix is created in which 3 rows of ASCII file data were used to construct each row of the matrix. Such as: