Cubic spline interpolator function

G'day!
Has anyone written a cubic spline interpolator for Filemaker?
Regards,
Sargon

Sargon Engineering Pty Ltd
No.25 Lincoln House
4 Ventnor Avenue
West Perth
Western Australia 6005
Phone: +61 8 9481-5878
Mobile:    0408905402

In article <znIBj.24691$421.18640@news-server.bigpond.net.au>,
"Sargon
Lovkis" <lovkis@bigpond.net.au> wrote:

> G'day!
> Has anyone written a cubic spline interpolator for Filemaker?
> Regards,
> Sargon

I'm not sure it's very likely that anyone has - a quick Goole search
didn't find anything. FileMaker isn't really designed to be a
number-cruncher, so such things are usually better done in Excel or a
custom application.

The same Google search turned up a non-FileMaker example source code
which shows a fairly simple mathematical method ... although I'm not
sure how well this example code handles more complex formulas. It could
be done in FileMaker, but it could easily get quite complicated to
set-up (depending on exactly how it needed to be implemented, number of
known data points to deal with, etc.).

I also don't know how good the charting abilities of newer versions of
FileMaker are or if you need charts, but it may not be up to the task.

Helpful Harry                   

Thanks Helpful Harry! I wanted the cubic spline interpolater for a cost 
estimating database. The interpolator was for interpolating tables of 
capacity vs cost tables for various equipment items. It gets you out of 
repeatedly having to do curve fits. It's a pity there isn't a cubic spline 
interpolator (or any other non-linear interpolator) available for Filemaker. 
I could revert back to Access I guess. There are VBA cubic spline 
interpolators available eg the free one (which works real well) in XNumbers 
on the Foxes website digilander.libero.it/foxes.
"Helpful Harry" <helpful_harry@nom.de.plume.com> wrote in
message 
news:140320081814391662%helpful_harry@nom.de.plume.com...
> In article <znIBj.24691$421.18640@news-server.bigpond.net.au>,
"Sargon
> Lovkis" <lovkis@bigpond.net.au> wrote:
>
>> G'day!
>> Has anyone written a cubic spline interpolator for Filemaker?
>> Regards,
>> Sargon
>
> I'm not sure it's very likely that anyone has - a quick Goole search
> didn't find anything. FileMaker isn't really designed to be a
> number-cruncher, so such things are usually better done in Excel or a
> custom application.
>
> The same Google search turned up a non-FileMaker example source code
> which shows a fairly simple mathematical method ... although I'm not
> sure how well this example code handles more complex formulas. It could
> be done in FileMaker, but it could easily get quite complicated to
> set-up (depending on exactly how it needed to be implemented, number of
> known data points to deal with, etc.).
>
> I also don't know how good the charting abilities of newer versions of
> FileMaker are or if you need charts, but it may not be up to the task.
>
> Helpful Harry
> Hopefully helping harassed humans happily handle handiwork hardships  ;o) 

In article <PGtDj.26769$421.21435@news-server.bigpond.net.au>,
"Michelle Lovkis" <lovkis@bigpond.net.au> wrote:

> Thanks Helpful Harry! I wanted the cubic spline interpolater for a cost 
> estimating database. The interpolator was for interpolating tables of 
> capacity vs cost tables for various equipment items. It gets you out of 
> repeatedly having to do curve fits. It's a pity there isn't a cubic spline

> interpolator (or any other non-linear interpolator) available for
Filemaker. 
> I could revert back to Access I guess. There are VBA cubic spline 
> interpolators available eg the free one (which works real well) in XNumbers

> on the Foxes website digilander.libero.it/foxes.

It is possible to make one in FileMaker, but would depend on how it
needs to be implemented as to how complicated it gets to set up.

Never go back to the dreaded Access.   ;o)

Helpful Harry