2D Interpolate to Find z at Given (x,y)

Owned by Meili Yang (Unlicensed)
Last updated: Nov 07, 2017 by Wall-E
1 min read

(ORG-5160)

9.1 adds a new x function interp2 to interpolate a group of existing xyz data to find z value for given (x,y), by 8 alternative methods: Nearest, Random Kriging, Random Renka Cline, Random Shepard, Random TPS, Spline, Triangle and Weight Average. 

Sample OPJ to download to try: 2D interpolate.opj

 

How to interpolate z from xy using interp2 x function:

  1. In script window, run interp2 -d; to open interpolation dialog;
  2. Pick data (x,y) from worksheet as XY Values To Interpolate, and a serial of xyz data as Input for interpolation; 
  3. Select a Method from drop down menu;
  4. Assign destination columns as Results of Interpolation.