.. highlightlang:: us

.. index:: File=>More File Functions=>Load 3D Data Matrix

.. _filemore-file-functionsload-3d-data-matrix:
.. _file-load-3d-data-matrix:

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 :ref:`filemore-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 :file:`do_file.ic`.

.. seealso::
   :ref:`file`,
   :ref:`filemore-file-functions`,
   :ref:`filemore-file-functionsload-3d-data-matrix`,
   :ref:`auto_LoadMatrixDataset`

:sub:`id-1816419`