Solved

Excel - best  hardware configuration for best performance (multi core support?)

Posted on 2014-12-21
8
408 Views
Last Modified: 2015-01-03
I have a user with whom we are spec’ing up a Mac Pro for (which will be running Windows 8 via Boot Camp).
We are debating the number of cores to get and how much memory to put into the Mac Pro. The user will go up to the fully loaded spec if necessary (and this comes in about £10k with 96GB of memory)

But we want to know if it’s worth it.

The user works in finance and have Bloomberg running, but a particular thing he does also use is Excel with various third party plug in’s he’s purchased as well as coding he does himself.

Research so far has learnt that if he uses VBA that can only make use of one core tops, but I’m wondering if it’s possible if some of his third party plugins might do (There are numerous ones)

I’m not sure at present if he will use the 32 bit or 64 bit edition of Excel. I assume the 32 bit version of Office can only address 4GB of memory (it will be on a 64 bit OS).

So if this is his use, is it a waste of time buying say 64GB instead of 32GB (Adds another £640  / $1100).

Also is it worth going for lots of additional cores which again can make a jump in price.

The user is prepared to pay for the best performance, but of course does not want to unnecessarily spend, if it’s not actually going to make a difference to performance.
He will be running three displays of the Mac Pro also.
0
Comment
Question by:IT Man200
8 Comments
 
LVL 90

Accepted Solution

by:
John Hurst earned 250 total points
Comment Utility
The issue with 32-bit Excel and 64-bit Excel (from my point of view) revolves more around software compatibility. If you use 64-bit Excel, everything around it must also be 64-bit. That is not usually true. I run Office 2013 32-bit on my Windows 8.1 Pro 64-bit machine. It runs really well this way.

I assume the 32 bit version of Office can only address 4GB of memory  <-- I don't know if this is true, but Excel on my machine is not constrained in any way.

is it a waste of time buying say 64GB instead of 32GB?  <--- I have an 8 GB machine. I can run Excel with large spreadsheets, IE11 with web pages running and 2 additional complete machines (Windows 7 and Windows XP) all simultaneously and still not run out of memory.  It is hard to imagine that 32 Gb of memory would constrain a user.
0
 
LVL 3

Assisted Solution

by:carlrjr
carlrjr earned 250 total points
Comment Utility
John is correct; if Excel and web browsers will be the primary applications, 16-32 GB will do.
Since Excel VBA doesn't benefit much from multi-core I would choose the Mac Pro 3.7 Ghz 4-core over the 3.5 Ghz 6-core CPU.

I would also spec the SSD for the boot drive.

Since the Bloomberg plugin is the client's primary concern, it's requirement for 32/64-bit Office will dictate which version to use. if it tolerates either then go 64-bit.
0
 
LVL 70

Expert Comment

by:KCTS
Comment Utility
If its going to be running windows8 then why not just buy a PC which will not only save a lot of cash but will also run the native applications much more efficiently.
0
 
LVL 90

Expert Comment

by:John Hurst
Comment Utility
I tend to agree. The user wants MAC hardware. However, my own ThinkPad bows to nothing and performs really well,
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:IT Man200
Comment Utility
The PC over the Mac choice is a conversation for another thread. In fact here is the one I did earlier
http://www.experts-exchange.com/Hardware/Apple_Hardware/Q_28584459.html
So for the purposes of this thread lets assume we have to get the Mac as this is what the client wants for various reasons.
0
 
LVL 85

Expert Comment

by:Rory Archibald
Comment Utility
32bit Excel will only actually use up to about 2GB of RAM, but of course you will want more to ensure that there is always 2GB free for it to use when other things are running. Unless your user works with really large files or uses the Power BI add-ins, I wouldn't bother with 64bit Office.
0
 

Author Closing Comment

by:IT Man200
Comment Utility
All useful input. Many thanks
0
 
LVL 90

Expert Comment

by:John Hurst
Comment Utility
@ IT Man200 - You are very welcome and I was happy to help.
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now