FastExcel Settings

Calculation Timers for buttons and keys

You can control the FastExcel calculation time display separately for the calculate buttons and the calculate keys.

When checked you will see a message box after the calculation showing the time taken by the calculation.

Range Calculate Settings

Range Calc including or excluding Dependents

In Excel 2007 and later there are 2 different Range calculate methods. One includes within-range dependency calculations and the other ignores within-range dependencies and calculates row by row strictly left-to-right and top-to-bottom. Range Calculate always ignores dependencies outside the selected range, although the selected range will be expanded to include all the cells in multi-cell array formulas.

Set Number of RangeCalc Trials

Because RangeCalc timing can be sensitive to Windows multi-tasking it is better to allow a number of trials. The Median (middle-most) calculation time will automatically be used, thus discarding incorrectly high and low values.

You can set the number of trials: the default number is 3.

Include Screen Refresh Time

If checked timings for Range Calculate will include the time used by Excel to refresh the visible window.

Copyright © 2022 Decision Models Ltd.