14.3 Expanding Columns During Conversion


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.

  • To expand while converting the matrix:
  1. Select Worksheet:Convert To Matrix:Expand to open the Wexpand2m dialog.
  2. Specify the number of ASCII file rows comprising one matrix row.
  3. Click OK.

Dialog Options

Recalculate

Controls recalculation of results

  • None
  • Auto
  • Manual

For more information, see: Recalculating Analysis Results

Input Worksheet

The data input range.

For help with range controls, see: Specifying Your Input Data

Expand for Every Row/Col

Specifies the number of rows/columns comprising one matrix row/column.

Orientation

Expanding order
Option list:

  • Row:Row'
Expand in row
  • Col:Column
Expand in column
Output

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:

  • Expand convert by 2 rows:
Expanding Columns During Conversion 01.png
  • Expand convert by 2 columns:
Expanding Columns During Conversion 02.png