The XYZ Gridding (XYZ Log Gridding) Dialog Box

The XYZ Gridding and XYZ Log Gridding dialog box can be accessed by selecting Worksheet: Convert to Matrix: XYZ Gridding and Worksheet: Convert to Matrix: XYZ Log Gridding from the menu respectively. Both dialog boxes have two panels: the left panel provides parameter controls, while the right panel provides several feature preview tabs, and the settings are the same with each other.

1 Input Data
2 Data Examination
3 Gridding Method and Parameters
4 Advanced
5 Preview Plot Type
6 Output
7 Preview(Right) Panel:

Input Data

If you highlight a worksheet Z column before opening the XYZ Gridding or XYZ Log Gridding dialog box, Origin will set the range according to the selection.

Once the dialog is open, you can modify the range with the dialog controls in the Advanced branch.

Data Examination

Multiple Z values that correspond to the same XY data pairs are not allowed. These controls are used to determine (a) whether two XY pairs should be treated as the same and (b) how Z values associated with such duplicate pairs should be handled.

X Tolerance	Specify the tolerance used to detect duplicate X coordinate data and examine the regularity. For two adjacent points (x₁, y₁, z₁) and (x₂, y₂, z₂), if $\left \| \frac{x_1-x_2}{x_1+x_2} \right \| < Tolerance$ These two X values will be considered to be duplicates. The X Tolerance value should between (0, 1).
Y Tolerance	Specify the tolerance used to detect duplicate Y coordinate data and examine the regularity. For two adjacent points (x₁, y₁, z₁) and (x₂, y₂, z₂), if $\left \| \frac{y_1-y_2}{y_1+y_2} \right \| < Tolerance$ These two Y values will be considered to be duplicates. The Y Tolerance value should between (0, 1).
Replace Duplicates With	If two Z values correspond to the same XY data pairs (tolerances are considered), these Z values should be merged into a new value. Use this drop-down list to specify the new value. It could be Mean, Median, Maximum, Minimum or Sum.

X Tolerance

Specify the tolerance used to detect duplicate X coordinate data and examine the regularity. For two adjacent points (x₁, y₁, z₁) and (x₂, y₂, z₂), if

$\left | \frac{x_1-x_2}{x_1+x_2} \right | < Tolerance$

These two X values will be considered to be duplicates. The X Tolerance value should between (0, 1).

Y Tolerance

Specify the tolerance used to detect duplicate Y coordinate data and examine the regularity. For two adjacent points (x₁, y₁, z₁) and (x₂, y₂, z₂), if

$\left | \frac{y_1-y_2}{y_1+y_2} \right | < Tolerance$

These two Y values will be considered to be duplicates. The Y Tolerance value should between (0, 1).

Replace Duplicates With

If two Z values correspond to the same XY data pairs (tolerances are considered), these Z values should be merged into a new value. Use this drop-down list to specify the new value. It could be Mean, Median, Maximum, Minimum or Sum.

Gridding Method and Parameters

Select the gridding methods and configure the gridding parameters. Note that the controls vary by gridding method.

Gridding Method and Parameters	Specify the gridding method. Gridding of Regularly Spaced Data Sparse Renka Cline Shepard Thin Plate Spline Kriging Correlation Weighted Average
Columns	Specify the number of columns of the output matrix.
Rows	Specify the number of rows of the output matrix.
Quadratic Interpolant Locality Factor (q)	This is only available when Random (Shepard) is selected in the Gridding Method and Parameters drop-down list. Use the quadratic interpolant locality factor (q) to calculate the influence radius of the local approximate quadratic fitted function for each node when using the Shepard gridding method. By default, q = 18 . For best results, q should approximately equal 2w and w should be greater than 0. Modifying these factors may increase gridding accuracy, though computation time will increase significantly for large values (i.e. values that decrease the locality of the method.)
Weight Function Locality Factor (w)	This is only available when Random (Shepard) is selected in the Gridding Method and Parameters drop-down list. Use it to specify the weight function locality factor w, which is used to calculate the weighting radius for each node. By default, w = 9. For best results, q should approximately equal 2w and w should be greater than 0. Modifying these factors may increase gridding accuracy, though computation time will increase significantly for large values (i.e. values that decrease the locality of the method.)
Smoothing	This is only available when either Thin Plate Spline or Kriging Correlation is selected in the Gridding Method and Parameters drop-down list. This non-negative value specifies the extent to which the gridding surface will depart from the input data points. If the smoothing factor is zero, no smoothing is performed and the interpolated surface will pass though all data points. A positive smoothing factor will smooth the surface. However, a factor that is too large will obscure the original data.
Extrapolation	This is only available when Thin Plate Spline is selected in the Gridding Method and Parameters drop-down list. Please see the algorithm description for details.
Search Radius	This is only available when either Weighted Average or Kriging Correlation is selected in the Gridding Method and Parameters drop-down list. Please see the algorithm description for details.
Minimum Points	This is only available when either Kriging Correlation is selected in the Gridding Method and Parameters drop-down list. Please see the algorithm description for details.

Advanced

Advanced options for gridding ranges and matrix coordinates.

Range Restriction	Specify the boundary of the input data range. By default, all data points are included. In order to exclude bad or unwanted data points, you can restrict the input data range by editing the minimum and maximum XY coordinates (Note: You can see the effects on the XY Range tab of the preview panel). X Minimum the minimum X value of the output matrix. X Maximum the maximum X value of the output matrix. Y Minimum the minimum Y value of the output matrix. Y Maximum the maximum Y value of the output matrix.

Range Restriction

Specify the boundary of the input data range. By default, all data points are included. In order to exclude bad or unwanted data points, you can restrict the input data range by editing the minimum and maximum XY coordinates (Note: You can see the effects on the XY Range tab of the preview panel).

X Minimum

the minimum X value of the output matrix.

X Maximum

the maximum X value of the output matrix.

Y Minimum

the minimum Y value of the output matrix.

Y Maximum

the maximum Y value of the output matrix.

Preview Plot Type

Control the plot type depicted on the Preview Result tab:

3D Color Map Surface

Contour - Color Fill

3D Wire Frame

Output

Specify whether and how to output the gridding data:

Output Matrix

Select to output gridding data as a matrix.

Output Virtual Matrix

Select to output gridding data as a worksheet arranged as a virtual matrix.

Preview(Right) Panel:

This panel provides various preview options.

XY Range	The plot on the XY Range tab provides a 2D view of your XY coordinate data.
X/Y Steps	The distribution of steps in X or Y coordinates. Because the rows and columns of gridding are associated with X step and Y step, the value will change synchronously when you edit one of them.
Preview Result	Preview the gridding result. The preview plot type is determined by the Preview Plot Type list selection. Note that the display of the preview graph may be slow with very large data sets.