Jump to content


Photo
- - - - -

Getting the most out of EXCEL 2010


  • Please log in to reply
14 replies to this topic

#1 daverty

daverty

    New Member

  • Members
  • 14 posts

Posted 03 December 2012 - 02:53 PM

Hello,
I wonder if you can recommend the best pc setup that would maximize EXCEL 2010 performance….I understand this version of excel can utilize up to 1024 threads – meaning processors – so I guess the more CPUS the better…or less CPUs with higher speed? Than more with slower speed as the Xeon e5 series for example?

I wonder what your experience has been with multi-core calculations in this version of Excel? Or even in Excel 2013? There is so little information on the interment on the excel performance benchmarks. I hope you can share some of your experience in multi-threaded Excel calculations on your own computer?
Thanks!

#2 Onion

Onion

    OCC Lawyer

  • Members
  • PipPipPipPipPip
  • 4202 posts
  • Gender:Male
  • Location:University of North Florida

Posted 03 December 2012 - 02:57 PM

What do you plan on doing on Excel? What are your current specs?

Rig 1: Q9450 @ 4.0 â–º P45-UD3R â–º GTX 275 â–º 2 x 2 G Series â–º 2x Raptor 150 â–º Truepower Quattro 1kw â–º WC'd â–º 3d Aurora 570
Rig 2: Q6700 @ 4.0 â–º 780i â–º 8800 GTS 512 â–º 4 x 1 Tracers â–º 2 x 640GB AAKS â–º Corsair 650TX â–º Temp. Stock Cooling â–º Antec 900
Rig 3: E2200 â–º P35-DS3L â–º 2900 ICEQ â–º 2 x 1GB Ballistix â–º WD 320 â–º Antec Earthwatts 380 â–º Stock Cooling â–º Ultra Armor
Rig 4: E2160 â–º P35-DS3L â–º 8400 GT â–º 2 x 1GB ballistix â–º WD 320 â–º Antec Earthwatts 430 â–º Stock Cooling â–º Custom Case
OCC - Home of the Potato Overclock


#3 VaporX

VaporX

    Sapphire Gaming Evangelist

  • Members
  • PipPipPipPip
  • 1720 posts
  • Gender:Male
  • Location:Carbondale, Il

Posted 03 December 2012 - 03:35 PM

I have personally never seen an Excel spreadsheet that has pushed a CPU very hard. Now I am not saying they do not exist but I would find it hard to believe you would need to have anything past an i5 for even the biggest spreadsheets. I have seen low RAM space however effect them a lot. I would say if you got a decent i5 or FX chip (6 core or above) and put in 16 Gig with an SSD for the apps and spreadsheet storage, you should not see any kind of slow down. Again however this is a gut reaction since I have never seen a truly massive spreadsheet in action.

If however you have such a spreadsheet and want to know how the performance is effect by the CPU thread count, and processor speed, send it to me and I will be happy to run some tests for you.

Edward "Vapor-X" Crisler

Sapphire North America PR Represenative

"I don't play when it comes to gaming"

 


#4 d6bmg

d6bmg

    BMG FTW!!

  • Members
  • PipPipPipPipPip
  • 4147 posts
  • Gender:Male

Posted 04 December 2012 - 02:57 AM

Generallt a descent I5 would be enough. To get better speed, SSD is compulsory.

boozei.gif


#5 Waco

Waco

    Lab Rat 2

  • Reviewer
  • PipPipPipPipPipPipPipPip
  • 15504 posts
  • Gender:Male
  • Location:Los Alamos, NM

Posted 04 December 2012 - 03:50 AM

Generallt a descent I5 would be enough. To get better speed, SSD is compulsory.

Why do you think an SSD would help Excel calculations?

sig.png

GTX 770 replaced with watercooled GTX780...but too lazy to change the sig.


#6 d6bmg

d6bmg

    BMG FTW!!

  • Members
  • PipPipPipPipPip
  • 4147 posts
  • Gender:Male

