|
Five Calculation Profiling Commands
Note: when using the trial version of FastExcel only the DrillDown profiler command is available and it is restricted to a single worksheet.
Drill-down Profiler Wizard: This guides you to drill down to find the calculation bottlenecks from workbook to the individual formulas on the slowest worksheets.
Profile Workbook: Analyzes the calculation times of your workbook and worksheets.
Profile Worksheet Formulas and Functions: This analyzes the calculation times for unique formulas on a worksheet and identifies the functions used that are volatile or single-threaded.
Profile Worksheet Areas: This analyzes formula calculation times for the columns, rows and blocks of formulas in one or more of your worksheets.
Map Worksheet Cross-References: This analyzes the cross-references between worksheets and optionally re-sequences the worksheets to minimize forward cross-references.
You can get Contextual Help on the output from the profiling commands either by right-clicking a selected cell on the output sheet or by selecting a cell and pressing the FastExcel Contextual Help button.
Potential bottlenecks are highlighted in orange. The sensitivity of the orange highlighting can be controlled by setting FastExcel’s Orange Tolerance (default 0.2) on the FastExcel Settings page: Cell Highlight (Orange) sensitivity.
The profiling commands help you to document calculation options, and generate timing statistics and memory usage details.
The profiling commands generate result worksheets into a separate workbook, using sheets called:
FastXLBookn: The workbook profile results
FastXLSheetn: the worksheet profile results
FastXLFuncsn: the worksheet formulas and functions profile results
FastXLPrecsn: the worksheet cross-reference map results
Multiple profiles of a given type are given an incremental number suffix.
|
