|
SpeedTools Overview
Extended Calculation Methods
SpeedTools Extended Calculation methods give you much finer control over Excel calculation.
This finer control allows you to minimize calculation time with slow-calculating workbooks.
When multiple workbooks are open:
Only calculate the active workbook
Use different calculation methods (Manual, Automatic for the open workbooks
Within a workbook control assign different calculation methods to each worksheet (Mixed Mode Sheets)
Control the calculation method to use at workbook open time.
Automatically restore each workbook’s calculation mode after it is opened.
High-Performance, High-Power Functions
Eliminate LOOKUP, SUMPRODUCT and Array Formula Bottlenecks
Two major Excel calculation bottlenecks are Lookup functions and multiple condition array formulas or their SUMPRODUCT equivalents.
FastExcel SpeedTools now has the solution to many of these bottlenecks with the AVLOOKUP2 and FILTER.IFS families of high-performance functions.
Extend your capabilities with over 100 High-Power Functions
Exploit the power of Dynamic Arrays with 50 Array-Handling functions
Dynamically floating totals
Accumulate, Difference and Moving Average array calculators
Stack Arrays
Unpivot
Merge (Join) dynamic arrays and find miss-matches (Anti-Join)
Resize & Reshape Arrays
Use MEMMATCH, MEMLOOKUP and a family of 24 advanced function Lookup functions for
Faster exact match Lookups with 3 Memory options
Multi-threaded C++ XLL for faster calculation Excel calculation.
Fast Exact match option with sorted data
Multiple Lookup answers
Find the Nth, first, last, all Lookup answers
Case-sensitive Lookup option
Wild-card and Regular Expression Lookups
Multiple Lookup Values
Multiple Lookup Columns
Multiple Answer Columns
Use column labels rather than column numbers
Built-in error handling
Use the LISTDISTINCTS family of functions to
Work with distinct rows or distinct cells within a multi-column range
Find the total number of distincts and duplicates
List the distincts
Count the number of occurrences for each distinct
Sum or average corresponding values for each distinct row
Find distincts using multiple criteria using LISTDISTINCTS(FILTER.IFS)
List output can be sorted.
Case-Sensitive or not
Options to ignore cells containing Errors, Blanks or zeros.
Use ASUMIFS and ACOUNTIFS for fast and powerful multiple-criteria summing and counting.
Use FILTER.IFS, FILTER.SORT and FILTER.MATCH to add fast and powerful multiple criteria capability to many Excel functions such as MAX, MEDIAN etc.
10 new Text Functions
Use Regular Expressions to find (Rgx.FIND , Rgx.LEN), substitute (Rgx.SUBSTITUTE) or extract (Rgx.MID) within text-strings
Concatenate Ranges (CONCAT.RANGE)
Split (SPLIT.TEXT), Pad (PAD.TEXT) and Reverse (REVERSE.TEXT) text-strings.
Extract groups of characters (GROUPS) from within text-strings
COMPARE to compare values in the same sequence as Excel’s SORT
Specialist high-performance functions VLINTERP2, LINTERP2D and GINICOEFF
EVAL to evaluate string expressions as formulas or array formulas
ISLIKE and Rgx.ISLIKE allow extended wild-card and Regular Expression pattern matching in ordinary and array formulas.
6 counting functions specially designed to extend the power of dynamic range names.
Calculation sequence and counting functions to help you understand Excel calculation quirks.
Use the SpeedTools Run-Time Library to distribute Workbooks that use SpeedTools Functions
The Run-Time library is a one-time additional purchase that allows unlimited distribution of SpeedTools Functions.
The Run-Time is designed to allow existing workbook formulas that use SpeedTools functions to execute correctly on PCs that do not have a licensed version of SpeedTools installed.
It does not facilitate users creating new fomulas that use SpeedTools functions
When you purchase the Run-Time you get freely copyable run-time versions of the SpeedTools Function Library (the XLLs).
You package these XLLs in a zip file with your workbook, add a few lines of VBA to the workbook, and send it to other users.
They simply extract the workbook and the XLLs from the zip file to a single folder, and the SpeedTools Functions are enabled.
Using the SpeedTools Run-Time in this way does not require the user to have Administrative Rights or to run an Installer program.
|
