FastExcel V3 Profiler

FastExcel V3 Profiler

FastExcel Profiler is one of the FastExcel V3 family of products.

  • Use FastExcel V3 Profiler to profile the calculation of your Excel workbooks to show you where the slow calculations are.
  • Use FastExcel V3 Manager to help you develop, debug, manage and maintain your workbooks.
  • Use SpeedTools state-of-the-art tools to help you speed up slow Excel calculation.

Most slow-calculating workbooks have a small number of calculation bottlenecks.
So the first step in speeding up calculation is to find these bottlenecks.
You can use FastExcel V3 Profiler to drill-down to yourcalculation problems and prioritise them:

Profile Workbook - detailed profiling of your workbook

Profile workbook provides and documents a detailed and prioritised analysis of the workbook:

  • Analysis of the physical environment, workbook and calculation settings
  • For the workbook and each worksheet
    • Full calculation and recalculation times
    • Volatility analysis
    • Multi-threading efficiency analysis
    • Memory Useage analysis
    • Used Range waste analysis
    • Sparsity analysis
    • Statistic counts of
      • Used Range Cells
      • Constants
      • Conditional Formats
      • Formulas
      • Shapes
      • Hyperlink
  • Potential problem areas are highlighted in orange

Profile Worksheet - detailed profiling of a worksheet

Profile worksheet provides a detailed and prioritised analysis of a worksheet:

  • For each Area, column group and row group
    • Counts of Formulas, Array Formulas and Conditional Format Rules
    • Calculation times compared to worksheet calculation times
  • Potential problem areas are highlighted in orange

Profile Formulas - detailed profiling of the formulas on a worksheet

The ability to directly profile formulas is one of the major advances in FastExcel V3.
Profile formulas provides a detailed and prioritised analysis of each unique formula and function used on the worksheet:

  • Count of the ocurrences of this formula
  • Microseconds per formula
  • Total calculation time for this formula compared to the worksheet
  • Analysis of the formula
  • Multi-threaded or single-threaded
  • Volatile or non-volatile
  • Function types used (Native, UDF, XLL)

Drill Down Wizard - the easy way to find your calculation bottlenecks

  • Step-by-step profiling drill down using defaults
  • Finds the slowest worksheet in the workbook
  • Then finds the slowest areas on the slowest sheet
  • Then finds the slowest formulas on the slowest sheet

Map Cross-References - see the links between worksheets

  • Shows forward and backward references between the worksheets in a workbook
  • Option to minimise the forward references

Try it for yourself!

Download the 15-day full-featured trial of FastExcel V3 build 236.656.793.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.

Want to know more?

Download the FastExcel V3 Help file or the FastExcel V3 User Guide (PDF)
(you may need to unblock the downloaded .CHM file - Right-Click->Properties->Unblock)

See Whats New for changes in this build

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