Solved

Build suggestion for Number Crunching (2013)

Hi.
I am fairly new to this forum hence please pardon my ignorance. Have tried searching old threads but info seems to be bit dated.

* Purpose: heavy number crunching, Data analysis/ Pivot/ visualizations/ business simulations/ fetching queries using MS Excel. Just to give an idea, I need to be able to handle upto 20 sheets of Excel simultaneously [with MS Outlook] and cross reference sheets on the fly + VOIP. My existing laptop HP Probook 6460b (i5 - perhaps 1st gen., not sure, 8 GB RAM) isn't able to handle it. I play only Civ5 occationally - hence GPU isn't essential - but good to have. I would be thankful for any build suggestion having decent onboard GPU.

* I am not sure of the capability of MS Excel. A great system may not be leveraged by it!

* Budget: 700-1000 USD, including case. i already have a valid Win 7 & 8 DVD so need not be purchased.

I would be thankful for any inputs.

- Should I rather look for vendors, such as HP/ Dell? Ongoing support isn't that important to me because I have faced challenges with HP for minor issues that i could fix myself..

- Component reliability, reasoable future-proofing within budget for my purpose would be great!

- A business-looking case suggestion would be great :-)

- I am in Canada, our options (seems to be) limited here, and this would be my first build

Thank you for reading through.
Kind Regards and have a great day!
7 answers Last reply Best Answer
More about build suggestion number crunching 2013
  1. I personally dislike laptops and I7 processor would help if you are doing that much multi tasking. Go to http://pcpartpicker.com/ and build ur own rig, it's fun. make sure to get an SSD 240GB is my suggestion.
  2. WarWolverineWarrior said:
    I personally dislike laptops and I7 processor would help if you are doing that much multi tasking. Go to http://pcpartpicker.com/ and build ur own rig, it's fun. make sure to get an SSD 240GB is my suggestion.


    Thank you WarWolverineWar,
    Should I go for Z87 - Asus/ Gigabit? i7 4770k - would that be good?
    Regards.
  3. If you look at benchmarks I7 3770k outperforms I7 4770k in some cases and it's better to overclock with 3770k if you are going to do that and you can get it at about $240 from www.microcenter.com if you have one near your house(pick up only). http://www.tomshardware.com/charts/cpu-charts-2012/benchmarks,140.html
    Any I7 3 rd gen or 4th gen will do.

    I have a I7-3770k and it was cheap and I saved alot of money.
    Make sure your ram is 1600 MHz.
    and don't forget to get 64 bit OS.
  4. With the amount of multitasking that you are wanting to do, I would go with an FX 8320/8350. That and plenty of ram. In your case, 16gb minimum.
  5. PCPartPicker part list / Price breakdown by merchant / Benchmarks

    CPU: AMD FX-8320 3.5GHz 8-Core Processor ($144.99 @ Amazon)
    CPU Cooler: Cooler Master Hyper 212 EVO 82.9 CFM Sleeve Bearing CPU Cooler ($29.99 @ Microcenter)
    Motherboard: Asus M5A97 R2.0 ATX AM3+ Motherboard ($94.99 @ Amazon)
    Memory: G.Skill Ripjaws X Series 16GB (2 x 8GB) DDR3-1866 Memory ($126.92 @ NCIX US)
    Storage: Samsung 840 EVO 250GB 2.5" Solid State Disk ($172.98 @ SuperBiiz)
    Storage: Seagate Barracuda 2TB 3.5" 7200RPM Internal Hard Drive ($84.99 @ NCIX US)
    Video Card: HIS Radeon HD 7770 1GB Video Card ($89.99 @ Microcenter)
    Case: NZXT Source 210 (Black) ATX Mid Tower Case ($37.99 @ Microcenter)
    Power Supply: SeaSonic 520W 80 PLUS Bronze Certified ATX12V / EPS12V Power Supply ($73.99 @ SuperBiiz)
    Optical Drive: Samsung SH-224DB/BEBE DVD/CD Writer ($16.97 @ Outlet PC)
    Total: $873.80
    (Prices include shipping, taxes, and discounts when available.)
    (Generated by PCPartPicker 2013-09-30 13:50 EDT-0400)
  6. Best answer
    For heavy number crunching and business / financial modelling simulations like Monte Carlo. You should disregard any suggestions for AMD CPUs unless you are looking to save money and accept lower performance for your needs. Saving a $100 - $200 for a CPU / motherboard combo will result in wasted time, effort and opportunity costs since your task will take longer to complete... especially simulations.

    Go for an i7-4770 which makes more sense from a business point of view rather than the i7-4770k. The i7-4770 cannot be overclocked, but it includes extra security features which prevents data from specific areas in RAM and in the cache from being hacked and thus cannot be transmitted to an unknown destination.

    Additionally, Haswell introduced AVX2 in all Core i5 / i7 CPUs which is Advanced Vectoring Extension instructions designed specifically to improve business / scientific modelling / simulations.
  7. Yeah, AMD can't match up with Intel with speed. And the only reason to get a K processor is if you are going to overclock it in the future when you need an extra kick.
Ask a new question

Read More

Excel Barebones Hewlett Packard Systems CPUs