Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Maximum Calculation Speed
What is the best tool to compare the Calculation speed between two formulas?
Ola Sandstrom I just found: http://www.acoustics-noise.com/calcsped.htm |
#2
|
|||
|
|||
Not free though, but will analyse your data and suggest optimisation
techniques:- http://www.decisionmodels.com/fastexcel.htm -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Ola" wrote in message ... What is the best tool to compare the Calculation speed between two formulas? Ola Sandstrom I just found: http://www.acoustics-noise.com/calcsped.htm |
#3
|
|||
|
|||
Thanks Ken,
I remember i've seen some comparison of Array formula speed; =SUM(...) compared to =SUMPRODUCT(...) =MAX with LARGE, RANK =INDEX(MATCH(..) with LOOKUP and other "Array crossreferences" .... You don't happen to know where I could find such comparisions? Ola |
#4
|
|||
|
|||
Sorry, don't have any links that have explicit comparisons, but Charles
Williams' site that I gave you the Fast Excel link for also has a number of pages devoted to calculation issues:- http://www.decisionmodels.com/calcsecrets.htm You can always set up a bunch of these formulas all inking to the same cell/range etc and then have a routine run through a few thousand times calculating each time, and then also have it stamp the time it starts and finishes and do a delta. then just switch formulas and repeat. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Ola" wrote in message ... Thanks Ken, I remember i've seen some comparison of Array formula speed; =SUM(...) compared to =SUMPRODUCT(...) =MAX with LARGE, RANK =INDEX(MATCH(..) with LOOKUP and other "Array crossreferences" ... You don't happen to know where I could find such comparisions? Ola |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
How do I fill down keeping one cell calculation from changing in . | Excel Discussion (Misc queries) | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
time-clock calculation | Excel Worksheet Functions |