Tool to Measure Calculation Speed

[ruve1k]

Is anyone aware of any tool that can measure (time) the calculation speed of a worksheet recalculate (F9).

(I've seen such a tool used by Bill Jelen on some of the PodCasts.)

 

[VoG]

Take a look here (and links) http://www.decisionmodels.com/optspeedb.htm

 

[ruve1k]

The link below provides VBA code for the following timing routines.

1. FullCalcTimer
2. RangeTimer
3. RecalcTimer
4. SheetTimer

http://msdn.microsoft.com/en-us/library/ff700515.aspx