Table(

[Robert Ameeti]

At 4:06 PM -0600, 2/20/08, Vic DiFranco wrote:

Yep. This has been my plan.

I've just been thinking that perhaps I'd overlooked some advanced 
method to return the 'next' values rather than the 'previous' values 
in the table( function.

And then too, it would be cool to be able to throw 3 variables at a 
interpolate( function so as to minimize that part as well.


>	The "Table" that is used for the lookup was a separate 
>database. When I constructed the table( function in my procedure, I 
>used the keyfield as the keyfield, (so in your original example, 
>keyfield = 95), and the lookup field to also be the keyfield (so it 
>returns the value = 50).
>
>
>	I then switched to the Table database, with the window 
>command, and did a "Find" in that database for the value of 50. I 
>extracted the required keyfield data, did a downrecord, and 
>extracted the next keyfield and datafield records. All those data 
>points, 4 in all, were placed in variables, to make the 
>extrapolation calculation easier. It worked quite well.
>
>
>	The Table database was open as a SECRET database, so you 
>didn't actually see anything happening as the macro was running. 
>That wouldn't be necessary for this to work, but it does avoid the 
>flashing as different databases are activated. In my case, I closed 
>the SECRET Table database as soon as the requisite data were 
>obtained.
>
>
>	Regards,
>
>	Vic DiFranco
>
>
>On Feb 20, 2008, at 2:00 PM, 
><mailto:qna-request at provue.com>qna-request at provue.com wrote:
>
>>A sampling of the data is:
>>
>>
>>dataField	keyField
>>
>>5	8.432286736
>>
>>10	8.842430608
>>
>>25	9.493228952
>>
>>50	10.151682752
>>
>>75	10.91032724
>>
>>90	11.541455432
>>
>>95	11.994954856
>>
>>
>>The keyField data is obtained by this formula:
>>
>>
>>keyField = A + B*E + C*E^2 + D*E^3
>>
>>
>>where A, B, C, & D are obtained by a table of coefficients that are 
>>used in the above 3rd order polynomial spline equation which 
>>defines the percentile curves representing the statistical analysis 
>>of a group of persons of identical age & sex. E is a fixed constant 
>>for the above equation
>>
>>
>>I need to know the appropriate keyField values for sequential 
>>dataField values with increments of 1 between 5 & 95.
>>
>>
>>Any ideas would be much appreciated.

-- 

<><><><><><><><><><><><><><><><><><>
Robert Ameeti

The man who does not read books has no advantage over the man that can not read them.
<><><><><><><><><><><><><><><><><><>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://provue.com/pipermail/qna/attachments/20080220/740d040f/attachment.html