interpolation ( y1 ; y2 ; y3 ; x1 ; x2 ; x3 ; x1y1 ; x2y1 ; x1y2 ; x2y2 ; rnd )

Interpolates single lines and cross table

Average rating: 3.0 (1 vote) Log in to vote

Eric van Oosterom - Show more from this author
HarperMac Marine Survey

Sample input:

interpolation(0;5;4;125;150;137,360;0,55;0,48;1,69;1,45;3

Sample output:

1,360

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*
* This is a function for cross table interpolation.
* created by Eric van Oosterom, HarperMac Marine Survey
*
* Parameters: y1, y2, y3, x1, x2, x3, x1y1, x2y1, x1y2, x2y2, rnd
* rnd is the decimal rounding
*
* Agruements as used in the a table as follows 
*
*		Table				Table
*		x1 		x3	 	x2  
* Table	y1  	x1y1		y1x3		x2y1
*	y3		        y3x3
* Table	y2 	x1y2	        y2x3		x2y2
*
* arguement x3 = value between x1 and x2 where to find y3x3
* arguement y3 = value between y1 and y2 where to find y3x3
*
* Interpolates first horizontal towards x3 then vertical towards y3
*
* Should work with only 5 agruements as well, if x1, x2, x3, x1y1 and x2y1 are used
*
* if parameters not used set them as ""
*
*/

Let ( [	~x1y1 = Ballast_Decutable::Tablelowvolumetrim1_init ;
		~x2y1 = Ballast_Decutable::Tablelowvolumetrim2_init ;
		~x1y2 = Ballast_Decutable::Tablehighvolumetrim1_init ;
		~x2y2 = Ballast_Decutable::Tablehighvolumetrim2_init ;
		~x1 = Ballast_Decutable::Table trim1 init ;
		~x2 = Ballast_Decutable::Table trim2 init ;
		~y1 = Ballast_Decutable::Table_lowsound_init ;
		~y2 = Ballast_Decutable::Table_highsound_init ;
		~y3 = Ballast_Decutable::Sounding ;
		~x3 = Draft_Survey::Truetrim1 ;
		~dt = ~x2 - ~x1 ;
		~ds = ~y2 - ~y1 ;
		~y1x3 = ~x1y1 + ( ( ~x2y1 - ~x1y1 ) / ~dt ) * ( ~x3 - ~x1) ;
		~y2x3 = ~x1y2 + ( ( ~x2y2 - ~x1y2 ) / ~dt ) * ( ~x3 - ~x1) ; 
		~y3x3 = ~y1x3 + ( ( ~y2x3 - ~y1x3 ) / ~ds ) * ( ~y3 - ~y1);
		~rnd = 3		
] ; 

Round ( Case (  	IsEmpty ( ~x2y1 ) ; ~x1y1 ; 
			IsEmpty ( ~x1y2 ) ; ~y1x3 ;
			~y3x3 ) 
	; ~rnd)

)

Works good for cross interpolation in tables and linear interpolation.

Needed a interpolation function that could make a cross interpolation because in my line of work we work with linear and cross table interpolation, could only find other types of interpolation so created this function.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

interpolation ( y1 ; y2 ; y3 ; x1 ; x2 ; x3 ; x1y1 ; x2y1 ; x1y2 ; x2y2 ; rnd )

Comments

Support this website.

Support this website.