Navigation: FXLV4_Manager > Calculation Manager >

FastExcel Settings

 

 

 

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 © 2020 Decision Models Ltd