XlXtrFun error when Excel is opened

[Tronen]

Hello:

I'd been using this addin called XlXtrFun for years. It is very useful mainly for interpolate (splines, etc..). Now the problem comes because I suspect this addin doesn't work for 64 bit Excel versions.

When we are trying to load the addin it appears a message when Excel is opened: "The file could be corrupted or unsafe. Unless you trust its source, don't open it. Do you want to open it anyway?" If Yes is selected then Excel closes. If No is select the addin is not loaded.

We web site for the adding is this:

http://www.xlxtrfun.com/XlXtrFun/XlXtrFun.htm

I have tried to contact with support@xlxtrfun.com but this address doesn't work because the web site is a little bit old.

I think it could be possible to make this addin work for a 64 bit Excel. In this sense I have found this site

http://www.dllfoot.com/fixing/xlxtrfun.xll.html

but I don't understand what they try to explain and it is needed to used a suspicious program called DLLEscort_Setup.exe and a process a little bit dark...

Any other ideas would be welcome.

 

[Dark Avenger]

Hi @ZVI,

Thanks a lot for your post and help to make it compatible with 64 bits version of Microsoft Office.
I would like to know if you have posted your source code on Github (or similar) so the community can support your work.
I'm a dev myself and might help you complete your current work on it.
Thanks a lot !

 

[luisen]

Hi @ZVI,

Thanks a lot for your post and for taking the time and effort to make this work!

Congrats and Happy New Year!

 

[RaviA]

Hi,

The recommendation of the 2nd link has no sense in this case.
That tool is XLL (actually - DLL) AddIn compiled for the Excel 32 bit only.
Theoretically the owner of its C++ source code might recompile the code for the 64 bit version too, but looks like the AddIn is not supported anymore.

What can you do:
1. Install one more Excel 32 bit of another version (say 2010 32bit if you are using 2016 64bit) and use it for the tasks of that AddIn.
2. Try to find alternative VBA code which is good by default for both 32 and 64 bits.
Or even hire someone (the Author?) for developing VBA AddIn with the similar functionality in case it’s too critical.

Regards,

Hello @ZVI/All

I want to know which interpolation method has been used for double Parabolic Interpolation? Can any one can help on this query?

Thank you

 

[Erwin1966]

Hi Felipe,

Thank you for testing and for sharing your installation experience.
In my testing Windows Defender antivirus software was used with no such issues.


Glad you got it all working!


Actially, all 1D and 2D functions are realized:

1. ddydx(ArrayOfXs, ArrayOfYs, GivenX)
2. dydx(ArrayOfXs, ArrayOfYs, GivenX)
3. IndexOfClosestValue(ArrayOfValues, ValueToSeek)
4. IndexOfMaxDouble(ArrayOfDoules)
5. Interp(ArrayOfXs, ArrayOfYs, GivenX)
6. Interpolate(ArrayOfXs, ArrayOfYs, GivenX, [Extrapolate], [Parabolic], [Averaging], [SmoothingPower])
7. Intersect(FirstCurveXs, FirstCurveYs, SecondCurveXs, SecondCurveYs, [GuessX], _
   [nInterpolateSpline1], [nInterpolateSpline2], [dAccuracy], [lMaxIterations], [dh])
8. LookupClosestValue(ArrayOfValues, ValueToSeek)
9. LookupClosestValue2D(XYArray, ArrayOfXKeys, ArrayOfYKeys, XValueToSeek, YValueToSeek)
10. Pfit(ArrayOfXs, ArrayOfYs, GivenX, order)
11. Spline(ArrayOfXs, ArrayOfYs, GivenX)
12. vba_InteriorAngles(X1, Y1, X2, Y2, X3, Y3, [TrueForRadiansFalseForDegrees], [DeltaYOverDeltaX])
13. XatY(KnownXArray, KnownYArray, PeakValleyOrY, [GuessX], [GivenY], [Extrapolate])

Click the Fx formula bar and select the "XtrFun64 Library" category to view their list and argument details.

Only two 3D functions are missing: Interp3D and InterpMatrix.
I will add them into the next version, but only if they are supported by XtrFun.dll


My bad, it was my preference for debugging. I will fix it in the next release.

Regards,

Hi Zvi, this 64 library works for me also, thank you very much. Only question is about the @PFit function. In de 32 bit version the formula to use was @Pfit but now in the 64 version there is a space between the @ and P so need to rewrite the formulas to @ PFit. Is there any reason for adding the space? Same issue with @LookupClosestValue. Easy to fix but just wondering why.

 

[mc56]

I've been using this and have been very grateful to have found ZVI's work, given I was compelled to leave my old laptop behind when it finally failed. Now, with a 64-bit OS and MSO installation, a lot of my spreadsheets would otherwise not work.

Alas, there is a flaw; this is not a criticism but a note of caution to anyone relying on Interpolate(). Extrapolation no longer works unless the data is sorted in a compliant way.

Allow me to explain.

For a formula of:

=Interpolate(known_xs,known_ys,given_x,TRUE,FALSE)

Things work if, for a given_x of 1800, the data set is:

known_xs known_ys
1250     246
1600     249
1785     250

But it doesn't work if:

known_xs known_ys
1785     250
1600     249
1250     246

This behaviour was not evident in the original 32-bit XlXtrFun, which handled this data sequence perfectly. Again, as I say, this is not a criticism of ZVI's best efforts in recreating this functionality in 64-bits, but a warning to those who may be depending on error-free results from their computations using @Interpolate().

All the best.
Matt

 

[mc56]

PS: to be clear, this seems only to be a problem when given_x is apparently beyond the x-bounds of the data. If given_x is a value within the dataset, the result is correct.