M1D tables

To save the data as an M1D table, choose the M1D option from the Table type drop-down list.

Figure 22: Selecting M1D table type

An M1D table allows you to define a 3D map from multiple XY curves. Each curve can have a different dimension. The result is a mesh built from cross-sectional slices whose points are not necessarily uniformly distributed.

A slice is referenced by one value and defined by (x, y) pairs of values:

• The values that reference the slices form the vector X2.

• The values that reference the (x, y) pairs form the vectors X1 and Y.

Cells selection

The selection widgets are updated to allow you to define the multiple 1D tables (also named M1D Slices):

Figure 23: Selection of data cells

An M1D table is defined by 3 components:

• 2 ordinate axes (labeled X1 and X2 in the spreadsheet)

• 1 abscissa axis (labeled Y in the spreadsheet)

When the M1D table type is selected, the following conditions apply:

• For slices that reference cell selection, you can select as many cells as you require for the number of slices you need (CTRL + left-click), and then click the selection update button to set the selected cells in the field.

• To make a selection of data cells, hold down the left mouse button while making your selection to define the (x,y) pairs, and then use CTRL to select multiple slices. Click the selection update button to set the selected cells in the field.

• Slices are separated with the "/" (forward slash) symbol.

Example of M1D table selection

Here is an example of a selection in the spreadsheet and the corresponding formula in the selection fields:

Automatic slice detection

There are 3 detection methods available. Given that an M1D table can contain many slices, the user may have to define many selections, which can become very tedious. For this reason, it is possible to let the automatic slice detection utility detect those slices automatically based on predefined rules and values. The detection is done on a columned selection. It is possible to set the cells on which the detection is done using the Detection range field.

This means the X2 values have to be in a single column, as must the X1 values and the Y values. The order of the selection is important. The first column is for the slice referencing cell (X2) detection, the second one for the values of X1, and the third one for the values of Y.

1. Detect slices by slice length: each slice has the same predefined length. Empty rows are ignored, so a slice may span over more table rows than specified. Here is an example of generating the selections for slices that contain 5 values each.

After pressing the Detect button, the resulting selections are:

2. Generate slices by detecting the range of the X1-axis values: a new slice is started each time a value on the X1-axis is lower than the one before it by a specific amount. In the example below, we want to have a new slice each time a value is lower than the previous one by 0.05.

After pressing the Detect button, these are the detected selections:

3. Generate slices by detecting the step of the X2-axis discretization: a new slice is created for each X2-axis value that is different (higher or lower) than the previous one by a specific amount. This method works only for tables with at least 3 columns (that contain at least a number). In the example below, new slices are defined whenever the X2 value differs by more than 8 from the previous value.

After pressing the Detect button, these are the detected selections: