File=>More File Functions=>Load 3D Data MatrixΒΆ

Loads a data matrix from an Excel or ASCII file.

The matrix must adhere to the following format:

Equidistant Matrices

The number of data columns and rows must be between 5 and 100. All elements of the matrix must be valid numbers:

z11    z12....z1j
z21    z22    z2j
...    ...    ...
zi1    zi2....zij

Non Equidistant Matrices

Distances between the columns (x-values) for non-equidistant matrices are specified in the first row, and the distances between the rows (y-values) are specified in the first column. The upper left field (1. row, 1. column) must be left blank or have the value 999.999. All other matrix elements must be valid numbers.

Form1:

      x1    x2    xj
y1   z11   z12   z1j
y2   z21   z22   z2j

yi   zi1   zi2   zij

Form2:

999.999   x1    x2    xj
y1       z11   z12   z1j
y2       z21   z22   z2j

yi       zi1   zi2   zij

Incomplete Matrix

For this type of matrix the first row must contain the x-coordinates and the first column the y-coordinates. The upper left cell (Row 1 / Col 1) must be empty or contain the number 999.999. The matrix may contain invalid elements, for example: empty elements or text elements ie: the text Nan. The invalid elements will be replaced with valid values by interpolation or extrapolation. The data full will be calculated from the valid elements.

     x1    x2 ..   xj
y1  z11   z12 ..  z1j
y2  z21   Nan ..  z2j
..  ..    ..  ..   ..
yi  NAN   zi2 ..  Nan

To import a matrix, select File=>More File Functions. Then choose the function Load 3D Data Matrix. The matrix will be loaded and displayed in the selected diagram. If no diagram is selected, a document with a new diagram will be created.

These functions are written in UniScript. The source code can be found in the file do_file.ic.

id-1816419