Jump to content


Photo
- - - - -

Getting the most out of EXCEL 2010


  • Please log in to reply
14 replies to this topic

#13 AkakmanH

AkakmanH

    Member

  • Members
  • PipPip
  • 304 posts
  • Gender:Male
  • Location:Dallas, Texas

Posted 05 December 2012 - 04:44 PM

O/K, guys. I have been investigating this for a long time. I got started because a CPA friend of mine had some Excel spreadsheets which were huge. When he input new numbers and hit enter, he could walk away, brew a pot of coffee and, if he was lucky, when he came back the computations might be done. What I found was that CPU speed is not an issue. It is "memory". The more of it you have , the fasted the calculations because underneath the Excel engine are floating point math formulas that really speed up the process. With low memory the FP part of any CPU does not have enough to work with.

#14 Waco

Waco

    Lab Rat 2

  • Reviewer
  • PipPipPipPipPipPipPipPip
  • 16508 posts
  • Gender:Male
  • Location:Los Alamos, NM

Posted 05 December 2012 - 07:20 PM

O/K, guys. I have been investigating this for a long time. I got started because a CPA friend of mine had some Excel spreadsheets which were huge. When he input new numbers and hit enter, he could walk away, brew a pot of coffee and, if he was lucky, when he came back the computations might be done. What I found was that CPU speed is not an issue. It is "memory". The more of it you have , the fasted the calculations because underneath the Excel engine are floating point math formulas that really speed up the process. With low memory the FP part of any CPU does not have enough to work with.

The amount of memory available has very little to do with FP calculation speeds.

What version of Excel was this? The newest ones can utilize a huge number of threads as long as your workload isn't sequential in nature. If it is...you're pretty much stuck throwing the fastest cores you can get at it.
Tolerance is a sign of weakness.

#15 Hyper

Hyper

    Of course it will fit, I have power tools.

  • Members
  • PipPipPip
  • 943 posts
  • Gender:Male
  • Location:Vancouver, WA

Posted 06 December 2012 - 06:40 AM

I have a 3930k w/32g ram but I havent done anything with excel in a while. I could look for a benchmark prog this weekend and see what it does though.

sigimage.gif