Re: Help with reducing CPU demands?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

8 Meg is quite small, should not be a resource hog ...

If your problem is calculation time (F9 takes a long time when in Manual
Calc Mode) then:

For the Lookups and Index/Match sort your data and use the approx match
options of lookups and Matches
(see http://www.decisionmodels.com/optspeede.htm)

For SUMPRODUCT try splitting out helper columns, or using Pivot Tables, or
work with contiguous subsets of sorted data or ...
(see http://www.decisionmodels.com/optspeedj.htm)

If your problem is not calculation then its more difficult to offer advice

regards
Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"Matt Knight" <mattknight1986@xxxxxxxxxxxxxx> wrote in message
news:9fd802c1-0e1e-4cc6-8f48-1711a48a96c7@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi there, I'm currently working on a costing model for education
courses for a college. Since I have 95 cost centres, some of which
contain courses and others are overheads, as well as course codes (of
which there are 602), I have loads of lookups (which I can probably
get rid of when I'm done) and sum products, index matches (which I
can't hard code, cos the model needs to be flexible to sensitivity
analysis). As you can expect, having all these formulae spread over
some 15 sheets has made the sheet pretty big (pushing 8meg in XML
format) and places heavy demands on the CPU (I'm using a quad core and
it's struggling)

What I could really do with is anything which may reduce the pressure
on the CPU as changes are made to the file (and this is before hitting
F9) without having to recode anything. I was just wandering if there
are any tricks to streamlining the calculation process as I don't
think my client will be so lucky as to enjoy lots of processing power!

Any help gratefully received.

Cheers
Matt (PS I checked out www.decisionmodels.com yesterday on the advice
of another thread on here, and it didn't give rise to anything I could
see being useful!)



.

Relevant Pages

  • Re: Help with reducing CPU demands?
    ... the actual calculation times seem to be okay - any reasonable ... If your problem is calculation time (F9 takes a long time when in Manual ... For the Lookups and Index/Match sort your data and use the approx match ... courses for a college. ...
    (microsoft.public.excel)
  • Re: Most performant way to code client script.
    ... > will then be processed with some mathematical algorithms and then ... Don't retrieve data again and again if you really don't need to. ... reduce calculation time. ... calculation times became 6 seconds. ...
    (comp.databases.oracle.server)
  • Re: Match, Filter????
    ... This formula will work but it will add to the calculation time that you ... I need to average cells A1:A100 where the corresponding cells in B1:B100 ...
    (microsoft.public.excel.misc)
  • Setting priority for exe built in DFf6.6
    ... Windows console .exe in w2k. ... Calculation time is 30...50 s. ... Anyway the calculation takes too much of the CPU-usage. ...
    (comp.lang.fortran)
  • Re: relationship based on unstored calculation field
    ... indexable field, and calculations based on related fields cannot be indexed. ... Lookups can be indexed, and, again, you are correct that your next task is ... Relationships can use calculations for the child side, ... Associate Member, Filemaker Solutions Alliance ...
    (comp.databases.filemaker)