Make Tables

Results of any calculations must be stored in a table. Some tables are built-in tables and some tables are created when data are imported.  It may be necessary to create a new table internally to mXrap. Such new tables can be created using the Make Table tool.

Make Table can create tables with columns of type, Numbers, ID's, Dates and Points. An example of this is Sensitivity Analysis with the results mapped to a table of points (i.e. dense grid).

Make table parameters

All the inputs can be linked to variables that can be manipulated afterwards or typed in.

Maximum number of rows

The Maximum number of rows allowed must also be defined and is dependent on computational capabilities.

Reference point

The reference point defines a value that must occur in a non-truncated series of the values.

Step size

Define the difference between consecutive values in the table.

Minimum/Maximum

The minimum and maximum values defines the smallest and largest values that must be included in the series.

Examples of the values table resulting from different settings

Reference Point

0

0.1

0.5

9.4

Step size

1

1

2

2

Minimum

-3

-3

-3

-5.6

Maximum

5

5

5

6.6

1

-3

-3.9

-3.5

-6.6

2

-2

-2.9

-1.5

-4.6

3

-1

-1.9

0.5

-2.6

4

0

-0.9

2.5

-0.6

5

1

0.1

4.5

1.4

6

2

1.1

6.5

3.4

7

3

2.1


5.4

8

4

3.1


7.4

9

5

4.1



10


5.1



11





Table Types

Number Table

Creating a table of numbers is similar to "dragging down" numbers to form a sequence in Excel.

ID Table

Creating a table of ID's follows the same constraints as creating a table of numbers and is conducted in a similar manner.

Dates Table

A single unit of time in mXrap is defined as a millisecond and, therefore, it is important to select a relevant Step size unit. Alternatively, "Extra Special Units" can be defined as Calender Months or Calendar Years.

Creating a table of dates. Note the selection of units of time for the step size.

Points Table

Points are defined in a similar fashion to numbers in that there is a reference point, step size, and min/max values for each (x,y,z)coordinate. This defines a volume, plane, line or single point that has a directional density corresponding to the step size.

Creating a table of points.


Created points corresponding to the values and table shown in Figure 3 above.

Created with the Personal Edition of HelpNDoc: Write eBooks for the Kindle