Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Flims, Switzerland
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    calculation performance tuning (2000)

    Does anyone know if the order of a series of numeric values affects the performance of a formula which is referencing them?

    Does it make any difference if they are in a random order, or sorted in ascending/descending order?

    I ask this with reference to any standard worksheet function, e.g. SUM().

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: calculation performance tuning (2000)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Adam

    ASAIK Excel < 2002 AKA XP does calculate sequentially, that is cell A1 on Sheet1 then cell A2 or B1 I am not sure on Sheet1 all the way to cell A1 on Sheet2 and then cell A2/B1 on Sheet2 and the all the way to Cell IV65536 on Sheetx.

    So if you have a row of cells that are part of a calculation then your idea of performance comes into play. So the idea is to have all the cells related to a certain calculation is a singe row/column or as much as possible try to.

    I was told that Excel XP has a different calculation method and can do each cell alone.

    Anyone who would like to add to this please do so by replying to Adam.

    Hope this helps.

    Wassim <img src=/S/compute.gif border=0 alt=compute width=40 height=20>
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Silicon Valley, California, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: calculation performance tuning (2000)

    <P ID="edit" class=small>Edited by gwhitfield on 26-Mar-02 22:46.</P>Adam,

    Here is a link to a site with lots of good detailed information about how Excel does certain things and how to use that knowledge to get better performance (or avoid poor performance). I learned a lot here, and was able to cut a 10-minute calculation time to 3 minutes, without even buying their product.

    http://www.decisionmodels.com

    Look under Excel Pages/Calculation Secrets and Optimising Speed.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •