I've got the folloving setup for Mathcad as an OLE object in Excel:
data := csort(data,0)
X := data(0)
Y := data(1)
S := cspline(X,Y)
fit(x) :=interp(S,X,Y,x)
a := fit(x)
Using the folloving VBA-code in Excel I can poke the x-value into the OLE-object and update the calculation, but I cant...
Thanks for the reply!
The eksamples work but they don't give me an equation that I can use in another software to calculate y-values from a given x-value...?
Is there a way to get Mathcad to return the exact equation instead of general formulas and functions ?
(I want to get an equation...
Using the following setup i can interpolate values related to a two-column matrix:
X:=data(0) y:=data(1)
S:=cspline(X,Y)
fit(x):=interp(S,X,Y,x)
fit("value") = "returned value"
Is there any vay that i can get mathcad to return an equation expressing the dataset in my matrix ?
;-)...
