Speeding up Excel... (ready to swap some pieces)...

[twizzlybear]

Here's the current build -- I have $500 to burn and I want to significant enhance calculation speed in Excel. My software model calcs a 30 MB spreadsheet, captures various cels and then re-calcs x 10,000. It takes 30 minutes and it's making me nuts.

More RAM? Xeon 1231v3? New mobo? What do you think boss?

PCPartPicker part list / Price breakdown by merchant

CPU: Intel Core i3-4130 3.4GHz Dual-Core Processor ($114.29 @ Amazon)
Motherboard: ASRock H97M-ITX/AC Mini ITX LGA1150 Motherboard
Memory: G.Skill Sniper Series 8GB (2 x 4GB) DDR3-1866 Memory ($61.99 @ Amazon)
Storage: Samsung 850 EVO-Series 250GB 2.5" Solid State Drive ($104.00 @ Amazon)
Video Card: Gigabyte Radeon R9 285 2GB WINDFORCE 2X Video Card
Case: Corsair Air 240 MicroATX Mid Tower Case
Power Supply: XFX 550W 80+ Bronze Certified ATX Power Supply ($65.99 @ Amazon)
Case Fan: BitFenix Spectre Pro LED 56.2 CFM 120mm Fan ($13.66 @ Amazon)
Total: $359.93
Prices include shipping, taxes, and discounts when available
Generated by PCPartPicker 2015-07-29 19:41 EDT-0400

 

[USAFRet]

If you haven't, in the code, turn off Screen Refresh.

What parts do you have now?

 

[dudeman509]

What version of Excel?

Have you set it to use more than 1 thread for formulas?

You can control the number of threads that Excel assigns to the calculation process using File–>Options–>Advanced Options–>Formulas. The number of threads assigned can be larger or smaller than the number of logical cores available.

 

[twizzlybear]

If you haven't, in the code, turn off Screen Refresh.

What parts do you have now?

Sorry for not being clear, the PCPARTPICKER list above is what I currently have. Thanks!