Excel speed test comparison against an FX-8350

[Vectronic]

Yeah I found it searching the thread.

 

[sequoia464]

Even my 990FX Sabertooth w/8320 pushes notably lower hdd/ssd performance with the same SSD as my Z68 and Z77 rigs.

Curious as to how big a gap you have between the AMD and Intel systems with the SSD. I'm also using an 8320 with a Sabertooth - always thought that AMD gave up about 10% or so to Intel.

Be interesting to know what it actually is.

 

[Rvenger]

Excel 2013 Pro Plus

i7-3770k @ 4.2ghz with Samsung 830 SSD and Windows 8 Pro - 29.12s

A8-5600k @ 4ghz with OCZ Agility 3 and Windows 8 Pro - 60.23s
2nd test because I was skeptical... 60.02s


E-300 @ 1.3ghz with 320gb WD 5400rpm and Windows 7 Ultimate - 181.12s

A8-4500m @ 1.9ghz with 500gb Hitachi 5400rpm and Windows 8 - 93.37

 

[Zstream]

Excel 2013 Pro Plus

i7-3770k @ 4.2ghz with Samsung 830 SSD - 29.12s


Will test A8-5600k @ 4ghz shortly

Yeah, there is a limitation somewhere. The lowest I can get is exactly 29.12s and that is with one cpu core being picked. I think something is wrong with the macro or you have the same ipc as a 3.1ghz 2400.

 

[Rvenger]

Score updated above. Interesting results indeed. My A8-5600k is as fast as an 8 core Vishera.

 

[zuffy]

Finished in 28.01s

Office Pro 2013
Windows 7 Enterprise with SP1
i7-3770K @ 4.4GHz
32GB RAM @ 1866
Samsung Pro 840 256GB

 

[Saylick]

[...]
If anyone else wants to post results I will update the chart.

I can't seem to reproduce my last result of 32.11. Must have read it wrong or something. Please change my time to 37.62 seconds. I apologize for the inconvenience.

 

[Vectronic]

Please change my time to 37.62 seconds. I apologize for the inconvenience.

That's it... scrap the whole thread, lets all start again...

5.5 seconds is a pretty big difference, I've got way more stuff going on now than I did before but I get: (3570K @ 4.2)

Previous: 26.96 (slowest of my 4 at 4.2GHz... 26.38 fastest)
Test Now: 27.03

So yeah, 5.5 is significantly off.

 

[Saylick]

That's it... scrap the whole thread, lets all start again...

5.5 seconds is a pretty big difference, I've got way more stuff going on now than I did before but I get: (3570K @ 4.2)

Previous: 26.96 (slowest of my 4 at 4.2GHz... 26.38 fastest)
Test Now: 27.03

So yeah, 5.5 is significantly off.

Hahaha, no kidding. :awe:
I was surprised when I ran the test again and saw that I wasn't getting numbers in the low 30s. Ran the test a couple more times to make sure I was seeing what I was seeing, and the result I just posted was consistent with my last couple of tests.

Lesson learned: document the result of any test you expect to publish.

 

[John Tauwhare]

Updated chart (v4).

 

[dbcooper1]

10 minutes and open office is still starting with 100% cpu load here~

Has anyone tried copying the calculation part 8 times in the spreadsheet? That would be an interesting test to see how well Excel is multithreaded and how well in comparison the processors scale imho.

edit - anyone keen to test how Libre Office handles this?

Just ran a quick test and won't run on the copy I have.

 

[WaitingForNehalem]

Updated chart (v3). Hope I've got it right this time.

The i7 920 at 52.89s is at stock speeds, 2.66GHz/2.8GHz with Turbo.

 

[SlowSpyder]

55.65 for my Thurban at 4.03/2.6GHz. I figured I would chime in just for comparrison.

 

[SPBHM]

from Idontcare:
FX-8350 2.0GHz DDR3-1866 109.02s

I tested on my 2.1GHz k8 X2 (Brisbane, slower than Windsor), using DDR2 533 and IGP, and it did it in 112s,

that's quite close

 

[Rvenger]

That's pretty bad that in many cases PD has slightly higher IPC than an old Brisbane X2.

 

[KompuKare]

Er, I'm completely blown away by the response.

Clearly there is nothing wrong with my setup as the FX-8350 results are consistent. I just chose the wrong chip. Evidently, if I want a setup that runs the sort of Excel implementations I write and use significantly faster then I have to go with Intel. Isn't hindsight wonderful. And this chart is great as it shows my options and, in particular, that with an i5-3570K, which is about the same price as an FX-8350 in UK (approx USD255) I could DOUBLE my Excel macro performance. I think that's a profound finding.

Thanks to everyone.

Edit: chart updated and posted later (page 4).

The 3570K is generally more balanced (i.e. no major surprises) but short of having started this discussion before you bought your CPU it's hard to see what else you could have done.

Because specific usage is always important and while the AT review of CPUs includes Excel doing a Monte Carlo Simulation, those results would lead you to the wrong conclusion for your usage:

