Looking for a little help picking out a rig, again don't want to build one it's for business use.
Main Use Excel 2016 64 Bit $1,500-$2,500 budgetTower only, pre-built 16 gigs of ram & SSD
No peripherals needed 256 SSD min size
Looking around I like the Precision Tower 7000 Series by Dell. Was thinking a Dual Xeon Dual Intel® Xeon® Processor E5-2609 v4 (8C, 1.7GHz, 1866MHz, 20MB, 85W)
There seems to be a lot of dated information out there for older Excel Versions along with old CPU's. Again I don't want to build anything, just need to order something. Am I best putting most the budget towards say a Dual Xeon setup and less ram?
Primary use again Excel with big worksheets, macros and formulas.
Dual 27" 1080P monitors. That was kinda my question should I focus on a high end i7 or go the Xeon route? Again building is off the table, it's for a Small Business office and am ok with buying a dell work station. I usually use XPS towers and I'm pretty happy with them but I didn't know the best CPU configuration for Excel.
The xeons just let you use way more RAM than an i7, like in the 256 GB range vs 64gbs
but you're probably going to want a much faster per core CPU, like a 5820K + 64gbs of RAM, and like a samsung 950 SSD, and that's about it
What's your current machine? is it just maxing it out?
seems like Excel 2007+ can be multi-threaded, but I don't know how many threads at max it can use, but overall you're still going to want strong per core performance from some quick google searching. Also depends on what kind of workload you're doing I guess
And you should totally like buy a 40" 4k display - - and just to throw it out there....what I listed above + W2100 firepro since it was just the cheapest thing with 2 display port outputs PCPartPicker part list: http://pcpartpicker.com/p/YwQ7Yr Price breakdown by merchant: http://pcpartpicker.com/p/YwQ7Yr/by_merchant/
CPU: Intel Core i7-5820K 3.3GHz 6-Core Processor ($369.99 @ SuperBiiz) CPU Cooler: Cooler Master Hyper 212 EVO 82.9 CFM Sleeve Bearing CPU Cooler ($29.49 @ Amazon) Motherboard: Asus SABERTOOTH X99 ATX LGA2011-3 Motherboard ($307.99 @ SuperBiiz) Memory: Crucial 64GB (4 x 16GB) DDR4-2133 Memory ($204.99 @ Adorama)
This is the current machine, CPU is pretty weak. I attached some screen shots. I just was wondering if I'm better of going big on one high end i7 CPU and lots of ram (ssd of course) or do a Xeon setup.
So right now on this machine, a 20 megabyte file takes about 11 seconds to run VBA code with 60k rows of data.
What do you think of spending more getting a Xeon setup?
A Xeon is certainly not worth it. To get a Xeon as fast or a bit faster than something like a 5820K you're gonna have to spend something like at least $700 as opposed to about $350. The i7 is cheaper and faster at the lower price range and SKUs.
You do get more RAM support, dual CPU support and ECC memory support but I don't think that would be necessary.
Could wait for Zen to drop around October. I imagine that there will be a lot more pre built machines up for sale then than there are now. And since it is a new platform, there will be a lot of new features and all. High capacity ssds, more ram, etc. Still not sure that you need more than an i3 and don't see why you can't build it yourself. Just look around newegg for a prebuilt with the specs you want if you want it now.
As someone who builds computers daily, I would do the i7-6700k and an AIO water cooler and overclock it. You can do the same with the AMD processors as they have more "cores" but it's up to you. Zen won't be out in time. As a shop that still builds with AMD, we are moving towards Intel more and more. Hopefully, Zen fixes that. Good luck though in finding something that fits what you are needing!
running excel is one thing if you use it to keep track of your daily expenses, for complex modeling macros and database access its another beast entirely
i cannot realy help on this one unfortunatly. since i done have much experiance with massive spreadsheets in excel, And large formule calculations. But i do think that @Skelterz hits a good nail there, fast ram speeds can definitely be benefitical in this situation. Since you do allot in RAM i would imagin. Not sure if a 5820K might be benefitical as well, since more cores and onboard cache? What do you think @Skelterz ?
I think an i7 6700k is adequate but having enough ram to keep from having to wait for excel to pull from disk, so ssd will help there too. I am not too sure how well excel could even utilize that much power.
