|
|
|
Author |
Message |
wp78
|
Posted: Sat Apr 02 20:07:14 CST 2005 |
Top |
Excel Programming >> Cubic splines
Sorry all,
A dumb question.
I was searching the Excel groups for a Cubic spline smoothing.
I find numerous messages refering to code entered by David Braden.
In some I find a link:
Most (all?) look like this:
http://www.hide-link.com/ %40rochester.rr.com
But this leads nowhere.
Can somebody help me locating this code?
I really tried myself.
TIA
Eric
Excel355
|
|
|
|
|
Debra
|
Posted: Sat Apr 02 20:07:14 CST 2005 |
Top |
|
|
|
Eric
|
Posted: Sat Apr 02 21:40:30 CST 2005 |
Top |
Excel Programming >> Cubic splines
Hello Debra,
A million thanks .... that one works.
I tried again in Ron de Bruyn's Google search and via Google.com by
literally copying text from the David Braden post as text and they couldn't
find it.
You helped me a lot.
And thanks to David to.
Kind regards
Eric
PS: maybe an idea for David to reenter that post that google.com can find it
too. (it's often referred to).
> Try this link instead:
>
>
http://groups.google.ca/groups?selm=3A11AD33.B1438202%40rochester.rr.com
>
> > Sorry all,
> >
> > A dumb question.
> > I was searching the Excel groups for a Cubic spline smoothing.
> >
> > I find numerous messages refering to code entered by David Braden.
> > In some I find a link:
> >
> > Most (all?) look like this:
> >
http://groups.google.com/groups?selm=3A11AD33.B1438202%40rochester.rr.com
> >
> > But this leads nowhere.
> >
> > Can somebody help me locating this code?
> > I really tried myself.
> >
> > TIA
> > Eric
> >
> >
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
|
|
|
|
|
Tom
|
Posted: Sun Apr 03 14:20:37 CDT 2005 |
Top |
Excel Programming >> Cubic splines
I don't think David has posted in at least 6 months or more, so his
interests must lie elsewhere, at least for the present.
But you have been a bit of a stranger as well.
--
Regards,
Tom Ogilvy
> Hello Debra,
>
> A million thanks .... that one works.
>
> I tried again in Ron de Bruyn's Google search and via Google.com by
> literally copying text from the David Braden post as text and they
couldn't
> find it.
>
> You helped me a lot.
> And thanks to David to.
>
> Kind regards
> Eric
>
> PS: maybe an idea for David to reenter that post that google.com can find
it
> too. (it's often referred to).
>
>
>
> > Try this link instead:
> >
> >
> http://groups.google.ca/groups?selm=3A11AD33.B1438202%40rochester.rr.com
> >
> > > Sorry all,
> > >
> > > A dumb question.
> > > I was searching the Excel groups for a Cubic spline smoothing.
> > >
> > > I find numerous messages refering to code entered by David Braden.
> > > In some I find a link:
> > >
> > > Most (all?) look like this:
> > >
> http://groups.google.com/groups?selm=3A11AD33.B1438202%40rochester.rr.com
> > >
> > > But this leads nowhere.
> > >
> > > Can somebody help me locating this code?
> > > I really tried myself.
> > >
> > > TIA
> > > Eric
> > >
> > >
> >
> >
> > --
> > Debra Dalgleish
> > Excel FAQ, Tips & Book List
> > http://www.contextures.com/tiptech.html
> >
>
>
|
|
|
|
|
Dana
|
Posted: Sun Apr 03 23:54:26 CDT 2005 |
Top |
Excel Programming >> Cubic splines
Eric. Just for feedback, David's code works really well! For example, he
gave 7 data points for testing, with x values running from 1-7.
As a custom function, the Cubic Spline equations of that test data would be
the following: The returned values match David exactly. :>)
Function Spline(num)
Dim t, n
n = num - Int(num)
Select Case num
Case Is < 1
t = "#N/A"
Case Is < 2
t = 3 + (21 * n) / 26 - (21 * n ^ 3) / 26
Case Is < 3
t = 3 - (21 * n) / 13 - (63 * n ^ 2) / 26 + (53 * n ^ 3) / 26
Case Is < 4
t = 1 - (9 * n) / 26 + (48 * n ^ 2) / 13 - (61 * n ^ 3) / 26
Case Is < 5
t = 2 - (87 * n ^ 2) / 26 + (61 * n ^ 3) / 26
Case Is < 6
t = 1 + (9 * n) / 26 + (48 * n ^ 2) / 13 - (53 * n ^ 3) / 26
Case Is <= 7
t = 3 + (21 * n) / 13 - (63 * n ^ 2) / 26 + (21 * n ^ 3) / 26
Case Else
t = "#N/A"
End Select
Spline = t
End Function
--
Dana DeLouis
Win XP & Office 2003
> Hello Debra,
>
> A million thanks .... that one works.
>
> I tried again in Ron de Bruyn's Google search and via Google.com by
> literally copying text from the David Braden post as text and they
> couldn't
> find it.
>
> You helped me a lot.
> And thanks to David to.
>
> Kind regards
> Eric
>
> PS: maybe an idea for David to reenter that post that google.com can find
> it
> too. (it's often referred to).
>
>
>
>> Try this link instead:
>>
>>
> http://groups.google.ca/groups?selm=3A11AD33.B1438202%40rochester.rr.com
>>
>> > Sorry all,
>> >
>> > A dumb question.
>> > I was searching the Excel groups for a Cubic spline smoothing.
>> >
>> > I find numerous messages refering to code entered by David Braden.
>> > In some I find a link:
>> >
>> > Most (all?) look like this:
>> >
> http://groups.google.com/groups?selm=3A11AD33.B1438202%40rochester.rr.com
>> >
>> > But this leads nowhere.
>> >
>> > Can somebody help me locating this code?
>> > I really tried myself.
>> >
>> > TIA
>> > Eric
>> >
>> >
>>
>>
>> --
>> Debra Dalgleish
>> Excel FAQ, Tips & Book List
>> http://www.contextures.com/tiptech.html
>>
>
>
|
|
|
|
|
Eric
|
Posted: Tue Apr 05 01:38:33 CDT 2005 |
Top |
Excel Programming >> Cubic splines
Thanks Tom & Dana,
I'll play with David's code next weekend.
:):) Tom I know I've been busy.
:):) But to smooth my consience a bit.
I still help people a lot with physical acoustics in studio groups.
In Excel I'm still stuck with a lot of old macro4 programs.
Dana,
checking your function, it seems I still must search how to make those
formulas for n numbers of x.
Must take some time to better understand.
Warm regards
Eric
> Eric. Just for feedback, David's code works really well! For example, he
> gave 7 data points for testing, with x values running from 1-7.
> As a custom function, the Cubic Spline equations of that test data would
be
> the following: The returned values match David exactly. :>)
>
> Function Spline(num)
> Dim t, n
> n = num - Int(num)
>
> Select Case num
> Case Is < 1
> t = "#N/A"
> Case Is < 2
> t = 3 + (21 * n) / 26 - (21 * n ^ 3) / 26
> Case Is < 3
> t = 3 - (21 * n) / 13 - (63 * n ^ 2) / 26 + (53 * n ^ 3) / 26
> Case Is < 4
> t = 1 - (9 * n) / 26 + (48 * n ^ 2) / 13 - (61 * n ^ 3) / 26
> Case Is < 5
> t = 2 - (87 * n ^ 2) / 26 + (61 * n ^ 3) / 26
> Case Is < 6
> t = 1 + (9 * n) / 26 + (48 * n ^ 2) / 13 - (53 * n ^ 3) / 26
> Case Is <= 7
> t = 3 + (21 * n) / 13 - (63 * n ^ 2) / 26 + (21 * n ^ 3) / 26
> Case Else
> t = "#N/A"
> End Select
>
> Spline = t
> End Function
>
>
> --
> Dana DeLouis
> Win XP & Office 2003
>
>
> > Hello Debra,
> >
> > A million thanks .... that one works.
> >
> > I tried again in Ron de Bruyn's Google search and via Google.com by
> > literally copying text from the David Braden post as text and they
> > couldn't
> > find it.
> >
> > You helped me a lot.
> > And thanks to David to.
> >
> > Kind regards
> > Eric
> >
> > PS: maybe an idea for David to reenter that post that google.com can
find
> > it
> > too. (it's often referred to).
> >
> >
> >
> >> Try this link instead:
> >>
> >>
> > http://groups.google.ca/groups?selm=3A11AD33.B1438202%40rochester.rr.com
> >>
> >> > Sorry all,
> >> >
> >> > A dumb question.
> >> > I was searching the Excel groups for a Cubic spline smoothing.
> >> >
> >> > I find numerous messages refering to code entered by David Braden.
> >> > In some I find a link:
> >> >
> >> > Most (all?) look like this:
> >> >
> >
http://groups.google.com/groups?selm=3A11AD33.B1438202%40rochester.rr.com
> >> >
> >> > But this leads nowhere.
> >> >
> >> > Can somebody help me locating this code?
> >> > I really tried myself.
> >> >
> >> > TIA
> >> > Eric
> >> >
> >> >
> >>
> >>
> >> --
> >> Debra Dalgleish
> >> Excel FAQ, Tips & Book List
> >> http://www.contextures.com/tiptech.html
> >>
> >
> >
>
>
|
|
|
|
|
|
|