FastExcel SpeedTools Extra

SpeedTools Extra contains 29 useful extra functions for Array-handling, Logical, Math, Text and Information.

Array-Handling Functions

These array-handling functions allow you to

  • Mix constant arrays and range references.
  • Stack ranges and/or arrays alongside or below one another.
  • Pad the unfilled cells of arrays with blanks, zeros or #N/A

The array functions are:

  • COL.ARRAY - Appends Ranges/Arrays column-wise
  • ROW.ARRAY - Appends Ranges/Arrays row-wise
  • REVERSE.ARRAY - Reverse the rows, columns or both in an array.
  • PAD.ARRAY - Resize and/or pad an array
  • VECTOR - Outputs a sequence of numbers as a column or row vector.

Logical Functions

    Simplify adding AND and OR to your array formulas with SpeedTools logical functions.
    Excel's AND and OR functions do not work well in array formulas. They return a single TRUE or FALSE rather than an array of TRUEs and FALSEs.

  • ANDROWS - Logical AND by rows
  • ANDCOLS - Logical AND by columns
  • ANDEACH - Logical AND by cell
  • ORROWS - Logical OR by rows
  • ORCOLS - Logical OR by columns
  • OREACH - Logical OR by cell
  • ANY - scalar version of Excel's OR with more sensible error handling
  • ALL - scalar version of Excel's AND with more sensible error handling
  • NONE - equivalent to NOT OR with more sensible error handling
  • COMPARE - Compare 2 values using Locale Collating rules
  • IFERRORX - Extended error-handling version of IFERROR

Math Functions

  • LINTERP2D - Fast 2-dimensional linear interpolation
  • VLINTERP2 - Fast linear interpolation in a vertical table
  • GINICOEFF - Fast calculation of the Gini inequality coefficient.

Text Functions

  • CONCAT.RANGE - Concatenate cell values to a string using delimiters.
  • PAD.TEXT - Expand/Contract text-strings to a fixed length
  • REVERSE.TEXT - Reverse the characters in a Text-string
  • SPLIT.TEXT - Splits text into tokens using delimiters
  • GROUPS - Extracts groups of characters or digits from a Text-string
  • Rgx.FIND - Find the position of a RegEx pattern within a text-string
  • Rgx.LEN - Finds the length of the substring that matches a RegEx pattern
  • Rgx.SUBSTITUTE - Replaces substring(s) that match RegEx patterns.
  • Rgx.MID - Extracts substrings that match regular expressions

Information Functions

  • ISLIKE - wildcard pattern testing for text strings
  • Rgx.ISLIKE - regular expression pattern testing for text strings
  • ISFORMULA - returns true if the cell contains a formula

Functions for use in dynamic range names:

  • COUNTCONTIGCOLS - Counts the number of contiguous visible volumns
  • COUNTCONTIGROWS - Counts the number of contiguous visible rows
  • COUNTUSEDCOLS - Counts the number of columns in the used range, starting from a reference.
  • COUNTUSEDROWS - Counts the number of rows in the used range, starting from a reference.
  • COUNTCOLS - Counts the number of columns to the last non-empty visible column.
  • COUNTROWS - Counts the number of rows to the last non-empty visible row.

Functions for tracing formula calculation sequence and volatility:

  • CalcSeqCountRef - counts the number of times references have been calculated
  • CalcSeqCountVol - counts the number of times this Excel session has calculated
  • CalcSeqCountSet - resets the calculation counter

Free Copy of SpeedTools Calc

SpeedTools Extra gives you all the additional calculation control and options of SpeedTools Calc, at no extra charge.

Try it for yourself!

Download the 15-day full-featured trial of FastExcel V3 build 231.655.789.380

Note: the trial version of FastExcel V3 profiler does not enable Profile Workbook, Profile Worksheet and Profile Formulas, and the Drill down wizard will only profile a single worksheet.

You can convert the trial version of FastExcel V3 to a fully licensed version at any time by purchasing one of the FastExcel V3 licensing options.

 

 

© 2001-2014 Decision Models  Legal Disclaimer Privacy Statement E-Mail Webmaster