v3.1 [Jan 6, 2010]
- Faster calculation speed:
- Division calculation speed is improved in xlPrecision 3.1. The improvement varies with the lengths of the divisor, dividend, and quotient, but for most scenarios it is about 10 - 15 TIMES faster.
Of course, all other xlPrecision functions that use division (which is most of them) benefit from this improvement, too, to varying degrees depending on how much they use division.
- Multiplication calculation speed is improved in xlPrecision 3.1. The longer the multiplication product, the greater the improvement. With a 400,000-digit product, it's about 18 times faster. With a 32,000-digit product, it's about 10 times faster. With a 1,000-digit product, it's about 40% faster. With a 100-digit product, it's about 10% faster.
Of course, all other xlPrecision functions that use multiplication (which is most of them) benefit from this improvement, too, to varying degrees depending on how much they use multiplication.
- Format Decimal Place:
- xlPrecision 3.1 adds the format_decimal_place parameter to several xlPrecision functions, allowing you to easily specify that you want digits to always appear exactly out to whatever decimal position you specify.
- Version 3.1 also adds the new xlpDEFAULTMAXSD function, which allows you to determine the default maximum significant digits currently in effect.
- Customize the default maximum significant digits:
On editions that allow more than 100 significant digits, xlPrecision prevents inadvertently causing long calculations by defaulting to 100 significant digits unless a custom maximum is specified in the function's maximum_significant_digits parameter. Now, version 3.1 allows you to customize that default from 100 to any number you wish.
v2.0 [Jun 17, 2008]
66 new functions, faster calculation, export in exponential notation, Data Control & Analysis functions, help text in Excel's Insert Function dialog, Setup intalls xlPrecision as an add-in in all installed compatible versions of Excel.
