High spec pc required for Excel modelling

[A[L]C]

Hi all,

I need a spec for a machine to excel data modelling using this to model excel files in excess of 200mb each.

The vendor has advised a quad core pc with ~20gb of ram.

Any recommendations please?
Thanks

 

[stulid]

Is there a budget?

Whats needed? base unit? operating system? monitor etc?

 

[A[L]C]

No budget limit really, but in excess of 2k would be hard to justify.

Base unit only. No os needed.

 

[stulid]

Your basketProduct Name Qty Price Line Total
Crucial RealSSD M4 256GB 2.5" SATA 6Gb/s Solid State Hard Drive £283.99
(£236.66) £283.99
(£236.66)
Intel Core i7-2600K 3.40GHz (Sandybridge) Socket LGA1155 Processor - Retail £239.99
(£199.99) £239.99
(£199.99)
OcUK GeForce GTX 560 1024MB GDDR5 PCI-Express Graphics Card £139.99
(£116.66) £139.99
(£116.66)
Gigabyte Z68XP-UD3 Intel Z68 (Socket 1155) DDR3 Motherboard ** LOWEST UK PRICE ** £99.98
(£83.32) £99.98
(£83.32)
BeQuiet Efficient Power 600W '80 Plus Gold' Power Supply £69.98
(£58.32) £69.98
(£58.32)
Cooler Master CM-690 II Lite Dominator Case - Black £66.98
(£55.82) £66.98
(£55.82)
Samsung SpinPoint F4 EcoGreen 2TB SATA-II 32MB Cache - OEM (HD204UI) £55.99
(£46.66) £55.99
(£46.66)
Kingston HyperX Genesis Grey 8GB (2x4GB) DDR3 PC3-12800C9 1600MHz Dual Channel Kit (KHX1600C9D3X2K2/8GX) £53.99
(£44.99) £107.98
(£89.98)
Samsung SH-S222AL/BEBE 22x DVD±RW SATA Lightscribe ReWriter (Black) - OEM £16.99
(£14.16) £16.99
(£14.16)
Sub Total : £901.57
Shipping cost assumes delivery to UK Mainland with:
DPD Next Day Parcel
(This can be changed during checkout) Shipping : £12.50
VAT is being charged at 20.00% VAT : £182.81
Total : £1,096.88

Cant see you needing to spend any more.

• 16GB RAM, OCUk dont have any 8GB RAM sticks listed which would give 32GB.
• 256GB SSD + 2TB HDD
• Gold rated efficiency PSU.
• Quad core + hyperthreading CPU.
• Motherboard does everything.


To get more RAM in you will need to find 8GB sticks, the other option is a socket 1366 system and i7 CPU which being triple channel means you can get 24GB kits - http://www.overclockers.co.uk/showproduct.php?prodid=MY-111-KS&groupid=701&catid=8&subcat=1389

But a i7 2600K is faster than most of the socket 1366 CPU's.

 

[A[L]C]

Thank you. Have been looking at the prebuilt stuff available and this is over half the price.

We could even knock the 2tb hdd off, and drop the SSD to a 80gb or so. We will probably copy the file down to the pc over the network and then perform the calculations and put it back on the filer to ensure it is backed up etc.

They are using Xeon's though.

edit: If we switched to the Z68XP-UD3P-B3, we do do away with the graphics card and use a hdmi to dvi convertor? Its only displaying excel, so not sure if we need a high powered gfx card?

 

[stulid]

Your basketProduct Name Qty Price Line Total
Intel Core i7-2600K 3.40GHz (Sandybridge) Socket LGA1155 Processor - Retail £239.99
(£199.99) £239.99
(£199.99)
OcUK GeForce GTX 560 1024MB GDDR5 PCI-Express Graphics Card £139.99
(£116.66) £139.99
(£116.66)
Intel 320 Series 80GB 2.5" SATA-II 25nm Solid State Hard Drive - Retail £109.99
(£91.66) £109.99
(£91.66)
Gigabyte Z68XP-UD3 Intel Z68 (Socket 1155) DDR3 Motherboard ** LOWEST UK PRICE ** £99.98
(£83.32) £99.98
(£83.32)
BeQuiet Efficient Power 600W '80 Plus Gold' Power Supply £69.98
(£58.32) £69.98
(£58.32)
Cooler Master CM-690 II Lite Dominator Case - Black £66.98
(£55.82) £66.98
(£55.82)
Kingston HyperX Genesis Grey 8GB (2x4GB) DDR3 PC3-12800C9 1600MHz Dual Channel Kit (KHX1600C9D3X2K2/8GX) £53.99
(£44.99) £107.98
(£89.98)
Samsung SH-S222AL/BEBE 22x DVD±RW SATA Lightscribe ReWriter (Black) - OEM £16.99
(£14.16) £16.99
(£14.16)
Sub Total : £709.91
Shipping cost assumes delivery to UK Mainland with:
DPD Next Day Parcel
(This can be changed during checkout) Shipping : £12.50
VAT is being charged at 20.00% VAT : £144.48
Total : £866.89

No HDD but a 80GB SSD.

The only reason theres a nvidia card in there is because you may be able to make use of CUDA.

£230 i7 2600K vs a £600- £700 i7 980X - http://www.anandtech.com/bench/Product/287?vs=142

 

[richb93]

OcUK GeForce GTX 560 1024MB GDDR5 PCI-Express Graphics Card

Would that really be required? I didn't read anything about the software using CUDA acceleration. Surely onboard graphics would be a better bet?

Derp, read your last line! But I don't think he'll need it imo

 

[stulid]

Would that really be required? I didn't read anything about the software using CUDA acceleration. Surely onboard graphics would be a better bet?

Its hardly breaking the bank. You never know, better to have it and not need it than want it and not have it.

 

[richb93]

Its hardly breaking the bank. You never know, better to have it and not need it than want it and not have it.

This is true but I've not read anything about CUDA acceleration for the software online and should it become available it could always be upgraded at a later date

 

[A[L]C]

Hmm gonna go read about what CUDA is

Thanks guys

 

[stulid]

Hmm gonna go read about what CUDA is

Thanks guys

You usually find better info on Youtube -

There are various other demos from Nvidia/Adobe/3D studio etc for all sorts of applications.