AkakmanH Posted December 6, 2012 Posted December 6, 2012 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. Share this post Link to post Share on other sites More sharing options...
Waco Posted December 6, 2012 Posted December 6, 2012 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. Share this post Link to post Share on other sites More sharing options...
Hyper Posted December 6, 2012 Posted December 6, 2012 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. Share this post Link to post Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now