Re: $$Excel-Macros$$ Re: Two-dimensional interpolation

2014-03-07 Thread Gerrit Grundling
totallyp...@gmail.com javascript: *To:* excel-...@googlegroups.com javascript: *Sent:* Thursday, March 6, 2014 2:32 AM *Subject:* $$Excel-Macros$$ Re: Two-dimensional interpolation Slowly but surely I'm getting there. Thanks for the help so far. I am including an Excel file

Re: $$Excel-Macros$$ Re: Two-dimensional interpolation

2014-03-06 Thread Paul Schreiner
AM Subject: $$Excel-Macros$$ Re: Two-dimensional interpolation Slowly but surely I'm getting there. Thanks for the help so far. I am including an Excel file with the airfoil data, function LinInterpolate and functions Floor and Ceiling. None of these are my own, as I found them

$$Excel-Macros$$ Re: Two-dimensional interpolation

2014-03-05 Thread Gerrit Grundling
Slowly but surely I'm getting there. Thanks for the help so far. I am including an Excel file with the airfoil data, function LinInterpolate and functions Floor and Ceiling. None of these are my own, as I found them on the interweb. I have commented out my attempt at automating the linear

$$Excel-Macros$$ Re: Two-dimensional interpolation

2014-03-03 Thread Rajan Verma
Hi make your array as double data type not Long Thanks Rajan. n Wednesday, 26 February 2014 07:07:45 UTC-7, Gerrit Grundling wrote: Greetings, all I have attached some aerofoil data for a Clark Y foil. This data is also available in my spread sheet. The Reynolds number is given

$$Excel-Macros$$ Re: Two-dimensional interpolation

2014-02-27 Thread Gerrit Grundling
Please help: What is wrong with the following? ReDim ClArray(5) As Long ReDim ReArray(5) As Long ClArray(1) = LinInterpolate(ALPHEFD(J9), Sheets(AIRFOIL_DATA).Range( B3:B44), Sheets(AIRFOIL_DATA).Range(C3:C44)) ClArray(2) = LinInterpolate(ALPHEFD(J9), Sheets(AIRFOIL_DATA).Range( F3:F42),

Re: $$Excel-Macros$$ Re: Two-dimensional interpolation

2014-02-27 Thread Gerrit Grundling
On Thursday, 27 February 2014 16:33:41 UTC+2, Paul Schreiner wrote: What does your function LinInterpolate() look like? Evidendly, you have a function called: LinInterpolate and it looks like it must accept (3) arguements, so it may look like: Function LinIterpolate( Var1, Var2,