That shows Piledriver doing very well indeed (while using a fair bit more power mind) but it's obviously a totally different load to yours.

 

[Vectronic]

anyone keen to test how Libre Office handles this?

Just ran a quick test and won't run on the copy I have.

LibreOffice 3.6, I get "General Error: General Input/Output Error"

Went through the settings and enabled anything that seemed related (Experiemental Features, Lowered security settings, etc), same error.

 

[sequoia464]

The 3570K is generally more balanced (i.e. no major surprises) but short of having started this discussion before you bought your CPU it's hard to see what else you could have done.

Because specific usage is always important and while the AT review of CPUs includes Excel doing a Monte Carlo Simulation, those results would lead you to the wrong conclusion for your usage:

That shows Piledriver doing very well indeed (while using a fair bit more power mind) but it's obviously a totally different load to yours.

This seems to show the same results with bulldozer as well.

http://www.techspot.com/review/452-amd-bulldozer-fx-cpus/page8.html

I'm not really into benchmarks so I don't have a clue which one is the most meaningful to my usage.

 

[Vectronic]

Here's my pointless graph...

And if you want the "data", then: *.XLSX or *.ODS

Prices are from Newegg.ca or NCIX.ca ... couldn't find reliable mobile prices.

 

[Makaveli]

I don't understand the price line i'm going to assume higher = higher price?

Why is an i7 970 more expensive than the i7 3930k ?

Paid $400 for mine about 5-6 months ago.


Ahh nm this is based off newegg prices that explains it.

 

[Vectronic]

price is in dollars (CAD), and if that's what you got it for, good deal... doing a quick check I haven't seen a new one for under $600

 

[Makaveli]

price is in dollars (CAD), and if that's what you got it for, good deal... doing a quick check I haven't seen a new one for under $600

I got it off craigslist retail box unopened just got the guy to meet me at dundas square downtown toronto.

I would never buy it off a retailer with there insane markups.

 

[imported_PowerHouse]

Here is some new data for your benchmark results from a wide variety of architectures. It is highly dependant on clock speed rather than cores which can easily be seen by the dual-core i5-680 @ 3.733GHz smoking my dual 8-core Xeon E5-2650 @ 2.40GHz system. There also seems to be a huge performance hit when oscillating between cores and caches as seen by the Xeon X3380 @ 3.166GHz losing to the Core 2 Duo T9900 @ 3.066GHz.


3.40C GHz Pentium 4 HT - 109.25 ± 0.14 s
Core - Northwood
# Cores - 1
# Threads - 2
L2 Cache - 512KB
Bus - 800MHz QDR
RAM - 3GB PC3200 DC
HD - 120GB 7.2k RPM
GPU - GeForce 7800 GS 256MB
OS - XP
Office - 2007


2 x 3.20GHz Xeon HT - 120.86 ± 0.27 s
Core - Gallatin-2M
# Cores - 2 (1 Per Chip)
# Threads - 4 (2 Per Chip)
L2 Cache - 1MB (512KB Per Chip)
Bus - 533MHz QDR
RAM - 2GB PC2100 ECC DC
HD - 36GB 10k RPM
GPU - Quadro FX 500 128MB
OS - Server 03 x32
Office - 2007


3.20GHz Pentium D 840 - 118.69 ± 0.12 s
Core - Smithfield
# Cores - 2
# Threads - 2
L2 Cache - 2x1MB
Bus - 800MHz QDR
RAM - 2GB PC2-6400 DC
HD - 250GB 7.2k RPM
GPU - GeForce 7800 GTX 256MB
OS - XP x64
Office - 2007


3.60GHz Pentium D 960 - 111.06 ± 1.22 s
Core - Presler
# Cores - 2
# Threads - 2
L2 Cache - 2x2MB
Bus - 800MHz QDR
RAM - 2GB PC2-6400 DC
HD - 250GB 7.2k RPM
GPU - GeForce 7800 GTX 256MB
OS - XP x64
Office - 2007


2.266GHz Pentium M 780 - 78.29 ± 0.07 s
Core - Dothan
# Cores - 1
# Threads - 1
L2 Cache - 2MB
Bus - 533MHz QDR
RAM - 2GB PC2-5300 DC
HD - 250GB 7.2k RPM
GPU - GeForce 8400 GS 512MB
OS - XP
Office - 2007


2.166GHz Core Duo T2600 - 86.28 ± 0.21 s
Core - Yonah
# Cores - 2
# Threads - 2
L2 Cache - 2MB
Bus - 667MHz QDR
RAM - 4GB PC2-5300 DC
HD - 100GB 7.2k RPM
GPU - GeForce Go7400 TC 64/256MB
OS - 7 x32
Office - 2007


2.333GHz Core Duo T2700 - 78.54 ± 0.18 s
Core - Yonah
# Cores - 2
# Threads - 2
L2 Cache - 2MB
Bus - 667MHz QDR
RAM - 4GB PC2-5300 DC
HD - 100GB 7.2k RPM
GPU - GeForce 8600 GTS 256MB
OS - XP
Office - 2007


