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
.
See also
File, File=>More File Functions, File=>More File Functions=>Load 3D Data Matrix, auto_LoadMatrixDataset
id-1816419