The Museum of HP Calculators
HP Forum Archive 21
[ Return to Index | Top of Index ]
|OT: To All Number Crunchers: Don't miss this VBA numeric library|
Message #1 Posted by Namir on 4 Apr 2012, 11:25 a.m.
If you use Excel and are into number crunching, then I would like to share with you about the Xnumbers6 open source VBA library for extended precision calculations. This is based on an Italian product that was developed by the Foxes Team (led by Loenard Volpi). I am looking into the documentation that Volpi wrote and his team has written just about every function, from simple to advanced, to support extended precision numbers. There is also support for complex numbers. The Xnumbers library has support for real and complex matrices, and also supports multiple and polynomial regression (and offers regression statistics to see how well the fitted model is). The library also includes an extended-precision expression parse and evaluator (two versions one for real numbers and the other for complex numbers.
You can use the Xnumber6 functions in your VBA code,, in Excel formulas, or through the library's many forms. So you have a good number of choices.
The xnumber6 library is awesome. It has been updated for Excel 2007 and 2010. The code was rewritten in VBA. When you install it you can view the fantastic source code (and there are MANY modules). You can click here to visit the Xnumber6 page and download the software.
It's a gem worth looking at! You will NOT waste you time by doing so!
Edited: 5 Apr 2012, 11:24 a.m.
Return to Index | Top of Index ]
Go back to the main exhibit hall