1.60GHz Atom M HT N270 - 209.22 ± 0.37 s
Core - Diamondville
# Cores - 1
# Threads - 2
L2 Cache - 512KB
Bus - 533MHz QDR
RAM - 2GB PC2-5300
HD - 160GB 5.4k RPM
GPU - Intel GMA 950 128MB
OS - XP
Office - 2007


1.60GHz Atom HT 330 - 210.22 ± 0.93 s
Core - Diamondville
# Cores - 2
# Threads - 4
L2 Cache - 2x512KB
Bus - 533MHz QDR
RAM - 2GB PC2-6400 DC
HD - 500GB 7.2k RPM
GPU - ION 512MB
OS - XP
Office - 2007


1.666GHz Atom M HT N570 - 205.19 ± 0.86 s
Core - Pineview
# Cores - 2
# Threads - 4
L2 Cache - 2x512KB
Bus - 667MHz QDR
RAM - 2GB PC3-10666
HD - 64GB SSD
GPU - ION 2 512MB
OS - XP
Office - 2007


1.80GHz Atom HT D525 - 180.74 ± 0.86 s
Core - Pineview
# Cores - 2
# Threads - 4
L2 Cache - 2x512KB
Bus - 800MHz QDR
RAM - 4GB PC2-5300 DC
HD - 500GB 7.2k RPM
GPU - GeForce GT 430 1GB
OS - XP x64
Office - 2007


3.066GHz Core 2 Duo M T9900 - 43.54 ± 0.07 s
Core - Penryn
# Cores - 2
# Threads - 2
L2 Cache - 6MB
Bus - 1066MHz QDR
RAM - 8GB PC2-6400 DC
HD - 128GB SSD
GPU - Quadro NVS 160M 256MB
OS - 7 x64
Office - 2010 x64


3.50GHz Core 2 Duo E8700 - 36.62 ± 0.53 s
Core - Wolfdale
# Cores - 2
# Threads - 2
L2 Cache - 6MB
Bus - 1333MHz QDR
RAM - 4GB PC2-6400 DC
HD - 320GB 7.2k RPM
GPU - GeForce 9800 GTX 512MB
OS - 7 x64
Office - 2007


2.666GHz Xeon X3230 - 71.08 ± 0.29 s
Core - Kentsfield
# Cores - 4
# Threads - 4
L2 Cache - 2x4MB
Bus - 1066MHz QDR
RAM - 8GB PC2-5300 DC
HD - 1TB 5.4k RPM
GPU - Quadro NVS 295 256MB
OS - Server 08 R2 x64
Office - 2007


3.166GHz Xeon X3380 - 63.70 ± 0.03 s
Core - Yorkfield
# Cores - 4
# Threads - 4
L2 Cache - 2x6MB
Bus - 1333MHz QDR
RAM - 16GB PC3-10666 DC
HD - 60GB SSD
GPU - Quadro FX 580 512MB
OS - 7 x64
Office - 2010 x64


3.60GHz Core i5-680 - 38.37 ± 0.12 s
Core - Clarkdale
Turbo - 3.733GHz
# Cores - 2
# Threads - 4
L2 Cache - 2x256KB
L3 Cache - 4MB
Bus - 1250MHz DMI
RAM - 12GB PC3-12800 DC
HD - 64GB SSD
GPU - GeForce GTX 460 1GB + GeForce GT 430 1GB
OS - 7 x64
Office - 2007


3.333GHz Core i7-980X EE - 39.48 ± 0.11 s
Core - Gulftown
Turbo - 3.466GHz
# Cores - 6
# Threads - 12
L2 Cache - 6x256KB
L3 Cache - 12MB
Bus - 3200MHz QPI
RAM - 24GB PC3-12800 DC
HD - 64GB SSD
GPU - 2xGeForce GTX 480 1.5GB SLi + GeForce GTS 450 1GB
OS - 7 x64
Office - 2007


2 x 2.0GHz Xeon E5-2650 - 78.93 ± 0.56 s
Core - Sandy Bridge - EP
Turbo - 2.40GHz
# Cores - 16 (8 Per Chip)
# Threads - 32 (16 Per Chip)
L2 Cache - 16x256KB (8x256KB Per Chip)
L3 Cache - 40MB (20MB Per Chip)
Bus - 2x4000MHz QPI
RAM - 32GB PC3-12800 ECC QC
HD - 2x64GB SSD in RAID0
GPU - Quadro 600 1GB
OS - 7 x64
Office - 2010 x64

 

[el aye]

Windows 8 64bit (obviously )
Office 2013 preview
3770k @ stock
2x4gb 9-9-9-24
256gb crucial M4

106.34, last was 35.45.

I didn't restart/open or anything, had chrome, winamp, remote desktop, utorrent, foxit reader open.

 

[Tsavo]

i5-750@ 3.2 GHz. Office 2013: 36.70