Posted 04 December 2012 - 05:21 AM

Why do you think an SSD would help Excel calculations?


My bad. I mean to say that having an SSD is helpful as it will reduce saving time, load time (which should come into play while working with long excel documents).

boozei.gif


#7 Waco

Waco

    Lab Rat 2

  • Reviewer
  • PipPipPipPipPipPipPipPip
  • 15504 posts
  • Gender:Male
  • Location:Los Alamos, NM

Posted 04 December 2012 - 05:32 AM

More threads == faster.

Just take a look at this: http://www.anandtech...duct/288?vs=287

A 2500K is eclipsed by the 2600K in the Excel benchmark - and the old real difference between the two CPUs is hyperthreading. More real cores would be even more beneficial. Granted, this is Excel 2007, but from what I've seen 2010 is far more threaded.

sig.png

GTX 770 replaced with watercooled GTX780...but too lazy to change the sig.


#8 SpeedCrazy

SpeedCrazy

    Life is one heck of a ride, so hang on tight!

  • Folding Member
  • 3817 posts
  • Gender:Male
  • Location:Between birth and death.

Posted 04 December 2012 - 06:36 AM

I've messed with some pretty huge spreadsheets but the only things my i7 920 and 6gbs or ram have not been able to handle snappily was when i made 3 pages of inserted checkboxes(don't ask) that took about 2 mins to load every change. But other than that so long as a good amount of my ram is free i have no problems.
Fold for Team OCC


i7 930 @ 3.9 || Dual-SLI GTX 250 || ASUS P6X58D-E || 3x2GB G.Skill Pi @ 1600 || Corsair TX850w || 2x WD Caviar Black 500gb


#9 d6bmg

d6bmg

    BMG FTW!!

  • Members
  • PipPipPipPipPip
  • 4147 posts
  • Gender:Male

Posted 04 December 2012 - 07:29 AM

^^ Thanks for the feedback gathered from your own experience. It helps everyone, a lot. :)

boozei.gif


#10 d6bmg

d6bmg

    BMG FTW!!

  • Members
  • PipPipPipPipPip
  • 4147 posts
  • Gender:Male

Posted 04 December 2012 - 07:30 AM

double post.. delete it please.

Edited by d6bmg, 04 December 2012 - 07:30 AM.

boozei.gif


#11 daverty

daverty

    New Member

  • Members
  • 14 posts

Posted 05 December 2012 - 02:48 PM

thanks)) I wonder with i7 3930k can comment on using 12 threads in excel 2010?

#12 Onion

Onion

    OCC Lawyer

  • Members
  • PipPipPipPipPip
  • 4202 posts
  • Gender:Male
  • Location:University of North Florida

Posted 05 December 2012 - 03:18 PM

thanks)) I wonder with i7 3930k can comment on using 12 threads in excel 2010?


I have an i7 3610 and its more than enough.

Rig 1: Q9450 @ 4.0 â–º P45-UD3R â–º GTX 275 â–º 2 x 2 G Series â–º 2x Raptor 150 â–º Truepower Quattro 1kw â–º WC'd â–º 3d Aurora 570
Rig 2: Q6700 @ 4.0 â–º 780i â–º 8800 GTS 512 â–º 4 x 1 Tracers â–º 2 x 640GB AAKS â–º Corsair 650TX â–º Temp. Stock Cooling â–º Antec 900
Rig 3: E2200 â–º P35-DS3L â–º 2900 ICEQ â–º 2 x 1GB Ballistix â–º WD 320 â–º Antec Earthwatts 380 â–º Stock Cooling â–º Ultra Armor
Rig 4: E2160 â–º P35-DS3L â–º 8400 GT â–º 2 x 1GB ballistix â–º WD 320 â–º Antec Earthwatts 430 â–º Stock Cooling â–º Custom Case
OCC - Home of the Potato Overclock