Some of you will know that I have been developing (for the past 2 or more years!) some fast multi-threaded Excel functions using the XLL C++ interface.
After climbing this rather steep learning curve I am now very close to the final release of these functions.
FastExcel SpeedTools is designed to be a state-of-the-art set of tools to help you speed up calculation of slow workbooks:
- New calculation methods and modes give you greater control of calculation.
- Superfast memory lookup and Compare Lists functions make handling large data volumes easier.
- You can eliminate many SUMPRODUCT and array formula bottlenecks with SpeedTools FILTER.IFS.
- Additional functions include Regular Expressions, Array Stacking, Array OR/AND, Text and Information functions
The final SpeedTools Beta test is now live and I need more Beta Testers and feedback:
So download SpeedTools Beta 3 and tell me what you think!
The best 20 Beta test feedback reports received by the end of March will get their own exclusive SpeedTools coffee mug, (and a free license of course!).
Excel 2003 users get a toolbar to choose functions and launch the Function Wizard, and Excel 2007 and later users get 2 additional groups on the Formulas tab.